Excel sql query based on cell value jobs

I am desperately seeking a skilled digital artist who can recreate less than ten of my wedding photos which were tragically lost 50 years ago. Your contribution will help me greatly in preserving cherished memories which are of high sentimental value. To be the perfect fit, you should: - Be adept at digital art and photo editing. - Understand and capture the grace and elegance of a bygone era. - Have an innate ability to recreate photos from descriptions and reminiscent feelings. Your task will stretch beyond just photo recreation. It's about breathing life into lost memories, and creating timeless keepsakes which will be cherished for generations.

Please Sign Up or Login to see details.

Hi Laravel senior developers. I want a video explanation on already project written for explanation. should be fluent in English to explain the codes to me better.

I am seeking a skilled and experienced home designer to help me in enhancing the functionality of my home. My primary goal is to make a modern home design for outdoor and indoor Key Features: - outdoor design including home front , Backyard, walls and garden - indoor (Duplex indoor design) Ideal Skills: - Proficiency in home design and landscaping - Experience in creating fu...functional and aesthetically pleasing outdoor living spaces - Knowledge of pool, kitchen, and fire pit design and installation - Excellent communication skills to understand my vision and provide creative input The successful freelancer will be one who can bring creative ideas and a practical approach to the project, ensuring the end result is a beautiful, functional home that adds significant value to my...

...initiatives to enhance user interactions by developing a WordPress plugin, building a robust .NET middleware API, and integrating advanced Azure-based messaging services. Additionally, the role involves creating an SDK to facilitate easy integration for third-party AI bot services. This position is crucial for ensuring that our platform not only meets current technological standards but also adapts to future advancements and user needs, enhancing both the scalability and functionality of our services. Responsibilities: WordPress Plugin Development - Design, develop, and maintain a WordPress plugin that integrates the WordPress frontend with the .NET-based middleware, enhancing user interactions and backend connectivity. Middleware API Development - Build and mainta...

...launch and scale of my new Info Product, a Home Services based Launch and Scale Program. The ideal candidate should be based in the US, have an excellent command of the English language, and possess a proven track record of successful high-ticket sales. Key Responsibilities: - Collaborate on the development of sales strategies for the Home Services program - Conduct sales calls and negotiations with potential clients - Close high-value deals in the Home Services industry Ideal Skills and Experience: - Proven experience as a high-ticket closer in the US market - In-depth knowledge of the Home Services industry - Excellent communication and negotiation skills - Experience in launching and scaling of info products is a plus If you are a US-based high-t...

As a small commercial general contractor, I'm seeking professional assistance to improve my Excel workbook used for estimates and bids. The ideal candidate for this task should have: - Top-notch Excel skills, specifically understanding VLOOKUP functions and formulas for summing totals. - Experience in creating automatic calculations to streamline my estimation process. - A knack for designing and customizing Excel templates. - A solid understanding of construction or a similar industry would be a huge plus. Specific tasks include: - Building automated calculations for summing totals and utilizing VLOOKUP functions. - Customizing Excel templates, specifically for the cover sheet, project details sheet, and bid summary sheet. Approach this task with a ...

I am actively seeking 50 dedicated women to assist with part-time digital marketing on Facebook and Instagram. Ideal candidates are those with: -No skills required - 10th pass can also apply - work from home opportunity - Training and guidance will be provided This is an exclusive opportunity for women only. If you're looking to excel in a digital marketing role, please place your bid.

...for my hair salon, "CXR Hair Studio". I'm looking for a simple and sleek text-based logo. You can have the words “cxr” and “hair studios” in different fonts to spice it up. The main requirements are: - Color Scheme: The logo should have a black background with white letters. The words “CXR” and “hair studios” can be in different fonts to spice it up as well. This minimalist approach will help maintain a clean, professional look that's essential for a hair salon. - Font Style: I'm hoping to have an elegant font style for the logo. This will give it a sophisticated and stylish visual appeal. - Graphic Elements: I'm not looking for any graphic elements to be incorporated with the text. The focus should s...

I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.

I'm looking for a skilled Spring Boot developer to help me set up role-based security for my application. The main goal of this is to ensure proper authorization across different user types. Here's what I have in mind for this project: - I need the system to restrict access to various functionalities based on the user's role. - The application will have three types of users: Administrators, Regular Users, and Guests. - Among administrators, I need a specific functionality for them to set up role permissions. Technical Requirements: - Proven experience with Spring Boot and security implementations. - Excellent understanding of role-based access control. - Strong knowledge of setting up and managing user roles. I'm looking forward to colla...

I need a small application prototype with the following features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ie. admin app and applicant app. job application requirements will be provided. Nodejs, angular, My SQL, ORM, Data Seeding, Migrations should be used.

