Create excel file mysql data jobs

...need of a skilled Python expert to transform a raw excel report into a final template version of excel. The project requires two main tasks: Formatting and re-arranging of columns along with calculation updates for one column. Key Points; - Need 3 open reports to pull the information and split the reports at the end. - Formatting Changes: The report needs specific columns to have pre-defined blank values for certain columns: Col B, E, J, R, W, AB, AE, AJ, AV, BG, BI, BJ, BQ, BU, BV, BW, BX, BY, BZ. - Calculation Updates: The calculation layer within the excel report needs to be updated and finalized. The ideal freelancer for this project should have a profound understanding of Python and extensive experience in manipulating and formatting excel reports. I ...

...Image Design and optimization capabilities – Photoshop or similar - Experience in WordPress, HTML, CSS, JavaScript, PHP, (MySQL also helpful) - Experience with major WordPress themes and plugins - Strong understanding of SEO, website performance optimization, and security best practices - Familiar with WPEngine. Once confirmed we’ll create a WPEngine account - Strong English communication with ability to jump on Zoom calls if required Ideal Candidate: - The freelancer should have previous experience in creating minimalist corporate websites and integrating a product showcase with some animation. - Knowledge in visual design and UX will be highly valued in order to create an engaging and user-friendly interface. Attachments: - Attached is one page tha...

Read first - NO auto bidding, please I am hiring a Full Stack WordPress Developer who has an intermediate experience level. in >> Full time job << I anticipate that this developer will use a variety of programming languages and technologies, including: - HTML - CSS - JavaScript - PHP - MySQL - WordPress - jQuery - Laravel The candidate should be comfortable with carrying out a range of tasks, but these will most frequently include: - Creating new and custom features from scratch - Improving or updating existing features - Debugging and fixing issues You should have a thorough understanding of each of these tasks and be committed to providing high-quality results on a consistent basis. Please only apply if you possess a strong competency in all mentioned languages and...

Everyday I have to extract some datas from around 100 invoices (PDF files) and copy it to an Excel file. I do it manually (copy/paste), but I need a tool to have it done automatically. These invoices have a consistent format structure, and the fields I need to copy to Excel are always the same. They are informations like: invoice number, date, customer's name, product code, price, etc. All the fields that need to be on Excel are highlighted in color red on the 2 files I'm providing as an example. Any other info not highlighted in red, doesn't need to be on Excel file. The automation process must execute without fail, ensuring that the location of highlighted fields - which are always the same in every file - does not affect ...

I'm looking for a professional Excel user with a strong grasp of nutrition concepts to develop an advanced tool for me. Here's what I need: - A comprehensive Calorie Calculator - Macronutrient Calculator to recommend the optimal amounts based on three different goals: Weight loss, Muscle gain, and Maintenance - BMI Calculator - Be able to calculate these based off body weight, height, activity level, age and gender inputs The ideal candidate should not only be proficient in Excel, but also have a good understanding of nutrition principles. The faster this can be completed, the better.

...following issues: - **MySQL Configuration**: I'm encountering error messages related to MySQL. The freelancer must be able to diagnose the issue and provide an effective solution. - **SSH Troubleshooting**: There are connection issues with SSH. The hired professional should be able to identify the root cause and resolve it promptly. - **cPanel Account Missing**: Currently, some cPanel accounts are not showing. The task involves investigating and rectifying the issue. - **Service Stoppage**: Some important services have stopped working. The ideal candidate should have experience with Linux administration and be able to troubleshoot and restart these services effectively. Ideal skills and experience include: - Proficient in Linux server administration, particularl...

I need an expert to create a Video for a Facebook ad for an English learning Website. The video will be in Spanish language since the target audience will be Spanish speakers in South America who wish to learn English. I therefore need someone who is a native Spanish speaker (from South America) but who is also proficient in English. I prefer someone currently living in South America. The target platform will be primarily mobile and secondarily laptop users. The video should be a sketch/testimonial of sorts highlighting the effectiveness of the language learning approach taken by the website (see below). Creative, performance, acting, and video producing/editing skills are required. About the website's language learning approach: In order to acquire a new language, one must b...

