Java programs read excel sheets write mysql database jobs

I am in need of an Excel guru to assist with my project involving fewer than 5 sheets. Help is needed to organize and format data effectively. Beyond just basic formatting, the project also requires the use of advanced formulas, specifically VLOOKUP and INDEX MATCH. The ideal freelancer for this task should have: - Expert knowledge in Excel formatting and data organization - Proven experience in creating and using advanced Excel formulas like VLOOKUP or INDEX MATCH - Strong attention to detail and focus on data accuracy - The ability to complete tasks efficiently and on time. Rest assured, if this project is successful, there could be more opportunities for similar jobs in the future. Looking forward to your bids.

I'm looking for a proficient Excel expert with extensive experience in data cleaning to assist with a key task. Your primary responsibilities will include: - Identifying and removing duplicate data entries in Excel, Data cleaning - Creating Pivot tables and data aggregations - Efficient dashboard and visuals that showcases trends and patterns via graphical data representation. Please only bid if you are seasoned in creating pivot tables, using Power query and generating visually appealing data insights. Precision and attention to detail are essential skills for this project.

For this project, I need a skilled developer to create a data visualization webpage, similar to Google Earth. Ideal candidates should have a strong background in JavaScript, Python, a...shared with the selected freelancer. - Data: The website's function will be to display GPS coordinates (latitude and longitude) alongside relevant site information when hovered over. This would include Site Name, Site Description, and Site Statistics. - Source: All required data is contained in an Excel sheet which I will provide. The ideal freelancer would have experience in data visualization, and expertise in the programming languages mentioned. Additionally, a proficiency in working with Excel data is necessary. Detailed requirements and design specifics will be shared upon commen...

...in gathering text data from online resources and flawlessly entering it onto a spreadsheet. Key Responsibilities: - Sourcing text data from specified online resources - Accurately entering data onto a spreadsheet with minimal errors - Ensuring data entries are formatted correctly and uniformly within the spreadsheet Ideal Skills and Experience: - Proficiency in using spreadsheets: Microsoft Excel or an equivalent is required - Strong attention to detail: This is crucial to avoid mistakes in data entry - Experience in online research: Being able to quickly and efficiently find reliable online resources - Previous experience in data entry: A strong foundation in data entry tasks is desired. This project requires speed, accuracy, and a commitment to meeting set deadlines. If...

I am in need of a MySQL/MariaDB professional who can efficiently optimize my current database setup for larger queries. As the main area needing improvement is speed, the successful candidate will be those who can increase efficiency with minimal disruption. Key responsibilities will include, but are not limited to: * Enhancing database structure; this may include revisions in indexing or query optimization techniques. * Utilizing past experience and success stories in database speed optimization to further benefit this project. In your application, please include examples of past work where speed was dramatically improved through your interventions. This task demands significant MySQL/MariaDB experience, with a strong focus on developing and implement...

I am seeking a skilled Java developer to enhance the user experience of an existing project. The primary focus will be on GUI development and Networking—not data processing. Key Tasks: - Enhance user-interface design - Improve networking capabilities Skills & Experience: - Expert in Java development - Proven experience in GUI development - Strong knowledge of networking principles When applying, please abstain from providing project proposals or information on past work. Your technical skills and comprehension of the brief will be paramount. The primary objective is to enhance the user experience. If you embody a strong understanding of Java, and the aforementioned components, you'll be considered for this role.

...a talented and passionate freelance developer excited about artificial intelligence and cutting-edge technologies to join our innovative project at the intersection of AI and entertainment. If you have proven expertise in API integration, especially with OpenAI, and solid experience with Google services (Docs, Sheets, Drive), we would love to meet you. Missions: Integrate the OpenAI API to develop advanced interaction and content analysis functionalities. Utilize Google Docs, Sheets, and Drive APIs for creating, editing, and managing dynamic content. Collaborate with our team to develop and deploy a real-time moderation bot on Discord. Participate in the full development cycle: design, development, testing, and deployment. Profile Sought: Deep expertise in API integration,...

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