You must to be at least 16 years old and live in Latin America or Eastern Europe. ✻ NO EXPERIENCE REQUIRED ✻ You do not need any experience whatsoever, but you must be clever and eager to learn. No. I am *not* being charitable; rather, I am being practical. ✻ PAYING YOU TO LEARN ✻ No. You aren't dreaming. I value intelligence and problem-solving ability over experience. I'd prefer to work with someone who is clever and learns quickly rather than someone experienced but is not very intelligent and/or does not solve problems scientifically. Would I hire an Isaac Newton or an Albert Einstein even if he had no programming experience? Of course I would. ✻ TESTS ✻ You must pass several difficult logic tests to work with me. The first logic test you complete for me will b...

...create an informative website on Hostinger. All the necessary project information - including website content, theme (have flier can send to match), logo, and colour scheme - have been collected, finalised and ready for development. The website will include the following pages: - Home page - About Qigong page: What is Qigong, Who Can Practise, What To Expect, Benefits - About Wild Swan Flowing River Qigong page: Aims, Background, About Meetings, About Mark - Upcoming Events page - Contact page - Links page - Notes page While I didn't specify any additional functionality or design preferences, I do expect the website to: - Be intuitive and easy to navigate - Incorporate our company branding (logo, colour scheme) Ideal Skills: - Proficiency in Word Press for hosting on...

... Budget: Please provide a detailed quote for the entire project, including any revisions. Job Description: We are seeking a talented and creative graphic design team to create a professional and visually appealing pamphlet. This pamphlet will be used to showcase the various service plans and benefits offered by our HVAC company. The goal is to clearly communicate the value and benefits of our services to potential and existing customers. Project Scope: Design and Layout: Create a visually appealing and professional design that aligns with our brand identity. The pamphlet should be easy to read and navigate, with clear headings, subheadings, and bullet points. Incorporate high-quality images, icons, and graphics to enhance the visual appeal and readability. Content

I need a designer for a flyer/postcard promoting my service-based business. This piece plays a significant role in announcing our offerings to the market. Key Requirements: - Design should promote our business services effectively. - Match the design color scheme with our existing business logo colors. Ideal Skills: Freelancers with experience in designing marketing/advertising materials, particularly for service-based businesses, will be ideal for this project. A keen sense of color matching and understanding of marketing strategies will be beneficial.

I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and efficient sol...

I'm seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement for data analysis or visualization. A h...

I'm in need of a talented freelancer to assist with content creation. This project is focused on boosting brand awareness and making our products and services more visible to potential customers. Key Responsibilities: - Conceptualize and create compelling content that resonates with our target audience. - Develop engaging written content or video content that clearly communicates our brand message and value proposition. - Ensure that all content aligns with our brand guidelines and voice. Ideal skills and experience: - Proven track record in content creation, preferably with a focus on brand awareness. - Strong writing and/or video production skills. - Ability to understand and effectively communicate brand values. - Experience in a similar project or industry w...

I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)&...

I'm seeking a seasoned web designer to curate a service-based website for both B2B (Business-to-Business) and B2C (Business-to-Consumer) audiences requires a strategic approach to address the distinct needs of each target group. Medical Staffing Agency primarily located in the Midwest current Base Website Custom Design: Includes up to 4 unique page designs. Responsive Layout: Mobile-friendly design that adapts to various screen sizes and devices. CMS Integration: WordPress installation and setup, allowing for easy content management. Content Strategy Session: Session to outline the site’s content needs and SEO goals. Contact Form: Integration of a basic contact form which stores records in the CMS system. Google Analytics Setup: Integration of Google Analytics for tracki...

I'm looking an illustrator to create captivating illustrations to accompany my children's short story. The project includes a cover and 14 drawings, all tailored towards 4-8 year-olds. As the story revolves around a child's love for football, a basic understanding of the game would be ideal. I'm looking for cartoon style similar to the attached. Other than the front cover, each page should be related to the 4 lines of the story which will be provided but a summary of the story is that a young boy loves playing football and scoring goals, his team enter a tournament and he has to play in goal but becomes the hero.

I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.

...this many files can be a challenge for an untrained person, and I need an expert on my team. The project requires: - Knowledge and understanding of Kobo E-readers and Sony E-readers - Familiarity with E-book file formats - Able to deliver a precisely organized outcome Handling this quantity of files is no minor task, so I will place high value on the following skills: - Excellent organizational skills to ensure the easy location of each ebook post-transfer. - An understanding of ebook cataloging - managing metadata may become essential - Problem-solving skills, should any issues arise during the transfer process If you can ensure a smooth, error-free transition across devices, I want you on board. This task needs in-depth knowledge, metic...

