Spreadsheet data manipulation - Here's a macro for parsing LIVE output files

Started by 5 Minutes 2 Midnite, July 27, 2020, 01:12:36 AM

Previous topic - Next topic

ClassicCrazy

Quote from: dRdoS7 on September 24, 2020, 01:22:34 AM
Hi,

I love Macros!

I manually export values from my Classic to OpenOffice spreadsheets.

How do you get the data automatically?

I have a Classic 200 connected to a Windows PC. I use Local App for monitoring, and export data from that on the PC. Very labour intensive.

Thanks,

dRdoS7.

EDIT: Just re-read your first post (which naturally I skimmed first time ::) ), it seems your're doing the same as me. For some reason I though it was automatic.

If you use Raspberry Pi to collect the data in MQTT you can send it to where ever you want , one way is using something like node red or other ways I don't know about but maybe you do. Look in opensource software section of the forums here . Here is one link but there are more in the opensource section too.
http://midniteftp.com/forum/index.php?topic=4849.0

Larry
system 1
Classic 150 , 5s3p  Kyocera 135watt , 12s Soneil 2v 540amp lead crystal for 24v pack , Outback 3524 inverter
system 2
 5s 135w Kyocero , 3s3p 270w Kyocera  to Classic 150 ,   8s Kyocera 225w to Hawkes Bay Jakiper 48v 15kwh LiFePO4 , Outback VFX 3648 inverter
system 3
KID / Brat portable