On This Page
  1. 01Verification
  2. 02Variants
  3. 03Climate
  4. 04U-Values
  5. 05Areas
  6. 06Ground
  7. 07Components
  8. 08Windows
  9. 09Shading
  10. 10Ventilation
  11. 11Addl vent
  12. 12Heating
  13. 13Heating load
  14. 14Cooling
  15. 15Cooling load
  16. 16SummVent
  17. 17Cooling units
  18. 18DHW+Distribution
  19. 19SolarDHW
  20. 20PV
  21. 21Electricity
  22. 22Use non-res
  23. 23Electricity non-res
  24. 24Aux Electricity
  25. 25IHG non-res
  26. 26PER
  27. 27HP
  28. 28Boiler
  29. 29Data
  30. 30Overview
  31. 31easyPH
Reference › PHPP Field Mapping

PHPP Field Mapping

Cell-level locator map for reading and writing PHPP 10.6 Excel worksheets via PHX.

schema version PHPP 10.6
maintainer bldgtyp
source PHX / docs
LLM-ready · Fetch this doc

This page is mirrored at a stable URL for programmatic retrieval. Point your LLM tool at the URL below and it will always receive the current canonical schema in plain Markdown.

GET https://docs.passivehousetools.com/llm/phx/reference/phpp-field-mapping.md

PHPP Field Mapping Reference

Localization map for PHPP 10.6 (English). This document describes how PHX locates and reads/writes cells in each PHPP worksheet.

Note

PHX locates fields by searching for locator_string in locator_col, then reads/writes at input_column offset by input_row_offset rows from the found row.

Verification

Worksheet key: VERIFICATION

Field KeyLabel (locator_string)Locator ColInput ColRow OffsetUnitOptions
phi_building_category_typeBuilding useRT11: 10-Residential building: Residential; 2: 12-Residential building: Other; 11: 10-Residential building: Residential; 12: 12-Residential building: Other
phi_building_use_typeBuilding useRT110: 10-Residential building: Residential; 12: 12-Residential building: Other; 20: 20-Non-res building: Office/Administration; 21: 21-Non-res building: School half-days (< 7 h); 22: 22-Non-res building: School full-time (≥ 7 h); 23: 23-Non-res.: Other
phi_building_ihg_typeBuilding useRT42: 2-Standard; 3: 3-PHPP-calculation (‘IHG’ worksheet); 4: 4-PHPP-calculation (‘IHG non-res’ worksheet)
phi_building_occupancy_typeNo. of occupantsRR21: (null); 2: (null)
phi_certification_typePlanned energy standardTT110: 10-Passive house; 21: 21-EnerPHit (Component method); 22: 22-EnerPHit (Energy demand method); 30: 30-PHI Low Energy Building; 40: 40-Other
phi_certification_classClassPrimary energy methodTT1
phi_pe_typePrimary energy demand criterionTT11: 1-Standard; 2: 2-Project-specific
phi_enerphit_typeNew building / RetrofitTT11: 1-New building; 2: 2-Retrofit; 3: 3-Staged retrofit
phi_retrofit_typeNew building / RetrofitTT11: 1-New building; 2: 2-Retrofit; 3: 3-Staged retrofit
num_of_unitsNo. of dwelling units:EF0
setpoint_winterInterior temperature winter [°C]:JK0C
setpoint_summerInterior temp. summer [°C]:MN0C
mechanical_coolingMechanical cooling:MN0

Variants

Worksheet key: VARIANTS

Configuration:

  • active_value_column: E

results_header

  • Header locator: col B, string "Results"

input_header

  • Header locator: col B, string "Input variables"

assemblies

  • Header locator: col C, string "Building assembly layers"

  • input_col: C

windows

  • Header locator: col C, string "Windows and shading"

  • input_col: C

ventilation

  • Header locator: col C, string "Ventilation"

Input item names:

  • vent_type: “Ventilation type”

  • air_change_rate: “Air change rate at pressurisation test (n50)”

  • design_flow_rate: “Design air flow rate (maximum)”

  • install_location: “Installation site ventilation unit”

  • ventilator_unit: “Ventilation unit selection”

  • input_col: C

Climate

Worksheet key: CLIMATE

