{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["consignes","Renseignements","Menu","saisie ","Point","GrilleDesComptes","comptes","Banque","Caisse","LivretEpargne","Compte-Résultat","Bilan-Financier"],"not_rendered":{"images":12,"macros":1,"defined_names":23},"read":"whole","date_system":"1900"}

{"sheet":"consignes","index":0,"n_rows":25,"n_cols":5,"rows_kept":25,"hidden":true,"merged":[[2,1,3,6],[5,1,6,6],[7,1,8,6],[10,1,11,6],[12,1,13,6],[14,1,14,6],[15,1,16,6],[17,1,18,6],[19,1,19,6],[20,1,20,6]]}
[]
[]
[null,"* Cet outil permet de gérer une comptabilité d'AS comprenant un compte courant , un livret d'épargne et une caisse "]
[]
[null,"* Le compte de résultats et le bilan annuel se font automatiquement"]
[null,"* Une vérification en fonction des relevés bancaires (opération appelée \"rapprochement bancaire\" ) est proposée: \n    Lorsqu'une opération a été prise en compte par la banque,  inscrivez le numéro du relevé  dans la dernière colonne de droite (\"pointage\") . Inscrivez ensuite le solde indiqué par le relevé dans la case jaune de la feuille \"point\". Un message vous indique si vous êtes en accord avec la banque  ou la somme que vous devez rechercher . "]
[]
[null,"* Le point sur le résultat provisoire de l'exercice en cours et sur l 'état de trésorerie  est aussi disponible "]
[]
[null,"Particularités importantes: "]
[null,"- La gestion du livret se fait obligatoirement  par prélèvement ou virement sur le compte courant ( c' est automatique si vous passez par la feuille de saisie ). Entrez aussi les intérêts sur le compte courant puis vers le livret DEPUIS LA FEUILLE SAISIE"]
[]
[null,"- La gestion de la caisse est séparée . Vous avez obligation de partir et d'arriver  à un solde nul ( faire un versement sur le compte courant en fin d'exercice )"]
[]
[null,"- Les boutons de navigations  ne sont pas imprimés"]
[null,"- Pour entrer des données depuis la feuille saisie , validez votre montant avec la touche entrée et appuyez sur l'étoile verte de droite "]
[]
[null,"- La rentrée des données depuis la feuille de saisie se fait par insertion automatique de lignes ( vous avez donc les dernières opérations en haut )\nIl est fortement déconseillé de  déprotéger   pour  supprimer des lignes "]
[]
[null,"-  Vous serez peut-être amenés à régler le facteur de zoom de  certaines pages pour plus de confort"]
[null,"- AVANT DE SAISIR LA PREMIERE OPERATION . Faire une copie de ce document (enregistrer sous un autre nom ,  exemple : \"COMPTA  AS FRANGY 05/06\") . Il vous sera alors plus facile d'archiver ou (et) de retrouver un document vierge ( la suppression de lignes demande une déprotection de feuille plutôt déconseillée) "]
[{"$nulls":4},"Bonne compta "]
[]
[null,"plus d'infos : UNSS 74 ou rene.mossaz@wanadoo.fr"]
[null,"Version: 12/10/2013"]

{"sheet":"Renseignements","index":1,"n_rows":15,"n_cols":3,"rows_kept":15,"hidden":true}
[]
[null,"Coordonnées obligatoires."]
[]
[null,"Nom de l'établissement :","College X"]
[null,"Boite postal :","???"]
[null,"Adresse :","adresseX"]
[null,"Code Postal","74- - - "]
[null,"Ville :","VilleX"]
[null,"Nom de la banque :","Banque Y"]
[null,"N° compte bancaire","n° xxxxxxxxxxxxxxx"]
[null,"Année scolaire :","200. / 200."]
[null,"Date pour le bilan :","date x"]
[null,"Nom du président d'AS :","Mr X"]
[null,"Solde compte-chèque année antérieure"]
[null,"Solde épargne sur livret année antérieure"]

{"sheet":"Menu","index":2,"n_rows":58,"n_cols":1,"rows_kept":58,"merged":[[2,4,2,5],[2,6,2,7],[16,6,22,7],[32,1,32,3]]}
{"$rows_empty":57}
[" "]

{"sheet":"saisie ","index":3,"n_rows":29,"n_cols":13,"rows_kept":29,"hidden":true,"merged":[[2,12,9,12],[9,8,9,9],[22,8,22,9],[28,8,28,9],[35,6,41,7]]}
[{"$nulls":3},"* SAISIR SUR LE COMPTE COURANT ",{"$nulls":4},{"$f":"IF(AND(F6>=700,I6>0),\"ERREUR il faut un crédit\",\"\")","v":""},{"$f":"IF(AND(F6<700,J6>0),IF(F6>0,\"ERREUR il faut un débit\",\"\"),\"\")","v":""}]
[{"$nulls":8},{"$f":"IF(F6>0,IF(F6<700,\"⇓⇓⇓⇓\",\"\"),\"\")","v":"⇓⇓⇓⇓"},{"$f":"IF(F6>0,IF(F6>=700,\"⇓⇓⇓⇓\",\"\"),\"\")","v":""}]
[null,null,"date","N°de Pièce","Ref Bancaire","N°de compte","Libellé","Destinataire , Provenance , Objet","débit","crédit",null,null,{"$f":"IF(F6=0,\"ERREUR N° de compte non saisi\",\"\")","v":""}]
[]
[]
[null,null,{"$f":"TODAY()","v":"2014-01-21"},null,null,{"$f":"INDEX(comptes!B2:B37,LOOKUP(comptes!C1,comptes!A2:A37))","v":678}]
[{"$nulls":8},"…..€","…..€"]
[]
[]
[{"$nulls":8},{"$f":"IF(AND(ISNUMBER(I6),ISNUMBER(J6)),\"Une seule entrée svp !\",\"\")","v":""}]
[]
[]
[{"$nulls":3},"* FAIRE UN VIREMENT ENTRE LE COMPTE COURANT ET LE LIVRET "]
[]
[]
[]
[]
[]
[]
[null,null,"date","N°de Pièce","Type de paiement","N°de compte","Libellé","Destinataire , Provenance , Objet"," vers le livret","vers le compte courant"]
[null,null,{"$f":"TODAY()","v":"2014-01-21"},null,"Virement",511,null,"Livret"]
[{"$nulls":8},"…..€","…..€"]
[{"$nulls":8},{"$f":"IF(AND(ISNUMBER(I21),ISNUMBER(J21)),\"Une seule entrée svp !\",\"\")","v":""}]
[{"$nulls":3},"* GERER LA CAISSE"]
[]
[null,null,"date","N°de Pièce","Type de paiement","N°de compte","Libellé","Destinataire , Provenance , Objet","sortie","entrée"]
[null,null,{"$f":"TODAY()","v":"2014-01-21"},null,"Liquide",530]
[{"$nulls":8},"…..€","…..€"]
[{"$nulls":8},{"$f":"IF(AND(ISNUMBER(I27),ISNUMBER(J27)),\"Une seule entrée svp !\",\"\")","v":""}]

