{"text_format":"1","workbook":"xlsx","n_sheets":22,"sheets":["Maquette","remarq","récap","TS MESR ","Indicateurs","1-tab emplois_ETAB","2-tab_aut_budg_ETAB","2-tab_aut_budg_PRINC","2-tab_aut_budg_FU","3-tab_destination_origine_ETAB","3-tab_destination_origine_PRINC","3-tab_destination_origine_FU","4-tab_financier_ETAB","5-tab compte de tiers_ETAB","6-tab CR_TF_ETAB","6-tab CR_TF_PRINC","6-tab CR_TF_FU","7-tab Plan_tréso_ETAB","9-tab op_pluriannuelles_ETAB","8-tab recettes_fléchées_ETAB","9 tab op_pluriannuelles_ETAB","Annexe Synthèse_ETAB"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":26,"defined_names":599,"comments":14,"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":"Maquette","index":0,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":true,"merged":[[1,0,1,1]]}
[]
["VARIABLES A SAISIR"]
["Année",2017]
["Budget","Compte Financier"]
["N° budget"]

{"sheet":"remarq","index":1,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
["T2 : automatiser les CP de personnel pour les AE personnel saisies, ces montants étant systématiquement les mêmes (pour tous les T2)","FAIT"]
["T2 (tous) : pour la cellule L11, la formule est à remplacer par somme (L12:L16)","FAIT"]
["T2 (tous) et T6 (tous) : contrôle de cohérence des CP personnel et des charges de personnel à enlever car les montants peuvent être différents (charges à payer par exemple)","FAIT"]
["T2 ETAB : G34, G33  et G32 contrôle de cohérence PRINC + SIE???"]
["T3 : créer les liens pour que la saisie ne soit à faire que pour PRINC, FU et SIE (destinations et recettes)","FAIT"]
["T3 : ajouter un onglet pour FU et un onglet pour SIE","FAIT"]
["T4 : cellule C11 remplacer le lien avec l'onglet '2-tab_aut_budg_FU'!J30 par un lien avec l'onglet '2-tab_aut_budg_ETAB'!J30 Idem pour D11 et E11 pour BR et COFI","FAIT"]
["T5 : Automatiser le total des colonnes prévisions de décaissements et prévisions d'encaissements","FAIT"]
["T6 : cellule H46 formule à changer car différente de H44 et H45 (pour tous les T6)","FAIT"]
["T7 : ajouter la formule permettant de reprendre le montant de la colonne C49 dans D7 et ceci pour chaque mois","FAIT"]
["T7 : prise en compte des arrondis entre T4 et T7 : notamment opérations gérées en compte de tiers","NON FAIT"]
["T8 : pas de recettes fléchées à UBS => Tableaux 8 à supprimer","FAIT"]
["T9 : modifier les colonnes selon modèle transmis","FAIT"]
["Annexe synthèse : pas de contrôle de cohérence sur les données 2, 3 et 4 (H9 H10 H11 I9 I10 I11 J9 J10 J11) ces données COFI 2016 sont à saisir manuellemment sauf pour H10 I10 J10 où il ya une formule de calcul","FAIT"]
["Annexe synthèse : H24 : ne peut pas être pré remplie pour BI car le tableau 7 ne concerne que le COFI (idem pour cellule I24) + aps de contrôle de cohérence à faire","FAIT"]
["Annexe synthèse : H42 : différence (G20+ G22) - (C20+C22) à mettreen formule. Idem I42 et J42. Enlever le contrôle de cohérence car le tableau 5 ne prend pas en compte tous les éléments contenue dans la cellule H42. Idem I42 et J42.","FAIT"]
["Annexe synthèse : I38 : incohérence due à l'arrondi","NON FAIT"]
["Annexe synthèse : H44 : problème d'arrondis idem pour 144 et J44 + formule à adapter en fnction des données + ou -","NON FAIT"]
["Annexe synthèse : I48 : problème d'arrondis","NON FAIT"]
["Annexe synthèse : H54 : problème d'arrondis idem pour I54 et J54","NON FAIT"]
["Annexe synthèse : I55 : erreur dans le calcul cumulé du niveau de trésorerie PRINC, FU et CFA","NON FAIT MAIS EXPLICATIONS A DONNER PAR UBS"]
["Annexe synthèse : I56 : problème d'arrondis Idem pour H56 et J56.","NON FAIT"]
[]
["Enlever la protection sur certains tableaux "]
["Comment protéger des cellules dans des tableaux pour éviter saisies sur formules"]
["Toutes les données concernant le \"fléché\" ont été supprimés (commentaires et contrôle de cohérence)"]

{"sheet":"récap","index":2,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[18,3,20,3],[9,0,11,0],[9,1,11,1],[9,3,11,3],[0,1,0,3],[1,1,1,3],[6,1,8,1],[6,0,8,0],[14,1,16,1],[14,0,16,0],[6,3,8,3],[14,3,16,3],[18,0,20,0],[18,1,20,1]]}
[null,"EPSCP - synthèse des documents budgétaires"]
[]
[]
[null,"Intitulé du tableau","Périmètre","Soumission au CA"]
[]
[1,"Tableau des emplois","Budget de l'établissement","Pour vote"]
[2,"Tableau des autorisations budgétaires","Budget de l'établissement (3) = (1)+(2)","Pour vote. Pour les SIE, le vote relève du CA de l'établissement de rattachement"]
[null,null,"Budget établissement principal (1)"]
[null,null,"Fondation (2)"]
[3,"Tableau des dépenses par destination et recettes par origine","Budget de l'établissement (3) = (1)+(2)","Pour information"]
[null,null,"Budget établissement principal (1)"]
[null,null,"Fondation (2)"]
[4,"Tableau d'équilibre financier","Budget de l'établissement","Pour vote"]
[5,"Tableau des opération pour compte de tiers","Budget de l'établissement","Pour information"]
[6,"Tableau de situation patrimoniale (tableau compte de résultat - tableau de financement)","Budget de l'établissement (3) = (1)+(2)","Pour vote"]
[null,null,"Budget établissement principal (1)"]
[null,null,"Fondation (2)"]
[7,"Tableau présentant le plan de trésorerie","Budget de l'établissement","Pour information"]
[8,"Tableau des opérations liées aux recettes fléchées","Budget de l'établissement (3) = (1)+(2)","Pour information"]
[null,null,"Budget établissement principal (1)"]
[null,null,"Fondation (2)"]
[9,"Tableau des opérations pluriannuelles","Budget de l'établissement","Pour vote"]
[]
["Annexe 5","Tableau de synthèse","Budget de l'établissement"]

{"sheet":"TS MESR ","index":3,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,2,0,4]]}
["UBS",null,"Compte financier 2020"]
[null,null,"budget agrégé",null,"budget établissement"]
[null,null,"hors SIE",null,"avec SIE"]
[]
["T6","résultat net comptable",{"$f":"+IF('6-tab CR_TF_ETAB'!D14>0,'6-tab CR_TF_ETAB'!D14,'6-tab CR_TF_ETAB'!D14*-1)","v":2375948.1299999952},null,{"$f":"+IF(#REF!>0,#REF!,#REF!*-1)","v":{"$error":"#REF!"}},null,"onglet \"6-tab CR_TF_ETAB\" : cellule  H 14 (si perte) ou cellule D 14 (si bénéfice)"]
["T6","résultat net comptable (établissement principal)",{"$f":"+IF('6-tab CR_TF_PRINC'!D14>0,'6-tab CR_TF_PRINC'!D14,'6-tab CR_TF_PRINC'!D14*-1)","v":2375948.1299999952},null,null,null,"onglet \"6-tab CR_TF_PRINC\" : cellule H4 (si perte) ou cellule D14 (si bénéfice)"]
["T6","CAF",{"$f":"'6-tab CR_TF_ETAB'!D28","v":4571199.9799999958},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,"onglet \"6-tab CR_TF_ETAB\" : cellule D 28"]
["T6","Variation FDR",{"$f":"'6-tab CR_TF_ETAB'!H46","v":590153.22999999486},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,"onglet \"6-tab CR_TF_ETAB\" : cellule H 46"]
["T6","FDR",{"$f":"'6-tab CR_TF_ETAB'!H49","v":14337031.039999995},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,"onglet \"6-tab CR_TF_ETAB\" : cellule H 49"]
[]
["T4","variation de la trésorerie",{"$f":"'6-tab CR_TF_ETAB'!H48","v":603671.80000000005},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,"onglet \"6-tab CR_TF_ETAB\" : cellule H 48"]
["T6","trésorerie",{"$f":"'6-tab CR_TF_ETAB'!H51","v":14188111.000000002},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,"onglet \"6-tab CR_TF_ETAB\" : cellule H 51"]
[]
["T6","produits",{"$f":"'6-tab CR_TF_ETAB'!H13","v":96395211.780000001},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,"onglet \"6-tab CR_TF_ETAB\" : cellule H 13"]
["T6","produits encaissables",{"$f":"'6-tab CR_TF_ETAB'!H13+'6-tab CR_TF_ETAB'!D24+'6-tab CR_TF_ETAB'!D26+'6-tab CR_TF_ETAB'!D27","v":91071358.219999999},null,{"$f":"+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,"onglet \"6-tab CR_TF_ETAB\" : cellule H 13 + cellule D 24 + cellule D 26 + cellule D 27"]
["T2","SCSP",{"$f":"'2-tab_aut_budg_ETAB'!L12","v":68012462},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,"onglet \"2-tab_aut_budg_ETAB\" cellule L 12"]
[]
["T6","charges de fonctionnement décaissables",{"$f":"'6-tab CR_TF_ETAB'!D13-'6-tab CR_TF_ETAB'!D23-'6-tab CR_TF_ETAB'!D25","v":86500158.24000001},null,{"$f":"+#REF!-#REF!-#REF!","v":{"$error":"#REF!"}},null,"onglet \"6-tab CR_TF_ETAB\" : cellule D 13 - cellule D 23 - cellule D 25"]
["T6","charges de personnels",{"$f":"'6-tab CR_TF_ETAB'!D9","v":73619346.530000001},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,"onglet \"6-tab CR_TF_ETAB\" : cellule D 9"]
[]
["T6","emplois hors IAF",{"$f":"'6-tab CR_TF_ETAB'!D36","v":6729956.0600000005},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,"onglet \"6-tab CR_TF_ETAB\" : cellule D 36 (attention fusion cellules F36/F37/F38)"]
[]
["T2","solde budgétaire ",{"$f":"+IF('2-tab_aut_budg_ETAB'!H30>0,'2-tab_aut_budg_ETAB'!H30,'2-tab_aut_budg_ETAB'!H30*-1)","v":107904.76999998093},null,{"$f":"+IF(#REF!>0,#REF!,#REF!*-1)","v":{"$error":"#REF!"}},null,"onglet \"2-tab_aut_budg_ETAB\" cellule L 30 (si déficit) ou cellule H 30 (si excédent)"]
["T2","recettes (encaissements)",{"$f":"'2-tab_aut_budg_ETAB'!L28","v":92847985},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,"onglet \"2-tab_aut_budg_ETAB\" cellule L 28"]
["T2","autorisations d'engagements",{"$f":"'2-tab_aut_budg_ETAB'!G28","v":93880444.49000001},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,"onglet \"2-tab_aut_budg_ETAB\" cellule G 28"]
[]
["T9","restes à payer sur AE consommées en fin d'année n (CP)",null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,"onglet \"9-tab op_pluriannuelles_ETAB\" cellule L 28"]
["T9","restes à encaisser (année n+1 et suivantes)",null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,"onglet \"9-tab op_pluriannuelles_ETAB\" cellule I50"]
[]
["synthèse","niveau final des restes à payer",null,null,{"$f":"'Annexe Synthèse_ETAB'!J52","v":5987257.1899999911},null,"onglet \"Annexe Synthèse_ETAB\" cellule J 52"]
["synthèse","niveau final de la trésorerie fléchée",null,null,{"$f":"'Annexe Synthèse_ETAB'!J57","v":2019075.04},null,"onglet \"Annexe Synthèse_ETAB\" cellule J 57"]

{"sheet":"Indicateurs","index":4,"n_rows":76,"n_cols":6,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
["UBS",null,"COFI 2020"]
[]
["plafond Etat",null,{"$f":"+'1-tab emplois_ETAB'!H20","v":812.05},null,"tableau 1 : ligne 20"]
["plafond  ressources propres",null,{"$f":"+'1-tab emplois_ETAB'!L20","v":197.61},null,"tableau 1 : ligne 20"]
["Total ETPT OREMS",null,{"$f":"C3+C4","v":1009.66},null,"tableau 1 : ligne 20"]
[]
["Plafond Etat notifié MESR"]
[]
["charges de personnels T6",null,{"$f":"'6-tab CR_TF_ETAB'!D9","v":73619346.530000001},null,"onglet \"6-tab CR_TF_ETAB\" : cellule D 9"]
["dépenses de personnels T2",null,{"$f":"'2-tab_aut_budg_ETAB'!H11","v":74437711.080000013},null,"onglet \"2 -tab_aut_budg_ETAB\" : cellule H 10"]
["différence T 6 - T 2",null,{"$f":"C9-C10","v":-818364.55000001192}]
["dont rémunérations principales (64111)"]
[]
["dont cours complémentaires OREMS"]
["poids CC/MS OREMS"]
[]
["masse salariale notifiée MESR"]
[]
["masse salariale rémunérée hors SCSP"]
["% masse salariale rémunérée hors SCSP"]
[]
["dépenses totales section de fct",null,{"$f":"'6-tab CR_TF_ETAB'!D13","v":94019263.650000006},null,"onglet \"6-tab CR_TF_ETAB\" : cellule D 13"]
["% masse salariale sur total classe 6",null,{"$f":"IF(C22=0,0,C9/C22)","v":0.78302407051451095},null,"= ligne 9 / ligne 22"]
[]
["dépenses de fonctionnement (section de fct - MS)",null,{"$f":"+C22-C9","v":20399917.120000005},null,"= ligne 22 - ligne 9"]
["% fonctionnement sur total classe 6",null,{"$f":"IF(C22=0,0,C25/C22)","v":0.21697592948548905},null,"= ligne 25 / ligne 22"]
["vérif MS + fct",null,{"$f":"C23+C26","v":1},null,"= ligne 23 + ligne 26"]
[]
["dépenses décaissables section de fct",null,{"$f":"'6-tab CR_TF_ETAB'!D13-'6-tab CR_TF_ETAB'!D23","v":86500158.24000001},null,"onglet \"6-tab CR_TF_ETAB\" : cellule D 13 - cellule D 23 - cellule D 25"]
["% masse salariale sur dépenses décaissables",null,{"$f":"IF(C29=0,0,C9/C29)","v":0.85108915437748212},null,"= ligne 9 / ligne22"]
[]
["dépenses d'investissements",null,{"$f":"'6-tab CR_TF_ETAB'!D36","v":6729956.0600000005},null,"onglet \"6-tab CR_TF_ETAB\" : cellule D 36 (attention fusion cellules F36/F37/F38)"]
[]
["SCSP brute notifiée",null,null,null,"sans objet"]
["le"]
["mise en réserve"]
["% age de la mise en réserve"]
["mobilisation fonds de roulement"]
["SCSP nette"]
["dont masse salariale"]
["%age masse salariale"]
["dont fonctionnement"]
["%age fonctionnement"]
[]
["Poids de la SCSP sur les recettes encaissables",null,{"$f":"IF(C49=0,0,C39/C49)","v":0}]
["moyenne nationale 2013 : 83,6% rapport IGF IGAENR mars 2015"]
["recettes totales",null,{"$f":"'6-tab CR_TF_ETAB'!H13","v":96395211.780000001},null,"onglet \"6-tab CR_TF_ETAB\" : cellule H 13"]
[]
["recettes encaissables",null,{"$f":"'6-tab CR_TF_ETAB'!H13+'6-tab CR_TF_ETAB'!D24+'6-tab CR_TF_ETAB'!D27+'6-tab CR_TF_ETAB'!D26","v":91071358.219999999},null,"onglet \"6-tab CR_TF_ETAB\" : cellule  H 13 + cellule D 24 +cellule D 26 + cellule D 27"]
["% masse salariale sur recettes enc. Ratio MESR 81_83%",null,{"$f":"IF(C49=0,0,C9/C49)","v":0.80836991968604022},null,"=ligne 13 / ligne 54"]
[null,null,null,null,{"$f":"CONCATENATE(\"si % inférieur à \",F51*100,\" %\")","v":"si % inférieur à 80 %"},0.8]
["ressources propres (cl.7 -77 -78)",null,null,null,{"$f":"CONCATENATE(\"si % entre \",F51*100,\" et \",F52*100,\" %\")","v":"si % entre 80 et 83 %"},0.83]
["% masse salariale sur ressources propres (notion CRB)",null,null,null,{"$f":"CONCATENATE(\"si % supérieur à \",F52*100,\" %\")","v":"si % supérieur à 83 %"}]
[]
["recettes d'investissements",null,{"$f":"'6-tab CR_TF_ETAB'!H40-'6-tab CR_TF_ETAB'!H35","v":2748909.3099999996},null,"onglet \"6-tab CR_TF_ETAB\" : cellule H 40 - cellule H 35"]
["%investissements financés par subventions",null,{"$f":"IF(C32=0,0,C55/C32)","v":0.40845873070975136},null,"= ligne 55 / ligne 32"]
["% invsetissements financés par la CAF",null,{"$f":"IF(C32=0,0,C66/C32)","v":0.67923177198277207},null,"= ligne 66 / ligne 32"]
[]
["solde budgétaire (à compter de 2016)",null,{"$f":"-('2-tab_aut_budg_ETAB'!L30)","v":0},null,"onglet \"2-tab_aut_budg_ETAB\" : cellule L 30 (si déficit) ou cellule H 30 (si excédent)"]
[]
["résultat net comptable",null,{"$f":"'6-tab CR_TF_ETAB'!D14","v":2375948.1299999952},null,"onglet \"6-tab CR_TF_ETAB\" : cellule  H 14 (si perte) ou cellule D 14 (si bénéfice)"]
[]
["variation FDR",null,{"$f":"'6-tab CR_TF_ETAB'!H46","v":590153.22999999486},null,"onglet \"6-tab CR_TF_ETAB\" : cellule H 46"]
["vérif"]
[]
["CAF/IAF",null,{"$f":"'6-tab CR_TF_ETAB'!D28","v":4571199.9799999958},null,"onglet \"6-tab CR_TF_ETAB\" : cellule D 28"]
[]
["EBE"]
[]
["FDR ",null,{"$f":"'6-tab CR_TF_ETAB'!H49","v":14337031.039999995},null,"onglet \"6-tab CR_TF_ETAB\" : cellule H 49"]
["FDR en jours de dépenses décaissables",null,{"$f":"IF(C29=0,0,C70*360/C29)","v":59.668459334832285},null,{"$f":"CONCATENATE(\"si inférieur à \",F71,\" jours\")","v":"si inférieur à 20 jours"},20]
[null,null,null,null,{"$f":"CONCATENATE(\"si supérieur à \",F72,\" jours\")","v":"si supérieur à 30 jours"},30]
["TRESORERIE",null,{"$f":"'6-tab CR_TF_ETAB'!H51","v":14188111.000000002},null,"onglet \"6-tab CR_TF_ETAB\" : cellule H 51"]
["TRESORERIE en jours de dépenses décaissables",null,{"$f":"IF(C29=0,0,C73*360/C29)","v":59.048677643205203},null,{"$f":"CONCATENATE(\"si inférieur à \",F74,\" jours\")","v":"si inférieur à 30 jours"},30]
[null,null,null,null,{"$f":"CONCATENATE(\"si supérieur à \",F75,\" jours\")","v":"si supérieur à 31 jours"},31]
["BFR",null,{"$f":"C70-C73","v":148920.03999999352},null,"= ligne 70 - ligne 73"]

{"sheet":"1-tab emplois_ETAB","index":5,"n_rows":30,"n_cols":17,"rows_kept":30,"cut":false,"hidden":false,"merged":[[28,1,28,15],[29,1,29,16],[26,1,26,15],[27,1,27,15],[0,1,0,15],[1,1,1,15],[3,1,3,15],[20,9,20,11],[22,1,22,3],[22,5,22,7],[5,13,6,15],[6,1,7,1],[6,2,7,3],[18,1,18,3],[19,1,19,3],[5,5,5,7],[5,9,5,11],[6,5,6,7],[6,9,6,11],[8,1,10,1],[23,1,23,3],[23,5,23,7],[8,2,9,2],[11,1,11,3],[13,1,13,3],[15,1,17,1],[15,2,16,2],[20,5,20,7],[21,1,21,3],[21,5,21,7]]}
[null,"Tableau 1 - Université de Bretagne Sud (0561718N) : Etablissement principal + Fondation"]
[null,"Tableau des emplois présenté par l’établissement à l’appui du Compte Financier 2022"]
[]
[null,"POUR VOTE DE L'ORGANE DÉLIBÉRANT"]
[null,null,null,null,null,null,"(A)",null,null,null,"(B)",null,null,null,"( C ) = (A) + (B)"]
[null,null,null,null,null,"Emplois sous plafond Etat *",null,null,null,"Emplois financés hors SCSP",null,null,null,"Global"]
[null,"Catégories d'emplois","Nature des emplois",null,null,"En ETPT",null,null,null,"En ETPT"]
[null,null,null,null,null,"Budget initial\n2020","Dernier budget modifié\n2020","Compte Financier\n2020",null,"Budget initial\n2020","Dernier budget modifié\n2020","Compte Financier\n2020",null,"Budget initial\n2020","Dernier budget modifié\n2020","Compte Financier\n2020"]
[null,"Enseignants, enseignants-chercheurs, chercheurs","Permanents","Titulaires",null,371.5,372.5,371.43,null,0,0,0,null,{"$f":"F9+J9","v":371.5},{"$f":"G9+K9","v":372.5},371.43]
[null,null,null,"CDI",null,5.75,6,5.83,null,3.5,2.5,2.58,null,{"$f":"F10+J10","v":9.25},8.5,8.41]
[null,null,"Non permanents","CDD",null,69.75,70,69.28,null,76,75.5,71.25,null,145.75,145.5,140.53]
[null,"S/total EC",null,null,null,{"$f":"SUM(F9:F11)","v":447},{"$f":"SUM(G9:G11)","v":448.5},446.53999999999996,null,79.5,{"$f":"SUM(K9:K11)","v":78},{"$f":"SUM(L9:L11)","v":73.83},null,526.5,526.5,520.37]
[]
[null,"Elèves fonctionnaires stagiaires des écoles nationales supérieures (ENS)",null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"G14+K14","v":0},{"$f":"H14+L14","v":0}]
[]
[null,"BIATSS (personnels de bibliothèques, ingénieurs, administratifs, techniques et de service)","Permanents","Titulaires",null,288.7,287.5,283.57,null,null,null,null,null,288.7,{"$f":"G16+K16","v":287.5},{"$f":"H16+L16","v":283.57}]
[null,null,null,"CDI",null,16.5,19,18.75,null,16.3,16.3,16.14,null,{"$f":"F17+J17","v":32.799999999999997},{"$f":"G17+K17","v":35.299999999999997},{"$f":"H17+L17","v":34.89}]
[null,null,"Non permanents","CDD",null,67,66,63.19,null,100,108.7,107.64,null,167,174.7,170.82999999999998]
[null,"S/total Biatss",null,null,null,{"$f":"SUM(F16:F18)","v":372.2},{"$f":"SUM(G16:G18)","v":372.5},365.51,null,{"$f":"SUM(J16:J18)","v":116.3},{"$f":"SUM(K16:K18)","v":125},123.78,null,488.5,497.5,489.28999999999996]
[null,"Totaux",null,null,null,{"$f":"F12+F19","v":819.2},{"$f":"G12+G19","v":821},812.05,"(1)",{"$f":"J12+J19","v":195.8},{"$f":"K12+K19","v":203},{"$f":"L12+L19","v":197.61},null,1015,1024,1009.66]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Plafond global des emplois voté par le CA **","Plafond global des emplois voté par le CA **","Plafond global des emplois voté par le CA **","(2)"]
[null,"Rappel du plafond des emplois fixé par l'Etat au Budget initial",null,null,null,825,null,null,"(3)",{"$f":"IF(F20>F22,\"! BI : Nombre total d'emplois sous plafond > à la notification de l'Etat\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(P20>O20,\"ATTENTION le plafond d'emploi au COFI doit être inférieur ou égal au plafond d'emploi du dernier BR\",\"\")","v":""}]
[null,"Rappel du plafond des emplois fixé par l'Etat au dernier Budget modifié",null,null,null,828,null,null,"(3)",{"$f":"IF(G20>F23,\"BR : ! Nombre total d'emplois sous plafond > à la notification de l'Etat\",\"\")","v":""}]
[null,"Rappel du plafond des emplois fixé par l'Etat au Compte financier",null,null,null,828,null,null,"(3)",{"$f":"IF(H20>F24,\"COFI : ! Nombre total d'emplois sous plafond > à la notification de l'Etat\",\"\")","v":""}]
[]
[null,"Note sur les modalités de renseignement du tableau"]
[null,"Ce tableau doit être annexé au budget de l'établissement et, en cas de modification, aux budgets rectificatifs. Les chiffres qu'il contient doivent être exprimés en équivalents temps plein travaillés (ETPT). Le guide de décompte des emplois élaboré par la DAF et la DGESIP précise les régles de décompte des emplois en ETPT en fonction des catégories de personnel."]
[null,"Seul est soumis au vote du conseil d'administration le plafond global des emplois (case annotée (2))"]
[null,"Le nombre total d'emplois sous plafond Etat (case annotée (1)) ne peut être supérieur au plafond des emplois Etat qui a été notifié à l'établissement et rappelé en case (3)"]
[null,"* : cf. article R719-54 du code de l'éducation : \"plafond d'emplois fixé par l'État relatif aux emplois financés par l'État\"\n** : cf. article R719-54 du code de l'éducation : \"plafond d'autorisation de l'ensemble des emplois rémunérés par l'établissement\""]

{"sheet":"2-tab_aut_budg_ETAB","index":6,"n_rows":67,"n_cols":13,"rows_kept":67,"cut":false,"hidden":false,"merged":[[0,1,0,12],[1,1,1,12],[7,1,7,7],[7,9,7,12],[8,2,8,3],[8,4,8,5],[8,6,8,7],[39,1,40,1],[39,2,39,3],[39,4,39,5],[53,1,54,1],[53,2,53,3],[53,4,53,5]]}
[null,"Tableau 2 - Université de Bretagne Sud (0561718N) : Etablissement principal + Fondation"]
[null," Autorisations budgétaires - Compte Financier 2022"]
[]
[]
[null,"POUR VOTE DE L'ORGANE DÉLIBÉRANT"]
[]
[]
[null,"Dépenses"]
[null,null,"Budget initial\n2022",null,"Dernier Budget Modifié\n2022",null,"Compte Financier\n2022",null,null," Budget initial \n2022"," Dernier Budget Modifié \n2022"," Compte Financier \n2022"]
[null,null,"AE","CP","AE","CP","AE","CP",null,"Montants","Montants","Montants"]
[null,"Personnel",{"$f":"'2-tab_aut_budg_PRINC'!C11+'2-tab_aut_budg_FU'!C11","v":76136253.700000003},{"$f":"'2-tab_aut_budg_PRINC'!D11+'2-tab_aut_budg_FU'!D11","v":76136253.700000003},{"$f":"'2-tab_aut_budg_PRINC'!E11+'2-tab_aut_budg_FU'!E11","v":75723453.469999999},{"$f":"'2-tab_aut_budg_PRINC'!F11+'2-tab_aut_budg_FU'!F11","v":75722346.359999999},{"$f":"'2-tab_aut_budg_PRINC'!G11+'2-tab_aut_budg_FU'!G11","v":74453544.580000013},{"$f":"'2-tab_aut_budg_PRINC'!H11+'2-tab_aut_budg_FU'!H11","v":74437711.080000013},null,{"$f":"SUM(J12:J16)","v":95361369.729999989},{"$f":"SUM(K12:K16)","v":94625620.689999998},90626521,"Recettes globalisées"]
[null,"dont contributions employeur au CAS Pension",{"$f":"'2-tab_aut_budg_PRINC'!C12+'2-tab_aut_budg_FU'!C12","v":20455893},{"$f":"'2-tab_aut_budg_PRINC'!D12+'2-tab_aut_budg_FU'!D12","v":20455893},{"$f":"'2-tab_aut_budg_PRINC'!E12+'2-tab_aut_budg_FU'!E12","v":19827314},{"$f":"'2-tab_aut_budg_PRINC'!F12+'2-tab_aut_budg_FU'!F12","v":19827314},{"$f":"'2-tab_aut_budg_PRINC'!G12+'2-tab_aut_budg_FU'!G12","v":19889158.25},{"$f":"'2-tab_aut_budg_PRINC'!H12+'2-tab_aut_budg_FU'!H12","v":19889158.25},null,{"$f":"'2-tab_aut_budg_PRINC'!J12+'2-tab_aut_budg_FU'!J12","v":66458360},{"$f":"'2-tab_aut_budg_PRINC'!K12+'2-tab_aut_budg_FU'!K12","v":67419953},{"$f":"'2-tab_aut_budg_PRINC'!L12+'2-tab_aut_budg_FU'!L12","v":68012462},"Subvention pour charges de service public"]
[null,null,null,null,null,null,null,null,null,{"$f":"'2-tab_aut_budg_PRINC'!J13+'2-tab_aut_budg_FU'!J13","v":4380495.5999999996},{"$f":"'2-tab_aut_budg_PRINC'!K13+'2-tab_aut_budg_FU'!K13","v":3237122.3},{"$f":"'2-tab_aut_budg_PRINC'!L13+'2-tab_aut_budg_FU'!L13","v":1917931.1500000001},"Autres financements de l'Etat"]
[null,null,null,null,null,null,null,null,null,{"$f":"'2-tab_aut_budg_PRINC'!J14+'2-tab_aut_budg_FU'!J14","v":600000},{"$f":"'2-tab_aut_budg_PRINC'!K14+'2-tab_aut_budg_FU'!K14","v":600000},{"$f":"'2-tab_aut_budg_PRINC'!L14+'2-tab_aut_budg_FU'!L14","v":473570.35},"Fiscalité affectée"]
[null,"Fonctionnement et intervention",{"$f":"'2-tab_aut_budg_PRINC'!C15+'2-tab_aut_budg_FU'!C15","v":13871894.92},{"$f":"'2-tab_aut_budg_PRINC'!D15+'2-tab_aut_budg_FU'!D15","v":13660886.58},{"$f":"'2-tab_aut_budg_PRINC'!E15+'2-tab_aut_budg_FU'!E15","v":14395473.24},{"$f":"'2-tab_aut_budg_PRINC'!F15+'2-tab_aut_budg_FU'!F15","v":13387426.74},{"$f":"'2-tab_aut_budg_PRINC'!G15+'2-tab_aut_budg_FU'!G15","v":12840939.109999999},{"$f":"'2-tab_aut_budg_PRINC'!H15+'2-tab_aut_budg_FU'!H15","v":11888797.76},null,{"$f":"'2-tab_aut_budg_PRINC'!J15+'2-tab_aut_budg_FU'!J15","v":7803541.1299999999},{"$f":"'2-tab_aut_budg_PRINC'!K15+'2-tab_aut_budg_FU'!K15","v":6843446.3700000001},{"$f":"'2-tab_aut_budg_PRINC'!L15+'2-tab_aut_budg_FU'!L15","v":6837311.0800000001},"Autres financements publics"]
[null,null,null,null,null,null,null,null,null,{"$f":"'2-tab_aut_budg_PRINC'!J16+'2-tab_aut_budg_FU'!J16","v":16118973},{"$f":"'2-tab_aut_budg_PRINC'!K16+'2-tab_aut_budg_FU'!K16","v":16525099.02},{"$f":"'2-tab_aut_budg_PRINC'!L16+'2-tab_aut_budg_FU'!L16","v":13385246.42},"Recettes propres"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J19:J21)","v":0},2221464,{"$f":"L19+L20+L21","v":2221464},"Recettes fléchées **"]
[null,null,null,null,null,null,null,null,null,{"$f":"'2-tab_aut_budg_PRINC'!J19+'2-tab_aut_budg_FU'!J19","v":0},{"$f":"'2-tab_aut_budg_PRINC'!K19+'2-tab_aut_budg_FU'!K19","v":0},{"$f":"'2-tab_aut_budg_PRINC'!L19+'2-tab_aut_budg_FU'!L19","v":0},"Financements de l'Etat fléchés"]
[null,"Investissement",{"$f":"'2-tab_aut_budg_PRINC'!C20+'2-tab_aut_budg_FU'!C20","v":7579491.8799999999},{"$f":"'2-tab_aut_budg_PRINC'!D20+'2-tab_aut_budg_FU'!D20","v":7303449.6200000001},{"$f":"'2-tab_aut_budg_PRINC'!E20+'2-tab_aut_budg_FU'!E20","v":7932552.1500000004},{"$f":"'2-tab_aut_budg_PRINC'!F20+'2-tab_aut_budg_FU'!F20","v":8525126.7300000004},{"$f":"'2-tab_aut_budg_PRINC'!G20+'2-tab_aut_budg_FU'!G20","v":6585960.7999999998},{"$f":"'2-tab_aut_budg_PRINC'!H20+'2-tab_aut_budg_FU'!H20","v":6413571.3899999997},null,{"$f":"'2-tab_aut_budg_PRINC'!J20+'2-tab_aut_budg_FU'!J20","v":0},{"$f":"'2-tab_aut_budg_PRINC'!K20+'2-tab_aut_budg_FU'!K20","v":2221464},{"$f":"'2-tab_aut_budg_PRINC'!L20+'2-tab_aut_budg_FU'!L20","v":2221464},"Autres financements publics fléchés"]
[null,null,null,null,null,null,null,null,null,{"$f":"'2-tab_aut_budg_PRINC'!J21+'2-tab_aut_budg_FU'!J21","v":0},{"$f":"'2-tab_aut_budg_PRINC'!K21+'2-tab_aut_budg_FU'!K21","v":0},{"$f":"'2-tab_aut_budg_PRINC'!L21+'2-tab_aut_budg_FU'!L21","v":0},"Recettes propres fléchées"]
[]
[null,"Enveloppes* destinées à des contrats de recherche",{"$f":"C24+C25+C26","v":0},{"$f":"D24+D25+D26","v":0},0,0,{"$f":"C23+E23","v":0},{"$f":"D23+F23","v":0}]
[null,"Personnel",{"$f":"'2-tab_aut_budg_PRINC'!C24+'2-tab_aut_budg_FU'!C24","v":0},{"$f":"'2-tab_aut_budg_PRINC'!D24+'2-tab_aut_budg_FU'!D24","v":0},{"$f":"'2-tab_aut_budg_PRINC'!E24+'2-tab_aut_budg_FU'!E24","v":0},{"$f":"'2-tab_aut_budg_PRINC'!F24+'2-tab_aut_budg_FU'!F24","v":0},{"$f":"'2-tab_aut_budg_PRINC'!G24+'2-tab_aut_budg_FU'!G24","v":0},{"$f":"'2-tab_aut_budg_PRINC'!H24+'2-tab_aut_budg_FU'!H24","v":0}]
[null,"Fonctionnement",{"$f":"'2-tab_aut_budg_PRINC'!C25+'2-tab_aut_budg_FU'!C25","v":0},{"$f":"'2-tab_aut_budg_PRINC'!D25+'2-tab_aut_budg_FU'!D25","v":0},{"$f":"'2-tab_aut_budg_PRINC'!E25+'2-tab_aut_budg_FU'!E25","v":0},{"$f":"'2-tab_aut_budg_PRINC'!F25+'2-tab_aut_budg_FU'!F25","v":0},{"$f":"'2-tab_aut_budg_PRINC'!G25+'2-tab_aut_budg_FU'!G25","v":0},{"$f":"'2-tab_aut_budg_PRINC'!H25+'2-tab_aut_budg_FU'!H25","v":0}]
[null,"Investissement",{"$f":"'2-tab_aut_budg_PRINC'!C26+'2-tab_aut_budg_FU'!C26","v":0},{"$f":"'2-tab_aut_budg_PRINC'!D26+'2-tab_aut_budg_FU'!D26","v":0},{"$f":"'2-tab_aut_budg_PRINC'!E26+'2-tab_aut_budg_FU'!E26","v":0},{"$f":"'2-tab_aut_budg_PRINC'!F26+'2-tab_aut_budg_FU'!F26","v":0},{"$f":"'2-tab_aut_budg_PRINC'!G26+'2-tab_aut_budg_FU'!G26","v":0},{"$f":"'2-tab_aut_budg_PRINC'!H26+'2-tab_aut_budg_FU'!H26","v":0}]
[]
[null,"TOTAL DES DÉPENSES",{"$f":"C20+C15+C11+C23","v":97587640.5},{"$f":"D20+D15+D11+D23","v":97100589.900000006},98051478.859999999,97634899.829999998,93880444.49000001,92740080.230000019,null,{"$f":"J11+J18","v":95361369.729999989},{"$f":"K11+K18","v":96847084.689999998},{"$f":"L11+L18","v":92847985},"TOTAL DES RECETTES"]
[]
[null,"Solde budgétaire (excédent)",null,{"$f":"IF(J28-D28>=0,J28-D28,0)","v":0},null,{"$f":"IF(K28-F28>=0,K28-F28,0)","v":0},null,{"$f":"IF(L28-H28>=0,L28-H28,0)","v":107904.76999998093},null,{"$f":"IF(D28-J28>0,D28-J28,0)","v":1739220.1700000167},{"$f":"IF(F28-K28>0,F28-K28,0)","v":787815.1400000006},{"$f":"IF(H28-L28>0,H28-L28,0)","v":0},"Solde budgétaire (déficit)"]
[]
[null,"* Chaque enveloppe peut être détaillée en fonction des besoins des organismes.",{"$f":"IF('3-tab_destination_origine_ETAB'!C31=\"\",\"\",\"! Incohérence total Personnel AE avec Tab3 AGR\")","v":""},{"$f":"IF('3-tab_destination_origine_ETAB'!D31=\"\",\"\",\"! Incohérence total Personnel CP avec Tab3 AGR\")","v":""},null,null,null,null,null,{"$f":"IF('3-tab_destination_origine_ETAB'!C53=\"\",\"\",\"! Incohérence Subv charges serv public avec Tab3 AGR\")","v":""},{"$f":"IF('3-tab_destination_origine_ETAB'!D53=\"\",\"\",\"! Incohérence Autres financ. Etat avec Tab3 AGR\")","v":""}]
[null,"** Montant issu du tableau \"Opérations sur recettes fléchées\" (tableau 8)",{"$f":"IF('3-tab_destination_origine_ETAB'!E31=\"\",\"\",\"! Incohérence total Fonct AE avec Tab3 AGR\")","v":""},{"$f":"IF('3-tab_destination_origine_ETAB'!F31=\"\",\"\",\"! Incohérence total Fonct CP avec Tab3 AGR\")","v":""},null,null,null,null,null,{"$f":"IF('3-tab_destination_origine_ETAB'!E53=\"\",\"\",\"! Incohérence Fiscalité affectée avec Tab3 AGR\")","v":""},{"$f":"IF('3-tab_destination_origine_ETAB'!F531=\"\",\"\",\"! Incohérence Autres financements publics avec Tab3 AGR\")","v":""}]
[null,null,{"$f":"IF('3-tab_destination_origine_ETAB'!G31=\"\",\"\",\"! Incohérence total Invest AE avec Tab3 AGR\")","v":""},{"$f":"IF('3-tab_destination_origine_ETAB'!H31=\"\",\"\",\"! Incohérence total Invest CP avec Tab3 AGR\")","v":""},null,null,null,null,null,{"$f":"IF('3-tab_destination_origine_ETAB'!G53=\"\",\"\",\"! Incohérence Recettes propres avec Tab3 AGR\")","v":""},{"$f":"IF('3-tab_destination_origine_ETAB'!H53=\"\",\"\",\"! Incohérence Financements Etat fléchés avec Tab3 AGR\")","v":""}]
[null,null,null,{"$f":"\"BI : Différence charges de personnel entre tableau 2 et tableau 6 est de : \"&'6-tab CR_TF_ETAB'!B9-ROUND('2-tab_aut_budg_ETAB'!D11+'2-tab_aut_budg_ETAB'!D24,0)","v":"BI : Différence charges de personnel entre tableau 2 et tableau 6 est de : -792705"},null,null,null,null,null,{"$f":"IF('3-tab_destination_origine_ETAB'!I53=\"\",\"\",\"! Incohérence Autres financ. fléchés avec Tab3 AGR\")","v":""},{"$f":"IF('3-tab_destination_origine_ETAB'!J53=\"\",\"\",\"! Incohérence Recettes propres fléchées avec Tab3 AGR\")","v":""}]
[null,null,null,{"$f":"\"BR : Différence charges de personnel entre tableau 2 et tableau 6 est de : \"&'6-tab CR_TF_ETAB'!C9-ROUND('2-tab_aut_budg_ETAB'!F11+'2-tab_aut_budg_ETAB'!F24,0)","v":"BR : Différence charges de personnel entre tableau 2 et tableau 6 est de : -791597,230000004"}]
[null,null,null,{"$f":"\"COFI : Différence charges de personnel entre tableau 2 et tableau 6 est de : \"&'6-tab CR_TF_ETAB'!D9-ROUND('2-tab_aut_budg_ETAB'!H11+'2-tab_aut_budg_ETAB'!H24,0)","v":"COFI : Différence charges de personnel entre tableau 2 et tableau 6 est de : -818364,469999999"}]
[]
[null,"Comparaison COFI / BI"]
[null,"Comparaison COFI / BI","AE",null,"CP",null,null,null,null,null,"Comparaison COFI / BI"]
[null,null,"en valeur","en %","en valeur","en %",null,null,null,null,"en valeur","en %"]
[null,"Personnel",{"$f":"G11-C11","v":-1682709.1199999899},{"$f":"IF(G11=0,0,(G11-C11)/G11)","v":-2.2600792608227352E-2},{"$f":"H11-D11","v":-1698542.6199999899},{"$f":"IF(H11=0,0,(H11-D11)/H11)","v":-2.2818308023664576E-2},"Recettes globalisées",null,null,null,{"$f":"L11-J11","v":-4734848.7299999893},{"$f":"IF(L11=0,0,(L11-J11)/L11)","v":-5.2245729812358012E-2}]
[null,"Fonctionnement",{"$f":"G15-C15","v":-1030955.8100000005},{"$f":"IF(G15=0,0,(G15-C15)/G15)","v":-8.0286636449909979E-2},{"$f":"H15-D15","v":-1772088.8200000003},{"$f":"IF(H15=0,0,(H15-D15)/H15)","v":-0.1490553423292483},"Subvention pour charges de service public",null,null,null,{"$f":"L12-J12","v":1554102},{"$f":"IF(L12=0,0,(L12-J12)/L12)","v":2.2850253531477804E-2}]
[null,"Investissement",{"$f":"+G20-C20","v":-993531.08000000007},{"$f":"IF(G20=0,0,(G20-C20)/G20)","v":-0.15085590548914293},{"$f":"+H20-D20","v":-889878.23000000045},{"$f":"IF(H20=0,0,(H20-D20)/H20)","v":-0.13874925153051124},"Autres financements de l'Etat",null,null,null,-2462564.4499999993,-1.2839691612496096]
[null,"Enveloppes Recherche",{"$f":"G14-C14","v":0},{"$f":"IF(G14=0,0,(G14-C14)/G14)","v":0},{"$f":"H14-D14","v":0},{"$f":"IF(H14=0,0,(H14-D14)/H14)","v":0},"Fiscalité affectée",null,null,null,-126429.65000000002,-0.26697121135223106]
[null,"Personnel",null,-8.0286636449909979E-2,null,-0.1490553423292483,"Autres financements publics",null,null,null,-966230.04999999981,-0.1413172574268772]
[null,"Fonctionnement",0,0,0,0,"Recettes propres",null,null,null,-2733726.58,-0.20423431098850103]
[null,"Investissement",0,0,0,0]
[null,null,null,null,null,null,"Recettes fléchées **",null,null,null,2221464,1]
[null,null,null,null,null,null,"Financements de l'Etat fléchés",null,null,null,0,0]
[null,null,null,null,null,null,"Autres financements publics fléchés",null,null,null,2221464,1]
[null,null,null,null,null,null,"Recettes propres fléchées",null,null,null,0,0]
[null,"Comparaison COFI / BR"]
[null,"Comparaison COFI / BR","AE",null,"CP",null,null,null,null,null,"Comparaison COFI / BR"]
[null,null,"en valeur","en %","en valeur","en %",null,null,null,null,"en valeur","en %"]
[null,"Personnel",{"$f":"G11-E11","v":-1269908.8899999857},{"$f":"IF(G11=0,0,(G11-E11)/G11)","v":-1.705639264273676E-2},{"$f":"H11-F11","v":-1284635.2799999863},{"$f":"IF(H11=0,0,(H11-F11)/H11)","v":-1.725785574759758E-2},"Recettes globalisées",null,null,null,{"$f":"L11-K11","v":-3999099.6899999976},{"$f":"IF(L11=0,0,(L11-K11)/L11)","v":-4.4127255971792158E-2}]
[null,"Fonctionnement",{"$f":"G15-E15","v":-1554534.1300000008},{"$f":"IF(G15=0,0,(G15-E15)/G15)","v":-0.12106078197889694},{"$f":"H15-F155","v":11888797.76},{"$f":"IF(H15=0,0,(H15-F15)/H15)","v":-0.12605387106862523},"Subvention pour charges de service public",null,null,null,592509,{"$f":"IF(L12=0,0,(L12-K12)/L12)","v":8.7117710868928697E-3}]
[null,"Investissement",{"$f":"+G20-E20","v":-1346591.3500000006},{"$f":"IF(G20=0,0,(G20-E20)/G20)","v":-0.20446391815754517},{"$f":"+H20-F20","v":-2111555.3400000008},{"$f":"IF(H20=0,0,(H20-F20)/H20)","v":-0.32923237485004447},"Autres financements de l'Etat",null,null,null,-1319191.1499999997,-0.68781986777783943]
[null,"Enveloppes Recherche",null,null,null,null,"Fiscalité affectée",null,null,null,-126429.65000000002,-0.26697121135223106]
[null,"Personnel",null,null,null,null,"Autres financements publics",null,null,null,-6135.2900000000373,-8.9732497588804118E-4]
[null,"Fonctionnement",null,null,null,null,"Recettes propres",null,null,null,-3139852.5999999996,-0.23457562912764066]
[null,"Investissement"]
[null,null,null,null,null,null,"Recettes fléchées **",null,null,null,{"$f":"L18-K18","v":0},0]
[null,null,null,null,null,null,"Financements de l'Etat fléchés",null,null,null,{"$f":"L19-K19","v":0},0]
[null,null,null,null,null,null,"Autres financements publics fléchés",null,null,null,{"$f":"L20-K20","v":0},0]
[null,null,null,null,null,null,"Recettes propres fléchées",null,null,null,{"$f":"L21-K21","v":0},0]
[null,null,null,null,null,null,null,null,null,null,"m"]

{"sheet":"2-tab_aut_budg_PRINC","index":7,"n_rows":66,"n_cols":13,"rows_kept":66,"cut":false,"hidden":false,"merged":[[0,1,0,12],[1,1,1,12],[7,1,7,7],[7,9,7,12],[8,2,8,3],[8,4,8,5],[8,6,8,7],[39,1,40,1],[39,2,39,3],[39,4,39,5],[53,1,54,1],[53,2,53,3],[53,4,53,5]]}
[null,"Tableau 2 - Université de Bretagne Sud (0561718N) : Etablissement principal"]
[null," Autorisations budgétaires - Compte Financier 2022"]
[]
[]
[null,"POUR VOTE DE L'ORGANE DÉLIBÉRANT"]
[]
[]
[null,"Dépenses"]
[null,null,"Budget initial\n2022",null,"Dernier Budget Modifié\n2022",null,"Compte Financier\n2022",null,null," Budget initial \n2022"," Dernier Budget Modifié \n2022"," Compte Financier \n2022"]
[null,null,"AE","CP","AE","CP","AE","CP",null,"Montants","Montants","Montants"]
[null,"Personnel",75943253.700000003,75943253.700000003,75609975.230000004,75608868.120000005,74348490.900000006,74332657.400000006,null,{"$f":"SUM(J12:J16)","v":94730369.729999989},{"$f":"SUM(K12:K16)","v":94307688.689999998},90300588.679999992,"Recettes globalisées"]
[null,"dont contributions employeur au CAS Pension",20455893,20455893,19827314,19827314,19889158.25,19889158.25,null,66458360,67419953,68012462,"Subvention pour charges de service public"]
[null,null,null,null,0,0,null,null,null,4380495.5999999996,3217669.3,1897410.83,"Autres financements de l'Etat"]
[null,null,null,null,0,0,null,null,null,600000,600000,473570.35,"Fiscalité affectée"]
[null,"Fonctionnement et intervention",13555894.92,13402561.58,14252376.359999999,13238588.859999999,12728316.199999999,11771498.43,null,7668541.1299999999,6783379.3700000001,6778311.0800000001,"Autres financements publics"]
[null,null,null,null,0,0,null,null,null,15622973,16286687.02,13138834.42,"Recettes propres"]
[null,null,null,null,0,0]
[null,null,null,null,0,0,null,null,null,{"$f":"SUM(J19:J21)","v":0},{"$f":"SUM(K19:K21)","v":2221464},2221464,"Recettes fléchées **"]
[null,null,null,null,0,0,null,null,null,null,null,0,"Financements de l'Etat fléchés"]
[null,"Investissement",7504491.8799999999,7258449.6200000001,7930552.1500000004,8523126.7300000004,6584973.1399999997,6412893.3899999997,null,null,2221464,2221464,"Autres financements publics fléchés"]
[null,null,null,null,null,null,null,null,null,null,null,0,"Recettes propres fléchées"]
[]
[null,"Enveloppes* destinées à des contrats de recherche",{"$f":"C24+C25+C26","v":0},{"$f":"D24+D25+D26","v":0},0,0,{"$f":"C23+E23","v":0},{"$f":"D23+F23","v":0}]
[null,"Personnel"]
[null,"Fonctionnement"]
[null,"Investissement"]
[]
[null,"TOTAL DES DÉPENSES",{"$f":"C20+C15+C11+C23","v":97003640.5},{"$f":"D20+D15+D11+D23","v":96604264.900000006},{"$f":"E20+E15+E11+E23","v":97792903.74000001},97370583.710000008,{"$f":"G20+G15+G11+G23","v":93661780.24000001},{"$f":"H20+H15+H11+H23","v":92517049.219999999},null,{"$f":"J11+J18","v":94730369.729999989},{"$f":"K11+K18","v":96529152.689999998},{"$f":"L11+L18","v":92522052.679999992},"TOTAL DES RECETTES"]
[]
[null,"Solde budgétaire (excédent)",null,{"$f":"IF(J28-D28>=0,J28-D28,0)","v":0},null,{"$f":"IF(K28-F28>=0,K28-F28,0)","v":0},null,{"$f":"IF(L28-H28>=0,L28-H28,0)","v":5003.4599999934435},null,{"$f":"IF(D28-J28>0,D28-J28,0)","v":1873895.1700000167},{"$f":"IF(F28-K28>0,F28-K28,0)","v":841431.02000001073},{"$f":"IF(H28-L28>0,H28-L28,0)","v":0},"Solde budgétaire (déficit)"]
[]
[null,"* Chaque enveloppe peut être détaillée en fonction des besoins des organismes.",{"$f":"IF('3-tab_destination_origine_PRINC'!C31=\"\",\"\",\"! Incohérence total Personnel AE avec Tab3 PRINC\")","v":""},{"$f":"IF('3-tab_destination_origine_PRINC'!D31=\"\",\"\",\"! Incohérence total Personnel CP avec Tab3 PRINC\")","v":""},null,null,null,{"$f":"IF(AND(CONTROLES_TAB3_3_PRINC=\"\",CONTROLES_TAB3_4_PRINC=\"\"),\"\",\"! Incohérence solde budgétaire Tab3 PRINC\")","v":""},null,{"$f":"IF('3-tab_destination_origine_PRINC'!C53=\"\",\"\",\"! Incohérence Subv charges serv public avec Tab3 PRINC\")","v":""},{"$f":"IF('3-tab_destination_origine_PRINC'!D53=\"\",\"\",\"! Incohérence Autres financ. Etat avec Tab3 PRINC\")","v":""}]
[null,"** Montant issu du tableau \"Opérations sur recettes fléchées\" (tableau 8)",{"$f":"IF('3-tab_destination_origine_PRINC'!E31=\"\",\"\",\"! Incohérence total Fonct AE avec Tab3 PRINC\")","v":""},{"$f":"IF('3-tab_destination_origine_PRINC'!F31=\"\",\"\",\"! Incohérence total Fonct CP avec Tab3 PRINC\")","v":""},null,null,null,null,null,{"$f":"IF('3-tab_destination_origine_PRINC'!E53=\"\",\"\",\"! Incohérence Fiscalité affectée avec Tab3 PRINC\")","v":""},{"$f":"IF('3-tab_destination_origine_PRINC'!F531=\"\",\"\",\"! Incohérence Autres financements publics avec Tab3 PRINC\")","v":""}]
[null,null,{"$f":"IF('3-tab_destination_origine_PRINC'!G31=\"\",\"\",\"! Incohérence total Invest AE avec Tab3 PRINC\")","v":""},{"$f":"IF('3-tab_destination_origine_PRINC'!H31=\"\",\"\",\"! Incohérence total Invest CP avec Tab3 PRINC\")","v":""},null,null,null,null,null,{"$f":"IF('3-tab_destination_origine_PRINC'!G53=\"\",\"\",\"! Incohérence Recettes propres avec Tab3 PRINC\")","v":""}]
[null,null,{"$f":"\"BI : Différence charges de personnel entre tableau 2 et tableau 6 est de : \"&'6-tab CR_TF_PRINC'!B9-ROUND('2-tab_aut_budg_PRINC'!D11+'2-tab_aut_budg_PRINC'!D24,0)","v":"BI : Différence charges de personnel entre tableau 2 et tableau 6 est de : -789810"},{"$f":"IF(D12=\"\",IF(ROUND(D12,0)<>ROUND('6-tab CR_TF_PRINC'!B10,0),\"! Incohérence pensions civ. BI Tab6 PRINC\",\"\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF('3-tab_destination_origine_PRINC'!I53=\"\",\"\",\"! Incohérence Autres financ. fléchés avec Tab3 PRINC\")","v":""}]
[null,null,{"$f":"\"BR : Différence charges de personnel entre tableau 2 et tableau 6 est de : \"&'6-tab CR_TF_PRINC'!C9-ROUND('2-tab_aut_budg_PRINC'!F11+'2-tab_aut_budg_PRINC'!F24,0)","v":"BR : Différence charges de personnel entre tableau 2 et tableau 6 est de : -788702,469999999"},{"$f":"IF(F12=\"\",IF(ROUND(F12,0)<>ROUND('6-tab CR_TF_PRINC'!C10,0),\"! Incohérence pensions civ. BR Tab6 PRINC\",\"\"),\"\")","v":""}]
[null,null,{"$f":"\"COFI : Différence charges de personnel entre tableau 2 et tableau 6 est de : \"&'6-tab CR_TF_PRINC'!D9-ROUND('2-tab_aut_budg_PRINC'!H11+'2-tab_aut_budg_PRINC'!H24,0)","v":"COFI : Différence charges de personnel entre tableau 2 et tableau 6 est de : -816889,840000004"},{"$f":"IF(H12=\"\",IF(ROUND(H12,0)<>ROUND('6-tab CR_TF_PRINC'!D10,0),\"! Incohérence pensions civ. total COFI Tab6 PRINC\",\"\"),\"\")","v":""}]
[]
[null,"Comparaison COFI / BI"]
[null,"Comparaison COFI / BI","AE",null,"CP",null,null,null,null,null,"Comparaison COFI / BI"]
[null,null,"en valeur","en %","en valeur","en %",null,null,null,null,"en valeur","en %"]
[null,"Personnel",{"$f":"G11-C11","v":-1594762.799999997},{"$f":"IF(G11=0,0,(G11-C11)/G11)","v":-2.1449834162000414E-2},{"$f":"H11-D11","v":-1610596.299999997},{"$f":"IF(H11=0,0,(H11-D11)/H11)","v":-2.1667411825908929E-2},"Recettes globalisées",null,null,null,{"$f":"L11-J11","v":-4429781.049999997},{"$f":"IF(L11=0,0,(L11-J11)/L11)","v":-4.9055948745781723E-2}]
[null,"Fonctionnement",{"$f":"+G15-C15","v":-827578.72000000067},{"$f":"IF(G15=0,0,(G15-C15)/G15)","v":-6.5018711587319047E-2},{"$f":"+H15-D15","v":-1631063.1500000004},{"$f":"IF(H15=0,0,(H15-D15)/H15)","v":-0.1385603676285756},"Subvention pour charges de service public",null,null,null,{"$f":"L12-J12","v":1554102},{"$f":"IF(L12=0,0,(L12-J12)/L12)","v":2.2850253531477804E-2}]
[null,"Investissement",{"$f":"+G20-C20","v":-919518.74000000022},{"$f":"IF(G20=0,0,(G20-C20)/G20)","v":-0.13963895075204516},{"$f":"+H20-D20","v":-845556.23000000045},{"$f":"IF(H20=0,0,(H20-D20)/H20)","v":-0.13185253185691903},"Autres financements de l'Etat",null,null,null,-2483084.7699999996,-1.3086700733124832]
[null,"Enveloppes Recherche",{"$f":"G14-C14","v":0},{"$f":"IF(G14=0,0,(G14-C14)/G14)","v":0},{"$f":"H14-D14","v":0},{"$f":"IF(H14=0,0,(H14-D14)/H14)","v":0},"Fiscalité affectée",null,null,null,-126429.65000000002,-0.26697121135223106]
[null,"Personnel",null,-6.5018711587319047E-2,null,-0.1385603676285756,"Autres financements publics",null,null,null,-890230.04999999981,-0.13133508325203627]
[null,"Fonctionnement",0,0,0,0,"Recettes propres",null,null,null,-2484138.58,-0.18906841357393406]
[null,"Investissement",0,0,0,0]
[null,null,null,null,null,null,"Recettes fléchées **",null,null,null,2221464,1]
[null,null,null,null,null,null,"Financements de l'Etat fléchés",null,null,null,0,0]
[null,null,null,null,null,null,"Autres financements publics fléchés",null,null,null,2221464,1]
[null,null,null,null,null,null,"Recettes propres fléchées",null,null,null,0,0]
[null,"Comparaison COFI / BR"]
[null,"Comparaison COFI / BR","AE",null,"CP",null,null,null,null,null,"Comparaison COFI / BR"]
[null,null,"en valeur","en %","en valeur","en %",null,null,null,null,"en valeur","en %"]
[null,"Personnel",{"$f":"G11-E11","v":-1261484.3299999982},{"$f":"IF(G11=0,0,(G11-E11)/G11)","v":-1.6967181374222057E-2},{"$f":"H11-F11","v":-1276210.7199999988},{"$f":"IF(H11=0,0,(H11-F11)/H11)","v":-1.7168910202314369E-2},"Recettes globalisées",null,null,null,{"$f":"L11-K11","v":-4007100.0100000054},{"$f":"IF(L11=0,0,(L11-K11)/L11)","v":-4.4375126104659691E-2}]
[null,"Fonctionnement",{"$f":"+G15-E15","v":-1524060.1600000001},{"$f":"IF(G15=0,0,(G15-E15)/G15)","v":-0.11973776704258811},{"$f":"+H15-F15","v":-1467090.4299999997},{"$f":"IF(H15=0,0,(H15-F15)/H15)","v":-0.12463072893601021},"Subvention pour charges de service public",null,null,null,592509,{"$f":"IF(L12=0,0,(L12-K12)/L12)","v":8.7117710868928697E-3}]
[null,"Investissement",{"$f":"+G20-E20","v":-1345579.0100000007},{"$f":"IF(G20=0,0,(G20-E20)/G20)","v":-0.20434085020428813},{"$f":"+H20-F20","v":-2110233.3400000008},{"$f":"IF(H20=0,0,(H20-F20)/H20)","v":-0.32906103558350297},"Autres financements de l'Etat",null,null,null,-1320258.4699999997,-0.69582108899420569]
[null,"Enveloppes Recherche",null,null,null,null,"Fiscalité affectée",null,null,null,-126429.65000000002,-0.26697121135223106]
[null,"Personnel",null,null,null,null,"Autres financements publics",null,null,null,-5068.2900000000373,-7.4772165812136753E-4]
[null,"Fonctionnement",null,null,null,null,"Recettes propres",null,null,null,-3147852.5999999996,-0.23958385495811732]
[null,"Investissement"]
[null,null,null,null,null,null,"Recettes fléchées **",null,null,null,{"$f":"L18-K18","v":0},0]
[null,null,null,null,null,null,"Financements de l'Etat fléchés",null,null,null,{"$f":"L19-K19","v":0},0]
[null,null,null,null,null,null,"Autres financements publics fléchés",null,null,null,{"$f":"L20-K20","v":0},0]
[null,null,null,null,null,null,"Recettes propres fléchées",null,null,null,{"$f":"L21-K21","v":0},0]

{"sheet":"2-tab_aut_budg_FU","index":8,"n_rows":66,"n_cols":13,"rows_kept":66,"cut":false,"hidden":false,"merged":[[0,1,0,12],[1,1,1,12],[7,1,7,7],[7,9,7,12],[8,2,8,3],[8,4,8,5],[8,6,8,7],[39,1,40,1],[39,2,39,3],[39,4,39,5],[53,1,54,1],[53,2,53,3],[53,4,53,5]]}
[null,"Tableau 2 - Université de Bretagne Sud (0561718N) : Fondation"]
[null," Autorisations budgétaires - Compte Financier 2022"]
[]
[]
[null,"POUR VOTE DE L'ORGANE DÉLIBÉRANT"]
[]
[]
[null,"Dépenses"]
[null,null,"Budget initial\n2022",null,"Dernier Budget Modifié\n2022",null,"Compte Financier\n2022",null,null," Budget initial \n2022"," Dernier Budget Modifié \n2022"," Compte Financier \n2022"]
[null,null,"AE","CP","AE","CP","AE","CP",null,"Montants","Montants","Montants"]
[null,"Personnel",193000,193000,113478.24,113478.24,105053.68,105053.68,null,{"$f":"SUM(J12:J16)","v":631000},{"$f":"SUM(K12:K16)","v":317932},325932.32,"Recettes globalisées"]
[null,"dont contributions employeur au CAS Pension",null,null,0,0,null,null,null,null,0,0,"Subvention pour charges de service public"]
[null,null,null,null,0,0,null,null,null,null,19453,20520.32,"Autres financements de l'Etat"]
[null,null,null,null,0,0,null,null,null,null,0,0,"Fiscalité affectée"]
[null,"Fonctionnement et intervention",316000,258325,143096.88,148837.88,112622.91,117299.33,null,135000,60067,59000,"Autres financements publics"]
[null,null,null,null,0,0,null,null,null,496000,238412,246412,"Recettes propres"]
[null,null,null,null,0,0]
[null,null,null,null,0,0,null,null,null,{"$f":"SUM(J19:J21)","v":0},{"$f":"SUM(K19:K21)","v":0},0,"Recettes fléchées **"]
[null,null,null,null,0,0,null,null,null,null,null,null,"Financements de l'Etat fléchés"]
[null,"Investissement",75000,45000,2000,2000,987.66,678,null,null,null,null,"Autres financements publics fléchés"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Recettes propres fléchées"]
[]
[null,"Enveloppes* destinées à des contrats de recherche",{"$f":"C24+C25+C26","v":0},{"$f":"D24+D25+D26","v":0},0,0,{"$f":"C23+E23","v":0},{"$f":"D23+F23","v":0}]
[null,"Personnel"]
[null,"Fonctionnement"]
[null,"Investissement"]
[]
[null,"TOTAL DES DÉPENSES",{"$f":"C20+C15+C11+C23","v":584000},{"$f":"D20+D15+D11+D23","v":496325},258575.12,264316.12,218664.25,223031.01,null,{"$f":"J11+J18","v":631000},{"$f":"K11+K18","v":317932},{"$f":"L11+L18","v":325932.32},"TOTAL DES RECETTES"]
[]
[null,"Solde budgétaire (excédent)",null,{"$f":"IF(J28-D28>=0,J28-D28,0)","v":134675},null,{"$f":"IF(K28-F28>=0,K28-F28,0)","v":53615.880000000005},null,{"$f":"IF(L28-H28>=0,L28-H28,0)","v":102901.31},null,{"$f":"IF(D28-J28>0,D28-J28,0)","v":0},{"$f":"IF(F28-K28>0,F28-K28,0)","v":0},{"$f":"IF(H28-L28>0,H28-L28,0)","v":0},"Solde budgétaire (déficit)"]
[]
[null,"* Chaque enveloppe peut être détaillée en fonction des besoins des organismes."]
[null,"** Montant issu du tableau \"Opérations sur recettes fléchées\" (tableau 8)"]
[]
[null,null,{"$f":"\"BI : Différence charges de personnel entre tableau 2 et tableau 6 est de : \"&'6-tab CR_TF_FU'!B9-ROUND('2-tab_aut_budg_FU'!D11+'2-tab_aut_budg_FU'!D24,0)","v":"BI : Différence charges de personnel entre tableau 2 et tableau 6 est de : -2895"}]
[null,null,{"$f":"\"BR : Différence charges de personnel entre tableau 2 et tableau 6 est de : \"&'6-tab CR_TF_FU'!C9-ROUND('2-tab_aut_budg_FU'!F11+'2-tab_aut_budg_FU'!F24,0)","v":"BR : Différence charges de personnel entre tableau 2 et tableau 6 est de : -2894,75999999999"}]
[null,null,{"$f":"\"COFI : Différence charges de personnel entre tableau 2 et tableau 6 est de : \"&'6-tab CR_TF_FU'!D9-ROUND('2-tab_aut_budg_FU'!H11+'2-tab_aut_budg_FU'!H24,0)","v":"COFI : Différence charges de personnel entre tableau 2 et tableau 6 est de : -1474,63"}]
[]
[null,"Comparaison COFI / BI"]
[null,"Comparaison COFI / BI","AE",null,"CP",null,null,null,null,null,"Comparaison COFI / BI"]
[null,null,"en valeur","en %","en valeur","en %",null,null,null,null,"en valeur","en %"]
[null,"Personnel",{"$f":"G11-C11","v":-87946.32},{"$f":"IF(G11=0,0,(G11-C11)/G11)","v":-0.83715601395400918},{"$f":"H11-D11","v":-87946.32},{"$f":"IF(H11=0,0,(H11-D11)/H11)","v":-0.83715601395400918},"Recettes globalisées",null,null,null,{"$f":"L11-J11","v":-305067.68},{"$f":"IF(L11=0,0,(L11-J11)/L11)","v":-0.93598474677196786}]
[null,"Fonctionnement",{"$f":"+G15-C15","v":-203377.09},{"$f":"IF(G15=0,0,(G15-C15)/G15)","v":-1.8058234332606038},{"$f":"+H15-D15","v":-141025.66999999998},{"$f":"IF(H15=0,0,(H15-D15)/H15)","v":-1.2022717435811439},"Subvention pour charges de service public",null,null,null,{"$f":"L12-J12","v":0},{"$f":"IF(L12=0,0,(L12-J12)/L12)","v":0}]
[null,"Investissement",{"$f":"+G20-C20","v":-74012.34},{"$f":"IF(G20=0,0,(G20-C20)/G20)","v":-74.937063361885663},{"$f":"+H20-D20","v":-44322},{"$f":"IF(H20=0,0,(H20-D20)/H20)","v":-65.371681415929203},"Autres financements de l'Etat",null,null,null,20520.32,1]
[null,"Enveloppes Recherche",{"$f":"G14-C14","v":0},{"$f":"IF(G14=0,0,(G14-C14)/G14)","v":0},{"$f":"H14-D14","v":0},{"$f":"IF(H14=0,0,(H14-D14)/H14)","v":0},"Fiscalité affectée",null,null,null,0,0]
[null,"Personnel",null,-1.8058234332606038,null,-1.2022717435811439,"Autres financements publics",null,null,null,-76000,-1.2881355932203389]
[null,"Fonctionnement",0,0,0,0,"Recettes propres",null,null,null,-249588,-1.012888982679415]
[null,"Investissement",0,0,0,0]
[null,null,null,null,null,null,"Recettes fléchées **",null,null,null,0,0]
[null,null,null,null,null,null,"Financements de l'Etat fléchés",null,null,null,0,0]
[null,null,null,null,null,null,"Autres financements publics fléchés",null,null,null,0,0]
[null,null,null,null,null,null,"Recettes propres fléchées",null,null,null,0,0]
[null,"Comparaison COFI / BR"]
[null,"Comparaison COFI / BR","AE",null,"CP",null,null,null,null,null,"Comparaison COFI / BR"]
[null,null,"en valeur","en %","en valeur","en %",null,null,null,null,"en valeur","en %"]
[null,"Personnel",{"$f":"+G11-E11","v":-8424.5600000000122},{"$f":"IF(G11=0,0,(G11-E11)/G11)","v":-8.0192907092831139E-2},{"$f":"+H11-F11","v":-8424.5600000000122},{"$f":"IF(H11=0,0,(H11-F11)/H11)","v":-8.0192907092831139E-2},"Recettes globalisées",null,null,null,{"$f":"L11-K11","v":8000.320000000007},{"$f":"IF(L11=0,0,(L11-K11)/L11)","v":2.4545954816631892E-2}]
[null,"Fonctionnement",{"$f":"+G15-E15","v":-30473.97},{"$f":"IF(G15=0,0,(G15-E15)/G15)","v":-0.2705841111724071},{"$f":"+H15-F15","v":-31538.550000000003},{"$f":"IF(H15=0,0,(H15-F15)/H15)","v":-0.26887237974846062},"Subvention pour charges de service public",null,null,null,0,{"$f":"IF(L12=0,0,(L12-K12)/L12)","v":0}]
[null,"Investissement",{"$f":"+G20-E20","v":-1012.34},{"$f":"IF(G20=0,0,(G20-E20)/G20)","v":-1.0249883563169513},{"$f":"+H20-F20","v":-1322},{"$f":"IF(H20=0,0,(H20-F20)/H20)","v":-1.9498525073746313},"Autres financements de l'Etat",null,null,null,1067.3199999999997,5.2012834107850153E-2]
[null,"Enveloppes Recherche",null,null,null,null,"Fiscalité affectée",null,null,null,0,0]
[null,"Personnel",null,null,null,null,"Autres financements publics",null,null,null,-1067,-1.8084745762711865E-2]
[null,"Fonctionnement",null,null,null,null,"Recettes propres",null,null,null,8000,3.2465951333538953E-2]
[null,"Investissement"]
[null,null,null,null,null,null,"Recettes fléchées **",null,null,null,{"$f":"L18-K18","v":0},0]
[null,null,null,null,null,null,"Financements de l'Etat fléchés",null,null,null,{"$f":"L19-K19","v":0},0]
[null,null,null,null,null,null,"Autres financements publics fléchés",null,null,null,{"$f":"L20-K20","v":0},0]
[null,null,null,null,null,null,"Recettes propres fléchées",null,null,null,{"$f":"L21-K21","v":0},0]

{"sheet":"3-tab_destination_origine_ETAB","index":9,"n_rows":53,"n_cols":12,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,1,0,11],[29,2,29,3],[33,1,35,1],[33,2,33,10],[34,2,34,6],[34,7,34,9],[34,10,35,10],[1,1,1,11],[3,1,3,9],[5,1,7,1],[5,2,5,9],[6,2,6,3],[6,4,6,5],[6,6,6,7],[6,8,6,9],[7,2,7,3]]}
[null,"Tableau 3 - Université de Bretagne Sud (0561718N) : Etablissement principal + Fondation"]
[null,"Dépenses par destination et recettes par origine - Compte Financier 2022"]
[]
[null,"POUR INFORMATION DE L'ORGANE DÉLIBÉRANT"]
[null,"Tableau des dépenses par destination (obligatoire)"]
[null,"Budget","Dépenses de l’organisme"]
[null,null,"Personnel",null,"Fonctionnement et intervention",null,"Investissement",null,"Total"]
[null,null,"AE = CP",null,"AE","CP","AE","CP","AE","CP"]
[null,"Formation initiale et continue (d) = (a) + (b) + (c)",{"$f":"SUM(C10:C12)","v":43094877.75},{"$f":"SUM(D10:D12)","v":43094977.75},2270107.54,2162107.9299999997,1797466.6099999999,1546958.71,{"$f":"C9+E9+G9","v":47162451.899999999},{"$f":"D9+F9+H9","v":46804044.390000001}]
[null,"D101 - Formation initiale et continue de niveau Licence (a)",{"$f":"+'3-tab_destination_origine_PRINC'!C10+'3-tab_destination_origine_FU'!C10","v":32522372.809999999},{"$f":"+'3-tab_destination_origine_PRINC'!D10+'3-tab_destination_origine_FU'!D10","v":32522472.809999999},{"$f":"+'3-tab_destination_origine_PRINC'!E10+'3-tab_destination_origine_FU'!E10","v":1573059.72},{"$f":"+'3-tab_destination_origine_PRINC'!F10+'3-tab_destination_origine_FU'!F10","v":1503692.68},{"$f":"+'3-tab_destination_origine_PRINC'!G10+'3-tab_destination_origine_FU'!G10","v":1114525.53},{"$f":"+'3-tab_destination_origine_PRINC'!H10+'3-tab_destination_origine_FU'!H10","v":990624.26},{"$f":"C10+E10+G10","v":35209958.060000002},35016789.75]
[null,"D102 - Formation initiale et continue de niveau Master (b)",{"$f":"+'3-tab_destination_origine_PRINC'!C11+'3-tab_destination_origine_FU'!C11","v":8612198.6400000006},{"$f":"+'3-tab_destination_origine_PRINC'!D11+'3-tab_destination_origine_FU'!D11","v":8612198.6400000006},{"$f":"+'3-tab_destination_origine_PRINC'!E11+'3-tab_destination_origine_FU'!E11","v":611869.23},{"$f":"+'3-tab_destination_origine_PRINC'!F11+'3-tab_destination_origine_FU'!F11","v":572999.74},{"$f":"+'3-tab_destination_origine_PRINC'!G11+'3-tab_destination_origine_FU'!G11","v":682941.08},{"$f":"+'3-tab_destination_origine_PRINC'!H11+'3-tab_destination_origine_FU'!H11","v":556334.44999999995},9907008.9500000011,9741532.8300000001]
[null,"D103 - Formation initiale et continue de niveau Doctorat (c) ",{"$f":"+'3-tab_destination_origine_PRINC'!C12+'3-tab_destination_origine_FU'!C12","v":1960306.3},{"$f":"+'3-tab_destination_origine_PRINC'!D12+'3-tab_destination_origine_FU'!D12","v":1960306.3},{"$f":"+'3-tab_destination_origine_PRINC'!E12+'3-tab_destination_origine_FU'!E12","v":85178.59},{"$f":"+'3-tab_destination_origine_PRINC'!F12+'3-tab_destination_origine_FU'!F12","v":85415.51},{"$f":"+'3-tab_destination_origine_PRINC'!G12+'3-tab_destination_origine_FU'!G12","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!H12+'3-tab_destination_origine_FU'!H12","v":0},2045484.8900000001,2045721.81]
[null,"D105 - Bibliothèques et documentation",{"$f":"+'3-tab_destination_origine_PRINC'!C13+'3-tab_destination_origine_FU'!C13","v":1517311.39},{"$f":"+'3-tab_destination_origine_PRINC'!D13+'3-tab_destination_origine_FU'!D13","v":1517143.67},{"$f":"+'3-tab_destination_origine_PRINC'!E13+'3-tab_destination_origine_FU'!E13","v":511333.96},{"$f":"+'3-tab_destination_origine_PRINC'!F13+'3-tab_destination_origine_FU'!F13","v":482439.24},{"$f":"+'3-tab_destination_origine_PRINC'!G13+'3-tab_destination_origine_FU'!G13","v":21442.06},{"$f":"+'3-tab_destination_origine_PRINC'!H13+'3-tab_destination_origine_FU'!H13","v":26122.91},2050087.41,2025705.8199999998]
[null,"D106 - Recherche universitaire en sciences de la vie, biotechnologie et santé",{"$f":"+'3-tab_destination_origine_PRINC'!C14+'3-tab_destination_origine_FU'!C14","v":1432772.43},{"$f":"+'3-tab_destination_origine_PRINC'!D14+'3-tab_destination_origine_FU'!D14","v":1432772.43},{"$f":"+'3-tab_destination_origine_PRINC'!E14+'3-tab_destination_origine_FU'!E14","v":241870.52},{"$f":"+'3-tab_destination_origine_PRINC'!F14+'3-tab_destination_origine_FU'!F14","v":229087.96},{"$f":"+'3-tab_destination_origine_PRINC'!G14+'3-tab_destination_origine_FU'!G14","v":133784.63},{"$f":"+'3-tab_destination_origine_PRINC'!H14+'3-tab_destination_origine_FU'!H14","v":138625.18},1808427.58,1800485.5699999998]
[null,"D107 -  Recherche universitaire en mathématiques, sciences et techniques de l'information et de la communication, micro et nanotechnologies",{"$f":"+'3-tab_destination_origine_PRINC'!C15+'3-tab_destination_origine_FU'!C15","v":5793884.0300000003},{"$f":"+'3-tab_destination_origine_PRINC'!D15+'3-tab_destination_origine_FU'!D15","v":5793884.0300000003},{"$f":"+'3-tab_destination_origine_PRINC'!E15+'3-tab_destination_origine_FU'!E15","v":439300.09},{"$f":"+'3-tab_destination_origine_PRINC'!F15+'3-tab_destination_origine_FU'!F15","v":459342.14999999997},{"$f":"+'3-tab_destination_origine_PRINC'!G15+'3-tab_destination_origine_FU'!G15","v":189439.46},{"$f":"+'3-tab_destination_origine_PRINC'!H15+'3-tab_destination_origine_FU'!H15","v":114891.23},6422623.5800000001,6368117.4100000011]
[null,"D108 -  Recherche universitaire en physique, chimie et sciences pour l'ingénieur",{"$f":"+'3-tab_destination_origine_PRINC'!C16+'3-tab_destination_origine_FU'!C16","v":5683724.8899999997},{"$f":"+'3-tab_destination_origine_PRINC'!D16+'3-tab_destination_origine_FU'!D16","v":5683546.4900000002},{"$f":"+'3-tab_destination_origine_PRINC'!E16+'3-tab_destination_origine_FU'!E16","v":1419089.68},{"$f":"+'3-tab_destination_origine_PRINC'!F16+'3-tab_destination_origine_FU'!F16","v":1314502.82},{"$f":"+'3-tab_destination_origine_PRINC'!G16+'3-tab_destination_origine_FU'!G16","v":623976.75},{"$f":"+'3-tab_destination_origine_PRINC'!H16+'3-tab_destination_origine_FU'!H16","v":636386.02},7726791.3199999994,7634435.3300000001]
[null,"D109 -  Recherche universitaire en physique nucléaire et des hautes énergies",{"$f":"+'3-tab_destination_origine_PRINC'!C17+'3-tab_destination_origine_FU'!C17","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!D17+'3-tab_destination_origine_FU'!D17","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!E17+'3-tab_destination_origine_FU'!E17","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!F17+'3-tab_destination_origine_FU'!F17","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!G17+'3-tab_destination_origine_FU'!G17","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!H17+'3-tab_destination_origine_FU'!H17","v":0},0,0]
[null,"D110 -  Recherche universitaire en sciences de la terre, de l'univers et de l'environnement",{"$f":"+'3-tab_destination_origine_PRINC'!C18+'3-tab_destination_origine_FU'!C18","v":396040.26},{"$f":"+'3-tab_destination_origine_PRINC'!D18+'3-tab_destination_origine_FU'!D18","v":396040.26},{"$f":"+'3-tab_destination_origine_PRINC'!E18+'3-tab_destination_origine_FU'!E18","v":189308.22},{"$f":"+'3-tab_destination_origine_PRINC'!F18+'3-tab_destination_origine_FU'!F18","v":183855.64},{"$f":"+'3-tab_destination_origine_PRINC'!G18+'3-tab_destination_origine_FU'!G18","v":103362.03},{"$f":"+'3-tab_destination_origine_PRINC'!H18+'3-tab_destination_origine_FU'!H18","v":94082.15},688710.51,673978.05]
[null,"D111 -  Recherche universitaire en sciences de l'homme et de la société",{"$f":"+'3-tab_destination_origine_PRINC'!C19+'3-tab_destination_origine_FU'!C19","v":5440444.2000000002},{"$f":"+'3-tab_destination_origine_PRINC'!D19+'3-tab_destination_origine_FU'!D19","v":5440444.2000000002},{"$f":"+'3-tab_destination_origine_PRINC'!E19+'3-tab_destination_origine_FU'!E19","v":280642.09000000003},{"$f":"+'3-tab_destination_origine_PRINC'!F19+'3-tab_destination_origine_FU'!F19","v":246720.11},{"$f":"+'3-tab_destination_origine_PRINC'!G19+'3-tab_destination_origine_FU'!G19","v":9742.2800000000007},{"$f":"+'3-tab_destination_origine_PRINC'!H19+'3-tab_destination_origine_FU'!H19","v":13470.68},5730828.5700000003,5700634.9900000002]
[null,"D112 -  Recherche universitaire interdisciplinaire et transversale",{"$f":"+'3-tab_destination_origine_PRINC'!C20+'3-tab_destination_origine_FU'!C20","v":538119.72},{"$f":"+'3-tab_destination_origine_PRINC'!D20+'3-tab_destination_origine_FU'!D20","v":538119.72},{"$f":"+'3-tab_destination_origine_PRINC'!E20+'3-tab_destination_origine_FU'!E20","v":277064.73000000004},{"$f":"+'3-tab_destination_origine_PRINC'!F20+'3-tab_destination_origine_FU'!F20","v":289689.40000000002},{"$f":"+'3-tab_destination_origine_PRINC'!G20+'3-tab_destination_origine_FU'!G20","v":1334.6},{"$f":"+'3-tab_destination_origine_PRINC'!H20+'3-tab_destination_origine_FU'!H20","v":3150.2},816519.04999999993,830959.32]
[null,"D113 -  Diffusion des savoirs et musées",{"$f":"+'3-tab_destination_origine_PRINC'!C21+'3-tab_destination_origine_FU'!C21","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!D21+'3-tab_destination_origine_FU'!D21","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!E21+'3-tab_destination_origine_FU'!E21","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!F21+'3-tab_destination_origine_FU'!F21","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!G21+'3-tab_destination_origine_FU'!G21","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!H21+'3-tab_destination_origine_FU'!H21","v":0},0,0]
[null,"D114 - Immobilier",{"$f":"+'3-tab_destination_origine_PRINC'!C22+'3-tab_destination_origine_FU'!C22","v":2009565.84},{"$f":"+'3-tab_destination_origine_PRINC'!D22+'3-tab_destination_origine_FU'!D22","v":2009565.84},{"$f":"+'3-tab_destination_origine_PRINC'!E22+'3-tab_destination_origine_FU'!E22","v":3448783.43},{"$f":"+'3-tab_destination_origine_PRINC'!F22+'3-tab_destination_origine_FU'!F22","v":3415661.1300000004},{"$f":"+'3-tab_destination_origine_PRINC'!G22+'3-tab_destination_origine_FU'!G22","v":2994298.65},{"$f":"+'3-tab_destination_origine_PRINC'!H22+'3-tab_destination_origine_FU'!H22","v":3437202.24},8452647.9199999999,8862429.2100000009]
[null,"D115 - Pilotage et support",{"$f":"+'3-tab_destination_origine_PRINC'!C23+'3-tab_destination_origine_FU'!C23","v":6391251.0599999996},{"$f":"+'3-tab_destination_origine_PRINC'!D23+'3-tab_destination_origine_FU'!D23","v":6375501.7999999998},{"$f":"+'3-tab_destination_origine_PRINC'!E23+'3-tab_destination_origine_FU'!E23","v":2312481.8199999998},{"$f":"+'3-tab_destination_origine_PRINC'!F23+'3-tab_destination_origine_FU'!F23","v":2187487.46},{"$f":"+'3-tab_destination_origine_PRINC'!G23+'3-tab_destination_origine_FU'!G23","v":414304.29},{"$f":"+'3-tab_destination_origine_PRINC'!H23+'3-tab_destination_origine_FU'!H23","v":240894.04},9118037.1699999981,8803883.2999999989]
[null,"Étudiants (h) = (e) + (f) + (g)",{"$f":"SUM(C25:C27)","v":2155553.0099999998},{"$f":"SUM(D25:D27)","v":2155714.89},1450957.03,917903.92,296809.44,161788.03,3903319.48,3235406.84]
[null,"D201 - Aides directes aux étudiants (e)",{"$f":"+'3-tab_destination_origine_PRINC'!C25+'3-tab_destination_origine_FU'!C25","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!D25+'3-tab_destination_origine_FU'!D25","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!E25+'3-tab_destination_origine_FU'!E25","v":977212.01},{"$f":"+'3-tab_destination_origine_PRINC'!F25+'3-tab_destination_origine_FU'!F25","v":387183.27},{"$f":"+'3-tab_destination_origine_PRINC'!G25+'3-tab_destination_origine_FU'!G25","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!H25+'3-tab_destination_origine_FU'!H25","v":0},977212.01,387183.27]
[null,"D202 - Aides indirectes (f)",{"$f":"+'3-tab_destination_origine_PRINC'!C26+'3-tab_destination_origine_FU'!C26","v":8376.2099999999991},{"$f":"+'3-tab_destination_origine_PRINC'!D26+'3-tab_destination_origine_FU'!D26","v":8376.2099999999991},{"$f":"+'3-tab_destination_origine_PRINC'!E26+'3-tab_destination_origine_FU'!E26","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!F26+'3-tab_destination_origine_FU'!F26","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!G26+'3-tab_destination_origine_FU'!G26","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!H26+'3-tab_destination_origine_FU'!H26","v":0},8376.2099999999991,8376.2099999999991]
[null,"D203 - Santé des étudiants et activités associatives, culturelles et sportives (g)",{"$f":"+'3-tab_destination_origine_PRINC'!C27+'3-tab_destination_origine_FU'!C27","v":2147176.7999999998},{"$f":"+'3-tab_destination_origine_PRINC'!D27+'3-tab_destination_origine_FU'!D27","v":2147338.6800000002},{"$f":"+'3-tab_destination_origine_PRINC'!E27+'3-tab_destination_origine_FU'!E27","v":473745.02},{"$f":"+'3-tab_destination_origine_PRINC'!F27+'3-tab_destination_origine_FU'!F27","v":530720.65},{"$f":"+'3-tab_destination_origine_PRINC'!G27+'3-tab_destination_origine_FU'!G27","v":296809.44},{"$f":"+'3-tab_destination_origine_PRINC'!H27+'3-tab_destination_origine_FU'!H27","v":161788.03},2917731.26,2839847.36]
[null,"Total",{"$f":"SUM(C10:C24)","v":74453544.580000013},{"$f":"SUM(D10:D24)","v":74437711.080000013},12840939.109999999,11888797.76,6585960.7999999998,6413571.3900000006,{"$f":"C28+E28+G28","v":93880444.49000001},{"$f":"D28+F28+H28","v":92740080.230000019}]
[]
[null,null,null,null,null,null,null,"SOLDE BUDGETAIRE (excédent)",null,{"$f":"IF(K50>J28,K50-J28,0)","v":107904.76999998093},{"$f":"IF(ROUND(J30,-1)<>ROUND('2-tab_aut_budg_ETAB'!H30,-1),\"Incohérence solde budgétaire avec Tab2 ETAB\",\"\")","v":""}]
[null,null,{"$f":"IF(ROUND(C28,-1)<>ROUND('2-tab_aut_budg_ETAB'!G11+'2-tab_aut_budg_ETAB'!G24,-1),\"! Incohérence total Personnel AE avec Tab2 ETAB\",\"\")","v":""},{"$f":"IF(ROUND(D28,-1)<>ROUND('2-tab_aut_budg_ETAB'!H11+'2-tab_aut_budg_ETAB'!H24,-1),\"! Incohérence total Personnel CP avec Tab2 ETAB\",\"\")","v":""},{"$f":"IF(ROUND(E28,-1)<>ROUND('2-tab_aut_budg_ETAB'!G15+'2-tab_aut_budg_ETAB'!G25,-1),\"! Incohérence total Fonctionnement AE avec Tab2 ETAB\",\"\")","v":""},{"$f":"IF(ROUND(F28,-1)<>ROUND('2-tab_aut_budg_ETAB'!H15+'2-tab_aut_budg_ETAB'!H25,-1),\"! Incohérence total Fonctionnement CP avec Tab2 ETAB\",\"\")","v":""},{"$f":"IF(ROUND(G28,-1)<>ROUND('2-tab_aut_budg_ETAB'!G20+'2-tab_aut_budg_ETAB'!G26,-1),\"! Incohérence total Investissement AE avec Tab2 ETAB\",\"\")","v":""},{"$f":"IF(ROUND(H28,-1)<>ROUND('2-tab_aut_budg_ETAB'!H20+'2-tab_aut_budg_ETAB'!H26,-1),\"! Incohérence total Investissement CP avec Tab2 ETAB\",\"\")","v":""},{"$f":"IF(ROUND(I28,-1)<>ROUND('2-tab_aut_budg_ETAB'!G28,-1),\"! Incohérence Total dépenses AE avec Tab2 ETAB\",\"\")","v":""},{"$f":"IF(ROUND(J28,-1)<>ROUND('2-tab_aut_budg_ETAB'!H28,-1),\"! Incohérence Total dépenses CP avec Tab2 ETAB\",\"\")","v":""}]
[null,"Tableau des recettes par origine (obligatoire)"]
[]
[null,"Budget","Recettes de l'organisme"]
[null,null,"Recettes globalisées",null,null,null,null,"Recettes fléchées",null,null,"Total"]
[null,null,"Subvention pour charges de service public","Autres financements de l'Etat","Fiscalité affectée","Autres financements publics","Recettes propres","Financements de l'Etat fléchés","Autres financements publics fléchés","Recettes propres fléchées"]
[null,"Subvention pour charges de service public",{"$f":"+'3-tab_destination_origine_PRINC'!C37+'3-tab_destination_origine_FU'!C37","v":68012462},null,null,null,null,null,null,null,{"$f":"C37","v":68012462}]
[null,"Droits d'inscription",null,null,null,null,{"$f":"+'3-tab_destination_origine_PRINC'!G38+'3-tab_destination_origine_FU'!G38","v":1303032.6200000001},{"$f":"+'3-tab_destination_origine_PRINC'!H38+'3-tab_destination_origine_FU'!H38","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!I38+'3-tab_destination_origine_FU'!I38","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!J38+'3-tab_destination_origine_FU'!J38","v":0},{"$f":"SUM(G38:J38)","v":1303032.6200000001}]
[null,"Formation continue, diplômes propres et VAE",null,null,null,null,{"$f":"+'3-tab_destination_origine_PRINC'!G39+'3-tab_destination_origine_FU'!G39","v":5409002.2699999996},{"$f":"+'3-tab_destination_origine_PRINC'!H39+'3-tab_destination_origine_FU'!H39","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!I39+'3-tab_destination_origine_FU'!I39","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!J39+'3-tab_destination_origine_FU'!J39","v":0},{"$f":"SUM(G39:J39)","v":5409002.2699999996}]
[null,"Taxe d'apprentissage",null,null,null,null,{"$f":"+'3-tab_destination_origine_PRINC'!G40+'3-tab_destination_origine_FU'!G40","v":664150.49},{"$f":"+'3-tab_destination_origine_PRINC'!H40+'3-tab_destination_origine_FU'!H40","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!I40+'3-tab_destination_origine_FU'!I40","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!J40+'3-tab_destination_origine_FU'!J40","v":0},664150.49]
[null,"Contrats et prestations de recherche hors ANR",null,null,null,null,{"$f":"+'3-tab_destination_origine_PRINC'!G41+'3-tab_destination_origine_FU'!G41","v":869595.88},{"$f":"+'3-tab_destination_origine_PRINC'!H41+'3-tab_destination_origine_FU'!H41","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!I41+'3-tab_destination_origine_FU'!I41","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!J41+'3-tab_destination_origine_FU'!J41","v":0},{"$f":"SUM(G41:J41)","v":869595.88}]
[null,"Valorisation",null,null,null,null,{"$f":"+'3-tab_destination_origine_PRINC'!G42+'3-tab_destination_origine_FU'!G42","v":738101.38},{"$f":"+'3-tab_destination_origine_PRINC'!H42+'3-tab_destination_origine_FU'!H42","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!I42+'3-tab_destination_origine_FU'!I42","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!J42+'3-tab_destination_origine_FU'!J42","v":0},738101.38]
[null,"ANR investissements d'avenir",null,null,null,{"$f":"+'3-tab_destination_origine_PRINC'!F43+'3-tab_destination_origine_FU'!F43","v":264343.8},null,{"$f":"+'3-tab_destination_origine_PRINC'!H43+'3-tab_destination_origine_FU'!H43","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!I43+'3-tab_destination_origine_FU'!I43","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!J43+'3-tab_destination_origine_FU'!J43","v":0},{"$f":"SUM(F43,H43:J43)","v":264343.8}]
[null,"ANR hors investissements d'avenir",null,null,null,{"$f":"+'3-tab_destination_origine_PRINC'!F44+'3-tab_destination_origine_FU'!F44","v":1110767.3700000001},null,{"$f":"+'3-tab_destination_origine_PRINC'!H44+'3-tab_destination_origine_FU'!H44","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!I44+'3-tab_destination_origine_FU'!I44","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!J44+'3-tab_destination_origine_FU'!J44","v":0},{"$f":"SUM(F44,H44:J44)","v":1110767.3700000001}]
[null,"Subventions d'exploitation et financement des actifs - Région",null,null,null,{"$f":"+'3-tab_destination_origine_PRINC'!F45+'3-tab_destination_origine_FU'!F45","v":1418068.17},null,{"$f":"+'3-tab_destination_origine_PRINC'!H45+'3-tab_destination_origine_FU'!H45","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!I45+'3-tab_destination_origine_FU'!I45","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!J45+'3-tab_destination_origine_FU'!J45","v":0},1418068.17]
[null,"Subventions d'exploitation et financement des actifs - Union Européenne",null,null,null,{"$f":"+'3-tab_destination_origine_PRINC'!F46+'3-tab_destination_origine_FU'!F46","v":2111648.91},null,{"$f":"+'3-tab_destination_origine_PRINC'!H46+'3-tab_destination_origine_FU'!H46","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!I46+'3-tab_destination_origine_FU'!I46","v":2221464},{"$f":"+'3-tab_destination_origine_PRINC'!J46+'3-tab_destination_origine_FU'!J46","v":0},4333112.91]
[null,"Subventions d'exploitation et financement des actifs - Autres",null,{"$f":"+'3-tab_destination_origine_PRINC'!D47+'3-tab_destination_origine_FU'!D47","v":1917931.1500000001},null,{"$f":"+'3-tab_destination_origine_PRINC'!F47+'3-tab_destination_origine_FU'!F47","v":1932482.83},{"$f":"+'3-tab_destination_origine_PRINC'!G47+'3-tab_destination_origine_FU'!G47","v":139407.25},{"$f":"+'3-tab_destination_origine_PRINC'!H47+'3-tab_destination_origine_FU'!H47","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!I47+'3-tab_destination_origine_FU'!I47","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!J47+'3-tab_destination_origine_FU'!J47","v":0},{"$f":"SUM(D47,F47:J47)","v":3989821.2300000004}]
[null,"Fondations - fonds propres, réserves, dons et legs",null,{"$f":"+'3-tab_destination_origine_PRINC'!D48+'3-tab_destination_origine_FU'!D48","v":0},null,{"$f":"+'3-tab_destination_origine_PRINC'!F48+'3-tab_destination_origine_FU'!F48","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!G48+'3-tab_destination_origine_FU'!G48","v":241912},{"$f":"+'3-tab_destination_origine_PRINC'!H48+'3-tab_destination_origine_FU'!H48","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!I48+'3-tab_destination_origine_FU'!I48","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!J48+'3-tab_destination_origine_FU'!J48","v":0},{"$f":"SUM(D48,F48:J48)","v":241912}]
[null,"Autres recettes",null,null,{"$f":"+'3-tab_destination_origine_PRINC'!E49+'3-tab_destination_origine_FU'!E49","v":473570.35},{"$f":"+'3-tab_destination_origine_PRINC'!F49+'3-tab_destination_origine_FU'!F49","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!G49+'3-tab_destination_origine_FU'!G49","v":4020044.53},{"$f":"+'3-tab_destination_origine_PRINC'!H49+'3-tab_destination_origine_FU'!H49","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!I49+'3-tab_destination_origine_FU'!I49","v":0},{"$f":"+'3-tab_destination_origine_PRINC'!J49+'3-tab_destination_origine_FU'!J49","v":0},{"$f":"SUM(E49:J49)","v":4493614.88}]
[null,"Total",{"$f":"C37","v":68012462},{"$f":"SUM(D47:D48)","v":1917931.1500000001},{"$f":"+E49","v":473570.35},{"$f":"SUM(F43:F49)","v":6837311.0800000001},{"$f":"SUM(G38:G42,G47:G49)","v":13385246.42},{"$f":"SUM(H38:H49)","v":0},{"$f":"SUM(I38:I49)","v":2221464},0,{"$f":"SUM(C50:J50)","v":92847985}]
[]
[null,"La liste des destination est susceptible d'être modifiée par le ministre chargé de l'enseignement supérieur",null,null,null,null,null,null,"SOLDE BUDGETAIRE (déficit)",null,{"$f":"IF(J28>K50,J28-K50,0)","v":0},{"$f":"IF(ROUND(K52,-1)<>ROUND('2-tab_aut_budg_ETAB'!L30,-1),\"! Incohérence solde budgétaire avec Tab2 AGR\",\"\")","v":""}]
[null,null,{"$f":"IF(ROUND(C50,-1)<>ROUND('2-tab_aut_budg_ETAB'!L12,-1),\"! Incohérence total Subv charges serv public avec Tab2 ETAB\",\"\")","v":""},{"$f":"IF(ROUND(D50,-1)<>ROUND('2-tab_aut_budg_ETAB'!L13,-1),\"! Incohérence total Autres financements Etat avec Tab2 ETAB\",\"\")","v":""},{"$f":"IF(ROUND(E50,-1)<>ROUND('2-tab_aut_budg_ETAB'!L14,-1),\"! Incohérence total Fiscalité affectée avec Tab2 ETAB\",\"\")","v":""},{"$f":"IF(ROUND(F50,-1)<>ROUND('2-tab_aut_budg_ETAB'!L15,-1),\"! Incohérence total Autres financements publics avec Tab2 ETAB\",\"\")","v":""},{"$f":"IF(ROUND(G50,-1)<>ROUND('2-tab_aut_budg_ETAB'!L16,-1),\"! Incohérence total Recettes propres avec Tab2 ETAB\",\"\")","v":""},{"$f":"IF(ROUND(H50,-1)<>ROUND('2-tab_aut_budg_ETAB'!L19,-1),\"! Incohérence total Financements Etat fléchés avec Tab2 AGR\",\"\")","v":""},{"$f":"IF(ROUND(I50,-1)<>ROUND('2-tab_aut_budg_ETAB'!L20,-1),\"! Incohérence total Autres financements fléchés avec Tab2 AGR\",\"\")","v":""},{"$f":"IF(ROUND(J50,-1)<>ROUND('2-tab_aut_budg_ETAB'!L21,-1),\"! Incohérence total Recettes propres fléchées avec Tab2 AGR\",\"\")","v":""},{"$f":"IF(ROUND(K50,-1)<>ROUND('2-tab_aut_budg_ETAB'!L28,-1),\"! Incohérence total avec Tab2 AGR\",\"\")","v":""}]