active_dataset

FieldColumn
countryD
regionD
datasetD
elevation_overrideD

active_block

  • start_row: 26
  • end_row: 36
  • start_col: D
  • end_col: U

ud_block

  • Header locator: col Name of location, string ""
  • start_row: 67
FieldColumn
janE
febF
marG
aprH
mayI
junJ
julK
augL
sepM
octN
novO
decP
peak_heating_1Q
peak_heating_2R
peak_cooling_1S
peak_cooling_2T
PERU
latitudeF
longitudeH
elevationJ
elevation_unitM
display_nameL
summer_delta_tN
summer_delta_t_unitDELTA-C
sourceP
FieldRowUnit
temperature_air1C
radiation_north2KWH/M2
radiation_east3KWH/M2
radiation_south4KWH/M2
radiation_west5KWH/M2
radiation_global6KWH/M2
temperature_dewpoint7C
temperature_sky8C

named_ranges

  • country: Klima_Region
  • region: Klima_Region2
  • data_set: Klima_Standort

defined_ranges

  • climate_zone: D13
  • weather_station_altitude: D17
  • site_altitude: D18
  • latitude: F25
  • longitude: H25

U-Values

Worksheet key: UVALUES

constructor

  • Header locator: col L, string "Description of building assembly"
FieldColumnUnit
display_nameL
r_siMM2K/W
r_seMM2K/W
interior_insulationR
sec_1_descriptionL
sec_1_conductivityMW/MK
sec_2_descriptionN
sec_2_conductivityOW/MK
sec_3_descriptionP
sec_3_conductivityQW/MK
thicknessRMM
u_val_supplementRW/M2K
variants_layer_nameE
variants_conductivityF
variants_thicknessG
sec_2_percentageO
sec_3_percentageQ

Row offsets within each assembly block:

  • phpp_id_num_col_offset: 5
  • name_row_offset: 2
  • rsi_row_offset: 4
  • rse_row_offset: 5
  • first_layer_row_offset: 7
  • last_layer_row_offset: 14
  • result_val_row_offset: 19
  • result_val_col: R
  • result_val_unit: W/M2K

Areas

Worksheet key: AREAS

Field KeyLabel (locator_string)Locator ColInput ColRow OffsetUnitOptions
tfa_input1-Treated floor areaMT0M2

summary_rows

  • temp_zones: K
  • area_type: M
  • group_number: N
  • area: L
  • average_u_value: P

surface_rows

  • Header locator: col K, string "Area input"
  • Entry locator: col K, string "1"
FieldColumnUnit
descriptionL
group_numberM
quantityN
areaTM2
assembly_idAA
orientationAE
angleAF
shadingAH
absorptivityAI
emissivityAJ

thermal_bridge_rows

  • Header locator: col K, string "Thermal bridge input"
  • Entry locator: col K, string "1"
FieldColumnUnit
descriptionL
group_numberM
quantityN
lengthPM
psi_valueVW/MK
fRsi_valueX

defined_ranges

Ground

Worksheet key: GROUND

Components

Worksheet key: COMPONENTS

glazings

  • entry_column: IH
  • entry_start_row: 13
  • header_start_row: 8
FieldColumnUnit
idIH
descriptionII
g_valueIJ
u_valueIKW/M2K

frames

  • Header locator: col IO, string "Window and door frames"
  • Entry locator: col IO, string "01ud"
FieldColumnUnit
idIO
descriptionIP
u_value_leftIUW/M2K
u_value_rightIWW/M2K
u_value_bottomJAW/M2K
u_value_topIYW/M2K
width_leftITMM
width_rightIVMM
width_bottomIZMM
width_topIXMM
psi_g_leftIRW/MK
psi_g_rightIRW/MK
psi_g_bottomIRW/MK
psi_g_topIRW/MK
psi_i_leftJZW/MK
psi_i_rightJZW/MK
psi_i_bottomKBW/MK
psi_i_topKAW/MK

ventilators

  • Header locator: col LQ, string "Ventilation units"
  • Entry locator: col LQ, string "01ud"
