{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["TSBCE","OPTAB","OPTAD","PrepTab1","Tab1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"TSBCE","index":0,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[[12,4,12,5],[23,2,26,3],[19,2,21,3],[18,2,18,3],[22,2,22,3],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,2,16,3],[5,1,5,5],[0,1,0,7],[1,1,1,7],[2,1,2,7],[3,1,3,7],[4,1,4,7],[6,1,11,1],[6,2,6,3],[6,4,6,5],[7,2,7,3],[7,4,7,5],[8,2,8,3],[8,4,8,5],[9,2,9,3],[9,4,9,5],[10,4,10,5],[10,2,11,2],[11,4,11,5],[32,4,32,5],[16,4,16,5],[17,2,17,7],[27,2,27,3],[27,4,27,5],[28,4,28,5],[28,2,28,3],[31,4,31,5],[30,2,31,2],[29,2,29,3],[30,4,30,5],[29,4,29,5],[35,4,35,5],[36,2,36,3],[47,1,47,3],[45,1,45,3],[46,1,46,3],[38,2,39,2],[41,1,41,3],[42,1,42,3],[43,1,43,3],[44,1,44,3],[36,4,36,5],[37,2,37,3],[37,4,37,5],[38,4,38,5],[39,4,39,5],[48,1,48,3],[33,2,33,3],[34,1,39,1],[34,2,34,3],[35,2,35,3],[12,1,33,1],[13,2,13,3],[14,2,14,3],[15,2,15,3],[32,2,32,3],[12,2,12,3]]}
[]
[null,"Synthèse budgétaire et comptable"]
[]
[null,"POUR INFORMATION DE L'ORGANE DÉLIBÉRANT"]
[]
[null,null,null,null,null,null,"BI n","CF n"]
[null,"Niveaux initiaux",1,null,"Niveau initial de restes à payer nets des retraits d'engagements juridiques sur exercices antérieurs à N"]
[null,null,2,null,"Niveau initial du fonds de roulement"]
[null,null,3,null,"Niveau initial du besoin en fonds de roulement",null,{"$f":"G8-G10","v":0},{"$f":"H8-H10","v":0}]
[null,null,4,null,"Niveau initial de la trésorerie"]
[null,null,null,"4.a","dont niveau initial de la trésorerie fléchée"]
[null,null,null,"4.b","dont niveau initial de la trésorerie non fléchée",null,{"$f":"G10-G11","v":0},{"$f":"H10-H11","v":0}]
[null,"Flux de l'année",5,null,"Autorisations d'engagement"]
[null,null,6,null,"Résultat patrimonial"]
[null,null,7,null,"Capacité d'autofinancement (CAF)"]
[null,null,8,null,"Variation du fonds de roulement"]
[null,null,9,null,"Opérations sur dettes financières, capitaux propres et créances immobilisées sans impact budgétaire "]
[]
[null,null,10,"9.a","Opérations du compte de résultat sans flux de trésorerie, non retraitées par la CAF","SENS",{"$f":"SUM(G20:G22)","v":0},{"$f":"SUM(H20:H22)","v":0}]
[null,null,null,null,"Variation des stocks","+ / -"]
[null,null,null,null,"Charges sur créances irrécouvrables","-"]
[null,null,null,null,"Produits divers de gestion courante","+"]
[null,null,11,"9.b","Opérations budgétaires et comptables avec différence de fait générateur de trésorerie","SENS",{"$f":"SUM(G24:G27)","v":0},{"$f":"SUM(H24:H27)","v":0}]
[null,null,null,null,"Ecart entre les produits / ressources et les encaissements relatifs à des opérations sur exercices antérieurs","+ / -"]
[null,null,null,null,"Ecart entre les produits / ressources et les encaissements relatifs à des opérations de l'exercice en cours","+ / -"]
[null,null,null,null,"Ecart entre les charges / immobilisations et les décaissements relatifs à des opérations sur exercices antérieurs","+ / -"]
[null,null,null,null,"Ecart entre les charges / immobilisations et les décaissements relatifs à des opérations de l'exercice en cours","+ / -"]
[null,null,12,null,"Solde budgétaire = 8 - 9 - 10 - 11",null,{"$f":"G16-G17-G19-G23","v":0},{"$f":"H16-H17-H19-H23","v":0}]
[null,null,13,"9.c","Décalage de flux de trésorerie liés aux opérations de trésorerie non budgétaires"]
[null,null,14,null,"Variation de la trésorerie = 12 - 13",null,{"$f":"G28-G29","v":0},{"$f":"H28-H29","v":0}]
[null,null,null,"14.a","dont variation de la trésorerie fléchée"]
[null,null,null,"14.b","dont variation de la trésorerie non fléchée"]
[null,null,15,null,"Variations du besoin en fonds de roulement = 9 + 10 + 11 + 13",null,{"$f":"G17+G19+G23+G29","v":0},{"$f":"H17+H19+H23+H29","v":0}]
[null,null,16,null,"Variation des restes à payer"]
[null,"Niveaux finaux",17,null,"Niveau final de restes à payer",null,{"$f":"G7+G34","v":0},{"$f":"H7+H34","v":0}]
[null,null,18,null,"Niveau final du fonds de roulement",null,{"$f":"G8+G16","v":0},{"$f":"H8+H16","v":0}]
[null,null,19,null,"Niveau final du besoin en fonds de roulement",null,{"$f":"G36-G38","v":0},{"$f":"H36-H38","v":0}]
[null,null,20,null,"Niveau final de la trésorerie",null,{"$f":"G10+G30","v":0},0]
[null,null,null,"20.a","dont niveau final de la trésorerie fléchée",null,0,0]
[null,null,null,"20.b","dont niveau final de la trésorerie non fléchée",null,0,0]
[]
[null,"Identifiant de l'établissement",null,null,"0000000000",{"$f":"IF(LEN(E42)<>10,\"ERREUR\",\"\")","v":""}]
[null,"Type de document",null,null,"02",{"$f":"IF(LEN(E43)<>2,\"ERREUR\",\"\")","v":""}]
[null,"Code nomenclature",null,null,"01",{"$f":"IF(LEN(E44)<>2,\"ERREUR\",\"\")","v":""}]
[null,"Année comptable",null,null,"2015",{"$f":"IF(LEN(E45)<>4,\"ERREUR\",\"\")","v":""}]
[null,"Rang de la balance",null,null,"06",{"$f":"IF(LEN(E46)<>2,\"ERREUR\",\"\")","v":""}]
[null,"Date d'arrêté",null,null,"01012015",{"$f":"IF(LEN(E47)<>8,\"ERREUR\",\"\")","v":""}]
[null,"SIRET",null,null,"XXXXXXXXXXXXXX",{"$f":"IF(LEN(E48)<>14,\"ERREUR\",\"\")","v":""}]
[null,"Etablissement",null,null,"XXXXXX"]

{"sheet":"OPTAB","index":1,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["svcoptab","cosoptab","etsoptab","exeoptab","docoptab","cadoptab","envoptab"]
["INF-TSBCP","TSBCP",{"$f":"TSBCE!E49","v":"XXXXXX"},{"$f":"TSBCE!E45","v":"2015"},{"$f":"TSBCE!E43","v":"02"},"00","N"]

{"sheet":"OPTAD","index":2,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["seqoptad","coloptad","mntoptad"]
[10,"01",{"$f":"TSBCE!G7","v":0}]
[20,"02",{"$f":"TSBCE!G8","v":0}]
[30,"03",{"$f":"TSBCE!G9","v":0}]
[40,"04",{"$f":"TSBCE!G10","v":0}]
[50,"05",{"$f":"TSBCE!G11","v":0}]
[60,"06",{"$f":"TSBCE!G12","v":0}]
[70,"07",{"$f":"TSBCE!G13","v":0}]
[80,"08",{"$f":"TSBCE!G14","v":0}]
[90,"09",{"$f":"TSBCE!G15","v":0}]
[100,"10",{"$f":"TSBCE!G16","v":0}]
[110,"11",{"$f":"TSBCE!G17","v":0}]
[120,"12",{"$f":"TSBCE!G19","v":0}]
[130,"13",{"$f":"TSBCE!G20","v":0}]
[140,"14",{"$f":"TSBCE!G21","v":0}]
[150,"15",{"$f":"TSBCE!G22","v":0}]
[160,"16",{"$f":"TSBCE!G23","v":0}]
[170,"17",{"$f":"TSBCE!G24","v":0}]
[180,"18",{"$f":"TSBCE!G25","v":0}]
[190,"19",{"$f":"TSBCE!G26","v":0}]
[200,"20",{"$f":"TSBCE!G27","v":0}]
[210,"21",{"$f":"TSBCE!G28","v":0}]
[220,"22",{"$f":"TSBCE!G29","v":0}]
[230,"23",{"$f":"TSBCE!G30","v":0}]
[240,"24",{"$f":"TSBCE!G31","v":0}]
[250,"25",{"$f":"TSBCE!G32","v":0}]
[260,"26",{"$f":"TSBCE!G33","v":0}]
[270,"27",{"$f":"TSBCE!G34","v":0}]
[280,"28",{"$f":"TSBCE!G35","v":0}]
[290,"29",{"$f":"TSBCE!G36","v":0}]
[300,"30",{"$f":"TSBCE!G37","v":0}]
[310,"31",{"$f":"TSBCE!G38","v":0}]
[320,"32",{"$f":"TSBCE!G39","v":0}]
[330,"33",{"$f":"TSBCE!G40","v":0}]

{"sheet":"PrepTab1","index":3,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
["Code fichier : ",{"$f":"+CONCATENATE(\"TSBCE_\",TSBCE!E42,\"_\",TSBCE!E43,\"_01_\",TSBCE!E45,\"_\",TSBCE!E46,\".txt\")","v":"TSBCE_0000000000_02_01_2015_06.txt"}]
[]
[100001,null,null,null,{"$f":"+CONCATENATE(A3,TSBCE!E42,TSBCE!E43,TSBCE!E44,\"01\",TSBCE!E45,TSBCE!E46,TSBCE!E47,LEFT(TSBCE!E48,9),TSBCE!E48)","v":"100001000000000002010120150601012015XXXXXXXXXXXXXXXXXXXXXXX"}]
[200002,"01",{"$f":"+TSBCE!H7","v":0},{"$f":"IF(C4>=0,CONCATENATE(\"+\",+TEXT(C4*100,\"00000000000000\")),CONCATENATE(\"\",+TEXT(C4*100,\"00000000000000\")))","v":"+00000000000000"},{"$f":"+CONCATENATE(A4,B4,D4,REPT(\" \",59-LEN(CONCATENATE(A4,B4,D4))))","v":"20000201+00000000000000                                    "}]
[200003,"02",{"$f":"+TSBCE!H8","v":0},"+00000000000000","20000302+00000000000000                                    "]
[200004,"03",{"$f":"+TSBCE!H9","v":0},"+00000000000000","20000403+00000000000000                                    "]
[200005,"04",{"$f":"+TSBCE!H10","v":0},"+00000000000000","20000504+00000000000000                                    "]
[200006,"05",{"$f":"+TSBCE!H11","v":0},"+00000000000000","20000605+00000000000000                                    "]
[200007,"06",{"$f":"+TSBCE!H12","v":0},"+00000000000000","20000706+00000000000000                                    "]
[200008,"07",{"$f":"+TSBCE!H13","v":0},"+00000000000000","20000807+00000000000000                                    "]
[200009,"08",{"$f":"+TSBCE!H14","v":0},"+00000000000000","20000908+00000000000000                                    "]
[200010,"09",{"$f":"+TSBCE!H15","v":0},"+00000000000000","20001009+00000000000000                                    "]
[200011,"10",{"$f":"+TSBCE!H16","v":0},"+00000000000000","20001110+00000000000000                                    "]
[200012,"11",{"$f":"+TSBCE!H17","v":0},"+00000000000000","20001211+00000000000000                                    "]
[200013,"12",{"$f":"+TSBCE!H19","v":0},"+00000000000000","20001312+00000000000000                                    "]
[200014,"13",{"$f":"+TSBCE!H20","v":0},"+00000000000000","20001413+00000000000000                                    "]
[200015,"14",{"$f":"+TSBCE!H21","v":0},"+00000000000000","20001514+00000000000000                                    "]
[200016,"15",{"$f":"+TSBCE!H22","v":0},"+00000000000000","20001615+00000000000000                                    "]
[200017,"16",{"$f":"+TSBCE!H23","v":0},"+00000000000000","20001716+00000000000000                                    "]
[200018,"17",{"$f":"+TSBCE!H24","v":0},"+00000000000000","20001817+00000000000000                                    "]
[200019,"18",{"$f":"+TSBCE!H25","v":0},"+00000000000000","20001918+00000000000000                                    "]
[200020,"19",{"$f":"+TSBCE!H26","v":0},"+00000000000000","20002019+00000000000000                                    "]
[200021,"20",{"$f":"+TSBCE!H27","v":0},"+00000000000000","20002120+00000000000000                                    "]
[200022,"21",{"$f":"+TSBCE!H28","v":0},"+00000000000000","20002221+00000000000000                                    "]
[200023,"22",{"$f":"+TSBCE!H29","v":0},"+00000000000000","20002322+00000000000000                                    "]
[200024,"23",{"$f":"+TSBCE!H30","v":0},"+00000000000000","20002423+00000000000000                                    "]
[200025,"24",{"$f":"+TSBCE!H31","v":0},"+00000000000000","20002524+00000000000000                                    "]
[200026,"25",{"$f":"+TSBCE!H32","v":0},"+00000000000000","20002625+00000000000000                                    "]
[200027,"26",{"$f":"+TSBCE!H33","v":0},"+00000000000000","20002726+00000000000000                                    "]
[200028,"27",{"$f":"+TSBCE!H34","v":0},"+00000000000000","20002827+00000000000000                                    "]
[200029,"28",{"$f":"+TSBCE!H35","v":0},{"$f":"IF(C31>=0,CONCATENATE(\"+\",+TEXT(C31*100,\"00000000000000\")),CONCATENATE(\"\",+TEXT(C31*100,\"00000000000000\")))","v":"+00000000000000"},{"$f":"+CONCATENATE(A31,B31,D31,REPT(\" \",59-LEN(CONCATENATE(A31,B31,D31))))","v":"20002928+00000000000000                                    "}]
[200030,"29",{"$f":"+TSBCE!H36","v":0},"+00000000000000","20003029+00000000000000                                    "]
[200031,"30",{"$f":"+TSBCE!H37","v":0},"+00000000000000","20003130+00000000000000                                    "]
[200032,"31",{"$f":"+TSBCE!H38","v":0},"+00000000000000","20003231+00000000000000                                    "]
[200033,"32",{"$f":"+TSBCE!H39","v":0},"+00000000000000","20003332+00000000000000                                    "]
[200034,"33",{"$f":"+TSBCE!H40","v":0},"+00000000000000","20003433+00000000000000                                    "]
[900035,null,null,null,{"$f":"+CONCATENATE(A37,REPT(\" \",59-LEN(A37)))","v":"900035                                                     "}]

{"sheet":"Tab1","index":4,"n_rows":35,"n_cols":1,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
[{"$f":"+PrepTab1!E3","v":"100001000000000002010120150601012015XXXXXXXXXXXXXXXXXXXXXXX"}]
[{"$f":"+PrepTab1!E4","v":"20000201+00000000000000                                    "}]
[{"$f":"+PrepTab1!E5","v":"20000302+00000000000000                                    "}]
[{"$f":"+PrepTab1!E6","v":"20000403+00000000000000                                    "}]
[{"$f":"+PrepTab1!E7","v":"20000504+00000000000000                                    "}]
[{"$f":"+PrepTab1!E8","v":"20000605+00000000000000                                    "}]
[{"$f":"+PrepTab1!E9","v":"20000706+00000000000000                                    "}]
[{"$f":"+PrepTab1!E10","v":"20000807+00000000000000                                    "}]
[{"$f":"+PrepTab1!E11","v":"20000908+00000000000000                                    "}]
[{"$f":"+PrepTab1!E12","v":"20001009+00000000000000                                    "}]
[{"$f":"+PrepTab1!E13","v":"20001110+00000000000000                                    "}]
[{"$f":"+PrepTab1!E14","v":"20001211+00000000000000                                    "}]
[{"$f":"+PrepTab1!E15","v":"20001312+00000000000000                                    "}]
[{"$f":"+PrepTab1!E16","v":"20001413+00000000000000                                    "}]
[{"$f":"+PrepTab1!E17","v":"20001514+00000000000000                                    "}]
[{"$f":"+PrepTab1!E18","v":"20001615+00000000000000                                    "}]
[{"$f":"+PrepTab1!E19","v":"20001716+00000000000000                                    "}]
[{"$f":"+PrepTab1!E20","v":"20001817+00000000000000                                    "}]
[{"$f":"+PrepTab1!E21","v":"20001918+00000000000000                                    "}]
[{"$f":"+PrepTab1!E22","v":"20002019+00000000000000                                    "}]
[{"$f":"+PrepTab1!E23","v":"20002120+00000000000000                                    "}]
[{"$f":"+PrepTab1!E24","v":"20002221+00000000000000                                    "}]
[{"$f":"+PrepTab1!E25","v":"20002322+00000000000000                                    "}]
[{"$f":"+PrepTab1!E26","v":"20002423+00000000000000                                    "}]
[{"$f":"+PrepTab1!E27","v":"20002524+00000000000000                                    "}]
[{"$f":"+PrepTab1!E28","v":"20002625+00000000000000                                    "}]
[{"$f":"+PrepTab1!E29","v":"20002726+00000000000000                                    "}]
[{"$f":"+PrepTab1!E30","v":"20002827+00000000000000                                    "}]
[{"$f":"+PrepTab1!E31","v":"20002928+00000000000000                                    "}]
[{"$f":"+PrepTab1!E32","v":"20003029+00000000000000                                    "}]
[{"$f":"+PrepTab1!E33","v":"20003130+00000000000000                                    "}]
[{"$f":"+PrepTab1!E34","v":"20003231+00000000000000                                    "}]
[{"$f":"+PrepTab1!E35","v":"20003332+00000000000000                                    "}]
[{"$f":"+PrepTab1!E36","v":"20003433+00000000000000                                    "}]
[{"$f":"+PrepTab1!E37","v":"900035                                                     "}]