{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Karaktermatrise","Inndata","Ark1"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":12,"comments":1,"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":"Karaktermatrise","index":0,"n_rows":107,"n_cols":32,"rows_kept":107,"cut":false,"hidden":false,"merged":[[5,27,5,31],[86,0,86,6],[96,0,96,6],[6,10,6,13],[6,0,6,6],[16,0,16,6],[23,0,23,6],[30,0,30,6],[38,0,38,6],[101,0,101,6],[44,0,44,6],[50,0,50,6],[59,0,59,6],[69,0,69,6],[79,0,79,6]]}
[null,null,null,null,null,null,null,null,null,null,"Type kontroll:",null,null,{"$f":"VLOOKUP(O1,Inndata!A13:B14,2,FALSE)","v":{"$error":"#N/A"}},null,null,"Vise avvik?",{"$f":"Inndata!C4","v":"Stor"},false,{"$f":"IF(S1=TRUE,R1,\"Nei\")","v":"Nei"},"Tomme",false,{"$f":"IF(V1=TRUE,\"\",\"Nei\")","v":"Nei"},null,"Til utskrift:",null,null,null,"Trekkskala","liten","middels","stor"]
[null,null,{"$f":"IF(V3=TRUE,\"N/A\",IF(COUNTIF(R$9:R$108,FALSE)=0,IF(10-$N$3<0,0,10-$N$3),\"-\"))","v":"-"},null,null,null,null,null,"",null,"Alle felt ikke utfylt:",null,null,{"$f":"COUNTIF(R$9:R$1048576,FALSE)","v":63},null,null,null,{"$f":"Inndata!C5","v":"Middels"},false,"Nei","Ingen valgt?",{"$f":"IF(AND(S1=FALSE,S2=FALSE,S3=FALSE,S4=FALSE,S5=FALSE,S6=FALSE,V1=FALSE),TRUE,FALSE)","v":true},null,null,"Bygg/anlegg:","",null,null,"min",0.1,0.5,1.5]
[null,null,null,null,null,null,null,null,null,null,"Karaktertrekk:",null,null,{"$f":"SUM(D$9:D$150)","v":0},{"$f":"COUNTIF(R9:R108,FALSE)&\" kontrollpunkt gjenstår for å beregne karakter.\"","v":"63 kontrollpunkt gjenstår for å beregne karakter."},null,null,{"$f":"Inndata!C6","v":"Liten"},false,"Nei","Ingen anleggsvurdering?",{"$f":"COUNTIF(E9:E107,Inndata!C10)>0","v":false},{"$f":"IF(V3=TRUE,\"Anlegget gis ikke anleggsvurdering (begrunnes i kontrollrapport)\",COUNTIF(R9:R108,FALSE)&\" kontrollpunkt gjenstår for å beregne karakter.\")","v":"63 kontrollpunkt gjenstår for å beregne karakter."},null,"Kontrollør:","",null,null,"maks",0.5,1.5,10]
[null,null,null,null,null,null,null,null,null,null,"Endre karakter:",null,null,false,null,null,null,{"$f":"Inndata!C7","v":"Merknad"},false,"Nei",null,null,null,null,"FG-ref:",""]
[null,null,null,null,null,null,null,null,null,null,"Vurdert karakter",null,null,"",{"$f":"IFERROR(VALUE(N5)-C2,0)","v":0},{"$f":"IF(ISNUMBER(O5),IF(O5>0,\"( + \"&ROUND(O5,1)&\" )\",IF(O5<0,\"( \"&ROUND(O5,1)&\" )\",\"\")),\"\")","v":""},null,{"$f":"Inndata!C8","v":"Ingen avvik"},false,"Nei",null,null,null,null,"Beregnet karakter:",{"$f":"C2","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,"Begrunnelse karakter",null,null,"",null,null,null,{"$f":"Inndata!C9","v":"Ikke relevant"},false,"Nei",null,null,null,null,"Vurdert karakter:",{"$f":"IF(AND(N4=TRUE,_xlfn.NUMBERVALUE(N5)<>C2,N5<>\"\"),_xlfn.NUMBERVALUE(N5),C2)","v":"-"},{"$f":"IF(Karaktermatrise!AM4=TRUE,\"Begrunnelse endring av karakter:\",\"\")","v":""},{"$f":"IF(Karaktermatrise!AM4=TRUE,Karaktermatrise!AM6,\"\")","v":""}]
["1. Dokumentasjon",null,null,null,null,null,null,null,null,null,"Karaktertrekk",null,null,null,null,"Vises kun ved \n1.gangskontroll?","Vise ved rutinekont?","Utfylt?","Avvik/ merknad?","Intern kommentar",null,"Grense for trekk"]
["Pos.","Kontrollpunkt","Referanse","Beregnet trekk","Vurdering","Ref. til FG-kontroll","Kommentar vurdering",null,null,null,{"$f":"Inndata!$C$4","v":"Stor"},{"$f":"Inndata!$C$5","v":"Middels"},{"$f":"Inndata!$C$6","v":"Liten"},"Karakter-trekk",null,{"$f":"COUNTIF(P9:P107,TRUE)","v":14},{"$f":"COUNTIF(Q9:Q107,\"Ja\")","v":63},{"$f":"COUNTIF(R9:R107,TRUE)","v":0},{"$f":"COUNTIF(S9:S107,TRUE)","v":0},null,null,"Maks trekk","Min trekk"]
["1-1","Grunnlagsdata","4.1, 4.2, 4.3",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E9=Inndata!$C$4,$E9=Inndata!$C$5,$E9=Inndata!$C$6),HLOOKUP($E9,K$8:M$1048576,ROW($E9)-ROW($N$8)+1,FALSE),0)","v":0},null,true,{"$f":"IF(OR(P9=FALSE,R9=FALSE,S9=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$7=TRUE,TRUE,NOT(ISBLANK(E9)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E9=Inndata!$C$4,Karaktermatrise!$E9=Inndata!$C$5,Karaktermatrise!$E9=Inndata!$C$6,Karaktermatrise!$E9=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,{"$f":"IF(E9=\"Stor\",K9,IF(E9=\"Middels\",L9,IF(E9=\"Liten\",M9,0)))","v":0},{"$f":"IF(E9=\"Stor\",$AF$2,IF(E9=\"Middels\",$AE$2,IF(E9=\"Liten\",$AD$2,0)))","v":0}]
["1-2","Prosjekteringsgrunnlag","4.4",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E10=Inndata!$C$4,$E10=Inndata!$C$5,$E10=Inndata!$C$6),HLOOKUP($E10,K$8:M$1048576,ROW($E10)-ROW($N$8)+1,FALSE),0)","v":0},null,true,{"$f":"IF(OR(P10=FALSE,R10=FALSE,S10=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$7=TRUE,TRUE,NOT(ISBLANK(E10)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E10=Inndata!$C$4,Karaktermatrise!$E10=Inndata!$C$5,Karaktermatrise!$E10=Inndata!$C$6,Karaktermatrise!$E10=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,{"$f":"IF(E10=\"Stor\",K10,IF(E10=\"Middels\",L10,IF(E10=\"Liten\",M10,0)))","v":0},{"$f":"IF(E10=\"Stor\",$AF$2,IF(E10=\"Middels\",$AE$2,IF(E10=\"Liten\",$AD$2,0)))","v":0}]
["1-3","Tegninger","4.4.3.1",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E11=Inndata!$C$4,$E11=Inndata!$C$5,$E11=Inndata!$C$6),HLOOKUP($E11,K$8:M$1048576,ROW($E11)-ROW($N$8)+1,FALSE),0)","v":0},null,true,"Ja",false,{"$f":"IF(OR(Karaktermatrise!$E11=Inndata!$C$4,Karaktermatrise!$E11=Inndata!$C$5,Karaktermatrise!$E11=Inndata!$C$6,Karaktermatrise!$E11=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["1-4","Beregninger/dimensjonering","4.4.3.2, 4.4.3.3, 7.1, 7.2, 7.3, 13",null,null,null,null,null,null,null,3,1,0.1,{"$f":"IF(OR($E12=Inndata!$C$4,$E12=Inndata!$C$5,$E12=Inndata!$C$6),HLOOKUP($E12,K$8:M$1048576,ROW($E12)-ROW($N$8)+1,FALSE),0)","v":0},null,true,"Ja",false,{"$f":"IF(OR(Karaktermatrise!$E12=Inndata!$C$4,Karaktermatrise!$E12=Inndata!$C$5,Karaktermatrise!$E12=Inndata!$C$6,Karaktermatrise!$E12=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["1-5","Type og valg av vannforsyning","4.4.4, 9.1, 9.2, 9.3, 9.4, 9.5, 9.6",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E13=Inndata!$C$4,$E13=Inndata!$C$5,$E13=Inndata!$C$6),HLOOKUP($E13,K$8:M$1048576,ROW($E13)-ROW($N$8)+1,FALSE),0)","v":0},null,true,"Ja",false,{"$f":"IF(OR(Karaktermatrise!$E13=Inndata!$C$4,Karaktermatrise!$E13=Inndata!$C$5,Karaktermatrise!$E13=Inndata!$C$6,Karaktermatrise!$E13=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["1-6","Dokumentasjon av fravik fra prosjekteringsstandard og bruk av typegodkjente produkter utenfor standard","19.2",null,null,null,null,null,null,null,3,1.5,0.5,{"$f":"IF(OR($E14=Inndata!$C$4,$E14=Inndata!$C$5,$E14=Inndata!$C$6),HLOOKUP($E14,K$8:M$1048576,ROW($E14)-ROW($N$8)+1,FALSE),0)","v":0},null,true,{"$f":"IF(OR(P14=FALSE,R14=FALSE,S14=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$7=TRUE,TRUE,NOT(ISBLANK(E14)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E14=Inndata!$C$4,Karaktermatrise!$E14=Inndata!$C$5,Karaktermatrise!$E14=Inndata!$C$6,Karaktermatrise!$E14=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["1-7","FDV-dokumentasjon","19.2, 20",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E15=Inndata!$C$4,$E15=Inndata!$C$5,$E15=Inndata!$C$6),HLOOKUP($E15,K$8:M$1048576,ROW($E15)-ROW($N$8)+1,FALSE),0)","v":0},null,true,"Ja",false,{"$f":"IF(OR(Karaktermatrise!$E15=Inndata!$C$4,Karaktermatrise!$E15=Inndata!$C$5,Karaktermatrise!$E15=Inndata!$C$6,Karaktermatrise!$E15=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
[]
["2. Sprinklerbeskyttelsens omfang"]
["Pos.","Kontrollpunkt","Referanse","Beregnet trekk","Vurdering","Ref. til FG-kontroll","Kommentar vurdering",null,null,null,{"$f":"Inndata!$C$4","v":"Stor"},{"$f":"Inndata!$C$5","v":"Middels"},{"$f":"Inndata!$C$6","v":"Liten"},"Karakter-trekk",null,{"$f":"P$7","v":"Vises kun ved \n1.gangskontroll?"},{"$f":"Q$7","v":"Vise ved rutinekont?"},{"$f":"R$7","v":"Utfylt?"},{"$f":"S$7","v":"Avvik/ merknad?"},{"$f":"T$7","v":"Intern kommentar"},null,"Maks trekk","Min trekk"]
["2-1","Sprinklerbeskyttelsens omfang","5.1, 5.2",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E19=Inndata!$C$4,$E19=Inndata!$C$5,$E19=Inndata!$C$6),HLOOKUP($E19,K$8:M$1048576,ROW($E19)-ROW($N$8)+1,FALSE),0)","v":0},null,false,{"$f":"IF(OR(P19=FALSE,R19=FALSE,S19=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$17=TRUE,TRUE,NOT(ISBLANK(E19)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E19=Inndata!$C$4,Karaktermatrise!$E19=Inndata!$C$5,Karaktermatrise!$E19=Inndata!$C$6,Karaktermatrise!$E19=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,{"$f":"IF(E19=\"Stor\",K19,IF(E19=\"Middels\",L19,IF(E19=\"Liten\",M19,0)))","v":0},{"$f":"IF(E19=\"Stor\",$AF$2,IF(E19=\"Middels\",$AE$2,IF(E19=\"Liten\",$AD$2,0)))","v":0}]
["2-2","Skille mellom sprinklet og usprinklet område","5.3, TEK10/VTEK10",null,null,null,null,null,null,null,2,1,0.3,{"$f":"IF(OR($E20=Inndata!$C$4,$E20=Inndata!$C$5,$E20=Inndata!$C$6),HLOOKUP($E20,K$8:M$1048576,ROW($E20)-ROW($N$8)+1,FALSE),0)","v":0},null,false,{"$f":"IF(OR(P20=FALSE,R20=FALSE,S20=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$17=TRUE,TRUE,NOT(ISBLANK(E20)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E20=Inndata!$C$4,Karaktermatrise!$E20=Inndata!$C$5,Karaktermatrise!$E20=Inndata!$C$6,Karaktermatrise!$E20=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["2-3","Beskyttelse av skjulte hulrom","5.4",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E21=Inndata!$C$4,$E21=Inndata!$C$5,$E21=Inndata!$C$6),HLOOKUP($E21,K$8:M$1048576,ROW($E21)-ROW($N$8)+1,FALSE),0)","v":0},null,false,{"$f":"IF(OR(P21=FALSE,R21=FALSE,S21=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$17=TRUE,TRUE,NOT(ISBLANK(E21)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E21=Inndata!$C$4,Karaktermatrise!$E21=Inndata!$C$5,Karaktermatrise!$E21=Inndata!$C$6,Karaktermatrise!$E21=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["2-4","Høydeforskjell mellom de høyeste beliggende og laveste beliggende sprinklerne","5.5, Tillegg E",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E22=Inndata!$C$4,$E22=Inndata!$C$5,$E22=Inndata!$C$6),HLOOKUP($E22,K$8:M$1048576,ROW($E22)-ROW($N$8)+1,FALSE),0)","v":0},null,true,{"$f":"IF(OR(P22=FALSE,R22=FALSE,S22=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$17=TRUE,TRUE,NOT(ISBLANK(E22)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E22=Inndata!$C$4,Karaktermatrise!$E22=Inndata!$C$5,Karaktermatrise!$E22=Inndata!$C$6,Karaktermatrise!$E22=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
[]
["3. Klassifisering"]
["Pos.","Kontrollpunkt","Referanse","Beregnet trekk","Vurdering","Ref. til FG-kontroll","Kommentar vurdering",null,null,null,{"$f":"Inndata!$C$4","v":"Stor"},{"$f":"Inndata!$C$5","v":"Middels"},{"$f":"Inndata!$C$6","v":"Liten"},"Karakter-trekk",null,{"$f":"P$7","v":"Vises kun ved \n1.gangskontroll?"},{"$f":"Q$7","v":"Vise ved rutinekont?"},{"$f":"R$7","v":"Utfylt?"},{"$f":"S$7","v":"Avvik/ merknad?"},{"$f":"T$7","v":"Intern kommentar"},null,"Maks trekk","Min trekk"]
["3-1","Klassifisering","6.1, 6.2, \nTillegg A, B og C",null,null,null,null,null,null,null,5,1,0.5,{"$f":"IF(OR($E26=Inndata!$C$4,$E26=Inndata!$C$5,$E26=Inndata!$C$6),HLOOKUP($E26,K$8:M$1048576,ROW($E26)-ROW($N$8)+1,FALSE),0)","v":0},null,false,{"$f":"IF(OR(P26=FALSE,R26=FALSE,S26=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$24=TRUE,TRUE,NOT(ISBLANK(E26)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E26=Inndata!$C$4,Karaktermatrise!$E26=Inndata!$C$5,Karaktermatrise!$E26=Inndata!$C$6,Karaktermatrise!$E26=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,{"$f":"IF(E26=\"Stor\",K26,IF(E26=\"Middels\",L26,IF(E26=\"Liten\",M26,0)))","v":0},{"$f":"IF(E26=\"Stor\",$AF$2,IF(E26=\"Middels\",$AE$2,IF(E26=\"Liten\",$AD$2,0)))","v":0}]
["3-2","Lagringsforhold","6.3",null,null,null,null,null,null,null,2,1,0.3,{"$f":"IF(OR($E27=Inndata!$C$4,$E27=Inndata!$C$5,$E27=Inndata!$C$6),HLOOKUP($E27,K$8:M$1048576,ROW($E27)-ROW($N$8)+1,FALSE),0)","v":0},null,false,{"$f":"IF(OR(P27=FALSE,R27=FALSE,S27=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$24=TRUE,TRUE,NOT(ISBLANK(E27)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E27=Inndata!$C$4,Karaktermatrise!$E27=Inndata!$C$5,Karaktermatrise!$E27=Inndata!$C$6,Karaktermatrise!$E27=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["3-3","Mellomnivåsprinkler","6.3.2, 12.5",null,null,null,null,null,null,null,2,1,0.3,{"$f":"IF(OR($E28=Inndata!$C$4,$E28=Inndata!$C$5,$E28=Inndata!$C$6),HLOOKUP($E28,K$8:M$1048576,ROW($E28)-ROW($N$8)+1,FALSE),0)","v":0},null,false,{"$f":"IF(OR(P28=FALSE,R28=FALSE,S28=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$24=TRUE,TRUE,NOT(ISBLANK(E28)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E28=Inndata!$C$4,Karaktermatrise!$E28=Inndata!$C$5,Karaktermatrise!$E28=Inndata!$C$6,Karaktermatrise!$E28=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["3-4","Beskyttelse av spesiell risiko","Tillegg G",null,null,null,null,null,null,null,2,1,0.3,{"$f":"IF(OR($E29=Inndata!$C$4,$E29=Inndata!$C$5,$E29=Inndata!$C$6),HLOOKUP($E29,K$8:M$1048576,ROW($E29)-ROW($N$8)+1,FALSE),0)","v":0},null,false,{"$f":"IF(OR(P29=FALSE,R29=FALSE,S29=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$24=TRUE,TRUE,NOT(ISBLANK(E29)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E29=Inndata!$C$4,Karaktermatrise!$E29=Inndata!$C$5,Karaktermatrise!$E29=Inndata!$C$6,Karaktermatrise!$E29=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
[]
["4. Vannforsyning, generelt"]
["Pos.","Kontrollpunkt","Referanse","Beregnet trekk","Vurdering","Ref. til FG-kontroll","Kommentar vurdering",null,null,null,{"$f":"Inndata!$C$4","v":"Stor"},{"$f":"Inndata!$C$5","v":"Middels"},{"$f":"Inndata!$C$6","v":"Liten"},"Karakter-trekk",null,{"$f":"P$7","v":"Vises kun ved \n1.gangskontroll?"},{"$f":"Q$7","v":"Vise ved rutinekont?"},{"$f":"R$7","v":"Utfylt?"},{"$f":"S$7","v":"Avvik/ merknad?"},{"$f":"T$7","v":"Intern kommentar"},null,"Maks trekk","Min trekk"]
["4-1","Operasjonstid, kontinuitet og vanntrykk","8.1, 8.2",null,null,null,null,null,null,null,5,1,0.5,{"$f":"IF(OR($E33=Inndata!$C$4,$E33=Inndata!$C$5,$E33=Inndata!$C$6),HLOOKUP($E33,K$8:M$1048576,ROW($E33)-ROW($N$8)+1,FALSE),0)","v":0},null,false,{"$f":"IF(OR(P33=FALSE,R33=FALSE,S33=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$31=TRUE,TRUE,NOT(ISBLANK(E33)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E33=Inndata!$C$4,Karaktermatrise!$E33=Inndata!$C$5,Karaktermatrise!$E33=Inndata!$C$6,Karaktermatrise!$E33=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,{"$f":"IF(E33=\"Stor\",K33,IF(E33=\"Middels\",L33,IF(E33=\"Liten\",M33,0)))","v":0},{"$f":"IF(E33=\"Stor\",$AF$2,IF(E33=\"Middels\",$AE$2,IF(E33=\"Liten\",$AD$2,0)))","v":0}]
["4-2","Oppbygning vannforsyning - uttak andre formål og trykkbryter for lavt trykk","8.3, 9.2, \nTillegg H",null,null,null,null,null,null,null,2,1,0.3,{"$f":"IF(OR($E34=Inndata!$C$4,$E34=Inndata!$C$5,$E34=Inndata!$C$6),HLOOKUP($E34,K$8:M$1048576,ROW($E34)-ROW($N$8)+1,FALSE),0)","v":0},null,true,{"$f":"IF(OR(P34=FALSE,R34=FALSE,S34=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$31=TRUE,TRUE,NOT(ISBLANK(E34)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E34=Inndata!$C$4,Karaktermatrise!$E34=Inndata!$C$5,Karaktermatrise!$E34=Inndata!$C$6,Karaktermatrise!$E34=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["4-3","Plassering vannforsyningsutstyr","8.4",null,null,null,null,null,null,null,2,1,0.2,{"$f":"IF(OR($E35=Inndata!$C$4,$E35=Inndata!$C$5,$E35=Inndata!$C$6),HLOOKUP($E35,K$8:M$1048576,ROW($E35)-ROW($N$8)+1,FALSE),0)","v":0},null,true,{"$f":"IF(OR(P35=FALSE,R35=FALSE,S35=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$31=TRUE,TRUE,NOT(ISBLANK(E35)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E35=Inndata!$C$4,Karaktermatrise!$E35=Inndata!$C$5,Karaktermatrise!$E35=Inndata!$C$6,Karaktermatrise!$E35=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["4-4","Tilbakeslagssikring og tilpasning til lokale forhold","NS1717",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E36=Inndata!$C$4,$E36=Inndata!$C$5,$E36=Inndata!$C$6),HLOOKUP($E36,K$8:M$1048576,ROW($E36)-ROW($N$8)+1,FALSE),0)","v":0},null,false,{"$f":"IF(OR(P36=FALSE,R36=FALSE,S36=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$31=TRUE,TRUE,NOT(ISBLANK(E36)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E36=Inndata!$C$4,Karaktermatrise!$E36=Inndata!$C$5,Karaktermatrise!$E36=Inndata!$C$6,Karaktermatrise!$E36=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["4-5","Kapasitetsmåling","8.5, 8.6",null,null,null,null,null,null,null,5,1.5,0.5,{"$f":"IF(OR($E37=Inndata!$C$4,$E37=Inndata!$C$5,$E37=Inndata!$C$6),HLOOKUP($E37,K$8:M$1048576,ROW($E37)-ROW($N$8)+1,FALSE),0)","v":0},null,false,{"$f":"IF(OR(P37=FALSE,R37=FALSE,S37=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$31=TRUE,TRUE,NOT(ISBLANK(E37)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E37=Inndata!$C$4,Karaktermatrise!$E37=Inndata!$C$5,Karaktermatrise!$E37=Inndata!$C$6,Karaktermatrise!$E37=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
[]
["5. Vannforsyning, spesielt",null,null,null,null,null,null,false,false]
["Pos.","Kontrollpunkt","Referanse","Beregnet trekk","Vurdering","Ref. til FG-kontroll","Kommentar vurdering",null,null,null,{"$f":"Inndata!$C$4","v":"Stor"},{"$f":"Inndata!$C$5","v":"Middels"},{"$f":"Inndata!$C$6","v":"Liten"},"Karakter-trekk",null,{"$f":"P$7","v":"Vises kun ved \n1.gangskontroll?"},{"$f":"Q$7","v":"Vise ved rutinekont?"},{"$f":"R$7","v":"Utfylt?"},{"$f":"S$7","v":"Avvik/ merknad?"},{"$f":"T$7","v":"Intern kommentar"},null,"Maks trekk","Min trekk"]
["5-1","Lagringstank","9.3,20.3.5, 20.3.6, \nTillegg H",null,null,null,null,null,null,null,3,1,0.5,{"$f":"IF(OR($E41=Inndata!$C$4,$E41=Inndata!$C$5,$E41=Inndata!$C$6),HLOOKUP($E41,K$8:M$1048576,ROW($E41)-ROW($N$8)+1,FALSE),0)","v":0},null,false,{"$f":"IF(OR(P41=FALSE,R41=FALSE,S41=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$39=TRUE,TRUE,NOT(ISBLANK(E41)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E41=Inndata!$C$4,Karaktermatrise!$E41=Inndata!$C$5,Karaktermatrise!$E41=Inndata!$C$6,Karaktermatrise!$E41=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,{"$f":"IF(E41=\"Stor\",K41,IF(E41=\"Middels\",L41,IF(E41=\"Liten\",M41,0)))","v":0},{"$f":"IF(E41=\"Stor\",$AF$2,IF(E41=\"Middels\",$AE$2,IF(E41=\"Liten\",$AD$2,0)))","v":0}]
["5-2","Utømmelig kilde","9.4",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E42=Inndata!$C$4,$E42=Inndata!$C$5,$E42=Inndata!$C$6),HLOOKUP($E42,K$8:M$1048576,ROW($E42)-ROW($N$8)+1,FALSE),0)","v":0},null,false,{"$f":"IF(OR(P42=FALSE,R42=FALSE,S42=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$39=TRUE,TRUE,NOT(ISBLANK(E42)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E42=Inndata!$C$4,Karaktermatrise!$E42=Inndata!$C$5,Karaktermatrise!$E42=Inndata!$C$6,Karaktermatrise!$E42=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["5-3","Trykktanker","9.5, 20.3.5, 20.3.6, \nTillegg H",null,null,null,null,null,null,null,3,1,0.5,{"$f":"IF(OR($E43=Inndata!$C$4,$E43=Inndata!$C$5,$E43=Inndata!$C$6),HLOOKUP($E43,K$8:M$1048576,ROW($E43)-ROW($N$8)+1,FALSE),0)","v":0},null,false,{"$f":"IF(OR(P43=FALSE,R43=FALSE,S43=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$39=TRUE,TRUE,NOT(ISBLANK(E43)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E43=Inndata!$C$4,Karaktermatrise!$E43=Inndata!$C$5,Karaktermatrise!$E43=Inndata!$C$6,Karaktermatrise!$E43=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
[]
["6. Pumper",null,null,null,null,null,null,false,false]
["Pos.","Kontrollpunkt","Referanse","Beregnet trekk","Vurdering","Ref. til FG-kontroll","Kommentar vurdering",null,null,null,{"$f":"Inndata!$C$4","v":"Stor"},{"$f":"Inndata!$C$5","v":"Middels"},{"$f":"Inndata!$C$6","v":"Liten"},"Karakter-trekk",null,{"$f":"P$7","v":"Vises kun ved \n1.gangskontroll?"},{"$f":"Q$7","v":"Vise ved rutinekont?"},{"$f":"R$7","v":"Utfylt?"},{"$f":"S$7","v":"Avvik/ merknad?"},{"$f":"T$7","v":"Intern kommentar"},null,"Maks trekk","Min trekk"]
["6-1","Pumperommet utforming og sikring","10.3",null,null,null,null,null,null,null,3,1,0.5,{"$f":"IF(OR($E47=Inndata!$C$4,$E47=Inndata!$C$5,$E47=Inndata!$C$6),HLOOKUP($E47,K$8:M$1048576,ROW($E47)-ROW($N$8)+1,FALSE),0)","v":0},null,false,{"$f":"IF(OR(P47=FALSE,R47=FALSE,S47=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$45=TRUE,TRUE,NOT(ISBLANK(E47)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E47=Inndata!$C$4,Karaktermatrise!$E47=Inndata!$C$5,Karaktermatrise!$E47=Inndata!$C$6,Karaktermatrise!$E47=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,{"$f":"IF(E47=\"Stor\",K47,IF(E47=\"Middels\",L47,IF(E47=\"Liten\",M47,0)))","v":0},{"$f":"IF(E47=\"Stor\",$AF$2,IF(E47=\"Middels\",$AE$2,IF(E47=\"Liten\",$AD$2,0)))","v":0}]
["6-2","Sprinklerpumpens utførelse og kapasitet","10.5, 10.6, 10.7, 10.8, 10.9",null,null,null,null,null,null,null,4,1,0.3,{"$f":"IF(OR($E48=Inndata!$C$4,$E48=Inndata!$C$5,$E48=Inndata!$C$6),HLOOKUP($E48,K$8:M$1048576,ROW($E48)-ROW($N$8)+1,FALSE),0)","v":0},null,false,{"$f":"IF(OR(P48=FALSE,R48=FALSE,S48=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$45=TRUE,TRUE,NOT(ISBLANK(E48)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E48=Inndata!$C$4,Karaktermatrise!$E48=Inndata!$C$5,Karaktermatrise!$E48=Inndata!$C$6,Karaktermatrise!$E48=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["6-3","Alarmer, prøving og ettersyn","10, 20.2, 20.3",null,null,null,null,null,null,null,3,1,0.2,{"$f":"IF(OR($E49=Inndata!$C$4,$E49=Inndata!$C$5,$E49=Inndata!$C$6),HLOOKUP($E49,K$8:M$1048576,ROW($E49)-ROW($N$8)+1,FALSE),0)","v":0},null,false,{"$f":"IF(OR(P49=FALSE,R49=FALSE,S49=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$45=TRUE,TRUE,NOT(ISBLANK(E49)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E49=Inndata!$C$4,Karaktermatrise!$E49=Inndata!$C$5,Karaktermatrise!$E49=Inndata!$C$6,Karaktermatrise!$E49=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
[]
["7. Anleggstyper og omfang"]
["Pos.","Kontrollpunkt","Referanse","Beregnet trekk","Vurdering","Ref. til FG-kontroll","Kommentar vurdering",null,null,null,{"$f":"Inndata!$C$4","v":"Stor"},{"$f":"Inndata!$C$5","v":"Middels"},{"$f":"Inndata!$C$6","v":"Liten"},"Karakter-trekk",null,{"$f":"P$7","v":"Vises kun ved \n1.gangskontroll?"},{"$f":"Q$7","v":"Vise ved rutinekont?"},{"$f":"R$7","v":"Utfylt?"},{"$f":"S$7","v":"Avvik/ merknad?"},{"$f":"T$7","v":"Intern kommentar"},null,"Maks trekk","Min trekk"]
["7-1","Våtanlegg","11.1, 11.5",null,null,null,null,null,null,null,3,1,0.5,{"$f":"IF(OR($E53=Inndata!$C$4,$E53=Inndata!$C$5,$E53=Inndata!$C$6),HLOOKUP($E53,K$8:M$1048576,ROW($E53)-ROW($N$8)+1,FALSE),0)","v":0},null,false,{"$f":"IF(OR(P53=FALSE,R53=FALSE,S53=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$51=TRUE,TRUE,NOT(ISBLANK(E53)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E53=Inndata!$C$4,Karaktermatrise!$E53=Inndata!$C$5,Karaktermatrise!$E53=Inndata!$C$6,Karaktermatrise!$E53=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,{"$f":"IF(E53=\"Stor\",K53,IF(E53=\"Middels\",L53,IF(E53=\"Liten\",M53,0)))","v":0},{"$f":"IF(E53=\"Stor\",$AF$2,IF(E53=\"Middels\",$AE$2,IF(E53=\"Liten\",$AD$2,0)))","v":0}]
["7-2","Tørranlegg","11.2",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E54=Inndata!$C$4,$E54=Inndata!$C$5,$E54=Inndata!$C$6),HLOOKUP($E54,K$8:M$1048576,ROW($E54)-ROW($N$8)+1,FALSE),0)","v":0},null,false,"Ja",false,{"$f":"IF(OR(Karaktermatrise!$E54=Inndata!$C$4,Karaktermatrise!$E54=Inndata!$C$5,Karaktermatrise!$E54=Inndata!$C$6,Karaktermatrise!$E54=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["7-3","Pre-action anlegg","11.1.3, 11.4, 11.4.2, \nNS3960",null,null,null,null,null,null,null,5,1,0.3,{"$f":"IF(OR($E55=Inndata!$C$4,$E55=Inndata!$C$5,$E55=Inndata!$C$6),HLOOKUP($E55,K$8:M$1048576,ROW($E55)-ROW($N$8)+1,FALSE),0)","v":0},null,false,"Ja",false,{"$f":"IF(OR(Karaktermatrise!$E55=Inndata!$C$4,Karaktermatrise!$E55=Inndata!$C$5,Karaktermatrise!$E55=Inndata!$C$6,Karaktermatrise!$E55=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["7-4","Endeanlegg","11.5, \nTillegg H og I",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E56=Inndata!$C$4,$E56=Inndata!$C$5,$E56=Inndata!$C$6),HLOOKUP($E56,K$8:M$1048576,ROW($E56)-ROW($N$8)+1,FALSE),0)","v":0},null,false,"Ja",false,{"$f":"IF(OR(Karaktermatrise!$E56=Inndata!$C$4,Karaktermatrise!$E56=Inndata!$C$5,Karaktermatrise!$E56=Inndata!$C$6,Karaktermatrise!$E56=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["7-5","Soneinndeling","Tillegg D, H og I",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E57=Inndata!$C$4,$E57=Inndata!$C$5,$E57=Inndata!$C$6),HLOOKUP($E57,K$8:M$1048576,ROW($E57)-ROW($N$8)+1,FALSE),0)","v":0},null,false,"Ja",false,{"$f":"IF(OR(Karaktermatrise!$E57=Inndata!$C$4,Karaktermatrise!$E57=Inndata!$C$5,Karaktermatrise!$E57=Inndata!$C$6,Karaktermatrise!$E57=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["7-6","Personsikringsanlegg","Tillegg F og D",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E58=Inndata!$C$4,$E58=Inndata!$C$5,$E58=Inndata!$C$6),HLOOKUP($E58,K$8:M$1048576,ROW($E58)-ROW($N$8)+1,FALSE),0)","v":0},null,false,"Ja",false,{"$f":"IF(OR(Karaktermatrise!$E58=Inndata!$C$4,Karaktermatrise!$E58=Inndata!$C$5,Karaktermatrise!$E58=Inndata!$C$6,Karaktermatrise!$E58=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
[]
["8. Sprinklerhoder, karakteristikk og plassering"]
["Pos.","Kontrollpunkt","Referanse","Beregnet trekk","Vurdering","Ref. til FG-kontroll","Kommentar vurdering",null,null,null,{"$f":"Inndata!$C$4","v":"Stor"},{"$f":"Inndata!$C$5","v":"Middels"},{"$f":"Inndata!$C$6","v":"Liten"},"Karakter-trekk",null,{"$f":"P$7","v":"Vises kun ved \n1.gangskontroll?"},{"$f":"Q$7","v":"Vise ved rutinekont?"},{"$f":"R$7","v":"Utfylt?"},{"$f":"S$7","v":"Avvik/ merknad?"},{"$f":"T$7","v":"Intern kommentar"},null,"Maks trekk","Min trekk"]
["8-1","Typer og anvendelse","14.2, 14.4, 14.5",null,null,null,null,null,null,null,2,1,0.2,{"$f":"IF(OR($E62=Inndata!$C$4,$E62=Inndata!$C$5,$E62=Inndata!$C$6),HLOOKUP($E62,K$8:M$1048576,ROW($E62)-ROW($N$8)+1,FALSE),0)","v":0},null,false,{"$f":"IF(OR(P62=FALSE,R62=FALSE,S62=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$60=TRUE,TRUE,NOT(ISBLANK(E62)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E62=Inndata!$C$4,Karaktermatrise!$E62=Inndata!$C$5,Karaktermatrise!$E62=Inndata!$C$6,Karaktermatrise!$E62=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,{"$f":"IF(E62=\"Stor\",K62,IF(E62=\"Middels\",L62,IF(E62=\"Liten\",M62,0)))","v":0},{"$f":"IF(E62=\"Stor\",$AF$2,IF(E62=\"Middels\",$AE$2,IF(E62=\"Liten\",$AD$2,0)))","v":0}]
["8-2","Funksjonalitet","14.1, 14.6, 14.7, 14.8, 14.9, Datablad",null,null,null,null,null,null,null,2,1,0.2,{"$f":"IF(OR($E63=Inndata!$C$4,$E63=Inndata!$C$5,$E63=Inndata!$C$6),HLOOKUP($E63,K$8:M$1048576,ROW($E63)-ROW($N$8)+1,FALSE),0)","v":0},null,false,"Ja",false,{"$f":"IF(OR(Karaktermatrise!$E63=Inndata!$C$4,Karaktermatrise!$E63=Inndata!$C$5,Karaktermatrise!$E63=Inndata!$C$6,Karaktermatrise!$E63=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["8-3","Plassering, generelt","12.1",null,null,null,null,null,null,null,2,0.7,0.2,{"$f":"IF(OR($E64=Inndata!$C$4,$E64=Inndata!$C$5,$E64=Inndata!$C$6),HLOOKUP($E64,K$8:M$1048576,ROW($E64)-ROW($N$8)+1,FALSE),0)","v":0},null,false,"Ja",false,{"$f":"IF(OR(Karaktermatrise!$E64=Inndata!$C$4,Karaktermatrise!$E64=Inndata!$C$5,Karaktermatrise!$E64=Inndata!$C$6,Karaktermatrise!$E64=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["8-4","Plassering, dekning og omfang","12.2, 12.3, 12.4",null,null,null,null,null,null,null,2,1,0.2,{"$f":"IF(OR($E65=Inndata!$C$4,$E65=Inndata!$C$5,$E65=Inndata!$C$6),HLOOKUP($E65,K$8:M$1048576,ROW($E65)-ROW($N$8)+1,FALSE),0)","v":0},null,false,"Ja",false,{"$f":"IF(OR(Karaktermatrise!$E65=Inndata!$C$4,Karaktermatrise!$E65=Inndata!$C$5,Karaktermatrise!$E65=Inndata!$C$6,Karaktermatrise!$E65=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["8-5","Plassering, mellomnivåsprinklere","12.5, 14.7",null,null,null,null,null,null,null,2,1,0.3,{"$f":"IF(OR($E66=Inndata!$C$4,$E66=Inndata!$C$5,$E66=Inndata!$C$6),HLOOKUP($E66,K$8:M$1048576,ROW($E66)-ROW($N$8)+1,FALSE),0)","v":0},null,false,"Ja",false,{"$f":"IF(OR(Karaktermatrise!$E66=Inndata!$C$4,Karaktermatrise!$E66=Inndata!$C$5,Karaktermatrise!$E66=Inndata!$C$6,Karaktermatrise!$E66=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["8-6","Plassering, spesielle sprinklere","Tillegg N og P, NFPA13, Datablad",null,null,null,null,null,null,null,3,1.5,0.5,{"$f":"IF(OR($E67=Inndata!$C$4,$E67=Inndata!$C$5,$E67=Inndata!$C$6),HLOOKUP($E67,K$8:M$1048576,ROW($E67)-ROW($N$8)+1,FALSE),0)","v":0},null,false,"Ja",false,{"$f":"IF(OR(Karaktermatrise!$E67=Inndata!$C$4,Karaktermatrise!$E67=Inndata!$C$5,Karaktermatrise!$E67=Inndata!$C$6,Karaktermatrise!$E67=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["8-7","Inspeksjon av sprinklere (25 år)","Tillegg K",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E68=Inndata!$C$4,$E68=Inndata!$C$5,$E68=Inndata!$C$6),HLOOKUP($E68,K$8:M$1048576,ROW($E68)-ROW($N$8)+1,FALSE),0)","v":0},null,false,"Ja",false,{"$f":"IF(OR(Karaktermatrise!$E68=Inndata!$C$4,Karaktermatrise!$E68=Inndata!$C$5,Karaktermatrise!$E68=Inndata!$C$6,Karaktermatrise!$E68=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
[]
["9. Ventiler"]
["Pos.","Kontrollpunkt","Referanse","Beregnet trekk","Vurdering","Ref. til FG-kontroll","Kommentar vurdering",null,null,null,{"$f":"Inndata!$C$4","v":"Stor"},{"$f":"Inndata!$C$5","v":"Middels"},{"$f":"Inndata!$C$6","v":"Liten"},"Karakter-trekk",null,{"$f":"P$7","v":"Vises kun ved \n1.gangskontroll?"},{"$f":"Q$7","v":"Vise ved rutinekont?"},{"$f":"R$7","v":"Utfylt?"},{"$f":"S$7","v":"Avvik/ merknad?"},{"$f":"T$7","v":"Intern kommentar"},null,"Maks trekk","Min trekk"]
["9-1","Kontrollventilsett","15.1, \nTillegg H og I",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E72=Inndata!$C$4,$E72=Inndata!$C$5,$E72=Inndata!$C$6),HLOOKUP($E72,K$8:M$1048576,ROW($E72)-ROW($N$8)+1,FALSE),0)","v":0},null,false,{"$f":"IF(OR(P72=FALSE,R72=FALSE,S72=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$70=TRUE,TRUE,NOT(ISBLANK(E72)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E72=Inndata!$C$4,Karaktermatrise!$E72=Inndata!$C$5,Karaktermatrise!$E72=Inndata!$C$6,Karaktermatrise!$E72=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,{"$f":"IF(E72=\"Stor\",K72,IF(E72=\"Middels\",L72,IF(E72=\"Liten\",M72,0)))","v":0},{"$f":"IF(E72=\"Stor\",$AF$2,IF(E72=\"Middels\",$AE$2,IF(E72=\"Liten\",$AD$2,0)))","v":0}]
["9-2","Stengeventiler nedstrøms kontrollventilsett","15.2, \nTillegg D, H og I, FG krav",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E73=Inndata!$C$4,$E73=Inndata!$C$5,$E73=Inndata!$C$6),HLOOKUP($E73,K$8:M$1048576,ROW($E73)-ROW($N$8)+1,FALSE),0)","v":0},null,false,"Ja",{"$f":"IF($H$70=TRUE,TRUE,NOT(ISBLANK(E73)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E73=Inndata!$C$4,Karaktermatrise!$E73=Inndata!$C$5,Karaktermatrise!$E73=Inndata!$C$6,Karaktermatrise!$E73=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["9-3","Ventiler i ringledning","15.3",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E74=Inndata!$C$4,$E74=Inndata!$C$5,$E74=Inndata!$C$6),HLOOKUP($E74,K$8:M$1048576,ROW($E74)-ROW($N$8)+1,FALSE),0)","v":0},null,false,"Ja",false,{"$f":"IF(OR(Karaktermatrise!$E74=Inndata!$C$4,Karaktermatrise!$E74=Inndata!$C$5,Karaktermatrise!$E74=Inndata!$C$6,Karaktermatrise!$E74=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["9-4","Dreneringsventiler","15.4",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E75=Inndata!$C$4,$E75=Inndata!$C$5,$E75=Inndata!$C$6),HLOOKUP($E75,K$8:M$1048576,ROW($E75)-ROW($N$8)+1,FALSE),0)","v":0},null,false,"Ja",false,{"$f":"IF(OR(Karaktermatrise!$E75=Inndata!$C$4,Karaktermatrise!$E75=Inndata!$C$5,Karaktermatrise!$E75=Inndata!$C$6,Karaktermatrise!$E75=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["9-5","Prøvingsventiler","15.5",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E76=Inndata!$C$4,$E76=Inndata!$C$5,$E76=Inndata!$C$6),HLOOKUP($E76,K$8:M$1048576,ROW($E76)-ROW($N$8)+1,FALSE),0)","v":0},null,false,"Ja",false,{"$f":"IF(OR(Karaktermatrise!$E76=Inndata!$C$4,Karaktermatrise!$E76=Inndata!$C$5,Karaktermatrise!$E76=Inndata!$C$6,Karaktermatrise!$E76=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["9-6","Tilkobling for spyling","15.6",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E77=Inndata!$C$4,$E77=Inndata!$C$5,$E77=Inndata!$C$6),HLOOKUP($E77,K$8:M$1048576,ROW($E77)-ROW($N$8)+1,FALSE),0)","v":0},null,false,"Ja",false,{"$f":"IF(OR(Karaktermatrise!$E77=Inndata!$C$4,Karaktermatrise!$E77=Inndata!$C$5,Karaktermatrise!$E77=Inndata!$C$6,Karaktermatrise!$E77=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["9-7","Manometer","15.7",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E78=Inndata!$C$4,$E78=Inndata!$C$5,$E78=Inndata!$C$6),HLOOKUP($E78,K$8:M$1048576,ROW($E78)-ROW($N$8)+1,FALSE),0)","v":0},null,false,"Ja",false,{"$f":"IF(OR(Karaktermatrise!$E78=Inndata!$C$4,Karaktermatrise!$E78=Inndata!$C$5,Karaktermatrise!$E78=Inndata!$C$6,Karaktermatrise!$E78=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
[]
["10. Alarmer og alarmutstyr"]
["Pos.","Kontrollpunkt","Referanse","Beregnet trekk","Vurdering","Ref. til FG-kontroll","Kommentar vurdering",null,null,null,{"$f":"Inndata!$C$4","v":"Stor"},{"$f":"Inndata!$C$5","v":"Middels"},{"$f":"Inndata!$C$6","v":"Liten"},"Karakter-trekk",null,{"$f":"P$7","v":"Vises kun ved \n1.gangskontroll?"},{"$f":"Q$7","v":"Vise ved rutinekont?"},{"$f":"R$7","v":"Utfylt?"},{"$f":"S$7","v":"Avvik/ merknad?"},{"$f":"T$7","v":"Intern kommentar"},null,"Maks trekk","Min trekk"]
["10-1","Alarmutstyr kontrollventilsett, aktivert sprinkler",0.5,null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E82=Inndata!$C$4,$E82=Inndata!$C$5,$E82=Inndata!$C$6),HLOOKUP($E82,K$8:M$1048576,ROW($E82)-ROW($N$8)+1,FALSE),0)","v":0},null,false,{"$f":"IF(OR(P82=FALSE,R82=FALSE,S82=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$80=TRUE,TRUE,NOT(ISBLANK(E82)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E82=Inndata!$C$4,Karaktermatrise!$E82=Inndata!$C$5,Karaktermatrise!$E82=Inndata!$C$6,Karaktermatrise!$E82=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,{"$f":"IF(E82=\"Stor\",K82,IF(E82=\"Middels\",L82,IF(E82=\"Liten\",M82,0)))","v":0},{"$f":"IF(E82=\"Stor\",$AF$2,IF(E82=\"Middels\",$AE$2,IF(E82=\"Liten\",$AD$2,0)))","v":0}]
["10-2","Alarmutstyr kontrollventilsett, lavt lufttrykk","11.4.1.2, 16.2.3, Tillegg I",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E83=Inndata!$C$4,$E83=Inndata!$C$5,$E83=Inndata!$C$6),HLOOKUP($E83,K$8:M$1048576,ROW($E83)-ROW($N$8)+1,FALSE),0)","v":0},null,false,{"$f":"IF(OR(P83=FALSE,R83=FALSE,S83=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$80=TRUE,TRUE,NOT(ISBLANK(E83)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E83=Inndata!$C$4,Karaktermatrise!$E83=Inndata!$C$5,Karaktermatrise!$E83=Inndata!$C$6,Karaktermatrise!$E83=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["10-3","Alarmutstyr soner","16.2, \nTillegg D",null,null,null,null,null,null,null,2,1.5,0.5,{"$f":"IF(OR($E84=Inndata!$C$4,$E84=Inndata!$C$5,$E84=Inndata!$C$6),HLOOKUP($E84,K$8:M$1048576,ROW($E84)-ROW($N$8)+1,FALSE),0)","v":0},null,false,{"$f":"IF(OR(P84=FALSE,R84=FALSE,S84=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$80=TRUE,TRUE,NOT(ISBLANK(E84)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E84=Inndata!$C$4,Karaktermatrise!$E84=Inndata!$C$5,Karaktermatrise!$E84=Inndata!$C$6,Karaktermatrise!$E84=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["10-4","Overvåkning og alarmoverføring","16.3, 20.3.3.3, \nTillegg H og I, FG-krav",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E85=Inndata!$C$4,$E85=Inndata!$C$5,$E85=Inndata!$C$6),HLOOKUP($E85,K$8:M$1048576,ROW($E85)-ROW($N$8)+1,FALSE),0)","v":0},null,false,{"$f":"IF(OR(P85=FALSE,R85=FALSE,S85=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$80=TRUE,TRUE,NOT(ISBLANK(E85)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E85=Inndata!$C$4,Karaktermatrise!$E85=Inndata!$C$5,Karaktermatrise!$E85=Inndata!$C$6,Karaktermatrise!$E85=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
[]
["11. Rørledninger"]
["Pos.","Kontrollpunkt","Referanse","Beregnet trekk","Vurdering","Ref. til FG-kontroll","Kommentar vurdering",null,null,null,{"$f":"Inndata!$C$4","v":"Stor"},{"$f":"Inndata!$C$5","v":"Middels"},{"$f":"Inndata!$C$6","v":"Liten"},"Karakter-trekk",null,{"$f":"P$7","v":"Vises kun ved \n1.gangskontroll?"},{"$f":"Q$7","v":"Vise ved rutinekont?"},{"$f":"R$7","v":"Utfylt?"},{"$f":"S$7","v":"Avvik/ merknad?"},{"$f":"T$7","v":"Intern kommentar"},null,"Maks trekk","Min trekk"]
["11-1","Rørkvalitet, behandling og sikring","17.1.2, 17.1.6, 17.1.7",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E89=Inndata!$C$4,$E89=Inndata!$C$5,$E89=Inndata!$C$6),HLOOKUP($E89,K$8:M$1048576,ROW($E89)-ROW($N$8)+1,FALSE),0)","v":0},null,false,{"$f":"IF(OR(P89=FALSE,R89=FALSE,S89=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$87=TRUE,TRUE,NOT(ISBLANK(E89)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E89=Inndata!$C$4,Karaktermatrise!$E89=Inndata!$C$5,Karaktermatrise!$E89=Inndata!$C$6,Karaktermatrise!$E89=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,{"$f":"IF(E89=\"Stor\",K89,IF(E89=\"Middels\",L89,IF(E89=\"Liten\",M89,0)))","v":0},{"$f":"IF(E89=\"Stor\",$AF$2,IF(E89=\"Middels\",$AE$2,IF(E89=\"Liten\",$AD$2,0)))","v":0}]
["11-2","Rørdimensjoner","13.3, 13.4, 13.4.5",null,null,null,null,null,null,null,3,1,0.5,{"$f":"IF(OR($E90=Inndata!$C$4,$E90=Inndata!$C$5,$E90=Inndata!$C$6),HLOOKUP($E90,K$8:M$1048576,ROW($E90)-ROW($N$8)+1,FALSE),0)","v":0},null,true,"Ja",{"$f":"IF($H$87=TRUE,TRUE,NOT(ISBLANK(E90)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E90=Inndata!$C$4,Karaktermatrise!$E90=Inndata!$C$5,Karaktermatrise!$E90=Inndata!$C$6,Karaktermatrise!$E90=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["11-3","Drenering og fall","15.4, 17.1.8",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E91=Inndata!$C$4,$E91=Inndata!$C$5,$E91=Inndata!$C$6),HLOOKUP($E91,K$8:M$1048576,ROW($E91)-ROW($N$8)+1,FALSE),0)","v":0},null,true,"Ja",false,{"$f":"IF(OR(Karaktermatrise!$E91=Inndata!$C$4,Karaktermatrise!$E91=Inndata!$C$5,Karaktermatrise!$E91=Inndata!$C$6,Karaktermatrise!$E91=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["11-4","Lufteventiler","15.6",null,null,null,null,null,null,null,2,1,0.1,{"$f":"IF(OR($E92=Inndata!$C$4,$E92=Inndata!$C$5,$E92=Inndata!$C$6),HLOOKUP($E92,K$8:M$1048576,ROW($E92)-ROW($N$8)+1,FALSE),0)","v":0},null,true,"Ja",false,{"$f":"IF(OR(Karaktermatrise!$E92=Inndata!$C$4,Karaktermatrise!$E92=Inndata!$C$5,Karaktermatrise!$E92=Inndata!$C$6,Karaktermatrise!$E92=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["11-5","Fleksible slanger","Datablad",null,null,null,null,null,null,null,3,1,0.1,{"$f":"IF(OR($E93=Inndata!$C$4,$E93=Inndata!$C$5,$E93=Inndata!$C$6),HLOOKUP($E93,K$8:M$1048576,ROW($E93)-ROW($N$8)+1,FALSE),0)","v":0},null,true,"Ja",false,{"$f":"IF(OR(Karaktermatrise!$E93=Inndata!$C$4,Karaktermatrise!$E93=Inndata!$C$5,Karaktermatrise!$E93=Inndata!$C$6,Karaktermatrise!$E93=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["11-6","Oppheng","17.2",null,null,null,null,null,null,null,2,0.7,0.1,{"$f":"IF(OR($E94=Inndata!$C$4,$E94=Inndata!$C$5,$E94=Inndata!$C$6),HLOOKUP($E94,K$8:M$1048576,ROW($E94)-ROW($N$8)+1,FALSE),0)","v":0},null,false,"Ja",false,{"$f":"IF(OR(Karaktermatrise!$E94=Inndata!$C$4,Karaktermatrise!$E94=Inndata!$C$5,Karaktermatrise!$E94=Inndata!$C$6,Karaktermatrise!$E94=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["11-7","Innvendig rørkontroll","Tillegg K",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E95=Inndata!$C$4,$E95=Inndata!$C$5,$E95=Inndata!$C$6),HLOOKUP($E95,K$8:M$1048576,ROW($E95)-ROW($N$8)+1,FALSE),0)","v":0},null,false,"Ja",false,{"$f":"IF(OR(Karaktermatrise!$E95=Inndata!$C$4,Karaktermatrise!$E95=Inndata!$C$5,Karaktermatrise!$E95=Inndata!$C$6,Karaktermatrise!$E95=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
[]
["12. Skilt, angivelser og informasjon"]
["Pos.","Kontrollpunkt","Referanse","Beregnet trekk","Vurdering","Ref. til FG-kontroll","Kommentar vurdering",null,null,null,{"$f":"Inndata!$C$4","v":"Stor"},{"$f":"Inndata!$C$5","v":"Middels"},{"$f":"Inndata!$C$6","v":"Liten"},"Karakter-trekk",null,{"$f":"P$7","v":"Vises kun ved \n1.gangskontroll?"},{"$f":"Q$7","v":"Vise ved rutinekont?"},{"$f":"R$7","v":"Utfylt?"},{"$f":"S$7","v":"Avvik/ merknad?"},{"$f":"T$7","v":"Intern kommentar"},null,"Maks trekk","Min trekk"]
["12-1","Oversiktsplan","18.1",null,null,null,null,null,null,null,2,1,0.1,{"$f":"IF(OR($E99=Inndata!$C$4,$E99=Inndata!$C$5,$E99=Inndata!$C$6),HLOOKUP($E99,K$8:M$1048576,ROW($E99)-ROW($N$8)+1,FALSE),0)","v":0},null,false,{"$f":"IF(OR(P99=FALSE,R99=FALSE,S99=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$97=TRUE,TRUE,NOT(ISBLANK(E99)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E99=Inndata!$C$4,Karaktermatrise!$E99=Inndata!$C$5,Karaktermatrise!$E99=Inndata!$C$6,Karaktermatrise!$E99=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,{"$f":"IF(E99=\"Stor\",K99,IF(E99=\"Middels\",L99,IF(E99=\"Liten\",M99,0)))","v":0},{"$f":"IF(E99=\"Stor\",$AF$2,IF(E99=\"Middels\",$AE$2,IF(E99=\"Liten\",$AD$2,0)))","v":0}]
["12-2","Skilt og anvisning","18.2",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E100=Inndata!$C$4,$E100=Inndata!$C$5,$E100=Inndata!$C$6),HLOOKUP($E100,K$8:M$1048576,ROW($E100)-ROW($N$8)+1,FALSE),0)","v":0},null,false,{"$f":"IF(OR(P100=FALSE,R100=FALSE,S100=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$97=TRUE,TRUE,NOT(ISBLANK(E100)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E100=Inndata!$C$4,Karaktermatrise!$E100=Inndata!$C$5,Karaktermatrise!$E100=Inndata!$C$6,Karaktermatrise!$E100=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
[]
["13 .Ettersyn, kontroll og vedlikehold"]
["Pos.","Kontrollpunkt","Referanse","Beregnet trekk","Vurdering","Ref. til FG-kontroll","Kommentar vurdering",null,null,null,{"$f":"Inndata!$C$4","v":"Stor"},{"$f":"Inndata!$C$5","v":"Middels"},{"$f":"Inndata!$C$6","v":"Liten"},"Karakter-trekk",null,{"$f":"P$7","v":"Vises kun ved \n1.gangskontroll?"},{"$f":"Q$7","v":"Vise ved rutinekont?"},{"$f":"R$7","v":"Utfylt?"},{"$f":"S$7","v":"Avvik/ merknad?"},{"$f":"T$7","v":"Intern kommentar"},null,"Maks trekk","Min trekk"]
["13-1","Ettersyn","20.1, 20.2, 20.3",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E104=Inndata!$C$4,$E104=Inndata!$C$5,$E104=Inndata!$C$6),HLOOKUP($E104,K$8:M$1048576,ROW($E104)-ROW($N$8)+1,FALSE),0)","v":0},null,false,{"$f":"IF(OR(P104=FALSE,R104=FALSE,S104=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$102=TRUE,TRUE,NOT(ISBLANK(E104)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E104=Inndata!$C$4,Karaktermatrise!$E104=Inndata!$C$5,Karaktermatrise!$E104=Inndata!$C$6,Karaktermatrise!$E104=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,{"$f":"IF(E104=\"Stor\",K104,IF(E104=\"Middels\",L104,IF(E104=\"Liten\",M104,0)))","v":0},{"$f":"IF(E104=\"Stor\",$AF$2,IF(E104=\"Middels\",$AE$2,IF(E104=\"Liten\",$AD$2,0)))","v":0}]
["13-2","Kontroll","20.3, 21",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E105=Inndata!$C$4,$E105=Inndata!$C$5,$E105=Inndata!$C$6),HLOOKUP($E105,K$8:M$1048576,ROW($E105)-ROW($N$8)+1,FALSE),0)","v":0},null,false,{"$f":"IF(OR(P105=FALSE,R105=FALSE,S105=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$102=TRUE,TRUE,NOT(ISBLANK(E105)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E105=Inndata!$C$4,Karaktermatrise!$E105=Inndata!$C$5,Karaktermatrise!$E105=Inndata!$C$6,Karaktermatrise!$E105=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["13-3","Vedlikehold","20.3",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E106=Inndata!$C$4,$E106=Inndata!$C$5,$E106=Inndata!$C$6),HLOOKUP($E106,K$8:M$1048576,ROW($E106)-ROW($N$8)+1,FALSE),0)","v":0},null,false,{"$f":"IF(OR(P106=FALSE,R106=FALSE,S106=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$102=TRUE,TRUE,NOT(ISBLANK(E106)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E106=Inndata!$C$4,Karaktermatrise!$E106=Inndata!$C$5,Karaktermatrise!$E106=Inndata!$C$6,Karaktermatrise!$E106=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]
["13-4","Reservesprinklere og deler","20.1.4, 20.3.2.9",null,null,null,null,null,null,null,2,1,0.5,{"$f":"IF(OR($E107=Inndata!$C$4,$E107=Inndata!$C$5,$E107=Inndata!$C$6),HLOOKUP($E107,K$8:M$1048576,ROW($E107)-ROW($N$8)+1,FALSE),0)","v":0},null,false,{"$f":"IF(OR(P107=FALSE,R107=FALSE,S107=TRUE),\"Ja\",\"Nei\")","v":"Ja"},{"$f":"IF($H$102=TRUE,TRUE,NOT(ISBLANK(E107)))","v":false},{"$f":"IF(OR(Karaktermatrise!$E107=Inndata!$C$4,Karaktermatrise!$E107=Inndata!$C$5,Karaktermatrise!$E107=Inndata!$C$6,Karaktermatrise!$E107=Inndata!$C$7),TRUE,FALSE)","v":false},null,null,0,0]

{"sheet":"Inndata","index":1,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[2]
[]
["Vurdering","Beskrivelse","Alternativ"]
[null,"Karaktertrekk nivå 1","Stor"]
[null,"Karaktertrekk nivå 2","Middels"]
[null,"Karaktertrekk nivå 3","Liten"]
[null,"Kommentar uten trekk","Merknad"]
[null,"Ingen avvik","Ingen avvik"]
[null,"Punkt ikke relevant","Ikke relevant"]
[null,"Ingen anleggsvurdering","Ingen anleggsvurdering"]
[]
["Kontrolltype","Kontrolltype","Verdi"]
[1,"1. gangskontroll",1]
[2,"Rutinekontroll",2]
[]
[null,"Valgt kontroll",{"$f":"IF(C17=1,B13,IF(C17=2,B14,\"Ikke valgt\"))","v":"Ikke valgt"}]

{"sheet":"Ark1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}