How to write sql query in excel sheet jobber

...developer to create a simple servlets program using JSP, JAVA, and bare HTML for a school project. The structure should follow a 3-layer architecture with the MVC design pattern. I have already designed the solution, just need some muscles to implement my ideas as I have not much time to do it myself. Key Project Requirements: - Version Control: Git - Database Connection: MySQL - Functionality: User registration and login, product catalog management (store, fetch, and modify products in the database) - Use of Design Patterns: Singleton, Observer, MVC, and any others you feel are necessary Additional Skills and Experience: - JUnit - Netbeans - Password hashing techniques (if time permits, otherwise store passwords as plaintext.) - Experience with implementin...

I am in need of a competent Snowflake SQL developer with expert knowledge in translating SQL Server queries to Snowflake SQL. Your role will involve figuring out the data model from an analysis of the data. No ER diagrams will be provided, so a deep understanding of data modeling is essential. You should be willing to get on a call to do the job. You will be paid hourly for your time. You will not be provided direct access to the database however your advise will be executed on call

I'm seeking a highly-skilled freelancer with a deep understanding of Excel for a data entry project. This is not your typical data entry job as it requires knowledge of complex formulas and data manipulation. Key Responsibilities: - Enter data from Excel spreadsheets - Create complex formulas within Excel - Use data manipulation techniques to ensure data integrity Ideal Candidate: - Advanced understanding and experience with Microsoft Excel - Proven experience with complex data entry - Attention to detail is paramount - Strong organizational skills - Ability to meet tight deadlines Join me in this challenging yet rewarding project and let's make a difference together.

I have code for login trading accound and fetch token data. I need to update more details incode I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Automate the buy/sell Trade I need an intelligent programmer, who can see future problems and solve them clever and independently. Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the paym...

Hello and Thank you for being here Please note I need to change the bios; not with a USB or Manual Step Need to do this via command line is fine but script would be nice also 1..change1 - so that it will make the 1st boot device PXE on the next boot it will boot off the PXE and do tasks as PXE including install a new OS after OS install is done........ 2..would like to change change2 - so that it will make the 1st boot HD 3..Also- read the values of the boot order from the bios in linux ? Can you do this as a script ? Will give a 5 Star Review when this is done and will write such inspiring words for you, when done. Please understand; there is hope you can give your “best” price; been unemployed, and have cancer with bills backi...

Hi, I have 6 excel optimization problems using premade excel model involving costs/profits/promotion. Answers using excel solver. Using an excel model to adjust subcontracting and demand. Note: Need it done within the next 20 hours.