{"sheet":"3-tab_destination_origine_PRINC","index":10,"n_rows":53,"n_cols":12,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,1,0,11],[29,2,29,3],[33,1,35,1],[33,2,33,10],[34,2,34,6],[34,7,34,9],[34,10,35,10],[1,1,1,11],[3,1,3,9],[5,1,7,1],[5,2,5,9],[6,2,6,3],[6,4,6,5],[6,6,6,7],[6,8,6,9],[7,2,7,3]]}
[null,"Tableau 3 - Université de Bretagne Sud (0561718N) : Etablissement principal"]
[null,"Dépenses par destination et recettes par origine - Compte Financier 2022"]
[]
[null,"POUR INFORMATION DE L'ORGANE DÉLIBÉRANT"]
[null,"Tableau des dépenses par destination (obligatoire)"]
[null,"Budget","Dépenses de l’organisme"]
[null,null,"Personnel",null,"Fonctionnement et intervention",null,"Investissement",null,"Total"]
[null,null,"AE = CP",null,"AE","CP","AE","CP","AE","CP"]
[null,"Formation initiale et continue (d) = (a) + (b) + (c)",{"$f":"SUM(C10:C12)","v":43077024.240000002},{"$f":"SUM(D10:D12)","v":43077124.240000002},2270107.54,2162107.9299999997,1797466.6099999999,1546958.71,{"$f":"C9+E9+G9","v":47144598.390000001},{"$f":"D9+F9+H9","v":46786190.880000003}]
[null,"D101 - Formation initiale et continue de niveau Licence (a)",32522372.809999999,32522472.809999999,1573059.72,1503692.68,1114525.53,990624.26,{"$f":"C10+E10+G10","v":35209958.060000002},35016789.75]
[null,"D102 - Formation initiale et continue de niveau Master (b)",8612198.6400000006,8612198.6400000006,611869.23,572999.74,682941.08,556334.44999999995,9907008.9500000011,9741532.8300000001]
[null,"D103 - Formation initiale et continue de niveau Doctorat (c) ",1942452.79,1942452.79,85178.59,85415.51,0,0,2027631.3800000001,2027868.3]
[null,"D105 - Bibliothèques et documentation",1517311.39,1517143.67,511333.96,482439.24,21442.06,26122.91,2050087.41,2025705.8199999998]
[null,"D106 - Recherche universitaire en sciences de la vie, biotechnologie et santé",1432772.43,1432772.43,241870.52,229087.96,133784.63,138625.18,1808427.58,1800485.5699999998]
[null,"D107 -  Recherche universitaire en mathématiques, sciences et techniques de l'information et de la communication, micro et nanotechnologies",5750754.1699999999,5750754.1699999999,425410.08,440453.47,189301.46,114213.23,6365465.71,6305420.8700000001]
[null,"D108 -  Recherche universitaire en physique, chimie et sciences pour l'ingénieur",5683724.8899999997,5683546.4900000002,1419089.68,1314502.82,623976.75,636386.02,7726791.3199999994,7634435.3300000001]
[null,"D109 -  Recherche universitaire en physique nucléaire et des hautes énergies",0,0,0,0,0,0,0,0]
[null,"D110 -  Recherche universitaire en sciences de la terre, de l'univers et de l'environnement",396040.26,396040.26,83925.5,78976.97,102512.37,94082.15,582478.13,569099.38]
[null,"D111 -  Recherche universitaire en sciences de l'homme et de la société",5440444.2000000002,5440444.2000000002,275945.14,242003,9742.2800000000007,13470.68,5726131.6200000001,5695917.8799999999]
[null,"D112 -  Recherche universitaire interdisciplinaire et transversale",538119.72,538119.72,276761.83,289569.40000000002,1334.6,3150.2,816216.15,830839.32]
[null,"D113 -  Diffusion des savoirs et musées",null,null,null,null,null,null,0,0]
[null,"D114 - Immobilier",2009565.84,2009565.84,3448550.73,3415428.43,2994298.65,3437202.24,8452415.2200000007,8862196.5100000016]
[null,"D115 - Pilotage et support",6347180.75,6331431.4900000002,2324364.19,2199025.29,414304.29,240894.04,9085849.2299999986,8771350.8200000003]
[null,"Étudiants (h) = (e) + (f) + (g)",{"$f":"SUM(C25:C27)","v":2155553.0099999998},{"$f":"SUM(D25:D27)","v":2155714.89},1450957.03,917903.92,296809.44,161788.03,3903319.48,3235406.84]
[null,"D201 - Aides directes aux étudiants (e)",0,0,977212.01,387183.27,0,0,977212.01,387183.27]
[null,"D202 - Aides indirectes (f)",8376.2099999999991,8376.2099999999991,0,0,0,0,8376.2099999999991,8376.2099999999991]
[null,"D203 - Santé des étudiants et activités associatives, culturelles et sportives (g)",2147176.7999999998,2147338.6800000002,473745.02,530720.65,296809.44,161788.03,2917731.26,2839847.36]
[null,"Total",{"$f":"SUM(C10:C24)","v":74348490.900000021},{"$f":"SUM(D10:D24)","v":74332657.400000006},12728316.199999999,11771498.430000002,6584973.1400000006,6412893.3900000006,{"$f":"C28+E28+G28","v":93661780.240000024},{"$f":"D28+F28+H28","v":92517049.220000014}]
[]
[null,null,null,null,null,null,null,"SOLDE BUDGETAIRE (excédent)",null,{"$f":"IF(K50>J28,K50-J28,0)","v":5003.4599999636412},{"$f":"IF(ROUND(J30,-1)<>ROUND('2-tab_aut_budg_PRINC'!H30,-1),\"Incohérence solde budgétaire avec Tab2 PRINC\",\"\")","v":""}]
[null,null,{"$f":"IF(ROUND(C28,-1)<>ROUND('2-tab_aut_budg_PRINC'!G11+'2-tab_aut_budg_PRINC'!G24,-1),\"! Incohérence total Personnel AE avec Tab2 PRINC\",\"\")","v":""},{"$f":"IF(ROUND(D28,-1)<>ROUND('2-tab_aut_budg_PRINC'!H11+'2-tab_aut_budg_PRINC'!H24,-1),\"! Incohérence total Personnel CP avec Tab2 PRINC\",\"\")","v":""},{"$f":"IF(ROUND(E28,-1)<>ROUND('2-tab_aut_budg_PRINC'!G15+'2-tab_aut_budg_PRINC'!G25,-1),\"! Incohérence total Fonctionnement AE avec Tab2 PRINC\",\"\")","v":""},{"$f":"IF(ROUND(F28,-1)<>ROUND('2-tab_aut_budg_PRINC'!H15+'2-tab_aut_budg_PRINC'!H25,-1),\"! Incohérence total Fonctionnement CP avec Tab2 PRINC\",\"\")","v":""},{"$f":"IF(ROUND(G28,-1)<>ROUND('2-tab_aut_budg_PRINC'!G20+'2-tab_aut_budg_PRINC'!G26,-1),\"! Incohérence total Investissement AE avec Tab2 PRINC\",\"\")","v":""},{"$f":"IF(ROUND(H28,-1)<>ROUND('2-tab_aut_budg_PRINC'!H20+'2-tab_aut_budg_PRINC'!H26,-1),\"! Incohérence total Investissement CP avec Tab2 PRINC\",\"\")","v":""},{"$f":"IF(ROUND(I28,-1)<>ROUND('2-tab_aut_budg_PRINC'!G28,-1),\"! Incohérence Total dépenses AE avec Tab2 PRINC\",\"\")","v":""},{"$f":"IF(ROUND(J28,-1)<>ROUND('2-tab_aut_budg_PRINC'!H28,-1),\"! Incohérence Total dépenses CP avec Tab2 PRINC\",\"\")","v":""}]
[null,"Tableau des recettes par origine (obligatoire)"]
[]
[null,"Budget","Recettes de l'organisme"]
[null,null,"Recettes globalisées",null,null,null,null,"Recettes fléchées",null,null,"Total"]
[null,null,"Subvention pour charges de service public","Autres financements de l'Etat","Fiscalité affectée","Autres financements publics","Recettes propres","Financements de l'Etat fléchés","Autres financements publics fléchés","Recettes propres fléchées"]
[null,"Subvention pour charges de service public",68012462,0,0,0,0,0,0,0,{"$f":"C37","v":68012462}]
[null,"Droits d'inscription",0,0,0,0,1303032.6200000001,0,0,0,{"$f":"SUM(G38:J38)","v":1303032.6200000001}]
[null,"Formation continue, diplômes propres et VAE",0,0,0,0,5409002.2699999996,0,0,0,{"$f":"SUM(G39:J39)","v":5409002.2699999996}]
[null,"Taxe d'apprentissage",0,0,0,0,664150.49,0,0,0,664150.49]
[null,"Contrats et prestations de recherche hors ANR",0,0,0,0,869595.88,0,0,0,869595.88]
[null,"Valorisation",0,0,0,0,735101.38,0,0,0,735101.38]
[null,"ANR investissements d'avenir",0,0,0,264343.8,0,0,0,0,{"$f":"SUM(F43,H43:J43)","v":264343.8}]
[null,"ANR hors investissements d'avenir",0,0,0,1110767.3700000001,0,0,0,0,{"$f":"SUM(F44,H44:J44)","v":1110767.3700000001}]
[null,"Subventions d'exploitation et financement des actifs - Région",0,0,0,1418068.17,0,0,0,0,1418068.17]
[null,"Subventions d'exploitation et financement des actifs - Union Européenne",0,0,0,2111648.91,0,0,2221464,0,4333112.91]
[null,"Subventions d'exploitation et financement des actifs - Autres",0,1897410.83,0,1873482.83,139407.25,0,0,0,{"$f":"SUM(D47,F47:J47)","v":3910300.91}]
[null,"Fondations - fonds propres, réserves, dons et legs",0,0,0,0,0,0,0,0,{"$f":"SUM(D48,F48:J48)","v":0}]
[null,"Autres recettes",0,0,473570.35,0,4018544.53,0,0,0,{"$f":"SUM(E49:J49)","v":4492114.88}]
[null,"Total",{"$f":"C37","v":68012462},{"$f":"SUM(D47:D48)","v":1897410.83},{"$f":"E49","v":473570.35},{"$f":"SUM(F43:F49)","v":6778311.0800000001},{"$f":"SUM(G38:G42,G47:G49)","v":13138834.42},{"$f":"SUM(H38:H49)","v":0},{"$f":"SUM(I38:I49)","v":2221464},0,{"$f":"SUM(K37:K49)","v":92522052.679999977}]
[]
[null,"La liste des destination est susceptible d'être modifiée par le ministre chargé de l'enseignement supérieur",null,null,null,null,null,null,"SOLDE BUDGETAIRE (déficit)",null,{"$f":"IF(J28>K50,J28-K50,0)","v":0},{"$f":"IF(ROUND(K52,-1)<>ROUND('2-tab_aut_budg_PRINC'!L30,-1),\"! Incohérence solde budgétaire avec Tab2 PRINC\",\"\")","v":""}]
[null,null,{"$f":"IF(ROUND(C50,-1)<>ROUND('2-tab_aut_budg_PRINC'!L12,-1),\"! Incohérence total Subv charges serv public avec Tab2 PRINC\",\"\")","v":""},{"$f":"IF(ROUND(D50,-1)<>ROUND('2-tab_aut_budg_PRINC'!L13,-1),\"! Incohérence total Autres financements Etat avec Tab2 PRINC\",\"\")","v":""},{"$f":"IF(ROUND(E50,-1)<>ROUND('2-tab_aut_budg_PRINC'!L14,-1),\"! Incohérence total Fiscalité affectée avec Tab2 PRINC\",\"\")","v":""},{"$f":"IF(ROUND(F50,-1)<>ROUND('2-tab_aut_budg_PRINC'!L15,-1),\"! Incohérence total Autres financements publics avec Tab2 PRINC\",\"\")","v":""},{"$f":"IF(ROUND(G50,-1)<>ROUND('2-tab_aut_budg_PRINC'!L16,-1),\"! Incohérence total Recettes propres avec Tab2 PRINC\",\"\")","v":""},{"$f":"IF(ROUND(H50,-1)<>ROUND('2-tab_aut_budg_PRINC'!L19,-1),\"! Incohérence total Financements Etat fléchés avec Tab2 PRINC\",\"\")","v":""},{"$f":"IF(ROUND(I50,-1)<>ROUND('2-tab_aut_budg_PRINC'!L20,-1),\"! Incohérence total Autres financements fléchés avec Tab2 PRINC\",\"\")","v":""},{"$f":"IF(ROUND(J50,-1)<>ROUND('2-tab_aut_budg_PRINC'!L21,-1),\"! Incohérence total Recettes propres fléchées avec Tab2 PRINC\",\"\")","v":""},{"$f":"IF(ROUND(K50,-1)<>ROUND('2-tab_aut_budg_PRINC'!L28,-1),\"! Incohérence total avec Tab2 PRINC\",\"\")","v":""}]

