get_building_air_conditioning

path: inputs/building-properties/air_conditioning_systems.dbf

The following file is used by these scripts: demand

Variable Description
cool_ends End of the cooling season - use 00|00 when there is none
cool_starts Start of the cooling season - use 00|00 when there is none
heat_ends End of the heating season - use 00|00 when there is none
heat_starts Start of the heating season - use 00|00 when there is none
Name Unique building ID. It must start with a letter.
type_cs Type of cooling HVAC assembly (relates to “code” in HVAC assemblies)
type_ctrl Type of heating and cooling control HVAC assembly (relates to “code” in HVAC assemblies)
type_dhw Type of hot water HVAC assembly (relates to “code” in HVAC assemblies)
type_hs Type of heating HVAC assembly (relates to “code” in HVAC assemblies)
type_vent Type of ventilation HVAC assembly (relates to “code” in HVAC assemblies)

get_building_architecture

path: inputs/building-properties/architecture.dbf

The following file is used by these scripts: demand, emissions, radiation, schedule_maker

Variable Description
Es Fraction of gross floor area with electrical demands.
Hs_ag Fraction of above ground gross floor area air-conditioned.
Hs_bg Fraction of below ground gross floor area air-conditioned.
Name Unique building ID. It must start with a letter.
Ns Fraction of net gross floor area.
type_base Basement floor construction assembly (relates to “code” in ENVELOPE assemblies)
type_cons Type of construction assembly (relates to “code” in ENVELOPE assemblies)
type_floor Internal floor construction assembly (relates to “code” in ENVELOPE assemblies)
type_leak Tightness level assembly (relates to “code” in ENVELOPE assemblies)
type_part Internal partitions construction assembly (relates to “code” in ENVELOPE assemblies)
type_roof Roof construction assembly (relates to “code” in ENVELOPE assemblies)
type_shade Shading system assembly (relates to “code” in ENVELOPE assemblies)
type_wall External wall construction assembly (relates to “code” in ENVELOPE assemblies)
type_win Window assembly (relates to “code” in ENVELOPE assemblies)
void_deck Number of floors (from the ground up) with an open envelope (default = 0, should be lower than floors_ag.)
wwr_east Window to wall ratio in in facades facing east
wwr_north Window to wall ratio in in facades facing north
wwr_south Window to wall ratio in in facades facing south
wwr_west Window to wall ratio in in facades facing west

get_building_comfort

path: inputs/building-properties/indoor_comfort.dbf

The following file is used by these scripts: demand, schedule_maker

Variable Description
Name Unique building ID. It must start with a letter.
RH_max_pc Upper bound of relative humidity
RH_min_pc Lower_bound of relative humidity
Tcs_set_C Setpoint temperature for cooling system
Tcs_setb_C Setback point of temperature for cooling system
Ths_set_C Setpoint temperature for heating system
Ths_setb_C Setback point of temperature for heating system
Ve_lsp Minimum outdoor air ventilation rate per person for Air Quality

get_building_internal

path: inputs/building-properties/internal_loads.dbf

The following file is used by these scripts: demand, schedule_maker

Variable Description
Ea_Wm2 Peak specific electrical load due to computers and devices
Ed_Wm2 Peak specific electrical load due to servers/data centres
El_Wm2 Peak specific electrical load due to artificial lighting
Epro_Wm2 Peak specific electrical load due to industrial processes
Ev_kWveh Peak capacity of electric battery per vehicle
Name Unique building ID. It must start with a letter.
Occ_m2p Occupancy density
Qcpro_Wm2 Peak specific process cooling load
Qcre_Wm2 Peak specific cooling load due to refrigeration (cooling rooms)
Qhpro_Wm2 Peak specific process heating load
Qs_Wp Peak sensible heat load of people
Vw_ldp Peak specific fresh water consumption (includes cold and hot water)
Vww_ldp Peak specific daily hot water consumption
X_ghp Moisture released by occupancy at peak conditions

get_building_supply

path: inputs/building-properties/supply_systems.dbf

The following file is used by these scripts: decentralized, demand, emissions, system_costs

Variable Description
Name Unique building ID. It must start with a letter.
type_cs Type of cooling supply assembly (refers to “code” in SUPPLY assemblies)
type_dhw Type of hot water supply assembly (refers to “code” in SUPPLY assemblies)
type_el Type of electrical supply assembly (refers to “code” in SUPPLY assemblies)
type_hs Type of heating supply assembly (refers to “code” in SUPPLY assemblies)

get_building_weekly_schedules

path: inputs/building-properties/schedules/B001.csv