Hello and Thank you for being here Please note I need to change the bios; not with a USB or Manual Step Need to do this via command line is fine but script would be nice also change1 - so that it will make the 1st boot device PXE on the next boot it will boot off the PXE and do tasks as PXE including install a new OS after OS install is done........ would like to change change2 - so that it will make the 1st boot HD Can you do this as a script ? Will give a 5 Star Review when this is done and will write such inspiring words for you, when done. Please understand; there is hope you can give your “best” price; been unemployed, and have cancer with bills backing up, $10 possible? Please note $10 is the max total that I can handle for this (...

Necesitamos personas que cierren ventas de préstamos de Infonavit. Las comisiones se entregan de 15 a 22 días hábiles después de finalizar un trámite. Ofrecemos: •Trabajo 100% en línea (tú decides cuando trabajas). • 100% Comisionista (tú decides cuanto ganas). • Ganancias previstas desde 8,800$mxn hasta ...100% en línea (tú decides cuando trabajas). • 100% Comisionista (tú decides cuanto ganas). • Ganancias previstas desde 8,800$mxn hasta 44,000$mxn. • Excelente ambiente laboral. Responsabilidades: - Buscar, filtrar y cerrar clientes. Requerimientos: - No se requiere experiencia (nosotros te capacitamos). - Pasión por las ventas. - Habilidad para comunicarse tanto verbal co...

6 excel optimization problems using premade excel model involving costs/profits/promotion. Answers using excel solver

This take is to take a list of URLS (as in the URLS spreadsheet attached) and create a Power Automate flow to extract the following from each URL: • Previous Close • Open • Bid • Ask • Day’s Range The output should be in a separate spreadsheet (‘output’). In the sample ‘output’ file attached, this shows the result for ‘MMM’. Other URLs will follow. I should be able to run the Power Automate workspace at any point to scan the URLS. The URLS may change (added or removed).

Hello I do sales for a tobacco company and I need to enter all my sales for January February March. I need three different Excel files. All it is is the name of the store the amount that I sold and the address.

...concreto necesitamos: • Automatizar la exportación de datos de facturas emitidas (y su estado, canal de entrada, consultor asignado) y gastos, y preparación de los mismos desde HOLDED. • Automatizar la exportación de datos (presupuestos lanzados y vendidos, potenciales clientes y comerciales asignados) y preparación de los mismos desde HUBSPOT. • Automatizar la cumplimentación Excel de RRHH mediante un Excel que nos pasa la gestoría cada mes, con todos los datos de las nóminas y costes laborables de cada trabajador. *****Importación e integración de todos datos y modelado de un cuadro de mando en Microsoft Power BI con las siguientes funcionalidades:  Facturación Mensual, anual,...

I'm in need of an hacker to perform a thorough black-box penetration testing on a WordPress website. Key Responsibilities Include: - Testing the security from an outsider's perspective. - Identifying and using hacking techniques including SQL injections, cross-site scripting attacks, and brute force attacks to hack website as outsider so that we can plug the vulnerability. Ideal candidates should have: - Proven experience in website vulnerability testing. - A strong understanding of WordPress. - Exceptional problem-solving skills. - In-depth knowledge of SQL injections, cross-site scripting attacks, and brute force attacks. My objective is to ensure my website's robust security, and your expertise can help me t...

I'm in need of an hacker to perform a thorough black-box penetration testing on my WordPress website. Key Responsibilities Include: - Testing the security from an outsider's perspective. - Identifying and using hacking techniques including SQL injections, cross-site scripting attacks, and brute force attacks to hack website as outsider so that we can plug the vulnerability. Ideal candidates should have: - Proven experience in website vulnerability testing. - A strong understanding of WordPress. - Exceptional problem-solving skills. - In-depth knowledge of SQL injections, cross-site scripting attacks, and brute force attacks. My objective is to ensure my website's robust security, and your expertise can help me ...

I'm seeking a freelancer with advanced Excel and Power Query proficiency to provide essential data extraction, transformation, cleaning, and combination services for an Excel Report. Qualified candidates must demonstrate: - Advanced understanding of Excel and Power Query - Experience in extracting data from diverse sources - Capability for cleaning and transforming data for optimal utility - Aptitude for combining data from various sheets effectively In your proposal, include details about your relevant experience. Your hands-on experience and proven record of similar projects will secure your success in this job.

Sample pincode - 743611,743329 I will provide all pin code of India in a excel. You have to fetch agents data and have to give me in a Excel Or google sheet. Total 19000 pincode. You have to write a script that can do it. Budget under INR2000

...these will be presented in a profit-focused, modern, and user-friendly interface. Besides, the app should offer: - MetaMask Integration for a secure OAuth login. - Real-time DEX arbitration on leading platforms (Ethereum, Binance Smart Chain, Solana (SOL), Avalanche (AVAX), Polygon (MATIC)). - A dynamic Flash Loan display, showing the profit display and transaction history. - Security audits to guarantee user safety as they engage in complex DeFi trading activities. For this task, familiarity with DeFi, Blockchain, and Cryptocurrency is paramount. A background in UI/UX design will also be beneficial due to the emphasis on a modern, sleek interface. Prior experience working with MetaMask and the platforms mentioned above will provide a crucial advanta...

As a busy professional, I'm on the lookout for an Excel pro who can assist in organizing my dataset of less than 1,000 rows. The data is moderately complex, with multiple columns of various types. The ideal freelancer will: - Have experience with Data Entry and Organization. This includes swiftly inputting data and structuring it for optimal accessibility and productivity. - Possess Data Analysis and Reporting Skills. I'm keen on meaningful insights from the data and require straightforward, compelling reports. - Excel proficiency is a must, with strong attention to detail, and ability to handle moderate complexity data. By bringing your advanced Excel management and analysis skills, you'll be delivering order to chaos, and ...

...details: What specific information do you need to gather for each company? Company name, Contact name, Contact email; Contact phone number; Company website, Gender, Position, Email What information should successful freelancers include in their application? Past work How would you like the database to be organized? Name, Position, Gender, Company, URL, Email, Phone, Notes Project Objective: To create an organized and detailed database, which includes the following columns: Name, Position, Gender, Company, URL, Email, Phone, and notes. Requirements: 1)Research Skills: Ability to conduct thorough online research to find accurate contact information for HR representatives, recruiters, and hiring managers within the specified companies...

