Import data using Calendar Time and fractional days
Posted: Sun Jul 02, 2017 2:57 pm
I'm learning to love the time series import and mapping features of Ventity.
I've been able to get Ventity to import a time series if DateTime is fractions of a day (e.g. 0, 0.0417, 0.0833, ...) or whole days (e.g. 1/1/2017, 1/2,2017,...) after checking "Use Calendar Time" in Run Control.
But I haven't figured out how to import hourly data using Calendar Time (e.g. Hourly solar flux throughout a year). Sure, I can hack this in Excel by making DateTime increment from 0 to 365 in steps of 1/24, but that seems to defeat the point of the Calendar Time feature.
Did I miss something?
I've been able to get Ventity to import a time series if DateTime is fractions of a day (e.g. 0, 0.0417, 0.0833, ...) or whole days (e.g. 1/1/2017, 1/2,2017,...) after checking "Use Calendar Time" in Run Control.
But I haven't figured out how to import hourly data using Calendar Time (e.g. Hourly solar flux throughout a year). Sure, I can hack this in Excel by making DateTime increment from 0 to 365 in steps of 1/24, but that seems to defeat the point of the Calendar Time feature.
Did I miss something?