FieldColumnUnit
idLQ
display_nameLR
sensible_heat_recoveryLS
latent_heat_recoveryLT
electric_efficiencyLWWH/M3
min_m3hLXM3/HR
max_m3hLYM3/HR
pa_per_sectionLZPA
pa_per_fittingsMAPA
frost_protection_reqdMB
noise_35DBAMC
noise_supply_airMD
noise_extract_airME
additional_infoMF

Windows

Worksheet key: WINDOWS

window_rows

  • Header locator: col L, string "Windows and entrance doors"
  • Entry locator: col L, string "Quan-"
FieldColumnUnit
quantityL
descriptionN
orientation_angleO
vertical_angleP
orientation_labelQ
widthRM
heightSM
hostT
glazing_idU
frame_idV
psi_i_leftANW/MK
psi_i_rightAOW/MK
psi_i_bottomAQW/MK
psi_i_topAPW/MK
window_areaAWM2
glazing_areaAXM2
glazing_fractionAY
u_wAZW/M2K
u_w_installedBAW/M2K
comfort_exemptEQ
comfort_tempEQC
variant_inputF

window_rows_end

  • Header locator: col L, string "Windows and entrance doors"
  • Entry locator: col L, string "Unhide additional rows"

Shading

Worksheet key: SHADING

shading_rows

  • Header locator: col T, string "Calculation of reduction factors for shading"
  • Entry locator: col T, string "Quan-"
FieldColumnUnit
h_horiABM
d_horiACM
o_revealADM
d_revealAEM
o_overAFM
d_overAGM
r_other_winterAH
r_other_summerAI
temp_zAJ
regulatedAK

shading_rows_end

  • Header locator: col T, string "Shading"
  • Entry locator: col T, string "Unhide additional rows"

Ventilation

Worksheet key: VENTILATION

Field KeyLabel (locator_string)Locator ColInput ColRow OffsetUnitOptions
vent_typeType of ventilationIK
wind_coeff_eWind protection coefficient, eIJ
wind_coeff_fWind protection coefficient, fIJ
airtightness_n50Air change rate from pressurisation testIM
airtightness_Vn50Net air volume for pressurisation testIMM3
multi_unit_on’Addl vent’ worksheetIK

Configuration:

  • variants_col: D

Addl vent

Worksheet key: ADDNL_VENT

rooms

  • Header locator: col C, string "Room"
  • Entry locator: col C, string "1"
  • last_col: Z
FieldColumnUnit
quantityD
display_nameE
vent_unit_assignedF
weighted_floor_areaGM2
clear_heightHM
V_supJM3/HR
V_etaKM3/HR
V_transLM3/HR
operating_hoursN
operating_daysO
holiday_daysP
period_high_speedQ
period_high_timeR
period_standard_speedS
period_standard_timeT
period_minimum_speedU
period_minimum_timeV

units

  • Header locator: col C, string "Venti-"
  • Entry locator: col C, string "1"
FieldColumnUnit
quantityD
display_nameE
unit_selectedF
oda_sup_paKPA
eta_eha_paLPA
addnl_paMPA
ext_locationQ
subsoil_hrX
frost_protection_typeZ
temperature_below_defrost_usedAAC

ducts

  • Header locator: col E, string "Round"
  • Entry locator: col D, string "1"
FieldColumnUnit
quantityD
diameterFMM
widthFMM
heightGMM
insul_thicknessHMM
insul_conductivityIW/MK
insul_reflectiveJ
sup_air_duct_lenLM
oda_air_duct_lenMM
exh_air_duct_lenNM
duct_assign_1Q
duct_assign_2R
duct_assign_3S
duct_assign_4T
duct_assign_5U
duct_assign_6V
duct_assign_7W
duct_assign_8X
duct_assign_9Z
duct_assign_10Z

Heating

Worksheet key: HEATING_DEMAND

Configuration:

  • unit: kWh
  • col_kWh_year: O
  • col_kWh_m2_year: Q
  • row_total_losses_transmission: 27
  • row_total_losses_ventilation: 43
  • row_total_losses: 45
  • row_total_gains_solar: 61
  • row_total_gains_internal: 65
  • row_utilization_factor: 72
  • row_useful_gains: 74
  • row_annual_demand: 78

Heating load

Worksheet key: HEATING_PEAK_LOAD

