Author Topic: Errors in CSV output from Local App  (Read 2293 times)

Resthome

  • Hero Member
  • *****
  • Posts: 1173
Errors in CSV output from Local App
« on: March 16, 2015, 06:47:05 PM »
This has been there for a long time but decided to at least post it just in case Andrew know how to fix it so I don't have to keep fixing the Excel spreadsheets.


There are a couple of errors in the way the time formulas are presented in column A by the LA. Could be cause by the way Excel converts the CSV file. Haven't look at it that close. But the end result is the following.

The first error is a bad formula in A4

 =(B5/1000 +$B$2*60*60)/86400 + 25569

 The correct formula is

 =(B4/1000 + $B$2*60*60)/86400 + 25569

All formulas is column A are off by one row and you need to replicate the corrected A4 down through all cells in column A that have data. Doing this will get rid of a second error that occurs further down is column A. I’m not sure it occurs in the same place but the above formula will start over again with B5. In the case I’m looking at now this occurred in cell A12801. You will see it if you are looking at the time in column A and have change the cells to represent TIME because the time will most likely jump from PM back to AM if you were collecting data from the morning until the evening.

Too large a file or I would post the raw data for a day.
John

10 x Kyocera KC140, Classic 150 w/WBJr, Link10 Battery Monitor, 850 AH @ 12v Solar One 2v cells, Xantrex PROwatt SW2000
Off Grid on Houseboat Lake Don Pedro, CA

atop8918

  • Moderator
  • Sr. Member
  • *****
  • Posts: 479
Re: Errors in CSV output from Local App
« Reply #1 on: March 17, 2015, 03:49:17 AM »
Thanks for this, RH,
I will look into it right away.

-A

Resthome

  • Hero Member
  • *****
  • Posts: 1173
Re: Errors in CSV output from Local App
« Reply #2 on: August 06, 2015, 03:11:39 AM »
Looks like we got a new Local App 0.3.66 but this bug is still there. What was the changes to 0.3.66?
John

10 x Kyocera KC140, Classic 150 w/WBJr, Link10 Battery Monitor, 850 AH @ 12v Solar One 2v cells, Xantrex PROwatt SW2000
Off Grid on Houseboat Lake Don Pedro, CA

Westbranch

  • Hero Member
  • *****
  • Posts: 2788
  • Building System (sort of) 1 weekend at a time
Re: Errors in CSV output from Local App
« Reply #3 on: August 06, 2015, 11:22:04 AM »
Hi John, did you just notice this?  I did a check a few (3?) days ago and got and up to date response...

Eric
KID FW1811 560W >C&D 24V 900Ah AGM
CL150 29032 FW V.2126-NW2097-GP2133 175A E-Panel WBjr, 3Px4s 140W > 24V 900Ah AGM,
2 Cisco WRT54GL i/c DD-WRT Rtr, NetGr DS104Hub
Cotek ST1500 Inv  want a 24V  ROSIE Inverter
OmniCharge3024  Eu1/2/3000iGens
West Chilcotin 1680+W to come

Resthome

  • Hero Member
  • *****
  • Posts: 1173
Re: Errors in CSV output from Local App
« Reply #4 on: August 06, 2015, 12:03:56 PM »
Hi John, did you just notice this?  I did a check a few (3?) days ago and got and up to date response...

Eric

Eric,  I just updated to Windows 10 before we left for the lake and was checking all the apps and the Local App got an update to 0.3.66 the Win 7 Local App was at 0.3.65.  I may have missed this update because i usually turn off checking for updates because we have very spotty internet connects at the lake. I though it was strange Andrew never post anything about an update maybe 0.3.66 is an older version that i just never got.

What version do you have?

 
John

10 x Kyocera KC140, Classic 150 w/WBJr, Link10 Battery Monitor, 850 AH @ 12v Solar One 2v cells, Xantrex PROwatt SW2000
Off Grid on Houseboat Lake Don Pedro, CA

Westbranch

  • Hero Member
  • *****
  • Posts: 2788
  • Building System (sort of) 1 weekend at a time
Re: Errors in CSV output from Local App
« Reply #5 on: August 06, 2015, 01:43:44 PM »
we head out tomorrow, so I will see what happens but the latest version on my newly W7 'ed old laptop (done 2 weeks ago) is 0.3.66 so it has been at least 2 weeks. 

Will check the other laptops later and advise if they are older but I did an auto update on it ~ a month ago.
KID FW1811 560W >C&D 24V 900Ah AGM
CL150 29032 FW V.2126-NW2097-GP2133 175A E-Panel WBjr, 3Px4s 140W > 24V 900Ah AGM,
2 Cisco WRT54GL i/c DD-WRT Rtr, NetGr DS104Hub
Cotek ST1500 Inv  want a 24V  ROSIE Inverter
OmniCharge3024  Eu1/2/3000iGens
West Chilcotin 1680+W to come

clint7434

  • Newby
  • *
  • Posts: 5
Re: Errors in CSV output from Local App
« Reply #6 on: August 12, 2021, 02:36:29 PM »
So, here we are in 2021, and this error is still in place.  It looks like no one has come close to trying to fix it.  And it is a very easy fix.