{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Exemples","TS_Afficher","TCD_Dates","TS_Factures","TS_Saisie","TS_Commandes","TCD_Chrono"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":13,"comments":0,"pivot_tables":2},"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":"Exemples","index":0,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Tableau de bord"]
[null,"Nb élèves :",{"$f":"COUNTIFS(TS_Eleves[Actif], 1)","v":8}]
[null,"Notes >= 10 :",{"$f":"COUNTIFS(TS_Eleves[Actif], 1, TS_Eleves[Note], \">=10\")","v":7}]
[null,"Moyenne :",{"$f":"AVERAGEIFS(TS_Eleves[Note],TS_Eleves[Actif],1)","v":13.112500000000001}]
[null,"Profs :","DURAND, LEGRAND"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Nom Famille","Prénom","Genre","Note","Dates","Commentaire","Prof","Salle","Actif"]
[null,"TINE","Clément","Garçon",7.7,"2025-07-01","Doit fournir des efforts","DURAND","Bleue",{"$f":"SUBTOTAL(103,TS_Eleves[[#This Row],[Salle]])","v":1}]
[null,"TERRIEUR","Alain","Garçon",14,"2025-11-12","Très bien","DURAND","Verte",{"$f":"SUBTOTAL(103,TS_Eleves[[#This Row],[Salle]])","v":1}]
[null,"TERRIEUR","Alex","Garçon",17.5,"2025-01-08","Peut mieux faire","DURAND","Verte",{"$f":"SUBTOTAL(103,TS_Eleves[[#This Row],[Salle]])","v":1}]
[null,"DEFER","Phil","Fille",17.5,"2025-12-25","Excellent","LEGRAND","Jaune",{"$f":"SUBTOTAL(103,TS_Eleves[[#This Row],[Salle]])","v":1}]
[null,"CROCHE","Sarah","Fille",11.7,"2025-06-25","Très bien","LEGRAND","Verte",{"$f":"SUBTOTAL(103,TS_Eleves[[#This Row],[Salle]])","v":1}]
[null,"DEFER","Jean","Garçon",12,"2025-09-11","Peut mieux faire","LEGRAND","Bleue",{"$f":"SUBTOTAL(103,TS_Eleves[[#This Row],[Salle]])","v":1}]
[null,"LERMITE","Bernard","Garçon",13.5,"2025-12-25","Peut mieux faire","DURAND","Violette",{"$f":"SUBTOTAL(103,TS_Eleves[[#This Row],[Salle]])","v":1}]
[null,"LAGIRAF","Sophie","Fille",11,"2025-11-25","Très bien","DURAND","Bleue",{"$f":"SUBTOTAL(103,TS_Eleves[[#This Row],[Salle]])","v":1}]

{"sheet":"TS_Afficher","index":1,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Colonnes à afficher"]
["Aucune"]
["Prénom"]
["Genre"]
["Commentaire"]
[{"$f":"SUBTOTAL(103,TS_Afficher[Colonnes à afficher])","v":3}]

{"sheet":"TCD_Dates","index":2,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Étiquettes de lignes"]
["2025-01-08"]
["2025-06-25"]
["2025-07-01"]
["2025-09-11"]
["2025-11-12"]
["2025-11-25"]
["2025-12-25"]
["Total général"]

{"sheet":"TS_Factures","index":3,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"DURAND, LEGRAND"]
[]
[]
[]
["Date","Commande","Fournisseur","Produit","Quantité","Actif"]
["2026-01-07","AN2026A","BLONDIE","Orange",4,{"$f":"SUBTOTAL(103,TS_Factures[[#This Row],[Date]])","v":0}]
["2026-01-07","AN2026A","BLONDIE","Orange",5,{"$f":"SUBTOTAL(103,TS_Factures[[#This Row],[Date]])","v":0}]
["2026-01-08","AN2026B","ALPHA","Pommes",40,{"$f":"SUBTOTAL(103,TS_Factures[[#This Row],[Date]])","v":0}]
["2026-04-09","AN2026B","ALPHA","Pommes",100,{"$f":"SUBTOTAL(103,TS_Factures[[#This Row],[Date]])","v":1}]
["2026-06-03","AN2026D","JULIETTE","Bananes",23,{"$f":"SUBTOTAL(103,TS_Factures[[#This Row],[Date]])","v":1}]
["2026-06-06","AN2026A","ALPHA","Orange",100,{"$f":"SUBTOTAL(103,TS_Factures[[#This Row],[Date]])","v":1}]
["2026-06-07","AN2026B","ALPHA","Pommes",77,{"$f":"SUBTOTAL(103,TS_Factures[[#This Row],[Date]])","v":1}]
["2026-11-26","AN2026A","ALPHA","Pommes",77,{"$f":"SUBTOTAL(103,TS_Factures[[#This Row],[Date]])","v":0}]
["2026-12-26","AN2026B","ALPHA","Pommes",66,{"$f":"SUBTOTAL(103,TS_Factures[[#This Row],[Date]])","v":0}]

{"sheet":"TS_Saisie","index":4,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["Date","Commande","Fournisseur","Produit","Quantité"]
[]
["Total",null,null,null,{"$f":"SUBTOTAL(109,TS_Saisie[Quantité])","v":0}]

{"sheet":"TS_Commandes","index":5,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Période du :","2026-04-01","Au :","2026-07-31"]
[]
["Commande","Fournisseur","Produit","Quantité","Consommé","Reste"]
["AN2026A","ALPHA","Pommes",500,{"$f":"SUMIFS(TS_Factures[Quantité],TS_Factures[Actif],1,TS_Factures[Commande],TS_Commandes[[#This Row],[Commande]],TS_Factures[Fournisseur],TS_Commandes[[#This Row],[Fournisseur]],TS_Factures[Produit],TS_Commandes[[#This Row],[Produit]])","v":0},{"$f":"TS_Commandes[[#This Row],[Quantité]]-TS_Commandes[[#This Row],[Consommé]]","v":500}]
["AN2026A","ALPHA","Bananes",1000,{"$f":"SUMIFS(TS_Factures[Quantité],TS_Factures[Actif],1,TS_Factures[Commande],TS_Commandes[[#This Row],[Commande]],TS_Factures[Fournisseur],TS_Commandes[[#This Row],[Fournisseur]],TS_Factures[Produit],TS_Commandes[[#This Row],[Produit]])","v":0},{"$f":"TS_Commandes[[#This Row],[Quantité]]-TS_Commandes[[#This Row],[Consommé]]","v":1000}]
["AN2026A","ALPHA","Orange",300,{"$f":"SUMIFS(TS_Factures[Quantité],TS_Factures[Actif],1,TS_Factures[Commande],TS_Commandes[[#This Row],[Commande]],TS_Factures[Fournisseur],TS_Commandes[[#This Row],[Fournisseur]],TS_Factures[Produit],TS_Commandes[[#This Row],[Produit]])","v":100},{"$f":"TS_Commandes[[#This Row],[Quantité]]-TS_Commandes[[#This Row],[Consommé]]","v":200}]
["AN2026B","ALPHA","Pommes",400,{"$f":"SUMIFS(TS_Factures[Quantité],TS_Factures[Actif],1,TS_Factures[Commande],TS_Commandes[[#This Row],[Commande]],TS_Factures[Fournisseur],TS_Commandes[[#This Row],[Fournisseur]],TS_Factures[Produit],TS_Commandes[[#This Row],[Produit]])","v":177},{"$f":"TS_Commandes[[#This Row],[Quantité]]-TS_Commandes[[#This Row],[Consommé]]","v":223}]
["AN2026C","ALPHA","Pommes",540,{"$f":"SUMIFS(TS_Factures[Quantité],TS_Factures[Actif],1,TS_Factures[Commande],TS_Commandes[[#This Row],[Commande]],TS_Factures[Fournisseur],TS_Commandes[[#This Row],[Fournisseur]],TS_Factures[Produit],TS_Commandes[[#This Row],[Produit]])","v":0},{"$f":"TS_Commandes[[#This Row],[Quantité]]-TS_Commandes[[#This Row],[Consommé]]","v":540}]
["AN2026A","ALPHA","Orange",189,{"$f":"SUMIFS(TS_Factures[Quantité],TS_Factures[Actif],1,TS_Factures[Commande],TS_Commandes[[#This Row],[Commande]],TS_Factures[Fournisseur],TS_Commandes[[#This Row],[Fournisseur]],TS_Factures[Produit],TS_Commandes[[#This Row],[Produit]])","v":100},{"$f":"TS_Commandes[[#This Row],[Quantité]]-TS_Commandes[[#This Row],[Consommé]]","v":89}]
["AN2026A","BLONDIE","Pommes",400,{"$f":"SUMIFS(TS_Factures[Quantité],TS_Factures[Actif],1,TS_Factures[Commande],TS_Commandes[[#This Row],[Commande]],TS_Factures[Fournisseur],TS_Commandes[[#This Row],[Fournisseur]],TS_Factures[Produit],TS_Commandes[[#This Row],[Produit]])","v":0},{"$f":"TS_Commandes[[#This Row],[Quantité]]-TS_Commandes[[#This Row],[Consommé]]","v":400}]
["AN2026A","BLONDIE","Orange",200,{"$f":"SUMIFS(TS_Factures[Quantité],TS_Factures[Actif],1,TS_Factures[Commande],TS_Commandes[[#This Row],[Commande]],TS_Factures[Fournisseur],TS_Commandes[[#This Row],[Fournisseur]],TS_Factures[Produit],TS_Commandes[[#This Row],[Produit]])","v":0},{"$f":"TS_Commandes[[#This Row],[Quantité]]-TS_Commandes[[#This Row],[Consommé]]","v":200}]
["AN2026C","ROMEO","Pommes",100,{"$f":"SUMIFS(TS_Factures[Quantité],TS_Factures[Actif],1,TS_Factures[Commande],TS_Commandes[[#This Row],[Commande]],TS_Factures[Fournisseur],TS_Commandes[[#This Row],[Fournisseur]],TS_Factures[Produit],TS_Commandes[[#This Row],[Produit]])","v":0},{"$f":"TS_Commandes[[#This Row],[Quantité]]-TS_Commandes[[#This Row],[Consommé]]","v":100}]
["AN2026C","ROMEO","Orange",100,{"$f":"SUMIFS(TS_Factures[Quantité],TS_Factures[Actif],1,TS_Factures[Commande],TS_Commandes[[#This Row],[Commande]],TS_Factures[Fournisseur],TS_Commandes[[#This Row],[Fournisseur]],TS_Factures[Produit],TS_Commandes[[#This Row],[Produit]])","v":0},{"$f":"TS_Commandes[[#This Row],[Quantité]]-TS_Commandes[[#This Row],[Consommé]]","v":100}]
["AN2026C","JULIETTE","Orange",200,{"$f":"SUMIFS(TS_Factures[Quantité],TS_Factures[Actif],1,TS_Factures[Commande],TS_Commandes[[#This Row],[Commande]],TS_Factures[Fournisseur],TS_Commandes[[#This Row],[Fournisseur]],TS_Factures[Produit],TS_Commandes[[#This Row],[Produit]])","v":0},{"$f":"TS_Commandes[[#This Row],[Quantité]]-TS_Commandes[[#This Row],[Consommé]]","v":200}]
["AN2026C","JULIETTE","Pommes",100,{"$f":"SUMIFS(TS_Factures[Quantité],TS_Factures[Actif],1,TS_Factures[Commande],TS_Commandes[[#This Row],[Commande]],TS_Factures[Fournisseur],TS_Commandes[[#This Row],[Fournisseur]],TS_Factures[Produit],TS_Commandes[[#This Row],[Produit]])","v":0},{"$f":"TS_Commandes[[#This Row],[Quantité]]-TS_Commandes[[#This Row],[Consommé]]","v":100}]
["AN2026C","JULIETTE","Bananes",100,{"$f":"SUMIFS(TS_Factures[Quantité],TS_Factures[Actif],1,TS_Factures[Commande],TS_Commandes[[#This Row],[Commande]],TS_Factures[Fournisseur],TS_Commandes[[#This Row],[Fournisseur]],TS_Factures[Produit],TS_Commandes[[#This Row],[Produit]])","v":0},{"$f":"TS_Commandes[[#This Row],[Quantité]]-TS_Commandes[[#This Row],[Consommé]]","v":100}]
["AN2026D","JULIETTE","Bananes",100,{"$f":"SUMIFS(TS_Factures[Quantité],TS_Factures[Actif],1,TS_Factures[Commande],TS_Commandes[[#This Row],[Commande]],TS_Factures[Fournisseur],TS_Commandes[[#This Row],[Fournisseur]],TS_Factures[Produit],TS_Commandes[[#This Row],[Produit]])","v":23},{"$f":"TS_Commandes[[#This Row],[Quantité]]-TS_Commandes[[#This Row],[Consommé]]","v":77}]
["Total",null,null,{"$f":"SUBTOTAL(109,TS_Commandes[Quantité])","v":4229},{"$f":"SUBTOTAL(109,TS_Commandes[Consommé])","v":400},{"$f":"SUBTOTAL(109,TS_Commandes[Reste])","v":3829}]

{"sheet":"TCD_Chrono","index":6,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Étiquettes de lignes"]
["2026-04-09"]
["2026-06-03"]
["2026-06-06"]
["2026-06-07"]
["Total général"]