{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Cronograma","Tabelas Etapas I, II e III","Plan3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Cronograma","index":0,"n_rows":37,"n_cols":70,"rows_kept":37,"cut":false,"hidden":false,"merged":[[33,16,33,18],[27,19,28,22],[29,19,30,22],[31,19,32,22],[31,12,32,15],[29,12,30,15],[27,12,28,15],[27,16,28,18],[29,16,30,18],[31,16,32,18],[33,12,33,15],[33,19,33,22],[25,19,26,22],[1,1,1,3],[1,4,1,8],[19,1,19,9],[20,1,20,9],[13,1,18,1],[5,1,6,1],[33,4,33,8],[22,12,22,44],[31,4,31,8],[32,4,32,8],[21,1,21,9],[30,4,30,8],[22,4,22,8],[23,4,23,8],[24,4,24,8],[25,4,25,8],[26,4,26,8],[27,4,27,8],[28,4,28,8],[29,4,29,8],[25,12,26,15],[25,16,26,18]]}
[]
[null,"PREÇO TOTAL:",null,null,3333877.7599999998]
[null,null,"assinatura contrato concessão",null,null,null,"ORDEM DE INÍCIO  CONCESSÃO",null,null,null,"início da MODERNIZAÇÃO"]
[null,"mês",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68]
[null,"CONCESSÃO","Fase preliminar - 4m.",null,null,null,"FASE 1 - 4m.",null,null,null,"FASE 2 - 1º marco (8 m. início Fase 2)",{"$nulls":7},"FASE 2 - 2º marco (14 m. inínio Fase2)",{"$nulls":5},"FASE 2 - 3 º marco (20 m. início F2)",{"$nulls":16},"1º BCE",{"$nulls":11},"2º BCE",{"$nulls":11},"3º BCE"]
[null,"V.I.",{"$nulls":8},"Etapa I - 4m.",null,null,null,"Etapa II - 56 m."]
[{"$nulls":10},"Etapa III"]
[null,"mês FASE 1 concessão",{"$nulls":4},1,2,3,4]
[null,"mês FASE 2 concessão ",{"$nulls":8},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[]
[]
[]
[null,"V.I. (mês das Etapas)",{"$nulls":8},1,2,3,4,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56]
[null,"produtos V.I.",{"$nulls":8},"P1, P2, P3","P4 a P10","P11 a P13","P14 a P16","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17","P17"]
[{"$nulls":14},"P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18","P18"]
[{"$nulls":14},"P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19","P19"]
[{"$nulls":18},"P20",{"$nulls":5},"P20",{"$nulls":5},"P20","P20"]
[{"$nulls":14},"P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21","P21"]
[{"$nulls":41},"P22",{"$nulls":11},"P22",{"$nulls":11},"P22"]
[null,"Valor mensal de desembolso das Etapas I e II",{"$nulls":8},{"$f":"SUM('Tabelas Etapas I, II e III'!D3:D5)","v":72496.154999999999},{"$f":"SUM('Tabelas Etapas I, II e III'!D6:D12)","v":169157.69500000001},{"$f":"SUM('Tabelas Etapas I, II e III'!D13:D15)","v":169157.69500000001},{"$f":"SUM('Tabelas Etapas I, II e III'!D16:D18)","v":72496.154999999999},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29,'Tabelas Etapas I, II e III'!$F$28)","v":61023.69999999999},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29,'Tabelas Etapas I, II e III'!$F$28)","v":61023.69999999999},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29,'Tabelas Etapas I, II e III'!$F$28)","v":61023.69999999999},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29,'Tabelas Etapas I, II e III'!$F$28)","v":61023.69999999999},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29,'Tabelas Etapas I, II e III'!$F$30)","v":61023.69999999999},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29,'Tabelas Etapas I, II e III'!$F$30)","v":61023.69999999999},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29,'Tabelas Etapas I, II e III'!$F$30)","v":61023.69999999999},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992},{"$f":"SUM('Tabelas Etapas I, II e III'!$F$25,'Tabelas Etapas I, II e III'!$F$26,'Tabelas Etapas I, II e III'!$F$27,'Tabelas Etapas I, II e III'!$F$29)","v":48818.959999999992}]
[]
[null,"Quantidade de Produtos V.I."]
[null,"P1",1,null,"P16",{"$nulls":4},1]
[null,"P2",1,null,"P17",{"$nulls":4},56]
[null,"P3",1,null,"P18",{"$nulls":4},56]
[null,"P4",1,null,"P19",{"$nulls":4},56,null,null,"Etapa",null,null,null,"Porcentagem sobre total",null,null,"Total das etapas"]
[null,"P5",1,null,"P20 (aceite e recebim.)",{"$nulls":4},4]
[null,"P6",1,null,"P21",{"$nulls":4},56,null,null,"Etapa I",null,null,null,0.14496863256318071,null,null,{"$f":"$Q$28*$E$2","v":483307.69999999995}]
[null,"P7",1,null,"P22 (BCE)",{"$nulls":4},3]
[null,"P8",1,null,"P23 (eventual)",{"$nulls":4},5,null,null,"Etapa II",null,null,null,0.84565036361741097,null,null,{"$f":"$Q$30*$E$2","v":2819294.9399999995}]
[null,"P9",1,null,"P24 (eventual)",{"$nulls":4},5]
[null,"P10",1,null,"P25 (eventual)",{"$nulls":4},2,null,null,"Etapa III",null,null,null,9.3810038194081825E-3,null,null,{"$f":"$Q$32*$E$2","v":31275.119999999995}]
[null,"P11",1]
[null,"P12",1,{"$nulls":9},"TOTAL",null,null,null,{"$f":"SUM(Q28:S33)","v":0.99999999999999989},null,null,{"$f":"SUM(T28:W33)","v":3333877.7599999998}]
[null,"P13",1]
[null,"P14",1]
[null,"P15",1]

