{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Prüfergebnis","Fallübersicht","Mängelreport","Datenimport","InfoW","InfoR","MB temp","ZU temp","M2 temp","M3 temp","MB","ZU","M2","M3"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":6,"comments":4,"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":"row_number_cap","date_system":"1900"}

{"sheet":"Prüfergebnis","index":0,"n_rows":64,"n_cols":15,"rows_kept":64,"cut":false,"hidden":true,"merged":[]}
[null,"Ergebnis der Prüfung des Datenimports vom",null,null,"(berechnet in 0.0 Sekunden)"]
[]
[null,"importierte und getestete Teildatensätze",null,null,null,null,null,null,null,null," ",null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,null," ","ANQ-Reha-Test-2020_v7.1"]
[null,null,null,null,null,null,null,null,null,null," ",null,null," ","Datenjahr 2020"]
[null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[]
[null,"Zusammenfassung MB / ZU / M2 / M3 ingesamt",null,null,null,null,null,null,null,null,null,null,null,null,"Rehabereiche"]
[]
[null," Anzahl eindeutige FID (Fallnummern)",null,null,null,0,null,null,null,null,null,null,null,null,"unklar"]
[null,"Fälle mit eindeutiger FID und allen erforderlichen Teildatensätzen *",null,null,null,null,0,null,null,null,null,null,null,null,"Geriatrische Reha"]
[null,"davon Fälle ohne Dokumentationsmängel",null,null,null,null,null,0,null,null,null,null,null,null,"Internistische Reha"]
[null,"davon Drop-Out-Fälle **",null,null,null,null,null,0,null,null,null,null,null,null,"Kardiologische Reha"]
[null,"davon Fälle mit Dokumentationsmängeln",null,null,null,null,null,0,null,null,null,null,null,null,"Muskuloskelettale Reha"]
[null,"Fälle mit fehlenden Teildatensätzen (ohne Duplikate) ***",null,null,null,null,0,null,null,null,null,null,null,null,"Neurologische Reha"]
[null,"davon Fälle ohne Dokumentationsmängel",null,null,null,null,null,0,null,null,null,null,null,null,"Onkologische Reha"]
[null,"davon Fälle mit Dokumentationsmängeln",null,null,null,null,null,0,null,null,null,null,null,null,"Paraplegiologische Reha"]
[null,"Fälle mit Duplikaten in mindestens einem Teildatensatz",null,null,null,null,0,null,null,null,null,null,null,null,"Psychosomatische Reha"]
[null,"Fälle mit Duplikaten in mindestens einem Teildatensatz",null,null,null,null,null,0,null,null,null,null,null,null,"Pulmonale Reha"]
[]
[]
[null,"Zusammenfassung Teildatensätze",null,null,null,null,"MB","ZU","M2 (E)","M2 (A)","M2 (E/A)°","M3 (E)","M3 (A)","M3 (E/A)°","  ° M2 oder M3 mit unbestimmtem Messzeitpunkt"]
[]
[null,"gelieferte Fälle (Datenzeilen)",null,null,null,null,0,0,0,0,0,0,0,0]
[]
[null,"Datenzeilen mit einfach verwendeter FID (Fallnummer)",null,null,null,null,0,0,0,0,0,0,0,0]
[null,"Datenzeilen mit mehrfach verwendeter FID (ergibt Duplikate)",null,null,null,null,0,0,0,0,0,0,0,0]
[null,"Datenzeilen mit fehlender FID-Angabe",null,null,null,null,0,0,0,0,0,0,0,0]
[]
[null,"Datenzeilen mit Mängeln in der Dokumentation (ohne Duplikate und Drop-Outs)",null,null,null,null,0,0,0,0,null,0,0]
[]
[null,"fehlende Teildatensätze",null,null,null,null,0,0,0,0,null,0,0]
[]
[]
[null,"weitere Ergebnisse der Prüfung"]
[]
[null,"Tabellenblatt Fallübersicht","►","Übersicht, welche Teildatensätze pro FID geliefert wurden und wo Mängel vorliegen (z. B. in der ZU-Datei)"]
[null,"Tabellenblatt Mängelreport","►","(druckfertige) Zusammenstellung der Mängel pro Messfall"]
[null,"Tabellenblätter MB, ZU, M2, M3","►","Detailinformationen zum Auffinden von Dokumentationsfehlern pro Messfall (Angabe welcher Mangel in den Teildatensätzen MB,ZU, M2 bzw. M3 vorliegt)"]

{"sheet":"Fallübersicht","index":1,"n_rows":5,"n_cols":33,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,27,2,27],[0,28,2,28],[0,29,2,29],[0,21,2,21],[0,22,2,22],[0,23,2,23],[0,24,2,24],[0,25,2,25],[0,26,2,26]]}
[null,"ANQ-Reha-Test-2020_v7.1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HZ/ZE","FIM","EBI","Gehtest","Ergo","MacNew","Feel","CRQ","Testkombi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020]
[null,"FID","MB",null,"ZU",null,"M2 (E) ",null,"M2 (A)",null,"M3 (E) ",null,"M3 (A)",null,"Reha-\nBereich","COPD",null,"Diagnose","Reha-Eintritt","Reha-Austritt","Lieferzeitraum",null,null,null,null,null,null,null,null,null,null,"Bereich","COPD"]
[]
[null,null,{"$f":"COUNTIF('MB temp'!H:H,B5)","v":1},{"$f":"IF(C5>1,\"DUPLIKAT\",IF(C5=0,\"fehlend\",IF(VLOOKUP(B5,INDIRECT(\"'MB temp'!$H$6:$DO$\"&'MB temp'!$H$1+5),109,FALSE)=\"\",\"\",VLOOKUP(B5,INDIRECT(\"'MB temp'!$H$6:$DO$\"&'MB temp'!$H$1+5),109,FALSE))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('ZU temp'!H:H,B5)","v":1},{"$f":"IF(E5>1,\"DUPLIKAT\",IF(VLOOKUP(B5,INDIRECT(\"'InfoW'!$A$3:$L$\"&InfoW!$A$2+2),12,FALSE)=\"Drop-Out\",\"Drop-Out\",IF(E5=0,\"fehlend\",VLOOKUP(B5,INDIRECT(\"'ZU temp'!$H$6:$AT$\"&'ZU temp'!$H$1+5),39,FALSE))))","v":{"$error":"#N/A"}},{"$f":"COUNTIF('M2 temp'!A:A,B5&\"1\")","v":0},{"$f":"IF(G5>1,\"DUPLIKAT\",IF(VLOOKUP(B5,INDIRECT(\"'InfoW'!$A$3:$L$\"&InfoW!$A$2+2),12,FALSE)=\"Drop-Out\",\"Drop-Out\",IF(G5=0,IF(AND(K5=0,M5=0),\"fehlend\",\"\"),VLOOKUP(B5&\"1\",INDIRECT(\"'M2 temp'!$A$6:$EC$\"&'M2 temp'!$H$1+5),133,FALSE))))","v":"fehlend"},{"$f":"COUNTIF('M2 temp'!A:A,B5&\"2\")","v":0},{"$f":"IF(I5>1,\"DUPLIKAT\",IF(VLOOKUP(B5,INDIRECT(\"'InfoW'!$A$3:$L$\"&InfoW!$A$2+2),12,FALSE)=\"Drop-Out\",\"Drop-Out\",IF(I5=0,IF(AND(K5=0,M5=0),\"fehlend\",\"\"),VLOOKUP(B5&\"2\",INDIRECT(\"'M2 temp'!$A$6:$EC$\"&'M2 temp'!$H$1+5),133,FALSE))))","v":"fehlend"},{"$f":"COUNTIF('M3 temp'!A:A,B5&\"1\")","v":0},{"$f":"IF(K5>1,\"DUPLIKAT\",IF(VLOOKUP(B5,INDIRECT(\"'InfoW'!$A$3:$L$\"&InfoW!$A$2+2),12,FALSE)=\"Drop-Out\",\"Drop-Out\",IF(K5=0,IF(AND(G5=0,I5=0),\"fehlend\",\"\"),VLOOKUP(B5&\"1\",INDIRECT(\"'M3 temp'!$A$6:$FY$\"&'M3 temp'!$H$1+5),181,FALSE))))","v":"fehlend"},{"$f":"COUNTIF('M3 temp'!A:A,B5&\"2\")","v":0},{"$f":"IF(M5>1,\"DUPLIKAT\",IF(VLOOKUP(B5,INDIRECT(\"'InfoW'!$A$3:$L$\"&InfoW!$A$2+2),12,FALSE)=\"Drop-Out\",\"Drop-Out\",IF(M5=0,IF(AND(G5=0,I5=0),\"fehlend\",\"\"),VLOOKUP(B5&\"2\",INDIRECT(\"'M3 temp'!$A$6:$FY$\"&'M3 temp'!$H$1+5),181,FALSE))))","v":"fehlend"},{"$f":"IF(AF5=\"|||\",\"\",IFERROR(VLOOKUP(AF5,InfoR!$C$224:$E$374,3,FALSE),\"unklar\"))","v":""},{"$f":"IF(AND(O5=\"Pulmo\",AG5=\"|\"),\"?\",IFERROR(VLOOKUP(AG5,InfoR!$L$225:$M$231,2,FALSE),\"?\"))","v":""},{"$f":"IF(OR(P5=\"\",P5=\"?\",R5=\"\",AND(P5=\"ja\",MID(R5,1,3)=\"J44\"),AND(P5=\"nein\",MID(R5,1,3)<>\"J44\")),\"\",\"<>\")","v":{"$error":"#N/A"}},{"$f":"IF(C5=1,VLOOKUP(B5,INDIRECT(\"'MB temp'!$H$6:$DO$\"&'MB temp'!$H$1+5),112,FALSE),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(C5=1,VLOOKUP(B5,INDIRECT(\"'MB temp'!$H$6:$DO$\"&'MB temp'!$H$1+5),110,FALSE),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(C5=1,VLOOKUP(B5,INDIRECT(\"'MB temp'!$H$6:$EDO\"&'MB temp'!$H$1+5),111,FALSE),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(T5<>\"\",YEAR(T5),\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G5=1,VLOOKUP(B5&\"1\",INDIRECT(\"'M2 temp'!$A$5:$L$\"&'M2 temp'!$H$1+5),10,FALSE),\"\")&\"|\"&IF(I5=1,VLOOKUP(B5&\"2\",INDIRECT(\"'M2 temp'!$A$5:$L$\"&'M2 temp'!$H$1+5),10,FALSE),\"\")&\"|\"&IF(K5=1,VLOOKUP(B5&\"1\",INDIRECT(\"'M3 temp'!$A$5:$M$\"&'M3 temp'!$H$1+5),11,FALSE),\"\")&\"|\"&IF(M5=1,VLOOKUP(B5&\"2\",INDIRECT(\"'M3 temp'!$A$5:$M$\"&'M3 temp'!$H$1+5),11,FALSE),\"\")","v":"|||"},{"$f":"IF(K5=1,VLOOKUP(B5&\"1\",INDIRECT(\"'M3 temp'!$A$6:$M$\"&'M3 temp'!$H$1+5),10,FALSE),\"\")&\"|\"&IF(M5=1,VLOOKUP(B5&\"2\",INDIRECT(\"'M3 temp'!$A$6:$M$\"&'M3 temp'!$H$1+5),10,FALSE),\"\")","v":"|"}]

{"sheet":"Mängelreport","index":2,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":true,"merged":[],"read":"row_number_cap"}
["ANQ-Reha-Test-2020_v7.1"]
["FID  ","Datenquelle   ","Mängel in der Dokumentation \n(Details siehe Tabellenblätter MB / M2 / M3 / ZU)"]
[null,null,"Es liegen keine Mängel vor."]

{"sheet":"Datenimport","index":3,"n_rows":19,"n_cols":43,"rows_kept":19,"cut":false,"hidden":false,"merged":[[4,4,5,4]]}
[null,null,null,null,"ANQ-Reha-Test-2020_v7.1"]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"IF(ISBLANK(InfoW!O7),\"\",InfoW!O7)","v":""},null,{"$f":"IF(ISBLANK(InfoW!P7),\"\",InfoW!P7)","v":""},null,{"$f":"IF(ISBLANK(InfoW!Q7),\"\",InfoW!Q7)","v":""},null,{"$f":"IF(ISBLANK(InfoW!R7),\"\",InfoW!R7)","v":""},null,{"$f":"IF(ISBLANK(InfoW!S7),\"\",InfoW!S7)","v":""},null,{"$f":"IF(ISBLANK(InfoW!T7),\"\",InfoW!T7)","v":""},null,{"$f":"IF(ISBLANK(InfoW!U7),\"\",InfoW!U7)","v":""},null,{"$f":"IF(ISBLANK(InfoW!V7),\"\",InfoW!V7)","v":""},null,{"$f":"IF(ISBLANK(InfoW!W7),\"\",InfoW!W7)","v":""},null,{"$f":"IF(ISBLANK(InfoW!X7),\"\",InfoW!X7)","v":""},null,{"$f":"IF(ISBLANK(InfoW!Y7),\"\",InfoW!Y7)","v":""},null,{"$f":"IF(ISBLANK(InfoW!Z7),\"\",InfoW!Z7)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AA7),\"\",InfoW!AA7)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AB7),\"\",InfoW!AB7)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AC7),\"\",InfoW!AC7)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AD7),\"\",InfoW!AD7)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AE7),\"\",InfoW!AE7)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AF7),\"\",InfoW!AF7)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AG7),\"\",InfoW!AG7)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AH7),\"\",InfoW!AH7)","v":""}]
[]
[null,null,null,null,{"$f":"IF(ISBLANK(InfoW!O9),\"\",InfoW!O9)","v":""},null,{"$f":"IF(ISBLANK(InfoW!P9),\"\",InfoW!P9)","v":""},null,{"$f":"IF(ISBLANK(InfoW!Q9),\"\",InfoW!Q9)","v":""},null,{"$f":"IF(ISBLANK(InfoW!R9),\"\",InfoW!R9)","v":""},null,{"$f":"IF(ISBLANK(InfoW!S9),\"\",InfoW!S9)","v":""},null,{"$f":"IF(ISBLANK(InfoW!T9),\"\",InfoW!T9)","v":""},null,{"$f":"IF(ISBLANK(InfoW!U9),\"\",InfoW!U9)","v":""},null,{"$f":"IF(ISBLANK(InfoW!V9),\"\",InfoW!V9)","v":""},null,{"$f":"IF(ISBLANK(InfoW!W9),\"\",InfoW!W9)","v":""},null,{"$f":"IF(ISBLANK(InfoW!X9),\"\",InfoW!X9)","v":""},null,{"$f":"IF(ISBLANK(InfoW!Y9),\"\",InfoW!Y9)","v":""},null,{"$f":"IF(ISBLANK(InfoW!Z9),\"\",InfoW!Z9)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AA9),\"\",InfoW!AA9)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AB9),\"\",InfoW!AB9)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AC9),\"\",InfoW!AC9)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AD9),\"\",InfoW!AD9)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AE9),\"\",InfoW!AE9)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AF9),\"\",InfoW!AF9)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AG9),\"\",InfoW!AG9)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AH9),\"\",InfoW!AH9)","v":""}]
[]
[null,null,null,null,{"$f":"IF(ISBLANK(InfoW!O11),\"\",InfoW!O11)","v":""},null,{"$f":"IF(ISBLANK(InfoW!P11),\"\",InfoW!P11)","v":""},null,{"$f":"IF(ISBLANK(InfoW!Q11),\"\",InfoW!Q11)","v":""},null,{"$f":"IF(ISBLANK(InfoW!R11),\"\",InfoW!R11)","v":""},null,{"$f":"IF(ISBLANK(InfoW!S11),\"\",InfoW!S11)","v":""},null,{"$f":"IF(ISBLANK(InfoW!T11),\"\",InfoW!T11)","v":""},null,{"$f":"IF(ISBLANK(InfoW!U11),\"\",InfoW!U11)","v":""},null,{"$f":"IF(ISBLANK(InfoW!V11),\"\",InfoW!V11)","v":""},null,{"$f":"IF(ISBLANK(InfoW!W11),\"\",InfoW!W11)","v":""},null,{"$f":"IF(ISBLANK(InfoW!X11),\"\",InfoW!X11)","v":""},null,{"$f":"IF(ISBLANK(InfoW!Y11),\"\",InfoW!Y11)","v":""},null,{"$f":"IF(ISBLANK(InfoW!Z11),\"\",InfoW!Z11)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AA11),\"\",InfoW!AA11)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AB11),\"\",InfoW!AB11)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AC11),\"\",InfoW!AC11)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AD11),\"\",InfoW!AD11)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AE11),\"\",InfoW!AE11)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AF11),\"\",InfoW!AF11)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AG11),\"\",InfoW!AG11)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AH11),\"\",InfoW!AH11)","v":""}]
[]
[null,null,null,null,{"$f":"IF(ISBLANK(InfoW!O13),\"\",InfoW!O13)","v":""},null,{"$f":"IF(ISBLANK(InfoW!P13),\"\",InfoW!P13)","v":""},null,{"$f":"IF(ISBLANK(InfoW!Q13),\"\",InfoW!Q13)","v":""},null,{"$f":"IF(ISBLANK(InfoW!R13),\"\",InfoW!R13)","v":""},null,{"$f":"IF(ISBLANK(InfoW!S13),\"\",InfoW!S13)","v":""},null,{"$f":"IF(ISBLANK(InfoW!T13),\"\",InfoW!T13)","v":""},null,{"$f":"IF(ISBLANK(InfoW!U13),\"\",InfoW!U13)","v":""},null,{"$f":"IF(ISBLANK(InfoW!V13),\"\",InfoW!V13)","v":""},null,{"$f":"IF(ISBLANK(InfoW!W13),\"\",InfoW!W13)","v":""},null,{"$f":"IF(ISBLANK(InfoW!X13),\"\",InfoW!X13)","v":""},null,{"$f":"IF(ISBLANK(InfoW!Y13),\"\",InfoW!Y13)","v":""},null,{"$f":"IF(ISBLANK(InfoW!Z13),\"\",InfoW!Z13)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AA13),\"\",InfoW!AA13)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AB13),\"\",InfoW!AB13)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AC13),\"\",InfoW!AC13)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AD13),\"\",InfoW!AD13)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AE13),\"\",InfoW!AE13)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AF13),\"\",InfoW!AF13)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AG13),\"\",InfoW!AG13)","v":""},null,{"$f":"IF(ISBLANK(InfoW!AH13),\"\",InfoW!AH13)","v":""}]
[]
[]
[null,null,null,null,{"$f":"IF(ISBLANK(InfoW!N16),\"\",InfoW!N16)","v":""},{"$f":"IF(ISBLANK(InfoW!O16),\"\",InfoW!O16)","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK(InfoW!N17),\"\",InfoW!N17)","v":""},{"$f":"IF(ISBLANK(InfoW!O17),\"\",InfoW!O17)","v":""}]
[]
[null,null,null,null,{"$f":"IF(ISBLANK(InfoW!N20),\"\",InfoW!N20)","v":""}]

