ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCV
1
012345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091
2
Enter Character Name Here
Note: This is a modified version of Elfarran's spreadsheet trainer. I've modified and improved it over the years, but credit belongs to Elfarran for the original design. --Tsoran
3
GemStone IV
Spreadsheet V4.6
Tsoran deArgonoth http://www.tsoran.com/ mailto:tsoran@tsoran.com AIM: GSTsoran
4
CMAN tables updated by Bobmuhthol mailto:bobmuhthol@gmail.com AIM: Bobmuhthol
5
Inter-Level
Monk Information updated by Kithus mailto:kkorandanis@gmail.com AIM: KithusSilverStrk
6
Modified
7
Stats
Statistics Growth
8
Level0
9
Class440012345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091
10
STR40604040414142424343444445454646474748484949505051515252535354545555565657575858595960606161616262626363636464646565656666666767676868686969697070707171717272727373737474747575757676767777
11
Race4CON40584040414142424343444445454646474748484949505051515252535354545555555656565757575858585959596060606161616262626363636464646565656666666767676868686969697070707171717272727373737374747474
12
Hidden Level:101DEX96100969696969696979797979797989898989898999999999999100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100
13
Target Level: 40AGL65786565656666666767676868686969697070707171717272727373737474747575757676767777777878787979798080808181818182828282838383838484848485858585868686868787878788888888898989899090909091919191
14
DIS50705050515152525353545455555656575758585959606061616262636364646565666667676868697070707171717272727373737474747575757676767777777878787979798080808181818282828383838484848585858686868787
15
AUR70797070707071717171727272727373737374747474757575757576767676767777777777787878787879797979798080808080818181818182828282828383838383848484848485858585858686868686878787878788888888888989
16
Experience: 1,730,000LOG62806262636364646565666667676868696970707171727273737474757676767777777878787979798080808181818282828383838484848585858686868787878888888989899090909191919292929393939494949595959696969797
17
INTS8497848484858585868686878787888888898989909090919191929292939393949494959595969696979797989898999999100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100
18
Next TP At: 1,731,401WISP,M7694767677777878797980808181828283838484858586868787888889899090919191929292939393949494959595969696979797989898999999100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100100
19
INF778877777778787879797980808081818181828282828383838384848484858585858686868687878787888888888989898990909090919191919292929293939393949494949595959596969696979797979898989899999999100100100100
20
21
Total660#################################################################################################################################################################################################################################################################################################################################################################################################################################################################################
22
Available
Used
23
Total TP:1,695475PTP40.0543.0040.0040.0040.0040.0040.0040.0040.0040.0040.0040.0040.0040.0041.0041.0041.0041.0041.0041.0041.0041.0041.0041.0042.0042.0042.0042.0042.0042.0042.0042.0042.0042.0042.0042.0043.0043.0043.0043.0043.0043.0043.0043.0043.0043.0043.0043.0043.0043.0044.0044.0044.0044.0044.0044.0044.0044.0044.0044.0044.0044.0044.0044.0044.0044.0044.0045.0045.0045.0045.0045.0045.0045.0045.0045.0045.0045.0045.0045.0045.0045.0045.0046.0046.0046.0046.0046.0046.0046.0046.0046.0046.0046.00
24
2,179475MTP50.9556.0050.0050.0051.0051.0051.0051.0051.0051.0052.0052.0052.0052.0052.0052.0052.0052.0053.0053.0053.0053.0053.0053.0054.0054.0054.0054.0054.0054.0054.0054.0055.0055.0055.0055.0055.0055.0055.0055.0055.0056.0056.0056.0056.0056.0056.0056.0056.0056.0057.0057.0057.0057.0057.0057.0057.0057.0057.0057.0057.0057.0058.0058.0058.0058.0058.0058.0058.0058.0058.0058.0058.0058.0058.0058.0058.0058.0058.0058.0058.0058.0058.0058.0058.0058.0059.0059.0059.0059.0059.0059.0059.0059.00
25
Post-Cap TP:0Health1198888888888888888888113115115115115116116116116117117117117117118118118118118118119119119119119119120120120120120120121121121121121121122122122122122122123123123123123123124124124124124124125125125125125125126126126126126126126127127127127
26
0Mana1299999999999999999999777981838587899193959799102105108111114117120123126129132135138141144144144144144144144144144144144144144144144144144144144144144144144144144144144144144144144144144144144144144144144144144144144144144144144
27
Total + Post-Cap:1,695Stamina54000000000000000000029303132333637383942424344454748485051515354545555555858585858585960606060606161616262626363636363646565656565656767676767676969696969697071717171
28
2,179Spirit877777777777777777777888888888888888888888888888888888888888888888888889999999999999999999999
29
Inter-Level
30
Note: "Target Level" must be set correctly for rank and 'X' counter (1x, 2x, 3x) to work properly.
Stat Bonuses
31
32
BonusGI40012345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091
33
STR205 (5)(5)(4)(4)(4)(4)(3)(3)(3)(3)(2)(2)(2)(2)(1)(1)(1)(1)0 0 0 0 0 0 1 1 1 1 2 2 2 2 3 3 3 3 4 4 4 4 5 5 5 5 5 6 6 6 6 6 6 7 7 7 7 7 7 8 8 8 8 8 8 9 9 9 9 9 9 10 10 10 10 10 10 11 11 11 11 11 11 12 12 12 12 12 12 13 13 13 13 13
34
CON18(1)(10)(10)(9)(9)(9)(9)(8)(8)(8)(8)(7)(7)(7)(7)(6)(6)(6)(6)(5)(5)(5)(5)(5)(5)(4)(4)(4)(4)(3)(3)(3)(3)(3)(2)(2)(2)(2)(2)(2)(1)(1)(1)(1)(1)(1)0 0 0 0 0 0 1 1 1 1 1 1 2 2 2 2 2 2 3 3 3 3 3 3 4 4 4 4 4 4 5 5 5 5 5 5 6 6 6 6 6 6 6 7 7 7 7
35
DEX1535 33 33 33 33 33 33 33 33 33 33 33 33 34 34 34 34 34 34 34 34 34 34 34 34 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35
36
AGL2019 12 12 12 13 13 13 13 13 13 14 14 14 14 14 14 15 15 15 15 15 15 16 16 16 16 16 16 17 17 17 17 17 17 18 18 18 18 18 18 19 19 19 19 19 19 20 20 20 20 20 20 20 21 21 21 21 21 21 21 21 22 22 22 22 22 22 22 22 23 23 23 23 23 23 23 23 24 24 24 24 24 24 24 24 25 25 25 25 25 25 25 25
37
DIS230 (10)(10)(10)(10)(9)(9)(9)(9)(8)(8)(8)(8)(7)(7)(7)(7)(6)(6)(6)(6)(5)(5)(5)(5)(4)(4)(4)(4)(3)(3)(3)(3)(2)(2)(2)(2)(1)(1)(1)0 0 0 0 0 0 1 1 1 1 1 1 2 2 2 2 2 2 3 3 3 3 3 3 4 4 4 4 4 4 5 5 5 5 5 5 6 6 6 6 6 6 7 7 7 7 7 7 8 8 8 8 8
38
AUR1524 20 20 20 20 20 20 20 20 21 21 21 21 21 21 21 21 22 22 22 22 22 22 22 22 22 23 23 23 23 23 23 23 23 23 23 24 24 24 24 24 24 24 24 24 24 25 25 25 25 25 25 25 25 25 25 26 26 26 26 26 26 26 26 26 26 27 27 27 27 27 27 27 27 27 27 28 28 28 28 28 28 28 28 28 28 29 29 29 29 29 29 29
39
LOG2515 6 6 6 6 7 7 7 7 8 8 8 8 9 9 9 9 10 10 10 10 11 11 11 11 12 12 12 13 13 13 13 13 13 14 14 14 14 14 14 15 15 15 15 15 15 16 16 16 16 16 16 17 17 17 17 17 17 18 18 18 18 18 18 19 19 19 19 19 19 20 20 20 20 20 20 21 21 21 21 21 21 22 22 22 22 22 22 23 23 23 23 23
40
INTS2528 22 22 22 22 22 22 23 23 23 23 23 23 24 24 24 24 24 24 25 25 25 25 25 25 26 26 26 26 26 26 27 27 27 27 27 27 28 28 28 28 28 28 29 29 29 29 29 29 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30
41
WISP,M3027 18 18 18 18 19 19 19 19 20 20 20 20 21 21 21 21 22 22 22 22 23 23 23 23 24 24 24 24 25 25 25 25 25 26 26 26 26 26 26 27 27 27 27 27 27 28 28 28 28 28 28 29 29 29 29 29 29 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30
42
INF2014 8 8 8 9 9 9 9 9 9 10 10 10 10 10 10 10 11 11 11 11 11 11 11 11 12 12 12 12 12 12 12 12 13 13 13 13 13 13 13 13 14 14 14 14 14 14 14 14 15 15 15 15 15 15 15 15 16 16 16 16 16 16 16 16 17 17 17 17 17 17 17 17 18 18 18 18 18 18 18 18 19 19 19 19 19 19 19 19 20 20 20 20
43
Inter-Level
44
P=Primary, S=Secondary, M=Mana
45
GS4 Level: 40012345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091
46
GS3 Level: 440001124567891011121315161718192021222324252627293031333435373840414344464749515254565759616264666870717375777981828486889092949698100102104106108110112114116118120122124126128130132135137139141
47
GS4 Experience per Level (1000's):
78.52.52.557.51012.51517.52022.52527.53032.5353739414345474951535556.55859.56162.56465.56768.57071.57374.57677.578.579.580.581.582.583.584.585.586.587.58888.58989.59090.59191.59292.59393.59494.59595.59696.59797.59898.59999.5100100.5101101.5102102.5103103.5104104.5105105.5106106.5107107.5108108.5
48
GS4 Next Level At (1000's):
1808.52.551017.527.5405572.592.5115140167.5197.5230265302341382425470517566617670725781.5839.58999601022.51086.5115212191287.51357.5142915021576.51652.517301808.518881968.520502132.522162300.523862472.5256026482736.52825.5291530053095.53186.5327833703462.53555.5364937433837.53932.5402841244220.54317.5441545134611.54710.5481049105010.55111.5521353155417.55520.5562457285832.55937.5604361496255.56362.5647065786686.5
49
FALSEWarning: Do NOT cut and paste training plan from spreadsheets prior to V4.1.0 into these cells! The order of the skills has changed, and a cut and paste will yield incorrect results.
50
FALSE
Training Plan
51
Fill in Extra Ranks With:1
52
At level 40: RanksX#PTPMTP40012345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091
53
Armor Use6(0.1X)1806
66
Physical Fitness42(1.0X)1802111111111111111111111111111
68
Climbing13(0.3X)1401011111
69
Swimming13(0.3X)1307311111
73
Perception42(1.0X)20312656411111111111111
74
First Aid211
78
Arcane Symbols21(0.5X)202161111111
79
Magic Item Use21(0.5X)202134111111
80
Harness Power40(1.0X)30430111111111111111
81
Spell Aiming231
83
Spirit Mana Control42(1.0X)30325238211
85
Spell Research116(2.8X)3085934434343333122333311133113
86
Major Spirit25(0.6X)30815222221
87
Minor Spirit30(0.7X)41323232112222221
88
Cleric61(1.5X)4011111111111111111111111111
94
Spiritual Lore10(0.2X)20682
95
Blessings10(0.2X)20682
96
Religion
97
Summoning
107
PTP80000000000000000000277178888888888881588158815881588150000000000000000000000000000000000000000000000
108
MTP2588000000000000000000012914981814984528488707174725079796367879266367-1363-40-40-40-40-40-40-40-40-40-40-40-40-40-40-40-40-24-8-8-8-8-8-8-8-8-8-8-8-8-8-8-8-8-8-8-8-8-8-8-8-8-8-8-8-8-8
109
Total PTP Left40240801201602002402803203604004404805215626036446857267671749266502462362440044231029334131267402423429578719733968120314411555159916431687173117751819186319071951199520392083212721712215226023052350239524402485253025752620266527102755280028452890293529813027307331193165321132573303334933953441
110
Total MTP Left05010015120225330435540645851056261466671877082287592898100000000000000000000000000000062159256353450547644741838935103211301228131013761442150815741640170617721838190419702036210221682234230023662432249825642630269627632830289729643031309831653232
111
DFRedux Primary (Physical Fitness)
42000000000000000000021222324252627282930313233343536373839404142434445464747474747474747474747474747474747474747474747474747474747474747474747474747474747474747474747
112
DFRedux Secondary600000000000000000006666666666666666666666666666666666666666666666666666666666666666666666666
113
DFRedux Teriary (weapon)000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
114
DFRedux Spell Penalty (GS3 formula)
536200000000000000000001900204822162344247026322782297831523332352237223826397441264330454447685002512052405362561258726000613063846384638463846384638463846384638463846384638463846384638463846384638463846384638463846384638463846384638463846384638463846384638463846384638463846384638463846384638463846384638463846384
115
Redux (this number is just a guess)
0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%
116
Inter-Level
117
Total Bonus:
118
At level 40: RanksX40012345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091
119
Armor Use6(0.1X)3030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030
132
Physical Fitness42(1.0X)142939699102105108111114117120122124126128130132134136138140141142143144145146147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147
134
Climbing13(0.3X)6250505050505050505050505050505454545858586262626666667070707070707070707070707070707070707070707070707070707070707070707070707070707070707070707070
135
Swimming13(0.3X)6235505050505050505050505050505454545858586262626666667070707070707070707070707070707070707070707070707070707070707070707070707070707070707070707070
139
Perception42(1.0X)142588299117126128130132134136138140141142143144145146147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147147
140
First Aid
144
Arcane Symbols21(0.5X)9374787882828686909093939696999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999
145
Magic Item Use21(0.5X)9362787882828686909093939696999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999
146
Harness Power40(1.0X)140120120120120120120120120120120120120122124126128130132134136138140141142143144145145145145145145145145145145145145145145145145145145145145145145145145145145145145145145145145145145145145145145145145145145145145145145145
147
Spell Aiming
149
Spirit Mana Control42(1.0X)142105105105105105105105105105105105105111120120120120120136140141142142142142142142142142142142142142142142142142142142142142142142142142142142142142142142142142142142142142142142142142142142142142142142142142142142142142
151
Spell Research116(2.8X)n/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/a
152
Major Spirit25(0.6X)n/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/a
153
Minor Spirit30(0.7X)n/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/a
154
Cleric61(1.5X)n/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/an/a
160
Spiritual Lore10(0.2X)504050505050505050505050505050505050505050505050505050505050505050505050505050505050505050505050505050505050505050505050
161
Blessings10(0.2X)504050505050505050505050505050505050505050505050505050505050505050505050505050505050505050505050505050505050505050505050