I need an Excel 365 PowerQuery script that can fetch daily market data and handle potential data source interruptions or changes. I will be providing a URL that contains the market data, and you'll need to replicate the Google Sheets function =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). This function provides real-time data from the specified URL. Please note that the data is structured using HTML tags. Key requirements: - The PowerQuery should be able to be refreshed with the google sheet. - It needs to include robust error handling. If the data source is unavailable or the structure changes, the PowerQuery should not break but continue to function, ideally pr...

I recorded a podcast episode on my computer through Riverside, but the audio is distorted. I need a skilled audio engineer to help me fix it. Key details include: - The audio was recorded in WAV format. - The primary issue is distorted sounds rather than background noise or volume fluctuations. Ideally, you should have experience with: - Audio editing software. - Correcting distorted audio without losing quality. - Working with WAV files.

...download of digital files. Key Functionalities: - Implement user registration and login feature. - Develop robust file upload and download functionality for various types of files: documents such as PDF, Word, and Excel; images including JPEG, PNG, GIF formats; and media files such as audio and video. - Integrate a highly secure and user-friendly payment gateway for transactions. Ideal Skills for this Project: - Proficient in full-stack development. - Experience in building e-commerce platforms, particularly with user account management and file sharing features. - Strong understanding of payment gateway integration. - Ability to work with various digital file formats. - Attentive to details, particularly regarding security and user privacy. ...

As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to deliveri...

I'm in need of a developer who can compile a Windows Exe file for the Real-ESRGAN GitHub project. The Exe file should operate on CPU, and accept command-line. Currently, the GitHub project offers only a GPU exe file, hence the need for a CPU version. GitHub link for Real-ESRGAN:

Create a form in google Sheets following the pre-determined options. The results of the answers must be recorded in a second tab

I am looking for a freelancer with expertise in PowerBi and Excel. The task will revolve around creating a one-time report/dashboard on PowerBi sourced from a single Excel spreadsheet. The ideal candidate should have: - Previous experience with PowerBi and Excel - Proven track record of data analysis - Attention to detail Please note that the Excel file won't be changing over time, so there is no requirement for the PowerBi report/dashboard to be updated. Content Description: I have statistics from every UFC fight and want basic visualizations made (I have a rubric)

I'm in search of a MailWizz expert Key responsibilities: - Customizing the user interface design to improve the overall user experience and branding. - Devising a mechanism to manage debits of email credits efficiently. We simply want to add emailing credits to our customers mailbox account and we will ad...credits the account based upon the amount paid. We then simply like to debit the credits for each email sent. Very simple. If we give the mailbox user 10,000 credits and they emails 3,000 emails the 3,000 is debited from the 10,000 balance and 7,000 credits are left. We have already configured Mail Wizz with Postfix MTA We own our servers and we wish to integrate the emailing server with our MySQL database. This is the first of many jobs that we will require cus...

I'm looking for a talented web developer to transform my Figma file into an interactive, grid layout webpage. This is a great opportunity for someone who is looking for a challenging project which will demonstrate their ability to implement effective, modern design principles. Here are the key deliverables of this project: - Perfectly replicate my Figma design and translate it into a fully interactive webpage. - Implement a grid layout to optimize content display and improve user experience. - Make the webpage fully responsive, providing optimal viewing and interaction experience across all devices. Skillset Requirement: - Strong understanding of HTML & CSS. - Experience in converting Figma designs into webpages. - Strong background in responsive design principles. - Clea...

I am looking for a skilled developer to create a Windows-based application that can interact with a remote database. The application should primarily focus on retrieving and generating website sitemaps based on different criteria. The ideal candidate should have: - Proficiency in Windows application development - Strong experience in working with databases, particularly remote databases - Knowledge in data retrieval and data update functionalities - Ability to understand and incorporate additional requirements as the project progresses Please note that the selected freelancer may need to provide examples of past work and project proposals. Note: Application should be able to connect different type of databases such as MS SQL Server, MySQL, Oracle etc.

