Favor Tracking Spreadsheet

Quote:

---

Originally Posted by FURYous

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).

Quote:

---

Originally Posted by FURYous

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.

Quote:

---

Originally Posted by 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. :)

Quote:

---

Originally Posted by Erofen

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.

Quote:

---

Originally Posted by Erofen

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.

Quote:

---

Originally Posted by Erofen

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.

Quote:

---

Originally Posted by Erofen

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

Quote:

---

Originally Posted by 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.

---

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

Quote:

---

Originally Posted by FURYous

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.

Quote:

---

Originally Posted by Qadashael

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.

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

Quote:

---

Originally Posted by FURYous

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.

Quote:

---

Originally Posted by Erofen

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

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.

This is great. Wow. Many thanks!

Minor updates

Minor updates

Quote:

---

Originally Posted by 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/13Em...ew?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))

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.

Quote:

---

Originally Posted by 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.

---

Unfortunately not afaik because it is just a spreadsheet. You'd just have to track the changes and copy paste them.

Updated with the new TOEE quests.

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.