Java programs read excel sheets write mysql database jobs

I am looking for a proficient database developer to create a robust database system for my logistics company. This system should be able to efficiently handle multiple aspects of the business including; 1. **Client Management**: The database should store and track client contact information, billing details as well as transaction history. Relevant experience in developing similar systems will be a plus. 2. **Rate Management**: The system completely manages various rates such as rate per mile, per weight, per volume, and based on material type. Freelancers with a good understanding of rate calculations within the logistics industry are preferred. 3. **Route Management**: The developed system should be capable of managing varying routes linked to different businesses,...

Hi Lin F., you have completed a scraping job for me for the last two years, I need it done again. Please have a look and apply: https://www.freelancer.com/projects/excel/Scrape-data-from-unprotected-URL

I need an expert to masterfully apply and tweak formulas and functions across entire rows and columns within my Excel spreadsheet. Your tasks will be to: - Implement formulas and functions - Apply them to entire rows and columns Ideal skills and qualifications for this job would include advanced proficiency in Excel, especially in applying lookups and mathematical functions like SUM, AVERAGE, COUNT. Proven experience with similar projects is highly preferred.

I am in need of a dynamic Excel tool to perform data analysis tasks. The tool must be designed using autofill drop down list, and it will be utilised for: - Employee name selection - The drop down list should offer an autofill option for employee names. - Tallying Totals - The drop-down list selections should be capable of tallying totals. For this project, the ideal freelancer will have strong experience with Excel, particularly with creating and managing drop down lists. Experience with data analysis in Excel will be beneficial. Your task will be to create an easy to use, and automated system that can manage complex quantitative data.

I'm seeking a talented professional to create AI generated explainer videos, specifically designed for corporate employees in the health industry - gyms. This project will involve: - Understanding the nuances and intricacies of gym routines and training programs. - Using this understanding, develop captivating, clear, and concise explainer videos intended to educate and train corporate employees on these various aspects. Ideal skills include: * Experience in content creation for education and training purposes. * Proven track record in creating engaging explainer videos. * Knowledge about the health and fitness industry, especially gyms. * Proficiency in AI technologies used in video generation. * Exceptional communication skills to succinctly articulate complex gym training...

Please Sign Up or Login to see details.

I'm seeking an expert in data collection to gather email addresses from a list of retail shop websites I have. Your responsibility will be to: - Visit each website link that I provide - Identify and collect the contact email address - Organize the data in a spreadsheet, with each email in a separate row Deliverables: - A sprea...have. Your responsibility will be to: - Visit each website link that I provide - Identify and collect the contact email address - Organize the data in a spreadsheet, with each email in a separate row Deliverables: - A spreadsheet in either .xlsx or .csv format with the email contact for each retail shop. Desired Skills: - Data Collection - Data Entry - Attention to detail - Proficiency in Excel or similar spreadsheet software - Familiarity wit...

I'm searching for a specialist in the Microsoft Partner Program to successfully navigate the ins and outs of the application and enrollment process. This encompasses: - Proficiency in completing application forms, - Expertise in gat...which include but are not limited to: - Knowledge of eligibility for incentives and rewards, - Familiarity with the requirements for earning partner certifications, - Understanding the process for accessing Microsoft resources and support. Lastly, I require sales and marketing support tailored to the Microsoft Partner Program. The ideal candidate will be highly experienced in Microsoft Partner Programs, have great communication skills and a keen attention to detail. Your role would be to make the process as seamless and beneficial for our compa...

Looking for a skilled developer who can automate the process of extracting text content from RTF code and organizing it in a categorized structure in an excel spreadsheet. On github, I see someone has tried to some success. The file is located: To begin with I am interested in the English file Years Foundation to Year 10. English MRAC/2023/07/LA/ENG HTML RDF/XML JSON LD SPARQL You goal is to extract the hierarchy and structure as a usable document to teachers. Learning Area (English) --> Year Level --> Aspect of the Achievement Standard (A sentence) : it may then have General Capabilities

