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.

Bug spotter

Return to the page.

Showing just the changes made in the edit by Asdc at 2012-05-29 16:18:24 UTC

See all changes since this wiki was released

2015-02-17

2014-09-26

2014-08-28

2014-08-18

2014-07-28

2014-07-24

2014-07-22

2014-06-02

2014-03-10

2013-01-31

2013-01-20

2013-01-11

2013-01-04

2012-12-31

2012-12-19

2012-11-13

2012-10-14

2012-09-28

2012-09-04

2012-06-26

2012-06-25

2012-06-21

2012-06-19

2012-06-11

2012-05-29

2012-05-14

2012-05-03

2012-04-24

2012-04-17

2012-04-03

2012-03-01

2012-02-15

2012-02-06

2012-01-26

Title: Bug spotter

Content: This is a space to list possible bugs in the excel model or web front end. Please assign the bug a number, incrementing one from the last one on the page.

h1 Outstanding bugs

h1 Web front end

(see also issues filed at https://github.com/decc/twenty-fifty/issues )

* Bug 1: IE8 cost sensitivity page very slow to load
* Bug 2: IE8 cost sensitivity page 'reset' link hard to press

h1 Excel model

* Bug 4: Is the cooling demand in IX.a correct? D12/192752
* Bug 5: The model assumes 77 million bikes in 2050, which seems too high, and the costs are not on the wiki
* Bug 6: labelling in E107 on year sheets is misleading - electricity imports are not related to hydrocarbons. Similarly, sorting out imports (brackets)ambiguity would be useful.
* Bug 7: error in waste volumes. D12/383050
* Bug 10: Transpot double counted in the energy demand chart on the control sheet
* Bug 11: Total emissions change when the unit of energy is changed in the preferences sheet. It shouldn't.
* Bug 18: typos - "ammortised" should be "amortised" throughout the spreadsheet
* Bug 19: incorrect label: Sheet I.a cell C245 - values are not "coal", they are "solid fuel input required" (they include biomass as well as coal)
* Bug 20: Sheet I.a cells H196-O196 allow total coal capacity to go negative. Changing them to *max(current formula,0)* fixes this
* Bug 21: there's an inconsistency across the years, in Sheet I.a G241-O241. And the formula, as it stands, means that when the user specifies more biomass plant in some scenarios, this drives up coal use.  This can be fixed, by replacing the formula with a straightforward *min(required,available)*

h1 Assumptions

* Bug 8: 2050 working assumption Biomass forestry arisings collection 2050 high end looks absurd.
* Bug 9: The operating cost of conventional vehicles looks high unless it includes tax and insurance. It should not include tax and insurance.

h1 Costs to delete

h2 Bioenergy costs (comments from richard.taylor@e4tech.com)

* Delete cost_source/84 (and therefore remove costs/793, /794, /795 and /796). These macro-algae costs needed correcting (as the source had them in biomethane form, not seaweed), plus these costs have been replaced by the more up-to-date TINA bioenergy analysis (http://2050-wiki.greenonblack.com/cost_sources/46)
* Delete energy crop costs/843 and /844, as these have been replaced by the more up-to-date TINA bioenergy analysis (cost_sources/46)
* I think the costs extracted from cost_source/90 (Jablonski et al. 2010) might need to be double-checked. All of the capital costs in the wiki are given as £/GJ (and hence converted straight into £/MWh using x3.6), however, all the investment costs in the original source itself are given as £/(GJ/year). Alternatively, the y-axis units could be changed £/(MWh/yr)?

h1 Fixed bugs

* Bug 3: Cost VI.a.Bioenergy is not included in the total cost presented by the webtool.
* Bug 12: There is a missing GW unit in sheet I.a, cell F92.  
* Bug 13: XVI.b wrong price year - row 37
* Bug 14: I.a - missing GW unit in cell F92
* Bug 15: VI.b Unit error: should have MGBP rather than GBP in cell G233
* Bug 16: IX.a small error in cells referenced by cooling costs on rows 461-463 of sheet 
* Bug 17: XII.a. cell E365 referencing wrong cell & throwing off costs



User: Asdc

Picture updated at: 

Signed off by: 

Signed off at:
Title: Bug spotter

Content: This is a space to list possible bugs in the excel model or web front end. Please assign the bug a number, incrementing one from the last one on the page.

h1 Outstanding bugs

h1 Web front end

(see also issues filed at https://github.com/decc/twenty-fifty/issues )

* Bug 1: IE8 cost sensitivity page very slow to load
* Bug 2: IE8 cost sensitivity page 'reset' link hard to press

(see also bug filed at http://2050-calculator-tool-wiki.decc.gov.uk/pages/143 by I G Crossland

h1 Excel model

* Bug 4: Is the cooling demand in IX.a correct? D12/192752
* Bug 5: The model assumes 77 million bikes in 2050, which seems too high, and the costs are not on the wiki
* Bug 6: labelling in E107 on year sheets is misleading - electricity imports are not related to hydrocarbons. Similarly, sorting out imports (brackets)ambiguity would be useful.
* Bug 7: error in waste volumes. D12/383050
* Bug 10: Transpot double counted in the energy demand chart on the control sheet
* Bug 11: Total emissions change when the unit of energy is changed in the preferences sheet. It shouldn't.
* Bug 18: typos - "ammortised" should be "amortised" throughout the spreadsheet
* Bug 19: incorrect label: Sheet I.a cell C245 - values are not "coal", they are "solid fuel input required" (they include biomass as well as coal)
* Bug 20: Sheet I.a cells H196-O196 allow total coal capacity to go negative. Changing them to *max(current formula,0)* fixes this
* Bug 21: there's an inconsistency across the years, in Sheet I.a G241-O241. And the formula, as it stands, means that when the user specifies more biomass plant in some scenarios, this drives up coal use.  This can be fixed, by replacing the formula with a straightforward *min(required,available)*

h1 Assumptions

* Bug 8: 2050 working assumption Biomass forestry arisings collection 2050 high end looks absurd.
* Bug 9: The operating cost of conventional vehicles looks high unless it includes tax and insurance. It should not include tax and insurance.

h1 Costs to delete

h2 Bioenergy costs (comments from richard.taylor@e4tech.com)

* Delete cost_source/84 (and therefore remove costs/793, /794, /795 and /796). These macro-algae costs needed correcting (as the source had them in biomethane form, not seaweed), plus these costs have been replaced by the more up-to-date TINA bioenergy analysis (http://2050-wiki.greenonblack.com/cost_sources/46)
* Delete energy crop costs/843 and /844, as these have been replaced by the more up-to-date TINA bioenergy analysis (cost_sources/46)
* I think the costs extracted from cost_source/90 (Jablonski et al. 2010) might need to be double-checked. All of the capital costs in the wiki are given as £/GJ (and hence converted straight into £/MWh using x3.6), however, all the investment costs in the original source itself are given as £/(GJ/year). Alternatively, the y-axis units could be changed £/(MWh/yr)?

h1 Fixed bugs

* Bug 3: Cost VI.a.Bioenergy is not included in the total cost presented by the webtool.
* Bug 12: There is a missing GW unit in sheet I.a, cell F92.  
* Bug 13: XVI.b wrong price year - row 37
* Bug 14: I.a - missing GW unit in cell F92
* Bug 15: VI.b Unit error: should have MGBP rather than GBP in cell G233
* Bug 16: IX.a small error in cells referenced by cooling costs on rows 461-463 of sheet 
* Bug 17: XII.a. cell E365 referencing wrong cell & throwing off costs



User: Asdc

Picture updated at: 

Signed off by: 

Signed off at: