{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Eingabeformular","Report","HiddenTab","ResultTab"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Eingabeformular","index":0,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":false,"merged":[[28,10,28,11],[28,15,28,16],[28,5,28,6],[27,9,27,12],[27,14,27,17],[1,3,1,18],[27,4,27,7],[8,11,8,12],[24,5,25,16],[21,3,21,18],[12,8,12,11],[14,8,14,11],[14,13,14,16],[8,5,8,6],[10,5,10,6],[12,5,12,6],[14,5,14,6],[5,5,5,16],[8,8,8,10],[12,13,12,16],[10,8,10,11],[33,14,33,17],[34,15,34,16],[33,4,33,7],[34,5,34,6],[33,9,33,12],[34,10,34,11]]}
[]
[null,null,null,"LAMP Result validation application"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Sample information"]
[]
[]
[null,null,null,null,null,"Declare number of samples analyzed and define target species of LAMP test"]
[]
[]
[null,null,null,null,"Sample 1",null,null,null,null,"Sample 2",null,null,null,null,"Sample 3"]
[]
[]
[]
[]
[]
[null,null,null,null,"Sample 4",null,null,null,null,"Sample 5",null,null,null,null,"Sample 6"]

{"sheet":"Report","index":1,"n_rows":19,"n_cols":1,"rows_kept":19,"cut":false,"hidden":true,"merged":[[13,3,13,5],[13,7,13,9],[7,3,7,5],[9,3,9,5],[11,3,11,5],[9,9,9,11]]}
[]
[]
[]
["LAMP result validation report"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Results LAMP Assy"]

{"sheet":"HiddenTab","index":2,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Eingabeformular Listen"]
[]
["Standortliste","Ausgabe Index",null,"Organimus Stichprobe","Ausgabe Stichp. 1","Ausgabe Stichp. 2","Ausgabe Stichp. 3","Ausgabe Stichp. 4","Ausgabe Stichp. 5","Ausgabe Stichp. 6"]
["EPSD ZH",1,null,"No organism",2,1,1,1,1,1,"Ausgabe Index"]
["EPSD BS",{"$f":"INDEX(Tabelle1[Standortliste],B4)","v":"EPSD ZH"},null,"Bemisia tabaci",{"$f":"INDEX(Tabelle2[Organimus Stichprobe],E4)","v":"Bemisia tabaci"},{"$f":"INDEX(Tabelle2[Organimus Stichprobe],F4)","v":"No organism"},{"$f":"INDEX(Tabelle2[Organimus Stichprobe],G4)","v":"No organism"},{"$f":"INDEX(Tabelle2[Organimus Stichprobe],H4)","v":"No organism"},{"$f":"INDEX(Tabelle2[Organimus Stichprobe],I4)","v":"No organism"},{"$f":"INDEX(Tabelle2[Organimus Stichprobe],J4)","v":"No organism"},"Organismus"]
["EPSD GE",null,null,"Bactrocera Triplex"]
["Agroscope WA",null,null,"Thrips palmi"]
[null,null,null,"Liriomyza"]

{"sheet":"ResultTab","index":3,"n_rows":286,"n_cols":26,"rows_kept":286,"cut":false,"hidden":true,"merged":[[27,5,27,6],[28,5,28,6],[278,7,279,8],[278,9,279,12],[188,7,189,8],[188,9,189,12],[205,7,206,8],[205,9,206,12],[214,7,215,8],[214,9,215,12],[223,7,224,8],[223,9,224,12],[233,7,234,8],[233,9,234,12],[245,11,245,16],[200,11,200,16],[79,7,80,8],[79,9,80,12],[88,7,89,8],[88,9,89,12],[98,7,99,8],[98,9,99,12],[115,7,116,8],[115,9,116,12],[124,7,125,8],[124,9,125,12],[25,7,26,8],[25,9,26,12],[34,7,35,8],[34,9,35,12],[43,7,44,8],[43,9,44,12],[53,7,54,8],[53,9,54,12],[70,7,71,8],[70,9,71,12],[280,2,280,4],[280,7,280,8],[280,11,280,12],[280,15,280,16],[281,2,281,4],[281,7,281,8],[281,11,281,12],[281,15,281,16],[284,1,286,4],[284,5,286,12],[284,15,284,16],[285,15,285,16],[282,2,282,4],[282,7,282,8],[282,11,282,12],[282,15,282,16],[283,2,283,4],[283,5,283,6],[283,7,283,8],[283,11,283,12],[283,15,283,16],[272,2,272,4],[272,5,272,6],[272,7,272,8],[272,11,272,12],[272,15,272,16],[273,1,275,4],[273,5,275,12],[273,15,273,16],[274,15,274,16],[263,1,265,4],[263,5,265,12],[263,15,263,16],[264,15,264,16],[270,2,270,4],[270,7,270,8],[270,11,270,12],[270,15,270,16],[271,2,271,4],[271,7,271,8],[271,11,271,12],[271,15,271,16],[268,7,269,8],[268,9,269,12],[254,15,254,16],[255,15,255,16],[261,2,261,4],[261,7,261,8],[261,11,261,12],[261,15,261,16],[262,2,262,4],[262,7,262,8],[262,11,262,12],[262,15,262,16],[259,7,260,8],[259,9,260,12],[252,2,252,4],[252,7,252,8],[252,11,252,12],[252,15,252,16],[253,2,253,4],[253,7,253,8],[253,11,253,12],[253,15,253,16],[250,7,251,8],[250,9,251,12],[238,2,238,4],[238,5,238,6],[238,7,238,8],[238,9,238,10],[238,11,238,12],[238,15,238,16],[239,1,241,4],[239,5,241,12],[239,15,239,16],[240,15,240,16],[235,2,235,4],[235,7,235,8],[235,11,235,12],[235,15,235,16],[236,2,236,4],[236,7,236,8],[236,11,236,12],[236,15,236,16],[237,2,237,4],[237,7,237,8],[237,11,237,12],[237,15,237,16],[227,2,227,4],[227,5,227,6],[227,7,227,8],[227,11,227,12],[227,15,227,16],[228,1,230,4],[228,5,230,12],[228,15,228,16],[229,15,229,16],[218,1,220,4],[218,5,220,12],[218,15,218,16],[219,15,219,16],[225,2,225,4],[225,7,225,8],[225,11,225,12],[225,15,225,16],[226,2,226,4],[226,7,226,8],[226,11,226,12],[226,15,226,16],[209,15,209,16],[210,15,210,16],[216,2,216,4],[216,7,216,8],[216,11,216,12],[216,15,216,16],[217,2,217,4],[217,7,217,8],[217,11,217,12],[217,15,217,16],[207,2,207,4],[207,7,207,8],[207,11,207,12],[207,15,207,16],[208,2,208,4],[208,7,208,8],[208,11,208,12],[208,15,208,16],[193,2,193,4],[193,5,193,6],[193,7,193,8],[193,11,193,12],[193,15,193,16],[194,1,196,4],[194,5,196,12],[194,15,194,16],[195,15,195,16],[190,2,190,4],[190,7,190,8],[190,11,190,12],[190,15,190,16],[191,2,191,4],[191,7,191,8],[191,11,191,12],[191,15,191,16],[192,2,192,4],[192,7,192,8],[192,11,192,12],[192,15,192,16],[182,2,182,4],[182,5,182,6],[182,7,182,8],[182,11,182,12],[182,15,182,16],[183,1,185,4],[183,5,185,12],[183,15,183,16],[184,15,184,16],[180,2,180,4],[180,7,180,8],[180,11,180,12],[180,15,180,16],[181,2,181,4],[181,7,181,8],[181,11,181,12],[181,15,181,16],[178,7,179,8],[178,9,179,12],[172,2,172,4],[172,7,172,8],[172,11,172,12],[172,15,172,16],[169,7,170,8],[169,9,170,12],[173,1,175,4],[173,5,175,12],[173,15,173,16],[174,15,174,16],[163,11,163,12],[163,15,163,16],[160,7,161,8],[160,9,161,12],[164,15,164,16],[165,15,165,16],[171,2,171,4],[171,7,171,8],[171,11,171,12],[171,15,171,16],[102,2,102,4],[102,7,102,8],[102,11,102,12],[102,15,102,16],[101,2,101,4],[101,7,101,8],[101,11,101,12],[103,15,103,16],[104,1,106,4],[104,5,106,12],[104,15,104,16],[105,15,105,16],[103,2,103,4],[103,5,103,6],[103,7,103,8],[103,9,103,10],[103,11,103,12],[93,1,95,4],[93,5,95,12],[93,15,93,16],[94,15,94,16],[100,2,100,4],[100,7,100,8],[100,11,100,12],[100,15,100,16],[101,15,101,16],[90,2,90,4],[90,7,90,8],[90,11,90,12],[90,15,90,16],[91,15,91,16],[92,2,92,4],[92,5,92,6],[92,7,92,8],[92,11,92,12],[92,15,92,16],[91,2,91,4],[91,7,91,8],[91,11,91,12],[82,2,82,4],[82,7,82,8],[82,11,82,12],[82,15,82,16],[81,2,81,4],[81,7,81,8],[81,11,81,12],[83,1,85,4],[83,5,85,12],[83,15,83,16],[84,15,84,16],[74,15,74,16],[75,15,75,16],[73,2,73,4],[73,7,73,8],[73,11,73,12],[72,5,72,6],[73,5,73,6],[81,15,81,16],[20,11,20,16],[55,15,55,16],[56,15,56,16],[57,15,57,16],[58,15,58,16],[27,7,27,8],[38,1,40,4],[38,5,40,12],[48,1,50,4],[48,5,50,12],[36,2,36,4],[36,7,36,8],[36,11,36,12],[37,2,37,4],[27,11,27,12],[28,2,28,4],[28,7,28,8],[28,11,28,12],[27,15,27,16],[57,7,57,8],[57,11,57,12],[58,2,58,4],[46,7,46,8],[28,15,28,16],[29,15,29,16],[30,15,30,16],[36,15,36,16],[37,15,37,16],[38,15,38,16],[39,15,39,16],[45,15,45,16],[46,15,46,16],[110,11,110,16],[117,2,117,4],[117,7,117,8],[117,11,117,12],[117,15,117,16],[37,7,37,8],[37,11,37,12],[45,2,45,4],[45,7,45,8],[45,11,45,12],[59,1,61,4],[59,5,61,12],[57,2,57,4],[55,7,55,8],[55,11,55,12],[46,2,46,4],[46,11,46,12],[47,2,47,4],[47,5,47,6],[47,7,47,8],[47,9,47,10],[47,11,47,12],[58,5,58,6],[118,15,118,16],[119,15,119,16],[120,15,120,16],[47,15,47,16],[48,15,48,16],[49,15,49,16],[58,7,58,8],[55,2,55,4],[56,2,56,4],[56,7,56,8],[56,11,56,12],[65,11,65,16],[72,7,72,8],[72,11,72,12],[72,15,72,16],[58,9,58,10],[60,15,60,16],[73,15,73,16],[59,15,59,16],[58,11,58,12],[63,3,63,5],[128,15,128,16],[129,15,129,16],[135,2,135,4],[135,7,135,8],[135,11,135,12],[135,15,135,16],[126,2,126,4],[126,7,126,8],[126,11,126,12],[126,15,126,16],[127,2,127,4],[127,7,127,8],[127,11,127,12],[127,15,127,16],[133,7,134,8],[133,9,134,12],[138,15,138,16],[139,15,139,16],[145,2,145,4],[145,7,145,8],[145,11,145,12],[145,15,145,16],[143,7,144,8],[143,9,144,12],[136,2,136,4],[136,7,136,8],[136,11,136,12],[136,15,136,16],[137,2,137,4],[137,5,137,6],[137,7,137,8],[137,11,137,12],[137,15,137,16],[148,7,148,8],[148,9,148,10],[148,11,148,12],[148,15,148,16],[149,1,151,4],[149,5,151,12],[149,15,149,16],[150,15,150,16],[146,2,146,4],[146,7,146,8],[146,11,146,12],[146,15,146,16],[147,2,147,4],[147,7,147,8],[147,11,147,12],[147,15,147,16],[117,5,117,6],[118,5,118,6],[162,5,162,6],[163,5,163,6],[207,5,207,6],[208,5,208,6],[252,5,252,6],[253,5,253,6],[148,2,148,4],[148,5,148,6],[138,1,140,4],[138,5,140,12],[128,1,130,4],[128,5,130,12],[118,2,118,4],[118,7,118,8],[118,11,118,12],[155,11,155,16],[162,2,162,4],[162,7,162,8],[162,11,162,12],[162,15,162,16],[163,2,163,4],[163,7,163,8]]}
["Resultattabelle generieren"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Formeln Resultat",null,null,null,null,"Wert interpr. Resultat",null,null,null,null,"Text weiteres vorgehen"]
["Dropdownliste Amplifikation",null,null,null,null,null,"Dropdownliste Negativ Kontrolle",null,null,null,null,null,"Positiv",null,null,null,null,"Positiv:",4,null,null,null,"Positiv:","Stichprobe positiv und gültig. Resultat kann direkt verwendet werden. Einsendung dieser Stichprobe an Agroscope Wädenswil nicht erforderlich."]
["Yes",null,null,null,null,null,"Positive",null,null,null,null,null,{"$f":"IF(AND(F29=\"Ja\",H29>70,J29=\"Negativ\"),\"Positiv\",\"next_wenn\")","v":"next_wenn"},null,null,null,null,"Negativ:",1,null,null,null,"Negativ:","Stichprobe negativ und gültig. Falls die anderen Stichproben ebenfalls negativ sind, Stichprobe an Agroscope Wädenswil zur Sequenzierung einsenden."]
["No",null,null,null,null,null,"Negative",null,null,null,null,null,"Neg.",null,null,null,null,"Ungültig:",0.05,null,null,null,"Ungültig:","Stichprobe ungültig. Falls die anderen Stichprobe ebenfalls ungültig oder negativ sind, Stichprobe an Agroscope Wädenswil zur Überprüfung einsenden."]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(F29=\"Nein\",OR(H29<70,H29=\"\"),J29=\"Negativ\"),\"Negativ\",\"Ungültig\")","v":"Ungültig"}]
[]
["Formel Interpretation Text weiteres vorgehen"]
["Situation 1: Bemisia tabaci od. Bacterocera dorsalis (1 Probe)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Range Kriterium Schmelztemperatur"]
["\"=WENN(UND(F29=\"\";H29=\"\";J29=\"\");\"\";WENN(UND(F29=\"Ja\";H29>ResultTab!$Y$12;H29<ResultTab!$Z$12;J29=\"Negativ\");\"Positiv\";WENN(UND(F29=\"Nein\";ODER(H29<ResultTab!$Y$12;H29=\"\");J29=\"Negativ\");\"Negativ\";\"Ungültig\")))\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Organimus","Tm [°C]","Untere Grenze [°C]","Obere Grenze [°C]"]
["Summe: Positiv = 4, Negativ = 1, Ungültig = else",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bemisia tabaci",83.5,80,85.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bactrocera dorsalis",83.8,80,85.8]
["Situation 2: Thrips palmi od. Scirtothrips dorsalis (2 Probe)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thysanoptera",82,78,84]
["\"=WENN(UND(F47=\"\";H47=\"\";J47=\"\");\"\";WENN(UND(F47=\"Ja\";H47>ResultTab!$Y$14;H47<ResultTab!$Z$14;J47=\"Negativ\");\"Positiv\";WENN(UND(F47=\"Nein\";ODER(H47<ResultTab!$Y$14;H47=\"\");J47=\"Negativ\");\"Negativ\";\"Ungültig\")))\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Liriomyza",82,79,84]
["Summe: Positiv = 5, Negativ = 2, Ungültig = else"]
[]
["Situation 3: Liriomyza trifolii, Liriomyza sativae od. Liriomyza huuidobrensis  (3 Probe)"]
["\"=WENN(UND(F57=\"\";H57=\"\";J57=\"\");\"\";WENN(UND(F57=\"Ja\";H57>ResultTab!$Y$15;H57<ResultTab!$Z$15=\"Negativ\");\"Positiv\";WENN(UND(F57=\"Nein\";ODER(H57<ResultTab!$Y$15;H57=\"\");J57=\"Negativ\");\"Negativ\";\"Ungültig\")))\""]
["Summe: Positiv = 6, Negativ = 3, Ungültig = else"]
[null,null,null,null,null,null,null,null,null,null,null,"Versteckte Zelle Summe (wird mitkopiert!!)"]
[]
["Sample 1"]
[]
[null,"Sample 1"]
[]
[null,"LAMP assay:",null,null,"Bemisia tabaci"]
[null,null,"Organism",null,null,"Amplification",null,"Annealing [°C]",null,"PAC","NAC","Result",null,null,null,"Wert Resultat"]
[null,null,"Bemisia tabaci",null,null,null,null,null,null,null,null,{"$f":"IF(AND(K29=\"\"),\"\",IF(AND(F29=\"Yes\",H29>ResultTab!$Y$12,H29<ResultTab!$Z$12,K29=\"Negative\",J29=\"Positive\"),\"Positive\",IF(AND(K29=\"Positive\",J29=\"Negative\",OR(H29<ResultTab!$Y$12,H29>ResultTab!$Z$12,H29=0)),\"Invalid\",IF(AND(F29=\"No\",K29=\"Negative\",J29=\"Positive\",H29=0),\"Negative\",\"Invalide\"))))","v":""},null,{"$f":"IF(L29=\"\",\"n/a\",IF(L29=\"Ungültig\",0.05,IF(L29=\"Negativ\",1,4)))","v":"n/a"},null,{"$f":"IF(L29=\"\",\"n/a\",IF(L29=\"Ungültig\",0.05,IF(L29=\"Negativ\",1,4)))","v":"n/a"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N29","v":"n/a"},null,{"$f":"P29","v":"n/a"}]
[]
[]
[null,"Stichprobe 1"]
[null,"Probe Nr.:",null,null,{"$f":"Eingabeformular!$F$29","v":0},null,null,"Bemerkung \nzur Probe:"]
[null,"Verdachtsorganismus:",null,null,"Bacterocera Triplex"]
[null,null,"Organismus",null,null,"Amplifikation","Zeit","Annealing [°C]",null,"Pos. Kontr.","Neg. Kontr.","Resultat",null,null,null,"Wert Resultat"]
[null,null,"Bacterocera Triplex",null,null,null,null,null,null,null,null,{"$f":"IF(AND(K38=\"\"),\"\",IF(AND(F38=\"Ja\",H38>ResultTab!$Y$13,H38<ResultTab!$Z$13,K38=\"Negativ\",J38=\"Positiv\"),\"Positiv\",IF(AND(K38=\"Positiv\",J38=\"Negativ\",OR(H38<ResultTab!$Y$13,H38>ResultTab!$Z$13,H38=0)),\"Ungültig\",IF(AND(F38=\"Nein\",K38=\"Negativ\",J38=\"Positiv\",H38=0),\"Negativ\",\"Ungültig\"))))","v":""},null,{"$f":"IF(L38=\"\",\"n/a\",IF(L38=\"Ungültig\",0.05,IF(L38=\"Negativ\",1,4)))","v":"n/a"},null,{"$f":"IF(L38=\"\",\"n/a\",IF(L38=\"Ungültig\",0.05,IF(L38=\"Negativ\",1,4)))","v":"n/a"}]
[null,"Weiteres vorgehen: ",null,null,null,{"$f":"IF(N40=\"n/a\",\"\",IF(N40=4,ResultTab!$X$4,IF(N40=1,ResultTab!$X$5,ResultTab!$X$6)))","v":""},null,null,null,null,null,null,null,null,null,"Summe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N38","v":"n/a"},null,{"$f":"P38","v":"n/a"}]
[]
[]
[null,"Stichprobe 1"]
[null,"Probe Nr.:",null,null,{"$f":"Eingabeformular!$F$29","v":0},null,null,"Bemerkung \nzur Probe:"]
[null,"Verdachtsorganismus:",null,null,"Thysanoptera"]
[null,null,"Organismus",null,null,"Amplifikation","Zeit","Annealing [°C]",null,"Pos. Kontr.","Neg. Kontr.","Resultat",null,null,null,"Wert Resultat"]
[null,null,"Thrips palmi",null,null,null,null,null,null,null,null,{"$f":"IF(AND(K47=\"\"),\"\",IF(AND(F47=\"Ja\",H47>ResultTab!$Y$14,H47<ResultTab!$Z$14,K47=\"Negativ\",J47=\"Positiv\"),\"Positiv\",IF(AND(K47=\"Positiv\",J47=\"Negativ\",OR(H47<ResultTab!$Y$14,H47>ResultTab!$Z$14,H47=0)),\"Ungültig\",IF(AND(F47=\"Nein\",K47=\"Negativ\",J47=\"Positiv\",H47=0),\"Negativ\",\"Ungültig\"))))","v":""},null,{"$f":"IF(L47=\"\",\"n/a\",IF(L47=\"Ungültig\",0.05,IF(L47=\"Negativ\",1,4)))","v":"n/a"},null,{"$f":"IF(L47=\"\",\"n/a\",IF(L47=\"Ungültig\",0.05,IF(L47=\"Negativ\",1,4)))","v":"n/a"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(F48=\"\",H48=\"\",J48=\"\"),\"\",IF(AND(F48=\"Ja\",H48>ResultTab!$Y$14,H48<ResultTab!$Z$14,J48=\"Negativ\"),\"Positiv\",IF(AND(F48=\"Nein\",OR(H48<ResultTab!$Y$14,H48=\"\"),J48=\"Negativ\"),\"Negativ\",\"Ungültig\")))","v":""},null,null,null,{"$f":"IF(L48=\"\",\"n/a\",IF(L48=\"Ungültig\",0.05,IF(L48=\"Negativ\",1,4)))","v":"n/a"}]
[null,"Weiteres vorgehen: ",null,null,null,{"$f":"IF(N47=\"n/a\",\"\",IF(N47=4,ResultTab!$X$4,IF(N47=1,ResultTab!$X$5,ResultTab!$X$6)))","v":""},null,null,null,null,null,null,null,null,null,"Summe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N47","v":"n/a"},null,{"$f":"SUM(P47:Q48)","v":0}]
[]
[]
[null,"Stichprobe 1"]
[null,"Probe Nr.:",null,null,{"$f":"Eingabeformular!$F$29","v":0},null,null,"Bemerkung \nzur Probe:"]
[null,"Verdachtsorganismus:",null,null,"Liriomyza"]
[null,"Pos","Organismus",null,null,"Amplifikation","Zeit","Annealing [°C]",null,"Pos. Kontr.","Neg. Kontr.","Resultat",null,null,null,"Wert Resultat"]
[null,"A1","L. sativae",null,null,null,null,null,null,null,null,{"$f":"IF(AND(K57=\"\"),\"\",IF(AND(F57=\"Ja\",H57>ResultTab!$Y$15,H57<ResultTab!$Z$15,K57=\"Negativ\",J57=\"Positiv\"),\"Positiv\",IF(AND(K57=\"Positiv\",J57=\"Negativ\",OR(H57<ResultTab!$Y$15,H57>ResultTab!$Z$15,H57=0)),\"Ungültig\",IF(AND(F57=\"Nein\",K57=\"Negativ\",J57=\"Positiv\",H57=0),\"Negativ\",\"Ungültig\"))))","v":""},null,{"$f":"IF(L57=\"\",\"n/a\",IF(L57=\"Ungültig\",0.05,IF(L57=\"Negativ\",1,4)))","v":"n/a"},null,{"$f":"IF(L57=\"\",\"n/a\",IF(L57=\"Ungültig\",0.05,IF(L57=\"Negativ\",1,4)))","v":"n/a"}]
[null,"A5","L. trifolii / L. huidobrensis",null,null,null,null,null,null,null,null,{"$f":"IF(AND(K58=\"\"),\"\",IF(AND(F58=\"Ja\",H58>ResultTab!$Y$15,H58<ResultTab!$Z$15,K58=\"Negativ\",J58=\"Positiv\"),\"Positiv\",IF(AND(K58=\"Positiv\",J58=\"Negativ\",OR(H58<ResultTab!$Y$15,H58>ResultTab!$Z$15,H58=0)),\"Ungültig\",IF(AND(F58=\"Nein\",K58=\"Negativ\",J58=\"Positiv\",H58=0),\"Negativ\",\"Ungültig\"))))","v":""},null,{"$f":"IF(L58=\"\",\"n/a\",IF(L58=\"Ungültig\",0.05,IF(L58=\"Negativ\",1,4)))","v":"n/a"},null,{"$f":"IF(L58=\"\",\"n/a\",IF(L58=\"Ungültig\",0.05,IF(L58=\"Negativ\",1,4)))","v":"n/a"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L59=\"\",\"n/a\",IF(L59=\"Ungültig\",0.05,IF(L59=\"Negativ\",1,4)))","v":"n/a"}]
[null,"Weiteres vorgehen: ",null,null,null,{"$f":"IF(OR(K57=\"\",K58=\"\",J57=\"\",J58=\"\"),\"\",IF(N61=\"0\",\"\",IF(N61=5,ResultTab!$X$4,IF(N61=2,ResultTab!$X$5,IF(N61>0.01,ResultTab!$X$6,\"\")))))","v":""},null,null,null,null,null,null,null,null,null,"Summe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N57, N58)","v":0},null,{"$f":"SUM(P57:Q59)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Versteckte Zelle Summe (wird mitkopiert!!)"]
[]
["Sample 2"]
[]
[null,"Sample 2"]
[]
[null,"LAMP assay:",null,null,"Bemisia tabaci"]
[null,null,"Organism",null,null,"Amplification",null,"Annealing [°C]",null,"PAC","NAC","Result",null,null,null,"Wert Resultat"]
[null,null,"Bemisia tabaci",null,null,null,null,null,null,null,null,{"$f":"IF(AND(K74=\"\"),\"\",IF(AND(F74=\"Yes\",H74>ResultTab!$Y$12,H74<ResultTab!$Z$12,K74=\"Negative\",J74=\"Positive\"),\"Positive\",IF(AND(K74=\"Positive\",J74=\"Negative\",OR(H74<ResultTab!$Y$12,H74>ResultTab!$Z$12,H74=0)),\"Invalid\",IF(AND(F74=\"No\",K74=\"Negative\",J74=\"Positive\",H74=0),\"Negative\",\"Invalid\"))))","v":""},null,{"$f":"IF(L74=\"\",\"n/a\",IF(L74=\"Ungültig\",0.05,IF(L74=\"Negativ\",1,4)))","v":"n/a"},null,{"$f":"IF(L74=\"\",\"n/a\",IF(L74=\"Ungültig\",0.05,IF(L74=\"Negativ\",1,4)))","v":"n/a"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N74","v":"n/a"},null,{"$f":"P74","v":"n/a"}]
[]
[]
[null,"Stichprobe 2"]
[null,"Probe Nr.:",null,null,null,null,null,"Bemerkung \nzur Probe:"]
[null,"Verdachtsorganismus:",null,null,"Bacterocera Triplex"]
[null,null,"Organismus",null,null,"Amplifikation",null,"Annealing [°C]",null,"Pos. Kontr.","Neg. Kontr.","Resultat",null,null,null,"Wert Resultat"]
[null,null,"Bacterocera Triplex",null,null,null,null,null,null,null,null,{"$f":"IF(AND(K83=\"\"),\"\",IF(AND(F83=\"Ja\",H83>ResultTab!$Y$13,H83<ResultTab!$Z$13,K83=\"Negativ\",J83=\"Positiv\"),\"Positiv\",IF(AND(K83=\"Positiv\",J83=\"Negativ\",OR(H83<ResultTab!$Y$13,H83>ResultTab!$Z$13,H83=0)),\"Ungültig\",IF(AND(F83=\"Nein\",K83=\"Negativ\",J83=\"Positiv\",H83=0),\"Negativ\",\"Ungültig\"))))","v":""},null,{"$f":"IF(L83=\"\",\"n/a\",IF(L83=\"Ungültig\",0.05,IF(L83=\"Negativ\",1,4)))","v":"n/a"},null,{"$f":"IF(L83=\"\",\"n/a\",IF(L83=\"Ungültig\",0.05,IF(L83=\"Negativ\",1,4)))","v":"n/a"}]
[null,"Weiteres vorgehen: ",null,null,null,{"$f":"IF(N85=\"n/a\",\"\",IF(N85=4,ResultTab!$X$4,IF(N85=1,ResultTab!$X$5,ResultTab!$X$6)))","v":""},null,null,null,null,null,null,null,null,null,"Summe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N83","v":"n/a"},null,{"$f":"P83","v":"n/a"}]
[]
[]
[null,"Stichprobe 2"]
[null,"Probe Nr.:",null,null,{"$f":"Eingabeformular!$K$29","v":0},null,null,"Bemerkung \nzur Probe:"]
[null,"Verdachtsorganismus:",null,null,"Thysanoptera"]
[null,null,"Organismus",null,null,"Amplifikation",null,"Annealing [°C]",null,"Pos. Kontr.","Neg. Kontr.","Resultat",null,null,null,"Wert Resultat"]
[null,null,"Thrips palmi",null,null,null,null,null,null,null,null,{"$f":"IF(AND(K92=\"\"),\"\",IF(AND(F92=\"Ja\",H92>ResultTab!$Y$14,H92<ResultTab!$Z$14,K92=\"Negativ\",J92=\"Positiv\"),\"Positiv\",IF(AND(K92=\"Positiv\",J92=\"Negativ\",OR(H92<ResultTab!$Y$14,H92>ResultTab!$Z$14,H92=0)),\"Ungültig\",IF(AND(F92=\"Nein\",K92=\"Negativ\",J92=\"Positiv\",H92=0),\"Negativ\",\"Ungültig\"))))","v":""},null,{"$f":"IF(L92=\"\",\"n/a\",IF(L92=\"Ungültig\",0.05,IF(L92=\"Negativ\",1,4)))","v":"n/a"},null,{"$f":"IF(L92=\"\",\"n/a\",IF(L92=\"Ungültig\",0.05,IF(L92=\"Negativ\",1,4)))","v":"n/a"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L93=\"\",\"n/a\",IF(L93=\"Ungültig\",0.05,IF(L93=\"Negativ\",1,4)))","v":"n/a"}]
[null,"Weiteres vorgehen: ",null,null,null,{"$f":"IF(N95=\"n/a\",\"\",IF(N95=4,ResultTab!$X$4,IF(N95=1,ResultTab!$X$5,ResultTab!$X$6)))","v":""},null,null,null,null,null,null,null,null,null,"Summe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N92","v":"n/a"},null,{"$f":"SUM(P92:Q93)","v":0}]
[]
[]
[null,"Stichprobe 2"]
[null,"Probe Nr.:",null,null,{"$f":"Eingabeformular!$K$29","v":0},null,null,"Bemerkung \nzur Probe:"]
[null,"Verdachtsorganismus:",null,null,"Liriomyza"]
[null,"Pos","Organismus",null,null,"Amplifikation",null,"Annealing [°C]",null,"Pos. Kontr.","Neg. Kontr.","Resultat",null,null,null,"Wert Resultat"]
[null,"A2","L. sativae",null,null,null,null,null,null,null,null,{"$f":"IF(AND(K102=\"\"),\"\",IF(AND(F102=\"Ja\",H102>ResultTab!$Y$15,H102<ResultTab!$Z$15,K102=\"Negativ\",J102=\"Positiv\"),\"Positiv\",IF(AND(K102=\"Positiv\",J102=\"Negativ\",OR(H102<ResultTab!$Y$15,H102>ResultTab!$Z$15,H102=0)),\"Ungültig\",IF(AND(F102=\"Nein\",K102=\"Negativ\",J102=\"Positiv\",H102=0),\"Negativ\",\"Ungültig\"))))","v":""},null,{"$f":"IF(L102=\"\",\"n/a\",IF(L102=\"Ungültig\",0.05,IF(L102=\"Negativ\",1,4)))","v":"n/a"},null,{"$f":"IF(L102=\"\",\"n/a\",IF(L102=\"Ungültig\",0.05,IF(L102=\"Negativ\",1,4)))","v":"n/a"}]
[null,"A6","L. trifolii / L. huidobrensis",null,null,null,null,null,null,null,null,{"$f":"IF(AND(K103=\"\"),\"\",IF(AND(F103=\"Ja\",H103>ResultTab!$Y$15,H103<ResultTab!$Z$15,K103=\"Negativ\",J103=\"Positiv\"),\"Positiv\",IF(AND(K103=\"Positiv\",J103=\"Negativ\",OR(H103<ResultTab!$Y$15,H103>ResultTab!$Z$15,H103=0)),\"Ungültig\",IF(AND(F103=\"Nein\",K103=\"Negativ\",J103=\"Positiv\",H103=0),\"Negativ\",\"Ungültig\"))))","v":""},null,{"$f":"IF(L103=\"\",\"n/a\",IF(L103=\"Ungültig\",0.05,IF(L103=\"Negativ\",1,4)))","v":"n/a"},null,{"$f":"IF(L103=\"\",\"n/a\",IF(L103=\"Ungültig\",0.05,IF(L103=\"Negativ\",1,4)))","v":"n/a"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(F104=\"\",H104=\"\",J104=\"\"),\"\",IF(AND(F104=\"Ja\",H104>ResultTab!$Y$15,H104<ResultTab!$Z$15,J104=\"Negativ\"),\"Positiv\",IF(AND(F104=\"Nein\",OR(H104<ResultTab!$Y$15,H104=\"\"),J104=\"Negativ\"),\"Negativ\",\"Ungültig\")))","v":""},null,null,null,{"$f":"IF(L104=\"\",\"n/a\",IF(L104=\"Ungültig\",0.05,IF(L104=\"Negativ\",1,4)))","v":"n/a"}]
[null,"Weiteres vorgehen: ",null,null,null,{"$f":"IF(OR(K102=\"\",K103=\"\",J102=\"\",J103=\"\"),\"\",IF(N106=\"0\",\"\",IF(N106=5,ResultTab!$X$4,IF(N106=2,ResultTab!$X$5,IF(N106>0.01,ResultTab!$X$6,\"\")))))","v":""},null,null,null,null,null,null,null,null,null,"Summe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N102, N103)","v":0},null,{"$f":"SUM(P102:Q104)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Versteckte Zelle Summe (wird mitkopiert!!)"]
[]
["Sample 3"]
[]
[null,"Sample 3",null,null,null,"GENIE-Position A5"]
[]
[null,"LAMP assay:",null,null,"Bemisia tabaci"]
[null,null,"Organism",null,null,"Amplification",null,"Annealing [°C]",null,"PAC","NAC","Result",null,null,null,"Wert Resultat"]
[null,null,"Bemisia tabaci",null,null,null,null,null,null,null,null,{"$f":"IF(AND(K119=\"\"),\"\",IF(AND(F119=\"Yes\",H119>ResultTab!$Y$12,H119<ResultTab!$Z$12,K119=\"Negative\",J119=\"Positive\"),\"Positive\",IF(AND(K119=\"Positive\",J119=\"Negative\",OR(H119<ResultTab!$Y$12,H119>ResultTab!$Z$12,H119=0)),\"Invalid\",IF(AND(F119=\"No\",K119=\"Negative\",J119=\"Positive\",H119=0),\"Negative\",\"Invalid\"))))","v":""},null,{"$f":"IF(L119=\"\",\"n/a\",IF(L119=\"Ungültig\",0.05,IF(L119=\"Negativ\",1,4)))","v":"n/a"},null,{"$f":"IF(L119=\"\",\"n/a\",IF(L119=\"Ungültig\",0.05,IF(L119=\"Negativ\",1,4)))","v":"n/a"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N119","v":"n/a"},null,{"$f":"P119","v":"n/a"}]
[]
[]
[null,"Stichprobe 3",null,null,null,"GENIE-Position A5"]
[null,"Probe Nr.:",null,null,{"$f":"Eingabeformular!$P$29","v":0},null,null,"Bemerkung \nzur Probe:"]
[null,"Verdachtsorganismus:",null,null,"Bacterocera Triplex"]
[null,null,"Organismus",null,null,"Amplifikation","Zeit","Annealing [°C]",null,"Pos. Kontr.","Neg. Kontr.","Resultat",null,null,null,"Wert Resultat"]
[null,null,"Bacterocera Triplex",null,null,null,null,null,null,null,null,{"$f":"IF(AND(K128=\"\"),\"\",IF(AND(F128=\"Ja\",H128>ResultTab!$Y$13,H128<ResultTab!$Z$13,K128=\"Negativ\",J128=\"Positiv\"),\"Positiv\",IF(AND(K128=\"Positiv\",J128=\"Negativ\",OR(H128<ResultTab!$Y$13,H128>ResultTab!$Z$13,H128=0)),\"Ungültig\",IF(AND(F128=\"Nein\",K128=\"Negativ\",J128=\"Positiv\",H128=0),\"Negativ\",\"Ungültig\"))))","v":""},null,{"$f":"IF(L128=\"\",\"n/a\",IF(L128=\"Ungültig\",0.05,IF(L128=\"Negativ\",1,4)))","v":"n/a"},null,{"$f":"IF(L128=\"\",\"n/a\",IF(L128=\"Ungültig\",0.05,IF(L128=\"Negativ\",1,4)))","v":"n/a"}]
[null,"Weiteres vorgehen: ",null,null,null,{"$f":"IF(N130=\"n/a\",\"\",IF(N130=4,ResultTab!$X$4,IF(N130=1,ResultTab!$X$5,ResultTab!$X$6)))","v":""},null,null,null,null,null,null,null,null,null,"Summe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N128","v":"n/a"},null,{"$f":"P128","v":"n/a"}]
[]
[]
[null,"Stichprobe 3",null,null,null,"GENIE-Position A5"]
[null,"Probe Nr.:",null,null,{"$f":"Eingabeformular!$P$29","v":0},null,null,"Bemerkung \nzur Probe:"]
[null,"Verdachtsorganismus:",null,null,"Thysanoptera"]
[null,null,"Organismus",null,null,"Amplifikation","Zeit","Annealing [°C]",null,"Pos. Kontr.","Neg. Kontr.","Resultat",null,null,null,"Wert Resultat"]
[null,null,"Thrips palmi",null,null,null,null,null,null,null,null,{"$f":"IF(AND(K137=\"\"),\"\",IF(AND(F137=\"Ja\",H137>ResultTab!$Y$14,H137<ResultTab!$Z$14,K137=\"Negativ\",J137=\"Positiv\"),\"Positiv\",IF(AND(K137=\"Positiv\",J137=\"Negativ\",OR(H137<ResultTab!$Y$14,H137>ResultTab!$Z$14,H137=0)),\"Ungültig\",IF(AND(F137=\"Nein\",K137=\"Negativ\",J137=\"Positiv\",H137=0),\"Negativ\",\"Ungültig\"))))","v":""},null,{"$f":"IF(L137=\"\",\"n/a\",IF(L137=\"Ungültig\",0.05,IF(L137=\"Negativ\",1,4)))","v":"n/a"},null,{"$f":"IF(L137=\"\",\"n/a\",IF(L137=\"Ungültig\",0.05,IF(L137=\"Negativ\",1,4)))","v":"n/a"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L138=\"\",\"n/a\",IF(L138=\"Ungültig\",0.05,IF(L138=\"Negativ\",1,4)))","v":"n/a"}]
[null,"Weiteres vorgehen: ",null,null,null,{"$f":"IF(N140=\"n/a\",\"\",IF(N140=4,ResultTab!$X$4,IF(N140=1,ResultTab!$X$5,ResultTab!$X$6)))","v":""},null,null,null,null,null,null,null,null,null,"Summe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N137","v":"n/a"},null,{"$f":"SUM(P137:Q138)","v":0}]
[]
[]
[null,"Stichprobe 3",null,null,null,"GENIE-Position siehe Pos"]
[null,"Probe Nr.:",null,null,{"$f":"Eingabeformular!$P$29","v":0},null,null,"Bemerkung \nzur Probe:"]
[null,"Verdachtsorganismus:",null,null,"Liriomyza"]
[null,"Pos","Organismus",null,null,"Amplifikation","Zeit","Annealing [°C]",null,"Pos. Kontr.","Neg. Kontr.","Resultat",null,null,null,"Wert Resultat"]
[null,"B1","L. sativae",null,null,null,null,null,null,null,null,{"$f":"IF(AND(K147=\"\"),\"\",IF(AND(F147=\"Ja\",H147>ResultTab!$Y$15,H147<ResultTab!$Z$15,K147=\"Negativ\",J147=\"Positiv\"),\"Positiv\",IF(AND(K147=\"Positiv\",J147=\"Negativ\",OR(H147<ResultTab!$Y$15,H147>ResultTab!$Z$15,H147=0)),\"Ungültig\",IF(AND(F147=\"Nein\",K147=\"Negativ\",J147=\"Positiv\",H147=0),\"Negativ\",\"Ungültig\"))))","v":""},null,{"$f":"IF(L147=\"\",\"n/a\",IF(L147=\"Ungültig\",0.05,IF(L147=\"Negativ\",1,4)))","v":"n/a"},null,{"$f":"IF(L147=\"\",\"n/a\",IF(L147=\"Ungültig\",0.05,IF(L147=\"Negativ\",1,4)))","v":"n/a"}]
[null,"B5","L. trifolii / L. huidobrensis",null,null,null,null,null,null,null,null,{"$f":"IF(AND(K148=\"\"),\"\",IF(AND(F148=\"Ja\",H148>ResultTab!$Y$15,H148<ResultTab!$Z$15,K148=\"Negativ\",J148=\"Positiv\"),\"Positiv\",IF(AND(K148=\"Positiv\",J148=\"Negativ\",OR(H148<ResultTab!$Y$15,H148>ResultTab!$Z$15,H148=0)),\"Ungültig\",IF(AND(F148=\"Nein\",K148=\"Negativ\",J148=\"Positiv\",H148=0),\"Negativ\",\"Ungültig\"))))","v":""},null,{"$f":"IF(L148=\"\",\"n/a\",IF(L148=\"Ungültig\",0.05,IF(L148=\"Negativ\",1,4)))","v":"n/a"},null,{"$f":"IF(L148=\"\",\"n/a\",IF(L148=\"Ungültig\",0.05,IF(L148=\"Negativ\",1,4)))","v":"n/a"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(F149=\"\",H149=\"\",J149=\"\"),\"\",IF(AND(F149=\"Ja\",H149>ResultTab!$Y$15,H149<ResultTab!$Z$15,J149=\"Negativ\"),\"Positiv\",IF(AND(F149=\"Nein\",OR(H149<ResultTab!$Y$15,H149=\"\"),J149=\"Negativ\"),\"Negativ\",\"Ungültig\")))","v":""},null,null,null,{"$f":"IF(L149=\"\",\"n/a\",IF(L149=\"Ungültig\",0.05,IF(L149=\"Negativ\",1,4)))","v":"n/a"}]
[null,"Weiteres vorgehen: ",null,null,null,{"$f":"IF(OR(K147=\"\",K148=\"\",J147=\"\",J148=\"\"),\"\",IF(N151=\"0\",\"\",IF(N151=5,ResultTab!$X$4,IF(N151=2,ResultTab!$X$5,IF(N151>0.01,ResultTab!$X$6,\"\")))))","v":""},null,null,null,null,null,null,null,null,null,"Summe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N147:N148)","v":0},null,{"$f":"SUM(P147:Q149)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Versteckte Zelle Summe (wird mitkopiert!!)"]
[]
["Sample 4"]
[]
[null,"Sample 4"]
[]
[null,"LAMP assay",null,null,"Bemisia tabaci"]
[null,null,"Organism",null,null,"Amplification",null,"Annealing [°C]",null,"PAC","NAC","Result",null,null,null,"Wert Resultat"]
[null,null,"Bemisia tabaci",null,null,null,null,null,null,null,null,{"$f":"IF(AND(K164=\"\"),\"\",IF(AND(F164=\"Yes\",H164>ResultTab!$Y$12,H164<ResultTab!$Z$12,K164=\"Negative\",J164=\"Positive\"),\"Positive\",IF(AND(K164=\"Positive\",J164=\"Negative\",OR(H164<ResultTab!$Y$12,H164>ResultTab!$Z$12,H164=0)),\"Invalid\",IF(AND(F164=\"No\",K164=\"Negative\",J164=\"Positive\",H164=0),\"Negative\",\"Invalid\"))))","v":""},null,{"$f":"IF(L164=\"\",\"n/a\",IF(L164=\"Ungültig\",0.05,IF(L164=\"Negativ\",1,4)))","v":"n/a"},null,{"$f":"IF(L164=\"\",\"n/a\",IF(L164=\"Ungültig\",0.05,IF(L164=\"Negativ\",1,4)))","v":"n/a"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N164","v":"n/a"},null,{"$f":"P164","v":"n/a"}]
[]
[]
[null,"Stichprobe 4",null,null,null,"GENIE-Position A6"]
[null,"Probe Nr.:",null,null,{"$f":"Eingabeformular!$F$35","v":0},null,null,"Bemerkung \nzur Probe:"]
[null,"Verdachtsorganismus:",null,null,"Bacterocera Triplex"]
[null,null,"Organismus",null,null,"Amplifikation","Zeit","Annealing [°C]",null,"Pos. Kontr.","Neg. Kontr.","Resultat",null,null,null,"Wert Resultat"]
[null,null,"Bacterocera Triplex",null,null,null,null,null,null,null,null,{"$f":"IF(AND(K173=\"\"),\"\",IF(AND(F173=\"Ja\",H173>ResultTab!$Y$13,H173<ResultTab!$Z$13,K173=\"Negativ\",J173=\"Positiv\"),\"Positiv\",IF(AND(K173=\"Positiv\",J173=\"Negativ\",OR(H173<ResultTab!$Y$13,H173>ResultTab!$Z$13,H173=0)),\"Ungültig\",IF(AND(F173=\"Nein\",K173=\"Negativ\",J173=\"Positiv\",H173=0),\"Negativ\",\"Ungültig\"))))","v":""},null,{"$f":"IF(L173=\"\",\"n/a\",IF(L173=\"Ungültig\",0.05,IF(L173=\"Negativ\",1,4)))","v":"n/a"},null,{"$f":"IF(L173=\"\",\"n/a\",IF(L173=\"Ungültig\",0.05,IF(L173=\"Negativ\",1,4)))","v":"n/a"}]
[null,"Weiteres vorgehen: ",null,null,null,{"$f":"IF(N175=\"n/a\",\"\",IF(N175=4,ResultTab!$X$4,IF(N175=1,ResultTab!$X$5,ResultTab!$X$6)))","v":""},null,null,null,null,null,null,null,null,null,"Summe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N173","v":"n/a"},null,{"$f":"P173","v":"n/a"}]
[]
[]
[null,"Stichprobe 4",null,null,null,"GENIE-Position A6"]
[null,"Probe Nr.:",null,null,{"$f":"Eingabeformular!$F$35","v":0},null,null,"Bemerkung \nzur Probe:"]
[null,"Verdachtsorganismus:",null,null,"Thysanoptera"]
[null,null,"Organismus",null,null,"Amplifikation","Zeit","Annealing [°C]",null,"Pos. Kontr.","Neg. Kontr.","Resultat",null,null,null,"Wert Resultat"]
[null,null,"Thrips palmi",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L182=\"\",\"n/a\",IF(L182=\"Ungültig\",0.05,IF(L182=\"Negativ\",1,4)))","v":"n/a"},null,{"$f":"IF(L182=\"\",\"n/a\",IF(L182=\"Ungültig\",0.05,IF(L182=\"Negativ\",1,4)))","v":"n/a"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L183=\"\",\"n/a\",IF(L183=\"Ungültig\",0.05,IF(L183=\"Negativ\",1,4)))","v":"n/a"}]
[null,"Weiteres vorgehen: ",null,null,null,{"$f":"IF(N185=\"n/a\",\"\",IF(N185=4,ResultTab!$X$4,IF(N185=1,ResultTab!$X$5,ResultTab!$X$6)))","v":""},null,null,null,null,null,null,null,null,null,"Summe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N182","v":"n/a"},null,{"$f":"SUM(P182:Q183)","v":0}]
[]
[]
[null,"Stichprobe 4",null,null,null,"GENIE-Position siehe Pos"]
[null,"Probe Nr.:",null,null,{"$f":"Eingabeformular!$F$35","v":0},null,null,"Bemerkung \nzur Probe:"]
[null,"Verdachtsorganismus:",null,null,"Liriomyza"]
[null,"Pos","Organismus",null,null,"Amplifikation","Zeit","Annealing [°C]",null,"Pos. Kontr.","Neg. Kontr.","Resultat",null,null,null,"Wert Resultat"]
[null,"B2","L. sativae",null,null,null,null,null,null,null,null,{"$f":"IF(AND(K192=\"\"),\"\",IF(AND(F192=\"Ja\",H192>ResultTab!$Y$15,H192<ResultTab!$Z$15,K192=\"Negativ\",J192=\"Positiv\"),\"Positiv\",IF(AND(K192=\"Positiv\",J192=\"Negativ\",OR(H192<ResultTab!$Y$15,H192>ResultTab!$Z$15,H192=0)),\"Ungültig\",IF(AND(F192=\"Nein\",K192=\"Negativ\",J192=\"Positiv\",H192=0),\"Negativ\",\"Ungültig\"))))","v":""},null,{"$f":"IF(L192=\"\",\"n/a\",IF(L192=\"Ungültig\",0.05,IF(L192=\"Negativ\",1,4)))","v":"n/a"},null,{"$f":"IF(L192=\"\",\"n/a\",IF(L192=\"Ungültig\",0.05,IF(L192=\"Negativ\",1,4)))","v":"n/a"}]
[null,"B6","L. trifolii / L. huidobrensis",null,null,null,null,null,null,null,null,{"$f":"IF(AND(K193=\"\"),\"\",IF(AND(F193=\"Ja\",H193>ResultTab!$Y$15,H193<ResultTab!$Z$15,K193=\"Negativ\",J193=\"Positiv\"),\"Positiv\",IF(AND(K193=\"Positiv\",J193=\"Negativ\",OR(H193<ResultTab!$Y$15,H193>ResultTab!$Z$15,H193=0)),\"Ungültig\",IF(AND(F193=\"Nein\",K193=\"Negativ\",J193=\"Positiv\",H193=0),\"Negativ\",\"Ungültig\"))))","v":""},null,{"$f":"IF(L193=\"\",\"n/a\",IF(L193=\"Ungültig\",0.05,IF(L193=\"Negativ\",1,4)))","v":"n/a"},null,{"$f":"IF(L193=\"\",\"n/a\",IF(L193=\"Ungültig\",0.05,IF(L193=\"Negativ\",1,4)))","v":"n/a"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(F194=\"\",H194=\"\",J194=\"\"),\"\",IF(AND(F194=\"Ja\",H194>ResultTab!$Y$15,H194<ResultTab!$Z$15,J194=\"Negativ\"),\"Positiv\",IF(AND(F194=\"Nein\",OR(H194<ResultTab!$Y$15,H194=\"\"),J194=\"Negativ\"),\"Negativ\",\"Ungültig\")))","v":""},null,null,null,{"$f":"IF(L194=\"\",\"n/a\",IF(L194=\"Ungültig\",0.05,IF(L194=\"Negativ\",1,4)))","v":"n/a"}]
[null,"Weiteres vorgehen: ",null,null,null,{"$f":"IF(OR(K192=\"\",K193=\"\",J192=\"\",J193=\"\"),\"\",IF(N196=\"0\",\"\",IF(N196=5,ResultTab!$X$4,IF(N196=2,ResultTab!$X$5,IF(N196>0.01,ResultTab!$X$6,\"\")))))","v":""},null,null,null,null,null,null,null,null,null,"Summe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N192:N193)","v":0},null,{"$f":"SUM(P192:Q194)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Versteckte Zelle Summe (wird mitkopiert!!)"]
[]
["Sample 5"]
[]
[null,"Sample 5"]
[]
[null,"LAMP assay",null,null,"Bemisia tabaci"]
[null,null,"Organism",null,null,"Amplification",null,"Annealing [°C]",null,"PAC","NAC","Result",null,null,null,"Wert Resultat"]
[null,null,"Bemisia tabaci",null,null,null,null,null,null,null,null,{"$f":"IF(AND(K209=\"\"),\"\",IF(AND(F209=\"Yes\",H209>ResultTab!$Y$12,H209<ResultTab!$Z$12,K209=\"Negative\",J209=\"Positive\"),\"Positive\",IF(AND(K209=\"Positive\",J209=\"Negative\",OR(H209<ResultTab!$Y$12,H209>ResultTab!$Z$12,H209=0)),\"Invalid\",IF(AND(F209=\"No\",K209=\"Negative\",J209=\"Positive\",H209=0),\"Negative\",\"Invalid\"))))","v":""},null,{"$f":"IF(L209=\"\",\"n/a\",IF(L209=\"Ungültig\",0.05,IF(L209=\"Negativ\",1,4)))","v":"n/a"},null,{"$f":"IF(L209=\"\",\"n/a\",IF(L209=\"Ungültig\",0.05,IF(L209=\"Negativ\",1,4)))","v":"n/a"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N209","v":"n/a"},null,{"$f":"P209","v":"n/a"}]
[]
[]
[null,"Stichprobe 5",null,null,null,"GENIE-Position B1"]
[null,"Probe Nr.:",null,null,{"$f":"Eingabeformular!$K$35","v":0},null,null,"Bemerkung \nzur Probe:"]
[null,"Verdachtsorganismus:",null,null,"Bacterocera Triplex"]
[null,null,"Organismus",null,null,"Amplifikation","Zeit","Annealing [°C]",null,"Pos. Kontr.","Neg. Kontr.","Resultat",null,null,null,"Wert Resultat"]
[null,null,"Bacterocera Triplex",null,null,null,null,null,null,null,null,{"$f":"IF(AND(K218=\"\"),\"\",IF(AND(F218=\"Ja\",H218>ResultTab!$Y$13,H218<ResultTab!$Z$13,K218=\"Negativ\",J218=\"Positiv\"),\"Positiv\",IF(AND(K218=\"Positiv\",J218=\"Negativ\",OR(H218<ResultTab!$Y$13,H218>ResultTab!$Z$13,H218=0)),\"Ungültig\",IF(AND(F218=\"Nein\",K218=\"Negativ\",J218=\"Positiv\",H218=0),\"Negativ\",\"Ungültig\"))))","v":""},null,{"$f":"IF(L218=\"\",\"n/a\",IF(L218=\"Ungültig\",0.05,IF(L218=\"Negativ\",1,4)))","v":"n/a"},null,{"$f":"IF(L218=\"\",\"n/a\",IF(L218=\"Ungültig\",0.05,IF(L218=\"Negativ\",1,4)))","v":"n/a"}]
[null,"Weiteres vorgehen: ",null,null,null,{"$f":"IF(N220=\"n/a\",\"\",IF(N220=4,ResultTab!$X$4,IF(N220=1,ResultTab!$X$5,ResultTab!$X$6)))","v":""},null,null,null,null,null,null,null,null,null,"Summe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N218","v":"n/a"},null,{"$f":"P218","v":"n/a"}]
[]
[]
[null,"Stichprobe 5",null,null,null,"GENIE-Position B1"]
[null,"Probe Nr.:",null,null,{"$f":"Eingabeformular!$K$35","v":0},null,null,"Bemerkung \nzur Probe:"]
[null,"Verdachtsorganismus:",null,null,"Thysanoptera"]
[null,null,"Organismus",null,null,"Amplifikation","Zeit","Annealing [°C]",null,"Pos. Kontr.","Neg. Kontr.","Resultat",null,null,null,"Wert Resultat"]
[null,null,"Thrips palmi",null,null,null,null,null,null,null,null,{"$f":"IF(AND(K227=\"\"),\"\",IF(AND(F227=\"Ja\",H227>ResultTab!$Y$14,H227<ResultTab!$Z$14,K227=\"Negativ\",J227=\"Positiv\"),\"Positiv\",IF(AND(K227=\"Positiv\",J227=\"Negativ\",OR(H227<ResultTab!$Y$14,H227>ResultTab!$Z$14,H227=0)),\"Ungültig\",IF(AND(F227=\"Nein\",K227=\"Negativ\",J227=\"Positiv\",H227=0),\"Negativ\",\"Ungültig\"))))","v":""},null,{"$f":"IF(L227=\"\",\"n/a\",IF(L227=\"Ungültig\",0.05,IF(L227=\"Negativ\",1,4)))","v":"n/a"},null,{"$f":"IF(L227=\"\",\"n/a\",IF(L227=\"Ungültig\",0.05,IF(L227=\"Negativ\",1,4)))","v":"n/a"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(F228=\"\",H228=\"\",J228=\"\"),\"\",IF(AND(F228=\"Ja\",H228>ResultTab!$Y$14,H228<ResultTab!$Z$14,J228=\"Negativ\"),\"Positiv\",IF(AND(F228=\"Nein\",OR(H228<ResultTab!$Y$14,H228=\"\"),J228=\"Negativ\"),\"Negativ\",\"Ungültig\")))","v":""},null,null,null,{"$f":"IF(L228=\"\",\"n/a\",IF(L228=\"Ungültig\",0.05,IF(L228=\"Negativ\",1,4)))","v":"n/a"}]
[null,"Weiteres vorgehen: ",null,null,null,{"$f":"IF(N230=\"n/a\",\"\",IF(N230=4,ResultTab!$X$4,IF(N230=1,ResultTab!$X$5,ResultTab!$X$6)))","v":""},null,null,null,null,null,null,null,null,null,"Summe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N227","v":"n/a"},null,{"$f":"SUM(P227:Q228)","v":0}]
[]
[]
[null,"Stichprobe 5",null,null,null,"GENIE-Position siehe Pos"]
[null,"Probe Nr.:",null,null,{"$f":"Eingabeformular!$K$35","v":0},null,null,"Bemerkung \nzur Probe:"]
[null,"Verdachtsorganismus:",null,null,"Liriomyza"]
[null,"Pos","Organismus",null,null,"Amplifikation","Zeit","Annealing [°C]",null,"Pos. Kontr.","Neg. Kontr.","Resultat",null,null,null,"Wert Resultat"]
[null,null,"L. sativae",null,null,null,null,null,null,null,null,{"$f":"IF(AND(K237=\"\"),\"\",IF(AND(F237=\"Ja\",H237>ResultTab!$Y$15,H237<ResultTab!$Z$15,K237=\"Negativ\",J237=\"Positiv\"),\"Positiv\",IF(AND(K237=\"Positiv\",J237=\"Negativ\",OR(H237<ResultTab!$Y$15,H237>ResultTab!$Z$15,H237=0)),\"Ungültig\",IF(AND(F237=\"Nein\",K237=\"Negativ\",J237=\"Positiv\",H237=0),\"Negativ\",\"Ungültig\"))))","v":""},null,{"$f":"IF(L237=\"\",\"n/a\",IF(L237=\"Ungültig\",0.05,IF(L237=\"Negativ\",1,4)))","v":"n/a"},null,{"$f":"IF(L237=\"\",\"n/a\",IF(L237=\"Ungültig\",0.05,IF(L237=\"Negativ\",1,4)))","v":"n/a"}]
[null,null,"L. trifolii / L. huidobrensis",null,null,null,null,null,null,null,null,{"$f":"IF(AND(K238=\"\"),\"\",IF(AND(F238=\"Ja\",H238>ResultTab!$Y$15,H238<ResultTab!$Z$15,K238=\"Negativ\",J238=\"Positiv\"),\"Positiv\",IF(AND(K238=\"Positiv\",J238=\"Negativ\",OR(H238<ResultTab!$Y$15,H238>ResultTab!$Z$15,H238=0)),\"Ungültig\",IF(AND(F238=\"Nein\",K238=\"Negativ\",J238=\"Positiv\",H238=0),\"Negativ\",\"Ungültig\"))))","v":""},null,{"$f":"IF(L238=\"\",\"n/a\",IF(L238=\"Ungültig\",0.05,IF(L238=\"Negativ\",1,4)))","v":"n/a"},null,{"$f":"IF(L238=\"\",\"n/a\",IF(L238=\"Ungültig\",0.05,IF(L238=\"Negativ\",1,4)))","v":"n/a"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(F239=\"\",H239=\"\",J239=\"\"),\"\",IF(AND(F239=\"Ja\",H239>ResultTab!$Y$15,H239<ResultTab!$Z$15,J239=\"Negativ\"),\"Positiv\",IF(AND(F239=\"Nein\",OR(H239<ResultTab!$Y$15,H239=\"\"),J239=\"Negativ\"),\"Negativ\",\"Ungültig\")))","v":""},null,null,null,{"$f":"IF(L239=\"\",\"n/a\",IF(L239=\"Ungültig\",0.05,IF(L239=\"Negativ\",1,4)))","v":"n/a"}]
[null,"Weiteres vorgehen: ",null,null,null,{"$f":"IF(OR(K237=\"\",K237=\"\",J238=\"\",J238=\"\"),\"\",IF(N241=\"0\",\"\",IF(N241=5,ResultTab!$X$4,IF(N241=2,ResultTab!$X$5,IF(N241>0.01,ResultTab!$X$6,\"\")))))","v":""},null,null,null,null,null,null,null,null,null,"Summe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N237:N238)","v":0},null,{"$f":"SUM(P237:Q239)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Versteckte Zelle Summe (wird mitkopiert!!)"]
[]
["Sample 6"]
[]
[null,"Sample 6"]
[]
[null,"LAMP assay",null,null,"Bemisia tabaci"]
[null,null,"Organism",null,null,"Amplification",null,"Annealing [°C]",null,"PAC","NAC","Result",null,null,null,"Wert Resultat"]
[null,null,"Bemisia tabaci",null,null,null,null,null,null,null,null,{"$f":"IF(AND(K254=\"\"),\"\",IF(AND(F254=\"Yes\",H254>ResultTab!$Y$12,H254<ResultTab!$Z$12,K254=\"Negative\",J254=\"Positive\"),\"Positive\",IF(AND(K254=\"Positive\",J254=\"Negative\",OR(H254<ResultTab!$Y$12,H254>ResultTab!$Z$12,H254=0)),\"Invalid\",IF(AND(F254=\"No\",K254=\"Negative\",J254=\"Positive\",H254=0),\"Negative\",\"Invalid\"))))","v":""},null,{"$f":"IF(L254=\"\",\"n/a\",IF(L254=\"Ungültig\",0.05,IF(L254=\"Negativ\",1,4)))","v":"n/a"},null,{"$f":"IF(L254=\"\",\"n/a\",IF(L254=\"Ungültig\",0.05,IF(L254=\"Negativ\",1,4)))","v":"n/a"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N254","v":"n/a"},null,{"$f":"P254","v":"n/a"}]
[]
[]
[null,"Stichprobe 6",null,null,null,"GENIE-Position B2"]
[null,"Probe Nr.:",null,null,{"$f":"Eingabeformular!$P$35","v":0},null,null,"Bemerkung \nzur Probe:"]
[null,"Verdachtsorganismus:",null,null,"Bacterocera Triplex"]
[null,null,"Organismus",null,null,"Amplifikation","Zeit","Annealing [°C]",null,"Pos. Kontr.","Neg. Kontr.","Resultat",null,null,null,"Wert Resultat"]
[null,null,"Bacterocera Triplex",null,null,null,null,null,null,null,null,{"$f":"IF(AND(K263=\"\"),\"\",IF(AND(F263=\"Ja\",H263>ResultTab!$Y$13,H263<ResultTab!$Z$13,K263=\"Negativ\",J263=\"Positiv\"),\"Positiv\",IF(AND(K263=\"Positiv\",J263=\"Negativ\",OR(H263<ResultTab!$Y$13,H263>ResultTab!$Z$13,H263=0)),\"Ungültig\",IF(AND(F263=\"Nein\",K263=\"Negativ\",J263=\"Positiv\",H263=0),\"Negativ\",\"Ungültig\"))))","v":""},null,{"$f":"IF(L263=\"\",\"n/a\",IF(L263=\"Ungültig\",0.05,IF(L263=\"Negativ\",1,4)))","v":"n/a"},null,{"$f":"IF(L263=\"\",\"n/a\",IF(L263=\"Ungültig\",0.05,IF(L263=\"Negativ\",1,4)))","v":"n/a"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N263","v":"n/a"},null,{"$f":"P263","v":"n/a"}]
[]
[]
[null,"Stichprobe 6",null,null,null,"GENIE-Position B2"]
[null,"Probe Nr.:",null,null,{"$f":"Eingabeformular!$P$35","v":0},null,null,"Bemerkung \nzur Probe:"]
[null,"Verdachtsorganismus:",null,null,"Thysanoptera"]
[null,"Well","Organismus",null,null,"Amplifikation","Zeit","Annealing [°C]",null,"Pos. Kontr.","Neg. Kontr.","Resultat",null,null,null,"Wert Resultat"]
[null,null,"Thrips palmi",null,null,null,null,null,null,null,null,{"$f":"IF(AND(K272=\"\"),\"\",IF(AND(F272=\"Ja\",H272>ResultTab!$Y$14,H272<ResultTab!$Z$14,K272=\"Negativ\",J272=\"Positiv\"),\"Positiv\",IF(AND(K272=\"Positiv\",J272=\"Negativ\",OR(H272<ResultTab!$Y$14,H272>ResultTab!$Z$14,H272=0)),\"Ungültig\",IF(AND(F272=\"Nein\",K272=\"Negativ\",J272=\"Positiv\",H272=0),\"Negativ\",\"Ungültig\"))))","v":""},null,{"$f":"IF(L272=\"\",\"n/a\",IF(L272=\"Ungültig\",0.05,IF(L272=\"Negativ\",1,4)))","v":"n/a"},null,{"$f":"IF(L272=\"\",\"n/a\",IF(L272=\"Ungültig\",0.05,IF(L272=\"Negativ\",1,4)))","v":"n/a"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(F273=\"\",H273=\"\",J273=\"\"),\"\",IF(AND(F273=\"Ja\",H273>ResultTab!$Y$14,H273<ResultTab!$Z$14,J273=\"Negativ\"),\"Positiv\",IF(AND(F273=\"Nein\",OR(H273<ResultTab!$Y$14,H273=\"\"),J273=\"Negativ\"),\"Negativ\",\"Ungültig\")))","v":""},null,null,null,{"$f":"IF(L273=\"\",\"n/a\",IF(L273=\"Ungültig\",0.05,IF(L273=\"Negativ\",1,4)))","v":"n/a"}]
[null,"Weiteres vorgehen: ",null,null,null,{"$f":"IF(N275=\"n/a\",\"\",IF(N275=4,ResultTab!$X$4,IF(N275=1,ResultTab!$X$5,ResultTab!$X$6)))","v":""},null,null,null,null,null,null,null,null,null,"Summe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N272","v":"n/a"},null,{"$f":"SUM(P272:Q273)","v":0}]
[]
[]
[null,"Stichprobe 6",null,null,null,"GENIE-Position siehe Pos"]
[null,"Probe Nr.:",null,null,{"$f":"Eingabeformular!$P$35","v":0},null,null,"Bemerkung \nzur Probe:"]
[null,"Verdachtsorganismus:",null,null,"Liriomyza"]
[null,"Pos","Organismus",null,null,"Amplifikation","Zeit","Annealing [°C]",null,"Pos. Kontr.","Neg. Kontr.","Resultat",null,null,null,"Wert Resultat"]
[null,null,"L. sativae",null,null,null,null,null,null,null,null,{"$f":"IF(AND(K282=\"\"),\"\",IF(AND(F282=\"Ja\",H282>ResultTab!$Y$15,H282<ResultTab!$Z$15,K282=\"Negativ\",J282=\"Positiv\"),\"Positiv\",IF(AND(K282=\"Positiv\",J282=\"Negativ\",OR(H282<ResultTab!$Y$15,H282>ResultTab!$Z$15,H282=0)),\"Ungültig\",IF(AND(F282=\"Nein\",K282=\"Negativ\",J282=\"Positiv\",H282=0),\"Negativ\",\"Ungültig\"))))","v":""},null,{"$f":"IF(L282=\"\",\"n/a\",IF(L282=\"Ungültig\",0.05,IF(L282=\"Negativ\",1,4)))","v":"n/a"},null,{"$f":"IF(L282=\"\",\"n/a\",IF(L282=\"Ungültig\",0.05,IF(L282=\"Negativ\",1,4)))","v":"n/a"}]
[null,null,"L. trifolii / L. huidobrensis",null,null,null,null,null,null,null,null,{"$f":"IF(AND(K283=\"\"),\"\",IF(AND(F283=\"Ja\",H283>ResultTab!$Y$15,H283<ResultTab!$Z$15,K283=\"Negativ\",J283=\"Positiv\"),\"Positiv\",IF(AND(K283=\"Positiv\",J283=\"Negativ\",OR(H283<ResultTab!$Y$15,H283>ResultTab!$Z$15,H283=0)),\"Ungültig\",IF(AND(F283=\"Nein\",K283=\"Negativ\",J283=\"Positiv\",H283=0),\"Negativ\",\"Ungültig\"))))","v":""},null,{"$f":"IF(L283=\"\",\"n/a\",IF(L283=\"Ungültig\",0.05,IF(L283=\"Negativ\",1,4)))","v":"n/a"},null,{"$f":"IF(L283=\"\",\"n/a\",IF(L283=\"Ungültig\",0.05,IF(L283=\"Negativ\",1,4)))","v":"n/a"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(F284=\"\",H284=\"\",J284=\"\"),\"\",IF(AND(F284=\"Ja\",H284>ResultTab!$Y$15,H284<ResultTab!$Z$15,J284=\"Negativ\"),\"Positiv\",IF(AND(F284=\"Nein\",OR(H284<ResultTab!$Y$15,H284=\"\"),J284=\"Negativ\"),\"Negativ\",\"Ungültig\")))","v":""},null,null,null,{"$f":"IF(L284=\"\",\"n/a\",IF(L284=\"Ungültig\",0.05,IF(L284=\"Negativ\",1,4)))","v":"n/a"}]
[null,"Weiteres vorgehen: ",null,null,null,{"$f":"IF(OR(K282=\"\",K282=\"\",J283=\"\",J283=\"\"),\"\",IF(N286=\"0\",\"\",IF(N286=5,ResultTab!$X$4,IF(N286=2,ResultTab!$X$5,IF(N286>0.01,ResultTab!$X$6,\"\")))))","v":""},null,null,null,null,null,null,null,null,null,"Summe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N282:N283)","v":0},null,{"$f":"SUM(P282:Q284)","v":0}]