PDA

View Full Version : Favor Tracking Spreadsheet



FURYous
02-21-2020, 09:17 PM
This is an updated spreadsheet that includes the new borderlands quests and some other updates to make it easier to use.

Spreadsheet download (https://drive.google.com/file/d/1-LK66Em1fbY9pCzeYMpJzPLpFDNhPnmK/view?usp=sharing)


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. I have 58 quests skipped and am still showing well over 5100 favor planned. 2014 already earned so far.


download the file or open in sheets
the only thing you need to do is pick Reaper, Elite, Hard, Normal 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/BjuGbI0.jpg

Spreadsheet download (https://drive.google.com/file/d/1-LK66Em1fbY9pCzeYMpJzPLpFDNhPnmK/view?usp=sharing)

FURYous
02-22-2020, 10:43 AM
Warning, the auto color coding of lines doesn't seem to work well in Google Sheets, you can use sheets but Excel will provide a better experience with some of the features of the spreadsheet. For instance, if you choose "Elite" the quest name will change to a different color than if you choose "Normal" or "Skip" ETC.

Note, I think I fixed this but other issues may remain with Google Sheets that I am not away of. Please let me know if you notice something.

FURYous
02-22-2020, 07:41 PM
Added challenges and reformatted some stuff, I also made some formula changes

Thanks mikarddo for the great input!!!

FURYous
02-23-2020, 03:57 PM
If you are using this, let me know please. I don't mind doing the work but if no one uses it, I won't bother posting it here.

Also if you are using it, give me input on things you would like to see that is may be missing.

FURYous
02-23-2020, 09:14 PM
Another big update. Take a look.

Graskitch
03-06-2020, 03:27 PM
thanks for making and updating this - it is very useful to plan out what to skip.

question: in excel is the favor that you earn for solos and challenges not calculated properly by formula into the EARNED so far amount?

I use the drop-down to select SOLO or "5 STAR" but the EARNED value does not seem to update. Should I just be using the corresponding value (I think it would be NORMAL for the SOLOS, and REAPER (5) for the challenges.

Dark_Lord_Mary
03-09-2020, 05:13 PM
This spreadsheet is fantastic - thank you - I have been recommending it to people.

Great Job!