Closed

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
Employer working
Project Budget
$30 - $40 USD
Total Bids
8
Project Description

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

## Deliverables

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.

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online