{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Välkommen","1. Alternativ","2. Kriterier","3. Teknisk","4. Social","5. Miljö","6. Ekonomi","7. Viktning","8. Analys & resultat","Känslighetsanalys 1","Känslighetsanalys 2","Beräkningar (rör ej)","Underlag mm","Modellunderlag"],"not_rendered":{"charts":23,"images":0,"macros":1,"external_links":0,"defined_names":139,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Välkommen","index":0,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,1,36,7],[4,1,4,5],[1,1,1,5],[2,1,2,5],[2,7,2,16],[6,1,28,5]]}
[]
[null,"WISER"]
[null,"Version 1.0 - 2021-04-27",null,null,null,null,null,"WISER - Water Investments for Sustainability Enhancement and Reliability"]
[]
[null,"Välkommen till WISER, ett verktyg för att utvärdera och jämföra vattenförsörjningsåtgärder!"]
[]
[null,"WISER är ett verktyg som är framtaget för att utvärdera och jämföra olika vattenförsörjningsåtgärder med avseende på tekniska, miljömässiga, sociala och ekonomiska konsekvenser. Alternativa åtgärder analyseras över en bestämd tidshorisont för att avgöra huruvida åtgärderna leder till en ökad eller minskad hållbarhet i förhållande till ett referensalternativ. Verktyget är probabilistiskt, vilket innebär att det går att ta hänsyn till osäkerheter i de bedömningar som görs. Målet med verktyget är att bidra till välinformerade och transparenta beslut vid val av åtgärdsalternativ för framtida vattenförsörjning, dvs. ge beslutsstöd.\n\nIllustrationen till höger visar de 8 steg som ingår i verktyget samt hur lagar m.m. påverkar analysen och hur resultatet utgör underlag för granskning och beslut. Starta analysen genom att klicka på startknappen nedan eller ett av de 8 stegen till höger.\n\nManual och ytterligare information om WISER finns på DRICKS hemsida: https://www.chalmers.se/sv/centrum/dricks/wiser/Sidor/default.aspx"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Vid frågor eller synpunkter på verktyget, kontaktakta:\nAndreas Lindhe (Chalmers), andreas.lindhe@chalmers.se \nKarin Sjöstrand (RISE), karin.sjostrand@rise.se"]

{"sheet":"1. Alternativ","index":1,"n_rows":25,"n_cols":23,"rows_kept":25,"cut":false,"hidden":false,"merged":[[4,4,4,22],[10,4,11,22],[6,4,8,22],[13,4,15,22],[17,4,20,22],[26,20,40,22],[10,1,11,2],[26,4,40,6],[26,8,40,10],[26,12,40,14],[26,16,40,18],[24,4,24,6],[24,8,24,10],[24,12,24,14],[24,16,24,18],[24,20,24,22]]}
[]
[null,"1. Beskrivning av alternativ m.m."]
[null,"Här beskrivs bl.a. syftet med analysen samt referensalternativet och de åtgärdsalternativ som ska analyseras."]
[]
[null,null,"Titel på analys"]
[]
[]
[null,null,"Deltagare"]
[]
[]
[null,"Område/system"]
[]
[]
[]
[null,null,"Syfte"]
[]
[]
[]
[null,null,"Referensalternativ"]
[]
[]
[]
[null,null,"Åtgärdsalternativ",null,null,null,true,null,null,null,true,null,null,null,false,null,null,null,false,null,null,null,false]
[]
[null,null,"Namn",null,"Alt. 1",null,null,null,"Alt. 2",null,null,null,"Alt. 3",null,null,null,"Alt. 4",null,null,null,"Alt. 5"]

{"sheet":"2. Kriterier","index":2,"n_rows":67,"n_cols":6,"rows_kept":67,"cut":false,"hidden":false,"merged":[[64,5,64,15],[65,5,65,15],[66,5,66,15],[67,5,67,15],[61,5,61,15],[62,5,62,15],[63,5,63,15],[17,5,17,15],[25,5,25,15],[12,5,12,15],[13,5,13,15],[14,5,14,15],[15,5,15,15],[16,5,16,15],[9,5,9,15],[10,5,10,15],[11,5,11,15],[47,5,47,15],[26,5,26,15],[27,5,27,15],[28,5,28,15],[29,5,29,15],[30,5,30,15],[31,5,31,15],[32,5,32,15],[44,5,44,15],[45,5,45,15],[46,5,46,15],[33,5,33,15],[34,5,34,15],[35,5,35,15],[36,5,36,15],[54,5,54,15],[55,5,55,15],[56,5,56,15],[48,5,48,15],[49,5,49,15],[50,5,50,15],[51,5,51,15],[52,5,52,15],[53,5,53,15]]}
[]
[null,"2. Val av kriterier"]
[null,"Välj de kriterier som ska ingå i analysen och komplettera vid behov med ytterligare kriteirer. Nya kriterier får inte överlappa befintliga."]
[]
[]
[null,"Tekniska kriterier"]
[]
[null,null,null,"Kriterium",null,"Beskrivning"]
[]
[null,true,null,"Leveranssäkerhet",null,"Systemets förmåga att leverera vatten vid störningar i en eller flera delar av systemet (råvatten, beredning, distribution)."]
[null,true,null,"Sabotage",null,"Systemets motståndskraft mot sabotagerisk."]
[null,true,null,"Anpassningsförmåga",null,"Förmåga att prestera tillfredsställande under omvärldsförändringar."]
[null,true,null,"Tillstånd",null,"Möjligheten att få nödvändiga tillstånd såsom vattendom."]
[null,true,null,"Rådighet",null,"Rådighet och påverkansmöjlighet kring systemet."]
[null,true,null,"Tid till idrifttagande",null,"Tidplanen för genomförandet i relation till när åtgärden behöver vara i drift för att klara vattenförsörjningen."]
[null,false,null,"Ytterligare kriterium",null,"Lägg till beskrivning"]
[null,false,null,"Ytterligare kriterium",null,"Lägg till beskrivning"]
[null,false,null,"Ytterligare kriterium",null,"Lägg till beskrivning"]
[]
[]
[]
[null,"Sociala kriterier"]
[]
[null,null,null,"Kriterium",null,"Beskrivning"]
[]
[null,true,null,"Upplevd trygghet",null,"Effekter på allmänhetens och konsumenternas tillit och förtroende för vattenproducenter och leverantörer."]
[null,true,null,"Skydd mot mikrobiologiska hälsorisker",null,"Barriärverkan med hänsyn till råvattenkvaliteten."]
[null,true,null,"Skydd mot kemiska hälsorisker",null,"Barriärverkan med hänsyn till både bakgrundsbelastningen av kemiska ämnen och akuta utsläpp."]
[null,true,null,"Andra dricksvattenparametrar",null,"Lukt, smak och andra kvalitetsaspekter."]
[null,true,null,"Icke-dricksvattenrelaterade hälsoeffekter",null,"Icke-dricksvattenrelaterade effekter på människors hälsa, från t.ex. luftföroreningar och buller."]
[null,true,null,"Icke-dricksvattenrelaterade hälsoeffekter ",null,"Icke-dricksvattenrelaterade effekter på människors hälsa till följd av åtgärden."]
[null,true,null,"Tillväxtpotential",null,"Utvecklingspotential för näringsliv, bostäder och offentlig sektor."]
[null,true,null,"Rekreationsvärden",null,"Effekter på områden av värde för det rörliga friluftslivet."]
[null,true,null,"Fördelningseffekter",null,"Effekter med hänsyn till om vissa delar av samhället missgynnas av åtgärden."]
[null,false,null,"Ytterligare kriterium",null,"Lägg till beskrivning"]
[null,false,null,"Ytterligare kriterium",null,"Lägg till beskrivning"]
[null,false,null,"Ytterligare kriterium",null,"Lägg till beskrivning"]
[]
[]
[]
[null,"Miljömässiga kriterier"]
[]
[null,null,null,"Kriterium",null,"Beskrivning"]
[]
[null,true,null,"Vattenresursers kvalitet",null,"Effekter på berörda vattenresursers kvalitet (råvattentäkter såväl som andra grund-och ytvattenresurser) ."]
[null,true,null,"Vattenresursers kvantitet",null,"Balans mellan tillgång och uttag i yt- och grundvattenresurser, samt andra faktorer som kan påverka berörda vattenresursers kvantitet."]
[null,true,null,"Terrestra ekosystems livsduglighet",null,"Effekter på flora, fauna, livsmiljöer och biologisk mångfald."]
[null,true,null,"Energianvändning och växthusgasutsläpp",null,"Effekter på energiförbrukning och växthusgasutsläpp."]
[null,true,null,"Vattenanvändning",null,"Effekter på vattenbehov och vattenanvändning."]
[null,true,null,"Markanvändning",null,"Arealen mark som tas i anspråk."]
[null,true,null,"Materialanvändning",null,"Användning av icke förnybara material."]
[null,true,null,"Kemikalieanvändning",null,"Kemikalieanvändning vid produktion."]
[null,true,null,"Icke-återvinningsbart avfall",null,"Produktion av icke-återvinningsbart avfall."]
[null,false,null,"Ytterligare kriterium",null,"Lägg till beskrivning"]
[null,false,null,"Ytterligare kriterium",null,"Lägg till beskrivning"]
[null,false,null,"Ytterligare kriterium",null,"Lägg till beskrivning"]
[]
[]
[]
[null,"Ekonomiska kriterier"]
[]
[null,true,null,"Investeringskostnader",null,"Investeringskostnader till följd av åtgärdsimplementering."]
[null,true,null,"Drift- och underhållskostnader",null,"Löpande kostnader till följd av drift och underhåll."]
[null,false,null,"Ytterligare kriterium",null,"Lägg till beskrivning"]
[null,false,null,"Ytterligare kriterium",null,"Lägg till beskrivning"]
[null,false,null,"Ytterligare kriterium",null,"Lägg till beskrivning"]
[null,false,null,"Ytterligare kriterium",null,"Lägg till beskrivning"]

{"sheet":"3. Teknisk","index":3,"n_rows":18,"n_cols":27,"rows_kept":18,"cut":false,"hidden":false,"merged":[[4,5,4,7],[4,9,4,11],[4,13,4,15],[4,17,4,19],[4,21,4,23],[5,5,5,7],[5,9,5,11],[5,13,5,15],[5,17,5,19],[5,21,5,23]]}
[]
[null,"3. Teknisk analys"]
[null,"Poängsätt varje alternativ med avseende på de ingående kriterierna. För att ta hänsyn till osäkerheter bedöms lägsta (min) och högsta (max) rimliga poäng samt det mest troliga poänget."]
[]
[null,null,null,null,null,"Alternativ 1",null,null,null,"Alternativ 2",null,null,null,"Alterantiv 3",null,null,null,"Alternativ 4",null,null,null,"Alternativ 5"]
[null,null,null,null,null,{"$f":"namn1","v":"Alt. 1"},null,null,null,{"$f":"namn2","v":"Alt. 2"},null,null,null,{"$f":"namn3","v":"Alt. 3"},null,null,null,{"$f":"namn4","v":"Alt. 4"},null,null,null,{"$f":"namn5","v":"Alt. 5"}]
[]
[null,"Kriterium","Indikatorer","Kommentarer",null,"Min","Mest\ntroliga","Max",null,"Min","Mest\ntroliga","Max",null,"Min","Mest\ntroliga","Max",null,"Min","Mest\ntroliga","Max",null,"Min","Mest\ntroliga","Max"]
[]
[null,{"$f":"'2. Kriterier'!D10","v":"Leveranssäkerhet"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B10","v":true}]
[null,{"$f":"'2. Kriterier'!D11","v":"Sabotage"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B11","v":true}]
[null,{"$f":"'2. Kriterier'!D12","v":"Anpassningsförmåga"},null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B12","v":true}]
[null,{"$f":"'2. Kriterier'!D13","v":"Tillstånd"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B13","v":true}]
[null,{"$f":"'2. Kriterier'!D14","v":"Rådighet"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B14","v":true}]
[null,{"$f":"'2. Kriterier'!D15","v":"Tid till idrifttagande"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B15","v":true}]
[null,{"$f":"'2. Kriterier'!D16","v":"Ytterligare kriterium"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B16","v":false}]
[null,{"$f":"'2. Kriterier'!D17","v":"Ytterligare kriterium"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B17","v":false}]
[null,{"$f":"'2. Kriterier'!D18","v":"Ytterligare kriterium"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B18","v":false}]

{"sheet":"4. Social","index":4,"n_rows":21,"n_cols":27,"rows_kept":21,"cut":false,"hidden":false,"merged":[[5,5,5,7],[5,9,5,11],[5,13,5,15],[5,17,5,19],[5,21,5,23],[4,5,4,7],[4,9,4,11],[4,13,4,15],[4,17,4,19],[4,21,4,23]]}
[]
[null,"4. Social analys"]
[null,"Poängsätt varje alternativ med avseende på de ingående kriterierna. För att ta hänsyn till osäkerheter bedöms lägsta (min) och högsta (max) rimliga poäng samt det mest troliga poänget."]
[]
[null,null,null,null,null,"Alternativ 1",null,null,null,"Alternativ 2",null,null,null,"Alternativ 3",null,null,null,"Alternativ 4",null,null,null,"Alternativ 5"]
[null,null,null,null,null,{"$f":"namn1","v":"Alt. 1"},null,null,null,{"$f":"namn2","v":"Alt. 2"},null,null,null,{"$f":"namn3","v":"Alt. 3"},null,null,null,{"$f":"namn4","v":"Alt. 4"},null,null,null,{"$f":"namn5","v":"Alt. 5"}]
[]
[null,"Kriterium","Indikatorer","Kommentarer",null,"Min","Mest\ntroliga","Max",null,"Min","Mest\ntroliga","Max",null,"Min","Mest\ntroliga","Max",null,"Min","Mest\ntroliga","Max",null,"Min","Mest\ntroliga","Max"]
[]
[null,{"$f":"'2. Kriterier'!D26","v":"Upplevd trygghet"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B26","v":true}]
[null,{"$f":"'2. Kriterier'!D27","v":"Skydd mot mikrobiologiska hälsorisker"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B27","v":true}]
[null,{"$f":"'2. Kriterier'!D28","v":"Skydd mot kemiska hälsorisker"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B28","v":true}]
[null,{"$f":"'2. Kriterier'!D29","v":"Andra dricksvattenparametrar"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B29","v":true}]
[null,{"$f":"'2. Kriterier'!D30","v":"Icke-dricksvattenrelaterade hälsoeffekter"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B30","v":true}]
[null,{"$f":"'2. Kriterier'!D31","v":"Icke-dricksvattenrelaterade hälsoeffekter "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B31","v":true}]
[null,{"$f":"'2. Kriterier'!D32","v":"Tillväxtpotential"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B32","v":true}]
[null,{"$f":"'2. Kriterier'!D33","v":"Rekreationsvärden"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B33","v":true}]
[null,{"$f":"'2. Kriterier'!D34","v":"Fördelningseffekter"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B34","v":true}]
[null,{"$f":"'2. Kriterier'!D35","v":"Ytterligare kriterium"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B35","v":false}]
[null,{"$f":"'2. Kriterier'!D36","v":"Ytterligare kriterium"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B36","v":false}]
[null,{"$f":"'2. Kriterier'!D37","v":"Ytterligare kriterium"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B37","v":false}]

{"sheet":"5. Miljö","index":5,"n_rows":21,"n_cols":27,"rows_kept":21,"cut":false,"hidden":false,"merged":[[5,5,5,7],[5,9,5,11],[5,13,5,15],[5,17,5,19],[5,21,5,23],[4,5,4,7],[4,9,4,11],[4,13,4,15],[4,17,4,19],[4,21,4,23]]}
[]
[null,"5. Miljömässig analys"]
[null,"Poängsätt varje alternativ med avseende på de ingående kriterierna. För att ta hänsyn till osäkerheter bedöms lägsta (min) och högsta (max) rimliga poäng samt det mest troliga poänget."]
[]
[null,null,null,null,null,"Alternativ 1",null,null,null,"Alternativ 2",null,null,null,"Alternativ 3",null,null,null,"Alternativ 4",null,null,null,"Alternativ 5"]
[null,null,null,null,null,{"$f":"namn1","v":"Alt. 1"},null,null,null,{"$f":"namn2","v":"Alt. 2"},null,null,null,{"$f":"namn3","v":"Alt. 3"},null,null,null,{"$f":"namn4","v":"Alt. 4"},null,null,null,{"$f":"namn5","v":"Alt. 5"}]
[]
[null,"Kriterium","Indikatorer","Kommentarer",null,"Min","Mest\ntroliga","Max",null,"Min","Mest\ntroliga","Max",null,"Min","Mest\ntroliga","Max",null,"Min","Mest\ntroliga","Max",null,"Min","Mest\ntroliga","Max"]
[]
[null,{"$f":"'2. Kriterier'!D45","v":"Vattenresursers kvalitet"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B45","v":true}]
[null,{"$f":"'2. Kriterier'!D46","v":"Vattenresursers kvantitet"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B46","v":true}]
[null,{"$f":"'2. Kriterier'!D47","v":"Terrestra ekosystems livsduglighet"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B47","v":true}]
[null,{"$f":"'2. Kriterier'!D48","v":"Energianvändning och växthusgasutsläpp"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B48","v":true}]
[null,{"$f":"'2. Kriterier'!D49","v":"Vattenanvändning"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B49","v":true}]
[null,{"$f":"'2. Kriterier'!D50","v":"Markanvändning"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B50","v":true}]
[null,{"$f":"'2. Kriterier'!D51","v":"Materialanvändning"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B51","v":true}]
[null,{"$f":"'2. Kriterier'!D52","v":"Kemikalieanvändning"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B52","v":true}]
[null,{"$f":"'2. Kriterier'!D53","v":"Icke-återvinningsbart avfall"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B53","v":true}]
[null,{"$f":"'2. Kriterier'!D54","v":"Ytterligare kriterium"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B54","v":false}]
[null,{"$f":"'2. Kriterier'!D55","v":"Ytterligare kriterium"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B55","v":false}]
[null,{"$f":"'2. Kriterier'!D56","v":"Ytterligare kriterium"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B56","v":false}]

{"sheet":"6. Ekonomi","index":6,"n_rows":15,"n_cols":26,"rows_kept":15,"cut":false,"hidden":false,"merged":[[4,4,4,6],[4,8,4,10],[4,12,4,14],[4,16,4,18],[4,20,4,22],[5,4,5,6],[5,8,5,10],[5,12,5,14],[5,16,5,18],[5,20,5,22]]}
[]
[null,"6. Ekonomisk analys"]
[null,"Kostnaderna anges som kkr/år."]
[]
[null,null,null,null,"Alternativ 1",null,null,null,"Alternativ 2",null,null,null,"Alternativ 3",null,null,null,"Alternativ 4",null,null,null,"Alternativ 5"]
[null,null,null,null,{"$f":"namn1","v":"Alt. 1"},null,null,null,{"$f":"namn2","v":"Alt. 2"},null,null,null,{"$f":"namn3","v":"Alt. 3"},null,null,null,{"$f":"namn4","v":"Alt. 4"},null,null,null,{"$f":"namn5","v":"Alt. 5"}]
[]
[null,"Kriterium","Kommentarer",null,"Min","Mest\ntroliga","Max",null,"Min","Mest\ntroliga","Max",null,"Min","Mest\ntroliga","Max",null,"Min","Mest\ntroliga","Max",null,"Min","Mest\ntroliga","Max"]
[]
[null,{"$f":"'2. Kriterier'!D62","v":"Investeringskostnader"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B62","v":true}]
[null,{"$f":"'2. Kriterier'!D63","v":"Drift- och underhållskostnader"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B63","v":true}]
[null,{"$f":"'2. Kriterier'!D64","v":"Ytterligare kriterium"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B64","v":false}]
[null,{"$f":"'2. Kriterier'!D65","v":"Ytterligare kriterium"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B65","v":false}]
[null,{"$f":"'2. Kriterier'!D66","v":"Ytterligare kriterium"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B66","v":false}]
[null,{"$f":"'2. Kriterier'!D67","v":"Ytterligare kriterium"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B67","v":false}]

{"sheet":"7. Viktning","index":7,"n_rows":69,"n_cols":22,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[]
[null,"6. Viktning"]
[null,"Vikta de olika dimensionerna samt de ingående kriterierna inom respektive dimension genom att ange relativa vikter."]
[]
[null,"Tekniska kriterier","Angiven vikt \n(0-10)",null,"Vikt\n(%)"]
[]
[null,{"$f":"'2. Kriterier'!D10","v":"Leveranssäkerhet"},5,{"$f":"IF(G7=TRUE,C7,0)","v":5},{"$f":"IF(G7=TRUE,D7/$D$16,0)","v":0.16666666666666666},null,{"$f":"'2. Kriterier'!B10","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B9","v":0}]
[null,{"$f":"'2. Kriterier'!D11","v":"Sabotage"},5,5,0.16666666666666666,null,{"$f":"'2. Kriterier'!B11","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B10","v":true}]
[null,{"$f":"'2. Kriterier'!D12","v":"Anpassningsförmåga"},5,5,0.16666666666666666,null,{"$f":"'2. Kriterier'!B12","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B11","v":true}]
[null,{"$f":"'2. Kriterier'!D13","v":"Tillstånd"},5,5,0.16666666666666666,null,{"$f":"'2. Kriterier'!B13","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B12","v":true}]
[null,{"$f":"'2. Kriterier'!D14","v":"Rådighet"},5,5,0.16666666666666666,null,{"$f":"'2. Kriterier'!B14","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B13","v":true}]
[null,{"$f":"'2. Kriterier'!D15","v":"Tid till idrifttagande"},5,5,0.16666666666666666,null,{"$f":"'2. Kriterier'!B15","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B14","v":true}]
[null,{"$f":"'2. Kriterier'!D16","v":"Ytterligare kriterium"},0,0,0,null,{"$f":"'2. Kriterier'!B16","v":false},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B15","v":true}]
[null,{"$f":"'2. Kriterier'!D17","v":"Ytterligare kriterium"},0,0,0,null,{"$f":"'2. Kriterier'!B17","v":false},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B16","v":false}]
[null,{"$f":"'2. Kriterier'!D18","v":"Ytterligare kriterium"},0,0,0,null,{"$f":"'2. Kriterier'!B18","v":false}]
[null,null,null,{"$f":"SUM(D7:D15)","v":30},{"$f":"SUM(E7:E15)","v":0.99999999999999989}]
[]
[]
[null,"Sociala kriterier","Angiven vikt \n(0-10)",null,"Vikt\n(%)"]
[]
[null,{"$f":"'2. Kriterier'!D26","v":"Upplevd trygghet"},5,{"$f":"IF(G21=TRUE,C21,0)","v":5},{"$f":"IF(G21=TRUE,D21/$D$33,0)","v":0.1111111111111111},null,{"$f":"'2. Kriterier'!B26","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B26","v":true}]
[null,{"$f":"'2. Kriterier'!D27","v":"Skydd mot mikrobiologiska hälsorisker"},5,{"$f":"IF(G22=TRUE,C22,0)","v":5},0.1111111111111111,null,{"$f":"'2. Kriterier'!B27","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B27","v":true}]
[null,{"$f":"'2. Kriterier'!D28","v":"Skydd mot kemiska hälsorisker"},5,5,0.1111111111111111,null,{"$f":"'2. Kriterier'!B28","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B28","v":true}]
[null,{"$f":"'2. Kriterier'!D29","v":"Andra dricksvattenparametrar"},5,5,0.1111111111111111,null,{"$f":"'2. Kriterier'!B29","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B29","v":true}]
[null,{"$f":"'2. Kriterier'!D30","v":"Icke-dricksvattenrelaterade hälsoeffekter"},5,5,0.1111111111111111,null,{"$f":"'2. Kriterier'!B30","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B30","v":true}]
[null,{"$f":"'2. Kriterier'!D31","v":"Icke-dricksvattenrelaterade hälsoeffekter "},5,5,0.1111111111111111,null,{"$f":"'2. Kriterier'!B31","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B31","v":true}]
[null,{"$f":"'2. Kriterier'!D32","v":"Tillväxtpotential"},5,5,0.1111111111111111,null,{"$f":"'2. Kriterier'!B32","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B32","v":true}]
[null,{"$f":"'2. Kriterier'!D33","v":"Rekreationsvärden"},5,5,0.1111111111111111,null,{"$f":"'2. Kriterier'!B33","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B33","v":true}]
[null,{"$f":"'2. Kriterier'!D34","v":"Fördelningseffekter"},5,5,0.1111111111111111,null,{"$f":"'2. Kriterier'!B34","v":true}]
[null,{"$f":"'2. Kriterier'!D35","v":"Ytterligare kriterium"},0,0,0,null,{"$f":"'2. Kriterier'!B35","v":false}]
[null,{"$f":"'2. Kriterier'!D36","v":"Ytterligare kriterium"},0,0,0,null,{"$f":"'2. Kriterier'!B36","v":false}]
[null,{"$f":"'2. Kriterier'!D37","v":"Ytterligare kriterium"},0,0,0,null,{"$f":"'2. Kriterier'!B37","v":false}]
[null,null,null,{"$f":"SUM(D21:D32)","v":45},{"$f":"SUM(E21:E32)","v":1.0000000000000002}]
[]
[]
[null,"Miljömässiga kriterier","Angiven vikt \n(0-10)",null,"Vikt\n(%)"]
[]
[null,{"$f":"'2. Kriterier'!D45","v":"Vattenresursers kvalitet"},5,{"$f":"IF(G38=TRUE,C38,0)","v":5},{"$f":"IF(G38=TRUE,D38/$D$50,0)","v":0.1111111111111111},null,{"$f":"'2. Kriterier'!B45","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B45","v":true}]
[null,{"$f":"'2. Kriterier'!D46","v":"Vattenresursers kvantitet"},5,{"$f":"IF(G39=TRUE,C39,0)","v":5},0.1111111111111111,null,{"$f":"'2. Kriterier'!B46","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B46","v":true}]
[null,{"$f":"'2. Kriterier'!D47","v":"Terrestra ekosystems livsduglighet"},5,5,0.1111111111111111,null,{"$f":"'2. Kriterier'!B47","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B47","v":true}]
[null,{"$f":"'2. Kriterier'!D48","v":"Energianvändning och växthusgasutsläpp"},5,5,0.1111111111111111,null,{"$f":"'2. Kriterier'!B48","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B48","v":true}]
[null,{"$f":"'2. Kriterier'!D49","v":"Vattenanvändning"},5,5,0.1111111111111111,null,{"$f":"'2. Kriterier'!B49","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B49","v":true}]
[null,{"$f":"'2. Kriterier'!D50","v":"Markanvändning"},5,5,0.1111111111111111,null,{"$f":"'2. Kriterier'!B50","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B50","v":true}]
[null,{"$f":"'2. Kriterier'!D51","v":"Materialanvändning"},5,5,0.1111111111111111,null,{"$f":"'2. Kriterier'!B51","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B51","v":true}]
[null,{"$f":"'2. Kriterier'!D52","v":"Kemikalieanvändning"},5,5,0.1111111111111111,null,{"$f":"'2. Kriterier'!B52","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B52","v":true}]
[null,{"$f":"'2. Kriterier'!D53","v":"Icke-återvinningsbart avfall"},5,5,0.1111111111111111,null,{"$f":"'2. Kriterier'!B53","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B53","v":true}]
[null,{"$f":"'2. Kriterier'!D54","v":"Ytterligare kriterium"},0,0,0,null,{"$f":"'2. Kriterier'!B54","v":false},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B54","v":false}]
[null,{"$f":"'2. Kriterier'!D55","v":"Ytterligare kriterium"},0,0,0,null,{"$f":"'2. Kriterier'!B55","v":false},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B55","v":false}]
[null,{"$f":"'2. Kriterier'!D56","v":"Ytterligare kriterium"},0,0,0,null,{"$f":"'2. Kriterier'!B56","v":false},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B56","v":false}]
[null,null,null,{"$f":"SUM(D38:D49)","v":45},{"$f":"SUM(E38:E49)","v":1.0000000000000002}]
[]
[]
[null,"Ekonomiska kriterier","Angiven vikt \n(0-10)",null,"Vikt\n(%)"]
[]
[null,{"$f":"'2. Kriterier'!D62","v":"Investeringskostnader"},5,{"$f":"IF(G55=TRUE,C55,0)","v":5},{"$f":"IF(G55=TRUE,D55/$D$61,0)","v":0.5},null,{"$f":"'2. Kriterier'!B62","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B59","v":0}]
[null,{"$f":"'2. Kriterier'!D63","v":"Drift- och underhållskostnader"},5,{"$f":"IF(G56=TRUE,C56,0)","v":5},0.5,null,{"$f":"'2. Kriterier'!B63","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B60","v":"Ekonomiska kriterier"}]
[null,{"$f":"'2. Kriterier'!D64","v":"Ytterligare kriterium"},0,0,0,null,{"$f":"'2. Kriterier'!B64","v":false},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B61","v":0}]
[null,{"$f":"'2. Kriterier'!D65","v":"Ytterligare kriterium"},0,0,0,null,{"$f":"'2. Kriterier'!B65","v":false},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B62","v":true}]
[null,{"$f":"'2. Kriterier'!D66","v":"Ytterligare kriterium"},0,0,0,null,{"$f":"'2. Kriterier'!B66","v":false},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B63","v":true}]
[null,{"$f":"'2. Kriterier'!D67","v":"Ytterligare kriterium"},0,0,0,null,{"$f":"'2. Kriterier'!B67","v":false},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2. Kriterier'!B64","v":false}]
[null,null,null,{"$f":"SUM(D55:D60)","v":10},{"$f":"SUM(E55:E60)","v":1}]
[]
[]
[null,"Dimensioner","Angiven vikt \n(0-10)",null,"Vikt\n(%)"]
[]
[null,"Teknisk",5,{"$f":"IF(tcheck=TRUE,C66,0)","v":5},{"$f":"IF(tcheck=TRUE,D66/SUM($D$66:$D$69),0)","v":0.25}]
[null,"Social",5,{"$f":"IF(scheck=TRUE,C67,0)","v":5},{"$f":"IF(scheck=TRUE,D67/SUM($D$66:$D$69),0)","v":0.25}]
[null,"Miljömässig",5,{"$f":"IF(mcheck=TRUE,C68,0)","v":5},{"$f":"IF(mcheck=TRUE,D68/SUM($D$66:$D$69),0)","v":0.25}]
[null,"Ekonomisk",5,{"$f":"IF(echeck=TRUE,C69,0)","v":5},{"$f":"IF(echeck=TRUE,D69/SUM($D$66:$D$69),0)","v":0.25}]

{"sheet":"8. Analys & resultat","index":8,"n_rows":273,"n_cols":8,"rows_kept":273,"cut":false,"hidden":false,"merged":[[2,1,2,5],[3,1,4,9],[194,7,195,12],[220,1,221,6],[220,7,221,12],[40,1,41,6],[40,7,41,12],[71,1,72,12],[10,1,10,12],[169,1,169,12],[103,1,104,6],[103,7,104,12],[134,1,135,6],[134,7,135,12],[165,7,166,12],[165,1,166,6],[272,7,273,12],[272,1,273,6],[246,1,247,6],[246,7,247,12],[194,1,195,6]]}
[]
[null,"8. Analys och resultat"]
[null,"Genomför eller uppdatera beräkningarna genom att välj om resultaten ska presenteras med eller utan osäkerheter:"]
[null,{"$f":"IF(osäk=TRUE,Modellunderlag!O2,Modellunderlag!O3)","v":"Du har inte angett osäkerheter i bedömningarna och ska därför välja alternativet ”Utan osäkerheter” ovan."}]
[]
[]
[null,"Dölj alternativ i grafer:"]
[]
[null,"Gå till känslighetsanalys (kräver att osäkerheter bedömts):"]
[]
[null,"Resultat från beräkningar med osäkerheter"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sammanvägt index de analyserade alternativen.",null,null,null,null,null,"Illustration av hur de ingående dimensionerna bidrar till det sammanväga indexet (medelvärdet) för respektive alternativ."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sannolikheten för att alternativen har högst sammanvägt index samt högst index inom respektive dimension."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Tekniskt index för analyserade alternativ.",null,null,null,null,null,"Socialt index för analyserade alternativ."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Miljömässigt index för analyserade alternativ.",null,null,null,null,null,"Ekonomiskt index för analyserade alternativ."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sammanvägt index (medelvärde) och total årskostnad (medelvärde) för de analyserade alternativen.",null,null,null,null,null,"Total årskostnad uttryckt i kkr för de analyserade alternativen."]
[]
[]
[]
[null,"Resultat från beräkningar utan osäkerheter"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sammanvägt index de analyserade alternativen.",null,null,null,null,null,"Illustration av hur de ingående dimensionerna bidrar till det sammanväga indexet för respektive alternativ."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Tekniskt index för analyserade alternativ.",null,null,null,null,null,"Socialt index för analyserade alternativ."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Miljömässigt index för analyserade alternativ.",null,null,null,null,null,"Ekonomiskt index för analyserade alternativ."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sammanvägt index (medelvärde) och total årskostnad (medelvärde) för de analyserade alternativen.",null,null,null,null,null,"Total årskostnad uttryckt i kkr för de analyserade alternativen."]

{"sheet":"Känslighetsanalys 1","index":9,"n_rows":112,"n_cols":42,"rows_kept":112,"cut":false,"hidden":false,"merged":[[4,1,4,11],[2,1,2,11]]}
[]
[null,"Känslighetsanalys: Korrelationskoefficient"]
[null,"Om bedömningarna (dvs. poängsättningen av alternativen) är gjorda med osäkerheter visas här känslighetsanalysen för resultaten. Observera att känslighetesanalysen kräver att programvaran @Risk är installerad på datorn."]
[]
[null,"Resultaten presenteras som korrelationskoefficienter (Spearman rangkorrelation) och beskriver hur starkt sambandet är mellan det aktuella resultatet (t.ex. sammanvägt hållbarhetsindex för en åtgärd) och de poängsatta kriterierna för detta alternativ. Korrelationskoefficienten kan anta ett värde mellan -1 till +1, där 1 motsvarar perfekt korrelation (positiv eller negativ) och 0 ingen korrelation. Rangkorrelationen beskriver hur väl sambandet kan beskrivas med en monoton funktion."]
[]
[]
[null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AH6,'Känslighetsanalys 1'!B8:J31,4,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AI6,'Känslighetsanalys 1'!L8:T31,4,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AJ6,'Känslighetsanalys 1'!V8:AD31,4,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AK6,'Känslighetsanalys 1'!AF8:AN31,4,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AL6,'Känslighetsanalys 1'!AP8:AX31,4,\"false\")","v":"@RISK graph"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AH9,'Känslighetsanalys 1'!B34:J57,4,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AI9,'Känslighetsanalys 1'!L34:T57,4,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AJ9,'Känslighetsanalys 1'!V34:AD57,4,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AK9,'Känslighetsanalys 1'!AF34:AN57,4,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AL9,'Känslighetsanalys 1'!AP34:AX57,4,\"false\")","v":"@RISK graph"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AH21,'Känslighetsanalys 1'!B60:J83,4,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AI21,'Känslighetsanalys 1'!L60:T83,4,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AJ21,'Känslighetsanalys 1'!V60:AD83,4,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AK21,'Känslighetsanalys 1'!AF60:AN83,4,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AL21,'Känslighetsanalys 1'!AP60:AX83,4,\"false\")","v":"@RISK graph"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AH36,'Känslighetsanalys 1'!B86:J109,4,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AI36,'Känslighetsanalys 1'!L86:T109,4,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AJ36,'Känslighetsanalys 1'!V86:AD109,4,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AK36,'Känslighetsanalys 1'!AF86:AN109,4,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AL36,'Känslighetsanalys 1'!AP86:AX109,4,\"false\")","v":"@RISK graph"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AH51,'Känslighetsanalys 1'!B112:J135,4,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AI51,'Känslighetsanalys 1'!L112:T135,4,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AJ51,'Känslighetsanalys 1'!V112:AD135,4,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AK51,'Känslighetsanalys 1'!AF112:AN135,4,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AL51,'Känslighetsanalys 1'!AP112:AX135,4,\"false\")","v":"@RISK graph"}]

{"sheet":"Känslighetsanalys 2","index":10,"n_rows":112,"n_cols":42,"rows_kept":112,"cut":false,"hidden":false,"merged":[[2,1,2,11],[4,1,4,11]]}
[]
[null,"Känslighetsanalys: Variation av poäng"]
[null,"Om bedömningarna (dvs. poängsättningen av alternativen) är gjorda med osäkerheter visas här känslighetsanalysen för resultaten. Observera att känslighetesanalysen kräver att programvaran @Risk är installerad på datorn."]
[]
[null,"I graferna nedan presenteras indexet för varje alternativ (medelvärdet) som en funktion av ingående poängsättningen för de olika kriterierna. Analysen har gjorts genom att variera ett kriterium i taget och hålla poängen med avseende på övriga kriterier konstant. Poängsättningen med avseende på de olika kriterierna har varierats inom det intervall som angivits i bedömningen (presetneras som percentiler på x-axeln). Y-axeln motsvarar indexets medelvärde."]
[]
[]
[null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AH6,'Känslighetsanalys 2'!B8:J31,15,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AI6,'Känslighetsanalys 2'!L8:T31,15,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AJ6,'Känslighetsanalys 2'!V8:AD31,15,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AK6,'Känslighetsanalys 2'!AF8:AN31,15,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AL6,'Känslighetsanalys 2'!AP8:AX31,15,\"false\")","v":"@RISK graph"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AH9,'Känslighetsanalys 2'!B34:J57,15,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AI9,'Känslighetsanalys 2'!L34:T57,15,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AJ9,'Känslighetsanalys 2'!V34:AD57,15,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AK9,'Känslighetsanalys 2'!AF34:AN57,15,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AL9,'Känslighetsanalys 2'!AP34:AX57,15,\"false\")","v":"@RISK graph"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AH21,'Känslighetsanalys 2'!B60:J83,15,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AI21,'Känslighetsanalys 2'!L60:T83,15,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AJ21,'Känslighetsanalys 2'!V60:AD83,15,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AK21,'Känslighetsanalys 2'!AF60:AN83,15,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AL21,'Känslighetsanalys 2'!AP60:AX83,15,\"false\")","v":"@RISK graph"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AH36,'Känslighetsanalys 2'!B86:J109,15,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AI36,'Känslighetsanalys 2'!L86:T109,15,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AJ36,'Känslighetsanalys 2'!V86:AD109,15,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AK36,'Känslighetsanalys 2'!AF86:AN109,15,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AL36,'Känslighetsanalys 2'!AP86:AX109,15,\"false\")","v":"@RISK graph"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AH51,'Känslighetsanalys 2'!B112:J135,15,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AI51,'Känslighetsanalys 2'!L112:T135,15,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AJ51,'Känslighetsanalys 2'!V112:AD135,15,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AK51,'Känslighetsanalys 2'!AF112:AN135,15,\"false\")","v":"@RISK graph"},null,null,null,null,null,null,null,null,null,{"$f":"_xll.RiskResultsGraph('Beräkningar (rör ej)'!AL51,'Känslighetsanalys 2'!AP112:AX135,15,\"false\")","v":"@RISK graph"}]

{"sheet":"Beräkningar (rör ej)","index":11,"n_rows":134,"n_cols":65,"rows_kept":134,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beräkningar med osäkerheter",null,null,null,null,null,null,"Beräkningar utan osäkerheter"]
[null,null,null,null,null,null,{"$f":"'4. Social'!F5","v":"Alternativ 1"},null,null,null,{"$f":"'4. Social'!J5","v":"Alternativ 2"},null,null,null,{"$f":"'4. Social'!N5","v":"Alternativ 3"},null,null,null,{"$f":"'4. Social'!R5","v":"Alternativ 4"},null,null,null,{"$f":"'4. Social'!V5","v":"Alternativ 5"},null,null,null,"Fördelning"]
[null,null,"Dimension","Kriterium","Slutvikt","Vikt","Min","Mest troliga","Max",null,"Min","Mest troliga","Max",null,"Min","Mest troliga","Max",null,"Min","Mest troliga","Max",null,"Min","Mest troliga","Max",null,"Alt. 1","Alt. 2","Alt. 3","Alt. 3","Alt. 5",null,null,"Alt. 1","Alt. 2","Alt. 3","Alt. 4","Alt. 5",null,null,"Alt. 1","Alt. 2","Alt. 3","Alt. 4","Alt. 5",null,null,null,"Alt. 1","Alt. 2","Alt. 3","Alt. 4","Alt. 5",null,null,null,"Alt. 1","Alt. 2","Alt. 3","Alt. 4","Alt. 5"]
[null,null,"Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH6=MAX($AH$6:$AL$6),1,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AI6=MAX($AH$6:$AL$6),1,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AJ6=MAX($AH$6:$AL$6),1,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AK6=MAX($AH$6:$AL$6),1,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AL6=MAX($AH$6:$AL$6),1,0)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,"Tot",{"$f":"_xll.RiskMean(AH6)","v":{"$error":"#N/A"}},{"$f":"_xll.RiskMean(AI6)","v":{"$error":"#N/A"}},{"$f":"_xll.RiskMean(AJ6)","v":{"$error":"#N/A"}},{"$f":"_xll.RiskMean(AK6)","v":{"$error":"#N/A"}},{"$f":"_xll.RiskMean(AL6)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sammanvägt index",{"$f":"_xll.RiskOutput()+AH9*$F$9+AH21*$F$21+AH36*$F$36+AH51*$F$51","v":{"$error":"#DIV/0!"}},{"$f":"_xll.RiskOutput()+AI9*$F$9+AI21*$F$21+AI36*$F$36+AI51*$F$51","v":{"$error":"#DIV/0!"}},{"$f":"_xll.RiskOutput()+AJ9*$F$9+AJ21*$F$21+AJ36*$F$36+AJ51*$F$51","v":{"$error":"#DIV/0!"}},{"$f":"_xll.RiskOutput()+AK9*$F$9+AK21*$F$21+AK36*$F$36+AK51*$F$51","v":{"$error":"#DIV/0!"}},{"$f":"_xll.RiskOutput()+AL9*$F$9+AL21*$F$21+AL36*$F$36+AL51*$F$51","v":{"$error":"#DIV/0!"}},null,{"$f":"AG6","v":"Sammanvägt index"},{"$f":"AO9*$F$9+AO21*$F$21+AO36*$F$36+AO51*$F$51","v":{"$error":"#DIV/0!"}},{"$f":"AP9*$F$9+AP21*$F$21+AP36*$F$36+AP51*$F$51","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$f":"C9","v":"Tekniskt"},null,null,null,null,null,null,null,null,{"$f":"IF(AH6=0,\"\",AH6)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AI6=0,\"\",AI6)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AJ6=0,\"\",AJ6)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AK6=0,\"\",AK6)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AL6=0,\"\",AL6)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C21","v":"Socialt"},null,null,null,null,null,null,null,"Slh tot",{"$f":"_xll.RiskOutput()+IF(BE6=MAX($BE$6:$BI$6),1,0)","v":{"$error":"#DIV/0!"}},{"$f":"_xll.RiskOutput()+IF(BF6=MAX($BE$6:$BI$6),1,0)","v":{"$error":"#DIV/0!"}},{"$f":"_xll.RiskOutput()+IF(BG6=MAX($BE$6:$BI$6),1,0)","v":{"$error":"#DIV/0!"}},{"$f":"_xll.RiskOutput()+IF(BH6=MAX($BE$6:$BI$6),1,0)","v":{"$error":"#DIV/0!"}},{"$f":"_xll.RiskOutput()+IF(BI6=MAX($BE$6:$BI$6),1,0)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C36","v":"Miljömässigt"},null,null,null,null,null,null,null,null,{"$f":"IF(AH9=0,\"\",AH9)","v":""},{"$f":"IF(AI9=0,\"\",AI9)","v":""},{"$f":"IF(AJ9=0,\"\",AJ9)","v":""},{"$f":"IF(AK9=0,\"\",AK9)","v":""},{"$f":"IF(AL9=0,\"\",AL9)","v":""}]
[null,null,"Tekniskt",{"$f":"C9","v":"Tekniskt"},null,{"$f":"'7. Viktning'!E66","v":0.25},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F9>0,1,0)","v":1},{"$f":"C9&\" index\"","v":"Tekniskt index"},{"$f":"_xll.RiskOutput()+SUM(AH10:AH18)*$AF9","v":0},{"$f":"_xll.RiskOutput()+SUM(AI10:AI18)*$AF9","v":0},{"$f":"_xll.RiskOutput()+SUM(AJ10:AJ18)*$AF9","v":0},{"$f":"_xll.RiskOutput()+SUM(AK10:AK18)*$AF9","v":0},{"$f":"_xll.RiskOutput()+SUM(AL10:AL18)*$AF9","v":0},null,{"$f":"AG9","v":"Tekniskt index"},{"$f":"SUM(AO10:AO18)*$AF9","v":0},{"$f":"SUM(AP10:AP18)*$AF9","v":0},0,0,0,null,null,{"$f":"C51","v":"Ekonomiskt"},null,null,null,null,null,null,null,"Slh teknik",{"$f":"_xll.RiskOutput()+IF(BE8=MAX($BE$8:$BI$8),1,0)","v":0},{"$f":"_xll.RiskOutput()+IF(BF8=MAX($BE$8:$BI$8),1,0)","v":0},{"$f":"_xll.RiskOutput()+IF(BG8=MAX($BE$8:$BI$8),1,0)","v":0},{"$f":"_xll.RiskOutput()+IF(BH8=MAX($BE$8:$BI$8),1,0)","v":0},{"$f":"_xll.RiskOutput()+IF(BI8=MAX($BE$8:$BI$8),1,0)","v":0}]
[null,null,null,{"$f":"'7. Viktning'!B7","v":"Leveranssäkerhet"},{"$f":"$F$9*F10","v":4.1666666666666664E-2},{"$f":"'7. Viktning'!E7","v":0.16666666666666666},{"$f":"'3. Teknisk'!F10","v":0},{"$f":"'3. Teknisk'!G10","v":0},{"$f":"'3. Teknisk'!H10","v":0},null,{"$f":"'3. Teknisk'!J10","v":0},{"$f":"'3. Teknisk'!K10","v":0},{"$f":"'3. Teknisk'!L10","v":0},null,{"$f":"'3. Teknisk'!N10","v":0},{"$f":"'3. Teknisk'!O10","v":0},{"$f":"'3. Teknisk'!P10","v":0},null,{"$f":"'3. Teknisk'!R10","v":0},{"$f":"'3. Teknisk'!S10","v":0},{"$f":"'3. Teknisk'!T10","v":0},null,{"$f":"'3. Teknisk'!V10","v":0},{"$f":"'3. Teknisk'!W10","v":0},{"$f":"'3. Teknisk'!X10","v":0},null,{"$f":"_xll.RiskPert(G10,H10,I10)","v":0},{"$f":"_xll.RiskPert(K10,L10,M10)","v":0},{"$f":"_xll.RiskPert(O10,P10,Q10)","v":0},{"$f":"_xll.RiskPert(S10,T10,U10)","v":0},{"$f":"_xll.RiskPert(W10,X10,Y10)","v":0},null,null,{"$f":"AA10*$F10","v":0},{"$f":"AB10*$F10","v":0},{"$f":"AC10*$F10","v":0},{"$f":"AD10*$F10","v":0},{"$f":"AE10*$F10","v":0},null,null,{"$f":"$F10*H10","v":0},{"$f":"$F10*L10","v":0},{"$f":"$F10*P10","v":0},{"$f":"$F10*T10","v":0},{"$f":"$F10*X10","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH21=0,\"\",AH21)","v":""},{"$f":"IF(AI21=0,\"\",AI21)","v":""},{"$f":"IF(AJ21=0,\"\",AJ21)","v":""},{"$f":"IF(AK21=0,\"\",AK21)","v":""},{"$f":"IF(AL21=0,\"\",AL21)","v":""}]
[null,null,null,{"$f":"'7. Viktning'!B8","v":"Sabotage"},{"$f":"$F$9*F11","v":4.1666666666666664E-2},{"$f":"'7. Viktning'!E8","v":0.16666666666666666},{"$f":"'3. Teknisk'!F11","v":0},{"$f":"'3. Teknisk'!G11","v":0},{"$f":"'3. Teknisk'!H11","v":0},null,{"$f":"'3. Teknisk'!J11","v":0},{"$f":"'3. Teknisk'!K11","v":0},{"$f":"'3. Teknisk'!L11","v":0},null,{"$f":"'3. Teknisk'!N11","v":0},{"$f":"'3. Teknisk'!O11","v":0},{"$f":"'3. Teknisk'!P11","v":0},null,{"$f":"'3. Teknisk'!R11","v":0},{"$f":"'3. Teknisk'!S11","v":0},{"$f":"'3. Teknisk'!T11","v":0},null,{"$f":"'3. Teknisk'!V11","v":0},{"$f":"'3. Teknisk'!W11","v":0},{"$f":"'3. Teknisk'!X11","v":0},null,{"$f":"_xll.RiskPert(G11,H11,I11)","v":0},{"$f":"_xll.RiskPert(K11,L11,M11)","v":0},{"$f":"_xll.RiskPert(O11,P11,Q11)","v":0},{"$f":"_xll.RiskPert(S11,T11,U11)","v":0},{"$f":"_xll.RiskPert(W11,X11,Y11)","v":0},null,null,0,0,0,0,0,null,null,{"$f":"$F11*H11","v":0},{"$f":"$F11*L11","v":0},{"$f":"$F11*P11","v":0},{"$f":"$F11*T11","v":0},{"$f":"$F11*X11","v":0},null,null,null,null,null,null,null,null,null,null,"Slh social",{"$f":"_xll.RiskOutput()+IF(BE10=MAX($BE$10:$BI$10),1,0)","v":0},{"$f":"_xll.RiskOutput()+IF(BF10=MAX($BE$10:$BI$10),1,0)","v":0},{"$f":"_xll.RiskOutput()+IF(BG10=MAX($BE$10:$BI$10),1,0)","v":0},{"$f":"_xll.RiskOutput()+IF(BH10=MAX($BE$10:$BI$10),1,0)","v":0},{"$f":"_xll.RiskOutput()+IF(BI10=MAX($BE$10:$BI$10),1,0)","v":0}]
[null,null,null,{"$f":"'7. Viktning'!B9","v":"Anpassningsförmåga"},4.1666666666666664E-2,{"$f":"'7. Viktning'!E9","v":0.16666666666666666},{"$f":"'3. Teknisk'!F12","v":0},{"$f":"'3. Teknisk'!G12","v":0},{"$f":"'3. Teknisk'!H12","v":0},null,{"$f":"'3. Teknisk'!J12","v":0},{"$f":"'3. Teknisk'!K12","v":0},{"$f":"'3. Teknisk'!L12","v":0},null,{"$f":"'3. Teknisk'!N12","v":0},{"$f":"'3. Teknisk'!O12","v":0},{"$f":"'3. Teknisk'!P12","v":0},null,{"$f":"'3. Teknisk'!R12","v":0},{"$f":"'3. Teknisk'!S12","v":0},{"$f":"'3. Teknisk'!T12","v":0},null,{"$f":"'3. Teknisk'!V12","v":0},{"$f":"'3. Teknisk'!W12","v":0},{"$f":"'3. Teknisk'!X12","v":0},null,{"$f":"_xll.RiskPert(G12,H12,I12)","v":0},{"$f":"_xll.RiskPert(K12,L12,M12)","v":0},{"$f":"_xll.RiskPert(O12,P12,Q12)","v":0},{"$f":"_xll.RiskPert(S12,T12,U12)","v":0},{"$f":"_xll.RiskPert(W12,X12,Y12)","v":0},null,null,0,0,0,0,0,null,null,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH36=0,\"\",AH36)","v":""},{"$f":"IF(AI36=0,\"\",AI36)","v":""},{"$f":"IF(AJ36=0,\"\",AJ36)","v":""},{"$f":"IF(AK36=0,\"\",AK36)","v":""},{"$f":"IF(AL36=0,\"\",AL36)","v":""}]
[null,null,null,{"$f":"'7. Viktning'!B10","v":"Tillstånd"},4.1666666666666664E-2,{"$f":"'7. Viktning'!E10","v":0.16666666666666666},{"$f":"'3. Teknisk'!F13","v":0},{"$f":"'3. Teknisk'!G13","v":0},{"$f":"'3. Teknisk'!H13","v":0},null,{"$f":"'3. Teknisk'!J13","v":0},{"$f":"'3. Teknisk'!K13","v":0},{"$f":"'3. Teknisk'!L13","v":0},null,{"$f":"'3. Teknisk'!N13","v":0},{"$f":"'3. Teknisk'!O13","v":0},{"$f":"'3. Teknisk'!P13","v":0},null,{"$f":"'3. Teknisk'!R13","v":0},{"$f":"'3. Teknisk'!S13","v":0},{"$f":"'3. Teknisk'!T13","v":0},null,{"$f":"'3. Teknisk'!V13","v":0},{"$f":"'3. Teknisk'!W13","v":0},{"$f":"'3. Teknisk'!X13","v":0},null,{"$f":"_xll.RiskPert(G13,H13,I13)","v":0},{"$f":"_xll.RiskPert(K13,L13,M13)","v":0},{"$f":"_xll.RiskPert(O13,P13,Q13)","v":0},{"$f":"_xll.RiskPert(S13,T13,U13)","v":0},{"$f":"_xll.RiskPert(W13,X13,Y13)","v":0},null,null,0,0,0,0,0,null,null,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,"Slh miljö",{"$f":"_xll.RiskOutput()+IF(BE12=MAX($BE$12:$BI$12),1,0)","v":0},{"$f":"_xll.RiskOutput()+IF(BF12=MAX($BE$12:$BI$12),1,0)","v":0},{"$f":"_xll.RiskOutput()+IF(BG12=MAX($BE$12:$BI$12),1,0)","v":0},{"$f":"_xll.RiskOutput()+IF(BH12=MAX($BE$12:$BI$12),1,0)","v":0},{"$f":"_xll.RiskOutput()+IF(BI12=MAX($BE$12:$BI$12),1,0)","v":0}]
[null,null,null,{"$f":"'7. Viktning'!B11","v":"Rådighet"},4.1666666666666664E-2,{"$f":"'7. Viktning'!E11","v":0.16666666666666666},{"$f":"'3. Teknisk'!F14","v":0},{"$f":"'3. Teknisk'!G14","v":0},{"$f":"'3. Teknisk'!H14","v":0},null,{"$f":"'3. Teknisk'!J14","v":0},{"$f":"'3. Teknisk'!K14","v":0},{"$f":"'3. Teknisk'!L14","v":0},null,{"$f":"'3. Teknisk'!N14","v":0},{"$f":"'3. Teknisk'!O14","v":0},{"$f":"'3. Teknisk'!P14","v":0},null,{"$f":"'3. Teknisk'!R14","v":0},{"$f":"'3. Teknisk'!S14","v":0},{"$f":"'3. Teknisk'!T14","v":0},null,{"$f":"'3. Teknisk'!V14","v":0},{"$f":"'3. Teknisk'!W14","v":0},{"$f":"'3. Teknisk'!X14","v":0},null,{"$f":"_xll.RiskPert(G14,H14,I14)","v":0},{"$f":"_xll.RiskPert(K14,L14,M14)","v":0},{"$f":"_xll.RiskPert(O14,P14,Q14)","v":0},{"$f":"_xll.RiskPert(S14,T14,U14)","v":0},{"$f":"_xll.RiskPert(W14,X14,Y14)","v":0},null,null,0,0,0,0,0,null,null,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH51=0,\"\",AH51)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AI51=0,\"\",AI51)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AJ51=0,\"\",AJ51)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AK51=0,\"\",AK51)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AL51=0,\"\",AL51)","v":{"$error":"#DIV/0!"}}]
[null,null,null,{"$f":"'7. Viktning'!B12","v":"Tid till idrifttagande"},4.1666666666666664E-2,{"$f":"'7. Viktning'!E12","v":0.16666666666666666},{"$f":"'3. Teknisk'!F15","v":0},{"$f":"'3. Teknisk'!G15","v":0},{"$f":"'3. Teknisk'!H15","v":0},null,{"$f":"'3. Teknisk'!J15","v":0},{"$f":"'3. Teknisk'!K15","v":0},{"$f":"'3. Teknisk'!L15","v":0},null,{"$f":"'3. Teknisk'!N15","v":0},{"$f":"'3. Teknisk'!O15","v":0},{"$f":"'3. Teknisk'!P15","v":0},null,{"$f":"'3. Teknisk'!R15","v":0},{"$f":"'3. Teknisk'!S15","v":0},{"$f":"'3. Teknisk'!T15","v":0},null,{"$f":"'3. Teknisk'!V15","v":0},{"$f":"'3. Teknisk'!W15","v":0},{"$f":"'3. Teknisk'!X15","v":0},null,{"$f":"_xll.RiskPert(G15,H15,I15)","v":0},{"$f":"_xll.RiskPert(K15,L15,M15)","v":0},{"$f":"_xll.RiskPert(O15,P15,Q15)","v":0},{"$f":"_xll.RiskPert(S15,T15,U15)","v":0},{"$f":"_xll.RiskPert(W15,X15,Y15)","v":0},null,null,0,0,0,0,0,null,null,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,"Slh ekonomi",{"$f":"_xll.RiskOutput()+IF(BE14=MAX($BE$14:$BI$14),1,0)","v":{"$error":"#DIV/0!"}},{"$f":"_xll.RiskOutput()+IF(BF14=MAX($BE$14:$BI$14),1,0)","v":{"$error":"#DIV/0!"}},{"$f":"_xll.RiskOutput()+IF(BG14=MAX($BE$14:$BI$14),1,0)","v":{"$error":"#DIV/0!"}},{"$f":"_xll.RiskOutput()+IF(BH14=MAX($BE$14:$BI$14),1,0)","v":{"$error":"#DIV/0!"}},{"$f":"_xll.RiskOutput()+IF(BI14=MAX($BE$14:$BI$14),1,0)","v":{"$error":"#DIV/0!"}}]
[null,null,null,{"$f":"'7. Viktning'!B13","v":"Ytterligare kriterium"},0,{"$f":"'7. Viktning'!E13","v":0},{"$f":"'3. Teknisk'!F16","v":0},{"$f":"'3. Teknisk'!G16","v":0},{"$f":"'3. Teknisk'!H16","v":0},null,{"$f":"'3. Teknisk'!J16","v":0},{"$f":"'3. Teknisk'!K16","v":0},{"$f":"'3. Teknisk'!L16","v":0},null,{"$f":"'3. Teknisk'!N16","v":0},{"$f":"'3. Teknisk'!O16","v":0},{"$f":"'3. Teknisk'!P16","v":0},null,{"$f":"'3. Teknisk'!R16","v":0},{"$f":"'3. Teknisk'!S16","v":0},{"$f":"'3. Teknisk'!T16","v":0},null,{"$f":"'3. Teknisk'!V16","v":0},{"$f":"'3. Teknisk'!W16","v":0},{"$f":"'3. Teknisk'!X16","v":0},null,{"$f":"_xll.RiskPert(G16,H16,I16)","v":0},{"$f":"_xll.RiskPert(K16,L16,M16)","v":0},{"$f":"_xll.RiskPert(O16,P16,Q16)","v":0},{"$f":"_xll.RiskPert(S16,T16,U16)","v":0},{"$f":"_xll.RiskPert(W16,X16,Y16)","v":0},null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,null,null,{"$f":"'7. Viktning'!B14","v":"Ytterligare kriterium"},0,{"$f":"'7. Viktning'!E14","v":0},{"$f":"'3. Teknisk'!F17","v":0},{"$f":"'3. Teknisk'!G17","v":0},{"$f":"'3. Teknisk'!H17","v":0},null,{"$f":"'3. Teknisk'!J17","v":0},{"$f":"'3. Teknisk'!K17","v":0},{"$f":"'3. Teknisk'!L17","v":0},null,{"$f":"'3. Teknisk'!N17","v":0},{"$f":"'3. Teknisk'!O17","v":0},{"$f":"'3. Teknisk'!P17","v":0},null,{"$f":"'3. Teknisk'!R17","v":0},{"$f":"'3. Teknisk'!S17","v":0},{"$f":"'3. Teknisk'!T17","v":0},null,{"$f":"'3. Teknisk'!V17","v":0},{"$f":"'3. Teknisk'!W17","v":0},{"$f":"'3. Teknisk'!X17","v":0},null,{"$f":"_xll.RiskPert(G17,H17,I17)","v":0},{"$f":"_xll.RiskPert(K17,L17,M17)","v":0},{"$f":"_xll.RiskPert(O17,P17,Q17)","v":0},{"$f":"_xll.RiskPert(S17,T17,U17)","v":0},{"$f":"_xll.RiskPert(W17,X17,Y17)","v":0},null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,null,null,{"$f":"'7. Viktning'!B15","v":"Ytterligare kriterium"},0,{"$f":"'7. Viktning'!E15","v":0},{"$f":"'3. Teknisk'!F18","v":0},{"$f":"'3. Teknisk'!G18","v":0},{"$f":"'3. Teknisk'!H18","v":0},null,{"$f":"'3. Teknisk'!J18","v":0},{"$f":"'3. Teknisk'!K18","v":0},{"$f":"'3. Teknisk'!L18","v":0},null,{"$f":"'3. Teknisk'!N18","v":0},{"$f":"'3. Teknisk'!O18","v":0},{"$f":"'3. Teknisk'!P18","v":0},null,{"$f":"'3. Teknisk'!R18","v":0},{"$f":"'3. Teknisk'!S18","v":0},{"$f":"'3. Teknisk'!T18","v":0},null,{"$f":"'3. Teknisk'!V18","v":0},{"$f":"'3. Teknisk'!W18","v":0},{"$f":"'3. Teknisk'!X18","v":0},null,{"$f":"_xll.RiskPert(G18,H18,I18)","v":0},{"$f":"_xll.RiskPert(K18,L18,M18)","v":0},{"$f":"_xll.RiskPert(O18,P18,Q18)","v":0},{"$f":"_xll.RiskPert(S18,T18,U18)","v":0},{"$f":"_xll.RiskPert(W18,X18,Y18)","v":0},null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[]
[]
[null,null,"Socialt",{"$f":"C21","v":"Socialt"},null,{"$f":"'7. Viktning'!E67","v":0.25},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F21>0,1,0)","v":1},{"$f":"C21&\" index\"","v":"Socialt index"},{"$f":"_xll.RiskOutput()+SUM(AH22:AH33)*$AF21","v":0},{"$f":"_xll.RiskOutput()+SUM(AI22:AI33)*$AF21","v":0},{"$f":"_xll.RiskOutput()+SUM(AJ22:AJ33)*$AF21","v":0},{"$f":"_xll.RiskOutput()+SUM(AK22:AK33)*$AF21","v":0},{"$f":"_xll.RiskOutput()+SUM(AL22:AL33)*$AF21","v":0},null,{"$f":"AG21","v":"Socialt index"},{"$f":"SUM(AO22:AO33)*$AF21","v":0},{"$f":"SUM(AP22:AP33)*$AF21","v":0},0,0,0]
[null,null,null,{"$f":"'7. Viktning'!B21","v":"Upplevd trygghet"},{"$f":"$F$21*F22","v":2.7777777777777776E-2},{"$f":"'7. Viktning'!E21","v":0.1111111111111111},{"$f":"'4. Social'!F10","v":0},{"$f":"'4. Social'!G10","v":0},{"$f":"'4. Social'!H10","v":0},null,{"$f":"'4. Social'!J10","v":0},{"$f":"'4. Social'!K10","v":0},{"$f":"'4. Social'!L10","v":0},null,{"$f":"'4. Social'!N10","v":0},{"$f":"'4. Social'!O10","v":0},{"$f":"'4. Social'!P10","v":0},null,{"$f":"'4. Social'!R10","v":0},{"$f":"'4. Social'!S10","v":0},{"$f":"'4. Social'!T10","v":0},null,{"$f":"'4. Social'!V10","v":0},{"$f":"'4. Social'!W10","v":0},{"$f":"'4. Social'!X10","v":0},null,{"$f":"_xll.RiskPert(G22,H22,I22)","v":0},{"$f":"_xll.RiskPert(K22,L22,M22)","v":0},{"$f":"_xll.RiskPert(O22,P22,Q22)","v":0},{"$f":"_xll.RiskPert(S22,T22,U22)","v":0},{"$f":"_xll.RiskPert(W22,X22,Y22)","v":0},null,null,{"$f":"AA22*$F22","v":0},{"$f":"AB22*$F22","v":0},{"$f":"AC22*$F22","v":0},{"$f":"AD22*$F22","v":0},{"$f":"AE22*$F22","v":0},null,null,{"$f":"$F22*H22","v":0},{"$f":"$F22*L22","v":0},{"$f":"$F22*P22","v":0},{"$f":"$F22*T22","v":0},{"$f":"$F22*X22","v":0}]
[null,null,null,{"$f":"'7. Viktning'!B22","v":"Skydd mot mikrobiologiska hälsorisker"},{"$f":"$F$21*F23","v":2.7777777777777776E-2},{"$f":"'7. Viktning'!E22","v":0.1111111111111111},{"$f":"'4. Social'!F11","v":0},{"$f":"'4. Social'!G11","v":0},{"$f":"'4. Social'!H11","v":0},null,{"$f":"'4. Social'!J11","v":0},{"$f":"'4. Social'!K11","v":0},{"$f":"'4. Social'!L11","v":0},null,{"$f":"'4. Social'!N11","v":0},{"$f":"'4. Social'!O11","v":0},{"$f":"'4. Social'!P11","v":0},null,{"$f":"'4. Social'!R11","v":0},{"$f":"'4. Social'!S11","v":0},{"$f":"'4. Social'!T11","v":0},null,{"$f":"'4. Social'!V11","v":0},{"$f":"'4. Social'!W11","v":0},{"$f":"'4. Social'!X11","v":0},null,{"$f":"_xll.RiskPert(G23,H23,I23)","v":0},{"$f":"_xll.RiskPert(K23,L23,M23)","v":0},{"$f":"_xll.RiskPert(O23,P23,Q23)","v":0},{"$f":"_xll.RiskPert(S23,T23,U23)","v":0},{"$f":"_xll.RiskPert(W23,X23,Y23)","v":0},null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,null,null,{"$f":"'7. Viktning'!B23","v":"Skydd mot kemiska hälsorisker"},2.7777777777777776E-2,{"$f":"'7. Viktning'!E23","v":0.1111111111111111},{"$f":"'4. Social'!F12","v":0},{"$f":"'4. Social'!G12","v":0},{"$f":"'4. Social'!H12","v":0},null,{"$f":"'4. Social'!J12","v":0},{"$f":"'4. Social'!K12","v":0},{"$f":"'4. Social'!L12","v":0},null,{"$f":"'4. Social'!N12","v":0},{"$f":"'4. Social'!O12","v":0},{"$f":"'4. Social'!P12","v":0},null,{"$f":"'4. Social'!R12","v":0},{"$f":"'4. Social'!S12","v":0},{"$f":"'4. Social'!T12","v":0},null,{"$f":"'4. Social'!V12","v":0},{"$f":"'4. Social'!W12","v":0},{"$f":"'4. Social'!X12","v":0},null,{"$f":"_xll.RiskPert(G24,H24,I24)","v":0},{"$f":"_xll.RiskPert(K24,L24,M24)","v":0},{"$f":"_xll.RiskPert(O24,P24,Q24)","v":0},{"$f":"_xll.RiskPert(S24,T24,U24)","v":0},{"$f":"_xll.RiskPert(W24,X24,Y24)","v":0},null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,null,null,{"$f":"'7. Viktning'!B24","v":"Andra dricksvattenparametrar"},2.7777777777777776E-2,{"$f":"'7. Viktning'!E24","v":0.1111111111111111},{"$f":"'4. Social'!F13","v":0},{"$f":"'4. Social'!G13","v":0},{"$f":"'4. Social'!H13","v":0},null,{"$f":"'4. Social'!J13","v":0},{"$f":"'4. Social'!K13","v":0},{"$f":"'4. Social'!L13","v":0},null,{"$f":"'4. Social'!N13","v":0},{"$f":"'4. Social'!O13","v":0},{"$f":"'4. Social'!P13","v":0},null,{"$f":"'4. Social'!R13","v":0},{"$f":"'4. Social'!S13","v":0},{"$f":"'4. Social'!T13","v":0},null,{"$f":"'4. Social'!V13","v":0},{"$f":"'4. Social'!W13","v":0},{"$f":"'4. Social'!X13","v":0},null,{"$f":"_xll.RiskPert(G25,H25,I25)","v":0},{"$f":"_xll.RiskPert(K25,L25,M25)","v":0},{"$f":"_xll.RiskPert(O25,P25,Q25)","v":0},{"$f":"_xll.RiskPert(S25,T25,U25)","v":0},{"$f":"_xll.RiskPert(W25,X25,Y25)","v":0},null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,null,null,{"$f":"'7. Viktning'!B25","v":"Icke-dricksvattenrelaterade hälsoeffekter"},2.7777777777777776E-2,{"$f":"'7. Viktning'!E25","v":0.1111111111111111},{"$f":"'4. Social'!F14","v":0},{"$f":"'4. Social'!G14","v":0},{"$f":"'4. Social'!H14","v":0},null,{"$f":"'4. Social'!J14","v":0},{"$f":"'4. Social'!K14","v":0},{"$f":"'4. Social'!L14","v":0},null,{"$f":"'4. Social'!N14","v":0},{"$f":"'4. Social'!O14","v":0},{"$f":"'4. Social'!P14","v":0},null,{"$f":"'4. Social'!R14","v":0},{"$f":"'4. Social'!S14","v":0},{"$f":"'4. Social'!T14","v":0},null,{"$f":"'4. Social'!V14","v":0},{"$f":"'4. Social'!W14","v":0},{"$f":"'4. Social'!X14","v":0},null,{"$f":"_xll.RiskPert(G26,H26,I26)","v":0},{"$f":"_xll.RiskPert(K26,L26,M26)","v":0},{"$f":"_xll.RiskPert(O26,P26,Q26)","v":0},{"$f":"_xll.RiskPert(S26,T26,U26)","v":0},{"$f":"_xll.RiskPert(W26,X26,Y26)","v":0},null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,null,null,{"$f":"'7. Viktning'!B26","v":"Icke-dricksvattenrelaterade hälsoeffekter "},2.7777777777777776E-2,{"$f":"'7. Viktning'!E26","v":0.1111111111111111},{"$f":"'4. Social'!F15","v":0},{"$f":"'4. Social'!G15","v":0},{"$f":"'4. Social'!H15","v":0},null,{"$f":"'4. Social'!J15","v":0},{"$f":"'4. Social'!K15","v":0},{"$f":"'4. Social'!L15","v":0},null,{"$f":"'4. Social'!N15","v":0},{"$f":"'4. Social'!O15","v":0},{"$f":"'4. Social'!P15","v":0},null,{"$f":"'4. Social'!R15","v":0},{"$f":"'4. Social'!S15","v":0},{"$f":"'4. Social'!T15","v":0},null,{"$f":"'4. Social'!V15","v":0},{"$f":"'4. Social'!W15","v":0},{"$f":"'4. Social'!X15","v":0},null,{"$f":"_xll.RiskPert(G27,H27,I27)","v":0},{"$f":"_xll.RiskPert(K27,L27,M27)","v":0},{"$f":"_xll.RiskPert(O27,P27,Q27)","v":0},{"$f":"_xll.RiskPert(S27,T27,U27)","v":0},{"$f":"_xll.RiskPert(W27,X27,Y27)","v":0},null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,null,null,{"$f":"'7. Viktning'!B27","v":"Tillväxtpotential"},2.7777777777777776E-2,{"$f":"'7. Viktning'!E27","v":0.1111111111111111},{"$f":"'4. Social'!F16","v":0},{"$f":"'4. Social'!G16","v":0},{"$f":"'4. Social'!H16","v":0},null,{"$f":"'4. Social'!J16","v":0},{"$f":"'4. Social'!K16","v":0},{"$f":"'4. Social'!L16","v":0},null,{"$f":"'4. Social'!N16","v":0},{"$f":"'4. Social'!O16","v":0},{"$f":"'4. Social'!P16","v":0},null,{"$f":"'4. Social'!R16","v":0},{"$f":"'4. Social'!S16","v":0},{"$f":"'4. Social'!T16","v":0},null,{"$f":"'4. Social'!V16","v":0},{"$f":"'4. Social'!W16","v":0},{"$f":"'4. Social'!X16","v":0},null,{"$f":"_xll.RiskPert(G28,H28,I28)","v":0},{"$f":"_xll.RiskPert(K28,L28,M28)","v":0},{"$f":"_xll.RiskPert(O28,P28,Q28)","v":0},{"$f":"_xll.RiskPert(S28,T28,U28)","v":0},{"$f":"_xll.RiskPert(W28,X28,Y28)","v":0},null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,null,null,{"$f":"'7. Viktning'!B28","v":"Rekreationsvärden"},2.7777777777777776E-2,{"$f":"'7. Viktning'!E28","v":0.1111111111111111},{"$f":"'4. Social'!F17","v":0},{"$f":"'4. Social'!G17","v":0},{"$f":"'4. Social'!H17","v":0},null,{"$f":"'4. Social'!J17","v":0},{"$f":"'4. Social'!K17","v":0},{"$f":"'4. Social'!L17","v":0},null,{"$f":"'4. Social'!N17","v":0},{"$f":"'4. Social'!O17","v":0},{"$f":"'4. Social'!P17","v":0},null,{"$f":"'4. Social'!R17","v":0},{"$f":"'4. Social'!S17","v":0},{"$f":"'4. Social'!T17","v":0},null,{"$f":"'4. Social'!V17","v":0},{"$f":"'4. Social'!W17","v":0},{"$f":"'4. Social'!X17","v":0},null,{"$f":"_xll.RiskPert(G29,H29,I29)","v":0},{"$f":"_xll.RiskPert(K29,L29,M29)","v":0},{"$f":"_xll.RiskPert(O29,P29,Q29)","v":0},{"$f":"_xll.RiskPert(S29,T29,U29)","v":0},{"$f":"_xll.RiskPert(W29,X29,Y29)","v":0},null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,null,null,{"$f":"'7. Viktning'!B29","v":"Fördelningseffekter"},2.7777777777777776E-2,{"$f":"'7. Viktning'!E29","v":0.1111111111111111},{"$f":"'4. Social'!F18","v":0},{"$f":"'4. Social'!G18","v":0},{"$f":"'4. Social'!H18","v":0},null,{"$f":"'4. Social'!J18","v":0},{"$f":"'4. Social'!K18","v":0},{"$f":"'4. Social'!L18","v":0},null,{"$f":"'4. Social'!N18","v":0},{"$f":"'4. Social'!O18","v":0},{"$f":"'4. Social'!P18","v":0},null,{"$f":"'4. Social'!R18","v":0},{"$f":"'4. Social'!S18","v":0},{"$f":"'4. Social'!T18","v":0},null,{"$f":"'4. Social'!V18","v":0},{"$f":"'4. Social'!W18","v":0},{"$f":"'4. Social'!X18","v":0},null,{"$f":"_xll.RiskPert(G30,H30,I30)","v":0},{"$f":"_xll.RiskPert(K30,L30,M30)","v":0},{"$f":"_xll.RiskPert(O30,P30,Q30)","v":0},{"$f":"_xll.RiskPert(S30,T30,U30)","v":0},{"$f":"_xll.RiskPert(W30,X30,Y30)","v":0},null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,null,null,{"$f":"'7. Viktning'!B30","v":"Ytterligare kriterium"},0,{"$f":"'7. Viktning'!E30","v":0},{"$f":"'4. Social'!F19","v":0},{"$f":"'4. Social'!G19","v":0},{"$f":"'4. Social'!H19","v":0},null,{"$f":"'4. Social'!J19","v":0},{"$f":"'4. Social'!K19","v":0},{"$f":"'4. Social'!L19","v":0},null,{"$f":"'4. Social'!N19","v":0},{"$f":"'4. Social'!O19","v":0},{"$f":"'4. Social'!P19","v":0},null,{"$f":"'4. Social'!R19","v":0},{"$f":"'4. Social'!S19","v":0},{"$f":"'4. Social'!T19","v":0},null,{"$f":"'4. Social'!V19","v":0},{"$f":"'4. Social'!W19","v":0},{"$f":"'4. Social'!X19","v":0},null,{"$f":"_xll.RiskPert(G31,H31,I31)","v":0},{"$f":"_xll.RiskPert(K31,L31,M31)","v":0},{"$f":"_xll.RiskPert(O31,P31,Q31)","v":0},{"$f":"_xll.RiskPert(S31,T31,U31)","v":0},{"$f":"_xll.RiskPert(W31,X31,Y31)","v":0},null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,null,null,{"$f":"'7. Viktning'!B31","v":"Ytterligare kriterium"},0,{"$f":"'7. Viktning'!E31","v":0},{"$f":"'4. Social'!F20","v":0},{"$f":"'4. Social'!G20","v":0},{"$f":"'4. Social'!H20","v":0},null,{"$f":"'4. Social'!J20","v":0},{"$f":"'4. Social'!K20","v":0},{"$f":"'4. Social'!L20","v":0},null,{"$f":"'4. Social'!N20","v":0},{"$f":"'4. Social'!O20","v":0},{"$f":"'4. Social'!P20","v":0},null,{"$f":"'4. Social'!R20","v":0},{"$f":"'4. Social'!S20","v":0},{"$f":"'4. Social'!T20","v":0},null,{"$f":"'4. Social'!V20","v":0},{"$f":"'4. Social'!W20","v":0},{"$f":"'4. Social'!X20","v":0},null,{"$f":"_xll.RiskPert(G32,H32,I32)","v":0},{"$f":"_xll.RiskPert(K32,L32,M32)","v":0},{"$f":"_xll.RiskPert(O32,P32,Q32)","v":0},{"$f":"_xll.RiskPert(S32,T32,U32)","v":0},{"$f":"_xll.RiskPert(W32,X32,Y32)","v":0},null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,null,null,{"$f":"'7. Viktning'!B32","v":"Ytterligare kriterium"},0,{"$f":"'7. Viktning'!E32","v":0},{"$f":"'4. Social'!F21","v":0},{"$f":"'4. Social'!G21","v":0},{"$f":"'4. Social'!H21","v":0},null,{"$f":"'4. Social'!J21","v":0},{"$f":"'4. Social'!K21","v":0},{"$f":"'4. Social'!L21","v":0},null,{"$f":"'4. Social'!N21","v":0},{"$f":"'4. Social'!O21","v":0},{"$f":"'4. Social'!P21","v":0},null,{"$f":"'4. Social'!R21","v":0},{"$f":"'4. Social'!S21","v":0},{"$f":"'4. Social'!T21","v":0},null,{"$f":"'4. Social'!V21","v":0},{"$f":"'4. Social'!W21","v":0},{"$f":"'4. Social'!X21","v":0},null,{"$f":"_xll.RiskPert(G33,H33,I33)","v":0},{"$f":"_xll.RiskPert(K33,L33,M33)","v":0},{"$f":"_xll.RiskPert(O33,P33,Q33)","v":0},{"$f":"_xll.RiskPert(S33,T33,U33)","v":0},{"$f":"_xll.RiskPert(W33,X33,Y33)","v":0},null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[]
[]
[null,null,"Miljömässigt",{"$f":"C36","v":"Miljömässigt"},null,{"$f":"'7. Viktning'!E68","v":0.25},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F36>0,1,0)","v":1},{"$f":"C36&\" index\"","v":"Miljömässigt index"},{"$f":"_xll.RiskOutput()+SUM(AH37:AH48)*$AF36","v":0},{"$f":"_xll.RiskOutput()+SUM(AI37:AI48)*$AF36","v":0},{"$f":"_xll.RiskOutput()+SUM(AJ37:AJ48)*$AF36","v":0},{"$f":"_xll.RiskOutput()+SUM(AK37:AK48)*$AF36","v":0},{"$f":"_xll.RiskOutput()+SUM(AL37:AL48)*$AF36","v":0},null,{"$f":"AG36","v":"Miljömässigt index"},{"$f":"SUM(AO37:AO48)*$AF36","v":0},{"$f":"SUM(AP37:AP48)*$AF36","v":0},0,0,0]
[null,null,null,{"$f":"'7. Viktning'!B38","v":"Vattenresursers kvalitet"},{"$f":"$F$36*F37","v":2.7777777777777776E-2},{"$f":"'7. Viktning'!E38","v":0.1111111111111111},{"$f":"'5. Miljö'!F10","v":0},{"$f":"'5. Miljö'!G10","v":0},{"$f":"'5. Miljö'!H10","v":0},null,{"$f":"'5. Miljö'!J10","v":0},{"$f":"'5. Miljö'!K10","v":0},{"$f":"'5. Miljö'!L10","v":0},null,{"$f":"'5. Miljö'!N10","v":0},{"$f":"'5. Miljö'!O10","v":0},{"$f":"'5. Miljö'!P10","v":0},null,{"$f":"'5. Miljö'!R10","v":0},{"$f":"'5. Miljö'!S10","v":0},{"$f":"'5. Miljö'!T10","v":0},null,{"$f":"'5. Miljö'!V10","v":0},{"$f":"'5. Miljö'!W10","v":0},{"$f":"'5. Miljö'!X10","v":0},null,{"$f":"_xll.RiskPert(G37,H37,I37)","v":0},{"$f":"_xll.RiskPert(K37,L37,M37)","v":0},{"$f":"_xll.RiskPert(O37,P37,Q37)","v":0},{"$f":"_xll.RiskPert(S37,T37,U37)","v":0},{"$f":"_xll.RiskPert(W37,X37,Y37)","v":0},null,null,{"$f":"AA37*$F37","v":0},{"$f":"AB37*$F37","v":0},{"$f":"AC37*$F37","v":0},{"$f":"AD37*$F37","v":0},{"$f":"AE37*$F37","v":0},null,null,{"$f":"$F37*H37","v":0},{"$f":"$F37*L37","v":0},{"$f":"$F37*P37","v":0},{"$f":"$F37*T37","v":0},{"$f":"$F37*X37","v":0}]
[null,null,null,{"$f":"'7. Viktning'!B39","v":"Vattenresursers kvantitet"},{"$f":"$F$36*F38","v":2.7777777777777776E-2},{"$f":"'7. Viktning'!E39","v":0.1111111111111111},{"$f":"'5. Miljö'!F11","v":0},{"$f":"'5. Miljö'!G11","v":0},{"$f":"'5. Miljö'!H11","v":0},null,{"$f":"'5. Miljö'!J11","v":0},{"$f":"'5. Miljö'!K11","v":0},{"$f":"'5. Miljö'!L11","v":0},null,{"$f":"'5. Miljö'!N11","v":0},{"$f":"'5. Miljö'!O11","v":0},{"$f":"'5. Miljö'!P11","v":0},null,{"$f":"'5. Miljö'!R11","v":0},{"$f":"'5. Miljö'!S11","v":0},{"$f":"'5. Miljö'!T11","v":0},null,{"$f":"'5. Miljö'!V11","v":0},{"$f":"'5. Miljö'!W11","v":0},{"$f":"'5. Miljö'!X11","v":0},null,{"$f":"_xll.RiskPert(G38,H38,I38)","v":0},{"$f":"_xll.RiskPert(K38,L38,M38)","v":0},{"$f":"_xll.RiskPert(O38,P38,Q38)","v":0},{"$f":"_xll.RiskPert(S38,T38,U38)","v":0},{"$f":"_xll.RiskPert(W38,X38,Y38)","v":0},null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,null,null,{"$f":"'7. Viktning'!B40","v":"Terrestra ekosystems livsduglighet"},2.7777777777777776E-2,{"$f":"'7. Viktning'!E40","v":0.1111111111111111},{"$f":"'5. Miljö'!F12","v":0},{"$f":"'5. Miljö'!G12","v":0},{"$f":"'5. Miljö'!H12","v":0},null,{"$f":"'5. Miljö'!J12","v":0},{"$f":"'5. Miljö'!K12","v":0},{"$f":"'5. Miljö'!L12","v":0},null,{"$f":"'5. Miljö'!N12","v":0},{"$f":"'5. Miljö'!O12","v":0},{"$f":"'5. Miljö'!P12","v":0},null,{"$f":"'5. Miljö'!R12","v":0},{"$f":"'5. Miljö'!S12","v":0},{"$f":"'5. Miljö'!T12","v":0},null,{"$f":"'5. Miljö'!V12","v":0},{"$f":"'5. Miljö'!W12","v":0},{"$f":"'5. Miljö'!X12","v":0},null,{"$f":"_xll.RiskPert(G39,H39,I39)","v":0},{"$f":"_xll.RiskPert(K39,L39,M39)","v":0},{"$f":"_xll.RiskPert(O39,P39,Q39)","v":0},{"$f":"_xll.RiskPert(S39,T39,U39)","v":0},{"$f":"_xll.RiskPert(W39,X39,Y39)","v":0},null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,null,null,{"$f":"'7. Viktning'!B41","v":"Energianvändning och växthusgasutsläpp"},2.7777777777777776E-2,{"$f":"'7. Viktning'!E41","v":0.1111111111111111},{"$f":"'5. Miljö'!F13","v":0},{"$f":"'5. Miljö'!G13","v":0},{"$f":"'5. Miljö'!H13","v":0},null,{"$f":"'5. Miljö'!J13","v":0},{"$f":"'5. Miljö'!K13","v":0},{"$f":"'5. Miljö'!L13","v":0},null,{"$f":"'5. Miljö'!N13","v":0},{"$f":"'5. Miljö'!O13","v":0},{"$f":"'5. Miljö'!P13","v":0},null,{"$f":"'5. Miljö'!R13","v":0},{"$f":"'5. Miljö'!S13","v":0},{"$f":"'5. Miljö'!T13","v":0},null,{"$f":"'5. Miljö'!V13","v":0},{"$f":"'5. Miljö'!W13","v":0},{"$f":"'5. Miljö'!X13","v":0},null,{"$f":"_xll.RiskPert(G40,H40,I40)","v":0},{"$f":"_xll.RiskPert(K40,L40,M40)","v":0},{"$f":"_xll.RiskPert(O40,P40,Q40)","v":0},{"$f":"_xll.RiskPert(S40,T40,U40)","v":0},{"$f":"_xll.RiskPert(W40,X40,Y40)","v":0},null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,null,null,{"$f":"'7. Viktning'!B42","v":"Vattenanvändning"},2.7777777777777776E-2,{"$f":"'7. Viktning'!E42","v":0.1111111111111111},{"$f":"'5. Miljö'!F14","v":0},{"$f":"'5. Miljö'!G14","v":0},{"$f":"'5. Miljö'!H14","v":0},null,{"$f":"'5. Miljö'!J14","v":0},{"$f":"'5. Miljö'!K14","v":0},{"$f":"'5. Miljö'!L14","v":0},null,{"$f":"'5. Miljö'!N14","v":0},{"$f":"'5. Miljö'!O14","v":0},{"$f":"'5. Miljö'!P14","v":0},null,{"$f":"'5. Miljö'!R14","v":0},{"$f":"'5. Miljö'!S14","v":0},{"$f":"'5. Miljö'!T14","v":0},null,{"$f":"'5. Miljö'!V14","v":0},{"$f":"'5. Miljö'!W14","v":0},{"$f":"'5. Miljö'!X14","v":0},null,{"$f":"_xll.RiskPert(G41,H41,I41)","v":0},{"$f":"_xll.RiskPert(K41,L41,M41)","v":0},{"$f":"_xll.RiskPert(O41,P41,Q41)","v":0},{"$f":"_xll.RiskPert(S41,T41,U41)","v":0},{"$f":"_xll.RiskPert(W41,X41,Y41)","v":0},null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,null,null,{"$f":"'7. Viktning'!B43","v":"Markanvändning"},2.7777777777777776E-2,{"$f":"'7. Viktning'!E43","v":0.1111111111111111},{"$f":"'5. Miljö'!F15","v":0},{"$f":"'5. Miljö'!G15","v":0},{"$f":"'5. Miljö'!H15","v":0},null,{"$f":"'5. Miljö'!J15","v":0},{"$f":"'5. Miljö'!K15","v":0},{"$f":"'5. Miljö'!L15","v":0},null,{"$f":"'5. Miljö'!N15","v":0},{"$f":"'5. Miljö'!O15","v":0},{"$f":"'5. Miljö'!P15","v":0},null,{"$f":"'5. Miljö'!R15","v":0},{"$f":"'5. Miljö'!S15","v":0},{"$f":"'5. Miljö'!T15","v":0},null,{"$f":"'5. Miljö'!V15","v":0},{"$f":"'5. Miljö'!W15","v":0},{"$f":"'5. Miljö'!X15","v":0},null,{"$f":"_xll.RiskPert(G42,H42,I42)","v":0},{"$f":"_xll.RiskPert(K42,L42,M42)","v":0},{"$f":"_xll.RiskPert(O42,P42,Q42)","v":0},{"$f":"_xll.RiskPert(S42,T42,U42)","v":0},{"$f":"_xll.RiskPert(W42,X42,Y42)","v":0},null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,null,null,{"$f":"'7. Viktning'!B44","v":"Materialanvändning"},2.7777777777777776E-2,{"$f":"'7. Viktning'!E44","v":0.1111111111111111},{"$f":"'5. Miljö'!F16","v":0},{"$f":"'5. Miljö'!G16","v":0},{"$f":"'5. Miljö'!H16","v":0},null,{"$f":"'5. Miljö'!J16","v":0},{"$f":"'5. Miljö'!K16","v":0},{"$f":"'5. Miljö'!L16","v":0},null,{"$f":"'5. Miljö'!N16","v":0},{"$f":"'5. Miljö'!O16","v":0},{"$f":"'5. Miljö'!P16","v":0},null,{"$f":"'5. Miljö'!R16","v":0},{"$f":"'5. Miljö'!S16","v":0},{"$f":"'5. Miljö'!T16","v":0},null,{"$f":"'5. Miljö'!V16","v":0},{"$f":"'5. Miljö'!W16","v":0},{"$f":"'5. Miljö'!X16","v":0},null,{"$f":"_xll.RiskPert(G43,H43,I43)","v":0},{"$f":"_xll.RiskPert(K43,L43,M43)","v":0},{"$f":"_xll.RiskPert(O43,P43,Q43)","v":0},{"$f":"_xll.RiskPert(S43,T43,U43)","v":0},{"$f":"_xll.RiskPert(W43,X43,Y43)","v":0},null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,null,null,{"$f":"'7. Viktning'!B45","v":"Kemikalieanvändning"},2.7777777777777776E-2,{"$f":"'7. Viktning'!E45","v":0.1111111111111111},{"$f":"'5. Miljö'!F17","v":0},{"$f":"'5. Miljö'!G17","v":0},{"$f":"'5. Miljö'!H17","v":0},null,{"$f":"'5. Miljö'!J17","v":0},{"$f":"'5. Miljö'!K17","v":0},{"$f":"'5. Miljö'!L17","v":0},null,{"$f":"'5. Miljö'!N17","v":0},{"$f":"'5. Miljö'!O17","v":0},{"$f":"'5. Miljö'!P17","v":0},null,{"$f":"'5. Miljö'!R17","v":0},{"$f":"'5. Miljö'!S17","v":0},{"$f":"'5. Miljö'!T17","v":0},null,{"$f":"'5. Miljö'!V17","v":0},{"$f":"'5. Miljö'!W17","v":0},{"$f":"'5. Miljö'!X17","v":0},null,{"$f":"_xll.RiskPert(G44,H44,I44)","v":0},{"$f":"_xll.RiskPert(K44,L44,M44)","v":0},{"$f":"_xll.RiskPert(O44,P44,Q44)","v":0},{"$f":"_xll.RiskPert(S44,T44,U44)","v":0},{"$f":"_xll.RiskPert(W44,X44,Y44)","v":0},null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,null,null,{"$f":"'7. Viktning'!B46","v":"Icke-återvinningsbart avfall"},2.7777777777777776E-2,{"$f":"'7. Viktning'!E46","v":0.1111111111111111},{"$f":"'5. Miljö'!F18","v":0},{"$f":"'5. Miljö'!G18","v":0},{"$f":"'5. Miljö'!H18","v":0},null,{"$f":"'5. Miljö'!J18","v":0},{"$f":"'5. Miljö'!K18","v":0},{"$f":"'5. Miljö'!L18","v":0},null,{"$f":"'5. Miljö'!N18","v":0},{"$f":"'5. Miljö'!O18","v":0},{"$f":"'5. Miljö'!P18","v":0},null,{"$f":"'5. Miljö'!R18","v":0},{"$f":"'5. Miljö'!S18","v":0},{"$f":"'5. Miljö'!T18","v":0},null,{"$f":"'5. Miljö'!V18","v":0},{"$f":"'5. Miljö'!W18","v":0},{"$f":"'5. Miljö'!X18","v":0},null,{"$f":"_xll.RiskPert(G45,H45,I45)","v":0},{"$f":"_xll.RiskPert(K45,L45,M45)","v":0},{"$f":"_xll.RiskPert(O45,P45,Q45)","v":0},{"$f":"_xll.RiskPert(S45,T45,U45)","v":0},{"$f":"_xll.RiskPert(W45,X45,Y45)","v":0},null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,null,null,{"$f":"'7. Viktning'!B47","v":"Ytterligare kriterium"},0,{"$f":"'7. Viktning'!E47","v":0},{"$f":"'5. Miljö'!F19","v":0},{"$f":"'5. Miljö'!G19","v":0},{"$f":"'5. Miljö'!H19","v":0},null,{"$f":"'5. Miljö'!J19","v":0},{"$f":"'5. Miljö'!K19","v":0},{"$f":"'5. Miljö'!L19","v":0},null,{"$f":"'5. Miljö'!N19","v":0},{"$f":"'5. Miljö'!O19","v":0},{"$f":"'5. Miljö'!P19","v":0},null,{"$f":"'5. Miljö'!R19","v":0},{"$f":"'5. Miljö'!S19","v":0},{"$f":"'5. Miljö'!T19","v":0},null,{"$f":"'5. Miljö'!V19","v":0},{"$f":"'5. Miljö'!W19","v":0},{"$f":"'5. Miljö'!X19","v":0},null,{"$f":"_xll.RiskPert(G46,H46,I46)","v":0},{"$f":"_xll.RiskPert(K46,L46,M46)","v":0},{"$f":"_xll.RiskPert(O46,P46,Q46)","v":0},{"$f":"_xll.RiskPert(S46,T46,U46)","v":0},{"$f":"_xll.RiskPert(W46,X46,Y46)","v":0},null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,null,null,{"$f":"'7. Viktning'!B48","v":"Ytterligare kriterium"},0,{"$f":"'7. Viktning'!E48","v":0},{"$f":"'5. Miljö'!F20","v":0},{"$f":"'5. Miljö'!G20","v":0},{"$f":"'5. Miljö'!H20","v":0},null,{"$f":"'5. Miljö'!J20","v":0},{"$f":"'5. Miljö'!K20","v":0},{"$f":"'5. Miljö'!L20","v":0},null,{"$f":"'5. Miljö'!N20","v":0},{"$f":"'5. Miljö'!O20","v":0},{"$f":"'5. Miljö'!P20","v":0},null,{"$f":"'5. Miljö'!R20","v":0},{"$f":"'5. Miljö'!S20","v":0},{"$f":"'5. Miljö'!T20","v":0},null,{"$f":"'5. Miljö'!V20","v":0},{"$f":"'5. Miljö'!W20","v":0},{"$f":"'5. Miljö'!X20","v":0},null,{"$f":"_xll.RiskPert(G47,H47,I47)","v":0},{"$f":"_xll.RiskPert(K47,L47,M47)","v":0},{"$f":"_xll.RiskPert(O47,P47,Q47)","v":0},{"$f":"_xll.RiskPert(S47,T47,U47)","v":0},{"$f":"_xll.RiskPert(W47,X47,Y47)","v":0},null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,null,null,{"$f":"'7. Viktning'!B49","v":"Ytterligare kriterium"},0,{"$f":"'7. Viktning'!E49","v":0},{"$f":"'5. Miljö'!F21","v":0},{"$f":"'5. Miljö'!G21","v":0},{"$f":"'5. Miljö'!H21","v":0},null,{"$f":"'5. Miljö'!J21","v":0},{"$f":"'5. Miljö'!K21","v":0},{"$f":"'5. Miljö'!L21","v":0},null,{"$f":"'5. Miljö'!N21","v":0},{"$f":"'5. Miljö'!O21","v":0},{"$f":"'5. Miljö'!P21","v":0},null,{"$f":"'5. Miljö'!R21","v":0},{"$f":"'5. Miljö'!S21","v":0},{"$f":"'5. Miljö'!T21","v":0},null,{"$f":"'5. Miljö'!V21","v":0},{"$f":"'5. Miljö'!W21","v":0},{"$f":"'5. Miljö'!X21","v":0},null,{"$f":"_xll.RiskPert(G48,H48,I48)","v":0},{"$f":"_xll.RiskPert(K48,L48,M48)","v":0},{"$f":"_xll.RiskPert(O48,P48,Q48)","v":0},{"$f":"_xll.RiskPert(S48,T48,U48)","v":0},{"$f":"_xll.RiskPert(W48,X48,Y48)","v":0},null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[]
[]
[null,null,"Ekonomiskt",{"$f":"C51","v":"Ekonomiskt"},null,{"$f":"'7. Viktning'!E69","v":0.25},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F51>0,1,0)","v":1},{"$f":"C51&\" index\"","v":"Ekonomiskt index"},{"$f":"_xll.RiskOutput()+SUM(AH52:AH57)*$AF51","v":{"$error":"#DIV/0!"}},{"$f":"_xll.RiskOutput()+SUM(AI52:AI57)*$AF51","v":{"$error":"#DIV/0!"}},{"$f":"_xll.RiskOutput()+SUM(AJ52:AJ57)*$AF51","v":{"$error":"#DIV/0!"}},{"$f":"_xll.RiskOutput()+SUM(AK52:AK57)*$AF51","v":{"$error":"#DIV/0!"}},{"$f":"_xll.RiskOutput()+SUM(AL52:AL57)*$AF51","v":{"$error":"#DIV/0!"}},null,{"$f":"AG51","v":"Ekonomiskt index"},{"$f":"SUM(AO52:AO57)*$AF51","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AP52:AP57)*$AF51","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$f":"MAX(ABS(AV52:AZ57))","v":0}]
[null,null,null,{"$f":"'7. Viktning'!B55","v":"Investeringskostnader"},{"$f":"$F$51*F52","v":0.125},{"$f":"'7. Viktning'!E55","v":0.5},{"$f":"'6. Ekonomi'!E10","v":0},{"$f":"'6. Ekonomi'!F10","v":0},{"$f":"'6. Ekonomi'!G10","v":0},null,{"$f":"'6. Ekonomi'!I10","v":0},{"$f":"'6. Ekonomi'!J10","v":0},{"$f":"'6. Ekonomi'!K10","v":0},null,{"$f":"'6. Ekonomi'!M10","v":0},{"$f":"'6. Ekonomi'!N10","v":0},{"$f":"'6. Ekonomi'!O10","v":0},null,{"$f":"'6. Ekonomi'!Q10","v":0},{"$f":"'6. Ekonomi'!R10","v":0},{"$f":"'6. Ekonomi'!S10","v":0},null,{"$f":"'6. Ekonomi'!U10","v":0},{"$f":"'6. Ekonomi'!V10","v":0},{"$f":"'6. Ekonomi'!W10","v":0},null,{"$f":"_xll.RiskPert(G52,H52,I52)*IF(F52>0,1,0)","v":0},{"$f":"_xll.RiskPert(K52,L52,M52)*IF(F52>0,1,0)","v":0},{"$f":"_xll.RiskPert(O52,P52,Q52)*IF(F52>0,1,0)","v":0},{"$f":"_xll.RiskPert(S52,T52,U52)*IF(F52>0,1,0)","v":0},{"$f":"_xll.RiskPert(W52,X52,Y52)*IF(F52>0,1,0)","v":0},null,null,{"$f":"AA52/MAX(ABS($G$60:$Y$65))*$F52*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"AB52/MAX(ABS($G$60:$Y$65))*$F52*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"AC52/MAX(ABS($G$60:$Y$65))*$F52*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"AD52/MAX(ABS($G$60:$Y$65))*$F52*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"AE52/MAX(ABS($G$60:$Y$65))*$F52*(-10)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"$F52*H52/$AV$51*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"$F52*L52/$AV$51*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"$F52*P52/$AV$51*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"$F52*T52/$AV$51*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"$F52*X52/$AV$51*(-10)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"H52*IF(F52>0,1,0)","v":0},{"$f":"L52*IF(F52>0,1,0)","v":0},{"$f":"P52*IF(F52>0,1,0)","v":0},{"$f":"T52*IF(F52>0,1,0)","v":0},{"$f":"X52*IF(F52>0,1,0)","v":0}]
[null,null,null,{"$f":"'7. Viktning'!B56","v":"Drift- och underhållskostnader"},{"$f":"$F$51*F53","v":0.125},{"$f":"'7. Viktning'!E56","v":0.5},{"$f":"'6. Ekonomi'!E11","v":0},{"$f":"'6. Ekonomi'!F11","v":0},{"$f":"'6. Ekonomi'!G11","v":0},null,{"$f":"'6. Ekonomi'!I11","v":0},{"$f":"'6. Ekonomi'!J11","v":0},{"$f":"'6. Ekonomi'!K11","v":0},null,{"$f":"'6. Ekonomi'!M11","v":0},{"$f":"'6. Ekonomi'!N11","v":0},{"$f":"'6. Ekonomi'!O11","v":0},null,{"$f":"'6. Ekonomi'!Q11","v":0},{"$f":"'6. Ekonomi'!R11","v":0},{"$f":"'6. Ekonomi'!S11","v":0},null,{"$f":"'6. Ekonomi'!U11","v":0},{"$f":"'6. Ekonomi'!V11","v":0},{"$f":"'6. Ekonomi'!W11","v":0},null,{"$f":"_xll.RiskPert(G53,H53,I53)*IF(F53>0,1,0)","v":0},{"$f":"_xll.RiskPert(K53,L53,M53)*IF(F53>0,1,0)","v":0},{"$f":"_xll.RiskPert(O53,P53,Q53)*IF(F53>0,1,0)","v":0},{"$f":"_xll.RiskPert(S53,T53,U53)*IF(F53>0,1,0)","v":0},{"$f":"_xll.RiskPert(W53,X53,Y53)*IF(F53>0,1,0)","v":0},null,null,{"$f":"AA53/MAX(ABS($G$60:$Y$65))*$F53*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"AB53/MAX(ABS($G$60:$Y$65))*$F53*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"AC53/MAX(ABS($G$60:$Y$65))*$F53*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"AD53/MAX(ABS($G$60:$Y$65))*$F53*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"AE53/MAX(ABS($G$60:$Y$65))*$F53*(-10)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"$F53*H53/$AV$51*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"$F53*L53/$AV$51*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"$F53*P53/$AV$51*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"$F53*T53/$AV$51*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"$F53*X53/$AV$51*(-10)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"H53*IF(F53>0,1,0)","v":0},{"$f":"L53*IF(F53>0,1,0)","v":0},{"$f":"P53*IF(F53>0,1,0)","v":0},{"$f":"T53*IF(F53>0,1,0)","v":0},{"$f":"X53*IF(F53>0,1,0)","v":0}]
[null,null,null,{"$f":"'7. Viktning'!B57","v":"Ytterligare kriterium"},{"$f":"$F$51*F54","v":0},{"$f":"'7. Viktning'!E57","v":0},{"$f":"'6. Ekonomi'!E12","v":0},{"$f":"'6. Ekonomi'!F12","v":0},{"$f":"'6. Ekonomi'!G12","v":0},null,{"$f":"'6. Ekonomi'!I12","v":0},{"$f":"'6. Ekonomi'!J12","v":0},{"$f":"'6. Ekonomi'!K12","v":0},null,{"$f":"'6. Ekonomi'!M12","v":0},{"$f":"'6. Ekonomi'!N12","v":0},{"$f":"'6. Ekonomi'!O12","v":0},null,{"$f":"'6. Ekonomi'!Q12","v":0},{"$f":"'6. Ekonomi'!R12","v":0},{"$f":"'6. Ekonomi'!S12","v":0},null,{"$f":"'6. Ekonomi'!U12","v":0},{"$f":"'6. Ekonomi'!V12","v":0},{"$f":"'6. Ekonomi'!W12","v":0},null,{"$f":"_xll.RiskPert(G54,H54,I54)*IF(F54>0,1,0)","v":0},{"$f":"_xll.RiskPert(K54,L54,M54)*IF(F54>0,1,0)","v":0},{"$f":"_xll.RiskPert(O54,P54,Q54)*IF(F54>0,1,0)","v":0},{"$f":"_xll.RiskPert(S54,T54,U54)*IF(F54>0,1,0)","v":0},{"$f":"_xll.RiskPert(W54,X54,Y54)*IF(F54>0,1,0)","v":0},null,null,{"$f":"AA54/MAX(ABS($G$60:$Y$65))*$F54*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"AB54/MAX(ABS($G$60:$Y$65))*$F54*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"AC54/MAX(ABS($G$60:$Y$65))*$F54*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"AD54/MAX(ABS($G$60:$Y$65))*$F54*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"AE54/MAX(ABS($G$60:$Y$65))*$F54*(-10)","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,0,0,0,0,0]
[null,null,null,{"$f":"'7. Viktning'!B58","v":"Ytterligare kriterium"},0,{"$f":"'7. Viktning'!E58","v":0},{"$f":"'6. Ekonomi'!E13","v":0},{"$f":"'6. Ekonomi'!F13","v":0},{"$f":"'6. Ekonomi'!G13","v":0},null,{"$f":"'6. Ekonomi'!I13","v":0},{"$f":"'6. Ekonomi'!J13","v":0},{"$f":"'6. Ekonomi'!K13","v":0},null,{"$f":"'6. Ekonomi'!M13","v":0},{"$f":"'6. Ekonomi'!N13","v":0},{"$f":"'6. Ekonomi'!O13","v":0},null,{"$f":"'6. Ekonomi'!Q13","v":0},{"$f":"'6. Ekonomi'!R13","v":0},{"$f":"'6. Ekonomi'!S13","v":0},null,{"$f":"'6. Ekonomi'!U13","v":0},{"$f":"'6. Ekonomi'!V13","v":0},{"$f":"'6. Ekonomi'!W13","v":0},null,{"$f":"_xll.RiskPert(G55,H55,I55)*IF(F55>0,1,0)","v":0},{"$f":"_xll.RiskPert(K55,L55,M55)*IF(F55>0,1,0)","v":0},{"$f":"_xll.RiskPert(O55,P55,Q55)*IF(F55>0,1,0)","v":0},{"$f":"_xll.RiskPert(S55,T55,U55)*IF(F55>0,1,0)","v":0},{"$f":"_xll.RiskPert(W55,X55,Y55)*IF(F55>0,1,0)","v":0},null,null,{"$f":"AA55/MAX(ABS($G$60:$Y$65))*$F55*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"AB55/MAX(ABS($G$60:$Y$65))*$F55*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"AC55/MAX(ABS($G$60:$Y$65))*$F55*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"AD55/MAX(ABS($G$60:$Y$65))*$F55*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"AE55/MAX(ABS($G$60:$Y$65))*$F55*(-10)","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,0,0,0,0,0]
[null,null,null,{"$f":"'7. Viktning'!B59","v":"Ytterligare kriterium"},0,{"$f":"'7. Viktning'!E59","v":0},{"$f":"'6. Ekonomi'!E14","v":0},{"$f":"'6. Ekonomi'!F14","v":0},{"$f":"'6. Ekonomi'!G14","v":0},null,{"$f":"'6. Ekonomi'!I14","v":0},{"$f":"'6. Ekonomi'!J14","v":0},{"$f":"'6. Ekonomi'!K14","v":0},null,{"$f":"'6. Ekonomi'!M14","v":0},{"$f":"'6. Ekonomi'!N14","v":0},{"$f":"'6. Ekonomi'!O14","v":0},null,{"$f":"'6. Ekonomi'!Q14","v":0},{"$f":"'6. Ekonomi'!R14","v":0},{"$f":"'6. Ekonomi'!S14","v":0},null,{"$f":"'6. Ekonomi'!U14","v":0},{"$f":"'6. Ekonomi'!V14","v":0},{"$f":"'6. Ekonomi'!W14","v":0},null,{"$f":"_xll.RiskPert(G56,H56,I56)*IF(F56>0,1,0)","v":0},{"$f":"_xll.RiskPert(K56,L56,M56)*IF(F56>0,1,0)","v":0},{"$f":"_xll.RiskPert(O56,P56,Q56)*IF(F56>0,1,0)","v":0},{"$f":"_xll.RiskPert(S56,T56,U56)*IF(F56>0,1,0)","v":0},{"$f":"_xll.RiskPert(W56,X56,Y56)*IF(F56>0,1,0)","v":0},null,null,{"$f":"AA56/MAX(ABS($G$60:$Y$65))*$F56*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"AB56/MAX(ABS($G$60:$Y$65))*$F56*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"AC56/MAX(ABS($G$60:$Y$65))*$F56*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"AD56/MAX(ABS($G$60:$Y$65))*$F56*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"AE56/MAX(ABS($G$60:$Y$65))*$F56*(-10)","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,0,0,0,0,0]
[null,null,null,{"$f":"'7. Viktning'!B60","v":"Ytterligare kriterium"},0,{"$f":"'7. Viktning'!E60","v":0},{"$f":"'6. Ekonomi'!E15","v":0},{"$f":"'6. Ekonomi'!F15","v":0},{"$f":"'6. Ekonomi'!G15","v":0},null,{"$f":"'6. Ekonomi'!I15","v":0},{"$f":"'6. Ekonomi'!J15","v":0},{"$f":"'6. Ekonomi'!K15","v":0},null,{"$f":"'6. Ekonomi'!M15","v":0},{"$f":"'6. Ekonomi'!N15","v":0},{"$f":"'6. Ekonomi'!O15","v":0},null,{"$f":"'6. Ekonomi'!Q15","v":0},{"$f":"'6. Ekonomi'!R15","v":0},{"$f":"'6. Ekonomi'!S15","v":0},null,{"$f":"'6. Ekonomi'!U15","v":0},{"$f":"'6. Ekonomi'!V15","v":0},{"$f":"'6. Ekonomi'!W15","v":0},null,{"$f":"_xll.RiskPert(G57,H57,I57)*IF(F57>0,1,0)","v":0},{"$f":"_xll.RiskPert(K57,L57,M57)*IF(F57>0,1,0)","v":0},{"$f":"_xll.RiskPert(O57,P57,Q57)*IF(F57>0,1,0)","v":0},{"$f":"_xll.RiskPert(S57,T57,U57)*IF(F57>0,1,0)","v":0},{"$f":"_xll.RiskPert(W57,X57,Y57)*IF(F57>0,1,0)","v":0},null,null,{"$f":"AA57/MAX(ABS($G$60:$Y$65))*$F57*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"AB57/MAX(ABS($G$60:$Y$65))*$F57*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"AC57/MAX(ABS($G$60:$Y$65))*$F57*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"AD57/MAX(ABS($G$60:$Y$65))*$F57*(-10)","v":{"$error":"#DIV/0!"}},{"$f":"AE57/MAX(ABS($G$60:$Y$65))*$F57*(-10)","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total årskostnad",null,{"$f":"_xll.RiskOutput()+SUM(AA52:AA57)","v":0},{"$f":"_xll.RiskOutput()+SUM(AB52:AB57)","v":0},{"$f":"_xll.RiskOutput()+SUM(AC52:AC57)","v":0},{"$f":"_xll.RiskOutput()+SUM(AD52:AD57)","v":0},{"$f":"_xll.RiskOutput()+SUM(AE52:AE57)","v":0},null,{"$f":"MAX(G52:Y57)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AV52:AV57)","v":0},{"$f":"SUM(AW52:AW57)","v":0},0,0,0]
[null,null,null,null,null,null,{"$f":"G52*IF($F52>0,1,0)","v":0},{"$f":"H52*IF($F52>0,1,0)","v":0},0,null,{"$f":"K52*IF($F52>0,1,0)","v":0},{"$f":"L52*IF($F52>0,1,0)","v":0},0,null,{"$f":"O52*IF($F52>0,1,0)","v":0},{"$f":"P52*IF($F52>0,1,0)","v":0},0,null,{"$f":"S52*IF($F52>0,1,0)","v":0},{"$f":"T52*IF($F52>0,1,0)","v":0},0,null,{"$f":"W52*IF($F52>0,1,0)","v":0},{"$f":"X52*IF($F52>0,1,0)","v":0},0,null,null,null,null,null,null,null,{"$f":"MAX(ABS(G52:Y57))","v":0}]
[null,null,null,null,null,null,{"$f":"G53*IF($F53>0,1,0)","v":0},0,0,null,{"$f":"K53*IF($F53>0,1,0)","v":0},0,0,null,{"$f":"O53*IF($F53>0,1,0)","v":0},0,0,null,{"$f":"S53*IF($F53>0,1,0)","v":0},0,0,null,{"$f":"W53*IF($F53>0,1,0)","v":0},0,0]
[null,null,null,null,null,null,{"$f":"G54*IF($F54>0,1,0)","v":0},0,0,null,{"$f":"K54*IF($F54>0,1,0)","v":0},0,0,null,{"$f":"O54*IF($F54>0,1,0)","v":0},0,0,null,{"$f":"S54*IF($F54>0,1,0)","v":0},0,0,null,{"$f":"W54*IF($F54>0,1,0)","v":0},0,0]
[null,null,null,null,null,null,{"$f":"G55*IF($F55>0,1,0)","v":0},0,0,null,{"$f":"K55*IF($F55>0,1,0)","v":0},0,0,null,{"$f":"O55*IF($F55>0,1,0)","v":0},0,0,null,{"$f":"S55*IF($F55>0,1,0)","v":0},0,0,null,{"$f":"W55*IF($F55>0,1,0)","v":0},0,0]
[null,null,null,null,null,null,{"$f":"G56*IF($F56>0,1,0)","v":0},0,0,null,{"$f":"K56*IF($F56>0,1,0)","v":0},0,0,null,{"$f":"O56*IF($F56>0,1,0)","v":0},0,0,null,{"$f":"S56*IF($F56>0,1,0)","v":0},0,0,null,{"$f":"W56*IF($F56>0,1,0)","v":0},0,0]
[null,null,null,null,null,null,{"$f":"G57*IF($F57>0,1,0)","v":0},0,0,null,{"$f":"K57*IF($F57>0,1,0)","v":0},0,0,null,{"$f":"O57*IF($F57>0,1,0)","v":0},0,0,null,{"$f":"S57*IF($F57>0,1,0)","v":0},0,0,null,{"$f":"W57*IF($F57>0,1,0)","v":0},0,0]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"'Beräkningar (rör ej)'!C5","v":"Total"},null,null,null,null,null,{"$f":"'Beräkningar (rör ej)'!C9","v":"Tekniskt"},null,null,null,null,null,{"$f":"'Beräkningar (rör ej)'!C21","v":"Socialt"},null,null,null,null,null,{"$f":"'Beräkningar (rör ej)'!C36","v":"Miljömässigt"},null,null,null,null,null,{"$f":"'Beräkningar (rör ej)'!C51","v":"Ekonomiskt"},null,null,null,null,"Sannolikhet högst",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total årskostnad"]
[null,null,null,null,null,0.05,0.5,0.95,null,null,null,0.05,0.5,0.95,null,null,null,0.05,0.5,0.95,null,null,null,0.05,0.5,0.95,null,null,null,0.05,0.5,0.95,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.05,0.5,0.95]
[null,null,null,null,"min","P05","P50","P95","max",null,"min","P05","P50","P95","max",null,"min","P05","P50","P95","max",null,"min","P05","P50","P95","max",null,"min","P05","P50","P95","max",null,"Sammanvägt",{"$f":"'Beräkningar (rör ej)'!C9","v":"Tekniskt"},{"$f":"'Beräkningar (rör ej)'!C21","v":"Socialt"},{"$f":"'Beräkningar (rör ej)'!C36","v":"Miljömässigt"},{"$f":"'Beräkningar (rör ej)'!C51","v":"Ekonomiskt"},null,{"$f":"AI75","v":"Sammanvägt"},{"$f":"AJ75","v":"Tekniskt"},{"$f":"AK75","v":"Socialt"},{"$f":"AL75","v":"Miljömässigt"},{"$f":"AM75","v":"Ekonomiskt"},null,null,"Sammanvägt index","Total årskostnad",null,"P05","P50","P95",null,null,null,null,null,null,null,null,{"$f":"AP75","v":"Tekniskt"},{"$f":"AQ75","v":"Socialt"},{"$f":"AR75","v":"Miljömässigt"},{"$f":"AS75","v":"Ekonomiskt"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AN6","v":"Sammanvägt index"},{"$f":"AN9","v":"Tekniskt index"},{"$f":"AN21","v":"Socialt index"},{"$f":"AN36","v":"Miljömässigt index"},{"$f":"AN51","v":"Ekonomiskt index"},"Årskostnad"]
[1,1,1,"Alt. 1",{"$f":"_xll.RiskMin('Beräkningar (rör ej)'!AH6)","v":{"$error":"#N/A"}},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AH$6,F$74)","v":{"$error":"#NUM!"}},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AH$6,G$74)","v":{"$error":"#NUM!"}},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AH$6,H$74)","v":{"$error":"#NUM!"}},{"$f":"_xll.RiskMax('Beräkningar (rör ej)'!AH6)","v":{"$error":"#N/A"}},null,{"$f":"_xll.RiskMin(AH9)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AH$9,L$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AH$9,M$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AH$9,N$74)","v":0},{"$f":"_xll.RiskMax(AH9)","v":0},null,{"$f":"_xll.RiskMin(AH21)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AH$21,R$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AH$21,S$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AH$21,T$74)","v":0},{"$f":"_xll.RiskMax(AH21)","v":0},null,{"$f":"_xll.RiskMin(AH36)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AH$36,X$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AH$36,Y$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AH$36,Z$74)","v":0},{"$f":"_xll.RiskMax(AH36)","v":0},null,{"$f":"_xll.RiskMin(AH51)","v":{"$error":"#N/A"}},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AH$51,AD$74)","v":{"$error":"#NUM!"}},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AH$51,AE$74)","v":{"$error":"#NUM!"}},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AH$51,AF$74)","v":{"$error":"#NUM!"}},{"$f":"_xll.RiskMax(AH51)","v":{"$error":"#N/A"}},null,{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!BE7)","v":{"$error":"#N/A"}},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!BE9)","v":0},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!BE11)","v":0},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!BE13)","v":0},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!BE15)","v":{"$error":"#N/A"}},null,{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AH6)","v":{"$error":"#N/A"}},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AH9)*'Beräkningar (rör ej)'!F9","v":0},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AH21)*'Beräkningar (rör ej)'!F21","v":0},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AH36)*'Beräkningar (rör ej)'!F36","v":0},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AH51)*'Beräkningar (rör ej)'!F51","v":{"$error":"#N/A"}},{"$f":"SUM(AP77:AS77)","v":{"$error":"#N/A"}},null,{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AH6)","v":{"$error":"#N/A"}},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AA59)","v":0},null,{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AA$59,AY$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AA$59,AZ$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AA$59,BA$74)","v":0},null,{"$f":"TRANSPOSE(AO6:AS6)","v":{"$error":"#DIV/0!"}},{"$f":"TRANSPOSE(AO9:AS9)","v":0},{"$f":"TRANSPOSE(AO21:AS21)","v":0},{"$f":"TRANSPOSE(AO36:AS36)","v":0},{"$f":"TRANSPOSE(AO51:AS51)","v":{"$error":"#DIV/0!"}},{"$f":"TRANSPOSE(AV59:AZ59)","v":0},null,{"$f":"BD77*$F$9","v":0},{"$f":"BE77*$F$21","v":0},{"$f":"BF77*$F$36","v":0},{"$f":"BG77*$F$51","v":{"$error":"#DIV/0!"}}]
[2,2,2,"Alt. 2",{"$f":"_xll.RiskMin('Beräkningar (rör ej)'!AI6)","v":{"$error":"#N/A"}},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AI$6,F$74)","v":{"$error":"#NUM!"}},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AI$6,G$74)","v":{"$error":"#NUM!"}},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AI$6,H$74)","v":{"$error":"#NUM!"}},{"$f":"_xll.RiskMax('Beräkningar (rör ej)'!AI6)","v":{"$error":"#N/A"}},null,{"$f":"_xll.RiskMin(AI9)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AI$9,L$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AI$9,M$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AI$9,N$74)","v":0},{"$f":"_xll.RiskMax(AI9)","v":0},null,{"$f":"_xll.RiskMin(AI21)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AI$21,R$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AI$21,S$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AI$21,T$74)","v":0},{"$f":"_xll.RiskMax(AI21)","v":0},null,{"$f":"_xll.RiskMin(AI36)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AI$36,X$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AI$36,Y$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AI$36,Z$74)","v":0},{"$f":"_xll.RiskMax(AI36)","v":0},null,{"$f":"_xll.RiskMin(AI51)","v":{"$error":"#N/A"}},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AI$51,AD$74)","v":{"$error":"#NUM!"}},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AI$51,AE$74)","v":{"$error":"#NUM!"}},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AI$51,AF$74)","v":{"$error":"#NUM!"}},{"$f":"_xll.RiskMax(AI51)","v":{"$error":"#N/A"}},null,{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!BF7)","v":{"$error":"#N/A"}},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!BF9)","v":0},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!BF11)","v":0},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!BF13)","v":0},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!BF15)","v":{"$error":"#N/A"}},null,{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AI6)","v":{"$error":"#N/A"}},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AI9)*'Beräkningar (rör ej)'!F9","v":0},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AI21)*'Beräkningar (rör ej)'!F21","v":0},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AI36)*'Beräkningar (rör ej)'!F36","v":0},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AI51)*'Beräkningar (rör ej)'!F51","v":{"$error":"#N/A"}},{"$f":"SUM(AP78:AS78)","v":{"$error":"#N/A"}},null,{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AI6)","v":{"$error":"#N/A"}},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AB59)","v":0},null,{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AB$59,AY$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AB$59,AZ$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AB$59,BA$74)","v":0},null,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},0,null,{"$f":"BD78*$F$9","v":0},{"$f":"BE78*$F$21","v":0},{"$f":"BF78*$F$36","v":0},{"$f":"BG78*$F$51","v":{"$error":"#DIV/0!"}}]
[3,3,3,"Alt. 3",{"$f":"_xll.RiskMin('Beräkningar (rör ej)'!AJ8)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AJ$6,F$74)","v":{"$error":"#NUM!"}},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AJ$6,G$74)","v":{"$error":"#NUM!"}},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AJ$6,H$74)","v":{"$error":"#NUM!"}},{"$f":"_xll.RiskMax('Beräkningar (rör ej)'!AJ8)","v":0},null,{"$f":"_xll.RiskMin(AJ9)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AJ$9,L$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AJ$9,M$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AJ$9,N$74)","v":0},{"$f":"_xll.RiskMax(AJ9)","v":0},null,{"$f":"_xll.RiskMin(AJ21)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AJ$21,R$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AJ$21,S$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AJ$21,T$74)","v":0},{"$f":"_xll.RiskMax(AJ21)","v":0},null,{"$f":"_xll.RiskMin(AJ36)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AJ$36,X$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AJ$36,Y$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AJ$36,Z$74)","v":0},{"$f":"_xll.RiskMax(AJ36)","v":0},null,{"$f":"_xll.RiskMin(AJ51)","v":{"$error":"#N/A"}},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AJ$51,AD$74)","v":{"$error":"#NUM!"}},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AJ$51,AE$74)","v":{"$error":"#NUM!"}},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AJ$51,AF$74)","v":{"$error":"#NUM!"}},{"$f":"_xll.RiskMax(AJ51)","v":{"$error":"#N/A"}},null,{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!BG7)","v":{"$error":"#N/A"}},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!BG9)","v":0},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!BG11)","v":0},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!BG13)","v":0},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!BG15)","v":{"$error":"#N/A"}},null,{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AJ6)","v":{"$error":"#N/A"}},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AJ9)*'Beräkningar (rör ej)'!F9","v":0},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AJ21)*'Beräkningar (rör ej)'!F21","v":0},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AJ36)*'Beräkningar (rör ej)'!F36","v":0},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AJ51)*'Beräkningar (rör ej)'!F51","v":{"$error":"#N/A"}},{"$f":"SUM(AP79:AS79)","v":{"$error":"#N/A"}},null,{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AJ6)","v":{"$error":"#N/A"}},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AC59)","v":0},null,{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AC$59,AY$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AC$59,AZ$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AC$59,BA$74)","v":0},null,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},0,null,0,0,0,{"$error":"#DIV/0!"}]
[4,4,4,"Alt. 4",{"$f":"_xll.RiskMin('Beräkningar (rör ej)'!AK8)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AK$6,F$74)","v":{"$error":"#NUM!"}},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AK$6,G$74)","v":{"$error":"#NUM!"}},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AK$6,H$74)","v":{"$error":"#NUM!"}},{"$f":"_xll.RiskMax('Beräkningar (rör ej)'!AK8)","v":0},null,{"$f":"_xll.RiskMin(AK9)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AK$9,L$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AK$9,M$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AK$9,N$74)","v":0},{"$f":"_xll.RiskMax(AK9)","v":0},null,{"$f":"_xll.RiskMin(AK21)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AK$21,R$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AK$21,S$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AK$21,T$74)","v":0},{"$f":"_xll.RiskMax(AK21)","v":0},null,{"$f":"_xll.RiskMin(AK36)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AK$36,X$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AK$36,Y$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AK$36,Z$74)","v":0},{"$f":"_xll.RiskMax(AK36)","v":0},null,{"$f":"_xll.RiskMin(AK51)","v":{"$error":"#N/A"}},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AK$51,AD$74)","v":{"$error":"#NUM!"}},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AK$51,AE$74)","v":{"$error":"#NUM!"}},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AK$51,AF$74)","v":{"$error":"#NUM!"}},{"$f":"_xll.RiskMax(AK51)","v":{"$error":"#N/A"}},null,{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!BH7)","v":{"$error":"#N/A"}},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!BH9)","v":0},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!BH11)","v":0},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!BH13)","v":0},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!BH15)","v":{"$error":"#N/A"}},null,{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AK6)","v":{"$error":"#N/A"}},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AK9)*'Beräkningar (rör ej)'!F9","v":0},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AK21)*'Beräkningar (rör ej)'!F21","v":0},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AK36)*'Beräkningar (rör ej)'!F36","v":0},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AK51)*'Beräkningar (rör ej)'!F51","v":{"$error":"#N/A"}},{"$f":"SUM(AP80:AS80)","v":{"$error":"#N/A"}},null,{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AK6)","v":{"$error":"#N/A"}},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AD59)","v":0},null,{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AD$59,AY$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AD$59,AZ$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AD$59,BA$74)","v":0},null,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},0,null,0,0,0,{"$error":"#DIV/0!"}]
[5,5,5,"Alt. 5",{"$f":"_xll.RiskMin('Beräkningar (rör ej)'!AL6)","v":{"$error":"#N/A"}},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AL$6,F$74)","v":{"$error":"#NUM!"}},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AL$6,G$74)","v":{"$error":"#NUM!"}},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AL$6,H$74)","v":{"$error":"#NUM!"}},{"$f":"_xll.RiskMax('Beräkningar (rör ej)'!AL6)","v":{"$error":"#N/A"}},null,{"$f":"_xll.RiskMin(AL9)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AL$9,L$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AL$9,M$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AL$9,N$74)","v":0},{"$f":"_xll.RiskMax(AL9)","v":0},null,{"$f":"_xll.RiskMin(AL21)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AL$21,R$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AL$21,S$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AL$21,T$74)","v":0},{"$f":"_xll.RiskMax(AL21)","v":0},null,{"$f":"_xll.RiskMin(AL36)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AL$36,X$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AL$36,Y$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AL$36,Z$74)","v":0},{"$f":"_xll.RiskMax(AL36)","v":0},null,{"$f":"_xll.RiskMin(AL51)","v":{"$error":"#N/A"}},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AL$51,AD$74)","v":{"$error":"#NUM!"}},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AL$51,AE$74)","v":{"$error":"#NUM!"}},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AL$51,AF$74)","v":{"$error":"#NUM!"}},{"$f":"_xll.RiskMax(AL51)","v":{"$error":"#N/A"}},null,{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!BI7)","v":{"$error":"#N/A"}},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!BI9)","v":0},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!BI11)","v":0},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!BI13)","v":0},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!BI15)","v":{"$error":"#N/A"}},null,{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AL6)","v":{"$error":"#N/A"}},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AL9)*'Beräkningar (rör ej)'!F9","v":0},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AL21)*'Beräkningar (rör ej)'!F21","v":0},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AL36)*'Beräkningar (rör ej)'!F36","v":0},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AL51)*'Beräkningar (rör ej)'!F51","v":{"$error":"#N/A"}},{"$f":"SUM(AP81:AS81)","v":{"$error":"#N/A"}},null,{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AL6)","v":{"$error":"#N/A"}},{"$f":"_xll.RiskMean('Beräkningar (rör ej)'!AE59)","v":0},null,{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AE$59,AY$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AE$59,AZ$74)","v":0},{"$f":"_xll.RiskPercentile('Beräkningar (rör ej)'!$AE$59,BA$74)","v":0},null,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},0,null,0,0,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,"Median"]
[]
[null,null,null,{"$f":"D77","v":"Alt. 1"},null,{"$f":"F77","v":{"$error":"#NUM!"}},{"$f":"G77-F77","v":{"$error":"#NUM!"}},{"$f":"H77-G77","v":{"$error":"#NUM!"}},null,null,null,{"$f":"L77","v":0},{"$f":"M77-L77","v":0},{"$f":"N77-M77","v":0},null,null,null,{"$f":"R77","v":0},{"$f":"S77-R77","v":0},{"$f":"T77-S77","v":0},null,null,null,{"$f":"X77","v":0},{"$f":"Y77-X77","v":0},{"$f":"Z77-Y77","v":0},null,null,null,{"$f":"AD77","v":{"$error":"#NUM!"}},{"$f":"AE77-AD77","v":{"$error":"#NUM!"}},{"$f":"AF77-AE77","v":{"$error":"#NUM!"}}]
[null,null,null,{"$f":"D78","v":"Alt. 2"},null,{"$f":"F78","v":{"$error":"#NUM!"}},{"$f":"G78-F78","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,null,null,{"$f":"L78","v":0},{"$f":"M78-L78","v":0},0,null,null,null,{"$f":"R78","v":0},{"$f":"S78-R78","v":0},0,null,null,null,{"$f":"X78","v":0},{"$f":"Y78-X78","v":0},0,null,null,null,{"$f":"AD78","v":{"$error":"#NUM!"}},{"$f":"AE78-AD78","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F52>0,1,0)","v":1}]
[null,null,null,"Alt. 3",null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,0,{"$f":"M79-L79","v":0},0,null,null,null,0,{"$f":"S79-R79","v":0},0,null,null,null,0,{"$f":"Y79-X79","v":0},0,null,null,null,{"$error":"#NUM!"},{"$f":"AE79-AD79","v":{"$error":"#NUM!"}},{"$error":"#NUM!"}]
[null,null,null,"Alt. 4",null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,0,{"$f":"M80-L80","v":0},0,null,null,null,0,{"$f":"S80-R80","v":0},0,null,null,null,0,{"$f":"Y80-X80","v":0},0,null,null,null,{"$error":"#NUM!"},{"$f":"AE80-AD80","v":{"$error":"#NUM!"}},{"$error":"#NUM!"}]
[null,null,null,"Alt. 5",null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,0,{"$f":"M81-L81","v":0},0,null,null,null,0,{"$f":"S81-R81","v":0},0,null,null,null,0,{"$f":"Y81-X81","v":0},0,null,null,null,{"$error":"#NUM!"},{"$f":"AE81-AD81","v":{"$error":"#NUM!"}},{"$error":"#NUM!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"TRANSPOSE(F77:H77)","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"TRANSPOSE(F78:H78)","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"TRANSPOSE(F79:H79)","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"TRANSPOSE(F80:H80)","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"TRANSPOSE(F81:H81)","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$error":"#NUM!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"TRANSPOSE('Beräkningar (rör ej)'!D77:D81)","v":"Alt. 1"},"Alt. 2","Alt. 3","Alt. 4","Alt. 5"]
[null,null,null,null,{"$f":"TRANSPOSE('Beräkningar (rör ej)'!F75:H75)","v":"P05"},{"$f":"TRANSPOSE('Beräkningar (rör ej)'!F77:H81)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,"P50",{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,"P95",{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[]
[]
[null,null,null,null,1,1,1]

{"sheet":"Underlag mm","index":12,"n_rows":47,"n_cols":3,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
[]
[{"$f":"IF(SUM(A3:A11)>0,TRUE,FALSE)","v":true},{"$f":"'2. Kriterier'!B6","v":"Tekniska kriterier"}]
[{"$f":"IF(B3=TRUE,1,0)","v":1},{"$f":"'2. Kriterier'!B10","v":true},{"$f":"'2. Kriterier'!D10","v":"Leveranssäkerhet"}]
[{"$f":"IF(B4=TRUE,1,0)","v":1},{"$f":"'2. Kriterier'!B11","v":true},{"$f":"'2. Kriterier'!D11","v":"Sabotage"}]
[1,{"$f":"'2. Kriterier'!B12","v":true},{"$f":"'2. Kriterier'!D12","v":"Anpassningsförmåga"}]
[1,{"$f":"'2. Kriterier'!B13","v":true},{"$f":"'2. Kriterier'!D13","v":"Tillstånd"}]
[1,{"$f":"'2. Kriterier'!B14","v":true},{"$f":"'2. Kriterier'!D14","v":"Rådighet"}]
[1,{"$f":"'2. Kriterier'!B15","v":true},{"$f":"'2. Kriterier'!D15","v":"Tid till idrifttagande"}]
[0,{"$f":"'2. Kriterier'!B16","v":false},{"$f":"'2. Kriterier'!D16","v":"Ytterligare kriterium"}]
[0,{"$f":"'2. Kriterier'!B17","v":false},{"$f":"'2. Kriterier'!D17","v":"Ytterligare kriterium"}]
[0,{"$f":"'2. Kriterier'!B18","v":false},{"$f":"'2. Kriterier'!D18","v":"Ytterligare kriterium"}]
[]
[{"$f":"IF(SUM(A14:A25)>0,TRUE,FALSE)","v":true},{"$f":"'2. Kriterier'!B22","v":"Sociala kriterier"}]
[1,{"$f":"'2. Kriterier'!B26","v":true},{"$f":"'2. Kriterier'!D26","v":"Upplevd trygghet"}]
[1,{"$f":"'2. Kriterier'!B27","v":true},{"$f":"'2. Kriterier'!D27","v":"Skydd mot mikrobiologiska hälsorisker"}]
[1,{"$f":"'2. Kriterier'!B28","v":true},{"$f":"'2. Kriterier'!D28","v":"Skydd mot kemiska hälsorisker"}]
[1,{"$f":"'2. Kriterier'!B29","v":true},{"$f":"'2. Kriterier'!D29","v":"Andra dricksvattenparametrar"}]
[1,{"$f":"'2. Kriterier'!B30","v":true},{"$f":"'2. Kriterier'!D30","v":"Icke-dricksvattenrelaterade hälsoeffekter"}]
[1,{"$f":"'2. Kriterier'!B31","v":true},{"$f":"'2. Kriterier'!D31","v":"Icke-dricksvattenrelaterade hälsoeffekter "}]
[1,{"$f":"'2. Kriterier'!B32","v":true},{"$f":"'2. Kriterier'!D32","v":"Tillväxtpotential"}]
[1,{"$f":"'2. Kriterier'!B33","v":true},{"$f":"'2. Kriterier'!D33","v":"Rekreationsvärden"}]
[1,{"$f":"'2. Kriterier'!B34","v":true},{"$f":"'2. Kriterier'!D34","v":"Fördelningseffekter"}]
[0,{"$f":"'2. Kriterier'!B35","v":false},{"$f":"'2. Kriterier'!D35","v":"Ytterligare kriterium"}]
[0,{"$f":"'2. Kriterier'!B36","v":false},{"$f":"'2. Kriterier'!D36","v":"Ytterligare kriterium"}]
[0,{"$f":"'2. Kriterier'!B37","v":false},{"$f":"'2. Kriterier'!D37","v":"Ytterligare kriterium"}]
[]
[{"$f":"IF(SUM(A28:A39)>0,TRUE,FALSE)","v":true},{"$f":"'2. Kriterier'!B41","v":"Miljömässiga kriterier"}]
[{"$f":"IF(B28=TRUE,1,0)","v":1},{"$f":"'2. Kriterier'!B45","v":true},{"$f":"'2. Kriterier'!D45","v":"Vattenresursers kvalitet"}]
[1,{"$f":"'2. Kriterier'!B46","v":true},{"$f":"'2. Kriterier'!D46","v":"Vattenresursers kvantitet"}]
[1,{"$f":"'2. Kriterier'!B47","v":true},{"$f":"'2. Kriterier'!D47","v":"Terrestra ekosystems livsduglighet"}]
[1,{"$f":"'2. Kriterier'!B48","v":true},{"$f":"'2. Kriterier'!D48","v":"Energianvändning och växthusgasutsläpp"}]
[1,{"$f":"'2. Kriterier'!B49","v":true},{"$f":"'2. Kriterier'!D49","v":"Vattenanvändning"}]
[1,{"$f":"'2. Kriterier'!B50","v":true},{"$f":"'2. Kriterier'!D50","v":"Markanvändning"}]
[1,{"$f":"'2. Kriterier'!B51","v":true},{"$f":"'2. Kriterier'!D51","v":"Materialanvändning"}]
[1,{"$f":"'2. Kriterier'!B52","v":true},{"$f":"'2. Kriterier'!D52","v":"Kemikalieanvändning"}]
[1,{"$f":"'2. Kriterier'!B53","v":true},{"$f":"'2. Kriterier'!D53","v":"Icke-återvinningsbart avfall"}]
[0,{"$f":"'2. Kriterier'!B54","v":false},{"$f":"'2. Kriterier'!D54","v":"Ytterligare kriterium"}]
[0,{"$f":"'2. Kriterier'!B55","v":false},{"$f":"'2. Kriterier'!D55","v":"Ytterligare kriterium"}]
[0,{"$f":"'2. Kriterier'!B56","v":false},{"$f":"'2. Kriterier'!D56","v":"Ytterligare kriterium"}]
[]
[{"$f":"IF(SUM(A42:A47)>0,TRUE,FALSE)","v":true},{"$f":"'2. Kriterier'!B60","v":"Ekonomiska kriterier"}]
[{"$f":"IF(B42=TRUE,1,0)","v":1},{"$f":"'2. Kriterier'!B62","v":true},{"$f":"'2. Kriterier'!D62","v":"Investeringskostnader"}]
[1,{"$f":"'2. Kriterier'!B63","v":true},{"$f":"'2. Kriterier'!D63","v":"Drift- och underhållskostnader"}]
[0,{"$f":"'2. Kriterier'!B64","v":false},{"$f":"'2. Kriterier'!D64","v":"Ytterligare kriterium"}]
[0,{"$f":"'2. Kriterier'!B65","v":false},{"$f":"'2. Kriterier'!D65","v":"Ytterligare kriterium"}]
[0,{"$f":"'2. Kriterier'!B66","v":false},{"$f":"'2. Kriterier'!D66","v":"Ytterligare kriterium"}]
[0,{"$f":"'2. Kriterier'!B67","v":false},{"$f":"'2. Kriterier'!D67","v":"Ytterligare kriterium"}]

{"sheet":"Modellunderlag","index":13,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Skala viktning",null,"Skala för poängsättning",null,null,"Guide till poängsättning",null,null,null,"Val av kriterier",null,"Osäkerheter",null,"Du har valt att ange osäkerheter i bedömningarna och kan därför välja båda alternativen ovan. För att kunna genomföra beräkningarna med osäkerheter krävs att programvaran @Risk är installerad."]
[null,0,null,10,null,null,{"$f":"\"-10 till -6\"","v":"-10 till -6"},"stor negativ förändring",null,null,"Ja",null,false,null,"Du har inte angett osäkerheter i bedömningarna och ska därför välja alternativet ”Utan osäkerheter” ovan."]
[null,1,null,9,null,null,{"$f":"\"-5 till -1\"","v":"-5 till -1"},"liten negativ förändring",null,null,"Nej"]
[null,2,null,8,null,null,0,"ingen förändring"]
[null,3,null,7,null,null,"1 till 5","liten positiv förändring"]
[null,4,null,6,null,null,"6 till 10","stor positiv förändring"]
[null,5,null,5]
[null,6,null,4]
[null,7,null,3]
[null,8,null,2]
[null,9,null,1]
[null,10,null,0]
[null,null,null,-1]
[null,null,null,-2]
[null,null,null,-3]
[null,null,null,-4]
[null,null,null,-5]
[null,null,null,-6]
[null,null,null,-7]
[null,null,null,-8]
[null,null,null,-9]
[null,null,null,-10]