{"sheet":"Point","index":4,"n_rows":11,"n_cols":4,"rows_kept":11,"hidden":true,"merged":[[5,3,5,4]]}
[null,"Situation au",{"$f":"TODAY()","v":"2014-01-21"}]
[null,"Solde du compte courant  donné par l'ordinateur ",{"$f":"Banque!D16","v":{"v":0,"d":"0.00 €"}}]
[null,"Solde des opérations pointées",{"$f":"ROUND(Banque!J6+Banque!M37-Banque!L37,2)","v":{"v":0,"d":"0.00 €"}}]
[null,"Inscrire dans la case jaune le solde  du compte courant donné par le relevé bancaire ",{"v":0,"d":"0.00 €"}]
[null,null,{"$f":"IF(C3-C4=0,\"BRAVO !\",\"\")","v":"BRAVO !"}]
[null,null,{"$f":"IF(C4-C3=0,\"\",\"ERREUR ! la différence à rechercher est de :\")","v":""},{"$f":"IF(C3-C4=0,\"\",ABS(C3-C4))","v":""}]
[]
[null,"Solde de la caisse ",{"$f":"Caisse!H3","v":{"v":0,"d":"0.00 €"}}]
[null,"Solde du livret épargne ",{"$f":"LivretEpargne!H4","v":{"v":0,"d":"0.00 €"}}]
[null,"Trésorerie disponible",{"$f":"C2+C8+C9","v":{"v":0,"d":"0.00 €"}}]
[null,"Résultat provisoire de l'exercice en cours ",{"$f":"'Compte-Résultat'!F46-'Compte-Résultat'!J46","v":{"v":0,"d":"0.00 €"}}]

