Any Excel spreadsheets or external program that reads EG4 Monitor raw data?

[macdaman]

Has anyone come across something that will read in exported EG4 Monitor data and kick out additional charts, graphs, etc..?? Excel spreadsheet or external program?

I don't have anything pressing ATM but recently, I was wanting to track TRADIATOR values over several days. Looking through the headers, I could see an interest one might have in looking at other numbers over a period of time.

I searched here for things like EXCEL, EG4, MONITOR, CHART, etc. but didn't see anything on point. Only data on the EG4 monitor software as well as Solar Assistant.

 

[TM48]

What's wrong with Solar Assistant?

 

[macdaman]

What's wrong with Solar Assistant?

Does it track TINNER and all three TRADIATOR values? I've watched a few videos and did a few searches and I can only find "Inverter temperature" which I'm assuming might be TRADIATOR2. Does it track all roughly 100 variables? Can I graph or chart by selectable variables such as day, week, month, year, winter, summer, monday, tuesday, etc..?

My research on using both Monitor and Solar Assistant indicates the few people I can find that do it complain that one or the other freezes periodically. Some say they haven't been able to make them co-exist. I'm sure smarter people than I have figured it out.

 

[TM48]

I've not have had any problems with freezing but it doesn't (yet) track everything I would like. I have three batteries but it only shows the two directly connected to the inverters with the third bat approximately split between the two. Also it doesn't show the min/max cell voltages either.

 

[macdaman]

I've not have had any problems with freezing but it doesn't (yet) track everything I would like. I have three batteries but it only shows the two directly connected to the inverters with the third bat approximately split between the two. Also it doesn't show the min/max cell voltages either.

If you don't mind me asking, are you using both monitor and SA? Did you use any particular resources (videos, step through guides) to get it up and running with both? I want to keep using monitor but would love to add SA to the mix.

 

[TM48]

No I don't normally use the EG4 website. However I have and never experienced a problem. The Pi you use to run SA can play a role in whether you do. I'm running it on a Pi 4 that I already owned. I wouldn't run it on anything less. If buying new I'd elect the Pi5. Also something which may be important is the Pi is connected to my network though ethernet not WiFi.