Tag: mathcrafting

[D3] Quin69 analyzes the area damage weapon property in Diablo 3

YouTuber Quin69 goes into the mechanics of the "area damage" weapon property. The initial overview of the rules of area damage functionality is followed with a powerfully convincing mathematical calculation to demonstrate its efficacy relative to other DPS properties. I found the entire video both entertaining and enlightening despite not being a D3 player. I think you will enjoy it too.

[LoL] RheingoldRiver’s “How to Theorycraft Effectively”

RheingoldRiver’s How to Theorycraft Effectively provides excellent guidance for analysts and theorists, with well-put general advice supported by specific suggestions for effectively gaining insight using a spreadsheet tool. I strongly recommend reading her post in full, as she goes into the specifics of constructing an effective question and the spreadsheet targeted at answering it. At the highest level, the steps she goes into are:

  1. Choose a good question
  2. Decide what stats you need to answer the question
  3. Figure out what intermediate values you need, and calculate them
  4. Make your formulas universal enough that you can autofill EVERYTHING!
  5. Decide how you want to present the final data, and fill in that formula
  6. Make sure everything is correct
  7. Duplicate your chart with other starting values
  8. Make gameplay decisions based on your numbers