{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Menu principal","BASE","Facture","Archives","Extension"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"Menu principal","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BASE","index":1,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
["Code de\nprestation","Type de\nprestation","Montant Annuel","Découvert base"]
[1,"Carte Argent",85,500]
[2,"E Carte",22.5,200]
[3,"Carte Verte",31,150]

{"sheet":"Facture","index":2,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Nom :","MOUSSE","Rue :","DE TRIBORD",null,"Données client à récupérer pour archivage"]
[null,"Prénom","LINE","CP :",10800]
[null,null,null,"Ville :","ST JULIEN LES VILLAS"]
[]
[null,"Statut :","Particulier"]
[]
[]
[]
[]
["Code de prestation :",3,null,"Type de prestation :",{"$f":"IF(OR($C$2=\"\",$B$11=\"\"),\"\",VLOOKUP(B11,prestation,2,0))","v":"Carte Verte"}]
["Nombre de produits:",2]
["Prix global",{"$f":"IF(OR($C$2=\"\",$B$11=\"\"),\"\",VLOOKUP($B$11,prestation,3,0))","v":31}]
["Découvert autorisé :",{"$f":"IF(OR($C$2=\"\",$B$11=\"\"),\"\",VLOOKUP($B$11,prestation,4,0))","v":150}]
[]
["Total  :",{"$f":"B13*B12","v":62}]
["Remise :",{"$f":"INDEX(remise,MATCH(C6,type,0),MATCH(B16,seuil))*B16","v":0}]
["Net  :",{"$f":"IF(B16=\"\",\"\",B16-B17)","v":62}]
[]
["Frais de banque :",{"$f":"IF(B12>0,IF(B11=1,20,IF(B11=2,5,15)),0)","v":15}]
[]
[]
["Net à payer\nTTC",{"$f":"B18+B20","v":77}]

{"sheet":"Archives","index":3,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
["Nom","Prénom","Rue","Code Postal","Ville"]
["MOUSSE","LINE","DE TRIBORD",10800,"ST JULIEN LES VILLAS"]

{"sheet":"Extension","index":4,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"TABLEAU DES REMISES"]
[]
[null,"                CA à partir de\nType Client",0,100,200,300,400]
[null,"Particulier",0,0.02,0.03,0.04,0.05]
[null,"Professionnel",0,2.5000000000000001E-2,3.5000000000000003E-2,4.4999999999999998E-2,5.5E-2]
[null,"Agricole",0,0.03,0.04,0.05,0.06]