Modifications required in an Excel Spreadsheet
- or -
Post a project like this3419
$$
- Posted:
- Proposals: 19
- Remote
- #628098
- Awarded
VBA, Excel,Access,SQL Development,Intrgration & Automation,Database Desigh & Development,Reporting Services
Melbourne
60144352836351009050556240366139775920827010737396475
Description
Experience Level: Intermediate
I had a Excel spreadsheet created with a Dashboard and need some minor modifications.
In the Dashboard itself I would like a separate part for 'On Costs' and for the total amount to be included. Once you see the spreadsheet you will understand.
In the sheet itself I have created an extra Column and I need this to be a drop down box for each of the cells in the column. There needs to be 2 options in the drop down 1. 'PAYG' 2. 'Company'. With the PAYG and Company I need a formula associated with it, with PAYG it needs to 7.85% and Company it needs to be 6.85%
The figure displayed needs to be on the contractor rate ie 60 x 0.0785 = 4.71.
I would also like the hourly Markup column moved to be between the On Cost Column and Client Rate Column.
I have attached the spreadsheet so you can understand what I am trying to say,
Thanks
In the Dashboard itself I would like a separate part for 'On Costs' and for the total amount to be included. Once you see the spreadsheet you will understand.
In the sheet itself I have created an extra Column and I need this to be a drop down box for each of the cells in the column. There needs to be 2 options in the drop down 1. 'PAYG' 2. 'Company'. With the PAYG and Company I need a formula associated with it, with PAYG it needs to 7.85% and Company it needs to be 6.85%
The figure displayed needs to be on the contractor rate ie 60 x 0.0785 = 4.71.
I would also like the hourly Markup column moved to be between the On Cost Column and Client Rate Column.
I have attached the spreadsheet so you can understand what I am trying to say,
Thanks
Steve J.
100% (8)Projects Completed
6
Freelancers worked with
4
Projects awarded
86%
Last project
2 Apr 2015
Australia
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