{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Tableau Bord","FACTURE","Suivi_Factures","Histo","Catalogue","Clients","Preparation","Param","A propos"],"not_rendered":{"charts":1,"images":4,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":1},"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":"Tableau Bord","index":0,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Statut","Montant TTC ",null,{"$f":"CHOOSE(1,Preparation!F1:G11)","v":"Nom client"},"Montant TTC"]
[null,"A Régler",2369.4000000000005,null,"Bernard et Cie",1153.5999999999999]
[null,"Payée",2727.6000000000004,null,"Dubois Informatique",638.79999999999995]
[null,"Total général",5097.0000000000009,null,"Dupont SARL",571.19999999999993]
[null,null,null,null,"Martin & Fils",538]
[null,null,null,null,"Petit Distribution",431.4]
[null,null,null,null,"Morin Transport",400]
[null,null,null,null,"Lefèvre Industries",381]
[null,null,null,null,"Rousseau Constructions",368]
[null,null,null,null,"Société Giraud",330]
[null,null,null,null,"Pelletier et Associés",305.39999999999998]

{"sheet":"FACTURE","index":1,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[54,4,55,4],[11,4,12,4]]}
[]
[]
[]
[null,null,null,null,"Facture n°",null,{"$f":"Param!E2","v":"F2024003"}]
[null,null,null,null,null,null,"Date :","2024-12-21"]
[]
[null,null,"",null,null,null,null,null,null,null,null,0]
[null,null,"Client ID","C007","A :",{"$f":"\" \"&VLOOKUP($D$8,Clients!$A:$B,2,FALSE)","v":" Dubois Informatique"},null,null,null,null,null,5.5E-2]
[null,null,"Ma PME SA",null,"Adresse :",{"$f":"VLOOKUP($D$8,Clients!$A:$E,5,FALSE)","v":"9 Rue de la Technologie"},null,null,null,null,null,0.1]
[null,null,"   18 Allées de mon adresse",null,null,{"$f":"VLOOKUP($D$8,Clients!$A:$F,6,FALSE)","v":37000},{"$f":"VLOOKUP($D$8,Clients!$A:$G,7,FALSE)","v":"Tours"},null,null,null,null,0.2]
[null,null,31000,"TOULOUSE",null,"Téléphone : ",{"$f":"VLOOKUP($D$8,Clients!$A:$G,3,FALSE)","v":0}]
[null,null,"Téléphone : ","06 81 xx xx xx","Adresse de livraison :",""]
[null,null,"Siret : ","34114 XXXXXXXX",null,""]
[null,null,"N° TVA intracommunautaire : ","TVA XXXXXX"]
[]
[]
[]
[null,null,"Référence","Description","PU HT €","Quantité","Montant HT","Taux TVA",null,null,"taux tva","montant tva"]
[]
[5,null,"TOU003",{"$f":"IFERROR(VLOOKUP(C20,Catalogue!A:B,2,FALSE),\"\")","v":"Magnet réfrigérateur \"Vieux Toulouse\""},{"$f":"IFERROR(VLOOKUP(C20,Catalogue!A:C,3,FALSE),\"\")","v":5},1,{"$f":"IF(ISERROR(E20*F20),\"\",E20*F20)","v":5},0.2,null,null,{"$f":"H20","v":0.2},{"$f":"IF(ISERROR(G20*H20),0,G20*H20)","v":1}]
[null,null,"TOU004",{"$f":"IFERROR(VLOOKUP(C21,Catalogue!A:B,2,FALSE),\"\")","v":"Porte-clés \"Basilique Saint-Sernin\""},{"$f":"IFERROR(VLOOKUP(C21,Catalogue!A:C,3,FALSE),\"\")","v":6},2,{"$f":"IF(ISERROR(E21*F21),\"\",E21*F21)","v":12},0.2,null,null,{"$f":"H21","v":0.2},{"$f":"IF(ISERROR(G21*H21),0,G21*H21)","v":2.4000000000000004}]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C22,Catalogue!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C22,Catalogue!A:C,3,FALSE),\"\")","v":""},null,"",null,null,null,0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C23,Catalogue!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C23,Catalogue!A:C,3,FALSE),\"\")","v":""},null,"",null,null,null,0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C24,Catalogue!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C24,Catalogue!A:C,3,FALSE),\"\")","v":""},"","","",null,null,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C25,Catalogue!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C25,Catalogue!A:C,3,FALSE),\"\")","v":""},"","","",null,null,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C26,Catalogue!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C26,Catalogue!A:C,3,FALSE),\"\")","v":""},"","","",null,null,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C27,Catalogue!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C27,Catalogue!A:C,3,FALSE),\"\")","v":""},"","","",null,null,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C28,Catalogue!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C28,Catalogue!A:C,3,FALSE),\"\")","v":""},"","","",null,null,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C29,Catalogue!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C29,Catalogue!A:C,3,FALSE),\"\")","v":""},"","","",null,null,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C30,Catalogue!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C30,Catalogue!A:C,3,FALSE),\"\")","v":""},"","","",null,null,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C31,Catalogue!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C31,Catalogue!A:C,3,FALSE),\"\")","v":""},"","","",null,null,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C32,Catalogue!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C32,Catalogue!A:C,3,FALSE),\"\")","v":""},"","","",null,null,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C33,Catalogue!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C33,Catalogue!A:C,3,FALSE),\"\")","v":""},"","","",null,null,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C34,Catalogue!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C34,Catalogue!A:C,3,FALSE),\"\")","v":""},"","","",null,null,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C35,Catalogue!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C35,Catalogue!A:C,3,FALSE),\"\")","v":""},"","","",null,null,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C36,Catalogue!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C36,Catalogue!A:C,3,FALSE),\"\")","v":""},"","","",null,null,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C37,Catalogue!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C37,Catalogue!A:C,3,FALSE),\"\")","v":""},"","","",null,null,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C38,Catalogue!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C38,Catalogue!A:C,3,FALSE),\"\")","v":""},"","","",null,null,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C39,Catalogue!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C39,Catalogue!A:C,3,FALSE),\"\")","v":""},"","","",null,null,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C40,Catalogue!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C40,Catalogue!A:C,3,FALSE),\"\")","v":""},"","","",null,null,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C41,Catalogue!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C41,Catalogue!A:C,3,FALSE),\"\")","v":""},"","","",null,null,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C42,Catalogue!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C42,Catalogue!A:C,3,FALSE),\"\")","v":""},"","","",null,null,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C43,Catalogue!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C43,Catalogue!A:C,3,FALSE),\"\")","v":""},"","","",null,null,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C44,Catalogue!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C44,Catalogue!A:C,3,FALSE),\"\")","v":""},"","","",null,null,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C45,Catalogue!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C45,Catalogue!A:C,3,FALSE),\"\")","v":""},"","","",null,null,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C46,Catalogue!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C46,Catalogue!A:C,3,FALSE),\"\")","v":""},"","","",null,null,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C47,Catalogue!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C47,Catalogue!A:C,3,FALSE),\"\")","v":""},"","","",null,null,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C48,Catalogue!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C48,Catalogue!A:C,3,FALSE),\"\")","v":""},"","","",null,null,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C49,Catalogue!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C49,Catalogue!A:C,3,FALSE),\"\")","v":""},"","","",null,null,"",0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C50,Catalogue!A:B,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C50,Catalogue!A:C,3,FALSE),\"\")","v":""},"","","",null,null,"",0]
[null,null,"","","","","","",null,null,"",0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L20:L51)","v":3.4000000000000004}]
[null,null,"Échéance :","paiement à 30 jours",null,"€ HT",{"$f":"SUM(G20:G51)","v":17}]
[null,null,"Règlement :","virement",null,"",""]
[null,null,null,null,"TOTAL €","HT",{"$f":"G53","v":17}]
[null,null,"En cas de retard de paiement, des pénalités de retard seront appliquées",null,null,"TTC",{"$f":"G55+L52","v":20.399999999999999}]
[null,null," au taux de 10% par an, conformément à l'article L.441-10 du Code de commerce."]
[null,null,null,null,null,"TVA à 5,5% :",{"$f":"SUMIFS((G20:$G$51),$H$20:$H$51,0.055)*0.055","v":0}]
[null,null,null,null,null,"TVA à 10% :",{"$f":"SUMIFS((G20:$G$51),$H$20:$H$51,0.1)*0.1","v":0}]
[null,null,null,null,null,"TVA à 20% :",{"$f":"SUMIFS((G20:$G$51),$H$20:$H$51,0.2)*0.2","v":3.4000000000000004}]
[null,null,null,null,null,"Total TVA :",{"$f":"SUM(G58:G60)","v":3.4000000000000004}]

