{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Information","CPR","Skabeloner","Prøvetyper","Batch typer"],"read":"whole","date_system":"1900"}

{"sheet":"Information","index":0,"n_rows":15,"n_cols":3,"rows_kept":15}
["Batch Information"]
["Version","v2.0.0",{"$f":"B2","v":"v2.0.0"}]
["Dato",{"$f":"TODAY()","v":"2020-07-15"},{"$f":"B3","v":"2020-07-15"}]
["Batch type","Standard",{"$f":"B4","v":"Standard"}]
["Batch ID",{"$f":"VLOOKUP($B$4,'Batch typer'!$A$2:$I$2500,2,FALSE)","v":"-"},{"$f":"IF(ISBLANK(B5),\"-\",B5)","v":"-"}]
["Prøvetype",{"$f":"VLOOKUP($B$4,'Batch typer'!$A$2:$I$2500,3,FALSE)","v":"-"},{"$f":"IFERROR(VLOOKUP(B6,Prøvetyper!A2:B15,2,FALSE),\"-\")","v":"-"}]
["Send breve til gr1",{"$f":"VLOOKUP($B$4,'Batch typer'!$A$2:$I$2500,4,FALSE)","v":"-"},{"$f":"IFERROR(IF(B7=\"Ja\",TRUE,IF(B7=\"Nej\",FALSE,\"-\")),\"-\")","v":"-"}]
["Send breve til gr2+",{"$f":"VLOOKUP($B$4,'Batch typer'!$A$2:$I$2500,5,FALSE)","v":"-"},{"$f":"IFERROR(IF(B8=\"Ja\",TRUE,IF(B8=\"Nej\",FALSE,\"-\")),\"-\")","v":"-"}]
["Spørgeskema",{"$f":"VLOOKUP($B$4,'Batch typer'!$A$2:$I$2500,6,FALSE)","v":"-"},{"$f":"IFERROR(IF(B9=\"Ja\",TRUE,IF(B9=\"Nej\",FALSE,\"-\")),\"-\")","v":"-"}]
["Brevskabelon til gr1",{"$f":"VLOOKUP($B$4,'Batch typer'!$A$2:$I$2500,7,FALSE)","v":"-"},{"$f":"IFERROR(VLOOKUP(B10,Skabeloner!A2:C10,2,FALSE),\"-\")","v":"-"}]
["Brevskabelon til gr2+",null,{"$f":"IFERROR(VLOOKUP(B10,Skabeloner!A2:C10,3,FALSE),\"-\")","v":"-"}]
["Rekvisition til gr1",{"$f":"VLOOKUP($B$4,'Batch typer'!$A$2:$I$2500,8,FALSE)","v":"-"},{"$f":"IFERROR(IF(B12=\"Ja\",TRUE,IF(B12=\"Nej\",FALSE,\"-\")),\"-\")","v":"-"}]
["Rekvisition til gr2+",{"$f":"VLOOKUP($B$4,'Batch typer'!$A$2:$I$2500,9,FALSE)","v":"-"},{"$f":"IFERROR(IF(B13=\"Ja\",TRUE,IF(B13=\"Nej\",FALSE,\"-\")),\"-\")","v":"-"}]
[]
["* Udfyld alle de grønne felter før afsendelse"]

{"sheet":"CPR","index":1,"n_rows":1,"n_cols":4,"rows_kept":1}
["CPR","Link","Brugernavn","Password"]

{"sheet":"Skabeloner","index":2,"n_rows":5,"n_cols":3,"rows_kept":5}
["Test","Skabelon","Gruppe 2+ Skabelon"]
["Intet brev","-","-"]
["Virustest - Medarbejdere","virus_medarb_gr1_270520.docx","virus_medarb_gr2_270520.docx"]
["Virustest - EPI prævalens","virus_tilfborg_voksne_gruppe1_20200515.docx","virus_tilfborg_voksne_gruppe1_20200515.docx"]
["Antistoftest - EPI prævalens","antistof_tilfborg_voksne_gruppe1_20200515.docx","antistof_tilfborg_voksne_gruppe1_20200515.docx"]

{"sheet":"Prøvetyper","index":3,"n_rows":6,"n_cols":2,"rows_kept":6}
["Prøve","Kode"]
["[X2074] SARS-CoV-2 (RNA) - Batchvisiteret ","X2074"]
["[X2079] SARS-CoV-2 (RNA) - Alle voksne","X2079"]
["[X2080] SARS-CoV-2 (RNA) - EPI prævalens PCR","X2080"]
["[R2075] SARS-CoV-2-Ab - EPI prævalens AB","R2075"]
["[R2081] SARS-CoV-2-Ab - Testcenter","R2081"]

{"sheet":"Batch typer","index":4,"n_rows":12,"n_cols":9,"rows_kept":12}
["Type","Batch ID","Prøvetype","Send breve til gr1","Send breve til gr2+","Spørgeskema","Brevskabelon","Rekvistion til gr1","Rekvisition til gr2+"]
["Standard","-","-","-","-","-","-","-","-"]
["Erhvervsrejsende","CALLCENTER_POL-ERHVERV-PCR","[X2074] SARS-CoV-2 (RNA) - Batchvisiteret ","Nej","Nej","Nej","Intet brev","Ja","Ja"]
["SUM CPR 01 ov12 (PCR)","SUM-CPR01_ov12-PCR","[X2079] SARS-CoV-2 (RNA) - Alle voksne","Nej","Nej","Nej","Intet brev","Ja","Ja"]
["SUM CPR 03 ov12 (PCR)","SUM-CPR03_ov12-PCR","[X2079] SARS-CoV-2 (RNA) - Alle voksne","Nej","Nej","Nej","Intet brev","Ja","Ja"]
["SUM CPR 20 VANDRENDE (PCR)","SUM-CPR20_VANDRENDE_20200708-PCR","[X2079] SARS-CoV-2 (RNA) - Alle voksne","Nej","Nej","Nej","Intet brev","Ja","Ja"]
["EPI prævalens (PCR)","EPI_PRÆVALENS_PCR","[X2074] SARS-CoV-2 (RNA) - Batchvisiteret ","Ja","Ja","Nej","Virustest - EPI prævalens","Ja","Ja"]
["EPI prævalens (AB)","EPI_PRÆVALENS_ANTISTOF","[R2075] SARS-CoV-2-Ab - EPI prævalens AB","Ja","Ja","Nej","Antistoftest - EPI prævalens","Ja","Ja"]
["Kommuner (PCR)","<Udfyld Batch ID>","[X2074] SARS-CoV-2 (RNA) - Batchvisiteret ","Ja","Ja","Nej","Virustest - Medarbejdere","Ja","Ja"]
["Alle voksne","ALLE_VOKSNE","[X2079] SARS-CoV-2 (RNA) - Alle voksne","Nej","Nej","Nej","Intet brev","Ja","Ja"]
["Inkonklusive (PCR)","SSI-INKONKLUSIVE-PCR","[X2074] SARS-CoV-2 (RNA) - Batchvisiteret ","Nej","Nej","Nej","Intet brev","Ja","Ja"]
["Inkonklusive (AB)","SSI-INKONKLUSIVE-ANTISTOF","[R2075] SARS-CoV-2-Ab - EPI prævalens AB","Nej","Nej","Nej","Intet brev","Ja","Ja"]