Pricing calculator
- or -
Post a project like this1795
£50(approx. $63)
- Posted:
- Proposals: 20
- Remote
- #2397804
- Awarded
Microsoft Certified Power BI Data Analyst & Advance Excel Specialist¦Professional Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦
Doha
Web Scraper, Programmer, Data Mining, Text Mining, Algorithm, AI, Image processing, Python
Faisalabad
Business and Continuous Improvement Consultant, Excel and Google Sheets Development
Cardiff
Virtual Assistant | Web Research Specialist | Excel | Fillable / Editable PDF |Data Mining Specialist |Data Extraction | & Project Coordinator
Cairo
Full Stack Web & Software Application Developer with good knowledge of C#-ASP.Net, PHP-MySQL, Python, AJAX, jQuery, Bootstrap
Indore
1406416171158627300122723856271842927174082704195243555622255761912774178829012721
Description
Experience Level: Entry
I am looking to develop a very simple pricing spreadsheet. What I need is a cell where a value (capacity) can be entered and a and price outputted based on a tiered pricing structure.
For example:
band 1 - 0 to 99 (price rate $0.007)
band 2 - 100 to 299 (price rate $0.005)
band 3 - 300 to 599 (price rate $0.003)
band 4 - 600 to 999 (price rate $0.002)
band 5 - 1000 and beyond (price rate $0.001)
If I was to select a value of 650, the calculator must blend band 1, band 2, band 3 and band 4 based on each band to calculate the price (differential equation?) for any given scenario through each band. Its not a difficult calculation process but I also need it to be user friendly but to also have seperate pricing band in order to to the calculation. Plus it must be easy to maintain when if the pricing bands need to change.
For example:
band 1 - 0 to 99 (price rate $0.007)
band 2 - 100 to 299 (price rate $0.005)
band 3 - 300 to 599 (price rate $0.003)
band 4 - 600 to 999 (price rate $0.002)
band 5 - 1000 and beyond (price rate $0.001)
If I was to select a value of 650, the calculator must blend band 1, band 2, band 3 and band 4 based on each band to calculate the price (differential equation?) for any given scenario through each band. Its not a difficult calculation process but I also need it to be user friendly but to also have seperate pricing band in order to to the calculation. Plus it must be easy to maintain when if the pricing bands need to change.
Trevor W.
90% (2)Projects Completed
3
Freelancers worked with
3
Projects awarded
60%
Last project
14 Jul 2021
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hello Trevor,
What is the status of your project?
Thanks -
Do you need an online calculator or we have to work on excel?
805710805108
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies