{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Accueil","facture","Liste Factures","Liste Clients","Intervenants","Relevé"],"not_rendered":{"charts":0,"images":22,"macros":1,"external_links":0,"defined_names":3,"comments":3,"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":"Accueil","index":0,"n_rows":10,"n_cols":28,"rows_kept":10,"cut":false,"hidden":false,"merged":[[11,2,12,4],[22,2,23,4]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Mode emploi"]
[null,null,null,null,null,null,null,null,"Nouveau client"]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Mode d'emploi ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1er client",1]
[null,null,null,null,null,null,null,null,"recherche client ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1ère facture",200901]
[null,null,null,null,null,null,null,null,"par numéro"]
[null,null,null,null,null,null,null,null,"Mode d'emploi "]
[null,null,null,null,null,null,null,null,"recherche par donnée."]

{"sheet":"facture","index":1,"n_rows":48,"n_cols":18,"rows_kept":48,"cut":false,"hidden":false,"merged":[[39,7,39,8],[7,9,7,10],[28,9,28,10],[11,9,12,12],[13,9,13,12],[20,8,20,10],[39,11,39,12],[8,9,9,10],[8,11,9,12],[28,11,28,12],[7,11,7,12],[31,9,31,10],[30,11,30,12],[4,0,4,13],[36,11,36,12],[33,2,33,4],[34,2,34,4],[5,9,5,10],[40,9,40,10],[20,2,20,5],[21,2,21,5],[30,2,30,4],[31,2,31,4],[5,11,5,12],[27,7,29,8],[37,9,37,10],[35,7,35,8],[32,2,32,4],[13,16,13,17],[41,7,41,8],[41,11,41,12],[37,7,37,8],[37,11,37,12],[38,7,38,8],[38,11,38,12],[14,17,15,17],[41,9,41,10],[30,9,30,10],[45,10,47,10],[45,11,47,12],[45,6,45,8],[42,7,42,8],[42,11,42,12],[42,9,42,10],[46,4,47,5],[38,9,38,10],[36,9,36,10],[46,7,46,8],[47,7,47,8],[28,2,28,5],[35,9,35,10],[32,7,32,8],[32,9,32,10],[33,9,33,10],[45,4,45,5],[33,7,33,8],[33,11,33,12],[34,7,34,8],[34,11,34,12],[40,11,40,12],[39,9,39,10],[40,7,40,8],[43,7,43,8],[43,11,43,12],[30,16,30,17],[30,7,30,8],[31,7,31,8],[21,15,21,18],[40,2,40,4],[24,16,25,17],[32,11,32,12],[31,11,31,12],[35,11,35,12],[36,7,36,8],[41,2,41,4],[24,3,24,12],[21,8,21,10],[24,1,24,2],[36,2,36,4],[37,2,37,4],[38,2,38,4],[39,2,39,4],[35,2,35,4],[34,9,34,10]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"FACTURE   N°:",null,200903]
[]
[null,null,null,null,null,null,null,null,null,"DATE",null,"CLIENT"]
[null,null,null,null,null,null,null,null,null,"23/11/2016",null,"M, MD"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"M, MD G",null,null,null,null,null,null,"NB copie(s)"]
[null,null,null,null,null,null,null,null,null,"5 jhv",null,null,null,null,null,null,null,1]
[null,null,null,"03-200903",null,null,null,null,null,"52251 jhg"]
[]
[]
[]
[]
[null,null,"MODE DE REGLEMENT",null,null,null,null,null,"ECHEANCE"]
[null,null,"Chèque",null,null,null,null,null,"30 jours",null,null,null,null,null,null,"Novembre"]
[]
[]
[null,"Intervenant(s) :",null," - H C",null,null,null,null,null,null,null,null,null,null,null,null,"Facture +"]
[]
[]
[null,null,null,null,null,null,"TAUX HORAIRE","Quantité"]
[null,null,"NATURE DE LA PRESTATION ",null,null,null,"ou",null,null,"PRIX (HT)",null,"Prix (TCC)",null,null,null,null,null,200903]
[null,null,null,null,null,null,"FORFAIT"]
[null,null,"suivi avec abonnement",null,null,null,150,2,null,300,null,360,null,null,null,null,"Facture -"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"TVA",null,"Détails",null,null,null,"Total (TCC)",360]
[null,null,null,null,0.2,null,"Total HT",300]
[null,null,null,null,null,null,"Total TVA",60]

{"sheet":"Liste Factures","index":2,"n_rows":8,"n_cols":40,"rows_kept":8,"cut":false,"hidden":false,"merged":[[3,0,3,11]]}
[null,null,null,null,null,null,null,null,null,null,null,20,null,"Mode prestation",null,"suivi","suivi avec abonnement"]
[null,null,null,null,null,null,null,null,null,null,null,"% TVA",null,"Tarif unitaire",null,150,100]
[1,2,3,4,5,6,7,8,9,10,11,12,13,"Échéance",null,"Comptant","15 jours","30 jours","60 jours","90 jours"]
["Accueil                                                                               Acceuil                                            Acceuil",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,15,30,60,90,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41]
["N° Client","N° facture","date de facture","Echeance","% TVA","Total heures","montant Facture HT","Règlement","Facture TCC","Solde","Montant TVA","Acquittée","Général","Data ligne1","lig2","lig 3","lig 4","lig 5","lig 6","lig 7","lig 8","lig 9","lig 10","lig 11","lig 12","lig 13","lig 14","lig 15","lig 16","lig 17","lig 18","lig 19","lig 20","lig 21","lig 22","lig 23","lig 24","lig 25",null,"Acquittée"]
[1,200901,"23/11/2016","2016-12-08",20,2,300,360,360,0,60,"A","15 jours;Chèque;1;0;","0;suivi;2;0;150;1;8,71"]
[2,200902,"23/11/2016","2016-12-23",20,3,300,0,360,360,60,null,"30 jours;Chèque;2;0;","0;suivi;3;1;100;2;8,71"]
[3,200903,"23/11/2016","2016-12-23",20,2,300,360,360,0,60,"A","30 jours;Chèque;2;0;","1;suivi avec abonnement;2;0;150;2;8,71"]

{"sheet":"Liste Clients","index":3,"n_rows":264,"n_cols":32,"rows_kept":264,"cut":false,"hidden":false,"merged":[[3,0,3,13]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mode règlement","Chèque","Virement","Prélèvement","Espèces"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rappel ligne 1","PREMIER RAPPEL"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,null,null,null,null,null,null,null,null,"Rappel ligne 2","2èmè RAPPEL"]
["Accueil                                                                               Acceuil                                            Acceuil",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rappel","RAPPEL","DERNIER RAPPEL"]
["N° du client","Titre","Nom du client","Prénom ","N°","adresse","Bt P","CP","Ville","Téléphone","GSM","Note","Inscription","Solde","N° Fact","date","N° Fact","date","N° Fact","date","N° Fact","date","N° Fact","date",">>>>"]
[1,"M.","Durand","Jean Claude",20,"Rue Th. Pierre",null,31200,"Toulouse",null,null,null,null,null,200901,"23/11/2016",200901,"23/11/2016"]
[2,"Mme","Martin","vanessa",10,"rue st Exupéry",null,85000,"LRSY",null,null,null,null,null,200902,"23/11/2016",200902,"23/11/2016"]
[3,"M,","MD","G",5,"jhv",null,52251,"jhg",null,null,null,null,null,200903,"23/11/2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"2008-10-09"]

{"sheet":"Intervenants","index":4,"n_rows":17,"n_cols":23,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,0,3,19]]}
[]
[]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,null,null,23]
["                                                     Acceuil                                                         Acceuil                                                                                     Acceuil",2,3,4,5,6,7,8,9,10,11,12,13,14]
["N°","Nom","Prénom","Titre","N°","adresse","Bt P","CP","Ville","Téléphone","GSM","date entrée","Date sortie","N° régistre","Date naiss","Qualification","Horaire 1","Horaire 2","Taux Horaire","Note","Réserve","Réserve"]
[1,"Dupont","Julienne","Mme","4","Rue de la coline","","31470","ST LYS","","","17/12/2007","","","","","","","8,71",""]
[2,"H","C","M",null,null,null,null,null,null,null,null,"","","","","","","8,71",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",8.7100000000000009,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",8.7100000000000009,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",8.7100000000000009,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","8,71",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",8.7100000000000009]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",8.7100000000000009,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",8.7100000000000009,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",8.7100000000000009,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",8.7100000000000009,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",8.7100000000000009,""]

{"sheet":"Relevé","index":5,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[7,2,7,3],[7,4,7,5],[9,6,9,12],[5,11,5,12],[6,2,6,3],[9,2,9,3],[9,4,9,5],[5,2,5,4],[5,5,5,6],[7,8,7,9]]}
[]
[]
[]
[]
[]
[null,null,"Relevé du mois de",null,null,"2016-11-15",null,null,null," PIBRAC","le",{"$f":"TODAY()","v":"2016-11-23"}]
[null,null,null,null,null,null," "]
[null,null,"Intervenant :  ",null,null,null,"N°"]
[]
[null,null,"Prestations",null,"Valeur",null,"Client"]
[null,null,"Mois","NB Hrs","Taux","Montant","Nom","Prénom","N°","Adresse","Bt","CP","Localité"]