{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Orientações","Lista de Pendências","Resumo","Parâmetros"],"not_rendered":{"charts":3,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":3},"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":"Orientações","index":0,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Passo","Descrição"]
[null,1,"Na aba \"Parâmetros\", identifique as situações possíveis para suas atividades e as pessoas da sua equipe.\nEstas informações podem ser modificadas posteriormente conforme sua necessidade."]
[null,2,"Na aba \"Lista de Pendências\", identifique as atividades que você quer controlar.\nCada coluna tem um comentário para ajudá-lo a entender para que serve cada informação."]
[null,3,"Na aba \"Resumo\", clique no botão \"Atualizar Gráficos\" para obter um resumo dos dados que estão sendo monitorados."]
[null,4,"Se necessário, você tem um layout bem agradável para impressão das informações e distribuição para sua equipe."]

{"sheet":"Lista de Pendências","index":1,"n_rows":200,"n_cols":12,"rows_kept":200,"cut":false,"hidden":false,"merged":[]}
["Pendência","Observações","Responsável","Situação","Início Estimado","Término Estimado","Trabalho Previsto (horas)","% Completo","Trabalho Real","Término Real","Prazo","Esforço"]
["Atividade 1","Detalhes sobre a entrega e o andamento da mesma","João","Concluída","2015-01-01","2015-01-31",40,1,10,"2015-01-20",{"$f":"IF(A2=\"\",-1,IF(OR(E2=\"\",F2=\"\",E2>F2),0,IF(TODAY()<=E2,2,IF(J2=\"\",IF((TODAY()-E2)/IF((F2-E2)=0,(TODAY()-E2),(F2-E2))>H2,1,2),IF(J2>F2,1,2)))))","v":2},{"$f":"IF(A2=\"\",-1,IF(G2<=0,0,(IF(J2=\"\",IF(I2/G2>H2,1,2),IF(I2>G2,1,2)))))","v":2}]
["Atividade 2","Detalhes sobre a entrega e o andamento da mesma","Maria","Em Andamento","2015-02-01","2015-02-10",10,0.6,50,null,1,1]
["Atividade N","Detalhes sobre a entrega e o andamento da mesma","Pedro","Aguardando","2015-02-11","2015-02-20",60,null,null,null,1,2]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A10=\"\",-1,IF(OR(E10=\"\",F10=\"\",E10>F10),0,IF(TODAY()<=E10,2,IF(J10=\"\",IF((TODAY()-E10)/IF((F10-E10)=0,(TODAY()-E10),(F10-E10))>H10,1,2),IF(J10>F10,1,2)))))","v":-1},-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A22=\"\",-1,IF(OR(E22=\"\",F22=\"\",E22>F22),0,IF(TODAY()<=E22,2,IF(J22=\"\",IF((TODAY()-E22)/IF((F22-E22)=0,(TODAY()-E22),(F22-E22))>H22,1,2),IF(J22>F22,1,2)))))","v":-1},-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,{"$f":"IF(A34=\"\",-1,IF(G34<=0,0,(IF(J34=\"\",IF(I34/G34>H34,1,2),IF(I34>G34,1,2)))))","v":-1}]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,{"$f":"IF(A66=\"\",-1,IF(G66<=0,0,(IF(J66=\"\",IF(I66/G66>H66,1,2),IF(I66>G66,1,2)))))","v":-1}]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A86=\"\",-1,IF(OR(E86=\"\",F86=\"\",E86>F86),0,IF(TODAY()<=E86,2,IF(J86=\"\",IF((TODAY()-E86)/IF((F86-E86)=0,(TODAY()-E86),(F86-E86))>H86,1,2),IF(J86>F86,1,2)))))","v":-1},-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,{"$f":"IF(A98=\"\",-1,IF(G98<=0,0,(IF(J98=\"\",IF(I98/G98>H98,1,2),IF(I98>G98,1,2)))))","v":-1}]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,{"$f":"IF(A130=\"\",-1,IF(G130<=0,0,(IF(J130=\"\",IF(I130/G130>H130,1,2),IF(I130>G130,1,2)))))","v":-1}]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A150=\"\",-1,IF(OR(E150=\"\",F150=\"\",E150>F150),0,IF(TODAY()<=E150,2,IF(J150=\"\",IF((TODAY()-E150)/IF((F150-E150)=0,(TODAY()-E150),(F150-E150))>H150,1,2),IF(J150>F150,1,2)))))","v":-1},-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,{"$f":"IF(A162=\"\",-1,IF(G162<=0,0,(IF(J162=\"\",IF(I162/G162>H162,1,2),IF(I162>G162,1,2)))))","v":-1}]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,{"$f":"IF(A194=\"\",-1,IF(G194<=0,0,(IF(J194=\"\",IF(I194/G194>H194,1,2),IF(I194>G194,1,2)))))","v":-1}]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]
[null,null,null,null,null,null,null,null,null,null,-1,-1]

{"sheet":"Resumo","index":2,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Contagem de Pendência",null,null,null,null,"Contagem de Pendência"]
["Prazo","Total",null,null,null,"Esforço","Total"]
["Atrasadas",2,null,null,null,"Acima do Esforço",1]
["Em Dia",1,null,null,null,"Dentro do Esforço",2]
["Total Geral",3,null,null,null,"Total Geral",3]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Contagem de Pendência","Prazo"]
["Responsável","Atrasadas","Em Dia","Total Geral"]
["João",null,1,1]
["Maria",1,null,1]
["Pedro",1,null,1]
["Total Geral",2,1,3]

{"sheet":"Parâmetros","index":3,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Situações das Atividades",null,"Equipe de Trabalho"]
["Proposta",null,"João"]
["Aguardando",null,"Maria"]
["Em Andamento",null,"Pedro"]
["Concluída"]
["Cancelada"]
["Aprovada"]