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
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