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

{"sheet":"Daten","index":0,"n_rows":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Muster für FF Einsätze"]
[]
["Datum","Start","Ende","Dauer Minuten","Mitarbeiter","Klient","Einsatzart"]
["2025-03-01","08:00:00","08:10:00",{"$f":"+C4-B4","v":"00:10:00"},"MA 1","KL 5","a1",null,null,null,"KL 1","a1"]
["2025-03-01","09:00:00","09:20:00",{"$f":"+C5-B5","v":"00:20:00"},"MA 2","KL 5","b5",null,null,null,"KL 1","b1"]
["2025-03-01","10:00:00","10:30:00","00:30:00","MA 3","KL 1","a1",null,null,null,"KL 2","FF-25"]
["2025-03-01","11:00:00","11:10:00","00:10:00","MA 1","KL 2","FF-25",null,null,null,"KL 2","b-zusatz"]
["2025-03-02","12:00:00","12:20:00","00:20:00","MA 2","KL 3","F3",null,null,null,"KL 3","F3"]
["2025-03-03","13:00:00","13:15:00","00:15:00","MA 3","KL 4","FF-12",null,null,null,"KL 3","HB"]
["2025-03-04","14:00:00","14:12:00","00:12:00","MA 1","KL 6","FFbc",null,null,null,"KL 4","FF-12"]
["2025-03-05","15:00:00","15:35:00","00:35:00","MA 2","KL 6","a1",null,null,null,"KL 4","FF-12"]
["2025-03-06","16:00:00","16:10:00","00:10:00","MA 3","KL 6","a1",null,null,null,"KL 5","a1"]
["2025-03-06","10:00:00","10:20:00","00:20:00","MA 1","KL 6","b45",null,null,null,"KL 5","b5"]
["2025-03-06","11:00:00","11:40:00","00:40:00","MA 2","KL 1","b1",null,null,null,"KL 6","FFbc"]
["2025-03-06","12:00:00","12:10:00","00:10:00","MA 3","KL 2","b-zusatz",null,null,null,"KL 6","a1"]
["2025-03-07","13:00:00","13:10:00","00:10:00","MA 2","KL 3","HB",null,null,null,"KL 6","a1"]
["2025-03-07","17:00:00","17:10:00","00:10:00","MA 2","KL 4","FF-12",null,null,null,"KL 6","b45"]

{"sheet":"Auswertung","index":1,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Auswertung"]
[]
[" Minuten"]
["Klient","Einsatzart","Ergebnis"]
["KL 2","b-zusatz",6.9444444444444198E-3]
[null,"FF-25",6.9444444444448084E-3]
["KL 2 Ergebnis",null,1.3888888888889228E-2]
[]
["KL 4","FF-12",1.0416666666666408E-2]
[null,"FF-12",6.9444444444444198E-3]
["KL 4 Ergebnis",null,1.7361111111110827E-2]
[]
["KL 6","a1",2.430555555555558E-2]
[null,"a1",6.9444444444441977E-3]
[null,"b45",1.3888888888888562E-2]
[null,"FFbc",8.3333333333336368E-3]
["KL 6 Ergebnis",null,5.3472222222221977E-2]
[]
["Gesamtergebnis",null,8.4722222222222032E-2]

{"sheet":"Auswertung (2)","index":2,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Auswertung",null,null,null,"aus Daten:"]
[null,null,null,null,"KL 2, KL 4 und KL 6 haben Einsatzarten mit FF beginnend"]
[" Minuten",null,null,null,"KL 1, KL 3 und KL 5 haben keine Einsatzart mit FF beginnend"]
["Klient","Einsatzart","Ergebnis"]
["KL 1","a1",2.0833333333333332E-2,null,"Ziel / Wunsch:"]
[null,"b1",2.7777777777777776E-2,null,"ich sehe  KL 2, KL 4 und KL 6  (da sie Einsatzarten mit FF beginnend haben) und auch alle anderen Einsatzarten zusätzlich: b-zusatz,  a1, b45)"]
["KL 1 Ergebnis",null,4.8611111111111105E-2,null,"KL 1, KL 3 und KL 5 will ich nicht sehen"]
[null,null,null,null,"Die zu prüfende Datei enthält ca. 10.000 Zeilen, die Fehlerquote liegt unter 1%"]
["KL 2","b-zusatz",6.9444444444444441E-3]
[null,"FF-25",6.9444444444444441E-3,null,"Ist dieser Wunsch möglich?"]
["KL 2 Ergebnis",null,1.3888888888888888E-2,null,"Heute lasse ich mir alle Klienten mit FF beginnend anzeigen und die Namen ausdrucken. Im zweiten Schritt rufe ich diese Klienten auf und prüfe, was dort gebucht wurde."]
[]
["KL 3","F3",1.3888888888888888E-2]
[null,"HB",6.9444444444444441E-3]
["KL 3 Ergebnis",null,2.0833333333333332E-2]
[]
["KL 4","FF-12",1.7361111111111112E-2]
["KL 4 Ergebnis",null,1.7361111111111112E-2]
[]
["KL 5","a1",6.9444444444444441E-3]
[null,"b5",1.3888888888888888E-2]
["KL 5 Ergebnis",null,2.0833333333333332E-2]
[]
["KL 6","a1",3.125E-2]
[null,"b45",1.3888888888888888E-2]
[null,"FFbc",8.3333333333333332E-3]
["KL 6 Ergebnis",null,5.347222222222222E-2]
[]
["Gesamtergebnis",null,0.17500000000000002]