{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Simulateur","Questionnaire","Image"],"not_rendered":{"charts":1,"images":5,"macros":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Simulateur","index":0,"n_rows":34,"n_cols":22,"rows_kept":34,"merged":[[0,0,1,6],[2,8,2,9],[3,4,3,5],[4,4,4,5],[5,4,5,5],[6,4,6,5],[9,3,9,4],[10,3,10,4],[12,3,12,4],[19,7,23,8]]}
["Simulateur pour calcul du salaire coordonné effectif",{"$nulls":10},"Valeurs historiques"]
[]
[{"$nulls":8},"Salaire cotisant"]
[{"$nulls":3},"annuel 2015","mensuel 2015",{"$nulls":3},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"annuel 2011-12","mensuel 2011-12",null,"annuel 2009-10","mensuel 2009-10",null,"annuel 2006","mensuel 2006",null,"annuel 2015","mensuel 2015"]
[null,null,"Seuil d'entrée",{"v":21150,"d":"21,150.-"},{"$f":"D5/12","v":{"v":1762.5,"d":"1,762.50"}},{"$nulls":3},{"$f":"E5","v":{"v":1762.5,"d":"1,762.50"}},{"$f":"E6-E5","v":293.75},"min",20880,{"v":1612.5,"d":"1,612.50"},null,"20'520.-",{"v":1710,"d":"1,710.00"},null,"19'350.-",{"v":1612.5,"d":"1,612.50"},null,{"v":21060,"d":"21,060.-"},{"$f":"U5/12","v":{"v":1755,"d":"1,755.00"}}]
[null,null,"Salaire assuré  minimum",{"v":24675,"d":"24,675.-"},{"$f":"D6/12","v":{"v":2056.25,"d":"2,056.25"}},{"$nulls":3},{"$f":"E6+(E6-E5)","v":{"v":2350,"d":"2,350.00"}},{"$f":"G11","v":{"v":2943.75,"d":"2,943.75"}},null,24360,{"v":1881.25,"d":"1,881.25"},null,"23'940.-",{"v":1995,"d":"1,995.00"},null,"22'575.-",{"v":1881.25,"d":"1,881.25"},null,{"v":24570,"d":"24,570.-"},{"$f":"U6/12","v":{"v":2047.5,"d":"2,047.50"}}]
[null,null,"Salaire assuré maximum",{"v":84600,"d":"84,600.-"},{"$f":"D7/12","v":{"v":7050,"d":"7,050.00"}},{"$nulls":3},{"$f":"E7","v":{"v":7050,"d":"7,050.00"}},{"$f":"(D7-D6)/12","v":{"v":4993.75,"d":"4,993.75"}},"max",83520,{"v":6450,"d":"6,450.00"},null,"82'080.-",{"v":6840,"d":"6,840.00"},null,"77'400.-",{"v":6450,"d":"6,450.00"},null,{"v":84240,"d":"84,240.-"},{"$f":"U7/12","v":{"v":7020,"d":"7,020.00"}}]
[{"$nulls":8},{"v":20000,"d":"20,000.00"}]
[null,"+"]
[null,null,"Salaire brut","Salaire cotisant LPP",null,null,"Salaire coordonné"]
[null,null,{"v":5000,"d":"5,000.00"},{"$f":"LOOKUP(C11,I4:J8)","v":{"v":2943.75,"d":"2,943.75"}},null,{"v":10000,"d":"10,000.00"},{"$f":"C11-E6","v":{"v":2943.75,"d":"2,943.75"}}]
[null,"-"]
[null,"annuel ->",{"$f":"C11*12","v":{"v":60000,"d":"60,000.00"}},{"$f":"D11*12","v":{"v":35325,"d":"35,325.00"}},null,null,{"$f":"G11*12","v":{"v":35325,"d":"35,325.00"}}]
[]
[{"$f":"IF(D11=0,0,IF(D11=J5,2,IF(D11=J7,2,1)))","v":1}]
[]
[null,null,{"$f":"C11","v":{"v":5000,"d":"5,000.00"}},{"$f":"D11","v":{"v":2943.75,"d":"2,943.75"}},10000]
{"$rows_empty":16}
[null,"http://www.vdfisc.ch/salaires.htm"]

