> RQ @\pCIT Student Computing Services Ba==L,8X@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1
Arial1Arial1@Arial1Arial1@Arial1@Arial1@
Arial1Arial1Arial1
Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* ""_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* ""_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* ""??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* ""??_);_(@_)""#,##0;\""#,##0""#,##0;[Red]\""#,##0""#,##0.00;\""#,##0.00#""#,##0.00;[Red]\""#,##0.0050_""* #,##0_;\""* #,##0_;_""* ""_;_@_,'_* #,##0_;\* #,##0_;_* ""_;_@_=8_""* #,##0.00_;\""* #,##0.00_;_""* ""??_;_@_4/_* #,##0.00_;\* #,##0.00_;_* ""??_;_@_
"$"#,##0
dd/mm/yyyy (@ @ " "0 @ "4 @ "<@ @ "0@ @ "0@ "0 "8@ @ "8@ @ "0 @ "8@ @ "8@ "8@ "0 "8@ "8 @ "8@ @ "4@ @ "8@@ "4@@ "4@ "0@@ "0@ "8@ "8@ @ (@ @ "8@ @ "4@ @ "0 " "@ "4 "4 "4@ "0@
"@ @
" @ "@ @ " @
"
( "8 @ "8 "8 "8@@ "8@ "8@ #
! !8 @ #8@@ !8 @ #8@@ @ `K8Sheet1YSheet2mSheet3integer ;[$
solver_adj;$
solver_adj;$
solver_adj;"
solver_cvgMbP?"
solver_cvgMbP?"
solver_cvgMbP?
solver_drv
solver_drv
solver_drv
solver_est
solver_est
solver_est
solver_itrd
solver_itrd
solver_itrd%solver_lhs1;%solver_lhs1;$%solver_lhs1;!solver_lhs2:%solver_lhs2;%solver_lhs2;%solver_lhs3;$!solver_lhs3:!solver_lhs3:%solver_lhs4=$(!solver_lhs4:!solver_lhs4:!solver_lhs5< !solver_lhs5:%solver_lhs5;!solver_lhs6:
solver_lin
solver_lin
solver_lin
solver_neg
solver_neg
solver_neg
solver_num
solver_num
solver_num
solver_nwt
solver_nwt
solver_nwt
solver_opt:
solver_opt:
solver_opt:"
solver_preư>"
solver_preư>"
solver_preư>solver_rel1solver_rel1solver_rel1solver_rel2solver_rel2solver_rel2solver_rel3solver_rel3solver_rel3solver_rel4solver_rel4solver_rel4solver_rel5solver_rel5solver_rel5solver_rel6solver_rhs1#%solver_rhs1;$%solver_rhs1;!solver_rhs2:solver_rhs2#solver_rhs2#%solver_rhs3;$%solver_rhs3z!solver_rhs3:%solver_rhs4=$(!solver_rhs4:!solver_rhs4:!solver_rhs5< %solver_rhs5z(solver_rhs5#%solver_rhs6z
solver_scl
solver_scl
solver_scl
solver_sho
solver_sho
solver_sho
solver_timd
solver_timd
solver_timd"
solver_tol?"
solver_tol?"
solver_tol?
solver_typ
solver_typ
solver_typ
solver_val
solver_val
solver_val`i VariablesLHSRHS >="="CoefficientsHPMPSTRVITINTMENAGIDEXHP TotalMP Total STR Total VIT Total INT Total MEN Total AGI Total DEX TotalTotalAmClWtArPrSiDtVkSlBtNjKnWzBeTkDrSdWaExGnExplanation of "Chartrain.xls"Male ClassesFemale ClassesSoldierBeast TamerNinjaKnightWizard Berserker
Terror KnightDragoonSword MasterWarlockExorcistGunnerMale ClassesFemaleAmazonClericWitchArcherPriestSirenValkyrieDragon Tamer]The numbers beneath the variables are their actual values; for example, the number under "Sl"`is the number of levels you spend training as a Soldier. If you just want to tinker around withYthe model and develop your own blend of training, these are the numbers that you want to Ychange. Note that the sum of these numbers should not be greater than 49, since you can \only gain 49 levels in the game; it's perfectly okay for the sum to be less than 49, though.]Line 7 should read "Coefficients" in column A. The numbers in this row are just the sums of \the growth statistics of each class. For example, the number in row 7 (Sheet 2) in the same_column as the variable "Sl" is just the sum of the soldier's increase in STR, HP, VIT, MP, AGI,\DEX, INT, and MEN per level gained (note that the actual increases themselves is an average;]characters don't always gain the same amount of each statistic at level up). This is just a `general objective function (since we officially need one) that has the aim of producing the best^"overall" character. It does that by adding up all of a character's statistics, and tries to Wmaximize that number; however, maximizing the sum of your character's statistics is not^likely to be your goala better goal is to maximize the leastvalued statistic (commonly VIT)
Level Gain Beginning_You can do this by altering the constraints to the modelto do that, go up to the menu bar andWselect "Tools," and then select "Solver." Notice how cells B22B29 represent the total]increase in each statisticin Solver, cell B22 is referred to as $B$22, and so on. You can balter the constraint so that, for example, the character's total gain in VIT is less than or equal_to their total gain in AGI + 30. If you do this, then the character's VIT and AGI should stay awithin 30 points of each other; likewise, you can do this for any of the statisticsI just chose[VIT and AGI because those are typically the statistics which are most problematic to raise ^together. Of course, you have to keep in mind what you're using the character forif you're ]trying to create a Terror Knight, having high INT and MP is not important. This model can be_quite helpful in assisting you in determining how to create an allaround quality character, inWcase you don't want to restrict someone to being "just a fighter" or "just a magician."YLines 9 and 10 are some basic constraints that I created more for "common sense" than any^other reasonthe thing with these models is that you have to interpret the results and see if]they make sense. The "Beginning" constraint is basically there to ensure that your character]gains at least 6 levels as a Soldier, since that's usually how many levels you'd have to gainZbefore you can change to anything else. The "Level Gain" constraint has two purposesin [the more general sense, it places a boundary on the model; without it, your character woulddbe able to gain infinite levels, and their stats would be infinitely high (in other words, the model`could not give you a finite solution). More specifically to Tactics Ogre, the constraint makes [sure that the total number of levels gained is equal to 49, since that's the maximum numberbof levels you can gain. It is based on the assumption that we're looking at a Level 50 character;bif you want to look at a character at a level less than 50, then just change cell H23 accordingly.YLines 1219 are mainly to help the model determine your character's total gain in each offthe statistics; in plain talk, each of those lines just says "the total gain in each statistic is just_the sum of the levels gained with each class times the average increase in the statistic gained(from gaining a level with that class." [Lines 2230 form the "result area" of the model. Cells B22B29 represent the total gain in\each statistic (B30 is simply the sum of all gains), cells C22C29 represent the status of a^typical Level 1 character, and cells D22D29 represent the final status of the character. TheVtable next to that area, marked with a "LHS" and "RHS," is just the output area of the_constraintsthat's where you can see that all of the constraints are being met, and that's theWarea that the model uses to determine whether or not all the constraints are being met.^And that's about it as far as the model goeshopefully, I explained it to the point where you\can understand how to use the model, and hopefully you find this model to be useful. If youWhave any questions, feel free to contact me at crg@princeton.edu; you can also see someXsample characters at http://www.princeton.edu/~crg/dojo.html. Thanks for reading this, Hand I wish you the best of luck in forming a more effective attack team!By Chris Gonzalez`First of all, note that at the bottom of this worksheet, there are three tabs labeled "Sheet1," aOn Line 4 of Sheets 2 and 3, you'll notice that in column A, there is the word "Variables." The _variables are simply the number of levels gained with each class, being abbreviated as follows:]"sensitivity analysis" where you input the number of levels you want to train with each classaand tinker around with the levels to determine the optimal blend of training for your characters.bIn most cases, it will involve training as more than one class and "diversifying" your character's,statistics. Anyway, on to the actual model:]go to Sheet 2, which is the model for male classes. Likewise, Sheet 3 is for female classes.`"Sheet2," and "Sheet3." Right now, you are on Sheet 1click on the tab for Sheet 2, and you'll`This is a nonlinear optimization model on Microsoft Excel that is designed to tell you for how ^many levels you should train with each class to get a character with your desired distributionVof statistics such as STR, and VIT. This model can also be used to conduct a sort of ]A final noteyou may end up getting a result that is not possible to actually carry out (foraexample, it may tell you to train as a Soldier for 6 levels and a Sword Master for 43). In this Xcase, you just have to tinker around with it until you get something that works for you.GL{&V,"#H%wT(M+*.Y1L36
@`<GQ[Y
dMbP?_*+%MBlackWhitehitew 3dXXlMZzbRdCustom page 1BBCustom page 2BBCustom page 3BB" dXX??U}}}}}} }
}}}`
h,,,,,,,,,,,,
?,??@K
M{@@@@
=&=L===========>>>
=&================
=&================
=&================
=&================
=&================
=&================
=
=&================
=&================(
=================
=}&================
=~&================(=================
Q;
N<===
O=
P<=========
H
E/===
H
F>=========
I!
F0===
I
F?=========
I"
F1===
I
F@=========
I#
F2===
I
FA=========
I$
F3===
I
FB=========
I%
F4===
I
FC=========
I&
F5===
I
FD======>>>
I'
F6222
J
GER2222==>>>
I(
F7$====D=======>>>
I)
F8$====D=======>>>
I*
F9$====D==========
J+
G:$====D==========(======D==========
=F&================B
XP888888888,88,ddddddddfDDDD, !"#$%&'()*+,./0123456789:;<=>?
=G& ================
!=H&!================
"=I&"================
#=J&#================($=================
%=K&%================
&=L&&================
'=M&'================
(=N&(================
)=O&)================
*=P&*================
+=Q&+================
,=R&,================
=S&================(.=================
/=V&/================
0=W&0================
1=X&1================
2=Y&2================
3=Z&3================
4=[&4================
5=\&5================
6=]&6================
7=^&7================
8=_&8================
9=`&9================(:=================
;=a&;================
<=b&<================
==c&=================
>=d&>================
?=e&?================D\ l8888,888888888,88888888888,8888@ABCDEFGHIJKLMNOPQRSTUWXYZ[\]^_
@=f&@================
A=g&A================
B=h&B================
C=i&C================
D=j&D================
E=k&E================(F=================
G=l&G================
H=m&H================
I=n&I================
J=o&J================(K=================
L=p&L================
M=qM=======
N=rN=======
O=sO=======
P=tP=======
Q=uQ=======R========
S=
T=T=======
U=U=======
W=vW=======
X=wX=======
Y=xY=======
Z=yZ=======
[=z[=======\========]========^========_========BX888888,8888,8&&&&&&&&&&&&> @<d7
@%Zkm
dMbP?_*+%"??=U}}%
A
BB
!
"
#
$
%
&
'
(
)
*
+
~
;@<+4@*<<<<<< <06@
<<<
"
N&G@F@G@G@F@G@F@E@I@E@G@D@
"
U~
'?''''
''
'
''
TN '??'?'?'?'?'?'?'?'?'??
"
2666666666666
N @"@ @"@@$@$@"@ @@@@
N@@@@@@ @@
N
@@@@@@@ @@@@@
N@@@@@@@@@@@@
N@@@@ @@@@@@ @@
N@@@@@@@@@"@@@
N@@ @@@@@@@@@@
N@@@@@@@ @"@@@@
"
(
%
.y@$m@@@mB~
N@$ }@$@$@B0)@e@@@eB
~
@
00\@~
$0\@$@$@B01H@e@@@e B
~
H@
. !Or@~
4@$"s@$@$@B$)$@$@B
~

0@p@~
0@$@q@$@$@B$*$@$ @B
~
.!5o@~
2@$"p@$@$@B$)$@$@B
~
0A
s@~
3@$A
t@$@$@B$*$@$
@B
~
.
0pr@~
3@$s@$@$@B$+$@$@B
~
!' v@~
#5@$$' w@$@$@B$,$@$@B
~
/0IZ@e@@@eB$+$@$ @B
~
$,$@$@B
~
$+ $@$ @B
~
Dl,
&j&hj&jjjjjjjj&HD !"#$$ ,!$@$@B
~
$!+"$@$@B
!~
!$",#$@$@B
"~
"$#+$$@$ @B
#~
#$$+$$ @$@B
$~
$PDDDD>@7
@1r
dMbP?_*+%MBlackWhitehitew 3dXXlMZzbRdCustom page 1BBCustom page 2BBCustom page 3BB" dXX??U}}
C.
CC
,2
43
22
69@:::4@:::7@9
22
55
6&G@F@F@H@F@F@H@G@
66
66
U~
'?''''
''66
T6 '??'?'?'?'?'?'?
66
26666666666
6 @@@ @@@"@"@
22
6@@@@@@@@
22
6
@@@@@@@@
22
6@@@@@@@@
22
6@ @@@"@"@@@
6@@ @@@@@@
6@@@@@@@@
6@@@ @@@@@22
(
%22
.y@$m@@@mB~
N@$ }@$@$@B0)@e@@@eB
~
@22
0 c@~
$ c@$@$@B01H@e@@@e B
~
H@22
. !r@~
4@$"s@$@$@B$)$@$@B
~
22

0p@~
0@$q@$@$@B$)$@$@B
~
22
.!r@~
2@$"s@$@$@B222
22
0`r@~
3@$s@$@$@B222
22
.
00r@~
3@$`s@$@$@B222
!t@~
#5@$$0v@$@$@B222
/0T@e@@@eB222 D
l*R V NV VVVVHHHH @}\
,
,788B
>
@7
Oh+'0 PX
&Training Your Tactics Ogre CharacterslChris GonzalezaCIT Student Computing ServicesaMicrosoft Excel@r@;S@m ՜.+,0 PXdlt
3 Sheet1Sheet2Sheet3Worksheets
!"#$%&'()*+,./0123456789:;<=>?@BCDEFGHJKLMNOPRoot Entry FWorkbookƀSummaryInformation(ADocumentSummaryInformation8I