Favor Tracking Spreadsheet

[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/13Em...ew?usp=sharing