Drop Tracking Spreadsheet, your farming BFF ! WiP, help appreciated!

Borderlands 3 Loot and Weapons
#1

Here is a spreadsheet to help you track your drop.

It’s a WiP.

I have made the original template that can be customised to track drop from any boss. Use in coordination with johnirby86 's spreadsheet on loot location for an easiest time. My spreadsheet is honestly kind of useless without his work, thanks for the work fellow VH !

I’ll gladly accept any help completing it since i have only done Sky Bullies sheet and no other boss at the moment.

To contribute, the simpliest way i have thought off at the moment is for any people interested in helping to to simply dl it, create a boss template and post the link here so that i can add it later.
If you see that same topic on reddit, it’s normal, i posted there first because i wasn’t sure if i should post it here.

If you think of anything that could be added, any comment is appreciated.

1 Like
Dedicated Loot Pools Miss The Mark
#2

oh nice! i’ve been tracking all my farming runs and having this premade template will help a lot. TY

#3

Great that could be of help !

i could add a little bit more depht to the template by separing the annointed drop of grenade and shield from the item pool is i know for sure that grenades have a separated annointed drop rate and i’m not too sure about the shield annointed drop.
Grenade there’s no doubt about it since they never spawned before the annointed week of 10th year anniversary celebrations.
But that would add 2 columns on each rarity, with even more total here and there and it’s already quite a heavy template already. I doubt that many would track drops from rarity bellow purple and i’m missing space for the total % legendary drop and annointed drop.

Now that i’m thinking about it, having 2 more totals wouldn’t hurt. One for the world drop, the other for the dedicated & unique drop since they are separated.

#4

So I’ve done a couple 100 run/kill tracks. First I did 100 kills on The Unstoppable. Next I ran Trial of Discipline on Zane 100 times and tracked my efforts to get Anti-Freeze coms. In my future tracking runs I will use this spreadsheet, but for now here are my results:

100 “Trial of Disciplne” completions. Ran on Zane - TVHM M4

WLD = World Drop (Any Legendary besides COM’s)
AN = Anointed
COM = Class Mod
M/F/A/Z/AF = Moze/Fl4k/Amara/Zane/Anti Freeze
# = # of Legendary

Invulnerable Triage Commando Count - 11 (requiring restart)

12-01-19
0-0-0-0-0 0-0-0-0-0
0-0-0-0-0 1(COM/M)-1(COM/M)-0-1(COM/F)-1(COM/AF)
0-0-0-0-0 0-0-0-0-0
12-02-19
1(COM/AF)-0-0-0-0 0-0-0-0-0
1(COM/Z)-0-0-0-1(COM/AF) 0-0-1(COM/Z)-0-0
0-0-0-0-0 0-0-0-1(COM/M)-1(COM/F)
0-0-0-0-0 0-0-1(COM/M)-0-1(COM/M)
0-0-0-0-0 12-03-19 0-0-0-1(COM/F)-0
0-0-0-1(COM/Z)-1(WLD) 0-0-0-0-0
0-0-1(COM/F)-0-0 0-0-0-1(WLD/AN)-0

12-01-19 100 “The Unstoppable kills”

DEV = Devastator -Dedicated
BBB = Big Boom Blaster -Dedicated
BOS = Band of Sitorak -Specific
WLD = World Drop

Y/N/CA = Anointed/Not Anointed/Class mod-Artifact
# = # of Legendary

0-0-0-0-0 0-0-0-1(DEV/N)-0
0-0-0-0-0 1(DEV/Y)-0-0-0-0
0-0-0-0-0 0-0-0-0-0
1-(BOS/N)-0-1(BOS/Y)-0-0 0-0-0-0-0
0-0-0-0-0 0-0-0-0-0

0-0-0-0-0 0-0-0-0-0
0-1(DEV/N)-0-0-0 0-0-0-0-1(BBB/N)
0-0-1(WLD/CA)-1(DEV/N)-0 0-0-0-0-0
0-0-0-1(BOS/Y)-0 1(DEV/Y)-0-0-0-0
0-0-0-0-1(WLD/Y) 0-0-0-0-0
1 Like