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.
Thanks for this, RH,
I will look into it right away.
-A
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?
Hi John, did you just notice this? I did a check a few (3?) days ago and got and up to date response...
Eric
Quote from: Westbranch 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
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?
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.
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.