Google REM Data Archive (9.12~ JP + Heroes & Batman Collab now open)

Discussion in 'Rants and Accomplishments' started by sunglassesmichael, Oct 17, 2014.

  1. sunglassesmichael

    sunglassesmichael Ruka button is OP

    Messages:
    31,863
    Likes Received:
    3,721
    Joined:
    Jul 11, 2013
    User ID:
    NA: 371,153,246
    PADherder:
    link
    Alright, buzzy told me to do this a while ago so now I'm finally getting to it.

    This thread will be the place to find links to all the Google data we've put together on REM rates for past festivals, special Galas and special REMs.

    The link in the old results threads should always take you to the most recent sheet, so here I will keep direct links to previous sheets.

    I will include the events for which I managed the sheet and I will add the events managed by the originators of the Google doc as well.

    Currently Open Events

    2015.9.12~ Japanese 1 & Heroes

    2015.9.7 ~ 9.21 Batman Collab 2 REM (Harley Quinn Debut)



    @Verrous@PF developed a script for converting data entered into the Google sheet into pretty format for posting in the the results thread!


    Posting a Pre-Formatted Roll Table


    If you're interested in posting a graphical table of your rolls from the REM or Collab machine in one of the R&A threads you can use my script to help.

    Steps:



      • Copy your data from the spreadsheet (Copy from your username through the comments.)
      • Paste it into the text area in the script page here
      • Press the button, your table will be generated and selected for you.
      • Copy the text.
      • Paste it into the posting field for the proper R&A thread.
    Have fun!



    Some tips:



      • A single 1 in the comment field or the word "new" placed anywhere in the comment field will tell the script that the roll was a new one for you.
      • You can use the checkboxes and fields in the options area to customize your display.
      • I did not make this script super robust. It was my first foray into Javascript. If you try very hard to break it you will, but give it proper data and it should work. If you have ideas for improvements please let me know.
     
    Last edited: Sep 11, 2015
    Phavin, 0never, pidimension and 3 others like this.
  2. sunglassesmichael

    sunglassesmichael Ruka button is OP

    Messages:
    31,863
    Likes Received:
    3,721
    Joined:
    Jul 11, 2013
    User ID:
    NA: 371,153,246
    PADherder:
    link
    RE: Google REM Data Collection Thread

    New Godfest Results Docs
    2015.7.1~ Japanese 1 & Egyptian 2
    2015.6.30~ Greek 1 & 5 Elements
    2015.6.14~ Indian 1 & Indian 2 (Gadius, Typhon, Ilm & Zuoh debut)
    2015.6.13~ Egyptian 1 & Norse (Gadius, Typhon, Ilm & Zuoh debut)
    2015.5.31~ Players' Choice
    2015.5.16~ 3 Kingdoms & Egyptian 1
    2015.5.15~ Heroes & Japanese 2
    2015.5.1~ 5 Elements & Indian 2
    2015.4.30~ Greek 1 & Greek 2
    2015.4.18~ Angels 1 & Angels 2
    2015.4.17~ Demons & 3 Kingdoms
    2015.4.1~ Egyptian 2 & Angels 2 (Famiel, Ariel, Lumiel, etc. Debut)
    2015.3.31~ Egyptian 1 & Angels 2 (Famiel, Ariel, Lumiel, etc. Debut)
    2015.3.14~ Japanese 1, Japanese 2 & Heroes
    2015.2.28~ Indian 1 & Indian 2
    2015.2.18~ 5 Elements & Norse
    2015.1.30~ Demons & 3 Kingdoms (First fest with Armored Knights)
    2015.1.16~ Greek 1 & Angels
    2015.1.2~ New Year's Day 3 - Egyptian 1 & Egyptian 2 (Norns Debut)
    2015.1.1~ New Year's Day 2 - Norse & Heroes (Norns Debut)
    2014.12.31~ New Year's Day 1 - Japanese 1 & 2
    2014.12.13~ Indian 1, Greek 2 & Egyptian 2 (Debut)
    2014.11.29~ Players' Choice
    2014.11.15~ Heroes, 3 Kingdoms & Indian 2 (Kali Debut)
    2014.10.30~ Norse, Angels & 5 Elements
    2014.10.18~ Egyptian, Greek 2 & Demons (Apocalypse Debut)
    2014.10.1~ Japanse 1, Indian 1 & Indian 2 (Debut)
    2014.9.12~ Greek 1 & Japanese
    2014.8.30~ Norse & Angels
    2014.8.16~ Indian 1 & Japanese 2
    2014.7.31~ Greek 1 & Greek 2
    2014.7.13~ 5 Elements & Heroes (ZGL Debut?)
    2014.6.30~ Japanese 1 & Egyptian
    2014.6.14~ 3 Kingdoms, Angels & Demons
    2014.5.31~ Players' Choice Festival
    2014.5.16~ Japanese 2 & Indian 1
     
    Last edited: Nov 8, 2015
  3. sunglassesmichael

    sunglassesmichael Ruka button is OP

    Messages:
    31,863
    Likes Received:
    3,721
    Joined:
    Jul 11, 2013
    User ID:
    NA: 371,153,246
    PADherder:
    link
  4. 1835831108

    1835831108 Ult Pandora <3

    Messages:
    6,033
    Likes Received:
    342
    Joined:
    Feb 7, 2014
    User ID:
    All threes (333,333,333)
    PADherder:
    link
    RE: Google REM Data Collection Thread

    Tomorrow is not 10/1
     
  5. sunglassesmichael

    sunglassesmichael Ruka button is OP

    Messages:
    31,863
    Likes Received:
    3,721
    Joined:
    Jul 11, 2013
    User ID:
    NA: 371,153,246
    PADherder:
    link
    RE: Google REM Data Collection Thread

    You're right.

    But the first link isn't for the one starting in 3 hours. It's for the last completed one. :p


    (Or it wasn't for the upcoming one when you replied, anyway.)
     
  6. sunglassesmichael

    sunglassesmichael Ruka button is OP

    Messages:
    31,863
    Likes Received:
    3,721
    Joined:
    Jul 11, 2013
    User ID:
    NA: 371,153,246
    PADherder:
    link
    RE: Google REM Data Collection Thread

    Changed 2014.10.18 Egyptian, Greek 2 & Demons link to permanent link.

    Added temporary link for 2014.10.22~ Pink REM event #5
     
  7. buzzyrecky

    buzzyrecky Okuni's #1 bae Card Creation Winner

    Messages:
    15,197
    Likes Received:
    4,429
    Joined:
    Sep 28, 2013
    User ID:
    367,972,248
    PADherder:
    link
    RE: Google REM Data Collection Thread

    dammit, i didnt keep track of my rolls for the pink rem... my bad

    it was only 2 valks out of 77 rolls though so it probably wouldve ruined the rates :p
     
  8. sunglassesmichael

    sunglassesmichael Ruka button is OP

    Messages:
    31,863
    Likes Received:
    3,721
    Joined:
    Jul 11, 2013
    User ID:
    NA: 371,153,246
    PADherder:
    link
    RE: Google REM Data Collection Thread

    Are you talking about the previous event, I guess?

    It shows 117 entries for you entered to the sheet.
     
  9. buzzyrecky

    buzzyrecky Okuni's #1 bae Card Creation Winner

    Messages:
    15,197
    Likes Received:
    4,429
    Joined:
    Sep 28, 2013
    User ID:
    367,972,248
    PADherder:
    link
    RE: Google REM Data Collection Thread

    nah i rolled 77 times this event

    previous events missing some last minute rolls i did too, though
     
  10. sunglassesmichael

    sunglassesmichael Ruka button is OP

    Messages:
    31,863
    Likes Received:
    3,721
    Joined:
    Jul 11, 2013
    User ID:
    NA: 371,153,246
    PADherder:
    link
    RE: Google REM Data Collection Thread

    I was confused because PDX had the REM going live hours later.

    Did it start right from midnight?
     
  11. DogFest

    DogFest Hound Egg Machine

    Messages:
    795
    Likes Received:
    68
    Joined:
    Sep 12, 2014
    RE: Google REM Data Collection Thread

    Is it still ok to post results of previous Godfests in their respective sheets? I only posted on the last one but I remember my rolls from the ones that came before.
     
  12. sunglassesmichael

    sunglassesmichael Ruka button is OP

    Messages:
    31,863
    Likes Received:
    3,721
    Joined:
    Jul 11, 2013
    User ID:
    NA: 371,153,246
    PADherder:
    link
    RE: Google REM Data Collection Thread

    The past sheets are locked, but if you tell me which one you want to post in I can unlock it for you.
     
  13. DogFest

    DogFest Hound Egg Machine

    Messages:
    795
    Likes Received:
    68
    Joined:
    Sep 12, 2014
    RE: Google REM Data Collection Thread

    I could post my results of the Jp2/Greeks and Indian1-2/Jp1 GodFests and the Player's Choice Carnival, if it's too much of a hassle there's no problem though, it's not like 5 rolls worth of data would change much.
     
  14. sunglassesmichael

    sunglassesmichael Ruka button is OP

    Messages:
    31,863
    Likes Received:
    3,721
    Joined:
    Jul 11, 2013
    User ID:
    NA: 371,153,246
    PADherder:
    link
    RE: Google REM Data Collection Thread

    No. It's no problem. If you're ready I'll unlock them and you can post your rolls. :)
     
  15. DogFest

    DogFest Hound Egg Machine

    Messages:
    795
    Likes Received:
    68
    Joined:
    Sep 12, 2014
    RE: Google REM Data Collection Thread

    I'm ready, bring it!

    Edit: Just realized I already posted my results for the PC Carnival, so no need to unlock that one.
     
  16. sunglassesmichael

    sunglassesmichael Ruka button is OP

    Messages:
    31,863
    Likes Received:
    3,721
    Joined:
    Jul 11, 2013
    User ID:
    NA: 371,153,246
    PADherder:
    link
    RE: Google REM Data Collection Thread

    Those 3 sheets should be unlocked. Tell me if you have any problems.
     
  17. DogFest

    DogFest Hound Egg Machine

    Messages:
    795
    Likes Received:
    68
    Joined:
    Sep 12, 2014
    RE: Google REM Data Collection Thread

    It keeps asking me to login and doesn't let me add anything. You can lock them up again, it's no big deal, and I'm out of time to do this right now.
     

Share This Page