I need a professional to add dimensions to specific sections of my AutoCAD drawing. These added measuremen...sections of my AutoCAD drawing. These added measurements will serve to enhance the amount of detail and provide more informative insights for the viewer. I will send the DWG file on the creation of milestone. Key tasks: - Add metric (meters) dimensions to the DWG file - Pay special attention to select objects and areas requiring measurements Ideal skills and experience: - Expertise in AutoCAD software - Deep understanding of technical drawing and dimensioning standards - Precise attention to detail - Engineering or technical drafting experience would be a plus Your task will be integral in enhancing the sense of scale and data detail for anyone viewing thi...

...other supported content types. Contact Management: Develop a system to manage the list of customer contacts, allowing for adding, editing, and deleting contacts as needed. Message Templates: Create predefined message templates to facilitate the sending of common messages, such as order confirmations, appointment reminders, promotions, etc. Activity Logging: Implement an activity logging system that records all interactions performed through the application, including message sending, delivery status, etc. Technologies Used: PHP: Primary programming language for backend development of the application. MySQL: Database for storing user information, contacts, and activity logs. WhatsApp Business API: Official API provided by WhatsApp for sending messages from business appl...

I'm in need of a skilled PHP/MySQL programmer to help me resolve issues with my legacy application. While the data in the current database isn't critical and can be easily recreated, the system is currently not allowing the addition or update of database records, although deletion is possible. Key requirements and responsibilities: - The main issue is resolving the problem of not being able to add or update database records. - There are no error messages displayed, so a deep understanding of PHP and MySQL is needed to identify and solve the root problem. - Once the issue is resolved, the next step would be to optimize the application to prevent similar issues in the future. Ideal skills: - Proficient in PHP and MySQL - Experience in working with and...

Hi, I am looking for someone to take my text-only Microsoft Word document and create a nice-looking visual booklet for people to read. I have already typed out the document and would like someone to add some good fonts, formatting, images, and themes. It is important that this be done in something like Microsoft Word or even Microsoft Powerpoint for me to make the final adjustments. ***I will send a quick message with the word document and what the preferred themes and colours are to be. *** I have attached an example Handbook as a Guide to what is to be made.

I'm seeking an Excel expert to create a user-friendly data entry workbook. The job is straightforward and requires the following: - **Data Entry:** The workbook should mostly focus on simple data, like names and dates. I am not looking for any intricate calculations, formulas, or pivot tables. The main focus is on creating an Excel workbook that streamlines the process of entering simple data in a structured and efficient way. Experience in creating user-friendly UX within Excel is a plus. No integration with external systems or services is needed - this is a standalone project. I look forward to collaborating with an experienced professional who can deliver an effective, easy-to-use data entry solution within E...

I require AutoCAD shop drawings for the intention of construction planning for a commercial building. The freelancer should include comprehensive architectural details. A strong background in creating accurate AutoCAD drawings detailing architectural specifics for commercial projects ...accurate AutoCAD drawings detailing architectural specifics for commercial projects is a must. The desired candidate will need a strong understanding of construction processes, especially within the commercial realm, to ensure every detail contributes to a seamless build. Your craftsmanship will directly influence our build strategy, so we expect precise and detailed work. Please only apply if you excel in AutoCAD and have direct experience in the realm of architecture and construction of commercial ...

I'm looking for a seasoned Excel expert to create a set of macros that can automate my data extraction process. Here's what I need: - Automate data extraction: The primary purpose of these macros is to enable automated data extraction from local files. The data in question is stock market data. The ideal candidate for this project would have: - Proficiency in Excel: You should have a strong grasp of Excel, particularly in designing and implementing macros. - Experience in data extraction: You should have a track record of successfully automating data extraction processes. Looking forward to hearing from you.

