Excel formulas assign rank based range numbers jobs

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.

I'm looking for a web developer to 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 fo...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 Hostinger - Sound experience with website design and development - Excellent communication skills - Ability to implement a website based on provided content, theme, and logo. - Good understanding of essentials su...

...agent based in China who is adept at navigating and platforms. The objective of this project is to identify three verified suppliers for a specific product category and provide comprehensive details, including supplier contact information, lead time, and DDP (Delivery Duty Paid) pricing. Key Responsibilities: 1. Supplier Identification: Utilize and to search for reputable suppliers specializing in the specified product category. 2. Supplier Verification: Conduct thorough due diligence to verify the credibility and reliability of potential suppliers, ensuring they meet our standards for quality and reliability. 3. Supplier Contact Information: Provide accurate contact details for the selected suppliers, including email addresses, phone numbers, and any

I am seeking an experienced engineer to design and implement a two-axis machine control system that is capable of: - Effectively controlling and managing the movements of the system along two axes with a LIMITED RANGE. Your expertise in designing systems with the necessary navigation strategies and motion control algorithms will be required. - Providing real-time position feedback to the user. Your extensive understanding of feedback mechanisms particular to these types of systems is a must. Ideal expertise for the job includes: - Comprehensive knowledge in machine systems control and design. - A thorough understanding of motion control strategies. - A background in data analysis and logs processing. The machine is a Bandsaw to cut small logs into planks. The 2-...

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.

...different grades. Requirements: - The card templates should have a cartoonish art style. - Each card template should include: - A designated area for a character portrait. This should be distinct and easily distinguishable from the other elements on the card. - A section to display the character's stats. These stats should be prominent and easily readable. This area should only need space for 2 numbers. - An area for the character's abilities. This text section should be carefully designed to make the abilities stand out. Ideal candidates should have experience in: - Designing for trading card games, preferably in the fantasy genre. - Proficiency in cartoonish art styles. - Creating visually distinct and easily readable card layouts. I'm looking for so...

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 am looking for an experienced CNC programmer to help me program M codes on my Syntec 60W-e CNC controller. I have 3 unused out relays that I want to use, and I would like each of them to be assigned to specific M codes. Here’s what I need: - Assign M code e.g. M30, M50 and M80 to the unused output relays. - The function they should perform is to turn an external device on/off. Skills and Experience: - Previous experience with CNC programming is crucial. - Familiarity with Syntec 60W-e CNC controller will be highly advantageous. - Proficiency in M code programming required.

I'm in need of a skilled graphic designer to craft a comprehensive overview PDF for my digital services and solutions. Key Deliverables: - Service Descriptions: A detailed explanation of the range of services I offer should be included. - Professional Design: The overall look and feel of the overview should be corporate and professional. This will resonate well with the target audience and reflect the nature of the services I provide. Distribution Plan: - The PDF will be used in a variety of situations, so it must be adaptable. I intend to: - Email the document to clients. The design should be compatible with and visually appealing in email format. - Make it available for download on my website. The PDF should be easy to access and view on a digital platform. - Print ph...

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 ...

...The Inside Out Wellness Center" Logo Design Challenge! We are looking for a creative and original logo design that embodies the essence of our wellness center, focusing on energy-based work and spiritual practices. Our center offers a variety of services and activities aimed at promoting holistic well-being, personal growth, and spiritual development. The design should reflect our integrative heart-centered approach, helping individuals transcend to their higher selves and empower them on their journey towards optimal health, inner peace, and spiritual enlightenment. Design Guidelines: what we consider when we assign star ratings: 1. Name of the logo must be found in the logo and it should be easily readable: From The Inside Out Wellness Center 2. MUST include drago...

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)∗100=19.88% However, i...

...create an interactive design for our property management application using Figma. The application is intended to streamline property management operations, offering functionalities like task management, team coordination, guest management, and more. Scope of Work: The designer will be responsible for: Creating an interactive and user-friendly design in Figma Developing wireframes and prototypes based on provided sketches and descriptions Suggesting and implementing improvements to enhance usability and aesthetics Ensuring responsive design for both web and mobile views Pages to Design: Home Page: Displays an overview of tasks, notifications, and key metrics for the day. Contents: Summary of check-ins/check-outs, ongoing tasks, alerts, and quick links to other sections. Prope...