{"sheet":"3-tab_destination_origine_FU","index":11,"n_rows":53,"n_cols":12,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,1,0,11],[1,1,1,11],[3,1,3,9],[5,1,7,1],[5,2,5,9],[6,2,6,3],[6,4,6,5],[6,6,6,7],[6,8,6,9],[7,2,7,3],[29,2,29,3],[33,1,35,1],[33,2,33,10],[34,2,34,6],[34,7,34,9],[34,10,35,10]]}
[null,"Tableau 3 - Université de Bretagne Sud (0561718N) : Fondation universitaire"]
[null,"Dépenses par destination et recettes par origine - Compte Financier 2022"]
[]
[null,"POUR INFORMATION DE L'ORGANE DÉLIBÉRANT"]
[null,"Tableau des dépenses par destination (obligatoire)"]
[null,"Budget","Dépenses de l’organisme"]
[null,null,"Personnel",null,"Fonctionnement et intervention",null,"Investissement",null,"Total"]
[null,null,"AE = CP",null,"AE","CP","AE","CP","AE","CP"]
[null,"Formation initiale et continue (d) = (a) + (b) + (c)",{"$f":"SUM(C10:C12)","v":17853.509999999998},{"$f":"SUM(D10:D12)","v":17853.509999999998},0,0,0,0,{"$f":"C9+E9+G9","v":17853.509999999998},{"$f":"D9+F9+H9","v":17853.509999999998}]
[null,"D101 - Formation initiale et continue de niveau Licence (a)",0,0,0,0,0,0,{"$f":"C10+E10+G10","v":0},0]
[null,"D102 - Formation initiale et continue de niveau Master (b)",0,0,0,0,0,0,0,0]
[null,"D103 - Formation initiale et continue de niveau Doctorat (c) ",17853.509999999998,17853.509999999998,0,0,0,0,17853.509999999998,17853.509999999998]
[null,"D105 - Bibliothèques et documentation",null,0,null,null,null,null,0,0]
[null,"D106 - Recherche universitaire en sciences de la vie, biotechnologie et santé",0,0,0,0,0,0,0,0]
[null,"D107 -  Recherche universitaire en mathématiques, sciences et techniques de l'information et de la communication, micro et nanotechnologies",43129.86,43129.86,13890.01,18888.68,138,678,57157.87,62696.54]
[null,"D108 -  Recherche universitaire en physique, chimie et sciences pour l'ingénieur",0,0,0,0,0,0,0,0]
[null,"D109 -  Recherche universitaire en physique nucléaire et des hautes énergies",0,0,0,0,0,0,0,0]
[null,"D110 -  Recherche universitaire en sciences de la terre, de l'univers et de l'environnement",0,0,105382.72,104878.67,849.66,0,106232.38,104878.67]
[null,"D111 -  Recherche universitaire en sciences de l'homme et de la société",0,0,4696.95,4717.1099999999997,0,0,4696.95,4717.1099999999997]
[null,"D112 -  Recherche universitaire interdisciplinaire et transversale",0,0,302.89999999999998,120,0,0,302.89999999999998,120]
[null,"D113 -  Diffusion des savoirs et musées",null,null,null,null,null,null,0,0]
[null,"D114 - Immobilier",0,0,232.7,232.7,0,0,232.7,232.7]
[null,"D115 - Pilotage et support",44070.31,44070.31,-11882.37,-11537.83,0,0,32187.939999999995,32532.479999999996]
[null,"Étudiants (h) = (e) + (f) + (g)",null,null,null,null,null,null,0,0]
[null,"D201 - Aides directes aux étudiants (e)",null,null,null,null,null,null,0,0]
[null,"D202 - Aides indirectes (f)",null,null,null,null,null,null,0,0]
[null,"D203 - Santé des étudiants et activités associatives, culturelles et sportives (g)",null,{"$f":"+C27","v":0},null,null,null,null,0,0]
[null,"Total",{"$f":"SUM(C10:C24)","v":105053.68},{"$f":"SUM(D10:D24)","v":105053.68},112622.90999999999,117299.33,987.66,678,{"$f":"C28+E28+G28","v":218664.24999999997},{"$f":"D28+F28+H28","v":223031.01}]
[]
[null,null,{"$f":"IF(SUM(C9:C28)<>SUM(D9:D28),\"! Dépenses de personnel AE <> CP\",\"\")","v":""},null,null,null,null,"SOLDE BUDGETAIRE (excédent)",null,{"$f":"IF(K50>J28,K50-J28,0)","v":102901.31}]
[]
[null,"Tableau des recettes par origine (obligatoire)"]
[]
[null,"Budget","Recettes de l'organisme"]
[null,null,"Recettes globalisées",null,null,null,null,"Recettes fléchées",null,null,"Total"]
[null,null,"Subvention pour charges de service public","Autres financements de l'Etat","Fiscalité affectée","Autres financements publics","Recettes propres","Financements de l'Etat fléchés","Autres financements publics fléchés","Recettes propres fléchées"]
[null,"Subvention pour charges de service public",0,0,0,0,0,0,0,0,{"$f":"C37","v":0}]
[null,"Droits d'inscription",0,0,0,0,0,0,0,0,{"$f":"SUM(G38:J38)","v":0}]
[null,"Formation continue, diplômes propres et VAE",0,0,0,0,0,0,0,0,{"$f":"SUM(G39:J39)","v":0}]
[null,"Taxe d'apprentissage",0,0,0,0,0,0,0,0,0]
[null,"Contrats et prestations de recherche hors ANR",0,0,0,0,0,0,0,0,0]
[null,"Valorisation",0,0,0,0,3000,0,0,0,3000]
[null,"ANR investissements d'avenir",0,0,0,0,0,0,0,0,{"$f":"SUM(F43,H43:J43)","v":0}]
[null,"ANR hors investissements d'avenir",0,0,0,0,0,0,0,0,{"$f":"SUM(F44,H44:J44)","v":0}]
[null,"Subventions d'exploitation et financement des actifs - Région",0,0,0,0,0,0,0,0,0]
[null,"Subventions d'exploitation et financement des actifs - Union Européenne",0,0,0,0,0,0,0,0,0]
[null,"Subventions d'exploitation et financement des actifs - Autres",0,20520.32,0,59000,0,0,0,0,{"$f":"SUM(D47,F47:J47)","v":79520.320000000007}]
[null,"Fondations - fonds propres, réserves, dons et legs",0,0,0,0,241912,0,0,0,{"$f":"SUM(D48,F48:J48)","v":241912}]
[null,"Autres recettes",0,0,0,0,1500,0,0,0,{"$f":"SUM(F49:J49)","v":1500}]
[null,"Total",{"$f":"C37","v":0},{"$f":"SUM(D47:D48)","v":20520.32},{"$f":"SUM(E47:E48)","v":0},{"$f":"SUM(F43:F49)","v":59000},{"$f":"SUM(G38:G42,G47:G49)","v":246412},{"$f":"SUM(H38:H49)","v":0},{"$f":"SUM(I38:I49)","v":0},0,{"$f":"SUM(K37:K49)","v":325932.32}]
[]
[null,"La liste des destination est susceptible d'être modifiée par le ministre chargé de l'enseignement supérieur",null,null,null,null,null,null,"SOLDE BUDGETAIRE (déficit)",null,{"$f":"IF(J28>K50,J28-K50,0)","v":0},{"$f":"IF(ROUND(K52,-1)<>ROUND('2-tab_aut_budg_FU'!L30,-1),\"! Incohérence solde budgétaire avec Tab2 FU\",\"\")","v":""}]
[null,null,{"$f":"IF(ROUND(C50,-1)<>ROUND('2-tab_aut_budg_FU'!L12,-1),\"! Incohérence total Subv charges serv public avec Tab2 FU\",\"\")","v":""},{"$f":"IF(ROUND(D50,-1)<>ROUND('2-tab_aut_budg_FU'!L13,-1),\"! Incohérence total Autres financements Etat avec Tab2 FU\",\"\")","v":""},{"$f":"IF(ROUND(E50,-1)<>ROUND('2-tab_aut_budg_FU'!L14,-1),\"! Incohérence total Fiscalité affectée avec Tab2 FU\",\"\")","v":""},{"$f":"IF(ROUND(F50,-1)<>ROUND('2-tab_aut_budg_FU'!L15,-1),\"! Incohérence total Autres financements publics avec Tab2 FU\",\"\")","v":""},{"$f":"IF(ROUND(G50,-1)<>ROUND('2-tab_aut_budg_FU'!L16,-1),\"! Incohérence total Recettes propres avec Tab2 FU\",\"\")","v":""},{"$f":"IF(ROUND(H50,-1)<>ROUND('2-tab_aut_budg_PRINC'!L19,-1),\"! Incohérence total Financements Etat fléchés avec Tab2 PRINC\",\"\")","v":""},{"$f":"IF(ROUND(I50,-1)<>ROUND('2-tab_aut_budg_FU'!L20,-1),\"! Incohérence total Autres financements fléchés avec Tab2 PRINC\",\"\")","v":""},{"$f":"IF(ROUND(J50,-1)<>ROUND('2-tab_aut_budg_PRINC'!L21,-1),\"! Incohérence total Recettes propres fléchées avec Tab2 PRINC\",\"\")","v":""}]