I am looking for an expert in Excel to design a dynamic spreadsheet for project tracking. This spreadsheet will focus on monitoring task progress and deadlines. Key Features: - Daily updates: I will be updating task progress and deadlines daily, and so I need the spreadsheet to be user-friendly and efficient. - Task highlighting: If a task is falling behind schedule, I need it to automatically become highlighted in red. This will help me prioritize tasks and ensure no deadlines are missed. - This will need to show throughput for every phase and also provide an average through in volume. Skills and Experience: - Proficient in Excel - Experience in creating dynamic spreadsheets - Understanding of project management principles. I look forward to working with a detail-orien...

Create 1 Instagram reels for the valuable buyer

Create an astronaut helmet logo similar to the style of the logo attached. Please show how your logo looks on a white background and on a black background.

For this task, I am specifically seeking a freelancer who is proficient at data entry and familiar with Excel spreadsheets. The project primarily involves numeric data, so accuracy is vital. Key Responsibilities: - Input numeric data into an Excel spreadsheet. - Maintain a minimum 98% accuracy level. Ideal Skills and Experience: - Proficient in Excel. - High attention to detail. - Experienced in numeric data entry. - Proven track record of maintaining high levels of accuracy. Please ensure you have the necessary skills and experience before placing your bid. I look forward to your detailed proposals.

I am urgently in need of an expert in Data Build Tool and SQLite database who can efficiently develop a data pipeline. The pipeline will handle extracting all files from a specific folder location on my local drive. The goal here is to create a pipeline that can universally extract all types of files. Ideal Skills and Experience: - Proficient with Data Build Tool - Extensive knowledge of SQLite database - Prior experience with data extraction projects - Quick turnaround time - Ability to work with local storage systems This is a two-hour assignment and the steps required for the task are detailed in the document provided. Your quick assistance is highly appreciated!

Need to extract data from website: , into an Excel file. Specifically name, discipline (medical practitioner, midwife, nurse, OT, physio, psychologist, podiatrist), location (incl suburb and postcode), initial registration date, registration expiry. There would be at least 100,000 rows of data. Only barrier, is this data is not able to be 'searched' efficiently. Individual names can be looked up. Or disciplines with a select number of names demonstrated...but I can't find a way to show ALL clinicians at once. Looking for a solution which can reliably pull all the names from the database.

...Integrate Razorpay for secure and efficient payment processing. 4. Integrate Shiprocket API to facilitate seamless order fulfillment and shipment tracking. 5. Connect the frontend to the backend, ensuring proper data flow and interaction between the two. 6. Collaborate with the frontend developer to ensure smooth integration of custom designs. 7. Optimize the website for performance, security, and scalability. **Skills Required:** 1. Strong experience with Laravel 10.x framework, including MVC architecture, routing, middleware, and blade templating. 2. Proficiency in database management with MySQL or other relational databases. 3. Deep understanding of backend development principles and best practices. 4. Proven track record with API integration, particularly with payment...

I'm looking for an Excel expert who can build a simple yet effective sheet for basic arithmetic calculations. Key requirements: - Perform basic arithmetic operations: The main functionality of the sheet should be to perform basic arithmetic operations such as addition and subtraction. - Real-time collaboration: The sheet should support real-time collaboration, where multiple users can edit the Excel file simultaneously. Ideal skills and experience: - Strong background in Excel: The freelancer should have a deep understanding of Excel and the ability to create formulas for basic arithmetic. - Real-time collaboration proficiency: Experience in implementing real-time collaboration features in Excel will be highly beneficial. - Atte...

I'm looking for a reliable and experienced data entry specialist who can assist me with entering data from images. The images will be directly uploaded to a website, and I need the data to be transcribed into various formats like Excel sheets, Word documents, and for copywriting purposes. Ideal Skills and Experience: - Prior experience with data entry from images - Proficiency in Excel and Word - Copywriting experience is a plus The primary goal of the project is to create a comprehensive database in various formats, so the ability to accurately transcribe and organize data is crucial. The chosen freelancer should have keen attention to detail and a high level of accuracy.

...potential clients. - Convert conversations into promising leads. - Record conversational details into our database. REQUIRED SKILLS AND EXPERIENCE: - Exceptional persuasive communication skills. - Proven experience in lead generation. - Familiarity with the corporate events and conferences sector. - A resilient attitude to handle potential rejections and keep going. This role demands someone ready to excel in a fast-paced environment while showcasing dedication, autonomy and agility. Your ultimate aim will be to assist in the company's expansion through the successful generation of potential leads. This is an excellent opportunity for someone looking to apply and enhance their telecalling skills while significantly contributing to a growing company in the event managemen...

Hello, I would like a catchy kids song created about the digestive system. The lyrics should be fun and explain how food works its way through the digestive system including: - the mouth where food is chewed and saliva begins to break down the food - the esophagus whe...the stomach where food is broken down into small pieces, like a blender - the small intestine where nutrients like vitamins and minerals are soaked up from the food for the rest of the body to use - the large intestine where all the left-over waste from the food turns into poop. The deliverables should include a) the complete song with the vocals and the instrument backing track, and b) a second file with just the backing track. And I want the song to be very catchy. Please let me know if you have any questions. ...

I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.

As a data enthusiastic business, we're seeking a talented freelancer who can design an effective Power BI Dashboard to integrate various data sources including Excel spreadsheets, CSV files, and SQL databases. The ideal freelancer would: - Have extensive experience with Power BI and DAX language integration. - Demonstrate an excellent grasp of designing dashboards that report on KPIs. - Be well-versed with creating DAX calculations in the Power BI environment. We require the dashboard to focus on specific metrics, therefore, a strong understanding of reporting on KPIs using DAX language is a must. Additional Skills: - Proficient in Microsoft Excel and SQL databases. - Understanding of data integration and reporting. - High attention to detail. ...

Tasks: We have three different algorithms for matching a resume with jobs on the website. They are coded in python. You have to create the APIs for webapplication. Then you create the Website which has 2 user types. Job Seeker and Employer. Login to use (home page) Job seeker will upload their resume details using a fixed form. Employer can post as many jobs using an upload job form. The data is stored in a table. On clicking the Find Jobs button (after uploading resume) or Find Profiles (for each job posting uploaded) the results page will show the ranked results (either job or resume depending on user). Home Page - Login SignUp buttons only...no design or banner or random stuff. Profile Page - Form Filling page with resume details. Resume Form Page Job Descri...

In search of a competent Excel specialist adept in Microsoft Access for multiple automation tasks. I need assistance with: - Macros Development: The main tasks include automation and creating tools. The proficient use of macros in daily operations is essential. - Report Generation: Specifically, the generation of technical proposal reports. Alongside this, the candidate should also be capable of automating the formula calculation process. Familiarity with financial, sales, and project status reports is an added advantage. - Tool Building: The capacity to build tools and other operations geared towards improving efficiency is crucial. Ideal skills include deep understanding of Excel functionalities, proficiency in Microsoft Access, extensive experience in automation via macr...

I'm currently in need of a skilled professional versed in CSS3, HTML5, PHP, and MYSQL. My primary requirement consists of creating minimalist and clean CSS styles for specific pages, namely the products page, product view, and checkout page. In addition to this, there will be some light PHP work involved. The ideal candidate should have demonstrable experience in these areas and a good eye for clean and minimalist design. Efficiency and attention to detail are key.

Dear Developer, We have an older application that was developed 15 years ago to manage appointments for kitchen mechanics, using native PHP and JavaScript. As this app is now deprecated and outdated, we are looking to rebuild it entirely from the ground up while retaining its core functionalities. Project Overview: We are seeking to develop a modern web application using cutting-edge technologies: - Frontend: React.js for dynamic and responsive user interfaces. - Backend: Laravel for robust and scalable server-side logic and API development. To begin, we can provide you with access to a working instance of the current application, which you can run locally using XAMPP or WAMPP. Please ensure that PHP version 5.6 is installed to ensure compatibility and functionality. If yo...

