{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instruktioner","Kalkylator","Diagram","Socialstyrelsens referensvärden"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"Instruktioner","index":0,"n_rows":1,"n_cols":11,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Version 1.1",null,"Instruktioner","Kalkylator","Diagram","Socialstyrelsens referensvärden",null,null,null,null,"Region"]

{"sheet":"Kalkylator","index":1,"n_rows":69,"n_cols":23,"rows_kept":69,"cut":false,"hidden":false,"merged":[[52,2,52,3],[51,1,51,3],[4,13,4,17],[25,24,25,25],[27,1,27,10],[29,1,29,10],[27,13,27,22],[29,13,29,22],[4,1,4,5]]}
[{"$f":"Instruktioner!A1","v":"Version 1.1"},null,"Instruktioner","Kalkylator","Diagram","Socialstyrelsens referensvärden"]
[]
[1,"Nyckeltal region och personlig skyddsutrustning"]
[]
[null,"Bekräftad och misstänkt covid-19",null,null,null,null,null,null,null,null,null,null,null,"Övrig vård exklusive covid-19"]
[null,"Nyckeltal region","Slutenvård exkl. IVA","IVA","Primärvård","Akut-mottagning",null,null,null,null,null,null,null,{"$f":"B6","v":"Nyckeltal region"},{"$f":"C6","v":"Slutenvård exkl. IVA"},"IVA","Primärvård",{"$f":"F6","v":"Akut-mottagning"}]
["1.1","Antal patienter",null,null,null,null,null,null,null,null,null,null,"1.19","Antal patienter"]
["1.2","Besök/patienter/dygn",null,null,null,null,null,null,null,null,null,null,"1.20","Besök/patienter/dygn"]
["1.3","Personalresurs/besök",null,null,null,null,null,null,null,null,null,null,"1.21","Personalresurs/besök"]
[null,null,{"$f":"C6","v":"Slutenvård exkl. IVA"},{"$f":"D6","v":"IVA"},"Primärvård","Akut-mottagning",null,null,null,null,null,null,null,null,{"$f":"O6","v":"Slutenvård exkl. IVA"},{"$f":"P6","v":"IVA"},{"$f":"Q6","v":"Primärvård"},{"$f":"R6","v":"Akut-mottagning"}]
[null,"Nyckeltal personlig skyddsutrustning","Behov per besök","Behov per besök","Behov per besök","Behov per besök",null,null,null,null,null,null,null,{"$f":"B11","v":"Nyckeltal personlig skyddsutrustning"},"Behov per besök","Behov per besök","Behov per besök","Behov per besök"]
["1.4","Andningsskydd FFP2",null,null,null,null,null,null,null,null,null,null,"1.22",{"$f":"B12","v":"Andningsskydd FFP2"}]
["1.5","Andningsskydd FFP3",null,null,null,null,null,null,null,null,null,null,"1.23",{"$f":"B13","v":"Andningsskydd FFP3"}]
["1.6","Munskydd typ IIR",null,null,null,null,null,null,null,null,null,null,"1.24","Munskydd typ IIR"]
["1.7","Visir engångs",null,null,null,null,null,null,null,null,null,null,"1.25","Visir engångs"]
["1.8","Visir flergångs",null,null,null,null,null,null,null,null,null,null,"1.26","Visir flergångs"]
["1.9","Skyddsglasögon",null,null,null,null,null,null,null,null,null,null,"1.27","Skyddsglasögon"]
["1.10","Skyddshandskar stycken",null,null,null,null,null,null,null,null,null,null,"1.28","Skyddshandskar stycken"]
["1.11","Engångsförkläde",null,null,null,null,null,null,null,null,null,null,"1.29","Engångsförkläde"]
["1.12","Handdesinfektion liter",null,null,null,null,null,null,null,null,null,null,"1.30","Handdesinfektion liter"]
["1.13","Ytdesinfektion liter",null,null,null,null,null,null,null,null,null,null,"1.31","Ytdesinfektion liter"]
["1.14","Annan personlig skyddsutr. 1",null,null,null,null,null,null,null,null,null,null,"1.32","Annan personlig skyddsutr. 1"]
["1.15","Annan personlig skyddsutr. 2",null,null,null,null,null,null,null,null,null,null,"1.33","Annan personlig skyddsutr. 2"]
["1.16","Annan personlig skyddsutr. 3",null,null,null,null,null,null,null,null,null,null,"1.34","Annan personlig skyddsutr. 3"]
["1.17","Annan personlig skyddsutr. 4",null,null,null,null,null,null,null,null,null,null,"1.35","Annan personlig skyddsutr. 4"]
["1.18","Annan personlig skyddsutr. 5",null,null,null,null,null,null,null,null,null,null,"1.36","Annan personlig skyddsutr. 5"]
[]
[2,"Beräkning förbrukning personlig skyddsutrustning"]
[]
[null,{"$f":"B5","v":"Bekräftad och misstänkt covid-19"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"N5","v":"Övrig vård exklusive covid-19"}]
[null,null,{"$f":"C10","v":"Slutenvård exkl. IVA"},{"$f":"D10","v":"IVA"},{"$f":"E10","v":"Primärvård"},{"$f":"F10","v":"Akut-mottagning"},null,{"$f":"C10","v":"Slutenvård exkl. IVA"},{"$f":"D10","v":"IVA"},{"$f":"E10","v":"Primärvård"},{"$f":"F10","v":"Akut-mottagning"},null,null,null,{"$f":"O10","v":"Slutenvård exkl. IVA"},{"$f":"P10","v":"IVA"},{"$f":"Q10","v":"Primärvård"},{"$f":"R10","v":"Akut-mottagning"},null,{"$f":"O10","v":"Slutenvård exkl. IVA"},{"$f":"P10","v":"IVA"},{"$f":"Q10","v":"Primärvård"},{"$f":"R10","v":"Akut-mottagning"}]
[null,"Beräkning personlig skyddsutrustning","30 dagar förbrukning","30 dagar förbrukning","30 dagar förbrukning","30 dagar förbrukning",null,"90 dagar förbrukning","90 dagar förbrukning","90 dagar förbrukning","90 dagar förbrukning",null,null,{"$f":"B32","v":"Beräkning personlig skyddsutrustning"},"30 dagar förbrukning","30 dagar förbrukning","30 dagar förbrukning","30 dagar förbrukning",null,"90 dagar förbrukning","90 dagar förbrukning","90 dagar förbrukning","90 dagar förbrukning"]
["2.1",{"$f":"B12","v":"Andningsskydd FFP2"},{"$f":"IFERROR((($C$7*($C$8*$C$9)*C12)*$C$48),0)","v":0},{"$f":"IFERROR((($D$7*($D$8*$D$9)*D12)*$C$48),0)","v":0},{"$f":"IFERROR((($E$7*($E$8*$E$9)*E12)*$C$48),0)","v":0},{"$f":"IFERROR((($F$7*($F$8*$F$9)*F12)*$C$48),0)","v":0},null,{"$f":"IFERROR((($C$7*($C$8*$C$9)*C12)*$H$48),0)","v":0},{"$f":"IFERROR((($D$7*($D$8*$D$9)*D12)*$H$48),0)","v":0},{"$f":"IFERROR((($E$7*($E$8*$E$9)*E12)*$H$48),0)","v":0},{"$f":"IFERROR((($F$7*($F$8*$F$9)*F12)*$H$48),0)","v":0},null,"2.16",{"$f":"B12","v":"Andningsskydd FFP2"},{"$f":"IFERROR((($O$7*($O$8*$O$9)*O12)*$C$48),0)","v":0},{"$f":"IFERROR((($P$7*($P$8*$P$9)*P12)*$C$48),0)","v":0},{"$f":"IFERROR((($Q$7*($Q$8*$Q$9)*Q12)*$C$48),0)","v":0},{"$f":"IFERROR((($R$7*($R$8*$R$9)*R12)*$C$48),0)","v":0},null,{"$f":"IFERROR((($O$7*($O$8*$O$9)*O12)*$H$48),0)","v":0},{"$f":"IFERROR((($P$7*($P$8*$P$9)*P12)*$H$48),0)","v":0},{"$f":"IFERROR((($Q$7*($Q$8*$Q$9)*Q12)*$H$48),0)","v":0},{"$f":"IFERROR((($R$7*($R$8*$R$9)*R12)*$H$48),0)","v":0}]
["2.2",{"$f":"B13","v":"Andningsskydd FFP3"},{"$f":"IFERROR((($C$7*($C$8*$C$9)*C13)*$C$48),0)","v":0},{"$f":"IFERROR((($D$7*($D$8*$D$9)*D13)*$C$48),0)","v":0},{"$f":"IFERROR((($E$7*($E$8*$E$9)*E13)*$C$48),0)","v":0},{"$f":"IFERROR((($F$7*($F$8*$F$9)*F13)*$C$48),0)","v":0},null,{"$f":"IFERROR((($C$7*($C$8*$C$9)*C13)*$H$48),0)","v":0},{"$f":"IFERROR((($D$7*($D$8*$D$9)*D13)*$H$48),0)","v":0},{"$f":"IFERROR((($E$7*($E$8*$E$9)*E13)*$H$48),0)","v":0},{"$f":"IFERROR((($F$7*($F$8*$F$9)*F13)*$H$48),0)","v":0},null,"2.17",{"$f":"B13","v":"Andningsskydd FFP3"},{"$f":"IFERROR((($O$7*($O$8*$O$9)*O13)*$C$48),0)","v":0},{"$f":"IFERROR((($P$7*($P$8*$P$9)*P13)*$C$48),0)","v":0},{"$f":"IFERROR((($Q$7*($Q$8*$Q$9)*Q13)*$C$48),0)","v":0},{"$f":"IFERROR((($R$7*($R$8*$R$9)*R13)*$C$48),0)","v":0},null,{"$f":"IFERROR((($O$7*($O$8*$O$9)*O13)*$H$48),0)","v":0},{"$f":"IFERROR((($P$7*($P$8*$P$9)*P13)*$H$48),0)","v":0},{"$f":"IFERROR((($Q$7*($Q$8*$Q$9)*Q13)*$H$48),0)","v":0},{"$f":"IFERROR((($R$7*($R$8*$R$9)*R13)*$H$48),0)","v":0}]
["2.3","Munskydd typ IIR",0,0,0,0,null,0,0,0,0,null,"2.18","Munskydd typ IIR",0,0,0,0,null,0,0,0,0]
["2.4","Visir engångs",0,0,0,0,null,0,0,0,0,null,"2.19","Visir engångs",0,0,0,0,null,0,0,0,0]
["2.5","Visir flergångs",0,0,0,0,null,0,0,0,0,null,"2.20","Visir flergångs",0,0,0,0,null,0,0,0,0]
["2.6","Skyddsglasögon",0,0,0,0,null,0,0,0,0,null,"2.21","Skyddsglasögon",0,0,0,0,null,0,0,0,0]
["2.7","Skyddshandskar stycken",0,0,0,0,null,0,0,0,0,null,"2.22","Skyddshandskar stycken",0,0,0,0,null,0,0,0,0]
["2.8","Engångsförkläde",0,0,0,0,null,0,0,0,0,null,"2.23","Engångsförkläde",0,0,0,0,null,0,0,0,0]
["2.9","Handdesinfektion liter",0,0,0,0,null,0,0,0,0,null,"2.24","Handdesinfektion liter",0,0,0,0,null,0,0,0,0]
["2.10","Ytdesinfektion liter",0,0,0,0,null,0,0,0,0,null,"2.25","Ytdesinfektion liter",0,0,0,0,null,0,0,0,0]
["2.11","Annan personlig skyddsutr. 1",0,0,0,0,null,0,0,0,0,null,"2.26","Annan personlig skyddsutr. 1",0,0,0,0,null,0,0,0,0]
["2.12","Annan personlig skyddsutr. 2",0,0,0,0,null,0,0,0,0,null,"2.27","Annan personlig skyddsutr. 2",0,0,0,0,null,0,0,0,0]
["2.13","Annan personlig skyddsutr. 3",0,0,0,0,null,0,0,0,0,null,"2.28","Annan personlig skyddsutr. 3",0,0,0,0,null,0,0,0,0]
["2.14","Annan personlig skyddsutr. 4",0,0,0,0,null,0,0,0,0,null,"2.29","Annan personlig skyddsutr. 4",0,0,0,0,null,0,0,0,0]
["2.15","Annan personlig skyddsutr. 5",0,0,0,0,null,0,0,0,0,null,"2.30","Annan personlig skyddsutr. 5",0,0,0,0,null,0,0,0,0]
[null,null,30,null,null,null,null,90]
[]
[3,"Beräknat behov personlig skyddsutrustning"]
[]
[null,"Covid-19 och övrig vård exkl. covid-19"]
[null,null,"Slutenvård exkl. IVA, IVA, primärvård, akutmottagning"]
[null,"Beräknat behov personlig skyddsutrustning","Beräknat behov 30 dagar","Beräknat behov 90 dagar"]
["3.1",{"$f":"B12","v":"Andningsskydd FFP2"},{"$f":"C33+D33+E33+F33+O33+P33+Q33+R33","v":0},{"$f":"H33+I33+J33+K33+T33+U33+V33+W33","v":0}]
["3.2",{"$f":"B13","v":"Andningsskydd FFP3"},{"$f":"C34+D34+E34+F34+O34+P34+Q34+R34","v":0},{"$f":"H34+I34+J34+K34+T34+U34+V34+W34","v":0}]
["3.3","Munskydd typ IIR",0,0]
["3.4","Visir engångs",0,0]
["3.5","Visir flergångs",0,0]
["3.6","Skyddsglasögon",0,0]
["3.7","Skyddshandskar stycken",0,0]
["3.8","Engångsförkläde",0,0]
["3.9","Handdesinfektion liter",0,0]
["3.10","Ytdesinfektion liter",0,0]
["3.11","Annan personlig skyddsutr. 1",0,0]
["3.12","Annan personlig skyddsutr. 2",0,0]
["3.13","Annan personlig skyddsutr. 3",0,0]
["3.14","Annan personlig skyddsutr. 4",0,0]
["3.15","Annan personlig skyddsutr. 5",0,0]

