Good job. Don’t need another way. For the uninitiated, here is a quick way to put it in Excel..
Select the block of text for LA or OC, paste into notepad, save as a text file (make note of location and filename)
Bring up Excel, select File->Open. Set the view in the ‘chooser’ to all files (*.*). Navigate to the file you saved and select and ‘open’ it. You will get a menu for import wizard.
First page of import wizard:
Select Delimited, start at row 1 File Origin should be 437:OEM US.
Hit Next
Select delimiters as ‘tab’ and ‘space'(last one usually not checked). Make sure that you treat consecutive delimiters as one.
Hit Next
Treat first column as date, MDY..
Second through last should be general..
Hit Finish.. and play (the numbers should now be in Excel).
Having it in the single space separated format is great.. I can suck it into other programs as well as ones I write, without any problems. The only concern would be with longer data sets.. Maybe a web page on somewhere for the full sized /updated as we go form? One year will have 365 rows per area.
