{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Tjänstgöringsrapport sköterska","Tjänstgöringsrapport (ssk)"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Tjänstgöringsrapport sköterska","index":0,"n_rows":43,"n_cols":31,"rows_kept":43,"merged":[[2,14,2,16],[4,2,4,3],[4,14,4,16],[7,2,7,5],[7,7,7,13],[7,14,7,18],[7,19,7,23],[7,26,7,31],[8,2,8,5],[8,7,8,13],[8,14,8,15],[8,16,8,17],[8,19,8,20],[8,21,8,22],[8,26,8,31],[9,14,9,15],[9,16,9,17],[9,19,9,20],[9,21,9,22],[10,2,10,5],[10,14,10,15],[10,16,10,17],[10,19,10,20],[10,21,10,22],[11,14,11,15],[11,16,11,17],[11,19,11,20],[11,21,11,22],[12,14,12,15],[12,16,12,17],[12,19,12,20],[12,21,12,22],[36,19,36,20],[36,21,36,22],[37,0,37,2],[37,3,37,5],[38,3,38,5],[38,7,38,8],[39,0,39,2],[39,3,39,5],[39,26,39,31],[40,0,40,2],[40,3,40,5],[40,7,40,9],[40,16,40,18],[41,0,41,2],[41,3,41,5],[42,0,42,2],[42,3,42,5],[43,0,43,2],[43,3,43,5],[44,0,44,2],[44,3,44,5]]}
["Enhet/ort: ",{"$nulls":10},"Avropsnr / diarienr: "]
[]
["År & månad (ÅÅÅÅ-MM):",{"$nulls":7},"Period:",{"$nulls":5},"Sköterskans namn:",{"$nulls":6}," (textat)"]
[]
[null,"Timkostn:",{"$nulls":12},"Leverantör:"]
[]
[]
[null,null,"Normatid",{"$nulls":4},"OB-Tid",{"$nulls":6},"JOUR",{"$nulls":4},"BEREDSKAP"]
[null,null,"Ordinarie arbetstid",{"$nulls":4},"\"AKTIV TID\"",{"$nulls":6},"Bunden tid",null,"Bunden tid",null,"AKTIV TID","Bunden tid",null,"Bunden tid",null,"AKTIV TID"]
[{"$nulls":7},"19-22","22-06","19-22","06-19","22-06","07-22","22-07","00:00-23:59",null,"00:00-23:59",null,"00:00-23:59","00:00-23:59",null,"00:00-23:59",null,"00:00-23:59"]
[null,null,"OBS! kom ihåg att fylla i lunch (HH:MM)",{"$nulls":4},"Måndag-Torsdag\n(vardag-\nkväll)","Måndag-Fredag\n(vardag-\nnatt)","Fredag\nLördag\nSöndag\nHelgdag\n(kväll)","Lördag\nSöndag\nHelgdag\n(dag)","Fredag\nLördag\nSöndag\nHelgdag\n(natt)","Storhelg\n(dag och\nkväll)","Storhelg\n(nattl)","Lördag\nSöndag\nStorhelg\nHelgdag\n",null,"Måndag\nTisdag\nOnsdag\nTorsdag\nFredag\n",null,"Måndag-Söndag\nStorhelg\nHelgdag\n","Lördag\nSöndag\nStorhelg\nHelgdag\n",null,"måndag\nTisdag\nOnsdag\nTorsdag\nFredag\n",null,"Måndag-Söndag\nStorhelg\nHelgdag\n"]
[]
[]
["Dag","Datum","Från kl.","Till kl.","Lunch","Antal timmar","Normal-tid","Antal timmar","Antal timmar","Antal timmar","Antal timmar","Antal timmar","Antal timmar","Antal timmar","Antal timmar","\"Jour\" minus \"aktiv tid\"","Antal timmar","\"Jour\" minus \"aktiv tid\"","Antal timmar","Antal timmar","\"Beredskap\" minus\"\naktiv tid\"","Antal timmar","\"Beredskap\" minus \"aktiv tid\"","Antal timmar"]
[]
[]
[{"$nulls":5},{"$f":"((D17-C17+(D17<C17))-E17)*24","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"}]
[null,"Summa timmar:",{"$nulls":3},"Tot tim",{"$f":"IF(SUM(G15:G28)=0,\"\",SUM(G15:G28))","v":""},{"$f":"IF(SUM(H15:H28)=0,\"\",SUM(H15:H28))","v":""},"",{"$f":"IF(SUM(J15:J28)=0,\"\",SUM(J15:J28))","v":""},{"$f":"IF(SUM(K15:K28)=0,\"\",SUM(K15:K28))","v":""},null,"","","Tot tim","","Tot tim","","","Tot tim","","Tot tim","",{"$f":"IF(SUM(X15:X28)=0,\"\",SUM(X15:X28))","v":""}]
[{"$nulls":6},"Kostnad"]
[]
[]
[]
[]
[]
[]
[{"$nulls":21},{"$f":"IFERROR(#REF!*$C$5*V13,\"\")","v":""},{"$nulls":6},{"$f":"IFERROR(#REF!*$C$5*(1+$AB$5)*#REF!,\"\")","v":""},{"$f":"IFERROR(#REF!*$C$5*(1+$AB$5)*#REF!,\"\")","v":""},{"$f":"IFERROR(#REF!*$C$5*(1+$AB$5)*#REF!,\"\")","v":""}]
[]
[{"$nulls":7},"Ort och datum:"]
[]
[{"$nulls":7},"Underskrift Inhyrd konsult:",{"$nulls":8},"Underskrift behörig på enhet:"]
[]
[{"$nulls":17},"Namnförtydligande"]