I am seeking a proficient Excel expert to enhance macros within an existing spreadsheet. My primary concern involves re-scripting macros for performance enhancement. On top of this, the spreadheet needs to have its calculation functions updated in certain areas. Hence, the ideal candidate should be comfortable in tweaking and improving formulas for better functionality. I also anticipate that some redundant aspects of the macros may be stripped off as we progress to streamline performance. Required Skills: - Proven Macro scripting and implementation in Excel - Solid understanding and experience in complex formula manipulation - Ability to optimize spreadsheet for improved performance and efficiency. Note: Specific deliverables relating to the calculation changes will be share...

I need a data expert who can perform inferential analysis on a dataset that is less than 1000 rows and columns. This task requires absolute proficiency in Excel, including functions and formulas associated with inferential statistics. Your ability to draw meaningful insights from raw data is essential. Skills Required: - Excel proficiency - Familiarity with inferential analysis - Ability to handle small to medium-sized datasets Experience preferred: - Previous experience in Excel-based inferential data analysis - Proven track record of data interpretation and insights extraction

I require an expert in Google Sheets and ChatGPT to create a system where column A holds factual statements, and column B generates a unique ChatGPT response based on the statement in column A. The prompt will remain constant, with only the input from column A changing the outcome. Ideal Skills: - Google Sheets proficiency - Experience with OpenAI's ChatGPT or similar AI based conversation models - Strong understanding of how to integrate API-based response generators into spreadsheets - Ability to execute tasks seamlessly without creating duplicates or errors. Experience: - Past projects involving integration of AI chat models and spreadsheet software will be advantageous. Note: There is no need for verification of the uniqueness of responses, so your focus should...

I'm searching for a skilled coder knowledgeable in PHP and MySQL databases to build a custom PHP class. We are currently using an old PEAR class and need a custom class written so we do not need to edit all the calls through the entire application. I have attached an example of a query call so you can see exactly how it is handled. So the class would need to support running this code. This class will need the following operations: - Connection to the MySQL database - Execution of SQL queries - Reading, writing, modifying, and deleting data - Creating and dropping tables - Fetching query results - Handling errors and exceptions Your background should include not only experience in PHP and MySQL, but a deep understanding of database operations and SQ...

I am in need of a professional who can assist in changing the database configuration of my Android app from PHPMyAdmin to Eclipse MySQL. This project will involve: - Understanding the current PHPMyAdmin settings in my application and migrating it to suit the MySQL Eclipse environment. - Providing me with the necessary .sql file for the Eclipse platform. Ideal Skillset: - Proficiency in Android app development and database configuration. - In-depth understanding of MySQL and Eclipse platform. - Excellent problem-solving skills and attention to detail. - Proficiency in PHPMyAdmin settings might be beneficial as you need to understand and migrate the existing setup. Note: The MySQL version in use is currently unknown, and additional details about ...

...but also several modifications to the game's existing setup. Key Tasks: - Setting up the Astonia 3 game server on my Linux dedicated server. Previous experience with game server setup is an absolute must for this task. - Implementing modifications or making edits to the established game server to customize for my specific needs. Within the scope of these tasks, a sound understanding of Linux, MySQL, and familiarity with game server architecture will be required. Prior experience with Astonia 3 would be a significant asset. Please provide examples of similar projects and detail your experience with game server setups in your bid. This project requires precise, meticulous execution, and I am eager to collaborate with a professional who can deliver to these standards. spec...

I'm in need of a skilled developer with expertise in AppSheet, Excel, and ERP systems. Your task will be multifaceted, involving various aspects such as: - Data analysis and visualization - Spreadsheet automation - Developing an AppSheet app designed for ERP, focusing on billing, data collection, and data management The main functionalities I am looking for are: - Ability to generate and track invoices - Data entry and validation capabilities - Incorporation of Google Maps API - Budgeting features - Ability to export data to Excel A strong understanding of ERP systems, proficiency in AppSheet, and advanced Excel skills are essential to this role. Experience with Google Maps API is a significant advantage. You should be able to understand the essence and p...

Hi everyone, I will need a computer network analyst (ideally with cisco certification) with experience in measuring network delays, calculate jitter (with tools povided), do some graphs in excel etc. Analytical specific requirements in chat Deadline: 4/4 Budget: $20 USD

