{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Accueil","----","Paramètres","---","Mode d'emploi","--","Feuil"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":10,"comments":1,"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":"Accueil","index":0,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[[30,12,30,13],[28,1,28,8],[29,1,29,8],[0,1,0,10],[1,1,1,10],[26,1,26,11],[27,1,27,11],[29,9,29,10],[4,1,4,2]]}
[null,"Les comptes de l'Association Sportive"]
[null,"Pour la gestion des comptes de l'Association Sportive sur une année scolaire (et plus)"]
[]
[]
[null,"Enregistrer et quitter"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Cette application n'est pas verrouillée par mot de passe. Vous pourez donc la modifier à votre convenance. Il s'agit d'une application qui vous permettra de gérer les comptes "]
[null,"de l'Association Sportive."]
[null,"Ctrl + Shift (Majuscule) + D    =>   Déverrouillage de l'application (L'application est verrouillée par défaut)"]
[null,"Ctrl + Shift (Majuscule) + V    =>   Verrouillage de l'application",null,null,null,null,null,null,null,"Cette oeuvre est sous licence Creative Commons\n Paternité - Pas d'Utilisation Commerciale 2.0 France."]

{"sheet":"----","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["----"]

{"sheet":"Paramètres","index":2,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[[20,5,28,6],[4,10,8,11],[15,10,15,11],[12,10,14,11],[1,1,4,1],[6,1,9,1],[11,1,12,1],[0,4,0,7],[1,5,1,6]]}
[null,null,null,"Entrez l'année scolaire","Entrez l'avoir initial"]
[null,"Après avoir copié des données, vous pouvez directement cliquer sur \"accéder aux comptes\".",null,null,"2012-2013"]
[null,null,null,"Entrez le nom de l'établissement"]
[]
[]
[]
[null,"Pour la 1ère utilisation, pensez à renseigner l'année scolaire, le nom de l'Etablissement et l'avoir initial, puis       ",null,"Items de la liste de choix déroulants"]
[null,null,1,"Affiliation"]
[null,null,2,"Assurances"]
[null,null,3,"Autres"]
[null,"cliquez sur la disquette",4,"Contrat"]
[null,"pour copier les données sur la feuille de comptes.",5,"Cross Chèques"]
[null,null,6,"Cross Espèces"]
[null,null,7,"Dépenses Cross"]
[null,null,8,"Dépenses Lavages"]
[null,null,9,"Dépenses Matériel"]
[null,null,10,"Dépenses Ski"]
[null,null,11,"Frais Compte"]
[null,null,12,"Lavage voitures Chèques"]
[null,null,13,"Lavage Voitures Espèces"]
[null,null,14,"Licences Chèques",null,"Vous pouvez ajouter ou modifier ici les items à votre convenance et ils se rajouteront au menu déroulant dans les comptes.\n"]
[null,null,15,"Licences Espèces"]
[null,null,16,"Maison de la Danse Chèques"]
[null,null,17,"Maison de la Danse espèces"]
[null,null,18,"Ski Chèques"]
[null,null,19,"Ski Espèces"]
[null,null,20,"Subvention"]
[null,null,21,"Transport"]
[null,null,22]
[null,null,23]
[null,null,24]
[null,null,25]
[null,null,26]
[null,null,27]
[null,null,28]
[null,null,29]
[null,null,30]

{"sheet":"---","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Mode d'emploi","index":4,"n_rows":141,"n_cols":13,"rows_kept":141,"cut":false,"hidden":false,"merged":[[18,0,20,2],[18,12,21,13],[26,11,28,13],[38,6,39,8]]}
[]
["     Explications de l'application :"]
[]
[" Il s'agit d'une application qui gère les comptes de l'Association Sportive de votre établissement."]
[" L'enseignant n'a que peu de paramètres à régler, le reste ressemble à un cahier de compte :"]
[]
["Si vous utilisez l'application pour la première fois, vous devez avant tout entrer 3 informations importantes : l'année scolaire, le nom de l'établissement "]
["et la somme avec laquelle vous allez débuter l'année (solde initial).",null,null,null,null,null,null,null,1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2 - Cliquez sur la disquette",null,null,null,null,null,null,null,null,null,null,null,"4 - Cliquez sur \"Accéder aux comptes\""]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"3 - Vous pourrez ici effacer ou ajouter des items présents dans vos comptes. A vous de les personnaliser !"]
[]
[]
[]
[]
[]
[]
[]
["Après avoir cliqué sur \"Accéder aux Comptes\", vous serez redirigé automatiquement sur l'onglet de Gestion des comptes :"]
[]
[]
[]
["Cet onglet vous permettra de trier ",null,null,null,null,null,"Cliquez ici pour avancer ou reculer d'une année.",null,null,"Cliquez ici pour enregistrer et quitter l'application"]
["toutes les opérations par date."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Voici à quoi pourrait ressembler un compte d'AS."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Lorsque vous recevez les relevés de compte, il vous suffit de noter le numéro du relevé et automatiquement la ligne se met en blanc, ce qui signifie que le solde est consolidé."]
[]
["En cliquant sur le bouton \"Etat des comptes\",                                         vous accédez à ceci :",null,null,null,null,null,null,null,null,null,"Cliquez ici pour revenir en haut de la page."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Si vous cliquez ici, vous créerez une nouvelle année scolaire : il vous sera demandé uniquement de renseigner la nouvelle année scolaire."]

{"sheet":"--","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Feuil","index":6,"n_rows":459,"n_cols":63,"rows_kept":459,"cut":false,"hidden":false,"merged":[[0,4,0,5],[2,4,2,5],[0,1,0,2],[1,1,1,2],[372,59,372,62],[369,59,369,62],[370,60,370,62],[437,10,437,11],[1,4,1,5]]}
["X","ASSOCIATION SPORTIVE   ",null,null,"AVOIR INITIAL"]
[null,"Année scolaire   ",null,null,"SOLDE NON CONSOLIDE",null,{"$f":"G1+F6-E6","v":0}]
[null,"* en  caractères gras dépenses consolidées",null,null,"SOLDE CONSOLIDE",null,{"$f":"G1+J6-I6","v":0},1756]
[null,"* en italique: dépenses en cours (ne sont consolidées que ",null,null,null,null,null,"Enregistrer et quitter"]
[null,"au moment du relevé de compte)"]
[null,null,null,"Bilan",{"$f":"SUM(IF(ISBLANK(H8:H422),0,(E8:E422)))","v":0},{"$f":"SUM(IF(ISBLANK(H8:H422),0,F8:F422))","v":0},null,null,{"$f":"SUM(IF(ISBLANK(L8:L422),0,(I8:I422)))","v":0},{"$f":"SUM(IF(ISBLANK(L8:L422),0,J8:J422))","v":0}]
[null,"Dates  (jj/mm/aaaa)","Nature","Libellé de l'opération","Débit","Crédit","Solde","Relevé de compte N°","Débit","Crédit","Etat des comptes"]
[1,null,"Affiliation",null,null,null,{"$f":"IF(COUNT(E8:F8)=0,\"\",G1+(IF(E8=\"\",F8,0-E8)))","v":""},null,{"$f":"IF(H8=\"\",\"\",E8)","v":""},{"$f":"IF(H8=\"\",\"\",F8)","v":""}]
[2,null,null,null,null,null,{"$f":"IF(COUNT(E9:F9)=0,\"\",IF(F9=\"\",G8-E9,G8+F9))","v":""},null,"",""]
[3,null,null,null,null,null,"",null,"",""]
[4,null,null,null,null,null,"",null,"",""]
[5,null,null,null,null,null,"",null,"",""]
[6,null,null,null,null,null,"",null,"",""]
[7,null,null,null,null,null,"",null,"",""]
[8,null,null,null,null,null,"",null,"",""]
[9,null,null,null,null,null,"",null,"",""]
[10,null,null,null,null,null,"",null,"",""]
[11,null,null,null,null,null,"",null,"",""]
[12,null,null,null,null,null,"",null,"",""]
[13,null,null,null,null,null,"",null,"",""]
[14,null,null,null,null,null,"",null,"",""]
[15,null,null,null,null,null,"",null,"",""]
[16,null,null,null,null,null,"",null,"",""]
[17,null,null,null,null,null,"",null,"",""]
[18,null,null,null,null,null,"",null,"",""]
[19,null,null,null,null,null,"",null,"",""]
[20,null,null,null,null,null,"",null,"",""]
[21,null,null,null,null,null,"",null,"",""]
[22,null,null,null,null,null,"",null,"",""]
[23,null,null,null,null,null,"",null,"",""]
[24,null,null,null,null,null,"",null,"",""]
[25,null,null,null,null,null,"",null,"",""]
[26,null,null,null,null,null,"",null,"",""]
[27,null,null,null,null,null,"",null,"",""]
[28,null,null,null,null,null,"",null,"",""]
[29,null,null,null,null,null,"",null,"",""]
[30,null,null,null,null,null,"",null,"",""]
[31,null,null,null,null,null,"",null,"",""]
[32,null,null,null,null,null,"",null,"",""]
[33,null,null,null,null,null,"",null,"",""]
[34,null,null,null,null,null,"",null,"",""]
[35,null,null,null,null,null,"",null,"",""]
[36,null,null,null,null,null,"",null,"",""]
[37,null,null,null,null,null,"",null,"",""]
[38,null,null,null,null,null,"",null,"",""]
[39,null,null,null,null,null,"",null,"",""]
[40,null,null,null,null,null,"",null,"",""]
[41,null,null,null,null,null,"",null,"",""]
[42,null,null,null,null,null,"",null,"",""]
[43,null,null,null,null,null,"",null,"",""]
[44,null,null,null,null,null,"",null,"",""]
[45,null,null,null,null,null,"",null,"",""]
[46,null,null,null,null,null,"",null,"",""]
[47,null,null,null,null,null,"",null,"",""]
[48,null,null,null,null,null,"",null,"",""]
[49,null,null,null,null,null,"",null,"",""]
[50,null,null,null,null,null,"",null,"",""]
[51,null,null,null,null,null,"",null,"",""]
[52,null,null,null,null,null,"",null,"",""]
[53,null,null,null,null,null,"",null,"",""]
[54,null,null,null,null,null,"",null,"",""]
[55,null,null,null,null,null,"",null,"",""]
[56,null,null,null,null,null,"",null,"",""]
[57,null,null,null,null,null,"",null,"",""]
[58,null,null,null,null,null,"",null,"",""]
[59,null,null,null,null,null,"",null,"",""]
[60,null,null,null,null,null,"",null,"",""]
[61,null,null,null,null,null,"",null,"",""]
[62,null,null,null,null,null,"",null,"",""]
[63,null,null,null,null,null,"",null,"",""]
[64,null,null,null,null,null,"",null,"",""]
[65,null,null,null,null,null,"",null,{"$f":"IF(H72=\"\",\"\",E72)","v":""},{"$f":"IF(H72=\"\",\"\",F72)","v":""}]
[66,null,null,null,null,null,{"$f":"IF(COUNT(E73:F73)=0,\"\",IF(F73=\"\",G72-E73,G72+F73))","v":""},null,"",""]
[67,null,null,null,null,null,"",null,"",""]
[68,null,null,null,null,null,"",null,"",""]
[69,null,null,null,null,null,"",null,"",""]
[70,null,null,null,null,null,"",null,"",""]
[71,null,null,null,null,null,"",null,"",""]
[72,null,null,null,null,null,"",null,"",""]
[73,null,null,null,null,null,"",null,"",""]
[74,null,null,null,null,null,"",null,"",""]
[75,null,null,null,null,null,"",null,"",""]
[76,null,null,null,null,null,"",null,"",""]
[77,null,null,null,null,null,"",null,"",""]
[78,null,null,null,null,null,"",null,"",""]
[79,null,null,null,null,null,"",null,"",""]
[80,null,null,null,null,null,"",null,"",""]
[81,null,null,null,null,null,"",null,"",""]
[82,null,null,null,null,null,"",null,"",""]
[83,null,null,null,null,null,"",null,"",""]
[84,null,null,null,null,null,"",null,"",""]
[85,null,null,null,null,null,"",null,"",""]
[86,null,null,null,null,null,"",null,"",""]
[87,null,null,null,null,null,"",null,"",""]
[88,null,null,null,null,null,"",null,"",""]
[89,null,null,null,null,null,"",null,"",""]
[90,null,null,null,null,null,"",null,"",""]
[91,null,null,null,null,null,"",null,"",""]
[92,null,null,null,null,null,"",null,"",""]
[93,null,null,null,null,null,"",null,"",""]
[94,null,null,null,null,null,"",null,"",""]
[95,null,null,null,null,null,"",null,"",""]
[96,null,null,null,null,null,"",null,"",""]
[97,null,null,null,null,null,"",null,"",""]
[98,null,null,null,null,null,"",null,"",""]
[99,null,null,null,null,null,"",null,"",""]
[100,null,null,null,null,null,"",null,"",""]
[101,null,null,null,null,null,"",null,"",""]
[102,null,null,null,null,null,"",null,"",""]
[103,null,null,null,null,null,"",null,"",""]
[104,null,null,null,null,null,"",null,"",""]
[105,null,null,null,null,null,"",null,"",""]
[106,null,null,null,null,null,"",null,"",""]
[107,null,null,null,null,null,"",null,"",""]
[108,null,null,null,null,null,"",null,"",""]
[109,null,null,null,null,null,"",null,"",""]
[110,null,null,null,null,null,"",null,"",""]
[111,null,null,null,null,null,"",null,"",""]
[112,null,null,null,null,null,"",null,"",""]
[113,null,null,null,null,null,"",null,"",""]
[114,null,null,null,null,null,"",null,"",""]
[115,null,null,null,null,null,"",null,"",""]
[116,null,null,null,null,null,"",null,"",""]
[117,null,null,null,null,null,"",null,"",""]
[118,null,null,null,null,null,"",null,"",""]
[119,null,null,null,null,null,"",null,"",""]
[120,null,null,null,null,null,"",null,"",""]
[121,null,null,null,null,null,"",null,"",""]
[122,null,null,null,null,null,"",null,"",""]
[123,null,null,null,null,null,"",null,"",""]
[124,null,null,null,null,null,"",null,"",""]
[125,null,null,null,null,null,"",null,"",""]
[126,null,null,null,null,null,"",null,"",""]
[127,null,null,null,null,null,"",null,"",""]
[128,null,null,null,null,null,"",null,"",""]
[129,null,null,null,null,null,"",null,{"$f":"IF(H136=\"\",\"\",E136)","v":""},{"$f":"IF(H136=\"\",\"\",F136)","v":""}]
[130,null,null,null,null,null,{"$f":"IF(COUNT(E137:F137)=0,\"\",IF(F137=\"\",G136-E137,G136+F137))","v":""},null,"",""]
[131,null,null,null,null,null,"",null,"",""]
[132,null,null,null,null,null,"",null,"",""]
[133,null,null,null,null,null,"",null,"",""]
[134,null,null,null,null,null,"",null,"",""]
[135,null,null,null,null,null,"",null,"",""]
[136,null,null,null,null,null,"",null,"",""]
[137,null,null,null,null,null,"",null,"",""]
[138,null,null,null,null,null,"",null,"",""]
[139,null,null,null,null,null,"",null,"",""]
[140,null,null,null,null,null,"",null,"",""]
[141,null,null,null,null,null,"",null,"",""]
[142,null,null,null,null,null,"",null,"",""]
[143,null,null,null,null,null,"",null,"",""]
[144,null,null,null,null,null,"",null,"",""]
[145,null,null,null,null,null,"",null,"",""]
[146,null,null,null,null,null,"",null,"",""]
[147,null,null,null,null,null,"",null,"",""]
[148,null,null,null,null,null,"",null,"",""]
[149,null,null,null,null,null,"",null,"",""]
[150,null,null,null,null,null,"",null,"",""]
[151,null,null,null,null,null,"",null,"",""]
[152,null,null,null,null,null,"",null,"",""]
[153,null,null,null,null,null,"",null,"",""]
[154,null,null,null,null,null,"",null,"",""]
[155,null,null,null,null,null,"",null,"",""]
[156,null,null,null,null,null,"",null,"",""]
[157,null,null,null,null,null,"",null,"",""]
[158,null,null,null,null,null,"",null,"",""]
[159,null,null,null,null,null,"",null,"",""]
[160,null,null,null,null,null,"",null,"",""]
[161,null,null,null,null,null,"",null,"",""]
[162,null,null,null,null,null,"",null,"",""]
[163,null,null,null,null,null,"",null,"",""]
[164,null,null,null,null,null,"",null,"",""]
[165,null,null,null,null,null,"",null,"",""]
[166,null,null,null,null,null,"",null,"",""]
[167,null,null,null,null,null,"",null,"",""]
[168,null,null,null,null,null,"",null,"",""]
[169,null,null,null,null,null,"",null,"",""]
[170,null,null,null,null,null,"",null,"",""]
[171,null,null,null,null,null,"",null,"",""]
[172,null,null,null,null,null,"",null,"",""]
[173,null,null,null,null,null,"",null,"",""]
[174,null,null,null,null,null,"",null,"",""]
[175,null,null,null,null,null,"",null,"",""]
[176,null,null,null,null,null,"",null,"",""]
[177,null,null,null,null,null,"",null,"",""]
[178,null,null,null,null,null,"",null,"",""]
[179,null,null,null,null,null,"",null,"",""]
[180,null,null,null,null,null,"",null,"",""]
[181,null,null,null,null,null,"",null,"",""]
[182,null,null,null,null,null,"",null,"",""]
[183,null,null,null,null,null,"",null,"",""]
[184,null,null,null,null,null,"",null,"",""]
[185,null,null,null,null,null,"",null,"",""]
[186,null,null,null,null,null,"",null,"",""]
[187,null,null,null,null,null,"",null,"",""]
[188,null,null,null,null,null,"",null,"",""]
[189,null,null,null,null,null,"",null,"",""]
[190,null,null,null,null,null,"",null,"",""]
[191,null,null,null,null,null,"",null,"",""]
[192,null,null,null,null,null,"",null,"",""]
[193,null,null,null,null,null,"",null,{"$f":"IF(H200=\"\",\"\",E200)","v":""},{"$f":"IF(H200=\"\",\"\",F200)","v":""}]
[194,null,null,null,null,null,{"$f":"IF(COUNT(E201:F201)=0,\"\",IF(F201=\"\",G200-E201,G200+F201))","v":""},null,"",""]
[195,null,null,null,null,null,"",null,"",""]
[196,null,null,null,null,null,"",null,"",""]
[197,null,null,null,null,null,"",null,"",""]
[198,null,null,null,null,null,"",null,"",""]
[199,null,null,null,null,null,"",null,"",""]
[200,null,null,null,null,null,"",null,"",""]
[201,null,null,null,null,null,"",null,"",""]
[202,null,null,null,null,null,"",null,"",""]
[203,null,null,null,null,null,"",null,"",""]
[204,null,null,null,null,null,"",null,"",""]
[205,null,null,null,null,null,"",null,"",""]
[206,null,null,null,null,null,"",null,"",""]
[207,null,null,null,null,null,"",null,"",""]
[208,null,null,null,null,null,"",null,"",""]
[209,null,null,null,null,null,"",null,"",""]
[210,null,null,null,null,null,"",null,"",""]
[211,null,null,null,null,null,"",null,"",""]
[212,null,null,null,null,null,"",null,"",""]
[213,null,null,null,null,null,"",null,"",""]
[214,null,null,null,null,null,"",null,"",""]
[215,null,null,null,null,null,"",null,"",""]
[216,null,null,null,null,null,"",null,"",""]
[217,null,null,null,null,null,"",null,"",""]
[218,null,null,null,null,null,"",null,"",""]
[219,null,null,null,null,null,"",null,"",""]
[220,null,null,null,null,null,"",null,"",""]
[221,null,null,null,null,null,"",null,"",""]
[222,null,null,null,null,null,"",null,"",""]
[223,null,null,null,null,null,"",null,"",""]
[224,null,null,null,null,null,"",null,"",""]
[225,null,null,null,null,null,"",null,"",""]
[226,null,null,null,null,null,"",null,"",""]
[227,null,null,null,null,null,"",null,"",""]
[228,null,null,null,null,null,"",null,"",""]
[229,null,null,null,null,null,"",null,"",""]
[230,null,null,null,null,null,"",null,"",""]
[231,null,null,null,null,null,"",null,"",""]
[232,null,null,null,null,null,"",null,"",""]
[233,null,null,null,null,null,"",null,"",""]
[234,null,null,null,null,null,"",null,"",""]
[235,null,null,null,null,null,"",null,"",""]
[236,null,null,null,null,null,"",null,"",""]
[237,null,null,null,null,null,"",null,"",""]
[238,null,null,null,null,null,"",null,"",""]
[239,null,null,null,null,null,"",null,"",""]
[240,null,null,null,null,null,"",null,"",""]
[241,null,null,null,null,null,"",null,"",""]
[242,null,null,null,null,null,"",null,"",""]
[243,null,null,null,null,null,"",null,"",""]
[244,null,null,null,null,null,"",null,"",""]
[245,null,null,null,null,null,"",null,"",""]
[246,null,null,null,null,null,"",null,"",""]
[247,null,null,null,null,null,"",null,"",""]
[248,null,null,null,null,null,"",null,"",""]
[249,null,null,null,null,null,"",null,"",""]
[250,null,null,null,null,null,"",null,"",""]
[251,null,null,null,null,null,"",null,"",""]
[252,null,null,null,null,null,"",null,"",""]
[253,null,null,null,null,null,"",null,"",""]
[254,null,null,null,null,null,"",null,"",""]
[255,null,null,null,null,null,"",null,"",""]
[256,null,null,null,null,null,"",null,"",""]
[257,null,null,null,null,null,"",null,{"$f":"IF(H264=\"\",\"\",E264)","v":""},{"$f":"IF(H264=\"\",\"\",F264)","v":""}]
[258,null,null,null,null,null,{"$f":"IF(COUNT(E265:F265)=0,\"\",IF(F265=\"\",G264-E265,G264+F265))","v":""},null,"",""]
[259,null,null,null,null,null,"",null,"",""]
[260,null,null,null,null,null,"",null,"",""]
[261,null,null,null,null,null,"",null,"",""]
[262,null,null,null,null,null,"",null,"",""]
[263,null,null,null,null,null,"",null,"",""]
[264,null,null,null,null,null,"",null,"",""]
[265,null,null,null,null,null,"",null,"",""]
[266,null,null,null,null,null,"",null,"",""]
[267,null,null,null,null,null,"",null,"",""]
[268,null,null,null,null,null,"",null,"",""]
[269,null,null,null,null,null,"",null,"",""]
[270,null,null,null,null,null,"",null,"",""]
[271,null,null,null,null,null,"",null,"",""]
[272,null,null,null,null,null,"",null,"",""]
[273,null,null,null,null,null,"",null,"",""]
[274,null,null,null,null,null,"",null,"",""]
[275,null,null,null,null,null,"",null,"",""]
[276,null,null,null,null,null,"",null,"",""]
[277,null,null,null,null,null,"",null,"",""]
[278,null,null,null,null,null,"",null,"",""]
[279,null,null,null,null,null,"",null,"",""]
[280,null,null,null,null,null,"",null,"",""]
[281,null,null,null,null,null,"",null,"",""]
[282,null,null,null,null,null,"",null,"",""]
[283,null,null,null,null,null,"",null,"",""]
[284,null,null,null,null,null,"",null,"",""]
[285,null,null,null,null,null,"",null,"",""]
[286,null,null,null,null,null,"",null,"",""]
[287,null,null,null,null,null,"",null,"",""]
[288,null,null,null,null,null,"",null,"",""]
[289,null,null,null,null,null,"",null,"",""]
[290,null,null,null,null,null,"",null,"",""]
[291,null,null,null,null,null,"",null,"",""]
[292,null,null,null,null,null,"",null,"",""]
[293,null,null,null,null,null,"",null,"",""]
[294,null,null,null,null,null,"",null,"",""]
[295,null,null,null,null,null,"",null,"",""]
[296,null,null,null,null,null,"",null,"",""]
[297,null,null,null,null,null,"",null,"",""]
[298,null,null,null,null,null,"",null,"",""]
[299,null,null,null,null,null,"",null,"",""]
[300,null,null,null,null,null,"",null,"",""]
[301,null,null,null,null,null,"",null,"",""]
[302,null,null,null,null,null,"",null,"",""]
[303,null,null,null,null,null,"",null,"",""]
[304,null,null,null,null,null,"",null,"",""]
[305,null,null,null,null,null,"",null,"",""]
[306,null,null,null,null,null,"",null,"",""]
[307,null,null,null,null,null,"",null,"",""]
[308,null,null,null,null,null,"",null,"",""]
[309,null,null,null,null,null,"",null,"",""]
[310,null,null,null,null,null,"",null,"",""]
[311,null,null,null,null,null,"",null,"",""]
[312,null,null,null,null,null,"",null,"",""]
[313,null,null,null,null,null,"",null,"",""]
[314,null,null,null,null,null,"",null,"",""]
[315,null,null,null,null,null,"",null,"",""]
[316,null,null,null,null,null,"",null,"",""]
[317,null,null,null,null,null,"",null,"",""]
[318,null,null,null,null,null,"",null,"",""]
[319,null,null,null,null,null,"",null,"",""]
[320,null,null,null,null,null,"",null,"",""]
[321,null,null,null,null,null,"",null,{"$f":"IF(H328=\"\",\"\",E328)","v":""},{"$f":"IF(H328=\"\",\"\",F328)","v":""}]
[322,null,null,null,null,null,{"$f":"IF(COUNT(E329:F329)=0,\"\",IF(F329=\"\",G328-E329,G328+F329))","v":""},null,"",""]
[323,null,null,null,null,null,"",null,"",""]
[324,null,null,null,null,null,"",null,"",""]
[325,null,null,null,null,null,"",null,"",""]
[326,null,null,null,null,null,"",null,"",""]
[327,null,null,null,null,null,"",null,"",""]
[328,null,null,null,null,null,"",null,"",""]
[329,null,null,null,null,null,"",null,"",""]
[330,null,null,null,null,null,"",null,"",""]
[331,null,null,null,null,null,"",null,"",""]
[332,null,null,null,null,null,"",null,"",""]
[333,null,null,null,null,null,"",null,"",""]
[334,null,null,null,null,null,"",null,"",""]
[335,null,null,null,null,null,"",null,"",""]
[336,null,null,null,null,null,"",null,"",""]
[337,null,null,null,null,null,"",null,"",""]
[338,null,null,null,null,null,"",null,"",""]
[339,null,null,null,null,null,"",null,"",""]
[340,null,null,null,null,null,"",null,"",""]
[341,null,null,null,null,null,"",null,"",""]
[342,null,null,null,null,null,"",null,"",""]
[343,null,null,null,null,null,"",null,"",""]
[344,null,null,null,null,null,"",null,"",""]
[345,null,null,null,null,null,"",null,"",""]
[346,null,null,null,null,null,"",null,"",""]
[347,null,null,null,null,null,"",null,"",""]
[348,null,null,null,null,null,"",null,"",""]
[349,null,null,null,null,null,"",null,"",""]
[350,null,null,null,null,null,"",null,"",""]
[351,null,null,null,null,null,"",null,"",""]
[352,null,null,null,null,null,"",null,"",""]
[353,null,null,null,null,null,"",null,"",""]
[354,null,null,null,null,null,"",null,"",""]
[355,null,null,null,null,null,"",null,"",""]
[356,null,null,null,null,null,"",null,"",""]
[357,null,null,null,null,null,"",null,"",""]
[358,null,null,null,null,null,"",null,"",""]
[359,null,null,null,null,null,"",null,"",""]
[360,null,null,null,null,null,"",null,"",""]
[361,null,null,null,null,null,"",null,"",""]
[362,null,null,null,null,null,"",null,"",""]
[363,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Comptes de l'Association Sportive"]
[364,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(D1=\"\",\"\",D1)","v":""},{"$f":"IF(D2=\"\",\"\",D2)","v":""}]
[365,null,null,null,null,null,"",null,"",""]
[366,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Etat des comptes par poste"]
[367,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dépenses","Recettes","Solde"]
[368,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Affiliation",0,0,{"$f":"IF(BH375=\"\",\"\",BJ375-BI375)","v":0}]
[369,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assurances",0,0,{"$f":"IF(BH376=\"\",\"\",BJ376-BI376)","v":0}]
[370,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Autres",0,0,0]
[371,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contrat",0,0,0]
[372,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cross Chèques",0,0,0]
[373,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cross Espèces",0,0,0]
[374,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dépenses Cross",0,0,0]
[375,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dépenses Lavages",0,0,0]
[376,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dépenses Matériel",0,0,0]
[377,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dépenses Ski",0,0,0]
[378,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Frais Compte",0,0,0]
[379,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lavage voitures Chèques",0,0,0]
[380,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lavage Voitures Espèces",0,0,0]
[381,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Licences Chèques",0,0,0]
[382,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Licences Espèces",0,0,0]
[383,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maison de la Danse Chèques",0,0,0]
[384,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maison de la Danse espèces",0,0,0]
[385,null,null,null,null,null,"",null,{"$f":"IF(H392=\"\",\"\",E392)","v":""},{"$f":"IF(H392=\"\",\"\",F392)","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,"Ski Chèques",0,0,0]
[386,null,null,null,null,null,{"$f":"IF(COUNT(E393:F393)=0,\"\",IF(F393=\"\",G392-E393,G392+F393))","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,"Ski Espèces",0,0,0]
[387,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subvention",0,0,0]
[388,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transport",0,0,0]
[389,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[390,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[391,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[392,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[393,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[394,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[395,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[396,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[397,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[398,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[399,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[400,null,null,null,null,null,"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total ",{"$f":"SUM(BI375:BI406)","v":0},{"$f":"SUM(BJ375:BJ406)","v":0},{"$f":"SUM(BK375:BK406)","v":0}]
[401,null,null,null,null,null,"",null,"",""]
[402,null,null,null,null,null,"",null,"",""]
[403,null,null,null,null,null,"",null,"",""]
[404,null,null,null,null,null,"",null,"",""]
[405,null,null,null,null,null,"",null,"",""]
[406,null,null,null,null,null,"",null,"",""]
[407,null,null,null,null,null,"",null,"",""]
[408,null,null,null,null,null,"",null,"",""]
[409,null,null,null,null,null,"",null,"",""]
[410,null,null,null,null,null,"",null,"",""]
[411,null,null,null,null,null,"",null,"",""]
[412,null,null,null,null,null,"",null,"",""]
[413,null,null,null,null,null,"",null,"",""]
[414,null,null,null,null,null,"",null,"",""]
[415,null,null,null,null,null,"",null,"",""]
[]
[]
[]
[]
[]
[null,null,null,"Etat des comptes par poste"]
[null,null,null,null,"Dépenses","Recettes"]
[null,null,null,{"$f":"IF(Paramètres!D8=\"\",\"\",Paramètres!D8)","v":"Affiliation"},{"$f":"IF(D430=\"\",\"\",SUMIF($C$8:$C$422,D430,$E$8:$E$422))","v":0},{"$f":"IF(D430=\"\",\"\",SUMIF($C$8:$C$422,D430,$F$8:$F$422))","v":0}]
[null,null,null,{"$f":"IF(Paramètres!D9=\"\",\"\",Paramètres!D9)","v":"Assurances"},{"$f":"IF(D431=\"\",\"\",SUMIF($C$8:$C$422,D431,$E$8:$E$422))","v":0},{"$f":"IF(D431=\"\",\"\",SUMIF($C$8:$C$422,D431,$F$8:$F$422))","v":0}]
[null,null,null,{"$f":"IF(Paramètres!D10=\"\",\"\",Paramètres!D10)","v":"Autres"},0,0]
[null,null,null,{"$f":"IF(Paramètres!D11=\"\",\"\",Paramètres!D11)","v":"Contrat"},0,0]
[null,null,null,{"$f":"IF(Paramètres!D12=\"\",\"\",Paramètres!D12)","v":"Cross Chèques"},0,0]
[null,null,null,{"$f":"IF(Paramètres!D13=\"\",\"\",Paramètres!D13)","v":"Cross Espèces"},0,0]
[null,null,null,{"$f":"IF(Paramètres!D14=\"\",\"\",Paramètres!D14)","v":"Dépenses Cross"},0,0]
[null,null,null,{"$f":"IF(Paramètres!D15=\"\",\"\",Paramètres!D15)","v":"Dépenses Lavages"},0,0]
[null,null,null,{"$f":"IF(Paramètres!D16=\"\",\"\",Paramètres!D16)","v":"Dépenses Matériel"},0,0,null,"Haut de page",null,null,"Imprimer"]
[null,null,null,{"$f":"IF(Paramètres!D17=\"\",\"\",Paramètres!D17)","v":"Dépenses Ski"},0,0]
[null,null,null,{"$f":"IF(Paramètres!D18=\"\",\"\",Paramètres!D18)","v":"Frais Compte"},0,0]
[null,null,null,{"$f":"IF(Paramètres!D19=\"\",\"\",Paramètres!D19)","v":"Lavage voitures Chèques"},0,0]
[null,null,null,{"$f":"IF(Paramètres!D20=\"\",\"\",Paramètres!D20)","v":"Lavage Voitures Espèces"},0,0]
[null,null,null,{"$f":"IF(Paramètres!D21=\"\",\"\",Paramètres!D21)","v":"Licences Chèques"},0,0]
[null,null,null,{"$f":"IF(Paramètres!D22=\"\",\"\",Paramètres!D22)","v":"Licences Espèces"},0,0]
[null,null,null,{"$f":"IF(Paramètres!D23=\"\",\"\",Paramètres!D23)","v":"Maison de la Danse Chèques"},0,0]
[null,null,null,{"$f":"IF(Paramètres!D24=\"\",\"\",Paramètres!D24)","v":"Maison de la Danse espèces"},0,0]
[null,null,null,{"$f":"IF(Paramètres!D25=\"\",\"\",Paramètres!D25)","v":"Ski Chèques"},0,0]
[null,null,null,{"$f":"IF(Paramètres!D26=\"\",\"\",Paramètres!D26)","v":"Ski Espèces"},0,0]
[null,null,null,{"$f":"IF(Paramètres!D27=\"\",\"\",Paramètres!D27)","v":"Subvention"},0,0]
[null,null,null,{"$f":"IF(Paramètres!D28=\"\",\"\",Paramètres!D28)","v":"Transport"},0,0]
[null,null,null,{"$f":"IF(Paramètres!D29=\"\",\"\",Paramètres!D29)","v":""},"",""]
[null,null,null,{"$f":"IF(Paramètres!D30=\"\",\"\",Paramètres!D30)","v":""},"",""]
[null,null,null,{"$f":"IF(Paramètres!D31=\"\",\"\",Paramètres!D31)","v":""},"",""]
[null,null,null,{"$f":"IF(Paramètres!D32=\"\",\"\",Paramètres!D32)","v":""},"",""]
[null,null,null,{"$f":"IF(Paramètres!D33=\"\",\"\",Paramètres!D33)","v":""},"",""]
[null,null,null,{"$f":"IF(Paramètres!D34=\"\",\"\",Paramètres!D34)","v":""},"",""]
[null,null,null,{"$f":"IF(Paramètres!D35=\"\",\"\",Paramètres!D35)","v":""},"",""]
[null,null,null,{"$f":"IF(Paramètres!D36=\"\",\"\",Paramètres!D36)","v":""},"",""]
[null,null,null,{"$f":"IF(Paramètres!D37=\"\",\"\",Paramètres!D37)","v":""},"",""]