The following file is used by these scripts: demand, schedule_maker

Variable Description
METADATA TODO
MONTHLY_MULTIPLIER Monthly probabilities of occupancy throughout the year

get_database_air_conditioning_systems

path: inputs/technology/assemblies/HVAC.xlsx

The following file is used by these scripts: demand

Worksheet: CONTROLLER
Variable Description
code Unique ID of the controller
Description Describes the type of controller
dT_Qcs correction temperature of emission losses due to control system of cooling
dT_Qhs correction temperature of emission losses due to control system of heating
Worksheet: COOLING
Variable Description
class_cs Type or class of the cooling system
code Unique ID of the heating system
convection_cs Convective part of the power of the heating system in relation to the total power
Description Describes the type of cooling system
dTcs0_ahu_C Nominal temperature increase on the water side of the air-handling units
dTcs0_aru_C Nominal temperature increase on the water side of the air-recirculation units
dTcs0_scu_C Nominal temperature increase on the water side of the sensible cooling units
dTcs_C Set-point correction for space emission systems
Qcsmax_Wm2 Maximum heat flow permitted by cooling system per m2 gross floor area
Tc_sup_air_ahu_C Supply air temperature of the air-handling units
Tc_sup_air_aru_C Supply air temperature of the air-recirculation units
Tscs0_ahu_C Nominal supply temperature of the water side of the air-handling units
Tscs0_aru_C Nominal supply temperature of the water side of the air-recirculation units
Tscs0_scu_C Nominal supply temperature of the water side of the sensible cooling units
Worksheet: HEATING
Variable Description
class_hs Type or class of the heating system
code Unique ID of the heating system
convection_hs Convective part of the power of the heating system in relation to the total power
Description Description
dThs0_ahu_C Nominal temperature increase on the water side of the air-handling units
dThs0_aru_C Nominal temperature increase on the water side of the air-recirculation units
dThs0_shu_C Nominal temperature increase on the water side of the sensible heating units
dThs_C correction temperature of emission losses due to type of heating system
Qhsmax_Wm2 Maximum heat flow permitted by heating system per m2 gross floor area
Th_sup_air_ahu_C Supply air temperature of the air-recirculation units
Th_sup_air_aru_C Supply air temperature of the air-handling units
Tshs0_ahu_C Nominal supply temperature of the water side of the air-handling units
Tshs0_aru_C Nominal supply temperature of the water side of the air-recirculation units
Tshs0_shu_C Nominal supply temperature of the water side of the sensible heating units
Worksheet: HOT_WATER
Variable Description
code Unique ID of the hot water supply system
Description Describes the Type of hot water supply system
Qwwmax_Wm2 Maximum heat flow permitted by hot water system per m2 gross floor area
Tsww0_C Typical supply water temperature.
Worksheet: VENTILATION
Variable Description  
code Unique ID of the type of ventilation  
Description Describes the Type of ventilation  
ECONOMIZER Boolean economizer on
HEAT_REC Boolean heat recovery on
MECH_VENT Boolean mechanical ventilation on
NIGHT_FLSH Boolean night flush on
WIN_VENT Boolean window ventilation on

get_database_construction_standards

path: inputs/technology/archetypes/CONSTRUCTION_STANDARDS.xlsx

The following file is used by these scripts: archetypes_mapper

