CP distribution.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
CP Distribution for Thieves Guild
2
3
Introduction to what this spreadsheet does
4
http://tamrielfoundry.com/topic/pts-2-1-2-sorcerer-arithmagic/page/19/#post-640374
Input cell
5
Example parse for a stamina DK
https://forums.elderscrollsonline.com/en/discussion/comment/2760032/#Comment_2760032
Output cell
6
If any of the inputs are not that clear, post a comment in the thread above and I'll explain it there or add comments to the input fields here
7
To use this spreadsheet click File -> Make a copy
8
Elfborn Jump Points
9
Free web host
10
I exceeded the server limit on the previous host >.> I honestly don't know what I did but here is a new host. I'll try not to mess this one up
11
http://asayre.mygamesonline.org/CPOptimisation/CPOptimisation.html#
12
13
InputsTooltip00
14
Outputs
15
Number of Champion Points
187PointTooltip
16
Spell Critical Chance0.723Elemental Expert89238973
17
Spell Critical multiplier0.5Critical damage / Non-Critical damage - 1Thaumathurge6318.16371
18
Target Resistance12920Most veteran bosses have spell resistance ~18k. This is reduced to ~13k by Major BreachStaff Expert000
19
Target Level50Most veteran level mobs are level 50Elfborn2910.52918
20
Percentage Penetration0Leave at 0 for most casesSpell Erosion640665
21
Flat Penetration10144At least 4984 for Magicka users. 100 [Base] + 4884 [Concentration, Light Armour passive]. Add the sum of sharpened here
22
Advanced Output
23
Elemental Ratio0
No need to change
24
DoT Ratio0.9max f1.9120689
Additional checks
25
Staff Ratio0.1max f 12.087626609
Mitigation
0.04740282268
26
f11.3929
27
Precisef21.44103
28
f30.95261.752357
29
Advanced Inputs
30
31
Maximum points187
32
Elemental Expert100
33
Thaumathurge100
34
Staff Expert100
35
Elfborn100
36
Spell Erosion100
37
38
39
Major Force Toggle0Set to 1 for Major Force, otherwise set to 0
40
Major Force Value1
41
42
43
26
44
32
45
1.796278
46
47
48
49
0.40.4
50
51
52
Changes
53
25/2/16
Will only suggest elfborn jump points now
54
Added tooltip for recommended number of points
55
Changed equation modelling Elemental Expert and Spell Erosion
56
57
8/3/2016
Added another spreadsheet for stamina builds
58
It is not very smart at the moment and will choose non-Precise Strike jump points
59
60
10/3/2016
Helpful post relating to this spreadsheet
61
Stamina DK parse example: http://forums.elderscrollsonline.com/en/discussion/comment/2760032/#Comment_2760032
62
Link above also tries to explain why you have so many points in Spell Erosion
63
64
16/3/2016
I realised that i accidentally moved Percentage Penetration into Target Level
65
I restored to an earlier version. Sorry =(
66
DoT Ratio
67
1/6/2016
You can now set the maximum number of points that can be allocated
68
Added option to calculate for Major Force
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Magicka
Magicka function calcs
Stamina
Stamina function calcs
table