How to write sql query in excel sheet jobs

...actionable content? If so, we want you on our team! We're on the hunt for a highly proficient Course Creator to join us in developing a groundbreaking program: the "3-Day Weekend Reset." This course is designed to address overuse of behaviors or substances, offering participants a comprehensive toolkit for reclaiming balance and wellness in their lives. As our Course Creator, you'll be tasked with bringing this vision to life across various Learning Management Systems (LMS) platforms, including Podia, Kajabi, Thinkific, UpSkill, and more. Your expertise will shine as you meticulously design each aspect of the course, from rewriting copy to timing content delivery and conducting a final test to ensure efficacy. Here&...

I need a freelancer with a deep understanding of Excel ,data management and social media to extract info from profile list that we have . As the project involves organizing approximately 20,000 rows of data, proficiency in handling large datasets will get you far in this task. Key Project Details: - Data Type: The data primarily comprises email addresses and phone numbers. - Links in Profile - Other profiles in the profile - Formatting: The data files contain labels, so you'll need to distinguish this information keenly. Ideal Skills: - Proficient in Excel - Expertise in data management - Data Scraper

I'm in need of a business plan financial forecasting expert to create the financial statements for my business plan. The main purpose of the business plan is to secure a business startup loan. Key requirements: - Develop a comprehensive financial forecast that includes income statement, balance sheet, and cash flow statement - Provide a detailed explanation of the assumptions used in the forecast - Ensure the financials are aligned with the business plan's goals and objectives - Experience in preparing financial forecasts for services industry is a plus. - Previous success in helping clients secure business loans is highly desired.

Please Sign Up or Login to see details.

I'm looking to establish a Cloudflare tunnel to secure traffic and enable safe connection between my on-premise SQL server and Cloudflare CDN. The main emphasis is to foster a secure pathway for my SaaS application to interact with the SQL Server. The core tasks involved include: - Configuration of Cloudflare tunnel to connect saas app to sql server A background in network security, CDN configuration, and Cloudflare Tunnel would be ideal. Proficiency in SQL Server database administration, as well as a working knowledge of CMS SaaS applications, is a key asset for this project.

I need an expert with strong Excel skills to create two simple line graphs. Though I didn't provide specifics, these will be used to illustrate financial data, so experience in creating graphs for financial analysis would be ideal. Fast turnaround is critical. I will share 2 images of sample graphs. You need to put same data but have to create it line graph and in excel. I need this now. If you can't do now then please dont waste my time.

I require a professional who can develop a detailed sales forecasting report leveraging Power BI. The project needs to be done within one day. Key Requirements: - Utilize data from Excel spreadsheets for the forecasting. - The sales forecast should be detailed, breaking down sales by product/service. - The forecasting model should be based on regression analysis. Ideal Skills: - Proficiency in Power BI. - Strong experience in Excel data analysis. - Proven track record in regression analysis for sales forecasting. - Ability to work under tight deadlines.

I am in need of a Visual Basics code in Excel that specifically focuses on equipment check-in and check-out functionality, while also automatically creating a record for each transaction. Key Features: - Equipment Check-in and Check-out: The primary purpose of the program is to allow users to easily check equipment in and out. - Automatic Inventory Status Update: The program should update the inventory status automatically, ensuring that the availability of each item is always up to date. Additional Features: - Daily Reports: The program should generate daily check-in and check-out reports - this would be beneficial for managing equipment usage and tracking. - Statistics: The program should also provide statistics on e...

Transferring data from a jpg file to an excel table. With online access via google

I'm looking for a Power BI expert to help me set up a robust sales forecasting system. Responsibilities: - Integrate my Excel spreadsheets into Power BI Desktop - Design visually appealing and intuitive dashboards that clearly display sales forecasts - Utilize Power BI's capabilities to predict sales trends Ideal Skills: - Proficiency in Power BI Desktop - Expertise in Excel spreadsheet integration - Proven track record in sales forecasting - Strong communication skills to understand my business and its sales forecasting needs This project requires someone who can not only set up the technical aspects but also has a deep understanding of sales forecasting.

I am looking for a data expert familiar with Microsoft SQL Server Management Studio who can help me export data specifically for analysis. The data will need to be exported as is, with no transformations or filters applied. The final output should be an Excel file which can be used for our upcoming project. Ideal Skills and Experience: 1. Proficient in Microsoft SQL Server Management Studio 2. Experience in data export to Excel 3. Understanding the importance of data cleanliness and integrity 4. Able to deliver work with accuracy and speed.

