End of month is near: how do I generate a month report with

[WS Grave]

Has anyone managed to create a month report with help of excel and the monthly log/data files?

Without that I will have to make a screenshot and type my own list for the month.

PS.
I have seen the Spanish spreadsheet, but can't figger out how he did that ;)


/oops. I now see that I posted this in the wrong forum.
It should be in the application forum. Sorry.

[Chill]

WS Grave wrote:
I have seen the Spanish spreadsheet, but can't figger out how he did that ;)
[/quote]

Data for past periods (days) are extracted from each sensor's daily data file (min/Max) e.g: (rain0-day1, ...)

Today's data is extracted from the file I send to weather network.

HTH,
Chill

[WS Grave]

OK, but I want to create a report for past months. How do I approach that data? Do I have to import the month data in Excel, and then what...!?

[Chill]

That's nice, but I want to create a report for past months. How do I approach that data?

This is what I meant. If you take rain0-day1 you'll have the data for all time related to rain.

You can extract the data you need from here. Isn't it?

Chill

[WS Grave]

Oh you're right
I hadn't seen the content of those files until now.
Still a newby here ;)

So you import that and the other files into Excel and then call them into a table?

[Chill]

That's it!

When I have imported data into Excel sheet, I work with this info in Excel properly, not into a table. But once you have the data, you can work with it at your best way...

Chill