<div dir="ltr">I would run MySQL on my computer and write a python script to import the data to MySQL, and use a front end package to graph the data - it's pretty easy to do.<div>If that's more than you can handle, go to Guru.com and setup an account, describe what yo uwant done, and there's plenty of willing takers that will write the code to do it nicely.</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Aug 7, 2017 at 3:15 PM, Dan Fink <span dir="ltr"><<a href="mailto:danbob88@gmail.com" target="_blank">danbob88@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><br></div>Hi Mac -- yep, at about 50k data points Excel seizes up no matter how fast your computer. You really need to use a database program after that point.<div>I had a friend arrange a web API into MySQL on our server and it works fine.<span class="HOEnZb"><font color="#888888"><br></font></span><div class="gmail_extra"><span class="HOEnZb"><font color="#888888"><br clear="all"><div><div class="m_3448869945739592771gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><span style="font-size:12.8000001907349px">Dan Fink</span><div style="font-size:12.8000001907349px">Professor of Solar Energy Technology, Ecotech Institute</div><div style="font-size:12.8000001907349px">IREC Certified Instructor™ for: </div><div style="font-size:12.8000001907349px">~ PV Installation Professional</div><div style="font-size:12.8000001907349px">~ Small Wind Installer</div><div style="font-size:12.8000001907349px">Executive Director, Buckville Energy</div><div style="font-size:12.8000001907349px">NABCEP Registered Continuing Education Providers™<br><a href="tel:970.672.4342" value="+19706724342" style="color:rgb(17,85,204)" target="_blank">970.672.4342</a></div><br> </div></div></div></div></div></div></div></div></div></div></div></div></font></span><div><div class="h5">
<br><div class="gmail_quote">On Mon, Aug 7, 2017 at 9:17 AM, Mac Lewis <span dir="ltr"><<a href="mailto:maclewis1@gmail.com" target="_blank">maclewis1@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi Wrenches,<div><br></div><div>I am getting more and more zipped up SD card data emailed from clients from their Outback Mate 3s, Sunny Islands and other systems that we have out there. The data can be very laborious to process and will crash Excel most of the time because of the sheer quantity of data. Also oftentimes, you need to merge these data sets to get a true picture of how these power systems are functioning. </div><div><br></div><div>Do you have recommendations for 3rd party programs to help process and analyse this data? I am looking closely at WattPlot SunMate to use with the Outback stuff. Maybe there is a better way? I'm interested in any feedback about WattPlot products in general as well.</div><div><br></div><div>Thanks in advance<span class="m_3448869945739592771HOEnZb"><font color="#888888"><br clear="all"><div><br></div>-- <br><div class="m_3448869945739592771m_3660933655801708231gmail_signature" data-smartmail="gmail_signature"><div><br></div><div><font color="#305A78" face="'times new roman', serif"><br></font></div><div><br></div>Mac Lewis<br><br><span style="font-family:'Times New Roman';font-size:medium;color:rgb(255,153,0)"><b><font face="Arial, Helvetica, sans-serif" size="3"><p align="left"><font color="#000000" face="Verdana, Arial, Helvetica, sans-serif"><span style="font-size:small"><span style="font-family:arial;font-weight:normal;color:rgb(48,90,120)"><font face="'times new roman', serif">"Yo solo sé que no sé nada." </font><span style="font-weight:700;color:rgb(104,104,104)"><font face="'times new roman', serif">-Sócrates</font></span></span></span></font></p></font></b></span></div>
</font></span></div></div>
</blockquote></div><br></div></div></div></div></div>
<br>______________________________<wbr>_________________<br>
List sponsored by Redwood Alliance<br>
<br>
List Address: <a href="mailto:RE-wrenches@lists.re-wrenches.org">RE-wrenches@lists.re-wrenches.<wbr>org</a><br>
<br>
Change listserver email address & settings:<br>
<a href="http://lists.re-wrenches.org/options.cgi/re-wrenches-re-wrenches.org" rel="noreferrer" target="_blank">http://lists.re-wrenches.org/<wbr>options.cgi/re-wrenches-re-<wbr>wrenches.org</a><br>
<br>
List-Archive: <a href="http://www.mail-archive.com/re-wrenches@lists.re-wrenches.org/maillist.html" rel="noreferrer" target="_blank">http://www.mail-archive.com/<wbr>re-wrenches@lists.re-wrenches.<wbr>org/maillist.html</a><br>
<br>
List rules & etiquette:<br>
<a href="http://www.re-wrenches.org/etiquette.htm" rel="noreferrer" target="_blank">www.re-wrenches.org/etiquette.<wbr>htm</a><br>
<br>
Check out or update participant bios:<br>
<a href="http://www.members.re-wrenches.org" rel="noreferrer" target="_blank">www.members.re-wrenches.org</a><br>
<br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr">Chris Mason<div><div style="color:rgb(136,136,136)"><span style="font-size:13px">NABCEP Certified Solar PV Installer™</span></div><div style="color:rgb(136,136,136)"><span style="color:rgb(34,34,34)">Solar Design Engineer</span></div><div style="color:rgb(136,136,136)"><span style="font-size:13px">Generac Generators Industrial technician</span></div></div><div style="color:rgb(136,136,136)"><span style="font-size:13px"><br></span></div><div><a href="http://www.cometenergysystems.com" target="_blank">www.cometsolar.com</a></div><div>264.235.5670</div><div>869.662.5670</div><div>Skype: netconcepts</div></div></div>
</div>