The old sheet here:
http://dffd.wimbli.com/file.php?id=10014was set to 10 generated dwarfs, and the weighted average ~= the weighted geometric mean results.
However... since the values are arbitrarily pre transformed before compared with each other, I thought it would be more "pure" to use the "raw" values.
So...
I redid all the roles using raw values vs transformed values as inputs for a weighted geometric mean. I dropped the file size down by a 3rd
and cleaned up a lot of the sheets.
http://dffd.wimbli.com/file.php?id=10023Please, if you have time, I'd love anyone to see if I f'd it up.
It currently generates 100 Monte Carlo dwarf's with varying skills, traits, and attributes.
It appears to produce a comparative relationship.
The first 4 sheets are the important "results"
sheet 1 = global variables and the final generated roles
sheet 2 - 4 = 3 pre-defined roles (They are editable, so one can make any role of up to 5 input vars) and how the raw values are fed into them to produce a weighted geometric mean.
**Update**
Much easier way to view the way the changes affect things
http://imgur.com/IuLdwjQI think the reason it works is because it's like finding the volume of a 3d area (but not limited to just 3d) (height * width * length), but finding a volume's center I guess. When all the values are combined [using a WGM role setup] into single role matrix; all the dimensions comparable statistics like min, max, mean, median, etc, are built into the 1 dimensional output: the role matrix.
**Update**
I updated the setup to include virtual preferences.