How to use mysql for excel jobs

Here is a list of zip files on a US Govt website. You must write a Python p...zip files on a US Govt website. You must write a Python program that uses a network library to download each zip file on this site, then find each .csv file in the zip archive, and copy each .csv file in each zip archive to a hard drive directory on the local windows machine. The directory will be "C:/MedicareDownloadFiles". The files cover the years 2017 to 2024. You may not hardcode file names ... you must extract the filenames from the above https URL. The fee for this will be $30. You must have it done within 60 minutes. Thanks for participating!

I'm in need of a meticulous professional to clean a mixed set of data contained in an Excel file. I am specifically struggling with duplicate values and missing entries. To effectively accomplish this: - You should possess excellent skills in data analysis and data management. - Previous experience with Excel-based data cleaning is preferable. - Profound knowledge of dealing with duplicate entries and filling in missing data is required. - A keen eye for detail and ability to spot and correct errors is essential. In summary, my ideal candidate would be someone with significant experience in data cleaning, particularly with mixed data in Excel files. It would be a bonus if you've previously resolved issues related to du...

I need an adept data entry freelancer to skillfully convert text data from various online sources into an organized Excel spreadsheet. You'll reap the benefits of this project if you're detail-orientated, familiar with navigating online sources, and proficient in Excel. - The project involves researching, collecting and collating text data from specific online sources - The final deliverable needs to be an Excel spreadsheet, with data arranged legibly - Demonstrable experience in data entry jobs would be ideal - A keen eye for detail is paramount as exactness is key for this data entry task - You should be comfortable working with Excel and have proficiency in using all its features. The testimonials of your past clients...

I'm looking for a skilled developer to migrate our Java-based desktop application onto the AWS cloud. The project involves: - Hosting the existing Java-based desktop application on an AWS cloud instance. - Implementing a multi-user access system. - Integrating a MySQL database component. - Developing a Python-based web interface for users to change settings. The ideal candidate should have: - Proficiency in Java, Python, and MySQL. - Prior experience with cloud hosting, particularly on AWS. - Knowledge of user access control systems, particularly Discretionary Access Control. - A good understanding of desktop-to-cloud migration. - Strong communication skills and attention to detail. We need a developer who can take a Java ba...

I need a proficient excel expert to help me with a data entry project. The data involves simply names, emails, and phone numbers. It will be a table with 100-500 entries, so proficiency in data entry and Excel is crucial. Key Requirements: - Accurate Data Entry: The job is primarily about accurately transferring names, emails, and phone numbers from a document to an Excel sheet. - Excel Proficiency: Knowledge of Excel functions is a plus, though not specifically required. You should be comfortable working with a table of this size.

I'm in need of comprehensive and detailed Australian databases. Specifically: - Medical databases, with a key focus on medical specialties. Medical databases should preferably contain reliable and relevant information about the different br...different branches of medical specialties across Australia. - Business databases, encompassing detailed company profiles inclusive of industry category, phone, fax, email, physical address, etc. I'd appreciate getting more data, as in-depth as possible. The databases should be pre-existing or scraped and must be provided in Excel format, or .BAK for MSSQL server. Professionals equipped in big data collection, scrapping, and data analysis would be the most suited for this project. Knowledge about Australian medical and...

I need a freelancer to assist with accurate and efficient data entry into Microsoft Excel. The data is in digital format and involves numeric values. Key Requirements: - Enter numeric data into Microsoft Excel from provided digital sources - Ensure data is accurately transcribed - Maintain confidentiality of the data Ideal Freelancer: - Proficient in Microsoft Excel - Strong attention to detail - Previous experience in data entry, preferably with numeric data - Ability to maintain data integrity and confidentiality. Note: Please ensure you have a copy of Microsoft Excel for this job.

