{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["MODELE_FACTURE","Table_Clients","Table_Missions","Table_Consultant"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":28,"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":"MODELE_FACTURE","index":0,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[[26,0,26,4],[40,0,40,6],[3,8,3,9],[0,0,7,4],[4,8,4,9],[1,7,1,8]]}
["\n"]
[null,null,null,null,null,null,null,"Note d'honoraires numéro :",null,{"$f":"LEFT($H$8,3)","v":"Alp"},{"$f":"NOW()","v":"2013-04-09T16:54:23.610"}]
[]
[null,null,null,null,null,null,null,"DATE","CLIENT",null,"PAGE"]
[null,null,null,null,null,null,null,{"$f":"NOW()","v":"2013-04-09T16:54:23.610"},{"$f":"LEFT($H$8,3)","v":"Alp"},null,{"$f":"Nbpages()","v":1}]
[]
[]
[null,null,null,null,null,"Mission",null,"AlphaX"]
[null,null,null,null,null,null,null,"Direction financiere"]
[null,null,null,null,null,null,null,"Mme Valérie Dupont"]
[null,"Note d'honoraires",null,null,null,null,null,"Rue d'ici"]
[null,null,null,null,null,null,null,"92000 Paris "]
[]
[]
[]
[null,"Objet : ","Analyse de bilan"]
[null,"Intervention  du "]
["CODE",null,"Interv","QUANTITE",null,"P.U.H.T.",null,"MONTANT H.T.",null,null,"TTC","T.V.A."]
[6,null,null,3,"Jours, à un taux journalier de",1000,"pour un montant total HT de",{"$f":"+D19*F19","v":3000},"soit un total TTC de",null,{"$f":"+H19*1.196","v":3588},1]
[6,null,null,12,"Jours, à un taux journalier de",850,"pour un montant total HT de",{"$f":"+D20*F20","v":10200},"soit un total TTC de",null,{"$f":"+H20*1.196","v":12199.199999999999},1]
[6,null,null,null,null,null,null,null,null,null,null,1]
[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,""]
[]
["TVA acquittée sur encaissement"]
[null,null,null,null,null,null,"T.V.A.",null,"BASE",null,"MT T.V.A."]
[null,null,null,null,null,null,19.600000000000001,null,{"$f":"SUM(H19:H21)","v":13200},null,{"$f":"+I28*0.196","v":2587.2000000000003}]
[null,null,null,null,null,null,5.5,null,0,null,0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"EUROS"]
[null,null,null,null,null,null,"TOTAL T.T.C.",null,null,null,{"$f":"+K28+I28","v":15787.2}]
[]
[null,null,null,null,null,null,"FRAIS",null,null,null,132]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"NET A PAYER",null,null,null,{"$f":"SUM(K33:K35)","v":15919.2}]
[]
[null,null,"A 30 jours date de réception de facture"]
[]
[" Tout retard de règlement donnera lieu de plein droit et sans qu’aucune mise en demeure ne soit nécessaire au paiement de pénalités de retard sur la base du taux BCE majoré de dix (10) points et au paiement d’une indemnité forfaitaire pour frais de recouvrement d’un montant de 40€ "]

{"sheet":"Table_Clients","index":1,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Nom_Entreprise","Service_Contact","Genre_Contact","Prénom_Contact","Nom_Contact","Adresse_Contact","CP_Contact","Ville_Contact"]
["AlphaX","Direction financiere","Mme","Valérie","Dupont","Rue d'ici",92000,"Paris"]
["AlphaX","Direction Technique","M.","Jean","Fort","80 avenue Charles de Gaulle",92200,"Neuilly-sur-Seine"]
["Société B","Direction commerciale","Mme","Isabelle","Martin","Rue là bas",75008,"Paris"]
["Société C","Direction comptable","M.","Pierre","Dupont","Rue d'ailleurs",75001,"Paris"]
["Société D","Direction comptable","M.","Jean","VALJEAN","Av des champs",75002,"Paris"]
["Société F"]
["aef"]
["efzef"]
["rt"]
["rg"]
["r(g"]
["(g"]
["(g(z"]
["Société F"]
["eg"]
["et('"]
["t'"]
["\"e"]
["ff"]
["reg"]
["rg"]
["e"]
["g"]

{"sheet":"Table_Missions","index":2,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Nom_Entreprise","Intitulé_Mission","Nom_Consultant","Coût_journalier_Consultant"]
["AlphaX","Implémentation ERP","DUFOUR"]
["AlphaX","Pojet APPOLO","DUPONT"]
["Société B","Choix stratégique","DUPUIS",700]
["Société C","Rédaction des annexes","DUFOUR",400]
["Société C","Analyse de bilan","DUPONT",400]
["Société D","Expertise"]

{"sheet":"Table_Consultant","index":3,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Genre_Consultant","Prénom_Consultant","Nom_Consultant","Grade_Consultant"]
["M.","Michel","DUPUIS","Manager"]
["M. ","Olivier ","DUFOUR","Consultant"]
["M. ","Thibault ","DUPONT","Consultant"]
[]
[]
[{"$f":"\"Intervention de \"  & VLOOKUP(MODELE_FACTURE!C16,Table_Missions!B1:D9,2,FALSE)","v":"Intervention de DUPONT"}]