Page 1 of 1

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

Posted: Wed Nov 25, 2009 2:46 pm
by 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.

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

Posted: Mon Nov 30, 2009 10:23 am
by 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

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

Posted: Thu Dec 03, 2009 10:13 am
by 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...!?

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

Posted: Thu Dec 03, 2009 11:28 am
by Chill
WS Grave wrote: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

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

Posted: Fri Dec 04, 2009 5:20 pm
by WS Grave
Oh you're right :blush:
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?

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

Posted: Fri Dec 04, 2009 5:53 pm
by 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