See the attached File. Simple project here. If any of the words in column A, sheet 2 are in column D, Sheet 1, then delete the entire row (in Sheet 1) (Delete the entire row, not just the cell) No macros Likely conditional formatting, new rule is the best. This will be used on multiple files so it needs to be quickly applied. New words will be added to the list to filter for. The filter list can be added to each new file. No Macros Type :Sponge Bob" in your bid (to sort through the spammers) This should be a very low cost bid and delivered today.

...experienced ASP.NET Core, MVC DevExpress developer to help with the migration of our ERP system from vb.net to a new platform. Your main responsibilities will include: - Designing new forms: As we have not yet designed the new forms for the migration, you will be required to assist in creating these. - ASP.NET Core 5.0 or later: We plan on using the latest version of ASP.NET Core for this project. It is essential that you have hands-on experience working with this version. - Migrating 20 forms: There are a total of 20 forms that need to be migrated as part of this project. You will be compensated based on each form migration. - Database expertise: Our database is SQL based, so familiarity with SQL will be a plus. Ideal Skills and Exper...

I need an Excel expert who can craft 4 meaningful bar charts to visualize several health metrics. The foremost tasks required would include: - Visualizing perceived health data acquired from various sources namely, self-assessment questionnaires and participant interviews - Converting raw data of percentage changes in health into impactful insights using Excel It's pertinent that the freelancer has a good grasp of Excel and data visualization. A comprehensive understanding of health metrics would be appreciated, but not compulsory. Your role will aid in the better comprehension of health improvement or decline, ultimately guiding decision-making based on these observations.

I am looking for a skilled individual to create 4 bar charts in Excel for the purpose of showcasing percentage changes in perceived health over time. Key requirements: - Using perceived health data, generate 4 bar charts showing changes over time. Ideal Skills: - Proficiency in Excel - Understanding of data visualization - Ability to depict percentage changes in a clear and accessible manner. Please provide examples of your past work in your bid.

I need an Excel file created with text, numbers, and formulas. The data should be organized using rows and columns, across 6-10 tabs/sheets, and include pivot tables. Ideal skills and experience for this project include: - Advanced Excel knowledge - Experience in creating organized and visually appealing Excel files - Proficiency with pivot tables and formulas - Attention to detail and ability to follow specific instructions If you have experience with similar projects and can deliver a well-organized Excel file with the specified features, I'd like to hear from you.

I need to automate the creation of tasks and subtasks in Microsoft Planner from an Excel file. The automation should be set up to run on Windows operating system using Power Automate. Requirements: - Automate creation of tasks and subtasks in Microsoft Planner from an Excel file - The automation should trigger based on a specific action, potentially a call, button, or script (vba button Prefered) - The system should be set up to run on Windows Ideal skills and experience include: - Proficiency in Power Automate - Prior experience integrating Microsoft Planner with Excel - Strong understanding of Windows OS and how to set up automation scripts to run on it - Experience creating and managing subtasks in...

