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 sector worksheet

Return to the page.

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

See all changes since this wiki was released


Title: What makes a great sector worksheet

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 assumptions about a sector are ready and documented, the next step is to implement these as a worksheet.

A great sector worksheet:

# Is a single worksheet
# Follows the following structure:
## Trajectory choice
## Assumptions that vary with choice of trajectory
## Assumptions that don't vary with choice of trajectory
## Assumptions that are derived from the assumptions above
## Calculations
## Outputs (in tables)
# Minimises its interaction with other worksheets
# Contains references to any key sources / documentation

Because the sector is implemented as a single worksheet, it needs to be simple.

Previous: What makes a great one page note

Next: What makes a great excel spreadsheet

User: Tom Counsell

Picture updated at: 

Signed off by: 

Signed off at: