Mysql read excel file jobs

...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: - Proficiency in Google AppSheet and MySQL - Experience in developing inve...

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.

...website design concepts and digital marketing trends is a plus. Technical Requirement: • Fast Internet • American English Accent • Quality Microphone Ready to take your sales career to the next level? We are! How to Apply? (Do the Following to be considered, copy and paste the template below and use as your cover letter) 1. Record Your Voice: Read the following sales script with your voice: 2. Speed Test Goto: Change server to any Los Angeles, CA Server. Screenshot or link me to your test result. 3. Are you able to work in USA Time? (-8 PST) working 8am-4pm or 8am-5pm? 4. What is your Sales Experience and Website

I have a batch of handwritten notes that I need to be converted into digital text. Key Requirements: - The project is primarily data entry. You will be given physical copies of these notes, and your task will be to accurately transcribe them. - Attention to detail is crucial, as the notes may be difficult to read and require care to ensure that the content is correctly interpreted and entered. - This is a time-sensitive project, so meeting the deadline is essential. Ideal Skills: - Proficient in typing and data entry, ideally with experience in transcribing handwritten notes. - Attention to detail is paramount. - Time management and ability to meet deadlines.

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 need a command-line program that can convert .mpz files to .xlsx files. The program should be written in Python. If anyone can do it, please send me the message. Key Requirements: - Input: The program should take a .mpz file (protected password) as input. - Output: The extracted files should be converted to .xlsx format. - Handling: The program should be able to handle files up to 200mb in size. Skills/Experience Required: - Proficient in Python programming - Experience with file handling and conversion Note: A graphical user interface is not required, the program should be command-line only.

...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 implementing automated email notification systems - Abil...

I am looking for a skilled and experienced professional who can render detailed plans and elevations for my residential construction project. Your task will involve: - Preparing construction drawings that effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing compreh...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 this, you might be the right fit ...

I hope to acquire some apps that already exist on Google Play Store. No need for any development or optimization. Please read my requirements carefully. Key Points: - No new development is required, just purchase apps that already exist on Google Play - I'm interested in apps across a range of categories except finance and wallpapers. - The apps should offer diverse functionalities and be of high quality. - Prior experience in evaluating app performance and potential is highly desirable. - Has a certain download volume。 Your role would be to identify suitable apps for purchase, based on their category, features, and potential. Your ability to assess apps in terms of their quality, user base and potential for monetization will be crucial. Your familiarity with the Google Play...

Please Sign Up or Login to see details.

I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: -...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 also a key requirement. Previous experience handling numerical, categorical, and textual ...

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. - Potential...

...Create preliminary design of the engine layout (drawings or sketches) - Develop preliminary design/placement of key components (e.g., pipe, valves, evaporator, condenser) Deliverables: First 10 hours: - Design Report (5-10 pages): - Overview of the design concept - Thermodynamic cycle analysis (calculations and spreadsheet; Excel/OpenOffice Calc) - Heat transfer calculations and assumptions (calculations and spreadsheet; Excel/OpenOffice Calc) - Fluid flow, power, and pressure drop (calculations) - Summary of Findings (1-2 pages) Second 10 hours: -CAD Drawings (2D or 3D): - Engine layout design - Key component designs (e.g., evaporator, condenser, piston) -Design Summary (2-3 pages): - Overview of the preliminar...

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 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.

...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 to inquire about availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the chosen courier to confirm the shipment. Automat...

Russian Recording Project Note : We need Native Russian speakers for long term project. We have a project, that needs Native Russian speakers, we will give you the text, and you need to record 626 Short sentences. you just need to download our software, to read our text and record it, it's a very easy job. 1. You will need to record in a quiet place without loud background noise. and without echo. 2. Each person is $14 dollar for 626 sentences record. If you are interested please let me know sure.I will contact u. A Good Opportunity For New Freelancers For taking 5 Star Review after their completion of the project. Thanks :

