b1ur
Active member
- Oct 16, 2018
- 126
- 173
- 43
- Mar 17, 2020
- #1
Introduction
This threads purpose is to compile every useful D2 related spreadsheet into one easy to browse through place. All of the spreadsheets I come across or are send to me will be uploaded as .zip archives on Google Drive and kept locally just in case. Keep in mind my MS Excel skills top out at writing text and coloring the blocks so if you need help using any of the provided spreadsheets and can't find information on it I will probably not be able to help. All credits of course go to their creators, they are the ones you should be thanking. I'm simply putting them all in one place for easy access.
If you want to share a spreadsheet feel free to PM me.
How to use with Google Docs
(WIP)
- The SPF Spreadsheet Compilation -
MF/RF Spreadsheets
Magic Finding Efficiency by Owlie - .xlsx archive | Info
Countess Rune Odds by Luhkoh - .xlsx archive | Info
Rune Calculator by Luhkoh - .xlsx archive | Info
Damage Calculators
A2 Merc Damage for Various Setups by Owlie - .xlsx archive | Info
Pitzerker Attack Rating and Damage by Luhkoh - .xlsx archive | Info inside document
Pitzerker Simulator (macro) by Luhkoh - .xlsm archive | Info
Item Generation
TC and qlvl list (sortable) by Luhkoh - .xlsx archive
Superchest Patterns by Luhkoh - .xlsx archive
Holy Grail
Holy Grail Spreadsheet by TestyFish - .xlsx archive
Holy Grail Remaining by Luhkoh - .xlsx archive
***
(to be continued...)
Last edited:
Reactions:
Pb_pal and D2DC
b1ur
Active member
- Oct 16, 2018
- 126
- 173
- 43
- Mar 17, 2020
- #2
(reserved for possible later use)
D2DC
PurePremium
- Sep 12, 2013
- 4,903
- 1,721
- 113
- Mar 17, 2020
- #3
@b1ur - The Drive link worked (read-only), but was almost blank? The .zip archive said "whoops there was a problem .. retrying" but didn't download. The third link works fine.
b1ur
Active member
- Oct 16, 2018
- 126
- 173
- 43
- Mar 17, 2020
- #4
D2DC said:
@b1ur - The Drive link worked (read-only), but was almost blank? The .zip archive said "whoops there was a problem .. retrying" but didn't download. The third link works fine.
Thanks for checking.
Drive link - The spreadsheet has multiple sheets you should be able to see on the bottom where most of the contents are.
.zip archive - It tends to do this most of the time as it tries to read the contents of the .zip. There's a download link at the top right.
My best guess is it does work as intended but the Drive is not very intuitive to use.
Luhkoh
Well-known member
Guide Author
- Jan 3, 2019
- 1,480
- 1,593
- 113
- Mar 17, 2020
- #5
Very nice! I've got...a few.... of these . Will do a batch post for you tomorrow if I don't get to it tonight.
Reactions:
b1ur
TestyFish
Member
- Mar 17, 2020
- 25
- 36
- 13
- Mar 18, 2020
- #6
Here is a link to my version of the Grail Spreadsheet. I know there are many, but mine is the only one that has both item name and unique name with the subcategory percentages summed up on a summary page.
Luhkoh
Well-known member
Guide Author
- Jan 3, 2019
- 1,480
- 1,593
- 113
- Mar 18, 2020
- #7
Glad you already took care of the most important sheet (Owlie's MF efficiency sheet). Here are most of my sheets that a few people thought were useful. If you don't mind updating the countess runes link too, I made a new google account to have the spreadsheet sharing more anonymized. Also google drive is just bit unresponsive and buggy. If you could check to see that these links point to a spreadsheet with a similar title, I'd appreciate it.
Rune Calculator
Pitzerker AR&dmg
Pitzerker Simulator (excel macro that can be downloaded, wont run on google sheets)
TC & qlvl list (sortable)
Superchest Patterns
Countess Rune Odds
Holy Grail Remaining
I will also be reposting my threads about some of these at some point in the future. I know there's a lot to say or explain about the the countess calc, rune calculator, and especially pitzerker simulator.
b1ur
Active member
- Oct 16, 2018
- 126
- 173
- 43
- Mar 18, 2020
- #8
Maybe it would be a good idea to just use .xlsx archives altogether? After all if someone wants to use google docs it's easily imported via the original Excel. I will temporarily remove the Drive links until I decide which is the best option.
Also, thank you very much for sharing all of your spreadsheets! I'll add them as soon as I have enough free time.
Luhkoh
Well-known member
Guide Author
- Jan 3, 2019
- 1,480
- 1,593
- 113
- Mar 18, 2020
- #9
I think people like being able to just click a link, click make a copy, and start using. Rather than having to import an xlsx. That being said I don't think it matters too much and SPF members are generally capable of opening a file (unlike people on... say... reddit ).
b1ur
Active member
- Oct 16, 2018
- 126
- 173
- 43
- Mar 18, 2020
- #10
@Luhkoh I will write a short guide just in case hehe. But I'll do it when I'm at work and have a bunch of free time. Doing that kind of thing on a Mac is a million times easier I'd have to admit despite the fact I hate them
Other than that I've updated the first post with all of the new stuff and restyled it a bit. If you have any suggestions feel free to throw them my way!
Reactions:
Luhkoh
Luhkoh
Well-known member
Guide Author
- Jan 3, 2019
- 1,480
- 1,593
- 113
- Mar 18, 2020
- #11
Here's the link to the simulator discussion. Looks good!
maxicek
Moderator
Moderator
Guide Author
- Aug 5, 2005
- 8,100
- 2,616
- 113
- Mar 18, 2020
- #12
There are already a load in the community & links thread when I move it over. The biggest problem is all the cross links in it though.
b1ur
Active member
- Oct 16, 2018
- 126
- 173
- 43
- Mar 19, 2020
- #13
When/if the authors decide to migrate their threads in here I'll update the information links. Also I'll dig through the community & links thread I didn't realise there were many spreadsheets there
TestyFish
Member
- Mar 17, 2020
- 25
- 36
- 13
- Mar 20, 2020
- #14
Not to nitpick, but my name is TestyFish, not TestyFist. ;-)
Log in to Reply / Create Site Account or log in with
BattleNet Discord Twitch Google