Favor Tracking Spreadsheet

[FURYous]

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.


download the file or open in sheets
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.

https://i.imgur.com/1ZcvbLz.jpeg

Spreadsheet download (https://docs.google.com/spreadsheets/d/1B92RafhyaQvr9hqsHwWEVdCJpcOMMadn/edit?usp=share_link&ouid=104463891375490944084&rtpof=true&sd=true)

[Silverleafeon]

+1 wow

[Arcath]

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

[Arcath]

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.

[FURYous]

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.

[FURYous]

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

[FURYous]

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.

[FURYous]

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

In short:

download the file or open in sheets
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.

[FURYous]

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.

[FURYous]

Added the soul splitter quests. Cleaned it up a bit

[Mglaxix]

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


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

[mikarddo]

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/b4te2r9fwc6u4j3/DDO%20Favor%20Planner.xlsx?dl=0

[Heledore]

Cool, thank You. If I'm not mistaken, the spreadsheet misses the Refugee Toll (https://ddowiki.com/page/Refugee_Toll) quest (I haven't done it yet :p)

[Noir]

I updated the spreadsheet for season 3 ( Includes "The lost Gate Keepers" Chain )

Goggle Drive Link ( I open it with Google Doc. Not Sure how well it will work with Excel )

https://drive.google.com/file/d/1w60IYW7prh5SvXPcJP8w-OQjl3cB2eF5/view?usp=sharing

Please save a local copy or copy to your own online repository, Don't make edits to the original

[hit_fido]

I updated the spreadsheet for season 3 ( Includes "The lost Gate Keepers" Chain )

Goggle Drive Link ( I open it with Google Doc. Not Sure how well it will work with Excel )



Great job on this, can confirm it works fine in Excel once downloaded. Thanks.

[Noir]

There was a mistake in the formulas on line 46. ( The Swiped Signet )
I have corrected it but if you had downloaded the sheet prior to this post you will need to either correct the formulas yourself or re-download the spreadsheet.

https://drive.google.com/file/d/1w60IYW7prh5SvXPcJP8w-OQjl3cB2eF5/view?usp=sharing

EDIT: I also corrected the Solo Quest values and formulas

[Mindos]

There was a mistake in the formulas on line 46. ( The Swiped Signet )
I have corrected it but if you had downloaded the sheet prior to this post you will need to either correct the formulas yourself or re-download the spreadsheet.

https://drive.google.com/file/d/1w60IYW7prh5SvXPcJP8w-OQjl3cB2eF5/view?usp=sharing

Weird, it went from 82 to 97 KB. Seems a lot.

[Noir]

That is strange. All I did was change the reference cell for the formulas on line 46 from Line 40 to line 45.
And correct the formulas for the Solo quest from doing a *3 to an *1 and also modified the formula to recognize if the drop down had "Solo" as a value.

[Tist]

maybe the change tracking is on? So every change is recorded and passed along in the final sheet currently, rather than just being the final sheet as is at the time of export?

[Noir]

I updated the spreadsheet for season 3 ( Includes "The lost Gate Keepers" Chain )

Goggle Drive Link ( I open it with Google Doc. Not Sure how well it will work with Excel )

https://drive.google.com/file/d/1w60IYW7prh5SvXPcJP8w-OQjl3cB2eF5/view?usp=sharing

Please save a local copy or copy to your own online repository, Don't make edits to the original

Updated Spreadsheet for Hardcore Season 4


Added Feywild Quests and RAID
Added Morgrave University Quests
Added Sharn RAIDS


Google Docs Link https://docs.google.com/spreadsheets/d/1msagzzZHZXNVKqNZrA6xZhT1qfIUZc42uMDhJL8IALo/edit?usp=sharing
Excel Doc Link https://drive.google.com/file/d/16gpIXItc6col8wCJ9ZaPbKOu9LxyFP37/view?usp=sharing

Please save a local copy or copy to your own online repository, Don't make edits to the original

[Jinxx]

This is amazing! Great job :)

[FengXian]

Great work, thanks!

[Oxarhamar]

Do not give a care about favor rewards

Top job anyway.

[Marshal_Lannes]

+1 excellent gaming tool. Thanks also for those that made it Google sheets compatible.

[FURYous]

Updated with all the new quests

[Mindos]

Noticed solo quests if drop down is marked "solo" for difficulty it doesn't work right, you have to mark normal?

[beta1]