I am in need of an advanced Excel spreadsheet that will help track and output several key performance indicators (KPIs) on a monthly basis. The KPI dashboard should integrate the following parameters: - Sales pipeline - Revenue - Over $2,000,000 Per month - Overheads Average 3.75% of revenue for month - Gross profit 12 % - Projects on time >90 % - Defects closed <20 working days - Customer Satisfaction - Employee Productivity - Health and Safety The desired freelancer should have: - Proficient skills in Excel including pivot tables, charts, and formulas - Experience in creating KPI dashboards - Strong understanding of business metrics Please note that the dashboard should be mapped to be updated monthly. The focus is on clarity and ease of interpretation of the...

I'm seeking an expert in Amazon FBA arbitrage research. - You have to be super skilled with Keepa analysis and Buybox history check. - You can work with wholesalers sheets and find hard sourcing products. - As you are interested long term work relationship and understand that the products should be long lasting but not just impress with the numbers - then you want to work on % only based salary from the profit your products make. Each month you will get your passive income. (I have to choose an hourly paid option because there is no % based option to post) I have a good healthy Amazon account and good budget. Please let me know who wants to become a part of my team and work together. Interested freelancers can fill in the questionnaire

I have a task I need automated using an Excel macro. The specific function I need is data filtering from various sheets. - The Macro Task: The job involves creating a macro that filters data to different sheets. - Data Filtering: Notably, the filtering should be done based on specific criteria. I require a system that intelligently separates and filters information to various sheets. - Work Scope: I need the data filtered from multiple sheets, not limited to sheets 2, 3, or 4. The project might involve other sheets as well. Ideal freelancers for this job will have strong experience in Excel macros, data filtering, and automation scripts. Expertise in efficient data handling and manipulation are essential.

We have a requirement to work with Excel Power Pivot, Power Query Editor and prepare a Report. Very normal report and can be completed within couple of hours by an expert. I can pay maximum of INR1500/2000 for this first project but I will ensure, all my future work will be assigned to you. Looking for someone whom I can bank on for future. Thank you!

Hello, im looking for a java microservices expert, the idea is to create an API that provides "real time" information. for this project u should use a simple mongodb, which where store all the data consumed from the next 2 apis (they are free with 200 req. month per email): It should be noted that I am an expert java programmer, so I will thoroughly review the project, so any technical questions can be consulted and I will answer you without problems. *** Fixed budget: 200€. *** Deadline 10 days from start tech stack: -Project should use spring boot -should use docker -mongodb as database -use cron as automatize external api calls (mentioned above) -swagger will be a plus Extra info: The two APIs in

I am looking for a skilled pattern designer to create appealing floral patterns for textile use. The final designs should be artistic and resonate with a youthful audience. The ideal candidate should have: - Proven experience in designing patterns, particularly floral ones. - A good understanding of trends in apparel design. - Be capable of producing designs that is appealing Responsibilities will include: - Producing original floral pattern designs. - Adapting designs to clothing cut-outs. - Incorporating feedback to refine designs. Looking forward to hearing from you! Please include a portfolio or examples of previous pattern work in your proposal.

I'm seeking an expert in Amazon FBA arbitrage research. - You have to be super skilled with Keepa analysis and Buybox history check. - You can work with wholesalers sheets and find hard sourcing products. - As you are interested long term work relationship and understand that the products should be long lasting but not just impress with the numbers - then you want to work on % only based salary from the profit your products make. Each month you will get your passive income. (I have to choose an hourly paid option because there is no % based option to post) I have a good healthy Amazon account and good budget. Please let me know who wants to become a part of my team and work together. Interested freelancers can fill in the questionnaire

I am in need of an Excel specialist who can handle a large dataset of over 51,000 records. The data centers around employee contributions to political candidates. Specifically, I require detailed analysis on: - Contribution patterns - Candidate preferences - Employee demographics As an Excel expert, you should be proficient in working with pivot tables and be able to identify trends within large sets of data. Your experience managing, analyzing, and interpreting datasets should be well demonstrated. In addition, there is a particular interest in providing a thorough analysis of contributions based on political parties. This will help to understand better the political leanings within the dataset. To apply, please highlight your relevant experience. I look forward to seein...