{"sheet":"Diagram","index":2,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Instruktioner!A1","v":"Version 1.1"},null,"Instruktioner","Kalkylator","Diagram","Socialstyrelsens referensvärden"]

{"sheet":"Socialstyrelsens referensvärden","index":3,"n_rows":90,"n_cols":6,"rows_kept":90,"cut":false,"hidden":false,"merged":[[74,1,74,3],[75,2,75,3],[54,1,54,5],[50,8,50,9],[31,1,31,3]]}
[{"$f":"Instruktioner!A1","v":"Version 1.1"},null,"Instruktioner","Kalkylator","Diagram","Socialstyrelsens referensvärden"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1,"Socialstyrelsens referensvärden region och personlig skyddsutrustning"]
[]
[null,"Bekräftad och misstänkt covid-19"]
[null,"Socialstyrelsens referensvärden region","Slutenvård exkl. IVA","IVA"]
["1.1","Antal patienter",10,2]
["1.2","Besök/patienter/dygn",7,14]
["1.3","Personalresurs/besök",2,1.5]
[null,null,{"$f":"C33","v":"Slutenvård exkl. IVA"},{"$f":"D33","v":"IVA"}]
[null,"Socialstyrelsens referensvärden personlig skyddsutrustning","Behov per besök","Behov per besök"]
["1.4","Andningsskydd FFP2",0,0]
["1.5","Andningsskydd FFP3",0.5,0.5]
["1.6","Munskydd typ IIR",0.5,0.5]
["1.7","Visir engångs",0.5,0.5]
["1.8","Visir flergångs",0.3,0.3]
["1.9","Skyddsglasögon",0.1,0.1]
["1.10","Skyddshandskar stycken",5,5]
["1.11","Engångsförkläde",1,1]
["1.12","Handdesinfektion liter",0.05,0.05]
["1.13","Ytdesinfektion liter",0.03,0.03]
["1.16","Annan skyddsutrustning 1"]
["1.17","Annan skyddsutrustning 2"]
["1.18","Annan skyddsutrustning 3"]
[]
[2,"Beräkning förbrukning personlig skyddsutrustning"]
[]
[null,{"$f":"B32","v":"Bekräftad och misstänkt covid-19"}]
[null,null,{"$f":"C37","v":"Slutenvård exkl. IVA"},{"$f":"D37","v":"IVA"},{"$f":"C37","v":"Slutenvård exkl. IVA"},{"$f":"D37","v":"IVA"}]
[null,"Beräkning personlig skyddsutrustning","30 dagar förbrukning","30 dagar förbrukning","90 dagar förbrukning","90 dagar förbrukning"]
["2.1",{"$f":"B39","v":"Andningsskydd FFP2"},{"$f":"IFERROR((($C$34*($C$35*$C$36)*C39)*$C$71),0)","v":0},{"$f":"IFERROR((($D$34*($D$35*$D$36)*D39)*$C$71),0)","v":0},{"$f":"IFERROR((($C$34*($C$35*$C$36)*C39)*$E$71),0)","v":0},{"$f":"IFERROR((($D$34*($D$35*$D$36)*D39)*$E$71),0)","v":0}]
["2.2",{"$f":"B40","v":"Andningsskydd FFP3"},2100,630,6300,1890]
["2.3","Munskydd typ IIR",2100,630,6300,1890]
["2.4","Visir engångs",2100,630,6300,1890]
["2.5","Visir flergångs",1260,378,3780,1134]
["2.6","Skyddsglasögon",420,126,1260,378]
["2.7","Skyddshandskar stycken",21000,6300,63000,18900]
["2.8","Engångsförkläde",4200,1260,12600,3780]
["2.9","Handdesinfektion liter",210,63,630,189]
["2.10","Ytdesinfektion liter",126,37.799999999999997,378,113.4]
["2.13",{"$f":"B49","v":"Annan skyddsutrustning 1"},0,0,0,0]
["2.14",{"$f":"B50","v":"Annan skyddsutrustning 2"},0,0,0,0]
["2.15",{"$f":"B51","v":"Annan skyddsutrustning 3"},0,0,0,0]
[null,null,30,null,90]
[]
[3,"Beräknat behov personlig skyddsutrustning"]
[]
[null,{"$f":"B32","v":"Bekräftad och misstänkt covid-19"}]
[null,null,"Slutenvård exkl. IVA, IVA"]
[null,"Beräknat behov personlig skyddsutrustning","Beräknat behov 30 dagar","Beräknat behov 90 dagar"]
["3.1",{"$f":"B39","v":"Andningsskydd FFP2"},{"$f":"C58+D58","v":0},{"$f":"E58+F58","v":0}]
["3.2",{"$f":"B40","v":"Andningsskydd FFP3"},2730,8190]
["3.3","Munskydd typ IIR",2730,8190]
["3.4","Visir engångs",2730,8190]
["3.5","Visir flergångs",1638,4914]
["3.6","Skyddsglasögon",546,1638]
["3.7","Skyddshandskar stycken",27300,81900]
["3.8","Engångsförkläde",{"$f":"C65+D65","v":5460},{"$f":"E65+F65","v":16380}]
["3.9","Handdesinfektion liter",273,819]
["3.10","Ytdesinfektion liter",163.80000000000001,491.4]
["3.13",{"$f":"B49","v":"Annan skyddsutrustning 1"},{"$f":"C68+D68+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"E68+F68+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}}]
["3.14",{"$f":"B50","v":"Annan skyddsutrustning 2"},{"$f":"C69+D69+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"E69+F69+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}}]
["3.15",{"$f":"B51","v":"Annan skyddsutrustning 3"},{"$f":"C70+D70+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"E70+F70+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}}]