{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Tareas 2016","Proyectos 2016","Gráfico Gant estimación días","Gráfico días reales","CheckList"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":3,"pivot_tables":2},"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":"Tareas 2016","index":0,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[12,0,12,7],[0,0,0,7]]}
["IGNEOTRACK V1.0"]
[]
[null,null,null,null,null,null,null,null,null,null,"TABLA TIPOS TAREA"]
[null,null,null,null,null,null,null,null,null,null,"Tipos Tarea"]
[null,null,null,null,null,null,null,null,null,null,"Administración"]
[null,null,null,null,null,null,null,null,null,null,"Mantenimiento"]
[null,null,null,null,null,null,null,null,null,null,"Programación"]
[null,null,null,null,null,null,null,null,null,null,"Diseño"]
[null,null,null,null,null,null,null,null,null,null,"Comercial"]
[]
[]
[]
["DESGLOSE DE TAREAS:"]
["Fecha","Cliente","Proyecto","Nombre Tarea","Tipo Tarea","Horas Reales","Horas Facturables","Observaciones"]
["2016-09-09",{"$f":"IFERROR(INDEX(ResProyectos[[Cliente]:[Proyecto]],MATCH(Tareas[[#This Row],[Proyecto]],ResProyectos[Proyecto],0),1),\"--\")","v":"Cliente 1"},"Proyecto #1","Tarea #1","Diseño","00:15:00","00:15:00"]
["2016-10-08",{"$f":"IFERROR(INDEX(ResProyectos[[Cliente]:[Proyecto]],MATCH(Tareas[[#This Row],[Proyecto]],ResProyectos[Proyecto],0),1),\"--\")","v":"Cliente 1"},"Proyecto #1","Tarea #2","Programación","01:00:00","01:00:00"]
["2016-10-08",{"$f":"IFERROR(INDEX(ResProyectos[[Cliente]:[Proyecto]],MATCH(Tareas[[#This Row],[Proyecto]],ResProyectos[Proyecto],0),1),\"--\")","v":"Cliente 1"},"Proyecto #1","Tarea #3","Comercial","00:45:00","00:00:00"]
["2016-10-08",{"$f":"IFERROR(INDEX(ResProyectos[[Cliente]:[Proyecto]],MATCH(Tareas[[#This Row],[Proyecto]],ResProyectos[Proyecto],0),1),\"--\")","v":"Cliente 1"},"Proyecto #1","Tarea #4","Administración","00:03:00","00:00:00"]
[{"$f":"SUBTOTAL(103,Tareas[Fecha])","v":4},null,null,null,null,{"$f":"SUBTOTAL(109,Tareas[Horas Reales])","v":8.5416666666666669E-2},{"$f":"SUBTOTAL(109,Tareas[Horas Facturables])","v":5.2083333333333329E-2}]

