{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Menu","Structure normalisée","Structure en étoile (flocon)","TCD","Clients","Produits","Factures","Détail factures","Formulaire facture"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":80,"comments":1,"pivot_tables":3},"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","index":0,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[15,5,15,6],[14,9,14,11],[15,9,15,11]]}
[]
[]
[null,null,null,"Gestionnaire clients, factures et produits"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Fichier développé par Gaëtan Mourmant "]
[null,null,null,"Pour toute question : ",null,"contact@polykromy.com",null,null,null,"www.xlerateur.com"]
[null,null,null,"Cette application fait partie du CD : \"Organiser et Gérer vos données sous Excel\", disponible ici : ",null,null,null,null,null,null,null,"www.polykromy.com"]
[]
[]
[]
[null,null,"Menu alternatif : "]
[null,null,"On peut utiliser ce menu pour accéder directement aux formulaires (les feuilles peuvent être masquées)"]

{"sheet":"Structure normalisée","index":1,"n_rows":26,"n_cols":16,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["No","Date","No Client",null,null,"No client","Société","Nom","Prénom","Adresse 1","Adresse 2","Ville","Code postal","Pays","Téléphone","Email"]
[1,"2011-12-01",1,null,null,1,"Société A","Dupont","Benoit","1, rue des tilleuls",null,"Lille",59000,"France","03 20 21 22 23 25"]
[2,"2011-09-09",2,null,null,2,"Société B","Durand","Bertrand","2, Bd de la révolution",null,"Paris",92500,"France","03 20 22 24 28 36"]
[3,"2011-12-01",1,null,null,3,"Société C","Dubois","Bernard","3, rue Dutour",null,"Paris",92600,"France","03 20 21 22 23 24"]
[4,"2011-03-01",1,null,"La table Client est liée à la table Facture via le numéro de client"]
[5,"2011-03-02",3]
[null,null,null,"La table Facture est liée à la table Facture détail via le numéro de facture"]
["No","No Facture","No Produit","Prix unitaire","Quantité","Total"]
[1,1,3,20,1,{"$f":"E9*D9","v":20}]
[2,1,2,10,1,{"$f":"E10*D10","v":10}]
[3,1,3,20,3,60]
[4,2,2,10,5,50]
[5,2,3,20,1,20]
[6,3,2,10,2,20]
[7,3,3,20,1,20]
[8,3,3,20,2,{"$f":"E16*D16","v":40}]
[9,3,2,10,1,{"$f":"E17*D17","v":10}]
[10,4,1,60,10,{"$f":"E18*D18","v":600}]
[11,5,4,50,5,{"$f":"E19*D19","v":250}]
[]
[null,null,"La table Produit est liée à la table Facture détail via le numéro de produit"]
["No Produit","Intitulé du produit","Description du produit"]
[1,"Produit A","Ceci est le produit A"]
[2,"Produit B","Ceci est le produit B"]
[3,"Produit C","Ceci est le produit C"]
[4,"Produit D","Ceci est le produit D"]

{"sheet":"Structure en étoile (flocon)","index":2,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"No","Intitulé du produit"]
[null,1,"Produit A",null,null,null,"No","Pays","Ville"]
[null,2,"Produit B",null,null,null,1,"France","Lille"]
[null,3,"Produit C",null,null,null,2,"France","Paris"]
[null,4,"Produit D"]
[null,null,null,null,null,null,null,null,null,null,"No","Année","Mois"]
[null,null,null,null,null,null,null,null,null,null,1,2011,"Janvier"]
[null,null,null,null,null,null,null,null,null,null,2,2011,"Février"]
[null,null,null,null,null,null,null,null,null,null,3,2011,"Mars"]
[null,null,null,null,null,null,null,null,null,null,4,2011,"Avril"]
[null,null,"No","No Produit","No Ville Pays","NoMoisAnnée","Somme de Quantité","Somme de Total",null,null,5,2011,"Mai"]
[null,null,1,1,1,3,10,600,null,null,6,2011,"Juin"]
[null,null,2,2,1,12,4,40,null,null,7,2011,"Juillet"]
[null,null,3,2,2,9,5,50,null,null,8,2011,"Août"]
[null,null,4,3,1,12,7,140,null,null,9,2011,"Septembre"]
[null,null,5,3,2,9,1,20,null,null,10,2011,"Octobre"]
[null,null,6,4,2,3,5,250,null,null,11,2011,"Novembre"]
[null,null,null,null,null,null,null,null,null,null,12,2011,"Décembre"]

{"sheet":"TCD","index":3,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
["Tableau croisé dynamique basé sur une seule table dénormalisée"]
[]
["Somme de Total",null,"Années","Date facture"]
[null,null,"2011",null,null,"Total 2011","Total général"]
["Pays","Ville","mars","sept","déc"]
["France","Lille",600,null,180,780,780]
[null,"Paris",250,70,null,320,320]
["Total France",null,850,70,180,1100,1100]
["Total général",null,850,70,180,1100,1100]
[]
[]
["Tableau croisé dynamique basé sur 4 tables normalisées et fusionnée via PowerPivot"]
[]
["Somme de Total",null,"Date (année)","Date (mois)","Date"]
[null,null,"2011",null,null,"Total 2011","Total général"]
[null,null,"mars","sept","déc"]
["Pays","Ville"]
["France","Lille",600,null,180,780,780]
[null,"Paris",250,70,null,320,320]
["Total France",null,850,70,180,1100,1100]
["Total général",null,850,70,180,1100,1100]
[]
["Tableau croisé dynamique basé sur un cube de données fusionné via PowerPivot"]
[]
["Somme de Somme de Total",null,"Année","Mois"]
[null,null,2011,null,null,"Total 2011","Total général"]
["Pays","Ville","Mars","Septembre","Décembre"]
["France","Lille",600,null,180,780,780]
[null,"Paris",250,70,null,320,320]
["Total France",null,850,70,180,1100,1100]
["Total général",null,850,70,180,1100,1100]

{"sheet":"Clients","index":4,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["No client","Société","Nom","Prénom","Adresse 1","Adresse 2","Ville","Code postal","Pays","Téléphone","Email"]
[1,"Société A","Dupont","Benoit","1, rue des tilleuls",null,"Lille",59000,"France","03 20 21 22 23 25"]
[2,"Société B","Durand","Bertrand","2, Bd de la révolution",null,"Paris",92500,"France","03 20 22 24 28 36"]
[3,"Société C","Dubois","Bernard","3, rue Dutour",null,"Paris",92600,"France","03 20 21 22 23 24"]

{"sheet":"Produits","index":5,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["No Produit","Intitulé du produit","Description du produit"]
[1,"Produit A","Ceci est le produit A"]
[2,"Produit B","Ceci est le produit B"]
[3,"Produit C","Ceci est le produit C"]
[4,"Produit D","Ceci est le produit D"]

{"sheet":"Factures","index":6,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["No","Date","No Client"]
[1,"2011-12-01",1]
[2,"2011-09-09",2]
[3,"2011-12-01",1]
[4,"2011-03-01",1]
[5,"2011-03-02",3]

{"sheet":"Détail factures","index":7,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["No","No Facture","No Produit","Prix unitaire","Quantité","Total","Date facture","Intitulé du produit","Description du produit","ClientNo","Nom","Prénom","Société","Ville","Pays"]
[1,1,3,20,1,{"$f":"E2*D2","v":20},{"$f":"INDEX(Factures_Colonne_Date,MATCH(B2,Factures_Colonne_No,0))","v":"2011-12-01"},{"$f":"INDEX(Produits_Colonne_Intitule_du_produit,MATCH(C2,Produits_Colonne_No_Produit,0))","v":"Produit C"},{"$f":"INDEX(Produits_Colonne_Description_du_produit,MATCH(C2,Produits_Colonne_No_Produit,0))","v":"Ceci est le produit C"},{"$f":"INDEX(TableauFactures[No Client],MATCH(TableauDetailsFactures[[#This Row],[No Facture]],TableauFactures[No],0))","v":1},{"$f":"INDEX(TableauClients[Nom],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Dupont"},{"$f":"INDEX(TableauClients[Prénom],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Benoit"},{"$f":"INDEX(TableauClients[Société],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Société A"},{"$f":"INDEX(TableauClients[Ville],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Lille"},{"$f":"INDEX(TableauClients[Pays],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"France"}]
[2,1,2,10,1,{"$f":"E3*D3","v":10},"2011-12-01","Produit B","Ceci est le produit B",{"$f":"INDEX(TableauFactures[No Client],MATCH(TableauDetailsFactures[[#This Row],[No Facture]],TableauFactures[No],0))","v":1},{"$f":"INDEX(TableauClients[Nom],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Dupont"},{"$f":"INDEX(TableauClients[Prénom],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Benoit"},{"$f":"INDEX(TableauClients[Société],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Société A"},{"$f":"INDEX(TableauClients[Ville],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Lille"},{"$f":"INDEX(TableauClients[Pays],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"France"}]
[3,1,3,20,3,60,"2011-12-01","Produit C","Ceci est le produit C",{"$f":"INDEX(TableauFactures[No Client],MATCH(TableauDetailsFactures[[#This Row],[No Facture]],TableauFactures[No],0))","v":1},{"$f":"INDEX(TableauClients[Nom],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Dupont"},{"$f":"INDEX(TableauClients[Prénom],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Benoit"},{"$f":"INDEX(TableauClients[Société],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Société A"},{"$f":"INDEX(TableauClients[Ville],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Lille"},{"$f":"INDEX(TableauClients[Pays],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"France"}]
[4,2,2,10,5,50,"2011-09-09","Produit B","Ceci est le produit B",{"$f":"INDEX(TableauFactures[No Client],MATCH(TableauDetailsFactures[[#This Row],[No Facture]],TableauFactures[No],0))","v":2},{"$f":"INDEX(TableauClients[Nom],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Durand"},{"$f":"INDEX(TableauClients[Prénom],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Bertrand"},{"$f":"INDEX(TableauClients[Société],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Société B"},{"$f":"INDEX(TableauClients[Ville],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Paris"},{"$f":"INDEX(TableauClients[Pays],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"France"}]
[5,2,3,20,1,20,"2011-09-09","Produit C","Ceci est le produit C",{"$f":"INDEX(TableauFactures[No Client],MATCH(TableauDetailsFactures[[#This Row],[No Facture]],TableauFactures[No],0))","v":2},{"$f":"INDEX(TableauClients[Nom],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Durand"},{"$f":"INDEX(TableauClients[Prénom],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Bertrand"},{"$f":"INDEX(TableauClients[Société],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Société B"},{"$f":"INDEX(TableauClients[Ville],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Paris"},{"$f":"INDEX(TableauClients[Pays],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"France"}]
[6,3,2,10,2,20,"2011-12-01","Produit B","Ceci est le produit B",{"$f":"INDEX(TableauFactures[No Client],MATCH(TableauDetailsFactures[[#This Row],[No Facture]],TableauFactures[No],0))","v":1},{"$f":"INDEX(TableauClients[Nom],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Dupont"},{"$f":"INDEX(TableauClients[Prénom],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Benoit"},{"$f":"INDEX(TableauClients[Société],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Société A"},{"$f":"INDEX(TableauClients[Ville],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Lille"},{"$f":"INDEX(TableauClients[Pays],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"France"}]
[7,3,3,20,1,20,"2011-12-01","Produit C","Ceci est le produit C",{"$f":"INDEX(TableauFactures[No Client],MATCH(TableauDetailsFactures[[#This Row],[No Facture]],TableauFactures[No],0))","v":1},{"$f":"INDEX(TableauClients[Nom],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Dupont"},{"$f":"INDEX(TableauClients[Prénom],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Benoit"},{"$f":"INDEX(TableauClients[Société],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Société A"},{"$f":"INDEX(TableauClients[Ville],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Lille"},{"$f":"INDEX(TableauClients[Pays],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"France"}]
[8,3,3,20,2,{"$f":"E9*D9","v":40},"2011-12-01","Produit C","Ceci est le produit C",{"$f":"INDEX(TableauFactures[No Client],MATCH(TableauDetailsFactures[[#This Row],[No Facture]],TableauFactures[No],0))","v":1},{"$f":"INDEX(TableauClients[Nom],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Dupont"},{"$f":"INDEX(TableauClients[Prénom],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Benoit"},{"$f":"INDEX(TableauClients[Société],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Société A"},{"$f":"INDEX(TableauClients[Ville],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Lille"},{"$f":"INDEX(TableauClients[Pays],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"France"}]
[9,3,2,10,1,{"$f":"E10*D10","v":10},"2011-12-01","Produit B","Ceci est le produit B",{"$f":"INDEX(TableauFactures[No Client],MATCH(TableauDetailsFactures[[#This Row],[No Facture]],TableauFactures[No],0))","v":1},{"$f":"INDEX(TableauClients[Nom],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Dupont"},{"$f":"INDEX(TableauClients[Prénom],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Benoit"},{"$f":"INDEX(TableauClients[Société],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Société A"},{"$f":"INDEX(TableauClients[Ville],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Lille"},{"$f":"INDEX(TableauClients[Pays],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"France"}]
[10,4,1,60,10,{"$f":"E11*D11","v":600},"2011-03-01","Produit A","Ceci est le produit A",{"$f":"INDEX(TableauFactures[No Client],MATCH(TableauDetailsFactures[[#This Row],[No Facture]],TableauFactures[No],0))","v":1},{"$f":"INDEX(TableauClients[Nom],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Dupont"},{"$f":"INDEX(TableauClients[Prénom],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Benoit"},{"$f":"INDEX(TableauClients[Société],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Société A"},{"$f":"INDEX(TableauClients[Ville],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Lille"},{"$f":"INDEX(TableauClients[Pays],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"France"}]
[11,5,4,50,5,{"$f":"E12*D12","v":250},"2011-03-02","Produit D","Ceci est le produit D",{"$f":"INDEX(TableauFactures[No Client],MATCH(TableauDetailsFactures[[#This Row],[No Facture]],TableauFactures[No],0))","v":3},{"$f":"INDEX(TableauClients[Nom],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Dubois"},{"$f":"INDEX(TableauClients[Prénom],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Bernard"},{"$f":"INDEX(TableauClients[Société],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Société C"},{"$f":"INDEX(TableauClients[Ville],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"Paris"},{"$f":"INDEX(TableauClients[Pays],MATCH(TableauDetailsFactures[[#This Row],[ClientNo]],TableauClients[No client],0))","v":"France"}]

{"sheet":"Formulaire facture","index":8,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Nom de votre société",null,null,"FACTURE",null,null,"Informations techniques pour le formulaire"]
["Slogan de votre société"]
[]
["Adresse",null,"DATE :",{"$f":"INDEX(Factures_Colonne_Date,MATCH(form_facture_no_facture,Factures_Colonne_No,0))","v":"2011-12-01"}]
["Code postal, Ville",null,"N° FACTURE",1]
["Tél. +33 3 20 20 20 20 \nFax. +33 3 20 20 20 20",null,"POUR :","Description du projet ou service"]
[]
[]
["Facturé à :",null,null,null,null,null,"Numéro du client : "]
[{"$f":"\"Votre numéro client : \" & form_facture_no_client","v":"Votre numéro client : 1"},null,null,null,null,null,{"$f":"INDEX(Factures_Colonne_No_Client,MATCH(form_facture_no_facture,Factures_Colonne_No,0))","v":1}]
[{"$f":"INDEX(Clients_Colonne_Prenom,MATCH(form_facture_no_client,Clients_Colonne_No_client,0))&\" \"&INDEX(Clients_Colonne_Nom,MATCH(form_facture_no_client,Clients_Colonne_No_client,0))&\"\"","v":"Benoit Dupont"}]
[{"$f":"INDEX(Clients_Colonne_Societe,MATCH(form_facture_no_client,Clients_Colonne_No_client,0))&\"\"","v":"Société A"}]
[{"$f":"INDEX(Clients_Colonne_Adresse_1,MATCH(form_facture_no_client,Clients_Colonne_No_client,0))&\"\"","v":"1, rue des tilleuls"}]
[{"$f":"INDEX(Clients_Colonne_Adresse_2,MATCH(form_facture_no_client,Clients_Colonne_No_client,0))&\"\"","v":""}]
[{"$f":"INDEX(Clients_Colonne_Code_postal,MATCH(form_facture_no_client,Clients_Colonne_No_client,0)) & \", \" & INDEX(Clients_Colonne_Ville,MATCH(form_facture_no_client,Clients_Colonne_No_client,0))","v":"59000, Lille"}]
[{"$f":"INDEX(Clients_Colonne_Telephone,MATCH(form_facture_no_client,Clients_Colonne_No_client,0))&\"\"","v":"03 20 21 22 23 25"}]
[]
[]
["DESCRIPTION","P.U.","Quté","MONTANT",null,null,"No de ligne dans la table facture"]
[{"$f":"IF(ISNA(G20),\"\",INDEX(Detail_factures_Colonne_Intitule_du_produit,G20)&\" - \"&INDEX(Detail_factures_Colonne_Description_du_produit,G20))","v":"Produit C - Ceci est le produit C"},{"$f":"IF(ISNA(G20),\"\",INDEX(Detail_factures_Colonne_Prix_unitaire,G20))","v":20},{"$f":"IF(ISNA(G20),\"\",INDEX(Detail_factures_Colonne_Quantite,G20))","v":1},{"$f":"IF(ISNA(G20),\"\",INDEX(Detail_factures_Colonne_Total,G20))","v":20},null,null,{"$f":"MATCH(form_facture_no_facture,Detail_factures_Colonne_No_Facture,0)","v":1}]
["Produit B - Ceci est le produit B",10,1,10,null,null,{"$f":"MATCH(form_facture_no_facture,OFFSET(Detail_factures_Colonne_No_Facture,G20,0,COUNTA(Detail_factures_Colonne_No)-G20+1),0)+G20","v":2}]
["Produit C - Ceci est le produit C",20,3,60,null,null,3]
["","","","",null,null,{"$error":"#N/A"}]
["","","","",null,null,{"$error":"#N/A"}]
["","","","",null,null,{"$error":"#N/A"}]
["","","","",null,null,{"$error":"#N/A"}]
["","","","",null,null,{"$error":"#N/A"}]
["","","","",null,null,{"$error":"#N/A"}]
["","","","",null,null,{"$error":"#N/A"}]
["","","","",null,null,{"$error":"#N/A"}]
["","","","",null,null,{"$error":"#N/A"}]
["","","","",null,null,{"$error":"#N/A"}]
["","","","",null,null,{"$error":"#N/A"}]
["","","","",null,null,{"$error":"#N/A"}]
["","","","",null,null,{"$error":"#N/A"}]
["","","","",null,null,{"$error":"#N/A"}]
[null,null,"TOTAL",{"$f":"IF(SUM(D20:D36)=INDEX(Factures_Colonne_Total,MATCH(form_facture_no_facture,Factures_Colonne_No,0)),SUM(D20:D36),\"Erreur!\")","v":{"$error":"#REF!"}}]
[]
[]
["Veuillez rédiger tous les chèques à l'ordre de Nom de votre société"]
["Pour toute question concernant cette facture, veuillez contacter Nom, numéro de téléphone, adresse de messagerie"]