{"sheet":"GrilleDesComptes","index":5,"n_rows":23,"n_cols":35,"rows_kept":23,"hidden":true}
[]
[{"$nulls":3},606,607,613,615,616,618,622,623,624,625,626,627,651,657,658,671,678,null,null,741,744,746,747,748,756,758,763,771,778]
[{"$nulls":3},"Fournitures administratives","Matériel et gros équipement","Location salle ou matériel","Entretien et réparation matériel","Assurance","Documentations brochures","Prestations de service Honoraires","Récompenses Cadeaux","Transport collectif des élèves","Déplacement animateurs,  réceptions","Frais postaux et télécommunication","Frais bancaires","Sacem","Subvention versée par l'AS","Licences UNSS  Affiliation","Charges sur Tombola , calendriers","Autres charges exceptionnelles",null,null,"Collectivités territoriales","CNDS","UNSS DN SR SD74 District , crédits animation","Etablissement scolaire","Dons divers","Cotisations élèves, licences ","Participations élèves aux sorties ou activités ","Intérêts livret","Ventes tombola , calendriers…","Autres produits exceptionnels"]
[]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(Banque!$E19=D$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=E$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=F$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=G$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=H$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=I$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=J$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=K$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=L$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=M$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=N$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=O$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=P$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=Q$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=R$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=S$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=T$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=U$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=V$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=W$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=X$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=Y$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=Z$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=AA$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=AB$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=AC$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=AD$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=AE$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=AF$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=AG$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=AH$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E19=AI$2,Banque!$I19+Banque!$H19,0)","v":{"v":0,"d":"0.00"}}]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(Banque!$E20=D$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=E$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=F$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=G$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=H$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=I$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=J$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=K$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=L$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=M$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=N$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=O$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=P$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=Q$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=R$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=S$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=T$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=U$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=V$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=W$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=X$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=Y$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=Z$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=AA$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=AB$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=AC$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=AD$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=AE$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=AF$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=AG$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=AH$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E20=AI$2,Banque!$I20+Banque!$H20,0)","v":{"v":0,"d":"0.00"}}]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(Banque!$E21=D$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=E$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=F$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=G$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=H$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=I$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=J$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=K$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=L$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=M$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=N$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=O$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=P$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=Q$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=R$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=S$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=T$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=U$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=V$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=W$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=X$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=Y$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=Z$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=AA$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=AB$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=AC$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=AD$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=AE$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=AF$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=AG$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=AH$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E21=AI$2,Banque!$I21+Banque!$H21,0)","v":{"v":0,"d":"0.00"}}]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(Banque!$E22=D$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=E$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=F$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=G$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=H$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=I$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=J$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=K$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=L$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=M$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=N$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=O$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=P$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=Q$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=R$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=S$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=T$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=U$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=V$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=W$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=X$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=Y$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=Z$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=AA$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=AB$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=AC$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=AD$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=AE$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=AF$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=AG$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=AH$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E22=AI$2,Banque!$I22+Banque!$H22,0)","v":{"v":0,"d":"0.00"}}]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(Banque!$E23=D$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=E$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=F$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=G$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=H$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=I$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=J$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=K$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=L$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=M$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=N$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=O$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=P$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=Q$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=R$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=S$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=T$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=U$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=V$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=W$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=X$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=Y$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=Z$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=AA$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=AB$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=AC$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=AD$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=AE$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=AF$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=AG$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=AH$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E23=AI$2,Banque!$I23+Banque!$H23,0)","v":{"v":0,"d":"0.00"}}]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(Banque!$E24=D$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=E$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=F$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=G$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=H$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=I$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=J$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=K$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=L$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=M$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=N$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=O$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=P$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=Q$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=R$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=S$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=T$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=U$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=V$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=W$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=X$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=Y$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=Z$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=AA$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=AB$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=AC$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=AD$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=AE$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=AF$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=AG$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=AH$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E24=AI$2,Banque!$I24+Banque!$H24,0)","v":{"v":0,"d":"0.00"}}]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(Banque!$E25=D$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=E$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=F$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=G$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=H$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=I$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=J$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=K$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=L$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=M$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=N$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=O$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=P$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=Q$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=R$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=S$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=T$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=U$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=V$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=W$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=X$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=Y$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=Z$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=AA$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=AB$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=AC$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=AD$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=AE$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=AF$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=AG$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=AH$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E25=AI$2,Banque!$I25+Banque!$H25,0)","v":{"v":0,"d":"0.00"}}]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(Banque!$E26=D$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=E$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=F$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=G$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=H$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=I$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=J$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=K$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=L$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=M$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=N$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=O$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=P$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=Q$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=R$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=S$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=T$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=U$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=V$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=W$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=X$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=Y$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=Z$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=AA$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=AB$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=AC$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=AD$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=AE$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=AF$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=AG$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=AH$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E26=AI$2,Banque!$I26+Banque!$H26,0)","v":{"v":0,"d":"0.00"}}]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(Banque!$E27=D$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=E$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=F$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=G$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=H$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=I$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=J$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=K$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=L$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=M$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=N$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=O$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=P$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=Q$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=R$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=S$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=T$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=U$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=V$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=W$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=X$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=Y$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=Z$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=AA$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=AB$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=AC$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=AD$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=AE$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=AF$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=AG$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=AH$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E27=AI$2,Banque!$I27+Banque!$H27,0)","v":{"v":0,"d":"0.00"}}]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(Banque!$E28=D$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=E$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=F$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=G$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=H$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=I$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=J$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=K$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=L$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=M$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=N$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=O$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=P$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=Q$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=R$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=S$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=T$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=U$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=V$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=W$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=X$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=Y$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=Z$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=AA$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=AB$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=AC$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=AD$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=AE$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=AF$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=AG$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=AH$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E28=AI$2,Banque!$I28+Banque!$H28,0)","v":{"v":0,"d":"0.00"}}]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(Banque!$E29=D$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=E$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=F$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=G$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=H$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=I$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=J$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=K$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=L$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=M$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=N$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=O$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=P$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=Q$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=R$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=S$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=T$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=U$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=V$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=W$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=X$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=Y$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=Z$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=AA$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=AB$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=AC$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=AD$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=AE$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=AF$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=AG$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=AH$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E29=AI$2,Banque!$I29+Banque!$H29,0)","v":{"v":0,"d":"0.00"}}]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(Banque!$E30=D$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=E$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=F$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=G$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=H$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=I$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=J$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=K$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=L$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=M$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=N$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=O$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=P$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=Q$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=R$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=S$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=T$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=U$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=V$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=W$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=X$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=Y$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=Z$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=AA$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=AB$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=AC$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=AD$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=AE$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=AF$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=AG$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=AH$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E30=AI$2,Banque!$I30+Banque!$H30,0)","v":{"v":0,"d":"0.00"}}]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(Banque!$E31=D$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=E$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=F$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=G$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=H$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=I$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=J$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=K$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=L$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=M$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=N$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=O$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=P$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=Q$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=R$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=S$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=T$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=U$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=V$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=W$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=X$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=Y$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=Z$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=AA$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=AB$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=AC$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=AD$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=AE$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=AF$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=AG$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=AH$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E31=AI$2,Banque!$I31+Banque!$H31,0)","v":{"v":0,"d":"0.00"}}]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(Banque!$E32=D$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=E$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=F$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=G$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=H$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=I$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=J$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=K$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=L$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=M$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=N$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=O$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=P$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=Q$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=R$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=S$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=T$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=U$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=V$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=W$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=X$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=Y$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=Z$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=AA$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=AB$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=AC$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=AD$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=AE$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=AF$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=AG$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=AH$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E32=AI$2,Banque!$I32+Banque!$H32,0)","v":{"v":0,"d":"0.00"}}]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(Banque!$E33=D$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=E$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=F$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=G$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=H$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=I$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=J$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=K$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=L$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=M$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=N$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=O$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=P$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=Q$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=R$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=S$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=T$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=U$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=V$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=W$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=X$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=Y$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=Z$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=AA$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=AB$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=AC$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=AD$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=AE$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=AF$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=AG$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=AH$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E33=AI$2,Banque!$I33+Banque!$H33,0)","v":{"v":0,"d":"0.00"}}]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(Banque!$E34=D$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=E$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=F$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=G$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=H$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=I$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=J$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=K$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=L$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=M$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=N$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=O$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=P$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=Q$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=R$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=S$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=T$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=U$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=V$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=W$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=X$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=Y$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=Z$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=AA$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=AB$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=AC$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=AD$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=AE$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=AF$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=AG$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=AH$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E34=AI$2,Banque!$I34+Banque!$H34,0)","v":{"v":0,"d":"0.00"}}]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(Banque!$E35=D$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=E$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=F$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=G$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=H$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=I$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=J$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=K$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=L$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=M$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=N$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=O$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=P$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=Q$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=R$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=S$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=T$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=U$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=V$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=W$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=X$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=Y$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=Z$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=AA$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=AB$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=AC$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=AD$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=AE$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=AF$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=AG$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=AH$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E35=AI$2,Banque!$I35+Banque!$H35,0)","v":{"v":0,"d":"0.00"}}]
[null,null,{"v":0,"d":"0.00"},{"$f":"IF(Banque!$E36=D$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=E$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=F$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=G$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=H$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=I$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=J$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=K$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=L$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=M$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=N$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=O$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=P$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=Q$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=R$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=S$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=T$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=U$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=V$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=W$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=X$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=Y$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=Z$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=AA$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=AB$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=AC$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=AD$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=AE$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=AF$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=AG$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=AH$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(Banque!$E36=AI$2,Banque!$I36+Banque!$H36,0)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$f":"SUM(D4:D22)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"$f":"SUM(W4:W22)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"$f":"SUM(AI4:AI22)","v":{"v":0,"d":"0.00"}}]

{"sheet":"comptes","index":6,"n_rows":37,"n_cols":3,"rows_kept":37,"hidden":true}
[null,null,19]
[1,null,"DEPENSES"]
[2]
[3,606,"606 Fournitures administratives"]
[4,607,"607 Matériel et gros équipement"]
[5,613,"613 Location salle ou matériel"]
[6,615,"615 Entretien et réparation matériel"]
[7,616,"616 Assurance"]
[8,618,"618 Documentations brochures"]
[9,622,"622 Prestations de service Honoraires"]
[10,623,"623 Récompenses Cadeaux"]
[11,624,"624 Transport collectif des élèves"]
[12,625,"625 Déplacement animateurs,  réceptions"]
[13,626,"626 Frais postaux et télécommunication"]
[14,627,"627 Frais bancaires"]
[15,651,"651 Sacem"]
[16,657,"657 Subvention versée par l'AS"]
[17,658,"658 Licences UNSS  Affiliation"]
[18,671,"671 Charges sur Tombola , calendriers"]
[19,678,"678 Autres charges exceptionnelles"]
[20]
[21]
[22]
[23,null,"RECETTES"]
[24,741,"741 Collectivités territoriales"]
[25,744,"744 CNDS"]
[26,746,"746 UNSS DN SR SD74 District , crédits animation"]
[27,747,"747 Etablissement scolaire"]
[28,748,"748 Dons divers"]
[29,756,"756 Cotisations élèves, licences "]
[30,758,"758 Participations élèves aux sorties ou activités "]
[31,763,"763 Intérêts livret"]
[32,771,"771 Ventes tombola , calendriers…"]
[33,778,"778  Autres produits exceptionnels"]
[34]
[35]
[36]

