Mysql export to excel with headers jobs

I am looking for a freelancer to assist with cleaning and analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools...

Hello, I need complet the Amazon categories catalogue excel in french

I am an exporter in need of a proactive sourcing agent to help me establish connections with potential buyers in the United States, European Union, and UAE. My focus lies in the exportation of: - Basmati rice (1121) - Guar gum powder Both products are under the category of less than 100 metric tons export quantity. The responsibilities of the agent should include: - Identification and procurement of potential buyers - Market research regarding the demand for these products - Effective communication with buyers regarding product specifications and negotiation of pricing The ideal candidate should have: - Prior experience in sourcing and exporting goods, ideally within the specified regions. - Excellent communication and negotiation skills - An extensive net...

I'm in need of medium-sized corrugated boxes for exporting products internationally. These boxes are intended for standard shipping purposes. Key Requirements: - Medium Size: The boxes should be within the 18-36 inches range. - Durability: The boxes must be suitable for standard shipping, ensuring that th...18-36 inches range. - Durability: The boxes must be suitable for standard shipping, ensuring that they can endure the typical handling and transportation processes involved in international shipping. Ideal Skills: - Experience in manufacturing or sourcing medium-sized corrugated boxes. - Knowledge of international shipping standards and requirements. - Attention to detail to ensure box quality and durability. - Effective communication to discuss specification...

...Flutter and PHP developer to create a three-platform application- Android, iOS, Web. The crux of the application is to serve a robust platform for job posting and searching. Its primary audience is families and domestic helpers. Key Features: - User authentication - Push notifications - Payment integration - Job posting and Employee Profile creation - In-app chat and Whatsapp integration - Bookmarking and job/profile sharing functionalities - Premium membership that enables additional contact features - MySQL database schema design - Integrated Google Admob Advertisement Backend Work: - You'll develop a RESTful API with PHP+MySQL to support app functionalities. The ideal candidate will have significant experience in Flutter Developmen...

I'm seeking a skilled individual who ca...Communication: The chosen candidate should have a sound understanding of MQTT (Message Queuing Telemetry Transport) and how to use it to integrate various IoT devices. - Data Collection & Analytics: Proficiency in handling data streams from these devices, ensuring seamless collection, storage, and basic analytics. - User Interface & Experience: Creating a clear, intuitive UI to monitor and interact with the IoT data is essential. Ideal Skills: - Proficient in Java, MySQL, and Tomcat - Experience with MQTT and IoT SCADA is a plus - Strong background in designing user-friendly interfaces - Able to deliver quality work within a tight timeframe Go through the PDF file attached to un...

I'm in need of a freelancer with a high level of proficiency in Microsoft Excel to use conditional formatting over different tabs to help visualize duplications in large sets of numerical data. Ideally, you should not only be skilled in Excel, but also possess a keen eye for patterns and detail. Your job will encompass: - Applying conditional formatting across multiple tabs. - Highlighting duplications in numerical data. - Ensuring easy readability and understanding of the data presented. An understanding of data visualisation techniques would give you a competitive edge for this project. This task will require a close attention to detail and a strong understanding of Excel's conditional formatting tools.

...skilled developer to create a customized inventory management app using Google AppSheet and MySQL. The app will cater to a user base of less than 50, but it needs to be designed and optimized for scalable growth. It should be intuitive, easy to use, and have a professional interface. Key features that need to be incorporated into the app include: - Real-time inventory tracking - Sales and purchase order management - Product barcode scanning As the app will be handling crucial data for my business, security and reliability are of utmost importance. The developer should have experience in creating and integrating secure databases, as well as a track record of building robust, scalable applications. The successful freelancer should have: - Pro...

I have a small dataset of less than 1,000 rows that requires both data cleaning and formatting. Additionally, I need assistance with data analysis and visualization. This is a one-time project, and I am looking for a skilled individual to handle this for me. Ideal Skills and Experience for this project: - Proficiency in Excel is a must. - Experience with data cleaning and formatting. - Ability to perform data analysis and create visualizations. - Attention to detail and an eye for accuracy.

I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.

I need a skilled Excel professional to create a comprehensive spreadsheet for financial tracking. - Data Type: The primary focus will be on financial data, so the spreadsheet must expertly handle these calculations and entries. - Data Organization: The data should be organized by project. This includes clear separation of financial data under different project heads, ensuring a clean and easily navigable interface. - Functionality: I am looking for an Excel expert to incorporate some key features to help make the data easier to understand, like conditional formatting. Ideal Skills: - Proficient in Excel, particularly in managing financial data - Experience in creating user-friendly and logically structured spreadsheets - Understanding of c...

