{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Blad1","Blad2","Blad3"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Blad1","index":0,"n_rows":35,"n_cols":42,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Prijselasticiteit van de vraag",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"www.jdjong.nl"]
["Gegeven zijn een (collectieve) vraagfunctie en de grafische weergave van deze functie. Bereken in een aantal stappen de prijselasticiteit van de vraag en  "]
["beoordeel daarna of de prijsverandering verstandig is geweest. Alleen de gele vakjes invullen. Antwoorden afronden op twee cijfers achter de komma."]
["Gegeven is de volgende vraagfunctie:"]
["qv","=","-",0.2,"p +",10]
["Stap 1",null,null,null,null,null,null,{"$f":"IF(J7<>\"\",IF(J7>=50,\"Kies een ander getal\",\"\"),\"\")","v":""}]
["Vul hier een prijs in (oude prijs)",null,null,null,null,null,null,null,null,null,null,null,null,"vraaglijn",null,null,"horizontale lijnen"]
["Vul hier een andere prijs in (nieuwe prijs)",null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"($F$5-N8)/$D$5","v":50},{"$f":"IF($J$7=45,45,\"\")","v":""},{"$f":"IF($J$7=40,40,\"\")","v":""},{"$f":"IF($J$7=35,35,\"\")","v":""},{"$f":"IF($J$7=30,30,\"\")","v":""},{"$f":"IF($J$7=25,25,\"\")","v":""},{"$f":"IF($J$7=20,20,\"\")","v":""},{"$f":"IF($J$7=15,15,\"\")","v":""},{"$f":"IF($J$7=10,10,\"\")","v":""},{"$f":"IF($J$7=5,5,\"\")","v":""},{"$f":"IF($J$8=45,45,\"\")","v":""},{"$f":"IF($J$8=40,40,\"\")","v":""},{"$f":"IF($J$8=35,35,\"\")","v":""},{"$f":"IF($J$8=30,30,\"\")","v":""},{"$f":"IF($J$8=25,25,\"\")","v":""},{"$f":"IF($J$8=20,20,\"\")","v":""},{"$f":"IF($J$8=15,15,\"\")","v":""},{"$f":"IF($J$8=10,10,\"\")","v":""},{"$f":"IF($J$8=5,5,\"\")","v":""}]
["(niet meer dan 5 hoger of lager)",null,null,null,null,null,null,{"$f":"IF(J8<>\"\",IF(OR(J8>J7+5,J8<J7-5),\"Kies een ander getal\",\"\"),\"\")","v":""},null,null,null,null,null,1,45,{"$f":"IF($J$7=45,45,\"\")","v":""},{"$f":"IF($J$7=40,40,\"\")","v":""},{"$f":"IF($J$7=35,35,\"\")","v":""},{"$f":"IF($J$7=30,30,\"\")","v":""},"","","","","",{"$f":"IF($J$8=45,45,\"\")","v":""},{"$f":"IF($J$8=40,40,\"\")","v":""},{"$f":"IF($J$8=35,35,\"\")","v":""},{"$f":"IF($J$8=30,30,\"\")","v":""},"","","","",""]
["Stap 2",null,null,null,null,null,null,null,null,null,null,null,null,2,40,null,{"$f":"IF($J$7=40,40,\"\")","v":""},{"$f":"IF($J$7=35,35,\"\")","v":""},{"$f":"IF($J$7=30,30,\"\")","v":""},"","","","","",null,{"$f":"IF($J$8=40,40,\"\")","v":""},{"$f":"IF($J$8=35,35,\"\")","v":""},{"$f":"IF($J$8=30,30,\"\")","v":""},"","","","",""]
["Bereken m.b.v. de grafiek en onderstaande ",null,null,null,null,null,null,null,null,null,null,null,null,3,35,null,null,{"$f":"IF($J$7=35,35,\"\")","v":""},{"$f":"IF($J$7=30,30,\"\")","v":""},"","","","","",null,null,{"$f":"IF($J$8=35,35,\"\")","v":""},{"$f":"IF($J$8=30,30,\"\")","v":""},"","","","",""]
["formule de prijselasticiteit van de vraag.",null,null,null,null,null,null,null,null,null,null,null,null,4,30,null,null,null,{"$f":"IF($J$7=30,30,\"\")","v":""},"","","","","",null,null,null,{"$f":"IF($J$8=30,30,\"\")","v":""},"","","","",""]
["(nieuw - oud /oud x 100%).",null,null,null,null,null,null,null,null,null,null,null,null,5,25,null,null,null,null,"","","","","",null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,6,20,null,null,null,null,null,"","","","",null,null,null,null,null,"","","",""]
[null,null,null,null,"-",null,"x",1,null,null,null,null,null,7,15,null,null,null,null,null,null,"","","",null,null,null,null,null,null,"","","",null,null,null,null,null,null,"oude q",{"$f":"(J7*-D5)+F5","v":10},{"$f":"(AO16-AO15)/AO15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,8,10,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,"","",null,null,null,null,null,null,"nieuwe q",{"$f":"(J8*-D5)+F5","v":10},{"$f":"(J8-J7)/J7","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"=",null,null,null,null,9,5,null,null,"verticale lijnen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,"Ev",{"$f":"((AO16-AO15)/AO15)/((J8-J7)/J7)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"-",null,"x",1,null,{"$f":"IF(J17<>\"\",IF(J17=ROUND(AO17,2),\"GOED\",\"FOUT\"),\"\")","v":""},null,null,null,10,0,null,1,null,0,5,null,0,9,0,1,null,0,5,null,0,9,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,{"$f":"IF(J7=45,45,\"\")","v":""},5,null,{"$f":"IF(J7=25,25,\"\")","v":""},9,{"$f":"IF(J7=5,5,\"\")","v":""},1,null,{"$f":"IF(J8=45,45,\"\")","v":""},5,null,{"$f":"IF(J8=25,25,\"\")","v":""},9,{"$f":"IF(J8=5,5,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,0,6,null,0,null,null,2,null,0,6,null,0,null,null,null,null,null,null,null,null,null,"oude omzet",{"$f":"J7*AO15","v":0}]
["Stap 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,{"$f":"IF(J7=40,40,\"\")","v":""},6,null,{"$f":"IF(J7=20,20,\"\")","v":""},null,null,2,null,{"$f":"IF(J8=40,40,\"\")","v":""},6,null,{"$f":"IF(J8=20,20,\"\")","v":""},null,null,null,null,null,null,null,null,null,"nieuwe omzet",{"$f":"J8*AO16","v":0}]
["Bereken de oude en nieuwe omzet.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,0,7,null,0,null,null,3,null,0,7,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,{"$f":"IF(J7=35,35,\"\")","v":""},7,null,{"$f":"IF(J7=15,15,\"\")","v":""},null,null,3,null,{"$f":"IF(J8=35,35,\"\")","v":""},7,null,{"$f":"IF(J8=15,15,\"\")","v":""}]
[null,null,null,"Oude omzet",null,null,"=",null,null,{"$f":"IF(H24<>\"\",IF(H24=ROUND(AO20,2),\"GOED\",\"FOUT\"),\"\")","v":""},null,null,null,null,null,null,4,null,0,8,null,0,null,null,4,null,0,8,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,{"$f":"IF(J7=30,30,\"\")","v":""},8,null,{"$f":"IF(J7=10,10,\"\")","v":""},null,null,4,null,{"$f":"IF(J8=30,30,\"\")","v":""},8,null,{"$f":"IF(J8=10,10,\"\")","v":""}]
[null,null,null,"Nieuwe omzet",null,null,"=",null,null,{"$f":"IF(H26<>\"\",IF(H26=ROUND(AO21,2),\"GOED\",\"FOUT\"),\"\")","v":""},null,null,null,null,null,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":"IF(AND(J8>J7,H26>H24,J17>=-1),\"x\",\"-\")","v":"-"}]
[]
["Stap 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(AND(J8<J7,H26<H24,J17>=-1),\"x\",\"-\")","v":"-"}]
["Beantwoord onderstaande vraag door een kruisje in het juiste vakje te plaatsen en op ENTER te drukken.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(AND(J8<J7,H26>H24,J17<=-1),\"x\",\"-\")","v":"-"}]
["Is de prijsverandering verstandig geweest?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(AND(J8>J7,H26<H24,J17<=-1),\"x\",\"-\")","v":"-"}]
[]
[{"$f":"IF(G32<>\"\",IF(G32=AN26,\"Het gekozen antwoord is goed\",\"Het gekozen antwoord is fout\"),\"\")","v":""},null,null,null,null,null,null,"Ja, bij een inelastische vraag is de procentuele prijsstijging groter dan de procentuele hoeveelheidsdaling. De omzet is toegenomen."]
[{"$f":"IF(G33<>\"\",IF(G33=AN28,\"Het gekozen antwoord is goed\",\"Het gekozen antwoord is fout\"),\"\")","v":""},null,null,null,null,null,null,"Nee, bij een inelastische vraag is de procentuele prijsdaling groter dan de procentuele hoeveelheidsstijging. De omzet is afgenomen."]
[{"$f":"IF(G34<>\"\",IF(G34=AN29,\"Het gekozen antwoord is goed\",\"Het gekozen antwoord is fout\"),\"\")","v":""},null,null,null,null,null,null,"Ja, bij een elastische vraag is de procentuele prijsdaling kleiner dan de procentuele hoeveelheidsstijging. De omzet is toegenomen."]
[{"$f":"IF(G35<>\"\",IF(G35=AN30,\"Het gekozen antwoord is goed\",\"Het gekozen antwoord is fout\"),\"\")","v":""},null,null,null,null,null,null,"Nee, bij een elastische vraag is de procentuele prijsstijging kleiner dan de procentuele hoeveelheidsdaling. De omzet is afgenomen."]

{"sheet":"Blad2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Blad3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}