I am trying to import data into Excel to record monthly values. The only way I can find to do it is by importing the month log in the Data sub directory. For this month I would have to import data from a midnight back up on the 30th.
Is what I am doing the best way, if so, can anyone tell me what are the actual categories of the data in the imported CSV file. Some are obvious, date, pressure etc but some are extremely difficult to pin down.
I am looking for something which approaches part way to a NOAA type report but, anything which shows the daily values or monthly values is fine as long as it can be imported into Excel.
Thanks in advance for any help
Barry
Welcome to the Cumulus Support forum.
Latest Cumulus MX V4 release 4.4.2 (build 4085) - 12 March 2025
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Legacy Cumulus 1 release 1.9.4 (build 1099) - 28 November 2014
(a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)
Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki
If you are posting a new Topic about an error or if you need help PLEASE read this first viewtopic.php?p=164080#p164080
Latest Cumulus MX V4 release 4.4.2 (build 4085) - 12 March 2025
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Legacy Cumulus 1 release 1.9.4 (build 1099) - 28 November 2014
(a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)
Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki
If you are posting a new Topic about an error or if you need help PLEASE read this first viewtopic.php?p=164080#p164080
recording data in tabular form
- opticsman0127
- Posts: 71
- Joined: Wed 11 Nov 2009 10:43 am
- Weather Station: Davis Pro2 Wireless
- Location: Sandbach, Cheshire
- Contact:
- steve
- Cumulus Author
- Posts: 26672
- Joined: Mon 02 Jun 2008 6:49 pm
- Weather Station: None
- Operating System: None
- Location: Vienne, France
- Contact:
Re: recording data in tabular form
The formats of the data files are in the help, and in the wiki - http://wiki.sandaysoft.com/index.php?ti ... :Log_Files
Steve
- opticsman0127
- Posts: 71
- Joined: Wed 11 Nov 2009 10:43 am
- Weather Station: Davis Pro2 Wireless
- Location: Sandbach, Cheshire
- Contact:
Re: recording data in tabular form
Hi Steve,
There is a discrepency. In the Format of the files in Wiki, there are 17 'titles'. The actual log file only imports 16 into Excel, unless I am importing incorrectly
Barry
There is a discrepency. In the Format of the files in Wiki, there are 17 'titles'. The actual log file only imports 16 into Excel, unless I am importing incorrectly
Barry
- opticsman0127
- Posts: 71
- Joined: Wed 11 Nov 2009 10:43 am
- Weather Station: Davis Pro2 Wireless
- Location: Sandbach, Cheshire
- Contact:
Re: recording data in tabular form
Hi Steve,
Please forget that last post. For some reason, the last 'column' only started to show data after the first 2 days of commencement, the 14th. Is there something I have done wrong in my set up to cause this?
Barry
Please forget that last post. For some reason, the last 'column' only started to show data after the first 2 days of commencement, the 14th. Is there something I have done wrong in my set up to cause this?
Barry
- steve
- Cumulus Author
- Posts: 26672
- Joined: Mon 02 Jun 2008 6:49 pm
- Weather Station: None
- Operating System: None
- Location: Vienne, France
- Contact:
Re: recording data in tabular form
That data probably came from 1.8.7. The 17th field is Heat Index, which was added in one of the early 1.8.8 builds, and I updated the wiki to correspond to the latest code.
Steve
- steve
- Cumulus Author
- Posts: 26672
- Joined: Mon 02 Jun 2008 6:49 pm
- Weather Station: None
- Operating System: None
- Location: Vienne, France
- Contact:
Re: recording data in tabular form
By the way - I intend to put NOAA reports in Cumulus 2, and might even do it in Cumulus 1 first to try it out. And if you're doing something like that, wouldn't it be easier using dayfile.txt, which has the daily summaries?
Steve
- opticsman0127
- Posts: 71
- Joined: Wed 11 Nov 2009 10:43 am
- Weather Station: Davis Pro2 Wireless
- Location: Sandbach, Cheshire
- Contact:
Re: recording data in tabular form
You are indeed correct. I downloaded the newer build which has caused this discrepency. Sorted.
Yes, just tried the daily values, loads better, thanks ever so much. NOAA would be superb if you can incorporate it.
Thanks again
Barry
Yes, just tried the daily values, loads better, thanks ever so much. NOAA would be superb if you can incorporate it.
Thanks again
Barry