I urgently need proficient help with excel. The tasks to handle include but not limited to; - Data entry. - Data analysis using relevant tools. - Leverage advanced excel formulas and functions to streamline data processing. The data to handle resides within 1-5 sheets and contains both numeric and categorical data. Ideal skills for the job include; - Advanced proficiency in Excel. - Deep knowledge of data analysis methodologies. - Quick data entry skills. - Understanding of Excel functions and formulas. Experience in processing both numeric and categorical data on Excel is crucial.

This project involves using web searching and social media analysis to identify an author's genre. The main task is to examine authors' information and conduct online searches to accurately tag an author's genre. The ultimate goal of this project is to improve the accuracy of author genre identification. -The ideal candidate for this job should have: 1. High-level web research skills 2. Expert understanding of social media analysis, especially Twitter 3. Profound knowledge about different writing genres 4. High accuracy in data tagging This project does not involve extracting any extra information. The focus is completely on identifying the genre of the author.

I'm seeking a detail-oriented freelancer with strong skills in text data entry, Excel, and who is comfortable working with less than 500 pages of data. Key Requirements: - Proficiency in text data entry - Strong familiarity with Excel - Able to handle less than 500 pages of data The ideal freelancer should efficiently turn raw data into an organized Excel spreadsheet. Accuracy is vital in this job, as any mistake could lead to incorrect data analysis. Please provide evidence of your past experience in text data entry and working with Excel.

I would like a new WordPress website I need a theme that I have, which works with elementor, uploading to my webspace then recreating my existing website on the new theme, with customisations (add xx to the start of your proposal or it will not be read). I need customisation and pages adding the theme doesnt have. Services pages, case study pages, then a couple of forms. 12 Case study pages - 10/12 normal pages around 46 blog pages that will have to be moved to the new site with the exact URLS. Please read, bot proposals will be ignored. You must be able to add elementor and this theme to my existing webspace prior to working. ALL URLS and meta descriptions page titles must be the same as existing website but there will be content changes. THIS IS VITAL We want to ...

I am seeking a skilled coder who can create a system that automatically updates my Google Sheets and sends email notifications whenever a new row of specific data - names and contact information or sales data and revenue - is added to my Airtable. Efficiency and accuracy are of utmost importance, as this system will also need to generate reports based on the new data additions. Ideal Skills: - Expertise in Airtable and Google Sheets integration - Proficiency in automation software - Experience in data management, particularly with contact data and sales revenue - Strong understanding of email notifications systems and report generation Requirements: - Set up system to update Google Sheets with new Airtable row additions - Create a trigger to send email notifications ...

For days I have been trying to migrate a database (MSSQL to MySQL) using ODBC Datasource Administrator unfortunately this is not successful I get error 1822 "Missing index for constraint". I'm just doing it as an exercise, it's not a business project. I wanted to know if anyone here could help me with this. I also tried with AWS the problem is the same (constraints), it doesn't work.

Hello, I need a desktop software that will scrape business data automatically with given parameters from the listings. You can develop the software in any programming language you are best. Java, C, C++, or Phyton or any other. Features of the Software This project aims to provide a service to those who are looking for business data from different sources. The project will be set as an online service with different levels of subscription plans. The project will have a website and web panel. Online users will come and select the package suits best them and make the purchase. Once their payment is done, they will be directed to the subscribed user’s web panel and they will check their subscription level and renewal dates. Service fees will be auto-renewable each month. We wil...

Hello, I need a desktop software that will scrape business data automatically with given parameters from the listings. You can develop the software in any programming language you are best. Java, C, C++, or Phyton or any other. Features of the Software This project aims to provide a service to those who are looking for business data from different sources. The project will be set as an online service with different levels of subscription plans. The project will have a website and web panel. Online users will come and select the package suits best them and make the purchase. Once their payment is done, they will be directed to the subscribed user’s web panel and they will check their subscription level and renewal dates. Service fees will be auto-renewable each month. We wil...

writing a grant proposal for the design of a boat

...the use Less congested APIs also make response time at the time of purchase more efficient, such as the Jupiter aggregator v6. 4- With all this information, I'm looking for a developer who has vast knowledge of what was mentioned to update my bot or make one from scratch that works following the same logic 5- important links *program on chain documentation : exemple : *jito priority documentation : *examples of program users that currently run within the Solana blockchain : user hash >program + jito =