I want to make a Incentive structure in the attached excel. I am paying incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the value that I am putting in the cells of "m" and "n". You have to correct the formula I have given in the sample or you can make a new formula

I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

I'm in need of a Virtual Admin Assistant to help me manage my daily work. Our dailly working time is : 10 - 7pm. We are in retail industry, dealing with bathroom & kitchen products. I need freelancers who are based in Malaysia and based in City if Kuala Lumpur and Town of Cheras Key Responsibilities: - Data Entry & Report Writing: You would be handling data entry tasks & writing report and (you only need to direct report to me so simple communication) - Task Management: Utilizing software such as Trello, or Microsoft Excel to keep track of tasks and deadlines. Ideal Skills and Experience: - Experience as a virtual assistant or in administrative roles is a huge plus. -Experience in wiritng report will be added advant...

...developer to create an admin dashboard for an e-commerce site. This will involve managing callback values for various e-commerce events such as sales, cancellations, and renewals. These values need to be stored in a MySQL database. Additionally, email notifications need to be sent to both the admin and users, triggered by specific e-commerce events. Key Requirements: - Develop an admin dashboard for managing callback values - Utilize a MySQL database for storing the callback values - Implement a system for automated email notifications upon e-commerce event triggers Skills & Experience: - Strong proficiency in MySQL - Extensive experience in e-commerce site development - Proficient in creating admin dashboards - Skilled in implemen...

I am lookin...effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing comprehensive plans that can be used for obtaining necessary permits. Your understanding of local building codes and regulations will significantly contribute to the project's success. - Ensuring these detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residential construction projects is a must. Please keep in mind the crucial role these drawings play in the project's execution and the importance of accuracy and attention to detail. If you excel at ...

I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: - Data Cleaning & Preparation: This includes cleansing the data from any incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. Proficiency in using MS Office is al...

I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and efficient data arrangement...

I need a skilled freelancer to install and configure Dolibarr for our company's productive site on our intranet. Here are the specifics: IA definition: (below you can see my own) - We need the inventory management, manufacturing, service contracts and human resources management features to be properly configured. - The system must be set up for 1-10 users to access on our intranet. Customizations and integrations: - We may require custom reports or dashboards, although the specifics for these are not yet entirely defined. - There may be other custom integrations needed as the project progresses. Ideal Skills and Experience: - Proficient in Dolibarr installation and configuration - Previous experience in setting up Dolibarr for small businesses - ...

Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!

i have one php script which used to load in a few seconds now takes 4 minutes not sure why it suddenly lags need optimised - the mysql query hittin some bottleneck somewhere by looks of it

I'm looking for an experienced full-stack developer to build a custom admin dashboard for a Flutter app backed by Firebase. The dashboard should have a clean, minimalist design and robust functionality to manage the platform. Core Features: - Firebase Integration - Comprehensive Data Visualization - Content Management (Articles, Quizzes, Categories) - Feedback Management - Notification System (In-App, Push) Other Key Features: - Secure Admin Authentication - User Management (Roles, Permissions) - Content Packaging & Distribution - Content Localization - Import & Export Functionality - Settings & Integrations - Security & Compliance - Performance Monitoring & Optimization The ideal candidate should have: - Proven experience developing adm...

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

Hi there. I'm running XCode 15.3 and I need a few pages done with simple, clean storyboards and View Controllers. I use Alamo Fire and Swift, so if you could use that to pull my data via my API links and display it in several pages that would be great. Categories > Collections > Items > Item Details You select one and it shows a list - Item Details is one record from a MySQL db I need each selected item to be a variable in the code of the ViewController so if I use the print function, I can see it at the bottom of XCode. I'll give you the 3 or 4 API webservice links. I can give you a super simple app to put it in too...

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

Objective: Our company aims to automate its logistics process to improve efficiency and reduce manual workload. We are looking for a freelancer with expertise in automation to develop a system that streamlines the process from transport request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook ...

...experienced developer to provide long-term maintenance for my e-commerce website. The ecommerce is up and running and fully operational and we need a FULL STACK developer that can code in ALL AREAS of the webapp. - Frontend: React (JavaScript) - Backend: Node.js - Services: Python - Database: MySQL RESPONSIBILITIES: - Integration of new B2B APIs - New payment gateway integration - - Implementation of bug fixes and performance improvements. - Regular software updates and security patches. - Feature additions and enhancements. Skills and Experience: - Proven experience in maintaining e-commerce solutions. - Proficiency in React, Node.js, Python, and MySQL. - Strong problem-solving skills. - Excellent understanding of software best practices and design patterns. - ...

Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.

I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.

