Excel sql database jobs
We're on the lookout for self-motivated sales reps ready to roll up their sleeves and boost their earnings with our natural herbal products. With a proven track record and satisfied customers, our products offer a lucrative opportunity for those willing to put in the effort. Responsibilities: Drive sales of our natural herbal products to prospective cus...profit-sharing opportunity. As you contribute to our products' success, you'll share in the profits generated. If you're hungry for success and eager to boost your earnings through hard work, this is the opportunity for you! Join us in spreading the benefits of our natural herbal products far and wide. Ready to seize this opportunity? Submit your application detailing your drive and determination to excel in...
I need a custom database designed to keep track of various interchangeable machine parts. The purpose of this project is to have a clear and updated view of the present location of these assets. Key elements will include: - A user-friendly graphical user interface - Data entry for assets (machine parts) - Location tracking of assets - tracking of repairs Ideal freelancers for this project would have experience in database architecture, GUI design, and asset tracking solutions. Previous work in heavy machinery or similar industries would be a bonus. A thorough understanding of data privacy and security is also necessary.
Hello, I have around 400 Postcodes in the UK, and out of those 300 are already done, so you need to search for the remaining postcodes on a website, I will provide you with all the ...remaining postcodes on a website, I will provide you with all the details along with a video tutorial + other details I will provide through WhatsApp messaging and calls. You will know about taking screenshots, I have a free Chrome tool, and I will provide it. it's a Very Urgent Project, so if you can start work Immediately and finish within the next 24 hours, then only apply. You should know the Excel and web-based copy/paste knowledge. This is a challenging job, and who can handle the pressure, the right candidate can get regular work. Hindi-speaking people will get preference. Happy B...
...and jackpot. 3 - Webcam Streaming: Integrate WebRTC or RTMP for live streaming. Capture and display player webcams during gameplay with content monitoring. 4 - Pre-recorded AI Host: Scripted responses. 5 - Frontend and Backend: Develop responsive UI using HTML/CSS/JavaScript. This will be web based with Mobile compatibility. Set up APIs for game flow and AI interactions. Store data in a database. 6 - Security and Privacy: Secure webcam streams and handle user data safely along with content monitoring. 7 - Testing and Deployment: Test components thoroughly. Deploy on a cloud platform. 8 - Monetization: ads, premium features, or in-app purchases. The following skills will be needed: Web Development Skills: Frontend Development: HTML, CSS, and JavaScript: Cr...
I'm in need of a proficient individual with strong data extraction skills and a good knowledge of Excel. The task is focused on extracting both text and image data from 1-2 websites. It is essential for the freelancer to have capabilities in: • Website data extraction • Handling of both text and image data • Organizing and managing the extracted data in Excel. An eye for detail and a knack for organization would be key for this project. Experience in similar projects is also a great advantage. This task requires utmost accuracy and adherence to deadlines, thus a freelancer with a track record for prompt delivery would be ideal.
I need a skilled professional to import news posts from a pre-existing database to my WordPress website. The task includes importing the following components: - Post Title - Post Author - Post Category - Post Description - Image inside Posts - Featured Image Given the data-oriented nature of this task, proficiency in database management and experience with WordPress is critical. A solid understanding of data mapping is also highly desirable to ensure accurate alignment between the source database and the WordPress system. The completion timeline for this project is within two weeks. I appreciate a candidate who can work efficiently and communicate progress regularly.
I need an expert to assist with converting PDF and Excel files into IIF to incorporate into my QuickBooks accounting software. This integration will be key in the transparency and efficiency of my financial transactions. Key responsibilities: - Convert files from PDF and Excel to IIF. - Ensure compatible formatting with QuickBooks. - Sort IIF files by transaction type for easy navigation and organization. Skills and experience: - Proficient in QuickBooks and IIF format. - Accurate data entry. - Deep understanding of accounting principles and financial data organization.
We are currently looking for experienced writers to produce high-quality articles on Python programming. We are shari...for experienced writers to produce high-quality articles on Python programming. We are sharing a few topics that we would like you to write about. Not less than 1500 words, with sample code and screenshots if necessary, with grammarly and plagiarism checks done. Each article should be in Word document. Per article, INR 500. versus Python Key differences Python certificates 3..SQL versus Python , which one to learn Libraries for Datascience 5.10 Python Tips and Tricks Every Developer Should Know with Databases in python Python Functions of Iron python Python in C# Applications Giants that use python
Data collection for the markets of Spain, Portugal and Mexico. A B2C database needs to be generated for each of the above markets Need a specialist is Scraping Data of Websites and Applications The budget is oriented to the amount of data obtained, which would be approximately 250€ x million, depending on the fields obtained per registration. Deadline: Collection should be available within a maximum of 10 days
I'm looking for a skilled individual with a keen eye for detail to create an Excel spreadsheet. This sheet will be handling different insurance companies' appetite guidelines, which are broken down by state. For example, I need to know which carriers write workers compensation in New Jersey Key Requirements are: - Excellent knowledge of Microsoft Excel for data organization and management. In your application, please include your asking price for this fixed rate project. Previous experience in the insurance field or with similar projects would be a plus but isn't a necessity. Looking forward to finding the best fit for this data-driven venture.
If you know how to code a javascript or python script to get a few pieces of information from Google, then this is easy for you. Here's all we need in this small project: 1. For a particular google search ON MAPs, the program would output the web URL, and name and send that to excel (or a csv) - other fields would be provided to include as well. 2. It should let me pick 1-50 entries. 3. It should work from within the browser (NO API calls necessary). that's it! Thanks for your bid
I'm seeking an expert to create an ...aggregating training metrics from an eLearning Management System database. It is essential that Excel functions are automated, and feeding data into this dashboard should be user-friendly. Key responsibilities: - Design a dashboard that will display updated training metrics from a database - Automate Excel functions - Allow user-friendly data import Ideal candidate: - Proficient in Excel - Knowledge of DBMS (Database Management Systems) - Familiar with eLearning Management Systems - Experience in creating user-friendly interfaces - Strong time management skills, as the project needs to be completed within a month Our understanding of the exact DBMS is currently unclear; thus the freelancer needs to be ...
Hello there is a free publicly accessible Google spreadsheet with 185 lines and 21 columns. Copy and download is disable. I need someone who is still able to copy the data into an excel spreadsheet or otherwise manually "copy" all data into an excel spreedsheet thanks I offer the link to the website after receiving bids Generic bids are ignored. Therefore pls write "i understand its a download disables google spreadsheet."
I'm looking for a skilled data science trainer who can introduce my large team to the foundational aspects of the field. Key Responsibilities: • Deliver beginner level lectures on data science • Train over 10 team members • Cover areas inclusive of Data Analysis, Machine Learning, and Predictive Modelling Ideal Candidate: • Ex...Machine Learning, and Predictive Modelling Ideal Candidate: • Expertise in data science education • Ability to conduct engaging, accessible training sessions • In-depth knowledge of Data Analysis, Machine Learning, Predictive Modelling • Experience in training larger groups The objective of this training is to equip my team with basic data science capabilities. Thus, patient trainers who excel in bre...
I need a skilled and creative freelancer to create 100 different invoices for me in Excel. Each invoice must have its own distinct company design and company logo. Here are the specifics of the project: - I am giving you complete creative freedom to design each invoice. Let your mind run wild! - The invoices should include placeholder information whilst also leaving some areas blank. This will provide a more customizable experience. Ideal skill set includes: - Proficiency in Excel - Graphic design inclination - Creative thinking - Attention to detail Looking forward to seeing your brilliant designs shine on each invoice.
I'm looking for an expert PHP developer with proficiency in Codigniter to modify and en...enhance an existing script I bought from CodeCanyon. Task Details: • Modify existing functionality and add new features to the script. • Add three new fields to the signup window code and sync it with the mySQL database. These fields should include text fields and dropdown menus. • Create a report based on data from one table in the mySQL database. • Implement a feature to export the report data to Excel. Ideal Skills and Experience: • PHP and Codigniter expertise • Experience with SQL database manipulation • Knowledge in report generation and data exporting to Excel • Proficient in UI design with a foc...
I'm in need of a developer to build a simple CRUD website. A few specifics about my requirements: 1. The website should interact with an Excel file; enabling data extraction and modification directly from and to the file and Display the records in a grid or tabular format. 2. Search option to look for connection details with Applicant ID. 3. Add a date picker to filter via date range via date of application. 4. Option to view/edit electricity connection application requests. a. Refer dataset for the data attributes. b. Could be on same or different page. 5. Data Validation. a. Should not be allowed to change some data and put validations on a few fields. Nothing complex. 6. Create a visualization graph e.g., bar or line chart for number of connection requests in every month. Th...
I require a freelancer who is proficient in extracting specific data points from a PDF document and translating it into a structured Excel or CSV file. The data is presented within paragraphs. Key Tasks: 1. Extract the following elements from the PDF: Names, dates, numerical values, lead location, phone number, email, US dollar value, status, date added. 2. Organise these elements in a structured format in an Excel or CSV file. Skills Required: - Attention to detail - Proficiency in data extraction - Strong knowledge of Excel or similar data management software - Ability to interpret information from paragraphs. Freelancer should assure accuracy as the correctness of extracted data is essential.
I am seeking a skilled freelancer with experience in SQL to develop a utility program for my company. We utilize a ZKTeco fingerprint machine for tracking attendance, but the standard reports it generates are not meeting our needs. My hope is to have this application improve the readability and functionality of these reports. The tasks you'd undertake: - Building a lightweight application that can process the .dat files generated by the machine. This application should not merely replicate the machine's output but offer new ways to view and sort the information. Key features I'd like to see: - Ability to view attendance trends, which is not possible with the machine's default output. - Enhanced sort capabilities, allowing organization by department. To be su...
...information. -Ensure all guest details, including name, email, phone number, reservation number, booking period, and payment information, are promptly forwarded for record-keeping and follow-up purposes. Requirements: -Strong attention to detail and accuracy in task execution. -College degree or equivalent qualification preferred. -Proficiency in basic software tools, including Microsoft Office (Word & Excel). -Ability to operate electronic devices (computer or phone) proficiently. -Fast-paced and adaptable to changing priorities. -Ability to commit to 10-30 hours per week, approximately 2-4 hours per day. -Willingness to undergo a short trial test or task, lasting 2-4 hours, with the possibility of extension up to one week if necessary. Duration: The duration of the jo...
I am presently working on an extensive project involving several excel spreadsheets. These spreadsheets contain sentences for a book and I require a freelancer to help me color code the cells based on different categories. The color will represent different aspects of each category. The color coding will include: - More than 10 different categories - Existing color suggestions that need refining - Categorization that's based on multiple factors, going beyond the book chapters The ideal freelancer for this job should possess a good understanding of Excel and have a knack for good organization and attention to detail. Strong collaboration and communication skills are key, as I'll need to discuss and finalize the color scheme and the factors affecting categorization...
I'm in need of a proficient Excel expert who can proficiently apply formulas to my dataset. Here's what you'll be taking on: - Add 'Sum', 'Average' and 'Count' functions to the given data set. Your expertise in implementing these formulas will be highly valuable. - The dataset needs to be sorted based on validity. I'm not entirely certain whether ascending or descending order would work best, so I'm open to your professional advice. - Prioritization should be given to the most recent entries. They should appear at the top of the dataset after sorting. To succeed in this task, you must possess advanced understanding of Excel functionality and a keen eye for detail. An ability to work independently, make efficient decisi...
I need an experienced full stack web developer for a project. The purpose of the website hasn't been decided yet and would appreciate your insights. The visual style is also open for suggestions. What I look for in potential candidates: * Mastery in HTML, CSS, JavaScript, PHP, SQL. * Proven full stack development experience. * Flexibility to adapt to project deliverables. To apply, please provide the following: * Examples of your past work. * Your experience in web development. * A detailed work proposal for this project. Looking forward to working with an experienced and creative professional who can steer this project successfully.
I require assistance with port forwarding for my MySQL 5.7 database installed on a Windows operating system. I want to configure it to be accessible publicly on the internet. The desired freelancer should have the following skills and experience: • Knowledge of and experience with Windows operating systems • Understanding of MySQL 5.7 databases • Familiarity with port forwarding procedures • IP configuration expertise for public internet access The goal of this project is to ensure safe, secure, and proper configuration for public internet access without any compromise on performance. Can you help me achieve this?
Need nay type of data entry work
Hello, I and creating a 3-year business plan. I have the first-year projection but I need to calculate the subsequent years, both 2 and 3. I need to add 15% each year which I am using year one as a basis to calculate and add 15 percent each year.
...validate data from an excel file to a database. This function should be equipped with the following features: 1. Data Type Validation 2. Data Format Validation This task requires proficiency in database structures, data validation methods, and experience working with Excel file manipulation. The ideal candidate, consequently, should be able to display capabilities in these areas. Their experience in similar projects would be a bonus. Here is the main flow: 1. User upload excel file 2. System will check and validate the data 3. System saves record into multiple tables in a database 2 types of excel files involved. Please check attachments. 3 types of data will be stored into database 1. User profile 2. User farm 3. User plan...
I am seeking a skilled Python developer to spearhead the migration of my company's databases from our ...Microsoft Azure, and with a wide range of databases including MySQL, PostgreSQL, and MongoDB. It's crucial that the freelancer I hire has a clear understanding of high availability, scalability, and data security as these areas were not ruled out as possible requirements during the migration process. Experienced freelancers will know to consider these crucial components as part of the standard database migration strategy to the cloud. Skills and Experience: - Proven experience with Python programming - Familiarity with multiple cloud providers (AWS, GCP, Azure) - Knowledge of various databases (MySQL, PostgreSQL, MongoDB) - High availability, scalability, and data sec...
I am struggling with a VBA Excel file where the Macro is not running correctly, and I need someone proficient with VBA and debugging to fix it. The file is crashing frequently, which is causing significant delays and impacting efficiency. • **Macro Issue:** The macro is not running and I am unable to debug or fix it myself. I need an expert who can look into the problem, define what's wrong, and provide a solution that works flawlessly. • **Purpose of the Macro:** I will discuss this further with the successful applicant, but rest assured that your tasks will align with typical VBA Macro functions. Since the purpose of this macro hasn't been disclosed, I am expecting you to have experience with commonly used VBA functions like automated data entry, formatting d...
I am in need of a highly skilled PHP and SQL professional who can assist with a redesign of my output table. The specific requirements for this project are: - Improvement of the layout and design, with an emphasis on improving the clarity of information presented in the table. - The addition of new columns or fields is not required. Instead, focus on reshaping the data structure to make the displayed data easier to digest. Ideal candidates for this job will have a solid background in PHP and SQL and a portfolio demonstrating their knack for user-friendly, clear, and efficient data displays. Understanding of modern aesthetic elements and color schemes is appreciated, though not the primary focus of this project.
...that can access data records from my continuously updated local Microsoft SQL Server. Both solutions should allow for real-time data extraction and display. Key Requirements: - Develop a mobile application compatible with the latest smartphones. - Create a responsive website that can be accessed on various devices. - The apps need to accurately access and display data from a Microsoft SQL Server data base. Ideal Skills and Experience: - Proficiency in mobile application development (iOS and Android Operating Systems) - Skilled in web-based programming languages such as HTML, CSS, JavaScript, and PHP. - Strong understanding of database connectivity and manipulation using SQL. - Prior experience with Microsoft SQL Server is mandatory. - Ability to d...
...so the history and mission of our company. Introduction of our individual team members is not necessary for this project. • Services Page: This page will enumerate and explain the consulting services we offer, providing potential clients with a detailed understanding of what we can offer. A Developer with a strong background in Wordpress and a good understanding of UI/UX best practices will excel in this project. Proficiency in both front-end and back-end development is paramount. Also, having a history with similar consulting websites will be a significant plus. In your proposal, please include examples of prior consulting websites you've created....
Iam looking for passionate Full-Stack Developer with a keen eye for visual design. Technical Skills: Proficient in PHP and Angular or Vue frontend. Experienced with Microsoft SQL Server for database management and Familiar with stored procedures in SQL for database queries Strong understanding of user authentication and authorization (login, validation, management) Adept at CSV file manipulation and validation such as: parsing, data transformation, Aggregation, Joining and Merging, exporting, Find, edit or remove duplicates, Consolidate data, convert data types, clean data, Skilled in error handling and debugging to ensure application stability Experience with UI/UX design principles to create an intuitive user interface Functionality to import and manipulat...
I am in need of an expert in Excel who can provide assistance in managing multiple sheets in an Excel file. The spreadsheet requires extensive data analysis, formula creation, and formatting. Key requirements include: - Ability to analyze complex data across multiple spreadsheets - Proficiency in creating advanced Excel formulas to automate processes - Expertise in formatting spreadsheets for ease of use and understanding While I have advanced proficiency in Excel, I need someone capable of handling these tasks efficiently. A background in data science or similar is desirable.
...Requirement- The requirement to copy from the "R" until the last row last string, such as W1 in the example. The data will be pasted in the cell right below the link, in this example is Cell B7. 6. Requirement- When the spreadsheet is opened, there should be an option if i want to refresh all the links, or remain as it is. 7. Requirement- Computation or refresh of the data should be within the Excel file itself, if an external programme is required, i can consider if it is not too complex. 8. Requirement- must be able to add to this list as it is not complete and there are always changes For 2nd link 3. In the Worksheet "Link 2", this is for the pasting of data from the weblink 4. The link for testing is , cell A2. 5. Requirement- There
...that can access data records from my continuously updated local Microsoft SQL Server. Both solutions should allow for real-time data extraction and display. Key Requirements: - Develop a mobile application compatible with the latest smartphones. - Create a responsive website that can be accessed on various devices. - The apps need to accurately access and display data from a Microsoft SQL Server data base. Ideal Skills and Experience: - Proficiency in mobile application development (iOS and Android Operating Systems) - Skilled in web-based programming languages such as HTML, CSS, JavaScript, and PHP. - Strong understanding of database connectivity and manipulation using SQL. - Prior experience with Microsoft SQL Server is mandatory. - Ability to d...
I need a proficient PHP and SQL expert who can troubleshoot why my output isn't correct. Currently, I am facing a problem where my output is missing vital product details. Ideally, any freelancer bidding on this project should have proven experience in managing and rectifying this specific issue. Key skills required would include advanced proficiency in PHP and SQL, problem-solving abilities, and a keen eye for detail.
I'm seeking a profoundly competent PHP and SQL expert who can effectively conduct data analysis on user behavior data, Your crucial responsibility is to: - Analyse the data and provide notable insights into user click-through rates. Ideal skills: - Proficiency in PHP and SQL - Sound knowledge in data analysis of user behavior data - Understanding of click-through rates - Proven experience in similar project This task requires precision and attention to detail, eluding the median for an analytical mind.
Looking for an expert in data extraction and management, specifically from Websites, APIs, and Databases. The project involves extracting numerical data daily and...extraction and management, specifically from Websites, APIs, and Databases. The project involves extracting numerical data daily and integrating the information smoothly into an excel sheet. Skills & Experience Required: - Expertise in data extraction. - Proficient in API integration. - Experience with database management. - Excellent skills in Excel data manipulation. Responsibilities: - Setup extraction from multiple data sources (Websites, APIs, Databases) using Zapier. - Ensure extraction of numerical data only. - Secure daily extraction and update of the information. - Seamless integration of t...
I am in dir...Your core responsibilities will include: - Data Entry: You should be familiar with Microsoft Excel, as a significant part of your job will be related to entering and managing data in a structured, orderly manner. - Email Management: Not only will you be tasked with responding to inquiries on my behalf, but you'll also be setting up automated responses to maximize efficiency and ensure no email goes unanswered. - Scheduling: You will also help in scheduling meetings. This will involve coordinating with multiple parties to find suitable times. Ideal candidates should have prior experience in administrative roles and should be proactive with excellent communication skills. Mastery of Microsoft Excel is a must, and previous experience with email management ...
I require a programmer to create a robust database querying application. The application should be proficient in MySQL, capable of siphoning off a resource management database via an easily customizable configuration file for test and real-time data queries. Key Features: - Ability to alert me via email in case of any significant changes or issues. - Ability to produce output in a PDF format for easy documentation and read-outs. - Emphasis on clean, professional, and corporate design visuals. The Ideal Candidate: - Strong database management background, especially in MySQL. - Proficient in diverse programming languages to keep the program open-ended. - Should have exceptional skills in developing and handling configuration files. - Experience in developing corpora...
Th...To successfully meet the project's goals, I require a specialist in email scraping to obtain addresses for real estate agents across South Africa and the UK. The target website where these emails will be extracted from is Property24. Of utmost importance and unique to this project is the regional scope. It should cover all regions, without exclusions, within the two countries mentioned. To excel in this project, having the following skills/experience would be ideal: - Strong experience in email scraping - Familiarity with the Property24 platform - Sound understanding of real estate markets in South Africa and the UK - Ability to accurately segment data by region Your commitment to accuracy and attention to detail will strongly influence the success of our subsequent l...
I'm seeking an expert .NET developer with a strong background in SQL database management, time management, and ERP systems. Your main responsibility will be to seamlessly integrate existing systems for improved efficiencies. Ideal Skills and Experience: - Expertise in ASP.NET development. - Proficiency in SQL database management, ensuring secure and efficient data manipulation. - Solid experience with ERP systems to streamline business processes. - Excellent time management skills, meeting the deadlines without compromising on quality. - Previous work with system integration projects will be highly advantageous. Bring your strategic problem-solving skills to this project and contribute to enhancing our business operations.
I am looking for an experienced VBA developer to create a custom add-in for Excel. This project will require: - Developing custom functions to automate the generation of multiple types of charts in Excel, specifically pie charts, bar charts, and line charts. - These charts should be formatted according to our specific design requirements, including our house style and measurements. The ideal freelancer will have exceptional skills and experience in VBA and Excel add-in development. I expect a strong understanding of data analysis and an excellent ability to perform tasks accurately and efficiently. Furthermore, I value clear and regular communication so we can ensure the end result meets our expectations. Please only apply if you are confident you can deliver th...
I need a large volume of (Female) dating profiles with the following information: Name, age, bio, interests and pictures (min 2 per profile, but more is nice). Preferably in SQL or CSV. You can scrape them from other dating sites for exmaple, I need previews before buying. More details: Is this project for business or personal use? Personal What information should successful freelancers include in their application? Experience How soon do you need your project completed? ASAP
I'm in urgent need of a web based applicat...transforms PDF files, largely bank statements, into Excel layouts. Key Features: - The application should have batch conversion support, allowing numerous files to be converted at the same time. - It needs to have OCR (Optical Character Recognition) capability for pinpointing and extracting info from scanned PDFs. - Its operation should be secure with user authentication and access control features to maintain data privacy. Ideal candidate skills: - Robust experience in web application development - Familiarity with OCR technology - Knowledge in building secure applications with user authentication and access controls - Ability to work under pressure to fulfill project needs ASAP P.S: Keep in mind, the goal is to produce files i...
Today, I need a professional with deep understanding of database creation and Excel data organization to produce a new, streamlined database from my current Excel one. Key Project Requirements: - Convert an Excel database with 1-10 sheets/tabs into a new database system. - Your task is to simplify and streamline the layout of the data for ease of use, without losing critical information. - While expertise in Excel is a must, experience with other database systems is also necessary, considering we might need a smoother platform than Excel. Ideal Candidate Skills: - Thorough experience working with Excel and other database systems. - Exceptional at delivering swiftly to meet today's deadline. - Exce...
I need an experienced data scraper who can extract specific information from a horse racing website. Your task will be to gather data on past horse race records, focusing on: - Horse Names - Race Dates - Horse Positions - And the complete data from the table What I need is for this information to be extracted from the website and then outputted into an Excel file. Proficiency in Data Scraping tools and Excel is mandatory for this task. Prior experience with similar sports data scraping will be highly advantageous. Efficiency and accuracy are crucial in this project.