I have a set of less than 10 excel spreadsheets that I use for various purposes. I'm looking for a talented professional who can re-work these sheets eliminating redundancy. Key objectives: - The primary goal of this rework is to automate repetitive tasks. I'm looking for someone who can introduce VBA scripts and macros to help me achieve this. - The spreadsheets are both independent and share common data. It will be important to create a system that can handle both types of sheets. Ideal skills: - Proficiency in Excel, VBA, and Macro programming is a must - Experience with data manipulation and automation - Ability to understand and work with a mix of independent and shared data I'm open to discussing the project r...

...GPT-4 on my PHP coded site. It used to update a data field in SQL using OpenAI but it has inexplicably stopped. Traits required for a successful freelancer: • Proficiency in PHP • OpenAI and API chat GPT-4 debugging expertise • Experience in working with SQL Your task includes: • Identifying what exactly needs fixing which might be in the OpenAI, PHP code or both • Establishing that no recent changes have been made to the PHP code or OpenAI integration • Determining why our system, on the admin side, shows no updates were done (The field that should be green is appearing red) Your task won't involve: • Expecting any specific error messages when the API chat function stops working as t...

...a proficient web data scraper to extract specific information from a prominent South African property portal and organize it in an Excel spreadsheet. Key Project Requirements: - Extracting and organizing the following data: property information (e.g., price, location) and size. - No need for continual updates, just a one-time extraction. Filtering Criteria: - The data to be scraped should be from a particular property portal and should extract information like : property type (industrial/retail/office), size, address, price. Ideal Skills: - Proficiency in web scraping techniques and tools. - Strong experience with Excel and organizing large sets of data. - Familiarity with the South African property market would be a plus. The goal of thi...

...project demands high-quality research skills. You will need to locate and verify the schools that meet our criteria. - Mapping: Proficiency in using online mapping tools is essential. - Data Management: The final report should be in Excel format. Experience handling and analyzing data in Excel is a must. - Need to confirm they have sports facilities - Data needed is Name of school - distance to tube - address - Phone number off the school site There is a list of 151 schools already on the list these will be provided and can not be used. The budget is $25 to start but if it goes well will become full-time for 4 to 12 weeks. We have other areas outside London coming up as well. The final output should be a compre...

convert gramms per second to litres per m thermodynamics fluid in excel calcualtor pv=nrt

I'm looking for a skilled software engineer well-versed in Progressive Web Applications (PWA), Microsoft Blazor, SQL Server, and Web Services. Your task will be to enhance our current application. Important details include: The ideal candidate should have a proven record of software enhancement, able to work on an hourly basis, flexible, and open to performing revisions if needed. Your robust knowledge of PWAs, Microsoft Blazor, SQL Server, and Web Services will be pivotal to the success of this project.

I have a number of JPEG images with text which I need to be transcribed into an Excel spreadsheet. The task should take around 2 - 3 hours to complete. Key Requirements: - Convert text from JPEG images to an Excel spreadsheet - Organize the data into categories as requested - Implement numeric data validation checks for accuracy Ideal Skills: - Proficient in data entry and data management - Familiarity with Excel and its functionalities - Strong attention to detail and accuracy - Experience in implementing data validation checks Please ensure that before submitting, you are confident in your ability to deliver an error-free and well-organized Excel spreadsheet.

...freelancer to develop an Optical Mark Recognition (OMR) system that will streamline the grading process of multiple choice tests. The project will involve the following specifics: - OMR Sheet: The system should be able to accurately process and analyze data from OMR sheets. These sheets will be provided in printed format. The freelancer will need to develop a robust system that can effectively read, interpret, and grade the responses on these sheets. - Accuracy: The primary goal of the project is to accurately grade the tests. Therefore, the system needs to be highly precise and reliable in identifying and interpreting the marks made on the OMR sheets. - Efficiency: The system should significantly reduce the time and effort requ...

Hi. I have an app that is becoming very popular. We created videos on how to do certain things with the app to help users get started. The videos are now out of date. We would like to have a professional video created, (preferably with out spoken words), to accurately describe how to accomplish certain tasks within the app. We anticipate each video will be 1 to 2 minutes long. We want to start with one video to see how this goes, but could definitely use 12 or more to accurately help users. The app is for golfers and golf tournament managers. Fairly straight forward, but also powerful and can be complex. It's on iOS and Android, and also the web.

I have a PDF catalogue that I need converted into an Excel spreadsheet. The PDF contains a mix of text and images which are crucial for the data. Key requirements: - Extract the data from the PDF and input into an Excel sheet. - Embed the images within the corresponding cells in the Excel file.

