DIR Return Create A Forum - Home
       ---------------------------------------------------------
       Blacraft
  HTML https://blacraft.createaforum.com
       ---------------------------------------------------------
       *****************************************************
   DIR Return to: Blacraft General
       *****************************************************
       #Post#: 3632--------------------------------------------------
       Blacraft Playtime Community Contribution
       By: Bla Date: November 26, 2015, 4:43 pm
       ---------------------------------------------------------
       To participate:
       - Let me know your email so I can add you as contributor to the
       sheet
       - Get OnTime raw data files from:
  HTML https://www.dropbox.com/sh/3gllpvcnicjew2e/AADtzrK0VBKVWxLRQgmg8RRwa?dl=0
       - Go to the data sheet to contribute:
  HTML https://docs.google.com/spreadsheets/d/1Vr4SD-mcKAZeqJN6EO4JugNY1nnhvMm9w5_vjiH1GDk/edit#gid=302314035&vpid=C3
       Method:
       - Every new day is added as a column to the left.
       - Every user is a row - if a new player appears in OnTime files,
       they should be added at the bottom, and Bla should be notified
       to move the player into alphabetic ordering without breaking the
       sheet.
       - Each cell shows the number of seconds the player (row) was
       online that day (column).
       - Note only the daily reports should be used. They're mixed with
       weekly and monthly reports too in the data files.
       - The number at the top of a column is the total amount of time
       online by players that day. And the very first column shows
       total time a player has been online. These cells use a formula.
       - The data is listed in seconds, minutes and hours. The sheet
       has m defined as 60 and h defined as 3600 so to save speed and
       for easier verification you may write =1*h+43*m in a cell if
       someone was online for 1 hour and 43 minutes that day.
       Dates cumulative/percentage sheets: These use formulae for all
       the cells. If you want to update them, add more rows/columns
       like above and just make sure to repeat the formulae to the new
       cells.
       Please report here if you update the sheet, need help or more
       files.
       *****************************************************