{"text_format":"1","workbook":"xlsx","n_sheets":29,"sheets":["Table des matières","Identification","Gestionnaires","Gestion impression","Reports","Caisse 1","AP sortie","Impression PV caisse","PV de remise-reprise","Impression Cpte fin de gestion","Caisse 2","AP sortie 2","Impression PV caisse (2)","PV de remise-reprise (2)","Impression Cpte fin de gest (2)","Caisse 3","AP sortie 3","Impression PV caisse (3)","PV de remise-reprise (3)","Impression Cpte fin de gest (3)","1er semestre","2ème semestre","Jaune 31-12","Compte scindé","Compte scindé 30 juin","Compte scindé RR1","Compte scindé RR2","Compte scindé RR3","Contenu listes"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":4,"comments":6,"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":"Table des matières","index":0,"n_rows":5,"n_cols":14,"rows_kept":5,"cut":false,"hidden":false,"merged":[[4,13,5,14],[0,0,3,9],[4,1,5,2],[4,4,5,5],[4,7,5,8],[4,10,5,11]]}
["Fichier d'aide à la remise - reprise"]
[]
[]
[]
[null,"Généralités",null,null,"Infos nécessaires au compte scindé",null,null,"Remise-reprise 1",null,null,"Remise-reprise 2",null,null,"Reprise-reprise 3"]

{"sheet":"Identification","index":1,"n_rows":344,"n_cols":12,"rows_kept":344,"cut":false,"hidden":false,"merged":[[4,11,15,17]]}
[null,"SEL",null,"Etablissement","Rue, numéro","COPO","Commune"]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL DE LA CF","Avenue du Onze Novembre, 57",1040,"ETTERBEEK","CPMS","SGS-CPMS",410]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL DE LA CF","Avenue de l'Armée,117",1040,"BRUXELLES","CPMS","SGS-CPMS",418]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL DE LA CF","Avenue Marie de Hongrie, 60A",1083,"GANSHOREN","CPMS","SGS-CPMS",406]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL (SPECIAL)","Avenue Schaller, 89",1160,"BRUXELLES","CPMS","SGS-CPMS",431,null,"Veuillez marquer d'un \"X\" dans la colonne bleue, uniquement la ligne correspondante à votre établissement."]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL DE LA CF","Avenue Kamerdelle, 15",1180,"UCCLE","CPMS","SGS-CPMS",425]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL DE LA CF","Avenue Jacques Brel, 30",1200,"WOLUWE-SAINT-LAMBERT","CPMS","SGS-CPMS",430]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL DE LA CF","Chaussée de Louvain, 72",1300,"WAVRE","CPMS","SGS-CPMS",429]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL DE LA CF","Avenue du Burlet, 23",1400,"NIVELLES","CPMS","SGS-CPMS",417]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL DE LA CF","Rue Saint Léonard, 378",4000,"LIEGE","CPMS","SGS-CPMS",411]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL ","Rue de l'Eglise, 99",4030,"CHENEE ","CPMS","SGS-CPMS",439]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL DE LA CF","Rue du Marais, 35",4100,"SERAING","CPMS","SGS-CPMS",419]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL ","Rue Gustave Renier, 19",4300,"WAREMME","CPMS","SGS-CPMS",440]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL (SPECIAL)","Grand'Route, 197",4400,"FLEMALLE","CPMS","SGS-CPMS",433]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL DE LA CF","Rue des Augustins, 11",4500,"HUY","CPMS","SGS-CPMS",409]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL DE LA CF","Rue de la Wade, 9",4600,"VISE","CPMS","SGS-CPMS",428]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL DE LA CF","Rue du Palais, 27  Bte 5",4800,"VERVIERS","CPMS","SGS-CPMS",426]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL (SPECIAL)","Rue des Wallons, 42",4800,"VERVIERS","CPMS","SGS-CPMS",438]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL DE LA CF","Rue de la Sauvenière, 10A",4900,"SPA","CPMS","SGS-CPMS",421]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL DE LA CF","Rue de Bruxelles, 34B",5000,"NAMUR","CPMS","SGS-CPMS",415]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL DE LA CF","Rue Entrée Jacques, 68",5030,"GEMBLOUX","CPMS","SGS-CPMS",407]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL DE LA CF","Rue Reine Elisabeth, 26",5060,"TAMINES","CPMS","SGS-CPMS",422]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL (SPECIAL)","Rue de Géronsart, 160",5100,"JAMBES","CPMS","SGS-CPMS",434]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL DE LA CF","Rue St Pierre, 139",5500,"DINANT","CPMS","SGS-CPMS",404]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL (SPECIAL)","Rue de la Calamine, 36",5600,"PHILIPPEVILLE","CPMS","SGS-CPMS",437]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL ","Rue du Bercet, 2",5660,"COUVIN","CPMS","SGS-CPMS",441]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL DE LA CF","Rue de la Science, 38",6000,"CHARLEROI","CPMS","SGS-CPMS",403]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL DE LA CF","Place des Martyrs, 31",6041,"GOSSELIES","CPMS","SGS-CPMS",408]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL (SPECIAL)","Rue des Gravelles, 49",6200,"CHATELET","CPMS","SGS-CPMS",432]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL DE LA CF","Drève des Alliés, 9A",6530,"THUIN","CPMS","SGS-CPMS",423]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL DE LA CF","Rue de Sesselich, 61",6700,"ARLON","CPMS","SGS-CPMS",401]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL DE LA CF","Faubourg d'Arival, 39",6760,"VIRTON","CPMS","SGS-CPMS",427]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL DE LA CF","Avenue de la Gare, 10",6840,"NEUFCHATEAU","CPMS","SGS-CPMS",416]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL DE LA CF","Avenue de la Toison d'Or, 75",6900,"MARCHE-EN-FAMENNE","CPMS","SGS-CPMS",412]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL (SPECIAL)","Rue Mionvaux, 35",6900,"MARLOIE","CPMS","SGS-CPMS",435]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL DE LA CF","Avenue du Champ de Mars, 2",7000,"MONS","CPMS","SGS-CPMS",413]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL (SPECIAL)","Chaussée du Roeulx, 122",7000,"MONS","CPMS","SGS-CPMS",436]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL DE LA CF","Rue Léon Hachez, 38",7060,"SOIGNIES","CPMS","SGS-CPMS",420]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL DE LA CF","Rue Léon Moyaux, 82",7140,"MORLANWELZ","CPMS","SGS-CPMS",414]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL DE LA CF","Rue de l'Athénée, 37",7370,"DOUR","CPMS","SGS-CPMS",405]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL DE LA CF","Rue Beyaert, 39",7500,"TOURNAI","CPMS","SGS-CPMS",424]
[null,null,null,"CENTRE PSYCHO-MEDICO-SOCIAL DE LA CF","Boulevard de l'Hôpital, 32",7800,"ATH","CPMS","SGS-CPMS",402]
[null,null,null,"EF CF DE HAMME-MILLE","RUE RENÉ MÉNADA, 12",1320,"HAMME-MILLE (BEAUVECHAIN)","FONDAMENTAL","SGS-FO",222]
[null,null,null,"EF CF DE GENTINNES","PLACE DE GENTINNES, 14",1450,"GENTINNES (CHASTRE)","FONDAMENTAL","SGS-FO",217]
[null,null,null,"EF CF DE NIL-ST-VINCENT","RUE WARICHET, 1",1457,"NIL-SAINT-VINCENT (WALHAIN)","FONDAMENTAL","SGS-FO",244]
[null,null,null,"EF CF DE TUBIZE-CENTRE","RUE FERRER, 15",1480,"TUBIZE","FONDAMENTAL","SGS-FO",255]
[null,null,null,"EF CF DE TUBIZE-RENARD","RUE DE STIMBERT, 8",1480,"TUBIZE","FONDAMENTAL","SGS-FO",256]
[null,null,null,"EF CF DE FERRIÈRES","RUE PRÉ DU FA, 7",4190,"FERRIERES","FONDAMENTAL","SGS-FO",211]
[null,null,null,"EF CF DE BURDINNE-CIPLET","RUE DE VOÏD, 2",4260,"CIPLET (BRAIVES)","FONDAMENTAL","SGS-FO",204]
[null,null,null,"EF CF DE CRISNÉE","RUE JEAN STASSART, 15",4367,"CRISNEE (FIZE-LE-MARSAL)","FONDAMENTAL","SGS-FO",205]
[null,null,null,"EF CF DE HERVE-BATTICE","RUE DES ECOLES, 23",4650,"HERVE","FONDAMENTAL","SGS-FO",226]
[null,null,null,"EF CF DE EBEN-EMAEL","RUE HAUTE, 65",4690,"EBEN-EMAEL","FONDAMENTAL","SGS-FO",206]
[null,null,null,"EF CF DE HEUSY","AVENUE DU CHAÎNEUX, 30",4802,"HEUSY (VERVIERS)","FONDAMENTAL","SGS-FO",227]
[null,null,null,"EF CF DE LIMBOURG","RUE GUILLAUME MAISIER, 56",4830,"LIMBOURG","FONDAMENTAL","SGS-FO",233]
[null,null,null,"EF CF DE STOUMONT","RUE DE L'AMBLÈVE, 24",4987,"STOUMONT","FONDAMENTAL","SGS-FO",250]
[null,null,null,"EF CF DE LIERNEUX","RUE DEVANT LA VAUX, 2",4990,"LIERNEUX","FONDAMENTAL","SGS-FO",232]
[null,null,null,"EF CF DE MALONNE","RUE D'INSEVAUX, 72",5020,"MALONNE (NAMUR)","FONDAMENTAL","SGS-FO",234]
[null,null,null,"EF CF DE VEDRIN","RUE PARMENTIER, 2",5020,"VEDRIN (NAMUR)","FONDAMENTAL","SGS-FO",257]
[null,null,null,"EF CF D'AUVELAIS","RUE WILLY FÉLIX, 5",5060,"AUVELAIS (SAMBREVILLE)","FONDAMENTAL","SGS-FO",202]
[null,null,null,"EF CF DE FALISOLLE","RUE DE LA LOGETTE, 4",5060,"FALISOLLE (SAMBREVILLE)","FONDAMENTAL","SGS-FO",210]
[null,null,null,"EF CF DE TAMINES","RUE DE L'ENSEIGNEMENT, 25",5060,"TAMINES (SAMBREVILLE)","FONDAMENTAL","SGS-FO",252]
[null,null,null,"EF CF DE SOMBREFFE","CHAUSSÉE DE NIVELLES, 79-81",5140,"SOMBREFFE","FONDAMENTAL","SGS-FO",248]
[null,null,null,"EF CF DE MOUSTIER S/SAMBRE","RUE DE LA STATION, 113",5190,"MOUSTIER S/S (JEMEPPE S/S)","FONDAMENTAL","SGS-FO",242]
[null,null,null,"EF CF DE SPY","RUE HAUTE, 60",5190,"SPY (JEMEPPE S/SAMBRE)","FONDAMENTAL","SGS-FO",249]
[null,null,null,"EF CF \"YANNICK LEROY\" D'EGHEZEE","ROUTE DE GEMBLOUX, 10",5310,"EGHEZEE","FONDAMENTAL","SGS-FO",207]
[null,null,null,"EF CF DE GESVES","CHAUSSÉE DE GRAMPTINNE, 118",5340,"GESVES","FONDAMENTAL","SGS-FO",219]
[null,null,null,"EF CF D'ANHÉE","RUE GRANDE , 57",5537,"ANHEE","FONDAMENTAL","SGS-FO",201]
[null,null,null,"EF CF DE HASTIÈRE-LAVAUX","PLACE EMILE BINET,1",5540,"HASTIERE","FONDAMENTAL","SGS-FO",223]
[null,null,null,"EF CF  \"CROIX-SCAILLE\" DE GEDINNE","RUE DE LA CROISETTE, 13",5575,"GEDINNE","FONDAMENTAL","SGS-FO",216]
[null,null,null,"EF CF DE HAVERSIN","RUE DE HAID, 19",5590,"HAVERSIN (CINEY)","FONDAMENTAL","SGS-FO",224]
[null,null,null,"EF CF DE METTET","RUE CROIX DE BOURGOGNE, 12",5640,"METTET","FONDAMENTAL","SGS-FO",239]
[null,null,null,"EF CF DE WALCOURT","RUE DES BERGERIES, 4",5650,"WALCOURT","FONDAMENTAL","SGS-FO",259]
[null,null,null,"EF CF DE TRAZEGNIES","RUE DES CLOUTIERS,",6183,"TRAZEGNIES (COURCELLES)","FONDAMENTAL","SGS-FO",254]
[null,null,null,"EF CF DE FRASNES-LEZ-GOSSELIES","RUE ZÉPHIRIN FLANDRE, 10",6210,"FRASNES-LEZ-GOSSELIES","FONDAMENTAL","SGS-FO",215]
[null,null,null,"EF CF DE GERPINNES","RUE DE BERTRANSART, 6",6280,"GERPINNES","FONDAMENTAL","SGS-FO",218]
[null,null,null,"EF CF DE MOMIGNIES","RUE DE LA GENDARMERIE, 10",6590,"MOMIGNIES","FONDAMENTAL","SGS-FO",240]
[null,null,null,"EF CF DE MARTELANGE","RUE DE LA POSTE, 10",6630,"MARTELANGE","FONDAMENTAL","SGS-FO",236]
[null,null,null,"EF CF DE SIBRET","VIRÉE DU RENARD, 6",6640,"SIBRET (VAUX-SUR-SURE)","FONDAMENTAL","SGS-FO",247]
[null,null,null,"EF CF DE HABAY","RUE DE LA COURTIERE, 19",6720,"HABAY","FONDAMENTAL","SGS-FO",261]
[null,null,null,"EF CF DE MARBEHAN","RUE DES PRÉS, 1",6724,"MARBEHAN (HABAY)","FONDAMENTAL","SGS-FO",235]
[null,null,null,"EF CF D'ETALLE","RUE DU TERMEZART, 16",6740,"ETALLE","FONDAMENTAL","SGS-FO",208]
[null,null,null,"EF CF DE MUSSON","PLACE ABBÉ GOFFINET, 22",6750,"MUSSON","FONDAMENTAL","SGS-FO",243]
[null,null,null,"EF CF DE SAINT-MARD","RUE DU TEMPLE, 2",6762,"SAINT-MARD (VIRTON)","FONDAMENTAL","SGS-FO",246]
[null,null,null,"EF CF DE MESSANCY","GRAND RUE, 108",6780,"MESSANCY","FONDAMENTAL","SGS-FO",238]
[null,null,null,"EF CF DE HALANZY","RUE MATHIEU, 48",6792,"HALANZY (AUBANGE)","FONDAMENTAL","SGS-FO",221]
[null,null,null,"EF CF DE FLORENVILLE","RUE DU MIROIR, 7",6820,"FLORENVILLE","FONDAMENTAL","SGS-FO",213]
[null,null,null,"EF CF DE LIBIN","RUE DU CURÉ, 13",6890,"LIBIN","FONDAMENTAL","SGS-FO",231]
[null,null,null,"EF CF DE WELLIN","RUE DE LA STATION, 31",6920,"WELLIN","FONDAMENTAL","SGS-FO",260]
[null,null,null,"EF CF DE FORRIÈRES","RUE DE LA RAMÉE, 19",6953,"FORRIERES (NASSOGNE)","FONDAMENTAL","SGS-FO",214]
[null,null,null,"EF CF DE HOTTON","AVENUE DE LA GARE, 42",6990,"HOTTON","FONDAMENTAL","SGS-FO",228]
[null,null,null,"EF CF DE JURBISE","RUE DU MOUSTIER, 3",7050,"JURBISE","FONDAMENTAL","SGS-FO",230]
[null,null,null,"EF CF \"ECOLE SOLAIRE\" DE TOURNAI","BOULEVARD LÉOPOLD, 6",7500,"TOURNAI","FONDAMENTAL","SGS-FO",253]
[null,null,null,"EF CF DE TAINTIGNIES","RUE DES BOIS, 31",7618,"TAINTIGNIES (RUMES)","FONDAMENTAL","SGS-FO",251]
[null,null,null,"EF CF DE ANTOING","PLACE BARA 10",7640,"ANTOING","FONDAMENTAL","SGS-FO",262]
[null,null,null,"EF CF DE HERSEAUX","RUE DES FRONTALIERS, 42",7712,"HERSEAUX (MOUSCRON)","FONDAMENTAL","SGS-FO",225]
[null,null,null,"EF CF DE FLOBECQ","RUE DE LA CRÊTE, 32",7880,"FLOBECQ","FONDAMENTAL","SGS-FO",212]
[null,null,null,"EF CF DE QUEVAUCAMPS","RUE WAUTERS, 60",7972,"QUEVAUCAMPS (BELOEIL)","FONDAMENTAL","SGS-FO",245]
[null,null,null,"I.E.P.S.C.F.  ANDERLECHT","RUE LEON DELACROIX 28",1070,"ANDERLECHT","PROMOTION SOCIALE","SGS-PS",501]
[null,null,null,"I.E.P.S.C.F. EVERE","AVENUE CONSTANT PERMEKE 4",1140,"EVERE","PROMOTION SOCIALE","SGS-PS",510]
[null,null,null,"I.E.P.S.C.F. WOLUWE-SAINT-PIERRE","AVENUE ORBAN 73",1150,"WOLUWE-SAINT-PIERRE","PROMOTION SOCIALE","SGS-PS",531]
[null,null,null,"I.E.P.S.C.F. UCCLE","RUE GATTI DE GAMOND 95",1180,"UCCLE","PROMOTION SOCIALE","SGS-PS",527]
[null,null,null,"I.E.P.S.C.F. BRAINE L'ALLEUD","AVENUE DE MENDEN 21",1420,"BRAINE L'ALLEUD","PROMOTION SOCIALE","SGS-PS",505]
[null,null,null,"I.E.P.S.C.F. COURT-SAINT-ETIENNE","AVENUE PAUL HENRICOT 1",1490,"COURT - SAINT - ETIENNE","PROMOTION SOCIALE","SGS-PS",507]
[null,null,null,"I.E.P.S.C.F. WAREMME","RUE GUSTAVE RENIER 1",4300,"WAREMME","PROMOTION SOCIALE","SGS-PS",530]
[null,null,null,"I.E.P.S.C.F. ALLEUR","RUE GEORGES TRUFFAUT 37",4432,"ALLEUR","PROMOTION SOCIALE","SGS-PS",500]
[null,null,null,"I.E.P.S.C.F. GRACE-HOLLOGNE","RUE ANTOINE DEGIVE 1",4460,"GRACE-HOLLOGNE","PROMOTION SOCIALE","SGS-PS",512]
[null,null,null,"I.E.P.S.C.F. SAINT-GEORGES-SUR-MEUSE","RUE ELOI FOUARGE 31",4470,"SAINT-GEORGES-SUR-MEUSE","PROMOTION SOCIALE","SGS-PS",523]
[null,null,null,"I.E.P.S.C.F. SOUMAGNE","RUE DES PRAIRIES 40",4630,"SOUMAGNE","PROMOTION SOCIALE","SGS-PS",524]
[null,null,null,"I.E.P.S.C.F. BLEGNY","ESPACE SIMONE VEIL 7",4670,"BLEGNY","PROMOTION SOCIALE","SGS-PS",504]
[null,null,null,"I.E.P.S.C.F. VERVIERS","AVENUE JARDIN ECOLE 87",4820,"VERVIERS","PROMOTION SOCIALE","SGS-PS",528]
[null,null,null,"I.E.P.S.C.F. NAMUR CEFOR","BOULEVARD CAUCHY 9-10",5000,"NAMUR CEFOR","PROMOTION SOCIALE","SGS-PS",518]
[null,null,null,"I.E.P.S.C.F. NAMUR CADETS","PLACE DE L'ECOLE DES CADETS 6",5000,"NAMUR CADETS","PROMOTION SOCIALE","SGS-PS",519]
[null,null,null,"I.E.P.S.C.F. DINANT","DOMAINE D'HERBUCHENNE",5500,"DINANT","PROMOTION SOCIALE","SGS-PS",508]
[null,null,null,"I.E.P.S.C.F. PHILIPPEVILLE","AVENUE DE SAMART 2B BOITE 2",5600,"PHILIPPEVILLE","PROMOTION SOCIALE","SGS-PS",521]
[null,null,null,"I.E.P.S.C.F. RANCE","RUE PAULINE HUBERT 40/2",6470,"RANCE","PROMOTION SOCIALE","SGS-PS",522]
[null,null,null,"I.E.P.S.C.F. THUIN","DREVE DES ALLIES 11",6530,"THUIN","PROMOTION SOCIALE","SGS-PS",525]
[null,null,null,"I.E.P.S.C.F. VIELSALM","RUE DES CHASSEURS ARDENNAIS 1",6690,"VIELSALM","PROMOTION SOCIALE","SGS-PS",529]
[null,null,null,"I.E.P.S.C.F. ARLON","CHEMIN DE WEYLER 2",6700,"ARLON","PROMOTION SOCIALE","SGS-PS",502]
[null,null,null,"I.E.P.S.C.F. LIBRAMONT","AVENUE HERBOFIN 39",6800,"LIBRAMONT","PROMOTION SOCIALE","SGS-PS",514]
[null,null,null,"I.E.P.S.C.F. MARCHE-EN-FAMENNE","AVENUE DE LA TOISON D'OR 71",6900,"MARCHE-EN-FAMENNE","PROMOTION SOCIALE","SGS-PS",515]
[null,null,null,"I.E.P.S.C.F. JEMAPPES","AVENUE DU ROI ALBERT 643",7012,"JEMAPPES","PROMOTION SOCIALE","SGS-PS",513]
[null,null,null,"I.E.P.S.C.F. FRAMERIES","RUE DU ONZE NOVEMBRE 2",7080,"FRAMERIES","PROMOTION SOCIALE","SGS-PS",511]
[null,null,null,"I.E.P.S.C.F. MORLANWELZ","RUE RAOUL WAROCQUE 46",7140,"MORLANWELZ","PROMOTION SOCIALE","SGS-PS",516]
[null,null,null,"I.E.P.S.C.F. COLFONTAINE","RUE CLEMENCEAU 60-62",7340,"COLFONTAINE","PROMOTION SOCIALE","SGS-PS",506]
[null,null,null,"I.E.P.S.C.F. DOUR","RUE DE BOUSSU 84",7370,"DOUR","PROMOTION SOCIALE","SGS-PS",509]
[null,null,null,"I.E.P.S.C.F. TOURNAI","RUE SAINT-BRICE 53",7500,"TOURNAI","PROMOTION SOCIALE","SGS-PS",526]
[null,null,null,"I.E.P.S.C.F. PERUWELZ","BOULEVARD LEOPOLD III 40",7600,"PERUWELZ","PROMOTION SOCIALE","SGS-PS",520]
[null,null,null,"I.E.P.S.C.F. MOUSCRON","PLACE DE LA JUSTICE 1 BP 155",7700,"MOUSCRON","PROMOTION SOCIALE","SGS-PS",517]
[null,null,null,"I.E.P.S.C.F. ATH","RUE CARTON 5",7800,"ATH","PROMOTION SOCIALE","SGS-PS",503]
[null,null,null,"AR \"GATTI DE GAMOND\" DE BRUXELLES","RUE DU MARAIS 65",1000,"BRUXELLES","SECONDAIRE","SGS-SE",18]
[null,null,null,"IACF DE STROMBEEK","RUE DE MOLENBEEK 43",1020,"BRUXELLES","SECONDAIRE","SGS-SE",137]
[null,null,null,"AR DE BRUXELLES II","RUE MARIE-CHRISTINE 37",1020,"BRUXELLES","SECONDAIRE","SGS-SE",17]
[null,null,null,"AR \"RIVE GAUCHE\" DE BRUXELLES","RUE MARIE-CHRISTINE 83",1020,"BRUXELLES","SECONDAIRE","SGS-SE",20]
[null,null,null,"AR \"ALFRED VERWEE\" DE SCHAERBEEK","RUE VERWEE 12",1030,"BRUXELLES (SCHAERBEEK)","SECONDAIRE","SGS-SE",32]
[null,null,null,"AR \"JEAN ABSIL\" D'ETTERBEEK","AVENUE HANSEN-SOULIE 27",1040,"BRUXELLES (ETTERBEEK)","SECONDAIRE","SGS-SE",23]
[null,null,null,"AR \"MADELEINE JACQUEMOTTE\" D'IXELLES","RUE DE LA CROIX, 40",1050,"BRUXELLES (IXELLES)","SECONDAIRE","SGS-SE",27]
[null,null,null,"AR \"VICTOR HORTA\" DE ST-GILLES","RUE DE LA RHETORIQUE 16",1060,"BRUXELLES (ST-GILLES)","SECONDAIRE","SGS-SE",31]
[null,null,null,"IACF \"MAURICE CAREME\" D'ANDERLECHT","RUE DE SWAEF 27",1070,"ANDERLECHT","SECONDAIRE","SGS-SE",155]
[null,null,null,"AR LEONARDO DA VINCI","RUE CHOME-WYNS 5",1070,"BRUXELLES (ANDERLECHT)","SECONDAIRE","SGS-SE",21]
[null,null,null,"AR \"SERGE CREUZ\" DE MOLENBEEK-ST-JEAN","AVENUE DU SIPPELBERG 2",1080,"BRUXELLES (MOLENBEEK- ST-JEAN)","SECONDAIRE","SGS-SE",30]
[null,null,null,"AR DE KOEKELBERG","RUE OMER LEPREUX 15",1081,"BRUXELLES (KOEKELBERG)","SECONDAIRE","SGS-SE",29]
[null,null,null,"AR DE GANSHOREN","RUE AUGUSTE DE COCK 1",1083,"BRUXELLES (GANSHOREN)","SECONDAIRE","SGS-SE",26]
[null,null,null,"AR DE JETTE","AVENUE DE LEVIS MIREPOIX 100",1090,"BRUXELLES (JETTE)","SECONDAIRE","SGS-SE",28]
[null,null,null,"AR EVERE","AVENUE CONSTANT PERMEKE 2",1140,"BRUXELLES (EVERE)","SECONDAIRE","SGS-SE",24]
[null,null,null,"AR \"CROMMELYNCK\" DE WOLUWE-ST-PIERRE","AVENUE ORBAN 73",1150,"BRUXELLES (WOLUWÉ-ST-PIERRE)","SECONDAIRE","SGS-SE",37]
[null,null,null,"AR D'AUDERGHEM","AVENUE DU PARC DE WOLUWE 25-27",1160,"BRUXELLES (AUDERGHEM)","SECONDAIRE","SGS-SE",22]
[null,null,null,"AR DE WATERMAEL-BOITSFORT","RUE DE LA BERGERETTE",1170,"BRUXELLES (WATERMAEL-BOITSFORT)","SECONDAIRE","SGS-SE",35]
[null,null,null,"AR D' UCCLE I","AVENUE HOUZEAU 87",1180,"BRUXELLES (UCCLE)","SECONDAIRE","SGS-SE",33]
[null,null,null,"AR D' UCCLE II","AVENUE DES TILLEULS 24",1180,"BRUXELLES (UCCLE)","SECONDAIRE","SGS-SE",34]
[null,null,null,"AR \"ANDREE THOMAS\" DE FOREST","AVENUE REINE MARIE-HENRIETTE 47",1190,"BRUXELLES (FOREST)","SECONDAIRE","SGS-SE",25]
[null,null,null,"AR DE WOLUWE-SAINT-LAMBERT","RUE DE L'ATHENEE ROYAL 75 77",1200,"BRUXELLES (WOLUWÉ-ST-LAMBERT)","SECONDAIRE","SGS-SE",36]
[null,null,null,"IACF \"FOLON\" DE WAVRE","CHAUSSEE DES NERVIENS 25",1300,"WAVRE","SECONDAIRE","SGS-SE",153]
[null,null,null,"AR \"MAURICE CAREME\" DE WAVRE","AVENUE HENRI LEPAGE 4 6",1300,"WAVRE","SECONDAIRE","SGS-SE",134]
[null,null,null,"AR DE RIXENSART","RUE ALBERT CROY 3",1330,"RIXENSART","SECONDAIRE","SGS-SE",106]
[null,null,null,"AR \"PAUL DELVAUX\" D'OTTIGNIES","AVENUE DES VILLAS 15",1340,"OTTIGNIES-LOUVAIN-LA-NEUVE (OTTIGNIES)","SECONDAIRE","SGS-SE",98]
[null,null,null,"AR DE JODOIGNE","CHAUSSEE DE HANNUT 61",1370,"JODOIGNE","SECONDAIRE","SGS-SE",71]
[null,null,null,"IACF DE NIVELLES","BOITE POSTALE 535",1400,"NIVELLES","SECONDAIRE","SGS-SE",145]
[null,null,null,"AR DE NIVELLES","AVENUE DU CENTENAIRE 34",1400,"NIVELLES","SECONDAIRE","SGS-SE",97]
[null,null,null,"AR DE WATERLOO","RUE DE LA STATION 118",1410,"WATERLOO","SECONDAIRE","SGS-SE",133]
[null,null,null,"AR \"RIVA-BELLA\" DE BRAINE-L'ALLEUD","SQUARE RIVA-BELLA",1420,"BRAINE-L'ALLEUD","SECONDAIRE","SGS-SE",15]
[null,null,null,"AR \"CHARLES ROGIER\" DE LIEGE","RUE DES CLARISSES 13",4000,"LIEGE","SECONDAIRE","SGS-SE",76]
[null,null,null,"AR \"FRAGNEE\" DE LIEGE","RUE DE FRAGNEE 73",4000,"LIEGE","SECONDAIRE","SGS-SE",77]
[null,null,null,"AR \"LIEGE ATLAS\" DE LIEGE","QUAI SAINT-LEONARD 80",4000,"LIEGE","SECONDAIRE","SGS-SE",78]
[null,null,null,"AR \"CHARLEMAGNE\" DE JUPILLE","RUE DE BOIS DE BREUX",4020,"LIEGE (JUPILLE-SUR-MEUSE)","SECONDAIRE","SGS-SE",80]
[null,null,null,"AR DE CHENEE","RUE BOURDON 32",4032,"LIEGE (CHENEE)","SECONDAIRE","SGS-SE",79]
[null,null,null,"AR DE HERSTAL","RUE JEAN LAMBERT SAUVEUR",4040,"HERSTAL","SECONDAIRE","SGS-SE",67]
[null,null,null,"AR \"AIR PUR\" DE SERAING","RUE DES NATIONS-UNIES 1",4100,"SERAING","SECONDAIRE","SGS-SE",113]
[null,null,null,"AR \"LUCIE DEJARDIN\" DE SERAING","RUE DE L'INDUSTRIE 127",4100,"SERAING","SECONDAIRE","SGS-SE",114]
[null,null,null,"AR D'ESNEUX","RUE DE L'ATHENEE 6",4130,"ESNEUX","SECONDAIRE","SGS-SE",58]
[null,null,null,"IACF DE FERRIERES","ROUTE DES ARDENNES 1",4190,"FERRIERES","SECONDAIRE","SGS-SE",55]
[null,null,null,"AR DE HANNUT","RUE DE TIRLEMONT 22",4280,"HANNUT","SECONDAIRE","SGS-SE",66]
[null,null,null,"AR DE WAREMME","RUE GUSTAVE RENIER",4300,"WAREMME","SECONDAIRE","SGS-SE",132]
[null,null,null,"AR DE MONTEGNÉE - GRACE-HOLLOGNE","RUE FELIX BERNARD 1",4420,"SAINT-NICOLAS (MONTEGNÉE)","SECONDAIRE","SGS-SE",111]
[null,null,null,"AR D'ALLEUR","RUE GEORGES TRUFFAUT 37",4432,"ANS (ALLEUR)","SECONDAIRE","SGS-SE",2]
[null,null,null,"AR DE ST-GEORGES-SUR-MEUSE","RUE ELOI FOUARGE 31",4470,"SAINT-GEORGES-SUR-MEUSE","SECONDAIRE","SGS-SE",108]
[null,null,null,"IACF \"FILLES\" DE HUY","PLACE ST-DENIS 3",4500,"HUY","SECONDAIRE","SGS-SE",140]
[null,null,null,"ITCF DE HUY","RUE SAINT-VICTOR 5",4500,"HUY","SECONDAIRE","SGS-SE",69]
[null,null,null,"AR DE HUY","QUAI D'ARONA 5",4500,"HUY","SECONDAIRE","SGS-SE",68]
[null,null,null,"AR \"PRINCE BAUDOUIN\" DE MARCHIN","RUE FOURNEAU 40",4570,"MARCHIN","SECONDAIRE","SGS-SE",83]
[null,null,null,"AR D'OUFFET","RUE MOGNEE 21",4590,"OUFFET","SECONDAIRE","SGS-SE",99]
[null,null,null,"AR DE VISE","RUE DU GOLLET 2",4600,"VISE","SECONDAIRE","SGS-SE",130]
[null,null,null,"AR DE SOUMAGNE","RUE DES PRAIRIES",4630,"SOUMAGNE","SECONDAIRE","SGS-SE",118]
[null,null,null,"AR \"THIL LORRAIN\" DE VERVIERS","RUE THIL LORRAIN 1 3",4800,"VERVIERS","SECONDAIRE","SGS-SE",126]
[null,null,null,"AR \"VERDI\" DE VERVIERS","RUE DES WALLONS 57",4800,"VERVIERS","SECONDAIRE","SGS-SE",127]
[null,null,null,"IACF DE DOLHAIN-LIMBOURG","HORS LES PORTES 71",4830,"DOLHAIN-LIMBOURG","SECONDAIRE","SGS-SE",142]
[null,null,null,"AR DE WELKENRAEDT","RUE GERARD DELVOYE 2",4840,"WELKENRAEDT","SECONDAIRE","SGS-SE",135]
[null,null,null,"AR DE PEPINSTER","RUE DES JARDINS 4",4860,"PEPINSTER","SECONDAIRE","SGS-SE",101]
[null,null,null,"IACF \"LE BRITANNIQUE\" DE SPA","RUE DE LA SAUVENIERE 8",4900,"SPA","SECONDAIRE","SGS-SE",149]
[null,null,null,"IACF \"LOUISE WEISS\" DE SPA","AVENUE MARIE-HENRIETTE 28",4900,"SPA","SECONDAIRE","SGS-SE",150]
[null,null,null,"ATHENEE ROYAL ET ECOLE D'HOTELLERIE DE SPA","RUE DES CAPUCINS 8",4900,"SPA","SECONDAIRE","SGS-SE",120]
[null,null,null,"AR D'AYWAILLE","AVENUE FRANCOIS CORNESSE 48",4920,"AYWAILLE","SECONDAIRE","SGS-SE",8]
[null,null,null,"AR DE WAIMES","RUE DES HETRES 2 A",4950,"WAIMES","SECONDAIRE","SGS-SE",131]
[null,null,null,"AR \"ARDENNE - HAUTES FAGNES\" DE MALMEDY","ROUTE DE FALIZE 21",4960,"MALMEDY","SECONDAIRE","SGS-SE",81]
[null,null,null,"ITCF \"FELICIEN ROPS\" DE NAMUR","RUE DU QUATRIEME GENIE 2",5000,"NAMUR","SECONDAIRE","SGS-SE",91]
[null,null,null,"ITCF \"HENRI MAUS\" DE NAMUR","PLACE DE L'ECOLE DES CADETS 4",5000,"NAMUR","SECONDAIRE","SGS-SE",92]
[null,null,null,"LYCEE DE LA CF DE NAMUR","RUE LELIEVRE 10",5000,"NAMUR","SECONDAIRE","SGS-SE",93]
[null,null,null,"AR \"FRANCOIS BOVESSE\" DE NAMUR","RUE DU COLLEGE 8",5000,"NAMUR","SECONDAIRE","SGS-SE",90]
[null,null,null,"IACF DE ST SERVAIS","RUE MUZET 47",5002,"ST SERVAIS","SECONDAIRE","SGS-SE",144]
[null,null,null,"IACF \"SUARLEE\" DE NAMUR","CHAUSSEE DE NIVELLES 204",5020,"NAMUR","SECONDAIRE","SGS-SE",156]
[null,null,null,"I T C F \"AGRO-ALIMENTAIRES\" DE SUARLEE","CHAUSSEE DE NIVELLES 204",5020,"NAMUR (SUARLÉE)","SECONDAIRE","SGS-SE",95]
[null,null,null,"IACF GEMBLOUX","RUE VERLAINE 22",5030,"GEMBLOUX","SECONDAIRE","SGS-SE",158]
[null,null,null,"ITCF DE GEMBLOUX","RUE VERLAINE 5",5030,"GEMBLOUX","SECONDAIRE","SGS-SE",65]
[null,null,null,"AR DE GEMBLOUX","RUE GUSTAVE DOCQ 26",5030,"GEMBLOUX","SECONDAIRE","SGS-SE",64]
[null,null,null,"AR DE TAMINES","AVENUE PRESIDENT ROOSEVELT 57",5060,"SAMBREVILLE (TAMINES)","SECONDAIRE","SGS-SE",112]
[null,null,null,"AR DE JAMBES","RUE DE GERONSART 150",5100,"NAMUR (JAMBES)","SECONDAIRE","SGS-SE",94]
[null,null,null,"AR \"BAUDOUIN 1ER\" DE JEMEPPE-SUR-SAMBRE","RUE FRANCOIS HITTELET 129",5190,"JEMEPPE-SUR-SAMBRE","SECONDAIRE","SGS-SE",70]
[null,null,null,"IACF ANDENNE","RUE DE L'HOPITAL, 3",5300,"ANDENNE","SECONDAIRE","SGS-SE",157]
[null,null,null,"AR \"JEAN TOUSSEUL\" D'ANDENNE","RUE ADELINE HENIN 4",5300,"ANDENNE","SECONDAIRE","SGS-SE",1]
[null,null,null,"ITCF DE DINANT","DOMAINE D'HERBUCHENNE",5500,"DINANT","SECONDAIRE","SGS-SE",53]
[null,null,null,"AR \"ADOLPHE SAX\" DE DINANT","RUE SAINT-PIERRE 90",5500,"DINANT","SECONDAIRE","SGS-SE",52]
[null,null,null,"AR  \"NORBERT COLLARD\" DE BEAURAING","RUE DE DINANT 23",5570,"BEAURAING","SECONDAIRE","SGS-SE",11]
[null,null,null,"AR \"ROBERT GRUSLIN\" DE ROCHEFORT","RUE JACQUET 102",5580,"ROCHEFORT","SECONDAIRE","SGS-SE",107]
[null,null,null,"AR \"JULES DELOT\" DE CINEY","SQUARE OMER BERTRAND 1",5590,"CINEY","SECONDAIRE","SGS-SE",49]
[null,null,null,"IACF \"ANNE FRANK\" DE PHILIPPEVILLE","AVENUE DE SAMART 2 A",5600,"PHILIPPEVILLE","SECONDAIRE","SGS-SE",148]
[null,null,null,"AR DE PHILIPPEVILLE","AVENUE DE SAMART 2 B",5600,"PHILIPPEVILLE","SECONDAIRE","SGS-SE",103]
[null,null,null,"IACF DE COUVIN","DESSUS DE LA VILLE 3, BTE 37",5660,"COUVIN","SECONDAIRE","SGS-SE",139]
[null,null,null,"AR \"JEAN REY\" DE COUVIN","LA CROISETTE 1",5660,"COUVIN","SECONDAIRE","SGS-SE",51]
[null,null,null,"AR \"ERNEST SOLVAY\" DE CHARLEROI","BOULEVARD EMILE DEVREUX 27",6000,"CHARLEROI","SECONDAIRE","SGS-SE",38]
[null,null,null,"AR \"VAUBAN\" DE CHARLEROI","RUE EMILE TUMELAIRE 12",6000,"CHARLEROI","SECONDAIRE","SGS-SE",39]
[null,null,null,"AR \"JULES DESTREE\" DE MARCINELLE","RUE DES HAIES 76",6001,"CHARLEROI (MARCINELLE)","SECONDAIRE","SGS-SE",44]
[null,null,null,"AR DE MARCHIENNE-AU-PONT","RUE DES REMPARTS 35",6030,"CHARLEROI (MARCHIENNE-AU-PONT)","SECONDAIRE","SGS-SE",43]
[null,null,null,"AR \"ORSINI DEWERPE\" DE JUMET","RUE GENDEBIEN 1",6040,"CHARLEROI (JUMET)","SECONDAIRE","SGS-SE",42]
[null,null,null,"AR \"LES MARLAIRES\" DE GOSSELIES","RUE DE LA PROVIDENCE 12",6041,"CHARLEROI (GOSSELIES)","SECONDAIRE","SGS-SE",41]
[null,null,null,"AR DE GILLY","RUE DU CALVAIRE 20",6060,"CHARLEROI (GILLY)","SECONDAIRE","SGS-SE",40]
[null,null,null,"AR \"LOUIS DELATTRE\" DE FONTAINE-L'EVEQUE","RUE DE L'ATHENEE 32",6140,"FONTAINE-L'EVEQUE","SECONDAIRE","SGS-SE",62]
[null,null,null,"AR \"PIERRE PAULUS\" DE CHATELET","RUE DES GAUX 100",6200,"CHATELET","SECONDAIRE","SGS-SE",45]
[null,null,null,"AR \"RENE MAGRITTE\" DE CHATELET","RUE DU COLLEGE 16",6200,"CHATELET","SECONDAIRE","SGS-SE",46]
[null,null,null,"AR \"JOURDAN\" DE FLEURUS","RUE DE FLEURJOUX 3",6220,"FLEURUS","SECONDAIRE","SGS-SE",60]
[null,null,null,"AR DE PONT-A-CELLES","RUE DE L'EGLISE 107 B",6230,"PONT-A-CELLES","SECONDAIRE","SGS-SE",104]
[null,null,null,"AR DE CHIMAY","RUE DE NOAILLES 3",6460,"CHIMAY","SECONDAIRE","SGS-SE",47]
[null,null,null,"ITCF DE SIVRY-RANCE","RUE PAULINE HUBERT 40",6470,"SIVRY-RANCE (RANCE)","SECONDAIRE","SGS-SE",116]
[null,null,null,"AR DE BEAUMONT","RUE GERMAIN MICHIELS 3",6500,"BEAUMONT","SECONDAIRE","SGS-SE",10]
[null,null,null,"AR DE THUIN","DREVE DES ALLIES 11",6530,"THUIN","SECONDAIRE","SGS-SE",121]
[null,null,null,"ITCF D'ERQUELINNES","RUE ALBERT IER 21",6560,"ERQUELINNES","SECONDAIRE","SGS-SE",57]
[null,null,null,"AR DE BASTOGNE - HOUFFALIZE","AVENUE DE LA GARE 12",6600,"BASTOGNE","SECONDAIRE","SGS-SE",9]
[null,null,null,"AR DE VIELSALM","LES GRANDS CHAMPS 18 A",6690,"VIELSALM","SECONDAIRE","SGS-SE",128]
[null,null,null,"ITCF \"ETIENNE LENOIR\" D'ARLON","CHEMIN DE WEYLER 2",6700,"ARLON","SECONDAIRE","SGS-SE",4]
[null,null,null,"AR D'ARLON","RUE DE SESSELICH 83",6700,"ARLON","SECONDAIRE","SGS-SE",3]
[null,null,null,"AR DE VIRTON","FAUBOURG-D'ARIVAL 48",6760,"VIRTON","SECONDAIRE","SGS-SE",129]
[null,null,null,"AR D'ATHUS","RUE NEUVE 32",6791,"AUBANGE (ATHUS)","SECONDAIRE","SGS-SE",7]
[null,null,null,"ITCF \"CENTRE ARDENNE\" DE LIBRAMONT","AVENUE HERBOFIN 39",6800,"LIBRAMONT-CHEVIGNY","SECONDAIRE","SGS-SE",75]
[null,null,null,"AR \"G. ET G. GILSON\" D'IZEL","RUE DE L'INSTITUT 47",6810,"CHINY (IZEL)","SECONDAIRE","SGS-SE",48]
[null,null,null,"AR DE BOUILLON - PALISEUL","RUE DU COLLEGE 35",6830,"BOUILLON","SECONDAIRE","SGS-SE",14]
[null,null,null,"AR DE NEUFCHATEAU - BERTRIX","AVENUE DE LA VICTOIRE 30",6840,"NEUFCHATEAU","SECONDAIRE","SGS-SE",96]
[null,null,null,"AR DE MARCHE -BOMAL","AVENUE DE LA TOISON D'OR 71",6900,"MARCHE-EN-FAMENNE","SECONDAIRE","SGS-SE",82]
[null,null,null,"AR DE LA ROCHE-EN-ARDENNE","RUE DES EVETS 4",6980,"LA ROCHE-EN-ARDENNE","SECONDAIRE","SGS-SE",73]
[null,null,null,"AR \"MARGUERITE BERVOETS\" DE MONS","AVENUE VICTOR MAISTRIAU 11",7000,"MONS","SECONDAIRE","SGS-SE",85]
[null,null,null,"AR DE MONS I","RUE DE L'ATHENEE 4",7000,"MONS","SECONDAIRE","SGS-SE",86]
[null,null,null,"ECOLE DU SHAPE SECTION BELGE","AVENUE DE PARIS 705",7010,"SHAPE","SECONDAIRE","SGS-SE",115]
[null,null,null,"AR \"JULES BORDET\" DE SOIGNIES","BOULEVARD F. ROOSEVELT 27",7060,"SOIGNIES","SECONDAIRE","SGS-SE",117]
[null,null,null,"IACF DU ROEULX","RUE DU CARGIES 8",7070,"LE ROEULX","SECONDAIRE","SGS-SE",141]
[null,null,null,"AR DE BRAINE-LE-COMTE","RUE DE MONS 87",7090,"BRAINE-LE-COMTE","SECONDAIRE","SGS-SE",16]
[null,null,null,"AR DE LA LOUVIERE","RUE DE BOUVY 15",7100,"LA LOUVIERE","SECONDAIRE","SGS-SE",72]
[null,null,null,"AR DE BINCHE","PLACE DES DROITS DE L'HOMME",7130,"BINCHE","SECONDAIRE","SGS-SE",13]
[null,null,null,"ITCF DE MORLANWELZ","RUE RAOUL WAROCQUE 46",7140,"MORLANWELZ (MORLANWELZ-MARIEMONT)","SECONDAIRE","SGS-SE",87]
[null,null,null,"LYCEE DE LA CF \"CHARLES PLISNIER\" DE ST-GHISLAIN","RUE DE SAS 75",7330,"SAINT-GHISLAIN","SECONDAIRE","SGS-SE",110]
[null,null,null,"AR DE SAINT-GHISLAIN","AVENUE DE L'ENSEIGNEMENT 20",7330,"SAINT-GHISLAIN","SECONDAIRE","SGS-SE",109]
[null,null,null,"AR DE DOUR","RUE DE L'ATHENEE 23",7370,"DOUR","SECONDAIRE","SGS-SE",54]
[null,null,null,"AR DE QUIEVRAIN","RUE DEBAST 26",7380,"QUIEVRAIN","SECONDAIRE","SGS-SE",105]
[null,null,null,"IACF Walter Ravez ","QUAI VIFQUIN 22-25",7500,"TOURNAI","SECONDAIRE","SGS-SE",151]
[null,null,null,"ITCF VAL-ITMA","RUE DES MOULINS 1",7500,"TOURNAI","SECONDAIRE","SGS-SE",124]
[null,null,null,"VAL-ITMA DE TOURNAI","CHAUSSEE DE LILLE 2",7500,"TOURNAI","SECONDAIRE","SGS-SE",125]
[null,null,null,"AR \"JULES BARA\" DE TOURNAI","RUE DUQUESNOY 24",7500,"TOURNAI","SECONDAIRE","SGS-SE",122]
[null,null,null,"AR \"ROBERT CAMPIN\" DE TOURNAI","RUE DU CHATEAU 18",7500,"TOURNAI","SECONDAIRE","SGS-SE",123]
[null,null,null,"IACF \"LA CROISÉE\" DE TOURNAI","CHAUSSEE DE RENAIX 603",7540,"TOURNAI","SECONDAIRE","SGS-SE",152]
[null,null,null,"IACF DE PERUWELZ","RUE ASTRID 9",7600,"PERUWELZ","SECONDAIRE","SGS-SE",147]
[null,null,null,"AR DE PERUWELZ","RUE DES FRANCAIS 31",7600,"PERUWELZ","SECONDAIRE","SGS-SE",102]
[null,null,null,"IACF DE MOUSCRON","AVENUE DE BARRY 30",7700,"MOUSCRON","SECONDAIRE","SGS-SE",143]
[null,null,null,"AR DE MOUSCRON","RUE DU MIDI 15",7700,"MOUSCRON","SECONDAIRE","SGS-SE",88]
[null,null,null,"AR THOMAS EDISON DE MOUSCRON","PLACE DE LA JUSTICE 1",7700,"MOUSCRON","SECONDAIRE","SGS-SE",89]
[null,null,null,"IACF DE PECQ","RUE DE LANNOY 52",7740,"PECQ","SECONDAIRE","SGS-SE",146]
[null,null,null,"AR \"FERNAND JACQUEMIN\" DE COMINES","CHAUSSEE DE WARNETON 26",7780,"COMINES-WARNETON (COMINES)","SECONDAIRE","SGS-SE",50]
[null,null,null,"AR D'ATH","RUE DES RECOLLETS 9",7800,"ATH","SECONDAIRE","SGS-SE",5]
[null,null,null,"IACF D' ATH-IRCHONWELZ","CHAUSSEE DE VALENCIENNES 48",7801,"ATH-IRCHONWELZ","SECONDAIRE","SGS-SE",136]
[null,null,null,"ITCF D'ATH IRCHONWELZ","CHAUSSEE DE VALENCIENNES 48",7801,"ATH (IRCHONWELZ)","SECONDAIRE","SGS-SE",6]
[null,null,null,"AR D'ENGHIEN","RUE MONTGOMERY 73",7850,"ENGHIEN","SECONDAIRE","SGS-SE",56]
[null,null,null,"AR \"RENE MAGRITTE\" DE LESSINES","RUE FRANCOIS WATTERMAN 27",7860,"LESSINES","SECONDAIRE","SGS-SE",74]
[null,null,null,"AR \"LUCIENNE TELLIER\" D'ANVAING","CHEMIN DU CARNOIS 32 A",7910,"FRASNES-LEZ-ANVAING (ANVAING)","SECONDAIRE","SGS-SE",63]
[null,null,null,"EES CF DE GANSHOREN","AVENUE LOUIS DE BROUCKERE, 29",1083,"GANSHOREN","SPECIALISE","SGS-SP",321]
[null,null,null,"EES PS CF D'AUDERGHEM","AVENUE SCHALLER, 87",1160,"AUDERGHEM","SPECIALISE","SGS-SP",309]
[null,null,null,"EES P CF DE BRAINE-L'ALLEUD","RUE DEFALQUE 30",1490,"COURT-SAINT-ETIENNE","SPECIALISE","SGS-SP",313]
[null,null,null,"HA CF DE LIEGE","RUE JULIEN D'ANDRIMONT, 26",4000,"LIEGE","SPECIALISE","SGS-SP",331]
[null,null,null,"EES PS CF DE GRIVEGNEE","RUE NICOLAS SPIROUX, 62",4030,"GRIVEGNEE","SPECIALISE","SGS-SP",323]
[null,null,null,"HA CF DE MILMORT","RUE DE FEXHE, 76",4041,"MILMORT","SPECIALISE","SGS-SP",335]
[null,null,null,"EES PS CF DE MILMORT","RUE DE FEXHE, 76",4041,"MILMORT","SPECIALISE","SGS-SP",334]
[null,null,null,"EES P CF DE SERAING","AVENUE DAVY, 3",4100,"SERAING","SPECIALISE","SGS-SP",348]
[null,null,null,"HAP CF DE COMBLAIN-AU-PONT","RUE SOSSON, 28",4170,"COMBLAIN-AU-PONT","SPECIALISE","SGS-SP",317]
[null,null,null,"EES P CF DE COMBLAIN-AU-PONT","RUE DES GROTTES, 20",4170,"COMBLAIN-AU-PONT","SPECIALISE","SGS-SP",316]
[null,null,null,"EES PS CF DE HANNUT","RUE DE HUY, 28",4280,"HANNUT","SPECIALISE","SGS-SP",324]
[null,null,null,"HA CF DE FLEMALLE-HAUTE","AVENUE PIOMBINO, 1",4400,"FLEMALLE-HAUTE","SPECIALISE","SGS-SP",319]
[null,null,null,"EES PS CF DE FLEMALLE-HAUTE","CHEMIN DU HERDIER,",4400,"FLEMALLE-HAUTE","SPECIALISE","SGS-SP",318]
[null,null,null,"EES P CF DE AMAY","RUE VELBRUCK, 22",4540,"AMAY","SPECIALISE","SGS-SP",300]
[null,null,null,"EES S CF DE AMAY","RUE D'AMPSIN, 1",4540,"AMAY","SPECIALISE","SGS-SP",301]
[null,null,null,"EES P CF \"LT JACQUEMIN\" DE VISE","RUE DE BERNEAU, 16",4600,"VISE","SPECIALISE","SGS-SP",352]
[null,null,null,"HA CF DE SAIVE","RUE DES CHAMPS, 3",4671,"SAIVE","SPECIALISE","SGS-SP",347]
[null,null,null,"EES P CF DE SAIVE","RUE DES CHAMPS, 1",4671,"SAIVE","SPECIALISE","SGS-SP",346]
[null,null,null,"EES S CF DE VERVIERS","RUE DES WALLONS, 59",4800,"VERVIERS","SPECIALISE","SGS-SP",350]
[null,null,null,"HA CF \"LES ACACIAS\" DE ANDRIMONT","RUE ALBERT THOMAS, 1",4821,"ANDRIMONT","SPECIALISE","SGS-SP",306]
[null,null,null,"EES P CF DE ANDRIMONT","A. DE T'SERCLAES, 58",4821,"ANDRIMONT","SPECIALISE","SGS-SP",305]
[null,null,null,"EES P CF DE GEMBLOUX","RUE DE MAZY, 27A",5030,"GEMBLOUX","SPECIALISE","SGS-SP",322]
[null,null,null,"EES P CF DE AUVELAIS","RUE DU BOSQUET, 75",5060,"AUVELAIS","SPECIALISE","SGS-SP",310]
[null,null,null,"EES PS CF \"DELAHAUT\" DE JAMBES","RUE DE SEDENT, 28",5100,"JAMBES","SPECIALISE","SGS-SP",325]
[null,null,null,"EES P CF DE ANDENNE","CHAUSSEE DE CINEY, 246",5300,"ANDENNE","SPECIALISE","SGS-SP",302]
[null,null,null,"HAP CF DE ANSEREMME","AVENUE HODGES, 7B",5500,"ANSEREMME","SPECIALISE","SGS-SP",308]
[null,null,null,"EES P CF \"LE CAILLOU \" DE ANSEREMME","AV G.HODGES, 7A",5500,"ANSEREMME","SPECIALISE","SGS-SP",307]
[null,null,null,"EES S CF DE PHILIPPEVILLE","RUE DE LA CALAMINE, 32",5600,"PHILIPPEVILLE","SPECIALISE","SGS-SP",340]
[null,null,null,"HA CF DE MARIEMBOURG","CHAUSSEE DE ROLY, 17",5660,"MARIEMBOURG","SPECIALISE","SGS-SP",333]
[null,null,null,"EES P CF DE MARIEMBOURG","CHAUSSEE DE ROLY, 15",5660,"MARIEMBOURG","SPECIALISE","SGS-SP",332]
[null,null,null,"EES P CF DE NALINNES","RUE DES BOUTIS, 62",6120,"NALINNES","SPECIALISE","SGS-SP",339]
[null,null,null,"EES P CF DE ANDERLUES","RUE GUERLEMENT, 34",6150,"ANDERLUES","SPECIALISE","SGS-SP",303]
[null,null,null,"EES S CF DE ANDERLUES","RUE GUERLEMENT, 36",6150,"ANDERLUES","SPECIALISE","SGS-SP",304]
[null,null,null,"EES PS CF DE CHATELET","RUE DE LOVERVAL, 262",6200,"CHATELET","SPECIALISE","SGS-SP",315]
[null,null,null,"EES P CF \"CROIX BLANCHE\" DE BASTOGNE","RUE DE LA CHAPELLE, 131",6600,"BASTOGNE","SPECIALISE","SGS-SP",311]
[null,null,null,"EES PS CF DE VIELSALM","RUE DU CHATEAU, 19",6690,"VIELSALM","SPECIALISE","SGS-SP",351]
[null,null,null,"HAP CF DE SAINT-MARD","CHEMIN  MOREL, 71",6762,"SAINT-MARD","SPECIALISE","SGS-SP",345]
[null,null,null,"EES PS CF DE SAINT-MARD","CHEMIN MOREL, 71",6762,"SAINT-MARD","SPECIALISE","SGS-SP",344]
[null,null,null,"HACF DE MARCHE","RUE VICTOR LIBERT 12",6900,"MARCHE","SPECIALISE","SGS-SP",355]
[null,null,null,"EES P CF DE WAHA (MARLOIE)","RUE MIONVAUX,",6900,"WAHA (MARLOIE)","SPECIALISE","SGS-SP",353]
[null,null,null,"EES S CF DE WAHA (MARLOIE)","RUE MIONVAUX,",6900,"WAHA (MARLOIE)","SPECIALISE","SGS-SP",354]
[null,null,null,"EES P CF \"L'ARBRE VERT\" DE MONS","CHAUSSEE DU ROEULX, 122",7000,"MONS","SPECIALISE","SGS-SP",337]
[null,null,null,"EES P CF DE BRAINE-LE-COMTE","AVENUE DE LA HOUSSIERE, 100",7090,"BRAINE-LE-COMTE","SPECIALISE","SGS-SP",314]
[null,null,null,"EES P CF DE LA LOUVIERE","RUE MAX BUSET, 24",7100,"LA LOUVIERE","SPECIALISE","SGS-SP",328]
[null,null,null,"EES S CF DE TOURNAI","RUE DE LANNOY 53",7340,"PECQ","SPECIALISE","SGS-SP",349]
[null,null,null,"HA CF DE QUAREGNON","RIEU DU COEUR, 159",7390,"QUAREGNON","SPECIALISE","SGS-SP",342]
[null,null,null,"EES PS CF DE QUAREGNON","RUE DU PLAT RIE, 345",7390,"QUAREGNON","SPECIALISE","SGS-SP",341]
[null,null,null,"HA CF DE KAIN","RUE DE BREUZE, 9BIS",7540,"KAIN","SPECIALISE","SGS-SP",327]
[null,null,null,"EES P CF DE KAIN","RUE DE BREUZE, 9BIS",7540,"KAIN","SPECIALISE","SGS-SP",326]
[null,null,null,"EES P CF DE MOUSCRON","RUE DE LA COQUINIE, 285",7700,"MOUSCRON","SPECIALISE","SGS-SP",338]
[null,null,null,"HAP CF DE LESSINES","CHEMIN DE PAPIGNIES, 38",7860,"LESSINES","SPECIALISE","SGS-SP",330]
[null,null,null,"EES P CF DE LESSINES","CHEMIN DE PAPIGNIES, 38",7860,"LESSINES","SPECIALISE","SGS-SP",329]
[null,null,null,"EES PS CF DE FRASNES-LEZ-BUISSENAL","ROUTE DE LESSINES, 27",7911,"FRASNES-LEZ-BUISSENAL","SPECIALISE","SGS-SP",320]
[null,null,null,"EES P CF \"L'ARC-EN-CIEL\" DE BELOEIL","RUE DES VIVIERS AU BOIS, 50",7970,"BELOEIL","SPECIALISE","SGS-SP",312]
[null,null,null,"IACF SUP D'IXELLES","RUE DE L'ABBAYE 26 A",1050,"IXELLES","SUPERIEUR","SGS-SUP",600]
[null,null,null,"IACF SUP D'UCCLE","AVENUE HAMOIR 24",1180,"UCCLE","SUPERIEUR","SGS-SUP",601]
[null,null,null,"IACF SUP D'UCCLE","SQUARE DE FRE 2",1180,"UCCLE","SUPERIEUR","SGS-SUP",602]
[null,null,null,"IACF SUPDE  FOREST","RUE DE BOURGOGNE 48",1190,"FOREST","SUPERIEUR","SGS-SUP",603]
[null,null,null,"IACF DE  LIEGE","RUE DES BRUYERES 150",4000,"LIEGE","SUPERIEUR","SGS-SUP",604]
[null,null,null,"IACF SUP DE HUY","QUAI D'ARONA 1",4500,"HUY","SUPERIEUR","SGS-SUP",605]
[null,null,null,"IACF SUP  DETAMINES","RUE SAINT-MARTIN 22-24",5060,"TAMINES","SUPERIEUR","SGS-SUP",606]
[null,null,null,"IACF SUP DE JAMBES","CHAUSSEE DE LIEGE 394",5100,"JAMBES","SUPERIEUR","SGS-SUP",607]
[null,null,null,"IACF SUP DE SAINT_MARD","RUE DE MAGEROUX",6762,"SAINT-MARD","SUPERIEUR","SGS-SUP",608]
[null,null,null,"IACF SUP DE LIBRAMONT","RUE DE LA CITE 64",6800,"LIBRAMONT","SUPERIEUR","SGS-SUP",609]
[null,null,null,"IACF SUP DE MONS","AVENUE REINE ASTRID 23",7000,"MONS","SUPERIEUR","SGS-SUP",610]
[null,null,null,"IACF SUP DE TOURNAI","RUE DES CARMES 13-15",7500,"TOURNAI","SUPERIEUR","SGS-SUP",611]

