{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Situation patrimoniale","Pdf1","Pdf2","Pdf3","Pdf4","Fonds de roulement","PrFicTab5","FicTab5","Donnees","PrepTab1","Tab1","PrepTab2","Tab2","PrepTab3","Tab3","PrepTab4","Tab4"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":3,"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":"Situation patrimoniale","index":0,"n_rows":58,"n_cols":5,"rows_kept":58,"cut":false,"hidden":false,"merged":[[45,1,45,4],[54,1,54,3],[55,1,55,3],[49,1,49,3],[50,1,50,3],[51,1,51,3],[52,1,52,3],[53,1,53,3],[1,1,1,4],[6,1,6,4],[2,1,2,4],[37,2,39,2],[37,1,39,1],[4,1,4,4],[33,1,33,2]]}
[" ",null,null,null,{"$f":"CONCATENATE(\"Edité au : \",Donnees!F4)","v":"Edité au : 02/05/2019"}]
[null,{"$f":"+Donnees!C1","v":"Qualiac développement"}]
[null,"Tableau 2"]
[]
[null,"COMPTE DE RÉSULTAT ET ÉTAT DE L'ÉVOLUTION DE LA SITUATION PATRIMONIALE EN DROITS CONSTATÉS"]
[]
[null,"POUR VOTE DE L'ORGANE DÉLIBÉRANT"]
[]
[null,"COMPTE DE RÉSULTAT PRÉVISIONNEL/EXÉCUTÉ"]
[]
[null,"CHARGES",{"$f":"CONCATENATE(Donnees!W6,CHAR(10),Donnees!E1)","v":"V3\n2018"},"PRODUITS",{"$f":"CONCATENATE(Donnees!W6,CHAR(10),Donnees!E1)","v":"V3\n2018"}]
[null,"Personnel",{"$f":"SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$F$6:$F$1000000,\"SPCRC1\",Donnees!$B$6:$B$1000000,\"B1\")-SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$F$6:$F$1000000,\"SPCRC1\",Donnees!$B$6:$B$1000000,\"B1\")","v":530580},"Subventions de l'Etat",{"$f":"-SUM(SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$F$6:$F$1000000,\"SPCRP1\",Donnees!$B$6:$B$1000000,\"B1\"))+SUM(SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$F$6:$F$1000000,\"SPCRP1\",Donnees!$B$6:$B$1000000,\"B1\"))","v":324000}]
[null,"dont charges de pensions civiles",{"$f":"SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$H$6:$H$1000000,\"6453\",Donnees!$B$6:$B$1000000,\"B1\")-SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$H$6:$H$1000000,\"6453\",Donnees!$B$6:$B$1000000,\"B1\")","v":0},"Fiscalité affectée",{"$f":"-SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$F$6:$F$1000000,\"SPCRP2\",Donnees!$B$6:$B$1000000,\"B1\")+SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$F$6:$F$1000000,\"SPCRP2\",Donnees!$B$6:$B$1000000,\"B1\")","v":0}]
[null,"Fonctionnement autre que les charges de personnel",{"$f":"SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$F$6:$F$1000000,\"SPCRC2\",Donnees!$B$6:$B$1000000,\"B1\")-SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$F$6:$F$1000000,\"SPCRC2\",Donnees!$B$6:$B$1000000,\"B1\")","v":960049.29},"Autres subventions",{"$f":"-SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$F$6:$F$1000000,\"SPCRP3\",Donnees!$B$6:$B$1000000,\"B1\")+SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$F$6:$F$1000000,\"SPCRP3\",Donnees!$B$6:$B$1000000,\"B1\")","v":648000}]
[null,"Intervention (le cas échéant)",{"$f":"SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$F$6:$F$1000000,\"SPCRC3\",Donnees!$B$6:$B$1000000,\"B1\")-SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$F$6:$F$1000000,\"SPCRC3\",Donnees!$B$6:$B$1000000,\"B1\")","v":105000},"Autres produits",{"$f":"-SUM(SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$F$6:$F$1000000,\"SPCRP4\",Donnees!$B$6:$B$1000000,\"B1\"))+SUM(SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$F$6:$F$1000000,\"SPCRP4\",Donnees!$B$6:$B$1000000,\"B1\"))","v":754683.67}]
[null,"TOTAL DES CHARGES (1)",{"$f":"SUM(C12,C14,C15)","v":1595629.29},"TOTAL DES PRODUITS (2)",{"$f":"SUM(E12:E15)","v":1726683.67}]
[null,"Résultat : bénéfice (3) = (2) - (1)",{"$f":"IF(E16>C16,E16-C16,0)","v":131054.37999999989},"Résultat : perte (4) = (1) - (2)",{"$f":"IF(C16>E16,C16-E16,0)","v":0}]
[null,"TOTAL EQUILIBRE du compte de résultat\n(1) + (3) = (2) + (4)",{"$f":"SUM(C16:C17)","v":1726683.67},"TOTAL EQUILIBRE du compte de résultat\n(1) + (3) = (2) + (4)",{"$f":"SUM(E16:E17)","v":1726683.67}]
[]
[]
[null,"CALCUL DE LA CAPACITÉ D'AUTOFINANCEMENT"]
[]
[null,null,{"$f":"CONCATENATE(Donnees!W6,CHAR(10),Donnees!E1)","v":"V3\n2018"}]
[null,"Résultat de l'exercice (bénéfice (3) ou perte (-4))",{"$f":"C17-E17","v":131054.37999999989}]
[null,"+ Dotations aux amortissements, dépréciations et provisions",{"$f":"SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$G$6:$G$1000000,\"681\",Donnees!$B$6:$B$1000000,\"B1\")-SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$G$6:$G$1000000,\"681\",Donnees!$B$6:$B$1000000,\"B1\")+SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$G$6:$G$1000000,\"684\",Donnees!$B$6:$B$1000000,\"B1\")-SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$G$6:$G$1000000,\"684\",Donnees!$B$6:$B$1000000,\"B1\")+SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$G$6:$G$1000000,\"686\",Donnees!$B$6:$B$1000000,\"B1\")-SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$G$6:$G$1000000,\"686\",Donnees!$B$6:$B$1000000,\"B1\")+IF(Donnees!AI6=\"O\",SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$G$6:$G$1000000,\"603\",Donnees!$B$6:$B$1000000,\"B1\")-SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$G$6:$G$1000000,\"603\",Donnees!$B$6:$B$1000000,\"B1\"),0)","v":324663.41000000003}]
[null,"- reprises sur amortissements, dépréciations et provisions",{"$f":"SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$G$6:$G$1000000,\"781\",Donnees!$B$6:$B$1000000,\"B1\")-SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$G$6:$G$1000000,\"781\",Donnees!$B$6:$B$1000000,\"B1\")+SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$G$6:$G$1000000,\"784\",Donnees!$B$6:$B$1000000,\"B1\")-SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$G$6:$G$1000000,\"784\",Donnees!$B$6:$B$1000000,\"B1\")+SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$G$6:$G$1000000,\"786\",Donnees!$B$6:$B$1000000,\"B1\")-SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$G$6:$G$1000000,\"786\",Donnees!$B$6:$B$1000000,\"B1\")","v":96000}]
[null,"+ valeur nette comptable des éléments d'actifs cédés",{"$f":"SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$G$6:$G$1000000,\"656\",Donnees!$B$6:$B$1000000,\"B1\")-SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$G$6:$G$1000000,\"656\",Donnees!$B$6:$B$1000000,\"B1\")+SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$H$6:$H$1000000,\"6577\",Donnees!$B$6:$B$1000000,\"B1\")-SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$H$6:$H$1000000,\"6577\",Donnees!$B$6:$B$1000000,\"B1\")+SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$H$6:$H$1000000,\"6672\",Donnees!$B$6:$B$1000000,\"B1\")-SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$H$6:$H$1000000,\"6672\",Donnees!$B$6:$B$1000000,\"B1\")","v":38000}]
[null,"- produits de cession d'éléments d'actifs ",{"$f":"SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$G$6:$G$1000000,\"756\",Donnees!$B$6:$B$1000000,\"B1\")-SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$G$6:$G$1000000,\"756\",Donnees!$B$6:$B$1000000,\"B1\")+SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$H$6:$H$1000000,\"7577\",Donnees!$B$6:$B$1000000,\"B1\")-SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$H$6:$H$1000000,\"7577\",Donnees!$B$6:$B$1000000,\"B1\")+SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$H$6:$H$1000000,\"7672\",Donnees!$B$6:$B$1000000,\"B1\")-SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$H$6:$H$1000000,\"7672\",Donnees!$B$6:$B$1000000,\"B1\")","v":150000}]
[null,"- quote-part reprise au résultat des financements rattachés à des actifs",{"$f":"SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$G$6:$G$1000000,\"7813\",Donnees!$B$6:$B$1000000,\"B1\")-SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$G$6:$G$1000000,\"7813\",Donnees!$B$6:$B$1000000,\"B1\")+SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$G$6:$G$1000000,\"7863\",Donnees!$B$6:$B$1000000,\"B1\")-SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$G$6:$G$1000000,\"7863\",Donnees!$B$6:$B$1000000,\"B1\")","v":11000}]
[null,"= CAF ou IAF*",{"$f":"(C24+C25-C26+C27-C28-C29)","v":236717.78999999992}]
[null,"*capacité d'autofinancement ou d'insuffisance d'autofinancement"]
[]
[]
[null,"ÉTAT PRÉVISIONNEL/EXÉCUTÉ DE L'ÉVOLUTION DE LA SITUATION PATRIMONIALE EN DROITS CONSTATÉS"]
[]
[null,"EMPLOIS",{"$f":"CONCATENATE(Donnees!W6,CHAR(10),Donnees!E1)","v":"V3\n2018"},"RESSOURCES",{"$f":"CONCATENATE(Donnees!W6,CHAR(10),Donnees!E1)","v":"V3\n2018"}]
[null,"Insuffisance d'autofinancement",{"$f":"+IF(C30<0,-C30,0)","v":0},"Capacité d'autofinancement",{"$f":"+IF(C30>0,C30,0)","v":236717.78999999992}]
[null,"Investissements",{"$f":"SUM(SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$F$6:$F$1000000,\"SPERE1\",Donnees!$B$6:$B$1000000,\"B1\"))-SUM(SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$F$6:$F$1000000,\"SPERE1\",Donnees!$B$6:$B$1000000,\"B1\"))","v":952720},"Financement de l'actif par l'État",{"$f":"-SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$F$6:$F$1000000,\"SPERR1\",Donnees!$B$6:$B$1000000,\"B1\")+SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$F$6:$F$1000000,\"SPERR1\",Donnees!$B$6:$B$1000000,\"B1\")","v":400000}]
[null,null,null,"Financement de l'actif par des tiers autres que l'État",{"$f":"-SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$F$6:$F$1000000,\"SPERR2\",Donnees!$B$6:$B$1000000,\"B1\")+SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$F$6:$F$1000000,\"SPERR2\",Donnees!$B$6:$B$1000000,\"B1\")","v":116000}]
[null,null,null,"Autres ressources",{"$f":"-SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$F$6:$F$1000000,\"SPERR3\",Donnees!$B$6:$B$1000000,\"B1\")\n+SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$F$6:$F$1000000,\"SPERR3\",Donnees!$B$6:$B$1000000,\"B1\")\n+SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$G$6:$G$1000000,\"756\",Donnees!$B$6:$B$1000000,\"B1\")\n+SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$H$6:$H$1000000,\"7577\",Donnees!$B$6:$B$1000000,\"B1\")\n+SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$H$6:$H$1000000,\"7672\",Donnees!$B$6:$B$1000000,\"B1\")\n+SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$H$6:$H$1000000,\"6672\",Donnees!$B$6:$B$1000000,\"B1\")","v":150000}]
[null,"Remboursement des dettes financières",{"$f":"SUM(SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$F$6:$F$1000000,\"SPERE2\",Donnees!$B$6:$B$1000000,\"B1\"))-SUM(SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$F$6:$F$1000000,\"SPERE2\",Donnees!$B$6:$B$1000000,\"B1\"))","v":48000},"Augmentation des dettes financières",{"$f":"SUM(SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$F$6:$F$1000000,\"SPERR4\",Donnees!$B$6:$B$1000000,\"B1\"))-SUM(SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$F$6:$F$1000000,\"SPERR4\",Donnees!$B$6:$B$1000000,\"B1\"))","v":108000}]
[null,"TOTAL DES EMPLOIS (5)",{"$f":"SUM(C37:C41)","v":1000720},"TOTAL DES RESSOURCES (6)",{"$f":"SUM(E37:E41)","v":1010717.7899999999}]
[null,"Augmentation du fonds de roulement (7) = (6)-(5)",{"$f":"IF(E42>C42,E42-C42,0)","v":9997.7899999999208},"Diminution du fonds de roulement  (8) = (5)-(6)",{"$f":"IF(C42>E42,C42-E42,0)","v":0}]
[]
[]
[null,"POUR INFORMATION DE L'ORGANE DÉLIBÉRANT"]
[]
[null,"VARIATION ET NIVEAU DU FONDS DE ROULEMENT, DU BESOIN EN FONDS DE ROULEMENT ET DE LA TRÉSORERIE"]
[]
[null,null,null,null,{"$f":"CONCATENATE(Donnees!W6,CHAR(10),Donnees!E1)","v":"V3\n2018"}]
[null,"Variation du FONDS DE ROULEMENT : AUGMENTATION (7) ou DIMINUTION (8)",null,null,{"$f":"+C43-E43","v":9997.7899999999208}]
[null,"Variation du BESOIN en FONDS DE ROULEMENT (FONDS DE ROULEMENT - TRÉSORERIE)",null,null,{"$f":"E51-E53","v":9997.7899999999208}]
[null,"Variation de la TRÉSORERIE : ABONDEMENT (I) ou PRÉLÈVEMENT (II)*"]
[null,"Niveau final du FONDS DE ROULEMENT",null,null,{"$f":"E55+E56","v":242000}]
[null,"Niveau final du BESOIN EN FONDS DE ROULEMENT",null,null,{"$f":"SUM(SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$F$6:$F$1000000,\"SPTRE1\",Donnees!$B$6:$B$1000000,\"B1\"))-SUM(SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$F$6:$F$1000000,\"SPTRE1\",Donnees!$B$6:$B$1000000,\"B1\"))","v":169000}]
[null,"Niveau final de la TRÉSORERIE",null,null,{"$f":"SUM(SUMIFS(Donnees!$I$6:$I$1000000,Donnees!$F$6:$F$1000000,\"SPTRE2\",Donnees!$B$6:$B$1000000,\"B1\"))-SUM(SUMIFS(Donnees!$J$6:$J$1000000,Donnees!$F$6:$F$1000000,\"SPTRE2\",Donnees!$B$6:$B$1000000,\"B1\"))","v":73000}]
[]
[null,"* Montant issu du tableau \"Equilibre financier\""]