{"sheet":"InfoW","index":4,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["sortierte Liste ohne Duplikate, kombiniert aus MB, M2, ZU - erstellt beim Import",{"$f":"'MB temp'!H1+5","v":5},{"$f":"'M2 temp'!H1+5","v":5},null,{"$f":"'M3 temp'!H1+5","v":5},null,{"$f":"'ZU temp'!H1+5","v":5},null,null,null,null,"M2 RE/RA trennen oder zusammenfassen?","Kliniknr. aus MB"]
[0,"Anzahl MB","Anzahl M2/RE","Anzahl M2/RA","Anzahl M3/RE","Anzahl M3/RA","Anzahl ZU","MB","M2 (andere Kategoriebildung als in M2)","M3 (andere Kategoriebildung als in M2)","ZU","Dropout M2 oder M3",null,"Test begonnen?"]
[null,{"$f":"COUNTIF(INDIRECT(\"'MB temp'!BG$6:BG$\"&$B$1),A3)","v":0},{"$f":"COUNTIF(INDIRECT(\"'M2 temp'!A$6:A$\"&$C$1),A3&\"1\")","v":0},{"$f":"COUNTIF(INDIRECT(\"'M2 temp'!A$6:A$\"&$C$1),A3&\"2\")","v":0},{"$f":"COUNTIF(INDIRECT(\"'M3 temp'!A$5:A$\"&$E$1),A3&\"1\")","v":0},{"$f":"COUNTIF(INDIRECT(\"'M3 temp'!A$5:A$\"&$E$1),A3&\"2\")","v":0},{"$f":"COUNTIF(INDIRECT(\"'ZU temp'!H$6:H$\"&$G$1),A3)","v":0},{"$f":"IF(B3=1,\"MB\",IF(B3=0,\"\",\"DUP\"))","v":""},{"$f":"IF(AND(C3=1,D3=1),\"M2\",IF(OR(C3>1,D3>1),\"DUP\",IF(C3+D3=0,\"\",IF(C3=1,\"E\",\"A\"))))","v":""},{"$f":"IF(AND(E3=1,F3=1),\"M3\",IF(OR(E3>1,F3>1),\"DUP\",IF(E3+F3=0,\"\",IF(E3=1,\"E\",\"A\"))))","v":""},{"$f":"IF(G3=1,\"ZU\",IF(G3=0,\"\",\"DUP\"))","v":""},{"$f":"IF(SUMIF(INDIRECT(\"'M2 temp'!$H$5:$H$\"&$C$1),A3,INDIRECT(\"'M2 temp'!$L$5:$L$\"&$C$1))+SUMIF(INDIRECT(\"'M3 temp'!$H$5:$H$\"&$E$1),A3,INDIRECT(\"'M3 temp'!$M$5:$M$\"&$E$1))>0,\"Drop-Out\",\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"bereits importiert"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"bereits importiert: "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"MB"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ZU"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"M2"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"M3"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Speicherort/Kliniknummer"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fortschritt"]

{"sheet":"InfoR","index":5,"n_rows":437,"n_cols":225,"rows_kept":437,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Länderkodes ISO 3166 ALPHA-3 "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XXA","Spezialkode für Staatenlose (\"NON\" wird einzeln abegefragt)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CH","Sonderfall CH zweistellig wird toleriert"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YUG","Yugoslavia (Federal Republic of)"]
[null,null,"1_ Datum",null,"ZE_01 Zielanpassung des zu Reha-Beginn festgelegten Hauptziels","ZE_02_1 Zielerreichung ursprüngliches Ziel","ZE_02_2 statt dessen erreichtes Ziel ","ZE_02_3 Unterstützungsbedarf des statt dessen erreichten Ziels ","ZE_03_1 Angepasstes Ziel","ZE_03_2 Unterstützungsbedarf angepasstes Ziel","ZE_04_1 Zielerreichung angepasstes Ziel","ZE_04_2  statt dessen erreichtes Ziel","ZE_04_3 Unterstützungsbedarf des statt dessen erreichten Ziels",null,"XKX","Kosovo"]
[null,null,"ZE gültige Kombinationen",null,null,null,null,null,null,null,null,null,null,null,"SCG","Serbia and Montenegro"]
[null,197,{"$f":"\"1_||\"&E7&\"|\"&F7&\"|\"&G7&\"|\"&H7&\"|\"&I7&\"|\"&J7&\"|\"&K7&\"|\"&L7&\"|\"&M7","v":"1_||||||||||"},null,null,null,null,null,null,null,null,null,null,null,"SRB","Serbia"]
[null,1,"1_||0|1|||||||",true,0,1,null,null,null,null,null,null,null,null,"SER","Serbien und Montenegro"]
[null,2,"1_||0|2|1||||||",true,0,2,1,null,null,null,null,null,null,null,"MNE","Montenegro"]
[null,13,"1_||0|2|10|0|||||",true,0,2,10,0,null,null,null,null,null,null,"MKD","Macedonia, the former Yugoslav Republic of"]
[null,14,"1_||0|2|10|1|||||",true,0,2,10,1,null,null,null,null,null,null,"FYR","Macedonia, The Former Yugoslav Republic of"]
[null,3,"1_||0|2|2||||||",true,0,2,2,null,null,null,null,null,null,null,"TMP","Timor-Leste"]
[null,4,"1_||0|2|3|0|||||",true,0,2,3,0,null,null,null,null,null,null,"TZN","Tanzania"]
[null,5,"1_||0|2|3|1|||||",true,0,2,3,1,null,null,null,null,null,null,"TZA","Tanzania, United Republic of"]
[null,6,"1_||0|2|4|0|||||",true,0,2,4,0,null,null,null,null,null,null,"ABW","Aruba"]
[null,7,"1_||0|2|4|1|||||",true,0,2,4,1,null,null,null,null,null,null,"ACI","Ashmore and Cartier Islands"]
[null,8,"1_||0|2|5||||||",true,0,2,5,null,null,null,null,null,null,null,"AFG","Afghanistan"]
[null,9,"1_||0|2|6||||||",true,0,2,6,null,null,null,null,null,null,null,"AGO","Angola"]
[null,10,"1_||0|2|7||||||",true,0,2,7,null,null,null,null,null,null,null,"AIA","Anguilla"]
[null,11,"1_||0|2|8||||||",true,0,2,8,null,null,null,null,null,null,null,"ALA","Åland Islands"]
[null,12,"1_||0|2|9||||||",true,0,2,9,null,null,null,null,null,null,null,"ALB","Albania"]
[null,15,"1_||1||||1||1||",true,1,null,null,null,1,null,1,null,null,null,"AND","Andorra"]
[null,28,"1_||1||||1||2|1|",true,1,null,null,null,1,null,2,1,null,null,"ARE","United Arab Emirates"]
[null,171,"1_||1||||1||2|10|0",true,1,null,null,null,1,null,2,10,0,null,"ARG","Argentina"]
[null,184,"1_||1||||1||2|10|1",true,1,null,null,null,1,null,2,10,1,null,"ARM","Armenia"]
[null,41,"1_||1||||1||2|2|",true,1,null,null,null,1,null,2,2,null,null,"ASM","American Samoa"]
[null,54,"1_||1||||1||2|3|0",true,1,null,null,null,1,null,2,3,0,null,"ATA","Antarctica"]
[null,67,"1_||1||||1||2|3|1",true,1,null,null,null,1,null,2,3,1,null,"ATF","French Southern Territories"]
[null,80,"1_||1||||1||2|4|0",true,1,null,null,null,1,null,2,4,0,null,"ATG","Antigua and Barbuda"]
[null,93,"1_||1||||1||2|4|1",true,1,null,null,null,1,null,2,4,1,null,"AUS","Australia"]
[null,106,"1_||1||||1||2|5|",true,1,null,null,null,1,null,2,5,null,null,"AUT","Austria"]
[null,119,"1_||1||||1||2|6|",true,1,null,null,null,1,null,2,6,null,null,"AZE","Azerbaijan"]
[null,132,"1_||1||||1||2|7|",true,1,null,null,null,1,null,2,7,null,null,"BDI","Burundi"]
[null,145,"1_||1||||1||2|8|",true,1,null,null,null,1,null,2,8,null,null,"BEL","Belgium"]
[null,158,"1_||1||||1||2|9|",true,1,null,null,null,1,null,2,9,null,null,"BEN","Benin"]
[null,26,"1_||1||||10|0|1||",true,1,null,null,null,10,0,1,null,null,null,"BES","Bonaire, Sint Eustatius and Saba"]
[null,39,"1_||1||||10|0|2|1|",true,1,null,null,null,10,0,2,1,null,null,"BFA","Burkina Faso"]
[null,182,"1_||1||||10|0|2|10|0",true,1,null,null,null,10,0,2,10,0,null,"BGD","Bangladesh"]
[null,195,"1_||1||||10|0|2|10|1",true,1,null,null,null,10,0,2,10,1,null,"BGR","Bulgaria"]
[null,52,"1_||1||||10|0|2|2|",true,1,null,null,null,10,0,2,2,null,null,"BHR","Bahrain"]
[null,65,"1_||1||||10|0|2|3|0",true,1,null,null,null,10,0,2,3,0,null,"BHS","Bahamas"]
[null,78,"1_||1||||10|0|2|3|1",true,1,null,null,null,10,0,2,3,1,null,"BIH","Bosnia and Herzegovina"]
[null,91,"1_||1||||10|0|2|4|0",true,1,null,null,null,10,0,2,4,0,null,"BLM","Saint Barthélemy"]
[null,104,"1_||1||||10|0|2|4|1",true,1,null,null,null,10,0,2,4,1,null,"BLR","Belarus"]
[null,117,"1_||1||||10|0|2|5|",true,1,null,null,null,10,0,2,5,null,null,"BLZ","Belize"]
[null,130,"1_||1||||10|0|2|6|",true,1,null,null,null,10,0,2,6,null,null,"BMU","Bermuda"]
[null,143,"1_||1||||10|0|2|7|",true,1,null,null,null,10,0,2,7,null,null,"BOL","Bolivia, Plurinational State of"]
[null,156,"1_||1||||10|0|2|8|",true,1,null,null,null,10,0,2,8,null,null,"BRA","Brazil"]
[null,169,"1_||1||||10|0|2|9|",true,1,null,null,null,10,0,2,9,null,null,"BRB","Barbados"]
[null,27,"1_||1||||10|1|1||",true,1,null,null,null,10,1,1,null,null,null,"BRN","Brunei Darussalam"]
[null,40,"1_||1||||10|1|2|1|",true,1,null,null,null,10,1,2,1,null,null,"BTN","Bhutan"]
[null,183,"1_||1||||10|1|2|10|0",true,1,null,null,null,10,1,2,10,0,null,"BVT","Bouvet Island"]
[null,196,"1_||1||||10|1|2|10|1",true,1,null,null,null,10,1,2,10,1,null,"BWA","Botswana"]
[null,53,"1_||1||||10|1|2|2|",true,1,null,null,null,10,1,2,2,null,null,"CAF","Central African Republic"]
[null,66,"1_||1||||10|1|2|3|0",true,1,null,null,null,10,1,2,3,0,null,"CAN","Canada"]
[null,79,"1_||1||||10|1|2|3|1",true,1,null,null,null,10,1,2,3,1,null,"CCK","Cocos (Keeling) Islands"]
[null,92,"1_||1||||10|1|2|4|0",true,1,null,null,null,10,1,2,4,0,null,"CHE","Switzerland"]
[null,105,"1_||1||||10|1|2|4|1",true,1,null,null,null,10,1,2,4,1,null,"CHL","Chile"]
[null,118,"1_||1||||10|1|2|5|",true,1,null,null,null,10,1,2,5,null,null,"CHN","China"]
[null,131,"1_||1||||10|1|2|6|",true,1,null,null,null,10,1,2,6,null,null,"CIV","Côte d'Ivoire"]
[null,144,"1_||1||||10|1|2|7|",true,1,null,null,null,10,1,2,7,null,null,"CMR","Cameroon"]
[null,157,"1_||1||||10|1|2|8|",true,1,null,null,null,10,1,2,8,null,null,"COD","Congo, the Democratic Republic of the"]
[null,170,"1_||1||||10|1|2|9|",true,1,null,null,null,10,1,2,9,null,null,"COG","Congo"]
[null,16,"1_||1||||2||1||",true,1,null,null,null,2,null,1,null,null,null,"COK","Cook Islands"]
[null,29,"1_||1||||2||2|1|",true,1,null,null,null,2,null,2,1,null,null,"COL","Colombia"]
[null,172,"1_||1||||2||2|10|0",true,1,null,null,null,2,null,2,10,0,null,"COM","Comoros"]
[null,185,"1_||1||||2||2|10|1",true,1,null,null,null,2,null,2,10,1,null,"CPV","Cabo Verde"]
[null,42,"1_||1||||2||2|2|",true,1,null,null,null,2,null,2,2,null,null,"CRI","Costa Rica"]
[null,55,"1_||1||||2||2|3|0",true,1,null,null,null,2,null,2,3,0,null,"CSI","Coral Sea Islands"]
[null,68,"1_||1||||2||2|3|1",true,1,null,null,null,2,null,2,3,1,null,"CUB","Cuba"]
[null,81,"1_||1||||2||2|4|0",true,1,null,null,null,2,null,2,4,0,null,"CUW","Curaçao"]
[null,94,"1_||1||||2||2|4|1",true,1,null,null,null,2,null,2,4,1,null,"CXR","Christmas Island"]
[null,107,"1_||1||||2||2|5|",true,1,null,null,null,2,null,2,5,null,null,"CYM","Cayman Islands"]
[null,120,"1_||1||||2||2|6|",true,1,null,null,null,2,null,2,6,null,null,"CYP","Cyprus"]
[null,133,"1_||1||||2||2|7|",true,1,null,null,null,2,null,2,7,null,null,"CZE","Czechia"]
[null,146,"1_||1||||2||2|8|",true,1,null,null,null,2,null,2,8,null,null,"DEU","Germany"]
[null,159,"1_||1||||2||2|9|",true,1,null,null,null,2,null,2,9,null,null,"DJI","Djibouti"]
[null,17,"1_||1||||3|0|1||",true,1,null,null,null,3,0,1,null,null,null,"DMA","Dominica"]
[null,30,"1_||1||||3|0|2|1|",true,1,null,null,null,3,0,2,1,null,null,"DNK","Denmark"]
[null,173,"1_||1||||3|0|2|10|0",true,1,null,null,null,3,0,2,10,0,null,"DOM","Dominican Republic"]
[null,186,"1_||1||||3|0|2|10|1",true,1,null,null,null,3,0,2,10,1,null,"DZA","Algeria"]
[null,43,"1_||1||||3|0|2|2|",true,1,null,null,null,3,0,2,2,null,null,"ECU","Ecuador"]
[null,56,"1_||1||||3|0|2|3|0",true,1,null,null,null,3,0,2,3,0,null,"EGY","Egypt"]
[null,69,"1_||1||||3|0|2|3|1",true,1,null,null,null,3,0,2,3,1,null,"ERI","Eritrea"]
[null,82,"1_||1||||3|0|2|4|0",true,1,null,null,null,3,0,2,4,0,null,"ESH","Western Sahara"]
[null,95,"1_||1||||3|0|2|4|1",true,1,null,null,null,3,0,2,4,1,null,"ESP","Spain"]
[null,108,"1_||1||||3|0|2|5|",true,1,null,null,null,3,0,2,5,null,null,"EST","Estonia"]
[null,121,"1_||1||||3|0|2|6|",true,1,null,null,null,3,0,2,6,null,null,"ETH","Ethiopia"]
[null,134,"1_||1||||3|0|2|7|",true,1,null,null,null,3,0,2,7,null,null,"FIN","Finland"]
[null,147,"1_||1||||3|0|2|8|",true,1,null,null,null,3,0,2,8,null,null,"FJI","Fiji"]
[null,160,"1_||1||||3|0|2|9|",true,1,null,null,null,3,0,2,9,null,null,"FLK","Falkland Islands (Malvinas)"]
[null,18,"1_||1||||3|1|1||",true,1,null,null,null,3,1,1,null,null,null,"FRA","France"]
[null,31,"1_||1||||3|1|2|1|",true,1,null,null,null,3,1,2,1,null,null,"FRO","Faroe Islands"]
[null,174,"1_||1||||3|1|2|10|0",true,1,null,null,null,3,1,2,10,0,null,"FSM","Micronesia, Federated States of"]
[null,187,"1_||1||||3|1|2|10|1",true,1,null,null,null,3,1,2,10,1,null,"GAB","Gabon"]
[null,44,"1_||1||||3|1|2|2|",true,1,null,null,null,3,1,2,2,null,null,"GBR","United Kingdom"]
[null,57,"1_||1||||3|1|2|3|0",true,1,null,null,null,3,1,2,3,0,null,"GEO","Georgia"]
[null,70,"1_||1||||3|1|2|3|1",true,1,null,null,null,3,1,2,3,1,null,"GGY","Guernsey"]
[null,83,"1_||1||||3|1|2|4|0",true,1,null,null,null,3,1,2,4,0,null,"GHA","Ghana"]
[null,96,"1_||1||||3|1|2|4|1",true,1,null,null,null,3,1,2,4,1,null,"GIB","Gibraltar"]
[null,109,"1_||1||||3|1|2|5|",true,1,null,null,null,3,1,2,5,null,null,"GIN","Guinea"]
[null,122,"1_||1||||3|1|2|6|",true,1,null,null,null,3,1,2,6,null,null,"GLP","Guadeloupe"]
[null,135,"1_||1||||3|1|2|7|",true,1,null,null,null,3,1,2,7,null,null,"GMB","Gambia"]
[null,148,"1_||1||||3|1|2|8|",true,1,null,null,null,3,1,2,8,null,null,"GNB","Guinea-Bissau"]
[null,161,"1_||1||||3|1|2|9|",true,1,null,null,null,3,1,2,9,null,null,"GNQ","Equatorial Guinea"]
[null,19,"1_||1||||4|0|1||",true,1,null,null,null,4,0,1,null,null,null,"GRC","Greece"]
[null,32,"1_||1||||4|0|2|1|",true,1,null,null,null,4,0,2,1,null,null,"GRD","Grenada"]
[null,175,"1_||1||||4|0|2|10|0",true,1,null,null,null,4,0,2,10,0,null,"GRL","Greenland"]
[null,188,"1_||1||||4|0|2|10|1",true,1,null,null,null,4,0,2,10,1,null,"GTM","Guatemala"]
[null,45,"1_||1||||4|0|2|2|",true,1,null,null,null,4,0,2,2,null,null,"GUF","French Guiana"]
[null,58,"1_||1||||4|0|2|3|0",true,1,null,null,null,4,0,2,3,0,null,"GUM","Guam"]
[null,71,"1_||1||||4|0|2|3|1",true,1,null,null,null,4,0,2,3,1,null,"GUY","Guyana"]
[null,84,"1_||1||||4|0|2|4|0",true,1,null,null,null,4,0,2,4,0,null,"HKG","Hong Kong"]
[null,97,"1_||1||||4|0|2|4|1",true,1,null,null,null,4,0,2,4,1,null,"HMD","Heard Island and McDonald Islands"]
[null,110,"1_||1||||4|0|2|5|",true,1,null,null,null,4,0,2,5,null,null,"HND","Honduras"]
[null,123,"1_||1||||4|0|2|6|",true,1,null,null,null,4,0,2,6,null,null,"HQI","Howland Island"]
[null,136,"1_||1||||4|0|2|7|",true,1,null,null,null,4,0,2,7,null,null,"HRV","Croatia"]
[null,149,"1_||1||||4|0|2|8|",true,1,null,null,null,4,0,2,8,null,null,"HTI","Haiti"]
[null,162,"1_||1||||4|0|2|9|",true,1,null,null,null,4,0,2,9,null,null,"HUN","Hungary"]
[null,20,"1_||1||||4|1|1||",true,1,null,null,null,4,1,1,null,null,null,"IDN","Indonesia"]
[null,33,"1_||1||||4|1|2|1|",true,1,null,null,null,4,1,2,1,null,null,"IMN","Isle of Man"]
[null,176,"1_||1||||4|1|2|10|0",true,1,null,null,null,4,1,2,10,0,null,"IND","India"]
[null,189,"1_||1||||4|1|2|10|1",true,1,null,null,null,4,1,2,10,1,null,"IOT","British Indian Ocean Territory"]
[null,46,"1_||1||||4|1|2|2|",true,1,null,null,null,4,1,2,2,null,null,"IRL","Ireland"]
[null,59,"1_||1||||4|1|2|3|0",true,1,null,null,null,4,1,2,3,0,null,"IRN","Iran, Islamic Republic of"]
[null,72,"1_||1||||4|1|2|3|1",true,1,null,null,null,4,1,2,3,1,null,"IRQ","Iraq"]
[null,85,"1_||1||||4|1|2|4|0",true,1,null,null,null,4,1,2,4,0,null,"ISL","Iceland"]
[null,98,"1_||1||||4|1|2|4|1",true,1,null,null,null,4,1,2,4,1,null,"ISR","Israel"]
[null,111,"1_||1||||4|1|2|5|",true,1,null,null,null,4,1,2,5,null,null,"ITA","Italy"]
[null,124,"1_||1||||4|1|2|6|",true,1,null,null,null,4,1,2,6,null,null,"JAM","Jamaica"]
[null,137,"1_||1||||4|1|2|7|",true,1,null,null,null,4,1,2,7,null,null,"JEY","Jersey"]
[null,150,"1_||1||||4|1|2|8|",true,1,null,null,null,4,1,2,8,null,null,"JNM","Jan Mayen Island"]
[null,163,"1_||1||||4|1|2|9|",true,1,null,null,null,4,1,2,9,null,null,"JOR","Jordan"]
[null,21,"1_||1||||5||1||",true,1,null,null,null,5,null,1,null,null,null,"JPN","Japan"]
[null,34,"1_||1||||5||2|1|",true,1,null,null,null,5,null,2,1,null,null,"JQA","Johnston Atoll"]
[null,177,"1_||1||||5||2|10|0",true,1,null,null,null,5,null,2,10,0,null,"KAZ","Kazakhstan"]
[null,190,"1_||1||||5||2|10|1",true,1,null,null,null,5,null,2,10,1,null,"KEN","Kenya"]
[null,47,"1_||1||||5||2|2|",true,1,null,null,null,5,null,2,2,null,null,"KGZ","Kyrgyzstan"]
[null,60,"1_||1||||5||2|3|0",true,1,null,null,null,5,null,2,3,0,null,"KHM","Cambodia"]
[null,73,"1_||1||||5||2|3|1",true,1,null,null,null,5,null,2,3,1,null,"KIR","Kiribati"]
[null,86,"1_||1||||5||2|4|0",true,1,null,null,null,5,null,2,4,0,null,"KNA","Saint Kitts and Nevis"]
[null,99,"1_||1||||5||2|4|1",true,1,null,null,null,5,null,2,4,1,null,"KOR","Korea, Republic of"]
[null,112,"1_||1||||5||2|5|",true,1,null,null,null,5,null,2,5,null,null,"KWT","Kuwait"]
[null,125,"1_||1||||5||2|6|",true,1,null,null,null,5,null,2,6,null,null,"LAO","Lao People's Democratic Republic"]
[null,138,"1_||1||||5||2|7|",true,1,null,null,null,5,null,2,7,null,null,"LBN","Lebanon"]
[null,151,"1_||1||||5||2|8|",true,1,null,null,null,5,null,2,8,null,null,"LBR","Liberia"]
[null,164,"1_||1||||5||2|9|",true,1,null,null,null,5,null,2,9,null,null,"LBY","Libya"]
[null,22,"1_||1||||6||1||",true,1,null,null,null,6,null,1,null,null,null,"LCA","Saint Lucia"]
[null,35,"1_||1||||6||2|1|",true,1,null,null,null,6,null,2,1,null,null,"LIE","Liechtenstein"]
[null,178,"1_||1||||6||2|10|0",true,1,null,null,null,6,null,2,10,0,null,"LKA","Sri Lanka"]
[null,191,"1_||1||||6||2|10|1",true,1,null,null,null,6,null,2,10,1,null,"LSO","Lesotho"]
[null,48,"1_||1||||6||2|2|",true,1,null,null,null,6,null,2,2,null,null,"LTU","Lithuania"]
[null,61,"1_||1||||6||2|3|0",true,1,null,null,null,6,null,2,3,0,null,"LUX","Luxembourg"]
[null,74,"1_||1||||6||2|3|1",true,1,null,null,null,6,null,2,3,1,null,"LVA","Latvia"]
[null,87,"1_||1||||6||2|4|0",true,1,null,null,null,6,null,2,4,0,null,"MAC","Macao"]
[null,100,"1_||1||||6||2|4|1",true,1,null,null,null,6,null,2,4,1,null,"MAF","Saint Martin (French part)"]
[null,113,"1_||1||||6||2|5|",true,1,null,null,null,6,null,2,5,null,null,"MAR","Morocco"]
[null,126,"1_||1||||6||2|6|",true,1,null,null,null,6,null,2,6,null,null,"MCO","Monaco"]
[null,139,"1_||1||||6||2|7|",true,1,null,null,null,6,null,2,7,null,null,"MDA","Moldova, Republic of"]
[null,152,"1_||1||||6||2|8|",true,1,null,null,null,6,null,2,8,null,null,"MDG","Madagascar"]
[null,165,"1_||1||||6||2|9|",true,1,null,null,null,6,null,2,9,null,null,"MDV","Maldives"]
[null,23,"1_||1||||7||1||",true,1,null,null,null,7,null,1,null,null,null,"MEX","Mexico"]
[null,36,"1_||1||||7||2|1|",true,1,null,null,null,7,null,2,1,null,null,"MHL","Marshall Islands"]
[null,179,"1_||1||||7||2|10|0",true,1,null,null,null,7,null,2,10,0,null,"MLI","Mali"]
[null,192,"1_||1||||7||2|10|1",true,1,null,null,null,7,null,2,10,1,null,"MLT","Malta"]
[null,49,"1_||1||||7||2|2|",true,1,null,null,null,7,null,2,2,null,null,"MMR","Myanmar"]
[null,62,"1_||1||||7||2|3|0",true,1,null,null,null,7,null,2,3,0,null,"MNG","Mongolia"]
[null,75,"1_||1||||7||2|3|1",true,1,null,null,null,7,null,2,3,1,null,"MNP","Northern Mariana Islands"]
[null,88,"1_||1||||7||2|4|0",true,1,null,null,null,7,null,2,4,0,null,"MOZ","Mozambique"]
[null,101,"1_||1||||7||2|4|1",true,1,null,null,null,7,null,2,4,1,null,"MRT","Mauritania"]
[null,114,"1_||1||||7||2|5|",true,1,null,null,null,7,null,2,5,null,null,"MSR","Montserrat"]
[null,127,"1_||1||||7||2|6|",true,1,null,null,null,7,null,2,6,null,null,"MTQ","Martinique"]
[null,140,"1_||1||||7||2|7|",true,1,null,null,null,7,null,2,7,null,null,"MUS","Mauritius"]
[null,153,"1_||1||||7||2|8|",true,1,null,null,null,7,null,2,8,null,null,"MWI","Malawi"]
[null,166,"1_||1||||7||2|9|",true,1,null,null,null,7,null,2,9,null,null,"MYS","Malaysia"]
[null,24,"1_||1||||8||1||",true,1,null,null,null,8,null,1,null,null,null,"MYT","Mayotte"]
[null,37,"1_||1||||8||2|1|",true,1,null,null,null,8,null,2,1,null,null,"NAM","Namibia"]
[null,180,"1_||1||||8||2|10|0",true,1,null,null,null,8,null,2,10,0,null,"NCL","New Caledonia"]
[null,193,"1_||1||||8||2|10|1",true,1,null,null,null,8,null,2,10,1,null,"NER","Niger"]
[null,50,"1_||1||||8||2|2|",true,1,null,null,null,8,null,2,2,null,null,"NFK","Norfolk Island"]
[null,63,"1_||1||||8||2|3|0",true,1,null,null,null,8,null,2,3,0,null,"NGA","Nigeria"]
[null,76,"1_||1||||8||2|3|1",true,1,null,null,null,8,null,2,3,1,null,"NIC","Nicaragua"]
[null,89,"1_||1||||8||2|4|0",true,1,null,null,null,8,null,2,4,0,null,"NIU","Niue"]
[null,102,"1_||1||||8||2|4|1",true,1,null,null,null,8,null,2,4,1,null,"NLD","Netherlands"]
[null,115,"1_||1||||8||2|5|",true,1,null,null,null,8,null,2,5,null,null,"NOR","Norway"]
[null,128,"1_||1||||8||2|6|",true,1,null,null,null,8,null,2,6,null,null,"NPL","Nepal"]
[null,141,"1_||1||||8||2|7|",true,1,null,null,null,8,null,2,7,null,null,"NRU","Nauru"]
[null,154,"1_||1||||8||2|8|",true,1,null,null,null,8,null,2,8,null,null,"NZL","New Zealand"]
[null,167,"1_||1||||8||2|9|",true,1,null,null,null,8,null,2,9,null,null,"OMN","Oman"]
[null,25,"1_||1||||9||1||",true,1,null,null,null,9,null,1,null,null,null,"PAK","Pakistan"]
[null,38,"1_||1||||9||2|1|",true,1,null,null,null,9,null,2,1,null,null,"PAN","Panama"]
[null,181,"1_||1||||9||2|10|0",true,1,null,null,null,9,null,2,10,0,null,"PCN","Pitcairn"]
[null,194,"1_||1||||9||2|10|1",true,1,null,null,null,9,null,2,10,1,null,"PER","Peru"]
[null,51,"1_||1||||9||2|2|",true,1,null,null,null,9,null,2,2,null,null,"PFI","Paracel Islands"]
[null,64,"1_||1||||9||2|3|0",true,1,null,null,null,9,null,2,3,0,null,"PHL","Philippines"]
[null,77,"1_||1||||9||2|3|1",true,1,null,null,null,9,null,2,3,1,null,"PLW","Palau"]
[null,90,"1_||1||||9||2|4|0",true,1,null,null,null,9,null,2,4,0,null,"PNG","Papua New Guinea"]
[null,103,"1_||1||||9||2|4|1",true,1,null,null,null,9,null,2,4,1,null,"POL","Poland"]
[null,116,"1_||1||||9||2|5|",true,1,null,null,null,9,null,2,5,null,null,"PRI","Puerto Rico"]
[null,129,"1_||1||||9||2|6|",true,1,null,null,null,9,null,2,6,null,null,"PRK","Korea, Democratic People's Republic of"]
[null,142,"1_||1||||9||2|7|",true,1,null,null,null,9,null,2,7,null,null,"PRT","Portugal"]
[null,155,"1_||1||||9||2|8|",true,1,null,null,null,9,null,2,8,null,null,"PRY","Paraguay"]
[null,168,"1_||1||||9||2|9|",true,1,null,null,null,9,null,2,9,null,null,"PSE","Palestine, State of"]
[null,201,"1_1||||||||||",true,null,null,null,null,null,null,null,null,null,null,"PYF","French Polynesia"]
[null,202,"1_2||||||||||",true,null,null,null,null,null,null,null,null,null,null,"QAT","Qatar"]
[null,203,"1_3|0|||||||||",true,null,null,null,null,null,null,null,null,null,null,"REU","Réunion"]
[null,204,"1_3|1|||||||||",true,null,null,null,null,null,null,null,null,null,null,"ROU","Romania"]
[null,205,"1_4|0|||||||||",true,null,null,null,null,null,null,null,null,null,null,"RUS","Russian Federation"]
[null,206,"1_4|1|||||||||",true,null,null,null,null,null,null,null,null,null,null,"RWA","Rwanda"]
[null,207,"1_5||||||||||",true,null,null,null,null,null,null,null,null,null,null,"SAU","Saudi Arabia"]
[null,208,"1_6||||||||||",true,null,null,null,null,null,null,null,null,null,null,"SDN","Sudan"]
[null,209,"1_7||||||||||",true,null,null,null,null,null,null,null,null,null,null,"SEN","Senegal"]
[null,210,"1_8||||||||||",true,null,null,null,null,null,null,null,null,null,null,"SGP","Singapore"]
[null,211,"1_9||||||||||",true,null,null,null,null,null,null,null,null,null,null,"SGS","South Georgia and the South Sandwich Islands"]
[null,212,"1_10|0|||||||||",true,null,null,null,null,null,null,null,null,null,null,"SHN","Saint Helena, Ascension and Tristan da Cunha"]
[null,213,"1_10|1|||||||||",true,null,null,null,null,null,null,null,null,null,null,"SJM","Svalbard and Jan Mayen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SLB","Solomon Islands"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SLE","Sierra Leone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SLV","El Salvador"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SMR","San Marino"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SOM","Somalia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPM","Saint Pierre and Miquelon"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SSD","South Sudan"]
[null,null,"|||","",null,null,null,null,null,null,null,null,"COPD",null,"STP","Sao Tome and Principe"]
[null,null,"|||1","MSK","Geri",null,null,null,null,null,null,"1|","ja",null,"SUR","Suriname"]
[null,null,"||1|","MSK","Geri",null,null,null,null,null,null,"|1","ja",null,"SVK","Slovakia"]
[null,null,"||1|1","MSK","Geri",null,null,null,null,null,null,"1|1","ja",null,"SVN","Slovenia"]
[null,null,"|1||","MSK","Geri",null,null,null,null,null,null,"2|","ja",null,"SWE","Sweden"]
[null,null,"|1||1","MSK","Geri",null,null,null,null,null,null,"|2","nein",null,"SWZ","Eswatini"]
[null,null,"|1|1|","MSK","Geri",null,null,null,null,null,null,"2|2","nein",null,"SXM","Sint Maarten (Dutch part)"]
[null,null,"|1|1|1","MSK","Geri",null,null,null,null,null,null,"|","",null,"SYC","Seychelles"]
[null,null,"1|||","MSK","Geri",null,null,null,null,null,null,null,null,null,"SYR","Syrian Arab Republic"]
[null,null,"1|||1","MSK","Geri",null,null,null,null,null,null,null,null,null,"TCA","Turks and Caicos Islands"]
[null,null,"1||1|","MSK","Geri",null,null,null,null,null,null,null,null,null,"TCD","Chad"]
[null,null,"1||1|1","MSK","Geri",null,null,null,null,null,null,null,null,null,"TGO","Togo"]
[null,null,"1|1||","MSK","Geri",null,null,null,null,null,null,null,null,null,"THA","Thailand"]
[null,null,"1|1||1","MSK","Geri",null,null,null,null,null,null,null,null,null,"TJK","Tajikistan"]
[null,null,"1|1|1|","MSK","Geri",null,null,null,null,null,null,null,null,null,"TKL","Tokelau"]
[null,null,"1|1|1|1","MSK","Geri",null,null,null,null,null,null,null,null,null,"TKM","Turkmenistan"]
[null,null,"|||2","Neuro","Innere",null,null,null,null,null,null,null,null,null,"TLS","Timor-Leste"]
[null,null,"||2|","Neuro","Innere",null,null,null,null,null,null,null,null,null,"TON","Tonga"]
[null,null,"||2|2","Neuro","Innere",null,null,null,null,null,null,null,null,null,"TTO","Trinidad and Tobago"]
[null,null,"|2||","Neuro","Innere",null,null,null,null,null,null,null,null,null,"TUN","Tunisia"]
[null,null,"|2||2","Neuro","Innere",null,null,null,null,null,null,null,null,null,"TUR","Turkey"]
[null,null,"|2|2|","Neuro","Innere",null,null,null,null,null,null,null,null,null,"TUV","Tuvalu"]
[null,null,"|2|2|2","Neuro","Innere",null,null,null,null,null,null,null,null,null,"TWN","Taiwan, Province of China"]
[null,null,"2|||","Neuro","Innere",null,null,null,null,null,null,null,null,null,"UGA","Uganda"]
[null,null,"2|||2","Neuro","Innere",null,null,null,null,null,null,null,null,null,"UKR","Ukraine"]
[null,null,"2||2|","Neuro","Innere",null,null,null,null,null,null,null,null,null,"UMI","United States Minor Outlying Islands"]
[null,null,"2||2|2","Neuro","Innere",null,null,null,null,null,null,null,null,null,"URY","Uruguay"]
[null,null,"2|2||","Neuro","Innere",null,null,null,null,null,null,null,null,null,"USA","United States of America"]
[null,null,"2|2||2","Neuro","Innere",null,null,null,null,null,null,null,null,null,"UZB","Uzbekistan"]
[null,null,"2|2|2|","Neuro","Innere",null,null,null,null,null,null,null,null,null,"VAT","Holy See"]
[null,null,"2|2|2|2","Neuro","Innere",null,null,null,null,null,null,null,null,null,"VCT","Saint Vincent and the Grenadines"]
[null,null,"|||3","Kardio","Kardio",null,null,null,null,null,null,null,null,null,"VEN","Venezuela, Bolivarian Republic of"]
[null,null,"||3|","Kardio","Kardio",null,null,null,null,null,null,null,null,null,"VGB","Virgin Islands, British"]
[null,null,"||3|3","Kardio","Kardio",null,null,null,null,null,null,null,null,null,"VIR","Virgin Islands, U.S."]
[null,null,"|3||","Kardio","Kardio",null,null,null,null,null,null,null,null,null,"VNM","Viet Nam"]
[null,null,"|3||3","Kardio","Kardio",null,null,null,null,null,null,null,null,null,"VUT","Vanuatu"]
[null,null,"|3|3|","Kardio","Kardio",null,null,null,null,null,null,null,null,null,"WLF","Wallis and Futuna"]
[null,null,"|3|3|3","Kardio","Kardio",null,null,null,null,null,null,null,null,null,"WSM","Samoa"]
[null,null,"3|||","Kardio","Kardio",null,null,null,null,null,null,null,null,null,"YEM","Yemen"]
[null,null,"3|||3","Kardio","Kardio",null,null,null,null,null,null,null,null,null,"ZAF","South Africa"]
[null,null,"3||3|","Kardio","Kardio",null,null,null,null,null,null,null,null,null,"ZMB","Zambia"]
[null,null,"3||3|3","Kardio","Kardio",null,null,null,null,null,null,null,null,null,"ZWE","Zimbabwe"]
[null,null,"3|3||","Kardio","Kardio"]
[null,null,"3|3||3","Kardio","Kardio"]
[null,null,"3|3|3|","Kardio","Kardio"]
[null,null,"3|3|3|3","Kardio","Kardio"]
[null,null,"|||4","Pulmo","MSK"]
[null,null,"||4|","Pulmo","MSK"]
[null,null,"||4|4","Pulmo","MSK"]
[null,null,"|4||","Pulmo","MSK"]
[null,null,"|4||4","Pulmo","MSK"]
[null,null,"|4|4|","Pulmo","MSK"]
[null,null,"|4|4|4","Pulmo","MSK"]
[null,null,"4|||","Pulmo","MSK"]
[null,null,"4|||4","Pulmo","MSK"]
[null,null,"4||4|","Pulmo","MSK"]
[null,null,"4||4|4","Pulmo","MSK"]
[null,null,"4|4||","Pulmo","MSK"]
[null,null,"4|4||4","Pulmo","MSK"]
[null,null,"4|4|4|","Pulmo","MSK"]
[null,null,"4|4|4|4","Pulmo","MSK"]
[null,null,"|||5","Andere","Neuro"]
[null,null,"||5|","Andere","Neuro"]
[null,null,"||5|5","Andere","Neuro"]
[null,null,"|5||","Andere","Neuro"]
[null,null,"|5||5","Andere","Neuro"]
[null,null,"|5|5|","Andere","Neuro"]
[null,null,"|5|5|5","Andere","Neuro"]
[null,null,"5|||","Andere","Neuro"]
[null,null,"5|||5","Andere","Neuro"]
[null,null,"5||5|","Andere","Neuro"]
[null,null,"5||5|5","Andere","Neuro"]
[null,null,"5|5||","Andere","Neuro"]
[null,null,"5|5||5","Andere","Neuro"]
[null,null,"5|5|5|","Andere","Neuro"]
[null,null,"5|5|5|5","Andere","Neuro"]
[null,null,"|||6",null,"Onko"]
[null,null,"||6|",null,"Onko"]
[null,null,"||6|6",null,"Onko"]
[null,null,"|6||",null,"Onko"]
[null,null,"|6||6",null,"Onko"]
[null,null,"|6|6|",null,"Onko"]
[null,null,"|6|6|6",null,"Onko"]
[null,null,"6|||",null,"Onko"]
[null,null,"6|||6",null,"Onko"]
[null,null,"6||6|",null,"Onko"]
[null,null,"6||6|6",null,"Onko"]
[null,null,"6|6||",null,"Onko"]
[null,null,"6|6||6",null,"Onko"]
[null,null,"6|6|6|",null,"Onko"]
[null,null,"6|6|6|6",null,"Onko"]
[null,null,"|||7",null,"Pädia"]
[null,null,"||7|",null,"Pädia"]
[null,null,"||7|7",null,"Pädia"]
[null,null,"|7||",null,"Pädia"]
[null,null,"|7||7",null,"Pädia"]
[null,null,"|7|7|",null,"Pädia"]
[null,null,"|7|7|7",null,"Pädia"]
[null,null,"7|||",null,"Pädia"]
[null,null,"7|||7",null,"Pädia"]
[null,null,"7||7|",null,"Pädia"]
[null,null,"7||7|7",null,"Pädia"]
[null,null,"7|7||",null,"Pädia"]
[null,null,"7|7||7",null,"Pädia"]
[null,null,"7|7|7|",null,"Pädia"]
[null,null,"7|7|7|7",null,"Pädia"]
[null,null,"|||8",null,"Para"]
[null,null,"||8|",null,"Para"]
[null,null,"||8|8",null,"Para"]
[null,null,"|8||",null,"Para"]
[null,null,"|8||8",null,"Para"]
[null,null,"|8|8|",null,"Para"]
[null,null,"|8|8|8",null,"Para"]
[null,null,"8|||",null,"Para"]
[null,null,"8|||8",null,"Para"]
[null,null,"8||8|",null,"Para"]
[null,null,"8||8|8",null,"Para"]
[null,null,"8|8||",null,"Para"]
[null,null,"8|8||8",null,"Para"]
[null,null,"8|8|8|",null,"Para"]
[null,null,"8|8|8|8",null,"Para"]
[null,null,"|||9",null,"Psychosoma"]
[null,null,"||9|",null,"Psychosoma"]
[null,null,"||9|9",null,"Psychosoma"]
[null,null,"|9||",null,"Psychosoma"]
[null,null,"|9||9",null,"Psychosoma"]
[null,null,"|9|9|",null,"Psychosoma"]
[null,null,"|9|9|9",null,"Psychosoma"]
[null,null,"9|||",null,"Psychosoma"]
[null,null,"9|||9",null,"Psychosoma"]
[null,null,"9||9|",null,"Psychosoma"]
[null,null,"9||9|9",null,"Psychosoma"]
[null,null,"9|9||",null,"Psychosoma"]
[null,null,"9|9||9",null,"Psychosoma"]
[null,null,"9|9|9|",null,"Psychosoma"]
[null,null,"9|9|9|9",null,"Psychosoma"]
[null,null,"|||10",null,"Pulmo"]
[null,null,"||10|",null,"Pulmo"]
[null,null,"||10|10",null,"Pulmo"]
[null,null,"|10||",null,"Pulmo"]
[null,null,"|10||10",null,"Pulmo"]
[null,null,"|10|10|",null,"Pulmo"]
[null,null,"|10|10|10",null,"Pulmo"]
[null,null,"10|||",null,"Pulmo"]
[null,null,"10|||10",null,"Pulmo"]
[null,null,"10||10|",null,"Pulmo"]
[null,null,"10||10|10",null,"Pulmo"]
[null,null,"10|10||",null,"Pulmo"]
[null,null,"10|10||10",null,"Pulmo"]
[null,null,"10|10|10|",null,"Pulmo"]
[null,null,"10|10|10|10",null,"Pulmo"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["MB","MB","MB",null,null,null,null," FID  (Importdaten Position 51)"," Rekordart"," Betriebsnummer \n (BUR-Satellit Gesundheit)"," Standort"," Kanton"," Anonymer Verbindungskode (nicht übermitteln!)"," Kennzeichnung des Statistikfalls"," Neugeborenen-Datensatz"," Psychiatrie-Datensatz"," Patientengruppendatensatz"," Kantonaler Datensatz"," Geschlecht"," Geburtsdatum (nicht übermitteln!)"," Alter bei Eintritt"," Wohnort (Region)"," Nationalität"," Eintrittsdatum und -Stunde"," Aufenthaltsort vor Eintritt"," Eintrittsart"," Einweisende Instanz"," Behandlungsart"," Klasse"," Aufenthalt in einer Intensivstation (Stunden)"," Administrativer Urlaub und Ferien (Stunden)"," Hauptkostenstelle"," Hauptkostenträger für Grundversicherungsleistungen"," Austrittsdatum und -Stunde"," Entscheid für Austritt"," Aufenthalt nach Austritt"," Behandlung nach Austritt"," Hauptdiagnose (ICD-10)"," Zusatz zu Hauptdiagnose (ICD-10)"," 1. Nebendiagnose (ICD-10)"," 2. Nebendiagnose (ICD-10)"," 3. Nebendiagnose (ICD-10)"," 4. Nebendiagnose (ICD-10)"," 5. Nebendiagnose (ICD-10)"," 6. Nebendiagnose (ICD-10)"," 7. Nebendiagnose (ICD-10)"," 8. Nebendiagnose (ICD-10)"," Hauptbehandlung (CHOP)"," Beginn Hauptbehandlung (Datum und Stunde)"," 1. weitere Behandlung (CHOP)"," 2. weitere Behandlung (CHOP)"," 3. weitere Behandlung (CHOP)"," 4. weitere Behandlung (CHOP)"," 5. weitere Behandlung (CHOP)"," 6. weitere Behandlung (CHOP)"," 7. weitere Behandlung (CHOP)"," 8. weitere Behandlung (CHOP)"," 9. weitere Behandlung (CHOP)"," Fallidentifikationsnummer FID"," Patientenidentifikations-nummer PID",null,null," Rekordart"," Betriebsnummer \n (BUR-Satellit Gesundheit)"," Standort"," Kanton"," Anonymer Verbindungskode (nicht übermitteln!)"," Kennzeichnung des Statistikfalls"," Neugeborenen-Datensatz"," Psychiatrie-Datensatz"," Patientengruppendatensatz"," Kantonaler Datensatz"," Geschlecht"," Geburtsdatum (nicht übermitteln!)"," Alter bei Eintritt"," Wohnort (Region)"," Nationalität"," Eintrittsdatum und -Stunde"," Aufenthaltsort vor Eintritt"," Eintrittsart"," Einweisende Instanz"," Behandlungsart"," Klasse"," Aufenthalt in einer Intensivstation (Stunden)"," Administrativer Urlaub und Ferien (Stunden)"," Hauptkostenstelle"," Hauptkostenträger für Grundversicherungsleistungen"," Austrittsdatum und -Stunde"," Entscheid für Austritt"," Aufenthalt nach Austritt"," Behandlung nach Austritt"," Hauptdiagnose (ICD-10)"," Zusatz zu Hauptdiagnose (ICD-10)"," 1. Nebendiagnose (ICD-10)"," 2. Nebendiagnose (ICD-10)"," 3. Nebendiagnose (ICD-10)"," 4. Nebendiagnose (ICD-10)"," 5. Nebendiagnose (ICD-10)"," 6. Nebendiagnose (ICD-10)"," 7. Nebendiagnose (ICD-10)"," 8. Nebendiagnose (ICD-10)"," Hauptbehandlund (CHOP"," Beginn Hauptbehandlung (Datum und Stunde)"," 1. weitere Behandlund (CHOP)"," 2. weitere Behandlung (CHOP)"," 3. weitere Behandlung (CHOP)"," 4. weitere Behandlung (CHOP)"," 5. weitere Behandlung (CHOP)"," 6. weitere Behandlung (CHOP)"," 7. weitere Behandlung (CHOP)"," 8. weitere Behandlung (CHOP)"," 9. weitere Behandlung (CHOP)"," Fallidentifikationsnummer FID"," Patientenidentifikations-nummer PID","Drop-Out / Duplikat","Mangel MB","Rekordart","anonymer Verbindungskode (ohne Anzeige)","Geburtsdatum übermittelt (ohne Anzeige)","MIS BUR","INVALID BUR","MIS Demo","INVALID Demo","MIS Eintritt","INVALID Eintritt","UNBEKANNT Eintritt","MIS Austritt","INVALID Austritt","UNBEKANNT Austritt","MIS Diagnose","VALID Diagnose","MIS FID/PID (2)","IVALID FID/PID (2)","Kodierung \"unbekannt\"","zus. VALID_DAT einbeziehen","zus. VALID_DAT einbeziehen","Hauptdiagnose","fehlende Angaben",null,"ungültige Angaben",null,"CONCAT","Mängel insgesamt (evtl. Unterscheidung)"]
[null,null,null,null,null,null,null,null,"0.1.",null,null,null,"0.2.",null,"0.3.",null,null,null,"1.1.",null,null,null,null,"1.2.",null,null,null,"1.3.",null,null,null,"1.4.",null,"1.5.",null,null,null,"1.6.",null,null,null,null,null,null,null,null,null,"1.7.",null,null,null,null,null,null,null,null,null,null,"FID","PID",null,null,"0.1.",null,null,null,"0.2.",null,"0.3.",null,null,null,"1.1.",null,null,null,null,"1.2.",null,null,null,"1.3.",null,null,null,"1.4.",null,"1.5.",null,null,null,"1.6.",null,null,null,null,null,null,null,null,null,"1.7.",null,null,null,null,null,null,null,null,null,null,"FID","PID",null,null,"err0001","err0200","err1100",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"er0005",null,null,null,null,"er0003",null,"er0004"]
[null,null,null,null,null,null,null,null,"V01","V02","V03","V04","V01","V02","V01","V02","V03","V04","V01","V02","V03","V04","V05","V01","V02","V03","V04","V01","V02","V03","V04","V01","V02","V01","V02","V03","V04","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V11",null,null,null,null,"V01","V02","V03","V04","V01","V02","V01","V02","V03","V04","V01","V02","V03","V04","V05","V01","V02","V03","V04","V01","V02","V03","V04","V01","V02","V01","V02","V03","V04","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V11"]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(BG407),\"\",BG407)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(I407=\"\",0,IF(I407=\"MB\",1,-1))","v":0},{"$f":"IF(J407=\"\",0,IF(J407=BL$1,1,-1))","v":0},{"$f":"IF(K407=\"\",0,1)","v":0},{"$f":"IF(L407=\"\",0,IF(OR(L407=\"ZH\",L407=\"BE\",L407=\"LU\",L407=\"UR\",L407=\"SZ\",L407=\"OW\",L407=\"NW\",L407=\"GL\",L407=\"ZG\",L407=\"FR\",L407=\"SO\",L407=\"BS\",L407=\"BL\",L407=\"SH\",L407=\"AR\",L407=\"AI\",L407=\"SG\",L407=\"GR\",L407=\"AG\",L407=\"TG\",L407=\"TI\",L407=\"VD\",L407=\"VS\",L407=\"NE\",L407=\"GE\",L407=\"JU\"),1,-1))","v":0},{"$f":"IF(M407<>\"\",-1,0)","v":0},{"$f":"IF(N407=\"\",0,IF(OR(N407=\"A\",N407=\"B\",N407=\"C\"),1,-1))","v":0},{"$f":"IF(O407=\"\",0,IF(O407=0,1,IF(O407=1,2,-1)))","v":0},{"$f":"IF(P407=\"\",0,IF(P407=0,1,IF(P407=1,2,-1)))","v":0},{"$f":"IF(Q407=\"\",0,IF(Q407=0,1,IF(Q407=1,2,-1)))","v":0},{"$f":"IF(R407=\"\",0,IF(R407=0,1,IF(R407=1,2,-1)))","v":0},{"$f":"IF(S407=\"\",0,IF(OR(S407=1,S407=2),1,-1))","v":0},{"$f":"IF(T407<>\"\",-1,0)","v":0},{"$f":"IF(U407=\"\",0,IF(AND(ISNUMBER(U407),U407>9,U407<136),1,-1))","v":0},{"$f":"IF(V407=\"\",0,IF(OR(LEN(V407)=4,LEN(V407)=3),1,-1))","v":0},{"$f":"IF(W407=\"\",0,IF(COUNTIF(InfoR!O$3:P$265,W407)>0,1,IF(W407=\"NON\",2,-1)))","v":0},{"$f":"IF(X407=\"\",0,IF(AND(ISNUMBER(X407),LEN(X407)=10),IF(OR(VALUE(MID(X407,1,4))<2015,VALUE(MID(X407,1,4))>$BZ$1,VALUE(MID(X407,5,2))<1,VALUE(MID(X407,5,2))>12,VALUE(MID(X407,7,2))<1,VALUE(MID(X407,7,2))>31,VALUE(MID(X407,9,2))>23),-1,1),-1))","v":0},{"$f":"IF(Y407=\"\",0,IF(OR(Y407=1,Y407=2,Y407=3,Y407=4,Y407=5,Y407=6,Y407=7,Y407=8,Y407=55,Y407=66,Y407=83,Y407=84),1,IF(Y407=9,2,-1)))","v":0},{"$f":"IF(Z407=\"\",0,IF(OR(Z407=1,Z407=2,Z407=3,Z407=4,Z407=5,Z407=8),1,IF(Z407=9,2,-1)))","v":0},{"$f":"IF(AA407=\"\",0,IF(OR(AA407=1,AA407=2,AA407=3,AA407=4,AA407=5,AA407=6,AA407=8,AA407=9),1,-1))","v":0},{"$f":"IF(AB407=\"\",0,IF(AB407=3,1,IF(OR(AB407=1,AB407=9),2,-1)))","v":0},{"$f":"IF(AC407=\"\",0,IF(OR(AC407=1,AC407=2,AC407=3),1,IF(AC407=9,2,-1)))","v":0},{"$f":"IF(AD407=\"\",0,IF(ISNUMBER(AD407),1,-1))","v":0},{"$f":"IF(AE407=\"\",0,IF(ISNUMBER(AE407),1,-1))","v":0},{"$f":"IF(AF407=\"\",0,IF(OR(AF407=\"M950\",AF407=\"M900\"),1,IF(OR(AF407=\"M000\",AF407=\"M050\",AF407=\"M100\",AF407=\"M200\",AF407=\"M300\",AF407=\"M400\",AF407=\"AF500\",AF407=\"M600\",AF407=\"M700\",AF407=\"M800\",AF407=\"M990\"),2,-1)))","v":0},{"$f":"IF(AG407=\"\",0,IF(OR(AG407=1,AG407=2,AG407=3,AG407=4,AG407=5,AG407=8),1,IF(AG407=9,2,-1)))","v":0},{"$f":"IF(AH407=\"\",0,IF(AND(ISNUMBER(AH407),LEN(AH407)=10),IF(OR(VALUE(MID(AH407,1,4))<2015,VALUE(MID(AH407,1,4))>$BZ$1,VALUE(MID(AH407,5,2))<1,VALUE(MID(AH407,5,2))>12,VALUE(MID(AH407,7,2))<1,VALUE(MID(AH407,7,2))>31,VALUE(MID(AH407,9,2))>23),-1,1),-1))","v":0},{"$f":"IF(AI407=\"\",0,IF(OR(AI407=1,AI407=2,AI407=3,AI407=4,AI407=5,AI407=8),1,IF(AI407=9,2,-1)))","v":0},{"$f":"IF(AJ407=\"\",0,IF(OR(AJ407=1,AJ407=2,AJ407=3,AJ407=4,AJ407=5,AJ407=6,AJ407=7,AJ407=8,AJ407=44,AJ407=55,AJ407=66,AJ407=0),1,IF(AJ407=9,2,-1)))","v":0},{"$f":"IF(AK407=\"\",0,IF(OR(AK407=1,AK407=2,AK407=3,AK407=4,AK407=5,AK407=8,AK407=9,AK407=0),1,-1))","v":0},{"$f":"IF(AL407=\"\",0,IF(AND(LEN(AL407)>2,LEN(AL407)<7,MID(AL407,1,1)>=\"A\",MID(AL407,1,1)<=\"Z\",ISNUMBER(VALUE(MID(AL407,2,1))),ISNUMBER(VALUE(MID(AL407,3,1))),OR(ISNUMBER(VALUE(MID(AL407,4,1))),MID(AL407,4,1)=\"\",MID(AL407,4,1)=\".\"),OR(ISNUMBER(VALUE(MID(AL407,5,1))),MID(AL407,5,1)=\"\"),OR(AND(MID(AL407,4,1)=\".\",ISNUMBER(VALUE(MID(AL407,6,1)))),MID(AL407,6,1)=\"\")),1,-1))","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(AV407=\"\",0,IF(AND(LEN(AV407)>1,LEN(AV407)<9,OR(AND(ISNUMBER(VALUE(MID(AV407,1,1))),ISNUMBER(VALUE(MID(AV407,2,1)))),MID(AV407,1,2)=\"AA\",MID(AV407,1,2)=\"BA\",MID(AV407,1,2)=\"BB\")),1,-1))","v":0},{"$f":"IF(AW407=\"\",0,IF(AND(ISNUMBER(AW407),LEN(AW407)=10),IF(OR(VALUE(MID(AW407,1,4))<2015,VALUE(MID(AW407,1,4))>$BZ$1,VALUE(MID(AW407,5,2))<1,VALUE(MID(AW407,5,2))>12,VALUE(MID(AW407,7,2))<1,VALUE(MID(AW407,7,2))>31,VALUE(MID(AW407,9,2))>23),-1,1),-1))","v":0},{"$f":"IF(AX407=\"\",0,IF(AND(LEN(AX407)>1,LEN(AX407)<9,OR(AND(ISNUMBER(VALUE(MID(AX407,1,1))),ISNUMBER(VALUE(MID(AX407,2,1)))),MID(AX407,1,2)=\"AA\",MID(AX407,1,2)=\"BA\",MID(AX407,1,2)=\"BB\")),1,-1))","v":0},0,0,0,0,0,0,0,0,{"$f":"IF(BG407=\"\",0,IF(COUNTIF(BG:BG,BG407)>1,-1,1))","v":0},{"$f":"IF(BH407=\"\",0,1)","v":0},{"$f":"IF(BG407=\"\",0,IF(VLOOKUP(BG407,INDIRECT(\"'InfoW'!$A$3:$L$\"&InfoW!$A$2+2),8,FALSE)=\"DUP\",2,IF(VLOOKUP(BG407,INDIRECT(\"'InfoW'!$A$3:$L$\"&InfoW!$A$2+2),12,FALSE)=\"Drop-Out\",1,0)))","v":0},{"$f":"EM407","v":"mangelhaft"},{"$f":"IF(BK407<>1,\"Rekordart mangelhaft / \",\"\")","v":"Rekordart mangelhaft / "},{"$f":"IF(BO407=0,\"\",\"anonym. Verbindungskode vorhanden / \")","v":""},{"$f":"IF(BV407=0,\"\",\"Geburtsdatum angegeben / \")","v":""},{"$f":"IF(BL407=0,\"BUR \",\"\")","v":"BUR "},{"$f":"IF(BL407=-1,\"BUR \",\"\")","v":""},{"$f":"IF(OR(BU407=0,BW407=0,BY407=0),\"Demografie \",\"\")","v":"Demografie "},{"$f":"IF(OR(BU407=-1,BW407=-1,BY407=-1,BY407=2),\"Demografie \",\"\")","v":""},{"$f":"IF(OR(BZ407=0,CA407=0,CB407=0,CD407=0,CE407=0,CI407=0),\"Eintritt \",\"\")","v":"Eintritt "},{"$f":"IF(OR(BZ407=-1,CA407=-1,CB407=-1,CD407=-1,CE407=-1,CI407=-1),\"Eintritt \",\"\")","v":""},null,{"$f":"IF(OR(CJ407=0,CK407=0,CL407=0),\"Austritt \",\"\")","v":"Austritt "},{"$f":"IF(OR(CJ407=-1,CK407=-1,CL407=-1),\"Austritt \",\"\")","v":""},null,{"$f":"IF(CN407=0,\"Hauptdiagnose \",\"\")","v":"Hauptdiagnose "},{"$f":"IF(CN407=-1,\"Hauptdiagnose \",\"\")","v":""},{"$f":"IF(OR(DI407=0,DJ407=0),\"FID/PID \",\"\")","v":"FID/PID "},null,{"$f":"IF(OR(CA407=2,CB407=2,CD407=2,CE407=2,CI407=2,CK407=2,CL407=2),\"unbekannte Angaben Reha-Eintritt/Reha-Austritt / \",\"\")","v":""},{"$f":"IF(BZ407=1,DATE(MID(X407,1,4),MID(X407,5,2),MID(X407,7,2)),\"\")","v":""},{"$f":"IF(CJ407=1,DATE(MID(AH407,1,4),MID(AH407,5,2),MID(AH407,7,2)),\"\")","v":""},{"$f":"IF(CN407=1,MID(AL407,1,3)&\".\"&MID(AL407,4,2),\"\")","v":""},{"$f":"EB407&DP407&DR407&DT407&DW407&DZ407","v":"FID/PID BUR Demografie Eintritt Austritt Hauptdiagnose "},{"$f":"IF(EH407=\"\",\"\",\"fehlende auswertungsrelevante Angaben: \"&EH407&\" / \")","v":"fehlende auswertungsrelevante Angaben: FID/PID BUR Demografie Eintritt Austritt Hauptdiagnose  / "},{"$f":"EC407&DS407&DU407&DX407&EA407","v":""},{"$f":"IF(EJ407=\"\",\"\",\"ungültige auswertungsrelevante Angaben: \"&EJ407&\" / \")","v":""},{"$f":"DM407&EI407&EK407&ED407","v":"Rekordart mangelhaft / fehlende auswertungsrelevante Angaben: FID/PID BUR Demografie Eintritt Austritt Hauptdiagnose  / "},{"$f":"IF(COUNTIF(DR407:EC407,\"\")+COUNTIF(ED407,\"\")=13,\"\",\"mangelhaft\")","v":"mangelhaft"}]
[]
[]
[]
[]
[]
[]
["ZU","ZU","ZU",null,null,null," Rekordart"," Fallidentifikationsnummer"," Betriebsnummer \n (BUR-Satellit Gesundheit)"," CIRS_Datum der Erhebung"," CIRS_01 Herz"," CIRS_02 Hypertonie"," CIRS_03 Gefässe"," CIRS_04 Respiratorisches System"," CIRS_05 Augen, Ohren, Nase, Rachen, …"," CIRS_06 Oberer Gastrointestinaltrakt"," CIRS_07 Unterer Gastrointestinaltrakt"," CIRS_08 Leber und Gallengangsystem"," CIRS_09 Nieren"," CIRS_10 Restlicher Urogenitaltrakt"," CIRS_11 Bewegungsapparat und Haut"," CIRS_12 Neurologisches System"," CIRS_13 Endokrinium und Stoffwechsel"," CIRS_14 Psychische Erkrankungen / …","x",null," Rekordart"," Fallidentifikationsnummer"," Betriebsnummer \n (BUR-Satellit Gesundheit)"," CIRS_Datum der Erhebung"," CIRS_01 Herz"," CIRS_02 Hypertonie"," CIRS_03 Gefässe"," CIRS_04 Respiratorisches System"," CIRS_05 Augen, Ohren, Nase, Rachen, …"," CIRS_06 Oberer Gastrointestinaltrakt"," CIRS_07 Unterer Gastrointestinaltrakt"," CIRS_08 Leber und Gallengangsystem"," CIRS_09 Nieren"," CIRS_10 Restlicher Urogenitaltrakt"," CIRS_11 Bewegungsapparat und Haut"," CIRS_12 Neurologisches System"," CIRS_13 Endokrinium und Stoffwechsel"," CIRS_14 Psychische Erkrankungen / …","Drop-Out / Duplikat","VALID Antworten CIRS","ANZ Antworten CIRS","FID","ZU","BUR","CIRS Datumsangabe","CIRS ungültige Angaben","CIRS weniger als 14 Werte","CONCAT auswertungsrelevant","CONCAT","Mängel insgesamt (evtl. Unterscheidung)"]
[null,null,null,null,null,null,"7.1.","FID","7.1.","7.2.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x",null,"7.1.","FID","7.1.","7.2.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"err7101","err7102","err7200","err7201","err7203"]
[null,null,null,null,null,null,"V01",null,"V02","V00","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V11","V12","V13","V14","x",null,"V01",null,"V02","V00","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V11","V12","V13","V14"]
[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(G417=\"\",0,IF(G417=\"ZU\",1,-1))","v":0},{"$f":"IF(H417=\"\",0,IF(COUNTIF(H:H,H417)>1,-1,1))","v":0},{"$f":"IF(I417=\"\",0,IF(I417=AC$1,1,-1))","v":0},{"$f":"IF(J417=\"\",0,IF(AND(ISNUMBER(J417),LEN(J417)=8),IF(OR(VALUE(MID(J417,1,4))<2015,VALUE(MID(J417,1,4))>$AD$1,VALUE(MID(J417,5,2))<1,VALUE(MID(J417,5,2))>12,VALUE(MID(J417,7,2))<1,VALUE(MID(J417,7,2))>31),-1,1),IF(ISBLANK(J417),1,-1)))","v":0},{"$f":"IF(K417=\"\",0,IF(OR(K417=0,K417=1,K417=2,K417=3,K417=4),1,-1))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(H417=\"\",0,IF(VLOOKUP(H417,INDIRECT(\"'InfoW'!$A$3:$L$\"&InfoW!$A$2+2),11,FALSE)=\"DUP\",2,IF(VLOOKUP(H417,INDIRECT(\"'InfoW'!$A$3:$L$\"&InfoW!$A$2+2),12,FALSE)=\"Drop-Out\",1,0)))","v":0},{"$f":"COUNTIF(AE417:AR417,1)","v":0},{"$f":"14-COUNTIF(AE417:AR417,0)","v":0},{"$f":"IF(AB417=0,\"FID fehlend / \",\"\")","v":"FID fehlend / "},{"$f":"IF(AA417<>1,\"Rekordart mangelhaft / \",\"\")","v":"Rekordart mangelhaft / "},{"$f":"IF(AC417=0,\"BUR mangelhaft / \",\"\")","v":"BUR mangelhaft / "},{"$f":"IF(AD417=0,\"fehlendes Datum CIRS / \",IF(AD417=-1,\"ungültiges Datum CIRS / \",\"\"))","v":"fehlendes Datum CIRS / "},{"$f":"IF(AT417<AU417,\"ungültige Angaben CIRS / \",\"\")","v":""},{"$f":"IF(AU417<14,\"fehlende Angaben CIRS / \",\"\")","v":"fehlende Angaben CIRS / "},{"$f":"CONCATENATE(AY417,AZ417,BA417)","v":"fehlendes Datum CIRS / fehlende Angaben CIRS / "},{"$f":"CONCATENATE(AV417,AW417,AX417,BB417)","v":"FID fehlend / Rekordart mangelhaft / BUR mangelhaft / fehlendes Datum CIRS / fehlende Angaben CIRS / "},{"$f":"IF(BB417<>\"\",\"mangelhaft\",\"\")","v":"mangelhaft"}]
[]
[]
[]
[]
[]
[]
["M2","M2","M2",null,null,null,"Rekordart"," Fallidentifikationsnummer"," Betriebsnummer \n (BUR-Satellit Gesundheit)"," Rehabereich"," Messzeitpunkt (Ein-/Austritt)"," Grund für Drop-Out (Fallausschluss)"," Datum Drop-Out"," HZ/ZE-Datum der Erhebung"," HZ_01_1 Hauptziel"," HZ_01_2 Unterstützung"," ZE_01 Zielanpassung des ... Hauptziels"," ZE_02_1 Zielerreichung ursprüngliches Ziel"," ZE_02_2 stattdessen erreichtes Ziel "," ZE_02_3 Unterstützungsbedarf zu ZE_02_2"," ZE_03_1 Angepasstes Ziel"," ZE_03_2 Unterstützungsbedarf zu ZE_03_1"," ZE_04_1 Zielerreichung angepasstes Ziel"," ZE_04_2  stattdessen erreichtes Ziel"," ZE_04_3 Unterstützungsbedarf zu ZE_04_2"," FIM_Datum der Erhebung"," FIM_01 Essen/Trinken"," FIM_02 Körperpflege"," FIM_03 Baden/Duschen/Waschen"," FIM_04 Ankleiden Oberkörper"," FIM_05 Ankleiden Unterkörper"," FIM_06 Toilettenhygiene"," FIM_07 Blasenkontrolle"," FIM_08 Darmkontrolle"," FIM_09 Transfer Bett/Stuhl/Rollstuhl"," FIM_10 Transfer Toilettensitz"," FIM_11 Transfer Badewanne"," FIM_12_1 Gehen oder Rollstuhlfahren"," FIM_12_2 Spezifikation Fortbewegungsart"," FIM_12_3 Rollstuhlfahren"," FIM_13 Treppensteigen"," FIM_14 Verstehen akustisch/visuell"," FIM_14_1 Spezifikation Kommunikationsform: Verstehen"," FIM_15 Ausdruck verbal/nonverbal"," FIM_15_1: Spezifikation Kommunikationsform: Ausdruck"," FIM_16 Soziales Verhalten"," FIM_17 Problemlösungsfähigkeit"," FIM_18 Gedächtnis"," EBI_Datum der Erhebung"," EBI_01 Essen und Trinken"," EBI_02 Persönliche Pflege"," EBI_03 An- / Ausziehen"," EBI_04 Baden / Duschen / Körper waschen"," EBI_05 Umsteigen aus Rollstuhl in Bett …"," EBI_06 Fortbewegung auf ebenem …"," EBI_07 Treppen auf- / absteigen"," EBI_08 Benutzung der Toilette"," EBI_09 Stuhlkontrolle "," EBI_10 Harnkontrolle"," EBI_11 Verstehen"," EBI_12 Verständlichkeit "," EBI_13 Soziale Interaktion"," EBI_14 Problemlösen"," EBI_15 Gedächtnis / Lernfähigkeit / …"," EBI_16 Sehen / Neglect"," HAQ_01 Ankleiden",null,null,"Rekordart"," Fallidentifikationsnummer"," Betriebsnummer \n (BUR-Satellit Gesundheit)"," Rehabereich"," Messzeitpunkt (Ein-/Austritt)"," Grund für Drop-Out (Ausschluss aus Gesamt-Messung)"," Datum Drop-Out"," HZ/ZE-Datum der Erhebung"," HZ_01_1 Hauptziel"," HZ_01_2 Unterstützung"," ZE_01 Zielanpassung des zu Reha-Beginn festgelegten Hauptziels"," ZE_02_1 Zielerreichung ursprüngliches Ziel"," ZE_02_2 stattdessen erreichtes Ziel "," ZE_02_3 Unterstützungsbedarf des stattdessen erreichten Ziels "," ZE_03_1 Angepasstes Ziel"," ZE_03_2 Unterstützungsbedarf angepasstes Ziel"," ZE_04_1 Zielerreichung angepasstes Ziel"," ZE_04_2  stattdessen erreichtes Ziel"," ZE_04_3 Unterstützungsbedarf des stattdessen erreichten Ziels"," FIM_Datum der Erhebung"," FIM_01 Essen/Trinken"," FIM_02 Körperpflege"," FIM_03 Baden/Duschen/Waschen"," FIM_04 Ankleiden Oberkörper"," FIM_05 Ankleiden Unterkörper"," FIM_06 Toilettenhygiene"," FIM_07 Blasenkontrolle"," FIM_08 Darmkontrolle"," FIM_09 Transfer Bett/Stuhl/Rollstuhl"," FIM_10 Transfer Toilettensitz"," FIM_11 Transfer Badewanne"," FIM_12_1 Gehen oder Rollstuhlfahren"," FIM_12_2 Spezifikation Fortbewegungsart"," FIM_12_3 Rollstuhlfahren"," FIM_13 Treppensteigen"," FIM_14 Verstehen akustisch/visuell"," FIM_14_1 Spezifikation Kommunikationsform: Verstehen"," FIM_15 Ausdruck verbal/nonverbal"," FIM_15_1: Spezifikation Kommunikationsform: Ausdruck"," FIM_16 Soziales Verhalten"," FIM_17 Problemlösungsfähigkeit"," FIM_18 Gedächtnis"," EBI_Datum der Erhebung"," EBI_01 Essen und Trinken"," EBI_02 Persönliche Pflege"," EBI_03 An- / Ausziehen"," EBI_04 Baden / Duschen / Körper waschen"," EBI_05 Umsteigen aus Rollstuhl in Bett und umgekehrt"," EBI_06 Fortbewegung auf ebenem Untergrund"," EBI_07 Treppen auf- / absteigen"," EBI_08 Benutzung der Toilette"," EBI_09 Stuhlkontrolle "," EBI_10 Harnkontrolle"," EBI_11 Verstehen"," EBI_12 Verständlichkeit "," EBI_13 Soziale Interaktion"," EBI_14 Problemlösen"," EBI_15 Gedächtnis / Lernfähigkeit / Orientierung"," EBI_16 Sehen / Neglect","Drop-Out / Duplikat","Plausib Reha-Art/-Bereich","Plausib HZ/ZE","Plausib FIM","Plausib EBI","Mangel M2","Drop-Out","Rekordart","BUR","FID/Messezeitpunkt fehlend","Reha-Art/Rehabereich fehlend","HZ/ZE Datumsangabe","HZ/ZE Kombi","HZ/ZE (nur gültige Kombinationen erlaubt)","ANZ FIM","ANZ EBI","FIM Datumsangabe","FIM ungültige Angaben","FIM weniger als 21/22 Werte [Plausib wird nicht geprüft!]","FIM Fortbewegung unplausibel","EBI Datumsangabe","EBI ungültige Angaben","EBI weniger als 17 Werte (inkl. Datum)","weder FIM noch EBI vorhanden","CONCAT auswertungsrelevant","CONCAT","Mängel insgesamt (evtl. Unterscheidung)"]
[null,null,null,null,null,null,"5.1.","FID","5.1.",null,null,null,null,"5.2.",null,null,null,null,null,null,null,null,null,null,null,"5.3.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5.4.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x",null,null,"5.1.","FID","5.1.",null,null,null,null,"5.2.",null,null,null,null,null,null,null,null,null,null,null,"5.3.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5.4.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"err5101","err5102","err5103","err5104","err5200",null,"err5201-err5203",null,null,"err5300","err5301","err5302","err5303","err5401","err5402","err5403","err5500"]
[null,null,null,null,null,null,"V01",null,"V02","V03","V04","V05","V06","V00","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V11","V00  ","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20","V21","V22","V00","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V11","V12","V13","V14","V15","V16","x",null,null,"V01",null,"V02","V03","V04","V05","V06","V00","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V11","V00  ","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20","V21","V22","V00","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V11","V12","V13","V14","V15","V16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(G427=\"\",0,IF(G427=\"M2\",1,-1))","v":0},{"$f":"IF(H427=\"\",0,IF(COUNTIF(A:A,A427)>1,-1,1))","v":0},{"$f":"IF(I427=\"\",0,IF(I427=BS$1,1,-1))","v":0},{"$f":"IF(J427=\"\",0,IF(OR(J427=1,J427=2,J427=4,J427=5,J427=6,J427=7,J427=8,J427=9),1,IF(OR(J427=3,J427=10),2,-1)))","v":0},{"$f":"IF(K427=\"\",0,IF(OR(K427=1,K427=2),1,-1))","v":0},{"$f":"IF(L427=\"\",0,IF(L427=1,1,-1))","v":0},{"$f":"IF(M427=\"\",0,IF(AND(ISNUMBER(M427),LEN(M427)=8),IF(OR(VALUE(MID(M427,1,4))<2017,VALUE(MID(M427,1,4))>$BW$1,VALUE(MID(M427,5,2))<1,VALUE(MID(M427,5,2))>12,VALUE(MID(M427,7,2))<1,VALUE(MID(M427,7,2))>31),-1,1),IF(ISBLANK(M427),1,-1)))","v":0},{"$f":"IF(N427=\"\",0,IF(AND(ISNUMBER(N427),LEN(N427)=8),IF(OR(VALUE(MID(N427,1,4))<2017,VALUE(MID(N427,1,4))>$BW$1,VALUE(MID(N427,5,2))<1,VALUE(MID(N427,5,2))>12,VALUE(MID(N427,7,2))<1,VALUE(MID(N427,7,2))>31),-1,1),IF(ISBLANK(N427),1,-1)))","v":0},{"$f":"IF(O427=\"\",0,IF(OR(O427=1,O427=2,O427=3,O427=4,O427=5,O427=6,O427=7,O427=8,O427=9,O427=10),1,-1))","v":0},{"$f":"IF(P427=\"\",0,IF(OR(P427=0,P427=1),1,-1))","v":0},{"$f":"IF(Q427=\"\",0,IF(OR(Q427=0,Q427=1),1,-1))","v":0},{"$f":"IF(R427=\"\",0,IF(OR(R427=1,R427=2),1,-1))","v":0},{"$f":"IF(S427=\"\",0,IF(OR(S427=1,S427=2,S427=3,S427=4,S427=5,S427=6,S427=7,S427=8,S427=9,S427=10),1,-1))","v":0},{"$f":"IF(T427=\"\",0,IF(OR(T427=0,T427=1),1,-1))","v":0},{"$f":"IF(U427=\"\",0,IF(OR(U427=1,U427=2,U427=3,U427=4,U427=5,U427=6,U427=7,U427=8,U427=9,U427=10),1,-1))","v":0},{"$f":"IF(V427=\"\",0,IF(OR(V427=0,V427=1),1,-1))","v":0},{"$f":"IF(W427=\"\",0,IF(OR(W427=1,W427=2),1,-1))","v":0},{"$f":"IF(X427=\"\",0,IF(OR(X427=1,X427=2,X427=3,X427=4,X427=5,X427=6,X427=7,X427=8,X427=9,X427=10),1,-1))","v":0},{"$f":"IF(Y427=\"\",0,IF(OR(Y427=0,Y427=1),1,-1))","v":0},{"$f":"IF(Z427=\"\",0,IF(AND(ISNUMBER(Z427),LEN(Z427)=8),IF(OR(VALUE(MID(Z427,1,4))<2017,VALUE(MID(Z427,1,4))>$BW$1,VALUE(MID(Z427,5,2))<1,VALUE(MID(Z427,5,2))>12,VALUE(MID(Z427,7,2))<1,VALUE(MID(Z427,7,2))>31),-1,1),IF(ISBLANK(Z427),1,-1)))","v":0},{"$f":"IF(AA427=\"\",0,IF(OR(AA427=1,AA427=2,AA427=3,AA427=4,AA427=5,AA427=6,AA427=7),1,-1))","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AM427=\"\",0,IF(OR(AM427=1,AM427=2,AM427=3,AM427=4),1,-1))","v":0},{"$f":"IF(AN427=\"\",0,IF(OR(AN427=1,AN427=2,AN427=3,AN427=4,AN427=5,AN427=6),1,-1))","v":0},{"$f":"IF(AO427=\"\",0,IF(OR(AO427=1,AO427=2,AO427=3,AO427=4,AO427=5,AO427=6,AO427=7),1,-1))","v":0},{"$f":"IF(AP427=\"\",0,IF(OR(AP427=1,AP427=2,AP427=3,AP427=4,AP427=5,AP427=6,AP427=7),1,-1))","v":0},{"$f":"IF(AQ427=\"\",0,IF(OR(AQ427=1,AQ427=2,AQ427=3),1,-1))","v":0},{"$f":"IF(AR427=\"\",0,IF(OR(AR427=1,AR427=2,AR427=3,AR427=4,AR427=5,AR427=6,AR427=7),1,-1))","v":0},{"$f":"IF(AS427=\"\",0,IF(OR(AS427=1,AS427=2,AS427=3),1,-1))","v":0},{"$f":"IF(AT427=\"\",0,IF(OR(AT427=1,AT427=2,AT427=3,AT427=4,AT427=5,AT427=6,AT427=7),1,-1))","v":0},{"$f":"IF(AU427=\"\",0,IF(OR(AU427=1,AU427=2,AU427=3,AU427=4,AU427=5,AU427=6,AU427=7),1,-1))","v":0},{"$f":"IF(AV427=\"\",0,IF(OR(AV427=1,AV427=2,AV427=3,AV427=4,AV427=5,AV427=6,AV427=7),1,-1))","v":0},{"$f":"IF(AW427=\"\",0,IF(AND(ISNUMBER(AW427),LEN(AW427)=8),IF(OR(VALUE(MID(AW427,1,4))<2017,VALUE(MID(AW427,1,4))>$BW$1,VALUE(MID(AW427,5,2))<1,VALUE(MID(AW427,5,2))>12,VALUE(MID(AW427,7,2))<1,VALUE(MID(AW427,7,2))>31),-1,1),IF(ISBLANK(AW427),1,-1)))","v":0},{"$f":"IF(AX427=\"\",0,IF(OR(AX427=0,AX427=2,AX427=3,AX427=4),1,-1))","v":0},{"$f":"IF(AY427=\"\",0,IF(OR(AY427=0,AY427=1,AY427=2,AY427=3,AY427=4),1,-1))","v":0},{"$f":"IF(AZ427=\"\",0,IF(OR(AZ427=0,AZ427=1,AZ427=2,AZ427=4),1,-1))","v":0},{"$f":"IF(BA427=\"\",0,IF(OR(BA427=0,BA427=1,BA427=2,BA427=3,BA427=4),1,-1))","v":0},{"$f":"IF(BB427=\"\",0,IF(OR(BB427=0,BB427=1,BB427=2,BB427=4),1,-1))","v":0},{"$f":"IF(BC427=\"\",0,IF(OR(BC427=0,BC427=1,BC427=2,BC427=3,BC427=4),1,-1))","v":0},{"$f":"IF(BD427=\"\",0,IF(OR(BD427=0,BD427=1,BD427=2,BD427=4),1,-1))","v":0},{"$f":"IF(BE427=\"\",0,IF(OR(BE427=0,BE427=1,BE427=2,BE427=4),1,-1))","v":0},{"$f":"IF(BF427=\"\",0,IF(OR(BF427=0,BF427=2,BF427=3,BF427=4),1,-1))","v":0},{"$f":"IF(BG427=\"\",0,IF(OR(BG427=0,BG427=1,BG427=3,BG427=4),1,-1))","v":0},{"$f":"IF(BH427=\"\",0,IF(OR(BH427=0,BH427=1,BH427=3,BH427=4),1,-1))","v":0},{"$f":"IF(BI427=\"\",0,IF(OR(BI427=0,BI427=1,BI427=3,BI427=4),1,-1))","v":0},{"$f":"IF(BJ427=\"\",0,IF(OR(BJ427=0,BJ427=2,BJ427=4),1,-1))","v":0},{"$f":"IF(BK427=\"\",0,IF(OR(BK427=0,BK427=2,BK427=4),1,-1))","v":0},{"$f":"IF(BL427=\"\",0,IF(OR(BL427=0,BL427=1,BL427=2,BL427=3,BL427=4),1,-1))","v":0},{"$f":"IF(BM427=\"\",0,IF(OR(BM427=0,BM427=1,BM427=3,BM427=4),1,-1))","v":0},{"$f":"IF(BR427=0,0,IF(BR427=-1,2,IF(VLOOKUP(H427,INDIRECT(\"'InfoW'!$A$3:$L$\"&InfoW!$A$2+2),12,FALSE)=\"Drop-Out\",1,0)))","v":0},{"$f":"IF(BT427=1,0,1)","v":1},{"$f":"IF(DX427=1,0,IF(EK427=\"HZ unvollständig/unplausibel / \",1,IF(EK427=\"ZE unvollständig/unplausibel / \",2,IF(EK427=\"HZ/ZE unvollständig/unplausibel / \",3,0))))","v":3},{"$f":"IF(AND(DX427=0,OR(EN427<>\"\",EP427<>\"\",EU427<>\"\")),1,IF(AND(DX427=0,EN427=\"\",EP427=\"\",EQ427<>\"\"),2,0))","v":1},{"$f":"IF(AND(DX427=0,OR(ER427<>\"\",ET427<>\"\",EU427<>\"\")),1,0)","v":1},{"$f":"EX427","v":"mangelhaft"},{"$f":"IF(OR(AND(BV427=0,BW427=0),AND(BV427=1,BW427=1)),\"\",\"Drop-Out mangelhaft / \")","v":""},{"$f":"IF(BQ427<>1,\"Rekordart mangelhaft / \",\"\")","v":"Rekordart mangelhaft / "},{"$f":"IF(BS427=0,\"BUR mangelhaft / \",\"\")","v":"BUR mangelhaft / "},{"$f":"IF(BR427=0,\"FID fehlend / \",IF(BU427=1,\"\",\"Messzeitpunkt mangelhaft / \"))","v":"FID fehlend / "},{"$f":"IF(BT427=1,\"\",IF(BT427=2,\"Rehabereich nicht M2 / \",\"Rehabereich mangelhaft / \"))","v":"Rehabereich mangelhaft / "},{"$f":"IF(BX427=-1,\"ungültiges Datum \"&IF(J427=1,\"HZ / \",IF(J427=2,\"ZE / \",\"HZ/ZE / \")),\"\")","v":""},{"$f":"BX427&\"_\"&O427&\"|\"&P427&\"|\"&Q427&\"|\"&R427&\"|\"&S427&\"|\"&T427&\"|\"&U427&\"|\"&V427&\"|\"&W427&\"|\"&X427&\"|\"&Y427","v":"0_||||||||||"},{"$f":"IF(AND(K427=1,ISNA(VLOOKUP(EJ427,InfoR!$C$204:$D$216,2,FALSE))),\"HZ unvollständig/unplausibel / \",IF(AND(K427=2,ISNA(VLOOKUP(EJ427,InfoR!$C$8:$D$203,2,FALSE))),\"ZE unvollständig/unplausibel / \",IF(ISNA(VLOOKUP(EJ427,InfoR!$C$8:$D$216,2,FALSE)),\"HZ/ZE unvollständig/unplausibel / \",\"\")))","v":"HZ/ZE unvollständig/unplausibel / "},{"$f":"23-COUNTIF(CJ427:DF427,0)","v":0},{"$f":"17-COUNTIF(DG427:DW427,0)","v":0},{"$f":"IF(CJ427=-1,\"ungültiges Datum FIM / \",\"\")","v":""},{"$f":"IF(COUNTIF(CK427:DF427,-1)>0,\"ungültige Angaben FIM / \",\"\")","v":""},{"$f":"IF(EL427=23,\"\",IF(OR(AND(EL427=22,AM427<4,ISBLANK(AN427)),AND(EL427=22,AM427=4,OR(ISBLANK(AL427),ISBLANK(AN427)),K427=2)),\"\",IF(EL427>0,\"fehlende Angaben FIM / \",\"\")))","v":""},{"$f":"IF(OR(IF(ISNA(VLOOKUP(H427&\"1\",INDIRECT(\"A$6:AM$\"&$H$1+5),39,FALSE)),FALSE,IF(AND(K427=2,AM427<>VLOOKUP(H427&\"1\",INDIRECT(\"A$6:AM$\"&$H$1+5),39,FALSE)),TRUE,FALSE)),AND(OR(AM427=1,AM427=2,AM427=3),COUNT(AN427)=1),AND(K427=1,AM427=4,OR(ISBLANK(AL427),ISBLANK(AN427)))),\"FIM Fortbewegung unplausibel / \",\"\")","v":""},{"$f":"IF(DG427=-1,\"ungültiges Datum EBI / \",\"\")","v":""},{"$f":"IF(COUNTIF(DH427:DW427,-1),\"ungültige Angaben EBI / \",\"\")","v":""},{"$f":"IF(AND(EM427>0,EM427<17),\"fehlende Angaben EBI / \",\"\")","v":""},{"$f":"IF(EL427+EM427=0,\"FIM/EBI fehlend / \",\"\")","v":"FIM/EBI fehlend / "},{"$f":"ED427&EG427&EH427&EI427&EK427&EN427&EO427&EP427&EQ427&ER427&ES427&ET427&EU427","v":"FID fehlend / Rehabereich mangelhaft / HZ/ZE unvollständig/unplausibel / FIM/EBI fehlend / "},{"$f":"EV427&EE427&EF427","v":"FID fehlend / Rehabereich mangelhaft / HZ/ZE unvollständig/unplausibel / FIM/EBI fehlend / Rekordart mangelhaft / BUR mangelhaft / "},{"$f":"IF(EV427<>\"\",\"mangelhaft\",\"\")","v":"mangelhaft"}]
[]
[]
[]
[]
[]
[]
["M3","M3","M3",null,null,null," Rekordart"," Fallidentifikationsnummer"," Betriebsnummer \n (BUR-Satellit Gesundheit)"," Diagnose Pulmo-Reha (für CRQ)"," Rehabereich"," Messzeitpunkt (Ein-/Austritt)"," Grund für Drop-Out (Fallausschluss)"," Datum Drop-Out"," 6MWT_Datum der Durchführung"," 6MWT_1 Zurückgelegte Strecke"," 6MWT_2 Gehdauer in Minuten"," 6MWT_3 Verwendung einer Gehhilfe"," 6MWT_4 Abgabe von Sauerstoff"," 6MWT_5 Grund für Test-Abbruch "," 6MWT_6 Grund für Abbruch (Anderer)"," 6MWT_7 Grund für Test-Verzicht "," 6MWT_8 Grund für Test-Verzicht (Anderer)"," Ergo_Datum der Durchführung"," Ergo_1 Maximale Leistung "," Ergo_2 Dauer der Belastungsphase "," Ergo_3 Grund für Test-Abbruch"," Ergo_4 Grund für Abbruch (Anderer)"," Ergo_5 Grund für Test-Verzicht "," Ergo_6 Grund für Test-Verzicht (Anderer)"," MacNew_Datum der Erhebung"," MacNew_01 frustriert gefühlt"," MacNew_02 wertlos gefühlt"," MacNew_03 zuversichtlich gefühlt"," MacNew_04 entmutigt gefühlt"," MacNew_05 entspannt gefühlt "," MacNew_06 erschöpft gefühlt "," MacNew_07 glücklich und zufrieden"," MacNew_08 rastlos gefühlt "," MacNew_09 Stärke Atemnot"," MacNew_10 zum Weinen gefühlt"," MacNew_11 abhängiger gefühlt "," MacNew_12 außerstande … zu Aktivitäten"," MacNew_13 mangelndes Vertrauen anderer "," MacNew_14 Brustschmerzen"," MacNew_15 Mangel an Selbstbewusstsein"," MacNew_16 … schmerzende Beine"," MacNew_17 beim Sport eingeschränkt "," MacNew_18 besorgt oder verängstigt …"," MacNew_19 schwindlig oder benommen …"," MacNew_20 eingeschränkt oder reduziert …"," MacNew_21 unsicher … körperl. Aktivität"," MacNew_22 Familie als zu besorgt …"," MacNew_23 als Last für andere gefühlt "," MacNew_24 Ausschluss von Aktivitäten"," MacNew_25 unfähig zu sozialen Kontakten …"," MacNew_26 … körperl. Belastung eingeschränkt"," MacNew_27 beeinträchtigtes Sexualleben"," MacNew_Grund für Test-Verzicht"," MacNew_Grund für Test-Verzicht (Anderer)"," Feeling_Datum der Erhebung"," Feeling"," Feeling_Grund für Test-Verzicht"," Feeling_Grund für Test-Verzicht (Anderer)"," CRQ_Datum der Erhebung"," CRQ_01 Kurzatmigkeit bei … Ärger"," CRQ_02 Kurzatmigkeit bei Aktivitäten …"," CRQ_03 Kurzatmigkeit bei zu Fuss gehen"," CRQ_04 Kurzatmigkeit bei Hausarbeiten"," CRQ_05 Kurzatmigkeit bei gesell. Leben"," CRQ_06 frustriert oder ungeduldig"," CRQ_07 Gefühl der Angst und Panik"," CRQ_08 müde gefühlt"," CRQ_09 Husten oder schweres Atmen …"," CRQ_10 zuversichtlich … wg. Krankheit "," CRQ_11 Energie in den letzten 2 Wochen "," CRQ_12 verärgert, besorgt oder deprimiert"," CRQ_13 Atemprobleme unter Kontrolle"," CRQ_14 locker und entspannt "," CRQ_15 wenig Lebensenergie"," CRQ_16 mutlos oder niedergeschlagen"," CRQ_17 erschöpft oder lustlos"," CRQ_18 zufrieden mit Leben "," CRQ_19 verstört oder ängstlich"," CRQ_20 ruhelos, angespannt oder nervös"," CRQ_Grund für Test-Verzicht"," CRQ_Grund für Test-Verzicht (Anderer)",null,null,null," Rekordart"," Fallidentifikationsnummer"," Betriebsnummer \n (BUR-Satellit Gesundheit)"," Diagnose Pulmo-Reha (für CRQ Durchführung)"," Rehabereich"," Messzeitpunkt (Ein-/Austritt)"," Grund für Drop-Out (Ausschluss aus Gesamt-Messung)"," Datum Drop-Out"," 6MWT_Datum der Durchführung"," 6MWT_1 Zurückgelegte Strecke"," 6MWT_2 Gehdauer in Minuten"," 6MWT_3 Verwendung einer Gehhilfe"," 6MWT_4 Abgabe von Sauerstoff"," 6MWT_5 Grund für Test-Abbruch "," 6MWT_6 Grund für Abbruch (Anderer)"," 6MWT_7 Grund für Test-Verzicht "," 6MWT_8 Grund für Test-Verzicht (Anderer)"," Ergo_Datum der Durchführung"," Ergo_1 Maximale Leistung "," Ergo_2 Dauer der Belastungsphase "," Ergo_3 Grund für Test-Abbruch"," Ergo_4 Grund für Abbruch (Anderer)"," Ergo_5 Grund für Test-Verzicht "," Ergo_6 Grund für Test-Verzicht (Anderer)"," MacNew_Datum der Erhebung"," MacNew_01 frustriert gefühlt"," MacNew_02 wertlos gefühlt"," MacNew_03 zuversichtlich gefühlt"," MacNew_04 entmutigt gefühlt"," MacNew_05 entspannt gefühlt "," MacNew_06 erschöpft gefühlt "," MacNew_07 glücklich und zufrieden"," MacNew_08 rastlos gefühlt "," MacNew_09 Stärke Atemnot"," MacNew_10 zum Weinen gefühlt"," MacNew_11 abhängiger gefühlt "," MacNew_12 außerstande gefühlt zu Aktivitäten"," MacNew_13 mangelndes Vertrauen anderer "," MacNew_14 Brustschmerzen"," MacNew_15 Mangel an Selbstbewusstsein"," MacNew_16 beunruhigt aufgrund schmerzender Beine"," MacNew_17 beim Sport eingeschränkt "," MacNew_18 besorgt oder verängstigt gefühlt "," MacNew_19 schwindlig oder benommen gefühlt "," MacNew_20 eingeschränkt oder reduziert gefühlt "," MacNew_21 unsicher bezüglich Gymnastik oder körperl. Aktivität"," MacNew_22 Familie als zu besorgt empfunden"," MacNew_23 als Last für andere gefühlt "," MacNew_24 von Aktivitäten mit anderen ausgeschlossen gefühlt "," MacNew_25 unfähig zu sozialen Kontakten gefühlt "," MacNew_26 bei täglicher körperlicher Belastung eingeschränkt"," MacNew_27 beeinträchtigtes Sexualleben"," MacNew_Grund für Abbruch"," MacNew_Grund für Abbruch (Anderer)"," Feeling_Datum der Erhebung"," Feeling"," Feeling_Grund für Abbruch"," Feeling_Grund für Abbruch (Anderer)"," CRQ_Datum der Erhebung"," CRQ_01 Kurzatmigkeit bei Gefühl von Ärger"," CRQ_02 Kurzatmigkeit bei Aktivitäten des täglichen Lebens"," CRQ_03 Kurzatmigkeit bei zu Fuss gehen"," CRQ_04 Kurzatmigkeit bei Hausarbeiten"," CRQ_05 Kurzatmigkeit bei gesell. Leben"," CRQ_06 frustriert oder ungeduldig"," CRQ_07 Gefühl der Angst und Panik"," CRQ_08 müde gefühlt"," CRQ_09 Husten oder schweres Atmen peinlich"," CRQ_10 zuversichtlich bei Umgang mit Krankheit "," CRQ_11 Energie in den letzten 2 Wochen "," CRQ_12 verärgert, besorgt oder deprimiert"," CRQ_13 Atemprobleme unter Kontrolle"," CRQ_14 locker und entspannt "," CRQ_15 wenig Lebensenergie"," CRQ_16 mutlos oder niedergeschlagen"," CRQ_17 erschöpft oder lustlos"," CRQ_18 zufrieden mit Leben "," CRQ_19 verstört oder ängstlich"," CRQ_20 ruhelos, angespannt oder nervös"," CRQ_Grund für Verzicht"," MacNew_Grund für Test-Verzicht (Anderer)","Drop-Out / Duplikat","Plausib Reha-Art/-Bereich","Plausib GT6M","Plausib Ergo","Plausib MNH","Plausib FT","Plausib CRQ"," 6MWT_2 Gehdauer (Sekunden oder #WERT!)"," Ergo_2 Dauer (Sekunden oder #WERT!)","Mangel M3","Drop-Out","Rekordart","BUR","FID/Messezeitpunkt fehlend","Reha-Art/Rehabereich fehlend","Leistungstest fehlend","MacNew fehlend","FT fehlend","CRQ fehlend","falsche Kombination von Messinstrumenten","GT6M fehlende Werte","VALID Datum GT6M","GT6M ungültige Werte Strecke","GT6M ungültige Gehdauer","GT6M ungültige Werte","GT6M unplausible Angaben","Ergo fehlende Werte","VALID Datum Ergo","Ergo ungültige Werte Leistung","Ergo ungültige Ergodauer","Ergo ungültige Werte","Ergo unplausible Angaben","MNH fehlende Werte","VALID Datum MNH","MNH ungültige Werte","MNH unplausible Angaben","MNH zu viele Angaben unbekannt","FT fehlende Werte","VALID Datum Feeling","FT ungültige Werte","FT unplausible Angaben","CRQ fehlende Werte","VALID Datum CRQ","CRQ ungültige Werte","CRQ unplausible Angaben","CRQ zu viele Angaben unbekannt","CONCAT Gehtest","CONCAT Ergo","CONCAT MNH","CONCAT FT","CONCAT CRQ","CONCAT auswertungsrelevant","CONCAT","Mängel insgesamt (evtl. Unterscheidung)"]
[null,null,null,null,null,null,"6.1.","FID",null,null,null,null,null,null,"6.2.",null,null,null,null,null,null,null,null,"6.3.",null,null,null,null,null,null,"6.4.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6.5.",null,null,null,"6.6.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x",null,null,"6.1.","FID",null,null,null,null,null,null,"6.2.",null,null,null,null,null,null,null,null,"6.3.",null,null,null,null,null,null,"6.4.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6.5.",null,null,null,"6.6.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"err6101","err6102","err6103","err6104-err6104","err6106-err6107","err6108","err6109","err6110","err6111","err6200","err6201","err6202","err6203","err6204","err6205","err6300","err6301","err6302","err6303","err6304","err6305","err6400","err6401","err6402","err6403","err6404","err6500","err6501","err6502","err6503","err6600","err6601","err6602","err6603","err6604"]
[null,null,null,null,null,null,"V01",null,"V02","V03","V04","V05","V06","V07","V00","V01","V02","V03","V04","V05","V06","V07","V08","V00","V01","V02","V03","V04","V05","V06","V00","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20","V21","V22","V23","V24","V25","V26","V27","V28","V29","V00","V01","V02","V03","V00","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20","V21","V22","x",null,null,"V01",null,"V02","V03","V04","V05","V06","V07","V00","V01","V02","V03","V04","V05","V06","V07","V08","V00","V01","V02","V03","V04","V05","V06","V00","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20","V21","V22","V23","V24","V25","V26","V27","V28","V29","V00","V01","V02","V03","V00","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20","V21","V22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(G437=\"\",0,IF(G437=\"M3\",1,-1))","v":0},{"$f":"IF(H437=\"\",0,IF(COUNTIF(A:A,A437)>1,-1,1))","v":0},{"$f":"IF(I437=\"\",0,IF(I437=CO$1,1,-1))","v":0},{"$f":"IF(J437=\"\",0,IF(OR(J437=1,J437=2),1,-1))","v":0},{"$f":"IF(K437=\"\",0,IF(OR(K437=3,K437=10),1,IF(OR(K437=1,K437=2,K437=4,K437=5,K437=6,K437=7,K437=8,K437=9),2,-1)))","v":0},{"$f":"IF(L437=\"\",0,IF(OR(L437=1,L437=2),1,-1))","v":0},{"$f":"IF(M437=\"\",0,IF(M437=1,1,-1))","v":0},{"$f":"IF(N437=\"\",0,IF(AND(ISNUMBER(N437),LEN(N437)=8),IF(OR(VALUE(MID(N437,1,4))<2017,VALUE(MID(N437,1,4))>$CT$1,VALUE(MID(N437,5,2))<1,VALUE(MID(N437,5,2))>12,VALUE(MID(N437,7,2))<1,VALUE(MID(N437,7,2))>31),-1,1),IF(ISBLANK(N437),1,-1)))","v":0},{"$f":"IF(O437=\"\",0,IF(AND(ISNUMBER(O437),LEN(O437)=8),IF(OR(VALUE(MID(O437,1,4))<2017,VALUE(MID(O437,1,4))>$CT$1,VALUE(MID(O437,5,2))<1,VALUE(MID(O437,5,2))>12,VALUE(MID(O437,7,2))<1,VALUE(MID(O437,7,2))>31),-1,1),IF(ISBLANK(O437),1,-1)))","v":0},{"$f":"IF(P437=\"\",0,IF(OR(AND(LEN(P437)=1,P437>=0,P437<10),AND(LEN(P437)=2,P437>9,P437<100),AND(LEN(P437)=3,P437>99,P437<1000)),1,-1))","v":0},{"$f":"IF(Q437=\"\",0,IF(ISERR(FW437),-1,IF(OR(FW437>360,FW437<0),-1,1)))","v":0},{"$f":"IF(R437=\"\",0,IF(OR(R437=1,R437=2),1,-1))","v":0},{"$f":"IF(S437=\"\",0,IF(OR(S437=1,S437=2),1,-1))","v":0},{"$f":"IF(T437=\"\",0,IF(OR(T437=1,T437=2,T437=3,T437=4,T437=5,T437=6),1,-1))","v":0},{"$f":"IF(U437=\"\",0,1)","v":0},{"$f":"IF(V437=\"\",0,IF(OR(V437=1,V437=2,V437=3,V437=4),1,-1))","v":0},{"$f":"IF(W437=\"\",0,1)","v":0},{"$f":"IF(X437=\"\",0,IF(AND(ISNUMBER(X437),LEN(X437)=8),IF(OR(VALUE(MID(X437,1,4))<2017,VALUE(MID(X437,1,4))>$CT$1,VALUE(MID(X437,5,2))<1,VALUE(MID(X437,5,2))>12,VALUE(MID(X437,7,2))<1,VALUE(MID(X437,7,2))>31),-1,1),IF(ISBLANK(X437),1,-1)))","v":0},{"$f":"IF(Y437=\"\",0,IF(OR(AND(LEN(Y437)=1,Y437>=0,Y437<10),AND(LEN(Y437)=2,Y437>9,Y437<100),AND(LEN(Y437)=3,Y437>99,Y437<301)),1,-1))","v":0},{"$f":"IF(Z437=\"\",0,IF(ISERR(FX437),-1,IF(OR(FX437>1200,FX437<0),-1,1)))","v":0},{"$f":"IF(AA437=\"\",0,IF(OR(AA437=1,AA437=2,AA437=3,AA437=4,AA437=5),1,-1))","v":0},{"$f":"IF(AB437=\"\",0,1)","v":0},{"$f":"IF(AC437=\"\",0,IF(OR(AC437=1,AC437=2,AC437=3,AC437=4),1,-1))","v":0},{"$f":"IF(AD437=\"\",0,1)","v":0},{"$f":"IF(AE437=\"\",0,IF(AND(ISNUMBER(AE437),LEN(AE437)=8),IF(OR(VALUE(MID(AE437,1,4))<2017,VALUE(MID(AE437,1,4))>$CT$1,VALUE(MID(AE437,5,2))<1,VALUE(MID(AE437,5,2))>12,VALUE(MID(AE437,7,2))<1,VALUE(MID(AE437,7,2))>31),-1,1),IF(ISBLANK(AE437),1,-1)))","v":0},{"$f":"IF(AF437=\"\",0,IF(OR(AF437=1,AF437=2,AF437=3,AF437=4,AF437=5,AF437=6,AF437=7),1,IF(AF437=9,2,-1)))","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,{"$f":"IF(BF437=\"\",0,IF(OR(BF437=1,BF437=2,BF437=3,BF437=4,BF437=5,BF437=6,BF437=7),1,IF(OR(BF437=8,BF437=9),2,-1)))","v":0},{"$f":"IF(BG437=\"\",0,IF(OR(BG437=1,BG437=2,BG437=3,BG437=4),1,-1))","v":0},{"$f":"IF(BH437=\"\",0,1)","v":0},{"$f":"IF(BI437=\"\",0,IF(AND(ISNUMBER(BI437),LEN(BI437)=8),IF(OR(VALUE(MID(BI437,1,4))<2017,VALUE(MID(BI437,1,4))>$CT$1,VALUE(MID(BI437,5,2))<1,VALUE(MID(BI437,5,2))>12,VALUE(MID(BI437,7,2))<1,VALUE(MID(BI437,7,2))>31),-1,1),IF(ISBLANK(BI437),1,-1)))","v":0},{"$f":"IF(BJ437=\"\",0,IF(OR(AND(LEN(BJ437)=1,BJ437>=0,BJ437<10),AND(LEN(BJ437)=2,BJ437>9,BJ437<100),BJ437=100),1,IF(BJ437=999,2,-1)))","v":0},{"$f":"IF(BK437=\"\",0,IF(OR(BK437=1,BK437=2,BK437=3,BK437=4),1,-1))","v":0},{"$f":"IF(BL437=\"\",0,1)","v":0},{"$f":"IF(BM437=\"\",0,IF(AND(ISNUMBER(BM437),LEN(BM437)=8),IF(OR(VALUE(MID(BM437,1,4))<2017,VALUE(MID(BM437,1,4))>$CT$1,VALUE(MID(BM437,5,2))<1,VALUE(MID(BM437,5,2))>12,VALUE(MID(BM437,7,2))<1,VALUE(MID(BM437,7,2))>31),-1,1),IF(ISBLANK(BM437),1,-1)))","v":0},{"$f":"IF(BN437=\"\",0,IF(OR(BN437=1,BN437=2,BN437=3,BN437=4,BN437=5,BN437=6,BN437=7),1,IF(OR(BN437=8,BN437=9),2,-1)))","v":0},{"$f":"IF(BO437=\"\",0,IF(OR(BO437=1,BO437=2,BO437=3,BO437=4,BO437=5,BO437=6,BO437=7),1,IF(OR(BO437=8,BO437=9),2,-1)))","v":0},{"$f":"IF(BP437=\"\",0,IF(OR(BP437=1,BP437=2,BP437=3,BP437=4,BP437=5,BP437=6,BP437=7),1,IF(OR(BP437=8,BP437=9),2,-1)))","v":0},{"$f":"IF(BQ437=\"\",0,IF(OR(BQ437=1,BQ437=2,BQ437=3,BQ437=4,BQ437=5,BQ437=6,BQ437=7),1,IF(OR(BQ437=8,BQ437=9),2,-1)))","v":0},{"$f":"IF(BR437=\"\",0,IF(OR(BR437=1,BR437=2,BR437=3,BR437=4,BR437=5,BR437=6,BR437=7),1,IF(OR(BR437=8,BR437=9),2,-1)))","v":0},{"$f":"IF(BS437=\"\",0,IF(OR(BS437=1,BS437=2,BS437=3,BS437=4,BS437=5,BS437=6,BS437=7),1,IF(BS437=9,2,-1)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(CH437=\"\",0,IF(OR(CH437=1,CH437=2,CH437=3,CH437=4),1,-1))","v":0},{"$f":"IF(CI437=\"\",0,1)","v":0},{"$f":"IF(CN437=0,0,IF(CN437=-1,2,IF(VLOOKUP(H437,INDIRECT(\"'InfoW'!$A$3:$L$\"&InfoW!$A$2+2),12,FALSE)=\"Drop-Out\",1,0)))","v":0},{"$f":"IF(OR(AND(K437=3,CP437=0),AND(K437=10,CP437=1)),0,1)","v":1},{"$f":"IF(OR(GE437<>\"\",HJ437<>\"\"),1,0)","v":1},{"$f":"IF(OR(GE437=\"Messung Leistungstest fehlend / \",HK437<>\"\"),1,0)","v":1},{"$f":"IF(OR(GF437<>\"\",HL437<>\"\"),1,0)","v":0},{"$f":"IF(OR(GG437<>\"\",HM437<>\"\"),1,0)","v":0},{"$f":"IF(OR(GH437<>\"\",HN437<>\"\"),1,0)","v":0},{"$f":"IF(ISBLANK(Q437),0,IF(AND(LEN(Q437)=5,MID(Q437,3,1)=\":\",INT(MID(Q437,4,2))<60),60*MID(Q437,1,2)+MID(Q437,4,2),IF(AND(LEN(Q437)=4,MID(Q437,2,1)=\":\",INT(MID(Q437,3,2))<60),60*MID(Q437,1,1)+MID(Q437,3,2),#VALUE!)))","v":0},{"$f":"IF(ISBLANK(Z437),0,IF(AND(LEN(Z437)=5,MID(Z437,3,1)=\":\",INT(MID(Z437,4,2))<60),60*MID(Z437,1,2)+MID(Z437,4,2),IF(AND(LEN(Z437)=4,MID(Z437,2,1)=\":\",INT(MID(Z437,3,2))<60),60*MID(Z437,1,1)+MID(Z437,3,2),#VALUE!)))","v":0},{"$f":"HQ437","v":"mangelhaft"},{"$f":"IF(OR(AND(CS437=0,CT437=0),AND(CS437=1,CT437=1)),\"\",\"Drop-Out mangelhaft / \")","v":""},{"$f":"IF(CM437<>1,\"Rekordart mangelhaft / \",\"\")","v":"Rekordart mangelhaft / "},{"$f":"IF(CO437=0,\"BUR mangelhaft / \",\"\")","v":"BUR mangelhaft / "},{"$f":"IF(CN437=0,\"FID fehlend / \",IF(CN437=1,\"\",\"Messzeitpunkt mangelhaft / \"))","v":"FID fehlend / "},{"$f":"IF(OR(AND(K437=3,CP437=0),AND(K437=10,CP437=1)),\"\",IF(CQ437=2,\"Rehabereich nicht M3 / \",IF(OR(K437=10,CP437=1),\"Rehabereich/Pulmo-Reha mangelhaft / \",\"Rehabereich mangelhaft / \")))","v":"Rehabereich mangelhaft / "},{"$f":"IF(COUNTIF(CU437:DC437,0)=9,IF(K437=10,\"Messung Gehtest fehlend / \",IF(COUNTIF(DD437:DJ437,0)=7,\"Messung Leistungstest fehlend / \",\"\")),\"\")","v":"Messung Leistungstest fehlend / "},{"$f":"IF(AND(K437=3,COUNTIF(DK437:EN437,0)=30),\"Messung MNH fehlend / \",\"\")","v":""},{"$f":"IF(AND(K437=10,COUNTIF(EO437:ER437,0)=4),\"Messung Feeling-T fehlend / \",\"\")","v":""},{"$f":"IF(AND(K437=10,DD437=1,COUNTIF(ES437:FO437,0)=23),\"Messung CRQ fehlend / \",\"\")","v":""},{"$f":"IF(OR(AND(K437=3,COUNTIF(EO437:FO437,0)=27,OR(COUNTIF(CU437:DC437,0)=9,COUNTIF(DD437:DJ437,0)=7)),AND(K437=10,COUNTIF(DD437:EN437,0)=37)),\"\",\"falsche Kombination von Messungen / \")","v":"falsche Kombination von Messungen / "},{"$f":"IF(AND(COUNTIF(CU437:DC437,0)<9,OR(CU437=0,AND(COUNTIF(CV437:CY437,0)>0,DB437=0),AND(CV437=0,V437=3),AND(COUNTIF(CV437:CY437,0)=0,CZ437=0,IF(ISERR(FW437),FALSE,IF(AND(FW437>0,FW437<360),TRUE,FALSE))))),\"fehlende Angaben Gehtest / \",\"\")","v":""},{"$f":"IF(CU437=-1,\"ungültiges Datum GT6M / \",\"\")","v":""},{"$f":"IF(CV437=-1,\"ungültige Angabe Gehtest/Strecke / \",\"\")","v":""},{"$f":"IF(CW437=-1,\"ungültige Angabe Gehtest/Dauer / \",\"\")","v":""},{"$f":"IF(COUNTIF(CX437:DC437,-1)=0,\"\",\"ungültige Angaben Gehtest / \")","v":""},{"$f":"IF(AND(P437=0,V437=3,CU437=1,COUNTIF(CW437:DA437,0)=5),\"\",IF(OR(AND(COUNTIF(CV437:CY437,0)<4,IF(ISERR(FW437),TRUE,IF(AND(FW437>0,FW437<360),FALSE,TRUE)),OR(CZ437<>0,DB437<>0)),AND(CZ437<>0,DB437<>0),AND(CZ437=0,IF(ISERR(FW437),FALSE,IF(AND(CW437<>0,FW437>0,FW437<360),TRUE,FALSE)))),\"unplausible Angaben Gehtest / \",\"\"))","v":""},{"$f":"IF(AND(COUNTIF(DD437:DJ437,0)<7,OR(DD437=0,AND(COUNTIF(DE437:DG437,0)>0,DI437=0))),\"fehlende Angaben Ergo / \",\"\")","v":""},{"$f":"IF(DD437=-1,\"ungültiges Datum Ergo / \",\"\")","v":""},{"$f":"IF(DE437=-1,\"ungültige Angabe Ergo/Leistung / \",\"\")","v":""},{"$f":"IF(DF437=-1,\"ungültige Angabe Ergo/Dauer / \",\"\")","v":""},{"$f":"IF(COUNTIF(DG437:DJ437,-1)=0,\"\",\"ungültige Angaben Ergo / \")","v":""},{"$f":"IF(AND(COUNTIF(DE437:DH437,0)<4,COUNTIF(DI437:DJ437,0)<2),\"unplausible Angaben Ergo / \",\"\")","v":""},{"$f":"IF(OR(COUNTIF(DK437:EN437,0)=30,AND(DK437<>0,OR(COUNTIF(DL437:EL437,0)=0,EM437<>0))),\"\",\"fehlende Angaben MNH / \")","v":""},{"$f":"IF(DK437=-1,\"ungültiges Datum MNH / \",\"\")","v":""},{"$f":"IF(COUNTIF(DL437:EN437,-1)=0,\"\",\"ungültige Angaben MNH / \")","v":""},{"$f":"IF(AND(COUNTIF(DL437:EL437,0)<27,COUNTIF(DL437:EL437,2)<27,EM437<>0),\"unplausible Angaben MNH / \",\"\")","v":""},{"$f":"IF(OR(EM437=1,COUNTIF(DL437:EK437,0)=26,AND(COUNTIF(DL437:DS437,1)+COUNTIF(DU437,1)+COUNTIF(DW437:DX437,1)+COUNTIF(DZ437,1)+COUNTIF(EC437,1)+COUNTIF(EH437,1)>6,COUNTIF(DQ437,1)+COUNTIF(DT437,1)+COUNTIF(DW437,1)+COUNTIF(DY437,1)+COUNTIF(EA437:EB437,1)+COUNTIF(ED437:EF437,1)+COUNTIF(EI437:EK437,1)>5,COUNTIF(DM437,1)+COUNTIF(DV437:DX437,1)+COUNTIF(DZ437,1)+COUNTIF(EB437,1)+COUNTIF(EE437:EK437,1)>6)),\"\",\"zu wenig Werte für Subscore-Berechnung MNH / \")","v":""},{"$f":"IF(OR(COUNTIF(EO437:ER437,0)=4,AND(EO437<>0,COUNTIF(EP437:ER437,0)<3)),\"\",\"fehlende Angaben Feeling-T / \")","v":""},{"$f":"IF(EO437=-1,\"ungültiges Datum Feeling-T / \",\"\")","v":""},{"$f":"IF(COUNTIF(EP437:ER437,-1)=0,\"\",\"ungültige Angaben Feeling-T / \")","v":""},{"$f":"IF(OR(AND(EP437<>0,EQ437<>0),AND(BK437<>4,ER437<>0)),\"unplausible Angaben Feeling-T / \",\"\")","v":""},{"$f":"IF(AND(ES437<>0,OR(COUNTIF(ET437:FM437,0)=0,FN437<>0)),\"\",IF(COUNTIF(ES437:FO437,0)=23,\"\",\"fehlende Angaben CRQ / \"))","v":""},{"$f":"IF(ES437=-1,\"ungültiges Datum CRQ / \",\"\")","v":""},{"$f":"IF(COUNTIF(ET437:FO437,-1)=0,\"\",\"ungültige Angaben CRQ / \")","v":""},{"$f":"IF(AND(COUNTIF(ET437:FM437,0)<20,COUNTIF(ET437:FM437,2)<20,FN437<>0),\"unplausible Angaben CRQ / \",\"\")","v":""},{"$f":"IF(OR(AND(COUNTIF(ET437:EX437,1)>2,COUNTIF(FA437,1)+COUNTIF(FD437,1)+COUNTIF(FH437,1)+COUNTIF(FJ437,1)>2,COUNTIF(EY437,1)+COUNTIF(FB437,1)+COUNTIF(FE437,1)+COUNTIF(FG437,1)+COUNTIF(FI437,1)+COUNTIF(FK437,1)+COUNTIF(FM437,1)>3,COUNTIF(EZ437,1)+COUNTIF(FC437,1)+COUNTIF(FF437,1)+COUNTIF(FL437,1)>2),COUNTIF(ES437:FO437,0)=23,FN437=1),\"\",\"zu wenig Werte für Subscore-Berechnung CRQ / \")","v":""},{"$f":"GJ437&GK437&GL437&GM437&GN437&GO437","v":""},{"$f":"GP437&GQ437&GR437&GS437&GT437&GU437","v":""},{"$f":"GV437&GW437&GX437&GY437&GZ437","v":""},{"$f":"HA437&HB437&HC437&HD437","v":""},{"$f":"HE437&HF437&HG437&HH437&HI437","v":""},{"$f":"GC437&GD437&GE437&GF437&GG437&GH437&GI437&HJ437&HK437&HL437&HM437&HN437","v":"FID fehlend / Rehabereich mangelhaft / Messung Leistungstest fehlend / falsche Kombination von Messungen / "},{"$f":"GA437&GB437&HO437","v":"Rekordart mangelhaft / BUR mangelhaft / FID fehlend / Rehabereich mangelhaft / Messung Leistungstest fehlend / falsche Kombination von Messungen / "},{"$f":"IF(HP437<>\"\",\"mangelhaft\",\"\")","v":"mangelhaft"}]

{"sheet":"MB temp","index":6,"n_rows":6,"n_cols":143,"rows_kept":6,"cut":false,"hidden":true,"merged":[[4,60,4,61],[4,62,4,116],[4,117,4,133],[4,6,4,59],[4,2,4,3]]}
[null,"MB","ANQ-Reha-Test-2020_v7.1",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"► Demografie",null,null,null,null,"► Reha-Eintritt",null,null,null,null,null,null,null,null,null,"► Reha-Austritt",null,null,null,null,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":"MODE(INDIRECT(\"J6:J\"&$H$1+5))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(BK1),-1,IF(AND(BK1>50000000,BK1<90000000),BK1,-1))","v":-1},null,null,null,null,"2/GRAU","2/GRAU","2/GRAU","2/GRAU",null,null,"Komma nicht geprüft","nur Länge geprüft",null,2020,"Y","Z","AA","AB","AC","AD","AE","AF","AG","AH","AI","AJ","AK","AL","AM","AN","AO","AP","AQ","AR","AS","AT","AU","AV","AW","AX","AY","AZ","BA","BB","BC","BD","BE","BF","BG","BH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ohne BUR (DQ6)"]
[null,null,"Status MB (Mängel)",null,null,null,null," FID  (Importdaten Position 51)"," Rekordart"," Betriebsnummer \n (BUR-Satellit Gesundheit)"," Standort"," Kanton"," Anonymer Verbindungskode (nicht übermitteln!)"," Kennzeichnung des Statistikfalls"," Neugeborenen-Datensatz"," Psychiatrie-Datensatz"," Patientengruppendatensatz"," Kantonaler Datensatz"," Geschlecht"," Geburtsdatum (nicht übermitteln!)"," Alter bei Eintritt"," Wohnort (Region)"," Nationalität"," Eintrittsdatum und -Stunde"," Aufenthaltsort vor Eintritt"," Eintrittsart"," Einweisende Instanz"," Behandlungsart"," Klasse"," Aufenthalt in einer Intensivstation (Stunden)"," Administrativer Urlaub und Ferien (Stunden)"," Hauptkostenstelle"," Hauptkostenträger für Grundversicherungsleistungen"," Austrittsdatum und -Stunde"," Entscheid für Austritt"," Aufenthalt nach Austritt"," Behandlung nach Austritt"," Hauptdiagnose (ICD-10)"," Zusatz zu Hauptdiagnose (ICD-10)"," 1. Nebendiagnose (ICD-10)"," 2. Nebendiagnose (ICD-10)"," 3. Nebendiagnose (ICD-10)"," 4. Nebendiagnose (ICD-10)"," 5. Nebendiagnose (ICD-10)"," 6. Nebendiagnose (ICD-10)"," 7. Nebendiagnose (ICD-10)"," 8. Nebendiagnose (ICD-10)"," Hauptbehandlung (CHOP)"," Beginn Hauptbehandlung (Datum und Stunde)"," 1. weitere Behandlung (CHOP)"," 2. weitere Behandlung (CHOP)"," 3. weitere Behandlung (CHOP)"," 4. weitere Behandlung (CHOP)"," 5. weitere Behandlung (CHOP)"," 6. weitere Behandlung (CHOP)"," 7. weitere Behandlung (CHOP)"," 8. weitere Behandlung (CHOP)"," 9. weitere Behandlung (CHOP)"," Fallidentifikationsnummer FID"," Patientenidentifikationsnummer PID",null,null," Rekordart"," Betriebsnummer \n (BUR-Satellit Gesundheit)"," Standort"," Kanton"," Anonymer Verbindungskode (nicht übermitteln!)"," Kennzeichnung des Statistikfalls"," Neugeborenen-Datensatz"," Psychiatrie-Datensatz"," Patientengruppendatensatz"," Kantonaler Datensatz"," Geschlecht"," Geburtsdatum (nicht übermitteln!)"," Alter bei Eintritt"," Wohnort (Region)"," Nationalität"," Eintrittsdatum und -Stunde"," Aufenthaltsort vor Eintritt"," Eintrittsart"," Einweisende Instanz"," Behandlungsart"," Klasse"," Aufenthalt in einer Intensivstation (Stunden)"," Administrativer Urlaub und Ferien (Stunden)"," Hauptkostenstelle"," Hauptkostenträger für Grundversicherungsleistungen"," Austrittsdatum und -Stunde"," Entscheid für Austritt"," Aufenthalt nach Austritt"," Behandlung nach Austritt"," Hauptdiagnose (ICD-10)"," Zusatz zu Hauptdiagnose (ICD-10)"," 1. Nebendiagnose (ICD-10)"," 2. Nebendiagnose (ICD-10)"," 3. Nebendiagnose (ICD-10)"," 4. Nebendiagnose (ICD-10)"," 5. Nebendiagnose (ICD-10)"," 6. Nebendiagnose (ICD-10)"," 7. Nebendiagnose (ICD-10)"," 8. Nebendiagnose (ICD-10)"," Hauptbehandlund (CHOP"," Beginn Hauptbehandlung (Datum und Stunde)"," 1. weitere Behandlund (CHOP)"," 2. weitere Behandlung (CHOP)"," 3. weitere Behandlung (CHOP)"," 4. weitere Behandlung (CHOP)"," 5. weitere Behandlung (CHOP)"," 6. weitere Behandlung (CHOP)"," 7. weitere Behandlung (CHOP)"," 8. weitere Behandlung (CHOP)"," 9. weitere Behandlung (CHOP)"," Fallidentifikationsnummer FID"," Patientenidentifikations-nummer PID","Drop-Out / Duplikat","Mangel MB","Rekordart","anonymer Verbindungskode","Geburtsdatum übermittelt","MIS BUR","INVALID BUR","MIS Demo","INVALID Demo","MIS Eintritt","INVALID Eintritt","UNBEKANNT Eintritt","MIS Austritt","INVALID Austritt","UNBEKANNT Austritt","MIS Diagnose","VALID Diagnose","MIS FID/PID (2)","IVALID FID/PID (2)","Kodierung \"unbekannt\"","zus. VALID_DAT einbeziehen","zus. VALID_DAT einbeziehen","Hauptdiagnose","fehlende Angaben",null,"ungültige Angaben",null,"CONCAT","Mängel insgesamt (evtl. Unterscheidung)"]
[null,null,null,null,null,null,null,null,"0.1.",null,null,null,"0.2.",null,"0.3.",null,null,null,"1.1.",null,null,null,null,"1.2.",null,null,null,"1.3.",null,null,null,"1.4.",null,"1.5.",null,null,null,"1.6.",null,null,null,null,null,null,null,null,null,"1.7.",null,null,null,null,null,null,null,null,null,null,"FID","PID",null,null,"0.1.",null,null,null,"0.2.",null,"0.3.",null,null,null,"1.1.",null,null,null,null,"1.2.",null,null,null,"1.3.",null,null,null,"1.4.",null,"1.5.",null,null,null,"1.6.",null,null,null,null,null,null,null,null,null,"1.7.",null,null,null,null,null,null,null,null,null,null,"FID","PID",null,null,"err0001","err0200","err1100",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"er0005",null,null,null,null,"er0003",null,"er0004"]
[null,null,null,null,null,null,null,null,"V01","V02","V03","V04","V01","V02","V01","V02","V03","V04","V01","V02","V03","V04","V05","V01","V02","V03","V04","V01","V02","V03","V04","V01","V02","V01","V02","V03","V04","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V11",null,null,null,null,"V01","V02","V03","V04","V01","V02","V01","V02","V03","V04","V01","V02","V03","V04","V05","V01","V02","V03","V04","V01","V02","V03","V04","V01","V02","V01","V02","V03","V04","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V11"]
[null,{"$f":"IF(AND(J5<>\"\",COUNTIF(J$5:J$5,J5)>1),\"DUP\",\"\")","v":""},"Filter   ►",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OK"]
[null,{"$f":"IF(AND(J6<>\"\",COUNTIF(J$5:J$5,J6)>1),\"DUP\",\"\")","v":""},{"$f":"IF(DK6=2,\"Duplikat \"&EL6,IF(COUNTIF(BH6:DJ6,0)=52,\"\",EL6))","v":0},null,null,null,null,{"$f":"IF(ISBLANK(BG6),\"\",BG6)","v":""}]

{"sheet":"ZU temp","index":7,"n_rows":6,"n_cols":56,"rows_kept":6,"cut":false,"hidden":true,"merged":[[4,2,4,3],[4,5,4,23],[4,24,4,25],[4,26,4,55]]}
[null,"ZU","ANQ-Reha-Test-2020_v7.1",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MODE(INDIRECT(\"I6:I\"&$H$1+5))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(AB1),-1,IF(AND(AB1>50000000,AB1<90000000),AB1,-1))","v":-1},2020,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AC6<>1,\"BUR mangelhaft / \",\"\")","v":"BUR mangelhaft / "}]
[null,null,"Status ZU (Mängel)",null,null,null," Rekordart"," Fallidentifikationsnummer"," Betriebsnummer \n (BUR-Satellit Gesundheit)"," CIRS_Datum der Erhebung"," CIRS_01 Herz"," CIRS_02 Hypertonie"," CIRS_03 Gefässe"," CIRS_04 Respiratorisches System"," CIRS_05 Augen, Ohren, Nase, Rachen, …"," CIRS_06 Oberer Gastrointestinaltrakt"," CIRS_07 Unterer Gastrointestinaltrakt"," CIRS_08 Leber und Gallengangsystem"," CIRS_09 Nieren"," CIRS_10 Restlicher Urogenitaltrakt"," CIRS_11 Bewegungsapparat und Haut"," CIRS_12 Neurologisches System"," CIRS_13 Endokrinium und Stoffwechsel"," CIRS_14 Psychische Erkrankungen / …","x",null," Rekordart"," Fallidentifikationsnummer"," Betriebsnummer \n (BUR-Satellit Gesundheit)"," CIRS_Datum der Erhebung"," CIRS_01 Herz"," CIRS_02 Hypertonie"," CIRS_03 Gefässe"," CIRS_04 Respiratorisches System"," CIRS_05 Augen, Ohren, Nase, Rachen, …"," CIRS_06 Oberer Gastrointestinaltrakt"," CIRS_07 Unterer Gastrointestinaltrakt"," CIRS_08 Leber und Gallengangsystem"," CIRS_09 Nieren"," CIRS_10 Restlicher Urogenitaltrakt"," CIRS_11 Bewegungsapparat und Haut"," CIRS_12 Neurologisches System"," CIRS_13 Endokrinium und Stoffwechsel"," CIRS_14 Psychische Erkrankungen / …","Drop-Out / Duplikat","VALID Antworten CIRS","ANZ Antworten CIRS","FID","ZU","BUR","CIRS Datumsangabe","CIRS ungültige Angaben","CIRS weniger als 14 Werte","CONCAT auswertungsrelevant","CONCAT","Mängel insgesamt (evtl. Unterscheidung)"]
[null,null,null,null,null,null,"7.1.","FID","7.1.","7.2.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x",null,"7.1.","FID","7.1.","7.2.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"err7101","err7102","err7200","err7201","err7203"]
[null,null,null,null,null,null,"V01",null,"V02","V00","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V11","V12","V13","V14","x",null,"V01",null,"V02","V00","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V11","V12","V13","V14"]
[null,null,"Filter   ►"]
[null,null,{"$f":"IF(COUNTIF(AA6:AR6,0)=18,\"\",IF(AS6=2,\"Duplikat \"&BC6,IF(AS6=1,\"Drop-Out\",IF(BC6<>\"\",BC6,\"\"))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]

{"sheet":"M2 temp","index":8,"n_rows":6,"n_cols":154,"rows_kept":6,"cut":false,"hidden":true,"merged":[[4,2,4,3],[4,5,4,64],[4,65,4,67],[4,68,4,132]]}
[null,"M2","ANQ-Reha-Test-2020_v7.1",null,null,null,null,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,null,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":"MODE(INDIRECT(\"I6:I\"&$H$1+5))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(BR1),-1,IF(AND(BR1>50000000,BR1<90000000),BR1,-1))","v":-1},null,null,null,2020,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(BS6<>1,\"BUR mangelhaft / \",\"\")","v":"BUR mangelhaft / "}]
["ID*Messzeitpunkt > AUSBLENDEN",null,"Status M2 (Mängel)",null,null,null," Rekordart"," Fallidentifikationsnummer"," Betriebsnummer \n (BUR-Satellit Gesundheit)"," Rehabereich"," Messzeitpunkt (Ein-/Austritt)"," Grund für Drop-Out (Fallausschluss)"," Datum Drop-Out"," HZ/ZE-Datum der Erhebung"," HZ_01_1 Hauptziel"," HZ_01_2 Unterstützung"," ZE_01 Zielanpassung des ... Hauptziels"," ZE_02_1 Zielerreichung ursprüngliches Ziel"," ZE_02_2 stattdessen erreichtes Ziel "," ZE_02_3 Unterstützungsbedarf zu ZE_02_2"," ZE_03_1 Angepasstes Ziel"," ZE_03_2 Unterstützungsbedarf zu ZE_03_1"," ZE_04_1 Zielerreichung angepasstes Ziel"," ZE_04_2  stattdessen erreichtes Ziel"," ZE_04_3 Unterstützungsbedarf zu ZE_04_2"," FIM_Datum der Erhebung"," FIM_01 Essen/Trinken"," FIM_02 Körperpflege"," FIM_03 Baden/Duschen/Waschen"," FIM_04 Ankleiden Oberkörper"," FIM_05 Ankleiden Unterkörper"," FIM_06 Toilettenhygiene"," FIM_07 Blasenkontrolle"," FIM_08 Darmkontrolle"," FIM_09 Transfer Bett/Stuhl/Rollstuhl"," FIM_10 Transfer Toilettensitz"," FIM_11 Transfer Badewanne"," FIM_12_1 Gehen oder Rollstuhlfahren"," FIM_12_2 Spezifikation Fortbewegungsart"," FIM_12_3 Rollstuhlfahren"," FIM_13 Treppensteigen"," FIM_14 Verstehen akustisch/visuell"," FIM_14_1 Spezifikation Kommunikationsform: Verstehen"," FIM_15 Ausdruck verbal/nonverbal"," FIM_15_1: Spezifikation Kommunikationsform: Ausdruck"," FIM_16 Soziales Verhalten"," FIM_17 Problemlösungsfähigkeit"," FIM_18 Gedächtnis"," EBI_Datum der Erhebung"," EBI_01 Essen und Trinken"," EBI_02 Persönliche Pflege"," EBI_03 An- / Ausziehen"," EBI_04 Baden / Duschen / Körper waschen"," EBI_05 Umsteigen aus Rollstuhl in Bett …"," EBI_06 Fortbewegung auf ebenem …"," EBI_07 Treppen auf- / absteigen"," EBI_08 Benutzung der Toilette"," EBI_09 Stuhlkontrolle "," EBI_10 Harnkontrolle"," EBI_11 Verstehen"," EBI_12 Verständlichkeit "," EBI_13 Soziale Interaktion"," EBI_14 Problemlösen"," EBI_15 Gedächtnis / Lernfähigkeit / …"," EBI_16 Sehen / Neglect"," HAQ_01 Ankleiden",null,null,"Rekordart"," Fallidentifikationsnummer"," Betriebsnummer \n (BUR-Satellit Gesundheit)"," Rehabereich"," Messzeitpunkt (Ein-/Austritt)"," Grund für Drop-Out (Ausschluss aus Gesamt-Messung)"," Datum Drop-Out"," HZ/ZE-Datum der Erhebung"," HZ_01_1 Hauptziel"," HZ_01_2 Unterstützung"," ZE_01 Zielanpassung des zu Reha-Beginn festgelegten Hauptziels"," ZE_02_1 Zielerreichung ursprüngliches Ziel"," ZE_02_2 stattdessen erreichtes Ziel "," ZE_02_3 Unterstützungsbedarf des stattdessen erreichten Ziels "," ZE_03_1 Angepasstes Ziel"," ZE_03_2 Unterstützungsbedarf angepasstes Ziel"," ZE_04_1 Zielerreichung angepasstes Ziel"," ZE_04_2  stattdessen erreichtes Ziel"," ZE_04_3 Unterstützungsbedarf des stattdessen erreichten Ziels"," FIM_Datum der Erhebung"," FIM_01 Essen/Trinken"," FIM_02 Körperpflege"," FIM_03 Baden/Duschen/Waschen"," FIM_04 Ankleiden Oberkörper"," FIM_05 Ankleiden Unterkörper"," FIM_06 Toilettenhygiene"," FIM_07 Blasenkontrolle"," FIM_08 Darmkontrolle"," FIM_09 Transfer Bett/Stuhl/Rollstuhl"," FIM_10 Transfer Toilettensitz"," FIM_11 Transfer Badewanne"," FIM_12_1 Gehen oder Rollstuhlfahren"," FIM_12_2 Spezifikation Fortbewegungsart"," FIM_12_3 Rollstuhlfahren"," FIM_13 Treppensteigen"," FIM_14 Verstehen akustisch/visuell"," FIM_14_1 Spezifikation Kommunikationsform: Verstehen"," FIM_15 Ausdruck verbal/nonverbal"," FIM_15_1: Spezifikation Kommunikationsform: Ausdruck"," FIM_16 Soziales Verhalten"," FIM_17 Problemlösungsfähigkeit"," FIM_18 Gedächtnis"," EBI_Datum der Erhebung"," EBI_01 Essen und Trinken"," EBI_02 Persönliche Pflege"," EBI_03 An- / Ausziehen"," EBI_04 Baden / Duschen / Körper waschen"," EBI_05 Umsteigen aus Rollstuhl in Bett und umgekehrt"," EBI_06 Fortbewegung auf ebenem Untergrund"," EBI_07 Treppen auf- / absteigen"," EBI_08 Benutzung der Toilette"," EBI_09 Stuhlkontrolle "," EBI_10 Harnkontrolle"," EBI_11 Verstehen"," EBI_12 Verständlichkeit "," EBI_13 Soziale Interaktion"," EBI_14 Problemlösen"," EBI_15 Gedächtnis / Lernfähigkeit / Orientierung"," EBI_16 Sehen / Neglect","Drop-Out / Duplikat","Plausib Reha-Art/-Bereich","Plausib HZ/ZE","Plausib FIM","Plausib EBI","Mangel M2","Drop-Out","Rekordart","BUR","FID/Messezeitpunkt fehlend","Reha-Art/Rehabereich fehlend","HZ/ZE Datumsangabe","HZ/ZE Kombi","HZ/ZE (nur gültige Kombinationen erlaubt)","ANZ FIM","ANZ EBI","FIM Datumsangabe","FIM ungültige Angaben","FIM weniger als 21/22 Werte [Plausib wird nicht geprüft!]","FIM Fortbewegung unplausibel","EBI Datumsangabe","EBI ungültige Angaben","EBI weniger als 17 Werte (inkl. Datum)","weder FIM noch EBI vorhanden","CONCAT auswertungsrelevant","CONCAT","Mängel insgesamt (evtl. Unterscheidung)"]
[null,null,null,null,null,null,"5.1.","FID","5.1.",null,null,null,null,"5.2.",null,null,null,null,null,null,null,null,null,null,null,"5.3.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5.4.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x",null,null,"5.1.","FID","5.1.",null,null,null,null,"5.2.",null,null,null,null,null,null,null,null,null,null,null,"5.3.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5.4.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"err5101","err5102","err5103","err5104","err5200",null,"err5201-err5203",null,null,"err5300","err5301","err5302","err5303","err5401","err5402","err5403","err5500"]
[null,null,null,null,null,null,"V01",null,"V02","V03","V04","V05","V06","V00","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V11","V00  ","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20","V21","V22","V00","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V11","V12","V13","V14","V15","V16","x",null,null,"V01",null,"V02","V03","V04","V05","V06","V00","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V11","V00  ","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20","V21","V22","V00","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V11","V12","V13","V14","V15","V16"]
[null,null,"Filter   ►"]
[{"$f":"CONCATENATE(H6,K6)","v":""},null,{"$f":"IF(COUNTIF(BQ6:DW6,0)=59,\"\",IF(DX6=2,\"Duplikat \"&EW6,IF(DX6=1,\"Drop-Out\"&IF(ED6=\"\",\"\",\" (mangelhaft)\"),IF(EW6<>\"\",EW6,\"\"))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]

{"sheet":"M3 temp","index":9,"n_rows":6,"n_cols":225,"rows_kept":6,"cut":false,"hidden":true,"merged":[[4,2,4,3],[4,5,4,86],[4,87,4,89],[4,90,4,181]]}
[null,"M3","ANQ-Reha-Test-2020_v7.1",null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"MODE(INDIRECT(\"I6:I\"&$H$1+5))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(CN1),-1,IF(AND(CN1>50000000,CN1<90000000),CN1,-1))","v":-1},null,null,null,null,2020,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(CO6<>1,\"BUR mangelhaft / \",\"\")","v":"BUR mangelhaft / "}]
[null,null,"Status M3 (Mängel)",null,null,null," Rekordart"," Fallidentifikationsnummer"," Betriebsnummer \n (BUR-Satellit Gesundheit)"," Diagnose Pulmo-Reha (für CRQ)"," Rehabereich"," Messzeitpunkt (Ein-/Austritt)"," Grund für Drop-Out (Fallausschluss)"," Datum Drop-Out"," 6MWT_Datum der Durchführung"," 6MWT_1 Zurückgelegte Strecke"," 6MWT_2 Gehdauer in Minuten"," 6MWT_3 Verwendung einer Gehhilfe"," 6MWT_4 Abgabe von Sauerstoff"," 6MWT_5 Grund für Test-Abbruch "," 6MWT_6 Grund für Abbruch (Anderer)"," 6MWT_7 Grund für Test-Verzicht "," 6MWT_8 Grund für Test-Verzicht (Anderer)"," Ergo_Datum der Durchführung"," Ergo_1 Maximale Leistung "," Ergo_2 Dauer der Belastungsphase "," Ergo_3 Grund für Test-Abbruch"," Ergo_4 Grund für Abbruch (Anderer)"," Ergo_5 Grund für Test-Verzicht "," Ergo_6 Grund für Test-Verzicht (Anderer)"," MacNew_Datum der Erhebung"," MacNew_01 frustriert gefühlt"," MacNew_02 wertlos gefühlt"," MacNew_03 zuversichtlich gefühlt"," MacNew_04 entmutigt gefühlt"," MacNew_05 entspannt gefühlt "," MacNew_06 erschöpft gefühlt "," MacNew_07 glücklich und zufrieden"," MacNew_08 rastlos gefühlt "," MacNew_09 Stärke Atemnot"," MacNew_10 zum Weinen gefühlt"," MacNew_11 abhängiger gefühlt "," MacNew_12 außerstande … zu Aktivitäten"," MacNew_13 mangelndes Vertrauen anderer "," MacNew_14 Brustschmerzen"," MacNew_15 Mangel an Selbstbewusstsein"," MacNew_16 … schmerzende Beine"," MacNew_17 beim Sport eingeschränkt "," MacNew_18 besorgt oder verängstigt …"," MacNew_19 schwindlig oder benommen …"," MacNew_20 eingeschränkt oder reduziert …"," MacNew_21 unsicher … körperl. Aktivität"," MacNew_22 Familie als zu besorgt …"," MacNew_23 als Last für andere gefühlt "," MacNew_24 Ausschluss von Aktivitäten"," MacNew_25 unfähig zu sozialen Kontakten …"," MacNew_26 … körperl. Belastung eingeschränkt"," MacNew_27 beeinträchtigtes Sexualleben"," MacNew_Grund für Test-Verzicht"," MacNew_Grund für Test-Verzicht (Anderer)"," Feeling_Datum der Erhebung"," Feeling"," Feeling_Grund für Test-Verzicht"," Feeling_Grund für Test-Verzicht (Anderer)"," CRQ_Datum der Erhebung"," CRQ_01 Kurzatmigkeit bei … Ärger"," CRQ_02 Kurzatmigkeit bei Aktivitäten …"," CRQ_03 Kurzatmigkeit bei zu Fuss gehen"," CRQ_04 Kurzatmigkeit bei Hausarbeiten"," CRQ_05 Kurzatmigkeit bei gesell. Leben"," CRQ_06 frustriert oder ungeduldig"," CRQ_07 Gefühl der Angst und Panik"," CRQ_08 müde gefühlt"," CRQ_09 Husten oder schweres Atmen …"," CRQ_10 zuversichtlich … wg. Krankheit "," CRQ_11 Energie in den letzten 2 Wochen "," CRQ_12 verärgert, besorgt oder deprimiert"," CRQ_13 Atemprobleme unter Kontrolle"," CRQ_14 locker und entspannt "," CRQ_15 wenig Lebensenergie"," CRQ_16 mutlos oder niedergeschlagen"," CRQ_17 erschöpft oder lustlos"," CRQ_18 zufrieden mit Leben "," CRQ_19 verstört oder ängstlich"," CRQ_20 ruhelos, angespannt oder nervös"," CRQ_Grund für Test-Verzicht"," CRQ_Grund für Test-Verzicht (Anderer)",null,null,null," Rekordart"," Fallidentifikationsnummer"," Betriebsnummer \n (BUR-Satellit Gesundheit)"," Diagnose Pulmo-Reha (für CRQ Durchführung)"," Rehabereich"," Messzeitpunkt (Ein-/Austritt)"," Grund für Drop-Out (Ausschluss aus Gesamt-Messung)"," Datum Drop-Out"," 6MWT_Datum der Durchführung"," 6MWT_1 Zurückgelegte Strecke"," 6MWT_2 Gehdauer in Minuten"," 6MWT_3 Verwendung einer Gehhilfe"," 6MWT_4 Abgabe von Sauerstoff"," 6MWT_5 Grund für Test-Abbruch "," 6MWT_6 Grund für Abbruch (Anderer)"," 6MWT_7 Grund für Test-Verzicht "," 6MWT_8 Grund für Test-Verzicht (Anderer)"," Ergo_Datum der Durchführung"," Ergo_1 Maximale Leistung "," Ergo_2 Dauer der Belastungsphase "," Ergo_3 Grund für Test-Abbruch"," Ergo_4 Grund für Abbruch (Anderer)"," Ergo_5 Grund für Test-Verzicht "," Ergo_6 Grund für Test-Verzicht (Anderer)"," MacNew_Datum der Erhebung"," MacNew_01 frustriert gefühlt"," MacNew_02 wertlos gefühlt"," MacNew_03 zuversichtlich gefühlt"," MacNew_04 entmutigt gefühlt"," MacNew_05 entspannt gefühlt "," MacNew_06 erschöpft gefühlt "," MacNew_07 glücklich und zufrieden"," MacNew_08 rastlos gefühlt "," MacNew_09 Stärke Atemnot"," MacNew_10 zum Weinen gefühlt"," MacNew_11 abhängiger gefühlt "," MacNew_12 außerstande gefühlt zu Aktivitäten"," MacNew_13 mangelndes Vertrauen anderer "," MacNew_14 Brustschmerzen"," MacNew_15 Mangel an Selbstbewusstsein"," MacNew_16 beunruhigt aufgrund schmerzender Beine"," MacNew_17 beim Sport eingeschränkt "," MacNew_18 besorgt oder verängstigt gefühlt "," MacNew_19 schwindlig oder benommen gefühlt "," MacNew_20 eingeschränkt oder reduziert gefühlt "," MacNew_21 unsicher bezüglich Gymnastik oder körperl. Aktivität"," MacNew_22 Familie als zu besorgt empfunden"," MacNew_23 als Last für andere gefühlt "," MacNew_24 von Aktivitäten mit anderen ausgeschlossen gefühlt "," MacNew_25 unfähig zu sozialen Kontakten gefühlt "," MacNew_26 bei täglicher körperlicher Belastung eingeschränkt"," MacNew_27 beeinträchtigtes Sexualleben"," MacNew_Grund für Abbruch"," MacNew_Grund für Abbruch (Anderer)"," Feeling_Datum der Erhebung"," Feeling"," Feeling_Grund für Abbruch"," Feeling_Grund für Abbruch (Anderer)"," CRQ_Datum der Erhebung"," CRQ_01 Kurzatmigkeit bei Gefühl von Ärger"," CRQ_02 Kurzatmigkeit bei Aktivitäten des täglichen Lebens"," CRQ_03 Kurzatmigkeit bei zu Fuss gehen"," CRQ_04 Kurzatmigkeit bei Hausarbeiten"," CRQ_05 Kurzatmigkeit bei gesell. Leben"," CRQ_06 frustriert oder ungeduldig"," CRQ_07 Gefühl der Angst und Panik"," CRQ_08 müde gefühlt"," CRQ_09 Husten oder schweres Atmen peinlich"," CRQ_10 zuversichtlich bei Umgang mit Krankheit "," CRQ_11 Energie in den letzten 2 Wochen "," CRQ_12 verärgert, besorgt oder deprimiert"," CRQ_13 Atemprobleme unter Kontrolle"," CRQ_14 locker und entspannt "," CRQ_15 wenig Lebensenergie"," CRQ_16 mutlos oder niedergeschlagen"," CRQ_17 erschöpft oder lustlos"," CRQ_18 zufrieden mit Leben "," CRQ_19 verstört oder ängstlich"," CRQ_20 ruhelos, angespannt oder nervös"," CRQ_Grund für Abbruch"," CRQ_Grund für Abbruch (Anderer)","Drop-Out / Duplikat","Plausib Reha-Art","Plausib GT6M","Plausib Ergo","Plausib MNH","Plausib FT","Plausib CRQ"," 6MWT_2 Gehdauer (Sekunden oder #WERT!)"," Ergo_2 Dauer (Sekunden oder #WERT!)","Mangel M3","Drop-Out","Rekordart","BUR","FID/Messezeitpunkt fehlend","Reha-Art/Rehabereich fehlend","Leistungstest fehlend","MacNew fehlend","FT fehlend","CRQ fehlend","falsche Kombination von Messinstrumenten","GT6M fehlende Werte","VALID Datum GT6M","GT6M ungültige Werte Strecke","GT6M ungültige Gehdauer","GT6M ungültige Werte","GT6M unplausible Angaben","Ergo fehlende Werte","VALID Datum Ergo","Ergo ungültige Werte Leistung","Ergo ungültige Ergodauer","Ergo ungültige Werte","Ergo unplausible Angaben","MNH fehlende Werte","VALID Datum MNH","MNH ungültige Werte","MNH unplausible Angaben","MNH zu viele Angaben unbekannt","FT fehlende Werte","VALID Datum Feeling","FT ungültige Werte","FT unplausible Angaben","CRQ fehlende Werte","VALID Datum CRQ","CRQ ungültige Werte","CRQ unplausible Angaben","CRQ zu viele Angaben unbekannt","CONCAT Gehtest","CONCAT Ergo","CONCAT MNH","CONCAT FT","CONCAT CRQ","CONCAT auswertungsrelevant","CONCAT","Mängel insgesamt (evtl. Unterscheidung)"]
[null,null,null,null,null,null,"6.1.","FID",null,null,null,null,null,null,"6.2.",null,null,null,null,null,null,null,null,"6.3.",null,null,null,null,null,null,"6.4.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6.5.",null,null,null,"6.6.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x",null,null,"6.1.","FID",null,null,null,null,null,null,"6.2.",null,null,null,null,null,null,null,null,"6.3.",null,null,null,null,null,null,"6.4.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6.5.",null,null,null,"6.6.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"err6101","err6102","err6103","err6104-err6104","err6106-err6107","err6108","err6109","err6110","err6111","err6200","err6201","err6202","err6203","err6204","err6205","err6300","err6301","err6302","err6303","err6304","err6305","err6400","err6401","err6402","err6403","err6404","err6500","err6501","err6502","err6503","err6600","err6601","err6602","err6603","err6604"]
[null,null,null,null,null,null,"V01",null,"V02","V03","V04","V05","V06","V07","V00","V01","V02","V03","V04","V05","V06","V07","V08","V00","V01","V02","V03","V04","V05","V06","V00","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20","V21","V22","V23","V24","V25","V26","V27","V28","V29","V00","V01","V02","V03","V00","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20","V21","V22","x",null,null,"V01",null,"V02","V03","V04","V05","V06","V07","V00","V01","V02","V03","V04","V05","V06","V07","V08","V00","V01","V02","V03","V04","V05","V06","V00","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20","V21","V22","V23","V24","V25","V26","V27","V28","V29","V00","V01","V02","V03","V00","V01","V02","V03","V04","V05","V06","V07","V08","V09","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20","V21","V22"]
[null,null,"Filter   ►"]
[{"$f":"CONCATENATE(H6,L6)","v":""},null,{"$f":"IF(COUNTIF(CM6:FO6,0)=81,\"\",IF(FP6=2,\"Duplikat \"&HP6,IF(FP6=1,\"Drop-Out\"&IF(FZ6=\"\",\"\",\" (mangelhaft)\"),IF(HP6<>\"\",HP6,\"\"))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]

{"sheet":"MB","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"ZU","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"M2","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"M3","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}