- This topic has 0 replies, 2 voices, and was last updated 4 years, 3 months ago by
.
- Posts
open test Mooshimeter V.1-Log1-20181004_2042 (1) file,
this is a test log of my 120 volt outlet, this test was for a few minutes on a logging interval of max and be at 122.***volts ac.
this is just part of the file that my Microsoft Excel software open in windows 10.I need to see the time and voltage.
At this time I don’t care about the amps.
PCB: 008
ASM: 000
LOT: 00000
FW: 1477971088
CH1: AMPS 10A
CH2: VOLT 600V
SMPL: 0256 4000Hz
UTC TIME SEC CH1 AMPS AC CH2 VOLT AC
1538703591 7.86E-04 4.89E-02
1538703591 8.49E-04 4.10E-02
1538703592 8.32E-04 4.14E-02
1538703592 8.90E-04 3.52E-02
1538703592 7.46E-04 3.99E-02
1538703593 9.30E-04 4.20E-02
1538703593 8.61E-04 3.89E-02
1538703593 7.63E-04 5.02E-02
1538703594 8.22E-04 4.33E-02
1538703594 8.37E-04 4.49E-02Other questions:
In the mooshimeter how is the time reffenced?
Is the time adjustable or able to be zero-ed or is it zero-ed at each log event?
Is there a date and time stamp in the log?
Can you start a data logging event on a day in a electrical box and leave it there recording for days and collect it later to upload and view?
How is a logging event started and stopped?Example: With a smart phone connect the Mooshimeter to a electrical connection in a electric box, then enable the logging and turn off my smart phone connect to the Mooshimeter and leave it there for 24 to 48 hours come back, connect with my smart phone and then disable the logging event to stop the log event.
Do I have a log event?
upload that data log and view?Then once I know how to open the file with proper application I need to see the data in a standard time format and standard voltage format, later one day a standard current format.
Here are my notes.
You need to add some formulas to make the time and measurements show properly.
http://www.epochconverter.com/
Mooshimeter Graph Info
Excel Formula for Unix Time “=A2/86400+25569”
Then Format Time as Custom ss.0
Then Format Voltage as Number with 2 decimal placesWe most likely have answers to all of the questions above in this wiki:
https://moosh.im/wiki/index.php/Main_Page
It seems that joe had started logging before sticking probes to the outlet and that is why it does not show line voltage at first ~3 seconds of log.
Your example data translates to this:
https://coremx.net/mooshimeter_log_viewer/?1539616644Q: In the mooshimeter how is the time reffenced?
A: As a epoch or unix time stamp. From the first logged line in your example “1538703591”. In short is the number of seconds that have elapsed since January 1, 1970 (midnight UTC/GMT). You can decode it directly here > https://www.epochconverter.comQ: Is the time adjustable or able to be zero-ed or is it zero-ed at each log event?
A: No. The number of seconds from 1970-01-01 00:00:00 isn’t retractable. But you can always count the first logget sample as “point zero” in time and work from there.Q: Is there a date and time stamp in the log?
A: Yes. First and last time stamp.Q: Can you start a data logging event on a day in a electrical box and leave it there recording for days and collect it later to upload and view?
A: Yes.Q: How is a logging event started and stopped?
A: By connecting the meter to a smartphone/tablet and start the logging- and later, reconnecting it and stop the logging. The smartphone/tablet does not have to be connected during the logging.To see the data in “standard time”, with a “human readable” format, you can convert the data in (for example) MS-Excel, or write some kind of script like the one i’m pointing to at the beginning of this answer; where i simply upload the log files- or copy/paste the data into a text-field.
I’m also the username “A User”. But now i remembered my user name / password here. I misread the question “is there a date and time stamp in the log”, and here’s a better answer.
Q: Is there a date and time stamp in the log?
A: Yes. Every epoch / unix time stamp are convertible to date and time in “any format”. Converting the timestamp from the first and last sample, will also give you the start and end time of the log.In Excel, if your timestamp column is at A, then prepare a new column for this formula:
=(A1/86400)+DATE(1970,1,1)+TIME(8,0,0)The
+TIME(8,0,0)is for my particular GMT+8 timezone in asia, adjust it to your own if you like, or omit the whole thing for UTC.Then format the new column as a Date. I chose Custom with this format string:
yyyy-mm-dd hh:mm:ss