Configuration:

  • unit: W
  • col_weather_1: P
  • col_weather_2: R
  • row_total_losses_transmission: 44
  • row_total_losses_ventilation: 57
  • row_total_losses: 60
  • row_total_gains_solar: 73
  • row_total_gains_internal: 77
  • row_total_gains: 80
  • row_total_load: 88

Cooling

Worksheet key: COOLING_DEMAND

Configuration:

  • unit: kWh
  • col_kWh_year: O
  • col_kWh_m2_year: Q
  • row_total_losses_transmission: 29
  • row_total_losses_ventilation: 57
  • row_total_losses: 59
  • row_utilization_factor: 84
  • row_useful_losses: 86
  • row_total_gains_solar: 73
  • row_total_gains_internal: 77
  • row_total_gains: 79
  • row_annual_sensible_demand: 88
  • row_annual_latent_demand: 94
  • address_specific_latent_cooling_demand: AN176
  • address_tfa: O8

Cooling load

Worksheet key: COOLING_PEAK_LOAD

Configuration:

  • unit: W
  • col_weather_1: P
  • col_weather_2: R
  • row_total_losses_transmission: 35
  • row_total_losses_ventilation: 43
  • row_total_gains_solar: 56
  • row_total_gains_internal: 60
  • row_total_sensible_load: 64
  • row_total_latent_load: 93

SummVent

Worksheet key: SUMM_VENT

Cooling units

Worksheet key: COOLING_UNITS

Configuration:

  • SEER_unit: W/W

supply_air

  • used: Kuehlgeraete_Zuluft_Kuehlung_Ankreuzen
  • num_units: Kuehlgeraete_Kompressor_Zuluft_Anzahl
  • device_type_name: Kuehlgeraete_Kompressor_Zuluft_Geraet
  • SEER: X32

recirculation_air

  • used: Kuehlgeraete_Umluft_Kuehlung_Ankreuzen
  • num_units: Kuehlgeraete_Kompressor_Umluft_Anzahl
  • device_type_name: Kuehlgeraete_Kompressor_Umluft_Geraet
  • SEER: X50

dehumidification

  • used: Kuehlgeraete_Zusaetzliche_Entfeuchtung_Ankreuzen
  • waste_heat_to_room: Kuehlgeraete_Zusaetzliche_Entfeuchtung_Abwaerme
  • SEER: Kuehlgeraete_Zusaetzliche_Entfeuchtung_JAZ

panel

  • used: Kuehlgeraete_Flaechenkuehlung_Ankreuzen
  • device_type_name: Kuehlgeraete_Kompressor_Flaechenkuehlung_Geraet
  • SEER: X69

DHW+Distribution

Worksheet key: DHW

recirc_piping

  • Header locator: col D, string "DHW distribution"
  • Entry locator: col E, string "DHW circulation pipes or, for heat interface units, forward and return flows"
  • input_col_start: J
FieldRow OffsetUnit
total_length2M
diameter3MM
insul_thickness4MM
insul_reflective5
insul_conductivity6W/MK
daily_period12
water_temp13C

branch_piping

  • Header locator: col D, string "DHW distribution"
  • Entry locator: col E, string "DHW stub pipes / individual pipes"
  • input_col_start: J
FieldRow OffsetUnit
water_temp1C
diameter2MM
total_length3M
num_taps4

tanks

  • Header locator: col D, string "Storage heat losses"
  • Entry locator: col J, string "Storage type 1"
  • entry_row_start: 191
FieldColumn
tank_1J
tank_2M
tank_bufferP
FieldRowUnit
tank_type0
standby_losses5W/K
storage_capacity6L
standby_fraction7
tank_location9
water_temp12C

tank_type options: 0: 0-No storage tank; 1: 1-DHW and heating; 2: 2-DHW only

tank_location options: 1: 1-Inside; 0: 2-Outside

SolarDHW

Worksheet key: SOLAR_DHW

Configuration:

  • footprint_unit: M2
  • energy_unit: KHW

ranges

  • footprint: SolarWW_Kollektorflaeche
  • annual_dhw_contribution: N34
  • annual_dhw_energy: P34
  • annual_heating_contribution: N35
  • annual_heating_energy: P35

