{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["APN Berechnung"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"APN Berechnung","index":0,"n_rows":28,"n_cols":25,"rows_kept":28,"cut":false,"hidden":false,"merged":[[17,3,17,5],[17,7,17,9],[3,11,3,24]]}
[null,"Spielauswertung"]
[]
[null,"Vorgaben"]
[null,null,null,null,null,null,null,null,null,null,null,"Beispiele für Änderungen nach Differenz der Team-APN"]
[null,"Anpassungsfaktoren:",null,null,null,null,null,"Mittelwert Team A - Team B",null,null,null,"<1=1",1,1.5,2,2.5,3,3.5,4,4.5,5,5.5,6,6.5]
[]
[null,"Team gewinnt gegen besseres Team (kgb)",null,null,null,0.15,null,"Mittelwert Team A",null,{"$f":"(D22+F22)/2","v":2.5},null,0.15,0.15,0.22500000000000001,0.3,0.375,0.45,0.52500000000000002,0.6,0.67500000000000004,0.75,0.82499999999999996,0.9,0.97499999999999998]
[null,null,null,null,null,null,null,"Mittelwert Team B",null,{"$f":"(H22+J22)/2","v":4.5}]
[null,"Team verliert gegen besseres Team (kvb)",null,null,null,0.05,null,null,null,null,null,0.05,0.05,3.3000000000000002E-2,2.5000000000000001E-2,0.02,1.7000000000000001E-2,1.4E-2,1.2999999999999999E-2,1.0999999999999999E-2,0.01,8.9999999999999993E-3,0,0]
[]
[null,"Team gewinnt gegen schlechteres Team (kgs)",null,null,null,0.05,null,"Differenz Team-APN",null,null,null,0.05,0.05,3.3000000000000002E-2,2.5000000000000001E-2,0.02,1.7000000000000001E-2,1.4E-2,1.2999999999999999E-2,1.0999999999999999E-2,0.01,8.9999999999999993E-3,0,0]
[]
[null,"Team verliert gegen schlechteres Team (kvs)",null,null,null,0.15,null,"Differenz",null,{"$f":"MAX(1,ABS(J7-J8))","v":2},null,0.15,0.15,0.22500000000000001,0.3,0.375,0.45,0.52500000000000002,0.6,0.67500000000000004,0.75,0.82499999999999996,0.9,0.97499999999999998]
[]
[null,null,null,null,null,null,null,"Wenn Differenz <1; dann immer 1"]
[null,"Spielauswertung",null,null,null,null,null,null,null,null,null,"Team A gewinnt gegen Team B",null,null,null,null,null,null,null,"Team B gewinnt gegen Team A"]
[]
[null,"1.",null,"TEAM A",null,null,null,"TEAM B",null,null,null,"Team A ist schlechter als Team B",null,null,null,null,null,"APN neu",null,"Team B ist besser als Team A",null,null,null,null,"APN neu"]
[null,"APN aller Spieler eintragen",null,null,null,null,null,null,null,null,null,"APN Spieler 1A + (Differenz Team APN * kgb Faktor)",null,null,null,null,null,{"$f":"MIN(7.5,D22+(J13*F7))","v":2.2999999999999998},null,"APN Spieler 1A - (1/Differenz Team APN* kvb Faktor)",null,null,null,null,{"$f":"MAX(1,D22-(1/J13*F9))","v":1.9750000000000001}]
[null,null,null,"Spieler 1A",null,"Spieler 2A",null,"Spieler 3B",null,"Spieler 4B",null,"APN Spieler 2A + (Differenz Team APN * kgb Faktor)",null,null,null,null,null,{"$f":"MIN(7.5,F22+(J13*F7))","v":3.3},null,"APN Spieler 2A - (1/Differenz Team APN* kvb Faktor)",null,null,null,null,{"$f":"MAX(1,F22-(1/J13*F9))","v":2.9750000000000001}]
[null,null,null,null,null,null,null,null,null,null,null,"APN Spieler 3A - (Differenz Team APN * kvs Faktor)",null,null,null,null,null,{"$f":"MAX(1,H22-(J13*F13))","v":3.7},null,"APN Spieler 3B  + (1/Differenz Team APN* kgs Faktor)",null,null,null,null,{"$f":"MIN(7.5,H22+(1/J13*F11))","v":4.0250000000000004}]
[null,null,"APN Alt",2,null,3,null,4,null,5,null,"APN Spieler 4A - (Differenz Team APN * kvs Faktor)",null,null,null,null,null,{"$f":"MAX(1,J22-(J13*F13))","v":4.7},null,"APN Spieler 4B  + (1/Differenz Team APN* kgs Faktor)",null,null,null,null,{"$f":"MIN(7.5,J22+(1/J13*F11))","v":5.0250000000000004}]
[null,"2."]
[null,"Button A oder B gewinnt",null,null,null,null,null,null,null,null,null,"Team A ist besser als Team B",null,null,null,null,null,"APN neu",null,"Team B ist schlechter als Team A",null,null,null,null,"APN neu"]
[null,"zur Auswertung drücken",null,null,null,null,null,null,null,null,null,"APN Spieler 1A  + (1/Differenz Team APN* kgs Faktor)",null,null,null,null,null,{"$f":"MIN(7.5,D22+(1/J13*F11))","v":2.0249999999999999},null,"APN Spieler 1A - (Differenz Team APN * kvs Faktor)",null,null,null,null,{"$f":"MAX(1,D22-(J13*F13))","v":1.7}]
[null,null,null,null,null,null,null,null,null,null,null,"APN Spieler 2A  + (1/Differenz Team APN* kgs Faktor)",null,null,null,null,null,{"$f":"MIN(7.5,F22+(1/J13*F11))","v":3.0249999999999999},null,"APN Spieler 2A - (Differenz Team APN * kvs Faktor)",null,null,null,null,{"$f":"MAX(1,F22-(J13*F13))","v":2.7}]
[null,null,"APN Neu",1.9750000000000001,null,2.9750000000000001,null,4.0250000000000004,null,5.0250000000000004,null,"APN Spieler 3B - (1/Differenz Team APN* kvb Faktor)",null,null,null,null,null,{"$f":"MAX(1,H22-(1/J13*F9))","v":3.9750000000000001},null,"APN Spieler 3B + (Differenz Team APN * kgb Faktor)",null,null,null,null,{"$f":"MIN(7.5,H22+(J13*F7))","v":4.3}]
[null,null,null,null,null,null,null,null,null,null,null,"APN Spieler 4B - (1/Differenz Team APN* kvb Faktor)",null,null,null,null,null,{"$f":"MAX(1,J22-(1/J13*F9))","v":4.9749999999999996},null,"APN Spieler 4B + (Differenz Team APN * kgb Faktor)",null,null,null,null,{"$f":"MIN(7.5,J22+(J13*F7))","v":5.3}]