{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["PLANO","CRONOGRAMA","Anotações"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":5,"defined_names":40,"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":"PLANO","index":0,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,"PROJETO XYZ",null,null,null,null,"DIAS","DATA INICIO","DATA FINAL",null,null,null,null,null,null,null,"CALCULO DE VINCULOS DA LINHA DE  BASE"]
[null,null,null,null,null,null,{"$f":"I2-H2+1","v":44},{"$f":"DT_INICIO","v":"2017-02-11"},{"$f":"MAX(I5:I24)","v":"2017-03-26"}]
[]
[null,"TAR","ATIVIDADE","DIAS","DEPEND","TIPO","AJUSTE","DATA INICIO","DATA FINAL",null,null,null,null,null,null,null,"VIN VZ","VIN TI","VIN II"]
[null,1,"ATIV 01",6,null,null,null,"2017-02-11",{"$f":"IF(H5>0,H5+D5-1,0)","v":"2017-02-16"}]
[null,2,"ATIV 02",12,1,"TI",null,{"$f":"MAX(Q6:S6)","v":"2017-02-17"},"2017-02-28",null,null,null,null,null,null,null,{"$f":"IF(F6=0,$H$5,0)","v":"00:00:00"},{"$f":"IF($F6=\"TI\",VLOOKUP($E6,TABPROCV,8,0)+1+$G6,0)","v":"2017-02-17"},{"$f":"IF($F6=\"II\",VLOOKUP($E6,TABPROCV,7,0)+1+$G6,0)","v":"00:00:00"}]
[null,3,"ATIV 03",10,1,"II",2,"2017-02-14","2017-02-23",null,null,null,null,null,null,null,{"$f":"IF(F7=0,$H$5,0)","v":"00:00:00"},"00:00:00","2017-02-14"]
[null,4,"ATIV 04",4,2,"TI",null,"2017-03-01","2017-03-04",null,null,null,null,null,null,null,{"$f":"IF(F8=0,$H$5,0)","v":"00:00:00"},"2017-03-01","00:00:00"]
[null,5,"ATIV 05",4,3,"II",4,"2017-02-19","2017-02-22",null,null,null,null,null,null,null,{"$f":"IF(F9=0,$H$5,0)","v":"00:00:00"},"00:00:00","2017-02-19"]
[null,6,"ATIV 06",20,4,"TI",-3,"2017-03-02","2017-03-21",null,null,null,null,null,null,null,{"$f":"IF(F10=0,$H$5,0)","v":"00:00:00"},"2017-03-02","00:00:00"]
[null,7,"ATIV 07",5,6,"TI",null,"2017-03-22","2017-03-26",null,null,null,null,null,null,null,{"$f":"IF(F11=0,$H$5,0)","v":"00:00:00"},"2017-03-22","00:00:00"]
[null,8,null,null,null,null,null,{"$f":"MAX(Q12:S12)","v":"2017-02-11"},{"$f":"IF(H12>0,H12+D12-1,0)","v":"2017-02-10"},null,null,null,null,null,null,null,{"$f":"IF(F12=0,$H$5,0)","v":"2017-02-11"},"00:00:00","00:00:00"]
[null,9,null,null,null,null,0,"2017-02-11","2017-02-10",null,null,null,null,null,null,null,{"$f":"IF(F13=0,$H$5,0)","v":"2017-02-11"},"00:00:00","00:00:00"]
[null,10,null,null,null,null,0,"2017-02-11","2017-02-10",null,null,null,null,null,null,null,{"$f":"IF(F14=0,$H$5,0)","v":"2017-02-11"},"00:00:00","00:00:00"]
[null,11,null,null,null,null,0,"2017-02-11","2017-02-10",null,null,null,null,null,null,null,{"$f":"IF(F15=0,$H$5,0)","v":"2017-02-11"},"00:00:00","00:00:00"]
[null,12,null,null,null,null,0,"2017-02-11","2017-02-10",null,null,null,null,null,null,null,{"$f":"IF(F16=0,$H$5,0)","v":"2017-02-11"},"00:00:00","00:00:00"]
[null,13,null,null,null,null,0,"2017-02-11","2017-02-10",null,null,null,null,null,null,null,{"$f":"IF(F17=0,$H$5,0)","v":"2017-02-11"},"00:00:00","00:00:00"]
[null,14,null,null,null,null,0,"2017-02-11","2017-02-10",null,null,null,null,null,null,null,{"$f":"IF(F18=0,$H$5,0)","v":"2017-02-11"},"00:00:00","00:00:00"]
[null,15,null,null,null,null,0,"2017-02-11","2017-02-10",null,null,null,null,null,null,null,{"$f":"IF(F19=0,$H$5,0)","v":"2017-02-11"},"00:00:00","00:00:00"]
[null,16,null,null,null,null,0,"2017-02-11","2017-02-10",null,null,null,null,null,null,null,{"$f":"IF(F20=0,$H$5,0)","v":"2017-02-11"},"00:00:00","00:00:00"]
[null,17,null,null,null,null,0,"2017-02-11","2017-02-10",null,null,null,null,null,null,null,{"$f":"IF(F21=0,$H$5,0)","v":"2017-02-11"},"00:00:00","00:00:00"]
[null,18,null,null,null,null,0,{"$f":"MAX(Q22:S22)","v":"2017-02-11"},{"$f":"IF(H22>0,H22+D22-1,0)","v":"2017-02-10"},null,null,null,null,null,null,null,{"$f":"IF(F22=0,$H$5,0)","v":"2017-02-11"},"00:00:00","00:00:00"]
[null,19,null,null,null,null,0,"2017-02-11","2017-02-10",null,null,null,null,null,null,null,{"$f":"IF(F23=0,$H$5,0)","v":"2017-02-11"},"00:00:00","00:00:00"]
[null,20,null,null,null,null,0,"2017-02-11","2017-02-10",null,null,null,null,null,null,null,{"$f":"IF(F24=0,$H$5,0)","v":"2017-02-11"},"00:00:00","00:00:00"]

{"sheet":"CRONOGRAMA","index":1,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"redutor"]
[null,null,null,{"$f":"TODAY()-30","v":42747}]
[]
[null,"NUM","TAREFA","INI","DIAS"]
[null,{"$f":"PLANO!B5","v":1},{"$f":"PLANO!C5","v":"ATIV 01"},{"$f":"PLANO!H5","v":42777},{"$f":"PLANO!D5","v":6}]
[null,{"$f":"PLANO!B6","v":2},{"$f":"PLANO!C6","v":"ATIV 02"},{"$f":"PLANO!H6","v":42783},{"$f":"PLANO!D6","v":12}]
[null,{"$f":"PLANO!B7","v":3},{"$f":"PLANO!C7","v":"ATIV 03"},{"$f":"PLANO!H7","v":42780},{"$f":"PLANO!D7","v":10}]
[null,{"$f":"PLANO!B8","v":4},{"$f":"PLANO!C8","v":"ATIV 04"},{"$f":"PLANO!H8","v":42795},{"$f":"PLANO!D8","v":4}]
[null,{"$f":"PLANO!B9","v":5},{"$f":"PLANO!C9","v":"ATIV 05"},{"$f":"PLANO!H9","v":42785},{"$f":"PLANO!D9","v":4}]
[null,{"$f":"PLANO!B10","v":6},{"$f":"PLANO!C10","v":"ATIV 06"},{"$f":"PLANO!H10","v":42796},{"$f":"PLANO!D10","v":20}]
[null,{"$f":"PLANO!B11","v":7},{"$f":"PLANO!C11","v":"ATIV 07"},{"$f":"PLANO!H11","v":42816},{"$f":"PLANO!D11","v":5}]
[null,{"$f":"PLANO!B12","v":8},{"$f":"PLANO!C12","v":0},{"$f":"PLANO!H12","v":42777},{"$f":"PLANO!D12","v":0}]
[null,{"$f":"PLANO!B13","v":9},{"$f":"PLANO!C13","v":0},{"$f":"PLANO!H13","v":42777},{"$f":"PLANO!D13","v":0}]
[null,{"$f":"PLANO!B14","v":10},{"$f":"PLANO!C14","v":0},{"$f":"PLANO!H14","v":42777},{"$f":"PLANO!D14","v":0}]
[null,{"$f":"PLANO!B15","v":11},{"$f":"PLANO!C15","v":0},{"$f":"PLANO!H15","v":42777},{"$f":"PLANO!D15","v":0}]
[null,{"$f":"PLANO!B16","v":12},{"$f":"PLANO!C16","v":0},{"$f":"PLANO!H16","v":42777},{"$f":"PLANO!D16","v":0}]
[null,{"$f":"PLANO!B17","v":13},{"$f":"PLANO!C17","v":0},{"$f":"PLANO!H17","v":42777},{"$f":"PLANO!D17","v":0}]
[null,{"$f":"PLANO!B18","v":14},{"$f":"PLANO!C18","v":0},{"$f":"PLANO!H18","v":42777},{"$f":"PLANO!D18","v":0}]
[null,{"$f":"PLANO!B19","v":15},{"$f":"PLANO!C19","v":0},{"$f":"PLANO!H19","v":42777},{"$f":"PLANO!D19","v":0}]
[null,{"$f":"PLANO!B20","v":16},{"$f":"PLANO!C20","v":0},{"$f":"PLANO!H20","v":42777},{"$f":"PLANO!D20","v":0}]
[null,{"$f":"PLANO!B21","v":17},{"$f":"PLANO!C21","v":0},{"$f":"PLANO!H21","v":42777},{"$f":"PLANO!D21","v":0}]
[]
[null,null,"INICIO ESCALA",{"$f":"MIN(D5:D21)-5","v":42772}]
[null,null,"FINAL ESCALA",{"$f":"MAX(D5:D21)+5","v":42821}]

{"sheet":"Anotações","index":2,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"CONSTRUINDO A TABELA DE DATAS  DO CRONOGRAMA "]
[null,null,"Data de Inicio"]
[null,null,"tipos de Vinculos - TI e II ( Termino Inicio) (InicioInicio) ( msProject)"]
[null,null,"Fator de ajuste ( antecipar / retardar)"]
[null,null,"Calculo automatico de todas as datas "]
[]
[]
[]
[null,null,"CONSTRUINDO O GRÁFICO   DO CRONOGRAMA "]
[null,null,"Grafico de barras horizontais"]
[null,null,"empilhando data de inicio e duração das atividades"]
[null,null,"ocultando elementos do gráfico"]
[null,null,"Ajuste de minimo e maximo da escala"]
[null,null,"Invertendo classificação serial das tarefas"]
[null,null,"ocultar linhas vazias"]
[]
[null,null,"OTIMIZAÇÃO E AUTOMAÇÃO"]
[null,null,"Macro para ocultar linhas vazias"]
[null,null,"Macro de ajuste automatico das escalas do grafico"]