{"id":1775,"date":"2019-04-10T15:32:26","date_gmt":"2019-04-10T13:32:26","guid":{"rendered":"http:\/\/www.htflux.com\/en\/?page_id=1775"},"modified":"2019-05-27T16:51:38","modified_gmt":"2019-05-27T14:51:38","slug":"importing-custom-time-series","status":"publish","type":"page","link":"https:\/\/www.htflux.com\/en\/documentation\/dynamic-thermal-simulations\/importing-custom-time-series\/","title":{"rendered":"Importing custom time-series"},"content":{"rendered":"<p>You can freely create your own time-series based upon your requirements. These time-series can have any required duration (e.g. 24 hours, several days, several months, one or more years). Once you have imported such a time-series, HTflux will automatically assume this time series to be periodic. This means if you import a 24-hour time-series you simulate several days without any extra effort (usually you will have to simulate more than one cycle to allow your components to settle to the correct temperature profiles).<\/p>\n<p>Regarding the necessary format for the custom time series, please read the following notes:<\/p>\n<ul>\n<li>The format that can be read by HTflux is a so-called <strong>plain text<\/strong> format with <strong>tab separations<\/strong> between the columns.<\/li>\n<li>The first row can contain a tab separated header line to describe to content of each column.<\/li>\n<li>The file can contain more than one column containing different values for different time-series (in this case it makes sense to use the header-line to distinguish the different columns)<\/li>\n<li>Datetime-column: the first column has to contain the date &amp; time for each row. The <strong>delimiter between the date and the time has to be a blank (not a tab!)<\/strong>. If you have a time series that is shorter than one day you should still provide a random date for it. <strong>Seconds can be included<\/strong> in the time, but are not mandatory.<br \/>\nThe format for the first column containing the date &amp; time is therefore:<\/li>\n<\/ul>\n<p style=\"padding-left: 60px;\"><span style=\"color: #339966;\"><strong>DD.MM.YYYY hh:mm(:ss)<br \/>\n<\/strong><\/span>examples for valid date-time column:\u00a0 <strong><span style=\"color: #339966;\">01.04.2019 15:30:15<\/span>\u00a0 or\u00a0 <span style=\"color: #339966;\">01.04.2019 16:44<\/span><\/strong><\/p>\n<p style=\"padding-left: 60px;\"><em>note: you can easily setup Excel to provide this date &amp; time format.<\/em><\/p>\n<ul>\n<li>The columns after the datetime-column will be interpreted as <strong>value-columns<\/strong> of\u00a0 the time series. You can provide <strong>one or more value columns<\/strong>.<br \/>\nThe values can contain a <strong>decimal separator<\/strong> (either a comma or a dot), but must <strong>not contain a thousand separator<\/strong>.<br \/>\n<strong>Do not include unit descriptors<\/strong> in the column (such as \u00b0C or F)<\/li>\n<\/ul>\n<p style=\"padding-left: 60px;\">examples for valid value columns: \u00a0\u00a0<strong><span style=\"color: #339966;\">22,3<\/span>\u00a0\u00a0\u00a0\u00a0 <span style=\"color: #339966;\">22.3<\/span>\u00a0\u00a0\u00a0 <span style=\"color: #339966;\">23<\/span><\/strong><\/p>\n<p style=\"padding-left: 60px;\"><em>note: if you are using the feature \u201cfixed temperature materials\u201d use -333 as value to specify your heating source as \u201cturned-off\u201d.<\/em><\/p>\n<ul>\n<li>Each row in the text file must therefore contain the following information:<\/li>\n<\/ul>\n<p style=\"padding-left: 60px;\"><strong><span style=\"color: #339966;\"><em>DD.MM.YYYY hh:mm(:ss)&lt;TAB&gt;value series 1&lt;OPTIONAL:TAB&gt;value series 2&lt;TAB&gt;\u2026.<\/em><\/span><\/strong><\/p>\n<p style=\"padding-left: 60px;\">example of a valid file including a column header:<\/p>\n<p style=\"text-align: left; padding-left: 60px;\"><span style=\"color: #339966;\"><strong><em>datetime\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 indoor-temp\u00a0\u00a0\u00a0\u00a0\u00a0 outdoor-temp<br \/>\n01.01.2019 17:00 22.3 -2.4<br \/>\n01.01.2019 17:15\u00a0\u00a0\u00a0\u00a0 22.2\u00a0\u00a0\u00a0 -2.7<br \/>\n01.01.2019 17:30\u00a0\u00a0\u00a0\u00a0 22.2\u00a0\u00a0\u00a0 -3.4<br \/>\n&#8230;.<\/em><\/strong><\/span><\/p>\n<ul>\n<li><em>Note: a convenient way to create valid files is to setup the correct format for each column in excel. Afterwards you can copy &amp; paste the entire data into a text editor (e.g. notepad) and save the file as text file (optionally you can export as CSV file, but make sure that tabs are used as column separators).<\/em><\/li>\n<li>Find below some downloadable time-series, which can serve as examples or templates for your time-series.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You can freely create your own time-series based upon your requirements. These time-series can have any required duration (e.g. 24 hours, several days, several months, one or more years). Once you have imported such a time-series, HTflux will automatically assume this time series to be periodic. This means if you import a 24-hour time-series you [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":1446,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"pageTemp-userGuide_NEW.php","meta":{"footnotes":""},"class_list":["post-1775","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.htflux.com\/en\/wp-json\/wp\/v2\/pages\/1775","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.htflux.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.htflux.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.htflux.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.htflux.com\/en\/wp-json\/wp\/v2\/comments?post=1775"}],"version-history":[{"count":7,"href":"https:\/\/www.htflux.com\/en\/wp-json\/wp\/v2\/pages\/1775\/revisions"}],"predecessor-version":[{"id":1788,"href":"https:\/\/www.htflux.com\/en\/wp-json\/wp\/v2\/pages\/1775\/revisions\/1788"}],"up":[{"embeddable":true,"href":"https:\/\/www.htflux.com\/en\/wp-json\/wp\/v2\/pages\/1446"}],"wp:attachment":[{"href":"https:\/\/www.htflux.com\/en\/wp-json\/wp\/v2\/media?parent=1775"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}