Noticed solo quests if drop down is marked "solo" for difficulty it doesn't work right, you have to mark normal?

This is one bug, another is the possible favor for solo quests is 3x the "normal" favor, but only normal favor is possible.

Overall the spreadsheet is a great aid though.

[FURYous]

Noticed solo quests if drop down is marked "solo" for difficulty it doesn't work right, you have to mark normal?


This is one bug, another is the possible favor for solo quests is 3x the "normal" favor, but only normal favor is possible.

Overall the spreadsheet is a great aid though.

Fixed and added a few features.

[FURYous]

I think I have all the solo quest favor calculations ironed out. I took out the challenges because the star system and the low favor you get from them don't make it worth the effort. I think I have all the quests now.

[FURYous]

Fixed a calc error, if you downloaded before this time you will have a small error in total favor after level 3 quests, it is fixed now.

[AlsoWondering]

I'm not sure where the errors are, but your total favor for House J, The Twelve, The Coin Lords, The Gatekeepers, Sharn and the Summer Court are all wrong. Also some have the wrong number of quests.

For some reason the first page is protected and I can't remove the protection it so I can't easily tell where the errors are located (I am using Open Office, not Excel). The second page is not protected.

[FURYous]

,,,

[FURYous]

I'm not sure where the errors are, but your total favor for House J, The Twelve, The Coin Lords, The Gatekeepers, Sharn and the Summer Court are all wrong. Also some have the wrong number of quests.

For some reason the first page is protected and I can't remove the protection it so I can't easily tell where the errors are located (I am using Open Office, not Excel). The second page is not protected.

for the sake of completion I have updated the list to include all the high end raids. I am not doing challenges as the star system is a PITA to incorporate in the spreadsheet for as little favor as they give.

Please update if you have a version earlier than this post if your are interested in earning favor from level 32 raids, good luck on elite ;)

[FURYous]

Added challenges and a few other improvements

[FURYous]

Minor updates to calcs

[FURYous]

it took me a while to figure it out but:


=(SUMIFS(E:E,J:J,Q15,C:C,"Solo"))+(SUMIFS(E:E,J:J,Q15,C:C,"<>Solo")*3)

has been added to the spreadsheet to calc the total patron favor for ALL quests, even solo and challenges :)

[Mindos]

is there some way to use an updated list with the list already started? i can't into excel

[FURYous]

is there some way to use an updated list with the list already started? i can't into excel

Not that I know of. Here is what I do:
On a clean copy, I copy/paste "Elite" on all the quests up to the level I am working on. Then I go back and mark the ones that I skipped or did on a different difficulty.
It takes a few minutes but isn't too hard.

The in game favor list shows which quests have not been done and unless you are skipping a ton of them, it should be easy to mark the ones skipped.

Being as I am the one making the sheet, I can also update the formula's on my current sheets as I make changes ;)

One of the reasons I have some of the quests pre-marked as skip is those are the ones I normally skip so I don't have to go back and mark them, I just mark all the others as elite.

[FURYous]

Added Update 49 quests

[Erofen]

Added Update 49 quests

2 of these have the incorrect favor amount.

I fixed those, added the epic versions of the challenges, added a current favor by patron section, updated the dropdowns to only show the relevant options, and sorted the list the same as the in game adventure compendium (1-32, Z-A with "The" not included in the sort). I also did some minor formatting.

Here is the updated version if anyone is interested: https://drive.google.com/file/d/13Em7HfStMalp6Kx9zMDG6LS0w5L_qny_/view?usp=sharing

[FURYous]

2 of these have the incorrect favor amount.

I fixed those, added the epic versions of the challenges, added a current favor by patron section, updated the dropdowns to only show the relevant options, and sorted the list the same as the in game adventure compendium (1-32, Z-A with "The" not included in the sort). I also did some minor formatting.

Here is the updated version if anyone is interested: https://drive.google.com/file/d/13Em7HfStMalp6Kx9zMDG6LS0w5L_qny_/view?usp=sharing

Fixed the favor, I don't add epic versions because the favor doesn't stack and it screws up the calcs. Also I sorted by level then by house favor to keep chains together when possible.

[Erofen]

Fixed the favor, I don't add epic versions because the favor doesn't stack and it screws up the calcs. Also I sorted by level then by house favor to keep chains together when possible.
The favor DOES stack for challenges since they are separate.

[FURYous]