{"sheet":"4-tab_financier_ETAB","index":12,"n_rows":67,"n_cols":14,"rows_kept":67,"cut":false,"hidden":false,"merged":[[18,11,19,11],[22,11,22,13],[27,11,28,11],[24,13,28,13],[10,13,20,13],[12,11,13,11],[8,1,8,4],[8,6,8,9],[4,1,4,9],[1,1,1,9],[0,1,0,9],[43,1,43,4],[43,7,43,10],[44,2,44,3],[44,4,44,5],[44,7,44,8],[44,9,44,10]]}
[null,"Tableau 4 - Université de Bretagne Sud (0561718N) : Etablissement principal + Fondation"]
[null,"Equilibre financier - Compte Financier 2022"]
[]
[]
[null,"POUR VOTE DE L'ORGANE DÉLIBÉRANT"]
[]
[]
[]
[null,"Besoins (utilisation des financements)"]
[null,null," Budget initial \n2022"," Dernier Budget Modifié \n2022"," Compte Financier \n2022",null," Budget initial \n2022"," Dernier Budget Modifié \n2022"," Compte Financier \n2022"]
[null,"Solde budgétaire (déficit) * (D2)",{"$f":"+'2-tab_aut_budg_ETAB'!J30","v":1739220.1700000167},{"$f":"+'2-tab_aut_budg_ETAB'!K30","v":787815.1400000006},{"$f":"+'2-tab_aut_budg_ETAB'!L30","v":0},null,{"$f":"'2-tab_aut_budg_ETAB'!D30","v":0},{"$f":"'2-tab_aut_budg_ETAB'!F30","v":0},{"$f":"'2-tab_aut_budg_ETAB'!H30","v":107904.76999998093},"Solde budgétaire (excédent) * (D1)",null,null,null,"Opérations ayant un impact sur la trésorerie"]
[null,"dont solde budgétaire budget principal",{"$f":"'2-tab_aut_budg_PRINC'!J30","v":1873895.1700000167},{"$f":"'2-tab_aut_budg_PRINC'!K30","v":841431.02000001073},{"$f":"'2-tab_aut_budg_PRINC'!L30","v":0},null,{"$f":"'2-tab_aut_budg_PRINC'!D30","v":0},{"$f":"'2-tab_aut_budg_PRINC'!F30","v":0},{"$f":"'2-tab_aut_budg_PRINC'!H30","v":5003.4599999934435},"dont solde budgétaire budget principal"]
[null,"dont solde budgétaire budget du SAIC",null,null,null,null,null,null,null,"dont solde budgétaire budget du SAIC",null,"Opérations budgétaires"]
[null,"dont solde budgétaire FU",{"$f":"'2-tab_aut_budg_FU'!J30","v":0},{"$f":"'2-tab_aut_budg_FU'!K30","v":0},{"$f":"'2-tab_aut_budg_FU'!L30","v":0},null,{"$f":"'2-tab_aut_budg_FU'!D30","v":134675},{"$f":"'2-tab_aut_budg_FU'!F30","v":53615.880000000005},{"$f":"'2-tab_aut_budg_FU'!H30","v":102901.31},"dont solde budgétaire FU"]
[null,"dont solde budgétaire BAI",null,null,null,null,null,null,null,"dont solde budgétaire BAI"]
[]
[null,"Remboursements d'emprunts (capital) ;\nNouveaux prêts (capital) ;\nDépôts et cautionnements (b1)",null,null,{"$f":"'7-tab Plan_tréso_ETAB'!O42","v":0},null,null,null,{"$f":"'7-tab Plan_tréso_ETAB'!O22","v":0},"Nouveaux emprunts (capital) ;\nRemboursements de prêts (capital) ;\nDépôts et cautionnements (b2)"]
[]
[null,"Opérations au nom et pour le compte de tiers **\n(décaissements de l’exercice) (c1)",{"$f":"'5-tab compte de tiers_ETAB'!E15","v":2487504.9909732803},1807052,{"$f":"'5-tab compte de tiers_ETAB'!I15","v":2263175.54},null,{"$f":"'5-tab compte de tiers_ETAB'!F15","v":2948410.3910611598},1976404,{"$f":"'5-tab compte de tiers_ETAB'!J15","v":2461090.6100000003},"Opérations au nom et pour le compte de tiers **\n(encaissements de l’exercice) (c2)",null,"Opérations non budgétaires"]
[null,null,null,0,null,null,null,0]
[null,"Autres décaissements sur comptes de tiers\n(non budgétaires) (e1)",null,null,{"$f":"'7-tab Plan_tréso_ETAB'!O46","v":1024155.4400000001},null,null,0,{"$f":"'7-tab Plan_tréso_ETAB'!O26","v":1322007.399999998},"Autres encaissements sur comptes de tiers\n(non budgétaires) (e2)"]
[]
[null,"Sous-total des opérations ayant un impact négatif sur la trésorerie de l'organisme (1= D2+b1+c1+e1)",{"$f":"C11+C17+C19+C21","v":4226725.1609732974},{"$f":"D11+D17+D19+D21","v":2594867.1400000006},{"$f":"E11+E17+E19+E21","v":3287330.98},"et",{"$f":"G11+G17+G19+G21","v":2948410.3910611598},{"$f":"H11+H17+H19+H21","v":1976404},{"$f":"I11+I17+I19+I21","v":3891002.7799999793},"Sous-total des opérations ayant un impact positif sur la trésorerie de l'organisme (2=D1+b2+c2+e2)",null,"La variation de trésorerie :\n- se détermine par différence entre (1) et (2),\n- se décompose en (a) et (d),\n- s'explique par D, (b), (c), (e)."]
[null,"Variation de trésorerie (I)",{"$f":"IF(G23-C23>0,G23-C23,)","v":0},{"$f":"IF(H23-D23>0,H23-D23,)","v":0},{"$f":"IF(I23-E23>0,I23-E23,)","v":603671.79999997932},"ou",{"$f":"IF(C23-G23>0,C23-G23,0)","v":1278314.7699121376},{"$f":"IF(D23-H23>0,D23-H23,0)","v":618463.1400000006},{"$f":"IF(E23-I23>0,E23-I23,0)","v":0},"Variation de trésorerie (II)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Décomposition de la variation de trésorerie"]
[null,"dont Abondement de la trésorerie fléchée *** (a1)",null,1929527,{"$f":"'7-tab Plan_tréso_ETAB'!O15-'7-tab Plan_tréso_ETAB'!O34","v":2019075.04},"ou",null,null,null,"dont Prélèvement sur la trésorerie fléchée *** (a2)"]
[]
[null,"dont Abondement sur la trésorerie non fléchée (d1)",null,null,null,"ou",{"$f":"G24","v":1278314.7699121376},2547990.1400000174,{"$f":"E26-E24","v":1415403.2400000207},"dont Prélèvement sur la trésorerie non fléchée (d2)",null,"= différence entre variation de trésorerie (I ou II) et (a)"]
[]
[null,"TOTAL DES BESOINS (1 + I)",{"$f":"C24+C23","v":4226725.1609732974},{"$f":"D24+D23","v":2594867.1400000006},{"$f":"E24+E23","v":3891002.7799999793},"et",{"$f":"G24+G23","v":4226725.1609732974},2594867.1400000006,3891002.7799999793,"TOTAL DES FINANCEMENTS (2 + II)"]
[]
[null,"* solde budgétaire à détailler pour chaque composante du budget de l'établissement",{"$f":"IF(ROUND(C11,-1)<>ROUND('2-tab_aut_budg_ETAB'!J30,-1),\"! Incohérence solde budgétaire BI avec Tab2 ETAB\",\"\")","v":""},{"$f":"IF(ROUND(D11,-1)<>ROUND('2-tab_aut_budg_ETAB'!K30,-1),\"! Incohérence solde budgétaire BR avec Tab2 ETAB\",\"\")","v":""},{"$f":"IF(ROUND(E11,-1)<>ROUND('2-tab_aut_budg_ETAB'!L30,-1),\"! Incohérence solde budgétaire COFI avec Tab2 ETAB\",\"\")","v":""},null,{"$f":"IF(ROUND(G11,-1)<>ROUND('2-tab_aut_budg_ETAB'!D30,-1),\"! Incohérence solde budgétaire BI avec Tab2 ETAB\",\"\")","v":""},{"$f":"IF(ROUND(H11,-1)<>ROUND('2-tab_aut_budg_ETAB'!F30,-1),\"! Incohérence solde budgétaire BR avec Tab2 ETAB\",\"\")","v":""},{"$f":"IF(ROUND(I11,-1)<>ROUND('2-tab_aut_budg_ETAB'!H30,-1),\"! Incohérence solde budgétaire COFI avec Tab2 ETAB\",\"\")","v":""}]
[null,"Montant issu du tableau \"Autorisations budgétaires\" (tableau 2)",null,{"$f":"IF(ROUND(E11,-1)<>ROUND('3-tab_destination_origine_ETAB'!K52,-1),\"! Incohérence solde budgétaire avec Tab3 ETAB\",\"\")","v":""},{"$f":"IF(ROUND(E19,-1)<>ROUND('5-tab compte de tiers_ETAB'!I15,-1),\"! Incohérence décaissements tiers avec Tab5\",\"\")","v":""},null,null,{"$f":"IF(ROUND(I11,-1)<>ROUND('3-tab_destination_origine_ETAB'!J30,-1),\"! Incohérence solde budgétaire avec Tab3 ETAB\",\"\")","v":""},{"$f":"IF(ROUND(I19,-1)<>ROUND('5-tab compte de tiers_ETAB'!J15,-1),\"! Incohérence encaissements tiers avec Tab5\",\"\")","v":""}]
[null,"** Montants issus du tableau \"Opérations pour compte de tiers\" (tableau 5)",null,null,{"$f":"IF(ROUND(E19+E21,-1)<>ROUND('7-tab Plan_tréso_ETAB'!O43,-1),\"! Incohérence décaissements tiers avec Tab7\",\"\")","v":""},null,null,null,{"$f":"IF(ROUND(I19+I21,-1)<>ROUND('7-tab Plan_tréso_ETAB'!O23,-1),\"! Incohérence encaissements tiers avec Tab7\",\"\")","v":""}]
[null,"*** Montant issu du tableau \"Opérations sur recettes fléchées\" (tableau 8)",{"$f":"IF('6-tab CR_TF_ETAB'!F48<=0,IF(ROUND('6-tab CR_TF_ETAB'!F48,-1)<>-ROUND(G24,-1),\"! Incohérence var trésorerie BI Tab6 ETAB\",\"\"),IF(ROUND('6-tab CR_TF_ETAB'!F48,-1)<>ROUND(C25,-1),\"! Incohérence var trésorerie BI Tab6 ETAB\",\"\"))","v":""},{"$f":"IF('6-tab CR_TF_ETAB'!G48<=0,IF(ROUND('6-tab CR_TF_ETAB'!G48,-1)<>-ROUND(H24,-1),\"! Incohérence var trésorerie BR tot Tab6 ETAB\",\"\"),IF(ROUND('6-tab CR_TF_ETAB'!G48,-1)<>ROUND(D25,-1),\"! Incohérence var trésorerie BR tot Tab6 ETAB\",\"\"))","v":""},{"$f":"IF('6-tab CR_TF_ETAB'!H48<=0,IF(ROUND('6-tab CR_TF_ETAB'!H48,-1)<>-ROUND(I24,-1),\"! Incohérence var trésorerie Total Tab6 ETAB\",\"\"),IF(ROUND('6-tab CR_TF_ETAB'!H48,-1)<>ROUND(E24,-1),\"! Incohérence var trésorerie Total Tab6 ETAB\",\"\"))","v":""},null,null,null,{"$f":"IF('7-tab Plan_tréso_ETAB'!O48<=0,IF(-ROUND('7-tab Plan_tréso_ETAB'!O48,-1)<>ROUND('4-tab_financier_ETAB'!I24,-1),\"! Incohérence variation de trésorerie Tab7\",\"\"),IF(ROUND('7-tab Plan_tréso_ETAB'!O48,-1)<>ROUND('4-tab_financier_ETAB'!E24,-1),\"! Incohérence variation trésorerie Tab7\",\"\"))","v":""}]
[]
[null,"SAIC : service d'activités industrielles et commerciales"]
[null,"FU : fondation universitaire"]
[null,"BAI : budget annexe immobilier"]
[null,"SIE : service inter-établissements"]
[]
[]
[null,"COMPARAISON COFI / BI et COFI / BR"]
[null,"Besoins (utilisation des financements)"]
[null,null,"Evolution COFI / BI",null,"Evolution COFI / BR",null,null,"Evolution COFI / BI",null,"Evolution COFI / BR"]
[null,null,"en valeur","en %","en valeur","en %",null,"en valeur","en %","en valeur","en %"]
[null,"Solde budgétaire (déficit) * (D2)",{"$f":"E11-C11","v":-1739220.1700000167},{"$f":"IF(E11=0,0,(E11-C11)/E11)","v":0},{"$f":"E11-D11","v":-787815.1400000006},{"$f":"IF(E11=0,0,(E11-D11)/E11)","v":0},null,{"$f":"I11-G11","v":107904.76999998093},{"$f":"IF(I11=0,0,(I11-G11)/I11)","v":1},{"$f":"I11-H11","v":107904.76999998093},{"$f":"IF(I11=0,0,(I11-H11)/I11)","v":1},"Solde budgétaire (excédent) * (D1)"]
[null,"dont solde budgétaire budget principal",{"$f":"E12-C12","v":-1873895.1700000167},{"$f":"IF(E12=0,0,(E12-C12)/E12)","v":0},{"$f":"E12-D12","v":-841431.02000001073},{"$f":"IF(E12=0,0,(E12-D12)/E12)","v":0},null,{"$f":"I12-G12","v":5003.4599999934435},{"$f":"IF(I12=0,0,(I12-G12)/I12)","v":1},{"$f":"I12-H12","v":5003.4599999934435},{"$f":"IF(I12=0,0,(I12-H12)/I12)","v":1},"dont solde budgétaire budget principal"]
[null,"dont solde budgétaire budget du SAIC",{"$f":"E13-C13","v":0},{"$f":"IF(E13=0,0,(E13-C13)/E13)","v":0},{"$f":"E13-D13","v":0},{"$f":"IF(E13=0,0,(E13-D13)/E13)","v":0},null,{"$f":"I13-G13","v":0},{"$f":"IF(I13=0,0,(I13-G13)/I13)","v":0},{"$f":"I13-H13","v":0},{"$f":"IF(I13=0,0,(I13-H13)/I13)","v":0},"dont solde budgétaire budget du SAIC"]
[null,"dont solde budgétaire FU",{"$f":"E14-C14","v":0},{"$f":"IF(E14=0,0,(E14-C14)/E14)","v":0},{"$f":"E14-D14","v":0},{"$f":"IF(E14=0,0,(E14-D14)/E14)","v":0},null,{"$f":"I14-G14","v":-31773.690000000002},{"$f":"IF(I14=0,0,(I14-G14)/I14)","v":-0.30877828474681229},{"$f":"I14-H14","v":49285.429999999993},{"$f":"IF(I14=0,0,(I14-H14)/I14)","v":0.47895823678046462},"dont solde budgétaire FU"]
[null,"dont solde budgétaire BAI",{"$f":"E15-C15","v":0},{"$f":"IF(E15=0,0,(E15-C15)/E15)","v":0},{"$f":"E15-D15","v":0},{"$f":"IF(E15=0,0,(E15-D15)/E15)","v":0},null,{"$f":"I15-G15","v":0},{"$f":"IF(I15=0,0,(I15-G15)/I15)","v":0},{"$f":"I15-H15","v":0},{"$f":"IF(I15=0,0,(I15-H15)/I15)","v":0},"dont solde budgétaire BAI"]
[null,"dont solde budgétaire SIE",{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,0,(#REF!-#REF!)/#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,0,(#REF!-#REF!)/#REF!)","v":{"$error":"#REF!"}},null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,0,(#REF!-#REF!)/#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,0,(#REF!-#REF!)/#REF!)","v":{"$error":"#REF!"}},"dont solde budgétaire SIE"]
[]
[null,"Remboursements d'emprunts (capital) ;\nNouveaux prêts (capital) ;\nDépôts et cautionnements (b1)",{"$f":"E17-C17","v":0},{"$f":"IF(E17=0,0,(E17-C17)/E17)","v":0},{"$f":"E17-D17","v":0},{"$f":"IF(E17=0,0,(E17-D17)/E17)","v":0},null,{"$f":"I17-G17","v":0},{"$f":"IF(I17=0,0,(I17-G17)/I17)","v":0},{"$f":"I17-H17","v":0},{"$f":"IF(I17=0,0,(I17-H17)/I17)","v":0},"Nouveaux emprunts (capital) ;\nRemboursements de prêts (capital) ;\nDépôts et cautionnements (b2)"]
[]
[null,"Opérations au nom et pour le compte de tiers **\n(décaissements de l’exercice) (c1)",-224329.45097328024,-9.9121542721021208E-2,456123.54000000004,0.20154138816823727,null,-487319.78106115945,-0.1980096868766483,484686.61000000034,0.19693976647206837,"Opérations au nom et pour le compte de tiers **\n(encaissements de l’exercice) (c2)"]
[]
[null,"Autres décaissements sur comptes de tiers\n(non budgétaires) (e1)",1024155.4400000001,1,1024155.4400000001,1,null,1322007.399999998,1,1322007.399999998,1,"Autres encaissements sur comptes de tiers\n(non budgétaires) (e2)"]
[]
[null,"Sous-total des opérations ayant un impact négatif sur la trésorerie de l'organisme (1= D2+b1+c1+e1)",-939394.18097329745,-0.28576197124309566,692463.83999999939,0.2106462185319713,"et",942592.38893881952,0.24224922011976166,1914598.7799999793,0.49205793165739897,"Sous-total des opérations ayant un impact positif sur la trésorerie de l'organisme (2=D1+b2+c2+e2)"]
[null,"Variation de trésorerie (I)",603671.79999997932,1,603671.79999997932,1,"ou",-1278314.7699121376,0,-618463.1400000006,0,"Variation de trésorerie (II)"]
[]
[null,"dont Abondement de la trésorerie fléchée *** (a1)",2019075.04,1,89548.040000000037,4.4351021247828429E-2,"ou",0,0,0,0,"dont Prélèvement sur la trésorerie fléchée *** (a2)"]
[]
[null,"dont Abondement sur la trésorerie non fléchée (d1)",0,0,0,0,"ou",137088.47008788306,9.6854709819571311E-2,-1132586.8999999966,-0.80018673689059805,"dont Prélèvement sur la trésorerie non fléchée (d2)"]
[]
[null,"TOTAL DES BESOINS (1 + I)",-335722.38097331813,-8.6281711927566368E-2,1296135.6399999787,0.33311095192792067,"et",-335722.38097331813,-8.6281711927566368E-2,1296135.6399999787,0.33311095192792067,"TOTAL DES FINANCEMENTS (2 + II)"]

{"sheet":"5-tab compte de tiers_ETAB","index":13,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,1,0,9],[1,1,1,9],[14,1,14,3],[17,1,17,5],[7,4,7,5],[7,6,7,7],[7,8,7,9],[6,1,6,5]]}
[null,"Tableau 5 - Université de Bretagne Sud (0561718N) : Etablissement principal + Fondation "]
[null,"Opérations pour le compte de tiers - Compte Financier 2022"]
[]
[]
[null,"POUR INFORMATION DE L'ORGANE DÉLIBÉRANT"]
[]
[]
[null,null,null,null,"Budget Initial",null,"Dernier Budget Modifié",null,"Compte Financier"]
[null,"Opérations ou regroupement d'opérations de même nature","Comptes","Libellé","Prévisions de décaissements","Prévisions d'encaissements","Prévisions de décaissements","Prévisions d'encaissements","décaissements","encaissements"]
[null,"Opération 1","C  4731","Bourse mobilité internationale",97200,162000,77184,160800,112000,160800]
[null,"Opération  2","C  4731","TVA",876254.99097328028,841410.39106116001,680000,400000,654538.53,437917.6]
[null,"Opération 3","C  44571 et C 44551","Projet Flower (Interreg)",351550,445000,550002,550002,631035.04,631035.04]
[null,"Opération 4","C  4731","Projet Indigo (Interreg)",1162500,1500000,499866,499866,499865.97,499865.97]
[null,"Opération 5",null,"Projet Cyberus ",null,null,0,365736,365736,731472]
[null,"TOTAL",null,null,{"$f":"+SUM(E10:E13)","v":2487504.9909732803},{"$f":"+SUM(F10:F13)","v":2948410.3910611598},{"$f":"+SUM(G10:G14)","v":1807052},{"$f":"+SUM(H10:H14)","v":1976404},{"$f":"+SUM(I10:I14)","v":2263175.54},{"$f":"+SUM(J10:J14)","v":2461090.6100000003}]
[null,null,null,null,"(c1)","(c2)"]
[null,null,null,"(c1) et (c2) étant repris au tableau \"Équilibre financier\" (tableau 4)"]
[null,"N.B. : Dans l'hypothèse d'un écart entre les crédits et les débits d'un même compte, l'opération concernée devra faire l'objet d'une explication spécifique."]
[]
["*","L'écart entre les encaissements et les décaissements \"bourse de mobilité internationale\" s'explique par un décalage habituel compte tenu des périodes de mobilité des bénéficiaires",null,null,{"$f":"IF(ROUND(E15,-1)<>ROUND('4-tab_financier_ETAB'!C19,-1),\"! Incohérence total décaissements tiers avec Tab4\",\"\")","v":""},{"$f":"IF(ROUND(F15,-1)<>ROUND('4-tab_financier_ETAB'!G19,-1),\"! Incohérence total encaissements tiers avec Tab4\",\"\")","v":""},{"$f":"IF(ROUND(G15,-1)<>ROUND('4-tab_financier_ETAB'!D19,-1),\"! Incohérence total décaissements tiers avec Tab4\",\"\")","v":""},{"$f":"IF(ROUND(H15,-1)<>ROUND('4-tab_financier_ETAB'!H19,-1),\"! Incohérence total encaissements tiers avec Tab4\",\"\")","v":""},{"$f":"IF(ROUND(I15,-1)<>ROUND('4-tab_financier_ETAB'!E19,-1),\"! Incohérence total décaissements tiers avec Tab4\",\"\")","v":""},{"$f":"IF(ROUND(J15,-1)<>ROUND('4-tab_financier_ETAB'!I19,-1),\"! Incohérence total encaissements tiers avec Tab4\",\"\")","v":""}]
["**","Le décalage sur les opérations d'encaissement et de décaissement de TVA est classique compte tenu de l'activité économique"]

{"sheet":"6-tab CR_TF_ETAB","index":14,"n_rows":53,"n_cols":21,"rows_kept":53,"cut":false,"hidden":false,"merged":[[6,11,6,12],[6,13,6,14],[6,16,6,17],[6,18,6,19],[0,0,0,7],[1,0,1,7],[3,0,3,7],[5,11,5,14],[5,16,5,19],[31,16,31,19],[32,11,32,12],[32,13,32,14],[32,16,32,17],[32,18,32,19],[43,13,43,14],[10,0,11,0],[19,11,19,12],[19,13,19,14],[31,11,31,14],[35,0,37,0],[35,1,37,1],[35,2,37,2],[43,11,43,12],[35,3,37,3],[50,0,50,4],[44,0,44,4],[45,0,45,4],[46,0,46,4],[47,0,47,4],[48,0,48,4],[49,0,49,4]]}
["Tableau 6 - Université de Bretagne Sud (0561718N) : Etablissement principal + Fondation"]
["Situation patrimoniale - Compte Financier 2022"]
[]
["POUR VOTE DE L'ORGANE DÉLIBÉRANT"]
[]
["Compte de résultat prévisionnel",null,null,null,null,null,null,null,null,null,null,"CHARGES",null,null,null,null,"PRODUITS"]
[null,null,null,null,null,null,null,null,null,null,null,"Evolution COFI / BI",null,"Evolution COFI / BR",null,null,"Evolution COFI / BI",null,"Evolution COFI / BR"]
["CHARGES","Budget initial\n2022","Dernier Budget Modifié\n2022","Compte Financier\n2022","PRODUITS","Budget initial\n2022","Dernier Budget Modifié\n2022","Compte Financier\n2022",null,null,null,"en valeur","en %","en valeur","en %",null,"en valeur","en %","en valeur","en %"]
["Personnel",{"$f":"'6-tab CR_TF_PRINC'!B9+'6-tab CR_TF_FU'!B9","v":75343549},{"$f":"'6-tab CR_TF_PRINC'!C9+'6-tab CR_TF_FU'!C9","v":74930748.769999996},{"$f":"'6-tab CR_TF_PRINC'!D9+'6-tab CR_TF_FU'!D9","v":73619346.530000001},"Subventions de l'Etat",{"$f":"'6-tab CR_TF_PRINC'!F9+'6-tab CR_TF_FU'!F9","v":70854541},{"$f":"'6-tab CR_TF_PRINC'!G9+'6-tab CR_TF_FU'!G9","v":71034662.689999998},{"$f":"'6-tab CR_TF_PRINC'!H9+'6-tab CR_TF_FU'!H9","v":71315703.879999995},null,null,"Personnel",{"$f":"D9-B9","v":-1724202.4699999988},{"$f":"IF(D9=0,0,(D9-B9)/D9)","v":-2.3420507669100046E-2},{"$f":"D9-C9","v":-1311402.2399999946},{"$f":"IF(D9=0,0,(D9-C9)/D9)","v":-1.7813282809642925E-2},null,{"$f":"H9-F9","v":461162.87999999523},{"$f":"IF(H9=0,0,(H9-F9)/H9)","v":6.4664983293998618E-3},{"$f":"H9-G9","v":281041.18999999762},{"$f":"IF(H9=0,0,(H9-G9)/H9)","v":3.9408037039484894E-3},"Subventions de l'Etat"]
["dont charges de pensions civiles*",{"$f":"'6-tab CR_TF_PRINC'!B10+'6-tab CR_TF_FU'!B10","v":20455893},{"$f":"'6-tab CR_TF_PRINC'!C10+'6-tab CR_TF_FU'!C10","v":19827314},{"$f":"'6-tab CR_TF_PRINC'!D10+'6-tab CR_TF_FU'!D10","v":19889158.25},"Fiscalité affectée",{"$f":"'6-tab CR_TF_PRINC'!F10+'6-tab CR_TF_FU'!F10","v":600000},{"$f":"'6-tab CR_TF_PRINC'!G10+'6-tab CR_TF_FU'!G10","v":600000},{"$f":"'6-tab CR_TF_PRINC'!H10+'6-tab CR_TF_FU'!H10","v":473570.35},null,null,"dont charges de pensions civiles*",{"$f":"D10-B10","v":-566734.75},{"$f":"IF(D10=0,0,(D10-B10)/D10)","v":-2.849465738450746E-2},{"$f":"D10-C10","v":61844.25},{"$f":"IF(D10=0,0,(D10-C10)/D10)","v":3.1094453180289818E-3},null,{"$f":"H10-F10","v":-126429.65000000002},{"$f":"IF(H10=0,0,(H10-F10)/H10)","v":-0.26697121135223106},{"$f":"H10-G10","v":-126429.65000000002},{"$f":"IF(H10=0,0,(H10-G10)/H10)","v":-0.26697121135223106},"Fiscalité affectée"]
["Fonctionnement (autre que les charges de personnel) et intervention",{"$f":"'6-tab CR_TF_PRINC'!B11+'6-tab CR_TF_FU'!B11","v":22087759},{"$f":"'6-tab CR_TF_PRINC'!C11+'6-tab CR_TF_FU'!C11","v":21008402.649999999},{"$f":"'6-tab CR_TF_PRINC'!D11+'6-tab CR_TF_FU'!D11","v":20399917.119999997},"Autres subventions",{"$f":"'6-tab CR_TF_PRINC'!F11+'6-tab CR_TF_FU'!F11","v":5777910},{"$f":"'6-tab CR_TF_PRINC'!G11+'6-tab CR_TF_FU'!G11","v":5536440.6100000003},{"$f":"'6-tab CR_TF_PRINC'!H11+'6-tab CR_TF_FU'!H11","v":4586564.18},null,null,"Fonctionnement",-1687841.8800000027,-8.2737683200940521E-2,-608485.53000000119,-2.9827843241747507E-2,null,-1191345.8200000003,-0.25974689838527459,-949876.43000000063,-0.20709977942574015,"Autres subventions"]
[null,{"$f":"'6-tab CR_TF_PRINC'!B12+'6-tab CR_TF_FU'!B12","v":0},{"$f":"'6-tab CR_TF_PRINC'!C12+'6-tab CR_TF_FU'!C12","v":0},{"$f":"'6-tab CR_TF_PRINC'!D12+'6-tab CR_TF_FU'!D12","v":0},"Autres produits",{"$f":"'6-tab CR_TF_PRINC'!F12+'6-tab CR_TF_FU'!F12","v":19869459},{"$f":"'6-tab CR_TF_PRINC'!G12+'6-tab CR_TF_FU'!G12","v":19336263.350000001},{"$f":"'6-tab CR_TF_PRINC'!H12+'6-tab CR_TF_FU'!H12","v":20019373.370000001},null,null,null,null,null,null,null,null,149914.37000000104,7.4884646601703813E-3,683110.01999999955,3.412244765980902E-2,"Autres produits"]
["TOTAL DES CHARGES (1)",{"$f":"B9+B11","v":97431308},{"$f":"C9+C11","v":95939151.419999987},{"$f":"D9+D11","v":94019263.650000006},"TOTAL DES PRODUITS (2)",{"$f":"SUM(F9:F12)","v":97101910},96507366.650000006,{"$f":"SUM(H9:H12)","v":96395211.780000001},null,null,"TOTAL CHARGES",-3412044.349999994,-3.6290906964574952E-2,-1919887.7699999809,-2.0420153226758237E-2,null,-706698.21999999881,-7.3312585443857494E-3,-112154.87000000477,-1.1634900523479587E-3,"TOTAL PRODUITS"]
["Résultat prévisionnel : bénéfice   (3) = (2) - (1)",{"$f":"IF(F13-B13>0,F13-B13,0)","v":0},{"$f":"IF(G13-C13>0,G13-C13,0)","v":568215.23000001907},{"$f":"IF(H13-D13>0,H13-D13,0)","v":2375948.1299999952},"Résultat prévisionnel : perte  (4) = (1) - (2)",{"$f":"IF(B13-F13>0,B13-F13,0)","v":329398},{"$f":"IF(C13-G13>0,C13-G13,0)","v":0},{"$f":"IF(D13-H13>0,D13-H13,0)","v":0},null,null,"Résultat",2375948.1299999952,1,1807732.8999999762,0.76084695502169053,null,-329398,0,0,0,"Résultat"]
["TOTAL EQUILIBRE du compte de résultat prévisionnel (1) + (3) = (2) + (4)",{"$f":"B13+B14","v":97431308},{"$f":"C13+C14","v":96507366.650000006},{"$f":"D13+D14","v":96395211.780000001},"TOTAL EQUILIBRE du compte de résultat prévisionnel (1) + (3)  = (2) + (4)",{"$f":"F13+F14","v":97431308},96507366.650000006,{"$f":"H13+H14","v":96395211.780000001},null,null,"TOTAL",-1036096.2199999988,-1.0748419977173256E-2,-112154.87000000477,-1.1634900523479587E-3,null,-1036096.2199999988,-1.0748419977173256E-2,-112154.87000000477,-1.1634900523479587E-3,"TOTAL"]
["* Il s'agit des sous catégories de comptes présentant les contributions employeur au CAS Pensions.",{"$f":"\"BI : Différence charges de personnel entre tableau 2 et tableau 6 est de : \"&'6-tab CR_TF_ETAB'!B9-ROUND('2-tab_aut_budg_ETAB'!D11+'2-tab_aut_budg_ETAB'!D24,0)","v":"BI : Différence charges de personnel entre tableau 2 et tableau 6 est de : -792705"},{"$f":"\"BR : Différence charges de personnel entre tableau 2 et tableau 6 est de : \"&'6-tab CR_TF_ETAB'!C9-ROUND('2-tab_aut_budg_ETAB'!F11+'2-tab_aut_budg_ETAB'!F24,0)","v":"BR : Différence charges de personnel entre tableau 2 et tableau 6 est de : -791597,230000004"},{"$f":"\"COFI : Différence charges de personnel entre tableau 2 et tableau 6 est de : \"&'6-tab CR_TF_ETAB'!D9-ROUND('2-tab_aut_budg_ETAB'!H11+'2-tab_aut_budg_ETAB'!H24,0)","v":"COFI : Différence charges de personnel entre tableau 2 et tableau 6 est de : -818364,469999999"}]
[null,{"$f":"IF('2-tab_aut_budg_ETAB'!D12=\"\",IF(ROUND(B10,0)<>ROUND('2-tab_aut_budg_ETAB'!D12,0),\"! Incohérence charges PC Tab2 AGR\",\"\"),\"\")","v":""},{"$f":"IF('2-tab_aut_budg_ETAB'!F12=\"\",IF(ROUND(C10,0)<>ROUND('2-tab_aut_budg_ETAB'!F12,0),\"! Incohérence charges PC Tab2 AGR\",\"\"),\"\")","v":""},{"$f":"IF('2-tab_aut_budg_ETAB'!H12=\"\",IF(ROUND(D10,0)<>ROUND('2-tab_aut_budg_ETAB'!H12,0),\"! Incohérence charges PCl Tab2 AGR\",\"\"),\"\")","v":""}]
[]
["Calcul de la capacité d'autofinancement (CAF)"]
[null,null,null,null,null,null,null,null,null,null,null,"Evolution COFI / BI",null,"Evolution COFI / BR"]
[null,"Budget initial\n2022","Dernier Budget Modifié\n2022","Compte Financier\n2022",null,null,null,null,null,null,null,"en valeur","en %","en valeur","en %"]
["Résultat prévisionnel de l'exercice \n(bénéfice (3) ou perte (-4)",{"$f":"IF(B14>0,B14,-F14)","v":-329398},{"$f":"IF(C14>0,C14,-G14)","v":568215.23000001907},{"$f":"IF(D14>0,D14,-H14)","v":2375948.1299999952},null,null,null,null,null,null,null,{"$f":"D22-B22","v":2705346.1299999952},{"$f":"IF(D22=0,0,(D22-B22)/D22)","v":1.1386385484770665},{"$f":"D22-C22","v":1807732.8999999762},{"$f":"IF(D22=0,0,(D22-C22)/D22)","v":0.76084695502169053},null,"Résultat"]
["+  dotations aux amortissements, dépréciations et provisions",{"$f":"'6-tab CR_TF_PRINC'!B23+'6-tab CR_TF_FU'!B23","v":7659161},{"$f":"'6-tab CR_TF_PRINC'!C23+'6-tab CR_TF_FU'!C23","v":7091877},{"$f":"'6-tab CR_TF_PRINC'!D23+'6-tab CR_TF_FU'!D23","v":7519105.4100000001},null,null,null,null,null,null,null,{"$f":"D23-B23","v":-140055.58999999985},{"$f":"IF(D23=0,0,(D23-B23)/D23)","v":-1.8626629414415917E-2},{"$f":"D23-C23","v":427228.41000000015},{"$f":"IF(D23=0,0,(D23-C23)/D23)","v":5.6819047839362598E-2},null,"+  dotations aux amortissements, dépréciations et provisions"]
["-  reprises sur amortissements, dépréciations et provisions",{"$f":"'6-tab CR_TF_PRINC'!B24+'6-tab CR_TF_FU'!B24","v":0},{"$f":"'6-tab CR_TF_PRINC'!C24+'6-tab CR_TF_FU'!C24","v":0},{"$f":"'6-tab CR_TF_PRINC'!D24+'6-tab CR_TF_FU'!D24","v":-540769.59000000008},null,null,null,null,null,null,null,-540769.59000000008,1,-540769.59000000008,1,null,"-  reprises sur amortissements, dépréciations et provisions"]
["+ valeur nette comptable des éléments d'actifs cédés",{"$f":"'6-tab CR_TF_PRINC'!B25+'6-tab CR_TF_FU'!B25","v":0},{"$f":"'6-tab CR_TF_PRINC'!C25+'6-tab CR_TF_FU'!C25","v":0},{"$f":"'6-tab CR_TF_PRINC'!D25+'6-tab CR_TF_FU'!D25","v":0},null,null,null,null,null,null,null,0,0,0,0,null,"+ valeur nette comptable des éléments d'actifs cédés"]
["- produits de cession d'éléments d'actifs",{"$f":"'6-tab CR_TF_PRINC'!B26+'6-tab CR_TF_FU'!B26","v":0},{"$f":"'6-tab CR_TF_PRINC'!C26+'6-tab CR_TF_FU'!C26","v":0},{"$f":"'6-tab CR_TF_PRINC'!D26+'6-tab CR_TF_FU'!D26","v":-2090},null,null,null,null,null,null,null,-2090,1,-2090,1,null,"- produits de cession d'éléments d'actifs"]
["- quote-part des subventions d’investissement virée au résultat de l’exercice",{"$f":"'6-tab CR_TF_PRINC'!B27+'6-tab CR_TF_FU'!B27","v":-5072618},{"$f":"'6-tab CR_TF_PRINC'!C27+'6-tab CR_TF_FU'!C27","v":-4749988},{"$f":"'6-tab CR_TF_PRINC'!D27+'6-tab CR_TF_FU'!D27","v":-4780993.97},null,null,null,null,null,null,null,291624.03000000026,-6.0996527464769065E-2,-31005.969999999739,6.4852560355769997E-3,null,"- quote-part des subventions d’investissement virée au résultat de l’exercice"]
["= CAF ou IAF*",{"$f":"SUM(B22:B27)","v":2257145},{"$f":"SUM(C22:C27)","v":2910104.2300000191},{"$f":"SUM(D22:D27)","v":4571199.9799999958},null,null,null,null,null,null,null,2314054.9799999958,0.50622484033174986,1661095.7499999767,0.36338286604559755,null,"= CAF ou IAF*"]
["* capacité d'autofinancement ou insuffisance d'autofinancement"]
[]
[]
["État prévisionnel de l'évolution de la situation patrimoniale en droits constatés",null,null,null,null,null,null,null,null,null,null,"EMPLOIS",null,null,null,null,"RESSOURCES"]
[null,null,null,null,null,null,null,null,null,null,null,"Evolution COFI / BI",null,"Evolution COFI / BR",null,null,"Evolution COFI / BI",null,"Evolution COFI / BR"]
["EMPLOIS","Budget initial\n2022","Dernier Budget Modifié\n2022","Compte Financier\n2022","RESSOURCES","Budget initial\n2022","Dernier Budget Modifié\n2022","Compte Financier\n2022",null,null,null,"en valeur","en %","en valeur","en %",null,"en valeur","en %","en valeur","en %"]
["Insuffisance d'autofinancement*",{"$f":"IF(B28<0,-B28,0)","v":0},{"$f":"IF(C28<0,-C28,0)","v":0},{"$f":"IF(D28<0,-D28,0)","v":0},"Capacité d'autofinancement*",{"$f":"IF(B28>0,B28,0)","v":2257145},{"$f":"IF(C28>0,C28,0)","v":2910104.2300000191},{"$f":"IF(D28>0,D28,0)","v":4571199.9799999958},null,null,"Insuffisance d'autofinancement",{"$f":"D35-B35","v":0},{"$f":"IF(D35=0,0,(D35-B35)/D35)","v":0},{"$f":"D35-C35","v":0},{"$f":"IF(D35=0,0,(D35-C35)/D35)","v":0},null,{"$f":"H35-F35","v":2314054.9799999958},{"$f":"IF(H35=0,0,(H35-F35)/H35)","v":0.50622484033174986},{"$f":"H35-G35","v":1661095.7499999767},{"$f":"IF(H35=0,0,(H35-G35)/H35)","v":0.36338286604559755},"Capacité d'autofinancement*"]
["Investissements",{"$f":"'6-tab CR_TF_PRINC'!B36+'6-tab CR_TF_FU'!B36","v":7103450},{"$f":"'6-tab CR_TF_PRINC'!C36+'6-tab CR_TF_FU'!C36","v":8344355.4199999999},{"$f":"'6-tab CR_TF_PRINC'!D36+'6-tab CR_TF_FU'!D36","v":6729956.0600000005},"Financement de l'actif par l'État",{"$f":"'6-tab CR_TF_PRINC'!F36+'6-tab CR_TF_FU'!F36","v":150000},{"$f":"'6-tab CR_TF_PRINC'!G36+'6-tab CR_TF_FU'!G36","v":1217182.02},{"$f":"'6-tab CR_TF_PRINC'!H36+'6-tab CR_TF_FU'!H36","v":1351960.02},null,null,"Investissements",{"$f":"D36-B36","v":-373493.93999999948},-5.5497233068115964E-2,-1614399.3599999994,-0.23988260036277254,null,{"$f":"H36-F36","v":1201960.02},0.88904997353398074,134778,9.9690817780247673E-2,"Financement de l'actif par l'État"]
[null,null,null,null,"Financement de l'actif par des tiers autres que l'Etat",{"$f":"'6-tab CR_TF_PRINC'!F37+'6-tab CR_TF_FU'!F37","v":2100000},{"$f":"'6-tab CR_TF_PRINC'!G37+'6-tab CR_TF_FU'!G37","v":2201214.04},{"$f":"'6-tab CR_TF_PRINC'!H37+'6-tab CR_TF_FU'!H37","v":1727861.44},null,null,null,null,null,null,null,null,-372138.56000000006,-0.21537523286589466,-473352.60000000009,-0.27395286973936989,"Financement de l'actif par des tiers autres que l'Etat"]
[null,null,null,null,"Autres ressources",{"$f":"'6-tab CR_TF_PRINC'!F38+'6-tab CR_TF_FU'!F38","v":488495},{"$f":"'6-tab CR_TF_PRINC'!G38+'6-tab CR_TF_FU'!G38","v":458086},{"$f":"'6-tab CR_TF_PRINC'!H38+'6-tab CR_TF_FU'!H38","v":-330912.15000000002},null,null,null,null,null,null,null,null,-819407.15,2.4762075070377438,-788998.15,2.3843130268864408,"Autres ressources"]
["Remboursement des dettes financières",{"$f":"'6-tab CR_TF_PRINC'!B39+'6-tab CR_TF_FU'!B39","v":0},{"$f":"'6-tab CR_TF_PRINC'!C39+'6-tab CR_TF_FU'!C39","v":0},{"$f":"'6-tab CR_TF_PRINC'!D39+'6-tab CR_TF_FU'!D39","v":0},"Augmentation des dettes financières",{"$f":"'6-tab CR_TF_PRINC'!F39+'6-tab CR_TF_FU'!F39","v":0},{"$f":"'6-tab CR_TF_PRINC'!G39+'6-tab CR_TF_FU'!G39","v":0},{"$f":"'6-tab CR_TF_PRINC'!H39+'6-tab CR_TF_FU'!H39","v":0},null,null,"Remboursement des dettes financières",0,0,0,0,null,0,0,0,0,"Augmentation des dettes financières"]
["TOTAL DES EMPLOIS (5)",{"$f":"SUM(B35:B39)","v":7103450},{"$f":"SUM(C35:C39)","v":8344355.4199999999},{"$f":"SUM(D35:D39)","v":6729956.0600000005},"TOTAL DES RESSOURCES (6)",{"$f":"SUM(F35:F39)","v":4995640},6786586.2900000196,{"$f":"SUM(H35:H39)","v":7320109.2899999954},null,null,"TOTAL DES EMPLOIS ",-373493.93999999948,-5.5497233068115964E-2,-1614399.3599999994,-0.23988260036277254,null,2324469.2899999954,0.31754570839201185,533522.99999997579,7.2884567547211593E-2,"TOTAL DES RESSOURCES "]
["APPORT au FONDS DE ROULEMENT (7) = (6)-(5)",{"$f":"IF(F40-B40>0,F40-B40,0)","v":0},{"$f":"IF(G40-C40>0,G40-C40,0)","v":0},{"$f":"IF(H40-D40>0,H40-D40,0)","v":590153.22999999486},"PRELEVEMENT sur FONDS DE ROULEMENT (8) = (5)-(6)",{"$f":"IF(B40-F40>0,B40-F40,0)","v":2107810},{"$f":"IF(C40-G40>0,C40-G40,0)","v":1557769.1299999803},{"$f":"IF(D40-H40>0,D40-H40,0)","v":0},null,null,"APPORT au FONDS DE ROULEMENT",590153.22999999486,1,590153.22999999486,1,null,-2107810,0,-1557769.1299999803,0,"PRELEVEMENT sur FONDS DE ROULEMENT "]
[]
["POUR INFORMATION DE L'ORGANE DÉLIBÉRANT"]
[null,null,null,null,null,null,null,null,null,null,null,"Evolution COFI / BI",null,"Evolution COFI / BR"]
[null,null,null,null,null,"Budget initial\n2022","Dernier Budget Modifié\n2022","Compte Financier\n2022",null,null,null,"en valeur","en %","en valeur","en %"]
["VARIATION DU FONDS DE ROULEMENT : APPORT (7) ou PRELEVEMENT (8)",null,null,null,null,{"$f":"IF(B41>0,B41,-F41)","v":-2107810},{"$f":"IF(C41>0,C41,-G41)","v":-1557769.1299999803},{"$f":"IF(D41>0,D41,-H41)","v":590153.22999999486},null,null,null,{"$f":"H46-F46","v":2697963.2299999949},{"$f":"IF(H46=0,0,(H46-F46)/H46)","v":4.5716317268991622},{"$f":"H46-G46","v":2147922.3599999752},{"$f":"IF(H46=0,0,(H46-G46)/H46)","v":3.6396011252874003},null,"VARIATION DU FONDS DE ROULEMENT : APPORT (7) ou PRELEVEMENT (8)"]
["Variation du BESOIN en FONDS DE ROULEMENT",null,null,null,null,{"$f":"'6-tab CR_TF_PRINC'!F47+'6-tab CR_TF_FU'!F47","v":-829495},{"$f":"'6-tab CR_TF_PRINC'!G47+'6-tab CR_TF_FU'!G47","v":-939306.16},{"$f":"'6-tab CR_TF_PRINC'!H47+'6-tab CR_TF_FU'!H47","v":-13518.570000005042},null,null,null,{"$f":"H47-F47","v":815976.42999999493},{"$f":"IF(H47=0,0,(H47-F47)/H47)","v":-60.359670438492429},{"$f":"H47-G47","v":925787.58999999496},{"$f":"IF(H47=0,0,(H47-G47)/H47)","v":-68.482656819445381},null,"Variation du BESOIN en FONDS DE ROULEMENT"]
["Variation de la TRESORERIE : ABONDEMENT (I) ou PRELEVEMENT (II) *",null,null,null,null,{"$f":"'6-tab CR_TF_PRINC'!F48+'6-tab CR_TF_FU'!F48+0.23","v":-1278314.77},{"$f":"'6-tab CR_TF_PRINC'!G48+'6-tab CR_TF_FU'!G48","v":-618462.97000000055},{"$f":"'6-tab CR_TF_PRINC'!H48+'6-tab CR_TF_FU'!H48","v":603671.80000000005},null,null,null,1881986.57,3.1175658197053431,1222134.7700000005,2.0245020058912813,null,"Variation de la TRESORERIE : ABONDEMENT (I) ou PRELEVEMENT (II) *"]
["Niveau du FONDS DE ROULEMENT",null,null,null,null,{"$f":"'6-tab CR_TF_PRINC'!F49+'6-tab CR_TF_FU'!F49","v":9422941.9700000007},{"$f":"'6-tab CR_TF_PRINC'!G49+'6-tab CR_TF_FU'!G49","v":12189108.680000009},{"$f":"'6-tab CR_TF_PRINC'!H49+'6-tab CR_TF_FU'!H49","v":14337031.039999995},null,null,null,4914089.0699999947,0.3427549997129668,2147922.3599999864,0.14981639880720987,null,"Niveau du FONDS DE ROULEMENT"]
["Niveau du BESOIN EN FONDS DE ROULEMENT",null,null,null,null,{"$f":"'6-tab CR_TF_PRINC'!F50+'6-tab CR_TF_FU'!F50","v":616021.83000000869},{"$f":"+G49-G51","v":-776867.54999999143},{"$f":"'6-tab CR_TF_PRINC'!H50+'6-tab CR_TF_FU'!H50","v":148920.03999999369},null,null,null,-467101.790000015,-3.1365945778690012,925787.58999998518,6.2166756737375604,null,"Niveau du BESOIN EN FONDS DE ROULEMENT"]
["Niveau de la TRESORERIE",null,null,null,null,{"$f":"'6-tab CR_TF_PRINC'!F51+'6-tab CR_TF_FU'!F51","v":8806920.1399999931},{"$f":"'6-tab CR_TF_PRINC'!G51+'6-tab CR_TF_FU'!G51","v":12965976.23},{"$f":"'6-tab CR_TF_PRINC'!H51+'6-tab CR_TF_FU'!H51","v":14188111.000000002},null,null,null,5381190.8600000087,0.37927465185464138,1222134.7700000014,8.6137948173650544E-2,null,"Niveau de la TRESORERIE"]
[]
["* : montant issu du tableau \"équilibre financier\""]

{"sheet":"6-tab CR_TF_PRINC","index":15,"n_rows":53,"n_cols":21,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7],[18,0,18,4],[35,0,37,0],[35,1,37,1],[35,2,37,2],[35,3,37,3],[3,0,3,7],[4,4,5,4],[10,0,11,0],[10,1,11,1],[10,2,11,2],[10,3,11,3],[45,9,45,11],[50,0,50,4],[44,0,44,4],[45,0,45,4],[46,0,46,4],[47,0,47,4],[48,0,48,4],[49,0,49,4],[5,11,5,14],[5,16,5,19],[6,11,6,12],[6,13,6,14],[6,16,6,17],[6,18,6,19],[31,16,31,19],[32,11,32,12],[32,13,32,14],[32,16,32,17],[32,18,32,19],[43,11,43,12],[43,13,43,14],[19,11,19,12],[19,13,19,14],[31,11,31,14]]}
["Tableau 6 - Université de Bretagne Sud (0561718N) : Etablissement principal"]
["Situation patrimoniale - Compte Financier 2022"]
[]
["POUR VOTE DE L'ORGANE DÉLIBÉRANT"]
[]
["Compte de résultat prévisionnel",null,null,null,null,null,null,null,null,null,null,"CHARGES",null,null,null,null,"PRODUITS"]
[null,null,null,null,null,null,null,null,null,null,null,"Evolution COFI / BI",null,"Evolution COFI / BR",null,null,"Evolution COFI / BI",null,"Evolution COFI / BR"]
["CHARGES","Budget initial\n2022","Dernier Budget Modifié\n2022","Compte Financier\n2022","PRODUITS","Budget initial\n2022","Dernier Budget Modifié\n2022","Compte Financier\n2022",null,null,null,"en valeur","en %","en valeur","en %",null,"en valeur","en %","en valeur","en %"]
["Personnel",75153444,74820165.530000001,{"$f":"53565896.11+19949871.05","v":73515767.159999996},"Subventions de l'Etat",70854541,70981184.689999998,71266963.219999999,null,null,"Personnel",{"$f":"D9-B9","v":-1637676.8400000036},{"$f":"IF(D9=0,0,(D9-B9)/D9)","v":-2.2276538806100702E-2},{"$f":"D9-C9","v":-1304398.3700000048},{"$f":"IF(D9=0,0,(D9-C9)/D9)","v":-1.7743110361089033E-2},null,{"$f":"H9-F9","v":412422.21999999881},{"$f":"IF(H9=0,0,(H9-F9)/H9)","v":5.7870042634882287E-3},{"$f":"H9-G9","v":285778.53000000119},{"$f":"IF(H9=0,0,(H9-G9)/H9)","v":4.0099720415728585E-3},"Subventions de l'Etat"]
["dont charges de pensions civiles*",20455893,19827314,19889158.25,"Fiscalité affectée",600000,600000,473570.35,null,null,"dont charges de pensions civiles*",{"$f":"D10-B10","v":-566734.75},{"$f":"IF(D10=0,0,(D10-B10)/D10)","v":-2.849465738450746E-2},{"$f":"D10-C10","v":61844.25},{"$f":"IF(D10=0,0,(D10-C10)/D10)","v":3.1094453180289818E-3},null,{"$f":"H10-F10","v":-126429.65000000002},{"$f":"IF(H10=0,0,(H10-F10)/H10)","v":-0.26697121135223106},{"$f":"H10-G10","v":-126429.65000000002},{"$f":"IF(H10=0,0,(H10-G10)/H10)","v":-0.26697121135223106},"Fiscalité affectée"]
["Fonctionnement (autre que les charges de personnel) et intervention",21774575,20832121.649999999,20008135.559999999,"Autres subventions",5567910,5477440.6100000003,4527564.18,null,null,"Fonctionnement",-1766439.4400000013,-8.8286059173421624E-2,-823986.08999999985,-4.1182552343722721E-2,null,-1040345.8200000003,-0.22978046884362452,-949876.43000000063,-0.20979855662697655,"Autres subventions"]
[null,null,null,null,"Autres produits",19521701,19158171.350000001,19631753.100000001,null,null,null,null,null,null,null,null,110052.10000000149,5.6058213160800948E-3,473581.75,2.412325315969871E-2,"Autres produits"]
["TOTAL DES CHARGES (1)",{"$f":"B9+B11","v":96928019},{"$f":"C9+C11","v":95652287.180000007},{"$f":"D9+D11","v":93523902.719999999},"TOTAL DES PRODUITS (2)",{"$f":"SUM(F9:F12)","v":96544152},96216796.650000006,{"$f":"SUM(H9:H12)","v":95899850.849999994},null,null,"TOTAL CHARGES",-3404116.2800000012,-3.6398355725076409E-2,-2128384.4600000083,-2.2757652301702496E-2,null,-644301.15000000596,-6.7184791664355965E-3,-316945.80000001192,-3.3049665582458197E-3,"TOTAL PRODUITS"]
["Résultat prévisionnel : bénéfice   (3) = (2) - (1)",{"$f":"IF(F13-B13>0,F13-B13,0)","v":0},{"$f":"IF(G13-C13>0,G13-C13,0)","v":564509.46999999881},{"$f":"IF(H13-D13>0,H13-D13,0)","v":2375948.1299999952},"Résultat prévisionnel : perte  (4) = (1) - (2)",{"$f":"IF(B13-F13>0,B13-F13,0)","v":383867},{"$f":"IF(C13-G13>0,C13-G13,0)","v":0},{"$f":"IF(D13-H13>0,D13-H13,0)","v":0},null,null,"Résultat",2375948.1299999952,1,1811438.6599999964,0.76240665237081584,null,-383867,0,0,0,"Résultat"]
["TOTAL EQUILIBRE du compte de résultat prévisionnel (1) + (3) = (2) + (4)",{"$f":"B13+B14","v":96928019},{"$f":"C13+C14","v":96216796.650000006},{"$f":"D13+D14","v":95899850.849999994},"TOTAL EQUILIBRE du compte de résultat prévisionnel (1) + (3)  = (2) + (4)",{"$f":"F13+F14","v":96928019},96216796.650000006,{"$f":"H13+H14","v":95899850.849999994},null,null,"TOTAL",-1028168.150000006,-1.0721269541995393E-2,-316945.80000001192,-3.3049665582458197E-3,null,-1028168.150000006,-1.0721269541995393E-2,-316945.80000001192,-3.3049665582458197E-3,"TOTAL"]
["* Il s'agit des sous catégories de comptes présentant les contributions employeur au CAS Pensions.",{"$f":"\"BI : Différence charges de personnel entre tableau 2 et tableau 6 est de : \"&'6-tab CR_TF_PRINC'!B9-ROUND('2-tab_aut_budg_PRINC'!D11+'2-tab_aut_budg_PRINC'!D24,0)","v":"BI : Différence charges de personnel entre tableau 2 et tableau 6 est de : -789810"},{"$f":"\"BR : Différence charges de personnel entre tableau 2 et tableau 6 est de : \"&'6-tab CR_TF_PRINC'!C9-ROUND('2-tab_aut_budg_PRINC'!F11+'2-tab_aut_budg_PRINC'!F24,0)","v":"BR : Différence charges de personnel entre tableau 2 et tableau 6 est de : -788702,469999999"},{"$f":"\"COFI : Différence charges de personnel entre tableau 2 et tableau 6 est de : \"&'6-tab CR_TF_PRINC'!D9-ROUND('2-tab_aut_budg_PRINC'!H11+'2-tab_aut_budg_PRINC'!H24,0)","v":"COFI : Différence charges de personnel entre tableau 2 et tableau 6 est de : -816889,840000004"}]
[null,{"$f":"IF('2-tab_aut_budg_PRINC'!H24=\"\",IF(ROUND(B10,0)<>ROUND('2-tab_aut_budg_PRINC'!D12,0),\"! Incohérence charges PC Tab2 PRINC\",\"\"),\"\")","v":""},{"$f":"IF('2-tab_aut_budg_PRINC'!H24=\"\",IF(ROUND(C10,0)<>ROUND('2-tab_aut_budg_PRINC'!F12,0),\"! Incohérence charges PC Tab2 PRINC\",\"\"),\"\")","v":""},{"$f":"IF('2-tab_aut_budg_PRINC'!H24=\"\",IF(ROUND(D10,0)<>ROUND('2-tab_aut_budg_PRINC'!H12,0),\"! Incohérence charges PCl Tab2 PRINC\",\"\"),\"\")","v":""}]
[]
["Calcul de la capacité d'autofinancement (CAF)"]
[null,null,null,null,null,null,null,null,null,null,null,"Evolution COFI / BI",null,"Evolution COFI / BR"]
[null,"Budget initial\n2022","Dernier Budget Modifié\n2022","Compte Financier\n2022",null,null,null,null,null,null,null,"en valeur","en %","en valeur","en %"]
["Résultat prévisionnel de l'exercice \n(bénéfice (3) ou perte (-4)",{"$f":"IF(B14>0,B14,-F14)","v":-383867},{"$f":"IF(C14>0,C14,-G14)","v":564509.46999999881},{"$f":"IF(D14>0,D14,-H14)","v":2375948.1299999952},null,null,null,null,null,null,null,{"$f":"D22-B22","v":2759815.1299999952},{"$f":"IF(D22=0,0,(D22-B22)/D22)","v":1.1615637122515805},{"$f":"D22-C22","v":1811438.6599999964},{"$f":"IF(D22=0,0,(D22-C22)/D22)","v":0.76240665237081584},null,"Résultat"]
["+  dotations aux amortissements, dépréciations et provisions",7628872,7061588,7251091.5499999998,null,null,null,null,null,null,null,{"$f":"D23-B23","v":-377780.45000000019},{"$f":"IF(D23=0,0,(D23-B23)/D23)","v":-5.2099804201203359E-2},{"$f":"D23-C23","v":189503.54999999981},{"$f":"IF(D23=0,0,(D23-C23)/D23)","v":2.6134485917502975E-2},null,"+  dotations aux amortissements, dépréciations et provisions"]
["-  reprises sur amortissements, dépréciations et provisions",null,0,-306028.15000000002,null,null,null,null,null,null,null,-306028.15000000002,1,-306028.15000000002,1,null,"-  reprises sur amortissements, dépréciations et provisions"]
["+ valeur nette comptable des éléments d'actifs cédés",null,0,null,null,null,null,null,null,null,null,0,0,0,0,null,"+ valeur nette comptable des éléments d'actifs cédés"]
["- produits de cession d'éléments d'actifs",null,0,-2090,null,null,null,null,null,null,null,-2090,1,-2090,1,null,"- produits de cession d'éléments d'actifs"]
["- quote-part des subventions d’investissement virée au résultat de l’exercice",-5062535,-4743688,-4752465.38,null,null,null,null,null,null,null,310069.62000000011,-6.5243951340472492E-2,-8777.3799999998882,1.8469108763923049E-3,null,"- quote-part des subventions d’investissement virée au résultat de l’exercice"]
["= CAF ou IAF*",{"$f":"SUM(B22:B27)","v":2182470},{"$f":"SUM(C22:C27)","v":2882409.4699999988},{"$f":"SUM(D22:D27)","v":4566456.1499999957},null,null,null,null,null,null,null,2383986.1499999957,0.52206482920020991,1684046.6799999969,0.36878634649760045,null,"= CAF ou IAF*"]
["* capacité d'autofinancement ou insuffisance d'autofinancement"]
[]
[]
["État prévisionnel de l'évolution de la situation patrimoniale en droits constatés",null,null,null,null,null,null,null,null,null,null,"EMPLOIS",null,null,null,null,"RESSOURCES"]
[null,null,null,null,null,null,null,null,null,null,null,"Evolution COFI / BI",null,"Evolution COFI / BR",null,null,"Evolution COFI / BI",null,"Evolution COFI / BR"]
["EMPLOIS","Budget initial\n2022","Dernier Budget Modifié\n2022","Compt2 Financier\n2020","RESSOURCES","Budget initial\n2022","Dernier Budget Modifié\n2022","Compte Financier\n2022",null,null,null,"en valeur","en %","en valeur","en %",null,"en valeur","en %","en valeur","en %"]
["Insuffisance d'autofinancement*",{"$f":"IF(B28<0,-B28,0)","v":0},{"$f":"IF(C28<0,-C28,0)","v":0},{"$f":"IF(D28<0,-D28,0)","v":0},"Capacité d'autofinancement*",{"$f":"IF(B28>0,B28,0)","v":2182470},{"$f":"IF(C28>0,C28,0)","v":2882409.4699999988},{"$f":"IF(D28>0,D28,0)","v":4566456.1499999957},null,null,"Insuffisance d'autofinancement",{"$f":"D35-B35","v":0},{"$f":"IF(D35=0,0,(D35-B35)/D35)","v":0},{"$f":"D35-C35","v":0},{"$f":"IF(D35=0,0,(D35-C35)/D35)","v":0},null,{"$f":"H35-F35","v":2383986.1499999957},{"$f":"IF(H35=0,0,(H35-F35)/H35)","v":0.52206482920020991},{"$f":"H35-G35","v":1684046.6799999969},{"$f":"IF(H35=0,0,(H35-G35)/H35)","v":0.36878634649760045},"Capacité d'autofinancement*"]
["Investissements",7058450,8342355.4199999999,6728968.4000000004,"Financement de l'actif par l'État",150000,1217182.02,1351960.02,null,null,"Investissements",{"$f":"D36-B36","v":-329481.59999999963},-4.89646525907299E-2,-1613387.0199999996,-0.23976736463794354,null,{"$f":"H36-F36","v":1201960.02},0.88904997353398074,134778,9.9690817780247673E-2,"Financement de l'actif par l'État"]
[null,null,null,null,"Financement de l'actif par des tiers autres que l'Etat",2100000,2201214.04,1727861.44,null,null,null,null,null,null,null,null,{"$f":"H37-#REF!","v":{"$error":"#REF!"}},{"$f":"IF(H37=0,0,(H37-#REF!)/H37)","v":{"$error":"#REF!"}},-473352.60000000009,-0.27395286973936989,"Financement de l'actif par des tiers autres que l'Etat"]
[null,null,null,null,"Autres ressources",312278,330878,-480912.15,null,null,null,null,null,null,null,null,{"$f":"H38-F37","v":-2580912.15},{"$f":"IF(H38=0,0,(H38-F37)/H38)","v":5.3667019017922497},-811790.15,1.688021710410103,"Autres ressources"]
["Remboursement des dettes financières",null,null,null,"Augmentation des dettes financières",null,0,null,null,null,"Remboursement des dettes financières",0,0,0,0,null,0,0,0,0,"Augmentation des dettes financières"]
["TOTAL DES EMPLOIS (5)",{"$f":"SUM(B35:B39)","v":7058450},{"$f":"SUM(C35:C39)","v":8342355.4199999999},{"$f":"SUM(D35:D39)","v":6728968.4000000004},"TOTAL DES RESSOURCES (6)",{"$f":"SUM(F35:F39)","v":4744748},6631683.5299999993,{"$f":"SUM(H35:H39)","v":7165365.4599999953},null,null,"TOTAL DES EMPLOIS ",-329481.59999999963,-4.89646525907299E-2,-1613387.0199999996,-0.23976736463794354,null,2420617.4599999953,0.33782191201731071,533681.92999999598,7.4480769052077955E-2,"TOTAL DES RESSOURCES "]
["APPORT au FONDS DE ROULEMENT (7) = (6)-(5)",{"$f":"IF(F40-B40>0,F40-B40,0)","v":0},{"$f":"IF(G40-C40>0,G40-C40,0)","v":0},{"$f":"IF(H40-D40>0,H40-D40,0)","v":436397.05999999493},"PRELEVEMENT sur FONDS DE ROULEMENT (8) = (5)-(6)",{"$f":"IF(B40-F40>0,B40-F40,0)","v":2313702},{"$f":"IF(C40-G40>0,C40-G40,0)","v":1710671.8900000006},{"$f":"IF(D40-H40>0,D40-H40,0)","v":0},null,null,"APPORT au FONDS DE ROULEMENT",436397.05999999493,1,436397.05999999493,1,null,-2313702,0,-1710671.8900000006,0,"PRELEVEMENT sur FONDS DE ROULEMENT "]
[]
["POUR INFORMATION DE L'ORGANE DÉLIBÉRANT"]
[null,null,null,null,null,null,null,null,null,null,null,"Evolution COFI / BI",null,"Evolution COFI / BR"]
[null,null,null,null,null,"Budget initial\n2022","Dernier Budget Modifié\n2022","Compte Financier\n2022",null,null,null,"en valeur","en %","en valeur","en %"]
["VARIATION DU FONDS DE ROULEMENT : APPORT (7) ou PRELEVEMENT (8)",null,null,null,null,{"$f":"IF(B41>0,B41,-F41)","v":-2313702},{"$f":"IF(C41>0,C41,-G41)","v":-1710671.8900000006},{"$f":"IF(D41>0,D41,-H41)","v":436397.05999999493},null,{"$f":"IF(H46<0,IF(ROUND(H46,0)=-ROUND('2-tab_aut_budg_PRINC'!L30,0),\"! Impossibilité Var fonds de roulement = Solde budg Tab2 PRINC\",\"\"),IF(H46>0,IF(ROUND(H46,0)=ROUND('2-tab_aut_budg_PRINC'!H30,0),\"! Impossibilité Var fonds de roulement = Solde budg Tab2 PRINC\",\"\"),\"\"))","v":""},null,null,{"$f":"IF(H46=0,0,(H46-F46)/H46)","v":6.30182765209286},{"$f":"H46-G46","v":2147068.9499999955},{"$f":"IF(H46=0,0,(H46-G46)/H46)","v":4.9199894930548353},null,"VARIATION DU FONDS DE ROULEMENT : APPORT (7) ou PRELEVEMENT (8)"]
["Variation du BESOIN en FONDS DE ROULEMENT",null,null,null,null,{"$f":"F46-F48","v":-900712},{"$f":"G46-G48","v":-1038593.04},{"$f":"H46-H48","v":-64232.400000005087},null,null,null,{"$f":"H47-F47","v":836479.59999999497},{"$f":"IF(H47=0,0,(H47-F47)/H47)","v":-13.022705052277802},{"$f":"H47-G47","v":974360.63999999501},{"$f":"IF(H47=0,0,(H47-G47)/H47)","v":-15.169301474021177},null,"Variation du BESOIN en FONDS DE ROULEMENT"]
["Variation de la TRESORERIE : ABONDEMENT (I) ou PRELEVEMENT (II) *",null,null,null,null,-1412990,-672078.85000000056,500629.46,null,null,null,1913619.46,3.8224267904649478,1172708.3100000005,2.3424676406378491,null,"Variation de la TRESORERIE : ABONDEMENT (I) ou PRELEVEMENT (II) *"]
["Niveau du FONDS DE ROULEMENT",null,null,null,null,9118931.040000001,11862976.930000009,{"$f":"13573648.82+H46","v":14010045.879999995},null,null,null,4891114.8399999943,0.34911483387661796,2147068.9499999862,0.15325209984251578,null,"Niveau du FONDS DE ROULEMENT"]
["Niveau du BESOIN EN FONDS DE ROULEMENT",null,null,null,null,{"$f":"F49-F51","v":569860.03000000864},-875363.43999999203,{"$f":"H49-H51","v":98997.199999993667},null,null,null,-470862.83000001498,-4.7563247243360935,974360.63999998569,9.8423050348903605,null,"Niveau du BESOIN EN FONDS DE ROULEMENT"]
["Niveau de la TRESORERIE",null,null,null,null,8549071.0099999923,12738340.370000001,{"$f":"13410419.22+H48","v":13911048.680000002},null,null,null,5361977.6700000092,0.38544740898714247,1172708.3100000005,8.4300496459768004E-2,null,"Niveau de la TRESORERIE"]
[]
["* : montant issu du tableau \"équilibre financier\""]

{"sheet":"6-tab CR_TF_FU","index":16,"n_rows":53,"n_cols":21,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7],[3,0,3,7],[4,4,5,4],[10,0,11,0],[10,1,11,1],[10,2,11,2],[10,3,11,3],[18,0,18,4],[35,0,37,0],[35,1,37,1],[35,2,37,2],[35,3,37,3],[50,0,50,4],[44,0,44,4],[45,0,45,4],[46,0,46,4],[47,0,47,4],[48,0,48,4],[49,0,49,4],[5,11,5,14],[5,16,5,19],[6,11,6,12],[6,13,6,14],[6,16,6,17],[6,18,6,19],[31,16,31,19],[32,11,32,12],[32,13,32,14],[32,16,32,17],[32,18,32,19],[43,11,43,12],[43,13,43,14],[19,11,19,12],[19,13,19,14],[31,11,31,14]]}
["Tableau 6 - Université de Bretagne Sud (0561718N) : Fondation"]
["Situation patrimoniale - Compte Financier 2022"]
[]
["POUR VOTE DE L'ORGANE DÉLIBÉRANT"]
[]
["Compte de résultat prévisionnel",null,null,null,null,null,null,null,null,null,null,"CHARGES",null,null,null,null,"PRODUITS"]
[null,null,null,null,null,null,null,null,null,null,null,"Evolution COFI / BI",null,"Evolution COFI / BR",null,null,"Evolution COFI / BI",null,"Evolution COFI / BR"]
["CHARGES","Budget initial\n2022","Dernier Budget Modifié\n2022","Compte Financier\n2022","PRODUITS","Budget initial\n2022","Dernier Budget Modifié\n2022","Compte Financier\n2022",null,null,null,"en valeur","en %","en valeur","en %",null,"en valeur","en %","en valeur","en %"]
["Personnel",190105,110583.24,103579.37,"Subventions de l'Etat",null,53478,48740.66,null,null,"Personnel",{"$f":"D9-B9","v":-86525.63},{"$f":"IF(D9=0,0,(D9-B9)/D9)","v":-0.83535582423411159},{"$f":"D9-C9","v":-7003.8700000000099},{"$f":"IF(D9=0,0,(D9-C9)/D9)","v":-6.7618387715623396E-2},null,{"$f":"H9-F9","v":48740.66},{"$f":"IF(H9=0,0,(H9-F9)/H9)","v":1},{"$f":"H9-G9","v":-4737.3399999999965},{"$f":"IF(H9=0,0,(H9-G9)/H9)","v":-9.7194826660123107E-2},"Subventions de l'Etat"]
["dont charges de pensions civiles*",null,0,null,"Fiscalité affectée",null,0,null,null,null,"dont charges de pensions civiles*",{"$f":"D10-B10","v":0},{"$f":"IF(D10=0,0,(D10-B10)/D10)","v":0},{"$f":"D10-C10","v":0},{"$f":"IF(D10=0,0,(D10-C10)/D10)","v":0},null,{"$f":"H10-F10","v":0},{"$f":"IF(H10=0,0,(H10-F10)/H10)","v":0},{"$f":"H10-G10","v":0},{"$f":"IF(H10=0,0,(H10-G10)/H10)","v":0},"Fiscalité affectée"]
["Fonctionnement (autre que les charges de personnel) et intervention",313184,176281,391781.56,"Autres subventions",210000,59000,59000,null,null,"Fonctionnement",78597.56,0.20061577170707065,215500.56,0.55005284066968341,null,-151000,-2.5593220338983049,0,0,"Autres subventions"]
[null,null,null,null,"Autres produits",347758,178092,387620.27,null,null,null,null,null,null,null,null,39862.270000000019,0.10283845579076661,209528.27000000002,0.5405503432521731,"Autres produits"]
["TOTAL DES CHARGES (1)",{"$f":"B9+B11","v":503289},{"$f":"C9+C11","v":286864.24},{"$f":"D9+D11","v":495360.93},"TOTAL DES PRODUITS (2)",{"$f":"SUM(F9:F12)","v":557758},290570,{"$f":"SUM(H9:H12)","v":495360.93000000005},null,null,"TOTAL CHARGES",-7928.070000000007,-1.6004633227735598E-2,208496.69,0.42089853553852141,null,-62397.069999999949,-0.12596284087241186,204790.93000000005,0.41341760643093112,"TOTAL PRODUITS"]
["Résultat prévisionnel : bénéfice   (3) = (2) - (1)",{"$f":"IF(F13-B13>0,F13-B13,0)","v":54469},{"$f":"IF(G13-C13>0,G13-C13,0)","v":3705.7600000000093},{"$f":"IF(H13-D13>0,H13-D13,0)","v":5.8207660913467407E-11},"Résultat prévisionnel : perte  (4) = (1) - (2)",{"$f":"IF(B13-F13>0,B13-F13,0)","v":0},{"$f":"IF(C13-G13>0,C13-G13,0)","v":0},{"$f":"IF(D13-H13>0,D13-H13,0)","v":0},null,null,"Résultat",-54468.999999999942,-935770294583295,-3705.7599999999511,-63664472027299,null,0,0,0,0,"Résultat"]
["TOTAL EQUILIBRE du compte de résultat prévisionnel (1) + (3) = (2) + (4)",{"$f":"B13+B14","v":557758},{"$f":"C13+C14","v":290570},{"$f":"D13+D14","v":495360.93000000005},"TOTAL EQUILIBRE du compte de résultat prévisionnel (1) + (3)  = (2) + (4)",{"$f":"F13+F14","v":557758},290570,{"$f":"H13+H14","v":495360.93000000005},null,null,"TOTAL",-62397.069999999949,-0.12596284087241186,204790.93000000005,0.41341760643093112,null,-62397.069999999949,-0.12596284087241186,204790.93000000005,0.41341760643093112,"TOTAL"]
["* Il s'agit des sous catégories de comptes présentant les contributions employeur au CAS Pensions.",{"$f":"\"BI : Différence charges de personnel entre tableau 2 et tableau 6 est de : \"&'6-tab CR_TF_FU'!B9-ROUND('2-tab_aut_budg_FU'!D11+'2-tab_aut_budg_FU'!D24,0)","v":"BI : Différence charges de personnel entre tableau 2 et tableau 6 est de : -2895"},{"$f":"\"BR : Différence charges de personnel entre tableau 2 et tableau 6 est de : \"&'6-tab CR_TF_FU'!C9-ROUND('2-tab_aut_budg_FU'!F11+'2-tab_aut_budg_FU'!F24,0)","v":"BR : Différence charges de personnel entre tableau 2 et tableau 6 est de : -2894,75999999999"},{"$f":"\"COFI : Différence charges de personnel entre tableau 2 et tableau 6 est de : \"&'6-tab CR_TF_FU'!D9-ROUND('2-tab_aut_budg_FU'!H11+'2-tab_aut_budg_FU'!H24,0)","v":"COFI : Différence charges de personnel entre tableau 2 et tableau 6 est de : -1474,63"}]
[null,{"$f":"IF('2-tab_aut_budg_FU'!H24=\"\",IF(ROUND(B10,0)<>ROUND('2-tab_aut_budg_FU'!D12,0),\"! Incohérence charges PC Tab2 FU\",\"\"),\"\")","v":""},{"$f":"IF('2-tab_aut_budg_FU'!H24=\"\",IF(ROUND(C10,0)<>ROUND('2-tab_aut_budg_FU'!F12,0),\"! Incohérence charges PC Tab2 FU\",\"\"),\"\")","v":""},{"$f":"IF('2-tab_aut_budg_FU'!H24=\"\",IF(ROUND(D10,0)<>ROUND('2-tab_aut_budg_FU'!H12,0),\"! Incohérence charges PCl Tab2 FU\",\"\"),\"\")","v":""}]
[]
["Calcul de la capacité d'autofinancement (CAF)"]
[null,null,null,null,null,null,null,null,null,null,null,"Evolution COFI / BI",null,"Evolution COFI / BR"]
[null,"Budget initial\n2022","Dernier Budget Modifié\n2022","Compte Financier\n2022",null,null,null,null,null,null,null,"en valeur","en %","en valeur","en %"]
["Résultat prévisionnel de l'exercice \n(bénéfice (3) ou perte (-4)",{"$f":"IF(B14>0,B14,-F14)","v":54469},{"$f":"IF(C14>0,C14,-G14)","v":3705.7600000000093},{"$f":"IF(D14>0,D14,-H14)","v":5.8207660913467407E-11},null,null,null,null,null,null,null,{"$f":"D22-B22","v":-54468.999999999942},{"$f":"IF(D22=0,0,(D22-B22)/D22)","v":-935770294583295},{"$f":"D22-C22","v":-3705.7599999999511},{"$f":"IF(D22=0,0,(D22-C22)/D22)","v":-63664472027299},null,"Résultat"]
["+  dotations aux amortissements, dépréciations et provisions",30289,30289,268013.86,null,null,null,null,null,null,null,{"$f":"D23-B23","v":237724.86},{"$f":"IF(D23=0,0,(D23-B23)/D23)","v":0.88698718790140185},{"$f":"D23-C23","v":237724.86},{"$f":"IF(D23=0,0,(D23-C23)/D23)","v":0.88698718790140185},null,"+  dotations aux amortissements, dépréciations et provisions"]
["-  reprises sur amortissements, dépréciations et provisions",null,0,-234741.44,null,null,null,null,null,null,null,-234741.44,1,-234741.44,1,null,"-  reprises sur amortissements, dépréciations et provisions"]
["+ valeur nette comptable des éléments d'actifs cédés",null,0,null,null,null,null,null,null,null,null,0,0,0,0,null,"+ valeur nette comptable des éléments d'actifs cédés"]
["- produits de cession d'éléments d'actifs",null,0,null,null,null,null,null,null,null,null,0,0,0,0,null,"- produits de cession d'éléments d'actifs"]
["- quote-part des subventions d’investissement virée au résultat de l’exercice",-10083,-6300,-28528.59,null,null,null,null,null,null,null,-18445.59,0.64656507734872282,-22228.59,0.77916889688554536,null,"- quote-part des subventions d’investissement virée au résultat de l’exercice"]
["= CAF ou IAF*",{"$f":"SUM(B22:B27)","v":74675},{"$f":"SUM(C22:C27)","v":27694.760000000009},{"$f":"SUM(D22:D27)","v":4743.8300000000418},null,null,null,null,null,null,null,-69931.169999999955,-14.741500011593867,-22950.929999999968,-4.8380591210055517,null,"= CAF ou IAF*"]
["* capacité d'autofinancement ou insuffisance d'autofinancement"]
[]
[]
["État prévisionnel de l'évolution de la situation patrimoniale en droits constatés",null,null,null,null,null,null,null,null,null,null,"EMPLOIS",null,null,null,null,"RESSOURCES"]
[null,null,null,null,null,null,null,null,null,null,null,"Evolution COFI / BI",null,"Evolution COFI / BR",null,null,"Evolution COFI / BI",null,"Evolution COFI / BR"]
["EMPLOIS","Budget initial\n2022","Dernier Budget Modifié\n2022","Compte Financier\n2022","RESSOURCES","Budget initial\n2022","Dernier Budget Modifié\n2022","Compte Financier\n2022",null,null,null,"en valeur","en %","en valeur","en %",null,"en valeur","en %","en valeur","en %"]
["Insuffisance d'autofinancement*",{"$f":"IF(B28<0,-B28,0)","v":0},{"$f":"IF(C28<0,-C28,0)","v":0},{"$f":"IF(D28<0,-D28,0)","v":0},"Capacité d'autofinancement*",{"$f":"IF(B28>0,B28,0)","v":74675},{"$f":"IF(C28>0,C28,0)","v":27694.760000000009},{"$f":"IF(D28>0,D28,0)","v":4743.8300000000418},null,null,"Insuffisance d'autofinancement",{"$f":"D35-B35","v":0},{"$f":"IF(D35=0,0,(D35-B35)/D35)","v":0},{"$f":"D35-C35","v":0},{"$f":"IF(D35=0,0,(D35-C35)/D35)","v":0},null,{"$f":"H35-F35","v":-69931.169999999955},{"$f":"IF(H35=0,0,(H35-F35)/H35)","v":-14.741500011593867},{"$f":"H35-G35","v":-22950.929999999968},{"$f":"IF(H35=0,0,(H35-G35)/H35)","v":-4.8380591210055517},"Capacité d'autofinancement*"]
["Investissements",45000,2000,987.66,"Financement de l'actif par l'État",null,0,null,null,null,"Investissements",{"$f":"D36-B36","v":-44012.34},-44.562238017131399,-1012.34,-1.0249883563169513,null,{"$f":"H36-F36","v":0},0,0,0,"Financement de l'actif par l'État"]
[null,null,null,null,"Financement de l'actif par des tiers autres que l'Etat",null,0,null,null,null,null,null,null,null,null,null,0,0,0,0,"Financement de l'actif par des tiers autres que l'Etat"]
[null,null,null,null,"Autres ressources",176217,127208,150000,null,null,null,null,null,null,null,null,-26217,-0.17477999999999999,22792,0.15194666666666667,"Autres ressources"]
["Remboursement des dettes financières",null,null,null,"Augmentation des dettes financières",null,0,null,null,null,"Remboursement des dettes financières",0,0,0,0,null,0,0,0,0,"Augmentation des dettes financières"]
["TOTAL DES EMPLOIS (5)",{"$f":"SUM(B35:B39)","v":45000},{"$f":"SUM(C35:C39)","v":2000},{"$f":"SUM(D35:D39)","v":987.66},"TOTAL DES RESSOURCES (6)",{"$f":"SUM(F35:F39)","v":250892},154902.76,{"$f":"SUM(H35:H39)","v":154743.83000000005},null,null,"TOTAL DES EMPLOIS ",-44012.34,-44.562238017131399,-1012.34,-1.0249883563169513,null,-96148.169999999955,-0.62133766496538134,-158.92999999996391,-1.0270522579153164E-3,"TOTAL DES RESSOURCES "]
["APPORT au FONDS DE ROULEMENT (7) = (6)-(5)",{"$f":"IF(F40-B40>0,F40-B40,0)","v":205892},{"$f":"IF(G40-C40>0,G40-C40,0)","v":152902.76},{"$f":"IF(H40-D40>0,H40-D40,0)","v":153756.17000000004},"PRELEVEMENT sur FONDS DE ROULEMENT (8) = (5)-(6)",{"$f":"IF(B40-F40>0,B40-F40,0)","v":0},{"$f":"IF(C40-G40>0,C40-G40,0)","v":0},{"$f":"IF(D40-H40>0,D40-H40,0)","v":0},null,null,"APPORT au FONDS DE ROULEMENT",-52135.829999999958,-0.33908122191128942,853.4100000000326,5.5504114078806224E-3,null,0,0,0,0,"PRELEVEMENT sur FONDS DE ROULEMENT "]
[]
["POUR INFORMATION DE L'ORGANE DÉLIBÉRANT"]
[null,null,null,null,null,null,null,null,null,null,null,"Evolution COFI / BI",null,"Evolution COFI / BR"]
[null,null,null,null,null,"Budget initial\n2022","Dernier Budget Modifié\n2022","Compte Financier\n2022",null,null,null,"en valeur","en %","en valeur","en %"]
["VARIATION DU FONDS DE ROULEMENT : APPORT (7) ou PRELEVEMENT (8)",null,null,null,null,{"$f":"IF(B41>0,B41,-F41)","v":205892},{"$f":"IF(C41>0,C41,-G41)","v":152902.76},{"$f":"IF(D41>0,D41,-H41)","v":153756.17000000004},null,{"$f":"IF(H46<0,IF(ROUND(H46,0)=-ROUND('2-tab_aut_budg_FU'!L30,0),\"! Impossibilité Var fonds de roulement = Solde budg Tab2 FU\",\"\"),IF(H46>0,IF(ROUND(H46,0)=ROUND('2-tab_aut_budg_FU'!H30,0),\"! Impossibilité Var fonds de roulement = Solde budg Tab2 FU\",\"\"),\"\"))","v":""},null,null,{"$f":"IF(H46=0,0,(H46-F46)/H46)","v":-0.33908122191128942},{"$f":"H46-G46","v":853.4100000000326},{"$f":"IF(H46=0,0,(H46-G46)/H46)","v":5.5504114078806224E-3},null,"VARIATION DU FONDS DE ROULEMENT : APPORT (7) ou PRELEVEMENT (8)"]
["Variation du BESOIN en FONDS DE ROULEMENT",null,null,null,null,{"$f":"F46-F48","v":71217},{"$f":"G46-G48","v":99286.88},50713.830000000045,null,null,null,{"$f":"H47-F47","v":-20503.169999999955},{"$f":"IF(H47=0,0,(H47-F47)/H47)","v":-0.40429149208411069},{"$f":"H47-G47","v":-48573.049999999959},{"$f":"IF(H47=0,0,(H47-G47)/H47)","v":-0.9577870572977808},null,"Variation du BESOIN en FONDS DE ROULEMENT"]
["Variation de la TRESORERIE : ABONDEMENT (I) ou PRELEVEMENT (II) *",null,null,null,null,134675,53615.880000000005,103042.34,null,null,null,-31632.660000000003,-0.30698701135863182,49426.459999999992,0.47967136615880418,null,"Variation de la TRESORERIE : ABONDEMENT (I) ou PRELEVEMENT (II) *"]
["Niveau du FONDS DE ROULEMENT",null,null,null,null,304010.93,326131.75000000006,{"$f":"173228.99+H46","v":326985.16000000003},null,null,null,22974.23000000004,7.026077269072406E-2,853.40999999997439,2.6099349585160816E-3,null,"Niveau du FONDS DE ROULEMENT"]
["Niveau du BESOIN EN FONDS DE ROULEMENT",null,null,null,null,{"$f":"F49-F51","v":46161.799999999988},{"$f":"G49-G51","v":98495.890000000072},49922.840000000026,null,null,null,3761.0400000000373,7.5337060151226085E-2,-48573.050000000047,-0.97296247569248906,null,"Niveau du BESOIN EN FONDS DE ROULEMENT"]
["Niveau de la TRESORERIE",null,null,null,null,257849.13,227635.86,{"$f":"174019.98+H48","v":277062.32},null,null,null,19213.190000000002,6.9346095131232577E-2,49426.460000000021,0.17839473805026979,null,"Niveau de la TRESORERIE"]
[]
["* : montant issu du tableau \"équilibre financier\""]

