Data exported to Excel

[Sansian]

Hi All

I have searched the forums but couldn't find an answer to my question.

My plan is to pisition a Maxkon WS 1080 weather station in one of our remote paddocks at a trial site. We will visit the site every 7 to 10 days to download the data to a lap top.

What I want to do is be able to view the data collected in a table format, most likely using Excel.
I would like to achieve a table where it lists Date and time and all of the readings in the next columns associated with each time point.


Is there a way to export all of the readings that go to make up the graphs into an Excel file or a CSV file?

[steve]

The data files are already in CSV format. Or am I misunderstanding what it is you want to do?

[apenwith]

Hi
It's very simple to transfer from Easyweather to Excel as there is an EXPORT facility. I don't
bother with the historical rain data (eg rain in last 24 hrs etc) as I find it unreliable in the dat
file. I let excel calculate it for me. As I keep a file per month it means getting excel for eg june
to look back at some of may's data to get the last week/month/total data which makes the model slightly complicated. I then use Excel for graphing as well largely because I calculate the
probable efficiency of a wind turbine. (The output depends on the cube of the windspeed as I'm
sure you know). And I can produce graphs which are wider (2 A4 landscapes wide). Thinking about which, Steve, would it be possible to stretch Cumulus graph prints to space out the troughs and peaks ?
I forget who wrote the original request (Samsiam I Think) but if he/she would like a copy of my
spreadsheet as a basis I could email it to them.
Regards
Alan

[steve]

Thinking about which, Steve, would it be possible to stretch Cumulus graph prints to space out the troughs and peaks ?

You can zoom the normal graphs (by dragging), or there's Select-a-graph where you can choose the start and end times - or is that not what you meant?

[Sansian]

Hi guys

Thanks for the replies, sorry I have delayed in getting back to you.

When I look at the files in the Data folder, they appear as txt file, which obviously has all the data in but not in a format that I can use in Excel. Like Apenwith said I can do it fairly easy with Easyweather.

Is this done using the easyweather dat file section on cumulus?

[steve]

The files are comma-separated text (i.e. CSV, which is what you asked for), which is quite easy to import into Excel? I do it occasionally myself.

[Sansian]

Aha, apologies a bit slow on the uptake.

Thanks everyone

[tfk78]

I have a question to this old topic as well. Having installed cumulus and trying to import the csv files into excel, it seems that excel doesn't recognize the numbers as numbers. Even when I set the cells format to "number" it will not let me calculate with the data or graph them. Has anyone had this problem or does anyone know a solution?

[steve]

Having installed cumulus and trying to import the csv files into excel, it seems that excel doesn't recognize the numbers as numbers.

What character does your system use for decimals? Cumulus uses the system setting; I'd expect Excel to do the same.

[tfk78]

Hi
Sorry, the Email reminder wasn't sent, thus my late answer.
I have figured out that it DOES work with the dayfile, but not with the jun2011log, and in both I use the same settings.

I had actually tried to import the data with all kinds of settings. Both "," and "." for decimals, and it turned out to be the same problem. I suppose the numbers are just not recognized as numbers...

But now with the dayfile it works just fine. I import it and can calculate and plot the numbers however I want. Seems kind of weird, cause I would have thought that both use the same properties in the csv.

[steve]

Sorry, I've no idea what the problem is. The monthly files use the same format as dayfile.txt.

[tfk78]

Thanks anyways. It works with the daily values, that is all I need right now. If I need the logged "raw" data, I will certainly try harder.
Cheers