{"sheet":"Gestionnaires","index":2,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":false,"merged":[[31,2,31,3],[30,0,30,1],[24,0,24,1],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[22,3,22,4],[17,9,17,11],[18,9,18,10],[19,9,19,10],[20,9,20,10],[21,9,21,10],[22,9,22,10],[17,3,17,5],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[16,3,16,4],[6,9,6,11],[7,9,7,10],[8,9,8,10],[9,9,9,10],[10,9,10,10],[11,9,11,10],[12,9,12,10],[13,9,13,10],[14,9,14,10],[15,9,15,10],[16,9,16,10],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[6,3,6,5],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,0,11,1],[7,0,7,1],[0,0,0,2],[6,0,6,2],[17,0,17,2],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[22,0,22,1],[15,0,15,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[16,0,16,1]]}
["L'ordonnateur :"]
["Civilité",null,null,null,null,null,"Exercice:",{"$f":"RIGHT(TEXT(C12,\"jj/mm/aaaa\"),4)","v":"1900"}]
["Titre"]
["Nom"]
["Prénom"]
["Matricule"]
["Le comptable sortant 1:",null,null,"Le comptable sortant 2:",null,null,null,null,null,"Le comptable sortant 3:"]
["Civilité",null,null,"Civilité",null,null,"Exercice précédent",null,{"$f":"H2-1","v":1899},"Civilité"]
["Nom",null,null,"Nom",null,null,null,null,null,"Nom"]
["Prénom",null,null,"Prénom",null,null,null,null,null,"Prénom"]
["Matricule",null,null,"Matricule",null,null,null,null,null,"Matricule"]
["Date de sortie du comptable",null,null,"Date de sortie du comptable",null,null,null,null,null,"Date de sortie du comptable"]
["Rue, N°",null,null,"Rue, N°",null,null,null,null,null,"Rue, N°"]
["Code postal",null,null,"Code postal",null,null,null,null,null,"Code postal"]
["Commune",null,null,"Commune",null,null,null,null,null,"Commune"]
["Date de naissance",null,null,"Date de naissance",null,null,null,null,null,"Date de naissance"]
["Date du constat de la rem-rep",null,null,"Date du constat de la rem-rep",null,null,null,null,null,"Date du constat de la rem-rep"]
["Le comptable entrant 1 :",null,null,"Le comptable entrant 2:",null,null,null,null,null,"Le comptable entrant 3:"]
["Civilité",null,null,"Civilité",null,null,null,null,null,"Civilité"]
["Nom",null,null,"Nom",null,null,null,null,null,"Nom"]
["Prénom",null,null,"Prénom",null,null,null,null,null,"Prénom"]
["Matricule",null,null,"Matricule",null,null,null,null,null,"Matricule"]
["Date de naissance",null,null,"Date de naissance",null,null,null,null,null,"Date de naissance"]
[]
["Identification des comptes",null,"Numéro IBAN"]
["Compte dotation"]
["Placement 1"]
["Placement 2"]
["Placement 3"]
["Placement 4"]
["Placement 5"]

{"sheet":"Gestion impression","index":3,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,1,7],[10,0,11,7],[20,0,21,7]]}
[{"$f":" \"Remise-Reprise du \"&TEXT(Gestionnaires!C12,\"jj/mm/aaaa\")&\" - Sortie de \"&\" \"&Gestionnaires!C8&\" \"&Gestionnaires!C10&\" \"&UPPER(Gestionnaires!C9)","v":"Remise-Reprise du 00/01/1900 - Sortie de    "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":" \"Remise-Reprise du \"&TEXT(Gestionnaires!F12,\"jj/mm/aaaa\")&\" - Sortie de \"&\" \"&Gestionnaires!F8&\" \"&Gestionnaires!F10&\" \"&UPPER(Gestionnaires!F9)","v":"Remise-Reprise du 00/01/1900 - Sortie de    "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":" \"Remise-Reprise du \"&TEXT(Gestionnaires!L12,\"jj/mm/aaaa\")&\" - Sortie de \"&\" \"&Gestionnaires!L8&\" \"&Gestionnaires!L10&\" \"&UPPER(Gestionnaires!L9)","v":"Remise-Reprise du 00/01/1900 - Sortie de    "}]

