{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Questions 1 à 3","Question 4","Macro - Sélection multiple"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Questions 1 à 3","index":0,"n_rows":221,"n_cols":8,"rows_kept":221,"cut":false,"hidden":false,"merged":[]}
["Salaire 1",20000,null,null,"Salaire 1","Salaire 2","Nb.Enfants","Impôts"]
["Salaire 2",0,null,null,20000,0,0,444.05999999999995]
["Nombre d'enfants",0,null,null,20000,0,1,280.07499999999993]
[null,null,null,null,20000,0,2,116.08999999999992]
["Revenu disp. (imposable)",{"$f":"B1+B2","v":20000},null,null,20000,0,3,0]
["Parts",{"$f":"2+IF((B3-2)>0,0.5*2+(B3-2),0.5*B3)","v":2},null,null,20000,0,4,0]
[null,null,null,null,20000,0,5,0]
["Quotient familial",{"$f":"B5/B6","v":10000},null,null,20000,0,6,0]
[null,null,null,null,20000,0,7,0]
["Impôts",{"$f":"MonImpot(B5,B8,B6)","v":444.05999999999995},null,null,20000,0,8,0]
[null,null,null,null,20000,0,9,0]
[null,null,null,null,20000,0,10,0]
[null,null,null,null,20000,10000,0,1521.7400000000002]
[null,null,null,null,20000,10000,1,852.17500000000018]
["Nb.Enfants",{"$f":"B10","v":444.05999999999995},null,null,20000,10000,2,666.08999999999992]
[0,444.05999999999995,null,null,20000,10000,3,338.11999999999989]
[1,280.07499999999993,null,null,20000,10000,4,10.149999999999872]
[2,116.08999999999992,null,null,20000,10000,5,0]
[3,0,null,null,20000,10000,6,0]
[4,0,null,null,20000,10000,7,0]
[5,0,null,null,20000,10000,8,0]
[6,0,null,null,20000,10000,9,0]
[7,0,null,null,20000,10000,10,0]
[8,0,null,null,20000,20000,0,2921.7400000000002]
[9,0,null,null,20000,20000,1,2252.1750000000002]
[10,0,null,null,20000,20000,2,1582.6100000000001]
[null,null,null,null,20000,20000,3,888.11999999999989]
[null,null,null,null,20000,20000,4,560.14999999999986]
[null,null,null,null,20000,20000,5,232.17999999999984]
[null,null,null,null,20000,20000,6,0]
[null,null,null,null,20000,20000,7,0]
[null,null,null,null,20000,20000,8,0]
[null,null,null,null,20000,20000,9,0]
[null,null,null,null,20000,20000,10,0]
[null,null,null,null,20000,30000,0,4321.7400000000007]
[null,null,null,null,20000,30000,1,3652.1750000000002]
[null,null,null,null,20000,30000,2,2982.61]
[null,null,null,null,20000,30000,3,1643.4800000000002]
[null,null,null,null,20000,30000,4,1110.1499999999999]
[null,null,null,null,20000,30000,5,782.17999999999984]
[null,null,null,null,20000,30000,6,454.20999999999981]
[null,null,null,null,20000,30000,7,126.2399999999998]
[null,null,null,null,20000,30000,8,0]
[null,null,null,null,20000,30000,9,0]
[null,null,null,null,20000,30000,10,0]
[null,null,null,null,25000,0,0,821.74000000000012]
[null,null,null,null,25000,0,1,555.07499999999993]
[null,null,null,null,25000,0,2,391.08999999999992]
[null,null,null,null,25000,0,3,63.119999999999898]
[null,null,null,null,25000,0,4,0]
[null,null,null,null,25000,0,5,0]
[null,null,null,null,25000,0,6,0]
[null,null,null,null,25000,0,7,0]
[null,null,null,null,25000,0,8,0]
[null,null,null,null,25000,0,9,0]
[null,null,null,null,25000,0,10,0]
[null,null,null,null,25000,10000,0,2221.7400000000002]
[null,null,null,null,25000,10000,1,1552.1750000000002]
[null,null,null,null,25000,10000,2,941.08999999999992]
[null,null,null,null,25000,10000,3,613.11999999999989]
[null,null,null,null,25000,10000,4,285.14999999999986]
[null,null,null,null,25000,10000,5,0]
[null,null,null,null,25000,10000,6,0]
[null,null,null,null,25000,10000,7,0]
[null,null,null,null,25000,10000,8,0]
[null,null,null,null,25000,10000,9,0]
[null,null,null,null,25000,10000,10,0]
[null,null,null,null,25000,20000,0,3621.7400000000002]
[null,null,null,null,25000,20000,1,2952.1750000000002]
[null,null,null,null,25000,20000,2,2282.61]
[null,null,null,null,25000,20000,3,1163.1199999999999]
[null,null,null,null,25000,20000,4,835.14999999999986]
[null,null,null,null,25000,20000,5,507.17999999999984]
[null,null,null,null,25000,20000,6,179.20999999999981]
[null,null,null,null,25000,20000,7,0]
[null,null,null,null,25000,20000,8,0]
[null,null,null,null,25000,20000,9,0]
[null,null,null,null,25000,20000,10,0]
[null,null,null,null,25000,30000,0,5367.3399999999992]
[null,null,null,null,25000,30000,1,4352.1750000000002]
[null,null,null,null,25000,30000,2,3682.6100000000006]
[null,null,null,null,25000,30000,3,2343.4800000000005]
[null,null,null,null,25000,30000,4,1385.1499999999999]
[null,null,null,null,25000,30000,5,1057.1799999999998]
[null,null,null,null,25000,30000,6,729.20999999999981]
[null,null,null,null,25000,30000,7,401.23999999999978]
[null,null,null,null,25000,30000,8,73.269999999999769]
[null,null,null,null,25000,30000,9,0]
[null,null,null,null,25000,30000,10,0]
[null,null,null,null,30000,0,0,1521.7400000000002]
[null,null,null,null,30000,0,1,852.17500000000018]
[null,null,null,null,30000,0,2,666.08999999999992]
[null,null,null,null,30000,0,3,338.11999999999989]
[null,null,null,null,30000,0,4,10.149999999999872]
[null,null,null,null,30000,0,5,0]
[null,null,null,null,30000,0,6,0]
[null,null,null,null,30000,0,7,0]
[null,null,null,null,30000,0,8,0]
[null,null,null,null,30000,0,9,0]
[null,null,null,null,30000,0,10,0]
[null,null,null,null,30000,10000,0,2921.7400000000002]
[null,null,null,null,30000,10000,1,2252.1750000000002]
[null,null,null,null,30000,10000,2,1582.6100000000001]
[null,null,null,null,30000,10000,3,888.11999999999989]
[null,null,null,null,30000,10000,4,560.14999999999986]
[null,null,null,null,30000,10000,5,232.17999999999984]
[null,null,null,null,30000,10000,6,0]
[null,null,null,null,30000,10000,7,0]
[null,null,null,null,30000,10000,8,0]
[null,null,null,null,30000,10000,9,0]
[null,null,null,null,30000,10000,10,0]
[null,null,null,null,30000,20000,0,4321.7400000000007]
[null,null,null,null,30000,20000,1,3652.1750000000002]
[null,null,null,null,30000,20000,2,2982.61]
[null,null,null,null,30000,20000,3,1643.4800000000002]
[null,null,null,null,30000,20000,4,1110.1499999999999]
[null,null,null,null,30000,20000,5,782.17999999999984]
[null,null,null,null,30000,20000,6,454.20999999999981]
[null,null,null,null,30000,20000,7,126.2399999999998]
[null,null,null,null,30000,20000,8,0]
[null,null,null,null,30000,20000,9,0]
[null,null,null,null,30000,20000,10,0]
[null,null,null,null,30000,30000,0,6867.3399999999992]
[null,null,null,null,30000,30000,1,5052.1750000000002]
[null,null,null,null,30000,30000,2,4382.6100000000006]
[null,null,null,null,30000,30000,3,3043.4800000000005]
[null,null,null,null,30000,30000,4,1704.3500000000004]
[null,null,null,null,30000,30000,5,1332.1799999999998]
[null,null,null,null,30000,30000,6,1004.2099999999998]
[null,null,null,null,30000,30000,7,676.23999999999978]
[null,null,null,null,30000,30000,8,348.26999999999975]
[null,null,null,null,30000,30000,9,20.299999999999745]
[null,null,null,null,30000,30000,10,0]
[null,null,null,null,35000,0,0,2221.7400000000002]
[null,null,null,null,35000,0,1,1552.1750000000002]
[null,null,null,null,35000,0,2,941.08999999999992]
[null,null,null,null,35000,0,3,613.11999999999989]
[null,null,null,null,35000,0,4,285.14999999999986]
[null,null,null,null,35000,0,5,0]
[null,null,null,null,35000,0,6,0]
[null,null,null,null,35000,0,7,0]
[null,null,null,null,35000,0,8,0]
[null,null,null,null,35000,0,9,0]
[null,null,null,null,35000,0,10,0]
[null,null,null,null,35000,10000,0,3621.7400000000002]
[null,null,null,null,35000,10000,1,2952.1750000000002]
[null,null,null,null,35000,10000,2,2282.61]
[null,null,null,null,35000,10000,3,1163.1199999999999]
[null,null,null,null,35000,10000,4,835.14999999999986]
[null,null,null,null,35000,10000,5,507.17999999999984]
[null,null,null,null,35000,10000,6,179.20999999999981]
[null,null,null,null,35000,10000,7,0]
[null,null,null,null,35000,10000,8,0]
[null,null,null,null,35000,10000,9,0]
[null,null,null,null,35000,10000,10,0]
[null,null,null,null,35000,20000,0,5367.3399999999992]
[null,null,null,null,35000,20000,1,4352.1750000000002]
[null,null,null,null,35000,20000,2,3682.6100000000006]
[null,null,null,null,35000,20000,3,2343.4800000000005]
[null,null,null,null,35000,20000,4,1385.1499999999999]
[null,null,null,null,35000,20000,5,1057.1799999999998]
[null,null,null,null,35000,20000,6,729.20999999999981]
[null,null,null,null,35000,20000,7,401.23999999999978]
[null,null,null,null,35000,20000,8,73.269999999999769]
[null,null,null,null,35000,20000,9,0]
[null,null,null,null,35000,20000,10,0]
[null,null,null,null,35000,30000,0,8367.34]
[null,null,null,null,35000,30000,1,5752.1750000000002]
[null,null,null,null,35000,30000,2,5082.6100000000006]
[null,null,null,null,35000,30000,3,3743.4800000000005]
[null,null,null,null,35000,30000,4,2404.3500000000004]
[null,null,null,null,35000,30000,5,1607.1799999999998]
[null,null,null,null,35000,30000,6,1279.2099999999998]
[null,null,null,null,35000,30000,7,951.23999999999978]
[null,null,null,null,35000,30000,8,623.26999999999975]
[null,null,null,null,35000,30000,9,295.29999999999973]
[null,null,null,null,35000,30000,10,0]
[null,null,null,null,40000,0,0,2921.7400000000002]
[null,null,null,null,40000,0,1,2252.1750000000002]
[null,null,null,null,40000,0,2,1582.6100000000001]
[null,null,null,null,40000,0,3,888.11999999999989]
[null,null,null,null,40000,0,4,560.14999999999986]
[null,null,null,null,40000,0,5,232.17999999999984]
[null,null,null,null,40000,0,6,0]
[null,null,null,null,40000,0,7,0]
[null,null,null,null,40000,0,8,0]
[null,null,null,null,40000,0,9,0]
[null,null,null,null,40000,0,10,0]
[null,null,null,null,40000,10000,0,4321.7400000000007]
[null,null,null,null,40000,10000,1,3652.1750000000002]
[null,null,null,null,40000,10000,2,2982.61]
[null,null,null,null,40000,10000,3,1643.4800000000002]
[null,null,null,null,40000,10000,4,1110.1499999999999]
[null,null,null,null,40000,10000,5,782.17999999999984]
[null,null,null,null,40000,10000,6,454.20999999999981]
[null,null,null,null,40000,10000,7,126.2399999999998]
[null,null,null,null,40000,10000,8,0]
[null,null,null,null,40000,10000,9,0]
[null,null,null,null,40000,10000,10,0]
[null,null,null,null,40000,20000,0,6867.3399999999992]
[null,null,null,null,40000,20000,1,5052.1750000000002]
[null,null,null,null,40000,20000,2,4382.6100000000006]
[null,null,null,null,40000,20000,3,3043.4800000000005]
[null,null,null,null,40000,20000,4,1704.3500000000004]
[null,null,null,null,40000,20000,5,1332.1799999999998]
[null,null,null,null,40000,20000,6,1004.2099999999998]
[null,null,null,null,40000,20000,7,676.23999999999978]
[null,null,null,null,40000,20000,8,348.26999999999975]
[null,null,null,null,40000,20000,9,20.299999999999745]
[null,null,null,null,40000,20000,10,0]
[null,null,null,null,40000,30000,0,9867.34]
[null,null,null,null,40000,30000,1,7084.1749999999993]
[null,null,null,null,40000,30000,2,5782.6100000000006]
[null,null,null,null,40000,30000,3,4443.4800000000005]
[null,null,null,null,40000,30000,4,3104.3500000000004]
[null,null,null,null,40000,30000,5,1882.1799999999998]
[null,null,null,null,40000,30000,6,1554.2099999999998]
[null,null,null,null,40000,30000,7,1226.2399999999998]
[null,null,null,null,40000,30000,8,898.26999999999975]
[null,null,null,null,40000,30000,9,570.29999999999973]
[null,null,null,null,40000,30000,10,242.32999999999973]

{"sheet":"Question 4","index":1,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Salaire 1",25000]
["Salaire 2"]
["Nombre d'enfants",1]
[]
["Revenu disp.",{"$f":"B1+B2","v":25000}]
["Parts",{"$f":"IF(ISBLANK(B1),0,1)+IF(ISBLANK(B2),0,1)+IF((B3-2)>0,0.5*2+(B3-2),0.5*B3)","v":1.5}]
[]
["QF",{"$f":"B5/B6","v":16666.666666666668}]
[]
["Impôts",{"$f":"MonImpot(B5,B8,B6)","v":1491.3050000000001}]

{"sheet":"Macro - Sélection multiple","index":2,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,1,2]
[null,5,6]
[]
[]
[null,null,null,8,5,8]
[null,null,null,3,3,4]
[]
[]
[]
[null,null,2,5]
[null,null,6,7]
[null,null,5,2]
[null,null,1,3]