{"sheet":"Pdf1","index":1,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":true,"merged":[[1,1,1,4],[2,1,2,4],[4,1,4,4]]}
[null,{"$f":"IF(Donnees!AD6=\"07\",+CONCATENATE(\"PDF_\",\"CR\",Donnees!AH6,\"_\",Donnees!Z6,REPT(\" \",10-LEN(Donnees!Z6)),\"_\",Donnees!M6),+CONCATENATE(\"CR\",Donnees!AH6,\"_\",Donnees!Z6,REPT(\" \",10-LEN(Donnees!Z6)),\"_\",Donnees!AA6,\"_\",Donnees!AC6,\"_\",Donnees!M6,\"_\",Donnees!AD6))","v":"CRP_1479999999_03_02_2018_04"},null,null,{"$f":"CONCATENATE(\"Edité au : \",Donnees!F4)","v":"Edité au : 02/05/2019"}]
[null,{"$f":"+Donnees!C1","v":"Qualiac développement"}]
[null,"Tableau 2"]
[]
[null,"COMPTE DE RÉSULTAT ET ÉTAT DE L'ÉVOLUTION DE LA SITUATION PATRIMONIALE EN DROITS CONSTATÉS"]
[]
[]
[null,"COMPTE DE RÉSULTAT PRÉVISIONNEL/EXÉCUTÉ"]
[]
[null,"CHARGES",{"$f":"CONCATENATE(Donnees!W6,CHAR(10),Donnees!E1)","v":"V3\n2018"},"PRODUITS",{"$f":"CONCATENATE(Donnees!W6,CHAR(10),Donnees!E1)","v":"V3\n2018"}]
[null,"Personnel",{"$f":"'Situation patrimoniale'!C12","v":530580},"Subventions de l'Etat",{"$f":"'Situation patrimoniale'!E12","v":324000}]
[null,"dont charges de pensions civiles",{"$f":"'Situation patrimoniale'!C13","v":0},"Fiscalité affectée",{"$f":"'Situation patrimoniale'!E13","v":0}]
[null,"Fonctionnement autre que les charges de personnel",{"$f":"'Situation patrimoniale'!C14","v":960049.29},"Autres subventions",{"$f":"'Situation patrimoniale'!E14","v":648000}]
[null,"Intervention (le cas échéant)",{"$f":"'Situation patrimoniale'!C15","v":105000},"Autres produits",{"$f":"'Situation patrimoniale'!E15","v":754683.67}]
[null,"TOTAL DES CHARGES (1)",{"$f":"SUM(C11,C13,C14)","v":1595629.29},"TOTAL DES PRODUITS (2)",{"$f":"SUM(E11:E14)","v":1726683.67}]
[null,"Résultat : bénéfice (3) = (2) - (1)",{"$f":"IF(E15>C15,E15-C15,0)","v":131054.37999999989},"Résultat : perte (4) = (1) - (2)",{"$f":"IF(C15>E15,C15-E15,0)","v":0}]
[null,"TOTAL EQUILIBRE du compte de résultat\n(1) + (3) = (2) + (4)",{"$f":"SUM(C15:C16)","v":1726683.67},"TOTAL EQUILIBRE du compte de résultat\n(1) + (3) = (2) + (4)",{"$f":"SUM(E15:E16)","v":1726683.67}]

{"sheet":"Pdf2","index":2,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":true,"merged":[[1,1,1,4],[2,1,2,4],[4,1,4,4]]}
[null,{"$f":"IF(Donnees!AD6=\"07\",+CONCATENATE(\"PDF_\",\"CAF\",Donnees!AH6,\"_\",Donnees!Z6,REPT(\" \",10-LEN(Donnees!Z6)),\"_\",Donnees!M6),+CONCATENATE(\"CAF\",Donnees!AH6,\"_\",Donnees!Z6,REPT(\" \",10-LEN(Donnees!Z6)),\"_\",Donnees!AA6,\"_\",Donnees!AC6,\"_\",Donnees!M6,\"_\",Donnees!AD6))","v":"CAFP_1479999999_03_02_2018_04"},null,null,{"$f":"CONCATENATE(\"Edité au : \",Donnees!F4)","v":"Edité au : 02/05/2019"}]
[null,{"$f":"+Donnees!C1","v":"Qualiac développement"}]
[null,"Tableau 2"]
[]
[null,"COMPTE DE RÉSULTAT ET ÉTAT DE L'ÉVOLUTION DE LA SITUATION PATRIMONIALE EN DROITS CONSTATÉS"]
[]
[]
[null,"CALCUL DE LA CAPACITÉ D'AUTOFINANCEMENT"]
[]
[null,null,{"$f":"CONCATENATE(Donnees!W6,CHAR(10),Donnees!E1)","v":"V3\n2018"}]
[null,"Résultat de l'exercice (bénéfice (3) ou perte (-4))",{"$f":"'Situation patrimoniale'!C24","v":131054.37999999989}]
[null,"+ Dotations aux amortissements, dépréciations et provisions",{"$f":"'Situation patrimoniale'!C25","v":324663.41000000003}]
[null,"- reprises sur amortissements, dépréciations et provisions",{"$f":"'Situation patrimoniale'!C26","v":96000}]
[null,"+ valeur nette comptable des éléments d'actifs cédés",{"$f":"'Situation patrimoniale'!C27","v":38000}]
[null,"- produits de cession d'éléments d'actifs ",{"$f":"'Situation patrimoniale'!C28","v":150000}]
[null,"- quote-part reprise au résultat des financements rattachés à des actifs",{"$f":"'Situation patrimoniale'!C29","v":11000}]
[null,"= CAF ou IAF*",{"$f":"(C11+C12-C13+C14-C15-C16)","v":236717.78999999992}]
[null,"*capacité d'autofinancement ou d'insuffisance d'autofinancement"]

{"sheet":"Pdf3","index":3,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":true,"merged":[[1,1,1,4],[2,1,2,4],[4,1,4,4],[11,1,13,1],[11,2,13,2]]}
[null,{"$f":"IF(Donnees!AD6=\"07\",+CONCATENATE(\"PDF_\",\"TF\",Donnees!AH6,\"_\",Donnees!Z6,REPT(\" \",10-LEN(Donnees!Z6)),\"_\",Donnees!M6),+CONCATENATE(\"TF\",Donnees!AH6,\"_\",Donnees!Z6,REPT(\" \",10-LEN(Donnees!Z6)),\"_\",Donnees!AA6,\"_\",Donnees!AC6,\"_\",Donnees!M6,\"_\",Donnees!AD6))","v":"TFP_1479999999_03_02_2018_04"},null,null,{"$f":"CONCATENATE(\"Edité au : \",Donnees!F4)","v":"Edité au : 02/05/2019"}]
[null,{"$f":"+Donnees!C1","v":"Qualiac développement"}]
[null,"Tableau 2"]
[]
[null,"COMPTE DE RÉSULTAT ET ÉTAT DE L'ÉVOLUTION DE LA SITUATION PATRIMONIALE EN DROITS CONSTATÉS"]
[]
[]
[null,"ÉTAT PRÉVISIONNEL/EXÉCUTÉ DE L'ÉVOLUTION DE LA SITUATION PATRIMONIALE EN DROITS CONSTATÉS"]
[]
[null,"EMPLOIS",{"$f":"CONCATENATE(Donnees!W6,CHAR(10),Donnees!E1)","v":"V3\n2018"},"RESSOURCES",{"$f":"CONCATENATE(Donnees!W6,CHAR(10),Donnees!E1)","v":"V3\n2018"}]
[null,"Insuffisance d'autofinancement",{"$f":"'Situation patrimoniale'!C37","v":0},"Capacité d'autofinancement",{"$f":"'Situation patrimoniale'!E37","v":236717.78999999992}]
[null,"Investissements",{"$f":"'Situation patrimoniale'!C38","v":952720},"Financement de l'actif par l'État",{"$f":"'Situation patrimoniale'!E38","v":400000}]
[null,null,null,"Financement de l'actif par des tiers autres que l'État",{"$f":"'Situation patrimoniale'!E39","v":116000}]
[null,null,null,"Autres ressources",{"$f":"'Situation patrimoniale'!E40","v":150000}]
[null,"Remboursement des dettes financières",{"$f":"'Situation patrimoniale'!C41","v":48000},"Augmentation des dettes financières",{"$f":"'Situation patrimoniale'!E41","v":108000}]
[null,"TOTAL DES EMPLOIS (5)",{"$f":"'Situation patrimoniale'!C42","v":1000720},"TOTAL DES RESSOURCES (6)",{"$f":"'Situation patrimoniale'!E42","v":1010717.7899999999}]
[null,"Augmentation du fonds de roulement (7) = (6)-(5)",{"$f":"'Situation patrimoniale'!C43","v":9997.7899999999208},"Diminution du fonds de roulement  (8) = (5)-(6)",{"$f":"'Situation patrimoniale'!E43","v":0}]

{"sheet":"Pdf4","index":4,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":true,"merged":[[1,1,1,4],[2,1,2,4],[4,1,4,4],[11,1,13,1],[11,2,13,2]]}
[null,{"$f":"IF(Donnees!AD6=\"07\",+CONCATENATE(\"PDF_\",\"SP\",Donnees!AH6,\"1_\",Donnees!Z6,REPT(\" \",10-LEN(Donnees!Z6)),\"_\",Donnees!M6),+CONCATENATE(\"SP\",Donnees!AH6,\"1_\",Donnees!Z6,REPT(\" \",10-LEN(Donnees!Z6)),\"_\",Donnees!AA6,\"_\",Donnees!AC6,\"_\",Donnees!M6,\"_\",Donnees!AD6))","v":"SPP1_1479999999_03_02_2018_04"},null,null,{"$f":"CONCATENATE(\"Edité au : \",Donnees!F4)","v":"Edité au : 02/05/2019"}]
[null,{"$f":"+Donnees!C1","v":"Qualiac développement"}]
[null,"Tableau 2"]
[]
[null,"COMPTE DE RÉSULTAT ET ÉTAT DE L'ÉVOLUTION DE LA SITUATION PATRIMONIALE EN DROITS CONSTATÉS"]
[]
[]
[null,"ÉTAT PRÉVISIONNEL/EXÉCUTÉ DE L'ÉVOLUTION DE LA SITUATION PATRIMONIALE EN DROITS CONSTATÉS"]
[]
[null,"EMPLOIS",{"$f":"CONCATENATE(Donnees!W6,CHAR(10),Donnees!E1)","v":"V3\n2018"},"RESSOURCES",{"$f":"CONCATENATE(Donnees!W6,CHAR(10),Donnees!E1)","v":"V3\n2018"}]
[null,"Insuffisance d'autofinancement",{"$f":"'Situation patrimoniale'!C37","v":0},"Capacité d'autofinancement",{"$f":"'Situation patrimoniale'!E37","v":236717.78999999992}]
[null,"Investissements",{"$f":"'Situation patrimoniale'!C38","v":952720},"Financement de l'actif par l'État",{"$f":"'Situation patrimoniale'!E38","v":400000}]
[null,null,null,"Financement de l'actif par des tiers autres que l'État",{"$f":"'Situation patrimoniale'!E39","v":116000}]
[null,null,null,"Autres ressources",{"$f":"'Situation patrimoniale'!E40","v":150000}]
[null,"Remboursement des dettes financières",{"$f":"'Situation patrimoniale'!C41","v":48000},"Augmentation des dettes financières",{"$f":"'Situation patrimoniale'!E41","v":108000}]
[null,"TOTAL DES EMPLOIS (5)",{"$f":"'Situation patrimoniale'!C42","v":1000720},"TOTAL DES RESSOURCES (6)",{"$f":"'Situation patrimoniale'!E42","v":1010717.7899999999}]
[null,"Augmentation du fonds de roulement (7) = (6)-(5)",{"$f":"'Situation patrimoniale'!C43","v":9997.7899999999208},"Diminution du fonds de roulement  (8) = (5)-(6)",{"$f":"'Situation patrimoniale'!E43","v":0}]

{"sheet":"Fonds de roulement","index":5,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[12,1,12,3],[1,1,1,4],[6,1,6,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[2,1,2,4]]}
[null,null,null,null,{"$f":"CONCATENATE(\"Edité au : \",Donnees!F4)","v":"Edité au : 02/05/2019"}]
[null,{"$f":"+Donnees!C1","v":"Qualiac développement"}]
[null,"Tableau 2"]
[]
[null,"VARIATION ET NIVEAU DU FONDS DE ROULEMENT, DU BESOIN EN FONDS DE ROULEMENT ET DE LA TRÉSORERIE"]
[]
[null,null,null,null,{"$f":"CONCATENATE(Donnees!W6,CHAR(10),Donnees!E1)","v":"V3\n2018"}]
[null,"Variation du FONDS DE ROULEMENT : AUGMENTATION (7) ou DIMINUTION (8)",null,null,{"$f":"'Situation patrimoniale'!E51","v":9997.7899999999208}]
[null,"Variation du BESOIN en FONDS DE ROULEMENT (FONDS DE ROULEMENT - TRÉSORERIE)",null,null,{"$f":"'Situation patrimoniale'!E52","v":9997.7899999999208}]
[null,"Variation de la TRESORERIE : ABONDEMENT (I) ou PRÉLÈVEMENT (II)*",null,null,{"$f":"'Situation patrimoniale'!E53","v":0}]
[null,"Niveau final du FONDS DE ROULEMENT",null,null,{"$f":"'Situation patrimoniale'!E54","v":242000}]
[null,"Niveau final du BESOIN EN FONDS DE ROULEMENT",null,null,{"$f":"'Situation patrimoniale'!E55","v":169000}]
[null,"Niveau final de la TRÉSORERIE",null,null,{"$f":"'Situation patrimoniale'!E56","v":73000}]
[]
[null,"* Montant issu du tableau \"Equilibre financier\""]

{"sheet":"PrFicTab5","index":6,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Code fichier : ",{"$f":"+CONCATENATE(\"SP\",Donnees!AH6,\"2_\",Donnees!Z6,REPT(\" \",10-LEN(Donnees!Z6)),\"_\",Donnees!AA6,\"_\",Donnees!AC6,\"_\",Donnees!M6,\"_\",Donnees!AD6,\".txt\")","v":"SPP2_1479999999_03_02_2018_04.txt"}]
[]
[100001,null,null,null,{"$f":"+CONCATENATE(A3,Donnees!Z6,REPT(\" \",10-LEN(Donnees!Z6)),Donnees!AA6,Donnees!AB6,REPT(\" \",2-LEN(Donnees!AB6)),Donnees!AC6,Donnees!M6,Donnees!AD6,Donnees!AE6,Donnees!AF6,Donnees!AG6)","v":"10000114799999990301022018043112201831639383431639383400080"}]
[200002,"01",{"$f":"'Fonds de roulement'!E8","v":9997.7899999999208},{"$f":"IF(C4>=0,CONCATENATE(\"+\",+TEXT(C4*100,\"00000000000000\")),CONCATENATE(\"\",+TEXT(C4*100,\"00000000000000\")))","v":"+00000000999779"},{"$f":"+CONCATENATE(A4,B4,D4,REPT(\" \",59-LEN(CONCATENATE(A4,B4,D4))))","v":"20000201+00000000999779                                    "}]
[200003,"02",{"$f":"'Fonds de roulement'!E9","v":9997.7899999999208},"+00000000999779","20000302+00000000999779                                    "]
[200004,"03",{"$f":"'Fonds de roulement'!E10","v":0},"+00000000000000","20000403+00000000000000                                    "]
[200005,"04",{"$f":"'Fonds de roulement'!E11","v":242000},"+00000024200000","20000504+00000024200000                                    "]
[200006,"05",{"$f":"'Fonds de roulement'!E12","v":169000},"+00000016900000","20000605+00000016900000                                    "]
[200007,"06",{"$f":"'Fonds de roulement'!E13","v":73000},"+00000007300000","20000706+00000007300000                                    "]
[900008,null,null,null,{"$f":"+CONCATENATE(A10,REPT(\" \",59-LEN(A10)))","v":"900008                                                     "}]

{"sheet":"FicTab5","index":7,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[{"$f":"PrFicTab5!E3","v":"10000114799999990301022018043112201831639383431639383400080"}]
[{"$f":"PrFicTab5!E4","v":"20000201+00000000999779                                    "}]
[{"$f":"PrFicTab5!E5","v":"20000302+00000000999779                                    "}]
[{"$f":"PrFicTab5!E6","v":"20000403+00000000000000                                    "}]
[{"$f":"PrFicTab5!E7","v":"20000504+00000024200000                                    "}]
[{"$f":"PrFicTab5!E8","v":"20000605+00000016900000                                    "}]
[{"$f":"PrFicTab5!E9","v":"20000706+00000007300000                                    "}]
[{"$f":"PrFicTab5!E10","v":"900008                                                     "}]

{"sheet":"Donnees","index":8,"n_rows":71,"n_cols":35,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
["Etablissement :",{"$f":"K6","v":"IND"},{"$f":"L6","v":"Qualiac développement"},"Année de l'exercice :",{"$f":"M6","v":"2018"}]
["CGR :",{"$f":"N6","v":"CENTRE"},{"$f":"O6","v":"Centre"},"Chemin :",{"$f":"P6","v":"DAT"}]
["Poste :",{"$f":"Q6","v":"SP"},{"$f":"R6","v":"Situation patrimoniale"},"Chemin :",{"$f":"S6","v":"SP"}]
["Job :",{"$f":"T6","v":"428638"},"Utilisateur :",{"$f":"U6","v":"PR"},"Date :",{"$f":"V6","v":"02/05/2019"}]
["But","But N°","Poste ","Poste 1","Poste 2","Poste 3","Poste 4","Poste 5","Montant débit","Montant crédit","Etablissement","Intitulé de l'établissement","Année","CGR","Intitulé du CGR","Chemin","Poste ","Intitulé du poste","Chemin","Job","Utilisateur","Date","But 1","Type d'enregistrement","Numéro de l'enregistrement","Identifiant de l’établissement","Type de document","Code nomenclature","Code budget","Rang de la balance","Date d'arrêté","SIREN","SIRET","Type fichier","Formule CAF"]
["RC","B1","104","SPER","SPERR","SPERR1","104",null,0,400000,"IND","Qualiac développement","2018","CENTRE","Centre","DAT","SP","Situation patrimoniale","SP","428638","PR","02/05/2019","V3","1","00001","1479999999","03","01","02","04","31122018","316393834","31639383400080","P","O"]
["RC","B1","131","SPER","SPERR","SPERR2","131",null,0,76000]
["RC","B1","138","SPER","SPERR","SPERR2","138",null,0,40000]
["RC","B1","161D","SPER","SPERE","SPERE2","161D",null,8000,0]
["RC","B1","164C","SPER","SPERR","SPERR4","164C",null,0,80000]
["RC","B1","174D","SPER","SPERE","SPERE2","174D",null,40000,0]
["RC","B1","178C","SPER","SPERR","SPERR4","178C",null,0,28000]
["RC","B1","201D","SPER","SPERE","SPERE1","201D",null,72000,0]
["RC","B1","203D","SPER","SPERE","SPERE1","203D",null,44000,0]
["RC","B1","211D","SPER","SPERE","SPERE1","211D",null,40000,0]
["RC","B1","213D","SPER","SPERE","SPERE1","213D",null,480000,0]
["RC","B1","231D","SPER","SPERE","SPERE1","231D",null,144000,0]
["RC","B1","237D","SPER","SPERE","SPERE1","237D",null,70720,0]
["RC","B1","261D","SPER","SPERE","SPERE1","261D",null,76000,0]
["RC","B1","267D","SPER","SPERE","SPERE1","267D",null,6000,0]
["RC","B1","272D","SPER","SPERE","SPERE1","272D",null,20000,0]
["RC","B1","341","SPTR","SPTRE","SPTRE1","341",null,160000,0]
["RC","B1","431","SPTR","SPTRE","SPTRE1","431",null,9000,0]
["RC","B1","512","SPTR","SPTRE","SPTRE2","512",null,70000,0]
["RC","B1","531","SPTR","SPTRE","SPTRE2","531",null,3000,0]
["RC","B1","603","SPCR","SPCRC","SPCRC2","603",null,156663.41,0]
["RC","B1","606","SPCR","SPCRC","SPCRC2","606",null,2731.37,0]
["RC","B1","606","SPCR","SPCRC","SPCRC2","606",null,146023.57999999999,0]
["RC","B1","606","SPCR","SPCRC","SPCRC2","606",null,33055.71,0]
["RC","B1","606","SPCR","SPCRC","SPCRC2","606",null,1035.22,0]
["RC","B1","606","SPCR","SPCRC","SPCRC2","606",null,6041.58,0]
["RC","B1","606","SPCR","SPCRC","SPCRC2","606",null,101975.21,0]
["RC","B1","606","SPCR","SPCRC","SPCRC2","606",null,13817.4,0]
["RC","B1","606","SPCR","SPCRC","SPCRC2","606",null,21608.18,0]
["RC","B1","606","SPCR","SPCRC","SPCRC2","606",null,16389.96,0]
["RC","B1","606","SPCR","SPCRC","SPCRC2","606",null,52000,0]
["RC","B1","606","SPCR","SPCRC","SPCRC2","606",null,151700,0]
["RC","B1","612","SPCR","SPCRC","SPCRC2","612",null,13408.65,0]
["RC","B1","612","SPCR","SPCRC","SPCRC2","612",null,7474.59,0]
["RC","B1","612","SPCR","SPCRC","SPCRC2","612",null,5043.83,0]
["RC","B1","612","SPCR","SPCRC","SPCRC2","612",null,4808.24,0]
["RC","B1","612","SPCR","SPCRC","SPCRC2","612",null,4973.79,0]
["RC","B1","612","SPCR","SPCRC","SPCRC2","612",null,4913.75,0]
["RC","B1","612","SPCR","SPCRC","SPCRC2","612",null,4845.7299999999996,0]
["RC","B1","612","SPCR","SPCRC","SPCRC2","612",null,4845.7299999999996,0]
["RC","B1","612","SPCR","SPCRC","SPCRC2","612",null,4789.8100000000004,0]
["RC","B1","612","SPCR","SPCRC","SPCRC2","612",null,4845.7299999999996,0]
["RC","B1","612","SPCR","SPCRC","SPCRC2","612",null,4801.72,0]
["RC","B1","612","SPCR","SPCRC","SPCRC2","612",null,4845.7299999999996,0]
["RC","B1","616","SPCR","SPCRC","SPCRC2","616",null,1410.37,0]
["RC","B1","641","SPCR","SPCRC","SPCRC1","641",null,150000,0]
["RC","B1","645","SPCR","SPCRC","SPCRC1","645",null,120000,0]
["RC","B1","647","SPCR","SPCRC","SPCRC1","647",null,260580,0]
["RC","B1","656","SPCR","SPCRC","SPCRC2","656",null,18000,0]
["RC","B1","657","SPCR","SPCRC","SPCRC3","657",null,85000,0]
["RC","B1","6577","SPCR","SPCRC","SPCRC3","657","6577",20000,0]
["RC","B1","681","SPCR","SPCRC","SPCRC2","681",null,168000,0]
["RC","B1","701","SPCR","SPCRP","SPCRP4","701",null,0,284000]
["RC","B1","706","SPCR","SPCRP","SPCRP4","706",null,0,3000]
["RC","B1","706","SPCR","SPCRP","SPCRP4","706",null,0,21932.34]
["RC","B1","707","SPCR","SPCRP","SPCRP4","707",null,0,2000.33]
["RC","B1","707","SPCR","SPCRP","SPCRP4","707",null,0,18751]
["RC","B1","741","SPCR","SPCRP","SPCRP1","741",null,0,324000]
["RC","B1","744","SPCR","SPCRP","SPCRP3","744",null,0,324000]
["RC","B1","745","SPCR","SPCRP","SPCRP3","745",null,0,324000]
["RC","B1","7813","SPCR","SPCRP","SPCRP4","7813",null,0,11000]
["RC","B1","756","SPCR","SPCRP","SPCRP4","756",null,0,140000]
["RC","B1","765","SPCR","SPCRP","SPCRP4","765",null,0,168000]
["RC","B1","7672","SPCR","SPCRP","SPCRP4","767","7672",0,10000]
["RC","B1","781","SPCR","SPCRP","SPCRP4","781",null,0,88000]
["RC","B1","786","SPCR","SPCRP","SPCRP4","786",null,0,8000]

{"sheet":"PrepTab1","index":9,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Code fichier : ",{"$f":"+CONCATENATE(\"CR\",Donnees!AH6,\"_\",Donnees!Z6,REPT(\" \",10-LEN(Donnees!Z6)),\"_\",Donnees!AA6,\"_\",Donnees!AC6,\"_\",Donnees!M6,\"_\",Donnees!AD6,\".txt\")","v":"CRP_1479999999_03_02_2018_04.txt"}]
[]
[100001,null,null,null,{"$f":"+CONCATENATE(A3,Donnees!Z6,REPT(\" \",10-LEN(Donnees!Z6)),Donnees!AA6,Donnees!AB6,REPT(\" \",2-LEN(Donnees!AB6)),Donnees!AC6,Donnees!M6,Donnees!AD6,Donnees!AE6,Donnees!AF6,Donnees!AG6)","v":"10000114799999990301022018043112201831639383431639383400080"}]
[200002,"01",{"$f":"'Situation patrimoniale'!C12","v":530580},{"$f":"IF(C4>=0,CONCATENATE(\"+\",+TEXT(C4*100,\"00000000000000\")),CONCATENATE(\"\",+TEXT(C4*100,\"00000000000000\")))","v":"+00000053058000"},{"$f":"+CONCATENATE(A4,B4,D4,REPT(\" \",59-LEN(CONCATENATE(A4,B4,D4))))","v":"20000201+00000053058000                                    "}]
[200003,"02",{"$f":"'Situation patrimoniale'!C13","v":0},"+00000000000000","20000302+00000000000000                                    "]
[200004,"03",{"$f":"'Situation patrimoniale'!C14","v":960049.29},"+00000096004929","20000403+00000096004929                                    "]
[200005,"04",{"$f":"'Situation patrimoniale'!C15","v":105000},"+00000010500000","20000504+00000010500000                                    "]
[200006,"05",{"$f":"'Situation patrimoniale'!E12","v":324000},"+00000032400000","20000605+00000032400000                                    "]
[200007,"06",{"$f":"'Situation patrimoniale'!E13","v":0},"+00000000000000","20000706+00000000000000                                    "]
[200008,"07",{"$f":"'Situation patrimoniale'!E14","v":648000},"+00000064800000","20000807+00000064800000                                    "]
[200009,"08",{"$f":"'Situation patrimoniale'!E15","v":754683.67},"+00000075468367","20000908+00000075468367                                    "]
[200010,"09",{"$f":"'Situation patrimoniale'!C16","v":1595629.29},"+00000159562929","20001009+00000159562929                                    "]
[200011,"10",{"$f":"'Situation patrimoniale'!E16","v":1726683.67},"+00000172668367","20001110+00000172668367                                    "]
[200012,"11",{"$f":"'Situation patrimoniale'!C17","v":131054.37999999989},"+00000013105438","20001211+00000013105438                                    "]
[200013,"12",{"$f":"'Situation patrimoniale'!E17","v":0},"+00000000000000","20001312+00000000000000                                    "]
[200014,"13",{"$f":"'Situation patrimoniale'!C18","v":1726683.67},"+00000172668367","20001413+00000172668367                                    "]
[200015,"14",{"$f":"'Situation patrimoniale'!E18","v":1726683.67},"+00000172668367","20001514+00000172668367                                    "]
[900016,null,null,null,{"$f":"+CONCATENATE(A18,REPT(\" \",59-LEN(A18)))","v":"900016                                                     "}]

{"sheet":"Tab1","index":10,"n_rows":16,"n_cols":1,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[{"$f":"+PrepTab1!E3","v":"10000114799999990301022018043112201831639383431639383400080"}]
[{"$f":"+PrepTab1!E4","v":"20000201+00000053058000                                    "}]
[{"$f":"+PrepTab1!E5","v":"20000302+00000000000000                                    "}]
[{"$f":"+PrepTab1!E6","v":"20000403+00000096004929                                    "}]
[{"$f":"+PrepTab1!E7","v":"20000504+00000010500000                                    "}]
[{"$f":"+PrepTab1!E8","v":"20000605+00000032400000                                    "}]
[{"$f":"+PrepTab1!E9","v":"20000706+00000000000000                                    "}]
[{"$f":"+PrepTab1!E10","v":"20000807+00000064800000                                    "}]
[{"$f":"+PrepTab1!E11","v":"20000908+00000075468367                                    "}]
[{"$f":"+PrepTab1!E12","v":"20001009+00000159562929                                    "}]
[{"$f":"+PrepTab1!E13","v":"20001110+00000172668367                                    "}]
[{"$f":"+PrepTab1!E14","v":"20001211+00000013105438                                    "}]
[{"$f":"+PrepTab1!E15","v":"20001312+00000000000000                                    "}]
[{"$f":"+PrepTab1!E16","v":"20001413+00000172668367                                    "}]
[{"$f":"+PrepTab1!E17","v":"20001514+00000172668367                                    "}]
[{"$f":"+PrepTab1!E18","v":"900016                                                     "}]

{"sheet":"PrepTab2","index":11,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Code fichier : ",{"$f":"+CONCATENATE(\"CAF\",Donnees!AH6,\"_\",Donnees!Z6,REPT(\" \",10-LEN(Donnees!Z6)),\"_\",Donnees!AA6,\"_\",Donnees!AC6,\"_\",Donnees!M6,\"_\",Donnees!AD6,\".txt\")","v":"CAFP_1479999999_03_02_2018_04.txt"}]
[]
[100001,null,null,null,{"$f":"+CONCATENATE(A3,Donnees!Z6,REPT(\" \",10-LEN(Donnees!Z6)),Donnees!AA6,Donnees!AB6,REPT(\" \",2-LEN(Donnees!AB6)),Donnees!AC6,Donnees!M6,Donnees!AD6,Donnees!AE6,Donnees!AF6,Donnees!AG6)","v":"10000114799999990301022018043112201831639383431639383400080"}]
[200002,"01",{"$f":"'Situation patrimoniale'!C24","v":131054.37999999989},{"$f":"IF(C4>=0,CONCATENATE(\"+\",+TEXT(C4*100,\"00000000000000\")),CONCATENATE(\"\",+TEXT(C4*100,\"00000000000000\")))","v":"+00000013105438"},{"$f":"+CONCATENATE(A4,B4,D4,REPT(\" \",59-LEN(CONCATENATE(A4,B4,D4))))","v":"20000201+00000013105438                                    "}]
[200003,"02",{"$f":"'Situation patrimoniale'!C25","v":324663.41000000003},"+00000032466341","20000302+00000032466341                                    "]
[200004,"03",{"$f":"'Situation patrimoniale'!C26","v":96000},"+00000009600000","20000403+00000009600000                                    "]
[200005,"04",{"$f":"'Situation patrimoniale'!C27","v":38000},"+00000003800000","20000504+00000003800000                                    "]
[200006,"05",{"$f":"'Situation patrimoniale'!C28","v":150000},"+00000015000000","20000605+00000015000000                                    "]
[200007,"06",{"$f":"'Situation patrimoniale'!C29","v":11000},"+00000001100000","20000706+00000001100000                                    "]
[200008,"07",{"$f":"'Situation patrimoniale'!C30","v":236717.78999999992},"+00000023671779","20000807+00000023671779                                    "]
[900009,null,null,null,{"$f":"+CONCATENATE(A11,REPT(\" \",59-LEN(A11)))","v":"900009                                                     "}]

{"sheet":"Tab2","index":12,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[{"$f":"+PrepTab2!E3","v":"10000114799999990301022018043112201831639383431639383400080"}]
[{"$f":"+PrepTab2!E4","v":"20000201+00000013105438                                    "}]
[{"$f":"+PrepTab2!E5","v":"20000302+00000032466341                                    "}]
[{"$f":"+PrepTab2!E6","v":"20000403+00000009600000                                    "}]
[{"$f":"+PrepTab2!E7","v":"20000504+00000003800000                                    "}]
[{"$f":"+PrepTab2!E8","v":"20000605+00000015000000                                    "}]
[{"$f":"+PrepTab2!E9","v":"20000706+00000001100000                                    "}]
[{"$f":"+PrepTab2!E10","v":"20000807+00000023671779                                    "}]
[{"$f":"+PrepTab2!E11","v":"900009                                                     "}]

{"sheet":"PrepTab3","index":13,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["Code fichier : ",{"$f":"+CONCATENATE(\"TF\",Donnees!AH6,\"_\",Donnees!Z6,REPT(\" \",10-LEN(Donnees!Z6)),\"_\",Donnees!AA6,\"_\",Donnees!AC6,\"_\",Donnees!M6,\"_\",Donnees!AD6,\".txt\")","v":"TFP_1479999999_03_02_2018_04.txt"}]
[]
[100001,null,null,null,{"$f":"+CONCATENATE(A3,Donnees!Z6,REPT(\" \",10-LEN(Donnees!Z6)),Donnees!AA6,Donnees!AB6,REPT(\" \",2-LEN(Donnees!AB6)),Donnees!AC6,Donnees!M6,Donnees!AD6,Donnees!AE6,Donnees!AF6,Donnees!AG6)","v":"10000114799999990301022018043112201831639383431639383400080"}]
[200002,"01",{"$f":"'Situation patrimoniale'!C37","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":"'Situation patrimoniale'!C38","v":952720},"+00000095272000","20000302+00000095272000                                    "]
[200004,"03",{"$f":"'Situation patrimoniale'!C41","v":48000},"+00000004800000","20000403+00000004800000                                    "]
[200005,"04",{"$f":"'Situation patrimoniale'!C42","v":1000720},"+00000100072000","20000504+00000100072000                                    "]
[200006,"05",{"$f":"'Situation patrimoniale'!E37","v":236717.78999999992},"+00000023671779","20000605+00000023671779                                    "]
[200007,"06",{"$f":"'Situation patrimoniale'!E38","v":400000},"+00000040000000","20000706+00000040000000                                    "]
[200008,"07",{"$f":"'Situation patrimoniale'!E39","v":116000},"+00000011600000","20000807+00000011600000                                    "]
[200009,"08",{"$f":"'Situation patrimoniale'!E40","v":150000},"+00000015000000","20000908+00000015000000                                    "]
[200010,"09",{"$f":"'Situation patrimoniale'!E41","v":108000},"+00000010800000","20001009+00000010800000                                    "]
[200011,"10",{"$f":"'Situation patrimoniale'!E42","v":1010717.7899999999},"+00000101071779","20001110+00000101071779                                    "]
[200012,"11",{"$f":"'Situation patrimoniale'!C43","v":9997.7899999999208},"+00000000999779","20001211+00000000999779                                    "]
[200013,"12",{"$f":"'Situation patrimoniale'!E43","v":0},"+00000000000000","20001312+00000000000000                                    "]
[900014,null,null,null,{"$f":"+CONCATENATE(A16,REPT(\" \",59-LEN(A16)))","v":"900014                                                     "}]

{"sheet":"Tab3","index":14,"n_rows":14,"n_cols":1,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[{"$f":"+PrepTab3!E3","v":"10000114799999990301022018043112201831639383431639383400080"}]
[{"$f":"+PrepTab3!E4","v":"20000201+00000000000000                                    "}]
[{"$f":"+PrepTab3!E5","v":"20000302+00000095272000                                    "}]
[{"$f":"+PrepTab3!E6","v":"20000403+00000004800000                                    "}]
[{"$f":"+PrepTab3!E7","v":"20000504+00000100072000                                    "}]
[{"$f":"+PrepTab3!E8","v":"20000605+00000023671779                                    "}]
[{"$f":"+PrepTab3!E9","v":"20000706+00000040000000                                    "}]
[{"$f":"+PrepTab3!E10","v":"20000807+00000011600000                                    "}]
[{"$f":"+PrepTab3!E11","v":"20000908+00000015000000                                    "}]
[{"$f":"+PrepTab3!E12","v":"20001009+00000010800000                                    "}]
[{"$f":"+PrepTab3!E13","v":"20001110+00000101071779                                    "}]
[{"$f":"+PrepTab3!E14","v":"20001211+00000000999779                                    "}]
[{"$f":"+PrepTab3!E15","v":"20001312+00000000000000                                    "}]
[{"$f":"+PrepTab3!E16","v":"900014                                                     "}]

{"sheet":"PrepTab4","index":15,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["Code fichier : ",{"$f":"+CONCATENATE(\"SP\",Donnees!AH6,\"1_\",Donnees!Z6,REPT(\" \",10-LEN(Donnees!Z6)),\"_\",Donnees!AA6,\"_\",Donnees!AC6,\"_\",Donnees!M6,\"_\",Donnees!AD6,\".txt\")","v":"SPP1_1479999999_03_02_2018_04.txt"}]
[]
[100001,null,null,null,{"$f":"+CONCATENATE(A3,Donnees!Z6,REPT(\" \",10-LEN(Donnees!Z6)),Donnees!AA6,Donnees!AB6,REPT(\" \",2-LEN(Donnees!AB6)),Donnees!AC6,Donnees!M6,Donnees!AD6,Donnees!AE6,Donnees!AF6,Donnees!AG6)","v":"10000114799999990301022018043112201831639383431639383400080"}]
[200002,"01",{"$f":"'Pdf4'!C11","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":"'Pdf4'!C12","v":952720},"+00000095272000","20000302+00000095272000                                    "]
[200004,"03",{"$f":"'Pdf4'!C15","v":48000},"+00000004800000","20000403+00000004800000                                    "]
[200005,"04",{"$f":"'Pdf4'!C16","v":1000720},"+00000100072000","20000504+00000100072000                                    "]
[200006,"05",{"$f":"'Pdf4'!E11","v":236717.78999999992},"+00000023671779","20000605+00000023671779                                    "]
[200007,"06",{"$f":"'Pdf4'!E12","v":400000},"+00000040000000","20000706+00000040000000                                    "]
[200008,"07",{"$f":"'Pdf4'!E13","v":116000},"+00000011600000","20000807+00000011600000                                    "]
[200009,"08",{"$f":"'Pdf4'!E14","v":150000},"+00000015000000","20000908+00000015000000                                    "]
[200010,"09",{"$f":"'Pdf4'!E15","v":108000},"+00000010800000","20001009+00000010800000                                    "]
[200011,"10",{"$f":"'Pdf4'!E16","v":1010717.7899999999},"+00000101071779","20001110+00000101071779                                    "]
[200012,"11",{"$f":"'Pdf4'!C17","v":9997.7899999999208},"+00000000999779","20001211+00000000999779                                    "]
[200013,"12",{"$f":"'Pdf4'!E17","v":0},"+00000000000000","20001312+00000000000000                                    "]
[900014,null,null,null,{"$f":"+CONCATENATE(A16,REPT(\" \",59-LEN(A16)))","v":"900014                                                     "}]

{"sheet":"Tab4","index":16,"n_rows":14,"n_cols":1,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[{"$f":"PrepTab4!E3","v":"10000114799999990301022018043112201831639383431639383400080"}]
[{"$f":"PrepTab4!E4","v":"20000201+00000000000000                                    "}]
[{"$f":"PrepTab4!E5","v":"20000302+00000095272000                                    "}]
[{"$f":"PrepTab4!E6","v":"20000403+00000004800000                                    "}]
[{"$f":"PrepTab4!E7","v":"20000504+00000100072000                                    "}]
[{"$f":"PrepTab4!E8","v":"20000605+00000023671779                                    "}]
[{"$f":"PrepTab4!E9","v":"20000706+00000040000000                                    "}]
[{"$f":"PrepTab4!E10","v":"20000807+00000011600000                                    "}]
[{"$f":"PrepTab4!E11","v":"20000908+00000015000000                                    "}]
[{"$f":"PrepTab4!E12","v":"20001009+00000010800000                                    "}]
[{"$f":"PrepTab4!E13","v":"20001110+00000101071779                                    "}]
[{"$f":"PrepTab4!E14","v":"20001211+00000000999779                                    "}]
[{"$f":"PrepTab4!E15","v":"20001312+00000000000000                                    "}]
[{"$f":"PrepTab4!E16","v":"900014                                                     "}]