ForceUser:
If you are having trouble defining what the low, medium, and high values need to be, then just start breaking the categories down, define the ranges, and then go from there.
Here is an example:
Movement Points: 0 - 127
Spotting: 0 - 127
Camoflage: 0 - 127
Agility: 0 - 127
Armor: 0 - 65536?
Psy Def: 0 - 65536?
Accuracy: 0 - 127
Attack Strength: 0 - 65536?
These are the absolute ranges of these statistcs - I think 0 - 127 is a signed char (guessing) and 0 - 65536 is an int or something like that. From here you can see that you probably don't need to go this high on your statistics, but it is nice to know what the limits are.
When it comes to Spotting and Camouflage, you need to take into account the terrain modifiers, but you can pit these two statistics against each other to determine their limits. For example, let's say that you are going to limit Spotting to 0 - 10 and the same with Camouflage. Now you can see that low spotting is 0-3, medium spotting 4-7, and high spotting 8-10. The same could be true for camouflage. You can do similar things for Movement Rate (say you put a max movement rate of 100 in your mod), then low, medium, and high movement rates are 0-30, 31-70, and 71-100, respectively.
So you can see if you do something like this that you'll be on your way to creating a new mod. Note that these ranges are linear or evenly distributed. If you want to use a Guassian, Normal, or some other distribution profile just whip out a statistics book and then apply the distribution profile to your range. I did something like this with my DAMAGE.DAT file - take the numbers in that file and plot them and you'll see the distribution profile.
As far as my formulas, I have an old spreadsheet that is available on my website here (way down at the bottom of the downloads section):
http://www.twarriors.com/~hyperion/downloads/h1375xls.zip This is for Hyperion V1.375, but shows you how I devised the formulas for that version of Hyperion. My latest design spreadsheet uses a different set of formulas and, frankly, the formulas are so good that I'm going to use them in a future game that I'm going to make one of these days when I find the time. Nonetheless, I will provide you guidance in how to go about creating formulas if you are interested, but if you go through my spreadsheets (I have another one for Hyperion V1.35 in the downloads section on my site as well) you'll see what the formulas were that I used in those previous versions of Hyperion.
Basically with my older spreadsheets I had to tweak resources to change unit statistics. This worked really well, but required manual tweaking of the resource values to increase a statistic. I bet you can imagine that this took a lot of time. Nonetheless, it was very effective and produced an incredibly balanced set of units for such a large number of units. What is so good about my new set of formulas is that all the statistics save Accuracy and Attack Strength are automatically generated based on the unit's technology requirements, unit class, unit type, movement type, and faction.
This produces a balanced set of units and what is so good about it is that it can be used for any type of game like this. It took me about 7 years to come up with this automatic statistic generation system (boy it has been that long - wow!) to create a 45[MB] unit design spreadsheet, and so I hope you can understand why I'm secretive about my current formula set.
But feel free to ask questions about the spreadsheets you download from my website as those represent about 3-4 years of work and show how you can link a lot of the information together (the spreadsheet is a little daunting to the unitiated, so don't be taken aback when you first open it as it was designed for my own use). Also, I had a day job (where I averaged about 50 hours of work a week) so that is why it took me so long, so don't be scared off by how long it took me.
I wish you the best of luck in designing a mod, or at the very least, I hope you'll get into galaxy design as that is an area that is seriously lacking for all the mods!
Matt
P.S. Sorry for taking so long to reply, but as Grim said I am very, very busy! I have a day job where I work about 50-60 hours a week right now and so I don't have much time to Hyperion (or even play games) these days!