The favor DOES stack for challenges since they are separate.

Good to know, I hardly ever do challenges due to the low favor return so I don't know much about them

[FURYous]

Added the Saltmarsh quests for season 5

[rabidfox]

This is a such handy thing for planning what I feel like running or skipping at any given time. Thanks.

[FURYous]

This is a such handy thing for planning what I feel like running or skipping at any given time. Thanks.

Glad you find it helpful

[Dark_Lord_Mary]

Thank you this is great - very helpful to track for rewards - having used a similar one for all four hcl so far makes a big difference.

[mikarddo]

Thank you very much.

I plan to do some of the challanges 3* rather than 6*. Is there a way to pre-plan that which takes the reduced favor into account in the calculated total?

[FURYous]

Thank you very much.

I plan to do some of the challanges 3* rather than 6*. Is there a way to pre-plan that which takes the reduced favor into account in the calculated total?

you should be able to pick "3 star" from the difficulty drop down. Doesn't that work?

[mikarddo]

you should be able to pick "3 star" from the difficulty drop down. Doesn't that work?

It does not seem to change the Total favor planned in the top right.

[FURYous]

It does not seem to change the Total favor planned in the top right.

Ah, I see, the "Total Favor Planned" just checks if you are doing things or skipping them. It assumes that if you are not skipping them, then they are done on elite. If you want a running total of actual favor earned for the level you did the quests on, look at the "Earned" Column.

Let me think about how to best change the "Total Favor Planned" to add elite if blank or the marked favor if not blank. The blanks are what makes it tricky

[FURYous]

Ah, I see, the "Total Favor Planned" just checks if you are doing things or skipping them. It assumes that if you are not skipping them, then they are done on elite. If you want a running total of actual favor earned for the level you did the quests on, look at the "Earned" Column.

Let me think about how to best change the "Total Favor Planned" to add elite if blank or the marked favor if not blank. The blanks are what makes it tricky

"Total of non skipped" may help as well, I added those columns for tracking how many more quests I had to do to get to my goal. It does update with the difficulty chosen.

[Samiusbot]

Thank you for a clean, updated copy.

Very Cool.

[Erofen]

Ah, I see, the "Total Favor Planned" just checks if you are doing things or skipping them. It assumes that if you are not skipping them, then they are done on elite. If you want a running total of actual favor earned for the level you did the quests on, look at the "Earned" Column.

Let me think about how to best change the "Total Favor Planned" to add elite if blank or the marked favor if not blank. The blanks are what makes it tricky

In the updated copy I had linked above, these fixes and extra statistics were already made. I had also fixed the incorrect favor calculations and some other things from your spreadsheet, but it was a while ago so I don't remember what all I changed. You can always reorder the quests with the sort option since you didn't like how I reordered them, but I would definitely suggest working off of that updated copy where I fixed and added a bunch of formulas. It would just need any content added after HC 4 (so Saltmarsh?).

[Noir]

Added the Saltmarsh quests for season 5

Thank you again for updating this. ( Wish I had seen it sooner and saved myself the pain of updating my HCL4 copy to include the Feywild, Perils, and Saltmarsh Quests. )
This is by far the best thing you can do to keep track of the HC league favor and removes all guess work as to what you can and can't skip.

[FURYous]

In the updated copy I had linked above, these fixes and extra statistics were already made. I had also fixed the incorrect favor calculations and some other things from your spreadsheet, but it was a while ago so I don't remember what all I changed. You can always reorder the quests with the sort option since you didn't like how I reordered them, but I would definitely suggest working off of that updated copy where I fixed and added a bunch of formulas. It would just need any content added after HC 4 (so Saltmarsh?).

I am not sure what you are referencing, what incorrect favor calculations? What "other things"? If you are talking about versions from months ago, there have been many changes and updates since then.

[SoulDustar]

Added the Saltmarsh quests for season 5

Looks like you missed The Haunting of Saltmarsh on your spreadsheet

[FURYous]

Looks like you missed The Haunting of Saltmarsh on your spreadsheet

Fixed

[Erofen]

I am not sure what you are referencing, what incorrect favor calculations? What "other things"? If you are talking about versions from months ago, there have been many changes and updates since then.
It was a while ago so I don't remember what I had to change, but I remember it was pretty substantial. I also added some additional info.

Here is the current one with the new quests (including Dread Sea Scrolls) added: https://drive.google.com/file/d/13Em7HfStMalp6Kx9zMDG6LS0w5L_qny_/view?usp=sharing

