James,
I thought I should move this to it’s own topic.
Connected and logging with my Droid phone, I noticed a couple issues:
1. The “Time” field was always coming out with numbers ####.### which you said was “seconds since the meter was powered on” unless the clock has been set. Then you told me the iOS devices auto sync the clock with the phone. So, I had a friend with an iPhone connect to my Mooshimeter and sure enough, my clock is set now. I’ll patiently await the droid update for clock sync.
2. You said this would be UTC time. But, that didn’t address the format of the time. The time the mooshi puts into the log files is actually “UNIX EPOCH” time (aka: seconds elapsed since 00:00:00 on 1/1/1970 GMT). To that end, users will need the following formula to convert this Epoch time back to their time zone. This example converts to EST (GMT-5):
=(((A2/60)/60)/24)+DATE(1970,1,1)+(-5/24)
the -5 is for EST, adjust as required for your time zone. Then set the Excel cell format to date/time.
3. Since connecting to the iOS to set the clock, I connected to my droid & setup to performed a 10min LOG (max interval) of a DC battery just to test. What came out was 30 log files, 3 per minute, each log contains 1 reading. I don’t understand why? Earlier tests produced 1 log file with hundreds of readings in the same file. What am I doing wrong?
Thanks again for all your hard work!
Matt