{"sheet":"7-tab Plan_tréso_ETAB","index":17,"n_rows":50,"n_cols":16,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,1,0,14],[3,1,3,14],[1,1,1,14],[49,12,49,13],[4,1,4,8],[49,14,49,15],[27,1,27,14],[7,1,7,14],[30,15,31,15]]}
[null,"Tableau 7 - Université de Bretagne Sud (0561718N) : Etablissement principal + Fondation "]
[null,"Plan de trésorerie - Compte Financier 2022"]
[]
[null,"POUR INFORMATION DE L'ORGANE DÉLIBÉRANT"]
[]
[null,"( K€ )","janvier","février","mars","avril","mai","juin","juillet","août","septembre","octobre","novembre","décembre","TOTAL Variation de la trésorerie annuelle"]
[null,"(1) SOLDE INITIAL (début de mois)",13584439.199999999,{"$f":"C49","v":25985406.27},{"$f":"D49","v":22788389.98},16807537.16,28071272.570000004,22846202.030000005,17262924.200000003,34916808.290000007,28915064.900000006,22225946.990000006,26772529.160000004,20324764.140000004]
[null,"ENCAISSEMENTS"]
[null,"Recettes budgétaires globalisées",{"$f":"SUM(C10:C14)","v":2257255.0099999998},{"$f":"SUM(D10:D14)","v":17909362.690000001},2352976.6399999997,18319388.010000002,1409772.47,1454856.6099999999,28875404.73,1099545.3399999999,1320146.58,919104.98,7966435.080000001,6742272.8599999994,90626521]
[null,"Subvention pour charges de service public",0,16544431,0,17089896,0,0,27292670,0,0,0,5795412,1290053,{"$f":"SUM(C10:N10)","v":68012462},{"$f":"IF(ROUND(O10,-1)<>ROUND('2-tab_aut_budg_ETAB'!L12,-1),\"! Incohérence subv serv publ. Tab2 ETAB\",\"\")","v":""}]
[null,"Autres financements de l'Etat",50295.64,292855.87,83153.69,36250,5682,115530.56,212225.89,33727.72,303300,0,515782.53,269127.25,{"$f":"SUM(C11:N11)","v":1917931.1500000001},{"$f":"IF(ROUND(O11,-1)<>ROUND('2-tab_aut_budg_ETAB'!L13,-1),\"! Incohérence autres financ. Etat Tab2 ETAB\",\"\")","v":""}]
[null,"Fiscalité affectée",0,0,0,0,0,0,473570.35,0,0,0,0,0,473570.35,{"$f":"IF(ROUND(O12,-1)<>ROUND('2-tab_aut_budg_ETAB'!L14,-1),\"! Incohérence fiscalité affectée Tab2 ETAB\",\"\")","v":""}]
[null,"Autres financements publics",365872.91,521076.62,626356.93999999994,128469.12,256194.66,341369.29,452913.33,534822.13,457034.93,592782.31999999995,748561.27,1811857.56,6837311.0800000001,{"$f":"IF(ROUND(O13,-1)<>ROUND('2-tab_aut_budg_ETAB'!L15,-1),\"! Incohérence autres financ. publics Tab2 ETAB\",\"\")","v":""}]
[null,"Recettes propres",1841086.46,550999.19999999995,1643466.01,1064772.8899999999,1147895.81,997956.76,444025.16,530995.49,559811.65,326322.65999999997,906679.28,3371235.05,13385246.419999998,{"$f":"IF(ROUND(O14,-1)<>ROUND('2-tab_aut_budg_ETAB'!L16,-1),\"! Incohérence recettes propres Tab2 ETAB\",\"\")","v":""}]
[null,"Recettes budgétaires fléchées",{"$f":"SUM(C16:C18)","v":0},{"$f":"SUM(D16:D18)","v":0},0,0,0,2221464,0,0,249144,-249144,0,0,{"$f":"SUM(C15:N15)","v":2221464}]
[null,"Financements de l'Etat fléchés",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(ROUND(O16,-1)<>ROUND('2-tab_aut_budg_ETAB'!L19,-1),\"! Incohérence Financ. Etat fléchés Tab2 ETAB\",\"\")","v":""}]
[null,"Autres financements publics fléchés",0,0,0,0,0,2221464,0,0,249144,-249144,0,0,2221464,{"$f":"IF(ROUND(O17,-1)<>ROUND('2-tab_aut_budg_ETAB'!L20,-1),\"! Incohérence Autres financ. fléchés Tab2 ETAB\",\"\")","v":""}]
[null,"Recettes propres fléchées",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(ROUND(O18,-1)<>ROUND('2-tab_aut_budg_ETAB'!L21,-1),\"! Incohérence recettes propres fléchées Tab2 ETAB\",\"\")","v":""}]
[null,"Opérations non budgétaires",{"$f":"SUM(C20:C22)","v":0},{"$f":"SUM(D20:D22)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Emprunts : encaissements en capital",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Prêts : encaissements en capital",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Dépôts et cautionnements",0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,"Opérations gérées en comptes de tiers :",{"$f":"SUM(C24:C26)","v":17166357.84},{"$f":"SUM(D24:D26)","v":-13530209.74},321355.07999999996,-400327.82999999996,769747.4,-1809767.4499999997,-2401237.67,425535.56,12165.809999999998,12037679.33,-5271126.1300000008,-3537074.19,3783098.0099999993]
[null,"TVA encaissée",28731.39,42141.57,29864.5,46155.46,45415.86,32970.83,21331.96,23258.57,9761.1299999999992,28360.58,28017.119999999999,101908.63,437917.6]
[null,"Dispositifs d'intervention pour compte de tiers : encaissements",0,300001.93,232629.24,0,112560,365736,0,0,315476.73,365736,331033.11,0,2023173.0099999998]
[null,"Autres encaissements d'opérations gérées en comptes de tiers",17137626.449999999,-13872353.24,58861.34,-446483.29,611771.54,-2208474.2799999998,-2422569.63,402276.99,-313072.05,11643582.75,-5630176.3600000003,-3638982.82,1322007.399999998]
[null,"A. TOTAL",{"$f":"C23+C19+C15+C9","v":19423612.850000001},{"$f":"D23+D19+D15+D9","v":4379152.9500000011},2674331.7199999997,17919060.180000003,2179519.87,1866553.1600000001,26474167.060000002,1525080.9,1581456.3900000001,12707640.310000001,2695308.95,3205198.6699999995,96631083.01000002]
[null,"DECAISSEMENTS"]
[null,"Dépenses liées à des recettes globalisées",{"$f":"SUM(C30:C33)","v":6957641.4100000001},{"$f":"SUM(D30:D33)","v":7196178.2400000002},8370071.3499999996,6626599.2999999998,7354703.8399999999,7374699.4700000007,8773368.7100000009,7496341.6200000001,7866623.3199999994,7608922.3600000003,7669494.0199999996,9243047.6300000008,{"$f":"SUM(C29:N29)","v":92537691.269999981}]
[null,"Personnel",5890239.5300000003,6040550.9900000002,6329809.8899999997,5819695.9299999997,5908624.6900000004,5759065.6100000003,7355561.9000000004,6975855.5599999996,5904660.3499999996,6242899.0800000001,6038452.5599999996,6150361.2800000003,{"$f":"SUM(C30:N30)","v":74415777.370000005},{"$f":"IF(ROUND(SUM(O30,O35),-1)<>ROUND('2-tab_aut_budg_ETAB'!H11+'2-tab_aut_budg_ETAB'!H24,-1),\"! Incohérence Personnel Tab2 ETAB\",\"\")","v":""}]
[null,"Fonctionnement",859650.95,788089.78,1409412.32,585690.09,1130652.1499999999,1204496.17,668101.92000000004,408881.2,1045799.21,826833.92000000004,864569.24,1924329.16,11716506.109999999,{"$f":"IF(ROUND(SUM(O31:O32,O36:O37),-1)<>ROUND('2-tab_aut_budg_ETAB'!H15+'2-tab_aut_budg_ETAB'!H25,-1),\"! Incohérence Fonct et Interv. Tab2 ETAB\",\"\")","v":""}]
[null,"Intervention",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Investissement",207750.93,367537.47,630849.14,221213.28,315427,411137.69,749704.89,111604.86,916163.76,539189.36,766472.22,1168357.19,6405407.790000001]
[null,"Dépenses liées à des recettes fléchées",{"$f":"SUM(C35:C38)","v":0},{"$f":"SUM(D35:D38)","v":0},0,0,0,0,1754.56,2159.54,13290.51,65478.65,39006.339999999997,80699.360000000001,202388.96000000002]
[null,"Personnel",0,0,0,0,0,0,1754.56,1295.54,2732.53,2021.85,8206.34,5922.89,21933.71,{"$f":"IF(ROUND(SUM(O30,O35),-1)<>ROUND('2-tab_aut_budg_ETAB'!H11+'2-tab_aut_budg_ETAB'!H24,-1),\"! Incohérence Personnel Tab2 ETAB\",\"\")","v":""}]
[null,"Fonctionnement",0,0,0,0,0,0,0,864,2394.38,63456.800000000003,30800,74776.47,172291.65000000002]
[null,"Intervention",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(ROUND(SUM(O31:O32,O36:O37),-1)<>ROUND('2-tab_aut_budg_ETAB'!H15+'2-tab_aut_budg_ETAB'!H25,-1),\"! Incohérence Fonct et Interv. Tab2 ETAB\",\"\")","v":""}]
[null,"Investissement",0,0,0,0,0,0,0,0,8163.6,0,0,0,8163.6,{"$f":"IF(ROUND(SUM(O33,O38),-1)<>ROUND('2-tab_aut_budg_ETAB'!H20+'2-tab_aut_budg_ETAB'!H26,-1),\"! Incohérence Invt Tab2 ETAB\",\"\")","v":""}]
[null,"Opérations non budgétaires",{"$f":"SUM(C40:C42)","v":0},{"$f":"SUM(D40:D42)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(ROUND(O39,-1)<>ROUND('4-tab_financier_ETAB'!E17,-1),\"! Incohérence Emprunts Tab4\",\"\")","v":""}]
[null,"Emprunts : remboursements en capital",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Prêts : décaissements en capital",0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Dépôts et cautionnements",0,0,0,0,0,0,0,0,0,null,0,0,0]
[null,"Opérations gérées en compte de tiers :",{"$f":"SUM(C44:C46)","v":65004.369999999995},{"$f":"SUM(D44:D46)","v":379991},285113.19,28725.470000000005,49886.57,75131.51999999999,45159.7,28323.13,390660.47000000003,486657.13,1434573.61,18104.819999999992,3287330.98,{"$f":"IF(ROUND(O43,-1)<>ROUND('4-tab_financier_ETAB'!E19+'4-tab_financier_ETAB'!E21,-1),\"! Incohérence Compte tiers Tab4\",\"\")","v":""}]
[null,"TVA décaissée",49270.07,31833.8,68220.66,31714.49,39584.92,54347.38,39147.019999999997,17356.330000000002,61852.959999999999,59776.08,71340.83,130093.99,654538.53]
[null,"Dispositifs d'intervention pour compte de tiers : décaissements",2000,328001.93,199589.24,1840,4000,3920,5440,3200,315876.73,380136,355033.11,9600,1608637.0099999998]
[null,"Autres décaissements d'opérations gérées en comptes de tiers",13734.3,20155.27,17303.29,-4829.0200000000004,6301.65,16864.14,572.67999999999995,7766.8,12930.78,46745.05,1008199.67,-121589.17,1024155.4400000001]
[null,"B. TOTAL",{"$f":"C43+C39+C34+C29","v":7022645.7800000003},{"$f":"D43+D39+D34+D29","v":7576169.2400000002},8655184.5399999991,6655324.7699999996,7404590.4100000001,7449830.9900000002,8820282.9700000007,7526824.29,8270574.2999999998,8161058.1400000006,9143073.9699999988,9341851.8100000005,96027411.209999993]
[null,"(2) SOLDE DU MOIS = A - B",{"$f":"C27-C47","v":12400967.07},{"$f":"D27-D47","v":-3197016.2899999991},-5980852.8199999994,11263735.410000004,-5225070.54,-5583277.8300000001,17653884.090000004,-6001743.3900000006,-6689117.9100000001,4546582.17,-6447765.0199999986,-6136653.1400000006,{"$f":"SUM(C48:N48)","v":603671.80000001099},{"$f":"IF(O48<0,IF(-ROUND(O48,-1)<>ROUND('4-tab_financier_ETAB'!I24,-1),\"! Incohérence variation trésorerie Tab4\",\"\"),IF(ROUND('7-tab Plan_tréso_ETAB'!O48,-1)<>ROUND('4-tab_financier_ETAB'!E24,-1),\"! Incohérence variation trésorerie Tab4\",\"\"))","v":""}]
[null,"SOLDE CUMULE (1) + (2)",{"$f":"C48+C7","v":25985406.27},{"$f":"D48+D7","v":22788389.98},16807537.16,28071272.570000004,22846202.030000005,17262924.200000003,34916808.290000007,28915064.900000006,22225946.990000006,26772529.160000004,20324764.140000004,{"$f":"N48+N7","v":14188111.000000004}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Variation de trésorerie correspondant à celle du tableau d'équilibre financier (I) ou (II)"]

{"sheet":"9-tab op_pluriannuelles_ETAB","index":18,"n_rows":60,"n_cols":18,"rows_kept":60,"cut":false,"hidden":true,"merged":[[40,1,40,4],[41,1,43,3],[44,1,44,4],[53,1,53,3],[45,1,47,3],[48,1,48,4],[54,1,54,3],[55,1,55,3],[56,1,56,4],[59,2,59,3],[49,1,51,3],[52,1,52,4],[30,1,30,4],[30,8,30,9],[34,7,34,8],[37,1,39,3],[18,1,18,4],[18,8,18,9],[19,1,21,3],[19,8,19,9],[20,8,20,9],[35,1,36,3],[35,4,36,4],[25,8,25,9],[26,8,26,9],[27,1,29,3],[27,8,27,9],[28,8,28,9],[29,8,29,9],[26,1,26,4],[21,8,21,9],[22,1,22,4],[22,8,22,9],[23,1,25,3],[23,8,23,9],[24,8,24,9],[14,1,14,4],[14,8,14,9],[15,1,17,3],[15,8,15,9],[16,8,16,9],[17,8,17,9],[0,1,0,17],[1,1,1,17],[8,16,8,17],[9,8,9,9],[11,1,13,3],[11,8,11,9],[12,8,12,9],[13,8,13,9],[8,7,8,14],[9,1,10,3],[9,4,10,4],[10,8,10,9]]}
[null,"Tableau 9 - Université de Bretagne Sud (0561718N) : Etablissement principal + Fondation + CFA"]
[null,"Tableau des opérations pluriannuelles - Compte financier 2017"]
[null,"POUR VOTE DE L'ORGANE DÉLIBÉRANT"]
[]
[null,"Suivi par opération (ou par regroupement d'opérations) des autorisations d'engagement, des crédits de paiement et des recettes"]
[]
[null,"A - Exécution des autorisations d'engagement et de crédits de paiement"]
[]
[null,null,null,null,null,"Prévision",null,"Exécution",null,null,null,null,null,null,null,null,"Prévision N+1 et suivantes"]
[null,"Opérations",null,null,"Nature","Coût total de l'opération",null,"AE\nconsommées les années antérieures\nà N","AE consommées\nen N",null,"Total des AE consommées","CP consommés\nles années\nantérieures à N","CP consommés\nen N","Total des CP consommés","Restes à payer",null,"Solde à engager","Solde à payer"]
[null,null,null,null,null,"(1)",null,"(2)","(3)",null,"(4) = (2) + (3)","(5)","(6)","(7) = (5) + (6)","(8) = (4) - (7)",null,"(9) = (1) - (4)","(10) = (1) - (7)"]
[null,"Contrats de recherche",null,null,"Personnel",{"$f":"331795.87+306635.59+2681703.12+26996.06+5813568.04","v":9160698.6799999997},null,3347130.64,2198805.0499999998,null,{"$f":"H12+I12","v":5545935.6899999995},{"$f":"H12","v":3347130.64},2198805.0499999998,{"$f":"L12+M12","v":5545935.6899999995},{"$f":"K12-N12","v":0},null,{"$f":"F12-K12","v":3614762.99},{"$f":"F12-N12","v":3614762.99}]
[null,null,null,null,"Fonctionnement",{"$f":"428.31+201701.71+1700376.26+120851.01+3224529.81","v":5247887.0999999996},null,2023357.29,1201193.18,null,{"$f":"H13+I13","v":3224550.4699999997},{"$f":"H13","v":2023357.29},1060595.19,{"$f":"L13+M13","v":3083952.48},{"$f":"K13-N13","v":140597.98999999976},null,{"$f":"F13-K13","v":2023336.63},{"$f":"F13-N13","v":2163934.6199999996}]
[null,null,null,null,"Investissement",{"$f":"3865.25+220664.32+5781.29+142555.7","v":372866.56000000006},null,230310.86,59513.32,null,{"$f":"H14+I14","v":289824.18},{"$f":"H14","v":230310.86},34743.69,{"$f":"L14+M14","v":265054.55},{"$f":"K14-N14","v":24769.630000000005},null,{"$f":"F14-K14","v":83042.380000000063},{"$f":"F14-N14","v":107812.01000000007}]
[null,"Total Contrats de recherche",null,null,null,{"$f":"SUM(F12:F14)","v":14781452.34},null,{"$f":"SUM(H12:H14)","v":5600798.79},3459511.55,null,{"$f":"SUM(K12:K14)","v":9060310.3399999999},{"$f":"SUM(L12:L14)","v":5600798.79},3294143.93,{"$f":"SUM(N12:N14)","v":8894942.7200000007},{"$f":"SUM(O12:O14)","v":165367.61999999976},null,{"$f":"SUM(Q12:Q14)","v":5721142},{"$f":"SUM(R12:R14)","v":5886509.6199999992}]
[null,"Contrats de formation continue",null,null,"Personnel",42000,null,0,6797.09,null,{"$f":"H16+I16","v":6797.09},{"$f":"H16","v":0},6797.09,{"$f":"L16+M16","v":6797.09},{"$f":"K16-N16","v":0},null,{"$f":"F16-K16","v":35202.910000000003},{"$f":"F16-N16","v":35202.910000000003}]
[null,null,null,null,"Fonctionnement",148000,null,0,40761.660000000003,null,{"$f":"H17+I17","v":40761.660000000003},{"$f":"H17","v":0},15854.02,{"$f":"L17+M17","v":15854.02},{"$f":"K17-N17","v":24907.640000000003},null,{"$f":"F17-K17","v":107238.34},{"$f":"F17-N17","v":132145.98000000001}]
[null,null,null,null,"Investissement",0,null,0,0,null,{"$f":"H18+I18","v":0},{"$f":"H18","v":0},0,{"$f":"L18+M18","v":0},{"$f":"K18-N18","v":0},null,{"$f":"F18-K18","v":0},{"$f":"F18-N18","v":0}]
[null,"Total Contrats de formation continue",null,null,null,{"$f":"SUM(F16:F18)","v":190000},null,{"$f":"SUM(H16:H18)","v":0},47558.75,null,{"$f":"SUM(K16:K18)","v":47558.75},{"$f":"SUM(L16:L18)","v":0},22651.11,{"$f":"SUM(N16:N18)","v":22651.11},{"$f":"SUM(O16:O18)","v":24907.640000000003},null,{"$f":"SUM(Q16:Q18)","v":142441.25},{"$f":"SUM(R16:R18)","v":167348.89000000001}]
[null,"Contrats d'enseignement",null,null,"Personnel",31750,null,0,3740.59,null,{"$f":"H20+I20","v":3740.59},{"$f":"H20","v":0},3740.59,{"$f":"L20+M20","v":3740.59},{"$f":"K20-N20","v":0},null,{"$f":"F20-K20","v":28009.41},{"$f":"F20-N20","v":28009.41}]
[null,null,null,null,"Fonctionnement",{"$f":"38482+605335","v":643817},null,38482,163809.54,null,{"$f":"H21+I21","v":202291.54},{"$f":"H21","v":38482},144957.46,{"$f":"L21+M21","v":183439.46},{"$f":"K21-N21","v":18852.080000000016},null,{"$f":"F21-K21","v":441525.45999999996},{"$f":"F21-N21","v":460377.54000000004}]
[null,null,null,null,"Investissement",0,null,0,0,null,{"$f":"H22+I22","v":0},{"$f":"H22","v":0},0,{"$f":"L22+M22","v":0},{"$f":"K22-N22","v":0},null,{"$f":"F22-K22","v":0},{"$f":"F22-N22","v":0}]
[null,"Total Contrats d'enseignement",null,null,null,{"$f":"SUM(F20:F22)","v":675567},null,{"$f":"SUM(H20:H22)","v":38482},167550.13,null,{"$f":"SUM(K20:K22)","v":206032.13},{"$f":"SUM(L20:L22)","v":38482},148698.04999999999,{"$f":"SUM(N20:N22)","v":187180.05},{"$f":"SUM(O20:O22)","v":18852.080000000016},null,{"$f":"SUM(Q20:Q22)","v":469534.86999999994},{"$f":"SUM(R20:R22)","v":488386.95}]
[null,"Programmes pluriannuels d'inv",null,null,"Personnel",0,null,0,0,null,{"$f":"H24+I24","v":0},{"$f":"H24","v":0},0,{"$f":"L24+M24","v":0},{"$f":"K24-N24","v":0},null,{"$f":"F24-K24","v":0},{"$f":"F24-N24","v":0}]
[null,null,null,null,"Fonctionnement",4507.5,null,0,3807.5,null,{"$f":"H25+I25","v":3807.5},{"$f":"H25","v":0},3807.5,{"$f":"L25+M25","v":3807.5},{"$f":"K25-N25","v":0},null,{"$f":"F25-K25","v":700},{"$f":"F25-N25","v":700}]
[null,null,null,null,"Investissement",{"$f":"2320329.73+10795788.31","v":13116118.040000001},null,2320329.73,1259997.44,null,{"$f":"H26+I26","v":3580327.17},2121846.44,1337570.33,{"$f":"L26+M26","v":3459416.77},{"$f":"K26-N26","v":120910.39999999991},null,{"$f":"F26-K26","v":9535790.870000001},{"$f":"F26-N26","v":9656701.2700000014}]
[null,"Total Programmes pluriannuels d'inv",null,null,null,{"$f":"SUM(F24:F26)","v":13120625.540000001},null,{"$f":"SUM(H24:H26)","v":2320329.73},1263804.94,null,{"$f":"SUM(K24:K26)","v":3584134.67},{"$f":"SUM(L24:L26)","v":2121846.44},1341377.83,{"$f":"SUM(N24:N26)","v":3463224.27},{"$f":"SUM(O24:O26)","v":120910.39999999991},null,{"$f":"SUM(Q24:Q26)","v":9536490.870000001},{"$f":"SUM(R24:R26)","v":9657401.2700000014}]
[null,null,null,null,"Ss total Personnel",{"$f":"F12+F16+F20+F24","v":9234448.6799999997},null,{"$f":"H12+H16+H20+H24","v":3347130.64},2209342.73,null,{"$f":"H28+I28","v":5556473.3700000001},{"$f":"L12+L16+L20+L24","v":3347130.64},2209342.73,{"$f":"N12+N16+N20+N24","v":5556473.3699999992},0,null,{"$f":"Q12+Q16+Q20+Q24","v":3677975.3100000005},3677975.3100000005]
[null,null,null,null,"Ss total Fonctionnement",{"$f":"F13+F17+F21+F25","v":6044211.5999999996},null,{"$f":"H13+H17+H21+H25","v":2061839.29},1409571.88,null,{"$f":"H29+I29","v":3471411.17},{"$f":"L13+L17+L21+L25","v":2061839.29},1225214.17,3287053.46,184357.70999999979,null,2572800.4299999997,2757158.1399999997]
[null,null,null,null,"Ss total Investissement",{"$f":"F14+F18+F22+F26","v":13488984.600000001},null,{"$f":"H14+H18+H22+H26","v":2550640.59},1319510.76,null,{"$f":"H30+I30","v":3870151.3499999996},{"$f":"L14+L18+L22+L26","v":2352157.2999999998},1372314.02,3724471.32,145680.02999999991,null,9618833.2500000019,9764513.2800000012]
[null,"TOTAL",null,null,null,{"$f":"SUM(F28:F30)","v":28767644.880000003},null,{"$f":"SUM(H28:H30)","v":7959610.5199999996},4938425.37,null,{"$f":"SUM(K28:K30)","v":12898035.889999999},{"$f":"SUM(L28:L30)","v":7761127.2299999995},4806870.92,{"$f":"SUM(N28:N30)","v":12567998.149999999},{"$f":"SUM(O28:O30)","v":330037.7399999997},null,{"$f":"SUM(Q28:Q30)","v":15869608.990000002},{"$f":"SUM(R28:R30)","v":16199646.73}]
[]
[]
[null,"B - Exécution des recettes"]
[null,null,null,null,null,"Prévision",null,"Financements extérieurs",null,null,"Prévisions en N+1 et suivantes"]
[null,"Opérations",null,null,"Nature","Financement de l'opération",null,"Encaissements des\nannées antérieures à\nN","Encaissements réalisés N",null,"Reste à encaisser en N+1 et suivantes"]
[null,null,null,null,null,"(11)",null,"(12)","(13)",null,"(14) = (11) - (12) - (13)"]
[null,"Contrats de recherche",null,null,"Financement de l'État",{"$f":"94050+650040.08+1381499.82","v":2125589.9},null,744090.08,555308.18000000005,null,{"$f":"F38-H38-I38","v":826191.63999999978}]
[null,null,null,null,"Autres financements publics",{"$f":"536638+7690.75+2580658.01+6679755.39","v":9804742.1499999985},null,3124986.76,1494337.89,null,{"$f":"F39-H39-I39","v":5185417.4999999991}]
[null,null,null,null,"Autres financements",{"$f":"585777.18+300546.52+235208.6+1873351.22","v":2994883.52},null,1121532.3,665960.39,null,{"$f":"F40-H40-I40","v":1207390.83}]
[null,"Total Contrats de recherche",null,null,null,{"$f":"SUM(F38:F40)","v":14925215.569999998},null,{"$f":"SUM(H38:H40)","v":4990609.1399999997},2715606.46,null,{"$f":"SUM(K38:K40)","v":7218999.9699999988}]
[null,"Contrats de formation continue",null,null,"Financement de l'État",0,null,0,0,null,{"$f":"F42-H42-I42","v":0}]
[null,null,null,null,"Autres financements publics",190000,null,0,29430.400000000001,null,{"$f":"F43-H43-I43","v":160569.60000000001}]
[null,null,null,null,"Autres financements",0,null,0,0,null,{"$f":"F44-H44-I44","v":0}]
[null,"Total Contrats de formation continue",null,null,null,{"$f":"SUM(F42:F44)","v":190000},null,{"$f":"SUM(H42:H44)","v":0},29430.400000000001,null,{"$f":"SUM(K42:K44)","v":160569.60000000001}]
[null,"Contrats d'enseignement",null,null,"Financement de l'État",0,null,0,0,null,{"$f":"F46-H46-I46","v":0}]
[null,null,null,null,"Autres financements publics",{"$f":"255076+120751-52461+299740","v":623106},null,255076,181236,null,{"$f":"F47-H47-I47","v":186794}]
[null,null,null,null,"Autres financements",{"$f":"52461","v":52461},null,0,10273.27,null,{"$f":"F48-H48-I48","v":42187.729999999996}]
[null,"Total Contrats d'enseignement",null,null,null,{"$f":"SUM(F46:F48)","v":675567},null,{"$f":"SUM(H46:H48)","v":255076},191509.27,null,{"$f":"SUM(K46:K48)","v":228981.72999999998}]
[null,"Programmes pluriannuels d'inv",null,null,"Financement de l'État",{"$f":"1927000+100000+2632500","v":4659500},null,1927000,625625.46,null,{"$f":"F50-H50-I50","v":2106874.54}]
[null,null,null,null,"Autres financements publics",{"$f":"151500+4283500","v":4435000},null,151500,208288.27,null,{"$f":"F51-H51-I51","v":4075211.73}]
[null,null,null,null,"Autres financements",0,null,0,0,null,{"$f":"F52-H52-I52","v":0}]
[null,"Total Programmes pluriannuels d'inv",null,null,null,{"$f":"SUM(F50:F52)","v":9094500},null,{"$f":"SUM(H50:H52)","v":2078500},833913.73,null,{"$f":"SUM(K50:K52)","v":6182086.2699999996}]
[null,null,null,null,"Ss total Financement de l'État",{"$f":"F38+F42+F46+F50","v":6785089.9000000004},null,{"$f":"H38+H42+H46+H50","v":2671090.08},1180933.6399999999,null,{"$f":"+K38+K42+K46+K50","v":2933066.1799999997}]
[null,null,null,null,"Ss total Autres financements publics",{"$f":"F39+F43+F47+F51","v":15052848.149999999},null,{"$f":"H39+H43+H47+H51","v":3531562.76},1913292.56,null,{"$f":"+K39+K43+K47+K51","v":9607992.8299999982}]
[null,null,null,null,"Ss total Autres financements",{"$f":"F40+F44+F48+F52","v":3047344.52},null,{"$f":"H40+H44+H48+H52","v":1121532.3},676233.66,null,{"$f":"+K40+K44+K48+K52","v":1249578.56}]
[null,"TOTAL",null,null,null,{"$f":"SUM(F54:F56)","v":24885282.569999997},null,{"$f":"SUM(H54:H56)","v":7324185.1399999997},3770459.86,null,{"$f":"SUM(K54:K56)","v":13790637.569999998}]
[]
[]
[null,"Date : ","2018-02-12"]

{"sheet":"8-tab recettes_fléchées_ETAB","index":19,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,1,0,6],[1,1,1,6],[4,1,4,6]]}
[null,"Tableau 8 - Université de Bretagne Sud (0561718N) : Etablissement principal + Fondation "]
[null,"Opérations liées aux recettes fléchées - Compte financier 2022"]
[]
[]
[null,"POUR INFORMATION DE L'ORGANE DÉLIBÉRANT"]
[]
[]
[null,null,"Antérieures à N\nnon dénouées","N","N+1","N+2","N+3"]
[null,"Position de financement des opérations fléchées en début d'exercice (a)"]
[]
[null,"Recettes fléchées (b)",{"$f":"SUM(C13:C15)","v":0},{"$f":"SUM(D13:D15)","v":2221464},0,0,0]
[]
[null,"Financements de l'État fléchés",0,0,0,0,0,{"$f":"IF(ROUND(D13,-1)<>ROUND('[10]2-tab_aut_budg_ETAB'!R19,-1),\"! Incohérence Financ. Etat fléchés avec Tab2 ETAB\",\"\")","v":""},{"$f":"IF(ROUND(D13,-1)<>ROUND('[10]3-tab_destination_origine_ETAB'!H50,-1),\"! Incohérence Financ. Etat fléchés avec Tab3 ETAB\",\"\")","v":""},{"$f":"IF(ROUND(D13,-1)<>ROUND('[10]7-tab Plan_tréso_ETAB'!O16,-1),\"! Incohérence Financ. Etat fléchés avec Tab7\",\"\")","v":""}]
[null,"Autres financements publics fléchés",0,2221464,0,0,0,{"$f":"IF(ROUND(D14,-1)<>ROUND('[10]2-tab_aut_budg_ETAB'!R20,-1),\"! Incohérence Autres financ. fléchés avec Tab2 ETAB\",\"\")","v":""},{"$f":"IF(ROUND(D14,-1)<>ROUND('[10]3-tab_destination_origine_ETAB'!I50,-1),\"! Incohérence Autres financ. fléchés avec Tab3 ETAB\",\"\")","v":""},{"$f":"IF(ROUND(D14,-1)<>ROUND('[10]7-tab Plan_tréso_ETAB'!O17,-1),\"! Incohérence Autres financ. fléchés avec Tab7\",\"\")","v":""}]
[null,"Recettes propres fléchées",0,0,0,0,0,{"$f":"IF(ROUND(D15,-1)<>ROUND('[10]2-tab_aut_budg_ETAB'!R21,-1),\"! Incohérence Recettes propres fléchées avec Tab2 ETAB\",\"\")","v":""},{"$f":"IF(ROUND(D15,-1)<>ROUND('[10]3-tab_destination_origine_ETAB'!J50,-1),\"! Incohérence Recettes propres fléchées avec Tab3 ETAB\",\"\")","v":""},{"$f":"IF(ROUND(D15,-1)<>ROUND('[10]7-tab Plan_tréso_ETAB'!O18,-1),\"! Incohérence Recettes propres fléchées avec Tab7\",\"\")","v":""}]
[]
[null,"Dépenses sur recettes fléchées (c)",{"$f":"C19+C21+C24","v":0},{"$f":"D19+D21+D24","v":202388.96},774736,1026198,1009936]
[]
[null,"Personnel",{"$f":"C20","v":0},{"$f":"D20","v":21933.71},151000,151000,151000,{"$f":"IF(ROUND(D19,-1)<>ROUND('[10]7-tab Plan_tréso_ETAB'!O35,-1),\"! Incohérence dépenses Pers fléchées avec Tab7\",\"\")","v":"! Incohérence dépenses Pers fléchées avec Tab7"}]
[null,"AE=CP",0,21933.71,151000,151000,151000]
[null,"Fonctionnement et intervention",0,{"$f":"+D23","v":172291.65},{"$f":"+E23","v":610736},862198,845936,{"$f":"IF(ROUND(D21,-1)<>ROUND(SUM('[10]7-tab Plan_tréso_ETAB'!O36:O37),-1),\"! Incohérence dépenses Fonct fléchées avec Tab7\",\"\")","v":"! Incohérence dépenses Fonct fléchées avec Tab7"}]
[null,"AE",0,780474.84,845936,862198,812336]
[null,"CP",0,172291.65,610736,862198,845936]
[null,"Investissement",{"$f":"C26","v":0},{"$f":"D26","v":8163.6},13000,13000,13000,{"$f":"IF(ROUND(D24,-1)<>ROUND(SUM('[10]7-tab Plan_tréso_ETAB'!O38),-1),\"! Incohérence dépenses Invest. fléchées avec Tab7\",\"\")","v":"! Incohérence dépenses Invest. fléchées avec Tab7"}]
[null,"AE",0,8163.6,13000,13000,13000]
[null,"CP",0,8163.6,13000,13000,13000]
[]
[null,"Solde budgétaire de l'exercice résultant des opérations fléchées (b) - (c)",{"$f":"C11-C17","v":0},{"$f":"D11-D17","v":2019075.04},{"$f":"E11-E17","v":-774736},-1026198,-1009936]
[null,null,null,"(1)"]
[null,null,null,"(1) repris au tableau \"Équilibre financier\" en (a) (tableau 4)"]
[null,null,null,{"$f":"IF(D28>=0,IF(ROUND(D28,-1)<>ROUND('[10]4-tab_financier_ETAB'!G27,-1),\"! Incohérence Tab4\",\"\"),IF(-ROUND('8-tab recettes_fléchées_ETAB'!D28,-1)<>ROUND('[10]4-tab_financier_ETAB'!M27,-1),\"! Incohérence Tab4\",\"\"))","v":"! Incohérence Tab4"}]

{"sheet":"9 tab op_pluriannuelles_ETAB","index":20,"n_rows":55,"n_cols":15,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,1,0,14],[1,1,1,14],[2,1,2,8],[8,5,8,11],[8,13,8,14],[20,1,22,1],[9,7,10,7],[9,8,10,8],[9,9,10,9],[9,10,10,10],[9,1,11,1],[9,2,11,2],[9,3,10,3],[9,5,10,5],[9,6,10,6],[9,14,10,14],[12,1,14,1],[15,1,15,2],[16,1,18,1],[19,1,19,2],[9,11,10,11],[9,13,10,13],[23,1,23,2],[24,1,26,1],[30,5,30,6],[31,1,33,1],[31,2,33,2],[31,3,32,3],[31,5,32,5],[31,6,32,6],[53,1,53,7],[54,1,54,6],[31,8,32,8],[34,1,36,1],[38,1,40,1],[42,1,44,1],[46,1,48,1],[52,1,52,8]]}
[null,"Tableau 9 - Université de Bretagne Sud (0561718N) : Etablissement principal + Fondation"]
[null,"Tableau des opérations pluriannuelles - Compte Financier 2022"]
[null,"POUR VOTE DE L'ORGANE DÉLIBÉRANT"]
[]
[null,"Suivi par opération (ou par regroupement d'opérations) des autorisations d'engagement, des crédits de paiement et des recettes"]
[]
[null,"A - Exécution des autorisations d'engagement et de crédits de paiement"]
[]
[null,null,null,"Prévision",null,"Exécution",null,null,null,null,null,null,null,"Prévision N+1 et suivantes"]
[null,"Opérations","Nature","Coût total de l'opération",null,"AE\nconsommées les années antérieures à N","AE consommées en N","Total des AE consommées","CP consommés les années antérieures à N","CP consommés en N","Total des CP consommés","Restes à payer",null,"Solde à engager","Solde à payer"]
[]
[null,null,null,"(1)",null,"(2)","(3)","(4)<=(2)+(3)","(5)","(6)","(7) = (5) + (6)","(8)= (4)-(7)",null,"(9)= (1) - (4)","(10) = (1) - (7)"]
[null,"Contrats de recherche","Personnel",18897737.219999999,null,7645535.9500000002,3950589.24,{"$f":"+F13+G13","v":11596125.190000001},7645535.9500000002,3950410.84,{"$f":"+I13+J13","v":11595946.789999999},{"$f":"+H13-K13","v":178.40000000223517},null,{"$f":"+D13-H13","v":7301612.0299999975},{"$f":"+D13-K13","v":7301790.4299999997}]
[null,null,"Fonctionnement et intervention",8408091.5899999999,null,2547087.06,1449283,{"$f":"+F14+G14","v":3996370.06},2289753.8400000003,1417073.24,{"$f":"+I14+J14","v":3706827.08},{"$f":"+H14-K14","v":289542.98},null,4411721.5299999993,4701264.51]
[null,null,"Investissement",1090721.94,null,456381.6,208887.93,{"$f":"+F15+G15","v":665269.53},445624.15,175689.69,621313.84000000008,43955.689999999944,null,425452.40999999992,469408.09999999986]
[null,"Total Contrats de recherche",null,{"$f":"+D13+D14+D15","v":28396550.75},null,{"$f":"+F13+F14+F15","v":10649004.609999999},{"$f":"+G13+G14+G15","v":5608760.1699999999},{"$f":"+F16+G16","v":16257764.779999999},{"$f":"SUM(I13:I15)","v":10380913.940000001},{"$f":"SUM(J13:J15)","v":5543173.7700000005},15924087.710000001,333677.06999999844,null,12138785.970000001,12472463.039999999]
[null,"Contrats d'enseignement","Personnel",2096832.29,null,177089.52,343802.25,{"$f":"F17+G17","v":520891.77},177089.52,343802.25,520891.77,0,null,1575940.52,1575940.52]
[null,null,"Fonctionnement et intervention",5312899.8099999996,null,373329.66,1154095.6299999999,{"$f":"F18+G18","v":1527425.2899999998},348983.17,525854.31000000006,874837.48,652587.80999999982,null,3785474.5199999996,4438062.33]
[null,null,"Investissement",181817,null,4641.0200000000004,57712.67,{"$f":"F19+G19","v":62353.69},4641.0200000000004,13751.37,18392.39,43961.3,null,119463.31,163424.60999999999]
[null,"Total Contrats d'enseignement",null,{"$f":"+D17+D18+D19","v":7591549.0999999996},null,{"$f":"+F17+F18+F19","v":555060.19999999995},{"$f":"+G17+G18+G19","v":1555610.5499999998},{"$f":"+F20+G20","v":2110670.75},{"$f":"SUM(I17:I19)","v":530713.71},{"$f":"SUM(J17:J19)","v":883407.93},1414121.6400000001,696549.10999999987,null,5480878.3499999996,6177427.459999999]
[null,"Programmes pluriannuels d'investissement","Personnel",0,null,0,0,{"$f":"F21+G21","v":0},0,0,{"$f":"I21+J21","v":0},0,null,0,0]
[null,null,"Fonctionnement et intervention",45126.31,null,5126.3100000000004,0,{"$f":"F22+G22","v":5126.3100000000004},5126.3100000000004,0,5126.3100000000004,0,null,40000,40000]
[null,null,"Investissement",13486515.289999999,null,6076320.04,2356645.4,{"$f":"F23+G23","v":8432965.4399999995},4726255.9000000004,2626572.56,7352828.4600000009,1080136.9799999986,null,5053549.8499999996,6133686.8299999982]
[null,"Total Programme pluriannuels d'inv",null,{"$f":"+D21+D22+D23","v":13531641.6},null,{"$f":"+F21+F22+F23","v":6081446.3499999996},{"$f":"+G21+G22+G23","v":2356645.4},{"$f":"+F24+G24","v":8438091.75},{"$f":"SUM(I21:I23)","v":4731382.21},{"$f":"SUM(J21:J23)","v":2626572.56},{"$f":"SUM(K21:K23)","v":7357954.7700000005},1080136.9799999995,null,5093549.8499999996,6173686.8299999991]
[null,null,"Ss total personnel",{"$f":"+D13+D17+D21","v":20994569.509999998},null,{"$f":"+F13+F17+F21","v":7822625.4699999997},{"$f":"+G13+G17+G21","v":4294391.49},{"$f":"+H13+H17+H21","v":12117016.960000001},{"$f":"+I13+I17+I21","v":7822625.4699999997},{"$f":"+J13+J17+J21","v":4294213.09},{"$f":"+K13+K17+K21","v":12116838.559999999},178.40000000223517,null,{"$f":"+N13+N17+N21","v":8877552.549999997},8877730.9499999993]
[null,null,"Ss total fonctionnement et intervention",{"$f":"+D14+D18+D22","v":13766117.709999999},null,{"$f":"+F14+F18+F22","v":2925543.0300000003},2603378.63,5528921.6599999992,2643863.3200000003,1942927.55,4586790.87,942130.7899999998,null,8237196.0499999989,9179326.8399999999]
[null,null,"Ss total investissement",14759054.229999999,null,6537342.6600000001,2623246,9160588.6600000001,5176521.07,2816013.62,7992534.6900000013,1168053.9699999986,null,5598465.5699999994,6766519.5399999982]
[null,"Total",null,{"$f":"D25+D26+D27","v":49519741.449999996},null,{"$f":"F25+F26+F27","v":17285511.16},9521016.120000001,26806527.280000001,15643009.859999999,9053154.2599999998,24696164.120000001,2110363.1600000006,null,{"$f":"N25+N26+N27","v":22713214.169999994},{"$f":"O25+O26+O27","v":24823577.329999998}]
[]
[null,"B - Exécution des recettes"]
[null,null,null,"Prévision",null,"Financements extérieurs",null,null,"Prévisions en N+1 et suivantes"]
[null,"Opérations","Nature","Financement de l'opération",null,"Encaissements des années antérieures à N","Encaissements réalisés en N",null,"Reste à encaisser en N+1 et suivantes"]
[null,null,null,null,null,null,"Montant"]
[null,null,null,"(11)",null,"(12)","(13)",null,"(14) = (11) - (12) - (13)"]
[null,"Contrats de recherche","Financement de l'Etat*",6003245.9299999997,null,1576908.25,779647.71,null,{"$f":"+D35-F35-G35","v":3646689.9699999997}]
[null,null,"Autres financements publics**",18735869.719999999,null,7023761.7999999998,3674459.13,null,{"$f":"+D36-F36-G36","v":8037648.7899999982}]
[null,null,"Autres financements***",4570478.7699999996,null,1596558.56,1203694.77,null,{"$f":"+D37-F37-G37","v":1770225.4399999995}]
[null,null,"Total Contrats de recherche",{"$f":"SUM(D35:D37)","v":29309594.419999998},null,{"$f":"+F35+F36+F37","v":10197228.610000001},{"$f":"SUM(G35:G37)","v":5657801.6099999994},null,{"$f":"+I35+I36+I37","v":13454564.199999997}]
[null,"Contrats d'enseignement","Financement de l'Etat*",1162000,null,472400,86200,null,{"$f":"+D39-F39-G39","v":603400}]
[null,null,"Autres financements publics**",6430884,null,1317668.74,2535177.9,null,{"$f":"+D40-F40-G40","v":2578037.36}]
[null,null,"Autres financements***",0,null,99,10106.02,null,{"$f":"+D41-F41-G41","v":-10205.02}]
[null,null,"Total Contrats d'enseignement",{"$f":"SUM(D39:D41)","v":7592884},null,{"$f":"+F39+F40+F41","v":1790167.74},{"$f":"SUM(G39:G41)","v":2631483.92},null,{"$f":"+I39+I40+I41","v":3171232.34}]
[null,"Programmes pluriannuels d'investissement","Financement de l'Etat*",6479288.1900000004,null,4726959.34,949841.53,null,{"$f":"+D43-F43-G43","v":802487.32000000053}]
[null,null,"Autres financements publics**",5282655.96,null,1317944.21,873763.79,null,{"$f":"+D44-F44-G44","v":3090947.96}]
[null,null,"Autres financements***",0,null,-22957.86,0,null,{"$f":"+D45-F45-G45","v":22957.86}]
[null,null,"Total Programme pluriannuels d'inv",{"$f":"SUM(D43:D45)","v":11761944.15},null,{"$f":"+F43+F44+F45","v":6021945.6899999995},{"$f":"SUM(G43:G45)","v":1823605.32},null,{"$f":"+I43+I44+I45","v":3916393.14}]
[null,null,"Ss total financement de l'Etat*",{"$f":"+D35+D39+D43","v":13644534.120000001},null,{"$f":"+F35+F39+F43","v":6776267.5899999999},{"$f":"+G35+G39+G43","v":1815689.24},null,{"$f":"+I35+I39+I43","v":5052577.29}]
[null,null,"Ss total autres financements publics**",30449409.68,null,9659374.75,7083400.8199999994,null,13706634.109999999]
[null,null,"Ss total autres financements***",4570478.7699999996,null,1573699.7,1213800.79,null,1782978.2799999996]
[null,"Total",null,{"$f":"+D47+D48+D49","v":48664422.569999993},null,{"$f":"+F47+F48+F49","v":18009342.039999999},{"$f":"+G47+G48+G49","v":10112890.849999998},null,{"$f":"+I47+I48+I49","v":20542189.68}]
[]
[]
[null,"* Subvention pour charge de service public, financements de l'Etat, fiscalité affectée, financements de l'Etat fléchés"]
[null,"** Autres financements publics et autres financements publics fléchés"]
[null,"*** Recettes propres et recettes propres fléchées"]

