{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Disclaimer","Superformule","Info BD","Evaluatie","TBV Onderzoek","BPK-Grafiek","HULP-velden","DATA","HULP-data"],"not_rendered":{"charts":4,"images":11,"macros":1,"external_links":0,"defined_names":57,"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":"Disclaimer","index":0,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,3,1]]}
[]
[null,"Disclaimer"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null," "]
[]
[null,null,"© 2012-2023"]
[null,null,"IUC - Belastingdienst"]

{"sheet":"Superformule","index":1,"n_rows":32,"n_cols":23,"rows_kept":32,"cut":false,"hidden":false,"merged":[[5,10,5,11],[6,10,6,11],[1,1,3,2],[10,4,10,6],[11,4,11,6],[5,6,5,7],[6,6,6,7],[10,3,12,3],[19,4,19,8],[9,4,9,8],[13,4,13,6],[14,4,14,8],[20,4,20,8],[12,4,12,6],[18,4,18,8],[15,4,15,6]]}
[]
[null,"Uitgangspunten Superformule"]
[null,null,null,null,"= invoervelden",null,null,null,null,null," "]
[]
[]
[null,null,null,null,"Naam inkooptraject",null,null,null,null,null,"Even geduld a.u.b."]
[null,null,null," ","Kenmerk",null,null,null,null,null,"Updaten van grafieken!"]
[]
[null,null,null,null,"Uitgangspunten Superformule"]
[null,null,null,1,"Maximum aantal punten dat aan de WENSEN wordt toegekend",null,null,null,null,null,100,"= Qwensen"]
[null,null,null,2,"Aandeel Qeisen in KWALITEIT (=100%) (Lijn A)",null,null,null,{"$f":"+'HULP-velden'!J73","v":0.6},null,{"$f":"ROUND(IFERROR(Superformule!K10/Superformule!I12*(1-Superformule!I12),0),0)","v":150}," = Qmin"]
[null,null,null,null,"Aandeel Qwensen in KWALITEIT (=100%)",null,null,null,{"$f":"1-I11","v":0.4},null,{"$f":"IFERROR(+K13-K11,0)","v":100},"= Qwensen"]
[null,null,null,null,"Punten voor EISEN en WENSEN (Qtotaal)",null,null,null,{"$f":"SUM(I11:I12)","v":1},null,{"$f":"IFERROR(+K11+Superformule!K10,0)","v":250}," = Qmax"]
[null,null,null,3,"Referentiekwaliteit (Punt B)",null,null,null,{"$f":"+'HULP-velden'!J74","v":0.5},null,{"$f":"IF(Qmin+I14*(Qmax-Qmin)<'HULP-velden'!J70,'HULP-velden'!J70,Qmin+I14*(Qmax-Qmin))","v":200}," = Qref"]
[null,null,null,4,"Referentieprijs (Pref)",null,null,null,null,null,100000," = Pref"]
[null,null,null,5,"Prijs voor maximale kwaliteit (Qmax)  (Punt C)",null,null,null,{"$f":"+'HULP-velden'!J75","v":0.19895788082817978},0.17499999999999999,{"$f":"'HULP-velden'!K75*K15","v":119895.78808281798}," = P (Qmax)"]
[null,null,null,null,null,null,null,"Advieswaarde punt C (dit is de exacte cirkel met n=2)",{"$f":"+'HULP-velden'!L19-1","v":0.19895788082817978}]
[null,null,null,null,null,null,null," Maximale waarde punt C (dit is een lineaire lijn met n=1)",{"$f":"+'HULP-velden'!L20-1","v":0.25}]
[null,null,null,null,"Waarde voor n in Superformule",null,null,null,null,null,{"$f":"IF(ISERROR(ROUND(SOLVERWAARDE,3)),1,ROUND(SOLVERWAARDE,3))","v":2},"= n-waarde"]
[null,null,null,6,"Hoogste verwachte vergelijkingswaarde (hulplijn)"]
[null,null,null,7,"Laagste verwachte vergelijkingswaarde (hulplijn)"]
[null,null,null,8,"Lowest Acceptable Quality (Qeisen + Qknockout)",null,null,null,{"$f":"\">\"&Qmin","v":">150"},null,-1000,"= Qknockout"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Info BD","index":2,"n_rows":32,"n_cols":22,"rows_kept":32,"cut":false,"hidden":false,"merged":[[14,6,14,8],[15,6,15,8],[16,6,16,8],[1,1,3,4],[10,6,10,8],[11,6,11,8],[12,6,12,8],[13,6,13,8],[24,3,24,4],[24,9,25,9],[17,6,17,8],[19,6,19,8],[20,6,20,8],[21,6,21,8],[22,6,22,8]]}
[]
[null,"Info t.b.v. Beschrijvend Document",null,null,null,null,null,null,"Even geduld a.u.b. "]
[null,null,null,null,null,null,null,null,"De teksten voor het inkoopdocument worden gegenereerd!"]
[]
[]
[null,null,null,null,null,null,"Voorbeeldtekst en waarden t.b.v. Beschrijvend Document"]
[]
[]
[]
[null,null,null,null,null,null,"Informatie t.b.v. gele velden in tekst Document",null,null,"Waarde"]
[null,null,null,null,null,null,"Totaal aantal punten",null,null,{"$f":"+Qmax","v":250}]
[null,null,null,null,null,null,"Aantal punten voor de wensen (Qwensen)",null,null,{"$f":"Qwensen","v":100}]
[null,null,null,null,null,null,"Aantal punten voor de eisen (Qeisen)",null,null,{"$f":"Qmin","v":150}]
[null,null,null,null,null,null,"Referentie kwaliteit (Qref)",null,null,{"$f":"Qref","v":200}]
[null,null,null,null,null,null,"Referentie Prijs (Pref)",null,null,{"$f":"Pref","v":100000}]
[null,null,null,null,null,null,"Prijs bij maximale kwaliteit (P bij Qmax)",null,null,{"$f":"Pmax","v":119895.78808281798}]
[null,null,null,null,null,null,"Waarde voor n in Superformule",null,null,{"$f":"Exponent","v":2}]
[null,null,null,null,null,null,"Lowest Acceptable Quality (LAQ = QKnockOut)",null,null,{"$f":"IF(Superformule!$K$22<0,\"n.v.t.\",Superformule!$K$22)","v":"n.v.t."}]
[null,null,null,null,null,null,"Ten behoeve van voorbeeld in Document",null,null,"Waarde"]
[null,null,null,null,null,null,"Winnaar ",null,null,{"$f":"\"Leverancier \" & 'HULP-velden'!I61","v":"Leverancier 4"}]
[null,null,null,null,null,null,"Inschrijfprijs",null,null,{"$f":"VLOOKUP(1,'Info BD'!$A$27:$J$31,5,FALSE)","v":92040}]
[null,null,null,null,null,null,"Kwaliteitscore",null,null,{"$f":"VLOOKUP(1,'Info BD'!$A$27:$J$31,9,FALSE)","v":235}]
[null,null,null,null,null,null,"BPK-Score",null,null,{"$f":"VLOOKUP(1,'Info BD'!$A$27:$J$31,7,FALSE)","v":0.87400262013337238}]
[]
[null,"Legenda voorbeeld inschrijvingen",null," ",null,null,null,null,null,"Totaal\nGenormaliseerd"]
[null,"Inschrijver","Qwenseni","Vrije keuze Qwenseni","Pi","Vrije keuze\nPi","SCOREi","Qmin","Totaal",null,"Rangorde"]
[{"$f":"6-RANK(G27,$G$27:$G$31)","v":5},"1",{"$f":"IF(ISBLANK(D27),'HULP-velden'!G121,D27)","v":65},null,{"$f":"IF(ISBLANK(F27),'HULP-velden'!H121,F27)","v":99010},null,{"$f":"IFERROR((0.5*(E27/Pref)^Exponent+0.5*(2-I27/Qref)^Exponent)^(1/Exponent),0)","v":0.95810307639627168},{"$f":"Qmin","v":150},{"$f":"+H27+C27","v":215},{"$f":"ROUND(I27/Qmax*100,0)","v":86},{"$f":"IF('HULP-velden'!J130=\"KO\",\"KO\",'HULP-velden'!N130)","v":5}]
[{"$f":"6-RANK(G28,$G$27:$G$31)","v":3},"2",{"$f":"IF(ISBLANK(D28),'HULP-velden'!G122,D28)","v":73},null,{"$f":"IF(ISBLANK(F28),'HULP-velden'!H122,F28)","v":92040},null,{"$f":"IFERROR((0.5*(E28/Pref)^Exponent+0.5*(2-I28/Qref)^Exponent)^(1/Exponent),0)","v":0.90287351273586491},{"$f":"Qmin","v":150},{"$f":"+H28+C28","v":223},{"$f":"ROUND(I28/Qmax*100,0)","v":89},{"$f":"IF('HULP-velden'!J131=\"KO\",\"KO\",'HULP-velden'!N131)","v":3}]
[{"$f":"6-RANK(G29,$G$27:$G$31)","v":4},"3",{"$f":"IF(ISBLANK(D29),'HULP-velden'!G123,D29)","v":80},null,{"$f":"IF(ISBLANK(F29),'HULP-velden'!H123,F29)","v":101990},null,{"$f":"IFERROR((0.5*(E29/Pref)^Exponent+0.5*(2-I29/Qref)^Exponent)^(1/Exponent),0)","v":0.93880136610467291},{"$f":"Qmin","v":150},{"$f":"+H29+C29","v":230},{"$f":"ROUND(I29/Qmax*100,0)","v":92},{"$f":"IF('HULP-velden'!J132=\"KO\",\"KO\",'HULP-velden'!N132)","v":4}]
[{"$f":"6-RANK(G30,$G$27:$G$31)","v":1},"4",{"$f":"IF(ISBLANK(D30),'HULP-velden'!G124,D30)","v":85},null,{"$f":"IF(ISBLANK(F30),'HULP-velden'!H124,F30)","v":92040},null,{"$f":"IFERROR((0.5*(E30/Pref)^Exponent+0.5*(2-I30/Qref)^Exponent)^(1/Exponent),0)","v":0.87400262013337238},{"$f":"Qmin","v":150},{"$f":"+H30+C30","v":235},{"$f":"ROUND(I30/Qmax*100,0)","v":94},{"$f":"IF('HULP-velden'!J133=\"KO\",\"KO\",'HULP-velden'!N133)","v":1}]
[{"$f":"6-RANK(G31,$G$27:$G$31)","v":2},"5",{"$f":"IF(ISBLANK(D31),'HULP-velden'!G125,D31)","v":93},null,{"$f":"IF(ISBLANK(F31),'HULP-velden'!H125,F31)","v":100000},null,{"$f":"IFERROR((0.5*(E31/Pref)^Exponent+0.5*(2-I31/Qref)^Exponent)^(1/Exponent),0)","v":0.89895077729539785},{"$f":"Qmin","v":150},{"$f":"+H31+C31","v":243},{"$f":"ROUND(I31/Qmax*100,0)","v":97},{"$f":"IF('HULP-velden'!J134=\"KO\",\"KO\",'HULP-velden'!N134)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Evaluatie","index":3,"n_rows":22,"n_cols":21,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,3,2],[5,9,6,9],[5,13,6,13],[5,12,6,12],[5,11,6,11],[5,7,6,7]]}
[]
[null,{"$f":"\"Evaluatie \"\n& DATA!G46\n& \" \" & DATA!G47","v":"Evaluatie 0 0"}]
[]
[]
[]
[null,null,null,null,"= invoervelden",null,null,"Score \nQwensen",null,"Rang-\norde",null,"Score\nQeisen","Score\nTotaal","Score in procenten"]
[null,null,null,"#","Inschrijver","Qi","Pi",null,"SCOREi"]
[null,null,null,"1",null,{"$f":"+N8","v":""},null,null,{"$f":"IF(ISBLANK(G8),\"\",(0.5*(G8/DATA!$C$12)^DATA!$F$38+0.5*(2-(M8)/DATA!$D$12)^DATA!$F$38)^(1/DATA!$F$38))","v":""},{"$f":"IF('HULP-velden'!K96=\"KO\",\"KO\",'HULP-velden'!O96)","v":""},null,{"$f":"IF(ISBLANK(G8),\"\",DATA!$G$41)","v":""},{"$f":"IFERROR((+H8+L8),\"\")","v":""},{"$f":"IFERROR(((M8/DATA!$G$40)*100),\"\")","v":""}]
[null,null,null,"2",null,"",null,null,{"$f":"IF(ISBLANK(G9),\"\",(0.5*(G9/DATA!$C$12)^DATA!$F$38+0.5*(2-(M9)/DATA!$D$12)^DATA!$F$38)^(1/DATA!$F$38))","v":""},{"$f":"IF('HULP-velden'!K97=\"KO\",\"KO\",'HULP-velden'!O97)","v":""},null,{"$f":"IF(ISBLANK(G9),\"\",DATA!$G$41)","v":""},"",{"$f":"IFERROR(((M9/DATA!$G$40)*100),\"\")","v":""}]
[null,null,null,"3",null,"",null,null,{"$f":"IF(ISBLANK(G10),\"\",(0.5*(G10/DATA!$C$12)^DATA!$F$38+0.5*(2-(M10)/DATA!$D$12)^DATA!$F$38)^(1/DATA!$F$38))","v":""},{"$f":"IF('HULP-velden'!K98=\"KO\",\"KO\",'HULP-velden'!O98)","v":""},null,{"$f":"IF(ISBLANK(G10),\"\",DATA!$G$41)","v":""},"",{"$f":"IFERROR(((M10/DATA!$G$40)*100),\"\")","v":""}]
[null,null,null,"4",null,"",null,null,{"$f":"IF(ISBLANK(G11),\"\",(0.5*(G11/DATA!$C$12)^DATA!$F$38+0.5*(2-(M11)/DATA!$D$12)^DATA!$F$38)^(1/DATA!$F$38))","v":""},{"$f":"IF('HULP-velden'!K99=\"KO\",\"KO\",'HULP-velden'!O99)","v":""},null,{"$f":"IF(ISBLANK(G11),\"\",DATA!$G$41)","v":""},"",{"$f":"IFERROR(((M11/DATA!$G$40)*100),\"\")","v":""}]
[null,null,null,"5",null,"",null,null,{"$f":"IF(ISBLANK(G12),\"\",(0.5*(G12/DATA!$C$12)^DATA!$F$38+0.5*(2-(M12)/DATA!$D$12)^DATA!$F$38)^(1/DATA!$F$38))","v":""},{"$f":"IF('HULP-velden'!K100=\"KO\",\"KO\",'HULP-velden'!O100)","v":""},null,{"$f":"IF(ISBLANK(G12),\"\",DATA!$G$41)","v":""},"",{"$f":"IFERROR(((M12/DATA!$G$40)*100),\"\")","v":""}]
[null,null,null,"6",null,"",null,null,{"$f":"IF(ISBLANK(G13),\"\",(0.5*(G13/DATA!$C$12)^DATA!$F$38+0.5*(2-(M13)/DATA!$D$12)^DATA!$F$38)^(1/DATA!$F$38))","v":""},{"$f":"IF('HULP-velden'!K101=\"KO\",\"KO\",'HULP-velden'!O101)","v":""},null,{"$f":"IF(ISBLANK(G13),\"\",DATA!$G$41)","v":""},"",{"$f":"IFERROR(((M13/DATA!$G$40)*100),\"\")","v":""}]
[null,null,null,"7",null,"",null,null,{"$f":"IF(ISBLANK(G14),\"\",(0.5*(G14/DATA!$C$12)^DATA!$F$38+0.5*(2-(M14)/DATA!$D$12)^DATA!$F$38)^(1/DATA!$F$38))","v":""},{"$f":"IF('HULP-velden'!K102=\"KO\",\"KO\",'HULP-velden'!O102)","v":""},null,{"$f":"IF(ISBLANK(G14),\"\",DATA!$G$41)","v":""},"",{"$f":"IFERROR(((M14/DATA!$G$40)*100),\"\")","v":""}]
[null,null,null,"8",null,"",null,null,{"$f":"IF(ISBLANK(G15),\"\",(0.5*(G15/DATA!$C$12)^DATA!$F$38+0.5*(2-(M15)/DATA!$D$12)^DATA!$F$38)^(1/DATA!$F$38))","v":""},{"$f":"IF('HULP-velden'!K103=\"KO\",\"KO\",'HULP-velden'!O103)","v":""},null,{"$f":"IF(ISBLANK(G15),\"\",DATA!$G$41)","v":""},"",{"$f":"IFERROR(((M15/DATA!$G$40)*100),\"\")","v":""}]
[null,null,null,"9",null,"",null,null,{"$f":"IF(ISBLANK(G16),\"\",(0.5*(G16/DATA!$C$12)^DATA!$F$38+0.5*(2-(M16)/DATA!$D$12)^DATA!$F$38)^(1/DATA!$F$38))","v":""},{"$f":"IF('HULP-velden'!K104=\"KO\",\"KO\",'HULP-velden'!O104)","v":""},null,{"$f":"IF(ISBLANK(G16),\"\",DATA!$G$41)","v":""},"",{"$f":"IFERROR(((M16/DATA!$G$40)*100),\"\")","v":""}]
[null,null,null,"10",null,"",null,null,{"$f":"IF(ISBLANK(G17),\"\",(0.5*(G17/DATA!$C$12)^DATA!$F$38+0.5*(2-(M17)/DATA!$D$12)^DATA!$F$38)^(1/DATA!$F$38))","v":""},{"$f":"IF('HULP-velden'!K105=\"KO\",\"KO\",'HULP-velden'!O105)","v":""},null,{"$f":"IF(ISBLANK(G17),\"\",DATA!$G$41)","v":""},"",{"$f":"IFERROR(((M17/DATA!$G$40)*100),\"\")","v":""}]
[null,null,null,"11",null,"",null,null,{"$f":"IF(ISBLANK(G18),\"\",(0.5*(G18/DATA!$C$12)^DATA!$F$38+0.5*(2-(M18)/DATA!$D$12)^DATA!$F$38)^(1/DATA!$F$38))","v":""},{"$f":"IF('HULP-velden'!K106=\"KO\",\"KO\",'HULP-velden'!O106)","v":""},null,{"$f":"IF(ISBLANK(G18),\"\",DATA!$G$41)","v":""},"",{"$f":"IFERROR(((M18/DATA!$G$40)*100),\"\")","v":""}]
[null,null,null,"12",null,"",null,null,{"$f":"IF(ISBLANK(G19),\"\",(0.5*(G19/DATA!$C$12)^DATA!$F$38+0.5*(2-(M19)/DATA!$D$12)^DATA!$F$38)^(1/DATA!$F$38))","v":""},{"$f":"IF('HULP-velden'!K107=\"KO\",\"KO\",'HULP-velden'!O107)","v":""},null,{"$f":"IF(ISBLANK(G19),\"\",DATA!$G$41)","v":""},"",{"$f":"IFERROR(((M19/DATA!$G$40)*100),\"\")","v":""}]
[null,null,null,null,"Referentie",null,{"$f":"DATA!C12","v":100000},{"$f":"DATA!H38-DATA!G41","v":50},{"$f":"IF(ISBLANK(G20),\"\",(0.5*(G20/DATA!$C$12)^DATA!$F$38+0.5*(2-(M20)/DATA!$D$12)^DATA!$F$38)^(1/DATA!$F$38))","v":1},null,null,{"$f":"IF(ISBLANK(G20),\"\",DATA!$G$41)","v":150},{"$f":"DATA!D12","v":200},{"$f":"IFERROR(((M20/DATA!$G$40)*100),\"\")","v":80}]
[null,null,null,null,"Referentie (Qmax)",null,{"$f":"DATA!C13","v":119895.78808281798},{"$f":"DATA!G42","v":100},{"$f":"IF(ISBLANK(G21),\"\",(0.5*(G21/DATA!$C$12)^DATA!$F$38+0.5*(2-(M21)/DATA!$D$12)^DATA!$F$38)^(1/DATA!$F$38))","v":1},null,null,{"$f":"IF(ISBLANK(G21),\"\",DATA!$G$41)","v":150},{"$f":"DATA!D13","v":250},{"$f":"IFERROR(((M21/DATA!$G$40)*100),\"\")","v":100}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"TBV Onderzoek","index":4,"n_rows":28,"n_cols":20,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,3,7],[5,3,5,4],[11,4,11,6],[8,3,8,4],[12,15,13,15]]}
[]
[null,"Data voor onderzoek Superformule"]
[]
[]
[]
[null,"Naam inkooptraject",null,"Naam traject"]
[null,"Kenmerk",null,"Uw kenmerk"]
[]
[null,"Naam organisatie",null,"Uw organisatie"]
[null,"Datum Publicatie",null,"2021-11-11"]
[null,"CPV-code",null,"ICT"]
[]
[null,"Contactpersoon",null,"uw naam",null,null,null,null,null,null,null,null,null,null,null,"Namen van inschrijvers geanonimiseerd"]
[null,"Telefoonnummer",null,"uw telefoonnr."]
[]
[null,"#",null,"Kenmerk","Naam_Aanbesteding","CPV-code","Datum_Publicatie","Pref","Qref","Qwensen","Qmin","Qmax","P(Qmax)","n-waarde","Qknockout","Naam_Inschrijver","P(inschrijver)","Q(Inschrijver)","Score","Rangorde"]
[null,1,null,{"$f":"+Superformule!$G$7","v":0},{"$f":"+Superformule!$G$6","v":0},{"$f":"D11","v":"ICT"},{"$f":"+D10","v":"2021-11-11"},{"$f":"+Pref","v":100000},{"$f":"+Qref","v":200},{"$f":"Qmax-Qmin","v":100},{"$f":"+Qmin","v":150},{"$f":"+Qmax","v":250},{"$f":"+Pmax","v":119895.78808281798},{"$f":"+Exponent","v":2},{"$f":"LAQ","v":-1000},{"$f":"+Evaluatie!E8","v":0},{"$f":"+Evaluatie!G8","v":0},{"$f":"+Evaluatie!H8","v":0},{"$f":"+Evaluatie!I8","v":""},{"$f":"+Evaluatie!J8","v":""}]
[null,2,null,{"$f":"+Superformule!$G$7","v":0},{"$f":"+Superformule!$G$6","v":0},{"$f":"$F$17","v":"ICT"},{"$f":"+$G$17","v":"2021-11-11"},100000,200,100,150,250,119895.78808281798,2,-1000,{"$f":"+Evaluatie!E9","v":0},{"$f":"+Evaluatie!G9","v":0},{"$f":"+Evaluatie!H9","v":0},{"$f":"+Evaluatie!I9","v":""},{"$f":"+Evaluatie!J9","v":""}]
[null,3,null,{"$f":"+Superformule!$G$7","v":0},{"$f":"+Superformule!$G$6","v":0},{"$f":"$F$17","v":"ICT"},{"$f":"+$G$17","v":"2021-11-11"},100000,200,100,150,250,119895.78808281798,2,-1000,{"$f":"+Evaluatie!E10","v":0},{"$f":"+Evaluatie!G10","v":0},{"$f":"+Evaluatie!H10","v":0},{"$f":"+Evaluatie!I10","v":""},{"$f":"+Evaluatie!J10","v":""}]
[null,4,null,{"$f":"+Superformule!$G$7","v":0},{"$f":"+Superformule!$G$6","v":0},"ICT","2021-11-11",100000,200,100,150,250,119895.78808281798,2,-1000,{"$f":"+Evaluatie!E11","v":0},{"$f":"+Evaluatie!G11","v":0},{"$f":"+Evaluatie!H11","v":0},{"$f":"+Evaluatie!I11","v":""},{"$f":"+Evaluatie!J11","v":""}]
[null,5,null,{"$f":"+Superformule!$G$7","v":0},{"$f":"+Superformule!$G$6","v":0},"ICT","2021-11-11",100000,200,100,150,250,119895.78808281798,2,-1000,{"$f":"+Evaluatie!E12","v":0},{"$f":"+Evaluatie!G12","v":0},{"$f":"+Evaluatie!H12","v":0},{"$f":"+Evaluatie!I12","v":""},{"$f":"+Evaluatie!J12","v":""}]
[null,6,null,{"$f":"+Superformule!$G$7","v":0},{"$f":"+Superformule!$G$6","v":0},"ICT","2021-11-11",100000,200,100,150,250,119895.78808281798,2,-1000,{"$f":"+Evaluatie!E13","v":0},{"$f":"+Evaluatie!G13","v":0},{"$f":"+Evaluatie!H13","v":0},{"$f":"+Evaluatie!I13","v":""},{"$f":"+Evaluatie!J13","v":""}]
[null,7,null,{"$f":"+Superformule!$G$7","v":0},{"$f":"+Superformule!$G$6","v":0},"ICT","2021-11-11",100000,200,100,150,250,119895.78808281798,2,-1000,{"$f":"+Evaluatie!E14","v":0},{"$f":"+Evaluatie!G14","v":0},{"$f":"+Evaluatie!H14","v":0},{"$f":"+Evaluatie!I14","v":""},{"$f":"+Evaluatie!J14","v":""}]
[null,8,null,{"$f":"+Superformule!$G$7","v":0},{"$f":"+Superformule!$G$6","v":0},"ICT","2021-11-11",100000,200,100,150,250,119895.78808281798,2,-1000,{"$f":"+Evaluatie!E15","v":0},{"$f":"+Evaluatie!G15","v":0},{"$f":"+Evaluatie!H15","v":0},{"$f":"+Evaluatie!I15","v":""},{"$f":"+Evaluatie!J15","v":""}]
[null,9,null,{"$f":"+Superformule!$G$7","v":0},{"$f":"+Superformule!$G$6","v":0},"ICT","2021-11-11",100000,200,100,150,250,119895.78808281798,2,-1000,{"$f":"+Evaluatie!E16","v":0},{"$f":"+Evaluatie!G16","v":0},{"$f":"+Evaluatie!H16","v":0},{"$f":"+Evaluatie!I16","v":""},{"$f":"+Evaluatie!J16","v":""}]
[null,10,null,{"$f":"+Superformule!$G$7","v":0},{"$f":"+Superformule!$G$6","v":0},"ICT","2021-11-11",100000,200,100,150,250,119895.78808281798,2,-1000,{"$f":"+Evaluatie!E17","v":0},{"$f":"+Evaluatie!G17","v":0},{"$f":"+Evaluatie!H17","v":0},{"$f":"+Evaluatie!I17","v":""},{"$f":"+Evaluatie!J17","v":""}]
[null,11,null,{"$f":"+Superformule!$G$7","v":0},{"$f":"+Superformule!$G$6","v":0},"ICT","2021-11-11",100000,200,100,150,250,119895.78808281798,2,-1000,{"$f":"+Evaluatie!E18","v":0},{"$f":"+Evaluatie!G18","v":0},{"$f":"+Evaluatie!H18","v":0},{"$f":"+Evaluatie!I18","v":""},{"$f":"+Evaluatie!J18","v":""}]
[null,12,null,{"$f":"+Superformule!$G$7","v":0},{"$f":"+Superformule!$G$6","v":0},"ICT","2021-11-11",100000,200,100,150,250,119895.78808281798,2,-1000,{"$f":"+Evaluatie!E19","v":0},{"$f":"+Evaluatie!G19","v":0},{"$f":"+Evaluatie!H19","v":0},{"$f":"+Evaluatie!I19","v":""},{"$f":"+Evaluatie!J19","v":""}]

