This spreadsheet is used in a game to calculate the difficulty of an
encounter to a group of adventurers.

Basicly, the user will put in the number of monsters at each Challenge
Code, and then it should spit out a CC for the entire encounter. There
is no mathmatical forumla presented in the rules for determining the
CC. Here is what they give you:

"1. Doubling the number of obstacles of similar challenge codes
increases the Challenge Code of the encounter by one letter. Thus, two
Challenge Code "A" obstacles are basically the same as a single
Challenge Code "B" obstacle

2. Combining two obstacles whos Challenge Codes are one letter apart
increases the tougher obstacle by one letter; the tougher obstacle's
new Challenge Code determines the Challenge Code for the encounter. For
example, combiding a Challenge Code "C" obstacle and a Challenge Code
"D" obstacle creates a Challenge Code "E" encounter.

3. When combining two obstacles whos Challenge Codes are more than one
letter apart, the tougher obstacle's Challenge Code determines the
Challenge Code for the whole encounter. For examble, a Challenge Code
"A" obstacle coupled with a Challenge Code "D" obstacle is treated as a
Challenge Code "D" encounter. (The lesser obstacle does not contribute
significantly to the difficulty of the encounter.)

4. When combining three or more obstacles with different Challenge
Codes, group the obstacles in pairs from least difficult to most
difficult, use the guidelines above to combine each pair into a single
Challenge Code, and then repeat the pairing process. For example, three
obstacles of Challenge Code "B", "C", and "C" would be paired as
follows: "B"+"C" and "C" (unpaired). The "B" and "C" combine to form a
single Challenge Code "D" encounter, which then combines with the
second Challenge Code "C" encounter to yield a final encounter of
Challenge Code "E"."

As you can see on the attached sheet, the forumula I have works in most
cases, but not all. What I need is to know how to make the total value
snap to one of my pre-existing values (1,2,4,8,16,32,64,128,640,etc). I
need to to snap to the value closest, instead of using the lowest (as it
does now.)

This is the scenario I've been using to test it: 8B's 4D's 4F's should
come out to an "I" but instead yields and "H". I think this bug would
be fixed if the value in the Total column would snap to the closest
number in the "Numerical Value" row, but this is far beyond the extent
of my Excel knowledge.

If anyone can help with this I would greatly appreciate it.

Here is the spreadsheet for your viewing pleasu
http://www.xmaveric.com/exp.xls


--
xmaveric
------------------------------------------------------------------------
xmaveric's Profile: http://www.excelforum.com/member.php...o&userid=26440
View this thread: http://www.excelforum.com/showthread...hreadid=397553