Below is an example tree. The score is calculated going from the lower levels in the tree where questions were answered. The valuation of the answers is then rolled up the tree and transformed by formulas until eventually on the top level the ranking score can be determined.
Top Level Equipment Ranking Level Formula = ( - Level1a + - Level1b + Level1c ) without normalization. Result - Equipment Ranking Score = 250 + 35 +15 = 300 |
|||
Level1a Formula = ( - Level2a + - Level2b ) * - Level2c without normalization. Result - L1a = ( 10 + 40 ) * 5 = 250 |
|||
Level2a Formula = ( - Level3a + - Level3b) without normalization Result - Level2a = 2 + 8 = 10 |
|||
Level3a is a numeric Question Level Answer - Level3a = 2 (User entered 2) |
|||
Level3b is a non-numeric Question Level without normalization. User can select between answer Yes (8) or No (2) Answer - Level3b = 8 (User picked Yes) |
|||
Level2b is numeric Question Level. Answer - Level2b = 40 (User entered 40) |
|||
Level2c Formula = ( - Level3c + - Level3d + - Level3e) with normalization. Range from 50 to 150 becomes 5. Result - Level2c = 5 (User entered 120 total, but this is normalized to 5) |
|||
Level3c is a numeric Question Level Answer - Level3c = 30 (User entered 30) |
|||
Level3d is a non-numeric Question Level and is calculated. Query can select between answer Good (70) or Bad (500) Answer - Level3d = 70 (Query picked ‘Good’) |
|||
Level3e is a numeric Question Level. Answer - Level3e = 20 (User entered 20) |
|||
Level1b is a non-numeric Question Level. User can select between answer White (40) or Blue (35) Answer - L1b = 35 (User picked Blue) |
|||
Level1c is numeric Question Level and is calculated. Query is SELECT 15 FROM dual; Answer - L1c = 15 |
Ranking Survey Grid
Question |
Answer |
Value |
Calculated Answer |
Calculated Value |
---|---|---|---|---|
Level1b |
Blue |
35 |
||
Level1c |
15 |
|||
Level2b |
40 |
|||
Level3a |
2 |
|||
Level3b |
Yes |
8 |
||
Level3c |
30 |
|||
Level3d |
‘Good’ |
70 |
||
Level3e |
20 |
Answer and Value for calculated questions will be provided automatically when the user clicks Calculate Ranking Values.