{"sheet":"BPK-Grafiek","index":5,"n_rows":83,"n_cols":16,"rows_kept":83,"cut":false,"hidden":true,"merged":[[19,3,19,4],[18,3,18,4],[17,3,17,4],[20,3,20,4],[21,3,21,4],[10,3,10,4],[8,3,8,4],[10,6,10,7],[17,6,17,7],[14,3,14,4],[12,3,12,4],[11,3,11,4]]}
[]
[null,"Europese Aanbesteding"]
[null,{"$f":"Superformule!G6","v":0}]
[null,"BPK-Grafiek"]
[null,{"$f":"\"Kenmerk: \" & Superformule!G7","v":"Kenmerk: "}]
[null,"(Prijzen exclusief BTW)"]
[]
[]
[null,null,null,"Vergelijkingswaarde"]
[]
[null,null,null,"      Indicatie eigen score",null,"Score Kwaliteit","Procenten"]
[null,null,null,"Kwaliteit in eisen ",null,{"$f":"+DATA!G41","v":150},{"$f":"+F12/DATA!$G$40*100","v":60},"%"]
[null,null,null,"Eigen inschatting score kwaliteit *1",null,null,{"$f":"+F13/DATA!$G$40*100","v":0},"%"]
[null,null,null,null,"Totaal kwaliteit",{"$f":"SUM(F12:F13)","v":150},{"$f":"SUM(G12:G13)","v":60},"%"]
[null,null,null,"Indicatie BPK-score",null,{"$f":"+DATA!E7","v":0.88388347648318444}]
[null,null,null,"*1",{"$f":"\"Eigen inschatting door Inschrijver. Waarde tussen 0 en \"&F20&\" punten.\"","v":"Eigen inschatting door Inschrijver. Waarde tussen 0 en 100 punten."}]
[]
[null,null,null,"Opbouw Score voor kwaliteit",null,"Punten","Procenten"]
[null,null,null,"Eisen ",null,{"$f":"DATA!G41","v":150},{"$f":"+F19/DATA!$G$40*100","v":60},"%"]
[null,null,null,"Wensen",null,{"$f":"DATA!G42","v":100},{"$f":"+F20/DATA!$G$40*100","v":40},"%"]
[null,null,null,"Totaal",null,{"$f":"SUM(F19:F20)","v":250},{"$f":"+F21/DATA!$G$40*100","v":100},"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Totaal kwaliteit",null,1650,{"$f":"+E83/Qmax*100","v":660},"%"]

