Forum Discussion
Filling in a Table with Intermittent Dates
I am trying to fill in a table with large amounts of data. The table I am filling has an unbroken list of dates through the year, as I am tracking a building's energy usage throughout the year. Howev...
Let me clarify - do you mean you'd like to generate the table as in Oak Hill Data sheet from the bunch of added from time to time files like Wing XXX Load, syncing resulting data by datetime?
That is correct. The full monthly calendar in Oak Hill Data would be populated according to the incomplete dates in the data sheets, hopefully.
I see, thank you. Format/structure of the source files is exactly the same as in sheets, or you modified them somehow?
I don't know how to check the minor going ons behind the scenes in Excel, but the format of both dates fields should be mm/dd/yy hh:mm, sampled every 15 minutes.
