HomeFeaturesExamplesTutorialsHelpTheoryVerificationPricingContact
BoreTherm Online help

TRT import

Select time, inlet/outlet temperature, power and optional flow columns with correct units. Preview parsed rows, missing values and timestamp order. Reject or correct duplicate/non-finite samples; retain data-cleaning notes. CSV separator and decimal settings must match the data.

Step-by-step workflows · Menus and keyboard

TRT import in BoreTherm
English GUI; click to enlarge.
Controls captured from the BoreTherm GUI. Ranges are interface bounds; example values depend on the open project.
ControlMeaning / actionUnitRange / choicesExample value
Selected test fileThe local test data file selected for import.
Open file…Rig data (CSV, TXT, DAT), a BoreTherm test file (.trt.json) or a project with a stored test
Use the test stored in the projectLoad the TRT data already embedded in the open project.
Time columnMap the source column for this quantity. Leave not mapped only when the required quantity can be supplied by another supported input.(not mapped) / A: Time / B: Tin [degC] / C: Tout [degC] / D: Flow [l/min] / E: Power [kW]
Time unitSelect the source unit before import.elapsed seconds / elapsed minutes / elapsed hours / elapsed days / date and time (detected) / dd.mm.yyyy HH:MM / dd.mm.yyyy HH:MM:SS / mm/dd/yyyy HH:MM:SS
Inlet temperature columnMap the source column for this quantity. Leave not mapped only when the required quantity can be supplied by another supported input.(not mapped) / A: Time / B: Tin [degC] / C: Tout [degC] / D: Flow [l/min] / E: Power [kW]
Inlet temperature unitSelect the source unit before import.°C / K / °F
Outlet temperature columnMap the source column for this quantity. Leave not mapped only when the required quantity can be supplied by another supported input.(not mapped) / A: Time / B: Tin [degC] / C: Tout [degC] / D: Flow [l/min] / E: Power [kW]
Outlet temperature unitSelect the source unit before import.°C / K / °F
Flow columnMap the source column for this quantity. Leave not mapped only when the required quantity can be supplied by another supported input.(not mapped) / A: Time / B: Tin [degC] / C: Tout [degC] / D: Flow [l/min] / E: Power [kW]
Flow unitSelect the source unit before import.l/min / l/s / l/h / m³/h / m³/s / kg/s
Heat input columnMap the source column for this quantity. Leave not mapped only when the required quantity can be supplied by another supported input.(not mapped) / A: Time / B: Tin [degC] / C: Tout [degC] / D: Flow [l/min] / E: Power [kW]
Heat input unitSelect the source unit before import.W / kW / MW
Mean temperature columnMap the source column for this quantity. Leave not mapped only when the required quantity can be supplied by another supported input.(not mapped) / A: Time / B: Tin [degC] / C: Tout [degC] / D: Flow [l/min] / E: Power [kW]
Mean temperature unitSelect the source unit before import.°C / K / °F
Trt constant flowConstant flow of the test when the file has no flow column (0 = none)l/min0 to 100000
Delimiter:Select one of the listed alternatives.detect / semicolon ; / comma , / tab / spaces
Decimal separator:Select one of the listed alternatives.detect / point 1.5 / comma 1,5
Repeated time stamps:Samples with the same time stamp, e.g. 30 s data with minute stampsaverage / spread to the next stamp / keep
Resample:Averages the samples on a uniform time step (0 = keep every sample)s0 to 36000
Fibre position of the ground surface: depth = position - offsetFibre position of the ground surface: depth = position - offsetm-10000 to 100000
Top of the depth range of the meanTop of the depth range of the meanm-10000 to 100000
Bottom of the depth range of the mean (e.g. the borehole length)Bottom of the depth range of the mean (e.g. the borehole length)m-10000 to 10000100
Added to the DTS times after the calendar times are matched (e.g. -1 h for a DTS in UTC and a logger in CET)Added to the DTS times after the calendar times are matched (e.g. -1 h for a DTS in UTC and a logger in CET)h-48 to 480
Depth mean as the mean fluid temperatureThe mean over the depth range of every DTS profile becomes the mean fluid temperature of the records (one-minute values).
Add DTS file…Links a DTS file (fibre position in the first column, one column per time stamp) to the test
Read the full dataReads the full data of the compact copy again from the linked files