Results 1 to 20 of 108

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Community Member FURYous's Avatar
    Join Date
    Mar 2006
    Posts
    553

    Default Favor Tracking Spreadsheet

    Pretty simple spreadsheet to help plan your favor. Go through the list and click "Skip" in the "Done" column on all the quests you want to skip. This will update the sheet with quests "Planned" (not marked "Skip")
    Then you should see how much favor is left and how many quests you need to do to get that favor.
    As you do a quest, mark the difficulty done, in the Done column and the sheet will update to show how much you have earned, planned and skipped.

    You can actually skip a lot of quests and still get to 5,000. There is 7403 favor if you do everything so you can skip 2403. You will need to do about 360 quests to get 5k favor and there is 498 quests (and raids and challenges) allowing you to skip around 138 things and still get your 5k favor.

    1. download the file or open in sheets
    2. the only thing you need to do is pick the difficulty or Skip from the Done column, the spreadsheet will do the rest.



    • Quest name, Level and Favor should be self explanatory
    • Possible shows a total of all favor possible to that point whether you do the quest or not
    • Earned = running total of all quests you marked as done
    • Lost = running total of all quests you marked as Skip
    • Total favor planned = total favor of all quests not marked Skip. This allows you to plan what quests to skip by letting you know how much favor you will have once you marked all raid and other quests you want to skip.
    • Total quests planed = Number of quests not marked Skip to give you a number of quests you plan to do.
    • Quests left = number of quests planned - number of quests done.
    • Quests skipped = number of quests you are skipping (Marked Skip)


    NOTE: You have to download the file to make changes to it. I made this using excel and while it seems to work in Sheets, I make no promises.

    NOTE: I added some comments in the title fields to explain what each number means, just hover your mouse over a total to see the notes.



    Spreadsheet download
    Last edited by FURYous; 11-30-2022 at 10:52 PM.
    Mr Blacks - Ranged DPS - 120PL - 50RP
    Mr Blues - Main - 177PL - 98RP
    Mr Greens - Caster CC/DC - 126PL - 37RP
    Mr Purples - Healer - 43PL - 21RP
    Mr Redd - Melee DPS - 129PL - 37RP
    Mr Whites - Tank - 138PL - 58RP

  2. #2
    Ultimate Completionist
    2014 DDO Players Council
    Open Guild for All Founder - Hardcore

    Join Date
    Nov 2009
    Posts
    0

    Default

    +1 wow

  3. #3
    Community Member
    Join Date
    Aug 2008
    Posts
    203

    Default

    Wow, very nice.

    The spreadsheet does have some fields already started for you. For best results just deleted all the Y/N and start to fill it in fresh.

    There are a few duplicates, I'm not sure if this is intentional or not:

    Disciples of Shar
    Disciples of Shar?*(F2P)

    Escape Plan
    Escape Plan?*(F2P)

    Beyond the Rift
    Beyond the Rift
    Servants of the Overlord
    Servants of the Overlord
    The Lords of Dust
    The Lords of Dust
    The Spinner of Shadows
    The Spinner of Shadows
    Last edited by Arcath; 08-22-2019 at 02:02 AM.

  4. #4
    Community Member
    Join Date
    Aug 2008
    Posts
    203

    Default

    This is also a great planning tool. Just add a field with '=F399-H399' then you can go ahead and mark quests you want to skip and it will give you a running total of what favor you get for running EVERY other quest in the game.

    If I plan on skipping just about every raid and most quests with beholders I should be at about 5100 favor.

    Great tool, thank you.

  5. #5
    Community Member FURYous's Avatar
    Join Date
    Mar 2006
    Posts
    553

    Default

    Quote Originally Posted by Arcath View Post
    This is also a great planning tool. Just add a field with '=F399-H399' then you can go ahead and mark quests you want to skip and it will give you a running total of what favor you get for running EVERY other quest in the game.

    If I plan on skipping just about every raid and most quests with beholders I should be at about 5100 favor.

    Great tool, thank you.
    Added a "Total Planned" field at the top to track everything you don't have marked "N"

    Marked all raids as "N" and added " (RIAD)" to their names.

    It looks like you can safely bypass all raids (some may be done on normal somewhat safely I think) and some of the more dangerous quests (like crucible) and still have enough favor to hit the 5,000 point mark. It will be a serious grind though, doing all 341 quests on elite or higher without dieing
    Last edited by FURYous; 08-22-2019 at 08:37 AM.
    Mr Blacks - Ranged DPS - 120PL - 50RP
    Mr Blues - Main - 177PL - 98RP
    Mr Greens - Caster CC/DC - 126PL - 37RP
    Mr Purples - Healer - 43PL - 21RP
    Mr Redd - Melee DPS - 129PL - 37RP
    Mr Whites - Tank - 138PL - 58RP

  6. #6
    Community Member FURYous's Avatar
    Join Date
    Mar 2006
    Posts
    553

    Default

    Updated a few items.

    Did you know you can skip 70 quests or so, you can skip most quests that have a huge chance of death in them. If you plan it out correctly, the road to 5000 could be a lot less stressful.
    Last edited by FURYous; 04-07-2021 at 12:20 AM.
    Mr Blacks - Ranged DPS - 120PL - 50RP
    Mr Blues - Main - 177PL - 98RP
    Mr Greens - Caster CC/DC - 126PL - 37RP
    Mr Purples - Healer - 43PL - 21RP
    Mr Redd - Melee DPS - 129PL - 37RP
    Mr Whites - Tank - 138PL - 58RP

  7. #7
    Community Member FURYous's Avatar
    Join Date
    Mar 2006
    Posts
    553

    Default

    Quote Originally Posted by Arcath View Post
    Wow, very nice.

    The spreadsheet does have some fields already started for you. For best results just deleted all the Y/N and start to fill it in fresh.

    There are a few duplicates, I'm not sure if this is intentional or not:

    Disciples of Shar
    Disciples of Shar?*(F2P)

    Escape Plan
    Escape Plan?*(F2P)

    Beyond the Rift
    Beyond the Rift
    Servants of the Overlord
    Servants of the Overlord
    The Lords of Dust
    The Lords of Dust
    The Spinner of Shadows
    The Spinner of Shadows
    Fixed, other updates too.
    Mr Blacks - Ranged DPS - 120PL - 50RP
    Mr Blues - Main - 177PL - 98RP
    Mr Greens - Caster CC/DC - 126PL - 37RP
    Mr Purples - Healer - 43PL - 21RP
    Mr Redd - Melee DPS - 129PL - 37RP
    Mr Whites - Tank - 138PL - 58RP

  8. #8
    Community Member FURYous's Avatar
    Join Date
    Mar 2006
    Posts
    553

    Default

    Major updates, it now lets you pick the difficulty and adjusts the favor to match.

    NOTE: you have to choose from the drop down list with the difficulty that you plan to do the quest. Also you need to choose "Skip" on the quests you plan to skip to update the totals. For convenience, I pre selected most of the quests I normally skip. You need to change these to match your play.
    Mr Blacks - Ranged DPS - 120PL - 50RP
    Mr Blues - Main - 177PL - 98RP
    Mr Greens - Caster CC/DC - 126PL - 37RP
    Mr Purples - Healer - 43PL - 21RP
    Mr Redd - Melee DPS - 129PL - 37RP
    Mr Whites - Tank - 138PL - 58RP

  9. #9
    Community Member FURYous's Avatar
    Join Date
    Mar 2006
    Posts
    553

    Default

    Added the soul splitter quests. Cleaned it up a bit
    Mr Blacks - Ranged DPS - 120PL - 50RP
    Mr Blues - Main - 177PL - 98RP
    Mr Greens - Caster CC/DC - 126PL - 37RP
    Mr Purples - Healer - 43PL - 21RP
    Mr Redd - Melee DPS - 129PL - 37RP
    Mr Whites - Tank - 138PL - 58RP

  10. #10
    Community Member Mglaxix's Avatar
    Join Date
    Feb 2016
    Posts
    457

    Default

    Updated your sheet a bit with Keep on the Boarderlands and the Challenges


    https://drive.google.com/open?id=1-g...YmjezZBUTnuGXx

  11. #11
    Senior Member
    Join Date
    Sep 2011
    Posts
    0

    Default

    Quite amazing, thank you for sharing.

    A small thing - the dropdowns are missing for the last set of challenges.

    A further improvement might be to add which chain / zone each quest is in and sort by that within each level, or simply sort by favor within each level as that is already in the sheet.

    I added those things to the sheet.
    https://www.dropbox.com/s/b4te2r9fwc...nner.xlsx?dl=0
    Last edited by mikarddo; 02-20-2020 at 04:39 AM.
    Member of Spellswords on Ghallanda

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