{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Données","Facture","Renseignement","Feuil2"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":3,"comments":1,"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":"Données","index":0,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["LIBELLE","Code "]
["Animation pour école",100]
["Animation  Marché au foies gras",101]
["Animation anniversaire",102]
["Animation chant",103]
["Animation Culturelle",104]
["Animation de rue ",105]
["Animation Hopital",106]
["Animation Maison de Retraite",107]
["Chant avec orgue de Barbarie",108]
["Location costumes",109]
[]
[]
[]
[]
["Frais de déplacement voiture",200]
["Frais de déplacement train",201]
["Frais de déplacement avion",202]
["Frais de déplacement vélo",203]
["Frais de déplacement à pied",204]

{"sheet":"Facture","index":1,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,0,34,3]]}
["VALENTIN Orgue de Barbarie",null,"Facture n°:","0001"]
["France\nvalentinrossano@gmail.com\nTél.: 06 09 06 72 21\nSite internet : http://www.rossanoclown.fr"]
[]
["Facturer à :","Infos Clients supplémentaires :"]
["Maison de Retraite ","elodie.pautounier@orange.fr"]
["Ehpad Le neubourg","Tél. : 06 54 65 68 98"]
["27110 Le Neubourg"]
["France"]
["Date d'émission de la facture  le:"]
[]
["Prestation","Prix","Quantité","Total"]
["Animation  Marché au foies gras",300,1,{"$f":"B12*C12","v":300}]
[]
[]
[]
["Frais de déplacement voiture",50,1,{"$f":"B16*C16","v":50}]
[null,"Sous Total",null,{"$f":"SUM(D12:D16)","v":350}]
[null,"Taxe (0%)",null,0]
[null,"Total Facture",null,{"$f":"D17","v":350}]
[null,"Montant à Payer",null,{"$f":"D19","v":350}]
["Date du spectacle             :"]
["Conditions de règlement :","Règlement au paiement comptant à la réception de la facture"]
[]
["Siret n° 000000000000000","Entreprise non assujétie à la TVA"]
["Informations bancaires :","Gilles DONNEADIEU"]
["IBAN :\nFR76 2020 8008 6900 0254 5422 660 ","BIC :\nCRCAFRPPXXX"]
[]
["Informations personnelles ne figurant pas sur la facture"]
["Nom de l'Archive :",{"$f":"IF(B9=\"\",\"\",CONCATENATE(YEAR(B9),\"-\",IF(MONTH(B9)<10,CONCATENATE(\"0\",MONTH(B9)),MONTH(B9)),\"-\",IF(DAY(B9)<10,CONCATENATE(\"0\",DAY(B9)),DAY(B9)),\"_\",D1,\".pdf\"))","v":""}]
["Créationj Archive :",{"$f":"CONCATENATE(\"Le : \",TEXT(TODAY(),\"jjjj jj mmmm aaaa\"))","v":"Le : vendredi 19 août 2022"}]
["Montant à déclarer à l'ursaff:",null,null,{"$f":"D20-D16","v":300}]
[]
[]
[]
["Fermer le fichier pdf après l'impression. Puis ne pas oublier d'enregistrer le fichier excel dans le dossier facture excel afin d'incrémenter les factures "]

{"sheet":"Renseignement","index":2,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["mot de passe feuille de calcul","rossano"]

{"sheet":"Feuil2","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}