{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["Partner DataBase","Building DataBase","ID DataBase","Welcome","Instruction","Short Description","#1","#2","#3","#4","#4a","#5","#6","#7a","#7b","#7c","#8","#ID1","#ID2","2_Energy saving measures","3_Data collection"],"not_rendered":{"charts":7,"images":19,"macros":1,"external_links":2,"defined_names":204,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Partner DataBase","index":0,"n_rows":7,"n_cols":46,"rows_kept":7,"cut":false,"hidden":true,"merged":[[0,0,0,1],[2,2,3,2],[2,7,3,7],[2,23,3,23],[2,11,3,11],[2,17,3,17]]}
["GREENBUILDINGplus"]
[]
[null,null,"COMPANY INFORMATION",null,null,null,null,"BUILDING INFORMATION",null,null,null,"DIRECTOR INFORMATION",null,null,null,null,null,"REFERENCE INFORMATION",null,null,null,null,null,"ENERGY MANAGEMENT"]
["Id","BUILDING NAME",null,"COMPANY NAME","COMPANY HOMEPAGE","BUILDING ADDRESS - STREET, NUMBER, CAP, CITY","COMPANY COUNTRY",null,"SHORT BUILDING IDENTIFICATION NAME","COMPANY ADDRESS - STREET, NUMBER, CAP, CITY","BUILDING COUNTRY",null,"DIRECTOR OR PERSON AUTHORIZED TO SIGN FOR THE ORGANIZATION","FUNCTION","PHONE NUMBER","FAX NUMBER","E-MAIL",null,"REFERENCE PERSON","FUNCTION","PHONE NUMBER","FAX NUMBER","E-MAIL",null,"IS THERE AN EXPLICIT ENVIRONMENTAL POLICY?","COMMENT #1","DOES THE ENVIRONMENTAL POLICY INCLUDE ENERGY CONSIDERATIONS?","COMMENT #2","DO THE LONG TERM PROFITABILITY CRITERIA INCLUDE ENERGY CONSIDERATIONS?","COMMENT #3","DO CONSTRUCTION AND RENOVATION PROCEDURES INCLUDE ENERGY CONSIDERATIONS?","COMMENT #4","DOES THE INTERNAL DESIGN PROCEDURES INCLUDE ENERGY CONSIDERATIONS?","COMMENT #5","DO THE PURCHASING AND SERVICE PROCEDURES INCLUDE ENERGY CONSIDERATIONS?","COMMENT #6","DOES THE FACILITY MANAGEMENT PROCEDURE INCLUDE ENERGY CONSIDERATIONS?","COMMENT #7","DOES THE COMPANY HAVE ANY MONITORING PLAN AND SPECIFIC DELIVERED ENERGY MEASUREMENTS?","COMMENT #8","DOES THE COMPANY HAVE SPECIFIC ENERGY COSTS IN ITS ACCOUNTING?","COMMENT #9","DOES THE COMPANY HAVE A SPECIFIC PERSON RESONSIBLE FOR THE ENERGY RELATED ISSUES?","COMMENT #10","DO THE OPERATIONS AND MAINTENANCE INCLUDE ENERGY CONSIDERATIONS?","COMMENT #11"]
[1,{"$f":"'#1'!E22","v":0},null,{"$f":"'#1'!E10","v":0},{"$f":"'#1'!E12","v":0},{"$f":"'#1'!E14&\" - \"&'#1'!I14&\" - \"&'#1'!E16&\" - \"&'#1'!G16","v":" -  -  - "},{"$f":"'#1'!E18","v":0},null,{"$f":"'#1'!#REF!","v":{"$error":"#REF!"}},{"$f":"'#1'!E24&\" - \"&'#1'!I24&\" - \"&'#1'!E26&\" - \"&'#1'!G26","v":" -  -  - "},{"$f":"'#1'!E28","v":0},null,{"$f":"'#1'!N10","v":0},{"$f":"'#1'!N12","v":0},{"$f":"'#1'!N14","v":0},{"$f":"'#1'!N16","v":0},{"$f":"'#1'!N18","v":0},null,{"$f":"'#1'!N22","v":0},{"$f":"'#1'!#REF!","v":{"$error":"#REF!"}},{"$f":"'#1'!N24","v":0},{"$f":"'#1'!N26","v":0},{"$f":"'#1'!N28","v":0},null,{"$f":"'#8'!E8","v":0},{"$f":"'#8'!G8","v":0},{"$f":"'#8'!E11","v":0},{"$f":"'#8'!G11","v":0},{"$f":"'#8'!E14","v":0},{"$f":"'#8'!G14","v":0},{"$f":"'#8'!E19","v":0},{"$f":"'#8'!G19","v":0},{"$f":"'#8'!E22","v":0},{"$f":"'#8'!G22","v":0},{"$f":"'#8'!E27","v":0},{"$f":"'#8'!G27","v":0},{"$f":"'#8'!E30","v":0},{"$f":"'#8'!G30","v":0},{"$f":"'#8'!E35","v":0},{"$f":"'#8'!G35","v":0},{"$f":"'#8'!E38","v":0},{"$f":"'#8'!G38","v":0},{"$f":"'#8'!E41","v":0},{"$f":"'#8'!G41","v":0},{"$f":"'#8'!E44","v":0},{"$f":"'#8'!G44","v":0}]
["DO NOT INSERT ROWS BELOW"]
[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,"Created by Salvatore Carlucci"]

{"sheet":"Building DataBase","index":1,"n_rows":7,"n_cols":242,"rows_kept":7,"cut":false,"hidden":true,"merged":[[2,92,2,99],[2,80,2,83],[2,84,2,91],[2,197,2,241],[2,100,2,103],[2,158,2,164],[2,165,2,177],[2,178,2,184],[2,104,2,107],[2,116,2,119],[2,120,2,138],[2,139,2,157],[2,185,2,196],[2,108,2,115],[14,0,14,1],[0,0,0,1],[2,64,2,71],[2,72,2,79],[2,35,2,63],[2,2,2,7],[2,11,2,19],[2,8,2,10],[2,20,2,34]]}
["GREENBUILDINGplus"]
[]
[null,null,"CANDIDATURE ITER",null,null,null,null,null,"CANDIDATE PARTNER",null,null,"CANDIDATE BUILDING",null,null,null,null,null,null,null,null,"SITE & BUILDING INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BUILDING ENVELOPE",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,"HEATING SYSTEM BEFORE RENOVATION",null,null,null,null,null,null,null,"HEATING SYSTEM AFTER RENOVATION OR ACTUAL STATUS",null,null,null,null,null,null,null,"PRODUCTION OF SHW",null,null,null,"COOLING SYSTEM BEFORE RENOVATION",null,null,null,null,null,null,null,"COOLING SYSTEM AFTER RENOVATION OR ACTUAL STATUS",null,null,null,null,null,null,null,"VENTILATION SYSTEM BEFORE RENOVATION",null,null,null,"VENTILATION SYSTEM AFTER RENOVATION OR ACTUAL STATUS",null,null,null,"ELECTRIC USES",null,null,null,null,null,null,null,"TRI/COGENERATION",null,null,null,"RENEWABLE SOURCES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DELIVERED ENERGY BY ENERGY CARRIER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENERGY PERFORMANCE OF BUILDING (Legal values or before renovation)",null,null,null,null,null,null,"ENERGY PERFORMANCE OF BUILDING (Actual building)",null,null,null,null,null,null,null,null,null,null,null,null,"PRIMARY ENERGY FROM RENEWABLES",null,null,null,null,null,null,"COSTS FOR ENERGY EFFICIENCY",null,null,null,null,null,null,null,null,null,null,null,"ENERGY SAVINGS MEASURES"]
["Id","BUILDING NAME","NAME OF DOCUMENT #1","NAME OF DOCUMENT #2","NAME OF DOCUMENT #3","NAME OF DOCUMENT #4","NAME OF DOCUMENT #5","NAME OF DOCUMENT #6","COMPANY NAME","DIRECTOR OR PERSON AUTHORIZED TO SIGN FOR THE ORGANIZATION","BUILDING REFERENCE PERSON","COUNTRY","BUILDING ADDRESS - STREET, NUMBER, CAP, CITY","SHORT DESCRIPTION OF BUILDING & INTERVENTION (300 WORD)","ACTUAL TYPE OF USE","YEAR OF CONSTRUCTION","TYPE OF INTERVENT","YEAR OF RENOVATION","DAYS OF USE IN A YEAR","HOURS OF USE IN A DAY","CLIMATE ZONE ACCORDING TO M.METZGER, 2003","TYPE OF SURROUNDING","ALTITUDE ABOVE SEA LEVEL\n(m)","LATITUDE","HEATING DEGREE DAYS (DD)","COOLING DEGREE DAY (DD)","HEATED NET FLOOR AREA BEFORE RENOVATION (m2)","COOLED NET FLOOR AREA BEFORE RENOVATION (m2)","LIGHTED NET FLOOR AREA BEFORE INTERVENTION (m2)","ELECTRIC EQUIPPED NET FLOOR AREA BEFORE INTERVENTION (m2)","HEATED NET FLOOR AREA AFTER RENOVATION OR NEW BUILDING (m2)","COOLED NET FLOOR AREA AFTER RENOVATION OR NEW BUILDING (m2)","LIGHTED/ELECTRIC EQUIPPED NET FLOOR AREA AFTER RENOVATION OR NEW BUILDING (m2)","HEATED NET VOLUME AFTER RENOVATION OR NEW BUILDING (m3)","HEATED GROSS VOLUME AFTER RENOVATION OR NEW BUILDING (m3)","AVERAGE U-value OF ROOF","AREA OF ROOF","AVERAGE U-value OF EXTERNAL WALL","AREA OF EXTERNAL WALL","AVERAGE U-value OF PARTITIONS AGAINST NOT HEATED SPACES","AREA OF PARTITION AGAINST NOT HEATED SPACES","AVERAGE U-value OF BASEMENT","AREA OF BASEMENT","U-value OF TYPE 1 WINDOWS (glazed system+frame+TB)","SHADING COEFFICIENT OF TYPE 1 WINDOWS (glazed system+shading)","VISIBLE TRANSMITTANCE OF TYPE 1 WINDOWS (%)","AREA OF TYPE 1 WINDOWS","PERCENTAGE OF TYPE 1 WINDOW AREA AGAINST TOTAL GLAZED AREA (%)","U-value OF TYPE 2 WINDOWS (glazed system+frame+TB)","SHADING COEFFICIENT OF TYPE 2 WINDOWS (glazed system+shading)","VISIBLE TRANSMITTANCE OF TYPE 2 WINDOWS (%)","AREA OF TYPE 2 WINDOWS","PERCENTAGE OF TYPE 2 WINDOW AREA AGAINST TOTAL GLAZED AREA (%)","U-value OF TYPE 3 WINDOWS (glazed system+frame+TB)","SHADING COEFFICIENT OF TYPE 3 WINDOWS (glazed system+shading)","VISIBLE TRANSMITTANCE OF TYPE 3 WINDOWS (%)","AREA OF TYPE 3 WINDOWS","PERCENTAGE OF TYPE 3 WINDOW AREA AGAINST TOTAL GLAZED AREA (%)","AVERAGE ENVELOPE U-VALUE (HT) (W/m2/K)","TOTAL LOSSING AREA (m2)","S/V RATIO (m2/m3)","CLASS OF AIRTHIGTNESS","DATA SOURCE FOR OPAQUE ENVELOPE DATA","DATA SOURCE FOR TRANSPARENT ENVELOPE DATA","TYPE OF USE OF THE HEATING PRODUCTION BEFORE RENOVATION","TYPE OF HEATING PRODUCTION SYSTEM BEFORE RENOVATION","AGE OF THE HEATING PRODUCTION SYSTEM BEFORE RENOVATION","NOMINAL HEATING POWER  BEFORE RENOVATION  (kW)","IF BOILER, NOMINAL GENERATION EFFICIENCY BEFORE RENOVATION","IF HEAT PUNP, NOMINAL COP BEFORE RENOVATION","INDOOR HEATING SETPOINT TEMPERATURE BEFORE RENOVATION (°C)","TYPE OF DATA ABOUT SETPOINT TEMPERATURE  BEFORE RENOVATION","TYPE OF USE OF THE HEATING PRODUCTION ACTUAL STATUS","TYPE OF HEATING PRODUCTION SYSTEM ACTUAL STATUS","YEAR OF INSTALLATION OF THE HEATING SYSTEM","NOMINAL HEATING POWER ACTUAL STATUS  (kW)","IF BOILER, NOMINAL GENERATION EFFICIENCY IN ACTUAL STATUS","IF HEAT PUNP, NOMINAL COP IN ACTUAL STATUS","INDOOR HEATING SETPOINT TEMPERATURE ACTUAL STATUS (°C)","TYPE OF DATA ABOUT SETPOINT TEMPERATURE ACTUAL STATUS ","TYPE OF SYSTEM TO PRODUCE SHW BEFORE RENOVATION","NOMINAL HEATING POWER BEFORE RENOVATION  (kW)","TYPE OF SYSTEM TO PRODUCE SHW ACTUAL STATUS","NOMINAL HEATING POWER ACTUAL STATUS  (kW)","EXPLICIT COMFORT MODEL","STRATEGY TO REDUCE SOLAR HEAT GAIN BEFORE RENOVATION","COOLING STRATEGY BEFORE RENOVATION","TYPE OF COOLING PRODUCTION SYSTEM BEFORE RENOVATION","NOMINAL COOLING POWER BEFORE RENOVATION (kW)","SEASONAL ENERGY EFFICIENCY RATIO BEFORE RENOVATION (EER)","INDOOR COOLING SETPOINT TEMPERATURE BEFORE RENOVATION (°C)","TYPE OF DATA ABOUT SETPOINT TEMPERATURE  BEFORE RENOVATION","EXPLICIT COMFORT MODEL","STRATEGY TO REDUCE SOLAR HEAT GAIN ACTUAL STATUS","COOLING STRATEGY ACTUAL STATUS","TYPE OF COOLING PRODUCTION SYSTEM ACTUAL STATUS","NOMINAL COOLING POWER ACTUAL STATUS (kW)","SEASONAL ENERGY EFFICIENCY RATIO ACTUAL STATUS (EER)","INDOOR COOLING SETPOINT TEMPERATURE ACTUAL STATUS (°C)","TYPE OF DATA ABOUT SETPOINT TEMPERATURE ACTUAL STATUS","TYPE OF VENTILATION","IF MECHANICAL VENTILATION, ACH RATE (h-1)","PRESENCE OF A HEAT RECOVERY","EFFICIENCY OF HEAT RECOVERY (%)","TYPE OF VENTILATION","IF MECHANICAL VENTILATION, ACH RATE (h-1)","PRESENCE OF A HEAT RECOVERY","EFFICIENCY OF HEAT RECOVERY (%)","YEARLY OPERATION HOURS BEFORE INTERVENTION (h/y)","INSTALLED ELECTRIC POWER FOR LIGHTING BEFORE INTERVENTION (W/m2)","YEARL OPERATION HOURS AFTER INTERVENTION (h/y)","INSTALLED ELECTRIC POWER FOR LIGHTING AFTER INTERVENTION (W/m2)",null,"INSTALLED ELECTRIC POWER FOR ELECTRIC EQUIPMENT BEFORE INTERVENTION (W/m2)",null,"INSTALLED ELECTRIC POWER FOR ELECTRIC EQUIPMENT AFTER INTERVENTION (W/m2)","Is there a TRIGENERATION OR COGENERATION SYSTEM?","TYPE OF COMBINED GENERATION SYSTEM","ELECTRIC EFFICIENCY (%)","HEAT EFFICIENCY (%)","IS THERE A SOLAR THERMAL PLANT?","TYPE OF COLLECTOR","ABSORBING AREA (M2)","NOMINAL EFFICIENCY","IS THERE A PHOTOVOLTAIC SYSTEM?","TYPE OF CELL","ABSORBING AREA (M2)","NOMINAL EFFICIENCY","POWER INSTALLED (KW)","IS THERE A GEOTHERMAL PLANT?","PLANT TYPOLOGY","POWER INSTALLED (KW)","IS THERE A BIOMASS GENERATION SYSTEM?","TYPE OF BIOMASS USED AS FUEL","POWER INSTALLED (KW)","IS THERE A WIND GENERATION SYSTEM?","POWER INSTALLED (KW)","IS THERE A HYDROELECTRIC GENERATION SYSTEM?","POWER INSTALLED (KW)","ELECTRICITY CONSUMPTION BEFORE RENOVATION (kWh)","FUEL CONSUMPTION BEFORE RENOVATION (kWh)","ELECTRICITY CONSUMPTION AFTER RENOVATION (kWh)","QUALITY OF DATA ENTERED FOR ELECTRICITY CONSUMPTION","FUEL CONSUMPTION AFTER RENOVATION OR ACTUAL STATUS (kWh)","QUALITY OF DATA ENTERED FOR FUEL CONSUMPTION","ELECTRICITY PRODUCTION FROM RENEWABLES AFTER INTERVENTION (kWh/y)","QUALITY OF DATA ENTERED FOR ELECTRICITY PRODUCED BY RENEWABLES","HEAT PRODUCTION FROM RENEWABLES AFTER INTERVENTION (kWh/y)","QUALITY OF DATA ENTERED FOR FUEL PRODUCED BY RENEWABLES","SPECIFIC ELECTRICITY CONSUMPTION AFTER RENOVATION OR ACTUAL STATUS (kWh/m2)","SPECIFIC FUEL CONSUMPTION AFTER RENOVATION OR ACTUAL STATUS (kWh/m2)","CONVERSION FACTOR FOR ELECTRICITY\n(delivered to primary energy ratio)","CONVERSION FACTOR FOR FUEL\n(delivered to primary energy ratio)","TOTAL PRIMARY ENERGY FROM ELECTRICITY AFTER RENOVATION (kWh/y)","TOTAL PRIMARY ENERGY FROM FUEL AFTER RENOVATION (kWh/y)","TOTAL PRIMARY ENERGY FROM RENEWABLES (kWh/y)","ENERGY SAVING PERCENTAGE WITH RENEWABLES","ENERGY SAVING PERCENTAGE WITHOUT RENEWABLES","PRIMARY ENERGY FOR HEATING BEFORE INTERVENTION OR LEGAL VALUE (kWh)","PRIMARY ENERGY FOR COOLING AND DEHUMIDIFICATION BEFORE INTERVENTION OR LEGAL VALUE (kWh)","PRIMARY ENERGY FOR VENTILATION AND HUMIDIFICATION BEFORE INTERVENTION OR LEGAL VALUE (kWh)","PRIMARY ENERGY FOR THE PRODUCTION OF SHW BEFORE INTERVENTION OR LEGAL VALUE (kWh)","PRIMARY ENERGY FOR LIGHTING BEFORE INTERVENTION OR LEGAL VALUE (kWh)","PRIMARY ENERGY FOR OTHER ELECTRIC USES BEFORE INTERVENTION OR LEGAL VALUE (kWh)","TOTAL PRIMARY ENERGY BEFORE INTERVENTION OR LEGAL VALUE (kWh)","ACTUAL PRIMARY ENERGY FOR HEATING (kWh)","QUALITY OF DATA ENTERED FOR HEATING","ACTUAL PRIMARY ENERGY FOR COOLING AND DEHUMIDIFICATION (kWh)","QUALITY OF DATA ENTERED FOR COOLING AND DEHUMIDIFICATION","ACTUAL PRIMARY ENERGY FOR VENTILATION AND HUMIDIFICATION (kWh)","QUALITY OF DATA ENTERED FOR VENTILATION AND HUMIDIFICATION","ACTUAL PRIMARY ENERGY FOR THE PRODUCTION OF SHW (kWh)","QUALITY OF DATA ENTERED FOR THE PRODUCTION OF SHW","ACTUAL PRIMARY ENERGY FOR LIGHTING (kWh)","QUALITY OF DATA ENTERED FOR LIGHTING","ACTUAL PRIMARY ENERGY FOR OTHER ELECTRIC USES (kWh)","QUALITY OF DATA ENTERED FOR ELECTRIC USE","TOTAL PRIMARY ENERGY IN ACTUAL BUILDING STATUS (kWh)","PRIMARY ENERGY GENERATED BY SOLAR THERMAL PLANT","PRIMARY ENERGY GENERATED BY PHOTOVOLTAIC PLANT","PRIMARY ENERGY GENERATED BY WIND GENERATOR SYSTEM","PRIMARY ENERGY GENERATED BY HYDOELECTRIC GENERATOR SYSTEM","TOTAL PRIMARY ENERGY FROM RENEWABLE","ENERGY SAVING PERCENTAGE WITH RENEWABLES","ENERGY SAVING PERCENTAGE WITHOUT RENEWABLES","EXTRA INVESTIMENT COST FOR HEATING","EXTRA INVESTIMENT COST FOR COOLING AND DEHUMIDIFICATION","EXTRA INVESTIMENT COST FOR VENTILATION AND HUMIDIFICATION","EXTRA INVESTIMENT COST FOR PRODUCTION OF SHW","EXTRA INVESTIMENT COST FOR LIGHTING","EXTRA INVESTIMENT COST FOR ELECTRIC USES","TECHNICAL LIFE FOR HEATING EQUIPMENT","TECHNICAL LIFE FOR COOLING AND DEHUMIDIFICATION EQUIPMENT","TECHNICAL LIFE FOR VENTILATION AND HUMIDIFICATION EQUIPMENT","TECHNICAL LIFE FOR SHW PRODUCTION EQUIPMENT","TECHNICAL LIFE FOR LIGHTING EQUIPMENT","TECHNICAL LIFE FOR ELECTRIC EQUIPMENT","TARGET SUB-SYSTEM_1","TYPOLOGY OF ENERGY SAVING MEASURE_1","SPECIFIC ACTIONS_1","TARGET SUB-SYSTEM_2","TYPOLOGY OF ENERGY SAVING MEASURE_2","SPECIFIC ACTIONS_2","TARGET SUB-SYSTEM_3","TYPOLOGY OF ENERGY SAVING MEASURE_3","SPECIFIC ACTIONS_3","TARGET SUB-SYSTEM_4","TYPOLOGY OF ENERGY SAVING MEASURE_4","SPECIFIC ACTIONS_4","TARGET SUB-SYSTEM_5","TYPOLOGY OF ENERGY SAVING MEASURE_5","SPECIFIC ACTIONS_5","TARGET SUB-SYSTEM_6","TYPOLOGY OF ENERGY SAVING MEASURE_6","SPECIFIC ACTIONS_6","TARGET SUB-SYSTEM_7","TYPOLOGY OF ENERGY SAVING MEASURE_7","SPECIFIC ACTIONS_7","TARGET SUB-SYSTEM_8","TYPOLOGY OF ENERGY SAVING MEASURE_8","SPECIFIC ACTIONS_8","TARGET SUB-SYSTEM_9","TYPOLOGY OF ENERGY SAVING MEASURE_9","SPECIFIC ACTIONS_9","TARGET SUB-SYSTEM_10","TYPOLOGY OF ENERGY SAVING MEASURE_10","SPECIFIC ACTIONS_10","TARGET SUB-SYSTEM_11","TYPOLOGY OF ENERGY SAVING MEASURE_11","SPECIFIC ACTIONS_11","TARGET SUB-SYSTEM_12","TYPOLOGY OF ENERGY SAVING MEASURE_12","SPECIFIC ACTIONS_12","TARGET SUB-SYSTEM_13","TYPOLOGY OF ENERGY SAVING MEASURE_13","SPECIFIC ACTIONS_13","TARGET SUB-SYSTEM_14","TYPOLOGY OF ENERGY SAVING MEASURE_14","SPECIFIC ACTIONS_14","TARGET SUB-SYSTEM_15","TYPOLOGY OF ENERGY SAVING MEASURE_15","SPECIFIC ACTIONS_15"]
[1,{"$f":"'#1'!E22","v":0},{"$f":"'#2'!#REF!","v":{"$error":"#REF!"}},{"$f":"'#2'!#REF!","v":{"$error":"#REF!"}},{"$f":"'#2'!#REF!","v":{"$error":"#REF!"}},{"$f":"'#2'!#REF!","v":{"$error":"#REF!"}},{"$f":"'#2'!#REF!","v":{"$error":"#REF!"}},{"$f":"'#2'!#REF!","v":{"$error":"#REF!"}},{"$f":"'#1'!E10","v":0},{"$f":"'#1'!N10","v":0},{"$f":"'#1'!N22","v":0},{"$f":"'#1'!E28","v":0},{"$f":"'#1'!E24&\" - \"&'#1'!I24&\" - \"&'#1'!E26&\" - \"&'#1'!G26","v":" -  -  - "},{"$f":"'#2'!C38","v":0},{"$f":"'#2'!E8","v":0},{"$f":"'#2'!E10","v":0},{"$f":"'#2'!E12","v":0},{"$f":"'#2'!E14","v":0},{"$f":"'#2'!F16","v":0},{"$f":"'#2'!I16","v":0},{"$f":"'#2'!N8","v":0},{"$f":"'#2'!N10","v":0},{"$f":"'#2'!N12","v":0},{"$f":"'#2'!#REF!","v":{"$error":"#REF!"}},{"$f":"'#2'!N14","v":0},{"$f":"'#2'!N16","v":0},{"$f":"IF('#2'!E12<>\"New building (legal value)\",IF(#REF!=\"Gross\",#REF!*#REF!,#REF!),\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"New building (legal value)\",IF(#REF!=\"Gross\",#REF!*#REF!,#REF!),\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"New building (legal value)\",IF('#5'!E21=\"Gross\",'#5'!E23*'#5'!I21,'#5'!E23),\"None\")","v":0},{"$f":"IF('#2'!E12<>\"New building (legal value)\",IF('#5'!E34=\"Gross\",'#5'!E36*'#5'!I34,'#5'!E36),\"None\")","v":0},{"$f":"IF('#2'!E20=\"Gross\",'#2'!E22*'#2'!I20,'#2'!E22)","v":0},{"$f":"IF('#2'!E24=\"Gross\",'#2'!E26*'#2'!I24,'#2'!E26)","v":0},{"$f":"IF('#2'!E28=\"Gross\",'#2'!#REF!*'#2'!I28,'#2'!#REF!)","v":{"$error":"#REF!"}},{"$f":"'#2'!E32","v":0},{"$f":"'#2'!E34","v":0},{"$f":"'#3'!E31","v":0},{"$f":"'#3'!E33","v":0},{"$f":"'#3'!I31","v":0},{"$f":"'#3'!I33","v":0},{"$f":"'#3'!S31","v":0},{"$f":"'#3'!S33","v":0},{"$f":"'#3'!N31","v":0},{"$f":"'#3'!N33","v":0},{"$f":"'#3'!E42","v":0},{"$f":"'#3'!E44","v":0},{"$f":"'#3'!E46","v":0},{"$f":"'#3'!E48","v":0},{"$f":"'#3'!E50","v":0},{"$f":"'#3'!I42","v":0},{"$f":"'#3'!I44","v":0},{"$f":"'#3'!I46","v":0},{"$f":"'#3'!I48","v":0},{"$f":"'#3'!I50","v":0},{"$f":"'#3'!N42","v":0},{"$f":"'#3'!N44","v":0},{"$f":"'#3'!N46","v":0},{"$f":"'#3'!N48","v":0},{"$f":"'#3'!N50","v":0},{"$f":"'#3'!E57","v":0},{"$f":"'#3'!I57","v":""},{"$f":"'#3'!S57","v":"Not evaluable"},{"$f":"'#3'!P53","v":0},{"$f":"'#3'!G36","v":0},{"$f":"'#3'!G53","v":0},{"$f":"IF('#2'!E12<>\"New building (legal value)\",#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"New building (legal value)\",#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"New building (legal value)\",#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"New building (legal value)\",#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"New building (legal value)\",#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"New building (legal value)\",#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"New building (legal value)\",#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"New building (legal value)\",#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"'#4'!E8","v":0},{"$f":"'#4'!E10","v":0},{"$f":"'#4'!E12","v":0},{"$f":"'#4'!E14","v":0},{"$f":"'#4'!E18","v":0},{"$f":"'#4'!E20","v":0},{"$f":"'#4'!E22","v":0},{"$f":"'#4'!G22","v":0},{"$f":"IF('#2'!E12<>\"New building (legal value)\",#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"New building (legal value)\",#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"'#4'!E26","v":0},{"$f":"'#4'!E30","v":0},{"$f":"IF('#2'!E12<>\"New building (legal value)\",#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"New building (legal value)\",#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"New building (legal value)\",#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"New building (legal value)\",#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"New building (legal value)\",#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"New building (legal value)\",#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"New building (legal value)\",#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"New building (legal value)\",#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"'#4'!$L$14","v":0},{"$f":"'#4'!$L$16","v":0},{"$f":"'#4'!$L$12","v":0},{"$f":"'#4'!#REF!","v":{"$error":"#REF!"}},{"$f":"'#4'!$L$18","v":0},{"$f":"'#4'!$L$20","v":0},{"$f":"'#4'!$L$22","v":0},{"$f":"'#4'!$N$22","v":0},{"$f":"IF('#2'!E12<>\"New building (legal value)\",IF(#REF!=\"Yes\",\"Mechanical ventilation\",\"Natural ventilation\"),\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"New building (legal value)\",IF(#REF!=\"Yes\",#REF!,\"None\"),\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"New building (legal value)\",#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"New building (legal value)\",IF(#REF!=\"Yes\",#REF!,\"None\"),\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#4'!L26=\"Yes\",\"Mechanical ventilation\",\"Natural ventilation\")","v":"Natural ventilation"},{"$f":"IF('#4'!L26=\"Yes\",'#4'!#REF!,\"None\")","v":"None"},{"$f":"'#4'!L30","v":0},{"$f":"IF('#4'!L30=\"yES\",'#4'!L34,\"None\")","v":"None"},{"$f":"IF('#2'!E12<>\"New building (legal value)\",'#5'!#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"New building (legal value)\",'#5'!#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"'#5'!#REF!","v":{"$error":"#REF!"}},{"$f":"'#5'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF('#2'!E12<>\"New building (legal value)\",'#5'!E32,\"None\")","v":0},null,{"$f":"'#5'!N32","v":0},{"$f":"IF(OR('#6'!J28=\"\",'#6'!J28=\"No\"),\"No\",\"Yes\")","v":"No"},{"$f":"IF('#6'!J28=\"No\",\"None\",'#6'!J30)","v":0},{"$f":"IF('#6'!J28=\"No\",\"None\",'#6'!J32)","v":0},{"$f":"IF('#6'!J28=\"No\",\"None\",'#6'!J34)","v":0},{"$f":"IF(OR('#6'!$E$8=\"\",'#6'!$E$8=\"No\"),\"No\",\"Yes\")","v":"No"},{"$f":"IF($DQ$5=\"No\",\"None\",'#6'!$E$12)","v":"None"},{"$f":"IF($DQ$5=\"No\",\"None\",'#6'!$E$10)","v":"None"},{"$f":"IF($DQ$5=\"No\",\"None\",'#6'!$E$14)","v":"None"},{"$f":"IF(OR('#6'!$J$8=\"\",'#6'!$J$8=\"No\"),\"No\",\"Yes\")","v":"No"},{"$f":"IF($DU$5=\"No\",\"None\",'#6'!$J$12)","v":"None"},{"$f":"IF($DU$5=\"No\",\"None\",'#6'!$J$10)","v":"None"},{"$f":"IF($DU$5=\"No\",\"None\",'#6'!$J$14)","v":"None"},{"$f":"IF($DU$5=\"No\",\"None\",'#6'!$J$16)","v":"None"},{"$f":"IF(OR('#6'!$E$20=\"\",'#6'!$E$20=\"No\"),\"No\",\"Yes\")","v":"No"},{"$f":"IF($DZ$5=\"No\",\"None\",'#6'!$E$22)","v":"None"},{"$f":"IF($DZ$5=\"No\",\"None\",'#6'!$E$24)","v":"None"},{"$f":"IF(OR('#6'!$J$20=\"\",'#6'!$J$20=\"No\"),\"No\",\"Yes\")","v":"No"},{"$f":"IF($EC$5=\"No\",\"None\",'#6'!$J$22)","v":"None"},{"$f":"IF($EC$5=\"No\",\"None\",'#6'!$J$24)","v":"None"},{"$f":"IF(OR('#6'!$E$28=\"\",'#6'!$E$28=\"No\"),\"No\",\"Yes\")","v":"No"},{"$f":"IF($EF$5=\"No\",\"None\",'#6'!$E$30)","v":"None"},{"$f":"IF(OR('#6'!$E$38=\"\",'#6'!$E$38=\"No\"),\"No\",\"Yes\")","v":"No"},{"$f":"IF($EH$5=\"No\",\"None\",'#6'!$E$40)","v":"None"},{"$f":"IF('#2'!E12=\"Renovation of existing building (consumption)\",#REF!,\"None\")","v":"None"},{"$f":"IF('#2'!E12=\"Renovation of existing building (consumption)\",#REF!,\"None\")","v":"None"},{"$f":"IF('#2'!E12=\"Renovation of existing building (consumption)\",#REF!,\"None\")","v":"None"},{"$f":"IF('#2'!E12=\"Renovation of existing building (consumption)\",#REF!,\"None\")","v":"None"},{"$f":"IF('#2'!E12=\"Renovation of existing building (consumption)\",#REF!,\"None\")","v":"None"},{"$f":"IF('#2'!E12=\"Renovation of existing building (consumption)\",#REF!,\"None\")","v":"None"},{"$f":"IF('#2'!E12=\"Renovation of existing building (consumption)\",#REF!,\"None\")","v":"None"},{"$f":"IF('#2'!E12=\"Renovation of existing building (consumption)\",#REF!,\"None\")","v":"None"},{"$f":"IF('#2'!E12=\"Renovation of existing building (consumption)\",#REF!,\"None\")","v":"None"},{"$f":"IF('#2'!E12=\"Renovation of existing building (consumption)\",#REF!,\"None\")","v":"None"},{"$f":"IF('#2'!E12=\"Renovation of existing building (consumption)\",#REF!,\"None\")","v":"None"},{"$f":"IF('#2'!E12=\"Renovation of existing building (consumption)\",#REF!,\"None\")","v":"None"},{"$f":"IF('#2'!E12=\"Renovation of existing building (consumption)\",#REF!,\"None\")","v":"None"},{"$f":"IF('#2'!E12=\"Renovation of existing building (consumption)\",#REF!,\"None\")","v":"None"},{"$f":"IF('#2'!E12=\"Renovation of existing building (consumption)\",#REF!,\"None\")","v":"None"},{"$f":"IF('#2'!E12=\"Renovation of existing building (consumption)\",#REF!,\"None\")","v":"None"},{"$f":"IF('#2'!E12=\"Renovation of existing building (consumption)\",#REF!,\"None\")","v":"None"},{"$f":"IF('#2'!E12=\"Renovation of existing building (consumption)\",#REF!,\"None\")","v":"None"},{"$f":"IF('#2'!E12=\"Renovation of existing building (consumption)\",#REF!,\"None\")","v":"None"},{"$f":"IF('#2'!E12<>\"Renovation of existing building (consumption)\",'#7a'!#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"Renovation of existing building (consumption)\",'#7a'!#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"Renovation of existing building (consumption)\",'#7a'!#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"Renovation of existing building (consumption)\",'#7a'!#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"Renovation of existing building (consumption)\",'#7a'!#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"Renovation of existing building (consumption)\",'#7a'!#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"Renovation of existing building (consumption)\",'#7a'!#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"Renovation of existing building (consumption)\",'#7a'!#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"Renovation of existing building (consumption)\",'#7a'!#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"Renovation of existing building (consumption)\",'#7a'!#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"Renovation of existing building (consumption)\",'#7a'!#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"Renovation of existing building (consumption)\",'#7a'!#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"Renovation of existing building (consumption)\",'#7a'!#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"Renovation of existing building (consumption)\",'#7a'!#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"Renovation of existing building (consumption)\",'#7a'!#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"Renovation of existing building (consumption)\",'#7a'!#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"Renovation of existing building (consumption)\",'#7a'!#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"Renovation of existing building (consumption)\",'#7a'!#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"Renovation of existing building (consumption)\",'#7a'!#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"Renovation of existing building (consumption)\",'#7a'!#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"Renovation of existing building (consumption)\",'#7a'!#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"Renovation of existing building (consumption)\",'#7a'!#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"Renovation of existing building (consumption)\",'#7a'!#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"Renovation of existing building (consumption)\",'#7a'!#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"Renovation of existing building (consumption)\",'#7a'!#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"Renovation of existing building (consumption)\",'#7a'!#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"IF('#2'!E12<>\"Renovation of existing building (consumption)\",'#7a'!#REF!,\"None\")","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["DO NOT INSERT ROWS BELOW"]
[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,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,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,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,"Created by Salvatore Carlucci"]

{"sheet":"ID DataBase","index":2,"n_rows":7,"n_cols":86,"rows_kept":7,"cut":false,"hidden":true,"merged":[[14,0,14,1],[2,2,2,3],[2,4,2,7],[2,8,2,17],[2,56,2,65],[2,18,2,39],[2,66,2,85],[0,0,0,1],[2,40,2,49],[2,50,2,51],[2,52,2,55]]}
["GREENBUILDINGplus"]
[]
[null,null,"Communication among the team members",null,"ID Facilitator",null,null,null,"Which are/were the stakeholders actually involved into the design team?",null,null,null,null,null,null,null,null,null,"Which disciplines have been included in the design team?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Explicit objectives of the building design process",null,null,null,null,null,null,null,null,null,"Control strategies",null,"Planning and schedulling design tools",null,null,null,"Building Information Model Tools - BIM",null,null,null,null,null,null,null,null,null,"Design planning"]
["Id","BUILDING NAME","Sharing information approach","Other","Was he/she appointed?","Surname, Name","Phone number","E-mail address","Architect","Constructor","Engineer","Future building manager","Interior designer","Landscape architect","Occupant","Operating staff","Owner","Other","Acoustical Engineering","Architecture","Architectural programming","Building physics","Civil/Structural/Seismic engineering","Commissioning ","Cost estimation","Electrical engineering","Environmental engineering","Fire safety engineering","HVAC engineering","Information technologies engineering","Interior design","Historic Preservation","Landscape architecture","Lighting design","Mechanical engineering","Productivity","Space Planner","Surveying ","Urban planning","Other","Aesthetics","Accessibility","Cost-effectiveness","Energy efficiency","Functionality","Historic preservation","Productivity","Security/Safety","Sustainability","Other","Have Quality Assurance and Control Plan been set?","Has a responsible been identified for each design phase?","Gantt chart","PERT and/or CPM","Building Process Manag. (BPM)","Building Information Model (BIM)","Architecture composition","Structural sizing","Building sistem syzing (MEP)","Construction management","Facility management","Architecture composition","Structural sizing","Building sistem syzing (MEP)","Construction management","Facility management","Initial planning phase - Beginning\ndate","Competition phase (if applicable) - Beginning\ndate","Concept design phase - Beginning\ndate","Detailed design phase - Beginning\ndate","Construction phase - Beginning\ndate","Initial planning phase - End\ndate","Competition phase (if applicable) - End\ndate","Concept design phase - End\ndate","Detailed design phase - End\ndate","Construction phase - End\ndate","Initial planning phase - Duration\nin day","Competition phase (if applicable) - Duration\nin day","Concept design phase - Duration\nin day","Detailed design phase - Duration\nin day","Construction phase - Duration\nin day","Initial planning phase - Estimed hours spent","Competition phase (if applicable) - Estimed hours spent","Concept design phase - Estimed hours spent","Detailed design phase - Estimed hours spent","Construction phase - Estimed hours spent"]
[1,{"$f":"'#1'!E22","v":0},{"$f":"'#ID1'!F8","v":0},{"$f":"IF('#ID1'!K8=0,\"none\",'#ID1'!K8)","v":"none"},{"$f":"'#ID1'!F12","v":0},{"$f":"'#ID1'!K12","v":0},{"$f":"'#ID1'!F14","v":0},{"$f":"'#ID1'!K14","v":0},{"$f":"'#ID1'!F18","v":0},{"$f":"'#ID1'!F20","v":0},{"$f":"'#ID1'!F22","v":0},{"$f":"'#ID1'!F24","v":0},{"$f":"'#ID1'!F26","v":0},{"$f":"'#ID1'!K18","v":0},{"$f":"'#ID1'!K20","v":0},{"$f":"'#ID1'!K22","v":0},{"$f":"'#ID1'!K24","v":0},{"$f":"'#ID1'!K26","v":0},{"$f":"'#ID1'!F30","v":0},{"$f":"'#ID1'!F32","v":0},{"$f":"'#ID1'!F34","v":0},{"$f":"'#ID1'!F36","v":0},{"$f":"'#ID1'!F38","v":0},{"$f":"'#ID1'!F40","v":0},{"$f":"'#ID1'!F42","v":0},{"$f":"'#ID1'!F44","v":0},{"$f":"'#ID1'!F46","v":0},{"$f":"'#ID1'!F48","v":0},{"$f":"'#ID1'!F50","v":0},{"$f":"'#ID1'!K30","v":0},{"$f":"'#ID1'!K32","v":0},{"$f":"'#ID1'!K34","v":0},{"$f":"'#ID1'!K36","v":0},{"$f":"'#ID1'!K38","v":0},{"$f":"'#ID1'!K40","v":0},{"$f":"'#ID1'!K42","v":0},{"$f":"'#ID1'!K44","v":0},{"$f":"'#ID1'!K46","v":0},{"$f":"'#ID1'!K48","v":0},{"$f":"'#ID1'!K50","v":0},{"$f":"'#ID2'!F8","v":0},{"$f":"'#ID2'!F10","v":0},{"$f":"'#ID2'!F12","v":0},{"$f":"'#ID2'!F14","v":0},{"$f":"'#ID2'!F16","v":0},{"$f":"'#ID2'!O8","v":0},{"$f":"'#ID2'!O10","v":0},{"$f":"'#ID2'!O12","v":0},{"$f":"'#ID2'!O14","v":0},{"$f":"'#ID2'!O16","v":0},{"$f":"'#ID2'!F20","v":0},{"$f":"'#ID2'!O20","v":0},{"$f":"'#ID2'!F25","v":0},{"$f":"'#ID2'!F27","v":0},{"$f":"'#ID2'!O25","v":0},{"$f":"'#ID2'!O27","v":0},{"$f":"'#ID2'!F33","v":0},{"$f":"'#ID2'!F35","v":0},{"$f":"'#ID2'!F37","v":0},{"$f":"'#ID2'!F39","v":0},{"$f":"'#ID2'!F41","v":0},{"$f":"'#ID2'!O33","v":0},{"$f":"'#ID2'!O35","v":0},{"$f":"'#ID2'!O37","v":0},{"$f":"'#ID2'!O39","v":0},{"$f":"'#ID2'!O41","v":0},{"$f":"'#ID2'!F47","v":"00:00:00"},{"$f":"'#ID2'!F49","v":"00:00:00"},{"$f":"'#ID2'!F51","v":"00:00:00"},{"$f":"'#ID2'!F53","v":"00:00:00"},{"$f":"'#ID2'!F55","v":"00:00:00"},{"$f":"'#ID2'!H47","v":"00:00:00"},{"$f":"'#ID2'!H49","v":"00:00:00"},{"$f":"'#ID2'!H51","v":"00:00:00"},{"$f":"'#ID2'!H53","v":"00:00:00"},{"$f":"'#ID2'!H55","v":"00:00:00"},{"$f":"'#ID2'!J47","v":0},{"$f":"'#ID2'!J49","v":0},{"$f":"'#ID2'!J51","v":0},{"$f":"'#ID2'!J53","v":0},{"$f":"'#ID2'!J55","v":0},{"$f":"'#ID2'!L47","v":0},{"$f":"'#ID2'!L49","v":0},{"$f":"'#ID2'!L51","v":0},{"$f":"'#ID2'!L53","v":0},{"$f":"'#ID2'!L55","v":0}]
["DO NOT INSERT ROWS BELOW"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Created by Salvatore Carlucci"]

{"sheet":"Welcome","index":3,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,3,1],[4,1,6,1]]}
[]
[null,"The European GreenBuilding Award"]
[]
[]
[null,"The GreenBuilding Integrated Design Award"]

{"sheet":"Instruction","index":4,"n_rows":54,"n_cols":16,"rows_kept":54,"cut":false,"hidden":false,"merged":[[37,15,41,15]]}
[]
[null," Generell Intructions"]
[]
[]
[]
[null,null,"Overview and Description"]
[]
[null,null,"Different types of fields"]
[]
[null,null,null,null,"Fill in !"]
[]
[null,null,null,null,"will be calculated automatically / is determined"]
[]
[null,null,null,null,"important results"]
[]
[]
[]
[]
[]
[null,null,"Worksheets",null,null,null,null,null,null,null,null,null,null,null,null,"Compulsory?"]
[]
[null,null,"Short Description",null,"Summarizes the most important results",null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,"#1",null,"Organization and Building Generell Information",null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,"#2",null,"Detailled Building Information",null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,"#3",null,"Building Envelope",null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,"#4",null,"Building Systems in Final Status or After Renovation",null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,"#4a",null,"Building Systems Before Renovation"]
[]
[null,null,"#5",null,"Electric installed power",null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,"#6",null,"Special Plant Systems in Final Status or After Renovation",null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,"#7a",null,"Energy Summary Based on Legal Values for New Buildings - Austrian Project",null,null,null,null,null,null,null,null,null,null,"X"]
[]
[null,null,"#7b",null,"Energy Summary Based on Legal Values for Renovations - Austrian Project"]
[]
[null,null,"#7c",null,"Energy Summary Based on Legal Values - International Projects"]
[]
[null,null,"#8",null,"Energy Management",null,null,null,null,null,null,null,null,null,null,"X"]
[]
[]
[]
[]
[]
[]
[]
[null,"1) Instructions & notes"]
[]
[null,"(0)","Footnote... "]

{"sheet":"Short Description","index":5,"n_rows":341,"n_cols":18,"rows_kept":341,"cut":false,"hidden":false,"merged":[[7,4,7,10],[58,2,68,10],[9,4,9,10],[27,4,27,10],[25,4,25,10],[40,2,40,3],[38,6,38,8],[29,4,30,10],[34,4,34,5],[13,4,13,10],[23,4,23,10],[21,4,21,10],[19,4,19,10],[17,4,17,10],[15,4,15,10],[40,10,42,10]]}
[]
[null,"EU Green Building Short Description"]
[]
[]
[]
[null,null,"EU Green Building Partner"]
[]
[null,null,"Organization name and adress",null,{"$f":"IF('#1'!E10:I10=\"\",\"\",CONCATENATE('#1'!E10:I10,\", \",'#1'!E14:G14,\" \",'#1'!I14,\", \",'#1'!E16,\" \",'#1'!G16:G16,\", \",'#1'!E18:I18))","v":""}]
[]
[null,null,"Project name and address",null,{"$f":"IF('#1'!E22:I22=\"\",\"\",CONCATENATE('#1'!E22:I22,\", \",'#1'!E24:G24,\" \",'#1'!I24,\", \",'#1'!E26,\" \",'#1'!G26:G26,\", \",'#1'!E28:I28))","v":""}]
[]
[null,null,"Project Information"]
[]
[null,null,"Building Type",null,{"$f":"'#2'!E8:I8","v":0}]
[]
[null,null,"New Building / Refurbishment",null,{"$f":"'#2'!E12","v":0}]
[]
[null,null,"Year bin of Construction",null,{"$f":"'#2'!E10:I10","v":0}]
[]
[null,null,"Year of Renovation",null,{"$f":"'#2'!E14:I14","v":0}]
[]
[null,null,"Gross floor area (heated)",null,{"$f":"CONCATENATE('#2'!W22,\" m²\")","v":" m²"}]
[]
[null,null,"Gross building volume (heated)",null,{"$f":"CONCATENATE('#2'!E34:I34,\" m³\")","v":" m³"}]
[]
[null,null,"Number of floors"]
[]
[null,null,"Prevalent Use (if applicable)"]
[]
[null,null,"Short Description",null,{"$f":"IF('#2'!C38=\"compulsory\",\"\",'#2'!C38)","v":0}]
[]
[]
[null,null,"Energy Audit"]
[]
[null,null,"according to form",null,null,null,null,"EPC according to",null,null,{"$f":"IF(E35=R86,'#7a'!M10,IF(E35=R87,'#7b'!M10,\"-\"))","v":"-"}]
[]
[null,null,"Lighting Energy Demand is calculated",null,null,{"$f":"IF(E35=R86,'#7a'!G14,IF(E35=R87,'#7b'!G14,\"-\"))","v":"-"}]
[]
[null,null,"Energy Performance",null,null,null,"Legal Values or Before Ren.",null,null,"Savings [%]"]
[]
[null,null,{"$f":"IF(OR(E35=R86,E35=R87),IF(K35=\"OIB RL6-2015\",\"Ref-HWB Reference Climate:\",\"Annual heating demand (HWB*ref):\"),\"FEC for Heating:\")","v":"FEC for Heating:"},null,{"$f":"IF(OR(E35=R86,E35=R87),\"kWh/m³a\",\"kWh/a\")","v":"kWh/a"},{"$f":"IF($E$35=\"\",\"\",IF($E$35=$R$86,M112,IF($E$35=$R$87,M120,M128)))","v":""},null,{"$f":"IF($E$35=\"\",\"\",IF($E$35=$R$86,N112,IF($E$35=$R$87,N120,N128)))","v":""},null,{"$f":"IF($E$35=\"\",\"\",IF($E$35=$R$86,O112,IF($E$35=$R$87,O120,O128)))","v":""},"Seek a minimum of\n25 % savings!*)"]
[]
[null,null,{"$f":"IF(OR(E35=R86,E35=R87),IF(K35=\"OIB RL6-2015\",\"Annual cooling demand (KB*):\",\"Annual cooling demand (KB*ref):\"),\"FEC for Cooling & Dehumidification:\")","v":"FEC for Cooling & Dehumidification:"},null,{"$f":"IF(OR(E35=R86,E35=R87),\"kWh/m³a\",\"kWh/a\")","v":"kWh/a"},{"$f":"IF($E$35=\"\",\"\",IF($E$35=$R$86,M113,IF($E$35=$R$87,M121,M129)))","v":""},null,{"$f":"IF($E$35=\"\",\"\",IF($E$35=$R$86,N113,IF($E$35=$R$87,N121,N129)))","v":""},null,{"$f":"IF($E$35=\"\",\"\",IF($E$35=$R$86,O113,IF($E$35=$R$87,O121,O129)))","v":""}]
[]
[null,null,{"$f":"IF(OR(E35=R86,E35=R87),\"Annual heating demand (HWB):\",\"FEC for Heating:\")","v":"FEC for Heating:"},null,"kWh/m²a ",{"$f":"IF($E$35=\"\",\"\",IF($E$35=$R$86,M114,IF($E$35=$R$87,M122,M130)))","v":""}]
[]
[null,null,{"$f":"IF(OR(E35=R86,E35=R87),\"Annual cooling demand (KB):\",\"FEC for Cooling & Dehumidification:\")","v":"FEC for Cooling & Dehumidification:"},null,"kWh/m²a ",{"$f":"IF($E$35=\"\",\"\",IF($E$35=$R$86,M115,IF($E$35=$R$87,M123,M131)))","v":""}]
[]
[null,null,"Lighting energy demand (BelEB):",null,{"$f":"IF(OR(E35=R86,E35=R87),\"kWh/m²a \",\"kWh/a\")","v":"kWh/a"},{"$f":"IF($E$35=\"\",\"\",IF($E$35=$R$86,M116,IF($E$35=$R$87,M124,M132)))","v":""},null,{"$f":"IF($E$35=\"\",\"\",IF($E$35=$R$86,N116,IF($E$35=$R$87,N124,N132)))","v":""}]
[]
[null,null,null,null,null,"LENI-Benchmark",null,{"$f":"IF($E$35=\"\",\"\",IF($E$35=$R$86,O116,IF($E$35=$R$87,O124,O132)))","v":""}]
[]
[null,null,"Total end energy demand:",null,{"$f":"IF(OR(E35=R86,E35=R87),\"kWh/m²a \",\"kWh/a\")","v":"kWh/a"},{"$f":"IF($E$35=\"\",\"\",IF($E$35=$R$86,M117,IF($E$35=$R$87,M125,M133)))","v":""},null,{"$f":"IF($E$35=\"\",\"\",IF($E$35=$R$86,N117,IF($E$35=$R$87,N125,N133)))","v":""},null,{"$f":"IF($E$35=\"\",\"\",IF($E$35=$R$86,O117,IF($E$35=$R$87,O125,O133)))","v":""},{"$f":"IF(J53=\"\",\"\",IF(J53=\"-\",\"\",IF(J53=\"#NV\",\"\",IF(J53>=24.5%,\"a\",\"r\"))))","v":""}]
[]
[null,null,"Total primary energy demand:",null,{"$f":"IF(OR(E35=R86,E35=R87),\"kWh/m²a \",\"kWh/a\")","v":"kWh/a"},{"$f":"IF($E$35=\"\",\"\",IF($E$35=$R$86,M118,IF($E$35=$R$87,M126,M134)))","v":""},null,{"$f":"IF($E$35=\"\",\"\",IF($E$35=$R$86,\"\",IF($E$35=$R$87,\"\",N134)))","v":""},null,{"$f":"IF($E$35=\"\",\"\",IF($E$35=$R$86,\"\",IF($E$35=$R$87,\"\",O134)))","v":""},{"$f":"IF(J55=\"\",\"\",IF(J55=\"-\",\"\",IF(J55=\"#NV\",\"\",IF(J55>=24.5%,\"a\",\"r\"))))","v":""}]
[null,null,"*) Savings of 25 % are not mandatory for EU Green Building standard, but are highly recommended."]
[null,null,"Main measures / fields of action (Action Plan)"]
[]
[null,null,"compulsory (including Heating/building envelope, Cooling, Lighting, Ventilation, Electrical Equipment, Management):\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E35=R86,1,IF(E35=R87,2,3))","v":3}]
[null,null,"#7a","OIB","BelEB exakt?","Value",null,null,null,"#7a",null,null,"Value","Legal Value","Savings",null,null,"#7a- new building, austria"]
[null,null,"Annual heating demand (HWB*):           ","before OIB RL6-2011","no",{"$f":"'#7a'!G32","v":0},null,null,null,"Annual heating demand (HWB*):           ",null,null,{"$f":"VLOOKUP(K35,IF(E87:E92=F37,D87:F92,\"\"),3,0)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($K$35,IF(E93:E98=$F$37,D93:F98,\"\"),3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($K$35,IF(E99:E104=$F$37,D99:F104,\"\"),3,0)","v":{"$error":"#N/A"}},null,null,"#7b- refurbishment, austria"]
[null,null,null,"before OIB RL6-2011","yes",{"$f":"'#7a'!U32","v":0},null,null,null,"Annual cooling demand (KB*):",null,null,{"$f":"VLOOKUP($K$35,IF(E105:E110=$F$37,D105:F110,\"\"),3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($K$35,IF(E111:E116=$F$37,D111:F116,\"\"),3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($K$35,IF(E117:E122=$F$37,D117:F122,\"\"),3,0)","v":{"$error":"#N/A"}},null,null,"#7c- international project"]
[null,null,null,"OIB RL6-2011","no",{"$f":"'#7a'!G32","v":0},null,null,null,"Annual heating demand (HWB):     ",null,null,{"$f":"VLOOKUP($K$35,IF(E123:E128=$F$37,D123:F128,\"\"),3,0)","v":{"$error":"#N/A"}}]
[null,null,null,"OIB RL6-2011","yes",{"$f":"'#7a'!U32","v":0},null,null,null,"Annual cooling demand (KB):",null,null,{"$f":"VLOOKUP($K$35,IF(E129:E134=$F$37,D129:F134,\"\"),3,0)","v":{"$error":"#N/A"}},null,"LENI:"]
[null,null,null,"OIB RL6-2015","no",{"$f":"'#7a'!G20","v":0},null,null,null,"Lighting energy demand (BelEB):",null,null,{"$f":"VLOOKUP($K$35,IF(E135:E140=$F$37,D135:F140,\"\"),3,0)","v":{"$error":"#N/A"}},"-",{"$f":"VLOOKUP($K$35,IF(E165:E170=$F$37,D165:F170,\"\"),3,0)","v":{"$error":"#N/A"}}]
[null,null,null,"OIB RL6-2015","yes",{"$f":"'#7a'!U20","v":0},null,null,null,"Total end energy demand:",null,null,{"$f":"VLOOKUP($K$35,IF(E141:E146=$F$37,D141:F146,\"\"),3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($K$35,IF(E147:E152=$F$37,D147:F152,\"\"),3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($K$35,IF(E153:E158=$F$37,D153:F158,\"\"),3,0)","v":{"$error":"#N/A"}}]
[null,null,"Legal Value HWB*","before OIB RL6-2011","no",{"$f":"'#7a'!K32","v":0},null,null,null,"Total primary energy demand:",null,null,{"$f":"VLOOKUP($K$35,IF(E159:E164=$F$37,D159:F164,\"\"),3,0)","v":{"$error":"#N/A"}}]
[null,null,null,"before OIB RL6-2011","yes",{"$f":"'#7a'!Y32","v":0},null,null,null,"#7b",null,null,"Value","Legal Value","Savings"]
[null,null,null,"OIB RL6-2011","no",{"$f":"'#7a'!K32","v":0},null,null,null,"Annual heating demand (HWB*):           ",null,null,{"$f":"VLOOKUP($K$35,IF(E173:E178=$F$37,D173:F178,\"\"),3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($K$35,IF(E179:E184=$F$37,D179:F184,\"\"),3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($K$35,IF(E185:E190=$F$37,D185:F190,\"\"),3,0)","v":{"$error":"#N/A"}}]
[null,null,null,"OIB RL6-2011","yes",{"$f":"'#7a'!Y32","v":0},null,null,null,"Annual cooling demand (KB*):",null,null,{"$f":"VLOOKUP($K$35,IF(E191:E196=$F$37,D191:F196,\"\"),3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($K$35,IF(E197:E202=$F$37,D197:F202,\"\"),3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($K$35,IF(E203:E208=$F$37,D203:F208,\"\"),3,0)","v":{"$error":"#N/A"}}]
[null,null,null,"OIB RL6-2015","no",{"$f":"'#7a'!K20","v":0},null,null,null,"Annual heating demand (HWB):     ",null,null,{"$f":"VLOOKUP($K$35,IF(E209:E214=$F$37,D209:F214,\"\"),3,0)","v":{"$error":"#N/A"}}]
[null,null,null,"OIB RL6-2015","yes",{"$f":"'#7a'!Y20","v":0},null,null,null,"Annual cooling demand (KB):",null,null,{"$f":"VLOOKUP($K$35,IF(E215:E220=$F$37,D215:F220,\"\"),3,0)","v":{"$error":"#N/A"}}]
[null,null,"Percentage Savings","before OIB RL6-2011","no",{"$f":"'#7a'!Q32","v":""},null,null,null,"Lighting energy demand (BelEB):",null,null,{"$f":"VLOOKUP($K$35,IF(E221:E226=$F$37,D221:F226,\"\"),3,0)","v":{"$error":"#N/A"}},"-",{"$f":"VLOOKUP($K$35,IF(E251:E256=$F$37,D251:F256,\"\"),3,0)","v":{"$error":"#N/A"}}]
[null,null,null,"before OIB RL6-2011","yes",{"$f":"'#7a'!AE32","v":""},null,null,null,"Total end energy demand:",null,null,{"$f":"VLOOKUP($K$35,IF(E227:E232=$F$37,D227:F232,\"\"),3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($K$35,IF(E233:E238=$F$37,D233:F238,\"\"),3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($K$35,IF(E239:E244=$F$37,D239:F244,\"\"),3,0)","v":{"$error":"#N/A"}}]
[null,null,null,"OIB RL6-2011","no",{"$f":"'#7a'!Q32","v":""},null,null,null,"Total primary energy demand:",null,null,{"$f":"VLOOKUP($K$35,IF(E245:E250=$F$37,D245:F250,\"\"),3,0)","v":{"$error":"#N/A"}}]
[null,null,null,"OIB RL6-2011","yes",{"$f":"'#7a'!AE32","v":""},null,null,null,"#7c",null,null,"Value","Legal Value","Savings"]
[null,null,null,"OIB RL6-2015","no",{"$f":"'#7a'!Q20","v":""},null,null,null,"Annual heating demand (HWB*):           ",null,null,{"$f":"'#7c'!F16","v":0},{"$f":"'#7c'!H16","v":0},{"$f":"'#7c'!J16","v":""}]
[null,null,null,"OIB RL6-2015","yes",{"$f":"'#7a'!AE20","v":""},null,null,null,"Annual cooling demand (KB*):",null,null,{"$f":"'#7c'!F18","v":0},{"$f":"'#7c'!H18","v":0},{"$f":"'#7c'!J18","v":""}]
[null,null,"Annual cooling demand (KB*):","before OIB RL6-2011","no",{"$f":"'#7a'!G54","v":0},null,null,null,"Annual heating demand (HWB):     ",null,null,{"$f":"M103/'#7c'!F9","v":{"$error":"#VALUE!"}}]
[null,null,null,"before OIB RL6-2011","yes",{"$f":"'#7a'!U54","v":0},null,null,null,"Annual cooling demand (KB):",null,null,{"$f":"M104/'#7c'!F9","v":{"$error":"#VALUE!"}}]
[null,null,null,"OIB RL6-2011","no",{"$f":"'#7a'!G54","v":0},null,null,null,"Lighting energy demand (BelEB):",null,null,{"$f":"'#7c'!F24","v":0},{"$f":"'#7c'!H24","v":0},"-"]
[null,null,null,"OIB RL6-2011","yes",{"$f":"'#7a'!U54","v":0},null,null,null,"Total end energy demand:",null,null,{"$f":"'#7c'!M38","v":0},{"$f":"'#7c'!M32","v":0},{"$f":"'#7c'!M42","v":""}]
[null,null,null,"OIB RL6-2015","no",{"$f":"'#7a'!G22","v":0},null,null,null,"Total primary energy demand:",null,null,{"$f":"'#7c'!M69","v":0},{"$f":"'#7c'!M67","v":0},{"$f":"'#7c'!M75","v":""}]
[null,null,null,"OIB RL6-2015","yes",{"$f":"'#7a'!U22","v":0}]
[null,null,"Legal Value KB*","before OIB RL6-2011","no",{"$f":"'#7a'!K54","v":0},null,null,null,"#7a",null,null,"Value","Legal Value","Savings"]
[null,null,null,"before OIB RL6-2011","yes",{"$f":"'#7a'!Y54","v":0},null,null,null,"Annual heating demand (HWB*):           ",null,null,{"$f":"IFERROR(M87,\"\")","v":""},{"$f":"IFERROR(N87,\"\")","v":""},""]
[null,null,null,"OIB RL6-2011","no",{"$f":"'#7a'!K54","v":0},null,null,null,"Annual cooling demand (KB*):",null,null,{"$f":"IFERROR(M88,\"\")","v":""},"",""]
[null,null,null,"OIB RL6-2011","yes",{"$f":"'#7a'!Y54","v":0},null,null,null,"Annual heating demand (HWB):     ",null,null,{"$f":"IFERROR(M89,\"\")","v":""}]
[null,null,null,"OIB RL6-2015","no",{"$f":"'#7a'!K22","v":0},null,null,null,"Annual cooling demand (KB):",null,null,"",null,"LENI:"]
[null,null,null,"OIB RL6-2015","yes",{"$f":"'#7a'!Y22","v":0},null,null,null,"Lighting energy demand (BelEB):",null,null,"","-",""]
[null,null,"Percentage Savings","before OIB RL6-2011","no",{"$f":"'#7a'!Q54","v":""},null,null,null,"Total end energy demand:",null,null,{"$f":"IFERROR(M92,\"\")","v":""},"",""]
[null,null,null,"before OIB RL6-2011","yes",{"$f":"'#7a'!AE54","v":""},null,null,null,"Total primary energy demand:",null,null,""]
[null,null,null,"OIB RL6-2011","no",{"$f":"'#7a'!Q54","v":""},null,null,null,"#7b",null,null,"Value","Legal Value","Savings"]
[null,null,null,"OIB RL6-2011","yes",{"$f":"'#7a'!AE54","v":""},null,null,null,"Annual heating demand (HWB*):           ",null,null,"","",""]
[null,null,null,"OIB RL6-2015","no",{"$f":"'#7a'!Q22","v":""},null,null,null,"Annual cooling demand (KB*):",null,null,"","",""]
[null,null,null,"OIB RL6-2015","yes",{"$f":"'#7a'!AE22","v":""},null,null,null,"Annual heating demand (HWB):     ",null,null,{"$f":"IFERROR(M97,\"\")","v":""}]
[null,null,"Annual heating demand (HWB):     ","before OIB RL6-2011","no",{"$f":"'#7a'!I34","v":""},null,null,null,"Annual cooling demand (KB):",null,null,{"$f":"IFERROR(M98,\"\")","v":""}]
[null,null,null,"before OIB RL6-2011","yes",{"$f":"'#7a'!W34","v":""},null,null,null,"Lighting energy demand (BelEB):",null,null,{"$f":"IFERROR(M99,\"\")","v":""},"-",""]
[null,null,null,"OIB RL6-2011","no",{"$f":"'#7a'!I34","v":""},null,null,null,"Total end energy demand:",null,null,{"$f":"IFERROR(M100,\"\")","v":""},{"$f":"IFERROR(N100,\"\")","v":""},""]
[null,null,null,"OIB RL6-2011","yes",{"$f":"'#7a'!W34","v":""},null,null,null,"Total primary energy demand:",null,null,{"$f":"IFERROR(M101,\"\")","v":""}]
[null,null,null,"OIB RL6-2015","no",{"$f":"'#7a'!I34","v":""},null,null,null,"#7c",null,null,"Value","Legal Value","Savings"]
[null,null,null,"OIB RL6-2015","yes",{"$f":"'#7a'!W34","v":""},null,null,null,"Annual heating demand (HWB*):           ",null,null,{"$f":"IFERROR(M103,\"\")","v":0},0,""]
[null,null,"Annual cooling demand (KB):","before OIB RL6-2011","no",{"$f":"'#7a'!I58","v":""},null,null,null,"Annual cooling demand (KB*):",null,null,0,0,""]
[null,null,null,"before OIB RL6-2011","yes",{"$f":"'#7a'!W58","v":""},null,null,null,"Annual heating demand (HWB):     ",null,null,{"$f":"IFERROR(M105,\"\")","v":""}]
[null,null,null,"OIB RL6-2011","no",{"$f":"'#7a'!I58","v":""},null,null,null,"Annual cooling demand (KB):",null,null,{"$f":"IFERROR(M106,\"\")","v":""}]
[null,null,null,"OIB RL6-2011","yes",{"$f":"'#7a'!W58","v":""},null,null,null,"Lighting energy demand (BelEB):",null,null,{"$f":"IFERROR(M107,\"\")","v":0},0,"-"]
[null,null,null,"OIB RL6-2015","no",{"$f":"'#7a'!I58","v":""},null,null,null,"Total end energy demand:",null,null,{"$f":"IFERROR(M108,\"\")","v":0},{"$f":"IFERROR(N108,\"\")","v":0},""]
[null,null,null,"OIB RL6-2015","yes",{"$f":"'#7a'!W58","v":""},null,null,null,"Total primary energy demand:",null,null,{"$f":"IFERROR(M109,\"\")","v":0},0,""]
[null,null,"Lighting energy demand (BelEB):","before OIB RL6-2011","no",{"$f":"'#7a'!I76","v":""}]
[null,null,null,"before OIB RL6-2011","yes",{"$f":"'#7a'!W76","v":""}]
[null,null,null,"OIB RL6-2011","no",{"$f":"'#7a'!I76","v":""}]
[null,null,null,"OIB RL6-2011","yes",{"$f":"'#7a'!W76","v":""}]
[null,null,null,"OIB RL6-2015","no",{"$f":"'#7a'!I76","v":""}]
[null,null,null,"OIB RL6-2015","yes",{"$f":"'#7a'!W76","v":""}]
[null,null,"Total end energy","before OIB RL6-2011","no",{"$f":"'#7a'!I86","v":""}]
[null,null,null,"before OIB RL6-2011","yes",{"$f":"'#7a'!W86","v":""}]
[null,null,null,"OIB RL6-2011","no",{"$f":"'#7a'!I86","v":""}]
[null,null,null,"OIB RL6-2011","yes",{"$f":"'#7a'!W86","v":""}]
[null,null,null,"OIB RL6-2015","no",{"$f":"'#7a'!G24","v":0}]
[null,null,null,"OIB RL6-2015","yes",{"$f":"'#7a'!U24","v":0}]
[null,null,"Legal Values","before OIB RL6-2011","no","-"]
[null,null,null,"before OIB RL6-2011","yes","-"]
[null,null,null,"OIB RL6-2011","no",{"$f":"'#7a'!K86","v":0}]
[null,null,null,"OIB RL6-2011","yes",{"$f":"'#7a'!Y86","v":0}]
[null,null,null,"OIB RL6-2015","no",{"$f":"'#7a'!K24","v":0}]
[null,null,null,"OIB RL6-2015","yes",{"$f":"'#7a'!Y24","v":0}]
[null,null,"Percentage Saving","before OIB RL6-2011","no","-"]
[null,null,null,"before OIB RL6-2011","yes","-"]
[null,null,null,"OIB RL6-2011","no",{"$f":"'#7a'!Q86","v":""}]
[null,null,null,"OIB RL6-2011","yes",{"$f":"'#7a'!AE86","v":""}]
[null,null,null,"OIB RL6-2015","no",{"$f":"'#7a'!Q24","v":""}]
[null,null,null,"OIB RL6-2015","yes",{"$f":"'#7a'!AE24","v":""}]
[null,null,"Total primary energy demand:","before OIB RL6-2011","no","not available"]
[null,null,null,"before OIB RL6-2011","yes","not available"]
[null,null,null,"OIB RL6-2011","no",{"$f":"'#7a'!I88","v":""}]
[null,null,null,"OIB RL6-2011","yes",{"$f":"'#7a'!W88","v":""}]
[null,null,null,"OIB RL6-2015","no",{"$f":"'#7a'!I88","v":""}]
[null,null,null,"OIB RL6-2015","yes",{"$f":"'#7a'!W88","v":""}]
[null,null,"LENI-Benchmark","before OIB RL6-2011","no",{"$f":"'#7a'!Q76/'#7a'!G10","v":{"$error":"#VALUE!"}}]
[null,null,null,"before OIB RL6-2011","yes",{"$f":"'#7a'!AE76/'#7a'!G10","v":{"$error":"#VALUE!"}}]
[null,null,null,"OIB RL6-2011","no",{"$f":"'#7a'!Q76/'#7a'!G10","v":{"$error":"#VALUE!"}}]
[null,null,null,"OIB RL6-2011","yes",{"$f":"'#7a'!AE76/'#7a'!G10","v":{"$error":"#VALUE!"}}]
[null,null,null,"OIB RL6-2015","no",{"$f":"'#7a'!Q76/'#7a'!G10","v":{"$error":"#VALUE!"}}]
[null,null,null,"OIB RL6-2015","yes",{"$f":"'#7a'!AE76/'#7a'!G10","v":{"$error":"#VALUE!"}}]
[]
[null,null,"#7b"]
[null,null,"Annual heating demand (HWB*):           ","before OIB RL6-2011","no",{"$f":"'#7b'!G32","v":0}]
[null,null,null,"before OIB RL6-2011","yes",{"$f":"'#7b'!U32","v":0}]
[null,null,null,"OIB RL6-2011","no",{"$f":"'#7b'!G32","v":0}]
[null,null,null,"OIB RL6-2011","yes",{"$f":"'#7b'!U32","v":0}]
[null,null,null,"OIB RL6-2015","no","-"]
[null,null,null,"OIB RL6-2015","yes","-"]
[null,null,"Before Refurbishment","before OIB RL6-2011","no",{"$f":"'#7b'!AM32","v":0}]
[null,null,null,"before OIB RL6-2011","yes",{"$f":"'#7b'!AX32","v":0}]
[null,null,null,"OIB RL6-2011","no",{"$f":"'#7b'!AM32","v":0}]
[null,null,null,"OIB RL6-2011","yes",{"$f":"'#7b'!AX32","v":0}]
[null,null,null,"OIB RL6-2015","no","-"]
[null,null,null,"OIB RL6-2015","yes","-"]
[null,null,"Percentage Savings","before OIB RL6-2011","no",{"$f":"'#7b'!BJ32","v":""}]
[null,null,null,"before OIB RL6-2011","yes",{"$f":"'#7b'!BJ32","v":""}]
[null,null,null,"OIB RL6-2011","no",{"$f":"'#7b'!BJ32","v":""}]
[null,null,null,"OIB RL6-2011","yes",{"$f":"'#7b'!BJ32","v":""}]
[null,null,null,"OIB RL6-2015","no","-"]
[null,null,null,"OIB RL6-2015","yes","-"]
[null,null,"Annual cooling demand (KB*):","before OIB RL6-2011","no",{"$f":"'#7b'!G54","v":0}]
[null,null,null,"before OIB RL6-2011","yes",{"$f":"'#7b'!U54","v":0}]
[null,null,null,"OIB RL6-2011","no",{"$f":"'#7b'!G54","v":0}]
[null,null,null,"OIB RL6-2011","yes",{"$f":"'#7b'!U54","v":0}]
[null,null,null,"OIB RL6-2015","no","-"]
[null,null,null,"OIB RL6-2015","yes","-"]
[null,null,"Before Refurbishment","before OIB RL6-2011","no",{"$f":"'#7b'!AM54","v":0}]
[null,null,null,"before OIB RL6-2011","yes",{"$f":"'#7b'!AX54","v":0}]
[null,null,null,"OIB RL6-2011","no",{"$f":"'#7b'!AM54","v":0}]
[null,null,null,"OIB RL6-2011","yes",{"$f":"'#7b'!AX54","v":0}]
[null,null,null,"OIB RL6-2015","no","-"]
[null,null,null,"OIB RL6-2015","yes","-"]
[null,null,"Percentage Savings","before OIB RL6-2011","no",{"$f":"'#7b'!BJ54","v":""}]
[null,null,null,"before OIB RL6-2011","yes",{"$f":"'#7b'!BJ54","v":""}]
[null,null,null,"OIB RL6-2011","no",{"$f":"'#7b'!BJ54","v":""}]
[null,null,null,"OIB RL6-2011","yes",{"$f":"'#7b'!BJ54","v":""}]
[null,null,null,"OIB RL6-2015","no","-"]
[null,null,null,"OIB RL6-2015","yes","-"]
[null,null,"Annual heating demand (HWB):     ","before OIB RL6-2011","no",{"$f":"'#7b'!I34","v":""}]
[null,null,null,"before OIB RL6-2011","yes",{"$f":"'#7b'!W34","v":""}]
[null,null,null,"OIB RL6-2011","no",{"$f":"'#7b'!I34","v":""}]
[null,null,null,"OIB RL6-2011","yes",{"$f":"'#7b'!W34","v":""}]
[null,null,null,"OIB RL6-2015","no",{"$f":"'#7b'!I34","v":""}]
[null,null,null,"OIB RL6-2015","yes",{"$f":"'#7b'!W34","v":""}]
[null,null,"Annual cooling demand (KB):","before OIB RL6-2011","no",{"$f":"'#7b'!I58","v":""}]
[null,null,null,"before OIB RL6-2011","yes",{"$f":"'#7b'!W58","v":""}]
[null,null,null,"OIB RL6-2011","no",{"$f":"'#7b'!I58","v":""}]
[null,null,null,"OIB RL6-2011","yes",{"$f":"'#7b'!W58","v":""}]
[null,null,null,"OIB RL6-2015","no",{"$f":"'#7b'!I58","v":""}]
[null,null,null,"OIB RL6-2015","yes",{"$f":"'#7b'!W58","v":""}]
[null,null,"Lighting energy demand (BelEB):","before OIB RL6-2011","no",{"$f":"'#7b'!I76","v":""}]
[null,null,null,"before OIB RL6-2011","yes",{"$f":"'#7b'!W76","v":""}]
[null,null,null,"OIB RL6-2011","no",{"$f":"'#7b'!I76","v":""}]
[null,null,null,"OIB RL6-2011","yes",{"$f":"'#7b'!W76","v":""}]
[null,null,null,"OIB RL6-2015","no",{"$f":"'#7b'!I76","v":""}]
[null,null,null,"OIB RL6-2015","yes",{"$f":"'#7b'!W76","v":""}]
[null,null,"Total end energy","before OIB RL6-2011","no",{"$f":"'#7b'!I86","v":""}]
[null,null,null,"before OIB RL6-2011","yes",{"$f":"'#7b'!W86","v":""}]
[null,null,null,"OIB RL6-2011","no",{"$f":"'#7b'!I86","v":""}]
[null,null,null,"OIB RL6-2011","yes",{"$f":"'#7b'!W86","v":""}]
[null,null,null,"OIB RL6-2015","no",{"$f":"'#7b'!I86","v":""}]
[null,null,null,"OIB RL6-2015","yes",{"$f":"'#7b'!W86","v":""}]
[null,null,"Before Refurbishment","before OIB RL6-2011","no",{"$f":"'#7b'!AO86","v":""}]
[null,null,null,"before OIB RL6-2011","yes",{"$f":"'#7b'!AZ86","v":""}]
[null,null,null,"OIB RL6-2011","no",{"$f":"'#7b'!AO86","v":""}]
[null,null,null,"OIB RL6-2011","yes",{"$f":"'#7b'!AZ86","v":""}]
[null,null,null,"OIB RL6-2015","no",{"$f":"'#7b'!AO86","v":""}]
[null,null,null,"OIB RL6-2015","yes",{"$f":"'#7b'!AZ86","v":""}]
[null,null,"Percentage Saving","before OIB RL6-2011","no",{"$f":"'#7b'!BJ86","v":""}]
[null,null,null,"before OIB RL6-2011","yes",{"$f":"'#7b'!BJ86","v":""}]
[null,null,null,"OIB RL6-2011","no",{"$f":"'#7b'!BJ86","v":""}]
[null,null,null,"OIB RL6-2011","yes",{"$f":"'#7b'!BJ86","v":""}]
[null,null,null,"OIB RL6-2015","no",{"$f":"'#7b'!BJ86","v":""}]
[null,null,null,"OIB RL6-2015","yes",{"$f":"'#7b'!BJ86","v":""}]
[null,null,"Total primary energy demand:","before OIB RL6-2011","no",{"$f":"'#7b'!I88","v":""}]
[null,null,null,"before OIB RL6-2011","yes",{"$f":"'#7b'!W88","v":""}]
[null,null,null,"OIB RL6-2011","no",{"$f":"'#7b'!I88","v":""}]
[null,null,null,"OIB RL6-2011","yes",{"$f":"'#7b'!W88","v":""}]
[null,null,null,"OIB RL6-2015","no",{"$f":"'#7b'!I88","v":""}]
[null,null,null,"OIB RL6-2015","yes",{"$f":"'#7b'!W88","v":""}]
[null,null,"LENI-Benchmark","before OIB RL6-2011","no",{"$f":"'#7b'!Q76","v":""}]
[null,null,null,"before OIB RL6-2011","yes",{"$f":"'#7b'!AE76","v":""}]
[null,null,null,"OIB RL6-2011","no",{"$f":"'#7b'!Q76","v":""}]
[null,null,null,"OIB RL6-2011","yes",{"$f":"'#7b'!AE76","v":""}]
[null,null,null,"OIB RL6-2015","no",{"$f":"'#7b'!Q76","v":""}]
[null,null,null,"OIB RL6-2015","yes",{"$f":"'#7b'!AE76","v":""}]
[null,null,"#7c",null,null,null,null,{"$f":"VLOOKUP($K$35,IF(E257:E262=$F$37,D257:F262,\"\"),3,0)","v":{"$error":"#N/A"}}]
[null,null,"Annual heating demand (HWB*):           ","before OIB RL6-2011","no"]
[null,null,null,"before OIB RL6-2011","yes"]
[null,null,null,"OIB RL6-2011","no"]
[null,null,null,"OIB RL6-2011","yes"]
[null,null,null,"OIB RL6-2015","no"]
[null,null,null,"OIB RL6-2015","yes"]
[null,null,"Legal Value HWB*","before OIB RL6-2011","no"]
[null,null,null,"before OIB RL6-2011","yes"]
[null,null,null,"OIB RL6-2011","no"]
[null,null,null,"OIB RL6-2011","yes"]
[null,null,null,"OIB RL6-2015","no"]
[null,null,null,"OIB RL6-2015","yes"]
[null,null,"Percentage Savings","before OIB RL6-2011","no"]
[null,null,null,"before OIB RL6-2011","yes"]
[null,null,null,"OIB RL6-2011","no"]
[null,null,null,"OIB RL6-2011","yes"]
[null,null,null,"OIB RL6-2015","no"]
[null,null,null,"OIB RL6-2015","yes"]
[null,null,"Annual cooling demand (KB*):","before OIB RL6-2011","no"]
[null,null,null,"before OIB RL6-2011","yes"]
[null,null,null,"OIB RL6-2011","no"]
[null,null,null,"OIB RL6-2011","yes"]
[null,null,null,"OIB RL6-2015","no"]
[null,null,null,"OIB RL6-2015","yes"]
[null,null,"Legal Value KB*","before OIB RL6-2011","no"]
[null,null,null,"before OIB RL6-2011","yes"]
[null,null,null,"OIB RL6-2011","no"]
[null,null,null,"OIB RL6-2011","yes"]
[null,null,null,"OIB RL6-2015","no"]
[null,null,null,"OIB RL6-2015","yes"]
[null,null,"Percentage Savings","before OIB RL6-2011","no"]
[null,null,null,"before OIB RL6-2011","yes"]
[null,null,null,"OIB RL6-2011","no"]
[null,null,null,"OIB RL6-2011","yes"]
[null,null,null,"OIB RL6-2015","no"]
[null,null,null,"OIB RL6-2015","yes"]
[null,null,"Annual heating demand (HWB):     ","before OIB RL6-2011","no"]
[null,null,null,"before OIB RL6-2011","yes"]
[null,null,null,"OIB RL6-2011","no"]
[null,null,null,"OIB RL6-2011","yes"]
[null,null,null,"OIB RL6-2015","no"]
[null,null,null,"OIB RL6-2015","yes"]
[null,null,"Annual cooling demand (KB):","before OIB RL6-2011","no"]
[null,null,null,"before OIB RL6-2011","yes"]
[null,null,null,"OIB RL6-2011","no"]
[null,null,null,"OIB RL6-2011","yes"]
[null,null,null,"OIB RL6-2015","no"]
[null,null,null,"OIB RL6-2015","yes"]
[null,null,"Lighting energy demand (BelEB):","before OIB RL6-2011","no"]
[null,null,null,"before OIB RL6-2011","yes"]
[null,null,null,"OIB RL6-2011","no"]
[null,null,null,"OIB RL6-2011","yes"]
[null,null,null,"OIB RL6-2015","no"]
[null,null,null,"OIB RL6-2015","yes"]
[null,null,"Total end energy","before OIB RL6-2011","no"]
[null,null,null,"before OIB RL6-2011","yes"]
[null,null,null,"OIB RL6-2011","no"]
[null,null,null,"OIB RL6-2011","yes"]
[null,null,null,"OIB RL6-2015","no"]
[null,null,null,"OIB RL6-2015","yes"]
[null,null,"Legal Values","before OIB RL6-2011","no"]
[null,null,null,"before OIB RL6-2011","yes"]
[null,null,null,"OIB RL6-2011","no"]
[null,null,null,"OIB RL6-2011","yes"]
[null,null,null,"OIB RL6-2015","no"]
[null,null,null,"OIB RL6-2015","yes"]
[null,null,"Percentage Saving","before OIB RL6-2011","no"]
[null,null,null,"before OIB RL6-2011","yes"]
[null,null,null,"OIB RL6-2011","no"]
[null,null,null,"OIB RL6-2011","yes"]
[null,null,null,"OIB RL6-2015","no"]
[null,null,null,"OIB RL6-2015","yes"]
[null,null,"Total primary energy demand:","before OIB RL6-2011","no"]
[null,null,null,"before OIB RL6-2011","yes"]
[null,null,null,"OIB RL6-2011","no"]
[null,null,null,"OIB RL6-2011","yes"]
[null,null,null,"OIB RL6-2015","no"]
[null,null,null,"OIB RL6-2015","yes"]
[null,null,"LENI-Benchmark","before OIB RL6-2011","no"]
[null,null,null,"before OIB RL6-2011","yes"]
[null,null,null,"OIB RL6-2011","no"]
[null,null,null,"OIB RL6-2011","yes"]
[null,null,null,"OIB RL6-2015","no"]
[null,null,null,"OIB RL6-2015","yes"]

{"sheet":"#1","index":6,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[[7,2,7,8],[19,2,19,8],[7,11,7,17],[9,4,9,8],[9,13,9,17],[11,13,11,17],[13,4,13,6],[11,4,11,8],[15,6,15,8],[27,4,27,8],[17,4,17,8],[13,13,13,17],[15,13,15,17],[17,13,17,17],[19,11,19,17],[21,11,28,17],[21,4,21,8],[23,4,23,6],[25,6,25,8]]}
[]
[null,"1) GreenBuilding Programme Application Form"]
[]
[]
[]
[null,"1.1)","Organization and building information"]
[]
[null,null,"Organization information",null,null,null,null,null,null,null,null,"GreenBuilding manager appointed by the organization"]
[]
[null,null,"Organization name",null,null,null,null,null,null,null,null,"Surname, Name"]
[]
[null,null,"Homepage address",null,null,null,null,null,null,null,null,"Function"]
[]
[null,null,"Street and number",null,null,null,null,null,null,null,null,"Phone number"]
[]
[null,null,"Area code and city",null,null,null,null,null,null,null,null,"Fax number"]
[]
[null,null,"Country",null,null,null,null,null,null,null,null,"E-mail "]
[]
[null,null,"Building information"]
[]
[null,null,"Building name (will be published!)"]
[]
[null,null,"Street and number"]
[]
[null,null,"Area code and city"]
[]
[null,null,"Country"]
[]
[]
[]
[]
[]
[]
[]
[null,"1) Instructions & notes"]
[]
[null,"(0)","Requirements in red are compulsory."]

{"sheet":"#2","index":7,"n_rows":89,"n_cols":23,"rows_kept":89,"cut":false,"hidden":false,"merged":[[68,2,68,17],[37,2,42,17],[15,13,15,17],[9,4,9,8],[33,4,33,8],[11,4,11,8],[13,4,13,8],[19,5,19,7],[23,5,23,7],[27,5,27,7],[29,4,29,8],[25,4,25,8],[21,4,21,8],[31,4,31,8],[7,4,7,8],[7,13,7,17],[9,13,9,17],[11,13,11,17],[13,13,13,17]]}
[]
[null,"2) Building Information"]
[]
[]
[]
[null,"2.1)","Information about intervention and use of the building",null,null,null,null,null,null,null,"2.2)","Information about climate and site"]
[]
[null,null,"Actual type of use",null,null,null,null,null,null,null,null,"Climate Zone"]
[]
[null,null,"Year of construction",null,null,null,null,null,null,null,null,"Type of surrounding"]
[]
[null,null,"Type of intervention (and type of baseline)",null,null,null,null,null,null,null,null,"Altitude above sea level(1) (m)"]
[]
[null,null,"Year of renovation(4)",null,null,null,null,null,null,null,null,"Heating Degree Days(2) (DDh)"]
[]
[null,null,"Typical period of use",null,"Days/Year",null,null,"Hours/Day",null,null,null,"Cooling Degree Days(2) (DDc)"]
[]
[null,"2.3)","Dimensional information on the building in final status or after renovation"]
[]
[null,null,"Heated floor surface type(3)",null,null,"Net to Gross ratio"]
[]
[null,null,{"$f":"IF(E20='3_Data collection'!$A$76,\"   Heating system not installed\",\"   \"&\"Heated \"&LOWER(E20)&\" floor area (m²)\")","v":"   Heated  floor area (m²)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E20=\"Gross\",E22,IF(E20=\"Net\",E22*I20,\"\"))","v":""}]
[]
[null,null,"Cooled floor surface type(3)",null,null,"Net to Gross ratio"]
[]
[null,null,{"$f":"IF(E24='3_Data collection'!$A$76,\"   Cooling system not installed\",\"   \"&\"Cooled \"&LOWER(E24)&\" floor area (m²)\")","v":"   Cooled  floor area (m²)"}]
[]
[null,null,"Lighted/electric equipped floor surface type(3)",null,null,"Net to Gross ratio"]
[]
[null,null,{"$f":"IF(E28='3_Data collection'!$A$76,\"   Lighting/electric system not installed\",\"   \"&\"Lighted/electric \"&LOWER(E28)&\" floor area (m²)\")","v":"   Lighted/electric  floor area (m²)"}]
[]
[null,null,"Heated net volume (m3)"]
[]
[null,null,"Heated gross volume (m3)"]
[]
[null,"2.4)","Short description of the building and the intervention (maximum 1500 characters) - will be published",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(1500-LEN(C38)>=0,\"Remaining characters: \"&1500-LEN(C38),\"Text too long of \"&LEN(C38)-1500)","v":"Remaining characters: 1500"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2) Instructions & notes"]
[]
[null,"(0)","Requirements in red are compulsory."]
[null,"(1)","\"Altitude above sea level\" and \"Latitude\" entered according to Google Earth or EPC."]
[null,"(2)","\"Heating Degree Days\" and \"Cooling Degree Days\" can be taken from the EPC or calculated through a web-based tool. Fullow the instructions:"]
[null,null,"1) open your browser (Explorer, Firefox, Netscape, Google Chrome, ...)"]
[null,null,"2) go to http://www.degreedays.net "]
[null,null,"3) chose the weather station"]
[null,null,"4) chose between heating or cooling"]
[null,null,"5) set the base temperature 18°C for heating, for cooling"]
[null,null,"6) set breakdown to average"]
[null,null,"7) set the period covered to last 2 years"]
[null,null,"8) push Generate Degree Days"]
[null,null,"9) the tool takes some seconds at the end, download a csv file"]
[null,null,"10) open the csv file and the total value is the number of degree days wanted."]
[null,"(3)","\"Surface floor type\" might assume three values: Not present, Gross and Net"]
[null,null,"Not present - you have to chose this categoly if the corresponding energy use has not been calculated."]
[null,null,"                     i.e. if a cooling plant is not present in your building, you don't have a demand of energy for cooling and so  \"Cooled floor surface type\" must be set to \"Not present\""]
[null,null,"If you have an evaluated demand of energy for heating, cooling or electricity you must enter floor area. Two types of floor area can be entered: Gross floor area and Net floor area."]
[null,null,"Gross floor area - It includes total floor area of all floors including basements, mezzanines, penthouses, mechanical, electrical, and communications spaces, and enclosed loading "]
[null,null,"                     docks. It is measured from the exterior surfaces of all enclosing walls of the building."]
[null,null,"Net floor area -  It refers to those portions of the facility available for use for program operations and other necessary support functions. It is measured from the inside surface of the "]
[null,null,"                     enclosing walls of the building. Exterior walls, interior partitions, columns, structural members and plumbing chases are excluded from the net floor area."]
[null,null,"If you enter Gross floor area you have to enter the \"Net to Gross ratio\". It is the expressed as the percentage of Net floor area to Gross flor area. Reference values follow under."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"source: http://www.abor.asu.edu/1_the_regents/cost_control/chapter_two(A).pdf"]
[]
[null,null,"The calculation of Net floor area garantees a more precise evaluation of energy performance of building."]
[null,"(4)","To be entered only for renovations."]

{"sheet":"#3","index":8,"n_rows":97,"n_cols":19,"rows_kept":97,"cut":false,"hidden":false,"merged":[[47,15,47,18],[41,10,41,11],[43,10,43,11],[47,10,47,11],[7,2,7,4],[7,6,7,8],[7,10,7,13],[7,15,7,18],[35,6,35,8],[30,2,30,3],[30,15,30,16],[32,15,32,16],[39,2,39,4],[39,6,39,8],[39,10,39,13],[39,15,39,18],[32,2,32,3],[30,6,30,7],[32,6,32,7],[30,10,30,11],[32,10,32,11],[49,10,49,11],[56,2,56,3],[41,15,41,16],[41,2,41,3],[43,2,43,3],[47,2,47,3],[49,2,49,3],[41,6,41,7],[43,6,43,7],[47,6,47,7],[49,6,49,7],[52,15,52,18],[52,6,52,8],[49,15,49,18],[43,15,43,18],[45,15,45,18]]}
[]
[null,"3) Building Envelope"]
[]
[]
[]
[null,"3.1)","Thermal properties of opaque components in final status or after renovation(1)"]
[]
[null,null,"Roof",null,null,null,"External walls",null,null,null,"Basement",null,null,null,null,"Partitions*"]
[null,null,"Building Component","U-value (kWh/m²a)","Area (m²)",null,"Building Component","U-value (kWh/m²a)","Area (m²)",null,"Building Component","U-value (kWh/m²a)","Temperature correction factor","Area (m²)",null,"Building Component","U-value (kWh/m²a)","Temperature correction factor","Area (m²)"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[]
[null,null,"Average(1) U-value (W/m2/K)",null,{"$f":"IF(OR(D10=\"\",E10=\"\"),0,SUMPRODUCT(D10:D29,E10:E29)/E33)","v":0},null,"Average(1) U-value (W/m2/K)",null,{"$f":"IF(OR(H10=\"\",I10=\"\"),0,SUMPRODUCT(H10:H29,I10:I29)/I33)","v":0},null,"Average(1) U-value (W/m2/K)",null,null,{"$f":"IF(OR(L10=\"\",N10=\"\"),0,SUMPRODUCT(L10:L29,N10:N29,M10:M29)/N33)","v":0},null,"Average(1) U-value (W/m2/K)",null,null,{"$f":"IF(OR(Q10=\"\",S10=\"\"),0,SUMPRODUCT(Q10:Q29,S10:S29,R10:R29)/S33)","v":0}]
[]
[null,null,"Area (m2)",null,{"$f":"IF(OR(D10=\"\",E10=\"\"),0,SUM(E10:E29))","v":0},null,"Area (m2)",null,{"$f":"IF(OR(H10=\"\",I10=\"\"),0,SUM(I10:I29))","v":0},null,"Area (m2)",null,null,{"$f":"IF(OR(L10=\"\",N10=\"\"),0,SUM(N10:N29))","v":0},null,"Area (m2)",null,null,{"$f":"IF(OR(Q10=\"\",S10=\"\"),0,SUM(S10:S29))","v":0}]
[]
[]
[null,null,"Data souce for opaque envelope data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"* \"Partitions\" is used to refer to all the walls which separate conditioned from unconditioned spaces."]
[]
[null,"3.2)","Thermal properties of transparent components in final status or after renovation(2)"]
[]
[null,null,"Type 1 window",null,null,null,"Type 2 window",null,null,null,"Type 3 window",null,null,null,null,"Other transparent components (windows & doors)"]
[]
[null,null,"Average U-value Window (W/m2/K)",null,null,null,"Average U-value Window (W/m2/K)",null,null,null,"Average U-value Window (W/m2/K)",null,null,null,null,"Area (m²)"]
[]
[null,null,"Energy transmittance, g (%)",null,null,null,"Energy transmittance, g (%)",null,null,null,"Energy transmittance, g (%)"]
[]
[null,null,"Visible transmittance (%)",null,null,null,"Visible transmittance (%)",null,null,null,"Visible transmittance (%)"]
[]
[null,null,"Area (m2)",null,null,null,"Area (m2)",null,null,null,"Area (m2)"]
[]
[null,null,"% of the whole glazed area",null,null,null,"% of the whole glazed area",null,null,null,"% of the whole glazed area"]
[]
[]
[null,null,"Data souce for transparent envelope data"]
[]
[null,"3.3)","SUMMARY"]
[]
[null,null,"Envelope U-value (W/m2/K)",null,{"$f":"IF(E31=\"\",\"\",IF(AND(E33=0,I33=0,N33=0,S33=0,E48=0,I48=0,N48=0),0,(E33*E31+I33*I31+N33*N31+S33*S31+E48*E42+I48*I42+N48*N42)/(E33+I33+N33+S33+E48+I48+N48)))","v":0},null,null,"Total lossing area (m2)",{"$f":"IF(AND(OR(E50=\"\",E50=0),OR(I50=\"\",I50=0),OR(N50=\"\",N50=0)),\"\",E33+I33+N33+S33+(E48+I48+N48)/(E50+I50+N50))","v":""},null,null,null,"Gross heating volume (m3)",{"$f":"IF('#2'!E34=\"\",\"\",'#2'!E34)","v":""},null,null,null,"Shape ration (m2/m3)",{"$f":"IF(OR(I57=\"\",I57=0,N57=\"\",N57=0),\"Not evaluable\",I57/N57)","v":"Not evaluable"}]
[null,null,null,null,null,null,null,"Enveloping surface (m²)",{"$f":"IF(AND(OR(E50=\"\",E50=0),OR(I50=\"\",I50=0),OR(N50=\"\",N50=0)),\"\",E33+I33+N33+S33+(E48+I48+N48)+S42)","v":""}]
[]
[]
[]
[]
[]
[null,"3) Instructions & notes"]
[]
[null,"(0)","Requirements in red are compulsory."]
[null,"(1)","Enter the surface weighted average U-value:"]
[]
[]
[]
[null,"(2)","Primary energy required by single energy uses in final status in case of a new building or after renovation in case of an existing building."]
[null,">","Thermal trasmittance (U-value) is the heat flux density through 1 m2 of a given structure divided by the difference in environmental temperatures of 1 K on either side of the structure"]
[null,null," in steady-state conditions."]
[null,">","U-value for opaque component of building envelope has to be calculated according to EN 6946."]
[null,">","U-value for transparent component (glazing + frame) of the building envelope has to be calculated according to EN 10077."]
[null,null,"           Therefore, the U-value for the whole unit is:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,">","Solar Heat Gain Coefficient (SHGC) is the fraction of incident solar radiation admitted through a window, both admitted through a window, both directly transmitted, and absorbed and "]
[null,null,"subsequently released inward. The lower a window's solar heat gain coefficient, the less solar heat it transmits and the greater its shading ability. "]
[null,">","Shading Coefficient (SC), or Solar factor, is the ratio of the SHGC of a certain glass to the SHGC of a baseline glass caracterized by a solar transmittance of 0,86 and a "]
[null,null,"solar assorbance (normal incidence) of 0,06 . The relationship between SC and SHGC is: SHGC = SC x 0,87."]
[null,">","Visible transmittance is a measure of the amount of visible light that passes through the glazing material of a window, door, or skylight. Visible light transmittance, or simply visible "]
[null,null,"transmittance (VT), is a fraction of the visible spectrum of sunlight (380 to 720 nanometers), weighted by the sensitivity of the human eye, which is transmitted through a window's, door's, or "]
[null,null,"skylight's glazing. A product with a higher VT transmits more visible light. VT is expressed as a number between 0 and 1."]
[null,">","Envelope U-Value is the heat loss coefficient of the building envelope, thus the average U-values of all components, opaque and transarent, of the buiding envelope weighted on single areas."]
[null,">","Shape ratio is the ratio of the whole heat loss area to heated volume."]

{"sheet":"#4","index":9,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[[33,11,33,13],[17,4,17,6],[15,11,15,13],[11,11,11,13],[17,11,17,13],[31,11,31,13],[13,2,13,3],[13,11,13,13],[13,4,13,6],[29,11,29,13],[25,4,25,6],[29,4,29,6],[25,11,25,13],[19,11,19,13],[7,4,7,6],[15,4,15,6],[27,4,27,6],[27,11,27,13],[7,11,7,13],[9,4,9,6],[11,4,11,6],[9,11,9,13]]}
[]
[null,"4) Building Systems in Final Status or After Renovation(1)"]
[]
[]
[]
[null,"4.1)","Heating",null,null,null,null,null,"4.2)","Cooling"]
[]
[null,null,"Type of use of heating production",null,null,null,null,null,null,"Cooling strategy"]
[]
[null,null,"Type of heating production system",null,null,null,null,null,null,"Type of cooling production system"]
[]
[null,null,"Other / Additional",null,null,null,null,null,null,"Other / Additional"]
[]
[null,null,"Year of installation of the heating system (a)",null,null,null,null,null,null,"Thermal comfort model"]
[]
[null,null,"Nominal heating power (kW)",null,null,null,null,null,null,"Strategy to reduce solar heat gains"]
[]
[null,null,"If boiler, nominal generation efficiency",null,null,null,null,null,null,"Nominal cooling power (kW)"]
[]
[null,null,"If heat pump, nominal COP or APF",null,null,null,null,null,null,"Seasonal Energy Efficiency Ratio (SEER)"]
[]
[null,null,"Indoor heating setpoint temperature (°C)",null,null,null,null,null,null,"Indoor cooling setpoint temperature(2) (°C)"]
[]
[null,"4.3)","Production of sanitary hot water (SHW)",null,null,null,null,null,"4.4)","Mechanical ventilation system"]
[]
[null,null,"Type of production system",null,null,null,null,null,null,"Has a ventilation system been provided?"]
[]
[null,null,"Other",null,null,null,null,null,null,"     If yes, please specify the ACR (h-1)(3)"]
[]
[null,null,"   If autonomous, nominal power (kW)",null,null,null,null,null,null,"Has an heat recovery unit been provided?"]
[]
[null,null,null,null,null,null,null,null,null,"     If yes, please specify its efficiency (%)(3)"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"4) Instructions & notes"]
[]
[null,"(0)","Requirements in red are compulsory. Please, fill in just data about installed or planned systems."]
[null,"(1)","Primary energy required by single energy uses in the final status in case of a new building or after renovation in case of an existing building."]
[null,"(2)","If adaptive comfort model has been explicited, enter in the \"Indoor cooling setpoint temperature\" cell ND and in the \"Type of temperature\" Adaptive comfort model."]
[null,"(3)","ACR: air changes per hour. If more than one mechanical ventilation system then enter aches in this form: xx / xx / xx (e.g. three ventilation systems)"]
[]
[]
[null,"COP"]
[null,"Annual Performance Factor"]

{"sheet":"#4a","index":10,"n_rows":52,"n_cols":15,"rows_kept":52,"cut":false,"hidden":false,"merged":[[7,12,7,16],[9,12,9,16],[11,12,11,16],[25,4,25,8],[40,12,40,14],[13,4,13,8],[15,4,15,8],[17,4,17,8],[32,12,32,16],[34,12,34,16],[13,12,13,16],[9,4,9,8],[7,4,7,8],[11,4,11,8],[19,4,19,8],[21,6,21,8],[15,12,15,16],[17,12,17,16],[19,12,19,16],[21,14,21,16],[25,12,25,16],[36,12,36,16],[38,12,38,16],[27,12,27,16],[32,4,32,8],[34,4,34,8],[36,4,36,8],[27,4,27,8]]}
[]
[null,"4) Building Systems Before Renovation"]
[]
[]
[]
[null,"4.1)","Heating",null,null,null,null,null,null,"4.2)","Cooling"]
[]
[null,null,"Type of use of heating production",null,null,null,null,null,null,null,"Cooling strategy"]
[]
[null,null,"Type of heating production system",null,null,null,null,null,null,null,"Type of cooling production system"]
[]
[null,null,"Other",null,null,null,null,null,null,null,"Other"]
[]
[null,null,"Age of the heating production system (a)",null,null,null,null,null,null,null,"Comfort model"]
[]
[null,null,"Nominal heating power (kW)",null,null,null,null,null,null,null,"Strategy to reduce solar heat gains"]
[]
[null,null,"If boiler, nominal generation efficiency",null,null,null,null,null,null,null,"Nominal cooling power (kW)"]
[]
[null,null,"If heat pump, nominal COP",null,null,null,null,null,null,null,"Seasonal Energy Efficiency Ratio (SEER)"]
[]
[null,null,"Indoor heating setpoint temperature (°C)",null,null,null,null,null,null,null,"Indoor cooling setpoint temperature(1) (°C)"]
[]
[null,null,"Heated floor surface type",null,null,null,"Net to Gross ratio",null,null,null,"Cooled floor surface type",null,null,null,"Net to Gross ratio"]
[]
[null,null,{"$f":"\"   \"&\"Heated \"&LOWER(E24)&\" floor area (m2)\"","v":"   Heated  floor area (m2)"},null,null,null,null,null,null,null,{"$f":"\"   \"&\"Cooled \"&LOWER(M24)&\" floor area (m²)\"","v":"   Cooled  floor area (m²)"}]
[]
[null,null,{"$f":"'#2'!C24&\" filled in Sheet #2\"","v":"Cooled floor surface type(3) filled in Sheet #2"},null,{"$f":"'#2'!E24","v":0},null,null,null,null,null,{"$f":"'#2'!C28&\" filled in Sheet #2\"","v":"Lighted/electric equipped floor surface type(3) filled in Sheet #2"},"k",{"$f":"'#2'!E28","v":0}]
[]
[]
[null,"4.3)","Production of sanitary hot water (SHW)",null,null,null,null,null,null,"4.4)","Mechanical ventilation system"]
[]
[null,null,"Type of production system",null,null,null,null,null,null,null,"Has a ventilation system been provided?"]
[]
[null,null,"Other",null,null,null,null,null,null,null,"     If yes, please specify the ACH (h-1)(2)"]
[]
[null,null,"   If autonomous, nominal power (kW)",null,null,null,null,null,null,null,"Has an heat recovery unit been provided?"]
[]
[null,null,null,null,null,null,null,null,null,null,"     If yes, please specify its efficiency (%)(2)"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"4) Instructions & notes"]
[]
[null,"(0)","Requirements in red are compulsory  |  Fill in just data about installed or planned systems"]
[null,"(1)","If adaptive comfort model has been explicited, enter in the \"Indoor cooling setpoint temperature\" cell ND and in the \"Type of temperature\" Adaptive comfort model."]
[null,"(2)","ACH: air changes per hour. If more than one mechanical ventilation system then enter aches in this form: xx / xx / xx (e.g. three ventilation systems)"]

{"sheet":"#5","index":11,"n_rows":72,"n_cols":18,"rows_kept":72,"cut":false,"hidden":false,"merged":[[18,5,18,6],[12,7,12,8],[13,11,13,12],[13,3,13,4],[14,3,14,4],[15,3,15,4],[14,5,14,6],[15,5,15,6],[13,5,13,6],[13,7,13,8],[14,7,14,8],[15,7,15,8],[16,7,16,8],[14,11,14,12],[15,11,15,12],[16,11,16,12],[8,5,8,6],[8,11,8,12],[9,11,9,12],[10,11,10,12],[11,11,11,12],[8,7,8,8],[9,7,9,8],[10,7,10,8],[11,7,11,8],[35,4,35,8],[31,4,31,8],[22,4,22,8],[29,2,29,8],[6,10,7,14],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[7,2,7,8],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[12,11,12,12],[35,13,35,14],[20,10,20,14],[24,4,24,8],[24,13,24,14],[16,3,16,4],[17,3,17,4],[18,3,18,4],[29,10,29,13],[31,13,31,14],[17,7,17,8],[18,7,18,8],[16,5,16,6],[17,5,17,6],[22,13,22,14],[17,11,17,12],[18,11,18,12]]}
[]
[null,"5) Electric installed power"]
[]
[]
[]
[null,"5.1)","Lighting"]
[null,null,null,null,null,null,null,null,null,null,"In final status or after renovation(1)"]
[null,null,"To fill in ONLY to describe the status before renovation"]
[null,null,"Building zone","Installed electric power for lighting (W/m²)",null,"Yearly operation hours (h/a)",null,{"$f":"IF(E21='3_Data collection'!$A$76,\"Lighting system not installed\",\"\"&\"Lighted \"&LOWER(E21)&\" floor area (m²)\")","v":"Lighted  floor area (m²)"},null,null,"Building zone","Installed electric power for lighting (W/m²)",null,"Yearly operation hours (h/a)",{"$f":"IF(E21='3_Data collection'!$A$76,\"Lighting system not installed\",\"\"&\"Lighted \"&LOWER(E21)&\" floor area (m²)\")","v":"Lighted  floor area (m²)"}]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[]
[null,null,"Lighted floor surface type(2)",null,null,null,"Net to Gross ratio",null,null,null,{"$f":"IF(OR(L10=\"\",N10=\"\",O10=\"\"),\"\",\"Lighted net floor area in #2 and the sum of Lighted net floor area indicated here do not match!\")","v":""}]
[]
[null,null,{"$f":"IF(E21='3_Data collection'!$A$76,\"   Lighting system not installed\",\"   \"&\"Lighted \"&LOWER(E21)&\" floor area (m2)\")","v":"   Lighted  floor area (m2)"},null,{"$f":"SUM(H10:I14)","v":0},null,null,null,null,null,"Lighted net floor area (m2)",null,null,{"$f":"IF('#2'!E30=\"\",\"\",IF('#2'!E28=\"Gross\",'#2'!E30*'#2'!$I$28,'#2'!E30))","v":""},null,null,null,{"$f":"IF(SUM(O10:O19)=N23,\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,"Installed electric power (kWh/m²a)",null,{"$f":"IF(OR(D10=\"\",F10=\"\",H10=\"\"),\"\",SUMPRODUCT(D10:E19,F10:G19,H10:I19)/SUM(H10:I19)/1000)","v":""},null,null,null,null,null,"Installed electric power (kWh/m²a)",null,null,{"$f":"IF(OR(D10=\"\",F10=\"\",H10=\"\"),\"\",SUMPRODUCT(L10:L19,N10:N19,O10:O19)/SUM(O10:O19)/1000)","v":""}]
[]
[]
[null,"5.2)","Electric equipment(3) inside heated and/or cooled spaces"]
[]
[null,null,"To fill in ONLY to describe the status before renovation",null,null,null,null,null,null,null,"In final status or after renovation(1)"]
[]
[null,null,"Installed electric power for equipment (W/m2)",null,null,null,null,null,null,null,"Installed electric power for equipment (W/m2)"]
[]
[null,null,"Electric equipped floor surface type(2)",null,null,null,"Net to Gross ratio"]
[]
[null,null,{"$f":"IF(E34='3_Data collection'!$A$76,\"   Electric system not installed\",\"   \"&\"Electric equipped \"&LOWER(E34)&\" floor area (m2)\")","v":"   Electric equipped  floor area (m2)"},null,null,null,null,null,null,null,"Electric equipped net floor area (m2)",null,null,{"$f":"IF('#2'!E30=\"\",\"\",IF('#2'!E28=\"Gross\",'#2'!E30*'#2'!$I$28,'#2'!E30))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,"5) Instructions & notes"]
[]
[null,"(0)","Requirements in red are compulsory  |  Fill in just data about installed or planned systems."]
[null,"(1)","Primary energy required by single energy uses in final status in case of a new building or after renovation in case of an existing building."]
[null,"(2)","\"Surface floor type\" might assume three values: Not present, Gross and Net"]
[null,null,"Not present - you have to chose this categoly if the corresponding energy use has not been calculated."]
[null,null,"                     i.e. if a cooling plant is not present in your building, you don't have a demand of energy for cooling and so  \"Cooled floor surface type\" must be set to \"Not present\"."]
[null,null,"If you have an evaluated demand of energy for heating, cooling or electricity you must enter floor area. Two types of floor area can be entered: Gross floor area and Net floor area."]
[null,null,"Gross floor area - It includes total floor area of all floors including basements, mezzanines, penthouses, mechanical, electrical, and communications spaces, and enclosed loading "]
[null,null,"                     docks. It is measured from the exterior surfaces of all enclosing walls of the building."]
[null,null,"Net floor area -  It refers to those portions of the facility available for use for program operations and other necessary support functions. It is measured from the inside surface of the "]
[null,null,"                     enclosing walls of the building. Exterior walls, interior partitions, columns, structural members and plumbing chases are excluded from the net floor area."]
[null,null,"Only if you enter Gross floor area you have to enter the \"Net to Gross ratio\". It is the expressed as the percentage of Net floor area to Gross flor area. Reference values follow under."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"source: http://www.abor.asu.edu/1_the_regents/cost_control/chapter_two(A).pdf"]
[]
[null,null,"The calculation of Net floor area garantees a more precise evaluation of energy performance of building."]
[null,"(2)","Electric equipment is refered to electric appliances (e.g. computers, TVs, printers, ...) inside the thermal zone."]

{"sheet":"#6","index":12,"n_rows":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[null,"6) Special Plant Systems in Final Status or After Renovation"]
[]
[]
[]
[null,"6.1)","Solar thermal collectors",null,null,null,"6.2)","Photovoltaic array"]
[]
[null,null,"Is there a solar thermal collectors?",null,null,null,null,"Is there a photovoltaic array?"]
[]
[null,null,"    If yes, specify the absorbing area (m2)",null,null,null,null,"    If yes, specify the absorbing area (m2)"]
[]
[null,null,"    If yes, specify the type of collector",null,null,null,null,"    If yes, specify the type of cell"]
[]
[null,null,"    If yes, specify nominal efficiency (%)",null,null,null,null,"    If yes, specify nominal efficiency (%)"]
[]
[null,null,null,null,null,null,null,"    If yes, specify the installed power (kW)"]
[]
[null,"6.3)","Geothermal system",null,null,null,"6.4)","Biomass system"]
[]
[null,null,"Is there a geothermal system?",null,null,null,null,"Is there a biomass boiler?"]
[]
[null,null,"    If yes, specify its typology",null,null,null,null,"    If yes, specify the type of biomass"]
[]
[null,null,"    If yes, specify the installed power (kW)",null,null,null,null,"    If yes, specify the installed power (kW)"]
[]
[null,"6.5)","Wind generators",null,null,null,"6.6)","Combined Heat and Power (CHP) system"]
[]
[null,null,"Is there a wind generation system?",null,null,null,null,"Is there a CHP system?"]
[]
[null,null,"    If yes, specify the installed power (kW)",null,null,null,null,"    If yes, specify its typology"]
[]
[null,null,null,null,null,null,null,"    If yes, efficiency for electricity (%)"]
[]
[null,null,null,null,null,null,null,"    If yes, efficiency for heat (%)"]
[]
[null,"6.7)","Hydroelectric generators",null,null,null,"6.8)","Other Renewable Energy Source"]
[]
[null,null,"Is there a hydroelectric system?",null,null,null,null,"Description"]
[]
[null,null,"    If yes, specify the installed power (kW)",null,null,null,null,"    Installed power (kW)"]
[]
[]
[]
[]
[]
[]
[null,"6) Instructions & notes"]
[]
[null,"(0)","Requirements in red are compulsory."]
[null,"(1)","Primary energy required by single energy uses in final status in case of a new building or after renovation in case of an existing building."]

{"sheet":"#7a","index":13,"n_rows":332,"n_cols":42,"rows_kept":332,"cut":false,"hidden":false,"merged":[[2,2,3,10],[158,8,158,10],[160,8,160,10],[162,8,162,10],[148,16,148,18],[150,16,150,18],[154,16,154,18],[158,16,158,18],[160,16,160,18],[162,16,162,18],[152,8,152,10],[152,16,152,18],[156,8,156,10],[156,16,156,18],[69,16,73,16],[9,12,9,14],[77,53,77,60],[89,54,91,54],[89,59,91,59],[89,60,91,60],[89,55,91,55],[89,57,91,57],[89,58,91,58],[89,56,91,56],[85,39,91,39],[285,26,285,27],[280,26,280,27],[281,26,281,27],[282,26,282,27],[283,26,283,27],[279,26,279,27],[285,12,285,13],[280,12,280,13],[170,8,170,10],[172,8,172,10],[174,8,174,10],[176,8,176,10],[279,12,279,13],[228,3,228,32],[285,4,285,5],[279,4,279,5],[280,4,280,5],[281,4,281,5],[282,4,282,5],[284,4,284,5],[283,4,283,5],[281,12,281,13],[7,6,7,14],[15,20,15,30],[69,30,73,30],[284,12,284,13],[284,26,284,27],[282,12,282,13],[283,12,283,13],[170,16,170,18],[172,16,172,18],[174,16,174,18],[176,16,176,18],[164,16,164,18],[178,16,178,18],[180,16,180,18],[95,16,95,18],[166,8,166,10],[166,16,166,18],[168,8,168,10],[168,16,168,18],[11,12,11,14],[13,12,13,14],[148,8,148,10],[150,8,150,10],[154,8,154,10],[164,8,164,10]]}
[]
[null,"7) ","Energy Summary Based on Legal Values"]
[null,null,"for New Buildings - Austrian Project"]
[]
[]
[null,"7.1)",null,"Energy Parameters (according to the Austrian Energy Performance Certificate (EPC))"]
[]
[null,null,null,"Building Type",null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,"Gross floor area (heated)","m²",null,{"$f":"'#2'!W22","v":""},null,"EPC according to"]
[]
[null,null,null,"Gross volume (heated)","m³",null,{"$f":"'#2'!E34","v":0},null,"Software for Calculation"]
[]
[null,null,null,"Lighting Energy Demand is calculated?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"With specific and accuracte calculation of BelEB"]
[]
[null,null,null,"Energy Paramters",null,null,"Reference Climate",null,"Local Climate",null,"Legal values",null,null,null,"Local Climate in kWh/a",null,"Percentage savings(4)",null,null,null,"Reference Climate",null,"Local Climate",null,"Legal values",null,null,null,"Local Climate in kWh/a",null,"Percentage savings(4)",null,null,null,null,"before OIB RL6-2011","OIB RL6-2011","OIB RL6-2015",null,"before OIB RL6-2011","OIB RL6-2011","OIB RL6-2015"]
[]
[null,null,null,"Ref-HWB (OIB RL6 2015)","kWh/m²a",null,null,null,{"$f":"IF(O20=\"\",\"\",O20/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,{"$f":"IF(OR(K20=\"\",K20=0),\"\",-(G20-K20)/K20)","v":""},null,null,null,null,null,{"$f":"IF(AC20=\"\",\"\",AC20/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,{"$f":"IF(OR(Y20=\"\",Y20=0),\"\",-(U20-Y20)/Y20)","v":""},null,null,null,null,null,null,"x",{"$f":"IF(M$10=AL$18,\"JA\",\"NEIN\")","v":"NEIN"},{"$f":"IF($M$10=AN18,\"JA\",\"NEIN\")","v":"NEIN"},{"$f":"IF($M$10=AO18,\"JA\",\"NEIN\")","v":"NEIN"},"NEIN"]
[]
[null,null,null,"Außeninduzierter Kühlbedarf (KB*, OIB RL6 2015)","kWh/m³a",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(K22=\"\",K22=0),\"\",-(G22-K22)/K22)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Y22=\"\",Y22=0),\"\",-(U22-Y22)/Y22)","v":""},null,null,null,null,null,null,"x",{"$f":"IF(M$10=AL$18,\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"End-/Lieferenergiebedarf (OIB RL6 2015)","kWh/m²a",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(K24=\"\",K24=0),\"\",-(G24-K24)/K24)","v":""},null,"Savings required: min. 25 %",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Y24=\"\",Y24=0),\"\",-(U24-Y24)/Y24)","v":""},null,"Savings required: min. 25 %",null,null,null,null,"x",{"$f":"IF(M$10=AL$18,\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"Gesamtenergieeffizienz-Faktor (OIB RL6 2015)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(K26=\"\",K26=0),\"\",-(G26-K26)/K26)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Y26=\"\",Y26=0),\"\",-(U26-Y26)/Y26)","v":""},null,null,null,null,null,null,"x",{"$f":"IF(M$10=AL$18,\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"HWB*","(kWh/a)",null,null,null,null,null,null,null,"(kWh/a)",null,null,null,{"$f":"IF(OR(K28=\"\",K28=0),\"\",-(G28-K28)/K28)","v":""},null,null,null,null,null,null,null,null,null,"(kWh/a)",null,null,null,{"$f":"IF(OR(Y28=\"\",Y28=0),\"\",-(U28-Y28)/Y28)","v":""}]
[]
[null,null,null,"Erneuerbarer Anteil (OIB RL6 2015)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(K30=\"\",K30=0),\"\",-(G30-K30)/K30)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Y30=\"\",Y30=0),\"\",-(U30-Y30)/Y30)","v":""},null,null,null,null,null,null,"x",{"$f":"IF(M$10=AL$18,\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"HWB*","kWh/m³a",null,null,null,{"$f":"IF(O32=\"\",\"\",O32/$G$12)","v":""},null,null,null,"kWh/a",null,null,null,{"$f":"IF(OR(K32=\"\",K32=0),\"\",-(G32-K32)/K32)","v":""},null,"Savings required: min. 25 %",null,null,null,{"$f":"IF(AC32=\"\",\"\",AC32/$G$12)","v":""},null,null,null,"kWh/a",null,null,null,{"$f":"IF(OR(Y32=\"\",Y32=0),\"\",-(U32-Y32)/Y32)","v":""},null,"Savings required: min. 25 %",null,null,"x","x",null,{"$f":"IF(OR(M10=AJ18,M10=AK18),\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"HWB","kWh/m²a",null,null,null,{"$f":"IF(OR(O34=\"\",G10=\"\"),\"\",O34/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC34=\"\",\"\",AC34/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"x","x","x","JA"]
[]
[null,null,null,"WWWB","kWh/m²a",null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC36=\"\",\"\",AC36/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"x","x","x","JA"]
[]
[null,null,null,"NERLT-h","kWh/m²a",null,null,null,{"$f":"IF(O38=\"\",\"\",O38/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC38=\"\",\"\",AC38/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"x",null,null,{"$f":"IF(M$10=AJ$18,\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"HTEB RH","kWh/m²a",null,null,null,{"$f":"IF(O40=\"\",\"\",O40/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC40=\"\",\"\",AC40/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"x","x",null,{"$f":"IF(OR(M$10=AJ$18,M$10=AK$18),\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"HTEB WW","kWh/m²a",null,null,null,{"$f":"IF(O42=\"\",\"\",O42/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC42=\"\",\"\",AC42/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"x","x",null,{"$f":"IF(OR(M$10=AJ$18,M$10=AK$18),\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"HTEB","kWh/m²a",null,null,null,{"$f":"IF(O44=\"\",\"\",O44/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC44=\"\",\"\",AC44/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"x","x",null,{"$f":"IF(OR(M$10=AJ$18,M$10=AK$18),\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"KTEB","kWh/m²a",null,null,null,{"$f":"IF(O46=\"\",\"\",O46/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC46=\"\",\"\",AC46/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"x","x",null,{"$f":"IF(OR(M$10=AJ$18,M$10=AK$18),\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"HEB","kWh/m²a",null,null,null,{"$f":"IF(O48=\"\",\"\",O48/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC48=\"\",\"\",AC48/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"x","x","x","JA"]
[]
[null,null,null,"Energieaufwandszahl Heizen",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,"x",{"$f":"IF(M$10=AL$18,\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"KB*",null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a"]
[null,null,null,"KB*","kWh/m³a",null,null,null,{"$f":"IF(O54=\"\",\"\",O54/$G$12)","v":""},null,null,null,"kWh/a",null,null,null,{"$f":"IF(OR(K54=\"\",K54=0),\"\",-(G54-K54)/K54)","v":""},null,"Savings required: min. 25 %",null,null,null,{"$f":"IF(AC54=\"\",\"\",AC54/$G$12)","v":""},null,null,null,"kWh/a",null,null,null,{"$f":"IF(OR(U54=\"\",Y54=0),\"\",-(U54-Y54)/Y54)","v":""},null,"Savings required: min. 25 %",null,null,"x","x",null,{"$f":"IF(OR(M$10=AJ$18,M$10=AK$18),\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"KB*",null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a"]
[null,null,null,"KB","kWh/m²a",null,null,null,{"$f":"IF(OR(O58=\"\",G10=\"\"),\"\",O58/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC58=\"\",\"\",AC58/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"x","x","x","JA"]
[]
[null,null,null,"NERLT-k","kWh/m²a",null,null,null,{"$f":"IF(O60=\"\",\"\",O60/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC60=\"\",\"\",AC60/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"x",null,null,{"$f":"IF(M$10=AJ$18,\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"KB*",null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a"]
[null,null,null,"NERLT-d","kWh/m²a",null,null,null,{"$f":"IF(O64=\"\",\"\",O64/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC64=\"\",\"\",AC64/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"x",null,null,{"$f":"IF(M$10=AJ$18,\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"NE","kWh/m²a",null,null,null,{"$f":"IF(O66=\"\",\"\",O66/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC66=\"\",\"\",AC66/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"x",null,null,{"$f":"IF(M$10=AJ$18,\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"KEB","kWh/m²a",null,null,null,{"$f":"IF(O68=\"\",\"\",O68/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC68=\"\",\"\",AC68/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"x","x","x","JA"]
[]
[null,null,null,"Energieaufwandszahl Kühlen",null,null,null,null,null,null,null,null,null,null,null,null,"LENI-Benchmark",null,null,null,null,null,null,null,null,null,null,null,null,null,"LENI-Benchmark",null,null,null,null,null,null,"x",{"$f":"IF(M$10=AL$18,\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"RLTEB","kWh/m²a",null,null,null,{"$f":"IF(O72=\"\",\"\",O72/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC72=\"\",\"\",AC72/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"x",null,null,{"$f":"IF(M$10=AJ$18,\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"BefEB","kWh/m²a",null,null,null,{"$f":"IF(O74=\"\",\"\",O74/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC74=\"\",\"\",AC74/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,"x","x",{"$f":"IF(OR(M$10=AK$18,M$10=AL$18),\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"BelEB","kWh/m²a",null,null,null,{"$f":"IF(OR(O76=\"\",G10=\"\"),\"\",O76/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,{"$f":"IF(G10=\"\",\"\",VLOOKUP(G8,'3_Data collection'!A493:B504,2,0)*G10)","v":""},null,null,null,null,null,{"$f":"IF(AC76=\"\",\"\",AC76/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,{"$f":"IF(G10=\"\",\"\",VLOOKUP(G8,'3_Data collection'!A493:B504,2,0)*G10)","v":""},null,null,null,null,"x","x","x","JA"]
[]
[null,null,null,"BSB","kWh/m²a",null,null,null,{"$f":"IF(O78=\"\",\"\",O78/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC78=\"\",\"\",AC78/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,"x","x",{"$f":"IF(OR(M$10=AK$18,M$10=AL$18),\"JA\",\"NEIN\")","v":"NEIN"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a"]
[null,null,null,"HTEB RH",null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a"]
[null,null,null,"HTEB WW",null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a"]
[null,null,null,"HTEB",null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a"]
[]
[null,null,null,"EEB","kWh/m²a",null,null,null,{"$f":"IF(OR(O86=\"\",G10=\"\"),\"\",O86/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,{"$f":"IF(OR(K86=\"\",K86=0),\"\",-(I86-K86)/K86)","v":""},null,"Savings required: min. 25 %",null,null,null,{"$f":"IF(AC86=\"\",\"\",AC86/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,{"$f":"IF(OR(Y86=\"\",Y86=0),\"\",-(W86-Y86)/Y86)","v":""},null,"Savings required: min. 25 %",null,null,"x","x","x","JA","PV-Erträge werden abgezogen!"]
[]
[null,null,null,"PEB","kWh/m²a",null,null,null,{"$f":"IF(O88=\"\",\"\",O88/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC88=\"\",\"\",AC88/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,"x","x",{"$f":"IF(OR(M$10=AK$18,M$10=AL$18),\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"PEB n.ern.","kWh/m²a",null,null,null,{"$f":"IF(O90=\"\",\"\",O90/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC90=\"\",\"\",AC90/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,"x","x",{"$f":"IF(OR(M$10=AK$18,M$10=AL$18),\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"PEB ern.","kWh/m²a",null,null,null,{"$f":"IF(O92=\"\",\"\",O92/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC92=\"\",\"\",AC92/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,"x","x",{"$f":"IF(OR(M$10=AK$18,M$10=AL$18),\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"PV Export","kWh/m²a",null,null,null,{"$f":"IF(O94=\"\",\"\",O94/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC94=\"\",\"\",AC94/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,"x",{"$f":"IF(M$10=AL$18,\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"Optional: Additional Information if available",null,null,"In final status",null,"Percentage",null,null,null,null,null,null,null,"Source of Data"]
[]
[null,null,null,"Ventilation (auxiliary power for ventilation)","kWh/m²a",null,10,null,{"$f":"IF(G98=\"\",\"\",G98/$G$110*100)","v":29.411764705882355},"%",null,null,"kWh/a",null,{"$f":"IF(G98=\"\",0,G98*$G$10)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MaF Recherche: je nach BPH-Programm: wo finde ich diese Daten? - ansonsten: Sache der Beratung"]
[]
[null,null,null,"Heating (auxiliary power for pumps)","kWh/m²a",null,7,null,{"$f":"IF(G100=\"\",\"\",G100/$G$110*100)","v":20.588235294117645},"%",null,null,"kWh/a",null,{"$f":"IF(G100=\"\",0,G100*$G$10)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"SHW (auxiliary power for pumps)","kWh/m²a",null,4,null,{"$f":"IF(G102=\"\",\"\",G102/$G$110*100)","v":11.76470588235294},"%",null,null,"kWh/a",null,{"$f":"IF(G102=\"\",0,G102*$G$10)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"Auxiliary power for solar thermal plant","kWh/m²a",null,5,null,{"$f":"IF(G104=\"\",\"\",G104/$G$110*100)","v":14.705882352941178},"%",null,null,"kWh/a",null,{"$f":"IF(G104=\"\",0,G104*$G$10)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"Cooling (auxiliary power for ventilation)","kWh/m²a",null,4,null,{"$f":"IF(G106=\"\",\"\",G106/$G$110*100)","v":11.76470588235294},"%",null,null,"kWh/a",null,{"$f":"IF(G106=\"\",0,G106*$G$10)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"Others","kWh/m²a",null,4,null,{"$f":"IF(G108=\"\",\"\",G108/$G$110*100)","v":11.76470588235294},"%",null,null,"kWh/a",null,{"$f":"IF(G108=\"\",0,G108*$G$10)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"Sum","kWh/m²a",null,{"$f":"SUM(G98:G108)","v":34},null,{"$f":"SUM(I98:I108)","v":100},"%",null,null,"kWh/a",null,{"$f":"IF(G110=\"\",\"\",G110*$G$10)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"... or Anteile Hilfsstrom"]
[null,null,null,"Hilfsstromanteil an HTEB RW","(kWh/a)",null,{"$f":"IF(#REF!=\"\",\"\",#REF!*#REF!/100)","v":{"$error":"#REF!"}},null,null,null,null,null,"(kWh/a)"]
[]
[null,null,null,"Hilfsstromanteil an HTEB WWWB","(kWh/a)",null,{"$f":"IF(#REF!=\"\",\"\",#REF!*#REF!/100)","v":{"$error":"#REF!"}},null,null,null,null,null,"(kWh/a)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LÖSCHEN"]
[]
[null,null,null,"Hilfsstrom (HEB - HWB - WWWB - HTEB RW - HTEB WWWB)","(kWh/a)",null,{"$f":"#REF!-#REF!-#REF!-#REF!-#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,"(kWh/a)"]
[]
[null,null,null,"davon für Heizung","(kWh/a)",null,{"$f":"#REF!*G117/100","v":{"$error":"#REF!"}},null,null,null,null,null,"(kWh/a)"]
[]
[null,null,null,"davon für Warmwasser","(kWh/a)",null,{"$f":"#REF!*G117/100","v":{"$error":"#REF!"}},null,null,null,null,null,"(kWh/a)"]
[]
[null,null,null,"davon für Lüftung","(kWh/a)",null,{"$f":"#REF!*G117/100","v":{"$error":"#REF!"}},null,null,null,null,null,"(kWh/a)"]
[]
[null,null,null,"KEB-Anteil für Kühlung ","(kWh/a)",null,{"$f":"#REF!*#REF!/100","v":{"$error":"#REF!"}},null,null,null,null,null,"(kWh/a)"]
[]
[null,null,null,"KEB-Anteil für Lüftung","(kWh/a)",null,{"$f":"#REF!*#REF!/100","v":{"$error":"#REF!"}},null,null,null,null,null,"(kWh/a)"]
[]
[]
[null,null,null,"... or Anteile Hilfsstrom"]
[null,null,null,"Hilfsstromanteil an HTEB RW","(kWh/a)",null,{"$f":"IF(#REF!=\"\",\"\",#REF!*#REF!/100)","v":{"$error":"#REF!"}}]
[]
[null,null,null,"Hilfsstromanteil an HTEB WWWB","(kWh/a)",null,{"$f":"IF(#REF!=\"\",\"\",#REF!*#REF!/100)","v":{"$error":"#REF!"}},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,"LÖSCHEN"]
[]
[null,null,null,"Hilfsstrom (HEB - HWB - WWWB - HTEB RW - HTEB WWWB)","(kWh/a)",null,{"$f":"#REF!-#REF!-#REF!-#REF!-#REF!","v":{"$error":"#REF!"}}]
[]
[null,null,null,"davon für Heizung","(kWh/a)",null,{"$f":"#REF!*G135/100","v":{"$error":"#REF!"}}]
[]
[null,null,null,"davon für Warmwasser","(kWh/a)",null,{"$f":"#REF!*G135/100","v":{"$error":"#REF!"}}]
[]
[null,null,null,"davon für Lüftung","(kWh/a)",null,{"$f":"#REF!*G135/100","v":{"$error":"#REF!"}}]
[]
[null,null,null,"KEB-Anteil für Kühlung ","(kWh/a)",null,{"$f":"#REF!*#REF!/100","v":{"$error":"#REF!"}}]
[]
[null,null,null,"KEB-Anteil für Lüftung","(kWh/a)",null,{"$f":"#REF!*#REF!/100","v":{"$error":"#REF!"}}]
[]
[null,"7.2)",null,"OPTIONAL: Final energy and Primary energy balance of the building"]
[]
[null,null,null,"Final Energy (FE) disaggregation",null,null,"In final status(1) or \nafter renovation",null,"Source of Energy",null,null,null,"Primary Energy Factor",null,"Primary Energy",null,"Source of Data(5)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,2011,"before 2011"]
[]
[null,null,null,"Heating","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"M151*G151","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O34-G104","v":-5},{"$f":"O34+O40-G100-G104","v":-12},{"$f":"O34+O40-G100-G104","v":-12}]
[]
[null,null,null,"if installed, 2nd Heating","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"M153*G153","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O36-G106","v":-4},{"$f":"O36+O42-G102-G106","v":-8},{"$f":"O36+O42-G102-G106","v":-8}]
[]
[null,null,null,"Sanitary Hot Water (SHW) production","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"M155*G155","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O36","v":0},{"$f":"O36+O42","v":0},{"$f":"O36+O42","v":0}]
[]
[null,null,null,"if installed, 2nd SHW production","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"M157*G157","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O40-G110","v":-34},{"$f":"O40+O46-G106-G110","v":-38},{"$f":"O40+O46-G106-G110","v":-38}]
[]
[null,null,null,"Ventilation","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"M159*G159","v":0}]
[]
[null,null,null,"Humidification","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"M161*G161","v":0}]
[]
[null,null,null,"Cooling","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"M163*G163","v":0}]
[]
[null,null,null,"if installed, 2nd Cooling","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"M165*G165","v":0}]
[]
[null,null,null,"if applicable, Auxiliary Power Cooling","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"M167*G167","v":0}]
[]
[null,null,null,"Dehumidification","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"M169*G169","v":0}]
[]
[null,null,null,"Lighting ","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"M171*G171","v":0}]
[]
[null,null,null,"Auxiliary Power Heating","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"M173*G173","v":0}]
[]
[null,null,null,"Auxiliary Power SHW","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"M175*G175","v":0}]
[]
[null,null,null,"Other electric uses ","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"M177*G177","v":0}]
[]
[null,null,null,"PV-Benefits (6)","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"G179","v":0}]
[]
[null,null,null,"Other benefits from renewable energy sources (6)","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"G181","v":0}]
[]
[null,null,null,"All uses","(kWh/a)",null,{"$f":"SUM(G151:G181)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(O151:O181)","v":0}]
[]
[null,null,null,"Equivalent Primary Energy (ePE) generated by renewables(3)",null,null,"In final status(1) or after renovation"]
[]
[null,null,null,"ePE generated by solar thermal collectors","(kWh/a)"]
[]
[null,null,null,"ePE generated by photovoltaic arrays","(kWh/a)"]
[]
[null,null,null,"ePE generated by wind generators","(kWh/a)"]
[]
[null,null,null,"ePE generated by hydroelectric generators","(kWh/a)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"7) Instructions & notes"]
[]
[null,"(0)",null,"Requirements in red are compulsory."]
[null,"(1)",null,"Primary energy required by single energy uses in final status in case of a new building or after renovation in case of an existing building."]
[null,"(2)",null,"Enter legal values according National legislation: in some countries there are legal values specified for any energy use, in others only a total primary energy limit for all uses."]
[null,"(3)",null,"It is possible to enter the single contribution of geothermal and biomass plants "]
[null,null,null,"The contributions of geothermal and biomass plants have to be considered into the calculation of energy need for the specific energy use (heating, cooling, production of warm water, ... )"]
[null,null,null,"Example 1: the energy need required to heat a certain building is 1000 kWhEN. A geothermal plant with an average seasonal COP of 3,5 delivers the needed thermal energy. "]
[null,null,null,"The electric delivered energy required by the geothermal plant to satisfy the energy need is 1000kWhEN / 3,5 = 286 kWhDE. If the delivered to primary energy conversion factor "]
[null,null,null,"for electricity is 2,5, the primary energy consumption required to keep warm the building is 286 kWhDE * 2,5 = 715 kWhPE."]
[null,null,null,"Example 2: energy need required to heat a certain building is 1000 kWhEN. A geothermal plant with an average seasonal COP of 3,5 delivers the 70% of the whole thermal energy required (1000 kWhEN *0,7 = 700 kWhEN). The rest (1000 kWhEN *0,3 = 300 kWhEN) is produced through a boiler with an average seasonal efficiency of 80%. Electric delivered energy required by the geothermal plant is 700 kWhEN / 3,5 = 200 kWhDE,electricity, while fuel delivered energy required by the boiler is 300 kWhEN / 0,80 = 375 kWhDE,fuel. If the delivered to primary energy conversion factor for electricity is 2,5, primary energy consumed by the geothermal plant is 200 kWhDE * 2,5 = 500 kWhPE. If the delivered to primary energy conversion factor for fuel  is 1,1, primary energy consumed by the boiler is 375 kWhDE * 1,1 = 412,5 kWhPE. So the whole consumption of primary energy is           500 kWhPE + 412,5 kWhPE = 912,5 kWhPE."]
[null,"(4)",null,"A positive number indicates that energy consumption has been reduced, while a negative number means that energy consumtion has been increased."]
[null,"(5)",null,"Only if the actual Primary Energy Factor differs from the suggested Primary Energy Factor."]
[null,"(6)",null,"Please insert the benefits with a negative value"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Primary Energy",{"$f":"D183","v":"All uses"},"ePE generated"]
[null,null,null,{"$f":"D151","v":"Heating"},{"$f":"O151+O153","v":0},{"$f":"Q183","v":0},{"$f":"SUM(G187:G193)","v":0}]
[null,null,null,{"$f":"D155","v":"Sanitary Hot Water (SHW) production"},{"$f":"O155+O157","v":0}]
[null,null,null,{"$f":"D159","v":"Ventilation"},{"$f":"O159","v":0}]
[null,null,null,{"$f":"D161","v":"Humidification"},{"$f":"O161","v":0}]
[null,null,null,{"$f":"D163","v":"Cooling"},{"$f":"O163","v":0}]
[null,null,null,{"$f":"D171","v":"Lighting "},{"$f":"O171","v":0}]
[null,null,null,{"$f":"D173","v":"Auxiliary Power Heating"},{"$f":"O173","v":0}]
[null,null,null,{"$f":"D175","v":"Auxiliary Power SHW"},{"$f":"O175","v":0}]
[null,null,null,{"$f":"D177","v":"Other electric uses "},{"$f":"O177","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,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"#REF!/SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"#REF!/SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"#REF!/SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"#REF!/SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"#REF!/SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"#REF!/SUM(#REF!)","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U281:U286)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"PEC in final status or after renovation",null,"Net PEC in final status or after renovation",null,"Net PEC in final status or after renovation",null,null,null,"Net PEC in final status or after renovation",null,null,null,"Net PEC in final status or after renovation",null,"PEC in final status or after renovation",null,"Net PEC in final status or after renovation",null,"Net PEC in final status or after renovation",null,null,null,"Net PEC in final status or after renovation",null,null,null,"Net PEC in final status or after renovation"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Total Primary Energy"]

{"sheet":"#7b","index":14,"n_rows":334,"n_cols":74,"rows_kept":334,"cut":false,"hidden":false,"merged":[[230,61,230,64],[287,36,287,37],[287,44,287,45],[287,55,287,56],[2,2,3,10],[285,36,285,37],[285,44,285,45],[285,55,285,56],[286,36,286,37],[286,44,286,45],[286,55,286,56],[282,44,282,45],[282,55,282,56],[283,36,283,37],[283,44,283,45],[283,55,283,56],[284,36,284,37],[284,44,284,45],[284,55,284,56],[178,40,178,42],[287,4,287,5],[287,12,287,13],[287,26,287,27],[7,44,7,46],[281,36,281,37],[281,44,281,45],[281,55,281,56],[164,40,164,42],[172,40,172,42],[174,40,174,42],[156,40,156,42],[158,40,158,42],[160,40,160,42],[230,32,230,60],[162,40,162,42],[176,40,176,42],[170,40,170,42],[166,40,166,42],[168,40,168,42],[282,36,282,37],[285,4,285,5],[285,12,285,13],[285,26,285,27],[286,4,286,5],[286,12,286,13],[286,26,286,27],[283,4,283,5],[283,12,283,13],[283,26,283,27],[284,4,284,5],[284,12,284,13],[284,26,284,27],[230,3,230,31],[281,4,281,5],[281,12,281,13],[281,26,281,27],[282,4,282,5],[282,12,282,13],[282,26,282,27],[174,8,174,10],[174,16,174,18],[176,8,176,10],[176,16,176,18],[178,8,178,10],[178,16,178,18],[180,16,180,18],[182,16,182,18],[162,8,162,10],[162,16,162,18],[164,8,164,10],[164,16,164,18],[172,8,172,10],[172,16,172,18],[156,8,156,10],[156,16,156,18],[158,8,158,10],[158,16,158,18],[160,8,160,10],[160,16,160,18],[170,8,170,10],[170,16,170,18],[166,8,166,10],[166,16,166,18],[168,8,168,10],[168,16,168,18],[150,8,150,10],[150,16,150,18],[152,8,152,10],[152,16,152,18],[154,8,154,10],[154,16,154,18],[96,16,96,18],[77,85,77,92],[85,71,91,71],[89,86,91,86],[89,87,91,87],[89,88,91,88],[89,89,91,89],[89,90,91,90],[89,91,91,91],[89,92,91,92],[150,40,150,42],[152,40,152,42],[154,40,154,42],[9,12,9,14],[11,12,11,14],[13,12,13,14],[15,20,15,30],[69,16,73,16],[69,30,73,30],[69,53,73,53],[5,61,5,63],[5,35,5,46],[5,3,5,18],[11,44,11,46],[15,49,15,58],[69,42,73,42],[9,44,9,46],[7,6,7,14],[7,38,7,43]]}
[]
[null,"7) E","Energy Summary Based on Legal Values"]
[null,null,"for Renovations - Austrian Project"]
[]
[]
[null,"7.1)",null,"Energy Parameters (according to the Austrian Energy Performance Certificate (EPC))\nAFTER Renovation",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,"7.2)",null,"Energy Parameters (according to the Austrian Energy Performance Certificate (EPC))\nBEFORE Renovation",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,"Energy Savings",null,null,null,null,null,null,null,null,null,"before OIB RL6-2011","OIB RL6-2011","OIB RL6-2015"]
[]
[null,null,null,"Building Type",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,"Building Type",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":"IF($M$10=BT6,\"JA\",\"NEIN\")","v":"NEIN"},{"$f":"IF($M$10=BU6,\"JA\",\"NEIN\")","v":"NEIN"},"NEIN"]
[]
[null,null,null,"Gross floor area (heated)","m²",null,{"$f":"'#2'!W22","v":""},null,"EPC according to",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,"Gross floor area (heated)","m²"]
[]
[null,null,null,"Gross volume (heated)","m³",null,{"$f":"'#2'!E34","v":0},null,"Software for 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,"Gross volume (heated)","m³"]
[]
[null,null,null,"Lighting Energy Demand is calculated?",null,null,null,null,null,null,null,null,"Pleaser insert here!"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"With specific and accuracte calculation of BelEB",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,"With specific and accuracte calculation of BelEB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual heating demand (HWB*):           "]
[]
[null,null,null,"Energy Paramters",null,null,"Reference Climate",null,"Local Climate",null,"Legal values",null,null,null,"Local Climate in kWh/a",null,"Percentage savings(4)",null,null,null,"Reference Climate",null,"Local Climate",null,"Legal values",null,null,null,"Local Climate in kWh/a",null,"Percentage savings(4)",null,null,null,null,"Energy Paramters",null,null,"Reference Climate",null,"Local Climate",null,null,null,null,null,"Local Climate in kWh/a",null,null,"Reference Climate",null,"Local Climate",null,null,null,null,null,"Local Climate in kWh/a",null,null,null,null,null,null,null,null,null,"before OIB RL6-2011","OIB RL6-2011","OIB RL6-2015",null,null,null,"Annual cooling demand (KB*):"]
[]
[null,null,null,"Ref-HWB (OIB RL6 2015)","kWh/m²a",null,null,null,{"$f":"IF(O20=\"\",\"\",O20/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,{"$f":"IF(OR(G20=\"\",AM20=\"\"),\"\",1-G20/AM20)","v":""},null,null,null,null,null,{"$f":"IF(AC20=\"\",\"\",AC20/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,{"$f":"IF(OR(Y20=\"\",Y20=0),\"\",-(U20-Y20)/Y20)","v":""},null,null,null,null,"Ref-HWB (OIB RL6 2015)","kWh/m²a",null,null,null,{"$f":"IF(AU20=\"\",\"\",AU20/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,{"$f":"IF(BF20=\"\",\"\",BF20/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,"x",{"$f":"IF(M$10=BR$18,\"JA\",\"NEIN\")","v":"NEIN"},null,null,"Annual heating demand (HWB):     "]
[]
[null,null,null,"Außeninduzierter Kühlbedarf (KB*, OIB RL6 2015)","kWh/m³a",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G22=\"\",AM22=\"\"),\"\",1-G22/AM22)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Y22=\"\",Y22=0),\"\",-(U22-Y22)/Y22)","v":""},null,null,null,null,"Außeninduzierter Kühlbedarf (KB*, OIB RL6 2015)","kWh/m³a",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,"x",{"$f":"IF(M$10=BR$18,\"JA\",\"NEIN\")","v":"NEIN"},null,null,"Annual cooling demand (KB):"]
[]
[null,null,null,"End-/Lieferenergiebedarf (OIB RL6 2015)","kWh/m²a",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G24=\"\",AM24=\"\"),\"\",1-G24/AM24)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Y24=\"\",Y24=0),\"\",-(U24-Y24)/Y24)","v":""},null,null,null,null,"End-/Lieferenergiebedarf (OIB RL6 2015)","kWh/m²a",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,"x",{"$f":"IF(M$10=BR$18,\"JA\",\"NEIN\")","v":"NEIN"},null,null,"Lighting energy demand (BelEB):"]
[]
[null,null,null,"Gesamtenergieeffizienz-Faktor (OIB RL6 2015)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G26=\"\",AM26=\"\"),\"\",1-G26/AM26)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Y26=\"\",Y26=0),\"\",-(U26-Y26)/Y26)","v":""},null,null,null,null,"Gesamtenergieeffizienz-Faktor (OIB RL6 2015)",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,"x",{"$f":"IF(M$10=BR$18,\"JA\",\"NEIN\")","v":"NEIN"},null,null,"Total end energy"]
[]
[null,null,null,"HWB*","(kWh/a)",null,null,null,null,null,null,null,"(kWh/a)",null,null,null,{"$f":"IF(OR(K28=\"\",K28=0),\"\",-(G28-K28)/K28)","v":""},null,null,null,null,null,null,null,null,null,"(kWh/a)",null,null,null,{"$f":"IF(OR(Y28=\"\",Y28=0),\"\",-(U28-Y28)/Y28)","v":""},null,null,null,null,"HWB*","(kWh/a)",null,null,null,null,null,null,null,"(kWh/a)",null,null,null,null,null,null,null,null,null,null,"(kWh/a)"]
[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,null,null,null,null,null,null,null,"Total end energy demand:"]
[null,null,null,"Erneuerbarer Anteil (OIB RL6 2015)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G30=\"\",AM30=\"\"),\"\",1-G30/AM30)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Y30=\"\",Y30=0),\"\",-(U30-Y30)/Y30)","v":""},null,null,null,null,"Erneuerbarer Anteil (OIB RL6 2015)",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,"x",{"$f":"IF(M$10=BR$18,\"JA\",\"NEIN\")","v":"NEIN"},null,null,"Total primary energy demand:"]
[]
[null,null,null,"HWB*","kWh/m³a",null,null,null,{"$f":"IF(O32=\"\",\"\",O32/$G$12)","v":""},null,null,null,"kWh/a",null,null,null,{"$f":"IF(OR(K32=\"\",K32=0),\"\",-(G32-K32)/K32)","v":""},null,null,null,null,null,{"$f":"IF(AC32=\"\",\"\",AC32/$G$12)","v":""},null,null,null,"kWh/a",null,null,null,{"$f":"IF(OR(Y32=\"\",Y32=0),\"\",-(U32-Y32)/Y32)","v":""},null,null,null,null,"HWB*","kWh/m³a",null,null,null,{"$f":"IF(AU32=\"\",\"\",AU32/$AM$12)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,{"$f":"IF(BF32=\"\",\"\",BF32/$AM$12)","v":""},null,null,null,"kWh/a",null,null,null,null,null,{"$f":"IF($G$14=\"no\",IF(OR(G32=\"\",AM32=\"\"),\"\",1-G32/AM32),IF(OR(U32=\"\",AX32=\"\"),\"\",1-U32/AX32))","v":""},null,"Savings required: min. 25 %",null,null,null,"x","x",null,{"$f":"IF(OR(M10=BP18,M10=BQ18),\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"HWB","kWh/m²a",null,null,null,{"$f":"IF(OR(G10=\"\",O34=\"\"),\"\",O34/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G10=\"\",AC34=\"\"),\"\",AC34/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"HWB","kWh/m²a",null,null,null,{"$f":"IF(OR(AU34=\"\",AM10=\"\"),\"\",AU34/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,{"$f":"IF(OR(AM10=\"\",BF34=\"\"),\"\",BF34/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,"x","x","x","JA"]
[]
[null,null,null,"WWWB","kWh/m²a",null,null,null,{"$f":"IF(O36=\"\",\"\",O36/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC36=\"\",\"\",AC36/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"WWWB","kWh/m²a",null,null,null,{"$f":"IF(AU36=\"\",\"\",AU36/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,{"$f":"IF(BF36=\"\",\"\",BF36/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,"x","x","x","JA"]
[]
[null,null,null,"NERLT-h","kWh/m²a",null,null,null,{"$f":"IF(O38=\"\",\"\",O38/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC38=\"\",\"\",AC38/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"NERLT-h","kWh/m²a",null,null,null,{"$f":"IF(AU38=\"\",\"\",AU38/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,{"$f":"IF(BF38=\"\",\"\",BF38/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,"x",null,null,{"$f":"IF(M$10=BP$18,\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"HTEB RH","kWh/m²a",null,null,null,{"$f":"IF(O40=\"\",\"\",O40/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC40=\"\",\"\",AC40/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"HTEB RH","kWh/m²a",null,null,null,{"$f":"IF(AU40=\"\",\"\",AU40/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,{"$f":"IF(BF40=\"\",\"\",BF40/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,"x","x",null,{"$f":"IF(OR(M$10=BP$18,M$10=BQ$18),\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"HTEB WW","kWh/m²a",null,null,null,{"$f":"IF(O42=\"\",\"\",O42/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC42=\"\",\"\",AC42/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"HTEB WW","kWh/m²a",null,null,null,{"$f":"IF(AU42=\"\",\"\",AU42/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,{"$f":"IF(BF42=\"\",\"\",BF42/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,"x","x",null,{"$f":"IF(OR(M$10=BP$18,M$10=BQ$18),\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"HTEB","kWh/m²a",null,null,null,{"$f":"IF(O44=\"\",\"\",O44/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC44=\"\",\"\",AC44/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"HTEB","kWh/m²a",null,null,null,{"$f":"IF(AU44=\"\",\"\",AU44/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,{"$f":"IF(BF44=\"\",\"\",BF44/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,"x","x",null,{"$f":"IF(OR(M$10=BP$18,M$10=BQ$18),\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"KTEB","kWh/m²a",null,null,null,{"$f":"IF(O46=\"\",\"\",O46/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC46=\"\",\"\",AC46/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"KTEB","kWh/m²a",null,null,null,{"$f":"IF(AU46=\"\",\"\",AU46/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,{"$f":"IF(BF46=\"\",\"\",BF46/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,"x","x",null,{"$f":"IF(OR(M$10=BP$18,M$10=BQ$18),\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"HEB","kWh/m²a",null,null,null,{"$f":"IF(O48=\"\",\"\",O48/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC48=\"\",\"\",AC48/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"HEB","kWh/m²a",null,null,null,{"$f":"IF(AU48=\"\",\"\",AU48/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,{"$f":"IF(BF48=\"\",\"\",BF48/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,"x","x","x","JA"]
[]
[null,null,null,"Energieaufwandszahl Heizen",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,"Energieaufwandszahl Heizen",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,"x",{"$f":"IF(M$10=BR$18,\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"KB*",null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"KB*",null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,"kWh/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,"kWh/a"]
[null,null,null,"KB*","kWh/m³a",null,null,null,{"$f":"IF(O54=\"\",\"\",O54/$G$12)","v":""},null,null,null,"kWh/a",null,null,null,{"$f":"IF(OR(G54=\"\",AM54=\"\"),\"\",1-G54/AM54)","v":""},null,null,null,null,null,{"$f":"IF(AC54=\"\",\"\",AC54/$G$12)","v":""},null,null,null,"kWh/a",null,null,null,{"$f":"IF(OR(U54=\"\",Y54=0),\"\",-(U54-Y54)/Y54)","v":""},null,null,null,null,"KB*","kWh/m³a",null,null,null,{"$f":"IF(AU54=\"\",\"\",AU54/$AM$12)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,{"$f":"IF(BF54=\"\",\"\",BF54/$AM$12)","v":""},null,null,null,"kWh/a",null,null,null,null,null,{"$f":"IF($G$14=\"no\",IF(OR(G54=\"\",AM54=\"\"),\"\",1-G54/AM54),IF(OR(U54=\"\",AX54=\"\"),\"\",1-U54/AX54))","v":""},null,"Savings required: min. 25 %",null,null,null,"x","x",null,{"$f":"IF(OR(M$10=BP$18,M$10=BQ$18),\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"KB*",null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"KB*",null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,"kWh/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,"kWh/a"]
[null,null,null,"KB","kWh/m²a",null,null,null,{"$f":"IF(OR(O58=\"\",G10=\"\"),\"\",O58/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G10=\"\",AC58=\"\"),\"\",AC58/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"KB","kWh/m²a",null,null,null,{"$f":"IF(OR(AM10=\"\",AU58=\"\"),\"\",AU58/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,{"$f":"IF(OR(AM10=\"\",BF58=\"\"),\"\",BF58/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,"x","x","x","JA"]
[]
[null,null,null,"NERLT-k","kWh/m²a",null,null,null,{"$f":"IF(O60=\"\",\"\",O60/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC60=\"\",\"\",AC60/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"NERLT-k","kWh/m²a",null,null,null,{"$f":"IF(AU60=\"\",\"\",AU60/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,{"$f":"IF(BF60=\"\",\"\",BF60/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,"x",null,null,{"$f":"IF(M$10=BP$18,\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"KB*",null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"KB*",null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,"kWh/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,"kWh/a"]
[null,null,null,"NERLT-d","kWh/m²a",null,null,null,{"$f":"IF(O64=\"\",\"\",O64/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC64=\"\",\"\",AC64/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"NERLT-d","kWh/m²a",null,null,null,{"$f":"IF(AU64=\"\",\"\",AU64/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,{"$f":"IF(BF64=\"\",\"\",BF64/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,"x",null,null,{"$f":"IF(M$10=BP$18,\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"NE","kWh/m²a",null,null,null,{"$f":"IF(O66=\"\",\"\",O66/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC66=\"\",\"\",AC66/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"NE","kWh/m²a",null,null,null,{"$f":"IF(AU66=\"\",\"\",AU66/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,{"$f":"IF(BF66=\"\",\"\",BF66/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,"x",null,null,{"$f":"IF(M$10=BP$18,\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"KEB","kWh/m²a",null,null,null,{"$f":"IF(O68=\"\",\"\",O68/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC68=\"\",\"\",AC68/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"KEB","kWh/m²a",null,null,null,{"$f":"IF(AU68=\"\",\"\",AU68/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,{"$f":"IF(BF68=\"\",\"\",BF68/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,"x","x","x","JA"]
[]
[null,null,null,"Energieaufwandszahl Kühlen",null,null,null,null,null,null,null,null,null,null,null,null,"LENI-Benchmark",null,null,null,null,null,{"$f":"IF(AC70=\"\",\"\",AC70/$G$10)","v":""},null,null,null,null,null,null,null,"LENI-Benchmark",null,null,null,null,"Energieaufwandszahl Kühlen",null,null,null,null,null,null,"LENI-Benchmark",null,null,null,null,null,null,null,null,{"$f":"IF(BF70=\"\",\"\",BF70/$G$10)","v":""},null,"LENI-Benchmark",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x",{"$f":"IF(M$10=BR$18,\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"RLTEB","kWh/m²a",null,null,null,{"$f":"IF(O72=\"\",\"\",O72/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC72=\"\",\"\",AC72/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"RLTEB","kWh/m²a",null,null,null,{"$f":"IF(AU72=\"\",\"\",AU72/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,{"$f":"IF(BF72=\"\",\"\",BF72/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,"x",null,null,{"$f":"IF(M$10=BP$18,\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"BefEB","kWh/m²a",null,null,null,{"$f":"IF(O74=\"\",\"\",O74/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC74=\"\",\"\",AC74/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"BefEB","kWh/m²a",null,null,null,{"$f":"IF(AU74=\"\",\"\",AU74/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,{"$f":"IF(BF74=\"\",\"\",BF74/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,"x","x",{"$f":"IF(OR(M$10=BQ$18,M$10=BR$18),\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"BelEB","kWh/m²a",null,null,null,{"$f":"IF(O76=\"\",\"\",O76/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,{"$f":"IF(G10=\"\",\"\",VLOOKUP(G8,'3_Data collection'!A493:B504,2,0)*G10)","v":""},null,null,null,null,null,{"$f":"IF(AC76=\"\",\"\",AC76/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,{"$f":"IF(G10=\"\",\"\",VLOOKUP(G8,'3_Data collection'!A493:B504,2,0)*G10)","v":""},null,null,null,null,"BelEB","kWh/m²a",null,null,null,{"$f":"IF(AU76=\"\",\"\",AU76/$AM$10)","v":""},null,{"$f":"IF(AM10=\"\",\"\",VLOOKUP(AM8,'3_Data collection'!A493:B504,2,0)*AM10)","v":""},null,"kWh/a",null,null,null,null,null,null,{"$f":"IF(BF76=\"\",\"\",BF76/$AM$10)","v":""},null,{"$f":"IF(AM10=\"\",\"\",VLOOKUP(AM8,'3_Data collection'!A493:B504,2,0)*AM10)","v":""},null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,"x","x","x","JA"]
[]
[null,null,null,"BSB","kWh/m²a",null,null,null,{"$f":"IF(O78=\"\",\"\",O78/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC78=\"\",\"\",AC78/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"BSB","kWh/m²a",null,null,null,{"$f":"IF(AU78=\"\",\"\",AU78/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,{"$f":"IF(BF78=\"\",\"\",BF78/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,"x","x",{"$f":"IF(OR(M$10=BQ$18,M$10=BR$18),\"JA\",\"NEIN\")","v":"NEIN"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,"kWh/a"]
[null,null,null,"HTEB RH",null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"HTEB RH",null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,"kWh/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,"kWh/a"]
[null,null,null,"HTEB WW",null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"HTEB WW",null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,"kWh/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,"kWh/a"]
[null,null,null,"HTEB",null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"HTEB",null,null,null,null,null,null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,"kWh/a"]
[]
[null,null,null,"EEB","kWh/m²a",null,null,null,{"$f":"IF(O86=\"\",\"\",O86/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,{"$f":"IF(OR(G86=\"\",AM86=\"\"),\"\",1-G86/AM86)","v":""},null,null,null,null,null,{"$f":"IF(AC86=\"\",\"\",AC86/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,{"$f":"IF(OR(Y86=\"\",Y86=0),\"\",-(W86-Y86)/Y86)","v":""},null,null,null,null,"EEB","kWh/m²a",null,null,null,{"$f":"IF(AU86=\"\",\"\",AU86/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,{"$f":"IF(BF86=\"\",\"\",BF86/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,{"$f":"IF($G$14=\"no\",IF(OR(O86=\"\",AU86=\"\"),\"\",1-O86/AU86),IF(OR(AC86=\"\",BF86=\"\"),\"\",1-AC86/BF86))","v":""},null,"Savings required: min. 25 %",null,null,null,"x","x","x","JA","PV-Erträge werden abgezogen!"]
[]
[null,null,null,"PEB","kWh/m²a",null,null,null,{"$f":"IF(O88=\"\",\"\",O88/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC88=\"\",\"\",AC88/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"PEB","kWh/m²a",null,null,null,{"$f":"IF(AU88=\"\",\"\",AU88/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,{"$f":"IF(BF88=\"\",\"\",BF88/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,"x","x",{"$f":"IF(OR(M$10=BQ$18,M$10=BR$18),\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"PEB n.ern.","kWh/m²a",null,null,null,{"$f":"IF(O90=\"\",\"\",O90/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC90=\"\",\"\",AC90/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"PEB n.ern","kWh/m²a",null,null,null,{"$f":"IF(AU90=\"\",\"\",AU90/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,{"$f":"IF(BF90=\"\",\"\",BF90/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,"x","x",{"$f":"IF(OR(M$10=BQ$18,M$10=BR$18),\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"PEB ern.","kWh/m²a",null,null,null,{"$f":"IF(O92=\"\",\"\",O92/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC92=\"\",\"\",AC92/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"PEB er.","kWh/m²a",null,null,null,{"$f":"IF(AU92=\"\",\"\",AU92/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,{"$f":"IF(BF92=\"\",\"\",BF92/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,"x","x",{"$f":"IF(OR(M$10=BQ$18,M$10=BR$18),\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[null,null,null,"PV Export","kWh/m²a",null,null,null,{"$f":"IF(O94=\"\",\"\",O94/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,{"$f":"IF(AC94=\"\",\"\",AC94/$G$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,"PV Export","kWh/m²a",null,null,null,{"$f":"IF(AU94=\"\",\"\",AU94/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,{"$f":"IF(BF94=\"\",\"\",BF94/$AM$10)","v":""},null,null,null,"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,"x",{"$f":"IF(M$10=BR$18,\"JA\",\"NEIN\")","v":"NEIN"}]
[]
[]
[null,null,null,"Optional: Additional Information if available",null,null,"In final status",null,"Percentage",null,null,null,null,null,null,null,"Source of Data"]
[]
[null,null,null,"Ventilation (auxiliary power for ventilation)","kWh/m²a",null,10,null,{"$f":"IF(G99=\"\",\"\",G99/$G$111*100)","v":29.411764705882355},"%",null,null,"kWh/a",null,{"$f":"IF(G99=\"\",0,G99*$G$10)","v":{"$error":"#VALUE!"}},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,"MaF Recherche: je nach BPH-Programm: wo finde ich diese Daten? - ansonsten: Sache der Beratung"]
[]
[null,null,null,"Heating (auxiliary power for pumps)","kWh/m²a",null,7,null,{"$f":"IF(G101=\"\",\"\",G101/$G$111*100)","v":20.588235294117645},"%",null,null,"kWh/a",null,{"$f":"IF(G101=\"\",0,G101*$G$10)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"SHW (auxiliary power for pumps)","kWh/m²a",null,4,null,{"$f":"IF(G103=\"\",\"\",G103/$G$111*100)","v":11.76470588235294},"%",null,null,"kWh/a",null,{"$f":"IF(G103=\"\",0,G103*$G$10)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"Auxiliary power for solar thermal plant","kWh/m²a",null,5,null,{"$f":"IF(G105=\"\",\"\",G105/$G$111*100)","v":14.705882352941178},"%",null,null,"kWh/a",null,{"$f":"IF(G105=\"\",0,G105*$G$10)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"Cooling (auxiliary power for ventilation)","kWh/m²a",null,4,null,{"$f":"IF(G107=\"\",\"\",G107/$G$111*100)","v":11.76470588235294},"%",null,null,"kWh/a",null,{"$f":"IF(G107=\"\",0,G107*$G$10)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"Others","kWh/m²a",null,4,null,{"$f":"IF(G109=\"\",\"\",G109/$G$111*100)","v":11.76470588235294},"%",null,null,"kWh/a",null,{"$f":"IF(G109=\"\",0,G109*$G$10)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"Sum","kWh/m²a",null,{"$f":"SUM(G99:G109)","v":34},null,{"$f":"SUM(I99:I109)","v":100},"%",null,null,"kWh/a",null,{"$f":"IF(G111=\"\",\"\",G111*$G$10)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"... or Anteile Hilfsstrom"]
[null,null,null,"Hilfsstromanteil an HTEB RW","(kWh/a)",null,{"$f":"IF(#REF!=\"\",\"\",#REF!*#REF!/100)","v":{"$error":"#REF!"}},null,null,null,null,null,"(kWh/a)"]
[]
[null,null,null,"Hilfsstromanteil an HTEB WWWB","(kWh/a)",null,{"$f":"IF(#REF!=\"\",\"\",#REF!*#REF!/100)","v":{"$error":"#REF!"}},null,null,null,null,null,"(kWh/a)",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,"LÖSCHEN"]
[]
[null,null,null,"Hilfsstrom (HEB - HWB - WWWB - HTEB RW - HTEB WWWB)","(kWh/a)",null,{"$f":"#REF!-#REF!-#REF!-#REF!-#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,"(kWh/a)"]
[]
[null,null,null,"davon für Heizung","(kWh/a)",null,{"$f":"#REF!*G118/100","v":{"$error":"#REF!"}},null,null,null,null,null,"(kWh/a)"]
[]
[null,null,null,"davon für Warmwasser","(kWh/a)",null,{"$f":"#REF!*G118/100","v":{"$error":"#REF!"}},null,null,null,null,null,"(kWh/a)"]
[]
[null,null,null,"davon für Lüftung","(kWh/a)",null,{"$f":"#REF!*G118/100","v":{"$error":"#REF!"}},null,null,null,null,null,"(kWh/a)"]
[]
[null,null,null,"KEB-Anteil für Kühlung ","(kWh/a)",null,{"$f":"#REF!*#REF!/100","v":{"$error":"#REF!"}},null,null,null,null,null,"(kWh/a)"]
[]
[null,null,null,"KEB-Anteil für Lüftung","(kWh/a)",null,{"$f":"#REF!*#REF!/100","v":{"$error":"#REF!"}},null,null,null,null,null,"(kWh/a)"]
[]
[]
[null,null,null,"... or Anteile Hilfsstrom"]
[null,null,null,"Hilfsstromanteil an HTEB RW","(kWh/a)",null,{"$f":"IF(#REF!=\"\",\"\",#REF!*#REF!/100)","v":{"$error":"#REF!"}}]
[]
[null,null,null,"Hilfsstromanteil an HTEB WWWB","(kWh/a)",null,{"$f":"IF(#REF!=\"\",\"\",#REF!*#REF!/100)","v":{"$error":"#REF!"}},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,"LÖSCHEN"]
[]
[null,null,null,"Hilfsstrom (HEB - HWB - WWWB - HTEB RW - HTEB WWWB)","(kWh/a)",null,{"$f":"#REF!-#REF!-#REF!-#REF!-#REF!","v":{"$error":"#REF!"}}]
[]
[null,null,null,"davon für Heizung","(kWh/a)",null,{"$f":"#REF!*G136/100","v":{"$error":"#REF!"}}]
[]
[null,null,null,"davon für Warmwasser","(kWh/a)",null,{"$f":"#REF!*G136/100","v":{"$error":"#REF!"}}]
[]
[null,null,null,"davon für Lüftung","(kWh/a)",null,{"$f":"#REF!*G136/100","v":{"$error":"#REF!"}}]
[]
[null,null,null,"KEB-Anteil für Kühlung ","(kWh/a)",null,{"$f":"#REF!*#REF!/100","v":{"$error":"#REF!"}}]
[]
[null,null,null,"KEB-Anteil für Lüftung","(kWh/a)",null,{"$f":"#REF!*#REF!/100","v":{"$error":"#REF!"}}]
[]
[]
[null,"7.2)",null,"OPTIONAL: Final energy and Primary energy balance of the building"]
[]
[null,null,null,"Final Energy (FE) disaggregation",null,null,"In final status(1) or \nafter renovation",null,"Source of Energy",null,null,null,"Primary Energy Factor",null,"Primary Energy",null,"Source of Data(5)",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,2015,2011,"before 2011"]
[]
[null,null,null,"Heating","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"M153*G153","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,null,null,null,null,null,null,null,{"$f":"O34-G105","v":-5},{"$f":"O34+O40-G101-G105","v":-12},{"$f":"O34+O40-G101-G105","v":-12}]
[]
[null,null,null,"if installed, 2nd Heating","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"M155*G155","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,null,null,null,null,null,null,null,{"$f":"O36-G107","v":-4},{"$f":"O36+O42-G103-G107","v":-8},{"$f":"O36+O42-G103-G107","v":-8}]
[]
[null,null,null,"Sanitary Hot Water (SHW) production","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"M157*G157","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,null,null,null,null,null,null,null,{"$f":"O36","v":0},{"$f":"O36+O42","v":0},{"$f":"O36+O42","v":0}]
[]
[null,null,null,"if installed, 2nd SHW production","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"M159*G159","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,null,null,null,null,null,null,null,{"$f":"O40-G111","v":-34},{"$f":"O40+O46-G107-G111","v":-38},{"$f":"O40+O46-G107-G111","v":-38}]
[]
[null,null,null,"Ventilation (auxiliary power for ventialtion)","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"M161*G161","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,null,null,null,null,null,null,null,{"$f":"IF(O99=\"\",0,O99)","v":{"$error":"#VALUE!"}},{"$f":"IF(O99=\"\",0,O99)","v":{"$error":"#VALUE!"}},{"$f":"O72","v":0}]
[]
[null,null,null,"Humidification","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"M163*G163","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,null,null,null,null,null,null,null,{"$f":"O74","v":0},{"$f":"O74","v":0}]
[]
[null,null,null,"Cooling","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"M165*G165","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,null,null,null,null,null,null,null,{"$f":"O68","v":0},{"$f":"O68","v":0},{"$f":"O68","v":0}]
[]
[null,null,null,"if installed, 2nd Cooling","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"M167*G167","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,null,null,null,null,null,null,null,{"$f":"O70","v":0},{"$f":"O70","v":0},{"$f":"O70","v":0}]
[]
[null,null,null,"if applicable, Auxiliary Power Cooling","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"M169*G169","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,null,null,null,null,null,null,null,{"$f":"O72","v":0},{"$f":"O72","v":0},{"$f":"O72","v":0}]
[]
[null,null,null,"Dehumidification","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"M171*G171","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,null,null,null,null,null,null,null,{"$f":"O70","v":0},{"$f":"O70","v":0},{"$f":"O70","v":0}]
[]
[null,null,null,"Lighting ","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"M173*G173","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,null,null,null,null,null,null,null,{"$f":"O76","v":0},{"$f":"O76","v":0},{"$f":"O76","v":0}]
[]
[null,null,null,"Auxiliary Power Heating","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"M175*G175","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,null,null,null,null,null,null,null,{"$f":"IF(O101=\"\",0,O101)","v":{"$error":"#VALUE!"}},{"$f":"IF(O101=\"\",0,O101)","v":{"$error":"#VALUE!"}},{"$f":"IF(O101=\"\",0,O101)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"Auxiliary Power SHW","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"M177*G177","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,null,null,null,null,null,null,null,{"$f":"IF(O103=\"\",0,O103)","v":{"$error":"#VALUE!"}},{"$f":"IF(O103=\"\",0,O103)","v":{"$error":"#VALUE!"}},{"$f":"IF(O103=\"\",0,O103)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"Other electric uses ","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"M179*G179","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,null,null,null,null,null,null,null,{"$f":"IF(AND(O105=\"\",O109=\"\",O107=\"\",O78=\"\"),0,O105+O109+O107+O78)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(O105=\"\",O109=\"\",O107=\"\",O78=\"\"),0,O105+O109+O107+O78)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(O105=\"\",O109=\"\",O107=\"\",O78=\"\"),0,O105+O109+O107+O78)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"PV-Benefits (6)","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"G181","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,null,null,null,null,null,null,null,{"$f":"SUM(BQ151:BQ177)","v":{"$error":"#VALUE!"}},{"$f":"SUM(BR151:BR177)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[]
[null,null,null,"Other benefits from renewable energy sources (6)","(kWh/a)",null,null,null,null,null,null,null,null,null,{"$f":"G183","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,null,null,null,null,null,null,null,{"$f":"SUM(BQ153:BQ179)","v":{"$error":"#VALUE!"}},{"$f":"SUM(BR153:BR179)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[]
[null,null,null,"All uses","(kWh/a)",null,{"$f":"SUM(G153:G183)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(O153:O183)","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,null,null,null,null,null,null,null,{"$f":"SUM(BQ153:BQ179)","v":{"$error":"#VALUE!"}},{"$f":"SUM(BR153:BR179)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[]
[null,null,null,"Equivalent Primary Energy (ePE) generated by renewables(3)",null,null,"In final status(1) or after renovation"]
[]
[null,null,null,"ePE generated by solar thermal collectors","(kWh/a)"]
[]
[null,null,null,"ePE generated by photovoltaic arrays","(kWh/a)"]
[]
[null,null,null,"ePE generated by wind generators","(kWh/a)"]
[]
[null,null,null,"ePE generated by hydroelectric generators","(kWh/a)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"7) Instructions & notes"]
[]
[null,"(0)",null,"Requirements in red are compulsory."]
[null,"(1)",null,"Primary energy required by single energy uses in final status in case of a new building or after renovation in case of an existing building."]
[null,"(2)",null,"Enter legal values according National legislation: in some countries there are legal values specified for any energy use, in others only a total primary energy limit for all uses."]
[null,"(3)",null,"It is possible to enter the single contribution of geothermal and biomass plants "]
[null,null,null,"The contributions of geothermal and biomass plants have to be considered into the calculation of energy need for the specific energy use (heating, cooling, production of warm water, ... )"]
[null,null,null,"Example 1: the energy need required to heat a certain building is 1000 kWhEN. A geothermal plant with an average seasonal COP of 3,5 delivers the needed thermal energy. "]
[null,null,null,"The electric delivered energy required by the geothermal plant to satisfy the energy need is 1000kWhEN / 3,5 = 286 kWhDE. If the delivered to primary energy conversion factor "]
[null,null,null,"for electricity is 2,5, the primary energy consumption required to keep warm the building is 286 kWhDE * 2,5 = 715 kWhPE."]
[null,null,null,"Example 2: energy need required to heat a certain building is 1000 kWhEN. A geothermal plant with an average seasonal COP of 3,5 delivers the 70% of the whole thermal energy required (1000 kWhEN *0,7 = 700 kWhEN). The rest (1000 kWhEN *0,3 = 300 kWhEN) is produced through a boiler with an average seasonal efficiency of 80%. Electric delivered energy required by the geothermal plant is 700 kWhEN / 3,5 = 200 kWhDE,electricity, while fuel delivered energy required by the boiler is 300 kWhEN / 0,80 = 375 kWhDE,fuel. If the delivered to primary energy conversion factor for electricity is 2,5, primary energy consumed by the geothermal plant is 200 kWhDE * 2,5 = 500 kWhPE. If the delivered to primary energy conversion factor for fuel  is 1,1, primary energy consumed by the boiler is 375 kWhDE * 1,1 = 412,5 kWhPE. So the whole consumption of primary energy is           500 kWhPE + 412,5 kWhPE = 912,5 kWhPE."]
[null,"(4)",null,"A positive number indicates that energy consumption has been reduced, while a negative number means that energy consumtion has been increased."]
[null,"(5)",null,"Only if the actual Primary Energy Factor differs from the suggested Primary Energy Factor."]
[null,"(6)",null,"Please insert the benefits with a negative value"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Primary Energy",{"$f":"D185","v":"All uses"},"ePE generated",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,"Primary Energy",{"$f":"AJ185","v":0},"ePE generated"]
[null,null,null,{"$f":"D153","v":"Heating"},{"$f":"O153+O155","v":0},{"$f":"Q185","v":0},{"$f":"SUM(G189:G195)","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,{"$f":"AJ153","v":0},{"$f":"AU153+AU155","v":0},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(AM189:AM195)","v":0}]
[null,null,null,{"$f":"D157","v":"Sanitary Hot Water (SHW) production"},{"$f":"O157+O159","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,{"$f":"AJ157","v":0},{"$f":"AU157+AU159","v":0}]
[null,null,null,{"$f":"D161","v":"Ventilation (auxiliary power for ventialtion)"},{"$f":"O161","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,{"$f":"AJ161","v":0},{"$f":"AU161","v":0}]
[null,null,null,{"$f":"D163","v":"Humidification"},{"$f":"O163","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,{"$f":"AJ163","v":0},{"$f":"AU163","v":0}]
[null,null,null,{"$f":"D165","v":"Cooling"},{"$f":"O165","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,{"$f":"AJ165","v":0},{"$f":"AU165","v":0}]
[null,null,null,{"$f":"D173","v":"Lighting "},{"$f":"O173","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,{"$f":"AJ173","v":0},{"$f":"AU173","v":0}]
[null,null,null,{"$f":"D175","v":"Auxiliary Power Heating"},{"$f":"O175","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,{"$f":"AJ175","v":0},{"$f":"AU175","v":0}]
[null,null,null,{"$f":"D177","v":"Auxiliary Power SHW"},{"$f":"O177","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,{"$f":"AJ177","v":0},{"$f":"AU177","v":0}]
[null,null,null,{"$f":"D179","v":"Other electric uses "},{"$f":"O179","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,{"$f":"AJ179","v":0},{"$f":"AU179","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,{"$f":"#REF!","v":{"$error":"#REF!"}},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":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"#REF!/SUM(#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"#REF!/SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"#REF!/SUM(#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"#REF!/SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"#REF!/SUM(#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"#REF!/SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"#REF!/SUM(#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"#REF!/SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"#REF!/SUM(#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"#REF!/SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"#REF!/SUM(#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"#REF!/SUM(#REF!)","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U283:U288)","v":{"$error":"#REF!"}},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":"SUM(AX283:AX288)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"PEC in final status or after renovation",null,"Net PEC in final status or after renovation",null,"Net PEC in final status or after renovation",null,null,null,"Net PEC in final status or after renovation",null,null,null,"Net PEC in final status or after renovation",null,"PEC in final status or after renovation",null,"Net PEC in final status or after renovation",null,"Net PEC in final status or after renovation",null,null,null,"Net PEC in final status or after renovation",null,null,null,null,null,null,null,null,null,"PEC in final status or after renovation",null,"Net PEC in final status or after renovation",null,"Net PEC in final status or after renovation",null,null,null,"Net PEC in final status or after renovation",null,null,"PEC in final status or after renovation",null,"Net PEC in final status or after renovation",null,"Net PEC in final status or after renovation",null,null,null,"Net PEC in final status or after renovation"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Total Primary Energy",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,"Total Primary Energy"]

{"sheet":"#7c","index":15,"n_rows":209,"n_cols":19,"rows_kept":209,"cut":false,"hidden":false,"merged":[[29,7,29,12],[37,7,39,9],[160,3,160,4],[161,3,161,4],[162,3,162,4],[64,7,64,12],[107,2,107,12],[156,3,156,4],[157,3,157,4],[158,3,158,4],[159,3,159,4]]}
[]
[null,"G) Energy Summary Based on Legal Values - International Projects"]
[]
[]
[]
[null,"G1)","Final energy balance of building"]
[]
[]
[null,null,"Gross floor area (heated)","m²",null,{"$f":"'#2'!W22","v":""}]
[]
[null,null,"Gross volume (heated)","m³",null,{"$f":"'#2'!E34","v":0}]
[]
[]
[null,null,"Final Energy Consumption (FEC) disaggregation",null,null,"In final status(1) or after renovation",null,"Legal values(2) or before renovation",null,"Savings in \npercentage(4)",null,null,"Data source"]
[]
[null,null,"FEC for heating ","(kWh/a)",null,null,null,null,null,{"$f":"IF(OR(H16=\"\",H16=0),\"\",-(F16-H16)/H16)","v":""}]
[]
[null,null,"FEC for cooling & dehumidification ","(kWh/a)",null,null,null,null,null,{"$f":"IF(OR(H18=\"\",H18=0),\"\",-(F18-H18)/H18)","v":""}]
[]
[null,null,"FEC for ventilation & humidification ","(kWh/a)",null,null,null,null,null,{"$f":"IF(OR(H20=\"\",H20=0),\"\",-(F20-H20)/H20)","v":""}]
[]
[null,null,"FEC for Sanitary Hot Water (SHW) production ","(kWh/a)",null,null,null,null,null,{"$f":"IF(OR(H22=\"\",H22=0),\"\",-(F22-H22)/H22)","v":""}]
[]
[null,null,"FEC for lighting ","(kWh/a)",null,null,null,null,null,{"$f":"IF(OR(H24=\"\",H24=0),\"\",-(F24-H24)/H24)","v":""}]
[]
[null,null,"FEC for other electric uses ","(kWh/a)",null,null,null,null,null,{"$f":"IF(OR(H26=\"\",H26=0),\"\",-(F26-H26)/H26)","v":""}]
[]
[null,null,"FEC for all uses","(kWh/a)"]
[]
[null,null,"Equivalent Final Energy generated (FEG) by renewables(3)",null,null,"In final status(1) or after renovation",null,"FINAL ENERGY SUMMARY"]
[]
[null,null,"FEG from solar thermal plant ","(kWh/a)",null,null,null,"Sum of FEC according to legal values",null,null,"(kWh/a)",null,{"$f":"IF(OR(H28=0,H28=\"\"),SUM(H26,H24,H22,H20,H18,H16),H28)","v":0}]
[]
[null,null,"FEG from photovoltaic plant ","(kWh/a)",null,null,null,"Total FEC after renovation or in final status ",null,null,"(kWh/a)",null,{"$f":"IF(OR(F28=0,F28=\"\"),SUM(F16,F26,F24,F22,F20,F18),F28)","v":0}]
[]
[null,null,"FEG from wind generation system ","(kWh/a)",null,null,null,"Total FEG by renewables ",null,null,"(kWh/a)",null,{"$f":"IF(AND(F32=\"\",F34=\"\",F36=\"\",F38=\"\"),0,SUM(F32:F39))","v":0}]
[]
[null,null,"FEG from hydroelectric generator ","(kWh/a)",null,null,null,"Total FEG after renovation or in final status\nincluding renewables",null,null,"(kWh/a)",null,{"$f":"M34-M36","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,"Energy saving percentage including renewables(4)",null,null,"(%)",null,{"$f":"IF(OR(M34=0,M36=0),\"\",1-M38/M32)","v":""}]
[]
[null,null,null,null,null,null,null,"Energy saving percentage without renewables(4)",null,null,"(%)",null,{"$f":"IF(OR(M32=0,M34=0),\"\",1-M34/M32)","v":""}]
[]
[]
[null,"G2)","OPTIONAL: Primary energy balance of building"]
[]
[null,null,"Primary Energy Consumption (PEC) disaggregation according to EN 15603",null,null,"In final status(1) or after renovation",null,"Legal values(2) or before renovation",null,"Savings in \npercentage(4)",null,null,"Data source"]
[]
[null,null,"PEC for heating ","(kWh/a)",null,null,null,null,null,{"$f":"IF(OR(H51=\"\",H51=0),\"\",-(F51-H51)/H51)","v":""},null,null,null,null,null,{"$f":"IF(H51=0,0,F51)","v":0},{"$f":"IF(H51=0,0,H51)","v":0}]
[]
[null,null,"PEC for cooling & dehumidification ","(kWh/a)",null,null,null,null,null,{"$f":"IF(OR(H53=\"\",H53=0),\"\",-(F53-H53)/H53)","v":""},null,null,null,null,null,{"$f":"IF(H53=0,0,F53)","v":0},{"$f":"IF(H53=0,0,H53)","v":0}]
[]
[null,null,"PEC for ventilation & humidification ","(kWh/a)",null,null,null,null,null,{"$f":"IF(OR(H55=\"\",H55=0),\"\",-(F55-H55)/H55)","v":""},null,null,null,null,null,{"$f":"IF(H55=0,0,F55)","v":0},0]
[]
[null,null,"PEC for SHW production ","(kWh/a)",null,null,null,null,null,{"$f":"IF(OR(H57=\"\",H57=0),\"\",-(F57-H57)/H57)","v":""},null,null,null,null,null,{"$f":"IF(H57=0,0,F57)","v":0},0]
[]
[null,null,"PEC for lighting ","(kWh/a)",null,null,null,null,null,{"$f":"IF(OR(H59=\"\",H59=0),\"\",-(F59-H59)/H59)","v":""},null,null,null,null,null,{"$f":"IF(H59=0,0,F59)","v":0},0]
[]
[null,null,"PEC for other electric uses ","(kWh/a)",null,null,null,null,null,{"$f":"IF(OR(H61=\"\",H61=0),\"\",-(F61-H61)/H61)","v":""},null,null,null,null,null,{"$f":"IF(H61=0,0,F61)","v":0},0]
[]
[null,null,"PEC for all uses","(kWh/a)",null,{"$f":"F51+F53+F55+F57+F59+F61","v":0},null,null,null,{"$f":"IF(OR(H63=\"\",H63=0),\"\",-(F63-H63)/H63)","v":""},null,null,null,null,null,{"$f":"IF(H63=0,0,F63)","v":0},0,null,{"$f":"SUM(H51,H53,H55,H57,H59,H61)","v":0}]
[]
[null,null,"Equivalent Primary Energy generated (PEG) by renewables(3)",null,null,"In final status(1) or after renovation",null,"PRIMARY ENERGY SUMMARY"]
[]
[null,null,"PEG from solar thermal plant ","(kWh/a)",null,null,null,"Sum of PEC according to legal values",null,null,"(kWh/a)",null,{"$f":"IF(AND(H63=0,H63=\"\"),SUM(H61,H59,H57,H55,H53,H51),H63)","v":0}]
[]
[null,null,"PEG from photovoltaic plant ","(kWh/a)",null,null,null,"Total PEC after renovation or in final status ",null,null,"(kWh/a)",null,{"$f":"IF(AND(F63=0,F63=\"\"),SUM(F51,F61,F59,F57,F55,F53),F63)","v":0}]
[]
[null,null,"PEG from wind generation system ","(kWh/a)",null,null,null,"Total PEG by renevables ",null,null,"(kWh/a)",null,{"$f":"IF(AND(F67=\"\",F69=\"\",F71=\"\",F73=\"\"),0,SUM(F67:F74))","v":0}]
[]
[null,null,"PEG from hydroelectric generator ","(kWh/a)"]
[]
[null,null,null,null,null,null,null,"Energy saving percentage including renewables(4)",null,null,"(%)",null,{"$f":"IF(OR(M67=0,M69=0,M67=\"\",M69=\"\"),\"\",(Q63-P63+M71)/Q63)","v":""}]
[]
[null,null,null,null,null,null,null,"Energy saving percentage without renewables(4)",null,null,"(%)",null,{"$f":"IF(OR(M67=0,M69=0,M67=\"\",M69=\"\"),\"\",(Q63-P63)/Q63)","v":""}]
[]
[]
[null,null,{"$f":"-F67","v":0}]
[null,null,{"$f":"-F69","v":0}]
[null,null,{"$f":"-F71","v":0}]
[null,null,{"$f":"-F73","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"G) Instructions & notes"]
[]
[null,"(0)","Requirements in red are compulsory."]
[null,"(1)","Primary energy required by single energy uses in final status in case of a new building or after renovation in case of an existing building."]
[null,"(2)","Enter legal values according National legislation: in some countries there are legal values specified for any energy use, in others only a total primary energy limit for all uses."]
[null,"(3)","It is possible to enter the single contribution of geothermal and biomass plants "]
[null,null,"The contributions of geothermal and biomass plants have to be considered into the calculation of energy need for the specific energy use (heating, cooling, production of warm water, ... )"]
[null,null,"Example 1: the energy need required to heat a certain building is 1000 kWhEN. A geothermal plant with an average seasonal COP of 3,5 delivers the needed thermal energy. "]
[null,null,"The electric delivered energy required by the geothermal plant to satisfy the energy need is 1000kWhEN / 3,5 = 286 kWhDE. If the delivered to primary energy conversion factor "]
[null,null,"for electricity is 2,5, the primary energy consumption required to keep warm the building is 286 kWhDE * 2,5 = 715 kWhPE."]
[null,null,"Example 2: energy need required to heat a certain building is 1000 kWhEN. A geothermal plant with an average seasonal COP of 3,5 delivers the 70% of the whole thermal energy required (1000 kWhEN *0,7 = 700 kWhEN). The rest (1000 kWhEN *0,3 = 300 kWhEN) is produced through a boiler with an average seasonal efficiency of 80%. Electric delivered energy required by the geothermal plant is 700 kWhEN / 3,5 = 200 kWhDE,electricity, while fuel delivered energy required by the boiler is 300 kWhEN / 0,80 = 375 kWhDE,fuel. If the delivered to primary energy conversion factor for electricity is 2,5, primary energy consumed by the geothermal plant is 200 kWhDE * 2,5 = 500 kWhPE. If the delivered to primary energy conversion factor for fuel  is 1,1, primary energy consumed by the boiler is 375 kWhDE * 1,1 = 412,5 kWhPE. So the whole consumption of primary energy is           500 kWhPE + 412,5 kWhPE = 912,5 kWhPE."]
[null,"(4)","A positive number indicates that energy consumption has been reduced, while a negative number means that energy consumtion has been increased."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"F49","v":"In final status(1) or after renovation"}]
[null,null,{"$f":"C51","v":"PEC for heating "},{"$f":"F51/SUM($F$51:$F$61)","v":{"$error":"#DIV/0!"}},null,{"$f":"F51","v":0}]
[null,null,{"$f":"C53","v":"PEC for cooling & dehumidification "},{"$f":"F53/SUM($F$51:$F$61)","v":{"$error":"#DIV/0!"}},null,{"$f":"F53","v":0}]
[null,null,{"$f":"C55","v":"PEC for ventilation & humidification "},{"$f":"F55/SUM($F$51:$F$61)","v":{"$error":"#DIV/0!"}},null,{"$f":"F55","v":0}]
[null,null,{"$f":"C57","v":"PEC for SHW production "},{"$f":"F57/SUM($F$51:$F$61)","v":{"$error":"#DIV/0!"}},null,{"$f":"F57","v":0}]
[null,null,{"$f":"C59","v":"PEC for lighting "},{"$f":"F59/SUM($F$51:$F$61)","v":{"$error":"#DIV/0!"}},null,{"$f":"F59","v":0}]
[null,null,{"$f":"C61","v":"PEC for other electric uses "},{"$f":"F61/SUM($F$51:$F$61)","v":{"$error":"#DIV/0!"}},null,{"$f":"F61","v":0}]
[]
[null,null,null,null,null,{"$f":"SUM(F158:F163)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"PEC in final status or after renovation",null,"Net PEC in final status or after renovation",null,"Legal values by end uses",null,null,"Sum of legal values"]
[null,null,{"$f":"C51","v":"PEC for heating "},null,null,{"$f":"F51","v":0},null,null,null,{"$f":"H51","v":0}]
[null,null,{"$f":"C53","v":"PEC for cooling & dehumidification "},null,null,{"$f":"F53","v":0},null,null,null,{"$f":"H53","v":0}]
[null,null,{"$f":"C55","v":"PEC for ventilation & humidification "},null,null,{"$f":"F55","v":0},null,null,null,{"$f":"H55","v":0}]
[null,null,{"$f":"C57","v":"PEC for SHW production "},null,null,{"$f":"F57","v":0},null,null,null,{"$f":"H57","v":0}]
[null,null,{"$f":"C59","v":"PEC for lighting "},null,null,{"$f":"F59","v":0},null,null,null,{"$f":"H59","v":0}]
[null,null,{"$f":"C61","v":"PEC for other electric uses "},null,null,{"$f":"F61","v":0},null,null,null,{"$f":"H61","v":0}]
[null,null,{"$f":"C67","v":"PEG from solar thermal plant "},null,null,{"$f":"-F67","v":0}]
[null,null,{"$f":"C69","v":"PEG from photovoltaic plant "},null,null,{"$f":"-F69","v":0}]
[null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"-#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"-#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"C71","v":"PEG from wind generation system "},null,null,{"$f":"-F71","v":0}]
[null,null,{"$f":"C73","v":"PEG from hydroelectric generator "},null,null,{"$f":"-F73","v":0}]
[null,null,"Total Primary Energy",null,null,null,null,{"$f":"M69-M71","v":0},null,null,null,null,{"$f":"M67","v":0}]

{"sheet":"#8","index":16,"n_rows":54,"n_cols":3,"rows_kept":54,"cut":false,"hidden":false,"merged":[[43,2,44,2],[40,2,41,2],[37,2,38,2],[37,6,38,6],[40,6,41,6],[43,6,44,6],[7,2,8,2],[10,2,11,2],[13,2,14,2],[18,2,19,2],[13,6,14,6],[7,6,8,6],[10,6,11,6],[18,6,19,6],[21,2,22,2],[26,2,27,2],[29,2,30,2],[34,2,35,2],[34,6,35,6],[21,6,22,6],[26,6,27,6],[29,6,30,6]]}
[]
[null,"8) Energy Management"]
[]
[]
[]
[null,"8.1)","Policy"]
[]
[null,null,"Is there an explicit environmental policy?\nPlease, specify."]
[]
[]
[null,null,"Does the environmental policy include energy considerations? Please, specify."]
[]
[]
[null,null,"Do the long term profitability criteria include energy considerations? Please, specify."]
[]
[]
[null,"8.2)","Design and construction"]
[]
[null,null,"Do construction and refurbishment procedures include energy considerations? Please, specify."]
[]
[]
[null,null,"Does the internal design procedure include energy considerations? Please, specify."]
[]
[]
[null,"8.3)","Component and system choice"]
[]
[null,null,"Do the purchasing and service procedures include energy considerations? Please, specify."]
[]
[]
[null,null,"Does the facility management procedure include energy consideration? Please, specify."]
[]
[]
[null,"8.4)","Operation and manteinance"]
[]
[null,null,"Does the company have any monitoring plan and specific energy measurements? Please, specify."]
[]
[]
[null,null,"Does the company have specific energy costs in its accounting? Please, specify."]
[]
[]
[null,null,"Does the company have a person responsible for energy-related issues? Please, specify."]
[]
[]
[null,null,"Do operations and maintenance practices include energy considerations? Please, specify."]
[]
[]
[]
[]
[]
[]
[]
[null,"I) Instructions & notes"]
[]
[null,"(0)"]

{"sheet":"#ID1","index":17,"n_rows":60,"n_cols":8,"rows_kept":60,"cut":false,"hidden":true,"merged":[[8,17,8,18],[8,23,8,24],[8,25,8,26],[8,19,8,20],[8,21,8,22]]}
[]
[null,"10) Integrated Design Work Team"]
[]
[]
[]
[null,"10.1)","Communication among team members"]
[]
[null,null,"Sharing information approach",null,null,null,null,"Please specify"]
[]
[null,"10.2)","ID facilitator"]
[]
[null,null,"Was he/she appointed?",null,null,null,null,"Surname, Name"]
[]
[null,null,"Phone number",null,null,null,null,"E-mail address"]
[]
[null,"10.3)","Which are/were the stakeholders actually involved into the design team?"]
[]
[null,null,"Architect",null,null,null,null,"Landtscape architect"]
[]
[null,null,"Constructor",null,null,null,null,"Occupant"]
[]
[null,null,"Engineer",null,null,null,null,"Operating staff"]
[]
[null,null,"Future building manager",null,null,null,null,"Owner"]
[]
[null,null,"Interior designer",null,null,null,null,"Other, please specify"]
[]
[null,"10.4)","Which disciplines have been included in the design team?"]
[]
[null,null,"Acoustical engineering",null,null,null,null,"IT engineering"]
[]
[null,null,"Architecture",null,null,null,null,"Interior design"]
[]
[null,null,"Architectural programming",null,null,null,null,"Historic preservation"]
[]
[null,null,"Building physics",null,null,null,null,"Landscape architecture"]
[]
[null,null,"Civil/Seismic engineering",null,null,null,null,"Lighting design"]
[]
[null,null,"Commissioning ",null,null,null,null,"Mechanical engineering"]
[]
[null,null,"Cost estimation",null,null,null,null,"Productivity"]
[]
[null,null,"Electrical engineering",null,null,null,null,"Space planner"]
[]
[null,null,"Environmental engineering",null,null,null,null,"Surveying "]
[]
[null,null,"Fire safety engineering",null,null,null,null,"Urban planning"]
[]
[null,null,"HVAC engineering",null,null,null,null,"Other, please specify"]
[]
[]
[]
[]
[]
[]
[]
[null,"10) Instructions & notes"]
[]
[null,"(0)","Requirements in red are compulsory."]

{"sheet":"#ID2","index":18,"n_rows":66,"n_cols":39,"rows_kept":66,"cut":false,"hidden":true,"merged":[[40,5,40,9],[40,14,40,18],[45,25,45,26],[45,27,45,28],[34,5,34,9],[36,5,36,9],[36,14,36,18],[34,14,34,18],[38,5,38,9],[38,14,38,18],[64,2,64,18],[65,2,65,18],[48,2,48,4],[45,33,45,34],[45,31,45,32],[45,29,45,30],[15,14,15,18],[24,2,24,4],[7,5,7,9],[9,5,9,9],[7,14,7,18],[9,14,9,18],[11,5,11,9],[11,14,11,18],[24,14,24,18],[19,5,19,9],[19,14,19,18],[15,5,15,9],[13,5,13,9],[13,14,13,18],[24,11,24,13],[30,5,30,9],[24,5,24,9],[19,2,20,4],[19,11,20,13],[32,14,32,18],[32,5,32,9],[26,2,26,4],[30,11,30,18],[26,5,26,9],[26,14,26,18],[26,11,26,13]]}
[]
[null,"11) Integrated Design Process"]
[]
[]
[]
[null,"11.1)","Check the explicit objectives of the building design process"]
[]
[null,null,"Aesthetics",null,null,null,null,null,null,null,null,"Historic preservation"]
[]
[null,null,"Accessibility",null,null,null,null,null,null,null,null,"Productivity"]
[]
[null,null,"Cost-effectiveness",null,null,null,null,null,null,null,null,"Secure/Safety"]
[]
[null,null,"Energy efficiency",null,null,null,null,null,null,null,null,"Sustainability"]
[]
[null,null,"Functionality",null,null,null,null,null,null,null,null,"Other, please specify"]
[]
[null,"11.2)","Control strategies"]
[]
[null,null,"Have Quality Assurance and Control Plan been set?",null,null,null,null,null,null,null,null,"Has a responsible been identified for each design phase?"]
[]
[]
[null,"11.3)","Have you adopted any of these planning and schedulling design tools?"]
[]
[null,null,"Gantt chart",null,null,null,null,null,null,null,null,"Building Process Manag. (BPM)"]
[]
[null,null,"PERT and/or CPM(1)",null,null,null,null,null,null,null,null,"Building Information Model (BIM)"]
[]
[null,"11.4)","Have you adopted any of these Building Information Model Tools - BIM?"]
[]
[null,null,null,null,null,"Tool dimension",null,null,null,null,null,"Tool name"]
[]
[null,null,"Architecture composition",null,null,null,null,null,null,null,null,"Architecture composition"]
[]
[null,null,"Structural sizing",null,null,null,null,null,null,null,null,"Structural sizing"]
[]
[null,null,"Building systems (MEP)",null,null,null,null,null,null,null,null,"Building systems (MEP)"]
[]
[null,null,"Construction management",null,null,null,null,null,null,null,null,"Construction management"]
[]
[null,null,"Facility management",null,null,null,null,null,null,null,null,"Facility management"]
[]
[null,"11.5)","Design planning"]
[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,"x","y"]
[null,null,null,null,null,"Beginning\ndate",null,"End\ndate",null,"Duration\nin day",null,"Estimed hours spent(2)",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":"V48","v":"Initial planning"},{"$f":"W47","v":0},{"$f":"$X$48","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Duration (d)","Hours spent by the design team (h)",null,{"$f":"AK45","v":"Initial planning"},null,{"$f":"AK47","v":"Competition"},null,{"$f":"AK49","v":"Concept design"},null,{"$f":"AK51","v":"Detailed design"},null,{"$f":"AK53","v":"Construction"},null,null,null,{"$f":"W48","v":0},{"$f":"$X$48","v":0}]
[null,null,"Initial planning phase",null,null,null,null,null,null,{"$f":"IF((H47-F47)<0,\"\",H47-F47)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,"x","y","x","y","x","y","x","y","x","y",null,{"$f":"V49","v":"Competition"},{"$f":"W48","v":0},{"$f":"$X$49","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Initial planning",{"$f":"J47","v":0},{"$f":"L47","v":0},null,{"$f":"W48","v":0},0,null,null,null,null,null,null,null,null,null,null,{"$f":"W49","v":0},{"$f":"$X$49","v":0}]
[null,null,"Competition phase (if applicable)",null,null,null,null,null,null,{"$f":"IF((H49-F49)<0,\"\",H49-F49)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Competition",{"$f":"W48+J49","v":0},{"$f":"L49","v":0},null,{"$f":"W48","v":0},{"$f":"MAX($X$47:$X$52)*1.1","v":0},{"$f":"W49","v":0},0,null,null,null,null,null,null,null,{"$f":"V50","v":"Concept design"},{"$f":"W49","v":0},{"$f":"$X$50","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Concept design",{"$f":"W49+J51","v":0},{"$f":"L51","v":0},null,null,null,{"$f":"W49","v":0},{"$f":"MAX($X$47:$X$52)*1.1","v":0},{"$f":"W50","v":0},0,null,null,null,null,null,null,{"$f":"W50","v":0},{"$f":"$X$50","v":0}]
[null,null,"Concept design phase",null,null,null,null,null,null,{"$f":"IF((H51-F51)<0,\"\",H51-F51)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Detailed design",{"$f":"W50+J53","v":0},{"$f":"L53","v":0},null,null,null,null,null,{"$f":"W50","v":0},{"$f":"MAX($X$47:$X$52)*1.1","v":0},{"$f":"W51","v":0},0,null,null,null,{"$f":"V51","v":"Detailed design"},{"$f":"W50","v":0},{"$f":"$X$51","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Construction",{"$f":"+W51+J55","v":0},{"$f":"L55","v":0},null,null,null,null,null,null,null,{"$f":"W51","v":0},{"$f":"MAX($X$47:$X$52)*1.1","v":0},{"$f":"W52","v":0},0,null,null,{"$f":"W51","v":0},{"$f":"$X$51","v":0}]
[null,null,"Detailed design phase",null,null,null,null,null,null,{"$f":"IF((H53-F53)<0,\"\",H53-F53)","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,{"$f":"W52","v":0},{"$f":"MAX($X$47:$X$52)*1.1","v":0},null,{"$f":"V52","v":"Construction"},{"$f":"W51","v":0},{"$f":"$X$52","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,{"$f":"W52","v":0},{"$f":"$X$52","v":0}]
[null,null,"Construction phase",null,null,null,null,null,null,{"$f":"IF((H55-F55)<0,\"\",H55-F55)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,"11) Instructions & notes"]
[]
[null,"(1)","PERT is an acronym for Program Evaluation and Review Technique; CPM ia an acronym for Critical Path Method. Both are project management techniques, which have been developed \nto plan, schedule and control complex projects."]
[null,"(2)","Please, specify the total number of hours spent by all members of the design team to develop each design phase."]

{"sheet":"2_Energy saving measures","index":19,"n_rows":199,"n_cols":4,"rows_kept":199,"cut":false,"hidden":true,"merged":[]}
["ENERGY SAVINGS MEASURES"]
[]
["MEASURES"]
[]
[]
[null,"N_M_Cat"]
["Building envelope"]
["Heating system"]
["Cooling system"]
["Lighting"]
["Electric equipment"]
["Management"]
[]
[]
["Building envelope","Changing/Installation: type of glazing","N_M_BuiEnv"]
["Building envelope","Changing/Installation: type of frame"]
["Building envelope","Improving insulation of envelope components"]
["Building envelope","Reducing unwanted solar heat gains"]
["Building envelope","Modifying geometry"]
["Heating system","Selection of energy efficient product","N_M_HeaSys"]
["Heating system","Optimisation of the regulation"]
["Heating system","Improvement of the heating supply system"]
["Cooling system","Chiller circuit and control","N_M_CooSys"]
["Cooling system","Motors and fans"]
["Cooling system","Design & Sizing"]
["Cooling system","Decentralised system"]
["Cooling system","System based on water distribution"]
["Cooling system","System with circulation of refrigerant"]
["Cooling system","Equipment for air handling AS1 Central Free cooling"]
["Cooling system","Systems with water and air AWS1 Improved control of classic system"]
["Cooling system","Systems with water loop"]
["Cooling system","Alternative Equipment strategies E1 District or block cooling"]
["Lighting","Selection of energy efficient lamps","N_M_Lig"]
["Lighting","Connecting devices"]
["Lighting","Improvement of luminaires"]
["Lighting","Control Systems"]
["Lighting","Design"]
["Electric equipment","Selection of energy efficient equipment","N_M_EleEqu"]
["Electric equipment","Selection of energy efficient devices"]
["Electric equipment","User specific saving potentials"]
["Management","Behaviour","N_M_Man1"]
["Management","Maintenance"]
[]
[]
["Building envelope","Changing/Installation: type of glazing","Clear double glazed unit (6mm float + 12mm air + 6mm float)  ","N_M_ChaTypGla"]
[null,"Changing/Installation: type of glazing","Heat mirror double glazed unit (6mm float + 12mm air + 6mm “low-e coated” glass)  "]
[null,"Changing/Installation: type of glazing","Heat mirror double glazed unit (6mm float + 16mm argon + 6mm “low-e coated” glass)"]
[null,"Changing/Installation: type of glazing","Solar control double glazed unit “soft coating”  (6mm spectral selective + 16mm argon + 6mm float)"]
[null,"Changing/Installation: type of glazing","Solar control double glazed unit “hard coating” (6mm spectral selective + 12mm air + 6mm float)  "]
[null,"Changing/Installation: type of glazing","Triple glazed unit (6mm low-e glass + 16mm argon + 6mm float glass + 16mm argon + 6mm low-e glass)"]
[null,"Changing/Installation: type of frame","Aluminum with thermal break  ","N_M_ChaTypFra"]
[null,"Changing/Installation: type of frame","Plastic  "]
[null,"Changing/Installation: type of frame","Wood  "]
[null,"Improving insulation of envelope components","Localisation and elimination of thermal bridges  ","N_M_ImpInsEnv"]
[null,"Improving insulation of envelope components","Improving insulation of opaque building envelope"]
[null,"Improving insulation of envelope components","Improving insulation of opaque external walls"]
[null,"Improving insulation of envelope components","Improving insulation of opaque external roofs"]
[null,"Improving insulation of envelope components","Improving insulation of the ground floor"]
[null,"Improving insulation of envelope components","Improving insulation of transparent components of building envelope  "]
[null,"Improving insulation of envelope components","Improving insulation of vertical windows or/and transparent façades  "]
[null,"Improving insulation of envelope components","Improving insulation of skylights"]
[null,"Improving insulation of envelope components","Addition of a new envelope  "]
[null,"Reducing unwanted solar heat gains","By installation of movable shading devices  ","N_M_RedSolHeaGai"]
[null,"Reducing unwanted solar heat gains","By installation of permanent shading devices  "]
[null,"Reducing unwanted solar heat gains","By installation of solar control glazing  "]
[null,"Modifying geometry","Reducing \"lossing surface\"/\"Heated volume\" rate  ","N_M_ModGeo"]
[null,"Modifying geometry","Reducing transparent/opaque rate  "]
["Heating system","Selection of energy efficient product","Installation of a low temperature boiler or a condensing boiler","N_M_SelEneEffPro"]
[null,"Selection of energy efficient product","Installation of well dimensioned heating pumps with power regulation"]
[null,"Selection of energy efficient product","Installation of thermostatic radiator valves"]
[null,"Optimisation of the regulation","Installation thermostatic valves","N_M_OptReg"]
[null,"Optimisation of the regulation","Outdoor-temperature regulation"]
[null,"Optimisation of the regulation","Improvement of regulation at secondary supply system"]
[null,"Optimisation of the regulation","Limitation of hot water circulation pump by timer"]
[null,"Optimisation of the regulation","Activation of night-drawdown"]
[null,"Optimisation of the regulation","Activation of weekend-drawdown"]
[null,"Improvement of the heating supply system","Insulation of supply system in the basement","N_M_ImpHeaSupSys"]
[null,"Improvement of the heating supply system","Reducing the temperature of the hot water boiler"]
[null,"Improvement of the heating supply system","Improvement of hydraulic system"]
[null,"Improvement of the heating supply system","Optimise the division of the heating circuits"]
["Cooling system","Chiller circuit and control","Optimisation of cost/efficiency at full load (some threshold on accepted EER)  ","N_M_ChiCirCon"]
[null,"Chiller circuit and control","Optimisation of cost/efficiency at part load"]
[null,"Chiller circuit and control","Stable cold source at good temperature (river, aquifer)  "]
[null,"Chiller circuit and control","Multi-speed strategies & swept volume control  "]
[null,"Chiller circuit and control","Variable speed strategies  "]
[null,"Chiller circuit and control","Improved effectiveness of the tower, selection of fillings flow rates  "]
[null,"Chiller circuit and control","Optimal loading of stages  "]
[null,"Chiller circuit and control","Sharing of load among chillers & loading of chillers (when various)  "]
[null,"Chiller circuit and control","Optimal control of cooling tower for low auxiliaries and lowest cost effective condensing temperature  "]
[null,"Chiller circuit and control","Free cooling integrated into the chiller  "]
[null,"Chiller circuit and control","Reduction of power of cooling tower under a simpler form than CH9  "]
[null,"Motors and fans","Motor Eff. 2","N_M_MotFan"]
[null,"Motors and fans","Motor Eff. 1"]
[null,"Motors and fans","Selection of fans characteristic curves and the pressure control  "]
[null,"Motors and fans","Improved local tangential ventilator  "]
[null,"Motors and fans","Improved fans on condensers, AHU  "]
[null,"Motors and fans","Better filters, Classic option in design  "]
[null,"Motors and fans","Less pressure drop in all parts  "]
[null,"Motors and fans","Variable speed  "]
[null,"Motors and fans","Feasibility of local stopping of each electrical motor  "]
[null,"Motors and fans","Feasibility of central stopping of each electrical motor by BEMS  "]
[null,"Design & Sizing","Decentralised system banned over a certain limit  ","N_M_DesSiz"]
[null,"Design & Sizing","Over-sizing banned, some under-sizing acceptable  "]
[null,"Design & Sizing","Quality of the service of \"sizing\""]
[null,"Design & Sizing","Optimisation of multi-zone sizing & prohibition of cold & hot mixing  "]
[null,"Design & Sizing","Sizing by full plant simulation  "]
[null,"Design & Sizing","Careful organisation of set points and control dead bands since design  "]
[null,"Design & Sizing","Automatic adjustment of pressures planned from design  "]
[null,"Decentralised system","Local Free cooling","N_M_DecSys"]
[null,"Decentralised system","Changing control setpoints (temperature, humidity)"]
[null,"Decentralised system","Reversibility (local heat pump)"]
[null,"Decentralised system","Optimisation of cost/efficiency at full load (some threshold on accepted EER)"]
[null,"System based on water distribution","Control on the returns at 7/12","N_M_SysBasWatDis"]
[null,"System based on water distribution","Moving to 8/14 on departure"]
[null,"System based on water distribution","Moving to 8/16 on departure"]
[null,"System based on water distribution","Variable temperature on departures"]
[null,"System based on water distribution","Variable temperature on returns"]
[null,"System based on water distribution","Circuiting of chillers, “decoupling”, variable speed in distribution"]
[null,"System based on water distribution","Improved pumps"]
[null,"System based on water distribution","Pipes insulation reinforced"]
[null,"System based on water distribution","Less head losses, use of surfactants"]
[null,"System based on water distribution","Better control of FCU"]
[null,"System based on water distribution","Cold ceilings/ Beams/ Slabs"]
[null,"System based on water distribution","Reversibility"]
[null,"System based on water distribution","Water side free cooling"]
[null,"System with circulation of refrigerant","Optimisation of cost/efficiency at full load (some threshold on accepted EER) ","N_M_SysCirRef"]
[null,"System with circulation of refrigerant","Local free cooling "]
[null,"System with circulation of refrigerant","Reversible MS "]
[null,"System with circulation of refrigerant","Moving to the VRF (compression benefits) in MS "]
[null,"System with circulation of refrigerant","Optimal distribution of flows by electronic unit in VRF "]
[null,"System with circulation of refrigerant","Reversible behaviour of the VRF 2 pipes "]
[null,"System with circulation of refrigerant","Reversible behaviour of the VRF 3 pipes "]
[null,"System with circulation of refrigerant","Changing control setpoints (temperature, humidity) "]
[null,"Equipment for air handling AS1 Central Free cooling","Smaller percentage of outside air  ","N_M_EquUTA"]
[null,"Equipment for air handling AS1 Central Free cooling","Variable air volume (VAV)  "]
[null,"Equipment for air handling AS1 Central Free cooling","Better fans in AHU  "]
[null,"Equipment for air handling AS1 Central Free cooling","Application of EUROVENT specifications for AHUs (more insulation, ...)  "]
[null,"Equipment for air handling AS1 Central Free cooling","Cost effective AHU  "]
[null,"Equipment for air handling AS1 Central Free cooling","Optimised blowing temperature (10-16 °C)  "]
[null,"Equipment for air handling AS1 Central Free cooling","Quality of the moisture control system (critical for energy consumption)  "]
[null,"Equipment for air handling AS1 Central Free cooling","Correction of the poor multi-zone efficiency of air systems  "]
[null,"Equipment for air handling AS1 Central Free cooling","Sensor of occupancy and other “demand controlled” ventilation  "]
[null,"Equipment for air handling AS1 Central Free cooling","Central heat/cold Recovery within the HVAC system  "]
[null,"Equipment for air handling AS1 Central Free cooling","Prohibition and successive cooling & reheating  "]
[null,"Equipment for air handling AS1 Central Free cooling","Ducts insulation and leakage limitation  "]
[null,"Equipment for air handling AS1 Central Free cooling","Existence of an A/C stopping & controlling possibility in each zone  "]
[null,"Equipment for air handling AS1 Central Free cooling","Ventilation should be in cascade among rooms  "]
[null,"Equipment for air handling AS1 Central Free cooling","Reversibility by use of the same chiller as a heat pump  "]
[null,"Equipment for air handling AS1 Central Free cooling","Recovery of heat for DHW  "]
[null,"Systems with water and air AWS1 Improved control of classic system","Ejector improved allowing blowing temperature at 18°C ","N_M_SysWatAir"]
[null,"Systems with water and air AWS1 Improved control of classic system","Cold ceilings/Beams/Slabs + additional system by air "]
[null,"Systems with water and air AWS1 Improved control of classic system","“Displacement” equipment "]
[null,"Systems with water and air AWS1 Improved control of classic system","Reversibility "]
[null,"Systems with water loop","Optimisation of cost/efficiency at full load (some threshold on accepted EER) ","N_M_SysWatLoo"]
[null,"Alternative Equipment strategies E1 District or block cooling","Absorption or mixed strategies  ","N_M_AltEquStr"]
[null,"Alternative Equipment strategies E1 District or block cooling","Cool storage  "]
[null,"Alternative Equipment strategies E1 District or block cooling","Use of condenser to heat domestic hot water (DHW)  "]
[null,"Alternative Equipment strategies E1 District or block cooling","Evaporative cooling  "]
[null,"Alternative Equipment strategies E1 District or block cooling","Desiccant cooling  "]
[null,"Alternative Equipment strategies E1 District or block cooling","Natural cooling from cooling tower (free-chilling)  "]
["Lighting","Selection of energy efficient lamps","Fluorescent lamps replacing incandescent lamps  ","N_M_SelEneEffLam"]
[null,"Selection of energy efficient lamps","Fluorescent lamps replacing inefficient fluorescent lamps  "]
[null,"Connecting devices","Electronic ballasts replacing magnetic ballasts  ","N_M_ConDev"]
[null,"Improvement of luminaires","Aluminium reflectors replacing white painted reflectors  ","N_M_ImpLum"]
[null,"Improvement of luminaires","Introduction of luminaires with light direction, reducing the number of luminaires needed  "]
[null,"Improvement of luminaires","Improving older luminaires by replacing diffusers or prismatic panels with reflector systems  "]
[null,"Control Systems","Introduction of occupancy linking controls  ","N_M_ConSys"]
[null,"Control Systems","Introduction of time scheduling controls  "]
[null,"Control Systems","Introduction of daylight responsive controls  "]
[null,"Design","‘Localized lighting’, e.g. of work places  ","N_M_Des"]
["Office equipment","Selection of energy efficient equipment","Notebook replacing desktop PC  ","N_M_SelEneEffEqu"]
[null,"Selection of energy efficient equipment","LCD monitors replacing CRT  "]
[null,"Selection of energy efficient equipment","Multi-function devices replacing separate single-function devices  "]
[null,"Selection of energy efficient equipment","Centralised printer replacing personal printer  "]
[null,"Selection of energy efficient devices","Use of Energy-Star criteria  ","N_M_SelEneEffDev"]
[null,"Selection of energy efficient devices","Use of GEEA criteria  "]
[null,"Selection of energy efficient devices","Hard switch  "]
[null,"Selection of energy efficient devices","Power management configuration  "]
[null,"User specific saving potentials","Initiate power management  ","N_M_UseSpeSavPot"]
[null,"User specific saving potentials","Use of switchable multiway connector  "]
["Management","Behaviour","Free dress code","N_M_Beh"]
[null,"Behaviour","Turning off the thermostat valves"]
[null,"Behaviour","Increasing awareness on airing methods"]
[null,"Behaviour","Replace screensaver by standby/sleep mode  "]
[null,"Maintenance","Regular cleaning of luminaires  ","N_M_Man"]
[null,"Maintenance","Replacement of aged lamps with insufficient luminace  "]
[null,"Maintenance","Recording energy consumption  "]
[null,"Maintenance","Monitoring energy consumption with a BEMS  "]
[null,"Maintenance","Obligation to install a device allowing to measure temperature in each zone  "]
[null,"Maintenance","Optimisation of the change of the filters  "]
[null,"Maintenance","Cleaning of condensing coils  "]
[null,"Maintenance","Cleaning of evaporating coils  "]
[null,"Maintenance","Optimal scheduling of M4-M6  "]
[null,"Maintenance","Fine tuning of controls, namely through BEMS  "]
[null,"Maintenance","Fault detection systematic thanks to BEMS  "]
[null,"Maintenance","Contract of controlled service (which criterion?)  "]
[null,"Maintenance","Performance Contracting  "]
[null,"Maintenance","Balancing planned in design  "]
[null,"Maintenance","Operation manual written by designer and transferred to operator  "]

{"sheet":"3_Data collection","index":20,"n_rows":528,"n_cols":17,"rows_kept":528,"cut":false,"hidden":true,"merged":[]}
["DATA COLLECTION"]
[]
["COUNTRIES"]
["Austria"]
["Belgium"]
["Bulgaria"]
["Cyprus"]
["Czech Republic"]
["Denmark"]
["Estonia"]
["Finland"]
["France"]
["Germany"]
["Greece"]
["Hungary"]
["Iceland"]
["Ireland"]
["Italy"]
["Latvia"]
["Liechtenstein"]
["Lithuania"]
["Luxembourg"]
["Malta"]
["Netherlands"]
["Norway"]
["Poland"]
["Portugal"]
["Romania"]
["Slovakia"]
["Slovenia"]
["Spain"]
["Sweden"]
["United Kingdom"]
[]
["BUILDING TYPE OF USE"]
["Office"]
["Culture: cinema"]
["Culture: cultural centre, party hall, theatre, etc."]
["Culture: museum and art gallery"]
["Culture: library"]
["Culture: church"]
["Retail trade: small shop"]
["Retail trade: shopping mall, supermarket, ..."]
["Accommodation group: hotel"]
["Accommodation group: restaurant, pub, casino, ... "]
["Housing: housing for students"]
["School: primary and secondary (4-18 year)"]
["School: university and college (>18 year)"]
["Sport: sport hall"]
["Sport: swimming pool"]
["Sport: swimming pool and sport hall"]
["Care: nursery / crèche"]
["Care: rest home"]
["Care: hospital and psychiatry"]
["Care: prison"]
["Other: industrial or agrarian buildings"]
["Other: laboratories"]
["Other: fire brigade"]
[]
["TYPE OF INTERVENTION"]
["TYPE OF INTERVENTION"]
["New building (legal value)"]
["Complete renovation of existing building (legal value)"]
["Renovation of existing building (consumption)"]
[]
["TYPE OF SUBMITTED DOCUMENTATION"]
["TYPE OF SUBMITTED DOCUMENTATION"]
["(P) Application form"]
["(P) Energy audit"]
["(P) Energy analysis"]
["(P) Action Plan"]
["(E) Promotion Plan"]
[]
["TYPE OF FLOOR AREA"]
["TYPE OF FLOOR AREA"]
["Not present"]
["Net"]
["Gross"]
[]
["RATIO NET/GROSS FLOOR AREA"]
["RATIO NET/GROSS FLOOR AREA"]
[0.5]
[0.55000000000000004]
[0.6]
[0.65]
[0.7]
[0.75]
[0.8]
[0.85]
[0.9]
[]
[]
[]
[]
[]
[]
["CLASS OF YEAR CONSTRUCTION"]
["CLASS OF YEAR CONSTRUCTION"]
["Previous 1919"]
["1920-1944"]
["1945-1959"]
["1960-1969"]
["1970-1979"]
["1980-1989"]
["1990-1999"]
["2000-2004"]
["2005-2010"]
["After 2010"]
[]
[]
["BUILDING ENVELOPE"]
["TYPE OF GLAZING"," Uc.o.g. \nW/(m2 K)    "," g  ","tv"," LSG  "]
["(ext. pane / gas / int pane )  ",null," "," "," "]
[" Clear Double Glazed Unit\n(6mm float + 12mm Air + 6mm float)  ",2.6,0.75,0.81,1.1000000000000001]
[" Heat mirror Double Glazed Unit\n(6mm float + 12mm Air + 6mm “low-e coated” glass)  ",1.5,0.57999999999999996,0.71,1.2]
["Heat mirror Double Glazed Unit\n(6mm float + 16mm Argon + 6mm “low-e coated” glass)",1.1000000000000001,0.56000000000000005,0.71,1.3]
[" Solar control Double Glazed Unit “soft coating”\n (6mm spectral selective + 16mm Argon + 6mm float)",1.1000000000000001,0.31,0.54,1.7]
[" Solar control Double Glazed Unit “hard coating” \n (6mm spectral selective + 12mm Air + 6mm float)  ",2.6,0.46,0.48,1]
[" Triple Glazed Unit \n(6mm low-e glass + 16mm Argon + 6mm float glass + 16mm Argon + 6mm low-e glass)",0.6,0.36,0.62,1.7]
[]
["TYPE OF FRAME"," Uf \nW/(m2K)"]
[" Aluminum with thermal break  ",3.5]
[" Plastic  ",2.5]
[" Wood  ",1.7]
[]
["CLIMATE ZONES"]
["ENVIRONMENTAL ZONES"]
["Alpine North (ALN)"]
["Boreal (BOR)"]
["Nemoral (NEM)"]
["Atlantic North (ATN)"]
["Alpine South (ALS)"]
["Continental (CON)"]
["Atlantic Central (ATC)"]
["Pannonian (PAN)"]
["Lusitanian (LUS)"]
["Anatolian (ANO)"]
["Mediterranean Mountains (MDM)"]
["Mediterranean North (MDN)"]
["Mediterranean South (MDS)"]
[]
["TYPE OF SURROUNDING"]
["Rural"]
["Suburb"]
["City"]
[]
["COMFORT"]
["COMFORT MODELS"]
["Not explicited"]
["Fanger"]
["Adaptive"]
[]
["LOCAL OR INDIVIDUAL ADAPTATION"]
["No dress code"]
["Low thermal resistance chairs"]
["No dress code + Low thermal resistance chairs"]
["Other …"]
[]
["TYPE OF SETPOINT TEMPERATURE"]
[]
["Air temperature","Air temperature"]
["Operative temperature","Operative temperature"]
[null,"Adaptive comfort model"]
[]
["AIR TIGHTNESS"]
["CLASS OF AIRTHIGTNESS (EN 12207)"]
["Class 0"]
["Class 1"]
["Class 2"]
["Class 3"]
["Class 4",null,null,null,null,null,null,null,null,null,null,null,null,1.08,null,null,"OIB-6 v.2011"]
[null,null,null,null,null,"Primary Energy Factor"]
["HEATING PLANT",null,null,null,null,"OIB6-2015","OIB6-2011"]
["TYPE OF USE OF THE HEATING PRODUCTION"]
["Only heating",null,null,null,"Petroleum Oil",1.23,1.23]
["Heating + SHW",null,null,null,"Kohle",1.46,1.46]
[null,null,null,null,"Petroleum Gas",1.17,1.17,null,null,null,"OIB-6 v.2011"]
["TYPE OF THE PRODUCTION SYSTEM",null,null,null,"Electricity (Austria)",1.91,2.62,null,null,null,"Austrian-Mix; OIB-6 v.2011"]
["Methane boiler",null,null,null,{"$f":"A179","v":"Methane boiler"},{"$f":"F177","v":1.17},{"$f":"G177","v":1.17}]
["Gas oil boiler",null,null,null,{"$f":"A180","v":"Gas oil boiler"},{"$f":"F175","v":1.23},{"$f":"G175","v":1.23}]
["Electric boiler",null,null,null,"Electric boiler",{"$f":"F178","v":1.91},{"$f":"G178","v":2.62}]
["Biomass boiler",null,null,null,"Biomass boiler",1.08,1.08]
["Electric heat pump",null,null,null,"Electric heat pump",2.62,2.62]
["District heating (renewable)",null,null,null,"District heating (renewable)",1.6,1.6,null,null,null,"OIB-6 v.2011"]
["District heating (non renewable)",null,null,null,"District heating (non renewable)",1.52,1.52]
["District heating high efficiency cogeneration plant",null,null,null,"District heating high efficiency cogeneration plant",0.94,0.92]
["District heating Vienna",null,null,null,"District heating Vienna",0.33,0.33]
["Tri/Cogeneration plant",null,null,null,"Tri/Cogeneration plant",{"$f":"F186","v":0.94},{"$f":"G186","v":0.92}]
["Other"]
["SHW PLANT"]
["TYPE OF THE PRODUCTION SYSTEM"]
["Not installed","Not installed"]
["Autonomuos methane boiler","Combined methane boiler",null,null,"Autonomuos methane boiler",{"$f":"F179","v":1.17},{"$f":"G179","v":1.17}]
["Autonomous gas oil boiler","Combined gas oil boiler",null,null,"Autonomous gas oil boiler",{"$f":"F180","v":1.23},{"$f":"G180","v":1.23}]
["Autonomous biomass boiler","Combined biomass boiler",null,null,"Autonomous biomass boiler",{"$f":"F182","v":1.08},{"$f":"G182","v":1.08}]
["Combined methane boiler",null,null,null,"Combined methane boiler",{"$f":"F179","v":1.17},{"$f":"G179","v":1.17}]
["Combined gas oil boiler","Electric heat pump",null,null,"Combined gas oil boiler",{"$f":"F180","v":1.23},{"$f":"G180","v":1.23}]
["Combined biomass boiler","District heating",null,null,"Combined biomass boiler",{"$f":"F182","v":1.08},{"$f":"G182","v":1.08}]
["Electric boiler","Tri/Cogeneration plant",null,null,"Electric boiler",{"$f":"F178","v":1.91},{"$f":"G178","v":2.62}]
["Electric heat pump",null,null,null,"Electric heat pump",{"$f":"F182","v":1.08},{"$f":"G182","v":1.08}]
["Tri/Cogeneration plant",null,null,null,"Tri/Cogeneration plant",{"$f":"F188","v":0.94},{"$f":"G188","v":0.92}]
["District heating",null,null,null,"District heating",{"$f":"F184","v":1.6},{"$f":"G184","v":1.6}]
["Disctrict heating Vienna",null,null,null,"Disctrict heating Vienna",{"$f":"F187","v":0.33},{"$f":"G187","v":0.33}]
["Other"]
["COOLING PLANT"]
["STRAGETY TO REDUCE SOLAR HEAT GAINS"]
["Not specified"]
["Shading by fixed surrounding objects"]
["Well sized external shading"]
["Selective glazing (g<=0.5)"]
["Mobile external shading without automatic controls"]
["Mobile external shading with automatic controls"]
[]
["COOLING STRATEGY"]
["Not specified"]
["Not installed"]
["Efficient room air-conditioners"]
["Centralized mechanical cooling plant (EER<=4)"]
["Centralized mechanical cooling plant (EER>4)"]
["Active systems based on renewables"]
["Passive systems"]
["District cooling"]
["Tri/Cogeneration"]
[]
["TYPE OF COOLING PRODUCTION SYSTEM"]
["Air conditioner",null,null,null,"Air conditioner",{"$f":"F178","v":1.91},{"$f":"G178","v":2.62}]
["Air-air heat pump",null,null,null,"Air-air heat pump",{"$f":"F178","v":1.91},{"$f":"G178","v":2.62}]
["Air-water heat pump",null,null,null,"Air-water heat pump",{"$f":"F178","v":1.91},{"$f":"G178","v":2.62}]
["Water-water heat pump",null,null,null,"Water-water heat pump",{"$f":"F178","v":1.91},{"$f":"G178","v":2.62}]
["Ground source heat pump",null,null,null,"Ground source heat pump",{"$f":"F178","v":1.91},{"$f":"G178","v":2.62}]
["District cooling",null,null,null,"District cooling"]
["Trigeneration plant",null,null,null,"Trigeneration plant",{"$f":"F188","v":0.94},{"$f":"G188","v":0.92}]
["Other"]
["RENEWABLE"]
["TYPE OF SOLAR THERMAL COLLECTOR"]
["Evacuated tube"]
["Hot water collector with selective glazing"]
["Hot water collector with clear glazing"]
["Hot water collector without glazing"]
["Hot air glazed collector"]
["Other…"]
[]
["TYPE OF PV CELL"]
["Mono crystalline silicon (Nom.Eff. ~ 16%)"]
["Polycrystalline silicon (Nom.Eff. ~ 13%)"]
["Micro-spherical silicon (Nom.Eff. ~ 10%)"]
["Amorphous silicon (Nom.Eff. ~ 8%)"]
["Other"]
[]
["TYPE OF BIOMASS USED AS FUEL"]
["Bio-gas"]
["Bio-oil fuel"]
["Wood, Pellets, etc..."]
["Other"]
[]
["TYPE OF GEOTHERMAL SYSTEMS"]
["Vertical closed loop field"]
["Horizontal closed loop field"]
["Slinky closed loop field"]
["Closed pond loop"]
["Open loop systems"]
["Other"]
[]
["TYPE OF COMBINED ENERGY GENERATION SYSTEMS"]
["Cogenerator (Heat + Electricity)"]
["Trigenerator (Heat + Electricity + Cool)"]
[]
["NUMBER OF ENERGY SAVINGS ACTIONS"]
["NUMBER OF ENERGY SAVINGS ACTIONS"]
[0]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[]
["TYPE OF DATA"]
["TYPE OF DATA FOR NEW BUILDINGS"]
["Not available"]
["Data from EN or national norm calculation"]
["Data from dynamic simulation"]
[]
["TYPEOF DATA FOR RENOVATIONS"]
["Not available"]
["European or national standard/law"]
["Dynamic simulation"]
["Metering"]
[]
["TYPE OF DATA"]
["DATA SOURCE FOR OPAQUE ENVELOPE"]
["Estimation"]
["Calculation according to EN or national standard"]
["Specification from the producer"]
["Field measurement"]
[]
["DATA SOURCE FOR TRANSPARENT ENVELOPE"]
["Estimation"]
["Calculation according to EN or national standard"]
["Specification from the producer"]
["Field measurement"]
[]
["RISPOSTA A DOMANDE"]
["Yes"]
["No"]
[]
["DESIGN GOALS -> N_DesGoal"]
["Aesthetics"]
["Accessibility"]
["Cost-effectiveness"]
["Energy efficiency"]
["Functionality"]
["Historic preservation"]
["Productivity"]
["Security/Safety"]
["Sustainability"]
["Other"]
[]
["TEAM COMPOSITION -> N_TeamComp"]
["Architect"]
["Constructor"]
["Engineer"]
["Future building manager"]
["Interior designer"]
["Landscape architect"]
["Occupant"]
["Operating staff"]
["Owner"]
[]
["DISCIPLINES INVOLVED -> N_DiscInv"]
["Acoustical Engineering"]
["Architecture"]
["Architectural programming"]
["Building physics"]
["Civil/Structural/Seismic engineering"]
["Commissioning "]
["Cost estimation"]
["Electrical engineering"]
["Environmental engineering"]
["Fire safety engineering"]
["HVAC engineering"]
["Information technologies engineering"]
["Interior design"]
["Historic Preservation"]
["Landscape architecture"]
["Lighting design"]
["Mechanical engineering"]
["Productivity"]
["Seismic engineering"]
["Site engineering"]
["Soils engineering"]
["Space Planner"]
["Surveying "]
["Urban planning"]
["Waste management"]
[]
["COMMUNICATION AMONG THE TEAM -> N_ComTeam"]
["File sharing system"]
["Collaborative software"]
["Document management system"]
["Other"]
[]
["METHOD FOR SHARING INFORMATION -> N_MetSharInfo"]
["Emails"]
["One-to-one phone calls"]
["One-to-one teleconferences"]
["Periodic collective meetings/teleconferences"]
["ISO 9000 procedures"]
["File hosting service (e.g. Dropbox, GoogleDrive, Skydrive etc.)"]
["Other"]
[]
["PROCESS MANAGER TOOLS -> N_ProManTool"]
["Gantt chart"]
["Program Evaluation and Review Technique (PERT) and/or Critical Path Method (CPM)"]
["Business process management (BPM) tools"]
["Building information model (BIM) tool"]
[]
["BIM DIMENSION -> N_BimDim"]
["2D: 2D-drawings"]
["3D: 3D-drawings"]
["4D: Time schedule"]
["5D: Pricing"]
["XD: Specialist analyses and simulations"]
[]
["BIM TOOLS -> N_BimTool"]
["None"]
["4M BIM Suite - IDEA Architecture"]
["Archimen Groupe - Active 3d"]
["Autodesk Inc - Autodesk ADT"]
["Autodesk Inc - AutoCAD Architecture 2008"]
["Autodesk Inc - Autodesk BIM 360"]
["Autodesk Inc - NavisWorks"]
["Autodesk Inc - Revit Suite"]
["Bentley Systems Inc - Microstation"]
["Bentley Systems Inc - Bentley Suite"]
["BFRL - NIST CIS/2 to IFC Translator"]
["Bocad Software GmbH - Bocad"]
["CADSoft - Envisioneer"]
["Cadwork informatik AG - Cadwork"]
["Computers & Structures Inc - ETABS"]
["Computers & Structures Inc - SAP2000"]
["Data Design System ASA - Data Design System (DDS)"]
["Gehry Technologies Inc - Digital Projects"]
["Graitec Group - Advance Steel"]
["Granlund Oy - Riuska"]
["Granlund Oy - RYHTI FM"]
["Graphisoft - ArchiCAD"]
["IAI - IfcStoreyView"]
["InfoGraph GmbH - InfoCAD"]
["Ing.-Software Dlubal GmbH - RSTAB"]
["Inter-CAD - AxisVM"]
["Jidea Oy - ScaleCAD"]
["Kymdata Oy - Kymdata CADS HEPAC and Electric"]
["Nemetschek - ALLPLAN"]
["Nemetschek - Scia ESA PT"]
["Nemetschek - Vectorworks"]
["Norconsult Informasjonssystemer AS - Calcus"]
["Nosyko AS - dRofus"]
["Octaga AS - Octaga"]
["Onuma Inc - Onuma Planning System (OPS)"]
["Progman Oy - MagiCAD"]
["Roland Messerli AG Informatik - EliteCAD"]
["Secom IS Lab - IFC2SKP Google SketchUp"]
["Selvaag Group - Bluethink® House Designer"]
["Softtech - SPIRIT"]
["Solibri Inc - Solibri Model Checker"]
["StruSoft AB - StruSoft"]
["Tekla Corporation - Tekla Structures"]
["TNO - IFC Engine Viewer"]
["Vico Software Inc - Vico Suite"]
["Virtual Build Technologies – RhinoBIM"]
["Other"]
[]
["COST CALCULATION -> N_CostCalc"]
["Estimation"]
["Calculation"]
[]
["Energy Source","PE-Faktor 2015","PE-Faktor 2012"]
["District Heating",null,0.92,null,null,"OIB-6 v.2011"]
["District Heating (Vienna)",null,0.33]
[null,null,1.08,null,null,"OIB-6 v.2011"]
["Electricity",null,2.62,null,null,"Austrian-Mix; OIB-6 v.2011"]
["Heat pump",null,2.62]
["Petroleum Gas",null,1.17,null,null,"OIB-6 v.2011"]
["Petroleum Oil"]
["Methane boiler"]
["Gas oil boiler"]
["Electric boiler",{"$f":"B451","v":0},{"$f":"C451","v":2.62}]
["Biomass boiler"]
["Electric heat pump"]
["District heating"]
["Tri/Cogeneration plant"]
["Not installed"]
["Autonomuos methane boiler"]
["Autonomous gas oil boiler"]
["Autonomous biomass boiler"]
["Combined methane boiler",{"$f":"B455","v":0},{"$f":"C455","v":0}]
["Combined gas oil boiler",{"$f":"B456","v":0},{"$f":"C456","v":0}]
["Combined biomass boiler",{"$f":"B458","v":0},{"$f":"C458","v":0}]
[]
["Electric heat pump",{"$f":"B451","v":0}]
["Tri/Cogeneration plant"]
["District heating",{"$f":"B448","v":0}]
["Air conditioner",{"$f":"B451","v":0},{"$f":"C451","v":2.62}]
["Air-air heat pump"]
["Air-water heat pump"]
["Water-water heat pump"]
["Ground source heat pump"]
["District cooling"]
["Trigeneration plant"]
[]
["Energieausweis ","Berechnungssoftware"]
["OIB RL6-2015","Archiphysik"]
["OIB RL6-2011","GEQ Zehentmeyer"]
["before OIB RL6-2011","EcoTech"]
[null,"Other"]
[]
[]
[]
["ja / nein"]
["yes"]
["no"]
["LENI Benchmark","kWh/m²a"]
["Office Building",32.200000000000003]
["Kindergarten and Compulsory School (Pflichtschule)",24.8]
["Secondary School (Höhere Schule), University etc.",24.8]
["Hospital (Krankenhaus)",82.3]
["Rest Home (Pflegeheim)",50.7]
["Guesthouse (Pension)",34.6]
["Hotel",65.099999999999994]
["Restaurant (Gaststätte)",27.1]
["Event location (Veranstaltungsstätte)",27.1]
["Sport hall (Sportstätte)",37.9]
["Retail trade (Verkaufsstätte)",7.6]
["Indoor swimming pool (Hallenbad)",37.9]
[]
["Office"]
["Culture: cinema"]
["Culture: cultural centre, party hall, theatre, etc."]
["Culture: museum and art gallery"]
["Culture: library"]
["Culture: church"]
["Retail trade: small shop"]
["Retail trade: shopping mall, supermarket, ..."]
["Accommodation group: hotel"]
["Accommodation group: restaurant, pub, casino, ... "]
["Housing: housing for students"]
["School: primary and secondary (4-18 year)"]
["School: university and college (>18 year)"]
["Sport: sport hall"]
["Sport: swimming pool"]
["Sport: swimming pool and sport hall"]
["Care: nursery / crèche"]
["Care: rest home"]
["Care: hospital and psychiatry"]
["Care: prison"]
["Other: industrial or agrarian buildings"]
["Other: laboratories"]
["Other: fire brigade"]