Car loan calculator excel jobs
I'm looking for a detail-oriented researcher to help me gathe...charts can come later. Time is critical - ideally 24 hours. - Sector-wise breakdown: I am particularly interested in the finance/investment sector. Hence, your role will be to provide in-depth insights into the investment figures within this sector. Ideal candidate should have: - Strong research experience - Experience in economics or finance - Ability to analyze & interpret data - Proficient in Excel or data analysis tools - Access and experience with databases including Office for National Statistics (ONS) in the UK /EUROSTAT and STATISTA (paid) for the EU and Investment Association (UK) This project requires a detail-oriented, problem-solving researcher. The figures/charts should all be referenced with t...
I'm in urgent need of a seasoned expert in Microsoft Excel, particularly in creating financial models with emphasis on cash flow management. The ideal freelancer for this project should have proven experience in constructing similar tools for businesses. Key Areas of Focus: 1. Housemaid Cash Flow Tracker: This spreadsheet will facilitate tracking cash provided to our two housemaids and matching their submitted invoices. With three team members involved, it needs to be straightforward and efficient. 2. Monthly Household Budget Expenses: This spreadsheet will serve as a comprehensive monthly budget for all household expenses, including groceries, Amazon purchases, and payments to other suppliers. I envision a format where invoices and supplier names are listed vertically, with ...
...for an expert in Excel who can assist me with designing a functional cash flow budget. The primary aim of this tool will be to help me track and effectively manage two team members expenses. Key requirements for this project are: - Excellent proficiency in Excel, particularly in designing complex budgets and financial spreadsheets. - Experience creating automated functions within Excel, specifically for totalling expenses. - Ability to create a user-friendly and aesthetically pleasing interface that enables efficient data entry and report viewing. The freelancer would need to provide consistent updates and flexibility for potential adjustments during the process. This initiative is essential for my financial planning and needs to be done professionally. If you...
need a skilled freelancer who is an expert in creating financial formulas in Excel. You'll work exclusively with data I provide. Ideal candidate should have: * Expertise in Excel with a specific focus on financial formulas Ddata will be provided
I'm looking to have a website built that will serve as a platform to showcase our car inventory. This website is crucial for our business as it will be the central point for potential customers to peruse and get to know the cars we have on offer. Key Features: - The primary function of this platform is to showcase our car inventory. Therefore, the main focus should be on the design that will effectively showcase the cars in the best possible light. - I would like the website to have a user-friendly search and filter option. This is important as it will allow our clients to easily find the car they are looking for. - It's important that the site is designed to be responsive across various devices to ensure potential customers can access it no matter what d...
I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.
...artwork. I am planning a classic car meeting event and I need a flyer that stands out in A4 format Here's what I need: - The main theme of the artwork is a classic car meeting set in a recognisable square in Peer, Belgium. - The style should reflect the captivating comic book aesthetic of the examples in the attachment - Pay attention to details, it needs to include clear representations of the location and the classic cars. Ideal skills for this project: - Strong understanding of comic book art - Ability to design based on real locations and vehicles - Experience in creating promotional artwork. This artwork will be key in promoting our event, so it's essential that it's absolutely fantastic. Apply if you are confident that you can bring this classic ...
As an individual currently managing a project with numerous details and a profit loss statement, I need assistance with daily tasks for our Excel sheets. This will include: - Data entry and organization to streamline workflow - Basic arithmetic calculations for accuracy - Statistical analysis to make informed decisions - Formatting and visual presentation for clarity This role requires proficiency in Excel, a keen eye for details, and strong analytical skills. Experience in financial or project management is a plus. The job will be ongoing and requires daily attention. If your expertise aligns with these needs, please apply.
I'm in need of a dedicated Sales Development Rep with a proven track record in cold email marketing. As part of the role, you'd specifically be working with Instantly, so experience with this tool is a must. Responsibilities: - Primarily focus on cold email marketing to generate leads in the mortgage industry. - Ultimately, the main target is to get more appointments booked and loan applications. Ideal Skills and Experience: - Previous experience as a Sales Development Rep specializing in cold email marketing. - A strong understanding of the mortgage industry. - Proficiency in using Instantly. - Demonstrated ability to increase lead generation and improve conversion rates through cold email marketing. - Exceptional communication and persuasion skills. This is a full-tim...
I'm looking for a skilled graphic designer to create a unique, dynamic logo for my upcoming automobile brand, BORCELLE CAR SERVICE. The deadline for this project is the 19th of April. My budget is up to $55. Even though I don't have preferences for colors or symbols to be used in the logo, I expect the designer to bring creativity and innovation to the table. Experience in logo designing, especially for automotive or similar industries, will be appreciated. A good sense of color combinations and an understanding of branding impact are essential. Your portfolio will be considered among the major deciding factors. Please bid only if you can guarantee the delivery by the specified deadline.
I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.
I'm looking for an expert in Excel to assist with a project involving data entry and analysis. The Excel sheet you'll be working on has more than 50 columns and rows and will contain a mix of text, numbers, and dates. You'll be responsible for the following: - Accurate and timely entry of the data provided - Ensuring the data is appropriately formatted and organized - Conducting thorough data analysis, including but not limited to trends, comparisons, and any other insights that can be drawn from the data The ideal candidate for this project should have: - Proficiency in Excel and experience with large data sets - Strong attention to detail - Ability to perform data analysis and present insights - Good communication skills to provide regular updates a...
I'm on the lookout for a talented virtual assistant who thrives on lengthy hours of work and enjoys every second of it! This isn't your usual VA role, though - I'm seeking someone who can confidently handle the following responsibilities: - Social Media Management: More specifically, I need someone adept at Instagram. You'll be responsible for handling and managin...our audience. Ideal Skills and Experience: - Clear understanding of the Instagram platform and how to optimally engage audience in it - Skills in crafting Instagram worthy content - visuals, captions, and stories - Experience in managing professional instagram account is a plus - Must be organized, communicative, and able to handle long hours of work If this sounds like the sort of work you'd exc...
For this project, I require an expert who can efficiently extract text content from two distinct webpages and input my data into an Excel file organized by rows. Given that all types of data hold equal importance to me, of essence is for the professional to: - Accurately scrape all text content from the specified webpages - Ensure no data is skewed or omitted during this process - Neatly organize the data by rows in the Excel file The ideal candidate for this job should be proficient in web scraping tools and techniques, possesses an acute attention to detail, and is experienced in using Excel to ensure data is properly formatted and easy to analyze. Please note that minimizing errors during this process is critical, as the data collected will directly influence fur...
...(tariff payment and number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, whe...
...tenure, salary and location of our employees. Your ability to structure and organize these aspects will be key. - Creating an Excel-based system: I'm looking for a dashboard that's easy to dissect and understand. As such, I'd like the final product to be in Excel spreadsheet format. This means you should be very proficient in Excel, knowing how to integrate formulas, tables and other relevant features. - Monthly updates: The dashboard should be designed to be updated monthly. You should be dedicated to ensuring that the data is up-to-date and accurately represented. Ideal freelancer should have: - Proven experience in HR analytics and dashboards - Excellent Excel skills - Ability to present complex data in a clear and concise manner - Strong...
I have an excel sheet with intermediate complexity data, including formulas and charts. I need someone to transfer this data into tables, with the primary goal of organizing the information for better clarity and ease of understanding. Key Tasks: - Type the data into tables: This needs to be done with meticulous attention to detail to ensure accuracy and integrity of the data. - Apply borders and shading: To enhance the visibility of the tables and make them aesthetically pleasing. - Utilize headers: Rows and columns should have appropriate headers to aid in quick data navigation. Ideal Freelancer: - Proficient in Excel: Ability to work with intermediate level of data such as formulas and charts. - Strong attention to detail: Critical for ensuring that data is entered accur...
I'm in need of a skilled web developer to create a website for my new car dealership. The website will include a comprehensive set of features to ensure a smooth and user-friendly experience. Key Features: - Advanced Search Filters: Enable users to easily find their desired car based on various criteria such as make, model, year, price, etc. - Online Payment Integration: Implement a secure and reliable payment gateway for seamless transactions. - User Reviews and Ratings: Allow customers to leave feedback and rate their purchase experience, enhancing the credibility of the platform. Vehicle Listings: The website will exclusively list new cars. Therefore, it's essential to focus on showcasing these vehicles effectively. News Section: Additionally, I'm inter...
I have a small desktop application (little bigger than windows calculator sized) that was developed couple of years ago and now wanted to revamp the UI to latest design. Note: It's an algo trading application but the UI developer need NOT know anything about stock market because functionality development is being taken care by other developer. Ideal skills for this project include: - Proficiency in UI/UX design - Experience in desktop application development - Attention to detail and user-centric approach.
...looking for an Excel expert who can create a comprehensive sales target tracking spreadsheet for my customers. This spreadsheet should have several key functionalities. Features Needed: - Customer Information: It should contain a section where I can input and maintain all my customer's details. - Sales Tracking: The spreadsheet should enable me to track my sales targets daily and provide a detailed analysis of my performance. - Target Achievement: The spreadsheet should also be able to analyze the achievement or shortfall of selected items target completion by each customer. Analysis Required: - I would love to have a feature that shows how well sales targets are being achieved as per defined targets. Ideal candidate should have great attention to detail, proficiency...
I need an organized mind to help with research and data entry of a list of companies in a specific industry. Your main responsibility will be organizing this data. While basic Excel skills are a must, experience with data organization, particularly in a business context, would be highly beneficial. The data will be divided into 4 separate categories, so whoever takes on this task needs to have a keen attention to detail and an understanding of categorization. This project is perfect for an individual who thrives in organizing and systematizing data.
**Tour Costing Sheet Structure** 1. **Tour Details** - Tour Name - Tour Code - Duration - Destinations 2. **Client Information** - Client Name - Number of Adults/Children - Contact Information 3. **Accommodation** - Hotel Name - Room Type - Meal Plan - Cost per Night - Total Nights - Total Cost 4. **Transportation** - Vehicle Type - Distance - Cost per Kilometer - Total Cost 5. **Sightseeing and Activities** - Activity Name - Per Person Cost - Number of Persons - Total Cost 6. **Miscellaneous Expenses** - Guide Fees - Entrance Fees - Other Expenses 7. **Pricing** - Subtotal (Sum of all costs) - Markup Percentage - GST (Goods and Services Tax) - Final Price 8. **Payment Details** - Deposit Require...
...corruption - Your research and investigation skills must be top-notch - Experience in handling sensitive information and maintaining confidentiality is a must - The ability to present your findings in a compelling and newsworthy manner is crucial - Experience with uncovering fraud and unethical business practices will be highly valued. Your investigative work will be centered around a specific case: a car dealership scam. Your task will be to delve deep into this scam, uncover the intricacies of the fraud, and present your findings in a manner that is both engaging and exposes the truth. Time is of the essence for this project so I am looking for someone who can work quickly and deliver results ASAP. If you have experience in such matters, have a knack for investigative journ...
I'm looking for an experienced web scraper to access and download specific information and images from the Used Inventory section of the White Rock Honda website. Here are the specifics of what I need: - Car make and model - Year of the car - Price of the car For each car listing, I need ALL available images downloaded. Furthermore, I require the images in JPG format. Candidates applying should have successful experience in web scraping, data extraction, and handling myriad images. Efficiency and accuracy are critical for this project.
I am currently working on a project that requires the integration of Excel with a PostgreSQL database. As such, I am in need of a freelancer who is proficient in both Excel and PostgreSQL. The primary tasks to accomplish include: 1. Exporting data from Excel to SQL 2. Updating PostgreSQL data using Excel You will be working with various kinds of data as we aim to streamline our operations in a more efficient manner. Ideal skills and experience include: - Solid understanding of PostgreSQL - Expert skills in Excel - Previous experience with SQL data exporting and updating The success of this project highly relies on a flawless data transfer between Excel and PostgreSQL. Your expertise will be extremely valuable to our project's completi...
I'm in need of an expert to assist with the cleanup of our Medicine database. The goal of this project is to accurately remove all duplicate entries improving the overall accuracy of the data. Ideal Skills & Experience: - Strong background in Database / Excel /CSV management, specifically in the medical field. - Proven track record of similar past work. In your application, please include details of similar projects you've worked on. Efficiency and precision are pivotal for this task. Looking forward to a neat and streamlined database!
I have a channel where I make EXCEL educational videos, I upload 12 videos a month, between 5 to 7 minutes each. YOU MUST BE ABLE TO : - Have experience in editing videos for YouTube. - Have basic knowledge of Microsoft Office, to be able to edit the videos better. - Be able to edit 10- 12 videos consistently every week (Some will be only 1 minute long). IF YOU WANT TO STAND OUT FROM THE REST SEND US YOUR PORTFOLIO
Seeking an expert in digital photo enhancement for a personal project. The goal is to improve resolution on two car license plate photos to enable number and letter identification. Requirements: * Apply resolution enhancer to ensure license plate details become readable * Previous experience in photo enhancement and resolution improvement is necessary * Please respect the intent for this task, which is solely identification purposes. This task would best suit those with a background in digital forensics or similar. Your ability to maintain discretion and confidentiality is highly appreciated. With your help, we can make the hazy, clear.
I need a word document translated from English to Russian as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!
I am in need of a specialist to optimize my Amazon product listings for coloring books. The key focus will be enhancing visibility and maximizing customer engagement for my book collection. Here's what I am looking for in a freelancer: - I need you to know more about KDP marketing than I do. I only know the basics. I need an advanced skilled...listing. - Suggesting effective marketing strategies tailored to coloring books. - Execute strategies once approved. - Expertise in Amazon's A9 algorithm to optimize listings. Through these efforts, the ultimate goal is to increase the visibility of my coloring books on Amazon, targeting a better ranking in search results, and thereby improving sales. If you have the skills and experience to excel in this role, I would be thrill...
As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.
I'm in need of an Excel formula expert to help me with a specific task. I need a formula that will COUNT cells based on the following criteria: - I need to COUNT the number of cells in a range that are greater than -250 - The count should be done for the last 50 cells (ongoing) Your task will be to help me create a formula that dynamically counts the number of cells based on the above criteria. I need this formula to be able to adjust as new values are added to the range. The ideal Freelancer for this project should have: - Extensive experience with Excel functions and formulas - Strong understanding of dynamic range referencing in Excel - Excellent communication skills to explain the logic behind the formula in layman's terms Please include any relevant...
...three categories: A) Abbreviation letters, B) The full word representations of those abbreviations. C) and comprehensive definitions elucidating the meaning and context of each abbreviation and its corresponding full word. Examples: 1) BTL - Buy-to-Let: A property investment strategy where the property is purchased with the intention of renting it out to tenants. 2) LTV - Loan-to-Value: The ratio of a mortgage loan amount to the appraised value or purchase price of a property, expressed as a percentage. 3) APR - Annual Percentage Rate: The annualised cost of borrowing, including interest rates and additional fees....
I'm seeking a highly skilled programmer proficient in Excel macros and ODBC data connections to automate critical processes in my business. Specifically, your tasks will involve: - Automating order tracking, inventory management, and vendor communication processes. - Connecting to Excel files, SQL databases, and CSV files using ODBC. - Developing an automated procurement system capable of: - Generating purchase requisitions, - Aiding in vendor selection and negotiation, - Creating and tracking purchase orders. Proficiency in utilizing Excel macros is a must, and experience with ODBC data connections and related platforms is highly desirable. Knowledge of procurement systems and order logistics would be beneficial. Successful completion of this project req...
Project Brief: Dental Lab Website Development Objective: To create a comprehensive and user-friendly website for [Dental Lab] that showcases our dental lab services, highlights our car cam milling center, and offers a seamless online ordering experience for other labs and dentists. Key Features: Service Representation: A detailed section showcasing our range of services, including custom dental prosthetics, orthodontic appliances, and our specialized car cam milling services. Online Order Form: An intuitive and secure form that allows clients to easily place orders, with fields for specific requirements and preferences. File Upload Capability: A secure portal for clients to upload digital impressions or design files, supporting multiple file formats. Payment Gateway Integrati...
I need an expert in Microsoft Excel to build an efficient spreadsheet to monitor potential lost revenue due to late service deliveries. The ideal candidate would possess a strong background in creating financial models and understanding of revenue tracking. Key Requirements: - Proficient in Microsoft Excel, with emphasis on creating advanced, clear, and highly-functional spreadsheets. - Experience in financial modelling and understanding of revenue tracking. - Ability to automate the process as much as possible to minimize manual tracking. Objective: - Create an intuitive and efficient Excel spreadsheet to replace the current manual method of tracking potential lost revenue due to late service. Skills Needed: - Microsoft Excel - Financial modelling - Adv...
I'm searching for an experienced PR agent that can focus ...Taiwan, Singapore, and Kuala Lumpur. The main goal of this project is to promote our car rental services for travelers to Europe. Key Responsibilities: - Developing and executing a PR strategy to increase brand awareness and promote - Building relationships with key media outlets in the specified countries - Managing different media channels for different audiences Ideal candidates should have: - Proven experience in PR in the Asia region - A strong network with media and influencers - Experience in promoting services, ideally in the car rental industry Your work will be instrumental in establishing our presence in the Asian market for people who are aiming travel to Europe countries and driving our car...
I am seeking a skilled app developer to create an application akin to AirBnB but for luxurious, exotic car rentals. This app will cater to two specific user types: ones who are looking to rent an exotic car and owners of such luxurious automobiles who wish to offer them for rent. Here are the features expected in the application: - A Car Reservation System: The ability for users to book their desired exotic car. - User Profiles: Both renters and owners should be able to set up their profiles. - User Reviews and Ratings: To maintain transparency, reviews and ratings from past rentals should be displayed. For owners, the application must provide: - A Vehicle Listing Feature: To showcase their available vehicles for rent. - Rental Rate Setting Tools: Allow th...
I'm seeking a professional to diligently run through LinkedIn, identifying and documenting HR higher-u...Identifying: I'm targeting senior-level personnel only. Expertise in navigating LinkedIn search and understanding corporate hierarchies will be a plus point. 2. Documenting: I'd like the findings to be presented in a tabular form within an Excel document. Critical data points to be captured include the Company Name, individual's LinkedIn Profile link, and their Role. Your background in HR and corporate structures would be critical in understanding the perfect fit for my requirements. Strong organizational skills, meticulous attention to detail, and proficiency in Excel would be highly appreciated. Overall, a good grasp of LinkedIn-based research would...
I'm looking to build an interactive car selling website. It should be a platform where users can browse, search and list vehicles for sale. Key Features: - Search Functionality: The website must have robust search capabilities that allow users to filter by make, model, year, price range, etc. - Vehicle Listing Page: Each vehicle should have its own dedicated page with all relevant details and images. - User Registration and Login: Users should be able to sign up, create profiles, and manage their listings. Shopping Experience: - The purchase process will be facilitated directly on the website, with all necessary functionalities for transactions and user verification. Design: - I don't have a specific design in mind, so I'm open to suggestions on how to make the pl...
I'm looking for a skilled freelancer to help me create a pivot table in Microsoft Excel that will be used to find pricing quicker Key Requirements: - The pivot table must be created in Microsoft Excel. - The purpose of the pivot table is to find pricing easier The data sources which the pivot table will be using are confidential, and will be shared with the selected freelancer.
I'm looking for a graphic designer who can skillfully change the background of an image to create a new environment. Specifically, the image is of my wife on our wedding day, she really wanted a picture of her with the car, but we forgot on the day and missed the opportunity. Key Tasks: - Add picture of her beetle into the background of a wedding picture - Insert a high-resolution, realistic new environment - Position my Beetle car prominently in the image - Images can be sent over Ideally, you have previous experience with car image editing and can demonstrate a high level of attention to detail. I'm expecting the result to be realistic and in high definition. Proficiency in Photoshop or equivalent software is required. If you appreciate cars, specifical...
I'm seeking a proficient individual to help with a data entry project. I have about 40 URLs, from which I need to extract the product names, prices, and descriptions. The goal is to collate this information in a pre-defined Excel template. Key Aspects: - Extract product names, prices and descriptions from 40 URLs. - Populate an Excel file with the gathered data.
I'm seeking a skilled individual with a strong command of Microsoft Excel and Word. The tasks at hand are primarily data entry, table creation in Excel and development of an instruction manual in Word. Key Responsibilities: - Efficiently perform data entry tasks in Excel. - Create tables in Excel to visually present the data. - Develop an instruction manual in Word. Ideal skills for this project include: - Advanced proficiency in Microsoft Excel, with a strong expertise in data entry and structuring information. - Proficiency in creating tables, and potentially pivot tables. - Strong experience in creating documents in Word, preferably instructional or informative content. - Attention to detail, as accurate data entry is vital. - Strong communica...
Pr...imagery to create a cohesive look. - Include space for product descriptions, ingredients, and nutritional information. - Consider eco-friendly packaging options and materials. ****Additionally We need a creative concept for one packaging that have a place for the drink and place for the fries and place for the sauce so that the people can vary it n one hand and can fit the coffee holder inside the car.**** **Design Inspiration:** - Playful and vibrant designs that capture the essence of potato fun and excitement. - Incorporate potato-themed illustrations, patterns, and graphics. - Explore unique shapes and structures that stand out for takeaway customers. - Consider interactive elements or surprises that enhance the takeaway experience. Follow the branding color attach...
I am in need of a comprehensive business plan focused on a technology industry, primarily crafted to secure a bank loan. As such, the business plan should instill confidence in our financial viability and be convincing enough for loan approval. Key responsibilities would include: - Researching and understanding the nuances of the technology industry - Detailed financial planning including projected revenues, costs, and profitability Ideal freelancers for this job will: - Have a deep understanding and experience in the technology industry - Have strong financial planning capabilities - Show a proven track record in crafting successful business plans for securing bank loans - Be able to communicate technical and financial details in an understandable and compelling way.
I'm in need of an Excel calendar for 2024 - 2025 that will be used for tracking school days off and special events. The calendar should feature the following: - Ability to add and modify events - Monthly view - Color-coded categories - Dates should be highlighted with background color Ideal skills: - Proficiency in Excel, including knowledge of advanced functions - Experience in creating and customizing calendars - Design proficiency to ensure aesthetic and functional layout Look at the Sample
I'm in need of a virtual assistant to help with a variety of tasks, specifically: data entry, email management, and conducting research. ...help with a variety of tasks, specifically: data entry, email management, and conducting research. Ideal Skills and Experience: - Proficient in Google Docs and Sheets - Experience in managing email inbox - Can attend video calls and meeting to write MOM with clients I'm looking for someone who can commit to more than 20 hours per week. The ideal candidate should have a basic understanding of Excel or Google Sheets. Your job will be to document data, answer emails effectively, and conduct research on various topics. I am looking for someone who is timely, organized, and detail-oriented. Please reach out if you think you are a goo...
I have a calculator form that needs some updates made. It allows the user to input measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: New page (needs some jQuery updates): Also have Excel with new formula
