{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Startsida","1. Verksamhetsanalys","2. Oönskade händelser","3. Riskanalys","4. Åtgärdsanalys","Kunskapsbank ","Underlag"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":3,"defined_names":9,"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":"Startsida","index":0,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[[3,1,3,5],[1,1,1,2]]}
[]
[null,"Välkommen till verktyget för klimatanpassning för livsmedelsbranschen!"]
[]
[null,"Analysen görs lämpligast i arbetsgrupp under en workshop. Fyll nedan i information om er genomförda analys"]
[]
[null,"Företag/produkt:  "]
[null,"Datum för analysen:  "]
[null,"Namn på analysdeltagare:  "]
[null,"Ev. övriga upplysningar och kommentarer:  "]

{"sheet":"1. Verksamhetsanalys","index":1,"n_rows":45,"n_cols":3,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["1. Verksamhetsanalys",{"$f":"IF(Startsida!C6=\"\",\"\",Startsida!C6)","v":""}]
[]
["FRÅGOR om Råvaror - Vatten - Energi - Lokaler,Personal - Distribution:"]
["Råvaror/insatsvaror","Oönskade händelser","Kommentarer"]
["Vilka råvaror/insatsvaror används i verksamheten?"]
["Var produceras råvarorna/insatsvarorna?"]
["Finns det några framtidsplaner som kan påverka vilka/hur mycket råvaror/insatsvaror som behövs?"]
["Finns det några framtidsscenarier/trender som kan påverka tillgången på råvaror/insatsvaror?"]
["Har kvaliteten och tillgången på råvaror/insatsvaror varierat? Kan det bero på klimatvariationer eller ett förändrat klimat?"]
["Hur ser lagringsmöjligheterna av råvaror/insatsvaror ut?"]
[]
[]
[]
[]
["Vatten","Oönskade händelser","Kommentarer"]
["Hur mycket vatten används i verksamheten (både till tillverkning/förädling och hygienarbete)?"]
["Var kommer vattnet från (kommunalt vatten, egen försörjning)?"]
["Finns det några framtidsplaner som kan påverka vattenbehovet?"]
[]
[]
[]
[]
["Energi","Oönskade händelser","Kommentarer"]
["Hur mycket energi används i verksamheten?"]
["Finns det egna generatorer i verksamheten?"]
["Finns det några framtidsplaner som kan påverka energibehovet?"]
[]
[]
[]
[]
["Lokaler och personal","Oönskade händelser","Kommentarer"]
["Var ligger lokalerna?"]
["Hur ser omgivningen runt lokalerna ut?"]
["Vilken temperatur och luftfuktighet är det i lokalerna?"]
["Vilka hygienrutiner finns?"]
["Finns kylsystem i lokaler där personal vistas (tex AC, luftvärmepump)?"]
["Finns det behov av att kyla eller frysa råvaror/insatsvaror/produkter i lokalerna?"]
[]
[]
[]
["Distribution","Oönskade händelser","Kommentarer"]
["Hur transporteras råvaror/insatsvaror till verksamhetens anläggningar?"]
["Hur transporteras  produkter till uppköpare?"]
["Finns det behov att kyla/frysa råvaror/insatsvaror under transport?"]
["Finns det behov att kyla/frysa  produkter under transport?"]

{"sheet":"2. Oönskade händelser","index":2,"n_rows":47,"n_cols":5,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["2. Oönskade händelser",null,{"$f":"IF(Startsida!C6=\"\",\"\",Startsida!C6)","v":""}]
[]
[]
["Oönskade händelser inom verksamhetsområde:",{"$f":"Underlag!C15","v":"Nuläge"},"Skeenden som kan påverka oönskade händelser","Annan påverkan \n(se kunskapsbanken)","Kommentar"]
[{"$f":"Tabell1[[#Headers],[Råvaror/insatsvaror]]","v":"Råvaror/insatsvaror"}]
[{"$f":"'1. Verksamhetsanalys'!B5","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B6","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B7","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B8","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B9","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B10","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B11","v":0}]
[{"$f":"Tabell4[[#Headers],[Vatten]]","v":"Vatten"}]
[{"$f":"'1. Verksamhetsanalys'!B16","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B17","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B18","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B19","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B20","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B21","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B22","v":0}]
[{"$f":"Tabell5[[#Headers],[Energi]]","v":"Energi"}]
[{"$f":"'1. Verksamhetsanalys'!B24","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B25","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B26","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B27","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B28","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B29","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B30","v":0}]
[{"$f":"'[3]1. Verksamhetsanalys'!D33","v":"Lokaler och personal"}]
[{"$f":"'1. Verksamhetsanalys'!B32","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B33","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B34","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B35","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B36","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B37","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B38","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B39","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B40","v":0}]
[{"$f":"'[3]1. Verksamhetsanalys'!D43","v":"Distribution"}]
[{"$f":"'1. Verksamhetsanalys'!B42","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B43","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B44","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B45","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B46","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B47","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B48","v":0}]
[{"$f":"'1. Verksamhetsanalys'!B49","v":0}]

{"sheet":"3. Riskanalys","index":3,"n_rows":53,"n_cols":22,"rows_kept":53,"cut":false,"hidden":false,"merged":[[8,9,9,9],[6,1,6,6],[6,7,6,9],[8,1,8,2],[8,3,8,4],[8,5,8,6],[8,7,9,7],[8,8,9,8],[7,1,7,6]]}
["3. Riskanalys",{"$f":"IF(Startsida!C6=\"\",\"\",Startsida!C6)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"BEDÖMNINGSKRITERIER",null,null,"BEDÖMNINGSKRITERIER"]
[null,null,null,null,null,null,null,null,null,null,null,"Sannolikhetsnivåer (S)","Kriterier",null,"Konsekvensnivåer (K)","Kriterier"]
[null,null,null,null,null,null,null,null,null,null,null,"1. Liten sannolikhet","Händelsen kan inte uteslutas",null,"1. Liten konsekvens","Obetydlig påverkan på livsmedlets kvalitet och/eller normal leverans kan upprätthållas"]
[null,null,null,null,null,null,null,null,null,null,null,"2. Medelstor sannolikhet","Händelsen kan inträffa var 10-50:e år",null,"2. Medelstor konsekvens","Något försämrad kvalitet på enskilda produkter och/eller kortvarig försening i leveransen"]
[null,"Ange värde 1 - 4",null,null,null,null,null,"Risk",null,null,null,"3. Stor sannolikhet","Händelsen kan inträffa var 2-10:e år eller har inträffat",null,"3. Stor konsekvens","Försämrad kvalitet på flertalet produkter och/eller långvarig försening i leveransen"]
[null,"Sannolikhet (S) och konsekvens (K)",null,null,null,null,null,null,null,null,null,"4. Mycket stor sannolikhet","Händelsen förekommer ofta",null,"4. Mycket stor konsekvens","Kraftigt försämrad kvalitet på många produkter och/eller långvarigt leveransstopp"]
["(auto från blad 2)",{"$f":"Underlag!C15","v":"Nuläge"},null,{"$f":"Underlag!D15","v":"Om 50 år"},null,{"$f":"Underlag!E15","v":"Om 100 år"},null,"år 2030","år 2050","år 2100"]
["Oönskad händelse","S","K","S","K","S","K"]
[{"$f":"'2. Oönskade händelser'!A5:A47","v":"Råvaror/insatsvaror"},null,null,null,null,null,null,{"$f":"IF(B11=\"\",\"\",B11*VLOOKUP(C11,Konsekvens,2,FALSE))","v":""},{"$f":"IF(D11=\"\",\"\",D11*VLOOKUP(E11,Konsekvens,2,FALSE))","v":""},{"$f":"IF(F11=\"\",\"\",F11*VLOOKUP(G11,Konsekvens,2,FALSE))","v":""}]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
["Vatten",null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,"    "]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
["Energi",null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
["Lokaler och personal",null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
["Distribution",null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]
[0,null,null,null,null,null,null,"","",""]

{"sheet":"4. Åtgärdsanalys","index":4,"n_rows":55,"n_cols":17,"rows_kept":55,"cut":false,"hidden":false,"merged":[[6,4,6,6],[4,4,4,6],[3,4,3,6],[5,4,5,6],[8,7,10,7],[8,8,10,8],[8,9,10,9],[8,6,10,6],[8,1,8,3],[9,3,10,3],[9,1,10,1],[9,2,10,2],[8,4,10,4],[8,5,10,5]]}
["4. Åtgärdsanalys",{"$f":"IF(Startsida!C6=\"\",\"\",Startsida!C6)","v":""}]
[]
[null,null,"Risk","Färg","Definition"]
[null,null,"Liten risk ",null,"Liten risk för att versamheten drabbas. Inga åtgärder behövs"]
[null,null,"Medelstor risk ",null,"Medelstor risk för att versamheten drabbas. Utred ytterligare och vidta åtgärder för att minska riskerna"]
[null,null,"Stor risk ",null,"Stor risk för att versamheten drabbas. Utred ytterligare och vidta åtgärder inom en snar framtid"]
[null,null,"Mycket stor risk ",null,"Versamheten har redan drabbats och kommer enligt klimatscenarior drabbas i framtiden . Vidta åtgärder."]
[]
[null,"Risk",null,null,"Mål","Åtgärder","Beslut","Ansvarig","Uppföljning","Kommentarer"]
[null,{"$f":"Underlag!C15","v":"Nuläge"},{"$f":"Underlag!D15","v":"Om 50 år"},{"$f":"Underlag!E15","v":"Om 100 år"}]
["OMRÅDE"]
[{"$f":"'3. Riskanalys'!A11","v":"Råvaror/insatsvaror"}]
[{"$f":"'3. Riskanalys'!A12","v":0},{"$f":"'3. Riskanalys'!H12","v":""},{"$f":"'3. Riskanalys'!I12","v":""},{"$f":"'3. Riskanalys'!J12","v":""}]
[{"$f":"'3. Riskanalys'!A13","v":0},{"$f":"'3. Riskanalys'!H13","v":""},{"$f":"'3. Riskanalys'!I13","v":""},{"$f":"'3. Riskanalys'!J13","v":""}]
[{"$f":"'3. Riskanalys'!A14","v":0},{"$f":"'3. Riskanalys'!H14","v":""},{"$f":"'3. Riskanalys'!I14","v":""},{"$f":"'3. Riskanalys'!J14","v":""}]
[{"$f":"'3. Riskanalys'!A15","v":0},{"$f":"'3. Riskanalys'!H15","v":""},{"$f":"'3. Riskanalys'!I15","v":""},{"$f":"'3. Riskanalys'!J15","v":""}]
[{"$f":"'3. Riskanalys'!A16","v":0},{"$f":"'3. Riskanalys'!H16","v":""},{"$f":"'3. Riskanalys'!I16","v":""},{"$f":"'3. Riskanalys'!J16","v":""}]
[{"$f":"'3. Riskanalys'!A17","v":0},{"$f":"'3. Riskanalys'!H17","v":""},{"$f":"'3. Riskanalys'!I17","v":""},{"$f":"'3. Riskanalys'!J17","v":""}]
[{"$f":"'3. Riskanalys'!A18","v":0},{"$f":"'3. Riskanalys'!H18","v":""},{"$f":"'3. Riskanalys'!I18","v":""},{"$f":"'3. Riskanalys'!J18","v":""}]
[{"$f":"'3. Riskanalys'!A19","v":"Vatten"},{"$f":"'3. Riskanalys'!H19","v":""},{"$f":"'3. Riskanalys'!I19","v":""},{"$f":"'3. Riskanalys'!J19","v":""}]
[{"$f":"'3. Riskanalys'!A20","v":0},{"$f":"'3. Riskanalys'!H20","v":""},{"$f":"'3. Riskanalys'!I20","v":""},{"$f":"'3. Riskanalys'!J20","v":""}]
[{"$f":"'3. Riskanalys'!A21","v":0},{"$f":"'3. Riskanalys'!H21","v":""},{"$f":"'3. Riskanalys'!I21","v":""},{"$f":"'3. Riskanalys'!J21","v":""}]
[{"$f":"'3. Riskanalys'!A22","v":0},{"$f":"'3. Riskanalys'!H22","v":""},{"$f":"'3. Riskanalys'!I22","v":""},{"$f":"'3. Riskanalys'!J22","v":""}]
[{"$f":"'3. Riskanalys'!A23","v":0},{"$f":"'3. Riskanalys'!H23","v":""},{"$f":"'3. Riskanalys'!I23","v":""},{"$f":"'3. Riskanalys'!J23","v":""}]
[{"$f":"'3. Riskanalys'!A24","v":0},{"$f":"'3. Riskanalys'!H24","v":""},{"$f":"'3. Riskanalys'!I24","v":""},{"$f":"'3. Riskanalys'!J24","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"    "]
[{"$f":"'3. Riskanalys'!A25","v":0},{"$f":"'3. Riskanalys'!H25","v":""},{"$f":"'3. Riskanalys'!I25","v":""},{"$f":"'3. Riskanalys'!J25","v":""}]
[{"$f":"'3. Riskanalys'!A26","v":0},{"$f":"'3. Riskanalys'!H26","v":""},{"$f":"'3. Riskanalys'!I26","v":""},{"$f":"'3. Riskanalys'!J26","v":""}]
[{"$f":"'3. Riskanalys'!A27","v":"Energi"},{"$f":"'3. Riskanalys'!H27","v":""},{"$f":"'3. Riskanalys'!I27","v":""},{"$f":"'3. Riskanalys'!J27","v":""}]
[{"$f":"'3. Riskanalys'!A28","v":0},{"$f":"'3. Riskanalys'!H28","v":""},{"$f":"'3. Riskanalys'!I28","v":""},{"$f":"'3. Riskanalys'!J28","v":""}]
[{"$f":"'3. Riskanalys'!A29","v":0},{"$f":"'3. Riskanalys'!H29","v":""},{"$f":"'3. Riskanalys'!I29","v":""},{"$f":"'3. Riskanalys'!J29","v":""}]
[{"$f":"'3. Riskanalys'!A30","v":0},{"$f":"'3. Riskanalys'!H30","v":""},{"$f":"'3. Riskanalys'!I30","v":""},{"$f":"'3. Riskanalys'!J30","v":""}]
[{"$f":"'3. Riskanalys'!A31","v":0},{"$f":"'3. Riskanalys'!H31","v":""},{"$f":"'3. Riskanalys'!I31","v":""},{"$f":"'3. Riskanalys'!J31","v":""}]
[{"$f":"'3. Riskanalys'!A32","v":0},{"$f":"'3. Riskanalys'!H32","v":""},{"$f":"'3. Riskanalys'!I32","v":""},{"$f":"'3. Riskanalys'!J32","v":""}]
[{"$f":"'3. Riskanalys'!A33","v":0},{"$f":"'3. Riskanalys'!H33","v":""},{"$f":"'3. Riskanalys'!I33","v":""},{"$f":"'3. Riskanalys'!J33","v":""}]
[{"$f":"'3. Riskanalys'!A34","v":0},{"$f":"'3. Riskanalys'!H34","v":""},{"$f":"'3. Riskanalys'!I34","v":""},{"$f":"'3. Riskanalys'!J34","v":""}]
[{"$f":"'3. Riskanalys'!A35","v":"Lokaler och personal"},{"$f":"'3. Riskanalys'!H35","v":""},{"$f":"'3. Riskanalys'!I35","v":""},{"$f":"'3. Riskanalys'!J35","v":""}]
[{"$f":"'3. Riskanalys'!A36","v":0},{"$f":"'3. Riskanalys'!H36","v":""},{"$f":"'3. Riskanalys'!I36","v":""},{"$f":"'3. Riskanalys'!J36","v":""}]
[{"$f":"'3. Riskanalys'!A37","v":0},{"$f":"'3. Riskanalys'!H37","v":""},{"$f":"'3. Riskanalys'!I37","v":""},{"$f":"'3. Riskanalys'!J37","v":""}]
[{"$f":"'3. Riskanalys'!A38","v":0},{"$f":"'3. Riskanalys'!H38","v":""},{"$f":"'3. Riskanalys'!I38","v":""},{"$f":"'3. Riskanalys'!J38","v":""}]
[{"$f":"'3. Riskanalys'!A39","v":0},{"$f":"'3. Riskanalys'!H39","v":""},{"$f":"'3. Riskanalys'!I39","v":""},{"$f":"'3. Riskanalys'!J39","v":""}]
[{"$f":"'3. Riskanalys'!A40","v":0},{"$f":"'3. Riskanalys'!H40","v":""},{"$f":"'3. Riskanalys'!I40","v":""},{"$f":"'3. Riskanalys'!J40","v":""}]
[{"$f":"'3. Riskanalys'!A41","v":0},{"$f":"'3. Riskanalys'!H41","v":""},{"$f":"'3. Riskanalys'!I41","v":""},{"$f":"'3. Riskanalys'!J41","v":""}]
[{"$f":"'3. Riskanalys'!A42","v":0},{"$f":"'3. Riskanalys'!H42","v":""},{"$f":"'3. Riskanalys'!I42","v":""},{"$f":"'3. Riskanalys'!J42","v":""}]
[{"$f":"'3. Riskanalys'!A43","v":0},{"$f":"'3. Riskanalys'!H43","v":""},{"$f":"'3. Riskanalys'!I43","v":""},{"$f":"'3. Riskanalys'!J43","v":""}]
[{"$f":"'3. Riskanalys'!A44","v":0},{"$f":"'3. Riskanalys'!H44","v":""},{"$f":"'3. Riskanalys'!I44","v":""},{"$f":"'3. Riskanalys'!J44","v":""}]
[{"$f":"'3. Riskanalys'!A45","v":"Distribution"},{"$f":"'3. Riskanalys'!H45","v":""},{"$f":"'3. Riskanalys'!I45","v":""},{"$f":"'3. Riskanalys'!J45","v":""}]
[{"$f":"'3. Riskanalys'!A46","v":0},{"$f":"'3. Riskanalys'!H46","v":""},{"$f":"'3. Riskanalys'!I46","v":""},{"$f":"'3. Riskanalys'!J46","v":""}]
[{"$f":"'3. Riskanalys'!A47","v":0},{"$f":"'3. Riskanalys'!H47","v":""},{"$f":"'3. Riskanalys'!I47","v":""},{"$f":"'3. Riskanalys'!J47","v":""}]
[{"$f":"'3. Riskanalys'!A48","v":0},{"$f":"'3. Riskanalys'!H48","v":""},{"$f":"'3. Riskanalys'!I48","v":""},{"$f":"'3. Riskanalys'!J48","v":""}]
[{"$f":"'3. Riskanalys'!A49","v":0},{"$f":"'3. Riskanalys'!H49","v":""},{"$f":"'3. Riskanalys'!I49","v":""},{"$f":"'3. Riskanalys'!J49","v":""}]
[{"$f":"'3. Riskanalys'!A50","v":0},{"$f":"'3. Riskanalys'!H50","v":""},{"$f":"'3. Riskanalys'!I50","v":""},{"$f":"'3. Riskanalys'!J50","v":""}]
[{"$f":"'3. Riskanalys'!A51","v":0},{"$f":"'3. Riskanalys'!H51","v":""},{"$f":"'3. Riskanalys'!I51","v":""},{"$f":"'3. Riskanalys'!J51","v":""}]
[{"$f":"'3. Riskanalys'!A52","v":0},{"$f":"'3. Riskanalys'!H52","v":""},{"$f":"'3. Riskanalys'!I52","v":""},{"$f":"'3. Riskanalys'!J52","v":""}]
[{"$f":"'3. Riskanalys'!A53","v":0},{"$f":"'3. Riskanalys'!H53","v":""},{"$f":"'3. Riskanalys'!I53","v":""},{"$f":"'3. Riskanalys'!J53","v":""}]
[{"$f":"'3. Riskanalys'!A54","v":0},{"$f":"'3. Riskanalys'!H54","v":0},{"$f":"'3. Riskanalys'!I54","v":0},{"$f":"'3. Riskanalys'!J54","v":0}]

{"sheet":"Kunskapsbank ","index":5,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,2,1]]}
[]
[null,"Kunskapsbank"]
[]
[null,"Här finns länkar till kunskapskällor som kan vara användbara i ert arbete med klimatanpassning. Ni kan även lägga till egna källor."]
[null,"Klimatet och klimatförändringar"]
[null,"SMHI (www.smhi.se/klimat)"]
[null,"Framtidsklimat i Sveriges län enligt RCP-scenarier (https://www.smhi.se/klimat/framtidens-klimat/framtidsklimat-i-sveriges-lan-enligt-rcp-scenarier-1.95384)"]
[null,"Klimatanpassning"]
[null,"Klimatanpassningsportalen (www.klimatanpassning.se)"]
[null,"Klimatanpassning för livsmedelsföretag (https://www.livsmedelsverket.se/foretagande-regler-kontroll/krisberedskap-och-civiltforsvar/klimatanpassning-for-livsmedelsforetag)"]
[null,"Livsmedelssektorn i ett förändrat klimat — plan för vad Livsmedelsverket behöver göra (PDF) (https://www.livsmedelsverket.se/globalassets/publikationsdatabas/rapporter/2018/2018-livsmedelsverkets-handlingsplan-for-klimatanpassning.pdf)"]
[null,"Klimatförändringarnas påverkan på de regioner som Sverige är beroende av för sin livsmedelsförsörjning (PDF) (https://www.livsmedelsverket.se/globalassets/publikationsdatabas/rapporter/2019/e-2019-nr-01-klimatforandringarnas-paverkan.pdf)"]
[null,"Klimatanpassning i jordbruket (https://www2.jordbruksverket.se/download/18.60bca316180aa6f0766b2ef5/1652341349479/ra22_8.pdf)"]
[null,"Metoder för arbete med klimatanpassning "]
[null,"Vägledning på klimatanpassningsportalen (http://klimatanpassning.se/klimatanpassa)\n"]
[null,"EU:s verktyg för klimatanpassning (https://climate-adapt.eea.europa.eu/knowledge/tools/adaptation-support-tool)\n"]

{"sheet":"Underlag","index":6,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[3,0,3,1],[4,2,4,5],[17,2,17,7],[18,2,18,7]]}
["Dataunderlag till formler, beräkningar och listor i övriga flikar"]
[]
["Beräkningstabell för färgmarkering av risker"]
["Beräkningsvärde",null,1,5,10,16]
[null,null,"Konsekvens",null,null,null,null,"(Tabell som används i riskformel)"]
[null,"Sannolikhet","Liten \n(K1)","Medelstor (K2)","Stor\n(K3)","Mycket stor (K4)",null,"Konsekvens","Beräknas"]
[1,"Liten (S1)",{"$f":"A7*$C$4","v":1},{"$f":"A7*$D$4","v":5},{"$f":"A7*$E$4","v":10},{"$f":"A7*$F$4","v":16},null,1,{"$f":"C4","v":1}]
[2,"Medelstor (S2)",{"$f":"A8*$C$4","v":2},{"$f":"A8*$D$4","v":10},{"$f":"A8*$E$4","v":20},{"$f":"A8*$F$4","v":32},null,2,{"$f":"D4","v":5}]
[3,"Stor (S3)",{"$f":"A9*$C$4","v":3},{"$f":"A9*$D$4","v":15},{"$f":"A9*$E$4","v":30},{"$f":"A9*$F$4","v":48},null,3,{"$f":"E4","v":10}]
[4,"Mycket stor (S4)",{"$f":"A10*$C$4","v":4},{"$f":"A10*$D$4","v":20},{"$f":"A10*$E$4","v":40},{"$f":"A10*$F$4","v":64},null,4,{"$f":"F4","v":16}]
[]
[]
[]
["TIDSHORISONTER (hämtas till flik 2 och 3)"]
["Ändra om andra tidsperioder önskas:",null,"Nuläge","Om 50 år","Om 100 år"]
[]
["Skeenden som kan påverka oönskade händelser"]
[null,"Högre temperatur","Högre årsmedeltemperatur, värmebölja och torka"]
[null,"Ökad nederbörd","Ökad årsmedelnederbörd och kraftig nederbörd (skyfall)"]