{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Effektkalky","Meny","Instruktion","Process","Resultat","Diagram","Lönekostnad för SA","Lönekostnad för MA","Data"],"not_rendered":{"charts":5,"images":26,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":"Effektkalky","index":0,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,"Liten skärm 80% zoom. Stor 100%"]

{"sheet":"Meny","index":1,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,5,2,8],[8,0,11,3],[38,0,41,3],[33,0,36,3],[28,0,31,3],[23,0,26,3],[18,0,21,3],[13,0,16,3]]}
[null,null,null,null,null,"Meny"]
[]
[]
[null,null,null,null,null," Liten skärm 100% zoom. Stor 100%"]
[]
[]
[]
[]
["Vägledning till hur effektkalkylen ska fyllas i på respektive blad"]
[]
[]
[]
[]
["Här anges timmar, frånvaro, lön, arbetsdifferentiering subventionering "]
[]
[]
[]
[]
["Här visas kostnader för ordinarie verksamhet, arbetsdifferentiering samt normalrekrytering"]
[]
[]
[]
[]
["Här visas effekter för idag, normalrekrytering samt arbetsdifferentiering"]
[]
[]
[]
[]
["Här anges tjänstgöringsgrad, semestertillägg, löneökning och personalomkostnad för medarbetare"]
[]
[]
[]
[]
["Här anges semestertillägg, löneökning och personalomkostnad för serviceassistent"]
[]
[]
[]
[]
["Här anges lönetak för subventionering. Här visas också månadslön efter sjukfrånvaro"]
[]
[]
[]
[]
[]
["Layout-design\\Lars Kinnerbäck\\VU\\AVA\\Skövde kommun"]
["Version 5\\2020-12-10"]

{"sheet":"Instruktion","index":2,"n_rows":27,"n_cols":32,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,5,2,9],[26,1,28,5],[8,1,10,5],[11,1,13,5],[14,1,16,5],[17,1,19,5],[20,1,22,5],[23,1,25,5],[7,25,7,29],[8,25,10,29],[7,31,7,35],[8,31,10,35],[7,1,7,5],[7,7,7,11],[8,7,10,11],[7,13,7,17],[8,13,10,17],[7,19,7,23],[8,19,10,23]]}
[null,null,null,null,null,"Instruktion"]
[]
[]
[null,null,null,null,null," Liten skärm 80% zoom. Stor 100%"]
[]
[]
[]
[null,"Process",null,null,null,null,null,"Resultat",null,null,null,null,null,"Diagram",null,null,null,null,null,"Lönekostnad för MA",null,null,null,null,null,"Lönekostnad för SA",null,null,null,null,null,"Data"]
[null,"Under rubriken \"Personalkostnad\" anges tre (3) värden. Klicka på respektive i-ikon för mer information",null,null,null,null,null,"Här presenteras kostnader utifrån de värden som angetts i bladen; \"Process\", \"Lönekostnad för MA\" samt \"Lönekostnad för SA\"",null,null,null,null,null,"Här presenteras effekterna utifrån de värden som angetts i bladen; \"Process\", \"Lönekostnad för MA\" samt \"Lönekostnad för SA\"",null,null,null,null,null,"Här anges fem (5) värden. Klicka på respektive i-ikon för mer information",null,null,null,null,null,"Här anges fyra (4) värden. Klicka på respektive i-ikon för mer information",null,null,null,null,null,"Här anges ett (1) värde"]
[]
[]
[null,"Under rubriken \"Effekt\" anges två (2) värden. Klicka på respektive i-ikon för mer information"]
[]
[]
[null,"Under rubriken \"Serviceassistent\" anges fyra (4) värden. Klicka på respektive i-ikon för mer information"]
[]
[]
[null,"Under rubriken \"Effektresultat\" presenteras kostnads- och resursförändring"]
[]
[]
[null,"Under rubriken \"Personalkostnader MA\" presenteras summan av personalkostnader för medarbetare"]
[]
[]
[null,"Under rubriken \"Effekter\" presenteras resultat av angivna värden i \"Effekt\""]
[]
[]
[null,"Under rubriken \"Personal-omkostnader SA\" presenteras summan av personalkostnader för serviceassistent"]

