Cancelled

Excel Spreadsheet customizations

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.

Skills: Engineering, Excel, Microsoft Access, Microsoft Exchange, MySQL, PHP, Powerpoint, Project Management, Software Architecture, Software Testing, Word

See more: custom formulas in excel, work on ms excel, excel function, Excel Formulas, Excel Formatting, excel calculator, operation project management, excel sheet formatting, spreadsheet columns, work hours spreadsheet, excel custom number, excel custom number formatting, excel number custom, excel management, spreadsheet menu, excel spreadsheet hours worked, custom number formatting, drop menu excel, excel drop, excel attractive, attractive excel, embedded based project, sheet attractive, operation management project, project excel spreadsheet

About the Employer:
( 75 reviews ) Toronto, Canada

Project ID: #2877965

8 freelancers are bidding on average $31 for this job

sonarkaushik

See private message.

$32.3 USD in 8 days
(75 Reviews)
6.1
LogixSmith

See private message.

$29.75 USD in 8 days
(54 Reviews)
6.0
DenisSmolentsev

See private message.

$34 USD in 8 days
(83 Reviews)
5.2
azrajobs

See private message.

$34 USD in 8 days
(44 Reviews)
4.9
blueflare

See private message.

$29.75 USD in 8 days
(11 Reviews)
4.2
Futzure

See private message.

$25.5 USD in 8 days
(6 Reviews)
2.2
vw7334009vw

See private message.

$25.5 USD in 8 days
(0 Reviews)
0.0
aph003lx

See private message.

$34 USD in 8 days
(0 Reviews)
0.0