...searching for a talented graphic designer to work with on a long-term basis, contributing to various projects for my team. The ideal candidate will have the following qualities: - **Experience:** I require someone who has a solid background in graphic design, with a proven track record of successful projects. Your experience should cover a range of graphic design areas, ideally with a specialization in modern and minimalistic styles. - **Creativity:** I need a designer with a knack for generating innovative ideas. A strong creative vision will be a key asset. - **Portfolio:** Please be ready to showcase your portfolio, along with your previous works. This will help me understand your style and experience better. - **Communication:** I value clear and efficient commu...

I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.

I need an expert that can help change a date on a paper receipt. I have a picture of the receipt and need someone to change the date on it. The deadline is tight, so I need this done ASAP. Ideal candidate should: - Have experience working with physical documents - Demonstrate strong attention to detail - Be able to complete the task quickly and efficiently.

This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data

I've got a list of company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Data Mining Knowledge**: The ability to identify and extract the necessary data...

I'm currently seeking a professional with extensive experience in structural engineering, especially older homes. My property is an 1890s house in Michigan requiring structure optimization for joist, rafter, and beam/collar tie to better withstand our moderate winters. Unknown to me is whether or not the house c...Being familiar with Michigan's weather conditions and how they impact a home's structure will be a plus. Your recommendations and solutions should effectively address and prevent any potential instability or damage. Please include any relevant experience, project estimates, and methodological approach in your bid. Completion timeline is flexible and can be negotiated based on your professional opinion and strategy. We value quality, precision...

I have a SQL Server that needs to be accessible over the internet. However, I'm facing connectivity issues, possibly due to closed or blocked ports on my ComCast router model CBR2-T. I need a freelancer to open the necessary ports on the router. The task involves: - Checking the current port status on the router - Identifying the SQL Server port - Opening the port on the router Please bid if you're experienced with network configuration and have dealt with ComCast routers before. Necessary Skills: - Network Configuration - Router Administration - ComCast Router Experience - SQL Server Configuration

I require someone experienced in Linux server management to help optimize the performance of my server. Linux Server Performance Optimization Plesk Obsidian, SQL, PHP Key Responsibilities: - Review the current server setup and performance - Identify areas for improvement - Implement solutions to optimize server performance - Fix the 2 errors. This is not a one-time setup; I may require ongoing management based on the initial optimization results. Your expertise in Linux server management is crucial to this project.

...how my business functions, generates revenue, and its scalability. - Financial Projections: It's crucial that the pitch deck includes realistic financial projections and data to back them up. - Technical Concept: The technical aspect of the project will need to be explained in a way that non-technical investors can understand. - Unique Selling Proposition (USP): You should highlight the unique value that my project brings to the market and why it's a worthwhile investment. In terms of the length, I'm looking for something between 5-10 slides - it should be long enough to be comprehensive, but succinct enough to hold the attention of potential investors. Ideal candidates should have: - Proven experience in creating successful pitch decks that have secured fund...

I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.

Thank you!

I'm in need of a professional web developer to create a platform that serves as an agent management website. The website should have an elegant interface, account logins, and a simple credit system that can be administered by an admin account. Key Features: - Agent Registration and Login: The website should allow agents to create accounts and log in secu...functionality of the agent registration and login feature is not fully defined yet. The ideal candidate for this project should have experience in building similar systems, understand user account management, and have the ability to design an aesthetically pleasing interface. Requirements can be asked if you are interested, you can build with any framework, preferably javascript based frameworks. Minimal SQL is requ...

I have a financial plan drafted on which I want to have converted into Excel. The Excel file should mirror the plan in all aspects, including costs, expenses, revenue, and financial projections. Key Requirements: - The Excel file should be a faithful recreation of the original financial plan, ensuring that all details are accurately transferred. - It should include all costs, expenses, revenue figures, and financial projections. - You will need to have experience in financial planning, specifically in converting plans from to Excel. To be clear: I do not need business plan development, I need mostly technical work of converting one form of financial plan to the other (Excel file). Specifics: - I do not need any charts in the Excel file,...

...Mechanism Project Overview: We are seeking a skilled and detail-oriented freelance mechanical engineer or designer to work on a comprehensive mechanical design project. The project involves selecting an appropriate architecture for various linkages, creating a CAD model of a mechanism, and effectively communicating through technical drawings. Project Requirements: Architecture Selection for Each Linkage Estimated Time: 3 hours Evaluation Criteria: Creation of a simplified specification sheet Identification and characterization of functions and constraints Hierarchization and creative problem-solving using FAST diagrams Proposal of solutions with clear schematics and sketches Value analysis including criteria, scoring, weighting, and reasoned choices Synthesis of select...