{"sheet":"Questionnaire","index":1,"n_rows":24,"n_cols":15,"rows_kept":24,"merged":[[23,2,23,8]]}
[]
[]
[]
[null,null,"Salaire brut","Salaire cotisant LPP"]
[]
[null,null,{"v":6700,"d":"6,700.-"},{"$f":"IF(AND(C6>=2000,C6<=2200),Simulateur!$J$5,C6-Simulateur!$E$6)","v":4643.75},{"$nulls":3},{"$f":"IF(C6<Simulateur!$E$5,0,IF(AND(C6>Simulateur!$I$5-0.1,C6<Simulateur!$I$6),Simulateur!$J$5,IF(C6>Simulateur!$E$7,Simulateur!$J$7,IF(C6>Simulateur!$E$6-0.1,C6-Simulateur!$E$6))))","v":4643.75},null,{"$f":"IF(H6=D6,TRUE,FALSE)","v":true},{"$f":"IF(O6=0,\"\",IF(J6=F6,\"Juste\",\"          Pas d'accord !\"))","v":""},null,{"$f":"IF(F6=FALSE,0,1)","v":0},{"$f":"IF(G6=FALSE,0,1)","v":0},{"$f":"SUM(M6:N6)","v":0}]
[null,null,{"v":1700,"d":"1,700.-"},{"$f":"IF(AND(C7>=2000,C7<=2200),Simulateur!$J$5,C7-Simulateur!$E$6)","v":{"v":-356.25,"d":"356.25"}},{"$nulls":3},{"$f":"IF(C7<Simulateur!$E$5,0,IF(AND(C7>Simulateur!$I$5-0.1,C7<Simulateur!$I$6),Simulateur!$J$5,IF(C7>Simulateur!$E$7,Simulateur!$J$7,IF(C7>Simulateur!$E$6-0.1,C7-Simulateur!$E$6))))","v":0},null,{"$f":"IF(H7=D7,TRUE,FALSE)","v":false},{"$f":"IF(O7=0,\"\",IF(J7=F7,\"Juste\",\"          Pas d'accord !\"))","v":""},null,{"$f":"IF(F7=FALSE,0,1)","v":0},{"$f":"IF(G7=FALSE,0,1)","v":0},{"$f":"SUM(M7:N7)","v":0}]
[null,null,{"v":1200,"d":"1,200.-"},{"$f":"IF(AND(C8>=2000,C8<=2200),Simulateur!$J$5,C8-Simulateur!$E$6)","v":{"v":-856.25,"d":"856.25"}},{"$nulls":3},{"$f":"IF(C8<Simulateur!$E$5,0,IF(AND(C8>Simulateur!$I$5-0.1,C8<Simulateur!$I$6),Simulateur!$J$5,IF(C8>Simulateur!$E$7,Simulateur!$J$7,IF(C8>Simulateur!$E$6-0.1,C8-Simulateur!$E$6))))","v":0},null,false,"",null,0,0,0]
[null,null,{"v":5200,"d":"5,200.-"},{"$f":"IF(AND(C9>=2000,C9<=2200),Simulateur!$J$5,C9-Simulateur!$E$6)","v":3143.75},{"$nulls":3},{"$f":"IF(C9<Simulateur!$E$5,0,IF(AND(C9>Simulateur!$I$5-0.1,C9<Simulateur!$I$6),Simulateur!$J$5,IF(C9>Simulateur!$E$7,Simulateur!$J$7,IF(C9>Simulateur!$E$6-0.1,C9-Simulateur!$E$6))))","v":3143.75},null,true,"",null,0,0,0]
[null,null,{"v":2400,"d":"2,400.-"},{"$f":"IF(AND(C10>=2000,C10<=2200),Simulateur!$J$5,C10-Simulateur!$E$6)","v":343.75},{"$nulls":3},{"$f":"IF(C10<Simulateur!$E$5,0,IF(AND(C10>Simulateur!$I$5-0.1,C10<Simulateur!$I$6),Simulateur!$J$5,IF(C10>Simulateur!$E$7,Simulateur!$J$7,IF(C10>Simulateur!$E$6-0.1,C10-Simulateur!$E$6))))","v":343.75},null,true,"",null,0,0,0]
[null,null,{"v":1900,"d":"1,900.-"},{"$f":"IF(AND(C11>=2000,C11<=2200),Simulateur!$J$5,C11-Simulateur!$E$6)","v":{"v":-156.25,"d":"156.25"}},{"$nulls":3},{"$f":"IF(C11<Simulateur!$E$5,0,IF(AND(C11>Simulateur!$I$5-0.1,C11<Simulateur!$I$6),Simulateur!$J$5,IF(C11>Simulateur!$E$7,Simulateur!$J$7,IF(C11>Simulateur!$E$6-0.1,C11-Simulateur!$E$6))))","v":293.75},null,false,"",null,0,0,0]
[null,null,{"v":2700,"d":"2,700.-"},{"$f":"IF(AND(C12>=2000,C12<=2200),Simulateur!$J$5,C12-Simulateur!$E$6)","v":643.75},{"$nulls":3},{"$f":"IF(C12<Simulateur!$E$5,0,IF(AND(C12>Simulateur!$I$5-0.1,C12<Simulateur!$I$6),Simulateur!$J$5,IF(C12>Simulateur!$E$7,Simulateur!$J$7,IF(C12>Simulateur!$E$6-0.1,C12-Simulateur!$E$6))))","v":643.75},null,true,"",null,0,0,0]
[null,null,{"v":6700,"d":"6,700.-"},{"$f":"IF(AND(C13>=2000,C13<=2200),Simulateur!$J$5,C13-Simulateur!$E$6)","v":4643.75},{"$nulls":3},{"$f":"IF(C13<Simulateur!$E$5,0,IF(AND(C13>Simulateur!$I$5-0.1,C13<Simulateur!$I$6),Simulateur!$J$5,IF(C13>Simulateur!$E$7,Simulateur!$J$7,IF(C13>Simulateur!$E$6-0.1,C13-Simulateur!$E$6))))","v":4643.75},null,true,"",null,0,0,0]
[null,null,{"v":200,"d":"200.-"},{"$f":"IF(AND(C14>=2000,C14<=2200),Simulateur!$J$5,C14-Simulateur!$E$6)","v":{"v":-1856.25,"d":"1856.25"}},{"$nulls":3},{"$f":"IF(C14<Simulateur!$E$5,0,IF(AND(C14>Simulateur!$I$5-0.1,C14<Simulateur!$I$6),Simulateur!$J$5,IF(C14>Simulateur!$E$7,Simulateur!$J$7,IF(C14>Simulateur!$E$6-0.1,C14-Simulateur!$E$6))))","v":0},null,false,"",null,0,0,0]
[null,null,{"v":1600,"d":"1,600.-"},{"$f":"IF(AND(C15>=2000,C15<=2200),Simulateur!$J$5,C15-Simulateur!$E$6)","v":{"v":-456.25,"d":"456.25"}},{"$nulls":3},{"$f":"IF(C15<Simulateur!$E$5,0,IF(AND(C15>Simulateur!$I$5-0.1,C15<Simulateur!$I$6),Simulateur!$J$5,IF(C15>Simulateur!$E$7,Simulateur!$J$7,IF(C15>Simulateur!$E$6-0.1,C15-Simulateur!$E$6))))","v":0},null,false,"",null,0,0,0]
[null,null,{"v":4500,"d":"4,500.-"},{"$f":"IF(AND(C16>=2000,C16<=2200),Simulateur!$J$5,C16-Simulateur!$E$6)","v":2443.75},{"$nulls":3},{"$f":"IF(C16<Simulateur!$E$5,0,IF(AND(C16>Simulateur!$I$5-0.1,C16<Simulateur!$I$6),Simulateur!$J$5,IF(C16>Simulateur!$E$7,Simulateur!$J$7,IF(C16>Simulateur!$E$6-0.1,C16-Simulateur!$E$6))))","v":2443.75},null,true,"",null,0,0,0]
[null,null,{"v":7200,"d":"7,200.-"},{"$f":"IF(AND(C17>=2000,C17<=2200),Simulateur!$J$5,C17-Simulateur!$E$6)","v":5143.75},{"$nulls":3},{"$f":"IF(C17<Simulateur!$E$5,0,IF(AND(C17>Simulateur!$I$5-0.1,C17<Simulateur!$I$6),Simulateur!$J$5,IF(C17>Simulateur!$E$7,Simulateur!$J$7,IF(C17>Simulateur!$E$6-0.1,C17-Simulateur!$E$6))))","v":4993.75},null,false,"",null,0,0,0]
[null,null,{"v":1400,"d":"1,400.-"},{"$f":"IF(AND(C18>=2000,C18<=2200),Simulateur!$J$5,C18-Simulateur!$E$6)","v":{"v":-656.25,"d":"656.25"}},{"$nulls":3},{"$f":"IF(C18<Simulateur!$E$5,0,IF(AND(C18>Simulateur!$I$5-0.1,C18<Simulateur!$I$6),Simulateur!$J$5,IF(C18>Simulateur!$E$7,Simulateur!$J$7,IF(C18>Simulateur!$E$6-0.1,C18-Simulateur!$E$6))))","v":0},null,false,"",null,0,0,0]
[null,null,{"v":2100,"d":"2,100.-"},{"$f":"IF(AND(C19>=2000,C19<=2200),Simulateur!$J$5,C19-Simulateur!$E$6)","v":293.75},{"$nulls":3},{"$f":"IF(C19<Simulateur!$E$5,0,IF(AND(C19>Simulateur!$I$5-0.1,C19<Simulateur!$I$6),Simulateur!$J$5,IF(C19>Simulateur!$E$7,Simulateur!$J$7,IF(C19>Simulateur!$E$6-0.1,C19-Simulateur!$E$6))))","v":293.75},null,true,"",null,0,0,0]
[null,null,{"v":7900,"d":"7,900.-"},{"$f":"IF(AND(C20>=2000,C20<=2200),Simulateur!$J$5,C20-Simulateur!$E$6)","v":5843.75},{"$nulls":3},{"$f":"IF(C20<Simulateur!$E$5,0,IF(AND(C20>Simulateur!$I$5-0.1,C20<Simulateur!$I$6),Simulateur!$J$5,IF(C20>Simulateur!$E$7,Simulateur!$J$7,IF(C20>Simulateur!$E$6-0.1,C20-Simulateur!$E$6))))","v":4993.75},null,false,"",null,0,0,0]
[{"$nulls":12},{"$f":"COUNTIF(K6:K20,\"Juste\")","v":0}]
[{"$nulls":12},{"$f":"IF(M21<2,\" bonne réponse\",\" bonnes réponses\")","v":" bonne réponse"}]
[]
[null,null,{"$f":"M21 & M22 &\" / 15\"","v":"0 bonne réponse / 15"}]

{"sheet":"Image","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}