{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Facture","Exemple"],"not_rendered":{"defined_names":15,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Facture","index":0,"n_rows":66,"n_cols":14,"rows_kept":66,"merged":[[0,0,67,0],[0,1,0,13],[0,14,67,14],[1,1,7,7],[1,8,3,13],[4,8,11,10],[4,11,4,13],[5,11,6,13],[7,11,11,13],[8,1,8,7],[9,1,9,7],[10,1,10,7],[11,1,11,7],[12,1,12,13],[13,1,13,13],[14,1,14,13],[16,1,16,13],[18,1,18,5],[18,6,18,9],[19,1,19,13],[20,1,20,3],[20,4,20,9],[20,10,20,11],[20,12,20,13],[21,1,21,13],[22,1,22,13],[23,1,23,13],[24,1,24,2],[24,3,24,5],[24,6,24,9],[24,10,24,11],[25,1,25,2],[25,3,25,5],[25,6,25,9],[25,10,25,11],[26,1,26,2],[26,3,26,5],[26,6,26,9],[26,10,26,11],[27,1,27,2],[27,3,27,5],[27,6,27,9],[27,10,27,11],[28,1,28,2],[28,3,28,5],[28,6,28,9],[28,10,28,11],[29,1,29,2],[29,3,29,5],[29,6,29,9],[29,10,29,11],[30,1,30,2],[30,3,30,5],[30,6,30,9],[30,10,30,11],[31,1,31,2],[31,3,31,5],[31,6,31,9],[31,10,31,11],[32,1,32,2],[32,3,32,5],[32,6,32,9],[32,10,32,11],[33,1,33,2],[33,3,33,5],[33,6,33,9],[33,10,33,11],[34,1,34,2],[34,3,34,5],[34,6,34,9],[34,10,34,11],[35,1,35,2],[35,3,35,5],[35,6,35,9],[35,10,35,11],[36,1,36,2],[36,3,36,5],[36,6,36,9],[36,10,36,11],[37,1,37,2],[37,3,37,5],[37,6,37,9],[37,10,37,11],[38,1,38,2],[38,3,38,5],[38,6,38,9],[38,10,38,11],[39,1,39,2],[39,3,39,5],[39,6,39,9],[39,10,39,11],[40,1,40,2],[40,3,40,5],[40,6,40,9],[40,10,40,11],[41,1,41,2],[41,3,41,5],[41,6,41,9],[41,10,41,11],[42,1,42,12],[43,1,43,12],[44,1,44,13],[45,1,45,5],[45,6,45,8],[45,9,45,13],[46,1,49,5],[46,6,46,8],[46,9,46,13],[47,6,47,8],[47,9,47,13],[48,6,48,8],[48,9,48,13],[49,6,49,13],[50,1,50,5],[50,6,50,8],[50,9,50,13],[51,1,51,5],[51,6,51,13],[52,1,52,13],[53,1,53,13],[54,1,54,13],[55,1,55,13],[56,1,56,13],[57,2,57,13],[58,1,58,13],[59,1,59,13],[60,1,60,13],[61,1,61,13],[62,1,62,2],[62,3,62,7],[62,8,62,9],[62,10,62,13],[63,1,63,13],[64,2,64,13],[65,1,65,2],[65,3,65,13],[66,1,66,13],[67,1,67,13]]}
[]
[null,"Nom et adresse de la famille d'accueil :\n"]
[]
[]
[{"$nulls":11},"     ▼     Facture à adresser à la : "]
[]
[]
[{"$nulls":11},"Direction générale \nde l’enfance \net de la jeunesse\nUnité Finances\nAvenue de Longemalle 1\n1020 Renens"]
[]
[]
[]
[]
[]
[]
[null,"FACTURE"]
[]
[null,"Bénéficiaire des prestations (mineur) :"]
[]
[null,"N° dossier DGEJ (si connu) :"]
[]
[null,"Nom, prénom :",{"$nulls":8},"     Né(e) le :"]
[null,"     "]
[]
[]
[null,"Du",null,"Au",null,null,"Prestations *",{"$nulls":3},"Nombre",null,"Prix unitaire","Total"]
[{"$nulls":13},{"$f":"IF(G26=\"\",\"\",SUM(K26*M26))","v":""}]
[{"$nulls":13},{"$f":"IF(G27=\"\",\"\",SUM(K27*M27))","v":""}]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[null,"Total :",{"$nulls":11},{"$f":"IF(N26=\"\",\"\",SUM(N26:N42))","v":""}]
[]
[]
[null,"* Prestations forfaitaires :",{"$nulls":4},"Accueil Relais :",null,null,"fr. 35.00 par jour"]
[{"$nulls":6},"Accueil d'urgence / préadoption :",null,null,"fr. 60.00 par jour"]
[{"$nulls":6},"Transport par la famille d'accueil :",null,null,"fr. 00.70 le km"]
[{"$nulls":6},"Piquet en famille d'accueil",null,null,"fr. 30.00 par jour"]
[]
[null,"   Autres prestations :",{"$nulls":4},"Vacances avec la famille d'accueil :",null,null,"fr. 400.00 par événement (max. 2x / an)"]
[{"$nulls":6},"Autres : cf. \"Barèmes des aides financières relevant de l’intervention socio-éducative de la DGEJ\"."]
[]
[null,"Montant à verser sur le compte bancaire ou postal suivant (indiquer le n° d'IBAN) :"]
[]
[]
[]
[null,"N.B. ","Merci d'établir une facture mensuelle. La dernière facture en rapport avec les prestations de l'année en cours doit être envoyée au plus tard le 10 janvier de l'année suivante. Seules les prestations prévues par la convention, ou celles ayant fait l'objet d'une décision d'engagement financier peuvent être facturées."]
[]
[]
[null,"Signature :"]
[]
[null,"Date : ",{"$nulls":6},"Signature :         "]
[]
[]
[null,"Annexe(s) :"]

