{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Sommaire","Revenus","Dépenses","Mouvements_de_caisse","Sommaire mensuel","References"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":24,"comments":5,"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":"Instructions","index":0,"n_rows":48,"n_cols":5,"rows_kept":48,"cut":false,"hidden":false,"merged":[[42,1,42,6],[32,1,32,6],[30,1,30,6],[31,1,31,6],[36,1,36,6],[37,1,37,6],[38,1,38,6],[41,1,41,6],[11,2,11,5],[48,1,48,6],[47,1,47,6],[23,1,23,6],[24,1,24,6],[25,1,25,6],[27,1,27,6],[43,1,43,6],[45,1,45,6],[46,1,46,6],[44,1,44,6],[33,1,33,6],[34,1,34,6],[35,1,35,6],[28,1,28,6],[40,1,40,6],[1,1,1,6],[2,1,2,6],[8,1,8,6],[10,1,10,6],[3,1,3,6],[6,1,6,6],[7,1,7,6],[5,1,5,6]]}
[null,"Version mise-à-jour le 9 janvier 2018"]
[null,"Instructions"]
[" ","Enregistrement d'une copie pour une première année"]
[null,"Avant de débuter, enregistrez une copie du fichier en l'identifiant clairement.\nDans le menu \"Fichier\", sélectionnez \"Enregistrer sous\" et renommez-le pour le distinguer facilement. \nPar exemple :\"Finances de l'association 2016.xlsx\""]
[]
[null,"Entrée des informations de départ"]
[null,"Entrez les informations de départ dans les cases indiquées ci-dessous :"]
[null,"- Identifiez le nom de l'association ;\n- Déterminez le début et la fin de l'année financière ;\n- Indiquez les soldes en banque et dans la petite caisse à la fin de l'année financière précédente.     "]
[null,"Ces informations se reporteront automatiquement aux endroits appropriés dans les différentes feuilles du fichier.\nVous n'aurez à entrer ces informations qu'une seule fois. Quand l'année sera terminée, il vous suffira d'appuyer sur le bouton \"Créer une nouvelle année financière\" pour que vos informations se reportent dans un nouveau fichier (voir les instructions détaillées plus bas)."]
[]
[]
[null,"Nom de votre association","Association des locataires des HLM de Saint-ici"]
[]
[null,"Définir la période de votre année financière : ",{"$f":"IF(AND(C15<>\"\",C16<>\"\"),CONCATENATE(\"1\",\" \",C16,\" \",C15),\"\")","v":""},{"$f":"IF(C14<>\"\",\"au\",\"\")","v":""},{"$f":"IF(AND(C15<>\"\",C16<>\"\"),EDATE(C14,12)-1,\"\")","v":""}]
[null,"Choisir l'année du début de votre année financière"]
[null,"Choisir le premier mois de votre année financière"]
[]
[]
[null,{"$f":" IF(C14<>\"\",References!D15,\"Avoirs\")","v":"Avoirs"}]
[null,"Banque"]
[null,"Petite caisse:"]
[]
[]
[null,"Présentation des différentes feuilles"]
[null,"\"Sommaire\""]
[null,"La feuille \"Sommaire\" vous présente l'état général de vos finances en comptabilisant l'ensemble des transactions effectuées depuis le début de l'année financière. \nL'information est détaillée par postes budgétaires de revenus et de dépenses. \nLa feuille vous présente également un solde à jour de vos avoirs en banque et dans la petite caisse.\nVous pouvez imprimer cette feuille pour informer les membres de votre association de l'évolution des finances tout au long de l'année."]
[]
[null,"\"Sommaire mensuel\""]
[null,"Si vous le jugez utile, la feuille \"Sommaire mensuel\" vous donne les mêmes informations que la feuille \"Sommaire\", mais pour un mois en particulier. Après avoir sélectionné le mois pour lequel vous désirez un sommaire, la feuille vous affichera le solde au début et à la fin du mois et les revenus et dépenses réalisés pour ce même mois.\nLe choix du mois se fait à partir de la liste située dans la case orangée en haut de la page."]
[]
[null,"\"Revenus\" et \"dépenses\""]
[null,"C'est dans les pages \"Revenus\" et \"Dépenses\" que vous entrez les informations correspondant à chacune de vos transactions."]
[null,"- Il faut d'abord entrer la date de la transaction selon le format suivant : année-mois-jours. Par exemple : 2016-01-25 ;\n- Le logiciel associera automatiquement un numéro à votre transaction, vous n'avez rien à inscrire dans cette case ;\n- Inscrivez ensuite une description de la transaction. Exemple : \"café\" ou \"Cotisation annuelle FLHLMQ\" ou \"Vente de liqueurs\" ;  \n- Entrez le montant de la transaction ;\n- Dans le cas d'une dépense, précisez le type de paiement : directement à partir du compte de banque (\"payée par chèque\") ou à partir de la petite caisse (\"payée comptant\") ;\n- Indiquez ensuite à quelle catégorie de dépenses et de revenus correspond la transaction ;\n- Au besoin, ajoutez un commentaire ou une note explicative.     "]
[]
[null,"\"Mouvements de caisse\" et gestion de la Petite caisse"]
[null,"La feuille \"Mouvements de caisse\" vous permet de comptabiliser les dépôts que vous faites à la banque et les remboursements de la petite caisse que vous aurez besoin d'effectuer pour \"renflouer\" celle-ci quand ses fonds seront épuisés. Il est très important d'y inscrire ces opérations, autrement les soldes de la Petite caisse et de la Banque affichés dans les sommaires ne seront pas à jour et ne présenteront pas des montants fidèles à la réalité de vos avoirs."]
[null,"- Il faut d'abord entrer la date de l'opération selon le format suivant : année-mois-jours. Par exemple : 2016-01-25.\n- Le logiciel associera automatiquement un numéro à votre transaction, vous n'avez rien à inscrire dans cette case.\n- Inscrivez ensuite une description de la transaction. Vous devez sélectionner un des choix disponibles, soit \"Dépôt à la banque\" ou \"Remboursement de la Petite caisse\"\n- Entrez le montant du dépôt ou du remboursement.\n- Au besoin, ajoutez un commentaire ou une note explicative.\n"]
[null,"ATTENTION ! Pour une bonne gestion de votre Petite caisse, TOUS vos revenus - mêmes ceux qui sont reçus en argent comptant - devraient être déposés à la banque et ne devraient pas être utilisés pour financer de nouvelles dépenses de la Petite caisse. Si votre Petite caisse ne contient plus suffisamment de fonds pour couvrir les dépenses que vous avez à payer en argent comptant, émettez un chèque à l'ordre de la \"Petite Caisse\" au montant correspondant à la différence entre son montant actuel et le montant maximum que vous vous êtes fixé pour la Petite Caisse (généralement 100 $ ou 150$). Lorsque vous encaisserez ce chèque à la banque, vous pourrez déposer son montant en argent comptant dans la Petite caisse."]
[]
[]
[null,"Adaptation des catégories de revenus et de dépenses"]
[null,"AVERTISSEMENT : Pour que les fonctions présentées ci-dessous fonctionnent, vous devez avoir \"activé les macros\" du fichier. Cette option vous est proposée soit à l'ouverture du fichier, soit, une fois le fichier ouvert, dans un bandeau jaune en haut de la page. Si les macros ne sont pas activées, vous pourrez utiliser normalement le fichier de comptabilité pour enregister vos transactions et consulter votre sommaire, mais vous ne pourrez  apporter les modifications qui vous sont présentées ci-dessous."]
[null,"Si les catégories de revenus et de dépenses prévus dans le fichier de départ (voir dans la feuille \"Sommaire\") ne correspondent pas à celles de votre propre comptabilité, vous pouvez les adapter. Utilisez les boutons suivants pour ajouter ou supprimer des catégories de dépenses ou de revenus."]
[null,"ATTENTION ! Ne changez pas les catégories en cours d'année si vous avez déjà commencé à entrer des transactions, cela risque de fausser les résultats affichés dans les sommaires."]
[]
[]
[null,"Nouvelle année financière"]
[null,"À la fin de l'année financière, cliquez sur le bouton \"Créer une nouvelle année financière\". Un nouveau fichier sera créé et identifié à la nouvelle année. Les soldes de fin d'année précédente (banque et petite caisse) y seront reportés automatiquement. Le fichier est prêt à être utilisé pour entrer les transactions de votre nouvelle année financière.\nATTENTION ! Assurez-vous d'avoir entré toutes vos transactions dans l'année qui vient de se terminer avant d'en créer une nouvelle, autrement les ajouts que vous effecturez dans l'année précédente ne seront pas pris en compte dans les soldes de départ de la nouvelle année. Si malgré tout vous avez à apporter des corrections à l'année précédente, assurez-vous d'aller corriger directement les soldes de départ de la nouvelle année dans les cases appropriées un peu plus haut sur cette page."]

