{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Entreprise","Clients","Prestations","Elts fact","Compta","Factures","listes","Chiffre affaires"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":10,"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":"Entreprise","index":0,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,10,0]]}
[]
[]
[null,null,null,"Moyens de règlement clients :"]
[null,null,null,"chèque"]
[null,null,null,"virement"]
[null,null,null,"carte bancaire"]
[null,null,null,"espèces"]
[]
[]
[null,null,null,"particulier"]
[null,null,null,"profssionnel"]
["Votre prénom et nom :","PATRON prenom"]
["Votre nom commercial :","Otravaux",null,"Paye"]
["Adresse de votre siège :","14 rue du tilleul",null,"an atante"]
["Code postal :","55990 COMMUNE"]
["Téléphone :","01 01 01 01 01"]
["Numéro Siret :","98845527465954"]

{"sheet":"Clients","index":1,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Numéro client","Type","Nom prénom ou raison sociale","Adresse","C. postal","Ville","Téléphone","E-mail"]
["C1","Particulier","NOM1 Prenom1","1 rue du tilleul",55555,"Commune1","06 06 06 06 06","frtez2@rnle.fr"]
["C2","particulier","NOM2 Prenom2","2 rue du tilleul",55555,"Commune2","06 06 06 06 07","frtez1@rnle.fr"]
["C3","particulier","NOM3 Prenom3","3 rue du tilleul",55555,"Commune3","06 06 06 06 08","frtez@rnle.fr3"]
["C4","particulier","NOM4 Prenom4","4 rue du tilleul",55555,"Commune4","06 06 06 06 09","frtez4@rnle.fr"]
["C5","profssionnel","NOM5 Prenom5","5 rue du tilleul",55555,"Commune5","06 06 06 06 10","frtez5@rnle.fr"]
["C6","particulier","NOM6 Prenom6","6 rue du tilleul",55555,"Commune6","06 06 06 06 11","frtez6@rnle.fr"]
["C7","profssionnel","NOM7 Prenom7","7 rue du tilleul",55555,"Commune7","06 06 06 06 12","frtez7@rnle.fr"]

{"sheet":"Prestations","index":2,"n_rows":36,"n_cols":4,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Type","Prestation","Détail","Prix de base"]
["PLA1","placoplâtre ","pose plaque de plâtre visée ou colėe",100]
["PLA2","placoplâtre ","pose d'une ossature métallique",110]
["PLA3","placoplâtre ","bande a joint 2 passe pres a peindre",120]
["PLA4","placoplâtre ","application d'une peinture primaire mat",130]
["PLA5","placoplâtre ","application peinture satinée 2 couche",140]
["PLA6","placoplâtre ","isolation des murs thermique ou phonique",150]
["PLA7","placoplâtre ","réparation plaques de plâtre ",160]
["PLO1","plomberie","reprise évacuation diam 32 en PVC",170]
["PLO2","plomberie","reprise évacuation diam 40 en PVC",180]
["PLO3","plomberie","reprise ou installation de réseau eau froide per diam 12/14 ou 16",190]
["PLO4","plomberie","reprise ou installation de réseau eau froide multicouche diam 12/14 ou 16",200]
["PLO5","plomberie","reprise ou installation de réseau eau chaude per diam 12/14 ou 16",210]
["PLO6","plomberie","reprise ou installation de réseau eau chaude multicouche diam 12/14 ou 16",220]
["PLO7","plomberie","changement de wc",230]
["PLO8","plomberie","réparation de fuite d'eau ",240]
["EL1","électricite","mise en ligne électrique lumière",250]
["EL2","électricite","mise en place de prise 2p+T",260]
["EL3","électricite","mise en place prise RJ45",270]
["EL4","électricite","mise en ligne électrique inter dif",280]
["CU1","cuisine","pose d'un plan de travail de cuisine",290]
["CU2","cuisine","pose de meubles haut ",300]
["CU3","cuisine","pose de meubles bas",310]
["CU4","cuisine","mise en place d'évier ",320]
["CU5","cuisine","mise en place de plaque de cuisson ",330]
["AN1","prestation_annexe","frais de déplacement",340]
["AN2","prestation_annexe","Démolition et évacuation",350]
["AN3","rénovation_extérieur ","ponce et repeindre porte extérieure en bois ",360]
["AN4","rénovation_extérieur ","ponce et repeindre volets extérieure en bois ",370]
["AN5","rénovation_extérieur ","repeindre portail coulissant en métal ",380]
["SCP1","sols_carrelage_parquets","reparation de joint fisure",390]
["SCP2","sols_carrelage_parquets","remplacement de carreaux",400]
["SCP3","sols_carrelage_parquets","pose d'un sol en carrelage",410]
["SCP4","sols_carrelage_parquets","remise a niveau du sol (ragreage)",420]
["SCP5","sols_carrelage_parquets","pose de faience cuisine ou salla de bain",430]
["SCP6","sols_carrelage_parquets","pose d'un parquet ",440]

{"sheet":"Elts fact","index":3,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Numéro\n facture :","N° client :","Prestation","Montant"]
["FCT2","C2","plomberie"," 65,00"]
["FCT2","C2","électricite"," 56,20"]
["FCT3","C3","électricite"," 231,00"]
["FCT3","C3","plomberie"," 49,30"]
["FCT4","C5","électricite"," 145,00"]
["FCT4","C5","placoplâtre "," 249,00"]
["FCT5","C6","plomberie"," 115,00"]
["FCT6","C5","placoplâtre "," 256,00"]
["FCT6","C5","électricite"," 250,30"]
["FCT6","C5","plomberie"," 155,00"]

{"sheet":"Compta","index":4,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Numéro\n facture :","N° client :","Nom client :","Date facture","Date \néchéance","moyen de règlement","Acompte","remise global","TOTAL HT "]
["FCT2","C2","NOM2 Prenom2","27/10/2022","2022-11-26","CB",null,0,121.2]
["FCT3","C3","NOM3 Prenom3","27/10/2022","2022-11-26","indéterminé",50,0.05,280.3]
["FCT4","C5","NOM5 Prenom5","28/10/2022","2022-10-28","virement",0,0,394]
["FCT5","C6","NOM6 Prenom6","30/10/2022","2022-10-30","virement",100,"0,05",115]
["FCT6","C5","NOM5 Prenom5","30/10/2022","2022-11-29","virement",150,"0,1",661.3]

{"sheet":"Factures","index":5,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,2,46,3],[46,5,46,6],[14,2,14,3],[15,2,15,3],[19,2,19,7],[20,2,20,3],[41,2,43,3],[13,2,13,3],[4,3,6,4],[8,5,8,6],[10,2,10,3],[11,2,11,3],[12,2,12,3]]}
[]
[]
[]
[]
[null,null,null,"FACTURE"]
[null,null,null,null,null,"date","27/10/2022"]
[null,null,null,null,null,"N° facture","FCT3"]
[]
[null,null,null,null,null,"N° client",null,"C3"]
[]
[null,null,"PATRON prenom",null,null,"Nom prénom","NOM3 Prenom3"]
[null,null,"Otravaux",null,null,"Adresse","3 rue du tilleul"]
[null,null,"14 rue du tilleul",null,null,"Code postal",55555,"Commune3"]
[null,null,"55990 COMMUNE",null,null,"Téléphone","06 06 06 06 08"]
[null,null,"Tél. 01 01 01 01 01"]
[null,null,"SIRET 98845527465954"]
[null,null,null,null,null,"Echéance :","26/11/2022"]
[null,null,null,null,null,"Règlement :","indéterminé"]
[]
[null,null,"TRAVAUX A REALISER"]
[null,null,"Prestation",null,"UNITE","PRIX","Quantité","Montant"]
[]
[null,null,null,"électricite",null,null,null," 231,00"]
[null,null,null,"plomberie",null,null,null," 49,30"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Total HT","280,3"]
[null,null,"Merci pour votre confiance",null,null,null,"Remise",14.015000000000001]
[null,null,null,null,null,null,"TOTAL €",266.28500000000003]
[]
[null,null,null,null,null,null,"Acompte versé",50]
[]
[null,null,"Exonéré de TVA, article 293-B du CGI",null,null,"TOTAL A PAYER €",null,216.28500000000003]

{"sheet":"listes","index":6,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Prestation","PMT","Remise","Date échéance","Pages"]
["placoplâtre ","CB",0,"au comptant","page 1"]
["plomberie","virement",0.05,"à livraison","page 2"]
["électricite","chèque",0.1,"à 30 jours","page 3"]
["cuisine","prélèvement",0.15,"à 45 jours","page 4"]
["rénovation_extérieur ","indéterminé",0.2,"à 60 jours","page 5"]
["sols_carrelage_parquets"]

{"sheet":"Chiffre affaires","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}