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 Sophie Hartfield at 2012-06-26 15:19:12 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
* from Friends of the Earth: one of our local campaigners recently pointed out to me that there was a discrepancy between values shown when a cursor hovered over a level and the information in the information sheet associated with it. DECC off-shore level 4 = 929 TWhr - http://2050-calculator-tool.decc.gov.uk/assets/onepage/4.pdf but hovering over level 4 says 430 TWhrs
* From NAO: when they viewed the web tool (at http://2050-calculator-tool.decc.gov.uk) the "costs in context" page was showing the MARKAL pathway at £4,656/person/year when it should have shown £4,671.  The £4,656 was the old figure, prior to update in May.  NAO clicked on "refresh" and this did not fix it.  They then clicked on "costs sensivitity page" and "set to default" and this corrected it - even though none of the costs beforehand were set outside the default.

h1 Excel model

* Bug 4: The model assumes 77 million bikes in 2050, which seems too high, and the costs are not on the wiki.  (This is a *priority* bug to fix as it could have quite a big impact on costs.)
* Insulation costs: are these correct?  See: D12/850429
* Bug 5: Is the cooling demand in IX.a correct? D12/192752
* 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: Transport 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)*
* Bug 22: I think fuel cells vs batteries should probably be a category scale (A-D), not ascending order of difficulty (1-4). This can be fixed by changing cell F32 on the "Control" sheet from 4 to D.
* Bug 23: On the Control sheet, cells BO11-BO13 ("None in 2050") are not at all helpful, as they're dropped straight into the "story" tab of the web front end, and it's not possible to tell in the story tab, what there's "none" of. I suggest changing them to "No wave power","No power from tidal stream","No tidal range schemes" respectively.
* Bug 24: In the spreadsheet, wiki links are to http://2050-wiki.greenonblack.com/pages/{number} rather than to http://2050-calculator-tool-wiki.decc.gov.uk/pages/{number}
* Bug 25: We should really calculate the 'story' statements dynamically in the excel

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
* bug filed at http://2050-calculator-tool-wiki.decc.gov.uk/pages/143 by I G Crossland



User: Sophie Hartfield

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
* from Friends of the Earth: one of our local campaigners recently pointed out to me that there was a discrepancy between values shown when a cursor hovered over a level and the information in the information sheet associated with it. DECC off-shore level 4 = 929 TWhr - http://2050-calculator-tool.decc.gov.uk/assets/onepage/4.pdf but hovering over level 4 says 430 TWhrs
* From NAO: when they viewed the web tool (at http://2050-calculator-tool.decc.gov.uk) the "costs in context" page was showing the MARKAL pathway at £4,656/person/year when it should have shown £4,671.  The £4,656 was the old figure, prior to update in May.  NAO clicked on "refresh" and this did not fix it.  They then clicked on "costs sensivitity page" and "set to default" and this corrected it - even though none of the costs beforehand were set outside the default.

h1 Excel model

* Bug 4: The model assumes 77 million bikes in 2050, which seems too high, and the costs are not on the wiki.  (This is a *priority* bug to fix as it could have quite a big impact on costs.)
* Insulation costs: are these correct?  Another *priority* bug to look at. See: D12/850429
* Bug 5: Is the cooling demand in IX.a correct? D12/192752
* 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: Transport 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)*
* Bug 22: I think fuel cells vs batteries should probably be a category scale (A-D), not ascending order of difficulty (1-4). This can be fixed by changing cell F32 on the "Control" sheet from 4 to D.
* Bug 23: On the Control sheet, cells BO11-BO13 ("None in 2050") are not at all helpful, as they're dropped straight into the "story" tab of the web front end, and it's not possible to tell in the story tab, what there's "none" of. I suggest changing them to "No wave power","No power from tidal stream","No tidal range schemes" respectively.
* Bug 24: In the spreadsheet, wiki links are to http://2050-wiki.greenonblack.com/pages/{number} rather than to http://2050-calculator-tool-wiki.decc.gov.uk/pages/{number}
* Bug 25: We should really calculate the 'story' statements dynamically in the excel

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
* bug filed at http://2050-calculator-tool-wiki.decc.gov.uk/pages/143 by I G Crossland



User: Sophie Hartfield

Picture updated at: 

Signed off by: 

Signed off at: