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

{"sheet":"Tabelle1","index":0,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,12,2,12],[36,3,36,4],[37,3,37,4],[38,3,38,4],[39,3,39,4],[40,3,40,4],[1,0,2,0],[1,1,2,1],[1,3,2,3],[1,4,2,4]]}
[]
["Nr.","Name","Hilfsspalte ","m/w","DG","SGT-A","SGT-B","SGT-C","SGT-D","SGT Gesamt",null,null,"Befreites Personal"]
[null,null,"befreit",null,null,"Zeit (s)","Zeit (s)","Zeit (s)","Zeit (s)","Zeit (s)"]
[1,null,{"$f":"Farbe","v":15},null,null,45,45,null,null,{"$f":"SUM(F4:I4)","v":90},{"$f":"AnzahlZellenMitFarbe(F4:I4,D39)","v":0},{"$f":"Farbe","v":35},{"$f":"AnzahlZellenMitFarbe(F4:I4,D37)","v":1}]
[2,null,{"$f":"Farbe","v":37},null,null,null,null,null,null,{"$f":"SUM(F5:I5)","v":0}]
[3,null,15,null,null,null,null,null,null,0]
[4,null,15,null,null,null,null,null,null,0]
[5,null,15,null,null,null,null,null,null,0]
[6,null,15,null,null,null,null,null,null,0]
[7,null,15,null,null,null,null,null,null,0]
[8,null,15,null,null,null,null,null,null,0]
[9,null,15,null,null,null,null,null,null,0]
[10,null,15,null,null,null,null,null,null,0]
[11,null,15,null,null,null,null,null,null,0]
[12,null,37,null,null,null,null,null,null,0]
[13,null,15,null,null,null,null,null,null,0]
[14,null,15,null,null,null,null,null,null,0]
[15,null,37,null,null,null,null,null,null,0]
[16,null,15,null,null,null,null,null,null,0]
[17,null,15,null,null,null,null,null,null,0]
[18,null,15,null,null,null,null,null,null,0]
[19,null,15,null,null,null,null,null,null,0]
[20,null,37,null,null,null,null,null,null,0]
[21,null,15,null,null,null,null,null,null,0]
[22,null,15,null,null,null,null,null,null,0]
[23,null,37,null,null,null,null,null,null,0]
[24,null,37,null,null,null,null,null,null,0]
[25,null,37,null,null,null,null,null,null,0]
[26,null,15,null,null,null,null,null,null,0]
[27,null,15,null,null,null,null,null,null,0]
[28,null,15,null,null,null,null,null,null,0]
[29,null,15,null,null,null,null,null,null,0]
[30,null,37,null,null,null,null,null,null,0]
[31,null,15,null,null,null,null,null,null,0]
[32,null,15,null,null,null,null,null,null,0]
[null,null,null,null,null,"SGT-A","SGT-B","SGT-C","SGT-D","SGT Gesamt ",null,null,"Farbcodes:"]
[null,null,null,"erfüllt",null,{"$f":"COUNTIF(F$4:F$35,\"<=55\")","v":1},{"$f":"COUNTIF(G$4:G$35,\"<=30\")","v":0},{"$f":"COUNTIF(H$4:H$35,\"<=75\")","v":0},{"$f":"COUNTIF(I$4:I$35,\"<=20\")","v":0},null,"erfüllt",null,{"$f":"Farbe","v":35}]
[null,null,null,"gelb",null,{"$f":"COUNTIFS(F$4:F$35,\">55\",F$4:F$35,\"<70\")","v":0},{"$f":"COUNTIFS(G$4:G$35,\">30\",G$4:G$35,\"<50\")","v":1},{"$f":"COUNTIFS(H$4:H$35,\">75\",H$4:H$35,\"<100\")","v":0},{"$f":"COUNTIFS(I$4:I$35,\">20\",I$4:I$35,\"<50\")","v":0},null,"gelb",null,{"$f":"Farbe","v":36}]
[null,null,null,"rot",null,{"$f":"COUNTIF(F$4:F$35,\">=70\")","v":0},{"$f":"COUNTIF(G$4:G$35,\">=50\")","v":0},{"$f":"COUNTIF(H$4:H$35,\">=100\")","v":0},{"$f":"COUNTIF(I$4:I$35,\">=50\")","v":0},null,"rot",null,38]
[null,null,null,"nicht abgelegt",null,{"$f":"COUNTIF(F4:F35,\"\")","v":31},{"$f":"COUNTIF(G4:G35,\"\")","v":31},32,32,0,"nicht abgelegt",{"$f":"J40-L41","v":-8},0]
[null,null,null,"gesamt",null,{"$f":"SUM(F37:F40)","v":32},{"$f":"SUM(G37:G40)","v":32},32,32,{"$f":"SUM(J37:J40)","v":0},"befreit",{"$f":"COUNTIF(C4:C35,37)","v":8},37]
[null,null,null,null,null,null,null,null,null,null,"Gesamt",{"$f":"SUM(L37:L41)","v":0}]