...lookout for a YouTube SEO specialist to boost the visibility and ranking of our high-quality content on the platform. Key Responsibilities: - Implement advanced SEO techniques to improve the ranking of our videos in search results. - Conduct comprehensive keyword research and optimize video content accordingly. - Enhance the appeal and engagement of our videos through creative thumbnail and title optimization. - Dive into analytics and user engagement data to constantly refine and improve our strategies. Ideal Candidate: - Proven experience in YouTube SEO, with a track record of improving video ranking and visibility. - In-depth knowledge of keyword research tools and SEO optimization techniques specific to YouTube. - Proficiency in utilizing analyti...

create 10 spreads (20 pages), an A5 book or magazine for Porsche Develop full research about the topic and writing the content to design an interactive digital artwork. Tasks to be covered: Task 1: Research your selection and analyze all needed aspects. Also, Mood Board (your visual research) + Layout plan (Dividers and interactive buttons) as we discussed in the class. Task 2: Design a suitable layout for your selected topic. Use Table, margins, columns, master pages, and paragraph/character style. Task 3: Submit InDesign file (Packaged) and export an interactive digital file (PDF). Task 4: A Presentation on screen, that discusses the project’s concept and process.

create 10 spreads (20 pages), an A5 book or magazine for Porsche Develop full research about the topic and writing the content to design an interactive digital artwork. Tasks to be covered: Task 1: Research your selection and analyze all needed aspects. Also, Mood Board (your visual research) + Layout plan (Dividers and interactive buttons) as we discussed in the class. Task 2: Design a suitable layout for your selected topic. Use Table, margins, columns, master pages, and paragraph/character style. Task 3: Submit InDesign file (Packaged) and export an interactive digital file (PDF). Task 4: A Presentation on screen, that discusses the project’s concept and process.

Beginner level freealancer to create an mcq list for moodle quiz website in Aiken formatting. Aiken format I am following is Frusemide tablets 40mg tablets are in stock. How many would you give for a dose of 120mg? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: A Sulphasalazine tablets 500mg are on hand. The dosage required is 2g. How many tablets are required? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: C So can you create options like a teacher, you don't need to know a lot about the topics. If you are wondering, It is nursing mcq (multiple choice questions). I have the questions and answers ready in a pdf. The first 428 questions are ready. Once the Question and Answer pdf is given, In the format mentioned above, just add another 3 options in Google sheet, a...

We need an experienced Magento developer to assist with updating third-party extensions when conflicts arise due to newer php/mysql versions. Timeline: Start on the first project on 20th May using remote desktop tools like UltraViewer or AnyDesk for real-time collaboration. Bidders must be highly proficient in Magento 2.4x.

...application that can carefully monitor a MySQL database on my Windows system. The app should be able to perform the following functions: - **Monitoring MySQL Database**: The application should constantly monitor my MySQL database and detect when a new record is created. - **WYSIWYG Template Management**: There should be a feature that allows me to manage various WYSIWYG templates. These templates would be used to generate dynamic PDFs based on the new records in the database. - **PDF Generation**: Upon detecting a new record, the application should automatically generate a PDF based on a selected WYSIWYG template. Naming convention based on filed in processing record. Option Password added to pdf. I would like the application t...

I'm in search of a diligent and detail-oriented individual to assist me on a part-time basis with data entry tasks mainly in the finance sector. Key Responsibilities: - Data Entry: You will be responsible for inputting and maintaining various financial data into spreadsheets and databases. - Accuracy and Attention to Detail: Ensuring the provided data is accurately entered, including cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related data entry is advantageous but not mandatory. - Strong attention to detail and a...

We are in the middle of migrating Django to a new server. - Both servers run Ubuntu 20.04, postgres 12, python2.7 - The Django Project is already transferred over - Nginx has been configured - Postgresql has been setup Our struggle is to get the actual application up and running again. Your job will be to: - help to perform a clean export of the postgres database on old server - help to import the postgres database on the new server - ensure the Django application is coming back up smoothly The work will be done using shared tmate ssh sessions.

I need a web scraping professional to create a script to extract specific data from , a popular online marketplace for trading cards, please check attachement to get the idea. Key Requirements: - Scrapping: The primary task is to scrape the following information from the platform: - Card properties 1. Hero score for last 7 days 2. Hero rank for last 7 days 3. Stars 4. Rarity 5. Name 6. Quantity listed to purchase 7. Inflation data 8. Minted count - Buy prices List Price Last Price Order book (price and quantity see picture attached) - Bidding details bids book (bid and quantity see picture attached) - Twitter activity per card View Views+ Likes Likes+ Retweets Retweets+ Replies Replies+ Quotes Quotes+ Bookmarks Bookmarks+

