{"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":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":"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,"Kommun"]

{"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],[29,1,29,10],[27,13,27,22],[29,13,29,22],[4,1,4,5],[27,1,27,12]]}
[{"$f":"Instruktioner!A1","v":"Version 1.1"},null,"Instruktioner","Kalkylator","Diagram","Socialstyrelsens referensvärden"]
[]
[1,"Nyckeltal kommun 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 och omsorg exklusive covid-19"]
[null,"Nyckeltal kommun","Särskilt boende","LSS","Hemtjänst","Hemsjukvård",null,null,null,null,null,null,null,{"$f":"B6","v":"Nyckeltal kommun"},{"$f":"C6","v":"Särskilt boende"},{"$f":"D6","v":"LSS"},{"$f":"E6","v":"Hemtjänst"},{"$f":"F6","v":"Hemsjukvård"}]
["1.1","Antal brukare",null,null,null,null,null,null,null,null,null,null,"1.19",{"$f":"B7","v":"Antal brukare"}]
["1.2","Besök/brukare/dygn",null,null,null,null,null,null,null,null,null,null,"1.20",{"$f":"B8","v":"Besök/brukare/dygn"}]
["1.3","Personalresurs/besök",null,null,null,null,null,null,null,null,null,null,"1.21",{"$f":"B9","v":"Personalresurs/besök"}]
[null,null,{"$f":"C6","v":"Särskilt boende"},{"$f":"D6","v":"LSS"},{"$f":"E6","v":"Hemtjänst"},{"$f":"F6","v":"Hemsjukvård"},null,null,null,null,null,null,null,null,{"$f":"C6","v":"Särskilt boende"},{"$f":"D6","v":"LSS"},{"$f":"E6","v":"Hemtjänst"},{"$f":"F6","v":"Hemsjukvård"}]
[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 och omsorg exklusive covid-19"}]
[null,null,{"$f":"C6","v":"Särskilt boende"},{"$f":"D6","v":"LSS"},{"$f":"E6","v":"Hemtjänst"},{"$f":"F6","v":"Hemsjukvård"},null,{"$f":"C6","v":"Särskilt boende"},{"$f":"D6","v":"LSS"},{"$f":"E6","v":"Hemtjänst"},{"$f":"F6","v":"Hemsjukvård"},null,null,null,{"$f":"C6","v":"Särskilt boende"},{"$f":"D6","v":"LSS"},{"$f":"E6","v":"Hemtjänst"},{"$f":"F6","v":"Hemsjukvård"},null,{"$f":"C6","v":"Särskilt boende"},{"$f":"D6","v":"LSS"},{"$f":"E6","v":"Hemtjänst"},{"$f":"F6","v":"Hemsjukvård"}]
[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,0,0,{"$f":"IFERROR((($E$7*($E$8*$E$9)*E13)*$H$48),0)","v":0},0,null,"2.17",{"$f":"B13","v":"Andningsskydd FFP3"},0,0,{"$f":"IFERROR((($Q$7*($Q$8*$Q$9)*Q13)*$C$48),0)","v":0},0,null,0,0,{"$f":"IFERROR((($Q$7*($Q$8*$Q$9)*Q13)*$H$48),0)","v":0},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 och omsorg\nexklusive covid-19"]
[null,null,"Särskilt boende, LSS, hemtjänst, hemsjukvård"]
[null,"Beräknat behov personlig skyddsutrustning","Beräknad behov 30 dagar","Beräknad 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":76,"n_cols":6,"rows_kept":76,"cut":false,"hidden":false,"merged":[[63,1,63,3],[64,2,64,3],[26,1,26,3],[46,1,46,5],[44,1,44,8]]}
[{"$f":"Instruktioner!A1","v":"Version 1.1"},null,"Instruktioner","Kalkylator","Diagram","Socialstyrelsens referensvärden"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1,"Socialstyrelsens referensvärden kommun och personlig skyddsutrustning"]
[]
[null,"Bekräftad och misstänkt covid-19"]
[null,"Socialstyrelsens referensvärden kommun","Särskilt boende","Hemtjänst"]
["1.1","Antal brukare",10,10]
["1.2","Besök/brukare/dygn",6,4]
["1.3","Personalresurs/besök",2,1.5]
[null,null,{"$f":"C28","v":"Särskilt boende"},{"$f":"D28","v":"Hemtjänst"}]
[null,"Socialstyrelsens referensvärden personlig skyddsutrustning","Behov per besök","Behov per besök"]
["1.4","Andningsskydd FFP2/ FFP3",0.1,0.1]
["1.5","Andningsskydd FFP3"]
["1.6","Munskydd typ IIR",1,1]
["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",6,6]
["1.11","Engångsförkläde",1.5,1.5]
["1.12","Handdesinfektion liter",0.05,0.05]
["1.13","Ytdesinfektion liter",0.03,0.03]
[]
[2,"Beräkning förbrukning personlig skyddsutrustning"]
[]
[null,{"$f":"B27","v":"Bekräftad och misstänkt covid-19"}]
[null,null,{"$f":"C32","v":"Särskilt boende"},{"$f":"D32","v":"Hemtjänst"},{"$f":"C28","v":"Särskilt boende"},{"$f":"D28","v":"Hemtjänst"}]
[null,"Beräkning personlig skyddsutrustning","30 dagar förbrukning","30 dagar förbrukning","90 dagar förbrukning","90 dagar förbrukning"]
["2.1",{"$f":"B34","v":"Andningsskydd FFP2/ FFP3"},{"$f":"IFERROR((($C$29*($C$30*$C$31)*C34)*$C$60),0)","v":360},{"$f":"IFERROR((($D$29*($D$30*$D$31)*D34)*$C$60),0)","v":180},{"$f":"IFERROR((($C$29*($C$30*$C$31)*C34)*$F$60),0)","v":1080},{"$f":"IFERROR((($D$29*($D$30*$D$31)*D34)*$F$60),0)","v":540}]
["2.2",{"$f":"B35","v":"Andningsskydd FFP3"},0,0,0,{"$f":"IFERROR(((#REF!*(#REF!*#REF!)*#REF!)*$F$60),0)","v":0}]
["2.3","Munskydd typ IIR",3600,1800,10800,{"$f":"IFERROR((($D$29*($D$30*$D$31)*D36)*$F$60),0)","v":5400}]
["2.4","Visir engångs",1800,900,5400,2700]
["2.5","Visir flergångs",1080,540,3240,1620]
["2.6","Skyddsglasögon",360,180,1080,540]
["2.7","Skyddshandskar stycken",21600,10800,64800,32400]
["2.8","Engångsförkläde",5400,2700,16200,8100]
["2.9","Handdesinfektion liter",180,90,540,270]
["2.10","Ytdesinfektion liter",107.99999999999999,53.999999999999993,323.99999999999994,161.99999999999997]
["2.10",null,30,null,null,90]
[]
[3,"Beräknat behov personlig skyddsutrustning"]
[]
[null,{"$f":"B27","v":"Bekräftad och misstänkt covid-19"}]
[null,null,"Särskilt boende, hemtjänst"]
[null,"Beräknat behov personlig skyddsutrustning","Beräknad behov 30 dagar","Beräknad behov 90 dagar"]
["3.1",{"$f":"B34","v":"Andningsskydd FFP2/ FFP3"},{"$f":"C50+D50","v":540},{"$f":"E50+F50","v":1620}]
["3.2",{"$f":"B35","v":"Andningsskydd FFP3"},{"$f":"C51+D51","v":0},{"$f":"E51+F51","v":0}]
["3.3","Munskydd typ IIR",{"$f":"C52+D52","v":5400},{"$f":"E52+F52","v":16200}]
["3.4","Visir engångs",2700,8100]
["3.5","Visir flergångs",1620,4860]
["3.6","Skyddsglasögon",540,1620]
["3.7","Skyddshandskar stycken",32400,97200]
["3.8","Engångsförkläde",{"$f":"C57+D57","v":8100},{"$f":"E57+F57","v":24300}]
["3.9","Handdesinfektion liter",270,810]
["3.10","Ytdesinfektion liter",161.99999999999997,485.99999999999989]