search

baronbrew / TILTpi

Baron Brew Equipment Official Tilt app for Raspberry Pi
62 stars 18 forks source link

What are Timepoints #26

Closed myoung34 closed 4 years ago

myoung34 commented 4 years ago

In the Help tab of the spreadsheet:

  1. Number format in the "Timepoint" column must be a decimal number for the chart to plot properly.

What exactly is a timepoint? (Or how do i generate a valid one)

Im looking to programmatically generate one and all data including the timestamp, but I've never seen this format before.

For reference: https://github.com/myoung34/tilty/pull/24/files#diff-3a8777aa9aa17e5ffb6bac4eaf69b2f1R74

noahbaron commented 4 years ago

It’s the numerical representation of date/time which Google Sheets and Excel uses for calculations and graphing. To get a better idea how it works, If you change the Timepoint column’s number format to a date format, it will display the date properly. To generate this number I added the time zone offset of the device to the JavaScript (UTC) time. I also converted from milliseconds to days and adjusted for the epoch Jan 1, 1970 to Jan 1, 1900

On Fri, Aug 14, 2020 at 5:55 PM myoung34 notifications@github.com wrote:

In the Help tab of the spreadsheet:

  1. Number format in the "Timepoint" column must be a decimal number for the chart to plot properly.

What exactly is a timepoint?

Im looking to programmatically generate one and all data including the timestamp, but I've never seen this format before

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/baronbrew/TILTpi/issues/26, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAQ3FBI2NFHFWVOSPXK4U3TSAXMIVANCNFSM4P77TJJA .