X
xmaveric
This spreadsheet is used in a game to calculate the difficulty of a
encounter to a group of adventurers.
Basicly, the user will put in the number of monsters at each Challeng
Code, and then it should spit out a CC for the entire encounter. Ther
is no mathmatical forumla presented in the rules for determining th
CC. Here is what they give you:
"1. Doubling the number of obstacles of similar challenge code
increases the Challenge Code of the encounter by one letter. Thus, tw
Challenge Code "A" obstacles are basically the same as a singl
Challenge Code "B" obstacle
2. Combining two obstacles whos Challenge Codes are one letter apar
increases the tougher obstacle by one letter; the tougher obstacle'
new Challenge Code determines the Challenge Code for the encounter. Fo
example, combiding a Challenge Code "C" obstacle and a Challenge Cod
"D" obstacle creates a Challenge Code "E" encounter.
3. When combining two obstacles whos Challenge Codes are more than on
letter apart, the tougher obstacle's Challenge Code determines th
Challenge Code for the whole encounter. For examble, a Challenge Cod
"A" obstacle coupled with a Challenge Code "D" obstacle is treated as
Challenge Code "D" encounter. (The lesser obstacle does not contribut
significantly to the difficulty of the encounter.)
4. When combining three or more obstacles with different Challeng
Codes, group the obstacles in pairs from least difficult to mos
difficult, use the guidelines above to combine each pair into a singl
Challenge Code, and then repeat the pairing process. For example, thre
obstacles of Challenge Code "B", "C", and "C" would be paired a
follows: "B"+"C" and "C" (unpaired). The "B" and "C" combine to form
single Challenge Code "D" encounter, which then combines with th
second Challenge Code "C" encounter to yield a final encounter o
Challenge Code "E"."
As you can see on the attached sheet, the forumula I have works in mos
cases, but not all. What I need is to know how to make the total valu
snap to one of my pre-existing values (1,2,4,8,16,32,64,128,640,etc).
need to to snap to the value closest, instead of using the lowest (as i
does now.)
This is the scenario I've been using to test it: 8B's 4D's 4F's shoul
come out to an "I" but instead yields and "H". I think this bug woul
be fixed if the value in the Total column would snap to the closes
number in the "Numerical Value" row, but this is far beyond the exten
of my Excel knowledge.
If anyone can help with this I would greatly appreciate it.
Here is the spreadsheet for your viewing pleasure:
http://www.xmaveric.com/exp.xl
encounter to a group of adventurers.
Basicly, the user will put in the number of monsters at each Challeng
Code, and then it should spit out a CC for the entire encounter. Ther
is no mathmatical forumla presented in the rules for determining th
CC. Here is what they give you:
"1. Doubling the number of obstacles of similar challenge code
increases the Challenge Code of the encounter by one letter. Thus, tw
Challenge Code "A" obstacles are basically the same as a singl
Challenge Code "B" obstacle
2. Combining two obstacles whos Challenge Codes are one letter apar
increases the tougher obstacle by one letter; the tougher obstacle'
new Challenge Code determines the Challenge Code for the encounter. Fo
example, combiding a Challenge Code "C" obstacle and a Challenge Cod
"D" obstacle creates a Challenge Code "E" encounter.
3. When combining two obstacles whos Challenge Codes are more than on
letter apart, the tougher obstacle's Challenge Code determines th
Challenge Code for the whole encounter. For examble, a Challenge Cod
"A" obstacle coupled with a Challenge Code "D" obstacle is treated as
Challenge Code "D" encounter. (The lesser obstacle does not contribut
significantly to the difficulty of the encounter.)
4. When combining three or more obstacles with different Challeng
Codes, group the obstacles in pairs from least difficult to mos
difficult, use the guidelines above to combine each pair into a singl
Challenge Code, and then repeat the pairing process. For example, thre
obstacles of Challenge Code "B", "C", and "C" would be paired a
follows: "B"+"C" and "C" (unpaired). The "B" and "C" combine to form
single Challenge Code "D" encounter, which then combines with th
second Challenge Code "C" encounter to yield a final encounter o
Challenge Code "E"."
As you can see on the attached sheet, the forumula I have works in mos
cases, but not all. What I need is to know how to make the total valu
snap to one of my pre-existing values (1,2,4,8,16,32,64,128,640,etc).
need to to snap to the value closest, instead of using the lowest (as i
does now.)
This is the scenario I've been using to test it: 8B's 4D's 4F's shoul
come out to an "I" but instead yields and "H". I think this bug woul
be fixed if the value in the Total column would snap to the closes
number in the "Numerical Value" row, but this is far beyond the exten
of my Excel knowledge.
If anyone can help with this I would greatly appreciate it.
Here is the spreadsheet for your viewing pleasure:
http://www.xmaveric.com/exp.xl