I need a website designed and developed that will serve as a platform for my healthcare company. The site will have a three-pronged approach to content, focusing on: - **Services Offered**: I want to showcase the range of services we provide. This section should be clear, concise, and informative. - **About Us**: This is where I want to introduce the visitors to our company - our values, mission, and vision. It should be detailed yet engaging. - **Contact Information**: I need a clear and easily accessible way for potential clients or partners to reach out to us. The target audience for this website will be varied, including: - **Patients**: I want the site to be easily navigable for patients seeking our services. - **Healthcare Professionals**: This section should speak to prof...

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.

I am seeking an experienced engineer to design and implement a two-axis machine control system that is capable of: - Effectively controlling and managing the movements of the system along two axes with a LIMITED RANGE. Your expertise in designing systems with the necessary navigation strategies and motion control algorithms will be required. - Providing real-time position feedback to the user. Your extensive understanding of feedback mechanisms particular to these types of systems is a must. Ideal expertise for the job includes: - Comprehensive knowledge in machine systems control and design. - A thorough understanding of motion control strategies. - A background in data analysis and logs processing. The machine is a Bandsaw to cut small logs into planks. The 2-off, NEMA 23 s...

I'm 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 commun...

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'm in need of a skilled developer or team that can design and build a highly specialized mobile platform. The platform should be able to adapt to various unique applications. This platform should be intuitive, user-friendly, and able to support a range of features. Key Features: - Natural Language Processing: The platform should possess advanced natural language processing capabilities. - Voice Chat: The ability for the platform to support voice-based communication. - Image and Multimedia: The platform should support a range of multimedia options, from text to photo uploads. Platform Support: The mobile application should support the interface and experience similar to that of Pi from Inflection AI or ChatGPT from OpenAI. Design: The design should be sleek an...

I'm seeking a creative and experienced graphic designer to create a logo for my trust-based recruiting platform. This logo plays a vital role in conveying the unique values of my platform, so it needs to resonate with the message of trust, innovation, respect, and energy. Key Requirements: - Color: Predominantly blue should be used to represent trust and innovation - Emotion/Message: The logo should emanate trustworthiness intertwined with innovation, respect, professionalism and energy. - Symbols/Icons: The designer is expected to include pertinent symbols or icons that encapsulate the core values of the platform (such as a puzzle pieces, or other matching symbols) Ideal Skills: - Experience in logo and brand identity design. - Ability to translate values and emotions into...

I'm looking for a professional to verify the phone number for my Google Business profile to enhance its credibility and visibility. Key Requirements: - The verification method should be of Landline number. Ideal Skills and Experience: - Experience in managing Google Business profiles. - Proficiency in verifying phone numbers using SMS. - Knowledge of best practices to increase trust with customers and enhance visibility on Google Business.

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'm seeking an interior designer with a knack for modern aesthetics to help me transform my small living room which w...with a touch of sophistication. Clean lines and minimalistic elements are preferred. - Layout Consideration: As it's a small space, the layout is crucial. The design should be optimized to make the rooms appear bigger and more functional without compromising on the overall visual appeal. Your role will be to bring these elements together into a cohesive and attractive design. While the budget range is not specified, I'm open to a discussion about your rates and the scope of the project within these parameters. Ideal Skills: - Interior Design - Proficiency in modern design principles - Creative thinking for small spaces - Experience in working wi...

I'm looking for four fitness experts - 2 males and 2 females, with diverse backgrounds (white and black) - to help me create short, low-intensity home workout videos. These videos will be targeted at individuals looking to lose weight. - Each video should be 1 minute or less in duration. - I need the experts to provide a variety of workout...minute or less in duration. - I need the experts to provide a variety of workouts focusing on different areas of the body. Ideal candidates should have a strong fitness background, experience in creating workout videos and a good understanding of weight loss and low-intensity workouts. A good on-screen presence is also important. The goal is to create engaging videos that are accessible to a wide range of users, with a focus on simplicit...

I am seeking an experienced professional who can gather the names, emails phone numbers and address for all English language schools within England, Wales, and Scotland. Due in 24hrs Requirements: - The data should include the school's name, email and phone number. - Only the emails need to be verified for accuracy. I aim to compile a comprehensive database for the purpose of contact outreach to these schools. I expect to find around 5000 English language schools across these regions. Ideal skills & experience: - Proficiency in data research and extraction. - Attention to detail for accurate data collection. - Experience in email verification procedures. - Strong communication skills for potential follow-up with the schools. The successful candidate will play a crucial...

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.

