Spreadsheet Compilation (2024)

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:

  • Spreadsheet Compilation (2)

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

Spreadsheet Compilation (5)Spreadsheet Compilation (6)

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. Spreadsheet Compilation (7)

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. Spreadsheet Compilation (9)

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. Spreadsheet Compilation (10)

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 Spreadsheet Compilation (12). Will do a batch post for you tomorrow if I don't get to it tonight.

  • Spreadsheet Compilation (13)

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.

TestyFish's Grail Spreadsheet

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 Spreadsheet Compilation (18)).

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 Spreadsheet Compilation (20)

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!

  • Spreadsheet Compilation (21)

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

Spreadsheet Compilation (24)

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 Spreadsheet Compilation (26)

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
Spreadsheet Compilation (2024)

References

Top Articles
How Much Does Chrissy Metz Weigh
Chrissy Metz's Weight Loss Secrets: How She Lost 100 Pounds
2016 Hyundai Sonata Refrigerant Capacity
Wyoming Dot Webcams
Raleigh Craigs List
Rickrolling Link Generator
Levidia 2019
Www.citizen-Times.com Obituaries
Jak zgłosić awarię i brak energii elektrycznej w Twoim mieszkaniu lub domu? - ENERGA-OPERATOR SA
Nazir Afzal on the BBC: ‘Powerful predators were allowed to behave terribly on an industrial level’
Sigma Aldrich Calculator
Nusl Symplicity Login
M&T Bank Atm Locations Near Me
Stellaris Mid Game
Ticket To Paradise Showtimes Near Laemmle Newhall
How To Get To Brazil In Slap Battles
Gt7 Roadster Shop Rampage Engine Swap
Thomas Funeral Home Sparta Nc
Wdel News Today
Dealer 360 Login Generac
Integrations | Information Technology
The Closest Dollar Store To My Location
Booty Chaser Bingo Locations In Minnesota
Summoners War Update Notes
Cbs Local News Sacramento
BugBitten Jiggers: a painful infestation
Carefirst.webpay.md
MyChart | University Hospitals
Food Delivery Near Me Open Now Chinese
Q102 Snow Desk
Palladium-Item from Richmond, Indiana
Davias Grille
Nike Factory Store - Howell Photos
Restored Republic December 1 2022
Publix Christmas Dinner 2022
Wolf Of Wallstreet 123 Movies
Dramacool Love In Contract
Wyr Discount Code
Landwatch Ms
Flight 1173 Frontier
Osceola County Addresses Growth with Updated Mobility Fees
Los Alamos Beach in Torremolinos: A Perfect Mediterranean Escape - Mama Málaga
Ruth Chris 3 Course Meal
2Nd Chance Apartments In Richmond Va
Chess Unblocked Games 66
Sun Massage Tucson Reviews
Sxs Korde
Gen 50 Kjv
Rubrankings Austin
What Does Wmt Contactless Mean
Vimeo Downloader - Download Vimeo Videos Online - VEED.IO
Latest Posts
Article information

Author: Dong Thiel

Last Updated:

Views: 5739

Rating: 4.9 / 5 (79 voted)

Reviews: 94% of readers found this page helpful

Author information

Name: Dong Thiel

Birthday: 2001-07-14

Address: 2865 Kasha Unions, West Corrinne, AK 05708-1071

Phone: +3512198379449

Job: Design Planner

Hobby: Graffiti, Foreign language learning, Gambling, Metalworking, Rowing, Sculling, Sewing

Introduction: My name is Dong Thiel, I am a brainy, happy, tasty, lively, splendid, talented, cooperative person who loves writing and wants to share my knowledge and understanding with you.