Excel Spreadsheet customizations
This project received 8 bids from talented freelancers with an average bid price of $31 USD.Get free quotes for a project like this
Project Budget$30 - $40 USD
I need some custom work done to an MS Excel worksheet.
It will need:
- drop down lists embedded into a field
- choices in the drop down will affect another column
- some formulas
- it will function as a calculator
- it will need some formatting for appearance
I have attached a sheet I put together.
I need to add a drop down menu that will allow me specify other cities.
When the person selects a different city a new data column would be added into column "C" hours of operation which would change the other columns numbers. (I have all the data sorted that would be changed in hours of operation)
I would also like a drop down that would allow for column "D" to be changed. Column D is based on a number of BTUs for the size of the building. In the attached example I use 60,000 and divided it by the number of rows in column "C" which gives me the btus required to heat the building at different temperatures.
Once these details are worked out, I would like to make the calculator have an attractive look with hidden columns, colored cells, etc.
Browse Related Skills
Other things people do on Freelancer
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online