{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Bruksanvisning","Elektriker"],"not_rendered":{"charts":0,"images":5,"macros":0,"external_links":0,"defined_names":13,"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":"Bruksanvisning","index":0,"n_rows":192,"n_cols":2,"rows_kept":192,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Bruksanvisning for kalkulering av elektriker leveranser."]
[]
[null,"Kalkylesystemet er utviklet av Konsmo Fabrikker AS for raskt å kunne lage en pris på elektriker arbeider til en bolig."]
[null,"Systemet må under ingen omstendighet anses som et prosjekteringsverktøy."]
[null,"Det er ene og alene autoriserte elektrikere som kan forestå prosjektering av el. anlegg."]
[null,"Systemet eies av Konsmo Fabrikker AS og må ikke kopieres eller videreformidles til andre uten Konsmo Fabrikker AS tillatelse."]
[]
[null,"1. Installasjon og tilpasning"]
[null,"Malen bør lastes ned og lagres på egen maskin for innlegging av lokale priser."]
[null,"Når malen er lastet ned og lagret på maskinen klikker du på filnavnet med høyre museknapp og velger åpne for å  redigere "]
[null,"prisene. Dersom du kun vil benytte Konsmo Fabrikker AS malpriser behøver du ikke gjøre noe annet enn å velge ny."]
[null,"Når malen er åpnet piler du ned på venstre side til du finner + tegnet (se bilde under)."]
[null,"Klikk på + tegnet og feltene for innlegging av egne priser dukker opp."]
[null,"Legg inn en eller flere leverandører (fjern malpriser fra Konsmo Fabrikker AS). "]
[null,"Systemet beregnet selv gjennomsnittspriser avhengig av antall leverandører som legges inn."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Når alle prisene er lagt inn klikker du på - tegnet på venstre side for å lukke prismalen."]
[null,"Flytt markøren opp i feltet for byggherrenavn og lagre."]
[null,"Lukk programmet for å åpne det på nytt med dine priser i prismalen."]
[]
[null,"2. Bruk"]
[null,"Åpne programmet ved å høyreklikke på filnavnet og velge ny (alt. kan du dobbeltklikke)."]
[null,"Det vil nå åpnes et nytt kalkylsekjema og du vil beholde malen \"ren\" til neste kalkyle."]
[null,"Legg inn verdier i det gule feltene etter behov. Har du bruk for flere rom av en kategori er det bare å  klikke på det + tegnet"]
[null,"på venstre side og det vil åpnes et nytt rom av valgte kategori."]
[null,"Ved å klikke på valgt romkategori vil det komme frem en forklaring på hva som regnes med til hvert rom (se bilde nedefor)."]
[null,"Denne funksjonen får du bare ved å klikke i første rom av hver kategori."]
[null,"Fyll så ut hele skjemaet. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"For å se priskalkulasjonen må du klikke på + tegnet oppe til høyre (se markøren på bilde nedenfor)."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Klikk på + tegnet for å hente frem priskalkyle."]
[null,"Du kan klikke på - for å lukke priskalylen igjen."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Du har nå laget elektriker kalkylen."]
[null,"Velg lagre som i fil menyen og lagre kalkylen med for eksempel kundenavn, prosjektnr. el."]
[null,"Skriv ut kalylen om du ønsker. Standard utskriftsområdet er definert uten priskalyle."]
[null,"Ønsker du utskrift med priskalkyle må du omdefinere utskriftsområdet."]
[]
[null,"3. Advarsel"]
[null,"Det er kun de gule feltene som er beregnet for innlegging av data."]
[null,"Dersom du skriver i andre felt med unntak av prismalen vil dette ødelegge formler og systemet fungerer ikke som det skal."]
[null,"Skulle du være uheldig å få ødelagt en formel er det enkleste å lukke regnearket uten å lagre og opprette et nytt fra malfilen."]
[]
[null,"VIKTIG! "]
[null,"IKKE SEND REGNEARKET TIL KUNDE ELLER ANDRE FORBINDELSER DA DETTE VIL SYNLIGGJØRE DINE KALKYLEPRISER."]

{"sheet":"Elektriker","index":1,"n_rows":120,"n_cols":26,"rows_kept":120,"cut":false,"hidden":false,"merged":[[119,2,119,6],[119,7,119,8],[119,9,119,10],[119,11,119,12],[119,13,119,14],[119,15,119,16],[117,13,117,14],[117,15,117,16],[118,7,118,8],[118,9,118,10],[118,11,118,12],[118,13,118,14],[118,15,118,16],[117,7,117,8],[117,9,117,10],[117,11,117,12],[115,7,115,8],[115,9,115,10],[115,11,115,12],[115,13,115,14],[115,15,115,16],[116,7,116,8],[116,9,116,10],[116,11,116,12],[116,13,116,14],[116,15,116,16],[113,7,113,8],[113,9,113,10],[113,11,113,12],[113,13,113,14],[113,15,113,16],[114,7,114,8],[114,9,114,10],[114,11,114,12],[114,13,114,14],[114,15,114,16],[111,7,111,8],[111,9,111,10],[111,11,111,12],[111,13,111,14],[111,15,111,16],[110,2,110,6],[110,7,110,8],[110,9,110,10],[110,11,110,12],[110,13,110,14],[110,15,110,16],[109,2,109,6],[109,7,109,8],[109,9,109,10],[109,11,109,12],[109,13,109,14],[109,15,109,16],[108,2,108,6],[108,7,108,8],[108,9,108,10],[108,11,108,12],[108,13,108,14],[108,15,108,16],[106,7,106,8],[106,9,106,10],[106,11,106,12],[106,13,106,14],[106,15,106,16],[107,7,107,8],[107,9,107,10],[107,11,107,12],[107,13,107,14],[107,15,107,16],[104,7,104,8],[104,9,104,10],[104,11,104,12],[104,13,104,14],[104,15,104,16],[105,7,105,8],[105,9,105,10],[105,11,105,12],[105,13,105,14],[105,15,105,16],[102,7,102,8],[102,9,102,10],[102,11,102,12],[102,13,102,14],[102,15,102,16],[101,2,101,6],[101,7,101,8],[101,9,101,10],[101,11,101,12],[101,13,101,14],[101,15,101,16],[100,2,100,6],[100,7,100,8],[100,9,100,10],[100,11,100,12],[100,13,100,14],[100,15,100,16],[99,2,99,6],[99,7,99,8],[99,9,99,10],[99,11,99,12],[99,13,99,14],[99,15,99,16],[98,2,98,6],[98,7,98,8],[98,9,98,10],[98,11,98,12],[98,13,98,14],[98,15,98,16],[97,2,97,6],[97,7,97,8],[97,9,97,10],[97,11,97,12],[97,13,97,14],[97,15,97,16],[96,2,96,6],[96,7,96,8],[96,9,96,10],[96,11,96,12],[96,13,96,14],[96,15,96,16],[95,2,95,6],[95,7,95,8],[95,9,95,10],[95,11,95,12],[95,13,95,14],[95,15,95,16],[94,2,94,6],[94,7,94,8],[94,9,94,10],[94,11,94,12],[94,13,94,14],[94,15,94,16],[93,2,93,6],[93,7,93,8],[93,9,93,10],[93,11,93,12],[93,13,93,14],[93,15,93,16],[92,2,92,6],[92,7,92,8],[92,9,92,10],[92,11,92,12],[92,13,92,14],[92,15,92,16],[91,2,91,6],[91,7,91,8],[91,9,91,10],[91,11,91,12],[91,13,91,14],[91,15,91,16],[90,2,90,6],[90,7,90,8],[90,9,90,10],[90,11,90,12],[90,13,90,14],[90,15,90,16],[89,2,89,6],[89,7,89,8],[89,9,89,10],[89,11,89,12],[89,13,89,14],[89,15,89,16],[79,3,79,5],[80,3,80,5],[82,3,82,5],[84,20,84,22],[88,2,88,6],[88,7,88,8],[88,9,88,10],[88,11,88,12],[88,13,88,14],[88,15,88,16],[72,3,72,5],[74,3,74,5],[75,3,75,5],[76,3,76,5],[77,3,77,5],[78,3,78,5],[66,3,66,5],[67,3,67,5],[68,3,68,5],[69,3,69,5],[70,3,70,5],[71,3,71,5],[1,1,2,2],[1,20,2,23],[62,3,62,4],[63,3,63,5],[64,3,64,5],[65,3,65,5],[1,3,2,19]]}
[]
[null,"El. pkt. plan for bolig til:",null,"Ola Normann",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KUN FOR INTERN BRUK"]
[]
[null,"Areal beregnet rom","Areal m²","Stikkontakter","Stikkontakt for belysning","Bryter","Stikkontakter for TV og audio","Lyspunkt i tak","Lyspunkt over servant","Lyspunkt på vegg","Lyspunkt under overskap","Punkt for komfyr","Punkt for kjøleskap","Punkt for oppvaskmaskin","Punkt for micro","Ventilator","Kaffemaskin","Kontakt for vaskemaskin og tørketrommel",null,"Sum punkter","Pris pr. enhet","Sum pris nto. innkjøp","Administrasjon","Sum"]
[null,"Stue",null,{"$f":"IF(C5=0,\"\",ROUNDUP(C5/4,0))","v":""},{"$f":"IF(C5=0,\"\",1)","v":""},{"$f":"IF(C5=0,\"\",1)","v":""},{"$f":"IF(C5=0,\"\",3)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D5:S5)","v":0},{"$f":"IF($O$88=1,$H$91,IF($O$88=2,$J$91,IF($O$88=3,$L$91,IF($O$88=4,$N$91,IF($O$88=4,$S$91)))))","v":380},{"$f":"T5*U5","v":0},{"$f":"V5*$H$120","v":0},{"$f":"SUM(V5:W5)","v":0}]
[null,"Stue",null,"","","",{"$f":"IF(C6=0,\"\",3)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,380,{"$f":"T6*U6","v":0},{"$f":"V6*$H$120","v":0},{"$f":"SUM(V6:W6)","v":0}]
[null,"Stue",null,"","","",{"$f":"IF(C7=0,\"\",3)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,380,0,0,0]
[null,"Stue",null,"","","",{"$f":"IF(C8=0,\"\",3)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,380,0,0,0]
[null,"Stue",null,"","","",{"$f":"IF(C9=0,\"\",3)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,380,0,0,0]
[null,"Soverom",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,0,380,0,0,0]
[null,"Soverom",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,0,380,0,0,0]
[null,"Soverom",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,0,380,0,0,0]
[null,"Soverom",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,0,380,0,0,0]
[null,"Soverom",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,0,380,0,0,0]
[null,"Soverom",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,0,380,0,0,0]
[null,"Soverom",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,0,380,0,0,0]
[null,"Soverom",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,0,380,0,0,0]
[null,"Gang",null,{"$f":"IF(C18=0,\"\",ROUNDUP(C18/6,0))","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,0,380,0,0,0]
[null,"Gang",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,0,380,0,0,0]
[null,"Gang",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,0,380,0,0,0]
[null,"Entre/hall",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,0,380,0,0,0]
[null,"Entre/hall",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,0,380,0,0,0]
[null,"Entre/hall",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,0,380,0,0,0]
[null,"Vindfang",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,0,380,0,0,0]
[null,"Vindfang",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,0,380,0,0,0]
[null,"Vindfang",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,0,380,0,0,0]
[null,"Sum",null,{"$f":"IF(SUM(D5:D26)>0,SUM(D5:D26),\"\")","v":""},"","","","","","","","","","","","","","","",{"$f":"SUM(T5:T26)","v":0}]
[null,"Teknisk beregnet rom","Lm. benkeplate"]
[null,"Kjøkken",null,{"$f":"IF(C29=0,\"\",IF(C29<4,2,ROUNDUP(C29/2,0))+3)","v":""},{"$f":"IF(C29=0,\"\",1)","v":""},{"$f":"IF(C29=0,\"\",2)","v":""},null,{"$f":"IF(C29=0,\"\",1)","v":""},null,null,{"$f":"IF(C29=0,\"\",1)","v":""},{"$f":"IF(C29=0,\"\",1)","v":""},{"$f":"IF(C29=0,\"\",1)","v":""},{"$f":"IF(C29=0,\"\",1)","v":""},{"$f":"IF(C29=0,\"\",1)","v":""},{"$f":"IF(C29=0,\"\",1)","v":""},null,null,null,{"$f":"SUM(D29:S29)","v":0},{"$f":"IF($O$88=1,$H$91,IF($O$88=2,$J$91,IF($O$88=3,$L$91,IF($O$88=4,$N$91,IF($O$88=5,$S$91)))))","v":380},{"$f":"T29*U29","v":0},{"$f":"V29*$H$120","v":0},{"$f":"SUM(V29:W29)","v":0}]
[null,"Kjøkken",null,{"$f":"IF(C30=0,\"\",IF(C30<4,2,ROUNDUP(C30/2,0))+3)","v":""},{"$f":"IF(C30=0,\"\",1)","v":""},{"$f":"IF(C30=0,\"\",2)","v":""},null,{"$f":"IF(C30=0,\"\",1)","v":""},null,null,{"$f":"IF(C30=0,\"\",1)","v":""},{"$f":"IF(C30=0,\"\",1)","v":""},{"$f":"IF(C30=0,\"\",1)","v":""},{"$f":"IF(C30=0,\"\",1)","v":""},{"$f":"IF(C30=0,\"\",1)","v":""},{"$f":"IF(C30=0,\"\",1)","v":""},null,null,null,{"$f":"SUM(D30:S30)","v":0},{"$f":"IF($O$88=1,$H$91,IF($O$88=2,$J$91,IF($O$88=3,$L$91,IF($O$88=4,$N$91,IF($O$88=5,$S$91)))))","v":380},{"$f":"T30*U30","v":0},{"$f":"V30*$H$120","v":0},{"$f":"SUM(V30:W30)","v":0}]
[null,"Kjøkken",null,{"$f":"IF(C31=0,\"\",IF(C31<4,2,ROUNDUP(C31/2,0))+3)","v":""},{"$f":"IF(C31=0,\"\",1)","v":""},{"$f":"IF(C31=0,\"\",2)","v":""},null,{"$f":"IF(C31=0,\"\",1)","v":""},null,null,{"$f":"IF(C31=0,\"\",1)","v":""},{"$f":"IF(C31=0,\"\",1)","v":""},{"$f":"IF(C31=0,\"\",1)","v":""},{"$f":"IF(C31=0,\"\",1)","v":""},{"$f":"IF(C31=0,\"\",1)","v":""},{"$f":"IF(C31=0,\"\",1)","v":""},null,null,null,{"$f":"SUM(D31:S31)","v":0},{"$f":"IF($O$88=1,$H$91,IF($O$88=2,$J$91,IF($O$88=3,$L$91,IF($O$88=4,$N$91,IF($O$88=5,$S$91)))))","v":380},{"$f":"T31*U31","v":0},{"$f":"V31*$H$120","v":0},{"$f":"SUM(V31:W31)","v":0}]
[null,"Sum",null,{"$f":"IF(SUM(D29:D31)>0,SUM(D29:D31),\"\")","v":""},{"$f":"IF(SUM(E29:E31)>0,SUM(E29:E31),\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"SUM(T29:T31)","v":0}]
[null,"Antall beregnet rom","Antall rom"]
[null,"Bad",null,{"$f":"IF(C34=0,\"\",1)","v":""},null,{"$f":"IF(C34=0,\"\",1)","v":""},null,{"$f":"IF(C34=0,\"\",1)","v":""},{"$f":"IF(C34=0,\"\",1)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D34:S34)*C34","v":0},{"$f":"IF($O$88=1,$H$91,IF($O$88=2,$J$91,IF($O$88=3,$L$91,IF($O$88=4,$N$91,IF($O$88=5,$S$91)))))","v":380},{"$f":"T34*U34","v":0},{"$f":"V34*$H$120","v":0},{"$f":"SUM(V34:W34)","v":0}]
[null,"WC",null,{"$f":"IF(C35=0,\"\",1)","v":""},null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,0,380,{"$f":"T35*U35","v":0},0,0]
[null,"Vaskerom",null,{"$f":"IF(C36=0,\"\",2)","v":""},null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,0,380,0,0,0]
[null,"Teknisk rom",null,{"$f":"IF(C37=0,\"\",1)","v":""},null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,0,380,0,0,0]
[null,"Bod",null,{"$f":"IF(C38=0,\"\",1)","v":""},null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,0,380,0,0,0]
[null,"Kaldtloft",null,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,0,380,0,0,0]
[null,"Garasje",null,{"$f":"IF(C40=0,\"\",4)","v":""},null,"",null,{"$f":"IF(C40=0,\"\",2)","v":""},null,null,null,null,null,null,null,null,null,null,null,0,380,0,0,0]
[null,null,null,{"$f":"IF(SUM(D34:D40)>0,SUM(D34:D40),\"\")","v":""},{"$f":"IF(SUM(E34:E40)>0,SUM(E34:E40),\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"SUM(T34:T40)","v":0}]
[null,"Utvendig","Antall stk."]
[null,"Hoveddør",null,null,null,{"$f":"IF(C43=0,\"\",1)","v":""},null,null,null,{"$f":"IF(C43=0,\"\",1)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"SUM(D43:S43)*C43","v":0},{"$f":"IF($O$88=1,$H$91,IF($O$88=2,$J$91,IF($O$88=3,$L$91,IF($O$88=4,$N$91,IF($O$88=5,$S$91)))))","v":380},{"$f":"T43*U43","v":0},{"$f":"V43*$H$120","v":0},{"$f":"SUM(V43:W43)","v":0}]
[null,"Balkong/bi-inngangsdør",null,null,null,{"$f":"IF(C44=0,\"\",1)","v":""},null,null,null,{"$f":"IF(C44=0,\"\",1)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"SUM(D44:S44)*C44","v":0},{"$f":"IF($O$88=1,$H$91,IF($O$88=2,$J$91,IF($O$88=3,$L$91,IF($O$88=4,$N$91,IF($O$88=5,$S$91)))))","v":380},{"$f":"T44*U44","v":0},{"$f":"V44*$H$120","v":0},{"$f":"SUM(V44:W44)","v":0}]
[null,"Balkongdør (to-fløy)",null,null,null,{"$f":"IF(C45=0,\"\",1)","v":""},null,null,null,{"$f":"IF(C45=0,\"\",2)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"SUM(D45:S45)*C45","v":0},{"$f":"IF($O$88=1,$H$91,IF($O$88=2,$J$91,IF($O$88=3,$L$91,IF($O$88=4,$N$91,IF($O$88=5,$S$91)))))","v":380},{"$f":"T45*U45","v":0},{"$f":"V45*$H$120","v":0},{"$f":"SUM(V45:W45)","v":0}]
[null,"HS-dør",null,null,null,{"$f":"IF(C46=0,\"\",1)","v":""},null,null,null,{"$f":"IF(C46=0,\"\",2)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"SUM(D46:S46)*C46","v":0},{"$f":"IF($O$88=1,$H$91,IF($O$88=2,$J$91,IF($O$88=3,$L$91,IF($O$88=4,$N$91,IF($O$88=5,$S$91)))))","v":380},{"$f":"T46*U46","v":0},{"$f":"V46*$H$120","v":0},{"$f":"SUM(V46:W46)","v":0}]
[null,"Stikkontakt v/balkong",null,{"$f":"IF(C47=0,\"\",1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D47:S47)*C47","v":0},{"$f":"IF($O$88=1,$H$91,IF($O$88=2,$J$91,IF($O$88=3,$L$91,IF($O$88=4,$N$91,IF($O$88=5,$S$91)))))","v":380},{"$f":"T47*U47","v":0},{"$f":"V47*$H$120","v":0},{"$f":"SUM(V47:W47)","v":0}]
[null,null,null,{"$f":"IF(SUM(D43:D47)>0,SUM(D43:D47),\"\")","v":""},{"$f":"IF(SUM(E43:E47)>0,SUM(E43:E47),\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"SUM(T43:T47)","v":0}]
[null,"Teknisk/diverse","Antall"]
[null,"Tilkobling VVB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C50","v":0},{"$f":"IF($O$88=1,$H$91,IF($O$88=2,$J$91,IF($O$88=3,$L$91,IF($O$88=4,$N$91,IF($O$88=5,$S$91)))))","v":380},{"$f":"T50*U50","v":0},{"$f":"V50*$H$120","v":0},{"$f":"SUM(V50:W50)","v":0}]
[null,"Tilkobling ventilasjon",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF($O$88=1,$H$94,IF($O$88=2,$J$94,IF($O$88=3,$L$94,IF($O$88=4,$N$94,IF($O$88=5,$S$94)))))","v":2000},0,0,0]
[null,"Tilkobling sentalstøvsuger",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF($O$88=1,$H$91,IF($O$88=2,$J$91,IF($O$88=3,$L$91,IF($O$88=4,$N$91,IF($O$88=5,$S$91)))))","v":380},0,0,0]
[null,"Ringeanlegg (komplett)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF($O$88=1,$H$96,IF($O$88=2,$J$96,IF($O$88=3,$L$96,IF($O$88=4,$N$96,IF($O$88=5,$S$96)))))","v":790},0,0,0]
[null,"Rør for tlf./bredbånd",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF($O$88=1,$H$92,IF($O$88=2,$J$92,IF($O$88=3,$L$92,IF($O$88=4,$N$92,IF($O$88=5,$S$92)))))","v":400},{"$f":"T54*U54","v":0},0,{"$f":"SUM(V54:W54)","v":0}]
[null,"Rør for TV antenne",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF($O$88=1,$H$92,IF($O$88=2,$J$92,IF($O$88=3,$L$92,IF($O$88=4,$N$92,IF($O$88=5,$S$92)))))","v":400},{"$f":"T55*U55","v":0},0,{"$f":"SUM(V55:W55)","v":0}]
[null,"Komfyrvakt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF($O$88=1,$H$98,IF($O$88=2,$J$98,IF($O$88=3,$L$98,IF($O$88=4,$N$98,IF($O$88=5,$S$98)))))","v":4000},0,0,0]
[null,"Seriekoblet brannvarsler",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF($O$88=1,$H$99,IF($O$88=2,$J$99,IF($O$88=3,$L$99,IF($O$88=4,$N$99,IF($O$88=5,$S$99)))))","v":915},0,0,0]
[null,"Noby 801 sentral",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF($O$88=1,$H$100,IF($O$88=2,$J$100,IF($O$88=3,$L$100,IF($O$88=4,$N$100,IF($O$88=5,$S$100)))))","v":1200},0,0,0]
[null,"Sikringskap m/jordfeilautomat",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF($O$88=1,$H$90,IF($O$88=2,$J$90,IF($O$88=3,$L$90,IF($O$88=4,$N$90,IF($O$88=5,$S$90)))))","v":8000},0,0,0]
[null,"Våtromsvifte (komplett)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF($O$88=1,$H$97,IF($O$88=2,$J$97,IF($O$88=3,$L$97,IF($O$88=4,$N$97,IF($O$88=5,$S$97)))))","v":1300},0,0,0]
[null,"Stigekabler pr. bo-enhet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF($O$88=1,$H$102,IF($O$88=2,$J$102,IF($O$88=3,$L$102,IF($O$88=4,$N$102,IF($O$88=5,$S$102)))))","v":2000},0,0,0]
[]
[null,"Varmekabler (rom)","Areal m²","Watt pr. m²"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C64>0,INDEX(Varmekabler_pris+IF(Z64=TRUE,$P$112),MATCH(D64,Varmekabler,0)),0)","v":0},{"$f":"IF(C64>0,C64*U64+$P$110+$P$111,0)","v":0},{"$f":"V64*$H$120","v":0},{"$f":"SUM(U64:W64)","v":0},null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(C65>0,C65*U65+$P$110+$P$111,0)","v":0},0,{"$f":"SUM(U65:W65)","v":0},null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,false]
[]
[null,"Tillegg","Antall","Enhetspris"]
[null,"Standard pkt.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C76","v":0},{"$f":"IF($O$88=1,$H$91,IF($O$88=2,$J$91,IF($O$88=3,$L$91,IF($O$88=4,$N$91,IF($O$88=5,$S$91)))))","v":380},{"$f":"T76*U76","v":0},{"$f":"V76*$H$120","v":0},{"$f":"SUM(V76:W76)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"C77*D77","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"C78*D78","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"C79*D79","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"C80*D80","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"C81*D81","v":0},0,0,0]
[]
[null,"Reisetillegg"]
[null,"Reise mellom 0-40 km",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Reise_elektriker_pris,MATCH(B84,Reise_elektriker,0))","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum overføres kalkyle",null,null,{"$f":"SUM(X5:X84)","v":1}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,"PRISMAL\n\nKUN FOR INTERNT BRUK",null,null,null,null,"Leverandør 1",null,"Leverandør 2",null,"Leverandør 3",null,"Gjennomsnitt",null,"Kalkylepris"]
[null,null,"Komplett sikringskap m/jordfeilautomat",null,null,null,null,0,null,0,null,8000,null,{"$f":"(H90+J90+L90)/R90","v":8000},null,{"$f":"N90","v":8000},null,{"$f":"COUNTIF(H90:M90,\">0\")","v":1}]
[null,null,"Pkt. for normalinnstallasjon",null,null,null,null,0,null,0,null,380,null,{"$f":"(H91+J91+L91)/R91","v":380},null,{"$f":"N91","v":380},null,{"$f":"COUNTIF(H91:M91,\">0\")","v":1}]
[null,null,"Trekkrør for telefon/bredbånd mv.",null,null,null,null,0,null,0,null,400,null,400,null,400,null,1]
[null,null,"Pkt./tilkobling VVB",null,null,null,null,0,null,0,null,630,null,630,null,630,null,1]
[null,null,"Pkt./tilkobling ventilasjon",null,null,null,null,0,null,0,null,2000,null,2000,null,2000,null,1]
[null,null,"Pkt./tilkobling sentralstøvsuger",null,null,null,null,0,null,0,null,630,null,630,null,630,null,1]
[null,null,"Komplett ringeanlegg",null,null,null,null,0,null,0,null,790,null,790,null,790,null,1]
[null,null,"Komplett våtromsvifte (hytter)",null,null,null,null,0,null,0,null,1300,null,1300,null,1300,null,1]
[null,null,"Komfyrvakt",null,null,null,null,0,null,0,null,4000,null,4000,null,4000,null,1]
[null,null,"Brannvarsler (seriekoblet)",null,null,null,null,0,null,0,null,915,null,915,null,915,null,1]
[null,null,"Brannmeldersentral",null,null,null,null,0,null,0,null,1200,null,1200,null,1200,null,1]
[null,null,"Inntak utenfor byggefelt ( lufttrekk)",null,null,null,null,0,null,0,null,4725,null,4725,null,4725,null,1]
[null,null,"Stigekabler (andel pr. bo-enhet)",null,null,null,null,0,null,0,null,2000,null,2000,null,2000,null,1]
[]
[null,null,"Varmekabler"]
[null,null,"120 Watt pr. m²",null,null,null,null,0,null,0,null,310,null,{"$f":"(H105+J105+L105)/R105","v":310},null,{"$f":"IF($O$88=1,$H$105,IF($O$88=2,$J$105,IF($O$88=3,$L$105,IF($O$88=4,$N$105,IF($O$88=5,$Q$105)))))","v":310},{"$f":"IF($O$88=2,$H$91,IF($O$88=3,$J$91,IF($O$88=4,$L$91,IF($O$88=5,$N$91,IF($O$88=6,$S$91)))))","v":380},1,null,{"$f":"P105","v":310}]
[null,null,"100 Watt pr. m²",null,null,null,null,0,null,0,null,250,null,{"$f":"(H106+J106+L106)/R106","v":250},null,{"$f":"IF($O$88=1,$H$106,IF($O$88=2,$J$106,IF($O$88=3,$L$106,IF($O$88=4,$N$106,IF($O$88=5,$Q$106)))))","v":250},{"$f":"IF($O$88=2,$H$91,IF($O$88=3,$J$91,IF($O$88=4,$L$91,IF($O$88=5,$N$91,IF($O$88=6,$S$91)))))","v":380},1,null,{"$f":"P106","v":250}]
[null,null,"80 Watt pr. m²",null,null,null,null,0,null,0,null,210,null,{"$f":"(H107+J107+L107)/R107","v":210},null,{"$f":"IF($O$88=1,$H$107,IF($O$88=2,$J$107,IF($O$88=3,$L$107,IF($O$88=4,$N$107,IF($O$88=5,$Q$107)))))","v":210},{"$f":"IF($O$88=2,$H$91,IF($O$88=3,$J$91,IF($O$88=4,$L$91,IF($O$88=5,$N$91,IF($O$88=6,$S$91)))))","v":380},1,null,{"$f":"P107","v":210}]
[null,null,"60 Watt pr. m²",null,null,null,null,0,null,0,null,170,null,{"$f":"(H108+J108+L108)/R108","v":170},null,{"$f":"IF($O$88=1,$H$108,IF($O$88=2,$J$108,IF($O$88=3,$L$108,IF($O$88=4,$N$108,IF($O$88=5,$Q$108)))))","v":170},{"$f":"IF($O$88=2,$H$91,IF($O$88=3,$J$91,IF($O$88=4,$L$91,IF($O$88=5,$N$91,IF($O$88=6,$S$91)))))","v":380},1,null,{"$f":"P108","v":170}]
[]
[null,null,"Termostat m/føler",null,null,null,null,0,null,0,null,1000,null,{"$f":"(H110+J110+L110)/R110","v":1000},null,{"$f":"IF($O$88=1,$H$110,IF($O$88=2,$J$110,IF($O$88=3,$L$110,IF($O$88=4,$N$110,IF($O$88=5,$Q$110)))))","v":1000},{"$f":"IF($O$88=2,$H$91,IF($O$88=3,$J$91,IF($O$88=4,$L$91,IF($O$88=5,$N$91,IF($O$88=6,$S$91)))))","v":380},1]
[null,null,"Tilkobling",null,null,null,null,0,null,0,null,380,null,{"$f":"(H111+J111+L111)/R111","v":380},null,{"$f":"IF($O$88=1,$H$111,IF($O$88=2,$J$111,IF($O$88=3,$L$111,IF($O$88=4,$N$111,IF($O$88=5,$Q$111)))))","v":380},{"$f":"IF($O$88=2,$H$91,IF($O$88=3,$J$91,IF($O$88=4,$L$91,IF($O$88=5,$N$91,IF($O$88=6,$S$91)))))","v":380},1]
[null,null,"Tillegg trebjelkelag pr. m²",null,null,null,null,0,null,0,null,200,null,{"$f":"(H112+J112+L112)/R112","v":200},null,{"$f":"IF($O$88=1,$H$112,IF($O$88=2,$J$112,IF($O$88=3,$L$112,IF($O$88=4,$N$112,IF($O$88=5,$Q$112)))))","v":200},{"$f":"IF($O$88=2,$H$91,IF($O$88=3,$J$91,IF($O$88=4,$L$91,IF($O$88=5,$N$91,IF($O$88=6,$S$91)))))","v":380},1]
[]
[null,null,"Reise mellom 0-40 km",null,null,null,null,0,null,0,null,1,null,{"$f":"(H114+J114+L114)/R114","v":1},null,{"$f":"IF($O$88=1,$H$114,IF($O$88=2,$J$114,IF($O$88=3,$L$114,IF($O$88=4,$N$114,IF($O$88=5,$Q$114)))))","v":1},{"$f":"IF($O$88=2,$H$91,IF($O$88=3,$J$91,IF($O$88=4,$L$91,IF($O$88=5,$N$91,IF($O$88=6,$S$91)))))","v":380},1,null,{"$f":"P114","v":1}]
[null,null,"Reise mellom 40-50 km",null,null,null,null,0,null,0,null,1600,null,1600,null,{"$f":"IF($O$88=1,$H$115,IF($O$88=2,$J$115,IF($O$88=3,$L$115,IF($O$88=4,$N$115,IF($O$88=5,$Q$115)))))","v":1600},380,1,null,1600]
[null,null,"Reise mellom 50-60 km",null,null,null,null,0,null,0,null,1900,null,1900,null,{"$f":"IF($O$88=1,$H$116,IF($O$88=2,$J$116,IF($O$88=3,$L$116,IF($O$88=4,$N$116,IF($O$88=5,$Q$116)))))","v":1900},380,1,null,1900]
[null,null,"Reise mellom 60-70 km",null,null,null,null,0,null,0,null,2850,null,2850,null,{"$f":"IF($O$88=1,$H$117,IF($O$88=2,$J$117,IF($O$88=3,$L$117,IF($O$88=4,$N$117,IF($O$88=5,$Q$117)))))","v":2850},380,1,null,2850]
[null,null,"Reise mellom 70-80 km",null,null,null,null,0,null,0,null,3800,null,3800,null,{"$f":"IF($O$88=1,$H$118,IF($O$88=2,$J$118,IF($O$88=3,$L$118,IF($O$88=4,$N$118,IF($O$88=5,$Q$118)))))","v":3800},380,1,null,3800]
[null,null,"Reise mellom 80-90 km",null,null,null,null,0,null,0,null,5900,null,5900,null,{"$f":"IF($O$88=1,$H$119,IF($O$88=2,$J$119,IF($O$88=3,$L$119,IF($O$88=4,$N$119,IF($O$88=5,$Q$119)))))","v":5900},380,1,null,5900]
[null,null,"Påslag for administrasjon av U-entrenør",null,null,null,null,0.05]