{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Plantilla","El Tío Tech"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":"Plantilla","index":0,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"TODAY()","v":"2020-06-28"},null,{"$f":"COUNTIF(Tabla1[días],\"<0\")","v":8},{"$f":"COUNTIF(Tabla1[días],\"=0\")","v":0},{"$f":"COUNTIFS(Tabla1[días],\">0\",Tabla1[días],\"<4\")","v":0},{"$f":"COUNTIF(Tabla1[días],\">3\")","v":0}]
[null,"N° Factura","Cliente","Fecha Emisión","Días a vencer","Fecha Vencimiento","Alertas","días"]
[null,"Fact_001","Molinsa Corp SAC.","2019-10-10",8,{"$f":"IF(Tabla1[[#This Row],[Días a vencer]]=\"\",\"\",D4+E4)","v":"2019-10-18"},{"$f":"IF(E4=\"\",\"VACIO\",IF(H4<0,\"Vencido hace \"&H4*-1&\" días\",IF(H4=0,\"Vence hoy\",IF(H4<4,\"Tiene \"&H4&\" días\",\"Faltan \"&H4&\" días\"))))","v":"Vencido hace 254 días"},{"$f":"F4-$B$2","v":-254}]
[null,"Fact_002","Cajamarca E.I.R.L","2019-10-12",5,{"$f":"IF(Tabla1[[#This Row],[Días a vencer]]=\"\",\"\",D5+E5)","v":"2019-10-17"},"Vencido hace 255 días",{"$f":"F5-$B$2","v":-255}]
[null,"Fact_003","Grupo MTM SAC.","2019-10-10",7,{"$f":"IF(Tabla1[[#This Row],[Días a vencer]]=\"\",\"\",D6+E6)","v":"2019-10-17"},"Vencido hace 255 días",-255]
[null,"Fact_004","Imnobiliaria ABF","2019-10-08",1,{"$f":"IF(Tabla1[[#This Row],[Días a vencer]]=\"\",\"\",D7+E7)","v":"2019-10-09"},"Vencido hace 263 días",-263]
[null,"Fact_005","Constructora PERL SAC.","2019-10-09",20,{"$f":"IF(Tabla1[[#This Row],[Días a vencer]]=\"\",\"\",D8+E8)","v":"2019-10-29"},"Vencido hace 243 días",-243]
[null,"Fact_006","Emanuel SAC.","2019-10-07",20,{"$f":"IF(Tabla1[[#This Row],[Días a vencer]]=\"\",\"\",D9+E9)","v":"2019-10-27"},"Vencido hace 245 días",-245]
[null,"Fact_007","Corporación Miller","2019-10-08",30,{"$f":"IF(Tabla1[[#This Row],[Días a vencer]]=\"\",\"\",D10+E10)","v":"2019-11-07"},"Vencido hace 234 días",-234]
[null,"Fact_008","Seguros CDD SAC.","2019-10-01",10,{"$f":"IF(Tabla1[[#This Row],[Días a vencer]]=\"\",\"\",D11+E11)","v":"2019-10-11"},"Vencido hace 261 días",-261]

{"sheet":"El Tío Tech","index":1,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,1,12,5]]}
[null,"Crear alertas de vencimiento en Excel"]
["Tutoriales de El Tío Tech"]
[]
[]
[]
[null,"Aprende a crear gráficos profesionales en:","https://eltiotech.com/diagramas-y-graficos-en-excel/"]
[null,"Suscríbete a El Tío Tech en YouTube:","https://www.youtube.com/eltiotech"]
[null,"Visita la web para ver más tutoriales:","https://bit.ly/2BX3RdM"]
[null,"🔴 Cursos gratis de Excel:","https://eltiotech.com/cursos-gratis-de-excel-basico-intermedio-avanzado/"]
[]
[]
[null,"© Todos el contenido de este curso está sujeto a derechos de propiedad por las leyes de Derechos de Autor y demás Leyes relativas Internacionales por Miguel Vela - \"El Tío Tech\"."]