csv logfile to spreadsheet and calculate AHrs

[commanda]

I briefly explained how to do this for somebody on here a while back. So here's an actual example.

In this recent post, I gave a bash script for logging data to a csv file. I imported todays data into an OpenOffice spreadsheet, and added columns with formulas to calculate todays AHrs generated.

20090414.ods

Column G calculates the minutes between the last 2 readings, and column H calculates the AHrs for that time period by taking the average of the amps at the start and end of the period.

H106 sums the total AHrs.

Amanda

[gizmo]

Maybe you should have posted a Microsoft Excel format file. Open Office is brilliant, I use it and once tried to get my workplace to take it on board instead of upgrading to Office 2007. Didnt happen, the accounts girls didnt like the change, and it has poor support for common database files. Fact is, most people use Microsoft office, and wont be able to open that ods file. In Open office you can save as a Excel file, and then both Open Office and Microsoft Excel users can open it.

Glenn

http://www.openoffice.org/ if anyone is interrested, its free and pretty darn good.

[commanda]

I have managed to get OOO in use at work for most things, but some of the more complex stuff (BIG design spreadsheet) just won't quite work. Last Friday I found the boss doing a headcount to buy licences for M$ Office, at AU$1K each. Guess I can forget getting another bonus anytime soon.

I'll see how it goes exporting to Excel format.

Amanda

[commanda]

14K in OpenOffice format, or 129K in Excel 95 format.

http://www.otherpower.com/images/scimages/2006/20090414.xls