{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Linha do Tempo do Projeto","cálculos"],"not_rendered":{"charts":1,"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"Linha do Tempo do Projeto","index":0,"n_rows":16,"n_cols":6,"rows_kept":16,"merged":[[0,2,0,6],[1,2,1,6]]}
[null,null,"LINHA DO TEMPO DO PROJETO"]
[null,null,"O gráfico mostrando as atividades do projeto com uma linha do tempo rolável está nesta célula."]
[null,null,"INSIRA A DATA DE INÍCIO: ",{"$f":"TODAY()","v":"2019-07-05"}]
[null,"ID","ATIVIDADE","INÍCIO","TÉRMINO","OBSERVAÇÕES"]
[null,{"$f":"ROW(B5)-cálculos!$D$5","v":-7},"Início do projeto",{"$f":"$D$3+3","v":"2019-07-08"}]
[null,{"$f":"ROW(B6)-cálculos!$D$5","v":-6},"Marco 1",{"$f":"D5+10","v":"2019-07-18"},{"$f":"Atividades[[#This Row],[INÍCIO]]+3","v":"2019-07-21"}]
[null,{"$f":"ROW(B7)-cálculos!$D$5","v":-5},"Marco 2",{"$f":"D6+1","v":"2019-07-19"},{"$f":"Atividades[[#This Row],[INÍCIO]]+3","v":"2019-07-22"}]
[null,{"$f":"ROW(B8)-cálculos!$D$5","v":-4},"Marco 3",{"$f":"D7+5","v":"2019-07-24"}]
[null,{"$f":"ROW(B9)-cálculos!$D$5","v":-3},"Marco 4",{"$f":"D8+10","v":"2019-08-03"},{"$f":"Atividades[[#This Row],[INÍCIO]]+2","v":"2019-08-05"}]
[null,{"$f":"ROW(B10)-cálculos!$D$5","v":-2},"Marco 5","2019-08-13",{"$f":"Atividades[[#This Row],[INÍCIO]]+2","v":"2019-08-15"}]
[null,{"$f":"ROW(B11)-cálculos!$D$5","v":-1},"Marco 6",{"$f":"D10+10","v":"2019-08-23"},{"$f":"Atividades[[#This Row],[INÍCIO]]+2","v":"2019-08-25"}]
[null,{"$f":"ROW(B12)-cálculos!$D$5","v":0},"Marco 7","2019-09-02"]
[null,{"$f":"ROW(B13)-cálculos!$D$5","v":1},"Marco 8",{"$f":"D12+10","v":"2019-09-12"},{"$f":"Atividades[[#This Row],[INÍCIO]]+2","v":"2019-09-14"}]
[null,{"$f":"ROW(B14)-cálculos!$D$5","v":2},"Marco 9","2019-09-22",{"$f":"Atividades[[#This Row],[INÍCIO]]+2","v":"2019-09-24"}]
[null,{"$f":"ROW(B15)-cálculos!$D$5","v":3},"Marco 10","2019-10-02",{"$f":"Atividades[[#This Row],[INÍCIO]]+2","v":"2019-10-04"}]
[null,{"$f":"ROW(B16)-cálculos!$D$5","v":4},"Término do projeto",{"$f":"D15+10","v":"2019-10-12"}]

