This is amazing! Great job![]()
Great work, thanks!
Cannith - Juzam, Fighter 8 Ranger 6 Monk 6 AA/ Orocarn, Wraith 12 Stalwart Defender 6 Rogue 2 / Taigongwanng, Sorc TRing - Alleanza degli Uomini Liberi/Guardiani di Eberron
Do not give a care about favor rewards
Top job anyway.
+1 excellent gaming tool. Thanks also for those that made it Google sheets compatible.
I am Awesomesauce!
Updated with all the new quests
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
Noticed solo quests if drop down is marked "solo" for difficulty it doesn't work right, you have to mark normal?
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.
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
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.
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
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.
,,,
Last edited by FURYous; 04-06-2021 at 03:33 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
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![]()
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
Added challenges and a few other improvements
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
Minor updates to calcs
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
it took me a while to figure it out but:
has been added to the spreadsheet to calc the total patron favor for ALL quests, even solo and challengesCode:=(SUMIFS(E:E,J:J,Q15,C:C,"Solo"))+(SUMIFS(E:E,J:J,Q15,C:C,"<>Solo")*3)![]()
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
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.
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
Added Update 49 quests
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 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
Last edited by Erofen; 05-12-2021 at 04:49 AM.