...need an Excel expert to build a tool that can automatically validate and correct any incorrect country codes in the file. Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates...

...manage MIS excel sheets pertaining to data analysis, sales forecasting, and expense tracking on a daily basis. Key tasks: - Establishing excel sheets to analyze a broad range of data - Constructing a sales forecasting model within the excel sheets - Regular tracking and management of expenses via the excel sheets Data sources would primarily be spreadsheets and databases. These excel sheets will require daily updates, enabling close monitoring of key metrics. Ideal skills: - Proficient in Microsoft Excel - Exemplary skills in data analysis and modeling - Good understanding of databases and how to extract data from them Experience in handling and managing sales and expense data is crucial for th...

I need an expert to migrate my products from an Excel file to my WooCommerce store. Key Requirements: - Migrate products from an Excel file to WooCommerce - Use attributes to define variations within a single product - Update existing product descriptions during the migration Ideal Skills and Experience: - Strong experience with WooCommerce and product migration - Proficiency in handling product variations using attributes - Attention to detail for updating and modifying product descriptions - Excellent knowledge of data import/export and product management on WooCommerce. - Ability to ensure a smooth and error-free migration process.

We have an existing PHP/QuickBooks Online application designed to sync QuickBooks invoices to a MySQL database. The application works correctly when executed but we have an issue where the security token needs to be refreshed manually every 24 hours. We need to devise a way for this application to run with no requirement for refreshing the token manually. The program syncs orders in real-time so manual token refresh is not an acceptable way to do this. A developer is required with experience working with QBO applications and working with the QBO token refresh system so this refresh is done automatically.

...product data from XML sheets. The data needs to be imported into multiple Prestashop faced search feature tables. Key project details: - I need the product information to be imported - The data needs to be updated daily and in real-time - Multilingual support is not required, so a single language is sufficient Ideal Skills and Experience - Proficiency in working with XML data and importing it into systems - Expertise in Prestashop and its search feature tables - Experience with real-time data updates in web applications - Strong problem-solving skills and attention to detail Import data from xml sheets into multiple prestashop faced search feature table. Here's an outline of the tasks Script to Parse XML for Nightly Update: This scri...

I have a significant amount of text that needs to be typed into Excel quickly. The data is in a simple text format, no complex formatting required. Key requirements: - Proficient in Excel and typing - Attention to detail - Ability to work under tight deadlines The data is straightforward text and requires no specific formatting or analysis. The ideal freelancer will be skilled in data entry and be able to commit to a quick turnaround time.

As a client with emphasis on quality, I need the support of an experienced Python programmer who can take charge of the frontend aspect of my web development project. At the core of this project are the following requirements: - Full proficiency in Python as the main programming language for the task - Demonstrated experience in frontend web development using Python - Familiarity with the best practices in Python programming - Capacity to effectively communicate, provide regular updates and accept feedback The missing response for the third question won't be an issue — I am more interested in a Python programmer who can bring their own unique ideas and solutions. You are encouraged to showcase your creative problem-solving skills. Apply if you have the necessary skills and ...

I am seeking an Excel expert who can meticulously enter extensive amounts of text, numeric, and alphanumeric data into my spreadsheet. The task involves entering names, contact details, sales information, and inventory data. The size of the task is quite substantial, with up to 1,048,576 rows and 16,384 columns involved. The role requires a keen eye for detail, accuracy, and dedication. If you are efficient in Excel and possess experience with handling large data sets, your skills will be highly valuable for this project.

I need a reliable freelancer to assist with data input. Here's a breakdown of the project: - **Task:** Your primary job will be to input data from online forms into either Microsoft Excel or Google Sheets. - **Experience Required:** It is necessary for you to have prior experience with both of these tools. This will ensure you're able to work efficiently and accurately. - **Attention to Detail:** Given the nature of the task, it's crucial that you have excellent attention to detail. Even the smallest mistake can have significant implications. If you have the experience and skills mentioned above, I would love to hear from you.