Worksheet: ENVELOPE_ASSEMBLIES
Variable Description
Es Fraction of gross floor area with electrical demands.
Hs_ag Fraction of above ground gross floor area air-conditioned.
Hs_bg Fraction of below ground gross floor area air-conditioned
Ns Fraction of net gross floor area.
STANDARD Unique ID of Construction Standard
type_base Basement floor construction assembly (relates to “code” in ENVELOPE assemblies)
type_cons Type of construction assembly (relates to “code” in ENVELOPE assemblies)
type_floor Internal floor construction assembly (relates to “code” in ENVELOPE assemblies)
type_leak Tightness level assembly (relates to “code” in ENVELOPE assemblies)
type_part Internal partitions construction assembly (relates to “code” in ENVELOPE assemblies)
type_roof Roof construction assembly (relates to “code” in ENVELOPE assemblies)
type_shade Shading system assembly (relates to “code” in ENVELOPE assemblies)
type_wall External wall construction assembly (relates to “code” in ENVELOPE assemblies)
type_win Window assembly (relates to “code” in ENVELOPE assemblies)
void_deck Number of floors (from the ground up) with an open envelope (default = 0)
wwr_east Window to wall ratio in in facades facing east
wwr_north Window to wall ratio in in facades facing north
wwr_south Window to wall ratio in in facades facing south
wwr_west Window to wall ratio in in facades facing west
Worksheet: HVAC_ASSEMBLIES
Variable Description
cool_ends End of the cooling season - use 00|00 when there is none
cool_starts Start of the cooling season - use 00|00 when there is none
heat_ends End of the heating season - use 00|00 when there is none
heat_starts Start of the heating season - use 00|00 when there is none
STANDARD Unique ID of Construction Standard
type_cs Type of cooling HVAC assembly (relates to “code” in HVAC assemblies)
type_ctrl Type of heating and cooling control HVAC assembly (relates to “code” in HVAC assemblies)
type_dhw Type of hot water HVAC assembly (relates to “code” in HVAC assemblies)
type_hs Type of heating HVAC assembly (relates to “code” in HVAC assemblies)
type_vent Type of ventilation HVAC assembly (relates to “code” in HVAC assemblies)
Worksheet: STANDARD_DEFINITION
Variable Description
Description Description of the construction standard
STANDARD Unique ID of Construction Standard
YEAR_END Upper limit of year interval where the building properties apply
YEAR_START Lower limit of year interval where the building properties apply
Worksheet: SUPPLY_ASSEMBLIES
Variable Description
STANDARD Unique ID of Construction Standard
type_cs Type of cooling supply assembly (refers to “code” in SUPPLY assemblies)
type_dhw Type of hot water supply assembly (refers to “code” in SUPPLY assemblies)
type_el Type of electrical supply assembly (refers to “code” in SUPPLY assemblies)
type_hs Type of heating supply assembly (refers to “code” in SUPPLY assemblies)

get_database_conversion_systems

path: inputs/technology/components/CONVERSION.xlsx

The following file is used by these scripts: decentralized, optimization, photovoltaic, photovoltaic_thermal, solar_collector

