
Template spreadsheet to allow simple data input to produce graphs and pricing
- or -
Post a project like this2757
$$
- Posted:
- Proposals: 4
- Remote
- #1819141
- Awarded
Description
Experience Level: Intermediate
General information for the business: Energy efficient lighting upgrades
Description of excel work: Create a multitab template spreadsheet which will allow
1. our estimators to input the information using a pre prescribed drop down lists that they have obtained from the site inspection to ascertain current energy running costs - calculations will include wattage of fitting / hours in use / energy tariff
2. Allow our estimators to choose replacement products from pre prescribed drop down lists which will ascertain new energy running costs as above
3. Choice of replacement products to also produce quotation calculations from background tab holding pricing
4. Produce 2 x graph utilising information from items 1, 2 and 3 to show before and after running costs and return on investment
Design and target audience: The Graphs and tables will be used to demonstrate information to clients so need to be stylish, not bog standard Excel
Extra notes: I have included the extraordinarily basic template we are using at the present time. I appreciate that we will need to provide info in respect of drop down lists etc
Description of excel work: Create a multitab template spreadsheet which will allow
1. our estimators to input the information using a pre prescribed drop down lists that they have obtained from the site inspection to ascertain current energy running costs - calculations will include wattage of fitting / hours in use / energy tariff
2. Allow our estimators to choose replacement products from pre prescribed drop down lists which will ascertain new energy running costs as above
3. Choice of replacement products to also produce quotation calculations from background tab holding pricing
4. Produce 2 x graph utilising information from items 1, 2 and 3 to show before and after running costs and return on investment
Design and target audience: The Graphs and tables will be used to demonstrate information to clients so need to be stylish, not bog standard Excel
Extra notes: I have included the extraordinarily basic template we are using at the present time. I appreciate that we will need to provide info in respect of drop down lists etc

Bill S.
80% (2)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
25 Feb 2018
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