{"sheet":"cálculos","index":1,"n_rows":72,"n_cols":35,"rows_kept":72,"hidden":true}
["*** Esta planilha deve permanecer oculta ***"]
[]
[null,null,"Hoje:",{"$f":"TODAY()","v":"2019-07-05"}]
[{"$nulls":3},5]
[null,null,"Nº de linhas",{"$f":"ROWS(Atividades[])","v":12}]
[{"$nulls":4},{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"Janela de atividades:",{"$f":"SUMPRODUCT( ((Atividades[INÍCIO]>=JanelaDaDataDeInício)+(Atividades[TÉRMINO]>=JanelaDaDataDeInício)>0)*(Atividades[INÍCIO]<=(JanelaDaDataDeInício+JanelaDeDias-1)) )","v":5},{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":3},9,{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":3},{"$f":"D10-MIN(D10,D9)","v":4},{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"$f":"INDEX(Atividades[ID],MATCH(1, ((Atividades[INÍCIO]>=JanelaDaDataDeInício)+(Atividades[TÉRMINO]>=JanelaDaDataDeInício)>0)*(Atividades[INÍCIO]<=(JanelaDaDataDeInício+JanelaDeDias-1)), 0))","v":-7},{"$f":"OFFSET(E15,-$D$11,)","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"$f":"INDEX(Atividades[ID],MATCH(1, (Atividades[ID]>E15)*((Atividades[INÍCIO]>=JanelaDaDataDeInício)+(Atividades[TÉRMINO]>=JanelaDaDataDeInício)>0)*(Atividades[INÍCIO]<=(JanelaDaDataDeInício+JanelaDeDias-1)), 0))","v":-6},{"$error":"#N/A"}]
[{"$nulls":4},{"$f":"INDEX(Atividades[ID],MATCH(1, (Atividades[ID]>E16)*((Atividades[INÍCIO]>=JanelaDaDataDeInício)+(Atividades[TÉRMINO]>=JanelaDaDataDeInício)>0)*(Atividades[INÍCIO]<=(JanelaDaDataDeInício+JanelaDeDias-1)), 0))","v":-5},{"$error":"#N/A"}]
[{"$nulls":4},{"$f":"INDEX(Atividades[ID],MATCH(1, (Atividades[ID]>E17)*((Atividades[INÍCIO]>=JanelaDaDataDeInício)+(Atividades[TÉRMINO]>=JanelaDaDataDeInício)>0)*(Atividades[INÍCIO]<=(JanelaDaDataDeInício+JanelaDeDias-1)), 0))","v":-4},{"$error":"#N/A"}]
[{"$nulls":4},{"$f":"INDEX(Atividades[ID],MATCH(1, (Atividades[ID]>E18)*((Atividades[INÍCIO]>=JanelaDaDataDeInício)+(Atividades[TÉRMINO]>=JanelaDaDataDeInício)>0)*(Atividades[INÍCIO]<=(JanelaDaDataDeInício+JanelaDeDias-1)), 0))","v":-3},-7]
[{"$nulls":4},{"$f":"INDEX(Atividades[ID],MATCH(1, (Atividades[ID]>E19)*((Atividades[INÍCIO]>=JanelaDaDataDeInício)+(Atividades[TÉRMINO]>=JanelaDaDataDeInício)>0)*(Atividades[INÍCIO]<=(JanelaDaDataDeInício+JanelaDeDias-1)), 0))","v":{"$error":"#N/A"}},-6]
[{"$nulls":4},{"$f":"INDEX(Atividades[ID],MATCH(1, (Atividades[ID]>E20)*((Atividades[INÍCIO]>=JanelaDaDataDeInício)+(Atividades[TÉRMINO]>=JanelaDaDataDeInício)>0)*(Atividades[INÍCIO]<=(JanelaDaDataDeInício+JanelaDeDias-1)), 0))","v":{"$error":"#N/A"}},-5]
[{"$nulls":4},{"$f":"INDEX(Atividades[ID],MATCH(1, (Atividades[ID]>E21)*((Atividades[INÍCIO]>=JanelaDaDataDeInício)+(Atividades[TÉRMINO]>=JanelaDaDataDeInício)>0)*(Atividades[INÍCIO]<=(JanelaDaDataDeInício+JanelaDeDias-1)), 0))","v":{"$error":"#N/A"}},-4]
[{"$nulls":4},{"$f":"INDEX(Atividades[ID],MATCH(1, (Atividades[ID]>E22)*((Atividades[INÍCIO]>=JanelaDaDataDeInício)+(Atividades[TÉRMINO]>=JanelaDaDataDeInício)>0)*(Atividades[INÍCIO]<=(JanelaDaDataDeInício+JanelaDeDias-1)), 0))","v":{"$error":"#N/A"}},-3]
[]
[null,null,"Janela de início de cálculos",{"$f":"DataDeInício+JanelaDeDeslocamento","v":"2019-07-05"}]
[null,null,"Deslocamento",0]
[]
[null,null,"Início",{"$f":"'Linha do Tempo do Projeto'!D3","v":"2019-07-05"}]
[null,null,"Janela",30]
[]
["Cargo","Série","ID da atividade","Atividade",{"$f":"JanelaDaDataDeInício","v":"2019-07-05"},{"$f":"E31+1","v":"2019-07-06"},"2019-07-07","2019-07-08","2019-07-09","2019-07-10","2019-07-11","2019-07-12","2019-07-13","2019-07-14","2019-07-15","2019-07-16","2019-07-17","2019-07-18","2019-07-19","2019-07-20","2019-07-21","2019-07-22","2019-07-23","2019-07-24","2019-07-25","2019-07-26","2019-07-27","2019-07-28","2019-07-29","2019-07-30","2019-07-31","2019-08-01","2019-08-02","2019-08-03","2019-08-04"]
[11.3,1,{"$f":"F15","v":{"$error":"#N/A"}},{"$f":"INDEX(Atividades[ATIVIDADE],MATCH($C32,Atividades[ID],0))","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[{"$f":"A32-1","v":10.3},2,{"$error":"#N/A"},{"$f":"INDEX(Atividades[ATIVIDADE],MATCH($C33,Atividades[ID],0))","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[{"$f":"A33-1","v":9.3},3,{"$error":"#N/A"},{"$f":"INDEX(Atividades[ATIVIDADE],MATCH($C34,Atividades[ID],0))","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[8.3,4,{"$error":"#N/A"},{"$f":"INDEX(Atividades[ATIVIDADE],MATCH($C35,Atividades[ID],0))","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[7.300000000000001,5,-7,{"$f":"INDEX(Atividades[ATIVIDADE],MATCH($C36,Atividades[ID],0))","v":"Início do projeto"},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":7.300000000000001},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[6.300000000000001,6,-6,{"$f":"INDEX(Atividades[ATIVIDADE],MATCH($C37,Atividades[ID],0))","v":"Marco 1"},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":6.300000000000001},{"$f":"GridCalc","v":6.300000000000001},{"$f":"GridCalc","v":6.300000000000001},{"$f":"GridCalc","v":6.300000000000001},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[5.300000000000001,7,-5,{"$f":"INDEX(Atividades[ATIVIDADE],MATCH($C38,Atividades[ID],0))","v":"Marco 2"},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":5.300000000000001},{"$f":"GridCalc","v":5.300000000000001},{"$f":"GridCalc","v":5.300000000000001},{"$f":"GridCalc","v":5.300000000000001},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[4.300000000000001,8,-4,{"$f":"INDEX(Atividades[ATIVIDADE],MATCH($C39,Atividades[ID],0))","v":"Marco 3"},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":4.300000000000001},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[3.3000000000000007,9,-3,{"$f":"INDEX(Atividades[ATIVIDADE],MATCH($C40,Atividades[ID],0))","v":"Marco 4"},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":3.3000000000000007},{"$f":"GridCalc","v":3.3000000000000007}]
[]
[]
[{"$nulls":4},{"$f":"E31","v":"2019-07-05"},{"$f":"F31","v":"2019-07-06"},"2019-07-07","2019-07-08","2019-07-09","2019-07-10","2019-07-11","2019-07-12","2019-07-13","2019-07-14","2019-07-15","2019-07-16","2019-07-17","2019-07-18","2019-07-19","2019-07-20","2019-07-21","2019-07-22","2019-07-23","2019-07-24","2019-07-25","2019-07-26","2019-07-27","2019-07-28","2019-07-29","2019-07-30","2019-07-31","2019-08-01","2019-08-02","2019-08-03"]
[null,null,{"$f":"C32","v":{"$error":"#N/A"}},{"$f":"UPPER(INDEX(Atividades[ATIVIDADE],MATCH($C44,Atividades[ID],0)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(F32),E32,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"C33","v":{"$error":"#N/A"}},{"$f":"UPPER(INDEX(Atividades[ATIVIDADE],MATCH($C45,Atividades[ID],0)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(F33),E33,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$error":"#N/A"},{"$f":"UPPER(INDEX(Atividades[ATIVIDADE],MATCH($C46,Atividades[ID],0)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(F34),E34,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$error":"#N/A"},{"$f":"UPPER(INDEX(Atividades[ATIVIDADE],MATCH($C47,Atividades[ID],0)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(F35),E35,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,-7,{"$f":"UPPER(INDEX(Atividades[ATIVIDADE],MATCH($C48,Atividades[ID],0)))","v":"INÍCIO DO PROJETO"},{"$f":"IF(ISERROR(F36),E36,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},7.300000000000001,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,-6,{"$f":"UPPER(INDEX(Atividades[ATIVIDADE],MATCH($C49,Atividades[ID],0)))","v":"MARCO 1"},{"$f":"IF(ISERROR(F37),E37,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},6.300000000000001,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,-5,{"$f":"UPPER(INDEX(Atividades[ATIVIDADE],MATCH($C50,Atividades[ID],0)))","v":"MARCO 2"},{"$f":"IF(ISERROR(F38),E38,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},5.300000000000001,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,-4,{"$f":"UPPER(INDEX(Atividades[ATIVIDADE],MATCH($C51,Atividades[ID],0)))","v":"MARCO 3"},{"$f":"IF(ISERROR(F39),E39,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},4.300000000000001,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,-3,{"$f":"UPPER(INDEX(Atividades[ATIVIDADE],MATCH($C52,Atividades[ID],0)))","v":"MARCO 4"},{"$f":"IF(ISERROR(F40),E40,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[]
[{"$nulls":4},{"$f":"E31","v":"2019-07-05"},{"$f":"F31","v":"2019-07-06"},"2019-07-07","2019-07-08","2019-07-09","2019-07-10","2019-07-11","2019-07-12","2019-07-13","2019-07-14","2019-07-15","2019-07-16","2019-07-17","2019-07-18","2019-07-19","2019-07-20","2019-07-21","2019-07-22","2019-07-23","2019-07-24","2019-07-25","2019-07-26","2019-07-27","2019-07-28","2019-07-29","2019-07-30","2019-07-31","2019-08-01","2019-08-02","2019-08-03"]
[{"$nulls":3},"Dia atual",{"$f":"IF(E55=$D$3,5,NA())","v":5},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[{"$nulls":3},{"$f":"DATE(YEAR(MIN(E55:AH55)),MONTH(MIN(E55:AH55)),1)","v":"2019-07-01"},{"$f":"IF(MEDIAN($D58,E$55,EOMONTH($D58,0))=E$55,0.5,NA())","v":0.5},{"$f":"IF(MEDIAN($D58,F$55,EOMONTH($D58,0))=F$55,0.5,NA())","v":0.5},0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":3},{"$f":"TEXT(D58,\"mmm, aaaa\") & \" - Faixa Superior\"","v":"Jul, Monday - Faixa Superior"},{"$f":"E58+12.5","v":13},{"$f":"F58+12.5","v":13},13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[{"$nulls":3},{"$f":"EOMONTH(D58,0)+1","v":"2019-08-01"},{"$f":"IF(MEDIAN($D61,E$55,EOMONTH($D61,0))=E$55,0.5,NA())","v":{"$error":"#N/A"}},{"$f":"IF(MEDIAN($D61,F$55,EOMONTH($D61,0))=F$55,0.5,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0.5,0.5,0.5]
[{"$nulls":3},{"$f":"TEXT(D61,\"mmm, aaaa\") & \" - Faixa Superior\"","v":"Aug, Thursday - Faixa Superior"},{"$f":"E61+12.5","v":{"$error":"#N/A"}},{"$f":"F61+12.5","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},13,13,13]
[]
[]
[{"$nulls":3},{"$f":"D58+1","v":"2019-07-02"},{"$f":"IF(MEDIAN($D65,E$55)=E$55,0.5,NA())","v":{"$error":"#N/A"}},{"$f":"IF(MEDIAN($D65,F$55)=F$55,0.5,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":3},{"$f":"D61+1","v":"2019-08-02"},{"$f":"IF(MEDIAN($D66,E$55)=E$55,0.5,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0.5,{"$error":"#N/A"}]
[]
[]
[{"$nulls":4},2.3,{"$f":"E69","v":2.3},{"$f":"F69","v":2.3},2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3]
[{"$nulls":3},3,{"$f":"LEFT(UPPER(TEXT(E55,\"ddd\")),$D70)","v":"FRI"},{"$f":"LEFT(UPPER(TEXT(F55,\"ddd\")),$D70)","v":"SAT"},"SUN","MON","TUE","WED","THU","FRI","SAT","SUN","MON","TUE","WED","THU","FRI","SAT","SUN","MON","TUE","WED","THU","FRI","SAT","SUN","MON","TUE","WED","THU","FRI","SAT"]
[{"$nulls":4},1.3,{"$f":"E71","v":1.3},1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3]
[{"$nulls":4},{"$f":"TEXT(E55,\"dd\")","v":"05"},{"$f":"TEXT(F55,\"dd\")","v":"06"},"07","08","09","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","01","02","03"]