{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Feuil1","Vide"],"read":"whole","date_system":"1900"}

{"sheet":"Feuil1","index":0,"n_rows":48,"n_cols":11,"rows_kept":48,"merged":[[1,4,1,11],[3,8,3,10],[6,3,6,6],[7,3,7,6],[11,4,11,8],[11,9,11,11],[16,4,16,5],[16,6,16,7],[20,2,20,9],[25,2,25,9],[27,4,27,5],[27,6,27,7],[38,4,38,5],[38,6,38,7]]}
[]
[null,"FABRICATION S.A.",null,null,"CONSTUCTIONS METALLIQUES "]
[]
[null,"FICHE DE SALAIRE",{"$nulls":4},"mois :"]
[]
[]
[null,"Nom :",null,"Dubois Fernand"]
[null,"Avs no"]
[null,"Nb enfants",null,3]
[null,"Tarif horaire",null,25,"CHF"]
[]
[{"$nulls":4},"Salaire net versé CHF",{"$nulls":4},{"$f":"K43","v":{"v":4740.945,"d":"4,740.95"}}]
[]
[]
[null,null,"Décompte"]
[]
[null,null,"Salaire",null,"Nb d'heures",null,"Tarif en %"]
[null,null,"Heures normales",null,170,"h.",100,"%",null,null,{"$f":"E18*D10*G18/100","v":{"v":4250,"d":"4,250.00"}}]
[null,null,"       supplémentaires",null,10,"h.",120,"%",null,null,{"$f":"E19*D10*G19/100","v":{"v":300,"d":"300.00"}}]
[null,null,"       supplémentaires",null,10,"h.",120,"%",null,null,{"$f":"E20*D10*G20/100","v":{"v":300,"d":"300.00"}}]
[null,null,"Salaire déterminant AVS",{"$nulls":7},{"$f":"SUM(K18:K20)","v":{"v":4850,"d":"4,850.00"}}]
[]
[null,null,"Allocations enfants",null,150,{"$nulls":5},{"$f":"D9*E23","v":{"v":450,"d":"450.00"}}]
[null,null,"       supplémentaire"]
[]
[null,null,"Salaire brut",{"$nulls":7},{"$f":"SUM(K21:K25)","v":{"v":5300,"d":"5,300.00"}}]
[]
[null,null,"Charges sociales",null,"totales",null,"à charge",null,"s/CHF"]
[null,null,"  ./. Caisse de pens.",null,16,"%",8,"%",{"$f":"K21-1881.25","v":{"v":2968.75,"d":"2,968.75"}},{"$f":"I29*G29/100","v":{"v":237.5,"d":"237.50"}}]
[null,null,"  ./. Ass acc non prof",null,0.4,"%",0.2,"%",{"$f":"K21","v":{"v":4850,"d":"4,850.00"}},{"$f":"I30*G30/100","v":{"v":9.7,"d":"9.70"}}]
[null,null,"  ./. AVS/AI/APG",null,12.4,"%",6.05,"%",{"$f":"K21","v":{"v":4850,"d":"4,850.00"}},{"$f":"I31*G31/100","v":{"v":293.425,"d":"293.43"}}]
[null,null,"  ./. Ass chômage",null,0.38,"%",0.38,"%",{"$f":"K21","v":{"v":4850,"d":"4,850.00"}},{"$f":"I32*G32/100","v":18.43},{"$f":"SUM(J29:J32)","v":{"v":559.055,"d":"559.06"}}]
[]
[null,null,"Autres déductions"]
[]
[]
[{"$nulls":10},{"$f":"K26-SUM(K32:K36)","v":{"v":4740.945,"d":"4,740.95"}}]
[]
[null,null,"Frais de déplacements",null,"Nb de km",null,"Tarif"]
[{"$nulls":5},"km",null,"fr.",null,null,{"$f":"E40*G40","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},"km",null,"fr.",null,null,{"$f":"E41*G41","v":{"v":0,"d":"0.00"}}]
[null,null,"Arrondi"]
[null,null,"Montant net",{"$nulls":6},"   Net :",{"$f":"SUM(K37:K42)","v":{"v":4740.945,"d":"4,740.95"}}]
[]
[]
[]
[]
[null,"Lausanne, le"]

{"sheet":"Vide","index":1,"n_rows":48,"n_cols":10,"rows_kept":48,"merged":[[1,4,1,11],[3,8,3,10],[6,3,6,6],[7,3,7,6],[11,4,11,8],[11,9,11,11],[16,4,16,5],[16,6,16,7],[20,2,20,9],[25,2,25,9],[27,4,27,5],[27,6,27,7],[38,4,38,5],[38,6,38,7]]}
[]
[null,"FABRICATION S.A.",null,null,"CONSTUCTIONS METALLIQUES "]
[]
[null,"FICHE DE SALAIRE",{"$nulls":4},"mois :"]
[]
[]
[null,"Nom :"]
[null,"Avs no"]
[null,"Nb enfants"]
[null,"Tarif horaire",null,null,"CHF"]
[]
[{"$nulls":4},"Salaire net versé CHF"]
[]
[]
[null,null,"Décompte"]
[]
[null,null,"Salaire",null,"Nb d'heures",null,"Tarif en %"]
[null,null,"Heures normales",null,null,"h.",100,"%"]
[null,null,"       supplémentaires",null,null,"h.",120,"%"]
[null,null,"       supplémentaires",null,null,"h.",120,"%"]
[null,null,"Salaire déterminant AVS"]
[]
[null,null,"Allocations enfants"]
[null,null,"       supplémentaire"]
[]
[null,null,"Salaire brut"]
[]
[null,null,"Charges sociales",null,"totales",null,"à charge",null,"s/CHF"]
[null,null,"  ./. Caisse de pens.",null,null,"%",null,"%"]
[null,null,"  ./. Ass acc non prof",null,null,"%",null,"%"]
[null,null,"  ./. AVS/AI/APG",null,null,"%",null,"%"]
[null,null,"  ./. Ass chômage",null,null,"%",null,"%"]
[]
[null,null,"Autres déductions"]
[]
[]
[]
[]
[null,null,"Frais de déplacements",null,"Nb de km",null,"Tarif"]
[{"$nulls":5},"km",null,"fr."]
[{"$nulls":5},"km",null,"fr."]
[null,null,"Arrondi"]
[null,null,"Montant net",{"$nulls":6},"   Net :"]
[]
[]
[]
[]
[null,"Lausanne, le"]