I am in need of a skilled data analyst who can perform a descriptive analysis on my Excel spreadsheets, focusing on understanding trends. Key responsibilities: - Conduct a thorough descriptive analysis on the provided data - Identify and interpret trends within the datasets - Translate the data into actionable insights Ideal skills and experience: - Proficiency in data analysis, particularly descriptive analysis - Excellent working knowledge of Excel and data handling - Strong analytical skills and the ability to interpret data accurately - Prior experience in trend analysis is a plus

I am in search of an experienced full stack developer to work on a web application. To add on I can give him my previous work through which he needs to change some changes and help me in running without a virtual environment Key Requirements: - Proficiency in JavaScript, Python, SQL, and HTML - Expertise in front-end development, back-end development, and database management The ideal candidate should be able to: - Develop the front-end of the web application to ensure that it is visually appealing and user-friendly - Design and implement the back-end of the application to ensure that it functions correctly and efficiently - Manage the database of the application to ensure that data is stored and retriev...

I am looking to automate email sending through Excel. I have a list of email addresses and the same message to send to all recipients. However, there are certain conditions to consider: Firstly, as shown in the screenshot below, there are checkboxes with options (OUI ou NON) YES or NO. If the checkbox is marked with a "YES", the email will be sent. Otherwise, it will not be sent. Secondly, another condition relates to the frequency of email sending: Once a week Twice a week Once every two weeks Once a month I would like to establish an automated process that takes these conditions into account to send emails according to the specified parameters. Thank you for your assistance in implementing this sol...

In this project, I'm looking to leverage business analytics and data visualization to achieve multiple objectives: - Identifying key trends and patterns - Making data-driven decisions - Enhancing data presentation and communication The primary data sources for this project will be Excel spreadsheets, social media platforms, and analytical software, such as PowerBI and Tableau. The desired insights from this project are specifically: - Analyzing closing prices - Gaining a clear perspective of the stock market trends Ideal applicants for this job should be highly skilled in use of Excel, PowerBI, Tableau, and social media analytics. A keen understanding of revenue performance, stock market trends, and closing price analysis is also crucia...

I am in need of a proficient data scraper. The ideal candidate will mine and collate contact details, specifically email addresses, phone numbers, and business addresses. The targeted businesses should be choose through a defined criteria: location and industry. Your responsibility will not stop there. You will also need to compile the acquired data into a well-organised Excel spreadsheet - ensuring information is accurately represented and easy to navigate. A meticulous attention to detail is vital in this role, alongside experience in similar data scraping tasks. Skills: - Experience with data scraping - Proficiency in collating and organizing data - Excellent Excel skills - Attention to detail - Familiarity with ...

I am looking for a skilled Sketchup Ruby programmer to design and build a 3D modeling extension for me. Key Requirements: - The extension should be a small .rbz file that can create, modify, import, and export components. - It should include basic 3D modeling tools like dimensioning and simple shapes. Ideal Skills: - Proficiency in Sketchup - Strong knowledge of Ruby programming - Experience in developing 3D modeling tools The ideal candidate will be able to work to a tight deadline and produce a high-quality, user-friendly extension. Please include examples of your previous work in your bid, and outline your experience in developing Sketchup extensions. Certainly, here's a revised version for clarity and presentation: Short ter...

...have a better chance. Monthly salary will be considered to calculate the hourly rate and the time needed to complete different task documents, on an agreed fixed price. The best offers with the right experience will have the opportunity to work with us on a long-term basis. Also, Good prospects for the right developers, based on the performances evaluated over a period of time, once you established your skills. Need to provide the changed code details and sql queries if any at the end of each sub-task, with the changed code line numbers. Unlimited Revisions are needed. Any bugs created due to your own developments are to be fixed on free of Charge. Recruitment is for a long-term big project as such, all the developers are subject ...

