retepsnikrep wrote:One issue i haven't tackled is that PLX-DAQ only supports 26 columns so we might have to use two rows per cycle for 50 cells worth of data.
Thinking about this problem and one solution is that you could combine the byte data from each cell into word data. So cell 1 is the low bit of word one and cell 2 is the high bit of word 1. Cell 3 is the low bit of word 2 and cell 4 is the high bit of word 2, etc. Transmit the word data to the spreadsheet and then calculate the raw cell data. So for example if cell one is 3.35 volts the bms raw data would be 160 (335-175) and if cell 2 was 2.80 volts the raw data value would be 105. Expressed as a hex value 160 = A0h and 105 = 69h. So you send A069h (which in decimal is 41,065). In theory you can combine 3 or 4 cells this way although that might not be as straight forward with the pic. I can work on the spreadsheet formula for this if you want to pursue it.
The other option is to not use PLX-DAQ. Instead capture the data using hyperterminal to save it to a file and open after in a spreadsheet. Of course you lose out on live data capture, but are only limited by the spreadsheets capabilities.