Public
Edited
Jun 22, 2023
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
viewof maandlastdeel5 = Text({type: "number", label: "Maandlast deel 5 (€)", placeholder: "", width: 100, value: Math.round(maxmaandhyplast - maandlastdeel1 - maandlastdeel2 - maandlastdeel3 - maandlastdeel4)})
Insert cell
viewof hypotheek5 = Inputs.number({label: "Hypotheek 5 (€)", placeholder: "Euros", width: 100, disabled: true, value:12000})
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
calc_fac = function(toetsrentemaand,looptijd){
//volgens: https://www.hypotheekrente-annuiteitenhypotheek.nl/annuiteit-berekenen.php
//return (toetsrentemaand / (1 - ( Math.pow( (1 +toetsrentemaand), -(12*looptijd) ))));
return ( toetsrentemaand / 100 ) *
( Math.pow( toetsrentemaand/100 + 1, looptijd ) /
( Math.pow( toetsrentemaand/100 + 1, looptijd ) - 1 ) )
}
Insert cell
Insert cell
rates = FileAttachment('rates.json').json()
Insert cell
obviondata = FileAttachment("bijbouwe_rates_clean.tsv").tsv()
Insert cell
keys = Object.keys(obviondata[0]).filter(d=>d!='jaren' && d!='NHG' && d!='>106');
Insert cell
Insert cell
obvionjaren = [...new Set(df_obvion.map(d=>parseInt(d.jaren)))];
Insert cell
financieringslastperc = df.filter(d=>d.inkomen < toetsinkomen && d.rente > toetsrente -0.5 && d.rente <= toetsrente).sort(d=>d.inkomen)[0].percentage
Insert cell
financieringslastpercentages = FileAttachment("finlastpercent_clean@1.tsv").tsv()
Insert cell
Insert cell
Insert cell
Insert cell
d3 = require("d3-format@3")
Insert cell
locale = d3.formatLocale({
decimal: ",",
thousands: "\u00a0",
grouping: [3],
currency: ["", "\u00a0€"],
minus: "\u2212",
percent: "\u202f%"
})
Insert cell
fformat = locale.format("$,")
Insert cell
import {vl} from '@vega/vega-lite-api-v5'
Insert cell
import {printTable} from '@uwdata/data-utilities'
Insert cell
dfd = require('danfojs@0.0.15/dist/index.min.js').catch(() => {
window.dfd.Series.prototype.print = window.dfd.DataFrame.prototype.print = function() { return print(this) };
return window.dfd;
})
Insert cell

Purpose-built for displays of data

Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Learn more