I am in need of a freelancer who has experience in producing photo-realistic renders and reviewing existing SOLIDWORKS designs. "I'm looking for a talented 3D artist with experience in sheet metal to create a photo-realistic render of my existing design of a Charcoal stove product. SOLIDWORKS was used in designing the product. This render will primarily be used for marketing materials, so it needs to be visually appealing and of the highest quality. The existing design will be reviewed and adjusted slightly so that it can be produced using a CNC machine for prototyping. Key requirements: We need the render to be set in an isolated environment with a white background. This will help keep the focus on the product ...

I'm in need of an already developed ecommerce application that leverages PHP and flutter technologies. The application should be compatible with both web and mobile platforms. I intend to host this application myself, thus a local connectivity to SQL*Plus or Postgresql database is essential, and the use of PL/SQL and nested subqueries is also mandatory. • Product Variety: This ecommerce platform should have the capability to sell any type of products or services, with no restrictions on specific industry or category. • User roles: The application should be versatile enough to support multiple user roles, for various administrative and customer functions. Freelancers who have experience in PHP, Flutter, SQL, ...

...me having to micromanage the project. You have to be able to develop a full project like it would be your own project. You have to come up with the niche, concepts, storylines, designs, etc... You may hire a designer if necessary and defer the costs to me. General Requirements: -Experience with WEB3 technology -Proficiency in game design and development -Ability to create engaging and interactive gameplay -Knowledge of blockchain and Play-to-Earn mechanics -Strong understanding of game monetization strategies Project Requirements: -You have total freedom in what type of game you make -You have to work alone -The scope of the should be small enough that you can complete it -You have to integrate an ERC20 tok...

I'm in immediate need of a Linux expert with advanced problem-solving skills to assist with multiple tasks involving CentOS. - The right professional should excel in troubleshooting and debugging, Linux server administration, and Linux programming. - As the tasks are of an advanced nature, a strong background in Linux systems, particularly in CentOS, is essential. - Prior experience with complex issues is a must. Your challenging role will involve locating and fixing faults, managing the Linux server, and coding in the Linux environment. - If you feel you fit this profile, please apply, detailing your previous similar experience. Your commitment to a streamlined and effective Linux operation will be welcomed here.

As a business owner, I'm in dire need of a VBA Excel expert to automate key aspects of my inventory management. The primary goal of this project is to create an effective material management system. Task Description: - Automate data entry and generate regular reports - Update inventory levels regularly - Implement an efficient inventory tracking system within the operation Key Feature: The main feature that this project should hold is inventory tracking. Inventory Tracking System: - The inventory tracking should be innovative, able to adjust stock depending on the inventory levels. - Implement an automatic reordering system that triggers when stock is low. This will ensure that the operation runs smoothly without the worry of running low on ...

I have a excel of Maharashtra PT it has all macros and all i am able to use it but its outcome from excel the text file am not unable to find

I need a skilled Excel data analyst to work on sales data. Requirements: - Experience: Please include your previous experience with similar data analysis projects in your application to be considered. Please submit your bids along with a summary of your experience in this field. I will share the specific data once we are in contact.

I have a black and white Excel sheet that dosent look Professional ... I need it to be Colorful and attractive

Hello, I need to increase speed of search, current solution made in PHP , MY SQL , simple small solution to search from document. Currently speed is very slow i want to make it super fast search for all results I will share URL and more detail in chat This is job for PHP , JS Expert who have good experience of search. Regard

I am in need of a talented graphic designer to create an illustrative and eye-catching design for 100 DBT Therapy flashcards. The ideal candidate for this project should have: - Proven experience in illustrative design - Masterful use of natural/earthy tones in design - Substantial experience creating digital files, particularly PDF The design should reflect a holistic and earthy theme to align with the written content which I will provide. Your deliverables would be 100 cards (4 cards per A4 Sheet) PDF files, each containing the design of a unique flashcard. This will be a tangible means to further enhance the learning experience of the targeted adult learners. Let's bring these educational materials to life through artistica...