Worksheet: Absorption_chiller
Variable Description    
a parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
a_e parameter in the characteristic equations to calculate the evaporator side    
a_g parameter in the characteristic equations to calculate the generator side    
assumption items made by assumptions in this technology    
b parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
c parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
cap_max maximum capacity    
cap_min minimum capacity    
code identifier of each unique equipment    
currency currency-year information of the investment cost function should be unified to USD  
d parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
Description Describes the Type of Absorption Chiller    
e parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
e_e parameter in the characteristic equations to calculate the evaporator side    
e_g parameter in the characteristic equations to calculate the generator side    
IR_% interest rate charged on the loan for the capital cost    
LT_yr lifetime of this technology    
m_cw external flow rate of cooling water at the condenser and absorber    
m_hw external flow rate of hot water at the generator    
O&M_% operation and maintenance cost factor (fraction of the investment cost)    
r_e parameter in the characteristic equations to calculate the evaporator side    
r_g parameter in the characteristic equations to calculate the generator side    
s_e parameter in the characteristic equations to calculate the evaporator side    
s_g parameter in the characteristic equations to calculate the generator side    
type type of absorption chiller    
unit unit of the min/max capacity    
Worksheet: BH
Variable Description  
a parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
assumption items made by assumptions in this technology  
b parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
c parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
cap_max maximum capacity  
cap_min minimum capacity  
code identifier of each unique equipment  
currency currency-year information of the investment cost function  
d parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
Description Describes the type of borehole heat exchanger  
e parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
IR_% interest rate charged on the loan for the capital cost  
LT_yr lifetime of this technology  
O&M_% operation and maintenance cost factor (fraction of the investment cost)  
unit unit of the min/max capacity  
Worksheet: Boiler
Variable Description  
a parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
assumption items made by assumptions in this technology  
b parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
c parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
cap_max maximum capacity  
cap_min minimum capacity  
code identifier of each unique equipment  
currency currency-year information of the investment cost function  
d parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
Description Describes the type of boiler  
e parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
IR_% interest rate charged on the loan for the capital cost  
LT_yr lifetime of this technology  
O&M_% operation and maintenance cost factor (fraction of the investment cost)  
unit unit of the min/max capacity  
Worksheet: CCGT
Variable Description  
a parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
assumption items made by assumptions in this technology  
b parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
c parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
cap_max maximum capacity  
cap_min minimum capacity  
code identifier of each unique equipment  
currency currency-year information of the investment cost function should be unified to USD
d parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
Description Describes the type of combined-cycle gas turbine  
e parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
IR_% interest rate charged on the loan for the capital cost  
LT_yr lifetime of this technology  
O&M_% operation and maintenance cost factor (fraction of the investment cost)  
unit unit of the min/max capacity  
Worksheet: Chiller
Variable Description  
a parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
assumption items made by assumptions in this technology  
b parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
c parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
cap_max maximum capacity  
cap_min minimum capacity  
code identifier of each unique equipment  
currency currency-year information of the investment cost function should be unified to USD
d parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
Description Describes the source of the benchmark standards.  
e parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
IR_% interest rate charged on the loan for the capital cost  
LT_yr lifetime of this technology  
O&M_% operation and maintenance cost factor (fraction of the investment cost)  
unit unit of the min/max capacity  
Worksheet: CT
Variable Description  
a parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
assumption items made by assumptions in this technology  
b parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
c parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
cap_max maximum capacity  
cap_min minimum capacity  
code identifier of each unique equipment  
currency currency-year information of the investment cost function should be unified to USD
d parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
Description Describes the type of cooling tower  
e parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
IR_% interest rate charged on the loan for the capital cost  
LT_yr lifetime of this technology  
O&M_% operation and maintenance cost factor (fraction of the investment cost)  
unit unit of the min/max capacity  
Worksheet: FC
Variable Description  
a parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
assumption items made by assumptions in this technology  
b parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
c parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
cap_max maximum capacity  
cap_min minimum capacity  
code identifier of each unique equipment  
currency currency-year information of the investment cost function should be unified to USD
d parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
Description Describes the type of fuel cell  
e parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
IR_% interest rate charged on the loan for the capital cost  
LT_yr lifetime of this technology  
O&M_% operation and maintenance cost factor (fraction of the investment cost)  
unit unit of the min/max capacity  
Worksheet: Furnace
Variable Description  
a parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
assumption items made by assumptions in this technology  
b parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
c parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
cap_max maximum capacity  
cap_min minimum capacity  
code identifier of each unique equipment  
currency currency-year information of the investment cost function should be unified to USD
d parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
Description Describes the type of furnace  
e parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)
IR_% interest rate charged on the loan for the capital cost  
LT_yr lifetime of this technology  
O&M_% operation and maintenance cost factor (fraction of the investment cost)  
unit unit of the min/max capacity  
Worksheet: HEX
Variable Description    
a parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)  
a_p parameter in the pressure loss function f(x) = a_p + b_p*x^c_p + d_p*ln(x) + e_p*x*ln*(x) where x is the capacity mass flow rate [W/K]
assumption items made by assumptions in this technology    
b parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)  
b_p parameter in the pressure loss function f(x) = a_p + b_p*x^c_p + d_p*ln(x) + e_p*x*ln*(x) where x is the capacity mass flow rate [W/K]
c parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)  
c_p parameter in the pressure loss function f(x) = a_p + b_p*x^c_p + d_p*ln(x) + e_p*x*ln*(x) where x is the capacity mass flow rate [W/K]
cap_max maximum capacity    
cap_min minimum capacity    
code identifier of each unique equipment    
currency currency-year information of the investment cost function should be unified to USD  
d parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)  
d_p parameter in the pressure loss function f(x) = a_p + b_p*x^c_p + d_p*ln(x) + e_p*x*ln*(x) where x is the capacity mass flow rate [W/K]
Description Describes the type of heat exchanger    
e parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x)  
e_p parameter in the pressure loss function f(x) = a_p + b_p*x^c_p + d_p*ln(x) + e_p*x*ln*(x) where x is the capacity mass flow rate [W/K]
IR_% interest rate charged on the loan for the capital cost    
LT_yr lifetime of this technology    
O&M_% operation and maintenance cost factor (fraction of the investment cost)    
unit unit of the min/max capacity    
Worksheet: HP
Variable Description    
a parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
assumption items made by assumptions in this technology    
b parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
c parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
cap_max maximum capacity    
cap_min minimum capacity    
code identifier of each unique equipment    
currency currency-year information of the investment cost function should be unified to USD  
d parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
Description Describes the source of the heat pump    
e parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
IR_% interest rate charged on the loan for the capital cost    
LT_yr lifetime of this technology    
O&M_% operation and maintenance cost factor (fraction of the investment cost)    
unit unit of the min/max capacity    
Worksheet: Pump
Variable Description    
a parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
assumption items made by assumptions in this technology    
b parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
c parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
cap_max maximum capacity    
cap_min minimum capacity    
code identifier of each unique equipment    
currency currency-year information of the investment cost function should be unified to USD  
d parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
Description Describes the source of the benchmark standards.    
e parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
IR_% interest rate charged on the loan for the capital cost    
LT_yr lifetime of this technology    
O&M_% operation and maintenance cost factor (fraction of the investment cost)    
unit unit of the min/max capacity    
Worksheet: PV
Variable Description    
a parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
assumption items made by assumptions in this technology    
b parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
c parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
cap_max maximum capacity    
cap_min minimum capacity    
code identifier of each unique equipment    
currency currency-year information of the investment cost function should be unified to USD  
d parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
Description Describes the source of the benchmark standards.    
e parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
IR_% interest rate charged on the loan for the capital cost    
LT_yr lifetime of this technology    
misc_losses losses from cabling resistances etc…  
module_length_m lengh of the PV module    
O&M_% operation and maintenance cost factor (fraction of the investment cost)    
PV_a0 parameters for air mass modifier f(x) = a0 + a1*x + a2*x**2 + a3*x**3 + a4*x**4 where x is the relative air mass
PV_a1 parameters for air mass modifier f(x) = a0 + a1*x + a2*x**2 + a3*x**3 + a4*x**4 where x is the relative air mass
PV_a2 parameters for air mass modifier f(x) = a0 + a1*x + a2*x**2 + a3*x**3 + a4*x**4 where x is the relative air mass
PV_a3 parameters for air mass modifier f(x) = a0 + a1*x + a2*x**2 + a3*x**3 + a4*x**4 where x is the relative air mass
PV_a4 parameters for air mass modifier f(x) = a0 + a1*x + a2*x**2 + a3*x**3 + a4*x**4 where x is the relative air mass
PV_Bref cell maximum power temperature coefficient    
PV_n nominal efficiency    
PV_noct nominal operating cell temperature    
PV_th glazing thickness    
type redundant    
unit unit of the min/max capacity    
Worksheet: PVT
Variable Description    
a parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
assumption items made by assumptions in this technology    
b parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
c parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
cap_max maximum capacity    
cap_min minimum capacity    
code identifier of each unique equipment    
currency currency-year information of the investment cost function should be unified to USD  
d parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
Description Describes the type of photovoltaic thermal technology    
e parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
IR_% interest rate charged on the loan for the capital cost    
LT_yr lifetime of this technology    
O&M_% operation and maintenance cost factor (fraction of the investment cost)    
unit unit of the min/max capacity    
Worksheet: SC
Variable Description    
a parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
aperture_area_ratio ratio of aperture area to panel area    
assumption items made by assumptions in this technology    
b parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
c parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
c1 collector heat loss coefficient at zero temperature difference and wind speed    
c2 ctemperature difference dependency of the heat loss coefficient    
C_eff thermal capacity of module    
cap_max maximum capacity    
cap_min minimum capacity    
code identifier of each unique equipment    
Cp_fluid heat capacity of the heat transfer fluid    
currency currency-year information of the investment cost function should be unified to USD  
d parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
Description Describes the type of solar collector    
dP1 pressure drop at zero flow rate    
dP2 pressure drop at nominal flow rate (mB0)    
dP3 pressure drop at maximum flow rate (mB_max)    
dP4 pressure drop at minimum flow rate (mB_min)    
e parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
IAM_d incident angle modifier for diffuse radiation    
IR_% interest rate charged on the loan for the capital cost    
LT_yr lifetime of this technology    
mB0_r nominal flow rate per aperture area    
mB_max_r maximum flow rate per aperture area    
mB_min_r minimum flow rate per aperture area    
module_area_m2 module area of a solar collector    
module_length_m lengh of a solar collector module    
n0 zero loss efficiency at normal incidence    
O&M_% operation and maintenance cost factor (fraction of the investment cost)    
t_max maximum operating temperature    
type type of the solar collector (FP: flate-plate or ET: evacuated-tube)    
unit unit of the min/max capacity    
Worksheet: TES
Variable Description    
a parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
assumption items made by assumptions in this storage technology    
b parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
c parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
C_mat_% Working fluid replacement cost factor (fraction of the investment cost)    
cap_max maximum capacity    
cap_min minimum capacity    
code Unique code that identifies the thermal energy storage technology    
Cp_kJkgK heat capacity of working fluid    
currency currency-year information of the investment cost function should be unified to USD  
d parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
Description Describes the thermal energy storage technology    
e parameter in the investment cost function f(x) = a + b*x^c + d*ln(x) + e*x*ln*(x) where x is the capacity
HL_kJkg Lantent heat of working fluid at phase change temperature    
IR_% interest rate charged on the loan for the capital cost    
LT_mat_yr lifetime of the working fluid of this storage technology    
LT_yr lifetime of this storage technology    
O&M_% operation and maintnance cost factor (fraction of the investment cost)    
Rho_T_PHCH_kgm3 Density of working fluid at phase change temperature    
T_max_C Maximum temperature of working fluid at full discharge    
T_min_C Minimum temperature of working fluid at full charge    
T_PHCH_C Phase change temperature of working fluid    
type code that identifies whether the storage is used for heating or cooling (different properties of the transport media)    
unit unit which describes the minimum and maximum capacity    

