handleiding_nieuw:sub_spacematrix
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
handleiding_nieuw:sub_spacematrix [2025/05/07 09:43] – support | handleiding_nieuw:sub_spacematrix [2025/05/19 10:26] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 2: | Line 2: | ||
<html lang=" | <html lang=" | ||
< | < | ||
+ | <script src=" | ||
+ | <script src=" | ||
+ | <script src=" | ||
<meta charset=" | <meta charset=" | ||
- | < | + | < |
< | < | ||
body { font-family: | body { font-family: | ||
Line 22: | Line 25: | ||
.stipje { position: absolute; width: 14px; height: 14px; background: red; border-radius: | .stipje { position: absolute; width: 14px; height: 14px; background: red; border-radius: | ||
</ | </ | ||
+ | <script src=" | ||
</ | </ | ||
< | < | ||
Line 29: | Line 33: | ||
<div class=" | <div class=" | ||
<div class=" | <div class=" | ||
+ | <div class=" | ||
+ | <div class=" | ||
</ | </ | ||
<div id=" | <div id=" | ||
- | <div style=" | + | < |
- | <div style=" | + | < |
- | <div class=" | + | <div class=" |
- | <label for=" | + | <label for=" |
- | <input id=" | + | <input id=" |
- | </ | + | </ |
- | <div class=" | + | <div class=" |
- | <label for=" | + | <label for=" |
- | <input id=" | + | <input id=" |
- | </ | + | </ |
- | <div class=" | + | <div class=" |
- | <label for=" | + | <label for=" |
- | <input id=" | + | <input id=" |
- | </ | + | </ |
- | <div class=" | + | <div class=" |
- | < | + | < |
- | <input id="voorzieningenruimte" | + | <span id="voorzieningenruimte_display">-</span> |
- | | + | <input type="hidden" id="voorzieningenruimte_waarde" |
- | + | | |
- | | + | </ |
- | < | + | <div class=" |
- | < | + | |
- | </ | + | |
- | <tbody id="woningtypes"></ | + | |
- | < | + | |
- | < | + | |
- | | + | |
- | </ | + | |
- | + | ||
- | | + | |
- | <div class=" | + | |
<img src=" | <img src=" | ||
<div class=" | <div class=" | ||
</ | </ | ||
- | </ | ||
</ | </ | ||
- | < | + | < |
- | <div id=" | + | |
- | < | + | |
< | < | ||
- | < | + | |
- | | + | |
- | | + | </thead> |
- | < | + | |
- | | + | |
+ | < | ||
+ | </tfoot> | ||
</ | </ | ||
+ | |||
+ | <div style=" | ||
+ | < | ||
+ | Dit komt doordat het aantal woningen iteratief wordt bepaald op basis van de beschikbare ruimte, inclusief ruimte voor voorzieningen en parkeren. | ||
+ | Bij het toepassen van voorzieningen wordt eerst een schatting gemaakt op basis van een voorlopig aantal woningen. Daarna wordt het aantal woningen opnieuw berekend met de benodigde ruimte per woning. | ||
+ | Hierdoor ontstaat een klein verschil tussen het oorspronkelijk berekende totaal en de daadwerkelijk ingepaste voorzieningenruimte. | ||
+ | </ | ||
+ | |||
+ | <div id=" | ||
+ | <div id=" | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | |||
+ | < | ||
+ | <td colspan=" | ||
+ | Kengetallen | ||
+ | </td> | ||
+ | </tr> | ||
+ | |||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | </ | ||
</ | </ | ||
+ | | ||
+ | <div style=" | ||
+ | <button onclick=" | ||
+ | 📄 Kickstart Dump downloaden | ||
+ | </ | ||
+ | </ | ||
+ | | ||
</ | </ | ||
Line 94: | Line 126: | ||
</ | </ | ||
<div class=" | <div class=" | ||
- | <button onclick=" | + | < |
- | <div id=" | + | <div id=" |
</ | </ | ||
+ | < | ||
+ | <table id=" | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | <tbody id=" | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | </ | ||
+ | |||
+ | |||
+ | <div style=" | ||
+ | < | ||
+ | Nadat dit oppervlak per woning is berekend, wordt het aantal woningen in het rekenblok opnieuw doorgerekend. Hierdoor kan het werkelijke totaal afwijken. | ||
+ | Deze iteratieve aanpak is nodig omdat de benodigde ruimte per woning invloed heeft op hoeveel woningen uiteindelijk in het plan passen. | ||
+ | </ | ||
+ | </ | ||
+ | |||
+ | <div id=" | ||
+ | < | ||
+ | <div class=" | ||
+ | < | ||
+ | <input id=" | ||
+ | </ | ||
+ | <div class=" | ||
+ | < | ||
+ | <input id=" | ||
+ | </ | ||
+ | <div class=" | ||
+ | < | ||
+ | <input id=" | ||
+ | </ | ||
+ | <div class=" | ||
+ | < | ||
+ | <input id=" | ||
+ | </ | ||
+ | <div class=" | ||
+ | <button id=" | ||
+ | <div id=" | ||
+ | </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | </ | ||
+ | </ | ||
+ | |||
+ | <div id=" | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | <select id=" | ||
+ | <option value=" | ||
+ | <option value=" | ||
+ | <option value=" | ||
+ | <option value=" | ||
+ | </ | ||
+ | < | ||
+ | <tr> | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </tr> | ||
+ | </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | </ | ||
+ | <p style=" | ||
+ | <div id=" | ||
+ | <canvas id=" | ||
</ | </ | ||
Line 146: | Line 264: | ||
function updateSummary(bvoTot, | function updateSummary(bvoTot, | ||
- | document.getElementById(" | + | |
+ | const pp_bvo = parseFloat(document.getElementById(" | ||
+ | const pp_bovengronds = parseFloat(document.getElementById(" | ||
+ | const parkerenruimtePerWoning = pp * pp_bvo * (pp_bovengronds / 100); | ||
+ | const parkerenTot = woningen * parkerenruimtePerWoning; | ||
+ | |||
+ | const wonenBVO = bvoTot - voorzTot - parkerenTot; | ||
+ | const parkeerplaatsenTotaal = woningen * pp; | ||
+ | |||
+ | document.getElementById(" | ||
+ | document.getElementById(" | ||
document.getElementById(" | document.getElementById(" | ||
+ | document.getElementById(" | ||
+ | |||
document.getElementById(" | document.getElementById(" | ||
+ | document.getElementById(" | ||
+ | document.getElementById(" | ||
+ | |||
document.getElementById(" | document.getElementById(" | ||
document.getElementById(" | document.getElementById(" | ||
Line 158: | Line 291: | ||
const gsi = parseFloat(document.getElementById(" | const gsi = parseFloat(document.getElementById(" | ||
const bvoTot = opp * fsi; | const bvoTot = opp * fsi; | ||
- | const voorzieningenruimte = parseFloat(document.getElementById(" | + | const voorzieningenruimte = parseFloat(document.getElementById(" |
+ | |||
+ | // Nieuw: parkeerinput ophalen | ||
+ | const pp = parseFloat(document.getElementById(" | ||
+ | const pp_bvo = parseFloat(document.getElementById(" | ||
+ | const pp_bovengronds = parseFloat(document.getElementById(" | ||
+ | const parkerenruimte = pp * pp_bvo * (pp_bovengronds / 100); | ||
updateStipje(fsi, | updateStipje(fsi, | ||
Line 174: | Line 313: | ||
if (gewogenBVO === 0) return; | if (gewogenBVO === 0) return; | ||
- | let woningen = Math.floor(bvoTot / (gewogenBVO + voorzieningenruimte)); | + | |
+ | | ||
let sumWon = 0; | let sumWon = 0; | ||
let sumBVO = 0; | let sumBVO = 0; | ||
Line 192: | Line 332: | ||
wonPerType[decimaalSort[j].i]++; | wonPerType[decimaalSort[j].i]++; | ||
} | } | ||
+ | |||
for (let i = 0; i < details.length; | for (let i = 0; i < details.length; | ||
const aant = wonPerType[i]; | const aant = wonPerType[i]; | ||
Line 200: | Line 341: | ||
sumBVO += bvoTot; | sumBVO += bvoTot; | ||
} | } | ||
+ | |||
document.getElementById(" | document.getElementById(" | ||
document.getElementById(" | document.getElementById(" | ||
Line 209: | Line 351: | ||
const voorzieningenTot = sumWon * voorzieningenruimte; | const voorzieningenTot = sumWon * voorzieningenruimte; | ||
- | const wonenRuimte = bvoTot - voorzieningenTot; | + | const wonenRuimte = bvoTot - voorzieningenTot |
updateSummary(bvoTot, | updateSummary(bvoTot, | ||
+ | |||
+ | // Extra update voor parkeren per woning | ||
+ | document.getElementById(" | ||
} | } | ||
Line 227: | Line 372: | ||
function berekenVoorzieningenruimte() { | function berekenVoorzieningenruimte() { | ||
+ | updateLaadvermogen(); | ||
+ | |||
const bewonersPerWoning = parseFloat(document.getElementById(" | const bewonersPerWoning = parseFloat(document.getElementById(" | ||
const woningen = parseFloat(document.getElementById(" | const woningen = parseFloat(document.getElementById(" | ||
const totaalBewoners = woningen * bewonersPerWoning; | const totaalBewoners = woningen * bewonersPerWoning; | ||
+ | |||
+ | const resultDiv = document.getElementById(" | ||
+ | const btn = document.getElementById(" | ||
+ | |||
+ | if (woningen === 0) { | ||
+ | resultDiv.innerHTML = `<span style=" | ||
+ | btn.style.border = "1px solid #a00"; | ||
+ | btn.style.background = "# | ||
+ | return; | ||
+ | } | ||
let totaal_m2 = 0; | let totaal_m2 = 0; | ||
Line 238: | Line 395: | ||
} | } | ||
}); | }); | ||
- | | + | |
- | document.getElementById(" | + | |
- | `<b> | + | |
- | document.getElementById(" | + | document.getElementById(" |
+ | | ||
+ | |||
+ | resultDiv.innerHTML = `<span style=" | ||
+ | | ||
+ | btn.style.background = "# | ||
+ | |||
+ | updateLaadvermogen(); | ||
+ | |||
+ | // Toon tabel met voorzieningen en m2 | ||
+ | const summaryBody = document.getElementById(" | ||
+ | const summaryTotal = document.getElementById(" | ||
+ | summaryBody.innerHTML = ""; | ||
+ | let subtotal = 0; | ||
+ | |||
+ | voorzieningen.forEach((v, | ||
+ | const checked = document.getElementById(`vchk_${i}`).checked; | ||
+ | if (checked) { | ||
+ | const v_m2 = v.norm * totaalBewoners / 1000; | ||
+ | subtotal += v_m2; | ||
+ | const row = document.createElement(" | ||
+ | row.innerHTML = `< | ||
+ | summaryBody.appendChild(row); | ||
+ | } | ||
+ | }); | ||
+ | summaryTotal.innerText = `${subtotal.toFixed(1)} m²`; | ||
+ | |||
+ | } | ||
+ | |||
+ | function berekenParkeerruimte() { | ||
+ | const pp = parseFloat(document.getElementById(" | ||
+ | const bvo_per_pp | ||
+ | const bovengronds = parseFloat(document.getElementById(" | ||
+ | const woningen = parseFloat(document.getElementById(" | ||
+ | |||
+ | const ruimte_per_woning = pp * bvo_per_pp * (bovengronds / 100); | ||
+ | const totaal_ruimte = ruimte_per_woning * woningen; | ||
+ | |||
+ | // Toon het resultaat en vinkje | ||
+ | const resultDiv = document.getElementById(" | ||
+ | resultDiv.innerHTML = `<span style=" | ||
+ | |||
+ | // Visuele feedback op de knop | ||
+ | const btn = document.getElementById(" | ||
+ | btn.style.border = "1px solid # | ||
+ | btn.style.background = "# | ||
+ | |||
+ | // Update berekening | ||
updateLaadvermogen(); | updateLaadvermogen(); | ||
+ | |||
+ | const totaal_pp = woningen * pp; | ||
+ | const pp_boven_aantal = totaal_pp * (bovengronds / 100); | ||
+ | const ondergronds = parseFloat(document.getElementById(" | ||
+ | const pp_onder_aantal = totaal_pp * (ondergronds / 100); | ||
+ | |||
+ | document.getElementById(" | ||
+ | document.getElementById(" | ||
+ | document.getElementById(" | ||
+ | |||
} | } | ||
+ | |||
+ | function updateOpenbareRuimte() { | ||
+ | const opp = parseFloat(document.getElementById(" | ||
+ | const gsi = parseFloat(document.getElementById(" | ||
+ | const bebouwd = opp * gsi; | ||
+ | const onbebouwd = opp - bebouwd; | ||
+ | |||
+ | const types = [ | ||
+ | { id: " | ||
+ | { id: " | ||
+ | { id: " | ||
+ | { id: " | ||
+ | { id: " | ||
+ | { id: " | ||
+ | { id: " | ||
+ | ]; | ||
+ | |||
+ | let totaal = 0; | ||
+ | types.forEach(type => { | ||
+ | const perc = parseFloat(document.getElementById(`perc_${type.id}`).value) || 0; | ||
+ | totaal += perc; | ||
+ | }); | ||
+ | |||
+ | if (totaal !== 100) { | ||
+ | document.getElementById(" | ||
+ | return; | ||
+ | } else { | ||
+ | document.getElementById(" | ||
+ | } | ||
+ | |||
+ | types.forEach(type => { | ||
+ | const perc = parseFloat(document.getElementById(`perc_${type.id}`).value) || 0; | ||
+ | const m2 = (perc / 100) * onbebouwd; | ||
+ | document.getElementById(`m2_${type.id}`).innerText = `${m2.toFixed(0)} m²`; | ||
+ | }); | ||
+ | } | ||
+ | |||
+ | let openbareRuimteChart = null; | ||
+ | |||
+ | function updateOpenbareRuimte() { | ||
+ | const opp = parseFloat(document.getElementById(" | ||
+ | const gsi = parseFloat(document.getElementById(" | ||
+ | const bebouwd = opp * gsi; | ||
+ | const onbebouwd = opp - bebouwd; | ||
+ | |||
+ | const types = [ | ||
+ | { id: " | ||
+ | { id: " | ||
+ | { id: " | ||
+ | { id: " | ||
+ | { id: " | ||
+ | { id: " | ||
+ | { id: " | ||
+ | ]; | ||
+ | |||
+ | let totaal = 0; | ||
+ | let data = []; | ||
+ | |||
+ | types.forEach(type => { | ||
+ | const perc = parseFloat(document.getElementById(`perc_${type.id}`).value) || 0; | ||
+ | totaal += perc; | ||
+ | }); | ||
+ | |||
+ | if (totaal !== 100) { | ||
+ | document.getElementById(" | ||
+ | document.getElementById(" | ||
+ | return; | ||
+ | } else { | ||
+ | document.getElementById(" | ||
+ | } | ||
+ | |||
+ | // Bereken oppervlak per type en vul tabel | ||
+ | types.forEach(type => { | ||
+ | const perc = parseFloat(document.getElementById(`perc_${type.id}`).value) || 0; | ||
+ | const m2 = (perc / 100) * onbebouwd; | ||
+ | document.getElementById(`m2_${type.id}`).innerText = `${m2.toFixed(0)} m²`; | ||
+ | data.push({ label: type.label, value: m2 }); | ||
+ | }); | ||
+ | |||
+ | // Totaal m² | ||
+ | const totaal_m2 = data.reduce((sum, | ||
+ | document.getElementById(" | ||
+ | |||
+ | // Vergelijking met onbebouwd oppervlak | ||
+ | const verschil = Math.abs(totaal_m2 - onbebouwd); | ||
+ | const totaalCell = document.getElementById(" | ||
+ | if (verschil > 1) { | ||
+ | totaalCell.style.color = " | ||
+ | totaalCell.title = `Let op: verschil van ${verschil.toFixed(1)} m² met onbebouwde ruimte`; | ||
+ | } else { | ||
+ | totaalCell.style.color = ""; | ||
+ | totaalCell.title = ""; | ||
+ | } | ||
+ | |||
+ | // Chart.js bijwerken | ||
+ | const ctx = document.getElementById(" | ||
+ | const labels = data.map(d => d.label); | ||
+ | const values = data.map(d => d.value); | ||
+ | |||
+ | if (openbareRuimteChart) { | ||
+ | openbareRuimteChart.data.labels = labels; | ||
+ | openbareRuimteChart.data.datasets[0].data = values; | ||
+ | openbareRuimteChart.update(); | ||
+ | } else { | ||
+ | openbareRuimteChart = new Chart(ctx, { | ||
+ | type: ' | ||
+ | data: { | ||
+ | labels: labels, | ||
+ | datasets: [{ | ||
+ | data: values, | ||
+ | backgroundColor: | ||
+ | '# | ||
+ | '# | ||
+ | ] | ||
+ | }] | ||
+ | }, | ||
+ | options: { | ||
+ | plugins: { | ||
+ | legend: { position: ' | ||
+ | title: { | ||
+ | display: true, | ||
+ | text: ' | ||
+ | } | ||
+ | } | ||
+ | } | ||
+ | }); | ||
+ | } | ||
+ | } | ||
+ | |||
+ | |||
+ | function setVerdelingStedelijkheid() { | ||
+ | const type = document.getElementById(" | ||
+ | let waarden = {}; | ||
+ | |||
+ | if (type === " | ||
+ | waarden = { groen: 18, water: 4, tuinen: 8, rijbanen: 25, trottoirs: 20, parkeren: 10, pleinen: 15 }; | ||
+ | } else if (type === " | ||
+ | waarden = { groen: 20, water: 10, tuinen: 10, rijbanen: 20, trottoirs: 15, parkeren: 15, pleinen: 10 }; | ||
+ | } else if (type === " | ||
+ | waarden = { groen: 30, water: 15, tuinen: 25, rijbanen: 15, trottoirs: 8, parkeren: 5, pleinen: 2 }; | ||
+ | } else { | ||
+ | updateOpenbareRuimte(); | ||
+ | return; | ||
+ | } | ||
+ | |||
+ | Object.keys(waarden).forEach(id => { | ||
+ | document.getElementById(`perc_${id}`).value = waarden[id]; | ||
+ | }); | ||
+ | |||
+ | updateOpenbareRuimte(); | ||
+ | } | ||
+ | |||
+ | // 👇 Bouw de volledige woningtype + parkeren-tabel met eerste kolom labels, geschikt voor Kladblok | ||
+ | function buildWoningtypesTableTXT() { | ||
+ | const types = ["egw sociaal", | ||
+ | " | ||
+ | const parkeerkolommen = [" | ||
+ | const kolommen = [...types, ...parkeerkolommen]; | ||
+ | const colWidth = 13; | ||
+ | const labelWidth = 18; | ||
+ | |||
+ | const pad = (val) => val.toString().padStart(colWidth); | ||
+ | const head = (val) => val.toString().padEnd(colWidth); | ||
+ | const label = (txt) => `| ${txt}`.padEnd(labelWidth); | ||
+ | |||
+ | // DATA per woningtype (alleen types, dus zonder parkeren) | ||
+ | const perc = types.map((_, | ||
+ | const bvo = types.map((_, | ||
+ | const aantallen = types.map((_, | ||
+ | const vormfactor = types.map((_, | ||
+ | const bvo_tot = bvo.map((b, i) => b * aantallen[i]); | ||
+ | const gbo = bvo.map((b, i) => (b * vormfactor[i]).toFixed(1)); | ||
+ | |||
+ | // PARKEERREGELS berekenen | ||
+ | const pp = parseFloat(document.getElementById(" | ||
+ | const woningen = aantallen.reduce((acc, | ||
+ | const bvo_pp = parseFloat(document.getElementById(" | ||
+ | const perc_boven = parseFloat(document.getElementById(" | ||
+ | const perc_onder = parseFloat(document.getElementById(" | ||
+ | const pp_boven = Math.round(woningen * pp * (perc_boven / 100)); | ||
+ | const pp_onder = Math.round(woningen * pp * (perc_onder / 100)); | ||
+ | const bvo_boven = pp_boven * bvo_pp; | ||
+ | const bvo_onder = pp_onder * bvo_pp; | ||
+ | |||
+ | // PARKEERGEGEVENS toevoegen | ||
+ | perc.push(" | ||
+ | bvo.push(bvo_pp, | ||
+ | aantallen.push(pp_boven, | ||
+ | bvo_tot.push(bvo_boven, | ||
+ | vormfactor.push(1.00, | ||
+ | gbo.push((bvo_pp * 1.00).toFixed(1), | ||
+ | |||
+ | // TABEL opbouwen | ||
+ | const r = []; | ||
+ | r.push(label(" | ||
+ | r.push("" | ||
+ | r.push(label(" | ||
+ | r.push(label(" | ||
+ | r.push(label(" | ||
+ | r.push(label(" | ||
+ | r.push(label(" | ||
+ | r.push(label(" | ||
+ | |||
+ | // GEMIDDELDES (alleen woningtypes, | ||
+ | const woningtypes = [...Array(10).keys()]; | ||
+ | const totale_bvo = woningtypes.reduce((sum, | ||
+ | const totale_gbo = woningtypes.reduce((sum, | ||
+ | const totaal_woningen = woningtypes.reduce((sum, | ||
+ | |||
+ | const gemiddelde_bvo = totaal_woningen > 0 ? (totale_bvo / totaal_woningen).toFixed(1) : " | ||
+ | const gemiddelde_gbo = totaal_woningen > 0 ? (totale_gbo / totaal_woningen).toFixed(1) : " | ||
+ | |||
+ | r.push("" | ||
+ | r.push(`Totale aantal woningen: ${totaal_woningen}`); | ||
+ | r.push(`Gemiddelde BVO per woning: ${gemiddelde_bvo}`); | ||
+ | r.push(`Gemiddelde GBO per woning: ${gemiddelde_gbo}`); | ||
+ | |||
+ | return r.join(" | ||
+ | } | ||
+ | |||
+ | async function downloadKickstartDump() { | ||
+ | console.log(" | ||
+ | |||
+ | try { | ||
+ | const response = await fetch(' | ||
+ | if (!response.ok) throw new Error(`Bestand niet bereikbaar (${response.status})`); | ||
+ | |||
+ | let template = await response.text(); | ||
+ | console.log(" | ||
+ | |||
+ | const bvo_per_pp = parseFloat(document.getElementById(" | ||
+ | const pp_bovengronds = parseFloat(document.getElementById(" | ||
+ | const pp_ondergronds = parseFloat(document.getElementById(" | ||
+ | const woningen = parseFloat(document.getElementById(" | ||
+ | const pp = parseFloat(document.getElementById(" | ||
+ | |||
+ | const bvo_per_pp_boven = bvo_per_pp.toFixed(1); | ||
+ | const bvo_per_pp_onder = bvo_per_pp.toFixed(1); | ||
+ | |||
+ | const parkeeropp_totaal = woningen * pp * bvo_per_pp; | ||
+ | const parkeeropp_boven = parkeeropp_totaal * (pp_bovengronds / 100); | ||
+ | const parkeeropp_onder = parkeeropp_totaal * (pp_ondergronds / 100); | ||
+ | |||
+ | const data = { | ||
+ | datum: new Date().toISOString().slice(0, | ||
+ | aantal_woningen: | ||
+ | bvo_per_woning: | ||
+ | pp_boven: document.getElementById(" | ||
+ | pp_onder: document.getElementById(" | ||
+ | bvo_boven: document.getElementById(" | ||
+ | bvo_onder: " | ||
+ | bvo_per_pp_boven: | ||
+ | bvo_per_pp_onder: | ||
+ | totbvo_boven: | ||
+ | totbvo_onder: | ||
+ | woningtypes_table: | ||
+ | voorzieningen_table: | ||
+ | plankaart_table: | ||
+ | grex_table: buildGrexTableTXT() | ||
+ | }; | ||
+ | |||
+ | for (let i = 0; i < 10; i++) { | ||
+ | data[`perc_${i}`] = document.getElementById(`perc_${i}`)? | ||
+ | data[`bvo_${i}`] = document.getElementById(`bvo_${i}`)? | ||
+ | data[`aantal_${i}`] = document.getElementById(`aantal_${i}`)? | ||
+ | data[`totbvo_${i}`] = document.getElementById(`totbvo_${i}`)? | ||
+ | } | ||
+ | |||
+ | Object.entries(data).forEach(([key, | ||
+ | template = template.replaceAll(`{{${key}}}`, | ||
+ | }); | ||
+ | |||
+ | const blob = new Blob([template], | ||
+ | saveAs(blob, | ||
+ | alert(" | ||
+ | } catch (error) { | ||
+ | console.error(" | ||
+ | alert(" | ||
+ | } | ||
+ | } | ||
+ | |||
+ | function buildVoorzieningenTableTXT() { | ||
+ | let output = ""; | ||
+ | const rows = document.querySelectorAll("# | ||
+ | rows.forEach(row => { | ||
+ | const cells = row.querySelectorAll(" | ||
+ | if (cells.length === 2) { | ||
+ | const naam = cells[0].innerText.trim(); | ||
+ | const m2 = cells[1].innerText.trim(); | ||
+ | output += `| ${naam.padEnd(25)} | ${m2.padStart(14)} |\n`; | ||
+ | } | ||
+ | }); | ||
+ | return output || "| Geen voorzieningen geselecteerd | – |"; | ||
+ | } | ||
+ | |||
+ | function buildPlankaartTableTXT() { | ||
+ | const opp = parseFloat(document.getElementById(" | ||
+ | const gsi = parseFloat(document.getElementById(" | ||
+ | const footprint = gsi * opp; | ||
+ | const tuin = getVal(" | ||
+ | const uitgeefbaar = tuin + footprint; | ||
+ | |||
+ | return `Omschrijving | ||
+ | ----------------------------|---------------- | ||
+ | Totaal bruto plangebied | ||
+ | ----------------------------|---------------- | ||
+ | Tuinen | ||
+ | Footprint (GSI x opp) | ${footprint.toFixed(0)} | ||
+ | ----------------------------|---------------- | ||
+ | Totaal uitgeefbaar | ||
+ | Rijbanen | ||
+ | Trottoirs | ||
+ | Parkeren (bovengr.) | ||
+ | Pleinen | ||
+ | ----------------------------|---------------- | ||
+ | Totaal verharding | ||
+ | Groen | ${getVal(" | ||
+ | Water | ${getVal(" | ||
+ | } | ||
+ | |||
+ | function buildGrexTableTXT() { | ||
+ | return `Categorie | ||
+ | --------------------|----------------------------------------|---------------- | ||
+ | Verwerving | ||
+ | Grondwerk | ||
+ | Bouwrijp maken | Bouwstraten | ||
+ | Woonrijp maken | Rijbanen | ||
+ | Woonrijp maken | Trottoirs | ||
+ | Woonrijp maken | Parkeren | ||
+ | Woonrijp maken | Pleinen | ||
+ | Woonrijp maken | Groen | ${getVal(" | ||
+ | Woonrijp maken | Bomen en groenstructuur | ||
+ | Woonrijp maken | Verdere aankleding openbare ruimte | ||
+ | Nazorg | ||
+ | Onvoorzien | ||
+ | } | ||
+ | |||
+ | function getVal(id) { | ||
+ | const el = document.getElementById(id); | ||
+ | return el ? parseFloat(el.innerText.replace(" | ||
+ | } | ||
+ | |||
+ | |||
window.onload = () => { | window.onload = () => { | ||
Line 254: | Line 811: | ||
</ | </ | ||
</ | </ | ||
- |
handleiding_nieuw/sub_spacematrix.1746611003.txt.gz · Last modified: 2025/05/07 09:43 by support