...existing website based on a template using XHTML, PHP and CSS. The task is to migrate the existing site content, with a new domain name, onto an already purchased WordPress theme and make new links, upgrades and create some additional pages. A variety of WordPress plug-ins are required. Some are to replace existing functions, while others will add new features to the site. In addition, any End-of-Life MySQL and PHP is to be replaced for current versions and new data bases created. All web-pages should use the templates pre-installed in the WordPress theme, including the additional new web pages. The extra pages will enable site visitors to view up to 10 videos, each showcasing a single room or feature, which provide virtual tours of rooms and locations in the property and have ac...

We are looking for an experienced Figma designer to create a modern, visually appealing, and user-friendly homepage design & 2 Inner Pages for our website. Budget : INR Rs. 1000 Only Responsibilities: Design a responsive and conversion-focused homepage layout & 2 Inner Pages using Figma Ensure the design aligns with given demo concept Demo Design will be provided using canva design Provide at least 2 initial design concepts for review and feedback Iterate and refine the design based on feedback from our team Deliver a clean, well-organized, and commented Figma file with the final design Requirements: Proven experience in designing visually appealing and conversion-focused website homepages using Figma Excellent understanding of UI/UX principles, web design best practices, an...

...billing activities to ensure accountability and compliance. 6. User Management: - Secure management of user accounts and access controls in compliance with HIPAA guidelines. - Training and awareness programs for users to ensure adherence to HIPAA regulations. - Regular review and updates of user access permissions based on job roles and responsibilities. Development Approach: 1. Requirement Analysis: Gather detailed requirements from stakeholders and conduct a risk assessment to identify potential security and compliance risks. 2. Design Phase: Design the system architecture, database schema, and user interfaces with a focus on HIPAA compliance and security. 3. Development: Implement security controls and HIPAA-compliant features using appropriate technologies a...

...exercise materials for Excel, with a particular focus on Excel Macros, Array formulae, forecasting, countif, if statements, and all LOOKUPs. All exercises should come from dataset or data files KEY REQUIREMENTS: - The labs should cover 10 advanced topics, including but not limited to Excel Macros. - For each topic, I need 5 well-thought-out lab exercises created with step-by-step answers. - The exercises must be suitably challenging for advanced-level Excel users. - Each exercise should come with a step-by-step questions and answers guide to aid understanding. IDEAL SKILLS: - Extensive knowledge of Excel, especially in Macros and VBA programming - Proven experience in developing training materials or lab exercises. - Familiarity with financial modeli...

I'm in need of an expertly designed Excel spreadsheet that will serve as a dynamic sales reporting template. This tool will play a significant role in tracking and analyzing data related to various aspects of sales. The successful candidate in this role will incorporate tracking capabilities for variables such as: - Product sales - Revenue by customer - Customer % of revenue Furthermore, the spreadsheet should provide robust reporting on seasonality, current month vs prior year, and fiscal year to date (FYTD) vs the prior year. This comparative analysis is crucial in understanding trends and informing strategic decision making. Ideal Skills and Experience: - Proficiency in Excel - Experience in creating dynamic reporting tools - Understanding of sales data analysis - ...

This project entails creating a Power BI report that is linked to Excel spreadsheets for trend analysis purposes. The main user of this report will be the sales team. I'm seeking a professional with: - Expertise in Power BI and trend analysis - Proficiency in handling and linking Excel spreadsheets to Power BI - Familiarity with sales data and crafting useful reports for sales teams. Your primary objective will be to create a functional, insightful Power BI report, providing our sales team with meaningful trend analysis based on our historical data stored in Excel spreadsheets.

For Excel sheet data typing, you'd be looking for someone proficient in data entry and manipulation, preferably with experience in Excel. Here are the ideal skills and experience: Proficiency in Microsoft Excel Accurate and fast typing skills Attention to detail to ensure accurate data entry Familiarity with common data manipulation tasks in Excel such as formatting, sorting, and filtering Ability to handle large amounts of data efficiently Knowledge of basic formulas and functions in Excel for data analysis and manipulation Experience in working with different types of data formats and structures Strong organizational skills to manage and organize data effectively Ability to troubleshoot and resolve data entry issues Understanding of data privacy a...