{"sheet":"Banque","index":7,"n_rows":37,"n_cols":13,"rows_kept":37,"hidden":true,"merged":[[0,3,0,4],[0,8,0,10],[2,1,2,5],[2,9,2,10],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,5,10],[5,5,5,6],[15,1,16,2],[15,3,16,3],[15,4,16,4],[17,5,17,6]]}
[null,{"$f":"\"Compte n° \"&'Bilan-Financier'!C13","v":"Compte n° 5100"},null,{"$f":"Renseignements!C9","v":"Banque Y"},null,{"$f":"Renseignements!C10","v":"n° xxxxxxxxxxxxxxx"},null,null,"DEPENSES ET RECETTES"]
[]
[null,{"$f":"\"Association sportive : \"&Renseignements!C4&\" - \"&IF(ISBLANK(Renseignements!C5),\"\",\"BP \"&Renseignements!C5)&\" - \"&Renseignements!C6&\" - \"&Renseignements!C7&\" \"&Renseignements!C8","v":"Association sportive : College X - BP ??? - adresseX - 74- - -  VilleX"},{"$nulls":4},"Edition du ",{"$f":"NOW()","v":"2014-01-21T22:29:41.890"},"ANNEE :",{"$f":"Renseignements!C11","v":"200. / 200."}]
[null,"Date","N° Pièce","Ref bancaire","N° de compte","Libellé du compte","Destinataire , Provenance , Objet","Dépenses\n-","Recettes\n+","Solde","Pointage\nInscrire le N°\ndu bordereau"]
[]
[{"$nulls":5},"Report du solde banque du dernier bordereau de l' année antérieure",{"$nulls":3},{"$f":"Renseignements!C14","v":{"v":0,"d":"0.00 €"}},null,"dépenses pointées","recettes pointées"]
[{"$nulls":5},"Ecriture année ant. non passée en banque",{"$nulls":3},{"$f":"IF(ISBLANK(G7),\"\",J6+I7-H7)","v":""},null,{"$f":"IF(ISBLANK(K7),0,H7)","v":0},{"$f":"IF(ISBLANK(K7),0,I7)","v":0}]
[{"$nulls":5},"Ecriture année ant. non passée en banque",{"$nulls":3},{"$f":"IF(ISBLANK(G8),\"\",J7+I8-H8)","v":""},null,0,0]
[{"$nulls":5},"Ecriture année ant. non passée en banque",{"$nulls":3},"",null,0,0]
[{"$nulls":5},"Ecriture année ant. non passée en banque",{"$nulls":3},"",null,0,0]
[{"$nulls":5},"Ecriture année ant. non passée en banque",{"$nulls":3},"",null,0,0]
[{"$nulls":5},"Ecriture année ant. non passée en banque",{"$nulls":3},"",null,0,0]
[{"$nulls":5},"Ecriture année ant. non passée en banque",{"$nulls":3},"",null,0,0]
[{"$nulls":5},"Ecriture année ant. non passée en banque",{"$nulls":3},"",null,0,0]
[{"$nulls":5},"Ecriture année ant. non passée en banque",{"$nulls":3},"",null,0,0]
[null,"SOLDE \ndu compte courant",null,{"$f":"J37","v":{"v":0,"d":"0.00 €"}},null,"Ecriture année ant. non passée en banque",{"$nulls":3},"",null,0,0]
[{"$nulls":5},"Ecriture année ant. non passée en banque",{"$nulls":3},"",null,0,0]
[{"$nulls":5},"Solde de l'exercice antérieur",{"$nulls":3},{"$f":"J6+SUM(I7:I17)-SUM(H7:H17)","v":{"v":0,"d":"0.00 €"}},null,0,0]
[{"$nulls":5},{"$f":"IF(H19+I19>0,(IF(E19=0,\"N° de compte non saisi\",((IF(E19=0,\"\",IF(E19=511,\"Opération bancaire\",IF(ISNA(HLOOKUP(E19,GrilleDesComptes!$C$2:$AI$3,2,FALSE)),\"Compte inexistant\",HLOOKUP(E19,GrilleDesComptes!$C$2:$AI$3,2,FALSE)))))))),\"\")","v":""},{"$nulls":5},0,0]
[{"$nulls":5},{"$f":"IF(H20+I20>0,(IF(E20=0,\"N° de compte non saisi\",((IF(E20=0,\"\",IF(E20=511,\"Opération bancaire\",IF(ISNA(HLOOKUP(E20,GrilleDesComptes!$C$2:$AI$3,2,FALSE)),\"Compte inexistant\",HLOOKUP(E20,GrilleDesComptes!$C$2:$AI$3,2,FALSE)))))))),\"\")","v":""},{"$nulls":5},{"$f":"IF(ISBLANK(K20),0,H20)","v":0},{"$f":"IF(ISBLANK(K20),0,I20)","v":0}]
[{"$nulls":5},{"$f":"IF(H21+I21>0,(IF(E21=0,\"N° de compte non saisi\",((IF(E21=0,\"\",IF(E21=511,\"Opération bancaire\",IF(ISNA(HLOOKUP(E21,GrilleDesComptes!$C$2:$AI$3,2,FALSE)),\"Compte inexistant\",HLOOKUP(E21,GrilleDesComptes!$C$2:$AI$3,2,FALSE)))))))),\"\")","v":""},{"$nulls":5},0,0]
[{"$nulls":5},{"$f":"IF(H22+I22>0,(IF(E22=0,\"N° de compte non saisi\",((IF(E22=0,\"\",IF(E22=511,\"Opération bancaire\",IF(ISNA(HLOOKUP(E22,GrilleDesComptes!$C$2:$AI$3,2,FALSE)),\"Compte inexistant\",HLOOKUP(E22,GrilleDesComptes!$C$2:$AI$3,2,FALSE)))))))),\"\")","v":""},{"$nulls":5},{"$f":"IF(ISBLANK(K22),0,H22)","v":0},{"$f":"IF(ISBLANK(K22),0,I22)","v":0}]
[{"$nulls":5},{"$f":"IF(H23+I23>0,(IF(E23=0,\"N° de compte non saisi\",((IF(E23=0,\"\",IF(E23=511,\"Opération bancaire\",IF(ISNA(HLOOKUP(E23,GrilleDesComptes!$C$2:$AI$3,2,FALSE)),\"Compte inexistant\",HLOOKUP(E23,GrilleDesComptes!$C$2:$AI$3,2,FALSE)))))))),\"\")","v":""},{"$nulls":5},0,0]
[{"$nulls":5},{"$f":"IF(H24+I24>0,(IF(E24=0,\"N° de compte non saisi\",((IF(E24=0,\"\",IF(E24=511,\"Opération bancaire\",IF(ISNA(HLOOKUP(E24,GrilleDesComptes!$C$2:$AI$3,2,FALSE)),\"Compte inexistant\",HLOOKUP(E24,GrilleDesComptes!$C$2:$AI$3,2,FALSE)))))))),\"\")","v":""},{"$nulls":5},0,0]
[{"$nulls":5},{"$f":"IF(H25+I25>0,(IF(E25=0,\"N° de compte non saisi\",((IF(E25=0,\"\",IF(E25=511,\"Opération bancaire\",IF(ISNA(HLOOKUP(E25,GrilleDesComptes!$C$2:$AI$3,2,FALSE)),\"Compte inexistant\",HLOOKUP(E25,GrilleDesComptes!$C$2:$AI$3,2,FALSE)))))))),\"\")","v":""},{"$nulls":5},0,0]
[{"$nulls":5},{"$f":"IF(H26+I26>0,(IF(E26=0,\"N° de compte non saisi\",((IF(E26=0,\"\",IF(E26=511,\"Opération bancaire\",IF(ISNA(HLOOKUP(E26,GrilleDesComptes!$C$2:$AI$3,2,FALSE)),\"Compte inexistant\",HLOOKUP(E26,GrilleDesComptes!$C$2:$AI$3,2,FALSE)))))))),\"\")","v":""},{"$nulls":5},0,0]
[{"$nulls":5},{"$f":"IF(H27+I27>0,(IF(E27=0,\"N° de compte non saisi\",((IF(E27=0,\"\",IF(E27=511,\"Opération bancaire\",IF(ISNA(HLOOKUP(E27,GrilleDesComptes!$C$2:$AI$3,2,FALSE)),\"Compte inexistant\",HLOOKUP(E27,GrilleDesComptes!$C$2:$AI$3,2,FALSE)))))))),\"\")","v":""},{"$nulls":5},0,0]
[{"$nulls":5},{"$f":"IF(H28+I28>0,(IF(E28=0,\"N° de compte non saisi\",((IF(E28=0,\"\",IF(E28=511,\"Opération bancaire\",IF(ISNA(HLOOKUP(E28,GrilleDesComptes!$C$2:$AI$3,2,FALSE)),\"Compte inexistant\",HLOOKUP(E28,GrilleDesComptes!$C$2:$AI$3,2,FALSE)))))))),\"\")","v":""},{"$nulls":5},0,0]
[{"$nulls":5},{"$f":"IF(H29+I29>0,(IF(E29=0,\"N° de compte non saisi\",((IF(E29=0,\"\",IF(E29=511,\"Opération bancaire\",IF(ISNA(HLOOKUP(E29,GrilleDesComptes!$C$2:$AI$3,2,FALSE)),\"Compte inexistant\",HLOOKUP(E29,GrilleDesComptes!$C$2:$AI$3,2,FALSE)))))))),\"\")","v":""},{"$nulls":5},{"$f":"IF(ISBLANK(K29),0,H29)","v":0},{"$f":"IF(ISBLANK(K29),0,I29)","v":0}]
[{"$nulls":5},{"$f":"IF(H30+I30>0,(IF(E30=0,\"N° de compte non saisi\",((IF(E30=0,\"\",IF(E30=511,\"Opération bancaire\",IF(ISNA(HLOOKUP(E30,GrilleDesComptes!$C$2:$AI$3,2,FALSE)),\"Compte inexistant\",HLOOKUP(E30,GrilleDesComptes!$C$2:$AI$3,2,FALSE)))))))),\"\")","v":""},{"$nulls":5},0,0]
[{"$nulls":5},{"$f":"IF(H31+I31>0,(IF(E31=0,\"N° de compte non saisi\",((IF(E31=0,\"\",IF(E31=511,\"Opération bancaire\",IF(ISNA(HLOOKUP(E31,GrilleDesComptes!$C$2:$AI$3,2,FALSE)),\"Compte inexistant\",HLOOKUP(E31,GrilleDesComptes!$C$2:$AI$3,2,FALSE)))))))),\"\")","v":""},{"$nulls":5},0,0]
[{"$nulls":5},{"$f":"IF(H32+I32>0,(IF(E32=0,\"N° de compte non saisi\",((IF(E32=0,\"\",IF(E32=511,\"Opération bancaire\",IF(ISNA(HLOOKUP(E32,GrilleDesComptes!$C$2:$AI$3,2,FALSE)),\"Compte inexistant\",HLOOKUP(E32,GrilleDesComptes!$C$2:$AI$3,2,FALSE)))))))),\"\")","v":""},{"$nulls":5},0,0]
[{"$nulls":5},{"$f":"IF(H33+I33>0,(IF(E33=0,\"N° de compte non saisi\",((IF(E33=0,\"\",IF(E33=511,\"Opération bancaire\",IF(ISNA(HLOOKUP(E33,GrilleDesComptes!$C$2:$AI$3,2,FALSE)),\"Compte inexistant\",HLOOKUP(E33,GrilleDesComptes!$C$2:$AI$3,2,FALSE)))))))),\"\")","v":""},{"$nulls":5},0,0]
[{"$nulls":5},{"$f":"IF(H34+I34>0,(IF(E34=0,\"N° de compte non saisi\",((IF(E34=0,\"\",IF(E34=511,\"Opération bancaire\",IF(ISNA(HLOOKUP(E34,GrilleDesComptes!$C$2:$AI$3,2,FALSE)),\"Compte inexistant\",HLOOKUP(E34,GrilleDesComptes!$C$2:$AI$3,2,FALSE)))))))),\"\")","v":""},{"$nulls":5},0,0]
[{"$nulls":5},{"$f":"IF(H35+I35>0,(IF(E35=0,\"N° de compte non saisi\",((IF(E35=0,\"\",IF(E35=511,\"Opération bancaire\",IF(ISNA(HLOOKUP(E35,GrilleDesComptes!$C$2:$AI$3,2,FALSE)),\"Compte inexistant\",HLOOKUP(E35,GrilleDesComptes!$C$2:$AI$3,2,FALSE)))))))),\"\")","v":""},{"$nulls":5},0,0]
[{"$nulls":5},{"$f":"IF(H36+I36>0,(IF(E36=0,\"N° de compte non saisi\",((IF(E36=0,\"\",IF(E36=511,\"Opération bancaire\",IF(ISNA(HLOOKUP(E36,GrilleDesComptes!$C$2:$AI$3,2,FALSE)),\"Compte inexistant\",HLOOKUP(E36,GrilleDesComptes!$C$2:$AI$3,2,FALSE)))))))),\"\")","v":""},{"$nulls":5},0,0]
[null,"Notes :",{"$nulls":4},"Total de l'année",{"$f":"SUM(H6:H36)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(I6:I36)","v":{"v":0,"d":"0.00 €"}},{"$f":"J6+I37-H37","v":{"v":0,"d":"0.00 €"}},null,{"$f":"SUM(L7:L36)","v":0},{"$f":"SUM(M7:M36)","v":0}]

