{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Blad1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Blad1","index":0,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,9],[2,9,2,11],[4,6,4,7]]}
["3) Het aantal dagen (kolom f) mag enkel verschijnen als de einddatum gekend is. \nVanaf 7dagen krijgt de klant 10% korting, vanaf 14 20% korting. \nDe kortingen worden verleend op het totale aantal dagen. \nEr is geen korting en geen btw op verzekeringen.\n"]
[]
["klasse ","type","dagprijs","verzekering per dag",null,null,"btw",0.21,null,"prijzentabel"]
["a","Renault",26,7.5]
["b","Peugeot",31,7.5,null,null,"korting vanaf"]
["c","Fiat",23.5,7.5,null,null,7,0.1]
["d","Mitsubishi",35,9,null,null,14,0.2]
["e","Vw",46,10]
["f","BMW",50,11]
["g","Mercedes",56.5,11]
[]
["klant"," begint","einde","klasse","type","aantal dagen","totale huurpijs","korting","Totaal exclusief","btw","verzekering","totaal"]
["Devos","2012-04-14","2012-04-20","B",{"$f":"VLOOKUP(D13,A$3:B$10,2)","v":"Peugeot"},{"$f":"IF(OR(B13=\"\",C13=\"\"),\"\",DATEDIF(B13,C13,\"D\"))","v":6},{"$f":"IF(F13=\"\",\"\",F13*VLOOKUP(E13,B$3:C$10,2,FALSE))","v":186},{"$f":"IF(F13<>\"\",IF(AND(F13>=G$6,F13<G$7),G13*H$6,IF(F13>=G$7,G13*H$7,0)),\"\")","v":0},{"$f":"IF(F13<>\"\",(G13-H13),\"\")","v":186},{"$f":"IF(F13<>\"\",I13*$H$3,\"\")","v":39.059999999999995},{"$f":"IF(F13<>\"\",VLOOKUP(D13,$A$4:$D$10,4,FALSE)*F13,\"\")","v":45},{"$f":"IF(F13<>\"\",SUM(I13:K13),\"\")","v":270.06}]
["Lauwers","2012-04-18","2012-04-27","C",{"$f":"VLOOKUP(D14,A$3:B$10,2)","v":"Fiat"},{"$f":"IF(OR(B14=\"\",C14=\"\"),\"\",DATEDIF(B14,C14,\"D\"))","v":9},{"$f":"IF(F14=\"\",\"\",F14*VLOOKUP(E14,B$3:C$10,2,FALSE))","v":211.5},{"$f":"IF(F14<>\"\",IF(AND(F14>=G$6,F14<G$7),G14*H$6,IF(F14>=G$7,G14*H$7,0)),\"\")","v":21.150000000000002},{"$f":"IF(F14<>\"\",(G14-H14),\"\")","v":190.35},{"$f":"IF(F14<>\"\",I14*$H$3,\"\")","v":39.973499999999994},{"$f":"IF(F14<>\"\",VLOOKUP(D14,$A$4:$D$10,4,FALSE)*F14,\"\")","v":67.5},{"$f":"IF(F14<>\"\",SUM(I14:K14),\"\")","v":297.82349999999997}]
["Verlinden","2012-04-25","2012-05-15","A","Renault",20,520,{"$f":"IF(F15<>\"\",IF(AND(F15>=G$6,F15<G$7),G15*H$6,IF(F15>=G$7,G15*H$7,0)),\"\")","v":104},416,87.36,150,653.36]
["Debaere","2012-05-02","2012-05-04","D","Mitsubishi",2,70,{"$f":"IF(F16<>\"\",IF(AND(F16>=G$6,F16<G$7),G16*H$6,IF(F16>=G$7,G16*H$7,0)),\"\")","v":0},70,14.7,18,102.7]
["Van Parijs","2012-05-05","2012-05-15","E","Vw",10,460,{"$f":"IF(F17<>\"\",IF(AND(F17>=G$6,F17<G$7),G17*H$6,IF(F17>=G$7,G17*H$7,0)),\"\")","v":46},414,86.94,100,600.94000000000005]
["Wouters","2012-05-10",null,"F","BMW","","",{"$f":"IF(F18<>\"\",IF(AND(F18>=G$6,F18<G$7),G18*H$6,IF(F18>=G$7,G18*H$7,0)),\"\")","v":""},"","","",""]
["De Wilde","2012-05-13","2021-05-20","G","Mercedes",{"$f":"IF(OR(B19=\"\",C19=\"\"),\"\",DATEDIF(B19,C19,\"D\"))","v":3294},186111,{"$f":"IF(F19<>\"\",IF(AND(F19>=G$6,F19<G$7),G19*H$6,IF(F19>=G$7,G19*H$7,0)),\"\")","v":37222.200000000004},148888.79999999999,31266.647999999997,36234,216389.44799999997]