I am in need of a professional who can help provide insights into a dataset using Excel's pivot charts, tables, and dashboard. The area of the data is unspecified as of now, but a strong candidate would be adaptable and skilled across domains. Key responsibilities will include: - Data Visualization - Creating Pivot Charts - Building Tables - Preparing a Dashboard Note: This project is basic-level work and my budget is 10 not more than that I already checked price comparisons with different freelancing platforms. if anyone works in that price range only the person make bids does not waste time.

I'm looking for a professional writer to draft a comprehensive, easy-to-follow guide on how to "l7as tizi" for personal use. The final output must be a text-only document. Key requirements include: - Comprehensive: The guide should cover all aspects of "l7as tizi" that are crucial for a beginner to know. - Easy-to-Follow: It should be written in a clear, concise, and engaging manner. Avoid using technical jargon or overly complex language. - Personal Use: The guide is intended for my personal use, so it should be tailored to suit my needs and knowledge level. Ideal skills and experience for this project include: - Proven experience in technical writing or crea...

I am looking for a freelancer who is proficient in data entry and familiar with Excel to assist in the digitization of a 276-page vintage parts manual. Your task would be to: - Accurately copy the information from pdf to Excel. This includes part numbers, the description of parts, and all other columns present in the original tables in the document. - Organize the spreadsheet such that each section of the document is represented by a separate worksheet. No specific data validation rules or cell formatting are required, but the data must be accurate and searchable in Excel. This job requires someone with a keen eye for detail and a good understanding of Microsoft Excel. Prior experience in similar data entry tasks would be a ...

I'm looking for a talented graphic designer who can create a minimalist, illustrative Instagram graphic for my latest blog post titled "How to Get Your Business Phone Registered to Avoid Spam Labels". Key Requirements: - Minimalistic Design: The graphic should be clean, simple, and in line with a minimalistic aesthetic. - Illustrative Style: I'm looking for an illustration rather than a photographic or typographic design. - Business/Communication Elements: Incorporating telephone or mobile icons into the design is a must. The design should subtly communicate the main theme of the blog post without being overly busy or cluttered. The winner will be asked to provide a Canva template, so please design your samples in Canv...

I'm in need of a vintage logo to represent my brand. This logo will be primarily used online, on my website and social media platforms. Requirements: - The logo should have a vintage aesthetic. - It should be simple yet distinctive, conveying the essence of my brand. - The design must be suitable for digital platforms, ensuring clear visibility and recognition. Ideal skills and experience: - Proven experience in designing vintage logos, with a portfolio to demonstrate this. - A good understanding of digital design, ensuring the logo is optimized for online use. - Creative flair and the ability to translate my brand essence into a visual representation. - Ability to incorporate the specified color scheme into the design, while also o...