{"sheet":"Caisse","index":8,"n_rows":20,"n_cols":10,"rows_kept":20,"hidden":true,"merged":[[0,1,0,2],[0,7,0,9],[3,1,4,1],[3,2,4,2],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9],[5,6,5,8]]}
[null,{"$f":"\"Compte n° \"&'Bilan-Financier'!C15","v":"Compte n° 530"},null,"Caisse",{"$nulls":3},"DEPENSES ET RECETTES de la CAISSE"]
[{"$nulls":7},"SOLDE  actuel de la caisse :",{"$f":"IF(H3<0,\"Erreur , solde négatif\",\"\")","v":""}]
[null,{"$f":"\"Association sportive : \"&Renseignements!C4&\" - \"&IF(ISBLANK(Renseignements!C5),\"\",\"BP \"&Renseignements!C5)&\" - \"&Renseignements!C6&\" - \"&Renseignements!C7&\" \"&Renseignements!C8","v":"Association sportive : College X - BP ??? - adresseX - 74- - -  VilleX"},{"$nulls":5},{"$f":"J16","v":{"v":0,"d":"0.00 €"}},"Edition du ",{"$f":"NOW()","v":"2014-01-21T22:29:41.890"}]
[null,"Date","N° Pièce",{"$nulls":3},"Destinataire ou provenance","Dépenses\n-","Recettes\n+","Solde"]
[]
[{"$nulls":3},"Report solde année antérieure",null,null,"reprise année précédente",null,null,{"v":0,"d":"0.00 €"}]
[{"$nulls":3},"Liquide",{"v":530,"d":"530.00€"}]
[{"$nulls":3},"Liquide",{"v":530,"d":"530.00€"}]
[{"$nulls":3},"Liquide",{"v":530,"d":"530.00€"}]
[{"$nulls":3},"Liquide",{"v":530,"d":"530.00€"}]
[{"$nulls":3},"Liquide",{"v":530,"d":"530.00€"}]
[{"$nulls":3},"Liquide",{"v":530,"d":"530.00€"}]
[{"$nulls":3},"Liquide",{"v":530,"d":"530.00€"}]
[{"$nulls":3},"Liquide",{"v":530,"d":"530.00€"}]
[{"$nulls":3},"Liquide",{"v":530,"d":"530.00€"}]
[null,"Notes :",{"$nulls":4},"Total de l'année",{"$f":"SUM(H6:H15)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(I6:I15)","v":{"v":0,"d":"0.00 €"}},{"$f":"$J$6+I16-H16","v":{"v":0,"d":"0.00 €"}}]
[]
[]
[38643]
[38643]

