The UK 2050 Calculator Web Flash Excel Wiki
Register or sign in
This is a wiki Anyone can contribute, therefore we don't vouch for its accuracy.

What makes a great excel spreadsheet

Return to the page.

Showing just the changes made in the edit by Tom Counsell at 2012-10-02 17:31:09 UTC

See all changes since this wiki was released

2012-10-02


Title: What makes a great excel spreadsheet

Content: This is part of a series of "what makes a great.." notes to help people who are interested in copying the 2050 calculator. They are ideals, which the UK calculator may not live up to.

Once the sector worksheets are developed, the next step is to combine them into a model of the whole energy and climate system.

A great excel spreadsheet:

# Is a single workbook
# Does not use any VBA or macros
# Is not linked to any other workbooks
# Has the following structure:
## Controls
## Outputs
## Individual sector worksheets
## Year worksheets that combine outputs from sector worksheetts
## Calibration data
# Uses named references to refer across worksheets (this minimises the chance of #REF! errors)

Previous: What makes a great sector worksheet

Next: What makes a great report on the implications of the analysis



User: Tom Counsell

Picture updated at: 

Signed off by: 

Signed off at: