{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["NET ZERO","THE HOME","INVESTMENTS","GOVERNMENT","TOGETHER","YOU"],"not_rendered":{"charts":6,"images":8,"macros":1,"external_links":2,"defined_names":420,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"NET ZERO","index":0,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"NET ZERO VERSION",null,"The UK government wants to get the whole country to \"net zero\" by 2050."]
[null,null,null,"But how will this happen?  "]
[]
[null,null,null,"Will it be through personal choices at the household level?"]
[null,null,null,"Or are large-scale, top-down measures more likely?"]
[null,null,null,"Or could it be a bit of both? "]
[null,null,null,"This calculator applies realistic values to your choices and allows you to compare various measures."]
[]
[null,null,null,"You will find there are four kinds of things that can be done to reduce the UK emissions"]
[null,null,null,null,"changes in personal behaviour",null,null,null,null,null,"like using a bicycle for short journeys"]
[null,null,null,null,"installing green household equipment",null,null,null,null,null,"like solar panels"]
[null,null,null,null,"investing in green initiatives",null,null,null,null,null,"buying shares in low-carbon technologies like forests or wind farms"]
[null,null,null,null,"letting government and industry sort it out",null,null,null,null,null,"like offshore wind-farms"]
[]
[]
[]
[]
[]
[]
[]
["          Saving the Planet one goal at a time?"]
[]
[null,"The little red triangles hide comments.",null,"One thing before you start:  Save a new copy: Save As under your own name"]
[null,"Hover over them to find more information.",null,"Off you go!"]

{"sheet":"THE HOME","index":1,"n_rows":44,"n_cols":25,"rows_kept":44,"cut":false,"hidden":false,"merged":[[20,7,21,7],[1,3,1,8]]}
[]
["NET ZERO",null,null,"   GREEN LIFE AND LIVING"]
[]
[null,null,null,null,null,"Two sorts of actions"]
[]
[]
[null,null,"THESE  ARE FREE",null,null,null,null,"THESE  COST SOMETHING AT FIRST"]
[null,null,"AND MAY SAVE MONEY",null,null,null,null,"BUT SAVE MONEY LATER",null,null,null,null,null,null,null,null,null,null,null,"COOL",true,{"$f":"IF(COOL=TRUE,0.2,0)","v":0.2},{"$f":"IF(COOL=TRUE,-50,0)","v":-50}]
[]
[null,null,null,"Lower the thermostat 2°",null,null,null,null,"Insulate the loft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"THMIN",true,{"$f":"IF(THMIN=TRUE,0.1,0)","v":0.1},{"$f":"IF(THMIN=TRUE,-10,0)","v":-10}]
[null,null,null,"Take 3-minute showers",null,null,null,null,"Insulate the walls"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ONYER",false,{"$f":"IF(ONYER=TRUE,0.12,0)","v":0},{"$f":"IF(ONYER=TRUE,-10,0)","v":0},1.2E-2]
[null,null,null,"Use a bike for short journeys",null,null,null,null,"Install solar panels"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HOLS",false,{"$f":"IF(HOLS=TRUE,0.3,0)","v":0},{"$f":"IF(HOLS=TRUE,-200,0)","v":0},0.03]
[null,null,null,"Holiday closer to Britain",null,null,null,null,"Install a heat-pump"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOFLY",false,{"$f":"IF(NOFLY=TRUE,(AVEM/1000),0)","v":0},{"$f":"IF(NOFLY=TRUE,0,0)","v":0},0.06]
[null,null,null,"Don't fly at all",null,null,null,null,"Get an electric car"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MISTEAKS",true,{"$f":"IF(MISTEAKS=TRUE,0.9,0)","v":0.9},{"$f":"IF(MISTEAKS=TRUE,-100,0)","v":-100},0.09]
[null,null,null,"Halve meat and dairy consumption"]
[null,null,null,null,null,null,null,{"$f":"CASH","v":4000},"Annual cost over 5 years",null,null,null,null,null,null,null,null,null,null,"FRUGAL",true,{"$f":"IF(FRUGAL=TRUE,0.6,0)","v":0.6},{"$f":"IF(FRUGAL=TRUE,-500,0)","v":-500},0.06]
[null,null,null,"Buy much less stuff",null,null,"£",null,"(A negative value shows money saved)"]
[null,null,null,"Re-use, repair, recycle",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUMBEH",{"$f":"SUM(V11:V21)","v":1.6},null,null,{"$f":"SUM(W8:W21)","v":-660},"COSTBEH"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WALLSY",false,{"$f":"IF(WALLSY=TRUE,0.06,0)","v":0},{"$f":"IF(WALLSY=TRUE,4000,0)","v":0},0.06]
[null,null,null,null,null,null,"These choices saved ",{"$f":"TOTHOM","v":2.8000000000000003}," tonnes of greenhouse gas (CO2e) a year, per person",null,null,null,null,null,null,null,null,null,null,"LOFTY",true,{"$f":"IF(LOFTY=TRUE,0.2,0)","v":0.2},{"$f":"IF(LOFTY=TRUE,300,0)","v":300},0.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PHV",true,{"$f":"IF(PHV=TRUE,0.3,0)","v":0.3},{"$f":"IF(PHV=TRUE,5000,0)","v":5000},0.03]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HP",false,{"$f":"IF(HP=TRUE,0.7,0)","v":0},{"$f":"IF(HP=TRUE,10000*BROOMS/3,0)","v":0},7.0000000000000007E-2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EV",true,{"$f":"IF(EV=TRUE,0.5,0)","v":0.5},{"$f":"IF(EV=TRUE,18000,0)","v":18000},0.5]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUMONS",{"$f":"SUM(V24:V31)","v":1},null,null,{"$f":"SUM(W26:W31)","v":23300},"COSTONS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTHOM",null,{"$f":"SUM(V8:V32)","v":2.8000000000000003},{"$f":"SUM(W8:W21)+(SUM(W24:W31))/5","v":4000},null,"CASH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CASH/TOTHOM","v":1428.5714285714284},"£/t"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"YOUR CHOICES","BACKGROUND"]
[null,null,null,null,null,"GRAPHPOS",{"$f":"UKAVG-SAVED","v":7.6999999999999993},{"$f":"10.5","v":10.5},"UKAVG"]
[null,null,null,null,null,"GRAPHNEG",{"$f":"OFFTONNES+INVTONNES","v":-2.6}]

{"sheet":"INVESTMENTS","index":2,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[[15,2,16,2],[11,1,12,1],[19,2,20,2],[19,6,20,6],[19,1,20,1],[11,2,12,2],[11,6,12,6]]}
[]
[]
["NET ZERO",null,"INVESTING IN THE LOW-CARBON FUTURE"]
[]
[]
[null,null,"Long-term investments in low-carbon initiatives have a permanent effect on emissions."]
[null,null,"In the short term, they can be regarded as 'negative emissions' or 'negatonnes'."]
[null,null,"They can be bought for about £500 per negatonne of CO2e.  "]
[null,null,"Perhaps you don't do this already, but try the effect of investing up to £5000 over 5 years."]
[null,null,"(So that would be £1000 in the pink box)"]
[]
[null,"£",1300,null,null,null,{"$f":"-BUCKS/500","v":-2.6}]
[null,null,null,null,null,null,null," 'negatonnes' of CO2e per person-year"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"A curious thing about these investments is that, although they cost something at the beginning, "]
[null,null,null,"they usually generate a positive return,so you can keep investing. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"UKAVG","v":10.5},{"$f":"UKAVG","v":10.5}]
[null,null,null,"FSETS",{"$f":"INVTONNES","v":-2.6}]

{"sheet":"GOVERNMENT","index":3,"n_rows":33,"n_cols":21,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,5,32,6],[27,2,28,2],[11,2,12,2],[15,2,16,2],[19,2,20,2],[23,2,24,2]]}
[]
["NET ZERO",null,"WHAT COULD THE GOVERNMENT AND INDUSTRY DO?"]
[null,null,"They could do things that affect everybody"]
[null,null,null,null,null,null,null,null,null,null,null,null,"BIG"]
[null,null,"You can try two several things here"]
[null,null,"Look at the five classes of dcarbonisation measures and enter values you think are 'politically reasonable' right now."]
[null,null,"Then go up to the level suggested in red"]
[null,null,"This shows what the government's advisors are recommending by 2030. Try this first"]
[null,null,"But if you keep clicking you will eventually reach the the 'Greta Thunberg' levels."]
[]
[null,null,"%"]
[null,null,10,null,"    First, the government can improve  efficiency "]
[null,null,null,null,"     across the whole economy, up to 20% by 2030"]
[]
[]
[null,null,55,null,"   Then the energy supply "]
[null,null,null,null,"     can be 'decarbonised',  up to 60%"]
[]
[]
[null,null,15,null,"   But what about all the imports? "]
[null,null,null,null,"    They are slowly decarbonising, but 'carbon tariffs' could be imposed 20%"]
[]
[]
[null,null,25,null,"   Then livestock products can be reduced"]
[null,null,null,null,"    and replaced with nutritional equivalents, 25% "]
[]
[]
[null,null,15,null,"   The land released by livestock reduction can be used for carbon sequestration"]
[null,null,null,null,"    for up to 10% 0f UK land ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UKAVG-MASS","v":7.4214999999999991},{"$f":"UKAVG","v":10.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NEGT",{"$f":"-TREES*0.08","v":-1.2}]
[]
[]
[null,null,null,null,"These choices saved",{"$f":"(UKAVG*0.37*CEFF/100)+(UKAVG*0.4*ENLOW/100)+(UKAVG*0.2*IMPLOW/100)+(UKAVG*0.1*STOCKLOW/100)+(UKAVG*0.7*TREES/100)+INVTONNES/2","v":3.0785000000000009},null," tonnes per year",null,null,"and would cost about",{"$f":"28000*(CEFF*0.02/100+ENLOW*0.03/100+IMPLOW*0.01/100-STOCKLOW*0.025/100)","v":385.00000000000011},"  £ per year in extra tax"]

{"sheet":"TOGETHER","index":4,"n_rows":29,"n_cols":27,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,12,4,12]]}
[]
[null,"NET ZERO",null,null,null,"PUTTING IT ALL TOGETHER",null,null,null,null,null,null,null,null,null,null,null,{"$f":"700/67","v":10.447761194029852}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"10.5-SAVED-MASS+NEGT+INVTONNES","v":0.82149999999999812},"  Overall carbon balance"]
[null,null,null,null,null,"This is your result:",null,null,null,null,null,null,null,"  in 'personal' tonnes per year"]
[null,null,null,null,null,"Did you get to zero?",null,null,null,null,null,null,null,"The national average minus your choices so far"]
[]
[null,null,null,null,null,"You had quite a range of choices."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Personal behaviour",{"$f":"100*SUMBEH/(UKAVG-BALANCE)","v":16.531487317249571}]
[null,null,null,null,null,"Which kinds of choices had the biggest effect?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Home technology",{"$f":"100*SUMONS/(UKAVG-BALANCE)","v":10.332179573280982}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Green investment",{"$f":"100*(-INVTONNES/(UKAVG-BALANCE))","v":26.863666890530553}]
[null,null,null,null,null,"Were they realistic?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Government and industry",{"$f":"100*MASS/(UKAVG-BALANCE)","v":31.807614816345513}]
[]
[]
[null,null,null,null,null,"What would they cost every year,",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Personal behaviour",{"$f":"100*SUMBEH/(QUICK-BALANCE)","v":16.235652509546842}]
[null,null,null,null,null,"In the first five years?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Home technology",{"$f":"100*SUMONS/(QUICK-BALANCE)","v":10.147282818466778}]
[null,null,null,null,"£",{"$f":"CASH+BUCKS+TAX*INCGROUP/28000","v":5685},null,"Would that be worth it?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Green investment",{"$f":"100*(-INVTONNES/(QUICK-BALANCE))","v":26.382935328013623}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Government and industry",{"$f":"100*MASS/(QUICK-BALANCE)","v":31.23841015664998}]
[null,null,null,null,null,"If you want to go back "]
[null,null,null,null,null,"and see what else you might have done,"]
[null,null,null,null,null,"save this version ('Save As' and give it a name)"]
[null,null,null,null,null,"…and start again, many times as you like"]
[]
[null,null,null,null,null,"You might feel that your personal behaviour has made a big contribution."]
[null,null,null,null,null,"After you have completed the questions on the  'YOU' tab, a further pie-chart will give you a revised set of proportions."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UKAVG-SAVED-MASS","v":4.6214999999999984},{"$f":"UKAVG","v":10.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NEGT+FSETS","v":-3.8}]

{"sheet":"YOU","index":5,"n_rows":44,"n_cols":26,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[null,"NET ZERO",null,"YOUR OWN FOOTPRINT"]
[null,null,null,"The calculator assumes you have an average UK personal footprint of  about 10.7 tonnes of CO2e per year. But what if you don't?"]
[null,null,null,"Finding out a person's or a household's real carbon footprint can be very time-consuming."]
[null,null,null,"Fortunately we have a short-cut with just five questions! Rough answers are good enough here."]
[null,null,"NB THERE IS A RECOGNISED SPIN-BUTTON GLITCH IN EXCEL. SOMETIMES THE 'DOWN' BUTTONS GIVE AN 'UP' RESPONSE. IF YOU FIND THIS, JUST WRITE IN THE NUMBER DIRECTLY"]
[]
[null,null,null,"How many bedrooms are in the reference house?"]
[null,null,null,3]
[null,null,null,"Put in any serious room that could be a bedroom, even if it isn't. The UK average is 3. Think like an estate agent."]
[null,null,null,"If you have other houses that are not rented out or lived in permanently, add their bedrooms too",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ARE*0.0268","v":2.5728},null,null,{"$f":"V11/OCCUP","v":1.02912},{"$f":"BROOMS/OCCUP","v":1.2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(476+ARE*6.8)/1000","v":1.1288},null,null,{"$f":"V12/OCCUP","v":0.45152000000000003},{"$f":"2.4*EXP(-0.1*OCCUP)","v":1.8691218793713715}]
[null,null,null,"How many people over 12 live in your house?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V11:V12)","v":3.7016},null,null,{"$f":"V13/OCCUP","v":1.48064}]
[null,null,null,2.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FRACTOCC",7]
[null,null,null,"Give the closest  number over a typical year. Fractions allow for intermittemt occupancy, as for students. The UK average is 2.4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(2*BROOMS)^2","v":36}]
[]
[null,null,null,"How would you rate your whole household in terms of what you've got to spend, after tax and benefits?"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,"SPEND",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INCGROUP",{"$f":"IF(SPEND=1,13000,IF(SPEND=2,20000,IF(SPEND=3,28000,IF(SPEND=7,35000,IF(SPEND=6,45000,IF(SPEND=5,80000,IF(SPEND=4,150000)))))))","v":28000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AVOCC",2.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AVEM",{"$f":"FLYING*0.25*1.9","v":950}]
[null,null,null,"How much flying do you do?",null,null,"Miles per typical year",null,null,null,null,null,null,null,null,null,null,null,null,null,"EMEST",{"$f":"(INCGROUP*0.0002+4.5)*2.4/2.4*EXP(0.15*(AVOCC-OCCUP))","v":9.9496305899909334}]
[null,null,null,2000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DIET",1]
[]
[null,null,null,"How would you describe your diet? Choose the closest option",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FOOD",{"$f":"IF(DIET=1,0,IF(DIET=3,0.3,IF(DIET=4,-0.3,IF(DIET=5,-0.8,IF(DIET=2,-1)))))","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INCGROUP*0.0002+4.5)*2.4/2.4*EXP(0.15*(AVOCC-OCCUP))-(EMEST*0.12)+((ARE*0.026)+(475+ARE*6.7)/1000)/OCCUP-0.475+AVEM/1000+FOOD","v":10.67635491919202},"QUICK"]
[null,null,null,"On this basis your baseline annual footprint is likely to be ",null,null,null,null,null,{"$f":"QUICK","v":10.67635491919202}," tonnes per year"]
[]
[null,null,null,"Your choices and investments give a result of ",null,null,null,null,null,{"$f":"J36-10.8","v":-0.12364508080798053},"  tonnes per year",null,null,null,null,null,null,null,null,null,null,{"$f":"2*BROOMS^2+(6*BROOMS)+60","v":96},"ARE"]
[null,null,null,"Did you get to zero? If not, what else could you do?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Personal behaviour",{"$f":"100*SUMBEH/(QUICK-BALANCE)-(AVEM/1000)+FOOD","v":15.285652509546843}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Home technology",{"$f":"100*SUMONS/(QUICK-BALANCE)-INCGROUP/28000","v":9.1472828184667776}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Green investment",{"$f":"100*(-INVTONNES/(QUICK-BALANCE))","v":26.382935328013623}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Government and industry",{"$f":"100*MASS/(QUICK-BALANCE)","v":31.23841015664998}]