ࡱ> JI Fɀ`\p John Kazer Ba= =hBq48X@"1Arial1Arial1Arial1Arial1Arial1Arial""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.005*0_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=,8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_- dd/mm/yy;@[$-809]dd\ mmmm\ yyyy                + ) , *   (@ @ (8@ @  `@ @ *  d@ @ *  @ @  `@ @ /  d@ @ / (x@ @ ` H Help Electricity *%Gas AWaterX Copy me...,TJ$UnitsDateNotesUnits since last readingDays since last reading Daily unitsThe orange columns on the right will calculate the units used since the previous date. If this is your first entry, nothing much will happen!Note that since I've copied the equations all the way down the columns, there will be a spurious calculation in the row below your most recent reading - ignore this.Suggested graphs:<Cumulative meter readings - Column A vs B in a scatter graph;Average daily unit usage - Column F vs B in a scatter graphXEnter your meter readings and the dates (e.g. 14/4/04) in the green columns on the left.kg CO2Daily units * 31.65 * 0.19,multiplying by 31.65 converts units into kWh0.19 is a value taken from http://www.resurgence.org/carboncalculator/ that approximates the amount of CO2 released from burning a kW of natural gas for an hour<I calculated daily CO2 emissions with the following formula:Find your annual CO2 emissions by averaging the column of daily CO2 output and multiplying by 365 (divide by 1000 to convert into tonnes) w[  Fɀ   MbP?_*+%"??U             v>@7 Fɀ +$  MbP?_*+%"??U} m} m ++@            ! DD$DDB!nha^d^ DD *( LL*(LLBE*( LL                                                            DlTmmmmmmmmmmmmmmmmmmmmmmmmmmm !"#$%&'()*  !   ! !!"!!!" ""#"""# ##$###$ $$%$$$% %%&%%%& &&'&&&' ''('''( (()((() ))*)))* *****mmmmmmmmmm  >@7 Fɀ +% :5A  MbP?_*+%"??U} m} m ++@              *) LL*)LLBnha^(*) LL/ Dfffff?@RQ? E(#*(Lfffff?@RQ? ( ( ( (  (         (         (         (         (        ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( (  ( Dlb !"#$%&'()*      ! (! !!!!!!"!(" """"""#"(# ######$#($ $$$$$$%$(% %%%%%%&%(& &&&&&&'&(' ''''''('(( (((((()(() ))))))*)(* ******(2^*( * >@7 Fɀ +fBRoX  MbP?_*+%"??U} m} m ++@            *) LL*)LLBnha^*) LL E                                                           DlTmmmmmmmmmmmmmmmmmmmmmmmmmmmm !"#$%&'()*      ! !!!!!!" """"""# ######$ $$$$$$% %%%%%%& &&&&&&' ''''''( (((((() ))))))* ******tC^mmmmmmmmmm * C^>@7 Fɀ +Yio  MbP?_*+%"??U} m} m ++@            *) LL*)LLBnha^*) LL E                                                           DlTmmmmmmmmmmmmmmmmmmmmmmmmmmmm !"#$%&'()*      ! !!!!!!" """"""# ######$ $$$$$$% %%%%%%& &&&&&&' ''''''( (((((() ))))))* ******c^mmmmmmmmmm * c^>@7 Oh+'0HPx  Home Resource Audit Spreadsheet John Kazerc John KazercMicrosoft Excel@C@ C՜.+,0 PXd lt| mA Help ElectricityGasWater Copy me...  Worksheets  !"#$%&'()*+,-./012345678:;<=>?@BCDEFGHRoot Entry FWorkbookpSummaryInformation(9DocumentSummaryInformation8A