{"sheet":"Process","index":3,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,3,2,4]]}
[null,null,null,"Processen"]
[]
[]
[null,null,null," Liten skärm 80% zoom. Stor 100%"]
[]
[]
[]
[null,null,"Personalkostnad",null,null,null,null,"Personalkostnader MA","Per medarbetare","Verksamheten"]
[null,null,null,"Ange värden",null,null,null,{"$f":"'Lönekostnad för MA'!I21","v":"Summa personalkostnad:"},{"$f":"'Lönekostnad för MA'!K21","v":606771.53125631995},{"$f":"'Lönekostnad för MA'!L21","v":24270861.250252798}]
[null,null,"Medarbetare:",40,null,null,null,{"$f":"'Lönekostnad för MA'!J22","v":"Varav PF:"},{"$f":"'Lönekostnad för MA'!K22","v":177957.72824832},{"$f":"'Lönekostnad för MA'!L22","v":7118309.1299328003}]
[null,null,"Sjukfrånvaro:",0.04,null,null,null,{"$f":"'Lönekostnad för MA'!J23","v":"Varav semesterersättning:"},{"$f":"'Lönekostnad för MA'!K23","v":9966.64165631996},{"$f":"'Lönekostnad för MA'!L23","v":398665.6662527984}]
[null,null,"Månadslön:",36000,null,null,null,{"$f":"'Lönekostnad för MA'!J24","v":"Personalkostnad per månad inklusive PF (snitt):"},{"$f":"'Lönekostnad för MA'!K25","v":50564.294271359999},{"$f":"'Lönekostnad för MA'!L25","v":2022571.7708544}]
[]
[]
[null,null,"Effekt",null,null,null,null,"Effekter"]
[null,null,"Arbetsdifferentiering","Ange värden",null,null,null,"Effekt:",{"$f":"I19/I18","v":0.98397435897435892}]
[null,null,"Okvalificerade timmar:",25,null,null,null,"Motsvarar antal resurser:",{"$f":"I16*D10","v":39.358974358974358}]
[null,null,"Timmar per vecka:",39,null,null,null,"Totalt antal arbetstimmar:",{"$f":"D10*D18","v":1560}]
[null,null,null,null,null,null,null,"Effektiva arbetstimmar:",{"$f":"I18-D17","v":1535}]
[]
[]
[null,null,"Serviceassistent",null,null,null,null,"Personalkostnader SA"]
[null,null,null,"Ange värden",null,null,null,"Nettokostnad (lönekostnad - intäkt):",{"$f":"I24-(I29)","v":100929.26784923079}]
[null,null,"Timmar per vecka:",25,null,null,null,{"$f":"'Lönekostnad för SA'!I21","v":"Summa personalkostnad:"},{"$f":"'Lönekostnad för SA'!K21","v":207083.11400307695}]
[null,null,"Sjukfrånvaro:",0.08,null,null,null,{"$f":"'Lönekostnad för SA'!J22","v":"Varav PF:"},{"$f":"'Lönekostnad för SA'!K22","v":60734.623541538458}]
[null,null,"Månadslön:",20000,null,null,null,{"$f":"'Lönekostnad för SA'!J23","v":"Varav semesterersättning:"},{"$f":"'Lönekostnad för SA'!K23","v":3401.483233846142}]
[null,null,"Subventionering:",0.75,null,null,null,{"$f":"'Lönekostnad för SA'!J24","v":"Personalkostnad per månad inklusive PF (snitt):"},{"$f":"'Lönekostnad för SA'!K25","v":17256.92616692308}]
[null,null,null,null,null,null,null,"Personalkostnad per månad inkl. pf-subventionering i snitt:",{"$f":"I27-Data!D13","v":8410.7723207692343}]
[null,null,null,null,null,null,null,"Summa subventionering:",{"$f":"Data!D14","v":106153.84615384616}]
[null,null,null,null,null,null,null,"PF=personalomkostnad"]
[]
[null,null,"Effektresultat",null,null,null,null,"Effektresultat diagram"]
[null,null,null,null,null,null,null,null,null,"Resursökning"]
[null,null,"Resursökning:",{"$f":"D24*(1-(D25-D11))/D18","v":0.61538461538461542},null,null,null,null,null,{"$f":"D34","v":0.61538461538461542}]
[null,null,"Ordinarie kostnad:",{"$f":"D34*I9","v":373397.86538850464}]
[null,null,"Faktisk kostnad:",{"$f":"I23","v":100929.26784923079},null,null,null,null,null,"Kostnadsbesparing"]
[null,null,"Kostnadsbesparing:",{"$f":"D35-D36","v":272468.59753927385},null,null,null,null,null,{"$f":"D37","v":272468.59753927385}]

