Modifications required in an Excel Spreadsheet
- or -
Post a project like this3409
$$
- Posted:
- Proposals: 19
- Remote
- #628098
- Awarded
VBA, Excel,Access,SQL Development,Intrgration & Automation,Database Desigh & Development,Reporting Services
Melbourne
73988960144381891881686380712380268477909266498464864663772395745
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