Favor Tracking Spreadsheet

[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/13Em...ew?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/13Em...ew?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!