{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["FICHE DE RENSEIGNEMENTS","Page 1","Page 2","Page 3","Page 4","COMPTE DE FONCTIONNEMENT"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":3,"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":"FICHE DE RENSEIGNEMENTS","index":0,"n_rows":99,"n_cols":14,"rows_kept":99,"cut":false,"hidden":false,"merged":[[92,1,99,1],[92,2,99,7],[98,11,98,18],[81,11,81,18],[82,1,85,1],[82,2,85,7],[83,11,85,18],[87,1,90,1],[87,2,90,7],[77,1,80,1],[77,2,80,7],[57,1,57,2],[57,3,57,7],[59,1,59,2],[59,3,59,7],[61,1,61,7],[63,1,65,7],[67,1,70,1],[67,2,70,7],[72,1,75,1],[72,2,75,7],[61,10,61,18],[51,1,51,2],[51,3,51,7],[53,3,53,4],[53,6,53,7],[39,1,39,2],[41,1,41,2],[43,1,43,2],[53,23,53,28],[55,1,55,2],[55,3,55,7],[45,3,45,4],[45,6,45,7],[47,1,47,2],[47,3,47,7],[49,1,49,2],[49,3,49,7],[43,3,43,7],[41,3,41,7],[39,3,39,7],[25,1,25,2],[25,3,25,7],[27,1,27,2],[37,3,37,4],[37,6,37,7],[27,3,27,7],[29,3,29,4],[29,6,29,7],[31,3,31,7],[33,1,33,2],[33,3,33,7],[35,1,35,2],[35,3,35,7],[31,1,31,2],[11,13,15,18],[16,13,19,18],[21,3,21,4],[21,6,21,7],[23,1,23,2],[23,3,23,7],[15,4,15,7],[15,2,15,3],[11,3,11,4],[18,1,18,7],[11,10,15,11],[16,10,19,11],[21,10,22,11],[21,13,22,18],[23,13,25,18],[23,10,25,11],[8,10,9,11],[5,10,7,11],[5,13,7,18],[8,13,9,18],[9,1,9,3],[9,4,9,5],[3,10,3,18],[5,1,5,7],[7,1,7,7],[1,3,1,7],[3,3,3,7]]}
[]
[null,null,null,"OCCE DE LA REUNION "]
[]
[null,null,null,"COOPERATIVE SCOLAIRE DE L'ECOLE",null,null,null,null,null,null,"Dans quel compte ventiler une dépense ou une recette ?"]
[]
[null,null,null,null,null,null,null,null,null,null,"70700008",null,null,"Argent récolté de la vente d'articles non fabriqués par les enfants , calendriers, ...  L'argent des photos de classes ne transite pas par la coop de classe!"]
[]
[null,"COOPERATIVE DE CLASSE"]
[null,null,null,null,null,null,null,null,null,null,"60700008",null,null,"Dépenses faites pour acheter des produits finis destinés à la revente, sans modification "]
[null,"Année scolaire"]
[]
[null,null,"Classe",null,null,null,null,null,null,null,"70800008",null,null,"Recettes tirées des kermesses, des lotos et des participations demandées pour les activités éducatives SI ces sommes ne sont pas remises au mandataire de la coop école… Ces participations financières auront toujours un aspect facultatif."]
[]
[null,null,"Effectif"]
[]
[null,null,"Tuteur,trice"]
[null,null,null,null,null,null,null,null,null,null,"61810008",null,null,"Ensemble des charges résultant des activités pédagogiques de la coopérative de classe…"]
[]
[null,"CONSEIL DE COOPERATIVE DE CLASSE"]
[]
[]
[null,null,"Du  ",null,null,"au  ",null,null,null,null,"77000008",null,null,"Recettes inattendues : dons, solidarité."]
[]
[null,"Président",null,null,null,null,null,null,null,null,"67000008",null,null,"Ce compte devrait toujours être minime : solidarité internationale, nationale, ou dans l’école…"]
[]
[null,"Secrétaire"]
[]
[null,"Trésorier"]
[]
[null,null,"Du  ",null,null,"au  "]
[]
[null,"Président"]
[]
[null,"Secrétaire"]
[]
[null,"Trésorier"]
[]
[null,null,"Du  ",null,null,"au  "]
[]
[null,"Président"]
[]
[null,"Secrétaire"]
[]
[null,"Trésorier"]
[]
[null,null,"Du  ",null,null,"au  "]
[]
[null,"Président"]
[]
[null,"Secrétaire"]
[]
[null,"Trésorier"]
[]
[null,null,"Du  ",null,null,"au  "]
[]
[null,"Président"]
[]
[null,"Secrétaire"]
[]
[null,"Trésorier"]
[]
[null,"Quelques conseils",null,null,null,null,null,null,null,null,"Saisisser vos données dans les colonnes 1 à 6."]
[]
[null,"La participation financière demandée aux élèves\n- fréquemment appelée \"cotisation\" -\nne peut être que volontaire et modique. "]
[]
[]
[]
[null,"þ","Ne peuvent gérer des coop. de classe que des enseignants,\nmembres de la coopérative scolaire\n- donc affilié à l'OCCE -"]
[]
[]
[]
[]
[null,"þ","La coopérative de classe ne peut gérer que des espèces ;\nLes chèques sont remis au mandataire ;\nA aucun moment la caisse ne doit être en situation négative."]
[]
[]
[]
[]
[null,"þ","En fin d’année scolaire, le tuteur remettra au mandataire de la coopérative d’école son compte de fonctionnement.\nCelui-ci sera intégré dans les comptes de la coopérative d’école."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Mouvements internes"]
[null,"þ","Il est interdit d’utiliser son compte personnel pour gérer les fonds\nde la coopérative de classe...\n...même si ces sommes ne font qu’y transiter"]
[null,null,null,null,null,null,null,null,null,null,null,"C'est le transfert d'espèces du compte Caisse de la coop. Centrale\nsur le compte Caisse de la coop. de classe (ou inversement)"]
[]
[]
[]
[null,"þ","Il est interdit d’utiliser à des fins personnelles les sommes importantes du début d’année et de rembourser en effectuant au cours de l’année les achats pour la classe  "]
[]
[]
[]
[]
[null,"þ","                                  Les achats...\n- Pour le prévisible :\nfaire des commandes réglées par chèque de la coopérative d’école ;\n- Pour l’occasionnel :\nrégler avec des espèces (des petits montants).\n- L'achat d’un gros équipement (livres BCD, matériel audio-visuel...) est du ressort de la coop. d'école."]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Le reliquat"]

{"sheet":"Page 1","index":1,"n_rows":32,"n_cols":26,"rows_kept":32,"cut":false,"hidden":false,"merged":[[27,3,27,7],[28,3,28,7],[29,3,29,7],[30,3,30,7],[31,1,31,8],[26,3,26,7],[15,3,15,7],[16,3,16,7],[17,3,17,7],[18,3,18,7],[19,3,19,7],[20,3,20,7],[21,3,21,7],[22,3,22,7],[23,3,23,7],[24,3,24,7],[25,3,25,7],[3,18,4,18],[3,19,4,19],[3,15,4,15],[3,12,5,12],[14,3,14,7],[6,3,6,7],[7,3,7,7],[8,3,8,7],[3,13,4,13],[9,3,9,7],[10,3,10,7],[11,3,11,7],[12,3,12,7],[13,3,13,7],[3,14,4,14],[3,16,5,16],[3,17,4,17],[0,12,1,12],[0,16,1,16],[2,1,5,1],[2,2,5,2],[2,3,5,7],[2,8,5,8],[2,9,4,11],[0,9,1,11],[0,13,1,15],[0,17,1,19],[0,1,1,2],[0,3,1,4],[0,5,1,5],[0,6,1,6],[0,7,1,8]]}
[null,"ANNÉE SCOLAIRE",null,{"$f":"'FICHE DE RENSEIGNEMENTS'!$E$10","v":0},null,"Page ",1,"TUTEUR  ",null,{"$f":"'FICHE DE RENSEIGNEMENTS'!$E$16","v":0},null,null,"Virement DE\ncoop. école","CLASSE 7 : COMPTES DE PRODUITS (Entrées)",null,null,"Virement  A \ncoop. école","CLASSE 6 : COMPTES DE CHARGES (Sorties)"]
[]
[null,"N°\nde\nPJ","Date","LIBELLE\n\nNature de la pièce comptable",null,null,null,null,"A ventiler\ndans le compte N°","530  CAISSE",null,null,"R",707,708,77,"V",607,618,67]
[null,null,null,null,null,null,null,null,null,null,null,null,"Sommes reçues\nde\nla coop école","Cessions\nde produits","Produits\ndes activités\néducatives","Produits\nexceptionnels","Sommes versées\nA\nla coop. école","Achats\nde produits\npour cession","Charges\ndes activités\néducatives","Charges\nexceptionnelles"]
[]
[null,null,null,null,null,null,null,null,null,"ENTRÉES","SORTIES","SITUATION",null,"Mat. Scolaire\ncalendriers ...","Recettes tirées des actions éducatives","Dons,\nsolidarité",null,"Mat. Scolaire\ncalendriers,,,","Toutes dépenses liées aux actions éducatives","Évènement\n imprévu, solidarité"]
["01","1",null,"Régie d'avance reçue (1ère écriture obligatoire)",null,null,null,null,"R",null,null,{"$f":"J7","v":0},{"$f":"IF((I7=M$3),J7,\"\")","v":0},{"$f":"IF(($I7=N$3),J7,\"\")","v":""},{"$f":"IF(($I7=O$3),J7,\"\")","v":""},{"$f":"IF(($I7=P$3),J7,\"\")","v":""},{"$f":"IF((I7=Q$3),K7,\"\")","v":""},{"$f":"IF(($I7=R$3),K7,\"\")","v":""},{"$f":"IF(($I7=S$3),K7,\"\")","v":""},{"$f":"IF(($I7=T$3),K7,\"\")","v":""},null,null,null,null,null,"R"]
["02",null,null,null,null,null,null,null,null,null,null,{"$f":"(L7+J8)-K8","v":0},{"$f":"IF((I8=M$3),J8,\"\")","v":""},"","","","","","","",null,null,null,null,null,"V"]
["03",null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF((I9=M$3),J9,\"\")","v":""},"","","","","","","",null,null,null,null,null,707]
["04",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","",null,null,null,null,null,607]
["05",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","",null,null,null,null,null,708]
["06",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","",null,null,null,null,null,618]
["07",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","",null,null,null,null,null,77]
["08",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","",null,null,null,null,null,67]
["09",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["10",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["11",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["12",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["13",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["14",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["15",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["16",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["17",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["18",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["19",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["20",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["21",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["22",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["23",null,null,null,null,null,null,null,null,null,null,0,"",{"$f":"IF(($I29=N$3),J29,\"\")","v":""},{"$f":"IF(($I29=O$3),J29,\"\")","v":""},"","","","",""]
["24",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["25",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
[null,"REPORT",null,null,null,null,null,null,null,{"$f":"SUM(J7:J31)","v":0},{"$f":"SUM(K7:K31)","v":0},{"$f":"L31","v":0},{"$f":"SUM(M7:M31)","v":0},{"$f":"SUM(N7:N31)","v":0},0,0,0,0,0,0]

{"sheet":"Page 2","index":2,"n_rows":32,"n_cols":26,"rows_kept":32,"cut":false,"hidden":false,"merged":[[27,3,27,7],[28,3,28,7],[29,3,29,7],[30,3,30,7],[31,1,31,8],[26,3,26,7],[15,3,15,7],[16,3,16,7],[17,3,17,7],[18,3,18,7],[19,3,19,7],[20,3,20,7],[21,3,21,7],[22,3,22,7],[23,3,23,7],[24,3,24,7],[25,3,25,7],[3,18,4,18],[3,19,4,19],[3,15,4,15],[3,12,5,12],[14,3,14,7],[6,3,6,7],[7,3,7,7],[8,3,8,7],[3,13,4,13],[9,3,9,7],[10,3,10,7],[11,3,11,7],[12,3,12,7],[13,3,13,7],[3,14,4,14],[3,16,5,16],[3,17,4,17],[0,12,1,12],[0,16,1,16],[2,1,5,1],[2,2,5,2],[2,3,5,7],[2,8,5,8],[2,9,4,11],[0,9,1,11],[0,13,1,15],[0,17,1,19],[0,1,1,2],[0,3,1,4],[0,5,1,5],[0,6,1,6],[0,7,1,8]]}
[null,"ANNÉE SCOLAIRE",null,{"$f":"'FICHE DE RENSEIGNEMENTS'!$E$10","v":0},null,"Page ",2,"TUTEUR  ",null,{"$f":"'FICHE DE RENSEIGNEMENTS'!$E$16","v":0},null,null,"Virement DE\ncoop école","CLASSE 7 : COMPTES DE PRODUITS (Entrées)",null,null,"Virement  A \ncoop école","CLASSE 6 : COMPTES DE CHARGES (Sorties)"]
[]
[null,"N°\nde\nPJ","Date","LIBELLE\n\nNature de la pièce comptable",null,null,null,null,"A ventiler\ndans le compte N°","530  CAISSE",null,null,"R",707,708,77,"V",607,618,67]
[null,null,null,null,null,null,null,null,null,null,null,null,"Sommes reçues\nDE\nla coop école","Cessions\nde produits","Produits\ndes activités\néducatives","Produits\nexceptionnels","Sommes versées\nA\nla coop école","Achats\nde produits\npour cession","Charges\ndes activités\néducatives","Charges\nexceptionnelles"]
[]
[null,null,null,null,null,null,null,null,null,"ENTRÉES","SORTIES","SITUATION",null,"Mat. Scolaire\ncalendriers ...","Recettes tirées des actions éducatives","Dons,\nsolidarité",null,"Mat. Scolaire\ncalendriers,,,","Toutes dépenses liées aux actions éducatives","Évènement\n imprévu, solidarité"]
["01",null,null,null,null,null,null,null,null,{"$f":"'Page 1'!J32","v":0},{"$f":"'Page 1'!K32","v":0},{"$f":"'Page 1'!L32","v":0},{"$f":"'Page 1'!M32","v":0},{"$f":"'Page 1'!N32","v":0},{"$f":"'Page 1'!O32","v":0},{"$f":"'Page 1'!P32","v":0},{"$f":"'Page 1'!Q32","v":0},{"$f":"'Page 1'!R32","v":0},{"$f":"'Page 1'!S32","v":0},{"$f":"'Page 1'!T32","v":0},null,null,null,null,null,"R"]
["02",null,null,null,null,null,null,null,null,null,null,{"$f":"(L7+J8)-K8","v":0},{"$f":"IF((I8=M$3),J8,\"\")","v":""},{"$f":"IF(($I8=N$3),J8,\"\")","v":""},{"$f":"IF(($I8=O$3),J8,\"\")","v":""},{"$f":"IF(($I8=P$3),J8,\"\")","v":""},{"$f":"IF((I8=Q$3),K8,\"\")","v":""},{"$f":"IF(($I8=R$3),K8,\"\")","v":""},{"$f":"IF(($I8=S$3),K8,\"\")","v":""},{"$f":"IF(($I8=T$3),K8,\"\")","v":""},null,null,null,null,null,"V"]
["03",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","",null,null,null,null,null,707]
["04",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","",null,null,null,null,null,607]
["05",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","",null,null,null,null,null,708]
["06",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","",null,null,null,null,null,618]
["07",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","",null,null,null,null,null,77]
["08",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","",null,null,null,null,null,67]
["09",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["10",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["11",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["12",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["13",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["14",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["15",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["16",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["17",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["18",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["19",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["20",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["21",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["22",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["23",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["24",null,null,null,null,null,null,null,null,null,null,{"$f":"(L29+J30)-K30","v":0},"","","","","","","",""]
["25",null,null,null,null,null,null,null,null,null,null,{"$f":"(L30+J31)-K31","v":0},"","","","","","","",""]
[null,"REPORT",null,null,null,null,null,null,null,{"$f":"SUM(J7:J31)","v":0},{"$f":"SUM(K7:K31)","v":0},{"$f":"L31","v":0},{"$f":"SUM(M7:M31)","v":0},{"$f":"SUM(N7:N31)","v":0},0,0,0,0,0,0]

{"sheet":"Page 3","index":3,"n_rows":32,"n_cols":26,"rows_kept":32,"cut":false,"hidden":false,"merged":[[27,3,27,7],[28,3,28,7],[29,3,29,7],[30,3,30,7],[31,1,31,8],[26,3,26,7],[15,3,15,7],[16,3,16,7],[17,3,17,7],[18,3,18,7],[19,3,19,7],[20,3,20,7],[21,3,21,7],[22,3,22,7],[23,3,23,7],[24,3,24,7],[25,3,25,7],[3,18,4,18],[3,19,4,19],[3,15,4,15],[3,12,5,12],[14,3,14,7],[6,3,6,7],[7,3,7,7],[8,3,8,7],[3,13,4,13],[9,3,9,7],[10,3,10,7],[11,3,11,7],[12,3,12,7],[13,3,13,7],[3,14,4,14],[3,16,5,16],[3,17,4,17],[0,12,1,12],[0,16,1,16],[2,1,5,1],[2,2,5,2],[2,3,5,7],[2,8,5,8],[2,9,4,11],[0,9,1,11],[0,13,1,15],[0,17,1,19],[0,1,1,2],[0,3,1,4],[0,5,1,5],[0,6,1,6],[0,7,1,8]]}
[null,"ANNÉE SCOLAIRE",null,{"$f":"'FICHE DE RENSEIGNEMENTS'!$E$10","v":0},null,"Page ",3,"TUTEUR  ",null,{"$f":"'FICHE DE RENSEIGNEMENTS'!$E$16","v":0},null,null,"Virement DE\ncoop école","CLASSE 7 : COMPTES DE PRODUITS (Entrées)",null,null,"Virement  A \ncoop école","CLASSE 6 : COMPTES DE CHARGES (Sorties)"]
[]
[null,"N°\nde\nPJ","Date","LIBELLE\n\nNature de la pièce comptable",null,null,null,null,"A ventiler\ndans le compte N°","530  CAISSE",null,null,"R",707,708,77,"V",607,618,67]
[null,null,null,null,null,null,null,null,null,null,null,null,"Sommes reçues\nDE\nla coop école","Cessions\nde produits","Produits\ndes activités\néducatives","Produits\nexceptionnels","Sommes versées\nA\nla coop école","Achats\nde produits\npour cession","Charges\ndes activités\néducatives","Charges\nexceptionnelles"]
[]
[null,null,null,null,null,null,null,null,null,"ENTRÉES","SORTIES","SITUATION",null,"Mat. Scolaire\ncalendriers ...","Recettes tirées des actions éducatives","Dons,\nsolidarité",null,"Mat. Scolaire\ncalendriers,,,","Toutes dépenses liées aux actions éducatives","Évènement\n imprévu, solidarité"]
["01",null,null,null,null,null,null,null,null,{"$f":"'Page 2'!J32","v":0},{"$f":"'Page 2'!K32","v":0},{"$f":"'Page 2'!L32","v":0},{"$f":"'Page 2'!M32","v":0},{"$f":"'Page 2'!N32","v":0},{"$f":"'Page 2'!O32","v":0},{"$f":"'Page 2'!P32","v":0},{"$f":"'Page 2'!Q32","v":0},{"$f":"'Page 2'!R32","v":0},{"$f":"'Page 2'!S32","v":0},{"$f":"'Page 2'!T32","v":0},null,null,null,null,null,"R"]
["02",null,null,null,null,null,null,null,null,null,null,{"$f":"(L7+J8)-K8","v":0},{"$f":"IF((I8=M$3),J8,\"\")","v":""},{"$f":"IF(($I8=N$3),J8,\"\")","v":""},{"$f":"IF(($I8=O$3),J8,\"\")","v":""},{"$f":"IF(($I8=P$3),J8,\"\")","v":""},{"$f":"IF((I8=Q$3),K8,\"\")","v":""},{"$f":"IF(($I8=R$3),K8,\"\")","v":""},{"$f":"IF(($I8=S$3),K8,\"\")","v":""},{"$f":"IF(($I8=T$3),K8,\"\")","v":""},null,null,null,null,null,"V"]
["03",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","",null,null,null,null,null,707]
["04",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","",null,null,null,null,null,607]
["05",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","",null,null,null,null,null,708]
["06",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","",null,null,null,null,null,618]
["07",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","",null,null,null,null,null,77]
["08",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","",null,null,null,null,null,67]
["09",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["10",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["11",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["12",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["13",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["14",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["15",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["16",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["17",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["18",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["19",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["20",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["21",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["22",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["23",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["24",null,null,null,null,null,null,null,null,null,null,{"$f":"(L29+J30)-K30","v":0},"","","","","","","",""]
["25",null,null,null,null,null,null,null,null,null,null,{"$f":"(L30+J31)-K31","v":0},"","","","","","","",""]
[null,"REPORT",null,null,null,null,null,null,null,{"$f":"SUM(J7:J31)","v":0},{"$f":"SUM(K7:K31)","v":0},{"$f":"L31","v":0},{"$f":"SUM(M7:M31)","v":0},0,0,0,0,0,0,0]

{"sheet":"Page 4","index":4,"n_rows":32,"n_cols":26,"rows_kept":32,"cut":false,"hidden":false,"merged":[[27,3,27,7],[28,3,28,7],[29,3,29,7],[30,3,30,7],[31,1,31,8],[26,3,26,7],[15,3,15,7],[16,3,16,7],[17,3,17,7],[18,3,18,7],[19,3,19,7],[20,3,20,7],[21,3,21,7],[22,3,22,7],[23,3,23,7],[24,3,24,7],[25,3,25,7],[3,18,4,18],[3,19,4,19],[3,15,4,15],[3,12,5,12],[14,3,14,7],[6,3,6,7],[7,3,7,7],[8,3,8,7],[3,13,4,13],[9,3,9,7],[10,3,10,7],[11,3,11,7],[12,3,12,7],[13,3,13,7],[3,14,4,14],[3,16,5,16],[3,17,4,17],[0,12,1,12],[0,16,1,16],[2,1,5,1],[2,2,5,2],[2,3,5,7],[2,8,5,8],[2,9,4,11],[0,9,1,11],[0,13,1,15],[0,17,1,19],[0,1,1,2],[0,3,1,4],[0,5,1,5],[0,6,1,6],[0,7,1,8]]}
[null,"ANNÉE SCOLAIRE",null,{"$f":"'FICHE DE RENSEIGNEMENTS'!$E$10","v":0},null,"Page ",4,"TUTEUR  ",null,{"$f":"'FICHE DE RENSEIGNEMENTS'!$E$16","v":0},null,null,"Virement DE\ncoop école","CLASSE 7 : COMPTES DE PRODUITS (Entrées)",null,null,"Virement  A \ncoop école","CLASSE 6 : COMPTES DE CHARGES (Sorties)"]
[]
[null,"N°\nde\nPJ","Date","LIBELLE\n\nNature de la pièce comptable",null,null,null,null,"A ventiler\ndans le compte N°","530  CAISSE",null,null,"R",707,708,77,"V",607,618,67]
[null,null,null,null,null,null,null,null,null,null,null,null,"Sommes reçues\nDE\nla coop école","Cessions\nde produits","Produits\ndes activités\néducatives","Produits\nexceptionnels","Sommes versées\nA\nla coop école","Achats\nde produits\npour cession","Charges\ndes activités\néducatives","Charges\nexceptionnelles"]
[]
[null,null,null,null,null,null,null,null,null,"ENTRÉES","SORTIES","SITUATION",null,"Mat. Scolaire\ncalendriers ...","Recettes tirées des actions éducatives","Dons,\nsolidarité",null,"Mat. Scolaire\ncalendriers,,,","Toutes dépenses liées aux actions éducatives","Évènement\n imprévu, solidarité"]
["01",null,null,null,null,null,null,null,null,{"$f":"'Page 3'!J32","v":0},{"$f":"'Page 3'!K32","v":0},{"$f":"'Page 3'!L32","v":0},{"$f":"'Page 3'!M32","v":0},{"$f":"'Page 3'!N32","v":0},{"$f":"'Page 3'!O32","v":0},{"$f":"'Page 3'!P32","v":0},{"$f":"'Page 3'!Q32","v":0},{"$f":"'Page 3'!R32","v":0},{"$f":"'Page 3'!S32","v":0},{"$f":"'Page 3'!T32","v":0},null,null,null,null,null,"R"]
["02",null,null,null,null,null,null,null,null,null,null,{"$f":"(L7+J8)-K8","v":0},{"$f":"IF((I8=M$3),J8,\"\")","v":""},{"$f":"IF(($I8=N$3),J8,\"\")","v":""},{"$f":"IF(($I8=O$3),J8,\"\")","v":""},{"$f":"IF(($I8=P$3),J8,\"\")","v":""},{"$f":"IF((I8=Q$3),K8,\"\")","v":""},{"$f":"IF(($I8=R$3),K8,\"\")","v":""},{"$f":"IF(($I8=S$3),K8,\"\")","v":""},{"$f":"IF(($I8=T$3),K8,\"\")","v":""},null,null,null,null,null,"V"]
["03",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","",null,null,null,null,null,707]
["04",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","",null,null,null,null,null,607]
["05",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","",null,null,null,null,null,708]
["06",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","",null,null,null,null,null,618]
["07",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","",null,null,null,null,null,77]
["08",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","",null,null,null,null,null,67]
["09",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["10",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["11",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["12",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["13",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["14",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["15",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["16",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["17",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["18",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["19",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["20",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["21",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["22",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["23",null,null,null,null,null,null,null,null,null,null,0,"","","","","","","",""]
["24",null,null,null,null,null,null,null,null,null,null,{"$f":"(L29+J30)-K30","v":0},"","","","","","","",""]
["25",null,null,null,null,null,null,null,null,null,null,{"$f":"(L30+J31)-K31","v":0},"","","","","","","",""]
[null,"REPORT",null,null,null,null,null,null,null,{"$f":"SUM(J7:J31)","v":0},{"$f":"SUM(K7:K31)","v":0},{"$f":"L31","v":0},{"$f":"SUM(M7:M31)","v":0},0,0,0,0,0,0,0]

{"sheet":"COMPTE DE FONCTIONNEMENT","index":5,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[[27,2,27,3],[27,8,27,9],[29,11,34,15],[30,4,30,10],[33,1,33,3],[33,4,33,6],[33,7,33,9],[11,0,11,10],[12,0,13,10],[23,1,23,3],[23,7,23,9],[25,0,25,3],[25,6,25,9],[1,2,1,9],[3,2,3,3],[3,4,3,5],[5,3,5,9],[7,2,7,6],[7,7,7,9],[3,7,3,8]]}
[]
[null,"ÉCOLE",{"$f":"'FICHE DE RENSEIGNEMENTS'!$B$6","v":0}]
[]
[null,"CLASSE",{"$f":"'FICHE DE RENSEIGNEMENTS'!$D$12","v":0},null,"Effectif",null,null,{"$f":"'FICHE DE RENSEIGNEMENTS'!$D$14","v":0}]
[]
[null,"TUTEUR.TRICE",null,{"$f":"'FICHE DE RENSEIGNEMENTS'!$E$16","v":0}]
[]
[null,null,"ANNEE SCOLAIRE",null,null,null,null,{"$f":"'FICHE DE RENSEIGNEMENTS'!$E$10","v":0}]
[]
[]
[]
["COMPTES DE FONCTIONNEMENT GÉNÉRAL"]
["DU 01 SEPTEMBRE AU 31 AOÛT"]
[]
[]
[]
[]
[607,"Achats de produits pour cession",null,null,{"$f":"'Page 4'!$R$32","v":0},null,707,"Vente de produits pour cession",null,null,{"$f":"'Page 4'!$N$32","v":0}]
[]
[618,"Charges des activités éducatives",null,null,{"$f":"'Page 4'!$S$32","v":0},null,708,"Produits des activités éducatives",null,null,{"$f":"'Page 4'!$O$32","v":0}]
[]
[67,"Charges exceptionnelles",null,null,{"$f":"'Page 4'!$T$32","v":0},null,77,"Produits exceptionnels",null,null,{"$f":"'Page 4'!$P$32","v":0}]
[]
[null,"Total des charges",null,null,{"$f":"SUM(E18:E22)","v":0},null,null,"Total des produits",null,null,{"$f":"SUM(K18:K22)","v":0}]
[]
["Sommes versées à la coop école",null,null,null,{"$f":"'Page 4'!$Q$32","v":0},null,"Sommes reçues de la coop école",null,null,null,{"$f":"'Page 4'!$M$32","v":0}]
[]
[null,null,"TOTAL 1",null,{"$f":"SUM(E24,E26)","v":0},null,null,null,"TOTAL 2",null,{"$f":"SUM(K24,K26)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E28<>K28,\"\n● Avez-vous reversé le reliquat à la coop. École ?\n● Tous les montants ont-ils été ventilés ?\n         - dans un compte 6.. pour une dépense ;\n         - dans un compte 7.. pour une recette.\n● N'y a-t-il pas eu confusion entre R et V ?\",\"\")","v":""}]
[null,null,null,null,{"$f":"IF(E28<>K28,\"ERREUR ! TOTAL 1 doit être égal à TOTAL 2\",\"\")","v":""}]
[]
[]
[null,"   Le tuteur",null,null,"Le trésorier élève",null,null,"   Le président élève"]