{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["BinResultsYear","Elec.","GHELoads"],"not_rendered":{"charts":10,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"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":"BinResultsYear","index":0,"n_rows":59,"n_cols":70,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[null,null,1,{"$f":"C1+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,{"$f":"BO1+1","v":66},67,68]
[" Year","Count","ODA Temperature (°C)","EL 007 (kW)","GHE EFT (°C)","GHE ExFT (°C)","Clg Provided (kW)","Bldg Htg Provided (kW)","EL 003 (kW)","CP Energy (kW)","DHW Provided by HP (kW)","DHW by LPS (kW)","Useful Bldg Htg by LPS (kW)","Bldg Htg Uncertainty (kW)","Bldg Clg Uncertainty (kW)","DHW Htg by HP Uncertainty (kW)","Bldg + DHW Htg by HP Uncertainty (kW)","EL007+EL011 Uncertainty (kW)","EL011 Uncertainty (kW)","LPS DHW Uncertainty (kW)","CP Power for Heat Extraction from GHE (kW)","CP Power for Heat Rejection to GHE (kW)","Heat Extraction by GHE (kW)","Heat Rejection to GHE (kW)","EL007 Uncertainty (kW)","LPS Electricity going to bldg heat (kW)","Alt Calc GHE Heat Extraction (kW)","Alt Calc GHE Heat Extraction (kW)","HtgFrac","COP H4","COP H3","COP H2","COP C3","COP C2","Overall (H+C) COP","Not used","Not used","Not used","Not used","Error COP H4","Error COP H3","Error COP H2","Error COP H3b","Error COP C2","BPF0, heating","BPF0, cooling","BPF1*, heating","BPF2, heating","BPF3+, heating","BPF4+, heating","BPF2, cooling","BPF3, cooling","BPF4, cooling","Error BPF0, heating","Error BPF0, cooling","Error BPF1*, heating","Error BPF2, heating","Error BPF3+, heating","Error BPF4+, heating","Error BPF2, cooling","Error BPF3, cooling","Error BPF4, cooling","Htg & Clg Provided Boundary 2","Htg & Clg Provided Boundary 4+","Electricity Used Boundary 2","Electricity Used Boundary 4+","BPFHC2","BPFHC4+","Error BPFHC2","Error BPFHC4+"]
[2016,8783,7.9513269756916261,9.4886189229193132,9.4953831264943513,9.9972788341114018,12.690520873003099,22.908402595923945,12.928338836388486,1.0139643872115875,1.792720586070758,0.19695205067871255,1.6853951288473956,1.1571248981025433,0.69797864801517107,0.13896919284425277,1.2201110305706977,0.14006403970130019,0.19000000000003717,5.6570169674397167E-2,0.53605195424808127,0.47791243296350905,17.214639236336915,1.1503462591246556,9.4886189229192217E-2,2.7906165635633897,13.951865617922863,9.4562780048199553,0.66060543221001067,1.4744716569869945,2.6168827114162534,3.4446428892917718,2.8922233960757708,36.876683763840255,3.7394600999393939,0,0,0,0,6.8636947530386433E-2,0.12541052496374111,0.20262921581309079,0.12553410326583064,7.2015833338995572,32.113751474861886,2.4070230857804242,3.7995588419036119,3.4446428892917718,2.6168827114162534,1.4744716569869945,36.876683763840255,36.876683763840255,2.8922233960757708,0,0,0.23033759763036665,0.20262921581309079,0.12541052496374111,6.8636947530386433E-2,7.2015833338995572,7.2015833338995572,0.16465324115927443,37.391644054997805,39.273991234523912,7.5150146958887989,22.416957759307799,4.975591608018207,1.7519768586001312,0.18998604299682995,0.27766942603194766]
[2017,8760,7.7740964855493129,9.3784216956847466,9.4211658578545716,9.9181733602109734,13.026244975964339,22.622765851436412,13.353428495290331,1.0147284653223916,1.9176843358466555,0.2105706454751021,1.8601777502998968,1.1546488091218405,0.71644347367803562,0.14861076436397264,1.216114484904161,0.13605478824401837,0.19000000000003714,6.0481813222681959E-2,0.58264795233409095,0.43208051298831313,16.931928040758422,1.0847778370326842,9.3784216956849492E-2,2.7775484931072638,11.633916056569058,7.5247418676753011,0.65325017493930915,1.4701059756987886,2.650176420368179,3.479348421487626,2.8132621653305696,37.021426368789221,3.8138045679098869,0,0,0,0,6.8085491530808631E-2,0.12632255251818805,0.20631752265086237,0.12646607263424769,7.2248378340596267,29.060306438783527,2.5105919022597187,3.8402642078359888,3.479348421487626,2.650176420368179,1.4701059756987886,37.021426368789221,37.021426368789221,2.8132621653305696,0,0,0.23486102067336592,0.20631752265086237,0.12632255251818805,6.8085491530808631E-2,7.2248378340596267,7.2248378340596267,0.15982329782772875,37.56669516324741,39.637443559022408,7.4050310224247724,22.731850190975077,5.0731313683202126,1.7436963215057231,0.19431275713434554,0.29890557098604104]
[2018,8760,10.006805658083657,10.009246573118812,9.6114056978504134,10.161161128246736,18.379459671825291,24.468907240876064,13.780393636522271,0.98526202089425607,2.168934955348651,0.23796025388890185,1.7440987808063615,1.2384544057492888,1.0108702819503879,0.16799370531365754,1.3113241705757004,0.13931600337431824,0.19000000000003714,6.8348879292544615E-2,0.54243209551918581,0.44282992537507221,18.130717486881011,1.0874571306837844,0.10009246573118857,2.7384558673579935,12.947401288406818,12.707111236773487,0.59172453902952171,1.5756869561609852,2.701966102769731,3.4976919943474534,3.2667645827431482,45.690690307123411,4.2748032348019835,0,0,0,0,7.3200388894936422E-2,0.12880012196214297,0.20313382536186925,0.12896165739734183,9.1624447818749015,33.424861170000085,2.4556992840145564,3.787641743749782,3.4976919943474534,2.701966102769731,1.5756869561609852,45.690690307123411,45.690690307123411,3.2667645827431482,0,0,0.22500985128987522,0.20313382536186925,0.12880012196214297,7.3200388894936422E-2,9.1624447818749015,9.1624447818749015,0.18523162448670019,45.017301868050005,46.999360902745266,8.0180924727661722,23.789640209641085,5.6144652884652286,1.975623022818904,0.21031463194880795,0.28758406938242786]
[2019,8760,11.02910026542065,9.7269165154687141,9.4498344673406045,9.9825317664156081,14.163031893510425,24.197868732971607,13.432617176338681,1.0156410531289561,2.1783144753920034,0.23631860413495756,1.8815938943235746,1.2322097192681307,0.77896675414307026,0.1676227271384555,1.3013115946676117,0.1416350488515192,0.19000000000003714,6.7877351299784172E-2,0.60307106365145591,0.41256998947750473,18.097301182385191,0.99116066279661807,9.7269165154687323E-2,2.6984129326697639,12.777449839615464,8.3721245565552742,0.65063379106085106,1.5430045399771819,2.7430539876089841,3.5390043744922095,3.0179684695610285,39.914903968269151,3.970853991513775,0,0,0,0,7.145511202385961E-2,0.13073793025917155,0.20678529566269785,0.13090112499849357,7.7830653330358182,30.008571581614635,2.40240610823842,3.8833134390800623,3.5390043744922095,2.7430539876089841,1.5430045399771819,39.914903968269151,39.914903968269151,3.0179684695610285,0,0,0.23319606256396802,0.20678529566269785,0.13073793025917155,7.145511202385961E-2,7.7830653330358182,7.7830653330358182,0.17138957170713606,40.539215101874035,42.657127600332565,7.8078260317929491,23.159533691807397,5.1921258154063681,1.8418819725814417,0.19727157982858476,0.29421402971036203]
[2020,8784,10.070107300065867,8.5955454860153839,9.5541997914073225,9.8899323252687541,10.669081344789978,22.079872056618051,11.168309920451012,0.99531680184780436,0.81424187745870358,8.6403909886662744E-2,2.1398782724270857,1.1323854869063463,0.58679947396344534,6.18701592991448E-2,1.1463722216953169,0.13879359861372517,0.19000000000003717,2.4817633662488035E-2,0.59575112038813749,0.39956568145967136,15.891015823112577,1.043229759857031,8.5955454860153421E-2,2.8761180031021123,12.163696193918275,6.5670039795058788,0.68211961774962981,1.549334481754661,2.7085531016513662,3.6271071043984855,3.0052170398143239,33.721117956169039,3.7316224951400332,0,0,0,0,7.1937226312606156E-2,0.13008159649068818,0.22102641616696175,0.13010911663391417,6.6990136563268727,26.673916807339666,2.6109093154496188,4.0642673756424212,3.6271071043984855,2.7085531016513662,1.549334481754661,33.721117956169039,33.721117956169039,3.0052170398143239,0,0,0.25769304880149041,0.22102641616696175,0.13008159649068818,7.1937226312606156E-2,6.6990136563268727,6.6990136563268727,0.17301341432865658,33.563195278866729,35.789477461180475,6.628340374874413,19.763855406466398,5.063589583614684,1.8108550545998614,0.20307343100938172,0.354614665883345]
[2021,3144,3.0921067407599558,15.434366277104047,7.2448469448230579,8.2935109006115351,7.6757749891623357,47.667065231491037,11.126519915217921,1.0090543006128398,0.62503117518437523,6.3710330081990382E-2,2.9122862156211515,2.4122849358677936,0.42216762440392924,4.6410693547559508E-2,2.415287774617251,0.22193456622395474,0.190000000000006,1.8299399119380506E-2,0.94257581928526468,6.6478481327574973E-2,33.624125976511777,0.21169149055201256,0.15434366277104042,2.9362835467853312,27.957118930232365,0.78422421356897709,0.86285390532588357,2.0478626542075462,3.1443109516803509,3.6296095766532805,5.0301326760121627,55.4656685590123,3.5846475897732617,0,0,0,0,9.8169937847363969E-2,0.15419025021923663,0.19424267704113315,0.15419433470746213,10.880330237801719,35.672595549934904,3.1843611094076527,3.8837582511004758,3.6296095766532805,3.1443109516803509,2.0478626542075462,55.4656685590123,55.4656685590123,5.0301326760121627,0,0,0.20973602976358335,0.19424267704113315,0.15419025021923663,9.8169937847363969E-2,10.880330237801719,10.880330237801719,0.28968501589461454,55.967871395837747,58.943867941540887,13.443426700849566,26.560886192321966,4.1632146803984744,2.2191980913114246,0.18482607360567382,0.2704614635993674]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(AU3:AU7)","v":3.8750091216423734},{"$f":"AVERAGE(AV3:AV7)","v":3.5175589568035095},2.6841264647629028,1.5225207221157222,38.644964472838218,38.644964472838218,2.999087130704968,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BK3:BK7)","v":194.07805146703595},{"$f":"SUM(BL3:BL7)","v":204.35740075780461},37.374304597747106,111.86183725819774,{"$f":"AVERAGE(BO3:BO7)","v":5.1837807327649399},1.8248066460212122,"Raw average"]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BK10/BM10","v":5.1928204031048333},{"$f":"BL10/BN10","v":1.8268732730190196}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,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,{"$f":"CELL(\"filename\")","v":"D:\\Dropbox\\Gehlin-Spitler_collaboration\\Studenthuset\\studenthuset data detailed excel files\\2021_update\\20211208_Results\\[BinResultsYear_V3.xlsm]BinResultsYear"}]

{"sheet":"Elec.","index":1,"n_rows":30,"n_cols":70,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,1,{"$f":"C2+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,{"$f":"BO2+1","v":66},67,68]
[" Year","Count","ODA Temperature (°C)","EL 007 (kW)","GHE EFT (°C)","GHE ExFT (°C)","Clg Provided (kW)","Bldg Htg Provided (kW)","EL 003 (kW)","CP Energy (kW)","DHW Provided by HP (kW)","DHW by LPS (kW)","Useful Bldg Htg by LPS (kW)","Bldg Htg Uncertainty (kW)","Bldg Clg Uncertainty (kW)","DHW Htg by HP Uncertainty (kW)","Bldg + DHW Htg by HP Uncertainty (kW)","EL007+EL011 Uncertainty (kW)","EL011 Uncertainty (kW)","LPS DHW Uncertainty (kW)","CP Power for Heat Extraction from GHE (kW)","CP Power for Heat Rejection to GHE (kW)","Heat Extraction by GHE (kW)","Heat Rejection to GHE (kW)","EL007 Uncertainty (kW)","LPS Electricity going to bldg heat (kW)","Alt Calc GHE Heat Extraction (kW)","Alt Calc GHE Heat Extraction (kW)","HtgFrac","COP H4","COP H3","COP H2","COP C3","COP C2","Overall (H+C) COP","Not used","Not used","Not used","Not used","Error COP H4","Error COP H3","Error COP H2","Error COP H3b","Error COP C2","BPF0, heating","BPF0, cooling","BPF1*, heating","BPF2, heating","BPF3+, heating","BPF4+, heating","BPF2, cooling","BPF3, cooling","BPF4, cooling","Error BPF0, heating","Error BPF0, cooling","Error BPF1*, heating","Error BPF2, heating","Error BPF3+, heating","Error BPF4+, heating","Error BPF2, cooling","Error BPF3, cooling","Error BPF4, cooling","Htg & Clg Provided Boundary 2","Htg & Clg Provided Boundary 4+","Electricity Used Boundary 2","Electricity Used Boundary 4+","BPFHC2","BPFHC4+","Error BPFHC2","Error BPFHC4+"]
[2016,8783,7.9513269756916261,9.4886189229193132,9.4953831264943513,9.9972788341114018,12.690520873003099,22.908402595923945,12.928338836388486,1.0139643872115875,1.792720586070758,0.19695205067871255,1.6853951288473956,1.1571248981025433,0.69797864801517107,0.13896919284425277,1.2201110305706977,0.14006403970130019,0.19000000000003717,5.6570169674397167E-2,0.53605195424808127,0.47791243296350905,17.214639236336915,1.1503462591246556,9.4886189229192217E-2,2.7906165635633897,13.951865617922863,9.4562780048199553,0.66060543221001067,1.4744716569869945,2.6168827114162534,3.4446428892917718,2.8922233960757708,36.876683763840255,3.7394600999393939,0,0,0,0,6.8636947530386433E-2,0.12541052496374111,0.20262921581309079,0.12553410326583064,7.2015833338995572,32.113751474861886,2.4070230857804242,3.7995588419036119,3.4446428892917718,2.6168827114162534,1.4744716569869945,36.876683763840255,36.876683763840255,2.8922233960757708,0,0,0.23033759763036665,0.20262921581309079,0.12541052496374111,6.8636947530386433E-2,7.2015833338995572,7.2015833338995572,0.16465324115927443,37.391644054997805,39.273991234523912,7.5150146958887989,22.416957759307799,4.975591608018207,1.7519768586001312,0.18998604299682995,0.27766942603194766]
[2017,8760,7.7740964855493129,9.3784216956847466,9.4211658578545716,9.9181733602109734,13.026244975964339,22.622765851436412,13.353428495290331,1.0147284653223916,1.9176843358466555,0.2105706454751021,1.8601777502998968,1.1546488091218405,0.71644347367803562,0.14861076436397264,1.216114484904161,0.13605478824401837,0.19000000000003714,6.0481813222681959E-2,0.58264795233409095,0.43208051298831313,16.931928040758422,1.0847778370326842,9.3784216956849492E-2,2.7775484931072638,11.633916056569058,7.5247418676753011,0.65325017493930915,1.4701059756987886,2.650176420368179,3.479348421487626,2.8132621653305696,37.021426368789221,3.8138045679098869,0,0,0,0,6.8085491530808631E-2,0.12632255251818805,0.20631752265086237,0.12646607263424769,7.2248378340596267,29.060306438783527,2.5105919022597187,3.8402642078359888,3.479348421487626,2.650176420368179,1.4701059756987886,37.021426368789221,37.021426368789221,2.8132621653305696,0,0,0.23486102067336592,0.20631752265086237,0.12632255251818805,6.8085491530808631E-2,7.2248378340596267,7.2248378340596267,0.15982329782772875,37.56669516324741,39.637443559022408,7.4050310224247724,22.731850190975077,5.0731313683202126,1.7436963215057231,0.19431275713434554,0.29890557098604104]
[2018,8760,10.006805658083657,10.009246573118812,9.6114056978504134,10.161161128246736,18.379459671825291,24.468907240876064,13.780393636522271,0.98526202089425607,2.168934955348651,0.23796025388890185,1.7440987808063615,1.2384544057492888,1.0108702819503879,0.16799370531365754,1.3113241705757004,0.13931600337431824,0.19000000000003714,6.8348879292544615E-2,0.54243209551918581,0.44282992537507221,18.130717486881011,1.0874571306837844,0.10009246573118857,2.7384558673579935,12.947401288406818,12.707111236773487,0.59172453902952171,1.5756869561609852,2.701966102769731,3.4976919943474534,3.2667645827431482,45.690690307123411,4.2748032348019835,0,0,0,0,7.3200388894936422E-2,0.12880012196214297,0.20313382536186925,0.12896165739734183,9.1624447818749015,33.424861170000085,2.4556992840145564,3.787641743749782,3.4976919943474534,2.701966102769731,1.5756869561609852,45.690690307123411,45.690690307123411,3.2667645827431482,0,0,0.22500985128987522,0.20313382536186925,0.12880012196214297,7.3200388894936422E-2,9.1624447818749015,9.1624447818749015,0.18523162448670019,45.017301868050005,46.999360902745266,8.0180924727661722,23.789640209641085,5.6144652884652286,1.975623022818904,0.21031463194880795,0.28758406938242786]
[2019,8760,11.02910026542065,9.7269165154687141,9.4498344673406045,9.9825317664156081,14.163031893510425,24.197868732971607,13.432617176338681,1.0156410531289561,2.1783144753920034,0.23631860413495756,1.8815938943235746,1.2322097192681307,0.77896675414307026,0.1676227271384555,1.3013115946676117,0.1416350488515192,0.19000000000003714,6.7877351299784172E-2,0.60307106365145591,0.41256998947750473,18.097301182385191,0.99116066279661807,9.7269165154687323E-2,2.6984129326697639,12.777449839615464,8.3721245565552742,0.65063379106085106,1.5430045399771819,2.7430539876089841,3.5390043744922095,3.0179684695610285,39.914903968269151,3.970853991513775,0,0,0,0,7.145511202385961E-2,0.13073793025917155,0.20678529566269785,0.13090112499849357,7.7830653330358182,30.008571581614635,2.40240610823842,3.8833134390800623,3.5390043744922095,2.7430539876089841,1.5430045399771819,39.914903968269151,39.914903968269151,3.0179684695610285,0,0,0.23319606256396802,0.20678529566269785,0.13073793025917155,7.145511202385961E-2,7.7830653330358182,7.7830653330358182,0.17138957170713606,40.539215101874035,42.657127600332565,7.8078260317929491,23.159533691807397,5.1921258154063681,1.8418819725814417,0.19727157982858476,0.29421402971036203]
[2020,8784,10.070107300065867,8.5955454860153839,9.5541997914073225,9.8899323252687541,10.669081344789978,22.079872056618051,11.168309920451012,0.99531680184780436,0.81424187745870358,8.6403909886662744E-2,2.1398782724270857,1.1323854869063463,0.58679947396344534,6.18701592991448E-2,1.1463722216953169,0.13879359861372517,0.19000000000003717,2.4817633662488035E-2,0.59575112038813749,0.39956568145967136,15.891015823112577,1.043229759857031,8.5955454860153421E-2,2.8761180031021123,12.163696193918275,6.5670039795058788,0.68211961774962981,1.549334481754661,2.7085531016513662,3.6271071043984855,3.0052170398143239,33.721117956169039,3.7316224951400332,0,0,0,0,7.1937226312606156E-2,0.13008159649068818,0.22102641616696175,0.13010911663391417,6.6990136563268727,26.673916807339666,2.6109093154496188,4.0642673756424212,3.6271071043984855,2.7085531016513662,1.549334481754661,33.721117956169039,33.721117956169039,3.0052170398143239,0,0,0.25769304880149041,0.22102641616696175,0.13008159649068818,7.1937226312606156E-2,6.6990136563268727,6.6990136563268727,0.17301341432865658,33.563195278866729,35.789477461180475,6.628340374874413,19.763855406466398,5.063589583614684,1.8108550545998614,0.20307343100938172,0.354614665883345]
[]
[]
[]
[" Year","HP Elec. (kWh)","CP Elec. for Htg (kWh)","Elec. Resistance Heating (kWh)","Distribution CP  Elec. For Htg  (kWh)",null,null,null,null,null,null,null,null,null,null,null,null,null," Year","CP Elec. for Clg (kWh)","Distribution CP  Elec. For Clg  (kWh)"]
[2016,{"$f":"B4*I4-D13","v":87309.784861111679},{"$f":"U4*B4","v":4708.1443141608979},{"$f":"(Z4+L4)*B4","v":26239.815138888382},{"$f":"(B4*(D4-J4))*C21","v":49170.771989066576},null,null,null,null,null,null,null,null,null,null,null,null,null,2016,{"$f":"B4*V4","v":4197.5048987185},{"$f":"(B4*(D4-J4))*B21","v":25262.118798054391}]
[2017,{"$f":"B5*I5-D14","v":90800.109964761767},{"$f":"U5*B5","v":5103.9960624466366},{"$f":"(Z5+L5)*B5","v":26175.923653981525},{"$f":"(B5*(D5-J5))*C22","v":47860.996417046808},null,null,null,null,null,null,null,null,null,null,null,null,null,2017,{"$f":"B5*V5","v":3785.0252937776231},{"$f":"(B5*(D5-J5))*B22","v":25404.95628092741}]
[2018,94642.8430338123,4751.7051567480676,26073.405222122805,46775.886750521488,null,null,null,null,null,null,null,null,null,null,null,null,null,2018,3879.1901462856326,32274.217926965615]
[2019,91961.478202317492,5282.9025175867537,25708.248262409357,49650.367568368369,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,3614.1131078229414,26660.405481727907]
[2020,72079.641857548297,5233.0778414893994,26022.7924836934,45538.584505358951,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,3509.7849459417534,21221.824256369066]
[]
[]
[" Year","Clg fraction","Htg fraction"]
[2016,{"$f":"G4/(G4+H4+K4)","v":0.33939456778998922},{"$f":"1-B21","v":0.66060543221001078}]
[2017,{"$f":"G5/(G5+H5+K5)","v":0.3467498250606908},{"$f":"1-B22","v":0.65325017493930915}]
[2018,0.40827546097047834,0.5917245390295216]
[2019,0.34936620893914888,0.65063379106085106]
[2020,0.31788038225037019,0.68211961774962981]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CELL(\"filename\")","v":"D:\\Dropbox\\Gehlin-Spitler_collaboration\\Studenthuset\\studenthuset data detailed excel files\\2021_update\\20211208_Results\\[BinResultsYear_V3.xlsm]BinResultsYear"}]

{"sheet":"GHELoads","index":2,"n_rows":17,"n_cols":70,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[" Year","Count","ODA Temperature (°C)","EL 007 (kW)","GHE EFT (°C)","GHE ExFT (°C)","Clg Provided (kW)","Bldg Htg Provided (kW)","EL 003 (kW)","CP Energy (kW)","DHW Provided by HP (kW)","DHW by LPS (kW)","Useful Bldg Htg by LPS (kW)","Bldg Htg Uncertainty (kW)","Bldg Clg Uncertainty (kW)","DHW Htg by HP Uncertainty (kW)","Bldg + DHW Htg by HP Uncertainty (kW)","EL007+EL011 Uncertainty (kW)","EL011 Uncertainty (kW)","LPS DHW Uncertainty (kW)","CP Power for Heat Extraction from GHE (kW)","CP Power for Heat Rejection to GHE (kW)","Heat Extraction by GHE (kW)","Heat Rejection to GHE (kW)","EL007 Uncertainty (kW)","LPS Electricity going to bldg heat (kW)","Alt Calc GHE Heat Extraction (kW)","Alt Calc GHE Heat Extraction (kW)","HtgFrac","COP H4","COP H3","COP H2","COP C3","COP C2","Overall (H+C) COP","Not used","Not used","Not used","Not used","Error COP H4","Error COP H3","Error COP H2","Error COP H3b","Error COP C2","BPF0, heating","BPF0, cooling","BPF1*, heating","BPF2, heating","BPF3+, heating","BPF4+, heating","BPF2, cooling","BPF3, cooling","BPF4, cooling","Error BPF0, heating","Error BPF0, cooling","Error BPF1*, heating","Error BPF2, heating","Error BPF3+, heating","Error BPF4+, heating","Error BPF2, cooling","Error BPF3, cooling","Error BPF4, cooling","Htg & Clg Provided Boundary 2","Htg & Clg Provided Boundary 4+","Electricity Used Boundary 2","Electricity Used Boundary 4+","BPFHC2","BPFHC4+","Error BPFHC2","Error BPFHC4+"]
[2016,8783,7.9513269756916261,9.4886189229193132,9.4953831264943513,9.9972788341114018,12.690520873003099,22.908402595923945,12.928338836388486,1.0139643872115875,1.792720586070758,0.19695205067871255,1.6853951288473956,1.1571248981025433,0.69797864801517107,0.13896919284425277,1.2201110305706977,0.14006403970130019,0.19000000000003717,5.6570169674397167E-2,0.53605195424808127,0.47791243296350905,17.214639236336915,1.1503462591246556,9.4886189229192217E-2,2.7906165635633897,13.951865617922863,9.4562780048199553,0.66060543221001067,1.4744716569869945,2.6168827114162534,3.4446428892917718,2.8922233960757708,36.876683763840255,3.7394600999393939,0,0,0,0,6.8636947530386433E-2,0.12541052496374111,0.20262921581309079,0.12553410326583064,7.2015833338995572,32.113751474861886,2.4070230857804242,3.7995588419036119,3.4446428892917718,2.6168827114162534,1.4744716569869945,36.876683763840255,36.876683763840255,2.8922233960757708,0,0,0.23033759763036665,0.20262921581309079,0.12541052496374111,6.8636947530386433E-2,7.2015833338995572,7.2015833338995572,0.16465324115927443,37.391644054997805,39.273991234523912,7.5150146958887989,22.416957759307799,4.975591608018207,1.7519768586001312,0.18998604299682995,0.27766942603194766]
[2017,8760,7.7740964855493129,9.3784216956847466,9.4211658578545716,9.9181733602109734,13.026244975964339,22.622765851436412,13.353428495290331,1.0147284653223916,1.9176843358466555,0.2105706454751021,1.8601777502998968,1.1546488091218405,0.71644347367803562,0.14861076436397264,1.216114484904161,0.13605478824401837,0.19000000000003714,6.0481813222681959E-2,0.58264795233409095,0.43208051298831313,16.931928040758422,1.0847778370326842,9.3784216956849492E-2,2.7775484931072638,11.633916056569058,7.5247418676753011,0.65325017493930915,1.4701059756987886,2.650176420368179,3.479348421487626,2.8132621653305696,37.021426368789221,3.8138045679098869,0,0,0,0,6.8085491530808631E-2,0.12632255251818805,0.20631752265086237,0.12646607263424769,7.2248378340596267,29.060306438783527,2.5105919022597187,3.8402642078359888,3.479348421487626,2.650176420368179,1.4701059756987886,37.021426368789221,37.021426368789221,2.8132621653305696,0,0,0.23486102067336592,0.20631752265086237,0.12632255251818805,6.8085491530808631E-2,7.2248378340596267,7.2248378340596267,0.15982329782772875,37.56669516324741,39.637443559022408,7.4050310224247724,22.731850190975077,5.0731313683202126,1.7436963215057231,0.19431275713434554,0.29890557098604104]
[2018,8760,10.006805658083657,10.009246573118812,9.6114056978504134,10.161161128246736,18.379459671825291,24.468907240876064,13.780393636522271,0.98526202089425607,2.168934955348651,0.23796025388890185,1.7440987808063615,1.2384544057492888,1.0108702819503879,0.16799370531365754,1.3113241705757004,0.13931600337431824,0.19000000000003714,6.8348879292544615E-2,0.54243209551918581,0.44282992537507221,18.130717486881011,1.0874571306837844,0.10009246573118857,2.7384558673579935,12.947401288406818,12.707111236773487,0.59172453902952171,1.5756869561609852,2.701966102769731,3.4976919943474534,3.2667645827431482,45.690690307123411,4.2748032348019835,0,0,0,0,7.3200388894936422E-2,0.12880012196214297,0.20313382536186925,0.12896165739734183,9.1624447818749015,33.424861170000085,2.4556992840145564,3.787641743749782,3.4976919943474534,2.701966102769731,1.5756869561609852,45.690690307123411,45.690690307123411,3.2667645827431482,0,0,0.22500985128987522,0.20313382536186925,0.12880012196214297,7.3200388894936422E-2,9.1624447818749015,9.1624447818749015,0.18523162448670019,45.017301868050005,46.999360902745266,8.0180924727661722,23.789640209641085,5.6144652884652286,1.975623022818904,0.21031463194880795,0.28758406938242786]
[2019,8760,11.02910026542065,9.7269165154687141,9.4498344673406045,9.9825317664156081,14.163031893510425,24.197868732971607,13.432617176338681,1.0156410531289561,2.1783144753920034,0.23631860413495756,1.8815938943235746,1.2322097192681307,0.77896675414307026,0.1676227271384555,1.3013115946676117,0.1416350488515192,0.19000000000003714,6.7877351299784172E-2,0.60307106365145591,0.41256998947750473,18.097301182385191,0.99116066279661807,9.7269165154687323E-2,2.6984129326697639,12.777449839615464,8.3721245565552742,0.65063379106085106,1.5430045399771819,2.7430539876089841,3.5390043744922095,3.0179684695610285,39.914903968269151,3.970853991513775,0,0,0,0,7.145511202385961E-2,0.13073793025917155,0.20678529566269785,0.13090112499849357,7.7830653330358182,30.008571581614635,2.40240610823842,3.8833134390800623,3.5390043744922095,2.7430539876089841,1.5430045399771819,39.914903968269151,39.914903968269151,3.0179684695610285,0,0,0.23319606256396802,0.20678529566269785,0.13073793025917155,7.145511202385961E-2,7.7830653330358182,7.7830653330358182,0.17138957170713606,40.539215101874035,42.657127600332565,7.8078260317929491,23.159533691807397,5.1921258154063681,1.8418819725814417,0.19727157982858476,0.29421402971036203]
[2020,8784,10.070107300065867,8.5955454860153839,9.5541997914073225,9.8899323252687541,10.669081344789978,22.079872056618051,11.168309920451012,0.99531680184780436,0.81424187745870358,8.6403909886662744E-2,2.1398782724270857,1.1323854869063463,0.58679947396344534,6.18701592991448E-2,1.1463722216953169,0.13879359861372517,0.19000000000003717,2.4817633662488035E-2,0.59575112038813749,0.39956568145967136,15.891015823112577,1.043229759857031,8.5955454860153421E-2,2.8761180031021123,12.163696193918275,6.5670039795058788,0.68211961774962981,1.549334481754661,2.7085531016513662,3.6271071043984855,3.0052170398143239,33.721117956169039,3.7316224951400332,0,0,0,0,7.1937226312606156E-2,0.13008159649068818,0.22102641616696175,0.13010911663391417,6.6990136563268727,26.673916807339666,2.6109093154496188,4.0642673756424212,3.6271071043984855,2.7085531016513662,1.549334481754661,33.721117956169039,33.721117956169039,3.0052170398143239,0,0,0.25769304880149041,0.22102641616696175,0.13008159649068818,7.1937226312606156E-2,6.6990136563268727,6.6990136563268727,0.17301341432865658,33.563195278866729,35.789477461180475,6.628340374874413,19.763855406466398,5.063589583614684,1.8108550545998614,0.20307343100938172,0.354614665883345]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CELL(\"filename\")","v":"D:\\Dropbox\\Gehlin-Spitler_collaboration\\Studenthuset\\studenthuset data detailed excel files\\2021_update\\20211208_Results\\[BinResultsYear_V3.xlsm]BinResultsYear"}]
[]
[" Year","Clg (kW)","Htg (kW)","HP DHW Htg (kW)",null,null," Year","Clg (kWh)","Htg (kWh)","HP DHW Htg (kWh)","Compressor (kWh)","Loop CP (kWh)","Internal CP (kWh)","Kitchen Refrig (kWh)","Net heat extraction (kWh)","Net heat extraction (kWh/m)","Net heat extraction (W/m)"," Year","Clg uncertainty (%)","Htg uncertainty (%)"]
[2016,{"$f":"-G3","v":-12.690520873003099},{"$f":"H3","v":22.908402595923945},{"$f":"L3","v":0.19695205067871255},null,null,2016,{"$f":"$B3*B12","v":-111460.84482758622},{"$f":"$B3*C12","v":201204.5},1729.8298611111322,{"$f":"H12/AU3","v":-29335.206918849392},{"$f":"-B3*J3","v":-8905.6492128793743},{"$f":"-B3*D3","v":-83338.540000000328},{"$f":"-8760*2.5","v":-21900},{"$f":"SUM(H12:M12)","v":-30105.911098204175},{"$f":"O12/(20*200)","v":-7.5264777745510436},{"$f":"P12*1000/8760","v":-0.85918696056518762},2016,{"$f":"O3/G3","v":5.5000000000000049E-2},{"$f":"N3/H3","v":5.051093777740874E-2},null,null,{"$f":"I12+J12","v":202934.32986111112},{"$f":"H12+K12+L12+M12+N12","v":-254940.2409593153}]
[2017,{"$f":"-G4","v":-13.026244975964339},{"$f":"H4","v":22.622765851436412},{"$f":"L4","v":0.2105706454751021},null,null,2017,{"$f":"$B4*B13","v":-114109.90598944761},198175.42885858298,1844.5988543618944,{"$f":"H13/AU4","v":-29714.076900388372},{"$f":"-B4*J4","v":-8889.0213562241497},{"$f":"-B4*D4","v":-82154.974054198377},{"$f":"-8760*2.5","v":-21900},{"$f":"SUM(H13:M13)","v":-34847.950587313644},{"$f":"O13/(20*200)","v":-8.7119876468284119},{"$f":"P13*1000/8760","v":-0.99451913776580037},2017,{"$f":"O4/G4","v":5.4999999999999771E-2},{"$f":"N4/H4","v":5.1039241474911304E-2},null,null,{"$f":"I13+J13","v":200020.02771294487},{"$f":"H13+K13+L13+M13+N13","v":-256767.97830025852},null,null,{"$f":"sum","v":{"$error":"#NAME?"}}]
[2018,-18.379459671825291,24.468907240876064,0.23796025388890185,null,null,2018,{"$f":"$B5*B14","v":-161004.06672518956},214347.62743007432,2084.5318240667802,-42507.73373455189,-8630.8953030336834,-87680.999980520792,-21900,-83391.536489154823,-20.847884122288704,-2.3798954477498522,2018,5.4999999999999827E-2,5.0613392480413369E-2,null,null,216432.15925414109,-321723.69574329589]
[2019,-14.163031893510425,24.197868732971607,0.23631860413495756,null,null,2019,{"$f":"$B6*B15","v":-124068.15938715132},211973.33010083128,2070.1509722222281,-31949.045920059045,-8897.0156254096564,-85207.78867550593,-21900,-36078.528535072437,-9.0196321337681091,-1.0296383714347157,2019,5.4999999999999778E-2,5.0922241659619491E-2,null,null,214043.48107305352,-272022.00960812595,{"$f":"AVERAGE(Q12:Q16)","v":-1.0886844957644859}]
[2020,-10.669081344789978,22.079872056618051,8.6403909886662744E-2,null,null,2020,{"$f":"$B7*B16","v":-93717.210532635174},193949.59614533297,758.97194444444551,-23058.820168744853,-8742.8627874311132,-75503.271549159137,-21900,-6313.5969481928623,-1.5783992370482156,-0.18018256130687393,2020,5.4999999999999674E-2,5.1285871766042858E-2,null,null,194708.5680897774,-222922.16503797026]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W12:W16)","v":1028138.565991028},{"$f":"SUM(X12:X16)","v":-1328376.089648966},null,{"$f":"X17/W17","v":-1.2920204859434852}]