Results 1 to 8 of 8
  1. #1
    Community Member FURYous's Avatar
    Join Date
    Mar 2006
    Posts
    280

    Default Favor Tracking Spreadsheet

    Pretty simple spreadsheet to help plan your favor. Go through the list and click "N" in the "Done" column on all the quests you want to skip. This will update the sheet with quests "Planned" (not marked "N")
    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 "Done" column as "Y" 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. I have 58 quests skipped and am still showing well over 5100 favor planned. 1850 already earned so far.

    1. download the file or open in sheets
    2. the only thing you need to do is pick Y or N 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 not done
    • Total favor planned = total favor of all quests not marked N. 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 as N.
    • Total quests planed = Number of quests not marked N 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 N)


    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.




    Spreadsheet download
    Last edited by FURYous; 08-27-2019 at 11:15 AM.
    Choler 30 Brd 5PLs | Enmity 30 Clr | Exasperate 30 Sor | Ferocity 30Pal 13PLs | Furyous 30Inq Heroic/Epic Completionist 82PLs | Hiddin 20Mnk 2PL | Infuryated 30War 6PL | Retributive 20Dru 2PL | Vehemence 30Rog Completionist 35PLs | Vehement 10Pal 3Mnk 1Rog | Vexate 30Wiz Heroic/Epic Completionist 49PLs | Violence 30Clr Heroic/Epic/Racial Completionist 94PLs

  2. #2
    Ultimate Completionist
    2014 DDO Players Council

    Join Date
    Nov 2009
    Posts
    11,026

    Default

    +1 wow

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

    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 01:02 AM.

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

    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
    280

    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.
    Choler 30 Brd 5PLs | Enmity 30 Clr | Exasperate 30 Sor | Ferocity 30Pal 13PLs | Furyous 30Inq Heroic/Epic Completionist 82PLs | Hiddin 20Mnk 2PL | Infuryated 30War 6PL | Retributive 20Dru 2PL | Vehemence 30Rog Completionist 35PLs | Vehement 10Pal 3Mnk 1Rog | Vexate 30Wiz Heroic/Epic Completionist 49PLs | Violence 30Clr Heroic/Epic/Racial Completionist 94PLs

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

    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 07:37 AM.
    Choler 30 Brd 5PLs | Enmity 30 Clr | Exasperate 30 Sor | Ferocity 30Pal 13PLs | Furyous 30Inq Heroic/Epic Completionist 82PLs | Hiddin 20Mnk 2PL | Infuryated 30War 6PL | Retributive 20Dru 2PL | Vehemence 30Rog Completionist 35PLs | Vehement 10Pal 3Mnk 1Rog | Vexate 30Wiz Heroic/Epic Completionist 49PLs | Violence 30Clr Heroic/Epic/Racial Completionist 94PLs

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

    Default

    Updated a few items.

    Did you know you can skip 70 quests or so, if you plan it right 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.
    Choler 30 Brd 5PLs | Enmity 30 Clr | Exasperate 30 Sor | Ferocity 30Pal 13PLs | Furyous 30Inq Heroic/Epic Completionist 82PLs | Hiddin 20Mnk 2PL | Infuryated 30War 6PL | Retributive 20Dru 2PL | Vehemence 30Rog Completionist 35PLs | Vehement 10Pal 3Mnk 1Rog | Vexate 30Wiz Heroic/Epic Completionist 49PLs | Violence 30Clr Heroic/Epic/Racial Completionist 94PLs

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

    Default

    More changes, made the "Y" or "N" a drop down and added some more calcs.

    In short:
    1. download the file or open in sheets
    2. the only thing you need to do is pick Y or N 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 not done
    • Total favor planned = total favor of all quests not marked N. 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 as N.
    • Total quests planed = Number of quests not marked N 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 N)


    Premarked all 18 raids as skipped. This loses you 486 favor but leaves you 5762 favor to earn from other quests. This allows you to skip quite a few more to bypass the bad quests.
    Last edited by FURYous; 08-27-2019 at 11:57 AM.
    Choler 30 Brd 5PLs | Enmity 30 Clr | Exasperate 30 Sor | Ferocity 30Pal 13PLs | Furyous 30Inq Heroic/Epic Completionist 82PLs | Hiddin 20Mnk 2PL | Infuryated 30War 6PL | Retributive 20Dru 2PL | Vehemence 30Rog Completionist 35PLs | Vehement 10Pal 3Mnk 1Rog | Vexate 30Wiz Heroic/Epic Completionist 49PLs | Violence 30Clr Heroic/Epic/Racial Completionist 94PLs

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