{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Grunddata","Beräkningar nyttor","Nyttor","Kostnader","Nyttorealiseringskalkyl","-Admin-"],"not_rendered":{"charts":14,"macros":1,"external_links":2,"defined_names":6,"pivot_tables":7},"read":"whole","date_system":"1900"}

{"sheet":"Grunddata","index":0,"n_rows":37,"n_cols":5,"rows_kept":37}
[null,"Grunddata"]
[null,{"$f":"IF(B6=0,\"\",B6)","v":"Katalog 2025"}]
[]
[]
[null,"Tjänst / projekt / förändringsinitiativ"]
[null,"Katalog 2025"]
[]
[]
[null,"Revisionshistorik"]
[null,"Version","Datum","Författare","Kommentar"]
[null,null,"2020-09-28","Amanda Sundberg","Upprättar kalkyl"]
[null,null,"2020-10-13","Amanda Sundberg","Genomför preliminära beräkningar nyttor"]
[null,null,"2020-10-14","Amanda Sundberg","Uppdaterar beräkningar tillsammans med arbetsgruppen"]
[null,null,"2020-10-15","Amanda Sundberg","Reviderar då mer data om nyttor kommit in"]
[null,null,"2020-10-19","Amanda Sundberg","Reviderar med nya kostnadsuppgifter"]
[null,null,"2020-10-23","Amanda Sundberg","Uppgraderar till senaste mallen"]
{"$rows_empty":7}
[null,"Startår"]
[null,"Ange från vilket år periodiserade kostnader och nyttor ska anges. "]
[]
[null,"Parameter","Värde"]
[null,"Startår",2021]
[]
[]
[null,"Intressenter"]
[null,"Ange de intressenter som bär nyttor eller kostnader alternativt är involverade i genomförandet. De intressenter som anges här kommer att visas och bli valbara i den här mallens flikar om kostnader och nyttor. "]
[]
[null,"Intressent","Intressentkategori"]
[null,"Regioner","Region"]
[null,"Inera","Inera"]
[null,"Kommuner","Kommun"]

{"sheet":"Beräkningar nyttor","index":1,"n_rows":179,"n_cols":17,"rows_kept":179}
["Beräkningar av nyttor"]
[]
[]
["Minskade kostnader för anpassningar för att hantera felaktig information","Trolig","Källa ","Säkerhet","Min","Max",null,null,2021,2022,2023,2024,2025,2026,"Summa trolig","Summa min","Summa max"]
["Timpris, snitt för Systemutvecklare kompeteninvå 3",{"v":751,"d":"751 kr"},"Kommentus Ramavtal (Stockholm)","Ganska säker",{"$f":"B5","v":{"v":751,"d":"751 kr"}},{"v":900,"d":"900 kr"},null,"Trolig",null,null,{"$f":"$B$12","v":{"v":227803.33333333334,"d":"227,803 kr"}},{"v":227803.33333333334,"d":"227,803 kr"},{"v":227803.33333333334,"d":"227,803 kr"},{"v":227803.33333333334,"d":"227,803 kr"},{"$f":"SUM(I5:N5)","v":{"v":911213.3333333334,"d":"911,213 kr"}},{"$f":"SUM(I6:N6)","v":{"v":911213.3333333334,"d":"911,213 kr"}},{"$f":"SUM(I7:N7)","v":{"v":2184000,"d":"2,184,000 kr"}}]
["Kostnad för anpassning i tjänsten Formulärhantering (70 timmar)",{"$f":"70*B5","v":{"v":52570,"d":"52,570 kr"}},"Jenny Eltes","Mycket säker",{"$f":"70*E5","v":{"v":52570,"d":"52,570 kr"}},{"$f":"70*F5","v":{"v":63000,"d":"63,000 kr"}},null,"Min",null,null,{"$f":"$E$12","v":{"v":227803.33333333334,"d":"227,803 kr"}},{"v":227803.33333333334,"d":"227,803 kr"},{"v":227803.33333333334,"d":"227,803 kr"},{"v":227803.33333333334,"d":"227,803 kr"}]
["Kostnad för anpassning i tjänsten Stöd och Behandling (200 timmar)",{"$f":"200*B5","v":{"v":150200,"d":"150,200 kr"}},"Åsa Jonsson","Mycket säker",{"$f":"200*E5","v":{"v":150200,"d":"150,200 kr"}},{"$f":"200*F5","v":{"v":180000,"d":"180,000 kr"}},null,"Max",null,null,{"$f":"$F$12","v":{"v":546000,"d":"546,000 kr"}},{"v":546000,"d":"546,000 kr"},{"v":546000,"d":"546,000 kr"},{"v":546000,"d":"546,000 kr"}]
["Kostnad för anpassning i Intygsstjänser (200+168+168+104 timmar)",{"$f":"(200+168+168+104)*B5","v":{"v":480640,"d":"480,640 kr"}},"Anna Rajkowska","Mycket säker",{"$f":"(200+168+168+104)*E5","v":{"v":480640,"d":"480,640 kr"}},{"$f":"(200+168+168+104)*F5","v":{"v":576000,"d":"576,000 kr"}}]
["Kostnad för anpassning i Person- och Säkerhetstjänsterna (mycket-men ville inte uppskatta, tar snittet)",{"$f":"AVERAGE(B6:B8)","v":{"v":227803.33333333334,"d":"227,803 kr"}},"Niclas Hedlund","Mycket säker",{"$f":"E10","v":{"v":227803.33333333334,"d":"227,803 kr"}},{"$f":"F10","v":{"v":273000,"d":"273,000 kr"}}]
["Kostnad i snitt för att anpassa tjänsten för att hantera fel i HSA",{"$f":"AVERAGE(B6:B8)","v":{"v":227803.33333333334,"d":"227,803 kr"}},"Medelvärde","Mycket säker",{"$f":"AVERAGE(E6:E8)","v":{"v":227803.33333333334,"d":"227,803 kr"}},{"$f":"AVERAGE(F6:F8)","v":{"v":273000,"d":"273,000 kr"}}]
["Hälften av antalet tjänster som ansluter per år kan undvika anpassningar",1,"Ineras antagande","Ganska säker",{"$f":"B11","v":{"v":1,"d":"1 "}},{"v":2,"d":"2 "}]
["Minskade kostnader för att hantera felaktig information per år",{"$f":"B11*B10","v":{"v":227803.33333333334,"d":"227,803 kr"}},null,null,{"$f":"E11*E10","v":{"v":227803.33333333334,"d":"227,803 kr"}},{"$f":"F11*F10","v":{"v":546000,"d":"546,000 kr"}}]
[]
["Minskade kostnader för drift och förvaltning av HSA","Trolig","Källa ","Säkerhet","Min","Max",null,null,2021,2022,2023,2024,2025,2026,"Summa trolig","Summa min","Summa max"]
["Applikationsförvaltning",{"$nulls":6},"Trolig",null,null,{"$f":"$B$39","v":{"v":765672,"d":"765,672 kr"}},{"$f":"$B$39","v":{"v":765672,"d":"765,672 kr"}},{"v":765672,"d":"765,672 kr"},{"v":765672,"d":"765,672 kr"},{"$f":"SUM(I15:N15)","v":{"v":3062688,"d":"3,062,688 kr"}},{"$f":"SUM(I16:N16)","v":{"v":2102688,"d":"2,102,688 kr"}},{"$f":"SUM(I17:N17)","v":{"v":8107488,"d":"8,107,488 kr"}}]
["Kostnad applikationförvaltning per månad",{"v":253000,"d":"253,000 kr"},"Cybercom","Mycket säker",{"v":253000,"d":"253,000 kr"},{"v":253000,"d":"253,000 kr"},null,"Min",null,null,{"$f":"$E$39","v":{"v":525672,"d":"525,672 kr"}},{"$f":"$E$39","v":{"v":525672,"d":"525,672 kr"}},{"v":525672,"d":"525,672 kr"},{"v":525672,"d":"525,672 kr"}]
["Antal timmar applikationsförvaltning per månad",{"v":300,"d":"300 "},"Cybercom","Mycket säker",{"v":300,"d":"300 "},{"v":300,"d":"300 "},null,"Max",null,null,{"$f":"$F$39","v":{"v":2026872,"d":"2,026,872 kr"}},{"$f":"$F$39","v":{"v":2026872,"d":"2,026,872 kr"}},{"v":2026872,"d":"2,026,872 kr"},{"v":2026872,"d":"2,026,872 kr"}]
["Kostnad idag för applikationsförvaltning, per timme -enl.  Cybercom 300 timmar/mån och 253 000/mån",{"$f":"B16/B17","v":{"v":843.3333333333334,"d":"843 kr"}},"Cybercom","Mycket säker",{"$f":"E16/E17","v":{"v":843.3333333333334,"d":"843 kr"}},{"$f":"F16/F17","v":{"v":843.3333333333334,"d":"843 kr"}}]
["Årskostnad applikationsförvaltning",{"$f":"B16*12","v":{"v":3036000,"d":"3,036,000 kr"}},"Cybercom","Mycket säker",{"$f":"E16*12","v":{"v":3036000,"d":"3,036,000 kr"}},{"$f":"F16*12","v":{"v":3036000,"d":"3,036,000 kr"}}]
["Snittkostnad applikationsförvaltning Inera - timpris, snitt för Systemutvecklare kompeteninvå 3",{"v":751,"d":"751 kr"},"Kommentus Ramavtal (Stockholm)","Ganska säker",{"$f":"B20","v":{"v":751,"d":"751 kr"}},{"$f":"B20","v":{"v":751,"d":"751 kr"}}]
["Antal timmar applikationsförvaltning framöver",{"v":300,"d":"300 "},"Ineras uppskattning","Ganska säker",{"v":300,"d":"300 "},{"v":200,"d":"200 "}]
["Årskostnad med lägre kompetensnivå",{"$f":"B21*B20*12","v":{"v":2703600,"d":"2,703,600 kr"}},"Ineras antagande","Ganska säker",{"$f":"E21*E20*12","v":{"v":2703600,"d":"2,703,600 kr"}},{"$f":"F21*F20*12","v":{"v":1802400,"d":"1,802,400 kr"}}]
["Minskade kostnader för applikationsförvaltning per år",{"$f":"B19-B22","v":{"v":332400,"d":"332,400 kr"}},null,null,{"$f":"E19-E22","v":{"v":332400,"d":"332,400 kr"}},{"$f":"F19-F22","v":{"v":1233600,"d":"1,233,600 kr"}}]
[]
["Support (Service Agreement)"]
["Supportkostnad per månad i snitt",{"v":50000,"d":"50,000 kr"},"Robban","Ganska säker",{"v":30000,"d":"30,000 kr"},{"v":80000,"d":"80,000 kr"}]
["Supportkostnad per år",{"$f":"B26*12","v":{"v":600000,"d":"600,000 kr"}},"Mikael Welander","Ganska säker",{"$f":"E26*12","v":{"v":360000,"d":"360,000 kr"}},{"$f":"F26*12","v":{"v":960000,"d":"960,000 kr"}}]
["Supportkostnad i snitt per månad för Ineras övriga tjänster hos Basefarm",{"v":13894,"d":"13,894 kr"},"Mikael Welander","Mycket säker",{"v":13894,"d":"13,894 kr"},{"v":13894,"d":"13,894 kr"}]
["Supportkostnad per år för Ineras övriga tjänster hos Basefarm",{"$f":"B28*12","v":{"v":166728,"d":"166,728 kr"}},"Mikael Welander","Mycket säker",{"$f":"E28*12","v":{"v":166728,"d":"166,728 kr"}},{"$f":"F28*12","v":{"v":166728,"d":"166,728 kr"}}]
["Minskade kostnader för support per år",{"$f":"B27-B29","v":{"v":433272,"d":"433,272 kr"}},"Ineras antagande","Ganska säker",{"$f":"E27-E29","v":{"v":193272,"d":"193,272 kr"}},{"$f":"F27-F29","v":{"v":793272,"d":"793,272 kr"}}]
["Minskade kostnader för support per år",{"$f":"B30","v":{"v":433272,"d":"433,272 kr"}},null,null,{"$f":"E30","v":{"v":193272,"d":"193,272 kr"}},{"$f":"F30","v":{"v":793272,"d":"793,272 kr"}}]
[]
["Drift"]
["Hyrd hårdvara kostnad per månad idag",{"v":130558,"d":"130,558 kr"},"Mikael Welander","Mycket säker",{"v":130558,"d":"130,558 kr"},{"v":130558,"d":"130,558 kr"}]
["Hyrd hårdvara kostnad per år",{"$f":"B34*12","v":{"v":1566696,"d":"1,566,696 kr"}},"Mikael Welander","Mycket säker",{"$f":"E34*12","v":{"v":1566696,"d":"1,566,696 kr"}},{"$f":"F34*12","v":{"v":1566696,"d":"1,566,696 kr"}}]
["Förväntad kostnad för hyrd hårdvara per månad",null,"Kolla förra projektet","Osäker"]
["Förväntad kostnad för hyrd hårdvara per år",null,"Kolla förra projektet","Osäker"]
["Minskade kostnader för drift",{"v":0,"d":"0 kr"}]
["Summa minskade kostnader för applikationsförvaltning, support och drift",{"$f":"B23+B31+B38","v":{"v":765672,"d":"765,672 kr"}},null,null,{"$f":"E23+E31+E38","v":{"v":525672,"d":"525,672 kr"}},{"$f":"F23+F31+F38","v":{"v":2026872,"d":"2,026,872 kr"}}]
[]
["Minskade kostnader genom  gemensam terminologi - Inera","Trolig","Källa ","Säkerhet","Min","Max",null,null,2021,2022,2023,2024,2025,2026,"Summa trolig","Summa min","Summa max"]
["Antal medarbetare på Inera",300,"Inera","Mycket säker",{"v":300,"d":"300 kr"},{"v":300,"d":"300 kr"},null,"Trolig",{"$nulls":3},{"$f":"$B$47","v":{"v":149100,"d":"149,100 kr"}},{"v":149100,"d":"149,100 kr"},{"v":149100,"d":"149,100 kr"},{"$f":"SUM(I42:N42)","v":{"v":447300,"d":"447,300 kr"}},{"$f":"SUM(I43:N43)","v":{"v":447300,"d":"447,300 kr"}},{"$f":"SUM(I44:N44)","v":{"v":447300,"d":"447,300 kr"}}]
["Antal timmar arbetstiden minskar med per år",{"v":1,"d":"1 "},"Scanias beräkningar","Ganska säker",{"v":1,"d":"1 kr"},{"v":1,"d":"1 kr"},null,"Min",{"$nulls":3},{"$f":"$E$47","v":{"v":149100,"d":"149,100 kr"}},{"v":149100,"d":"149,100 kr"},{"v":149100,"d":"149,100 kr"}]
["Frigjord arbetstid per år (timmar)",{"$f":"B43*B42","v":{"v":300,"d":"300 "}},"Scanias beräkningar","Ganska säker",{"$f":"E43*E42","v":{"v":300,"d":"300 kr"}},{"$f":"F43*F42","v":{"v":300,"d":"300 kr"}},null,"Max",{"$nulls":3},{"$f":"$F$47","v":{"v":149100,"d":"149,100 kr"}},{"v":149100,"d":"149,100 kr"},{"v":149100,"d":"149,100 kr"}]
["Frigjord arbetstid omräknad i heltidstjänster",{"$f":"B44/2016","v":{"v":0.1488095238095238,"d":"0.15 "}},"Scanias beräkningar","Ganska säker",{"$f":"E44/2016","v":{"v":0.1488095238095238,"d":"0 kr"}},{"$f":"F44/2016","v":{"v":0.1488095238095238,"d":"0 kr"}}]
["Värdering frigjord tid per timme - vi antar att varje insparad timme kan användas för att minska köpet av konsulttimmar, systemutvecklare KN 1, 497 kr/timme",{"v":497,"d":"497 kr"},"Ineras värdering","Ganska säker",{"v":497,"d":"497 kr"},{"v":497,"d":"497 kr"}]
["Minskade kostnader per år",{"$f":"B46*B44","v":{"v":149100,"d":"149,100 kr"}},null,null,{"$f":"E46*E44","v":{"v":149100,"d":"149,100 kr"}},{"$f":"F46*F44","v":{"v":149100,"d":"149,100 kr"}}]
[]
[]
[]
["Minskade kostnader genom gemensam terminologi - Regioner","Trolig","Källa ","Säkerhet","Min","Max",null,null,2021,2022,2023,2024,2025,2026,"Summa trolig","Summa min","Summa max"]
["Antal anställda i regioner (handläggare, administratörer, administratörer vård)",{"$f":"15000+8000+13000","v":{"v":36000,"d":"36,000 "}},"SKR","Mycket säker",{"$f":"15000+8000+13000","v":{"v":36000,"d":"36,000 "}},{"$f":"15000+8000+13000","v":{"v":36000,"d":"36,000 "}},null,"Trolig",{"$nulls":3},{"$f":"$B$57","v":{"v":10656000,"d":"10,656,000 kr"}},{"v":10656000,"d":"10,656,000 kr"},{"v":10656000,"d":"10,656,000 kr"},{"$f":"SUM(I52:N52)","v":{"v":31968000,"d":"31,968,000 kr"}},{"$f":"SUM(I53:N53)","v":{"v":31968000,"d":"31,968,000 kr"}},{"$f":"SUM(I54:N54)","v":{"v":31968000,"d":"31,968,000 kr"}}]
["Antal timmar arbetstiden minskar med per år",{"v":1,"d":"1 "},"Scanias beräkningar","Ganska säker",{"v":1,"d":"1 "},{"v":1,"d":"1 "},null,"Min",{"$nulls":3},{"$f":"$E$57","v":{"v":10656000,"d":"10,656,000 kr"}},{"v":10656000,"d":"10,656,000 kr"},{"v":10656000,"d":"10,656,000 kr"}]
["Frigjord arbetstid per år (timmar)",{"$f":"B53*B52","v":{"v":36000,"d":"36,000 "}},"Scanias beräkningar","Ganska säker",{"$f":"E53*E52","v":{"v":36000,"d":"36,000 "}},{"$f":"F53*F52","v":{"v":36000,"d":"36,000 "}},null,"Max",{"$nulls":3},{"$f":"$F$57","v":{"v":10656000,"d":"10,656,000 kr"}},{"v":10656000,"d":"10,656,000 kr"},{"v":10656000,"d":"10,656,000 kr"}]
["Frigjord arbetstid omräknad i heltidstjänster",{"$f":"B54/2016","v":{"v":17.857142857142858,"d":"18 "}},"Scanias beräkningar","Ganska säker",{"$f":"E54/2016","v":{"v":17.857142857142858,"d":"18 "}},{"$f":"F54/2016","v":{"v":17.857142857142858,"d":"18 "}}]
["Värdering av frigjord tid per timme - antagande  att den frigjorda tiden används för att minskad stress och därmed sjukskrivningar (den kan exempelvis användas för att ge en friskvårdstimme per administrationsanställd i regionerna). Antagande att varje insparad timme kan minska sjukskrivningarna med en timme per anställd - 296 kr (källa Försäkringskassan)",{"v":296,"d":"296 kr"},"Ineras värdering, med underlag från Försäkringskassan","Ganska säker",{"v":296,"d":"296 kr"},{"v":296,"d":"296 kr"}]
["Minskade kostnader per år",{"$f":"B56*B54","v":{"v":10656000,"d":"10,656,000 kr"}},null,null,{"$f":"E56*E54","v":{"v":10656000,"d":"10,656,000 kr"}},{"$f":"F56*F54","v":{"v":10656000,"d":"10,656,000 kr"}}]
[]
[]
[]
["Minskade kostnader för drift och förvaltning av fristående kataloger","Trolig","Källa ","Säkerhet","Min","Max",null,null,2021,2022,2023,2024,2025,2026,"Summa trolig","Summa min","Summa max"]
["Applikationsförvaltning Hitta och jämför vård per år (2021)",{"v":5490000,"d":"5,490,000 kr"},"Gustaf Rosander","Mycket säker",{"v":5490000,"d":"5,490,000 kr"},{"v":5490000,"d":"5,490,000 kr"},null,"Trolig",null,null,{"$f":"$B$66","v":{"v":5576000,"d":"5,576,000 kr"}},{"$f":"$B$66","v":{"v":5576000,"d":"5,576,000 kr"}},{"$f":"$B$66","v":{"v":5576000,"d":"5,576,000 kr"}},{"$f":"$B$66","v":{"v":5576000,"d":"5,576,000 kr"}},{"$f":"SUM(I62:N62)","v":{"v":22304000,"d":"22,304,000 kr"}},{"$f":"SUM(I63:N63)","v":{"v":22304000,"d":"22,304,000 kr"}},{"$f":"SUM(I64:N64)","v":{"v":27304000,"d":"27,304,000 kr"}}]
["Drift Hitta och jämför vård och KKA per år",{"v":1162000,"d":"1,162,000 kr"},"Gustaf Rosander","Mycket säker",{"v":1162000,"d":"1,162,000 kr"},{"v":1162000,"d":"1,162,000 kr"},null,"Min",null,null,{"$f":"$E$66","v":{"v":5576000,"d":"5,576,000 kr"}},{"$f":"$E$66","v":{"v":5576000,"d":"5,576,000 kr"}},{"$f":"$E$66","v":{"v":5576000,"d":"5,576,000 kr"}},{"$f":"$E$66","v":{"v":5576000,"d":"5,576,000 kr"}}]
["Förvaltningskostnader RGS (enl RGS-utredningens alternativ 3, katalog antas vara 25%)",{"v":4500000,"d":"4,500,000 kr"},"Elisabeth Kvilen Eriksson, Marie Frosteman","Osäker",{"v":4500000,"d":"4,500,000 kr"},{"v":7000000,"d":"7,000,000 kr"},null,"Max",null,null,{"$f":"$F$66","v":{"v":6826000,"d":"6,826,000 kr"}},{"$f":"$F$66","v":{"v":6826000,"d":"6,826,000 kr"}},{"$f":"$F$66","v":{"v":6826000,"d":"6,826,000 kr"}},{"$f":"$F$66","v":{"v":6826000,"d":"6,826,000 kr"}}]
["Förväntade kostnader för drift och förvaltning för HJV och RGS med ny plattform (förväntas halveras jmf med idag)",{"$f":"SUM(B62:B64)/2","v":{"v":5576000,"d":"5,576,000 kr"}},"Ineras antagande","Ganska säker",{"$f":"SUM(E62:E64)/2","v":{"v":5576000,"d":"5,576,000 kr"}},{"$f":"SUM(F62:F64)/2","v":{"v":6826000,"d":"6,826,000 kr"}}]
["Minskade kostnader per år",{"$f":"SUM(B62:B64)-B65","v":{"v":5576000,"d":"5,576,000 kr"}},null,null,{"$f":"SUM(E62:E64)-E65","v":{"v":5576000,"d":"5,576,000 kr"}},{"$f":"SUM(F62:F64)-F65","v":{"v":6826000,"d":"6,826,000 kr"}}]
[]
[null,{"$f":"SUM(B62:B64)","v":{"v":11152000,"d":"11,152,000 kr"}}]
[]
[]
[]
["Kommande nationella tjänster behöver inte utveckla egna kataloger","Trolig","Källa ","Säkerhet","Min","Max",null,null,2021,2022,2023,2024,2025,2026,"Summa trolig","Summa min","Summa max"]
["SDK kostnader utveckling av adressbok (25 % av SDKs totala kostnader)",{"v":9000000,"d":"9,000,000 kr"},"Arvid Thunholm","Mycket säker",{"v":9000000,"d":"9,000,000 kr"},{"v":9000000,"d":"9,000,000 kr"}]
["Kostnad om kommande tjänster nyttjar ny plattform (förväntas halveras)",{"$f":"0.5*(B73)","v":{"v":4500000,"d":"4,500,000 kr"}},"Ineras antagande","Ganska säker",{"$f":"0.75*(E73)","v":{"v":6750000,"d":"6,750,000 kr"}},{"$f":"0.25*(F73)","v":{"v":2250000,"d":"2,250,000 kr"}},null,"Trolig",{"$nulls":3},{"$f":"$B$77/3","v":{"v":7500000,"d":"7,500,000 kr"}},{"$f":"$B$77/3","v":{"v":7500000,"d":"7,500,000 kr"}},{"$f":"$B$77/3","v":{"v":7500000,"d":"7,500,000 kr"}},{"$f":"SUM(I74:N74)","v":{"v":22500000,"d":"22,500,000 kr"}},{"$f":"SUM(I75:N75)","v":{"v":11250000,"d":"11,250,000 kr"}},{"$f":"SUM(I76:N76)","v":{"v":33750000,"d":"33,750,000 kr"}}]
["Kostnader som unviks per tjänst som nyttjar ny plattform",{"$f":"B73-B74","v":{"v":4500000,"d":"4,500,000 kr"}},"Ineras antagande","Ganska säker",{"$f":"E73-E74","v":{"v":2250000,"d":"2,250,000 kr"}},{"$f":"F73-F74","v":{"v":6750000,"d":"6,750,000 kr"}},null,"Min",{"$nulls":3},{"$f":"$E$77/3","v":{"v":3750000,"d":"3,750,000 kr"}},{"$f":"$E$77/3","v":{"v":3750000,"d":"3,750,000 kr"}},{"$f":"$E$77/3","v":{"v":3750000,"d":"3,750,000 kr"}}]
["Antal nya tjänster som kommer ha grunddata och katalog inom 5 år",{"v":5,"d":"5 "},"Ineras antagande","Ganska säker",{"v":5,"d":"5 "},{"v":5,"d":"5 "},null,"Max",{"$nulls":3},{"$f":"$F$77/3","v":{"v":11250000,"d":"11,250,000 kr"}},{"$f":"$F$77/3","v":{"v":11250000,"d":"11,250,000 kr"}},{"$f":"$F$77/3","v":{"v":11250000,"d":"11,250,000 kr"}}]
["Minskade kostnader inom 5 år",{"$f":"B76*B75","v":{"v":22500000,"d":"22,500,000 kr"}},null,null,{"$f":"E76*E75","v":{"v":11250000,"d":"11,250,000 kr"}},{"$f":"F76*F75","v":{"v":33750000,"d":"33,750,000 kr"}}]
[]
[null,{"$f":"B76*B73","v":45000000}]
[null,{"$f":"B76*B75","v":22500000}]
[null,{"$f":"B79-B80","v":22500000}]
[]
[]
["Kommande nationella tjänster behöver inte förvalta egna kataloger","Trolig","Källa ","Säkerhet","Min","Max",null,null,2021,2022,2023,2024,2025,2026,"Summa trolig","Summa min","Summa max"]
["SDK kostnader förvaltning av adressbok (25 % av SDKs totala kostnader)",{"v":2500000,"d":"2,500,000 kr"},"Arvid Thunholm","Mycket säker",{"v":2500000,"d":"2,500,000 kr"},{"v":2500000,"d":"2,500,000 kr"},null,"Trolig",{"$nulls":4},{"$f":"$B$89/2","v":{"v":3125000,"d":"3,125,000 kr"}},{"$f":"$B$89/2","v":{"v":3125000,"d":"3,125,000 kr"}},{"$f":"SUM(I85:N85)","v":{"v":6250000,"d":"6,250,000 kr"}},{"$f":"SUM(I86:N86)","v":{"v":3125000,"d":"3,125,000 kr"}},{"$f":"SUM(I87:N87)","v":{"v":9375000,"d":"9,375,000 kr"}}]
["Kostnad om kommande tjänster nyttjar ny plattform (förväntas halveras)",{"$f":"B85/2","v":{"v":1250000,"d":"1,250,000 kr"}},"Ineras antagande","Ganska säker",{"$f":"0.75*E85","v":{"v":1875000,"d":"1,875,000 kr"}},{"$f":"0.25*F85","v":{"v":625000,"d":"625,000 kr"}},null,"Min",{"$nulls":4},{"$f":"$E$89/2","v":{"v":1562500,"d":"1,562,500 kr"}},{"$f":"$E$89/2","v":{"v":1562500,"d":"1,562,500 kr"}}]
["Kostnader som unviks per tjänst som nyttjar ny plattform",{"$f":"B85-B86","v":{"v":1250000,"d":"1,250,000 kr"}},"Ineras antagande","Ganska säker",{"$f":"E85-E86","v":{"v":625000,"d":"625,000 kr"}},{"$f":"F85-F86","v":{"v":1875000,"d":"1,875,000 kr"}},null,"Max",{"$nulls":4},{"$f":"$F$89/2","v":{"v":4687500,"d":"4,687,500 kr"}},{"$f":"$F$89/2","v":{"v":4687500,"d":"4,687,500 kr"}}]
["Antal nya tjänster som kommer ha grunddata och katalog inom 5 år",{"v":5,"d":"5 "},"Ineras antagande","Ganska säker",{"v":5,"d":"5 kr"},{"v":5,"d":"5 kr"}]
["Minskade kostnader inom 5 år",{"$f":"B88*B87","v":{"v":6250000,"d":"6,250,000 kr"}},null,null,{"$f":"E88*E87","v":{"v":3125000,"d":"3,125,000 kr"}},{"$f":"F88*F87","v":{"v":9375000,"d":"9,375,000 kr"}}]
{"$rows_empty":7}
["Kommande konsumenter behöver inte utveckla anslutningar till andra informationsmängder","Trolig","Källa ","Säkerhet","Min","Max",null,null,2021,2022,2023,2024,2025,2026,"Summa trolig","Summa min","Summa max"]
["Kostnad för att utveckla anslutningar till andra informationsmängder",{"v":1000000,"d":"1,000,000 kr"},"Sara Meunier / Cosmic Kundgrupp","Ganska säker",{"v":750000,"d":"750,000 kr"},{"v":1000000,"d":"1,000,000 kr"},null,"Trolig",null,null,{"$f":"B100","v":{"v":1000000,"d":"1,000,000 kr"}},{"$f":"B100","v":{"v":1000000,"d":"1,000,000 kr"}},{"$f":"B100","v":{"v":1000000,"d":"1,000,000 kr"}},{"$f":"B100","v":{"v":1000000,"d":"1,000,000 kr"}},{"$f":"SUM(I98:N98)","v":{"v":4000000,"d":"4,000,000 kr"}},{"$f":"SUM(I99:N99)","v":{"v":3000000,"d":"3,000,000 kr"}},{"$f":"SUM(I100:N100)","v":{"v":4000000,"d":"4,000,000 kr"}}]
["Kommande konsumenter som kan undvika kostnaden, per år",1,"Ineras antagande","Ganska säker",{"v":1,"d":"1 kr"},{"v":1,"d":"1 kr"},null,"Min",null,null,{"$f":"$E$100","v":{"v":750000,"d":"750,000 kr"}},{"$f":"$E$100","v":{"v":750000,"d":"750,000 kr"}},{"$f":"$E$100","v":{"v":750000,"d":"750,000 kr"}},{"$f":"$E$100","v":{"v":750000,"d":"750,000 kr"}}]
["Minskade kostnader per år",{"$f":"B99*B98","v":{"v":1000000,"d":"1,000,000 kr"}},null,null,{"$f":"E99*E98","v":{"v":750000,"d":"750,000 kr"}},{"$f":"F99*F98","v":{"v":1000000,"d":"1,000,000 kr"}},null,"Max",null,null,{"$f":"$F$100","v":{"v":1000000,"d":"1,000,000 kr"}},{"$f":"$F$100","v":{"v":1000000,"d":"1,000,000 kr"}},{"$f":"$F$100","v":{"v":1000000,"d":"1,000,000 kr"}},{"$f":"$F$100","v":{"v":1000000,"d":"1,000,000 kr"}}]
{"$rows_empty":7}
["Minskade utvecklingskostnader för Ineras befintliga tjänster","Trolig","Källa ","Säkerhet","Min","Max",null,null,2021,2022,2023,2024,2025,2026,"Summa trolig","Summa min","Summa max"]
["Kostnad för att utveckla en ny funktion för enskilda tjänster",{"v":1000000,"d":"1,000,000 kr"},"Ineras uppskattning","Ganska säker",{"v":1000000,"d":"1,000,000 kr"},{"v":1000000,"d":"1,000,000 kr"},null,"Trolig",null,null,{"$f":"$B$114/4","v":{"v":2000000,"d":"2,000,000 kr"}},{"$f":"$B$114/4","v":{"v":2000000,"d":"2,000,000 kr"}},{"v":2000000,"d":"2,000,000 kr"},{"v":2000000,"d":"2,000,000 kr"},{"$f":"SUM(I109:N109)","v":{"v":8000000,"d":"8,000,000 kr"}},{"$f":"SUM(I110:N110)","v":{"v":6000000,"d":"6,000,000 kr"}},{"$f":"SUM(I111:N111)","v":{"v":9000000,"d":"9,000,000 kr"}}]
["Kostnad för att utveckla om tjänsterna kunde nyttja ny teknisk plattform",{"v":200000,"d":"200,000 kr"},"Ineras uppskattning","Ganska säker",{"v":400000,"d":"400,000 kr"},{"v":100000,"d":"100,000 kr"},null,"Min",null,null,{"$f":"$E$114/4","v":{"v":1500000,"d":"1,500,000 kr"}},{"$f":"$E$114/4","v":{"v":1500000,"d":"1,500,000 kr"}},{"v":1500000,"d":"1,500,000 kr"},{"v":1500000,"d":"1,500,000 kr"}]
["Kostnad som undviks per nyutvecklad funktion",{"$f":"B109-B110","v":{"v":800000,"d":"800,000 kr"}},"Ineras uppskattning","Ganska säker",{"$f":"E109-E110","v":{"v":600000,"d":"600,000 kr"}},{"$f":"F109-F110","v":{"v":900000,"d":"900,000 kr"}},null,"Max",null,null,{"$f":"$F$114/4","v":{"v":2250000,"d":"2,250,000 kr"}},{"$f":"$F$114/4","v":{"v":2250000,"d":"2,250,000 kr"}},{"v":2250000,"d":"2,250,000 kr"},{"v":2250000,"d":"2,250,000 kr"}]
["Antal tjänster som utvecklar nya funktioner inom 5 år",5,"Ineras uppskattning","Ganska säker",{"v":5,"d":"5 "},{"v":5,"d":"5 "}]
["Antal funktioner som varje tjänst utvecklar",2,"Ineras uppskattning","Ganska säker",{"v":2,"d":"2 "},{"v":2,"d":"2 "}]
["Minskade kostnader under fem år",{"$f":"B113*B112*B111","v":{"v":8000000,"d":"8,000,000 kr"}},null,null,{"$f":"E113*E112*E111","v":{"v":6000000,"d":"6,000,000 kr"}},{"$f":"F113*F112*F111","v":{"v":9000000,"d":"9,000,000 kr"}}]
[]
[]
[]
[]
[]
["Minskad tid på administration för producenter av information (genom bättre admingränssnitt)","Trolig","Källa ","Säkerhet","Min","Max",null,null,2021,2022,2023,2024,2025,2026,"Summa trolig","Summa min","Summa max"]
["Antal administratörer i nationella HSA idag",{"v":2236,"d":"2,236 "},"HSA","Mycket säker",{"v":2236,"d":"2,236 "},{"v":2236,"d":"2,236 "},null,"Trolig",null,null,{"$f":"$B$132","v":{"v":15816346,"d":"15,816,346 kr"}},{"$f":"$B$132","v":{"v":15816346,"d":"15,816,346 kr"}},{"$f":"$B$132","v":{"v":15816346,"d":"15,816,346 kr"}},{"$f":"$B$132","v":{"v":15816346,"d":"15,816,346 kr"}},{"$f":"SUM(I121:N121)","v":{"v":63265384,"d":"63,265,384 kr"}},{"$f":"SUM(I122:N122)","v":{"v":21018400,"d":"21,018,400 kr"}},{"$f":"SUM(I123:N123)","v":{"v":63265384,"d":"63,265,384 kr"}}]
["Timmar de lägger på administration i veckan i snitt",{"v":2,"d":"2 "},"Ineras uppskattning","Ganska säker",{"v":2,"d":"2 "},{"v":2,"d":"2 "},null,"Min",null,null,{"$f":"$E$132","v":{"v":5254600,"d":"5,254,600 kr"}},{"$f":"$E$132","v":{"v":5254600,"d":"5,254,600 kr"}},{"$f":"$E$132","v":{"v":5254600,"d":"5,254,600 kr"}},{"$f":"$E$132","v":{"v":5254600,"d":"5,254,600 kr"}}]
["Minskning av tiden som nytt administrationsgränssnitt medför",{"v":0.25,"d":"0.25 "},"Ineras uppskattning","Ganska säker",{"v":0.25,"d":"0 "},{"v":0.25,"d":"0 "},null,"Max",null,null,{"$f":"$F$132","v":{"v":15816346,"d":"15,816,346 kr"}},{"$f":"$F$132","v":{"v":15816346,"d":"15,816,346 kr"}},{"$f":"$F$132","v":{"v":15816346,"d":"15,816,346 kr"}},{"$f":"$F$132","v":{"v":15816346,"d":"15,816,346 kr"}}]
["Sparad tid per vecka (minuter)",{"v":30,"d":"30 "},"Ineras uppskattning","Ganska säker",{"v":30,"d":"30 "},{"v":30,"d":"30 "}]
["Antal arbetsveckor per år (exklusive semester 5 veckor)",{"v":47,"d":"47 "},"Ineras uppskattning","Mycket säker",{"v":47,"d":"47 "},{"v":47,"d":"47 "}]
["Sparad tid per år (minuter)",{"$f":"B125*B124","v":{"v":1410,"d":"1,410 "}},"Ineras uppskattning","Ganska säker",{"$f":"E125*E124","v":{"v":1410,"d":"1,410 "}},{"$f":"F125*F124","v":{"v":1410,"d":"1,410 "}}]
["Sparad tid per år (timmar)",{"$f":"B126/60","v":{"v":23.5,"d":"24 "}},"Ineras uppskattning","Ganska säker",{"$f":"E126/60","v":{"v":23.5,"d":"24 "}},{"$f":"F126/60","v":{"v":23.5,"d":"24 "}}]
["Sparad tid för alla administratörer sammanlagt per år (timmar)",{"$f":"B127*B121","v":{"v":52546,"d":"52,546 "}},"Ineras uppskattning","Ganska säker",{"$f":"E127*E121","v":{"v":52546,"d":"52,546 "}},{"$f":"F127*F121","v":{"v":52546,"d":"52,546 "}}]
["Antal heltidstjänster per år",{"$f":"B128/2016","v":{"v":26.064484126984127,"d":"26 "}},"Ineras uppskattning","Ganska säker",{"$f":"E128/2016","v":{"v":26.064484126984127,"d":"26 "}},{"$f":"F128/2016","v":{"v":26.064484126984127,"d":"26 "}}]
["Värdering av frigjord tid per timme - antagande att regionen kan minska timmar från timanställda med lika många timmar som frigörs från katalogen, timpris värderas till 301 kr (baserad på ssk-lön inkl arbetsgivaravgifter)",{"v":301,"d":"301 kr"},"Ineras värdering","Osäker",{"v":100,"d":"100 kr"},{"v":301,"d":"301 kr"}]
["Värdet av frigjord arbetstid per år",{"$f":"B130*B128","v":{"v":15816346,"d":"15,816,346 kr"}},"Ineras uppskattning","Osäker",{"$f":"E130*E128","v":{"v":5254600,"d":"5,254,600 kr"}},{"$f":"F130*F128","v":{"v":15816346,"d":"15,816,346 kr"}}]
["Minskade kostnader per år",{"$f":"B131","v":{"v":15816346,"d":"15,816,346 kr"}},null,null,{"$f":"E131","v":{"v":5254600,"d":"5,254,600 kr"}},{"$f":"F131","v":{"v":15816346,"d":"15,816,346 kr"}}]
[]
["Kommuner undviker kostnader för utveckling av separata kataloger i olika tjänster","Trolig","Källa ","Säkerhet","Min","Max",null,null,2021,2022,2023,2024,2025,2026,"Summa trolig","Summa min","Summa max"]
["Kostnad att utveckla en nationell katalog",{"v":9000000,"d":"9,000,000 kr"},"Arvid Thunholm","Mycket säker",{"v":9000000,"d":"9,000,000 kr"},{"v":9000000,"d":"9,000,000 kr"},null,"Trolig",{"$nulls":3},{"$f":"$B$140/3","v":{"v":27000000,"d":"27,000,000 kr"}},{"$f":"$B$140/3","v":{"v":27000000,"d":"27,000,000 kr"}},{"v":27000000,"d":"27,000,000 kr"},{"$f":"SUM(I135:N135)","v":{"v":81000000,"d":"81,000,000 kr"}},{"$f":"SUM(I136:N136)","v":{"v":20250000,"d":"20,250,000 kr"}},{"$f":"SUM(I137:N137)","v":{"v":202500000,"d":"202,500,000 kr"}}]
["Uppskattad kostnad för att etablera en lokal katalog (ca hälftena av en nationell)",{"v":4500000,"d":"4,500,000 kr"},"Ineras uppskattning","Ganska säker",{"v":4500000,"d":"4,500,000 kr"},{"v":4500000,"d":"4,500,000 kr"},null,"Min",{"$nulls":3},{"$f":"$E$140/3","v":{"v":6750000,"d":"6,750,000 kr"}},{"$f":"$E$140/3","v":{"v":6750000,"d":"6,750,000 kr"}},{"v":6750000,"d":"6,750,000 kr"}]
["Antal kommuner som förväntas utveckla en lokal katalog för en tjänst om ny plattform inte genomförs",{"v":20,"d":"20 "},"Ineras antagande","Ganska säker",{"v":5,"d":"5 "},{"v":50,"d":"50 "},null,"Max",{"$nulls":3},{"$f":"$F$140/3","v":{"v":67500000,"d":"67,500,000 kr"}},{"$f":"$F$140/3","v":{"v":67500000,"d":"67,500,000 kr"}},{"v":67500000,"d":"67,500,000 kr"}]
["Kostnad för kommunerna om de utvecklar tjänsten och katalogen var och en för sig",{"$f":"B137*B136","v":{"v":90000000,"d":"90,000,000 kr"}},"Ineras antagande","Ganska säker",{"$f":"E137*E136","v":{"v":22500000,"d":"22,500,000 kr"}},{"$f":"F137*F136","v":{"v":225000000,"d":"225,000,000 kr"}}]
["Kostnad för kommunerna om de utvecklar med ny plattform (10 % av vad de skulle lägga annars)",{"$f":"0.1*B138","v":{"v":9000000,"d":"9,000,000 kr"}},"Ineras antagande","Ganska säker",{"$f":"0.1*E138","v":{"v":2250000,"d":"2,250,000 kr"}},{"$f":"0.1*F138","v":{"v":22500000,"d":"22,500,000 kr"}}]
["Minskade kostnader under 5 år",{"$f":"B138-B139","v":{"v":81000000,"d":"81,000,000 kr"}},null,null,{"$f":"E138-E139","v":{"v":20250000,"d":"20,250,000 kr"}},{"$f":"F138-F139","v":{"v":202500000,"d":"202,500,000 kr"}}]
[]
[]
[]
[]
[]
[]
["Minskade skadestånd eller viten enligt GDPR","Trolig","Källa ","Säkerhet","Min","Max",null,null,2021,2022,2023,2024,2025,2026,"Summa trolig","Summa min","Summa max"]
["Vite för vanliga förseelser mot GDPR för företag - 10 000 000 EUR eller 2 % av årsomsättning",{"v":100000000,"d":"100,000,000 kr"},"Manólis Nymark","Mycket säker",{"v":100000000,"d":"100,000,000 kr"},{"v":100000000,"d":"100,000,000 kr"},null,"Trolig",{"$nulls":3},{"v":200000,"d":"200,000 kr"},null,null,{"$f":"SUM(I148:N148)","v":{"v":200000,"d":"200,000 kr"}},{"$f":"SUM(I149:N149)","v":0},{"$f":"SUM(I150:N150)","v":{"v":10000000,"d":"10,000,000 kr"}}]
["Vite för grövre överträderlse mot GDPR för företag - 20 000 000 EUR eller 4 % av årsomsättning",{"v":210000000,"d":"210,000,000 kr"},"Manólis Nymark","Mycket säker",{"v":210000000,"d":"210,000,000 kr"},{"v":210000000,"d":"210,000,000 kr"},null,"Min",{"$nulls":3},{"$f":"E152","v":0}]
["Vite som kan påföras myndigheter - max",{"v":10000000,"d":"10,000,000 kr"},"Datainspektionen","Mycket säker",{"v":10000000,"d":"10,000,000 kr"},{"v":10000000,"d":"10,000,000 kr"},null,"Max",{"$nulls":3},{"$f":"F152","v":{"v":10000000,"d":"10,000,000 kr"}}]
["Vite som utfärdats i Sverige hittills (skola i Skellefteå 2019)",{"v":200000,"d":"200,000 kr"},"Computer Sweden","Mycket säker",{"v":200000,"d":"200,000 kr"},{"v":200000,"d":"200,000 kr"}]
["Vite som vi tror någon kund skulle undvika inom 6 år",{"$f":"B151","v":{"v":200000,"d":"200,000 kr"}},null,null,{"v":0,"d":"0 kr"},{"$f":"F150","v":{"v":10000000,"d":"10,000,000 kr"}}]
[]
[]
[]
[]
[]
[]
["Minskad tid på administration för producenter i Hitta och jämför vård",null,"Källa ","Säkerhet","Min","Max",null,null,2021,2022,2023,2024,2025,2026,"Summa trolig","Summa min","Summa max"]
["Tid för att administera i KKA per vecka och region",{"v":1.5,"d":"2 "},"Helena Olsson","Ganska säker",{"v":1.5,"d":"2 "},{"v":1.5,"d":"2 "},null,"Trolig",null,null,{"$f":"$B$166","v":{"v":242424,"d":"242,424 kr"}},{"$f":"$B$166","v":{"v":242424,"d":"242,424 kr"}},{"$f":"$B$166","v":{"v":242424,"d":"242,424 kr"}},{"$f":"$B$166","v":{"v":242424,"d":"242,424 kr"}},{"$f":"SUM(I160:N160)","v":{"v":969696,"d":"969,696 kr"}},{"$f":"SUM(I161:N161)","v":{"v":327600,"d":"327,600 kr"}},{"$f":"SUM(I162:N162)","v":{"v":969696,"d":"969,696 kr"}}]
["Timmar per vecka i KKA för alla regioner",{"$f":"B160*21","v":{"v":31.5,"d":"32 "}},"Helena Olsson","Ganska säker",{"$f":"E160*21","v":{"v":31.5,"d":"32 "}},{"$f":"F160*21","v":{"v":31.5,"d":"32 "}},null,"Min",null,null,{"$f":"$E$166","v":{"v":81900,"d":"81,900 kr"}},{"$f":"$E$166","v":{"v":81900,"d":"81,900 kr"}},{"$f":"$E$166","v":{"v":81900,"d":"81,900 kr"}},{"$f":"$E$166","v":{"v":81900,"d":"81,900 kr"}}]
["Timmar per år i KKA för alla regioner",{"$f":"B161*52","v":{"v":1638,"d":"1,638 "}},"Helena Olsson","Ganska säker",{"$f":"E161*52","v":{"v":1638,"d":"1,638 "}},{"$f":"F161*52","v":{"v":1638,"d":"1,638 "}},null,"Max",null,null,{"$f":"$F$166","v":{"v":242424,"d":"242,424 kr"}},{"$f":"$F$166","v":{"v":242424,"d":"242,424 kr"}},{"$f":"$F$166","v":{"v":242424,"d":"242,424 kr"}},{"$f":"$F$166","v":{"v":242424,"d":"242,424 kr"}}]
["Timmar som förväntas undvikas om HJV nyttjar ny plattform (hälften av dagens timmar)",{"$f":"B162/2","v":{"v":819,"d":"819 "}},"Ineras antagande","Ganska säker",{"$f":"E162/2","v":{"v":819,"d":"819 "}},{"$f":"F162/2","v":{"v":819,"d":"819 "}}]
["Heltidstjänster som förväntas undvikas om HJV nyttjar ny plattform",{"$f":"B163/2016","v":{"v":0.40625,"d":"0.4 "}},"Ineras antagande","Ganska säker",{"$f":"E162/2016","v":{"v":0.8125,"d":"0.8 "}},{"$f":"F162/2016","v":{"v":0.8125,"d":"0.8 "}}]
["Värdering av frigjord tid per timme - antagande  att den frigjorda tiden används för att minskad stress och därmed sjukskrivningar (den kan exempelvis användas för att ge en friskvårdstimme per administrationsanställd i regionerna). Antagande att varje insparad timme kan minska kostnaderna för sjukskrivningar med en timme (värdering Försäkringskassan).",{"v":296,"d":"296 kr"},"Ineras värdering","Ganska säker",{"v":100,"d":"100 kr"},{"v":296,"d":"296 kr"}]
["Minskade kostnader per år",{"$f":"B165*B163","v":{"v":242424,"d":"242,424 kr"}},null,null,{"$f":"E165*E163","v":{"v":81900,"d":"81,900 kr"}},{"$f":"F165*F163","v":{"v":242424,"d":"242,424 kr"}}]
{"$rows_empty":7}
["Minskad tid på administration för producenter i RGS Katalog",null,"Källa ","Säkerhet","Min","Max",null,null,2021,2022,2023,2024,2025,2026,"Summa trolig","Summa min","Summa max"]
["Tid för att administrera i RGS katalog per år och region - ca 8 timmar /vecka",{"$f":"8*52","v":{"v":416,"d":"416 "}},"Eva-Marie Söberg","Ganska säker",{"$f":"8*52","v":{"v":416,"d":"416 kr"}},{"$f":"8*52","v":{"v":416,"d":"416 kr"}},null,"Trolig",null,null,{"$f":"$B$179","v":{"v":2629536,"d":"2,629,536 kr"}},{"$f":"$B$179","v":{"v":2629536,"d":"2,629,536 kr"}},{"v":2629536,"d":"2,629,536 kr"},{"v":2629536,"d":"2,629,536 kr"},{"$f":"SUM(I175:N175)","v":{"v":10518144,"d":"10,518,144 kr"}},{"$f":"SUM(I176:N176)","v":{"v":8414515.200000001,"d":"8,414,515 kr"}},{"$f":"SUM(I177:N177)","v":{"v":12621772.799999999,"d":"12,621,773 kr"}}]
["Timmar per år i RGS katalog för alla regioner",{"$f":"B175*21","v":{"v":8736,"d":"8,736 "}},"Eva-Marie Söberg","Ganska säker",{"$f":"E175*21","v":{"v":8736,"d":"8,736 kr"}},{"$f":"F175*21","v":{"v":8736,"d":"8,736 kr"}},null,"Min",null,null,{"$f":"$E$179","v":{"v":2103628.8000000003,"d":"2,103,629 kr"}},{"$f":"$E$179","v":{"v":2103628.8000000003,"d":"2,103,629 kr"}},{"v":2103628.8000000003,"d":"2,103,629 kr"},{"v":2103628.8000000003,"d":"2,103,629 kr"}]
["Antal heltidstjänster i RGS katalog per år",{"$f":"B176/2016","v":{"v":4.333333333333333,"d":"4.3 "}},"Eva-Marie Söberg","Ganska säker",{"$f":"E176/2016","v":{"v":4.333333333333333,"d":"4 kr"}},{"$f":"F176/2016","v":{"v":4.333333333333333,"d":"4 kr"}},null,"Max",null,null,{"$f":"$F$179","v":{"v":3155443.1999999997,"d":"3,155,443 kr"}},{"$f":"$F$179","v":{"v":3155443.1999999997,"d":"3,155,443 kr"}},{"v":3155443.1999999997,"d":"3,155,443 kr"},{"v":3155443.1999999997,"d":"3,155,443 kr"}]
["Värdering av frigjord tid per timme - antagande att regionen kan minska timmar från timanställda med lika många timmar som frigörs från katalogen, timpris baseras på sjuksköterskelön inkl arbetsgivaravgifter och värderas till 310 kr. ",{"v":301,"d":"301 kr"},"Ineras värdering","Ganska säker",{"$f":"B178*(0.8)","v":{"v":240.8,"d":"241 kr"}},{"$f":"B178*1.2","v":{"v":361.2,"d":"361 kr"}}]
["Minskade kostnader per år",{"$f":"B178*B176","v":{"v":2629536,"d":"2,629,536 kr"}},null,null,{"$f":"E178*E176","v":{"v":2103628.8000000003,"d":"2,103,629 kr"}},{"$f":"F178*F176","v":{"v":3155443.1999999997,"d":"3,155,443 kr"}}]

{"sheet":"Nyttor","index":2,"n_rows":28,"n_cols":19,"rows_kept":28,"merged":[[3,5,3,10],[3,12,3,13]]}
[null,"Nyttor"]
[null,{"$f":"IF(Grunddata!B6=0,\"\",Grunddata!B6)","v":"Katalog 2025"}]
[]
[null,null,"Välj finansiell nytta, en omfördelningsnytta, eller kvalitativ, mätbar. ","Ange ett kortfattat men beskrivande namn på nyttan, exempelvis \"minskad restid\",  \"reducerad personalkostnad\", \"reducerade kvalitetsbristkostnader,\" \"ökade intäkter,\" etc. ","Ange för vilken intressent nyttan uppstår. Faller nyttan hos flera aktörer får detta anges i en ny rad per intressent","För finansiella nyttor och omfördelningsnyttor, ange det uppskattade värdet per år under realiseringsperioden. Observera att nyttor som kategoriserats som kvalitetsnyttor inte värderas här.  ",{"$nulls":6},"Om möjligt estimera ett min- och ett max värde."]
[{"$nulls":5},{"$f":"Startår","v":2021},{"$f":"F5+1","v":2022},{"$f":"G5+1","v":2023},2024,2025,2026]
[null,"ID","Nyttokategori","Nyttans namn","Intressent ","år 1","år 2","år 3","år 4","år 5","år 6","Summa","Min","Max","Vägt medel","Osäkerhet","Andel av nyttan","Kolumn1","Kolumn2"]
[null,11,"1. Finansiell",{"$f":"'Beräkningar nyttor'!A134","v":"Kommuner undviker kostnader för utveckling av separata kataloger i olika tjänster"},"Kommuner",{"$f":"'Beräkningar nyttor'!I135","v":0},{"$f":"'Beräkningar nyttor'!J135","v":0},{"$f":"'Beräkningar nyttor'!K135","v":0},{"$f":"'Beräkningar nyttor'!L135","v":{"v":27000000,"d":"27,000,000 "}},{"$f":"'Beräkningar nyttor'!M135","v":{"v":27000000,"d":"27,000,000 "}},{"$f":"'Beräkningar nyttor'!N135","v":{"v":27000000,"d":"27,000,000 "}},{"$f":"SUM(F7:K7)","v":{"v":81000000,"d":"81,000,000 "}},{"$f":"'Beräkningar nyttor'!P135","v":{"v":20250000,"d":"20,250,000 "}},{"$f":"'Beräkningar nyttor'!Q135","v":{"v":202500000,"d":"202,500,000 "}},{"$f":"IF(OR(ISBLANK(N7),ISBLANK(M7),ISBLANK(L7)),\"\",(N7+M7+3*L7)/5)","v":{"v":93150000,"d":"93,150,000 "}},{"$f":"IF(OR(ISBLANK(L7),L7=0),\"\",(N7-M7)/5/L7)","v":{"v":0.45,"d":"45%"}},{"$f":"Tabell10[[#This Row],[Summa]]/SUM(L7:L15)","v":{"v":0.546455824250308,"d":"55%"}},{"$f":"Tabell10[[#This Row],[Summa]]/6","v":{"v":13500000,"d":"13,500,000 "}}]
[null,6,"1. Finansiell",{"$f":"'Beräkningar nyttor'!A72","v":"Kommande nationella tjänster behöver inte utveckla egna kataloger"},"Inera",{"$f":"'Beräkningar nyttor'!I74","v":0},{"$f":"'Beräkningar nyttor'!J74","v":0},{"$f":"'Beräkningar nyttor'!K74","v":0},{"$f":"'Beräkningar nyttor'!L74","v":{"v":7500000,"d":"7,500,000 "}},{"$f":"'Beräkningar nyttor'!M74","v":{"v":7500000,"d":"7,500,000 "}},{"$f":"'Beräkningar nyttor'!N74","v":{"v":7500000,"d":"7,500,000 "}},{"v":22500000,"d":"22,500,000 "},{"$f":"'Beräkningar nyttor'!P74","v":{"v":11250000,"d":"11,250,000 "}},{"$f":"'Beräkningar nyttor'!Q74","v":{"v":33750000,"d":"33,750,000 "}},{"v":22500000,"d":"22,500,000 "},{"v":0.2,"d":"20%"},{"$f":"Tabell10[[#This Row],[Summa]]/SUM(L7:L15)","v":{"v":0.15179328451397445,"d":"15%"}},{"$f":"Tabell10[[#This Row],[Summa]]/6","v":{"v":3750000,"d":"3,750,000 "}}]
[null,5,"1. Finansiell",{"$f":"'Beräkningar nyttor'!A61","v":"Minskade kostnader för drift och förvaltning av fristående kataloger"},"Inera",{"$f":"'Beräkningar nyttor'!I62","v":0},{"$f":"'Beräkningar nyttor'!J62","v":0},{"$f":"'Beräkningar nyttor'!K62","v":{"v":5576000,"d":"5,576,000 "}},{"$f":"'Beräkningar nyttor'!L62","v":{"v":5576000,"d":"5,576,000 "}},{"$f":"'Beräkningar nyttor'!M62","v":{"v":5576000,"d":"5,576,000 "}},{"$f":"'Beräkningar nyttor'!N62","v":{"v":5576000,"d":"5,576,000 "}},{"v":22304000,"d":"22,304,000 "},{"$f":"'Beräkningar nyttor'!P62","v":{"v":22304000,"d":"22,304,000 "}},{"$f":"'Beräkningar nyttor'!Q62","v":{"v":27304000,"d":"27,304,000 "}},{"v":23304000,"d":"23,304,000 "},{"v":0.04483500717360115,"d":"4%"},{"$f":"Tabell10[[#This Row],[Summa]]/SUM(L7:L15)","v":{"v":0.1504709963466527,"d":"15%"}},{"$f":"Tabell10[[#This Row],[Summa]]/6","v":{"v":3717333.3333333335,"d":"3,717,333 "}}]
[null,9,"1. Finansiell",{"$f":"'Beräkningar nyttor'!A108","v":"Minskade utvecklingskostnader för Ineras befintliga tjänster"},"Inera",{"$f":"'Beräkningar nyttor'!I109","v":0},{"$f":"'Beräkningar nyttor'!J109","v":0},{"$f":"'Beräkningar nyttor'!K109","v":{"v":2000000,"d":"2,000,000 "}},{"$f":"'Beräkningar nyttor'!L109","v":{"v":2000000,"d":"2,000,000 "}},{"$f":"'Beräkningar nyttor'!M109","v":{"v":2000000,"d":"2,000,000 "}},{"$f":"'Beräkningar nyttor'!N109","v":{"v":2000000,"d":"2,000,000 "}},{"v":8000000,"d":"8,000,000 "},{"$f":"'Beräkningar nyttor'!P109","v":{"v":6000000,"d":"6,000,000 "}},{"$f":"'Beräkningar nyttor'!Q109","v":{"v":9000000,"d":"9,000,000 "}},{"v":7800000,"d":"7,800,000 "},{"v":0.075,"d":"8%"},{"$f":"Tabell10[[#This Row],[Summa]]/SUM(L7:L15)","v":{"v":0.05397094560496869,"d":"5%"}},{"$f":"Tabell10[[#This Row],[Summa]]/6","v":{"v":1333333.3333333333,"d":"1,333,333 "}}]
[null,7,"1. Finansiell",{"$f":"'Beräkningar nyttor'!A84","v":"Kommande nationella tjänster behöver inte förvalta egna kataloger"},"Inera",{"$f":"'Beräkningar nyttor'!I85","v":0},{"$f":"'Beräkningar nyttor'!J85","v":0},{"$f":"'Beräkningar nyttor'!K85","v":0},{"$f":"'Beräkningar nyttor'!L85","v":0},{"$f":"'Beräkningar nyttor'!M85","v":{"v":3125000,"d":"3,125,000 "}},{"$f":"'Beräkningar nyttor'!N85","v":{"v":3125000,"d":"3,125,000 "}},{"v":6250000,"d":"6,250,000 "},{"$f":"'Beräkningar nyttor'!P85","v":{"v":3125000,"d":"3,125,000 "}},{"$f":"'Beräkningar nyttor'!Q85","v":{"v":9375000,"d":"9,375,000 "}},{"v":6250000,"d":"6,250,000 "},{"v":0.2,"d":"20%"},{"$f":"Tabell10[[#This Row],[Summa]]/SUM(L7:L15)","v":{"v":0.04216480125388179,"d":"4%"}},{"$f":"Tabell10[[#This Row],[Summa]]/6","v":{"v":1041666.6666666666,"d":"1,041,667 "}}]
[null,8,"1. Finansiell",{"$f":"'Beräkningar nyttor'!A97","v":"Kommande konsumenter behöver inte utveckla anslutningar till andra informationsmängder"},"Inera",{"$f":"'Beräkningar nyttor'!I98","v":0},{"$f":"'Beräkningar nyttor'!J98","v":0},{"$f":"'Beräkningar nyttor'!K98","v":{"v":1000000,"d":"1,000,000 "}},{"$f":"'Beräkningar nyttor'!L98","v":{"v":1000000,"d":"1,000,000 "}},{"$f":"'Beräkningar nyttor'!M98","v":{"v":1000000,"d":"1,000,000 "}},{"$f":"'Beräkningar nyttor'!N98","v":{"v":1000000,"d":"1,000,000 "}},{"v":4000000,"d":"4,000,000 "},{"$f":"'Beräkningar nyttor'!P98","v":{"v":3000000,"d":"3,000,000 "}},{"$f":"'Beräkningar nyttor'!Q98","v":{"v":4000000,"d":"4,000,000 "}},{"v":3800000,"d":"3,800,000 "},{"v":0.05,"d":"5%"},{"$f":"Tabell10[[#This Row],[Summa]]/SUM(L7:L15)","v":{"v":0.026985472802484346,"d":"3%"}},{"$f":"Tabell10[[#This Row],[Summa]]/6","v":{"v":666666.6666666666,"d":"666,667 "}}]
[null,2,"1. Finansiell",{"$f":"'Beräkningar nyttor'!A14","v":"Minskade kostnader för drift och förvaltning av HSA"},"Inera",{"$f":"'Beräkningar nyttor'!I15","v":0},{"$f":"'Beräkningar nyttor'!J15","v":0},{"$f":"'Beräkningar nyttor'!K15","v":{"v":765672,"d":"765,672 "}},{"$f":"'Beräkningar nyttor'!L15","v":{"v":765672,"d":"765,672 "}},{"$f":"'Beräkningar nyttor'!M15","v":{"v":765672,"d":"765,672 "}},{"$f":"'Beräkningar nyttor'!N15","v":{"v":765672,"d":"765,672 "}},{"v":3062688,"d":"3,062,688 "},{"$f":"'Beräkningar nyttor'!P15","v":{"v":2102688,"d":"2,102,688 "}},{"$f":"'Beräkningar nyttor'!Q15","v":{"v":8107488,"d":"8,107,488 "}},{"v":3879648,"d":"3,879,648 "},{"v":0.3921261323386515,"d":"39%"},{"$f":"Tabell10[[#This Row],[Summa]]/SUM(L7:L15)","v":{"v":0.020662020931623795,"d":"2%"}},{"$f":"Tabell10[[#This Row],[Summa]]/6","v":{"v":510448,"d":"510,448 "}},{"$f":"SUM(Q7:Q14)","v":{"v":0.9986507263598758,"d":"100%"}}]
[null,1,"1. Finansiell",{"$f":"'Beräkningar nyttor'!A4","v":"Minskade kostnader för anpassningar för att hantera felaktig information"},"Inera",{"$f":"'Beräkningar nyttor'!I5","v":0},{"$f":"'Beräkningar nyttor'!J5","v":0},{"$f":"'Beräkningar nyttor'!K5","v":{"v":227803.33333333334,"d":"227,803 "}},{"$f":"'Beräkningar nyttor'!L5","v":{"v":227803.33333333334,"d":"227,803 "}},{"$f":"'Beräkningar nyttor'!M5","v":{"v":227803.33333333334,"d":"227,803 "}},{"$f":"'Beräkningar nyttor'!N5","v":{"v":227803.33333333334,"d":"227,803 "}},{"v":911213.3333333334,"d":"911,213 "},{"$f":"'Beräkningar nyttor'!P5","v":{"v":911213.3333333334,"d":"911,213 "}},{"$f":"'Beräkningar nyttor'!Q5","v":{"v":2184000,"d":"2,184,000 "}},{"v":1165770.6666666667,"d":"1,165,771 "},{"v":0.2793608521970705,"d":"28%"},{"$f":"Tabell10[[#This Row],[Summa]]/SUM(L7:L15)","v":{"v":0.006147380655981942,"d":"1%"}},{"$f":"Tabell10[[#This Row],[Summa]]/6","v":{"v":151868.8888888889,"d":"151,869 "}},{"$f":"SUM(Q15:Q20)","v":{"v":1.0013492736401242,"d":"100%"}}]
[null,12,"1. Finansiell",{"$f":"'Beräkningar nyttor'!A147","v":"Minskade skadestånd eller viten enligt GDPR"},"Regioner",{"$f":"'Beräkningar nyttor'!I148","v":0},{"$f":"'Beräkningar nyttor'!J148","v":0},{"$f":"'Beräkningar nyttor'!K148","v":0},{"$f":"'Beräkningar nyttor'!L148","v":{"v":200000,"d":"200,000 "}},{"$f":"'Beräkningar nyttor'!M148","v":0},{"$f":"'Beräkningar nyttor'!N148","v":0},{"v":200000,"d":"200,000 "},{"$f":"'Beräkningar nyttor'!P148","v":0},{"$f":"'Beräkningar nyttor'!Q148","v":{"v":10000000,"d":"10,000,000 "}},{"v":2120000,"d":"2,120,000 "},{"v":10,"d":"1000%"},{"$f":"Tabell10[[#This Row],[Summa]]/SUM(L7:L15)","v":{"v":1.3492736401242173E-3,"d":"0%"}},{"$f":"Tabell10[[#This Row],[Summa]]/6","v":{"v":33333.333333333336,"d":"33,333 "}}]
[null,4,"2. Omfördelningsnytta",{"$f":"'Beräkningar nyttor'!A51","v":"Minskade kostnader genom gemensam terminologi - Regioner"},"Regioner",{"$f":"'Beräkningar nyttor'!I52","v":0},{"$f":"'Beräkningar nyttor'!J52","v":0},{"$f":"'Beräkningar nyttor'!K52","v":0},{"$f":"'Beräkningar nyttor'!L52","v":{"v":10656000,"d":"10,656,000 "}},{"$f":"'Beräkningar nyttor'!M52","v":{"v":10656000,"d":"10,656,000 "}},{"$f":"'Beräkningar nyttor'!N52","v":{"v":10656000,"d":"10,656,000 "}},{"v":31968000,"d":"31,968,000 "},{"$f":"'Beräkningar nyttor'!P52","v":{"v":31968000,"d":"31,968,000 "}},{"$f":"'Beräkningar nyttor'!Q52","v":{"v":31968000,"d":"31,968,000 "}},{"v":31968000,"d":"31,968,000 "},{"v":0,"d":"0%"},{"$f":"Tabell10[[#This Row],[Summa]]/SUM(L16:L20)","v":{"v":0.29829654087612517,"d":"30%"}},{"$f":"Tabell10[[#This Row],[Summa]]/6","v":{"v":5328000,"d":"5,328,000 "}}]
[null,10,"2. Omfördelningsnytta",{"$f":"'Beräkningar nyttor'!A120","v":"Minskad tid på administration för producenter av information (genom bättre admingränssnitt)"},"Regioner",{"$f":"'Beräkningar nyttor'!I121","v":0},{"$f":"'Beräkningar nyttor'!J121","v":0},{"$f":"'Beräkningar nyttor'!K121","v":{"v":15816346,"d":"15,816,346 "}},{"$f":"'Beräkningar nyttor'!L121","v":{"v":15816346,"d":"15,816,346 "}},{"$f":"'Beräkningar nyttor'!M121","v":{"v":15816346,"d":"15,816,346 "}},{"$f":"'Beräkningar nyttor'!N121","v":{"v":15816346,"d":"15,816,346 "}},{"v":63265384,"d":"63,265,384 "},{"$f":"'Beräkningar nyttor'!P121","v":{"v":21018400,"d":"21,018,400 "}},{"$f":"'Beräkningar nyttor'!Q121","v":{"v":63265384,"d":"63,265,384 "}},{"v":54815987.2,"d":"54,815,987 "},{"v":0.13355481727574753,"d":"13%"},{"$f":"Tabell10[[#This Row],[Summa]]/SUM(L16:L20)","v":{"v":0.5903354981356279,"d":"59%"}},{"$f":"Tabell10[[#This Row],[Summa]]/6","v":{"v":10544230.666666666,"d":"10,544,231 "}}]
[null,14,"2. Omfördelningsnytta",{"$f":"'Beräkningar nyttor'!A174","v":"Minskad tid på administration för producenter i RGS Katalog"},"Regioner",{"$f":"'Beräkningar nyttor'!I175","v":0},{"$f":"'Beräkningar nyttor'!J175","v":0},{"$f":"'Beräkningar nyttor'!K175","v":{"v":2629536,"d":"2,629,536 "}},{"$f":"'Beräkningar nyttor'!L175","v":{"v":2629536,"d":"2,629,536 "}},{"$f":"'Beräkningar nyttor'!M175","v":{"v":2629536,"d":"2,629,536 "}},{"$f":"'Beräkningar nyttor'!N175","v":{"v":2629536,"d":"2,629,536 "}},{"v":10518144,"d":"10,518,144 "},{"$f":"'Beräkningar nyttor'!P175","v":{"v":8414515.200000001,"d":"8,414,515 "}},{"$f":"'Beräkningar nyttor'!Q175","v":{"v":12621772.799999999,"d":"12,621,773 "}},{"v":10518144,"d":"10,518,144 "},{"v":0.07999999999999996,"d":"8%"},{"$f":"Tabell10[[#This Row],[Summa]]/SUM(L16:L20)","v":{"v":0.09814583244610144,"d":"10%"}},{"$f":"Tabell10[[#This Row],[Summa]]/6","v":{"v":1753024,"d":"1,753,024 "}}]
[null,3,"2. Omfördelningsnytta",{"$f":"'Beräkningar nyttor'!A41","v":"Minskade kostnader genom  gemensam terminologi - Inera"},"Inera",{"$f":"'Beräkningar nyttor'!I42","v":0},{"$f":"'Beräkningar nyttor'!J42","v":0},{"$f":"'Beräkningar nyttor'!K42","v":0},{"$f":"'Beräkningar nyttor'!L42","v":{"v":149100,"d":"149,100 "}},{"$f":"'Beräkningar nyttor'!M42","v":{"v":149100,"d":"149,100 "}},{"$f":"'Beräkningar nyttor'!N42","v":{"v":149100,"d":"149,100 "}},{"v":447300,"d":"447,300 "},{"$f":"'Beräkningar nyttor'!P42","v":{"v":447300,"d":"447,300 "}},{"$f":"'Beräkningar nyttor'!Q42","v":{"v":447300,"d":"447,300 "}},{"v":447300,"d":"447,300 "},{"v":0,"d":"0%"},{"$f":"Tabell10[[#This Row],[Summa]]/SUM(L16:L20)","v":{"v":0.004173800135569656,"d":"0%"}},{"$f":"Tabell10[[#This Row],[Summa]]/6","v":{"v":74550,"d":"74,550 "}}]
[null,13,"2. Omfördelningsnytta",{"$f":"'Beräkningar nyttor'!A159","v":"Minskad tid på administration för producenter i Hitta och jämför vård"},"Regioner",{"$f":"'Beräkningar nyttor'!I160","v":0},{"$f":"'Beräkningar nyttor'!J160","v":0},{"$f":"'Beräkningar nyttor'!K160","v":{"v":242424,"d":"242,424 "}},{"$f":"'Beräkningar nyttor'!L160","v":{"v":242424,"d":"242,424 "}},{"$f":"'Beräkningar nyttor'!M160","v":{"v":242424,"d":"242,424 "}},{"$f":"'Beräkningar nyttor'!N160","v":{"v":242424,"d":"242,424 "}},{"v":969696,"d":"969,696 "},{"$f":"'Beräkningar nyttor'!P160","v":{"v":327600,"d":"327,600 "}},{"$f":"'Beräkningar nyttor'!Q160","v":{"v":969696,"d":"969,696 "}},{"v":841276.8,"d":"841,277 "},{"v":0.13243243243243244,"d":"13%"},{"$f":"Tabell10[[#This Row],[Summa]]/SUM(L16:L20)","v":{"v":0.009048328406575797,"d":"1%"}},{"$f":"Tabell10[[#This Row],[Summa]]/6","v":{"v":161616,"d":"161,616 "}}]
[null,15,{"$nulls":9},0,null,null,"",""]
[null,16,{"$nulls":9},0,null,null,"",""]
[null,17,{"$nulls":9},0,null,null,"",""]
[null,18,{"$nulls":9},0,null,null,"",""]
[null,19,{"$nulls":9},0,null,null,"",""]
[null,20,{"$nulls":9},0,null,null,"",""]
[null,21,{"$nulls":9},0,null,null,"",""]
[null,"Summa",{"$nulls":3},{"$f":"SUBTOTAL(109,Tabell10[år 1])","v":0},{"$f":"SUBTOTAL(109,Tabell10[år 2])","v":0},{"$f":"SUBTOTAL(109,Tabell10[år 3])","v":{"v":28257781.333333336,"d":"28,257,781 "}},{"$f":"SUBTOTAL(109,Tabell10[år 4])","v":{"v":73762881.33333334,"d":"73,762,881 "}},{"$f":"SUBTOTAL(109,Tabell10[år 5])","v":{"v":76687881.33333334,"d":"76,687,881 "}},{"$f":"SUBTOTAL(109,Tabell10[år 6])","v":{"v":76687881.33333334,"d":"76,687,881 "}},{"$f":"SUBTOTAL(109,Tabell10[Summa])","v":{"v":255396425.33333334,"d":"255,396,425 "}},{"$f":"SUM(Tabell10[Min])","v":{"v":131118716.53333333,"d":"131,118,717 "}},{"$f":"SUM(Tabell10[Max])","v":{"v":415492640.8,"d":"415,492,641 "}},{"$f":"SUBTOTAL(109,Tabell10[Vägt medel])","v":{"v":262560126.6666667,"d":"262,560,127 "}}]

{"sheet":"Kostnader","index":3,"n_rows":28,"n_cols":16,"rows_kept":28,"merged":[[3,5,3,11],[3,12,3,13]]}
[null,"Kostnader"]
[null,{"$f":"IF(Grunddata!B6=0,\"\",Grunddata!B6)","v":"Katalog 2025"}]
[]
[null,null,"Ange kostnadskategori - genom att välja i rullisten. ","Ange ett kortfattat men beskrivande namn på kostnaden, exempelvis \"personalkostnad, \"konsultkostnad,\" etc. ","Angeför vilken intressent kostnaden uppstår. Ange en ny rad per intressent om kostnaden uppstår hos fler intressenter. ","Periodisera kostnaden under kalkylperioden per år.",{"$nulls":6},"Om möjligt estimera ett min- och ett max värde."]
[{"$nulls":5},{"$f":"Startår","v":2021},{"$f":"F5+1","v":2022},{"$f":"G5+1","v":2023},2024,2025,2026]
[null,"ID","Kostnadskategori","Kostnadens namn","Intressent ","år 1","år 2","år 3","år 4","år 5","år 6","Summa","Min","Max","Vägt medel","Osäkerhet"]
[null,1,"4. Projekt","Katalog 2025","Inera",{"v":15000000,"d":"15,000,000 "},{"v":30000000,"d":"30,000,000 "},{"v":30000000,"d":"30,000,000 "},{"v":10600000,"d":"10,600,000 "},null,null,{"$f":"SUM(F7:K7)","v":{"v":85600000,"d":"85,600,000 "}},{"v":85600000,"d":"85,600,000 "},{"v":85600000,"d":"85,600,000 "},{"$f":"IF(OR(ISBLANK(N7),ISBLANK(M7),ISBLANK(L7)),\"\",(N7+M7+3*L7)/5)","v":{"v":85600000,"d":"85,600,000 "}},{"$f":"IF(OR(ISBLANK(L7),L7=0),\"\",(N7-M7)/5/L7)","v":{"v":0,"d":"0%"}}]
[null,2,"1. Verksamhetsförändring",{"$nulls":8},0,{"$f":"0.8*Tabell109[[#This Row],[Summa]]","v":0},{"$f":"1.2*Tabell109[[#This Row],[Min]]","v":0},0,""]
[null,3,"2. Löpande verksamhetskostnader",{"$nulls":8},0,{"$f":"0.8*Tabell109[[#This Row],[Summa]]","v":0},{"$f":"1.2*Tabell109[[#This Row],[Min]]","v":0},0,""]
[null,4,"3. Investeringar",{"$nulls":8},0,{"$f":"0.8*Tabell109[[#This Row],[Summa]]","v":0},{"$f":"1.2*Tabell109[[#This Row],[Min]]","v":0},0,""]
[null,5,{"$nulls":9},0,{"$f":"0.8*Tabell109[[#This Row],[Summa]]","v":0},{"$f":"1.2*Tabell109[[#This Row],[Min]]","v":0},0,""]
[null,6,{"$nulls":9},0,{"$f":"0.8*Tabell109[[#This Row],[Summa]]","v":0},{"$f":"1.2*Tabell109[[#This Row],[Min]]","v":0},0,""]
[null,7,{"$nulls":9},0,{"$f":"0.8*Tabell109[[#This Row],[Summa]]","v":0},{"$f":"1.2*Tabell109[[#This Row],[Min]]","v":0},0,""]
[null,8,{"$nulls":9},0,{"$f":"0.8*Tabell109[[#This Row],[Summa]]","v":0},{"$f":"1.2*Tabell109[[#This Row],[Min]]","v":0},0,""]
[null,9,{"$nulls":9},0,{"$f":"0.8*Tabell109[[#This Row],[Summa]]","v":0},{"$f":"1.2*Tabell109[[#This Row],[Min]]","v":0},0,""]
[null,10,{"$nulls":9},0,{"$f":"0.8*Tabell109[[#This Row],[Summa]]","v":0},{"$f":"1.2*Tabell109[[#This Row],[Min]]","v":0},0,""]
[null,11,{"$nulls":9},0,{"$f":"0.8*Tabell109[[#This Row],[Summa]]","v":0},{"$f":"1.2*Tabell109[[#This Row],[Min]]","v":0},0,""]
[null,12,{"$nulls":9},0,{"$f":"0.8*Tabell109[[#This Row],[Summa]]","v":0},{"$f":"1.2*Tabell109[[#This Row],[Min]]","v":0},0,""]
[null,13,{"$nulls":9},0,{"$f":"0.8*Tabell109[[#This Row],[Summa]]","v":0},{"$f":"1.2*Tabell109[[#This Row],[Min]]","v":0},0,""]
[null,14,{"$nulls":9},0,{"$f":"0.8*Tabell109[[#This Row],[Summa]]","v":0},{"$f":"1.2*Tabell109[[#This Row],[Min]]","v":0},0,""]
[null,15,{"$nulls":9},0,{"$f":"0.8*Tabell109[[#This Row],[Summa]]","v":0},{"$f":"1.2*Tabell109[[#This Row],[Min]]","v":0},0,""]
[null,16,{"$nulls":9},0,{"$f":"0.8*Tabell109[[#This Row],[Summa]]","v":0},{"$f":"1.2*Tabell109[[#This Row],[Min]]","v":0},0,""]
[null,17,{"$nulls":9},0,{"$f":"0.8*Tabell109[[#This Row],[Summa]]","v":0},{"$f":"1.2*Tabell109[[#This Row],[Min]]","v":0},0,""]
[null,18,{"$nulls":9},0,{"$f":"0.8*Tabell109[[#This Row],[Summa]]","v":0},{"$f":"1.2*Tabell109[[#This Row],[Min]]","v":0},0,""]
[null,19,{"$nulls":9},0,{"$f":"0.8*Tabell109[[#This Row],[Summa]]","v":0},{"$f":"1.2*Tabell109[[#This Row],[Min]]","v":0},0,""]
[null,20,{"$nulls":9},0,{"$f":"0.8*Tabell109[[#This Row],[Summa]]","v":0},{"$f":"1.2*Tabell109[[#This Row],[Min]]","v":0},0,""]
[null,21,{"$nulls":9},0,{"$f":"0.8*Tabell109[[#This Row],[Summa]]","v":0},{"$f":"1.2*Tabell109[[#This Row],[Min]]","v":0},0,""]
[null,"Summa",{"$nulls":3},{"$f":"SUBTOTAL(109,Tabell109[år 1])","v":{"v":15000000,"d":"15,000,000 "}},{"$f":"SUBTOTAL(109,Tabell109[år 2])","v":{"v":30000000,"d":"30,000,000 "}},{"$f":"SUBTOTAL(109,Tabell109[år 3])","v":{"v":30000000,"d":"30,000,000 "}},{"$f":"SUBTOTAL(109,Tabell109[år 4])","v":{"v":10600000,"d":"10,600,000 "}},{"$f":"SUBTOTAL(109,Tabell109[år 5])","v":0},{"$f":"SUBTOTAL(109,Tabell109[år 6])","v":0},{"$f":"SUBTOTAL(109,Tabell109[Summa])","v":{"v":85600000,"d":"85,600,000 "}},{"$f":"SUBTOTAL(109,Tabell109[Min])","v":{"v":85600000,"d":"85,600,000 "}},{"$f":"SUBTOTAL(109,Tabell109[Max])","v":{"v":85600000,"d":"85,600,000 "}},{"$f":"SUBTOTAL(109,Tabell109[Vägt medel])","v":{"v":85600000,"d":"85,600,000 "}}]

{"sheet":"Nyttorealiseringskalkyl","index":4,"n_rows":134,"n_cols":16,"rows_kept":134,"merged":[[8,3,8,4],[20,3,22,4],[70,3,70,4],[121,3,121,4]]}
[{"$nulls":3},"Nyttorealiseringskalkyl"]
[{"$nulls":3},{"$f":"IF(Grunddata!B6=0,\"\",Grunddata!B6)","v":"Katalog 2025"}]
[{"$nulls":3},"Tabellerna och diagrammen är formaterade för att passa i powerpoint-presentationer. \nMarkera och kopiera tabellen eller diagrammet och välj att \"klistra in som bild\" för ett snyggt resultat."]
[]
[]
[{"$nulls":3},"Total nytta"]
[]
[]
[{"$nulls":3},"Nyttorealiseringskalkyl - total nytta",{"$nulls":4},"Nyttorealiseringskalkyl - total nytta"]
[{"$nulls":3},"För perioden",{"$f":"Startår & \" - \" & Startår+5","v":"2021 - 2026"}]
[{"$nulls":9},{"$f":"Startår","v":2021},{"$f":"J11+1","v":2022},{"$f":"K11+1","v":2023},2024,{"$f":"M11+1","v":2025},{"$f":"N11+1","v":2026},"Totalt"]
[{"$nulls":3},"Total kostnad",{"$f":"TotalKostnad","v":{"v":-85600000,"d":"-85,600,000 kr"}},{"$nulls":3},"Total nytta",{"$f":"J13+J14","v":0},{"$f":"K13+K14","v":0},{"v":28257781.333333336,"d":"28,257,781 "},{"v":73762881.33333334,"d":"73,762,881 "},{"v":76687881.33333334,"d":"76,687,881 "},{"v":76687881.33333334,"d":"76,687,881 "},{"v":255396425.33333334,"d":"255,396,425 "}]
[{"$nulls":3},"Finansiell nytta",{"$f":"P13","v":{"v":148227901.33333334,"d":"148,227,901 kr"}},{"$nulls":3},"Finansiella nyttor",{"$f":"GETPIVOTDATA(\"Summa av år 1\",'-Admin-'!$C$34,\"Nyttokategori\",\"1. Finansiell\")","v":0},{"$f":"GETPIVOTDATA(\"Summa av år 2\",'-Admin-'!$C$34,\"Nyttokategori\",\"1. Finansiell\")","v":0},{"$f":"GETPIVOTDATA(\"Summa av år 3\",'-Admin-'!$C$34,\"Nyttokategori\",\"1. Finansiell\")","v":{"v":9569475.333333334,"d":"9,569,475 "}},{"$f":"GETPIVOTDATA(\"Summa av år 4\",'-Admin-'!$C$34,\"Nyttokategori\",\"1. Finansiell\")","v":{"v":44269475.333333336,"d":"44,269,475 "}},{"$f":"GETPIVOTDATA(\"Summa av år 5\",'-Admin-'!$C$34,\"Nyttokategori\",\"1. Finansiell\")","v":{"v":47194475.333333336,"d":"47,194,475 "}},{"$f":"GETPIVOTDATA(\"Summa av år 6\",'-Admin-'!$C$34,\"Nyttokategori\",\"1. Finansiell\")","v":{"v":47194475.333333336,"d":"47,194,475 "}},{"$f":"SUM(J13:O13)","v":{"v":148227901.33333334,"d":"148,227,901 "}}]
[{"$nulls":3},"Omfördelningsnytta",{"$f":"P14","v":{"v":107168524,"d":"107,168,524 kr"}},{"$nulls":3},"Omfördelningsnyttor",{"$f":"GETPIVOTDATA(\"Summa av år 1\",'-Admin-'!$C$34,\"Nyttokategori\",\"2. Omfördelningsnytta\")","v":0},{"$f":"GETPIVOTDATA(\"Summa av år 2\",'-Admin-'!$C$34,\"Nyttokategori\",\"2. Omfördelningsnytta\")","v":0},{"$f":"GETPIVOTDATA(\"Summa av år 3\",'-Admin-'!$C$34,\"Nyttokategori\",\"2. Omfördelningsnytta\")","v":{"v":18688306,"d":"18,688,306 "}},{"$f":"GETPIVOTDATA(\"Summa av år 4\",'-Admin-'!$C$34,\"Nyttokategori\",\"2. Omfördelningsnytta\")","v":{"v":29493406,"d":"29,493,406 "}},{"$f":"GETPIVOTDATA(\"Summa av år 5\",'-Admin-'!$C$34,\"Nyttokategori\",\"2. Omfördelningsnytta\")","v":{"v":29493406,"d":"29,493,406 "}},{"$f":"GETPIVOTDATA(\"Summa av år 6\",'-Admin-'!$C$34,\"Nyttokategori\",\"2. Omfördelningsnytta\")","v":{"v":29493406,"d":"29,493,406 "}},{"$f":"SUM(J14:O14)","v":{"v":107168524,"d":"107,168,524 "}}]
[{"$nulls":3},"Total nytta",{"$f":"TotalNytta","v":{"v":255396425.33333334,"d":"255,396,425 kr"}}]
[{"$nulls":3},"Total nettonytta",{"$f":"NettoNytta","v":{"v":169796425.33333334,"d":"169,796,425 kr"}},{"$nulls":3},"Total kostnad",{"$f":"SUM(J17:J20)","v":{"v":-15000000,"d":"-15,000,000 "}},{"$f":"SUM(K17:K20)","v":{"v":-30000000,"d":"-30,000,000 "}},{"v":-30000000,"d":"-30,000,000 "},{"v":-10600000,"d":"-10,600,000 "},0,0,{"v":-85600000,"d":"-85,600,000 "}]
[{"$nulls":8},"Verksamhets-förändring",{"$f":"-GETPIVOTDATA(\"Summa av År 1\",'-Admin-'!$C$41,\"Kostnadskategori\",\"1. Verksamhetsförändring\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 2\",'-Admin-'!$C$41,\"Kostnadskategori\",\"1. Verksamhetsförändring\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 3\",'-Admin-'!$C$41,\"Kostnadskategori\",\"1. Verksamhetsförändring\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 4\",'-Admin-'!$C$41,\"Kostnadskategori\",\"1. Verksamhetsförändring\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 5\",'-Admin-'!$C$41,\"Kostnadskategori\",\"1. Verksamhetsförändring\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 6\",'-Admin-'!$C$41,\"Kostnadskategori\",\"1. Verksamhetsförändring\")","v":0},{"$f":"SUM(J17:O17)","v":0}]
[{"$nulls":3},"Return on investment (ROI)",{"$f":"IF(-TotalKostnad=0,0,TotalNettoNytta/-TotalKostnad)","v":{"v":1.9836030996884737,"d":"1.98 kr"}},{"$nulls":3},"Löpande verksamhets-kostnader",{"$f":"-GETPIVOTDATA(\"Summa av År 1\",'-Admin-'!$C$41,\"Kostnadskategori\",\"2. Löpande verksamhetskostnader\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 2\",'-Admin-'!$C$41,\"Kostnadskategori\",\"2. Löpande verksamhetskostnader\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 3\",'-Admin-'!$C$41,\"Kostnadskategori\",\"2. Löpande verksamhetskostnader\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 4\",'-Admin-'!$C$41,\"Kostnadskategori\",\"2. Löpande verksamhetskostnader\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 5\",'-Admin-'!$C$41,\"Kostnadskategori\",\"2. Löpande verksamhetskostnader\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 6\",'-Admin-'!$C$41,\"Kostnadskategori\",\"2. Löpande verksamhetskostnader\")","v":0},{"$f":"SUM(J18:O18)","v":0}]
[{"$nulls":3},"Payback-år",{"$f":"IF('-Admin-'!D93=0,\"Ingen payback\",'-Admin-'!D93)","v":2024},{"$nulls":3},"Investeringar",{"$f":"-GETPIVOTDATA(\"Summa av År 1\",'-Admin-'!$C$41,\"Kostnadskategori\",\"3. Investeringar\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 2\",'-Admin-'!$C$41,\"Kostnadskategori\",\"3. Investeringar\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 3\",'-Admin-'!$C$41,\"Kostnadskategori\",\"3. Investeringar\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 4\",'-Admin-'!$C$41,\"Kostnadskategori\",\"3. Investeringar\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 5\",'-Admin-'!$C$41,\"Kostnadskategori\",\"3. Investeringar\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 6\",'-Admin-'!$C$41,\"Kostnadskategori\",\"3. Investeringar\")","v":0},{"$f":"SUM(J19:O19)","v":0}]
[{"$nulls":8},"Projekt",{"$f":"-GETPIVOTDATA(\"Summa av År 1\",'-Admin-'!$C$41,\"Kostnadskategori\",\"4. Projekt\")","v":{"v":-15000000,"d":"-15,000,000 "}},{"$f":"-GETPIVOTDATA(\"Summa av År 2\",'-Admin-'!$C$41,\"Kostnadskategori\",\"4. Projekt\")","v":{"v":-30000000,"d":"-30,000,000 "}},{"$f":"-GETPIVOTDATA(\"Summa av År 3\",'-Admin-'!$C$41,\"Kostnadskategori\",\"4. Projekt\")","v":{"v":-30000000,"d":"-30,000,000 "}},{"$f":"-GETPIVOTDATA(\"Summa av År 4\",'-Admin-'!$C$41,\"Kostnadskategori\",\"4. Projekt\")","v":{"v":-10600000,"d":"-10,600,000 "}},{"$f":"-GETPIVOTDATA(\"Summa av År 5\",'-Admin-'!$C$41,\"Kostnadskategori\",\"4. Projekt\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 6\",'-Admin-'!$C$41,\"Kostnadskategori\",\"4. Projekt\")","v":0},{"v":-85600000,"d":"-85,600,000 "}]
[{"$nulls":3},"Return on investment (ROI) är intjänad värderad nytta per investerad krona. \nPayback-år är året då de värderade nyttorna förväntas överstiga kostnaderna. "]
[{"$nulls":8},"Finansiell nettonytta",{"$f":"J13+J16","v":{"v":-15000000,"d":"-15,000,000 "}},{"$f":"K13+K16","v":{"v":-30000000,"d":"-30,000,000 "}},{"v":-20430524.666666664,"d":"-20,430,525 "},{"v":33669475.333333336,"d":"33,669,475 "},{"v":47194475.333333336,"d":"47,194,475 "},{"v":47194475.333333336,"d":"47,194,475 "},{"$f":"P13+P16","v":{"v":62627901.33333334,"d":"62,627,901 "}}]
[{"$nulls":8},"Ackumulerad finansiell nettonytta",{"$f":"J14+J16","v":{"v":-15000000,"d":"-15,000,000 "}},{"$f":"IF(K22=0,\"\",J23+K22)","v":{"v":-45000000,"d":"-45,000,000 "}},{"$f":"IF(L22=0,\"\",K23+L22)","v":{"v":-65430524.666666664,"d":"-65,430,525 "}},{"v":-31761049.33333333,"d":"-31,761,049 "},{"v":15433426.000000007,"d":"15,433,426 "},{"v":62627901.33333334,"d":"62,627,901 "},{"$f":"O23","v":{"v":62627901.33333334,"d":"62,627,901 "}}]
[{"$nulls":8},"Omfördelnings-nettonytta",{"$f":"J14+J16","v":{"v":-15000000,"d":"-15,000,000 "}},{"$f":"K14+K16","v":{"v":-30000000,"d":"-30,000,000 "}},{"v":-11311694,"d":"-11,311,694 "},{"v":18893406,"d":"18,893,406 "},{"v":29493406,"d":"29,493,406 "},{"v":29493406,"d":"29,493,406 "},{"$f":"P14+P16","v":{"v":21568524,"d":"21,568,524 "}}]
[{"$nulls":8},"Ackumulerad omfördelnings-nettonytta",{"$f":"J26","v":{"v":-15000000,"d":"-15,000,000 "}},{"$f":"IF(K24=0,\"\",J25+K24)","v":{"v":-45000000,"d":"-45,000,000 "}},{"$f":"IF(L24=0,\"\",K25+L24)","v":{"v":-56311694,"d":"-56,311,694 "}},{"v":-37418288,"d":"-37,418,288 "},{"v":-7924882,"d":"-7,924,882 "},{"v":21568524,"d":"21,568,524 "},{"$f":"O25","v":{"v":21568524,"d":"21,568,524 "}}]
[{"$nulls":8},"Nettonytta",{"$f":"J12+J16","v":{"v":-15000000,"d":"-15,000,000 "}},{"v":-30000000,"d":"-30,000,000 "},{"v":-1742218.6666666642,"d":"-1,742,219 "},{"v":63162881.33333334,"d":"63,162,881 "},{"v":76687881.33333334,"d":"76,687,881 "},{"v":76687881.33333334,"d":"76,687,881 "},{"v":169796425.33333334,"d":"169,796,425 "}]
[{"$nulls":8},"Ackumulerad nettonytta",{"$f":"J26","v":{"v":-15000000,"d":"-15,000,000 "}},{"$f":"IF(K26=0,\"\",J27+K26)","v":{"v":-45000000,"d":"-45,000,000 "}},{"$f":"IF(L26=0,\"\",K27+L26)","v":{"v":-46742218.666666664,"d":"-46,742,219 "}},{"$f":"IF(M26=0,\"\",L27+M26)","v":{"v":16420662.66666668,"d":"16,420,663 "}},{"$f":"IF(N26=0,\"\",M27+N26)","v":{"v":93108544.00000003,"d":"93,108,544 "}},{"$f":"IF(O26=0,\"\",N27+O26)","v":{"v":169796425.33333337,"d":"169,796,425 "}},{"$f":"O27","v":{"v":169796425.33333337,"d":"169,796,425 "}}]
{"$rows_empty":40}
[{"$nulls":3},"Finansiell nytta"]
[]
[]
[{"$nulls":3},"Nyttorealiseringskalkyl - finansiel nytta",{"$nulls":4},"Nyttorealiseringskalkyl - finansiell nytta"]
[{"$nulls":3},"För perioden",{"$f":"Startår & \" - \" & Startår+5","v":"2021 - 2026"}]
[{"$nulls":9},{"$f":"Startår","v":2021},{"$f":"J73+1","v":2022},{"$f":"K73+1","v":2023},{"$f":"L73+1","v":2024},{"$f":"M73+1","v":2025},{"$f":"N73+1","v":2026},"Totalt"]
[{"$nulls":3},"Total kostnad",{"$f":"TotalKostnad","v":{"v":-85600000,"d":"-85,600,000 kr"}},{"$nulls":3},"Finansiella nyttor",{"$f":"GETPIVOTDATA(\"Summa av år 1\",'-Admin-'!$C$34,\"Nyttokategori\",\"1. Finansiell\")","v":0},{"$f":"GETPIVOTDATA(\"Summa av år 2\",'-Admin-'!$C$34,\"Nyttokategori\",\"1. Finansiell\")","v":0},{"$f":"GETPIVOTDATA(\"Summa av år 3\",'-Admin-'!$C$34,\"Nyttokategori\",\"1. Finansiell\")","v":{"v":9569475.333333334,"d":"9,569,475 "}},{"$f":"GETPIVOTDATA(\"Summa av år 4\",'-Admin-'!$C$34,\"Nyttokategori\",\"1. Finansiell\")","v":{"v":44269475.333333336,"d":"44,269,475 "}},{"$f":"GETPIVOTDATA(\"Summa av år 5\",'-Admin-'!$C$34,\"Nyttokategori\",\"1. Finansiell\")","v":{"v":47194475.333333336,"d":"47,194,475 "}},{"$f":"GETPIVOTDATA(\"Summa av år 6\",'-Admin-'!$C$34,\"Nyttokategori\",\"1. Finansiell\")","v":{"v":47194475.333333336,"d":"47,194,475 "}},{"$f":"SUM(J74:O74)","v":{"v":148227901.33333334,"d":"148,227,901 "}}]
[{"$nulls":3},"Total finansiell nytta",{"$f":"P74","v":{"v":148227901.33333334,"d":"148,227,901 kr"}}]
[{"$nulls":3},"Finansiell nettonytta",{"$f":"P82","v":{"v":62627901.33333334,"d":"62,627,901 kr"}},{"$nulls":3},"Total kostnad",{"$f":"SUM(J77:J80)","v":{"v":-15000000,"d":"-15,000,000 "}},{"$f":"SUM(K77:K80)","v":{"v":-30000000,"d":"-30,000,000 "}},{"v":-30000000,"d":"-30,000,000 "},{"v":-10600000,"d":"-10,600,000 "},0,0,{"v":-85600000,"d":"-85,600,000 "}]
[{"$nulls":8},"Verksamhets-förändring",{"$f":"-GETPIVOTDATA(\"Summa av År 1\",'-Admin-'!$C$41,\"Kostnadskategori\",\"1. Verksamhetsförändring\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 2\",'-Admin-'!$C$41,\"Kostnadskategori\",\"1. Verksamhetsförändring\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 3\",'-Admin-'!$C$41,\"Kostnadskategori\",\"1. Verksamhetsförändring\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 4\",'-Admin-'!$C$41,\"Kostnadskategori\",\"1. Verksamhetsförändring\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 5\",'-Admin-'!$C$41,\"Kostnadskategori\",\"1. Verksamhetsförändring\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 6\",'-Admin-'!$C$41,\"Kostnadskategori\",\"1. Verksamhetsförändring\")","v":0},{"$f":"SUM(J77:O77)","v":0}]
[{"$nulls":3},"Return on investment (ROI)",{"$f":"IF(-P76=0,0,P82/-P76)","v":{"v":0.7316343613707166,"d":"0.73 kr"}},{"$nulls":3},"Löpande verksamhets-kostnader",{"$f":"-GETPIVOTDATA(\"Summa av År 1\",'-Admin-'!$C$41,\"Kostnadskategori\",\"2. Löpande verksamhetskostnader\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 2\",'-Admin-'!$C$41,\"Kostnadskategori\",\"2. Löpande verksamhetskostnader\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 3\",'-Admin-'!$C$41,\"Kostnadskategori\",\"2. Löpande verksamhetskostnader\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 4\",'-Admin-'!$C$41,\"Kostnadskategori\",\"2. Löpande verksamhetskostnader\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 5\",'-Admin-'!$C$41,\"Kostnadskategori\",\"2. Löpande verksamhetskostnader\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 6\",'-Admin-'!$C$41,\"Kostnadskategori\",\"2. Löpande verksamhetskostnader\")","v":0},{"$f":"SUM(J78:O78)","v":0}]
[{"$nulls":3},"Payback-år",{"$f":"'-Admin-'!D102","v":2025},{"$nulls":3},"Investeringar",{"$f":"-GETPIVOTDATA(\"Summa av År 1\",'-Admin-'!$C$41,\"Kostnadskategori\",\"3. Investeringar\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 2\",'-Admin-'!$C$41,\"Kostnadskategori\",\"3. Investeringar\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 3\",'-Admin-'!$C$41,\"Kostnadskategori\",\"3. Investeringar\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 4\",'-Admin-'!$C$41,\"Kostnadskategori\",\"3. Investeringar\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 5\",'-Admin-'!$C$41,\"Kostnadskategori\",\"3. Investeringar\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 6\",'-Admin-'!$C$41,\"Kostnadskategori\",\"3. Investeringar\")","v":0},{"$f":"SUM(J79:O79)","v":0}]
[{"$nulls":8},"Projekt",{"$f":"-GETPIVOTDATA(\"Summa av År 1\",'-Admin-'!$C$41,\"Kostnadskategori\",\"4. Projekt\")","v":{"v":-15000000,"d":"-15,000,000 "}},{"$f":"-GETPIVOTDATA(\"Summa av År 2\",'-Admin-'!$C$41,\"Kostnadskategori\",\"4. Projekt\")","v":{"v":-30000000,"d":"-30,000,000 "}},{"$f":"-GETPIVOTDATA(\"Summa av År 3\",'-Admin-'!$C$41,\"Kostnadskategori\",\"4. Projekt\")","v":{"v":-30000000,"d":"-30,000,000 "}},{"$f":"-GETPIVOTDATA(\"Summa av År 4\",'-Admin-'!$C$41,\"Kostnadskategori\",\"4. Projekt\")","v":{"v":-10600000,"d":"-10,600,000 "}},{"$f":"-GETPIVOTDATA(\"Summa av År 5\",'-Admin-'!$C$41,\"Kostnadskategori\",\"4. Projekt\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 6\",'-Admin-'!$C$41,\"Kostnadskategori\",\"4. Projekt\")","v":0},{"v":-85600000,"d":"-85,600,000 "}]
[]
[{"$nulls":8},"Finansiell nettonytta",{"$f":"J74+J76","v":{"v":-15000000,"d":"-15,000,000 "}},{"v":-30000000,"d":"-30,000,000 "},{"v":-20430524.666666664,"d":"-20,430,525 "},{"$f":"M74+M76","v":{"v":33669475.333333336,"d":"33,669,475 "}},{"v":47194475.333333336,"d":"47,194,475 "},{"v":47194475.333333336,"d":"47,194,475 "},{"$f":"P74+P76","v":{"v":62627901.33333334,"d":"62,627,901 "}}]
[{"$nulls":8},"Ackumulerad finansiell nettonytta",{"$f":"J82","v":{"v":-15000000,"d":"-15,000,000 "}},{"$f":"J83+K82","v":{"v":-45000000,"d":"-45,000,000 "}},{"$f":"K83+L82","v":{"v":-65430524.666666664,"d":"-65,430,525 "}},{"v":-31761049.33333333,"d":"-31,761,049 "},{"v":15433426.000000007,"d":"15,433,426 "},{"v":62627901.33333334,"d":"62,627,901 "},{"$f":"O83","v":{"v":62627901.33333334,"d":"62,627,901 "}}]
{"$rows_empty":35}
[{"$nulls":3},"Omfördelningsnytta"]
[]
[]
[{"$nulls":3},"Nyttorealiseringskalkyl",{"$nulls":4},"Nyttorealiseringskalkyl per år"]
[{"$nulls":3},"För perioden",{"$f":"Startår & \" - \" & Startår+5","v":"2021 - 2026"}]
[{"$nulls":9},{"$f":"Startår","v":2021},{"$f":"J124+1","v":2022},{"$f":"K124+1","v":2023},{"$f":"L124+1","v":2024},{"$f":"M124+1","v":2025},{"$f":"N124+1","v":2026},"Totalt"]
[{"$nulls":3},"Total kostnad",{"$f":"TotalKostnad","v":{"v":-85600000,"d":"-85,600,000 "}},{"$nulls":3},"Omfördelningsnyttor",{"$f":"GETPIVOTDATA(\"Summa av år 1\",'-Admin-'!$C$34,\"Nyttokategori\",\"2. Omfördelningsnytta\")","v":0},{"$f":"GETPIVOTDATA(\"Summa av år 2\",'-Admin-'!$C$34,\"Nyttokategori\",\"2. Omfördelningsnytta\")","v":0},{"$f":"GETPIVOTDATA(\"Summa av år 3\",'-Admin-'!$C$34,\"Nyttokategori\",\"2. Omfördelningsnytta\")","v":{"v":18688306,"d":"18,688,306 "}},{"$f":"GETPIVOTDATA(\"Summa av år 4\",'-Admin-'!$C$34,\"Nyttokategori\",\"2. Omfördelningsnytta\")","v":{"v":29493406,"d":"29,493,406 "}},{"$f":"GETPIVOTDATA(\"Summa av år 5\",'-Admin-'!$C$34,\"Nyttokategori\",\"2. Omfördelningsnytta\")","v":{"v":29493406,"d":"29,493,406 "}},{"$f":"GETPIVOTDATA(\"Summa av år 6\",'-Admin-'!$C$34,\"Nyttokategori\",\"2. Omfördelningsnytta\")","v":{"v":29493406,"d":"29,493,406 "}},{"$f":"SUM(J125:O125)","v":{"v":107168524,"d":"107,168,524 "}}]
[{"$nulls":3},"Total omfördelningsnytta",{"$f":"P125","v":{"v":107168524,"d":"107,168,524 "}}]
[{"$nulls":3},"Omfördelnings-nettonytta",{"$f":"P133","v":{"v":21568524,"d":"21,568,524 "}},{"$nulls":3},"Total kostnad",{"$f":"SUM(J128:J131)","v":{"v":-15000000,"d":"-15,000,000 "}},{"$f":"SUM(K128:K131)","v":{"v":-30000000,"d":"-30,000,000 "}},{"v":-30000000,"d":"-30,000,000 "},{"v":-10600000,"d":"-10,600,000 "},0,0,{"v":-85600000,"d":"-85,600,000 "}]
[{"$nulls":8},"Verksamhets-förändring",{"$f":"-GETPIVOTDATA(\"Summa av År 1\",'-Admin-'!$C$41,\"Kostnadskategori\",\"1. Verksamhetsförändring\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 2\",'-Admin-'!$C$41,\"Kostnadskategori\",\"1. Verksamhetsförändring\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 3\",'-Admin-'!$C$41,\"Kostnadskategori\",\"1. Verksamhetsförändring\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 4\",'-Admin-'!$C$41,\"Kostnadskategori\",\"1. Verksamhetsförändring\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 5\",'-Admin-'!$C$41,\"Kostnadskategori\",\"1. Verksamhetsförändring\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 6\",'-Admin-'!$C$41,\"Kostnadskategori\",\"1. Verksamhetsförändring\")","v":0},{"$f":"SUM(J128:O128)","v":0}]
[{"$nulls":3},"Return on investment (ROI)",{"$f":"IF(-P127=0,0,P133/-P127)","v":{"v":0.251968738317757,"d":"0.25 kr"}},{"$nulls":3},"Löpande verksamhets-kostnader",{"$f":"-GETPIVOTDATA(\"Summa av År 1\",'-Admin-'!$C$41,\"Kostnadskategori\",\"2. Löpande verksamhetskostnader\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 2\",'-Admin-'!$C$41,\"Kostnadskategori\",\"2. Löpande verksamhetskostnader\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 3\",'-Admin-'!$C$41,\"Kostnadskategori\",\"2. Löpande verksamhetskostnader\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 4\",'-Admin-'!$C$41,\"Kostnadskategori\",\"2. Löpande verksamhetskostnader\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 5\",'-Admin-'!$C$41,\"Kostnadskategori\",\"2. Löpande verksamhetskostnader\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 6\",'-Admin-'!$C$41,\"Kostnadskategori\",\"2. Löpande verksamhetskostnader\")","v":0},{"$f":"SUM(J129:O129)","v":0}]
[{"$nulls":3},"Payback-år",{"$f":"IF('-Admin-'!D109=0,\"Ingen payback\",'-Admin-'!D109)","v":2026},{"$nulls":3},"Investeringar",{"$f":"-GETPIVOTDATA(\"Summa av År 1\",'-Admin-'!$C$41,\"Kostnadskategori\",\"3. Investeringar\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 2\",'-Admin-'!$C$41,\"Kostnadskategori\",\"3. Investeringar\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 3\",'-Admin-'!$C$41,\"Kostnadskategori\",\"3. Investeringar\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 4\",'-Admin-'!$C$41,\"Kostnadskategori\",\"3. Investeringar\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 5\",'-Admin-'!$C$41,\"Kostnadskategori\",\"3. Investeringar\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 6\",'-Admin-'!$C$41,\"Kostnadskategori\",\"3. Investeringar\")","v":0},{"$f":"SUM(J130:O130)","v":0}]
[{"$nulls":8},"Projekt",{"$f":"-GETPIVOTDATA(\"Summa av År 1\",'-Admin-'!$C$41,\"Kostnadskategori\",\"4. Projekt\")","v":{"v":-15000000,"d":"-15,000,000 "}},{"$f":"-GETPIVOTDATA(\"Summa av År 2\",'-Admin-'!$C$41,\"Kostnadskategori\",\"4. Projekt\")","v":{"v":-30000000,"d":"-30,000,000 "}},{"$f":"-GETPIVOTDATA(\"Summa av År 3\",'-Admin-'!$C$41,\"Kostnadskategori\",\"4. Projekt\")","v":{"v":-30000000,"d":"-30,000,000 "}},{"$f":"-GETPIVOTDATA(\"Summa av År 4\",'-Admin-'!$C$41,\"Kostnadskategori\",\"4. Projekt\")","v":{"v":-10600000,"d":"-10,600,000 "}},{"$f":"-GETPIVOTDATA(\"Summa av År 5\",'-Admin-'!$C$41,\"Kostnadskategori\",\"4. Projekt\")","v":0},{"$f":"-GETPIVOTDATA(\"Summa av År 6\",'-Admin-'!$C$41,\"Kostnadskategori\",\"4. Projekt\")","v":0},{"v":-85600000,"d":"-85,600,000 "}]
[]
[{"$nulls":8},"Omfördelnings-nettonytta",{"$f":"J125+J127","v":{"v":-15000000,"d":"-15,000,000 "}},{"v":-30000000,"d":"-30,000,000 "},{"v":-11311694,"d":"-11,311,694 "},{"v":18893406,"d":"18,893,406 "},{"v":29493406,"d":"29,493,406 "},{"v":29493406,"d":"29,493,406 "},{"v":21568524,"d":"21,568,524 "}]
[{"$nulls":8},"Ackumulerad omfördelnings-nettonytta",{"$f":"J133","v":{"v":-15000000,"d":"-15,000,000 "}},{"$f":"IF(K133=0,\"\",J134+K133)","v":{"v":-45000000,"d":"-45,000,000 "}},{"$f":"IF(L133=0,\"\",K134+L133)","v":{"v":-56311694,"d":"-56,311,694 "}},{"$f":"IF(M133=0,\"\",L134+M133)","v":{"v":-37418288,"d":"-37,418,288 "}},{"$f":"IF(N133=0,\"\",M134+N133)","v":{"v":-7924882,"d":"-7,924,882 "}},{"$f":"IF(O133=0,\"\",N134+O133)","v":{"v":21568524,"d":"21,568,524 "}},{"$f":"O134","v":{"v":21568524,"d":"21,568,524 "}}]

{"sheet":"-Admin-","index":5,"n_rows":110,"n_cols":13,"rows_kept":110,"hidden":true}
[null,null,"Admin"]
[null,null,"I den här fliken finns stödfunktioner som används i kalkylen. Dessa bör normalt sett inte redigeras. Om de redigeras kommer de påverka hur mallen fungerar. "]
[]
[]
[null,null,"Underlag för rullister i mallen"]
[null,null,"Fördefinierade värden i rullisterna"]
[]
[null,null,"Intressenter"]
[null,null,"Inera"]
[null,null,"Region"]
[null,null,"Kommun"]
[null,null,"Invånare"]
[null,null,"Statlig myndighet"]
[null,null,"Vårdenhet"]
[null,null,"Intresseorganisation"]
[null,null,"Samhället"]
[]
[null,null,"Nyttokategori"]
[null,null,"1. Finansiell"]
[null,null,"2. Omfördelningsnytta"]
[null,null,"3. Kvalitativ, mätbar"]
[]
[null,null,"Kostnadskategori"]
[null,null,"1. Verksamhetsförändring"]
[null,null,"2. Löpande verksamhetskostnader"]
[null,null,"3. Investeringar"]
[null,null,"4. Projekt"]
[]
[]
[null,null,"Underlag för nyttorealiseringskalkylen"]
[]
[null,null,"Nyttor (finansiella och omfördelningsnyttor)"]
[]
[null,null,"Radetiketter","Summa av år 1","Summa av År 2","Summa av År 3","Summa av År 4","Summa av År 5","Summa av År 6"]
[null,null,"2. Omfördelningsnytta",0,0,{"v":18688306,"d":"18,688,306 "},{"v":29493406,"d":"29,493,406 "},{"v":29493406,"d":"29,493,406 "},{"v":29493406,"d":"29,493,406 "}]
[null,null,"1. Finansiell",0,0,{"v":9569475.333333334,"d":"9,569,475 "},{"v":44269475.333333336,"d":"44,269,475 "},{"v":47194475.333333336,"d":"47,194,475 "},{"v":47194475.333333336,"d":"47,194,475 "}]
[]
[]
[null,null,"Kostnader"]
[]
[null,null,"Radetiketter","Summa av År 1","Summa av År 2","Summa av År 3","Summa av År 4","Summa av År 5","Summa av År 6"]
[null,null,"1. Verksamhetsförändring"]
[null,null,"2. Löpande verksamhetskostnader"]
[null,null,"3. Investeringar"]
[null,null,"4. Projekt",{"v":15000000,"d":"15,000,000 "},{"v":30000000,"d":"30,000,000 "},{"v":30000000,"d":"30,000,000 "},{"v":10600000,"d":"10,600,000 "}]
[]
[]
[]
[null,null,"Underlag för  några av diagrammen - övriga diagram hämtar sin data från sammanställningen på fliken Nyttoreaslieringskalkyl"]
[]
[null,null,"Diagram \"Nyttor och kostnader\"",{"$nulls":5},"Diagram \"Nytta per intressent\"",null,null,"Diagram \"Kostnad per intressent\""]
[]
[{"$nulls":3},"Finansiell nytta","Omfördelningsnytta","Total nytta","Kostnad",null,"Radetiketter","Summa av Summa",null,"Radetiketter","Summa av Summa"]
[null,null,"Nytta",{"$f":"Nyttorealiseringskalkyl!$P$13","v":{"v":148227901.33333334,"d":"148,227,901 "}},{"$f":"Nyttorealiseringskalkyl!$P$14","v":{"v":107168524,"d":"107,168,524 "}},{"$f":"D54+E54","v":{"v":255396425.33333334,"d":"255,396,425 "}},null,null,"Regioner",{"v":106921224,"d":"106,921,224 "},null,"Inera",{"v":85600000,"d":"85,600,000 "}]
[null,null,"Kostnad",{"$nulls":3},{"$f":"-1*TotalKostnad","v":{"v":85600000,"d":"85,600,000 "}},null,"Inera",{"v":67475201.33333334,"d":"67,475,201 "},null,"Totalsumma",{"v":85600000,"d":"85,600,000 "}]
[{"$nulls":8},"Kommuner",{"v":81000000,"d":"81,000,000 "}]
[{"$nulls":8},"Totalsumma",{"v":255396425.33333334,"d":"255,396,425 "}]
[null,null,"Diagram \"Osäkerhetsanalys\" Alla nyttor"]
[]
[{"$nulls":3},"Nytta","Kostnad","Nettonytta"]
[null,null,"Min",{"$f":"Tabell10[[#Totals],[Min]]","v":{"v":131118716.53333333,"d":"131,118,717 "}},{"$f":"Tabell109[[#Totals],[Min]]","v":{"v":85600000,"d":"85,600,000 "}},{"$f":"D61-E63","v":{"v":45518716.53333333,"d":"45,518,717 "}}]
[null,null,"Troligt",{"$f":"Tabell10[[#Totals],[Summa]]","v":{"v":255396425.33333334,"d":"255,396,425 "}},{"$f":"Tabell109[[#Totals],[Summa]]","v":{"v":85600000,"d":"85,600,000 "}},{"$f":"D62-E62","v":{"v":169796425.33333334,"d":"169,796,425 "}}]
[null,null,"Max",{"$f":"Tabell10[[#Totals],[Max]]","v":{"v":415492640.8,"d":"415,492,641 "}},{"$f":"Tabell109[[#Totals],[Max]]","v":{"v":85600000,"d":"85,600,000 "}},{"$f":"D63-E61","v":{"v":329892640.8,"d":"329,892,641 "}}]
[]
[null,null,"Pivottabell som underlag till diagram \"osäkerhetsanalys\" - finansiella nyttor och omfördelningsnyttor. "]
[null,null,"Radetiketter","Summa av Min","Summa av Summa","Summa av Max",null,null,"Diagram \"Finansiell nytta per intressent\"",null,null,"Diagram \"Omfördelningsnytta nytta per intressent\""]
[null,null,"1. Finansiell",{"v":68942901.33333333,"d":"68,942,901 "},{"v":148227901.33333334,"d":"148,227,901 "},{"v":306220488,"d":"306,220,488 "},null,null,"Nyttokategori","1. Finansiell",null,"Nyttokategori","2. Omfördelningsnytta"]
[null,null,"2. Omfördelningsnytta",{"v":62175815.2,"d":"62,175,815 "},{"v":107168524,"d":"107,168,524 "},{"v":109272152.8,"d":"109,272,153 "}]
[null,null,"Totalsumma",{"v":131118716.53333333,"d":"131,118,717 "},{"v":255396425.33333334,"d":"255,396,425 "},{"v":415492640.8,"d":"415,492,641 "},null,null,"Radetiketter","Summa av Summa",null,"Radetiketter","Summa av Summa"]
[{"$nulls":8},"Regioner",{"v":200000,"d":"200,000 "},null,"Regioner",{"v":106721224,"d":"106,721,224 "}]
[{"$nulls":8},"Inera",{"v":67027901.333333336,"d":"67,027,901 "},null,"Inera",{"v":447300,"d":"447,300 "}]
[{"$nulls":8},"Kommuner",{"v":81000000,"d":"81,000,000 "},null,"Totalsumma",{"v":107168524,"d":"107,168,524 "}]
[{"$nulls":8},"Totalsumma",{"v":148227901.33333334,"d":"148,227,901 "}]
[null,null,"Diagram \"Osäkerhetsanalys\" Finansiella nyttor"]
[]
[{"$nulls":3},"Finansiell nytta","Kostnad","Nettonytta"]
[null,null,"Min",{"$f":"GETPIVOTDATA(\"Summa av Min\",$C$66,\"Nyttokategori\",\"1. Finansiell\")","v":{"v":68942901.33333333,"d":"68,942,901 "}},{"$f":"Tabell109[[#Totals],[Min]]","v":{"v":85600000,"d":"85,600,000 "}},{"$f":"D77-E79","v":{"v":-16657098.666666672,"d":"-16,657,099 "}}]
[null,null,"Troligt",{"$f":"GETPIVOTDATA(\"Summa av Summa\",$C$66,\"Nyttokategori\",\"1. Finansiell\")","v":{"v":148227901.33333334,"d":"148,227,901 "}},{"$f":"Tabell109[[#Totals],[Summa]]","v":{"v":85600000,"d":"85,600,000 "}},{"$f":"D78-E78","v":{"v":62627901.33333334,"d":"62,627,901 "}}]
[null,null,"Max",{"$f":"GETPIVOTDATA(\"Summa av Max\",$C$66,\"Nyttokategori\",\"1. Finansiell\")","v":{"v":306220488,"d":"306,220,488 "}},{"$f":"Tabell109[[#Totals],[Max]]","v":{"v":85600000,"d":"85,600,000 "}},{"$f":"D79-E77","v":{"v":220620488,"d":"220,620,488 "}}]
[]
[null,null,"Diagram \"Osäkerhetsanalys\" Omfördelningsnyttor"]
[]
[{"$nulls":3},"Omfördelningsnytta","Kostnad","Nettonytta"]
[null,null,"Min",{"$f":"GETPIVOTDATA(\"Summa av Min\",$C$66,\"Nyttokategori\",\"2. Omfördelningsnytta\")","v":{"v":62175815.2,"d":"62,175,815 "}},{"$f":"Tabell109[[#Totals],[Min]]","v":{"v":85600000,"d":"85,600,000 "}},{"$f":"D84-E86","v":{"v":-23424184.799999997,"d":"-23,424,185 "}}]
[null,null,"Troligt",{"$f":"GETPIVOTDATA(\"Summa av Summa\",$C$66,\"Nyttokategori\",\"2. Omfördelningsnytta\")","v":{"v":107168524,"d":"107,168,524 "}},{"$f":"Tabell109[[#Totals],[Summa]]","v":{"v":85600000,"d":"85,600,000 "}},{"$f":"D85-E85","v":{"v":21568524,"d":"21,568,524 "}}]
[null,null,"Max",{"$f":"GETPIVOTDATA(\"Summa av Max\",$C$66,\"Nyttokategori\",\"2. Omfördelningsnytta\")","v":{"v":109272152.8,"d":"109,272,153 "}},{"$f":"Tabell109[[#Totals],[Max]]","v":{"v":85600000,"d":"85,600,000 "}},{"$f":"D86-E84","v":{"v":23672152.799999997,"d":"23,672,153 "}}]
[]
[null,null,"Underlag för payback-år"]
[null,null,"Alla nyttor"]
[null,null,"Följande rader används för beräkning av Payback-år",{"$f":"Startår","v":2021},{"$f":"D90+1","v":2022},{"$f":"E90+1","v":2023},2024,2025,2026]
[null,null,"Ack. diskonterat kassaflöde > 0?",{"$f":"Nyttorealiseringskalkyl!J27>0","v":false},{"$f":"Nyttorealiseringskalkyl!K27>0","v":false},{"$f":"Nyttorealiseringskalkyl!L27>0","v":false},{"$f":"Nyttorealiseringskalkyl!M27>0","v":true},{"$f":"Nyttorealiseringskalkyl!N27>0","v":true},{"$f":"Nyttorealiseringskalkyl!O27>0","v":true}]
[null,null,"Är detta ett paybackår?",{"$f":"IF(D91=FALSE,\"x\",D90)","v":"x"},{"$f":"IF(E91=FALSE,\"x\",E90)","v":"x"},"x",{"v":2024,"d":"2,024 "},{"v":2025,"d":"2,025 "},{"v":2026,"d":"2,026 "}]
[null,null,"Första paybackår (om något)",{"$f":"MIN(D92:I92)","v":{"v":2024,"d":"2,024 "}}]
[null,null,"Paybackår?",{"$f":"IF('-Admin-'!D93=0,\"Ingen payback\",'-Admin-'!D93)","v":2024}]
[]
[]
[null,null,"Finansiella nyttor"]
[null,null,"Följande rader används för beräkning av Payback-år",{"$f":"Startår","v":2021},{"$f":"D98+1","v":2022},{"$f":"E98+1","v":2023},{"$f":"F98+1","v":2024},{"$f":"G98+1","v":2025},{"$f":"H98+1","v":2026}]
[null,null,"Ack. diskonterat kassaflöde > 0?",{"$f":"Nyttorealiseringskalkyl!J83>0","v":false},{"$f":"Nyttorealiseringskalkyl!K83>0","v":false},{"$f":"Nyttorealiseringskalkyl!L83>0","v":false},{"$f":"Nyttorealiseringskalkyl!M83>0","v":false},{"$f":"Nyttorealiseringskalkyl!N83>0","v":true},{"$f":"Nyttorealiseringskalkyl!O83>0","v":true}]
[null,null,"Är detta ett paybackår?",{"$f":"IF(D99=FALSE,\"x\",D98)","v":"x"},{"$f":"IF(E99=FALSE,\"x\",E98)","v":"x"},"x","x",{"v":2025,"d":"2,025 "},{"v":2026,"d":"2,026 "}]
[null,null,"Första paybackår (om något)",{"$f":"MIN(D100:I100)","v":{"v":2025,"d":"2,025 "}}]
[null,null,"Paybackår?",{"$f":"IF('-Admin-'!D101=0,\"Ingen payback\",'-Admin-'!D101)","v":2025}]
[]
[]
[null,null,"Omfördelningsnyttor"]
[null,null,"Följande rader används för beräkning av Payback-år",{"$f":"Startår","v":2021},{"$f":"D106+1","v":2022},{"$f":"E106+1","v":2023},{"$f":"F106+1","v":2024},{"$f":"G106+1","v":2025},{"$f":"H106+1","v":2026}]
[null,null,"Ack. diskonterat kassaflöde > 0?",{"$f":"Nyttorealiseringskalkyl!J134>0","v":false},{"$f":"Nyttorealiseringskalkyl!K134>0","v":false},{"$f":"Nyttorealiseringskalkyl!L134>0","v":false},{"$f":"Nyttorealiseringskalkyl!M134>0","v":false},{"$f":"Nyttorealiseringskalkyl!N134>0","v":false},{"$f":"Nyttorealiseringskalkyl!O134>0","v":true}]
[null,null,"Är detta ett paybackår?",{"$f":"IF(D107=FALSE,\"x\",D106)","v":"x"},{"$f":"IF(E107=FALSE,\"x\",E106)","v":"x"},"x","x","x",{"v":2026,"d":"2,026 "}]
[null,null,"Första paybackår (om något)",{"$f":"MIN(D108:I108)","v":{"v":2026,"d":"2,026 "}}]
[null,null,"Paybackår?",{"$f":"IF('-Admin-'!D109=0,\"Ingen payback\",'-Admin-'!D109)","v":2026}]