{"sheet":"Resultat","index":4,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,3,2,4]]}
[null,null,null,"Resultat"]
[]
[]
[null,null,null," Liten skärm 100% zoom. Stor 100%"]
[]
[]
[]
[null,null,null,"Ordinarie verksamhet","Arbetsdifferentiering ","Normalrekrytering"]
[null,null,"Kostnad ",{"$f":"Process!J9","v":24270861.250252798},{"$f":"D9+Process!I23","v":24371790.518102027},{"$f":"D9+Process!D35","v":24644259.115641303}]
[null,null,"Resurs "]
[null,null,"Effektkostnad"]

{"sheet":"Diagram","index":5,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,3,2,3]]}
[null,null,null,"Diagram"]
[]
[]
[null,null,null," Liten skärm 100% zoom. Stor 100%"]
[]
[]
[]
[null,null,null,"Effekt","Kostnad ","Effekt/kostnadsenhet"]
[null,null,"Idag",{"$f":"Process!D37","v":272468.59753927385},{"$f":"Process!D36","v":100929.26784923079}]
[null,null,"Normarekrytering",{"$f":"Process!#REF!","v":{"$error":"#REF!"}},{"$f":"Process!#REF!","v":{"$error":"#REF!"}}]
[null,null,"Arbetsdifferentiering",{"$f":"Process!AG41","v":0},{"$f":"Process!AG42","v":0}]