{"sheet":"Sommaire","index":1,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[22,2,22,3],[21,0,22,0],[21,1,22,1],[1,0,1,1],[29,6,29,7]]}
[{"$f":"Instructions!C12","v":"Association des locataires des HLM de Saint-ici"},null,null,null,null,"Année  ",{"$f":"IF(YEAR([0]!PremierMois)<>YEAR([0]!DernierMois),YEAR([0]!PremierMois)&\"-\"&YEAR([0]!DernierMois),YEAR([0]!PremierMois))","v":{"$error":"#VALUE!"}}]
[{"$f":" CONCATENATE(\"Avoirs au 1er\",\" \",EntreeMois,\" \",EntreeAnnee)","v":"Avoirs au 1er  "},null,null,null,"Mouvements de caisse","Entrées \nd'argent","Sorties d'argent","Solde"]
[null,"Banque",{"$f":"Instructions!C20","v":0},null,"Banque",{"$f":"SUMIF(Mouvements_de_caisse!$C:$C,Depot,Mouvements_de_caisse!$D:$D)","v":0},{"$f":"-SUMIF(Dépenses!$E:$E,Cheque,Dépenses!$D:$D)-SUMIF(Mouvements_de_caisse!$C:$C,Remboursement,Mouvements_de_caisse!$D:$D)","v":0},{"$f":"C3+F3+G3","v":0}]
[null,"Petite caisse",{"$f":"Instructions!C21","v":0},null,"Petite caisse",{"$f":"SUMIF(Mouvements_de_caisse!$C:$C,Remboursement,Mouvements_de_caisse!$D:$D)","v":0},{"$f":"-SUMIF(Dépenses!$E:$E,Comptant,Dépenses!$D:$D)","v":0},{"$f":"C4+F4+G4","v":0}]
[null,"Total des avoirs",null,{"$f":"SUM(C3:C5)","v":0},"Total des avoirs à ce jour",null,null,{"$f":"SUM(H3:H4)","v":0}]
["Revenus",null,null,null,"Dépenses"]
[null,"Autres subventions",{"$f":"SUMIF(Revenus!$E:$E,B7,Revenus!$D:$D)","v":0},null,null,"Bazar - Vente de garage",{"$f":"SUMIF(Dépenses!F:F,F7,Dépenses!$D:$D)","v":0}]
[null,"Bazar - Vente de garage",{"$f":"SUMIF(Revenus!$E:$E,B8,Revenus!$D:$D)","v":0},null,null,"Bingo",{"$f":"SUMIF(Dépenses!F:F,F8,Dépenses!$D:$D)","v":0}]
[null,"Bingo",{"$f":"SUMIF(Revenus!$E:$E,B9,Revenus!$D:$D)","v":0},null,null,"Biscuits - Gâteaux et autres",{"$f":"SUMIF(Dépenses!F:F,F9,Dépenses!$D:$D)","v":0}]
[null,"Café et accompagnements",{"$f":"SUMIF(Revenus!$E:$E,B10,Revenus!$D:$D)","v":0},null,null,"Café et accompagnements",{"$f":"SUMIF(Dépenses!F:F,F10,Dépenses!$D:$D)","v":0}]
[null,"Fête des Mères",{"$f":"SUMIF(Revenus!$E:$E,B11,Revenus!$D:$D)","v":0},null,null,"Fête des Mères",{"$f":"SUMIF(Dépenses!F:F,F11,Dépenses!$D:$D)","v":0}]
[null,"Fête des Pères",{"$f":"SUMIF(Revenus!$E:$E,B12,Revenus!$D:$D)","v":0},null,null,"Fête des pères",{"$f":"SUMIF(Dépenses!F:F,F12,Dépenses!$D:$D)","v":0}]
[null,"Halloween",{"$f":"SUMIF(Revenus!$E:$E,B13,Revenus!$D:$D)","v":0},null,null,"FLHLMQ - Membership et congrès",{"$f":"SUMIF(Dépenses!F:F,F13,Dépenses!$D:$D)","v":0}]
[null,"Moitié-Moitié",{"$f":"SUMIF(Revenus!$E:$E,B14,Revenus!$D:$D)","v":0},null,null,"Frais de bureau",{"$f":"SUMIF(Dépenses!F:F,F14,Dépenses!$D:$D)","v":0}]
[null,"Noël",{"$f":"SUMIF(Revenus!$E:$E,B15,Revenus!$D:$D)","v":0},null,null,"Frais de communication - Internet",{"$f":"SUMIF(Dépenses!F:F,F15,Dépenses!$D:$D)","v":0}]
[null,"Soupers mensuels",{"$f":"SUMIF(Revenus!$E:$E,B16,Revenus!$D:$D)","v":0},null,null,"Frais de gardiennage",{"$f":"SUMIF(Dépenses!F:F,F16,Dépenses!$D:$D)","v":0}]
[null,"St-Jean",{"$f":"SUMIF(Revenus!$E:$E,B17,Revenus!$D:$D)","v":0},null,null,"Frais de rencontres",{"$f":"SUMIF(Dépenses!F:F,F17,Dépenses!$D:$D)","v":0}]
[null,"St-Patrick",{"$f":"SUMIF(Revenus!$E:$E,B18,Revenus!$D:$D)","v":0},null,null,"Frais de transport",{"$f":"SUMIF(Dépenses!F:F,F18,Dépenses!$D:$D)","v":0}]
[null,"St-Valentin",{"$f":"SUMIF(Revenus!$E:$E,B19,Revenus!$D:$D)","v":0},null,null,"Halloween",{"$f":"SUMIF(Dépenses!F:F,F19,Dépenses!$D:$D)","v":0}]
[null,"Subvention OMH",{"$f":"SUMIF(Revenus!$E:$E,B20,Revenus!$D:$D)","v":0},null,null,"Jardinage et fleurs",{"$f":"SUMIF(Dépenses!F:F,F20,Dépenses!$D:$D)","v":0}]
[null,"Autres",{"$f":"SUMIF(Revenus!$E:$E,B21,Revenus!$D:$D)","v":0},null,null,"Moitié-Moitié",{"$f":"SUMIF(Dépenses!F:F,F21,Dépenses!$D:$D)","v":0}]
[null,"Total des revenus",null,null,null,"Noël",{"$f":"SUMIF(Dépenses!F:F,F22,Dépenses!$D:$D)","v":0}]
[null,null,{"$f":"SUM($C$7:$C$21)","v":0},null,null,"Photocopies",{"$f":"SUMIF(Dépenses!F:F,F23,Dépenses!$D:$D)","v":0}]
[null,null,null,null,null,"Salle communautaire",{"$f":"SUMIF(Dépenses!F:F,F24,Dépenses!$D:$D)","v":0}]
[null,null,null,null,null,"Soupers mensuels",{"$f":"SUMIF(Dépenses!F:F,F25,Dépenses!$D:$D)","v":0}]
[null,null,null,null,null,"St-Jean",{"$f":"SUMIF(Dépenses!F:F,F26,Dépenses!$D:$D)","v":0}]
[null,null,null,null,null,"St-Patrick",{"$f":"SUMIF(Dépenses!F:F,F27,Dépenses!$D:$D)","v":0}]
[null,null,null,null,null,"St-Valentin",{"$f":"SUMIF(Dépenses!F:F,F28,Dépenses!$D:$D)","v":0}]
[null,null,null,null,null,"Autres",{"$f":"SUMIF(Dépenses!F:F,F29,Dépenses!$D:$D)","v":0}]
[null,null,null,null,null,"Total des dépenses",{"$f":"SUM(G7:G29)","v":0}]