PV

Worksheet key: SOLAR_PV

Configuration:

  • footprint_unit: M2
  • energy_unit: KWH

columns

  • systems_start: S
  • systems_end: W

rows

  • systems_start: 10
  • current: 20
  • voltage: 21
  • num_panels: 29
  • footprint: 37
  • annual_energy: 42
  • systems_end: 47

Electricity

Worksheet key: ELECTRICITY

input_columns

  • selection: E
  • used: E
  • in_conditioned_space: F
  • energy_demand_per_use: N
  • utilization_factor: H
  • frequency: K
  • reference_quantity: I
  • annual_energy_demand: AB

input_rows

ApplianceData RowSelection RowOptions
dishwasher25241: 1-DHW connection; 2: 2-Cold water connection
clothes_washing29281: 1-DHW connection; 2: 2-Cold water connection
clothes_drying33321: 1-Clothes line; 2: 2-Drying closet (cold!); 3: 3-Drying closet (cold!) in extract air; 4: 4-Condensation dryer; 5: 5-Electric exhaust air dryer; 6: 6-Gas exhaust air dryer
refrigerator16
freezer17
fridge_freezer18
cooking21201: 1-Electricity; 2: 2-Natural gas; 3: 3-LPG
lighting37
lighting_interior38
lighting_exterior39
consumer_elec68
small_appliances68

Use non-res

Worksheet key: USE_NON_RES

Electricity non-res

Worksheet key: ELEC_NON_RES

lighting_rows

  • Header locator: col C, string "Lighting"
  • Entry locator: col C, string "Room / Zone"
FieldColumnUnit
room_zone_nameC
net_floor_areaD
utilization_profileE
room_has_windowF
room_angle_from_northG
room_orientationH
factorI
glazing_light_transmissionJ
room_depthK
room_widthL
room_heightM
lintel_heightN
window_widthO
daily_utilizationP
nominal_illuminationR
installed_powerSW/M2
lighting_controlV
motion_detector_usedW
utilization_hours_yearX
ud_annual_full_load_hoursY
annual_full_load_hoursZ
daily_full_load_hoursAA
annual_energy_demandAC

Aux Electricity

Worksheet key: AUX_ELEC

IHG non-res

Worksheet key: IHG_NON_RES

PER

Worksheet key: PER

Configuration:

  • locator_col: P
  • unit: KWH

named_ranges

  • heating_type_1: PE_Waermeerzeuger_primaer
  • heating_type_2: PE_Waermeerzeuger_sekundaer

columns

  • calculated_efficiency: Q
  • user_determined_efficiency: R
  • final_energy: T
  • per_energy: V
  • pe_energy: X
  • co2_emissions: Z

addresses

  • tfa: Z7
  • footprint: Z8

heating_types

  • range_start: P8
  • range_end: T11

heating

  • locator_string_heading: Heating
  • locator_string_start: Electricity (HP compact unit)

cooling

  • locator_string_heading: Cooling and dehumidification
  • locator_string_start: Electricity cooling (HP)

dhw

  • locator_string_heading: DHW generation
  • locator_string_start: Electricity (HP compact unit)

household_electric

  • locator_string_heading: Occupant electricity + auxiliary electricity (other)
  • locator_string_start: User electricity (lighting, electrical devices, etc.)

additional_gas

  • locator_string_heading: Additional gas demand
  • locator_string_start: Drying/Cooking

energy_generation

  • locator_string_heading: Energy generation
  • locator_string_start: PV electricity

HP

Worksheet key: HP

Boiler

Worksheet key: BOILER

Data

Worksheet key: DATA

version

  • Header locator: col A, string "PHPP Version"
  • Entry locator: col B, string ""

Overview

Worksheet key: OVERVIEW

basic_data

  • address_number_dwellings_res: C27
  • address_number_dwellings_nonres: E27
  • address_number_occupants_res: C28
  • address_number_occupants_nonres: E28
  • address_project_name: C11

building_envelope

  • address_area_envelope: col C, row 105 (M2)
  • address_area_tfa: col E, row 105 (M2)

ventilation

  • vn50: col C, row 362 (M3)

easyPH

Worksheet key: EASY_PH