Started this project a while back, but decided to wipe the slate clean with the new patches. This is for those that want to take a look at what to expect from high MF farming the goblins in act 2. This is just my data from solo farming, but others are welcome to save a copy of the sheet for their own use.
What it tracks:
Total number of runs
Which goblin type spawned in each run
Overall goblin spawn rate
Average loot type distribution
Goblin type distribution
ilvl of loot
What you need to input:
Goblin Type
Common Loot Count
Magic Loot Count
Rare Loot Count
Legendary Loot Count
Set Loot Count
Gem Count (I only track Flawless squares)
Tomes Of Secrets Count
ilvl 61-63 Loot Count
The only sheet that needs user input is the "Running Tally" sheet, all others are calculated. I did this mainly for my own purposes, but have recently seen a lot of questions regarding this farm spot, so just thought I'd make this public.
If there is anything I've missed, botched, or otherwise should change/add; please let me know.
Edit: If you would like a copy of this for your own use, goto File > Make a copy.
Then clear out the "Running Tally" sheet and you can start tracking your runs with whatever MF% you have.
For informational purposes, you can put in your MF% on the "Totals" page.
1
What it tracks:
Total number of runs
Which goblin type spawned in each run
Overall goblin spawn rate
Average loot type distribution
Goblin type distribution
ilvl of loot
What you need to input:
Goblin Type
Common Loot Count
Magic Loot Count
Rare Loot Count
Legendary Loot Count
Set Loot Count
Gem Count (I only track Flawless squares)
Tomes Of Secrets Count
ilvl 61-63 Loot Count
The only sheet that needs user input is the "Running Tally" sheet, all others are calculated. I did this mainly for my own purposes, but have recently seen a lot of questions regarding this farm spot, so just thought I'd make this public.
If there is anything I've missed, botched, or otherwise should change/add; please let me know.
Link: http://www.tinyurl.com/gobfarm
Edit: If you would like a copy of this for your own use, goto File > Make a copy.
Then clear out the "Running Tally" sheet and you can start tracking your runs with whatever MF% you have.
For informational purposes, you can put in your MF% on the "Totals" page.