{"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-02-07"]
[]
[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":14,"rows_kept":106,"cut":false,"hidden":false,"merged":[[43,11,44,11],[43,12,44,12],[43,13,44,13],[2,2,2,13],[3,2,3,13],[41,1,41,5],[26,1,26,5],[13,1,13,5],[21,1,21,5],[22,1,22,5],[11,1,11,5],[12,1,12,5],[19,1,19,5],[20,1,20,5],[40,1,40,5],[36,1,36,5]]}
[]
[]
[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,"Versão","2023-04-19"]
[]
[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)",12]
[]
[null,"Categoria Profissional","Técnico 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?","Não"]
[]
[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 - 1333,35",null,null,{"$f":"INT(LEFT(C29,(FIND(\" \",C29,1)-1)))","v":16}]
[]
[null,"Data de Início (Mês/Ano)","2023-03-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","Subsídio de Natal","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","CE 010114SNDO","CE 010114SFDO","CE 010212","CE 010305A0B0","CE 010309"]
[]
[1,{"$f":"C31","v":"2023-03-01"},{"$f":"IF(A47<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1333.35},{"$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($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},{"$f":"IF(MONTH(B47)=11,C47+E47,0)","v":0},{"$f":"IF(MONTH(B47)=6,C47+E47,0)","v":0},{"$f":"IF(A47=$C$16,C47/30*2*fldDuracao,0)","v":0},{"$f":"(C47+E47+F47+G47)*22.3%","v":297.33704999999998},{"$f":"2%*C47","v":26.666999999999998},{"$f":"YEAR(B47)","v":2023},{"$f":"((C47+E47+F47+G47+IF(H47>6500,H47-6500,0))*$C$33)","v":93.334500000000006},{"$f":"(C47+E47+F47+G47)*$C$35","v":146.66849999999999},{"$f":"SUM(C47:H47)-SUM(L47:M47)","v":1225.347}]
[{"$f":"+A47+1","v":2},{"$f":"DATE(YEAR(B47),MONTH(B47)+1,DAY(B47))","v":"2023-04-01"},{"$f":"IF(A48<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1333.35},{"$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($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},{"$f":"IF(MONTH(B48)=11,C48+E48,0)","v":0},{"$f":"IF(MONTH(B48)=6,C48+E48,0)","v":0},0,{"$f":"(C48+E48+F48+G48)*22.3%","v":297.33704999999998},{"$f":"2%*C48","v":26.666999999999998},{"$f":"YEAR(B48)","v":2023},{"$f":"((C48+E48+F48+G48+IF(H48>6500,H48-6500,0))*$C$33)","v":93.334500000000006},{"$f":"(C48+E48+F48+G48)*$C$35","v":146.66849999999999},{"$f":"SUM(C48:H48)-SUM(L48:M48)","v":1225.347}]
[{"$f":"+A48+1","v":3},{"$f":"DATE(YEAR(B48),MONTH(B48)+1,DAY(B48))","v":"2023-05-01"},{"$f":"IF(A49<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1333.35},132,{"$f":"IF(A49<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,0,0,297.33704999999998,26.666999999999998,2023,93.334500000000006,146.66849999999999,1225.347]
[4,"2023-06-01",{"$f":"IF(A50<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1333.35},0,{"$f":"IF(A50<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,1333.35,0,594.67409999999995,26.666999999999998,2023,186.66900000000001,293.33699999999999,2186.694]
[5,"2023-07-01",{"$f":"IF(A51<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1333.35},132,{"$f":"IF(A51<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,0,0,297.33704999999998,26.666999999999998,2023,93.334500000000006,146.66849999999999,1225.347]
[6,"2023-08-01",{"$f":"IF(A52<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1333.35},132,{"$f":"IF(A52<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,0,0,297.33704999999998,26.666999999999998,2023,93.334500000000006,146.66849999999999,1225.347]
[7,"2023-09-01",{"$f":"IF(A53<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1333.35},132,{"$f":"IF(A53<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,0,0,297.33704999999998,26.666999999999998,2023,93.334500000000006,146.66849999999999,1225.347]
[8,"2023-10-01",{"$f":"IF(A54<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1333.35},132,{"$f":"IF(A54<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,0,0,297.33704999999998,26.666999999999998,2023,93.334500000000006,146.66849999999999,1225.347]
[9,"2023-11-01",{"$f":"IF(A55<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1333.35},132,{"$f":"IF(A55<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},1333.35,0,0,594.67409999999995,26.666999999999998,2023,186.66900000000001,293.33699999999999,2318.694]
[10,"2023-12-01",{"$f":"IF(A56<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1333.35},132,{"$f":"IF(A56<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,0,0,297.33704999999998,26.666999999999998,2023,93.334500000000006,146.66849999999999,1225.347]
[11,"2024-01-01",{"$f":"IF(A57<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1333.35},132,{"$f":"IF(A57<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,0,0,297.33704999999998,26.666999999999998,2024,93.334500000000006,146.66849999999999,1225.347]
[12,"2024-02-01",{"$f":"IF(A58<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":1333.35},132,{"$f":"IF(A58<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,0,1066.68,297.33704999999998,26.666999999999998,2024,93.334500000000006,146.66849999999999,2292.0269999999996]
[]
[null,"Total Ano 1",{"$f":"SUM(C47:C58)","v":16000.200000000003},{"$f":"SUM(D47:D58)","v":1452},{"$f":"SUM(E47:E58)","v":0},1333.35,1333.35,1066.68,4162.7187000000004,320.00399999999991,null,1306.683,2053.3589999999999,17825.537999999997]
[]
[{"$f":"+A58+1","v":13},{"$f":"DATE(YEAR(B58),MONTH(B58)+1,DAY(B58))","v":"2024-03-01"},{"$f":"IF(A62<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},{"$f":"IF(AND(A62<=$C$16,MONTH(B62)<>6),22*6,0)","v":0},{"$f":"IF(A62<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},{"$f":"IF(MONTH(B62)=11,C62+E62,0)","v":0},{"$f":"IF(MONTH(B62)=6,C62+E62,0)","v":0},{"$f":"IF(A62=$C$16,C62/30*2*fldDuracao,0)","v":0},{"$f":"(C62+E62+F62+G62)*22.3%","v":0},{"$f":"2%*C62","v":0},{"$f":"YEAR(B62)","v":2024},{"$f":"((C62+E62+F62+G62+IF(H62>6500,H62-6500,0))*$C$33)","v":0},{"$f":"(C62+E62+F62+G62)*$C$35","v":0},{"$f":"SUM(C62:H62)-SUM(L62:M62)","v":0}]
[{"$f":"+A62+1","v":14},{"$f":"DATE(YEAR(B62),MONTH(B62)+1,DAY(B62))","v":"2024-04-01"},{"$f":"IF(A63<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},{"$f":"IF(AND(A63<=$C$16,MONTH(B63)<>6),22*6,0)","v":0},{"$f":"IF(A63<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},{"$f":"IF(MONTH(B63)=11,C63+E63,0)","v":0},0,0,0,0,{"$f":"YEAR(B63)","v":2024},0,0,0]
[{"$f":"+A63+1","v":15},{"$f":"DATE(YEAR(B63),MONTH(B63)+1,DAY(B63))","v":"2024-05-01"},{"$f":"IF(A64<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,{"$f":"IF(A64<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,0,0,0,0,2024,0,0,0]
[16,"2024-06-01",{"$f":"IF(A65<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,{"$f":"IF(A65<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,0,0,0,0,2024,0,0,0]
[17,"2024-07-01",{"$f":"IF(A66<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,{"$f":"IF(A66<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,0,0,0,0,2024,0,0,0]
[18,"2024-08-01",{"$f":"IF(A67<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,{"$f":"IF(A67<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,0,0,0,0,2024,0,0,0]
[19,"2024-09-01",{"$f":"IF(A68<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,{"$f":"IF(A68<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,0,0,0,0,2024,0,0,0]
[20,"2024-10-01",{"$f":"IF(A69<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,{"$f":"IF(A69<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,0,0,0,0,2024,0,0,0]
[21,"2024-11-01",{"$f":"IF(A70<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,{"$f":"IF(A70<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,0,0,0,0,2024,0,0,0]
[22,"2024-12-01",{"$f":"IF(A71<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,{"$f":"IF(A71<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,0,0,0,0,2024,0,0,0]
[23,"2025-01-01",{"$f":"IF(A72<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,{"$f":"IF(A72<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,0,0,0,0,2025,0,0,0]
[24,"2025-02-01",{"$f":"IF(A73<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,{"$f":"IF(A73<=$C$16,INDEX('CT - Tabela'!$D$5:$D$119,MATCH($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,0,0,0,0,2025,0,0,0]
[]
[null,"Total Ano 2",{"$f":"SUM(C62:C73)","v":0},{"$f":"SUM(D62:D73)","v":0},0,0,0,{"$f":"SUM(H62:H73)","v":0},0,0,null,{"$f":"SUM(L62:L73)","v":0},0,0]
[]
[{"$f":"+A73+1","v":25},{"$f":"DATE(YEAR(B73),MONTH(B73)+1,DAY(B73))","v":"2025-03-01"},{"$f":"IF(A77<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$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($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},{"$f":"IF(MONTH(B77)=11,C77+E77,0)","v":0},{"$f":"IF(MONTH(B77)=6,C77+E77,0)","v":0},{"$f":"IF(A77=$C$16,C77/30*2*fldDuracao,0)","v":0},{"$f":"(C77+E77+F77+G77)*22.3%","v":0},{"$f":"2%*C77","v":0},{"$f":"YEAR(B77)","v":2025},{"$f":"((C77+E77+F77+G77+IF(H77>6500,H77-6500,0))*$C$33)","v":0},{"$f":"(C77+E77+F77+G77)*$C$35","v":0},{"$f":"SUM(C77:H77)-SUM(L77:M77)","v":0}]
[{"$f":"+A77+1","v":26},{"$f":"DATE(YEAR(B77),MONTH(B77)+1,DAY(B77))","v":"2025-04-01"},{"$f":"IF(A78<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$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($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},{"$f":"IF(MONTH(B78)=11,C78+E78,0)","v":0},0,0,0,0,2025,0,0,0]
[{"$f":"+A78+1","v":27},{"$f":"DATE(YEAR(B78),MONTH(B78)+1,DAY(B78))","v":"2025-05-01"},{"$f":"IF(A79<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$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($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,0,0,0,0,2025,0,0,0]
[28,"2025-06-01",{"$f":"IF(A80<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$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($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,0,0,0,0,2025,0,0,0]
[29,"2025-07-01",{"$f":"IF(A81<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$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($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,0,0,0,0,2025,0,0,0]
[30,"2025-08-01",{"$f":"IF(A82<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$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($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,0,0,0,0,2025,0,0,0]
[31,"2025-09-01",{"$f":"IF(A83<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$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($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,0,0,0,0,2025,0,0,0]
[32,"2025-10-01",{"$f":"IF(A84<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$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($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,0,0,0,0,2025,0,0,0]
[33,"2025-11-01",{"$f":"IF(A85<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$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($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,0,0,0,0,2025,0,0,0]
[34,"2025-12-01",{"$f":"IF(A86<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$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($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,0,0,0,0,2025,0,0,0]
[35,"2026-01-01",{"$f":"IF(A87<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$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($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},0,0,0,0,0,2026,0,0,0]
[36,"2026-02-01",{"$f":"IF(A88<=$C$16,INDEX('CT - Tabela'!$C$5:$C$119,MATCH($F$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($F$29,'CT - Tabela'!$B$5:$B$119,0)),0)","v":0},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},0,0,0,0,0,null,{"$f":"SUM(L77:L88)","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":2023},{"$f":"+D95+1","v":2024},{"$f":"+E95+1","v":2025},2026,"Total"]
[]
[null,null,"Vencimento Base\nCE 010106",{"$f":"SUMIF($K$47:$K$90,D$95,$C$47:$C$90)","v":13333.500000000002},{"$f":"SUMIF($K$47:$K$90,E$95,$C$47:$C$90)","v":2666.7},0,0,{"$f":"SUM(D97:G97)","v":16000.2}]
[null,null,"Subsídio de Alimentação\nCE 010113",{"$f":"SUMIF($K$47:$K$90,D$95,$D$47:$D$90)","v":1188},{"$f":"SUMIF($K$47:$K$90,E$95,$D$47:$D$90)","v":264},0,0,{"$f":"SUM(D98:G98)","v":1452}]
[null,null,"Renum. Complementar\nCE 010213RC00",{"$f":"SUMIF($K$47:$K$90,D$95,$E$47:$E$90)","v":0},{"$f":"SUMIF($K$47:$K$90,E$95,$E$47:$E$90)","v":0},0,0,0]
[null,null,"Subsídio de Natal\nCE 010114SN00",{"$f":"SUMIF($K$47:$K$90,D$95,$F$47:$F$90)","v":1333.35},{"$f":"SUMIF($K$47:$K$90,E$95,$F$47:$F$90)","v":0},0,0,1333.35]
[null,null,"Subsídio de Férias\nCE 010114SF00",{"$f":"SUMIF($K$47:$K$90,D$95,$G$47:$G$90)","v":1333.35},{"$f":"SUMIF($K$47:$K$90,E$95,$G$47:$G$90)","v":0},0,0,1333.35]
[null,null,"Compl. Termo Contrato\nCE 010212",{"$f":"SUMIF($K$47:$K$90,D$95,$H$47:$H$90)","v":0},{"$f":"SUMIF($K$47:$K$90,E$95,$H$47:$H$90)","v":1066.68},0,0,1066.68]
[null,null,"Encargos Seg. Social\nCE 010305A0B0",{"$f":"SUMIF($K$47:$K$90,D$95,$I$47:$I$90)","v":3568.0446000000002},{"$f":"SUMIF($K$47:$K$90,E$95,$I$47:$I$90)","v":594.67409999999995},0,0,4162.7187000000004]
[null,null,"Seguro de Ac. de Trab.\nCE 010309",{"$f":"SUMIF($K$47:$K$90,D$95,$J$47:$J$90)","v":266.66999999999996},{"$f":"SUMIF($K$47:$K$90,E$95,$J$47:$J$90)","v":53.333999999999996},0,0,320.00399999999996]
[]
[null,null,"Total",{"$f":"SUM(D97:D104)","v":21022.9146},{"$f":"SUM(E97:E104)","v":4645.3881000000001},0,0,{"$f":"SUM(H97:H104)","v":25668.3027}]

{"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","2023-02-17"]
[]
[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)","2023-05-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":997.5}]
[]
[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":"2023-05-01"},0,{"$f":"$C$27*22.3%","v":222.4425},{"$f":"2%*$C$27","v":19.95},{"$f":"YEAR(B36)","v":2023}]
[{"$f":"+A36+1","v":2},{"$f":"DATE(YEAR(B36),MONTH(B36)+1,DAY(B36))","v":"2023-06-01"},0,{"$f":"$C$27*22.3%","v":222.4425},{"$f":"2%*$C$27","v":19.95},{"$f":"YEAR(B37)","v":2023}]
[{"$f":"+A37+1","v":3},{"$f":"DATE(YEAR(B37),MONTH(B37)+1,DAY(B37))","v":"2023-07-01"},0,222.4425,19.95,2023]
[4,"2023-08-01",0,222.4425,19.95,2023]
[5,"2023-09-01",0,222.4425,19.95,2023]
[6,"2023-10-01",0,222.4425,19.95,2023]
[7,"2023-11-01",0,222.4425,19.95,2023]
[8,"2023-12-01",0,222.4425,19.95,2023]
[9,"2024-01-01",0,222.4425,19.95,2024]
[10,"2024-02-01",0,222.4425,19.95,2024]
[11,"2024-03-01",0,222.4425,19.95,2024]
[12,"2024-04-01",0,222.4425,19.95,2024]
[]
[null,"Total Ano 1",{"$f":"SUM(C36:C47)","v":0},{"$f":"SUM(D36:D47)","v":2669.3100000000009},{"$f":"SUM(E36:E47)","v":239.39999999999995}]
[]
[null,{"$f":"DATE(YEAR(B47),MONTH(B47)+1,DAY(B47))","v":"2024-05-01"},{"$f":"IF(fldProrrogacao=\"Sim\",fldPosicaoRemuneratoria*30%,0)","v":299.25},{"$f":"IF(fldProrrogacao=\"Sim\",$C$27*22.3%,0)","v":222.4425},{"$f":"IF(fldProrrogacao=\"Sim\",2%*$C$27,0)","v":19.95},{"$f":"YEAR(B51)","v":2024}]
[null,{"$f":"DATE(YEAR(B51),MONTH(B51)+1,DAY(B51))","v":"2024-06-01"},{"$f":"IF(fldProrrogacao=\"Sim\",fldPosicaoRemuneratoria*30%,0)","v":299.25},{"$f":"IF(fldProrrogacao=\"Sim\",$C$27*22.3%,0)","v":222.4425},{"$f":"IF(fldProrrogacao=\"Sim\",2%*$C$27,0)","v":19.95},2024]
[null,"2024-07-01",{"$f":"IF(fldProrrogacao=\"Sim\",fldPosicaoRemuneratoria*30%,0)","v":299.25},{"$f":"IF(fldProrrogacao=\"Sim\",$C$27*22.3%,0)","v":222.4425},{"$f":"IF(fldProrrogacao=\"Sim\",2%*$C$27,0)","v":19.95},2024]
[]
[null,"Total Prorrogação",{"$f":"SUM(C51:C53)","v":897.75},{"$f":"SUM(D51:D53)","v":667.32749999999999},{"$f":"SUM(E51:E53)","v":59.849999999999994}]
[]
[null,"Resumo da Imputação ao Centro de Custos por Ano e Conta Económica"]
[]
[null,"Conta Económica",{"$f":"YEAR(fldDatadeInicio)","v":2023},{"$f":"+C59+1","v":2024},{"$f":"+D59+1","v":2025},"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":897.75},0,{"$f":"SUM(C61:E61)","v":897.75}]
[null,"Encargos Seg. Social\nCE 010305A0B0",{"$f":"SUMIF($F$36:$F$55,C$59,$D$36:$D$55)","v":1779.5400000000004},{"$f":"SUMIF($F$36:$F$55,D$59,$D$36:$D$55)","v":1557.0975000000003},0,{"$f":"SUM(C62:E62)","v":3336.6375000000007}]
[null,"Seguro de Ac. de Trabalho\nCE 020212B000",{"$f":"SUMIF($F$36:$F$55,C$59,$E$36:$E$55)","v":159.6},{"$f":"SUMIF($F$36:$F$55,D$59,$E$36:$E$55)","v":139.65},0,299.25]
[]
[null,"Total",{"$f":"SUM(C61:C63)","v":1939.1400000000003},{"$f":"SUM(D61:D63)","v":2594.4975000000004},0,4533.6375000000007]

{"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","2023-02-17"]
[]
[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 Investigação",{"$f":"IF(fldTipoDeBolseiro=\"Bolsa de Investigação\",fldTipoDeBolseiro&\" - \"&fldGrauAcademico,fldTipoDeBolseiro)","v":"Bolsa de Investigação - Licenciado"}]
[]
[null,"Grau Académico do Bolseiro","Licenciado"]
[]
[null,"Data de Início (Mês/Ano)","2023-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":930.98}]
[]
[null," Indexante dos Apoios Sociais",480.43]
[]
[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":"2023-01-01"},{"$f":"fldPosicaoRemuneratoria","v":930.98},{"$f":"C23*29.6%","v":142.20728000000003},{"$f":"2%*C33","v":18.619600000000002},{"$f":"YEAR(B33)","v":2023}]
[{"$f":"+A33+1","v":2},{"$f":"DATE(YEAR(B33),MONTH(B33)+1,DAY(B33))","v":"2023-02-01"},930.98,{"$f":"+D33","v":142.20728000000003},{"$f":"2%*C34","v":18.619600000000002},{"$f":"YEAR(B34)","v":2023}]
[{"$f":"+A34+1","v":3},{"$f":"DATE(YEAR(B34),MONTH(B34)+1,DAY(B34))","v":"2023-03-01"},930.98,{"$f":"+D34","v":142.20728000000003},18.619600000000002,2023]
[4,"2023-04-01",930.98,142.20728000000003,18.619600000000002,2023]
[5,"2023-05-01",930.98,142.20728000000003,18.619600000000002,2023]
[6,"2023-06-01",930.98,142.20728000000003,18.619600000000002,2023]
[7,"2023-07-01",930.98,142.20728000000003,18.619600000000002,2023]
[8,"2023-08-01",930.98,142.20728000000003,18.619600000000002,2023]
[9,"2023-09-01",930.98,142.20728000000003,18.619600000000002,2023]
[10,"2023-10-01",930.98,142.20728000000003,18.619600000000002,2023]
[11,"2023-11-01",930.98,142.20728000000003,18.619600000000002,2023]
[12,"2023-12-01",930.98,142.20728000000003,18.619600000000002,2023]
[]
[null,"Total Ano 1",{"$f":"SUM(C33:C44)","v":11171.759999999997},{"$f":"SUM(D33:D44)","v":1706.4873600000008},{"$f":"SUM(E33:E44)","v":223.43519999999998}]
[]
[null,"Resumo da Imputação ao Centro de Custos por Ano e Conta Económica"]
[]
[null,"Conta Económica",{"$f":"YEAR(fldDatadeInicio)","v":2023},{"$f":"+C50+1","v":2024},"Total"]
[]
[null,"Valor da Bolsa\nCE 040802BE00",{"$f":"SUMIF($F$33:$F$44,C$50,$C$33:$C$44)","v":11171.759999999997},{"$f":"SUMIF($F$33:$F$44,D$50,$C$33:$C$44)","v":0},{"$f":"SUM(C52:D52)","v":11171.759999999997}]
[null,"Seguro Social Voluntário\nCE 010305A0O0",{"$f":"SUMIF($F$33:$F$44,C$50,$D$33:$D$44)","v":1706.4873600000008},{"$f":"SUMIF($F$33:$F$44,D$50,$D$33:$D$44)","v":0},{"$f":"SUM(C53:D53)","v":1706.4873600000008}]
[null,"Seguro de Ac. de Trabalho\nCE 020212B000",{"$f":"SUMIF($F$33:$F$44,C$50,$E$33:$E$44)","v":223.43519999999998},{"$f":"SUMIF($F$33:$F$44,D$50,$E$33:$E$44)","v":0},223.43519999999998]
[]
[null,"Total",{"$f":"SUM(C52:C54)","v":13101.682559999997},{"$f":"SUM(D52:D54)","v":0},13101.682559999997]

{"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 19/04/2023",null,null,null,null,null,null,null,"Atualizada a 19/04/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,709.46,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,709.47,714.94,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,714.95,720.42,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,720.43,790.04,0.8,64.36,0,64.36]
[null,5,769.2,{"$f":"RemComplementar(C9)","v":64.36},null,"5 - 769,2",null,null,790.05,866.72,0.7,56.314999999999998,0,56.32]
[null,6,817.22,{"$f":"RemComplementar(C10)","v":56.32},null,"6 - 817,22",null,null,866.73,935.33,0.6,48.27,0,48.27]
[null,7,869.84,{"$f":"RemComplementar(C11)","v":48.27},null,"7 - 869,84",null,null,935.34,1058.43,0.55000000000000004,44.247500000000002,0,44.25]
[null,8,908.77,{"$f":"RemComplementar(C12)","v":48.27},null,"8 - 908,77",null,null,1058.44,1109.8900000000001,0.45,36.202500000000001,0,36.200000000000003]
[null,9,964.93,{"$f":"RemComplementar(C13)","v":44.25},null,"9 - 964,93",null,null,1109.9000000000001,1144.2,0.4,32.18,0,32.18]
[null,10,1017.56,{"$f":"RemComplementar(C14)","v":44.25},null,"10 - 1017,56",null,null,1144.21,1230.97,0.35,28.157499999999999,0,28.16]
[null,11,1070.19,{"$f":"RemComplementar(C15)","v":36.200000000000003},null,"11 - 1070,19",null,null,1230.98,1320.77,0.25,20.112500000000001,0,20.11]
[null,12,1122.83,{"$f":"RemComplementar(C16)","v":32.18},null,"12 - 1122,83"]
[null,13,1175.46,{"$f":"RemComplementar(C17)","v":28.16},null,"13 - 1175,46"]
[null,14,1228.0899999999999,{"$f":"RemComplementar(C18)","v":28.16},null,"14 - 1228,09"]
[null,15,1280.72,{"$f":"RemComplementar(C19)","v":20.11},null,"15 - 1280,72"]
[null,16,1333.35,{"$f":"RemComplementar(C20)","v":0},null,"16 - 1333,35",{"$f":"B20&\" - \"&ROUND(C20,2)","v":"16 - 1333,35"}]
[null,17,1385.99,{"$f":"RemComplementar(C21)","v":0},null,"17 - 1385,99",{"$f":"B21&\" - \"&ROUND(C21,2)","v":"17 - 1385,99"}]
[null,18,1438.62,{"$f":"RemComplementar(C22)","v":0},null,"18 - 1438,62","18 - 1438,62"]
[null,19,1491.25,{"$f":"RemComplementar(C23)","v":0},null,"19 - 1491,25","19 - 1491,25"]
[null,20,1543.88,{"$f":"RemComplementar(C24)","v":0},null,"20 - 1543,88","20 - 1543,88"]
[null,21,1596.51,{"$f":"RemComplementar(C25)","v":0},null,"21 - 1596,51","21 - 1596,51"]
[null,22,1649.15,{"$f":"RemComplementar(C26)","v":0},null,"22 - 1649,15","22 - 1649,15"]
[null,23,1701.78,{"$f":"RemComplementar(C27)","v":0},null,"23 - 1701,78","23 - 1701,78"]
[null,24,1754.41,{"$f":"RemComplementar(C28)","v":0},null,"24 - 1754,41","24 - 1754,41"]
[null,25,1807.04,{"$f":"RemComplementar(C29)","v":0},null,"25 - 1807,04","25 - 1807,04"]
[null,26,1859.67,{"$f":"RemComplementar(C30)","v":0},null,"26 - 1859,67","26 - 1859,67"]
[null,27,1912.31,{"$f":"RemComplementar(C31)","v":0},null,"27 - 1912,31","27 - 1912,31"]
[null,28,1964.95,{"$f":"RemComplementar(C32)","v":0},null,"28 - 1964,95","28 - 1964,95"]
[null,29,2017.58,{"$f":"RemComplementar(C33)","v":0},null,"29 - 2017,58","29 - 2017,58"]
[null,30,2070.21,{"$f":"RemComplementar(C34)","v":0},null,"30 - 2070,21","30 - 2070,21"]
[null,31,2122.84,{"$f":"RemComplementar(C35)","v":0},null,"31 - 2122,84","31 - 2122,84"]
[null,32,2175.48,{"$f":"RemComplementar(C36)","v":0},null,"32 - 2175,48","32 - 2175,48"]
[null,33,2228.11,{"$f":"RemComplementar(C37)","v":0},null,"33 - 2228,11","33 - 2228,11"]
[null,34,2280.7399999999998,{"$f":"RemComplementar(C38)","v":0},null,"34 - 2280,74","34 - 2280,74"]
[null,35,2333.37,{"$f":"RemComplementar(C39)","v":0},null,"35 - 2333,37","35 - 2333,37"]
[null,36,2386,{"$f":"RemComplementar(C40)","v":0},null,"36 - 2386","36 - 2386"]
[null,37,2438.64,{"$f":"RemComplementar(C41)","v":0},null,"37 - 2438,64","37 - 2438,64"]
[null,38,2491.27,{"$f":"RemComplementar(C42)","v":0},null,"38 - 2491,27","38 - 2491,27"]
[null,39,2543.9,{"$f":"RemComplementar(C43)","v":0},null,"39 - 2543,9","39 - 2543,9"]
[null,40,2596.5300000000002,{"$f":"RemComplementar(C44)","v":0},null,"40 - 2596,53","40 - 2596,53"]
[null,41,2649.16,{"$f":"RemComplementar(C45)","v":0},null,"41 - 2649,16","41 - 2649,16"]
[null,42,2702.14,{"$f":"RemComplementar(C46)","v":0},null,"42 - 2702,14","42 - 2702,14"]
[null,43,2755.84,{"$f":"RemComplementar(C47)","v":0},null,"43 - 2755,84","43 - 2755,84"]
[null,44,2809.52,{"$f":"RemComplementar(C48)","v":0},null,"44 - 2809,52","44 - 2809,52"]
[null,45,2863.2,{"$f":"RemComplementar(C49)","v":0},null,"45 - 2863,2","45 - 2863,2"]
[null,46,2916.89,{"$f":"RemComplementar(C50)","v":0},null,"46 - 2916,89","46 - 2916,89"]
[null,47,2970.57,{"$f":"RemComplementar(C51)","v":0},null,"47 - 2970,57","47 - 2970,57"]
[null,48,3024.26,{"$f":"RemComplementar(C52)","v":0},null,"48 - 3024,26","48 - 3024,26"]
[null,49,3077.95,{"$f":"RemComplementar(C53)","v":0},null,"49 - 3077,95","49 - 3077,95"]
[null,50,3131.63,{"$f":"RemComplementar(C54)","v":0},null,"50 - 3131,63","50 - 3131,63"]
[null,51,3185.31,{"$f":"RemComplementar(C55)","v":0},null,"51 - 3185,31","51 - 3185,31"]
[null,52,3238.99,{"$f":"RemComplementar(C56)","v":0},null,"52 - 3238,99","52 - 3238,99"]
[null,53,3292.69,{"$f":"RemComplementar(C57)","v":0},null,"53 - 3292,69","53 - 3292,69"]
[null,54,3346.37,{"$f":"RemComplementar(C58)","v":0},null,"54 - 3346,37","54 - 3346,37"]
[null,55,3400.16,{"$f":"RemComplementar(C59)","v":0},null,"55 - 3400,16","55 - 3400,16"]
[null,56,3453.74,{"$f":"RemComplementar(C60)","v":0},null,"56 - 3453,74","56 - 3453,74"]
[null,57,3507.42,{"$f":"RemComplementar(C61)","v":0},null,"57 - 3507,42","57 - 3507,42"]
[null,58,3561.11,{"$f":"RemComplementar(C62)","v":0},null,"58 - 3561,11","58 - 3561,11"]
[null,59,3614.8,{"$f":"RemComplementar(C63)","v":0},null,"59 - 3614,8","59 - 3614,8"]
[null,60,3668.48,{"$f":"RemComplementar(C64)","v":0},null,"60 - 3668,48","60 - 3668,48"]
[null,61,3722.16,{"$f":"RemComplementar(C65)","v":0},null,"61 - 3722,16","61 - 3722,16"]
[null,62,3775.84,{"$f":"RemComplementar(C66)","v":0},null,"62 - 3775,84","62 - 3775,84"]
[null,63,3829.54,{"$f":"RemComplementar(C67)","v":0},null,"63 - 3829,54","63 - 3829,54"]
[null,64,3883.22,{"$f":"RemComplementar(C68)","v":0},null,"64 - 3883,22","64 - 3883,22"]
[null,65,3936.9,{"$f":"RemComplementar(C69)","v":0},null,"65 - 3936,9","65 - 3936,9"]
[null,66,3990.59,{"$f":"RemComplementar(C70)","v":0},null,{"$f":"B70&\" - \"&ROUND(C70,2)","v":"66 - 3990,59"},"66 - 3990,59"]
[null,{"$f":"+B70+1","v":67},4044.27,{"$f":"RemComplementar(C71)","v":0},null,"67 - 4044,27","67 - 4044,27"]
[null,68,4097.96,{"$f":"RemComplementar(C72)","v":0},null,"68 - 4097,96","68 - 4097,96"]
[null,69,4151.6499999999996,{"$f":"RemComplementar(C73)","v":0},null,"69 - 4151,65","69 - 4151,65"]
[null,70,4205.33,{"$f":"RemComplementar(C74)","v":0},null,"70 - 4205,33","70 - 4205,33"]
[null,71,4259.01,{"$f":"RemComplementar(C75)","v":0},null,"71 - 4259,01","71 - 4259,01"]
[null,72,4312.7,{"$f":"RemComplementar(C76)","v":0},null,"72 - 4312,7","72 - 4312,7"]
[null,73,4366.3900000000003,{"$f":"RemComplementar(C77)","v":0},null,"73 - 4366,39","73 - 4366,39"]
[null,74,4420.07,{"$f":"RemComplementar(C78)","v":0},null,"74 - 4420,07","74 - 4420,07"]
[null,75,4473.75,{"$f":"RemComplementar(C79)","v":0},null,"75 - 4473,75","75 - 4473,75"]
[null,76,4527.4399999999996,{"$f":"RemComplementar(C80)","v":0},null,"76 - 4527,44","76 - 4527,44"]
[null,77,4581.12,{"$f":"RemComplementar(C81)","v":0},null,"77 - 4581,12","77 - 4581,12"]
[null,78,4634.8100000000004,{"$f":"RemComplementar(C82)","v":0},null,"78 - 4634,81","78 - 4634,81"]
[null,79,4688.5,{"$f":"RemComplementar(C83)","v":0},null,"79 - 4688,5","79 - 4688,5"]
[null,80,4742.18,{"$f":"RemComplementar(C84)","v":0},null,"80 - 4742,18","80 - 4742,18"]
[null,81,4795.8599999999997,{"$f":"RemComplementar(C85)","v":0},null,"81 - 4795,86",{"$f":"B85&\" - \"&ROUND(C85,2)","v":"81 - 4795,86"}]
[null,82,4849.55,{"$f":"RemComplementar(C86)","v":0},null,"82 - 4849,55","82 - 4849,55"]
[null,83,4903.24,{"$f":"RemComplementar(C87)","v":0},null,"83 - 4903,24","83 - 4903,24"]
[null,84,4956.92,{"$f":"RemComplementar(C88)","v":0},null,"84 - 4956,92","84 - 4956,92"]
[null,85,5010.6099999999997,{"$f":"RemComplementar(C89)","v":0},null,"85 - 5010,61","85 - 5010,61"]
[null,86,5064.29,{"$f":"RemComplementar(C90)","v":0},null,"86 - 5064,29","86 - 5064,29"]
[null,87,5117.97,{"$f":"RemComplementar(C91)","v":0},null,"87 - 5117,97","87 - 5117,97"]
[null,88,5171.66,{"$f":"RemComplementar(C92)","v":0},null,"88 - 5171,66","88 - 5171,66"]
[null,89,5225.3500000000004,{"$f":"RemComplementar(C93)","v":0},null,"89 - 5225,35","89 - 5225,35"]
[null,90,5279.03,{"$f":"RemComplementar(C94)","v":0},null,"90 - 5279,03","90 - 5279,03"]
[null,91,5332.71,{"$f":"RemComplementar(C95)","v":0},null,"91 - 5332,71","91 - 5332,71"]
[null,92,5386.4,{"$f":"RemComplementar(C96)","v":0},null,"92 - 5386,4","92 - 5386,4"]
[null,93,5440.09,{"$f":"RemComplementar(C97)","v":0},null,"93 - 5440,09","93 - 5440,09"]
[null,94,5493.77,{"$f":"RemComplementar(C98)","v":0},null,"94 - 5493,77","94 - 5493,77"]
[null,95,5547.46,{"$f":"RemComplementar(C99)","v":0},null,"95 - 5547,46","95 - 5547,46"]
[null,96,5601.14,{"$f":"RemComplementar(C100)","v":0},null,"96 - 5601,14","96 - 5601,14"]
[null,97,5654.82,{"$f":"RemComplementar(C101)","v":0},null,"97 - 5654,82","97 - 5654,82"]
[null,98,5708.52,{"$f":"RemComplementar(C102)","v":0},null,"98 - 5708,52","98 - 5708,52"]
[null,99,5762.2,{"$f":"RemComplementar(C103)","v":0},null,"99 - 5762,2","99 - 5762,2"]
[null,100,5815.88,{"$f":"RemComplementar(C104)","v":0},null,"100 - 5815,88","100 - 5815,88"]
[null,101,5869.56,{"$f":"RemComplementar(C105)","v":0},null,"101 - 5869,56","101 - 5869,56"]
[null,102,5923.25,{"$f":"RemComplementar(C106)","v":0},null,"102 - 5923,25","102 - 5923,25"]
[null,103,5976.94,{"$f":"RemComplementar(C107)","v":0},null,"103 - 5976,94","103 - 5976,94"]
[null,104,6030.62,{"$f":"RemComplementar(C108)","v":0},null,"104 - 6030,62","104 - 6030,62"]
[null,105,6084.31,{"$f":"RemComplementar(C109)","v":0},null,"105 - 6084,31","105 - 6084,31"]
[null,106,6137.99,{"$f":"RemComplementar(C110)","v":0},null,"106 - 6137,99","106 - 6137,99"]
[null,107,6191.67,{"$f":"RemComplementar(C111)","v":0},null,"107 - 6191,67","107 - 6191,67"]
[null,108,6245.37,{"$f":"RemComplementar(C112)","v":0},null,"108 - 6245,37","108 - 6245,37"]
[null,109,6299.05,{"$f":"RemComplementar(C113)","v":0},null,"109 - 6299,05","109 - 6299,05"]
[null,110,6352.73,{"$f":"RemComplementar(C114)","v":0},null,"110 - 6352,73","110 - 6352,73"]
[null,111,6406.41,{"$f":"RemComplementar(C115)","v":0},null,"111 - 6406,41","111 - 6406,41"]
[null,112,6460.1,{"$f":"RemComplementar(C116)","v":0},null,"112 - 6460,1","112 - 6460,1"]
[null,113,6513.79,{"$f":"RemComplementar(C117)","v":0},null,"113 - 6513,79","113 - 6513,79"]
[null,114,6567.47,{"$f":"RemComplementar(C118)","v":0},null,"114 - 6567,47","114 - 6567,47"]
[null,115,6621.16,{"$f":"RemComplementar(C119)","v":0},null,"115 - 6621,16","115 - 6621,16"]

{"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 Pós-Doutoramento ",null,1741,null,{"$f":"B5","v":"Bolsa de Pós-Doutoramento "}]
[null,"Bolsa de Doutoramento",null,1199.6400000000001,null,{"$f":"B6","v":"Bolsa de Doutoramento"}]
[null,"Bolsa de Investigação","Doutor",1741,null,{"$f":"B7&\" - \"&C7","v":"Bolsa de Investigação - Doutor"}]
[null,"Bolsa de Investigação","Mestre",1199.6400000000001,null,{"$f":"B8&\" - \"&C8","v":"Bolsa de Investigação - Mestre"}]
[null,"Bolsa de Investigação","Licenciado",930.98,null,{"$f":"B9&\" - \"&C9","v":"Bolsa de Investigação - Licenciado"}]
[null,"Bolsa de Iniciação Científica",null,541.12,null,{"$f":"B10","v":"Bolsa de Iniciação Científica"}]

{"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",798]
[]
[null,"Tipo de Estágio","Bolsa (Em Portugal)"]
[null,"Estagiar L",{"$f":"+$C$4*1.25","v":997.5}]
[null,"Estagiar T",{"$f":"+$C$4*1.05","v":837.90000000000009}]
[null,"Estagiar +",{"$f":"+$C$4","v":798}]

{"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,"Técnico Superior",null,"Sim",null,"Doutor",null,"Bolsa de Pós-Doutoramento ",null,"Estagiar T"]
[null,"Incerto",null,"Assistente Técnico",null,"Não",null,"Mestre",null,"Bolsa de Doutoramento",null,"Estagiar L"]
[null,null,null,null,null,null,null,"Licenciado",null,"Bolsa de Investigação",null,"Estagiar +"]
[null,null,null,null,null,null,null,null,null,"Bolsa de Iniciação Científica"]