{"sheet":"HULP-velden","index":6,"n_rows":1012,"n_cols":64,"rows_kept":1012,"cut":false,"hidden":true,"merged":[[118,6,118,7],[79,7,79,8],[0,2,2,3],[76,7,76,8],[77,7,77,8],[78,7,78,8],[70,7,70,8],[71,7,71,8],[72,7,72,8],[73,7,73,8],[74,7,74,8],[18,6,18,10],[19,6,19,10],[69,7,69,8]]}
[null,null,"Hulpvelden"]
[]
[]
[]
[]
[null,null,"Oplossen n=waarde (Solver)",null,null,null,null,null,null,null,null,null,null,"EMVI-lijnen t.b.v grafiek",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qmax",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nummerieke waarden naar tekst"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hulp=Q bij P=0",0,{"$f":"+R7/2","v":1.2500000000000001E-2},{"$f":"+S7/2","v":2.5000000000000001E-2},0.05,0.1,0.15,0.2,0.25,0.3,0.35,0.4,0.45,0.5,0.55000000000000004,0.6,0.65,0.7,0.75,0.8,0.85,0.9,0.95,1,1.05,1.1000000000000001,1.1499999999999999,1.2,1.25,1.3,1.35,1.4,1.45,1.5,1.55,1.6,1.65,1.7,1.75,1.8]
[null,null,"Pmax/Pref",{"$f":"'HULP-velden'!K75","v":1.1989578808281798},{"$f":"VLOOKUP(TRUE,$C:$E,3,TRUE)","v":2.0000620863460412},null,null,null,null,null,null,null,null,"Q berekend bij P=0 en EMVI=1",{"$f":"'HULP-velden'!L18","v":117.15728752538097},{"$f":"IFERROR($O8+P$7*(Qmax-$O8),0)","v":117.15728752538097},{"$f":"IFERROR($O8+Q$7*(Qmax-$O8),0)","v":118.8178214313137},120.47835533724644,123.79942314911192,130.44155877284288,137.08369439657383,143.72583002030478,150.36796564403573,157.01010126776669,163.65223689149764,170.29437251522859,176.93650813895954,183.57864376269049,190.22077938642144,196.86291501015239,203.50505063388334,210.14718625761429,216.78932188134524,223.4314575050762,230.07359312880715,236.7157287525381,243.35786437626905,250,256.64213562373095,263.2842712474619,269.92640687119285,276.5685424949238,null,null,null,null,null,null,null,null,null,null,null,null,"EMVI",null,null,"Qmax",{"$f":"Qmax","v":250},{"$f":"TEXT(BG8,\"#.##0\")","v":"250"},null,"Winnaar",{"$f":"I61","v":"4"},{"$f":"TEXT(BK8,\"#.##0\")","v":"4"}]
[null,null,"Q/Qref",{"$f":"+'HULP-velden'!L17","v":1.25},null,null,null,null,null,null,null,null,null,"P berekend uit Q en EMVI=1",null,0,{"$f":"IFERROR((2*$BC$9^Exponent-(2-Q8/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":15301.817337880153},{"$f":"IFERROR((2*$BC$9^Exponent-(2-R8/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":21608.159136246002},30468.185650103391,42831.783651820129,52141.672987749946,59840.516795099422,66490.314000053171,72380.77975902686,77684.835833010613,82515.642004754831,86952.111243430321,91051.90355561435,94858.682521369032,98406.45901289639,101722.33637899699,104828.3228832969,107742.57216080221,110480.25819260458,113054.20851061429,115475.37265926583,117753.17548503382,119895.78808281798,{"$f":"IFERROR((2*$BC$9^Exponent-(2-AM8/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":121910.33869352021},{"$f":"IFERROR((2*$BC$9^Exponent-(2-AN8/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":123803.07903245219},{"$f":"IFERROR((2*$BC$9^Exponent-(2-AO8/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":125579.51701069878},{"$f":"IFERROR((2*$BC$9^Exponent-(2-AP8/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":127244.52375070271},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR('HULP-velden'!H25,0)","v":1},null,null,"Qmin",{"$f":"Qmin","v":150},{"$f":"TEXT(BG9,\"#.##0\")","v":"150"},null,"Prijs winnaar",{"$f":"VLOOKUP($BK$8,'Info BD'!$B$27:$K$31,4,FALSE)","v":92040},{"$f":"TEXT(BK9,\"€ #.##0,00\")","v":"€ 92.040,00"}]
[null,null,"n",{"$f":"ROUNDDOWN(VLOOKUP(TRUE,$C:$E,3,TRUE),4)","v":2},{"$f":"VLOOKUP(TRUE,$C:$E,2,TRUE)","v":1},null,null,null,null,null,null,null,null,null,null,{"$f":"+P8/Qmax*100","v":46.862915010152385},47.527128572525477,48.191342134898576,49.519769259644768,52.176623509137151,54.833477758629535,57.490332008121911,60.147186257614294,62.80404050710667,65.460894756599046,68.117749006091429,70.774603255583813,73.431457505076196,76.088311754568565,78.745166004060948,81.402020253553346,84.058874503045729,86.715728752538098,89.372583002030481,92.029437251522864,94.686291501015234,97.343145750507617,100,{"$f":"+AM8/Qmax*100","v":102.65685424949238},{"$f":"+AN8/Qmax*100","v":105.31370849898477},{"$f":"+AO8/Qmax*100","v":107.97056274847714},{"$f":"+AP8/Qmax*100","v":110.62741699796952},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qwensen",{"$f":"Qwensen","v":100},{"$f":"TEXT(BG10,\"#.##0\")","v":"100"},null,"Q-score",{"$f":"VLOOKUP($BK$8,'Info BD'!$B$27:$K$31,8,FALSE)","v":235},{"$f":"TEXT(BK10,\"#.##0\")","v":"235"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q berekend bij P=0 en EMVI=0,9",{"$f":"IFERROR(Qref*(2-BC12*(2-'HULP-velden'!H$24/Qref)),0)","v":145.44155877284285},{"$f":"IFERROR($O11+P$7*(Qmax-$O11),0)","v":145.44155877284285},146.74853928818231,148.05551980352178,150.6694808342007,155.89740289555857,161.12532495691642,166.35324701827429,171.58116907963213,176.80909114099001,182.03701320234785,187.26493526370572,192.49285732506357,197.72077938642144,202.94870144777929,208.17662350913713,213.404545570495,218.63246763185285,223.86038969321072,229.08831175456856,234.31623381592641,239.54415587728428,244.77207793864216,250,255.22792206135784,260.45584412271569,265.68376618407353,270.91168824543144,276.13961030678928,null,null,null,null,null,null,null,null,null,null,null,"EMVI",null,null,"Pref",{"$f":"Pref","v":100000},{"$f":"TEXT(BG11,\"€ #.##0,00\")","v":"€ 100.000,00"},null,"BPK-Score",{"$f":"VLOOKUP(1,$G$130:$K$134,5,FALSE)","v":0.87400262013337238},{"$f":"TEXT(BK11,\"#.##0,0000\")","v":"0,8740"}]
[null,null,"Opgelost","Waarde=1","n",null,null,null,null,null,null,null,null,"P berekend uit Q en EMVI=0,9",null,0,{"$f":"IFERROR((2*$BC$12^Exponent-(2-Q11/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":12881.165002928316},{"$f":"IFERROR((2*$BC$12^Exponent-(2-R11/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":18193.260417847021},25662.678214252082,36103.746643758241,43985.4794877276,50520.280138515802,56180.151479353422,61208.288251447426,65749.784003916153,69899.556922137737,73723.784728680999,77270.817434467477,80577.269963190585,83671.668191277087,86576.75263349645,89310.999046434794,91889.658940726862,94325.493400639651,96629.304073688269,98810.32598730101,100876.52379581808,102834.81900601568,{"$f":"IFERROR((2*$BC$12^Exponent-(2-AM11/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":104691.26688665073},{"$f":"IFERROR((2*$BC$12^Exponent-(2-AN11/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":106451.19604834905},{"$f":"IFERROR((2*$BC$12^Exponent-(2-AO11/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":108119.31988953844},{"$f":"IFERROR((2*$BC$12^Exponent-(2-AP11/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":109699.82653627504},{"$f":"IFERROR((2*$BC$12^Exponent-(2-AQ11/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":111196.45212982965},null,null,null,null,null,null,null,null,null,null,null,{"$f":"0.9*BC9","v":0.9},null,null,"Qref",{"$f":"Qref","v":200},{"$f":"TEXT(BG12,\"#.##0\")","v":"200"},null,"Nummer 2",{"$f":"VLOOKUP(2,$G$130:$K$134,5,FALSE)","v":0.89895077729539785},{"$f":"TEXT(BK12,\"#.##0,0000\")","v":"0,8990"}]
[null,1,{"$f":"IF(AND(D13<=1,D13>=0.9995),TRUE,FALSE)","v":false},{"$f":"ROUNDDOWN((0.5*A^E13+0.5*(2-B)^E13)^(1/E13),4)","v":0.97440000000000004},1,null,null,null,null,null,null,null,null,null,null,{"$f":"+P11/Qmax*100","v":58.176623509137137},58.699415715272927,59.22220792140871,60.267792333680283,62.358961158223423,64.450129982766569,66.541298807309715,68.632467631852862,70.723636456395994,72.81480528093914,74.905974105482287,76.997142930025433,79.088311754568579,81.179480579111711,83.270649403654858,85.361818228198004,87.452987052741136,89.544155877284297,91.635324701827429,93.726493526370575,95.817662350913707,97.908831175456868,100,{"$f":"+AM11/Qmax*100","v":102.09116882454315},{"$f":"+AN11/Qmax*100","v":104.18233764908626},{"$f":"+AO11/Qmax*100","v":106.27350647362941},{"$f":"+AP11/Qmax*100","v":108.36467529817257},{"$f":"+AQ11/Qmax*100","v":110.45584412271572},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qref punten",{"$f":"Qref-Qmin","v":50},{"$f":"TEXT(BG13,\"#.##0\")","v":"50"},null,"Nummer 5",{"$f":"VLOOKUP(G135,$G$130:$K$134,5,FALSE)","v":0.93880136610467291},{"$f":"TEXT(BK13,\"#.##0,0000\")","v":"0,9388"}]
[null,2,{"$f":"IF(AND(D14<=1,D14>=0.9995),TRUE,FALSE)","v":false},{"$f":"ROUNDDOWN((0.5*A^E14+0.5*(2-B)^E14)^(1/E14),4)","v":0.97509999999999997},{"$f":"IF(D13=1,E13,E13/(D13^E13))","v":1.0262725779967159},null,null,null,null,null,null,null,null,"Q berekend bij P=0 en EMVI=0,8",{"$f":"IFERROR(Qref*(2-BC15*(2-'HULP-velden'!H$24/Qref)),0)","v":173.72583002030476},{"$f":"IFERROR($O14+P$7*(Qmax-$O14),0)","v":173.72583002030476},174.67925714505094,175.63268426979712,177.53953851928952,181.35324701827429,185.16695551725905,188.98066401624379,192.79437251522856,196.60808101421333,200.42178951319809,204.23549801218286,208.04920651116763,211.86291501015239,215.67662350913713,219.4903320081219,223.30404050710666,227.11774900609143,230.9314575050762,234.74516600406096,238.55887450304573,242.37258300203047,246.18629150101523,250,253.81370849898477,257.62741699796953,261.44112549695427,265.25483399593907,269.0685424949238,272.88225099390854,null,null,null,null,null,null,null,null,null,null,"EMVI",null,null,"Exponent",{"$f":"Exponent","v":2},{"$f":"TEXT(BG14,\"#.##0,0000\")","v":"2,0000"},null,"LAQ",{"$f":"LAQ","v":-1000},{"$f":"TEXT(BK14,\"#.##0\")","v":"-1.000"}]
[null,3,false,0.9758,{"$f":"IF(D14=1,E14,E14/(D14^E14))","v":1.0531767794364724},null,"Hulpvelden",null,null,null,null,null,null,"P berekend uit Q en EMVI=0,8",null,0,{"$f":"IFERROR((2*$BC$15^Exponent-(2-Q14/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":10375.004087877855},{"$f":"IFERROR((2*$BC$15^Exponent-(2-R14/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":14656.974722154282},20684.191293046271,29127.295662952594,35520.286451113658,40837.604731958207,45458.299403525169,49577.53344832515,53311.67296869844,56736.804107787808,59905.953124475927,62857.850049780718,65621.819692476594,68220.707562773692,70672.727941699355,72992.683351277083,75192.798755336509,77283.309713311712,79272.887859401002,81168.955596564498,82977.923385966584,84705.371730487095,{"$f":"IFERROR((2*$BC$15^Exponent-(2-AM14/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":86356.192854334717},87934.70249186318,89444.729157800626,90889.686211552733,92272.630605717059,93596.311208861676,null,null,null,null,null,null,null,null,null,null,{"$f":"0.8*BC9","v":0.8},null,null,null,null,null,null,"Delta LAQ",{"$f":"+BK14-BG9","v":-1150},{"$f":"TEXT(BK15,\"#.##0\")","v":"-1.150"}]
[null,4,false,0.97650000000000003,1.0807026565725282,null,"Q/P-verhouding van Qref / Pref",null,null,null,null,{"$f":"IFERROR(Qref/Pref,0)","v":2E-3},null,null,null,{"$f":"+P14/Qmax*100","v":69.490332008121896},69.871702858020384,70.253073707918844,71.015815407715806,72.541298807309715,74.066782206903625,75.59226560649752,77.117749006091415,78.643232405685325,80.168715805279234,81.694199204873144,83.219682604467053,84.745166004060962,86.270649403654858,87.796132803248767,89.321616202842662,90.847099602436572,92.372583002030481,93.898066401624376,95.423549801218286,96.949033200812181,98.474516600406091,100,{"$f":"+AM14/Qmax*100","v":101.52548339959391},103.05096679918782,104.5764501987817,106.10193359837564,107.62741699796952,109.15290039756343,null,null,null,null,null,null,null,null,null,null," ",null,null,"Teksten voor Beschrijvend documet"]
[null,5,false,0.97729999999999995,1.1088363343856849,null,"Verhouding Qmax / Qref",null,null,null,null,{"$f":"IFERROR(Qmax/Qref,0)","v":1.25},null,"Q berekend bij P=0 en EMVI=0,7",{"$f":"IFERROR(Qref*(2-BC18*(2-'HULP-velden'!H$24/Qref)),0)","v":202.01010126776669},{"$f":"IFERROR($O17+P$7*(Qmax-$O17),0)","v":202.01010126776669},202.60997500191959,203.20984873607253,204.40959620437835,206.80909114099001,209.20858607760169,211.60808101421335,214.00757595082501,216.40707088743667,218.80656582404833,221.20606076066002,223.60555569727168,226.00505063388334,228.404545570495,230.80404050710666,233.20353544371835,235.60303038033001,238.00252531694167,240.40202025355333,242.80151519016499,245.20101012677668,247.60050506338834,250,252.39949493661166,254.79898987322332,257.19848480983501,259.59797974644664,261.99747468305833,264.39696961967002,266.79646455628165,269.19595949289334,271.59545442950497,null,null,null,null,null,null,null,"EMVI",null,null,"Beste prijs-kwaliteitverhouding"]
[null,6,false,0.97799999999999998,1.1374305184579412,null,"Waarde van Q voor P=0",null,null,null,null,{"$f":"(2-2^(1/Exponent))*Qref","v":117.15728752538097},null,"P berekend uit Q en EMVI=0,7",null,0,{"$f":"IFERROR((2*$BC$18^Exponent-(2-Q17/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":7700.2927096505246},{"$f":"IFERROR((2*$BC$18^Exponent-(2-R17/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":10881.594156195002},15365.496600058685,21663.75275794624,26451.069796381005,30448.665245182739,33936.772814720709,37059.534467763151,39902.817605794036,42522.721253699179,44958.314078520758,47238.113835870136,49383.701813279637,51411.884062148492,53336.055842940499,55167.10156395135,56914.010130001989,58584.308609159154,60184.375824403258,61719.674201646776,63194.924525363735,64614.239916600411,{"$f":"IFERROR((2*$BC$18^Exponent-(2-AM17/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":65981.230105676004},67299.0836827733,68570.633764376631,69798.410993232479,70984.68673972378,72131.508634700163,73240.730036800669,74314.034655331416,75352.957269165403,null,null,null,null,null,null,null,{"$f":"0.7*BC9","v":0.7},null,null,"Referentiewaarde voor prijs"]
[null,7,false,0.9788,1.1665779357008579,null,"Aanbevolen waarde punt C (dit is de exacte cirkel met n=2)",null,null,null,null,{"$f":"IFERROR((2-(2-'HULP-velden'!$L$17)^2)^0.5,0)","v":1.1989578808281798},null,null,null,{"$f":"+P17/Qmax*100","v":80.804040507106677},81.043990000767835,81.283939494429021,81.763838481751336,82.723636456395994,83.683434431040681,84.643232405685339,85.603030380329997,86.56282835497467,87.522626329619328,88.482424304264001,89.442222278908673,90.402020253553346,91.361818228198004,92.321616202842662,93.281414177487349,94.241212152132007,95.201010126776666,96.160808101421338,97.120606076065997,98.080404050710669,99.040202025355342,100,{"$f":"+AM17/Qmax*100","v":100.95979797464467},101.91959594928932,102.87939392393399,103.83919189857866,104.79898987322333,105.75878784786801,106.71858582251265,107.67838379715732,108.63818177180198,null,null,null,null,null,null,null,null,null,null,"De referentiewaarde voor prijs (Pref) is een optelling van de referentiewaarden van de kostencomponenten zoals weergeven in Bijlage XX Prijzenformulier. "]
[null,8,false,0.97950000000000004,1.1961068517686453,null," Maximale waarde punt C (dit is een lineaire lijn met n=1)",null,null,null,null,{"$f":"+'HULP-velden'!L17","v":1.25},null,"Q berekend bij P=0 en EMVI=0,6",{"$f":"IFERROR(Qref*(2-BC21*(2-'HULP-velden'!H$24/Qref)),0)","v":230.29437251522859},{"$f":"IFERROR($O20+P$7*(Qmax-$O20),0)","v":230.29437251522859},230.54069285878822,230.78701320234788,231.27965388946717,232.26493526370572,233.25021663794431,234.23549801218286,235.22077938642144,236.20606076066002,237.19134213489858,238.17662350913716,239.16190488337571,240.14718625761429,241.13246763185288,242.11774900609143,243.10303038033001,244.08831175456856,245.07359312880715,246.05887450304573,247.04415587728428,248.02943725152286,249.01471862576142,250,250.98528137423858,251.97056274847714,252.95584412271572,253.94112549695427,254.92640687119285,255.91168824543144,256.89696961967002,257.88225099390854,258.86753236814712,259.85281374238571,260.83809511662429,261.82337649086287,262.8086578651014,263.79393923933998,264.77922061357856,265.76450198781714,"EMVI",null,null,{"$f":"\"Deze waarden zijn bepaald op basis van onze huidige ervaringen, inzichten en het budgetkader voor de komende jaren. Het betreft een inschatting waar geen rechten aan te ontlenen zijn. De referentiewaarde voor prijs (Pref) is \" & BH11 & \".\"","v":"Deze waarden zijn bepaald op basis van onze huidige ervaringen, inzichten en het budgetkader voor de komende jaren. Het betreft een inschatting waar geen rechten aan te ontlenen zijn. De referentiewaarde voor prijs (Pref) is € 100.000,00."}]
[null,9,false,0.98029999999999995,1.226110548430174,null,"Drie punten van de EMVI-Supercirkel",null,null,null,null,null,null,"P berekend uit Q en EMVI=0,6",null,0,{"$f":"IFERROR((2*$BC$21^Exponent-(2-Q20/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":4570.0991023294027},{"$f":"IFERROR((2*$BC$21^Exponent-(2-R20/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":6460.748776604848},9130.235598575824,12893.293391441546,15767.924314153484,18180.551976844392,20296.603496531156,22201.044279827263,23944.419622139216,25559.708630462021,27069.850199325596,28491.568659175908,29837.506427547371,31117.498377506396,32339.375860413384,33509.496670568602,34633.107187998619,35714.597438340868,36757.685416479537,37765.55327911659,38740.94993783065,39686.269665968852,{"$f":"IFERROR((2*$BC$21^Exponent-(2-AM20/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":40603.613240957864},41494.836145590016,42361.587028630434,43205.33872944273,44027.413553084516,44829.004047932685,45611.190227745537,46374.9539553453,47121.191040083017,47850.721478556537,48564.298175795499,49262.614414011201,49946.310282205013,50615.978238258394,51272.167942580563,51915.390476768196,{"$f":"0.6*BC9","v":0.6},null,null,"Referentiewaarde voor kwaliteit"]
[null,10,false,0.98109999999999997,1.2563899297408394,null,null,"Qmin","Referentie","Qmax",null,null,null,null,null,{"$f":"+P20/Qmax*100","v":92.117749006091429},92.216277143515285,92.314805280939154,92.511861555786865,92.905974105482287,93.300086655177722,93.694199204873144,94.088311754568579,94.482424304264015,94.876536853959422,95.270649403654858,95.664761953350279,96.058874503045715,96.45298705274115,96.847099602436572,97.241212152132007,97.635324701827429,98.02943725152285,98.423549801218286,98.817662350913722,99.211774900609157,99.605887450304564,100,{"$f":"+AM20/Qmax*100","v":100.39411254969544},100.78822509939084,101.18233764908628,101.5764501987817,101.97056274847714,102.36467529817257,102.75878784786801,103.15290039756341,103.54701294725885,103.94112549695429,104.33523804664972,104.72935059634514,105.12346314604055,105.51757569573599,105.91168824543142,106.30580079512686," ",null,null,{"$f":"\"In totaal kunnen \" & BH8 & \" punten voor kwaliteit worden gescoord (Qmax). Indien een Inschrijver voldoet aan alle gunningseisen wordt daarvoor \" & BH9 & \" punten verkregen. Bij het niet voldoen aan de gunningseisen wordt de Inschrijving ter zijde gelegd). \"","v":"In totaal kunnen 250 punten voor kwaliteit worden gescoord (Qmax). Indien een Inschrijver voldoet aan alle gunningseisen wordt daarvoor 150 punten verkregen. Bij het niet voldoen aan de gunningseisen wordt de Inschrijving ter zijde gelegd). "}]
[null,11,false,0.9819,1.2868733399055057,null,"P",0,{"$f":"IF(ISERROR(Pref),100000,Pref)","v":100000},{"$f":"Pmax","v":119895.78808281798},297101.44927512069,null,null,"Q berekend bij P=0 en EMVI=1,1",{"$f":"IFERROR(Qref*(2-BC24*(2-'HULP-velden'!H$24/Qref)),0)","v":88.873016277919035},{"$f":"IFERROR($O23+P$7*(Qmax-$O23),0)","v":88.873016277919035},90.88710357444505,92.901190870971064,96.929365464023078,104.98571465012714,113.04206383623118,121.09841302233522,129.15476220843928,137.21111139454334,145.26746058064737,153.32380976675142,161.38015895285548,169.43650813895954,177.4928573250636,185.54920651116763,193.60555569727165,201.66190488337571,209.71825406947977,217.77460325558383,225.83095244168788,233.88730162779194,241.94365081389594,250,258.05634918610406,266.11269837220811,274.16904755831217,282.22539674441623,290.28174593052023,298.33809511662429,306.39444430272835,314.4507934888324,322.50714267493646,330.56349186104052,338.61984104714458,346.67619023324858,354.73253941935263,362.78888860545669,370.84523779156075,378.90158697766481,"EMVI",null,null,{"$f":"\"De overige \" & BH10 & \" punten zijn verdeeld over de wensen.\"","v":"De overige 100 punten zijn verdeeld over de wensen."}]
[null,12,false,0.98270000000000002,1.3174806193632722,null,"Q",{"$f":"+'HULP-velden'!L18","v":117.15728752538097},{"$f":"Qref","v":200},{"$f":"Qmax","v":250},{"$f":"+Qmin","v":150},null,null,"P berekend uit Q en EMVI=1,1",null,0,{"$f":"IFERROR((2*$BC$24^Exponent-(2-Q23/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":17672.133879388752},{"$f":"IFERROR((2*$BC$24^Exponent-(2-R23/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":24951.56022943393},35171.687768574368,49412.982705721683,60114.77121438289,68945.458119697927,76555.302176976853,83279.649413150313,89318.717748532377,94803.556330986554,99825.562180530076,104451.515332287,108731.97719465455,112706.31878028199,116405.89907836285,119856.16382304762,123078.08209185029,126089.15970588048,128904.1726173269,131535.70944757154,133994.58056387986,136290.13170439011,{"$f":"IFERROR((2*$BC$24^Exponent-(2-AM23/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":138430.48796564181},{"$f":"IFERROR((2*$BC$24^Exponent-(2-AN23/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":140422.74607664946},{"$f":"IFERROR((2*$BC$24^Exponent-(2-AO23/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":142273.12765207779},{"$f":"IFERROR((2*$BC$24^Exponent-(2-AP23/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":143987.10257171461},{"$f":"IFERROR((2*$BC$24^Exponent-(2-AQ23/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":145569.48918295439},147024.53629877864,148355.99073057767,149567.15319991688,150660.92481429726,151639.84580039329,152506.12781698495,153261.68088595997,153908.13576008542,154446.8623740726,154878.98488866183,155205.39372710197,1.1000000000000001]
[null,13,false,0.98350000000000004,1.3481228778779337,null,"EMVI",{"$f":"IFERROR(((0.5*(H23/Pref)^Exponent+0.5*(2-(H24/Qref))^Exponent)^(1/Exponent)),0)","v":1},{"$f":"IFERROR((0.5*(I23/Pref)^Exponent+0.5*(2-(I24/Qref))^Exponent)^(1/Exponent),0)","v":1},{"$f":"IFERROR((0.5*(J23/Pref)^Exponent+0.5*(2-(J24/Qref))^Exponent)^(1/Exponent),0)","v":1},{"$f":"IFERROR((0.5*(K23/Pref)^Exponent+0.5*(2-(K24/Qref))^Exponent)^(1/Exponent),0)","v":2.2791914263766557},null,null,null,null,{"$f":"+P23/Qmax*100","v":35.549206511167611},36.35484142977802,37.160476348388428,38.771746185609231,41.994285860050859,45.216825534492472,48.439365208934085,51.661904883375712,54.884444557817332,58.106984232258952,61.329523906700565,64.552063581142193,67.774603255583827,70.997142930025433,74.219682604467053,77.442222278908659,80.664761953350279,83.887301627791913,87.109841302233519,90.332380976675154,93.554920651116774,96.77746032555838,100,{"$f":"+AM23/Qmax*100","v":103.22253967444162},{"$f":"+AN23/Qmax*100","v":106.44507934888325},{"$f":"+AO23/Qmax*100","v":109.66761902332487},{"$f":"+AP23/Qmax*100","v":112.89015869776648},{"$f":"+AQ23/Qmax*100","v":116.1126983722081},119.33523804664972,122.55777772109133,125.78031739553298,129.0028570699746,132.2253967444162,135.44793641885784,138.67047609329944,141.89301576774105,145.11555544218268,148.33809511662429,151.56063479106592,null,null,null,{"$f":"\"Uitgaande van de referentiewaarde voor prijs (Pref) is bepaald welk kwaliteitsniveau de Aanbestedende dienst hierbij verwacht. Dit verwacht kwaliteitsniveau wordt benoemd als referentiewaarde voor kwaliteit (Qref) en is gesteld op \" & BH12 & \" punten. \"","v":"Uitgaande van de referentiewaarde voor prijs (Pref) is bepaald welk kwaliteitsniveau de Aanbestedende dienst hierbij verwacht. Dit verwacht kwaliteitsniveau wordt benoemd als referentiewaarde voor kwaliteit (Qref) en is gesteld op 200 punten. "}]
[null,14,false,0.98419999999999996,1.3787023748243097,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Dit betreft de \"&BH9&\" punten die worden verkregen door te voldoen aan de gunningseisen en \" & BH13 & \" van de \"&BH10&\" die verkregen kunnen worden op basis van de wensen.\"","v":"Dit betreft de 150 punten die worden verkregen door te voldoen aan de gunningseisen en 50 van de 100 die verkregen kunnen worden op basis van de wensen."}]
[null,15,false,0.98499999999999999,1.4093099258390316,null,"Verhoudingen (indicatief)"]
[null,16,false,0.98580000000000001,1.4396499158969764,null,"Links van de Referentie","rc=",{"$f":"IFERROR(('HULP-velden'!L17-1)/('HULP-velden'!K75-1),1)","v":1.2565473604732462}," ",null,null,null,"Hulpvelden voor grafiek  (as-label)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BPK-formule"]
[null,17,false,0.98660000000000003,1.4695989394016338,null,"Rechts van de Referentie","rc=",{"$f":"IFERROR(1-('HULP-velden'!L18/Superformule!#REF!),1)","v":1},null,null,null,null,"Labels","X-as","Y-as","Lok-lijn",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"De hierboven beschreven benadering vertaalt zich naar onderstaande formule voor het bepalen van de beste prijs-/kwaliteitverhouding: "]
[null,18,false,0.98729999999999996,1.4990255898427349,null,null,null,null,null,null,null,null,0,{"$f":"+$O$40*N30","v":0},{"$f":"+$P$40*N30","v":0},null,null,0,0,{"$f":"(T30*(2-T30)^(Exponent-1))^(1/Exponent)","v":0}]
[null,19,false,0.98809999999999998,1.5280231444726906,null,"Analyse EMVI-Supercirkel",null,null,null,null,null,null,0.1,10000,20,null,null,0.1,0.1,0.43588989435406733,{"$f":"+P31","v":20},{"$f":"(+$O$40/1)*U31","v":43588.989435406736}]
[null,20,false,0.98880000000000001,1.556231775575313,null,"Inschrijver A+",{"$f":"0.8*H35","v":68556.546004010437},{"$f":"+J32/Qmax*100","v":70},{"$f":"Qmin+0.25*Qwensen","v":175},{"$f":"+J32-Qmin","v":25},null,null,0.2,20000,40,null,null,0.2,0.2,0.60000000000000009,{"$f":"+P32","v":40},{"$f":"(+$O$40/1)*U32","v":60000.000000000007},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Toelichting symbolen:"]
[null,21,false,0.98950000000000005,1.5837500883003215,null,"Inschrijver B+",{"$f":"0.8*H36","v":80000},80,{"$f":"Qmin+0.5*Qwensen","v":200},50,null,null,0.30000000000000004,30000.000000000004,60.000000000000007,null,null,0.30000000000000004,0.30000000000000004,0.71414284285428498,60.000000000000007,{"$f":"(+$O$40/1)*U33","v":71414.284285428497},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pi = Vergelijkingswaarde Inschrijver"]
[null,22,false,0.99019999999999997,1.6104486496264547,null,"Inschrijver C+",{"$f":"0.8*H37","v":88881.944173155891},90,{"$f":"Qmin+0.75*Qwensen","v":225},75,null,null,0.4,40000,80,null,null,0.4,0.4,0.8,80,80000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qi = Kwaliteitsscore Inschrijver"]
[null,23,false,0.99080000000000001,1.6361943779348471,null,"Inschrijver A",{"$f":"IFERROR((2*1^Exponent-(2-J35/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":85695.682505013043},70,{"$f":"Qmin+0.25*Qwensen","v":175},25,null,null,0.5,50000,100,null,null,0.5,0.5,0.8660254037844386,100,86602.540378443853,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Pref = Referentiewaarde voor prijs = \" & BH11","v":"Pref = Referentiewaarde voor prijs = € 100.000,00"}]
[null,24,false,0.99150000000000005,1.661126029967779,null,"Inschrijver B",{"$f":"IFERROR((2*1^Exponent-(2-J36/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":100000},80,{"$f":"Qmin+0.5*Qwensen","v":200},50,null,null,0.6,60000,120,null,null,0.6,0.6,0.91651513899116799,120,91651.513899116806,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Qref = Referentiewaarde voor kwaliteit = \" & BH12","v":"Qref = Referentiewaarde voor kwaliteit = 200"}]
[null,25,false,0.99209999999999998,1.6848484605582528,null,"Inschrijver C",{"$f":"IFERROR((2*1^Exponent-(2-J37/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":111102.43021644486},90,{"$f":"Qmin+0.75*Qwensen","v":225},75,null,null,0.7,70000,140,null,null,0.7,0.7,0.95393920141694566,140,95393.920141694573,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"n ≈ \" &BH14","v":"n ≈ 2,0000"}]
[null,26,false,0.99260000000000004,1.7075144625772583,null,"Inschrijver A-",{"$f":"1.2*H35","v":102834.81900601565},70,{"$f":"Qmin+0.25*Qwensen","v":175},25,null,null,0.79999999999999993,80000,160,null,null,0.79999999999999993,0.79999999999999993,0.97979589711327131,160,97979.589711327135]
[null,27,false,0.99319999999999997,1.7293080772445353,null,"Inschrijver B-",{"$f":"1.2*H36","v":120000},80,{"$f":"Qmin+0.5*Qwensen","v":200},50,null,null,0.89999999999999991,89999.999999999985,179.99999999999997,null,null,0.89999999999999991,0.89999999999999991,0.99498743710661997,179.99999999999997,99498.743710661991,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deze formule bepaalt de BPK-score voor de prijs/kwaliteitsverhouding van de Inschrijving. De BPK-formule is ter verduidelijking in onderstane grafiek weergegeven."]
[null,28,false,0.99370000000000003,1.7498338347636475,null,"Inschrijver C-",{"$f":"1.2*H37","v":133322.91625973381},90,{"$f":"Qmin+0.75*Qwensen","v":225},75,{"$f":"Qref","v":200},null,0.99999999999999989,{"$f":"IF(Pref<=0,100000,Pref)","v":100000},{"$f":"Qref","v":200},null," ",0.99999999999999989,0.99999999999999989,1,200,100000]
[null,29,false,0.99419999999999997,1.7692923369620293,null,null,null,null," ",null,null,null,1.0999999999999999,{"$f":"+$O$40*N41","v":109999.99999999999},{"$f":"+$P$40*N41","v":219.99999999999997},null,null,1.0999999999999999,1.0999999999999999,0.99498743710661997,219.99999999999997,99498.743710661991,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"De referentie inschrijving is een Inschrijving die gelijk is aan de referentiewaarde Pref en Qref. De BPK-score voor een referentie inschrijving is BPK-score = 1. Deze score geldt voor de gehele niet-onderbroken oranje lijn. De lichtere oranje lijnen geven indicatief de BPK-scores weer van respectievelijk 0.9, 0.8 en 0.7 (van links naar rechts)."]
[null,30,false,0.99470000000000003,1.787595512346414,null,"Hulpvelden",null,null," ",null,null,null,1.2,120000,240,null,null,1.2,1.2,0.9797958971132712,240,97979.58971132712,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Afhankelijk van de prijsstelling en kwaliteitsscore wordt de BPK-score voor de ontvangen Inschrijvingen op basis van de BPK-formule bepaald. De Inschrijver met de laagste BPK-score krijgt de opdracht voorlopig gegund. De BPK-scores worden niet afgerond. Indien 2 Inschrijvers exact dezelfde laagste BPK-score halen, dan gaat de Inschrijver met de hoogste kwaliteit voor op de Inschrijver met een lagere prijs."]
[null,31,false,0.99509999999999998,1.8046576021630873,null,"Qmax",{"$f":"Superformule!K13/Qmax*100","v":100},{"$f":"Superformule!K13/Qmax*100","v":100}," "," ",{"$f":"Qmax","v":250},null,1.3,130000,260,null,null,1.3,1.3,0.95393920141694566,260,95393.920141694573]
[null,32,false,0.99550000000000005,1.8207262098363834,null,"Qmin",{"$f":"Superformule!K11/Qmax*100","v":60},{"$f":"Superformule!K11/Qmax*100","v":60}," ",null,null,null,1.4000000000000001,140000,280,null,null,1.4000000000000001,1.4000000000000001,0.91651513899116788,280,91651.513899116791,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Ter illustratie zijn in de BPK-grafiek de scores van 5 Inschrijvers weergegeven. \"","v":"Ter illustratie zijn in de BPK-grafiek de scores van 5 Inschrijvers weergegeven. "}]
[null,33,false,0.99590000000000001,1.8357391302551684,null,"Qref",{"$f":"Qref/Qmax*100","v":80},{"$f":"Qref/Qmax*100","v":80}," ",null,null,null,1.5000000000000002,150000.00000000003,300.00000000000006,null,null,1.5000000000000002,1.5000000000000002,0.86602540378443849,300.00000000000006,86602.540378443853,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"De winnende Inschrijver in dit voorbeeld is Inschrijver \"& BL8 & \", met een vergelijkingswaarde (Pi) van \"& BL9 & \" \"","v":"De winnende Inschrijver in dit voorbeeld is Inschrijver 4, met een vergelijkingswaarde (Pi) van € 92.040,00 "}]
[null,34,false,0.99619999999999997,1.849636620250295,null,"Q",0,{"$f":"+Superformule!K13*1.1","v":275}," ",null,null,null,1.6000000000000003,160000.00000000003,320.00000000000006,null,null,1.6000000000000003,1.6000000000000003,0.79999999999999982,320.00000000000006,79999.999999999985,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\" en een kwaliteitsscore (Qi) van \" & BL10 & \" dat resulteert in de laagste BPK-score van \" & BL11 & \". De overige Inschrijvers hebben hogere BPK-scores (van \"& BL12 & \"  tot \"& BL13 &\").\"","v":" en een kwaliteitsscore (Qi) van 235 dat resulteert in de laagste BPK-score van 0,8740. De overige Inschrijvers hebben hogere BPK-scores (van 0,8990  tot 0,9388)."}]
[null,35,false,0.99650000000000005,1.8627077445918472,null,"P",0,{"$f":"+O50","v":200000.00000000006}," ",null,null,null,1.7000000000000004,170000.00000000003,340.00000000000006,null,null,1.7000000000000004,1.7000000000000004,0.71414284285428464,340.00000000000006,71414.284285428468]
[null,36,false,0.99680000000000002,1.8749127380901403,null,"Pref",{"$f":"Pref","v":100000},{"$f":"Pref","v":100000}," ",null,null,null,1.8000000000000005,180000.00000000006,360.00000000000011,{"$f":"Qmax","v":250},null,1.8000000000000005,1.8000000000000005,0.59999999999999931,360.00000000000011,59999.999999999935,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Als extra ondersteuning is in bijlage X Prijzenformulier, in het tabblad ‘BPK-Grafiek’ de betreffende grafiek opgenomen. Aan de hand van de vergelijkingswaarde (Pi) en een eigen inschatting van de kwaliteitsscore (Qi) kan de Inschrijver zijn eigen positie in de grafiek indicatief bepalen."]
[null,37,false,0.99709999999999999,1.886213649290279,null,"Qref",0,{"$f":"Pref","v":100000}," ",null,null,null,1.9000000000000006,190000.00000000006,380.00000000000011,null,null,1.9000000000000006,1.9000000000000006,0.43588989435406617,380.00000000000011,43588.98943540662]
[null,38,false,0.99739999999999995,1.8965746170410271,null,"Pref",0,{"$f":"Qref","v":200}," ",null,null,null,2.0000000000000004,200000.00000000006,400.00000000000011,null,null,2.0000000000000004,2.0000000000000004,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weging van de wensen"]
[null,39,false,0.99760000000000004,1.9059621401718414,null,"Ref lijn",0,0," ",null,null,null,2.1,{"$f":"+$O$40*N51","v":210000},{"$f":"+$P$40*N51","v":420},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"In totaal kunnen \"&BH8&\" punten worden gescoord. \"&BH9&\" door te voldoen aan alle gunningseisen en \"&BH10&\" door maximaal te scoren op alle wensen. \"","v":"In totaal kunnen 250 punten worden gescoord. 150 door te voldoen aan alle gunningseisen en 100 door maximaal te scoren op alle wensen. "}]
[null,40,false,0.99780000000000002,1.914711098102629,null,"Ref lijn",{"$f":"Pref","v":100000},{"$f":"Qref","v":200}," ",null,null,null,2.2000000000000002,{"$f":"+$O$40*N52","v":220000.00000000003},{"$f":"+$P$40*N52","v":440.00000000000006},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"De verdeling van de \" & BH10 & \" punten over de wensen is in onderstaande tabel weergegeven. Het totaal aantal punten voor kwaliteit aan een Inschrijving toegekend wordt in de BPK-formule weergegeven met Qi.\"","v":"De verdeling van de 100 punten over de wensen is in onderstaande tabel weergegeven. Het totaal aantal punten voor kwaliteit aan een Inschrijving toegekend wordt in de BPK-formule weergegeven met Qi."}]
[null,41,false,0.998,1.9228024927739578,null,"Bonus (extra)",{"$f":"(Qmin+Qwensen+150)/(Qmin+Qwensen)*100","v":160},{"$f":"+H53","v":160}," ",null,null,"factor",2.1,20,28]
[null,42,false,0.99819999999999998,1.9302185004781134,null,"Referentie",{"$f":"Pref","v":100000},{"$f":"Qref/Qmax*100","v":80}," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"< Hieronder kan de beschrijving van de score-systematiek voor kwaliteit (wensen) worden weergegeven…>"]
[null,43,false,0.99839999999999995,1.9369425664365556,null,"Referentie (Qmax)",{"$f":"+J23","v":119895.78808281798},{"$f":"+J24/Qmax*100","v":100}," ",null,null,null,"Hulpvelden voor grafiek  (as-label)",null,null," "]
[null,44,false,0.99850000000000005,1.9429594944081361,null,"Referentie (onder)",{"$f":"+H23","v":0},{"$f":"+H24","v":117.15728752538097}," ",null,null,null,null,"X-as","Y-as","bovengrens X-as"]
[null,45,false,0.99870000000000003,1.9486346551745257,null,"LAQ",{"$f":"IF(+Superformule!K22>Qmin,+Superformule!K22,-10)","v":-10},{"$f":"+H57","v":-10}," ",null,null,null,"ondergrens",0,0,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Optie teksten",{"$f":"IF(LAQ>Qmin,\"1\",\"0\")","v":"0"}]
[null,46,false,0.99880000000000002,1.9535804625464386,null,"LAQ (norm)",{"$f":"+H57/Qmax*100","v":-4},{"$f":"+I57/Qmax*100","v":-4},null,null,null,null,"bovengrens",120,{"$f":"VLOOKUP(N53,$N$31:$P$50,2,TRUE)","v":200000.00000000006},{"$f":"+Qmax","v":250},null,"=AFRONDEN.NAAR.BOVEN(ALS(P45<Q50;Q50;P45);-2)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minimale score kwaliteit Inschrijver "]
[null,47,false,0.99890000000000001,1.95816836338384,null,null,null,null,null,null,null,null,"primaire eenheid",10,{"$f":"IF(+O31=0,10,+O31)","v":10000},null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"De Lowest Acceptable Quality (LAQ) betreft het minimale aantal kwaliteitspunten van een Inschrijving om voor gunning in aanmerking te komen. Dit is vastgesteld op \"& BL14 & \" punten en \"","v":"De Lowest Acceptable Quality (LAQ) betreft het minimale aantal kwaliteitspunten van een Inschrijving om voor gunning in aanmerking te komen. Dit is vastgesteld op -1.000 punten en "}]
[null,48,false,0.999,1.9623931014666172,null,"Winnaar","van tabblad evaluatie","Winnaar","van tabblad Info BD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"betreft de \"& BH9 & \" punten die worden verkregen door te voldoen aan de Gunningseisen vermeerderd met \" & BL15 & \" punten van de \" & BH10 & \" punten die verkregen kunnen worden met de Wensen.\"","v":"betreft de 150 punten die worden verkregen door te voldoen aan de Gunningseisen vermeerderd met -1.150 punten van de 100 punten die verkregen kunnen worden met de Wensen."}]
[null,49,false,0.99909999999999999,1.966249799762773,null,{"$f":"N93","v":{"$error":"#N/A"}},null,{"$f":"M127","v":"4"},null,null,null,null,"hoogte as-label",20,33,"inputveld vanuit macro \"Grafiek\""]
[null,50,false,0.99919999999999998,1.9697339742553175,null," "," "," "," ",null,null,null," "]
[null,51,false,0.99929999999999997,1.9728415467867861,null,"Bovengrens",{"$f":"IF(+Superformule!K20<=0,-1000,+Superformule!K20)","v":-1000},{"$f":"+H63","v":-1000}," ",null,null,null,"45 graden ",0,0,0,0,null,null,null,0.2,0.25,0.3,0.35,0.4,0.45,0.5,0.55000000000000004,0.6,0.65,0.7,0.75,0.8,0.85,0.9,0.95,1]
[null,52,false,0.99929999999999997,1.9755688568539411,null," ",{"$f":"Qmin/Qmax*100","v":60},{"$f":"Qmax/Qmax*(100)","v":100}," ",null,null,null,"lijn",1,1,{"$f":"+'HULP-velden'!O40","v":100000},{"$f":"+'HULP-velden'!P40","v":200},null,null,null,{"$f":"IFERROR(#REF!+V$7*(Qmax-#REF!),0)","v":0},{"$f":"IFERROR(#REF!+W$7*(Qmax-#REF!),0)","v":0},{"$f":"IFERROR(#REF!+X$7*(Qmax-#REF!),0)","v":0},{"$f":"IFERROR(#REF!+Y$7*(Qmax-#REF!),0)","v":0},{"$f":"IFERROR(#REF!+Z$7*(Qmax-#REF!),0)","v":0},{"$f":"IFERROR(#REF!+AA$7*(Qmax-#REF!),0)","v":0},{"$f":"IFERROR(#REF!+AB$7*(Qmax-#REF!),0)","v":0},{"$f":"IFERROR(#REF!+AC$7*(Qmax-#REF!),0)","v":0},{"$f":"IFERROR(#REF!+AD$7*(Qmax-#REF!),0)","v":0},{"$f":"IFERROR(#REF!+AE$7*(Qmax-#REF!),0)","v":0},{"$f":"IFERROR(#REF!+AF$7*(Qmax-#REF!),0)","v":0},{"$f":"IFERROR(#REF!+AG$7*(Qmax-#REF!),0)","v":0},{"$f":"IFERROR(#REF!+AH$7*(Qmax-#REF!),0)","v":0},{"$f":"IFERROR(#REF!+AI$7*(Qmax-#REF!),0)","v":0},{"$f":"IFERROR(#REF!+AJ$7*(Qmax-#REF!),0)","v":0},{"$f":"IFERROR(#REF!+AK$7*(Qmax-#REF!),0)","v":0},{"$f":"IFERROR(#REF!+AL$7*(Qmax-#REF!),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EMVI"]
[null,53,false,0.99939999999999996,1.978303715361305,null,"Ondergrens",{"$f":"IF(+Superformule!K21<=0,-1000,+Superformule!K21)","v":-1000},{"$f":"+H65","v":-1000}," ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((2*$BC$9^Exponent-(2-V64/Qref)^Exponent)^(1/Exponent)*Pref,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR('HULP-velden'!H83,0)","v":"controle welke waarde"}]
[null,54,true,0.99950000000000006,1.9806540264920409,null,null,null,null," "]
[null,55,true,0.99950000000000006,1.9826169842833159,null,"Lok-lijn",{"$f":"+H48","v":100000},0," ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+(2-(V64/Qref))^Exponent","v":4},4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4]
[null,56,true,0.99960000000000004,1.9845838358075691,null,null,{"$f":"Qref/Qmax*100","v":80},{"$f":"(2*Qref)/Qmax*100","v":160}]
[null,57,true,0.99960000000000004,1.9861602059080765,null,"Invoervariabelen"]
[null,58,true,0.99960000000000004,1.9877390817467233,null,null,"Minimale waarde voor Qref",null,{"$f":"IF(Qmax/2<Qmin,Qmin,IF(ISERROR(Qmax/2),\"\",Qmax/2))","v":150},"beschreming Qmax /2"]
[null,59,true,0.99970000000000003,1.9893204693020079,null,1,"Referentieprijs",null,{"$f":"Pref","v":100000}]
[null,60,true,0.99970000000000003,1.9905082206399423,null,2,"Punten Qwensen",null,{"$f":"+Superformule!K10","v":100},null,null,null,"Pref",{"$f":"Pref","v":100000}]
[null,61,true,0.99970000000000003,1.991697390939984,null,3,"% Qwensen in totaal",null,{"$f":"+K73/100","v":0.6},60,"waarde vanuit invoer",null,"Qref",{"$f":"Qref","v":200}]
[null,62,true,0.99980000000000002,1.9928879827461707,null,4,"Kwaliteit Qwensen (bij Pref)",null,{"$f":"+L74/100","v":0.5},{"$f":"Qref","v":200},50,null,"exponent",{"$f":"Exponent","v":2}]
[null,63,true,0.99980000000000002,1.9936825410430523,null,5,"Prijs bij Qmax",null,{"$f":"IF(K76=0,(L75-1)/100*L76,J76)","v":0.19895788082817978},{"$f":"IF(+Superformule!I16+1>'HULP-velden'!L20,'HULP-velden'!L20,+Superformule!I16+1)","v":1.1989578808281798},{"$f":"Maximaal","v":1.25}]
[null,64,true,0.99980000000000002,1.9944777331053178,null,"Hulpwaarden",null,null,0.19895788082817978,1,61]
[null,65,true,{"$f":"ROUNDDOWN((0.5*A^E77+0.5*(2-B)^E77)^(1/E77),4)","v":0.99980000000000002},1.995273559691487,null,null,"Qref in procenten van Qwensen",null,0.5,{"$f":"IF(Qref_wensen<J84,J84,Qref_wensen)","v":0.5}]
[null,66,{"$f":"IF(AND(D78<=1,D78>=0.9995),TRUE,FALSE)","v":true},0.99990000000000001,1.9960700215612903,null,null,"Pmax in procenten van Pref",null,126]
[null,67,true,0.99990000000000001,{"$f":"IF(D78=1,E78,E78/(D78^E78))","v":1.9964685108084812},null,null,"Precentage aandeel wensen in Qtotaal",null,{"$f":"100-Percentage_Qeisen","v":99.4}]
[null,68,true,0.99990000000000001,{"$f":"IF(D79=1,E79,E79/(D79^E79))","v":1.9968671591858196},null,"Bescherming","Precentage aandeel eisen  in Qtotaal",null,{"$f":"+Superformule!I11","v":0.6}]
[null,69,true,0.99990000000000001,1.9972659667886405,null,null,"Bescherming ondergrens",null,{"$f":"Qmax/2","v":125}]
[null,70,true,0.99990000000000001,1.9976649337123551,null,null,"Qmin",null,{"$f":"Qmin","v":150}]
[null,71,true,0.99990000000000001,1.9980640600524502,null,null,"controle welke waarde",null,{"$f":"IF(J81<J82,J82,IF(ISERROR(J81),\"\",J81))","v":150}]
[null,72,true,0.99990000000000001,1.99846334590449,null,null,"Waarde voor schuifbalk",null,{"$f":"ROUNDUP((J83-J82)/Qwensen*100,0)","v":0}]
[null,73,true,0.99990000000000001,1.9988627913641142,null,null,null,null," "]
[null,74,true,0.99990000000000001,1.9992623965270393,null,"Middenpunten","Qeisen",null,{"$f":"+I44/2","v":30},{"$f":"+PrimairEenheidY","v":10000}]
[null,75,true,0.99990000000000001,1.9996621614890584,null,null,"Qwensen",null,{"$f":"+I44+(I43-I44)/2","v":80},{"$f":"+PrimairEenheidY","v":10000}]
[null,76,true,1,2.0000620863460412,null,null,"Qbonus",null,{"$f":"(100+H53)/2","v":130},{"$f":"+PrimairEenheidY","v":10000}]
[null,77,true,1,2.0000620863460412]
[null,78,true,1,2.0000620863460412,null,"Middenpunten","tbv koppeleing BD",null,{"$f":"Qref-Qmin","v":50}]
[null,79,true,1,2.0000620863460412]
[null,80,true,1,2.0000620863460412,null,"Label","Gunningswaarde"]
[null,81,true,1,2.0000620863460412,null,null,null,null,"LAQ",null,null,"Winnaar = ",{"$f":"VLOOKUP(1,O95:P107,2,FALSE)","v":{"$error":"#N/A"}}]
[null,82,true,1,2.0000620863460412,null,"Evaluatie",null,null,{"$f":"LAQ","v":-1000},{"$f":"COUNTIF(K96:K105,\"KO\")","v":0},null,"# akkoord =",{"$f":"COUNT(N96:N107)","v":0}]
[null,83,true,1,2.0000620863460412,null,"Rangorde","lev. # ","Naam leverancier","Qscore","Knock Out","Score","Score","Rangorde onbewerkt","Rangorde","lev. # "]
[null,84,true,1,2.0000620863460412,null,{"$f":"+Evaluatie!J8","v":""},"1",{"$f":"+Evaluatie!E8","v":0},{"$f":"+Evaluatie!M8","v":""},{"$f":"IF(J96<$J$94,\"KO\",\"\")","v":""},{"$f":"+Evaluatie!I8","v":""},{"$f":"IF(K96=\"KO\",\"\",L96)","v":""},{"$f":"IF(ISERROR(RANK(M96,$M$96:$M$107)),\"\",RANK(M96,$M$96:$M$107))","v":""},{"$f":"IF(N96=\"\",\"\",IF(K96=\"KO\",\"\",$N$94+1-N96))","v":""},{"$f":"+H96","v":"1"}]
[null,85,true,1,2.0000620863460412,null,{"$f":"+Evaluatie!J9","v":""},"2",{"$f":"+Evaluatie!E9","v":0},{"$f":"+Evaluatie!M9","v":""},{"$f":"IF(J97<$J$94,\"KO\",\"\")","v":""},{"$f":"+Evaluatie!I9","v":""},{"$f":"IF(K97=\"KO\",\"\",L97)","v":""},"",{"$f":"IF(N97=\"\",\"\",IF(K97=\"KO\",\"\",$N$94+1-N97))","v":""},"2"]
[null,86,true,1,2.0000620863460412,null,{"$f":"+Evaluatie!J10","v":""},"3",{"$f":"+Evaluatie!E10","v":0},{"$f":"+Evaluatie!M10","v":""},"",{"$f":"+Evaluatie!I10","v":""},"","","","3"]
[null,87,true,1,2.0000620863460412,null,{"$f":"+Evaluatie!J11","v":""},"4",{"$f":"+Evaluatie!E11","v":0},{"$f":"+Evaluatie!M11","v":""},"",{"$f":"+Evaluatie!I11","v":""},"","","","4"]
[null,88,true,1,2.0000620863460412,null,{"$f":"+Evaluatie!J12","v":""},"5",{"$f":"+Evaluatie!E12","v":0},{"$f":"+Evaluatie!M12","v":""},"",{"$f":"+Evaluatie!I12","v":""},"","","","5"]
[null,89,true,1,2.0000620863460412,null,{"$f":"+Evaluatie!J13","v":""},"6",{"$f":"+Evaluatie!E13","v":0},{"$f":"+Evaluatie!M13","v":""},"",{"$f":"+Evaluatie!I13","v":""},"","","","6"]
[null,90,true,1,2.0000620863460412,null,{"$f":"+Evaluatie!J14","v":""},"7",{"$f":"+Evaluatie!E14","v":0},{"$f":"+Evaluatie!M14","v":""},"",{"$f":"+Evaluatie!I14","v":""},"","","","7"]
[null,91,true,1,2.0000620863460412,null,{"$f":"+Evaluatie!J15","v":""},"8",{"$f":"+Evaluatie!E15","v":0},{"$f":"+Evaluatie!M15","v":""},"",{"$f":"+Evaluatie!I15","v":""},"","","","8"]
[null,92,true,1,2.0000620863460412,null,{"$f":"+Evaluatie!J16","v":""},"9",{"$f":"+Evaluatie!E16","v":0},{"$f":"+Evaluatie!M16","v":""},"",{"$f":"+Evaluatie!I16","v":""},"","","","9"]
[null,93,true,1,2.0000620863460412,null,{"$f":"+Evaluatie!J17","v":""},"10",{"$f":"+Evaluatie!E17","v":0},{"$f":"+Evaluatie!M17","v":""},"",{"$f":"+Evaluatie!I17","v":""},"","","","10"]
[null,94,true,1,2.0000620863460412,null,{"$f":"+Evaluatie!J18","v":""},"11",{"$f":"+Evaluatie!E18","v":0},{"$f":"+Evaluatie!M18","v":""},{"$f":"IF(J106<$J$94,\"KO\",\"\")","v":""},{"$f":"+Evaluatie!I18","v":""},"","","","11"]
[null,95,true,1,2.0000620863460412,null,{"$f":"+Evaluatie!J19","v":""},"12",{"$f":"+Evaluatie!E19","v":0},{"$f":"+Evaluatie!M19","v":""},"",{"$f":"+Evaluatie!I19","v":""},"","","","12"]
[null,96,true,1,2.0000620863460412,null,"T.b.v. tabblad DATA"]
[null,97,true,1,2.0000620863460412,null,"Qmax",{"$f":"Qmax","v":250}]
[null,98,true,1,2.0000620863460412,null,"Qmin",{"$f":"Qmin","v":150}]
[null,99,true,1,2.0000620863460412,null,"Qwensen",{"$f":"Qwensen","v":100}]
[null,100,true,1,2.0000620863460412,null,"Exponent",{"$f":"Exponent","v":2}]
[null,101,true,1,2.0000620863460412,null,"Pref",{"$f":"Pref","v":100000}]
[null,102,true,1,2.0000620863460412,null,"Qref",{"$f":"Qref","v":200}]
[null,103,true,1,2.0000620863460412,null,"Qknockout",{"$f":"LAQ","v":-1000}]
[null,104,true,1,2.0000620863460412]
[null,105,true,1,2.0000620863460412]
[null,106,true,1,2.0000620863460412]
[null,107,true,1,2.0000620863460412,null," "]
[null,108,true,1,2.0000620863460412,null,"Qwenseni","Pi","Totaal"]
[null,109,true,1,2.0000620863460412,null,{"$f":"I121-Qmin","v":65},{"$f":"ROUND(Pref-0.05*(Pmax-Pref),-1)","v":99010},{"$f":"ROUND(Qref+0.3*(Qmax-Qref),0)","v":215}]
[null,110,true,1,2.0000620863460412,null,{"$f":"I122-Qmin","v":73},{"$f":"ROUND(Pref-0.4*(Pmax-Pref),-1)","v":92040},{"$f":"ROUND(Qref+0.45*(Qmax-Qref),0)","v":223}]
[null,111,true,1,2.0000620863460412,null,{"$f":"I123-Qmin","v":80},{"$f":"ROUND(Pref+0.1*(Pmax-Pref),-1)","v":101990},{"$f":"ROUND(Qref+0.6*(Qmax-Qref),0)","v":230}]
[null,112,true,1,2.0000620863460412,null,{"$f":"I124-Qmin","v":85},{"$f":"ROUND(Pref-0.4*(Pmax-Pref),-1)","v":92040},{"$f":"ROUND(Qref+0.7*(Qmax-Qref),0)","v":235}]
[null,113,true,1,2.0000620863460412,null,{"$f":"I125-Qmin","v":93},{"$f":"ROUND(Pref-0*(Pmax-Pref),-1)","v":100000},{"$f":"ROUND(Qref+0.85*(Qmax-Qref),0)","v":243}]
[null,114,true,1,2.0000620863460412]
[null,115,true,1,2.0000620863460412,null,null,null,"LAQ",null,null,"Winnaar = ",{"$f":"VLOOKUP(1,N129:O134,2,FALSE)","v":"4"}]
[null,116,true,1,2.0000620863460412,null,"Info BD",null,{"$f":"LAQ","v":-1000},{"$f":"COUNTIF(K130:K139,\"KO\")","v":0},null,"# akkoord =",{"$f":"COUNT(M130:M134)","v":5}]
[null,117,true,1,2.0000620863460412,null,"Rangorde","lev. # ","Qscore","Knock Out","Score","Score","Rangorde onbewerkt","Rangorde","lev. # "]
[null,118,true,1,2.0000620863460412,null,{"$f":"+N130","v":5},"1",{"$f":"+'Info BD'!C27+Qmin","v":215},{"$f":"IF(I130<$I$128,\"KO\",\"\")","v":""},{"$f":"+'Info BD'!G27","v":0.95810307639627168},{"$f":"IF(J130=\"KO\",\"\",K130)","v":0.95810307639627168},{"$f":"IF(ISERROR(RANK(L130,$L$130:$L$134)),\"\",RANK(L130,$L$130:$L$134))","v":1},{"$f":"IF(J130=\"KO\",\"\",$M$128+1-M130)","v":5},{"$f":"+H130","v":"1"}]
[null,119,true,1,2.0000620863460412,null,{"$f":"+N131","v":3},"2",{"$f":"+'Info BD'!C28+Qmin","v":223},{"$f":"IF(I131<$I$128,\"KO\",\"\")","v":""},{"$f":"+'Info BD'!G28","v":0.90287351273586491},{"$f":"IF(J131=\"KO\",\"\",K131)","v":0.90287351273586491},{"$f":"IF(ISERROR(RANK(L131,$L$130:$L$134)),\"\",RANK(L131,$L$130:$L$134))","v":3},{"$f":"IF(J131=\"KO\",\"\",$M$128+1-M131)","v":3},{"$f":"+H131","v":"2"}]
[null,120,true,1,2.0000620863460412,null,{"$f":"+N132","v":4},"3",{"$f":"+'Info BD'!C29+Qmin","v":230},{"$f":"IF(I132<$I$128,\"KO\",\"\")","v":""},{"$f":"+'Info BD'!G29","v":0.93880136610467291},0.93880136610467291,{"$f":"IF(ISERROR(RANK(L132,$L$130:$L$134)),\"\",RANK(L132,$L$130:$L$134))","v":2},{"$f":"IF(J132=\"KO\",\"\",$M$128+1-M132)","v":4},{"$f":"+H132","v":"3"}]
[null,121,true,1,2.0000620863460412,null,{"$f":"+N133","v":1},"4",{"$f":"+'Info BD'!C30+Qmin","v":235},{"$f":"IF(I133<$I$128,\"KO\",\"\")","v":""},{"$f":"+'Info BD'!G30","v":0.87400262013337238},0.87400262013337238,{"$f":"IF(ISERROR(RANK(L133,$L$130:$L$134)),\"\",RANK(L133,$L$130:$L$134))","v":5},{"$f":"IF(J133=\"KO\",\"\",$M$128+1-M133)","v":1},{"$f":"+H133","v":"4"}]
[null,122,true,1,2.0000620863460412,null,{"$f":"+N134","v":2},"5",{"$f":"+'Info BD'!C31+Qmin","v":243},{"$f":"IF(I134<$I$128,\"KO\",\"\")","v":""},{"$f":"+'Info BD'!G31","v":0.89895077729539785},0.89895077729539785,{"$f":"IF(ISERROR(RANK(L134,$L$130:$L$134)),\"\",RANK(L134,$L$130:$L$134))","v":4},{"$f":"IF(J134=\"KO\",\"\",$M$128+1-M134)","v":2},{"$f":"+H134","v":"5"}]
[null,123,true,1,2.0000620863460412,null,{"$f":"MAX(G131:G134)","v":4},"<- max"]
[null,124,true,1,2.0000620863460412]
[null,125,true,1,2.0000620863460412,null,"SOM evaluatie"]
[null,126,true,1,2.0000620863460412,null,{"$f":"SUM(Evaluatie!H8:H19)","v":0}]
[null,127,true,1,2.0000620863460412]
[null,128,true,1,2.0000620863460412]
[null,129,true,{"$f":"ROUNDDOWN((0.5*A^E141+0.5*(2-B)^E141)^(1/E141),4)","v":1},2.0000620863460412]
[null,130,{"$f":"IF(AND(D142<=1,D142>=0.9995),TRUE,FALSE)","v":true},1,2.0000620863460412]
[null,131,true,1,2.0000620863460412]
[null,132,true,1,{"$f":"IF(D143=1,E143,E143/(D143^E143))","v":2.0000620863460412}]
[null,133,true,1,2.0000620863460412]
[null,134,true,1,2.0000620863460412]
[null,135,true,1,2.0000620863460412]
[null,136,true,1,2.0000620863460412]
[null,137,true,1,2.0000620863460412]
[null,138,true,1,2.0000620863460412]
[null,139,true,1,2.0000620863460412]
[null,140,true,1,2.0000620863460412]
[null,141,true,1,2.0000620863460412]
[null,142,true,1,{"$f":"IF(D153=1,E153,E153/(D153^E153))","v":2.0000620863460412}]
[null,143,true,1,2.0000620863460412]
[null,144,true,1,2.0000620863460412]
[null,145,true,1,2.0000620863460412]
[null,146,true,1,2.0000620863460412]
[null,147,true,1,2.0000620863460412]
[null,148,true,1,2.0000620863460412]
[null,149,true,1,2.0000620863460412]
[null,150,true,1,2.0000620863460412]
[null,151,true,1,2.0000620863460412]
[null,152,true,1,2.0000620863460412]
[null,153,true,1,2.0000620863460412]
[null,154,true,1,2.0000620863460412]
[null,155,true,1,2.0000620863460412]
[null,156,true,1,2.0000620863460412]
[null,157,true,1,2.0000620863460412]
[null,158,true,1,2.0000620863460412]
[null,159,true,1,2.0000620863460412]
[null,160,true,1,2.0000620863460412]
[null,161,true,1,2.0000620863460412]
[null,162,true,1,2.0000620863460412]
[null,163,true,1,2.0000620863460412]
[null,164,true,1,2.0000620863460412]
[null,165,true,1,2.0000620863460412]
[null,166,true,1,2.0000620863460412]
[null,167,true,1,2.0000620863460412]
[null,168,true,1,2.0000620863460412]
[null,169,true,1,2.0000620863460412]
[null,170,true,1,2.0000620863460412]
[null,171,true,1,2.0000620863460412]
[null,172,true,1,2.0000620863460412]
[null,173,true,1,2.0000620863460412]
[null,174,true,1,2.0000620863460412]
[null,175,true,1,2.0000620863460412]
[null,176,true,1,2.0000620863460412]
[null,177,true,1,2.0000620863460412]
[null,178,true,1,2.0000620863460412]
[null,179,true,1,2.0000620863460412]
[null,180,true,1,2.0000620863460412]
[null,181,true,1,2.0000620863460412]
[null,182,true,1,2.0000620863460412]
[null,183,true,1,2.0000620863460412]
[null,184,true,1,2.0000620863460412]
[null,185,true,1,2.0000620863460412]
[null,186,true,1,2.0000620863460412]
[null,187,true,1,2.0000620863460412]
[null,188,true,1,2.0000620863460412]
[null,189,true,1,2.0000620863460412]
[null,190,true,1,2.0000620863460412]
[null,191,true,1,2.0000620863460412]
[null,192,true,1,2.0000620863460412]
[null,193,true,{"$f":"ROUNDDOWN((0.5*A^E205+0.5*(2-B)^E205)^(1/E205),4)","v":1},2.0000620863460412]
[null,194,{"$f":"IF(AND(D206<=1,D206>=0.9995),TRUE,FALSE)","v":true},1,2.0000620863460412]
[null,195,true,1,2.0000620863460412]
[null,196,true,1,2.0000620863460412]
[null,197,true,1,2.0000620863460412]
[null,198,true,1,2.0000620863460412]
[null,199,true,1,2.0000620863460412]
[null,200,true,1,2.0000620863460412]
[null,201,true,1,2.0000620863460412]
[null,202,true,1,2.0000620863460412]
[null,203,true,1,2.0000620863460412]
[null,204,true,1,2.0000620863460412]
[null,205,true,1,2.0000620863460412]
[null,206,true,1,{"$f":"IF(D217=1,E217,E217/(D217^E217))","v":2.0000620863460412}]
[null,207,true,1,2.0000620863460412]
[null,208,true,1,2.0000620863460412]
[null,209,true,1,2.0000620863460412]
[null,210,true,1,2.0000620863460412]
[null,211,true,1,2.0000620863460412]
[null,212,true,1,2.0000620863460412]
[null,213,true,1,2.0000620863460412]
[null,214,true,1,2.0000620863460412]
[null,215,true,1,2.0000620863460412]
[null,216,true,1,2.0000620863460412]
[null,217,true,1,2.0000620863460412]
[null,218,true,1,2.0000620863460412]
[null,219,true,1,2.0000620863460412]
[null,220,true,1,2.0000620863460412]
[null,221,true,1,{"$f":"IF(D232=1,E232,E232/(D232^E232))","v":2.0000620863460412}]
[null,222,true,1,2.0000620863460412]
[null,223,true,1,2.0000620863460412]
[null,224,true,1,2.0000620863460412]
[null,225,true,1,2.0000620863460412]
[null,226,true,1,2.0000620863460412]
[null,227,true,1,2.0000620863460412]
[null,228,true,1,2.0000620863460412]
[null,229,true,1,2.0000620863460412]
[null,230,true,1,2.0000620863460412]
[null,231,true,1,2.0000620863460412]
[null,232,true,1,2.0000620863460412]
[null,233,true,1,2.0000620863460412]
[null,234,true,1,2.0000620863460412]
[null,235,true,1,2.0000620863460412]
[null,236,true,1,2.0000620863460412]
[null,237,true,1,2.0000620863460412]
[null,238,true,1,2.0000620863460412]
[null,239,true,1,2.0000620863460412]
[null,240,true,1,2.0000620863460412]
[null,241,true,1,2.0000620863460412]
[null,242,true,1,2.0000620863460412]
[null,243,true,1,2.0000620863460412]
[null,244,true,1,2.0000620863460412]
[null,245,true,1,2.0000620863460412]
[null,246,true,1,2.0000620863460412]
[null,247,true,1,2.0000620863460412]
[null,248,true,1,2.0000620863460412]
[null,249,true,1,2.0000620863460412]
[null,250,true,1,2.0000620863460412]
[null,251,true,1,2.0000620863460412]
[null,252,true,1,2.0000620863460412]
[null,253,true,1,2.0000620863460412]
[null,254,true,1,2.0000620863460412]
[null,255,true,1,2.0000620863460412]
[null,256,true,1,2.0000620863460412]
[null,257,true,{"$f":"ROUNDDOWN((0.5*A^E269+0.5*(2-B)^E269)^(1/E269),4)","v":1},2.0000620863460412]
[null,258,{"$f":"IF(AND(D270<=1,D270>=0.9995),TRUE,FALSE)","v":true},1,2.0000620863460412]
[null,259,true,1,2.0000620863460412]
[null,260,true,1,2.0000620863460412]
[null,261,true,1,2.0000620863460412]
[null,262,true,1,2.0000620863460412]
[null,263,true,1,2.0000620863460412]
[null,264,true,1,2.0000620863460412]
[null,265,true,1,2.0000620863460412]
[null,266,true,1,2.0000620863460412]
[null,267,true,1,2.0000620863460412]
[null,268,true,1,2.0000620863460412]
[null,269,true,1,2.0000620863460412]
[null,270,true,1,2.0000620863460412]
[null,271,true,1,2.0000620863460412]
[null,272,true,1,2.0000620863460412]
[null,273,true,1,2.0000620863460412]
[null,274,true,1,2.0000620863460412]
[null,275,true,1,2.0000620863460412]
[null,276,true,1,2.0000620863460412]
[null,277,true,1,2.0000620863460412]
[null,278,true,1,2.0000620863460412]
[null,279,true,1,2.0000620863460412]
[null,280,true,1,2.0000620863460412]
[null,281,true,1,2.0000620863460412]
[null,282,true,1,2.0000620863460412]
[null,283,true,1,2.0000620863460412]
[null,284,true,1,2.0000620863460412]
[null,285,true,1,{"$f":"IF(D296=1,E296,E296/(D296^E296))","v":2.0000620863460412}]
[null,286,true,1,2.0000620863460412]
[null,287,true,1,2.0000620863460412]
[null,288,true,1,2.0000620863460412]
[null,289,true,1,2.0000620863460412]
[null,290,true,1,2.0000620863460412]
[null,291,true,1,2.0000620863460412]
[null,292,true,1,2.0000620863460412]
[null,293,true,1,2.0000620863460412]
[null,294,true,1,2.0000620863460412]
[null,295,true,1,2.0000620863460412]
[null,296,true,1,2.0000620863460412]
[null,297,true,1,2.0000620863460412]
[null,298,true,1,2.0000620863460412]
[null,299,true,1,2.0000620863460412]
[null,300,true,1,2.0000620863460412]
[null,301,true,1,2.0000620863460412]
[null,302,true,1,2.0000620863460412]
[null,303,true,1,2.0000620863460412]
[null,304,true,1,2.0000620863460412]
[null,305,true,1,2.0000620863460412]
[null,306,true,1,2.0000620863460412]
[null,307,true,1,2.0000620863460412]
[null,308,true,1,2.0000620863460412]
[null,309,true,1,2.0000620863460412]
[null,310,true,1,2.0000620863460412]
[null,311,true,1,2.0000620863460412]
[null,312,true,1,2.0000620863460412]
[null,313,true,1,2.0000620863460412]
[null,314,true,1,2.0000620863460412]
[null,315,true,1,2.0000620863460412]
[null,316,true,1,2.0000620863460412]
[null,317,true,1,2.0000620863460412]
[null,318,true,1,2.0000620863460412]
[null,319,true,1,2.0000620863460412]
[null,320,true,1,2.0000620863460412]
[null,321,true,{"$f":"ROUNDDOWN((0.5*A^E333+0.5*(2-B)^E333)^(1/E333),4)","v":1},2.0000620863460412]
[null,322,{"$f":"IF(AND(D334<=1,D334>=0.9995),TRUE,FALSE)","v":true},1,2.0000620863460412]
[null,323,true,1,2.0000620863460412]
[null,324,true,1,2.0000620863460412]
[null,325,true,1,2.0000620863460412]
[null,326,true,1,2.0000620863460412]
[null,327,true,1,2.0000620863460412]
[null,328,true,1,2.0000620863460412]
[null,329,true,1,2.0000620863460412]
[null,330,true,1,2.0000620863460412]
[null,331,true,1,2.0000620863460412]
[null,332,true,1,2.0000620863460412]
[null,333,true,1,2.0000620863460412]
[null,334,true,1,2.0000620863460412]
[null,335,true,1,2.0000620863460412]
[null,336,true,1,2.0000620863460412]
[null,337,true,1,2.0000620863460412]
[null,338,true,1,2.0000620863460412]
[null,339,true,1,2.0000620863460412]
[null,340,true,1,2.0000620863460412]
[null,341,true,1,2.0000620863460412]
[null,342,true,1,2.0000620863460412]
[null,343,true,1,2.0000620863460412]
[null,344,true,1,2.0000620863460412]
[null,345,true,1,{"$f":"IF(D356=1,E356,E356/(D356^E356))","v":2.0000620863460412}]
[null,346,true,1,2.0000620863460412]
[null,347,true,1,2.0000620863460412]
[null,348,true,1,2.0000620863460412]
[null,349,true,1,2.0000620863460412]
[null,350,true,1,2.0000620863460412]
[null,351,true,1,2.0000620863460412]
[null,352,true,1,2.0000620863460412]
[null,353,true,1,2.0000620863460412]
[null,354,true,1,2.0000620863460412]
[null,355,true,1,2.0000620863460412]
[null,356,true,1,2.0000620863460412]
[null,357,true,1,2.0000620863460412]
[null,358,true,1,2.0000620863460412]
[null,359,true,1,2.0000620863460412]
[null,360,true,1,2.0000620863460412]
[null,361,true,1,2.0000620863460412]
[null,362,true,1,2.0000620863460412]
[null,363,true,1,2.0000620863460412]
[null,364,true,1,2.0000620863460412]
[null,365,true,1,2.0000620863460412]
[null,366,true,1,2.0000620863460412]
[null,367,true,1,2.0000620863460412]
[null,368,true,1,2.0000620863460412]
[null,369,true,1,2.0000620863460412]
[null,370,true,1,2.0000620863460412]
[null,371,true,1,2.0000620863460412]
[null,372,true,1,2.0000620863460412]
[null,373,true,1,2.0000620863460412]
[null,374,true,1,2.0000620863460412]
[null,375,true,1,2.0000620863460412]
[null,376,true,1,2.0000620863460412]
[null,377,true,1,2.0000620863460412]
[null,378,true,1,2.0000620863460412]
[null,379,true,1,2.0000620863460412]
[null,380,true,1,2.0000620863460412]
[null,381,true,1,2.0000620863460412]
[null,382,true,1,2.0000620863460412]
[null,383,true,1,2.0000620863460412]
[null,384,true,1,2.0000620863460412]
[null,385,true,{"$f":"ROUNDDOWN((0.5*A^E397+0.5*(2-B)^E397)^(1/E397),4)","v":1},2.0000620863460412]
[null,386,{"$f":"IF(AND(D398<=1,D398>=0.9995),TRUE,FALSE)","v":true},1,2.0000620863460412]
[null,387,true,1,2.0000620863460412]
[null,388,true,1,2.0000620863460412]
[null,389,true,1,2.0000620863460412]
[null,390,true,1,2.0000620863460412]
[null,391,true,1,2.0000620863460412]
[null,392,true,1,2.0000620863460412]
[null,393,true,1,2.0000620863460412]
[null,394,true,1,2.0000620863460412]
[null,395,true,1,2.0000620863460412]
[null,396,true,1,2.0000620863460412]
[null,397,true,1,2.0000620863460412]
[null,398,true,1,2.0000620863460412]
[null,399,true,1,2.0000620863460412]
[null,400,true,1,2.0000620863460412]
[null,401,true,1,2.0000620863460412]
[null,402,true,1,2.0000620863460412]
[null,403,true,1,2.0000620863460412]
[null,404,true,1,2.0000620863460412]
[null,405,true,1,2.0000620863460412]
[null,406,true,1,2.0000620863460412]
[null,407,true,1,2.0000620863460412]
[null,408,true,1,2.0000620863460412]
[null,409,true,1,{"$f":"IF(D420=1,E420,E420/(D420^E420))","v":2.0000620863460412}]
[null,410,true,1,2.0000620863460412]
[null,411,true,1,2.0000620863460412]
[null,412,true,1,2.0000620863460412]
[null,413,true,1,2.0000620863460412]
[null,414,true,1,2.0000620863460412]
[null,415,true,1,2.0000620863460412]
[null,416,true,1,2.0000620863460412]
[null,417,true,1,2.0000620863460412]
[null,418,true,1,2.0000620863460412]
[null,419,true,1,2.0000620863460412]
[null,420,true,1,2.0000620863460412]
[null,421,true,1,2.0000620863460412]
[null,422,true,1,2.0000620863460412]
[null,423,true,1,2.0000620863460412]
[null,424,true,1,2.0000620863460412]
[null,425,true,1,2.0000620863460412]
[null,426,true,1,2.0000620863460412]
[null,427,true,1,2.0000620863460412]
[null,428,true,1,2.0000620863460412]
[null,429,true,1,2.0000620863460412]
[null,430,true,1,2.0000620863460412]
[null,431,true,1,2.0000620863460412]
[null,432,true,1,2.0000620863460412]
[null,433,true,1,2.0000620863460412]
[null,434,true,1,2.0000620863460412]
[null,435,true,1,2.0000620863460412]
[null,436,true,1,2.0000620863460412]
[null,437,true,1,2.0000620863460412]
[null,438,true,1,2.0000620863460412]
[null,439,true,1,2.0000620863460412]
[null,440,true,1,2.0000620863460412]
[null,441,true,1,2.0000620863460412]
[null,442,true,1,2.0000620863460412]
[null,443,true,1,2.0000620863460412]
[null,444,true,1,2.0000620863460412]
[null,445,true,1,2.0000620863460412]
[null,446,true,1,{"$f":"IF(D457=1,E457,E457/(D457^E457))","v":2.0000620863460412}]
[null,447,true,1,2.0000620863460412]
[null,448,true,1,2.0000620863460412]
[null,449,true,{"$f":"ROUNDDOWN((0.5*A^E461+0.5*(2-B)^E461)^(1/E461),4)","v":1},2.0000620863460412]
[null,450,{"$f":"IF(AND(D462<=1,D462>=0.9995),TRUE,FALSE)","v":true},1,2.0000620863460412]
[null,451,true,1,2.0000620863460412]
[null,452,true,1,2.0000620863460412]
[null,453,true,1,2.0000620863460412]
[null,454,true,1,2.0000620863460412]
[null,455,true,1,2.0000620863460412]
[null,456,true,1,2.0000620863460412]
[null,457,true,1,2.0000620863460412]
[null,458,true,1,2.0000620863460412]
[null,459,true,1,2.0000620863460412]
[null,460,true,1,2.0000620863460412]
[null,461,true,1,2.0000620863460412]
[null,462,true,1,2.0000620863460412]
[null,463,true,1,2.0000620863460412]
[null,464,true,1,2.0000620863460412]
[null,465,true,1,2.0000620863460412]
[null,466,true,1,2.0000620863460412]
[null,467,true,1,2.0000620863460412]
[null,468,true,1,2.0000620863460412]
[null,469,true,1,2.0000620863460412]
[null,470,true,1,2.0000620863460412]
[null,471,true,1,2.0000620863460412]
[null,472,true,1,2.0000620863460412]
[null,473,true,1,2.0000620863460412]
[null,474,true,1,2.0000620863460412]
[null,475,true,1,2.0000620863460412]
[null,476,true,1,2.0000620863460412]
[null,477,true,1,2.0000620863460412]
[null,478,true,1,2.0000620863460412]
[null,479,true,1,2.0000620863460412]
[null,480,true,1,2.0000620863460412]
[null,481,true,1,2.0000620863460412]
[null,482,true,1,2.0000620863460412]
[null,483,true,1,2.0000620863460412]
[null,484,true,1,2.0000620863460412]
[null,485,true,1,2.0000620863460412]
[null,486,true,1,2.0000620863460412]
[null,487,true,1,2.0000620863460412]
[null,488,true,1,2.0000620863460412]
[null,489,true,1,2.0000620863460412]
[null,490,true,1,2.0000620863460412]
[null,491,true,1,2.0000620863460412]
[null,492,true,1,2.0000620863460412]
[null,493,true,1,2.0000620863460412]
[null,494,true,1,2.0000620863460412]
[null,495,true,1,2.0000620863460412]
[null,496,true,1,2.0000620863460412]
[null,497,true,1,2.0000620863460412]
[null,498,true,1,2.0000620863460412]
[null,499,true,1,2.0000620863460412]
[null,500,true,1,2.0000620863460412]
[null,501,true,1,2.0000620863460412]
[null,502,true,1,2.0000620863460412]
[null,503,true,1,2.0000620863460412]
[null,504,true,1,2.0000620863460412]
[null,505,true,1,2.0000620863460412]
[null,506,true,1,2.0000620863460412]
[null,507,true,1,2.0000620863460412]
[null,508,true,1,2.0000620863460412]
[null,509,true,1,2.0000620863460412]
[null,510,true,1,{"$f":"IF(D521=1,E521,E521/(D521^E521))","v":2.0000620863460412}]
[null,511,true,1,2.0000620863460412]
[null,512,true,1,2.0000620863460412]
[null,513,true,{"$f":"ROUNDDOWN((0.5*A^E525+0.5*(2-B)^E525)^(1/E525),4)","v":1},2.0000620863460412]
[null,514,{"$f":"IF(AND(D526<=1,D526>=0.9995),TRUE,FALSE)","v":true},1,2.0000620863460412]
[null,515,true,1,2.0000620863460412]
[null,516,true,1,2.0000620863460412]
[null,517,true,1,2.0000620863460412]
[null,518,true,1,2.0000620863460412]
[null,519,true,1,2.0000620863460412]
[null,520,true,1,2.0000620863460412]
[null,521,true,1,2.0000620863460412]
[null,522,true,1,2.0000620863460412]
[null,523,true,1,2.0000620863460412]
[null,524,true,1,2.0000620863460412]
[null,525,true,1,2.0000620863460412]
[null,526,true,1,2.0000620863460412]
[null,527,true,1,2.0000620863460412]
[null,528,true,1,2.0000620863460412]
[null,529,true,1,2.0000620863460412]
[null,530,true,1,2.0000620863460412]
[null,531,true,1,2.0000620863460412]
[null,532,true,1,2.0000620863460412]
[null,533,true,1,2.0000620863460412]
[null,534,true,1,2.0000620863460412]
[null,535,true,1,2.0000620863460412]
[null,536,true,1,2.0000620863460412]
[null,537,true,1,2.0000620863460412]
[null,538,true,1,2.0000620863460412]
[null,539,true,1,2.0000620863460412]
[null,540,true,1,2.0000620863460412]
[null,541,true,1,2.0000620863460412]
[null,542,true,1,2.0000620863460412]
[null,543,true,1,2.0000620863460412]
[null,544,true,1,2.0000620863460412]
[null,545,true,1,2.0000620863460412]
[null,546,true,1,2.0000620863460412]
[null,547,true,1,2.0000620863460412]
[null,548,true,1,2.0000620863460412]
[null,549,true,1,2.0000620863460412]
[null,550,true,1,2.0000620863460412]
[null,551,true,1,2.0000620863460412]
[null,552,true,1,2.0000620863460412]
[null,553,true,1,2.0000620863460412]
[null,554,true,1,2.0000620863460412]
[null,555,true,1,2.0000620863460412]
[null,556,true,1,2.0000620863460412]
[null,557,true,1,{"$f":"IF(D568=1,E568,E568/(D568^E568))","v":2.0000620863460412}]
[null,558,true,1,2.0000620863460412]
[null,559,true,1,2.0000620863460412]
[null,560,true,1,2.0000620863460412]
[null,561,true,1,2.0000620863460412]
[null,562,true,1,2.0000620863460412]
[null,563,true,1,2.0000620863460412]
[null,564,true,1,2.0000620863460412]
[null,565,true,1,2.0000620863460412]
[null,566,true,1,2.0000620863460412]
[null,567,true,1,2.0000620863460412]
[null,568,true,1,2.0000620863460412]
[null,569,true,1,2.0000620863460412]
[null,570,true,1,2.0000620863460412]
[null,571,true,1,2.0000620863460412]
[null,572,true,1,2.0000620863460412]
[null,573,true,1,2.0000620863460412]
[null,574,true,1,2.0000620863460412]
[null,575,true,1,2.0000620863460412]
[null,576,true,1,2.0000620863460412]
[null,577,true,{"$f":"ROUNDDOWN((0.5*A^E589+0.5*(2-B)^E589)^(1/E589),4)","v":1},2.0000620863460412]
[null,578,{"$f":"IF(AND(D590<=1,D590>=0.9995),TRUE,FALSE)","v":true},1,2.0000620863460412]
[null,579,true,1,2.0000620863460412]
[null,580,true,1,2.0000620863460412]
[null,581,true,1,2.0000620863460412]
[null,582,true,1,2.0000620863460412]
[null,583,true,1,2.0000620863460412]
[null,584,true,1,2.0000620863460412]
[null,585,true,1,2.0000620863460412]
[null,586,true,1,2.0000620863460412]
[null,587,true,1,2.0000620863460412]
[null,588,true,1,2.0000620863460412]
[null,589,true,1,2.0000620863460412]
[null,590,true,1,2.0000620863460412]
[null,591,true,1,2.0000620863460412]
[null,592,true,1,2.0000620863460412]
[null,593,true,1,2.0000620863460412]
[null,594,true,1,2.0000620863460412]
[null,595,true,1,2.0000620863460412]
[null,596,true,1,2.0000620863460412]
[null,597,true,1,2.0000620863460412]
[null,598,true,1,2.0000620863460412]
[null,599,true,1,2.0000620863460412]
[null,600,true,1,2.0000620863460412]
[null,601,true,1,2.0000620863460412]
[null,602,true,1,2.0000620863460412]
[null,603,true,1,2.0000620863460412]
[null,604,true,1,2.0000620863460412]
[null,605,true,1,2.0000620863460412]
[null,606,true,1,2.0000620863460412]
[null,607,true,1,2.0000620863460412]
[null,608,true,1,2.0000620863460412]
[null,609,true,1,2.0000620863460412]
[null,610,true,1,2.0000620863460412]
[null,611,true,1,2.0000620863460412]
[null,612,true,1,2.0000620863460412]
[null,613,true,1,2.0000620863460412]
[null,614,true,1,2.0000620863460412]
[null,615,true,1,2.0000620863460412]
[null,616,true,1,2.0000620863460412]
[null,617,true,1,2.0000620863460412]
[null,618,true,1,2.0000620863460412]
[null,619,true,1,2.0000620863460412]
[null,620,true,1,2.0000620863460412]
[null,621,true,1,{"$f":"IF(D632=1,E632,E632/(D632^E632))","v":2.0000620863460412}]
[null,622,true,1,2.0000620863460412]
[null,623,true,1,2.0000620863460412]
[null,624,true,1,2.0000620863460412]
[null,625,true,1,2.0000620863460412]
[null,626,true,1,2.0000620863460412]
[null,627,true,1,2.0000620863460412]
[null,628,true,1,2.0000620863460412]
[null,629,true,1,2.0000620863460412]
[null,630,true,1,2.0000620863460412]
[null,631,true,1,2.0000620863460412]
[null,632,true,1,2.0000620863460412]
[null,633,true,1,2.0000620863460412]
[null,634,true,1,2.0000620863460412]
[null,635,true,1,2.0000620863460412]
[null,636,true,1,2.0000620863460412]
[null,637,true,1,2.0000620863460412]
[null,638,true,1,2.0000620863460412]
[null,639,true,1,2.0000620863460412]
[null,640,true,1,2.0000620863460412]
[null,641,true,{"$f":"ROUNDDOWN((0.5*A^E653+0.5*(2-B)^E653)^(1/E653),4)","v":1},2.0000620863460412]
[null,642,{"$f":"IF(AND(D654<=1,D654>=0.9995),TRUE,FALSE)","v":true},1,2.0000620863460412]
[null,643,true,1,2.0000620863460412]
[null,644,true,1,2.0000620863460412]
[null,645,true,1,2.0000620863460412]
[null,646,true,1,2.0000620863460412]
[null,647,true,1,2.0000620863460412]
[null,648,true,1,2.0000620863460412]
[null,649,true,1,2.0000620863460412]
[null,650,true,1,2.0000620863460412]
[null,651,true,1,2.0000620863460412]
[null,652,true,1,2.0000620863460412]
[null,653,true,1,2.0000620863460412]
[null,654,true,1,2.0000620863460412]
[null,655,true,1,2.0000620863460412]
[null,656,true,1,2.0000620863460412]
[null,657,true,1,2.0000620863460412]
[null,658,true,1,2.0000620863460412]
[null,659,true,1,2.0000620863460412]
[null,660,true,1,2.0000620863460412]
[null,661,true,1,2.0000620863460412]
[null,662,true,1,2.0000620863460412]
[null,663,true,1,2.0000620863460412]
[null,664,true,1,2.0000620863460412]
[null,665,true,1,2.0000620863460412]
[null,666,true,1,2.0000620863460412]
[null,667,true,1,2.0000620863460412]
[null,668,true,1,2.0000620863460412]
[null,669,true,1,2.0000620863460412]
[null,670,true,1,2.0000620863460412]
[null,671,true,1,2.0000620863460412]
[null,672,true,1,2.0000620863460412]
[null,673,true,1,2.0000620863460412]
[null,674,true,1,2.0000620863460412]
[null,675,true,1,2.0000620863460412]
[null,676,true,1,2.0000620863460412]
[null,677,true,1,2.0000620863460412]
[null,678,true,1,2.0000620863460412]
[null,679,true,1,2.0000620863460412]
[null,680,true,1,2.0000620863460412]
[null,681,true,1,2.0000620863460412]
[null,682,true,1,2.0000620863460412]
[null,683,true,1,2.0000620863460412]
[null,684,true,1,2.0000620863460412]
[null,685,true,1,{"$f":"IF(D696=1,E696,E696/(D696^E696))","v":2.0000620863460412}]
[null,686,true,1,2.0000620863460412]
[null,687,true,1,2.0000620863460412]
[null,688,true,1,2.0000620863460412]
[null,689,true,1,2.0000620863460412]
[null,690,true,1,2.0000620863460412]
[null,691,true,1,2.0000620863460412]
[null,692,true,1,2.0000620863460412]
[null,693,true,1,2.0000620863460412]
[null,694,true,1,2.0000620863460412]
[null,695,true,1,2.0000620863460412]
[null,696,true,1,2.0000620863460412]
[null,697,true,1,2.0000620863460412]
[null,698,true,1,2.0000620863460412]
[null,699,true,1,2.0000620863460412]
[null,700,true,1,2.0000620863460412]
[null,701,true,1,2.0000620863460412]
[null,702,true,1,2.0000620863460412]
[null,703,true,1,2.0000620863460412]
[null,704,true,1,2.0000620863460412]
[null,705,true,{"$f":"ROUNDDOWN((0.5*A^E717+0.5*(2-B)^E717)^(1/E717),4)","v":1},2.0000620863460412]
[null,706,{"$f":"IF(AND(D718<=1,D718>=0.9995),TRUE,FALSE)","v":true},1,2.0000620863460412]
[null,707,true,1,2.0000620863460412]
[null,708,true,1,2.0000620863460412]
[null,709,true,1,2.0000620863460412]
[null,710,true,1,2.0000620863460412]
[null,711,true,1,2.0000620863460412]
[null,712,true,1,2.0000620863460412]
[null,713,true,1,2.0000620863460412]
[null,714,true,1,2.0000620863460412]
[null,715,true,1,2.0000620863460412]
[null,716,true,1,2.0000620863460412]
[null,717,true,1,2.0000620863460412]
[null,718,true,1,2.0000620863460412]
[null,719,true,1,2.0000620863460412]
[null,720,true,1,2.0000620863460412]
[null,721,true,1,2.0000620863460412]
[null,722,true,1,2.0000620863460412]
[null,723,true,1,2.0000620863460412]
[null,724,true,1,2.0000620863460412]
[null,725,true,1,2.0000620863460412]
[null,726,true,1,2.0000620863460412]
[null,727,true,1,2.0000620863460412]
[null,728,true,1,2.0000620863460412]
[null,729,true,1,2.0000620863460412]
[null,730,true,1,2.0000620863460412]
[null,731,true,1,2.0000620863460412]
[null,732,true,1,2.0000620863460412]
[null,733,true,1,2.0000620863460412]
[null,734,true,1,2.0000620863460412]
[null,735,true,1,2.0000620863460412]
[null,736,true,1,2.0000620863460412]
[null,737,true,1,2.0000620863460412]
[null,738,true,1,2.0000620863460412]
[null,739,true,1,2.0000620863460412]
[null,740,true,1,2.0000620863460412]
[null,741,true,1,2.0000620863460412]
[null,742,true,1,2.0000620863460412]
[null,743,true,1,2.0000620863460412]
[null,744,true,1,2.0000620863460412]
[null,745,true,1,2.0000620863460412]
[null,746,true,1,2.0000620863460412]
[null,747,true,1,2.0000620863460412]
[null,748,true,1,2.0000620863460412]
[null,749,true,1,{"$f":"IF(D760=1,E760,E760/(D760^E760))","v":2.0000620863460412}]
[null,750,true,1,2.0000620863460412]
[null,751,true,1,2.0000620863460412]
[null,752,true,1,2.0000620863460412]
[null,753,true,1,2.0000620863460412]
[null,754,true,1,2.0000620863460412]
[null,755,true,1,2.0000620863460412]
[null,756,true,1,2.0000620863460412]
[null,757,true,1,2.0000620863460412]
[null,758,true,1,2.0000620863460412]
[null,759,true,1,2.0000620863460412]
[null,760,true,1,2.0000620863460412]
[null,761,true,1,2.0000620863460412]
[null,762,true,1,2.0000620863460412]
[null,763,true,1,2.0000620863460412]
[null,764,true,1,2.0000620863460412]
[null,765,true,1,2.0000620863460412]
[null,766,true,1,2.0000620863460412]
[null,767,true,1,2.0000620863460412]
[null,768,true,1,2.0000620863460412]
[null,769,true,{"$f":"ROUNDDOWN((0.5*A^E781+0.5*(2-B)^E781)^(1/E781),4)","v":1},2.0000620863460412]
[null,770,{"$f":"IF(AND(D782<=1,D782>=0.9995),TRUE,FALSE)","v":true},1,2.0000620863460412]
[null,771,true,1,2.0000620863460412]
[null,772,true,1,2.0000620863460412]
[null,773,true,1,2.0000620863460412]
[null,774,true,1,2.0000620863460412]
[null,775,true,1,2.0000620863460412]
[null,776,true,1,2.0000620863460412]
[null,777,true,1,2.0000620863460412]
[null,778,true,1,2.0000620863460412]
[null,779,true,1,2.0000620863460412]
[null,780,true,1,2.0000620863460412]
[null,781,true,1,2.0000620863460412]
[null,782,true,1,2.0000620863460412]
[null,783,true,1,2.0000620863460412]
[null,784,true,1,2.0000620863460412]
[null,785,true,1,2.0000620863460412]
[null,786,true,1,2.0000620863460412]
[null,787,true,1,2.0000620863460412]
[null,788,true,1,2.0000620863460412]
[null,789,true,1,2.0000620863460412]
[null,790,true,1,2.0000620863460412]
[null,791,true,1,2.0000620863460412]
[null,792,true,1,2.0000620863460412]
[null,793,true,1,2.0000620863460412]
[null,794,true,1,2.0000620863460412]
[null,795,true,1,2.0000620863460412]
[null,796,true,1,2.0000620863460412]
[null,797,true,1,2.0000620863460412]
[null,798,true,1,2.0000620863460412]
[null,799,true,1,2.0000620863460412]
[null,800,true,1,2.0000620863460412]
[null,801,true,1,2.0000620863460412]
[null,802,true,1,2.0000620863460412]
[null,803,true,1,2.0000620863460412]
[null,804,true,1,2.0000620863460412]
[null,805,true,1,2.0000620863460412]
[null,806,true,1,2.0000620863460412]
[null,807,true,1,2.0000620863460412]
[null,808,true,1,2.0000620863460412]
[null,809,true,1,2.0000620863460412]
[null,810,true,1,2.0000620863460412]
[null,811,true,1,2.0000620863460412]
[null,812,true,1,2.0000620863460412]
[null,813,true,1,{"$f":"IF(D824=1,E824,E824/(D824^E824))","v":2.0000620863460412}]
[null,814,true,1,2.0000620863460412]
[null,815,true,1,2.0000620863460412]
[null,816,true,1,2.0000620863460412]
[null,817,true,1,2.0000620863460412]
[null,818,true,1,2.0000620863460412]
[null,819,true,1,2.0000620863460412]
[null,820,true,1,2.0000620863460412]
[null,821,true,1,2.0000620863460412]
[null,822,true,1,2.0000620863460412]
[null,823,true,1,2.0000620863460412]
[null,824,true,1,2.0000620863460412]
[null,825,true,1,2.0000620863460412]
[null,826,true,1,2.0000620863460412]
[null,827,true,1,2.0000620863460412]
[null,828,true,1,2.0000620863460412]
[null,829,true,1,2.0000620863460412]
[null,830,true,1,2.0000620863460412]
[null,831,true,1,2.0000620863460412]
[null,832,true,1,2.0000620863460412]
[null,833,true,{"$f":"ROUNDDOWN((0.5*A^E845+0.5*(2-B)^E845)^(1/E845),4)","v":1},2.0000620863460412]
[null,834,{"$f":"IF(AND(D846<=1,D846>=0.9995),TRUE,FALSE)","v":true},1,2.0000620863460412]
[null,835,true,1,2.0000620863460412]
[null,836,true,1,2.0000620863460412]
[null,837,true,1,2.0000620863460412]
[null,838,true,1,2.0000620863460412]
[null,839,true,1,2.0000620863460412]
[null,840,true,1,2.0000620863460412]
[null,841,true,1,2.0000620863460412]
[null,842,true,1,2.0000620863460412]
[null,843,true,1,2.0000620863460412]
[null,844,true,1,2.0000620863460412]
[null,845,true,1,2.0000620863460412]
[null,846,true,1,2.0000620863460412]
[null,847,true,1,2.0000620863460412]
[null,848,true,1,2.0000620863460412]
[null,849,true,1,2.0000620863460412]
[null,850,true,1,2.0000620863460412]
[null,851,true,1,2.0000620863460412]
[null,852,true,1,2.0000620863460412]
[null,853,true,1,2.0000620863460412]
[null,854,true,1,2.0000620863460412]
[null,855,true,1,2.0000620863460412]
[null,856,true,1,2.0000620863460412]
[null,857,true,1,2.0000620863460412]
[null,858,true,1,2.0000620863460412]
[null,859,true,1,2.0000620863460412]
[null,860,true,1,2.0000620863460412]
[null,861,true,1,2.0000620863460412]
[null,862,true,1,2.0000620863460412]
[null,863,true,1,2.0000620863460412]
[null,864,true,1,2.0000620863460412]
[null,865,true,1,2.0000620863460412]
[null,866,true,1,2.0000620863460412]
[null,867,true,1,2.0000620863460412]
[null,868,true,1,2.0000620863460412]
[null,869,true,1,2.0000620863460412]
[null,870,true,1,2.0000620863460412]
[null,871,true,1,2.0000620863460412]
[null,872,true,1,2.0000620863460412]
[null,873,true,1,2.0000620863460412]
[null,874,true,1,2.0000620863460412]
[null,875,true,1,2.0000620863460412]
[null,876,true,1,2.0000620863460412]
[null,877,true,1,{"$f":"IF(D888=1,E888,E888/(D888^E888))","v":2.0000620863460412}]
[null,878,true,1,2.0000620863460412]
[null,879,true,1,2.0000620863460412]
[null,880,true,1,2.0000620863460412]
[null,881,true,1,2.0000620863460412]
[null,882,true,1,2.0000620863460412]
[null,883,true,1,2.0000620863460412]
[null,884,true,1,2.0000620863460412]
[null,885,true,1,2.0000620863460412]
[null,886,true,1,2.0000620863460412]
[null,887,true,1,2.0000620863460412]
[null,888,true,1,2.0000620863460412]
[null,889,true,1,2.0000620863460412]
[null,890,true,1,2.0000620863460412]
[null,891,true,1,2.0000620863460412]
[null,892,true,1,2.0000620863460412]
[null,893,true,1,2.0000620863460412]
[null,894,true,1,2.0000620863460412]
[null,895,true,1,2.0000620863460412]
[null,896,true,1,2.0000620863460412]
[null,897,true,{"$f":"ROUNDDOWN((0.5*A^E909+0.5*(2-B)^E909)^(1/E909),4)","v":1},2.0000620863460412]
[null,898,{"$f":"IF(AND(D910<=1,D910>=0.9995),TRUE,FALSE)","v":true},1,2.0000620863460412]
[null,899,true,1,2.0000620863460412]
[null,900,true,1,2.0000620863460412]
[null,901,true,1,2.0000620863460412]
[null,902,true,1,2.0000620863460412]
[null,903,true,1,2.0000620863460412]
[null,904,true,1,2.0000620863460412]
[null,905,true,1,2.0000620863460412]
[null,906,true,1,2.0000620863460412]
[null,907,true,1,2.0000620863460412]
[null,908,true,1,2.0000620863460412]
[null,909,true,1,2.0000620863460412]
[null,910,true,1,2.0000620863460412]
[null,911,true,1,2.0000620863460412]
[null,912,true,1,2.0000620863460412]
[null,913,true,1,2.0000620863460412]
[null,914,true,1,2.0000620863460412]
[null,915,true,1,2.0000620863460412]
[null,916,true,1,2.0000620863460412]
[null,917,true,1,2.0000620863460412]
[null,918,true,1,2.0000620863460412]
[null,919,true,1,2.0000620863460412]
[null,920,true,1,2.0000620863460412]
[null,921,true,1,2.0000620863460412]
[null,922,true,1,2.0000620863460412]
[null,923,true,1,2.0000620863460412]
[null,924,true,1,2.0000620863460412]
[null,925,true,1,2.0000620863460412]
[null,926,true,1,2.0000620863460412]
[null,927,true,1,2.0000620863460412]
[null,928,true,1,2.0000620863460412]
[null,929,true,1,2.0000620863460412]
[null,930,true,1,2.0000620863460412]
[null,931,true,1,2.0000620863460412]
[null,932,true,1,2.0000620863460412]
[null,933,true,1,2.0000620863460412]
[null,934,true,1,2.0000620863460412]
[null,935,true,1,2.0000620863460412]
[null,936,true,1,2.0000620863460412]
[null,937,true,1,2.0000620863460412]
[null,938,true,1,2.0000620863460412]
[null,939,true,1,2.0000620863460412]
[null,940,true,1,2.0000620863460412]
[null,941,true,1,{"$f":"IF(D952=1,E952,E952/(D952^E952))","v":2.0000620863460412}]
[null,942,true,1,2.0000620863460412]
[null,943,true,1,2.0000620863460412]
[null,944,true,1,2.0000620863460412]
[null,945,true,1,2.0000620863460412]
[null,946,true,1,2.0000620863460412]
[null,947,true,1,2.0000620863460412]
[null,948,true,1,2.0000620863460412]
[null,949,true,1,2.0000620863460412]
[null,950,true,1,2.0000620863460412]
[null,951,true,1,2.0000620863460412]
[null,952,true,1,2.0000620863460412]
[null,953,true,1,2.0000620863460412]
[null,954,true,1,2.0000620863460412]
[null,955,true,1,2.0000620863460412]
[null,956,true,1,2.0000620863460412]
[null,957,true,1,2.0000620863460412]
[null,958,true,1,2.0000620863460412]
[null,959,true,1,2.0000620863460412]
[null,960,true,1,2.0000620863460412]
[null,961,true,{"$f":"ROUNDDOWN((0.5*A^E973+0.5*(2-B)^E973)^(1/E973),4)","v":1},2.0000620863460412]
[null,962,{"$f":"IF(AND(D974<=1,D974>=0.9995),TRUE,FALSE)","v":true},1,2.0000620863460412]
[null,963,true,1,2.0000620863460412]
[null,964,true,1,2.0000620863460412]
[null,965,true,1,2.0000620863460412]
[null,966,true,1,2.0000620863460412]
[null,967,true,1,2.0000620863460412]
[null,968,true,1,2.0000620863460412]
[null,969,true,1,2.0000620863460412]
[null,970,true,1,2.0000620863460412]
[null,971,true,1,2.0000620863460412]
[null,972,true,1,2.0000620863460412]
[null,973,true,1,2.0000620863460412]
[null,974,true,1,2.0000620863460412]
[null,975,true,1,2.0000620863460412]
[null,976,true,1,2.0000620863460412]
[null,977,true,1,2.0000620863460412]
[null,978,true,1,2.0000620863460412]
[null,979,true,1,2.0000620863460412]
[null,980,true,1,2.0000620863460412]
[null,981,true,1,2.0000620863460412]
[null,982,true,1,2.0000620863460412]
[null,983,true,1,2.0000620863460412]
[null,984,true,1,2.0000620863460412]
[null,985,true,1,2.0000620863460412]
[null,986,true,1,2.0000620863460412]
[null,987,true,1,2.0000620863460412]
[null,988,true,1,2.0000620863460412]
[null,989,true,1,2.0000620863460412]
[null,990,true,1,2.0000620863460412]
[null,991,true,1,2.0000620863460412]
[null,992,true,1,{"$f":"IF(D1003=1,E1003,E1003/(D1003^E1003))","v":2.0000620863460412}]
[null,993,true,1,{"$f":"IF(D1004=1,E1004,E1004/(D1004^E1004))","v":2.0000620863460412}]
[null,994,true,1,{"$f":"IF(D1005=1,E1005,E1005/(D1005^E1005))","v":2.0000620863460412}]
[null,995,true,1,{"$f":"IF(D1006=1,E1006,E1006/(D1006^E1006))","v":2.0000620863460412}]
[null,996,true,1,2.0000620863460412]
[null,997,true,1,2.0000620863460412]
[null,998,true,1,2.0000620863460412]
[null,999,true,1,2.0000620863460412]
[null,1000,true,1,2.0000620863460412]