get_database_distribution_systems

path: inputs/technology/components/DISTRIBUTION.xlsx

The following file is used by these scripts: optimization, thermal_network

Worksheet: THERMAL_GRID
Variable Description
Code pipe ID from the manufacterer
D_ext_m external pipe diameter tolerance for the nominal diameter (DN)
D_ins_m maximum pipe diameter tolerance for the nominal diameter (DN)
D_int_m internal pipe diameter tolerance for the nominal diameter (DN)
Inv_USD2015perm Typical cost of investment for a given pipe diameter.
Pipe_DN Nominal pipe diameter
Vdot_max_m3s maximum volumetric flow rate for the nominal diameter (DN)
Vdot_min_m3s minimum volumetric flow rate for the nominal diameter (DN)

get_database_envelope_systems

path: inputs/technology/assemblies/ENVELOPE.xlsx

The following file is used by these scripts: demand, radiation, schedule_maker

Worksheet: CONSTRUCTION
Variable Description
Cm_Af Internal heat capacity per unit of air conditioned area. Defined according to ISO 13790.
code Type of construction
Description Describes the Type of construction
Worksheet: FLOOR
Variable Description
code Type of roof
Description Describes the Type of roof
GHG_FLOOR_kgCO2m2 Embodied emissions per m2 of roof.(entire building life cycle)
U_base Thermal transmittance of floor including linear losses (+10%). Defined according to ISO 13790.
Worksheet: ROOF
Variable Description
a_roof Solar absorption coefficient. Defined according to ISO 13790.
code Type of roof
Description Describes the Type of roof
e_roof Emissivity of external surface. Defined according to ISO 13790.
GHG_ROOF_kgCO2m2 Embodied emissions per m2 of roof.(entire building life cycle)
r_roof Reflectance in the Red spectrum. Defined according Radiance. (long-wave)
U_roof Thermal transmittance of windows including linear losses (+10%). Defined according to ISO 13790.
Worksheet: SHADING
Variable Description
code Type of shading
Description Describes the source of the benchmark standards.
rf_sh Shading coefficient when shading device is active. Defined according to ISO 13790.
Worksheet: TIGHTNESS
Variable Description
code Type of tightness
Description Describes the Type of tightness
n50 Air exchanges per hour at a pressure of 50 Pa.
Worksheet: WALL
Variable Description
a_wall Solar absorption coefficient. Defined according to ISO 13790.
code Type of wall
Description Describes the Type of wall
e_wall Emissivity of external surface. Defined according to ISO 13790.
GHG_WALL_kgCO2m2 Embodied emissions per m2 of walls (entire building life cycle)
r_wall Reflectance in the Red spectrum. Defined according Radiance. (long-wave)
U_wall Thermal transmittance of windows including linear losses (+10%). Defined according to ISO 13790.
Worksheet: WINDOW
Variable Description
code Window type code to relate to other databases
Description Describes the source of the benchmark standards.
e_win Emissivity of external surface. Defined according to ISO 13790.
F_F Window frame fraction coefficient. Defined according to ISO 13790.
G_win Solar heat gain coefficient. Defined according to ISO 13790.
GHG_WIN_kgCO2m2 Embodied emissions per m2 of windows.(entire building life cycle)
U_win Thermal transmittance of windows including linear losses (+10%). Defined according to ISO 13790.

