Page 1 of 8 12345 ... LastLast
Results 1 to 20 of 160
  1. #1

    Default Automatic raid timer spreadsheet

    Fed up with switching characters to find out which of your characters are on timer? So was I - so this morning I was bored and created a spreadsheet on Google docs that you can use to track your characters' raid timers.

    Click here to go to the template, then click 'Use this Template'. Note: you need a Google account to use this spreadsheet.

    Once you're loaded - simply put your my.ddo.com account name (e.g. Garth_of_Sarlona) in the top, and then fill in up to ten characters you wish to track and the data is automagically pulled from my.ddo.com by the power of Google. Note: you must make your characters you wish to track public on my.ddo.com - there's an excellent guide explaining this by geoffhanna here.

    UPDATE: The spreadsheet now supports automatic raid completion counters.

    Instructions for use

    Prerequisites: You must have a google account to download the spreadsheet. You must have made your characters public (see guide linked above).

    Step 1: Download the sheet.

    Go to the template here, and click on the 'use this template' button.

    Step 2: Fill in your account and characters

    First, fill in your my.ddo.com account name (this should match your forum name) at the top:


    Then, fill in your character names (up to 10) in the larger boxes at the top of each column. At this point, the timers for those characters should magically appear:



    If your timers do not appear then it's possible that your characters are not public, or maybe the spreadsheet had a problem connecting to my.ddo.com - to force a retry just make an edit on the page, but the sheet only hits my.ddo.com a maximum of once every 10 minutes so you might have to wait for it to update.

    Step 2b: Timezone correct

    If you've manually changed the timezone in my.ddo.com thenyou need to correct for this by putting a value into the timezone field. The value should be a fraction of days e.g. 3 hrs (PST) is less 3/24 = -0.125 (just put =-3/24 in the field). Your mileage may vary, experiment with different values until the times match what you're seeing in DDO.



    Step 3: Populate the raid completions

    Go to DDO and type /quest completions on each of your characters, then fill in the data into the small column beside each raid for each character. IMPORTANT never edit the fields where the timers appear or you'll break your spreadsheet!



    Step 4: Initialize the cache

    Go to the 'cache' tab (bottom of the screen) and click the 'Initialize' button. This will only have to ever be done once or if the sheet gets out of sync in future. Note: you might get a warning about running the script, if you go to Tools...Scripts...Manage you can view what they do to check I'm not doing anything nefarious



    Step 5: Set up the automatic triggers

    Unfortunately when I publish a sheet to Google Templates, I cannot also publish script triggers so if you want the sheet to automatically update without you having to open it, you need to set up these triggers.

    To do this, go to Tools->Scripts->Script Editor



    Then go to Triggers->Current Script Triggers...



    Then add a trigger to run the updateRaids script every 10 minutes. The script is running on Google platform so no need to be cautious with overloading it.



    All Done! Return to the 'Raid Timers' sheet, and it will automatically poll every 10 minutes and ensure that it keeps your raid counters up to date. You can also manually get it to update by clicking on the 'update' button on the front page.

    If the raid counters get out of sync, then just edit them on the main page manually and do the cache Initialize operation again to get the sheet back in sync.

    You can then either leave it as a spreadsheet, or ask Google to publish as a webpage e.g. I keep my timers here for easy access from anywhere.

    To publish as a webpage click the Share button in the top right, then do 'Publish as a webpage'



    ...then select the Raid Timers sheet and do 'publish'.. Make sure you have 'automatically republish when changes are made' enabled.



    Let me know if you find any bugs or if it's useful!

    Garth


    Revision log:
    2010-04-17 Original release
    2010-05-14 Add raid counter support
    2010-09-05 Fix link to timers
    2011-06-07 Fix link to template for those using Google app domains
    2011-06-24 Fix another link

    Last edited by Garth_of_Sarlona; 06-24-2011 at 05:38 PM. Reason: update link to my timers

    Garth 20/ftr (Kensei) Haeson 20/clr Cairis 12/ftr 6/rgr 2/rog Xortan 20/wiz
    Tinosa 20/brd Garthbot 20/fvs Gaarth 18/ftr 1/rgr 1/rog (Stal Def)
    Tibetan 20/mnk Automatic DDO raid timers Haezon 20/sor (Conj)

  2. #2
    Community Member Anderei's Avatar
    Join Date
    Sep 2009
    Posts
    1,417

    Default

    wow

  3. #3
    Community Member Lorien_the_First_One's Avatar
    Join Date
    Dec 2006
    Posts
    17,767

    Default

    great work. I've never understood why Turbine doesnt give us tools like this

  4. #4
    Community Member Quikster's Avatar
    Join Date
    Apr 2008
    Location
    Backwards Day in Bikini Bottom
    Posts
    7,252

    Default

    Quote Originally Posted by Garth_of_Sarlona View Post
    Fed up with switching characters to find out which of your characters are on timer? So was I - so this morning I was bored and created a spreadsheet on Google docs that you can use to track your characters' raid timers.

    Click here to go to the template, then click 'Use this Template'. Note: you need a Google account to use this spreadsheet.

    Once you're loaded - simply put your my.ddo.com account name (e.g. Garth_of_Sarlona) in the top, and then fill in up to ten characters you wish to track and the data is automagically pulled from my.ddo.com by the power of Google. Note: you must make your characters you wish to track public on my.ddo.com - there's an excellent guide explaining this by geoffhanna here.

    You can then either leave it as a spreadsheet, or ask Google to publish as a webpage e.g. I keep my timers here for easy access from anywhere.

    Let me know if you find any bugs or if it's useful!

    Garth
    eww only 10 slots??? W t heck am i going to do? Does that mean i need to delete some of my pikers?

    BTW grats on the pull tonight, punk!
    Sarlona's #1 Piker!!
    QuiknDirty~Quikster~Quikfire~Quikkilla~Quikinator~ Missquik~Quiktunes~Fatalbert~Bignugly~Quikmeister~ Member of Quantum Entropy!!

  5. #5
    Hero Morningfrost's Avatar
    Join Date
    Oct 2009
    Location
    Italy
    Posts
    479

    Default

    Quote Originally Posted by Garth_of_Sarlona View Post
    Fed up with switching characters to find out which of your characters are on timer? So was I - so this morning I was bored and created a spreadsheet on Google docs that you can use to track your characters' raid timers.
    Awesome, this is also very useful as boss key when you are drowning in paperwork!

    +1.
    --

    That the sky exists, although our place is hell.

  6. #6

    Default

    Quote Originally Posted by Quikster View Post
    eww only 10 slots??? W t heck am i going to do? Does that mean i need to delete some of my pikers?

    BTW grats on the pull tonight, punk!
    ya it was originally 7 but then I put it up to 10 because I know how many toons you have - but then you'll need two sheets for your two accounts. You can link the sheets together though with the new importRange() function that Google just added this week, so if you want me to make you a custom sheet with 20 slots for two accounts let me know

    Garth

    p.s. yes very happy with the pull!

    Garth 20/ftr (Kensei) Haeson 20/clr Cairis 12/ftr 6/rgr 2/rog Xortan 20/wiz
    Tinosa 20/brd Garthbot 20/fvs Gaarth 18/ftr 1/rgr 1/rog (Stal Def)
    Tibetan 20/mnk Automatic DDO raid timers Haezon 20/sor (Conj)

  7. #7
    Hero Morningfrost's Avatar
    Join Date
    Oct 2009
    Location
    Italy
    Posts
    479

    Default

    Quote Originally Posted by Garth_of_Sarlona View Post
    Let me know if you find any bugs or if it's useful!
    Can you explain how the timezone field works? f I enter integers, it seems that they are counted as full days. I'm normally in CET, daylight saving time so CEST (GMT +2) right now.

    Regards.
    --

    That the sky exists, although our place is hell.

  8. #8

    Default

    Quote Originally Posted by Morningfrost View Post
    Can you explain how the timezone field works? f I enter integers, it seems that they are counted as full days. I'm normally in CET, daylight saving time so CEST (GMT +2) right now.

    Regards.
    the TZ field takes values in days, so if you want to put hours in you have to use /24 so e.g. =-2/24 or =2/24 - I wasn't able to test the timezone field extensively because I'm in EST, so please let me know if it performs as desired.

    Garth

    Garth 20/ftr (Kensei) Haeson 20/clr Cairis 12/ftr 6/rgr 2/rog Xortan 20/wiz
    Tinosa 20/brd Garthbot 20/fvs Gaarth 18/ftr 1/rgr 1/rog (Stal Def)
    Tibetan 20/mnk Automatic DDO raid timers Haezon 20/sor (Conj)

  9. #9

    Default

    +1. this one is really good. i could obsolete my timer.
    ddoer.com: timer tracker, completions tracker, search engine, puzzle solver, xp table
    My toons on Argo: Salade TR2 Wiz20, Speedo ESoS Fighter, MangoSalade TR2 Wiz18/Mnk2, EvaHealer Clr18/Mnk2

  10. #10
    Community Member
    Join Date
    Oct 2009
    Location
    Budapest/Hungary
    Posts
    674

    Default

    This is very helpful awesome job.

    I d like to know how I can import another sheet to show my other account aswell.

    Thx in advance +1
    ~~~ R E V E N A N T S ~~~
    Ayspam Life #27/27(Completionist Sorc), Aycare Life #10/10(Evoker FvS), Ayplink Life #22/22(Completionist to be decided), Aygo Life #14/14(Helvesbarian)

  11. #11

    Default

    to import a second sheet, just create two sheets, one for each account, then on one of the sheets you need to use the importRange() command which is explained here by google. You need to find the google key for the second document you wish to import, you can find this by looking in the URL bar as you open the document - it should look something like a long list of characters e.g. 0AlFPW9gsaPxodEVqRW5RdlBoOGIySnpS.

    To do this just select an empty cell just below the main results page, and then add the command

    =importRange("0AlFPW9gsaPxodEVqRW5RdlBoOGIySnpS", "Raid Timers!A3:K19")


    This will suck in the data from your other spreadsheet, then you need to apply some basic formatting, but you'll have them both on the same sheet. Once you've done this you won't have to open your other sheet, but hang onto it because it's still the one pulling the source data for the other account.

    Garth

    Garth 20/ftr (Kensei) Haeson 20/clr Cairis 12/ftr 6/rgr 2/rog Xortan 20/wiz
    Tinosa 20/brd Garthbot 20/fvs Gaarth 18/ftr 1/rgr 1/rog (Stal Def)
    Tibetan 20/mnk Automatic DDO raid timers Haezon 20/sor (Conj)

  12. #12
    Community Member
    Join Date
    Oct 2009
    Location
    Budapest/Hungary
    Posts
    674

    Default

    Quote Originally Posted by Garth_of_Sarlona View Post
    to import a second sheet, just create two sheets, one for each account, then on one of the sheets you need to use the importRange() command which is explained here by google. You need to find the google key for the second document you wish to import, you can find this by looking in the URL bar as you open the document - it should look something like a long list of characters e.g. 0AlFPW9gsaPxodEVqRW5RdlBoOGIySnpS.

    To do this just select an empty cell just below the main results page, and then add the command

    =importRange("0AlFPW9gsaPxodEVqRW5RdlBoOGIySnpS", "Raid Timers!A3:K19")


    This will suck in the data from your other spreadsheet, then you need to apply some basic formatting, but you'll have them both on the same sheet. Once you've done this you won't have to open your other sheet, but hang onto it because it's still the one pulling the source data for the other account.

    Garth
    Erm thx, cant really say I understand what you wrote But I ll try fumbling around with it, thx for the help tho, much appreciated
    ~~~ R E V E N A N T S ~~~
    Ayspam Life #27/27(Completionist Sorc), Aycare Life #10/10(Evoker FvS), Ayplink Life #22/22(Completionist to be decided), Aygo Life #14/14(Helvesbarian)

  13. #13
    Community Member Calozz78's Avatar
    Join Date
    Mar 2006
    Location
    El Paso
    Posts
    243

    Default

    amazing Garth.. +1 rep


    It works well!
    Vulger Display of Power, Disposable Hero, Farbeyond Driven, VicRattle Head, Typeo Negative, Warpig, Infetious Grooves, Damageplan, Slipknott, GnR, BlkSunshine

  14. #14
    Hero Morningfrost's Avatar
    Join Date
    Oct 2009
    Location
    Italy
    Posts
    479

    Default

    Quote Originally Posted by Garth_of_Sarlona View Post
    the TZ field takes values in days, so if you want to put hours in you have to use /24 so e.g. =-2/24 or =2/24 - I wasn't able to test the timezone field extensively because I'm in EST, so please let me know if it performs as desired.
    Ok, it works. I'll double check if adding one hour is enough next time I log in.

    Edit: adding +1/24 is enough for DST, I just finished a Reaver and it shows 2 days and 18 hours.
    Last edited by Morningfrost; 04-19-2010 at 10:38 AM.
    --

    That the sky exists, although our place is hell.

  15. #15
    Community Member Raku's Avatar
    Join Date
    May 2006
    Posts
    22

    Thumbs up

    It works great, thank you.
    Any guide of add more char (11th or above char slot from ddo store) to the sheet from the same account?

  16. #16

    Default

    or just use this link.

    The guy that posted it has a thread somewhere. Kudos to him.

    Edit: I read your post more carefully... Interesting.

    Edit: after playing around with it and trying to get my spreadsheet made from long ago to work like yours....

    Damn.

    Nice work making that thing! /bow
    Last edited by Clay; 04-19-2010 at 05:15 AM.
    Khyber
    R e v e n a n t s Renowned
    Thelanis

  17. #17
    Community Member Hydro's Avatar
    Join Date
    Mar 2006
    Posts
    935

    Default

    Very nice, I liked it so much I even modified a seperate template for epic timers. Everything is working good with it, just not positive what I should put for timer. Currently I am using .664 which seems accurate up to a few minutes.

  18. #18

  19. #19
    Founder Shadow_Flayer's Avatar
    Join Date
    Feb 2006
    Location
    Providence, RI
    Posts
    1,065

    Default

    Quote Originally Posted by Missing_Minds View Post
    Raising the anti on Shadow_Flayer, huh?
    I'm a lover not a fighter. Garth can win if he wants. I'm just having a bit of fun in my spare time.

  20. #20
    Community Member rawzon3's Avatar
    Join Date
    Apr 2006
    Posts
    145

    Default

    Will this template work for characters that were server transfers? I couldn't manage to get the other one to work for my refugees.

Page 1 of 8 12345 ... LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

This form's session has expired. You need to reload the page.

Reload