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.

A guide to the 2050 calculator excel spreadsheet

Return to the uploaded file.

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

See all changes since this wiki was released

2012-10-02

Attached file: 2050_Calculator_excel_how_to_guide.docx

Title: A guide to the 2050 calculator excel spreadsheet

Content: Contents

| Introduction                                                                                                                                                 | 3  |
| How do I make a pathway in the spreadsheet?                                                                                                                  | 4  |
| How the Calculator works                                                                                                                                     | 5  |
| Frequently Asked Questions                                                                                                                                   | 12 |
| Emissions questions                                                                                                                                          | 12 |
| Why are some emissions negative?                                                                                                                             | 12 |
| Energy supply and demand questions                                                                                                                           | 13 |
| How is biomass allocated across the sectors?                                                                                                                 | 13 |
| How does the Calculator ensure there is sufficient energy supply to meet demand?                                                                             | 15 |
| How do you change the trajectory definitions (e.g. how can I redefine level 4)?                                                                              | 15 |
| Cost questions                                                                                                                                               | 16 |
| What discount rate do you use and how do you change it?                                                                                                      | 16 |
| What finance cost assumptions do you use and how can you change them?                                                                                        | 16 |
| Where can you get total costs and cost/person/year? How can you graph these over time?                                                                       | 17 |
| Assumption and data questions                                                                                                                                | 17 |
| How do you change the units?                                                                                                                                 | 17 |
| What population figures have you used and how do you change them?                                                                                            | 17 |
| What GDP growth rate assumptions have you used and how do you change them?                                                                                   | 17 |
| Why are there three 2007 worksheets?                                                                                                                         | 17 |
| Excel specific questions                                                                                                                                     | 18 |
| Why can’t I open the spreadsheet in Excel ’97?                                                                                                               | 18 |
| What do ‘Index and Match’ formulae do?                                                                                                                       | 18 |
| What is a ‘Structured Table Reference’?                                                                                                                      | 18 |
| Webtool questions                                                                                                                                            | 19 |
| How do you paste a pathway between Excel and the web tool?                                                                                                   | 19 |
| Where can I see key information about my pathway, such as total electricity generation and electricity capacities, and energy demand for heat and transport? | 19 |



User: Tom Counsell

Signed off at: 

Attachment file name: 2050_Calculator_excel_how_to_guide.docx

Attachment: http://s3-eu-west-1.amazonaws.com/2050-uk-wiki/versions/attachments/000/010/190/original/2050_Calculator_excel_how_to_guide.docx?1349184015