get_database_feedstocks

path: inputs/technology/components/FEEDSTOCKS.xlsx

The following file is used by these scripts: decentralized, emissions, system_costs, optimization

Worksheet: BIOGAS
Variable Description
GHG_kgCO2MJ Non-renewable Green House Gas Emissions factor
hour hour of a 24 hour day
Opex_var_buy_USD2015kWh buying price
Opex_var_sell_USD2015kWh selling price
reference reference
Worksheet: COAL
Variable Description
GHG_kgCO2MJ Non-renewable Green House Gas Emissions factor
hour hour of a 24 hour day
Opex_var_buy_USD2015kWh buying price
Opex_var_sell_USD2015kWh selling price
reference reference
Worksheet: DRYBIOMASS
Variable Description
GHG_kgCO2MJ Non-renewable Green House Gas Emissions factor
hour hour of a 24 hour day
Opex_var_buy_USD2015kWh buying price
Opex_var_sell_USD2015kWh selling price
reference reference
Worksheet: GRID
Variable Description
GHG_kgCO2MJ Non-renewable Green House Gas Emissions factor
hour hour of a 24 hour day
Opex_var_buy_USD2015kWh buying price
Opex_var_sell_USD2015kWh selling price
reference reference
Worksheet: NATURALGAS
Variable Description
GHG_kgCO2MJ Non-renewable Green House Gas Emissions factor
hour hour of a 24 hour day
Opex_var_buy_USD2015kWh buying price
Opex_var_sell_USD2015kWh selling price
reference reference
Worksheet: OIL
Variable Description
GHG_kgCO2MJ Non-renewable Green House Gas Emissions factor
hour hour of a 24 hour day
Opex_var_buy_USD2015kWh buying price
Opex_var_sell_USD2015kWh selling price
reference reference
Worksheet: SOLAR
Variable Description
GHG_kgCO2MJ Non-renewable Green House Gas Emissions factor
hour hour of a 24 hour day
Opex_var_buy_USD2015kWh buying price
Opex_var_sell_USD2015kWh selling price
reference reference
Worksheet: WETBIOMASS
Variable Description
GHG_kgCO2MJ Non-renewable Green House Gas Emissions factor
hour hour of a 24 hour day
Opex_var_buy_USD2015kWh buying price
Opex_var_sell_USD2015kWh selling price
reference reference
Worksheet: WOOD
Variable Description
GHG_kgCO2MJ Non-renewable Green House Gas Emissions factor
hour hour of a 24 hour day
Opex_var_buy_USD2015kWh buying price
Opex_var_sell_USD2015kWh selling price
reference reference