{"sheet":"LivretEpargne","index":9,"n_rows":20,"n_cols":10,"rows_kept":20,"hidden":true,"merged":[[0,1,0,2],[0,7,0,9],[3,1,3,6],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,6,5,6],[4,7,5,7],[4,8,5,8],[4,9,5,9]]}
[null,{"$f":"\"Compte n° \"&'Bilan-Financier'!C14","v":"Compte n° 5110"},{"$nulls":5},"Retraits et dépôts sur livret"]
[]
[{"$nulls":7},"SOLDE actuel\ndu livret :"]
[null,{"$f":"\"Association sportive : \"&Renseignements!C4&\" - \"&IF(ISBLANK(Renseignements!C5),\"\",\"BP \"&Renseignements!C5)&\" - \"&Renseignements!C6&\" - \"&Renseignements!C7&\" \"&Renseignements!C8","v":"Association sportive : College X - BP ??? - adresseX - 74- - -  VilleX"},{"$nulls":5},{"$f":"IF(J20<0,\"ERREUR !\",J20)","v":{"v":0,"d":"0.00 €"}},"Edition du ",{"$f":"NOW()","v":"2014-01-21T22:29:41.890"}]
[null,"Date","N° Pièce ","Type de\n paiement",null,null,"Destinataire ou Provenance","Retrait\n-","dépôt\n+","Solde"]
[]
[{"$nulls":7},"reprise année antérieure",null,{"$f":"Renseignements!C15","v":{"v":0,"d":"0.00 €"}}]
[null,"2013-04-26",null,"Virement",511,null,"Livret"]
{"$rows_empty":11}
[null,"Notes :",{"$nulls":4},"Total de l'année",{"$f":"SUM(H7:H19)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(I7:I19)","v":{"v":0,"d":"0.00 €"}},{"$f":"$J$7+I20-H20","v":{"v":0,"d":"0.00 €"}}]