{"sheet":"Annexe Synthèse_ETAB","index":21,"n_rows":61,"n_cols":15,"rows_kept":61,"cut":false,"hidden":false,"merged":[[51,1,57,1],[51,3,51,4],[53,3,53,4],[60,3,60,4],[54,5,54,6],[55,3,55,4],[55,5,55,6],[56,5,56,6],[57,5,57,6],[59,3,59,4],[25,3,25,4],[53,5,53,6],[54,3,54,4],[31,3,31,4],[37,3,37,4],[37,5,37,6],[38,5,38,6],[39,5,39,6],[41,3,41,4],[43,3,43,4],[44,5,44,6],[45,5,45,6],[47,3,47,4],[49,3,49,4],[14,3,14,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[20,3,20,4],[0,1,0,9],[1,1,1,9],[38,11,39,11],[44,11,45,11],[6,1,12,1],[6,3,6,4],[6,5,6,6],[8,3,8,4],[8,5,8,6],[9,3,9,4],[9,5,9,6],[10,3,10,4],[10,5,10,6],[11,5,11,6],[12,5,12,6],[14,1,49,1]]}
[null,"ANNEXE 5 - Université de Bretagne Sud (0561718N) : Etablissement principal + Fondation"]
[null,"Synthèse budgétaire et comptable - Compte Financier 2022"]
[]
[null,"POUR INFORMATION DE L'ORGANE DÉLIBÉRANT"]
[]
[null,null,null,null,null,null,null,"Budget initial","Dernier Budget Modifié","Compte Financier"]
[null,"Stocks initiaux",null,1,null,"Niveau initial de restes à payer",null,3459160.49,5092135.3600000003,4846892.9300000006,"à saisir"]
[]
[null,null,null,2,null,"Niveau initial du fonds de roulement",null,11530751.970000001,13746877.81000001,13746877.81000001,"à saisir",{"$f":"IF(ROUND(I9,-1)<>ROUND('[26]6-tab CR_TF_ETAB'!F49,-1),\"! Pb incohérence besoin fonds de roulement BI Tab6 ETAB\",\"\")","v":"! Pb incohérence besoin fonds de roulement BI Tab6 ETAB"},{"$f":"IF(ROUND(I9,-1)<>ROUND('[26]6-tab CR_TF_ETAB'!G49,-1),\"! Pb incohérence besoin fonds de roulement BI Tab6 ETAB\",\"\")","v":"! Pb incohérence besoin fonds de roulement BI Tab6 ETAB"},{"$f":"IF(ROUND(I9,-1)<>ROUND('[26]6-tab CR_TF_ETAB'!H49,-1),\"! Pb incohérence besoin fonds de roulement BI Tab6 ETAB\",\"\")","v":"! Pb incohérence besoin fonds de roulement BI Tab6 ETAB"}]
[null,null,null,3,null,"Niveau initial du besoin en fonds de roulement",null,{"$f":"H9-H11","v":1445516.8300000075},162438.61000000872,{"$f":"J9-J11","v":162438.61000000872},null,{"$f":"IF(ROUND(I10,-1)<>ROUND('[26]6-tab CR_TF_ETAB'!F50,-1),\"! Pb incohérence besoin fonds de roulement BI Tab6 ETAB\",\"\")","v":"! Pb incohérence besoin fonds de roulement BI Tab6 ETAB"},{"$f":"IF(ROUND(I10,-1)<>ROUND('[26]6-tab CR_TF_ETAB'!G50,-1),\"! Pb incohérence besoin fonds de roulement BI Tab6 ETAB\",\"\")","v":"! Pb incohérence besoin fonds de roulement BI Tab6 ETAB"},{"$f":"IF(ROUND(I10,-1)<>ROUND('[26]6-tab CR_TF_ETAB'!H50,-1),\"! Pb incohérence besoin fonds de roulement BI Tab6 ETAB\",\"\")","v":"! Pb incohérence besoin fonds de roulement BI Tab6 ETAB"}]
[null,null,null,4,null,"Niveau initial de la trésorerie",null,10085235.139999993,13584439.200000001,13584439.200000001,"à saisir",{"$f":"IF(ROUND(I11,-1)<>ROUND('[26]6-tab CR_TF_ETAB'!F51,-1),\"! Pb incohérence besoin fonds de roulement BI Tab6 ETAB\",\"\")","v":"! Pb incohérence besoin fonds de roulement BI Tab6 ETAB"},{"$f":"IF(ROUND(I11,-1)<>ROUND('[26]6-tab CR_TF_ETAB'!G51,-1),\"! Pb incohérence besoin fonds de roulement BI Tab6 ETAB\",\"\")","v":"! Pb incohérence besoin fonds de roulement BI Tab6 ETAB"},{"$f":"IF(ROUND(I11,-1)<>ROUND('[26]6-tab CR_TF_ETAB'!H51,-1),\"! Pb incohérence besoin fonds de roulement BI Tab6 ETAB\",\"\")","v":"! Pb incohérence besoin fonds de roulement BI Tab6 ETAB"}]
[null,null,null,null,"4.a","dont niveau initial de la trésorerie fléchée",null,0,0,0,"à saisir"]
[null,null,null,null,"4.b","dont niveau initial de la trésorerie non fléchée",null,{"$f":"H11-H12","v":10085235.139999993},13584439.200000001,{"$f":"+J11-J12","v":13584439.200000001}]
[]
[null,"Flux de l'année",null,5,null,"Autorisations d'engagement",null,{"$f":"'2-tab_aut_budg_ETAB'!C28","v":97587640.5},{"$f":"'2-tab_aut_budg_ETAB'!E28","v":98051478.859999999},{"$f":"'2-tab_aut_budg_ETAB'!G28","v":93880444.49000001}]
[]
[null,null,null,6,null,"Résultat patrimonial",null,{"$f":"IF('6-tab CR_TF_ETAB'!B14>0,'6-tab CR_TF_ETAB'!B14,-'6-tab CR_TF_ETAB'!F14)","v":-329398},{"$f":"IF('6-tab CR_TF_ETAB'!C14>0,'6-tab CR_TF_ETAB'!C14,-'6-tab CR_TF_ETAB'!G14)","v":568215.23000001907},{"$f":"IF('6-tab CR_TF_ETAB'!D14>0,'6-tab CR_TF_ETAB'!D14,-'6-tab CR_TF_ETAB'!H14)","v":2375948.1299999952}]
[null,null,null,7,null,"Capacité d'autofinancement (CAF)",null,{"$f":"'6-tab CR_TF_ETAB'!B28","v":2257145},{"$f":"'6-tab CR_TF_ETAB'!C28","v":2910104.2300000191},{"$f":"'6-tab CR_TF_ETAB'!D28","v":4571199.9799999958}]
[null,null,null,8,null,"Variation du fonds de roulement",null,{"$f":"'6-tab CR_TF_ETAB'!F46","v":-2107810},{"$f":"'6-tab CR_TF_ETAB'!G46","v":-1557769.1299999803},{"$f":"'6-tab CR_TF_ETAB'!H46","v":590153.22999999486}]
[]
[null,null,null,9,"9.a","Opérations bilancielles non budgétaires","SENS",{"$f":"SUM(H22:H24)","v":0},0,0,null,{"$f":"IF(ROUND(H21,-1)=ROUND('4-tab_financier_ETAB'!G17-'4-tab_financier_ETAB'!C17,-1),\"\",\"! Pb incohérence opérations non budgétaires Tab4\")","v":""},{"$f":"IF(ROUND(I21,-1)=ROUND('4-tab_financier_ETAB'!H17-'4-tab_financier_ETAB'!D17,-1),\"\",\"! Pb incohérence opérations non budgétaires Tab4\")","v":""},{"$f":"IF(ROUND(J21,-1)=ROUND('4-tab_financier_ETAB'!I17-'4-tab_financier_ETAB'!E17,-1),\"\",\"! Pb incohérence opérations non budgétaires Tab4\")","v":""},{"$f":"IF(ROUND(J21,-1)=ROUND('7-tab Plan_tréso_ETAB'!O19-'7-tab Plan_tréso_ETAB'!O39,-1),\"\",\"! Pb incohérence opérations non budgétaires Tab7\")","v":""}]
[null,null,null,null,null,"Nouvel emprunt / remboursement de prêt","+ / -",null,null,null,"à saisir"]
[null,null,null,null,null,"Remboursement d'emprunt / prêt accordé","+",null,null,null,"à saisir"]
[null,null,null,null,null,"Cautionnements et dépôts","-",null,null,{"$f":"'7-tab Plan_tréso_ETAB'!O22-'7-tab Plan_tréso_ETAB'!O42","v":0},"à saisir"]
[]
[null,null,null,10,"9.a","Opérations comptables non retraitées par la CAF, non budgétaires","SENS",{"$f":"SUM(H27:H30)","v":0},{"$f":"SUM(I27:I30)","v":0},-149542.38]
[null,null,null,null,null,"Variation des stocks","+ / -",null,null,null,"à saisir"]
[null,null,null,null,null,"Production immobilisée","+",null,null,null,"à saisir"]
[null,null,null,null,null,"Charges sur créances irrécouvrables","-",null,null,-306435.62,"à saisir"]
[null,null,null,null,null,"Produits divers de gestion courante","+",null,null,156893.24,"à saisir"]
[]
[null,null,null,11,"9.b","Décalages de flux de trésorerie liés aux opérations budgétaires","SENS",{"$f":"H34-H36","v":-368589.82999999996},{"$f":"I34-I36","v":-769953.99},{"$f":"SUM(J33:J36)","v":631790.84}]
[null,null,null,null,null,"Ecart entre les produits / ressources et les encaissements relatifs à des opérations sur exercices antérieurs","+ / -",null,null,-3859970.71,"à saisir"]
[null,null,null,null,null,"Ecart entre les produits / ressources et les encaissements relatifs à des opérations de l'exercice en cours","+ / -",-593582.73,-1213223.98,{"$f":"4658859.93+16500.07","v":4675360},"à saisir"]
[null,null,null,null,null,"Ecart entre les charges / immobilisations et les décaissements relatifs à des opérations sur exercices antérieurs","+ / -",null,null,-64799.06,"à saisir"]
[null,null,null,null,null,"Ecart entre les charges / immobilisations et les décaissements relatifs à des opérations de l'exercice en cours","+ / -",-224992.9,-443269.99,-118799.39,"à saisir"]
[]
[null,null,null,12,null,"Solde budgétaire = 8 - 9 - 10 - 11",null,{"$f":"H19-H26-H32-H21","v":-1739220.17},{"$f":"I19-I26-I32-I21","v":-787815.13999998034},{"$f":"J19-J26-J32-J21","v":107904.7699999949},null,{"$f":"IF(ROUND(H38,-1)<>ROUND(IF(H38>0,'2-tab_aut_budg_ETAB'!D30,-'2-tab_aut_budg_ETAB'!J30),-1),\"!Pb Incohérence solde budgétaire Tab2\",\"\")&\"\n\"&IF(ROUND(H38,-1)<>ROUND(IF(H38>0,'4-tab_financier_ETAB'!G11,-'4-tab_financier_ETAB'!C11),-1),\"!Pb Incohérence solde budgétaire Tab4\",\"\")","v":"\n"},null,{"$f":"IF(ROUND(J38,-1)<>ROUND(IF(J38>0,'2-tab_aut_budg_ETAB'!H30,-'2-tab_aut_budg_ETAB'!L30),-1),\"!Pb Incohérence solde budgétaire Tab2\",\"\")&\"\n\"&IF(ROUND(J38,-1)<>ROUND(IF(J38>0,'4-tab_financier_ETAB'!I11,-'4-tab_financier_ETAB'!E11),-1),\"!Pb Incohérence solde budgétaire Tab4\",\"\")","v":"\n"},{"$f":"IF(ROUND(J38,-1)<>ROUND(IF(J38>0,'3-tab_destination_origine_ETAB'!J30,-'3-tab_destination_origine_ETAB'!K52),-1),\"!Pb Incohérence solde budgétaire Tab3\",\"\")","v":""}]
[null,null,null,null,"12.a","Recettes budgétaires",null,{"$f":"'2-tab_aut_budg_ETAB'!J28","v":95361369.729999989},{"$f":"'2-tab_aut_budg_ETAB'!K28","v":96847084.689999998},{"$f":"'2-tab_aut_budg_ETAB'!L28","v":92847985},null,{"$f":"IF(ROUND(H39-H40,-1)<>ROUND(H38,-1),\"! Pb Recettes - CP <> Solde budgétaire\",\"\")","v":""}]
[null,null,null,null,"12.b","Crédits de paiement ouverts",null,{"$f":"'2-tab_aut_budg_ETAB'!D28","v":97100589.900000006},{"$f":"'2-tab_aut_budg_ETAB'!F28","v":97634899.829999998},{"$f":"'2-tab_aut_budg_ETAB'!H28","v":92740080.230000019}]
[]
[null,null,null,13,"9.c","Décalage du flux de trésorerie liés aux opérations de trésorerie non budgétaire",null,{"$f":"'4-tab_financier_ETAB'!G19-'4-tab_financier_ETAB'!C19+'4-tab_financier_ETAB'!G21-'4-tab_financier_ETAB'!C21","v":460905.40008787951},{"$f":"'4-tab_financier_ETAB'!H19-'4-tab_financier_ETAB'!D19+'4-tab_financier_ETAB'!H21-'4-tab_financier_ETAB'!D21","v":169352},{"$f":"'4-tab_financier_ETAB'!I19-'4-tab_financier_ETAB'!E19+'4-tab_financier_ETAB'!I21-'4-tab_financier_ETAB'!E21","v":495767.02999999828},null,{"$f":"IF(ROUND(H42,-1)<>ROUND('5-tab compte de tiers_ETAB'!F15-'5-tab compte de tiers_ETAB'!E15,-1),\"! Pb incohérence avec Tab5\",\"\")","v":""}]
[]
[null,null,null,14,null,"Variation de la trésorerie = 12 +13 ",null,{"$f":"H38+H42","v":-1278314.7699121204},{"$f":"I38+I42+0.29","v":-618462.8499999803},{"$f":"J38+J42+J21","v":603671.79999999318},null,{"$f":"IF(ROUND(H44,-1)<>ROUND(IF(H44>0,'4-tab_financier_ETAB'!C24,-'4-tab_financier_ETAB'!G24),-1),\"! Incohérence Var trésorerie Tab4\",\"\")&\"\n\"&IF(ROUND(H44,-1)<>ROUND('6-tab CR_TF_ETAB'!F48,-1),\"! Incohérence Var trésorerie Tab6\",\"\")","v":"\n"},{"$f":"IF(ROUND(I44,-1)<>ROUND(IF(I44>0,'4-tab_financier_ETAB'!D24,-'4-tab_financier_ETAB'!H24),-1),\"! Incohérence Var trésorerie Tab4\",\"\")&\"\n\"&IF(ROUND(I44,-1)<>ROUND('6-tab CR_TF_ETAB'!G48,-1),\"! Incohérence Var trésorerie Tab6\",\"\")","v":"\n"},{"$f":"IF(ROUND(J44,-1)<>ROUND(IF(J44>0,'4-tab_financier_ETAB'!E24,-'4-tab_financier_ETAB'!I24),-1),\"! Incohérence Var trésorerie Tab4\",\"\")&\"\n\"&IF(ROUND(J44,-1)<>ROUND('6-tab CR_TF_ETAB'!H48,-1),\"! Incohérence Var trésorerie Tab6\",\"\")","v":"\n"},{"$f":"IF(ROUND(J44,-1)<>ROUND('7-tab Plan_tréso_ETAB'!O48,-1),\"! Incohérence Var trésorerie Tab7\",\"\")","v":""}]
[null,null,null,null,"14.a","dont variation de la trésorerie fléchée",null,{"$f":"'4-tab_financier_ETAB'!C26-'4-tab_financier_ETAB'!G26","v":0},{"$f":"'4-tab_financier_ETAB'!D26-'4-tab_financier_ETAB'!H26","v":1929527},{"$f":"'4-tab_financier_ETAB'!E26-'4-tab_financier_ETAB'!I26","v":2019075.04}]
[null,null,null,null,"14.b","dont variation de la trésorerie non fléchée",null,{"$f":"'4-tab_financier_ETAB'!C28-'4-tab_financier_ETAB'!G28","v":-1278314.7699121376},{"$f":"'4-tab_financier_ETAB'!D28-'4-tab_financier_ETAB'!H28","v":-2547990.1400000174},{"$f":"-('4-tab_financier_ETAB'!I28)","v":-1415403.2400000207}]
[]
[null,null,null,15,null,"Variation du besoin en fonds de roulement = 9 + 10 + 11 + 13 ",null,{"$f":"H26+H32-H42+H21","v":-829495.23008787946},{"$f":"I26+I32-I42+I21","v":-939305.99},{"$f":"J26+J32-J42","v":-13518.569999998319},"o",{"$f":"IF(ABS(ROUND(H48,-1))<>ABS(ROUND('6-tab CR_TF_ETAB'!F48-'6-tab CR_TF_ETAB'!F46,-1)),\"! Incohérence var FDR du Tab6 ETAB\",\"\")","v":""},{"$f":"IF(ABS(ROUND(I48,-1))<>ABS(ROUND('6-tab CR_TF_ETAB'!G48-'6-tab CR_TF_ETAB'!G46,-1)),\"! Incohérence var FDR du Tab6 ETAB\",\"\")","v":""},{"$f":"IF(ABS(ROUND(J48,-1))<>ABS(ROUND('6-tab CR_TF_ETAB'!H48-'6-tab CR_TF_ETAB'!H46,-1)),\"! Incohérence var FDR du Tab6 ETAB\",\"\")","v":""}]
[]
[null,null,null,16,null,"Restes à payer",null,{"$f":"H15-H40","v":487050.59999999404},{"$f":"I15-I40","v":416579.03000000119},{"$f":"J15-J40","v":1140364.2599999905}]
[]
[null,"Stocks finaux",null,17,null,"Niveau final de restes à payer",null,{"$f":"H7+H50","v":3946211.0899999943},{"$f":"I7+I50","v":5508714.3900000015},5987257.1899999911]
[]
[null,null,null,18,null,"Niveau final du fonds de roulement",null,{"$f":"H9+H19","v":9422941.9700000007},{"$f":"I9+I19","v":12189108.68000003},{"$f":"J9+J19","v":14337031.040000005},null,null,{"$f":"IF(ROUND(I54,-1)<>ROUND('6-tab CR_TF_ETAB'!G49,-1),\"! Pb incohérence avec niveau final FDR Tab6 ETAB\",\"\")","v":""},{"$f":"IF(ROUND(J54,-1)<>ROUND('6-tab CR_TF_ETAB'!H49,-1),\"! Pb incohérence avec niveau final FDR Tab6 ETAB\",\"\")","v":""}]
[null,null,null,19,null,"Niveau final du besoin en fonds de roulement",null,{"$f":"H54-H56","v":616021.59991212748},{"$f":"I54-I56","v":-776867.66999999061},{"$f":"J54-J56","v":148920.04000001028},null,null,{"$f":"IF(ROUND(I55,-1)<>ROUND('6-tab CR_TF_ETAB'!G50,-1),\"! Pb incohérence avec niveau final BFDR Tab6 ETAB\",\"\")","v":""},{"$f":"IF(ROUND(J55,-1)<>ROUND('6-tab CR_TF_ETAB'!H50,-1),\"! Pb incohérence avec niveau final BFDR Tab6 ETAB\",\"\")","v":""}]
[null,null,null,20,null,"Niveau final de la trésorerie",null,{"$f":"H11+H44","v":8806920.3700878732},{"$f":"I11+I44","v":12965976.35000002},14188110.999999994,null,null,null,{"$f":"IF(ROUND(J55,-1)<>ROUND('6-tab CR_TF_ETAB'!H50,-1),\"! Pb incohérence avec niveau final BFDR Tab6 ETAB\",\"\")","v":""}]
[null,null,null,null,"20.a","dont niveau final de la trésorerie fléchée",null,{"$f":"H12+H45","v":0},{"$f":"I12+I45","v":1929527},2019075.04]
[null,null,null,null,"20.b","dont niveau final de la trésorerie non fléchée",null,{"$f":"H13+H46","v":8806920.3700878546},{"$f":"I13+I46","v":11036449.059999984},{"$f":"J56-J57","v":12169035.959999993}]
[]
[null,null,null,null,null,"Comptabilité budgétaire"]
[null,null,null,null,null,"Comptabilité générale"]