{"sheet":"Revenus","index":2,"n_rows":500,"n_cols":6,"rows_kept":500,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Sommaire!A1","v":"Association des locataires des HLM de Saint-ici"},null,null,{"$f":"Sommaire!$G1","v":{"$error":"#VALUE!"}}]
["Date","No entrée","Description","Montant","Catégorie de revenu","Commentaires / notes"]
[null,{"$f":"IF(A3=\"\",\"\",1)","v":""}]
[null,{"$f":"IF(A4=\"\",\"\",B3+1)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(A68=\"\",\"\",B67+1)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(A132=\"\",\"\",B131+1)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(A196=\"\",\"\",B195+1)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(A260=\"\",\"\",B259+1)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(A324=\"\",\"\",B323+1)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(A388=\"\",\"\",B387+1)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(A452=\"\",\"\",B451+1)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]

{"sheet":"Dépenses","index":3,"n_rows":500,"n_cols":7,"rows_kept":500,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Sommaire!A1","v":"Association des locataires des HLM de Saint-ici"},null,null,{"$f":"Sommaire!$G1","v":{"$error":"#VALUE!"}}]
["Date","No entrée","Description","Montant","Type de paiement\n(Chèque / argent comptant)","Catégorie de dépenses","Commentaires / notes"]
[null,{"$f":"IF(A3=\"\",\"\",1)","v":""}]
[null,{"$f":"IF(A4=\"\",\"\",B3+1)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(A68=\"\",\"\",B67+1)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(A132=\"\",\"\",B131+1)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(A196=\"\",\"\",B195+1)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(A260=\"\",\"\",B259+1)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(A324=\"\",\"\",B323+1)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(A388=\"\",\"\",B387+1)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(A452=\"\",\"\",B451+1)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]

{"sheet":"Mouvements_de_caisse","index":4,"n_rows":500,"n_cols":5,"rows_kept":500,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Sommaire!A1","v":"Association des locataires des HLM de Saint-ici"},null,null,{"$f":"Sommaire!$G1","v":{"$error":"#VALUE!"}}]
["Date","No entrée","Description","Montant","Commentaires / notes"]
[null,{"$f":"IF(A3=\"\",\"\",1)","v":""}]
[null,{"$f":"IF(A4=\"\",\"\",B3+1)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(A68=\"\",\"\",B67+1)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(A132=\"\",\"\",B131+1)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(A196=\"\",\"\",B195+1)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(A260=\"\",\"\",B259+1)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(A324=\"\",\"\",B323+1)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(A388=\"\",\"\",B387+1)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(A452=\"\",\"\",B451+1)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]

{"sheet":"Sommaire mensuel","index":5,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[22,2,22,3],[21,0,22,0],[21,1,22,1],[1,0,1,1]]}
[{"$f":"Instructions!C12","v":"Association des locataires des HLM de Saint-ici"},null,null,null,"Choisir un mois :","2016-03-01"]
[{"$f":"IF(F1<>\"\",F1,\"\")","v":"2016-03-01"},null,null,null,"Mouvements de caisse","Entrées \nd'argent","Sorties d'argent","Solde"]
[null,"Banque",{"$f":"Instructions!C20+SUMIFS(Mouvements_de_caisse!$D:$D,Mouvements_de_caisse!$C:$C,Depot,Mouvements_de_caisse!$A:$A,\"<\"&DebutMoisCourant)-SUMIFS(Dépenses!$D:$D,Dépenses!$E:$E,Cheque,Dépenses!$A:$A,\"<\"&DebutMoisCourant)-SUMIFS(Mouvements_de_caisse!$D:$D,Mouvements_de_caisse!$C:$C,Remboursement,Mouvements_de_caisse!$A:$A,\"<\"&DebutMoisCourant)","v":0},null,"Banque",{"$f":"SUMIFS(Mouvements_de_caisse!$D:$D,Mouvements_de_caisse!$C:$C,Depot,Mouvements_de_caisse!$A:$A,\">=\"&DebutMoisCourant,Mouvements_de_caisse!$A:$A,\"<\"&DebutMoisSuivant)","v":0},{"$f":"-SUMIFS(Dépenses!$D:$D,Dépenses!$E:$E,Cheque,Dépenses!$A:$A,\">=\"&DebutMoisCourant,Dépenses!$A:$A,\"<\"&DebutMoisSuivant)-SUMIFS(Mouvements_de_caisse!$D:$D,Mouvements_de_caisse!$C:$C,Remboursement,Mouvements_de_caisse!$A:$A,\">=\"&DebutMoisCourant,Mouvements_de_caisse!$A:$A,\"<\"&DebutMoisSuivant)","v":0},{"$f":"C3+F3+G3","v":0}]
[null,"Petite caisse",{"$f":"Instructions!C21+SUMIFS(Mouvements_de_caisse!$D:$D,Mouvements_de_caisse!$C:$C,\"Remboursement de la petite caisse\",Mouvements_de_caisse!$A:$A,\"<\"&DebutMoisCourant)-SUMIFS(Dépenses!$D:$D,Dépenses!$E:$E,\"Payée comptant\",Dépenses!$A:$A,\"<\"&DebutMoisCourant)","v":0},null,"Petite caisse",{"$f":"SUMIFS(Mouvements_de_caisse!$D:$D,Mouvements_de_caisse!$C:$C,Remboursement,Mouvements_de_caisse!$A:$A,\">=\"&DebutMoisCourant,Mouvements_de_caisse!$A:$A,\"<\"&DebutMoisSuivant)","v":0},{"$f":"-SUMIFS(Dépenses!$D:$D,Dépenses!$E:$E,Comptant,Dépenses!$A:$A,\">=\"&DebutMoisCourant,Dépenses!$A:$A,\"<\"&DebutMoisSuivant)","v":0},{"$f":"C4+F4+G4","v":0}]
[null,"Total des avoirs",null,{"$f":"SUM(C3:C4)","v":0},"Total des avoirs à ce jour",null,null,{"$f":"SUM(H3:H4)","v":0}]
["Revenus",null,null,null,"Dépenses"]
[null,{"$f":"Sommaire!B7","v":"Autres subventions"},{"$f":"SUMIFS(Revenus!$D:$D,Revenus!$E:$E,B7,Revenus!$A:$A,\">=\"&DebutMoisCourant,Revenus!$A:$A,\"<\"&DebutMoisSuivant)","v":0},null,null,{"$f":"Sommaire!F7","v":"Bazar - Vente de garage"},{"$f":"SUMIFS(Dépenses!$D:$D,Dépenses!$F:$F,F7,Dépenses!$A:$A,\">=\"&DebutMoisCourant,Dépenses!$A:$A,\"<\"&DebutMoisSuivant)","v":0}]
[null,{"$f":"Sommaire!B8","v":"Bazar - Vente de garage"},{"$f":"SUMIFS(Revenus!$D:$D,Revenus!$E:$E,B8,Revenus!$A:$A,\">=\"&DebutMoisCourant,Revenus!$A:$A,\"<\"&DebutMoisSuivant)","v":0},null,null,{"$f":"Sommaire!F8","v":"Bingo"},{"$f":"SUMIFS(Dépenses!$D:$D,Dépenses!$F:$F,F8,Dépenses!$A:$A,\">=\"&DebutMoisCourant,Dépenses!$A:$A,\"<\"&DebutMoisSuivant)","v":0}]
[null,{"$f":"Sommaire!B9","v":"Bingo"},{"$f":"SUMIFS(Revenus!$D:$D,Revenus!$E:$E,B9,Revenus!$A:$A,\">=\"&DebutMoisCourant,Revenus!$A:$A,\"<\"&DebutMoisSuivant)","v":0},null,null,{"$f":"Sommaire!F9","v":"Biscuits - Gâteaux et autres"},{"$f":"SUMIFS(Dépenses!$D:$D,Dépenses!$F:$F,F9,Dépenses!$A:$A,\">=\"&DebutMoisCourant,Dépenses!$A:$A,\"<\"&DebutMoisSuivant)","v":0}]
[null,{"$f":"Sommaire!B10","v":"Café et accompagnements"},{"$f":"SUMIFS(Revenus!$D:$D,Revenus!$E:$E,B10,Revenus!$A:$A,\">=\"&DebutMoisCourant,Revenus!$A:$A,\"<\"&DebutMoisSuivant)","v":0},null,null,{"$f":"Sommaire!F10","v":"Café et accompagnements"},{"$f":"SUMIFS(Dépenses!$D:$D,Dépenses!$F:$F,F10,Dépenses!$A:$A,\">=\"&DebutMoisCourant,Dépenses!$A:$A,\"<\"&DebutMoisSuivant)","v":0}]
[null,{"$f":"Sommaire!B11","v":"Fête des Mères"},{"$f":"SUMIFS(Revenus!$D:$D,Revenus!$E:$E,B11,Revenus!$A:$A,\">=\"&DebutMoisCourant,Revenus!$A:$A,\"<\"&DebutMoisSuivant)","v":0},null,null,{"$f":"Sommaire!F11","v":"Fête des Mères"},{"$f":"SUMIFS(Dépenses!$D:$D,Dépenses!$F:$F,F11,Dépenses!$A:$A,\">=\"&DebutMoisCourant,Dépenses!$A:$A,\"<\"&DebutMoisSuivant)","v":0}]
[null,{"$f":"Sommaire!B12","v":"Fête des Pères"},{"$f":"SUMIFS(Revenus!$D:$D,Revenus!$E:$E,B12,Revenus!$A:$A,\">=\"&DebutMoisCourant,Revenus!$A:$A,\"<\"&DebutMoisSuivant)","v":0},null,null,{"$f":"Sommaire!F12","v":"Fête des pères"},{"$f":"SUMIFS(Dépenses!$D:$D,Dépenses!$F:$F,F12,Dépenses!$A:$A,\">=\"&DebutMoisCourant,Dépenses!$A:$A,\"<\"&DebutMoisSuivant)","v":0}]
[null,{"$f":"Sommaire!B13","v":"Halloween"},{"$f":"SUMIFS(Revenus!$D:$D,Revenus!$E:$E,B13,Revenus!$A:$A,\">=\"&DebutMoisCourant,Revenus!$A:$A,\"<\"&DebutMoisSuivant)","v":0},null,null,{"$f":"Sommaire!F13","v":"FLHLMQ - Membership et congrès"},{"$f":"SUMIFS(Dépenses!$D:$D,Dépenses!$F:$F,F13,Dépenses!$A:$A,\">=\"&DebutMoisCourant,Dépenses!$A:$A,\"<\"&DebutMoisSuivant)","v":0}]
[null,{"$f":"Sommaire!B14","v":"Moitié-Moitié"},{"$f":"SUMIFS(Revenus!$D:$D,Revenus!$E:$E,B14,Revenus!$A:$A,\">=\"&DebutMoisCourant,Revenus!$A:$A,\"<\"&DebutMoisSuivant)","v":0},null,null,{"$f":"Sommaire!F14","v":"Frais de bureau"},{"$f":"SUMIFS(Dépenses!$D:$D,Dépenses!$F:$F,F14,Dépenses!$A:$A,\">=\"&DebutMoisCourant,Dépenses!$A:$A,\"<\"&DebutMoisSuivant)","v":0}]
[null,{"$f":"Sommaire!B15","v":"Noël"},{"$f":"SUMIFS(Revenus!$D:$D,Revenus!$E:$E,B15,Revenus!$A:$A,\">=\"&DebutMoisCourant,Revenus!$A:$A,\"<\"&DebutMoisSuivant)","v":0},null,null,{"$f":"Sommaire!F15","v":"Frais de communication - Internet"},{"$f":"SUMIFS(Dépenses!$D:$D,Dépenses!$F:$F,F15,Dépenses!$A:$A,\">=\"&DebutMoisCourant,Dépenses!$A:$A,\"<\"&DebutMoisSuivant)","v":0}]
[null,{"$f":"Sommaire!B16","v":"Soupers mensuels"},{"$f":"SUMIFS(Revenus!$D:$D,Revenus!$E:$E,B16,Revenus!$A:$A,\">=\"&DebutMoisCourant,Revenus!$A:$A,\"<\"&DebutMoisSuivant)","v":0},null,null,{"$f":"Sommaire!F16","v":"Frais de gardiennage"},{"$f":"SUMIFS(Dépenses!$D:$D,Dépenses!$F:$F,F16,Dépenses!$A:$A,\">=\"&DebutMoisCourant,Dépenses!$A:$A,\"<\"&DebutMoisSuivant)","v":0}]
[null,{"$f":"Sommaire!B17","v":"St-Jean"},{"$f":"SUMIFS(Revenus!$D:$D,Revenus!$E:$E,B17,Revenus!$A:$A,\">=\"&DebutMoisCourant,Revenus!$A:$A,\"<\"&DebutMoisSuivant)","v":0},null,null,{"$f":"Sommaire!F17","v":"Frais de rencontres"},{"$f":"SUMIFS(Dépenses!$D:$D,Dépenses!$F:$F,F17,Dépenses!$A:$A,\">=\"&DebutMoisCourant,Dépenses!$A:$A,\"<\"&DebutMoisSuivant)","v":0}]
[null,{"$f":"Sommaire!B18","v":"St-Patrick"},{"$f":"SUMIFS(Revenus!$D:$D,Revenus!$E:$E,B18,Revenus!$A:$A,\">=\"&DebutMoisCourant,Revenus!$A:$A,\"<\"&DebutMoisSuivant)","v":0},null,null,{"$f":"Sommaire!F18","v":"Frais de transport"},{"$f":"SUMIFS(Dépenses!$D:$D,Dépenses!$F:$F,F18,Dépenses!$A:$A,\">=\"&DebutMoisCourant,Dépenses!$A:$A,\"<\"&DebutMoisSuivant)","v":0}]
[null,{"$f":"Sommaire!B19","v":"St-Valentin"},{"$f":"SUMIFS(Revenus!$D:$D,Revenus!$E:$E,B19,Revenus!$A:$A,\">=\"&DebutMoisCourant,Revenus!$A:$A,\"<\"&DebutMoisSuivant)","v":0},null,null,{"$f":"Sommaire!F19","v":"Halloween"},{"$f":"SUMIFS(Dépenses!$D:$D,Dépenses!$F:$F,F19,Dépenses!$A:$A,\">=\"&DebutMoisCourant,Dépenses!$A:$A,\"<\"&DebutMoisSuivant)","v":0}]
[null,{"$f":"Sommaire!B20","v":"Subvention OMH"},{"$f":"SUMIFS(Revenus!$D:$D,Revenus!$E:$E,B20,Revenus!$A:$A,\">=\"&DebutMoisCourant,Revenus!$A:$A,\"<\"&DebutMoisSuivant)","v":0},null,null,{"$f":"Sommaire!F20","v":"Jardinage et fleurs"},{"$f":"SUMIFS(Dépenses!$D:$D,Dépenses!$F:$F,F20,Dépenses!$A:$A,\">=\"&DebutMoisCourant,Dépenses!$A:$A,\"<\"&DebutMoisSuivant)","v":0}]
[null,{"$f":"Sommaire!B21","v":"Autres"},{"$f":"SUMIFS(Revenus!$D:$D,Revenus!$E:$E,B21,Revenus!$A:$A,\">=\"&DebutMoisCourant,Revenus!$A:$A,\"<\"&DebutMoisSuivant)","v":0},null,null,{"$f":"Sommaire!F21","v":"Moitié-Moitié"},{"$f":"SUMIFS(Dépenses!$D:$D,Dépenses!$F:$F,F21,Dépenses!$A:$A,\">=\"&DebutMoisCourant,Dépenses!$A:$A,\"<\"&DebutMoisSuivant)","v":0}]
[null,"Total des revenus",null,null,null,{"$f":"Sommaire!F22","v":"Noël"},{"$f":"SUMIFS(Dépenses!$D:$D,Dépenses!$F:$F,F22,Dépenses!$A:$A,\">=\"&DebutMoisCourant,Dépenses!$A:$A,\"<\"&DebutMoisSuivant)","v":0}]
[null,null,{"$f":"SUM($C$7:$C$19)","v":0},null,null,{"$f":"Sommaire!F23","v":"Photocopies"},{"$f":"SUMIFS(Dépenses!$D:$D,Dépenses!$F:$F,F23,Dépenses!$A:$A,\">=\"&DebutMoisCourant,Dépenses!$A:$A,\"<\"&DebutMoisSuivant)","v":0}]
[null,null,null,null,null,{"$f":"Sommaire!F24","v":"Salle communautaire"},{"$f":"SUMIFS(Dépenses!$D:$D,Dépenses!$F:$F,F24,Dépenses!$A:$A,\">=\"&DebutMoisCourant,Dépenses!$A:$A,\"<\"&DebutMoisSuivant)","v":0}]
[null,null,null,null,null,{"$f":"Sommaire!F25","v":"Soupers mensuels"},{"$f":"SUMIFS(Dépenses!$D:$D,Dépenses!$F:$F,F25,Dépenses!$A:$A,\">=\"&DebutMoisCourant,Dépenses!$A:$A,\"<\"&DebutMoisSuivant)","v":0}]
[null,null,null,null,null,{"$f":"Sommaire!F26","v":"St-Jean"},{"$f":"SUMIFS(Dépenses!$D:$D,Dépenses!$F:$F,F26,Dépenses!$A:$A,\">=\"&DebutMoisCourant,Dépenses!$A:$A,\"<\"&DebutMoisSuivant)","v":0}]
[null,null,null,null,null,{"$f":"Sommaire!F27","v":"St-Patrick"},{"$f":"SUMIFS(Dépenses!$D:$D,Dépenses!$F:$F,F27,Dépenses!$A:$A,\">=\"&DebutMoisCourant,Dépenses!$A:$A,\"<\"&DebutMoisSuivant)","v":0}]
[null,null,null,null,null,{"$f":"Sommaire!F28","v":"St-Valentin"},{"$f":"SUMIFS(Dépenses!$D:$D,Dépenses!$F:$F,F28,Dépenses!$A:$A,\">=\"&DebutMoisCourant,Dépenses!$A:$A,\"<\"&DebutMoisSuivant)","v":0}]
[null,null,null,null,null,"Total des dépenses",null,{"$f":"SUM(G7:G26)","v":0}]

{"sheet":"References","index":6,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
[]
["MouvementsCaisse"]
["Remboursement de la petite caisse"]
["Dépôt à la banque"]
[]
["TypesPaiement"]
["Payée par chèque"]
["Payée comptant"]
[]
["Repères pour sommaire mensuel"]
[{"$f":"DATE(YEAR(MoisSommaireMensuel),MONTH(MoisSommaireMensuel),1)","v":"2016-03-01"}]
[{"$f":"EDATE(DebutMoisCourant,1)","v":"2016-04-01"}]
[]
["Mois","Index","Années","MoisEtAnnée"]
["janvier",1,2016,{"$f":"DATEVALUE(Instructions!C14)","v":{"$error":"#VALUE!"}}]
["février",2,2017,{"$f":"EDATE(D15,1)","v":{"$error":"#VALUE!"}}]
["mars",3,2018,{"$error":"#VALUE!"}]
["avril",4,2019,{"$error":"#VALUE!"}]
["mai",5,2020,{"$error":"#VALUE!"}]
["juin",6,2021,{"$error":"#VALUE!"}]
["juillet",7,2022,{"$error":"#VALUE!"}]
["août",8,2023,{"$error":"#VALUE!"}]
["septembre",9,2024,{"$error":"#VALUE!"}]
["octobre",10,2025,{"$error":"#VALUE!"}]
["novembre",11,2026,{"$error":"#VALUE!"}]
["décembre",12,2027,{"$error":"#VALUE!"}]
[null,null,null,{"$error":"#VALUE!"}]
[null,null,null,{"$f":"D27-1","v":{"$error":"#VALUE!"}}]