Author Topic: Spreadsheet data manipulation - Here's a macro for parsing LIVE output files  (Read 960 times)

ClassicCrazy

  • Hero Member
  • *****
  • Posts: 2670
Re: Spreadsheet data manipulation - Here's a macro for parsing LIVE output files
« Reply #15 on: September 24, 2020, 08:44:14 PM »
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
« Last Edit: September 24, 2020, 08:45:58 PM by ClassicCrazy »
system one
Classic 150 , 5s4p  Kyocera 135watt , 12s Soneil 2v 540amp lead crystal for 24v pack , Outback 3524 inverter
system two
Classic 150 ,5s 135 watt Kyocero , 16s Calb 100AH LiFePO4 , Outback VFX 3648 inverter
system three
Midnite KID MPPT 24 DC in to  12 volt AGM batterie