{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Rec x Desp","Cronog"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Rec x Desp","index":0,"n_rows":235,"n_cols":15,"rows_kept":235,"cut":false,"hidden":false,"merged":[[7,1,7,8],[3,1,3,10],[0,1,0,10],[1,1,1,10],[2,1,2,10],[4,1,4,10],[6,1,6,8],[9,1,9,8],[10,1,10,8],[11,1,11,8],[12,1,12,8],[13,1,13,8],[22,1,22,8],[23,1,23,8],[24,1,24,8],[6,9,6,10],[7,9,7,10],[8,9,8,10],[14,9,14,10],[15,9,15,10],[16,9,16,10],[14,1,14,8],[15,1,15,8],[16,1,16,8],[18,1,18,8],[19,1,19,8],[20,1,20,8],[8,1,8,8],[9,9,9,10],[10,9,10,10],[11,9,11,10],[12,9,12,10],[13,9,13,10],[24,9,24,10],[17,1,17,8],[17,9,17,10],[27,1,27,10],[32,4,32,10],[29,1,29,4],[30,1,30,4],[31,1,31,4],[32,1,32,3],[18,9,18,10],[19,9,19,10],[20,9,20,10],[21,9,21,10],[22,9,22,10],[23,9,23,10],[21,1,21,8]]}
[]
[null,"GUIA RÁPIDO DE IMPLANTAÇÃO DE PLANOS FAMÍLIA"]
[null,"Planilha Modelo de Avaliação da Viabilidade de criação do Plano Instituído"]
[null,"Orientações gerais: Habilite as macros para funcionamento completo da Planilha. Preencha os parâmetros de acordo com as orientações (passe o mouse sobre as céculas para obter mais informações)."]
[null,"Parâmetros"]
[]
[null,"Fundo Administrativo Compartilhado (Fundo de Fomento/PGA da Entidade) disponível para o projeto (R$)"]
[null,"Dotação Inicial para custear o projeto (R$)",null,null,null,null,null,null,null,0]
[null,"Valor médio da hora de trabalho da equipe interna da EFPC (R$/hora)",null,null,null,null,null,null,null,0]
[null,"Taxa de juros mensal para atualização dos valores futuros (% a.m.)",null,null,null,null,null,null,null,3.5000000000000001E-3]
[null,"Prazo estimado do projeto até a impltanação do plano (meses)",null,null,null,null,null,null,null,18]
[null,"Estimativa de horas gastas (média mensal) da equipe interna no prazo estimado para a implantação do plano (horas/mês)",null,null,null,null,null,null,null,200]
[null,"Despesa com consultoria na fase de reflexões iniciais e estudo de viabilidade - fase pré-operacional (R$)",null,null,null,null,null,null,null,15000]
[null,"Despesa com consultoria na montagem e acompanhamento do processo Previc (R$)",null,null,null,null,null,null,null,15000]
[null,"Despesas com prestadores de serviço para adaptação da infraestrutura tecnológica (R$)",null,null,null,null,null,null,null,50000]
[null,"Despesas fixas mensais atribuídas ao plano família (R$)",null,null,null,null,null,null,null,5000]
[null,"Incremento médio de despesa mensal por participante (R$ mensal/participante)",null,null,null,null,null,null,null,5]
[null,"Estimativa de novos ingressos mês - 1º ano de funcionamento (nº participantes)",null,null,null,null,null,null,null,200]
[null,"Estimativa de novos ingressos mês - a partir do 2º ano de funcionamento (nº participantes)",null,null,null,null,null,null,null,200]
[null,"Taxa de saída mês (% de participantes desligados)",null,null,null,null,null,null,null,0.01]
[null,"Contribuição média mensal (R$/mês)",null,null,null,null,null,null,null,200]
[null,"Percentual da contribuição destinada ao custeio dos benefícios de risco - Seguradora (% sobre contribuição)",null,null,null,null,null,null,null,0.15]
[null,"Taxa de carregamento (% sobre contribuição)",null,null,null,null,null,null,null,0]
[null,"Taxa de administração (% ao ano sobre o patrimônio)",null,null,null,null,null,null,null,0.01]
[null,"Pró-labore seguradora (% dos prêmios mensais arrecadados)",null,null,null,null,null,null,null,0.2]
[]
[]
[null,"Resultados"]
[]
[null,"Valor utilizado do Fundo Administrativo (PGA) dos demais planos da EFPC",null,null,null,{"$f":"MAX(0,-NPV(J10,O36:O235))","v":109993.14751375969}]
[null,"Mês de operação em que ocorreu a amortização total",null,null,null,{"$f":"IF(F30=0,\"Não houve utilização de PGA dos demais planos da EFPC\",IF((VLOOKUP(0,$M$36:$N$235,2)+1)=183,\"Superior a 15 anos.\",VLOOKUP(0,$M$36:$N$235,2)+1))","v":33}]
[null,"Atende ao requisito legal de amortização em 60 meses?",null,null,null,{"$f":"IF(F31>60,\"Não. É necessário elevar receitas e/ou reduzir despesas\",\"Sim\")","v":"Sim"}]
[null,{"$f":"\"Procurar ponto de equilíbrio ajustando o parâmetro:\"","v":"Procurar ponto de equilíbrio ajustando o parâmetro:"},null,null,null,null,null,null,null,null,null,{"$f":"MATCH(E33,B7:B25,0)","v":{"$error":"#N/A"}}]
[]
["Mês","Fase","Nº Participantes","Saldo Acumulado","Despesas Pessoal Pré-Operacional","Despesas Consult / Prest Serv Pré-operacional","Despesas fixas operacionais","Despesas variáveis operacionais","Receitas Iniciais","Receita Taxa Carreg","Receita Taxa Adm","Receita Pró-labore","Fundo Adm Plano","Mês de operação","Utilização do Fundo Adm dos demais Planos"]
[1,{"$f":"IF(A36>$J$11,\"Operacional\",\"Pré-operacional\")","v":"Pré-operacional"},{"$f":"IF(B36=\"Pré-operacional\",0,INT(IF(N36<13,$J$18,$J$19)+(C35*(1-$J$20))))","v":0},null,{"$f":"IF(B36=\"Pré-operacional\",$J$12*$J$9,0)","v":0},{"$f":"IF(B36=\"Pré-operacional\",($J$13+$J$14+$J$15)/$J$11,0)","v":4444.4444444444443},{"$f":"IF(B36=\"Operacional\",$J$16,0)","v":0},{"$f":"C36*$J$17","v":0},{"$f":"J7+J8","v":0},{"$f":"C36*$J$21*(1-$J$22)*$J$23","v":0},{"$f":"(((1+$J$24)^(1/12))-1)*D36","v":0},{"$f":"C36*$J$21*$J$22*$J$25","v":0},{"$f":"SUM(I36:L36)-SUM(E36:H36)","v":-4444.4444444444443},{"$f":"MAX(0,A36-$J$11)","v":0},{"$f":"MIN(0,-SUM(E36:H36)+SUM(I36:L36)+MAX(0,M35))","v":-4444.4444444444443}]
[2,"Pré-operacional",0,{"$f":"((D36*(1+$J$10))*(1-$J$20))+C37*$J$21*(1-$J$22)*(1-$J$23)","v":0},0,4444.4444444444443,0,0,null,0,0,0,{"$f":"M36*(1+$J$10)+SUM(I37:L37)-SUM(E37:H37)","v":-8904.4444444444453},0,{"$f":"MIN(0,-SUM(E37:H37)+SUM(I37:L37)+MAX(0,M36))","v":-4444.4444444444443}]
[3,"Pré-operacional",0,0,0,4444.4444444444443,0,0,null,0,0,0,-13380.054444444446,0,-4444.4444444444443]
[4,"Pré-operacional",0,0,0,4444.4444444444443,0,0,null,0,0,0,-17871.329079444447,0,-4444.4444444444443]
[5,"Pré-operacional",0,0,0,4444.4444444444443,0,0,null,0,0,0,-22378.323175666948,0,-4444.4444444444443]
[6,"Pré-operacional",0,0,0,4444.4444444444443,0,0,null,0,0,0,-26901.091751226228,0,-4444.4444444444443]
[7,"Pré-operacional",0,0,0,4444.4444444444443,0,0,null,0,0,0,-31439.690016799967,0,-4444.4444444444443]
[8,"Pré-operacional",0,0,0,4444.4444444444443,0,0,null,0,0,0,-35994.17337630321,0,-4444.4444444444443]
[9,"Pré-operacional",0,0,0,4444.4444444444443,0,0,null,0,0,0,-40564.597427564717,0,-4444.4444444444443]
[10,"Pré-operacional",0,0,0,4444.4444444444443,0,0,null,0,0,0,-45151.017963005645,0,-4444.4444444444443]
[11,"Pré-operacional",0,0,0,4444.4444444444443,0,0,null,0,0,0,-49753.490970320614,0,-4444.4444444444443]
[12,"Pré-operacional",0,0,0,4444.4444444444443,0,0,null,0,0,0,-54372.072633161188,0,-4444.4444444444443]
[13,"Pré-operacional",0,0,0,4444.4444444444443,0,0,null,0,0,0,-59006.819331821702,0,-4444.4444444444443]
[14,"Pré-operacional",0,0,0,4444.4444444444443,0,0,null,0,0,0,-63657.787643927528,0,-4444.4444444444443]
[15,"Pré-operacional",0,0,0,4444.4444444444443,0,0,null,0,0,0,-68325.034345125721,0,-4444.4444444444443]
[16,"Pré-operacional",0,0,0,4444.4444444444443,0,0,null,0,0,0,-73008.6164097781,0,-4444.4444444444443]
[17,"Pré-operacional",0,0,0,4444.4444444444443,0,0,null,0,0,0,-77708.591011656768,0,-4444.4444444444443]
[18,"Pré-operacional",0,0,0,4444.4444444444443,0,0,null,0,0,0,-82425.015524642004,0,-4444.4444444444443]
[19,"Operacional",200,34000,0,0,5000,1000,null,0,28.204295887769515,1200,-87485.298783090489,1,-4771.7957041122299]
[20,"Operacional",398,101437.81,0,0,5000,1990,null,0,84.146529630804281,2388,-92309.350799200503,2,-4517.8534703691957]
[21,"Operacional",594,201754.91391165002,0,0,5000,2970,null,0,167.36339084634244,3564,-96871.070136151378,3,-4238.6366091536574]
[22,"Operacional",788,334396.44554923743,0,0,5000,3940,null,0,277.39459688497351,4728,-101144.72428474294,4,-3934.6054031150261]
[23,"Operacional",980,498811.1647775732,0,0,5000,4900,null,0,413.78287304440084,5880,-105104.94794669515,5,-3606.2171269555993]
[24,"Operacional",1170,694451.43381575169,0,0,5000,5850,null,0,576.0739329125073,7020,-108726.74133159607,6,-3253.9260670874928]
[25,"Operacional",1358,920773.1936957658,0,0,5000,6790,null,0,763.81645883887916,8148,-111985.46846741778,7,-2878.183541161121]
[26,"Operacional",1544,1177235.940874964,0,0,5000,7720,null,0,976.56208253394777,9264,-114856.85552451981,8,-2479.4379174660517]
[27,"Operacional",1728,1463302.7040013461,0,0,5000,8640,null,0,1213.8653657949171,10368,-117316.98915306071,9,-2058.134634205082]
[28,"Operacional",1910,1778440.0208306974,0,0,5000,9550,null,0,1475.2837813576461,11460,-119342.31483373878,10,-1614.7162186423539]
[29,"Operacional",2090,2122117.915294569,0,0,5000,10450,null,0,1760.3776938736655,12540,-120909.63524178321,11,-1149.6223061263336]
[30,"Operacional",2269,2493979.8747181194,0,0,5000,11345,null,0,2068.8513624909465,13614,-121994.9676026385,12,-662.14863750905351]
[31,"Operacional",2446,2893501.7162368367,0,0,5000,12230,null,0,2400.2699575444894,14676,-122575.68003170326,13,-153.73004245551056]
[32,"Operacional",2621,3320162.6825212291,0,0,5000,13105,null,0,2754.201490981156,15726,-122629.49342083308,14,0]
[33,{"$f":"IF(A68>$J$11,\"Operacional\",\"Pré-operacional\")","v":"Operacional"},{"$f":"IF(B68=\"Pré-operacional\",0,INT(IF(N68<13,$J$18,$J$19)+(C67*(1-$J$20))))","v":2794},3773445.4193909531,{"$f":"IF(B68=\"Pré-operacional\",$J$12*$J$9,0)","v":0},{"$f":"IF(B68=\"Pré-operacional\",($J$13+$J$14+$J$15)/$J$11,0)","v":0},{"$f":"IF(B68=\"Operacional\",$J$16,0)","v":5000},{"$f":"C68*$J$17","v":13970},null,{"$f":"C68*$J$21*(1-$J$22)*$J$23","v":0},{"$f":"(((1+$J$24)^(1/12))-1)*D68","v":3130.2167977897343},{"$f":"C68*$J$21*$J$22*$J$25","v":16764},-122134.47985001627,{"$f":"MAX(0,A68-$J$11)","v":15},0]
[34,"Operacional",2966,4253005.953575233,0,0,5000,14830,null,0,3528.0305390318003,17796,{"$f":"M68*(1+$J$10)+SUM(I69:L69)-SUM(E69:H69)","v":-121067.91999045954},16,0]
[35,"Operacional",3136,4758332.5596686192,0,0,5000,15680,null,0,3947.2182189794539,18816,-119408.43949144671,17,0]
[36,"Operacional",3304,5288916.856391185,0,0,5000,16520,null,0,4387.3581159843752,19824,-117135.0109136824,18,0]
[37,"Operacional",3470,5844253.7847346691,0,0,5000,17350,null,0,4848.0312643492189,20820,-114226.95218753107,19,0]
[38,"Operacional",3635,6424011.5862514284,0,0,5000,18175,null,0,5328.962457796908,21810,-110662.78406239054,20,0]
[39,"Operacional",3798,7027690.6705352757,0,0,5000,18990,null,0,5829.737267043949,22788,-106422.36653956496,21,0]
[40,"Operacional",3960,7654964.7120033288,0,0,5000,19800,null,0,6350.0849925816538,23760,-101484.75982987178,22,0]
[41,"Operacional",4120,8305339.5176103879,0,0,5000,20600,null,0,6889.595682443186,24720,-95830.360806833138,23,0]
[42,"Operacional",4278,8978324.123862803,0,0,5000,21390,null,0,7447.8620636978085,25668,-89439.905005959241,24,0]
[43,"Operacional",4435,9673600.7757133599,0,0,5000,22175,null,0,8024.6205464228324,26610,-82293.324127057276,25,0]
[44,"Operacional",4590,10390683.794644073,0,0,5000,22950,null,0,8619.4682417762688,27540,-74371.88251972571,26,0]
[45,"Operacional",4744,11129260.676046073,0,0,5000,23720,null,0,9232.1459152741536,28464,-65656.038193270593,27,0]
[46,"Operacional",4896,11888850.957528112,0,0,5000,24480,null,0,9862.255005050436,29376,-56127.579321896614,28,0]
[47,"Operacional",5047,12669147.316520667,0,0,5000,25235,null,0,10509.540575320294,30282,-45767.485274202962,29,0]
[48,"Operacional",5196,13469674.438807204,0,0,5000,25980,null,0,11173.608334824828,31176,-34558.063137837846,30,0]
[49,"Operacional",5344,14290130.1163496,0,0,5000,26720,null,0,11854.20759047795,32064,-22480.808768342329,31,0]
[50,"Operacional",5490,15130044.116039256,0,0,5000,27450,null,0,12550.948265993451,32940,-9518.5433330380765,32,0]
[51,"Operacional",5635,15989119.277740939,0,0,5000,28175,null,0,13263.583855713088,33810,4346.7256210093838,33,0]
[52,"Operacional",5778,16866890.383260902,0,0,5000,28890,null,0,13991.728443413665,34668,19131.667604096583,34,0]
[53,"Operacional",5920,17763065.254606295,0,0,5000,29600,null,0,14735.139656313939,35520,34853.768097024862,35,0]
[54,"Operacional",6060,18677183.623167444,0,0,5000,30300,null,0,15493.435684059343,36360,51529.191969423788,36,0]
[55,"Operacional",6199,19608958.228190046,0,0,5000,30995,null,0,16266.378232905432,37194,69174.922374222195,37,0]
[56,"Operacional",6337,20558103.686168823,0,0,5000,31685,null,0,17053.730566357372,38022,87807.765168889338,38,0]
[57,"Operacional",6473,21524166.478579711,0,0,5000,32365,null,0,17855.116473513888,38838,107443.20882049436,39,0]
[58,"Operacional",6608,22506866.050642192,0,0,5000,33040,null,0,18670.303223491381,39648,128097.56327485747,40,0]
[59,"Operacional",6741,23505753.681001246,0,0,5000,33705,null,0,19498.918584823135,40446,149785.82333114263,41,0]
[60,"Operacional",6873,24520553.580695905,0,0,5000,34365,null,0,20340.733780054517,41238,172523.80749285617,42,0]
[61,"Operacional",7004,25550991.763046056,0,0,5000,35020,null,0,21195.521526791548,42024,196327.16234587273,43,0]
[62,"Operacional",7133,26596626.031874552,0,0,5000,35665,null,0,22062.915006451265,42798,221210.22242053458,44,0]
[63,"Operacional",7261,27657187.080756251,0,0,5000,36305,null,0,22942.690819089577,43566,247188.14901809604,45,0]
[64,"Operacional",7388,28732407.36318351,0,0,5000,36940,null,0,23834.627024681035,44328,274275.93456434039,46,0]
[65,{"$f":"IF(A100>$J$11,\"Operacional\",\"Pré-operacional\")","v":"Operacional"},{"$f":"IF(B100=\"Pré-operacional\",0,INT(IF(N100<13,$J$18,$J$19)+(C99*(1-$J$20))))","v":7514},29822021.081065107,{"$f":"IF(B100=\"Pré-operacional\",$J$12*$J$9,0)","v":0},{"$f":"IF(B100=\"Pré-operacional\",($J$13+$J$14+$J$15)/$J$11,0)","v":0},{"$f":"IF(B100=\"Operacional\",$J$16,0)","v":5000},{"$f":"C100*$J$17","v":37570},null,{"$f":"C100*$J$21*(1-$J$22)*$J$23","v":0},{"$f":"(((1+$J$24)^(1/12))-1)*D100","v":24738.503133578248},{"$f":"C100*$J$21*$J$22*$J$25","v":45084},302488.40346889384,{"$f":"MAX(0,A100-$J$11)","v":47},0]
[66,"Operacional",7638,{"$f":"((D100*(1+$J$10))*(1-$J$20))+C101*$J$21*(1-$J$22)*(1-$J$23)","v":30925594.173300348},0,0,5000,38190,null,0,25653.95907555423,45828,{"$f":"M100*(1+$J$10)+SUM(I101:L101)-SUM(E101:H101)","v":331839.07195658918},48,{"$f":"MIN(0,-SUM(E101:H101)+SUM(I101:L101)+MAX(0,M100))","v":0}]
[67,"Operacional",7761,32042865.415377829,0,0,5000,38805,null,0,26580.778154920379,46566,362342.28686335764,49,0]
[68,"Operacional",7883,33173575.289888337,0,0,5000,39415,null,0,27518.745092094414,47298,394012.22995947383,50,0]
[69,"Operacional",8004,34317465.975368917,0,0,5000,40020,null,0,28467.646014346112,48024,426862.91877867811,51,0]
[70,"Operacional",8123,35474111.335219882,0,0,5000,40615,null,0,29427.127425124119,48738,460907.06641952763,52,0]
[71,"Operacional",8241,36643258.017644219,0,0,5000,41205,null,0,30396.979159456474,49446,496158.22031145252,53,0]
[72,"Operacional",8358,37824654.326498911,0,0,5000,41790,null,0,31376.992425799312,50148,532629.766508342,54,0]
[73,"Operacional",8474,39018050.210475236,0,0,5000,42370,null,0,32366.959797061503,50844,570334.9304881827,55,0]
[74,"Operacional",8589,40223197.252349779,0,0,5000,42945,null,0,33366.675201687969,51534,609286.77794657939,56,0]
[75,"Operacional",8703,41439848.658305675,0,0,5000,43515,null,0,34375.93391480123,52218,649498.21558419371,57,0]
[76,"Operacional",8815,42667589.247323647,0,0,5000,44075,null,0,35394.391527921442,52890,690980.85086665989,58,0]
[77,"Operacional",8926,43906176.551592387,0,0,5000,44630,null,0,36421.846904757629,53556,733747.13074945088,59,0]
[78,"Operacional",9036,45155369.687827736,0,0,5000,45180,null,0,37458.100223444468,54216,777809.34593051835,60,0]
[79,"Operacional",9145,46414929.346917778,0,0,5000,45725,null,0,38502.952967952522,54870,823179.63160922774,61,0]
[80,"Operacional",9253,47684617.783635676,0,0,5000,46265,null,0,39556.20791955461,55518,869869.96823941474,62,0]
[81,"Operacional",9360,48964198.806419618,0,0,5000,46800,null,0,40617.669148347937,56160,917892.18227660062,63,0]
[82,"Operacional",9466,50253437.76721967,0,0,5000,47330,null,0,41687.142004831614,56796,967257.94691940036,64,0]
[83,"Operacional",9571,51552101.551410891,0,0,5000,47855,null,0,42764.433111539256,57426,1017978.7828451577,65,0]
[84,"Operacional",9675,52859958.567772426,0,0,5000,48375,null,0,43849.350354726201,58050,1070066.058939842,66,0]
[85,"Operacional",9778,54176778.738532037,0,0,5000,48890,null,0,44941.702876111121,58668,1123530.9930222426,67,0]
[86,"Operacional",9880,55502333.489475735,0,0,5000,49400,null,0,46041.301064671548,59280,1178384.6525624921,68,0]
[87,"Operacional",9981,56836395.74012202,0,0,5000,49905,null,0,47147.956548493064,59886,1234637.955394954,69,0]
[88,"Operacional",10081,58178739.893960327,0,0,5000,50405,null,0,48261.482186671688,60486,1292301.6704255082,70,0]
[89,"Operacional",10180,59529141.8287533,0,0,5000,50900,null,0,49381.692061269263,61080,1351386.4183332666,71,0]
[90,"Operacional",10278,60887378.886902399,0,0,5000,51390,null,0,50508.401469321347,61668,1411902.6722667543,72,0]
[91,"Operacional",10375,62253229.865876496,0,0,5000,51875,null,0,51641.426914897376,62250,1473860.7585345854,73,0]
[92,"Operacional",10471,63626475.008702993,0,0,5000,52355,null,0,52780.586101212699,62826,1537270.8572906693,74,0]
[93,"Operacional",10566,65006895.994521126,0,0,5000,52830,null,0,53925.69792279214,63396,1602143.0032139788,75,0]
[94,"Operacional",10660,66394275.929196939,0,0,5000,53300,null,0,55076.582457684817,63960,1668487.0861829128,76,0]
[95,"Operacional",10753,67788399.335999638,0,0,5000,53765,null,0,56233.060959729773,64518,1736312.8519442829,77,0]
[96,"Operacional",10845,69189052.14633888,0,0,5000,54225,null,0,57394.95585087224,65070,1805629.9027769603,78,0]
[97,{"$f":"IF(A132>$J$11,\"Operacional\",\"Pré-operacional\")","v":"Operacional"},{"$f":"IF(B132=\"Pré-operacional\",0,INT(IF(N132<13,$J$18,$J$19)+(C131*(1-$J$20))))","v":10936},70596021.690562561,{"$f":"IF(B132=\"Pré-operacional\",$J$12*$J$9,0)","v":0},{"$f":"IF(B132=\"Pré-operacional\",($J$13+$J$14+$J$15)/$J$11,0)","v":0},{"$f":"IF(B132=\"Operacional\",$J$16,0)","v":5000},{"$f":"C132*$J$17","v":54680},null,{"$f":"C132*$J$21*(1-$J$22)*$J$23","v":0},{"$f":"(((1+$J$24)^(1/12))-1)*D132","v":58562.090713530029},{"$f":"C132*$J$21*$J$22*$J$25","v":65616},1876447.6981502098,{"$f":"MAX(0,A132-$J$11)","v":79},0]
[98,"Operacional",11026,72009096.688814744,0,0,5000,55130,null,0,59734.290283009854,66156,{"$f":"M132*(1+$J$10)+SUM(I133:L133)-SUM(E133:H133)","v":1948775.5553767455},80,0]
[99,"Operacional",11115,73428067.241953343,0,0,5000,55575,null,0,60911.380439973182,66690,2022622.6502605374,81,0]
[100,"Operacional",11203,74852724.822527185,0,0,5000,56015,null,0,62093.188202951373,67218,2097998.0177394007,82,0]
[101,"Operacional",11290,76282862.26581198,0,0,5000,56450,null,0,63279.541720909678,67740,2174910.5525223981,83,0]
[102,"Operacional",11377,77718443.760904893,0,0,5000,56885,null,0,64470.411287339302,68262,2253370.150743566,84,0]
[103,"Operacional",11463,79159263.730927378,0,0,5000,57315,null,0,65665.626368384052,68778,2333385.5726395524,85,0]
[104,"Operacional",11548,80605117.942445785,0,0,5000,57740,null,0,66865.017544626477,69288,2414965.4396884171,86,0]
[105,"Operacional",11632,82055803.496691912,0,0,5000,58160,null,0,68068.416503805027,69792,2498118.2352311318,87,0]
[106,"Operacional",11715,83511118.820841029,0,0,5000,58575,null,0,69275.656033578765,70290,2582852.3050880195,88,0]
[107,"Operacional",11797,84970863.659346834,0,0,5000,58985,null,0,70486.570014339406,70782,2669175.8581701671,89,0]
[108,"Operacional",11879,86435009.065333009,0,0,5000,59395,null,0,71701.134433549785,71274,2757098.1081073126,90,0]
[109,"Operacional",11960,87903356.281091064,0,0,5000,59800,null,0,72919.184414115152,71760,2846627.1358998036,91,0]
[110,"Operacional",12040,89375707.847794145,0,0,5000,60200,null,0,74140.55615641264,72240,2937770.8870318658,92,0]
[111,"Operacional",12119,90851867.597008809,0,0,5000,60595,null,0,75365.086931249883,72714,3030537.1720677274,93,0]
[112,"Operacional",12197,92331640.642262354,0,0,5000,60985,null,0,76592.615072869783,73182,3124933.6672428343,94,0]
[113,"Operacional",12275,93815003.370665178,0,0,5000,61375,null,0,77823.120993480436,73650,3220969.0560716651,95,0]
[114,"Operacional",12352,95301762.323637888,0,0,5000,61760,null,0,79056.444211816706,74112,3318650.891979733,96,0]
[115,"Operacional",12428,96791725.306852922,0,0,5000,62140,null,0,80292.42529535848,74568,3417986.5953970207,97,0]
[116,"Operacional",12503,98284701.381972641,0,0,5000,62515,null,0,81530.905853477234,75018,3518983.4543343876,98,0]
[117,"Operacional",12577,99780500.858441442,0,0,5000,62885,null,0,82771.728530627137,75462,3621648.6249551852,99,0]
[118,"Operacional",12651,101279105.28533153,0,0,5000,63255,null,0,84014.878021060344,75906,3725990.2731635892,100,0]
[119,"Operacional",12724,102780326.3322919,0,0,5000,63620,null,0,85260.198097572618,76344,3832015.4372172346,101,0]
[120,"Operacional",12796,104283976.89971037,0,0,5000,63980,null,0,86507.533553904475,76776,3939731.0248013996,102,0]
[121,"Operacional",12868,105790041.11067078,0,0,5000,64340,null,0,87756.871219548819,77208,4049144.9546077535,103,0]
[122,"Operacional",12939,107298333.19201255,0,0,5000,64695,null,0,89008.056988588316,77634,4160264.0189374695,104,0]
[123,"Operacional",13009,108808668.58460276,0,0,5000,65045,null,0,90260.937762187867,78054,4273094.8807659391,105,0]
[124,"Operacional",13078,110320863.93540239,0,0,5000,65390,null,0,91515.361442013236,78468,4387644.0742906341,106,0]
[125,"Operacional",13147,111834907.08958454,0,0,5000,65735,null,0,92771.31794517221,78882,4503919.1464958237,107,0]
[126,"Operacional",13215,113350615.97175412,0,0,5000,66075,null,0,94028.656233184884,79290,4621926.5197417447,108,0]
[127,"Operacional",13282,114867809.69637871,0,0,5000,66410,null,0,95287.226254607798,79692,4741672.4888154482,109,0]
[128,"Operacional",13349,116386478.56001288,0,0,5000,66745,null,0,96547.019960063117,80094,4863164.3624863662,110,0]
[129,{"$f":"IF(A164>$J$11,\"Operacional\",\"Pré-operacional\")","v":"Operacional"},{"$f":"IF(B164=\"Pré-operacional\",0,INT(IF(N164<13,$J$18,$J$19)+(C163*(1-$J$20))))","v":13415},117906442.92262319,{"$f":"IF(B164=\"Pré-operacional\",$J$12*$J$9,0)","v":0},{"$f":"IF(B164=\"Pré-operacional\",($J$13+$J$14+$J$15)/$J$11,0)","v":0},{"$f":"IF(B164=\"Operacional\",$J$16,0)","v":5000},{"$f":"C164*$J$17","v":67075},null,{"$f":"C164*$J$21*(1-$J$22)*$J$23","v":0},{"$f":"(((1+$J$24)^(1/12))-1)*D164","v":97807.888331296243},{"$f":"C164*$J$21*$J$22*$J$25","v":80490},4986408.3260863647,{"$f":"MAX(0,A164-$J$11)","v":111},0]
[130,"Operacional",13480,{"$f":"((D164*(1+$J$10))*(1-$J$20))+C165*$J$21*(1-$J$22)*(1-$J$23)","v":119427524.31812385},0,0,5000,67400,null,0,99069.683323886886,80880,{"$f":"M164*(1+$J$10)+SUM(I165:L165)-SUM(E165:H165)","v":5111410.4385515545},112,{"$f":"MIN(0,-SUM(E165:H165)+SUM(I165:L165)+MAX(0,M164))","v":0}]
[131,"Operacional",13545,120949715.44670491,0,0,5000,67725,null,0,100332.39888236448,81270,5238177.7739688503,113,0]
[132,"Operacional",13609,122472839.05626069,0,0,5000,68045,null,0,101595.8879693515,81654,5366716.2841470931,114,0]
[133,"Operacional",13672,123996719.05302803,0,0,5000,68360,null,0,102860.00450835972,82032,5497031.7956499672,115,0]
[134,"Operacional",13735,125521350.4940165,0,0,5000,68675,null,0,104124.74439899017,82410,5629131.1513337325,116,0]
[135,"Operacional",13797,127046558.46853811,0,0,5000,68985,null,0,105389.96254616055,82782,5763020.072909561,117,0]
[136,"Operacional",13859,128572339.20894623,0,0,5000,69295,null,0,106655.6558244644,83154,5898705.2989892093,118,0]
[137,"Operacional",13920,130098518.97221577,0,0,5000,69600,null,0,107921.68010744028,83520,6036192.4476431115,119,0]
[138,"Operacional",13980,131624925.15073235,0,0,5000,69900,null,0,109187.89221049326,83880,6175487.0134203555,120,0]
[139,"Operacional",14040,133151556.26487233,0,0,5000,70200,null,0,110454.29090621912,84240,6316595.5088735456,121,0]
[140,"Operacional",14099,134678240.84468138,0,0,5000,70495,null,0,111720.73395375528,84594,6459523.327108359,122,0]
[141,"Operacional",14158,136204978.54076141,0,0,5000,70790,null,0,112987.22106326271,84948,6604276.8798165014,123,0]
[142,"Operacional",14216,137731599.00599754,0,0,5000,71080,null,0,114253.61092531694,85296,6750861.4598211767,124,0]
[143,"Operacional",14273,139257933.00649333,0,0,5000,71365,null,0,115519.76315395065,85638,6899282.2380845016,125,0]
[144,"Operacional",14330,140783982.41429591,0,0,5000,71650,null,0,116785.67930209829,85980,7049545.4052198958,126,0]
[145,"Operacional",14386,142309579.0892185,0,0,5000,71930,null,0,118051.21989106634,86316,7201656.0340292323,127,0]
[146,"Operacional",14442,143834725.98987046,0,0,5000,72210,null,0,119316.38737513407,86652,7355620.2175234687,128,0]
[147,"Operacional",14497,145359256.05552664,0,0,5000,72485,null,0,120581.04317106253,86982,7511442.9314558636,129,0]
[148,"Operacional",14552,146883173.31720376,0,0,5000,72760,null,0,121845.19062273373,87312,7669130.1723386934,130,0]
[149,"Operacional",14606,148406311.77957582,0,0,5000,73030,null,0,123108.69203069797,87636,7828686.8199725775,131,0]
[150,"Operacional",14659,149928506.5320963,0,0,5000,73295,null,0,124371.41059537143,87954,7990117.6344378535,132,0]
[151,"Operacional",14712,151449763.74190906,0,0,5000,73560,null,0,125633.35143263501,88272,8153428.3975910218,133,0]
[152,"Operacional",14764,152969919.53585568,0,0,5000,73820,null,0,126894.37860345788,88584,8318623.7755860481,134,0]
[153,"Operacional",14816,154488981.11168888,0,0,5000,74080,null,0,128154.49807865027,88896,8485709.4568792507,135,0]
[154,"Operacional",14867,156006785.62012398,0,0,5000,74335,null,0,129413.57476852363,89202,8654690.0147468522,136,0]
[155,"Operacional",14918,157523341.27609649,0,0,5000,74590,null,0,130671.61548768007,89508,8825571.0452861469,137,0]
[156,"Operacional",14968,159038486.24085721,0,0,5000,74840,null,0,131928.48598470876,89808,8998357.0299293585,138,0]
[157,"Operacional",15018,160552229.73327324,0,0,5000,75090,null,0,133184.19390701133,90108,9173053.473441124,139,0]
[158,"Operacional",15067,162064410.91196632,0,0,5000,75335,null,0,134438.60583053413,90402,9349664.7664287016,140,0]
[159,"Operacional",15116,163575039.98665664,0,0,5000,75580,null,0,135691.73022462922,90696,9528196.323335832,141,0]
[160,"Operacional",15164,165083957.10034385,0,0,5000,75820,null,0,136943.43448182198,90984,9708652.4449493308,142,0]
[161,{"$f":"IF(A196>$J$11,\"Operacional\",\"Pré-operacional\")","v":"Operacional"},{"$f":"IF(B196=\"Pré-operacional\",0,INT(IF(N196<13,$J$18,$J$19)+(C195*(1-$J$20))))","v":15212},166591173.44069311,{"$f":"IF(B196=\"Pré-operacional\",$J$12*$J$9,0)","v":0},{"$f":"IF(B196=\"Pré-operacional\",($J$13+$J$14+$J$15)/$J$11,0)","v":0},{"$f":"IF(B196=\"Operacional\",$J$16,0)","v":5000},{"$f":"C196*$J$17","v":76060},null,{"$f":"C196*$J$21*(1-$J$22)*$J$23","v":0},{"$f":"(((1+$J$24)^(1/12))-1)*D196","v":138193.72788270703},{"$f":"C196*$J$21*$J$22*$J$25","v":91272},9891038.456389362,{"$f":"MAX(0,A196-$J$11)","v":143},0]
[162,"Operacional",15259,168096530.12225819,0,0,5000,76295,null,0,139442.4786257509,91554,{"$f":"M196*(1+$J$10)+SUM(I197:L197)-SUM(E197:H197)","v":10075358.569612475},144,0]
[163,"Operacional",15306,169600039.29790923,0,0,5000,76530,null,0,140689.69679222262,91836,10261618.021398341,145,0]
[164,"Operacional",15352,171101543.0410974,0,0,5000,76760,null,0,141935.25137603065,92112,10449820.935849266,146,0]
[165,"Operacional",15398,172601054.45732385,0,0,5000,76990,null,0,143179.15324868768,92388,10639972.462373428,147,0]
[166,"Operacional",15444,174098586.56644523,0,0,5000,77220,null,0,144421.41321066106,92664,10832077.779202396,148,0]
[167,"Operacional",15489,175593982.30323353,0,0,5000,77445,null,0,145661.90097035773,92934,11026140.952399964,149,0]
[168,"Operacional",15534,177087255.6288819,0,0,5000,77670,null,0,146900.62810911948,93204,11222167.073842485,150,0]
[169,"Operacional",15578,178578250.41334715,0,0,5000,77890,null,0,148137.46511112477,93468,11420160.123712059,151,0]
[170,"Operacional",15622,180066981.54689595,0,0,5000,78110,null,0,149372.42432841726,93732,11620125.108473469,152,0]
[171,"Operacional",15665,181553293.822487,0,0,5000,78325,null,0,150605.3770108406,93990,11822065.923363967,153,0]
[172,"Operacional",15708,183037203.04735705,0,0,5000,78540,null,0,151836.33627110018,94248,12025987.490366841,154,0]
[173,"Operacional",15750,184518554.92544258,0,0,5000,78750,null,0,153065.17411473038,94500,12231893.620697856,155,0]
[174,"Operacional",15792,185997366.1690048,0,0,5000,78960,null,0,154291.90440518889,94752,12439789.152775489,156,0]
[175,"Operacional",15834,187473653.38109037,0,0,5000,79170,null,0,155516.54091533573,95004,12649678.955725539,157,0]
[176,"Operacional",15875,188947263.05624494,0,0,5000,79375,null,0,156738.9563065457,95250,12861566.788377125,158,0]
[177,"Operacional",15916,190418212.69217238,0,0,5000,79580,null,0,157959.16509383114,95496,13075457.437230278,159,0]
[178,"Operacional",15956,191886349.67222905,0,0,5000,79780,null,0,159177.04067586921,95736,13291354.578936454,160,0]
[179,"Operacional",15996,193351692.37712103,0,0,5000,79980,null,0,160392.59830015621,95976,13509262.91826289,161,0]
[180,"Operacional",16036,194814259.06743655,0,0,5000,80180,null,0,161605.85311454604,96216,13729187.191591356,162,0]
[181,"Operacional",16075,196273897.88443086,0,0,5000,80375,null,0,162816.67914642196,96450,13951131.025908349,163,0]
[182,"Operacional",16114,197730627.96175611,0,0,5000,80570,null,0,164025.09226787768,96684,14175099.076766908,164,0]
[183,"Operacional",16152,199184298.30802605,0,0,5000,80760,null,0,165230.96722580338,96912,14401094.890761396,165,0]
[184,"Operacional",16190,200634928.91858312,0,0,5000,80950,null,0,166434.32060709773,97140,14629123.043486159,166,0]
[185,"Operacional",16228,202082539.65810019,0,0,5000,81140,null,0,167635.16889026397,97368,14859188.143028626,167,0]
[186,"Operacional",16265,203526980.26143453,0,0,5000,81325,null,0,168833.38742463896,97590,15091293.688953865,168,0]
[187,"Operacional",16302,204968271.44542605,0,0,5000,81510,null,0,170028.99339563106,97812,15325444.210260835,169,0]
[188,"Operacional",16338,206406263.79153019,0,0,5000,81690,null,0,171221.8628548625,98028,15561643.127851611,170,0]
[189,"Operacional",16374,207840978.85765254,0,0,5000,81870,null,0,172412.01368543765,98244,15799894.892484529,171,0]
[190,"Operacional",16410,209272438.06081778,0,0,5000,82050,null,0,173599.46365359481,98460,16040203.988261821,172,0]
[191,"Operacional",16445,210700492.67809033,0,0,5000,82225,null,0,174784.08938799042,98670,16282573.791608728,173,0]
[192,"Operacional",16480,212125164.95843902,0,0,5000,82400,null,0,175965.90934499211,98880,16527008.709224351,174,0]
[193,{"$f":"IF(A228>$J$11,\"Operacional\",\"Pré-operacional\")","v":"Operacional"},{"$f":"IF(B228=\"Pré-operacional\",0,INT(IF(N228<13,$J$18,$J$19)+(C227*(1-$J$20))))","v":16515},213546477.00543565,{"$f":"IF(B228=\"Pré-operacional\",$J$12*$J$9,0)","v":0},{"$f":"IF(B228=\"Pré-operacional\",($J$13+$J$14+$J$15)/$J$11,0)","v":0},{"$f":"IF(B228=\"Operacional\",$J$16,0)","v":5000},{"$f":"C228*$J$17","v":82575},null,{"$f":"C228*$J$21*(1-$J$22)*$J$23","v":0},{"$f":"(((1+$J$24)^(1/12))-1)*D228","v":177144.94186035517},{"$f":"C228*$J$21*$J$22*$J$25","v":99090},16773513.181566991,{"$f":"MAX(0,A228-$J$11)","v":175},0]
[194,"Operacional",16549,{"$f":"((D228*(1+$J$10))*(1-$J$20))+C229*$J$21*(1-$J$22)*(1-$J$23)","v":214964280.77820513},0,0,5000,82745,null,0,178321.06412853123,99294,{"$f":"M228*(1+$J$10)+SUM(I229:L229)-SUM(E229:H229)","v":17022090.541831009},176,{"$f":"MIN(0,-SUM(E229:H229)+SUM(I229:L229)+MAX(0,M228))","v":0}]
[195,"Operacional",16583,216378599.20331958,0,0,5000,82915,null,0,179494.29516798572,99498,17272745.153895404,177,0]
[196,"Operacional",16617,217789455.0575259,0,0,5000,83085,null,0,180664.65387289829,99702,17525481.415806938,178,0]
[197,"Operacional",16650,219196700.96872497,0,0,5000,83250,null,0,181832.0179924957,99900,17780302.618754759,179,0]
[198,"Operacional",16683,220600360.52789435,0,0,5000,83415,null,0,182996.40709639303,100098,18037213.085016795,180,0]
[199,"Operacional",16716,222000457.17184457,0,0,5000,83580,null,0,184157.84062631789,100296,18296217.171440672,181,0]
[200,"Operacional",16748,223396844.18422657,0,0,5000,83740,null,0,185316.19687546673,100488,18557318.128416184,182,0]

{"sheet":"Cronog","index":1,"n_rows":11,"n_cols":25,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,24],[1,0,2,0]]}
[]
["Cronograma modelo de implantação de plano instituído","Meses"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
["Reflexões iniciais sobre o propósito da criação do plano"]
["Definição do meio que se utilizará para criação do plano e das suas fontes de custeio"]
["Elaboração/aprovação do estudo de viabilidade"]
["Elaboração do regulamento, do convênio de adesão e demais documentos para submissão à Previc"]
["Análise pela Previc, atendimento de exigências pela Entidade e aprovação"]
["Preparação para operacionalização do plano"]
["Implantação do plano"]
["Primeira avaliação semestral"]