Page 1 of 1

edit sep12

Posted: Thu 27 Sep 2012 8:45 am
by apenwith
Hi Steve
I wanted to backdate the values for the RG11 record. I opened the sep12log.txt with excel - recalculated the rg11 values and made sure that all the decimal places were correct for all the columns and saved the result as a csv file. Then renamed it to txt. Although it looks identical to a backup I made of the sep file it appears not to be read by cumulus in the select-a-graph. If I go back to the backup all is OK.
Puzzled Cornwall

Regards
Alan

Re: edit sep12

Posted: Thu 27 Sep 2012 9:05 am
by steve
Without seeing the file, it's impossible to comment.

Re: edit sep12

Posted: Thu 27 Sep 2012 9:33 am
by apenwith
Hi Steve
This is a sample of the file I created via a csv

01/09/2012,09:00,15.4,99,15.3,6.6,11.9,302,0.0,0.0,1029.3,244.5,24.2,61,9.3,14.8,15.4,0,0,0.00,0.00,14.7,276,0.3,270,0.0
01/09/2012,09:30,15.8,96,15.2,9.9,12.6,305,0.0,0.0,1028.4,244.5,24.2,61,12.6,14.8,15.8,0,0,0.00,0.00,13.9,364,0.7,315,0.0
01/09/2012,10:00,16.3,94,15.3,9.9,13.8,302,0.0,0.0,1028.5,244.5,24.5,60,11.9,15.4,16.3,0,0,0.00,0.00,14.5,447,1.2,315,0.0
01/09/2012,10:30,16.8,91,15.3,9.9,15.9,305,0.0,0.0,1028.5,244.5,24.8,60,13.2,16.1,16.8,0,0,0.00,0.00,15,523,1.7,315,0.0
01/09/2012,11:00,17,90,15.4,8.6,15.2,282,0.0,0.0,1029.1,244.5,25,60,12.6,16.5,17,0,0,0.00,0.00,15.7,590,2.1,315,0.0
01/09/2012,11:30,17.2,90,15.6,8,13.8,294,0.0,0.0,1028.2,244.5,24.7,60,11.3,16.8,17.2,0,0,0.00,0.00,16.1,646,2.6,315,0.0

Regards
Alan

Re: edit sep12

Posted: Thu 27 Sep 2012 9:55 am
by apenwith
Hi Steve

Found the answer - date format

Thanks
Alan

Re: edit sep12

Posted: Thu 27 Sep 2012 9:58 am
by steve
Ah, yes, that's the usual problem when using Excel.