Excel formulas assign rank based range numbers jobs

I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.

...Display daily receipt data with graphs. o Monthly Receipt Report: Display monthly receipt data with graphs. o Annual Receipt Report: Display annual receipt data with graphical representation. o Data Source: Multiple MS SQL databases. 3. Inventory Management o Full Inventory List: Display a comprehensive list of inventory items. o Export Functionality: Export inventory data to PDF or Excel files. 4. Customer Data Analysis o Outstanding Amounts: Report on outstanding customer balances. o Receipts: Report on customer receipts. o Sales and Payments Reports: Generate detailed reports on customer sales and payments. Compatibility • The dashboard must be accessible via: o Web browsers (Chrome, Firefox, Safari, Edge) o Mobile devices (responsive design ...

I need assistance with formatting a Word document. It is a 47 page word document that needs to be formatted in terms of look and feel. There are 4 table of contents in the document to be formatted and the page numbers of the document have to be fixed. There is a 13 page pdf that needs to be converted to Word and added to the document.

I need an expert to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table structures - Attention to detail to ensure accurate transfer of...

**Contest: Excel Specialist Wanted for Comprehensive Property Portfolio Management Tool!** Are you an Excel virtuoso with a passion for crafting intricate and comprehensive spreadsheets? We're embarking on a quest to develop the of a cutting-edge Property Portfolio & Financial position Management Tool for our discerning clients. If you possess the expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will be required. 1 being password and field protected and t...

Please Sign Up or Login to see details.

I'm in need of a tool that, provided a list of words or phrases, the tool can comprehensively check the availability of those words or phrases across various online platforms. It is primarily aimed at checking the availability of domain names, phone numbers, trademarks, and social media handles. Additionally, it should search for the mentions of the given words or phrases in Google organic search and various shopping sites. Note that some of these sites may not have APIs available to perform these checks. Ideal Skills and Experience: - Proficient in Web Development: The tool needs to be designed to perform these checks on multiple platforms in a seamless and efficient way. - Familiar with SEO and E-commerce: The ability to accurately identify mentions of the given words or ph...

I'm looking to create a comprehensive web-based accounting software with essential features that will allow me to manage my finances, track inventory, generate GST reports, and handle billing. This software should also support up to 5 users. Key Features Needed: - Financial Management: The software should offer robust financial management functionalities to help me track and manage my finances effectively. - Inventory Management: A sophisticated inventory management system is required which involves product categorization, stock monitoring, and purchase order tracking. - GST Reporting: The software should have the capability to generate accurate GST reports in compliance with the relevant regulations. - Billing Features: I would require the software to support invoicing, payme...

...long-term basis. Your primary tasks will be centred around mobile app development, particularly for iOS devices, and will involve using the latest Swift and XCode versions. Key requirements include: - Solid understanding of Swift programming and XCode - Experience with pushing apps to the App Store - Willingness to work during EST time for at least 3 - 5 hours The apps created will have a diverse range of functionalities, including user authentication, push notifications, and in-app purchases. They will cater to a broad audience, ranging from the general public to business professionals. The ideal candidate for this position will have: - Proven experience in Swift programming and iOS app development - Proficiency in using XCode and submitting apps to the App Store - A good und...

I need a software expert to develop a program that scrapes text content off of multiple websites and then cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. In essence, I'm looking for someone who can create a tool that not on...

...physical products. I'm looking to have the shipping costs calculated based on the distance to the delivery address, using postal/ZIP codes as the metric. Key Requirements: - WooCommerce Setup: Need someone who is well-versed in setting up eCommerce stores with WooCommerce. - Shipping Configuration: Experience in configuring shipping settings within WooCommerce, particularly for distance-based calculations. - Geolocation Skills: Proficiency in working with postal/ZIP codes to determine distances for shipping cost calculation. - Problem-Solving: Ability to troubleshoot and resolve any potential issues that may arise during the project. Your primary task will involve implementing a system that accurately calculates shipping costs based on the distance between th...

I am looking for someone skilled in Microsoft Excel and Power Automate. This task involves creating an automation system that sends emails to our internal team members based on given triggers. The automation should trigger when: - An event's start date is approaching - An event's deadline is nearing The email content should serve as a reminder of the approaching start dates. It's pivotal that the chosen freelancer can work with accurate detail to ensure that no deadlines are missed. A deep understanding of Excel, or similar spreadsheet software, automation, and email systems is required for this task. Experience working with scheduling and deadline tracking will be an advantage.

I require an expert in Excel to help me with a statistical analysis of my sales data. The key tasks for this project are: - Conducting statistical analysis: I need you to run a detailed statistical analysis on my sales data. This will involve using advanced Excel functions to analyze variables such as sales trends, forecasts, and correlations. The ideal candidate for this project should have: - Proficiency in Excel: The chosen freelancer should have a deep understanding of Excel and be skilled in using advanced functions. - Statistical Analysis Expertise: Experience in statistical analysis is crucial, as you will be required to interpret the data and provide insights. - Attention to Detail: The work involves handling a large amount of data, so attention to d...

I'm in need of a talented game developer to create a mobile game for both iOS and Android, in the grinding genre. I will provide map converters and all necessary assets for the game. Key Features: - Multiplayer Functionality: The game should have the capability for players to interact with each other in-game. - Leaderboards: Implement a system for players to compare their achievements and progress. - In-app Purchases: Include a functioning in-game store where players can purchase virtual goods. As the project is mainly about implementing the provided mechanics, I'm looking for someone with experience in online game development, particularly in the mobile sector. In addition, knowledge of grinding game mechanics will be helpful. An ideal candidate would have experience with imp...

I'm looking for an experienced professional in Power Factory and Electronics. The project will involve a mix of tasks such as circuit design, power system analysis, PCB layout design, as well as potentially de...in circuit design, power system analysis, and PCB layout design - Capability to undertake tasks related to designing circuits, simulating power systems, and developing control systems. - Strong problem-solving ability The task involves working on a project where knowledge and expertise in Power Factory and Electronics is crucial. The right candidate should be able to provide support in a wide range of tasks and have a track record of delivering high-quality work. No teams or companies. Also, for all the auto bidders read the requirements before applying to avoid w...

I'm seeking a talented designer to create unique and engaging merchandise designs for my social media brand. This merchandise would include a range of items such as T-shirts, hoodies, and caps. I have about 30 designs I would like made and would like a fixed cost to create all 30 designs. They will not be complicated for the most part. Please message me for more info. Key Requirements: - The designs should be appealing to a broad audience, as they will be marketed to both men and women. - The preferred design style should be bold and humorous, with a touch of wit and creativity to engage potential customers. Ideal Skills and Experience: - Strong graphic design skills with a proven track record of creating engaging and popular designs. - Previous experience in designing mer...

I'm in need of a skilled professional who can help me set up Caspio forms. I'd like these forms to be embedded into my website. Key points: - Precise skill in setting up Caspio forms. - Proficiency with embedding forms into websites. - Understanding of setting up formulas integration.

I'm aiming to increase the local following on both my Facebook and Instagram accounts. The ideal number of new followers I'm targeting is between 1,000 to 5,000. Key Requirements: - Local Following: The focus is on attracting follow...city, making it crucial for the growth to be locally targeted. - Quantity: The goal is to boost each account's following by 1,000 to 5,000 followers. Ideal Experience/Skills: - Proven Experience: Must have a solid track record of growing followers on both Facebook and Instagram. - Targeted Growth: Expertise in attracting followers based on a specific location. - Quantity Delivery: Capable of providing a significant number of followers within the desired range. - Organic Growth: Ability to generate real, organic followers and no...

I need an animator to help create educational content for preschool children (ages 3-5) which encompasses all subjects with a spotlight on rhymes. The primary objective is to m...incorporating math, science, and language arts in a child-friendly manner. Plus our primary goal has always been to engage families with entertaining and educational content that makes universally relatable preschool moments fun. Our beautiful 3D animation and toe-tapping songs create a world that centers on the everyday experiences of young children. In addition to helping preschoolers learn letters, numbers, animal sounds, colors, and more, the videos impart prosocial life lessons, providing parents with an opportunity to teach and play with their children as they watch together. Where kids can be happy ...

I'm looking for a skilled website designer to create a modern, user-friendly website for my beauty salon. The main aim of this project is to showcase our services and treatments in a visually appealing and organized manner. Key Requirements: - The website should be designed to effectively showcase our range of services and treatments. - It should include a detailed price list for our services. - The design should be modern, engaging, and suitable for the beauty industry. A clean, professional and elegant style is preferred. - It must be user-friendly and easy to navigate, ensuring visitors can quickly find the information they need. - It should have a Content Management System (CMS) that allows easy updating of the content. - The website must be responsive, ensuring it looks g...

I need to improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want to use “setup” 3- 3- Generate report even i...

I am in need of an Articulate Storyline expert to create an exciting, interactive game-based learning module targeted at adults. Requirements: - The module should have a moderate level of interactivity, including quizzes and drag-and-drop elements - The content must be engaging and challenging for adult learners, it should be both informative and entertaining - Attention to detail is crucial, the module should flow well and be free from technical errors - You are encouraged to bring creativity and originality to the project, it should not be a standard, uninspired e-learning module Ideal Skills: - Expertise in Articulate Storyline is paramount - Experience in developing game-based learning modules is a major plus - Understanding of adult learning principles and ...

I'm seeking a savvy developer to create a 1D barcode (UPC, EAN) inventory management system. This should then be integrated with an existing product management system. Key requirements: - Design and develop a user-friendly barcode inventory control system - Experience with 1D barcodes, preferably UPC and EAN - Capability to integrate with existing product management software The main users of this system will be store staff members. Therefore, it should be easy to navigate, and seamless in functionality to support a fast-paced retail environment. Expected expertise: - Proven experience in building similar inventory management systems - Proficiency in working with 1D barcode technology - Expertise in software integration - Solid understanding of user interface for non-technical ...

...skilled freelancer who can help automate various tasks in Excel. This includes, but is not limited to, data entry, formulas, and calculations. Key responsibilities: - Automating data entry processes within Excel - Implementing advanced formulas and calculations to streamline calculations - Generating reports and carrying out data analysis using Excel - Ensuring the accuracy and integrity of automated processes Ideal skills and experience: - Proven experience in automating tasks in Excel - Advanced knowledge of Excel functions and formulas - Ability to understand complex data sets and create accurate reports In your application, I'd like to see: - Examples of similar projects you've worked on - Details of your experienc...

I need a web scraping expert to gather data from the Maharera Maharashtra website. The data to be extracted includes agent names, their respective registration numbers, and contact details. The ideal candidate should: - Be proficient in web scraping techniques - Have prior experience in scraping data from government websites - Be able to deliver the project as soon as possible As I need this information urgently, I'm looking to have this done as a one-time scraping job.

...track the number and timing of messages sent. More information: Can someone develop an Android app that can do the following: Automatically send a message in a WhatsApp group at random times. For example, send 3-5 messages per day at random times. The number of messages should be adjustable within the app. The messages should be sent between 9:00 AM and 10:00 PM (always at random times). The time range during which the messages are sent should be adjustable within the app. Why do we need such an app? These messages are intended to prompt a person in the WhatsApp group to take an alcohol test and post the video of the test in the WhatsApp group. The purpose is to monitor an individual with alcohol dependency to ensure they do not consume alcohol. The other members of the WhatsA...

I am seeking an expert in data entry, particularly in the tasks of document conversion, data processing, and data verifi...necessitates the management of confidential and sensitive information, hence, a demonstrated respect and understanding for data privacy is paramount. Key Responsibilities: • Document conversion • Data processing • Data verification Required Skills and Experience: • Proficient with MS Excel • Demonstrated experience in similar roles handling sensitive data • Strong attention to detail • Respect for privacy and confidentiality Note: Familiarity and experience with utilizing formulas and pivot tables within Excel are highly desirable, given the nature of tasks to be performed. Integrity, diligence, and meticulou...

I'm ...seeking a reliable administrative assistant to help me compile a marketing booklet for general public distribution. Key Points: - The booklet will serve as a marketing tool, so it's crucial that the freelancer has a knack for presenting information in a clear, engaging, and persuasive manner. - As the target audience is the general public, the language used should be clear and accessible to a wide range of readers. - The ideal candidate will have experience in designing both digital and printed materials. - Attention to detail is crucial to ensure the final product is polished and professional. If you have a background in marketing, design, or administrative support and are confident in your ability to put together this booklet efficiently and effectively, I'...

I need assistance with copying & pasting data from spreadsheets. The dataset is less than 1,000 entries. Ideal skills and experience for this job: - Experience with data entry, especially from spreadsheets - Attention to detail - Proficiency in Excel - Ability to meet deadlines It's a straightforward task. The goal is to ensure the data is accurately copied and pasted.

I need an experienced Excel programmer to automate repetitive tasks and create custom VBA macros for my project. This assignment requires basic level tasks, so extensive experience in complex macros isn't necessary. Here is what I expect: - Automation of several repetitive tasks to streamline workflow and increase productivity - Creation of custom VBA macros from scratch Ideal Candidate: - Extensive experience with Excel automation and VBA macros - Ability to comprehend and successfully complete basic level assignments - High attention to detail and accuracy Please include your Excel automation and VBA macros experiences in your application. I look forward to working with you on this project.

...business. The website should include: - A home page with a few critical pieces of information, namely: - A comprehensive business overview - Contact Information - Client testimonials to build credibility - Educational materials on different types of therapy services provided - An 'About Page' giving insight into our company's values, mission, and team. - A 'Services Page' detailing the range of therapy services offered. Bringing in some expertise in UX/UI design will be beneficial for this project. Proven graphic design skills, particularly logo design, are also advantageous. An understanding of the counselling or therapy industry could be helpful but is not required. It's important for the potential freelancer to keep the target audienc...

...seeking professionals who can execute makeup, car customization, and car restoration projects. These projects are strictly for personal use. In your application, please include detailed project proposals, with a focus on the specific skills and experience you have in these areas. Key Details: - The scope of work will vary depending on the specific projects. - Makeup application: I'm interested in a range of makeup styles and techniques, from natural to avant-garde. - Car customization: This includes modifications to enhance aesthetics and performance. Knowledge of automotive design and mechanics is a plus. - Car restoration: The objective is to restore a vehicle to a condition as close to its original state as possible. Ideal Skills and Experience: - Extensive experien...

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

This is for my College final project, I need to develop a simulation of AI based threat detection.

Please Sign Up or Login to see details.

I'm seeking a highly professional Korean voiceover talent within the age range of 25-50 years. I have no gender preference as long as the delivery is authoritative and has an excellent command of the language. Key Requirements: - Fluent Korean language skills - Experience in voiceover work, particularly in a professional, authoritative tone - Must be within ages 25-50 - High-quality audio recording capabilities Looking forward to giving your talent a platform. Please include your previous work in your proposal.

I'm in need of a skilled Wordpress developer who can help optimize my website for specific keywords to improve its SEO ranking. The primary goal is to rank positively for keywords - not just chase them. Key Requirements: - Solid understanding of SEO - Proven experience in optimization - Proficiency in keyword implementation - Good grasp of backlink building techniques - Experience working with Wordpress sites and optimizing them for search engines Your main responsibilities will be: - Reviewing the technical areas of the website for keyword optimization - Implementing on-page optimization strategies - Developing and executing a robust backlink building strategy Ideal for someone who is a Wordpress expert. Has a strong foundation in SEO. If you have a track record of impr...

...customise a blank product with their own logo/design. The website's primary objective is to host a substantial number of products for sale, so experience with building comprehensive online stores is a must. Key Requirements: - E-commerce Expertise: I need a freelancer who's well-versed in e-commerce site development. Your prior experience with creating such platforms, particularly with a product range exceeding 100 items, will be highly beneficial. - Payment Gateway Integration: The website should allow customers to pay via credit card and PayPal. Your proficiency in integrating these payment methods securely and seamlessly is essential. - Customizable Design: While I have a vision for the website's aesthetics, I'm open to suggestions. Your ability to design...

Functionalities of Chrome extension : 1: scan any buttons fields used computer vision or openai vision or Google gimini to recognize fields or buttons 2: creator record macro auctions in same time record/uploading voice and notes 3:export files then shared the files with others that have same chorme extension Output: macro working without in others that have same extension 4: deployment on marketplace

Product Description: - FamPe is a platform that enables viewers to interact with their influencers through messages and monetary contributions. Adding a monetary contribution prioritizes and highlights their comments/messages. Brand Name: FamPe "Fam" is a keyword used by influencers to refer to their fans because it creates a sense of closeness and community. This platform enables fans to contribute (monetary contribution) to their influencers, especially in Live Streams. That's where the name FamPe comes from. Brand Values:- - Innovation - Reliability - Efficiency - User-Friendly Logo Style Preferences:- - Audience: YouTube streamers and viewers, ages 15-45, worldwide demographic - Type: Wordmark logo, modern and minimalist - Feel: Exclusive, Professional, trustworthy, c...

I have a kitchen range hood in the restaurant, I need the hvac design including the exhaust and ventilation design of the range hood with the calculation, the range hood is of 16' Please submit your sample work alongside thanks

I require a capable developer to create a new Python module from Wazuh server using C programming. This module should retain the following functionalities from the original: - Agent registration - Remote configuration - Log receiving A deep understanding of TLS and SHA technologies is a must.

...long-term basis. Your primary tasks will be centred around mobile app development, particularly for iOS devices, and will involve using the latest Swift and XCode versions. Key requirements include: - Solid understanding of Swift programming and XCode - Experience with pushing apps to the App Store - Willingness to work during EST time for at least 3 - 5 hours The apps created will have a diverse range of functionalities, including user authentication, push notifications, and in-app purchases. They will cater to a broad audience, ranging from the general public to business professionals. The ideal candidate for this position will have: - Proven experience in Swift programming and iOS app development - Proficiency in using XCode and submitting apps to the App Store - A good u...

I'm seeking an experienced Excel wizard capable of making my inventory report more dynamic and adaptable. Here's what I need: - Total Calculations: The report doesn't currently update the total inventory count and monetary value when I adjust the count of individual items. I require this to be automated so the totals are accurately recalculated whenever an inventory count changes. - Regular Updates: Going forward, I will be regularly updating inventory counts on a weekly basis. I would appreciate if the system is simplistic and user-friendly for regular updates. Ideal Freelancer Skills: - Advanced knowledge of Excel functionalities - Experience on inventory management systems - Meticulous attention to detail - Ability to create user-friendly systems. The o...

I'm looking for a skilled engineer who can design a self-supported steel chimney for a metal manufacturing plant. This chimney will be integral to industrial emissions control. Tasks Include: - Tailoring the design to accommodate the specific needs of a metal-manufacturing environment. - Incorporating robust safety features and compliances for high-temperature metal emissions. Ideal skills: - Structural Engineering - Industrial Design - Knowledge of industrial emissions standards - Experience with metal manufacturing processes.

...form content pages, and have a link to the ‘case studies’ housing section in the footer of the site rather than in the primary nav menu. Service pages - I want the capability to build out the service pages. At the moment we just have the primary service page, but I want to build out sub-pages that will sit in a secondary menu when hovering on the service section in the primary nav. Add Rank Math I want Rank Math added in as a plugin to help with the SEO optimisation of my pages....

I'm seeking an experienced CAD jewelry designer for custom-made jewelry pieces. Key tasks include: * CAD designs for a three different types of jewelry: rings, necklaces, and bracelets. * All designs will need to incorporate a mixture of materials such as gold, silver, and gemstones. The ideal candidate would have: * Proficiency in CAD software specifically for jewelry design. * Familiarity in using diverse materials such as gold, silver, and gemstones. * Experience in creating varied forms of jewelry like rings, necklaces, and bracelets. Your portfolio displaying your previous work in CAD jewelry design will be highly favored in the selection process.

...able to help me create a sustainable operational structure that ensures smooth running of the business. Target Market: I'm looking to cater to a wide range of individuals including children, adults, and elderly individuals with disabilities. It's important that the business plan reflects how we can effectively reach and serve these different market segments. Ideal Skills and Experience: - Experience in writing business plans, particularly for NDIS service providers - Strong research and analytical skills to conduct market analysis - Proficiency in financial planning and projections - Understanding of operational structures in service-based companies I'm excited about this venture and I'm looking forward to working with someone who can help me turn th...

...track the number and timing of messages sent. More information: Can someone develop an Android app that can do the following: Automatically send a message in a WhatsApp group at random times. For example, send 3-5 messages per day at random times. The number of messages should be adjustable within the app. The messages should be sent between 9:00 AM and 10:00 PM (always at random times). The time range during which the messages are sent should be adjustable within the app. Why do we need such an app? These messages are intended to prompt a person in the WhatsApp group to take an alcohol test and post the video of the test in the WhatsApp group. The purpose is to monitor an individual with alcohol dependency to ensure they do not consume alcohol. The other members of the WhatsA...

...straightforward e-commerce platform for my business. The site will primarily serve as a virtual store for my products and services. Key Requirements: - The website should have a user-friendly layout that appeals to customers - It should incorporate a simple checkout system that supports multiple payment methods - I plan to initially list between 1-10 products, so the site should accommodate this range - The payment gateway should be capable of handling diverse payment methods including Credit Card, PayPal, Bank Transfer, and UPI - The design should be minimalist but engaging, prioritizing product display and secure payment options Ideal Experience: - Proficient in e-commerce website development - Strong understanding of user interface and user experience design - Familiarity w...