...the local language, a mafia woman, etc. The possibilities are endless. 2. **Collaborative Storytelling**: - Every player online is roleplaying their own character. - Stories, plots, and actions are developed collaboratively, with everyone staying true to their roles and following the rules. 3. **Dedicated Servers**: - Roleplaying occurs on dedicated servers for the PC version of Grand Theft Auto V, as this mode is not available on consoles. The Project Vision: - **Recreate the GTA RP Experience in Minecraft**: - The goal is to build a Minecraft map that mirrors the GTA RP server's environment and dynamics. - This will involve detailed world-building to capture the essence and activities available in GTA's sandbox environment, translating t...

Pleas read the attached document

I want a strategy for tradingview that it opens the orders manually or crossing emas, we input a range for the stop loss and take profit using % or $ and when it reachs the SL it opens a new order using the same range and different direction, if it is long, turn in to a short but with the value increase by a pre set multiplier (one for the SL ad one for the TP) and also add a possibility to multiples TP We also need to pre set a limit of times that the reversion happens and also add a option tralling stop loss. Can you make it?

I urgently need assistance with installing a PHP application on my dedicated Linux server. Key requirements: - Expertise in server management, particularly dedicated servers - Proficiency in PHP application deployment - Strong knowledge of Linux operating systems Please only bid if you have significant experience in this area and can start immediately. Your prompt help is highly appreciated.

I have a dataset of images and I'm looking for someone experienced in U-Net algorithm. Project description: - Write PyTorch U-Net training model on top of provided base code (, , , ). - Train the model until achieving a validation dice score of min. 0.875. - Deliver source code and trained model until Wednesday 10 pm (Vietnam time zone).

...sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "Product details" of the input file 1 are present in column A of the VAT output file and we have a value in column B. If there...

I'm looking for an experienced domain broker to assist with selling a high-value domain in the technology industry. Key Points: - **Domain Expertise**: Familiarity with the technology niche is crucial. Understanding of the potential buyers and market, as well as the ability to articulate the domain's value. - **Negotiation Skills**: Proven ability to negotiate and secure high-value sales. Past experience in selling high-end domains would be a significant advantage. - **Professional Network**: A well-established network in the tech industry, particularly among potential domain buyers, would be highly beneficial. - **Confidentiality**: Ensuring all transactions are handled with the utmost discretion and confidentiality. I have a target price in mind higher t...

...environment - Opportunity to work on a variety of exciting projects - A supportive team that values your input and creativity If you are passionate about technology, constantly seeking to learn and improve your skill set, then you are the type of person we are looking for! We are offering superb career growth opportunities, great compensation and benefits. **Application Process:** 1. Submit your detailed resume/CV highlighting your relevant experience and recent projects. 2. Attach a concise cover letter, elaborating on your suitability for the role. 3. Provide links to any applicable portfolio pieces or code samples, with a preference for Github profile. 4. Detail your most recent projects where you extensively utilized React and TypeScript. 5. We value your tim...

I am looking for fre...Key Notes: - This is a commission-based role, and I intend to reward successful sales generously. - No website design or layout is required as the sale is purely for the domain names. - There are no specific keywords or phrases related to the domain names as they cover an extensive range of subjects. Ideal Candidate: - Knowledgeable about digital assets, particularly domain names - Proven sales experience, preferably in the digital marketplace - Highly persuasive and comfortable with cold outreach - A solid understanding of the value of domain names in today's market This isn't about creating websites. It's about selling potential scale, opportunities, and a vision to your audience. If you believe you can sell these domain names and m...

I'm in need of a proficient CSS Animation expert, comfortable with both vanilla JavaScript and React. Your task will involve incorporating specific animation effects into a project. Key Features: - Apply 'Fade in/out' and 'Rotate' animation component based on the value of the a sliding scale. - Work uniformly across both mobile and desktop devices. Ideal Skills: - Expertise in CSS and SVG animation - Familiarity with vanilla JavaScript and React - Strong understanding of responsive web design and development Flexibility in your use of vanilla JavaScript or React is preferred since I have no strict preference between the two. Anticipate demonstrating your ability to innovate and effectively apply your skills to create engaging user experience...

I have an Excel sheet that requires data filtering. From One sheet i want the following 1) Deletion of few records with some keywords 2) Make one sheet with unique data 3) No of repeated records. 4) Mobile number format to be changed

I'm looking for a skilled android developer to create a professional application for me. The app will be targeting professionals as the primary users. Key Features: - User Login and Registration: The application should allow users to create accounts and log in securely. - In-App Purchase Functiona...professional audience. Ideal Skills: - Proficiency in Android app development - Experience with in-app purchase integration - Ability to implement secure user login and registration systems - Prior work with push notification services - Strong design skills, especially in creating icons - Understanding target audience of professionals If you have additional expertise that you believe would add value to this project, please feel free to mention it in your bid. Looking forward to ...