| A | B | C | D | E | F | G | H | I |
1 | | | | | 8.1395 | 1520 | 0.02 | =G1-SUMME(G3:G9) | =H1-SUMME(H3:H9) |
2 | | Wissenschaft | Gesellschaft | Wirtschaft | Militär | Verhältnis/Punkte | Fixer Anteil | Variabler Anteil | Gesammt |
3 | Xinto (36013) | 4 | 58 | 42 | 5 | =(SUMME(B3;D3)-E3-E3)*$E$1 | =9000*$G$1 | =$F$1-F3 | =G3+H3 |
4 | Alderan (20002) | 171 | 310 | 276 | 163 | =(SUMME(B4;D4)-E4-E4)*$E$1 | =9000*$G$1 | =$F$1-F4 | =G4+H4 |
5 | Gregie (36677) | 3 | 39 | 28 | 0 | =(SUMME(B5;D5)-E5-E5)*$E$1 | =9000*$G$1 | =$F$1-F5 | =G5+H5 |
6 | Lanfear (34309) | 97 | 166 | 200 | 109 | =(SUMME(B6;D6)-E6-E6)*$E$1 | =9000*$G$1 | =$F$1-F6 | =G6+H6 |
7 | Thorhal (34048) | 18 | 70 | 99 | 0 | =(SUMME(B7;D7)-E7-E7)*$E$1 | =9000*$G$1 | =$F$1-F7 | =G7+H7 |
8 | Cyborg (34120) | 51 | 62 | 77 | 25 | =(SUMME(B8;D8)-E8-E8)*$E$1 | =9000*$G$1 | =$F$1-F8 | =G8+H8 |
9 | Raistlin Majere (33816) | 82 | 178 | 256 | 99 | =(SUMME(B9;D9)-E9-E9)*$E$1 | =9000*$G$1 | =$F$1-F9 | =G9+H9 |
10 | | | | | | | | | =SUMME(I3:I9) |