Excel spreadsheet that makes multi-stage calculations
- or -
Post a project like this2029
£50(approx. $62)
- Posted:
- Proposals: 16
- Remote
- #2124169
- Awarded
Excel and VBA expert. Professional OCR. PDF to Excel Conversion. Data management, Translations English Russian
Hua Hin
Spreadsheets|Excel macros and VBA|Google sheets |Google app scripts|Presentations - Tableau, PowerPoint, Prezi|Google data studio
Bay Minette
Chartered Certified Accountant (ACCA) / IFRS and reporting specialist / Excel expert / Xero Advisor / Book keeper
Yanbu` al Bahr
48649519011469457672137611046301224690137182714494731642492195784821385062223564
Description
Experience Level: Intermediate
I'm looking for an Excel spreadsheet that will do the following:
- Allow weekly revenue figures for three businesses to be added in endless columns which automatically shows the weekly date Mon-Fri date range (i.e. 20th to 26th August).
- Take each weekly figure for each business and work out a percentage within ranges (for example, 5% of £2000-£5000, and then 6% of £5001+) and enter this into a separate column (commission). It should also be possible to adjust these percentages and ranges.
- Calculate the total commission of a given period minus a fixed weekly amount (which should also be adjustable).
- Calculate total weekly revenue.
They're very simple calculations, but I'd like it set up in an easily accessible manner that does it automatically when the weekly revenue figures are entered. More information will be provided upon the start of the project.
- Allow weekly revenue figures for three businesses to be added in endless columns which automatically shows the weekly date Mon-Fri date range (i.e. 20th to 26th August).
- Take each weekly figure for each business and work out a percentage within ranges (for example, 5% of £2000-£5000, and then 6% of £5001+) and enter this into a separate column (commission). It should also be possible to adjust these percentages and ranges.
- Calculate the total commission of a given period minus a fixed weekly amount (which should also be adjustable).
- Calculate total weekly revenue.
They're very simple calculations, but I'd like it set up in an easily accessible manner that does it automatically when the weekly revenue figures are entered. More information will be provided upon the start of the project.
SC Marketing Media Ltd
100% (12)Projects Completed
14
Freelancers worked with
8
Projects awarded
71%
Last project
11 Aug 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
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