{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Basic_Data","Contacts","Risk_Analysis","Measurements","Help","Settings"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Basic_Data","index":0,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Quarantine Calculator"]
[null,null,null,"SARS-CoV-2",null,null,null,null,null,"Note and disclaimer"]
[null,null,null,"Advanced risk management",null,null,"Author:"]
[null,null,null,null,null,null,"Dr.med. Andreas Paaßen",null,null,"These recommendations are based on probability"]
[null,null,null,"Version 2.3",null,null,"Chemical Park Marl",null,null,"calculations and represent an optimum between effort"]
[null,null,null,null,null,null,null,null,null,"and risk.  "]
[]
[null,null,"Basic data source case"]
[null,"Have COVID-symptoms occured?",null,null,"Date of action:",null," Day of initiation of measures",null,null,"It can never be ruled out that, despite the application"]
[null,null,null,null,null,null,null,null,null,"of the recommendations, contagion can occur with"]
[null,"Date of symptom start:",null,null,null,null,null,null,null,"low probabilities."]
[]
[null,"Date testing:",null,null,null,null,null,null,null,"The advanced risk management and the resulting measures"]
[null,null,null,null,"  ===>",null,null,null,null,"are professionally bases but non-binding recommondations."]
[null,"Date notification of test result:"]
[null,null,null,null,null,null,null,null,null,"As soon as a health authority initiates official measures "]
[null," Suspected contagion date:",null,null,null,null,null,null,null,"such as isolation or contact quarantine, the health"]
[null,null,null,null,null,null,null,null,null,"authority decides on implementation and design."]

{"sheet":"Contacts","index":1,"n_rows":34,"n_cols":44,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Relation","Names",-3,-2,-1,0,1,2,3,4,5,6,7,8,9,null,{"$f":"IF($C$3=$J$2,SUM($K$3:$S$3),IF($C$3=$K$2,SUM($L$3:$S$3),IF($C$3=$L$2,SUM($M$3:$S$3),IF($C$3=$M$2,SUM($N$3:$S$3),IF($C$3=$N$2,SUM($O$3:$S$3),IF($C$3=$O$2,SUM($P$3:$S$3),SUM($Q$3:$S$3)))))))","v":2.5000000000000001E-3},"Eff Isolation",null,null,null,null,null,null,null,"H","M","G","U",null,null,null,null,null,null,"Transmissions-",null,null,null,"Cumulative"]
[null,null,{"$f":"IF($C$6>DATEVALUE(\"01.01.1900\"),$C$6,IF(AND($C$12>DATEVALUE(\"01.01.1900\"),OR($C$4=\"Nein\",$C$4=\"Unbekannt\")),$C$12+5,IF($C$8>DATEVALUE(\"01.01.1900\"),$C$8,IF($C$10>DATEVALUE(\"01.01.1900\"),$C$10-1,IF($C$12>DATEVALUE(\"01.01.1900\"),$C$12+5,$C$13)))))","v":"1900-01-01"},null,null,"Step A: source case",{"$f":"IF($C$6>DATEVALUE(\"01.01.1900\"),$C$6-3,IF(AND($C$12>DATEVALUE(\"01.01.1900\"),OR($C$4=\"Nein\",$C$4=\"Unbekannt\")),$C$12+2,IF($C$8>DATEVALUE(\"01.01.1900\"),$C$8-3,IF($C$10>DATEVALUE(\"01.01.1900\"),$C$10-4,IF($C$12>DATEVALUE(\"01.01.1900\"),$C$12+2,$C$13)))))","v":"1900-01-01"},{"$f":"$G$2+1","v":"1900-01-02"},{"$f":"$G$2+2","v":"1900-01-03"},{"$f":"$G$2+3","v":"1900-01-04"},{"$f":"$G$2+4","v":"1900-01-05"},{"$f":"$G$2+5","v":"1900-01-06"},{"$f":"$G$2+6","v":"1900-01-07"},{"$f":"$G$2+7","v":"1900-01-08"},{"$f":"$G$2+8","v":"1900-01-09"},{"$f":"$G$2+9","v":"1900-01-10"},{"$f":"$G$2+10","v":"1900-01-11"},{"$f":"$G$2+11","v":"1900-01-12"},{"$f":"$G$2+12","v":"1900-01-13"},null,{"$f":"IF($C$3=$J$2,SUM($H$3:$S$3),IF($C$3=$K$2,SUM($I$3:$S$3),IF($C$3=$L$2,SUM($J$3:$S$3),IF($C$3=$M$2,SUM($L$3:$S$3),IF($C$3=$N$2,SUM($M$3:$S$3),IF($C$3=$O$2,SUM($N$3:$S$3),SUM($O$3:$S$3)))))))","v":1.4578579999999999E-2},"Eff Quarantäne",null,null,null,null,null,null,null,{"$f":"Settings!G9","v":0.2},{"$f":"Settings!G11","v":0.1},{"$f":"Settings!G13","v":0.05},{"$f":"Settings!G15","v":0.01},null,null,null,null,null,null,"bedingungen",null,null,null,"risk of"]
[null,null,{"$f":"Basic_Data!F10","v":"00:00:00"},null,null,"Step B: direct contacts",7.1433650000000001E-2,0.13197249999999999,0.180176,0.19462299999999999,0.16947699999999999,0.118995,6.6822649999999997E-2,2.964495E-2,1.0239689999999999E-2,1.8388899999999999E-3,2.5000000000000001E-3,0,0,null,{"$f":"IF($C$3=$J$2,1,IF($C$3=$K$2,SUM($G$3:$S$3),IF($C$3=$L$2,SUM($H$3:$S$3),IF($C$3=$M$2,SUM($I$3:$S$3),IF($C$3=$N$2,SUM($J$3:$S$3),IF($C$3=$O$2,SUM($K$3:$S$3),SUM($L$3:$S$3)))))))","v":0.23004118000000001},"Eff Erweitert",null,null,null,null,null,null,null,"G","H","I","J","K","L","M","N","O","P",null,null,null,null,"Infection"]
[null,null,{"$f":"IF(Basic_Data!C10=\"Yes\",\"Ja\",IF(Basic_Data!C10=\"No\",\"Nein\",IF(Basic_Data!C10=\"Unknown\",\"Unbekannt\",Basic_Data!C10)))","v":0},null,"Nr. 1:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($G$4=\"H\",$H$4=\"H\",$I$4=\"H\",$J$4=\"H\",$K$4=\"H\",$L$4=\"H\",$M$4=\"H\",$N$4=\"H\",$O$4=\"H\",$P$4=\"H\",$Q$4=\"H\",$R$4=\"H\",$S$4=\"H\"),\"H\",IF(OR($G$4=\"M\",$H$4=\"M\",$I$4=\"M\",$J$4=\"M\",$K$4=\"M\",$L$4=\"M\",$M$4=\"M\",$N$4=\"M\",$O$4=\"M\",$P$4=\"M\",$Q$4=\"M\",$R$4=\"M\",$S$4=\"M\"),\"M\",IF(OR($G$4=\"G\",$H$4=\"G\",$I$4=\"G\",$J$4=\"G\",$K$4=\"G\",$L$4=\"G\",$M$4=\"G\",$N$4=\"G\",$O$4=\"G\",$P$4=\"G\",$Q$4=\"G\",$R$4=\"G\",$S$4=\"G\",$G$4=\"L\",$H$4=\"L\",$I$4=\"L\",$J$4=\"L\",$K$4=\"L\",$L$4=\"L\",$M$4=\"L\",$N$4=\"L\",$O$4=\"L\",$P$4=\"L\",$Q$4=\"L\",$R$4=\"L\",$S$4=\"L\"),\"G\",\"\")))","v":""},{"$f":"IF($G$5=\"i\",$G$2,IF($H$5=\"i\",$H$2,IF($I$5=\"i\",$I$2,IF($J$5=\"i\",$J$2,IF($K$5=\"i\",$K$2,IF($L$5=\"i\",$L$2,IF($M$5=\"i\",$M$2,IF($N$5=\"i\",$N$2,IF($O$5=\"i\",$O$2,IF($P$5=\"i\",$P$2,IF($Q$5=\"i\",$Q$2,DATEVALUE(\"01.01.1900\"))))))))))))","v":"1900-01-01"},{"$f":"IF(NOT(ISBLANK($Q$4)),$Q$2,IF(NOT(ISBLANK($P$4)),$P$2,IF(NOT(ISBLANK($O$4)),$O$2,IF(NOT(ISBLANK($N$4)),$N$2,IF(NOT(ISBLANK($M$4)),$M$2,IF(NOT(ISBLANK($L$4)),$L$2,IF(NOT(ISBLANK($K$4)),$K$2,IF(NOT(ISBLANK($J$4)),$J$2,IF(NOT(ISBLANK($I$4)),$I$2,IF(NOT(ISBLANK($H$4)),$H$2,IF(NOT(ISBLANK($G$4)),$G$2,DATEVALUE(\"01.01.1900\"))))))))))))+14","v":"1900-01-15"},{"$f":"IF(G4=\"G\",$G$2,IF(H4=\"G\",$H$2,IF(I4=\"G\",$I$2,IF(J4=\"G\",$J$2,IF(K4=\"G\",$K$2,IF(L4=\"G\",$L$2,IF(M4=\"G\",$M$2,IF(N4=\"G\",$N$2,IF(O4=\"G\",$O$2,IF(P4=\"G\",$P$2,IF(Q4=\"G\",$Q$2,IF(R4=\"G\",$R$2,IF(S4=\"G\",$S$2,DATEVALUE(\"01.01.1900\"))))))))))))))+3","v":"1900-01-04"},null,null,null,null,null,{"$f":"IF(G4=\"H\",$G$3*$AD$2,IF(G4=\"M\",$G$3*$AE$2,IF(OR(G4=\"G\",G4=\"L\"),$G$3*$AF$2,0)))","v":0},{"$f":"IF(H4=\"H\",$H$3*$AD$2,IF(H4=\"M\",$H$3*$AE$2,IF(OR(H4=\"G\",H4=\"L\"),$H$3*$AF$2,0)))","v":0},{"$f":"IF(I4=\"H\",$I$3*$AD$2,IF(I4=\"M\",$I$3*$AE$2,IF(OR(I4=\"G\",I4=\"L\"),$I$3*$AF$2,0)))","v":0},{"$f":"IF(J4=\"H\",$J$3*$AD$2,IF(J4=\"M\",$J$3*$AE$2,IF(OR(J4=\"G\",J4=\"L\"),$J$3*$AF$2,0)))","v":0},{"$f":"IF(K4=\"H\",$K$3*$AD$2,IF(K4=\"M\",$K$3*$AE$2,IF(OR(K4=\"G\",K4=\"L\"),$K$3*$AF$2,0)))","v":0},{"$f":"IF(L4=\"H\",$L$3*$AD$2,IF(L4=\"M\",$L$3*$AE$2,IF(OR(L4=\"G\",L4=\"L\"),$L$3*$AF$2,0)))","v":0},{"$f":"IF(M4=\"H\",$M$3*$AD$2,IF(M4=\"M\",$M$3*$AE$2,IF(OR(M4=\"G\",M4=\"L\"),$M$3*$AF$2,0)))","v":0},{"$f":"IF(N4=\"H\",$N$3*$AD$2,IF(N4=\"M\",$N$3*$AE$2,IF(OR(N4=\"G\",N4=\"L\"),$N$3*$AF$2,0)))","v":0},{"$f":"IF(O4=\"H\",$O$3*$AD$2,IF(O4=\"M\",$O$3*$AE$2,IF(OR(O4=\"G\",O4=\"L\"),$O$3*$AF$2,0)))","v":0},{"$f":"IF(P4=\"H\",$P$3*$AD$2,IF(P4=\"M\",$P$3*$AE$2,IF(OR(P4=\"G\",P4=\"L\"),$P$3*$AE$2,0)))","v":0},{"$f":"SUM(AD4:AM4)","v":0},{"$f":"AN4*Risk_Analysis!$T$1","v":0},null,null,{"$f":"AO4","v":0}]
[null,null,null,null,null,null,{"$f":"\" \"","v":" "},{"$f":"\" \"","v":" "},{"$f":"IF(OR($H$5=\"i\",NOT(ISBLANK($G$4))),\"i\",\" \")","v":" "},{"$f":"IF(OR($I$5=\"i\",NOT(ISBLANK($H$4))),\"i\",\" \")","v":" "},{"$f":"IF(OR($J$5=\"i\",NOT(ISBLANK($I$4))),\"i\",\" \")","v":" "},{"$f":"IF(OR($K$5=\"i\",NOT(ISBLANK($J$4))),\"i\",\" \")","v":" "},{"$f":"IF(OR($L$5=\"i\",NOT(ISBLANK($K$4))),\"i\",\" \")","v":" "},{"$f":"IF(OR($M$5=\"i\",NOT(ISBLANK($L$4))),\"i\",\" \")","v":" "},{"$f":"IF(OR($N$5=\"i\",NOT(ISBLANK($M$4))),\"i\",\" \")","v":" "},{"$f":"IF(OR($O$5=\"i\",NOT(ISBLANK($N$4))),\"i\",\" \")","v":" "},{"$f":"IF(OR($P$5=\"i\",NOT(ISBLANK($O$4))),\"i\",\" \")","v":" "},{"$f":"IF(OR($Q$5=\"i\",NOT(ISBLANK($P$4))),\"i\",\" \")","v":" "},{"$f":"IF(OR($R$5=\"i\",NOT(ISBLANK($Q$4))),\"i\",\" \")","v":" "}]
[null,null,{"$f":"IF(ISBLANK(Basic_Data!C12),DATEVALUE(\"01.01.1900\"),Basic_Data!C12)","v":"1900-01-01"},null,"Nr. 2:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($G$6=\"H\",$H$6=\"H\",$I$6=\"H\",$J$6=\"H\",$K$6=\"H\",$L$6=\"H\",$M$6=\"H\",$N$6=\"H\",$O$6=\"H\",$P$6=\"H\",$Q$6=\"H\",$R$6=\"H\",$S$6=\"H\"),\"H\",IF(OR($G$6=\"M\",$H$6=\"M\",$I$6=\"M\",$J$6=\"M\",$K$6=\"M\",$L$6=\"M\",$M$6=\"M\",$N$6=\"M\",$O$6=\"M\",$P$6=\"M\",$Q$6=\"M\",$R$6=\"M\",$S$6=\"M\"),\"M\",IF(OR($G$6=\"G\",$H$6=\"G\",$I$6=\"G\",$J$6=\"G\",$K$4=\"G\",$L$4=\"G\",$M$4=\"G\",$N$4=\"G\",$O$4=\"G\",$P$4=\"G\",$Q$4=\"G\",$R$4=\"G\",$S$4=\"G\",$G$4=\"L\",$H$4=\"L\",$I$4=\"L\",$J$4=\"L\",$K$4=\"L\",$L$4=\"L\",$M$4=\"L\",$N$4=\"L\",$O$4=\"L\",$P$4=\"L\",$Q$6=\"L\",$R$6=\"L\",$S$6=\"L\"),\"G\",\"\")))","v":""},{"$f":"IF($G$7=\"i\",$G$2,IF($H$7=\"i\",$H$2,IF($I$7=\"i\",$I$2,IF($J$7=\"i\",$J$2,IF($K$7=\"i\",$K$2,IF($L$7=\"i\",$L$2,IF($M$7=\"i\",$M$2,IF($N$7=\"i\",$N$2,IF($O$7=\"i\",$O$2,IF($P$7=\"i\",$P$2,IF($Q$7=\"i\",$Q$2,DATEVALUE(\"01.01.1900\"))))))))))))","v":"1900-01-01"},{"$f":"IF(NOT(ISBLANK($Q$6)),$Q$2,IF(NOT(ISBLANK($P$6)),$P$2,IF(NOT(ISBLANK($O$6)),$O$2,IF(NOT(ISBLANK($N$6)),$N$2,IF(NOT(ISBLANK($M$6)),$M$2,IF(NOT(ISBLANK($L$6)),$L$2,IF(NOT(ISBLANK($K$6)),$K$2,IF(NOT(ISBLANK($J$6)),$J$2,IF(NOT(ISBLANK($I$6)),$I$2,IF(NOT(ISBLANK($H$6)),$H$2,IF(NOT(ISBLANK($G$6)),$G$2,DATEVALUE(\"01.01.1900\"))))))))))))+14","v":"1900-01-15"},{"$f":"IF(G6=\"G\",$G$2,IF(H6=\"G\",$H$2,IF(I6=\"G\",$I$2,IF(J6=\"G\",$J$2,IF(K6=\"G\",$K$2,IF(L6=\"G\",$L$2,IF(M6=\"G\",$M$2,IF(N6=\"G\",$N$2,IF(O6=\"G\",$O$2,IF(P6=\"G\",$P$2,IF(Q6=\"G\",$Q$2,IF(R6=\"G\",$R$2,IF(S6=\"G\",$S$2,DATEVALUE(\"01.01.1900\"))))))))))))))+3","v":"1900-01-04"},null,null,null,null,null,{"$f":"IF(G6=\"H\",$G$3*$AD$2,IF(G6=\"M\",$G$3*$AE$2,IF(OR(G6=\"G\",G6=\"L\"),$G$3*$AF$2,0)))","v":0},{"$f":"IF(H6=\"H\",$H$3*$AD$2,IF(H6=\"M\",$H$3*$AE$2,IF(OR(H6=\"G\",H6=\"L\"),$H$3*$AF$2,0)))","v":0},{"$f":"IF(I6=\"H\",$I$3*$AD$2,IF(I6=\"M\",$I$3*$AE$2,IF(OR(I6=\"G\",I6=\"L\"),$I$3*$AF$2,0)))","v":0},{"$f":"IF(J6=\"H\",$J$3*$AD$2,IF(J6=\"M\",$J$3*$AE$2,IF(OR(J6=\"G\",J6=\"L\"),$J$3*$AF$2,0)))","v":0},{"$f":"IF(K6=\"H\",$K$3*$AD$2,IF(K6=\"M\",$K$3*$AE$2,IF(OR(K6=\"G\",K6=\"L\"),$K$3*$AF$2,0)))","v":0},{"$f":"IF(L6=\"H\",$L$3*$AD$2,IF(L6=\"M\",$L$3*$AE$2,IF(OR(L6=\"G\",L6=\"L\"),$L$3*$AF$2,0)))","v":0},{"$f":"IF(M6=\"H\",$M$3*$AD$2,IF(M6=\"M\",$M$3*$AE$2,IF(OR(M6=\"G\",M6=\"L\"),$M$3*$AF$2,0)))","v":0},{"$f":"IF(N6=\"H\",$N$3*$AD$2,IF(N6=\"M\",$N$3*$AE$2,IF(OR(N6=\"G\",N6=\"L\"),$N$3*$AF$2,0)))","v":0},{"$f":"IF(O6=\"H\",$O$3*$AD$2,IF(O6=\"M\",$O$3*$AE$2,IF(OR(O6=\"G\",O6=\"L\"),$O$3*$AF$2,0)))","v":0},{"$f":"IF(P6=\"H\",$P$3*$AD$2,IF(P6=\"M\",$P$3*$AE$2,IF(OR(P6=\"G\",P6=\"L\"),$P$3*$AE$2,0)))","v":0},{"$f":"SUM(AD6:AM6)","v":0},{"$f":"AN6*Risk_Analysis!$T$1","v":0},null,null,{"$f":"AO6","v":0}]
[null,null,null,null,null,null,{"$f":"\" \"","v":" "},{"$f":"\" \"","v":" "},{"$f":"IF(OR($H$7=\"i\",NOT(ISBLANK($G$6))),\"i\",\" \")","v":" "},{"$f":"IF(OR($I$7=\"i\",NOT(ISBLANK($H$6))),\"i\",\" \")","v":" "},{"$f":"IF(OR($J$7=\"i\",NOT(ISBLANK($I$6))),\"i\",\" \")","v":" "},{"$f":"IF(OR($K$7=\"i\",NOT(ISBLANK($J$6))),\"i\",\" \")","v":" "},{"$f":"IF(OR($L$7=\"i\",NOT(ISBLANK($K$6))),\"i\",\" \")","v":" "},{"$f":"IF(OR($M$7=\"i\",NOT(ISBLANK($L$6))),\"i\",\" \")","v":" "},{"$f":"IF(OR($N$7=\"i\",NOT(ISBLANK($M$6))),\"i\",\" \")","v":" "},{"$f":"IF(OR($O$7=\"i\",NOT(ISBLANK($N$6))),\"i\",\" \")","v":" "},{"$f":"IF(OR($P$7=\"i\",NOT(ISBLANK($O$6))),\"i\",\" \")","v":" "},{"$f":"IF(OR($Q$7=\"i\",NOT(ISBLANK($P$6))),\"i\",\" \")","v":" "},{"$f":"IF(OR($R$7=\"i\",NOT(ISBLANK($Q$6))),\"i\",\" \")","v":" "}]
[null,null,{"$f":"IF(ISBLANK(Basic_Data!C14),DATEVALUE(\"01.01.1900\"),Basic_Data!C14)","v":"1900-01-01"},null,"Nr. 3:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($G$8=\"H\",$H$8=\"H\",$I$8=\"H\",$J$8=\"H\",$K$8=\"H\",$L$8=\"H\",$M$8=\"H\",$N$8=\"H\",$O$8=\"H\",$P$8=\"H\",$Q$8=\"H\",$R$8=\"H\",$S$8=\"H\"),\"H\",IF(OR($G$8=\"M\",$H$8=\"M\",$I$8=\"M\",$J$8=\"M\",$K$8=\"M\",$L$8=\"M\",$M$8=\"M\",$N$8=\"M\",$O$8=\"M\",$P$8=\"M\",$Q$8=\"M\",$R$8=\"M\",$S$8=\"M\"),\"M\",IF(OR($G$8=\"G\",$H$8=\"G\",$I$8=\"G\",$J$8=\"G\",$K$4=\"G\",$L$4=\"G\",$M$4=\"G\",$N$4=\"G\",$O$4=\"G\",$P$4=\"G\",$Q$4=\"G\",$R$4=\"G\",$S$4=\"G\",$G$4=\"L\",$H$4=\"L\",$I$4=\"L\",$J$4=\"L\",$K$4=\"L\",$L$4=\"L\",$M$4=\"L\",$N$4=\"L\",$O$4=\"L\",$P$4=\"L\",$Q$8=\"L\",$R$8=\"L\",$S$8=\"L\"),\"G\",\"\")))","v":""},{"$f":"IF($G$9=\"i\",$G$2,IF($H$9=\"i\",$H$2,IF($I$9=\"i\",$I$2,IF($J$9=\"i\",$J$2,IF($K$9=\"i\",$K$2,IF($L$9=\"i\",$L$2,IF($M$9=\"i\",$M$2,IF($N$9=\"i\",$N$2,IF($O$9=\"i\",$O$2,IF($P$9=\"i\",$P$2,IF($Q$9=\"i\",$Q$2,DATEVALUE(\"01.01.1900\"))))))))))))","v":"1900-01-01"},{"$f":"IF(NOT(ISBLANK($Q$8)),$Q$2,IF(NOT(ISBLANK($P$8)),$P$2,IF(NOT(ISBLANK($O$8)),$O$2,IF(NOT(ISBLANK($N$8)),$N$2,IF(NOT(ISBLANK($M$8)),$M$2,IF(NOT(ISBLANK($L$8)),$L$2,IF(NOT(ISBLANK($K$8)),$K$2,IF(NOT(ISBLANK($J$8)),$J$2,IF(NOT(ISBLANK($I$8)),$I$2,IF(NOT(ISBLANK($H$8)),$H$2,IF(NOT(ISBLANK($G$8)),$G$2,DATEVALUE(\"01.01.1900\"))))))))))))+14","v":"1900-01-15"},{"$f":"IF(G8=\"G\",$G$2,IF(H8=\"G\",$H$2,IF(I8=\"G\",$I$2,IF(J8=\"G\",$J$2,IF(K8=\"G\",$K$2,IF(L8=\"G\",$L$2,IF(M8=\"G\",$M$2,IF(N8=\"G\",$N$2,IF(O8=\"G\",$O$2,IF(P8=\"G\",$P$2,IF(Q8=\"G\",$Q$2,IF(R8=\"G\",$R$2,IF(S8=\"G\",$S$2,DATEVALUE(\"01.01.1900\"))))))))))))))+3","v":"1900-01-04"},null,null,null,null,null,{"$f":"IF(G8=\"H\",$G$3*$AD$2,IF(G8=\"M\",$G$3*$AE$2,IF(OR(G8=\"G\",G8=\"L\"),$G$3*$AF$2,0)))","v":0},{"$f":"IF(H8=\"H\",$H$3*$AD$2,IF(H8=\"M\",$H$3*$AE$2,IF(OR(H8=\"G\",H8=\"L\"),$H$3*$AF$2,0)))","v":0},{"$f":"IF(I8=\"H\",$I$3*$AD$2,IF(I8=\"M\",$I$3*$AE$2,IF(OR(I8=\"G\",I8=\"L\"),$I$3*$AF$2,0)))","v":0},{"$f":"IF(J8=\"H\",$J$3*$AD$2,IF(J8=\"M\",$J$3*$AE$2,IF(OR(J8=\"G\",J8=\"L\"),$J$3*$AF$2,0)))","v":0},{"$f":"IF(K8=\"H\",$K$3*$AD$2,IF(K8=\"M\",$K$3*$AE$2,IF(OR(K8=\"G\",K8=\"L\"),$K$3*$AF$2,0)))","v":0},{"$f":"IF(L8=\"H\",$L$3*$AD$2,IF(L8=\"M\",$L$3*$AE$2,IF(OR(L8=\"G\",L8=\"L\"),$L$3*$AF$2,0)))","v":0},{"$f":"IF(M8=\"H\",$M$3*$AD$2,IF(M8=\"M\",$M$3*$AE$2,IF(OR(M8=\"G\",M8=\"L\"),$M$3*$AF$2,0)))","v":0},{"$f":"IF(N8=\"H\",$N$3*$AD$2,IF(N8=\"M\",$N$3*$AE$2,IF(OR(N8=\"G\",N8=\"L\"),$N$3*$AF$2,0)))","v":0},{"$f":"IF(O8=\"H\",$O$3*$AD$2,IF(O8=\"M\",$O$3*$AE$2,IF(OR(O8=\"G\",O8=\"L\"),$O$3*$AF$2,0)))","v":0},{"$f":"IF(P8=\"H\",$P$3*$AD$2,IF(P8=\"M\",$P$3*$AE$2,IF(OR(P8=\"G\",P8=\"L\"),$P$3*$AE$2,0)))","v":0},{"$f":"SUM(AD8:AM8)","v":0},{"$f":"AN8*Risk_Analysis!$T$1","v":0},null,null,{"$f":"AO8","v":0}]
[null,null,null,null,null,null,{"$f":"\" \"","v":" "},{"$f":"\" \"","v":" "},{"$f":"IF(OR($H$9=\"i\",NOT(ISBLANK($G$8))),\"i\",\" \")","v":" "},{"$f":"IF(OR($I$9=\"i\",NOT(ISBLANK($H$8))),\"i\",\" \")","v":" "},{"$f":"IF(OR($J$9=\"i\",NOT(ISBLANK($I$8))),\"i\",\" \")","v":" "},{"$f":"IF(OR($K$9=\"i\",NOT(ISBLANK($J$8))),\"i\",\" \")","v":" "},{"$f":"IF(OR($L$9=\"i\",NOT(ISBLANK($K$8))),\"i\",\" \")","v":" "},{"$f":"IF(OR($M$9=\"i\",NOT(ISBLANK($L$8))),\"i\",\" \")","v":" "},{"$f":"IF(OR($N$9=\"i\",NOT(ISBLANK($M$8))),\"i\",\" \")","v":" "},{"$f":"IF(OR($O$9=\"i\",NOT(ISBLANK($N$8))),\"i\",\" \")","v":" "},{"$f":"IF(OR($P$9=\"i\",NOT(ISBLANK($O$8))),\"i\",\" \")","v":" "},{"$f":"IF(OR($Q$9=\"i\",NOT(ISBLANK($P$8))),\"i\",\" \")","v":" "},{"$f":"IF(OR($R$9=\"i\",NOT(ISBLANK($Q$8))),\"i\",\" \")","v":" "}]
[null,null,{"$f":"IF(ISBLANK(Basic_Data!C16),DATEVALUE(\"01.01.1900\"),Basic_Data!C16)","v":"1900-01-01"},null,"Nr. 4:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($G$10=\"H\",$H$10=\"H\",$I$10=\"H\",$J$10=\"H\",$K$10=\"H\",$L$10=\"H\",$M$10=\"H\",$N$10=\"H\",$O$10=\"H\",$P$10=\"H\",$Q$10=\"H\",$R$10=\"H\",$S$10=\"H\"),\"H\",IF(OR($G$10=\"M\",$H$10=\"M\",$I$10=\"M\",$J$10=\"M\",$K$10=\"M\",$L$10=\"M\",$M$10=\"M\",$N$10=\"M\",$O$10=\"M\",$P$10=\"M\",$Q$10=\"M\",$R$10=\"M\",$S$10=\"M\"),\"M\",IF(OR($G$10=\"G\",$H$10=\"G\",$I$10=\"G\",$J$10=\"G\",$K$4=\"G\",$L$4=\"G\",$M$4=\"G\",$N$4=\"G\",$O$4=\"G\",$P$4=\"G\",$Q$4=\"G\",$R$4=\"G\",$S$4=\"G\",$G$4=\"L\",$H$4=\"L\",$I$4=\"L\",$J$4=\"L\",$K$4=\"L\",$L$4=\"L\",$M$4=\"L\",$N$4=\"L\",$O$4=\"L\",$P$4=\"L\",$Q$10=\"L\",$R$10=\"L\",$S$10=\"L\"),\"G\",\"\")))","v":""},{"$f":"IF($G$11=\"i\",$G$2,IF($H$11=\"i\",$H$2,IF($I$11=\"i\",$I$2,IF($J$11=\"i\",$J$2,IF($K$11=\"i\",$K$2,IF($L$11=\"i\",$L$2,IF($M$11=\"i\",$M$2,IF($N$11=\"i\",$N$2,IF($O$11=\"i\",$O$2,IF($P$11=\"i\",$P$2,IF($Q$11=\"i\",$Q$2,DATEVALUE(\"01.01.1900\"))))))))))))","v":"1900-01-01"},{"$f":"IF(NOT(ISBLANK($Q$10)),$Q$2,IF(NOT(ISBLANK($P$10)),$P$2,IF(NOT(ISBLANK($O$10)),$O$2,IF(NOT(ISBLANK($N$10)),$N$2,IF(NOT(ISBLANK($M$10)),$M$2,IF(NOT(ISBLANK($L$10)),$L$2,IF(NOT(ISBLANK($K$10)),$K$2,IF(NOT(ISBLANK($J$10)),$J$2,IF(NOT(ISBLANK($I$10)),$I$2,IF(NOT(ISBLANK($H$10)),$H$2,IF(NOT(ISBLANK($G$10)),$G$2,DATEVALUE(\"01.01.1900\"))))))))))))+14","v":"1900-01-15"},{"$f":"IF(G10=\"G\",$G$2,IF(H10=\"G\",$H$2,IF(I10=\"G\",$I$2,IF(J10=\"G\",$J$2,IF(K10=\"G\",$K$2,IF(L10=\"G\",$L$2,IF(M10=\"G\",$M$2,IF(N10=\"G\",$N$2,IF(O10=\"G\",$O$2,IF(P10=\"G\",$P$2,IF(Q10=\"G\",$Q$2,IF(R10=\"G\",$R$2,IF(S10=\"G\",$S$2,DATEVALUE(\"01.01.1900\"))))))))))))))+3","v":"1900-01-04"},null,null,null,null,null,{"$f":"IF(G10=\"H\",$G$3*$AD$2,IF(G10=\"M\",$G$3*$AE$2,IF(OR(G10=\"G\",G10=\"L\"),$G$3*$AF$2,0)))","v":0},{"$f":"IF(H10=\"H\",$H$3*$AD$2,IF(H10=\"M\",$H$3*$AE$2,IF(OR(H10=\"G\",H10=\"L\"),$H$3*$AF$2,0)))","v":0},{"$f":"IF(I10=\"H\",$I$3*$AD$2,IF(I10=\"M\",$I$3*$AE$2,IF(OR(I10=\"G\",I10=\"L\"),$I$3*$AF$2,0)))","v":0},{"$f":"IF(J10=\"H\",$J$3*$AD$2,IF(J10=\"M\",$J$3*$AE$2,IF(OR(J10=\"G\",J10=\"L\"),$J$3*$AF$2,0)))","v":0},{"$f":"IF(K10=\"H\",$K$3*$AD$2,IF(K10=\"M\",$K$3*$AE$2,IF(OR(K10=\"G\",K10=\"L\"),$K$3*$AF$2,0)))","v":0},{"$f":"IF(L10=\"H\",$L$3*$AD$2,IF(L10=\"M\",$L$3*$AE$2,IF(OR(L10=\"G\",L10=\"L\"),$L$3*$AF$2,0)))","v":0},{"$f":"IF(M10=\"H\",$M$3*$AD$2,IF(M10=\"M\",$M$3*$AE$2,IF(OR(M10=\"G\",M10=\"L\"),$M$3*$AF$2,0)))","v":0},{"$f":"IF(N10=\"H\",$N$3*$AD$2,IF(N10=\"M\",$N$3*$AE$2,IF(OR(N10=\"G\",N10=\"L\"),$N$3*$AF$2,0)))","v":0},{"$f":"IF(O10=\"H\",$O$3*$AD$2,IF(O10=\"M\",$O$3*$AE$2,IF(OR(O10=\"G\",O10=\"L\"),$O$3*$AF$2,0)))","v":0},{"$f":"IF(P10=\"H\",$P$3*$AD$2,IF(P10=\"M\",$P$3*$AE$2,IF(OR(P10=\"G\",P10=\"L\"),$P$3*$AE$2,0)))","v":0},{"$f":"SUM(AD10:AM10)","v":0},{"$f":"AN10*Risk_Analysis!$T$1","v":0},null,null,{"$f":"AO10","v":0}]
[null,null,null,null,null,null,{"$f":"\" \"","v":" "},{"$f":"\" \"","v":" "},{"$f":"IF(OR($H$11=\"i\",NOT(ISBLANK($G$10))),\"i\",\" \")","v":" "},{"$f":"IF(OR($I$11=\"i\",NOT(ISBLANK($H$10))),\"i\",\" \")","v":" "},{"$f":"IF(OR($J$11=\"i\",NOT(ISBLANK($I$10))),\"i\",\" \")","v":" "},{"$f":"IF(OR($K$11=\"i\",NOT(ISBLANK($J$10))),\"i\",\" \")","v":" "},{"$f":"IF(OR($L$11=\"i\",NOT(ISBLANK($K$10))),\"i\",\" \")","v":" "},{"$f":"IF(OR($M$11=\"i\",NOT(ISBLANK($L$10))),\"i\",\" \")","v":" "},{"$f":"IF(OR($N$11=\"i\",NOT(ISBLANK($M$10))),\"i\",\" \")","v":" "},{"$f":"IF(OR($O$11=\"i\",NOT(ISBLANK($N$10))),\"i\",\" \")","v":" "},{"$f":"IF(OR($P$11=\"i\",NOT(ISBLANK($O$10))),\"i\",\" \")","v":" "},{"$f":"IF(OR($Q$11=\"i\",NOT(ISBLANK($P$10))),\"i\",\" \")","v":" "},{"$f":"IF(OR($R$11=\"i\",NOT(ISBLANK($Q$10))),\"i\",\" \")","v":" "}]
[null,null,{"$f":"IF(ISBLANK(Basic_Data!C18),DATEVALUE(\"01.01.1900\"),Basic_Data!C18)","v":"1900-01-01"},null,"Nr. 5:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($G$12=\"H\",$H$12=\"H\",$I$12=\"H\",$J$12=\"H\",$K$12=\"H\",$L$12=\"H\",$M$12=\"H\",$N$12=\"H\",$O$12=\"H\",$P$12=\"H\",$Q$12=\"H\",$R$12=\"H\",$S$12=\"H\"),\"H\",IF(OR($G$12=\"M\",$H$12=\"M\",$I$12=\"M\",$J$12=\"M\",$K$12=\"M\",$L$12=\"M\",$M$12=\"M\",$N$12=\"M\",$O$12=\"M\",$P$12=\"M\",$Q$12=\"M\",$R$12=\"M\",$S$12=\"M\"),\"M\",IF(OR($G$12=\"G\",$H$12=\"G\",$I$12=\"G\",$J$12=\"G\",$K$4=\"G\",$L$4=\"G\",$M$4=\"G\",$N$4=\"G\",$O$4=\"G\",$P$4=\"G\",$Q$4=\"G\",$R$4=\"G\",$S$4=\"G\",$G$4=\"L\",$H$4=\"L\",$I$4=\"L\",$J$4=\"L\",$K$4=\"L\",$L$4=\"L\",$M$4=\"L\",$N$4=\"L\",$O$4=\"L\",$P$4=\"L\",$Q$12=\"L\",$R$12=\"L\",$S$12=\"L\"),\"G\",\"\")))","v":""},{"$f":"IF($G$13=\"i\",$G$2,IF($H$13=\"i\",$H$2,IF($I$13=\"i\",$I$2,IF($J$13=\"i\",$J$2,IF($K$13=\"i\",$K$2,IF($L$13=\"i\",$L$2,IF($M$13=\"i\",$M$2,IF($N$13=\"i\",$N$2,IF($O$13=\"i\",$O$2,IF($P$13=\"i\",$P$2,IF($Q$13=\"i\",$Q$2,DATEVALUE(\"01.01.1900\"))))))))))))","v":"1900-01-01"},{"$f":"IF(NOT(ISBLANK($Q$12)),$Q$2,IF(NOT(ISBLANK($P$12)),$P$2,IF(NOT(ISBLANK($O$12)),$O$2,IF(NOT(ISBLANK($N$12)),$N$2,IF(NOT(ISBLANK($M$12)),$M$2,IF(NOT(ISBLANK($L$12)),$L$2,IF(NOT(ISBLANK($K$12)),$K$2,IF(NOT(ISBLANK($J$12)),$J$2,IF(NOT(ISBLANK($I$12)),$I$2,IF(NOT(ISBLANK($H$12)),$H$2,IF(NOT(ISBLANK($G$12)),$G$2,DATEVALUE(\"01.01.1900\"))))))))))))+14","v":"1900-01-15"},{"$f":"IF(G12=\"G\",$G$2,IF(H12=\"G\",$H$2,IF(I12=\"G\",$I$2,IF(J12=\"G\",$J$2,IF(K12=\"G\",$K$2,IF(L12=\"G\",$L$2,IF(M12=\"G\",$M$2,IF(N12=\"G\",$N$2,IF(O12=\"G\",$O$2,IF(P12=\"G\",$P$2,IF(Q12=\"G\",$Q$2,IF(R12=\"G\",$R$2,IF(S12=\"G\",$S$2,DATEVALUE(\"01.01.1900\"))))))))))))))+3","v":"1900-01-04"},null,null,null,null,null,{"$f":"IF(G12=\"H\",$G$3*$AD$2,IF(G12=\"M\",$G$3*$AE$2,IF(OR(G12=\"G\",G12=\"L\"),$G$3*$AF$2,0)))","v":0},{"$f":"IF(H12=\"H\",$H$3*$AD$2,IF(H12=\"M\",$H$3*$AE$2,IF(OR(H12=\"G\",H12=\"L\"),$H$3*$AF$2,0)))","v":0},{"$f":"IF(I12=\"H\",$I$3*$AD$2,IF(I12=\"M\",$I$3*$AE$2,IF(OR(I12=\"G\",I12=\"L\"),$I$3*$AF$2,0)))","v":0},{"$f":"IF(J12=\"H\",$J$3*$AD$2,IF(J12=\"M\",$J$3*$AE$2,IF(OR(J12=\"G\",J12=\"L\"),$J$3*$AF$2,0)))","v":0},{"$f":"IF(K12=\"H\",$K$3*$AD$2,IF(K12=\"M\",$K$3*$AE$2,IF(OR(K12=\"G\",K12=\"L\"),$K$3*$AF$2,0)))","v":0},{"$f":"IF(L12=\"H\",$L$3*$AD$2,IF(L12=\"M\",$L$3*$AE$2,IF(OR(L12=\"G\",L12=\"L\"),$L$3*$AF$2,0)))","v":0},{"$f":"IF(M12=\"H\",$M$3*$AD$2,IF(M12=\"M\",$M$3*$AE$2,IF(OR(M12=\"G\",M12=\"L\"),$M$3*$AF$2,0)))","v":0},{"$f":"IF(N12=\"H\",$N$3*$AD$2,IF(N12=\"M\",$N$3*$AE$2,IF(OR(N12=\"G\",N12=\"L\"),$N$3*$AF$2,0)))","v":0},{"$f":"IF(O12=\"H\",$O$3*$AD$2,IF(O12=\"M\",$O$3*$AE$2,IF(OR(O12=\"G\",O12=\"L\"),$O$3*$AF$2,0)))","v":0},{"$f":"IF(P12=\"H\",$P$3*$AD$2,IF(P12=\"M\",$P$3*$AE$2,IF(OR(P12=\"G\",P12=\"L\"),$P$3*$AE$2,0)))","v":0},{"$f":"SUM(AD12:AM12)","v":0},{"$f":"AN12*Risk_Analysis!$T$1","v":0},null,null,{"$f":"AO12","v":0}]
[null,null,"1900-01-01",null,null,null,{"$f":"\" \"","v":" "},{"$f":"\" \"","v":" "},{"$f":"IF(OR($H$13=\"i\",NOT(ISBLANK($G$12))),\"i\",\" \")","v":" "},{"$f":"IF(OR($I$13=\"i\",NOT(ISBLANK($H$12))),\"i\",\" \")","v":" "},null,null,null,{"$f":"IF(OR($M$13=\"i\",NOT(ISBLANK($L$12))),\"i\",\" \")","v":" "},{"$f":"IF(OR($N$13=\"i\",NOT(ISBLANK($M$12))),\"i\",\" \")","v":" "},{"$f":"IF(OR($O$13=\"i\",NOT(ISBLANK($N$12))),\"i\",\" \")","v":" "},{"$f":"IF(OR($P$13=\"i\",NOT(ISBLANK($O$12))),\"i\",\" \")","v":" "},{"$f":"IF(OR($Q$13=\"i\",NOT(ISBLANK($P$12))),\"i\",\" \")","v":" "},{"$f":"IF(OR($R$13=\"i\",NOT(ISBLANK($Q$12))),\"i\",\" \")","v":" "}]
[null,null,null,null,"Nr. 6:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($G$14=\"H\",$H$14=\"H\",$I$14=\"H\",$J$14=\"H\",$K$14=\"H\",$L$14=\"H\",$M$14=\"H\",$N$14=\"H\",$O$14=\"H\",$P$14=\"H\",$Q$14=\"H\",$R$14=\"H\",$S$14=\"H\"),\"H\",IF(OR($G$14=\"M\",$H$14=\"M\",$I$14=\"M\",$J$14=\"M\",$K$14=\"M\",$L$14=\"M\",$M$14=\"M\",$N$14=\"M\",$O$14=\"M\",$P$14=\"M\",$Q$14=\"M\",$R$14=\"M\",$S$14=\"M\"),\"M\",IF(OR($G$14=\"G\",$H$14=\"G\",$I$14=\"G\",$J$14=\"G\",$K$4=\"G\",$L$4=\"G\",$M$4=\"G\",$N$4=\"G\",$O$4=\"G\",$P$4=\"G\",$Q$4=\"G\",$R$4=\"G\",$S$4=\"G\",$G$4=\"L\",$H$4=\"L\",$I$4=\"L\",$J$4=\"L\",$K$4=\"L\",$L$4=\"L\",$M$4=\"L\",$N$4=\"L\",$O$4=\"L\",$P$4=\"L\",$Q$14=\"L\",$R$14=\"L\",$S$14=\"L\"),\"G\",\"\")))","v":""},{"$f":"IF($G$15=\"i\",$G$2,IF($H$15=\"i\",$H$2,IF($I$15=\"i\",$I$2,IF($J$15=\"i\",$J$2,IF($K$15=\"i\",$K$2,IF($L$15=\"i\",$L$2,IF($M$15=\"i\",$M$2,IF($N$15=\"i\",$N$2,IF($O$15=\"i\",$O$2,IF($P$15=\"i\",$P$2,IF($Q$15=\"i\",$Q$2,DATEVALUE(\"01.01.1900\"))))))))))))","v":"1900-01-01"},{"$f":"IF(NOT(ISBLANK($Q$14)),$Q$2,IF(NOT(ISBLANK($P$14)),$P$2,IF(NOT(ISBLANK($O$14)),$O$2,IF(NOT(ISBLANK($N$14)),$N$2,IF(NOT(ISBLANK($M$14)),$M$2,IF(NOT(ISBLANK($L$14)),$L$2,IF(NOT(ISBLANK($K$14)),$K$2,IF(NOT(ISBLANK($J$14)),$J$2,IF(NOT(ISBLANK($I$14)),$I$2,IF(NOT(ISBLANK($H$14)),$H$2,IF(NOT(ISBLANK($G$14)),$G$2,DATEVALUE(\"01.01.1900\"))))))))))))+14","v":"1900-01-15"},{"$f":"IF(G14=\"G\",$G$2,IF(H14=\"G\",$H$2,IF(I14=\"G\",$I$2,IF(J14=\"G\",$J$2,IF(K14=\"G\",$K$2,IF(L14=\"G\",$L$2,IF(M14=\"G\",$M$2,IF(N14=\"G\",$N$2,IF(O14=\"G\",$O$2,IF(P14=\"G\",$P$2,IF(Q14=\"G\",$Q$2,IF(R14=\"G\",$R$2,IF(S14=\"G\",$S$2,DATEVALUE(\"01.01.1900\"))))))))))))))+3","v":"1900-01-04"},null,null,null,null,null,{"$f":"IF(G14=\"H\",$G$3*$AD$2,IF(G14=\"M\",$G$3*$AE$2,IF(OR(G14=\"G\",G14=\"L\"),$G$3*$AF$2,0)))","v":0},{"$f":"IF(H14=\"H\",$H$3*$AD$2,IF(H14=\"M\",$H$3*$AE$2,IF(OR(H14=\"G\",H14=\"L\"),$H$3*$AF$2,0)))","v":0},{"$f":"IF(I14=\"H\",$I$3*$AD$2,IF(I14=\"M\",$I$3*$AE$2,IF(OR(I14=\"G\",I14=\"L\"),$I$3*$AF$2,0)))","v":0},{"$f":"IF(J14=\"H\",$J$3*$AD$2,IF(J14=\"M\",$J$3*$AE$2,IF(OR(J14=\"G\",J14=\"L\"),$J$3*$AF$2,0)))","v":0},{"$f":"IF(K14=\"H\",$K$3*$AD$2,IF(K14=\"M\",$K$3*$AE$2,IF(OR(K14=\"G\",K14=\"L\"),$K$3*$AF$2,0)))","v":0},{"$f":"IF(L14=\"H\",$L$3*$AD$2,IF(L14=\"M\",$L$3*$AE$2,IF(OR(L14=\"G\",L14=\"L\"),$L$3*$AF$2,0)))","v":0},{"$f":"IF(M14=\"H\",$M$3*$AD$2,IF(M14=\"M\",$M$3*$AE$2,IF(OR(M14=\"G\",M14=\"L\"),$M$3*$AF$2,0)))","v":0},{"$f":"IF(N14=\"H\",$N$3*$AD$2,IF(N14=\"M\",$N$3*$AE$2,IF(OR(N14=\"G\",N14=\"L\"),$N$3*$AF$2,0)))","v":0},{"$f":"IF(O14=\"H\",$O$3*$AD$2,IF(O14=\"M\",$O$3*$AE$2,IF(OR(O14=\"G\",O14=\"L\"),$O$3*$AF$2,0)))","v":0},{"$f":"IF(P14=\"H\",$P$3*$AD$2,IF(P14=\"M\",$P$3*$AE$2,IF(OR(P14=\"G\",P14=\"L\"),$P$3*$AE$2,0)))","v":0},{"$f":"SUM(AD14:AM14)","v":0},{"$f":"AN14*Risk_Analysis!$T$1","v":0},null,null,{"$f":"AO14","v":0}]
[null,null,null,null,null,null,{"$f":"\" \"","v":" "},{"$f":"\" \"","v":" "},{"$f":"IF(OR($H$15=\"i\",NOT(ISBLANK($G$14))),\"i\",\" \")","v":" "},{"$f":"IF(OR($I$15=\"i\",NOT(ISBLANK($H$14))),\"i\",\" \")","v":" "},{"$f":"IF(OR($J$15=\"i\",NOT(ISBLANK($I$14))),\"i\",\" \")","v":" "},{"$f":"IF(OR($K$15=\"i\",NOT(ISBLANK($J$14))),\"i\",\" \")","v":" "},{"$f":"IF(OR($L$15=\"i\",NOT(ISBLANK($K$14))),\"i\",\" \")","v":" "},{"$f":"IF(OR($M$15=\"i\",NOT(ISBLANK($L$14))),\"i\",\" \")","v":" "},{"$f":"IF(OR($N$15=\"i\",NOT(ISBLANK($M$14))),\"i\",\" \")","v":" "},{"$f":"IF(OR($O$15=\"i\",NOT(ISBLANK($N$14))),\"i\",\" \")","v":" "},{"$f":"IF(OR($P$15=\"i\",NOT(ISBLANK($O$14))),\"i\",\" \")","v":" "},{"$f":"IF(OR($Q$15=\"i\",NOT(ISBLANK($P$14))),\"i\",\" \")","v":" "},{"$f":"IF(OR($R$15=\"i\",NOT(ISBLANK($Q$14))),\"i\",\" \")","v":" "}]
[null,null,null,null,"Nr. 7:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($G$16=\"H\",$H$16=\"H\",$I$16=\"H\",$J$16=\"H\",$K$16=\"H\",$L$16=\"H\",$M$16=\"H\",$N$16=\"H\",$O$16=\"H\",$P$16=\"H\",$Q$16=\"H\",$R$16=\"H\",$S$16=\"H\"),\"H\",IF(OR($G$16=\"M\",$H$16=\"M\",$I$16=\"M\",$J$16=\"M\",$K$16=\"M\",$L$16=\"M\",$M$16=\"M\",$N$16=\"M\",$O$16=\"M\",$P$16=\"M\",$Q$16=\"M\",$R$16=\"M\",$S$16=\"M\"),\"M\",IF(OR($G$16=\"G\",$H$16=\"G\",$I$16=\"G\",$J$16=\"G\",$K$4=\"G\",$L$4=\"G\",$M$4=\"G\",$N$4=\"G\",$O$4=\"G\",$P$4=\"G\",$Q$4=\"G\",$R$4=\"G\",$S$4=\"G\",$G$4=\"L\",$H$4=\"L\",$I$4=\"L\",$J$4=\"L\",$K$4=\"L\",$L$4=\"L\",$M$4=\"L\",$N$4=\"L\",$O$4=\"L\",$P$4=\"L\",$Q$16=\"L\",$R$16=\"L\",$S$16=\"L\"),\"G\",\"\")))","v":""},{"$f":"IF($G$17=\"i\",$G$2,IF($H$17=\"i\",$H$2,IF($I$17=\"i\",$I$2,IF($J$17=\"i\",$J$2,IF($K$17=\"i\",$K$2,IF($L$17=\"i\",$L$2,IF($M$17=\"i\",$M$2,IF($N$17=\"i\",$N$2,IF($O$17=\"i\",$O$2,IF($P$17=\"i\",$P$2,IF($Q$17=\"i\",$Q$2,DATEVALUE(\"01.01.1900\"))))))))))))","v":"1900-01-01"},{"$f":"IF(NOT(ISBLANK($Q$16)),$Q$2,IF(NOT(ISBLANK($P$16)),$P$2,IF(NOT(ISBLANK($O$16)),$O$2,IF(NOT(ISBLANK($N$16)),$N$2,IF(NOT(ISBLANK($M$16)),$M$2,IF(NOT(ISBLANK($L$16)),$L$2,IF(NOT(ISBLANK($K$16)),$K$2,IF(NOT(ISBLANK($J$16)),$J$2,IF(NOT(ISBLANK($I$16)),$I$2,IF(NOT(ISBLANK($H$16)),$H$2,IF(NOT(ISBLANK($G$16)),$G$2,DATEVALUE(\"01.01.1900\"))))))))))))+14","v":"1900-01-15"},{"$f":"IF(G16=\"G\",$G$2,IF(H16=\"G\",$H$2,IF(I16=\"G\",$I$2,IF(J16=\"G\",$J$2,IF(K16=\"G\",$K$2,IF(L16=\"G\",$L$2,IF(M16=\"G\",$M$2,IF(N16=\"G\",$N$2,IF(O16=\"G\",$O$2,IF(P16=\"G\",$P$2,IF(Q16=\"G\",$Q$2,IF(R16=\"G\",$R$2,IF(S16=\"G\",$S$2,DATEVALUE(\"01.01.1900\"))))))))))))))+3","v":"1900-01-04"},null,null,null,null,null,{"$f":"IF(G16=\"H\",$G$3*$AD$2,IF(G16=\"M\",$G$3*$AE$2,IF(OR(G16=\"G\",G16=\"L\"),$G$3*$AF$2,0)))","v":0},{"$f":"IF(H16=\"H\",$H$3*$AD$2,IF(H16=\"M\",$H$3*$AE$2,IF(OR(H16=\"G\",H16=\"L\"),$H$3*$AF$2,0)))","v":0},{"$f":"IF(I16=\"H\",$I$3*$AD$2,IF(I16=\"M\",$I$3*$AE$2,IF(OR(I16=\"G\",I16=\"L\"),$I$3*$AF$2,0)))","v":0},{"$f":"IF(J16=\"H\",$J$3*$AD$2,IF(J16=\"M\",$J$3*$AE$2,IF(OR(J16=\"G\",J16=\"L\"),$J$3*$AF$2,0)))","v":0},{"$f":"IF(K16=\"H\",$K$3*$AD$2,IF(K16=\"M\",$K$3*$AE$2,IF(OR(K16=\"G\",K16=\"L\"),$K$3*$AF$2,0)))","v":0},{"$f":"IF(L16=\"H\",$L$3*$AD$2,IF(L16=\"M\",$L$3*$AE$2,IF(OR(L16=\"G\",L16=\"L\"),$L$3*$AF$2,0)))","v":0},{"$f":"IF(M16=\"H\",$M$3*$AD$2,IF(M16=\"M\",$M$3*$AE$2,IF(OR(M16=\"G\",M16=\"L\"),$M$3*$AF$2,0)))","v":0},{"$f":"IF(N16=\"H\",$N$3*$AD$2,IF(N16=\"M\",$N$3*$AE$2,IF(OR(N16=\"G\",N16=\"L\"),$N$3*$AF$2,0)))","v":0},{"$f":"IF(O16=\"H\",$O$3*$AD$2,IF(O16=\"M\",$O$3*$AE$2,IF(OR(O16=\"G\",O16=\"L\"),$O$3*$AF$2,0)))","v":0},{"$f":"IF(P16=\"H\",$P$3*$AD$2,IF(P16=\"M\",$P$3*$AE$2,IF(OR(P16=\"G\",P16=\"L\"),$P$3*$AE$2,0)))","v":0},{"$f":"SUM(AD16:AM16)","v":0},{"$f":"AN16*Risk_Analysis!$T$1","v":0},null,null,{"$f":"AO16","v":0}]
[null,null,null,null,null,null,{"$f":"\" \"","v":" "},{"$f":"\" \"","v":" "},{"$f":"IF(OR($H$17=\"i\",NOT(ISBLANK($G$16))),\"i\",\" \")","v":" "},{"$f":"IF(OR($I$17=\"i\",NOT(ISBLANK($H$16))),\"i\",\" \")","v":" "},{"$f":"IF(OR($J$17=\"i\",NOT(ISBLANK($I$16))),\"i\",\" \")","v":" "},{"$f":"IF(OR($K$17=\"i\",NOT(ISBLANK($J$16))),\"i\",\" \")","v":" "},{"$f":"IF(OR($L$17=\"i\",NOT(ISBLANK($K$16))),\"i\",\" \")","v":" "},{"$f":"IF(OR($M$17=\"i\",NOT(ISBLANK($L$16))),\"i\",\" \")","v":" "},{"$f":"IF(OR($N$17=\"i\",NOT(ISBLANK($M$16))),\"i\",\" \")","v":" "},{"$f":"IF(OR($O$17=\"i\",NOT(ISBLANK($N$16))),\"i\",\" \")","v":" "},{"$f":"IF(OR($P$17=\"i\",NOT(ISBLANK($O$16))),\"i\",\" \")","v":" "},{"$f":"IF(OR($Q$17=\"i\",NOT(ISBLANK($P$16))),\"i\",\" \")","v":" "},{"$f":"IF(OR($R$17=\"i\",NOT(ISBLANK($Q$16))),\"i\",\" \")","v":" "}]
[null,null,null,null,"Nr. 8:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($G$18=\"H\",$H$18=\"H\",$I$18=\"H\",$J$18=\"H\",$K$18=\"H\",$L$18=\"H\",$M$18=\"H\",$N$18=\"H\",$O$18=\"H\",$P$18=\"H\",$Q$18=\"H\",$R$18=\"H\",$S$18=\"H\"),\"H\",IF(OR($G$18=\"M\",$H$18=\"M\",$I$18=\"M\",$J$18=\"M\",$K$18=\"M\",$L$18=\"M\",$M$18=\"M\",$N$18=\"M\",$O$18=\"M\",$P$18=\"M\",$Q$18=\"M\",$R$18=\"M\",$S$18=\"M\"),\"M\",IF(OR($G$18=\"G\",$H$18=\"G\",$I$18=\"G\",$J$18=\"G\",$K$4=\"G\",$L$4=\"G\",$M$4=\"G\",$N$4=\"G\",$O$4=\"G\",$P$4=\"G\",$Q$4=\"G\",$R$4=\"G\",$S$4=\"G\",$G$4=\"L\",$H$4=\"L\",$I$4=\"L\",$J$4=\"L\",$K$4=\"L\",$L$4=\"L\",$M$4=\"L\",$N$4=\"L\",$O$4=\"L\",$P$4=\"L\",$Q$18=\"L\",$R$18=\"L\",$S$18=\"L\"),\"G\",\"\")))","v":""},{"$f":"IF($G$19=\"i\",$G$2,IF($H$19=\"i\",$H$2,IF($I$19=\"i\",$I$2,IF($J$19=\"i\",$J$2,IF($K$19=\"i\",$K$2,IF($L$19=\"i\",$L$2,IF($M$19=\"i\",$M$2,IF($N$19=\"i\",$N$2,IF($O$19=\"i\",$O$2,IF($P$19=\"i\",$P$2,IF($Q$19=\"i\",$Q$2,DATEVALUE(\"01.01.1900\"))))))))))))","v":"1900-01-01"},{"$f":"IF(NOT(ISBLANK($Q$18)),$Q$2,IF(NOT(ISBLANK($P$18)),$P$2,IF(NOT(ISBLANK($O$18)),$O$2,IF(NOT(ISBLANK($N$18)),$N$2,IF(NOT(ISBLANK($M$18)),$M$2,IF(NOT(ISBLANK($L$18)),$L$2,IF(NOT(ISBLANK($K$18)),$K$2,IF(NOT(ISBLANK($J$18)),$J$2,IF(NOT(ISBLANK($I$18)),$I$2,IF(NOT(ISBLANK($H$18)),$H$2,IF(NOT(ISBLANK($G$18)),$G$2,DATEVALUE(\"01.01.1900\"))))))))))))+14","v":"1900-01-15"},{"$f":"IF(G18=\"G\",$G$2,IF(H18=\"G\",$H$2,IF(I18=\"G\",$I$2,IF(J18=\"G\",$J$2,IF(K18=\"G\",$K$2,IF(L18=\"G\",$L$2,IF(M18=\"G\",$M$2,IF(N18=\"G\",$N$2,IF(O18=\"G\",$O$2,IF(P18=\"G\",$P$2,IF(Q18=\"G\",$Q$2,IF(R18=\"G\",$R$2,IF(S18=\"G\",$S$2,DATEVALUE(\"01.01.1900\"))))))))))))))+3","v":"1900-01-04"},null,null,null,null,null,{"$f":"IF(G18=\"H\",$G$3*$AD$2,IF(G18=\"M\",$G$3*$AE$2,IF(OR(G18=\"G\",G18=\"L\"),$G$3*$AF$2,0)))","v":0},{"$f":"IF(H18=\"H\",$H$3*$AD$2,IF(H18=\"M\",$H$3*$AE$2,IF(OR(H18=\"G\",H18=\"L\"),$H$3*$AF$2,0)))","v":0},{"$f":"IF(I18=\"H\",$I$3*$AD$2,IF(I18=\"M\",$I$3*$AE$2,IF(OR(I18=\"G\",I18=\"L\"),$I$3*$AF$2,0)))","v":0},{"$f":"IF(J18=\"H\",$J$3*$AD$2,IF(J18=\"M\",$J$3*$AE$2,IF(OR(J18=\"G\",J18=\"L\"),$J$3*$AF$2,0)))","v":0},{"$f":"IF(K18=\"H\",$K$3*$AD$2,IF(K18=\"M\",$K$3*$AE$2,IF(OR(K18=\"G\",K18=\"L\"),$K$3*$AF$2,0)))","v":0},{"$f":"IF(L18=\"H\",$L$3*$AD$2,IF(L18=\"M\",$L$3*$AE$2,IF(OR(L18=\"G\",L18=\"L\"),$L$3*$AF$2,0)))","v":0},{"$f":"IF(M18=\"H\",$M$3*$AD$2,IF(M18=\"M\",$M$3*$AE$2,IF(OR(M18=\"G\",M18=\"L\"),$M$3*$AF$2,0)))","v":0},{"$f":"IF(N18=\"H\",$N$3*$AD$2,IF(N18=\"M\",$N$3*$AE$2,IF(OR(N18=\"G\",N18=\"L\"),$N$3*$AF$2,0)))","v":0},{"$f":"IF(O18=\"H\",$O$3*$AD$2,IF(O18=\"M\",$O$3*$AE$2,IF(OR(O18=\"G\",O18=\"L\"),$O$3*$AF$2,0)))","v":0},{"$f":"IF(P18=\"H\",$P$3*$AD$2,IF(P18=\"M\",$P$3*$AE$2,IF(OR(P18=\"G\",P18=\"L\"),$P$3*$AE$2,0)))","v":0},{"$f":"SUM(AD18:AM18)","v":0},{"$f":"AN18*Risk_Analysis!$T$1","v":0},null,null,{"$f":"AO18","v":0}]
[null,null,null,null,null,null,{"$f":"\" \"","v":" "},{"$f":"\" \"","v":" "},{"$f":"IF(OR($H$19=\"i\",NOT(ISBLANK($G$18))),\"i\",\" \")","v":" "},{"$f":"IF(OR($I$19=\"i\",NOT(ISBLANK($H$18))),\"i\",\" \")","v":" "},{"$f":"IF(OR($J$19=\"i\",NOT(ISBLANK($I$18))),\"i\",\" \")","v":" "},{"$f":"IF(OR($K$19=\"i\",NOT(ISBLANK($J$18))),\"i\",\" \")","v":" "},{"$f":"IF(OR($L$19=\"i\",NOT(ISBLANK($K$18))),\"i\",\" \")","v":" "},{"$f":"IF(OR($M$19=\"i\",NOT(ISBLANK($L$18))),\"i\",\" \")","v":" "},{"$f":"IF(OR($N$19=\"i\",NOT(ISBLANK($M$18))),\"i\",\" \")","v":" "},{"$f":"IF(OR($O$19=\"i\",NOT(ISBLANK($N$18))),\"i\",\" \")","v":" "},{"$f":"IF(OR($P$19=\"i\",NOT(ISBLANK($O$18))),\"i\",\" \")","v":" "},{"$f":"IF(OR($Q$19=\"i\",NOT(ISBLANK($P$18))),\"i\",\" \")","v":" "},{"$f":"IF(OR($R$19=\"i\",NOT(ISBLANK($Q$18))),\"i\",\" \")","v":" "}]
[null,null,null,null,"Reference","Step C: indirect contacts",null,null,null,null,null,null,null,null,null,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":"SUM(AN4:AN18)","v":0},{"$f":"SUM(AO4:AO18)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($G$21=\"H\",$H$21=\"H\",$I$21=\"H\",$J$21=\"H\",$K$21=\"H\",$L$21=\"H\",$M$21=\"H\",$N$21=\"H\",$O$21=\"H\",$P$21=\"H\",$Q$21=\"H\",$R$21=\"H\",$S$21=\"H\"),\"H\",IF(OR($G$21=\"M\",$H$21=\"M\",$I$21=\"M\",$J$21=\"M\",$K$21=\"M\",$L$21=\"M\",$M$21=\"M\",$N$21=\"M\",$O$21=\"M\",$P$21=\"M\",$Q$21=\"M\",$R$21=\"M\",$S$21=\"M\"),\"M\",IF(OR($G$21=\"G\",$H$21=\"G\",$I$21=\"G\",$J$21=\"G\",$K$21=\"G\",$L$21=\"G\",$M$21=\"G\",$N$21=\"G\",$O$21=\"G\",$P$21=\"G\",$Q$21=\"G\",$R$21=\"G\",$S$21=\"G\"),\"G\",\"\")))","v":""},{"$f":"IF($E$21=\"Nr. 1\",$U$4,IF($E$21=\"Nr. 2\",$U$6,IF($E$21=\"Nr. 3\",$U$8,IF($E$21=\"Nr. 4\",$U$10,IF($E$21=\"Nr. 5\",$U$12,IF($E$21=\"Nr. 6\",$U$14,IF($E$21=\"Nr. 7\",$U$16,IF($E$21=\"Nr. 8\",$U$18,\"\"))))))))","v":""},{"$f":"IF(E21=\"Nr. 1\",$V$4,IF(E21=\"Nr. 2\",$V$6,IF(E21=\"Nr. 3\",$V$8,IF(E21=\"Nr. 4\",$V$10,IF(E21=\"Nr. 5\",$V$12,IF(E21=\"Nr. 6\",$V$14,IF(E21=\"Nr. 7\",$V$16,IF(E21=\"Nr. 8\",$V$18,DATEVALUE(\"01.01.1900\")))))))))","v":"1900-01-01"},{"$f":"IF(E21=\"Nr. 1\",$W$4,IF(E21=\"Nr. 2\",$W$6,IF(E21=\"Nr. 3\",$W$8,IF(E21=\"Nr. 4\",$W$10,IF(E21=\"Nr. 5\",$W$12,IF(E21=\"Nr. 6\",$W$14,IF(E21=\"Nr. 7\",$W$16,IF(E21=\"Nr. 8\",$W$18,DATEVALUE(\"01.01.1900\")))))))))","v":"1900-01-01"},{"$f":"IF(AND(NOT(ISBLANK(I21)),$I$2>=W21),$I$2,IF(AND(NOT(ISBLANK(J21)),$J$2>=W21),$J$2,IF(AND(NOT(ISBLANK(K21)),$K$2>=W21),$K$2,IF(AND(NOT(ISBLANK(L21)),$L$2>=W21),$L$2,IF(AND(NOT(ISBLANK(M21)),$M$2>=W21),$M$2,IF(AND(NOT(ISBLANK(N21)),$N$2>=W21),$N$2,IF(AND(NOT(ISBLANK(O21)),$O$2>=W21),$O$2,IF(AND(NOT(ISBLANK(P21)),$P$2>=W21),$P$2,IF(AND(NOT(ISBLANK(Q21)),$Q$2>=W21),$Q$2,IF(AND(NOT(ISBLANK(R21)),$R$2>=W21),$R$2,IF(AND(NOT(ISBLANK(S21)),$S$2>=W21),$S$2,DATEVALUE(\"01.01.1900\"))))))))))))+2","v":"1900-01-03"},{"$f":"IF(AND(NOT(ISBLANK(S21)),$S$2>=W21),$S$2,IF(AND(NOT(ISBLANK(R21)),$R$2>=W21),$R$2,IF(AND(NOT(ISBLANK(Q21)),$Q$2>=W21),$Q$2,IF(AND(NOT(ISBLANK(P21)),$P$2>=W21),$P$2,IF(AND(NOT(ISBLANK(O21)),$O$2>=W21),$O$2,IF(AND(NOT(ISBLANK(N21)),$N$2>=W21),$N$2,IF(AND(NOT(ISBLANK(M21)),$M$2>=W21),$M$2,IF(AND(NOT(ISBLANK(L21)),$L$2>=W21),$L$2,IF(AND(NOT(ISBLANK(K21)),$K$2>=W21),$K$2,IF(AND(NOT(ISBLANK(J21)),$J$2>=W21),$J$2,IF(AND(NOT(ISBLANK(I21)),$I$2>=W21),$I$2,DATEVALUE(\"01.01.1900\"))))))))))))+14","v":"1900-01-15"},{"$f":"IF(AND(OR(J21=\"H\",J21=\"M\"),OR(V21=\"H\",V21=\"M\"),$J$2>=W21),$J$2,IF(AND(OR(K21=\"H\",K21=\"M\"),OR(V21=\"H\",V21=\"M\"),$K$2>=W21),$K$2,IF(AND(OR(L21=\"H\",L21=\"M\"),OR(V21=\"H\",V21=\"M\"),$L$2>=W21),$L$2,IF(AND(OR(M21=\"H\",M21=\"M\"),OR(V21=\"H\",V21=\"M\"),$M$2>=W21),$M$2,IF(AND(OR(N21=\"H\",N21=\"M\"),OR(V21=\"H\",V21=\"M\"),$N$2>=W21),$N$2,IF(AND(OR(O21=\"H\",O21=\"M\"),OR(V21=\"H\",V21=\"M\"),$O$2>=W21),O2,IF(AND(OR(P21=\"H\",P21=\"M\"),OR(V21=\"H\",V21=\"M\"),$P$2>=W21),$P$2,IF(AND(OR(Q21=\"H\",Q21=\"M\"),OR(V21=\"H\",V21=\"M\"),$Q$2>=W21),$Q$2,IF(AND(OR(R21=\"H\",R21=\"M\"),OR(V21=\"H\",V21=\"M\"),$R$2>=W21),$R$2,IF(AND(OR(S21=\"H\",S21=\"M\"),OR(V21=\"H\",V21=\"M\"),$S$2>=W21),$S$2,DATEVALUE(\"01.01.1900\")))))))))))+3","v":"1900-01-04"},{"$f":"IF(AND(NOT(V21=\"G\"),OR(S21=\"H\",S21=\"M\"),OR(U21=\"H\",U21=\"M\"),$S$2>=W21),$S$2,IF(AND(NOT(V21=\"G\"),OR(R21=\"H\",R21=\"M\"),OR(U21=\"H\",U21=\"M\"),$R$2>=W21),$R$2,IF(AND(NOT(V21=\"G\"),OR(Q21=\"H\",Q21=\"M\"),OR(U21=\"H\",U21=\"M\"),$Q$2>=W21),$Q$2,IF(AND(NOT(V21=\"G\"),OR(P21=\"H\",P21=\"M\"),OR(U21=\"H\",U21=\"M\"),$P$2>=W21),$P$2,IF(AND(NOT(V21=\"G\"),OR(O21=\"H\",O21=\"M\"),OR(U21=\"H\",U21=\"M\"),$O$2>=W21),$O$2,IF(AND(NOT(V21=\"G\"),OR(N21=\"H\",N21=\"M\"),OR(U21=\"H\",U21=\"M\"),$N$2>=W21),$N$2,IF(AND(NOT(V21=\"G\"),OR(M21=\"H\",M21=\"M\"),OR(U21=\"H\",U21=\"M\"),$M$2>=W21),$M$2,IF(AND(NOT(V21=\"G\"),OR(L21=\"H\",L21=\"M\"),OR(U21=\"H\",U21=\"M\"),$L$2>=W21),$L$2,IF(AND(NOT(V21=\"G\"),OR(K21=\"H\",K21=\"M\"),OR(U21=\"H\",U21=\"M\"),$K$2>=W21),$K$2,IF(AND(NOT(V21=\"G\"),OR(J21=\"H\",J21=\"M\"),OR(U21=\"H\",U21=\"M\"),$J$2>=W21),$J$2,DATEVALUE(\"01.01.1900\")))))))))))+14","v":"1900-01-15"},null,null,null,{"$f":"$G$3*IF(I21=\"H\",$AD$2,IF(I21=\"M\",$AE$2,IF(OR(I21=\"G\",I21=\"L\"),$AF$2,0)))*IF(OR(AND(E21=\"Nr. 1\",$I$5=\"i\"),AND(E21=\"Nr. 2\",$I$7=\"i\"),AND(E21=\"Nr. 3\",$I$9=\"i\"),AND(E21=\"Nr. 4\",$I$11=\"i\"),AND(E21=\"Nr. 5\",$I$13=\"i\"),AND(E21=\"Nr. 6\",$I$15=\"i\"),AND(E21=\"Nr. 7\",$I$17=\"i\"),AND(E21=\"Nr. 8\",$I$19=\"i\")),1,0)","v":0},{"$f":"$H$3*IF(J21=\"H\",$AD$2,IF(J21=\"M\",$AE$2,IF(OR(J21=\"G\",J21=\"L\"),$AF$2,0)))*IF(OR(AND(E21=\"Nr. 1\",$J$5=\"i\"),AND(E21=\"Nr. 2\",$J$7=\"i\"),AND(E21=\"Nr. 3\",$J$9=\"i\"),AND(E21=\"Nr. 4\",$J$11=\"i\"),AND(E21=\"Nr. 5\",$J$13=\"i\"),AND(E21=\"Nr. 6\",$J$15=\"i\"),AND(E21=\"Nr. 7\",$J$17=\"i\"),AND(E21=\"Nr. 8\",$J$19=\"i\")),1,0)","v":0},{"$f":"$I$3*IF(K21=\"H\",$AD$2,IF(K21=\"M\",$AE$2,IF(OR(K21=\"G\",K21=\"L\"),$AF$2,0)))*IF(OR(AND(E21=\"Nr. 1\",$K$5=\"i\"),AND(E21=\"Nr. 2\",$K$7=\"i\"),AND(E21=\"Nr. 3\",$K$9=\"i\"),AND(E21=\"Nr. 4\",$K$11=\"i\"),AND(E21=\"Nr. 5\",$K$13=\"i\"),AND(E21=\"Nr. 6\",$K$15=\"i\"),AND(E21=\"Nr. 7\",$K$17=\"i\"),AND(E21=\"Nr. 8\",$K$19=\"i\")),1,0)","v":0},{"$f":"$J$3*IF(L21=\"H\",$AD$2,IF(L21=\"M\",$AE$2,IF(OR(L21=\"G\",L21=\"L\"),$AF$2,0)))*IF(OR(AND(E21=\"Nr. 1\",$L$5=\"i\"),AND(E21=\"Nr. 2\",$L$7=\"i\"),AND(E21=\"Nr. 3\",$L$9=\"i\"),AND(E21=\"Nr. 4\",$L$11=\"i\"),AND(E21=\"Nr. 5\",$L$13=\"i\"),AND(E21=\"Nr. 6\",$L$15=\"i\"),AND(E21=\"Nr. 7\",$L$17=\"i\"),AND(E21=\"Nr. 8\",$L$19=\"i\")),1,0)","v":0},{"$f":"$K$3*IF(M21=\"H\",$AD$2,IF(M21=\"M\",$AE$2,IF(OR(M21=\"G\",M21=\"L\"),$AF$2,0)))*IF(OR(AND(E21=\"Nr. 1\",$M$5=\"i\"),AND(E21=\"Nr. 2\",$M$7=\"i\"),AND(E21=\"Nr. 3\",$M$9=\"i\"),AND(E21=\"Nr. 4\",$M$11=\"i\"),AND(E21=\"Nr. 5\",$M$13=\"i\"),AND(E21=\"Nr. 6\",$M$15=\"i\"),AND(E21=\"Nr. 7\",$M$17=\"i\"),AND(E21=\"Nr. 8\",$M$19=\"i\")),1,0)","v":0},{"$f":"$L$3*IF(N21=\"H\",$AD$2,IF(N21=\"M\",$AE$2,IF(OR(N21=\"G\",N21=\"L\"),$AF$2,0)))*IF(OR(AND(E21=\"Nr. 1\",$N$5=\"i\"),AND(E21=\"Nr. 2\",$N$7=\"i\"),AND(E21=\"Nr. 3\",$N$9=\"i\"),AND(E21=\"Nr. 4\",$N$11=\"i\"),AND(E21=\"Nr. 5\",$N$13=\"i\"),AND(E21=\"Nr. 6\",$N$15=\"i\"),AND(E21=\"Nr. 7\",$N$17=\"i\"),AND(E21=\"Nr. 8\",$N$19=\"i\")),1,0)","v":0},{"$f":"$M$3*IF(O21=\"H\",$AD$2,IF(O21=\"M\",$AE$2,IF(OR(O21=\"G\",O21=\"L\"),$AF$2,0)))*IF(OR(AND(E21=\"Nr. 1\",$O$5=\"i\"),AND(E21=\"Nr. 2\",$O$7=\"i\"),AND(E21=\"Nr. 3\",$O$9=\"i\"),AND(E21=\"Nr. 4\",$O$11=\"i\"),AND(E21=\"Nr. 5\",$O$13=\"i\"),AND(E21=\"Nr. 6\",$O$15=\"i\"),AND(E21=\"Nr. 7\",$O$17=\"i\"),AND(E21=\"Nr. 8\",$O$19=\"i\")),1,0)","v":0},{"$f":"$N$3*IF(P21=\"H\",$AD$2,IF(P21=\"M\",$AE$2,IF(OR(P21=\"G\",P21=\"L\"),$AF$2,0)))*IF(OR(AND(E21=\"Nr. 1\",$P$5=\"i\"),AND(E21=\"Nr. 2\",$P$7=\"i\"),AND(E21=\"Nr. 3\",$P$9=\"i\"),AND(E21=\"Nr. 4\",$P$11=\"i\"),AND(E21=\"Nr. 5\",$P$13=\"i\"),AND(E21=\"Nr. 6\",$P$15=\"i\"),AND(E21=\"Nr. 7\",$P$17=\"i\"),AND(E21=\"Nr. 8\",$P$19=\"i\")),1,0)","v":0},{"$f":"SUM(AF21:AM21)","v":0},{"$f":"AN21*IF(E21=\"Nr. 1\",$AO$4,IF(E21=\"Nr. 2\",$AO$6,IF(E21=\"Nr. 3\",$AO$8,IF(E21=\"Nr. 4\",$AO$10,IF(E21=\"Nr. 5\",$AO$12,IF(E21=\"Nr. 6\",$AO$14,IF(E21=\"Nr. 7\",$AO$16,IF(E21=\"Nr. 8\",$AO$18,0))))))))","v":0},{"$f":"AN21*Risk_Analysis!$T$1","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($G$22=\"H\",$H$22=\"H\",$I$22=\"H\",$J$22=\"H\",$K$22=\"H\",$L$22=\"H\",$M$22=\"H\",$N$22=\"H\",$O$22=\"H\",$P$22=\"H\",$Q$22=\"H\",$R$22=\"H\",$S$22=\"H\"),\"H\",IF(OR($G$22=\"M\",$H$22=\"M\",$I$22=\"M\",$J$22=\"M\",$K$22=\"M\",$L$22=\"M\",$M$22=\"M\",$N$22=\"M\",$O$22=\"M\",$P$22=\"M\",$Q$22=\"M\",$R$22=\"M\",$S$22=\"M\"),\"M\",IF(OR($G$22=\"G\",$H$22=\"G\",$I$22=\"G\",$J$22=\"G\",$K$22=\"G\",$L$22=\"G\",$M$22=\"G\",$N$22=\"G\",$O$22=\"G\",$P$22=\"G\",$Q$22=\"G\",$R$22=\"G\",$S$22=\"G\"),\"G\",\"\")))","v":""},{"$f":"IF($E$22=\"Nr. 1\",$U$4,IF($E$22=\"Nr. 2\",$U$6,IF($E$22=\"Nr. 3\",$U$8,IF($E$22=\"Nr. 4\",$U$10,IF($E$22=\"Nr. 5\",$U$12,IF($E$22=\"Nr. 6\",$U$14,IF($E$22=\"Nr. 7\",$U$16,IF($E$22=\"Nr. 8\",$U$18,\"\"))))))))","v":""},{"$f":"IF(E22=\"Nr. 1\",$V$4,IF(E22=\"Nr. 2\",$V$6,IF(E22=\"Nr. 3\",$V$8,IF(E22=\"Nr. 4\",$V$10,IF(E22=\"Nr. 5\",$V$12,IF(E22=\"Nr. 6\",$V$14,IF(E22=\"Nr. 7\",$V$16,IF(E22=\"Nr. 8\",$V$18,DATEVALUE(\"01.01.1900\")))))))))","v":"1900-01-01"},{"$f":"IF(E22=\"Nr. 1\",$W$4,IF(E22=\"Nr. 2\",$W$6,IF(E22=\"Nr. 3\",$W$8,IF(E22=\"Nr. 4\",$W$10,IF(E22=\"Nr. 5\",$W$12,IF(E22=\"Nr. 6\",$W$14,IF(E22=\"Nr. 7\",$W$16,IF(E22=\"Nr. 8\",$W$18,DATEVALUE(\"01.01.1900\")))))))))","v":"1900-01-01"},{"$f":"IF(AND(NOT(ISBLANK(I22)),$I$2>=W22),$I$2,IF(AND(NOT(ISBLANK(J22)),$J$2>=W22),$J$2,IF(AND(NOT(ISBLANK(K22)),$K$2>=W22),$K$2,IF(AND(NOT(ISBLANK(L22)),$L$2>=W22),$L$2,IF(AND(NOT(ISBLANK(M22)),$M$2>=W22),$M$2,IF(AND(NOT(ISBLANK(N22)),$N$2>=W22),$N$2,IF(AND(NOT(ISBLANK(O22)),$O$2>=W22),$O$2,IF(AND(NOT(ISBLANK(P22)),$P$2>=W22),$P$2,IF(AND(NOT(ISBLANK(Q22)),$Q$2>=W22),$Q$2,IF(AND(NOT(ISBLANK(R22)),$R$2>=W22),$R$2,IF(AND(NOT(ISBLANK(S22)),$S$2>=W22),$S$2,DATEVALUE(\"01.01.1900\"))))))))))))+2","v":"1900-01-03"},{"$f":"IF(AND(NOT(ISBLANK(S22)),$S$2>=W22),$S$2,IF(AND(NOT(ISBLANK(R22)),$R$2>=W22),$R$2,IF(AND(NOT(ISBLANK(Q22)),$Q$2>=W22),$Q$2,IF(AND(NOT(ISBLANK(P22)),$P$2>=W22),$P$2,IF(AND(NOT(ISBLANK(O22)),$O$2>=W22),$O$2,IF(AND(NOT(ISBLANK(N22)),$N$2>=W22),$N$2,IF(AND(NOT(ISBLANK(M22)),$M$2>=W22),$M$2,IF(AND(NOT(ISBLANK(L22)),$L$2>=W22),$L$2,IF(AND(NOT(ISBLANK(K22)),$K$2>=W22),$K$2,IF(AND(NOT(ISBLANK(J22)),$J$2>=W22),$J$2,IF(AND(NOT(ISBLANK(I22)),$I$2>=W22),$I$2,DATEVALUE(\"01.01.1900\"))))))))))))+14","v":"1900-01-15"},{"$f":"IF(AND(OR(J22=\"H\",J22=\"M\"),OR(V22=\"H\",V22=\"M\"),$J$2>=W22),$J$2,IF(AND(OR(K22=\"H\",K22=\"M\"),OR(V22=\"H\",V22=\"M\"),$K$2>=W22),$K$2,IF(AND(OR(L22=\"H\",L22=\"M\"),OR(V22=\"H\",V22=\"M\"),$L$2>=W22),$L$2,IF(AND(OR(M22=\"H\",M22=\"M\"),OR(V22=\"H\",V22=\"M\"),$M$2>=W22),$M$2,IF(AND(OR(N22=\"H\",N22=\"M\"),OR(V22=\"H\",V22=\"M\"),$N$2>=W22),$N$2,IF(AND(OR(O22=\"H\",O22=\"M\"),OR(V22=\"H\",V22=\"M\"),$O$2>=W22),O3,IF(AND(OR(P22=\"H\",P22=\"M\"),OR(V22=\"H\",V22=\"M\"),$P$2>=W22),$P$2,IF(AND(OR(Q22=\"H\",Q22=\"M\"),OR(V22=\"H\",V22=\"M\"),$Q$2>=W22),$Q$2,IF(AND(OR(R22=\"H\",R22=\"M\"),OR(V22=\"H\",V22=\"M\"),$R$2>=W22),$R$2,IF(AND(OR(S22=\"H\",S22=\"M\"),OR(V22=\"H\",V22=\"M\"),$S$2>=W22),$S$2,DATEVALUE(\"01.01.1900\")))))))))))+3","v":"1900-01-04"},"1900-01-15",null,null,null,{"$f":"$G$3*IF(I22=\"H\",$AD$2,IF(I22=\"M\",$AE$2,IF(OR(I22=\"G\",I22=\"L\"),$AF$2,0)))*IF(OR(AND(E22=\"Nr. 1\",$I$5=\"i\"),AND(E22=\"Nr. 2\",$I$7=\"i\"),AND(E22=\"Nr. 3\",$I$9=\"i\"),AND(E22=\"Nr. 4\",$I$11=\"i\"),AND(E22=\"Nr. 5\",$I$13=\"i\"),AND(E22=\"Nr. 6\",$I$15=\"i\"),AND(E22=\"Nr. 7\",$I$17=\"i\"),AND(E22=\"Nr. 8\",$I$19=\"i\")),1,0)","v":0},{"$f":"$H$3*IF(J22=\"H\",$AD$2,IF(J22=\"M\",$AE$2,IF(OR(J22=\"G\",J22=\"L\"),$AF$2,0)))*IF(OR(AND(E22=\"Nr. 1\",$J$5=\"i\"),AND(E22=\"Nr. 2\",$J$7=\"i\"),AND(E22=\"Nr. 3\",$J$9=\"i\"),AND(E22=\"Nr. 4\",$J$11=\"i\"),AND(E22=\"Nr. 5\",$J$13=\"i\"),AND(E22=\"Nr. 6\",$J$15=\"i\"),AND(E22=\"Nr. 7\",$J$17=\"i\"),AND(E22=\"Nr. 8\",$J$19=\"i\")),1,0)","v":0},{"$f":"$I$3*IF(K22=\"H\",$AD$2,IF(K22=\"M\",$AE$2,IF(OR(K22=\"G\",K22=\"L\"),$AF$2,0)))*IF(OR(AND(E22=\"Nr. 1\",$K$5=\"i\"),AND(E22=\"Nr. 2\",$K$7=\"i\"),AND(E22=\"Nr. 3\",$K$9=\"i\"),AND(E22=\"Nr. 4\",$K$11=\"i\"),AND(E22=\"Nr. 5\",$K$13=\"i\"),AND(E22=\"Nr. 6\",$K$15=\"i\"),AND(E22=\"Nr. 7\",$K$17=\"i\"),AND(E22=\"Nr. 8\",$K$19=\"i\")),1,0)","v":0},{"$f":"$J$3*IF(L22=\"H\",$AD$2,IF(L22=\"M\",$AE$2,IF(OR(L22=\"G\",L22=\"L\"),$AF$2,0)))*IF(OR(AND(E22=\"Nr. 1\",$L$5=\"i\"),AND(E22=\"Nr. 2\",$L$7=\"i\"),AND(E22=\"Nr. 3\",$L$9=\"i\"),AND(E22=\"Nr. 4\",$L$11=\"i\"),AND(E22=\"Nr. 5\",$L$13=\"i\"),AND(E22=\"Nr. 6\",$L$15=\"i\"),AND(E22=\"Nr. 7\",$L$17=\"i\"),AND(E22=\"Nr. 8\",$L$19=\"i\")),1,0)","v":0},{"$f":"$K$3*IF(M22=\"H\",$AD$2,IF(M22=\"M\",$AE$2,IF(OR(M22=\"G\",M22=\"L\"),$AF$2,0)))*IF(OR(AND(E22=\"Nr. 1\",$M$5=\"i\"),AND(E22=\"Nr. 2\",$M$7=\"i\"),AND(E22=\"Nr. 3\",$M$9=\"i\"),AND(E22=\"Nr. 4\",$M$11=\"i\"),AND(E22=\"Nr. 5\",$M$13=\"i\"),AND(E22=\"Nr. 6\",$M$15=\"i\"),AND(E22=\"Nr. 7\",$M$17=\"i\"),AND(E22=\"Nr. 8\",$M$19=\"i\")),1,0)","v":0},{"$f":"$L$3*IF(N22=\"H\",$AD$2,IF(N22=\"M\",$AE$2,IF(OR(N22=\"G\",N22=\"L\"),$AF$2,0)))*IF(OR(AND(E22=\"Nr. 1\",$N$5=\"i\"),AND(E22=\"Nr. 2\",$N$7=\"i\"),AND(E22=\"Nr. 3\",$N$9=\"i\"),AND(E22=\"Nr. 4\",$N$11=\"i\"),AND(E22=\"Nr. 5\",$N$13=\"i\"),AND(E22=\"Nr. 6\",$N$15=\"i\"),AND(E22=\"Nr. 7\",$N$17=\"i\"),AND(E22=\"Nr. 8\",$N$19=\"i\")),1,0)","v":0},{"$f":"$M$3*IF(O22=\"H\",$AD$2,IF(O22=\"M\",$AE$2,IF(OR(O22=\"G\",O22=\"L\"),$AF$2,0)))*IF(OR(AND(E22=\"Nr. 1\",$O$5=\"i\"),AND(E22=\"Nr. 2\",$O$7=\"i\"),AND(E22=\"Nr. 3\",$O$9=\"i\"),AND(E22=\"Nr. 4\",$O$11=\"i\"),AND(E22=\"Nr. 5\",$O$13=\"i\"),AND(E22=\"Nr. 6\",$O$15=\"i\"),AND(E22=\"Nr. 7\",$O$17=\"i\"),AND(E22=\"Nr. 8\",$O$19=\"i\")),1,0)","v":0},{"$f":"$N$3*IF(P22=\"H\",$AD$2,IF(P22=\"M\",$AE$2,IF(OR(P22=\"G\",P22=\"L\"),$AF$2,0)))*IF(OR(AND(E22=\"Nr. 1\",$P$5=\"i\"),AND(E22=\"Nr. 2\",$P$7=\"i\"),AND(E22=\"Nr. 3\",$P$9=\"i\"),AND(E22=\"Nr. 4\",$P$11=\"i\"),AND(E22=\"Nr. 5\",$P$13=\"i\"),AND(E22=\"Nr. 6\",$P$15=\"i\"),AND(E22=\"Nr. 7\",$P$17=\"i\"),AND(E22=\"Nr. 8\",$P$19=\"i\")),1,0)","v":0},{"$f":"SUM(AF22:AM22)","v":0},{"$f":"AN22*IF(E22=\"Nr. 1\",$AO$4,IF(E22=\"Nr. 2\",$AO$6,IF(E22=\"Nr. 3\",$AO$8,IF(E22=\"Nr. 4\",$AO$10,IF(E22=\"Nr. 5\",$AO$12,IF(E22=\"Nr. 6\",$AO$14,IF(E22=\"Nr. 7\",$AO$16,IF(E22=\"Nr. 8\",$AO$18,0))))))))","v":0},{"$f":"AN22*Risk_Analysis!$T$1","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($G$23=\"H\",$H$23=\"H\",$I$23=\"H\",$J$23=\"H\",$K$23=\"H\",$L$23=\"H\",$M$23=\"H\",$N$23=\"H\",$O$23=\"H\",$P$23=\"H\",$Q$23=\"H\",$R$23=\"H\",$S$23=\"H\"),\"H\",IF(OR($G$23=\"M\",$H$23=\"M\",$I$23=\"M\",$J$23=\"M\",$K$23=\"M\",$L$23=\"M\",$M$23=\"M\",$N$23=\"M\",$O$23=\"M\",$P$23=\"M\",$Q$23=\"M\",$R$23=\"M\",$S$23=\"M\"),\"M\",IF(OR($G$23=\"G\",$H$23=\"G\",$I$23=\"G\",$J$23=\"G\",$K$23=\"G\",$L$23=\"G\",$M$23=\"G\",$N$23=\"G\",$O$23=\"G\",$P$23=\"G\",$Q$23=\"G\",$R$23=\"G\",$S$23=\"G\"),\"G\",\"\")))","v":""},{"$f":"IF($E$23=\"Nr. 1\",$U$4,IF($E$23=\"Nr. 2\",$U$6,IF($E$23=\"Nr. 3\",$U$8,IF($E$23=\"Nr. 4\",$U$10,IF($E$23=\"Nr. 5\",$U$12,IF($E$23=\"Nr. 6\",$U$14,IF($E$23=\"Nr. 7\",$U$16,IF($E$23=\"Nr. 8\",$U$18,\"\"))))))))","v":""},"1900-01-01","1900-01-01","1900-01-03","1900-01-15","1900-01-04","1900-01-15",null,null,null,{"$f":"$G$3*IF(I23=\"H\",$AD$2,IF(I23=\"M\",$AE$2,IF(OR(I23=\"G\",I23=\"L\"),$AF$2,0)))*IF(OR(AND(E23=\"Nr. 1\",$I$5=\"i\"),AND(E23=\"Nr. 2\",$I$7=\"i\"),AND(E23=\"Nr. 3\",$I$9=\"i\"),AND(E23=\"Nr. 4\",$I$11=\"i\"),AND(E23=\"Nr. 5\",$I$13=\"i\"),AND(E23=\"Nr. 6\",$I$15=\"i\"),AND(E23=\"Nr. 7\",$I$17=\"i\"),AND(E23=\"Nr. 8\",$I$19=\"i\")),1,0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"AN23*Risk_Analysis!$T$1","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($G$24=\"H\",$H$24=\"H\",$I$24=\"H\",$J$24=\"H\",$K$24=\"H\",$L$24=\"H\",$M$24=\"H\",$N$24=\"H\",$O$24=\"H\",$P$24=\"H\",$Q$24=\"H\",$R$24=\"H\",$S$24=\"H\"),\"H\",IF(OR($G$24=\"M\",$H$24=\"M\",$I$24=\"M\",$J$24=\"M\",$K$24=\"M\",$L$24=\"M\",$M$24=\"M\",$N$24=\"M\",$O$24=\"M\",$P$24=\"M\",$Q$24=\"M\",$R$24=\"M\",$S$24=\"M\"),\"M\",IF(OR($G$24=\"G\",$H$24=\"G\",$I$24=\"G\",$J$24=\"G\",$K$24=\"G\",$L$24=\"G\",$M$24=\"G\",$N$24=\"G\",$O$24=\"G\",$P$24=\"G\",$Q$24=\"G\",$R$24=\"G\",$S$24=\"G\"),\"G\",\"\")))","v":""},{"$f":"IF($E$24=\"Nr. 1\",$U$4,IF($E$24=\"Nr. 2\",$U$6,IF($E$24=\"Nr. 3\",$U$8,IF($E$24=\"Nr. 4\",$U$10,IF($E$24=\"Nr. 5\",$U$12,IF($E$24=\"Nr. 6\",$U$14,IF($E$24=\"Nr. 7\",$U$16,IF($E$24=\"Nr. 8\",$U$18,\"\"))))))))","v":""},"1900-01-01","1900-01-01","1900-01-03","1900-01-15","1900-01-04","1900-01-15",null,null,null,0,0,0,0,0,0,0,0,0,0,{"$f":"AN24*Risk_Analysis!$T$1","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($G$25=\"H\",$H$25=\"H\",$I$25=\"H\",$J$25=\"H\",$K$25=\"H\",$L$25=\"H\",$M$25=\"H\",$N$25=\"H\",$O$25=\"H\",$P$25=\"H\",$Q$25=\"H\",$R$25=\"H\",$S$25=\"H\"),\"H\",IF(OR($G$25=\"M\",$H$25=\"M\",$I$25=\"M\",$J$25=\"M\",$K$25=\"M\",$L$25=\"M\",$M$25=\"M\",$N$25=\"M\",$O$25=\"M\",$P$25=\"M\",$Q$25=\"M\",$R$25=\"M\",$S$25=\"M\"),\"M\",IF(OR($G$25=\"G\",$H$25=\"G\",$I$25=\"G\",$J$25=\"G\",$K$25=\"G\",$L$25=\"G\",$M$25=\"G\",$N$25=\"G\",$O$25=\"G\",$P$25=\"G\",$Q$25=\"G\",$R$25=\"G\",$S$25=\"G\"),\"G\",\"\")))","v":""},{"$f":"IF($E$25=\"Nr. 1\",$U$4,IF($E$25=\"Nr. 2\",$U$6,IF($E$25=\"Nr. 3\",$U$8,IF($E$25=\"Nr. 4\",$U$10,IF($E$25=\"Nr. 5\",$U$12,IF($E$25=\"Nr. 6\",$U$14,IF($E$25=\"Nr. 7\",$U$16,IF($E$25=\"Nr. 8\",$U$18,\"\"))))))))","v":""},"1900-01-01","1900-01-01","1900-01-03","1900-01-15","1900-01-04","1900-01-15",null,null,null,0,0,0,0,0,0,0,0,0,0,{"$f":"AN25*Risk_Analysis!$T$1","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($G$26=\"H\",$H$26=\"H\",$I$26=\"H\",$J$26=\"H\",$K$26=\"H\",$L$26=\"H\",$M$26=\"H\",$N$26=\"H\",$O$26=\"H\",$P$26=\"H\",$Q$26=\"H\",$R$26=\"H\",$S$26=\"H\"),\"H\",IF(OR($G$26=\"M\",$H$26=\"M\",$I$26=\"M\",$J$26=\"M\",$K$26=\"M\",$L$26=\"M\",$M$26=\"M\",$N$26=\"M\",$O$26=\"M\",$P$26=\"M\",$Q$26=\"M\",$R$26=\"M\",$S$26=\"M\"),\"M\",IF(OR($G$26=\"G\",$H$26=\"G\",$I$26=\"G\",$J$26=\"G\",$K$26=\"G\",$L$26=\"G\",$M$26=\"G\",$N$26=\"G\",$O$26=\"G\",$P$26=\"G\",$Q$26=\"G\",$R$26=\"G\",$S$26=\"G\"),\"G\",\"\")))","v":""},{"$f":"IF($E$26=\"Nr. 1\",$U$4,IF($E$26=\"Nr. 2\",$U$6,IF($E$26=\"Nr. 3\",$U$8,IF($E$26=\"Nr. 4\",$U$10,IF($E$26=\"Nr. 5\",$U$12,IF($E$26=\"Nr. 6\",$U$14,IF($E$26=\"Nr. 7\",$U$16,IF($E$26=\"Nr. 8\",$U$18,\"\"))))))))","v":""},"1900-01-01","1900-01-01","1900-01-03","1900-01-15","1900-01-04","1900-01-15",null,null,null,0,0,0,0,0,0,0,0,0,0,{"$f":"AN26*Risk_Analysis!$T$1","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($G$27=\"H\",$H$27=\"H\",$I$27=\"H\",$J$27=\"H\",$K$27=\"H\",$L$27=\"H\",$M$27=\"H\",$N$27=\"H\",$O$27=\"H\",$P$27=\"H\",$Q$27=\"H\",$R$27=\"H\",$S$27=\"H\"),\"H\",IF(OR($G$27=\"M\",$H$27=\"M\",$I$27=\"M\",$J$27=\"M\",$K$27=\"M\",$L$27=\"M\",$M$27=\"M\",$N$27=\"M\",$O$27=\"M\",$P$27=\"M\",$Q$27=\"M\",$R$27=\"M\",$S$27=\"M\"),\"M\",IF(OR($G$27=\"G\",$H$27=\"G\",$I$27=\"G\",$J$27=\"G\",$K$27=\"G\",$L$27=\"G\",$M$27=\"G\",$N$27=\"G\",$O$27=\"G\",$P$27=\"G\",$Q$27=\"G\",$R$27=\"G\",$S$27=\"G\"),\"G\",\"\")))","v":""},{"$f":"IF($E$27=\"Nr. 1\",$U$4,IF($E$27=\"Nr. 2\",$U$6,IF($E$27=\"Nr. 3\",$U$8,IF($E$27=\"Nr. 4\",$U$10,IF($E$27=\"Nr. 5\",$U$12,IF($E$27=\"Nr. 6\",$U$14,IF($E$27=\"Nr. 7\",$U$16,IF($E$27=\"Nr. 8\",$U$18,\"\"))))))))","v":""},"1900-01-01","1900-01-01","1900-01-03","1900-01-15","1900-01-04","1900-01-15",null,null,null,0,0,0,0,0,0,0,0,0,0,{"$f":"AN27*Risk_Analysis!$T$1","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($G$28=\"H\",$H$28=\"H\",$I$28=\"H\",$J$28=\"H\",$K$28=\"H\",$L$28=\"H\",$M$28=\"H\",$N$28=\"H\",$O$28=\"H\",$P$28=\"H\",$Q$28=\"H\",$R$28=\"H\",$S$28=\"H\"),\"H\",IF(OR($G$28=\"M\",$H$28=\"M\",$I$28=\"M\",$J$28=\"M\",$K$28=\"M\",$L$28=\"M\",$M$28=\"M\",$N$28=\"M\",$O$28=\"M\",$P$28=\"M\",$Q$28=\"M\",$R$28=\"M\",$S$28=\"M\"),\"M\",IF(OR($G$28=\"G\",$H$28=\"G\",$I$28=\"G\",$J$28=\"G\",$K$28=\"G\",$L$28=\"G\",$M$28=\"G\",$N$28=\"G\",$O$28=\"G\",$P$28=\"G\",$Q$28=\"G\",$R$28=\"G\",$S$28=\"G\"),\"G\",\"\")))","v":""},{"$f":"IF($E$28=\"Nr. 1\",$U$4,IF($E$28=\"Nr. 2\",$U$6,IF($E$28=\"Nr. 3\",$U$8,IF($E$28=\"Nr. 4\",$U$10,IF($E$28=\"Nr. 5\",$U$12,IF($E$28=\"Nr. 6\",$U$14,IF($E$28=\"Nr. 7\",$U$16,IF($E$28=\"Nr. 8\",$U$18,\"\"))))))))","v":""},"1900-01-01","1900-01-01","1900-01-03","1900-01-15","1900-01-04","1900-01-15",null,null,null,0,0,0,0,0,0,0,0,0,0,{"$f":"AN28*Risk_Analysis!$T$1","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($G$29=\"H\",$H$29=\"H\",$I$29=\"H\",$J$29=\"H\",$K$29=\"H\",$L$29=\"H\",$M$29=\"H\",$N$29=\"H\",$O$29=\"H\",$P$29=\"H\",$Q$29=\"H\",$R$29=\"H\",$S$29=\"H\"),\"H\",IF(OR($G$29=\"M\",$H$29=\"M\",$I$29=\"M\",$J$29=\"M\",$K$29=\"M\",$L$29=\"M\",$M$29=\"M\",$N$29=\"M\",$O$29=\"M\",$P$29=\"M\",$Q$29=\"M\",$R$29=\"M\",$S$29=\"M\"),\"M\",IF(OR($G$29=\"G\",$H$29=\"G\",$I$29=\"G\",$J$29=\"G\",$K$29=\"G\",$L$29=\"G\",$M$29=\"G\",$N$29=\"G\",$O$29=\"G\",$P$29=\"G\",$Q$29=\"G\",$R$29=\"G\",$S$29=\"G\"),\"G\",\"\")))","v":""},{"$f":"IF($E$29=\"Nr. 1\",$U$4,IF($E$29=\"Nr. 2\",$U$6,IF($E$29=\"Nr. 3\",$U$8,IF($E$29=\"Nr. 4\",$U$10,IF($E$29=\"Nr. 5\",$U$12,IF($E$29=\"Nr. 6\",$U$14,IF($E$29=\"Nr. 7\",$U$16,IF($E$29=\"Nr. 8\",$U$18,\"\"))))))))","v":""},"1900-01-01","1900-01-01","1900-01-03","1900-01-15","1900-01-04","1900-01-15",null,null,null,0,0,0,0,0,0,0,0,0,0,{"$f":"AN29*Risk_Analysis!$T$1","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($G$30=\"H\",$H$30=\"H\",$I$30=\"H\",$J$30=\"H\",$K$30=\"H\",$L$30=\"H\",$M$30=\"H\",$N$30=\"H\",$O$30=\"H\",$P$30=\"H\",$Q$30=\"H\",$R$30=\"H\",$S$30=\"H\"),\"H\",IF(OR($G$30=\"M\",$H$30=\"M\",$I$30=\"M\",$J$30=\"M\",$K$30=\"M\",$L$30=\"M\",$M$30=\"M\",$N$30=\"M\",$O$30=\"M\",$P$30=\"M\",$Q$30=\"M\",$R$30=\"M\",$S$30=\"M\"),\"M\",IF(OR($G$30=\"G\",$H$30=\"G\",$I$30=\"G\",$J$30=\"G\",$K$30=\"G\",$L$30=\"G\",$M$30=\"G\",$N$30=\"G\",$O$30=\"G\",$P$30=\"G\",$Q$30=\"G\",$R$30=\"G\",$S$30=\"G\"),\"G\",\"\")))","v":""},{"$f":"IF($E$30=\"Nr. 1\",$U$4,IF($E$30=\"Nr. 2\",$U$6,IF($E$30=\"Nr. 3\",$U$8,IF($E$30=\"Nr. 4\",$U$10,IF($E$30=\"Nr. 5\",$U$12,IF($E$30=\"Nr. 6\",$U$14,IF($E$30=\"Nr. 7\",$U$16,IF($E$30=\"Nr. 8\",$U$18,\"\"))))))))","v":""},"1900-01-01","1900-01-01","1900-01-03","1900-01-15","1900-01-04","1900-01-15",null,null,null,0,0,0,0,0,0,0,0,0,0,{"$f":"AN30*Risk_Analysis!$T$1","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AN21:AN30)","v":0},{"$f":"SUM(AO21:AO30)","v":0},{"$f":"SUM(AP21:AP30)","v":0}]
[null,null,null,null,"<C> Dr. med. Andreas Paaßen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Übertrage-","Theor. Risiko"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nes Risiko","zur Berechn."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quarantäne"]

{"sheet":"Risk_Analysis","index":2,"n_rows":22,"n_cols":27,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,"Risk Analysis - Dashboard",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Basis-R",{"$f":"Settings!G7*$K$3/100","v":3.75},{"$f":"Contacts!$U$1*100","v":0.25},"Step A: Isolation source case",null,null,"Wild Type ",100," "]
[null,"Number of additional persons in the immediate labour/social sector:",null,null,null,null,0,null,"Virus Variant: ",null,"B 1.1.7 (England)",null,null,null,null,null,null,null,null,null,{"$f":"Contacts!$U$2*100","v":1.4578579999999999},"Step B: Quarantine direct Contacts",null,null,"B 1.1.7 (England)",150," "]
[null,"Security of complete contact determination:",null,null,null,null,"high",null,"Specific infectivity:",null,{"$f":"INDEX($Y$1:$Z$5,MATCH(K2,$Y$1:$Y$5,0),2)","v":150},"%",{"$f":"INDEX($Y$1:$AA$5,MATCH(K2,$Y$1:$Y$5,0),3)","v":" "},null,null,"What does that mean?",null,null,null,null,{"$f":"Contacts!$U$3*100","v":23.004118000000002},"Step C: Quarantine indirect Contacts",null,null,"B 1.351 (South Africa)",150,"nicht gesichert"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U1:U3)/3","v":8.2373253333333327},"Total Effectivity",null,null,"B 1.1.28 (Brasilia)",150,"nicht gesichert"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U4<70,\"The effectiveness of the measures is\",\"The effectiveness of measures by\")","v":"The effectiveness of the measures is"},null,null,null,null,null,"Sicherheit Effektivitätsberechnung",null,null,"B 1.427 (California)",135,"nicht gesichert"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U4<70,\"not optimal, as they were\",\"shortening the infectious time is good. \")","v":"not optimal, as they were"},null,null,null,null,null,"Sicherheit R-Berechnung",null,null,"B 1.526 (New York)",135,"nicht gesichert"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U4<70,\"introduced (too) late.\",\"They were initiated at an early stage.\")","v":"introduced (too) late."},null,null,null,null,null,null,null,null,"Andere",100,"nicht gesichert"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Contacts!$AN$20","v":0},"Übertragenes Risiko Stufe B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Risk_Analysis!U13>1,\"The reproduction number step C is\",\"The reproduction number step C is\")","v":"The reproduction number step C is"},null,null,null,null,{"$f":"Contacts!$AO$31","v":0},"Übertragenes Risiko Stufe C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Risk_Analysis!U13>1,\"greater than 1 and therefore too high!\",\"uncritical.\")","v":"uncritical."},null,null,null,null,{"$f":"$T$1","v":3.75},null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T1*(1-U1/100)","v":3.7406250000000001},"Step A",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Extended Measurements (dotted line):",null,null,null,null,{"$f":"U8*T1+IF(G3=\"sicher\",U16,IF(G3=\"mittel\",U17,U18))","v":0},"Step B",1,{"$f":"U12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Risks of infection by contact persons",null,null,null,null,{"$f":"U9*T1+IF(OR(G3=\"sicher\",G3=\"high\"),U16,IF(OR(G3=\"mittel\",G3=\"medium\"),U17,U18))","v":0},"Step C",1,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"can be prevented by individual tests.",null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Contacts!$AG$2*$G$2*T1","v":0},"sicher"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U13-(U8*T1)>0.7,\"Die Risiken durch weitere Personen\",\"\")","v":""},null,null,null,null,{"$f":"U16*2","v":0},"mittel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U13-(U8*T1)>0.7,\"im Arbeits-/ Sozialbereich ist hoch!\",\"\")","v":""},null,null,null,null,{"$f":"U16*3","v":0},"unsicher"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U13-(U8*T1)>0.7,\"Prüfen einer arbeitstäglichen\",\"\")","v":""}]
[null,"Dotted line: Additional measures individual or group testing ",null,null,null,null,null,null,"The effectiveness indicates what proportion of infectious days can be avoided ",null,null,null,null,null,null,{"$f":"IF(U13-(U8*T1)>0.7,\"Gruppentestung! Dauer min. 10-14 Tage.\",\"\")","v":""}]
[null,"The reproduction number (R) indicates how many people can be statistically infected. ",null,null,null,null,null,null,"by isolation or quarantine. It is the lower the longer it takes after the "]
[null,"An R-value >1 indicates a multiplication (infection chain!)",null,null,null,null,null,null,"appearance of symptoms to initiate measures."]

