{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Rekenblad","Rekenblad leges"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":21,"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":"Rekenblad","index":0,"n_rows":360,"n_cols":6,"rows_kept":360,"cut":false,"hidden":false,"merged":[[14,1,14,5],[10,1,10,4],[6,2,6,5],[7,2,7,5],[2,2,2,5],[3,2,3,5],[4,2,4,5],[8,1,8,4],[9,1,9,4],[5,2,5,5]]}
[null,null,null,null,"Versie 2023"]
[null,"Tabel Kengetallen Bouwkosten Súdwest-Fryslân 2023"]
[null,"Naam bouwplan: "]
[null,"Toelichting bouwplan: "]
[null,"Dossier nummer:"]
[null,"OLO nummer:"]
[null,"Datum invoer controle:"]
[null,"Invoer door:"]
[null,"Bouwkosten totaal volgens kengetallentabel",null,null,null,{"$f":"SUM(F18:F360)","v":137400}]
[null,"Minimale bouwkosten 10% onder berekende bouwkosten",null,null,null,{"$f":"F9*(1-10%)","v":123660}]
[null,"Opgegeven bouwkosten op aanvraagformulier. Controleer of excl BTW is opgegeven, klantvriendelijk!"]
[null,"Berekening leges volgens bouwkosten",null,null,null,{"$f":"'Rekenblad leges'!D24","v":3810.7}]
[null,"Berekening leges welstand",null,null,null,{"$f":"'Rekenblad leges'!D18","v":336}]
[]
[null,"Uitleg bij het gebruik van de tabel:\nOm de bouwkosten van een bouwplan te bepalen kunt u het bruto vloeroppervlak van uw bouwplan of de eenheid bij het \"aantal\" invullen bij de volgens u meest overeenkomende categorie. De tabel genereert automatisch de bouwkosten. Bij een uitbreiding vult u het bruto vloeroppervlak of de eenheid in bij het type bouwwerk wat u uitbreidt.\nVoorbeeld: u bouwt een catalogus woning met 2 bouwlagen en een schuin dak met een bruto vloeroppervlak van 120 m2. Vul dan 120 bij het aantal achter catalogus woning 2 laags met een schuin dak. De berekende bouwkosten zullen dan in 2023 € 137.400,00 zijn. Vul dit bedrag in bij de bouwkosten op het aanvraagformulier van omgevingsvergunningaanvraag in."]
[]
["Blz.","WOONFUNCTIE VRIJSTAAND",null,"Eenheid","Prijs","Som"]
[22,"Cataloguswoning (2 laags)",120,"m2 BVO",1145,{"$f":"SUM(C18*E18)","v":137400}]
[23,"Cataloguswoning (3 laags)",null,"m2 BVO",1142,{"$f":"SUM(C19*E19)","v":0}]
[24,"Bungalow (tot 120 m²)",null,"m2 BVO",1747,{"$f":"SUM(C20*E20)","v":0}]
[25,"Herenhuis (schuin dak)",null,"m2 BVO",1307,{"$f":"SUM(C21*E21)","v":0}]
[26,"Herenhuis (plat dak)",null,"m2 BVO",1576,{"$f":"SUM(C22*E22)","v":0}]
[27,"Herenhuis (geschakeld met garage)",null,"m2 BVO",1194,{"$f":"SUM(C23*E23)","v":0}]
[28,"Stedelijke villa (schuin dak)",null,"m2 BVO",1404,{"$f":"SUM(C24*E24)","v":0}]
[29,"Stedelijke villa (plat dak)",null,"m2 BVO",1658,{"$f":"SUM(C25*E25)","v":0}]
[30,"Landelijke villa (schuin dak/klein)",null,"m2 BVO",1470,{"$f":"SUM(C26*E26)","v":0}]
[31,"Landelijke villa (schuin dak/groot)",null,"m2 BVO",1272,{"$f":"SUM(C27*E27)","v":0}]
[34,"Landelijke villa (plat dak)",null,"m2 BVO",1693,{"$f":"SUM(C28*E28)","v":0}]
[35,"Woonboerderij",null,"m2 BVO",1002,{"$f":"SUM(C29*E29)","v":0}]
[32,"Praktijkwoning",null,"m2 BVO",1430,{"$f":"SUM(C30*E30)","v":0}]
[33,"Bungalow (vanaf 120 m²)",null,"m2 BVO",1584,{"$f":"SUM(C31*E31)","v":0}]
["-","Passief huis",null,"m2 BVO",1496,{"$f":"SUM(C32*E32)","v":0}]
["-","Energie neutrale woning",null,"m2 BVO",1396,{"$f":"SUM(C33*E33)","v":0}]
[36,"WOONFUNCTIE TWEE ONDER EEN KAP"]
[37,"Twee onder één kap (schuin dak)",null,"m2 BVO",1195,{"$f":"SUM(C35*E35)","v":0}]
[38,"2^1 kap (schuin, garage geschakeld)",null,"m2 BVO",1179,{"$f":"SUM(C36*E36)","v":0}]
[39,"Twee onder één kap (plat dak)",null,"m2 BVO",1323,{"$f":"SUM(C37*E37)","v":0}]
[42,"2^1 kap (plat dak, garage geschakeld)",null,"m2 BVO",1293,{"$f":"SUM(C38*E38)","v":0}]
[43,"RECREATIEWONINGEN"]
[44,"Vakantiehuisjes bungalowpark",null,"m2 BVO",1139,{"$f":"SUM(C40*E40)","v":0}]
[45,"Recreatiewoning (schuin dak)",null,"m2 BVO",1254,{"$f":"SUM(C41*E41)","v":0}]
[46,"Recreatiewoning (plat dak)",null,"m2 BVO",1503,{"$f":"SUM(C42*E42)","v":0}]
[47,"Chalet",null,"m2 BVO",837,{"$f":"SUM(C43*E43)","v":0}]
[48,"WOONFUNCTIE GESCHAKELD"]
[49,"Seriematig 2 laags (schuin dak)",null,"m2 BVO",1027,{"$f":"SUM(C45*E45)","v":0}]
[50,"Seriematig 2 laags (plat dak)",null,"m2 BVO",1237,{"$f":"SUM(C46*E46)","v":0}]
[51,"Bouwconceptwoning (schuin dak)",null,"m2 BVO",860,{"$f":"SUM(C47*E47)","v":0}]
[41,"Bouwconceptwoning (plat dak)",null,"m2 BVO",945,{"$f":"SUM(C48*E48)","v":0}]
["-","Seriematig 3 laags (schuin dak)",null,"m2 BVO",994,{"$f":"SUM(C49*E49)","v":0}]
[52,"Seriematig 3 laags (plat dak)",null,"m2 BVO",1099,{"$f":"SUM(C50*E50)","v":0}]
[40,"Seriematig 4 laags (plat dak)",null,"m2 BVO",1006,{"$f":"SUM(C51*E51)","v":0}]
[54,"Herenhuis (standaard)",null,"m2 BVO",1332,{"$f":"SUM(C52*E52)","v":0}]
[55,"Inpassing",null,"m2 BVO",1358,{"$f":"SUM(C53*E53)","v":0}]
[53,"Herenhuis (klassiek)",null,"m2 BVO",1621,{"$f":"SUM(C54*E54)","v":0}]
["-","Herenhuis (modern)",null,"m2 BVO",1674,{"$f":"SUM(C55*E55)","v":0}]
[56,"Sociale huurwoningen",null,"m2 BVO",988,{"$f":"SUM(C56*E56)","v":0}]
[57,"Seniorenwoningen",null,"m2 BVO",1046,{"$f":"SUM(C57*E57)","v":0}]
[58,"Drive-in woning (2 laags)",null,"m2 BVO",1284,{"$f":"SUM(C58*E58)","v":0}]
[59,"Drive-in woning (3 laags)",null,"m2 BVO",1143,{"$f":"SUM(C59*E59)","v":0}]
[60,"Drive-in woning (4 laags)",null,"m2 BVO",1046,{"$f":"SUM(C60*E60)","v":0}]
[61,"Patiowoning (1 laags)",null,"m2 BVO",1603,{"$f":"SUM(C61*E61)","v":0}]
[62,"Patiowoning (2 laags)",null,"m2 BVO",1470,{"$f":"SUM(C62*E62)","v":0}]
[63,"WOONFUNCTIE GESTAPELD"]
[68,"Urban villa (2 span)",null,"m2 BVO",1517,{"$f":"SUM(C64*E64)","v":0}]
[69,"Urban villa (3 span)",null,"m2 BVO",1388,{"$f":"SUM(C65*E65)","v":0}]
[70,"Urban villa (4 span)",null,"m2 BVO",1254,{"$f":"SUM(C66*E66)","v":0}]
[72,"Woontoren (tot 6 lagen)",null,"m2 BVO",1204,{"$f":"SUM(C67*E67)","v":0}]
[" -","Woontoren (tot 8 lagen)",null,"m2 BVO",1299,{"$f":"SUM(C68*E68)","v":0}]
[73,"Woontoren (tot 12 lagen)",null,"m2 BVO",1379,{"$f":"SUM(C69*E69)","v":0}]
[76,"Portiekwoning (tot 4 lagen)",null,"m2 BVO",1198,{"$f":"SUM(C70*E70)","v":0}]
[77,"Portiekwoning (vanaf 4 lagen)",null,"m2 BVO",1304,{"$f":"SUM(C71*E71)","v":0}]
[78,"Beneden-bovenwoning (2 laags)",null,"m2 BVO",1308,{"$f":"SUM(C72*E72)","v":0}]
[82,"Beneden-bovenwoning (3 laags)",null,"m2 BVO",1065,{"$f":"SUM(C73*E73)","v":0}]
[83,"Appartementenblok (tot 3 lagen)",null,"m2 BVO",1368,{"$f":"SUM(C74*E74)","v":0}]
[84,"Appartementenblok (tot 6 lagen)",null,"m2 BVO",1342,{"$f":"SUM(C75*E75)","v":0}]
[85,"Appartementenblok (tot 10 lagen)",null,"m2 BVO",1372,{"$f":"SUM(C76*E76)","v":0}]
[86,"Galerijflat, tot 8 lagen",null,"m2 BVO",1300,{"$f":"SUM(C77*E77)","v":0}]
[87,"Galerijflat, tot 12 lagen",null,"m2 BVO",1393,{"$f":"SUM(C78*E78)","v":0}]
[88,"Studentenwoningen (tot 4 lagen)",null,"m2 BVO",1287,{"$f":"SUM(C79*E79)","v":0}]
[89,"Starterswoningen",null,"m2 BVO",1130,{"$f":"SUM(C80*E80)","v":0}]
[" -","Sociale huurwoningen 4 laags",null,"m2 BVO",1163,{"$f":"SUM(C81*E81)","v":0}]
[" -","Sociale huurwoningen (tot 8 lagen)",null,"m2 BVO",1268,{"$f":"SUM(C82*E82)","v":0}]
[" -","Seniorenwoningen 4 laags",null,"m2 BVO",1615,{"$f":"SUM(C83*E83)","v":0}]
["Blz.","Levensloopbestendige woningen",null,"m2 BVO",1393,{"$f":"SUM(C84*E84)","v":0}]
[" -","Zorgwoningen",null,"m2 BVO",1522,{"$f":"SUM(C85*E85)","v":0}]
[" -","WOONFUNCTIE VERPLAATSBAAR / TIJDELIJK"]
[" -","Containerwoningen (tot 20 m²)",null,"m2 BVO",1635,{"$f":"SUM(C87*E87)","v":0}]
[" -","Containerwoning (vanaf 20 m²)",null,"m2 BVO",1388,{"$f":"SUM(C88*E88)","v":0}]
[" -","Waterwoning",null,"m2 BVO",1445,{"$f":"SUM(C89*E89)","v":0}]
[" -","Woonboot",null,"m2 BVO",1258,{"$f":"SUM(C90*E90)","v":0}]
["-","Woonwagen",null,"m2 BVO",908,{"$f":"SUM(C91*E91)","v":0}]
["-","WOONFUNCTIE OPTIES BIJ NIEUWBOUW"]
["-","Prefab kelder onder woning",null,"m2 BVO",811,{"$f":"SUM(C93*E93)","v":0}]
["-","Kelder onder woning",null,"m2 BVO",907,{"$f":"SUM(C94*E94)","v":0}]
["-","Optopping",null,"m2 BVO",1682,{"$f":"SUM(C95*E95)","v":0}]
["Blz.","Opbouw",null,"m2 BVO",1523,{"$f":"SUM(C96*E96)","v":0}]
[92,"Kapopbouw",null,"m2 BVO",777,{"$f":"SUM(C97*E97)","v":0}]
[93,"Dakopbouw geschakeld",null,"m2 BVO",669,{"$f":"SUM(C98*E98)","v":0}]
[94,"Uitbouw",null,"m2 BVO",1646,{"$f":"SUM(C99*E99)","v":0}]
[95,"Aanbouw",null,"m2 BVO",1674,{"$f":"SUM(C100*E100)","v":0}]
[106,"Serre",null,"m1",2922,{"$f":"SUM(C101*E101)","v":0}]
[107,"Erker",null,"m2 BVO",2608,{"$f":"SUM(C102*E102)","v":0}]
[108,"Erker geschakeld",null,"m2 BVO",2183,{"$f":"SUM(C103*E103)","v":0}]
[111,"UITBREIDING GEEN WOONFUNCTIE"]
[170,"Garageaanbouw",null,"m2 BVO",834,{"$f":"SUM(C105*E105)","v":0}]
[183,"Bergingaanbouw",null,"m2 BVO",1236,{"$f":"SUM(C106*E106)","v":0}]
["Blz.","Zwembadaanbouw",null,"m2 BVO",3118,{"$f":"SUM(C107*E107)","v":0}]
[160,"Praktijkaanbouw",null,"m2 BVO",1409,{"$f":"SUM(C108*E108)","v":0}]
[161,"Kelder",null,"m2 BVO",1070,{"$f":"SUM(C109*E109)","v":0}]
[162,"WOONFUNCTIE BIJGEBOUWEN"]
[166,"Garage ongeïsoleerd",null,"m2 BVO",1053,{"$f":"SUM(C111*E111)","v":0}]
[168,"Garage geïsoleerd",null,"m2 BVO",1305,{"$f":"SUM(C112*E112)","v":0}]
[" -","Berging ongeïsoleerd",null,"m2 BVO",1113,{"$f":"SUM(C113*E113)","v":0}]
[174,"Berging geïsoleerd",null,"m2 BVO",1420,{"$f":"SUM(C114*E114)","v":0}]
[175,"Schuur",null,"m2 BVO",667,{"$f":"SUM(C115*E115)","v":0}]
[172,"Carport prefab",null,"m2 BVO",489,{"$f":"SUM(C116*E116)","v":0}]
[176,"Carport gebouw",null,"m2 BVO",700,{"$f":"SUM(C117*E117)","v":0}]
[173,"Carport met berging",null,"m2 BVO",723,{"$f":"SUM(C118*E118)","v":0}]
["Blz.","Garageboxen geschakeld ongeïsoleerd",null,"m2 BVO",809,{"$f":"SUM(C119*E119)","v":0}]
[120,"Garageboxen geschakeld geïsoleerd",null,"m2 BVO",1002,{"$f":"SUM(C120*E120)","v":0}]
[121,"Bergingen geschakeld ongeïsoleerd",null,"m2 BVO",725,{"$f":"SUM(C121*E121)","v":0}]
[122,"Bergingen geschakeld geïsoleerd",null,"m2 BVO",893,{"$f":"SUM(C122*E122)","v":0}]
[123,"WOONFUNCTIE AANPASSING WONING"]
[124,"Daklicht",null,"/ m²",1075,{"$f":"SUM(C124*E124)","v":0}]
[125,"Dakraam",null,"/ m²",1926,{"$f":"SUM(C125*E125)","v":0}]
[126,"Lichtkoepel",null,"/ m² ",606,{"$f":"SUM(C126*E126)","v":0}]
[127,"Dakkapel prefab (bouwkosten o.b.v. uitbreding BVO)",null,"/ m² BVO",1411,{"$f":"SUM(C127*E127)","v":0}]
[132,"Dakkapel uitgetimmerd (bouwkosten o.b.v. uitbreding BVO)",null,"/ m² BVO",1897,{"$f":"SUM(C128*E128)","v":0}]
[128,"Gevelraam begane grond",null,"/ m²",952,{"$f":"SUM(C129*E129)","v":0}]
["Blz.","Gevelraam verdieping",null,"/ m²",1104,{"$f":"SUM(C130*E130)","v":0}]
[115,"Carport prefab",null,"/ m²",411,{"$f":"SUM(C131*E131)","v":0}]
[134,"Carport uitgetimmerd",null,"/ m²",704,{"$f":"SUM(C132*E132)","v":0}]
[135,"Veranda / overkapping",null,"/ m²",744,{"$f":"SUM(C133*E133)","v":0}]
[137,"Dakterras",null,"/ m²",120,{"$f":"SUM(C134*E134)","v":0}]
[138,"Renovatie badkamer standaard ",null,"/ m²",1425,{"$f":"SUM(C135*E135)","v":0}]
["Blz.","renovatie woning 1965-1974 naar Label A",null,"/ m3",86,{"$f":"SUM(C136*E136)","v":0}]
[116,"renovatie woning 1965-1974 naar Label A++",null,"/ m3",146,{"$f":"SUM(C137*E137)","v":0}]
[117,"renovatie woning 1975-1991 naar Label A++",null,"/ m3",139,{"$f":"SUM(C138*E138)","v":0}]
[118,"renovatie woning 1975-1991 naar High-end",null,"/ m3",206,{"$f":"SUM(C139*E139)","v":0}]
[119,"renovatie toilet en /of badruimtes",null,"/ m3",590,{"$f":"SUM(C140*E140)","v":0}]
[178,"ALGEMEEN VERBOUW"]
[179,"Schutting geimpregneerd hout",null,"/ m1",115,{"$f":"SUM(C142*E142)","v":0}]
[180,"Schutting hardhout",null,"/ m1",150,{"$f":"SUM(C143*E143)","v":0}]
[181,"vlaggenmast",null,"st",150,{"$f":"SUM(C144*E144)","v":0}]
[182,"Vervangen/plaatsen raamkozijn (ca. 2 m2)",null,"st  ",1100,{"$f":"SUM(C145*E145)","v":0}]
[184,"Deur- of raamkozijn + deur of raam",null,"st  ",1100,{"$f":"SUM(C146*E146)","v":0}]
[185,"Velux dakraam",null,"st  ",880,{"$f":"SUM(C147*E147)","v":0}]
[187,"Dichtmetselen deur of raamopening",null,"st  ",550,{"$f":"SUM(C148*E148)","v":0}]
[188,"Vervangen dakpannen",null,"m2  ",55,{"$f":"SUM(C149*E149)","v":0}]
[177,"Vervangen dakpannen door dakpanplaten",null,"m2 ",28,{"$f":"SUM(C150*E150)","v":0}]
["Blz.","Plaatsen zonwering",null,"m1",330,{"$f":"SUM(C151*E151)","v":0}]
[202,"Vervangen dakgoten",null,"m1",44,{"$f":"SUM(C152*E152)","v":0}]
[203,"Gevel, metselwerk",null,"m2  ",88,{"$f":"SUM(C153*E153)","v":0}]
[204,"Binnenwand kalkzandsteen lijmblokken",null,"m2",22,{"$f":"SUM(C154*E154)","v":0}]
[205,"Gevel, stucadoren",null,"m2",28,{"$f":"SUM(C155*E155)","v":0}]
[200,"Schuifpui",null,"st  ",2750,{"$f":"SUM(C156*E156)","v":0}]
[201,"Noodtrap",null,"st  ",2200,{"$f":"SUM(C157*E157)","v":0}]
["-","Plaatsen van een pinautomaat",null,"st  ",4400,{"$f":"SUM(C158*E158)","v":0}]
["-","Overheaddeur",null,"st  ",4400,{"$f":"SUM(C159*E159)","v":0}]
["-","Garagedeur ",null,"st  ",1650,{"$f":"SUM(C160*E160)","v":0}]
["-","Plaatsen luifel tankstation",null,"m2 ",165,{"$f":"SUM(C161*E161)","v":0}]
["-","Overkapping bedrijfsgebouw",null,"m2",83,{"$f":"SUM(C162*E162)","v":0}]
["-","Nieuwe gevelbeplating bedrijfshal, sandwich",null,"m2",110,{"$f":"SUM(C163*E163)","v":0}]
["-","Nieuwe gevelbetimmering, red cedar",null,"m2",110,{"$f":"SUM(C164*E164)","v":0}]
["-","Nieuwe trap",null,"st ",3300,{"$f":"SUM(C165*E165)","v":0}]
["-","Toiletruimte",null,"st ",1650,{"$f":"SUM(C166*E166)","v":0}]
["-","Nieuwe verdiepingsvloer aanbrengen",null,"m2 ",110,{"$f":"SUM(C167*E167)","v":0}]
["-","Verandering intern kantoor",null,"m2",165,{"$f":"SUM(C168*E168)","v":0}]
["-","Verandering intern opslag",null,"m2",55,{"$f":"SUM(C169*E169)","v":0}]
["-","Overkapping SPOK (abri) hangplek/rokersruimte",null,"st",6600,{"$f":"SUM(C170*E170)","v":0}]
["-","Schoorsteen/rookgasafvoer (buitenom metaal)",null,"m1",358,{"$f":"SUM(C171*E171)","v":0}]
["-","Schotelantenne 60 cm",null,"st",385,{"$f":"SUM(C172*E172)","v":0}]
[206,"Rolluik 4 x 3 meter",null,"st",3300,{"$f":"SUM(C173*E173)","v":0}]
[207,"Zonnepanelen ",null,"m2",318,{"$f":"SUM(C174*E174)","v":0}]
["-","Vrij in te vullen veld"]
["Blz.","KANTOORFUNCTIE"]
[150,"Kantoorvilla",null,"/ m²",1672,{"$f":"SUM(C177*E177)","v":0}]
[151,"Kleinschalig kantoor",null,"/ m²",1223,{"$f":"SUM(C178*E178)","v":0}]
[153,"Klein kantoor op bedrijfsterrein",null,"/ m²",1148,{"$f":"SUM(C179*E179)","v":0}]
[154,"Kantoorblok (max 6 lagen)",null,"/ m²",1273,{"$f":"SUM(C180*E180)","v":0}]
[156,"Binnenstedelijke inpassing",null,"/ m²",191,{"$f":"SUM(C181*E181)","v":0}]
[157,"Bijzondere vorm (tot 12 lagen)",null,"/ m²",1619,{"$f":"SUM(C182*E182)","v":0}]
["-","Semi-permanent kantoor",null,"/ m²",972,{"$f":"SUM(C183*E183)","v":0}]
[148,"Tijdelijke bebouwing (max. 2 jaar)",null,"/ m²",755,{"$f":"SUM(C184*E184)","v":0}]
[149,"Kleinschalige inpassing",null,"/ m²",1593,{"$f":"SUM(C185*E185)","v":0}]
[159,"Politiebureau (buurtniveau)",null,"/ m²",1845,{"$f":"SUM(C186*E186)","v":0}]
[190,"Brandweerkazerne (buurtniveau)",null,"/ m²",1826,{"$f":"SUM(C187*E187)","v":0}]
[198,"ONDERWIJSFUNCTIE"]
["Blz.","Kinderdagverblijf",null,"/ m²",1423,{"$f":"SUM(C189*E189)","v":0}]
[140,"Basisschool",null,"/ m²",1386,{"$f":"SUM(C190*E190)","v":0}]
[141,"Voortgezet onderwijs, tot twee lagen",null,"/ m²",1362,{"$f":"SUM(C191*E191)","v":0}]
[142,"Voortgezet onderwijs, tot zes lagen",null,"/ m²",1423,{"$f":"SUM(C192*E192)","v":0}]
[143,"Brede school",null,"/ m²",1596,{"$f":"SUM(C193*E193)","v":0}]
[144,"ROC",null,"/ m²",1582,{"$f":"SUM(C194*E194)","v":0}]
[146,"Tijdelijke huisvesting",null,"/ m²",929,{"$f":"SUM(C195*E195)","v":0}]
[147,"Speciale school, lichamelijk",null,"/ m²",1474,{"$f":"SUM(C196*E196)","v":0}]
["Blz.","GEZONDHEIDSZORGFUNCTIE"]
[210,"Ambulance station",null,"/ m²",2966,{"$f":"SUM(C198*E198)","v":0}]
[211,"Perifeer ziekenhuis (< 400 bedden)",null,"/ m²",2823,{"$f":"SUM(C199*E199)","v":0}]
["-","Apothekers- / Huisartsenpost",null,"/ m²",1648,{"$f":"SUM(C200*E200)","v":0}]
[214,"Gezondheidscentrum",null,"/ m²",1545,{"$f":"SUM(C201*E201)","v":0}]
[215,"Begeleid wonen gehandicapten",null,"/ m²",1573,{"$f":"SUM(C202*E202)","v":0}]
[218,"LOGIESFUNCTIE"]
[219,"Budgethotel",null,"/ m²",1404,{"$f":"SUM(C204*E204)","v":0}]
[220,"Hotel 3 sterren",null,"/ m²",1521,{"$f":"SUM(C205*E205)","v":0}]
[221,"Hotel 4 sterren",null,"/ m²",1826,{"$f":"SUM(C206*E206)","v":0}]
[222,"Hotel 5 sterren",null,"/ m²",2011,{"$f":"SUM(C207*E207)","v":0}]
[223,"Hotelconcept (prefab elementen)",null,"/ m²",1777,{"$f":"SUM(C208*E208)","v":0}]
[224,"Snelweghotel",null,"/ m²",1535,{"$f":"SUM(C209*E209)","v":0}]
[225,"BIJEENKOMSTFUNCTIE"]
[226,"Museum kunst",null,"/ m²",2914,{"$f":"SUM(C211*E211)","v":0}]
[227,"Museum belevenis",null,"/ m²",1672,{"$f":"SUM(C212*E212)","v":0}]
[228,"Muziekzaal",null,"/ m²",1618,{"$f":"SUM(C213*E213)","v":0}]
["Blz.","Muziekcentrum",null,"/ m²",1831,{"$f":"SUM(C214*E214)","v":0}]
[" -","Schouwburg met toneeltoren",null,"/ m²",3026,{"$f":"SUM(C215*E215)","v":0}]
[191,"Theater",null,"/ m²",2188,{"$f":"SUM(C216*E216)","v":0}]
[193,"Bioscoop (binnenstedelijk)",null,"/ m²",2176,{"$f":"SUM(C217*E217)","v":0}]
[192,"Kerkgebouw",null,"/ m²",1717,{"$f":"SUM(C218*E218)","v":0}]
[195,"Moskee",null,"/ m²",1847,{"$f":"SUM(C219*E219)","v":0}]
["-","Buurthuis",null,"/ m²",1632,{"$f":"SUM(C220*E220)","v":0}]
["Blz.","WINKELFUNCTIE"]
["-","Supermarkt (buurtniveau)",null,"/ m²",629,{"$f":"SUM(C222*E222)","v":0}]
["-","Bankgebouw",null,"/ m²",1460,{"$f":"SUM(C223*E223)","v":0}]
["-","Meubelhal",null,"/ m²",978,{"$f":"SUM(C224*E224)","v":0}]
["-","Bouwmarkt (enkellaags)",null,"/ m²",555,{"$f":"SUM(C225*E225)","v":0}]
["-","Bouwmarkt (tweelaags)",null,"/ m²",524,{"$f":"SUM(C226*E226)","v":0}]
["-","Vrijstaand paviljoen",null,"/ m²",1267,{"$f":"SUM(C227*E227)","v":0}]
["-","Autowerkplaats (specifiek)",null,"/ m²",840,{"$f":"SUM(C228*E228)","v":0}]
["-","Autowerkplaats",null,"/ m²",779,{"$f":"SUM(C229*E229)","v":0}]
["-","Autoshowroom (merkdealer)",null,"/ m²",979,{"$f":"SUM(C230*E230)","v":0}]
["-","Autoshowroom (tweedehands)",null,"/ m²",866,{"$f":"SUM(C231*E231)","v":0}]
["-","Winkelstraat met bovenwoningen",null,"/ m²",1224,{"$f":"SUM(C232*E232)","v":0}]
["-","Winkelcentrum (buurtniveau)",null,"/ m²",801,{"$f":"SUM(C233*E233)","v":0}]
["-","Winkelcentrum (streekniveau)",null,"/ m²",945,{"$f":"SUM(C234*E234)","v":0}]
["-","Winkelcentrum (regioniveau)",null,"/ m²",984,{"$f":"SUM(C235*E235)","v":0}]
["-","Warenhuis",null,"/ m²",2006,{"$f":"SUM(C236*E236)","v":0}]
["-","Meubelplein",null,"/ m²",732,{"$f":"SUM(C237*E237)","v":0}]
["-","SPORTFUNCTIE"]
["-","Gymzaal",null,"/ m²",1607,{"$f":"SUM(C239*E239)","v":0}]
["-","Kleed- en kantineruimte",null,"/ m²",1339,{"$f":"SUM(C240*E240)","v":0}]
["-","Kantine voetbalvereniging",null,"/ m²",1134,{"$f":"SUM(C241*E241)","v":0}]
["-","Golfclubhuis met restaurant",null,"/ m²",1302,{"$f":"SUM(C242*E242)","v":0}]
["-","Tennishal",null,"/ m²",885,{"$f":"SUM(C243*E243)","v":0}]
["-","Sportcentrum",null,"/ m²",1683,{"$f":"SUM(C244*E244)","v":0}]
["-","Zwembad (recreatief)",null,"/ m²",2582,{"$f":"SUM(C245*E245)","v":0}]
["-","Zwembad (wedstrijdbad)",null,"/ m²",2845,{"$f":"SUM(C246*E246)","v":0}]
["-","Subtropisch zwembad",null,"/ m²",3589,{"$f":"SUM(C247*E247)","v":0}]
["-","Buitenzwembad",null,"/ m²",582,{"$f":"SUM(C248*E248)","v":0}]
["-","INDUSTRIEFUNCTIE"]
["-","Bedrijfspanden met kantoren (< 2.000 m²)",null,"/ m²",738,{"$f":"SUM(C250*E250)","v":0}]
["-","Bedrijfspanden met kantoren (> 2.000 m²)",null,"/ m²",670,{"$f":"SUM(C251*E251)","v":0}]
["-","Bedrijfspanden geschakeld",null,"/ m²",816,{"$f":"SUM(C252*E252)","v":0}]
["-","Distributiecentrum (< 5.000 m²)",null,"/ m²",795,{"$f":"SUM(C253*E253)","v":0}]
["-","Distributiecentrum (< 10.000 m²)",null,"/ m²",743,{"$f":"SUM(C254*E254)","v":0}]
["-","Meerlaags distributiecentrum",null,"/ m²",1013,{"$f":"SUM(C255*E255)","v":0}]
["Blz.","Distributiecentrum (< 40.000 m²)",null,"/ m²",617,{"$f":"SUM(C256*E256)","v":0}]
["-","Self-storage",null,"/ m²",1341,{"$f":"SUM(C257*E257)","v":0}]
["-","Zadeldakloods",null,"/ m²",273,{"$f":"SUM(C258*E258)","v":0}]
["-","Opslagloods (< 5.000 m²)",null,"/ m²",580,{"$f":"SUM(C259*E259)","v":0}]
["-","Opslagloods (> 5.000 m²)",null,"/ m²",517,{"$f":"SUM(C260*E260)","v":0}]
["-","Bedrijfspanden geschakeld (opslag)",null,"/ m²",633,{"$f":"SUM(C261*E261)","v":0}]
["-","Zadeldakloods ongeisoleerd",null,"/ m²",222,{"$f":"SUM(C262*E262)","v":0}]
["-","Romneyloods ongeisoleerd",null,"/ m²",123,{"$f":"SUM(C263*E263)","v":0}]
["-","LICHTE INDUSTRIEFUNCTIE AGRARISCH"]
["-","Loods (open)",null,"/ m²",193,{"$f":"SUM(C265*E265)","v":0}]
["-","Loods (dicht)",null,"/ m²",303,{"$f":"SUM(C266*E266)","v":0}]
["-","Opslagloods agrarische gewassen",null,"/ m²",354,{"$f":"SUM(C267*E267)","v":0}]
["Blz.","Opslagloods agrarische gewassen gekoeld",null,"/ m²",449,{"$f":"SUM(C268*E268)","v":0}]
["-","Aardappelloods (incl. kelderventilatie + inrichting)",null,"/ m²",324,{"$f":"SUM(C269*E269)","v":0}]
["-","Ligboxenstal zonder kelders (zie verder)",null,"/ m²",429,{"$f":"SUM(C270*E270)","v":0}]
["-","Varkensstal fokzeugen en biggen ",null,"/ m²",392,{"$f":"SUM(C271*E271)","v":0}]
["-","Kippenstal voor legkippen",null,"/ m²",314,{"$f":"SUM(C272*E272)","v":0}]
["-","Stal voor vleeskalveren zonder kelders",null,"/ m²",363,{"$f":"SUM(C273*E273)","v":0}]
["-","Stal voor vleesvarkens ",null,"/ m²",363,{"$f":"SUM(C274*E274)","v":0}]
["-","Stal voor Vleeskuikens ",null,"/ m²",294,{"$f":"SUM(C275*E275)","v":0}]
["-","Paardenstal (buiten)",null,"/ m²",453,{"$f":"SUM(C276*E276)","v":0}]
["-","Binnenpiste (open gevel)",null,"/ m²",220,{"$f":"SUM(C277*E277)","v":0}]
["-","Buitenpiste",null,"/ m²",36,{"$f":"SUM(C278*E278)","v":0}]
["-","Paardenstal",null,"/ m²",495,{"$f":"SUM(C279*E279)","v":0}]
["-","Binnenpiste",null,"/ m²",339,{"$f":"SUM(C280*E280)","v":0}]
["-","OPSLAG MEST E.A."]
["W110","Mestkelder (onder nieuwbouw veestal)",null,"/ m²",198,{"$f":"SUM(C282*E282)","v":0}]
["W116","Mestkelder",null,"/ m²",300,{"$f":"SUM(C283*E283)","v":0}]
["W215","Waterbassin (rond)",null,"/ m²",222,{"$f":"SUM(C284*E284)","v":0}]
["-","Waterbassin (met talud)",null,"/ m²",18,{"$f":"SUM(C285*E285)","v":0}]
["-","Silo",null,"/ m²",324,{"$f":"SUM(C286*E286)","v":0}]
["-","TUINBOUWKASSEN"]
["-","Tuinbouwkas (Venlo)",null,"/ m²",52,{"$f":"SUM(C288*E288)","v":0}]
["W146","Tuinbouwkas (breedkap)",null,"/ m²",61,{"$f":"SUM(C289*E289)","v":0}]
["W148","Foliekas",null,"/ m²",43,{"$f":"SUM(C290*E290)","v":0}]
["W174","FIETSENSTALLING"]
["-","Overdekte fietsenstalling",null,"/ m²",204,{"$f":"SUM(C292*E292)","v":0}]
["Blz.","Meerlaagse fietsenstalling",null,"/ m²",265,{"$f":"SUM(C293*E293)","v":0}]
["W199","Bovengronds, open (tot 4 lagen)",null,"/ m²",528,{"$f":"SUM(C294*E294)","v":0}]
["W196","Bovengronds, dicht (tot 4 lagen)",null,"/ m²",638,{"$f":"SUM(C295*E295)","v":0}]
["-","PARKEREN"]
["W197","Oppervlakteparkeren (woonwijk)",null,"/ m²",73,{"$f":"SUM(C297*E297)","v":0}]
["-","Oppervlakteparkeren (openbaar)",null,"/ m²",109,{"$f":"SUM(C298*E298)","v":0}]
["-","Tijdelijk (tot 3 lagen)",null,"/ m²",193,{"$f":"SUM(C299*E299)","v":0}]
["-","Parkeerkelder onder plein (tot 1.000 m²)",null,"/ m²",1133,{"$f":"SUM(C300*E300)","v":0}]
["W126","Parkeerkelder onder plein (tot 5.000 m²)",null,"/ m²",1055,{"$f":"SUM(C301*E301)","v":0}]
["W128","PARKEREN MET BEBOUWING"]
["W134","Parkeren BG onder bebouwing (tot 1000 m²)",null,"/ m²",671,{"$f":"SUM(C303*E303)","v":0}]
["W136","Parkeren BG onder bebouwing (vanaf 1000 m²)",null,"/ m²",592,{"$f":"SUM(C304*E304)","v":0}]
["W140","Half verdiept (tot 750 m²)",null,"/ m²",703,{"$f":"SUM(C305*E305)","v":0}]
["W162","Half verdiept (vanaf 750 m²)",null,"/ m²",636,{"$f":"SUM(C306*E306)","v":0}]
["W164","Geheel verdiept (tot 1.000 m²)",null,"/ m²",898,{"$f":"SUM(C307*E307)","v":0}]
["W168","Geheel verdiept (vanaf 1.000 m²)",null,"/ m²",760,{"$f":"SUM(C308*E308)","v":0}]
["W200","Geheel verdiept (tot 2.500 m²)",null,"/ m²",910,{"$f":"SUM(C309*E309)","v":0}]
["W201","Geheel verdiept (vanaf 2.500 m²)",null,"/ m²",844,{"$f":"SUM(C310*E310)","v":0}]
[null,"Parkeren op dak",null,"/ m²",273,{"$f":"SUM(C311*E311)","v":0}]
[null,"PARKEERSYSTEMEN (MEERPRIJS)"]
[null,"Rotatiesysteem",null,"/ m²",5477,{"$f":"SUM(C313*E313)","v":0}]
[null,"Hefsysteem",null,"/ m²",997,{"$f":"SUM(C314*E314)","v":0}]
[null,"Hefsysteem, verdiept",null,"/ m²",1372,{"$f":"SUM(C315*E315)","v":0}]
[null,"GROND-, WEG- EN WATERBOUW OPENBARE INRICHTING"]
[null,"Speeltuin verhard",null,"/ m²",108,{"$f":"SUM(C317*E317)","v":0}]
[null,"Speeltuin in woonwijk",null,"/ m²",372,{"$f":"SUM(C318*E318)","v":0}]
[null,"Speeltuin in park",null,"/ m²",258,{"$f":"SUM(C319*E319)","v":0}]
[null,"Ondergrondse vuilcontainers",null,"/ st",3785,{"$f":"SUM(C320*E320)","v":0}]
[null,"Transformatorhuis",null,"/ m²",2898,{"$f":"SUM(C321*E321)","v":0}]
[null,"GROND-, WEG- EN WATERBOUW BRUGGEN"]
[null,"Perceelstoegansbrug Vlakke plaatbrug",null,"/ m²",473,{"$f":"SUM(C323*E323)","v":0}]
[null,"Voetgangersbrug in park (hout)",null,"/ m²",767,{"$f":"SUM(C324*E324)","v":0}]
[null,"Voetgangersbrug in wijk (met tussensteunen)",null,"/ m²",746,{"$f":"SUM(C325*E325)","v":0}]
[null,"Voetgangersbrug in wijk (met tussensteunen)",null,"/ m²",1076,{"$f":"SUM(C326*E326)","v":0}]
[null,"Fiets voetgangersbrug smal, kleine overspanning",null,"/ m²",1358,{"$f":"SUM(C327*E327)","v":0}]
[null,"Fiets voetgangersbrug Breed, kleine overspanning",null,"/ m²",819,{"$f":"SUM(C328*E328)","v":0}]
[null,"Fiets voetgangersbrug over kunstmatig water",null,"/ m²",1093,{"$f":"SUM(C329*E329)","v":0}]
[null,"Wijkbrug klein, overspanning 15 m¹",null,"/ m²",1221,{"$f":"SUM(C330*E330)","v":0}]
[null,"Wijkbrug middel, overspanning 25 m¹",null,"/ m²",1308,{"$f":"SUM(C331*E331)","v":0}]
[null,"Wijkbrug groot, overspanning 35 m¹",null,"/ m²",1759,{"$f":"SUM(C332*E332)","v":0}]
[null,"Betonbrug twee rijbanen, met tussensteun",null,"/ m²",1876,{"$f":"SUM(C333*E333)","v":0}]
[null,"Ophaalbrug langzaam verkeer",null,"/ m²",9730,{"$f":"SUM(C334*E334)","v":0}]
[null,"Ophaalbrug ontsluitingsweg",null,"/ m²",9353,{"$f":"SUM(C335*E335)","v":0}]
[null,"Basculebrug langzaam verkeer",null,"/ m²",12587,{"$f":"SUM(C336*E336)","v":0}]
[null,"Basculebrug ontsluitingsweg",null,"/ m²",9582,{"$f":"SUM(C337*E337)","v":0}]
[null,"Bedieningsgebouw brug",null,"/ m²",5676,{"$f":"SUM(C338*E338)","v":0}]
[null,"GROND-, WEG- EN WATERBOUW TUNNELS"]
[null,"Fietstunnel Bovengronds",null,"/ m²",3459,{"$f":"SUM(C340*E340)","v":0}]
[null,"Fietstunnel Verdiept, dicht deel",null,"/ m²",3972,{"$f":"SUM(C341*E341)","v":0}]
[null,"Fietstunnel Verdiept, open deel",null,"/ m²",2123,{"$f":"SUM(C342*E342)","v":0}]
[null,"Snelverkeer enkele tunnel, 2 rijbanen",null,"/ m²",3605,{"$f":"SUM(C343*E343)","v":0}]
[null,"Snelverkeer dubbele tunnel, 2 rijbanen",null,"/ m²",2381,{"$f":"SUM(C344*E344)","v":0}]
[null,"Enkele tunnelbuis, 2 rijbanen, open bouw",null,"/ m²",5423,{"$f":"SUM(C345*E345)","v":0}]
[null,"Dubbele tunnelbuis, 2 rijbanen, open bouw",null,"/ m²",3535,{"$f":"SUM(C346*E346)","v":0}]
[null,"Dubbele tunnelbuis, diameter 10 m¹",null,"/ m²",4083,{"$f":"SUM(C347*E347)","v":0}]
[null,"Dubbele tunnelbuis, diameter 12 m¹",null,"/ m²",3578,{"$f":"SUM(C348*E348)","v":0}]
[null,"Toerit tunnel 2 rijbanen",null,"/ m²",3019,{"$f":"SUM(C349*E349)","v":0}]
[null,"Toerit tunnel 2 x 2 rijbanen",null,"/ m²",2782,{"$f":"SUM(C350*E350)","v":0}]
[null,"GROND-, WEG- EN WATERBOUW TUNNELS WATERVOORZIENINGEN"]
[null,"duiker rond",null,"/ m²",990,{"$f":"SUM(C352*E352)","v":0}]
[null,"duiker rechthoekig",null,"/ m²",1494,{"$f":"SUM(C353*E353)","v":0}]
[null,"Damwand hardhout",null,"/ m1",411,{"$f":"SUM(C354*E354)","v":0}]
[null,"Damwand staal",null,"/ m1",301,{"$f":"SUM(C355*E355)","v":0}]
[null,"Damwand Kunststof",null,"/ m1",270,{"$f":"SUM(C356*E356)","v":0}]
[null,"Damwand betonopzetter",null,"/ m1",550,{"$f":"SUM(C357*E357)","v":0}]
[null,"Kademuur met meerpalen",null,"/ m²",351,{"$f":"SUM(C358*E358)","v":0}]
[null,"Steiger <1,4 breed",null,"/ m1",496,{"$f":"SUM(C359*E359)","v":0}]
[null,"Steiger >1,4 breed",null,"/ m2",516,{"$f":"SUM(C360*E360)","v":0}]