I am seeking an experienced online English teacher for children aged from 3 to 16. The ideal candidate should have a firm grasp of teaching Writing, Speaking, Listening, and Grammar. Your responsibility will involve: - Making engaging online classes using online learning platforms - Adapting your teaching methods to effectively cater to a diverse age range - Being consistent in monitoring and reporting on student progress. Experience with online learning platforms is a must. Certification in TEFL, TESOL, or equivalent would be an asset. Your commitment to making learning enjoyable, relatable, and effective are key to success in this role.

Thank you!

I have a financial plan d... 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, but the use o...

the project is about to create a Minecraft map that faithfully replicates a GTA RP server. GTA RP (Grand Theft Auto Roleplay) is a unique gaming style where players embody a character and immerse themselves in its persona, acting as if they were that character. Key Features of GTA RP: 1. **Roleplay Dynamics**: - Players assume the identity of a self-created character and live out their life within a fictional context alongside other players. - Interaction can be via text or, preferably, voice chat for enhanced realism. - Characters can be anything from a prominent businessperson to a foreigner unfamiliar with the local language, a mafia woman, etc. The possibilities are endless. 2. **Collaborative Storytelling**: - Every player online is roleplaying their own character. ...

I've been trying to validate my YouTube channel with multiple phone numbers, but it seems impossible. The channel mainly focuses on gaming content. I'm looking to hire a freelancer to help me with this issue. Ideal Skills and Experience: - Previous experience with YouTube channel verification - Strong understanding of YouTube's verification process - Knowledge of YouTube's policies and guidelines Looking forward to your bids.

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 need a talented social media influencer to create compelling content and promote my new cushion range on Instagram and Facebook. Key Details: - Ideal influencers would have a following made up of parents, home decor enthusiasts, and home owners. - The ultimate goals are to increase brand awareness, drive sales, and encourage user-generated content. Required Skills: - Experience as a social media influencer particularly in the home decor sector. - Proven track record of successful promotions and sales generation. - Strong content creation and audience engagement skills. - Familiarity with Instagram and Facebook platforms.

I need a quality writer with expertise in curating cocktail recipes to develop a summer-themed ebook. The intended audience is home bartenders and the recipes should be easy to follow using common household ingredients. Key requirements: - The ebook should include fewer than 50 unique alcohol-based cocktail recipes and food dishes. - Recipes should cover a range of spirits and styles, from classic to innovative. - Each recipe should come with easy to understand cooking instructions and accurate measurements. - Include high-quality images and illustrations for each recipe, if possible. - Easy-to-navigate layout with an index or table of contents at the beginning. Ideal Candidate: - Previous experience in recipe writing or food/cocktail blogging. - Strong knowledge of cock...

I'm in search of a professional to create monthly 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 "Pagamento ordine" and "Rimborso". Make the sum using the formula in column J "totale ordine" of the attached “esempio output” file 2- Filter the rows of input file 2 (attached), column D "Dettagli prodotto" 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 "dettagli prodotto”of input file column 2 are listed. (example VAT file attached) 3- The app must check th...

...The article should cover various design options, benefits and advantages of these desks, and provide a general overview of them. The target audience for this article is quite general; it should be something that can be well understood by those in various roles such as office managers, interior designers, and furniture sales representatives. The piece should be engaging and accessible to a wide range of readers, regardless of their prior knowledge in this domain. It's important that the article strikes a balance between depth of information and readability, so it would be ideal if the writer can demonstrate a good understanding of the topic and the ability to convey this in an engaging manner. A background in interior design, furniture sales, or a related field would be be...

I need a skilled WordPress developer to help me with a range of changes to my current website. Key tasks include: - adding two pages -activating social media icons - Updating and amending content throughout the website I already have all the necessary images, graphics and content for these updates. The focus of this job will be solely on the layout and content modifications.

A general information article is needed for waiting room chairs. The article should provide insight into the purpose of waiting room chairs and the benefits they provide to a businesses guests. The article is to provide a resource into understa...chairs and the benefits they provide to a businesses guests. The article is to provide a resource into understanding what sets waiting room chairs apart from other office chairs. - Must be between 1,000 to 1,200 words - Article must contain 3 to 5 references, the links will be provided upon awarding the project More details: This is for a website that provides general information on a wide range of topics. What is the main goal of your article? provide general information on waiting room chairs How soon do you need your project complet...

...what you'll need to do: - Present domain names to potential buyers * Examples: , , - Be able to familiarize yourself with the full list of domain names when making sales. 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