get_database_standard_schedules_use

path: inputs/technology/archetypes/schedules/RESTAURANT.csv

The following file is used by these scripts: archetypes_mapper

Worksheet: APPLIANCES
Variable Description    
1      
2      
3      
4      
5      
6      
7      
8      
9      
10      
11      
12      
13      
14      
15      
16      
17      
18      
19      
20      
21      
22      
23      
24      
DAY Day of the week (weekday saturday or sunday)
Worksheet: COOLING
Variable Description    
1      
2      
3      
4      
5      
6      
7      
8      
9      
10      
11      
12      
13      
14      
15      
16      
17      
18      
19      
20      
21      
22      
23      
24      
DAY Day of the week (weekday saturday or sunday)
Worksheet: ELECTROMOBILITY
Variable Description    
1 Average number of electric vehicles in this hour    
2 Average number of electric vehicles in this hour    
3 Average number of electric vehicles in this hour    
4 Average number of electric vehicles in this hour    
5 Average number of electric vehicles in this hour    
6 Average number of electric vehicles in this hour    
7 Average number of electric vehicles in this hour    
8 Average number of electric vehicles in this hour    
9 Average number of electric vehicles in this hour    
10 Average number of electric vehicles in this hour    
11 Average number of electric vehicles in this hour    
12 Average number of electric vehicles in this hour    
13 Average number of electric vehicles in this hour    
14 Average number of electric vehicles in this hour    
15 Average number of electric vehicles in this hour    
16 Average number of electric vehicles in this hour    
17 Average number of electric vehicles in this hour    
18 Average number of electric vehicles in this hour    
19 Average number of electric vehicles in this hour    
20 Average number of electric vehicles in this hour    
21 Average number of electric vehicles in this hour    
22 Average number of electric vehicles in this hour    
23 Average number of electric vehicles in this hour    
24 Average number of electric vehicles in this hour    
DAY Day of the week (weekday saturday or sunday)
Worksheet: HEATING
Variable Description    
1      
2      
3      
4      
5      
6      
7      
8      
9      
10      
11      
12      
13      
14      
15      
16      
17      
18      
19      
20      
21      
22      
23      
24      
DAY Day of the week (weekday saturday or sunday)
Worksheet: LIGHTING
Variable Description    
1      
2      
3      
4      
5      
6      
7      
8      
9      
10      
11      
12      
13      
14      
15      
16      
17      
18      
19      
20      
21      
22      
23      
24      
DAY Day of the week (weekday saturday or sunday)
Worksheet: METADATA
Variable Description
metadata  
Worksheet: MONTHLY_MULTIPLIER
Variable Description
1  
2  
3  
4  
5  
6  
7  
8  
9  
10  
11  
12  
Worksheet: OCCUPANCY
Variable Description    
1      
2      
3      
4      
5      
6      
7      
8      
9      
10      
11      
12      
13      
14      
15      
16      
17      
18      
19      
20      
21      
22      
23      
24      
DAY Day of the week (weekday saturday or sunday)
Worksheet: PROCESSES
Variable Description    
1      
2      
3      
4      
5      
6      
7      
8      
9      
10      
11      
12      
13      
14      
15      
16      
17      
18      
19      
20      
21      
22      
23      
24      
DAY Day of the week (weekday saturday or sunday)
Worksheet: SERVERS
Variable Description    
1      
2      
3      
4      
5      
6      
7      
8      
9      
10      
11      
12      
13      
14      
15      
16      
17      
18      
19      
20      
21      
22      
23      
24      
DAY Day of the week (weekday saturday or sunday)
Worksheet: WATER
Variable Description    
1      
2      
3      
4      
5      
6      
7      
8      
9      
10      
11      
12      
13      
14      
15      
16      
17      
18      
19      
20      
21      
22      
23      
24      
DAY Day of the week (weekday saturday or sunday)

