This is a wiki Anyone can contribute, therefore we don't vouch for its accuracy.

# A guide to the 2050 calculator excel spreadsheet

 ```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```