Custom TRNSYS component that converts simulation time into the Excel Serial Datetime format.
Type 3800 bridges TRNSYS simulation outputs with spreadsheet tools such as Microsoft Excel by converting TRNSYS simulation time into Excel’s serial datetime format. This makes it easier to analyze, graph, and post-process TRNSYS results directly in Excel.
- TRNSYS v.18
-
Clone the repo or download the source files:
git clone https://github.com/allachance/TRNSYS-ExcelSerialDatetime-Type3800.git
-
Copy the folders into your TRNSYS 18 installation directory, e.g.,
C:\TRNSYS18
| Name | Description | Options |
|---|---|---|
| Mode | Defines how multi-year simulations are handled | 1 → Time accumulates across years2 → Time loops within the reference year |
| Reference Year | Simulation starting year | — |
| Name | Description | Options |
|---|---|---|
| Serial Date | Serial number compatible with Excel datetime | — |
Note
TRNSYS simulations always assume a non-leap year with 8,760 hours per year. Therefore, February 29th is never simulated and will be skipped during conversion. To ensure a continuous date mapping to Excel serial numbers, it is recommended to avoid using leap years as the reference year.
Use the following formula to convert the Serial Date number into a datetime format:
=TEXT(A1,"yyyy-mm-dd hh:mm:ss")