![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
EL wire resource
6 Jan 2011 05:32 amA collection of info and how-to stuff for EL wire (the glowy stuff).
6 Jan 2011
Leading Zeroes Are Your Friend
6 Jan 2011 06:06 amA particular utility company (*cough*PG&E*cough*) offers the option of downloading hourly electrical usage on a day-by-day basis, at least for those with smart meters. So, you wind up with a lot of comma-delimited files that are named by the date. Handy, yes?
Unfortunately the programmer who wrote the code for this slipped (aside from the American-centric practive of uselessly putting the year at the end of the string, making sorting a pain). 30 Dec 2010 appears as "12302010" but 02 Jan 2011 appears as "122011" -- the mapping isn't one-to-one, obviously. Is "1122011" supposed to be 12 Jan or 2 Nov? Leading zeroes are there for a reason, folks.
If I wasn't merging them into one big spreadsheet I'd be renaming them manually as I grabbed 'em.
Unfortunately the programmer who wrote the code for this slipped (aside from the American-centric practive of uselessly putting the year at the end of the string, making sorting a pain). 30 Dec 2010 appears as "12302010" but 02 Jan 2011 appears as "122011" -- the mapping isn't one-to-one, obviously. Is "1122011" supposed to be 12 Jan or 2 Nov? Leading zeroes are there for a reason, folks.
If I wasn't merging them into one big spreadsheet I'd be renaming them manually as I grabbed 'em.