Need to upgrade my existing excel macro, very simple project

...our newly established local Badminton club. The website should be created using GoDaddy and should align with our existing logo design. It should also include a booking widget for users to book our sports programs and services. Project Requirements: 1. Design a basic website using GoDaddy: Create a visually appealing and user-friendly website using GoDaddy's platform. 2. Align with logo design: Ensure that the website's design elements, color scheme, and overall theme are consistent with our logo. 3. Create relevant pages: Design essential pages like Home, About Us, Sports Programs, and Contact to effectively present our club's information. 4. Integrate booking widget: Seamlessly integrate our existing booking widget into the website, allowing u...

For this project, I need an individual experienced in data entry to transfer 159 sets of data from an Excel file into an invoice system. I won't specify the exact data to be transferred, but expect that it could be a mix of customer information, product details or payment details. When applying, don't feel the need to highlight past work, experience or provide detailed project proposals unless you feel it is relevant. Expected Organization of Data: - The data must be arranged by date once in the invoice system. Ideal Skills: - Proficiency in Excel and Invoice systems - Strong attention to details - Efficiency and accuracy in data entry.

...Android. Although I am unsure about the main purpose of my app, I am incredibly open to any innovative ideas and collaboration. I expect the developer to provide their concepts and suggestions based on their expertise. Regardless of its ultimate purpose, the app will likely need to adapt and evolve, so I require someone who is flexible and willing to work long-term. Ideal Skills: - Android Studio and Java or Kotlin - Wireframing and UI/UX design - App optimization - Knowledge of the Android SDK and different versions of Android Experience: - Building and releasing mobile apps - Implementing updates and dealing with app version control. - Testing an app to ensure its usability and stability. - Improving an app to increase its performance and speed. I invite Android developers w...

Unify TXT files into Excel. (This data is good) This is a data merge project. Merge data from 3 txt files into excel. This is NOT a simply copy paste. The data needs merged. The data from 2 of the files will become columns of data in the 'master file' (see below) Download 2 files from here: Download 1 file from here: Note: This is public data it is completely permisable to use it. The files listed are: Deeds - don't use this file Owner: 1,817,424 lines. Step #1 for this file: Delete all rows that the aka pct_own is 0.000. This data will become columns of data in the master file ie: Owner 1 ln_num

...need someone who can write a compelling personal statement. The statement must be 2-3 pages long, showcasing both my work experience and academic achievements, as well as my background in a balanced manner. Resourceful wordsmiths with experience in drafting personal statements for law school applicants are highly desired. A background in law education or understanding the demands of top-tier law institutions would be a plus. You should be able supply proof of similar work to support your bid. Main duties: - Create a balanced narrative that encompasses my work experience and academic accomplishments, as well as my background - Adhere to the 2-3 page limit while maximizing impact - Create a convincing argument for my admission to Law Schools that offer online JD programs...

The function (I didn't write it): input: Path of a video file. [would be nice to also allow audio files] output: Array of the volume of all frames of the file. PHP Version 7.2.34 Edition Windows 10 Home Version 22H2 Installed on ‎11/‎7/‎2020 OS build 19045.4170 Experience Windows Feature Experience Pack 1000.19054.1000.0 Device name DESKTOP-TBNFM6D Processor Intel(R) Core(TM) i3-10100 CPU @ 3.60GHz 3.60 GHz Installed RAM 8.00 GB (7.85 GB usable) Device ID 0334C4DF-2DEE-401E-A453-E30F4EB12586 Product ID 00325-81840-60585-AAOEM System type 64-bit operating system, x64-based processor Pen and touch No pen or touch input is available for this display

For this project, I need an individual experienced in data entry to transfer 159 sets of data from an Excel file into an invoice system. I won't specify the exact data to be transferred, but expect that it could be a mix of customer information, product details or payment details. When applying, don't feel the need to highlight past work, experience or provide detailed project proposals unless you feel it is relevant. Expected Organization of Data: - The data must be arranged by date once in the invoice system. Ideal Skills: - Proficiency in Excel and Invoice systems - Strong attention to details - Efficiency and accuracy in data entry.