Skip to content

PoC: User specified demand heating profile (template_user_demand.csv)

KobusVanRooyen edited this page Jun 19, 2025 · 19 revisions

Specification and usage of the Template_user_demand_profile.csv (Template_user_demand_profile.xlsx) file:

  1. The file should contain hourly heat demand profile data for 1 year (8760 timesteps).
  2. The file must contain at least 2 columns namely “datetime” and one or more “name_of_your_profile” columns.
  3. “datetime”:
    – this column contains the hourly time horizon
    – cell format must be “dd-mm-yyyy h:mm”, example “01-01-2019 10:00”.
    – one can set this format by selecting the column, right mouse click→format cells→Costum→type→select from list or type “dd-mm-yyyy hh:mm”.
  4. “name_of_your_profile”:
    – this is a user specified name for the profile.
    – this column contains the heat demand values in kW or MW.
    IMPORTANT, when this user defined profile is used in the MapEditor (“Set profile of InportIn: In”),
    ensure that the correct unit selected in “Quantity and Unit”
    (kW or MW) to match the units of the user defined profile data.
  5. The file must be saved as: CSV (Comma delimited)(*.csv).
  6. IMPORTANT, once the file is closed and opened afterwards (for editing of the data for an example)
    with excel, the date format of column 1 might/will change to something like “d/m/yy hh:mm”. This
    file will not be able to load in the MapEditor. Please update the date format as specified in this file before saving as a “*.csv” file.

Clone this wiki locally