{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["quasi-static Net ZEB evaluation","quasi-static weighting factors","Building Data","static weighting factors","Operating costs","Net ZEB evaluation","Calculation"],"not_rendered":{"charts":18,"images":16,"macros":1,"external_links":2,"defined_names":32,"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":"quasi-static Net ZEB evaluation","index":0,"n_rows":95,"n_cols":10,"rows_kept":95,"cut":false,"hidden":false,"merged":[[45,7,46,7],[45,8,46,8],[45,9,46,9],[15,1,15,4],[43,0,43,4],[45,2,46,2],[45,3,46,3],[45,4,46,4],[45,5,46,5],[45,6,46,6],[0,2,1,7],[6,0,6,10],[10,0,10,4],[12,2,13,2],[12,3,13,3],[12,5,13,5],[12,4,13,4],[12,6,13,6],[12,7,13,7],[12,8,13,8],[12,9,13,9],[48,1,48,4],[111,0,111,10],[77,0,77,4],[82,1,82,4],[79,2,80,2],[79,3,80,3],[79,4,80,4],[79,5,80,5],[79,6,80,6],[79,7,80,7],[79,8,80,8],[79,9,80,9]]}
[null,null,"Net ZEB Evaluation Tool"]
[]
[null,null,null,"Developed within the IEA - SHC Task 40/ECBCS Annex 52 - \"Towards Net Zero Energy solar Buildings\""]
[null,null,null,"Created by: Eurac Research within subtask A"]
[]
[]
["Building Project - quasi-static Net ZEB evaluation"]
[]
[]
[]
["                              GENERATION/LOAD BALANCE"]
[]
[null,null,null,"kWhpe/m²y",null,"kWhpe/m²y",null,"__/m²y",null,"kgCO2eq/m²y"]
[]
[]
[null,"Generation/Load balance",null,null,null,null,"Electricity Load Match"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Thermal Load Match"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["                              ESTIMATED IMPORT/EXPORT BALANCE"]
[]
[null,null,null,"kWhpe/m²y",null,"kWhpe/m²y",null,"__/m²y",null,"kgCO2eq/m²y"]
[]
[]
[null,"Estimated Import/Export balance",null,null,null,null,"Electricity Load Match"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Thermal Load Match"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["                              MONITORED IMPORT/EXPORT BALANCE"]
[]
[null,null,null,"kWhpe/m²y",null,"kWhpe/m²y",null,"__/m²y",null,"kgCO2eq/m²y"]
[]
[]
[null,"Monitored Import/Export balance",null,null,null,null,"Electricity Load Match"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Thermal Load Match"]

{"sheet":"quasi-static weighting factors","index":1,"n_rows":41,"n_cols":16,"rows_kept":41,"cut":false,"hidden":false,"merged":[[19,15,19,16],[39,15,39,16],[40,15,40,16],[0,0,1,16],[2,0,4,1],[6,0,6,16],[11,15,11,16],[12,15,12,16],[20,15,20,16],[25,15,25,16],[26,15,26,16],[33,15,33,16],[34,15,34,16]]}
["Net ZEB Evaluation Tool"]
[]
[null,null,null,null,null,"Developed within the IEA - SHC Task 40/ECBCS Annex 52 - \"Towards Net Zero Energy solar Buildings\""]
[null,null,null,null,null,"Created by: Eurac Research within subtask A"]
[]
[]
["quasi-static weighting factors"]
[]
[null,"PRIMARY ENERGY FACTORS"]
[]
[null,"Wi [kWhpe/kWhi]",null,"jan","feb","mar","apr","may","jun","jul","aug","sep","oct","nov","dec","Note"]
[null,"Wi1 - electricity"]
[null,"Wi5 - heat"]
[]
[null,"STRATEGIC FACTORS"]
[]
[null,"Asymmetric strategic weighting  factors  for exported energy - We,i"]
[]
[null,"We,i [kWh/kWhi]",null,"jan","feb","mar","apr","may","jun","jul","aug","sep","oct","nov","dec","Note"]
[null,"We,i1 - electricity"]
[null,"We,i5 - heat"]
[]
[null,"Asymmetric strategic weighting factors for delivered energy - Wd,i"]
[]
[null,"Wd,i [kWh/kWhi]",null,"jan","feb","mar","apr","may","jun","jul","aug","sep","oct","nov","dec","Note"]
[null,"Wd,i1 - electricity"]
[null,"Wd,i5 - heat"]
[]
[null,"CARBON FACTORS"]
[]
[null,"Symmetric or asymmetric carbon weighting  factors  for exported energy - We,i"]
[]
[null,"We,i [kWh/kWhi]",null,"jan","feb","mar","apr","may","jun","jul","aug","sep","oct","nov","dec","Note"]
[null,"We,i1 - electricity"]
[null,"We,i5 - heat"]
[]
[null,"Symmetric or asymmetric carbon weighting factors for delivered energy - Wd,i"]
[]
[null,"Wd,i [kWh/kWhi]",null,"jan","feb","mar","apr","may","jun","jul","aug","sep","oct","nov","dec","Note"]
[null,"Wd,i1 - electricity"]
[null,"Wd,i5 - heat"]

{"sheet":"Building Data","index":2,"n_rows":132,"n_cols":19,"rows_kept":132,"cut":false,"hidden":false,"merged":[[8,2,8,7],[11,2,11,7],[44,2,44,3],[103,2,103,3],[104,2,104,3],[104,11,104,14],[105,1,109,1],[105,2,105,3],[105,11,105,14],[106,2,106,3],[106,11,106,14],[107,2,107,3],[107,11,107,14],[108,2,108,3],[108,11,108,14],[109,2,109,3],[109,11,109,14],[73,1,76,1],[73,2,73,3],[73,11,73,14],[74,2,74,3],[74,11,74,14],[68,1,72,1],[27,2,27,3],[117,2,117,3],[118,2,118,3],[118,11,118,14],[119,2,119,3],[119,11,119,14],[110,1,113,1],[110,2,110,3],[110,11,110,14],[111,2,111,3],[111,11,111,14],[112,2,112,3],[112,11,112,14],[113,2,113,3],[113,11,113,14],[76,11,76,14],[34,2,34,3],[36,2,36,3],[37,2,37,3],[35,11,35,14],[36,11,36,14],[37,11,37,14],[28,2,28,3],[71,2,71,3],[71,11,71,14],[72,2,72,3],[72,11,72,14],[28,11,28,14],[43,11,43,14],[42,2,42,3],[43,2,43,3],[68,2,68,3],[68,11,68,14],[69,2,69,3],[69,11,69,14],[70,2,70,3],[70,11,70,14],[27,11,27,14],[9,4,9,7],[41,2,41,3],[38,2,38,3],[39,2,39,3],[82,2,82,3],[82,11,82,14],[35,2,35,3],[41,11,41,14],[40,11,40,14],[38,11,38,14],[39,11,39,14],[40,2,40,3],[42,11,42,14],[66,2,66,3],[67,2,67,3],[67,11,67,14],[80,2,80,3],[81,2,81,3],[81,11,81,14],[45,2,45,3],[75,2,75,3],[75,11,75,14],[76,2,76,3],[10,4,10,7],[12,2,12,7],[99,3,99,4],[0,0,1,14],[2,0,4,2],[6,0,6,14],[19,11,19,14],[26,11,26,14],[22,11,22,14],[20,2,20,3],[21,2,21,3],[22,2,22,3],[21,11,21,14],[20,11,20,14],[19,2,19,3],[18,2,18,3],[23,2,23,3],[23,11,23,14],[24,11,24,14],[24,2,24,3],[26,2,26,3],[20,1,25,1],[26,1,30,1],[29,2,29,3]]}
["Net ZEB Evaluation Tool"]
[]
[null,null,null,"Developed within the IEA - SHC Task 40/ECBCS Annex 52 - \"Towards Net Zero Energy solar Buildings\""]
[null,null,null,"Created by: Eurac Research within subtask A"]
[]
[]
["Building Project - Input Data"]
[]
[null,"Name of project"]
[null,"Building type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RESIDENTIAL",1]
[null,"Location (city, country)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NON RESIDENTIAL"]
[null,"Energy rating"]
[null,"Web site"]
[]
[null,"BUILDING DESIGN DATA"]
[]
[null,"gi Energy generation"]
[]
[null,null,"i - energy carrier",null,"i1","i5","i6","i8","i9","i10","i11"]
[null,null,"gi - energy generation by:",null,"electricity\n[kWhel/m²y]","heat to district heating [kWhh/m²y]","cold to district cooling [kWhc/m²y]","enter one more energy source produced [kWh/m²y]","enter one more energy source produced [kWh/m²y]","enter one more energy source produced [kWh/m²y]","enter one more energy source produced [kWh/m²y]","Note"]
[null,"building on-site generation systems connected to the energy infrastructure\n","PV"]
[null,null,"cogeneration/trigeneration"]
[null,null,"solar thermal"]
[null,null,"enter one more generation system"]
[null,null,"enter one more generation system"]
[null,null,"TOTAL"]
[null,"off-site generation systems connected to the energy infrastructure\n","PV"]
[null,null,"wind turbine"]
[null,null,"enter one more generation system"]
[null,null,"enter one more generation system"]
[null,null,"TOTAL"]
[]
[null,"li Energy load of building systems"]
[]
[null,null,"i - energy carrier",null,"i1","i2","i3","i4","i5","i6","i7"]
[null,null,"li- building  systems load",null,"electricity [kWhel/m²y]","oil [kWhol/m²y]","gas [kWhg/m²y]","biomass [kWhb/m²y]","heat from district heating [kWhh/m²y]","cold from district cooling [kWhc/m²y]","enter one more energy source [kWh/m²y]","Note"]
[null,null,"heating "]
[null,null,"DHW"]
[null,null,"cooling"]
[null,null,"built-in lighting"]
[null,null,"auxiliaries"]
[null,null,"ventilation"]
[null,null,"plug loads"]
[null,null,"cogeneration/trigeneration"]
[null,null,"other"]
[null,null,"TOTAL"]
[]
[null,"Design monthly data about load and generation"]
[]
[null,"i1 = electricity",null,"jan","feb","mar","apr","may","jun","jul","aug","sep","oct","nov","dec"]
[null,null,"Generation (i1) [kWhel/m²]"]
[null,null,"Load (i1) [kWhel/m²]"]
[]
[]
[]
[null,"i5 = heat from/to district heating",null,"jan","feb","mar","apr","may","jun","jul","aug","sep","oct","nov","dec"]
[null,null,"Generation (i5) [kWhh/m²]"]
[null,null,"Load (i5) [kWhh/m²]"]
[]
[]
[null,"ESTIMATED BUILDING-GRID INTERACTION DATA"]
[]
[null,"Simulation time step",null,null,null,null,null,null,null,null,null,"Estimated delivered energy for plug loads",null,null,"kWh/m²y"]
[]
[null,"ei Estimated exported energy carriers"]
[]
[null,null,"i - energy carrier",null,"i1","i5","i6","i8","i9","i10","i11"]
[null,null,"ei - exported energy by:",null,"electricity\n[kWhel/m²y]","heat to district heating [kWhh/m²y]","cold to district cooling [kWhc/m²y]","enter one more energy source produced [kWh/m²y]","enter one more energy source produced [kWh/m²y]","enter one more energy source produced [kWh/m²y]","enter one more energy source produced [kWh/m²y]","Note"]
[null,"building on-site generation systems connected to the energy infrastructure\n","PV"]
[null,null,"cogeneration/trigeneration"]
[null,null,"solar thermal"]
[null,null,"enter one more generation system"]
[null,null,"enter one more generation system"]
[null,"off-site generation systems connected to the energy infrastructure\n","PV"]
[null,null,"wind turbine"]
[null,null,"enter one more generation system"]
[null,null,"enter one more generation system"]
[]
[null,"di Estimated delivered energy carriers"]
[]
[null,null,"i - energy carrier",null,"i1","i2","i3","i4","i5","i6","i7"]
[null,null,null,null,"electricity [kWhel/m²y]","oil [kWhol/m²y]","gas [kWhg/m²y]","biomass [kWhb/m²y]","heat from district heating [kWhh/m²y]","cold from district cooling [kWhc/m²y]","enter one more energy source [kWh/m²y]","Note"]
[null,null,"di - delivered energy"]
[]
[null,"Estimated monthly data about exported and delivered energy"]
[]
[null,"i1 = electricity ",null,"jan","feb","mar","apr","may","jun","jul","aug","sep","oct","nov","dec"]
[null,null,"Exported (i1) [kWhel/m²]"]
[null,null,"Delivered (i1) [kWhel/m²]"]
[null,null,"Generation (i1) [kWhel/m²]"]
[]
[null,"i5 = heat from/to district heating",null,"jan","feb","mar","apr","may","jun","jul","aug","sep","oct","nov","dec"]
[null,null,"Exported (i5) [kWhh/m²]"]
[null,null,"Delivered (i5) [kWhh/m²]"]
[null,null,"Generation (i5) [kWhh/m²]"]
[]
[]
[null,"MONITORED BUILDING-GRID INTERACTION DATA"]
[]
[null,"Time resolution of monitored data",null,null,null,null,null,null,null,null,null,"Monitored delivered energy for plug loads",null,null,"kWh/m²y"]
[]
[null,"ei Monitored exported energy carriers"]
[]
[null,null,"i - energy carrier",null,"i1","i5","i6","i8","i9","i10","i11"]
[null,null,"ei - exported energy by:",null,"electricity\n[kWhel/m²y]","heat to district heating [kWhh/m²y]","cold to district cooling [kWhc/m²y]","enter one more energy source produced [kWh/m²y]","enter one more energy source produced [kWh/m²y]","enter one more energy source produced [kWh/m²y]","enter one more energy source produced [kWh/m²y]","Note"]
[null,"building on-site generation systems connected to the energy infrastructure\n","PV"]
[null,null,"cogeneration/trigeneration"]
[null,null,"solar thermal"]
[null,null,"enter one more generation system"]
[null,null,"enter one more generation system"]
[null,"off-site generation systems connected to the energy infrastructure\n","PV"]
[null,null,"wind turbine"]
[null,null,"enter one more generation system"]
[null,null,"enter one more generation system"]
[]
[null,"di Monitored delivered energy carriers"]
[]
[null,null,"i - energy carrier",null,"i1","i2","i3","i4","i5","i6","i7"]
[null,null,null,null,"electricity [kWhel/m²y]","oil [kWhol/m²y]","gas [kWhg/m²y]","biomass [kWhb/m²y]","heat from district heating [kWhh/m²y]","cold from district cooling [kWhc/m²y]","enter one more energy source [kWh/m²y]","Note"]
[null,null,"di - delivered energy"]
[]
[null,"Monitored monthly data about exported and delivered energy"]
[]
[null,"i1 = electricity ",null,"jan","feb","mar","apr","may","jun","jul","aug","sep","oct","nov","dec"]
[null,null,"Exported (i1) [kWhel/m²]"]
[null,null,"Delivered (i1)  [kWhel/m²]"]
[null,null,"Generation (i1) [kWhel/m²]"]
[]
[null,"i5 = heat from/to district heating",null,"jan","feb","mar","apr","may","jun","jul","aug","sep","oct","nov","dec"]
[null,null,"Exported (i5) [kWhh/m²]"]
[null,null,"Delivered (i5) [kWhh/m²]"]
[null,null,"Generation (i5) [kWhh/m²]"]

{"sheet":"static weighting factors","index":3,"n_rows":63,"n_cols":13,"rows_kept":63,"cut":false,"hidden":false,"merged":[[49,11,49,13],[50,11,50,13],[51,11,51,13],[52,11,52,13],[58,11,58,13],[44,11,44,13],[45,11,45,13],[46,11,46,13],[47,11,47,13],[48,11,48,13],[26,11,26,13],[27,11,27,13],[28,11,28,13],[29,11,29,13],[35,11,35,13],[21,11,21,13],[22,11,22,13],[23,11,23,13],[24,11,24,13],[25,11,25,13],[62,7,63,7],[57,2,57,3],[58,2,58,3],[56,2,56,3],[49,1,52,1],[49,2,49,3],[50,2,50,3],[51,2,51,3],[52,2,52,3],[34,2,34,3],[35,2,35,3],[42,2,42,3],[43,2,43,3],[44,1,48,1],[44,2,44,3],[45,2,45,3],[46,2,46,3],[47,2,47,3],[48,2,48,3],[42,1,43,1],[33,2,33,3],[26,1,29,1],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[21,1,25,1],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[0,0,1,13],[2,0,4,1],[6,0,6,13],[19,2,19,3],[20,2,20,3],[10,1,11,1],[19,1,20,1]]}
["Net ZEB Evaluation Tool"]
[]
[null,null,null,null,null,"Developed within the IEA - SHC Task 40/ECBCS Annex 52 - \"Towards Net Zero Energy solar Buildings\""]
[null,null,null,null,null,"Created by: Eurac Research within subtask A"]
[]
[]
["static weighting factors"]
[]
[null,"PRIMARY ENERGY FACTORS"]
[]
[null,"Wi [kWhpe/kWhi]","i1","i2","i3","i4","i5","i6","i7","i8","i9","i10","i11"]
[null,null,"electricity ","oil ","gas ","biomass ","heat from/to district heating ","cold from/to district cooling ","enter one more energy source ","enter one more energy source ","enter one more energy source ","enter one more energy source ","enter one more energy source "]
[null,"Symmetric primary energy factors"]
[null,"Note"]
[]
[null,"STRATEGIC FACTORS"]
[]
[null,"Asymmetric strategic weighting  factors  for exported energy - We,i-sys"]
[]
[null,"We,i-sys [Uwe/kWhi]","i - energy carrier",null,"i1","i5","i6","i8","i9","i10","i11"]
[null,null,"sys-energy generation system",null,"electricity ","heat to district heating ","cold to district cooling ","enter one more energy source ","enter one more energy source ","enter one more energy source ","enter one more energy source ","Note"]
[null,"building on-site generation systems connected to the energy infrastructure\n","PV"]
[null,null,"cogeneration/trigeneration"]
[null,null,"solar thermal"]
[null,null,"enter one more generation system"]
[null,null,"enter one more generation system"]
[null,"building off-site generation systems connected to the energy infrastructure\n","PV"]
[null,null,"wind turbine"]
[null,null,"enter one more generation system"]
[null,null,"enter one more generation system"]
[]
[null,"Asymmetric strategic weighting factors for delivered energy - Wd,i"]
[]
[null,null,"i - energy carrier",null,"i1","i2","i3","i4","i5","i6","i7"]
[null,null,null,null,"electricity ","oil ","gas ","biomass ","heat from district heating ","cold from district cooling ","enter one more energy source ","Note"]
[null,null,"Wd,i [Uws/kWhi]"]
[]
[]
[null,"CARBON FACTORS"]
[]
[null,"Symmetric or asymmetric carbon  factors  for exported energy - We,i-sys"]
[]
[null,"We,i-sys [kgCO2/kWhi]","i - energy carrier",null,"i1","i5","i6","i8","i9","i10","i11"]
[null,null,"sys-energy generation system",null,"electricity ","heat to district heating ","cold to district cooling ","enter one more energy source ","enter one more energy source ","enter one more energy source ","enter one more energy source ","Note"]
[null,"building on-site generation systems connected to the energy infrastructure\n","PV"]
[null,null,"cogeneration/trigeneration"]
[null,null,"solar thermal"]
[null,null,"enter one more generation system"]
[null,null,"enter one more generation system"]
[null,"building off-site generation systems connected to the energy infrastructure\n","PV"]
[null,null,"wind turbine"]
[null,null,"enter one more generation system"]
[null,null,"enter one more generation system"]
[]
[null,"Symmetric or asymmetric carbon  factors  for delivered energy - Wd,i"]
[]
[null,null,"i - energy carrier",null,"i1","i2","i3","i4","i5","i6","i7"]
[null,null,null,null,"electricity ","oil ","gas ","biomass ","heat from district heating ","cold from district cooling ","enter one more energy source ","Note"]
[null,null,"Wd,i [kgCO2/kWh]"]
[]
[]
[]
[null,null,null,null,null,null,null,"OR"]

{"sheet":"Operating costs","index":4,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[[32,11,32,12],[33,11,33,12],[34,11,34,12],[40,11,40,12],[27,11,27,12],[28,11,28,12],[29,11,29,12],[30,11,30,12],[31,11,31,12],[17,11,17,12],[18,11,18,12],[19,11,19,12],[20,11,20,12],[26,11,26,12],[12,11,12,12],[13,11,13,12],[14,11,14,12],[15,11,15,12],[16,11,16,12],[38,2,38,3],[39,2,39,3],[40,2,40,3],[31,1,34,1],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[24,2,24,3],[25,2,25,3],[26,1,30,1],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[24,1,25,1],[17,1,20,1],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[12,1,16,1],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[0,0,1,12],[2,0,4,1],[6,0,6,12],[10,2,10,3],[11,2,11,3],[10,1,11,1]]}
["Net ZEB Evaluation Tool"]
[]
[null,null,null,null,"Developed within the IEA - SHC Task 40/ECBCS Annex 52 - \"Towards Net Zero Energy solar Buildings\""]
[null,null,null,null,"Created by: Eurac Research within subtask A"]
[]
[]
["Operating energy costs"]
[]
[null,"Specific costs for exported energy"]
[]
[null,"Ce(i-sys) per kWh","i - energy carrier",null,"i1","i5","i6","i8","i9","i10","i11"]
[null,null,"sys-energy generation system",null,"electricity","heat to district heating","cold to district cooling ","enter one more energy source produced ","enter one more energy source produced ","enter one more energy source produced","enter one more energy source produced","Note"]
[null,"building on-site generation systems connected to the energy infrastructure\n","PV"]
[null,null,"cogeneration/trigeneration"]
[null,null,"solar thermal"]
[null,null,"enter one more generation system"]
[null,null,"enter one more generation system"]
[null,"building off-site generation systems connected to the energy infrastructure\n","PV"]
[null,null,"wind turbine"]
[null,null,"enter one more generation system"]
[null,null,"enter one more generation system"]
[]
[null,"Incentives for generation"]
[]
[null,"Cin(i-sys) per kWh","i - energy carrier",null,"i1","i5","i6","i8","i9","i10","i11"]
[null,null,"sys-energy generation system",null,"electricity","heat to district heating","cold to district cooling ","enter one more energy source produced ","enter one more energy source produced ","enter one more energy source produced","enter one more energy source produced","Note"]
[null,"building on-site generation systems connected to the energy infrastructure\n","PV"]
[null,null,"cogeneration/trigeneration"]
[null,null,"solar thermal"]
[null,null,"enter one more generation system"]
[null,null,"enter one more generation system"]
[null,"building off-site generation systems connected to the energy infrastructure\n","PV"]
[null,null,"wind turbine"]
[null,null,"enter one more generation system"]
[null,null,"enter one more generation system"]
[]
[null,"Specific costs for delivered energy"]
[]
[null,null,"i - energy carrier",null,"i1","i2","i3","i4","i5","i6","i7"]
[null,null,null,null,"electricity ","oil","gas ","biomass ","heat from district heating","cold from district cooling ","enter one more energy source","Note"]
[null,null," Cd(i) per kWh"]

{"sheet":"Net ZEB evaluation","index":5,"n_rows":109,"n_cols":10,"rows_kept":109,"cut":false,"hidden":false,"merged":[[111,0,111,10],[74,6,75,7],[74,8,75,9],[82,1,82,4],[77,0,77,4],[74,2,75,3],[74,4,75,5],[108,2,109,3],[108,4,109,5],[108,6,109,7],[108,8,109,9],[79,2,80,2],[79,8,80,8],[12,8,13,8],[79,9,80,9],[79,3,80,3],[79,4,80,4],[48,1,48,4],[45,2,46,2],[45,3,46,3],[45,4,46,4],[45,5,46,5],[45,6,46,6],[45,7,46,7],[45,8,46,8],[45,9,46,9],[79,5,80,5],[79,6,80,6],[79,7,80,7],[12,9,13,9],[43,0,43,4],[0,2,1,7],[6,0,6,10],[10,0,10,4],[15,1,15,4],[40,2,41,3],[40,4,41,5],[40,6,41,7],[40,8,41,9],[12,2,13,2],[12,3,13,3],[12,4,13,4],[12,5,13,5],[12,6,13,6],[12,7,13,7]]}
[null,null,"Net ZEB Evaluation Tool"]
[]
[null,null,null,"Developed within the IEA - SHC Task 40/ECBCS Annex 52 - \"Towards Net Zero Energy solar Buildings\""]
[null,null,null,"Created by: Eurac Research within subtask A"]
[]
[]
["Building Project - static Net ZEB evaluation"]
[]
[]
[]
["                              GENERATION/LOAD BALANCE"]
[]
[null,null,null,"kWhpe/m²y",null,"kWhpe/m²y",null,"__/m²y",null,"kgCO2eq/m²y"]
[]
[]
[null,"Generation/Load balance",null,null,null,null,"Electricity Load Match"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Thermal Load Match"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Operating costs/(m²y)"]
[]
[]
["                              ESTIMATED IMPORT/EXPORT BALANCE"]
[]
[null,null,null,"kWhpe/m²y",null,"kWhpe/m²y",null,"__/m²y",null,"kgCO2eq/m²y"]
[]
[]
[null,"Estimated Import/Export balance",null,null,null,null,"Electricity Load Match"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Thermal Load Match"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Operating costs/(m²y)"]
[]
[]
["                              MONITORED IMPORT/EXPORT BALANCE"]
[]
[null,null,null,"kWhpe/m²y",null,"kWhpe/m²y",null,"__/m²y",null,"kgCO2eq/m²y"]
[]
[]
[null,"Monitored Import/Export balance",null,null,null,null,"Electricity Load Match"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Thermal Load Match"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Operating costs/(m²y)"]

{"sheet":"Calculation","index":6,"n_rows":170,"n_cols":60,"rows_kept":170,"cut":false,"hidden":true,"merged":[[146,13,146,14],[147,13,147,14],[19,7,19,8],[13,13,13,14],[14,13,14,14],[15,13,15,14],[16,13,16,14],[19,13,20,17],[122,1,122,5],[122,6,122,9],[120,13,120,14],[121,13,121,14],[122,13,122,14],[117,1,117,5],[117,6,117,9],[13,7,13,8],[14,7,14,8],[15,7,15,8],[17,1,21,1],[17,7,17,8],[18,7,18,8],[21,14,21,15],[21,16,21,17],[21,13,22,13],[0,3,1,15],[2,3,2,15],[3,3,3,15],[4,3,4,15],[12,27,12,28],[10,23,10,24],[10,25,10,26],[12,23,12,24],[12,21,12,22],[12,25,12,26],[6,0,6,17],[11,7,11,8],[12,7,12,8],[11,1,16,1],[16,7,16,8],[10,13,10,17],[86,13,86,14],[83,13,83,14],[80,13,80,17],[48,23,48,24],[32,13,32,17],[35,13,35,14],[47,1,51,1],[47,7,47,8],[2,0,4,2],[48,25,48,26],[49,13,49,14],[50,13,50,14],[51,13,51,14],[46,13,46,17],[52,1,55,1],[82,27,82,28],[52,13,52,14],[80,23,80,24],[80,25,80,26],[81,1,85,1],[81,7,81,8],[57,13,57,17],[60,13,60,14],[61,13,61,14],[62,13,62,14],[63,13,63,14],[84,13,84,14],[85,13,85,14],[163,1,163,5],[163,6,163,9],[158,1,158,5],[158,6,158,9],[86,1,89,1],[142,1,142,5],[142,6,142,9],[112,0,112,18],[119,13,119,14],[144,13,144,14],[163,13,163,14],[157,13,157,18],[141,13,141,18],[116,13,116,18],[160,13,160,14],[161,13,161,14],[162,13,162,14],[91,13,91,17],[95,13,95,14],[96,13,96,14],[97,13,97,14],[147,1,147,5],[147,6,147,9],[145,13,145,14],[8,37,9,37],[93,21,93,22],[93,23,93,24],[93,25,93,26],[93,27,93,28],[94,13,94,14],[34,21,34,22],[34,23,34,24],[34,25,34,26],[34,27,34,28],[59,21,59,22],[59,23,59,24],[59,25,59,26],[59,27,59,28],[82,21,82,22],[82,23,82,24],[82,25,82,26],[48,27,48,28],[46,23,46,24],[46,25,46,26],[36,13,36,14],[37,13,37,14],[38,13,38,14],[48,21,48,22],[8,47,9,47],[8,48,9,48],[8,49,9,49],[8,50,9,50],[8,51,9,51],[8,52,9,52],[8,53,9,53],[8,38,9,38],[8,39,9,39],[8,40,9,40],[8,41,9,41],[8,42,9,42],[8,43,9,43]]}
[null,null,null,"Net ZEB definitions Evaluation Tool"]
[]
[null,null,null,"Developed within the IEA - SHC Task 40/ECBCS Annex 126 - \"Towards Net Zero Energy solar Buildings\""]
[null,null,null,"Created by: Eurac Research within STA"]
[null,null,null,"Draft: V4.3",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,10]
[]
["Building Project - Balance calculation",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,"sources"]
[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,"Wi [kWhpe/kWhi]","i1","i2","i3","i4","i5","i6",null,null,null,"Wi [kWhpe/kWhi]","i1","i2","i3","i4","i5","i6",null,null,null,null,"Denmark","The Danish Building  Code 2010, BR 2010"]
["BUILDING DESIGN",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,"Symmetric primary energy factors","electricity ","oil ","gas ","biomass ","heat from/to district heating ","cold from/to district cooling ",null,null,null,"Symmetric emission factors","electricity ","oil ","gas ","biomass ","heat from/to district heating ","cold from/to district cooling ",null,null,null,null,"Austria","Database of GEMIS, Global Emission Model for Integrated Systems, internet page of the program: http://www.oeko.de/service/gemis/en/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x = load/demand",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,"Norway","NS 3700 (2010) Criteria for passive houses and low energy buildings - residential buildings, Standards Norway."]
[null,"Weighted Supply items",null,"Primary energy","Strategic factor","Emission",null,"Weighted Demand items",null,"Primary energy","Strategic factor","Emission",null,"Generation/load balance (yearly data)",null,null,null,null,null,null,null,null,"y = generation/supply",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AUSTRIA",1.91,1.1299999999999999,1.1200000000000001,1.1599999999999999,0.77,null,"GEMIS Version 4.5",null,null,"AUSTRIA",0.38900000000000001,0.30199999999999999,0.26800000000000002,4.1000000000000002E-2,0.219,null,"GEMIS Version 4.5",null,null,null,null,"SINTEF Energy Research (2011) CO2 emissions in different scnarios of electricity generation in Europa, Report for the Zero Emission Building research centre, TR A7058."]
[null,"on-site","PV",{"$f":"'Building Data'!E21*'static weighting factors'!C13","v":0},{"$f":"SUMPRODUCT('Building Data'!E21:K21,'static weighting factors'!E22:K22)","v":0},{"$f":"SUMPRODUCT('Building Data'!E21:K21,'static weighting factors'!E45:K45)","v":0},null,"heating ",null,{"$f":"SUMPRODUCT('Building Data'!E37:K37,'static weighting factors'!$C$13:$I$13)","v":0},{"$f":"SUMPRODUCT('Building Data'!E37:K37,'static weighting factors'!$E$36:$K$36)","v":0},{"$f":"SUMPRODUCT('Building Data'!E37:K37,'static weighting factors'!$E$59:$K$59)","v":0},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,"DENMARK",2.5,1,1,1,1,null,"BR 2010",null,null,"DENMARK",null,null,null,null,null,null,null,null,null,null,"Sweden","http://www.sweden.gov.se/content/1/c6/10/01/76/9e6cf104.pdf, download, 27.7.2011"]
[null,null,"cogeneration",{"$f":"'Building Data'!E22*'static weighting factors'!C13+'Building Data'!F22*'static weighting factors'!H13+'Building Data'!G22*'static weighting factors'!I13","v":0},{"$f":"SUMPRODUCT('Building Data'!E22:K22,'static weighting factors'!E23:K23)","v":0},{"$f":"SUMPRODUCT('Building Data'!E22:K22,'static weighting factors'!E46:K46)","v":0},null,"DHW ",null,{"$f":"SUMPRODUCT('Building Data'!E38:K38,'static weighting factors'!$C$13:$I$13)","v":0},{"$f":"SUMPRODUCT('Building Data'!E38:K38,'static weighting factors'!$E$36:$K$36)","v":0},{"$f":"SUMPRODUCT('Building Data'!E38:K38,'static weighting factors'!$E$59:$K$59)","v":0},null,null,null,"Generation","Load","Balance",null,null,null,"Net ZEB limited",null,"Net ZEB primary",null,"Net ZEB strategic",null,"Net ZEB carbon",null,null,null,null,null,null,null,null,null,"FINLAND",1.7,1,1,0.5,0.7,null,"BC 2012",null,null,"FINLAND",0.32900000000000001,0.27900000000000003,0.20200000000000001,3.2000000000000001E-2,0.23,null,"BC 2012",null,null,null,"Finland","National Building Code of Finland. Part D3 Energy-Efficiency. Ministry of Environment 2011"]
[null,null,"solar thermal",{"$f":"'Building Data'!F23*'static weighting factors'!G13","v":0},{"$f":"SUMPRODUCT('Building Data'!E23:K23,'static weighting factors'!E24:K24)","v":0},{"$f":"SUMPRODUCT('Building Data'!E23:K23,'static weighting factors'!E47:K47)","v":0},null,"cooling",null,{"$f":"SUMPRODUCT('Building Data'!E39:K39,'static weighting factors'!$C$13:$I$13)","v":0},{"$f":"SUMPRODUCT('Building Data'!E39:K39,'static weighting factors'!$E$36:$K$36)","v":0},{"$f":"SUMPRODUCT('Building Data'!E39:K39,'static weighting factors'!$E$59:$K$59)","v":0},null,"Net ZEB limited",null,{"$f":"IF(D17=0,SUM(D12:D16),D17)","v":0},{"$f":"IF(AND(J21=0,'Building Data'!S10=1),SUM(Calculation!J12:J14,Calculation!J16:J17,Calculation!J19),IF(AND(J21=0,'Building Data'!S10=2),SUM(Calculation!J12:J17,Calculation!J19),Calculation!J21))","v":0},{"$f":"P14-Q14","v":0},null,null,null,"x","y","x","y","x","y","x","y",null,null,null,null,null,null,null,null,"GERMANY",2.6,1.1000000000000001,1.1000000000000001,0.2,0.7,null,"DIN V 18599/1",null,null,"GERMANY",0.63300000000000001,0.30199999999999999,0.24399999999999999,4.1000000000000002E-2,0.219,null,"DIN V 18599/1",null,null,null,null,"Database of GEMIS, Global Emission Model for Integrated Systems, internet page of the program: http://www.oeko.de/service/gemis/en/"]
[null,null,"add",{"$f":"'Building Data'!E24*'static weighting factors'!C13+'Building Data'!F24*'static weighting factors'!G13+'Building Data'!G24*'static weighting factors'!H13+SUMPRODUCT('Building Data'!H24:K24,'static weighting factors'!J13:M13)","v":0},{"$f":"SUMPRODUCT('Building Data'!E24:K24,'static weighting factors'!E25:K25)","v":0},{"$f":"SUMPRODUCT('Building Data'!E24:K24,'static weighting factors'!E48:K48)","v":0},null,"built-in lighting",null,{"$f":"SUMPRODUCT('Building Data'!E40:K40,'static weighting factors'!$C$13:$I$13)","v":0},{"$f":"SUMPRODUCT('Building Data'!E40:K40,'static weighting factors'!$E$36:$K$36)","v":0},{"$f":"SUMPRODUCT('Building Data'!E40:K40,'static weighting factors'!$E$59:$K$59)","v":0},null,"Net ZEB primary",null,{"$f":"IF(D17=0,SUM(D12:D16),D17)","v":0},{"$f":"IF(J21=0,SUM(J12:J20),J21)","v":0},{"$f":"P15-Q15","v":0},null,null,"WD",{"$f":"Q14","v":0},0,{"$f":"Q15","v":0},0,{"$f":"Q16","v":0},0,{"$f":"Q17","v":0},0,null,"bisector",0,0,null,null,null,null,"ITALY",2.1800000000000002,1,1,0,null,null,"UNI TS 11300/4",null,null,"ITALY",0.53100000000000003,null,null,null,null,null,"UNI TS 11300/4",null,null,null,null,"Motiva report, 2004, emission factors and calculation of emission factors. Available at: http://www.motiva.fi/files/209/Laskentaohje_CO2_kohde_040622.pdf"]
[null,null,"add",{"$f":"'Building Data'!E25*'static weighting factors'!$C$13+'Building Data'!F25*'static weighting factors'!$G$13+'Building Data'!G25*'static weighting factors'!$H$13+SUMPRODUCT('Building Data'!H25:K25,'static weighting factors'!J13:M13)","v":0},{"$f":"SUMPRODUCT('Building Data'!E25:K25,'static weighting factors'!E26:K26)","v":0},{"$f":"SUMPRODUCT('Building Data'!E25:K25,'static weighting factors'!E49:K49)","v":0},null,"auxiliaries",null,{"$f":"SUMPRODUCT('Building Data'!E41:K41,'static weighting factors'!$C$13:$I$13)","v":0},{"$f":"SUMPRODUCT('Building Data'!E41:K41,'static weighting factors'!$E$36:$K$36)","v":0},{"$f":"SUMPRODUCT('Building Data'!E41:K41,'static weighting factors'!$E$59:$K$59)","v":0},null,"Net ZEB strategic",null,{"$f":"IF(SUM(E17,E22)=0,SUM(E12:E16,E18:E21),SUM(E17,E22))","v":0},{"$f":"IF(K21=0,SUM(K12:K20),K21)","v":0},0,null,null,"WS",0,{"$f":"P14","v":0},0,{"$f":"P15","v":0},0,{"$f":"P16","v":0},0,{"$f":"P17","v":0},null,null,{"$f":"MAX(V17:AC17)","v":0},{"$f":"AF16","v":0},null,null,null,null,"NORWAY",null,null,null,null,null,null,"under development, will be soon available",null,null,"NORWAY",null,null,null,null,null,null,"under development, will be soon available",null,null,null,"Germany","DIN V 18599:2007-02, part 10, Beuth-Verlag, Berlin, 2009"]
[null,null,"TOTAL",{"$f":"'Building Data'!E26*'static weighting factors'!$C$13+SUMPRODUCT('Building Data'!F26:G26,'static weighting factors'!$G$13:$H$13)+SUMPRODUCT('Building Data'!H26:K26,'static weighting factors'!$J$13:$M$13)","v":0},{"$f":"'Building Data'!E26*Calculation!O24+'Building Data'!F26*Calculation!O25+'Building Data'!G26*Calculation!O26+'Building Data'!H26*Calculation!O27+'Building Data'!I26*Calculation!O28+'Building Data'!J26*Calculation!O29+'Building Data'!K26*Calculation!O30","v":0},{"$f":"'Building Data'!E26*Calculation!Q24+'Building Data'!F26*Calculation!Q25+'Building Data'!G26*Calculation!Q26+'Building Data'!H26*Calculation!Q27+'Building Data'!I26*Calculation!Q28+'Building Data'!J26*Calculation!Q29+'Building Data'!K26*Calculation!Q30","v":0},null,"ventilation",null,{"$f":"SUMPRODUCT('Building Data'!E42:K42,'static weighting factors'!$C$13:$I$13)","v":0},{"$f":"SUMPRODUCT('Building Data'!E42:K42,'static weighting factors'!$E$36:$K$36)","v":0},{"$f":"SUMPRODUCT('Building Data'!E42:K42,'static weighting factors'!$E$59:$K$59)","v":0},null,"Net ZEB carbon",null,{"$f":"IF(F17=0,SUM(F12:F16),F17)","v":0},{"$f":"IF(L21=0,SUM(L12:L20),L21)","v":0},0,null,null,"Balance",{"$f":"V15","v":0},{"$f":"W16","v":0},{"$f":"X15","v":0},{"$f":"Y16","v":0},{"$f":"Z15","v":0},{"$f":"AA16","v":0},{"$f":"AB15","v":0},{"$f":"AC16","v":0},null,null,null,null,null,null,null,null,"SPAIN",2.6,1.08,1.1000000000000001,0,null,null,"CALENER",null,null,"SPAIN",0.64900000000000002,0.28699999999999998,0.20399999999999999,null,null,null,"CALENER",null,null,null,null,"Database of GEMIS, Global Emission Model for Integrated Systems, internet page of the program: http://www.oeko.de/service/gemis/en/"]
[null,"off-site","PV",{"$f":"'Building Data'!E27*'static weighting factors'!C13","v":0},{"$f":"SUMPRODUCT('Building Data'!E27:K27,'static weighting factors'!E27:K27)","v":0},{"$f":"SUMPRODUCT('Building Data'!E27:K27,'static weighting factors'!E50:K50)","v":0},null,"plug loads",null,{"$f":"SUMPRODUCT('Building Data'!E43:K43,'static weighting factors'!$C$13:$I$13)","v":0},{"$f":"SUMPRODUCT('Building Data'!E43:K43,'static weighting factors'!$E$36:$K$36)","v":0},{"$f":"SUMPRODUCT('Building Data'!E43:K43,'static weighting factors'!$E$59:$K$59)","v":0},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,"SWEDEN",1.5,null,1.2,1.2,0.9,null,"calcualted according to EN15316. ","For electricity, calculations are based on Nordic electricity",null,"SWEDEN",null,null,null,null,null,null,"calcualted according to EN15316. ",null,null,null,"Italy","UNI-TS 11300 Part IV,under review (last draft 2009)-LA NORMATIVA TECNICA DI RIFERIMENTO SUL RISPARMIO ENERGETICO E LA CERTIFICAZIONE ENERGETICA DEGLI EDIFICI\n"]
[null,null,"wind turbine",{"$f":"'Building Data'!E28*'static weighting factors'!C13","v":0},{"$f":"SUMPRODUCT('Building Data'!E28:K28,'static weighting factors'!E28:K28)","v":0},{"$f":"SUMPRODUCT('Building Data'!E28:K28,'static weighting factors'!E51:K51)","v":0},null,"combined h & p",null,{"$f":"SUMPRODUCT('Building Data'!E44:K44,'static weighting factors'!$C$13:$I$13)","v":0},{"$f":"SUMPRODUCT('Building Data'!E44:K44,'static weighting factors'!$E$36:$K$36)","v":0},{"$f":"SUMPRODUCT('Building Data'!E44:K44,'static weighting factors'!$E$59:$K$59)","v":0},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,"SWITZERLAND",2.97,1.24,1.1499999999999999,1.22,0.8,null,"SIA 2031",null,null,"SWITZERLAND",0.154,0.29499999999999998,0.24099999999999999,3.5999999999999997E-2,0.16200000000000001,null,"SIA 2031",null,null,null,null,"* EEN3/08 resolution by AEEG - GU n. 100, 29.4.08 - SO n.107 - www.http://www.autorita.energia.it/it/docs/08/003-08een.htm"]
[null,null,"add",{"$f":"'Building Data'!E29*'static weighting factors'!$C$13+'Building Data'!F29*'static weighting factors'!$G$13+'Building Data'!G29*'static weighting factors'!$H$13+SUMPRODUCT('Building Data'!H29:K29,'static weighting factors'!$J$13:$M$13)","v":0},{"$f":"SUMPRODUCT('Building Data'!E29:K29,'static weighting factors'!E29:K29)","v":0},{"$f":"SUMPRODUCT('Building Data'!E30:K30,'static weighting factors'!E53:K53)","v":0},null,"other",null,{"$f":"SUMPRODUCT('Building Data'!E45:K45,'static weighting factors'!$C$13:$I$13)","v":0},{"$f":"SUMPRODUCT('Building Data'!E45:K45,'static weighting factors'!$E$36:$K$36)","v":0},{"$f":"SUMPRODUCT('Building Data'!E45:K45,'static weighting factors'!$E$59:$K$59)","v":0},null,"Average values of asymmetric weighting factors for energy generation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER",null,null,null,null,null,null,null,null,null,"OTHER",null,null,null,null,null,null,null,null,null,null,null,"**www.minambiente.it/home_it/menu.html?mp=/menu/menu_attivita/&m=argomenti.html|Fonti_rinnovabili.html|Fotovoltaico.html|Costi__Vantaggi__e_Mercato.html"]
[null,null,"add",{"$f":"'Building Data'!E30*'static weighting factors'!$C$13+'Building Data'!F30*'static weighting factors'!$G$13+'Building Data'!G30*'static weighting factors'!$H$13+SUMPRODUCT('Building Data'!H30:K30,'static weighting factors'!$J$13:$M$13)","v":0},{"$f":"SUMPRODUCT('Building Data'!E30:K30,'static weighting factors'!E30:K30)","v":0},{"$f":"SUMPRODUCT('Building Data'!E31:K31,'static weighting factors'!E54:K54)","v":0},null,null,"TOTAL",{"$f":"SUMPRODUCT('Building Data'!E46:K46,'static weighting factors'!$C$13:$I$13)","v":0},{"$f":"SUMPRODUCT('Building Data'!E46:K46,'static weighting factors'!$E$36:$K$36)","v":0},{"$f":"SUMPRODUCT('Building Data'!E46:K46,'static weighting factors'!$E$59:$K$59)","v":0},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,"Switzerland","SIA 2031 „Energieausweis für Gebäude“, SIA 2040 „Effizienzpfad Energie“, Schweizer Ingenieur- und Architektenverein, 2009"]
[null,null,"TOTAL",{"$f":"'Building Data'!E31*'static weighting factors'!C13+SUMPRODUCT('Building Data'!F31:G31,'static weighting factors'!H13:I13)+SUMPRODUCT('Building Data'!H31:K31,'static weighting factors'!J13:M13)","v":0},{"$f":"'Building Data'!E31*Calculation!P24+'Building Data'!F31*Calculation!P25+'Building Data'!G31*Calculation!P26+'Building Data'!H31*Calculation!P27+'Building Data'!I31*Calculation!P28+'Building Data'!J31*Calculation!P29+'Building Data'!K31*Calculation!P30","v":0},{"$f":"'Building Data'!E31*Calculation!R24+'Building Data'!F31*Calculation!R25+'Building Data'!G31*Calculation!R26+'Building Data'!H31*Calculation!R27+'Building Data'!I31*Calculation!R28+'Building Data'!J31*Calculation!R29+'Building Data'!K31*Calculation!R30","v":0},null,null,null,null,null,null,null,"energy carrier","Avg strategic factors",null,"Avg emission factors",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,"Gebäudeenergieausweise der Kantone – Nationale Gewichtungsfaktoren, EnDK, Bundesamt für Energie, 2009"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"on site","off site","on site","off site"]
[null,"Load Match Index / Generation-Load",null,null,null,null,null,null,null,null,null,null,null,"i1",{"$f":"IF(SUM('static weighting factors'!E22:E26)>0,AVERAGE('static weighting factors'!E22:E28),)","v":0},{"$f":"IF(SUM('static weighting factors'!E27:E30)>0, AVERAGE('static weighting factors'!E27:E30),)","v":0},{"$f":"IF(SUM('static weighting factors'!E45:E49)>0,AVERAGE('static weighting factors'!E45:E49),)","v":0},{"$f":"IF(SUM('static weighting factors'!E50:E53)>0,AVERAGE('static weighting factors'!E50:E53),)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"i5",{"$f":"IF(SUM('static weighting factors'!F22:F26)>0,AVERAGE('static weighting factors'!F22:F28),)","v":0},{"$f":"IF(SUM('static weighting factors'!F27:F30)>0, AVERAGE('static weighting factors'!F27:F30),)","v":0},{"$f":"IF(SUM('static weighting factors'!F45:F49)>0,AVERAGE('static weighting factors'!F45:F49),)","v":0},{"$f":"IF(SUM('static weighting factors'!F50:F53)>0,AVERAGE('static weighting factors'!F50:F53),)","v":0}]
[null,"Electricity load match",null,null,null,null,null,"Thermal load match",null,null,null,null,null,"i6",{"$f":"IF(SUM('static weighting factors'!G22:G26)>0,AVERAGE('static weighting factors'!G22:G28),)","v":0},{"$f":"IF(SUM('static weighting factors'!G27:G30)>0, AVERAGE('static weighting factors'!G27:G30),)","v":0},{"$f":"IF(SUM('static weighting factors'!G45:G49)>0,AVERAGE('static weighting factors'!G45:G49),)","v":0},{"$f":"IF(SUM('static weighting factors'!G50:G53)>0,AVERAGE('static weighting factors'!G50:G53),)","v":0}]
[null,"Month","Load ","Generation",null,"Load matching",null,"Month","Load ","Generation",null,"Load matching",null,"i8",{"$f":"IF(SUM('static weighting factors'!H22:H26)>0,AVERAGE('static weighting factors'!H22:H28),)","v":0},{"$f":"IF(SUM('static weighting factors'!H27:H30)>0, AVERAGE('static weighting factors'!H27:H30),)","v":0},{"$f":"IF(SUM('static weighting factors'!H45:H49)>0,AVERAGE('static weighting factors'!H45:H49),)","v":0},{"$f":"IF(SUM('static weighting factors'!H50:H53)>0,AVERAGE('static weighting factors'!H50:H53),)","v":0}]
[null,1,{"$f":"'Building Data'!D52","v":0},{"$f":"'Building Data'!D51","v":0},null,{"$f":"IF(C28,MIN(1,D28/C28),\"\")","v":""},null,1,{"$f":"'Building Data'!D58","v":0},{"$f":"'Building Data'!D57","v":0},null,{"$f":"IF(I28,MIN(1,J28/I28),\"\")","v":""},null,"i9",{"$f":"IF(SUM('static weighting factors'!I22:I26)>0,AVERAGE('static weighting factors'!I22:I28),)","v":0},{"$f":"IF(SUM('static weighting factors'!I27:I30)>0, AVERAGE('static weighting factors'!I27:I30),)","v":0},{"$f":"IF(SUM('static weighting factors'!I45:I49)>0,AVERAGE('static weighting factors'!I45:I49),)","v":0},{"$f":"IF(SUM('static weighting factors'!I50:I53)>0,AVERAGE('static weighting factors'!I50:I53),)","v":0}]
[null,{"$f":"B28+1","v":2},{"$f":"'Building Data'!E52","v":0},{"$f":"'Building Data'!E51","v":0},null,{"$f":"IF(C29,MIN(1,D29/C29),\"\")","v":""},null,{"$f":"H28+1","v":2},{"$f":"'Building Data'!E58","v":0},{"$f":"'Building Data'!E57","v":0},null,{"$f":"IF(I29,MIN(1,J29/I29),\"\")","v":""},null,"i10",{"$f":"IF(SUM('static weighting factors'!J22:J26)>0,AVERAGE('static weighting factors'!J22:J28),)","v":0},{"$f":"IF(SUM('static weighting factors'!J27:J30)>0, AVERAGE('static weighting factors'!J27:J30),)","v":0},{"$f":"IF(SUM('static weighting factors'!J45:J49)>0,AVERAGE('static weighting factors'!J45:J49),)","v":0},{"$f":"IF(SUM('static weighting factors'!J50:J53)>0,AVERAGE('static weighting factors'!J50:J53),)","v":0}]
[null,{"$f":"B29+1","v":3},{"$f":"'Building Data'!F52","v":0},{"$f":"'Building Data'!F51","v":0},null,"",null,{"$f":"H29+1","v":3},{"$f":"'Building Data'!F58","v":0},{"$f":"'Building Data'!F57","v":0},null,"",null,"i11",{"$f":"IF(SUM('static weighting factors'!K22:K26)>0,AVERAGE('static weighting factors'!K22:K28),)","v":0},{"$f":"IF(SUM('static weighting factors'!K27:K30)>0, AVERAGE('static weighting factors'!K27:K30),)","v":0},{"$f":"IF(SUM('static weighting factors'!K45:K49)>0,AVERAGE('static weighting factors'!K45:K49),)","v":0},{"$f":"IF(SUM('static weighting factors'!K50:K53)>0,AVERAGE('static weighting factors'!K50:K53),)","v":0}]
[null,4,{"$f":"'Building Data'!G52","v":0},{"$f":"'Building Data'!G51","v":0},null,"",null,4,{"$f":"'Building Data'!G58","v":0},{"$f":"'Building Data'!G57","v":0},null,""]
[null,5,{"$f":"'Building Data'!H52","v":0},{"$f":"'Building Data'!H51","v":0},null,"",null,5,{"$f":"'Building Data'!H58","v":0},{"$f":"'Building Data'!H57","v":0},null,""]
[null,6,{"$f":"'Building Data'!I52","v":0},{"$f":"'Building Data'!I51","v":0},null,"",null,6,{"$f":"'Building Data'!I58","v":0},{"$f":"'Building Data'!I57","v":0},null,"",null,"Generation/load balance (monthly data)"]
[null,7,{"$f":"'Building Data'!J52","v":0},{"$f":"'Building Data'!J51","v":0},null,"",null,7,{"$f":"'Building Data'!J58","v":0},{"$f":"'Building Data'!J57","v":0},null,{"$f":"IF(I34,MIN(1,J34/I34),\"\")","v":""}]
[null,8,{"$f":"'Building Data'!K52","v":0},{"$f":"'Building Data'!K51","v":0},null,"",null,8,{"$f":"'Building Data'!K58","v":0},{"$f":"'Building Data'!K57","v":0},null,"",null,null,null,"Generation","Load","Balance",null,null,null,"Net ZEB limited",null,"Net ZEB primary",null,"Net ZEB strategic",null,"Net ZEB carbon"]
[null,9,{"$f":"'Building Data'!L52","v":0},{"$f":"'Building Data'!L51","v":0},null,"",null,9,{"$f":"'Building Data'!L58","v":0},{"$f":"'Building Data'!L57","v":0},null,"",null,"Net ZEB limited",null,{"$f":"SUMPRODUCT('Building Data'!D51:O51,'quasi-static weighting factors'!$D$12:$O$12)+SUMPRODUCT('Building Data'!D57:O57,'quasi-static weighting factors'!$D$13:$O$13)","v":0},{"$f":"('Building Data'!D52-'Building Data'!E43/12)*'quasi-static weighting factors'!D12+('Building Data'!E52-'Building Data'!E43/12)*'quasi-static weighting factors'!E12+('Building Data'!F52-'Building Data'!E43/12)*'quasi-static weighting factors'!F12+('Building Data'!G52-'Building Data'!E43/12)*'quasi-static weighting factors'!G12+('Building Data'!H52-'Building Data'!E43/12)*'quasi-static weighting factors'!H12+('Building Data'!I52-'Building Data'!E43/12)*'quasi-static weighting factors'!I12+('Building Data'!J52-'Building Data'!E43/12)*'quasi-static weighting factors'!J12+('Building Data'!K52-'Building Data'!E43/12)*'quasi-static weighting factors'!K12+('Building Data'!L52-'Building Data'!E43/12)*'quasi-static weighting factors'!L12+('Building Data'!M52-'Building Data'!E43/12)*'quasi-static weighting factors'!M12+('Building Data'!N52-'Building Data'!E43/12)*'quasi-static weighting factors'!N12+('Building Data'!O52-'Building Data'!E43/12)*'quasi-static weighting factors'!O12+SUMPRODUCT('Building Data'!D58:O58,'quasi-static weighting factors'!$D$13:$O$13)","v":0},{"$f":"P36-Q36","v":0},null,null,null,"x","y","x","y","x","y","x","y"]
[null,10,{"$f":"'Building Data'!M52","v":0},{"$f":"'Building Data'!M51","v":0},null,"",null,10,{"$f":"'Building Data'!M58","v":0},{"$f":"'Building Data'!M57","v":0},null,"",null,"Net ZEB primary",null,{"$f":"SUMPRODUCT('Building Data'!D51:O51,'quasi-static weighting factors'!$D$12:$O$12)+SUMPRODUCT('Building Data'!D57:O57,'quasi-static weighting factors'!$D$13:$O$13)","v":0},{"$f":"SUMPRODUCT('Building Data'!D52:O52,'quasi-static weighting factors'!$D$12:$O$12)+SUMPRODUCT('Building Data'!D58:O58,'quasi-static weighting factors'!$D$13:$O$13)","v":0},{"$f":"P37-Q37","v":0},null,null,"WD",{"$f":"Q36","v":0},0,{"$f":"Q37","v":0},0,{"$f":"Q38","v":0},0,{"$f":"Q39","v":0},0,null,"bisector",0,0]
[null,11,{"$f":"'Building Data'!N52","v":0},{"$f":"'Building Data'!N51","v":0},null,"",null,11,{"$f":"'Building Data'!N58","v":0},{"$f":"'Building Data'!N57","v":0},null,"",null,"Net ZEB strategic",null,{"$f":"SUMPRODUCT('Building Data'!D51:O51,'quasi-static weighting factors'!$D$20:$O$20)+SUMPRODUCT('Building Data'!D57:O57,'quasi-static weighting factors'!$D$21:$O$21)","v":0},{"$f":"SUMPRODUCT('Building Data'!D52:O52,'quasi-static weighting factors'!$D$26:$O$26)+SUMPRODUCT('Building Data'!D58:O58,'quasi-static weighting factors'!$D$27:$O$27)","v":0},0,null,null,"WS",0,{"$f":"P36","v":0},0,{"$f":"P37","v":0},0,{"$f":"P38","v":0},0,{"$f":"P39","v":0},null,null,{"$f":"MAX(V39:AC39)","v":0},{"$f":"AF38","v":0}]
[null,12,{"$f":"'Building Data'!O52","v":0},{"$f":"'Building Data'!O51","v":0},null,"",null,12,{"$f":"'Building Data'!O58","v":0},{"$f":"'Building Data'!O57","v":0},null,"",null,"Net ZEB carbon",null,{"$f":"SUMPRODUCT('Building Data'!D51:O51,'quasi-static weighting factors'!$D$34:$O$34)+SUMPRODUCT('Building Data'!D57:O57,'quasi-static weighting factors'!$D$35:$O$35)","v":0},{"$f":"SUMPRODUCT('Building Data'!D52:O52,'quasi-static weighting factors'!$D$40:$O$40)+SUMPRODUCT('Building Data'!D58:O58,'quasi-static weighting factors'!$D$41:$O$41)","v":0},0,null,null,"Balance",{"$f":"V37","v":0},{"$f":"W38","v":0},{"$f":"X37","v":0},{"$f":"Y38","v":0},{"$f":"Z37","v":0},{"$f":"AA38","v":0},{"$f":"AB37","v":0},{"$f":"AC38","v":0}]
[null,"TOTALS",{"$f":"SUM(C28:C39)","v":0},{"$f":"SUM(D28:D39)","v":0},null,{"$f":"IF(SUM(F28:F39)=0,\"\",AVERAGE(F28:F39))","v":""},null,"TOTALS",{"$f":"SUM(I28:I39)","v":0},{"$f":"SUM(J28:J39)","v":0},null,{"$f":"IF(SUM(L28:L39)=0,\"\",AVERAGE(L28:L39))","v":""}]
[null,"difference",null,{"$f":"C40-D40","v":0},null,null,null,"difference",null,{"$f":"I40-J40","v":0}]
[null,"coverage",null,{"$f":"D40/C40","v":{"$error":"#DIV/0!"}},null,null,null,"coverage",null,{"$f":"J40/I40","v":{"$error":"#DIV/0!"}}]
[]
[]
["BUILDING GRID INTERACTION"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x = delivered/demand"]
[null,"Weighted Supply items",null,"Primary energy","Strategic factor","Emission",null,"Weighted Demand items",null,"Primary energy","Strategic factor","Emission",null,"Estimated import/export balance (yearly data)",null,null,null,null,null,null,null,null,"y = generation/supply"]
[null,"on-site","PV",{"$f":"'Building Data'!E69*'static weighting factors'!$C$13","v":0},{"$f":"SUMPRODUCT('Building Data'!E69:K69,'static weighting factors'!E22:K22)","v":0},{"$f":"SUMPRODUCT('Building Data'!E69:K69,'static weighting factors'!E45:K45)","v":0},null,null,null,{"$f":"SUMPRODUCT('Building Data'!E83:K83,'static weighting factors'!$C$13:$I$13)","v":0},{"$f":"SUMPRODUCT('Building Data'!E83:K83,'static weighting factors'!$E$36:$K$36)","v":0},{"$f":"SUMPRODUCT('Building Data'!E83:K83,'static weighting factors'!$E$59:$K$59)","v":0}]
[null,null,"cogeneration",{"$f":"'Building Data'!E70*'static weighting factors'!$C$13+'Building Data'!F70*'static weighting factors'!$H$13+'Building Data'!G70*'static weighting factors'!$I$13","v":0},{"$f":"SUMPRODUCT('Building Data'!E70:K70,'static weighting factors'!E23:K23)","v":0},{"$f":"SUMPRODUCT('Building Data'!E70:K70,'static weighting factors'!E46:K46)","v":0},null,null,null,null,null,null,null,null,null,"Exported","Delivered","Balance",null,null,null,"Net ZEB limited",null,"Net ZEB primary",null,"Net ZEB strategic",null,"Net ZEB carbon"]
[null,null,"solar thermal",{"$f":"'Building Data'!F71*'static weighting factors'!$G$13","v":0},{"$f":"SUMPRODUCT('Building Data'!E71:K71,'static weighting factors'!E24:K24)","v":0},{"$f":"SUMPRODUCT('Building Data'!E71:K71,'static weighting factors'!E47:K47)","v":0},null,"Appliances",null,"Primary energy",null,null,null,"Net ZEB limited",null,{"$f":"IF(J51<>0,SUM(D48:D52),0)","v":0},{"$f":"IF(J51<>0,J48-J51,0)","v":0},{"$f":"P50-Q50","v":0},null,null,null,"x","y","x","y","x","y","x","y"]
[null,null,"add",{"$f":"'Building Data'!E72*'static weighting factors'!$C$13+'Building Data'!F72*'static weighting factors'!$G$13+'Building Data'!G72*'static weighting factors'!$H$13+SUMPRODUCT('Building Data'!H72:K72,'static weighting factors'!$J$13:$M$13)","v":0},{"$f":"SUMPRODUCT('Building Data'!E72:K72,'static weighting factors'!E25:K25)","v":0},{"$f":"SUMPRODUCT('Building Data'!E72:K72,'static weighting factors'!E48:K48)","v":0},null,null,null,{"$f":"'Building Data'!N63*'static weighting factors'!C13","v":0},null,null,null,"Net ZEB primary",null,{"$f":"SUM(D48:D52)","v":0},{"$f":"J48","v":0},{"$f":"P51-Q51","v":0},null,null,"WD",{"$f":"Q50","v":0},0,{"$f":"Q51","v":0},0,{"$f":"Q126","v":0},0,{"$f":"Q53","v":0},0,null,"bisector",0,0]
[null,null,"add",{"$f":"'Building Data'!E73*'static weighting factors'!$C$13+'Building Data'!F73*'static weighting factors'!$G$13+'Building Data'!G73*'static weighting factors'!$H$13+SUMPRODUCT('Building Data'!H73:K73,'static weighting factors'!$J$13:$M$13)","v":0},{"$f":"SUMPRODUCT('Building Data'!E73:K73,'static weighting factors'!E26:K26)","v":0},{"$f":"SUMPRODUCT('Building Data'!E73:K73,'static weighting factors'!E49:K49)","v":0},null,null,null,null,null,null,null,"Net ZEB strategic",null,{"$f":"SUM(E48:E56)","v":0},{"$f":"K48","v":0},0,null,null,"WS",0,{"$f":"P50","v":0},0,{"$f":"P51","v":0},0,{"$f":"P126","v":0},0,{"$f":"P53","v":0},null,null,{"$f":"MAX(V53:AC53)","v":0},{"$f":"AF52","v":0}]
[null,"off-site","PV",{"$f":"'Building Data'!E74*'static weighting factors'!$C$13","v":0},{"$f":"SUMPRODUCT('Building Data'!E74:K74,'static weighting factors'!E27:K27)","v":0},{"$f":"SUMPRODUCT('Building Data'!E74:K74,'static weighting factors'!E50:K50)","v":0},null,null,null,null,null,null,null,"Net ZEB carbon",null,{"$f":"SUM(F48:F52)","v":0},{"$f":"L48","v":0},0,null,null,"Balance",{"$f":"V51","v":0},{"$f":"W52","v":0},{"$f":"X51","v":0},{"$f":"Y52","v":0},{"$f":"Z51","v":0},{"$f":"AA52","v":0},{"$f":"AB51","v":0},{"$f":"AC52","v":0}]
[null,null,"wind turbine",{"$f":"'Building Data'!E75*'static weighting factors'!$C$13","v":0},{"$f":"SUMPRODUCT('Building Data'!E75:K75,'static weighting factors'!E28:K28)","v":0},{"$f":"SUMPRODUCT('Building Data'!E75:K75,'static weighting factors'!E51:K51)","v":0}]
[null,null,"add",{"$f":"'Building Data'!E76*'static weighting factors'!$C$13+'Building Data'!F76*'static weighting factors'!$G$13+'Building Data'!G76*'static weighting factors'!$H$13+SUMPRODUCT('Building Data'!H76:K76,'static weighting factors'!$J$13:$M$13)","v":0},{"$f":"SUMPRODUCT('Building Data'!E76:K76,'static weighting factors'!E29:K29)","v":0},{"$f":"SUMPRODUCT('Building Data'!E76:K76,'static weighting factors'!E52:K52)","v":0}]
[null,null,"add",{"$f":"'Building Data'!E77*'static weighting factors'!$C$13+'Building Data'!F77*'static weighting factors'!$G$13+'Building Data'!G77*'static weighting factors'!$H$13+SUMPRODUCT('Building Data'!H77:K77,'static weighting factors'!$J$13:$M$13)","v":0},{"$f":"SUMPRODUCT('Building Data'!E77:K77,'static weighting factors'!E30:K30)","v":0},{"$f":"SUMPRODUCT('Building Data'!E77:K77,'static weighting factors'!E53:K53)","v":0}]
[]
[null,"Load Match Index/ Exported-Delivered",null,null,null,null,null,null,null,null,null,null,null,"Estimated import/export balance (monthly data)"]
[]
[null,"Electricity load match",null,null,null,null,null,"Thermal load match",null,null,null,null,null,null,null,"Exported","Delivered","Balance",null,null,null,"Net ZEB limited",null,"Net ZEB primary",null,"Net ZEB strategic",null,"Net ZEB carbon"]
[null,"Month","Delivered","Exported","Generation","Load matching",null,"Month","Delivered","Exported","Generation","Load matching",null,"Net ZEB limited",null,{"$f":"SUMPRODUCT('Building Data'!D88:O88,'quasi-static weighting factors'!$D$12:$O$12)+SUMPRODUCT('Building Data'!D93:O93,'quasi-static weighting factors'!$D$13:$O$13)","v":0},{"$f":"('Building Data'!D89-'Building Data'!N63/12)*'quasi-static weighting factors'!D12+('Building Data'!E89-'Building Data'!N63/12)*'quasi-static weighting factors'!E12+('Building Data'!F89-'Building Data'!N63/12)*'quasi-static weighting factors'!F12+('Building Data'!G89-'Building Data'!N63/12)*'quasi-static weighting factors'!G12+('Building Data'!H89-'Building Data'!N63/12)*'quasi-static weighting factors'!H12+('Building Data'!I89-'Building Data'!N63/12)*'quasi-static weighting factors'!I12+('Building Data'!J89-'Building Data'!N63/12)*'quasi-static weighting factors'!J12+('Building Data'!K89-'Building Data'!N63/12)*'quasi-static weighting factors'!K12+('Building Data'!L89-'Building Data'!N63/12)*'quasi-static weighting factors'!L12+('Building Data'!M89-'Building Data'!N63/12)*'quasi-static weighting factors'!M12+('Building Data'!N89-'Building Data'!N63/12)*'quasi-static weighting factors'!N12+('Building Data'!O89-'Building Data'!N63/12)*'quasi-static weighting factors'!O12+SUMPRODUCT('Building Data'!D94:O94,'quasi-static weighting factors'!$D$13:$O$13)","v":0},{"$f":"P61-Q61","v":0},null,null,null,"x","y","x","y","x","y","x","y"]
[null,null,"kWh/m²","kWh/m²","kWh/m²",null,null,null,"kWh/m²","kWh/m²","kWh/m²",null,null,"Net ZEB primary",null,{"$f":"SUMPRODUCT('Building Data'!D88:O88,'quasi-static weighting factors'!$D$12:$O$12)+SUMPRODUCT('Building Data'!D93:O93,'quasi-static weighting factors'!$D$13:$O$13)","v":0},{"$f":"SUMPRODUCT('Building Data'!D89:O89,'quasi-static weighting factors'!$D$12:$O$12)+SUMPRODUCT('Building Data'!D94:O94,'quasi-static weighting factors'!$D$13:$O$13)","v":0},{"$f":"P62-Q62","v":0},null,null,"WD",{"$f":"Q61","v":0},0,{"$f":"Q62","v":0},0,{"$f":"Q63","v":0},0,{"$f":"Q64","v":0},0,null,"bisector",0,0]
[null,1,{"$f":"'Building Data'!D$89","v":0},{"$f":"'Building Data'!D$88","v":0},{"$f":"'Building Data'!D$90","v":0},{"$f":"IF(C63+E63-D63<>0,MIN(1,E63/(C63+E63-D63)),\"\")","v":""},null,1,{"$f":"'Building Data'!D$94","v":0},{"$f":"'Building Data'!D$93","v":0},{"$f":"'Building Data'!D$95","v":0},{"$f":"IF(I63+K63-J63<>0,MIN(1,K63/(I63+K63-J63)),\"\")","v":""},null,"Net ZEB strategic",null,{"$f":"SUMPRODUCT('Building Data'!D88:O88,'quasi-static weighting factors'!$D$20:$O$20)+SUMPRODUCT('Building Data'!D93:O93,'quasi-static weighting factors'!$D$21:$O$21)","v":0},{"$f":"SUMPRODUCT('Building Data'!D89:O89,'quasi-static weighting factors'!$D$26:$O$26)+SUMPRODUCT('Building Data'!D94:O94,'quasi-static weighting factors'!$D$27:$O$27)","v":0},{"$f":"P63-Q63","v":0},null,null,"WS",0,{"$f":"P61","v":0},0,{"$f":"P62","v":0},0,{"$f":"P63","v":0},0,{"$f":"P64","v":0},null,null,{"$f":"MAX(V64:AC64)","v":0},{"$f":"AF63","v":0}]
[null,{"$f":"B100+1","v":5},{"$f":"'Building Data'!E$89","v":0},{"$f":"'Building Data'!E$88","v":0},{"$f":"'Building Data'!E$90","v":0},{"$f":"IF(C64+E64-D64<>0,MIN(1,E64/(C64+E64-D64)),\"\")","v":""},null,{"$f":"H100+1","v":5},{"$f":"'Building Data'!E$94","v":0},{"$f":"'Building Data'!E$93","v":0},{"$f":"'Building Data'!E$95","v":0},{"$f":"IF(I64+K64-J64<>0,MIN(1,K64/(I64+K64-J64)),\"\")","v":""},null,"Net ZEB carbon",null,{"$f":"SUMPRODUCT('Building Data'!D88:O88,'quasi-static weighting factors'!$D$34:$O$34)+SUMPRODUCT('Building Data'!D93:O93,'quasi-static weighting factors'!$D$35:$O$35)","v":0},{"$f":"SUMPRODUCT('Building Data'!D89:O89,'quasi-static weighting factors'!$D$40:$O$40)+SUMPRODUCT('Building Data'!D94:O94,'quasi-static weighting factors'!$D$41:$O$41)","v":0},{"$f":"P64-Q64","v":0},null,null,"Balance",{"$f":"V62","v":0},{"$f":"W63","v":0},{"$f":"X62","v":0},{"$f":"Y63","v":0},{"$f":"Z62","v":0},{"$f":"AA63","v":0},{"$f":"AB62","v":0},{"$f":"AC63","v":0}]
[null,{"$f":"B64+1","v":6},{"$f":"'Building Data'!F$89","v":0},{"$f":"'Building Data'!F$88","v":0},{"$f":"'Building Data'!F$90","v":0},"",null,{"$f":"H64+1","v":6},{"$f":"'Building Data'!F$94","v":0},{"$f":"'Building Data'!F$93","v":0},{"$f":"'Building Data'!F$95","v":0},""]
[null,7,{"$f":"'Building Data'!G$89","v":0},{"$f":"'Building Data'!G$88","v":0},{"$f":"'Building Data'!G$90","v":0},"",null,7,{"$f":"'Building Data'!G$94","v":0},{"$f":"'Building Data'!G$93","v":0},{"$f":"'Building Data'!G$95","v":0},""]
[null,8,{"$f":"'Building Data'!H$89","v":0},{"$f":"'Building Data'!H$88","v":0},{"$f":"'Building Data'!H$90","v":0},"",null,8,{"$f":"'Building Data'!H$94","v":0},{"$f":"'Building Data'!H$93","v":0},{"$f":"'Building Data'!H$95","v":0},""]
[null,9,{"$f":"'Building Data'!I$89","v":0},{"$f":"'Building Data'!I$88","v":0},{"$f":"'Building Data'!I$90","v":0},"",null,9,{"$f":"'Building Data'!I$94","v":0},{"$f":"'Building Data'!I$93","v":0},{"$f":"'Building Data'!I$95","v":0},""]
[null,10,{"$f":"'Building Data'!J$89","v":0},{"$f":"'Building Data'!J$88","v":0},{"$f":"'Building Data'!J$90","v":0},"",null,10,{"$f":"'Building Data'!J$94","v":0},{"$f":"'Building Data'!J$93","v":0},{"$f":"'Building Data'!J$95","v":0},"",null,null,null,null,null,null,null,null,null,null,null," "]
[null,11,{"$f":"'Building Data'!K$89","v":0},{"$f":"'Building Data'!K$88","v":0},{"$f":"'Building Data'!K90","v":0},"",null,11,{"$f":"'Building Data'!K$94","v":0},{"$f":"'Building Data'!K$93","v":0},{"$f":"'Building Data'!K$95","v":0},""]
[null,12,{"$f":"'Building Data'!L$89","v":0},{"$f":"'Building Data'!L$88","v":0},{"$f":"'Building Data'!L$90","v":0},"",null,12,{"$f":"'Building Data'!L$94","v":0},{"$f":"'Building Data'!L$93","v":0},{"$f":"'Building Data'!L$95","v":0},""]
[null,13,{"$f":"'Building Data'!M$89","v":0},{"$f":"'Building Data'!M$88","v":0},{"$f":"'Building Data'!M$90","v":0},"",null,13,{"$f":"'Building Data'!M$94","v":0},{"$f":"'Building Data'!M$93","v":0},{"$f":"'Building Data'!M$95","v":0},""]
[null,14,{"$f":"'Building Data'!N$89","v":0},{"$f":"'Building Data'!N$88","v":0},{"$f":"'Building Data'!N$90","v":0},"",null,14,{"$f":"'Building Data'!N$94","v":0},{"$f":"'Building Data'!N$93","v":0},{"$f":"'Building Data'!N$95","v":0},""]
[null,15,{"$f":"'Building Data'!O$89","v":0},{"$f":"'Building Data'!O$88","v":0},{"$f":"'Building Data'!O$90","v":0},"",null,15,{"$f":"'Building Data'!O$94","v":0},{"$f":"'Building Data'!O$93","v":0},{"$f":"'Building Data'!O$95","v":0},""]
[null,"TOTALS",{"$f":"SUM(C63:C74)","v":0},{"$f":"SUM(D63:D74)","v":0},{"$f":"SUM(E63:E74)","v":0},{"$f":"IF(SUM(F63:F74)=0,\"\",AVERAGE(F63:F74))","v":""},null,"TOTALS",{"$f":"SUM(I63:I74)","v":0},{"$f":"SUM(J63:J74)","v":0},{"$f":"SUM(K63:K74)","v":0},{"$f":"IF(SUM(L63:L74)=0,\"\",AVERAGE(L63:L74))","v":""}]
[null,"difference",null,{"$f":"C75-D75","v":0},null,null,null,"difference",null,{"$f":"I75-J75","v":0}]
[null,"coverage",null,{"$f":"D75/C75","v":{"$error":"#DIV/0!"}},null,null,null,"coverage",null,{"$f":"J75/I75","v":{"$error":"#DIV/0!"}}]
[]
["BUILDING MONITORING"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x = delivered/demand"]
[null,"Weighted Supply items",null,"Primary energy","Strategic factor","Emission",null,"Weighted Demand items",null,"Primary energy","Strategic factor","Emission",null,"Monitored import/export balance (yearly data)",null,null,null,null,null,null,null,null,"y = generation/supply"]
[null,"on-site","PV",{"$f":"'Building Data'!E106*'static weighting factors'!$C$13","v":0},{"$f":"SUMPRODUCT('Building Data'!E106:K106,'static weighting factors'!E22:K22)","v":0},{"$f":"SUMPRODUCT('Building Data'!E106:K106,'static weighting factors'!E45:K45)","v":0},null,null,null,{"$f":"SUMPRODUCT('Building Data'!E120:K120,'static weighting factors'!$C$13:$I$13)","v":0},{"$f":"SUMPRODUCT('Building Data'!E120:K120,'static weighting factors'!$E$36:$K$36)","v":0},{"$f":"SUMPRODUCT('Building Data'!E120:K120,'static weighting factors'!$E$59:$K$59)","v":0}]
[null,null,"cogeneration",{"$f":"'Building Data'!E107*'static weighting factors'!$C$13+'Building Data'!F107*'static weighting factors'!$H$13+'Building Data'!G107*'static weighting factors'!$I$13","v":0},{"$f":"SUMPRODUCT('Building Data'!E107:K107,'static weighting factors'!E23:K23)","v":0},{"$f":"SUMPRODUCT('Building Data'!E107:K107,'static weighting factors'!E46:K46)","v":0},null,null,null,null,null,null,null,null,null,"Exported","Delivered","Balance",null,null,null,"Net ZEB limited",null,"Net ZEB primary",null,"Net ZEB strategic",null,"Net ZEB carbon"]
[null,null,"solar thermal",{"$f":"'Building Data'!F108*'static weighting factors'!$H$13","v":0},{"$f":"SUMPRODUCT('Building Data'!E108:K108,'static weighting factors'!E24:K24)","v":0},{"$f":"SUMPRODUCT('Building Data'!E108:K108,'static weighting factors'!E47:K47)","v":0},null,"Appliances",null,"Primary energy",null,null,null,"Net ZEB limited",null,{"$f":"IF(J85<>0,SUM(D82:D86),0)","v":0},{"$f":"IF(J85<>0,J82-J85,0)","v":0},{"$f":"P84-Q84","v":0},null,null,null,"x","y","x","y","x","y","x","y"]
[null,null,"add",{"$f":"'Building Data'!E109*'static weighting factors'!$C$13+'Building Data'!F109*'static weighting factors'!$H$13+'Building Data'!G109*'static weighting factors'!$I$13+SUMPRODUCT('Building Data'!H109:K109,'static weighting factors'!$K$13:$N$13)","v":0},{"$f":"SUMPRODUCT('Building Data'!E109:K109,'static weighting factors'!E25:K25)","v":0},{"$f":"SUMPRODUCT('Building Data'!E109:K109,'static weighting factors'!E48:K48)","v":0},null,null,null,{"$f":"'Building Data'!N100*'static weighting factors'!C13","v":0},null,null,null,"Net ZEB primary",null,{"$f":"SUM(D82:D86)","v":0},{"$f":"J82","v":0},{"$f":"P85-Q85","v":0},null,null,"WD",{"$f":"Q84","v":0},0,{"$f":"Q85","v":0},0,{"$f":"Q86","v":0},0,{"$f":"Q87","v":0},0,null,"bisector",0,0]
[null,null,"add",{"$f":"'Building Data'!E110*'static weighting factors'!$C$13+'Building Data'!F110*'static weighting factors'!$H$13+'Building Data'!G110*'static weighting factors'!$I$13+SUMPRODUCT('Building Data'!H110:K110,'static weighting factors'!$K$13:$N$13)","v":0},{"$f":"SUMPRODUCT('Building Data'!E110:K110,'static weighting factors'!E26:K26)","v":0},{"$f":"SUMPRODUCT('Building Data'!E110:K110,'static weighting factors'!E49:K49)","v":0},null,null,null,null,null,null,null,"Net ZEB strategic",null,{"$f":"SUM(E82:E90)","v":0},{"$f":"K82","v":0},{"$f":"P86-Q86","v":0},null,null,"WS",0,{"$f":"P84","v":0},0,{"$f":"P85","v":0},0,{"$f":"P86","v":0},0,{"$f":"P87","v":0},null,null,{"$f":"MAX(V87:AC87)","v":0},{"$f":"AF86","v":0}]
[null,"off-site","PV",{"$f":"'Building Data'!E111*'static weighting factors'!$C$13","v":0},{"$f":"SUMPRODUCT('Building Data'!E111:K111,'static weighting factors'!E27:K27)","v":0},{"$f":"SUMPRODUCT('Building Data'!E111:K111,'static weighting factors'!E50:K50)","v":0},null,null,null,null,null,null,null,"Net ZEB carbon",null,{"$f":"SUM(F82:F90)","v":0},{"$f":"L82","v":0},{"$f":"P87-Q87","v":0},null,null,"Balance",{"$f":"V85","v":0},{"$f":"W86","v":0},{"$f":"X85","v":0},{"$f":"Y86","v":0},{"$f":"Z85","v":0},{"$f":"AA86","v":0},{"$f":"AB85","v":0},{"$f":"AC86","v":0}]
[null,null,"wind turbine",{"$f":"'Building Data'!E112*'static weighting factors'!$C$13","v":0},{"$f":"SUMPRODUCT('Building Data'!E112:K112,'static weighting factors'!E28:K28)","v":0},{"$f":"SUMPRODUCT('Building Data'!E112:K112,'static weighting factors'!E51:K51)","v":0}]
[null,null,"add",{"$f":"'Building Data'!E113*'static weighting factors'!$C$13+'Building Data'!F113*'static weighting factors'!$H$13+'Building Data'!G113*'static weighting factors'!$I$13+SUMPRODUCT('Building Data'!H113:K113,'static weighting factors'!$K$13:$N$13)","v":0},{"$f":"SUMPRODUCT('Building Data'!E113:K113,'static weighting factors'!E29:K29)","v":0},{"$f":"SUMPRODUCT('Building Data'!E113:K113,'static weighting factors'!E52:K52)","v":0}]
[null,null,"add",{"$f":"'Building Data'!E114*'static weighting factors'!$C$13+'Building Data'!F114*'static weighting factors'!$H$13+'Building Data'!G114*'static weighting factors'!$I$13+SUMPRODUCT('Building Data'!H114:K114,'static weighting factors'!$K$13:$N$13)","v":0},{"$f":"SUMPRODUCT('Building Data'!E114:K114,'static weighting factors'!E30:K30)","v":0},{"$f":"SUMPRODUCT('Building Data'!E114:K114,'static weighting factors'!E53:K53)","v":0}]
[]
[null,"Load Match Index/ Exported-Delivered",null,null,null,null,null,null,null,null,null,null,null,"Monitored import/export balance (monthly data)"]
[]
[null,"Electricity load match",null,null,null,null,null,"Thermal load match",null,null,null,null,null,null,null,"Exported","Delivered","Balance",null,null,null,"Net ZEB limited",null,"Net ZEB primary",null,"Net ZEB strategic",null,"Net ZEB carbon"]
[null,"Month","Delivered","Exported","Generation","Load matching",null,"Month","Delivered","Exported","Generation","Load matching",null,"Net ZEB limited",null,{"$f":"SUMPRODUCT('Building Data'!D125:O125,'quasi-static weighting factors'!$D$12:$O$12)+SUMPRODUCT('Building Data'!D130:O130,'quasi-static weighting factors'!$D$13:$O$13)","v":0},{"$f":"('Building Data'!D126-'Building Data'!E43/12)*'quasi-static weighting factors'!D12+('Building Data'!E126-'Building Data'!E43/12)*'quasi-static weighting factors'!E12+('Building Data'!F126-'Building Data'!E43/12)*'quasi-static weighting factors'!F12+('Building Data'!G126-'Building Data'!E43/12)*'quasi-static weighting factors'!G12+('Building Data'!H126-'Building Data'!E43/12)*'quasi-static weighting factors'!H12+('Building Data'!I126-'Building Data'!E43/12)*'quasi-static weighting factors'!I12+('Building Data'!J126-'Building Data'!E43/12)*'quasi-static weighting factors'!J12+('Building Data'!K126-'Building Data'!E43/12)*'quasi-static weighting factors'!K12+('Building Data'!L126-'Building Data'!E43/12)*'quasi-static weighting factors'!L12+('Building Data'!M126-'Building Data'!E43/12)*'quasi-static weighting factors'!M12+('Building Data'!N126-'Building Data'!E43/12)*'quasi-static weighting factors'!N12+('Building Data'!O126-'Building Data'!E43/12)*'quasi-static weighting factors'!O12+SUMPRODUCT('Building Data'!D131:O131,'quasi-static weighting factors'!$D$13:$O$13)","v":0},{"$f":"P95-Q95","v":0},null,null,null,"x","y","x","y","x","y","x","y"]
[null,null,"kWh","kWh","kWh",null,null,null,"kWh","kWh","kWh",null,null,"Net ZEB primary",null,{"$f":"SUMPRODUCT('Building Data'!D125:O125,'quasi-static weighting factors'!$D$12:$O$12)+SUMPRODUCT('Building Data'!D130:O130,'quasi-static weighting factors'!$D$13:$O$13)","v":0},{"$f":"SUMPRODUCT('Building Data'!D126:O126,'quasi-static weighting factors'!$D$12:$O$12)+SUMPRODUCT('Building Data'!D131:O131,'quasi-static weighting factors'!$D$13:$O$13)","v":0},{"$f":"P96-Q96","v":0},null,null,"WD",{"$f":"Q95","v":0},0,{"$f":"Q96","v":0},0,{"$f":"Q97","v":0},0,{"$f":"Q98","v":0},0,null,"bisector",0,0]
[null,1,{"$f":"'Building Data'!$D$126","v":0},{"$f":"'Building Data'!$D$125","v":0},{"$f":"'Building Data'!D$127","v":0},{"$f":"IF(C97+E97-D97<>0,MIN(1,E97/(C97+E97-D97)),\"\")","v":""},null,1,{"$f":"'Building Data'!D$131","v":0},{"$f":"'Building Data'!D$130","v":0},{"$f":"'Building Data'!D$132","v":0},{"$f":"IF(I97+K97-J97,MIN(1,K97/(I97+K97-J97)),\"\")","v":""},null,"Net ZEB strategic",null,{"$f":"SUMPRODUCT('Building Data'!D125:O125,'quasi-static weighting factors'!$D$20:$O$20)+SUMPRODUCT('Building Data'!D130:O130,'quasi-static weighting factors'!$D$21:$O$21)","v":0},{"$f":"SUMPRODUCT('Building Data'!D126:O126,'quasi-static weighting factors'!$D$26:$O$26)+SUMPRODUCT('Building Data'!D131:O131,'quasi-static weighting factors'!$D$27:$O$27)","v":0},{"$f":"P97-Q97","v":0},null,null,"WS",0,{"$f":"P95","v":0},0,{"$f":"P96","v":0},0,{"$f":"P97","v":0},0,{"$f":"P98","v":0},null,null,{"$f":"MAX(V98:AC98)","v":0},{"$f":"AF97","v":0}]
[null,{"$f":"B97+1","v":2},{"$f":"'Building Data'!$E$126","v":0},{"$f":"'Building Data'!$E$125","v":0},{"$f":"'Building Data'!E$127","v":0},{"$f":"IF(C98+E98-D98<>0,MIN(1,E98/(C98+E98-D98)),\"\")","v":""},null,{"$f":"H97+1","v":2},{"$f":"'Building Data'!E$131","v":0},{"$f":"'Building Data'!E$130","v":0},{"$f":"'Building Data'!E$132","v":0},{"$f":"IF(I98+K98-J98,MIN(1,K98/(I98+K98-J98)),\"\")","v":""},null,"Net ZEB carbon",null,{"$f":"SUMPRODUCT('Building Data'!D125:O125,'quasi-static weighting factors'!$D$34:$O$34)+SUMPRODUCT('Building Data'!D130:O130,'quasi-static weighting factors'!$D$35:$O$35)","v":0},{"$f":"SUMPRODUCT('Building Data'!D126:O126,'quasi-static weighting factors'!$D$40:$O$40)+SUMPRODUCT('Building Data'!D131:O131,'quasi-static weighting factors'!$D$41:$O$41)","v":0},{"$f":"P98-Q98","v":0},null,null,"Balance",{"$f":"V96","v":0},{"$f":"W97","v":0},{"$f":"X96","v":0},{"$f":"Y97","v":0},{"$f":"Z96","v":0},{"$f":"AA97","v":0},{"$f":"AB96","v":0},{"$f":"AC97","v":0}]
[null,{"$f":"B98+1","v":3},{"$f":"'Building Data'!$F$126","v":0},{"$f":"'Building Data'!$F$125","v":0},{"$f":"'Building Data'!F$127","v":0},"",null,{"$f":"H98+1","v":3},{"$f":"'Building Data'!F$131","v":0},{"$f":"'Building Data'!F$130","v":0},{"$f":"'Building Data'!F$132","v":0},""]
[null,4,{"$f":"'Building Data'!$G$126","v":0},{"$f":"'Building Data'!$G$125","v":0},{"$f":"'Building Data'!G$127","v":0},"",null,4,{"$f":"'Building Data'!G$131","v":0},{"$f":"'Building Data'!G$130","v":0},{"$f":"'Building Data'!G$132","v":0},""]
[null,5,{"$f":"'Building Data'!$H$126","v":0},{"$f":"'Building Data'!$H$125","v":0},{"$f":"'Building Data'!H$127","v":0},"",null,5,{"$f":"'Building Data'!H$131","v":0},{"$f":"'Building Data'!H$130","v":0},{"$f":"'Building Data'!H$132","v":0},""]
[null,6,{"$f":"'Building Data'!$I$126","v":0},{"$f":"'Building Data'!$I$125","v":0},{"$f":"'Building Data'!I$127","v":0},"",null,6,{"$f":"'Building Data'!I$131","v":0},{"$f":"'Building Data'!I$130","v":0},{"$f":"'Building Data'!I$132","v":0},""]
[null,7,{"$f":"'Building Data'!$J$126","v":0},{"$f":"'Building Data'!$J$125","v":0},{"$f":"'Building Data'!J$127","v":0},"",null,7,{"$f":"'Building Data'!J$131","v":0},{"$f":"'Building Data'!J$130","v":0},{"$f":"'Building Data'!J$132","v":0},""]
[null,8,{"$f":"'Building Data'!$K$126","v":0},{"$f":"'Building Data'!$K$125","v":0},{"$f":"'Building Data'!K$127","v":0},"",null,8,{"$f":"'Building Data'!K$131","v":0},{"$f":"'Building Data'!K$130","v":0},{"$f":"'Building Data'!K$132","v":0},""]
[null,9,{"$f":"'Building Data'!$L$126","v":0},{"$f":"'Building Data'!$L$125","v":0},{"$f":"'Building Data'!L$127","v":0},"",null,9,{"$f":"'Building Data'!L$131","v":0},{"$f":"'Building Data'!L$130","v":0},{"$f":"'Building Data'!L$132","v":0},""]
[null,10,{"$f":"'Building Data'!$M$126","v":0},{"$f":"'Building Data'!$M$125","v":0},{"$f":"'Building Data'!M$127","v":0},"",null,10,{"$f":"'Building Data'!M$131","v":0},{"$f":"'Building Data'!M$130","v":0},{"$f":"'Building Data'!M$132","v":0},""]
[null,11,{"$f":"'Building Data'!$N$126","v":0},{"$f":"'Building Data'!$N$125","v":0},{"$f":"'Building Data'!N$127","v":0},"",null,11,{"$f":"'Building Data'!N$131","v":0},{"$f":"'Building Data'!N$130","v":0},{"$f":"'Building Data'!N$132","v":0},""]
[null,12,{"$f":"'Building Data'!$O$126","v":0},{"$f":"'Building Data'!$O$125","v":0},{"$f":"'Building Data'!O$127","v":0},"",null,12,{"$f":"'Building Data'!O$131","v":0},{"$f":"'Building Data'!O$130","v":0},{"$f":"'Building Data'!O$132","v":0},""]
[null,"TOTALS",{"$f":"SUM(C97:C108)","v":0},{"$f":"SUM(D97:D108)","v":0},{"$f":"SUM(E97:E108)","v":0},{"$f":"IF(SUM(F97:F108)=0,\"\",AVERAGE(F97:F108))","v":""},null,"TOTALS",{"$f":"SUM(I97:I108)","v":0},{"$f":"SUM(J97:J108)","v":0},{"$f":"SUM(K97:K108)","v":0},{"$f":"IF(SUM(L97:L108)=0,\"\",AVERAGE(L97:L108))","v":""}]
[null,"difference",null,{"$f":"C109-D109","v":0},null,null,null,"difference",null,{"$f":"I109-J109","v":0}]
[null,"coverage",null,{"$f":"D109/C109","v":{"$error":"#DIV/0!"}},null,null,null,"coverage",null,{"$f":"J109/I109","v":{"$error":"#DIV/0!"}}]
[]
["Building Project - Cost calculation"]
[]
["BUILDING DESIGN"]
[]
[null,"Cost Supply items",null,null,null,null,null,null,null,null,null,null,null,"Generation/load cost balance"]
[null,"on-site generation",null,null,null,null,"off-site generation"]
[null,"PV","cogeneration","solar thermal","enter one more generation system","enter one more generation system","PV","wind turbine","enter one more generation system","enter one more generation system",null,null,null,null,null,"Generation","Load","Incentives","Balance"]
[null,{"$f":"'Building Data'!$E$21*'Operating costs'!$E$13","v":0},{"$f":"SUMPRODUCT('Building Data'!$E$22:$G$22,'Operating costs'!$E$14:$G$14)","v":0},{"$f":"'Building Data'!F23*'Operating costs'!$F$15","v":0},{"$f":"SUMPRODUCT('Building Data'!E24:K24,'Operating costs'!$E$16:$K$16)","v":0},{"$f":"SUMPRODUCT('Building Data'!E25:K25,'Operating costs'!$E$17:$K$17)","v":0},{"$f":"'Building Data'!E27*'Operating costs'!$E$18","v":0},{"$f":"'Building Data'!E28*'Operating costs'!$E$19","v":0},{"$f":"SUMPRODUCT('Building Data'!E29:K29,'Operating costs'!$E$20:$K$20)","v":0},{"$f":"SUMPRODUCT('Building Data'!E30:K30,'Operating costs'!$E$21:$K$21)","v":0},null,null,null,"Net ZEB limited",null,{"$f":"SUM(B120:F120)","v":0},{"$f":"IF(AND(J138=0,'Building Data'!S10=1),SUM(C129:I131,C133:C134,C136),IF(AND(J138=0,'Building Data'!S10=2),SUM(C129:I131,C132:C134,C136),J138))","v":0},{"$f":"SUM(B125:F125)","v":0},{"$f":"P120-Q120+R120","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Net ZEB primary",null,{"$f":"SUM(B120:F120)","v":0},{"$f":"IF(J129=0,J138,J129)","v":0},{"$f":"SUM(B125:F125)","v":0},{"$f":"P121-Q121+R121","v":0}]
[null,"Incentives",null,null,null,null,null,null,null,null,null,null,null,"Net ZEB strategic",null,{"$f":"SUM(B120:J120)","v":0},{"$f":"IF(J129=0,J138,J129)","v":0},{"$f":"SUM(B125:J125)","v":0},0]
[null,"on-site generation",null,null,null,null,"off-site generation",null,null,null,null,null,null,"Net ZEB carbon",null,{"$f":"SUM(B120:F120)","v":0},{"$f":"IF(J129=0,J138,J129)","v":0},{"$f":"SUM(B125:F125)","v":0},0]
[null,"PV","cogeneration","solar thermal","enter one more generation system","enter one more generation system","PV","wind turbine","enter one more generation system","enter one more generation system"]
[null,{"$f":"'Building Data'!$E$21*'Operating costs'!E27","v":0},{"$f":"SUMPRODUCT('Building Data'!$E$22:$G$22,'Operating costs'!E28:G28)","v":0},{"$f":"'Building Data'!F23*'Operating costs'!F29","v":0},{"$f":"SUMPRODUCT('Building Data'!E24:K24,'Operating costs'!E30:K30)","v":0},{"$f":"SUMPRODUCT('Building Data'!E25:K25,'Operating costs'!E31:K31)","v":0},{"$f":"'Building Data'!E27*'Operating costs'!E32","v":0},{"$f":"'Building Data'!E28*'Operating costs'!E33","v":0},{"$f":"SUMPRODUCT('Building Data'!E29:K29,'Operating costs'!E34:K34)","v":0},{"$f":"SUMPRODUCT('Building Data'!E30:K30,'Operating costs'!E35:K35)","v":0}]
[]
[null,"Cost Demand items"]
[null,null,"electricity ","oil","gas ","biomass ","heat from district heating","cold from district cooling ","enter one more energy source","SUM"]
[null,"heating ",{"$f":"'Building Data'!E37*'Operating costs'!$E$41","v":0},{"$f":"'Building Data'!F37*'Operating costs'!$F$41","v":0},{"$f":"'Building Data'!G37*'Operating costs'!$G$41","v":0},{"$f":"'Building Data'!H37*'Operating costs'!$H$41","v":0},{"$f":"'Building Data'!I37*'Operating costs'!$I$41","v":0},null,{"$f":"'Building Data'!K37*'Operating costs'!$K$41","v":0},{"$f":"SUM(C129:I136)","v":0},"separeted items"]
[null,"DHW",{"$f":"'Building Data'!E38*'Operating costs'!$E$41","v":0},{"$f":"'Building Data'!F38*'Operating costs'!$F$41","v":0},{"$f":"'Building Data'!G38*'Operating costs'!G41","v":0},{"$f":"'Building Data'!H38*'Operating costs'!H41","v":0},{"$f":"'Building Data'!I38*'Operating costs'!I41","v":0},null,{"$f":"'Building Data'!K38*'Operating costs'!K41","v":0}]
[null,"cooling",{"$f":"'Building Data'!E39*'Operating costs'!$E$41","v":0},null,null,null,null,{"$f":"'Building Data'!J39*'Operating costs'!J41","v":0}]
[null,"built-in lighting",{"$f":"'Building Data'!E40*'Operating costs'!$E$41","v":0}]
[null,"auxiliaries",{"$f":"'Building Data'!E41*'Operating costs'!$E$41","v":0}]
[null,"ventilation",{"$f":"'Building Data'!E42*'Operating costs'!$E$41","v":0}]
[null,"plug loads",{"$f":"'Building Data'!E43*'Operating costs'!$E$41","v":0}]
[null,"combined h & p+c",{"$f":"'Building Data'!E44*'Operating costs'!$E$41","v":0},{"$f":"'Building Data'!F44*'Operating costs'!$F$41","v":0},{"$f":"'Building Data'!G44*'Operating costs'!$G$41","v":0},{"$f":"'Building Data'!H44*'Operating costs'!$H$41","v":0},{"$f":"'Building Data'!I44*'Operating costs'!$I$41","v":0},{"$f":"'Building Data'!J44*'Operating costs'!$J$41","v":0},{"$f":"'Building Data'!K44*'Operating costs'!$K$41","v":0}]
[null,"other",{"$f":"'Building Data'!E45*'Operating costs'!$E$41","v":0},{"$f":"'Building Data'!F45*'Operating costs'!$F$41","v":0},{"$f":"'Building Data'!G45*'Operating costs'!$G$41","v":0},{"$f":"'Building Data'!H45*'Operating costs'!$H$41","v":0},{"$f":"'Building Data'!I45*'Operating costs'!$I$41","v":0},{"$f":"'Building Data'!J45*'Operating costs'!$J$41","v":0},{"$f":"'Building Data'!K45*'Operating costs'!$K$41","v":0}]
[null,"TOTALE",{"$f":"'Building Data'!E46*'Operating costs'!$E$41","v":0},{"$f":"'Building Data'!F46*'Operating costs'!$F$41","v":0},{"$f":"'Building Data'!G46*'Operating costs'!$G$41","v":0},{"$f":"'Building Data'!H46*'Operating costs'!$H$41","v":0},{"$f":"'Building Data'!I46*'Operating costs'!$I$41","v":0},{"$f":"'Building Data'!J46*'Operating costs'!$J$41","v":0},{"$f":"'Building Data'!K46*'Operating costs'!$K$41","v":0},{"$f":"SUM(C138:I138)","v":0}]
[]
["ESTIMATED BUILDING GRID INTERACTION COST"]
[]
[null,"Cost Supply items",null,null,null,null,null,null,null,null,null,null,null,"Estimated import/export cost balance"]
[null,"on-site generation",null,null,null,null,"off-site generation"]
[null,"PV","cogeneration","solar thermal","enter one more generation system","enter one more generation system","PV","wind turbine","enter one more generation system","enter one more generation system",null,null,null,null,null,"Exported","Delivered","Incentives","Balance"]
[null,{"$f":"'Building Data'!E69*'Operating costs'!$E$13","v":0},{"$f":"SUMPRODUCT('Building Data'!E70:G70,'Operating costs'!$E$14:$G$14)","v":0},{"$f":"'Building Data'!F71*'Operating costs'!$F$15","v":0},{"$f":"SUMPRODUCT('Building Data'!E72:K72,'Operating costs'!$E$16:$K$16)","v":0},{"$f":"SUMPRODUCT('Building Data'!E73:K73,'Operating costs'!$E$17:$K$17)","v":0},{"$f":"'Building Data'!E74*'Operating costs'!$E$18","v":0},{"$f":"'Building Data'!E75*'Operating costs'!$E$19","v":0},{"$f":"SUMPRODUCT('Building Data'!E76:K76,'Operating costs'!$E$20:$K$20)","v":0},{"$f":"SUMPRODUCT('Building Data'!E77:K77,'Operating costs'!$E$21:$K$21)","v":0},null,null,null,"Net ZEB limited",null,{"$f":"SUM(B145:F145)","v":0},{"$f":"SUM(C154:I154)-L154","v":0},{"$f":"SUM(B150:F150)","v":0},{"$f":"P145-Q145+R145","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Net ZEB primary",null,{"$f":"SUM(B145:F145)","v":0},{"$f":"SUM(C154:I154)","v":0},{"$f":"SUM(B150:F150)","v":0},0]
[null,"Incentives",null,null,null,null,null,null,null,null,null,null,null,"Net ZEB strategic",null,{"$f":"SUM(B145:J145)","v":0},{"$f":"SUM(C154:I154)","v":0},{"$f":"SUM(B150:J150)","v":0},0]
[null,"on-site generation",null,null,null,null,"off-site generation",null,null,null,null,null,null,"Net ZEB carbon",null,{"$f":"SUM(B145:F145)","v":0},{"$f":"SUM(C154:I154)","v":0},{"$f":"SUM(B150:F150)","v":0},0]
[null,"PV","cogeneration","solar thermal","enter one more generation system","enter one more generation system","PV","wind turbine","enter one more generation system","enter one more generation system"]
[null,{"$f":"'Building Data'!E69*'Operating costs'!E27","v":0},{"$f":"SUMPRODUCT('Building Data'!E70:G70,'Operating costs'!E28:G28)","v":0},{"$f":"'Building Data'!F71*'Operating costs'!F29","v":0},{"$f":"SUMPRODUCT('Building Data'!E72:K72,'Operating costs'!E30:K30)","v":0},{"$f":"SUMPRODUCT('Building Data'!E73:K73,'Operating costs'!E31:K31)","v":0},{"$f":"'Building Data'!E74*'Operating costs'!E32","v":0},{"$f":"'Building Data'!E75*'Operating costs'!E33","v":0},{"$f":"SUMPRODUCT('Building Data'!E76:K76,'Operating costs'!E34:K34)","v":0},{"$f":"SUMPRODUCT('Building Data'!E77:K77,'Operating costs'!E35:K35)","v":0}]
[]
[null,"Cost Demand items"]
[null,null,"electricity ","oil","gas ","biomass ","heat from district heating","cold from district cooling ","enter one more energy source",null,null,"Appliances' electricity cost"]
[null,null,{"$f":"'Building Data'!E83*'Operating costs'!E41","v":0},{"$f":"'Building Data'!F83*'Operating costs'!F41","v":0},{"$f":"'Building Data'!G83*'Operating costs'!G41","v":0},{"$f":"'Building Data'!H83*'Operating costs'!H41","v":0},{"$f":"'Building Data'!I83*'Operating costs'!I41","v":0},{"$f":"'Building Data'!J83*'Operating costs'!J41","v":0},{"$f":"'Building Data'!K83*'Operating costs'!K41","v":0},null,null,{"$f":"'Building Data'!E43*'Operating costs'!E41","v":0}]
[]
["MONITORED BUILDING-GRID INTERACTION COST"]
[]
[null,"Cost Supply items",null,null,null,null,null,null,null,null,null,null,null,"Monitored import/export cost balance"]
[null,"on-site generation",null,null,null,null,"off-site generation"]
[null,"PV","cogeneration","solar thermal","enter one more generation system","enter one more generation system","PV","wind turbine","enter one more generation system","enter one more generation system",null,null,null,null,null,"Exported","Delivered","Incentives","Balance"]
[null,{"$f":"'Building Data'!E106*'Operating costs'!$E$13","v":0},{"$f":"SUMPRODUCT('Building Data'!E107:G107,'Operating costs'!$E$14:$G$14)","v":0},{"$f":"'Building Data'!F108*'Operating costs'!$F$15","v":0},{"$f":"SUMPRODUCT('Building Data'!E109:K109,'Operating costs'!$E$16:$K$16)","v":0},{"$f":"SUMPRODUCT('Building Data'!E110:K110,'Operating costs'!$E$17:$K$17)","v":0},{"$f":"'Building Data'!E111*'Operating costs'!$E$18","v":0},{"$f":"'Building Data'!E111*'Operating costs'!$E$19","v":0},{"$f":"SUMPRODUCT('Building Data'!E111:K111,'Operating costs'!$E$20:$K$20)","v":0},{"$f":"SUMPRODUCT('Building Data'!E111:K111,'Operating costs'!$E$21:$K$21)","v":0},null,null,null,"Net ZEB limited",null,{"$f":"SUM(B161:F161)","v":0},{"$f":"SUM(C170:I170)-L170","v":0},{"$f":"SUM(B166:F166)","v":0},{"$f":"P161-Q161+R161","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Net ZEB primary",null,{"$f":"SUM(B161:F161)","v":0},{"$f":"SUM($C$170:$I$170)","v":0},{"$f":"SUM(B166:F166)","v":0},0]
[null,"Incentives",null,null,null,null,null,null,null,null,null,null,null,"Net ZEB strategic",null,{"$f":"SUM(B161:J161)","v":0},0,{"$f":"SUM(B166:J166)","v":0},{"$f":"P163-Q163+R163","v":0}]
[null,"on-site generation",null,null,null,null,"off-site generation",null,null,null,null,null,null,"Net ZEB carbon",null,{"$f":"SUM(B161:F161)","v":0},0,{"$f":"SUM(B166:F166)","v":0},0]
[null,"PV","cogeneration","solar thermal","enter one more generation system","enter one more generation system","PV","wind turbine","enter one more generation system","enter one more generation system"]
[null,{"$f":"'Building Data'!E106*'Operating costs'!E27","v":0},{"$f":"SUMPRODUCT('Building Data'!E107:G107,'Operating costs'!E28:G28)","v":0},{"$f":"'Building Data'!F108*'Operating costs'!F29","v":0},{"$f":"SUMPRODUCT('Building Data'!E109:K109,'Operating costs'!E30:K30)","v":0},{"$f":"SUMPRODUCT('Building Data'!E110:K110,'Operating costs'!E31:K31)","v":0},{"$f":"'Building Data'!E111*'Operating costs'!E32","v":0},{"$f":"'Building Data'!E112*'Operating costs'!E33","v":0},{"$f":"SUMPRODUCT('Building Data'!E113:K113,'Operating costs'!E34:K34)","v":0},{"$f":"SUMPRODUCT('Building Data'!E114:K114,'Operating costs'!E35:K35)","v":0}]
[]
[null,"Cost Demand items"]
[null,null,"electricity ","oil","gas ","biomass ","heat from district heating","cold from district cooling ","enter one more energy source",null,null,"Appliances' electricity cost"]
[null,null,{"$f":"'Building Data'!E120*'Operating costs'!E41","v":0},{"$f":"'Building Data'!F120*'Operating costs'!F41","v":0},{"$f":"'Building Data'!G120*'Operating costs'!G41","v":0},{"$f":"'Building Data'!H120*'Operating costs'!H41","v":0},{"$f":"'Building Data'!I120*'Operating costs'!I41","v":0},{"$f":"'Building Data'!J120*'Operating costs'!J41","v":0},{"$f":"'Building Data'!K120*'Operating costs'!K41","v":0},null,null,{"$f":"'Building Data'!E43*'Operating costs'!E41","v":0}]