[Qadashael]

Thank you so much for the spreadsheet! I use it constantly.

I've updated the spreadsheet with the new quests from U53 and U54 to help people track favor in preparation for HCL 6.

EDIT: Link removed - the official spreadsheet was updated. Thank you!

[holdmyale]

Thank you so much for the spreadsheet! I use it constantly.

I've updated the spreadsheet with the new quests from U53 and U54 (https://docs.google.com/spreadsheets/d/15JXWu3wwr2J0TP0Lx6hbV4eEDTsZwTaN/edit?usp=sharing&ouid=107757859709073311782&rtpof=true&sd=true) to help people track favor in preparation for HCL 6.

Thanks for posting this. Hope this gets updated continuously. :cool:

[rish]

Thanks for the updates people, good stuff.

[FURYous]

Updated with the new isle of dread quests

[Erofen]

It was a while ago so I don't remember what I had to change, but I remember it was pretty substantial. I also added some additional info.

Here is the current one with the new quests (including Dread Sea Scrolls) added: https://drive.google.com/file/d/13Em7HfStMalp6Kx9zMDG6LS0w5L_qny_/view?usp=sharing

I updated this with Isle of Dread (including the new raid (empty base favor box to fill in when they fix it)). I'm aware other links are floating around, but this is the least buggy/has the most features.

Here is the link again so it doesn't get lost (the link should stay the same every season, so feel free to just bookmark it so you can have the latest version each HC season): https://drive.google.com/file/d/13Em7HfStMalp6Kx9zMDG6LS0w5L_qny_/view?usp=sharing

[FURYous]

I updated this with Isle of Dread (including the new raid (empty base favor box to fill in when they fix it)). I'm aware other links are floating around, but this is the least buggy/has the most features.

Here is the link again so it doesn't get lost (the link should stay the same every season, so feel free to just bookmark it so you can have the latest version each HC season): https://drive.google.com/file/d/13Em7HfStMalp6Kx9zMDG6LS0w5L_qny_/view?usp=sharing

Read the post before this. I already updated it.

[Erofen]

I'm aware other links are floating around, but this is the least buggy/has the most features.


Read the post before this. I already updated it.
I did before I posted. Hence this comment in my post. I stand by what I said.

[FURYous]

I did before I posted. Hence this comment in my post. I stand by what I said.

did you really come to my post to insult me after stealing all my work, to call it your own? How about you do your own work and make your own post?

[FURYous]

I did before I posted. Hence this comment in my post. I stand by what I said.

I can't even see what you changed. all of my calculations are still there. the only difference I see is that you added a column that does the exact same thing as the column next to it that I already had but gets the total favor wrong.

https://i.imgur.com/sVEwjJZ.jpeg

The first line seems to add 4 to the total favor you can get for that quest, this of course screws everything that comes after....

I got bored with it after that because everything else is EXACTLY my work.

I really like how you reference lines in the header like Q2 and X2, quality work there....

=IF(L3="", IF(D3<>"Solo",(F3*3)+Q2, F3+Q2), Q2)+X2

Nice job being not only an arrogant jerk but being wrong on top of it.

[Erofen]

2 of these have the incorrect favor amount.

I fixed those, added the epic versions of the challenges, added a current favor by patron section, updated the dropdowns to only show the relevant options, and sorted the list the same as the in game adventure compendium (1-32, Z-A with "The" not included in the sort). I also did some minor formatting.

Here is the updated version if anyone is interested: https://drive.google.com/file/d/13Em7HfStMalp6Kx9zMDG6LS0w5L_qny_/view?usp=sharing