{"sheet":"Tjänstgöringsrapport (ssk)","index":1,"n_rows":48,"n_cols":24,"rows_kept":48,"hidden":true,"merged":[[3,2,3,6],[5,3,5,6],[5,15,5,17],[7,15,7,17],[14,7,14,10],[14,12,14,14],[14,15,14,17],[14,20,15,20],[14,21,15,22],[14,23,15,23],[15,6,20,6],[15,7,20,7],[15,8,20,8],[15,9,20,9],[15,10,20,10],[15,12,20,14],[15,15,20,15],[15,16,20,16],[15,17,20,17],[37,21,37,22],[41,14,41,17],[43,14,43,17],[45,14,45,17],[47,14,47,17]]}
["Tjänstgöringsrapport (sjuksköterskor)"]
[]
[]
["Enhet/ort: "]
[]
["År & månad (ÅÅÅÅ-MM):",{"$nulls":7},"Pris:",700,null,null,"Sjuksköterskans namn:"]
[]
["Veckonummer:",{"$nulls":7},"Avdrag:",{"v":-0.1,"d":"-10%"},null,null,"Leverantör:"]
[]
["Pris:",{"$nulls":7},"Avdrag:",{"$nulls":3},"Not: Helgdag och storhelg börjar 00.00 aktuellt datum. "]
["Specialistsjuksköterskor",null,null,700,{"$nulls":4},"Om leg.ssk erbjuds ",{"$nulls":3},"Med helgdag avses röda dagar i almanackan. "]
[{"$nulls":8},"vid avrop av specialist ssk ",null,{"v":-0.1,"d":"-10%"},null,"Med storhelg avses midsommarhelg, julhelg och nyårshleg. "]
[]
[]
[{"$nulls":6},"Varav \nordinarie arbetstid","Varav \nobekväm arbetstid",{"$nulls":4},"Jourpass bunden tid",null,null,"Jour eller beredskap",{"$nulls":4},"Check:",null,null,"Check:"]
[{"$nulls":6},"\nVardag\n07-19\n","Vardag\n19-22","Vardag\n22-07","\nFre 22-\nmån 07\n","Storhelg\n00-00",{"$nulls":4},"Aktiv tid","Jour\n\n(bunden tid \npå \narbetsstället)","Beredskap\n\n(bunden tid utom arbetsstället)"]
[]
[]
[]
[]
[]
[{"$nulls":5},"Faktor:",{"v":1,"d":"1.00"},1.05,{"v":1.1,"d":"1.10"},1.15,1.25,{"$nulls":3},"Faktor:",1.15,{"v":0.3,"d":"0.30"},0.15]
["Datum",null,"Från kl.","Till kl.","Lunch","Antal timmar","Varav timmar","Varav tim","Varav tim","Varav tim","Varav tim",null,"Från kl.","Till kl.","Antal timmar","Varav timmar","Varav timmar","Varav timmar"]
[null,null,"08:00:00","17:00:00","01:00:00",{"$f":"((D24-C24+(D24<C24))-E24)*24","v":{"v":8,"d":"8.00"}},{"v":7,"d":"7.00"},{"v":1,"d":"1.00"},{"$nulls":4},"08:00:00","16:00:00",{"$f":"(N24-M24+(N24<M24))*24","v":{"v":8,"d":"8.00"}},{"v":2,"d":"2.00"},{"v":6,"d":"6.00"},{"$nulls":3},{"$f":"IFERROR(F24-G24-H24-I24-J24-K24,\"\")","v":{"v":0,"d":"0.00"}},null,null,{"$f":"O24-P24-Q24-R24","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"$f":"((D25-C25+(D25<C25))-E25)*24","v":{"v":0,"d":"0.00"}},{"$nulls":8},{"$f":"(N25-M25+(N25<M25))*24","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IFERROR(F25-G25-H25-I25-J25-K25,\"\")","v":{"v":0,"d":"0.00"}},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"v":0.5,"d":"0.50"},{"$nulls":7},{"v":0,"d":"0.00"},{"$nulls":5},{"v":-0.5,"d":"-0.50"},null,null,{"v":0,"d":"0.00"}]
[null,null,"08:00:00","17:00:00",null,{"v":9.000000000000002,"d":"9.00"},{"v":5,"d":"5.00"},{"v":3,"d":"3.00"},{"$nulls":4},"09:00:00","16:00:00",{"v":6.999999999999999,"d":"7.00"},null,{"v":2,"d":"2.00"},{"$nulls":3},{"v":1.0000000000000018,"d":"1.00"},null,null,{"v":4.999999999999999,"d":"5.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":8},{"v":0,"d":"0.00"},null,null,{"v":10,"d":"10.00"},null,null,{"$f":"IFERROR(F28-G28-H28-I28-J28-K28,\"\")","v":{"v":0,"d":"0.00"}},null,null,{"v":-10,"d":"-10.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":8},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":6},"15:00:00","21:00:00",{"v":6,"d":"6.00"},null,{"v":4,"d":"4.00"},{"v":2,"d":"2.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":8},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":8},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":8},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":8},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":8},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":8},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":8},{"v":0,"d":"0.00"},{"$nulls":5},{"v":0,"d":"0.00"},null,null,{"$f":"O37-P37-Q37-R37","v":{"v":0,"d":"0.00"}}]
["Summa timmar:",{"$nulls":4},{"$f":"SUM(F24:F37)","v":{"v":17,"d":"17.00"}},{"$f":"IF(SUM(G24:G37)=0,\"\",SUM(G24:G37))","v":{"v":12.5,"d":"12.50"}},{"$f":"IF(SUM(H24:H37)=0,\"\",SUM(H24:H37))","v":{"v":4,"d":"4.00"}},{"$f":"IF(SUM(I24:I37)=0,\"\",SUM(I24:I37))","v":""},{"$f":"IF(SUM(J24:J37)=0,\"\",SUM(J24:J37))","v":""},{"$f":"IF(SUM(K24:K37)=0,\"\",SUM(K24:K37))","v":""},{"$nulls":3},{"$f":"IF(SUM(O24:O37)=0,\"\",SUM(O24:O37))","v":{"v":21,"d":"21.00"}},{"$f":"IF(SUM(P24:P37)=0,\"\",SUM(P24:P37))","v":{"v":2,"d":"2.00"}},{"$f":"IF(SUM(Q24:Q37)=0,\"\",SUM(Q24:Q37))","v":{"v":12,"d":"12.00"}},{"$f":"IF(SUM(R24:R37)=0,\"\",SUM(R24:R37))","v":{"v":12,"d":"12.00"}}]
[]
["Fakturabelopp:",{"$nulls":5},{"$f":"IFERROR(G38*$J$6*(1+$J$8)*G22,\"\")","v":{"v":7875,"d":"7,875"}},{"$f":"IFERROR(H38*$J$6*(1+$J$8)*H22,\"\")","v":{"v":2646,"d":"2,646"}},{"$f":"IFERROR(I38*$J$6*(1+$J$8)*I22,\"\")","v":""},{"$f":"IFERROR(J38*$J$6*(1+$J$8)*J22,\"\")","v":""},{"$f":"IFERROR(K38*$J$6*(1+$J$8)*K22,\"\")","v":""},{"$nulls":4},{"$f":"IFERROR(P38*$J$6*(1+$J$8)*P22,\"\")","v":{"v":1449,"d":"1,449"}},{"$f":"IFERROR(Q38*$J$6*(1+$J$8)*Q22,\"\")","v":{"v":2268,"d":"2,268"}},{"$f":"IFERROR(R38*$J$6*(1+$J$8)*R22,\"\")","v":{"v":1134,"d":"1,134"}},"Total:",{"$f":"SUM(G40:R40)","v":{"v":15372,"d":"15,372"}}]
[]
[{"$nulls":9},"Ort och datum:"]
[]
[{"$nulls":9},"Underskrift inhyrd person:"]
[]
[{"$nulls":9},"Underskrift behörig på enhet:"]
[]
[{"$nulls":9},"Namnförtydligande behörig på enhet:"]