I’m on the hunt for a highly professional and reliable commercial cleaning service that can maintain my premise three days a week. The exact square footage of the commercial space was not provided, hence a site visit may be required to assess the area. You should have: - Proven experience in commercial cleaning - The ability to set and adhere to a cleaning schedule - The ability to handle a wide range of commercial cleaning tasks - Exceptional attention to detail The ideal candidate is someone consistent in delivering top-notch service and understands the unique concerns in cleaning commercial spaces. Looking forward to a sparkling clean working environment! I will supply my own cleaning products for this contract

...Previous experience with PI tuning is beneficial. Currently, MATLAB/Simulink is being used for modeling and system simulation, hence proficiency in it is crucial. Ideally, the candidate will have extensive experience using MATLAB for complex motor control simulations. However, I haven't defined the specific tuning methods to be used which leaves room for a range of strategies. The right candidate may suggest an efficient solution based on their past experience and knowledge. Overall, I am looking for someone to impart a level of dynamism and precision to the motor control that it currently lacks, by better tuning the PI controllers. Skills required: - Proficiency in MATLAB/Simulink - Solid grasp of field oriented control - Experience in PI tuning - Strong underst...

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 in need of a generative artificial intelligence that can analyze given text inputs and provide suggestions based on the analysis. The main purpose of this AI would be for data analysis. Key Requirements: - The AI should be primarily text-based. - It should be able to process and analyze the supplied text. - The output should be suggestions derived from the analysis. Ideal Skills and Experience: - Previous experience in developing generative AI systems. - Proficiency in natural language processing and data analysis. - Strong understanding of machine learning algorithms.

Hi, I am looking for someone to help me with courier delivery plugin for Botble Laravel CMS. 1) Technical tasks for the delivery person part - I need to add the role of the delivery person (name, phone number, passport photo (2 photos), text fields for biography, login and password) - so that he can log in to his account via login password. - When a customer orders goods, the admin must assign delivery to a certain deliveryman (list of deliverymen) that he delivered the goods to the client and should be the delivery status (picked up the goods, on the way, delivered, canceled). - Deliverer should see how much what goods delivered, new ordered goods (from admin) - notifications of new orders in telegram bot for deliverymen 2) Inside the product in each article should generate a ba...

I need someone to enter 500 purchase invoices into an Excel spreadsheet. I will provide a template for the format. The invoices will be sent to you as digital files through a cloud service, which you'll use to input the basic details like date, vendor, and amount. Ideal Skills and Experience: - Proficiency in Excel for accurate data entry - Experience in processing financial documents - Attention to detail to ensure data accuracy - Ability to handle sensitive financial information with confidentiality - Familiarity with using cloud services for file management Please let me know your experience with similar projects and how you plan to ensure the quality and efficiency of the data entry process.

...a skilled developer to create a versatile e-signing utility. This tool should allow users to select the DSC ( usb token) inserted to the local machine and can sign PDF, XML, JSON, and Text files in bulk and with the following additional features: - Bulk Signing: It should support signing multiple files at once, with no specific limit. - Predefined Output Path: Users should have the option to assign a default output path for the signed files. - PDF Signature Display: For PDF documents, the utility should display the signature as an optional feature. The goal is to have this utility developed within a month. Ideal skills for this project include: - Proficiency in programming languages suitable for file processing (e.g. Python, Java) - Experience in developing software utiliti...

I'm looking for a skilled Excel expert to create a project tracking sheet with a calendar section that lists weekly milestones. Key Features: - The main sheet is for tracking project progress. It should include: * Project /Task Name * Start Date * End Date * Progress (percentage) * Priority * Action plan * Comments - The calendar section should list team schedule. * Team working schedule "in office / out of office" * Team calendar "working remotely, annual leave, business trip, public holiday, overtime" Excel Automation: - I need the Excel sheet to have automated functions: * Conditional formatting for visual tracking: Changes in cell color or font based on the progress percentage, to quickly see if a project is ...

I'm looking for a professional 3D illustrator who can create a diverse range of animated illustrations for a logo design. The purpose of these illustrations will be to serve as the visual representation of the brand, so it's important that they are captivating and engaging. Key Requirements: - The ability to create character animations, product visualizations, and architectural renderings - Experience in logo design and understanding of brand representation - A strong portfolio showcasing a range of diverse 3D and animated illustrations In terms of the logo design, I'm open to suggestions and would appreciate any creative input you may have. Ideal Skills: - 3D Animation - Character Design - Logo Design - Product Visualization - Architecture Rendering I&#...