{"sheet":"Lönekostnad för SA","index":6,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,2,2,8],[8,6,8,7],[13,4,13,5],[23,9,24,9],[13,10,14,10],[10,2,14,2],[10,3,14,3],[11,6,14,6],[11,7,14,7],[11,8,14,8],[13,9,14,9]]}
[null,null,"Lönekostnad för serviceassistent"]
[]
[]
[null,null," Liten skärm 90% zoom. Stor 100%"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Ange värden"]
[null,null,null,null,null,null,"Sem.tillägg","PF"]
[null,"PF=personalomkostnad","Månadslön  (anges i kronor)","Tjänst-görings-grad i %",null,null,1.67E-2,0.41499999999999998,null,null,null,{"$f":"Process!D10","v":40}]
[null,null,null,null,null,null,"Semester-tillägg","PF","Månadslön efter uppskjuten löneökning"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"C17/1000","v":0}]
[null,null,null,null,"Ange värden",null,null,null,null,"Lönekostnad exklusive PF (i tkr)","Lönekostnad  inklusive PF (i tkr)"]
[null,"Befattning",null,null,"Månader","Löneökning",null,null,null,null,null,"Arbetslagskostnad"]
[null,"Personalkostnad (snitt)",{"$f":"Process!D26","v":20000},{"$f":"Process!D24/Process!D18","v":0.64102564102564108},12,1.7000000000000001E-2,{"$f":"G11","v":1.67E-2},{"$f":"H11","v":0.41499999999999998},{"$f":"(C16*D16*F16)+(C16*D16)","v":13038.461538461541},{"$f":"(I16*E16+I16*E16*G16)","v":159074.44615384619},{"$f":"(J16*H16+J16)","v":225090.34130769235},{"$f":"K16*$L$11","v":9003613.6523076929}]
[null,null,null,null,null,null,null,null,null,null,null,0]
["Frånvaro:",{"$f":"Process!D25","v":0.08},null,null,null,null,null,null,null,{"$f":"(SUM(J16:J17)*-B18)","v":-12725.955692307696},{"$f":"(SUM(K16:K17)*-B18)","v":-18007.22730461539},-720289.09218461555]
[null,null,null,null,null,null,null,null,"Fyllnads- och övertidsersättning, OB tillägg m.m., konto 5027 och 5028 + PF:",null,null,0]
[null,null,null,null,null,null,null,null,"Övriga tillägg, konto 5029 + PF:",null,null,0]
[null,null,null,null,null,null,null,null,"Summa personalkostnad:",{"$f":"SUM(J16:J20)","v":146348.49046153849},{"$f":"SUM(K16:K20)+L13","v":207083.11400307695},8283324.5601230776]
[null,null,null,null,null,null,null,null,null,"Varav PF:",{"$f":"K21-J21","v":60734.623541538458},2429384.9416615386]
[null,null,null,null,null,null,null,null,null,"Varav semesterersättning:",{"$f":"K21-(K21/(1+G11))","v":3401.483233846142},136059.32935384568]
[null,null,null,null,null,null,null,null,null,"Personalkostnad per månad inklusive PF (snitt):"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K21/12","v":17256.92616692308},{"$f":"K25*$L$11","v":690277.04667692317}]

{"sheet":"Lönekostnad för MA","index":7,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[[8,6,8,7],[12,6,14,6],[12,7,14,7],[13,9,14,9],[0,2,2,8],[23,9,24,9],[10,2,14,2],[13,3,13,5],[12,10,14,10],[10,8,14,8]]}
[null,null,"Lönekostnad för medarbetare"]
[]
[]
[null,null," Liten skärm 90% zoom. Stor 100%"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Ange värden"]
[null,null,null,null,null,null,"Sem.tillägg","PF"]
[null,"PF=personalomkostnad","Månadslön  (anges i kronor)",null,null,null,1.67E-2,0.41499999999999998,"Månadslön efter uppskjuten löneökning",null,null,{"$f":"Process!D10","v":40}]
[]
[null,null,null,null,null,null,"Semester-tillägg","PF",null,null,"Lönekostnad  inklusive PF (i tkr)",{"$f":"C17/1000","v":0}]
[null,null,null,"Ange värden",null,null,null,null,null,"Lönekostnad exklusive PF (i tkr)"]
[null,"Befattning",null,"Tjg","Månader","Löneökning",null,null,null,null,null,"Arbetslagskostnad"]
[null,"Personalkostnad (snitt)",{"$f":"Process!D12","v":36000},1,12,1.7000000000000001E-2,{"$f":"G11","v":1.67E-2},{"$f":"H11","v":0.41499999999999998},{"$f":"(C16*D16*F16)+(C16*D16)","v":36612},{"$f":"(I16*E16+I16*E16*G16)","v":446681.04479999997},{"$f":"(J16*H16+J16)","v":632053.67839199991},{"$f":"K16*$L$11","v":25282147.135679998}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"K17*$L$11","v":0}]
["Frånvaro:",{"$f":"Process!D11","v":0.04},null,null,null,null,null,null,null,{"$f":"(SUM(J16:J17)*-B18)","v":-17867.241792000001},{"$f":"(SUM(K16:K17)*-B18)","v":-25282.147135679996},-1011285.8854271998]
[null,null,null,null,null,null,null,null,"Fyllnads- och övertidsersättning, OB tillägg m.m., konto 5027 och 5028 + PF:",null,null,{"$f":"K19*$L$11","v":0}]
[null,null,null,null,null,null,null,null,"Övriga tillägg, konto 5029 + PF:",null,null,{"$f":"K20*$L$11","v":0}]
[null,null,null,null,null,null,null,null,"Summa personalkostnad:",{"$f":"SUM(J16:J20)","v":428813.80300799996},{"$f":"SUM(K16:K20)+L13","v":606771.53125631995},24270861.250252798]
[null,null,null,null,null,null,null,null,null,"Varav PF:",{"$f":"K21-J21","v":177957.72824832},7118309.1299328003]
[null,null,null,null,null,null,null,null,null,"Varav semesterersättning:",{"$f":"K21-(K21/(1+G11))","v":9966.64165631996},398665.6662527984]
[null,null,null,null,null,null,null,null,null,"Personalkostnad per månad inklusive PF (snitt):"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K21/12","v":50564.294271359999},{"$f":"K25*$L$11","v":2022571.7708544}]

{"sheet":"Data","index":8,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,3,2,4]]}
[null,null,null,"Data"]
[]
[]
[null,null,null," Liten skärm 100% zoom. Stor 100%"]
[]
[]
[]
[null,null,null,"Ange värde"]
[null,null,"Lönetak subventionering",20000]
[null,null,"Månadslön efter sjukfrånvaro",{"$f":"Process!D26*(1-Process!D25)*Process!D24/Process!D18","v":11794.871794871795}]
[null,null,"Subventionering i procent",{"$f":"Process!D27","v":0.75}]
[null,null,"Sjukfrånvaro",{"$f":"'Lönekostnad för SA'!B18","v":0.08}]
[null,null,"Månadsresultat",{"$f":"D10*D11","v":8846.1538461538457}]
[null,null,"Årsresultat",{"$f":"D13*12","v":106153.84615384616}]