Topic | data logging Can anyone help me

Home Forums Mooshimeter Support data logging Can anyone help me

  • This topic has 0 replies, 2 voices, and was last updated 4 years ago by Anonymous.
Viewing 5 reply threads
  • Author
    Posts
    • #19941 Reply
      joe
      Guest

      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-02

      Other 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.

    • #19942 Reply
      Anonymous
      Guest

      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 places

    • #19943 Reply
      Anonymous
      Inactive

      We 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.

    • #19945 Reply
      Anonymous
      Guest

      Your example data translates to this:
      https://coremx.net/mooshimeter_log_viewer/?1539616644

      Q: 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.com

      Q: 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.

    • #19946 Reply
      Anonymous
      Inactive

      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.

    • #20033 Reply
      Anonymous
      Guest

      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

Viewing 5 reply threads
Reply To: data logging Can anyone help me
Your information:




This site is protected by reCaptcha and the Google Privacy Policy and Terms of Service apply.