{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Leiter_Helfer-moniteur_aide","Behinderte-Handicapés","Behinderte-Handicapés(2)"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":6,"comments":2,"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":"Leiter_Helfer-moniteur_aide","index":0,"n_rows":82,"n_cols":36,"rows_kept":82,"cut":false,"hidden":false,"merged":[[1,23,1,32],[2,22,4,22],[2,34,4,35],[2,26,4,33],[2,0,4,0],[2,1,4,3],[2,4,4,6],[2,23,4,25],[2,7,4,21],[10,29,10,33],[9,29,9,33],[9,19,9,23],[5,27,7,35],[5,22,7,22],[5,13,7,18],[9,14,9,18],[5,1,7,1],[5,3,7,3],[10,0,11,0],[5,6,7,8],[5,0,7,0],[5,2,7,2],[10,14,10,18],[5,9,7,12],[10,9,10,13],[0,20,0,22],[34,8,34,9],[37,21,39,25],[5,19,7,21],[9,4,9,8],[10,4,10,8],[9,9,9,13],[10,19,10,23],[9,24,9,28],[10,24,10,28],[37,26,39,35],[5,23,7,26],[37,18,39,20],[5,4,7,5],[37,4,39,6],[37,7,39,17]]}
["Präsenzliste","Erfassen / compléter s.v.p",null,null," Leiter/Helfer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kursart >\ntyp de cours >",null,null,null,null,null,null,null,null,null,null,null,null,null,5]
["Liste de présence ",null,null,null," Moniteurs/Aides ou auxiliaires",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"é  bitte wählen / veuillez sélectionner  é",null,null,null,null,null,null,null,null,null,null,1]
["Sportclub / Club sportif:","AS Fair Play SHL - 7550",null,null,"  Kurs:\n  Cours:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Ort:\n  Lieu:"]
[]
[]
["Wochentag / Jour:  ",null,"      von\n      de",null,"  bis\n  à",null,null,null,null,"  Uhr\n  heures",null,null,null,"  Kursdauer:\n  Durée du cours:",null,null,null,null,null,{"$f":"(G6-D6)*24","v":0},null,null,null,"  Leiter:\n  Moniteur:"]
[]
[]
[]
["Name / Nom","Vorname","Funktion","   ** HS",{"$f":"IF(OR($AI$1=2,$AI$1=5),VLOOKUP($AI$2,$D$68:$F$82,2,FALSE),IF(OR($AI$1=3,$AI$1=6),VLOOKUP($AI$2,$D$68:$F$82,2,FALSE),IF(OR($AI$1=4,$AI$1=7),VLOOKUP($AI$2,$D$68:$F$82,2,FALSE),\"Kursart? Monat?\")))","v":"Januar"},null,null,null,null,{"$f":"IF(OR($AI$1=2,$AI$1=5),VLOOKUP($AI$2+1,$D$68:$F$82,2,FALSE),IF(OR($AI$1=3,$AI$1=6),VLOOKUP($AI$2,$D$68:$F$82,2,FALSE),\"\"))","v":"Februar"},null,null,null,null,{"$f":"IF(OR($AI$1=2,$AI$1=5),VLOOKUP($AI$2+2,$D$68:$F$82,2,FALSE),IF(OR($AI$1=3,$AI$1=6),VLOOKUP($AI$2,$D$68:$F$82,2,FALSE),\"\"))","v":"März"},null,null,null,null,{"$f":"IF(OR($AI$1=2,$AI$1=5),VLOOKUP($AI$2+3,$D$68:$F$82,2,FALSE),IF(OR($AI$1=3,$AI$1=6),VLOOKUP($AI$2,$D$68:$F$82,2,FALSE),\"\"))","v":"April"},null,null,null,null,{"$f":"IF(OR($AI$1=2,$AI$1=5),VLOOKUP($AI$2+4,$D$68:$F$82,2,FALSE),IF(OR($AI$1=3,$AI$1=6),VLOOKUP($AI$2+1,$D$68:$F$82,2,FALSE),\"\"))","v":"Mai"},null,null,null,null,{"$f":"IF(OR($AI$1=2,$AI$1=5),VLOOKUP($AI$2+5,$D$68:$F$82,2,FALSE),IF(OR($AI$1=3,$AI$1=6),VLOOKUP($AI$2+1,$D$68:$F$82,2,FALSE),\"\"))","v":"Juni"},null,null,null,null,"Total","Total"]
["alphabetisch geordnet\npar ordre alphabétique","Prénom","Fonction"," NH",{"$f":"IF(OR($AI$1=2,$AI$1=5),VLOOKUP($AI$2,$D$68:$F$82,3,FALSE),IF(OR($AI$1=3,$AI$1=6),VLOOKUP($AI$2,$D$68:$F$82,3,FALSE),IF(OR($AI$1=4,$AI$1=7),VLOOKUP($AI$2,$D$68:$F$82,3,FALSE),\"\")))","v":"Janvier"},null,null,null,null,{"$f":"IF(OR($AI$1=2,$AI$1=5),VLOOKUP($AI$2+1,$D$68:$F$82,3,FALSE),IF(OR($AI$1=3,$AI$1=6),VLOOKUP($AI$2,$D$68:$F$82,3,FALSE),\"\"))","v":"Février"},null,null,null,null,{"$f":"IF(OR($AI$1=2,$AI$1=5),VLOOKUP($AI$2+2,$D$68:$F$82,3,FALSE),IF(OR($AI$1=3,$AI$1=6),VLOOKUP($AI$2,$D$68:$F$82,3,FALSE),\"\"))","v":"Mars"},null,null,null,null,{"$f":"IF(OR($AI$1=2,$AI$1=5),VLOOKUP($AI$2+3,$D$68:$F$82,3,FALSE),IF(OR($AI$1=3,$AI$1=6),VLOOKUP($AI$2,$D$68:$F$82,3,FALSE),\"\"))","v":"Avril"},null,null,null,null,{"$f":"IF(OR($AI$1=2,$AI$1=5),VLOOKUP($AI$2+4,$D$68:$F$82,3,FALSE),IF(OR($AI$1=3,$AI$1=6),VLOOKUP($AI$2+1,$D$68:$F$82,3,FALSE),\"\"))","v":"Mai"},null,null,null,null,{"$f":"IF(OR($AI$1=2,$AI$1=5),VLOOKUP($AI$2+5,$D$68:$F$82,3,FALSE),IF(OR($AI$1=3,$AI$1=6),VLOOKUP($AI$2+1,$D$68:$F$82,3,FALSE),\"\"))","v":"Juin"},null,null,null,null,"Präsenz"," ***  LE"]
[null,null," *","Tag/Jour ->",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"présence","UP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C13=0,0,IF(OR('Behinderte-Handicapés'!$V$1=\"Tageskurs\",'Behinderte-Handicapés'!$V$1=\"cours journalier\"),1,COUNTIFS($E13:$AH13,\">0\",$E$12:$AH$12,\">0\")))","v":0},{"$f":"IF(OR($D$6=0,$G$6=0,A13=0,B13=0,AND(C13<>\"L\",C13<>\"A\",C13<>\"H\",C13<>\"M\",C13<>\"AS\",C13<>\"AU\")),0,IF(OR(D13=1,D13=2,D13=3),AI13*$T$6,IF(OR(C13>=9,C13=0),0,)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C14=0,0,IF(OR('Behinderte-Handicapés'!$V$1=\"Tageskurs\",'Behinderte-Handicapés'!$V$1=\"cours journalier\"),1,COUNTIFS($E14:$AH14,\">0\",$E$12:$AH$12,\">0\")))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C15=0,0,IF(OR('Behinderte-Handicapés'!$V$1=\"Tageskurs\",'Behinderte-Handicapés'!$V$1=\"cours journalier\"),1,COUNTIFS($E15:$AH15,\">0\",$E$12:$AH$12,\">0\")))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C16=0,0,IF(OR('Behinderte-Handicapés'!$V$1=\"Tageskurs\",'Behinderte-Handicapés'!$V$1=\"cours journalier\"),1,COUNTIFS($E16:$AH16,\">0\",$E$12:$AH$12,\">0\")))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C17=0,0,IF(OR('Behinderte-Handicapés'!$V$1=\"Tageskurs\",'Behinderte-Handicapés'!$V$1=\"cours journalier\"),1,COUNTIFS($E17:$AH17,\">0\",$E$12:$AH$12,\">0\")))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C18=0,0,IF(OR('Behinderte-Handicapés'!$V$1=\"Tageskurs\",'Behinderte-Handicapés'!$V$1=\"cours journalier\"),1,COUNTIFS($E18:$AH18,\">0\",$E$12:$AH$12,\">0\")))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C19=0,0,IF(OR('Behinderte-Handicapés'!$V$1=\"Tageskurs\",'Behinderte-Handicapés'!$V$1=\"cours journalier\"),1,COUNTIFS($E19:$AH19,\">0\",$E$12:$AH$12,\">0\")))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C20=0,0,IF(OR('Behinderte-Handicapés'!$V$1=\"Tageskurs\",'Behinderte-Handicapés'!$V$1=\"cours journalier\"),1,COUNTIFS($E20:$AH20,\">0\",$E$12:$AH$12,\">0\")))","v":0},{"$f":"IF(OR($D$6=0,$G$6=0,A20=0,B20=0,AND(C20<>\"L\",C20<>\"A\",C20<>\"H\",C20<>\"M\",C20<>\"AS\",C20<>\"AU\")),0,IF(OR(D20=1,D20=2,D20=3),AI20*$T$6,IF(OR(C20>=9,C20=0),0,)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C21=0,0,IF(OR('Behinderte-Handicapés'!$V$1=\"Tageskurs\",'Behinderte-Handicapés'!$V$1=\"cours journalier\"),1,COUNTIFS($E21:$AH21,\">0\",$E$12:$AH$12,\">0\")))","v":0},{"$f":"IF(OR($D$6=0,$G$6=0,A21=0,B21=0,AND(C21<>\"L\",C21<>\"A\",C21<>\"H\",C21<>\"M\",C21<>\"AS\",C21<>\"AU\")),0,IF(OR(D21=1,D21=2,D21=3),AI21*$T$6,IF(OR(C21>=9,C21=0),0,)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C22=0,0,IF(OR('Behinderte-Handicapés'!$V$1=\"Tageskurs\",'Behinderte-Handicapés'!$V$1=\"cours journalier\"),1,COUNTIFS($E22:$AH22,\">0\",$E$12:$AH$12,\">0\")))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C23=0,0,IF(OR('Behinderte-Handicapés'!$V$1=\"Tageskurs\",'Behinderte-Handicapés'!$V$1=\"cours journalier\"),1,COUNTIFS($E23:$AH23,\">0\",$E$12:$AH$12,\">0\")))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C24=0,0,IF(OR('Behinderte-Handicapés'!$V$1=\"Tageskurs\",'Behinderte-Handicapés'!$V$1=\"cours journalier\"),1,COUNTIFS($E24:$AH24,\">0\",$E$12:$AH$12,\">0\")))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C25=0,0,IF(OR('Behinderte-Handicapés'!$V$1=\"Tageskurs\",'Behinderte-Handicapés'!$V$1=\"cours journalier\"),1,COUNTIFS($E25:$AH25,\">0\",$E$12:$AH$12,\">0\")))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C26=0,0,IF(OR('Behinderte-Handicapés'!$V$1=\"Tageskurs\",'Behinderte-Handicapés'!$V$1=\"cours journalier\"),1,COUNTIFS($E26:$AH26,\">0\",$E$12:$AH$12,\">0\")))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C27=0,0,IF(OR('Behinderte-Handicapés'!$V$1=\"Tageskurs\",'Behinderte-Handicapés'!$V$1=\"cours journalier\"),1,COUNTIFS($E27:$AH27,\">0\",$E$12:$AH$12,\">0\")))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C28=0,0,IF(OR('Behinderte-Handicapés'!$V$1=\"Tageskurs\",'Behinderte-Handicapés'!$V$1=\"cours journalier\"),1,COUNTIFS($E28:$AH28,\">0\",$E$12:$AH$12,\">0\")))","v":0},0]
[null,null,null,"Total L/M*",{"$f":"IF(E12=0,0,COUNTA(E13:E28))","v":0},{"$f":"IF(F12=0,0,COUNTA(F13:F28))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AI13:AI28)","v":0},{"$f":"SUM(AJ13:AJ28)","v":0}]
[null,null,null,"Verhältnis / ratio L/M*:TN",{"$f":"IF('Behinderte-Handicapés'!G34=0,0,\"1:\"&ROUND('Behinderte-Handicapés'!G34/E29,1))","v":0},{"$f":"IF('Behinderte-Handicapés'!H34=0,0,\"1:\"&ROUND('Behinderte-Handicapés'!H34/F29,1))","v":0},{"$f":"IF('Behinderte-Handicapés'!I34=0,0,\"1:\"&ROUND('Behinderte-Handicapés'!I34/G29,1))","v":0},{"$f":"IF('Behinderte-Handicapés'!J34=0,0,\"1:\"&ROUND('Behinderte-Handicapés'!J34/H29,1))","v":0},{"$f":"IF('Behinderte-Handicapés'!K34=0,0,\"1:\"&ROUND('Behinderte-Handicapés'!K34/I29,1))","v":0},{"$f":"IF('Behinderte-Handicapés'!L34=0,0,\"1:\"&ROUND('Behinderte-Handicapés'!L34/J29,1))","v":0},{"$f":"IF('Behinderte-Handicapés'!M34=0,0,\"1:\"&ROUND('Behinderte-Handicapés'!M34/K29,1))","v":0},{"$f":"IF('Behinderte-Handicapés'!N34=0,0,\"1:\"&ROUND('Behinderte-Handicapés'!N34/L29,1))","v":0},{"$f":"IF('Behinderte-Handicapés'!O34=0,0,\"1:\"&ROUND('Behinderte-Handicapés'!O34/M29,1))","v":0},{"$f":"IF('Behinderte-Handicapés'!P34=0,0,\"1:\"&ROUND('Behinderte-Handicapés'!P34/N29,1))","v":0},{"$f":"IF('Behinderte-Handicapés'!Q34=0,0,\"1:\"&ROUND('Behinderte-Handicapés'!Q34/O29,1))","v":0},{"$f":"IF('Behinderte-Handicapés'!R34=0,0,\"1:\"&ROUND('Behinderte-Handicapés'!R34/P29,1))","v":0},{"$f":"IF('Behinderte-Handicapés'!S34=0,0,\"1:\"&ROUND('Behinderte-Handicapés'!S34/Q29,1))","v":0},{"$f":"IF('Behinderte-Handicapés'!T34=0,0,\"1:\"&ROUND('Behinderte-Handicapés'!T34/R29,1))","v":0},{"$f":"IF('Behinderte-Handicapés'!U34=0,0,\"1:\"&ROUND('Behinderte-Handicapés'!U34/S29,1))","v":0},{"$f":"IF('Behinderte-Handicapés'!V34=0,0,\"1:\"&ROUND('Behinderte-Handicapés'!V34/T29,1))","v":0},{"$f":"IF('Behinderte-Handicapés'!W34=0,0,\"1:\"&ROUND('Behinderte-Handicapés'!W34/U29,1))","v":0},{"$f":"IF('Behinderte-Handicapés'!X34=0,0,\"1:\"&ROUND('Behinderte-Handicapés'!X34/V29,1))","v":0},{"$f":"IF('Behinderte-Handicapés'!Y34=0,0,\"1:\"&ROUND('Behinderte-Handicapés'!Y34/W29,1))","v":0},{"$f":"IF('Behinderte-Handicapés'!Z34=0,0,\"1:\"&ROUND('Behinderte-Handicapés'!Z34/X29,1))","v":0},{"$f":"IF('Behinderte-Handicapés'!AA34=0,0,\"1:\"&ROUND('Behinderte-Handicapés'!AA34/Y29,1))","v":0},{"$f":"IF('Behinderte-Handicapés'!AB34=0,0,\"1:\"&ROUND('Behinderte-Handicapés'!AB34/Z29,1))","v":0},{"$f":"IF('Behinderte-Handicapés'!AC34=0,0,\"1:\"&ROUND('Behinderte-Handicapés'!AC34/AA29,1))","v":0},{"$f":"IF('Behinderte-Handicapés'!AD34=0,0,\"1:\"&ROUND('Behinderte-Handicapés'!AD34/AB29,1))","v":0},{"$f":"IF('Behinderte-Handicapés'!AE34=0,0,\"1:\"&ROUND('Behinderte-Handicapés'!AE34/AC29,1))","v":0},{"$f":"IF('Behinderte-Handicapés'!AF34=0,0,\"1:\"&ROUND('Behinderte-Handicapés'!AF34/AD29,1))","v":0},{"$f":"IF('Behinderte-Handicapés'!AG34=0,0,\"1:\"&ROUND('Behinderte-Handicapés'!AG34/AE29,1))","v":0},{"$f":"IF('Behinderte-Handicapés'!AH34=0,0,\"1:\"&ROUND('Behinderte-Handicapés'!AH34/AF29,1))","v":0},{"$f":"IF('Behinderte-Handicapés'!AI34=0,0,\"1:\"&ROUND('Behinderte-Handicapés'!AI34/AG29,1))","v":0},{"$f":"IF('Behinderte-Handicapés'!AJ34=0,0,\"1:\"&ROUND('Behinderte-Handicapés'!AJ34/AH29,1))","v":0}]
[]
["*    L / A / H = Leiter / Assistent / Helfer ",null,null,null,"Präsent/Présent = 1",null,null,null,null,{"$f":"IF(AVERAGEIF(E29:AH29,\">0\")<2,\"< Jeder Kurs muss mindestens durch 1 Behindertensportleiter plus 1 Assistenten geleitet werden (Qualitätsvorgabe) !\",\"\")","v":{"$error":"#DIV/0!"}}]
["     M / AS / AU = Moniteur / Assistant / Auxiliaire",null,null,null,null,null,null,null,null,{"$f":"IF(AVERAGEIF(E29:AH29,\">0\")<2,\"< Chaque cours doit être encadré par au moins 1 moniteur de sport-handicap et 1 assistant (exigence de qualité) !\",\"\")","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total HS1",{"$f":"SUMIF($D$13:$D$28,\"=1\",$AJ$13:$AJ$28)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR('Behinderte-Handicapés'!$V$1=\"Tageskurs\",'Behinderte-Handicapés'!$V$1=\"cours journalier\"),I35>1),\"Tagekurs = nur 1 Tag!\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total HS2",{"$f":"SUMIF($D$13:$D$28,\"=2\",$AJ$13:$AJ$28)","v":0}]
["**   HS = Honorarstufe     NH = Niveau d'honoraires",null,null,null,"Anzahl Tage:",null,null,null,{"$f":"COUNTIF(E12:AH12,\">0\")","v":0},null,{"$f":"IF(AND(OR('Behinderte-Handicapés'!$V$1=\"Tageskurs\",'Behinderte-Handicapés'!$V$1=\"cours journalier\"),I35>1),\"cours journalier = seulement 1 jour!\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total HS3",{"$f":"SUMIF($D$13:$D$28,\"=3\",$AJ$13:$AJ$28)","v":0}]
[]
["***  LE  = Leistungseinheit     UP = Unités de prestation"]
[null,null,null,null,"Datum:\nDate:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift:\nSignature:"]
[]
["fehlende / falsche Angaben - information manque /inexact"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,1,"Kursart"]
[null,null,null,2,"Semesterkurs"]
[null,null,null,3,"Blockkurs"]
[null,null,null,4,"Tageskurs"]
[null,null,null,5,"Cours semestriel"]
[null,null,null,6,"Cours en bloc"]
[null,null,null,7,"Cours journalier"]
[]
[null,null,null,1,"Januar","Janvier"]
[null,null,null,2,"Februar","Février"]
[null,null,null,3,"März","Mars"]
[null,null,null,4,"April","Avril"]
[null,null,null,5,"Mai","Mai"]
[null,null,null,6,"Juni","Juin"]
[null,null,null,7,"Juli","Julliet"]
[null,null,null,8,"August","Août"]
[null,null,null,9,"September","Septembre"]
[null,null,null,10,"Oktober","Octobre"]
[null,null,null,11,"November","Novembre"]
[null,null,null,12,"Dezember","Décembre"]
[null,null,null,13,"Monat?"]
[null,null,null,14,"Neues Jahr"]
[null,null,null,15,"Neues Jahr"]

{"sheet":"Behinderte-Handicapés","index":1,"n_rows":54,"n_cols":39,"rows_kept":54,"cut":false,"hidden":false,"merged":[[9,11,9,15],[9,16,9,20],[9,21,9,25],[5,14,7,19],[2,0,4,0],[2,1,4,2],[2,4,4,4],[2,6,4,22],[5,11,7,13],[5,9,7,10],[5,4,7,4],[5,0,7,0],[5,1,7,1],[5,2,7,2],[5,6,7,8],[10,11,10,15],[10,16,10,20],[10,21,10,25],[10,26,10,30],[10,31,10,35],[10,0,11,0],[10,1,11,1],[10,2,11,2],[10,3,10,4],[10,6,10,10],[11,3,11,4],[9,5,11,5],[9,3,9,4],[9,6,9,10],[41,25,43,29],[41,30,43,37],[9,31,9,35],[5,20,7,22],[5,23,7,23],[5,24,7,27],[5,28,7,37],[9,26,9,30],[0,27,0,31],[1,27,1,31],[0,21,0,25],[38,25,40,29],[38,30,40,37],[2,27,4,35],[2,36,4,37],[2,23,4,23],[2,24,4,26],[8,20,8,29]]}
["Präsenzliste",{"$f":"'Leiter_Helfer-moniteur_aide'!B1","v":"Erfassen / compléter s.v.p"},null,null," Behinderte",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(AK1,'Leiter_Helfer-moniteur_aide'!D60:E66,2,FALSE)","v":"Cours semestriel"},null,null,null,null,null,{"$f":"G10&\"-\"&AF10","v":"Januar-Juni"},null,null,null,null,null,null,null,null,{"$f":"'Leiter_Helfer-moniteur_aide'!AI1","v":5},"1. Semester"]
["Liste de présence ",null,null,null," Handicapés",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G11&\"-\"&AF11","v":"Janvier-Juin"},null,null,null,null,null,null,null,null,null,"2. Semester"]
["Sportclub / Club sportif:",{"$f":"'Leiter_Helfer-moniteur_aide'!B3","v":"AS Fair Play SHL - 7550"},null,null,"   Kurs:\n   Cours:",null,{"$f":"'Leiter_Helfer-moniteur_aide'!H3","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ort:\nLieu:",null,null,{"$f":"'Leiter_Helfer-moniteur_aide'!AA3","v":0}]
[]
[]
["Wochentag / Jour:",{"$f":"'Leiter_Helfer-moniteur_aide'!B6","v":0},"  von\n de ",null,{"$f":"'Leiter_Helfer-moniteur_aide'!D6","v":"00:00:00"},null,"   Uhr bis\n   heures à",null,null,{"$f":"'Leiter_Helfer-moniteur_aide'!G6","v":"00:00:00"},null,"  Uhr\n  heures",null,null,"Kursdauer:\nDurée de cours:",null,null,null,null,null,{"$f":"IF((J6-E6)*24>5,5,(J6-E6)*24)","v":0},null,null,null,"Leiter:\nMoniteur:",null,null,null,{"$f":"'Leiter_Helfer-moniteur_aide'!AB6","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((J6-E6)*24>5,\"max 5h anrechenbar / payant\",\"\")","v":""}]
["Name / Nom","Vorname","Geburtsdatum","Behinderung",null,"Encadrement pendant cours \n1, 2, 3",{"$f":"'Leiter_Helfer-moniteur_aide'!E10","v":"Januar"},null,null,null,null,{"$f":"'Leiter_Helfer-moniteur_aide'!J10","v":"Februar"},null,null,null,null,{"$f":"'Leiter_Helfer-moniteur_aide'!O10","v":"März"},null,null,null,null,{"$f":"'Leiter_Helfer-moniteur_aide'!T10","v":"April"},null,null,null,null,{"$f":"'Leiter_Helfer-moniteur_aide'!Y10","v":"Mai"},null,null,null,null,{"$f":"'Leiter_Helfer-moniteur_aide'!AD10","v":"Juni"},null,null,null,null,"Total","Total"]
["alphabetisch geordnet                     par ordre alphabétique","Prénom\n  ","Date de naissance","Handicap *",null,null,{"$f":"'Leiter_Helfer-moniteur_aide'!E11","v":"Janvier"},null,null,null,null,{"$f":"'Leiter_Helfer-moniteur_aide'!J11","v":"Février"},null,null,null,null,{"$f":"'Leiter_Helfer-moniteur_aide'!O11","v":"Mars"},null,null,null,null,{"$f":"'Leiter_Helfer-moniteur_aide'!T11","v":"Avril"},null,null,null,null,{"$f":"'Leiter_Helfer-moniteur_aide'!Y11","v":"Mai"},null,null,null,null,{"$f":"'Leiter_Helfer-moniteur_aide'!AD11","v":"Juin"},null,null,null,null,"Präsenz"," **   LE"]
[null,null,null,null,null,null,{"$f":"'Leiter_Helfer-moniteur_aide'!E12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!F12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!G12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!H12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!I12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!J12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!K12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!L12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!M12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!N12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!O12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!P12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!Q12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!R12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!S12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!T12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!U12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!V12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!W12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!X12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!Y12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!Z12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!AA12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!AB12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!AC12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!AD12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!AE12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!AF12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!AG12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!AH12","v":0},"présence","UP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AND(OR(E13=\"SH\",E13=\"NB\"),OR($V$1=\"Tageskurs\",$V$1=\"cours journalier\"))),SUM(G13:AJ13)/COUNT(G13:AJ13),IF(OR(A13=0,B13=0,C13=0,E13=0,E13=\"NB\",E13=\"SH\"),0,IF(OR(E13=\"HM\",E13=\"HO\",E13=\"HP\",E13=\"Hmal\",E13=\"HY\",E13=\"HV\",E13=\"HL\",E13=\"HD\",E13=\"GB\",E13=\"HB\",E13=\"KB\",E13=\"KH\",E13=\"PB\",E13=\"SB\",E13=\"SP\",E13=\"SU\"),IF(OR($V$1=\"Tageskurs\",$V$1=\"cours journalier\"),1,COUNTIFS($G13:$AJ13,\">0\",$G$12:$AJ$12,\">0\")),0)))","v":0},{"$f":"IF(OR(AND(OR(E13=\"SH\",E13=\"NB\"),OR($V$1=\"Tageskurs\",$V$1=\"cours journalier\"))),AK13*IF($U$6>5,5,$U$6),IF(OR(A13=0,B13=0,C13=0,E13=0,E13=\"NB\",E13=\"SH\"),0,IF(OR(E13=\"HM\",E13=\"HO\",E13=\"HP\",E13=\"Hmal\",E13=\"HY\",E13=\"HV\",E13=\"HL\",E13=\"HD\",E13=\"GB\",E13=\"HB\",E13=\"KB\",E13=\"KH\",E13=\"PB\",E13=\"SB\",E13=\"SP\",E13=\"SU\"),AK13*IF($U$6>5,5,$U$6),0)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"Mittelwert Blatt1:\nmoyenne feuille1:",{"$f":"IFERROR(AVERAGEIF(G33:AJ33,\">0\"),\"-\")","v":"-"},null,"Total",{"$f":"IFERROR(AVERAGEIF(F13:F32,\">0\"),\"-\")","v":"-"},{"$f":"IF(G12=0,0,IF(OR($V$1=\"Tageskurs\",$V$1=\"cours journalier\"),COUNTA(G13:G32),COUNTA(G13:G32)-(COUNTIFS($E13:$E32,\"nb\",G13:G32,\">0\")+COUNTIFS($E13:$E32,\"sh\",G13:G32,\">0\"))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AK13:AK32)","v":0},0,{"$f":"COUNTIF(F13:F32,3)","v":0}]
[{"$f":"IF(V1<>\"Tageskurs\",\"exkl. NB / SH\",0)","v":"exkl. NB / SH"},"Mittelwert Blatt 1+2:\nmoyenne feuille 1+2:",{"$f":"IFERROR(AVERAGEIF(G34:AJ34,\">0\"),\"-\")","v":"-"},null,"TotalBlatt 1+2",{"$f":"IFERROR(AVERAGEIF(F13:F32,\">0\"),\"-\")","v":"-"},{"$f":"'Behinderte-Handicapés(2)'!G33+'Behinderte-Handicapés'!G33","v":0},{"$f":"'Behinderte-Handicapés(2)'!H33+'Behinderte-Handicapés'!H33","v":0},{"$f":"'Behinderte-Handicapés(2)'!I33+'Behinderte-Handicapés'!I33","v":0},{"$f":"'Behinderte-Handicapés(2)'!J33+'Behinderte-Handicapés'!J33","v":0},{"$f":"'Behinderte-Handicapés(2)'!K33+'Behinderte-Handicapés'!K33","v":0},{"$f":"'Behinderte-Handicapés(2)'!L33+'Behinderte-Handicapés'!L33","v":0},{"$f":"'Behinderte-Handicapés(2)'!M33+'Behinderte-Handicapés'!M33","v":0},{"$f":"'Behinderte-Handicapés(2)'!N33+'Behinderte-Handicapés'!N33","v":0},{"$f":"'Behinderte-Handicapés(2)'!O33+'Behinderte-Handicapés'!O33","v":0},{"$f":"'Behinderte-Handicapés(2)'!P33+'Behinderte-Handicapés'!P33","v":0},{"$f":"'Behinderte-Handicapés(2)'!Q33+'Behinderte-Handicapés'!Q33","v":0},{"$f":"'Behinderte-Handicapés(2)'!R33+'Behinderte-Handicapés'!R33","v":0},{"$f":"'Behinderte-Handicapés(2)'!S33+'Behinderte-Handicapés'!S33","v":0},{"$f":"'Behinderte-Handicapés(2)'!T33+'Behinderte-Handicapés'!T33","v":0},{"$f":"'Behinderte-Handicapés(2)'!U33+'Behinderte-Handicapés'!U33","v":0},{"$f":"'Behinderte-Handicapés(2)'!V33+'Behinderte-Handicapés'!V33","v":0},{"$f":"'Behinderte-Handicapés(2)'!W33+'Behinderte-Handicapés'!W33","v":0},{"$f":"'Behinderte-Handicapés(2)'!X33+'Behinderte-Handicapés'!X33","v":0},{"$f":"'Behinderte-Handicapés(2)'!Y33+'Behinderte-Handicapés'!Y33","v":0},{"$f":"'Behinderte-Handicapés(2)'!Z33+'Behinderte-Handicapés'!Z33","v":0},{"$f":"'Behinderte-Handicapés(2)'!AA33+'Behinderte-Handicapés'!AA33","v":0},{"$f":"'Behinderte-Handicapés(2)'!AB33+'Behinderte-Handicapés'!AB33","v":0},{"$f":"'Behinderte-Handicapés(2)'!AC33+'Behinderte-Handicapés'!AC33","v":0},{"$f":"'Behinderte-Handicapés(2)'!AD33+'Behinderte-Handicapés'!AD33","v":0},{"$f":"'Behinderte-Handicapés(2)'!AE33+'Behinderte-Handicapés'!AE33","v":0},{"$f":"'Behinderte-Handicapés(2)'!AF33+'Behinderte-Handicapés'!AF33","v":0},{"$f":"'Behinderte-Handicapés(2)'!AG33+'Behinderte-Handicapés'!AG33","v":0},{"$f":"'Behinderte-Handicapés(2)'!AH33+'Behinderte-Handicapés'!AH33","v":0},{"$f":"'Behinderte-Handicapés(2)'!AI33+'Behinderte-Handicapés'!AI33","v":0},{"$f":"'Behinderte-Handicapés(2)'!AJ33+'Behinderte-Handicapés'!AJ33","v":0},{"$f":"SUM('Behinderte-Handicapés(2)'!AK13:AK32)+'Behinderte-Handicapés'!AK33","v":0},{"$f":"SUM('Behinderte-Handicapés(2)'!AL13:AL32)+'Behinderte-Handicapés'!AL33","v":0}]
[]
["information manque /inexact = pas UP",null,null,1," GB Geistig- Lernbehinderte",null,null,null,null,null,"HM Handicap mental ou ayant des difficultés d’apprentissage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Präsent / Présent = 1",null,null,null,null,null,null,null,null,"**"," LE = Leistungseinheit"]
[null,null,null,2," HB Hörbehinderte",null,null,null,null,null,"HO Handicap de l'ouïe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," UP = Unités de prestation"]
[null,null,null,3," KB Körperbehinderte",null,null,null,null,null,"HP Handicap physique"]
[null,null,null,4," KH Krankheitsbehinderte",null,null,null,null,null,"Hmal Handicap par suite de maladie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Datum:\nDate:",null,null,null,null,{"$f":"'Leiter_Helfer-moniteur_aide'!H38","v":"00:00:00"}]
[null,null,null,5," PB Psychischbehinderte",null,null,null,null,null,"HY Handicap psychique"]
[null,null,null,6," SB Sehbehinderte",null,null,null,null,null,"HV Handicap de la vue"]
[null,null,null,7," SP Sprachbehinderte",null,null,null,null,null,"HL Handicap du langage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift:\nSignature:",null,null,null,null,{"$f":"'Leiter_Helfer-moniteur_aide'!AA38","v":0}]
[null,null,null,8," SU Suchtbehinderte",null,null,null,null,null,"HD Handicap par suite de dépendance"]
["Nouveau à compléter merci",null,null,9," NB Nichtbehindert",null,null,null,null,null,"SH Sans handicap"]
[]
["Encadrement pendant la leçon de sport"]
["Important:"]
["à Classification de chaque sportif par offre auquel il a participé"]
["Niveau 1"]
["Taux d’encadrement de  1:6 à 1:10 - faible (rapport moniteurs/aides:sportifs)"]
["Niveau 2"]
["Taux d’encadrement de  1:3 à 1:5 - moyen"]
["Niveau 3"]
["Taux d’encadrement de  1:2 à 1:1 - élevé "]

{"sheet":"Behinderte-Handicapés(2)","index":2,"n_rows":43,"n_cols":39,"rows_kept":43,"cut":false,"hidden":false,"merged":[[5,0,7,0],[5,1,7,1],[5,2,7,2],[0,21,0,25],[2,0,4,0],[2,1,4,2],[2,4,4,4],[2,6,4,22],[2,23,4,23],[2,24,4,26],[10,11,10,15],[10,16,10,20],[10,21,10,25],[5,4,7,4],[5,6,7,8],[9,3,9,4],[9,6,9,10],[9,11,9,15],[5,9,7,10],[5,11,7,13],[5,14,7,19],[5,20,7,22],[5,23,7,23],[5,24,7,27],[9,16,9,20],[8,20,8,29],[10,0,11,0],[10,1,11,1],[10,2,11,2],[10,3,10,4],[10,6,10,10],[11,3,11,4],[9,5,11,5],[0,27,0,31],[1,27,1,31],[40,25,42,29],[40,30,42,37],[37,25,39,29],[37,30,39,37],[9,26,9,30],[9,31,9,35],[2,27,4,35],[2,36,4,37],[5,28,7,37],[10,26,10,30],[10,31,10,35],[9,21,9,25]]}
["Präsenzliste",{"$f":"'Leiter_Helfer-moniteur_aide'!B1","v":"Erfassen / compléter s.v.p"},null,null," Behinderte",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(AK1,'Leiter_Helfer-moniteur_aide'!D60:E66,2,FALSE)","v":"Cours semestriel"},null,null,null,null,null,{"$f":"G10&\"-\"&AF10","v":"Januar-Juni"},null,null,null,null,null,null,null,null,{"$f":"'Leiter_Helfer-moniteur_aide'!AI1","v":5},"1. Semester"]
["Liste de présence ",null,null,null," Handicapés",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G11&\"-\"&AF11","v":"Janvier-Juin"},null,null,null,null,null,null,null,null,null,"2. Semester"]
["Sportclub / Club sportif:",{"$f":"'Leiter_Helfer-moniteur_aide'!B3","v":"AS Fair Play SHL - 7550"},null,null,"   Kurs:\n   Cours:",null,{"$f":"'Leiter_Helfer-moniteur_aide'!H3","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ort:\nLieu:",null,null,{"$f":"'Leiter_Helfer-moniteur_aide'!AA3","v":0}]
[]
[]
["Wochentag / Jour:",{"$f":"'Leiter_Helfer-moniteur_aide'!B6","v":0},"  von\n de ",null,{"$f":"'Leiter_Helfer-moniteur_aide'!D6","v":"00:00:00"},null,"   Uhr bis\n   heures à",null,null,{"$f":"'Leiter_Helfer-moniteur_aide'!G6","v":"00:00:00"},null,"  Uhr\n  heures",null,null,"Kursdauer:\nDurée de cours:",null,null,null,null,null,{"$f":"IF((J6-E6)*24>5,5,(J6-E6)*24)","v":0},null,null,null,"Leiter:\nMoniteur:",null,null,null,{"$f":"'Leiter_Helfer-moniteur_aide'!AB6","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((J6-E6)*24>5,\"max 5h anrechenbar / payant\",\"\")","v":""}]
["Name / Nom","Vorname","Geburtsdatum","Behinderung",null,"Betreuungs-stufe\nEncadrement pendant cours \n1, 2, 3",{"$f":"'Leiter_Helfer-moniteur_aide'!E10","v":"Januar"},null,null,null,null,{"$f":"'Leiter_Helfer-moniteur_aide'!J10","v":"Februar"},null,null,null,null,{"$f":"'Leiter_Helfer-moniteur_aide'!O10","v":"März"},null,null,null,null,{"$f":"'Leiter_Helfer-moniteur_aide'!T10","v":"April"},null,null,null,null,{"$f":"+'Leiter_Helfer-moniteur_aide'!Y10","v":"Mai"},null,null,null,null,{"$f":"+'Leiter_Helfer-moniteur_aide'!AD10","v":"Juni"},null,null,null,null,"Total","Total","Betreuung während der Sportlektion"]
["alphabetisch geordnet                     par ordre alphabétique","Prénom\n  ","Date de naissance","Handicap *",null,null,{"$f":"+'Leiter_Helfer-moniteur_aide'!E11","v":"Janvier"},null,null,null,null,{"$f":"+'Leiter_Helfer-moniteur_aide'!J11","v":"Février"},null,null,null,null,{"$f":"+'Leiter_Helfer-moniteur_aide'!O11","v":"Mars"},null,null,null,null,{"$f":"+'Leiter_Helfer-moniteur_aide'!T11","v":"Avril"},null,null,null,null,{"$f":"+'Leiter_Helfer-moniteur_aide'!Y11","v":"Mai"},null,null,null,null,{"$f":"+'Leiter_Helfer-moniteur_aide'!AD11","v":"Juin"},null,null,null,null,"Präsenz"," **   LE","Wichtig:"]
[null,null,null,null,null,null,{"$f":"'Leiter_Helfer-moniteur_aide'!E12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!F12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!G12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!H12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!I12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!J12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!K12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!L12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!M12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!N12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!O12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!P12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!Q12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!R12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!S12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!T12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!U12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!V12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!W12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!X12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!Y12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!Z12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!AA12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!AB12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!AC12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!AD12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!AE12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!AF12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!AG12","v":0},{"$f":"'Leiter_Helfer-moniteur_aide'!AH12","v":0},"présence","UP","àEinstufung jedes einzelnen Sportlers in jedem Sportangebot, das er besucht"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AND(OR(E13=\"SH\",E13=\"NB\"),OR($V$1=\"Tageskurs\",$V$1=\"cours journalier\"))),SUM(G13:AJ13)/COUNT(G13:AJ13),IF(OR(A13=0,B13=0,C13=0,E13=0,E13=\"NB\",E13=\"SH\"),0,IF(OR(E13=\"HM\",E13=\"HO\",E13=\"HP\",E13=\"Hmal\",E13=\"HY\",E13=\"HV\",E13=\"HL\",E13=\"HD\",E13=\"GB\",E13=\"HB\",E13=\"KB\",E13=\"KH\",E13=\"PB\",E13=\"SB\",E13=\"SP\",E13=\"SU\"),IF(OR($V$1=\"Tageskurs\",$V$1=\"cours journalier\"),1,COUNTIFS($G13:$AJ13,\">0\",$G$12:$AJ$12,\">0\")),0)))","v":0},{"$f":"IF(OR(AND(OR(E13=\"SH\",E13=\"NB\"),OR($V$1=\"Tageskurs\",$V$1=\"cours journalier\"))),AK13*IF($U$6>5,5,$U$6),IF(OR(A13=0,B13=0,C13=0,E13=0,E13=\"NB\",E13=\"SH\"),0,IF(OR(E13=\"HM\",E13=\"HO\",E13=\"HP\",E13=\"Hmal\",E13=\"HY\",E13=\"HV\",E13=\"HL\",E13=\"HD\",E13=\"GB\",E13=\"HB\",E13=\"KB\",E13=\"KH\",E13=\"PB\",E13=\"SB\",E13=\"SP\",E13=\"SU\"),AK13*IF($U$6>5,5,$U$6),0)))","v":0},"Stufe 1 (niedriger Betreuungsaufwand)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AND(OR(E14=\"SH\",E14=\"NB\"),OR($V$1=\"Tageskurs\",$V$1=\"cours journalier\"))),SUM(G14:AJ14)/COUNT(G14:AJ14),IF(OR(A14=0,B14=0,C14=0,E14=0,E14=\"NB\",E14=\"SH\"),0,IF(OR(E14=\"HM\",E14=\"HO\",E14=\"HP\",E14=\"Hmal\",E14=\"HY\",E14=\"HV\",E14=\"HL\",E14=\"HD\",E14=\"GB\",E14=\"HB\",E14=\"KB\",E14=\"KH\",E14=\"PB\",E14=\"SB\",E14=\"SP\",E14=\"SU\"),IF(OR($V$1=\"Tageskurs\",$V$1=\"cours journalier\"),1,COUNTIFS($G14:$AJ14,\">0\",$G$12:$AJ$12,\">0\")),0)))","v":0},0,"- Betreuungsverhältnis zwischen 1:6 und 1:10 oder höher (= Verhältnis Leiter/Helfer: Sportler)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"Stufe 2 (mittlerer Betreuungsaufwand)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"- Betreuungsverhältnis zwischen 1:3 und 1:5 "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"Stufe 3 (hoher Betreuungsaufwand)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"- Betreuungsverhältnis zwischen 1:2 und 1:1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"Encadrement pendant la leçon de sport"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"Important:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"à Classification de chaque sportif par offre auquel il a participé"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"Niveau 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"- Taux d’encadrement de  1:6 à 1:10 ou plus (= rapport moniteurs/aides:sportifs)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"Niveau 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"- Taux d’encadrement de  1:3 à 1:5 "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"Niveau 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"- Taux d’encadrement de  1:2 à 1:1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"Mittelwert Blatt2:\nmoyenne feuille2:",{"$f":"IFERROR(AVERAGEIF(G33:AJ33,\">0\"),\"-\")","v":"-"},null,"Total",{"$f":"IFERROR(AVERAGEIF(F13:F32,\">0\"),\"-\")","v":"-"},{"$f":"IF(G12=0,0,IF(OR($V$1=\"Tageskurs\",$V$1=\"cours journalier\"),COUNTA(G13:G32),COUNTA(G13:G32)-(COUNTIFS($E13:$E32,\"nb\",G13:G32,\">0\")+COUNTIFS($E13:$E32,\"sh\",G13:G32,\">0\"))))","v":0},{"$f":"IF(H12=0,0,IF(OR($V$1=\"Tageskurs\",$V$1=\"cours journalier\"),COUNTA(H13:H32),COUNTA(H13:H32)-(COUNTIFS($E13:$E32,\"nb\",H13:H32,\">0\")+COUNTIFS($E13:$E32,\"sh\",H13:H32,\">0\"))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AK13:AK32)","v":0},{"$f":"SUM(AL13:AL32)","v":0}]
[]
[null,null,null,1," GB Geistig- Lernbehinderte",null,null,null,null,null,"HM Handicap mental ou ayant des difficultés d’apprentissage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Präsent / Présent = 1",null,null,null,null,null,null,null,null,"**"," LE = Leistungseinheit"]
[null,null,null,2," HB Hörbehinderte",null,null,null,null,null,"HO Handicap de l'ouïe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," UP = Unités de prestation"]
[null,null,null,3," KB Körperbehinderte",null,null,null,null,null,"HP Handicap physique"]
[null,null,null,4," KH Krankheitsbehinderte",null,null,null,null,null,"Hmal Handicap par suite de maladie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Datum:\nDate:",null,null,null,null,{"$f":"'Leiter_Helfer-moniteur_aide'!H38","v":"00:00:00"}]
[null,null,null,5," PB Psychischbehinderte",null,null,null,null,null,"HY Handicap psychique"]
[null,null,null,6," SB Sehbehinderte",null,null,null,null,null,"HV Handicap de la vue"]
[null,null,null,7," SP Sprachbehinderte",null,null,null,null,null,"HL Handicap du langage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift:\nSignature:",null,null,null,null,{"$f":"'Leiter_Helfer-moniteur_aide'!AA38","v":0}]
["fehlende / falsche Angaben - ",null,null,8," SU Suchtbehinderte",null,null,null,null,null,"HD Handicap par suite de dépendance"]
["information manque /inexact",null,null,9," NB Nichtbehindert",null,null,null,null,null,"SH Sans handicap"]