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

{"sheet":"Eingabefeld","index":0,"n_rows":37,"n_cols":19,"rows_kept":37,"cut":false,"hidden":false,"merged":[[22,12,24,14],[3,1,3,4],[3,6,3,8],[3,10,3,12],[3,14,3,16],[9,0,16,6],[9,8,16,12]]}
[]
["Zutrittskontrolle für Betriebe nach aktueller Rechtslage (Stand 21.01.2022)"]
[]
[null,"Test",null,null,null,null,"Impfung 1",null,null,null,"Impfung 2",null,null,null,"Impfung 3",null,null,null,"Genesung"]
[null,"Testtyp",null,"Testdatum","Testuhrzeit",null,"Impfstoff",null,"Datum",null,"Impfstoff",null,"Datum",null,"Impfstoff",null,"Datum",null,"Datum positiver Test"]
[]
[]
[]
[]
[{"$f":"Tabelle1!A7","v":"unzulässig"},null,null,null,null,null,null,null,{"$f":"Tabelle1!L7","v":" "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Zur Benutzung des Löschbuttons müssen Makros in Excel aktiviert sein. Wenden Sie sich hierzu ggf. an Ihre IT."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Stand: 21. Januar 2022"]
[]
["Bitte kontaktieren Sie uns unter tom.stiebert@dwf.law, um stets die aktuellste Version dieses Tools unter Berücksichtigung der aktuellen Rechtslage zu erhalten oder bei technischen Fragen zum Tool."]

{"sheet":"Tabelle1","index":1,"n_rows":7,"n_cols":27,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,17,0,19],[6,0,13,9],[6,11,13,15],[0,1,0,4],[0,9,0,11],[0,13,0,15]]}
[null,"Test",null,null,null,null,null,null,null,"Impfung 1",null,null,null,"Impfung 2",null,null,null,"Impfung 3",null,null,null,null,"Genesung"]
[null,"Testtyp",null,"Testdatum","Testuhrzeit",null,"Zeitdifferenz","Ergebnis Test",null,"Impfstoff",null,"Datum",null,"Impfstoff",null,"Datum",null,"Impfstoff",null,"Datum","Ergebnis Impfung",null,"Datum positiver Test",null,"Ergebnis Genesung",null,"Ergebnis Genesung und Test"]
[null,{"$f":"Eingabefeld!B6","v":0},null,{"$f":"Eingabefeld!D6","v":"00:00:00"},{"$f":"Eingabefeld!E6","v":"00:00:00"},{"$f":"NOW()-TODAY()","v":"19:04:09.550"},{"$f":"((F3-E3)*24)+(_xlfn.DAYS(TODAY(),D3)*24)","v":1070395.0693194442},{"$f":"IF(AND(B3=\"PCR-Test\",G3<48),\"GRÜN\",IF(AND(B3=\"Bürgertest\",G3<24),\"GRÜN\",IF(AND(B3=\"Betriebstest (beaufsichtigt)\",G3<24),\"GRÜN\",\"ROT\")))","v":"ROT"},null,{"$f":"Eingabefeld!G6","v":0},null,{"$f":"Eingabefeld!I6","v":"00:00:00"},null,{"$f":"Eingabefeld!K6","v":0},null,{"$f":"Eingabefeld!M6","v":"00:00:00"},null,{"$f":"Eingabefeld!O6","v":0},null,{"$f":"Eingabefeld!Q6","v":"00:00:00"},{"$f":"IF(AND(N3=0,R3=0),\"ROT\",IF(AND(R3=0,(_xlfn.DAYS(TODAY(),P3)<=14)),\"ROT\",\"GRÜN\"))","v":"ROT"},null,{"$f":"Eingabefeld!S6","v":"00:00:00"},{"$f":"_xlfn.DAYS(TODAY(),W3)","v":44599},{"$f":"IF(AND(X3>28,X3<=90),\"GRÜN\",\"ROT\")","v":"ROT"},{"$f":"W3-L3","v":0},{"$f":"IF(L3=0,\"ROT\",IF(W3=0,\"ROT\",IF(Z3<0,\"GRÜN\",IF(_xlfn.DAYS(TODAY(),W3)>28,\"GRÜN\",\"ROT\"))))","v":"ROT"}]
[]
[]
[]
[{"$f":"IF(U3=\"GRÜN\",\"unbegrenzt\",IF(AA3=\"GRÜN\",\"unbegrenzt\",IF(Y3=\"GRÜN\",\"begrenzt bis\",IF(H3=\"GRÜN\",\"begrenzt bis\",\"unzulässig\"))))","v":"unzulässig"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A7=\"unbegrenzt\",\" \",IF(A7=\"unzulässig\",\" \",IF(Y3=\"GRÜN\",W3+90,\"heute\")))","v":" "}]

{"sheet":"Tabelle2","index":2,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
["Bürgertest",null,"Comirnaty (BioNTech)"]
["PCR-Test",null,"Spikevax (Moderna)"]
["Betriebstest (beaufsichtigt)",null,"Vaxzevria (AstraZeneca)"]
[null,null,"Janssen (Johns & Johnson)"]