I require an accurate and efficient individual to input a combination of numeric and text data into a spreadsheet. This will involve less than 1000 entries. The primary task will be to input shipment data from Bills of Lading (BOLs) into an Excel file (.xlsx). The data must be organized based on specific categories found in the BOLs. Therefore, attention to detail and a keen eye for categorization is crucial. NOTE: BOL's shipped to the same location (multiple BOL's) must be added together on the same line. EXAMPLE: 1/1/2024 (5 Pallets) To Store #2595 2/1/2024 (4 Pallets) To Store #2595 NOTE: There are two types of BOL's a. Multiple Stop BOL"s. These will have 4-5 store location drops ...

I'm in need of a Laravel expert who can assist me with integrating Firebase with an SQL database. Key Requirements: - Proficient in Laravel: You should have a strong background in Laravel development and a good understanding of its architecture. - SQL Database Management: Experience in managing SQL databases is essential for this project. - Firebase Integration: Prior experience with integrating Firebase with other databases is a plus. - Problem-Solving Skills: Ability to troubleshoot and resolve issues that may arise during the integration process.

I require swift assistance in creating a balance sheet and a Profit and Loss (P&L) statement before end of day. My preference for these documents is a professional and corporate design, displaying a serious, mature understanding of business. Key Tasks: * Balance Sheet creation * Profit and Loss Statement creation My business belongs to the wholesale industry and all necessary financial data will be provided. Ideal Skills: * Expertise in financial reporting * Knowledge of the wholesale industry * Great design skills, with a professional, corporate touch * Proficiency in Excel or other financial software * Ability to work under tight deadlines Please note the urgency of this project.

Are you a Backend Developer or aspiring Intern looking to make a significant impact in the world of affiliate marketing? Join our ambitious startup and work alongside experienced co-founders who have worked with industry giants such as Meta, Verizon, MakeMyTrip, GoIbibo, Airtel, Ola, and Samsung. This is your chance to contribute to an innovative project while gaining valuable experience and honing your skills. About Us: We are a passionate and ambitious startup working on an exciting idea in the affiliate marketing space. Our goal is to revolutionize the industry by creating a cutting-edge platform that empowers marketers and drives unprecedented results. With experienced co-founders who have successfully led teams in renowned companies, w...

Expert in MS excel for automation of sheets

I'm looking for a skilled freelancer to help me customize my Excel alerts with WAV files. - I have the specific sounds in mind for each type of alert, but I need someone who can skillfully integrate these into Excel's alert system. - You should have experience in both Excel and sound file manipulation, in order to create a seamless and professional system. - Please provide examples of past work to showcase your compatibility with this project.

...developer who is proficient in creating complex database queries, particularly in SQL. Even though the ideal candidate will mainly work on backend using Java, APIs, and cloud hosting, experience building front-end using technologies such as React, Angular or Vue.js is required. THIS IS BOTH BACKEND AND FRONT END PROJECT. The core responsibilities for this position involves: - Designing, coding, and debugging applications in Java. - Performance tuning, improvement, balancing, usability, automation using cloud hosting. - Being proficient in SQL for advanced database management and queries. For a successful application, please include: - Your past work and projects, especially those related to Java and SQL. - Detailed write...

I am in need of a proficient developer to perform bug fixes on my ongoing project, primarily involving HTML, JavaScript, PHP, and SQL files. Key responsibilities: • Correcting a display issue present in my HTML file • Identifying any other existing bugs while ensuring that they do not interfere with the current functionality Skills and Experience: • Proficiency in HTML, JavaScript, PHP, and SQL • Experience with cross-browser compatibility testing and debugging • Proven track record of resolving bugs and improving webpage performance

I have an Excel file that I'd like to convert to a Google sheet. I need the Google sheet to keep all the formulas that are present in the Excel file. Key Requirements: - The Google sheet should have all the formulas intact from the original Excel file. - Include Data validation rules to ensure the data entered is accurate and meets certain criteria. - Implement Conditional formatting to visually highlight important information. - Custom scripts or functions to automate certain tasks and enhance the sheet's functionality. - Preserve font styles and retain cell borders from the original Excel file. - Maintain the column widths as in the original Excel file. Skills and ...