{"sheet":"Rekenblad leges","index":1,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,"Vast tarief","Tarief "]
[null,0,5000,195,1,1.69]
[null,5000,25000,195,17.03]
[null,25000,50000,876.2,14.85]
[null,50000,100000,1618.7,13.19]
[null,100000,250000,2937.7,11.64]
[null,250000,10000000,6429.7,5.94]
[null,10000000,null,"122,259,70",1.36]
[]
[]
["Berekende bouwkosten",{"$f":"Rekenblad!F9","v":137400},"Maatgevende bouwkosten",{"$f":"IF(B14>=B13,B14,B12)","v":137400}]
["10 % onder berekende bouwkosten",{"$f":"Rekenblad!F10","v":123660}," Leges volgens maatgevende bouwkosten",{"$f":"IF(AND(D12>=B3,D12<C3),D3*E3,IF(AND(D12>=B4,D12<C4),D4+(((D12-B4)/500)*E4),IF(AND(D12>=B5,D12<C5),D5+(((D12-B5)/500)*E5),IF(AND(D12>=B6,D12<C6),D6+(((D12-B6)/500)*E6),IF(AND(D12>=B7,D12<C7),D7+(((D12-B7)/500)*E7),IF(AND(D12>=B8,D12<C8),D8+(((D12-B8)/500)*E8),IF(AND(D12>=B9),D9+(((D12-B9)/500)*E9),\"\")))))))","v":3808.3719999999998}]
["Opgegeven bouwkosten",{"$f":"Rekenblad!F11","v":0},"Leges volgens opgegeven bouwkosten",{"$f":"IF(AND(B14>=B3,B14<C3),D3*E3,IF(AND(B14>=B4,B14<C4),D4+((D28/500)*E4),IF(AND(B14>=B5,B14<C5),D5+((D28/500)*E5),IF(AND(B14>=B6,B14<C6),D6+((D28/500)*E6),IF(AND(B14>=B7,B14<C7),D7+((D28/500)*E7),IF(AND(B14>=B8,B14<C8),D8+((D28/500)*E8),IF(AND(B14>=B9),D9+((D28/500)*E9),\"\")))))))","v":195}]
[]
[]
[null,null,"Bouwkosten Welstand afronding",{"$f":"CEILING(D12,500)","v":137500}]
[null,null,"Leges Welstand",{"$f":"IF(D17>2227000,2300,IF(D17>750000,INT(1143+(((D17-750000)/10000)*7.8)),IF(D17>250000,INT(573+(((D17-250000)/10000)*11.4)),IF(D17>100000,INT(258+(((D17-100000)/10000)*21)),IF(D17>25000,INT(93+(((D17-25000)/10000)*22)),IF(D17>5000,INT(45+(((D17-5000)/10000)*24)),43))))))","v":336}]
[]
[]
[null,null,null,{"$f":"IF(AND(D12>=B3,D12<C3),D3,IF(AND(D12>=B4,D12<C4),(D12-B4),IF(AND(D12>=B5,D12<C5),(D12-B5),IF(AND(D12>=B6,D12<C6),(D12-B6),IF(AND(D12>=B7,D12<C7),(D12-B7),IF(AND(D12>=B8,D12<C8),(D12-B8),IF(AND(D12>=B9),(D12-B9),\"\")))))))","v":37400},{"$f":"SUM(D12-B8)","v":-112600},{"$f":"SUM(D21-E21)","v":150000}]
[null,null,"berekening tarief bouwkosten afg naar boven € 500",{"$f":"CEILING(D21,500)","v":37500}]
[]
[null,null," Leges volgens maatgevende bouwkosten",{"$f":"IF(AND(D12>=B3,D12<C3),D3*E3,IF(AND(D12>=B4,D12<C4),D4+((D22/500)*E4),IF(AND(D12>=B5,D12<C5),D5+((D22/500)*E5),IF(AND(D12>=B6,D12<C6),D6+((D22/500)*E6),IF(AND(D12>=B7,D12<C7),D7+((D22/500)*E7),IF(AND(D12>=B8,D12<C8),D8+((D22/500)*E8),IF(AND(D12>=B9),D9+((D22/500)*E9),\"\")))))))","v":3810.7}]
[null,null,null,{"$f":"SUM(D24-D13)","v":2.3279999999999745}]
[]
[null,null,"Berekening tarief opgegeven bouwkosten ",{"$f":"IF(AND(B14>=B3,B14<C3),D3,IF(AND(B14>=B4,B14<C4),(B14-B4),IF(AND(B14>=B5,B14<C5),(B14-B5),IF(AND(B14>=B6,B14<C6),(B14-B6),IF(AND(B14>=B7,B14<C7),(B14-B7),IF(AND(B14>=B8,B14<C8),(B14-B8),IF(AND(B14>=B9),(B14-B9),\"\")))))))","v":195}]
[null,null,"opgegeven bouwkosten afgerond op € 500,--",{"$f":"CEILING(D27,500)","v":500}]