Data Logging
Posted: Mon Sep 07, 2009 5:55 pm
Got Data Logging directly to an Excel Spreadsheet working now over remote link.
You need Microsoft Excel installed. You also need the PLX-DAQ installed from here. http://www.parallax.com/Portals/0/Downl ... nstall.zip
You need the Pixcaxe USB programming lead from the remote to your PC.
This modified Excel spreadsheet logs all the data into simple columns.
www.solarvan.co.uk/bms/EXCELBMS.xls
This example from a few minutes charging of my own car shows the data.
www.solarvan.co.uk/bms/EXCELBMSEXAMPLE.xls
You can see at 18:43:41 I turned on the charger and then current tailed off within seconds as voltage rose as battery was charged anyway.
Edit
Here is the working remote display code for the Picaxe 08M for the above data logging.
www.solarvan.co.uk/bms/RemoteDisplay100909_v16.txt
The below version of the Master also works better at 8mhz in conjunction with the above. My display also works properly when cold without fiddling with the resonator/crystal. The long term data is also written to eeprom once every ten sconds instead of once a minute as before.
www.solarvan.co.uk/bms/MASTER_8mhz_1209 ... 00BAUD.txt
You need Microsoft Excel installed. You also need the PLX-DAQ installed from here. http://www.parallax.com/Portals/0/Downl ... nstall.zip
You need the Pixcaxe USB programming lead from the remote to your PC.
This modified Excel spreadsheet logs all the data into simple columns.
www.solarvan.co.uk/bms/EXCELBMS.xls
This example from a few minutes charging of my own car shows the data.
www.solarvan.co.uk/bms/EXCELBMSEXAMPLE.xls
You can see at 18:43:41 I turned on the charger and then current tailed off within seconds as voltage rose as battery was charged anyway.
Edit
Here is the working remote display code for the Picaxe 08M for the above data logging.
www.solarvan.co.uk/bms/RemoteDisplay100909_v16.txt
The below version of the Master also works better at 8mhz in conjunction with the above. My display also works properly when cold without fiddling with the resonator/crystal. The long term data is also written to eeprom once every ten sconds instead of once a minute as before.
www.solarvan.co.uk/bms/MASTER_8mhz_1209 ... 00BAUD.txt