{"sheet":"Exemple","index":1,"n_rows":65,"n_cols":16,"rows_kept":65,"merged":[[0,0,67,0],[0,1,0,13],[0,14,67,14],[1,1,7,7],[1,8,3,13],[4,8,12,10],[5,11,6,13],[7,11,11,13],[8,1,8,7],[9,1,9,7],[10,1,10,7],[11,1,11,7],[12,1,12,4],[12,5,12,7],[12,11,12,13],[13,1,13,13],[14,1,14,13],[15,1,15,13],[16,1,16,13],[17,1,17,13],[18,1,18,13],[19,1,19,3],[19,4,19,9],[19,10,19,11],[19,12,19,13],[20,1,20,13],[21,1,21,13],[22,1,22,13],[23,1,23,2],[23,3,23,5],[23,6,23,9],[23,10,23,11],[24,1,24,2],[24,3,24,5],[24,6,24,9],[24,10,24,11],[25,1,25,2],[25,3,25,5],[25,6,25,9],[25,10,25,11],[26,1,26,2],[26,3,26,5],[26,6,26,9],[26,10,26,11],[27,1,27,2],[27,3,27,5],[27,6,27,9],[27,10,27,11],[28,1,28,2],[28,3,28,5],[28,6,28,9],[28,10,28,11],[29,1,29,2],[29,3,29,5],[29,6,29,9],[29,10,29,11],[30,1,30,2],[30,3,30,5],[30,6,30,9],[30,10,30,11],[31,1,31,2],[31,3,31,5],[31,6,31,9],[31,10,31,11],[32,1,32,2],[32,3,32,5],[32,6,32,9],[32,10,32,11],[33,1,33,2],[33,3,33,5],[33,6,33,9],[33,10,33,11],[34,1,34,2],[34,3,34,5],[34,6,34,9],[34,10,34,11],[35,1,35,2],[35,3,35,5],[35,6,35,9],[35,10,35,11],[36,1,36,2],[36,3,36,5],[36,6,36,9],[36,10,36,11],[37,1,37,2],[37,3,37,5],[37,6,37,9],[37,10,37,11],[38,1,38,2],[38,3,38,5],[38,6,38,9],[38,10,38,11],[39,1,39,2],[39,3,39,5],[39,6,39,9],[39,10,39,11],[40,1,40,2],[40,3,40,5],[40,6,40,9],[40,10,40,11],[41,1,41,12],[42,1,42,12],[43,1,43,13],[44,1,44,5],[44,6,44,8],[44,9,44,13],[45,1,47,5],[45,6,45,8],[45,9,45,13],[46,6,46,8],[46,9,46,13],[47,6,47,13],[48,1,48,5],[48,6,48,8],[48,9,48,13],[48,15,53,16],[49,1,49,5],[49,6,49,13],[50,1,50,13],[51,1,51,13],[52,1,52,13],[53,1,53,13],[54,1,54,13],[54,15,55,16],[55,1,55,13],[56,2,56,13],[57,1,57,13],[58,1,58,13],[59,1,59,13],[60,1,60,13],[61,1,61,2],[61,3,61,7],[61,8,61,9],[61,10,61,13],[62,1,62,13],[63,2,63,13],[64,1,64,2],[64,3,64,13],[65,1,65,13],[66,1,66,13],[67,1,67,13]]}
[]
[]
[]
[]
[{"$nulls":11},"     ▼     Facture à adresser au : "]
[]
[]
[{"$nulls":11},"Service de protection\nde la jeunesse\nUnité logistique et finances\nBAP\n1014 Lausanne"]
[]
[null,"     ▲     Nom et adresse de la famille d'accueil :"]
[]
[]
[null,"N° dossier SPJ (si connu) :"]
[]
[]
[null,"FACTURE"]
[]
[null,"Bénéficiaire des prestations :"]
[]
[null,"Nom, prénom :",{"$nulls":8},"     Né(e) le :"]
[null,"     "]
[]
[]
[null,"Du",null,"Au",null,null,"Prestations *",{"$nulls":3},"Nombre",null,"Prix unitaire","Total"]
[null,"2010-01-01",null,"2010-01-31",null,null,"Transport (visite médicale)",{"$nulls":3},{"v":60.7,"d":"60.70"},null,{"v":0.7,"d":"0.70"},{"$f":"IF(G25=\"\",\"\",SUM(K25*M25))","v":42.49}]
[null,"2010-01-02",null,"2010-01-03",null,null,"Accueil Relais",{"$nulls":3},{"v":2,"d":"2.00"},null,{"v":35,"d":"35.00"},{"v":70,"d":"70.00"}]
[null,"2010-01-16",null,"2010-01-17",null,null,"Accueil Relais",{"$nulls":3},{"v":2,"d":"2.00"},null,{"v":35,"d":"35.00"},{"v":70,"d":"70.00"}]
[null,"2010-01-25",null,"2010-01-31",null,null,"Vacances (frais supplémentaires)",{"$nulls":3},{"v":1,"d":"1.00"},null,{"v":400,"d":"400.00"},{"v":400,"d":"400.00"}]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[{"$nulls":13},""]
[null,"Total :",{"$nulls":11},{"$f":"IF(N25=\"\",\"\",SUM(N25:N41))","v":582.49}]
[null,"Arrondi (aux 50 ct supérieurs) :",{"$nulls":11},{"$f":"IF(N42=\"\",\"\",CEILING(N42,0.5))","v":{"v":582.5,"d":"582.50"}}]
[]
[null,"* Prestations forfaitaires :",{"$nulls":4},"Accueil Relais :",null,null,"fr. 35.00 par jour"]
[{"$nulls":6},"Accueil d'urgence :",null,null,"fr. 60.00 par jour"]
[{"$nulls":6},"Transport par la famille d'accueil :",null,null,"fr. 00.70 le km"]
[]
[null,"   Autres prestations :",{"$nulls":4},"Vacances avec la famille d'accueil :",null,null,"fr. 400.00 par événement (max. 2x / an)",{"$nulls":5},"N.B. : Si vous ne connaissez pas votre IBAN, vous pouvez le calculer automatiquement sur : "]
[{"$nulls":6},"Autres : cf. \"Directives d'octroi et barèmes des aides financières\" du SPJ."]
[]
[null,"Montant à verser sur le compte bancaire ou postal suivant :"]
[null,"(Pour les comptes bancaires, indiquer le n° d'IBAN (références bancaires))."]
[]
[{"$nulls":15},"http://www.bcv.ch/fr/simulateurs/calculez_votre_iban"]
[]
[null,"N.B. ","Merci d'établir une facture mensuelle. La dernière facture en rapport avec les prestations de l'année en cours doit être envoyée au plus tard le 10 janvier de l'année suivante. Seules les prestations prévues par la convention, ou celles ayant fait l'objet d'une décision d'engagement financier peuvent être facturées."]
[]
[]
[null,"Signature :"]
[]
[null,"Date : ",{"$nulls":6},"Signature :         "]
[]
[]
[null,"Annexe(s) :"]