KMS Conversion Spreadsheet Walkthrough

Walk through for a popular resource in KMS for getting into parties, comparing gear, and informing themselves of soloable content. Easy to fill out once you get the hang of it~
-
ExclusiveKpr and AbandenHope's Guide: https://docs.google.com/document/d/1n_1tBQ96-FGGEUXtYX_GVXIu8n9FGl3gbZGuBpTEU2I/edit

Links to the spreadsheet are in the Translated guide.
Version I used in this tutorial: https://docs.google.com/spreadsheets/d/1wDRvBVX5hcXhJUoIgqGD28KorrSxf1NVa_0ohWwSSa0/edi #gid=1397551479

The cell for fixing your range (if its slightly off) is: '계산'$U$41 and you want to select "rounddown((I37+I38)*U38*(1+I40/100)*(1+I42/100)*I44/100)" in the formula bar
Thanks to aCyr for this tech

Lots of thanks to the folks in Kobe's discord who have helped me learn how to use this to inform myself and I hope it will help all of you (:
--
Things to watch out for:
- Turn familiars on
- Don't forget to turn MW back on after filling in stats
- Attack % must be multiple of 3 - Round up or down until the calculator works (lol)
- Attack Speed 0 Final Damage Adjustment: You need to know this value for your own class! Then you put it in cell X19
- Min Cut = Minimum Damage Solo: KMS standard is ~80% NOT 100% (for the best classes) - some classes can be disadvantaged or advantaged towards bosses
--
NOTE: After consulting with others, i've been told my bishop's sheet looks about right and that I just need to git gud LOL.

I also forgot to add that cells J27 - K40 are how you can tell how much FD per 1k conversion is. In my Bishop's sheet it says +1천=1.054 which means +1k Conversion = 1.054x (5.4 FD) so you can use this to compare to others in your class or tell how much gear FD difference you and someone else may have.
--
shoutoutmeruforchapters
0:55 - Reasons for using the Conversion Spreadsheet
3:47 - Filling out the Spreadsheet
11:20 - Things to watch out for
13:55 - What to do if your class is buffed/nerfed (and your FD does not match)
15:25 - Range troubleshooting
18:58 - Boss performance metrics (see note in desc)
23:17 - GMS AS0 FD adjustment
24:45 - Hyper Stat Optimization
26:03 - Gear Comparison (see note in desc)
29:00 - How to use the boss performance metrics (including Min Cut explanation)