Looking for an expert who can import data from 1-10 Excel files into Google Earth. Key tasks: - Convert location data from Excel into a format readable by Google Earth (preferred Google Eath Pro Tours for Commercial Real Estate Properties - Ensure perfect alignment of data with the geographical locations - Grouping and categorizing the locations as per the content of each column within the Excel files Ideal candidate: - Proven experience with data visualization tools, particularly Google Earth and Google Earth Pro tours for Commercial Real Estate Properties -- High proficiency in handling Excel files and data - Understanding of Geographical Information Systems would be a bonus.

I have a MySQL database that needs exporting. All user data, product data, and transaction data are required to be exported. Key Tasks: - Export all MySQL user data - Export all MySQL product data - Export all MySQL transaction data The final export should be in Excel format. This is not a job for beginners. You should have prior extensive experience with large database exports and MySQL. It would be a big plus if you're familiar with handling sensitive user and transaction data. As the project involves substantial data, confidentiality and data security are non-negotiable. Please include samples of similar database exporting projects you've completed.

I am in need of an Excel spreadsheet expert to create an Excel template using a PDF sample. Without being specific about the details, the ideal candidate should have excellent skills in extracting data from PDFs and well-versed in designing Excel templates. Here's what I'm looking for: Mactacquickshipsellsheet pdf converted into an excel sheet example of what I would like as template.

...currently in an Excel spreadsheet format, is used to assist employers in navigating our regional workforce programs and partners. To enhance its utility in responding promptly to RFIs (Request for Information), we aim to reinforce this database tool. Our objectives include implementing organizational features with multiple tags for efficient categorization and establishing a user-friendly update and maintenance system that does not require consultant engagement. 2. Objectives: i. Objective 1: Enhance Database Organization 1. Introduce multiple tags for easier navigation and filtering of information 2. Implement organizational features to categorize workforce partners efficiently ii. Objective 2: Streamline Update and Mainte...

I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel

Hi Dears, I am looking Laravel Expert on hourly basis. He should be able to improve the quality of code. Also, he should have experience to improve the performance of Laravel website. While bidding; kindly mention: 1. Your per hour rate 2. Previous Laravel Projects 3. Previous Laravel Projects detail where you improved Laravel Project/API Performance 4. Previous projects where you improved MYSQL performance for laravel

...and Enhance PHP/Mysql/Ajax Team Organisation Tool to Flutter Web App **Project Description:** We are seeking a skilled developer to assist in migrating an existing PHP/Mysql/Ajax Team Organisation Tool to Flutter, with the aim of releasing it as a web application. The primary objectives of this project include implementing a robust user authentication system, enhancing work organisation capabilities through calendar events, introducing user profile management for self-updating special user data, incorporating team management by assigning role models such as Teammember, Teamorganiser, Controller, Boss, and Admin, adding communication options to send team emails, chats, SMS, and WhatsApp messages, including timestamp functions for e...

I am looking for a freelancer to assist me with a data entry project. The task involves typing data from handwritten documents into a digital format. The data must be formatted in a specific way, so attention to detail is important. Skills and Experience: - Proficient typing skills and accuracy - Experience with data entry and handling handwritten documents - Familiarity with formatting data according to specific guidelines - Ability to work efficiently and meet deadlines The project includes 1-10 pages or documents that need to be entered. If you are interested in this project, please provide examples of previous data entry work and explain your experience with formatting data.

I need an experienced programmer to develop a custom-built website for a Loadshedding scheduler. The project has a high priority and needs to be completed as soon as possible Before 20 May 2024 Basics Summary: The Load shedding Scheduler System is a comprehensive solution designed to address the challenges associated with managing and implementing load shedding in an efficient and organized manner. As electricity supply continues to be a critical issue in Zimbabwe, it is imperative to have a system in place that can effectively manage the limited supply of electricity during periods of high demand or supply constraints. The Load shedding Scheduler System aims to provide utilities, grid operators, and other stakeholders with a powerful...

I'm looking for a talented Excel programmer to build an Excel tool tailored for my business' quotation procedures. Notably, this tool must provide these key functions: - Automatic Price Calculation - Customized Quotation Template Design I already have a specific design in mind for the quotation template and would require the freelancer to implement my design concept accurately. A potential candidate should have considerable Excel programming skills coupled with a solid understanding of quote creation processes. A sense of accuracy, creativity, and robust attention to detail would be beneficial for this task. Outputs should be precise and user-friendly, ultimately contributing to streamlining our curren...

I'm looking for a talented Excel programmer to build an Excel tool tailored for my business' quotation procedures. Notably, this tool must provide these key functions: - Automatic Price Calculation - Customized Quotation Template Design I already have a specific design in mind for the quotation template and would require the freelancer to implement my design concept accurately. A potential candidate should have considerable Excel programming skills coupled with a solid understanding of quote creation processes. A sense of accuracy, creativity, and robust attention to detail would be beneficial for this task. Outputs should be precise and user-friendly, ultimately contributing to streamlining our curren...

I'm looking for a skilled Excel expert who can help with adjusting product pricing, adding products, creating formulas, adding products etc via excel, .csv. This is a ongoing project. If you can upload .csv to wordpress is a big plus!! KEY REQUIREMENTS: - I specifically need assistance with spreadsheet automation. - The work required is at a basic level, focusing on formulas and functions. - Implement automation for the designated tasks. - Ensure that the automation is robust and well-documented. SKILLS & EXPERIENCE: - Proficiency in Excel is a must. - Experience in basic spreadsheet automation. - Strong understanding of formulas and functions. - Attention to detail and commitment to quality.

I'm looking to develop an Artificial Intelligence (AI) charges calculator for Excel. The core functionalities include: - Automatic calculation of fixed charges - User-friendly interface for effortless interaction and data management. - Reliable data input validation to ensure accuracy and consistency. - Calculate Profit based on fixed charges and earning from subscription The calculator will primarily handle financial data. Prospective freelancers should have a strong grip on Excel, data validation, and UI/UX design—along with financial acumen for effective calculator development. A successful execution ideally enhances efficiency and aids with precise financial management.

I'm in need of a meticulous and reliable freelancer to assist with online data entry tasks. You'll be required to input data into spreadsheets using platforms like Excel or Google Sheets. The data will be provided to you in digital formats, such as PDFs, Word documents, or scanned images. Key Requirements: - Proficiency in online data entry - Experience working with spreadsheets (Excel, Google Sheets) - Ability to maintain accuracy and attention to detail - Familiarity with handling data in digital formats Ideal Skills: - Previous experience with similar data entry projects - Proficiency in using Excel or Google Sheets - Background in spreadsheet management - Strong attention to detail and accuracy A successful c...

I would like a custom sales order created in Excel for about 50 different items. Key Requirements: - Each item's entry in the order should include item name, quantity, and description. - The items should be sorted by their ship date. - The system should incorporate a feature to apply a total discount on the order. Ideal Skills and Experience: - Advanced Excel Skills with the ability to create customized sales orders - Proven experience in developing financial/ordering spreadsheets - Excellent understanding of sales order process and discount mechanisms.

I'm looking for an experienced PostgreSQL professional capable of analyzing and generating reports from sales data. Key Responsibilities: -Analyzing sales data stored in PostgreSQL -Generating insightful reports based on analysis Ideal candidate should excel in PostgreSQL and possess strong data analysis skills. Previous experience with sales data is an advantage, however, specific functionalities required for the analysis have been left open-ended for your expertise to fill. Please outline in your proposal any relevant experience and your approach to this task.

I require a Linux WHM expert to assist with a critical data recovery issue. Specifically. Suddenly our mysql stop working. We had a dump of data but we need to solve the mysql issue or reinstall it (we can provide WHM and root access), and upload the data dump. Key Responsibilities: - Troubleshoot and resolve the MySQL data recovery issue. - Ensure the retrieved data is accurate and complete. We would like to know why this happends, to avoid it happends in future, by checking server logs. Ideal Skills and Experience: - Extensive experience with Linux WHM. - Proven track record in MySQL data recovery. - Understanding of data security and privacy best practices. - Prompt and effective communicator.

I need an experienced Shopify app developer to create a specialized app for me. This app should have the following functionalities: 1. Select the Order Date and time slot in the local delivery 2. Select the store pickup address for order 3. Very Pincode for local develiry is available or not this pincode? Require Skill - Shopify Order Edit - Shopify Webhook - REST API - Node.js and React.js - MySQL and Postgres - Javascript, HTML, CSS, Jquery A critical feature I require is the ability to gather specific information with each order. This should include: - The ability to select an order date via a calendar date picker. - Collect and record this order date. Ideal candidates for this project should be experienced...

...professional to help migrate my existing Grafana 8 alerts to Grafana 10. Your proposal should include detailed project plans and timelines for completing the following tasks: - Alert Configuration: This includes setting up and configuring alerts based on specific metrics, thresholds and conditions. - Alert Rule Mapping: You'll be responsible for ensuring that all alert rules are correctly mapped from Grafana 8 to Grafana 10. - Alert Notifications: Set up the necessary alert notifications to ensure they are received by the relevant parties promptly and efficiently. Ideal candidates should have: - Extensive experience with Grafana and its alerting system - A proven track record of successful alert migration projects - Excellent communicatio...

If C4 and D4 have no entries, make E4 blank. If C4 and D4 have values, perform C4/D4 in E4.

..., and its MySQL database on Cloudways. I'm looking for a professional to transfer both the frontend and backend to DigitalOcean. I need help in setting up the server and transferring the database as well. Key Project Requirements: - Transfer existing Angular project from to DigitalOcean - Move existing MySQL database hosted on Cloudways to DigitalOcean - Set up the server on DigitalOcean for hosting the Angular project - Transfer and configure the MySQL database on DigitalOcean - Ensure the migration process is smooth and without downtime - No manual deployment used, so expertise in this area is crucial Ideal Freelancer: - Proficient in Angular for frontend transfer - Experienced with setup and configuration ...

I'm in need of a skilled Shopify App Developer to create an innovative, new application that specifically includes an 'Order Date' feature. Key Function: - The primary function of this app needs to be the ability to select an order date. Additional Requirements: - The app must be easy to use and intuitive. - Requires seamless integration with my Shopify store. Ideal Skills & Experience: - Shopify App Development - UI/UX Design - Knowledge of eCommerce and order processing. - Node.js and React.js Expertise - Mysql and Postgres - Javascript, HTML, CSS, Jquery Looking forward to discussing potential approaches and ideas.

Custom Task Management System By ARABIC Language RTL , From Scratch SDLC To Deploy. I have Some Screens to understand Most Requirement> Requirement: PHP Laravel 11 MySQL Jquery CSS Bootstrap All Must be the last versions.

I need an expert in data formatting to help me clean and organize a large Excel file. The file currently contains unformatted data that needs to be segmented into distinct columns. I need the data separated into the following categories: - First Name - Last Name - Company Name - Position The ideal candidate for this job should have: - Proficiency in working with large Excel files - Experience in data segregation and formatting - Attention to detail to ensure data accuracy - Ability to follow instructions and deliver in an Excel file format Given that there are more than 500 entries in the file, efficiency and accuracy are key. The final deliverable should be an Excel file with the formatted data ready for u...

I'm seeking an expert who can assist with developing a comprehensive data analysis and automation solution within SMART sheet and Excel. Key Responsibilities: - Develop custom dashboards for financial analysis within Excel. - Automate data management processes within both SMART sheet and Excel. - Integrate the dashboards into SMART sheet for seamless use. Ideal Skills & Experience: - Strong expertise in SMART sheet and Excel, including VBA. - Proven track record of developing dashboards for financial analysis. - Ability to automate data management processes. - Excellent communication skills. Please provide examples of similar projects you've completed.

We have a device which is transmitting using JT808 , we want to capture that transmission and write in a mysql db. We will not provide documentation on JT808. Do NOT bid if you do not have experience with this protocol. If you have worked before with this protocol, please give a brief explanation of what you did.

I need an artist to create 2-5 caricatures for personal use. The style should be exaggerated, verging on cartoonish but maintaining some realism. Applicants should have experience in caricature design and a portfolio showcasing their skills. Attention to detail and ability to capture likeness in exaggerated style are crucial. Some funnyness included in their features would be ideal, but not too too much, i want it to still be them, but hopefully them looking a little funny. The backgrounds can be altered to anything, its mostly a focus on the girls and the dogs

I need to scrape specific information from a website for all search results with a particular key. The data should include Name, Address, Phone number, Email, Company name, and Job title. This data should be organized into an Excel file, with each category of information in separate columns. Ideal Skills: - Proficient in Excel VBA - Experience in web scraping - Understanding of VPN usage to access region restricted sites Please note that the website will only work with a USA VPN.

I am looking for a professional lead generation expert with experience in the real estate industry who can help me to collect real estate leads within the Greater Toronto Area. In this role, you'll be responsible for collecting leads of FSBO (For Sale by Owner), expired listings, and "Rent by Owners." I need - Collection of leads' name and contact information and collection of property address and specifics in excel sheet. The ideal candidate for this role should have: - Proven experience in real estate lead generation - Strong understanding of the real estate industry and the different types of leads within it - The ability to work independently and as part of a team.

...looking for a professional who can create an Excel sheet that will help me manage my product list and other essential production data. The excel file requires: - Filtering and Sorting Capabilities: The sheet should be able to sort and filter data easily. - Inventory Tracking: It is crucial that the sheet can track inventory levels to prevent overstocking or shortages. - Report Generation: The ability to generate reports will help me keep track of my production and make informed decisions. I need the excel file to have less than 10 columns, as I believe this will keep the sheet concise and easy to manage. The level of automation I am looking for is manual data entry with some formulas. This will help reduce manual wor...

webscraping cdiscount using python and export it into excel

I am looking for a professional lead generation expert with experience in the real estate industry who can help me to collect real estate leads within the Greater Toronto Area. In this role, you'll be responsible for collecting leads of FSBO (For Sale by Owner), expired listings, and "Rent by Owners." I need - Collection of leads' name and contact information and collection of property address and specifics in excel sheet. The ideal candidate for this role should have: - Proven experience in real estate lead generation - Strong understanding of the real estate industry and the different types of leads within it - The ability to work independently and as part of a team.

Do you understand instructions when given and can do tasks on excel? Are you a beginner? Are you free right now to work with me and read the data in pdf so I can write it on excel? If your answer if yes to all of that question bid by asking any question regarding this post to make your bid high quality. NEEDS TO BE DONE TODAY. WILL TAKE 3-4 HOURS APPROXIMATELY. (just an approximation)

I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel

I want to use Microsoft power automate for a simple RPA on my desktop browser. I want to repeatedly run a search on 6 websites which are clerk of court websites because I am an attorney trying to reach prospective clients who have recently been sued. My goal is to launch and sustain a mail merge campaign to these prospective clients. So I need to automate a regularly occuring search for the most recent lawsuits that are filed on these clerks' websites and extract the defendants' names, mailing addresses and case numbers. The only problem is that the addresses are not found neatly on the web pages of the search results, but they must be extracted from individual PDF documents by going into each individual case docket a...

I'm seeking an expert Android app developer for the creation of a mobile application focused on Bluetooth Beacon (BT Beacon) functionality. Your primary task will involve: - Designing and developing an Android app from scratch. - Implementing BT Beacon technology impeccably into the app's functionality. Ideal candidates for this project should have: - Deep knowledge and proven experience in Android app development. - Previous experience working with BT Beacon technology. - Strong understanding of user-interface design for mobile devices. - Ability to communicate complex technical issues succinctly and clearly. I look forward to your imaginative solutions in incorporating Bluetooth Beacon effectively into our app!

...license keys for an Excel template product. Key responsibilities are: * Design and develop a License Key Generator using Python. * Create it to have the flexibility of generating unique license keys, verifying these keys, and, if necessary, deactivating them. * Design and implement an API that allows the integration of generated license keys with my existing Excel templates. * Each license key must validate properly in Excel Template PRO. Besides, your work must include: * Order form * Implementing a MySQL database to store all generated license keys. * Building a response system that displays license keys on a 'Thank You' page after purchase. * Setting up an automated email system that sends emails to the customers wi...

An experienced web designer to creaye and design my adult dating site. I bought the site a couple years ago but never did anything with it. I’m not knowledgeable in this area so I can use a lot of help More details: Is this project for business or personal use? For starting a new enterprise What information should successful freelancers include in their application? Detailed project proposals How soon do you need your project completed? ASAP