i am an employee currently working in L2 production support in the health care sector project, I am seeking experienced people to help with various PL/SQL-related tasks (SHADOW SUPPORT) . Our collaboration rests on a time-sensitive SLA, hence swift responses and a proactive attitude are highly appreciated. Key responsibilities: - Writing and debugging SQL & PLSQL queries - Handling PL/SQL procedures and packages - Managing and rectifying production defects - Conducting unit testing experience with Jira tickets platform is preferable. The ideal freelancer for this job would be a proficient PL/SQL developer with exceptional debugging skills, experience in database schema design, and an understanding of the healthcare sector�...

I need a data entry specialist to compile an Excel spreadsheet database of addresses and opening times relating to approximately 400 branches of the Citizens Advice Bureau. The data will be collected from URLs that I will provide. Ideal Skills and Experience: - Proficient in data entry and Excel - Experience with web research - Attention to detail - Ability to meet tight deadlines - Previous experience with similar projects is a plus This is an urgent project and I need it completed as soon as possible. Thank you.

I am looking for a skilled freelancer to analyze the sentiments of the reviews given by the customers in the data and make some useful conclusions. Read ML PROJECT GUIDELINES pdf for full details. Two dataset excel files are given. Project should be done in Sample submission colab notebook. An example project is also given for reference. Complete full project as in the notebook and guidelines. Requirements: - Analyze and categorize sentiments - Visualize the results - Cluster Zomato restaurants into different segments. Ideal skills: - Strong experience in machine learning - Proficiency in data analysis and visualization - Knowledge of sentiment analysis techniques - Familiarity with clustering algorithms

...assistance with opening a Quickbooks file that was saved in 2009. The file contains important financial data which I urgently need to access. I am currently using Reckon Accounts 2013 Pro and did not keep the earlier versions of the Quicken software. Based in Australia, I have evidence that I own the company who owns the Quickbook file and the software registration details. What I don't have is knowledge of the specific password that I used for the file at the time. I have a list of 35 passwords that I was using for various tech systems around 2009. One of which is likely to open it or as a professional you may know a different way to access the data. At minimum I need from you an Microsoft Excel or Libre Calc file of all of the data...

we are looking f...core PHP development experience. - Proficient in Laravel framework. - highly knowledgeable in php programming and experience SQL Injection prevention/fixing - Finding and Securing any loop holes in the system - **must be an independent developer, not an agency! - must be able to work on github - lastly making sure platform is mobile responsive Must have experience in social media or multi-user platform, chat system, ecommerce platform *******We will only hire independent freelancer. If you are an agency, if you are a marketing person or project manager and will delegate the work to someone else, meaning, will subcontract the job to someone else to do, then DO NOT BID ON THIS, YOU ARE JUST WASTING YOUR TI...

...test on anydesk 2nd round - attend google meet for 30 minutes ,in which you will be asked some sql queries We are looking for a highly experienced Senior Laravel Developer proficient with PHP programming and SQL database knowledge. This project revolves around developing an e-commerce website using Laravel. The perfect candidate should possess: - Extensive Laravel Framework Experience: This isn't just about knowing Laravel, I need someone who has used it to solve complex web development issues. - PHP Programming: Laravel goes hand in hand with PHP, hence a solid understanding and proficiency in PHP is a necessity. - SQL Database Knowledge: The structure of our site's database is very important, and understanding SQL ...

I am in need of both a backend and frontend developer to create a software platform for my online travel company. Backend Developer: - Proficiency in Java, Python, C#, SQL, and other common backend languages - Experience in developing e-commerce or customer relationship management systems is a plus - Strong knowledge of server-side technologies - Ability to work with databases and APIs Frontend Developer: - Proficiency in JavaScript, HTML/CSS, and Ruby - UI/UX design experience is preferred - Knowledge of responsive design and cross-browser compatibility - Experience working with backend developers to integrate server-side functionalities into the frontend The software is intended to be a comprehensive platform for our onlin...

I have code for login trading accound and fetch token data. I need to update code to my system. you can create new code for my requirement at same cost.I need to collect live data from the web and candle stick with different time frame.I can choose any minutes interval, I need you to collect Last 10 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Stock Broker account: If Buy signal find it will automaticlly place Buy order,etc., Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the paym...