...- **Features:** - Natural language processing to interpret user queries. - Conversion of interpreted queries into SQL statements. - Execution of SQL queries against the existing database. - Display of query results in a format that is easy to understand. - **Technology Stack:** - Backend: .NET Core (existing) - AI/NLP Model: Choice of suitable LLM (e.g., OpenAI's GPT model) - Database: Existing system database - Mobile: Flutter (existing) - Additional Tools: AI model training and integration tools (Python, PyTorch/TensorFlow) - **Deliverables:** - AI model capable of parsing and converting natural language to SQL. - Integration code for connecting AI model with the existing backend. - Updated mobile app...

I'm looking for a professional who can help ...for a professional who can help me develop a comprehensive Excel workbook for RFQ analysis and purchasing. The primary goal of this tool is to streamline our purchasing process. Key Responsibilities: - Develop an Excel spreadsheet for RFQ analysis and purchasing. - Implement basic formulas and functions to automate data analysis. - Ensure the tool is user-friendly and easy to navigate. Ideal Skills and Experience: - Proficiency in Excel and advanced knowledge of its functions. - Experience in developing purchasing and analysis tools. - Ability to streamline processes through automation. This is an exciting opportunity for someone with a keen eye for detail and a strong un...

1- A Revit File (Design dormitory-3 Levels) 2024Version 2- 3 Sheets-Plan Views 3- 4 Sheets-Elevations 4- 1 Sheet-Section 5- A Nawiswork File 6- A 4D simulation video mp4 7- A walk-through animation(Less than 5 minutes) 8- 2 clash detections report( 0.1meter tolerance and 0.001meter tolerance)

We are seeking the the next talent to join our team at Mauritoon to animate SALKA episode 2. Watch the first clip of Salka here to understand the expected quality: You will need to pass an animation test animating the character model sheet of SALKA under 5 seconds in any context you want. Full body of the character speaking is preferred. Email your test to: [Removed by Freelancer.com Admin] And write “Salka test” in Object. Only candidates that will have the passed and emailed it to Mauritoon will be considered. Good Luck!

I'm looking for a diligent researcher who can compile a list of tire processors across different US states and organize the information in an Excel spreadsheet. Key Responsibilities: - Conducting online research to identify tire processors in each state. - Collating specific information (company name, contact person, phone number) for each processor. - Inputting the data into an Excel spreadsheet with consistent formatting. The ideal candidate should have: - Proficiency in web research and data entry. - Excellent attention to detail. - Strong Excel skills, with knowledge of maintaining consistent formatting. - Prior experience in conducting similar research would be an added advantage. The final list should be organized...

I am in need of a Senior Full Stack Developer with over 5 years of experience. The ideal candidate should demonstrate an expert proficiency in Python, Angular, HTML, CSS, Power BI, SQL (Snowflake, MSSQL), JavaScript, AWS Services, ORM, Linux, Git, Web Deployment, SSL, JWT, RESTful APIs, XML or JSON, TypeScript. Essential Skills and Experience: - 5+ years of experience in Full Stack Development - Proficiency in Python, Angular, HTML, CSS, JavaScript, TypeScript - Familiarity with Power BI and SQL (Snowflake, MSSQL) - Experience in AWS Services and Linux - Expertise in Web Deployment, SSL, JWT - Comprehensive knowledge of RESTful APIs, XML or JSON formats - Working experience with Git and ORM This highly challenging yet exciting ...

...app ready.. I want you to connect the frontend with Google Spreadsheet.. Read and write data from the frontend to Google Sheet. >>>>>>>>>>>>>>>>>>>>>>>>> >>> Please start your proposal with examples of Web App Script you have written before, to win this job. >>>>>>>>>>>>>>>>>>>>>>>>> I'm looking for a highly skilled professional with extensive knowledge in Google Web App scripting. Key Responsibilities: - Designing and implementing data entry and storage systems for text, numbers, images, files, dates and times. - Setting up automatons and workflows - Integrating the script with...

I'm looking for an expert in data analysis to assist with a project in Excel. The data provided is well-structured and needs extensive examination to extract meaningful insights. Ideal Candidate Skills: - Proficient in Excel and its data analysis tools - Strong analytical abilities - Excellent understanding of data organization Deliverables: - Clear analysis of the structured data - Relevant insights extracted from the data - Detailed reporting on the findings This project is particularly suited to those with a keen eye for data and the ability to utilize Excel's functionalities efficiently. Thanks!

I am looking for a dedicated and detail-oriented data entry operator to assist with a large volume of data entry tasks. Key Responsibilities: - Typing, copying and pasting, data validation - Handling a large volume of entries Ideal Skills and Experience: - Proven experience in data entry - Expertise in handling large datasets - Proficiency with text documents (Word, PDF) and spreadsheets (Excel, Google Sheets) - Attention to detail and accuracy - Time management skills to handle large volumes of data

I need an Excel spreadsheet that allows me to input a starting point's latitude and longitude, a heading (in degrees), and a distance (in kilometers), and then calculates the new latitude and longitude based on a rhumb line calculation. This tool will be primarily used for navigation purposes. Key Features: - Input fields for starting latitude, starting longitude, heading, and distance (all in kilometers) - Calculation of a new latitude and longitude based on the input - Utilization of the Rhumb line formula for the calculation Ideal Skills: - Advanced Excel proficiency - Understanding of geographical coordinate systems and navigation - Experience with mathematical calculations in Excel - Prior experience in developing n...

I'm looking for a freelancer to help with the data entry of a combination of text and numerical data into an Excel sheet. The data will be provided in digital text files. Key Requirements: - Proficiency in Excel and data entry - Attention to detail - Ability to accurately enter both text and numerical data Experience in similar projects will be an added advantage. Please include any relevant samples or references in your bid.

need to websrapp amazon , flipkart and get current prices of sa list of laptop models on an excel sheet

In this project, I'm seeking a skilled developer to create an intuitive, comprehensive online exam system similar to that of IELTS. Key Features and Interface Requirements: - User registration and login: Prospective test-takers should be able to register themselves and log in independently. - Payment platform integration: Users should be able to pay directly on the website before taking the examination. -Ability to import questions and exam material from excel or csv - Exam result delivery: Post-exam, users must receive their scores directly presented as a percentage score on their screens and via email. Successful applications to work on this project should include past work that directly speaks to these req...

...statement data and inject that data into an Excel worksheet. Key Requirements: - The program should be able to access Fidelity Brokerage website. - It should grab financial statement data and inject it into Excel. - Specifically, the program should insert this data row by row into a Microsoft Excel Worksheet. - Each stock symbol which the program should enact on will be in one column - The data rows should be organized by having one row per stock symbol. Ideal Skills: - Experience in API and data extraction. - Strong proficiency in Python, VBScript or other programming languages suitable for this task. - Prior experience in creating Excel macros or programs that interact with Excel. - Knowledge of fina...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

Extract data from pdf documents into an excel template. No software needed for the job. This is a complex project that requires accuracy and being organised. Must have strong numeracy and proven track record of attention to detail. Knowledge of European languages an advantage. We have over 100 files that will be allocated depending on ability and capacity. If you are interested please get in touch. Work will begin in April.

I'm in need of a professional to develop a Linux-based barcode printing application that supports both QR codes and 1D barcodes. The application must also be capable of importing data from Excel/CSV files. Key Components: - A Linux-based application: The application should be specifically designed to run on Linux operating system. - QR Codes and 1D Barcodes: The barcode printing application should support both QR codes and 1D barcodes. - Excel/CSV data import: The application should be able to import data from Excel/CSV files for generating barcodes. Ideal Skills: - Proficiency in Linux application development. - Experience with barcode generation and printing. - Ability to work with Excel/CSV data import. - Unde...

I am in need of a Python script that can read CSV files and push the data into SQL Server Management Studio database. Key Requirements: - The script should be versatile enough to handle multiple CSV files. - It should map the CSV file column names to the respective SQL Server database table columns. - I would like to have two versions - one for single CSV files and one for bulk import to optimize performance when dealing with a large volume of data. Key Skills: - Proficiency in Python to develop the script. - Familiarity with SQL Server Management Studio to manage the database. - Previous experience with CSV file handling and database import/export is a plus.

I require a Laravel developer with profound knowledge of SQL - specifically for data manipulation - and Firebase handling real-time data. The successful candidate will not only have expertise in Laravel development but also have the ability to efficaciously manipulate data using SQL. The ability to store data into SQL from firebase real-time don Firebase. Ideal Skills & Experience: - Laravel Development - SQL (Data Manipulation) - Firebase (Real-time Data Management) The developer must have a solid understanding and experience with Laravel, SQL, and Firebase. Proven track record in these fields would be advantageous.

I'm looking for an experienced programmer who understands MATLAB inside and out. Specifically, I need someone capable of optimizing a data analysis script. This script primarily uses arrays and matrices as ...programmer who understands MATLAB inside and out. Specifically, I need someone capable of optimizing a data analysis script. This script primarily uses arrays and matrices as its predominant data structures. It's crucial that you excel in: - MATLAB programming - Optimizing code for efficiency - Deep knowledge and understanding of working with arrays and matrices data structures If you are an expert with these requirements and have the know-how to streamline and optimize for speed and stability, your skills are highly valuable in thi...