{"sheet":"Compte-Résultat","index":10,"n_rows":59,"n_cols":13,"rows_kept":59,"hidden":true,"merged":[[1,7,1,9],[2,7,2,9],[3,7,3,9],[4,7,4,9],[5,7,5,9],[8,2,8,5],[8,6,8,9],[10,2,10,5],[10,6,10,9],[14,7,17,7],[21,3,31,3],[29,7,31,7],[32,7,33,7],[34,3,37,3],[41,3,44,3],[41,7,44,7],[51,3,54,5],[51,6,54,9],[58,3,59,9]]}
[]
[{"$nulls":7},"Association sportive"]
[{"$nulls":7},{"$f":"Renseignements!C4","v":"College X"}]
[{"$nulls":7},{"$f":"IF(ISBLANK(Renseignements!C5),\"\",\"BP \"&Renseignements!C5)","v":"BP ???"}]
[{"$nulls":7},{"$f":"Renseignements!C6","v":"adresseX"}]
[{"$nulls":7},{"$f":"Renseignements!C7&\" \"&Renseignements!C8","v":"74- - -  VilleX"}]
[]
[]
[null,null,"COMPTE DE RESULTAT ANNEE :",{"$nulls":3},{"$f":"Renseignements!C11","v":"200. / 200."}]
[]
[null,null,"RECETTES",{"$nulls":3},"DEPENSES"]
[{"$nulls":3},"74 - SUBVENTIONS D'EXPLOITATION",{"$nulls":3},"60 - ACHATS"]
[null,null,{"$f":"IF(E13>0,741,\"\")","v":""},{"$f":"IF(E13>0,\"Collectivités territoriales\",\"\")","v":""},{"$f":"GrilleDesComptes!W23","v":{"v":0,"d":"0.00 €"}},null,{"$f":"IF(I13>0,\"606\",\"\")","v":""},{"$f":"IF(I13>0,\"Fournitures administratives\",\"\")","v":""},{"$f":"GrilleDesComptes!D23","v":{"v":0,"d":"0.00 €"}}]
[null,null,{"$f":"IF(E14>0,744,\"\")","v":""},{"$f":"IF(E14>0,\"CNDS\",\"\")","v":""},{"$f":"GrilleDesComptes!X23","v":{"v":0,"d":"0.00 €"}},null,{"$f":"IF(I14>0,\"607\",\"\")","v":""},{"$f":"IF(I14>0,\"Matériel et gros équipement\",\"\")","v":""},{"$f":"GrilleDesComptes!E23","v":{"v":0,"d":"0.00 €"}}]
[null,null,{"$f":"IF(E15>0,746,\"\")","v":""},{"$f":"IF(E15>0,\"UNSS DN SR SD74 District , crédits animation\",\"\")","v":""},{"$f":"GrilleDesComptes!Y23","v":{"v":0,"d":"0.00 €"}}]
[null,null,{"$f":"IF(E16>0,747,\"\")","v":""},{"$f":"IF(E16>0,\"Etablissement scolaire\",\"\")","v":""},{"$f":"GrilleDesComptes!Z23","v":{"v":0,"d":"0.00 €"}}]
[null,null,{"$f":"IF(E17>0,748,\"\")","v":""},{"$f":"IF(E17>0,\"Dons divers\",\"\")","v":""},{"$f":"GrilleDesComptes!AA23","v":{"v":0,"d":"0.00 €"}},{"$nulls":5},1493.7,39.33]
[{"$nulls":5},{"$f":"SUM(E13:E17)","v":{"v":0,"d":"0.00 €"}},{"$nulls":3},{"$f":"SUM(I13:I17)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":3},"75 - AUTRES PRODUITS DE GESTION",{"$nulls":3},"61/62 - AUTRES CHARGES EXTERNES"]
[null,null,{"$f":"IF(E20>0,756,\"\")","v":""},{"$f":"IF(E20>0,\"Cotisations élèves, licences \",\"\")","v":""},{"$f":"GrilleDesComptes!AB23","v":{"v":0,"d":"0.00 €"}},null,{"$f":"IF(I20>0,613,\"\")","v":""},{"$f":"IF(I20>0,\"Location salle ou matériel\",\"\")","v":""},{"$f":"GrilleDesComptes!F23","v":{"v":0,"d":"0.00 €"}}]
[null,null,{"$f":"IF(E21>0,758,\"\")","v":""},{"$f":"IF(E21>0,\"Participations élèves aux sorties ou activités \",\"\")","v":""},{"$f":"GrilleDesComptes!AC23","v":{"v":0,"d":"0.00 €"}},null,{"$f":"IF(I21>0,615,\"\")","v":""},{"$f":"IF(I21>0,\"Entretien et réparation de matériel\",\"\")","v":""},{"$f":"GrilleDesComptes!G23","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"IF(I22>0,616,\"\")","v":""},{"$f":"IF(I22>0,\"Assurance\",\"\")","v":""},{"$f":"GrilleDesComptes!H23","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"IF(I23>0,618,\"\")","v":""},{"$f":"IF(I23>0,\"Documentation, brochures…\",\"\")","v":""},{"$f":"GrilleDesComptes!I23","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"IF(I24>0,622,\"\")","v":""},{"$f":"IF(I24>0,\"Prestations de service Honoraires\",\"\")","v":""},{"$f":"GrilleDesComptes!J23","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"IF(I25>0,623,\"\")","v":""},{"$f":"IF(I25>0,\"Récompenses Cadeaux\",\"\")","v":""},{"$f":"GrilleDesComptes!K23","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"IF(I26>0,624,\"\")","v":""},{"$f":"IF(I26>0,\"Transport collectif des élèves\",\"\")","v":""},{"$f":"GrilleDesComptes!L23","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"IF(I27>0,625,\"\")","v":""},{"$f":"IF(I27>0,\"Déplacement animateurs,  réceptions\",\"\")","v":""},{"$f":"GrilleDesComptes!M23","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"IF(I28>0,626,\"\")","v":""},{"$f":"IF(I28>0,\"Frais postaux et télécommunication\",\"\")","v":""},{"$f":"GrilleDesComptes!N23","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"IF(I29>0,627,\"\")","v":""},{"$f":"IF(I29>0,\"Frais bancaires\",\"\")","v":""},{"$f":"GrilleDesComptes!O23","v":{"v":0,"d":"0.00 €"}}]
[]
[]
[{"$nulls":5},{"$f":"SUM(E20:E31)","v":{"v":0,"d":"0.00 €"}},{"$nulls":3},{"$f":"SUM(I20:I31)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":3},"76 - PRODUITS FINANCIERS",{"$nulls":3},"65 -AUTRES CHARGES DE GESTION COURANTE"]
[null,null,{"$f":"IF(E34>0,763,\"\")","v":""},{"$f":"IF(E34>0,\"Intérêts livret\",\"\")","v":""},{"$f":"GrilleDesComptes!AD23","v":{"v":0,"d":"0.00 €"}},{"$nulls":5},{"$f":"2496.46","v":2496.46},163.44,829.06]
[{"$nulls":6},{"$f":"IF(I35>0,651,\"\")","v":""},{"$f":"IF(I35>0,\"Sacem\",\"\")","v":""},{"$f":"GrilleDesComptes!P23","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"IF(I36>0,657,\"\")","v":""},{"$f":"IF(I36>0,\"Subvention versée par l'AS\",\"\")","v":""},{"$f":"GrilleDesComptes!Q23","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"IF(I37>0,658,\"\")","v":""},{"$f":"IF(I37>0,\"Licences UNSS  Affiliation\",\"\")","v":""},{"$f":"GrilleDesComptes!R23","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":5},{"$f":"SUM(E34:E37)","v":{"v":0,"d":"0.00 €"}},{"$nulls":3},{"$f":"SUM(I35:I37)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":3},"77 - PRODUITS EXCEPTIONNELS",{"$nulls":3},"67 - CHARGES EXCEPTIONNELLES"]
[null,null,{"$f":"IF(E40>0,771,\"\")","v":""},{"$f":"IF(E40>0,\"Ventes tombola , calendriers…\",\"\")","v":""},{"$f":"GrilleDesComptes!AE23","v":{"v":0,"d":"0.00 €"}},null,{"$f":"IF(I40>0,671,\"\")","v":""},{"$f":"IF(I40>0,\"Charges sur Tombola , calendriers\",\"\")","v":""},{"$f":"GrilleDesComptes!S23","v":{"v":0,"d":"0.00 €"}}]
[null,null,{"$f":"IF(E41>0,778,\"\")","v":""},{"$f":"IF(E41>0,\"Autres produits exceptionnels\",\"\")","v":""},{"$f":"GrilleDesComptes!AF23","v":{"v":0,"d":"0.00 €"}},null,{"$f":"IF(I41>0,678,\"\")","v":""},{"$f":"IF(I41>0,\"Autres charges exceptionnelles\",\"\")","v":""},{"$f":"GrilleDesComptes!T23","v":{"v":0,"d":"0.00 €"}}]
[]
[]
[]
[{"$nulls":5},{"$f":"SUM(E40:E44)","v":{"v":0,"d":"0.00 €"}},{"$nulls":3},{"$f":"SUM(I40:I44)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":3},"TOTAL REVENUS",null,{"$f":"SUM(F12:F45)","v":{"v":0,"d":"0.00 €"}},null,"TOTAL DEPENSES",null,{"$f":"SUM(J12:J45)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":3},"DEFICIT",null,{"$f":"IF(J46>=F46,J46-F46,0)","v":{"v":0,"d":"0.00 €"}},null,"BENEFICE",null,{"$f":"IF(F46>=J46,F46-J46,0)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":3},"TOTAUX",null,{"$f":"F46+F47","v":{"v":0,"d":"0.00 €"}},null,"TOTAUX",null,{"$f":"J46+J47","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":10},96317.59]
[{"$nulls":3},{"$f":"'Bilan-Financier'!D21","v":"Document édité le :"},null,null,"A",{"$f":"Renseignements!C8","v":"VilleX"},"Le ",{"$f":"Renseignements!C12","v":"date x"},{"$f":"K49-J46","v":{"v":96317.59,"d":"96,317.59 €"}}]
[{"$nulls":3},{"$f":"'Bilan-Financier'!D22","v":"2014-01-21T22:29:41.890"},null,null,"Le président de l'association sportive :"]
[{"$nulls":6},{"$f":"Renseignements!C13","v":"Mr X"}]
[]
[]
[]
[]
[{"$nulls":3},"Il est possible de marquer des commentaires dans les cases vertes "]
[]
[{"$nulls":3},"Si vous ne voulez pas  imprimer en vert , déprotégez la feuille (pas de mot de passe )  et enlevez la couleur du remplissage . "]

{"sheet":"Bilan-Financier","index":11,"n_rows":23,"n_cols":9,"rows_kept":23,"merged":[[1,7,1,9],[2,7,2,9],[3,7,3,9],[4,7,4,9],[5,7,5,9],[6,3,6,5],[8,2,8,5],[8,6,8,8],[10,2,10,4],[10,6,10,8]]}
[]
[{"$nulls":7},"Association sportive :"]
[{"$nulls":7},{"$f":"Renseignements!C4","v":"College X"}]
[{"$nulls":7},{"$f":"IF(ISBLANK(Renseignements!C5),\"\",\"BP \"&Renseignements!C5)","v":"BP ???"}]
[{"$nulls":7},{"$f":"Renseignements!C6","v":"adresseX"}]
[{"$nulls":7},{"$f":"Renseignements!C7&\" \"&Renseignements!C8","v":"74- - -  VilleX"}]
[{"$nulls":3},{"$f":"IF(E17=I17,\"\",\"ERREUR !!\")","v":""}]
[]
[null,null,"BILAN FINANCIER ANNEE :",{"$nulls":3},{"$f":"Renseignements!C11","v":"200. / 200."}]
[]
[null,null,"ACTIF",{"$nulls":3},"PASSIF"]
[]
[null,null,5100,{"$f":"Banque!D1","v":"Banque Y"},{"$f":"Banque!D16","v":{"v":0,"d":"0.00 €"}},null,1060,"FONDS DE RESERVE\n (résultats cumulés des années précédentes)",{"$f":"SUM(Renseignements!C15:C15)+Banque!J18","v":{"v":0,"d":"0.00 €"}}]
[null,null,5110,"Epargne sur livret",{"$f":"LivretEpargne!H4","v":{"v":0,"d":"0.00 €"}},null,{"$f":"IF(I14=0,\"\",1190)","v":""},{"$f":"IF(I14=0,\"\",\"DEFICIT\")","v":""},{"$f":"-'Compte-Résultat'!F47","v":{"v":0,"d":"0.00 €"}}]
[null,null,530,"Caisse",{"$f":"Caisse!H3","v":{"v":0,"d":"0.00 €"}},null,{"$f":"IF(I15=0,\"\",1200)","v":""},{"$f":"IF(I15=0,\"\",\"BENEFICE\")","v":""},{"$f":"'Compte-Résultat'!J47","v":{"v":0,"d":"0.00 €"}}]
[]
[{"$nulls":3},"Total",{"$f":"SUM(E13:E16)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(E12:E16)","v":{"v":0,"d":"0.00 €"}},null,"Total",{"$f":"I13+I14+I15","v":{"v":0,"d":"0.00 €"}}]
[]
[]
[]
[{"$nulls":3},"Document édité le :",null,null,"A",{"$f":"Renseignements!C8","v":"VilleX"},{"$f":"Renseignements!C12","v":"date x"}]
[{"$nulls":3},{"$f":"NOW()","v":"2014-01-21T22:29:41.890"},null,null,"Le président de l'association sportive :"]
[{"$nulls":6},{"$f":"Renseignements!C13","v":"Mr X"}]