{"sheet":"Reports","index":4,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,0,2,3],[3,0,3,2],[4,0,4,2],[5,0,5,2],[21,0,21,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[6,0,6,2],[11,0,11,2],[12,0,12,2],[13,0,13,2],[7,0,7,2],[8,0,8,2],[9,0,9,2],[10,0,10,2],[26,0,26,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1]]}
[]
[{"$f":" \"Report au 31 décembre \"&Gestionnaires!I8","v":"Report au 31 décembre 1899"}]
[]
["Caisse",null,null,0]
["Dotation",null,null,0]
["Placement 1",null,null,0]
["Placement 2",null,null,0]
["Placement 3",null,null,0]
["Placement 4",null,null,0]
["Placement 5",null,null,0]
["PV déficit",null,null,0]
["Sous-totaux",null,null,{"$f":"SUM(C4:D11)","v":0}]
["Mouvements de fonds",null,null,0]
["Totaux",null,null,{"$f":"D12-C13","v":0}]
["Opérations courantes",null,"2A","2B"]
["Intendance",null,0,0]
["Fonctionnement",null,0,0]
["Fond de réserve",null,0,0]
["Total OC",null,{"$f":"SUM(C16:C18)","v":0},{"$f":"SUM(D16:D18)","v":0}]
["Opérations en capital",null,0,0]
["Opérations pour ordre"]
["Tiers",null,0,0]
["Trésor",null,0,0]
["Total PO",null,{"$f":"SUM(C22:C23)","v":0},{"$f":"SUM(D22:D23)","v":0}]
["Sous-totaux",null,{"$f":"SUM(C16:C18,C20,C22:C23)","v":0},{"$f":"SUM(D16:D18,D20,D22:D23)","v":0}]
["Transferts",null,0,0]
["Totaux",null,{"$f":"C25-C26","v":0},{"$f":"D25-D26","v":0}]

{"sheet":"Caisse 1","index":5,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[3,8,6,13],[9,8,10,13],[17,5,17,6],[0,0,0,7],[17,1,17,4],[2,5,2,6],[3,5,3,6],[4,5,4,6],[5,5,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[16,5,16,6]]}
[{"$f":"\"Encodage de la caisse à la date du \"&TEXT(Gestionnaires!C12,\"jj/mm/aaaa\")","v":"Encodage de la caisse à la date du 00/01/1900"}]
[]
[null,0,"x",1,"cents =",{"$f":"(B3*D3)/100","v":0}]
[null,0,"x",2,"cents =",{"$f":"(B4*D4)/100","v":0},null,null,{"$f":"\"Renseignez ici les devises contenues en caisse à la date du \"&TEXT(Gestionnaires!C12,\"jj/mm/aaaa\")&\" jour de sortie de \"&Gestionnaires!C8&\" \"&Gestionnaires!C10&\" \"\n&UPPER(Gestionnaires!C9)","v":"Renseignez ici les devises contenues en caisse à la date du 00/01/1900 jour de sortie de   "}]
[null,0,"x",5,"cents =",0]
[null,0,"x",10,"cents =",0]
[null,0,"x",20,"cents =",0]
[null,0,"x",50,"cents =",0]
[null,0,"x",1,"Euro =",{"$f":"B9*D9","v":0}]
[null,0,"x",2,"Euros =",0,null,null,"Ne complétez que la colonne jaune"]
[null,0,"x",5,"Euros =",0]
[null,0,"x",10,"Euros =",0]
[null,0,"x",20,"Euros =",0]
[null,0,"x",50,"Euros =",0]
[null,0,"x",100,"Euros =",0]
[null,0,"x",200,"Euros =",0]
[null,0,"x",500,"Euros =",0]
[null,"Total",null,null,null,{"$f":"SUM(F3:F17)","v":0}]