...software integrator to help me integrate my personal deployment system with an IA/Chatgpt API. This project involves building and implementing a chatbot that's capable of: - Natural language processing: The chatbot should be able to understand and interpret human language, not just in a literal sense, but also in context. - Chatbot functionality: The chatbot should have the capacity to engage in meaningful conversations with users, along with the ability to learn and adapt over time. - Question and Answers: The chatbot should be able to provide answers to frequently asked questions and find relevant answers from PDF files content. Experience and Skills: - Strong understanding of natural language processing - Previous ...

I'm looking for a talented web developer to help improve my existing website. The changes I seek span across editing the design, content, and functionality aspects. (I just bought this from Astra Pro with Spectra, essential, Optimizer and YOAST - along with the Godaddy WordPress hosting) I have decent content from another of my sites to copy across to - Compress components with gzip Add Expires headers Make fewer HTTP requests Design Updates: - Changing colours: I want to refresh the colour scheme of the website to make it more vibrant and engaging - Updating fonts: The current font is outdated. I need a modern, sleek, and readable font to be implemented - Redesigning the logo: A logo redesign to reflect ...

I need a freelancer to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new

...developer to help with a personal project. Using NodeJs and NextJs with MYSQL DB, your skills will include: - Expertise in utilizing NodeJs and NextJs - Develop a user-friendly platform - The ability to brainstorm and bring creative digital solutions - Strong problem-solving skills - Understand project requirements and deliver high-quality work - Should be proficient in using Github with AWS and coordinate with infra team member for coordinated push - Understands and knows the importance of proactive communication Expectations: - Your primary responsibility will be to design and develop the application, and to coordinate with the rest of the team working on different layers of the project. - Daily commitment f...

...English quotations (or English translations), and are looking for a researcher with native English language skills who can identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the use of existing source material, with the primary emphasis on the coll...

I have two websites that need to be merged with a main focus on consolidating information. The current websites are different in design and themes, and I'm looking for a professional who can successfully merge them into a cohesive, user-friendly site. Key requirements: - Consolidate information: The primary goal is to combine and organize the content from both websites into a single, easily navigable platform. The new website should provide a clear and seamless user experience. - Prioritize by relevance: The content should be arranged in a way that is most relevant to the user. This may involve restructuring and reorganizing information to ensure that the most important details are easily accessible. Ideal skills and experience: - Proficienc...

I need an experienced data entry freelancer who can assist with a high priority task. The project involves inputting data into an Excel spreadsheet and carrying out online data entry tasks. The ideal candidate will be proactive, detail-oriented, and able to work efficiently with minimal supervision.

As discussed, this includes the following - 1. Automated trading functionality in excel using the TWS API 2. Customization of entry and any other rules post discussion 3. Python codes 4. Deployment support and 2-weeks support for smooth operation

...of someone adept in Excel and knowledgeable in medicine, especially in dosages and weight-based calculations. The challenging aspect of this project is to modify an existing locked Excel spreadsheet which is used to calculate dosages once a patient's weight is entered. Tasks involve: - Updating the dosages of specific medications based on the guidelines I have on hand. - Modifying the weight-based formula in alignment to these dosage updates. Skills and experience: - Proficient in Excel and worksheet protection - Comprehensive understanding of medical dosages - Experience or understanding of weight related dosages calculations. I will provide the necessary medication and dosage guidelines to the successful bidder for r...

...agriculture business that focuses on growing fruits and vegetables for both local and export markets. In need of a logo design that communicates the authenticity and sustainability of our products. Key points: - Logo Theme: It should reflect our business as an agriculture company. - Message: The logo needs to convey authenticity and sustainability. - Design: Simple yet effective, avoiding overly complex or ornate designs. - Color Scheme: Earthy, natural hues would work best. - Can incorporate an illustration of agriculture or farming Ideal Skills and Experience: - Experience in designing logos for agricultural or sustainability-focused brands. - Demonstrable portfolio of simple yet effective logo designs. - Ability to capture the essence of a brand through minim...

We're seeking an experienced developer company to help upgrade a state-of-the art startup MEMBERSHIP PLATFORM; website, iOS & Android apps, and admin panel. **OVERVIEW** The framework is built in versions that are several years old. For example Node JS 7.10.0 and MySQL 5.7.0. Everything needs to be updated to highest stable version that offers support and packages. For Node.Js that will likely be version 18 or 20 Moreover, this project offers an excellent opportunity for more development. **QUOTE: UPGRADE** -Please provide a quote for upgrade of website, iOS & Android apps, and admin panel. -The Framework described below. -Specify team size and roles. -Time frame for completion. **PLATFORM FRAMEWORK & DETAILS** Framework: React, ...