{"sheet":"DATA","index":7,"n_rows":47,"n_cols":27,"rows_kept":47,"cut":false,"hidden":true,"merged":[[1,1,3,4],[8,2,9,9]]}
[]
[null,"Hulpdata Grafiek Superformule"]
[]
[]
[]
[null,"Hulpvelden"]
[null,"Uw inschrijving",{"$f":"+'BPK-Grafiek'!$F$9","v":0},{"$f":"+'BPK-Grafiek'!$F$14","v":150},{"$f":"IFERROR((0.5*($C$7/$G$38)^$F$38+0.5*(2-$D$7/$H$38)^$F$38)^(1/$F$38),0)","v":0.88388347648318444},{"$f":"+D7/G40*100","v":60}]
[]
[null,"LET OP  !!!","Voordat de TAB-bladen \"TBV PRIJSMODEL (1)\" EN \"TBV PRIJSMODEL (2)\" gekopieerd worden kan naar het Prijsmodel, moeten eerst onderstaande waarden ( oranje velden ) worden geselecteerd en worden gekopieerd en geplakt worden als WAARDEN (ctrl-C, plakken speciaal \"waarden\")"]
[]
[null,"EVMI-punten","P ","Q","EMVI"]
[null,"Ref",{"$f":"$G$38","v":100000},{"$f":"$H$38","v":200},{"$f":"IFERROR((0.5*($C$12/$G$38)^$F$38+0.5*(2-$D$12/$H$38)^$F$38)^(1/$F$38),0)","v":1}]
[null,"Ref (boven)",{"$f":"+'HULP-velden'!$J$23","v":119895.78808281798},{"$f":"$G$40","v":250},{"$f":"IFERROR((0.5*($C$13/$G$38)^$F$38+0.5*(2-$D$13/$H$38)^$F$38)^(1/$F$38),0)","v":1}]
[null,"Ref (onder)",0,{"$f":"'HULP-velden'!$L$18","v":117.15728752538097},{"$f":"IFERROR((0.5*(C14/$G$38)^$F$38+0.5*(2-D14/$H$38)^$F$38)^(1/$F$38),0)","v":1}]
[]
[null,"EMVI-lijnen"]
[null,null,"hulp=Q bij P=0",{"$f":"'HULP-velden'!P7","v":0},{"$f":"'HULP-velden'!Q7","v":1.2500000000000001E-2},{"$f":"'HULP-velden'!R7","v":2.5000000000000001E-2},{"$f":"'HULP-velden'!S7","v":0.05},{"$f":"'HULP-velden'!T7","v":0.1},{"$f":"'HULP-velden'!U7","v":0.15},{"$f":"'HULP-velden'!V7","v":0.2},{"$f":"'HULP-velden'!W7","v":0.25},{"$f":"'HULP-velden'!X7","v":0.3},{"$f":"'HULP-velden'!Y7","v":0.35},{"$f":"'HULP-velden'!Z7","v":0.4},{"$f":"'HULP-velden'!AA7","v":0.45},{"$f":"'HULP-velden'!AB7","v":0.5},{"$f":"'HULP-velden'!AC7","v":0.55000000000000004},{"$f":"'HULP-velden'!AD7","v":0.6},{"$f":"'HULP-velden'!AE7","v":0.65},{"$f":"'HULP-velden'!AF7","v":0.7},{"$f":"'HULP-velden'!AG7","v":0.75},{"$f":"'HULP-velden'!AH7","v":0.8},{"$f":"'HULP-velden'!AI7","v":0.85},{"$f":"'HULP-velden'!AJ7","v":0.9},{"$f":"'HULP-velden'!AK7","v":0.95},{"$f":"'HULP-velden'!AL7","v":1},0]
[null,"Q berekend bij P=0 en EMVI=1",{"$f":"'HULP-velden'!O8","v":117.15728752538097},{"$f":"'HULP-velden'!P8","v":117.15728752538097},{"$f":"'HULP-velden'!Q8","v":118.8178214313137},{"$f":"'HULP-velden'!R8","v":120.47835533724644},{"$f":"'HULP-velden'!S8","v":123.79942314911192},{"$f":"'HULP-velden'!T8","v":130.44155877284288},{"$f":"'HULP-velden'!U8","v":137.08369439657383},{"$f":"'HULP-velden'!V8","v":143.72583002030478},{"$f":"'HULP-velden'!W8","v":150.36796564403573},{"$f":"'HULP-velden'!X8","v":157.01010126776669},{"$f":"'HULP-velden'!Y8","v":163.65223689149764},{"$f":"'HULP-velden'!Z8","v":170.29437251522859},{"$f":"'HULP-velden'!AA8","v":176.93650813895954},{"$f":"'HULP-velden'!AB8","v":183.57864376269049},{"$f":"'HULP-velden'!AC8","v":190.22077938642144},{"$f":"'HULP-velden'!AD8","v":196.86291501015239},{"$f":"'HULP-velden'!AE8","v":203.50505063388334},{"$f":"'HULP-velden'!AF8","v":210.14718625761429},{"$f":"'HULP-velden'!AG8","v":216.78932188134524},{"$f":"'HULP-velden'!AH8","v":223.4314575050762},{"$f":"'HULP-velden'!AI8","v":230.07359312880715},{"$f":"'HULP-velden'!AJ8","v":236.7157287525381},{"$f":"'HULP-velden'!AK8","v":243.35786437626905},{"$f":"'HULP-velden'!AL8","v":250},"EMVI"]
[null,"P berekend uit Q en EMVI=1",null,{"$f":"'HULP-velden'!P9","v":0},{"$f":"'HULP-velden'!Q9","v":15301.817337880153},{"$f":"'HULP-velden'!R9","v":21608.159136246002},{"$f":"'HULP-velden'!S9","v":30468.185650103391},{"$f":"'HULP-velden'!T9","v":42831.783651820129},{"$f":"'HULP-velden'!U9","v":52141.672987749946},{"$f":"'HULP-velden'!V9","v":59840.516795099422},{"$f":"'HULP-velden'!W9","v":66490.314000053171},{"$f":"'HULP-velden'!X9","v":72380.77975902686},{"$f":"'HULP-velden'!Y9","v":77684.835833010613},{"$f":"'HULP-velden'!Z9","v":82515.642004754831},{"$f":"'HULP-velden'!AA9","v":86952.111243430321},{"$f":"'HULP-velden'!AB9","v":91051.90355561435},{"$f":"'HULP-velden'!AC9","v":94858.682521369032},{"$f":"'HULP-velden'!AD9","v":98406.45901289639},{"$f":"'HULP-velden'!AE9","v":101722.33637899699},{"$f":"'HULP-velden'!AF9","v":104828.3228832969},{"$f":"'HULP-velden'!AG9","v":107742.57216080221},{"$f":"'HULP-velden'!AH9","v":110480.25819260458},{"$f":"'HULP-velden'!AI9","v":113054.20851061429},{"$f":"'HULP-velden'!AJ9","v":115475.37265926583},{"$f":"'HULP-velden'!AK9","v":117753.17548503382},{"$f":"'HULP-velden'!AL9","v":119895.78808281798},1]
[null,null,null,{"$f":"'HULP-velden'!P10","v":46.862915010152385},{"$f":"'HULP-velden'!Q10","v":47.527128572525477},{"$f":"'HULP-velden'!R10","v":48.191342134898576},{"$f":"'HULP-velden'!S10","v":49.519769259644768},{"$f":"'HULP-velden'!T10","v":52.176623509137151},{"$f":"'HULP-velden'!U10","v":54.833477758629535},{"$f":"'HULP-velden'!V10","v":57.490332008121911},{"$f":"'HULP-velden'!W10","v":60.147186257614294},{"$f":"'HULP-velden'!X10","v":62.80404050710667},{"$f":"'HULP-velden'!Y10","v":65.460894756599046},{"$f":"'HULP-velden'!Z10","v":68.117749006091429},{"$f":"'HULP-velden'!AA10","v":70.774603255583813},{"$f":"'HULP-velden'!AB10","v":73.431457505076196},{"$f":"'HULP-velden'!AC10","v":76.088311754568565},{"$f":"'HULP-velden'!AD10","v":78.745166004060948},{"$f":"'HULP-velden'!AE10","v":81.402020253553346},{"$f":"'HULP-velden'!AF10","v":84.058874503045729},{"$f":"'HULP-velden'!AG10","v":86.715728752538098},{"$f":"'HULP-velden'!AH10","v":89.372583002030481},{"$f":"'HULP-velden'!AI10","v":92.029437251522864},{"$f":"'HULP-velden'!AJ10","v":94.686291501015234},{"$f":"'HULP-velden'!AK10","v":97.343145750507617},{"$f":"'HULP-velden'!AL10","v":100},0]
[null,"Q berekend bij P=0 en EMVI=0,9",{"$f":"'HULP-velden'!O11","v":145.44155877284285},{"$f":"'HULP-velden'!P11","v":145.44155877284285},{"$f":"'HULP-velden'!Q11","v":146.74853928818231},{"$f":"'HULP-velden'!R11","v":148.05551980352178},{"$f":"'HULP-velden'!S11","v":150.6694808342007},{"$f":"'HULP-velden'!T11","v":155.89740289555857},{"$f":"'HULP-velden'!U11","v":161.12532495691642},{"$f":"'HULP-velden'!V11","v":166.35324701827429},{"$f":"'HULP-velden'!W11","v":171.58116907963213},{"$f":"'HULP-velden'!X11","v":176.80909114099001},{"$f":"'HULP-velden'!Y11","v":182.03701320234785},{"$f":"'HULP-velden'!Z11","v":187.26493526370572},{"$f":"'HULP-velden'!AA11","v":192.49285732506357},{"$f":"'HULP-velden'!AB11","v":197.72077938642144},{"$f":"'HULP-velden'!AC11","v":202.94870144777929},{"$f":"'HULP-velden'!AD11","v":208.17662350913713},{"$f":"'HULP-velden'!AE11","v":213.404545570495},{"$f":"'HULP-velden'!AF11","v":218.63246763185285},{"$f":"'HULP-velden'!AG11","v":223.86038969321072},{"$f":"'HULP-velden'!AH11","v":229.08831175456856},{"$f":"'HULP-velden'!AI11","v":234.31623381592641},{"$f":"'HULP-velden'!AJ11","v":239.54415587728428},{"$f":"'HULP-velden'!AK11","v":244.77207793864216},{"$f":"'HULP-velden'!AL11","v":250},"EMVI"]
[null,"P berekend uit Q en EMVI=0,9",null,{"$f":"'HULP-velden'!P12","v":0},{"$f":"'HULP-velden'!Q12","v":12881.165002928316},{"$f":"'HULP-velden'!R12","v":18193.260417847021},{"$f":"'HULP-velden'!S12","v":25662.678214252082},{"$f":"'HULP-velden'!T12","v":36103.746643758241},{"$f":"'HULP-velden'!U12","v":43985.4794877276},{"$f":"'HULP-velden'!V12","v":50520.280138515802},{"$f":"'HULP-velden'!W12","v":56180.151479353422},{"$f":"'HULP-velden'!X12","v":61208.288251447426},{"$f":"'HULP-velden'!Y12","v":65749.784003916153},{"$f":"'HULP-velden'!Z12","v":69899.556922137737},{"$f":"'HULP-velden'!AA12","v":73723.784728680999},{"$f":"'HULP-velden'!AB12","v":77270.817434467477},{"$f":"'HULP-velden'!AC12","v":80577.269963190585},{"$f":"'HULP-velden'!AD12","v":83671.668191277087},{"$f":"'HULP-velden'!AE12","v":86576.75263349645},{"$f":"'HULP-velden'!AF12","v":89310.999046434794},{"$f":"'HULP-velden'!AG12","v":91889.658940726862},{"$f":"'HULP-velden'!AH12","v":94325.493400639651},{"$f":"'HULP-velden'!AI12","v":96629.304073688269},{"$f":"'HULP-velden'!AJ12","v":98810.32598730101},{"$f":"'HULP-velden'!AK12","v":100876.52379581808},{"$f":"'HULP-velden'!AL12","v":102834.81900601568},0.9]
[null,null,null,{"$f":"'HULP-velden'!P13","v":58.176623509137137},{"$f":"'HULP-velden'!Q13","v":58.699415715272927},{"$f":"'HULP-velden'!R13","v":59.22220792140871},{"$f":"'HULP-velden'!S13","v":60.267792333680283},{"$f":"'HULP-velden'!T13","v":62.358961158223423},{"$f":"'HULP-velden'!U13","v":64.450129982766569},{"$f":"'HULP-velden'!V13","v":66.541298807309715},{"$f":"'HULP-velden'!W13","v":68.632467631852862},{"$f":"'HULP-velden'!X13","v":70.723636456395994},{"$f":"'HULP-velden'!Y13","v":72.81480528093914},{"$f":"'HULP-velden'!Z13","v":74.905974105482287},{"$f":"'HULP-velden'!AA13","v":76.997142930025433},{"$f":"'HULP-velden'!AB13","v":79.088311754568579},{"$f":"'HULP-velden'!AC13","v":81.179480579111711},{"$f":"'HULP-velden'!AD13","v":83.270649403654858},{"$f":"'HULP-velden'!AE13","v":85.361818228198004},{"$f":"'HULP-velden'!AF13","v":87.452987052741136},{"$f":"'HULP-velden'!AG13","v":89.544155877284297},{"$f":"'HULP-velden'!AH13","v":91.635324701827429},{"$f":"'HULP-velden'!AI13","v":93.726493526370575},{"$f":"'HULP-velden'!AJ13","v":95.817662350913707},{"$f":"'HULP-velden'!AK13","v":97.908831175456868},{"$f":"'HULP-velden'!AL13","v":100},0]
[null,"Q berekend bij P=0 en EMVI=0,8",{"$f":"'HULP-velden'!O14","v":173.72583002030476},{"$f":"'HULP-velden'!P14","v":173.72583002030476},{"$f":"'HULP-velden'!Q14","v":174.67925714505094},{"$f":"'HULP-velden'!R14","v":175.63268426979712},{"$f":"'HULP-velden'!S14","v":177.53953851928952},{"$f":"'HULP-velden'!T14","v":181.35324701827429},{"$f":"'HULP-velden'!U14","v":185.16695551725905},{"$f":"'HULP-velden'!V14","v":188.98066401624379},{"$f":"'HULP-velden'!W14","v":192.79437251522856},{"$f":"'HULP-velden'!X14","v":196.60808101421333},{"$f":"'HULP-velden'!Y14","v":200.42178951319809},{"$f":"'HULP-velden'!Z14","v":204.23549801218286},{"$f":"'HULP-velden'!AA14","v":208.04920651116763},{"$f":"'HULP-velden'!AB14","v":211.86291501015239},{"$f":"'HULP-velden'!AC14","v":215.67662350913713},{"$f":"'HULP-velden'!AD14","v":219.4903320081219},{"$f":"'HULP-velden'!AE14","v":223.30404050710666},{"$f":"'HULP-velden'!AF14","v":227.11774900609143},{"$f":"'HULP-velden'!AG14","v":230.9314575050762},{"$f":"'HULP-velden'!AH14","v":234.74516600406096},{"$f":"'HULP-velden'!AI14","v":238.55887450304573},{"$f":"'HULP-velden'!AJ14","v":242.37258300203047},{"$f":"'HULP-velden'!AK14","v":246.18629150101523},{"$f":"'HULP-velden'!AL14","v":250},"EMVI"]
[null,"P berekend uit Q en EMVI=0,8",null,{"$f":"'HULP-velden'!P15","v":0},{"$f":"'HULP-velden'!Q15","v":10375.004087877855},{"$f":"'HULP-velden'!R15","v":14656.974722154282},{"$f":"'HULP-velden'!S15","v":20684.191293046271},{"$f":"'HULP-velden'!T15","v":29127.295662952594},{"$f":"'HULP-velden'!U15","v":35520.286451113658},{"$f":"'HULP-velden'!V15","v":40837.604731958207},{"$f":"'HULP-velden'!W15","v":45458.299403525169},{"$f":"'HULP-velden'!X15","v":49577.53344832515},{"$f":"'HULP-velden'!Y15","v":53311.67296869844},{"$f":"'HULP-velden'!Z15","v":56736.804107787808},{"$f":"'HULP-velden'!AA15","v":59905.953124475927},{"$f":"'HULP-velden'!AB15","v":62857.850049780718},{"$f":"'HULP-velden'!AC15","v":65621.819692476594},{"$f":"'HULP-velden'!AD15","v":68220.707562773692},{"$f":"'HULP-velden'!AE15","v":70672.727941699355},{"$f":"'HULP-velden'!AF15","v":72992.683351277083},{"$f":"'HULP-velden'!AG15","v":75192.798755336509},{"$f":"'HULP-velden'!AH15","v":77283.309713311712},{"$f":"'HULP-velden'!AI15","v":79272.887859401002},{"$f":"'HULP-velden'!AJ15","v":81168.955596564498},{"$f":"'HULP-velden'!AK15","v":82977.923385966584},{"$f":"'HULP-velden'!AL15","v":84705.371730487095},0.8]
[null,null,null,{"$f":"'HULP-velden'!P16","v":69.490332008121896},{"$f":"'HULP-velden'!Q16","v":69.871702858020384},{"$f":"'HULP-velden'!R16","v":70.253073707918844},{"$f":"'HULP-velden'!S16","v":71.015815407715806},{"$f":"'HULP-velden'!T16","v":72.541298807309715},{"$f":"'HULP-velden'!U16","v":74.066782206903625},{"$f":"'HULP-velden'!V16","v":75.59226560649752},{"$f":"'HULP-velden'!W16","v":77.117749006091415},{"$f":"'HULP-velden'!X16","v":78.643232405685325},{"$f":"'HULP-velden'!Y16","v":80.168715805279234},{"$f":"'HULP-velden'!Z16","v":81.694199204873144},{"$f":"'HULP-velden'!AA16","v":83.219682604467053},{"$f":"'HULP-velden'!AB16","v":84.745166004060962},{"$f":"'HULP-velden'!AC16","v":86.270649403654858},{"$f":"'HULP-velden'!AD16","v":87.796132803248767},{"$f":"'HULP-velden'!AE16","v":89.321616202842662},{"$f":"'HULP-velden'!AF16","v":90.847099602436572},{"$f":"'HULP-velden'!AG16","v":92.372583002030481},{"$f":"'HULP-velden'!AH16","v":93.898066401624376},{"$f":"'HULP-velden'!AI16","v":95.423549801218286},{"$f":"'HULP-velden'!AJ16","v":96.949033200812181},{"$f":"'HULP-velden'!AK16","v":98.474516600406091},{"$f":"'HULP-velden'!AL16","v":100}," "]
[null,"Q berekend bij P=0 en EMVI=0,7",{"$f":"'HULP-velden'!O17","v":202.01010126776669},{"$f":"'HULP-velden'!P17","v":202.01010126776669},{"$f":"'HULP-velden'!Q17","v":202.60997500191959},{"$f":"'HULP-velden'!R17","v":203.20984873607253},{"$f":"'HULP-velden'!S17","v":204.40959620437835},{"$f":"'HULP-velden'!T17","v":206.80909114099001},{"$f":"'HULP-velden'!U17","v":209.20858607760169},{"$f":"'HULP-velden'!V17","v":211.60808101421335},{"$f":"'HULP-velden'!W17","v":214.00757595082501},{"$f":"'HULP-velden'!X17","v":216.40707088743667},{"$f":"'HULP-velden'!Y17","v":218.80656582404833},{"$f":"'HULP-velden'!Z17","v":221.20606076066002},{"$f":"'HULP-velden'!AA17","v":223.60555569727168},{"$f":"'HULP-velden'!AB17","v":226.00505063388334},{"$f":"'HULP-velden'!AC17","v":228.404545570495},{"$f":"'HULP-velden'!AD17","v":230.80404050710666},{"$f":"'HULP-velden'!AE17","v":233.20353544371835},{"$f":"'HULP-velden'!AF17","v":235.60303038033001},{"$f":"'HULP-velden'!AG17","v":238.00252531694167},{"$f":"'HULP-velden'!AH17","v":240.40202025355333},{"$f":"'HULP-velden'!AI17","v":242.80151519016499},{"$f":"'HULP-velden'!AJ17","v":245.20101012677668},{"$f":"'HULP-velden'!AK17","v":247.60050506338834},{"$f":"'HULP-velden'!AL17","v":250},"EMVI"]
[null,"P berekend uit Q en EMVI=0,7",null,{"$f":"'HULP-velden'!P18","v":0},{"$f":"'HULP-velden'!Q18","v":7700.2927096505246},{"$f":"'HULP-velden'!R18","v":10881.594156195002},{"$f":"'HULP-velden'!S18","v":15365.496600058685},{"$f":"'HULP-velden'!T18","v":21663.75275794624},{"$f":"'HULP-velden'!U18","v":26451.069796381005},{"$f":"'HULP-velden'!V18","v":30448.665245182739},{"$f":"'HULP-velden'!W18","v":33936.772814720709},{"$f":"'HULP-velden'!X18","v":37059.534467763151},{"$f":"'HULP-velden'!Y18","v":39902.817605794036},{"$f":"'HULP-velden'!Z18","v":42522.721253699179},{"$f":"'HULP-velden'!AA18","v":44958.314078520758},{"$f":"'HULP-velden'!AB18","v":47238.113835870136},{"$f":"'HULP-velden'!AC18","v":49383.701813279637},{"$f":"'HULP-velden'!AD18","v":51411.884062148492},{"$f":"'HULP-velden'!AE18","v":53336.055842940499},{"$f":"'HULP-velden'!AF18","v":55167.10156395135},{"$f":"'HULP-velden'!AG18","v":56914.010130001989},{"$f":"'HULP-velden'!AH18","v":58584.308609159154},{"$f":"'HULP-velden'!AI18","v":60184.375824403258},{"$f":"'HULP-velden'!AJ18","v":61719.674201646776},{"$f":"'HULP-velden'!AK18","v":63194.924525363735},{"$f":"'HULP-velden'!AL18","v":64614.239916600411},0.7]
[null,null,null,{"$f":"'HULP-velden'!P19","v":80.804040507106677},{"$f":"'HULP-velden'!Q19","v":81.043990000767835},{"$f":"'HULP-velden'!R19","v":81.283939494429021},{"$f":"'HULP-velden'!S19","v":81.763838481751336},{"$f":"'HULP-velden'!T19","v":82.723636456395994},{"$f":"'HULP-velden'!U19","v":83.683434431040681},{"$f":"'HULP-velden'!V19","v":84.643232405685339},{"$f":"'HULP-velden'!W19","v":85.603030380329997},{"$f":"'HULP-velden'!X19","v":86.56282835497467},{"$f":"'HULP-velden'!Y19","v":87.522626329619328},{"$f":"'HULP-velden'!Z19","v":88.482424304264001},{"$f":"'HULP-velden'!AA19","v":89.442222278908673},{"$f":"'HULP-velden'!AB19","v":90.402020253553346},{"$f":"'HULP-velden'!AC19","v":91.361818228198004},{"$f":"'HULP-velden'!AD19","v":92.321616202842662},{"$f":"'HULP-velden'!AE19","v":93.281414177487349},{"$f":"'HULP-velden'!AF19","v":94.241212152132007},{"$f":"'HULP-velden'!AG19","v":95.201010126776666},{"$f":"'HULP-velden'!AH19","v":96.160808101421338},{"$f":"'HULP-velden'!AI19","v":97.120606076065997},{"$f":"'HULP-velden'!AJ19","v":98.080404050710669},{"$f":"'HULP-velden'!AK19","v":99.040202025355342},{"$f":"'HULP-velden'!AL19","v":100},0]
[null,"Q berekend bij P=0 en EMVI=0,6",{"$f":"'HULP-velden'!O20","v":230.29437251522859},{"$f":"'HULP-velden'!P20","v":230.29437251522859},{"$f":"'HULP-velden'!Q20","v":230.54069285878822},{"$f":"'HULP-velden'!R20","v":230.78701320234788},{"$f":"'HULP-velden'!S20","v":231.27965388946717},{"$f":"'HULP-velden'!T20","v":232.26493526370572},{"$f":"'HULP-velden'!U20","v":233.25021663794431},{"$f":"'HULP-velden'!V20","v":234.23549801218286},{"$f":"'HULP-velden'!W20","v":235.22077938642144},{"$f":"'HULP-velden'!X20","v":236.20606076066002},{"$f":"'HULP-velden'!Y20","v":237.19134213489858},{"$f":"'HULP-velden'!Z20","v":238.17662350913716},{"$f":"'HULP-velden'!AA20","v":239.16190488337571},{"$f":"'HULP-velden'!AB20","v":240.14718625761429},{"$f":"'HULP-velden'!AC20","v":241.13246763185288},{"$f":"'HULP-velden'!AD20","v":242.11774900609143},{"$f":"'HULP-velden'!AE20","v":243.10303038033001},{"$f":"'HULP-velden'!AF20","v":244.08831175456856},{"$f":"'HULP-velden'!AG20","v":245.07359312880715},{"$f":"'HULP-velden'!AH20","v":246.05887450304573},{"$f":"'HULP-velden'!AI20","v":247.04415587728428},{"$f":"'HULP-velden'!AJ20","v":248.02943725152286},{"$f":"'HULP-velden'!AK20","v":249.01471862576142},{"$f":"'HULP-velden'!AL20","v":250},"EMVI"]
[null,"P berekend uit Q en EMVI=0,6",null,{"$f":"'HULP-velden'!P21","v":0},{"$f":"'HULP-velden'!Q21","v":4570.0991023294027},{"$f":"'HULP-velden'!R21","v":6460.748776604848},{"$f":"'HULP-velden'!S21","v":9130.235598575824},{"$f":"'HULP-velden'!T21","v":12893.293391441546},{"$f":"'HULP-velden'!U21","v":15767.924314153484},{"$f":"'HULP-velden'!V21","v":18180.551976844392},{"$f":"'HULP-velden'!W21","v":20296.603496531156},{"$f":"'HULP-velden'!X21","v":22201.044279827263},{"$f":"'HULP-velden'!Y21","v":23944.419622139216},{"$f":"'HULP-velden'!Z21","v":25559.708630462021},{"$f":"'HULP-velden'!AA21","v":27069.850199325596},{"$f":"'HULP-velden'!AB21","v":28491.568659175908},{"$f":"'HULP-velden'!AC21","v":29837.506427547371},{"$f":"'HULP-velden'!AD21","v":31117.498377506396},{"$f":"'HULP-velden'!AE21","v":32339.375860413384},{"$f":"'HULP-velden'!AF21","v":33509.496670568602},{"$f":"'HULP-velden'!AG21","v":34633.107187998619},{"$f":"'HULP-velden'!AH21","v":35714.597438340868},{"$f":"'HULP-velden'!AI21","v":36757.685416479537},{"$f":"'HULP-velden'!AJ21","v":37765.55327911659},{"$f":"'HULP-velden'!AK21","v":38740.94993783065},{"$f":"'HULP-velden'!AL21","v":39686.269665968852},0.6]
[null,null,null,{"$f":"'HULP-velden'!P22","v":92.117749006091429},{"$f":"'HULP-velden'!Q22","v":92.216277143515285},{"$f":"'HULP-velden'!R22","v":92.314805280939154},{"$f":"'HULP-velden'!S22","v":92.511861555786865},{"$f":"'HULP-velden'!T22","v":92.905974105482287},{"$f":"'HULP-velden'!U22","v":93.300086655177722},{"$f":"'HULP-velden'!V22","v":93.694199204873144},{"$f":"'HULP-velden'!W22","v":94.088311754568579},{"$f":"'HULP-velden'!X22","v":94.482424304264015},{"$f":"'HULP-velden'!Y22","v":94.876536853959422},{"$f":"'HULP-velden'!Z22","v":95.270649403654858},{"$f":"'HULP-velden'!AA22","v":95.664761953350279},{"$f":"'HULP-velden'!AB22","v":96.058874503045715},{"$f":"'HULP-velden'!AC22","v":96.45298705274115},{"$f":"'HULP-velden'!AD22","v":96.847099602436572},{"$f":"'HULP-velden'!AE22","v":97.241212152132007},{"$f":"'HULP-velden'!AF22","v":97.635324701827429},{"$f":"'HULP-velden'!AG22","v":98.02943725152285},{"$f":"'HULP-velden'!AH22","v":98.423549801218286},{"$f":"'HULP-velden'!AI22","v":98.817662350913722},{"$f":"'HULP-velden'!AJ22","v":99.211774900609157},{"$f":"'HULP-velden'!AK22","v":99.605887450304564},{"$f":"'HULP-velden'!AL22","v":100}," "]
[null,"Q berekend bij P=0 en EMVI=1,1",{"$f":"'HULP-velden'!O23","v":88.873016277919035},{"$f":"'HULP-velden'!P23","v":88.873016277919035},{"$f":"'HULP-velden'!Q23","v":90.88710357444505},{"$f":"'HULP-velden'!R23","v":92.901190870971064},{"$f":"'HULP-velden'!S23","v":96.929365464023078},{"$f":"'HULP-velden'!T23","v":104.98571465012714},{"$f":"'HULP-velden'!U23","v":113.04206383623118},{"$f":"'HULP-velden'!V23","v":121.09841302233522},{"$f":"'HULP-velden'!W23","v":129.15476220843928},{"$f":"'HULP-velden'!X23","v":137.21111139454334},{"$f":"'HULP-velden'!Y23","v":145.26746058064737},{"$f":"'HULP-velden'!Z23","v":153.32380976675142},{"$f":"'HULP-velden'!AA23","v":161.38015895285548},{"$f":"'HULP-velden'!AB23","v":169.43650813895954},{"$f":"'HULP-velden'!AC23","v":177.4928573250636},{"$f":"'HULP-velden'!AD23","v":185.54920651116763},{"$f":"'HULP-velden'!AE23","v":193.60555569727165},{"$f":"'HULP-velden'!AF23","v":201.66190488337571},{"$f":"'HULP-velden'!AG23","v":209.71825406947977},{"$f":"'HULP-velden'!AH23","v":217.77460325558383},{"$f":"'HULP-velden'!AI23","v":225.83095244168788},{"$f":"'HULP-velden'!AJ23","v":233.88730162779194},{"$f":"'HULP-velden'!AK23","v":241.94365081389594},{"$f":"'HULP-velden'!AL23","v":250},"EMVI"]
[null,"P berekend uit Q en EMVI=1,1",null,{"$f":"'HULP-velden'!P24","v":0},{"$f":"'HULP-velden'!Q24","v":17672.133879388752},{"$f":"'HULP-velden'!R24","v":24951.56022943393},{"$f":"'HULP-velden'!S24","v":35171.687768574368},{"$f":"'HULP-velden'!T24","v":49412.982705721683},{"$f":"'HULP-velden'!U24","v":60114.77121438289},{"$f":"'HULP-velden'!V24","v":68945.458119697927},{"$f":"'HULP-velden'!W24","v":76555.302176976853},{"$f":"'HULP-velden'!X24","v":83279.649413150313},{"$f":"'HULP-velden'!Y24","v":89318.717748532377},{"$f":"'HULP-velden'!Z24","v":94803.556330986554},{"$f":"'HULP-velden'!AA24","v":99825.562180530076},{"$f":"'HULP-velden'!AB24","v":104451.515332287},{"$f":"'HULP-velden'!AC24","v":108731.97719465455},{"$f":"'HULP-velden'!AD24","v":112706.31878028199},{"$f":"'HULP-velden'!AE24","v":116405.89907836285},{"$f":"'HULP-velden'!AF24","v":119856.16382304762},{"$f":"'HULP-velden'!AG24","v":123078.08209185029},{"$f":"'HULP-velden'!AH24","v":126089.15970588048},{"$f":"'HULP-velden'!AI24","v":128904.1726173269},{"$f":"'HULP-velden'!AJ24","v":131535.70944757154},{"$f":"'HULP-velden'!AK24","v":133994.58056387986},{"$f":"'HULP-velden'!AL24","v":136290.13170439011},1.1000000000000001]
[null,null,null,{"$f":"'HULP-velden'!P25","v":35.549206511167611},{"$f":"'HULP-velden'!Q25","v":36.35484142977802},{"$f":"'HULP-velden'!R25","v":37.160476348388428},{"$f":"'HULP-velden'!S25","v":38.771746185609231},{"$f":"'HULP-velden'!T25","v":41.994285860050859},{"$f":"'HULP-velden'!U25","v":45.216825534492472},{"$f":"'HULP-velden'!V25","v":48.439365208934085},{"$f":"'HULP-velden'!W25","v":51.661904883375712},{"$f":"'HULP-velden'!X25","v":54.884444557817332},{"$f":"'HULP-velden'!Y25","v":58.106984232258952},{"$f":"'HULP-velden'!Z25","v":61.329523906700565},{"$f":"'HULP-velden'!AA25","v":64.552063581142193},{"$f":"'HULP-velden'!AB25","v":67.774603255583827},{"$f":"'HULP-velden'!AC25","v":70.997142930025433},{"$f":"'HULP-velden'!AD25","v":74.219682604467053},{"$f":"'HULP-velden'!AE25","v":77.442222278908659},{"$f":"'HULP-velden'!AF25","v":80.664761953350279},{"$f":"'HULP-velden'!AG25","v":83.887301627791913},{"$f":"'HULP-velden'!AH25","v":87.109841302233519},{"$f":"'HULP-velden'!AI25","v":90.332380976675154},{"$f":"'HULP-velden'!AJ25","v":93.554920651116774},{"$f":"'HULP-velden'!AK25","v":96.77746032555838},{"$f":"'HULP-velden'!AL25","v":100},0]
[]
[null,"Hulpvelden t.b.v grafiek",null,null,null,"Exponent","Pref","Qref"]
[null,"Referentie",{"$f":"+'HULP-velden'!H54","v":100000},{"$f":"+'HULP-velden'!I54","v":80},null,{"$f":"+'HULP-velden'!H112","v":2},{"$f":"+'HULP-velden'!H113","v":100000},{"$f":"+'HULP-velden'!H114","v":200}]
[null,"Referentie (Qmax)",{"$f":"+'HULP-velden'!H55","v":119895.78808281798},{"$f":"+'HULP-velden'!I55","v":100}]
[null,"Qmax",{"$f":"+'HULP-velden'!H43","v":100},{"$f":"+'HULP-velden'!I43","v":100},null,"Qmax",{"$f":"+'HULP-velden'!H109","v":250}]
[null,"Qmin",{"$f":"+'HULP-velden'!H44","v":60},{"$f":"+'HULP-velden'!I44","v":60},null,"Qmin",{"$f":"+'HULP-velden'!H110","v":150}]
[null,"Qref",{"$f":"+'HULP-velden'!H45","v":80},{"$f":"+'HULP-velden'!I45","v":80},null,"Qwensen",{"$f":"+G40-G41","v":100}]
[null,"P",{"$f":"+'HULP-velden'!H47","v":0},{"$f":"+'HULP-velden'!I47","v":200000.00000000006},null,"LAQ",{"$f":"+'HULP-velden'!H57","v":-10},{"$f":"+G43","v":-10},"genormaliseerd"]
[null,"Bonus (extra)",{"$f":"+'HULP-velden'!H53","v":160},{"$f":"+'HULP-velden'!I53","v":160},null,"LAQ (norm)",{"$f":"+'HULP-velden'!H58","v":-4},{"$f":"+G44","v":-4}]
[null,"Qeisen",{"$f":"+'HULP-velden'!J86","v":30},{"$f":"+'HULP-velden'!K86","v":10000},null,"Uw Inschrijving",{"$f":"+'BPK-Grafiek'!$F$14/G40*100","v":60},{"$f":"+'BPK-Grafiek'!$F$9","v":0}]
[null,"Qwensen",{"$f":"+'HULP-velden'!J87","v":80},{"$f":"+'HULP-velden'!K87","v":10000},null,"Kenmerk",{"$f":"Superformule!G7","v":0}]
[null,"Qbonus",{"$f":"+'HULP-velden'!J88","v":130},{"$f":"+'HULP-velden'!K88","v":10000},null,"Naam",{"$f":"Superformule!G6","v":0}]