{"sheet":"Tabelas Etapas I, II e III","index":1,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":false,"merged":[[22,0,22,5],[0,0,0,4],[40,0,40,6]]}
["Tabela 4 – Percentuais dos produtos da Etapa I"]
["Produto","Mês da entrega","% do produto em relação ao valor total do projeto","Valor total máximo do produto","% do produto em relação à Etapa I"]
["P1",1,{"$f":"(Cronograma!$Q$28/20)","v":7.2484316281590357E-3},{"$f":"C3*Cronograma!$E$2","v":24165.384999999998},{"$f":"D3/$D$19","v":4.9999999999999989E-2}]
["P2",1,{"$f":"(Cronograma!$Q$28/20)","v":7.2484316281590357E-3},{"$f":"C4*Cronograma!$E$2","v":24165.384999999998},{"$f":"D4/$D$19","v":4.9999999999999989E-2}]
["P3",1,{"$f":"(Cronograma!$Q$28/20)","v":7.2484316281590357E-3},{"$f":"C5*Cronograma!$E$2","v":24165.384999999998},4.9999999999999989E-2]
["P4",2,{"$f":"(Cronograma!$Q$28/20)","v":7.2484316281590357E-3},{"$f":"C6*Cronograma!$E$2","v":24165.384999999998},4.9999999999999989E-2]
["P5",2,{"$f":"(Cronograma!$Q$28/20)","v":7.2484316281590357E-3},{"$f":"C7*Cronograma!$E$2","v":24165.384999999998},4.9999999999999989E-2]
["P6",2,{"$f":"(Cronograma!$Q$28/20)","v":7.2484316281590357E-3},{"$f":"C8*Cronograma!$E$2","v":24165.384999999998},4.9999999999999989E-2]
["P7",2,{"$f":"(Cronograma!$Q$28/20)","v":7.2484316281590357E-3},{"$f":"C9*Cronograma!$E$2","v":24165.384999999998},4.9999999999999989E-2]
["P8",2,{"$f":"(Cronograma!$Q$28/20)","v":7.2484316281590357E-3},{"$f":"C10*Cronograma!$E$2","v":24165.384999999998},4.9999999999999989E-2]
["P9",2,{"$f":"(Cronograma!$Q$28/20)","v":7.2484316281590357E-3},{"$f":"C11*Cronograma!$E$2","v":24165.384999999998},4.9999999999999989E-2]
["P10",2,{"$f":"(Cronograma!$Q$28/20)","v":7.2484316281590357E-3},{"$f":"C12*Cronograma!$E$2","v":24165.384999999998},4.9999999999999989E-2]
["P11",3,{"$f":"(Cronograma!$Q$28/20)*3","v":2.1745294884477108E-2},{"$f":"C13*Cronograma!$E$2","v":72496.154999999999},0.14999999999999997]
["P12",3,{"$f":"(Cronograma!$Q$28/20)*3","v":2.1745294884477108E-2},{"$f":"C14*Cronograma!$E$2","v":72496.154999999999},0.14999999999999997]
["P13",3,{"$f":"(Cronograma!$Q$28/20)","v":7.2484316281590357E-3},{"$f":"C15*Cronograma!$E$2","v":24165.384999999998},4.9999999999999989E-2]
["P14",4,{"$f":"(Cronograma!$Q$28/20)","v":7.2484316281590357E-3},{"$f":"C16*Cronograma!$E$2","v":24165.384999999998},4.9999999999999989E-2]
["P15",4,{"$f":"(Cronograma!$Q$28/20)","v":7.2484316281590357E-3},{"$f":"C17*Cronograma!$E$2","v":24165.384999999998},4.9999999999999989E-2]
["P16",4,{"$f":"(Cronograma!$Q$28/20)","v":7.2484316281590357E-3},{"$f":"C18*Cronograma!$E$2","v":24165.384999999998},4.9999999999999989E-2]
["TOTAL",null,{"$f":"SUM(C3:C18)","v":0.14496863256318071},{"$f":"SUM(D3:D18)","v":483307.70000000007},{"$f":"SUM(E3:E18)","v":1}]
[]
[]
[]
["Tabela 5 – Produtos para pagamentos referentes à Etapa II"]
["Produto","Quantidade de entregas","%\nreferente à\nentrega do produto\nem relação ao\nvalor da Etapa II","% do produto em relação ao valor total do projeto","Valor total máximo do produto","Valor unitário máximo do produto"]
["P17",56,{"$f":"1/$B$31","v":4.329004329004329E-3},{"$f":"E25/Cronograma!$E$2","v":0.20500614875573603},{"$f":"B25*Cronograma!$T$30*'Tabelas Etapas I, II e III'!C25","v":683465.44},{"$f":"Cronograma!$T$30*'Tabelas Etapas I, II e III'!C25","v":12204.739999999998}]
["P18",56,{"$f":"1/$B$31","v":4.329004329004329E-3},{"$f":"E26/Cronograma!$E$2","v":0.20500614875573603},{"$f":"B26*Cronograma!$T$30*'Tabelas Etapas I, II e III'!C26","v":683465.44},{"$f":"Cronograma!$T$30*'Tabelas Etapas I, II e III'!C26","v":12204.739999999998}]
["P19",56,4.329004329004329E-3,{"$f":"E27/Cronograma!$E$2","v":0.20500614875573603},{"$f":"B27*Cronograma!$T$30*'Tabelas Etapas I, II e III'!C27","v":683465.44},{"$f":"Cronograma!$T$30*'Tabelas Etapas I, II e III'!C27","v":12204.739999999998}]
["P20",4,4.329004329004329E-3,{"$f":"E28/Cronograma!$E$2","v":1.4643296339695428E-2},{"$f":"B28*Cronograma!$T$30*'Tabelas Etapas I, II e III'!C28","v":48818.959999999992},{"$f":"Cronograma!$T$30*'Tabelas Etapas I, II e III'!C28","v":12204.739999999998}]
["P21",56,4.329004329004329E-3,{"$f":"E29/Cronograma!$E$2","v":0.20500614875573603},{"$f":"B29*Cronograma!$T$30*'Tabelas Etapas I, II e III'!C29","v":683465.44},{"$f":"Cronograma!$T$30*'Tabelas Etapas I, II e III'!C29","v":12204.739999999998}]
["P22",3,4.329004329004329E-3,{"$f":"E30/Cronograma!$E$2","v":1.0982472254771572E-2},{"$f":"B30*Cronograma!$T$30*'Tabelas Etapas I, II e III'!C30","v":36614.219999999994},{"$f":"Cronograma!$T$30*'Tabelas Etapas I, II e III'!C30","v":12204.739999999998}]
["TOTAL",{"$f":"SUM(B25:B30)","v":231},{"$f":"SUMPRODUCT(B25:B30,C25:C30)","v":1},{"$f":"SUM(D25:D30)","v":0.84565036361741108},{"$f":"SUM(E25:E30)","v":2819294.94}]
[]
[]
[]
["Valores Etapa III"]
["Qtde Horas para execução dos produtos","% do produto em relação ao valor total do projeto","Valor Total Etapa III","Valor unitário por hora"]
[{"$f":"SUMPRODUCT(B42:B45,C42:C45)","v":302},{"$f":"Cronograma!Q32","v":9.3810038194081825E-3},{"$f":"B37*Cronograma!E2","v":31275.119999999995},{"$f":"C37/A37","v":103.55999999999999}]
[]
[]
[]
["Tabela 6 – Produtos para pagamentos referentes à Etapa III"]
["Produto","Quantidade do produto a ser entregue","Quantidade de Horas do produto a ser entregue","Valor unitário por hora","%\nreferente à\nentrega do produto\nem relação ao\nvalor da Etapa III","% do produto em relação ao valor total do projeto","Valor total máximo do produto"]
["P23",5,32,{"$f":"$D$37","v":103.55999999999999},{"$f":"(C43*D43)/$C$37","v":0.10596026490066225},{"$f":"G43/Cronograma!$E$2","v":4.9700682486930776E-3},{"$f":"B43*E43*$C$37","v":16569.599999999999}]
["P24",5,18,{"$f":"$D$37","v":103.55999999999999},{"$f":"(C44*D44)/$C$37","v":5.9602649006622516E-2},{"$f":"G44/Cronograma!$E$2","v":2.7956633898898555E-3},{"$f":"B44*E44*$C$37","v":9320.3999999999978}]
["P25",2,26,103.55999999999999,8.6092715231788075E-2,{"$f":"G45/Cronograma!$E$2","v":1.61527218082525E-3},5385.119999999999]
["TOTAL",null,null,null,{"$f":"SUMPRODUCT(B43:B45,E43:E45)","v":1},{"$f":"SUM(F43:F45)","v":9.3810038194081825E-3},{"$f":"SUM(G43:G45)","v":31275.119999999995}]

{"sheet":"Plan3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}