{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Beregner","Stykliste","O","Regulering"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"comments":2,"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":"Beregner","index":0,"n_rows":25,"n_cols":17,"rows_kept":25,"cut":false,"hidden":false,"merged":[[9,14,9,16],[10,14,11,16],[12,14,12,15],[13,14,13,15],[14,14,14,15],[21,14,21,15],[17,14,17,16],[18,14,20,16],[34,1,34,2],[34,3,34,4],[34,5,34,6],[34,9,34,10],[34,11,34,12],[34,13,34,14],[10,1,11,1],[10,0,11,0],[10,5,11,5],[10,6,11,6],[3,3,3,6]]}
["Version 26.1.2017"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Her kan du regulere antal hegnsbrædder,"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"stolper & topplanker v/specielle behov"]
["Protræ modulhegn ",null,null,"TAST SELV I DE GRØNNE FELTER",null,null,null,null,null,null,null,null,null,null,"REGULERING",null,"REGULERET ANTAL"]
[null,null,"Dækbredde","Indtast","Indtast","Indtast","Indtast","Indtast antal","Samlet længde","Forbrug","Antal","Antal","Forbrug","Forbrug"," + / - antal"]
["VÆLG PROFIL (1,8 m)","PRO-nr.","lbm/m2","længde (m)","højde (m)","låge (stk.)","låge (stk.)","mellemrum","mellemrum","i m","brædder","felter  a","brædder","brædder"," brædder","omregnet"]
["↓",null,null,null,null,"B: 90 cm","B: 120 cm","uden låger","uden låger i m","netto","pr. felt","ca. 1,84 m","a 1,8 m","i m brutto",null," til m"]
["Design",{"$f":"VLOOKUP($A$8,O!$B$4:$L$11,7)","v":901},{"$f":"VLOOKUP($A$8,O!$B$4:$L$11,8)","v":12.7},null,null,null,null,null,null,{"$f":"IF(D8>=1.85,O!C75*ROUNDUP((E8-O!$C$53-O!$C$54)*C8,0),0)","v":0},{"$f":"IF(D8>=1.85,IF(O!C79=\"op\",(ROUNDUP((E8-O!$C$53-O!$C$54)*C8,0)),(ROUNDDOWN((E8-O!$C$53-O!$C$54)*C8,0))),0)","v":0},{"$f":"IF(D8>=1.85,ROUNDUP((O!C75/(O!$C$57+O!$C$58)),0),0)","v":0},{"$f":"K8*L8","v":0},{"$f":"IF(D8>=1.85,M8*O!$C$57,0)","v":0},null,{"$f":"O8*1.8","v":0},{"$f":"Regulering!C6+P8","v":0}]
[null,null,null,"Slutlængde (m)","  Færdig hegnshøjde (m):",null,null,{"$f":"IF(AND(I8>0,H8=0),\"Udfyld antal mellemrum\",0)","v":0},{"$f":"IF(AND(H8>0,I8=0),\"Udfyld samlet længde\",0)","v":0}]
[null,null,"Fuld udnyttelse →",{"$f":"L8*(O!C57+O!C58)+F8*O!C55+G8*O!C56+H8*I8","v":0},{"$f":"IF(E8>0,O!C53+O!C54+K8/C8,0)","v":0},null,null,null,null,null,null,null,null,null,"REGULERING"]
["STOLPER (2,7 m)","PRO-nr.",null,null,null,null,null,null,null,null,null,null,null,"Forbrug "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"stolper (stk.)"]
["H-stolper",932,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O!C67-N15","v":-1},null,null,{"$f":"Regulering!C11+O13","v":0}]
["Endestolper",931,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D8>0,O!C66,0)","v":0},null,null,{"$f":"Regulering!C12+O14","v":0}]
["Hjørnestolper",933,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Regulering!C13+O15","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REGULERING"]
[]
["VÆLG TOPPROFIL (3,9 m)","PRO-nr.",null,null,null,null,null,null,null,null,null,null,null,"Forbrug "]
["↓",null,null,null,null,null,null,null,null,null,null,null,null,"toppl. (stk.)"]
["Rund",{"$f":"IF(A22=\"Rund\",960,961)","v":960},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP((D8-F8*O!C55-G8*O!C56)/O!C60,0)","v":0},null,null,{"$f":"Regulering!C19+O22","v":0}]
[]
["Låge B: 90 cm",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F8","v":0},null,null,{"$f":"Regulering!C22","v":0}]
["Låge B: 120 cm",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G8","v":0},null,null,{"$f":"Regulering!C23","v":0}]

{"sheet":"Stykliste","index":1,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[[4,0,4,1],[3,0,3,1],[2,0,2,1],[1,0,1,1]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Stykliste - protræ modulhegn "]
[]
[]
["Styklisten er baseret på indtastet mængde og må kun"]
["betragtes som vejledende."]
["Som følger:"]
[]
["Hegn profil:",{"$f":"Regulering!A6","v":"Design"}]
["Topprofil:",{"$f":"Beregner!A22","v":"Rund"}]
[]
["Færdig hegnslængde:",{"$f":"Beregner!$D$10","v":0}]
["Færdig hegnshøjde:",{"$f":"Beregner!$E$10","v":0}]
["Feltbredde:",{"$f":"O!$C$57+O!$C$58","v":1.84}]
["Antal felter:",{"$f":"Beregner!$L$8","v":0}]
["Brædder pr. felt:",{"$f":"IF(Beregner!$K$8>0,Beregner!$K$8,0)","v":0}]
[]
[]
[]
["Varetekst","PRO-nr.",null,"Antal","Længde (m)","M i alt"]
[]
[{"$f":"CONCATENATE(\"Profil  \",$B$17)","v":"Profil  Design"},{"$f":"Beregner!$B8","v":901},null,{"$f":"Beregner!$M$8+Beregner!$O$8","v":0},{"$f":"O!$C57","v":1.8},{"$f":"$D$30*$E30","v":0}]
[{"$f":"CONCATENATE(\"Topprofil  \",$B$18)","v":"Topprofil  Rund"},{"$f":"Regulering!$B$19","v":960},null,{"$f":"Beregner!$Q$22","v":0},{"$f":"O!$C$60","v":3.9},{"$f":"$D$31*$E$31","v":0}]
["H-stolper",{"$f":"Regulering!$B$11","v":932},null,{"$f":"IF(Beregner!$Q$13>0,Beregner!$Q$13,0)","v":0},{"$f":"O!$C$59","v":2.7},{"$f":"$D$32*$E32","v":0}]
["Endestolper",{"$f":"Regulering!$B$12","v":931},null,{"$f":"Beregner!$Q$14","v":0},{"$f":"O!$C$59","v":2.7},{"$f":"$D$33*$E33","v":0}]
[{"$f":"Regulering!L49","v":" "},{"$f":"IF($A$34=Regulering!$A$13,Regulering!$B$13,IF($A$34=Regulering!$A$22,Regulering!$B$22,IF($A$34=Regulering!$A$23,Regulering!$B$23,\" \")))","v":" "},null,{"$f":"IF($A$34=Regulering!$A$13,Beregner!$Q$15,IF($A$34=Regulering!$A$22,Beregner!$Q$24,IF($A$34=Regulering!$A$23,Beregner!$Q$25,0)))","v":0},{"$f":"IF(A34=Beregner!A15,IF($A$34=Regulering!$A$13,O!$C$59,IF($A$34=Regulering!$A$22,Beregner!$E$8,IF($A$34=Regulering!$A$23,Beregner!$E$8,0))),0)","v":0},{"$f":"IF($D$34>0,$D$34*$E$34,0)","v":0}]
[{"$f":"Regulering!L50","v":" "},{"$f":"IF($A$35=Regulering!$A$22,Regulering!$B$22,IF($A$35=Regulering!$A$23,Regulering!$B$23,\" \"))","v":" "},null,{"$f":"IF($A$35=Regulering!$A$22,Beregner!$Q$24,IF($A$35=Regulering!$A$23,Beregner!$Q$25,0))","v":0}]
[{"$f":"Regulering!L51","v":" "},{"$f":"IF(A36=Regulering!A23,Regulering!B23,\" \")","v":" "},null,{"$f":"IF(A36=Regulering!A23,Beregner!Q25,0)","v":0}]

{"sheet":"O","index":2,"n_rows":90,"n_cols":9,"rows_kept":90,"cut":false,"hidden":true,"merged":[]}
[null,null,"P1 impr.","Klasse AB","Klasse AB","Grundmalet","Grund & top",null,"Dækbredde"]
[null,"PRISER ","gran","fyr (grøn)","fyr (brun)","sort ","malet sort","PRO-nr.","lbm/m2"]
[null,null,"us/kvinta","kvinta","kvinta","gran us/kta","gran us/kta"]
[null,"Almue",null,null,null,null,null,906,7.7]
[null,"Blokhus",null,null,null,null,null,905,7.7]
[null,"Design",null,null,null,null,null,901,12.7]
[null,"Klink db.",null,null,null,null,null,902,8.06]
[null,"Klink twin",null,null,null,null,null,904,7.7]
[null,"Rafte",null,null,null,null,null,900,11.9]
[null,"TGV twin",null,null,null,null,null,903,7.7]
[null,"Anbrudstillæg"]
[null,"Topplanker"]
[]
[]
[]
[]
[null,null,null,"Kl.A ↓ grøn","Kl.A ↓brun"]
[null,"Stolper (kl.A)"]
[]
[null,"Låger 90 cm bredde"]
[null,null,"P1 impr.","Klasse AB","Klasse AB","Grundmalet","Grund & top"]
[null,"kr.","gran","fyr (grøn)","fyr (brun)","sort ","malet sort"]
[null,null,"us/kvinta","kvinta","kvinta","gran us/kta","gran us/kta"]
[null,"Min. pris"]
[null,"Pris pr. m = eller > H: 120 cm"]
[]
[null,"Pris pr. m > H: 151 cm"]
[]
[null,null,{"$f":"Beregner!$E$8","v":0},{"$f":"Beregner!$E$8","v":0},{"$f":"Beregner!$E$8","v":0},{"$f":"Beregner!$E$8","v":0},{"$f":"Beregner!$E$8","v":0}]
[null,null,{"$f":"C24","v":0},{"$f":"D24","v":0},0,0,0]
[null,null,{"$f":"IF(C29<1.2,0,(C29-1.2)*C25)","v":0},{"$f":"IF(D29<1.2,0,(D29-1.2)*D25)","v":0},0,0,0]
[null,null,{"$f":"IF(C29<1.5,0,(C29-1.5)*(C27-C25))","v":0},{"$f":"IF(D29<1.5,0,(D29-1.5)*(D27-D25))","v":0},0,0,0]
[]
[null,null,{"$f":"SUM(C29:C32)","v":0},{"$f":"SUM(D29:D32)","v":0},0,0,0]
[null,"Låger 120 cm bredde"]
[null,null,"P1 impr.","Klasse AB","Klasse AB","Grundmalet","Grund & top"]
[null,"kr. ","gran","fyr (grøn)","fyr (brun)","sort ","malet sort"]
[null,null,"us/kvinta","kvinta","kvinta","gran us/kta","gran us/kta"]
[null,"Min. pris"]
[null,"Pris pr. m = eller > H: 120 cm"]
[]
[null,"Pris pr. m > H: 151 cm"]
[]
[null,null,{"$f":"Beregner!$E$8","v":0},{"$f":"Beregner!$E$8","v":0},{"$f":"Beregner!$E$8","v":0},{"$f":"Beregner!$E$8","v":0},{"$f":"Beregner!$E$8","v":0}]
[null,null,{"$f":"C39","v":0},{"$f":"D39","v":0},0,0,0]
[null,null,{"$f":"IF(C44<1.2,0,(C44-1.2)*C40)","v":0},{"$f":"IF(D44<1.2,0,(D44-1.2)*D40)","v":0},0,0,0]
[null,null,{"$f":"IF(C44<1.5,0,(C44-1.5)*(C42-C40))","v":0},{"$f":"IF(D44<1.5,0,(D44-1.5)*(D42-D40))","v":0},0,0,0]
[]
[null,null,{"$f":"SUM(C44:C47)","v":0},{"$f":"SUM(D44:D47)","v":0},0,0,0]
[]
[]
[]
[null,"Overkant bræt til overkant topplanke",4.4999999999999998E-2]
[null,"Afstand nederste bræt til jord",0.04]
[null,"Lågebredde inkl. Luftspalte",0.92,0.9]
[null,"Lågebredde inkl. Luftspalte",1.22,1]
[null,"Længde på brædder",1.8,1.2]
[null,"Dybde indhak i stolper",0.04]
[null,"Længde på stolper",2.7]
[null,"Længde på topplanke",3.9]
[]
[null,"Antal fag",{"$f":"Beregner!L8","v":0}]
[null,"Låger",{"$f":"Beregner!F8+Beregner!G8","v":0}]
[null,"Antal mellemrum uden låger"]
[]
[null,"Antal endestolper",{"$f":"2+2*C63","v":2}]
[null,"Antal H- stolper",{"$f":"(C62+C63+1)-C66-Beregner!C46","v":-1}]
[]
[null,"Nej"]
[null,"Ja"]
[]
[null,"Rund",960]
[null,"Skrå",961]
[]
[null,"Nyttebredde",{"$f":"Beregner!D8-(ROUNDUP(Beregner!F8,0)*$C$55)-(ROUNDUP(Beregner!G8,0)*$C$56+(C77*Beregner!I8))","v":0}]
[]
[null,"Medregn bredde mellemrum",{"$f":"IF(Beregner!H8>0,Beregner!H8,0)","v":0}]
[]
[null,"Rund op/ned (K7)","Op"]
[]
[null,"Op"]
[null,"Ned"]
[]
[null,"P1 impr. gran us/kvinta",{"$f":"IF(Beregner!#REF!=O!B84,1,0)","v":{"$error":"#REF!"}}]
[null,"Klasse AB fyr (grøn) kvinta",{"$f":"IF(Beregner!#REF!=O!B85,1,0)","v":{"$error":"#REF!"}}]
[null,"Klasse AB fyr (brun) kvinta",{"$f":"IF(Beregner!#REF!=O!B86,1,0)","v":{"$error":"#REF!"}}]
[null,"Grundmalet sort gran us/kvinta",{"$f":"IF(Beregner!#REF!=O!B87,1,0)","v":{"$error":"#REF!"}}]
[null,"Grund & top sort gran us/kvinta",{"$f":"IF(Beregner!#REF!=O!B88,1,0)","v":{"$error":"#REF!"}}]
[]
[null,"Profil"]

{"sheet":"Regulering","index":3,"n_rows":58,"n_cols":12,"rows_kept":58,"cut":false,"hidden":true,"merged":[[8,0,9,0],[8,1,9,1]]}
["Her kan du regulere antal hegnsbrædder, stolper og topprofil. Styklisten tilpasses evt. reguleringer."]
["Protræ modulhegn "]
[null,null,"Forbrug"]
["VALGT PROFIL (1,8 m)","PRO-nr.","brædder"]
[null,null,"beregnet m"]
[{"$f":"Beregner!A8","v":"Design"},{"$f":"Beregner!B8","v":901},{"$f":"Beregner!N8","v":0}]
[]
[]
["VALGTE STOLPER (2,7 m)","PRO-nr.","Forbrug "]
[null,null,"stolper (stk.)"]
["H-stolper",932,{"$f":"IF(Beregner!N13>0,Beregner!N13,0)","v":0}]
["Endestolper",931,{"$f":"Beregner!N14","v":0}]
["Hjørnestolper",933,{"$f":"Beregner!N15","v":0}]
[]
[]
[]
["VALGT TOPPROFIL (3,9 m)","PRO-nr.","Forbrug "]
[null,null,"toppl. (stk.)"]
[{"$f":"Beregner!A22","v":"Rund"},{"$f":"Beregner!B22","v":960},{"$f":"Beregner!N22","v":0}]
[]
["VALGT LÅGE"]
["Låge B: 90 cm",999,{"$f":"Beregner!N24","v":0}]
["Låge B: 120 cm",999,{"$f":"Beregner!N25","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"IF(AND(Beregner!$Q$15>0,Beregner!$Q$24=0,Beregner!$Q$25=0),1,0)","v":0},{"$f":"IF(AND(Beregner!$Q$15>0,Beregner!$Q$24>0,Beregner!$Q$25=0),1,0)","v":0},{"$f":"IF(AND(Beregner!$Q$15>0,Beregner!$Q$24=0,Beregner!$Q$25>0),1,0)","v":0},{"$f":"IF(AND(Beregner!$Q$15>0,Beregner!$Q$24>0,Beregner!$Q$25>0),1,0)","v":0},{"$f":"IF(AND(Beregner!$Q$15=0,Beregner!$Q$24>0,Beregner!$Q$25=0),1,0)","v":0},{"$f":"IF(AND(Beregner!$Q$15=0,Beregner!$Q$24>0,Beregner!$Q$25>0),1,0)","v":0},{"$f":"IF(AND(Beregner!$Q$15=0,Beregner!$Q$24=0,Beregner!$Q$25>0),1,0)","v":0}]
[]
[null,1,{"$f":"A13","v":"Hjørnestolper"},1,1,1,1,0,0,0,{"$f":"$D$47*D49+$E$47*E49+$F$47*F49+$G$47*G49+$H$47*H49+$I$47*I49+$J$47*J49","v":0},{"$f":"IF(K49=1,C49,IF(K50=1,C50,IF(K51=1,C51,\" \")))","v":" "}]
[null,2,{"$f":"A22","v":"Låge B: 90 cm"},0,1,0,1,1,1,0,{"$f":"$D$47*D50+$E$47*E50+$F$47*F50+$G$47*G50+$H$47*H50+$I$47*I50+$J$47*J50","v":0},{"$f":"IF(K53=1,\" \",IF(K53=2,C50,IF(K53=3,C51,\" \")))","v":" "}]
[null,3,{"$f":"A23","v":"Låge B: 120 cm"},0,0,1,1,0,1,1,{"$f":"$D$47*D51+$E$47*E51+$F$47*F51+$G$47*G51+$H$47*H51+$I$47*I51+$J$47*J51","v":0},{"$f":"IF(K54=1,\" \",IF(K54=2,C51,\" \"))","v":" "}]
[]
[null,null,null,1,2,3,2,1,3,1,{"$f":"D47*D53+E47*E53+F47*F53+G47*G53+H47*H53+I47*I53+J47*J53","v":0}]
[null,null,null,1,1,1,2,1,1,1,{"$f":"D47*D54+E47*E54+F47*F54+G47*G54+H47*H54+I47*I54+J47*J54","v":0}]
[]
[null,null,null,"Hjørnestolpe","Hjørnestolpe","Hjørnestolpe","Hjørnestolpe","Låge B: 90 cm","Låge B: 90 cm","Låge B: 120 cm"]
[null,null,null,"-","Låge B: 90 cm","Låge B: 120 cm","Låge B: 90 cm","-","Låge B: 120 cm","-"]
[null,null,null,"-","-",null,"Låge B: 120 cm","-","-","-"]