get_database_supply_assemblies

path: inputs/technology/assemblies/SUPPLY.xlsx

The following file is used by these scripts: demand, emissions, system_costs

Worksheet: COOLING
Variable Description
CAPEX_USD2015kW Capital costs per kW
code Code of cooling supply assembly
Description description
efficiency efficiency of the all in one system
feedstock feedstock used by the the all in one system (refers to the FEEDSTOCK database)
IR_% interest rate charged on the loan for the capital cost
LT_yr lifetime of assembly
O&M_% operation and maintenance cost factor (fraction of the investment cost)
reference reference
scale whether the all in one system is used at the building or the district scale
Worksheet: ELECTRICITY
Variable Description
CAPEX_USD2015kW Capital costs per kW
code Type of all in one system
Description Description of Type of all in one system
efficiency efficiency of the all in one system
feedstock feedstock used by the the all in one system (refers to the FEEDSTOCK database)
IR_% interest rate charged on the loan for the capital cost
LT_yr lifetime of assembly
O&M_% operation and maintenance cost factor (fraction of the investment cost)
reference Reference of the data
scale whether the all in one system is used at the building or the district scale
Worksheet: HEATING
Variable Description
CAPEX_USD2015kW Capital costs per kW
code Type of all in one system
Description Description of Type of all in one system
efficiency efficiency of the all in one system
feedstock feedstock used by the the all in one system (refers to the FEEDSTOCK database)
IR_% interest rate charged on the loan for the capital cost
LT_yr lifetime of assembly
O&M_% operation and maintenance cost factor (fraction of the investment cost)
reference Reference of the data
scale whether the all in one system is used at the building or the district scale
Worksheet: HOT_WATER
Variable Description
CAPEX_USD2015kW Capital costs per kW
code Type of all in one system
Description Description of Type of all in one system
efficiency efficiency of the all in one system
feedstock feedstock used by the the all in one system (refers to the FEEDSTOCK database)
IR_% interest rate charged on the loan for the capital cost
LT_yr lifetime of assembly
O&M_% operation and maintenance cost factor (fraction of the investment cost)
reference Reference of the data
scale whether the all in one system is used at the building or the district scale

get_database_use_types_properties

path: inputs/technology/archetypes/use_types/USE_TYPE_PROPERTIES.xlsx

The following file is used by these scripts: archetypes_mapper

Worksheet: INDOOR_COMFORT
Variable Description
code use type code (refers to building use type)
RH_max_pc Upper bound of relative humidity
RH_min_pc Lower_bound of relative humidity
Tcs_set_C Setpoint temperature for cooling system
Tcs_setb_C Setback point of temperature for cooling system
Ths_set_C Setpoint temperature for heating system
Ths_setb_C Setback point of temperature for heating system
Ve_lsp Indoor quality requirements of indoor ventilation per person
Worksheet: INTERNAL_LOADS
Variable Description
code use type code (refers to building use type)
Ea_Wm2 Peak specific electrical load due to computers and devices
Ed_Wm2 Peak specific electrical load due to servers/data centres
El_Wm2 Peak specific electrical load due to artificial lighting
Epro_Wm2 Peak specific electrical load due to industrial processes
Ev_kWveh Peak capacity of electrical battery per vehicle
Occ_m2p Occupancy density
Qcpro_Wm2 Peak specific process cooling load
Qcre_Wm2 Peak specific cooling load due to refrigeration (cooling rooms)
Qhpro_Wm2 Peak specific process heating load
Qs_Wp Peak sensible heat load of people
Vw_ldp Peak specific fresh water consumption (includes cold and hot water)
Vww_ldp Peak specific daily hot water consumption
X_ghp Moisture released by occupancy at peak conditions