{"sheet":"Measurements","index":3,"n_rows":25,"n_cols":16,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,4],[0,10,0,11],[0,6,0,7]]}
["Names","Possible Infectivity",null,"Isolation",null,"Info","Self or Contact Quarantine",null,"Info contact "," Initiation of Testing","Measurements Low Risk",null,null,null,"Infektiosität"]
[null,"from","to","from","to","Isolation","from","to","Quarantine","from","from","to",null,null,"Kontaktpers. ab"]
[null,{"$f":"Contacts!G2","v":"1900-01-01"},{"$f":"Contacts!S2+4","v":"1900-01-17"},{"$f":"IF(AND($N$3>B3,B3>DATEVALUE(\"01.01.2000\")),$N$3,B3)","v":"1900-01-01"},{"$f":"Contacts!S2+4","v":"1900-01-17"},"Yes",null,null,null,"immediately in case of suspicion",null,null,null,{"$f":"Basic_Data!F10","v":"00:00:00"}]
["Direct contacts"]
[{"$f":"IF(ISBLANK(Contacts!F4),\"\",Contacts!F4)","v":""},{"$f":"Contacts!$V$4","v":"1900-01-01"},{"$f":"Contacts!$W$4","v":"1900-01-15"},null,null,null,{"$f":"IF(Contacts!$AO$4>=0.1,$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},{"$f":"IF(G5>DATEVALUE(\"01.01.1900\"),C5,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},{"$f":"IF(G5>DATEVALUE(\"01.01.2000\"),\"yes\",\"\")","v":""},{"$f":"IF(B5>DATEVALUE(\"01.01.2000\"),$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},{"$f":"IF(AND(Contacts!$AO$4>=0.05,Contacts!$AO$4<0.1),$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},{"$f":"IF(K5>DATEVALUE(\"01.01.1900\"),C5,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"}]
[{"$f":"IF(ISBLANK(Contacts!F6),\"\",Contacts!F6)","v":""},{"$f":"Contacts!$V$6","v":"1900-01-01"},{"$f":"Contacts!$W$6","v":"1900-01-15"},null,null,null,{"$f":"IF(Contacts!$AO$6>=0.1,$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},{"$f":"IF(G6>DATEVALUE(\"01.01.1900\"),C6,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"","1900-01-01",{"$f":"IF(AND(Contacts!$AO$6>=0.05,Contacts!$AO$6<0.1),$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"1900-01-01"]
[{"$f":"IF(ISBLANK(Contacts!F8),\"\",Contacts!F8)","v":""},{"$f":"Contacts!$V$8","v":"1900-01-01"},{"$f":"Contacts!$W$8","v":"1900-01-15"},null,null,null,{"$f":"IF(Contacts!$AO$8>=0.1,$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"1900-01-01","","1900-01-01",{"$f":"IF(AND(Contacts!$AO$8>=0.05,Contacts!$AO$8<0.1),$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"1900-01-01"]
[{"$f":"IF(ISBLANK(Contacts!F10),\"\",Contacts!F10)","v":""},{"$f":"Contacts!$V$10","v":"1900-01-01"},{"$f":"Contacts!$W$10","v":"1900-01-15"},null,null,null,{"$f":"IF(Contacts!$AO$10>=0.1,$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"1900-01-01","","1900-01-01",{"$f":"IF(AND(Contacts!$AO$10>=0.05,Contacts!$AO$10<0.1),$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"1900-01-01"]
[{"$f":"IF(ISBLANK(Contacts!F12),\"\",Contacts!F12)","v":""},{"$f":"Contacts!$V$12","v":"1900-01-01"},{"$f":"Contacts!$W$12","v":"1900-01-15"},null,null,null,{"$f":"IF(Contacts!$AO$12>=0.1,$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"1900-01-01","","1900-01-01",{"$f":"IF(AND(Contacts!$AO$12>=0.05,Contacts!$AO$12<0.1),$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"1900-01-01"]
[{"$f":"IF(ISBLANK(Contacts!F14),\"\",Contacts!F14)","v":""},{"$f":"Contacts!$V$14","v":"1900-01-01"},{"$f":"Contacts!$W$14","v":"1900-01-15"},null,null,null,{"$f":"IF(Contacts!$AO$14>=0.1,$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"1900-01-01","","1900-01-01",{"$f":"IF(AND(Contacts!$AO$14>=0.05,Contacts!$AO$14<0.1),$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"1900-01-01"]
[{"$f":"IF(ISBLANK(Contacts!F16),\"\",Contacts!F16)","v":""},{"$f":"Contacts!$V$16","v":"1900-01-01"},{"$f":"Contacts!$W$16","v":"1900-01-15"},null,null,null,{"$f":"IF(Contacts!$AO$16>=0.1,$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"1900-01-01","","1900-01-01",{"$f":"IF(AND(Contacts!$AO$16>=0.05,Contacts!$AO$16<0.1),$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"1900-01-01"]
[{"$f":"IF(ISBLANK(Contacts!F18),\"\",Contacts!F18)","v":""},{"$f":"Contacts!$V$18","v":"1900-01-01"},{"$f":"Contacts!$W$18","v":"1900-01-15"},null,null,null,{"$f":"IF(Contacts!$AO$18>=0.1,$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"1900-01-01","","1900-01-01",{"$f":"IF(AND(Contacts!$AO$18>=0.05,Contacts!$AO$18<0.1),$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"1900-01-01"]
["Indirect contacts",null,null,null,null,null,"↓―――","―――――――","――――――","not in case of neg. test","―――↓"]
[{"$f":"IF(NOT(ISBLANK(Contacts!F21)),Contacts!F21,\"\")","v":""},{"$f":"IF(Contacts!$AP$21>=0.05,Contacts!Y21,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},{"$f":"IF(B14>DATEVALUE(\"01.01.2000\"),Contacts!Z21,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},null,null,null,{"$f":"IF(Contacts!$AP$21>=0.1,$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},{"$f":"IF(G14>DATEVALUE(\"01.01.1900\"),C14,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},{"$f":"IF(G14>DATEVALUE(\"01.01.2000\"),\"yes\",\"\")","v":""},{"$f":"IF(Contacts!$E$21=\"Nr. 1\",IF(AND($J$5>DATEVALUE(\"01.01.1900\"),OR(G14>DATEVALUE(\"01.01.2000\"),K14>DATEVALUE(\"01.01.2000\"))),$A$5,\"\"),IF(Contacts!$E$21=\"Nr. 2\",IF(AND($J$6>DATEVALUE(\"01.01.1900\"),OR(G14>DATEVALUE(\"01.01.2000\"),K14>DATEVALUE(\"01.01.2000\"))),$A$6,\"\"),IF(Contacts!$E$21=\"Nr. 3\",IF(AND($J$7>DATEVALUE(\"01.01.1900\"),OR(G14>DATEVALUE(\"01.01.2000\"),K14>DATEVALUE(\"01.01.2000\"))),$A$7,\"\"),IF(Contacts!$E$21=\"Nr. 4\",IF(AND($J$8>DATEVALUE(\"01.01.1900\"),OR(G14>DATEVALUE(\"01.01.2000\"),K14>DATEVALUE(\"01.01.2000\"))),$A$8,\"\"),IF(Contacts!$E$21=\"Nr. 5\",IF(AND($J$9>DATEVALUE(\"01.01.1900\"),OR(G14>DATEVALUE(\"01.01.2000\"),K14>DATEVALUE(\"01.01.2000\"))),$A$9,\"\"),IF(Contacts!$E$21=\"Nr. 6\",IF(AND($J$10>DATEVALUE(\"01.01.1900\"),OR(G14>DATEVALUE(\"01.01.2000\"),K14>DATEVALUE(\"01.01.2000\"))),$A$10,\"\"),IF(Contacts!$E$21=\"Nr. 7\",IF(AND($J$11>DATEVALUE(\"01.01.1900\"),OR(G14>DATEVALUE(\"01.01.2000\"),K14>DATEVALUE(\"01.01.2000\"))),$A$11,\"\"),IF(Contacts!$E$21=\"Nr. 8\",IF(AND($J$12>DATEVALUE(\"01.01.1900\"),OR(G14>DATEVALUE(\"01.01.2000\"),K14>DATEVALUE(\"01.01.2000\"))),$A$12,\"\"),\"\"))))))))","v":""},{"$f":"IF(AND(Contacts!$AP$21<0.1,Contacts!$AP$21>=0.05),$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},{"$f":"IF(K14>DATEVALUE(\"01.01.1900\"),C14,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},null,null,{"$f":"IF(Contacts!$E$21=\"Nr. 1\",$B$5,IF(Contacts!$E$21=\"Nr. 2\",$B$6,IF(Contacts!$E$21=\"Nr. 3\",$B$7,IF(Contacts!$E$21=\"Nr. 4\",$B$8,IF(Contacts!$E$21=\"Nr. 5\",$B$9,IF(Contacts!$E$21=\"Nr. 6\",$B$10,IF(Contacts!$E$21=\"Nr. 7\",$B$11,IF(Contacts!$E$21=\"Nr. 8\",$B$12,DATEVALUE(\"01.01.1900\")))))))))","v":"1900-01-01"},{"$f":"IF(Contacts!$E$21=\"Nr. 1\",Contacts!$U$4,IF(Contacts!$E$21=\"Nr. 2\",Contacts!$U$6,IF(Contacts!$E$21=\"Nr. 3\",Contacts!$U$8,IF(Contacts!$E$21=\"Nr. 4\",Contacts!$U$10,IF(Contacts!$E$21=\"Nr. 5\",Contacts!$U$12,IF(Contacts!$E$21=\"Nr. 6\",Contacts!$U$14,IF(Contacts!$E$21=\"Nr. 7\",Contacts!$U$16,IF(Contacts!$E$21=\"Nr. 8\",Contacts!$U$18,\"\"))))))))","v":""}]
[{"$f":"IF(NOT(ISBLANK(Contacts!F22)),Contacts!F22,\"\")","v":""},{"$f":"IF(Contacts!$AP$22>=0.05,Contacts!Y22,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},{"$f":"IF(B15>DATEVALUE(\"01.01.2000\"),Contacts!Z22,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},null,null,null,{"$f":"IF(Contacts!$AP$22>=0.1,$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},{"$f":"IF(G15>DATEVALUE(\"01.01.1900\"),C15,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"",{"$f":"IF(Contacts!$E$22=\"Nr. 1\",IF(AND($J$5>DATEVALUE(\"01.01.1900\"),OR(G15>DATEVALUE(\"01.01.2000\"),K15>DATEVALUE(\"01.01.2000\"))),$A$5,\"\"),IF(Contacts!$E$22=\"Nr. 2\",IF(AND($J$6>DATEVALUE(\"01.01.1900\"),OR(G15>DATEVALUE(\"01.01.2000\"),K15>DATEVALUE(\"01.01.2000\"))),$A$6,\"\"),IF(Contacts!$E$22=\"Nr. 3\",IF(AND($J$7>DATEVALUE(\"01.01.1900\"),OR(G15>DATEVALUE(\"01.01.2000\"),K15>DATEVALUE(\"01.01.2000\"))),$A$7,\"\"),IF(Contacts!$E$22=\"Nr. 4\",IF(AND($J$8>DATEVALUE(\"01.01.1900\"),OR(G15>DATEVALUE(\"01.01.2000\"),K15>DATEVALUE(\"01.01.2000\"))),$A$8,\"\"),IF(Contacts!$E$22=\"Nr. 5\",IF(AND($J$9>DATEVALUE(\"01.01.1900\"),OR(G15>DATEVALUE(\"01.01.2000\"),K15>DATEVALUE(\"01.01.2000\"))),$A$9,\"\"),IF(Contacts!$E$22=\"Nr. 6\",IF(AND($J$10>DATEVALUE(\"01.01.1900\"),OR(G15>DATEVALUE(\"01.01.2000\"),K15>DATEVALUE(\"01.01.2000\"))),$A$10,\"\"),IF(Contacts!$E$22=\"Nr. 7\",IF(AND($J$11>DATEVALUE(\"01.01.1900\"),OR(G15>DATEVALUE(\"01.01.2000\"),K15>DATEVALUE(\"01.01.2000\"))),$A$11,\"\"),IF(Contacts!$E$22=\"Nr. 8\",IF(AND($J$12>DATEVALUE(\"01.01.1900\"),OR(G15>DATEVALUE(\"01.01.2000\"),K15>DATEVALUE(\"01.01.2000\"))),$A$12,\"\"),\"\"))))))))","v":""},{"$f":"IF(AND(Contacts!$AP$22<0.1,Contacts!$AP$22>=0.05),$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"1900-01-01",null,null,{"$f":"IF(Contacts!$E$22=\"Nr. 1\",$B$5,IF(Contacts!$E$22=\"Nr. 2\",$B$6,IF(Contacts!$E$22=\"Nr. 3\",$B$7,IF(Contacts!$E$22=\"Nr. 4\",$B$8,IF(Contacts!$E$22=\"Nr. 5\",$B$9,IF(Contacts!$E$22=\"Nr. 6\",$B$10,IF(Contacts!$E$22=\"Nr. 7\",$B$11,IF(Contacts!$E$22=\"Nr. 8\",$B$12,DATEVALUE(\"01.01.1900\")))))))))","v":"1900-01-01"},{"$f":"IF(Contacts!$E$22=\"Nr. 1\",Contacts!$U$4,IF(Contacts!$E$22=\"Nr. 2\",Contacts!$U$6,IF(Contacts!$E$22=\"Nr. 3\",Contacts!$U$8,IF(Contacts!$E$22=\"Nr. 4\",Contacts!$U$10,IF(Contacts!$E$22=\"Nr. 5\",Contacts!$U$12,IF(Contacts!$E$22=\"Nr. 6\",Contacts!$U$14,IF(Contacts!$E$22=\"Nr. 7\",Contacts!$U$16,IF(Contacts!$E$22=\"Nr. 8\",Contacts!$U$18,\"\"))))))))","v":""}]
[{"$f":"IF(NOT(ISBLANK(Contacts!F23)),Contacts!F23,\"\")","v":""},{"$f":"IF(Contacts!$AP$23>=0.05,Contacts!Y23,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},{"$f":"IF(B16>DATEVALUE(\"01.01.2000\"),Contacts!Z23,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},null,null,null,{"$f":"IF(Contacts!$AP$23>=0.1,$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"1900-01-01","",{"$f":"IF(Contacts!$E$23=\"Nr. 1\",IF(AND($J$5>DATEVALUE(\"01.01.1900\"),OR(G16>DATEVALUE(\"01.01.2000\"),K16>DATEVALUE(\"01.01.2000\"))),$A$5,\"\"),IF(Contacts!$E$23=\"Nr. 2\",IF(AND($J$6>DATEVALUE(\"01.01.1900\"),OR(G16>DATEVALUE(\"01.01.2000\"),K16>DATEVALUE(\"01.01.2000\"))),$A$6,\"\"),IF(Contacts!$E$23=\"Nr. 3\",IF(AND($J$7>DATEVALUE(\"01.01.1900\"),OR(G16>DATEVALUE(\"01.01.2000\"),K16>DATEVALUE(\"01.01.2000\"))),$A$7,\"\"),IF(Contacts!$E$23=\"Nr. 4\",IF(AND($J$8>DATEVALUE(\"01.01.1900\"),OR(G16>DATEVALUE(\"01.01.2000\"),K16>DATEVALUE(\"01.01.2000\"))),$A$8,\"\"),IF(Contacts!$E$23=\"Nr. 5\",IF(AND($J$9>DATEVALUE(\"01.01.1900\"),OR(G16>DATEVALUE(\"01.01.2000\"),K16>DATEVALUE(\"01.01.2000\"))),$A$9,\"\"),IF(Contacts!$E$23=\"Nr. 6\",IF(AND($J$10>DATEVALUE(\"01.01.1900\"),OR(G16>DATEVALUE(\"01.01.2000\"),K16>DATEVALUE(\"01.01.2000\"))),$A$10,\"\"),IF(Contacts!$E$23=\"Nr. 7\",IF(AND($J$11>DATEVALUE(\"01.01.1900\"),OR(G16>DATEVALUE(\"01.01.2000\"),K16>DATEVALUE(\"01.01.2000\"))),$A$11,\"\"),IF(Contacts!$E$23=\"Nr. 8\",IF(AND($J$12>DATEVALUE(\"01.01.1900\"),OR(G16>DATEVALUE(\"01.01.2000\"),K16>DATEVALUE(\"01.01.2000\"))),$A$12,\"\"),\"\"))))))))","v":""},{"$f":"IF(AND(Contacts!$AP$23<0.1,Contacts!$AP$23>=0.05),$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"1900-01-01",null,null,{"$f":"IF(Contacts!$E$23=\"Nr. 1\",$B$5,IF(Contacts!$E$23=\"Nr. 2\",$B$6,IF(Contacts!$E$23=\"Nr. 3\",$B$7,IF(Contacts!$E$23=\"Nr. 4\",$B$8,IF(Contacts!$E$23=\"Nr. 5\",$B$9,IF(Contacts!$E$23=\"Nr. 6\",$B$10,IF(Contacts!$E$23=\"Nr. 7\",$B$11,IF(Contacts!$E$23=\"Nr. 8\",$B$12,DATEVALUE(\"01.01.1900\")))))))))","v":"1900-01-01"},{"$f":"IF(Contacts!$E$23=\"Nr. 1\",Contacts!$U$4,IF(Contacts!$E$23=\"Nr. 2\",Contacts!$U$6,IF(Contacts!$E$23=\"Nr. 3\",Contacts!$U$8,IF(Contacts!$E$23=\"Nr. 4\",Contacts!$U$10,IF(Contacts!$E$23=\"Nr. 5\",Contacts!$U$12,IF(Contacts!$E$23=\"Nr. 6\",Contacts!$U$14,IF(Contacts!$E$23=\"Nr. 7\",Contacts!$U$16,IF(Contacts!$E$23=\"Nr. 8\",Contacts!$U$18,\"\"))))))))","v":""}]
[{"$f":"IF(NOT(ISBLANK(Contacts!F24)),Contacts!F24,\"\")","v":""},{"$f":"IF(Contacts!$AP$24>=0.05,Contacts!Y24,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},{"$f":"IF(B17>DATEVALUE(\"01.01.2000\"),Contacts!Z24,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},null,null,null,{"$f":"IF(Contacts!$AP$24>=0.1,$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"1900-01-01","",{"$f":"IF(Contacts!$E$24=\"Nr. 1\",IF(AND($J$5>DATEVALUE(\"01.01.1900\"),OR(G17>DATEVALUE(\"01.01.2000\"),K17>DATEVALUE(\"01.01.2000\"))),$A$5,\"\"),IF(Contacts!$E$24=\"Nr. 2\",IF(AND($J$6>DATEVALUE(\"01.01.1900\"),OR(G17>DATEVALUE(\"01.01.2000\"),K17>DATEVALUE(\"01.01.2000\"))),$A$6,\"\"),IF(Contacts!$E$24=\"Nr. 3\",IF(AND($J$7>DATEVALUE(\"01.01.1900\"),OR(G17>DATEVALUE(\"01.01.2000\"),K17>DATEVALUE(\"01.01.2000\"))),$A$7,\"\"),IF(Contacts!$E$24=\"Nr. 4\",IF(AND($J$8>DATEVALUE(\"01.01.1900\"),OR(G17>DATEVALUE(\"01.01.2000\"),K17>DATEVALUE(\"01.01.2000\"))),$A$8,\"\"),IF(Contacts!$E$24=\"Nr. 5\",IF(AND($J$9>DATEVALUE(\"01.01.1900\"),OR(G17>DATEVALUE(\"01.01.2000\"),K17>DATEVALUE(\"01.01.2000\"))),$A$9,\"\"),IF(Contacts!$E$24=\"Nr. 6\",IF(AND($J$10>DATEVALUE(\"01.01.1900\"),OR(G17>DATEVALUE(\"01.01.2000\"),K17>DATEVALUE(\"01.01.2000\"))),$A$10,\"\"),IF(Contacts!$E$24=\"Nr. 7\",IF(AND($J$11>DATEVALUE(\"01.01.1900\"),OR(G17>DATEVALUE(\"01.01.2000\"),K17>DATEVALUE(\"01.01.2000\"))),$A$11,\"\"),IF(Contacts!$E$24=\"Nr. 8\",IF(AND($J$12>DATEVALUE(\"01.01.1900\"),OR(G17>DATEVALUE(\"01.01.2000\"),K17>DATEVALUE(\"01.01.2000\"))),$A$12,\"\"),\"\"))))))))","v":""},{"$f":"IF(AND(Contacts!$AP$24<0.1,Contacts!$AP$24>=0.05),$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"1900-01-01",null,null,{"$f":"IF(Contacts!$E$24=\"Nr. 1\",$B$5,IF(Contacts!$E$24=\"Nr. 2\",$B$6,IF(Contacts!$E$24=\"Nr. 3\",$B$7,IF(Contacts!$E$24=\"Nr. 4\",$B$8,IF(Contacts!$E$24=\"Nr. 5\",$B$9,IF(Contacts!$E$24=\"Nr. 6\",$B$10,IF(Contacts!$E$24=\"Nr. 7\",$B$11,IF(Contacts!$E$24=\"Nr. 8\",$B$12,DATEVALUE(\"01.01.1900\")))))))))","v":"1900-01-01"},{"$f":"IF(Contacts!$E$24=\"Nr. 1\",Contacts!$U$4,IF(Contacts!$E$24=\"Nr. 2\",Contacts!$U$6,IF(Contacts!$E$24=\"Nr. 3\",Contacts!$U$8,IF(Contacts!$E$24=\"Nr. 4\",Contacts!$U$10,IF(Contacts!$E$24=\"Nr. 5\",Contacts!$U$12,IF(Contacts!$E$24=\"Nr. 6\",Contacts!$U$14,IF(Contacts!$E$24=\"Nr. 7\",Contacts!$U$16,IF(Contacts!$E$24=\"Nr. 8\",Contacts!$U$18,\"\"))))))))","v":""}]
[{"$f":"IF(NOT(ISBLANK(Contacts!F25)),Contacts!F25,\"\")","v":""},{"$f":"IF(Contacts!$AP$25>=0.05,Contacts!Y25,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},{"$f":"IF(B18>DATEVALUE(\"01.01.2000\"),Contacts!Z25,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},null,null,null,{"$f":"IF(Contacts!$AP$25>=0.1,$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"1900-01-01","",{"$f":"IF(Contacts!$E$25=\"Nr. 1\",IF(AND($J$5>DATEVALUE(\"01.01.1900\"),OR(G18>DATEVALUE(\"01.01.2000\"),K18>DATEVALUE(\"01.01.2000\"))),$A$5,\"\"),IF(Contacts!$E$25=\"Nr. 2\",IF(AND($J$6>DATEVALUE(\"01.01.1900\"),OR(G18>DATEVALUE(\"01.01.2000\"),K18>DATEVALUE(\"01.01.2000\"))),$A$6,\"\"),IF(Contacts!$E$25=\"Nr. 3\",IF(AND($J$7>DATEVALUE(\"01.01.1900\"),OR(G18>DATEVALUE(\"01.01.2000\"),K18>DATEVALUE(\"01.01.2000\"))),$A$7,\"\"),IF(Contacts!$E$25=\"Nr. 4\",IF(AND($J$8>DATEVALUE(\"01.01.1900\"),OR(G18>DATEVALUE(\"01.01.2000\"),K18>DATEVALUE(\"01.01.2000\"))),$A$8,\"\"),IF(Contacts!$E$25=\"Nr. 5\",IF(AND($J$9>DATEVALUE(\"01.01.1900\"),OR(G18>DATEVALUE(\"01.01.2000\"),K18>DATEVALUE(\"01.01.2000\"))),$A$9,\"\"),IF(Contacts!$E$25=\"Nr. 6\",IF(AND($J$10>DATEVALUE(\"01.01.1900\"),OR(G18>DATEVALUE(\"01.01.2000\"),K18>DATEVALUE(\"01.01.2000\"))),$A$10,\"\"),IF(Contacts!$E$25=\"Nr. 7\",IF(AND($J$11>DATEVALUE(\"01.01.1900\"),OR(G18>DATEVALUE(\"01.01.2000\"),K18>DATEVALUE(\"01.01.2000\"))),$A$11,\"\"),IF(Contacts!$E$25=\"Nr. 8\",IF(AND($J$12>DATEVALUE(\"01.01.1900\"),OR(G18>DATEVALUE(\"01.01.2000\"),K18>DATEVALUE(\"01.01.2000\"))),$A$12,\"\"),\"\"))))))))","v":""},{"$f":"IF(AND(Contacts!$AP$25<0.1,Contacts!$AP$25>=0.05),$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"1900-01-01",null,null,{"$f":"IF(Contacts!$E$25=\"Nr. 1\",$B$5,IF(Contacts!$E$25=\"Nr. 2\",$B$6,IF(Contacts!$E$25=\"Nr. 3\",$B$7,IF(Contacts!$E$25=\"Nr. 4\",$B$8,IF(Contacts!$E$25=\"Nr. 5\",$B$9,IF(Contacts!$E$25=\"Nr. 6\",$B$10,IF(Contacts!$E$25=\"Nr. 7\",$B$11,IF(Contacts!$E$25=\"Nr. 8\",$B$12,DATEVALUE(\"01.01.1900\")))))))))","v":"1900-01-01"},{"$f":"IF(Contacts!$E$25=\"Nr. 1\",Contacts!$U$4,IF(Contacts!$E$25=\"Nr. 2\",Contacts!$U$6,IF(Contacts!$E$25=\"Nr. 3\",Contacts!$U$8,IF(Contacts!$E$25=\"Nr. 4\",Contacts!$U$10,IF(Contacts!$E$25=\"Nr. 5\",Contacts!$U$12,IF(Contacts!$E$25=\"Nr. 6\",Contacts!$U$14,IF(Contacts!$E$25=\"Nr. 7\",Contacts!$U$16,IF(Contacts!$E$25=\"Nr. 8\",Contacts!$U$18,\"\"))))))))","v":""}]
[{"$f":"IF(NOT(ISBLANK(Contacts!F26)),Contacts!F26,\"\")","v":""},{"$f":"IF(Contacts!$AP$26>=0.05,Contacts!Y26,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},{"$f":"IF(B19>DATEVALUE(\"01.01.2000\"),Contacts!Z26,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},null,null,null,{"$f":"IF(Contacts!$AP$26>=0.1,$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"1900-01-01","",{"$f":"IF(Contacts!$E$26=\"Nr. 1\",IF(AND($J$5>DATEVALUE(\"01.01.1900\"),OR(G19>DATEVALUE(\"01.01.2000\"),K19>DATEVALUE(\"01.01.2000\"))),$A$5,\"\"),IF(Contacts!$E$26=\"Nr. 2\",IF(AND($J$6>DATEVALUE(\"01.01.1900\"),OR(G19>DATEVALUE(\"01.01.2000\"),K19>DATEVALUE(\"01.01.2000\"))),$A$6,\"\"),IF(Contacts!$E$26=\"Nr. 3\",IF(AND($J$7>DATEVALUE(\"01.01.1900\"),OR(G19>DATEVALUE(\"01.01.2000\"),K19>DATEVALUE(\"01.01.2000\"))),$A$7,\"\"),IF(Contacts!$E$26=\"Nr. 4\",IF(AND($J$8>DATEVALUE(\"01.01.1900\"),OR(G19>DATEVALUE(\"01.01.2000\"),K19>DATEVALUE(\"01.01.2000\"))),$A$8,\"\"),IF(Contacts!$E$26=\"Nr. 5\",IF(AND($J$9>DATEVALUE(\"01.01.1900\"),OR(G19>DATEVALUE(\"01.01.2000\"),K19>DATEVALUE(\"01.01.2000\"))),$A$9,\"\"),IF(Contacts!$E$26=\"Nr. 6\",IF(AND($J$10>DATEVALUE(\"01.01.1900\"),OR(G19>DATEVALUE(\"01.01.2000\"),K19>DATEVALUE(\"01.01.2000\"))),$A$10,\"\"),IF(Contacts!$E$26=\"Nr. 7\",IF(AND($J$11>DATEVALUE(\"01.01.1900\"),OR(G19>DATEVALUE(\"01.01.2000\"),K19>DATEVALUE(\"01.01.2000\"))),$A$11,\"\"),IF(Contacts!$E$26=\"Nr. 8\",IF(AND($J$12>DATEVALUE(\"01.01.1900\"),OR(G19>DATEVALUE(\"01.01.2000\"),K19>DATEVALUE(\"01.01.2000\"))),$A$12,\"\"),\"\"))))))))","v":""},{"$f":"IF(AND(Contacts!$AP$26<0.1,Contacts!$AP$26>=0.05),$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"1900-01-01",null,null,{"$f":"IF(Contacts!$E$26=\"Nr. 1\",$B$5,IF(Contacts!$E$26=\"Nr. 2\",$B$6,IF(Contacts!$E$26=\"Nr. 3\",$B$7,IF(Contacts!$E$26=\"Nr. 4\",$B$8,IF(Contacts!$E$26=\"Nr. 5\",$B$9,IF(Contacts!$E$26=\"Nr. 6\",$B$10,IF(Contacts!$E$26=\"Nr. 7\",$B$11,IF(Contacts!$E$26=\"Nr. 8\",$B$12,DATEVALUE(\"01.01.1900\")))))))))","v":"1900-01-01"},{"$f":"IF(Contacts!$E$26=\"Nr. 1\",Contacts!$U$4,IF(Contacts!$E$26=\"Nr. 2\",Contacts!$U$6,IF(Contacts!$E$26=\"Nr. 3\",Contacts!$U$8,IF(Contacts!$E$26=\"Nr. 4\",Contacts!$U$10,IF(Contacts!$E$26=\"Nr. 5\",Contacts!$U$12,IF(Contacts!$E$26=\"Nr. 6\",Contacts!$U$14,IF(Contacts!$E$26=\"Nr. 7\",Contacts!$U$16,IF(Contacts!$E$26=\"Nr. 8\",Contacts!$U$18,\"\"))))))))","v":""}]
[{"$f":"IF(NOT(ISBLANK(Contacts!F27)),Contacts!F27,\"\")","v":""},{"$f":"IF(Contacts!$AP$27>=0.05,Contacts!Y27,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},{"$f":"IF(B20>DATEVALUE(\"01.01.2000\"),Contacts!Z27,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},null,null,null,{"$f":"IF(Contacts!$AP$27>=0.1,$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"1900-01-01","",{"$f":"IF(Contacts!$E$27=\"Nr. 1\",IF(AND($J$5>DATEVALUE(\"01.01.1900\"),OR(G20>DATEVALUE(\"01.01.2000\"),K20>DATEVALUE(\"01.01.2000\"))),$A$5,\"\"),IF(Contacts!$E$27=\"Nr. 2\",IF(AND($J$6>DATEVALUE(\"01.01.1900\"),OR(G20>DATEVALUE(\"01.01.2000\"),K20>DATEVALUE(\"01.01.2000\"))),$A$6,\"\"),IF(Contacts!$E$27=\"Nr. 3\",IF(AND($J$7>DATEVALUE(\"01.01.1900\"),OR(G20>DATEVALUE(\"01.01.2000\"),K20>DATEVALUE(\"01.01.2000\"))),$A$7,\"\"),IF(Contacts!$E$27=\"Nr. 4\",IF(AND($J$8>DATEVALUE(\"01.01.1900\"),OR(G20>DATEVALUE(\"01.01.2000\"),K20>DATEVALUE(\"01.01.2000\"))),$A$8,\"\"),IF(Contacts!$E$27=\"Nr. 5\",IF(AND($J$9>DATEVALUE(\"01.01.1900\"),OR(G20>DATEVALUE(\"01.01.2000\"),K20>DATEVALUE(\"01.01.2000\"))),$A$9,\"\"),IF(Contacts!$E$27=\"Nr. 6\",IF(AND($J$10>DATEVALUE(\"01.01.1900\"),OR(G20>DATEVALUE(\"01.01.2000\"),K20>DATEVALUE(\"01.01.2000\"))),$A$10,\"\"),IF(Contacts!$E$27=\"Nr. 7\",IF(AND($J$11>DATEVALUE(\"01.01.1900\"),OR(G20>DATEVALUE(\"01.01.2000\"),K20>DATEVALUE(\"01.01.2000\"))),$A$11,\"\"),IF(Contacts!$E$27=\"Nr. 8\",IF(AND($J$12>DATEVALUE(\"01.01.1900\"),OR(G20>DATEVALUE(\"01.01.2000\"),K20>DATEVALUE(\"01.01.2000\"))),$A$12,\"\"),\"\"))))))))","v":""},{"$f":"IF(AND(Contacts!$AP$27<0.1,Contacts!$AP$27>=0.05),$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"1900-01-01",null,null,{"$f":"IF(Contacts!$E$27=\"Nr. 1\",$B$5,IF(Contacts!$E$27=\"Nr. 2\",$B$6,IF(Contacts!$E$27=\"Nr. 3\",$B$7,IF(Contacts!$E$27=\"Nr. 4\",$B$8,IF(Contacts!$E$27=\"Nr. 5\",$B$9,IF(Contacts!$E$27=\"Nr. 6\",$B$10,IF(Contacts!$E$27=\"Nr. 7\",$B$11,IF(Contacts!$E$27=\"Nr. 8\",$B$12,DATEVALUE(\"01.01.1900\")))))))))","v":"1900-01-01"},{"$f":"IF(Contacts!$E$27=\"Nr. 1\",Contacts!$U$4,IF(Contacts!$E$27=\"Nr. 2\",Contacts!$U$6,IF(Contacts!$E$27=\"Nr. 3\",Contacts!$U$8,IF(Contacts!$E$27=\"Nr. 4\",Contacts!$U$10,IF(Contacts!$E$27=\"Nr. 5\",Contacts!$U$12,IF(Contacts!$E$27=\"Nr. 6\",Contacts!$U$14,IF(Contacts!$E$27=\"Nr. 7\",Contacts!$U$16,IF(Contacts!$E$27=\"Nr. 8\",Contacts!$U$18,\"\"))))))))","v":""}]
[{"$f":"IF(NOT(ISBLANK(Contacts!F28)),Contacts!F28,\"\")","v":""},{"$f":"IF(Contacts!$AP$28>=0.05,Contacts!Y28,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},{"$f":"IF(B21>DATEVALUE(\"01.01.2000\"),Contacts!Z28,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},null,null,null,{"$f":"IF(Contacts!$AP$28>=0.1,$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"1900-01-01","",{"$f":"IF(Contacts!$E$28=\"Nr. 1\",IF(AND($J$5>DATEVALUE(\"01.01.1900\"),OR(G21>DATEVALUE(\"01.01.2000\"),K21>DATEVALUE(\"01.01.2000\"))),$A$5,\"\"),IF(Contacts!$E$28=\"Nr. 2\",IF(AND($J$6>DATEVALUE(\"01.01.1900\"),OR(G21>DATEVALUE(\"01.01.2000\"),K21>DATEVALUE(\"01.01.2000\"))),$A$6,\"\"),IF(Contacts!$E$28=\"Nr. 3\",IF(AND($J$7>DATEVALUE(\"01.01.1900\"),OR(G21>DATEVALUE(\"01.01.2000\"),K21>DATEVALUE(\"01.01.2000\"))),$A$7,\"\"),IF(Contacts!$E$28=\"Nr. 4\",IF(AND($J$8>DATEVALUE(\"01.01.1900\"),OR(G21>DATEVALUE(\"01.01.2000\"),K21>DATEVALUE(\"01.01.2000\"))),$A$8,\"\"),IF(Contacts!$E$28=\"Nr. 5\",IF(AND($J$9>DATEVALUE(\"01.01.1900\"),OR(G21>DATEVALUE(\"01.01.2000\"),K21>DATEVALUE(\"01.01.2000\"))),$A$9,\"\"),IF(Contacts!$E$28=\"Nr. 6\",IF(AND($J$10>DATEVALUE(\"01.01.1900\"),OR(G21>DATEVALUE(\"01.01.2000\"),K21>DATEVALUE(\"01.01.2000\"))),$A$10,\"\"),IF(Contacts!$E$28=\"Nr. 7\",IF(AND($J$11>DATEVALUE(\"01.01.1900\"),OR(G21>DATEVALUE(\"01.01.2000\"),K21>DATEVALUE(\"01.01.2000\"))),$A$11,\"\"),IF(Contacts!$E$28=\"Nr. 8\",IF(AND($J$12>DATEVALUE(\"01.01.1900\"),OR(G21>DATEVALUE(\"01.01.2000\"),K21>DATEVALUE(\"01.01.2000\"))),$A$12,\"\"),\"\"))))))))","v":""},{"$f":"IF(AND(Contacts!$AP$28<0.1,Contacts!$AP$28>=0.05),$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"1900-01-01",null,null,{"$f":"IF(Contacts!$E$28=\"Nr. 1\",$B$5,IF(Contacts!$E$28=\"Nr. 2\",$B$6,IF(Contacts!$E$28=\"Nr. 3\",$B$7,IF(Contacts!$E$28=\"Nr. 4\",$B$8,IF(Contacts!$E$28=\"Nr. 5\",$B$9,IF(Contacts!$E$28=\"Nr. 6\",$B$10,IF(Contacts!$E$28=\"Nr. 7\",$B$11,IF(Contacts!$E$28=\"Nr. 8\",$B$12,DATEVALUE(\"01.01.1900\")))))))))","v":"1900-01-01"},{"$f":"IF(Contacts!$E$28=\"Nr. 1\",Contacts!$U$4,IF(Contacts!$E$28=\"Nr. 2\",Contacts!$U$6,IF(Contacts!$E$28=\"Nr. 3\",Contacts!$U$8,IF(Contacts!$E$28=\"Nr. 4\",Contacts!$U$10,IF(Contacts!$E$28=\"Nr. 5\",Contacts!$U$12,IF(Contacts!$E$28=\"Nr. 6\",Contacts!$U$14,IF(Contacts!$E$28=\"Nr. 7\",Contacts!$U$16,IF(Contacts!$E$28=\"Nr. 8\",Contacts!$U$18,\"\"))))))))","v":""}]
[{"$f":"IF(NOT(ISBLANK(Contacts!F29)),Contacts!F29,\"\")","v":""},{"$f":"IF(Contacts!$AP$29>=0.05,Contacts!Y29,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},{"$f":"IF(B22>DATEVALUE(\"01.01.2000\"),Contacts!Z29,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},null,null,null,{"$f":"IF(Contacts!$AP$29>=0.1,$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"1900-01-01","",{"$f":"IF(Contacts!$E$29=\"Nr. 1\",IF(AND($J$5>DATEVALUE(\"01.01.1900\"),OR(G22>DATEVALUE(\"01.01.2000\"),K22>DATEVALUE(\"01.01.2000\"))),$A$5,\"\"),IF(Contacts!$E$29=\"Nr. 2\",IF(AND($J$6>DATEVALUE(\"01.01.1900\"),OR(G22>DATEVALUE(\"01.01.2000\"),K22>DATEVALUE(\"01.01.2000\"))),$A$6,\"\"),IF(Contacts!$E$29=\"Nr. 3\",IF(AND($J$7>DATEVALUE(\"01.01.1900\"),OR(G22>DATEVALUE(\"01.01.2000\"),K22>DATEVALUE(\"01.01.2000\"))),$A$7,\"\"),IF(Contacts!$E$29=\"Nr. 4\",IF(AND($J$8>DATEVALUE(\"01.01.1900\"),OR(G22>DATEVALUE(\"01.01.2000\"),K22>DATEVALUE(\"01.01.2000\"))),$A$8,\"\"),IF(Contacts!$E$29=\"Nr. 5\",IF(AND($J$9>DATEVALUE(\"01.01.1900\"),OR(G22>DATEVALUE(\"01.01.2000\"),K22>DATEVALUE(\"01.01.2000\"))),$A$9,\"\"),IF(Contacts!$E$29=\"Nr. 6\",IF(AND($J$10>DATEVALUE(\"01.01.1900\"),OR(G22>DATEVALUE(\"01.01.2000\"),K22>DATEVALUE(\"01.01.2000\"))),$A$10,\"\"),IF(Contacts!$E$29=\"Nr. 7\",IF(AND($J$11>DATEVALUE(\"01.01.1900\"),OR(G22>DATEVALUE(\"01.01.2000\"),K22>DATEVALUE(\"01.01.2000\"))),$A$11,\"\"),IF(Contacts!$E$29=\"Nr. 8\",IF(AND($J$12>DATEVALUE(\"01.01.1900\"),OR(G22>DATEVALUE(\"01.01.2000\"),K22>DATEVALUE(\"01.01.2000\"))),$A$12,\"\"),\"\"))))))))","v":""},{"$f":"IF(AND(Contacts!$AP$29<0.1,Contacts!$AP$29>=0.05),$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"1900-01-01",null,null,{"$f":"IF(Contacts!$E$29=\"Nr. 1\",$B$5,IF(Contacts!$E$29=\"Nr. 2\",$B$6,IF(Contacts!$E$29=\"Nr. 3\",$B$7,IF(Contacts!$E$29=\"Nr. 4\",$B$8,IF(Contacts!$E$29=\"Nr. 5\",$B$9,IF(Contacts!$E$29=\"Nr. 6\",$B$10,IF(Contacts!$E$29=\"Nr. 7\",$B$11,IF(Contacts!$E$29=\"Nr. 8\",$B$12,DATEVALUE(\"01.01.1900\")))))))))","v":"1900-01-01"},{"$f":"IF(Contacts!$E$29=\"Nr. 1\",Contacts!$U$4,IF(Contacts!$E$29=\"Nr. 2\",Contacts!$U$6,IF(Contacts!$E$29=\"Nr. 3\",Contacts!$U$8,IF(Contacts!$E$29=\"Nr. 4\",Contacts!$U$10,IF(Contacts!$E$29=\"Nr. 5\",Contacts!$U$12,IF(Contacts!$E$29=\"Nr. 6\",Contacts!$U$14,IF(Contacts!$E$29=\"Nr. 7\",Contacts!$U$16,IF(Contacts!$E$29=\"Nr. 8\",Contacts!$U$18,\"\"))))))))","v":""}]
[{"$f":"IF(NOT(ISBLANK(Contacts!F30)),Contacts!F30,\"\")","v":""},{"$f":"IF(Contacts!$AP$30>=0.05,Contacts!Y30,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},{"$f":"IF(B23>DATEVALUE(\"01.01.2000\"),Contacts!Z30,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},null,null,null,{"$f":"IF(Contacts!$AP$30>=0.1,$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"1900-01-01","",{"$f":"IF(Contacts!$E$30=\"Nr. 1\",IF(AND($J$5>DATEVALUE(\"01.01.1900\"),OR(G23>DATEVALUE(\"01.01.2000\"),K23>DATEVALUE(\"01.01.2000\"))),$A$5,\"\"),IF(Contacts!$E$30=\"Nr. 2\",IF(AND($J$6>DATEVALUE(\"01.01.1900\"),OR(G23>DATEVALUE(\"01.01.2000\"),K23>DATEVALUE(\"01.01.2000\"))),$A$6,\"\"),IF(Contacts!$E$30=\"Nr. 3\",IF(AND($J$7>DATEVALUE(\"01.01.1900\"),OR(G23>DATEVALUE(\"01.01.2000\"),K23>DATEVALUE(\"01.01.2000\"))),$A$7,\"\"),IF(Contacts!$E$30=\"Nr. 4\",IF(AND($J$8>DATEVALUE(\"01.01.1900\"),OR(G23>DATEVALUE(\"01.01.2000\"),K23>DATEVALUE(\"01.01.2000\"))),$A$8,\"\"),IF(Contacts!$E$30=\"Nr. 5\",IF(AND($J$9>DATEVALUE(\"01.01.1900\"),OR(G23>DATEVALUE(\"01.01.2000\"),K23>DATEVALUE(\"01.01.2000\"))),$A$9,\"\"),IF(Contacts!$E$30=\"Nr. 6\",IF(AND($J$10>DATEVALUE(\"01.01.1900\"),OR(G23>DATEVALUE(\"01.01.2000\"),K23>DATEVALUE(\"01.01.2000\"))),$A$10,\"\"),IF(Contacts!$E$30=\"Nr. 7\",IF(AND($J$11>DATEVALUE(\"01.01.1900\"),OR(G23>DATEVALUE(\"01.01.2000\"),K23>DATEVALUE(\"01.01.2000\"))),$A$11,\"\"),IF(Contacts!$E$30=\"Nr. 8\",IF(AND($J$12>DATEVALUE(\"01.01.1900\"),OR(G23>DATEVALUE(\"01.01.2000\"),K23>DATEVALUE(\"01.01.2000\"))),$A$12,\"\"),\"\"))))))))","v":""},{"$f":"IF(AND(Contacts!$AP$30<0.1,Contacts!$AP$30>=0.05),$N$3,DATEVALUE(\"01.01.1900\"))","v":"1900-01-01"},"1900-01-01",null,null,{"$f":"IF(Contacts!$E$30=\"Nr. 1\",$B$5,IF(Contacts!$E$30=\"Nr. 2\",$B$6,IF(Contacts!$E$30=\"Nr. 3\",$B$7,IF(Contacts!$E$30=\"Nr. 4\",$B$8,IF(Contacts!$E$30=\"Nr. 5\",$B$9,IF(Contacts!$E$30=\"Nr. 6\",$B$10,IF(Contacts!$E$30=\"Nr. 7\",$B$11,IF(Contacts!$E$30=\"Nr. 8\",$B$12,DATEVALUE(\"01.01.1900\")))))))))","v":"1900-01-01"},{"$f":"IF(Contacts!$E$30=\"Nr. 1\",Contacts!$U$4,IF(Contacts!$E$30=\"Nr. 2\",Contacts!$U$6,IF(Contacts!$E$30=\"Nr. 3\",Contacts!$U$8,IF(Contacts!$E$30=\"Nr. 4\",Contacts!$U$10,IF(Contacts!$E$30=\"Nr. 5\",Contacts!$U$12,IF(Contacts!$E$30=\"Nr. 6\",Contacts!$U$14,IF(Contacts!$E$30=\"Nr. 7\",Contacts!$U$16,IF(Contacts!$E$30=\"Nr. 8\",Contacts!$U$18,\"\"))))))))","v":""}]
["Group testing",{"$f":"IF(Risk_Analysis!U13>1,\"Die Reproduktionszahl Stufe C ist zu hoch! Bitte arbeitstägliche Gruppentestung im gleichen Arbeits-/ Sozialbereich prüfen.\",\"\")","v":""}]
["<C> Dr. med. Andreas Paaßen"]

{"sheet":"Help","index":4,"n_rows":29,"n_cols":17,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,3],[0,5,0,8]]}
["Operating instructions",null,null,null,null,"Background"]
[]
[null,"Basic Data:","for the calculation of the infection-critical days, the specification of at least one date for the onset of symptoms,",null,null,"Basic assumptions:"]
[null,null,"execution or notification of the test or a suspected infection appointment is required.",null,null,"The duration of the incubation period in most cases is a maximum of 14 days."]
[null,null,"The indication of the onset of symptoms allows the most accurate calculation, following the indication",null,null,"The mean/median for the incubation period is 5 – 6 days."]
[null,null,"of a suspected infection date, if this can be limited to exactly one appointment.",null,null,"The duration of the infectious period is about 12 days. "]
[null,null,"After entering, the command key \"Check data\" must be pressed. The specification of the day of action is preset",null,null,"Infectivity is assumed 2 days before the onset of symptoms and no earlier than 3 days"]
[null,null,"to today's date and can be changed. ",null,null,"after critical contact."]
[null,"Contacts:","In line 2, the dates for the calculated duration of the infectivity of the source case are determined. The day"]
[null,null,"of action has been raised.",null,null,"Definitions of groups of people",null,null,null,null,null,null,null,null,null,null,"Schon mal positiv gemeldet"]
[null,null,"Direct contact persons of the source case (regardless of whether the source case occurred internally ",null,null,"Source Case: ","Person with positive test results or high suspicion"]
[null,null,"or off-site) are to be named in the column \"Names\". Contacts to the source case are to be named at the",null,null,"Direct Contact:","Person with contact to source case"]
[null,null,"respective displayed date with the risk rating \"H\" =high, \"M\"=medium or \"G\"=low.",null,null,"Indirect Contact:","Person with contact to direct contact person (contact to contact)"]
[null,null,"From these data, the time of possible infectivity of the direct contact person after infection is displayed"]
[null,null,"as a red bar below the risk.",null,null,"Definitions of measures"]
[null,null,"Indirect contact persons with contact to the direct contact persons are named in the lower part of the table.",null,null,"Isolation","Seperation of a person who tested positive"]
[null,null,"The reference to the respective direct contact person is made with the number from the upper part of the table",null,null,"Self Quarantine","Separation of a healthy contact person (voluntarily)"]
[null,null,"(column reference). The contacts to the reference are to be checked only during the days on which infectivity",null,null,"Contact Quarantine","Separation of a healthy contact person"]
[null,null,"is indicated for the reference."]
[null,"Risk Analysis:","Based on the information from the basic and contact details, a forward risk analysis is created for three virus"]
[null,null,"generations after interventions have taken place. The risk is expressed as a reproduction number."]
[null,null,"With an R-number above 1, there is an increased risk of a continuation of the infections as an operational "]
[null,null,"infection chain. In that case, further action must be taken."]
[null,null,"For the risk analysis, different virus variants can be specified."]
[null,null,"The calculation of the risk analysis can be influenced by the number of other people in the same work and social "]
[null,null,"sector or uncertain contact details, as in these cases transmissions cannot be safely excluded."]
[null,null,"From the risk analysis, a personal combined package of measures is created, which strives for an optimum of "]
[null,null,"risk minimization and effort. Particular attention is paid to personnel availability."]
[null,null,"User input is not required or possible here."]

{"sheet":"Settings","index":5,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[null,"Expert-Settings"]
[]
[null,"Basic parameters for calculation based on empirical values can be changed by experts."]
[null,"By changing values, the calculations and their results are fundamentally changed!"]
[]
[null,null,null,null,null,null,null,null,"Standard Values"]
[null,"Basic Reproduction number wild type:",null,null,null,null,2.5,null,2.5]
[]
[null,"Value of risk of transmission 'High':",null,null,null,null,0.2,null,0.2]
[]
[null,"Value of risk of transmission 'Medium':",null,null,null,null,0.1,null,0.1]
[]
[null,"Value of risk of transmission 'Low':",null,null,null,null,0.05,null,0.05]
[]
[null,"Value of the risk of transmission 'equal working/social sector'",null,null,null,null,0.01,null,0.01]
[]
[null,{"$f":"IF(OR(G7<>I7,G9<>I9,G11<>I11,G13<>I13,G15<>I15),\"WARNUNG: Standardwerte wurden verändert!\",\" \")","v":" "}]