{"sheet":"AP sortie","index":6,"n_rows":39,"n_cols":16,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,15],[1,0,1,4],[2,6,2,8],[2,10,2,15],[13,0,13,1],[3,6,3,7],[6,6,6,7],[3,10,3,11],[4,10,4,11],[6,10,6,11],[7,10,7,11],[10,10,10,11],[5,10,5,11],[8,10,8,11],[3,0,3,1],[2,0,2,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[4,6,4,7],[5,6,5,7],[8,0,8,1],[9,0,9,1],[11,0,11,1],[12,0,12,1],[13,6,13,7],[10,0,10,1],[31,11,31,12],[7,6,7,7],[10,6,10,7],[9,10,9,11],[17,6,17,9],[18,6,18,8],[19,6,19,8],[20,6,20,8],[8,6,8,7],[9,6,9,7],[22,6,22,8],[21,6,21,8],[24,11,24,14],[13,10,13,11],[17,11,17,15],[22,11,22,15],[38,6,38,7],[25,6,25,8],[34,6,34,8],[33,6,33,7],[32,6,32,8],[24,6,24,8],[15,0,15,1],[26,0,26,1],[19,0,19,1],[17,0,17,1],[16,0,16,1],[23,0,23,1],[21,0,21,1],[22,0,22,1],[18,0,18,1],[25,0,25,1],[24,0,24,1],[23,6,23,8]]}
[{"$f":"\"Etat des comptes et des avoirs à la date du \"&TEXT(Gestionnaires!C12,\"jj/mm/aaaa\")","v":"Etat des comptes et des avoirs à la date du 00/01/1900"}]
[{"$f":" \"Compte jaune du \"&TEXT(Gestionnaires!C12,\"jj/mm/aaaa\")","v":"Compte jaune du 00/01/1900"}]
[null,null,"Recettes","Dépenses","Solde remis",null,"Créances à recouvrer",null,null,null,"Créances à liquider"]
["Caisse",null,0,0,{"$f":"C4-D4","v":0},null,"Opérations courantes",null,{"$f":"SUM(I5:I6)","v":0},null,"Opérations courantes",null,"A honorer","Fact. Impayées","Fact. Ordonnancées","Total"]
["Dotation",null,0,0,{"$f":"C5-D5","v":0},null,"Intendance",null,0,null,"Intendance",null,0,0,0,{"$f":"SUM(M5:O5)","v":0}]
["Placement 1",null,0,0,0,null,"Autres",null,0,null,"Autres",null,0,0,0,{"$f":"SUM(M6:O6)","v":0}]
["Placement 2",null,0,0,0,null,"Opérations en capital",null,0,null,"Opérations en capital",null,0,0,0,0]
["Placement 3",null,0,0,0,null,"Opérations pour ordre",null,{"$f":"SUM(I9:I10)","v":0},null,"Opérations pour ordre"]
["Placement 4",null,0,0,0,null,"Tiers",null,0,null,"Tiers",null,0,0,0,0]
["Placement 5",null,0,0,0,null,"Trésor",null,0,null,"Trésor",null,0,0,0,0]
["PV déficit",null,0,0,0,null,"Total",null,{"$f":"SUM(I5,I6,I7,I9,I10,)","v":0},null,"Total",null,{"$f":"SUM(M5:M10)","v":0},{"$f":"SUM(N5:N10)","v":0},{"$f":"SUM(O5:O10)","v":0},{"$f":"SUM(P5:P10)","v":0}]
["Sous-totaux",null,{"$f":"SUM(C4:C11)","v":0},{"$f":"SUM(D4:D11)","v":0},0]
["Mouvements de fonds",null,0,0,0,null,null,null,null,null,null,null,"Total","hors pensions"]
["Totaux",null,{"$f":"C12-C13","v":0},{"$f":"D12-D13","v":0},0,null,"Pensions anticipatives",null,0,null,"Comptes créditeurs",null,0,{"$f":"M14-I14","v":0}]
["Opérations courantes"]
["Intendance",null,0,0,{"$f":"C16-D16","v":0}]
["Fonctionnement",null,0,0,{"$f":"C17-D17","v":0}]
["Fond de réserve",null,0,0,{"$f":"C18-D18","v":0},null,"Magasin",null,null,null,null,"Energie"]
["Total OC",null,{"$f":"SUM(C16:C18)","v":0},{"$f":"SUM(D16:D18)","v":0},{"$f":"C19-D19","v":0},null,"Stock alimentation",null,null,0,null,"Type","Qté","Unité","Prix unitaire","Montant"]
["Opérations en capital",null,0,0,{"$f":"C20-D20","v":0},null,"Stock des produits d'entretien",null,null,0,null,"Mazout",0,"litres à ",0,{"$f":"M20*O20","v":0}]
["Opérations pour ordre",null,null,null,null,null,"Stock de pharmacie",null,null,0,null,"Gaz",0,"litres à ",0,{"$f":"M21*O21","v":0}]
["Tiers",null,0,0,{"$f":"C22-D22","v":0},null,"Stock matériel de bureau",null,null,0,null,"Charbon",null,"Kg",null,{"$f":"M22*O22","v":0}]
["Trésor",null,0,0,0,null,"Stock matières premières",null,null,0,null,"Autres  à préciser"]
["Total PO",null,{"$f":"SUM(C22:C23)","v":0},{"$f":"SUM(D22:D23)","v":0},0,null,"Stock fournitures scolaires",null,null,0,null,null,null,null,null,0]
["Sous-totaux",null,{"$f":"C19+C20+C24","v":0},{"$f":"D19+D20+D24","v":0},0,null,"Stock autres",null,null,0,null,"Total",null,null,null,{"$f":"SUM(P20:P22,P24)","v":0}]
["Transferts",null,0,0,0,null,"Total",null,null,{"$f":"SUM(J19:J25)","v":0}]
["Totaux",null,{"$f":"C25-C26","v":0},{"$f":"D25-D26","v":0},0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Tickets en circulation"]
[null,null,null,null,null,null,"Autres valeurs",null,null,null,null,"Tickets",0]
[null,null,null,null,null,null,"Timbres",null,0]
[null,null,null,null,null,null,"Autres à préciser"]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Total",null,{"$f":"SUM(I34,I36:I38)","v":0}]

{"sheet":"Impression PV caisse","index":7,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[[33,0,33,5],[36,0,36,5],[38,0,38,5],[40,0,40,5],[29,0,29,1],[31,0,31,5],[22,0,22,1],[29,3,29,4],[0,0,0,1],[12,0,12,5],[5,3,5,4],[6,3,6,4],[9,0,9,5],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1]]}
["Procès-verbal de caisse",null,"du service",{"$f":"LOOKUP(\"X\",Identification!B2:B344,Identification!D2:D344)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"LOOKUP(\"X\",Identification!B2:B344,Identification!E2:E344)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"LOOKUP(\"X\",Identification!B2:B344,Identification!F2:F344&\" \"&Identification!G2:G344)","v":{"$error":"#N/A"}}]
[]
[]
[null,null,{"$f":"Gestionnaires!C2","v":0},{"$f":"IF(C6=\"Monsieur\",\"Ordonnateur\",\"Ordonnatrice\")","v":"Ordonnatrice"},null,{"$f":"Gestionnaires!C8","v":0}]
[{"$f":" \"Le\"&\" \"&TEXT(Gestionnaires!C12,\"jj/mm/AAAA\")","v":"Le 00/01/1900"},{"$f":"\" Nous,\"","v":" Nous,"},{"$f":"Gestionnaires!C5","v":0},"Avons requis",null,{"$f":"Gestionnaires!C10","v":0}]
[null,null,{"$f":"UPPER(Gestionnaires!C4)","v":""},null,null,{"$f":"UPPER(Gestionnaires!C9)","v":""}]
[]
["Comptable de l'établissement repris ci-dessus, de nous présenter les valeurs et autres espèces existant dans sa caisse et avons dressés le bordereau ci-après, à savoir:"]
[]
[]
["NUMERAIRES ET VALEURS"]
[]
[null,null,null,{"$f":"'Caisse 1'!B3","v":0},"Pièces de 1 cent =",{"$f":"'Caisse 1'!F3","v":0}]
[null,null,null,{"$f":"'Caisse 1'!B4","v":0},"Pièces de 2 cents =",{"$f":"'Caisse 1'!F4","v":0}]
[null,null,null,{"$f":"'Caisse 1'!B5","v":0},"Pièces de 5 cents =",{"$f":"'Caisse 1'!F5","v":0}]
[null,null,null,{"$f":"'Caisse 1'!B6","v":0},"Pièces de 10 cents =",{"$f":"'Caisse 1'!F6","v":0}]
[null,null,null,{"$f":"'Caisse 1'!B7","v":0},"Pièces de 20 cents =",{"$f":"'Caisse 1'!F7","v":0}]
[null,null,null,{"$f":"'Caisse 1'!B8","v":0},"Pièces de 50 cents =",{"$f":"'Caisse 1'!F8","v":0}]
[null,null,null,{"$f":"'Caisse 1'!B9","v":0},"Pièces de 1 Euro =",{"$f":"'Caisse 1'!F9","v":0}]
[null,null,null,{"$f":"'Caisse 1'!B10","v":0},"Pièces de 2 Euros =",{"$f":"'Caisse 1'!F10","v":0}]
["Caisse = ",null,{"$f":"'AP sortie'!E4","v":0},{"$f":"'Caisse 1'!B11","v":0},"bilets  de 5 Euros =",{"$f":"'Caisse 1'!F11","v":0}]
["Dotation = ",null,{"$f":"'AP sortie'!E5","v":0},{"$f":"'Caisse 1'!B12","v":0},"bilets  de 10 Euros =",{"$f":"'Caisse 1'!F12","v":0}]
["Placement 1 = ",null,{"$f":"'AP sortie'!E6","v":0},{"$f":"'Caisse 1'!B13","v":0},"bilets  de 20 Euros =",{"$f":"'Caisse 1'!F13","v":0}]
["Placement 2 = ",null,{"$f":"'AP sortie'!E7","v":0},{"$f":"'Caisse 1'!B14","v":0},"bilets  de 50 Euros =",{"$f":"'Caisse 1'!F14","v":0}]
["Placement 3 = ",null,{"$f":"'AP sortie'!E8","v":0},{"$f":"'Caisse 1'!B15","v":0},"bilets  de 100 Euros =",{"$f":"'Caisse 1'!F15","v":0}]
["Placement 4 = ",null,{"$f":"'AP sortie'!E9","v":0},{"$f":"'Caisse 1'!B16","v":0},"bilets  de 200 Euros =",{"$f":"'Caisse 1'!F16","v":0}]
["Placement 5 = ",null,{"$f":"'AP sortie'!E10","v":0},{"$f":"'Caisse 1'!B17","v":0},"bilets  de 500 Euros =",{"$f":"'Caisse 1'!F17","v":0}]
["TOTAL = ",null,{"$f":"SUM(C23:C29)","v":0},"TOTAL = ",null,{"$f":"'Caisse 1'!F18","v":0}]
[]
[{"$f":"IF('AP sortie'!E11<>0, (\"Attention : Déficit présent pour un montant de \"&'AP sortie'!E11&\" \"&\"Euro\"),\"\")","v":""}]
[]
["Nous étant fait présenter immédiatement le Journal-Centralisateur du Comptable, nous avons arrêté:"]
[]
["La recette à la somme de :"]
[{"$f":"ConvNumberLetter(('AP sortie'!C14-'AP sortie'!C11),1,1)","v":" Euro "}]
["La dépense à la somme de :"]
[{"$f":"ConvNumberLetter('AP sortie'!D14,1,1)","v":" Euro "}]
["L'excédent de la recette sur la dépense à celle de:"]
[{"$f":"ConvNumberLetter(('AP sortie'!E14-'AP sortie'!E11),1,1)","v":" Euro "}]
[]
[{"$f":"\"Après quoi, nous avons clos et arrêté le présent procès-verbal que \"&IF(Gestionnaires!C8=\"Monsieur\",\"le\",\"la\")&\" \"&\"Comptable a signé avec nous.\"","v":"Après quoi, nous avons clos et arrêté le présent procès-verbal que la Comptable a signé avec nous."}]
[]
[{"$f":"\"Fait à\"&\" \"&LOOKUP(\"X\",Identification!B2:B344,Identification!G2:G344)&\", le \"& TEXT(Gestionnaires!C17,\"jj/mm/AAAA\")","v":{"$error":"#N/A"}}]
[]
[null,{"$f":"IF(Gestionnaires!C8=\"Monsieur\",\"Le\",\"La\")&\" \"&\"comptable, \"","v":"La comptable, "},null,null,{"$f":"IF(Gestionnaires!C2=\"Monsieur\",\"L'ordonnateur,\",\"L'ordonnatrice,\")","v":"L'ordonnatrice,"}]

{"sheet":"PV de remise-reprise","index":8,"n_rows":127,"n_cols":6,"rows_kept":127,"cut":false,"hidden":false,"merged":[[27,0,27,1],[66,1,66,3],[36,2,36,3],[37,2,37,3],[33,2,33,4],[34,2,34,3],[35,2,35,3],[57,0,57,1],[51,0,51,1],[52,0,52,1],[53,0,53,1],[54,0,54,1],[56,0,56,1],[38,2,38,3],[39,2,39,3],[40,2,40,3],[22,0,22,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[18,0,18,1],[41,2,41,3],[28,0,28,1],[0,0,0,5],[2,0,2,5],[7,0,7,4],[9,0,9,1],[10,0,10,1],[11,0,11,1],[17,0,17,1],[25,0,25,1],[26,0,26,1],[29,0,29,1],[19,0,19,1],[20,0,20,1],[23,0,23,1],[24,0,24,1],[65,1,65,3],[69,1,69,3],[87,2,87,3],[88,2,88,3],[89,2,89,3],[84,2,84,3],[86,2,86,3],[68,1,68,3],[67,1,67,3],[55,0,55,1],[62,1,62,3],[63,1,63,3],[64,1,64,3],[58,0,58,1],[55,2,55,5]]}
["Procès verbal de remise-reprise des comptes"]
[]
[{"$f":"\"Les \"&IF(OR(Gestionnaires!C8=\"Monsieur\", Gestionnaires!C19=\"Monsieur\"),\"soussignés, \",\"soussignées, \")&Gestionnaires!C10&\" \"&UPPER(Gestionnaires!C9)&\", comptable \"&IF(Gestionnaires!C8=\"Monsieur\",\"sortant \",\"sortante \")&\"de l'établissement \"&LOOKUP(\"X\",Identification!B2:B344,Identification!D2:D344)&\" et \"&Gestionnaires!C21&\" \"&UPPER(Gestionnaires!C20)&\", successeur, ont procédé à la remise et à la reprise des comptes de l'établissement précité qui, en date du \"&TEXT(Gestionnaires!C12,\"jj/mm/aaaa\")&\", ont été établis comme suit :\"","v":{"$error":"#N/A"}}]
[]
[]
["I.  LIVRE CENTRALISATEUR"]
[]
["Livres centralisateurs"]
[null,null,"Recettes","Dépenses","Solde remis"]
["Caisse",null,{"$f":"'AP sortie'!C4","v":0},{"$f":"'AP sortie'!D4","v":0},{"$f":"'AP sortie'!E4","v":0}]
["Dotation",null,{"$f":"'AP sortie'!C5","v":0},{"$f":"'AP sortie'!D5","v":0},{"$f":"'AP sortie'!E5","v":0}]
["Placement 1",null,{"$f":"'AP sortie'!C6","v":0},{"$f":"'AP sortie'!D6","v":0},{"$f":"'AP sortie'!E6","v":0}]
["Placement 2",null,{"$f":"'AP sortie'!C7","v":0},{"$f":"'AP sortie'!D7","v":0},{"$f":"'AP sortie'!E7","v":0}]
["Placement 3",null,{"$f":"'AP sortie'!C8","v":0},{"$f":"'AP sortie'!D8","v":0},{"$f":"'AP sortie'!E8","v":0}]
["Placement 4",null,{"$f":"'AP sortie'!C9","v":0},{"$f":"'AP sortie'!D9","v":0},{"$f":"'AP sortie'!E9","v":0}]
["Placement 5",null,{"$f":"'AP sortie'!C10","v":0},{"$f":"'AP sortie'!D10","v":0},{"$f":"'AP sortie'!E10","v":0}]
["Deficit (-)",null,{"$f":"'AP sortie'!C11","v":0},{"$f":"'AP sortie'!D11","v":0},{"$f":"'AP sortie'!E11","v":0}]
["Sous-totaux",null,{"$f":"'AP sortie'!C12-'AP sortie'!C11","v":0},{"$f":"'AP sortie'!D12-'AP sortie'!D11","v":0},{"$f":"'AP sortie'!E12-'AP sortie'!E11","v":0}]
["Mouvements de fonds",null,{"$f":"'AP sortie'!C13","v":0},{"$f":"'AP sortie'!D13","v":0},{"$f":"'AP sortie'!E13","v":0}]
["Totaux",null,{"$f":"C18-C19","v":0},{"$f":"D18-D19","v":0},0]
[]
["Opérations courantes",null,{"$f":"SUM(C23:C24)","v":0},{"$f":"SUM(D23:D24)","v":0},{"$f":"C22-D22","v":0}]
["Intendance",null,{"$f":"'AP sortie'!C16","v":0},{"$f":"'AP sortie'!D16","v":0},{"$f":"'AP sortie'!E16","v":0}]
["Autres",null,{"$f":"'AP sortie'!C17","v":0},{"$f":"'AP sortie'!D17","v":0},{"$f":"'AP sortie'!E17","v":0}]
["Fond de réserve",null,{"$f":"'AP sortie'!C18","v":0},{"$f":"'AP sortie'!D18","v":0},{"$f":"'AP sortie'!E18","v":0}]
["Opérations en capital",null,{"$f":"'AP sortie'!C20","v":0},{"$f":"'AP sortie'!D20","v":0},{"$f":"'AP sortie'!E20","v":0}]
["Opérations pour ordre",null,{"$f":"'AP sortie'!C24","v":0},{"$f":"'AP sortie'!D24","v":0},{"$f":"'AP sortie'!E24","v":0}]
["Sous-totaux",null,{"$f":"'AP sortie 3'!C25","v":0},{"$f":"'AP sortie 3'!D25","v":0},{"$f":"'AP sortie 3'!E25","v":0}]
["Transferts",null,{"$f":"'AP sortie'!C26","v":0},{"$f":"'AP sortie'!D26","v":0},{"$f":"'AP sortie'!E26","v":0}]
["Totaux",null,{"$f":"'AP sortie'!C27","v":0},{"$f":"'AP sortie'!D27","v":0},{"$f":"'AP sortie'!E27","v":0}]
[]
["II. CREANCES A RECOUVRER"]
[]
[null,null,"Créances à recouvrer"]
[null,null,"Opérations courantes",null,{"$f":"'AP sortie'!I4","v":0}]
[null,null,"Intendance",null,{"$f":"'AP sortie'!I5","v":0}]
[null,null,"Autres",null,{"$f":"'AP sortie'!I6","v":0}]
[null,null,"Opérations en capital",null,{"$f":"'AP sortie'!I7","v":0}]
[null,null,"Opérations pour ordre",null,{"$f":"'AP sortie'!I8","v":0}]
[null,null,"Tiers",null,{"$f":"'AP sortie'!I9","v":0}]
[null,null,"Trésor",null,{"$f":"'AP sortie'!I10","v":0}]
[null,null,"Total",null,{"$f":"'AP sortie'!I11","v":0}]
[]
[]
[]
[]
[]
[]
[]
["III. CREANCES A LIQUIDER"]
[]
["Opérations courantes",null,"A honorer","Fact. Impayées","Fact. Ordonnancées","Total"]
["Intendance",null,{"$f":"'AP sortie'!M5","v":0},{"$f":"'AP sortie'!N5","v":0},{"$f":"'AP sortie'!O5","v":0},{"$f":"'AP sortie'!P5","v":0}]
["Autres",null,{"$f":"'AP sortie'!M6","v":0},{"$f":"'AP sortie'!N6","v":0},{"$f":"'AP sortie'!O6","v":0},{"$f":"'AP sortie'!P6","v":0}]
["Opérations en capital",null,{"$f":"'AP sortie'!M7","v":0},{"$f":"'AP sortie'!N7","v":0},{"$f":"'AP sortie'!O7","v":0},{"$f":"'AP sortie'!P7","v":0}]
["Opérations pour ordre"]
["Tiers",null,{"$f":"'AP sortie'!M9","v":0},{"$f":"'AP sortie'!N9","v":0},{"$f":"'AP sortie'!O9","v":0},{"$f":"'AP sortie'!P9","v":0}]
["Trésor",null,{"$f":"'AP sortie'!M10","v":0},{"$f":"'AP sortie'!N10","v":0},{"$f":"'AP sortie'!O10","v":0},{"$f":"'AP sortie'!P10","v":0}]
["Totaux",null,{"$f":"'AP sortie'!M11","v":0},{"$f":"'AP sortie'!N11","v":0},{"$f":"'AP sortie'!O11","v":0},{"$f":"'AP sortie'!P11","v":0}]
[]
["IV. MAGASIN"]
[]
[null,"Stock alimentation",null,null,{"$f":"'AP sortie'!J19","v":0}]
[null,"Stock des produits d'entretien",null,null,{"$f":"'AP sortie'!J20","v":0}]
[null,"Stock de pharmacie",null,null,{"$f":"'AP sortie'!J21","v":0}]
[null,"Stock matériel de bureau",null,null,{"$f":"'AP sortie'!J22","v":0}]
[null,"Stock matières premières",null,null,{"$f":"'AP sortie'!J23","v":0}]
[null,"Stock fournitures scolaires",null,null,{"$f":"'AP sortie'!J24","v":0}]
[null,"Stock autres",null,null,{"$f":"'AP sortie'!J25","v":0}]
[null,"Total",null,null,{"$f":"'AP sortie'!J26","v":0}]
["V.  ENERGIE"]
[]
[]
[null,"Type","Qté","Unité","Prix unitaire","Montant"]
[null,"Mazout",{"$f":"'AP sortie'!M20","v":0},"litres à ",{"$f":"'AP sortie'!O20","v":0},{"$f":"'AP sortie'!P20","v":0}]
[null,"Gaz",{"$f":"'AP sortie'!M21","v":0},null,{"$f":"'AP sortie'!O21","v":0},{"$f":"'AP sortie'!P21","v":0}]
[null,"Charbon",{"$f":"'AP sortie'!M22","v":0},"Kg",{"$f":"'AP sortie'!O22","v":0},{"$f":"'AP sortie'!P22","v":0}]
[null,"Autres  à préciser"]
[null,{"$f":"'AP sortie'!L24","v":0},null,null,null,{"$f":"'AP sortie'!P24","v":0}]
[null,"Total",null,null,null,{"$f":"'AP sortie'!P25","v":0}]
[]
["VI.  AUTRES VALEURS"]
[]
[]
[null,null,"Timbres",null,{"$f":"'AP sortie'!I34","v":0}]
[null,null,"Autres à préciser"]
[null,null,{"$f":"'AP sortie'!G36","v":0},null,{"$f":"'AP sortie'!I36","v":0}]
[null,null,{"$f":"'AP sortie'!G37","v":0},null,{"$f":"'AP sortie'!I37","v":0}]
[null,null,{"$f":"'AP sortie'!G38","v":0},null,{"$f":"'AP sortie'!I38","v":0}]
[null,null,"Total",null,{"$f":"'AP sortie'!I39","v":0}]
["VII.  TICKET"]
[]
[]
[null,null,"Ticket en circulation ",null,{"$f":"'AP sortie'!M33","v":0}]
[]
[]
[]
[]
[{"$f":"\"VIII. BILAN DU \"&TEXT(Gestionnaires!C12,\"jj/mm/aaaa\")","v":"VIII. BILAN DU 00/01/1900"}]
[]
[]
[null,"ACTIF"]
[null,null,"Comptes financiers (I)",null,{"$f":"E20","v":0}]
[null,null,"Créances à recouvrer (II)",null,{"$f":"E42","v":0}]
[null,null,"Magasins et autres (IV+V+VI)",null,{"$f":"E70+F80+E90","v":0}]
[null,null,"Solde négatif",null,{"$f":"IF((E103+E104+E105)-(E112+E113+E114+E115)>0,0,ABS((E103+E104+E105)-(E112+E113+E114+E115)))","v":0}]
[null,null,"TOTAL",null,{"$f":"SUM(E103:E106)","v":0}]
[]
[]
[]
[null,"PASSIF"]
[null,null,"Pensions anticipatives",null,{"$f":"'AP sortie'!I14","v":0}]
[null,null,"Comptes créditeurs",null,{"$f":"'AP sortie'!N14","v":0}]
[null,null,"Tickets en circulation (VII)",null,{"$f":"'AP sortie'!M33","v":0}]
[null,null,"Créances à liquider (III)",null,{"$f":"'AP sortie'!P11","v":0}]
[null,null,"Solde bénéficiaire",null,{"$f":"IF((E103+E104+E105)-(E112+E113+E114+E115)<0,0,ABS((E103+E104+E105)-(E112+E113+E114+E115)))","v":0}]
[null,null,"TOTAL",null,{"$f":"SUM(E112:E116)","v":0}]
[]
[]
[{"$f":"\"Fait à \"&LOOKUP(\"X\",Identification!B2:B344,Identification!G2:G344)&\", le \"&TEXT(Gestionnaires!C17,\"jj/mm/aaaa\")","v":{"$error":"#N/A"}}]
[]
[]
[]
[null,{"$f":"IF(Gestionnaires!C8=\"Monsieur\",\"Le \",\"La \")&\"comptable \"&IF(Gestionnaires!C8=\"Monsieur\",\"sortant,\",\"sortante,\")","v":"La comptable sortante,"},null,null,{"$f":"IF(Gestionnaires!C19=\"Monsieur\",\"Le \",\"La \")&\"comptable \"&IF(Gestionnaires!C19=\"Monsieur\",\"entrant,\",\"entrante,\")","v":"La comptable entrante,"}]
[]
[]
[null,{"$f":" Gestionnaires!C10&\" \"&UPPER(Gestionnaires!C9)","v":" "},null,null,{"$f":" Gestionnaires!C21&\" \"&UPPER(Gestionnaires!C20)","v":" "}]

{"sheet":"Impression Cpte fin de gestion","index":9,"n_rows":131,"n_cols":6,"rows_kept":131,"cut":false,"hidden":false,"merged":[[123,0,123,5],[97,2,97,3],[108,2,108,3],[113,0,113,2],[115,0,115,2],[114,0,114,2],[113,3,113,4],[114,3,114,4],[107,2,107,3],[118,0,118,2],[118,3,118,4],[119,0,119,2],[119,3,119,4],[17,0,17,5],[116,0,116,2],[117,0,117,2],[115,3,115,4],[116,3,116,4],[117,3,117,4],[93,0,93,5],[81,2,81,3],[80,2,80,3],[26,0,26,5],[50,0,50,5],[52,0,52,5],[67,0,67,5],[83,2,83,3],[10,3,10,4],[11,3,11,4],[12,3,12,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4]]}
["Etablissement :",null,{"$f":"LOOKUP(\"X\",Identification!B2:B344,Identification!D2:D344)","v":{"$error":"#N/A"}}]
[]
["Adresse :",null,{"$f":"LOOKUP(\"X\",Identification!B2:B344,Identification!E2:E344)","v":{"$error":"#N/A"}}]
[null,null,{"$f":"LOOKUP(\"X\",Identification!B2:B344,Identification!F2:F344&\" \"&Identification!G2:G344)","v":{"$error":"#N/A"}}]
[]
[]
["Comptes fnanciers",null,"Caisse:",{"$f":"\"---------\"","v":"---------"}]
[null,null,"Dotation 091 :",{"$f":"Gestionnaires!C26","v":0}]
[null,null,"Placement 1 :",{"$f":"Gestionnaires!C27","v":0}]
[null,null,"Placement 2 :",{"$f":"Gestionnaires!C28","v":0}]
[null,null,"Placement 3 :",{"$f":"Gestionnaires!C29","v":0}]
[null,null,"Placement 4 :",{"$f":"Gestionnaires!C30","v":0}]
[null,null,"Placement 5 :",{"$f":"Gestionnaires!C31","v":0}]
[]
[{"$f":" \"Comptable : \"","v":"Comptable : "},{"$f":"Gestionnaires!C10&\" \"&UPPER(Gestionnaires!C9)","v":" "}]
[]
[]
["COMPTE DE FIN DE GESTION"]
[]
[{"$f":"\"Remis par \"&IF(Gestionnaires!C8=\"Monsieur\",\"Monsieur \",\"Madame \")&Gestionnaires!C10&\" \"&Gestionnaires!C9&\" \"&IF(Gestionnaires!C8=\"Monsieur\",\"né le \",\"née le \")&TEXT(Gestionnaires!C16,\"jj/mm/aaaa\")","v":"Remis par Madame   née le 00/01/1900"}]
[]
[{"$f":"IF(Gestionnaires!C8=\"Monsieur\",\"Domicilié : \",\"Domiciliée : \")","v":"Domiciliée : "},{"$f":"Gestionnaires!C13","v":0}]
[null,{"$f":"Gestionnaires!C14&\" \"&UPPER(Gestionnaires!C15)","v":" "}]
[]
["Comptable de ",{"$f":"LOOKUP(\"X\",Identification!B2:B344,Identification!D2:D344)","v":{"$error":"#N/A"}}]
[]
[{"$f":"\"Conformément à l'article 7 de la loi du 29 octobre 1846,  pour les recettes et les dépenses faites par \"&IF(Gestionnaires!C8=\"Monsieur\",\"lui \",\"elle \")&\"pendant l'année \"&RIGHT(TEXT(Gestionnaires!C12,\"jj/mm/aaaa\"),4)&\" jusqu'au \"&TEXT(Gestionnaires!C12,\"jj/mm/aaaa\")&\" inclus.\"","v":"Conformément à l'article 7 de la loi du 29 octobre 1846,  pour les recettes et les dépenses faites par elle pendant l'année 1900 jusqu'au 00/01/1900 inclus."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["A.  Resultat du compte rendu au 31 décembre de l'année précédente"]
[]
[{"$f":"IF(Gestionnaires!C8=\"Monsieur\",\"Le \",\"La \")&\"comptable reporte ici, comme formant le premier article du présent compte, l'excédent des recettes sur les dépenses à la date du 31 décembre \"&Gestionnaires!I8&\" et dont \"&IF(Gestionnaires!C8=\"Monsieur\",\"il \",\"elle \")&\"a été \"&IF(Gestionnaires!C8=\"Monsieur\",\"constaté \",\"constatée \")&\"reliquataire par le compte établi à la même époque et qui a été précédemment adressé à la Cour des Comptes.\"","v":"La comptable reporte ici, comme formant le premier article du présent compte, l'excédent des recettes sur les dépenses à la date du 31 décembre 1899 et dont elle a été constatée reliquataire par le compte établi à la même époque et qui a été précédemment adressé à la Cour des Comptes."}]
[]
[{"$f":" \"Lequel excédent s'élevant à \"&ConvNumberLetter((Reports!D12-Reports!D11),1,1)&\" est représenté par le svaleurs que \"&IF(Gestionnaires!C8=\"Monsieur\",\"le \",\"la \")&\"comptable avait en caisse le 31/12/\"&Gestionnaires!I8&\", à savoir :\"","v":"Lequel excédent s'élevant à  Euro  est représenté par le svaleurs que la comptable avait en caisse le 31/12/1899, à savoir :"}]
[]
[null,null,"Caisse",{"$f":"Reports!D4","v":0}]
[null,null,"Dotation",{"$f":"Reports!D5","v":0}]
[null,null,"Placement 1",{"$f":"Reports!D6","v":0}]
[null,null,"Placement 2",{"$f":"Reports!D7","v":0}]
[null,null,"Placement 3",{"$f":"Reports!D8","v":0}]
[null,null,"Placement 4",{"$f":"Reports!D9","v":0}]
[null,null,"Placement 5",{"$f":"Reports!D10","v":0}]
[null,null,"Total (A)",{"$f":"Reports!D12-Reports!D11","v":0}]
[]
[]
[]
["B. RECETTES"]
[]
[{"$f":"\"Reçu par \"&IF(Gestionnaires!C8=\"Monsieur\",\"le \",\"la \")&\"comptable la somme de \"&ConvNumberLetter(('AP sortie'!C27 -Reports!D27),1,1)&\"  représentant les recouvrements effectués pendant l'année \"&Gestionnaires!H2&\" sur les Services à gestion séparées de l'Enseignement :\"","v":"Reçu par la comptable la somme de  Euro   représentant les recouvrements effectués pendant l'année 1900 sur les Services à gestion séparées de l'Enseignement :"}]
[]
[]
[null,null,"Opérations courantes",null,{"$f":"'AP sortie'!C19-Reports!D19","v":0}]
[null,null,null,"Intendance",{"$f":"'AP sortie'!C16-Reports!D16","v":0}]
[null,null,null,"Autres",{"$f":"('AP sortie'!C17-Reports!D17)+('AP sortie'!C18-Reports!D18)","v":0}]
[]
[null,null,"Opérations en capital",null,{"$f":"'AP sortie'!C20-Reports!D20","v":0}]
[]
[null,null,"Opérations pour ordre",null,{"$f":"'AP sortie'!C24-Reports!D24","v":0}]
[null,null,null,"Tiers",{"$f":"'AP sortie'!C22-Reports!D22","v":0}]
[null,null,null,"Trésor",{"$f":"'AP sortie'!C23-Reports!D23","v":0}]
[]
[null,null,"Transferts",null,{"$f":"'AP sortie'!C26","v":0}]
[null,null,"TOTAL (B)",null,{"$f":"'AP sortie'!C27-Reports!D27","v":0}]
[]
[null,null,{"$f":"\"Déficit en \"&Gestionnaires!H2&\" :\"","v":"Déficit en 1900 :"},null,{"$f":"'AP sortie'!C11-Reports!D11","v":0},{"$f":"\"*\"","v":"*"}]
[]
[]
[]
[]
[]
[]
[]
["C. DEPENSES"]
[]
[{"$f":"\"Dépensé par \"&IF(Gestionnaires!C33=\"Monsieur\",\"le \",\"la \")&\"comptable la somme de \"&ConvNumberLetter('AP sortie'!D27,1,1)&\" euros se décomposant comme suit :\"","v":"Dépensé par la comptable la somme de  Euro  euros se décomposant comme suit :"}]
[]
[]
[]
[null,null,"Opérations courantes",null,{"$f":"'AP sortie'!D19","v":0}]
[null,null,null,"Intendance",{"$f":"'AP sortie'!D16","v":0}]
[null,null,null,"Autres",{"$f":"'AP sortie'!D17+'AP sortie'!D18","v":0}]
[]
[null,null,"Opérations en capital",null,{"$f":"'AP sortie'!D20","v":0}]
[]
[null,null,"Opérations pour ordre",null,{"$f":"'AP sortie'!D24","v":0}]
[null,null,null,"Tiers",{"$f":"'AP sortie'!D22","v":0}]
[null,null,null,"Trésor",{"$f":"'AP sortie'!D23","v":0}]
[]
[null,null,"Transferts",null,{"$f":"'AP sortie'!D26","v":0}]
[null,null,"TOTAL (C)",null,{"$f":"'AP sortie'!D27","v":0}]
[]
[]
["D. RESULTATS"]
[]
["Valeurs existant en caisse au 31 décembre d e l'année précédente :",null,null,{"$f":"D62","v":0},null,"(A)"]
[{"$f":"\" + Recettes pendant l'année \"&Gestionnaires!H2&\" :\"","v":" + Recettes pendant l'année 1900 :"},null,null,{"$f":"E82","v":0},null,"(B)"]
["Total des sommes à justifier :",null,null,{"$f":"SUM(D114:E115)","v":0}]
[{"$f":"\" - Dépenses pendant l'année \"&Gestionnaires!H2&\" :\"","v":" - Dépenses pendant l'année 1900 :"},null,null,{"$f":"E109","v":0},null,"(C)"]
[{"$f":"\"Excédent des recettes sur les dépenses :\"","v":"Excédent des recettes sur les dépenses :"},null,null,{"$f":"D116-D117","v":0}]
[{"$f":"\"- Déficit en \"&Gestionnaires!H2&\" :\"","v":"- Déficit en 1900 :"},null,null,{"$f":"E84","v":0},null,{"$f":"\"*\"","v":"*"}]
["Réalité de la trésorie :",null,null,{"$f":"D118-D119","v":0}]
[]
[]
[{"$f":"IF(Gestionnaires!C8=\"Monsieur\",\"Le \",\"La \")&IF(Gestionnaires!C33=\"Monsieur\",\"soussigné, \",\"soussignée, \")&Gestionnaires!C10&\" \"&Gestionnaires!C9&\" \"&\"comptable de \"&LOOKUP(\"X\",Identification!B2:B344,Identification!D2:D344)&\",\"","v":{"$error":"#N/A"}}]
[{"$f":"\"affirme sous peine de droit, véritable dans toutes ses parties, le présent compte qui est le résumé des recettes et des dépenses effectuées par \"&IF(Gestionnaires!C8=\"Monsieur\",\"lui \",\"elle \")&\" pendant la durée de sa gestion.\"","v":"affirme sous peine de droit, véritable dans toutes ses parties, le présent compte qui est le résumé des recettes et des dépenses effectuées par elle  pendant la durée de sa gestion."}]
[]
[]
[{"$f":"\"Fait à  \"&LOOKUP(\"X\",Identification!B2:B344,Identification!G2:G344&\", \"&\"le \"&TEXT(Gestionnaires!C17,\"jj/mm/aaaa\"))","v":{"$error":"#N/A"}},null,null,null,{"$f":"IF(Gestionnaires!C8=\"Monsieur\",\"Le \",\"La \") &\"comptable,\"","v":"La comptable,"}]
[]
[]
[]
["E. REMARQUES EVENTUELLES (Manuscrites) :"]

{"sheet":"Caisse 2","index":10,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[3,8,6,13],[8,8,9,13],[13,5,13,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[17,1,17,4],[17,5,17,6],[12,5,12,6],[0,0,0,7],[2,5,2,6],[3,5,3,6],[4,5,4,6],[5,5,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6]]}
[{"$f":"\"Encodage de la caisse à la date du \"&TEXT(Gestionnaires!F12,\"jj/mm/aaaa\")","v":"Encodage de la caisse à la date du 00/01/1900"}]
[]
[null,0,"x",1,"cents =",{"$f":"(B3*D3)/100","v":0}]
[null,0,"x",2,"cents =",{"$f":"(B4*D4)/100","v":0},null,null,{"$f":"\"Renseignez ici les devises contenues en caisse à la date du \"&TEXT(Gestionnaires!F12,\"jj/mm/aaaa\")&\" jour de sortie de \"&Gestionnaires!F8&\" \"&Gestionnaires!F10&\" \"\n&UPPER(Gestionnaires!F9)","v":"Renseignez ici les devises contenues en caisse à la date du 00/01/1900 jour de sortie de   "}]
[null,0,"x",5,"cents =",0]
[null,0,"x",10,"cents =",0]
[null,0,"x",20,"cents =",0]
[null,0,"x",50,"cents =",0]
[null,0,"x",1,"Euro =",{"$f":"B9*D9","v":0},null,null,"Ne complétez que la colonne bleue"]
[null,0,"x",2,"Euros =",0]
[null,0,"x",5,"Euros =",0]
[null,0,"x",10,"Euros =",0]
[null,0,"x",20,"Euros =",0]
[null,0,"x",50,"Euros =",0]
[null,0,"x",100,"Euros =",0]
[null,0,"x",200,"Euros =",0]
[null,0,"x",500,"Euros =",0]
[null,"Total",null,null,null,{"$f":"SUM(F3:F17)","v":0}]

{"sheet":"AP sortie 2","index":11,"n_rows":32,"n_cols":16,"rows_kept":32,"cut":false,"hidden":false,"merged":[[26,0,26,1],[15,11,15,15],[2,0,2,1],[18,0,18,1],[22,0,22,1],[18,6,18,8],[19,0,19,1],[19,6,19,8],[9,0,9,1],[9,6,9,7],[9,10,9,11],[17,0,17,1],[17,6,17,8],[10,0,10,1],[10,6,10,7],[10,10,10,11],[31,6,31,7],[20,11,20,15],[25,6,25,8],[26,6,26,7],[25,11,25,12],[27,6,27,8],[23,6,23,8],[20,6,20,8],[22,11,22,14],[22,6,22,8],[21,6,21,8],[25,0,25,1],[21,0,21,1],[24,0,24,1],[23,0,23,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[15,0,15,1],[0,0,0,15],[1,0,1,4],[2,6,2,8],[2,10,2,15],[3,0,3,1],[3,6,3,7],[3,10,3,11],[4,0,4,1],[4,6,4,7],[4,10,4,11],[5,0,5,1],[5,6,5,7],[5,10,5,11],[15,6,15,9],[16,0,16,1],[16,6,16,8],[6,10,6,11],[7,0,7,1],[7,6,7,7],[7,10,7,11],[8,0,8,1],[8,6,8,7],[8,10,8,11],[6,6,6,7],[6,0,6,1],[13,10,13,11],[13,6,13,7]]}
[{"$f":"\"Etat des comptes et des avoirs à la date du \"&TEXT(Gestionnaires!F12,\"jj/mm/aaaa\")","v":"Etat des comptes et des avoirs à la date du 00/01/1900"}]
[{"$f":" \"Compte jaune du \"&TEXT(Gestionnaires!F12,\"jj/mm/aaaa\")","v":"Compte jaune du 00/01/1900"}]
[null,null,"Recettes","Dépenses","Solde remis",null,"Créances à recouvrer",null,null,null,"Créances à liquider"]
["Caisse",null,0,0,{"$f":"C4-D4","v":0},null,"Opérations courantes",null,{"$f":"SUM(I5:I6)","v":0},null,"Opérations courantes",null,"A honorer","Fact. Impayées","Fact. Ordonnancées","Total"]
["Dotation",null,0,0,{"$f":"C5-D5","v":0},null,"Intendance",null,0,null,"Intendance",null,0,0,0,{"$f":"SUM(M5:O5)","v":0}]
["Placement 1",null,0,0,0,null,"Autres",null,0,null,"Autres",null,0,0,0,{"$f":"SUM(M6:O6)","v":0}]
["Placement 2",null,0,0,0,null,"Opérations en capital",null,0,null,"Opérations en capital",null,0,0,0,0]
["Placement 3",null,0,0,0,null,"Opérations pour ordre",null,{"$f":"SUM(I9:I10)","v":0},null,"Opérations pour ordre"]
["Placement 4",null,0,0,0,null,"Tiers",null,0,null,"Tiers",null,0,0,0,0]
["Placement 5",null,0,0,0,null,"Trésor",null,0,null,"Trésor",null,0,0,0,0]
["PV déficit",null,0,0,0,null,"Total",null,{"$f":"SUM(I5,I6,I7,I9,I10,)","v":0},null,"Total",null,{"$f":"SUM(M5:M10)","v":0},{"$f":"SUM(N5:N10)","v":0},{"$f":"SUM(O5:O10)","v":0},{"$f":"SUM(P5:P10)","v":0}]
["Sous-totaux",null,{"$f":"SUM(C4:C11)","v":0},{"$f":"SUM(D4:D11)","v":0},0]
["Mouvements de fonds",null,0,0,0,null,null,null,null,null,null,null,"Total","hors pensions"]
["Totaux",null,{"$f":"C12-C13","v":0},{"$f":"D12-D13","v":0},0,null,"Pensions anticipatives",null,0,null,"Comptes créditeurs",null,0,{"$f":"M14-I14","v":0}]
["Opérations courantes"]
["Intendance",null,0,0,{"$f":"C16-D16","v":0},null,"Magasin",null,null,null,null,"Energie"]
["Fonctionnement",null,0,0,{"$f":"C17-D17","v":0},null,"Stock alimentation",null,null,0,null,"Type","Qté","Unité","Prix unitaire","Montant"]
["Fond de réserve",null,0,0,{"$f":"C18-D18","v":0},null,"Stock des produits d'entretien",null,null,0,null,"Mazout",0,"litres à ",0,{"$f":"M18*O18","v":0}]
["Total OC",null,{"$f":"SUM(C16:C18)","v":0},{"$f":"SUM(D16:D18)","v":0},{"$f":"C19-D19","v":0},null,"Stock de pharmacie",null,null,0,null,"Gaz",null,"litres à ",null,{"$f":"M19*O19","v":0}]
["Opérations en capital",null,0,0,{"$f":"C20-D20","v":0},null,"Stock matériel de bureau",null,null,0,null,"Charbon",null,"Kg",null,{"$f":"M20*O20","v":0}]
["Opérations pour ordre",null,null,null,null,null,"Stock matières premières",null,null,0,null,"Autres  à préciser"]
["Tiers",null,0,0,{"$f":"C22-D22","v":0},null,"Stock fournitures sclaires",null,null,0,null,null,null,null,null,0]
["Trésor",null,0,0,0,null,"Stock Autres",null,null,0,null,"Total",null,null,null,{"$f":"SUM(P18:P20,P22)","v":0}]
["Total PO",null,{"$f":"SUM(C22:C23)","v":0},{"$f":"SUM(D22:D23)","v":0},0,null,"Total",null,null,{"$f":"SUM(J17:J23)","v":0}]
["Sous-totaux",null,{"$f":"C19+C20+C24","v":0},{"$f":"D19+D20+D24","v":0},0]
["Transferts",null,0,0,0,null,"Autres valeurs",null,null,null,null,"Tickets en circulation"]
["Totaux",null,{"$f":"C25-C26","v":0},{"$f":"D25-D26","v":0},0,null,"Timbres",null,0,null,null,"Tickets",0]
[null,null,null,null,null,null,"Autres à préciser"]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Total",null,{"$f":"SUM(I27,I29:I31)","v":0}]

{"sheet":"Impression PV caisse (2)","index":12,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[[40,0,40,5],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[29,3,29,4],[33,0,33,5],[36,0,36,5],[38,0,38,5],[31,0,31,5],[22,0,22,1],[0,0,0,1],[5,3,5,4],[6,3,6,4],[9,0,9,5],[12,0,12,5]]}
["Procès-verbal de caisse",null,"du service",{"$f":"LOOKUP(\"X\",Identification!B2:B344,Identification!D2:D344)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"LOOKUP(\"X\",Identification!B2:B344,Identification!E2:E344)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"LOOKUP(\"X\",Identification!B2:B344,Identification!F2:F344&\" \"&Identification!G2:G344)","v":{"$error":"#N/A"}}]
[]
[]
[null,null,{"$f":"Gestionnaires!C2","v":0},{"$f":"IF(C6=\"Monsieur\",\"Ordonnateur\",\"Ordonnatrice\")","v":"Ordonnatrice"},null,{"$f":" Gestionnaires!F8","v":0}]
[{"$f":" \"Le\"&\" \"&TEXT(Gestionnaires!F12,\"jj/mm/AAAA\")","v":"Le 00/01/1900"},{"$f":"\" Nous,\"","v":" Nous,"},{"$f":"Gestionnaires!C5","v":0},"Avons requis",null,{"$f":"Gestionnaires!F10","v":0}]
[null,null,{"$f":"UPPER(Gestionnaires!C4)","v":""},null,null,{"$f":"UPPER(Gestionnaires!F9)","v":""}]
[]
["Comptable de l'établissement repris ci-dessus, de nous présenter les valeurs et autres espèces existant dans sa caisse et avons dressés le bordereau ci-après, à savoir:"]
[]
[]
["NUMERAIRES ET VALEURS"]
[]
[null,null,null,{"$f":"'Caisse 2'!B3","v":0},"Pièces de 1 cent =",{"$f":"'Caisse 2'!F3","v":0}]
[null,null,null,{"$f":"'Caisse 2'!B4","v":0},"Pièces de 2 cents =",{"$f":"'Caisse 2'!F4","v":0}]
[null,null,null,{"$f":"'Caisse 2'!B5","v":0},"Pièces de 5 cents =",{"$f":"'Caisse 2'!F5","v":0}]
[null,null,null,{"$f":"'Caisse 2'!B6","v":0},"Pièces de 10 cents =",{"$f":"'Caisse 2'!F6","v":0}]
[null,null,null,{"$f":"'Caisse 2'!B7","v":0},"Pièces de 20 cents =",{"$f":"'Caisse 2'!F7","v":0}]
[null,null,null,{"$f":"'Caisse 2'!B8","v":0},"Pièces de 50 cents =",{"$f":"'Caisse 2'!F8","v":0}]
[null,null,null,{"$f":"'Caisse 2'!B9","v":0},"Pièces de 1 Euro =",{"$f":"'Caisse 2'!F9","v":0}]
[null,null,null,{"$f":"'Caisse 2'!B10","v":0},"Pièces de 2 Euros =",{"$f":"'Caisse 2'!F10","v":0}]
["Caisse = ",null,{"$f":"'AP sortie 2'!E4","v":0},{"$f":"'Caisse 2'!B11","v":0},"bilets  de 5 Euros =",{"$f":"'Caisse 2'!F11","v":0}]
["Dotation = ",null,{"$f":"'AP sortie 2'!E5","v":0},{"$f":"'Caisse 2'!B12","v":0},"bilets  de 10 Euros =",{"$f":"'Caisse 2'!F12","v":0}]
["Placement 1 = ",null,{"$f":"'AP sortie 2'!E6","v":0},{"$f":"'Caisse 2'!B13","v":0},"bilets  de 20 Euros =",{"$f":"'Caisse 2'!F13","v":0}]
["Placement 2 = ",null,{"$f":"'AP sortie 2'!E7","v":0},{"$f":"'Caisse 2'!B14","v":0},"bilets  de 50 Euros =",{"$f":"'Caisse 2'!F14","v":0}]
["Placement 3 = ",null,{"$f":"'AP sortie 2'!E8","v":0},{"$f":"'Caisse 2'!B15","v":0},"bilets  de 100 Euros =",{"$f":"'Caisse 2'!F15","v":0}]
["Placement 4 = ",null,{"$f":"'AP sortie 2'!E9","v":0},{"$f":"'Caisse 2'!B16","v":0},"bilets  de 200 Euros =",{"$f":"'Caisse 2'!F16","v":0}]
["Placement 5 = ",null,{"$f":"'AP sortie 2'!E10","v":0},{"$f":"'Caisse 2'!B17","v":0},"bilets  de 500 Euros =",{"$f":"'Caisse 2'!F17","v":0}]
["TOTAL = ",null,{"$f":"SUM(C23:C29)","v":0},"TOTAL = ",null,{"$f":"'Caisse 2'!F18","v":0}]
[]
[{"$f":"IF('AP sortie 2'!E11<>0, (\"Attention : Déficit présent pour un montant de \"&'AP sortie 2'!E11&\" \"&\"Euro\"),\"\")","v":""}]
[]
["Nous étant fait présenter immédiatement le Journal-Centralisateur du Comptable, nous avons arrêté:"]
[]
["La recette à la somme de :"]
[{"$f":"ConvNumberLetter(('AP sortie 2'!C14-'AP sortie 2'!C11),1,1)","v":" Euro "}]
["La dépense à la somme de :"]
[{"$f":"ConvNumberLetter('AP sortie 2'!D14,1,1)","v":" Euro "}]
["L'excédent de la recette sur la dépense à celle de:"]
[{"$f":"ConvNumberLetter(('AP sortie 2'!E14-'AP sortie 2'!E11),1,1)","v":" Euro "}]
[]
[{"$f":"\"Après quoi, nous avons clos et arrêté le présent procès-verbal que \"&IF(Gestionnaires!F8=\"Monsieur\",\"le\",\"la\")&\" \"&\"Comptable a signé avec nous.\"","v":"Après quoi, nous avons clos et arrêté le présent procès-verbal que la Comptable a signé avec nous."}]
[]
[{"$f":"\"Fait à\"&\" \"&LOOKUP(\"X\",Identification!B2:B344,Identification!G2:G344)&\", le \"& TEXT(Gestionnaires!F17,\"jj/mm/AAAA\")","v":{"$error":"#N/A"}}]
[]
[null,{"$f":"IF(Gestionnaires!F8=\"Monsieur\",\"Le\",\"La\")&\" \"&\"comptable, \"","v":"La comptable, "},null,null,{"$f":"IF(Gestionnaires!C2=\"Monsieur\",\"L'ordonnateur,\",\"L'ordonnatrice,\")","v":"L'ordonnatrice,"}]

{"sheet":"PV de remise-reprise (2)","index":13,"n_rows":127,"n_cols":6,"rows_kept":127,"cut":false,"hidden":false,"merged":[[89,2,89,3],[62,1,62,3],[63,1,63,3],[64,1,64,3],[65,1,65,3],[66,1,66,3],[84,2,84,3],[86,2,86,3],[87,2,87,3],[88,2,88,3],[68,1,68,3],[69,1,69,3],[67,1,67,3],[58,0,58,1],[57,0,57,1],[37,2,37,3],[38,2,38,3],[39,2,39,3],[40,2,40,3],[41,2,41,3],[51,0,51,1],[52,0,52,1],[53,0,53,1],[54,0,54,1],[55,0,55,1],[56,0,56,1],[55,2,55,5],[36,2,36,3],[20,0,20,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[29,0,29,1],[33,2,33,4],[34,2,34,3],[35,2,35,3],[22,0,22,1],[28,0,28,1],[27,0,27,1],[19,0,19,1],[0,0,0,5],[2,0,2,5],[7,0,7,4],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[18,0,18,1],[17,0,17,1]]}
["Procès verbal de remise-reprise des comptes"]
[]
[{"$f":"\"Les \"&IF(OR(Gestionnaires!F8=\"Monsieur\", Gestionnaires!F19=\"Monsieur\"),\"soussignés, \",\"soussignées, \")&Gestionnaires!F10&\" \"&UPPER(Gestionnaires!F9)&\", comptable \"&IF(Gestionnaires!F8=\"Monsieur\",\"sortant \",\"sortante \")&\"de l'établissement \"&LOOKUP(\"X\",Identification!B2:B344,Identification!D2:D344)&\" et \"&Gestionnaires!F21&\" \"&UPPER(Gestionnaires!F20)&\", successeur, ont procédé à la remise et à la reprise des comptes de l'établissement précité qui, en date du \"&TEXT(Gestionnaires!F12,\"jj/mm/aaaa\")&\", ont été établis comme suit :\"","v":{"$error":"#N/A"}}]
[]
[]
["I.  LIVRE CENTRALISATEUR"]
[]
["Livres centralisateurs"]
[null,null,"Recettes","Dépenses","Solde remis"]
["Caisse",null,{"$f":"'AP sortie 2'!C4","v":0},{"$f":"'AP sortie 2'!D4","v":0},{"$f":"'AP sortie 2'!E4","v":0}]
["Dotation",null,{"$f":"'AP sortie 2'!C5","v":0},{"$f":"'AP sortie 2'!D5","v":0},{"$f":"'AP sortie 2'!E5","v":0}]
["Placement 1",null,{"$f":"'AP sortie 2'!C6","v":0},{"$f":"'AP sortie 2'!D6","v":0},{"$f":"'AP sortie 2'!E6","v":0}]
["Placement 2",null,{"$f":"'AP sortie 2'!C7","v":0},{"$f":"'AP sortie 2'!D7","v":0},{"$f":"'AP sortie 2'!E7","v":0}]
["Placement 3",null,{"$f":"'AP sortie 2'!C8","v":0},{"$f":"'AP sortie 2'!D8","v":0},{"$f":"'AP sortie 2'!E8","v":0}]
["Placement 4",null,{"$f":"'AP sortie 2'!C9","v":0},{"$f":"'AP sortie 2'!D9","v":0},{"$f":"'AP sortie 2'!E9","v":0}]
["Placement 5",null,{"$f":"'AP sortie 2'!C10","v":0},{"$f":"'AP sortie 2'!D10","v":0},{"$f":"'AP sortie 2'!E10","v":0}]
["Deficit (-)",null,{"$f":"'AP sortie 2'!C11","v":0},{"$f":"'AP sortie 2'!D11","v":0},{"$f":"'AP sortie 2'!E11","v":0}]
["Sous-totaux",null,{"$f":"'AP sortie 2'!C12 -'AP sortie 2'!C11","v":0},{"$f":"'AP sortie 2'!D12 -'AP sortie 2'!D11","v":0},{"$f":"'AP sortie 2'!E12 -'AP sortie 2'!E11","v":0}]
["Mouvements de fonds",null,{"$f":"'AP sortie 2'!C13","v":0},{"$f":"'AP sortie 2'!D13","v":0},{"$f":"'AP sortie 2'!E13","v":0}]
["Totaux",null,{"$f":"C18-C19","v":0},{"$f":"D18-D19","v":0},0]
[]
["Opérations courantes",null,{"$f":"SUM(C23:C24)","v":0},{"$f":"SUM(D23:D24)","v":0},{"$f":"C22-D22","v":0}]
["Intendance",null,{"$f":"'AP sortie 2'!C16","v":0},{"$f":"'AP sortie 2'!D16","v":0},{"$f":"'AP sortie 2'!E16","v":0}]
["Autres",null,{"$f":"'AP sortie 2'!C17","v":0},{"$f":"'AP sortie 2'!D17","v":0},{"$f":"'AP sortie 2'!E17","v":0}]
["Fond de réserve",null,{"$f":"'AP sortie 2'!C18","v":0},{"$f":"'AP sortie 2'!D18","v":0},{"$f":"'AP sortie 2'!E18","v":0}]
["Opérations en capital",null,{"$f":"'AP sortie 2'!C20","v":0},{"$f":"'AP sortie 2'!D20","v":0},{"$f":"'AP sortie 2'!E20","v":0}]
["Opérations pour ordre",null,{"$f":"'AP sortie 2'!C24","v":0},{"$f":"'AP sortie 2'!D24","v":0},{"$f":"'AP sortie 2'!E24","v":0}]
["Sous-totaux",null,{"$f":"'AP sortie 2'!C25","v":0},{"$f":"'AP sortie 2'!D25","v":0},{"$f":"'AP sortie 2'!E25","v":0}]
["Transferts",null,{"$f":"'AP sortie 2'!C26","v":0},{"$f":"'AP sortie 2'!D26","v":0},{"$f":"'AP sortie 2'!E26","v":0}]
["Totaux",null,{"$f":"'AP sortie 2'!C27","v":0},{"$f":"'AP sortie 2'!D27","v":0},{"$f":"'AP sortie 2'!E27","v":0}]
[]
["II. CREANCES A RECOUVRER"]
[]
[null,null,"Créances à recouvrer"]
[null,null,"Opérations courantes",null,{"$f":"'AP sortie 2'!I4","v":0}]
[null,null,"Intendance",null,{"$f":"'AP sortie 2'!I5","v":0}]
[null,null,"Autres",null,{"$f":"'AP sortie 2'!I6","v":0}]
[null,null,"Opérations en capital",null,{"$f":"'AP sortie 2'!I7","v":0}]
[null,null,"Opérations pour ordre",null,{"$f":"'AP sortie 2'!I8","v":0}]
[null,null,"Tiers",null,{"$f":"'AP sortie 2'!I9","v":0}]
[null,null,"Trésor",null,{"$f":"'AP sortie 2'!I10","v":0}]
[null,null,"Total",null,{"$f":"'AP sortie 2'!I11","v":0}]
[]
[]
[]
[]
[]
[]
[]
["III. CREANCES A LIQUIDER"]
[]
["Opérations courantes",null,"A honorer","Fact. Impayées","Fact. Ordonnancées","Total"]
["Intendance",null,{"$f":"'AP sortie 2'!M5","v":0},{"$f":"'AP sortie 2'!N5","v":0},{"$f":"'AP sortie 2'!O5","v":0},{"$f":"'AP sortie 2'!P5","v":0}]
["Autres",null,{"$f":"'AP sortie 2'!M6","v":0},{"$f":"'AP sortie 2'!N6","v":0},{"$f":"'AP sortie 2'!O6","v":0},{"$f":"'AP sortie 2'!P6","v":0}]
["Opérations en capital",null,{"$f":"'AP sortie 2'!M7","v":0},{"$f":"'AP sortie 2'!N7","v":0},{"$f":"'AP sortie 2'!O7","v":0},{"$f":"'AP sortie 2'!P7","v":0}]
["Opérations pour ordre"]
["Tiers",null,{"$f":"'AP sortie 2'!M9","v":0},{"$f":"'AP sortie 2'!N9","v":0},{"$f":"'AP sortie 2'!O9","v":0},{"$f":"'AP sortie 2'!P9","v":0}]
["Trésor",null,{"$f":"'AP sortie 2'!M10","v":0},{"$f":"'AP sortie 2'!N10","v":0},{"$f":"'AP sortie 2'!O10","v":0},{"$f":"'AP sortie 2'!P10","v":0}]
["Total",null,{"$f":"'AP sortie 2'!M11","v":0},{"$f":"'AP sortie 2'!N11","v":0},{"$f":"'AP sortie 2'!O11","v":0},{"$f":"'AP sortie 2'!P11","v":0}]
[]
["IV. MAGASIN"]
[]
[null,"Stock alimentation",null,null,{"$f":"'AP sortie 2'!J17","v":0}]
[null,"Stock des produits d'entretien",null,null,{"$f":"'AP sortie 2'!J18","v":0}]
[null,"Stock de pharmacie",null,null,{"$f":"'AP sortie 2'!J19","v":0}]
[null,"Stock matériel de bureau",null,null,{"$f":"'AP sortie 2'!J20","v":0}]
[null,"Stock matières premières",null,null,{"$f":"'AP sortie 2'!J21","v":0}]
[null,"Stock fournitures scolaires",null,null,{"$f":"'AP sortie 2'!J22","v":0}]
[null,"Stock autres",null,null,{"$f":"'AP sortie 2'!J23","v":0}]
[null,"Total",null,null,{"$f":"'AP sortie 2'!J24","v":0}]
["V.  ENERGIE"]
[]
[]
[null,"Type","Qté","Unité","Prix unitaire","Montant"]
[null,"Mazout",{"$f":"'AP sortie 2'!M18","v":0},"litres à ",{"$f":"'AP sortie 2'!O18","v":0},{"$f":"'AP sortie 2'!P18","v":0}]
[null,"Gaz",{"$f":"'AP sortie 2'!M19","v":0},null,{"$f":"'AP sortie 2'!O19","v":0},{"$f":"'AP sortie 2'!P19","v":0}]
[null,"Charbon",{"$f":"'AP sortie 2'!M20","v":0},"Kg",{"$f":"'AP sortie 2'!O20","v":0},{"$f":"'AP sortie 2'!P20","v":0}]
[null,"Autres  à préciser"]
[null,{"$f":"'AP sortie 2'!L22","v":0},null,null,null,{"$f":"'AP sortie 2'!P22","v":0}]
[null,"Total",null,null,null,{"$f":"'AP sortie 2'!P23","v":0}]
[]
["VI.  AUTRES VALEURS"]
[]
[]
[null,null,"Timbres",null,{"$f":"'AP sortie 2'!I27","v":0}]
[null,null,"Autres à préciser"]
[null,null,{"$f":"'AP sortie 2'!G29","v":0},null,{"$f":"'AP sortie 2'!I29","v":0}]
[null,null,{"$f":"'AP sortie 2'!G30","v":0},null,{"$f":"'AP sortie 2'!I30","v":0}]
[null,null,{"$f":"'AP sortie 2'!G31","v":0},null,{"$f":"'AP sortie 2'!I31","v":0}]
[null,null,"Total",null,{"$f":"'AP sortie 2'!I32","v":0}]
["VII.  TICKET"]
[]
[]
[null,null,"Ticket en circulation ",null,{"$f":"'AP sortie 2'!M27","v":0}]
[]
[]
[]
[]
[{"$f":"\"VIII. BILAN DU \"&TEXT(Gestionnaires!F12,\"jj/mm/aaaa\")","v":"VIII. BILAN DU 00/01/1900"}]
[]
[]
[null,"ACTIF"]
[null,null,"Comptes financiers (I)",null,{"$f":"E20","v":0}]
[null,null,"Créances à recouvrer (II)",null,{"$f":"E42","v":0}]
[null,null,"Magasins et autres (IV+V+VI)",null,{"$f":"E70+F80+E90","v":0}]
[null,null,"Solde négatif",null,{"$f":"IF((E103+E104+E105)-(E112+E113+E114+E115)>0,0,ABS((E103+E104+E105)-(E112+E113+E114+E115)))","v":0}]
[null,null,"TOTAL",null,{"$f":"SUM(E103:E106)","v":0}]
[]
[]
[]
[null,"PASSIF"]
[null,null,"Pensions anticipatives",null,{"$f":"'AP sortie 2'!I14","v":0}]
[null,null,"Comptes créditeurs",null,{"$f":"'AP sortie 2'!N14","v":0}]
[null,null,"Tickets en circulation (VII)",null,{"$f":"'AP sortie 2'!M27","v":0}]
[null,null,"Créances à liquider (III)",null,{"$f":"'AP sortie 2'!P11","v":0}]
[null,null,"Solde bénéficiaire",null,{"$f":"IF((E103+E104+E105)-(E112+E113+E114+E115)<0,0,ABS((E103+E104+E105)-(E112+E113+E114+E115)))","v":0}]
[null,null,"TOTAL",null,{"$f":"SUM(E112:E116)","v":0}]
[]
[]
[{"$f":"\"Fait à \"&LOOKUP(\"X\",Identification!B2:B344,Identification!G2:G344)&\", le \"&TEXT(Gestionnaires!F17,\"jj/mm/aaaa\")","v":{"$error":"#N/A"}}]
[]
[]
[]
[null,{"$f":"IF(Gestionnaires!F8=\"Monsieur\",\"Le \",\"La \")&\"comptable \"&IF(Gestionnaires!F8=\"Monsieur\",\"sortant,\",\"sortante,\")","v":"La comptable sortante,"},null,null,{"$f":"IF(Gestionnaires!F19=\"Monsieur\",\"Le \",\"La \")&\"comptable \"&IF(Gestionnaires!F19=\"Monsieur\",\"entrant,\",\"entrante,\")","v":"La comptable entrante,"}]
[]
[]
[null,{"$f":" Gestionnaires!F10&\" \"&UPPER(Gestionnaires!F9)","v":" "},null,null,{"$f":" Gestionnaires!F21&\" \"&UPPER(Gestionnaires!F20)","v":" "}]

{"sheet":"Impression Cpte fin de gest (2)","index":14,"n_rows":130,"n_cols":7,"rows_kept":130,"cut":false,"hidden":false,"merged":[[118,0,118,2],[118,3,118,4],[119,0,119,2],[119,3,119,4],[117,0,117,2],[117,3,117,4],[122,0,122,6],[69,2,70,2],[69,3,70,3],[69,4,70,4],[114,0,114,2],[114,3,114,4],[115,0,115,2],[115,3,115,4],[116,0,116,2],[116,3,116,4],[82,0,82,1],[93,0,93,6],[97,0,97,1],[108,0,108,1],[113,0,113,2],[113,3,113,4],[67,0,67,6],[81,0,81,1],[107,0,107,1],[84,0,84,1],[11,3,11,4],[95,2,96,2],[95,3,96,3],[95,4,96,4],[12,3,12,4],[17,0,17,6],[26,0,26,6],[50,0,50,6],[52,0,52,6],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4]]}
["Etablissement :",null,{"$f":"LOOKUP(\"X\",Identification!B2:B344,Identification!D2:D344)","v":{"$error":"#N/A"}}]
[]
["Adresse :",null,{"$f":"LOOKUP(\"X\",Identification!B2:B344,Identification!E2:E344)","v":{"$error":"#N/A"}}]
[null,null,{"$f":"LOOKUP(\"X\",Identification!B2:B344,Identification!F2:F344&\" \"&Identification!G2:G344)","v":{"$error":"#N/A"}}]
[]
[]
["Comptes fnanciers",null,"Caisse:",{"$f":"\"---------\"","v":"---------"}]
[null,null,"Dotation 091 :",{"$f":"Gestionnaires!C26","v":0}]
[null,null,"Placement 1 :",{"$f":"Gestionnaires!C27","v":0}]
[null,null,"Placement 2 :",{"$f":"Gestionnaires!C28","v":0}]
[null,null,"Placement 3 :",{"$f":"Gestionnaires!C29","v":0}]
[null,null,"Placement 4 :",{"$f":"Gestionnaires!C30","v":0}]
[null,null,"Placement 5 :",{"$f":"Gestionnaires!C31","v":0}]
[]
[{"$f":" \"Comptable : \"","v":"Comptable : "},{"$f":"Gestionnaires!F10&\" \"&UPPER(Gestionnaires!F9)","v":" "}]
[]
[]
["COMPTE DE FIN DE GESTION"]
[]
[{"$f":"\"Remis par \"&IF(Gestionnaires!F8=\"Monsieur\",\"Monsieur \",\"Madame \")&Gestionnaires!F10&\" \"&Gestionnaires!F9&\" \"&IF(Gestionnaires!F8=\"Monsieur\",\"né le \",\"née le \")&TEXT(Gestionnaires!F16,\"jj/mm/aaaa\")","v":"Remis par Madame   née le 00/01/1900"}]
[]
[{"$f":"IF(Gestionnaires!F8=\"Monsieur\",\"Domicilié : \",\"Domiciliée : \")","v":"Domiciliée : "},{"$f":" Gestionnaires!F13","v":0}]
[null,{"$f":"Gestionnaires!F14&\" \"&UPPER(Gestionnaires!F15)","v":" "}]
[]
["Comptable de ",{"$f":"LOOKUP(\"X\",Identification!B2:B344,Identification!D2:D344)","v":{"$error":"#N/A"}}]
[]
[{"$f":"\"Conformément à l'article 7 de la loi du 29 octobre 1846,  pour les recettes et les dépenses faites par \"&IF(Gestionnaires!F8=\"Monsieur\",\"lui \",\"elle \")&\"pendant l'année \"&RIGHT(TEXT(Gestionnaires!F12,\"jj/mm/aaaa\"),4)&\" du \"&TEXT((Gestionnaires!C12+1),\"jj/mm/aaaa\")&\" jusqu'au \"&TEXT((Gestionnaires!F12),\"jj/mm/aaaa\")&\" inclus.\"","v":"Conformément à l'article 7 de la loi du 29 octobre 1846,  pour les recettes et les dépenses faites par elle pendant l'année 1900 du 01/01/1900 jusqu'au 00/01/1900 inclus."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["A.  Resultat du compte rendu au 31 décembre de l'année précédente"]
[]
[{"$f":"IF(Gestionnaires!F8=\"Monsieur\",\"Le \",\"La \")&\"comptable reporte ici, comme formant le premier article du présent compte, l'excédent des recettes sur les dépenses à la date du 31 décembre \"&Gestionnaires!I8&\" et dont \"&IF(Gestionnaires!F8=\"Monsieur\",\"il \",\"elle \")&\"a été \"&IF(Gestionnaires!F8=\"Monsieur\",\"constaté \",\"constatée \")&\"reliquataire par le compte établi à la même époque et qui a été précédemment adressé à la Cour des Comptes.\"","v":"La comptable reporte ici, comme formant le premier article du présent compte, l'excédent des recettes sur les dépenses à la date du 31 décembre 1899 et dont elle a été constatée reliquataire par le compte établi à la même époque et qui a été précédemment adressé à la Cour des Comptes."}]
[]
[{"$f":" \"Lequel excédent s'élevant à \"&ConvNumberLetter(Reports!D12-Reports!D11,1,1)&\" euros est représenté par les valeurs que \"&IF(Gestionnaires!F8=\"Monsieur\",\"le \",\"la \")&\"comptable avait en caisse le 31/12/\"&Gestionnaires!I8&\", à savoir :\"","v":"Lequel excédent s'élevant à  Euro  euros est représenté par les valeurs que la comptable avait en caisse le 31/12/1899, à savoir :"}]
[]
[null,null,"Caisse",{"$f":"Reports!D4","v":0}]
[null,null,"Dotation",{"$f":"Reports!D5","v":0}]
[null,null,"Placement 1",{"$f":"Reports!D6","v":0}]
[null,null,"Placement 2",{"$f":"Reports!D7","v":0}]
[null,null,"Placement 3",{"$f":"Reports!D8","v":0}]
[null,null,"Placement 4",{"$f":"Reports!D9","v":0}]
[null,null,"Placement 5",{"$f":"Reports!D10","v":0}]
[null,null,"Total (A)",{"$f":"Reports!D12-Reports!D11","v":0}]
[]
[]
[]
["B. RECETTES"]
[]
[{"$f":"\"Reçu par \"&IF(Gestionnaires!F8=\"Monsieur\",\"le \",\"la \")&\"comptable la somme de \"&ConvNumberLetter(('AP sortie 2'!C27-Reports!D27),1,1)&\" euros représentant les recouvrements effectués pendant l'année \"&Gestionnaires!H2&\" sur les Services à gestion séparées de l'Enseignement :\"","v":"Reçu par la comptable la somme de  Euro  euros représentant les recouvrements effectués pendant l'année 1900 sur les Services à gestion séparées de l'Enseignement :"}]
[]
[null,null,{"$f":"\"Rem-rep du \"&TEXT(Gestionnaires!C12,\"jj/mm/aaaa\")","v":"Rem-rep du 00/01/1900"},{"$f":"\"Rem-rep du \"&TEXT(Gestionnaires!F12,\"jj/mm/aaaa\")","v":"Rem-rep du 00/01/1900"},"Total"]
[]
["Opérations courantes",null,{"$f":"'Impression Cpte fin de gestion'!E71","v":0},{"$f":"E72-C72","v":0},{"$f":"'AP sortie 2'!C19-Reports!D19","v":0}]
[null,"Intendance",{"$f":"'Impression Cpte fin de gestion'!E72","v":0},{"$f":"E73-C73","v":0},{"$f":"'AP sortie 2'!C16-Reports!D16","v":0}]
[null,"Autres",{"$f":"'Impression Cpte fin de gestion'!E73","v":0},0,{"$f":"('AP sortie 2'!C17-Reports!D17)+('AP sortie 2'!C18-Reports!D18)","v":0}]
[]
["Opérations en capital",null,{"$f":"'Impression Cpte fin de gestion'!E75","v":0},0,{"$f":"'AP sortie 2'!C20-Reports!D20","v":0}]
[]
["Opérations pour ordre",null,{"$f":"'Impression Cpte fin de gestion'!E77","v":0},0,{"$f":"'AP sortie 2'!C24--Reports!D24","v":0}]
[null,"Tiers",{"$f":"'Impression Cpte fin de gestion'!E78","v":0},0,{"$f":"'AP sortie 2'!C22-Reports!D22","v":0}]
[null,"Trésor",{"$f":"'Impression Cpte fin de gestion'!E79","v":0},0,{"$f":"'AP sortie 2'!C23-Reports!D23","v":0}]
[]
["Transferts",null,{"$f":"'Impression Cpte fin de gestion'!E81","v":0},{"$f":"E82-C82","v":0},{"$f":"'AP sortie 2'!C26","v":0}]
["TOTAL (B)",null,{"$f":"'Impression Cpte fin de gestion'!E82","v":0},0,{"$f":"'AP sortie 2'!C27-Reports!C27","v":0}]
[]
[{"$f":"\"Déficit en \"&Gestionnaires!H2&\" :\"","v":"Déficit en 1900 :"},null,{"$f":"'Impression Cpte fin de gestion'!E84","v":0},{"$f":"E85-C85","v":0},{"$f":"'AP sortie 2'!C11","v":0},{"$f":"\"*\"","v":"*"}]
[]
[]
[]
[]
[]
[]
["C. DEPENSES"]
[]
[{"$f":"\"Dépensé par \"&IF(Gestionnaires!C8=\"Monsieur\",\"le \",\"la \")&\"comptable la somme de \"&ConvNumberLetter('AP sortie 2'!D27,1,1)&\" euros se décomposant comme suit :\"","v":"Dépensé par la comptable la somme de  Euro  euros se décomposant comme suit :"}]
[]
[null,null,{"$f":"\"Rem-rep du \"&TEXT(Gestionnaires!C12,\"jj/mm/aaaa\")","v":"Rem-rep du 00/01/1900"},{"$f":"\"Rem-rep du \"&TEXT(Gestionnaires!F12,\"jj/mm/aaaa\")","v":"Rem-rep du 00/01/1900"},"Total"]
[]
["Opérations courantes",null,{"$f":"'Impression Cpte fin de gestion'!E98","v":0},{"$f":"E98-C98","v":0},{"$f":"'AP sortie 2'!D19","v":0}]
[null,"Intendance",{"$f":"'Impression Cpte fin de gestion'!E99","v":0},{"$f":"E99-C99","v":0},{"$f":"'AP sortie 2'!D16","v":0}]
[null,"Autres",{"$f":"'Impression Cpte fin de gestion'!E100","v":0},0,{"$f":"'AP sortie 2'!D17+'AP sortie 2'!D18","v":0}]
[]
["Opérations en capital",null,{"$f":"'Impression Cpte fin de gestion'!E102","v":0},0,{"$f":"'AP sortie 2'!D20","v":0}]
[]
["Opérations pour ordre",null,{"$f":"'Impression Cpte fin de gestion'!E104","v":0},0,{"$f":"'AP sortie 2'!D24","v":0}]
[null,"Tiers",{"$f":"'Impression Cpte fin de gestion'!E105","v":0},0,{"$f":"'AP sortie 2'!D22","v":0}]
[null,"Trésor",{"$f":"'Impression Cpte fin de gestion'!E106","v":0},0,{"$f":"'AP sortie 2'!D23","v":0}]
[]
["Transferts",null,{"$f":"'Impression Cpte fin de gestion'!E108","v":0},{"$f":"E108-C108","v":0},{"$f":"'AP sortie 2'!D26","v":0}]
["TOTAL (C)",null,{"$f":"'Impression Cpte fin de gestion'!E109","v":0},0,{"$f":"'AP sortie 2'!D27","v":0}]
[]
[]
["D. RESULTATS"]
[]
["Valeurs existant en caisse au 31 décembre d e l'année précédente :",null,null,{"$f":"D62","v":0},null,"(A)",{"$f":"\"+\"","v":"+"}]
[{"$f":"\"Recettes pendant l'année \"&Gestionnaires!H2&\" :\"","v":"Recettes pendant l'année 1900 :"},null,null,{"$f":"E83","v":0},null,"(B)"]
["Total des sommes à justifier :",null,null,{"$f":"SUM(D114:E115)","v":0},null,null,{"$f":"\"-\"","v":"-"}]
[{"$f":"\"Dépenses pendant l'année \"&Gestionnaires!H2&\" :\"","v":"Dépenses pendant l'année 1900 :"},null,null,{"$f":"E109","v":0},null,"(C)"]
[{"$f":"\"Excédent des recettes sur les dépenses :\"","v":"Excédent des recettes sur les dépenses :"},null,null,{"$f":"D116-D117","v":0}]
[{"$f":"\"- Déficit en \"&Gestionnaires!H2&\" :\"","v":"- Déficit en 1900 :"},null,null,{"$f":"E85","v":0},null,{"$f":"\"*\"","v":"*"}]
["Réalité de la trésorie :",null,null,{"$f":"D118-D119","v":0}]
[]
[{"$f":"IF(Gestionnaires!F8=\"Monsieur\",\"Le \",\"La \")&IF(Gestionnaires!F8=\"Monsieur\",\"soussigné, \",\"soussignée, \")&Gestionnaires!F10&\" \"&Gestionnaires!F9&\" \"&\"comptable de \"&LOOKUP(\"X\",Identification!B2:B344,Identification!D2:D344)&\",\"","v":{"$error":"#N/A"}}]
[{"$f":"\"affirme sous peine de droit, véritable dans toutes ses parties, le présent compte qui est le résumé des recettes et des dépenses effectuées par\"&IF(Gestionnaires!F33=\"Monsieur\",\"Le \",\"La \")&\" pendant la durée de sa gestion\"","v":"affirme sous peine de droit, véritable dans toutes ses parties, le présent compte qui est le résumé des recettes et des dépenses effectuées parLa  pendant la durée de sa gestion"}]
[]
[]
[{"$f":"\"Fait à  \"&LOOKUP(\"X\",Identification!B2:B344,Identification!G2:G344&\", \"&\"le \"&TEXT(Gestionnaires!F17,\"jj/mm/aaaa\"))","v":{"$error":"#N/A"}},null,null,null,{"$f":"IF(Gestionnaires!F8=\"Monsieur\",\"Le \",\"La \") &\"comptable,\"","v":"La comptable,"}]
[]
[]
[]
["E. REMARQUES EVENTUELLES (Manuscrites) :"]

{"sheet":"Caisse 3","index":15,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,8,5,13],[7,8,8,13],[13,5,13,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[17,1,17,4],[17,5,17,6],[12,5,12,6],[0,0,0,7],[2,5,2,6],[3,5,3,6],[4,5,4,6],[5,5,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6]]}
["Encodage de la caisse à la date de la remise-reprise"]
[]
[null,0,"x",1,"cents =",{"$f":"(B3*D3)/100","v":0},null,null,{"$f":"\"Renseignez ici les devises contenues en caisse à la date du \"&TEXT(Gestionnaires!L12,\"jj/mm/aaaa\")&\" jour de sortie de \"&Gestionnaires!L8&\" \"&Gestionnaires!L10&\" \"\n&UPPER(Gestionnaires!L9)","v":"Renseignez ici les devises contenues en caisse à la date du 00/01/1900 jour de sortie de   "}]
[null,0,"x",2,"cents =",{"$f":"(B4*D4)/100","v":0}]
[null,0,"x",5,"cents =",0]
[null,0,"x",10,"cents =",0]
[null,0,"x",20,"cents =",0]
[null,0,"x",50,"cents =",0,null,null,"Ne complétez que la colonne jaune"]
[null,0,"x",1,"Euro =",{"$f":"B9*D9","v":0}]
[null,0,"x",2,"Euros =",0]
[null,0,"x",5,"Euros =",0]
[null,0,"x",10,"Euros =",0]
[null,0,"x",20,"Euros =",0]
[null,0,"x",50,"Euros =",0]
[null,0,"x",100,"Euros =",0]
[null,0,"x",200,"Euros =",0]
[null,0,"x",500,"Euros =",0]
[null,"Total",null,null,null,{"$f":"SUM(F3:F17)","v":0},null,null,null,"Accueil"]

{"sheet":"AP sortie 3","index":16,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":false,"merged":[[25,0,25,1],[24,0,24,1],[32,6,32,7],[21,11,21,15],[26,6,26,8],[27,6,27,7],[26,11,26,12],[28,6,28,8],[23,6,23,8],[21,6,21,8],[23,11,23,14],[24,6,24,8],[22,6,22,8],[23,0,23,1],[26,0,26,1],[10,10,10,11],[12,0,12,1],[13,0,13,1],[10,0,10,1],[22,0,22,1],[16,11,16,15],[19,0,19,1],[19,6,19,8],[20,6,20,8],[21,0,21,1],[18,6,18,8],[16,0,16,1],[16,6,16,9],[15,0,15,1],[18,0,18,1],[13,10,13,11],[11,0,11,1],[10,6,10,7],[17,0,17,1],[17,6,17,8],[13,6,13,7],[9,10,9,11],[6,0,6,1],[6,6,6,7],[6,10,6,11],[7,0,7,1],[7,6,7,7],[7,10,7,11],[8,10,8,11],[8,0,8,1],[8,6,8,7],[9,0,9,1],[9,6,9,7],[0,0,0,15],[1,0,1,4],[2,6,2,8],[2,10,2,15],[3,0,3,1],[3,6,3,7],[3,10,3,11],[2,0,2,1],[4,0,4,1],[4,6,4,7],[4,10,4,11],[5,0,5,1],[5,6,5,7],[5,10,5,11]]}
[{"$f":"\"Etat des comptes et des avoirs à la date du \"&TEXT(Gestionnaires!L12,\"jj/mm/aaaa\")","v":"Etat des comptes et des avoirs à la date du 00/01/1900"}]
[{"$f":" \"Compte jaune du \"&TEXT(Gestionnaires!L12,\"jj/mm/aaaa\")","v":"Compte jaune du 00/01/1900"}]
[null,null,"Recettes","Dépenses","Solde remis",null,"Créances à recouvrer",null,null,null,"Créances à liquider"]
["Caisse",null,0,0,{"$f":"C4-D4","v":0},null,"Opérations courantes",null,{"$f":"SUM(I5:I6)","v":0},null,"Opérations courantes",null,"A honorer","Fact. Impayées","Fact. Ordonnancées","Total"]
["Dotation",null,0,0,{"$f":"C5-D5","v":0},null,"Intendance",null,0,null,"Intendance",null,0,0,0,{"$f":"SUM(M5:O5)","v":0}]
["Placement 1",null,0,0,0,null,"Autres",null,0,null,"Autres",null,0,0,0,{"$f":"SUM(M6:O6)","v":0}]
["Placement 2",null,0,0,0,null,"Opérations en capital",null,0,null,"Opérations en capital",null,0,0,0,0]
["Placement 3",null,0,0,0,null,"Opérations pour ordre",null,{"$f":"SUM(I9:I10)","v":0},null,"Opérations pour ordre"]
["Placement 4",null,0,0,0,null,"Tiers",null,0,null,"Tiers",null,0,0,0,0]
["Placement 5",null,0,0,0,null,"Trésor",null,0,null,"Trésor",null,0,0,0,0]
["PV déficit",null,0,0,0,null,"Total",null,{"$f":"SUM(I5,I6,I7,I9,I10,)","v":0},null,"Total",null,{"$f":"SUM(M5:M10)","v":0},{"$f":"SUM(N5:N10)","v":0},{"$f":"SUM(O5:O10)","v":0},{"$f":"SUM(P5:P10)","v":0}]
["Sous-totaux",null,{"$f":"SUM(C4:C11)","v":0},{"$f":"SUM(D4:D11)","v":0},0]
["Mouvements de fonds",null,0,0,0,null,null,null,null,null,null,null,"Total","hors pensions"]
["Totaux",null,{"$f":"C12-C13","v":0},{"$f":"D12-D13","v":0},0,null,"Pensions anticipatives",null,0,null,"Comptes créditeurs",null,0,{"$f":"M14-I14","v":0}]
["Opérations courantes"]
["Intendance",null,0,0,{"$f":"C16-D16","v":0}]
["Fonctionnement",null,0,0,0,null,"Magasin",null,null,null,null,"Energie"]
["Fond de réserve",null,0,0,0,null,"Stock alimentation",null,null,0,null,"Type","Qté","Unité","Prix unitaire","Montant"]
["Total OC",null,{"$f":"SUM(C16:C18)","v":0},{"$f":"SUM(D16:D18)","v":0},0,null,"Stock des produits d'entretien",null,null,0,null,"Mazout",null,"litres à ",null,{"$f":"M19*O19","v":0}]
["Opérations en capital",null,0,0,0,null,"Stock de pharmacie",null,null,0,null,"Gaz",null,"litres à ",null,{"$f":"M20*O20","v":0}]
["Opérations pour ordre",null,null,null,null,null,"Stock matériel de bureau",null,null,0,null,"Charbon",null,"Kg",null,{"$f":"M21*O21","v":0}]
["Tiers",null,0,0,0,null,"Stock matières premières",null,null,0,null,"Autres  à préciser"]
["Trésor",null,0,0,0,null,"Stokc fournitures scolaires",null,null,0,null,null,null,null,null,0]
["Total PO",null,{"$f":"SUM(C22:C23)","v":0},{"$f":"SUM(D22:D23)","v":0},0,null,"Stock Autres",null,null,0,null,"Total",null,null,null,{"$f":"SUM(P19:P21,P23)","v":0}]
["Sous-totaux",null,{"$f":"C19+C20+C24","v":0},{"$f":"D19+D20+D24","v":0},{"$f":"C25-D25","v":0},null,"Total",null,null,{"$f":"SUM(J18:J24)","v":0}]
["Transferts",null,0,0,{"$f":"C26-D26","v":0}]
["Totaux",null,{"$f":"C25-C26","v":0},{"$f":"D25-D26","v":0},0,null,"Autres valeurs",null,null,null,null,"Tickets en circulation"]
[null,null,null,null,null,null,"Timbres",null,0,null,null,"Tickets",0]
[null,null,null,null,null,null,"Autres à préciser"]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Total",null,{"$f":"SUM(I28,I30:I32)","v":0}]

{"sheet":"Impression PV caisse (3)","index":17,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[[40,0,40,5],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[29,3,29,4],[33,0,33,5],[36,0,36,5],[38,0,38,5],[31,0,31,5],[22,0,22,1],[0,0,0,1],[5,3,5,4],[6,3,6,4],[9,0,9,5],[12,0,12,5]]}
["Procès-verbal de caisse",null,"du service",{"$f":"LOOKUP(\"X\",Identification!B2:B344,Identification!D2:D344)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"LOOKUP(\"X\",Identification!B2:B344,Identification!E2:E344)","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"LOOKUP(\"X\",Identification!B2:B344,Identification!F2:F344&\" \"&Identification!G2:G344)","v":{"$error":"#N/A"}}]
[]
[]
[null,null,{"$f":"Gestionnaires!C2","v":0},{"$f":"IF(C6=\"Monsieur\",\"Ordonnateur\",\"Ordonnatrice\")","v":"Ordonnatrice"},null,{"$f":"Gestionnaires!L8","v":0}]
[{"$f":" \"Le\"&\" \"&TEXT(Gestionnaires!L12,\"jj/mm/AAAA\")","v":"Le 00/01/1900"},{"$f":"\" Nous,\"","v":" Nous,"},{"$f":"Gestionnaires!C5","v":0},"Avons requis",null,{"$f":"Gestionnaires!L10","v":0}]
[null,null,{"$f":"UPPER(Gestionnaires!C4)","v":""},null,null,{"$f":"UPPER(Gestionnaires!L9)","v":""}]
[]
["Comptable de l'établissement repris ci-dessus, de nous présenter les valeurs et autres espèces existant dans sa caisse et avons dressés le bordereau ci-après, à savoir:"]
[]
[]
["NUMERAIRES ET VALEURS"]
[]
[null,null,null,{"$f":"'Caisse 3'!B3","v":0},"Pièces de 1 cent =",{"$f":"'Caisse 3'!F3","v":0}]
[null,null,null,{"$f":"'Caisse 3'!B4","v":0},"Pièces de 2 cents =",{"$f":"'Caisse 3'!F4","v":0}]
[null,null,null,{"$f":"'Caisse 3'!B5","v":0},"Pièces de 5 cents =",{"$f":"'Caisse 3'!F5","v":0}]
[null,null,null,{"$f":"'Caisse 3'!B6","v":0},"Pièces de 10 cents =",{"$f":"'Caisse 3'!F6","v":0}]
[null,null,null,{"$f":"'Caisse 3'!B7","v":0},"Pièces de 20 cents =",{"$f":"'Caisse 3'!F7","v":0}]
[null,null,null,{"$f":"'Caisse 3'!B8","v":0},"Pièces de 50 cents =",{"$f":"'Caisse 3'!F8","v":0}]
[null,null,null,{"$f":"'Caisse 3'!B9","v":0},"Pièces de 1 Euro =",{"$f":"'Caisse 3'!F9","v":0}]
[null,null,null,{"$f":"'Caisse 3'!B10","v":0},"Pièces de 2 Euros =",{"$f":"'Caisse 3'!F10","v":0}]
["Caisse = ",null,{"$f":"'AP sortie 3'!E4","v":0},{"$f":"'Caisse 3'!B11","v":0},"bilets  de 5 Euros =",{"$f":"'Caisse 3'!F11","v":0}]
["Dotation = ",null,{"$f":"'AP sortie 3'!E5","v":0},{"$f":"'Caisse 3'!B12","v":0},"bilets  de 10 Euros =",{"$f":"'Caisse 3'!F12","v":0}]
["Placement 1 = ",null,{"$f":"'AP sortie 3'!E6","v":0},{"$f":"'Caisse 3'!B13","v":0},"bilets  de 20 Euros =",{"$f":"'Caisse 3'!F13","v":0}]
["Placement 2 = ",null,{"$f":"'AP sortie 3'!E7","v":0},{"$f":"'Caisse 3'!B14","v":0},"bilets  de 50 Euros =",{"$f":"'Caisse 3'!F14","v":0}]
["Placement 3 = ",null,{"$f":"'AP sortie 3'!E8","v":0},{"$f":"'Caisse 3'!B15","v":0},"bilets  de 100 Euros =",{"$f":"'Caisse 3'!F15","v":0}]
["Placement 4 = ",null,{"$f":"'AP sortie 3'!E9","v":0},{"$f":"'Caisse 3'!B16","v":0},"bilets  de 200 Euros =",{"$f":"'Caisse 3'!F16","v":0}]
["Placement 5 = ",null,{"$f":"'AP sortie 3'!E10","v":0},{"$f":"'Caisse 3'!B17","v":0},"bilets  de 500 Euros =",{"$f":"'Caisse 3'!F17","v":0}]
["TOTAL = ",null,{"$f":"SUM(C23:C29)","v":0},"TOTAL = ",null,{"$f":"'Caisse 3'!F18","v":0}]
[]
[{"$f":"IF('AP sortie 3'!E11<>0, (\"Attention : Déficit présent pour un montant de \"&'AP sortie 3'!E11&\" \"&\"Euro\"),\"\")","v":""}]
[]
["Nous étant fait présenter immédiatement le Journal-Centralisateur du Comptable, nous avons arrêté:"]
[]
["La recette à la somme de :"]
[{"$f":"ConvNumberLetter(('AP sortie 3'!C14-'AP sortie 3'!C11),1,1)","v":" Euro "}]
["La dépense à la somme de :"]
[{"$f":"ConvNumberLetter('AP sortie 3'!D14,1,1)","v":" Euro "}]
["L'excédent de la recette sur la dépense à celle de:"]
[{"$f":"ConvNumberLetter(('AP sortie 3'!E14-'AP sortie 3'!E11),1,1)","v":" Euro "}]
[]
[{"$f":"\"Après quoi, nous avons clos et arrêté le présent procès-verbal que \"&IF(Gestionnaires!L8=\"Monsieur\",\"le\",\"la\")&\" \"&\"Comptable a signé avec nous.\"","v":"Après quoi, nous avons clos et arrêté le présent procès-verbal que la Comptable a signé avec nous."}]
[]
[{"$f":"\"Fait à\"&\" \"&LOOKUP(\"X\",Identification!B2:B344,Identification!G2:G344)&\", le \"& TEXT(Gestionnaires!L17,\"jj/mm/AAAA\")","v":{"$error":"#N/A"}}]
[]
[null,{"$f":"IF(Gestionnaires!L8=\"Monsieur\",\"Le\",\"La\")&\" \"&\"comptable, \"","v":"La comptable, "},null,null,{"$f":"IF(Gestionnaires!C2=\"Monsieur\",\"L'ordonnateur,\",\"L'ordonnatrice,\")","v":"L'ordonnatrice,"}]

{"sheet":"PV de remise-reprise (3)","index":18,"n_rows":128,"n_cols":6,"rows_kept":128,"cut":false,"hidden":false,"merged":[[89,2,89,3],[62,1,62,3],[63,1,63,3],[64,1,64,3],[65,1,65,3],[69,1,69,3],[84,2,84,3],[86,2,86,3],[87,2,87,3],[88,2,88,3],[66,1,66,3],[68,1,68,3],[58,0,58,1],[57,0,57,1],[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[40,2,40,3],[51,0,51,1],[52,0,52,1],[53,0,53,1],[54,0,54,1],[55,0,55,1],[56,0,56,1],[55,2,55,5],[35,2,35,3],[20,0,20,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[28,0,28,1],[32,2,32,4],[33,2,33,3],[34,2,34,3],[22,0,22,1],[27,0,27,1],[19,0,19,1],[0,0,0,5],[2,0,2,5],[7,0,7,4],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[18,0,18,1],[17,0,17,1]]}
["Procès verbal de remise-reprise des comptes"]
[]
[{"$f":"\"Les \"&IF(OR(Gestionnaires!L8=\"Monsieur\", Gestionnaires!L19=\"Monsieur\"),\"soussignés, \",\"soussignées, \")&Gestionnaires!L10&\" \"&UPPER(Gestionnaires!L9)&\", comptable \"&IF(Gestionnaires!L8=\"Monsieur\",\"sortant \",\"sortante \")&\"de l'établissement \"&LOOKUP(\"X\",Identification!B2:B344,Identification!D2:D344)&\" et \"&Gestionnaires!L21&\" \"&UPPER(Gestionnaires!L20)&\", successeur, ont procédé à la remise et à la reprise des comptes de l'établissement précité qui, en date du \"&TEXT(Gestionnaires!L12,\"jj/mm/aaaa\")&\", ont été établis comme suit :\"","v":{"$error":"#N/A"}}]
[]
[]
["I.  LIVRE CENTRALISATEUR"]
[]
["Livres centralisateurs"]
[null,null,"Recettes","Dépenses","Solde remis"]
["Caisse",null,{"$f":"'AP sortie 3'!C4","v":0},{"$f":"'AP sortie 3'!D4","v":0},{"$f":"'AP sortie 3'!E4","v":0}]
["Dotation",null,{"$f":"'AP sortie 3'!C5","v":0},{"$f":"'AP sortie 3'!D5","v":0},{"$f":"'AP sortie 3'!E5","v":0}]
["Placement 1",null,{"$f":"'AP sortie 3'!C6","v":0},{"$f":"'AP sortie 3'!D6","v":0},{"$f":"'AP sortie 3'!E6","v":0}]
["Placement 2",null,{"$f":"'AP sortie 3'!C7","v":0},{"$f":"'AP sortie 3'!D7","v":0},{"$f":"'AP sortie 3'!E7","v":0}]
["Placement 3",null,{"$f":"'AP sortie 3'!C8","v":0},{"$f":"'AP sortie 3'!D8","v":0},{"$f":"'AP sortie 3'!E8","v":0}]
["Placement 4",null,{"$f":"'AP sortie 3'!C9","v":0},{"$f":"'AP sortie 3'!D9","v":0},{"$f":"'AP sortie 3'!E9","v":0}]
["Placement 5",null,{"$f":"'AP sortie 3'!C10","v":0},{"$f":"'AP sortie 3'!D10","v":0},{"$f":"'AP sortie 3'!E10","v":0}]
["Deficit (-)",null,{"$f":"'AP sortie 3'!C11","v":0},{"$f":"'AP sortie 3'!D11","v":0},{"$f":"'AP sortie 3'!E11","v":0}]
["Sous-totaux",null,{"$f":"'AP sortie 3'!C12-'AP sortie 3'!C11","v":0},{"$f":"'AP sortie 3'!D12-'AP sortie 3'!D11","v":0},{"$f":"'AP sortie 3'!E12-'AP sortie 3'!E11","v":0}]
["Mouvements de fonds",null,{"$f":"'AP sortie 3'!C13","v":0},{"$f":"'AP sortie 3'!D13","v":0},{"$f":"'AP sortie 3'!E13","v":0}]
["Totaux",null,{"$f":"C18-C19","v":0},{"$f":"D18-D19","v":0},0]
[]
["Opérations courantes",null,{"$f":"SUM(C23:C24)","v":0},{"$f":"SUM(D23:D24)","v":0},{"$f":"C22-D22","v":0}]
["Intendance",null,{"$f":"'AP sortie 3'!C16","v":0},{"$f":"'AP sortie 3'!D16","v":0},{"$f":"'AP sortie 3'!E16","v":0}]
["Autres",null,{"$f":"'AP sortie 3'!C17","v":0},{"$f":"'AP sortie 3'!D17","v":0},{"$f":"'AP sortie 3'!E17","v":0}]
["Fond de réserve",null,{"$f":"'AP sortie 3'!C18","v":0},{"$f":"'AP sortie 3'!D18","v":0},{"$f":"'AP sortie 3'!E18","v":0}]
["Opérations en capital",null,{"$f":"'AP sortie 3'!C20","v":0},{"$f":"'AP sortie 3'!D20","v":0},{"$f":"'AP sortie 3'!E20","v":0}]
["Opérations pour ordre",null,{"$f":"'AP sortie 3'!C24","v":0},{"$f":"'AP sortie 3'!D24","v":0},{"$f":"'AP sortie 3'!E24","v":0}]
["Transferts",null,{"$f":"'AP sortie 3'!C26","v":0},{"$f":"'AP sortie 3'!D26","v":0},{"$f":"'AP sortie 3'!E26","v":0}]
["Totaux",null,{"$f":"'AP sortie 3'!C27","v":0},{"$f":"'AP sortie 3'!D27","v":0},{"$f":"'AP sortie 3'!E27","v":0}]
[]
["II. CREANCES A RECOUVRER"]
[]
[null,null,"Créances à recouvrer"]
[null,null,"Opérations courantes",null,{"$f":"'AP sortie 3'!I4","v":0}]
[null,null,"Intendance",null,{"$f":"'AP sortie 3'!I5","v":0}]
[null,null,"Autres",null,{"$f":"'AP sortie 3'!I6","v":0}]
[null,null,"Opérations en capital",null,{"$f":"'AP sortie 3'!I7","v":0}]
[null,null,"Opérations pour ordre",null,{"$f":"'AP sortie 3'!I8","v":0}]
[null,null,"Tiers",null,{"$f":"'AP sortie 3'!I9","v":0}]
[null,null,"Trésor",null,{"$f":"'AP sortie 3'!I10","v":0}]
[null,null,"Total",null,{"$f":"'AP sortie 3'!I11","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
["III. CREANCES A LIQUIDER"]
[]
["Opérations courantes",null,"A honorer","Fact. Impayées","Fact. Ordonnancées","Total"]
["Intendance",null,{"$f":"'AP sortie 3'!M5","v":0},{"$f":"'AP sortie 3'!N5","v":0},{"$f":"'AP sortie 3'!O5","v":0},{"$f":"'AP sortie 3'!P5","v":0}]
["Autres",null,{"$f":"'AP sortie 3'!M6","v":0},{"$f":"'AP sortie 3'!N6","v":0},{"$f":"'AP sortie 3'!O6","v":0},{"$f":"'AP sortie 3'!P6","v":0}]
["Opérations en capital",null,{"$f":"'AP sortie 3'!M7","v":0},{"$f":"'AP sortie 3'!N7","v":0},{"$f":"'AP sortie 3'!O7","v":0},{"$f":"'AP sortie 3'!P7","v":0}]
["Opérations pour ordre"]
["Tiers",null,{"$f":"'AP sortie 3'!M9","v":0},{"$f":"'AP sortie 3'!N9","v":0},{"$f":"'AP sortie 3'!O9","v":0},{"$f":"'AP sortie 3'!P9","v":0}]
["Trésor",null,{"$f":"'AP sortie 3'!M10","v":0},{"$f":"'AP sortie 3'!N10","v":0},{"$f":"'AP sortie 3'!O10","v":0},{"$f":"'AP sortie 3'!P10","v":0}]
["Total",null,{"$f":"'AP sortie 3'!M11","v":0},{"$f":"'AP sortie 3'!N11","v":0},{"$f":"'AP sortie 3'!O11","v":0},{"$f":"'AP sortie 3'!P11","v":0}]
[]
["IV. MAGASIN"]
[]
[null,"Stock alimentation",null,null,{"$f":"'AP sortie 3'!J18","v":0}]
[null,"Stock des produits d'entretien",null,null,{"$f":"'AP sortie 3'!J19","v":0}]
[null,"Stock de pharmacie",null,null,{"$f":"'AP sortie 3'!J20","v":0}]
[null,"Stock matériel de bureau",null,null,{"$f":"'AP sortie 3'!J21","v":0}]
[null,"Stock matières premières",null,null,{"$f":"'AP sortie 3'!J22","v":0}]
[null,"Stock fournitures scolaires",null,null,{"$f":"'AP sortie 3'!J23","v":0}]
[null,"Autres stock",null,null,{"$f":"'AP sortie 3'!J24","v":0}]
[null,"Total",null,null,{"$f":"'AP sortie 3'!J25","v":0}]
["V.  ENERGIE"]
[]
[]
[null,"Type","Qté","Unité","Prix unitaire","Montant"]
[null,"Mazout",{"$f":"'AP sortie 3'!M19","v":0},"litres à ",{"$f":"'AP sortie 3'!O19","v":0},{"$f":"'AP sortie 3'!P19","v":0}]
[null,"Gaz",{"$f":"'AP sortie 3'!M20","v":0},null,{"$f":"'AP sortie 3'!O20","v":0},{"$f":"'AP sortie 3'!P20","v":0}]
[null,"Charbon",{"$f":"'AP sortie 3'!M21","v":0},"Kg",{"$f":"'AP sortie 3'!O21","v":0},{"$f":"'AP sortie 3'!P21","v":0}]
[null,"Autres  à préciser"]
[null,{"$f":"'AP sortie 3'!L23","v":0},null,null,null,{"$f":"'AP sortie 3'!P23","v":0}]
[null,"Total",null,null,null,{"$f":"'AP sortie 3'!P24","v":0}]
[]
["VI.  AUTRES VALEURS"]
[]
[]
[null,null,"Timbres",null,{"$f":"'AP sortie 3'!I28","v":0}]
[null,null,"Autres à préciser"]
[null,null,{"$f":"'AP sortie 3'!G30","v":0},null,{"$f":"'AP sortie 3'!I30","v":0}]
[null,null,{"$f":"'AP sortie 3'!G31","v":0},null,{"$f":"'AP sortie 3'!I31","v":0}]
[null,null,{"$f":"'AP sortie 3'!G32","v":0},null,{"$f":"'AP sortie 3'!I32","v":0}]
[null,null,"Total",null,{"$f":"'AP sortie 3'!I33","v":0}]
["VII.  TICKET"]
[]
[]
[null,null,"Ticket en circulation ",null,{"$f":"'AP sortie 3'!M28","v":0}]
[]
[]
[]
[]
[]
[{"$f":"\"VIII. BILAN DU \"&TEXT(Gestionnaires!C12,\"jj/mm/aaaa\")","v":"VIII. BILAN DU 00/01/1900"}]
[]
[]
[null,"ACTIF"]
[null,null,"Comptes financiers (I)",null,{"$f":"E20","v":0}]
[null,null,"Créances à recouvrer (II)",null,{"$f":"E41","v":0}]
[null,null,"Magasins et autres (IV+V+VI)",null,{"$f":"E70+F80+E90","v":0}]
[null,null,"Solde négatif",null,{"$f":"IF((E104+E105+E106)-(E113+E114+E115+E116)>0,0,ABS((E104+E105+E106)-(E113+E114+E115+E116)))","v":0}]
[null,null,"TOTAL",null,{"$f":"SUM(E104:E107)","v":0}]
[]
[]
[]
[null,"PASSIF"]
[null,null,"Pensions anticipatives",null,{"$f":"'AP sortie 3'!I14","v":0}]
[null,null,"Comptes créditeurs",null,{"$f":"'AP sortie 3'!N14","v":0}]
[null,null,"Tickets en circulation (VII)",null,{"$f":"'AP sortie 3'!M28","v":0}]
[null,null,"Créances à liquider (III)",null,{"$f":"'AP sortie 3'!P11","v":0}]
[null,null,"Solde bénéficiaire",null,{"$f":"IF((E104+E105+E106)-(E113+E114+E115+E116)<0,0,ABS((E104+E105+E106)-(E113+E114+E115+E116)))","v":0}]
[null,null,"TOTAL",null,{"$f":"SUM(E113:E117)","v":0}]
[]
[]
[{"$f":"\"Fait à \"&LOOKUP(\"X\",Identification!B2:B344,Identification!G2:G344)&\", le \"&TEXT(Gestionnaires!L17,\"jj/mm/aaaa\")","v":{"$error":"#N/A"}}]
[]
[]
[]
[null,{"$f":"IF(Gestionnaires!L8=\"Monsieur\",\"Le \",\"La \")&\"comptable \"&IF(Gestionnaires!L8=\"Monsieur\",\"sortant,\",\"sortante,\")","v":"La comptable sortante,"},null,null,{"$f":"IF(Gestionnaires!L19=\"Monsieur\",\"Le \",\"La \")&\"comptable \"&IF(Gestionnaires!L19=\"Monsieur\",\"entrant,\",\"entrante,\")","v":"La comptable entrante,"}]
[]
[]
[null,{"$f":" Gestionnaires!L10&\" \"&UPPER(Gestionnaires!L9)","v":" "},null,null,{"$f":" Gestionnaires!L21&\" \"&UPPER(Gestionnaires!L20)","v":" "}]

{"sheet":"Impression Cpte fin de gest (3)","index":19,"n_rows":130,"n_cols":7,"rows_kept":130,"cut":false,"hidden":false,"merged":[[81,0,81,1],[69,2,70,2],[69,3,70,3],[69,4,70,4],[69,5,70,5],[122,0,122,6],[114,0,114,2],[114,3,114,4],[115,0,115,2],[115,3,115,4],[116,0,116,2],[116,3,116,4],[117,0,117,2],[117,3,117,4],[118,0,118,2],[118,3,118,4],[119,0,119,2],[119,3,119,4],[82,0,82,1],[97,0,97,1],[108,0,108,1],[113,0,113,2],[113,3,113,4],[107,0,107,1],[93,0,93,6],[95,3,96,3],[95,4,96,4],[95,2,96,2],[95,5,96,5],[84,0,84,1],[67,0,67,6],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[17,0,17,6],[26,0,26,6],[50,0,50,6],[52,0,52,6]]}
["Etablissement :",null,{"$f":"LOOKUP(\"X\",Identification!B2:B344,Identification!D2:D344)","v":{"$error":"#N/A"}}]
[]
["Adresse :",null,{"$f":"LOOKUP(\"X\",Identification!B2:B344,Identification!E2:E344)","v":{"$error":"#N/A"}}]
[null,null,{"$f":"LOOKUP(\"X\",Identification!B2:B344,Identification!F2:F344&\" \"&Identification!G2:G344)","v":{"$error":"#N/A"}}]
[]
[]
["Comptes fnanciers",null,"Caisse:",{"$f":"\"---------\"","v":"---------"}]
[null,null,"Dotation 091 :",{"$f":"Gestionnaires!C26","v":0}]
[null,null,"Placement 1 :",{"$f":"Gestionnaires!C27","v":0}]
[null,null,"Placement 2 :",{"$f":"Gestionnaires!C28","v":0}]
[null,null,"Placement 3 :",{"$f":"Gestionnaires!C29","v":0}]
[null,null,"Placement 4 :",{"$f":"Gestionnaires!C30","v":0}]
[null,null,"Placement 5 :",{"$f":"Gestionnaires!C31","v":0}]
[]
[{"$f":" \"Comptable : \"","v":"Comptable : "},{"$f":"Gestionnaires!L10&\" \"&UPPER(Gestionnaires!L9)","v":" "}]
[]
[]
["COMPTE DE FIN DE GESTION"]
[]
[{"$f":"\"Remis par \"&IF(Gestionnaires!L8=\"Monsieur\",\"Monsieur \",\"Madame \")&Gestionnaires!L10&\" \"&Gestionnaires!L9&\" \"&IF(Gestionnaires!L8=\"Monsieur\",\"né le \",\"née le \")&TEXT(Gestionnaires!L16,\"jj/mm/aaaa\")","v":"Remis par Madame   née le 00/01/1900"}]
[]
[{"$f":"IF(Gestionnaires!L8=\"Monsieur\",\"Domicilié : \",\"Domiciliée : \")","v":"Domiciliée : "},{"$f":"Gestionnaires!L13","v":0}]
[null,{"$f":"Gestionnaires!L14&\" \"&UPPER(Gestionnaires!L15)","v":" "}]
[]
["Comptable de ",{"$f":"LOOKUP(\"X\",Identification!B2:B344,Identification!D2:D344)","v":{"$error":"#N/A"}}]
[]
[{"$f":"\"Conformément à l'article 7 de la loi du 29 octobre 1846,  pour les recettes et les dépenses faites par \"&IF(Gestionnaires!L8=\"Monsieur\",\"lui \",\"elle \")&\"pendant l'année \"&RIGHT(TEXT(Gestionnaires!L12,\"jj/mm/aaaa\"),4)&\" jusqu'au \"&TEXT(Gestionnaires!L12,\"jj/mm/aaaa\")&\" inclus.\"","v":"Conformément à l'article 7 de la loi du 29 octobre 1846,  pour les recettes et les dépenses faites par elle pendant l'année 1900 jusqu'au 00/01/1900 inclus."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["A.  Resultat du compte rendu au 31 décembre de l'année précédente"]
[]
[{"$f":"IF(Gestionnaires!L8=\"Monsieur\",\"Le \",\"La \")&\"comptable reporte ici, comme formant le premier article du présent compte, l'excédent des recettes sur les dépenses à la date du 31 décembre \"&Gestionnaires!I8&\" et dont \"&IF(Gestionnaires!L8=\"Monsieur\",\"il \",\"elle \"&\"a été \"&IF(Gestionnaires!C8=\"Monsieur\",\"constaté \",\"constatée \")&\"reliquataire par le compte établi à la même époque et qui a été précédemment adressé à la Cour des Comptes.\")","v":"La comptable reporte ici, comme formant le premier article du présent compte, l'excédent des recettes sur les dépenses à la date du 31 décembre 1899 et dont elle a été constatée reliquataire par le compte établi à la même époque et qui a été précédemment adressé à la Cour des Comptes."}]
[]
[{"$f":" \"Lequel excédent s'élevant à \"&ConvNumberLetter((Reports!D12-Reports!D11),1,1)&\" euros est représenté par le svaleurs que \"&IF(Gestionnaires!C8=\"Monsieur\",\"le \",\"la \")&\"comptable avait en caisse le 31/12/\"&Gestionnaires!I8&\", à savoir :\"","v":"Lequel excédent s'élevant à  Euro  euros est représenté par le svaleurs que la comptable avait en caisse le 31/12/1899, à savoir :"}]
[]
[null,null,"Caisse",{"$f":"Reports!D4","v":0}]
[null,null,"Dotation",{"$f":"Reports!D5","v":0}]
[null,null,"Placement 1",{"$f":"Reports!D6","v":0}]
[null,null,"Placement 2",{"$f":"Reports!D7","v":0}]
[null,null,"Placement 3",{"$f":"Reports!D8","v":0}]
[null,null,"Placement 4",{"$f":"Reports!D9","v":0}]
[null,null,"Placement 5",{"$f":"Reports!D10","v":0}]
[null,null,"Total (A)",{"$f":"Reports!D12-Reports!D11","v":0}]
[]
[]
[]
["B. RECETTES"]
[]
[{"$f":"\"Reçu par \"&IF(Gestionnaires!C8=\"Monsieur\",\"le \",\"la \")&\"comptable la somme de \"&ConvNumberLetter('AP sortie 3'!C27-Reports!C27,1,1)&\"euros représentant les recouvrements effectués pendant l'année \"&Gestionnaires!H2&\" sur les Services à gestion séparées de l'Enseignement :\"","v":"Reçu par la comptable la somme de  Euro euros représentant les recouvrements effectués pendant l'année 1900 sur les Services à gestion séparées de l'Enseignement :"}]
[]
[null,null,{"$f":"\"Rem-rep du \"&TEXT(Gestionnaires!C12,\"jj/mm/aaaa\")","v":"Rem-rep du 00/01/1900"},{"$f":"\"Rem-rep du \"&TEXT(Gestionnaires!F12,\"jj/mm/aaaa\")","v":"Rem-rep du 00/01/1900"},{"$f":"\"Rem-rep du \"&TEXT(Gestionnaires!L12,\"jj/mm/aaaa\")","v":"Rem-rep du 00/01/1900"},"Total"]
[]
["Opérations courantes",null,{"$f":"'Impression Cpte fin de gestion'!E71","v":0},{"$f":"'Impression Cpte fin de gest (2)'!D72","v":0},{"$f":"F72-(C72+D72)","v":0},{"$f":"'AP sortie 3'!C19-Reports!D19","v":0}]
[null,"Intendance",{"$f":"'Impression Cpte fin de gestion'!E72","v":0},{"$f":"'Impression Cpte fin de gest (2)'!D73","v":0},{"$f":"F73-(C73+D73)","v":0},{"$f":"'AP sortie 3'!C16-Reports!D16","v":0}]
[null,"Autres",{"$f":"'Impression Cpte fin de gestion'!E73","v":0},{"$f":"'Impression Cpte fin de gest (2)'!D74","v":0},{"$f":"F74-(C74+D74)","v":0},{"$f":"'AP sortie 3'!C17-Reports!D17","v":0}]
[]
["Opérations en capital",null,{"$f":"'Impression Cpte fin de gestion'!E75","v":0},{"$f":"'Impression Cpte fin de gest (2)'!D76","v":0},0,{"$f":"'AP sortie 3'!C20-Reports!D20","v":0}]
[]
["Opérations pour ordre",null,{"$f":"'Impression Cpte fin de gestion'!E77","v":0},{"$f":"'Impression Cpte fin de gest (2)'!D78","v":0},0,{"$f":"'AP sortie 3'!C24-Reports!D24","v":0}]
[null,"Tiers",{"$f":"'Impression Cpte fin de gestion'!E78","v":0},{"$f":"'Impression Cpte fin de gest (2)'!D79","v":0},0,{"$f":"'AP sortie 3'!C22-Reports!D22","v":0}]
[null,"Trésor",{"$f":"'Impression Cpte fin de gestion'!E79","v":0},{"$f":"'Impression Cpte fin de gest (2)'!D80","v":0},0,{"$f":"'AP sortie 3'!C23-Reports!D23","v":0}]
[]
["Transferts",null,{"$f":"'Impression Cpte fin de gestion'!E81","v":0},{"$f":"'Impression Cpte fin de gest (2)'!D82","v":0},0,{"$f":"'AP sortie 3'!D26","v":0}]
["TOTAL (B)",null,{"$f":"'Impression Cpte fin de gestion'!E82","v":0},{"$f":"'Impression Cpte fin de gest (2)'!D83","v":0},0,{"$f":"'AP sortie 3'!C27-Reports!D27","v":0}]
[]
[{"$f":"\"Déficit en \"&Gestionnaires!H2&\" :\"","v":"Déficit en 1900 :"},null,{"$f":"'Impression Cpte fin de gestion'!E84","v":0},{"$f":"'Impression Cpte fin de gest (2)'!D85","v":0},{"$f":"F85-(C85+D85)","v":0},{"$f":"'AP sortie 3'!C11","v":0},{"$f":"\"*\"","v":"*"}]
[]
[]
[]
[]
[]
[]
["C. DEPENSES"]
[]
[{"$f":"\"Dépensé par \"&IF(Gestionnaires!C33=\"Monsieur\",\"le \",\"la \")&\"comptable la somme de \"&ConvNumberLetter('AP sortie 3'!D27,1,1)&\" euros se décomposant comme suit :\"","v":"Dépensé par la comptable la somme de  Euro  euros se décomposant comme suit :"}]
[]
[null,null,{"$f":"\"Rem-rep du \"&TEXT(Gestionnaires!C12,\"jj/mm/aaaa\")","v":"Rem-rep du 00/01/1900"},{"$f":"\"Rem-rep du \"&TEXT(Gestionnaires!F12,\"jj/mm/aaaa\")","v":"Rem-rep du 00/01/1900"},{"$f":"\"Rem-rep du \"&TEXT(Gestionnaires!L12,\"jj/mm/aaaa\")","v":"Rem-rep du 00/01/1900"},"Total"]
[]
["Opérations courantes",null,{"$f":"'Impression Cpte fin de gestion'!E98","v":0},{"$f":"'Impression Cpte fin de gest (2)'!D98","v":0},{"$f":"F98-(C98+D98)","v":0},{"$f":"'AP sortie 3'!D19","v":0}]
[null,"Intendance",{"$f":"'Impression Cpte fin de gestion'!E99","v":0},{"$f":"'Impression Cpte fin de gest (2)'!D99","v":0},{"$f":"F99-(C99+D99)","v":0},{"$f":"'AP sortie 3'!D16","v":0}]
[null,"Autres",{"$f":"'Impression Cpte fin de gestion'!E100","v":0},{"$f":"'Impression Cpte fin de gest (2)'!D100","v":0},0,{"$f":"'AP sortie 3'!D17","v":0}]
[]
["Opérations en capital",null,{"$f":"'Impression Cpte fin de gestion'!E102","v":0},{"$f":"'Impression Cpte fin de gest (2)'!D102","v":0},0,{"$f":"'AP sortie 3'!D20","v":0}]
[]
["Opérations pour ordre",null,{"$f":"'Impression Cpte fin de gestion'!E104","v":0},{"$f":"'Impression Cpte fin de gest (2)'!D104","v":0},0,{"$f":"'AP sortie 3'!D24","v":0}]
[null,"Tiers",{"$f":"'Impression Cpte fin de gestion'!E105","v":0},{"$f":"'Impression Cpte fin de gest (2)'!D105","v":0},0,{"$f":"'AP sortie 3'!D22","v":0}]
[null,"Trésor",{"$f":"'Impression Cpte fin de gestion'!E106","v":0},{"$f":"'Impression Cpte fin de gest (2)'!D106","v":0},0,{"$f":"'AP sortie 3'!D23","v":0}]
[]
["Transferts",null,{"$f":"'Impression Cpte fin de gestion'!E108","v":0},{"$f":"'Impression Cpte fin de gest (2)'!D108","v":0},0,{"$f":"'AP sortie 3'!D26","v":0}]
["TOTAL (C)",null,{"$f":"'Impression Cpte fin de gestion'!E109","v":0},{"$f":"'Impression Cpte fin de gest (2)'!D109","v":0},0,{"$f":"'AP sortie 3'!D27","v":0}]
[]
[]
["D. RESULTATS"]
[]
["Valeurs existant en caisse au 31 décembre d e l'année précédente :",null,null,{"$f":"D62","v":0},null,"(A)",{"$f":"\"+\"","v":"+"}]
[{"$f":"\"Recettes pendant l'année \"&Gestionnaires!H2&\" :\"","v":"Recettes pendant l'année 1900 :"},null,null,{"$f":"F83","v":0},null,"(B)"]
["Total des sommes à justifier :",null,null,{"$f":"SUM(D114:E115)","v":0},null,null,{"$f":"\"-\"","v":"-"}]
[{"$f":"\"Dépenses pendant l'année \"&Gestionnaires!H2&\" :\"","v":"Dépenses pendant l'année 1900 :"},null,null,{"$f":"F109","v":0},null,"(C)"]
[{"$f":"\"Excédent des recettes sur les dépenses :\"","v":"Excédent des recettes sur les dépenses :"},null,null,{"$f":"D116-D117","v":0}]
[{"$f":"\"- Déficit en \"&Gestionnaires!H2&\" :\"","v":"- Déficit en 1900 :"},null,null,{"$f":"F85","v":0},null,{"$f":"\"*\"","v":"*"}]
["Réalité de la trésorie :",null,null,{"$f":"D118-D119","v":0}]
[]
[{"$f":"IF(Gestionnaires!L28=\"Monsieur\",\"Le \",\"La \")&IF(Gestionnaires!L28=\"Monsieur\",\"soussigné, \",\"soussignée, \")&Gestionnaires!L10&\" \"&Gestionnaires!L9&\" \"&\"comptable de \"&LOOKUP(\"X\",Identification!B2:B344,Identification!D2:D344)&\",\"","v":{"$error":"#N/A"}}]
[{"$f":"\"affirme sous peine de droit, véritable dans toutes ses parties, le présent compte qui est le résumé des recettes et des dépenses effectuées par \"&IF(Gestionnaires!L28=\"Monsieur\",\"lui \",\"elle \")&\" pendant la durée de sa gestion\"","v":"affirme sous peine de droit, véritable dans toutes ses parties, le présent compte qui est le résumé des recettes et des dépenses effectuées par elle  pendant la durée de sa gestion"}]
[]
[]
[{"$f":"\"Fait à  \"&LOOKUP(\"X\",Identification!B2:B344,Identification!G2:G344&\", \"&\"le \"&TEXT(Gestionnaires!L17,\"jj/mm/aaaa\"))","v":{"$error":"#N/A"}},null,null,null,{"$f":"IF(Gestionnaires!L28=\"Monsieur\",\"Le \",\"La \") &\"comptable,\"","v":"La comptable,"}]
[]
[]
[]
["E. REMARQUES EVENTUELLES (Manuscrites) :"]

{"sheet":"1er semestre","index":20,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[[16,0,16,1],[17,0,17,1],[14,0,14,1],[20,0,20,1],[24,0,24,1],[1,0,1,4],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[26,0,26,1],[12,0,12,1],[2,0,2,1],[15,0,15,1],[21,0,21,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[18,0,18,1],[19,0,19,1],[22,0,22,1],[23,0,23,1],[25,0,25,1],[13,0,13,1]]}
[]
["Livre centralisateur 1er semestre (30 JUIN)"]
[null,null,"Recettes","Dépenses","Solde remis"]
["Caisse",null,0,0,{"$f":"C4-D4","v":0}]
["Dotation",null,0,0,{"$f":"C5-D5","v":0}]
["Placement 1",null,0,0,0]
["Placement 2",null,0,0,0]
["Placement 3",null,0,0,0]
["Placement 4",null,0,0,0]
["Placement 5",null,0,0,0]
["PV déficit",null,0,0,0]
["Sous-totaux",null,{"$f":"SUM(C4:C11)","v":0},{"$f":"SUM(D4:D11)","v":0},0]
["Mouvements de fonds",null,0,0,0]
["Totaux",null,{"$f":"C12-C13","v":0},{"$f":"D12-D13","v":0},0]
["Opérations courantes"]
["Intendance",null,0,0,{"$f":"C16-D16","v":0}]
["Fonctionnement",null,0,0,0]
["Fond de réserve",null,0,0,0]
["Total OC",null,{"$f":"SUM(C16:C18)","v":0},{"$f":"SUM(D16:D18)","v":0},0]
["Opérations en capital",null,0,0,0]
["Opérations pour ordre"]
["Tiers",null,0,0,0]
["Trésor",null,0,0,0]
["Total PO",null,{"$f":"SUM(C22:C23)","v":0},{"$f":"SUM(D22:D23)","v":0},{"$f":"C24-D24","v":0}]
["Sous-totaux",null,{"$f":"C19+C20+C24","v":0},{"$f":"D19+D20+D24","v":0},{"$f":"C25-D25","v":0}]
["Transferts",null,0,0,{"$f":"C26-D26","v":0}]
["Totaux",null,{"$f":"C25-C26","v":0},{"$f":"D25-D26","v":0},{"$f":"C27-D27","v":0}]

{"sheet":"2ème semestre","index":21,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[[12,0,12,1],[1,0,1,4],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[2,0,2,1],[22,0,22,1],[23,0,23,1],[26,0,26,1],[13,0,13,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[15,0,15,1],[25,0,25,1],[21,0,21,1],[24,0,24,1]]}
[]
["Livres centralisateurs 2ème semestre (31 décembre)"]
[null,null,"Recettes","Dépenses","Solde remis"]
["Caisse",null,0,0,0]
["Dotation",null,0,0,0]
["Placement 1",null,0,0,0]
["Placement 2",null,0,0,{"$f":"C7-D7","v":0}]
["Placement 3",null,0,0,0]
["Placement 4",null,0,0,0]
["Placement 5",null,0,0,0]
["PV déficit",null,0,0,0]
["Sous-totaux",null,{"$f":"SUM(C4:C11)","v":0},{"$f":"SUM(D4:D11)","v":0},0]
["Mouvements de fonds",null,0,0,0]
["Totaux",null,{"$f":"C12-C13","v":0},{"$f":"D12-D13","v":0},0]
["Opérations courantes"]
["Intendance",null,0,0,{"$f":"C16-D16","v":0}]
["Fonctionnement",null,0,0,0]
["Fond de réserve",null,0,0,0]
["Total OC",null,{"$f":"SUM(C16:C18)","v":0},{"$f":"SUM(D16:D18)","v":0},0]
["Opérations en capital",null,0,0,0]
["Opérations pour ordre"]
["Tiers",null,0,0,0]
["Trésor",null,0,0,0]
["Total PO",null,{"$f":"SUM(C22:C23)","v":0},{"$f":"SUM(D22:D23)","v":0},0]
["Sous-totaux",null,{"$f":"C19+C20+C24","v":0},{"$f":"D19+D20+D24","v":0},{"$f":"C25-D25","v":0}]
["Transferts",null,0,0,{"$f":"C26-D26","v":0}]
["Totaux",null,{"$f":"C25-C26","v":0},{"$f":"D25-D26","v":0},{"$f":"C27-D27","v":0}]

{"sheet":"Jaune 31-12","index":22,"n_rows":38,"n_cols":13,"rows_kept":38,"cut":false,"hidden":true,"merged":[[38,0,38,6],[38,7,38,12],[13,1,13,2],[14,1,14,2],[15,1,15,2],[30,0,30,6],[30,7,30,12],[31,0,31,6],[31,7,31,12],[5,1,5,2],[6,1,6,2],[7,1,7,2],[32,0,32,6],[32,7,32,12],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[2,0,3,0],[2,3,2,7],[2,8,2,11],[3,1,3,2],[3,3,3,6],[3,8,3,11],[0,0,0,6],[0,7,0,12],[1,1,1,2],[1,4,1,5],[1,9,1,10]]}
["ANNEE 2014",null,null,null,null,null,null," DEUXIEME SEMESTRE"]
[1,2,null,3,4,null,5,6,7,8,null,9,10]
["COMPTES",null,null,"RECETTES",null,null,null,null,"DEPENSES"]
[null,"SOLDE AU 31/12\nDE L'ANNEE PRECEDENTE",null,"RECETTES DE L'ANNEE EN COURS",null,null,null,"TOTAL GENERAL DES RECETTES","DEPENSES DE L'ANNEE EN COURS",null,null,null,"A JUSTIFIER AU 31/12/2014"]
[null,null,null,"01/01/2014 au 30/06/2014","01/07/2014 au 31/08/2014","01/09/2014 au 31/12/2014","TOTAL COL 3+4","COL 2+5","01/01/2014 au 30/06/2014","01/07/2014 au 31/08/2014","01/09/2014 au 31/12/2014","TOTAL COL 7+8","COL 6-9"]
["CPTE CAISSE",0,null,null,0,0,{"$f":"SUM(D6:F6)","v":0},{"$f":"(B6+G6)","v":0},null,0,0,{"$f":"SUM(I6:K6)","v":0},{"$f":"(H6-L6)","v":0}]
["CPTE COURANT",0,null,null,0,0,0,0,null,0,0,0,0]
["CPTE PLACEMENT N°1",null,null,null,0,0,0,0,0,0,0,0,0]
["CPTE PLACEMENT N°2"]
["CPTE PLACEMENT N°3"]
["CPTE PLACEMENT N°4"]
["CPTE PLACEMENT N°5"]
["PV DE DEFICIT",0,null,0,0,0,0,0,0,0,0,0,0]
["SOUS-TOTAL",{"$f":"SUM(B6:B13)","v":0},null,{"$f":"SUM(D6:D13)","v":0},{"$f":"SUM(E6:E13)","v":0},{"$f":"SUM(F6:F13)","v":0},0,0,{"$f":"SUM(I6:I13)","v":0},{"$f":"SUM(J6:J13)","v":0},{"$f":"SUM(K6:K13)","v":0},0,0]
["MOUV. DE FONDS",0,null,null,0,0,null,0,null,0,{"$f":"F15","v":0},0,0]
["TOTAL",{"$f":"(B14-B15)","v":0},null,{"$f":"(D14-D15)","v":0},{"$f":"(E14-E15)","v":0},{"$f":"(F14-F15)","v":0},0,0,{"$f":"(I14-I15)","v":0},{"$f":"(J14-J15)","v":0},{"$f":"(K14-K15)","v":0},0,0]
["OP. COURANTES","2a","2b"]
["INTENDANCE",null,null,null,null,0,{"$f":"SUM(D18:F18)","v":0},{"$f":"(C18+G18)","v":0},null,null,0,{"$f":"SUM(I18:K18)","v":0},{"$f":"(H18-L18)","v":0}]
["FONCTIONNEMENT",null,null,null,null,0,{"$f":"SUM(D19:F19)","v":0},{"$f":"(C19+G19)","v":0},null,null,0,{"$f":"SUM(I19:K19)","v":0},{"$f":"(H19-L19)","v":0}]
["RESERVE",null,null,null,null,0,{"$f":"SUM(D20:F20)","v":0},{"$f":"(C20+G20)","v":0},null,null,0,{"$f":"SUM(I20:K20)","v":0},{"$f":"(H20-L20)","v":0}]
["TOTAL",null,null,null,null,{"$f":"SUM(F18:F20)","v":0},{"$f":"SUM(D21:F21)","v":0},{"$f":"(C21+G21)","v":0},null,null,{"$f":"SUM(K18:K20)","v":0},{"$f":"SUM(I21:K21)","v":0},{"$f":"(H21-L21)","v":0}]
["OP. DE CAPITAL",null,null,0,0,0,{"$f":"SUM(D22:F22)","v":0},{"$f":"(C22+G22)","v":0},null,0,0,{"$f":"SUM(I22:K22)","v":0},{"$f":"(H22-L22)","v":0}]
["OP. POUR ORDRE"]
["TIERS",0,{"$f":"SUM(B24)","v":0},0,0,0,{"$f":"SUM(D24:F24)","v":0},{"$f":"(C24+G24)","v":0},0,0,0,{"$f":"SUM(I24:K24)","v":0},{"$f":"(H24-L24)","v":0}]
["TRESOR",0,{"$f":"SUM(B25)","v":0},0,0,0,{"$f":"SUM(D25:F25)","v":0},{"$f":"(C25+G25)","v":0},0,0,0,{"$f":"SUM(I25:K25)","v":0},{"$f":"(H25-L25)","v":0}]
["DIVERS",0,{"$f":"SUM(B26)","v":0},0,0,0,{"$f":"SUM(D26:F26)","v":0},{"$f":"(C26+G26)","v":0},0,0,0,{"$f":"SUM(I26:K26)","v":0},{"$f":"(H26-L26)","v":0}]
["TOTAL",{"$f":"SUM(B24:B26)","v":0},{"$f":"SUM(B27)","v":0},{"$f":"SUM(D24:D26)","v":0},{"$f":"SUM(E24:E26)","v":0},{"$f":"SUM(F24:F26)","v":0},{"$f":"SUM(D27:F27)","v":0},{"$f":"(C27+G27)","v":0},{"$f":"SUM(I24:I26)","v":0},{"$f":"SUM(J24:J26)","v":0},{"$f":"SUM(K24:K26)","v":0},{"$f":"SUM(I27:K27)","v":0},{"$f":"(H27-L27)","v":0}]
["TOTAL GENERAL",{"$f":"(B21+B22+B27)","v":0},{"$f":"(C21+C22+C27)","v":0},{"$f":"(D21+D22+D27)","v":0},{"$f":"(E21+E22+E27)","v":0},{"$f":"(F21+F22+F27)","v":0},{"$f":"SUM(D28:F28)","v":0},{"$f":"(C28+G28)","v":0},{"$f":"(I21+I22+I27)","v":0},{"$f":"(J21+J22+J27)","v":0},{"$f":"(K21+K22+K27)","v":0},{"$f":"SUM(I28:K28)","v":0},{"$f":"(H28-L28)","v":0}]
[]
[]
["CERTIFIE CONFORME AUX ECRITURES",null,null,null,null,null,null,"VU ET APPROUVE"]
["FAIT A                             , LE ",null,null,null,null,null,null,{"$f":"A32","v":"FAIT A                             , LE "}]
["LE (LA)  COMPTABLE,",null,null,null,null,null,null,"LE (LA) CHEF D'ETABLISSEMENT,"]
[]
[]
[]
[]
[null,null,"Nom du (de la) comptable",null,null,null,null,null,null,"Nom du directeur"]

{"sheet":"Compte scindé","index":23,"n_rows":33,"n_cols":18,"rows_kept":33,"cut":false,"hidden":false,"merged":[[5,1,5,2],[6,1,6,2],[7,1,7,2],[2,0,3,0],[2,3,2,9],[2,10,2,15],[3,1,3,2],[3,3,3,8],[0,0,0,8],[0,9,0,16],[1,1,1,2],[1,6,1,7],[3,10,3,14],[3,9,4,9],[3,15,4,15],[32,0,32,8],[12,1,12,2],[32,9,32,16],[37,0,37,8],[37,9,37,16],[13,1,13,2],[14,1,14,2],[15,1,15,2],[30,0,30,8],[30,9,30,16],[31,0,31,8],[31,9,31,16],[10,17,12,17],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2]]}
[{"$f":" \"Compte scindé de \"&LOOKUP(\"X\",Identification!B2:B344,Identification!D2:D344)&\" - Année \"&RIGHT(TEXT(Gestionnaires!C12,\"jj/mm/aaaa\"),4)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,{"$f":"A1","v":{"$error":"#N/A"}}]
[1,2,null,3,4,5,6,null,7,8,9,10,11,12,13,15,15]
["COMPTES",null,null,"RECETTES",null,null,null,null,null,null,"DEPENSES"]
[null,"SOLDE AU 31/12\nDE L'ANNEE PRECEDENTE",null,"RECETTES DE L'ANNEE EN COURS",null,null,null,null,null,"TOTAL GENERAL DES RECETTES","DEPENSES DE L'ANNEE EN COURS",null,null,null,null,"TOTAL GENERAL DES DEPENSES",{"$f":"\"A justifier au 31/12/\"&Gestionnaires!H2","v":"A justifier au 31/12/1900"}]
[null,null,null,"Du 1er janvier au 2 mai","Du 3 mai au 3 juin","Du 4 juin au 30 juin","N/A.","Du 1 juillet au 31 décembre","Total des colonnes 3 à 7",null,{"$f":"D5","v":"Du 1er janvier au 2 mai"},{"$f":"E5","v":"Du 3 mai au 3 juin"},"Du 4 juin au 30 juin","N/A.","Du 1 juillet au 31 décembre",null,"COL 6-9"]
["CPTE CAISSE",{"$f":"Reports!D4","v":0},null,1532.4,7404.33,3136.2,0,0,{"$f":"SUM(D6:H6)","v":12072.93},{"$f":"B6+I6","v":12072.93},0,7687.03,4387.03,0,0,{"$f":"SUM(K6:O6)","v":12074.06},{"$f":"(J6-P6)","v":-1.1299999999991996}]
["CPTE COURANT",{"$f":"Reports!D5","v":0},null,254.3,99915.32,10525.38,0,0,{"$f":"SUM(D7:H7)","v":110695.00000000001},{"$f":"B7+I7","v":110695.00000000001},15044.73,85029.7,45615.35,0,0,{"$f":"SUM(K7:O7)","v":145689.78},-34994.779999999984]
["CPTE PLAC. N°1",{"$f":"Reports!D6","v":0},null,70.180000000000007,58.52,0,0,0,128.70000000000002,128.70000000000002,0,0,0,0,0,0,128.70000000000002]
["CPTE PLAC. N°2",{"$f":"Reports!D7","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["CPTE PLAC. N°3",{"$f":"Reports!D8","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["CPTE PLAC. N°4",{"$f":"Reports!D9","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Avoir en caisse = \nTotaux financiers\n- Déficit"]
["CPTE PLAC. N°5",{"$f":"Reports!D10","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["PV DE DEFICIT",{"$f":"Reports!D11","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["SOUS-TOTAL",{"$f":"Reports!D12","v":0},null,1856.88,107378.17,13661.58,0,0,122896.63,122896.63,15044.73,92716.73,50002.38,0,0,157763.84,-34867.209999999992,{"$f":"Q14","v":-34867.209999999992}]
["MOUV. DE FONDS",{"$f":"Reports!D13","v":0},null,0,7689.46,4387.03,0,0,12076.49,12076.49,0,7689.46,4387.03,0,0,12076.49,0,{"$f":"\"(-)\"&Q13","v":"(-)0"}]
["TOTAL",{"$f":"Reports!D14","v":0},null,1856.88,99688.71,9274.5499999999993,0,0,110820.14000000001,110820.14000000001,15044.73,85027.27,45615.35,0,0,145687.35,-34867.209999999992,{"$f":"Q16-Q13","v":-34867.209999999992}]
["OP. COURANTES","2A","2B"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
["INTENDANCE",{"$f":"Reports!C16","v":0},{"$f":"Reports!D16","v":0},1647.2,7678.3,3530.3,0,0,12855.8,{"$f":"C18+I18","v":12855.8},1382.9,6074.1,2087.48,0,0,9544.48,{"$f":"(J18-P18)","v":3311.3199999999997}]
["FONCTIONNEMENT",{"$f":"Reports!C17","v":0},{"$f":"Reports!D17","v":0},209.68,92010.41,5744.25,0,0,97964.34,{"$f":"C19+I19","v":97964.34},12695.04,78374.179999999993,43527.87,0,0,134597.09,{"$f":"(J19-P19)","v":-36632.75}]
["RESERVE",{"$f":"Reports!C18","v":0},{"$f":"Reports!D18","v":0},0,0,0,0,0,0,{"$f":"C20+I20","v":0},0,0,0,0,0,0,{"$f":"(J20-P20)","v":0}]
["TOTAL",{"$f":"Reports!C19","v":0},{"$f":"Reports!D19","v":0},1856.88,99688.71,9274.5499999999993,0,0,110820.14000000001,{"$f":"C21+I21","v":110820.14000000001},14077.94,84448.28,45615.35,0,0,144141.57,{"$f":"(J21-P21)","v":-33321.429999999993}]
["OP. DE CAPITAL",{"$f":"Reports!C20","v":0},{"$f":"Reports!D20","v":0},10000,0,-10000,0,0,0,{"$f":"C22+I22","v":0},966.79,578.99,-1545.78,0,0,0,{"$f":"(J22-P22)","v":0}]
["OP. POUR ORDRE"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
["TIERS",{"$f":"Reports!C22","v":0},{"$f":"Reports!D22","v":0},0,0,0,0,0,0,{"$f":"C24+I24","v":0},0,0,0,0,0,0,{"$f":"(J24-P24)","v":0}]
["TRESOR",{"$f":"Reports!C23","v":0},{"$f":"Reports!D23","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(J25-P25)","v":0}]
["TOTAL",{"$f":"Reports!C24","v":0},{"$f":"Reports!D24","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(J26-P26)","v":0}]
["SOUS-TOTAL",{"$f":"Reports!C25","v":0},{"$f":"Reports!D25","v":0},11856.88,99688.71,-725.45,0,0,110820.14000000001,110820.14000000001,15044.73,85027.27,44069.57,0,0,144141.57,{"$f":"(J27-P27)","v":-33321.429999999993}]
["TRANSFERT",{"$f":"Reports!C26","v":0},{"$f":"Reports!D26","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["TOTAL GENERAL",{"$f":"Reports!C27","v":0},{"$f":"Reports!D27","v":0},11856.88,99688.71,-725.45,0,0,110820.14000000001,110820.14000000001,15044.73,85027.27,44069.57,0,0,144141.57,{"$f":"(J29-P29)","v":-33321.429999999993}]
[]
["CERTIFIE CONFORME AUX ECRITURES",null,null,null,null,null,null,null,null,"VU ET APPROUVE"]
[{"$f":"\"Fait à \"&LOOKUP(\"X\",Identification!B2:B344,Identification!G2:G344)&\", le 31/12/\"&Gestionnaires!H2","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,{"$f":"A32","v":{"$error":"#N/A"}}]
[{"$f":"IF(Gestionnaires!L12<>\"\",IF(Gestionnaires!L19=\"Monsieur\",\"Le comptable \",\"La comptable \"),IF(Gestionnaires!F12<>\"\",IF(Gestionnaires!F19=\"Monsieur\",\"Le comptable \",\"La comptable \"),IF(Gestionnaires!C19=\"Monsieur\",\"Le comptable \",\"La comptable \")))&\", \"&IF(Gestionnaires!L12<>\"\",Gestionnaires!L21&\" \"&UPPER(Gestionnaires!L20),IF(Gestionnaires!F12<>\"\",Gestionnaires!F21&\" \"&UPPER(Gestionnaires!F20),Gestionnaires!C21&\" \"&UPPER(Gestionnaires!C20)))","v":"La comptable ,  "},null,null,null,null,null,null,null,null,{"$f":"IF(Gestionnaires!C2=\"Monsieur\",\"Le Chef d'étabissement, \",\"La Cheffe d'établissement, \")&Gestionnaires!C5&\" \"&UPPER(Gestionnaires!C4)","v":"La Cheffe d'établissement,  "}]

{"sheet":"Compte scindé 30 juin","index":24,"n_rows":33,"n_cols":18,"rows_kept":33,"cut":false,"hidden":false,"merged":[[37,0,37,8],[37,9,37,16],[15,1,15,2],[30,0,30,8],[30,9,30,16],[31,0,31,8],[31,9,31,16],[32,0,32,8],[32,9,32,16],[14,1,14,2],[3,10,3,14],[3,15,4,15],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[10,17,12,17],[0,0,0,8],[0,9,0,16],[1,1,1,2],[1,6,1,7],[2,0,3,0],[2,3,2,9],[2,10,2,15],[3,1,3,2],[3,3,3,8],[3,9,4,9]]}
[{"$f":" \"Compte scindé de \"&LOOKUP(\"X\",Identification!B2:B344,Identification!D2:D344)&\" - Année \"&RIGHT(TEXT(Gestionnaires!C12,\"jj/mm/aaaa\"),4)&\" - Situation au 30 juin\"","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,{"$f":"A1","v":{"$error":"#N/A"}}]
[1,2,null,3,4,5,6,null,7,8,9,10,11,12,13,15,15]
["COMPTES",null,null,"RECETTES",null,null,null,null,null,null,"DEPENSES"]
[null,"SOLDE AU 31/12\nDE L'ANNEE PRECEDENTE",null,"RECETTES DE L'ANNEE EN COURS",null,null,null,null,null,"TOTAL GENERAL DES RECETTES","DEPENSES DE L'ANNEE EN COURS",null,null,null,null,"TOTAL GENERAL DES DEPENSES",{"$f":"\"A justifier au 30/06/\"&Gestionnaires!H2","v":"A justifier au 30/06/1900"}]
[null,null,null,"Du 1er janvier au 2 mai","Du 3 mai au 3 juin","Du 4 juin au 30 juin","NA","NA","Total des colonnes 3 à 7",null,{"$f":"D5","v":"Du 1er janvier au 2 mai"},{"$f":"E5","v":"Du 3 mai au 3 juin"},"Du 4 juin au 30 juin","NA","NA",null,"COL 6-9"]
["CPTE CAISSE",{"$f":"Reports!D4","v":0},null,1532.4,7404.33,3136.2,0,0,{"$f":"SUM(D6:H6)","v":12072.93},{"$f":"B6+I6","v":12072.93},0,7687.03,4387.03,0,0,{"$f":"SUM(K6:O6)","v":12074.06},{"$f":"(J6-P6)","v":-1.1299999999991996}]
["CPTE COURANT",{"$f":"Reports!D5","v":0},null,254.3,99915.32,10525.38,0,0,{"$f":"SUM(D7:H7)","v":110695.00000000001},{"$f":"B7+I7","v":110695.00000000001},15044.73,85029.7,45615.35,0,0,{"$f":"SUM(K7:O7)","v":145689.78},-34994.779999999984]
["CPTE PLAC. N°1",{"$f":"Reports!D6","v":0},null,70.180000000000007,58.52,0,0,0,128.70000000000002,128.70000000000002,0,0,0,0,0,0,128.70000000000002]
["CPTE PLAC. N°2",{"$f":"Reports!D7","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["CPTE PLAC. N°3",{"$f":"Reports!D8","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["CPTE PLAC. N°4",{"$f":"Reports!D9","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Avoir en caisse = \nTotaux financiers\n- Déficit"]
["CPTE PLAC. N°5",{"$f":"Reports!D10","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["PV DE DEFICIT",{"$f":"Reports!D11","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["SOUS-TOTAL",{"$f":"Reports!D12","v":0},null,1856.88,107378.17,13661.58,0,0,122896.63,122896.63,15044.73,92716.73,50002.38,0,0,157763.84,-34867.209999999992,{"$f":"Q14","v":-34867.209999999992}]
["MOUV. DE FONDS",{"$f":"Reports!D13","v":0},null,0,7689.46,4387.03,0,0,12076.49,12076.49,0,7689.46,4387.03,0,0,12076.49,0,{"$f":"\"(-)\"&Q13","v":"(-)0"}]
["TOTAL",{"$f":"Reports!D14","v":0},null,1856.88,99688.71,9274.5499999999993,0,0,110820.14000000001,110820.14000000001,15044.73,85027.27,45615.35,0,0,145687.35,-34867.209999999992,{"$f":"Q16-Q13","v":-34867.209999999992}]
["OP. COURANTES","2A","2B"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
["INTENDANCE",{"$f":"Reports!C16","v":0},{"$f":"Reports!D16","v":0},1647.2,7678.3,3530.3,0,0,12855.8,{"$f":"C18+I18","v":12855.8},1382.9,6074.1,2087.48,0,0,9544.48,{"$f":"(J18-P18)","v":3311.3199999999997}]
["FONCTIONNEMENT",{"$f":"Reports!C17","v":0},{"$f":"Reports!D17","v":0},209.68,92010.41,5744.25,0,0,97964.34,{"$f":"C19+I19","v":97964.34},12695.04,78374.179999999993,43527.87,0,0,134597.09,{"$f":"(J19-P19)","v":-36632.75}]
["RESERVE",{"$f":"Reports!C18","v":0},{"$f":"Reports!D18","v":0},0,0,0,0,0,0,{"$f":"C20+I20","v":0},0,0,0,0,0,0,{"$f":"(J20-P20)","v":0}]
["TOTAL",{"$f":"Reports!C19","v":0},{"$f":"Reports!D19","v":0},1856.88,99688.71,9274.5499999999993,0,0,110820.14000000001,{"$f":"C21+I21","v":110820.14000000001},14077.94,84448.28,45615.35,0,0,144141.57,{"$f":"(J21-P21)","v":-33321.429999999993}]
["OP. DE CAPITAL",{"$f":"Reports!C20","v":0},{"$f":"Reports!D20","v":0},10000,0,-10000,0,0,0,{"$f":"C22+I22","v":0},966.79,578.99,-1545.78,0,0,0,{"$f":"(J22-P22)","v":0}]
["OP. POUR ORDRE"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
["TIERS",{"$f":"Reports!C22","v":0},{"$f":"Reports!D22","v":0},0,0,0,0,0,0,{"$f":"C24+I24","v":0},0,0,0,0,0,0,{"$f":"(J24-P24)","v":0}]
["TRESOR",{"$f":"Reports!C23","v":0},{"$f":"Reports!D23","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(J25-P25)","v":0}]
["TOTAL",{"$f":"Reports!C24","v":0},{"$f":"Reports!D24","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(J26-P26)","v":0}]
["SOUS-TOTAL",{"$f":"Reports!C25","v":0},{"$f":"Reports!D25","v":0},11856.88,99688.71,-725.45,0,0,110820.14000000001,110820.14000000001,15044.73,85027.27,44069.57,0,0,144141.57,{"$f":"(J27-P27)","v":-33321.429999999993}]
["TRANSFERT",{"$f":"Reports!C26","v":0},{"$f":"Reports!D26","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["TOTAL GENERAL",{"$f":"Reports!C27","v":0},{"$f":"Reports!D27","v":0},11856.88,99688.71,-725.45,0,0,110820.14000000001,110820.14000000001,15044.73,85027.27,44069.57,0,0,144141.57,{"$f":"(J29-P29)","v":-33321.429999999993}]
[]
["CERTIFIE CONFORME AUX ECRITURES",null,null,null,null,null,null,null,null,"VU ET APPROUVE"]
[{"$f":"\"Fait à \"&LOOKUP(\"X\",Identification!B2:B344,Identification!G2:G344)&\", le 30/06/\"&Gestionnaires!H2","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,{"$f":"A32","v":{"$error":"#N/A"}}]
[{"$f":"IF(AND(Gestionnaires!L12<>\"\",Gestionnaires!L12<DATEVALUE(\"30/06/\"&Gestionnaires!H2)),IF(Gestionnaires!L19=\"Monsieur\",\"Le comptable \",\"La comptable \"),IF(AND(Gestionnaires!L12<>\"\",Gestionnaires!L12>DATEVALUE(\"30/06/\"&Gestionnaires!H2)),IF(Gestionnaires!L8=\"Monsieur\",\"Le comptable \",\"La comptable \"),IF(AND(Gestionnaires!F12<>\"\",Gestionnaires!F12<DATEVALUE(\"30/06/\"&Gestionnaires!H2)),IF(Gestionnaires!F19=\"Monsieur\",\"Le comptable \",\"La comptable \"),IF(AND(Gestionnaires!F12<>\"\",Gestionnaires!F12>DATEVALUE(\"30/06/\"&Gestionnaires!H2)),IF(Gestionnaires!F8=\"Monsieur\",\"Le comptable \",\"La comptable \"),IF(AND(Gestionnaires!C12<>\"\",Gestionnaires!F12<DATEVALUE(\"30/06/\"&Gestionnaires!H2)),IF(Gestionnaires!C19=\"Monsieur\",\"Le compatble \",\"La comptable \"),IF(Gestionnaires!C8=\"Monsieur\",\"Le comptable \",\"La comptable \"))))))&\", \"&IF(AND(Gestionnaires!L12<>\"\",Gestionnaires!L12<DATEVALUE(\"30/06/\"&Gestionnaires!H2)),Gestionnaires!L21&\" \"&UPPER(Gestionnaires!L20),IF(AND(Gestionnaires!F12<>\"\",Gestionnaires!F12<DATEVALUE(\"30/06/\"&Gestionnaires!H2)),Gestionnaires!F21&\" \"&UPPER(Gestionnaires!F20),IF(Gestionnaires!C12<DATEVALUE(\"30/06/\"&Gestionnaires!H2),Gestionnaires!C21&\" \"&UPPER(Gestionnaires!C20),Gestionnaires!C10&\" \"&UPPER(Gestionnaires!C9))))","v":"La comptable ,  "},null,null,null,null,null,null,null,null,{"$f":"IF(Gestionnaires!C2=\"Monsieur\",\"Le Chef d'étabissement, \",\"La Cheffe d'établissement, \")&Gestionnaires!C5&\" \"&UPPER(Gestionnaires!C4)","v":"La Cheffe d'établissement,  "}]

{"sheet":"Compte scindé RR1","index":25,"n_rows":33,"n_cols":18,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,9,0,16],[1,1,1,2],[1,6,1,7],[2,0,3,0],[2,3,2,9],[2,10,2,15],[3,1,3,2],[3,3,3,8],[3,9,4,9],[3,10,3,14],[3,15,4,15],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[0,0,0,8],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[10,17,12,17],[37,0,37,8],[37,9,37,16],[15,1,15,2],[30,0,30,8],[30,9,30,16],[31,0,31,8],[31,9,31,16],[32,0,32,8],[32,9,32,16],[14,1,14,2],[13,1,13,2]]}
[{"$f":" \"Compte scindé de \"&LOOKUP(\"X\",Identification!B2:B344,Identification!D2:D344)&\" - Année \"&RIGHT(TEXT(Gestionnaires!C12,\"jj/mm/aaaa\"),4)&\" - Sortie de \"&PROPER(Gestionnaires!C8)&\" \"&Gestionnaires!C10&\" \"&UPPER(Gestionnaires!C9)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,{"$f":"A1","v":{"$error":"#N/A"}}]
[1,2,null,3,4,5,6,null,7,8,9,10,11,12,13,15,15]
["COMPTES",null,null,"RECETTES",null,null,null,null,null,null,"DEPENSES"]
[null,"SOLDE AU 31/12\nDE L'ANNEE PRECEDENTE",null,"RECETTES DE L'ANNEE EN COURS",null,null,null,null,null,"TOTAL GENERAL DES RECETTES","DEPENSES DE L'ANNEE EN COURS",null,null,null,null,"TOTAL GENERAL DES DEPENSES",{"$f":"\"A justifier au \"&TEXT(Gestionnaires!C12,\"jj/mm/aaaa\")","v":"A justifier au 00/01/1900"}]
[null,null,null,"Du 1er janvier au 30 juin","Du 1er juillet au 2 octobre","NA","NA","NA","Total des colonnes 3 à 7",null,{"$f":"D5","v":"Du 1er janvier au 30 juin"},{"$f":"E5","v":"Du 1er juillet au 2 octobre"},"NA","NA","NA",null,"COL 6-9"]
["CPTE CAISSE",{"$f":"Reports!D4","v":0},null,12072.93,-10540.53,0,0,0,{"$f":"SUM(D6:H6)","v":1532.3999999999996},{"$f":"B6+I6","v":1532.3999999999996},12074.06,-12074.06,0,0,0,{"$f":"SUM(K6:O6)","v":0},{"$f":"(J6-P6)","v":1532.3999999999996}]
["CPTE COURANT",{"$f":"Reports!D5","v":0},null,110695,-110440.7,0,0,0,{"$f":"SUM(D7:H7)","v":254.30000000000291},{"$f":"B7+I7","v":254.30000000000291},145689.78,-130645.05,0,0,0,{"$f":"SUM(K7:O7)","v":15044.729999999996},-14790.429999999993]
["CPTE PLAC. N°1",{"$f":"Reports!D6","v":0},null,128.69999999999999,-58.52,0,0,0,70.179999999999978,70.179999999999978,0,0,0,0,0,0,70.179999999999978]
["CPTE PLAC. N°2",{"$f":"Reports!D7","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["CPTE PLAC. N°3",{"$f":"Reports!D8","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["CPTE PLAC. N°4",{"$f":"Reports!D9","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Avoir en caisse = \nTotaux financiers\n- Déficit"]
["CPTE PLAC. N°5",{"$f":"Reports!D10","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["PV DE DEFICIT",{"$f":"Reports!D11","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["SOUS-TOTAL",{"$f":"Reports!D12","v":0},null,122896.63,-121039.75,0,0,0,1856.8800000000047,1856.8800000000047,157763.84,-142719.10999999999,0,0,0,15044.73000000001,-13187.850000000006,{"$f":"Q14","v":-13187.850000000006}]
["MOUV. DE FONDS",{"$f":"Reports!D13","v":0},null,12076.49,-12076.49,0,0,0,0,0,12076.49,-12076.49,0,0,0,0,0,{"$f":"\"(-)\"&Q13","v":"(-)0"}]
["TOTAL",{"$f":"Reports!D14","v":0},null,110820.14,-108963.26,0,0,0,1856.8800000000047,1856.8800000000047,145687.35,-130642.62,0,0,0,15044.73000000001,-13187.850000000006,{"$f":"Q16-Q13","v":-13187.850000000006}]
["OP. COURANTES","2A","2B"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
["INTENDANCE",{"$f":"Reports!C16","v":0},{"$f":"Reports!D16","v":0},12855.8,-11208.6,0,0,0,1647.1999999999989,{"$f":"C18+I18","v":1647.1999999999989},9544.48,-8161.58,0,0,0,1382.8999999999996,{"$f":"(J18-P18)","v":264.29999999999927}]
["FONCTIONNEMENT",{"$f":"Reports!C17","v":0},{"$f":"Reports!D17","v":0},97964.34,-97754.66,0,0,0,209.67999999999302,{"$f":"C19+I19","v":209.67999999999302},134597.09,-121902.05,0,0,0,12695.039999999994,{"$f":"(J19-P19)","v":-12485.36}]
["RESERVE",{"$f":"Reports!C18","v":0},{"$f":"Reports!D18","v":0},0,0,0,0,0,0,{"$f":"C20+I20","v":0},0,0,0,0,0,0,{"$f":"(J20-P20)","v":0}]
["TOTAL",{"$f":"Reports!C19","v":0},{"$f":"Reports!D19","v":0},110820.14,-108963.26,0,0,0,1856.8800000000047,{"$f":"C21+I21","v":1856.8800000000047},144141.57,-130063.63,0,0,0,14077.940000000002,{"$f":"(J21-P21)","v":-12221.059999999998}]
["OP. DE CAPITAL",{"$f":"Reports!C20","v":0},{"$f":"Reports!D20","v":0},0,10000,0,0,0,10000,{"$f":"C22+I22","v":10000},0,966.79,0,0,0,966.79,{"$f":"(J22-P22)","v":9033.2099999999991}]
["OP. POUR ORDRE"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
["TIERS",{"$f":"Reports!C22","v":0},{"$f":"Reports!D22","v":0},0,0,0,0,0,0,{"$f":"C24+I24","v":0},0,0,0,0,0,0,{"$f":"(J24-P24)","v":0}]
["TRESOR",{"$f":"Reports!C23","v":0},{"$f":"Reports!D23","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(J25-P25)","v":0}]
["TOTAL",{"$f":"Reports!C24","v":0},{"$f":"Reports!D24","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(J26-P26)","v":0}]
["SOUS-TOTAL",{"$f":"Reports!C25","v":0},{"$f":"Reports!D25","v":0},110820.14,-98963.26,0,0,0,11856.880000000005,11856.880000000005,144141.57,-129096.84,0,0,0,15044.73000000001,{"$f":"(J27-P27)","v":-3187.8500000000058}]
["TRANSFERT",{"$f":"Reports!C26","v":0},{"$f":"Reports!D26","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["TOTAL GENERAL",{"$f":"Reports!C27","v":0},{"$f":"Reports!D27","v":0},110820.14,-98963.26,0,0,0,11856.880000000005,11856.880000000005,144141.57,-129096.84,0,0,0,15044.73000000001,{"$f":"(J29-P29)","v":-3187.8500000000058}]
[]
["CERTIFIE CONFORME AUX ECRITURES",null,null,null,null,null,null,null,null,"VU ET APPROUVE"]
[{"$f":"\"Fait à \"&LOOKUP(\"X\",Identification!B2:B344,Identification!G2:G344)&\", le \"&TEXT(Gestionnaires!C12,\"jj/mm/aaaa\")","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,{"$f":"A32","v":{"$error":"#N/A"}}]
[{"$f":"IF(Gestionnaires!C8=\"Monsieur\",\"Le comptable sortant \",\"La comptable sortante \")&\", \"&Gestionnaires!C10&\" \"&UPPER(Gestionnaires!C9)","v":"La comptable sortante ,  "},null,null,null,null,null,null,null,null,{"$f":"IF(Gestionnaires!C2=\"Monsieur\",\"Le Chef d'étabissement, \",\"La Cheffe d'établissement, \")&Gestionnaires!C5&\" \"&UPPER(Gestionnaires!C4)","v":"La Cheffe d'établissement,  "}]

{"sheet":"Compte scindé RR2","index":26,"n_rows":33,"n_cols":18,"rows_kept":33,"cut":false,"hidden":false,"merged":[[37,0,37,8],[37,9,37,16],[15,1,15,2],[30,0,30,8],[30,9,30,16],[31,0,31,8],[31,9,31,16],[32,0,32,8],[32,9,32,16],[14,1,14,2],[3,10,3,14],[3,15,4,15],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[10,17,12,17],[0,0,0,8],[0,9,0,16],[1,1,1,2],[1,6,1,7],[2,0,3,0],[2,3,2,9],[2,10,2,15],[3,1,3,2],[3,3,3,8],[3,9,4,9]]}
[{"$f":" \"Compte scindé de \"&LOOKUP(\"X\",Identification!B2:B344,Identification!D2:D344)&\" - Année \"&RIGHT(TEXT(Gestionnaires!C12,\"jj/mm/aaaa\"),4)&\" - Sortie de \"&PROPER(Gestionnaires!F8)&\" \"&Gestionnaires!F10&\" \"&UPPER(Gestionnaires!F9)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,{"$f":"A1","v":{"$error":"#N/A"}}]
[1,2,null,3,4,5,6,null,7,8,9,10,11,12,13,15,15]
["COMPTES",null,null,"RECETTES",null,null,null,null,null,null,"DEPENSES"]
[null,"SOLDE AU 31/12\nDE L'ANNEE PRECEDENTE",null,"RECETTES DE L'ANNEE EN COURS",null,null,null,null,null,"TOTAL GENERAL DES RECETTES","DEPENSES DE L'ANNEE EN COURS",null,null,null,null,"TOTAL GENERAL DES DEPENSES",{"$f":"\"A justifier au \"&TEXT(Gestionnaires!F12,\"jj/mm/aaaa\")","v":"A justifier au 00/01/1900"}]
[null,null,null,"Du 1er janvier au 30 juin","Du 1er juillet au 30 juin","N/A","N/A","N/A","Total des colonnes 3 à 7",null,{"$f":"D5","v":"Du 1er janvier au 30 juin"},{"$f":"E5","v":"Du 1er juillet au 30 juin"},"N/A","N/A","N/A",null,"COL 6-9"]
["CPTE CAISSE",{"$f":"Reports!D4","v":0},null,12072.93,-3136.2,0,0,0,{"$f":"SUM(D6:H6)","v":8936.73},{"$f":"B6+I6","v":8936.73},12074.06,-4387.03,0,0,0,{"$f":"SUM(K6:O6)","v":7687.03},{"$f":"(J6-P6)","v":1249.6999999999998}]
["CPTE COURANT",{"$f":"Reports!D5","v":0},null,110695,-10525.38,0,0,0,{"$f":"SUM(D7:H7)","v":100169.62},{"$f":"B7+I7","v":100169.62},145689.78,-45615.35,0,0,0,{"$f":"SUM(K7:O7)","v":100074.43},95.190000000002328]
["CPTE PLAC. N°1",{"$f":"Reports!D6","v":0},null,128.69999999999999,0,0,0,0,128.69999999999999,128.69999999999999,0,0,0,0,0,0,128.69999999999999]
["CPTE PLAC. N°2",{"$f":"Reports!D7","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["CPTE PLAC. N°3",{"$f":"Reports!D8","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["CPTE PLAC. N°4",{"$f":"Reports!D9","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Avoir en caisse = \nTotaux financiers\n- Déficit"]
["CPTE PLAC. N°5",{"$f":"Reports!D10","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["PV DE DEFICIT",{"$f":"Reports!D11","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["SOUS-TOTAL",{"$f":"Reports!D12","v":0},null,122896.63,-13661.58,0,0,0,109235.05,109235.05,157763.84,-50002.38,0,0,0,107761.45999999999,1473.5900000000111,{"$f":"Q14","v":1473.5900000000111}]
["MOUV. DE FONDS",{"$f":"Reports!D13","v":0},null,12076.49,-4387.03,0,0,0,7689.46,7689.46,12076.49,-4387.03,0,0,0,7689.46,0,{"$f":"\"(-)\"&Q13","v":"(-)0"}]
["TOTAL",{"$f":"Reports!D14","v":0},null,110820.14,-9274.5499999999993,0,0,0,101545.59,101545.59,145687.35,-45615.35,0,0,0,100072,1473.5899999999965,{"$f":"Q16-Q13","v":1473.5899999999965}]
["OP. COURANTES","2A","2B"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
["INTENDANCE",{"$f":"Reports!C16","v":0},{"$f":"Reports!D16","v":0},12855.8,-3530.3,0,0,0,9325.5,{"$f":"C18+I18","v":9325.5},9544.48,-2087.48,0,0,0,7457,{"$f":"(J18-P18)","v":1868.5}]
["FONCTIONNEMENT",{"$f":"Reports!C17","v":0},{"$f":"Reports!D17","v":0},97964.34,-5744.25,0,0,0,92220.09,{"$f":"C19+I19","v":92220.09},134597.09,-43527.87,0,0,0,91069.22,{"$f":"(J19-P19)","v":1150.8699999999953}]
["RESERVE",{"$f":"Reports!C18","v":0},{"$f":"Reports!D18","v":0},0,0,0,0,0,0,{"$f":"C20+I20","v":0},0,0,0,0,0,0,{"$f":"(J20-P20)","v":0}]
["TOTAL",{"$f":"Reports!C19","v":0},{"$f":"Reports!D19","v":0},110820.14,-9274.5499999999993,0,0,0,101545.59,{"$f":"C21+I21","v":101545.59},144141.57,-45615.35,0,0,0,98526.22,{"$f":"(J21-P21)","v":3019.3699999999953}]
["OP. DE CAPITAL",{"$f":"Reports!C20","v":0},{"$f":"Reports!D20","v":0},0,10000,0,0,0,10000,{"$f":"C22+I22","v":10000},0,1545.78,0,0,0,1545.78,{"$f":"(J22-P22)","v":8454.2199999999993}]
["OP. POUR ORDRE"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
["TIERS",{"$f":"Reports!C22","v":0},{"$f":"Reports!D22","v":0},0,0,0,0,0,0,{"$f":"C24+I24","v":0},0,0,0,0,0,0,{"$f":"(J24-P24)","v":0}]
["TRESOR",{"$f":"Reports!C23","v":0},{"$f":"Reports!D23","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(J25-P25)","v":0}]
["TOTAL",{"$f":"Reports!C24","v":0},{"$f":"Reports!D24","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(J26-P26)","v":0}]
["SOUS-TOTAL",{"$f":"Reports!C25","v":0},{"$f":"Reports!D25","v":0},110820.14,725.45,0,0,0,111545.59,111545.59,144141.57,-44069.57,0,0,0,100072,{"$f":"(J27-P27)","v":11473.589999999997}]
["TRANSFERT",{"$f":"Reports!C26","v":0},{"$f":"Reports!D26","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["TOTAL GENERAL",{"$f":"Reports!C27","v":0},{"$f":"Reports!D27","v":0},110820.14,725.45,0,0,0,111545.59,111545.59,144141.57,-44069.57,0,0,0,100072,{"$f":"(J29-P29)","v":11473.589999999997}]
[]
["CERTIFIE CONFORME AUX ECRITURES",null,null,null,null,null,null,null,null,"VU ET APPROUVE"]
[{"$f":"\"Fait à \"&LOOKUP(\"X\",Identification!B2:B344,Identification!G2:G344)&\", le \"&TEXT(Gestionnaires!F12,\"jj/mm/aaaa\")","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,{"$f":"A32","v":{"$error":"#N/A"}}]
[{"$f":"IF(Gestionnaires!F8=\"Monsieur\",\"Le comptable sortant \",\"La comptable sortante \")&\", \"&Gestionnaires!F10&\" \"&UPPER(Gestionnaires!F9)","v":"La comptable sortante ,  "},null,null,null,null,null,null,null,null,{"$f":"IF(Gestionnaires!C2=\"Monsieur\",\"Le Chef d'étabissement, \",\"La Cheffe d'établissement, \")&Gestionnaires!C5&\" \"&UPPER(Gestionnaires!C4)","v":"La Cheffe d'établissement,  "}]

{"sheet":"Compte scindé RR3","index":27,"n_rows":33,"n_cols":18,"rows_kept":33,"cut":false,"hidden":false,"merged":[[37,0,37,8],[37,9,37,16],[15,1,15,2],[30,0,30,8],[30,9,30,16],[31,0,31,8],[31,9,31,16],[32,0,32,8],[32,9,32,16],[14,1,14,2],[3,10,3,14],[3,15,4,15],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[10,17,12,17],[0,0,0,8],[0,9,0,16],[1,1,1,2],[1,6,1,7],[2,0,3,0],[2,3,2,9],[2,10,2,15],[3,1,3,2],[3,3,3,8],[3,9,4,9]]}
[{"$f":" \"Compte scindé de \"&LOOKUP(\"X\",Identification!B2:B344,Identification!D2:D344)&\" - Année \"&RIGHT(TEXT(Gestionnaires!C12,\"jj/mm/aaaa\"),4)&\" - Sortie de \"&PROPER(Gestionnaires!L8)&\" \"&Gestionnaires!L10&\" \"&UPPER(Gestionnaires!L9)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,{"$f":"A1","v":{"$error":"#N/A"}}]
[1,2,null,3,4,5,6,null,7,8,9,10,11,12,13,15,15]
["COMPTES",null,null,"RECETTES",null,null,null,null,null,null,"DEPENSES"]
[null,"SOLDE AU 31/12\nDE L'ANNEE PRECEDENTE",null,"RECETTES DE L'ANNEE EN COURS",null,null,null,null,null,"TOTAL GENERAL DES RECETTES","DEPENSES DE L'ANNEE EN COURS",null,null,null,null,"TOTAL GENERAL DES DEPENSES",{"$f":"\"A justifier au \"&TEXT(Gestionnaires!L12,\"jj/mm/aaaa\")","v":"A justifier au 00/01/1900"}]
[null,null,null,"Du 1er janvier au 2 mai","Du 3 mai au 3 juin","Du 4 juin au 30 juin","NA","NA","Total des colonnes 3 à 7",null,{"$f":"D5","v":"Du 1er janvier au 2 mai"},{"$f":"E5","v":"Du 3 mai au 3 juin"},"Du 4 juin au 30 juin","NA","NA",null,"COL 6-9"]
["CPTE CAISSE",{"$f":"Reports!D4","v":0},null,1532.4,7404.33,3136.2,0,0,{"$f":"SUM(D6:H6)","v":12072.93},{"$f":"B6+I6","v":12072.93},0,7687.03,0,0,0,{"$f":"SUM(K6:O6)","v":7687.03},{"$f":"(J6-P6)","v":4385.9000000000005}]
["CPTE COURANT",{"$f":"Reports!D5","v":0},null,254.3,99915.32,10525.38,0,0,{"$f":"SUM(D7:H7)","v":110695.00000000001},{"$f":"B7+I7","v":110695.00000000001},15044.73,85029.7,0,0,0,{"$f":"SUM(K7:O7)","v":100074.43},10620.570000000022]
["CPTE PLAC. N°1",{"$f":"Reports!D6","v":0},null,70.180000000000007,58.52,0,0,0,128.70000000000002,128.70000000000002,0,0,0,0,0,0,128.70000000000002]
["CPTE PLAC. N°2",{"$f":"Reports!D7","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["CPTE PLAC. N°3",{"$f":"Reports!D8","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["CPTE PLAC. N°4",{"$f":"Reports!D9","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Avoir en caisse = \nTotaux financiers\n- Déficit"]
["CPTE PLAC. N°5",{"$f":"Reports!D10","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["PV DE DEFICIT",{"$f":"Reports!D11","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["SOUS-TOTAL",{"$f":"Reports!D12","v":0},null,1856.88,107378.17,13661.58,0,0,122896.63,122896.63,15044.73,92716.73,0,0,0,107761.45999999999,15135.170000000013,{"$f":"Q14","v":15135.170000000013}]
["MOUV. DE FONDS",{"$f":"Reports!D13","v":0},null,0,7689.46,4387.03,0,0,12076.49,12076.49,0,7689.46,0,0,0,7689.46,4387.03,{"$f":"\"(-)\"&Q13","v":"(-)0"}]
["TOTAL",{"$f":"Reports!D14","v":0},null,1856.88,99688.71,9274.5499999999993,0,0,110820.14000000001,110820.14000000001,15044.73,85027.27,0,0,0,100072,10748.140000000014,{"$f":"Q16-Q13","v":10748.140000000014}]
["OP. COURANTES","2A","2B"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
["INTENDANCE",{"$f":"Reports!C16","v":0},{"$f":"Reports!D16","v":0},1647.2,7678.3,3530.3,0,0,12855.8,{"$f":"C18+I18","v":12855.8},1382.9,6074.1,0,0,0,7457,{"$f":"(J18-P18)","v":5398.7999999999993}]
["FONCTIONNEMENT",{"$f":"Reports!C17","v":0},{"$f":"Reports!D17","v":0},209.68,92010.41,5744.25,0,0,97964.34,{"$f":"C19+I19","v":97964.34},12695.04,78374.179999999993,0,0,0,91069.22,{"$f":"(J19-P19)","v":6895.1199999999953}]
["RESERVE",{"$f":"Reports!C18","v":0},{"$f":"Reports!D18","v":0},0,0,0,0,0,0,{"$f":"C20+I20","v":0},0,0,0,0,0,0,{"$f":"(J20-P20)","v":0}]
["TOTAL",{"$f":"Reports!C19","v":0},{"$f":"Reports!D19","v":0},1856.88,99688.71,9274.5499999999993,0,0,110820.14000000001,{"$f":"C21+I21","v":110820.14000000001},14077.94,84448.28,0,0,0,98526.22,{"$f":"(J21-P21)","v":12293.920000000013}]
["OP. DE CAPITAL",{"$f":"Reports!C20","v":0},{"$f":"Reports!D20","v":0},10000,0,-10000,0,0,0,{"$f":"C22+I22","v":0},966.79,578.99,0,0,0,1545.78,{"$f":"(J22-P22)","v":-1545.78}]
["OP. POUR ORDRE"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
["TIERS",{"$f":"Reports!C22","v":0},{"$f":"Reports!D22","v":0},0,0,0,0,0,0,{"$f":"C24+I24","v":0},0,0,0,0,0,0,{"$f":"(J24-P24)","v":0}]
["TRESOR",{"$f":"Reports!C23","v":0},{"$f":"Reports!D23","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(J25-P25)","v":0}]
["TOTAL",{"$f":"Reports!C24","v":0},{"$f":"Reports!D24","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(J26-P26)","v":0}]
["SOUS-TOTAL",{"$f":"Reports!C25","v":0},{"$f":"Reports!D25","v":0},11856.88,99688.71,-725.45,0,0,110820.14000000001,110820.14000000001,15044.73,85027.27,0,0,0,100072,{"$f":"(J27-P27)","v":10748.140000000014}]
["TRANSFERT",{"$f":"Reports!C26","v":0},{"$f":"Reports!D26","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["TOTAL GENERAL",{"$f":"Reports!C27","v":0},{"$f":"Reports!D27","v":0},11856.88,99688.71,-725.45,0,0,110820.14000000001,110820.14000000001,15044.73,85027.27,0,0,0,100072,{"$f":"(J29-P29)","v":10748.140000000014}]
[]
["CERTIFIE CONFORME AUX ECRITURES",null,null,null,null,null,null,null,null,"VU ET APPROUVE"]
[{"$f":"\"Fait à \"&LOOKUP(\"X\",Identification!B2:B344,Identification!G2:G344)&\", le \"&TEXT(Gestionnaires!L12,\"jj/mm/aaaa\")","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,{"$f":"A32","v":{"$error":"#N/A"}}]
[{"$f":"IF(Gestionnaires!F8=\"Monsieur\",\"Le comptable sortant \",\"La comptable sortante \")&\", \"&Gestionnaires!L10&\" \"&UPPER(Gestionnaires!L9)","v":"La comptable sortante ,  "},null,null,null,null,null,null,null,null,{"$f":"IF(Gestionnaires!C2=\"Monsieur\",\"Le Chef d'étabissement, \",\"La Cheffe d'établissement, \")&Gestionnaires!C5&\" \"&UPPER(Gestionnaires!C4)","v":"La Cheffe d'établissement,  "}]

{"sheet":"Contenu listes","index":28,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Civilité","Titre"]
["Monsieur","Préfet"]
["Monsieur","Directeur"]
["Monsieur","Administrateur"]
["Madame","Préfète"]
["Madame","Directrice"]
["Madame","Administratrice"]
["Mademoiselle","Préfète"]
["Mademoiselle","Directrice"]
["Mademoiselle","Administratrice"]
[]
[]
[]
["Monsieur","Madame","Mademoiselle",null,null,"Monsieur"]
["Préfet","Préfète","Préfète"]
["Directeur","Directrice","Directrice"]
["Administrateur","Administratrice","Administratrice"]