{"sheet":"Proyectos 2016","index":1,"n_rows":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,9],[12,0,12,9]]}
["IGNEOTRACK V1.0",null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLA CLIENTES:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cliente"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cliente 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cliente 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cliente 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cliente 4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cliente 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cliente 6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cliente 7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cliente 8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cliente 9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cliente 10"]
["RESUMEN PROYECTOS:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Cliente 11"]
["Cliente","Proyecto","Horas Reales Totales","Horas Totales Facturables","Rendimiento Horas","Fecha Inicio Proyecto","Fecha Estimada Fin Proyecto","Fecha Real Fin Proyecto","Finalizado","Facturado",null,null,null,null,"Cliente 12"]
["Cliente 1","Proyecto #1",{"$f":"IF(SUMIF(Tareas[Proyecto],ResProyectos[[#This Row],[Proyecto]],Tareas[Horas Reales])>=0,SUMIF(Tareas[Proyecto],ResProyectos[[#This Row],[Proyecto]],Tareas[Horas Reales]),\"--\")","v":8.5416666666666669E-2},{"$f":"IF(SUMIF(Tareas[Proyecto],ResProyectos[[#This Row],[Proyecto]],Tareas[Horas Facturables])>=0,SUMIF(Tareas[Proyecto],ResProyectos[[#This Row],[Proyecto]],Tareas[Horas Facturables]),\"--\")","v":5.2083333333333329E-2},{"$f":"IFERROR(IF(ResProyectos[[#This Row],[Horas Reales Totales]]>ResProyectos[[#This Row],[Horas Totales Facturables]],ResProyectos[[#This Row],[Horas Reales Totales]]-ResProyectos[[#This Row],[Horas Totales Facturables]],ResProyectos[[#This Row],[Horas Totales Facturables]]-ResProyectos[[#This Row],[Horas Reales Totales]]),\"--\")","v":"00:48:00"},{"$f":"IFERROR(IF(YEAR(INDEX(Tareas[[Fecha]:[Proyecto]],MATCH(ResProyectos[[#This Row],[Proyecto]],Tareas[Proyecto],0),1))>=2016,INDEX(Tareas[[Fecha]:[Proyecto]],MATCH(ResProyectos[[#This Row],[Proyecto]],Tareas[Proyecto],0),1),\"Cubrir F. Inicio\"),\"--\")","v":"2016-09-09"},"2016-12-31"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(SUMIF(Tareas[Proyecto],ResProyectos[[#This Row],[Proyecto]],Tareas[Horas Reales])>=0,SUMIF(Tareas[Proyecto],ResProyectos[[#This Row],[Proyecto]],Tareas[Horas Reales]),\"--\")","v":0},{"$f":"IF(SUMIF(Tareas[Proyecto],ResProyectos[[#This Row],[Proyecto]],Tareas[Horas Facturables])>=0,SUMIF(Tareas[Proyecto],ResProyectos[[#This Row],[Proyecto]],Tareas[Horas Facturables]),\"--\")","v":0},{"$f":"IFERROR(IF(ResProyectos[[#This Row],[Horas Reales Totales]]>ResProyectos[[#This Row],[Horas Totales Facturables]],ResProyectos[[#This Row],[Horas Reales Totales]]-ResProyectos[[#This Row],[Horas Totales Facturables]],ResProyectos[[#This Row],[Horas Totales Facturables]]-ResProyectos[[#This Row],[Horas Reales Totales]]),\"--\")","v":"00:00:00"},{"$f":"IFERROR(IF(YEAR(INDEX(Tareas[[Fecha]:[Proyecto]],MATCH(ResProyectos[[#This Row],[Proyecto]],Tareas[Proyecto],0),1))>=2016,INDEX(Tareas[[Fecha]:[Proyecto]],MATCH(ResProyectos[[#This Row],[Proyecto]],Tareas[Proyecto],0),1),\"Cubrir F. Inicio\"),\"--\")","v":"--"}]
[{"$f":"SUBTOTAL(103,ResProyectos[Cliente])","v":1},{"$f":"SUBTOTAL(103,ResProyectos[Proyecto])","v":1},{"$f":"SUBTOTAL(109,ResProyectos[Horas Reales Totales])","v":8.5416666666666669E-2},{"$f":"SUBTOTAL(109,ResProyectos[Horas Totales Facturables])","v":5.2083333333333329E-2}]

{"sheet":"Gráfico Gant estimación días","index":2,"n_rows":9,"n_cols":241,"rows_kept":9,"cut":false,"hidden":false,"merged":[[6,211,6,240],[6,121,6,151],[6,152,6,179],[6,180,6,210],[0,0,0,2],[2,0,2,2],[6,5,6,28],[6,29,6,59],[6,60,6,89],[6,90,6,120]]}
[{"$f":"'Proyectos 2016'!$A$1","v":"IGNEOTRACK V1.0"}]
[null,null,null,null,null,null,null,null,"    "]
["RESUMEN PROYECTOS:"]
[]
[]
["Fecha Estimada Fin Proyecto","2016-12-31"]
[null,null,null,null,null,"2016-09-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-10-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-11-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-12-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-01-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-02-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-03-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HI8","v":"2017-04-06"}]
["Etiquetas de fila","Mín. de Fecha Inicio Proyecto","Máx. de Fecha Estimada Fin Proyecto",null,"Proyectos / Días","2016-09-07","2016-09-08","2016-09-09","2016-09-10","2016-09-11","2016-09-12","2016-09-13","2016-09-14","2016-09-15","2016-09-16","2016-09-17","2016-09-18","2016-09-19","2016-09-20","2016-09-21","2016-09-22","2016-09-23","2016-09-24","2016-09-25","2016-09-26","2016-09-27","2016-09-28","2016-09-29","2016-09-30","2016-10-01","2016-10-02","2016-10-03","2016-10-04","2016-10-05","2016-10-06","2016-10-07","2016-10-08","2016-10-09","2016-10-10","2016-10-11","2016-10-12","2016-10-13","2016-10-14","2016-10-15","2016-10-16","2016-10-17","2016-10-18","2016-10-19","2016-10-20","2016-10-21","2016-10-22","2016-10-23","2016-10-24","2016-10-25","2016-10-26","2016-10-27","2016-10-28","2016-10-29","2016-10-30","2016-10-31","2016-11-01","2016-11-02","2016-11-03","2016-11-04","2016-11-05","2016-11-06","2016-11-07","2016-11-08","2016-11-09","2016-11-10","2016-11-11","2016-11-12","2016-11-13","2016-11-14","2016-11-15","2016-11-16","2016-11-17","2016-11-18","2016-11-19","2016-11-20","2016-11-21","2016-11-22","2016-11-23","2016-11-24","2016-11-25","2016-11-26","2016-11-27","2016-11-28","2016-11-29","2016-11-30","2016-12-01","2016-12-02","2016-12-03","2016-12-04","2016-12-05","2016-12-06","2016-12-07","2016-12-08","2016-12-09","2016-12-10","2016-12-11","2016-12-12","2016-12-13","2016-12-14","2016-12-15","2016-12-16","2016-12-17","2016-12-18","2016-12-19","2016-12-20","2016-12-21","2016-12-22","2016-12-23","2016-12-24","2016-12-25","2016-12-26","2016-12-27","2016-12-28","2016-12-29","2016-12-30","2016-12-31","2017-01-01","2017-01-02","2017-01-03","2017-01-04","2017-01-05","2017-01-06","2017-01-07","2017-01-08","2017-01-09","2017-01-10","2017-01-11","2017-01-12","2017-01-13","2017-01-14","2017-01-15","2017-01-16","2017-01-17","2017-01-18","2017-01-19","2017-01-20","2017-01-21","2017-01-22","2017-01-23","2017-01-24","2017-01-25","2017-01-26","2017-01-27","2017-01-28","2017-01-29","2017-01-30","2017-01-31","2017-02-01","2017-02-02","2017-02-03","2017-02-04","2017-02-05","2017-02-06","2017-02-07","2017-02-08","2017-02-09","2017-02-10","2017-02-11","2017-02-12","2017-02-13","2017-02-14","2017-02-15","2017-02-16","2017-02-17","2017-02-18","2017-02-19","2017-02-20","2017-02-21","2017-02-22","2017-02-23","2017-02-24","2017-02-25","2017-02-26","2017-02-27","2017-02-28","2017-03-01","2017-03-02","2017-03-03","2017-03-04","2017-03-05","2017-03-06","2017-03-07","2017-03-08","2017-03-09","2017-03-10","2017-03-11","2017-03-12","2017-03-13","2017-03-14","2017-03-15","2017-03-16","2017-03-17","2017-03-18","2017-03-19","2017-03-20","2017-03-21","2017-03-22","2017-03-23","2017-03-24","2017-03-25","2017-03-26","2017-03-27","2017-03-28","2017-03-29","2017-03-30","2017-03-31","2017-04-01","2017-04-02","2017-04-03","2017-04-04","2017-04-05","2017-04-06","2017-04-07","2017-04-08","2017-04-09","2017-04-10","2017-04-11","2017-04-12","2017-04-13","2017-04-14","2017-04-15","2017-04-16","2017-04-17","2017-04-18","2017-04-19","2017-04-20","2017-04-21","2017-04-22","2017-04-23","2017-04-24","2017-04-25","2017-04-26","2017-04-27","2017-04-28","2017-04-29","2017-04-30"]
["Proyecto #1","2016-09-09","2016-12-31",null,{"$f":"A9","v":"Proyecto #1"}]

{"sheet":"Gráfico días reales","index":3,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Etiquetas de fila","Suma de Horas Reales","Suma de Horas Facturables"]
["2016-09-09","00:15:00","00:15:00"]
["2016-10-08","01:48:00","01:00:00"]
["Total general",8.5416666666666669E-2,5.2083333333333329E-2]

{"sheet":"CheckList","index":4,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Tareas Semanales","2016-10-03","2016-10-10","2016-10-17","2016-10-24","2016-10-31","2016-11-07","2016-11-14","2016-11-21","2016-11-28","2016-12-05","2016-12-12"]
[]
[]
[]
[]
[]
[]
[]
["Tareas Mensuales"]
[]
[]
[]
[]
[]
[]
["Tareas Trimestrales"]