{"sheet":"Suivi_Factures","index":2,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["ID Fature","ID Client","Date facture","Montant TTC","Statut paiement","Date paiement","Montant paiement","Type paiement","Mois Année","Total",{"$f":"SUM(D:D)","v":5117.3999999999987},{"$f":"\"CA Annuel brut \"&K1&\"€\"","v":"CA Annuel brut 5117,4€"}]
["F2024017","C002","2024-07-17",50,"A Régler",null,null,null,{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"7 2024"},"Clients",{"$f":"COUNTA(Clients!A:A)-1","v":10},{"$f":"\"Clients : \"&K2","v":"Clients : 10"}]
["F2024018","C004","2024-07-22",110,"A Régler",null,null,null,{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"7 2024"},"Min date",{"$f":"MIN(tab_suivi[Date facture])","v":"2024-07-17"}]
["F2024020","C009","2024-08-01",110,"Payée","2024-08-22",110,"Virement",{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"8 2024"},"Max date",{"$f":"MAX(C:C)","v":"2025-03-20"}]
["F2024021","C009","2024-08-07",110,"Payée",null,null,null,{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"8 2024"},"Nombre mois",{"$f":"DATEDIF(K3,K4,\"m\")","v":8}]
["F2024023","C002","2024-08-17",238,"A Régler",null,null,null,{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"8 2024"},"CA moyen mensuel",{"$f":"ROUND(K1/K5,0)","v":640},{"$f":"\"CA Mensuel Moyen: \"&K6&\"€\"","v":"CA Mensuel Moyen: 640€"}]
["F2024024","C005","2024-08-20",75,"Payée","2024-08-30",75,"Chèque",{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"8 2024"}]
["F2024025","C007","2024-09-05",120,"Payée","2024-09-10",120,"Virement",{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"9 2024"}]
["F2024026","C003","2024-09-15",95,"A Régler",null,null,null,{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"9 2024"}]
["F2024027","C010","2024-10-01",135,"Payée","2024-10-15",135,"Virement",{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"10 2024"}]
["F2024028","C006","2024-10-20",85,"A Régler",null,null,null,{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"10 2024"}]
["F2024029","C008","2024-11-15",110,"A Régler",null,null,null,{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"11 2024"}]
["F2024030","C001","2024-12-01",100,"Payée","2024-12-10",100,"Chèque",{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"12 2024"}]
["F2024031","C003","2024-12-10",200,"A Régler",null,null,null,{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"12 2024"}]
["F2024032","C004","2024-12-15",220,"Payée","2024-12-20",220,"Virement",{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"12 2024"}]
["F2024033","C007","2025-01-01",240,"A Régler",null,null,null,{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"1 2025"}]
["F2024034","C009","2025-01-10",300,"Payée","2025-01-20",300,"Virement",{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"1 2025"}]
["F2024035","C002","2025-01-20",250,"Payée","2025-01-30",250,"Chèque",{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"1 2025"}]
["F2024036","C005","2025-02-01",210,"A Régler",null,null,null,{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"2 2025"}]
["F2024037","C006","2025-02-15",280,"Payée","2025-02-25",280,"Virement",{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"2 2025"}]
["F2024038","C010","2025-03-01",260,"A Régler",null,null,null,{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"3 2025"}]
["F2024039","C008","2025-03-10",290,"Payée","2025-03-20",290,"Chèque",{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"3 2025"}]
["F2024040","C001","2025-03-20",320,"Payée","2025-03-30",320,"Virement",{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"3 2025"}]
["F2024041","C007","2024-08-17",238,"A Régler",null,null,null,{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"8 2024"}]
["F2024042","C010","2024-08-17",36.4,"A Régler",null,null,null,{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"8 2024"}]
["F2024043","C009","2024-08-17",316.8,"A Régler",null,null,null,{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"8 2024"}]
["F2024044","C009","2024-08-12",316.8,"Payée",null,null,null,{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"8 2024"}]
["F2024045","C003","2024-08-17",2,"A Régler",null,null,null,{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"8 2024"}]
["F2024046","C003","2024-08-17",42,"Payée",null,null,null,{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"8 2024"}]
["F2024047","C003","2024-08-19",42,"A Régler",null,null,null,{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"8 2024"}]
["F2024048","C006","2024-08-17",2,"A Régler",null,null,null,{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"8 2024"}]
["F2024049","C006","2024-08-17",1,"A Régler",null,null,null,{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"8 2024"}]
["F2024050","C001","2024-08-17",112.8,"A Régler",null,null,null,{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"8 2024"}]
["F2024051","C001","2024-08-21",38.4,"Payée",null,null,null,{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"8 2024"}]
["F2024052","C005","2024-08-21",20.399999999999999,"Payée","2024-08-28",20.399999999999999,"Virement",{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"8 2024"}]
["F2024002","C007","2024-08-21",20.399999999999999,"A Régler",null,null,null,{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"8 2024"}]
["F2024003","C007","2024-08-21",20.399999999999999,"A Régler",null,null,null,{"$f":"MONTH(tab_suivi[[#This Row],[Date facture]])&\" \"&YEAR(tab_suivi[[#This Row],[Date facture]])","v":"8 2024"}]

{"sheet":"Histo","index":3,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["ID Fature","ID Client","Date facture","Montant TTC","Condition de paiement","Fichier PDF"]
["F2024012","C004","2024-08-17",21762.799999999999,"paiement à 30 jours"]
["F2024013","C009","2024-08-17",21762.799999999999,"paiement à 30 jours"]
["F2024014","C009","2024-08-17",110,"paiement à 30 jours"]
["F2024021","C009","2024-08-17",128,"paiement à 30 jours"]
["F2024022","C002","2024-08-17",238,"paiement à 30 jours"]
["F2024023","C002","2024-08-17",238,"Paiement à 30 jours"]
["F2024024","C005","2024-08-20",150,"Paiement à 30 jours"]
["F2024025","C007","2024-09-05",240,"Paiement à 30 jours"]
["F2024026","C003","2024-09-15",190,"Paiement à 30 jours"]
["F2024027","C010","2024-10-01",270,"Paiement à 30 jours"]
["F2024028","C006","2024-10-20",170,"Paiement à 30 jours"]
["F2024029","C008","2024-11-15",220,"Paiement à 30 jours"]
["F2024030","C001","2024-12-01",200,"Paiement à 30 jours"]
["F2024031","C003","2024-12-10",200,"Paiement à 30 jours"]
["F2024032","C004","2024-12-15",220,"Paiement à 30 jours"]
["F2024033","C007","2025-01-01",280,"Paiement à 30 jours"]
["F2024034","C009","2025-01-10",320,"Paiement à 30 jours"]
["F2024035","C002","2025-01-20",270,"Paiement à 30 jours"]
["F2024036","C005","2025-02-01",210,"Paiement à 30 jours"]
["F2024037","C006","2025-02-15",280,"Paiement à 30 jours"]
["F2024038","C010","2025-03-01",260,"Paiement à 30 jours"]
["F2024039","C008","2025-03-10",290,"Paiement à 30 jours"]
["F2024040","C001","2025-03-20",320,"Paiement à 30 jours"]
["F2024040","C007","2024-08-17",238,"paiement à 30 jours"]
["F2024041","C010","2024-08-17",36.4,"paiement à 30 jours"]
["F2024042","C009","2024-08-17",316.8,"paiement à 30 jours"]
["F2024043","C009","2024-08-17",316.8,"paiement à 30 jours"]
["F2024044","C003","2024-08-17",42,"paiement à 30 jours"]
["F2024045","C003","2024-08-17",42,"paiement à 30 jours"]
["F2024046","C003","2024-08-17",42,"paiement à 30 jours"]
["F2024047","C006","2024-08-17",147.6,"paiement à 30 jours"]
["F2024048","C006","2024-08-17",147.6,"paiement à 30 jours"]
["F2024049","C001","2024-08-17",112.8,"paiement à 30 jours","\\F2024049_Facture_20240818.pdf"]
["F2024050","C001","2024-08-21",38.4,"paiement à 30 jours","\\F2024050_Facture_20240818.pdf"]
["F2024051","C005","2024-08-21",20.399999999999999,"paiement à 30 jours","\\F2024051_Facture_20240818.pdf"]
["F2024001","C007","2024-08-21",20.399999999999999,"paiement à 30 jours","\\F2024001_Facture_20240818.pdf"]
["F2024002","C007","2024-08-21",20.399999999999999,"paiement à 30 jours","\\F2024002_Facture_20240822.pdf"]

{"sheet":"Catalogue","index":4,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Référence","Produit","Prix HT (EUR)","Taux de TVA","Prix TTC (EUR)"]
["TOU001","Miniature de la Place du Capitole",10,0.2,12]
["TOU002","Tasse souvenir \"Toulouse\"",8,0.2,9.6]
["TOU003","Magnet réfrigérateur \"Vieux Toulouse\"",5,0.2,6]
["TOU004","Porte-clés \"Basilique Saint-Sernin\"",6,0.2,7.2]
["TOU005","Cartes postales anciennes de Toulouse",4,0.2,4.8]
["TOU006","Casquette brodée \"Toulouse\"",12,0.2,14.4]
["TOU007","Écharpe en laine avec motifs de Toulouse",20,0.2,24]
["TOU008","Assiette décorative \"Toulouse\"",15,0.2,18]
["TOU009","Bougie parfumée \"Toulouse\"",11,0.2,13.2]
["TOU010","Poster illustré \"Canal du Midi\"",9,0.2,10.8]
["TOU011","Livre sur l'histoire de Toulouse",18,0.2,21.6]
["TOU012","Bracelet en cuir \"Toulouse\"",14,0.2,16.8]
["TOU013","Verre à bière gravé \"Toulouse\"",13,0.2,15.6]
["TOU014","Tablier de cuisine avec logo \"Toulouse\"",17,0.2,20.399999999999999]
["TOU015","Sac en toile \"Toulouse\"",22,0.2,26.4]
["TOU016","Magnet \"Pont Neuf\"",7,0.2,8.4]
["TOU017","Réplica en résine de la Tour des Archives",25,0.2,30]
["TOU018","Boucles d'oreilles en forme de violette",12,0.2,14.4]
["TOU019","Couteau de poche \"Toulouse\"",18,0.2,21.6]
["TOU020","Coque de téléphone \"Toulouse\"",16,0.2,19.2]
["TOU021","Panneau en bois \"Bienvenue à Toulouse\"",20,0.2,24]
["TOU022","Mappemonde vintage \"Toulouse\"",30,0.2,36]
["TOU023","T-shirt imprimé \"Toulouse\"",15,0.2,18]
["TOU024","Dessous de verre \"Vieux Toulouse\"",9,0.2,10.8]
["TOU025","Porte-cartes en cuir \"Toulouse\"",14,0.2,16.8]
["TOU026","Chapeau de paille \"Toulouse\"",22,0.2,26.4]
["TOU027","Luminaires décoratifs \"Toulouse\"",35,0.2,42]
["TOU028","Cendrier en verre \"Toulouse\"",11,0.2,13.2]
["TOU029","Parapluie avec motifs de Toulouse",18,0.2,21.6]
["TOU030","Set de cartes \"Toulouse\"",8,0.2,9.6]

{"sheet":"Clients","index":5,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["ID Client","Nom du client","Téléphone","Email","Adresse ","Code Postal","Ville","Condition de paiement"]
["C001","Dupont SARL",1,"contact@dupontsarl.fr","12 Rue de la République",75001,"Paris","30 jours fin de mois"]
["C002","Martin & Fils",6,"info@martinfils.fr","18 Avenue Victor Hugo",29200,"Brest","45 jours nets"]
["C003","Lefèvre Industries",null,"admin@lefevreindus.fr","5 Rue des Entrepreneurs",13008,"Marseille","30 jours nets"]
["C004","Société Giraud",null,"giraud.contact@socgiraud.fr","22 Boulevard Saint-Michel",75005,"Paris","60 jours fin de mois"]
["C005","Pelletier et Associés",null,"contact@pelletierassocies.fr","3 Rue du Commerce",59000,"Lille","30 jours fin de mois"]
["C006","Rousseau Constructions",null,"rousseau@constrouseau.fr","25 Quai de la Garonne",33000,"Bordeaux","45 jours nets"]
["C007","Dubois Informatique",null,"support@duboisinfo.fr","9 Rue de la Technologie",37000,"Tours","30 jours nets"]
["C008","Morin Transport",null,"logistique@morintrans.fr","7 Allée des Chênes",38000,"Grenoble","60 jours fin de mois"]
["C009","Bernard et Cie",null,"accueil@bernardcie.fr","14 Rue des Capucines",78000,"Versailles","30 jours fin de mois"]
["C010","Petit Distribution",null,"service@petitdist.fr","30 Route de Strasbourg",67000,"Strasbourg","45 jours nets"]

{"sheet":"Preparation","index":6,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Clients","Nom","Montant",null,"Clients","Nom client","Montant TTC"]
[{"$f":"_xlfn.UNIQUE(tab_suivi[ID Client])","v":"C002"},{"$f":"_xlfn.XLOOKUP(_xlfn.ANCHORARRAY(A2),tab_clients[ID Client],tab_clients[Nom du client])","v":"Martin & Fils"},{"$f":"SUMIFS(tab_suivi[Montant TTC],tab_suivi[ID Client],Preparation!A2)","v":538},null,{"$f":"_xlfn._xlws.SORT(A2:C11,3,-1)","v":"C009"},"Bernard et Cie",1153.5999999999999]
["C004","Société Giraud",{"$f":"SUMIFS(tab_suivi[Montant TTC],tab_suivi[ID Client],Preparation!A3)","v":330},null,"C007","Dubois Informatique",638.79999999999995]
["C009","Bernard et Cie",{"$f":"SUMIFS(tab_suivi[Montant TTC],tab_suivi[ID Client],Preparation!A4)","v":1153.5999999999999},null,"C001","Dupont SARL",571.19999999999993]
["C005","Pelletier et Associés",{"$f":"SUMIFS(tab_suivi[Montant TTC],tab_suivi[ID Client],Preparation!A5)","v":305.39999999999998},null,"C002","Martin & Fils",538]
["C007","Dubois Informatique",{"$f":"SUMIFS(tab_suivi[Montant TTC],tab_suivi[ID Client],Preparation!A6)","v":638.79999999999995},null,"C010","Petit Distribution",431.4]
["C003","Lefèvre Industries",{"$f":"SUMIFS(tab_suivi[Montant TTC],tab_suivi[ID Client],Preparation!A7)","v":381},null,"C008","Morin Transport",400]
["C010","Petit Distribution",{"$f":"SUMIFS(tab_suivi[Montant TTC],tab_suivi[ID Client],Preparation!A8)","v":431.4},null,"C003","Lefèvre Industries",381]
["C006","Rousseau Constructions",{"$f":"SUMIFS(tab_suivi[Montant TTC],tab_suivi[ID Client],Preparation!A9)","v":368},null,"C006","Rousseau Constructions",368]
["C008","Morin Transport",{"$f":"SUMIFS(tab_suivi[Montant TTC],tab_suivi[ID Client],Preparation!A10)","v":400},null,"C004","Société Giraud",330]
["C001","Dupont SARL",{"$f":"SUMIFS(tab_suivi[Montant TTC],tab_suivi[ID Client],Preparation!A11)","v":571.19999999999993},null,"C005","Pelletier et Associés",305.39999999999998]

{"sheet":"Param","index":7,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Numéro de facture intial","F",{"$f":"YEAR(TODAY())","v":2024},"001",{"$f":"B1&C1&D1","v":"F2024001"}]
["Numéro de facture en cours",null,null,null,"F2024003"]
["Chemin archivage PDF facture","/Users/carolinemontet/Documents/Les tutos de David/Production vidéo/facture/Factures_PDF/"]

{"sheet":"A propos","index":8,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,3,2,6]]}
[]
[null,null,null,"DMO Formation"]
[]
[]
[null,null,null,"Youtube","Chaine Tutos Excel"]
[null,null,null,"Facebook","Facebook"]
[null,null,null,"Linkedin","Voir le profil"]
[null,null,null,"Instagram","Voir le compte"]
[null,null,null,"Télégram","Voir le canal"]
[null,null,null,"Site","Visiter"]
[]
[]
[null,"Ce fichier est une démonstration avec des données fictives"]
[]
[null,"Pour visualiser le code source de la macro, activer l'onglet Développeur / Visual Basic"]
[]
[null,"Adaptez le code source selon votre besoin"]
[]
[null,"Vidéo dé démonstration",null,"https://youtu.be/xAPSJ84DDE0"]
[]
[null,"Vidéo d'explication (cachée)",null,"https://youtu.be/J81KBFL7jZY"]