{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Kalkylator","Beskrivning"],"not_rendered":{"charts":0,"images":4,"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":"Kalkylator","index":0,"n_rows":101,"n_cols":25,"rows_kept":101,"cut":false,"hidden":false,"merged":[[0,2,0,7],[0,12,0,21],[4,22,4,23],[5,22,5,24],[21,23,21,26],[2,2,2,3],[2,4,2,9],[1,14,2,18],[1,2,1,4],[1,6,1,9]]}
[null,null,"Kalkylator för beräkning i MDD",null,null,null,null,null,null,null,null,null,"Bokstäverna/siffrorna i de gråa fälten anger från vilken rad i Bilaga B som uppgifterna skall hämtas.\nMakron och redigering måste vara aktiva för att kalkylatorn ska fungera. "]
[null,null,"Beräkning av kompressionskraften ",null,null,null,"Beräkning av dos/återkommande  belastningsdag ",null,null,null,null,null,null,null,"Beräkning av livsdos"]
[null,null,"B Belastningsdag:"]
[null,1,"D\nBördans vikt [kg]","1-8\nTyp av hantering","Kompr.kraft\n[N]",null,"Kompr.kraft [N]","F/H/K\nTid/han-tering [s] ","I/L\nAntal/dag","Tid/dag [h]",null,null,"Dagsdos [Nh]",null,"Dagsdos [Nh]","Belastningsdag","C\nAntal dagar/år","A\nAntal år","Dos för perioden [106 Nh]",null,"Total Livsdos\n[106 Nh]"]
[null,null,null,null,{"$f":"IF(D5=1,C5*75+1800,IF(D5=2,C5*130+1800,IF(D5=3,C5*75+800,IF(D5=4,C5*240+800,IF(D5=5,C5*85+1000,IF(D5=6,C5*60+1000,IF(D5=7,1300,IF(D5=8,1700,0))))))))","v":0},null,{"$f":"IF(OR(AND(E5>3199,B4=1),AND(E5>2499,B4=2),AND(D5=7),AND(D5=8)),E5,0)","v":0},null,null,{"$f":"IF(D5=1,H5*I5/3600,IF(D5=2,H5*I5/3600,IF(D5=3,H5*I5/3600,IF(D5=4,H5*I5/3600,IF(AND(D5=5,H5>4),H5*I5/3600,IF(AND(D5=6,H5>4),H5*I5/3600,IF(AND(D5=7,H5>119),H5*I5/3600,IF(AND(D5=8,H5>119),H5*I5/3600,0))))))))","v":0},{"$f":"G5*G5*J5","v":0},null,{"$f":"SQRT(K101/8)*8","v":0},null,null,null,null,null,{"$f":"O5*Q5*R5/1000000","v":0},null,{"$f":"(SUM(S5:S100))","v":0},null,"Typ av hantering, ange:"]
[null,null,null,null,0,null,{"$f":"IF(OR(AND(E6>3199,B4=1),AND(E6>2499,B4=2),AND(D6=7),AND(D6=8)),E6,0)","v":0},null,null,{"$f":"IF(D6=1,H6*I6/3600,IF(D6=2,H6*I6/3600,IF(D6=3,H6*I6/3600,IF(D6=4,H6*I6/3600,IF(AND(D6=5,H6>4),H6*I6/3600,IF(AND(D6=6,H6>4),H6*I6/3600,IF(AND(D6=7,H6>119),H6*I6/3600,IF(AND(D6=8,H6>119),H6*I6/3600,0))))))))","v":0},{"$f":"G6*G6*J6","v":0},null,null,null,null,null,null,null,{"$f":"O6*Q6*R6/1000000","v":0},null,null,null,"1.Lyfta upp med båda händer"]
[null,null,null,null,0,null,{"$f":"IF(OR(AND(E7>3199,B4=1),AND(E7>2499,B4=2),AND(D7=7),AND(D7=8)),E7,0)","v":0},null,null,0,0,null,null,null,null,null,null,null,0,null,null,null,"2.Lyfta upp med en hand"]
[null,null,null,null,0,null,{"$f":"IF(OR(AND(E8>3199,B4=1),AND(E8>2499,B4=2),AND(D8=7),AND(D8=8)),E8,0)","v":0},null,null,0,0,null,null,null,null,null,null,null,0,null,null,null,"3.Lyfta ned med båda händer"]
[null,null,null,null,0,null,{"$f":"IF(OR(AND(E9>3199,B4=1),AND(E9>2499,B4=2),AND(D9=7),AND(D9=8)),E9,0)","v":0},null,null,0,0,null,null,null,null,null,null,null,0,null,null,null,"4.Lyfta ned med en hand"]
[null,null,null,null,0,null,{"$f":"IF(OR(AND(E10>3199,B4=1),AND(E10>2499,B5=2),AND(D10=7),AND(D10=8)),E10,0)","v":0},null,null,0,0,null,null,null,null,null,null,null,0,null,null,null,"5.Bära/hålla framför eller vid sidan av kroppen"]
[null,null,null,null,0,null,{"$f":"IF(OR(AND(E11>3199,B5=1),AND(E11>2499,B4=2),AND(D11=7),AND(D11=8)),E11,0)","v":0},null,null,0,0,null,null,null,null,null,null,null,0,null,null,null,"6.Bära/hålla på båda sidor, på ryggen eller på axlarna"]
[null,null,null,null,0,null,{"$f":"IF(OR(AND(E12>3199,B4=1),AND(E12>2499,B4=2),AND(D12=7),AND(D12=8)),E12,0)","v":0},null,null,0,0,null,null,null,null,null,null,null,0,null,null,null,"7. Framåtböjd 20-90° minst 120 s i sträck"]
[null,null,null,null,0,null,{"$f":"IF(OR(AND(E13>3199,B4=1),AND(E13>2499,B4=2),AND(D13=7),AND(D13=8)),E13,0)","v":0},null,null,0,0,null,null,null,null,null,null,null,0,null,null,null,"8. Framåtböjd över 90° minst 120 s i sträck"]
[null,null,null,null,0,null,{"$f":"IF(OR(AND(E14>3199,B4=1),AND(E14>2499,B4=2),AND(D14=7),AND(D14=8)),E14,0)","v":0},null,null,0,0,null,null,null,null,null,null,null,0,null,null,null,"För uppgift 7 och 8 anges ingen vikt"]
[null,null,null,null,0,null,{"$f":"IF(OR(AND(E15>3199,B4=1),AND(E15>2499,B4=2),AND(D15=7),AND(D15=8)),E15,0)","v":0},null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,{"$f":"IF(OR(AND(E16>3199,B4=1),AND(E16>2499,B4=2),AND(D16=7),AND(D16=8)),E16,0)","v":0},null,null,0,{"$f":"G16*G16*J16","v":0},null,null,null,null,null,null,null,0,null,null,null,"Tid/lyft:",null,"Exempel"]
[null,null,null,null,0,null,{"$f":"IF(OR(AND(E17>3199,B4=1),AND(E17>2499,B4=2),AND(D17=7),AND(D17=8)),E17,0)","v":0},null,null,0,0,null,null,null,null,null,null,null,0,null,null,null,"Snabba","2.5 s","Rutinlyft t.ex. varuplock"]
[null,null,null,null,0,null,{"$f":"IF(OR(AND(E18>3199,B4=1),AND(E18>2499,B4=2),AND(D18=7),AND(D18=8)),E18,0)","v":0},null,null,0,0,null,null,null,null,null,null,null,0,null,null,null,"Medel","5s","Lyft med precision, t.ex mursten"]
[null,null,null,null,0,null,{"$f":"IF(OR(AND(E19>3199,B4=1),AND(E19>2499,B4=2),AND(D19=7),AND(D19=8)),E19,0)","v":0},null,null,0,0,null,null,null,null,null,null,null,0,null,null,null,"Långa","7.5s","Patienter, farligt/ömtåligt"]
[null,null,null,null,0,null,{"$f":"IF(OR(AND(E20>3199,B4=1),AND(E20>2499,B4=2),AND(D20=7),AND(D20=8)),E20,0)","v":0},null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,{"$f":"IF(OR(AND(E21>3199,B4=1),AND(E21>2499,B4=2),AND(D21=7),AND(D21=8)),E21,0)","v":0},null,null,0,0,null,null,null,null,null,null,null,0,null,null,null,"Övriga tider:"]
[null,null,null,null,0,null,{"$f":"IF(OR(AND(E22>3199,B4=1),AND(E22>2499,B4=2),AND(D22=7),AND(D22=8)),E22,0)","v":0},null,null,0,0,null,null,null,null,null,null,null,0,null,null,null,"Bärande:","1 meter = 1sekund"]
[null,null,null,null,0,null,{"$f":"IF(OR(AND(E23>3199,B4=1),AND(E23>2499,B4=2),AND(D23=7),AND(D23=8)),E23,0)","v":0},null,null,0,0,null,null,null,null,null,null,null,0,null,null,null,"Hållande och framåtböjning: Ange den verkliga tiden i sekunder"]
[null,null,null,null,0,null,{"$f":"IF(OR(AND(E24>3199,B4=1),AND(E24>2499,B4=2),AND(D24=7),AND(D24=8)),E24,0)","v":0},null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,{"$f":"IF(OR(AND(E25>3199,B4=1),AND(E25>2499,B4=2),AND(D25=7),AND(D25=8)),E25,0)","v":0},null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,{"$f":"IF(OR(AND(E26>3199,B4=1),AND(E26>2499,B4=2),AND(D26=7),AND(D26=8)),E26,0)","v":0},null,null,0,0,null,null,null,null,null,null,null,0,null,null,null,"Version: 2020-04-07"]
[null,null,null,null,0,null,{"$f":"IF(OR(AND(E27>3199,B4=1),AND(E27>2499,B4=2),AND(D27=7),AND(D27=8)),E27,0)","v":0},null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,{"$f":"IF(OR(AND(E28>3199,B4=1),AND(E28>2499,B4=2),AND(D28=7),AND(D28=8)),E28,0)","v":0},null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,{"$f":"IF(OR(AND(E29>3199,B4=1),AND(E29>2499,B4=2),AND(D29=7),AND(D29=8)),E29,0)","v":0},null,null,0,{"$f":"G29*G29*J29","v":0},null,null,null,null,null,null,null,{"$f":"O29*Q29*R29/1000000","v":0}]
[null,null,null,null,0,null,{"$f":"IF(OR(AND(E30>3199,B4=1),AND(E30>2499,B4=2),AND(D30=7),AND(D30=8)),E30,0)","v":0},null,null,0,0,null,null,null,null,null,null,null,{"$f":"O30*Q30*R30/1000000","v":0}]
[null,null,null,null,0,null,{"$f":"IF(OR(AND(E31>3199,B4=1),AND(E31>2499,B4=2),AND(D31=7),AND(D31=8)),E31,0)","v":0},null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,{"$f":"IF(OR(AND(E32>3199,B4=1),AND(E32>2499,B4=2),AND(D32=7),AND(D32=8)),E32,0)","v":0},null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,{"$f":"IF(OR(AND(E33>3199,B4=1),AND(E33>2499,B4=2),AND(D33=7),AND(D33=8)),E33,0)","v":0},null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,{"$f":"IF(OR(AND(E34>3199,B4=1),AND(E34>2499,B4=2),AND(D34=7),AND(D34=8)),E34,0)","v":0},null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,{"$f":"IF(D35=1,C35*75+1800,IF(D35=2,C35*130+1800,IF(D35=3,C35*75+800,IF(D35=4,C35*240+800,IF(D35=5,C35*85+1000,IF(D35=6,C35*60+1000,IF(D35=7,1300,IF(D35=8,1700,0))))))))","v":0},null,{"$f":"IF(OR(AND(E35>3199,B5=1),AND(E35>2499,B5=2),AND(D35=7),AND(D35=8)),E35,0)","v":0},null,null,{"$f":"IF(D35=1,H35*I35/3600,IF(D35=2,H35*I35/3600,IF(D35=3,H35*I35/3600,IF(D35=4,H35*I35/3600,IF(AND(D35=5,H35>4),H35*I35/3600,IF(AND(D35=6,H35>4),H35*I35/3600,IF(AND(D35=7,H35>119),H35*I35/3600,IF(AND(D35=8,H35>119),H35*I35/3600,0))))))))","v":0},0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,{"$f":"G70*G70*J70","v":0},null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,{"$f":"O93*Q93*R93/1000000","v":0}]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,{"$f":"IF(D99=1,C99*75+1800,IF(D99=2,C99*130+1800,IF(D99=3,C99*75+800,IF(D99=4,C99*240+800,IF(D99=5,C99*85+1000,IF(D99=6,C99*60+1000,IF(D99=7,1300,IF(D99=8,1700,0))))))))","v":0},null,{"$f":"IF(OR(AND(E99>3199,B69=1),AND(E99>2499,B69=2),AND(D99=7),AND(D99=8)),E99,0)","v":0},null,null,{"$f":"IF(D99=1,H99*I99/3600,IF(D99=2,H99*I99/3600,IF(D99=3,H99*I99/3600,IF(D99=4,H99*I99/3600,IF(AND(D99=5,H99>4),H99*I99/3600,IF(AND(D99=6,H99>4),H99*I99/3600,IF(AND(D99=7,H99>119),H99*I99/3600,IF(AND(D99=8,H99>119),H99*I99/3600,0))))))))","v":0},0,null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,0,null,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K5:K100)","v":0}]