{"sheet":"HULP-data","index":8,"n_rows":47,"n_cols":27,"rows_kept":47,"cut":false,"hidden":true,"merged":[[1,1,3,4],[8,2,9,9]]}
[]
[null,"Hulpdata Grafiek Superformule"]
[]
[]
[]
[null,"Hulpvelden"]
[null,"Uw inschrijving",{"$f":"+'BPK-Grafiek'!$F$9","v":0},{"$f":"+'BPK-Grafiek'!$F$14","v":150},{"$f":"IFERROR((0.5*($C$7/$G$38)^$F$38+0.5*(2-$D$7/$H$38)^$F$38)^(1/$F$38),0)","v":0.88388347648318444},{"$f":"+D7/G40*100","v":60}]
[]
[null,"LET OP  !!!","Voordat de TAB-bladen \"TBV PRIJSMODEL (1)\" EN \"TBV PRIJSMODEL (2)\" gekopieerd worden kan naar het Prijsmodel, moeten eerst onderstaande waarden ( oranje velden ) worden geselecteerd en worden gekopieerd en geplakt worden als WAARDEN (ctrl-C, plakken speciaal \"waarden\")"]
[]
[null,"EVMI-punten","P ","Q","EMVI"]
[null,"Ref",{"$f":"$G$38","v":100000},{"$f":"$H$38","v":200},{"$f":"IFERROR((0.5*($C$12/$G$38)^$F$38+0.5*(2-$D$12/$H$38)^$F$38)^(1/$F$38),0)","v":1}]
[null,"Ref (boven)",{"$f":"+'HULP-velden'!$J$23","v":119895.78808281798},{"$f":"$G$40","v":250},{"$f":"IFERROR((0.5*($C$13/$G$38)^$F$38+0.5*(2-$D$13/$H$38)^$F$38)^(1/$F$38),0)","v":1}]
[null,"Ref (onder)",0,{"$f":"'HULP-velden'!$L$18","v":117.15728752538097},{"$f":"IFERROR((0.5*(C14/$G$38)^$F$38+0.5*(2-D14/$H$38)^$F$38)^(1/$F$38),0)","v":1}]
[]
[null,"EMVI-lijnen"]
[null,null,"hulp=Q bij P=0",{"$f":"'HULP-velden'!P7","v":0},{"$f":"'HULP-velden'!Q7","v":1.2500000000000001E-2},{"$f":"'HULP-velden'!R7","v":2.5000000000000001E-2},{"$f":"'HULP-velden'!S7","v":0.05},{"$f":"'HULP-velden'!T7","v":0.1},{"$f":"'HULP-velden'!U7","v":0.15},{"$f":"'HULP-velden'!V7","v":0.2},{"$f":"'HULP-velden'!W7","v":0.25},{"$f":"'HULP-velden'!X7","v":0.3},{"$f":"'HULP-velden'!Y7","v":0.35},{"$f":"'HULP-velden'!Z7","v":0.4},{"$f":"'HULP-velden'!AA7","v":0.45},{"$f":"'HULP-velden'!AB7","v":0.5},{"$f":"'HULP-velden'!AC7","v":0.55000000000000004},{"$f":"'HULP-velden'!AD7","v":0.6},{"$f":"'HULP-velden'!AE7","v":0.65},{"$f":"'HULP-velden'!AF7","v":0.7},{"$f":"'HULP-velden'!AG7","v":0.75},{"$f":"'HULP-velden'!AH7","v":0.8},{"$f":"'HULP-velden'!AI7","v":0.85},{"$f":"'HULP-velden'!AJ7","v":0.9},{"$f":"'HULP-velden'!AK7","v":0.95},{"$f":"'HULP-velden'!AL7","v":1},0]
[null,"Q berekend bij P=0 en EMVI=1",{"$f":"'HULP-velden'!O8","v":117.15728752538097},{"$f":"'HULP-velden'!P8","v":117.15728752538097},{"$f":"'HULP-velden'!Q8","v":118.8178214313137},{"$f":"'HULP-velden'!R8","v":120.47835533724644},{"$f":"'HULP-velden'!S8","v":123.79942314911192},{"$f":"'HULP-velden'!T8","v":130.44155877284288},{"$f":"'HULP-velden'!U8","v":137.08369439657383},{"$f":"'HULP-velden'!V8","v":143.72583002030478},{"$f":"'HULP-velden'!W8","v":150.36796564403573},{"$f":"'HULP-velden'!X8","v":157.01010126776669},{"$f":"'HULP-velden'!Y8","v":163.65223689149764},{"$f":"'HULP-velden'!Z8","v":170.29437251522859},{"$f":"'HULP-velden'!AA8","v":176.93650813895954},{"$f":"'HULP-velden'!AB8","v":183.57864376269049},{"$f":"'HULP-velden'!AC8","v":190.22077938642144},{"$f":"'HULP-velden'!AD8","v":196.86291501015239},{"$f":"'HULP-velden'!AE8","v":203.50505063388334},{"$f":"'HULP-velden'!AF8","v":210.14718625761429},{"$f":"'HULP-velden'!AG8","v":216.78932188134524},{"$f":"'HULP-velden'!AH8","v":223.4314575050762},{"$f":"'HULP-velden'!AI8","v":230.07359312880715},{"$f":"'HULP-velden'!AJ8","v":236.7157287525381},{"$f":"'HULP-velden'!AK8","v":243.35786437626905},{"$f":"'HULP-velden'!AL8","v":250},"EMVI"]
[null,"P berekend uit Q en EMVI=1",null,{"$f":"'HULP-velden'!P9","v":0},{"$f":"'HULP-velden'!Q9","v":15301.817337880153},{"$f":"'HULP-velden'!R9","v":21608.159136246002},{"$f":"'HULP-velden'!S9","v":30468.185650103391},{"$f":"'HULP-velden'!T9","v":42831.783651820129},{"$f":"'HULP-velden'!U9","v":52141.672987749946},{"$f":"'HULP-velden'!V9","v":59840.516795099422},{"$f":"'HULP-velden'!W9","v":66490.314000053171},{"$f":"'HULP-velden'!X9","v":72380.77975902686},{"$f":"'HULP-velden'!Y9","v":77684.835833010613},{"$f":"'HULP-velden'!Z9","v":82515.642004754831},{"$f":"'HULP-velden'!AA9","v":86952.111243430321},{"$f":"'HULP-velden'!AB9","v":91051.90355561435},{"$f":"'HULP-velden'!AC9","v":94858.682521369032},{"$f":"'HULP-velden'!AD9","v":98406.45901289639},{"$f":"'HULP-velden'!AE9","v":101722.33637899699},{"$f":"'HULP-velden'!AF9","v":104828.3228832969},{"$f":"'HULP-velden'!AG9","v":107742.57216080221},{"$f":"'HULP-velden'!AH9","v":110480.25819260458},{"$f":"'HULP-velden'!AI9","v":113054.20851061429},{"$f":"'HULP-velden'!AJ9","v":115475.37265926583},{"$f":"'HULP-velden'!AK9","v":117753.17548503382},{"$f":"'HULP-velden'!AL9","v":119895.78808281798},1]
[null,null,null,{"$f":"'HULP-velden'!P10","v":46.862915010152385},{"$f":"'HULP-velden'!Q10","v":47.527128572525477},{"$f":"'HULP-velden'!R10","v":48.191342134898576},{"$f":"'HULP-velden'!S10","v":49.519769259644768},{"$f":"'HULP-velden'!T10","v":52.176623509137151},{"$f":"'HULP-velden'!U10","v":54.833477758629535},{"$f":"'HULP-velden'!V10","v":57.490332008121911},{"$f":"'HULP-velden'!W10","v":60.147186257614294},{"$f":"'HULP-velden'!X10","v":62.80404050710667},{"$f":"'HULP-velden'!Y10","v":65.460894756599046},{"$f":"'HULP-velden'!Z10","v":68.117749006091429},{"$f":"'HULP-velden'!AA10","v":70.774603255583813},{"$f":"'HULP-velden'!AB10","v":73.431457505076196},{"$f":"'HULP-velden'!AC10","v":76.088311754568565},{"$f":"'HULP-velden'!AD10","v":78.745166004060948},{"$f":"'HULP-velden'!AE10","v":81.402020253553346},{"$f":"'HULP-velden'!AF10","v":84.058874503045729},{"$f":"'HULP-velden'!AG10","v":86.715728752538098},{"$f":"'HULP-velden'!AH10","v":89.372583002030481},{"$f":"'HULP-velden'!AI10","v":92.029437251522864},{"$f":"'HULP-velden'!AJ10","v":94.686291501015234},{"$f":"'HULP-velden'!AK10","v":97.343145750507617},{"$f":"'HULP-velden'!AL10","v":100},0]
[null,"Q berekend bij P=0 en EMVI=0,9",{"$f":"'HULP-velden'!O11","v":145.44155877284285},{"$f":"'HULP-velden'!P11","v":145.44155877284285},{"$f":"'HULP-velden'!Q11","v":146.74853928818231},{"$f":"'HULP-velden'!R11","v":148.05551980352178},{"$f":"'HULP-velden'!S11","v":150.6694808342007},{"$f":"'HULP-velden'!T11","v":155.89740289555857},{"$f":"'HULP-velden'!U11","v":161.12532495691642},{"$f":"'HULP-velden'!V11","v":166.35324701827429},{"$f":"'HULP-velden'!W11","v":171.58116907963213},{"$f":"'HULP-velden'!X11","v":176.80909114099001},{"$f":"'HULP-velden'!Y11","v":182.03701320234785},{"$f":"'HULP-velden'!Z11","v":187.26493526370572},{"$f":"'HULP-velden'!AA11","v":192.49285732506357},{"$f":"'HULP-velden'!AB11","v":197.72077938642144},{"$f":"'HULP-velden'!AC11","v":202.94870144777929},{"$f":"'HULP-velden'!AD11","v":208.17662350913713},{"$f":"'HULP-velden'!AE11","v":213.404545570495},{"$f":"'HULP-velden'!AF11","v":218.63246763185285},{"$f":"'HULP-velden'!AG11","v":223.86038969321072},{"$f":"'HULP-velden'!AH11","v":229.08831175456856},{"$f":"'HULP-velden'!AI11","v":234.31623381592641},{"$f":"'HULP-velden'!AJ11","v":239.54415587728428},{"$f":"'HULP-velden'!AK11","v":244.77207793864216},{"$f":"'HULP-velden'!AL11","v":250},"EMVI"]
[null,"P berekend uit Q en EMVI=0,9",null,{"$f":"'HULP-velden'!P12","v":0},{"$f":"'HULP-velden'!Q12","v":12881.165002928316},{"$f":"'HULP-velden'!R12","v":18193.260417847021},{"$f":"'HULP-velden'!S12","v":25662.678214252082},{"$f":"'HULP-velden'!T12","v":36103.746643758241},{"$f":"'HULP-velden'!U12","v":43985.4794877276},{"$f":"'HULP-velden'!V12","v":50520.280138515802},{"$f":"'HULP-velden'!W12","v":56180.151479353422},{"$f":"'HULP-velden'!X12","v":61208.288251447426},{"$f":"'HULP-velden'!Y12","v":65749.784003916153},{"$f":"'HULP-velden'!Z12","v":69899.556922137737},{"$f":"'HULP-velden'!AA12","v":73723.784728680999},{"$f":"'HULP-velden'!AB12","v":77270.817434467477},{"$f":"'HULP-velden'!AC12","v":80577.269963190585},{"$f":"'HULP-velden'!AD12","v":83671.668191277087},{"$f":"'HULP-velden'!AE12","v":86576.75263349645},{"$f":"'HULP-velden'!AF12","v":89310.999046434794},{"$f":"'HULP-velden'!AG12","v":91889.658940726862},{"$f":"'HULP-velden'!AH12","v":94325.493400639651},{"$f":"'HULP-velden'!AI12","v":96629.304073688269},{"$f":"'HULP-velden'!AJ12","v":98810.32598730101},{"$f":"'HULP-velden'!AK12","v":100876.52379581808},{"$f":"'HULP-velden'!AL12","v":102834.81900601568},0.9]
[null,null,null,{"$f":"'HULP-velden'!P13","v":58.176623509137137},{"$f":"'HULP-velden'!Q13","v":58.699415715272927},{"$f":"'HULP-velden'!R13","v":59.22220792140871},{"$f":"'HULP-velden'!S13","v":60.267792333680283},{"$f":"'HULP-velden'!T13","v":62.358961158223423},{"$f":"'HULP-velden'!U13","v":64.450129982766569},{"$f":"'HULP-velden'!V13","v":66.541298807309715},{"$f":"'HULP-velden'!W13","v":68.632467631852862},{"$f":"'HULP-velden'!X13","v":70.723636456395994},{"$f":"'HULP-velden'!Y13","v":72.81480528093914},{"$f":"'HULP-velden'!Z13","v":74.905974105482287},{"$f":"'HULP-velden'!AA13","v":76.997142930025433},{"$f":"'HULP-velden'!AB13","v":79.088311754568579},{"$f":"'HULP-velden'!AC13","v":81.179480579111711},{"$f":"'HULP-velden'!AD13","v":83.270649403654858},{"$f":"'HULP-velden'!AE13","v":85.361818228198004},{"$f":"'HULP-velden'!AF13","v":87.452987052741136},{"$f":"'HULP-velden'!AG13","v":89.544155877284297},{"$f":"'HULP-velden'!AH13","v":91.635324701827429},{"$f":"'HULP-velden'!AI13","v":93.726493526370575},{"$f":"'HULP-velden'!AJ13","v":95.817662350913707},{"$f":"'HULP-velden'!AK13","v":97.908831175456868},{"$f":"'HULP-velden'!AL13","v":100},0]
[null,"Q berekend bij P=0 en EMVI=0,8",{"$f":"'HULP-velden'!O14","v":173.72583002030476},{"$f":"'HULP-velden'!P14","v":173.72583002030476},{"$f":"'HULP-velden'!Q14","v":174.67925714505094},{"$f":"'HULP-velden'!R14","v":175.63268426979712},{"$f":"'HULP-velden'!S14","v":177.53953851928952},{"$f":"'HULP-velden'!T14","v":181.35324701827429},{"$f":"'HULP-velden'!U14","v":185.16695551725905},{"$f":"'HULP-velden'!V14","v":188.98066401624379},{"$f":"'HULP-velden'!W14","v":192.79437251522856},{"$f":"'HULP-velden'!X14","v":196.60808101421333},{"$f":"'HULP-velden'!Y14","v":200.42178951319809},{"$f":"'HULP-velden'!Z14","v":204.23549801218286},{"$f":"'HULP-velden'!AA14","v":208.04920651116763},{"$f":"'HULP-velden'!AB14","v":211.86291501015239},{"$f":"'HULP-velden'!AC14","v":215.67662350913713},{"$f":"'HULP-velden'!AD14","v":219.4903320081219},{"$f":"'HULP-velden'!AE14","v":223.30404050710666},{"$f":"'HULP-velden'!AF14","v":227.11774900609143},{"$f":"'HULP-velden'!AG14","v":230.9314575050762},{"$f":"'HULP-velden'!AH14","v":234.74516600406096},{"$f":"'HULP-velden'!AI14","v":238.55887450304573},{"$f":"'HULP-velden'!AJ14","v":242.37258300203047},{"$f":"'HULP-velden'!AK14","v":246.18629150101523},{"$f":"'HULP-velden'!AL14","v":250},"EMVI"]
[null,"P berekend uit Q en EMVI=0,8",null,{"$f":"'HULP-velden'!P15","v":0},{"$f":"'HULP-velden'!Q15","v":10375.004087877855},{"$f":"'HULP-velden'!R15","v":14656.974722154282},{"$f":"'HULP-velden'!S15","v":20684.191293046271},{"$f":"'HULP-velden'!T15","v":29127.295662952594},{"$f":"'HULP-velden'!U15","v":35520.286451113658},{"$f":"'HULP-velden'!V15","v":40837.604731958207},{"$f":"'HULP-velden'!W15","v":45458.299403525169},{"$f":"'HULP-velden'!X15","v":49577.53344832515},{"$f":"'HULP-velden'!Y15","v":53311.67296869844},{"$f":"'HULP-velden'!Z15","v":56736.804107787808},{"$f":"'HULP-velden'!AA15","v":59905.953124475927},{"$f":"'HULP-velden'!AB15","v":62857.850049780718},{"$f":"'HULP-velden'!AC15","v":65621.819692476594},{"$f":"'HULP-velden'!AD15","v":68220.707562773692},{"$f":"'HULP-velden'!AE15","v":70672.727941699355},{"$f":"'HULP-velden'!AF15","v":72992.683351277083},{"$f":"'HULP-velden'!AG15","v":75192.798755336509},{"$f":"'HULP-velden'!AH15","v":77283.309713311712},{"$f":"'HULP-velden'!AI15","v":79272.887859401002},{"$f":"'HULP-velden'!AJ15","v":81168.955596564498},{"$f":"'HULP-velden'!AK15","v":82977.923385966584},{"$f":"'HULP-velden'!AL15","v":84705.371730487095},0.8]
[null,null,null,{"$f":"'HULP-velden'!P16","v":69.490332008121896},{"$f":"'HULP-velden'!Q16","v":69.871702858020384},{"$f":"'HULP-velden'!R16","v":70.253073707918844},{"$f":"'HULP-velden'!S16","v":71.015815407715806},{"$f":"'HULP-velden'!T16","v":72.541298807309715},{"$f":"'HULP-velden'!U16","v":74.066782206903625},{"$f":"'HULP-velden'!V16","v":75.59226560649752},{"$f":"'HULP-velden'!W16","v":77.117749006091415},{"$f":"'HULP-velden'!X16","v":78.643232405685325},{"$f":"'HULP-velden'!Y16","v":80.168715805279234},{"$f":"'HULP-velden'!Z16","v":81.694199204873144},{"$f":"'HULP-velden'!AA16","v":83.219682604467053},{"$f":"'HULP-velden'!AB16","v":84.745166004060962},{"$f":"'HULP-velden'!AC16","v":86.270649403654858},{"$f":"'HULP-velden'!AD16","v":87.796132803248767},{"$f":"'HULP-velden'!AE16","v":89.321616202842662},{"$f":"'HULP-velden'!AF16","v":90.847099602436572},{"$f":"'HULP-velden'!AG16","v":92.372583002030481},{"$f":"'HULP-velden'!AH16","v":93.898066401624376},{"$f":"'HULP-velden'!AI16","v":95.423549801218286},{"$f":"'HULP-velden'!AJ16","v":96.949033200812181},{"$f":"'HULP-velden'!AK16","v":98.474516600406091},{"$f":"'HULP-velden'!AL16","v":100}," "]
[null,"Q berekend bij P=0 en EMVI=0,7",{"$f":"'HULP-velden'!O17","v":202.01010126776669},{"$f":"'HULP-velden'!P17","v":202.01010126776669},{"$f":"'HULP-velden'!Q17","v":202.60997500191959},{"$f":"'HULP-velden'!R17","v":203.20984873607253},{"$f":"'HULP-velden'!S17","v":204.40959620437835},{"$f":"'HULP-velden'!T17","v":206.80909114099001},{"$f":"'HULP-velden'!U17","v":209.20858607760169},{"$f":"'HULP-velden'!V17","v":211.60808101421335},{"$f":"'HULP-velden'!W17","v":214.00757595082501},{"$f":"'HULP-velden'!X17","v":216.40707088743667},{"$f":"'HULP-velden'!Y17","v":218.80656582404833},{"$f":"'HULP-velden'!Z17","v":221.20606076066002},{"$f":"'HULP-velden'!AA17","v":223.60555569727168},{"$f":"'HULP-velden'!AB17","v":226.00505063388334},{"$f":"'HULP-velden'!AC17","v":228.404545570495},{"$f":"'HULP-velden'!AD17","v":230.80404050710666},{"$f":"'HULP-velden'!AE17","v":233.20353544371835},{"$f":"'HULP-velden'!AF17","v":235.60303038033001},{"$f":"'HULP-velden'!AG17","v":238.00252531694167},{"$f":"'HULP-velden'!AH17","v":240.40202025355333},{"$f":"'HULP-velden'!AI17","v":242.80151519016499},{"$f":"'HULP-velden'!AJ17","v":245.20101012677668},{"$f":"'HULP-velden'!AK17","v":247.60050506338834},{"$f":"'HULP-velden'!AL17","v":250},"EMVI"]
[null,"P berekend uit Q en EMVI=0,7",null,{"$f":"'HULP-velden'!P18","v":0},{"$f":"'HULP-velden'!Q18","v":7700.2927096505246},{"$f":"'HULP-velden'!R18","v":10881.594156195002},{"$f":"'HULP-velden'!S18","v":15365.496600058685},{"$f":"'HULP-velden'!T18","v":21663.75275794624},{"$f":"'HULP-velden'!U18","v":26451.069796381005},{"$f":"'HULP-velden'!V18","v":30448.665245182739},{"$f":"'HULP-velden'!W18","v":33936.772814720709},{"$f":"'HULP-velden'!X18","v":37059.534467763151},{"$f":"'HULP-velden'!Y18","v":39902.817605794036},{"$f":"'HULP-velden'!Z18","v":42522.721253699179},{"$f":"'HULP-velden'!AA18","v":44958.314078520758},{"$f":"'HULP-velden'!AB18","v":47238.113835870136},{"$f":"'HULP-velden'!AC18","v":49383.701813279637},{"$f":"'HULP-velden'!AD18","v":51411.884062148492},{"$f":"'HULP-velden'!AE18","v":53336.055842940499},{"$f":"'HULP-velden'!AF18","v":55167.10156395135},{"$f":"'HULP-velden'!AG18","v":56914.010130001989},{"$f":"'HULP-velden'!AH18","v":58584.308609159154},{"$f":"'HULP-velden'!AI18","v":60184.375824403258},{"$f":"'HULP-velden'!AJ18","v":61719.674201646776},{"$f":"'HULP-velden'!AK18","v":63194.924525363735},{"$f":"'HULP-velden'!AL18","v":64614.239916600411},0.7]
[null,null,null,{"$f":"'HULP-velden'!P19","v":80.804040507106677},{"$f":"'HULP-velden'!Q19","v":81.043990000767835},{"$f":"'HULP-velden'!R19","v":81.283939494429021},{"$f":"'HULP-velden'!S19","v":81.763838481751336},{"$f":"'HULP-velden'!T19","v":82.723636456395994},{"$f":"'HULP-velden'!U19","v":83.683434431040681},{"$f":"'HULP-velden'!V19","v":84.643232405685339},{"$f":"'HULP-velden'!W19","v":85.603030380329997},{"$f":"'HULP-velden'!X19","v":86.56282835497467},{"$f":"'HULP-velden'!Y19","v":87.522626329619328},{"$f":"'HULP-velden'!Z19","v":88.482424304264001},{"$f":"'HULP-velden'!AA19","v":89.442222278908673},{"$f":"'HULP-velden'!AB19","v":90.402020253553346},{"$f":"'HULP-velden'!AC19","v":91.361818228198004},{"$f":"'HULP-velden'!AD19","v":92.321616202842662},{"$f":"'HULP-velden'!AE19","v":93.281414177487349},{"$f":"'HULP-velden'!AF19","v":94.241212152132007},{"$f":"'HULP-velden'!AG19","v":95.201010126776666},{"$f":"'HULP-velden'!AH19","v":96.160808101421338},{"$f":"'HULP-velden'!AI19","v":97.120606076065997},{"$f":"'HULP-velden'!AJ19","v":98.080404050710669},{"$f":"'HULP-velden'!AK19","v":99.040202025355342},{"$f":"'HULP-velden'!AL19","v":100},0]
[null,"Q berekend bij P=0 en EMVI=0,6",{"$f":"'HULP-velden'!O20","v":230.29437251522859},{"$f":"'HULP-velden'!P20","v":230.29437251522859},{"$f":"'HULP-velden'!Q20","v":230.54069285878822},{"$f":"'HULP-velden'!R20","v":230.78701320234788},{"$f":"'HULP-velden'!S20","v":231.27965388946717},{"$f":"'HULP-velden'!T20","v":232.26493526370572},{"$f":"'HULP-velden'!U20","v":233.25021663794431},{"$f":"'HULP-velden'!V20","v":234.23549801218286},{"$f":"'HULP-velden'!W20","v":235.22077938642144},{"$f":"'HULP-velden'!X20","v":236.20606076066002},{"$f":"'HULP-velden'!Y20","v":237.19134213489858},{"$f":"'HULP-velden'!Z20","v":238.17662350913716},{"$f":"'HULP-velden'!AA20","v":239.16190488337571},{"$f":"'HULP-velden'!AB20","v":240.14718625761429},{"$f":"'HULP-velden'!AC20","v":241.13246763185288},{"$f":"'HULP-velden'!AD20","v":242.11774900609143},{"$f":"'HULP-velden'!AE20","v":243.10303038033001},{"$f":"'HULP-velden'!AF20","v":244.08831175456856},{"$f":"'HULP-velden'!AG20","v":245.07359312880715},{"$f":"'HULP-velden'!AH20","v":246.05887450304573},{"$f":"'HULP-velden'!AI20","v":247.04415587728428},{"$f":"'HULP-velden'!AJ20","v":248.02943725152286},{"$f":"'HULP-velden'!AK20","v":249.01471862576142},{"$f":"'HULP-velden'!AL20","v":250},"EMVI"]
[null,"P berekend uit Q en EMVI=0,6",null,{"$f":"'HULP-velden'!P21","v":0},{"$f":"'HULP-velden'!Q21","v":4570.0991023294027},{"$f":"'HULP-velden'!R21","v":6460.748776604848},{"$f":"'HULP-velden'!S21","v":9130.235598575824},{"$f":"'HULP-velden'!T21","v":12893.293391441546},{"$f":"'HULP-velden'!U21","v":15767.924314153484},{"$f":"'HULP-velden'!V21","v":18180.551976844392},{"$f":"'HULP-velden'!W21","v":20296.603496531156},{"$f":"'HULP-velden'!X21","v":22201.044279827263},{"$f":"'HULP-velden'!Y21","v":23944.419622139216},{"$f":"'HULP-velden'!Z21","v":25559.708630462021},{"$f":"'HULP-velden'!AA21","v":27069.850199325596},{"$f":"'HULP-velden'!AB21","v":28491.568659175908},{"$f":"'HULP-velden'!AC21","v":29837.506427547371},{"$f":"'HULP-velden'!AD21","v":31117.498377506396},{"$f":"'HULP-velden'!AE21","v":32339.375860413384},{"$f":"'HULP-velden'!AF21","v":33509.496670568602},{"$f":"'HULP-velden'!AG21","v":34633.107187998619},{"$f":"'HULP-velden'!AH21","v":35714.597438340868},{"$f":"'HULP-velden'!AI21","v":36757.685416479537},{"$f":"'HULP-velden'!AJ21","v":37765.55327911659},{"$f":"'HULP-velden'!AK21","v":38740.94993783065},{"$f":"'HULP-velden'!AL21","v":39686.269665968852},0.6]
[null,null,null,{"$f":"'HULP-velden'!P22","v":92.117749006091429},{"$f":"'HULP-velden'!Q22","v":92.216277143515285},{"$f":"'HULP-velden'!R22","v":92.314805280939154},{"$f":"'HULP-velden'!S22","v":92.511861555786865},{"$f":"'HULP-velden'!T22","v":92.905974105482287},{"$f":"'HULP-velden'!U22","v":93.300086655177722},{"$f":"'HULP-velden'!V22","v":93.694199204873144},{"$f":"'HULP-velden'!W22","v":94.088311754568579},{"$f":"'HULP-velden'!X22","v":94.482424304264015},{"$f":"'HULP-velden'!Y22","v":94.876536853959422},{"$f":"'HULP-velden'!Z22","v":95.270649403654858},{"$f":"'HULP-velden'!AA22","v":95.664761953350279},{"$f":"'HULP-velden'!AB22","v":96.058874503045715},{"$f":"'HULP-velden'!AC22","v":96.45298705274115},{"$f":"'HULP-velden'!AD22","v":96.847099602436572},{"$f":"'HULP-velden'!AE22","v":97.241212152132007},{"$f":"'HULP-velden'!AF22","v":97.635324701827429},{"$f":"'HULP-velden'!AG22","v":98.02943725152285},{"$f":"'HULP-velden'!AH22","v":98.423549801218286},{"$f":"'HULP-velden'!AI22","v":98.817662350913722},{"$f":"'HULP-velden'!AJ22","v":99.211774900609157},{"$f":"'HULP-velden'!AK22","v":99.605887450304564},{"$f":"'HULP-velden'!AL22","v":100}," "]
[null,"Q berekend bij P=0 en EMVI=1,1",{"$f":"'HULP-velden'!O23","v":88.873016277919035},{"$f":"'HULP-velden'!P23","v":88.873016277919035},{"$f":"'HULP-velden'!Q23","v":90.88710357444505},{"$f":"'HULP-velden'!R23","v":92.901190870971064},{"$f":"'HULP-velden'!S23","v":96.929365464023078},{"$f":"'HULP-velden'!T23","v":104.98571465012714},{"$f":"'HULP-velden'!U23","v":113.04206383623118},{"$f":"'HULP-velden'!V23","v":121.09841302233522},{"$f":"'HULP-velden'!W23","v":129.15476220843928},{"$f":"'HULP-velden'!X23","v":137.21111139454334},{"$f":"'HULP-velden'!Y23","v":145.26746058064737},{"$f":"'HULP-velden'!Z23","v":153.32380976675142},{"$f":"'HULP-velden'!AA23","v":161.38015895285548},{"$f":"'HULP-velden'!AB23","v":169.43650813895954},{"$f":"'HULP-velden'!AC23","v":177.4928573250636},{"$f":"'HULP-velden'!AD23","v":185.54920651116763},{"$f":"'HULP-velden'!AE23","v":193.60555569727165},{"$f":"'HULP-velden'!AF23","v":201.66190488337571},{"$f":"'HULP-velden'!AG23","v":209.71825406947977},{"$f":"'HULP-velden'!AH23","v":217.77460325558383},{"$f":"'HULP-velden'!AI23","v":225.83095244168788},{"$f":"'HULP-velden'!AJ23","v":233.88730162779194},{"$f":"'HULP-velden'!AK23","v":241.94365081389594},{"$f":"'HULP-velden'!AL23","v":250},"EMVI"]
[null,"P berekend uit Q en EMVI=1,1",null,{"$f":"'HULP-velden'!P24","v":0},{"$f":"'HULP-velden'!Q24","v":17672.133879388752},{"$f":"'HULP-velden'!R24","v":24951.56022943393},{"$f":"'HULP-velden'!S24","v":35171.687768574368},{"$f":"'HULP-velden'!T24","v":49412.982705721683},{"$f":"'HULP-velden'!U24","v":60114.77121438289},{"$f":"'HULP-velden'!V24","v":68945.458119697927},{"$f":"'HULP-velden'!W24","v":76555.302176976853},{"$f":"'HULP-velden'!X24","v":83279.649413150313},{"$f":"'HULP-velden'!Y24","v":89318.717748532377},{"$f":"'HULP-velden'!Z24","v":94803.556330986554},{"$f":"'HULP-velden'!AA24","v":99825.562180530076},{"$f":"'HULP-velden'!AB24","v":104451.515332287},{"$f":"'HULP-velden'!AC24","v":108731.97719465455},{"$f":"'HULP-velden'!AD24","v":112706.31878028199},{"$f":"'HULP-velden'!AE24","v":116405.89907836285},{"$f":"'HULP-velden'!AF24","v":119856.16382304762},{"$f":"'HULP-velden'!AG24","v":123078.08209185029},{"$f":"'HULP-velden'!AH24","v":126089.15970588048},{"$f":"'HULP-velden'!AI24","v":128904.1726173269},{"$f":"'HULP-velden'!AJ24","v":131535.70944757154},{"$f":"'HULP-velden'!AK24","v":133994.58056387986},{"$f":"'HULP-velden'!AL24","v":136290.13170439011},1.1000000000000001]
[null,null,null,{"$f":"'HULP-velden'!P25","v":35.549206511167611},{"$f":"'HULP-velden'!Q25","v":36.35484142977802},{"$f":"'HULP-velden'!R25","v":37.160476348388428},{"$f":"'HULP-velden'!S25","v":38.771746185609231},{"$f":"'HULP-velden'!T25","v":41.994285860050859},{"$f":"'HULP-velden'!U25","v":45.216825534492472},{"$f":"'HULP-velden'!V25","v":48.439365208934085},{"$f":"'HULP-velden'!W25","v":51.661904883375712},{"$f":"'HULP-velden'!X25","v":54.884444557817332},{"$f":"'HULP-velden'!Y25","v":58.106984232258952},{"$f":"'HULP-velden'!Z25","v":61.329523906700565},{"$f":"'HULP-velden'!AA25","v":64.552063581142193},{"$f":"'HULP-velden'!AB25","v":67.774603255583827},{"$f":"'HULP-velden'!AC25","v":70.997142930025433},{"$f":"'HULP-velden'!AD25","v":74.219682604467053},{"$f":"'HULP-velden'!AE25","v":77.442222278908659},{"$f":"'HULP-velden'!AF25","v":80.664761953350279},{"$f":"'HULP-velden'!AG25","v":83.887301627791913},{"$f":"'HULP-velden'!AH25","v":87.109841302233519},{"$f":"'HULP-velden'!AI25","v":90.332380976675154},{"$f":"'HULP-velden'!AJ25","v":93.554920651116774},{"$f":"'HULP-velden'!AK25","v":96.77746032555838},{"$f":"'HULP-velden'!AL25","v":100},0]
[]
[null,"Hulpvelden t.b.v grafiek",null,null,null,"Exponent","Pref","Qref"]
[null,"Referentie",{"$f":"+'HULP-velden'!H54","v":100000},{"$f":"+'HULP-velden'!I54","v":80},null,{"$f":"+'HULP-velden'!H112","v":2},{"$f":"+'HULP-velden'!H113","v":100000},{"$f":"+'HULP-velden'!H114","v":200}]
[null,"Referentie (Qmax)",{"$f":"+'HULP-velden'!H55","v":119895.78808281798},{"$f":"+'HULP-velden'!I55","v":100}]
[null,"Qmax",{"$f":"+'HULP-velden'!H43","v":100},{"$f":"+'HULP-velden'!I43","v":100},null,"Qmax",{"$f":"+'HULP-velden'!H109","v":250}]
[null,"Qmin",{"$f":"+'HULP-velden'!H44","v":60},{"$f":"+'HULP-velden'!I44","v":60},null,"Qmin",{"$f":"+'HULP-velden'!H110","v":150}]
[null,"Qref",{"$f":"+'HULP-velden'!H45","v":80},{"$f":"+'HULP-velden'!I45","v":80},null,"Qwensen",{"$f":"+G40-G41","v":100}]
[null,"P",{"$f":"+'HULP-velden'!H47","v":0},{"$f":"+'HULP-velden'!I47","v":200000.00000000006},null,"LAQ",{"$f":"+'HULP-velden'!H57","v":-10},{"$f":"+G43","v":-10},"genormaliseerd"]
[null,"Bonus (extra)",{"$f":"+'HULP-velden'!H53","v":160},{"$f":"+'HULP-velden'!I53","v":160},null,"LAQ (norm)",{"$f":"+'HULP-velden'!H58","v":-4},{"$f":"+G44","v":-4}]
[null,"Qeisen",{"$f":"+'HULP-velden'!J86","v":30},{"$f":"+'HULP-velden'!K86","v":10000},null,"Uw Inschrijving",{"$f":"+'BPK-Grafiek'!$F$14/G40*100","v":60},{"$f":"+'BPK-Grafiek'!$F$9","v":0}]
[null,"Qwensen",{"$f":"+'HULP-velden'!J87","v":80},{"$f":"+'HULP-velden'!K87","v":10000},null,"Kenmerk",{"$f":"Superformule!G7","v":0}]
[null,"Qbonus",{"$f":"+'HULP-velden'!J88","v":130},{"$f":"+'HULP-velden'!K88","v":10000},null,"Naam",{"$f":"Superformule!G6","v":0}]