Looking For: Spreadsheet Calculators

[Khrysaes]

Hello,

I am performing a project for a statistics course and looking for any calculators for 5th edition that are built in google sheets or excel. I am using the search feature, but I thought I would make a thread to help me.

I know I have seen many, damage calculators and whatnot, so the thread may help me find ones I missed

Thank you

[Khrysaes]

Here is the first one I found

Thread: https://forums.giantitp.com/showthread.php?582779-Comprehensive-DPR-Calculator-(v2-0)

Direct Link:
https://docs.google.com/spreadsheets/d/14WlZE_UKwn3Vhv4i8ewVOc-f2-A7tMW_VRum_p3YNHQ/edit

[Khrysaes]

Not an actual calculator, but I am adding Detect Balance

https://docs.google.com/spreadsheets/d/1vq1kz6PRAbw5LHy6amH-bNb4OuB8DBXL1RsZROt03Sc/edit#gid=1437537911

And Detect Greater Balance
https://forums.giantitp.com/showthread.php?572364-Detect-Greater-Balance-%96-A-Critical-Review-of-Homebrew-Race-Creation

https://docs.google.com/spreadsheets/d/1XQ9shwsH5tu2s4Nt4J2Lie-pY4_G8CYhjB-yuJ7FlTk/edit#gid=1880237047

[Khrysaes]

These may be out of date, but here are some stat analyses

https://oganm.github.io/dndstats/

https://www.displayr.com/dungeons-and-data-science/

https://github.com/cyberscribe/d20datascience#d20datascience

http://surfarcher.blogspot.com/2014/12/d-5e-monsters-part-10-construction-cr.html

http://blogofholding.com/?p=7338

https://towardsdatascience.com/dnd-exploratory-analysis-using-r-d13757b09768?gi=5b1a32be3410

https://github.com/oganm/dnddata

[Man_Over_Game]

I, uh, have a calculator that determines a player's most ideal class, race and subclass.

Does that fit what you're looking for, or are you just looking for combat-related stuff?

[Khrysaes]

I, uh, have a calculator that determines a player's most ideal class, race and subclass.

Does that fit what you're looking for, or are you just looking for combat-related stuff?

Yes..

Basically I want to analyze the mechanics of 5e. I also don't want to redo a bunch of work that is already done.

The Githubs i listed have repositories of data for a lot of things, so if I copy and paste and expand upon it, I am not redoing the wheel.

Same with the calculator by Ludic.

So yes, that calculator may be useful. As of right now, I am just going through each book item by item and adding it to a spreadsheet.

[Man_Over_Game]

Yes..

Basically I want to analyze the mechanics of 5e. I also don't want to redo a bunch of work that is already done.

The Githubs i listed have repositories of data for a lot of things, so if I copy and paste and expand upon it, I am not redoing the wheel.

Same with the calculator by Ludic.

So yes, that calculator may be useful. As of right now, I am just going through each book item by item and adding it to a spreadsheet.

Gotcha. It might not be easy to parse for backwards compatibility, though. As is, it asks the player a few questions to rank from 1-10, while each of the different classes are sorted into rankings for those positions (so if I ask "Do you want more Melee or more Range", and you say "1", it'll think you want "Very Melee" and will be more likely to suggest a Barbarian).

I mostly did it as a means of teaching myself Excel stuff, so some of it might not be terribly efficient. Not all of the new subclasses have been finished yet in the subclass tab. Still, it seemed really accurate for what people were looking for when I first started getting reviews for it.

https://drive.google.com/file/d/19EYPrEofoLANqgS0TL5MQ_kvSXhf02Nc/view?usp=sharing

[Khrysaes]

I know it is a bit of necromancy...


But: DPR of Classes

https://docs.google.com/spreadsheets/d/1d-9xDdath8kX_v7Rpts9JFIJwIG3X0-dDUtfax14NT0/edit?usp=sharing

[Quietus]

This one is kind of a mess, but I built it specifically to test out what the most optimal damage was for a Beastmaster using Tasha's rules for beasts. I do apologize that it's not terribly user friendly yet, but feel free to reach out if you have questions about how/why I did anything here.

https://docs.google.com/spreadsheets/d/1fmZOPzowTm5mU2fkshhdqiQVX5oJ3Kl1wTfZH-fpWP0/edit?usp=sharing