...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. - Ability to work independently and meet deadlines. - .NET and are a plus but not a requir...

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.

We're a dynamic agency specializing in helping businesses stand out on YouTube. We're currently on the 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 techniq...techniques specific to YouTube. - Proficiency in utilizing analytics tools to drive decisions and enhance content performance. - Strong creative skills for developing eye-catching thumbnails and titles. - Passionate about the YouTube platform and staying up-to-date with the latest trends and algorithm changes. If you're ready to join a results-driven team and help businesses across various industries excel on YouTube, we'd love to hear from you. A perfect opportunity to apply your SEO exp...

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 tab...Question and Answer pdf is given, In the format mentioned above, just add another 3 options in Google sheet, and write the answer in Aiken formatting. Note: The question should be in one line (cell). After Each "ANSWER: X" is marked, the next line/row will be blank. Can you do a sample for the first 3 mcq? Can you do this for a 5-star review and lowest price? Do the sample in the attached Excel file by referring to the PDF attached. For sample, do the 3rd, 4th and 5th question as example in google sheet online and s...

I have a science fiction novel which is between 50,000 and 100,000 words, and looking for a professional and detailed proofread. Ideal Skills: - Proofreader with previous experience in novels, especially within the science fiction genre - Must have an eye fo...words, and looking for a professional and detailed proofread. Ideal Skills: - Proofreader with previous experience in novels, especially within the science fiction genre - Must have an eye for detail and excellent knowledge of English language Responsibilities: - Checking and correcting errors in the manuscript - Providing suggestions on how to improve readability, pace, and structure Expect to read and correct the novel within an agreed deadline. Also, use track changes so I can view all the edits made. Please send your...

I have a photo of a medal that I would like to have converted to a svg file for printing. I want the outlines of the kings head, text and contours in black. Also the clasp with the text *1858 Gustaf V †1950 in black. The ribbon should be black also. Show examples and the best one gets the job.

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.

I need a desktop 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 to be user-friendl...

...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 accuracy are highly valued. - Understanding of basic financial jargon will be beneficial. This role requires someone who is organized, reliable and able to work independently. The workload will be part-time with flex...

...content incorrectly, and I need you to rectify this. Essentially, your role here will be to fix any errors that cause incorrect content display on mobile, making sure all elements appear as they should. Lastly, there is a problem with the automatic update of monthly posts on the homepage. It's visible only when you click ‘read more’ whereas it should appear readily on the homepage. I’m looking for a way around this, so viewers do not have to take the extra step of clicking 'read more' to see the recent posts. Skills and Experience Required: - Experience with WordPress AND GoDaddy platform - Expertise in mobile web design and troubleshooting - Strong understanding of responsive design - Proficiency in rectifying content display errors - A...

I'm seeking an expert audio engineer who can produce a high-quality WAV sound format file that records music in gigabyte quality. The resulted file needs to be compatible to play on various platforms including but not limited to YouTube, Spotify etc. Specifics: - The file should offer unlimited recording capability, with no restrictions in terms of length. - Must possess proven experience in music editing and file formation. Skills in working specifically with WAV formats is a plus. - Familiarity with audio quality requirements for various platforms (YouTube, Spotify, etc.) is crucial. The importance of quality, compatibility, and versatility in this project cannot be overstated. Applicants should bid with relevant portfolio samples demonstrating the abi...

...with sentiment analysis - Ability to create personalized recommendations for users - Skilled in extracting and understanding content from PDF files - Strong problem-solving skills and attention to detail Details - Upload Excel file containing Expediente Codes - Use automation and OpenCV to solve Captcha and download files - Upload files to s3 bucket - Integration with existing system - use google to authenticate to the system (maybe change to office 365) Requirements: - REMOTE SERVER: Existing server - Access to S3 Bucket - Access to chatgpt api - Access mysql aws instance We need access to final git repository Project Completion: 2 weeks This project is an exciting opportunity to work on a cutting-edge software integration and development. If ...

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 freelancer who is looking for a 5-star review.

