{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Scénario 0","Conseils"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Scénario 0","index":0,"n_rows":500,"n_cols":23,"rows_kept":500,"cut":false,"hidden":false,"merged":[[3,5,3,17]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Redémarrer","Retour","Suivant","Commencer/\nContinuer","Arrêter/\nMettre en pause"]
[null,"Modèle de simulation financière de l’éducation – SAO TOMÉ-ET-PRINCIPE 2016-2030"]
[]
[null,"N.B. : Tous les montants sont indiqués en nouveaux dobras.","Hypothèses","Année de référence","Années de projection ou de référence (si disponibles)","Années de projection"]
[null,"Année",2030,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"Ano escolar equivalente",null,"2015-16","2016-17","2017-18","2018-19","2019-2020","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26","2026-27","2027-28","2028-29","20129-30"]
[]
[null,"Ressources publiques consacrées à l’éducation"]
[null,"PIB (en millions de dobras)",null,7592.2244332919709,{"$f":"D9*(1+$C$10)","v":8009.7967771230287},{"$f":"E9*(1+$C$10)","v":8450.3355998647949},8915.1040578573575,9405.434781039512,9922.7336939966845,10468.484047166501,11044.250669760659,11651.684456597493,12292.527101710355,12968.616092304424,13681.889977381166,14434.393926137129,15228.28559207467,16065.841299638776]
[null,"Taux de croissance du PIB réel (%)",5.5E-2]
[null,"Population totale",null,193706,197698,201783,205965,210238,214617,219075,223650,228320,233094,237960,242919,247953,253046,258184]
[null,"Taux de change (euros/dobras)",24.5]
[null,"Taux de change (dollars É.-U./dobras)",22.175508571428573]
[null,"PIB par habitant"]
[null,"En dobras",null,{"$f":"D9*10^9/D11/1000","v":39194.575456062128},{"$f":"E9*10^9/E11/1000","v":40515.315163142921},41878.332663627734,43284.558336889073,44737.082644619484,46234.6118620458,47784.932316177117,49381.849630049888,51032.254978089935,52736.351436374833,54499.143100959926,56322.848263747037,58214.233851323152,{"$f":"Q9*10^9/Q11/1000","v":60179.910340707494},{"$f":"R9*10^9/R11/1000","v":62226.32424797344}]
[null,"En euros",null,{"$f":"D15/$C$12","v":1599.7785900433521},{"$f":"E15/$C$12","v":1653.686333189507},1709.319700556234,1766.7166668117989,1826.0033732497748,1887.1270147773796,1950.4054006602905,2015.5856991857097,2082.9491827791812,2152.5041402601973,2224.454820447344,2298.8917658672258,2376.0911776050266,2456.3228710492854,2539.8499693050385]
[null,"En dollars É.-U.",null,{"$f":"D15/$C$13","v":1767.4713222388643},{"$f":"E15/$C$13","v":1827.0298078008352},1888.4948017645343,1951.9082593964893,2017.4095444313623,2084.9403166164821,2154.8516987675453,2226.8643567288727,2301.2890465944511,2378.1349260382485,2457.6276537430963,2539.8672631262521,2625.158907350954,2713.8006845193463,2806.0832989484284]
[null,"Ressources nationales du pays"]
[null,"En millions de dobras",null,1129.7318668130699,{"$f":"E9*E20","v":1209.7168552302426},{"$f":"F9*F20","v":1295.082753476195},1386.1795070421304,1483.3792781710533,1587.0778311153554,1697.696002567063,1815.6812624393347,1941.5093704897909,2075.6861346069181,2218.749276931198,2371.2704143539627,2533.857160330514,2707.1553553610661,2891.8514339349795]
[null,"En pourcentage du PIB, taux d’utilisation des ressources économiques nationales",0.18,{"$f":"D19/D9","v":0.14880116845060398},{"$f":"IF(E$5<$C21, D20+($C20-$D20)/($C21-$D$5),$C20)","v":0.15102965641841798},{"$f":"IF(F$5<$C21, E20+($C20-$D20)/($C21-$D$5),$C20)","v":0.15325814438623198},0.15548663235404597,0.15771512032185997,0.15994360828967397,0.16217209625748796,0.16440058422530196,0.16662907219311596,0.16885756016092995,0.17108604812874395,0.17331453609655795,0.17554302406437194,0.17777151203218594,0.18]
[null,"Hypothèses annuelles",2030]
[null,"Ressources externes"]
[null,"En millions de dobras",null,1038.0478027663401,{"$f":"E24*E9","v":1051.2438158262669},1062.7512957194174,1072.34458585794,1079.7783152421489,1084.7859124864005,1087.0780160239124,1086.3407735652791,1082.2340234377236,1074.3893499561025,1062.4080044706038,1045.8586831980829,1024.2751523720613,997.15371063850296,963.95047797832774]
[null,"En pourcentage du PIB",0.06,{"$f":"D23/D9","v":0.13672512079786411},{"$f":"D24+($C24-$D24)/($C$5-$D$5)","v":0.13124475502658811},{"$f":"E24+($C24-$D24)/($C$5-$D$5)","v":0.12576438925531211},0.12028402348403611,0.1148036577127601,0.1093232919414841,0.1038429261702081,9.8362560398932097E-2,9.2882194627656095E-2,8.7401828856380093E-2,8.192146308510409E-2,7.6441097313828088E-2,7.0960731542552086E-2,6.5480365771276083E-2,6.0000000000000074E-2]
[null,"En pourcentage des recettes internes",null,{"$f":"D23/D19","v":0.91884440304816128},0.86899989140532075,0.82060493267077694,0.77359720036991442,0.72791789067828416,0.68351147701687842,0.64032548488077756,0.59831028498129679,0.55741890298716656,0.51760684433129112,0.47883193270942459,0.44105416103840706,0.40423555376675446,0.36834003954143513,0.33333333333333376]
[null,"En pourcentage des recettes totales",null,{"$f":"D23/D28","v":0.47885300214469712},{"$f":"E23/E28","v":0.4649544900464978},0.45073201656494044,0.43617412127656008,0.42126879674389167,0.40600345548462552,0.39036489451806439,0.37433925727900708,0.35791199266814078,0.34106781098458089,0.32379063646004608,0.30606355608493474,0.28786876438388381,0.26918750376176603,0.25000000000000022]
[null,"Total des ressources en pourcentage du PIB",null,{"$f":"D24+D20","v":0.28552628924846812},{"$f":"E24+E20","v":0.28227441144500609},0.27902253364154406,0.27577065583808208,0.2725187780346201,0.26926690023115807,0.26601502242769604,0.26276314462423406,0.25951126682077208,0.25625938901731005,0.25300751121384801,0.24975563341038604,0.24650375560692403,0.24325187780346202,0.24000000000000007]
[null,"Total des recettes de l’État (en millions de dobras)",null,{"$f":"D19+D23","v":2167.77966957941},2260.9606710565095,2357.8340491956124,2458.5240929000702,2563.1575934132024,2671.8637436017561,2784.7740185909752,2902.0220360046137,3023.7433939275143,3150.0754845630208,3281.1572814018018,3417.1290975520456,3558.1323127025753,3704.3090659995692,3855.8019119133073]
[null,"Total des dépenses publiques"]
[null,"En millions de dobras",null,2515.6268072498101,{"$f":"E28+(E37*E9)","v":2566.7762795917361},2615.9424227993436,2662.7523435140224,2706.7981296783491,2747.634126481621,2784.7740185909752,2902.0220360046137,3023.7433939275143,3150.0754845630208,3281.1572814018018,3417.1290975520456,3558.1323127025753,3704.3090659995692,3855.8019119133073]
[null,"    (dont intérêts de la dette)",null,56.473999999999997,{"$f":"E32*E9","v":58.184992420401066},{"$f":"F32*F9","v":59.913360157046263},61.655838742650708,63.40875205819659,65.167976926255989,66.92890505482589,68.686402147336551,70.434763982232525,72.167669252471384,73.878128941390258,75.55843199660147,77.20008704783821,78.793759897921277,80.329206498193784]
[null,"    Intérêts de la dette en pourcentage du PIB",5.0000000000000001E-3,{"$f":"D31/D9","v":7.4383997069898261E-3},{"$f":"D32+($C32-$D32)/($C$5-$D$5)","v":7.2642282993476952E-3},7.0900568917055644E-3,6.9158854840634335E-3,6.7417140764213027E-3,6.5675426687791718E-3,6.3933712611370409E-3,6.2191998534949101E-3,6.0450284458527792E-3,5.8708570382106483E-3,5.6966856305685175E-3,5.5225142229263866E-3,5.3483428152842558E-3,5.1741714076421249E-3,4.999999999999994E-3]
[null,"En pourcentage du PIB",null,{"$f":"D30/D9","v":0.33134252409857173},0.32045460715342577,0.30956669020827987,0.29867877326313386,0.28779085631798801,0.27690293937284205,0.26601502242769604,0.26276314462423406,0.25951126682077202,0.25625938901731005,0.25300751121384801,0.24975563341038604,0.24650375560692403,0.24325187780346205,0.24000000000000007,null,null,null,null,5141]
[null,"En pourcentage des ressources internes",null,{"$f":"D30/D19","v":2.2267467893477204},2.1217992197878468,2.0199036824309218,1.9209289489467924,1.8247512079417219,1.7312535482589775,1.6403254848807773,1.5983102849812969,1.5574189029871666,1.5176068443312913,1.4788319327094246,1.4410541610384071,1.4042355537667544,1.3683400395414351,1.3333333333333337,null,null,null,null,4965]
[null,"Déficit budgétaire"]
[null,"En millions de dobras",null,{"$f":"D30-D28","v":347.84713767040012},{"$f":"E37*E9","v":305.81560853522672},258.10837360373131,204.22825061395238,143.64053626514649,75.770382879864755,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"W33+W34","v":10106}]
[null,"En pourcentage du PIB",0,{"$f":"D36/D9","v":4.5816234850103658E-2},{"$f":"IF(E$5<$C38, D37+($C37-$D37)/($C38-$D$5),$C37)","v":3.8180195708419712E-2},3.0544156566735769E-2,2.2908117425051826E-2,1.5272078283367883E-2,7.6360391416839396E-3,0,0,0,0,0,0,0,0,0]
[null,"Hypothèses annuelles",2022]
[null,"Ressources publiques consacrées à l’éducation en millions de dobras",null,438.65356316985998,{"$f":"E40*(E30-E31)","v":456.51320613566685},{"$f":"F40*(F30-F31)","v":474.3579049435628},492.09609853414997,509.62422528956205,526.82557137159506,543.56902270722992,566.6671267714554,590.66172598905632,615.58156306210992,641.45583049208244,668.31413311108884,696.1864451309475,725.10306122032966,{"$f":"R40*(R30-R31)","v":755.0945410830227}]
[null,"En pourcentage du total des dépenses publiques (hors intérêts de la dette)",0.2,{"$f":"D39/(D30-D31)","v":0.17837588696264367},{"$f":"IF(E$5<$C41, D40+($C40-$D40)/($C41-$D$5),$C40)","v":0.18197990580220305},0.18558392464176243,0.18918794348132181,0.19279196232088119,0.19639598116044057,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2]
[null,"Hypothèses annuelles",2022]
[]
[null,"Dépenses courantes d’éducation"]
[]
["X","Enseignement préscolaire (garderies et maternelles)"]
[null,"Population d’âge scolaire (0-3 ans)",null,19155,19501,19851,20207,20568,20935,21307,21691,22085,22486,22890,23290,23667,24010,24313]
[null,"Population d’âge scolaire (4-5 ans)",null,11025,10143,9344,9518,9693,9869,10049,10231,10416,10603,10795,10995,11201,11407,11611]
[null,"Taux de scolarisation des 0-3 ans (%)",0,{"$f":"SUM(D53:D54)/D46","v":0.31866353432524147},{"$f":"IF(E$5<$C49, D48+($C48-$D48)/($C49-$D$5),$C48)","v":0.26555294527103457},{"$f":"IF(F$5<$C49, E48+($C48-$D48)/($C49-$D$5),$C48)","v":0.21244235621682767},0.15933176716262076,0.10622117810841386,5.3110589054206951E-2,0,0,0,0,0,0,0,0,0]
[null,"Année de l’objectif intermédiaire",2022]
[null,"Taux de scolarisation des 4-5 ans (%)",1,{"$f":"SUM(D55:D56)/D47","v":0.59274376417233565},{"$f":"IF(E$5<$C51, D50+($C50-$D50)/($C51-$D$5),$C50)","v":0.66061980347694638},{"$f":"IF(F$5<$C51, E50+($C50-$D50)/($C51-$D$5),$C50)","v":0.7284958427815571},{"$f":"IF(G$5<$C51, F50+($C50-$D50)/($C51-$D$5),$C50)","v":0.79637188208616783},0.86424792139077855,0.93212396069538928,1,1,1,1,1,1,1,1,1]
[null,"Année de l’objectif intermédiaire",2022]
[null,"Nombre d’élèves âgés de 0 à 3 ans",null,{"$f":"D53+D54","v":6104},{"$f":"E48*E46","v":5178.5479857304454},4217.193213260246,3219.6170190550779,2184.7571913338561,1111.8701818498225,0,0,0,0,0,0,0,0,0]
[null,"Nombre d’élèves âgés de 0 à 2 ans",null,{"$f":"D58-D57","v":3412}]
[null,"Nombre d’élèves âgés de 3 ans",null,2692]
[null,"Nombre d’élèves âgés de 4 ans",null,3299]
[null,"Nombre d’élèves âgés de 5 ans",null,3236]
[null,"Nombre d’élèves âgés de 4 à 5 ans",null,{"$f":"SUM(D55:D56)","v":6535},{"$f":"E50*E47","v":6700.666666666667},{"$f":"F50*F47","v":6807.0651549508693},7579.867573696145,8377.1551020408169,9199.1313681027968,10049,10231,10416,10603,10795,10995,11201,11407,11611]
[null,"Nombre total d’élèves",null,9947,11180,{"$f":"F57+F52","v":11024.258368211114},{"$f":"G57+G52","v":10799.484592751223},10561.912293374673,10311.00154995262,10049,10231,10416,10603,10795,10995,11201,11407,11611]
[null,"Enseignement privé"]
[null,"Nombre d’élèves scolarisés dans l’enseignement privé (4-5 ans)",null,884,1074,{"$f":"F61*F58","v":1022.7654981139382},966.3786174678869,910.36774054381385,854.81443976606977,800.02931893687742,780.8556478405319,760.70339892665515,739.47321748019476,717.344716330182,694.45802453360659,670.6144326603636,645.41523128034828,618.75383976488695]
[null,"        Pourcentage d’élèves scolarisés dans le privé",0.05,{"$f":"D60/D58","v":8.8871016386850313E-2},{"$f":"E60/E58","v":9.6064400715563505E-2},{"$f":"E61+($C$61-$E$61)/($C$5-$D$5)","v":9.2774086378737547E-2},8.9483772041911588E-2,8.619345770508563E-2,8.2903143368259671E-2,7.9612829031433713E-2,7.6322514694607754E-2,7.3032200357781796E-2,6.9741886020955837E-2,6.6451571684129879E-2,6.316125734730392E-2,5.9870943010477955E-2,5.6580628673651989E-2,5.3290314336826024E-2]
[null,"Enseignement public"]
[null,"Nombre d’élèves ",null,{"$f":"D58-D60","v":9063},10106,10001.492870097176,9833.1059752833371,9651.5445528308592,9456.1871101865509,9248.9706810631233,9450.1443521594683,9655.2966010733453,9863.5267825198061,10077.655283669817,10300.541975466393,10530.385567339636,10761.584768719651,10992.246160235112]
[null,"Nombre d’enseignants",null,null,61,{"$f":"F63/F67","v":67.789402550715309},{"$f":"G63/G67","v":75.988074451743628},86.740757539364452,101.53267156962956,123.31960908084164,126.00192469545958,128.73728801431128,131.51369043359742,134.36873711559755,137.34055967288523,140.4051408978618,143.48779691626203,146.56328213646816]
[null,"Nombre de moniteurs et d’auxiliaires",null,542,530,{"$f":"F63/F68","v":530.46105407408356},{"$f":"G63/G68","v":527.50578635776424},523.76705981736916,519.18318986438385,513.8317045035069,525.00801956441489,536.40536672629696,547.97371013998918,559.8697379816565,572.25233197035516,585.02142040775755,597.86582048442506,610.680342235284]
[null,"Nombre total d’enseignants, de moniteurs et d’assistants",null,{"$f":"D65+D64","v":542},{"$f":"E65+E64","v":591},{"$f":"F65+F64","v":598.25045662479886},{"$f":"G65+G64","v":603.49386080950785},610.50781735673365,620.71586143401339,637.1513135843486,651.00994425987449,665.14265474060824,679.48740057358657,694.23847509725408,709.59289164324036,725.42656130561932,741.35361740068709,757.24362437175216]
[null,"Nombre d’élèves par enseignant",75,null,{"$f":"E63/E64","v":165.67213114754099},{"$f":"IF(F$5<$C70, E67+($C67-$E67)/($C70-$E$5),$C67)","v":147.5377049180328},129.40327868852461,111.26885245901641,93.134426229508222,75,75,75,75,75,75,75,75,75]
[null,"Nombre d’élèves par moniteur et auxiliaire",18,{"$f":"D63/D65","v":16.721402214022142},{"$f":"E63/E65","v":19.067924528301887},{"$f":"IF(F$5<$C70, E68+($C68-$E68)/($C70-$E$5),$C68)","v":18.854339622641511},{"$f":"IF(G$5<$C70, F68+($C68-$E68)/($C70-$E$5),$C68)","v":18.640754716981135},18.427169811320759,18.213584905660383,18,18,18,18,18,18,18,18,18]
[null,"Nombre d’élèves par enseignant, moniteur et assistant",null,null,{"$f":"E63/E66","v":17.099830795262267},{"$f":"F63/F66","v":16.717902609758895},16.293630497075007,15.809043354462473,15.234324910499829,14.516129032258062,14.516129032258064,14.516129032258064,14.516129032258066,14.516129032258064,14.516129032258064,14.516129032258066,14.516129032258064,14.516129032258064]
[null,"Année de l’objectif intermédiaire",2022]
[null,"Nombre d’élèves par classe",null,null,{"$f":"E69*2","v":34.199661590524535},{"$f":"F69*2","v":33.435805219517789},{"$f":"G69*2","v":32.587260994150014},31.618086708924945,30.468649820999659,29.032258064516125,29.032258064516128,29.032258064516128,29.032258064516132,29.032258064516128,29.032258064516128,29.032258064516132,29.032258064516128,29.032258064516128]
[null,"Nombre de classes",null,null,{"$f":"E63/E71","v":295.5},{"$f":"F63/F71","v":299.12522831239943},{"$f":"G63/G71","v":301.74693040475393},305.25390867836683,310.3579307170067,318.5756567921743,325.50497212993724,332.57132737030412,339.74370028679328,347.11923754862704,354.79644582162018,362.71328065280966,370.67680870034354,378.62181218587608]
[null,"Besoins en enseignants, moniteurs et assistants "]
[null,"Taux d’attrition des enseignants",1.4999999999999999E-2]
[null,"Nombre d’enseignants après attrition",null,null,null,{"$f":"E64*(1-$C$74)","v":60.085000000000001},66.772561512454573,74.848253334967467,85.439646176273982,100.00968149608511,121.46981494462902,124.11189582502769,126.8062286940966,129.54098507709347,132.35320605886358,135.28045127779197,138.29906378439387,141.33547996251809]
[null,"Nouveaux enseignants",null,null,null,{"$f":"IF((F64-F75)<0,0,(F64-F75))","v":7.704402550715308},9.2155129392890558,11.892504204396985,16.093025393355575,23.309927584756537,4.532109750830557,4.6253921892835876,4.7074617395008147,4.8277520385040873,4.9873536140216572,5.1246896200698302,5.1887331318681618,5.2278021739500673]
[null,"Taux d’attrition des moniteurs et des auxiliaires",1.4999999999999999E-2]
[null,"Nombre de moniteurs et d’auxiliaires après attrition",null,null,{"$f":"D65*(1-$C$77)","v":533.87},522.04999999999995,522.50413826297233,519.59319956239779,515.91055392010867,511.39544201641809,506.12422893595431,517.13289927094866,528.35928622540246,539.75410448788932,551.47169191193166,563.66854699079977,576.24609910164122,588.89783317715865]
[null,"Nouveaux moniteurs et auxiliaires",null,null,{"$f":"IF((E65-E78)>=0,(E65-E78),0)","v":0},8.4110540740836086,5.0016480947919035,4.1738602549713733,3.27263594427518,2.4362624870888112,18.883790628460588,19.272467455348306,19.614423914586723,20.115633493767177,20.780640058423501,21.352873416957777,21.619721382783837,21.782509058125356]
[null,"Rémunération moyenne des éducateurs, moniteurs et assistants (hors heures supplémentaires)"]
[null,"Rémunération annuelle moyenne en PIB par habitant",null,{"$f":"D82/D15","v":1.5539609782855266},{"$f":"E82/E15","v":1.5369654080879505},1.5195073667090742,1.5016494234810023,1.483378558314292,1.4648295619521168,1.4458453737698567,1.4267067948528549,1.407290693401098,1.3876768601743845,1.3678162154683902,1.3477409450513982,1.3273799330360219,1.3066852786994676,1.2856295300554486]
[null,"Rémunération annuelle moyenne (en dobras)",80000,60906.84081918819,{"$f":"D82+($C82-$D82)/($C5-$D5)","v":62270.63790353189},{"$f":"E82+($C82-$D82)/($C5-$D5)","v":63634.434987875589},64998.232072219289,66362.029156562989,67725.826240906696,69089.623325250403,70453.42040959411,71817.217493937816,73181.014578281523,74544.81166262523,75908.608746968937,77272.405831312644,78636.202915656351,80000.000000000058]
[null,"Masse salariale des enseignants, moniteurs et assistants (en milliers de dobras, hors heures supplémentaires)",null,{"$f":"(D82*D66)/10^3","v":33011.507724000003},36801.94700098734,38069.329788557647,39226.034019056002,40514.537575737195,42038.494576454708,44020.544256731147,45865.877293767364,47768.694700001448,49725.577367134261,51751.876375072941,53864.209181377053,56055.455646021415,58297.233490176288,60579.489949740215]
[null,"Heures supplémentaires (en milliers de dobras)",null,2316.1596,{"$f":"E85*E83","v":2240.4725751846499},{"$f":"F85*F83","v":2139.3505916237405},2020.656862689629,1897.3015901387357,1771.8018430312877,1649.1907076256223,1503.533916237539,1342.2088835703382,1164.3279505889054,969.41910942990728,756.74058631680657,525.01700128913592,273.00677835661571,0]
[null,"Heures supplémentaires en pourcentage de la masse salariale (heures supplémentaires comprises)",0,{"$f":"D84/(D84+D83)","v":6.556220026524387E-2},{"$f":"D85+($C85-D85)/($C$5-D$5)","v":6.0879185960583594E-2},{"$f":"E85+($C85-E85)/($C$5-E$5)","v":5.6196171655923319E-2},5.1513157351263043E-2,4.6830143046602768E-2,4.2147128741942493E-2,3.7464114437282217E-2,3.2781100132621942E-2,2.8098085827961666E-2,2.3415071523301387E-2,1.8732057218641109E-2,1.4049042913980831E-2,9.3660286093205543E-3,{"$f":"P85+($C85-P85)/($C$5-P$5)","v":4.6830143046602771E-3},{"$f":"Q85+($C85-Q85)/($C$5-Q$5)","v":0}]
[null,"Masse salariale des enseignants, des moniteurs et des assistants (en milliers de dobras, heures supplémentaires comprises)",null,{"$f":"D83/(1-D85)","v":35327.667324000002},{"$f":"E83/(1-E85)","v":39187.659831211771},{"$f":"F83/(1-F85)","v":40336.062055767536},41356.434538948044,42505.055400338839,43888.258664653535,45733.925266584585,47420.369163646763,49149.707396857557,50917.821806545231,52739.801351692615,54631.732739093713,56585.436462802922,{"$f":"Q83/(1-Q85)","v":58571.524778560044},{"$f":"R83/(1-R85)","v":60579.489949740215}]
[null,"Rémunération moyenne (heures supplémentaires comprises) en PIB par habitant",null,{"$f":"D88/D15","v":1.6629902800663934},1.6366003022305937,1.6099822029489765,1.583205328697558,1.5562583599271522,1.5292845132135888,1.5021210070776596,1.4750609143891629,1.4479760486941389,1.4209484702358834,1.39392734220113,1.3669452170670338,1.3399297534412322,1.3128332958033488,1.2856295300554486]
[null,"Rémunération moyenne (heures supplémentaires comprises) en dobras",null,{"$f":"(D86*10^3)/D66","v":65180.19801476015},66307.377040967462,67423.370277617461,68528.343409283087,69622.458864440981,70705.875895067933,71778.750653913768,72841.236269529531,73893.482919126458,74935.637899338748,75967.845694960124,76990.248045721295,78002.98401117367,79006.190033741048,80000.000000000058]
[null,"Masse salariale des autres personnels préscolaires (en milliers de dobras)",null,12078.578576161575,{"$f":"E90*E86","v":9831.2149954081251},{"$f":"F90*F86","v":9961.4662356482477},10051.611558780873,10164.439115447421,10323.455244519049,10578.616495292419,10783.12542883582,10984.020688697577,11179.894462466818,11373.545493766414,11567.74758826194,11759.979558056468,11943.523610937698,12115.897989948044]
[null,"Masse salariale des autres personnels en pourcentage de la masse salariale totale (personnel enseignant et non enseignant)",0.2,{"$f":"D89/(D89+D86)","v":0.25478875930398037},{"$f":"D90+($C90-D90)/($C$5-D$5)","v":0.25087527649655322},0.24696179368912605,0.24304831088169887,0.23913482807427169,0.23522134526684452,0.23130786245941734,0.22739437965199016,0.22348089684456299,0.21956741403713581,0.21565393122970866,0.21174044842228151,0.20782696561485434,{"$f":"P90+($C90-P90)/($C$5-P$5)","v":0.20391348280742716},{"$f":"Q90+($C90-Q90)/($C$5-Q$5)","v":0.2}]
[null,"Masse salariale totale du personnel enseignant, non enseignant et administratif (en milliers de dobras)",null,{"$f":"D89+D86","v":47406.245900161579},{"$f":"E86/(1-E90)","v":52311.262199359866},{"$f":"F86/(1-F90)","v":53564.429689926983},54635.500697699877,55864.109659218258,57386.877095787815,59495.763040987382,61377.199330088864,63294.910836236289,65243.075087292782,67240.473882120437,69306.781795091636,71430.652151297181,73574.320772464023,75724.362437175267]
[null,"Dépenses administratives et pédagogiques"]
[null,"Dépenses éducatives dans les établissements (en milliers de dobras)",null,53.062873690954966,{"$f":"E94*E91","v":484.7214919822743},{"$f":"F94*F91","v":932.71107273093799},1396.4648877606376,1882.9803053697142,2401.8256153100442,2974.7881520493693,3068.8599665044435,3164.7455418118147,3262.1537543646391,3362.023694106022,3465.3390897545819,3571.5326075648591,3678.7160386232013,3786.2181218587634]
[null,"Dépenses pédagogiques en pourcentage de la masse salariale totale",0.05,{"$f":"D93/D91","v":1.119322415926086E-3},{"$f":"IF(E$5<$C95, D94+($C94-$D94)/($C95-$D$5),$C94)","v":9.2661020132717396E-3},1.7412881610617395E-2,2.5559661207963047E-2,3.3706440805308699E-2,4.1853220402654351E-2,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05]
[null,"Année de l’objectif intermédiaire",2022]
[null,"Par élève",null,{"$f":"D93/D63","v":5.8548906202090878E-3},{"$f":"E93*10^3/E63","v":47.963733621835964},93.257185186782579,142.01666200596389,195.09626620512509,253.99514490599594,321.63450989634146,324.74212584945047,327.77300093090884,330.72893968776413,333.61169830386655,336.42298609221257,339.16446693481902,341.83776067220191,344.44444444444468]
[null,"Dépenses administratives (en milliers de dobras)",null,3024.2692211398225,{"$f":"E98*E91","v":3216.9134099195103},{"$f":"F98*F91","v":3170.82647250849},3108.6163499427503,3050.0824741684114,3001.283381017282,2974.7881520493693,3068.8599665044435,3164.7455418118147,3262.1537543646391,3362.023694106022,3465.3390897545819,3571.5326075648591,3678.7160386232013,3786.2181218587634]
[null,"Dépenses administratives en pourcentage de la masse salariale totale",0.05,{"$f":"D97/D91","v":6.3794741889264733E-2},{"$f":"IF(E$5<$C99, D98+($C98-$D98)/($C99-$D$5),$C98)","v":6.1495618241053943E-2},5.9196494592843152E-2,5.6897370944632361E-2,5.459824729642157E-2,5.229912364821078E-2,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05]
[null,"Année de l’objectif intermédiaire",2022]
[null,"Dépenses pédagogiques et administratives (en milliers de dobras)",null,{"$f":"D97+D93","v":3077.3320948307774},{"$f":"E97+E93","v":3701.6349019017844},{"$f":"F97+F93","v":4103.5375452394283},4505.0812377033881,4933.0627795381261,5403.1089963273262,5949.5763040987385,6137.719933008887,6329.4910836236295,6524.3075087292782,6724.0473882120441,6930.6781795091638,7143.0652151297181,7357.4320772464025,7572.4362437175268]
[null,"Dépenses consacrées aux enfants présentant des besoins éducatifs particuliers"]
[null,"Nombre d’enfants âgés de 4 à 5 ans présentant des besoins éducatifs particuliers",null,174,{"$f":"E103*E47","v":184.87071428571431},193.14565597667641,220.00547133138974,247.74139941690967,276.36077259475223,305.96226433430519,336.50942176870751,368.05224489795921,400.57495140913511,434.21287657920317,469.13068513119543,505.29681243926149,542.46991739552971,580.55000000000007]
[null,"Pourcentage d’enfants âgés de 4 à 5 ans présentant des besoins éducatifs particuliers",0.05,{"$f":"D102/D47","v":1.5782312925170069E-2},{"$f":" D103+($C103-$D103)/($C5-$D$5)","v":1.8226433430515065E-2},2.0670553935860061E-2,2.3114674441205057E-2,2.5558794946550053E-2,2.8002915451895049E-2,3.0447035957240045E-2,3.2891156462585038E-2,3.5335276967930034E-2,3.777939747327503E-2,4.0223517978620026E-2,4.2667638483965022E-2,4.5111758989310018E-2,4.7555879494655014E-2,5.000000000000001E-2]
[null,"Subvention moyenne par enfant présentant des besoins éducatifs particuliers en pourcentage du PIB par habitant",0.01,0,{"$f":"IF(E$5<$C105, D104+($C104-$D104)/($C105-$D$5),$C104)","v":2.5000000000000001E-3},5.0000000000000001E-3,7.4999999999999997E-3,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[null,"Année de l’objectif intermédiaire",2020]
[null,"Dotation annuelle allouée aux enfants présentant des besoins éducatifs particuliers (en dobras)",null,null,{"$f":"E104*E15","v":101.28828790785731},209.39166331813868,324.63418752666803,447.37082644619483,462.34611862045801,477.84932316177117,493.81849630049891,510.32254978089935,527.36351436374832,544.9914310095993,563.22848263747039,582.14233851323149,601.79910340707499,622.26324247973446]
[null,"Dépenses consacrées aux enfants présentant des besoins éducatifs particuliers (en milliers de dobras)",null,null,{"$f":"(E106*E102)/1000","v":18.725238134302661},{"$f":"(F106*F102)/1000","v":40.443090167629272},71.421297437087375,110.83227460207974,127.77433054813473,146.20386092519064,166.1745766487735,187.82536006891056,211.2486141412092,236.64229696969446,264.2277639451201,294.1546680366734,326.45790991393983,361.25492542160987]
[null,"Dépenses sociales (hors bourses)"]
[null,"Dépenses de restauration scolaire hors frais de personnel (en milliers de dobras)",{"$f":"(3751440+5093760+1078000+98230)/1000","v":10021.43}]
[null,"Nombre d’enfants bénéficiaires (y compris dans l’enseignement préscolaire)",{"$f":"D63+D143","v":45457}]
[null,"Coût unitaire par enfant bénéficiaire hors frais de personnel",2]
[null,"Nombre de jours/repas annuels pris en charge par l’État",180]
[null,"Dépenses totales d’approvisionnement alimentaire des cantines scolaires hors frais de personnel (en milliers de dobras)",null,537.497297,{"$f":"(E63*$C$112*$C$111)/10^3","v":3638.16},{"$f":"(F63*$C$112*$C$111)/10^3","v":3600.5374332349829},3539.9181511020015,3474.556039019109,3404.227359667158,3329.6294451827243,3402.0519667774083,3475.9067763864045,3550.8696417071301,3627.9559021211339,3708.1951111679014,3790.9388042422688,3874.1705167390742,3957.2086176846406]
[null,"Coût par élève de l’enseignement public"]
[null,"             Coût unitaire en PIB par habitant",null,{"$f":"D116/D15","v":0.14363215042306318},0.14573233993945348,0.14637592424612977,0.14743592460333646,0.14910896878124461,0.15169604607810358,0.15594386009062577,0.15232137248235181,0.14873846186872494,0.14520257114288354,0.14170753527016403,0.13825574816025912,0.1348390530403018,0.13145194428743781,0.1280911639404137]
[null,"             Coût unitaire en dobras",null,{"$f":"D117*10^3/D63","v":5629.6011576732162},5904.391682109238,6129.979649525395,6381.6988794462959,6670.700259420526,7013.6078114281336,7451.7667995539468,7521.9111113663157,7590.4591111336786,7657.4538212563257,7722.9392431729948,7786.9575252210989,7849.5521659790948,7910.7662213296835,7970.6423006565055,{"$f":"R116/D116","v":1.4158449377523701}]
[null,"Total des frais de fonctionnement de l’enseignement préscolaire (en milliers de dobras)",null,{"$f":"D91+D100+D107+D113","v":51021.075291992362},{"$f":"E91+E100+E107+E113","v":59669.782339395955},61308.947758569026,62751.921383942354,64382.560752377576,66321.987782330427,68921.172651194036,71083.145806523928,73288.134056315219,75529.500851870398,77829.119469423313,80209.882849713831,82658.810838705831,85132.381276363434,87615.262223999045,{"$f":"R117/D117","v":1.7172366854790702}]
[]
["X","Ensino basico (1° e 2° ciclo)"]
[null,"População"]
[null,"População escolarizável 1° ciclo (6-9 anos)",null,21827,21988,21998,21123,20333,19629,19007,19359,19714,20074,20440,20811,21188,21577,21976]
[null,"População escolarizável 2° ciclo (10-11 anos)",null,10339,10564,10817,10972,10975,10982,10990,10112,9317,9492,9668,9845,10025,10208,10394]
[null,"População escolarizável 6 anos",null,5500,5503,5508,4623,4710,4797,4885,4974,5065,5157,5250,5345,5442,5545,5649]
[null,"População escolarizável 11 anos",null,5105,5231,5330,5484,5485,5488,5491,5497,4614,4701,4789,4877,4966,5057,5150]
[null,"Taxas de acesso, de sobrevivencia e de transiçao"]
[null,"   Taxa de acesso 1°a",1,{"$f":"E126","v":1.02},1.02,{"$f":"IF(F$5<$C133, E126+($C126-$E126)/($C133-$E$5),$C126)","v":1.016},1.012,1.008,1.004,1,1,1,1,1,1,1,1,1]
[null,"       Taxa de sobrevivência 1° ciclo (1°a - 4°a)",1,0.94970896904488933,{"$f":"E128/E126","v":0.94970896904488933},{"$f":"IF(F$5<$C133, E127+($C127-$E127)/($C133-$E$5),$C127)","v":0.95976717523591148},0.96982538142693364,0.9798835876179558,0.98994179380897795,1,1,1,1,1,1,1,1,1]
[null,"   Taxa de acesso 4°a",null,0.96870314842578709,0.96870314842578709,{"$f":"E126*F127","v":0.97896251874062978},{"$f":"F126*G127","v":0.98534258752976456},0.99164219066937132,0.99786132815944983,1.004,1,1,1,1,1,1,1,1]
[null,"       Taxa de transição 1° ciclo - 2° ciclo (4°a - 5°a) ",1,0.9806925904430257,{"$f":"E130/E128","v":0.9806925904430257},{"$f":"IF(F$5<$C133, E129+($C129-$E129)/($C133-$E$5),$C129)","v":0.98455407235442061},0.98841555426581551,0.99227703617721041,0.99613851808860532,1,1,1,1,1,1,1,1,1]
[null,"   Taxa de acesso 5°a",null,0.95,0.95,{"$f":"E128*F129","v":0.95374062968515738},{"$f":"F128*G129","v":0.96762178056647841},0.97773282237321835,0.98781298228752579,0.99786132815944983,1.004,1,1,1,1,1,1,1]
[null,"       Taxa de sobrevivência 2° ciclo (5°a - 6°a)",1,0.97468941698025668,{"$f":"E132/E130","v":0.97468941698025668},{"$f":"IF(F$5<$C133, E131+($C131-$E131)/($C133-$E$5),$C131)","v":0.9797515335842053},0.98481365018815392,0.98987576679210254,0.99493788339605116,1,1,1,1,1,1,1,1,1]
[null,"   Taxa de acesso 6°a",null,0.92595494613124385,0.92595494613124385,{"$f":"E130*F131","v":0.93076395690499503},{"$f":"F130*G131","v":0.93925679085298819},0.95782535200298236,0.97278342481885716,0.98781298228752579,0.99786132815944983,1.004,1,1,1,1,1,1]
[null,"Ano do meta intermediário",2022]
[null,"% repetentes"]
[null,"     1° ciclo (1° - 4° ano)",0.05,0.11163083212137888,0.11499511241446725,{"$f":"IF(F$5<$C136, E135+($C135-$D135)/($C136-$D$5),$C135)","v":0.11059291012008304},0.10619070782569884,0.10178850553131463,9.7386303236930427E-2,9.2984100942546222E-2,8.8581898648162016E-2,8.4179696353777811E-2,7.9777494059393605E-2,7.53752917650094E-2,7.0973089470625195E-2,6.6570887176240989E-2,6.2168684881856784E-2,0.05]
[null,"Ano do meta intermediário",2030]
[null,"     2° ciclo (5° - 6° ano)",0.05,0.19118049849356342,0.139209726443769,{"$f":"IF(F$5<$C138, E137+($C137-$D137)/($C138-$D$5),$C137)","v":0.12912540512280019},{"$f":"IF(G$5<$C138, F137+($C137-$D137)/($C138-$D$5),$C137)","v":0.11904108380183137},0.10895676248086256,9.8872441159893742E-2,8.8788119838924928E-2,7.8703798517956114E-2,6.86194771969873E-2,5.8535155876018485E-2,4.8450834555049671E-2,3.8366513234080857E-2,2.8282191913112043E-2,1.8197870592143228E-2,0.05]
[null,"Ano do meta intermediário",2030]
[null,"    Total ensino basico",null,0.13557179754904655,0.12251280668643839,{"$f":"(F135*F141+F137*F142)/F143","v":0.11655576183004239},0.11049206929229678,0.10426140140915525,9.7912930179071586E-2,9.1460238681552258E-2,8.5214450148821438E-2,7.9236134443926159E-2,7.3062995447828877E-2,6.6897163787578581E-2,6.0745360687101971E-2,5.4606460159476677E-2,4.8482712241000016E-2,0.05]
[null,"Numero de alunos"]
[null,"     1° ciclo (1° - 4° ano)",null,25441,25575,{"$f":"F146*F121","v":24671.034212905543},23601.157341830251,22633.157621151895,21767.083831853488,20997.442293780143,21240.526133161336,21526.056936618694,21814.289338078448,22106.266269931042,22400.858106619915,22699.099169837562,23007.335809939166,23132.631578947367]
[null,"     2° ciclo (5° - 6° ano)",null,10953,11515,{"$f":"F148*F122","v":11703.57146313361},11874.714757361055,11920.157220946619,11946.848995805018,11974.471112006728,10986.055145882901,10023.437007147388,10082.160857352204,10160.273742113139,10237.788237917792,10316.781185411388,10397.207028015551,10941.052631578947]
[null,"    Total ensino basico",null,{"$f":"D141+D142","v":36394},{"$f":"SUM(E141:E142)","v":37090},{"$f":"SUM(F141:F142)","v":36374.605676039151},35475.872099191307,34553.314842098516,33713.932827658507,32971.913405786872,32226.581279044236,31549.49394376608,31896.450195430654,32266.540012044181,32638.646344537709,33015.880355248948,{"$f":"SUM(Q141:Q142)","v":33404.542837954716},{"$f":"SUM(R141:R142)","v":34073.684210526313}]
[null,"Taxa bruta de escolarização  (TBE - %)"]
[null,"     1° ciclo (1° - 4° ano)",null,{"$f":"D141/D121","v":1.1655747468731388},1.1631344369656176,1.1215126017322277,1.1173203305321333,1.1131243604560024,1.1089247456239997,1.1047215391056002,1.0971912874198737,1.0919172637018715,1.0866937002131338,1.0815198762197182,1.0763950846484991,1.0713186317650349,1.0662898368605074,1.0526315789473684]
[null,"     1° ciclo (1° - 4° ano) : verificação",null,null,{"$f":"(E126+E128)/2/(1-E135)","v":1.1235548957539432},1.1215126017322277,1.1173203305321333,1.1131243604560024,1.1089247456239997,1.1047215391056002,1.0971912874198737,1.0919172637018715,1.0866937002131338,1.0815198762197182,1.0763950846484991,1.0713186317650349,1.0662898368605074,1.0526315789473684]
[null,"     2° ciclo (5° - 6° ano)",null,{"$f":"D142/D122","v":1.0593867878905117},1.0900227186671716,1.0819609377030239,1.0822744036967786,1.0861191089700792,1.0878573115830465,1.0895788090997933,1.086437415534306,1.0758223684820638,1.0621745530290987,1.0509178467225009,1.0398972308702683,1.0291053551532556,1.0185351712397679,1.0526315789473684]
[null,"     2° ciclo (5° - 6° ano) : (verificação)",null,null,{"$f":"(E130+E132)/2/(1-E137)","v":1.0896701576221384},1.0819609377030239,1.0822744036967786,1.0861191089700792,1.0878573115830465,1.0895788090997933,1.086437415534306,1.0758223684820638,1.0621745530290987,1.0509178467225009,1.0398972308702683,1.0291053551532556,1.0185351712397679,1.0526315789473684]
[null,"    Total ensino basico",null,{"$f":"D143/(D121+D122)","v":1.1314431387179009},1.1394077168837553,1.1084749558445575,1.1053395263807855,1.1036576862814143,1.1013665946116922,1.099173697562652,1.093501451564054,1.0867518839780261,1.0788219642640415,1.0716932380777262,1.0646740065415485,1.0577605598708535,1.0509530545211487,1.0526315789473684]
[null,"Privado"]
[null,"Numero de alunos"]
[null,"     1° ciclo (1° - 4° ano)",null,185,261,{"$f":"F153*F141","v":189.01663675860931},185.41911118899657,182.22483426841941,179.49376868706105,177.23913131940637,183.43028159609332,190.09101271178702,196.8874139949221,203.8306812318713,210.91236774478472,218.14394237204397,{"$f":"Q153*Q141","v":225.58976530887949},{"$f":"R153*R141","v":231.32631578947368}]
[null,"     % alunos 1° ciclo ( 1°a - 4°a) ano no privado",0.01,{"$f":"D152/D141","v":7.2717267403010887E-3},{"$f":"D153+($C153-D153)/($C$5-D$5)","v":7.4666034017081542E-3},{"$f":"E153+($C153-E153)/($C$5-E$5)","v":7.6614800631152197E-3},7.8563567245222843E-3,8.0512333859293489E-3,8.2461100473364135E-3,8.4409867087434781E-3,8.6358633701505427E-3,8.8307400315576073E-3,9.0256166929646719E-3,9.2204933543717383E-3,9.4153700157788046E-3,9.6102466771858693E-3,{"$f":"P153+($C153-P153)/($C$5-P$5)","v":9.8051233385929339E-3},{"$f":"Q153+($C153-Q153)/($C$5-Q$5)","v":0.01}]
[null,"     5°- 6° ano",null,93,169,{"$f":"F155*F142","v":101.89621967609106},104.66633876499344,106.35185074618491,107.87784470035224,109.41809440806551,101.57060844954182,93.751315967778325,95.387411844249158,97.221698307069204,99.067035261504046,100.94354983855584,{"$f":"Q155*Q142","v":102.85126950689641},{"$f":"R155*R142","v":109.41052631578947}]
[null,"     % alunos 2° ciclo ( 5°a - 6°a) ano no privado",0.01,{"$f":"D154/D142","v":8.4908244316625574E-3},{"$f":"D155+($C155-D155)/($C$5-D$5)","v":8.5986226865438029E-3},{"$f":"E155+($C155-E155)/($C$5-E$5)","v":8.7064209414250485E-3},8.814219196306294E-3,8.9220174511875396E-3,9.0298157060687851E-3,9.1376139609500306E-3,9.2454122158312762E-3,9.3532104707125217E-3,9.461008725593769E-3,9.5688069804750146E-3,9.6766052353562601E-3,9.7844034902375074E-3,{"$f":"P155+($C155-P155)/($C$5-P$5)","v":9.8922017451187547E-3},{"$f":"Q155+($C155-Q155)/($C$5-Q$5)","v":0.01}]
[null,"    Total ensino basico no privado",null,{"$f":"D152+D154","v":278},{"$f":"E152+E154","v":430},290.91285643470036,290.08544995399001,288.57668501460432,287.37161338741328,286.65722572747188,285.00089004563517,283.84232867956536,292.27482583917129,301.0523795389405,309.97940300628875,319.08749221059981,{"$f":"Q152+Q154","v":328.44103481577588},{"$f":"R152+R154","v":340.73684210526312}]
[null,"     % alunos ensino basico no privado",null,{"$f":"D156/D143","v":7.6386217508380505E-3},1.1593421407387436E-2,7.9976909997496373E-3,8.1769786840730739E-3,8.3516353303102735E-3,8.5238235140474936E-3,8.6939821234991149E-3,8.8436588286502724E-3,8.9967315857898342E-3,9.1632399232012759E-3,9.3301723527395939E-3,9.4973118595087155E-3,9.6646670867848138E-3,{"$f":"Q156/Q143","v":9.8322266048974788E-3},{"$f":"R156/R143","v":0.01}]
[null,"Publico"]
[null,"Numero alunos"]
[null,"     1° ciclo (1° - 4° ano)",null,{"$f":"D141-D152","v":25256},{"$f":"E141-E152","v":25314},24482.017576146933,23415.738230641255,22450.932786883477,21587.590063166426,20820.203162460737,21057.095851565242,21335.965923906908,21617.401924083526,21902.435588699173,22189.945738875129,22480.955227465518,22781.746044630287,22901.305263157894]
[null,"     2° ciclo (5° - 6° ano)",null,{"$f":"D142-D154","v":10860},11346,11601.675243457519,11770.048418596061,11813.805370200434,11838.971151104666,11865.053017598662,10884.48453743336,9929.6856911796094,9986.7734455079553,10063.05204380607,10138.721202656288,10215.837635572832,10294.355758508655,10831.642105263158]
[null,"    Total ensino basico",null,{"$f":"D160+D161","v":36116},{"$f":"E160+E161","v":36660},36083.692819604454,35185.786649237314,34264.738157083913,33426.561214271089,32685.256180059398,31941.580388998602,31265.651615086517,31604.175369591481,31965.487632505243,32328.666941531417,32696.79286303835,{"$f":"Q160+Q161","v":33076.101803138939},{"$f":"R160+R161","v":33732.947368421053}]
[null,"Numero professores em sala da aula"]
[null,"     1° ciclo (1° - 4° ano)",null,664,{"$f":"E172*E179/E183","v":705.85970570449501},700.34607911728529,687.65849170043782,677.33903577162903,669.58692614769166,694.00677208202455,701.90319505217474,711.19886413023039,720.58006413611747,730.08118628997238,739.66485796250424,749.36517424885062,{"$f":"Q172*Q179/Q183","v":759.3915348210096},{"$f":"R172*R179/R183","v":763.37684210526299}]
[null,"     2° ciclo (5° - 6° ano)",null,447,{"$f":"E173*E180/E185","v":458.22179708215356},477.25111752123308,497.56741310278983,518.1864693095938,544.5978505289354,707.74129944652464,621.57287788838823,543.86239678062771,525.50244598109089,509.50205095210316,494.63740751921193,480.88559731289166,{"$f":"Q173*Q180/Q185","v":468.13121302837669},{"$f":"R173*R180/R185","v":476.39166666666665}]
[null,"    Total ensino basico",null,{"$f":"D164+D165","v":1111},{"$f":"E164+E165","v":1164.0815027866486},1177.5971966385184,1185.2259048032276,1195.5255050812229,1214.1847766766271,1401.7480715285492,1323.476072940563,1255.061260910858,1246.0825101172084,1239.5832372420755,1234.3022654817162,1230.2507715617423,{"$f":"Q164+Q165","v":1227.5227478493862},{"$f":"R164+R165","v":1239.7685087719296}]
[null,"Alunos por professor"]
[null,"     1° ciclo (1° - 4° ano)",null,{"$f":"D160/D164","v":38.036144578313255},35.862650602409644,34.957028112449798,34.051405622489959,33.14578313253012,32.240160642570288,30,30,29.999999999999993,30.000000000000004,30,30.000000000000004,30,29.999999999999996,30.000000000000007]
[null,"     2° ciclo (5° - 6° ano)",null,24.29530201342282,24.760934709454254,24.309372608103651,23.655183415648139,22.798367132087737,21.738923757422434,16.764675209539838,17.511196071505257,18.257716933470668,19.004237795436083,19.750758657401498,20.497279519366913,21.243800381332328,21.990321243297746,22.736842105263158]
[null,"    Total ensino basico",null,32.507650765076505,31.492640259501659,30.641795787733095,29.686987524187543,28.660817365628681,27.530044731547118,23.317496805554693,24.134611151699371,24.911653788433831,25.362827190808371,25.787286139513011,26.19185579223933,26.577339855297463,26.945408434253547,27.209069378472684]
[null,"Numero de turmas"]
[null,"     1° ciclo (1° - 4° ano)",null,{"$f":"D160/D174","v":721.6},{"$f":"E160/E174","v":767.09090909090912},{"$f":"F160/F174","v":761.09899200456789},{"$f":"G160/G174","v":747.31079459493367},736.09615694699926,727.6715751629132,694.00677208202455,701.90319505217474,711.19886413023028,720.58006413611758,730.08118628997238,739.66485796250424,749.36517424885062,{"$f":"Q160/Q174","v":759.3915348210096},{"$f":"R160/R174","v":763.37684210526311}]
[null,"     2° ciclo (5° - 6° ano)",null,{"$f":"D161/D176","v":212.94117647058823},{"$f":"E161/E176","v":231.55102040816325},254.98187348258284,280.239248061811,306.85208753767364,338.25631860299046,395.50176725328873,362.81615124777869,330.98952303932032,332.8924481835985,335.435068126869,337.9573734218763,340.5279211857611,{"$f":"Q161/Q176","v":343.14519195028851},{"$f":"R161/R176","v":361.05473684210523}]
[null,"    Alunos por turma 1° ciclo",30,35,33,{"$f":"IF(F$5<$C175, E174+($C174-$D174)/($C175-$D$5),$C174)","v":32.166666666666664},{"$f":"IF(G$5<$C175, F174+($C174-$D174)/($C175-$D$5),$C174)","v":31.333333333333332},30.5,29.666666666666668,30,30,30,30,30,30,30,30,30]
[null,"Ano do meta intermediário",2022]
[null,"    Alunos por turma 2° ciclo",30,51,49,{"$f":"IF(F$5<$C177, E176+($C176-$D176)/($C177-$D$5),$C176)","v":45.5},{"$f":"IF(G$5<$C177, F176+($C176-$D176)/($C177-$D$5),$C176)","v":42},38.5,35,30,30,30,30,30,30,30,30,30]
[null,"Ano do meta intermediário",2022]
[null,"Numero horas alunos por semana"]
[null,"     1° ciclo (1° - 4° ano)",23.75,18.75,{"$f":"IF(E5<$C$181,D179,$C$179)","v":18.75},18.75,18.75,18.75,18.75,23.75,23.75,23.75,23.75,23.75,23.75,23.75,23.75,23.75]
[null,"     2° ciclo (5° - 6° ano)",23.75,20.416666666666664,{"$f":"IF(E5<$C$181,D180,$C$180)","v":20.416666666666664},20.416666666666664,20.416666666666664,20.416666666666664,20.416666666666664,23.75,23.75,23.75,23.75,23.75,23.75,23.75,23.75,23.75]
[null,"              Ano de arranque",2022]
[null,"Numero horas professores em classe"]
[null,"     1° ciclo (1° - 4° ano)",23.75,{"$f":"(D179*D172)/D164","v":20.376506024096386},{"$f":"IF(E5<$C$184,D183,$C$183)","v":20.376506024096386},{"$f":"IF(F5<$C$184,E183,$C$183)","v":20.376506024096386},20.376506024096386,20.376506024096386,20.376506024096386,23.75,23.75,23.75,23.75,23.75,23.75,23.75,23.75,23.75]
[null,"              Ano de arranque",2022]
[null,"     2° ciclo (5° - 6° ano)",18,{"$f":"(D180*D173)/D165","v":9.7260604465499831},{"$f":"IF(E$5<$C$186,D185+($C185-D185)/($C$186-D$5),$C$185)","v":10.317056128939271},{"$f":"IF(F5<$C$186,E185+($C185-E185)/($C$186-E$5),$C$185)","v":10.908051811328559},11.499047493717846,12.090043176107132,12.681038858496418,13.272034540885706,13.863030223274993,14.454025905664279,15.045021588053565,15.636017270442853,16.227012952832141,16.818008635221428,17.409004317610716,18]
[null,"               Ano de referencia",2030]
[null,"Necessidade de professores en classe"]
[null,"    Taxa de atrito de professore por ano",1.4999999999999999E-2]
[null,"    Numero professores após atrito",null,null,{"$f":"E191+E190","v":1094.335},{"$f":"F191+F190","v":1146.6202802448488},1159.9332386889405,1167.4475162311792,1177.5926225050043,1195.9720050264777,1380.7218504556208,1303.6239318464545,1236.2353419971951,1227.3912724654501,1220.9894886834443,1215.7877314994903,{"$f":"Q191+Q190","v":1211.7970099883162},{"$f":"R191+R190","v":1209.1099066316456}]
[null,"         1° ciclo (1° - 4° ano)",null,null,{"$f":"D164*(1-$C$188)","v":654.04},{"$f":"E164*(1-$C$188)","v":695.27181011892753},689.84088793052604,677.3436143249312,667.17895023505457,659.54312225547631,683.59667050079418,691.37464712639212,700.53088116827689,709.77136317407565,719.12996849562273,728.56988509306666,{"$f":"P164*(1-$C$188)","v":738.12469663511786},{"$f":"Q164*(1-$C$188)","v":748.00066179869441}]
[null,"         2° ciclo (5° - 6° ano)",null,null,{"$f":"D165*(1-$C$188)","v":440.29500000000002},451.34847012592127,470.09235075841457,490.10390190624798,510.41367226994987,536.42888277100133,697.12517995482676,612.24928472006241,535.70446082891829,517.61990929137448,501.8595201878216,487.21784640642375,{"$f":"P165*(1-$C$188)","v":473.67231335319826},{"$f":"Q165*(1-$C$188)","v":461.10924483295105}]
[null,"    Novos professores",null,null,{"$f":"SUM(E193:E194)","v":69.746502786648591},{"$f":"SUM(F193:F194)","v":30.976916393669569},27.47506234437526,{"$f":"SUM(H193:H194)","v":28.08256740334582},36.59215417162261,205.77606650207156,18.306524551380562,19.824217003838271,20.049182967840579,20.309823115896734,20.534889466881509,20.795289155783962,{"$f":"SUM(Q193:Q194)","v":21.266838185891743},{"$f":"SUM(R193:R194)","v":30.658602140284188}]
[null,"         1° ciclo (1° - 4° ano)",null,null,{"$f":"IF((E164-E190)>0,E164-E190,0)","v":51.81970570449505},{"$f":"IF((F164-F190)>0,F164-F190,0)","v":5.074268998357752},{"$f":"IF((G164-G190)>0,G164-G190,0)","v":0},{"$f":"IF((H164-H190)>0,H164-H190,0)","v":0},{"$f":"IF((I164-I190)>0,I164-I190,0)","v":2.4079759126370845},34.463649826548249,18.306524551380562,19.824217003838271,20.049182967840579,20.309823115896734,20.534889466881509,20.795289155783962,{"$f":"IF((Q164-Q190)>0,Q164-Q190,0)","v":21.266838185891743},{"$f":"IF((R164-R190)>0,R164-R190,0)","v":15.376180306568585}]
[null,"         2° ciclo (5° - 6° ano)",null,null,{"$f":"IF((E165-E191)>0,E165-E191,0)","v":17.926797082153541},{"$f":"IF((F165-F191)>0,F165-F191,0)","v":25.902647395311817},27.47506234437526,28.08256740334582,34.184178258985526,171.31241667552331,0,0,0,0,0,0,{"$f":"IF((Q165-Q191)>0,Q165-Q191,0)","v":0},{"$f":"IF((R165-R191)>0,R165-R191,0)","v":15.282421833715603}]
[null,"Remuneração media professor (exclusão horas extras)"]
[null,"             Remuneração anual media em PIB / habitante",null,{"$f":"D197/D$15","v":1.5065280036735007},{"$f":"E197/E$15","v":1.5208013284481967},1.5326246449229723,1.5421616137324221,1.5494931685895827,1.5548486437155959,1.5581447863046587,1.5597605868423201,1.5596387500111657,1.5579367880494484,1.5546652067396232,1.54992057172522,1.5436767752986678,1.5359275191794821,1.5266850669408436]
[null,"             Remuneração anual media (dobras)",95000,59047.72551665167,{"$f":"D197+($C197-$D197)/($C$5-$D$5)","v":61615.74512260512},{"$f":"E197+($C197-$D197)/($C$5-$D$5)","v":64183.76472855857},66751.78433451202,69319.80394046547,71887.82354641892,74455.84315237237,77023.86275832582,79591.88236427927,82159.90197023272,84727.921576186171,87295.941182139621,89863.960788093071,92431.980394046521,94999.999999999971]
[null,"Massa salarial professores (exclusão horas extras) (000 de Dbs)",null,{"$f":"(D197*D166)/10^3","v":65602.023048999996},{"$f":"(E197*E166)/10^3","v":71725.749177641279},75582.62141405679,79115.943985101927,82873.593618056329,87285.100978477436,104368.3345528701,101939.23940610194,99892.68823838103,102378.01687805135,105027.31131220155,107749.57796847359,110555.20709514566,113462.35856246058,117778.00833333329]
[null,"Horas extras  (000 de Dbs)",null,20835.620387999999,{"$f":"E200*E201","v":21542.447924836957},{"$f":"F200*F201","v":21429.898731991889},21135.313113994205,20815.420960695894,20563.985314621641,23003.142633873929,20956.708056602718,19090.797971050903,18119.767987113955,17140.004291850353,16132.488847783858,15097.087104752454,14034.161117590947,13086.445370370366]
[null,"Horas extras em % do massa salarial incluindo horas extras",0.1,{"$f":"D199/(D198+D199)","v":0.24104799204973729},{"$f":"D200+($C200-D200)/($C$5-D$5)","v":0.23097313547475606},0.22089827889977484,0.21082342232479362,0.20074856574981237,0.19067370917483112,0.1805988525998499,0.17052399602486867,0.16044913944988742,0.15037428287490617,0.14029942629992495,0.13022456972494373,0.12014971314996249,{"$f":"P200+($C200-P200)/($C$5-P$5)","v":0.11007485657498126},{"$f":"Q200+($C200-Q200)/($C$5-Q$5)","v":0.1}]
[null,"Massa salarial professores ensino basico incluindo horas extras  (000 de Dbs)",null,{"$f":"D198/(1-D200)","v":86437.643436999992},{"$f":"E198/(1-E200)","v":93268.19710247824},{"$f":"F198/(1-F200)","v":97012.520146048686},100251.25709909612,103689.01457875222,107849.08629309908,127371.47718674403,122895.94746270466,118983.48620943194,120497.7848651653,122167.31560405191,123882.06681625746,125652.29419989811,{"$f":"Q198/(1-Q200)","v":127496.51968005153},{"$f":"R198/(1-R200)","v":130864.45370370365}]
[null,"              Remuneração anual media (com horas extras) em PIB / habitante",null,{"$f":"D203/D$15","v":1.9850108938274651},{"$f":"E203/E$15","v":1.9775659324815111},1.9671688605162414,1.9541401219425369,1.9386804980127801,1.9211641353332432,1.9015652971056278,1.8804167683783697,1.8577060941718508,1.8336742363697389,1.8083798642223561,1.7819778735702803,1.7544766403670826,{"$f":"Q203/Q$15","v":1.7259064209245962},{"$f":"R203/R$15","v":1.6963167410453819}]
[null,"              Remuneração anual media (com horas extras) (dobras)",null,{"$f":"(D201*10^3)/D166","v":77801.659259225911},{"$f":"(E201*10^3)/E166","v":80121.707010383034},82381.751946228658,84584.092106677272,86730.909661109807,88824.278120415329,90866.169016983651,92858.458097884999,94802.931072129446,96701.288949020804,98555.153001148661,100366.0693824535,102135.51342901314,103864.89366769357,105555.55555555553]
[null,"Massa salarial outros pessoal ensino basico  (000 de Dbs)",null,16848.907862628097,{"$f":"E205*E201","v":15127.178197708681},{"$f":"F205*F201","v":15643.501687120895},16071.750190855544,16525.644061841271,17087.533724179397,20061.211436852784,19241.068816779545,18516.94781142148,18639.621585587272,18783.322501058658,18930.802659339013,19083.492438970145,19244.031436707079,19629.668055555547]
[null,"Massa salarial outros pessoal em % das massa salarial professores em classe",0.15,{"$f":"D204/(D201+D204)","v":0.16312779980183892},{"$f":"D205+($C205-D205)/($C$5-D$5)","v":0.16219009981599328},0.16125239983014764,0.16031469984430199,0.15937699985845635,0.15843929987261071,0.15750159988676507,0.15656389990091943,0.15562619991507379,0.15468849992922815,0.1537507999433825,0.15281309995753689,0.15187539997169125,{"$f":"P205+($C205-P205)/($C$5-P$5)","v":0.15093769998584561},{"$f":"Q205+($C205-Q205)/($C$5-Q$5)","v":0.15}]
[null,"Massa salarial pessoal ensino basico total  (000 de Dbs)",null,{"$f":"D204+D201","v":103286.55129962809},{"$f":"E201/(1-E205)","v":111323.81830531474},{"$f":"F201/(1-F205)","v":115663.54422522694},119391.46377875988,123347.82008259722,128153.66292267888,151183.04933234866,145708.664175351,140913.2853215776,142548.37992275853,144363.28636514919,146227.55239729059,148153.1065078222,150161.5602034457,153958.18082788665]
[null,"Despesas administrativas e pedagógicas"]
[null,"Despesas administrativas e pedagogicas (000 dobras)",null,6789.5432129254496,{"$f":"E209*E206","v":7953.6245523815242},8924.214843628959,9893.6731437751569,10925.945025122333,12083.502446887027,15118.304933234867,14570.8664175351,14091.32853215776,14254.837992275854,14436.32863651492,14622.75523972906,14815.310650782221,15016.15602034457,15395.818082788666]
[null,"Despesas administrativas com % de despesas do pessoal total",0.1,{"$f":"D208/D206","v":6.5735017071384169E-2},{"$f":"IF(E$5<$C210, D209+($C209-$D209)/($C210-$D$5),$C209)","v":7.1445847559486811E-2},{"$f":"IF(F$5<$C210, E209+($C209-$D209)/($C210-$D$5),$C209)","v":7.7156678047589453E-2},{"$f":"IF(G$5<$C210, F209+($C209-$D209)/($C210-$D$5),$C209)","v":8.2867508535692094E-2},8.8578339023794736E-2,9.4289169511897378E-2,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1]
[null,"               Ano de referencia",2022]
[null,"Despesas administrativas e pedagógicas por aluno (Dobras)",null,{"$f":"+D208*10^3/D162","v":187.99266842744075},{"$f":"+E208*10^3/E162","v":216.95647987947419},247.31988735865716,281.18379851512037,318.86848149935435,361.49403372453742,462.54203577141408,456.17236968505273,450.69678078797227,451.04287093633206,451.62234978185739,452.31544084930266,453.1120441335392,453.98808208165354,456.4029912548167]
[null,"Despesas sociais"]
[null,"Despesas com fornecimento de comida na cantina escolar escolar excluindo (000 dobras)",null,649.96900000000005,{"$f":"($C$217*$C$216*E160)/10^3","v":9113.0400000000009},8813.5263274128956,8429.6657630308509,8082.3358032780516,7771.5324227399133,7495.2731384858653,7580.5545065634878,7680.9477326064862,7782.26469267007,7884.8768119317019,7988.3804659950465,8093.1438818875868,8201.4285760669027,8244.4698947368415]
[null,"Despesas do alimentaçao escolar escolar excluindo (000 dobras)",{"$f":"(3751440+5093760+1078000+98230)/1000","v":10021.43}]
[null,"Número de crianças beneficiárias (incluindo pré-escola)",{"$f":"D162+D63","v":45179}]
[null,"Custo unitário por criança beneficiário por dia escolar excluindo",2]
[null,"Número de dias / refeições por ano abrangidos pelo Estado",180]
[null,"Outras despesas socias (transport scolaire, etc.) (000  de Dbs)",null,null,{"$f":"(E219*E221)/1000","v":2180.0735250134303},{"$f":"(F219*F221)/1000","v":2633.3244651586083},3043.1877581649505,3426.4738157083916,3342.6561214271092,3268.52561800594,3194.1580388998605,3126.5651615086517,3160.4175369591485,3196.5487632505246,3232.8666941531419,3269.6792863038354,3307.610180313894,3373.2947368421055]
[null,"Número de beneficiários",null,null,{"$f":"$C$220*E162","v":3666},3608.3692819604457,3518.5786649237316,3426.4738157083916,3342.6561214271092,3268.52561800594,3194.1580388998605,3126.5651615086517,3160.4175369591485,3196.5487632505246,3232.8666941531419,3269.6792863038354,3307.610180313894,3373.2947368421055]
[null,"Número de crianças beneficiárias em% do total de alunos do EB",0.1]
[null,"Bolsa media por beneficiario (dobras)",1000,459.56483906653227,{"$f":"IF(E$5<$C222, D221+($C221-$D221)/($C222-$D$5),$C221)","v":594.67362929989918},{"$f":"IF(F$5<$C222, E221+($C221-$D221)/($C222-$D$5),$C221)","v":729.78241953326608},864.89120976663298,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000]
[null,"               Ano de referencia",2020]
[null,"Despesas para com crianças com NEE"]
[null,"Número de crianças com idade 6 anos e mais, NEE",null,341,{"$f":"E225*E162","v":749.7315332960269},1093.3585527149003,1412.7203821682449,1713.2369078541958,1671.3280607135546,1634.26280900297,1597.0790194499302,1563.2825807543259,1580.2087684795742,1598.2743816252623,1616.433347076571,1634.8396431519177,1653.805090156947,1686.6473684210528]
[null,"% de crianças com idade 6 anos e mais NEE",0.05,{"$f":"D224/(D121+D122)","v":1.0601255984579991E-2},{"$f":"IF(E$5<$C$227, D225+($C225-$D225)/($C$227-$D$5),$C225)","v":2.0450941988434994E-2},{"$f":"IF(F$5<$C$227, E225+($C225-$D225)/($C$227-$D$5),$C225)","v":3.0300627992289997E-2},4.0150313996145E-2,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05]
[null,"Subvenção média por criança NEE em% do PIB / habitante",0.01,0,{"$f":"IF(E$5<$C227, D226+($C226-$D226)/($C227-$D$5),$C226)","v":2.5000000000000001E-3},5.0000000000000001E-3,7.4999999999999997E-3,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[null,"Ano do meta intermediário",2020]
[null,"Subsídio anual por criança NEE (dobras)",null,null,{"$f":"E226*E15","v":101.28828790785731},209.39166331813868,324.63418752666803,447.37082644619483,462.34611862045801,477.84932316177117,493.81849630049891,510.32254978089935,527.36351436374832,544.9914310095993,563.22848263747039,582.14233851323149,601.79910340707499,622.26324247973446]
[null,"Despesas par com crianças com NEE (000 dobras)",null,0,{"$f":"(E228*E224)/1000","v":75.939023398087286},228.94016595608579,458.61733346755216,766.45221136485497,772.73204181236918,780.93137715052421,788.66715985783981,797.77835263861232,833.34444957379901,871.04584238793404,910.42130135854461,951.70937295859426,995.25842046650757,1049.5386603935954]
[null,"Custo por aluno de público"]
[null,"custo unitario em PIB / habitante",null,{"$f":"D232/D$15","v":7.8221159852025046E-2},{"$f":"E232/E$15","v":8.7960174459194684E-2},9.0173585771762862E-2,9.2722582586263952E-2,9.5602194608522692E-2,9.843262458662437E-2,0.1138679336001031,0.10894514127428777,0.10442117447122695,0.1011461975179979,9.801555676514391E-2,9.5001059311991098E-2,9.208848556090686E-2,8.926426028998212E-2,8.6714910594330397E-2]
[null,"custo unitario (dobras)",null,{"$f":"D233*1000/D162","v":3065.8451520808931},3563.7341900193069,3776.3194224220538,4013.4560351021569,4276.9632812084747,4550.9941923250444,5441.1715000638769,5379.9125843314205,5328.8480007272692,5334.0814187621208,5341.7638542638388,5350.7302485245073,5360.8606334568276,5371.9151808807001,5395.9501437768304]
[null,"Total despesas correntes ensino basico (000  de Dbs)",null,{"$f":"D206+D208+D213+D218+D229","v":110726.06351255353},{"$f":"E206+E208+E213+E218+E229","v":130646.49540610779},136263.55002738349,141216.6077771984,146549.02693807083,152124.08595554531,177846.08439922589,171842.91029820728,166609.90510048912,168579.24459423742,170752.08641923429,172981.97609852641,175282.94969975445,177682.01340063757,182021.30220264784]
[]
["X","Ensino basico 3° ciclo"]
[null,"População"]
[null,"População 12 anos",null,4951,5102,5228,5327,5481,5483,5485,5488,5494,4612,4699,4787,4875,4965,5056]
[null,"População 13 anos",null,4779,4948,5099,5225,5324,5478,5480,5483,5486,5492,4610,4698,4785,4874,4963]
[null,"População 14 anos",null,4594,4776,4945,5097,5222,5322,5475,5478,5480,5484,5490,4608,4696,4784,4872]
[null,"População escolarizável (12-14 anos)",null,{"$f":"SUM(D237:D239)","v":14324},{"$f":"SUM(E237:E239)","v":14826},15272,15649,16027,16283,16440,16449,16460,15588,14799,14093,14356,14623,14891]
[null,"Taxas de acesso, de sobrevivencia e de transiçao"]
[null,"    Taxa de transição Ensino basico 2° ciclo - ensino basico 3° ciclo (%)",1,{"$f":"D244/D132","v":0.99096873925502293},{"$f":"IF(E$5>$C243,$C242,D242+($C242-$D242)/($C243-$D$5))","v":0.99247394937918576},{"$f":"IF(F$5>=$C243,$C242,E242+($C242-$D242)/($C243-$D$5))","v":0.99397915950334859},{"$f":"IF(G$5>=$C243,$C242,F242+($C242-$D242)/($C243-$D$5))","v":0.99548436962751141},0.99698957975167424,0.99849478987583706,1,1,1,1,1,1,1,1,1]
[null,"                      Ano de referência",2022]
[null,"Taxa de acesso 7°a",null,{"$f":"E244","v":0.9175924055746314},0.9175924055746314,{"$f":"E132*F242","v":0.92037991909350214},0.92656097091157719,0.9364292331914269,0.95638362358596751,0.97278342481885716,0.98781298228752579,0.99786132815944983,1.004,1,1,1,1,1]
[null,"Taxa de acesso 8°a",null,{"$f":"E245","v":0.81209458045616234},0.81209458045616234,{"$f":"E244*F247","v":0.82967755130924048},{"$f":"F244*G247","v":0.84983437755299607},0.87329648949424599,0.9005413862276892,0.95638362358596751,0.97278342481885716,0.98781298228752579,0.99786132815944983,1.004,1,1,1,1]
[null,"Taxa de acesso 9°a",null,{"$f":"E246","v":0.79734436221158034},0.79734436221158034,{"$f":"E245*F249","v":0.79980273191901075},{"$f":"F245*G249","v":0.8196311640624353},0.84211653110855,0.86800920969446715,0.9005413862276892,0.95638362358596751,0.97278342481885716,0.98781298228752579,0.99786132815944983,1.004,1,1,1]
[null,"           Taxa de sobrevivência 7a-8a (%)",1,{"$f":"D245/D244","v":0.88502757381432084},{"$f":"E245/E244","v":0.88502757381432084},{"$f":"IF(F$5>=$C248,$C247,E247+($C247-$D247)/($C248-$D$5))","v":0.90418964484526732},{"$f":"IF(G$5>=$C248,$C247,F247+($C247-$D247)/($C248-$D$5))","v":0.9233517158762139},0.94251378690716048,0.96167585793810706,1,1,1,1,1,1,1,1,1]
[null,"                     Ano de referência",2022]
[null,"           Taxa de sobrevivência 8a-9a (%)",1,{"$f":"D246/D245","v":0.98183682221312618},{"$f":"E246/E245","v":0.98183682221312618},{"$f":"IF(F$5>=$C250,$C249,E249+($C249-$D249)/($C250-$D$5))","v":0.98486401851093852},{"$f":"IF(G$5>=$C250,$C249,F249+($C249-$D249)/($C250-$D$5))","v":0.98789121480875086},0.9909184111065632,0.99394560740437554,1,1,1,1,1,1,1,1,1]
[null,"                     Ano de referência",2022]
[null,"Repetentes"]
[null,"    Taxa de repetição 7a (%)",0.1,0.16758747697974216,0.14956944964432797,{"$f":"IF(F$5>=$C256,$C252,E252+($C252-$D252)/($C256-$D$5))","v":0.14474177271720354},{"$f":"IF(G$5>=$C256,$C252,F252+($C252-$D252)/($C256-$D$5))","v":0.1399140957900791},0.13508641886295467,0.13025874193583023,0.12543106500870579,0.12060338808158136,0.11577571115445692,0.11094803422733249,0.10612035730020805,0.10129268037308362,9.646500344595918E-2,9.1637326518834744E-2,{"$f":"IF(R$5>=$C256,$C252,Q252+($C252-$D252)/($C256-$D$5))","v":0.1}]
[null,"    Taxa de repetição 8a (%)",0.15,0.28634530439792588,0.26773584905660375,{"$f":"IF(F$5>=$C256,$C253,E253+($C253-$D253)/($C256-$D$5))","v":0.25799689874246617},{"$f":"IF(G$5>=$C256,$C253,F253+($C253-$D253)/($C256-$D$5))","v":0.2482579484283286},0.23851899811419103,0.22878004780005345,0.21904109748591588,0.20930214717177831,0.19956319685764073,0.18982424654350316,0.18008529622936559,0.17034634591522801,0.16060739560109044,0.15086844528695287,{"$f":"IF(R$5>=$C256,$C253,Q253+($C253-$D253)/($C256-$D$5))","v":0.15}]
[null,"    Taxa de repetição 9a (%)",0.2,0.35736800630417653,0.36106750392464676,{"$f":"IF(F$5>=$C256,$C254,E254+($C254-$D254)/($C256-$D$5))","v":0.34982693204577703},{"$f":"IF(G$5>=$C256,$C254,F254+($C254-$D254)/($C256-$D$5))","v":0.3385863601669073},0.32734578828803756,0.31610521640916783,0.3048646445302981,0.29362407265142837,0.28238350077255864,0.27114292889368891,0.25990235701481917,0.24866178513594941,0.23742121325707966,0.2261806413782099,{"$f":"IF(R$5>=$C256,$C254,Q254+($C254-$D254)/($C256-$D$5))","v":0.2}]
[null,"     % repetentes ensino basico 3° ciclo",null,0.26824922039075927,0.26186259541984735,{"$f":"(F252*E258+F253*E259+F254*E260)/F261","v":0.24185051920167097},0.23610871647324197,0.22814081504497621,0.22036213345648123,0.21172213617983118,0.20656776262923057,0.20204765441197917,0.20375745529031694,0.20040712663182858,0.19281471385175741,0.17110215761605491,0.15892684149286704,0.15081584470053172]
[null,"                     Ano de referência",2030]
[null,"Numero de alunos"]
[null,"    alunos 7a",null,5430,5342,{"$f":"F244*F237+F252*E258","v":5584.9567668761301},5717.2044681101288,5904.8853046264921,6013.0143391778784,6089.9358776071322,6155.5845468329398,6194.917315388986,5317.7618983432722,5263.3227926896207,5320.1360733402753,5388.2069446477417,5458.7608791377379,5601.8760879137735]
[null,"    alunos 8a",null,5207,5300,5597.9093974608877,5830.110125215705,6040.0225360292161,6315.0023582614449,6624.2273044308358,6720.2365164530893,6760.2539036922008,6763.5145179628462,5846.4495155189534,5693.9213115465091,5699.4858726050297,5733.8725725348731,5823.0808858802311]
[null,"    alunos 9a",null,5076,5733,5960.5823107579481,6195.8319123010206,6425.7120068812046,6650.7460985121252,6958.0414347807646,7282.1179537616463,7387.2031288292528,7420.1542875481773,7406.7742803427673,6468.2137146490695,6231.6911477380636,6193.4879006663086,6110.6975801332619]
[null,"    alunos 3° ciclo total",null,{"$f":"SUM(D258:D260)","v":15713},{"$f":"SUM(E258:E260)","v":16375},17143.448475094967,17743.146505626857,18370.619847536913,18978.76279595145,19672.204616818733,20157.939017047676,20342.374347910438,19501.430703854297,18516.54658855134,17482.271099535854,17319.383964990833,17386.12135233892,17535.654553927267]
[null,"Taxa bruta de escolarização  (TBE %)",null,{"$f":"D261/D240","v":1.0969701200781905},1.1044786186429245,1.122541152114652,1.1338198291026171,1.1462294782265499,1.1655568873027975,1.1966061202444485,1.2254811245089474,1.2358672143323475,1.2510540610632728,1.2512025534530267,1.2404932306489642,1.2064212848280045,1.1889572148217822,1.1776008699165446]
[null,"Privado"]
[null,"Numero de alunos",null,137,446,{"$f":"F265*F261","v":463.98043667974287},477.15832276259471,490.87202358318689,503.85661980655135,518.88183158125707,528.22559399575437,529.55870931644949,504.31180751482282,475.65670206069029,446.08021630019437,438.94417575629444,437.6443042466617,438.3913638481817]
[null,"     % alunos no privado",2.5000000000000001E-2,{"$f":"D264/D261","v":8.7188951823331008E-3},{"$f":"E264/E261","v":2.7236641221374047E-2},{"$f":"E265+($C265-E265)/($C$5-E$5)","v":2.7064591896652966E-2},2.6892542571931886E-2,2.6720493247210805E-2,2.6548443922489725E-2,2.6376394597768645E-2,2.6204345273047564E-2,2.6032295948326484E-2,2.5860246623605403E-2,2.5688197298884323E-2,2.5516147974163243E-2,2.5344098649442162E-2,2.5172049324721082E-2,2.5000000000000001E-2]
[null,"Publico"]
[null,"Numero alunos",null,{"$f":"D261-D264","v":15576},{"$f":"E261-E264","v":15929},16679.468038415223,17265.988182864261,17879.747823953727,18474.906176144897,19153.322785237477,19629.713423051922,19812.815638593987,18997.118896339474,18040.889886490651,17036.19088323566,16880.439789234541,16948.47704809226,17097.263190079084]
[null,"Numero turmas",null,{"$f":"D267/D269","v":288.44444444444446},{"$f":"E267/E269","v":318.58},{"$f":"F267/F269","v":345.43277002635079},370.74207754616515,398.59310435565635,428.22630209607382,462.32158447124948,494.27335957324993,521.38988522615762,523.54264674951321,521.84392233650658,518.4927660115203,542.03247029652209,575.91912299342653,569.90877300263617]
[null,"Alunos por turma",30,54,50,{"$f":"IF(F$5<$C270, E269+($C269-$D269)/($C270-$D$5),$C269)","v":48.285714285714285},{"$f":"IF(G$5<$C270, F269+($C269-$D269)/($C270-$D$5),$C269)","v":46.571428571428569},44.857142857142854,43.142857142857139,41.428571428571423,39.714285714285708,37.999999999999993,36.285714285714278,34.571428571428562,32.857142857142847,31.142857142857132,29.428571428571416,30]
[null,"Ano de referência",2030]
[null,"Numero professores en classe ",null,590,{"$f":"E268*E275","v":626.99812561657359},655.07450209369767,678.35259373702195,704.54215285546479,732.05781720794141,765.20870659857007,792.87752802087959,811.36725509062774,791.06355485883307,766.25021471638706,740.43884623692452,753.38233504985749,779.65979441657089,751.96296437847832]
[null,"Numero horas alunos por semana",23.75,{"$f":"4.75*5","v":23.75},{"$f":"D272+($C272-$D272)/($C$5-$E$5)","v":23.75},{"$f":"E272+($C272-$D272)/($C$5-$E$5)","v":23.75},23.75,23.75,23.75,23.75,23.75,23.75,23.75,23.75,23.75,23.75,23.75,23.75]
[null,"Numero horas professores em classe",18,{"$f":"D272/D275","v":11.611111111111111},{"$f":"IF(E$5<$C274, D273+($C273-$D273)/($C274-$D$5),$C273)","v":12.067460317460316},{"$f":"IF(F$5<$C274, E273+($C273-$D273)/($C274-$D$5),$C273)","v":12.523809523809522},12.980158730158728,13.436507936507933,13.892857142857139,14.349206349206344,14.80555555555555,15.261904761904756,15.718253968253961,16.174603174603167,16.630952380952372,17.087301587301578,17.543650793650784,18]
[null,"Ano de referência",2030]
[null,"Numero professores por turma",null,{"$f":"D271/D268","v":2.0454545454545454},{"$f":"E272/E273","v":1.9681025978296616},{"$f":"F272/F273","v":1.89638783269962},1.8297156832772856,1.7675723567631427,1.7095115681233939,1.6551438053097351,1.6041275797373364,1.5561622464898601,1.5109820752335275,1.4683513248282638,1.4280601288475312,1.3899210404087328,1.3537661162632897,1.3194444444444444]
[null,"Alunos por professor",null,{"$f":"D267/D271","v":26.4},25.405179615705929,25.461940565699958,25.452822532521775,25.377825516171374,25.236949516648753,25.030194533953917,24.757560568086873,24.41904761904761,24.014655686836122,23.544384771452421,23.008234872896505,22.406205991168381,21.738298126268027,22.736842105263154]
[null,"Necessidade de professores en classe por ensino basico 3° ciclo"]
[null,"    Taxa de atrito de professore por ano",1.4999999999999999E-2]
[null,"    Numero professores após atrito",null,null,{"$f":"D271*(1-$C278)","v":581.15},617.59315373232494,645.24838456229224,668.17730483096659,693.97402056263286,721.07694994982228,753.73057599959157,780.98436510056638,799.19674626426831,779.19760153595053,754.75646149564125,729.33226354337069,742.08160002410966,767.96489750032231]
[null,"    Novos professores",null,null,{"$f":"IF((E271-E279)>=0, (E271-E279), 0)","v":45.848125616573611},{"$f":"IF((F271-F279)>=0, (F271-F279), 0)","v":37.481348361372739},33.104209174729704,36.364848024498201,38.083796645308553,44.131756648747796,39.14695202128803,30.382889990061358,0,0,0,24.050071506486802,37.578194392461228,0]
[null,"Remuneração media professor (exclusão horas extras)"]
[null,"             Remuneração anual media em PIB / habitante",null,{"$f":"D283/D15","v":1.5082655815557375},{"$f":"E283/E15","v":1.5399922145058651},1.568130976521702,1.5929041237687351,1.614445734414675,1.6330413510655473,1.6486467590943898,1.661701924629813,1.6721846875881796,1.6802981948758937,1.6860859028201232,1.6896815521132793,1.6910832958925044,1.6903075901688092,1.6873887581977751]
[null,"             Remuneração anual media (dobras)",105000,59115.829144067786,{"$f":"D283+($C283-D283)/($C$5-D$5)","v":62393.269919491519},65670.710694915251,68948.151470338984,72225.592245762717,75503.033021186449,78780.473796610182,82057.914572033915,85335.355347457647,88612.79612288138,91890.236898305098,95167.677673728816,98445.118449152549,101722.55922457628,105000]
[null,"Massa salarial professores (exclusão horas extras) (000  de Dbs)",null,34878.339195,{"$f":"(E283*E271)/10^3","v":39120.463290610125},{"$f":"(F283*F271)/10^3","v":43019.208110610874},46771.15738327751,50885.974252090622,55272.585546068876,60283.50445912662,65061.876460422762,69238.313030450037,70098.353506947562,70410.913753665955,70465.845455783288,74166.813211482353,79308.989612560603,78956.111259740224]
[null,"Horas extras (000 dobras)",null,19476.224399999999,{"$f":"E286*E287","v":20141.007221326854},{"$f":"F286*F287","v":20376.300425825913},20328.924497793076,20234.772301187426,20036.988981197548,19839.214218305457,19341.886477893342,18483.711309372458,16684.580261075254,14812.221902301606,12960.626074557927,11764.174513304,10656.532454133063,8772.9012510822486]
[null,"Horas extras em % do massa salarial incluindo horas extras",0.1,{"$f":"D285/D287","v":0.358318108211094},{"$f":"D286+($C286-D286)/($C$5-D$5)","v":0.3398668147674444},0.32141552132379481,0.30296422788014526,0.28451293443649572,0.26606164099284613,0.24761034754919656,0.22915905410554699,0.21070776066189742,0.19225646721824785,0.17380517377459828,0.15535388033094871,0.13690258688729914,0.11845129344364957,0.1]
[null,"Massa salarial professores incluindo horas extras (000 Dbs)",null,54354.563595,{"$f":"E284/(1-E286)","v":59261.470511936976},63395.508536436791,67100.081881070582,71120.746553278048,75309.574527266421,80122.718677432073,84403.762938316111,87722.024339822499,86782.93376802282,85223.135655967562,83426.471530341209,85930.987724786362,89965.522066693666,87729.012510822475]
[null,"Remuneração media (com horas extras) em PIB / habitante",null,{"$f":"D289/D$15","v":2.3504879923460762},2.3328507776250449,2.3108854178050757,2.2852544840336204,2.256428958842418,2.2250388346981462,2.1912140255041455,2.1557001265697431,2.1185875196118329,2.0802372618065901,2.0407848721629813,2.0004609182071769,1.9593191570273973,1.9174296072326675,1.8748763979975278]
[null,"Remuneração media (com horas extras) (dobras)",null,{"$f":"D287*10^3/D271","v":92126.378974576262},{"$f":"E287*10^3/E271","v":94516.184484061727},96776.028274367331,98916.231028790586,100946.04881344594,102873.80690024748,104707.01389897359,106452.45949774657,108116.29849423017,109704.12330967443,111221.02678628454,112671.65675373889,114060.26359657025,115390.74184787992,116666.66666666667]
[null,"Massa salarial outros pessoal ensino secundario geral (000 Dbs)",null,4728.9280204426013,{"$f":"E291*E287","v":4999.2103257473727},{"$f":"F291*F287","v":5180.3996620477601},5305.7778860170483,5435.7327502136068,5556.8428843073216,5700.2273470137234,5781.7206415949877,5777.1779050135292,5485.967350899291,5162.1233544462184,4832.8029517549785,4750.7743265257786,4736.0517007679537,4386.4506255411243]
[null,"              Massa salarial outros pessoal em % das massa salarial professores em classe",0.05,{"$f":"D290/D287","v":8.7001489988553768E-2},{"$f":"D291+($C291-D291)/($C$5-D$5)","v":8.4358526417942781E-2},8.1715562847331794E-2,7.9072599276720806E-2,7.6429635706109819E-2,7.3786672135498832E-2,7.1143708564887845E-2,6.8500744994276858E-2,6.5857781423665884E-2,6.3214817853054911E-2,6.0571854282443931E-2,5.792889071183295E-2,5.528592714122197E-2,5.264296357061099E-2,0.05]
[null,"Despesas administrativas e pedagogicas (000 dobras)",null,3906.020900479481,{"$f":"E293*(E290+E287)","v":4611.249570191615},{"$f":"F293*(F290+F287)","v":5308.2411875492417},6013.6755884232534,6790.8197700302599,7629.8838309327712,8582.294602444581,9018.5483579911106,9349.9202244836033,9226.8901118922113,9038.5259010413774,8825.9274482096189,9068.1762051312144,9470.1573767461632,9211.5463136363596]
[null,"Despesas administrativas e pedagogicas com % de despesas do pessoal total",0.1,{"$f":"+D292/(D290+D287)","v":6.6110190743340694E-2},{"$f":"IF(E$5<$C294, D293+($C293-$D293)/($C294-$D$5),$C293)","v":7.1758492286117248E-2},{"$f":"IF(F$5<$C294, E293+($C293-$D293)/($C294-$D$5),$C293)","v":7.7406793828893802E-2},{"$f":"IF(G$5<$C294, F293+($C293-$D293)/($C294-$D$5),$C293)","v":8.3055095371670357E-2},8.8703396914446911E-2,9.4351698457223465E-2,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1]
[null,"              Ano de arranque",2022]
[null,"Despesas administrativas e pedagógicas por aluno (Dobras)",null,{"$f":"D292*10^3/D261","v":248.58530519184632},{"$f":"E292*10^3/E261","v":281.60302718727422},309.63672188012549,338.9294895646691,369.65653997465722,402.02219254041034,436.2650129770995,447.39436657507872,459.62777326649797,473.13913794379164,488.13237705079621,504.85016494475616,523.58537829414149,544.69638079870879,525.30381944444446]
[null,"Despesas sociais"]
[]
[null,"Outras despesas socias (transport scolaire, etc.) (000  de Dbs)",null,null,{"$f":"(E299*E301)/1000","v":960.26179763741175},{"$f":"(F299*F301)/1000","v":1226.3175458346479},1498.0194195792265,1787.9747823953728,1847.4906176144898,1915.3322785237478,1962.9713423051924,1981.2815638593988,1899.7118896339475,1804.0889886490652,1703.6190883235661,1688.0439789234542,1694.8477048092261,1709.7263190079084]
[null,"Número de beneficiários",null,{"$f":"$C$300*D267","v":1557.6000000000001},1592.9,1667.9468038415225,1726.5988182864262,1787.9747823953728,1847.4906176144898,1915.3322785237478,1962.9713423051924,1981.2815638593988,1899.7118896339475,1804.0889886490652,1703.6190883235661,1688.0439789234542,1694.8477048092261,1709.7263190079084]
[null,"Número de crianças beneficiárias em% do total de alunos do EB 3",0.1]
[null,"Bolsa media por beneficiario (dobras)",1000,470.45162712655053,{"$f":"IF(E$5<$C302, D301+($C301-$D301)/($C302-$D$5),$C301)","v":602.83872034491287},{"$f":"IF(F$5<$C302, E301+($C301-$D301)/($C302-$D$5),$C301)","v":735.22581356327521},867.61290678163755,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000]
[null,"              Ano de arranque",2020]
[null,"Despesas para com crianças com NEE"]
[null,"Número de crianças com idade 6 e mais , NEE",null,341,{"$f":"E305*E261","v":473.55667372881362},616.24401651294772,762.47914185550451,918.53099237684569,948.9381397975726,983.61023084093677,1007.8969508523838,1017.1187173955219,975.07153519271492,925.82732942756707,874.11355497679278,865.96919824954171,869.30606761694605,876.78272769636339]
[null,"% de crianças com idade 6 anos e mais NEE",0.05,{"$f":"D304/D267","v":2.1892655367231638E-2},{"$f":"IF(E$5<$C$307, D305+($C305-$D305)/($C$307-$D$5),$C305)","v":2.8919491525423731E-2},{"$f":"IF(F$5<$C$307, E305+($C305-$D305)/($C$307-$D$5),$C305)","v":3.5946327683615824E-2},4.2973163841807917E-2,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05]
[null,"Subvenção média por criança NEE em% do PIB / habitante",0.01,0,{"$f":"IF(E$5<$C$307, D306+($C306-$D306)/($C$307-$D$5),$C306)","v":2.5000000000000001E-3},5.0000000000000001E-3,7.4999999999999997E-3,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[null,"Ano do meta intermediário",2020]
[null,"Subsídio anual por criança NEE (dobras)",null,null,{"$f":"E306*E15","v":101.28828790785731},{"$f":"F306*F15","v":209.39166331813868},324.63418752666803,447.37082644619483,462.34611862045801,477.84932316177117,493.81849630049891,510.32254978089935,527.36351436374832,544.9914310095993,563.22848263747039,582.14233851323149,601.79910340707499,622.26324247973446]
[null,"Despesas par com crianças com NEE (000 dobras)",null,0,{"$f":"(E308*E304)/1000","v":47.965744709331325},{"$f":"(F308*F304)/1000","v":129.03635962749664},247.52679672229274,410.92396917607294,438.73786574632527,470.01748306233509,497.71815669578206,519.05861729116077,514.21715155528545,504.56796113252545,492.32565122242409,504.11733414941637,523.14761207820823,545.58966308656522]
[null,"Custo por aluno de público"]
[null,"custo unitario em PIB / habitante",null,{"$f":"D312/D$15","v":0.10317781917246803},{"$f":"E312/E$15","v":0.10827947567551534},0.10771454267451426,0.10726568463147818,0.10694775257707935,0.10628031254730322,0.10575430024466161,0.10487910268590464,0.10419367766184204,0.10371900814932895,0.10346937821674844,0.10346886327658238,0.10373865921773613,0.10430796589709608,9.7360974448667023E-2]
[null,"custo unitario (dobras)",null,{"$f":"D313*1000/D267","v":4044.0108189472321},4386.9770826933718,4510.905450833834,4642.9477839775627,4784.5304456971153,4913.8289992014807,5053.4620793358281,5179.1240781699044,5317.2383255440363,5469.7620643952368,5638.9924500019188,5827.661086349337,6039.0665671240113,6277.2440355088174,6058.4155651414112]
[null,"Total despesas correntes ensino basico (000 de Dbs)",null,{"$f":"D287+D290+D292+D298+D309","v":62989.512515922084},{"$f":"E287+E290+E292+E298+E309","v":69880.15795022271},75239.503291495945,80165.081571812407,85546.197825093346,90782.529725867324,96790.59038847647,101664.72143690319,105349.46265047019,103909.72027200356,101732.44186123674,99281.146669851791,101942.09956951621,106389.72646109523,103582.32543209443]
[]
["X","Ensino secundario geral e profissional qualificante"]
[null,"População"]
[null,"População 15 anos",null,4250,4411,4591,4773,4942,5094,5219,5319,5473,5475,5478,5482,5488,4607,4695]
[null,"População 16 anos",null,4115,4247,4408,4588,4770,4939,5091,5216,5316,5470,5472,5475,5479,5486,4605]
[null,"População 17 anos",null,4002,4112,4244,4405,4584,4767,4936,5087,5213,5313,5467,5469,5473,5477,5483]
[null,"População 15-17 anos",null,{"$f":"SUM(D317:D319)","v":12367},{"$f":"SUM(E317:E319)","v":12770},13243,13766,14296,14800,15246,15622,16002,16258,16417,16426,16440,15570,14783]
[null,"Numero de alunos (geral e profissional qualificante)",null,7456,8645,{"$f":"F335+F345","v":9433.6840190290204},{"$f":"G335+G345","v":10061.633664884497},10874.695994255377,11848.836990464739,12872.80025664678,13970.602747686826,15331.009905421421,16475.482559039119,17309.014661447298,17874.680891766155,17931.231975006423,17175.951972302497,16428.766291345626]
[null,"curso geral (10°a, 11°a e 12°a)"]
[null,"Taxas de acesso, de sobrevivencia e de transiçao"]
[null,"    Taxa de transição 1° ciclo geral (9° ano) - 2° ciclo geral (10° ano)",0.75,{"$f":"D326/D246","v":0.61556641243787014},{"$f":"E326/E246","v":0.61556641243787014},{"$f":"IF(F$5<$C325, E324+($C324-$D324)/($C325-$D$5),$C324)","v":0.62900977119408308},0.64245312995029602,0.65589648870650896,0.6693398474627219,0.68278320621893485,0.69622656497514779,0.70966992373136073,0.72311328248757367,0.75,0.75,0.75,0.75,0.75]
[null,"Ano de referência",2026]
[null,"Taxa de acesso 10°a geral",null,{"$f":"E326","v":0.49081840852414421},0.49081840852414421,{"$f":"F324*E246","v":0.50153739483759829},0.51383576846416601,0.53759320254297993,0.56366215047803336,0.59266211122275203,0.62698083595126186,0.67871669320817596,0.70343261547026759,0.74085973671564431,0.7483959961195874,0.753,0.75,0.75]
[null,"Taxa de acesso 11°a geral",null,{"$f":"E327","v":0.49},0.49,{"$f":"E326*F329","v":0.49008184085241441},0.50086836943515445,0.51323601650716422,0.53705536102948892,0.56319221505927453,0.59226682065064784,0.62666720073401694,0.67849034981210377,0.70343261547026759,0.74085973671564431,0.7483959961195874,0.753,0.75]
[null,"Taxa de acesso 12°a geral",null,{"$f":"E328","v":0.40515564202334631},0.40515564202334631,0.41303206364967959,0.42165447045209425,0.43967661581837075,0.45949082324020446,0.49018909930123944,0.5238745347312217,0.56125623904912014,0.60479269677985403,0.67849034981210377,0.70343261547026759,0.74085973671564431,0.7483959961195874,0.753]
[null,"    Taxa de sobrevivência 10° - 11° ciclo geral (%)",1,{"$f":"D327/D326","v":0.99833256351039257},{"$f":"E327/E326","v":0.99833256351039257},{"$f":"IF(F$5<$C331, E329+($C329-$D329)/($C331-$D$5),$C329)","v":0.99849930715935331},{"$f":"IF(G$5<$C331, F329+($C329-$D329)/($C331-$D$5),$C329)","v":0.99866605080831405},0.9988327944572748,0.99899953810623554,0.99916628175519628,0.99933302540415703,0.99949976905311777,0.99966651270207851,1,1,1,1,1]
[null,"    Taxa de sobrevivência 11° - 12° ciclo geral (%)",1,{"$f":"D328/D326","v":0.82546953208544127},{"$f":"E328/E326","v":0.82546953208544127},{"$f":"IF(F$5<$C331, E330+($C330-$D330)/($C331-$D$5),$C330)","v":0.84292257887689714},{"$f":"IF(G$5<$C331, F330+($C330-$D330)/($C331-$D$5),$C330)","v":0.86037562566835302},0.87782867245980889,0.89528171925126476,0.91273476604272064,0.93018781283417651,0.94764085962563238,0.96509390641708825,1,1,1,1,1]
[null,"Ano de referência",2026]
[null,"TBE 2° ciclo geral (%)",null,{"$f":"D335/D320","v":0.60289480067922696},0.67697729052466715,0.65506736773162655,0.66351485635422724,0.68023392160422069,0.70544113490423488,0.73348245962791192,0.76616517674754869,0.81237001533293385,0.85177548722899865,0.88178320814584554,0.90070047944404064,0.89959913716705875,0.89226318750171518,0.88235294117647056]
[null,"TBE 2° ciclo geral (verificaçao) (%)",null,{"$f":"(D326+D327)/2/(1-D334)","v":0.65464383750759225},0.65464383750759225,0.65506736773162655,0.66351485635422724,0.68023392160422069,0.70544113490423488,0.73348245962791192,0.76616517674754869,0.81237001533293385,0.85177548722899865,0.88178320814584554,0.90070047944404064,0.89959913716705875,0.89226318750171518,0.88235294117647056]
[null,"% repetentes 2° ciclo geral ",0.15,{"$f":"E334","v":0.25087631447170755},0.25087631447170755,{"$f":"E334+($C334-E334)/($C$5-E$5)","v":0.24311659797388388},0.23535688147606021,0.22759716497823657,0.21983744848041292,0.21207773198258925,0.20431801548476558,0.19655829898694194,0.18879858248911829,0.18103886599129462,0.17327914949347095,0.16551943299564731,0.15775971649782367,0.15]
[null,"Numero alunos 2° ciclo geral",null,{"$f":"D321","v":7456},{"$f":"E321","v":8645},{"$f":"F333*F320","v":8675.0571508699304},9133.9455125722925,9724.6241432539391,10440.528796582676,11182.673579487146,11969.032391150206,12999.544985357608,13848.165871369059,14476.234928130347,14794.906075347812,14789.409815026445,13892.537829401705,13043.823529411764]
[null,"Privado"]
[null,"Numero de alunos",null,104,281,{"$f":"F338*F335","v":283.64237336083886},{"$f":"G338*G335","v":300.39981052893251},321.6930933218735,347.37971552308227,374.21931306004996,402.83193102198771,440.0106251984248,471.39336528459728,495.55197855256358,509.30099994662851,511.95097867725013,483.57181772333075,456.53382352941179]
[null,"     % alunos no privado",3.5000000000000003E-2,{"$f":"D337/D335","v":1.3948497854077254E-2},{"$f":"E337/E335","v":3.2504337767495665E-2},{"$f":"E338+($C338-E338)/($C$5-E$5)","v":3.2696311785380613E-2},{"$f":"F338+($C338-F338)/($C$5-F$5)","v":3.2888285803265561E-2},3.3080259821150509E-2,3.3272233839035457E-2,3.3464207856920405E-2,3.3656181874805353E-2,3.3848155892690301E-2,3.4040129910575249E-2,3.4232103928460197E-2,3.4424077946345152E-2,3.46160519642301E-2,3.4808025982115048E-2,3.5000000000000003E-2]
[null,"Publico"]
[null,"Numero alunos",null,{"$f":"D335-D337","v":7352},{"$f":"E335-E337","v":8364},8391.4147775090914,8833.5457020433605,9402.9310499320654,10093.149081059593,10808.454266427096,11566.200460128217,12559.534360159183,13376.772506084462,13980.682949577784,14285.605075401183,14277.458836349195,13408.966011678374,12587.289705882353]
[null,"Numero turmas",null,{"$f":"D340/D342","v":136.14814814814815},164,171.50336771551426,188.52079242165706,209.95380334776539,236.29446009169612,265.93736332158051,299.8644563736944,344.09683178518299,388.5369607576398,432.07408674191799,471.69450720664258,506.03651571870535,512.9112682062763,503.4915882352941]
[null,"Alunos por turma",25,54,51,{"$f":"IF(F$5<$C343, E342+($C342-$D342)/($C343-$D$5),$C342)","v":48.928571428571431},{"$f":"IF(G$5<$C343, F342+($C342-$D342)/($C343-$D$5),$C342)","v":46.857142857142861},44.785714285714292,42.714285714285722,40.642857142857153,38.571428571428584,36.500000000000014,34.428571428571445,32.357142857142875,30.285714285714302,28.21428571428573,26.142857142857157,25]
[null,"Ano de referência",2030]
[null,"curso profissionalmente qualificante (10°, 11°a, 12°a)"]
[null,"Numero de alunos profissionalmente qualificante",null,520,657,{"$f":"E345/3*2+F348*F346","v":758.62686815908944},{"$f":"F345/3*2+G348*G346","v":927.68815231220401},1150.0718510014372,1408.3081938820628,1690.1266771596338,2001.5703565366202,2331.4649200638123,2627.3166876700616,2832.7797333169492,3079.7748164183431,3141.8221599799781,3283.4141429007932,3384.9427619338621]
[null,"Novo ingresso potencial em 10°a profissionalmente qualificante",null,null,{"$f":"E347*D246*D239","v":1408.1802312400819},1412.7740761781386,1414.1066342842075,1437.5474898646644,1454.0887756525578,1465.3972580664679,1497.7440127634393,1521.0594446095422,1476.0424352302705,1354.2915987161978,1369.5646728988449,1156.6079999999999,1174,1196]
[null,"% novo ingresso potencial em 10°a profissionalmente qualificante",null,{"$f":"1-D324","v":0.38443358756212986},0.38443358756212986,0.37099022880591692,0.35754687004970398,0.34410351129349104,0.3306601525372781,0.31721679378106515,0.30377343502485221,0.29033007626863927,0.27688671751242633,0.25,0.25,0.25,0.25,0.25]
[null,"% real de novos ingresso portencial que entram em qualificação profissional",1,null,{"$f":"(E345/3)/E346","v":0.15551986538480422},{"$f":"IF(F$5<$C349, E348+($C348-$D348)/($C349-$D$5),$C348)","v":0.22694843681337565},{"$f":"IF(G$5<$C349, F348+($C348-$D348)/($C349-$D$5),$C348)","v":0.29837700824194707},0.36980557967051852,0.44123415109908992,0.51266272252766132,0.58409129395623272,0.65551986538480411,0.72694843681337551,0.79837700824194691,0.8698055796705183,0.9412341510990897,1.0126627225276612,1]
[null,"Ano de referência",2030]
[null,"% de alunos 2° ciclo em curso  profissionalmente qualificante",null,{"$f":"D345/D321","v":6.974248927038626E-2},7.5997686524002309E-2,8.0416819837174552E-2,9.2200549454495906E-2,0.10575668980622259,0.1188562383814874,0.13129440708030474,0.14327015037830268,0.15207510362636639,0.15946826918454104,0.16365921392547284,0.17229817052773341,0.17521507525858956,0.19116344457620418,0.20603755034953466]
[null,"Numero turmas",null,14,{"$f":"E345/E352","v":18.111392405063292},21.425196852908002,26.857736758226292,34.153648908527529,42.928212441817166,52.917704268895896,64.418356302328021,77.190392623734354,89.557229701449089,99.502657299305071,111.57779371866832,117.51853880841148,126.93277554409387,135.39771047735448]
[null,"Alunos por turma",25,{"$f":"D345/D351","v":37.142857142857146},{"$f":"IF(E$5<$C353, D352+($C352-$D352)/($C353-$D$5),$C352)","v":36.275510204081634},{"$f":"IF(F$5<$C353, E352+($C352-$D352)/($C353-$D$5),$C352)","v":35.408163265306122},{"$f":"IF(G$5<$C353, F352+($C352-$D352)/($C353-$D$5),$C352)","v":34.54081632653061},33.673469387755098,32.806122448979586,31.938775510204074,31.071428571428562,30.20408163265305,29.336734693877538,28.469387755102026,27.602040816326515,26.734693877551003,25.867346938775491,25]
[null,"Ano de referência",2030]
[null,"Professores secundario 2° ciclo geral e profissionalmente qualificante publico"]
[null,"Numero professores en classe ",null,291,{"$f":"E341*E359","v":307.54624314073982},311.52226241954725,332.01188461390456,358.8380321474948,392.27225042230953,429.17090617641009,470.79369943475132,525.96983823636208,578.61557909546832,627.3087146722728,668.07108387473693,699.58853316234558,692.54813296823033,664.32917892156854]
[null,"Numero horas alunos por semana",23.75,{"$f":"4.75*5","v":23.75},{"$f":"D356+($C356-$D356)/($C$5-$E$5)","v":23.75},{"$f":"E356+($C356-$D356)/($C$5-$E$5)","v":23.75},23.75,23.75,23.75,23.75,23.75,23.75,23.75,23.75,23.75,23.75,23.75,23.75]
[null,"Numero horas professores em classe",18,{"$f":"D356/D359","v":12.254359170166731},{"$f":"IF(E$5<$C358, D357+($C357-$D357)/($C358-$D$5),$C357)","v":12.664762086583394},{"$f":"IF(F$5<$C358, E357+($C357-$D357)/($C358-$D$5),$C357)","v":13.075165003000055},13.485567919416717,13.895970835833378,14.306373752250039,14.7167766686667,15.127179585083361,15.537582501500022,15.947985417916684,16.358388334333345,16.768791250750006,17.179194167166667,17.589597083583328,18]
[null,"Ano de referência",2030]
[null,"Numero professores por turma",null,{"$f":"D355/(D341+D351)","v":1.9380858411445485},{"$f":"E356/E357","v":1.8752819703703647},{"$f":"F356/F357","v":1.8164206719036156},1.7611419957927323,1.7091285150625211,1.6600992264908998,1.6138044719103348,1.5700216862249357,1.5285518192876619,1.489216310250584,1.4518545173642186,1.4163215251986485,1.3824862661714152,1.3502299050480402,1.3194444444444444]
[null,"Alunos por professor",null,{"$f":"(D340+D345)/D355","v":27.051546391752577},29.332174270364263,29.372031310382649,29.400254348445596,29.408819454778012,29.320088949854352,29.122619366116133,28.818930314816658,28.311507994744041,27.659278062946761,26.802533249802934,25.993311656451706,24.899323203010358,24.10284478428434,24.042647793590163]
[null,"Necessidade de professores en classe por ensino basico 3° ciclo"]
[null,"    Taxa de atrito de professore por ano",1.4999999999999999E-2]
[null,"    Numero professores após atrito",null,null,{"$f":"D355*(1-$C362)","v":286.63499999999999},302.93304949362874,306.84942848325403,327.03170634469598,353.45546166528237,386.38816666597489,422.73334258376394,463.73179394323006,518.08029066281665,569.93634540903633,617.89908395218868,658.05001761661583,689.09470516491035,682.15991097370681]
[null,"    Novos professores",null,null,{"$f":"IF((E355-E363)>=0, (E355-E363), 0)","v":20.911243140739828},{"$f":"IF((F355-F363)>=0, (F355-F363), 0)","v":8.5892129259185026},25.162456130650526,31.806325802798824,38.816788757027155,42.782739510435192,48.060356850987375,62.23804429313202,60.535288432651669,57.372369263236465,50.171999922548252,41.538515545729751,3.4534278033199826,0]
[null,"Remuneração media professor (exclusão horas extras)"]
[null,"             Remuneração anual media em PIB / habitante",null,{"$f":"D367/D15","v":1.4898728754939523},{"$f":"E367/E15","v":1.5234700215404202},1.5533761053154904,1.5798182341086011,1.6029357191533753,1.6230178635759187,1.6400260583165207,1.6544027417217146,1.6661305811701106,1.6754161307023141,1.6823065809835813,1.6869388401241356,1.6893142285358822,1.6894519483091412,1.6873887581977751]
[null,"             Remuneração anual media (dobras)",105000,58394.93483848797,{"$f":"D367+($C367-D367)/($C$5-D$5)","v":61723.868064310256},65052.801290132542,68381.734515954828,71710.667741777113,75039.600967599399,78368.534193421685,81697.467419243971,85026.400645066256,88355.333870888542,91684.267096710828,95013.200322533114,98342.133548355414,101671.06677417771,105000]
[null,"Massa salarial professores (exclusão horas extras) (000  de Dbs)",null,{"$f":"(D367*D355)/10^3","v":16992.926037999998},{"$f":"(E367*E355)/10^3","v":18982.943735293306},{"$f":"(F367*F355)/10^3","v":20265.39583463133},22703.548549809846,25732.514896442135,29435.953142352333,33633.494835507765,38462.652920755936,44721.32219310561,51123.772673877618,57514.339748107021,63475.571721882203,68799.028957149465,70412.107471345051,69754.563786764702]
[null,"Horas extras (000 dobras)",null,13231.5468,{"$f":"E370*E371","v":13791.019504549668},{"$f":"F370*F371","v":13725.992654856811},14322.601535014661,15102.372982788091,16049.983816025038,17009.593394992957,18007.723511684373,19340.526545704506,20370.005597697545,21050.291550605129,21266.08770125766,21013.18267262408,19512.117629833767,17438.640946691175]
[null,"Horas extras em % do massa salarial incluindo horas extras",0.2,{"$f":"D369/D371","v":0.43777593312941149},{"$f":"D370+($C370-D370)/($C$5-D$5)","v":0.4207919379058821},0.40380794268235271,0.38682394745882331,0.36983995223529392,0.35285595701176453,0.33587196178823514,0.31888796656470575,0.30190397134117636,0.28491997611764697,0.26793598089411758,0.25095198567058818,0.23396799044705879,0.2169839952235294,0.2]
[null,"Massa salarial professores incluindo horas extras (000 Dbs)",null,{"$f":"D369+D368","v":30224.472837999998},{"$f":"E368/(1-E370)","v":32773.963239842975},33991.388489488141,37026.150084824505,40834.887879230228,45485.936958377373,50643.088230500718,56470.376432440309,64061.84873881012,71493.778271575167,78564.631298712149,84741.659423139863,89812.211629773548,89924.225101178818,87193.204733455874]
[null,"Remuneração anual media (com horas extras) em PIB / habitante",null,{"$f":"D373/D$15","v":2.6499628231619043},2.6302638399616494,2.6054961421397493,2.5764512941452669,2.54369620041652,2.5079700279423323,2.4694425832893079,2.4289730037178723,2.3866782115507337,2.3429771140942375,2.2980320533145342,2.2521104226334203,2.2052789014936485,2.1576212210265524,2.1092359477472189]
[null,"Remuneração anual media (com horas extras) (dobras)",null,{"$f":"D371*10^3/D355","v":103864.16782817869},106565.96843826474,109113.83419432712,111520.55634358415,113797.54714083842,115955.0208035579,118002.14670116514,119947.17962504658,121797.5710425087,123560.06449625701,125240.77772418156,126845.27360718534,128378.6216789403,129845.45163058575,131250]
[null,"Massa salarial outros pessoal ensino secundario geral (000 Dbs)",null,3110.2201750877707,{"$f":"E375*E371","v":3365.7746860751859},3483.7492561490494,3787.0990879420942,4168.1929989250275,4633.5104310526604,5148.3483892946279,5729.0335847142242,6485.9153489904202,7223.5279521432421,7921.650085951539,8526.900080497493,9018.4808343982459,9011.0755808932663,8719.3204733455877]
[null,"              Massa salarial outros pessoal em % das massa salarial professores em classe",0.1,{"$f":"D374/D371","v":0.10290403381915789},{"$f":"D375+($C375-D375)/($C$5-D$5)","v":0.10269660283207518},0.10248917184499248,0.10228174085790978,0.10207430987082708,0.10186687888374438,0.10165944789666168,0.10145201690957897,0.10124458592249626,0.10103715493541354,0.10082972394833084,0.10062229296124814,0.10041486197416542,0.10020743098708271,0.1]
[null,"Despesas administrativas (000 dobras)",null,2203.7629134659387,{"$f":"E377*(E374+E371)","v":2593.3331051792975},2900.830261185934,3389.7483024718763,3991.9261455079618,4728.8549869301778,5579.143661979535,6219.9410017154541,7054.7764087800551,7871.7306223718406,8648.6281384663689,9326.8559503637352,9883.0692464171807,9893.5300682072102,9591.2525206801474]
[null,"Despesas administrativas com % de despesas do pessoal total",0.1,{"$f":"+D376/(D374+D371)","v":6.6110190743340694E-2},{"$f":"IF(E$5<$C378, D377+($C377-$D377)/($C378-$D$5),$C377)","v":7.1758492286117248E-2},{"$f":"IF(F$5<$C378, E377+($C377-$D377)/($C378-$D$5),$C377)","v":7.7406793828893802E-2},{"$f":"IF(G$5<$C378, F377+($C377-$D377)/($C378-$D$5),$C377)","v":8.3055095371670357E-2},8.8703396914446911E-2,9.4351698457223465E-2,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1]
[null,"Ano de referência",2022]
[null,"Despesas administrativas e pedagógicas por aluno (Dobras)",null,{"$f":"D376*10^3/D321","v":295.56906028244885},299.98069464190831,307.49707699924716,336.89840192674006,367.08393021898917,399.09866181260554,433.40559557729352,445.21636711381814,460.16384127997424,477.78452583491031,499.66033928722851,521.79146619954963,551.16509898442939,576.01058061650758,583.80844614806199]
[null,"Despesas sociais"]
[null,"Outras despesas socias (transport scolaire, etc.) (000  de Dbs)",null,null,{"$f":"(E382*E384)/1000","v":209.10000000000002},{"$f":"(F382*F384)/1000","v":419.57073887545459},662.51592765325211,940.29310499320661,1009.3149081059594,1080.8454266427093,1156.6200460128218,1255.9534360159184,1337.6772506084462,1398.0682949577786,1428.5605075401184,1427.7458836349197,1340.8966011678376,1258.7289705882354]
[null,"Número do beneficiários",null,{"$f":"$C$383*D340","v":735.2},836.40000000000009,839.14147775090919,883.35457020433614,940.29310499320661,1009.3149081059594,1080.8454266427095,1156.6200460128218,1255.9534360159184,1337.6772506084462,1398.0682949577786,1428.5605075401184,1427.7458836349197,1340.8966011678376,1258.7289705882354]
[null,"Número de crianças beneficiárias em% do total de alunos do ensino secundário",0.1]
[null,"Bolsa media por beneficiario (dobras)",1000,0,{"$f":"IF(E$5<$C385, D384+($C384-$D384)/($C385-$D$5),$C384)","v":250},{"$f":"IF(F$5<$C385, E384+($C384-$D384)/($C385-$D$5),$C384)","v":500},{"$f":"IF(G$5<$C385, F384+($C384-$D384)/($C385-$D$5),$C384)","v":750},1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000]
[null,"              Ano de arranque",2020]
[null,"Despesas para com crianças com NEE"]
[null,"Número de crianças entre os 15 e os 17 anos de idade, NEE",null,221,{"$f":"E388*E321","v":256.24053607723573},331.32767795854772,408.53475540455457,543.7347997127689,592.44184952323701,643.64001283233904,698.53013738434129,766.5504952710711,823.77412795195596,865.45073307236498,893.73404458830782,896.5615987503212,858.79759861512491,821.4383145672814]
[null,"% de crianças com 6 anos ou mais com NEE",0.05,{"$f":"D387/(D340+D345)","v":2.8074186991869917E-2},{"$f":"D388+($C388-D388)/($C$5-D$5)","v":2.9640316492450636E-2},{"$f":"IF(F$5<$C$390, E388+($C388-$D388)/($C$390-$D$5),$C388)","v":3.512176974448316E-2},{"$f":"IF(G$5<$C$390, F388+($C388-$D388)/($C$390-$D$5),$C388)","v":4.0603222996515684E-2},0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05]
[null,"Subvenção média por criança NEE em% do PIB / habitante",0.01,0,{"$f":"IF(E$5<$C390, D389+($C389-$D389)/($C390-$D$5),$C389)","v":2.5000000000000001E-3},{"$f":"IF(F$5<$C$390, E389+($C389-$D389)/($C$390-$D$5),$C389)","v":5.0000000000000001E-3},7.4999999999999997E-3,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[null,"              Ano de arranque",2020]
[null,"Subsídio anual por criança NEE (dobras)",null,null,{"$f":"E389*E15","v":101.28828790785731},209.39166331813868,324.63418752666803,447.37082644619483,462.34611862045801,477.84932316177117,493.81849630049891,510.32254978089935,527.36351436374832,544.9914310095993,563.22848263747039,582.14233851323149,601.79910340707499,622.26324247973446]
[null,"Despesas par com crianças com NEE (000 dobras)",null,0,{"$f":"(E391*E387)/1000","v":25.954165191854749},69.377253591076908,132.62434839716363,243.25108671505762,273.91318963539408,307.56294449176693,344.94710206371633,391.18800328254429,434.42841915867558,471.66323348541493,503.3764698149219,521.92646571767352,516.82362485473129,511.15086911972463]
[null,"Custo por aluno de público"]
[null,"custo unitario em PIB / habitante",null,{"$f":"D395/D$15","v":0.123329534314479},{"$f":"E395/E$15","v":0.11499428734918175},0.11628562725240819,0.11768645745685423,0.1192853767545686,0.12028541741964748,0.12151261633766539,0.12241906407608573,0.1236457605910975,0.12525639311960127,0.12731349840196127,0.12991123197706175,0.13314474801183818,0.13716649098844694,0.13695778160744984]
[null,"custo unitario (dobras)",null,{"$f":"D396*1000/D340","v":4833.8487386498509},4659.0297939131178,4869.8481820749657,5094.0063332530208,5336.4797581637076,5561.3495870615634,5806.4721472569381,6045.2798140567074,6309.9219814447515,6605.5651672080148,6938.4765680923192,7316.9706064004913,7750.919496836641,8254.6671294341995,8522.3793265883069]
[null,"Total despesas correntes ensino basico (000  de Dbs)",null,{"$f":"D371+D374+D376+D381+D392","v":35538.455926553703},{"$f":"E371+E374+E376+E381+E392","v":38968.125196289315},40864.915999289653,44998.137751288887,50178.551215371481,56131.530474101564,62758.988652909356,69920.918166946518,79249.681935879067,88361.142515857384,97004.641051573257,104527.35243135614,110663.43405994156,110686.55097630188,107273.65756718957]
[]
["X","Formação profissional publico"]
[null,"CFP Politecnico"]
[null,"Numero de alunos politecnico",null,114,{"$f":"D400*(1+$C$401)","v":115.14},226,228.26,230.54259999999999,232.848026,235.17650626,237.52827132260001,239.90355403582601,242.30258957618426,244.7256154719461,247.17287162666557,249.64460034293222,252.14104634636155,254.66245680982516]
[null,"         Aumento médio anual no número de alunos ",0.01]
[null,"Custo por aluno"]
[null,"             custo unitario em PIB / habitante",1.5,{"$f":"D404/D$15","v":1.5782887993843198},{"$f":"D403+($C403-D403)/($C$5-D$5)","v":1.5726967422854399},1.56710468518656,1.5615126280876801,1.5559205709888,1.5503285138899199,1.54473645679104,1.5391443996921601,1.53355234259328,1.5279602854943999,1.52236822839552,1.5167761712966401,1.51118411419776,1.5055920570988799,1.5]
[null,"             custo unitario (dobras)",null,{"$f":"(D405*10^3)/D400","v":61860.359438926425},{"$f":"E403*E15","v":63718.304169742754},65627.731324972367,67589.384444250158,69607.347172789479,71678.837098362725,73815.1270340911,76005.797304531647,78260.63416946739,80579.050596656292,82967.76393168229,85429.154146007844,87972.425416313024,90606.395005891944,93339.486371960156]
[null,"Despesas correntes para Formação profissional MECF (000 Dbs)",null,7052.0809760376123,{"$f":"(E400*E404)/10^3","v":7336.5255421041811},{"$f":"(F400*F404)/10^3","v":14831.867279443755},15427.952893244541,16047.458796317535,16690.275724329327,17359.583685015619,18053.525644241334,18775.00427835283,19524.512625160194,20304.33709251208,21115.769350905819,21961.840984253875,22845.59124245734,23770.062916850566]
[null,"Fora MECCC"]
[null,"Numero total de alunos",null,{"$f":"D409+D416+D423","v":506},{"$f":"E409+E416+E423","v":521.62},537.92420000000004,554.94584199999997,572.71982042000002,591.28276462420013,610.67312557044204,630.93126679114653,652.099559922308,674.22248500794353,697.3467358187562,721.52133043571348,746.79772736177893,773.22994743819049,800.87470185550569]
[null,"Camara AG (Meri)"]
[null,"Numero de alunos",null,60,{"$f":"D409*(1+$C$410)","v":60.6},{"$f":"E409*(1+$C$410)","v":61.206000000000003},61.818060000000003,62.436240600000005,63.060603006000008,63.691209036060009,64.328121126420612,64.971402337684822,65.621116361061667,66.277327524672287,66.940100799919009,67.609501807918193,68.285596825997374,68.968452794257345]
[null,"         Aumento médio anual no número de alunos ",0.01]
[null,"Custo por aluno"]
[null,"             custo unitario em PIB / habitante",2.5,{"$f":"D413/D15","v":5.5903246035816379},{"$f":"D412+($C412-D412)/($C$5-D$5)","v":5.3695871318972355},5.1488496602128331,4.9281121885284307,4.7073747168440283,4.4866372451596259,4.2658997734752226,4.0451623017908194,3.8244248301064165,3.6036873584220137,3.3829498867376109,3.162212415053208,2.9414749433688052,2.7207374716844024,2.5]
[null,"             custo unitario (dobras)",null,{"$f":"D414*10^3/D409","v":219110.39949896111},{"$f":"E412*E15","v":217550.51494477317},215625.23890539966,213311.15951509294,210594.21174664353,207437.93159575373,203845.73194310881,199757.59651618073,195169.02307452893,190045.32300056459,184367.86998068923,178104.8100307789,171235.71022107915,163733.73710657054,155565.81061993359]
[null,"Despesas correntes para Camara AG (Meri) (000  de Dbs)",null,13146.623969937667,{"$f":"(E409*E413)/10^3","v":13183.561205653254},{"$f":"(F409*F413)/10^3","v":13197.558372443893},13186.482057573587,13148.710873580783,13081.161052745612,12983.181124297198,12850.03086461553,12680.405122028113,12470.986254495598,12219.409703736335,11922.353936410766,11577.161059772206,11180.655958873122,10729.133266141267]
[null,"Centro de formaçao profissionnal Budo Budo"]
[null,"Numero de alunos",null,264,{"$f":"D416*(1+$C$417)","v":277.2},{"$f":"E416*(1+$C$417)","v":291.06},305.613,320.89365000000004,336.93833250000006,353.78524912500006,371.47451158125006,390.04823716031257,409.55064901832822,430.02818146924466,451.5295905427069,474.10607006984225,497.81137357333438,522.70194225200112]
[null,"         Aumento médio anual no número de alunos ",0.05]
[null,"Custo por aluno"]
[null,"             custo unitario em % de PIB / habitante",0.1,{"$f":"D420/D15","v":2.2298713194541641E-2},{"$f":"D419+($C419-D419)/($C$5-D$5)","v":2.7848805109217237E-2},3.3398897023892836E-2,3.8948988938568435E-2,4.4499080853244034E-2,5.0049172767919634E-2,5.5599264682595233E-2,6.1149356597270832E-2,6.6699448511946424E-2,7.2249540426622016E-2,7.7799632341297609E-2,8.3349724255973201E-2,8.8899816170648807E-2,9.4449908085324413E-2,0.1]
[null,"             custo unitario (dobras)",null,{"$f":"D421*10^3/D416","v":873.98859687655056},{"$f":"E419*E15","v":1128.3031159168811},1398.6901201648304,1685.8897838743126,1990.7590577411829,2314.0040769412367,2656.8070996870301,3019.6683324607275,3403.8232633596313,3810.1771550549097,4240.0132961704485,4694.4938720943346,5175.2346878977887,5683.9870002628868,6222.6324247973444]
[null,"Despesas correntes para Centro de formaçao profissionnal Budo Budo (000  de Dbs)",null,230.73298957540936,{"$f":"(E416*E420)/10^3","v":312.76562373215944},{"$f":"(F416*F420)/10^3","v":407.10274637517557},515.22983451918026,638.82194030912899,779.67667508278214,939.93916163984488,1121.7298189382166,1327.6552634786865,1560.4605267275456,1823.3252071575957,2119.7028958720016,2453.6101795683471,2829.5533759738441,3252.5820543618511]
[null,"CATAP"]
[null,"Numero de alunos",null,182,{"$f":"D423*(1+$C$424)","v":183.82},{"$f":"E423*(1+$C$424)","v":185.65819999999999},187.514782,189.38992981999999,191.2838291182,193.196667409382,195.12863408347582,197.07992042431059,199.05071962855371,201.04122682483924,203.05163909308763,205.0821554840185,207.13297703885868,209.20430680924727]
[null,"         Aumento médio anual no número de alunos ",0.01]
[null,"Custo por aluno"]
[null,"             custo unitario em % de PIB / habitante",null,{"$f":"D427/D15","v":0.14062994414634472},{"$f":"E427/E$15","v":0.13955058392328323},0.13839951239303003,0.13718392840906796,0.13590404926557911,0.13457354490017936,0.1331792311617791,0.13174811246142226,0.13026997166975698,0.12875322537355038,0.1271942984617489,0.12559707868454981,0.1239557692226249,0.1222666339433892,0.12052776844269822]
[null,"             custo unitario (dobras)",7500,{"$f":"D428*10^3/D423","v":5511.9309572257107},{"$f":"D427+($C427-D427)/($C$5-D$5)","v":5653.9358888524457},5795.9408204791807,5937.9457521059157,6079.9506837326508,6221.9556153593858,6363.9605469861208,6505.9654786128558,6647.9704102395908,6789.9753418663258,6931.9802734930608,7073.9852051197959,7215.9901367465309,7357.9950683732659,7500]
[null,"Despesas correntes para CFP CATAP (000  de Dbs)",null,1003.1714342150793,{"$f":"E427*E423/1000","v":1039.3064950888565},{"$f":"F427*F423/1000","v":1076.0639400366877},1113.4526032339668,1151.4814333011875,1190.1594947094297,1229.4959692025063,1269.5001572359736,1310.1814794331901,1351.5494780586271,1393.6138185086297,1436.3842908198262,1479.8708111953958,1524.0834235493951,1569.0323010693546]
[null,"Total despesas correntes Formação profissional publico (fora MECCC) (000  de Dbs)",null,{"$f":"D428+D421+D414","v":14380.528393728157},{"$f":"E428+E421+E414","v":14535.633324474269},14680.725058855756,14815.164495326733,14939.0142471911,15050.997222537824,15152.61625513955,15241.260840789721,15318.24186493999,15382.99625928177,15436.348729402562,15478.441123102593,15510.642050535949,15534.292758396361,15550.747621572473]
[null,"Despesas do pessoal para Direcoes formacao professional",null,134.59650999999999,{"$f":"E431*E428","v":139.13514832405301},{"$f":"F431*F428","v":143.7353903763441},148.39785727373325,153.12317482410597,157.91197354237303,162.7648886661633,167.68256017120189,172.66563278636264,177.71475600838633,182.83058411625453,188.01377618520866,193.26499610040509,198.58491257019446,203.97419913901609]
[null,"              Em % das otras despesas correntes",0.13,{"$f":"D430/D428","v":0.13417099551415515},{"$f":"D431+($C431-D431)/($C$5-D$5)","v":0.13387306726314407},0.133575139012133,0.13327721076112192,0.13297928251011085,0.13268135425909977,0.13238342600808869,0.13208549775707762,0.13178756950606654,0.13148964125505547,0.13119171300404436,0.13089378475303326,0.13059585650202218,0.13029792825101111,0.13]
[null,"Total despesas correntes Formação profissional publico (000  de Dbs)",null,{"$f":"D429+D405+D430","v":21567.20587976577},{"$f":"E429+E405","v":21872.158866578451},29512.59233829951,30243.117388571274,30986.473043508635,31741.272946867153,32512.199940155169,33294.786485031058,34093.246143292818,34907.508884441966,35740.685821914638,36594.210474008411,37472.483034789824,38379.884000853701,39320.810538423037]
[]
[null,"Enseignement supérieur"]
[]
[null,"Institut de formation supérieure en éducation et communication (ISEC)"]
[null,"Besoins en nouveaux enseignants",null,null,{"$f":"SUM(E438:E441)","v":136.50587154396203},{"$f":"SUM(F438:F441)","v":93.162934305759734},99.958888683836449,112.3201056900112,132.85840091158906,318.43675273309992,128.92973380294711,136.34301093166354,104.90635705457979,102.62557791140446,96.47488306187492,112.86143924502812,89.106914896324952,57.668913372359611]
[null,"Enseignement préscolaire",null,null,{"$f":"E76+E79","v":0},16.115456624798917,14.217161034080959,16.066364459368359,19.365661337630755,25.746190071845348,23.415900379291145,23.897859644631893,24.321885654087538,24.943385532271265,25.767993672445158,26.477563037027608,26.808454514651999,27.010311232075424]
[null,"Éducation de base des cycles 1 et 2",null,null,{"$f":"E193+E194","v":69.746502786648591},30.976916393669569,27.47506234437526,28.08256740334582,36.59215417162261,205.77606650207156,18.306524551380562,19.824217003838271,20.049182967840579,20.309823115896734,20.534889466881509,20.795289155783962,21.266838185891743,30.658602140284188]
[null,"Éducation de base du cycle 3",null,null,{"$f":"E280","v":45.848125616573611},37.481348361372739,33.104209174729704,36.364848024498201,38.083796645308553,44.131756648747796,39.14695202128803,30.382889990061358,0,0,0,24.050071506486802,37.578194392461228,0]
["A revoir parceque dans les commentaires recus on me dit que les enseignants du secondaire ne sont pas formés à l'ISEC","Enseignement secondaire général",null,null,{"$f":"E364","v":20.911243140739828},8.5892129259185026,25.162456130650526,31.806325802798824,38.816788757027155,42.782739510435192,48.060356850987375,62.23804429313202,60.535288432651669,57.372369263236465,50.171999922548252,41.538515545729751,3.4534278033199826,0]
[null,"Enseignement préscolaire (éducateurs de moyenne section)"]
[null,"Formation initiale"]
[null,"Nombre d’élèves",null,48,{"$f":"SUM(E445:E448)","v":74},{"$f":"SUM(F445:F448)","v":58.755416763862172},{"$f":"SUM(G445:G448)","v":91.510833527724344},183.02166705544869,113.80034913286526,105.18969017157355,96.57903121028184,98.950354021761427,101.32167683324101,103.6929996447206,106.06432245620019,106.06432245620019,106.06432245620019,106.06432245620019]
[null,"             1re année",null,null,26,{"$f":"G446","v":32.755416763862172},{"$f":"H446","v":32.755416763862172},{"$f":"G444","v":91.510833527724344},{"$f":"J446","v":24.14475780257046},24.14475780257046,24.14475780257046,26.516080614050047,26.516080614050047,26.516080614050047,26.516080614050047,{"$f":"O445","v":26.516080614050047},{"$f":"P445","v":26.516080614050047},{"$f":"Q445","v":26.516080614050047}]
[null,"             2e année",null,null,{"$f":"D445","v":0},{"$f":"E445","v":26},{"$f":"H447","v":32.755416763862172},{"$f":"I447","v":32.755416763862172},{"$f":"J447","v":24.14475780257046},24.14475780257046,24.14475780257046,24.14475780257046,26.516080614050047,26.516080614050047,26.516080614050047,26.516080614050047,{"$f":"P446","v":26.516080614050047},{"$f":"Q445","v":26.516080614050047}]
[null,"             3e année",null,null,{"$f":"D446","v":0},{"$f":"E446","v":0},{"$f":"F446","v":26},{"$f":"I448","v":32.755416763862172},{"$f":"J448","v":32.755416763862172},{"$f":"K448","v":24.14475780257046},24.14475780257046,24.14475780257046,24.14475780257046,26.516080614050047,26.516080614050047,26.516080614050047,26.516080614050047,{"$f":"Q447","v":26.516080614050047}]
[null,"             4e année",null,null,48,{"$f":"E447","v":0},{"$f":"F447","v":0},{"$f":"G447","v":26},{"$f":"IF(SUM($F438:$J438)-$F448-$G448-$H448>0,(SUM($F438:$J438)-$F448-$G448-$H448)/($J$5-$H$5),0)","v":32.755416763862172},{"$f":"IF(SUM($F438:$J438)-$F448-$G448-$H448>0,(SUM($F438:$J438)-$F448-$G448-$H448)/($J$5-$H$5),0)","v":32.755416763862172},{"$f":"SUM($K438:$N438)/($N$5-$J$5)","v":24.14475780257046},{"$f":"SUM($K438:$N438)/($N$5-$J$5)","v":24.14475780257046},{"$f":"SUM($K438:$N438)/($N$5-$J$5)","v":24.14475780257046},{"$f":"SUM($K438:$N438)/($N$5-$J$5)","v":24.14475780257046},{"$f":"SUM($O438:$R438)/($R$5-$N$5)","v":26.516080614050047},{"$f":"SUM($O438:$R438)/($R$5-$N$5)","v":26.516080614050047},{"$f":"SUM($O438:$R438)/($R$5-$N$5)","v":26.516080614050047},{"$f":"SUM($O438:$R438)/($R$5-$N$5)","v":26.516080614050047}]
[null,"Ensino basico"]
[null,"Formaçao inicial"]
[null,"Numero estudantes em formaçao inicial",null,193,{"$f":"SUM(E452:E455)","v":130},229.45138340754241,328.90276681508482,236.52520372482385,238.14764063456289,158.31869413675952,78.489747638956146,82.18121546642746,85.872683293898774,89.564151121370088,93.255618948841402,93.255618948841402,93.255618948841402,93.255618948841402]
[null,"             1° ano",null,null,18,{"$f":"G453","v":99.451383407542409},{"$f":"H453","v":99.451383407542409},{"$f":"I453","v":19.622436909739037},{"$f":"J453","v":19.622436909739037},19.622436909739037,19.622436909739037,23.313904737210351,23.313904737210351,23.313904737210351,23.313904737210351,{"$f":"O452","v":23.313904737210351},{"$f":"P452","v":23.313904737210351},{"$f":"Q452","v":23.313904737210351}]
[null,"             2° ano",null,null,112,{"$f":"E452","v":18},{"$f":"H454","v":99.451383407542409},{"$f":"I454","v":99.451383407542409},{"$f":"J454","v":19.622436909739037},19.622436909739037,19.622436909739037,19.622436909739037,23.313904737210351,23.313904737210351,23.313904737210351,23.313904737210351,{"$f":"P453","v":23.313904737210351},{"$f":"Q452","v":23.313904737210351}]
[null,"             3° ano",null,null,0,{"$f":"E453","v":112},{"$f":"F453","v":18},{"$f":"I455","v":99.451383407542409},{"$f":"J455","v":99.451383407542409},{"$f":"K455","v":19.622436909739037},19.622436909739037,19.622436909739037,19.622436909739037,23.313904737210351,23.313904737210351,23.313904737210351,23.313904737210351,{"$f":"Q454","v":23.313904737210351}]
[null,"             4° ano",null,null,0,{"$f":"E454","v":0},{"$f":"F454","v":112},{"$f":"G454","v":18},{"$f":"IF(SUM($F439:$J439)-$F455-$G455-$H455>0,(SUM($F439:$J439)-$F455-$G455-$H455)/($J$5-$H$5),0)","v":99.451383407542409},{"$f":"IF(SUM($F439:$J439)-$F455-$G455-$H455>0,(SUM($F439:$J439)-$F455-$G455-$H455)/($J$5-$H$5),0)","v":99.451383407542409},{"$f":"SUM($K439:$N439)/($N$5-$J$5)","v":19.622436909739037},{"$f":"SUM($K439:$N439)/($N$5-$J$5)","v":19.622436909739037},{"$f":"SUM($K439:$N439)/($N$5-$J$5)","v":19.622436909739037},{"$f":"SUM($K439:$N439)/($N$5-$J$5)","v":19.622436909739037},{"$f":"SUM($O439:$R439)/($R$5-$N$5)","v":23.313904737210351},{"$f":"SUM($O439:$R439)/($R$5-$N$5)","v":23.313904737210351},{"$f":"SUM($O439:$R439)/($R$5-$N$5)","v":23.313904737210351},{"$f":"SUM($O439:$R439)/($R$5-$N$5)","v":23.313904737210351}]
[null,"Ensino basico ciclo 3 e secundario geral(Licenciatura)"]
[null,"Formaçao inicial"]
[null,"Numero estudantes em formaçao inicial",null,289,{"$f":"SUM(E459:E462)","v":446},{"$f":"SUM(F459:F462)","v":402},228,258.43397521283924,148.86795042567846,223.30192563851767,297.73590085135692,262.49997793115421,227.26405501095149,192.02813209074873,156.79220917054602,156.79220917054602,156.79220917054602,156.79220917054602]
[null,"             1° ano",null,null,184,{"$f":"G460","v":0},{"$f":"H460","v":0},{"$f":"I460","v":74.433975212839229},{"$f":"J460","v":74.433975212839229},74.433975212839229,74.433975212839229,39.198052292636504,39.198052292636504,39.198052292636504,39.198052292636504,{"$f":"O459","v":39.198052292636504},{"$f":"P459","v":39.198052292636504},{"$f":"Q459","v":39.198052292636504}]
[null,"             2° ano",null,null,44,{"$f":"E459","v":184},{"$f":"H461","v":0},{"$f":"I461","v":0},{"$f":"J461","v":74.433975212839229},74.433975212839229,74.433975212839229,74.433975212839229,39.198052292636504,39.198052292636504,39.198052292636504,39.198052292636504,{"$f":"P460","v":39.198052292636504},{"$f":"Q459","v":39.198052292636504}]
[null,"             3° ano",null,null,174,{"$f":"E460","v":44},{"$f":"F460","v":184},{"$f":"I462","v":0},{"$f":"J462","v":0},{"$f":"K462","v":74.433975212839229},74.433975212839229,74.433975212839229,74.433975212839229,39.198052292636504,39.198052292636504,39.198052292636504,39.198052292636504,{"$f":"Q461","v":39.198052292636504}]
[null,"             4° ano",null,null,44,{"$f":"E461","v":174},{"$f":"F461","v":44},{"$f":"G461","v":184},{"$f":"IF(SUM($F440:$J441)-$F462-$G462-$H462>0,(SUM($F440:$J441)-$F462-$G462-$H462)/($J$5-$H$5),0)","v":0},{"$f":"IF(SUM($F440:$J441)-$F462-$G462-$H462>0,(SUM($F440:$J441)-$F462-$G462-$H462)/($J$5-$H$5),0)","v":0},{"$f":"SUM($K440:$N441)/($N$5-$J$5)","v":74.433975212839229},{"$f":"SUM($K440:$N441)/($N$5-$J$5)","v":74.433975212839229},{"$f":"SUM($K440:$N441)/($N$5-$J$5)","v":74.433975212839229},{"$f":"SUM($K440:$N441)/($N$5-$J$5)","v":74.433975212839229},{"$f":"SUM($O440:$R441)/($R$5-$N$5)","v":39.198052292636504},{"$f":"SUM($O440:$R441)/($R$5-$N$5)","v":39.198052292636504},{"$f":"SUM($O440:$R441)/($R$5-$N$5)","v":39.198052292636504},{"$f":"SUM($O440:$R441)/($R$5-$N$5)","v":39.198052292636504}]
[]
[null,"Numero de professores  Formação em Exercício",null,null,{"$f":"SUM(E468:E471)","v":0},0,97.212499999999991,194.42499999999998,291.63749999999999,388.84999999999997,291.63749999999999,194.42499999999998,97.212499999999991,0,0,0,0,0]
[null,"            Ano de arranque",2019]
[null,"            Ano de pressupostos",2022]
[null,"           Stock professores por formaçao em Exercico ",{"$f":"D166*35%","v":388.84999999999997}]
[null,"             1° ano",null,0,{"$f":"IF($C$465>E5,0,IF(E5<$N$5,$C$467/($M$5-$C$465),0))","v":0},{"$f":"IF($C$465>F5,0,IF(F5<=$C$466,$C$467/($C$466-$C$465+1),0))","v":0},97.212499999999991,97.212499999999991,97.212499999999991,97.212499999999991,0,0,0,0,0,0,0,0]
[null,"             2° ano",null,0,{"$f":"D468","v":0},{"$f":"E468","v":0},0,97.212499999999991,97.212499999999991,97.212499999999991,97.212499999999991,0,0,0,0,0,0,0]
[null,"             3° ano",null,0,{"$f":"D469","v":0},0,0,0,97.212499999999991,97.212499999999991,97.212499999999991,97.212499999999991,0,0,0,0,0,0]
[null,"             4° ano",null,0,{"$f":"D470","v":0},0,0,0,0,97.212499999999991,97.212499999999991,97.212499999999991,97.212499999999991,0,0,0,0,0]
[]
[null,"Nombre total d’élèves (enseignement préscolaire + éducation de base + enseignement secondaire)",null,{"$f":"D444+D451+D458","v":530},{"$f":"E451+E444+E464+E458","v":650},{"$f":"F451+F444+F464+F458","v":690.20680017140455},745.6261003428092,872.40584599311183,792.45344019310664,875.6603099468507,764.44217970059481,638.05654741934313,511.67091513809129,385.28528285683944,356.11215057558763,356.11215057558763,356.11215057558763,356.11215057558763]
[null,"Masse salariale des enseignants à contrat à durée indéterminée de l’ISEC (en milliers de dobras)",null,996.19399499999997,{"$f":"D474*(1+$C$475)","v":1046.00369475},{"$f":"E474*(1+$C$475)","v":1098.3038794875001},1153.2190734618753,1210.8800271349692,1271.4240284917178,1334.9952299163037,1401.7449914121189,1471.8322409827249,1545.4238530318612,1622.6950456834543,1703.829797967627,1789.0212878660084,1878.4723522593088,1972.3959698722742]
[null,"         Augmentation annuelle moyenne",0.05,{"$f":"D474/D473","v":1.8796113113207547},{"$f":"E474/E473","v":1.6092364534615384},1.5912678333721859,1.5466452595096538,1.3879778920515506,1.6044148009274772,1.5245583415757795,1.833683473563865,2.3067426342314583,3.0203472726503859,4.2116715013129626,4.7845314887843893,5.0237580632236094,{"$f":"Q474/Q473","v":5.2749459663847897},5.5386932647040288]
[null,"Masse salariale des autres effectifs de l’ISEC (en milliers de dobras)",null,337.72130562081884,{"$f":"E474*E477","v":354.60737090185978},{"$f":"F474*F477","v":372.33773944695281},390.9546264193005,410.50235774026555,431.02747562727887,452.5788494086429,475.20779187907499,498.96818147302878,523.91659054668025,550.11242007401427,577.61804107771491,606.49894313160075,636.82389028818079,668.66508480258983]
[null,"              Masse salariale des autres effectifs en pourcentage de la masse salariale totale des enseignants",0.33901158540994702,{"$f":"D476/D474","v":0.33901158540994702},{"$f":"D477+($C477-D477)/($C$5-D$5)","v":0.33901158540994702},0.33901158540994702,0.33901158540994702,0.33901158540994702,0.33901158540994702,0.33901158540994702,0.33901158540994702,0.33901158540994702,0.33901158540994702,0.33901158540994702,0.33901158540994702,0.33901158540994702,0.33901158540994702,0.33901158540994702]
[null,"Transferts (en milliers de dobras)",null,5036.5225297435654,{"$f":"E479*E473/10^3","v":6287.168454413717},6793.1954769622189,7465.1750854225838,8882.5303876502076,8202.9577467529634,9212.8550716264126,8172.4463081921986,6929.5658788742094,5643.791643328429,4315.1236015548584,4048.8200894807428,4109.2502400700087,4169.6803906592741,4230.1105412485385]
[null,"Par élève (en dobras)",11878.590872036712,{"$f":"D478*10^3/(D444+D451+D458)","v":9502.8726976293692},{"$f":"D479+($C479-D479)/($C$5-D$5)","v":9672.5668529441791},9842.261008258989,10011.955163573799,10181.649318888609,10351.343474203419,10521.037629518229,10690.731784833039,10860.425940147848,11030.120095462658,11199.814250777468,11369.508406092278,11539.20256140709,11708.896716721902,11878.590872036712]
[null,"Dépenses administratives et pédagogiques (en milliers de dobras)",null,113.26307583343664,{"$f":"E481*E473/10^3","v":140.59272113107002},151.07872558331957,165.142498099455,195.4836648650757,179.62288826785297,200.75334058308252,177.23741639625928,149.58887101924131,121.28499657916733,92.325793076037385,86.258292723918046,87.181541030577662,88.104789337237293,89.028037643896909]
[null,"          Dépenses administratives et pédagogiques par élève (en dobras)",250,{"$f":"D480*10^3/D473","v":213.70391666686157},{"$f":"D481+($C481-D481)/($C$5-D$5)","v":216.29649404780002},218.88907142873848,221.48164880967693,224.07422619061538,226.66680357155383,229.25938095249228,231.85195833343073,234.44453571436921,237.03711309530769,239.62969047624614,242.22226785718459,244.81484523812307,247.40742261906155,250]
[null,"Bourses (en milliers de dobras)",null,1373.9436984941754,{"$f":"E484*E485/10^3","v":1735.3947436863875},{"$f":"F484*F485/10^3","v":1897.62369900608},2110.8059005082691,2542.7863419569976,2377.7736651583414,2704.8195206141813,2430.4221286892966,2087.8889724964661,1723.1118194990602,1335.2699344492685,1270.0697402455439,1307.0912717463052,1345.3531979840716,1384.9718843974786]
[null,"Pourcentage de bénéficiaires",0.5,{"$f":"D484/D473","v":0.48030495552731889},{"$f":"D483+($C483-D483)/($C$5-D$5)","v":0.48171174441822467},0.48311853330913046,0.48452532220003625,0.48593211109094203,0.48733889998184782,0.4887456888727536,0.49015247776365939,0.49155926665456517,0.49296605554547096,0.49437284443637675,0.49577963332728259,0.49718642221818837,0.49859321110909416,0.5]
[null,"Nombre de bénéficiaires",null,254.56162642947902,{"$f":"E483*E473","v":313.11263387184601},333.45169697879709,361.27472650935619,423.9300144715121,386.19338783053962,427.97520140350247,374.69322848729911,313.6426085335961,252.23639277296627,190.47458120540969,176.55315143575487,177.05412605310119,177.5551006704475,178.05607528779382]
[null,"          Montant moyen d’une bourse par bénéficiaire (en dobras)",null,{"$f":"D482*10^3/D484","v":5397.2930553804335},{"$f":"+E486*E15","v":5542.3977059854697},5690.8503276465335,5842.6614031457975,5998.1276511570804,6156.9507404453552,6320.0379642184689,6486.4319499483026,6656.904756207,6831.3370666143492,7010.2263829592048,7193.6962320817247,7382.4389235317167,7577.1025045409697,7778.29053099668]
[null,"Montant d’une bourse par bénéficiaire en pourcentage du PIB par habitant",0.125,{"$f":"D485/D15","v":0.13770510313170511},0.13679759576515474,0.13589008839860436,0.13498258103205399,0.13407507366550361,0.13316756629895327,0.13226005893240289,0.13135255156585252,0.13044504419930217,0.12953753683275182,0.12863002946620145,0.12772252209965107,0.12681501473310072,0.12590750736655038,0.125]
[null,"Total des dépenses courantes à l’ISEC (en milliers de dobras)",null,{"$f":"D482+D480+D478+D476+D474","v":7857.6446046919955},9563.7669848830337,10312.539520486072,11285.297183911483,13242.182779347517,12462.805804298156,13906.002012148623,12657.058636568947,11137.844144845671,9557.5289029851974,7915.5267948376331,7686.5959614955473,7899.0432838445004,8118.4346205280726,{"$f":"R482+R480+R478+R476+R474","v":8345.1715179647781}]
[]
["XX","Dépenses d’investissement (en milliers de dobras)"]
[]
[null,"Enseignement préscolaire"]
[null,"Coût par salle de classe équipée (en euros)",20000]
[null,"Nombre de classes par salle",1.2,null,{"$f":"E72/E494","v":1.1679841897233201},{"$f":"E493+($C493-E493)/($C$5-E$5)","v":1.1704469443599879},{"$f":"F493+($C493-F493)/($C$5-F$5)","v":1.1729096989966554},1.1753724536333232,1.177835208269991,1.1802979629066586,1.1827607175433261,1.1852234721799939,1.1876862268166617,1.1901489814533293,1.1926117360899968,1.1950744907266646,1.1975372453633324,1.2]
[null,"Nombre de salles de classe",null,null,253,{"$f":"F72/F493","v":255.5649615335312},257.26356484465765,259.70823778859449,263.49860195881024,269.9112146289184,275.20779757213535,280.59799284821975,286.05509823701789,291.66032400813265,297.49534998274288,303.50683866765661,309.53259294067328,315.51817682156343]
[null,"Nouvelles salles (moyenne par période : 2019-2022, 2023-2026, 2027-2030)",null,null,null,null,{"$f":"IF(($J494-$E494)/($J$5-$F$5)>=0,($J494-$E494)/($J$5-$F$5),0)","v":4.2278036572296003},{"$f":"IF(($J494-$E494)/($J$5-$F$5)>=0,($J494-$E494)/($J$5-$F$5),0)","v":4.2278036572296003},{"$f":"IF(($J494-$E494)/($J$5-$F$5)>=0,($J494-$E494)/($J$5-$F$5),0)","v":4.2278036572296003},{"$f":"IF(($J494-$E494)/($J$5-$F$5)>=0,($J494-$E494)/($J$5-$F$5),0)","v":4.2278036572296003},{"$f":"IF(($N494-$J494)/($N$5-$J$5)>=0,($N494-$J494)/($N$5-$J$5),0)","v":5.4372773448035616},{"$f":"IF(($N494-$J494)/($N$5-$J$5)>=0,($N494-$J494)/($N$5-$J$5),0)","v":5.4372773448035616},{"$f":"IF(($N494-$J494)/($N$5-$J$5)>=0,($N494-$J494)/($N$5-$J$5),0)","v":5.4372773448035616},{"$f":"IF(($N494-$J494)/($N$5-$J$5)>=0,($N494-$J494)/($N$5-$J$5),0)","v":5.4372773448035616},{"$f":"IF(($R494-$N494)/($R$5-$N$5)>=0,($R494-$N494)/($R$5-$N$5),0)","v":5.9644632033576954},{"$f":"IF(($R494-$N494)/($R$5-$N$5)>=0,($R494-$N494)/($R$5-$N$5),0)","v":5.9644632033576954},{"$f":"IF(($R494-$N494)/($R$5-$N$5)>=0,($R494-$N494)/($R$5-$N$5),0)","v":5.9644632033576954},{"$f":"IF(($R494-$N494)/($R$5-$N$5)>=0,($R494-$N494)/($R$5-$N$5),0)","v":5.9644632033576954}]
[null,"Dépenses annuelles consacrées à l’aménagement de nouvelles salles (en euros)",null,null,null,null,{"$f":"G495*$C$492","v":84556.07314459201},84556.07314459201,84556.07314459201,84556.07314459201,108745.54689607123,108745.54689607123,108745.54689607123,108745.54689607123,119289.26406715391,119289.26406715391,119289.26406715391,119289.26406715391]
[null,"Pourcentage annuel de salles nécessitant des travaux d’entretien",0.25]
[null,"Frais d’entretien par classe (en euros)",1000]
[null,"Dépenses d’entretien (en euros)",null,null,null,null,{"$f":"G494*$C497*$C498","v":64315.891211164409},64927.059447148626,65874.650489702559,67477.803657229597,68801.949393033836,70149.498212054939,71513.774559254467,72915.081002033156,74373.837495685715,75876.709666914147,77383.148235168323,78879.544205390863]
[null,"Total des dépenses par salle de classe de l’enseignement préscolaire (en milliers de dobras)",null,null,null,null,{"$f":"(G499+G496)*$C$12/1000","v":3647.3631267160322},3662.3367484976452,3685.5527290402169,3724.8299816446297,4349.913659083074,4382.9286051490908,4416.3533756554798,4450.6853835035572,4744.745988289571,4781.5663564846673,4818.474101406895,4855.135802677346]

{"sheet":"Conseils","index":1,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[0,"Cette présentation guidée porte sur l’exemple du modèle de simulation de Sao Tomé-et-Principe. Les cellules apparaîtront en surbrillance et un encadré vous exposera les différentes étapes. Cliquez sur l’encadré pour passer au conseil suivant. Vous pouvez utiliser à tout moment les boutons situés en haut à droite pour parcourir les conseils, mettre en pause ou redémarrer la présentation.\nCe modèle est un exemple type d’outil de projection axé sur les besoins qui peut être élaboré afin d’évaluer la viabilité pratique et financière des politiques envisagées. Il est généralement conçu par la Division de la planification du Ministère de l’éducation avec une assistance technique externe. Il offre une grande souplesse dans la projection des besoins et l’estimation des coûts. ","Ainsi s’achève cette présentation guidée. Ce modèle permet d’estimer les dépenses publiques à l’aide de projections et d’anticiper les conséquences des politiques d’EPE sur les coûts en fonction de différents éléments : population cible, effectifs prévus, besoins en matière de formation et de rémunération des enseignants, etc. Il convient de l’adapter aux spécificités de votre contexte national, à la structure du sous-secteur de l’EPE, aux politiques envisagées, etc. Comme indiqué dans l’outil intitulé « Ajustement des composantes relatives à l’EPE dans le plan sectoriel d’éducation après la simulation », la valeur du modèle de simulation réside non seulement dans le calcul des coûts eux-mêmes, mais également dans les indications apportées en matière d’accessibilité financière et de faisabilité opérationnelle, lesquelles orienteront l’ajustement des politiques et des cibles durant l’élaboration du plan sectoriel d’éducation.  \n\nVous pouvez recommencer, parcourir les conseils ou fermer ce fichier.\n\nCliquez pour fermer.",null,null,null,-1]
["B:B","La première colonne indique les variables qui sont estimées. Nous y reviendrons en détail dans un instant.",null,null,"B:B",null,"B:b"]
["C:C","La colonne suivante indique les « hypothèses » relatives à chaque variable. Ces hypothèses sont exprimées sous forme de taux de croissance annuel sur la période donnée ou sous forme de valeur cible de la variable concernée. L’année cible correspond par défaut à la fin du Plan stratégique du secteur de l’éducation ; lorsque l’année cible est fixée avant cette échéance, celle-ci apparaît en bleu dans cette colonne.",null,null,"C:C",null,"C:c"]
["D:E","Les colonnes suivantes correspondent aux données de référence. Les cellules en vert contiennent les données saisies manuellement (à partir du système d’information sur la gestion des établissements d’enseignement [SIGE] ou de l’analyse du secteur de l’éducation), et les cellules en blanc correspondent aux calculs.",null,null,"D:E",null,"d:e"]
["F:R","Les autres colonnes indiquent le nombre d’années entre l’année de référence et la dernière année du Plan stratégique du secteur de l’éducation.",null,null,"F:R",null,"f:r"]
[" 9:41","Le premier « bloc » du modèle de simulation concerne la projection des ressources consacrées au secteur de l’éducation. Ces éléments ne sont pas du ressort du Ministère de l’éducation mais ils peuvent déterminer le budget national affecté à la mise en œuvre du futur plan. Des chiffres et des projections actualisés sont disponibles auprès du Ministère des finances, du budget ou de la planification. Ces données n’influenceront pas les choix de politiques du Ministère, mais elles permettront d’envisager différents scénarios (par exemple, en matière de croissance économique nationale).",null,null," 9:41",null," 9:41"]
[" 9:10","Lorsque Sao Tomé-et-Principe a réalisé sa simulation, l’augmentation prévue du PIB était de 5,5 % par an.  \nSi vous deviez réaliser cet exercice, vous pourriez obtenir ces chiffres auprès du Ministère des finances ou de l’Institut national de la statistique.  ",null,null," 9:10",null," 9:10"]
[" 20:20","Les ressources nationales du pays sont exprimées en pourcentage du PIB afin de refléter la capacité de l’État à utiliser les ressources générées par l’économie grâce à la fiscalité (impôts sur le revenu, impôts sur les sociétés, TVA, etc.). Ce montant résulte de discussions avec le Ministère des finances ou du budget, et peut varier en fonction des niveaux d’imposition (par exemple, impôt plus ou moins élevé sur les sociétés) ou de l’assiette fiscale (par exemple, nouveaux gisements pétroliers). Le Ministère des finances/du budget dispose peut-être d’un plan de politique publique macroéconomique visant à augmenter le niveau d’imposition, et ainsi accroître les recettes publiques, ou à faire diminuer les impôts pour stimuler l’investissement et encourager la création d’entreprises, par exemple. En l’absence d’objectifs explicites, il est généralement prévu que le montant des recettes nationales en pourcentage du PIB reste stable.Ici, on prévoit une hausse de 14,9 % à 18 %. ",null,null," 20:20",null," 20:20"]
[" 19:19","Les ressources nationales sont donc calculées en multipliant le PIB par ce pourcentage au moyen d’une formule simple.",null,null," 19:19",null," 19:19"]
[" 23:24","Les ressources externes, qui devraient passer de 13,7 % à 6 %, sont également exprimées en pourcentage du PIB (dépendance à l’aide extérieure).",null,null," 23:24",null," 23:24"]
[" 28:28","Le total des recettes de l’État est donc calculé en additionnant les ressources nationales et les ressources externes.",null,null," 28:28",null," 28:28"]
[" 29:38","Ici, les projections des ressources totales (et ensuite celles de l’éducation) sont établies à partir des dépenses publiques réelles –  et non des recettes –, mais on suppose qu’à terme (en 2022 dans cet exemple) la réduction du déficit budgétaire permettra de porter les ressources au niveau des recettes. En l’absence de déficit budgétaire (important), les projections des ressources sont souvent établies simplement à partir des recettes prévues.",null,null," 29:38",null," 29:38"]
[" 39:41","Enfin, les ressources publiques consacrées au fonctionnement et au développement du système d’éducation sont estimées sous forme de pourcentage du total des dépenses publiques (de 17,8 % en 2016 à 20 % en 2022).\nCes ressources sont affectées à tous les niveaux d’enseignement. Les sections suivantes du modèle permettront d’estimer les dépenses qui seront consacrées à chaque sous-secteur afin de les comparer au budget prévu.",null,null," 39:41",null," 39:41"]
[" 43:43","Avant d’aller plus loin, il est important de comprendre que les dépenses consacrées aux différents niveaux d’enseignement sont généralement fonction des effectifs estimés dans ces niveaux (primaire, premier et second cycles du secondaire, voire enseignement supérieur). Les projections reposent sur des objectifs ; lorsque ces modèles ont été conçus pour la première fois, les objectifs fixés portaient souvent sur l’enseignement primaire universel (programme Éducation pour tous et objectifs du Millénaire pour le développement), puis ils se sont progressivement orientés vers le premier cycle du secondaire (objectif de développement durable 4). Les effectifs devraient « fluctuer » entre un niveau d’enseignement et le suivant en fonction des hypothèses relatives aux taux de rétention (ou persévérance) et de transition entre les différents cycles d’enseignement. Toutefois, l’éducation de la petite enfance (EPE) n’étant pas toujours obligatoire, il est impossible de calculer les effectifs du primaire à partir des effectifs de l’EPE*. Les effectifs sont donc généralement calculés séparément en fonction des objectifs fixés dans la politique nationale, et exprimés en taux de scolarisation du groupe d’âge cible.\n* Les effectifs de l’EPE sont parfois calculés à partir de ceux du primaire, en utilisant le pourcentage d’élèves de première année ayant suivi un programme d’EPE – en particulier lorsque les données relatives à l’EPE ne sont pas fiables ou sont incomplètes (par exemple, absence de données sur les prestataires de services d’EPE privés ou communautaires, mais pourcentage connu d’élèves de première année ayant suivi un programme d’EPE grâce aux données collectées dans le SIGE au niveau des établissements primaires).",null,null," 43:43",null," 43:43"]
[" 46:47","La première étape relative à l’enseignement préscolaire (comme pour les autres niveaux d’enseignement) consiste à estimer le groupe d’âge cible ou à utiliser les projections existantes. Ici, les estimations de population ont été fournies par l’Institut national de la statistique et utilisées telles quelles.",null,null," 46:47",null," 46:47"]
[" 48:51","L’étape suivante consiste à établir des hypothèses ou à fixer des taux de scolarisation cibles.\nIci, la priorité retenue vise à universaliser l’enseignement préscolaire et à le rendre obligatoire. Afin de concentrer les ressources et les efforts, la durée de l’enseignement préscolaire sera ramenée de trois à deux ans, et tous les enfants âgés de 4 à 5 ans devront pouvoir bénéficier d’un enseignement préscolaire à l’horizon 2022 (contre 59,3 % en 2016). Parallèlement, il est prévu de ne plus accueillir les enfants de moins de 4 ans dans les établissements publics, afin que les effectifs d’enfants déjà scolarisés mais pas assez âgés pour leur niveau disparaissent progressivement du système public d’ici à 2022. Actuellement, il n’est pas prévu de mettre en place des services d’enseignement préscolaire ni des activités d’éducation parentale au niveau communautaire, et ce afin de mettre l’accent sur la prestation de services publics.",null,null," 48:51",null," 48:51"]
["48:48,50:50,52:52,57:58","La projection des taux de scolarisation correspondant aux objectifs fixés permet de calculer le nombre d’élèves de chaque groupe d’âge ainsi que le nombre total d’élèves dans l’enseignement préscolaire.",null,null,"48:48,50:50,52:52,57:58",null,"48:48,50:50,52:52,57:58"]
["59:61","On calcule ensuite le nombre d’élèves scolarisés dans l’enseignement privé (et/ou communautaire), car ces derniers ne constituent pas une charge financière pour l’État (ou, du moins, ils représentent un coût différent).\nIci, la politique vise à réduire la proportion (et le nombre) d’élèves fréquentant des écoles et des centres non étatiques afin de mieux gérer et superviser ces prestataires de services.\nSi votre système inclut des prestataires de services communautaires, vous pouvez comptabiliser les élèves qui fréquentent ces derniers avec ceux de l’enseignement privé ou séparément, selon la même méthode de calcul. \nBien que cette option n’ait pas été retenue ici, veuillez noter qu’il est également possible de soutenir les prestataires de services non étatiques, par exemple en finançant la rémunération des enseignants et/ou en versant des subventions proportionnelles au nombre d’élèves. Le calcul des coûts correspondants apparaîtrait alors ici. Par exemple, pour calculer le coût d’une subvention proportionnelle au nombre d’élèves, il faudra multiplier le taux de scolarisation dans les établissements/centres privés ou communautaires par le montant de cette subvention. Les coûts correspondants seront ajoutés au total lors de la dernière étape de projection des coûts du sous-secteur.",null,null,"59:61",null,"59:61"]
["62:64","Le nombre d’élèves scolarisés dans le système public est ensuite calculé en déduisant du nombre d’élèves à scolariser le nombre d’élèves fréquentant des établissements/centres privés (et/ou communautaires). Les calculs suivants concernent le coût des enfants scolarisés dans le système public.",null,null,"62:64",null,"62:64"]
["66:70","Le principal poste de dépenses de l’enseignement préscolaire, comme des autres niveaux d’enseignement, est la rémunération des enseignants/éducateurs/assistants…\nLes cibles sont exprimées en taux d’encadrement, c’est-à-dire le nombre d’élèves par adulte de différentes catégories/fonctions. Ici, la politique vise à assurer la présence d’un moniteur ou d’un auxiliaire pour 17 élèves (ligne 68) et à faire passer le nombre d’enseignants disponibles de 1 pour 166 élèves à 1 pour 75 (ligne 67).  ",null,null,"66:70",null,"66:70"]
["73:79","On calcule ensuite le nombre de nouveaux enseignants et moniteurs/auxiliaires à recruter (et à former au cas où les effectifs de professionnels formés seraient insuffisants). Ces chiffres permettent d’évaluer la faisabilité de la politique (« Les instituts de formation des enseignants sont-ils en mesure de former autant de professionnels ? ») et de calculer le coût de formation des enseignants (à un stade ultérieur).",null,null,"73:79",null,"73:79"]
["80:80,82:82","On estime ensuite le salaire moyen d’un enseignant/éducateur/moniteur (c.-à-d. la rémunération moyenne perçue individuellement). Ici, la cible établie porte sur la rémunération annuelle d’un enseignant. Il est également possible de prévoir une augmentation annuelle des salaires ou, dans les rares cas où la rémunération par enseignant est trop élevée, de geler les salaires pendant quelques années.\nVeuillez noter qu’il est possible de définir différents salaires et de fixer des cibles différenciées selon les types d’enseignants ou leurs catégories/niveaux :\nsi votre système d’EPE se compose d’enseignants fonctionnaires et vacataires, leurs salaires sont probablement très différents. Dans ce cas, ils seront estimés séparément. Ce point est particulièrement important lorsqu’un choix de politique modifie sensiblement les proportions respectives de ces deux groupes en vue de : titulariser tous les enseignants vacataires dans la fonction publique, ou recruter uniquement des enseignants vacataires afin d’appuyer le développement de l’EPE (par exemple).\nDans la mesure du possible, le salaire moyen doit correspondre au coût total de rémunération des enseignants incluant non seulement le salaire qui leur est versé, mais également les coûts liés aux avantages perçus (sécurité sociale, cotisation retraite, etc.). Si cela n’est pas possible, ces coûts seront inclus implicitement dans les frais administratifs (comme c’est le cas ici).",null,null,"80:80,82:82",null,"80:80,82:82"]
["81:81","Ici, la rémunération des enseignants est également exprimée en multiples du PIB par habitant à des fins d’information/de vérification, le but étant de comparer leur niveau de rémunération par rapport à la richesse moyenne du pays. Ici, la politique salariale a pour effet une moindre rémunération des éducateurs et des moniteurs par rapport aux autres groupes de population (leur salaire est passé de 1,6 fois à 1,3 fois le PIB par habitant, car les salaires ont progressé moins rapidement que l’augmentation prévue du PIB par habitant).\nCette étape n’est pas indispensable, mais elle apporte des informations et permet de vérifier que l’évolution prévue des salaires est « raisonnable ».",null,null,"81:81",null,"81:81"]
["83:85","On calcule ensuite le total de la masse salariale des enseignants, des moniteurs et des assistants (c.-à-d. le montant total de toutes les rémunérations qui leur sont versées) en multipliant le salaire annuel moyen par le nombre d’enseignants, de moniteurs et d’assistants.\nS’il existe différentes catégories d’enseignants (par exemple, fonctionnaires et vacataires), on multiplie leurs salaires respectifs par leurs effectifs estimés, puis on additionne la masse salariale de chaque catégorie afin d’obtenir la masse salariale totale.",null,null,"83:85",null,"83:85"]
["86:88","Dans ce cas, l’augmentation des effectifs disponibles et la meilleure gestion du personnel devraient entraîner la disparition des heures supplémentaires (rémunération perçue au titre des heures de travail effectuées au-delà du temps de travail contractuel), lesquelles représentent 6,6 % de la rémunération totale des enseignants pour l’année de référence.\nCette étape n’est pas indispensable si le volume d’heures supplémentaires est peu important dans votre système.",null,null,"86:88",null,"86:88"]
["89:90","Le salaire du personnel préscolaire (par exemple, personnel administratif ou agents d’entretien) est calculé en pourcentage du total (lequel devrait diminuer) puis additionné afin d’obtenir la masse salariale totale.",null,null,"89:90",null,"89:90"]
["92:100","Les dépenses administratives et pédagogiques (administration générale, supports d’enseignement et d’apprentissage, inspecteurs…) sont estimées en pourcentage de la masse salariale. Ainsi, il est possible d’évaluer ces dépenses sans entrer dans le détail à ce stade (projection globale à long terme). Cette estimation est justifiée par le fait que la masse salariale est un indicateur indirect du nombre de classes. Plus le nombre d’élèves scolarisés est élevé, plus les besoins augmentent en matière de recrutement d’enseignants, d’achat de matériel pédagogique, de gestion du personnel enseignant, etc.\nIci, l’amélioration de la qualité de l’apprentissage préscolaire grâce à un environnement d’apprentissage plus favorable et un meilleur équipement des écoles devrait entraîner une augmentation des dépenses administratives et pédagogiques, qui passeraient d’un niveau quasi nul pour l’année de référence à environ 5 % de la masse salariale.\nEn revanche, les dépenses administratives au niveau central devraient légèrement baisser en pourcentage de la masse salariale totale (sous l’effet des économies d’échelle) malgré une hausse prévue en valeur nominale.",null,null,"92:100",null,"92:100"]
["101:107","Le Ministère a prévu d’augmenter l’enveloppe allouée à la prise en charge des enfants présentant des besoins éducatifs particuliers. La politique d’éducation inclusive prévoit l’accueil de tous les enfants dans la même salle de classe, quels que soient leur handicap, leur incapacité ou leur vulnérabilité. La politique relative aux besoins éducatifs particuliers prévoit le versement de subventions aux établissements scolaires en vue de financer les coûts additionnels engendrés par la situation particulière de ces enfants. D’après les estimations, d’ici à 2030, les enfants présentant des besoins éducatifs particuliers devraient représenter environ 5 % du total des élèves scolarisés dans l’enseignement préscolaire, contre moins de 1 % pour l’année de référence.",null,null,"101:107",null,"101:107"]
["108:113","En l’absence de bourses dans l’enseignement préscolaire, les « dépenses sociales » concernent ici les programmes d’alimentation scolaire. Elles sont calculées directement en multipliant le nombre d’élèves par le nombre de repas servis chaque année et le coût unitaire d’un repas.",null,null,"108:113",null,"108:113"]
["114:117","Enfin, on calcule le total des coûts consacrés à l’enseignement préscolaire en additionnant la masse salariale, les dépenses pédagogiques et administratives, le coût de la prise en charge des besoins éducatifs particuliers et les frais de restauration scolaire.\nLe coût unitaire, c’est-à-dire le coût total divisé par le nombre d’élèves scolarisés dans l’enseignement public, est calculé et exprimé en pourcentage du PIB par habitant afin de mettre en perspective l’augmentation totale.\nNous pouvons observer ici que les dépenses totales consacrées à l’enseignement préscolaire devraient augmenter de 71 % (passant de 51 millions à 87,6 millions de dobras). Le coût unitaire augmentera également de 41 % en valeur nominale, toutefois il baissera en pourcentage du PIB par habitant sous l’effet de la diminution en pourcentage du salaire des enseignants.",null,null,"114:117",null,"114:117"]
["118:433","Le modèle de simulation porte également sur d’autres niveaux d’enseignement, dans une optique de conception stratégique sectorielle. Ces lignes sont masquées ici afin de mettre l’accent sur l’enseignement préscolaire.",null,null,"118:433",null,"118:433"]
["434:436","Parmi les dépenses consacrées aux autres niveaux d’enseignement, celles relatives à la formation des enseignants/éducateurs préscolaires présentent un intérêt particulier pour la politique d’EPE. Ici, la formation initiale des enseignants est assurée par l’institut de formation supérieure en éducation et communication (ISEC).  ",null,null,"434:436",null,"434:436"]
["438:438,444:448","Le nombre requis d’enseignants diplômés de l’ISEC est estimé en fonction des besoins en nouveaux enseignants calculés ci-dessus. On calcule d’abord le nombre de diplômés nécessaires pour répondre aux besoins en nouveaux enseignants d’ici à la 5e année, puis on estime le nombre moyen qui sera nécessaire sur les cinq prochaines années.  ",null,null,"438:438,444:448",null,"438:438,444:448"]
["474:487","Le coût de formation des enseignants (tous niveaux confondus) est calculé par composante : 1) salaire des enseignants de l’ISEC*, 2) autres frais de personnel en pourcentage de la masse salariale des enseignants de l’ISEC, 3) transferts et dépenses administratives et pédagogiques en coût unitaire par stagiaire, et 4) bourses allouées aux stagiaires défavorisés (environ 50 %).\nOn obtient ainsi le coût de formation des enseignants. Une partie de ce coût peut être imputée à l’EPE, par exemple au prorata du nombre d’enseignants stagiaires dans l’EPE (ligne 438).\n* Dans les faits, l’estimation de la masse salariale de l’ISEC à partir de cette composante est discutable, car cette dernière n’est pas liée au nombre d’enseignants en formation (lequel décroît vers la fin de la période prévue). Le coût unitaire par stagiaire devrait donc passer de 1,9 à 1,5 avant de remonter à 5,5. Une hypothèse fondée sur une augmentation contrôlée du coût unitaire, qui serait alors multiplié par le nombre de stagiaires, semble une solution plus adaptée.",null,null,"474:487",null,"474:487"]
["489:500","Le dernier type de coûts à estimer concerne les coûts d’investissement, en particulier dans les infrastructures. ",null,null,"489:500",null,"489:500"]
["493:494","Le nombre de salles de classe est estimé à partir du nombre de salles de classe d’enseignement préscolaire calculé ci-dessus et d’un nombre déterminé de classes par salle. ",null,null,"493:494",null,"493:494"]
["492:492,494:495","Le coût total de construction de nouvelles salles de classe est calculé en multipliant le nombre de nouvelles salles de classe nécessaires par le coût unitaire d’une salle de classe (équipements inclus).",null,null,"492:492,494:495",null,"492:492,494:495"]
["496:499","Les frais d’entretien sont estimés à partir du pourcentage de salles de classe susceptibles de requérir des travaux d’entretien chaque année et du prix moyen de ces travaux.",null,null,"496:499",null,"496:499"]
["500:500","Pour finir, on calcule le total des dépenses d’investissement.\nIci, les dépenses d’investissement portent uniquement sur les salles de classe (équipements inclus), mais elles peuvent également couvrir (notamment dans les autres niveaux) les manuels et le matériel d’apprentissage, les équipements informatiques, etc.",null,null,"500:500",null,"500:500"]