{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instruções","Contrato de Trabalho","ESTAGIAR","Bolsa","CT - Tabela","Bolsas - Tabela","Estagiar - Tabela","Listas"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":43,"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":"Instruções","index":0,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[2,2,2,8],[3,2,3,8]]}
[]
[]
[null,null,"SIMULADOR DE CUSTOS COM RECURSOS HUMANOS"]
[null,null,"Instruções"]
[]
[null,null,null,null,null,null,null,"Versão","2023-11-08"]
[]
[null,"Para que o simulador funcione corretamente, é necessário seguir os seguintes passos:"]
[]
[null,"1. Depois de descarregar o ficheiro, desbloquer o mesmo."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2. Abrir o ficheiro e clicar em \"Ativar Edição\"."]

{"sheet":"Contrato de Trabalho","index":1,"n_rows":106,"n_cols":16,"rows_kept":106,"cut":false,"hidden":false,"merged":[[43,13,44,13],[43,14,44,14],[43,15,44,15],[2,2,2,15],[3,2,3,15],[41,1,41,6],[26,1,26,6],[13,1,13,6],[21,1,21,6],[22,1,22,6],[11,1,11,6],[12,1,12,6],[19,1,19,6],[20,1,20,6],[40,1,40,6],[36,1,36,6]]}
[]
[]
[null,null,"SIMULADOR DE CUSTOS COM RECURSOS HUMANOS"]
[null,null,"Contrato de Trabalho"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Versão","2024-01-26"]
[]
[null,"Pressupostos de Contratação"]
[]
[null,"Tipo de Termo","Certo"]
[]
[null,"Nos termos do Art.º 60º da Lei Geral do Trabalho em Funções Públicas (LTFP):"]
[null,"1. O contrato a termo certo dura até 3 anos (36 meses), incluido renovações. Este contrato não pode ser renovado mais do que 2 vezes."]
[null,"2. O contrato a termo incerto dura por todo o tempo necessário para a substituição do trabalhador ausente ou para a conclusão da tarefa ou serviço cuja execução justifica a celebração. "]
[]
[null,"Duração (meses)",24]
[]
[null,"Categoria Profissional","Tecnico Superior"]
[]
[null,"Nos termos do Art.º 88º da LTFP, as carreiras gerais são as de Técnico Superior, de Assistente Técnico, e de Assistente Operacional."]
[null,"Nos termos do Art.º 86º e do ponto 2 do Art.º 88º, ambos da LTFP:"]
[null,"1. Os Técnicos Superiores são titulares de licenciatura ou de grau académico superior a esta; e auferem, no minimo, ao equivalente à posição 16 da Tabela Remuneratória Única."]
[null,"2. Os Assistentes Técnicos são titulares do 12.º ano de escolaridade ou de curso equiparado; e auferem, no minimo, ao equivalente à posição 6 da Tabela Remuneratória Única."]
[]
[null,"Tem ou Terá Grau de Doutor?","Nao"]
[]
[null,"Nos termos do Art.º 39º - B da LTFP, os Técnicos Superiores que tenham ou venham a ter o grau de doutor auferem o equivalente ao nivel 23 da Tabela Remuneratória Única; ou, caso já aufiram o equivalente ao referido nível, passam a estar enquadrados na posição imediatamente seguinte àquela em que se encontra."]
[]
[null,"Posição Remuneratória","16 - 1385,99",null,null,null,{"$f":"INT(LEFT(C29,(FIND(\" \",C29,1)-1)))","v":16}]
[]
[null,"Data de Início (Mês/Ano)","2024-01-01"]
[]
[null,"Taxa de IRS",7.0000000000000007E-2]
[]
[null,"Segurança Social - Funcionário",0.11]
[]
[null,"A Taxa de IRS deverá ser preenchida conforme a aplicável para o trabalhador. Neste contexto poderão ser consultadas as tabelas em vigor aqui: https://info.portaldasfinancas.gov.pt/pt/apoio_contribuinte/tabela_ret_doclib/Pages/default.aspx"]
[]
[null,"Estimativas"]
[]
[null,"Para o contrato a termo incerto, é apresentada a estimativa para um ano completo de contrato."]
[null,"O Seguro de Acidentes de Trabalho foi assumido como sendo 2% do Vencimento Base, no entanto esse valor poderá variar conforme as condições de mercado."]
[]
[null,"Data","Vencimento Base","Subsídio de Alimentação","Renumeração Complementar",null,"Subsídio de Natal",null,"Subsídio de Férias","Compensação Termo Contrato","Encargos Seg. Social","Seguro de Ac. de Trabalho",null,"IRS Retido","Segurança Social","Vencimento Líquido"]
[null,null,"CE 010106D000","CE 010113D000","CE 010213RC00",null,"CE 010114SNDO",null,"CE 010114SFDO","CE 010212","CE 010305A0B0","CE 010309"]
[]
[1,{"$f":"C31","v":"2024-01-01"},{"$f":"IF(A47<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1385.99},{"$f":"IF(AND(A47<=$C$16,MONTH(B47)<>6),22*6,0)","v":132},{"$f":"IF(A47<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":20.11},{"$f":"(C47+E47)/30*(2.5*COUNT($B$47:B47))","v":117.175},{"$f":"IF(SUM($J$47:$J$58)=0,IF(MONTH(B47)=11,$F$58,0),IF(J47=0,0,F47))","v":0},{"$f":"(C47+E47)/30*(2.5*COUNT($B$47:B47))","v":117.175},{"$f":"IF(SUM($J$47:$J$58)=0,IF(MONTH(B47)=6,$H$58,0),IF(J47=0,0,H47))","v":0},{"$f":"IF(A47=$C$16,C47/30*2*fldDuracao,0)","v":0},{"$f":"(C47+E47+G47+I47)*22.3%","v":313.56029999999998},{"$f":"1%*C47","v":13.8599},{"$f":"YEAR(B47)","v":2024},{"$f":"((C47+E47+G47+I47+IF(J47>6500,J47-6500,0))*$C$33)","v":98.427000000000007},{"$f":"(C47+E47+G47+I47)*$C$35","v":154.67099999999999},{"$f":"SUM(C47:J47)-SUM(N47:O47)","v":1519.3519999999999}]
[{"$f":"+A47+1","v":2},{"$f":"DATE(YEAR(B47),MONTH(B47)+1,DAY(B47))","v":"2024-02-01"},{"$f":"IF(A48<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1385.99},{"$f":"IF(AND(A48<=$C$16,MONTH(B48)<>6),22*6,0)","v":132},{"$f":"IF(A48<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":20.11},{"$f":"(C48+E48)/30*(2.5*COUNT($B$47:B48))","v":234.35},{"$f":"IF(SUM($J$47:$J$58)=0,IF(MONTH(B48)=11,$F$58,0),IF(J48=0,0,F48))","v":0},{"$f":"(C48+E48)/30*(2.5*COUNT($B$47:B48))","v":234.35},{"$f":"IF(SUM($J$47:$J$58)=0,IF(MONTH(B48)=6,$H$58,0),IF(J48=0,0,H48))","v":0},0,{"$f":"(C48+E48+G48+I48)*22.3%","v":313.56029999999998},13.8599,{"$f":"YEAR(B48)","v":2024},{"$f":"((C48+E48+G48+I48+IF(J48>6500,J48-6500,0))*$C$33)","v":98.427000000000007},{"$f":"(C48+E48+G48+I48)*$C$35","v":154.67099999999999},{"$f":"SUM(C48:J48)-SUM(N48:O48)","v":1753.7019999999998}]
[{"$f":"+A48+1","v":3},{"$f":"DATE(YEAR(B48),MONTH(B48)+1,DAY(B48))","v":"2024-03-01"},{"$f":"IF(A49<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1385.99},132,{"$f":"IF(A49<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":20.11},{"$f":"(C49+E49)/30*(2.5*COUNT($B$47:B49))","v":351.52499999999998},0,{"$f":"(C49+E49)/30*(2.5*COUNT($B$47:B49))","v":351.52499999999998},0,0,313.56029999999998,13.8599,2024,98.427000000000007,154.67099999999999,1988.0520000000001]
[4,"2024-04-01",{"$f":"IF(A50<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1385.99},132,{"$f":"IF(A50<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":20.11},{"$f":"(C50+E50)/30*(2.5*COUNT($B$47:B50))","v":468.7},0,{"$f":"(C50+E50)/30*(2.5*COUNT($B$47:B50))","v":468.7},0,0,313.56029999999998,13.8599,2024,98.427000000000007,154.67099999999999,2222.402]
[5,"2024-05-01",{"$f":"IF(A51<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1385.99},132,{"$f":"IF(A51<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":20.11},{"$f":"(C51+E51)/30*(2.5*COUNT($B$47:B51))","v":585.875},0,{"$f":"(C51+E51)/30*(2.5*COUNT($B$47:B51))","v":585.875},0,0,313.56029999999998,13.8599,2024,98.427000000000007,154.67099999999999,2456.752]
[6,"2024-06-01",{"$f":"IF(A52<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1385.99},0,{"$f":"IF(A52<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":20.11},{"$f":"(C52+E52)/30*(2.5*COUNT($B$47:B52))","v":703.05},0,{"$f":"(C52+E52)/30*(2.5*COUNT($B$47:B52))","v":703.05},1406.1,0,627.12059999999997,13.8599,2024,196.85400000000001,309.34199999999998,3712.1039999999994]
[7,"2024-07-01",{"$f":"IF(A53<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1385.99},132,{"$f":"IF(A53<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":20.11},{"$f":"(C53+E53)/30*(2.5*COUNT($B$47:B53))","v":820.22499999999991},0,{"$f":"(C53+E53)/30*(2.5*COUNT($B$47:B53))","v":820.22499999999991},0,0,313.56029999999998,{"$f":"1%*C53","v":13.8599},2024,98.427000000000007,154.67099999999999,2925.4519999999998]
[8,"2024-08-01",{"$f":"IF(A54<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1385.99},132,{"$f":"IF(A54<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":20.11},{"$f":"(C54+E54)/30*(2.5*COUNT($B$47:B54))","v":937.4},0,{"$f":"(C54+E54)/30*(2.5*COUNT($B$47:B54))","v":937.4},0,0,313.56029999999998,13.8599,2024,98.427000000000007,154.67099999999999,3159.8020000000001]
[9,"2024-09-01",{"$f":"IF(A55<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1385.99},132,{"$f":"IF(A55<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":20.11},{"$f":"(C55+E55)/30*(2.5*COUNT($B$47:B55))","v":1054.575},0,{"$f":"(C55+E55)/30*(2.5*COUNT($B$47:B55))","v":1054.575},0,0,313.56029999999998,13.8599,2024,98.427000000000007,154.67099999999999,3394.152]
[10,"2024-10-01",{"$f":"IF(A56<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1385.99},132,{"$f":"IF(A56<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":20.11},{"$f":"(C56+E56)/30*(2.5*COUNT($B$47:B56))","v":1171.75},0,{"$f":"(C56+E56)/30*(2.5*COUNT($B$47:B56))","v":1171.75},0,0,313.56029999999998,13.8599,2024,98.427000000000007,154.67099999999999,3628.502]
[11,"2024-11-01",{"$f":"IF(A57<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1385.99},132,{"$f":"IF(A57<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":20.11},{"$f":"(C57+E57)/30*(2.5*COUNT($B$47:B57))","v":1288.925},1406.1,{"$f":"(C57+E57)/30*(2.5*COUNT($B$47:B57))","v":1288.925},0,0,627.12059999999997,13.8599,2024,196.85400000000001,309.34199999999998,5015.8540000000003]
[12,"2024-12-01",{"$f":"IF(A58<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1385.99},132,{"$f":"IF(A58<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":20.11},{"$f":"(C58+E58)/30*(2.5*COUNT($B$47:B58))","v":1406.1},0,{"$f":"(C58+E58)/30*(2.5*COUNT($B$47:B58))","v":1406.1},0,0,313.56029999999998,13.8599,2024,98.427000000000007,154.67099999999999,4097.2019999999993]
[]
[null,"Total Ano 1",{"$f":"SUM(C47:C58)","v":16631.88},{"$f":"SUM(D47:D58)","v":1452},{"$f":"SUM(E47:E58)","v":241.32000000000005},null,1406.1,null,1406.1,0,4389.8442000000005,{"$f":"SUM(L47:L58)","v":166.31880000000001},null,1377.9780000000001,2165.3940000000002,35873.327999999994]
[]
[{"$f":"+A58+1","v":13},{"$f":"DATE(YEAR(B58),MONTH(B58)+1,DAY(B58))","v":"2025-01-01"},{"$f":"IF(A62<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1385.99},{"$f":"IF(AND(A62<=$C$16,MONTH(B62)<>6),22*6,0)","v":132},{"$f":"IF(A62<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":20.11},{"$f":"(C62+E62)/30*(2.5*COUNT($B$62:B62))","v":117.175},{"$f":"IF(SUM($J$62:$J$73)=0,IF(MONTH(B62)=11,$F$73,0),IF(J62=0,0,F62))","v":0},{"$f":"(C62+E62)/30*(2.5*COUNT($B$62:B62))","v":117.175},{"$f":"IF(SUM($J$62:$J$73)=0,IF(MONTH(B62)=6,$H$73,0),IF(J62=0,0,H62))","v":0},{"$f":"IF(A62=$C$16,C62/30*2*fldDuracao,0)","v":0},{"$f":"(C62+E62+G62+I62)*22.3%","v":313.56029999999998},{"$f":"1%*C62","v":13.8599},{"$f":"YEAR(B62)","v":2025},{"$f":"((C62+E62+G62+I62+IF(J62>6500,J62-6500,0))*$C$33)","v":98.427000000000007},{"$f":"(C62+E62+G62+I62)*$C$35","v":154.67099999999999},{"$f":"SUM(C62:J62)-SUM(N62:O62)","v":1519.3519999999999}]
[{"$f":"+A62+1","v":14},{"$f":"DATE(YEAR(B62),MONTH(B62)+1,DAY(B62))","v":"2025-02-01"},{"$f":"IF(A63<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1385.99},{"$f":"IF(AND(A63<=$C$16,MONTH(B63)<>6),22*6,0)","v":132},{"$f":"IF(A63<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":20.11},{"$f":"(C63+E63)/30*(2.5*COUNT($B$62:B63))","v":234.35},{"$f":"IF(SUM($J$62:$J$73)=0,IF(MONTH(B63)=11,$F$73,0),IF(J63=0,0,F63))","v":0},{"$f":"(C63+E63)/30*(2.5*COUNT($B$62:B63))","v":234.35},{"$f":"IF(SUM($J$62:$J$73)=0,IF(MONTH(B63)=6,$H$73,0),IF(J63=0,0,H63))","v":0},0,313.56029999999998,{"$f":"1%*C63","v":13.8599},{"$f":"YEAR(B63)","v":2025},98.427000000000007,154.67099999999999,1753.7019999999998]
[{"$f":"+A63+1","v":15},{"$f":"DATE(YEAR(B63),MONTH(B63)+1,DAY(B63))","v":"2025-03-01"},{"$f":"IF(A64<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1385.99},132,{"$f":"IF(A64<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":20.11},{"$f":"(C64+E64)/30*(2.5*COUNT($B$62:B64))","v":351.52499999999998},0,{"$f":"(C64+E64)/30*(2.5*COUNT($B$62:B64))","v":351.52499999999998},0,0,313.56029999999998,13.8599,2025,98.427000000000007,154.67099999999999,1988.0520000000001]
[16,"2025-04-01",{"$f":"IF(A65<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1385.99},132,{"$f":"IF(A65<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":20.11},{"$f":"(C65+E65)/30*(2.5*COUNT($B$62:B65))","v":468.7},0,{"$f":"(C65+E65)/30*(2.5*COUNT($B$62:B65))","v":468.7},0,0,313.56029999999998,13.8599,2025,98.427000000000007,154.67099999999999,2222.402]
[17,"2025-05-01",{"$f":"IF(A66<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1385.99},132,{"$f":"IF(A66<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":20.11},{"$f":"(C66+E66)/30*(2.5*COUNT($B$62:B66))","v":585.875},0,{"$f":"(C66+E66)/30*(2.5*COUNT($B$62:B66))","v":585.875},0,0,313.56029999999998,13.8599,2025,98.427000000000007,154.67099999999999,2456.752]
[18,"2025-06-01",{"$f":"IF(A67<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1385.99},0,{"$f":"IF(A67<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":20.11},{"$f":"(C67+E67)/30*(2.5*COUNT($B$62:B67))","v":703.05},0,{"$f":"(C67+E67)/30*(2.5*COUNT($B$62:B67))","v":703.05},0,0,313.56029999999998,13.8599,2025,98.427000000000007,154.67099999999999,2559.1019999999999]
[19,"2025-07-01",{"$f":"IF(A68<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1385.99},132,{"$f":"IF(A68<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":20.11},{"$f":"(C68+E68)/30*(2.5*COUNT($B$62:B68))","v":820.22499999999991},0,{"$f":"(C68+E68)/30*(2.5*COUNT($B$62:B68))","v":820.22499999999991},0,0,313.56029999999998,13.8599,2025,98.427000000000007,154.67099999999999,2925.4519999999998]
[20,"2025-08-01",{"$f":"IF(A69<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1385.99},132,{"$f":"IF(A69<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":20.11},{"$f":"(C69+E69)/30*(2.5*COUNT($B$62:B69))","v":937.4},0,{"$f":"(C69+E69)/30*(2.5*COUNT($B$62:B69))","v":937.4},0,0,313.56029999999998,13.8599,2025,98.427000000000007,154.67099999999999,3159.8020000000001]
[21,"2025-09-01",{"$f":"IF(A70<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1385.99},132,{"$f":"IF(A70<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":20.11},{"$f":"(C70+E70)/30*(2.5*COUNT($B$62:B70))","v":1054.575},0,{"$f":"(C70+E70)/30*(2.5*COUNT($B$62:B70))","v":1054.575},0,0,313.56029999999998,13.8599,2025,98.427000000000007,154.67099999999999,3394.152]
[22,"2025-10-01",{"$f":"IF(A71<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1385.99},132,{"$f":"IF(A71<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":20.11},{"$f":"(C71+E71)/30*(2.5*COUNT($B$62:B71))","v":1171.75},0,{"$f":"(C71+E71)/30*(2.5*COUNT($B$62:B71))","v":1171.75},0,0,313.56029999999998,13.8599,2025,98.427000000000007,154.67099999999999,3628.502]
[23,"2025-11-01",{"$f":"IF(A72<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1385.99},132,{"$f":"IF(A72<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":20.11},{"$f":"(C72+E72)/30*(2.5*COUNT($B$62:B72))","v":1288.925},0,{"$f":"(C72+E72)/30*(2.5*COUNT($B$62:B72))","v":1288.925},0,0,313.56029999999998,13.8599,2025,98.427000000000007,154.67099999999999,3862.8519999999999]
[24,"2025-12-01",{"$f":"IF(A73<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1385.99},132,{"$f":"IF(A73<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":20.11},{"$f":"(C73+E73)/30*(2.5*COUNT($B$62:B73))","v":1406.1},1406.1,{"$f":"(C73+E73)/30*(2.5*COUNT($B$62:B73))","v":1406.1},1406.1,2217.5839999999998,940.68089999999984,13.8599,2025,295.28099999999995,464.01299999999992,8620.7899999999991]
[]
[null,"Total Ano 2",{"$f":"SUM(C62:C73)","v":16631.88},{"$f":"SUM(D62:D73)","v":1452},241.32000000000005,null,1406.1,null,1406.1,{"$f":"SUM(J62:J73)","v":2217.5839999999998},4389.8442000000005,166.31880000000001,null,{"$f":"SUM(N62:N73)","v":1377.9780000000001},2165.3940000000002,38090.912000000004]
[]
[{"$f":"+A73+1","v":25},{"$f":"DATE(YEAR(B73),MONTH(B73)+1,DAY(B73))","v":"2026-01-01"},{"$f":"IF(A77<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},{"$f":"IF(AND(A77<=$C$16,MONTH(B77)<>6),22*6,0)","v":0},{"$f":"IF(A77<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},{"$f":"(C77+E77)/30*(2.5*COUNT($B$77:B77))","v":0},{"$f":"IF(SUM($J$77:$J$88)=0,IF(MONTH(B77)=11,$F$88,0),IF(J77=0,0,F77))","v":0},{"$f":"(C77+E77)/30*(2.5*COUNT($B$77:B77))","v":0},{"$f":"IF(SUM($J$77:$J$88)=0,IF(MONTH(B77)=6,$H$88,0),IF(J77=0,0,H77))","v":0},{"$f":"IF(A77=$C$16,C77/30*2*fldDuracao,0)","v":0},{"$f":"(C77+E77+G77+I77)*22.3%","v":0},{"$f":"1%*C77","v":0},{"$f":"YEAR(B77)","v":2026},{"$f":"((C77+E77+G77+I77+IF(J77>6500,J77-6500,0))*$C$33)","v":0},{"$f":"(C77+E77+G77+I77)*$C$35","v":0},{"$f":"SUM(C77:J77)-SUM(N77:O77)","v":0}]
[{"$f":"+A77+1","v":26},{"$f":"DATE(YEAR(B77),MONTH(B77)+1,DAY(B77))","v":"2026-02-01"},{"$f":"IF(A78<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,{"$f":"IF(A78<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},{"$f":"(C78+E78)/30*(2.5*COUNT($B$77:B78))","v":0},{"$f":"IF(SUM($J$77:$J$88)=0,IF(MONTH(B78)=11,$F$88,0),IF(J78=0,0,F78))","v":0},{"$f":"(C78+E78)/30*(2.5*COUNT($B$77:B78))","v":0},{"$f":"IF(SUM($J$77:$J$88)=0,IF(MONTH(B78)=6,$H$88,0),IF(J78=0,0,H78))","v":0},0,0,0,2026,0,0,0]
[{"$f":"+A78+1","v":27},{"$f":"DATE(YEAR(B78),MONTH(B78)+1,DAY(B78))","v":"2026-03-01"},{"$f":"IF(A79<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,{"$f":"IF(A79<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},{"$f":"(C79+E79)/30*(2.5*COUNT($B$77:B79))","v":0},0,{"$f":"(C79+E79)/30*(2.5*COUNT($B$77:B79))","v":0},0,0,0,0,2026,0,0,0]
[28,"2026-04-01",{"$f":"IF(A80<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,{"$f":"IF(A80<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},{"$f":"(C80+E80)/30*(2.5*COUNT($B$77:B80))","v":0},0,{"$f":"(C80+E80)/30*(2.5*COUNT($B$77:B80))","v":0},0,0,0,0,2026,0,0,0]
[29,"2026-05-01",{"$f":"IF(A81<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,{"$f":"IF(A81<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},{"$f":"(C81+E81)/30*(2.5*COUNT($B$77:B81))","v":0},0,{"$f":"(C81+E81)/30*(2.5*COUNT($B$77:B81))","v":0},0,0,0,0,2026,0,0,0]
[30,"2026-06-01",{"$f":"IF(A82<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,{"$f":"IF(A82<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},{"$f":"(C82+E82)/30*(2.5*COUNT($B$77:B82))","v":0},0,{"$f":"(C82+E82)/30*(2.5*COUNT($B$77:B82))","v":0},0,0,0,0,2026,0,0,0]
[31,"2026-07-01",{"$f":"IF(A83<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,{"$f":"IF(A83<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},{"$f":"(C83+E83)/30*(2.5*COUNT($B$77:B83))","v":0},0,{"$f":"(C83+E83)/30*(2.5*COUNT($B$77:B83))","v":0},0,0,0,0,2026,0,0,0]
[32,"2026-08-01",{"$f":"IF(A84<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,{"$f":"IF(A84<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},{"$f":"(C84+E84)/30*(2.5*COUNT($B$77:B84))","v":0},0,{"$f":"(C84+E84)/30*(2.5*COUNT($B$77:B84))","v":0},0,0,0,0,2026,0,0,0]
[33,"2026-09-01",{"$f":"IF(A85<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,{"$f":"IF(A85<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},{"$f":"(C85+E85)/30*(2.5*COUNT($B$77:B85))","v":0},0,{"$f":"(C85+E85)/30*(2.5*COUNT($B$77:B85))","v":0},0,0,0,0,2026,0,0,0]
[34,"2026-10-01",{"$f":"IF(A86<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,{"$f":"IF(A86<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},{"$f":"(C86+E86)/30*(2.5*COUNT($B$77:B86))","v":0},0,{"$f":"(C86+E86)/30*(2.5*COUNT($B$77:B86))","v":0},0,0,0,0,2026,0,0,0]
[35,"2026-11-01",{"$f":"IF(A87<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,{"$f":"IF(A87<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},{"$f":"(C87+E87)/30*(2.5*COUNT($B$77:B87))","v":0},0,{"$f":"(C87+E87)/30*(2.5*COUNT($B$77:B87))","v":0},0,0,0,0,2026,0,0,0]
[36,"2026-12-01",{"$f":"IF(A88<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,{"$f":"IF(A88<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($G$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},{"$f":"(C88+E88)/30*(2.5*COUNT($B$77:B88))","v":0},0,{"$f":"(C88+E88)/30*(2.5*COUNT($B$77:B88))","v":0},0,0,0,0,2026,0,0,0]
[]
[null,"Total Ano 3",{"$f":"SUM(C77:C88)","v":0},{"$f":"SUM(D77:D88)","v":0},{"$f":"SUM(E77:E88)","v":0},null,0,null,0,0,0,0,null,{"$f":"SUM(N77:N88)","v":0},0,0]
[]
[]
[null,"Resumo da Imputação ao Centro de Custos por Ano e Conta Económica"]
[]
[null,null,"Conta Económica",{"$f":"+YEAR(fldDatadeInicio)","v":2024},{"$f":"+D95+1","v":2025},null,{"$f":"+E95+1","v":2026},null,{"$f":"+G95+1","v":2027},"Total"]
[]
[null,null,"Vencimento Base\nCE 010106",{"$f":"SUMIF($M$47:$M$90,D$95,$C$47:$C$90)","v":16631.88},{"$f":"SUMIF($M$47:$M$90,E$95,$C$47:$C$90)","v":16631.88},null,{"$f":"SUMIF($M$47:$M$90,G$95,$C$47:$C$90)","v":0},null,{"$f":"SUMIF($M$47:$M$90,I$95,$C$47:$C$90)","v":0},{"$f":"SUM(D97:I97)","v":33263.760000000002}]
[null,null,"Subsídio de Alimentação\nCE 010113",{"$f":"SUMIF($M$47:$M$90,D$95,$D$47:$D$90)","v":1452},{"$f":"SUMIF($M$47:$M$90,E$95,$D$47:$D$90)","v":1452},null,{"$f":"SUMIF($M$47:$M$90,G$95,$D$47:$D$90)","v":0},null,{"$f":"SUMIF($M$47:$M$90,I$95,$D$47:$D$90)","v":0},{"$f":"SUM(D98:I98)","v":2904}]
[null,null,"Renum. Complementar\nCE 010213RC00",{"$f":"SUMIF($M$47:$M$90,D$95,$E$47:$E$90)","v":241.32000000000005},{"$f":"SUMIF($M$47:$M$90,E$95,$E$47:$E$90)","v":241.32000000000005},null,0,null,0,482.6400000000001]
[null,null,"Subsídio de Natal\nCE 010114SN00",{"$f":"SUMIF($M$47:$M$90,D$95,$G$47:$G$90)","v":1406.1},{"$f":"SUMIF($M$47:$M$90,E$95,$G$47:$G$90)","v":1406.1},null,0,null,0,2812.2]
[null,null,"Subsídio de Férias\nCE 010114SF00",{"$f":"SUMIF($M$47:$M$90,D$95,$I$47:$I$90)","v":1406.1},{"$f":"SUMIF($M$47:$M$90,E$95,$I$47:$I$90)","v":1406.1},null,0,null,0,2812.2]
[null,null,"Compl. Termo Contrato\nCE 010212",{"$f":"SUMIF($M$47:$M$90,D$95,$J$47:$J$90)","v":0},{"$f":"SUMIF($M$47:$M$90,E$95,$J$47:$J$90)","v":2217.5839999999998},null,0,null,0,2217.5839999999998]
[null,null,"Encargos Seg. Social\nCE 010305A0B0",{"$f":"SUMIF($M$47:$M$90,D$95,$K$47:$K$90)","v":4389.8442000000005},{"$f":"SUMIF($M$47:$M$90,E$95,$K$47:$K$90)","v":4389.8442000000005},null,0,null,0,8779.6884000000009]
[null,null,"Seguro de Ac. de Trab.\nCE 010309",{"$f":"SUMIF($M$47:$M$90,D$95,$L$47:$L$90)","v":166.31880000000001},{"$f":"SUMIF($M$47:$M$90,E$95,$L$47:$L$90)","v":166.31880000000001},null,{"$f":"SUMIF($M$47:$M$90,G$95,$L$47:$L$90)","v":0},null,{"$f":"SUMIF($M$47:$M$90,I$95,$L$47:$L$90)","v":0},332.63760000000002]
[]
[null,null,"Total",{"$f":"SUM(D97:D104)","v":25693.562999999998},{"$f":"SUM(E97:E104)","v":27911.146999999997},null,0,null,0,{"$f":"SUM(J97:J104)","v":53604.71}]

{"sheet":"ESTAGIAR","index":2,"n_rows":65,"n_cols":6,"rows_kept":65,"cut":false,"hidden":false,"merged":[[30,1,30,4],[11,1,11,4],[2,2,2,5],[3,2,3,5],[9,1,9,4],[15,1,15,4],[16,1,16,4],[17,1,17,4],[18,1,18,4],[24,1,24,4],[10,1,10,4]]}
[]
[]
[null,null,"SIMULADOR DE CUSTOS COM RECURSOS HUMANOS"]
[null,null,"Programa ESTAGIAR"]
[]
[null,null,null,null,"Versão","2024-03-07"]
[]
[null,"Pressupostos do ESTAGIAR"]
[]
[null,"Conforme o Art.º 20.º do Regulamento dos Programas Estagiar, a FGF fica obrigada, após o período de estágio, à celebração de contrato a tempo completo por 1 ano, sem período experimental, com, pelo menos, 50% dos estagiários que iniciaram no mesmo mês."]
[null,"Assim, e de forma a cumprir com o exposto supra, será cabimentada verba para um ano de contrato. Na eventualidade de a FGF atingir a quota referida no Art.º 20.º, a verba poderá ser descabimentada."]
[null,"Neste contexto, e após usar este simulador, deverá o requerente usar, igualmente, o simulador para contratos de trabalho."]
[]
[null,"Tipo de Estagiar","Estagiar L"]
[]
[null,"Nos termos do Regulamento dos programas ESTAGIAR L, ESTAGIAR T e ESTAGIAR +:"]
[null,"1. O ESTAGIAR L destina-se a jovens recém-diplomados no ensino superior, detentores de nível VI, VII ou VIII do QNQ, que nunca tenham exercido funções na respetiva área de formação ao abrigo de contrato de trabalho, após a conclusão da respetiva formação."]
[null,"2. O ESTAGIAR T destina-se a jovens recém-diplomados em cursos de qualificação profissional, nível IV ou V do QNQ, que nunca tenham exercido funções na respetiva área de formação ao abrigo de contrato de trabalho, após a conclusão da respetiva formação."]
[null,"3. O ESTAGIAR + destina-se a jovens com qualificação igual ou inferior ao nível III do QNQ, inscritos no CQE há mais de três meses, quando estão à procura de primeiro emprego, ou jovens desempregados há mais de seis meses, quando estão à procura de novo emprego."]
[]
[null,"Data de Início (Mês/Ano)","2024-01-01"]
[]
[null,"Pretende Prorrogação?","Sim"]
[]
[null,"Os estágios têm a duração de 12 meses, incluindo um mês de descanso a gozar durante o 12.º mês de estágio, podendo ser prorrogados por um período de 3 meses."]
[]
[null,"Posição Remuneratória",{"$f":"INDEX('Estagiar - Tabela'!$C$7:$C$9,MATCH(fldTipoDeBolseiro,'Estagiar - Tabela'!$B$7:$B$9,0))","v":1076.25}]
[]
[null,"Estimativas"]
[]
[null,"O Seguro de Acidentes de Trabalho foi assumido como sendo 2% da compensação do ESTAGIAR, no entanto esse valor poderá variar conforme as condições de mercado."]
[]
[null,"Data","Compensação ESTAGIAR","Encargos Seg. Social","Seguro de Ac. de Trabalho"]
[null,null,"CE 040802A000","CE 010305A0B0","CE 020212B000"]
[]
[1,{"$f":"C21","v":"2024-01-01"},0,{"$f":"$C$27*22.3%","v":240.00375},{"$f":"1%*$C$27","v":10.762500000000001},{"$f":"YEAR(B36)","v":2024}]
[{"$f":"+A36+1","v":2},{"$f":"DATE(YEAR(B36),MONTH(B36)+1,DAY(B36))","v":"2024-02-01"},0,{"$f":"$C$27*22.3%","v":240.00375},{"$f":"1%*$C$27","v":10.762500000000001},{"$f":"YEAR(B37)","v":2024}]
[{"$f":"+A37+1","v":3},{"$f":"DATE(YEAR(B37),MONTH(B37)+1,DAY(B37))","v":"2024-03-01"},0,240.00375,10.762500000000001,2024]
[4,"2024-04-01",0,240.00375,10.762500000000001,2024]
[5,"2024-05-01",0,240.00375,10.762500000000001,2024]
[6,"2024-06-01",0,240.00375,10.762500000000001,2024]
[7,"2024-07-01",0,240.00375,10.762500000000001,2024]
[8,"2024-08-01",0,240.00375,10.762500000000001,2024]
[9,"2024-09-01",0,240.00375,10.762500000000001,2024]
[10,"2024-10-01",0,240.00375,10.762500000000001,2024]
[11,"2024-11-01",0,240.00375,10.762500000000001,2024]
[12,"2024-12-01",0,240.00375,10.762500000000001,2024]
[]
[null,"Total Ano 1",{"$f":"SUM(C36:C47)","v":0},{"$f":"SUM(D36:D47)","v":2880.0449999999996},{"$f":"SUM(E36:E47)","v":129.15}]
[]
[null,{"$f":"DATE(YEAR(B47),MONTH(B47)+1,DAY(B47))","v":"2025-01-01"},{"$f":"IF(fldProrrogacao=\"Sim\",fldPosicaoRemuneratoria*30%,0)","v":322.875},{"$f":"IF(fldProrrogacao=\"Sim\",$C$27*22.3%,0)","v":240.00375},{"$f":"1%*$C$27","v":10.762500000000001},{"$f":"YEAR(B51)","v":2025}]
[null,{"$f":"DATE(YEAR(B51),MONTH(B51)+1,DAY(B51))","v":"2025-02-01"},{"$f":"IF(fldProrrogacao=\"Sim\",fldPosicaoRemuneratoria*30%,0)","v":322.875},{"$f":"IF(fldProrrogacao=\"Sim\",$C$27*22.3%,0)","v":240.00375},10.762500000000001,2025]
[null,"2025-03-01",{"$f":"IF(fldProrrogacao=\"Sim\",fldPosicaoRemuneratoria*30%,0)","v":322.875},{"$f":"IF(fldProrrogacao=\"Sim\",$C$27*22.3%,0)","v":240.00375},10.762500000000001,2025]
[]
[null,"Total Prorrogação",{"$f":"SUM(C51:C53)","v":968.625},{"$f":"SUM(D51:D53)","v":720.01125000000002},{"$f":"SUM(E51:E53)","v":32.287500000000001}]
[]
[null,"Resumo da Imputação ao Centro de Custos por Ano e Conta Económica"]
[]
[null,"Conta Económica",{"$f":"YEAR(fldDatadeInicio)","v":2024},{"$f":"+C59+1","v":2025},{"$f":"+D59+1","v":2026},"Total"]
[]
[null,"Compensação ESTAGIAR\nCE 040802A000",{"$f":"SUMIF($F$36:$F$55,C$59,$C$36:$C$55)","v":0},{"$f":"SUMIF($F$36:$F$55,D$59,$C$36:$C$55)","v":968.625},0,{"$f":"SUM(C61:E61)","v":968.625}]
[null,"Encargos Seg. Social\nCE 010305A0B0",{"$f":"SUMIF($F$36:$F$55,C$59,$D$36:$D$55)","v":2880.0449999999996},{"$f":"SUMIF($F$36:$F$55,D$59,$D$36:$D$55)","v":720.01125000000002},0,{"$f":"SUM(C62:E62)","v":3600.0562499999996}]
[null,"Seguro de Ac. de Trabalho\nCE 020212B000",{"$f":"SUMIF($F$36:$F$55,C$59,$E$36:$E$55)","v":129.15},{"$f":"SUMIF($F$36:$F$55,D$59,$E$36:$E$55)","v":32.287500000000001},0,161.4375]
[]
[null,"Total",{"$f":"SUM(C61:C63)","v":3009.1949999999997},{"$f":"SUM(D61:D63)","v":1720.9237499999999},0,4730.1187499999996]

{"sheet":"Bolsa","index":3,"n_rows":56,"n_cols":6,"rows_kept":56,"cut":false,"hidden":false,"merged":[[27,1,27,4],[9,1,9,4],[17,1,17,4],[18,1,18,4],[2,2,2,4],[3,2,3,4],[26,1,26,4]]}
[]
[]
[null,null,"SIMULADOR DE CUSTOS COM RECURSOS HUMANOS"]
[null,null,"Bolsa"]
[]
[null,null,null,"Versão","2024-03-07"]
[]
[null,"Pressupostos da Bolsa"]
[]
[null,"Uma vez que a FGF recebe financiamento da Fundação para a Ciência e Tecnologia (FCT), esta está obrigada a aplicar o Estatuto do Bolseiro de Investigação e o Regulamento de Bolsas de Investigação a todos os bolseiros, mesmo quando a respetiva bolsa não seja financiada diretamente pela FCT."]
[]
[null,"Tipo de Bolsa","Bolsa de Investigacao",{"$f":"IF(fldTipoDeBolseiro=\"Bolsa de Investigacao\",fldTipoDeBolseiro&\" - \"&fldGrauAcademico,fldTipoDeBolseiro)","v":"Bolsa de Investigacao - Doutor"}]
[]
[null,"Grau Académico do Bolseiro","Doutor"]
[]
[null,"Data de Início (Mês/Ano)","2024-01-01"]
[]
[null,"As durações das bolsas encontram-se previstas nos Art.º 5º a 7º do Regulamento n.º 950/2019 da FCT e no Art.º 3º do Estatuto do Bolseiro de Investigação."]
[null,"Em regra, as bolsas têm uma duração entre 3 e 12 meses. Conforme a tipologia da bolsa, é possível a renovação - por exemplo, a bolsa de doutoramento pode ser renovada até atingir 4 anos."]
[]
[null,"Posição Remuneratória",{"$f":"INDEX('Bolsas - Tabela'!$D$5:$D$10,MATCH(Bolsa!D12,'Bolsas - Tabela'!$F$5:$F$10,0))","v":1801}]
[]
[null," Indexante dos Apoios Sociais",509.26]
[]
[null,"Estimativas"]
[]
[null,"As estimativas abaixo assumem que a bolsa terá uma duração de 12 meses. O Seguro Social Voluntário é opcional."]
[null,"O Seguro de Acidentes de Trabalho foi assumido como sendo 2% da compensação do ESTAGIAR, no entanto esse valor poderá variar conforme as condições de mercado."]
[]
[null,"Data","Valor da Bolsa","Seguro Social Voluntário","Seguro de Ac. de Trabalho"]
[null,null,"CE 040802BE00","CE 010305A0O0","CE 020212B000"]
[]
[1,{"$f":"C16","v":"2024-01-01"},{"$f":"fldPosicaoRemuneratoria","v":1801},{"$f":"C23*29.6%","v":150.74096000000003},{"$f":"1%*C33","v":18.010000000000002},{"$f":"YEAR(B33)","v":2024}]
[{"$f":"+A33+1","v":2},{"$f":"DATE(YEAR(B33),MONTH(B33)+1,DAY(B33))","v":"2024-02-01"},{"$f":"fldPosicaoRemuneratoria","v":1801},{"$f":"+D33","v":150.74096000000003},{"$f":"1%*C34","v":18.010000000000002},{"$f":"YEAR(B34)","v":2024}]
[{"$f":"+A34+1","v":3},{"$f":"DATE(YEAR(B34),MONTH(B34)+1,DAY(B34))","v":"2024-03-01"},1801,{"$f":"+D34","v":150.74096000000003},18.010000000000002,2024]
[4,"2024-04-01",1801,150.74096000000003,18.010000000000002,2024]
[5,"2024-05-01",1801,150.74096000000003,18.010000000000002,2024]
[6,"2024-06-01",1801,150.74096000000003,18.010000000000002,2024]
[7,"2024-07-01",1801,150.74096000000003,18.010000000000002,2024]
[8,"2024-08-01",1801,150.74096000000003,18.010000000000002,2024]
[9,"2024-09-01",1801,150.74096000000003,18.010000000000002,2024]
[10,"2024-10-01",1801,150.74096000000003,18.010000000000002,2024]
[11,"2024-11-01",1801,150.74096000000003,18.010000000000002,2024]
[12,"2024-12-01",1801,150.74096000000003,18.010000000000002,2024]
[]
[null,"Total Ano 1",{"$f":"SUM(C33:C44)","v":21612},{"$f":"SUM(D33:D44)","v":1808.8915200000008},{"$f":"SUM(E33:E44)","v":216.11999999999998}]
[]
[null,"Resumo da Imputação ao Centro de Custos por Ano e Conta Económica"]
[]
[null,"Conta Económica",{"$f":"YEAR(fldDatadeInicio)","v":2024},{"$f":"+C50+1","v":2025},"Total"]
[]
[null,"Valor da Bolsa\nCE 040802BE00",{"$f":"SUMIF($F$33:$F$44,C$50,$C$33:$C$44)","v":21612},{"$f":"SUMIF($F$33:$F$44,D$50,$C$33:$C$44)","v":0},{"$f":"SUM(C52:D52)","v":21612}]
[null,"Seguro Social Voluntário\nCE 010305A0O0",{"$f":"SUMIF($F$33:$F$44,C$50,$D$33:$D$44)","v":1808.8915200000008},{"$f":"SUMIF($F$33:$F$44,D$50,$D$33:$D$44)","v":0},{"$f":"SUM(C53:D53)","v":1808.8915200000008}]
[null,"Seguro de Ac. de Trabalho\nCE 020212B000",{"$f":"SUMIF($F$33:$F$44,C$50,$E$33:$E$44)","v":216.11999999999998},{"$f":"SUMIF($F$33:$F$44,D$50,$E$33:$E$44)","v":0},216.11999999999998]
[]
[null,"Total",{"$f":"SUM(C52:C54)","v":23637.01152},{"$f":"SUM(D52:D54)","v":0},23637.01152]

{"sheet":"CT - Tabela","index":4,"n_rows":119,"n_cols":14,"rows_kept":119,"cut":false,"hidden":true,"merged":[[3,8,3,9]]}
["Tabela Remuneratória Única",null,null,null,null,null,null,null,"Tabela Remuneração Complementar"]
["Atualizada a 26/01/2024",null,null,null,null,null,null,null,"Atualizada a 08/11/2023"]
[]
[null,"Posição","Remuneração","Remuneração",null,"Geral e AT","TS",null,"Intervalo",null,"Percentagem","Montante","Acréscimo","Total"]
[null,1,null,{"$f":"RemComplementar(C5)","v":80.45},null,{"$f":"B5&\" - \"&ROUND(C5,2)","v":"1 - 0"},null,null,null,769.2,1,80.45,0,{"$f":"ROUND(L5+M5,2)","v":80.45}]
[null,{"$f":"+B5+1","v":2},null,{"$f":"RemComplementar(C6)","v":80.45},null,{"$f":"B6&\" - \"&ROUND(C6,2)","v":"2 - 0"},null,null,{"$f":"+J5+0.01","v":769.21},774.72,0.9,{"$f":"K6*$L$5","v":72.405000000000001},0,{"$f":"ROUND(L6+M6,2)","v":72.41}]
[null,{"$f":"+B6+1","v":3},null,{"$f":"RemComplementar(C7)","v":80.45},null,"3 - 0",null,null,{"$f":"+J6+0.01","v":774.73},780.25,0.85,{"$f":"+K7*$L$5","v":68.382500000000007},0,68.38]
[null,4,null,{"$f":"RemComplementar(C8)","v":80.45},null,"4 - 0",null,null,780.26,850.57,0.8,64.36,0,64.36]
[null,5,821.83,{"$f":"RemComplementar(C9)","v":64.36},null,"5 - 821,83",null,null,850.58,928.02,0.7,56.314999999999998,0,56.32]
[null,6,869.84,{"$f":"RemComplementar(C10)","v":56.32},null,"6 - 869,84",null,null,928.03,997.32,0.6,48.27,0,48.27]
[null,7,922.47,{"$f":"RemComplementar(C11)","v":56.32},null,"7 - 922,47",null,null,997.33,1121.6500000000001,0.55000000000000004,44.247500000000002,0,44.25]
[null,8,961.4,{"$f":"RemComplementar(C12)","v":48.27},null,"8 - 961,4",null,null,1121.6600000000001,1173.6199999999999,0.45,36.202500000000001,0,36.200000000000003]
[null,9,1017.56,{"$f":"RemComplementar(C13)","v":44.25},null,"9 - 1017,56",null,null,1173.6299999999999,1208.27,0.4,32.18,0,32.18]
[null,10,1070.19,{"$f":"RemComplementar(C14)","v":44.25},null,"10 - 1070,19",null,null,1208.28,1295.9100000000001,0.35,28.157499999999999,0,28.16]
[null,11,1122.8399999999999,{"$f":"RemComplementar(C15)","v":36.200000000000003},null,"11 - 1122,84",null,null,1295.92,1386.61,0.25,20.112500000000001,0,20.11]
[null,12,1175.46,{"$f":"RemComplementar(C16)","v":32.18},null,"12 - 1175,46"]
[null,13,1228.0899999999999,{"$f":"RemComplementar(C17)","v":28.16},null,"13 - 1228,09"]
[null,14,1280.72,{"$f":"RemComplementar(C18)","v":28.16},null,"14 - 1280,72"]
[null,15,1333.35,{"$f":"RemComplementar(C19)","v":20.11},null,"15 - 1333,35"]
[null,16,1385.99,{"$f":"RemComplementar(C20)","v":20.11},null,"16 - 1385,99",{"$f":"B20&\" - \"&ROUND(C20,2)","v":"16 - 1385,99"}]
[null,17,1438.62,{"$f":"RemComplementar(C21)","v":0},null,"17 - 1438,62",{"$f":"B21&\" - \"&ROUND(C21,2)","v":"17 - 1438,62"}]
[null,18,1491.25,{"$f":"RemComplementar(C22)","v":0},null,"18 - 1491,25","18 - 1491,25"]
[null,19,1543.88,{"$f":"RemComplementar(C23)","v":0},null,"19 - 1543,88","19 - 1543,88"]
[null,20,1596.52,{"$f":"RemComplementar(C24)","v":0},null,"20 - 1596,52","20 - 1596,52"]
[null,21,1649.15,{"$f":"RemComplementar(C25)","v":0},null,"21 - 1649,15","21 - 1649,15"]
[null,22,1701.78,{"$f":"RemComplementar(C26)","v":0},null,"22 - 1701,78","22 - 1701,78"]
[null,23,1754.41,{"$f":"RemComplementar(C27)","v":0},null,"23 - 1754,41","23 - 1754,41"]
[null,24,1807.04,{"$f":"RemComplementar(C28)","v":0},null,"24 - 1807,04","24 - 1807,04"]
[null,25,1861.25,{"$f":"RemComplementar(C29)","v":0},null,"25 - 1861,25","25 - 1861,25"]
[null,26,1915.46,{"$f":"RemComplementar(C30)","v":0},null,"26 - 1915,46","26 - 1915,46"]
[null,27,1969.68,{"$f":"RemComplementar(C31)","v":0},null,"27 - 1969,68","27 - 1969,68"]
[null,28,2023.89,{"$f":"RemComplementar(C32)","v":0},null,"28 - 2023,89","28 - 2023,89"]
[null,29,2078.11,{"$f":"RemComplementar(C33)","v":0},null,"29 - 2078,11","29 - 2078,11"]
[null,30,2132.3200000000002,{"$f":"RemComplementar(C34)","v":0},null,"30 - 2132,32","30 - 2132,32"]
[null,31,2186.5300000000002,{"$f":"RemComplementar(C35)","v":0},null,"31 - 2186,53","31 - 2186,53"]
[null,32,2240.7399999999998,{"$f":"RemComplementar(C36)","v":0},null,"32 - 2240,74","32 - 2240,74"]
[null,33,2294.9499999999998,{"$f":"RemComplementar(C37)","v":0},null,"33 - 2294,95","33 - 2294,95"]
[null,34,2349.15,{"$f":"RemComplementar(C38)","v":0},null,"34 - 2349,15","34 - 2349,15"]
[null,35,2403.37,{"$f":"RemComplementar(C39)","v":0},null,"35 - 2403,37","35 - 2403,37"]
[null,36,2457.5700000000002,{"$f":"RemComplementar(C40)","v":0},null,"36 - 2457,57","36 - 2457,57"]
[null,37,2511.81,{"$f":"RemComplementar(C41)","v":0},null,"37 - 2511,81","37 - 2511,81"]
[null,38,2566.0100000000002,{"$f":"RemComplementar(C42)","v":0},null,"38 - 2566,01","38 - 2566,01"]
[null,39,2620.23,{"$f":"RemComplementar(C43)","v":0},null,"39 - 2620,23","39 - 2620,23"]
[null,40,2674.43,{"$f":"RemComplementar(C44)","v":0},null,"40 - 2674,43","40 - 2674,43"]
[null,41,2728.65,{"$f":"RemComplementar(C45)","v":0},null,"41 - 2728,65","41 - 2728,65"]
[null,42,2783.21,{"$f":"RemComplementar(C46)","v":0},null,"42 - 2783,21","42 - 2783,21"]
[null,43,2838.52,{"$f":"RemComplementar(C47)","v":0},null,"43 - 2838,52","43 - 2838,52"]
[null,44,2893.81,{"$f":"RemComplementar(C48)","v":0},null,"44 - 2893,81","44 - 2893,81"]
[null,45,2949.11,{"$f":"RemComplementar(C49)","v":0},null,"45 - 2949,11","45 - 2949,11"]
[null,46,3004.4,{"$f":"RemComplementar(C50)","v":0},null,"46 - 3004,4","46 - 3004,4"]
[null,47,3059.69,{"$f":"RemComplementar(C51)","v":0},null,"47 - 3059,69","47 - 3059,69"]
[null,48,3114.98,{"$f":"RemComplementar(C52)","v":0},null,"48 - 3114,98","48 - 3114,98"]
[null,49,3170.28,{"$f":"RemComplementar(C53)","v":0},null,"49 - 3170,28","49 - 3170,28"]
[null,50,3225.58,{"$f":"RemComplementar(C54)","v":0},null,"50 - 3225,58","50 - 3225,58"]
[null,51,3280.88,{"$f":"RemComplementar(C55)","v":0},null,"51 - 3280,88","51 - 3280,88"]
[null,52,3336.16,{"$f":"RemComplementar(C56)","v":0},null,"52 - 3336,16","52 - 3336,16"]
[null,53,3391.46,{"$f":"RemComplementar(C57)","v":0},null,"53 - 3391,46","53 - 3391,46"]
[null,54,3446.76,{"$f":"RemComplementar(C58)","v":0},null,"54 - 3446,76","54 - 3446,76"]
[null,55,3502.05,{"$f":"RemComplementar(C59)","v":0},null,"55 - 3502,05","55 - 3502,05"]
[null,56,3557.35,{"$f":"RemComplementar(C60)","v":0},null,"56 - 3557,35","56 - 3557,35"]
[null,57,3612.64,{"$f":"RemComplementar(C61)","v":0},null,"57 - 3612,64","57 - 3612,64"]
[null,58,3667.94,{"$f":"RemComplementar(C62)","v":0},null,"58 - 3667,94","58 - 3667,94"]
[null,59,3723.24,{"$f":"RemComplementar(C63)","v":0},null,"59 - 3723,24","59 - 3723,24"]
[null,60,3778.53,{"$f":"RemComplementar(C64)","v":0},null,"60 - 3778,53","60 - 3778,53"]
[null,61,3833.82,{"$f":"RemComplementar(C65)","v":0},null,"61 - 3833,82","61 - 3833,82"]
[null,62,3889.1,{"$f":"RemComplementar(C66)","v":0},null,"62 - 3889,1","62 - 3889,1"]
[null,63,3944.44,{"$f":"RemComplementar(C67)","v":0},null,"63 - 3944,44","63 - 3944,44"]
[null,64,3999.72,{"$f":"RemComplementar(C68)","v":0},null,"64 - 3999,72","64 - 3999,72"]
[null,65,4055.02,{"$f":"RemComplementar(C69)","v":0},null,"65 - 4055,02","65 - 4055,02"]
[null,66,4110.3,{"$f":"RemComplementar(C70)","v":0},null,{"$f":"B70&\" - \"&ROUND(C70,2)","v":"66 - 4110,3"},"66 - 4110,3"]
[null,{"$f":"+B70+1","v":67},4165.6000000000004,{"$f":"RemComplementar(C71)","v":0},null,"67 - 4165,6","67 - 4165,6"]
[null,68,4220.8999999999996,{"$f":"RemComplementar(C72)","v":0},null,"68 - 4220,9","68 - 4220,9"]
[null,69,4276.21,{"$f":"RemComplementar(C73)","v":0},null,"69 - 4276,21","69 - 4276,21"]
[null,70,4331.49,{"$f":"RemComplementar(C74)","v":0},null,"70 - 4331,49","70 - 4331,49"]
[null,71,4386.79,{"$f":"RemComplementar(C75)","v":0},null,"71 - 4386,79","71 - 4386,79"]
[null,72,4442.08,{"$f":"RemComplementar(C76)","v":0},null,"72 - 4442,08","72 - 4442,08"]
[null,73,4497.38,{"$f":"RemComplementar(C77)","v":0},null,"73 - 4497,38","73 - 4497,38"]
[null,74,4552.67,{"$f":"RemComplementar(C78)","v":0},null,"74 - 4552,67","74 - 4552,67"]
[null,75,4607.95,{"$f":"RemComplementar(C79)","v":0},null,"75 - 4607,95","75 - 4607,95"]
[null,76,4663.26,{"$f":"RemComplementar(C80)","v":0},null,"76 - 4663,26","76 - 4663,26"]
[null,77,4718.55,{"$f":"RemComplementar(C81)","v":0},null,"77 - 4718,55","77 - 4718,55"]
[null,78,4773.8599999999997,{"$f":"RemComplementar(C82)","v":0},null,"78 - 4773,86","78 - 4773,86"]
[null,79,4829.1400000000003,{"$f":"RemComplementar(C83)","v":0},null,"79 - 4829,14","79 - 4829,14"]
[null,80,4884.45,{"$f":"RemComplementar(C84)","v":0},null,"80 - 4884,45","80 - 4884,45"]
[null,81,4939.74,{"$f":"RemComplementar(C85)","v":0},null,"81 - 4939,74",{"$f":"B85&\" - \"&ROUND(C85,2)","v":"81 - 4939,74"}]
[null,82,4995.04,{"$f":"RemComplementar(C86)","v":0},null,"82 - 4995,04","82 - 4995,04"]
[null,83,5050.34,{"$f":"RemComplementar(C87)","v":0},null,"83 - 5050,34","83 - 5050,34"]
[null,84,5105.63,{"$f":"RemComplementar(C88)","v":0},null,"84 - 5105,63","84 - 5105,63"]
[null,85,5160.92,{"$f":"RemComplementar(C89)","v":0},null,"85 - 5160,92","85 - 5160,92"]
[null,86,5216.22,{"$f":"RemComplementar(C90)","v":0},null,"86 - 5216,22","86 - 5216,22"]
[null,87,5271.51,{"$f":"RemComplementar(C91)","v":0},null,"87 - 5271,51","87 - 5271,51"]
[null,88,5326.81,{"$f":"RemComplementar(C92)","v":0},null,"88 - 5326,81","88 - 5326,81"]
[null,89,5382.11,{"$f":"RemComplementar(C93)","v":0},null,"89 - 5382,11","89 - 5382,11"]
[null,90,5437.41,{"$f":"RemComplementar(C94)","v":0},null,"90 - 5437,41","90 - 5437,41"]
[null,91,5492.69,{"$f":"RemComplementar(C95)","v":0},null,"91 - 5492,69","91 - 5492,69"]
[null,92,5547.99,{"$f":"RemComplementar(C96)","v":0},null,"92 - 5547,99","92 - 5547,99"]
[null,93,5603.28,{"$f":"RemComplementar(C97)","v":0},null,"93 - 5603,28","93 - 5603,28"]
[null,94,5658.58,{"$f":"RemComplementar(C98)","v":0},null,"94 - 5658,58","94 - 5658,58"]
[null,95,5713.88,{"$f":"RemComplementar(C99)","v":0},null,"95 - 5713,88","95 - 5713,88"]
[null,96,5769.18,{"$f":"RemComplementar(C100)","v":0},null,"96 - 5769,18","96 - 5769,18"]
[null,97,5824.46,{"$f":"RemComplementar(C101)","v":0},null,"97 - 5824,46","97 - 5824,46"]
[null,98,5879.78,{"$f":"RemComplementar(C102)","v":0},null,"98 - 5879,78","98 - 5879,78"]
[null,99,5935.07,{"$f":"RemComplementar(C103)","v":0},null,"99 - 5935,07","99 - 5935,07"]
[null,100,5990.36,{"$f":"RemComplementar(C104)","v":0},null,"100 - 5990,36","100 - 5990,36"]
[null,101,6045.65,{"$f":"RemComplementar(C105)","v":0},null,"101 - 6045,65","101 - 6045,65"]
[null,102,6100.94,{"$f":"RemComplementar(C106)","v":0},null,"102 - 6100,94","102 - 6100,94"]
[null,103,6156.25,{"$f":"RemComplementar(C107)","v":0},null,"103 - 6156,25","103 - 6156,25"]
[null,104,6211.54,{"$f":"RemComplementar(C108)","v":0},null,"104 - 6211,54","104 - 6211,54"]
[null,105,6266.84,{"$f":"RemComplementar(C109)","v":0},null,"105 - 6266,84","105 - 6266,84"]
[null,106,6322.12,{"$f":"RemComplementar(C110)","v":0},null,"106 - 6322,12","106 - 6322,12"]
[null,107,6377.42,{"$f":"RemComplementar(C111)","v":0},null,"107 - 6377,42","107 - 6377,42"]
[null,108,6432.73,{"$f":"RemComplementar(C112)","v":0},null,"108 - 6432,73","108 - 6432,73"]
[null,109,6488.03,{"$f":"RemComplementar(C113)","v":0},null,"109 - 6488,03","109 - 6488,03"]
[null,110,6543.31,{"$f":"RemComplementar(C114)","v":0},null,"110 - 6543,31","110 - 6543,31"]
[null,111,6598.6,{"$f":"RemComplementar(C115)","v":0},null,"111 - 6598,6","111 - 6598,6"]
[null,112,6653.89,{"$f":"RemComplementar(C116)","v":0},null,"112 - 6653,89","112 - 6653,89"]
[null,113,6709.2,{"$f":"RemComplementar(C117)","v":0},null,"113 - 6709,2","113 - 6709,2"]
[null,114,6764.49,{"$f":"RemComplementar(C118)","v":0},null,"114 - 6764,49","114 - 6764,49"]
[null,115,6819.79,{"$f":"RemComplementar(C119)","v":0},null,"115 - 6819,79","115 - 6819,79"]

{"sheet":"Bolsas - Tabela","index":5,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Tabela de Bolsas da FCT"]
["Atualizada a 01/01/2023"]
[]
[null,"Tipo de Bolsa","Grau","Bolsa (Em Portugal)"]
[null,"Bolsa de Pos-Doutoramento ",null,1801,null,{"$f":"B5","v":"Bolsa de Pos-Doutoramento "}]
[null,"Bolsa de Doutoramento",null,1259.6400000000001,null,{"$f":"B6","v":"Bolsa de Doutoramento"}]
[null,"Bolsa de Investigacao","Doutor",1801,null,{"$f":"B7&\" - \"&C7","v":"Bolsa de Investigacao - Doutor"}]
[null,"Bolsa de Investigacao","Mestre",1259.6400000000001,null,{"$f":"B8&\" - \"&C8","v":"Bolsa de Investigacao - Mestre"}]
[null,"Bolsa de Investigacao","Licenciado",990.98,null,{"$f":"B9&\" - \"&C9","v":"Bolsa de Investigacao - Licenciado"}]
[null,"Bolsa de Iniciacao Cientifica",null,601.12,null,{"$f":"B10","v":"Bolsa de Iniciacao Cientifica"}]

{"sheet":"Estagiar - Tabela","index":6,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Tabela de Bolsas da FCT"]
["Atualizada a 01/01/2023"]
[]
[null,"RMMG-RAA",861]
[]
[null,"Tipo de Estágio","Bolsa (Em Portugal)"]
[null,"Estagiar L",{"$f":"+$C$4*1.25","v":1076.25}]
[null,"Estagiar T",{"$f":"+$C$4*1.05","v":904.05000000000007}]
[null,"Estagiar +",{"$f":"+$C$4","v":861}]

{"sheet":"Listas","index":7,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Tipo de Termo",null,"Categorias Profissionais",null,"Sim/Não",null,"Grau Académico",null,"Tipo de Bolsa",null,"Tipo de Estagiário"]
[null,"Certo",null,"Tecnico Superior",null,"Sim",null,"Doutor",null,"Bolsa de Pos-Doutoramento ",null,"Estagiar T"]
[null,"Incerto",null,"Assistente Tecnico",null,"Nao",null,"Mestre",null,"Bolsa de Doutoramento",null,"Estagiar L"]
[null,null,null,null,null,null,null,"Licenciado",null,"Bolsa de Investigacao",null,"Estagiar +"]
[null,null,null,null,null,null,null,null,null,"Bolsa de Iniciacao Cientifica"]