I am in need of a developer skilled in Flutter to create a hybrid app for both iOS and Android platforms. The primary function of this app will be able to support reading manga. Key deliverables for this project include: - Development of a user-friendly application in Flutter. - Th...and categorizing manga content. - Any experience with manga or comic book applications is a bonus, but not necessary. Proven experience in Flutter and mobile application development for both iOS and Android platforms is required. A successful candidate should demonstrate a strong understanding of usability and user experience and should be able to work effectively with minimal supervision. read this file for more details:

I'm in need of an expert to help me create a 3D STL file for a wood carving project I'm planning to run on my CNC machine. Key Requirements: - The 3D model should be suitable for wood carving, ensuring it's conducive to the CNC machine's operation. I use vetric aspire and the file is for a wall decor - I'm looking for detailed, intricate designs that would look appealing once carved. Ideal Candidate: - Proven experience in creating 2.5D and 3D STL files for CNC wood carving. - Proficiency in understanding the constraints and requirements of CNC machines. - Creative and skilled in designing intricate patterns and shapes. - Strong attention to detail to ensure the final product is of high quality and visually appealing.

I am looking for a proficient full stack 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 for a minimum of 4 hours f...

We are developing a spreadsheet-based database of the most popular 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 mate...

Russian Recording Project Note : We need Native Russian speakers for long term project. We have a project, that needs Native Russian speakers, we will give you the text, and you need to record 626 Short sentences. you just need to download our software, to read our text and record it, it's a very easy job. 1. You will need to record in a quiet place without loud background noise. and without echo. 2. Each person is $14 dollar for 626 sentences record. If you are interested please let me know sure.I will contact u. A Good Opportunity For New Freelancers For taking 5 Star Review after their completion of the project. Thanks :

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: - Cons...seamlessly Please let me know your experience with similar projects and your approach to this particular task. Your input on the best ways to consolidate the information and prioritize content is highly appreciated. Website language is: - Linux AMI > OS - PHP > web and back-end - NodeJS > ICS - > ICS & Warehouse App - Ionic v1 > Warehouse App - Apache > web server - Database: MySQL Aurora - AWS hosted, leveraging EC2, RDS and S3 - Front-end is custom framework mix of ...

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

I am in need 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 reference. The idea...

I'm in need of a creative designer who can put together a unique logo for my brand. The name of our company if "Young Gifted Entrepreneurs". Please create one for the company name and acronym YGE. The logo should feature both text and an icon and be visually striking to catch the eye. Key Requirements: - I'm keen on a balanced mix of vibrant and bold colors. I particularly like the idea of incorporating Purple, Teal, and Navy into the design. - The logo should be modern and with details. Particularly something that can be branded!! Ideal Skills and Experience: - Proven experience in logo design, especially with a combination of text and icon. - Proficiency with color theory and ability to create striking color combinations. - A good understanding of current design ...

...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, Node, Express, React Native Frontend: React (website), Node + Express (APIs on server), React Native (mobile apps on iOS & Android), Bootstrap (making UI web responsive) Backend: Node.js (latest version), Express, MySQL Deployment:...

I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.

...maps. The goal is to clearly illustrate the evacuation routes within the building's layout. Requirements: - The present pdf copy of the floor plans should be converted into an editable format. The preferable formats are Word, Excel, or Editable PDF. - Use color-coding to differentiate the evacuation routes for better clarity. The color to be used for the evacuation routes is Red. Ideal Freelancer: - Proficient in creating and editing floor plans. - Skilled in using software that can create and edit floor plans, such as Adobe Acrobat for PDFs, Microsoft Word and Excel. - Experience working on evacuation plans or similar projects is an advantage. - Knowledge of color-coding and its application within floor plans to ensure the clarity of the evacuation routes. The ...