did you really come to my post to insult me after stealing all my work, to call it your own? How about you do your own work and make your own post?
Insult? That is not at all what happened. I just said your spreadsheet has some bugs that I had fixed. As far as my own work, yes, I used your original spreadsheet (well, I think I started iterating off of Noir's update to your original spreadsheet... updated myself since then) but updated all of the formulas and added some additional functionality. Not sure why you are getting up-in-arms about me improving your spreadsheet that you were gracious enough to share with us in the beginning (and only just now complaining about it when I have been making updates and posting them for a year and a half (same with other people also in this thread)).

[Erofen]

I can't even see what you changed. all of my calculations are still there. the only difference I see is that you added a column that does the exact same thing as the column next to it that I already had but gets the total favor wrong. nope

https://i.imgur.com/sVEwjJZ.jpeg

The first line seems to add 4 to the total favor you can get for that quest, this of course screws everything that comes after up.... nope, you must have 4 favor elsewhere on that spreadsheet. that column shows the total favor that will be there after you complete that quest. it includes any favor you have already gained later.

I got bored with it after that because everything else is EXACTLY my work. nope, but again, your spreadsheet a year and a half ago was the base

Nice job being not only an arrogant ****** but being wrong on top of it. namecalling completely unnecessary and unwarranted

I really like how you reference lines in the header like Q2 and X2, quality work there.... look at where they reference (a brand new section you didn't have). no reason to duplicate the code from another section. but sure, belittle me all you want.

=IF(L3="", IF(D3<>"Solo",(F3*3)+Q2, F3+Q2), Q2)+X2

Added comments in red. Not sure why you are making this about flaming me now. Is this thread not supposed to be about helping people on HC track their favor? I'm just trying to help.

[FURYous]

but this is the least buggy/has the most features.


Sure seems to indicate "all" the others are buggy and lacking features


I did before I posted. Hence this comment in my post. I stand by what I said.

Reinforces that you stand by all the others being buggy and lacking feature but in a fairly arrogant way


Insult? That is not at all what happened.

Sure came off that way to me

[FURYous]

Added comments in red. Not sure why you are making this about flaming me now. Is this thread not supposed to be about helping people on HC track their favor? I'm just trying to help.

The cell I highlighted that shows 10 favor, is the one that references cells in the header, this is why it is wrong and that error is propagated all the way down the sheet. I had nothing to do with this whole column, you added that and it seems to match my column "Total of non skipped" all the way down with the exception of the wrong starting amount that gets added all the way down.

Here is YOUR calculation in Q3

=IF(L3="", IF(D3<>"Solo",(F3*3)+Q2, F3+Q2), Q2)+X2

if you note, you are calling cells Q2 and X2 that are part of the header and not part of the spreadsheet proper. This is screwing something up to give you a total of 10 instead of the 6 that you should have. But don't worry, I fixed your bugs in my spreadsheet found here: Spreadsheet download (https://docs.google.com/spreadsheets/d/1O_uonb4NUC8YlDRsm5yQquQ9jHxgNvft/edit?usp=sharing&ouid=104463891375490944084&rtpof=true&sd=true)

Spoiler alert, I fixed it by not adding the redundant column (with the bad calc) at all

[FURYous]

Is this thread not supposed to be about helping people on HC track their favor? I'm just trying to help.

it is and if you look at the history I liked and added the corrections people brought to my attention. The wording of your post seemed pretty insulting.

Instead of calling all the other spreadsheets buggy and lacking features, you could have just pointing out how you added the epic challenges, sorted the names without the "The" at the beginning and added the 4 quests I forgot from the hunt pack and the isle of dread preview.

I have corrected all this btw, and feel free to let me know if I missed anything.

I am human and make mistakes but calling the spreadsheet I spent uncountable hours creating over the last 5 hard core seasons, buggy and lacking features, will get you a negative response. You reap what you sow.

[FURYous]

Just a note:
https://i.imgur.com/SBNaaps.jpeg

If you note, in the new column you have called "Favor after complete", this seems to be from a much older version of my sheet before I added the challenges to it. Note how marking the challanges as 5 star doesn't change the value? It stays 6381 until you get to a line with a quest that fixes the error.

In the column "Earned" I fixed this issue by adding the calculation for the star rating in challenges. Also I think what you are trying to do is get your running total of favor you have already completed. I normally do this by looking at column O after the lowest completed quest but I can add a total of earned favor so far at the top if you like.

[FURYous]

In the column "Earned" I fixed this issue by adding the calculation for the star rating in challenges. Also I think what you are trying to do is get your running total of favor you have already completed. I normally do this by looking at column O after the lowest completed quest but I can add a total of earned favor so far at the top if you like.

I added the new total favor earned to the top of the page. take a look and let me know if you like it there, also let me know if there is anything else you would like

[Erofen]

Just a note:
https://i.imgur.com/SBNaaps.jpeg

If you note, in the new column you have called "Favor after complete", this seems to be from a much older version of my sheet before I added the challenges to it. Note how marking the challanges as 5 star doesn't change the value? It stays 6381 until you get to a line with a quest that fixes the error.

In the column "Earned" I fixed this issue by adding the calculation for the star rating in challenges. Also I think what you are trying to do is get your running total of favor you have already completed. I normally do this by looking at column O after the lowest completed quest but I can add a total of earned favor so far at the top if you like.
As I put earlier, all of my changes have been since whatever version of your spreadsheet was out a year and a half or so ago (Noir's HC 3 post is a good reference to see differences). So any calculation changes you made to the bulk of the spreadsheet since then matching up with changes I might have made are purely coincidence from me using the same bulk data source and spreadsheet program. I have only updated my edited version of it since then.

I think you are misunderstanding what the new column I added is doing. It takes your current favor and tells you (starting from the lowest quest level) what completing the next quest will put your current favor total at. So, while these values (Q) will match up with the other column (P) if you run everything exactly in order, if you say complete all of your 15s and have a collection of 18s done, the new Q column will show you what your current favor total will be at after running these lower level quests next. I found it useful as I was running HC, so I added it.

[Erofen]

Sure seems to indicate "all" the others are buggy and lacking features



Reinforces that you stand by all the others being buggy and lacking feature but in a fairly arrogant way



Sure came off that way to me
Other versions had some bugs that I fixed a while ago and don't include a couple extra things I added that I found useful during the seasons. Sorry if this came off as abrasive.

[Erofen]

it is and if you look at the history I liked and added the corrections people brought to my attention. The wording of your post seemed pretty insulting. This was not my intent. Sorry if it came across that way.

Instead of calling all the other spreadsheets buggy and lacking features, you could have just pointing out how you added the epic challenges, sorted the names without the "The" at the beginning and added the 4 quests I forgot from the hunt pack and the isle of dread preview. This was just an example of what I did a while ago. I've just kept updating since. I haven't been going back to any of your updates and working from there, because I like my personal adjustments.

I have corrected all this btw, and feel free to let me know if I missed anything.

I am human and make mistakes but calling the spreadsheet I spent uncountable hours creating over the last 5 hard core seasons, buggy and lacking features, will get you a negative response. You reap what you sow.
Again, it was not my intent to downplay your hard work on this spreadsheet. I appreciate you sharing it with us. It was a great launching point for me to add things that helped me.

[Erofen]

The cell I highlighted that shows 10 favor, is the one that references cells in the header, this is why it is wrong and that error is propagated all the way down the sheet. I had nothing to do with this whole column, you added that and it seems to match my column "Total of non skipped" all the way down with the exception of the wrong starting amount that gets added all the way down.

Here is YOUR calculation in Q3

=IF(L3="", IF(D3<>"Solo",(F3*3)+Q2, F3+Q2), Q2)+X2

if you note, you are calling cells Q2 and X2 that are part of the header and not part of the spreadsheet proper. This is screwing something up to give you a total of 10 instead of the 6 that you should have. But don't worry, I fixed your bugs in my spreadsheet found here: Spreadsheet download (https://docs.google.com/spreadsheets/d/1O_uonb4NUC8YlDRsm5yQquQ9jHxgNvft/edit?usp=sharing&ouid=104463891375490944084&rtpof=true&sd=true)

Spoiler alert, I fixed it by not adding the redundant column (with the bad calc) at all
X2 is intentional for a current favor total after completing the next lowest quest. Q2 (and related ?2s) could be removed from row 3, yes, but considering Q2 is blank (and part of a merged cell) it does not interfere anyways and allows an easy resorting of the quest list if wanted to arrange the whole list differently without breaking calculations. Again, the 10 would be because you have 4 favor somewhere else in your spreadsheet (or unmerged and typed a 4 in Q2).

[FURYous]

X2 is intentional for a current favor total after completing the next lowest quest. Q2 (and related ?2s) could be removed from row 3, yes, but considering Q2 is blank (and part of a merged cell) it does not interfere anyways and allows an easy resorting of the quest list if wanted to arrange the whole list differently without breaking calculations. Again, the 10 would be because you have 4 favor somewhere else in your spreadsheet (or unmerged and typed a 4 in Q2).

I added some of the features from your sheet to try and keep a single version going. I am confused as to what you are looking for in column Q so I didn't add that as I think the information is already available in column M on mine or in the new cell T1

P.S.
I think what you have in column Q is your already earned favor + the favor of the quest on the line? So X2+m3 (if you choose elite or reaper) for line 3?

[Erofen]

I have corrected all this btw, and feel free to let me know if I missed anything.
Since it looks like you just updated the favor totals to be correct now, there are just a couple more things (if you don't plan to add the extra column). Total Quests Planned shouldn't include any quests that give 0 favor (imo). Also, the dropdown for quests/challenges/etc. should only show the relevant difficulty options (can't 6 star The Pit or something). Finally, not sure why you removed the 6 star option for challenges (I think you had that before... don't think I added that one).

[Erofen]

I added some of the features from your sheet to try and keep a single version going. I am confused as to what you are looking for in column Q so I didn't add that as I think the information is already available in column M on mine or in the new cell T1

P.S.
I think what you have in column Q is your already earned favor + the favor of the quest on the line? So X2+m3 (if you choose elite or reaper) for line 3?
Yes, Q is already earned + favor of the next quests in order from lowest level to highest level. It is useful when you complete some higher level quests before lower level ones and need to see how many more of the lower level ones you need to do to reach your goal.

[Erofen]

Since it looks like you just updated the favor totals to be correct now, there are just a couple more things (if you don't plan to add the extra column). Total Quests Planned shouldn't include any quests that give 0 favor (imo). Also, the dropdown for quests/challenges/etc. should only show the relevant difficulty options (can't 6 star The Pit or something). Finally, not sure why you removed the 6 star option for challenges (I think you had that before... don't think I added that one).
I know you like your spreadsheet ordered differently, or I'd just suggest copy-pasting the edited version I had, but you should be able to find the logic to quickly do these next fixes in the spreadsheet I linked if you don't already know how you want to code it up.

P.S. Sorry again if it sounded like I was trying to steal your thunder or talk down about you. My words definitely don't get across what I'm thinking at times and no tone from text-based doesn't help either. I appreciate all your work in this. :)

[FURYous]

not sure why you removed the 6 star option for challenges (I think you had that before... don't think I added that one).

https://ddowiki.com/page/Challenges#Star_ranking

Star ranking
You get 1 Favor point for each star, and 1 additional Favor point if you achieve all 5 stars and run the challenge at its maximum available CR, for a total of 6 Favor possible per challenge. (With 21 Cannith and 6 Eveningstar challenges, this is a total possible Favor of 162.)

Stars are awarded only if the main objective of challenge is completed successfully, and are not awarded progressively. To get all 5 stars, you must complete all 5 objectives during a single instance.

Stars also reward a large amount of bonus XP, this bonus XP is much larger the first each star # is achieved. See the XP section for a detailed explanation on how this works.

[FURYous]

Total Quests Planned shouldn't include any quests that give 0 favor (imo).

I pre-marked them skipped, this allows you to unmark them if you like to add to your total or leave them skipped if you want to do them for reaper XP or something.


Also, the dropdown for quests/challenges/etc. should only show the relevant difficulty options (can't 6 star The Pit or something).

I wanted a universal formula for earned favor so I didn't have to manually use one formula for quests and another for challenges. This allows me to mix and add things without worrying that I messed up the earned favor and having to go back to fix them. Being as the "Difficulty" column can be copy/pasted and well as drag copied, I didn't think it was that big a deal.


Finally, not sure why you removed the 6 star option for challenges (I think you had that before... don't think I added that one).

I did have it before but you can only 5 star challenges, I added the 6th star if you did the challenge at the highest level and got all 5 stars for the extra favor point, but this ran into issues with confusing some folks and the extra point couldn't be over-leveled so it just got messy. I took it out to simplify things as those extra points don't really add up to much (21 favor if you do them all on the highest level at 5 stars). I could add it back again if people think it is worth it. being as the challenges give so little favor to begin with, I assumed everyone skipped them

[FURYous]

Thank you so much for the spreadsheet! I use it constantly.

I've updated the spreadsheet with the new quests from U53 and U54 (https://docs.google.com/spreadsheets/d/15JXWu3wwr2J0TP0Lx6hbV4eEDTsZwTaN/edit?usp=sharing&ouid=107757859709073311782&rtpof=true&sd=true) to help people track favor in preparation for HCL 6.

Thanks, I updated the original with all the current quests (thanks to Erofen for his help) and added a few more information boxes.

[Qadashael]

Thanks, I updated the original with all the current quests (thanks to Erofen for his help) and added a few more information boxes.

Thank you for the updates! I have removed all links to the one I uploaded earlier now that the official one has the new quests. I do use this even when HCL isn't up to track favor and add quests on release to my file locally, but will keep those offline from now on.

I apologize if I ruffled any feathers.

[FURYous]

Thank you for the updates! I have removed all links to the one I uploaded earlier now that the official one has the new quests. I do use this even when HCL isn't up to track favor and add quests on release to my file locally, but will keep those offline from now on.

I apologize if I ruffled any feathers.

You are fine, I love the bug reports and other input. Please keep it up.

I just got a bit ticked when someone claimed their version was the only one not filled with bugs and lacking features. If you want to do your own project, great, the more options the better, but to take someone else's work, tack on quests that came out since the last revision, add some minor edits, then bad mouth everything you built your changes on, poor form.

I encourage you guys to make your own spreadsheets and add whatever you like but if it is going to be based on my work, just give credit and don't bad mouth it. If it was good enough to use as a bases for your work, then it really couldn't have been all that bad.

[FURYous]

Added back in 6 star (this is if you get 5 stars plus the bonus favor) to challanges.
Other minor changes.

[Erofen]

You are fine, I love the bug reports and other input. Please keep it up.

I just got a bit ticked when someone claimed their version was the only one not filled with bugs and lacking features. If you want to do your own project, great, the more options the better, but to take someone else's work, tack on quests that came out since the last revision, add some minor edits, then bad mouth everything you built your changes on, poor form.

I encourage you guys to make your own spreadsheets and add whatever you like but if it is going to be based on my work, just give credit and don't bad mouth it. If it was good enough to use as a bases for your work, then it really couldn't have been all that bad.

This is not at all what happened and we already went over this.

[FURYous]

This is not at all what happened and we already went over this.

https://i.imgur.com/MvYnXst.jpeg

Not trying to restart a disagreement ;)

Now, I understand that you did not mean it that way, but when I first seen it, that was the way I read it. Thus the disagreement

[FURYous]

Added a chart that shows how many quests there are per level. Sometimes doing a level's worth of quests took a very long time so I was curious.

[Thugblood]

This is great. Wow. Many thanks!

[FURYous]

Minor updates

[FURYous]

Minor updates

[Erofen]

Here is the link again so it doesn't get lost (the link should stay the same every season, so feel free to just bookmark it so you can have the latest version each HC season): https://drive.google.com/file/d/13Em7HfStMalp6Kx9zMDG6LS0w5L_qny_/view?usp=sharing
Updated with the new ToEE favor (yes, both versions are on the spreadsheet, because if you completed the old one before the change, you can keep its favor (for now))

[Kaliya]

Love the CI/CD, guys!

Is there an easy way to update the latest version with mg older version populated data?

Apologies if this has already been covered and I missed it.

[Erofen]

Love the CI/CD, guys!

Is there an easy way to update the latest version with mg older version populated data?

Apologies if this has already been covered and I missed it.
Unfortunately not afaik because it is just a spreadsheet. You'd just have to track the changes and copy paste them.

[FURYous]

Updated with the new TOEE quests.

[huntdawumpus]

Thank you for the TOEE update. The base favor for TOEE: Lower Temple Complex should be 6 instead of 5. TOEE: Air Node is missing.

[FURYous]

Thank you for the TOEE update. The base favor for TOEE: Lower Temple Complex should be 6 instead of 5. TOEE: Air Node is missing.

Fixed.

[Crell_1]

The level 9 quest "The Threnal Arena" should have a base favor of 5 (15 on elite) and be for house K.

That makes the total possible for the faction mismatch the wiki, but I can't figure out where the other corresponding error is.

[Erofen]

The level 9 quest "The Threnal Arena" should have a base favor of 5 (15 on elite) and be for house K.

That makes the total possible for the faction mismatch the wiki, but I can't figure out where the other corresponding error is.
Yah, no. You are thinking of Tharashk Arena.

Here is the information on The Threnal Arena (which is correct in the spreadsheet): https://ddowiki.com/page/The_Threnal_Arena

[Crell_1]

Yah, no. You are thinking of Tharashk Arena.
You're right, My apologies!

[FURYous]

Updated for season 7

[Gambrel]

Updated for season 7

Thank you for sharing! This is wonderfully useful. Your work is appreciated. :D

[FURYous]

Fixed a calculation error on number of quests needed to match the new 3k favor requirement instead of the old 5k.