{"sheet":"Beskrivning","index":1,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[[3,1,3,11],[2,1,2,11],[1,1,1,11],[6,1,6,11],[22,1,22,11],[10,1,10,11],[12,1,12,11],[21,1,21,11],[7,1,7,11],[8,1,8,11],[16,1,16,11],[13,1,13,11],[14,1,14,11],[15,1,15,11],[17,1,17,11],[9,1,9,11],[11,1,11,11],[5,1,5,11],[4,1,4,11],[19,1,19,11],[20,1,20,11]]}
[]
[null,"Beskrivning för att använda kalkylatorn"]
[null,"Bokstäverna/siffrorna i de gråa fälten anger från vilken rad i Bilaga B som uppgifterna skall hämtas"]
[null,"Kalkylatorn är skrivskyddad, spara en egen kopia att arbeta i"]
[null,"Börja med att kryssa i om patienten är kvinna eller man. "]
[null,"Beräkning av kompressionskraften"]
[null,"Ruta B: Namnge belastningsdagen."]
[null,"Kolumn D Bördans vikt: Fyll bördans vikt på lika många rader som antalet sätt den hanterades. Gör detta för alla bördor."]
[null,"Kolumn ”1-8 Typ av hantering”: Fyll i den siffra (1-6, se rutan till höger om kalkylatorn) som motsvarar hanteringen. Gör detta för alla rader med en ifylld vikt."]
[null,"                                                   Fyll sedan i eventuell framåtböjning 20-89 grader (7) och minst 90 grader (8) i rad där ingen vikt angetts."]
[]
[]
[null,"Beräkning av dos/återkommande faktisk belastningsdag"]
[null,"Kolumn ”F/H/K tid/hantering”: Fyll i tid i sekunder för varje hantering/framåtböjning. Standardtider för lyft, se rutan till höger om kalkylatorn. "]
[null,"                                                För framåtböjning och hållande anges den verkliga tiden i sekunder. Bära 1m=1s dvs. att bära 10 meter tar 10 sekunder."]
[null,"Kolumn ”I/L Antal/dag”: Fyll i antal per återkommande faktisk belastningsdag för alla ifyllda rader. Tryck på knappen ny dagsdos."]
[null,"Nu rensas formuläret och en kopia läggs automatiskt som en ny flik i Excel. Du får alltså en flik för varje återkommande faktisk belastningsdag. Upprepa enligt ovan för alla återkommande faktiska belastningsdagar under tidsperioden. Dagsdosen fylls automatiskt i kolumnen \"Dagsdos\". Om det inte blir så är dagsdosen får låg för att räknas med i uträkningen. "]
[]
[]
[null,"Beräkning av livsdos"]
[null,"Kolumn ”C antal dagar/år”: Fyll i Antal dagar/år för alla återkommande faktiska belastningsdagar/dagsdoser under tidsperioden."]
[null,"”A antal år”: Fyll i antal år för alla återkommande faktiska belastningsdagar/dagsdoser under tidsperioden (samma siffra för alla tidsperiodens rader)."]
[null,"Upprepa enligt ovan för alla övriga tidsperioder tills du har överfört all information från alla dina anamnesformulär. "]
[null,"I rutan \"Total livsdos\" ser du nu den kumulativa ländryggsbelastningen uttryckt i Meganewtontimmar, MNh."]