{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Facturas","Reporte"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":1},"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":"Facturas","index":0,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Facturas"]
[]
[null,"Fecha de factura","Factura #","Vendedor","Total","Vencimiento","Pago?","Días","Período"]
[null,"2013-12-10","A-120","Rinaudo",206.48,"2014-02-02","No",{"$f":"IF(Invoices[[#This Row],[Pago?]]=\"Si\",\"\",ReportDate-F7)","v":214},{"$f":"IF(Invoices[[#This Row],[Pago?]]=\"Si\",\"\",REPT(\"1 - 30 Days\",Invoices[[#This Row],[Días]]<31)   &   REPT(\"31 - 60 Días\",Invoices[[#This Row],[Días]]=MEDIAN(Invoices[[#This Row],[Días]],31,60))   &   REPT(\"61 - 90 Días\",Invoices[[#This Row],[Días]]=MEDIAN(Invoices[[#This Row],[Días]],61,90))   &   REPT(\"91 - 120 Días\",Invoices[[#This Row],[Días]]=MEDIAN(Invoices[[#This Row],[Días]],91,120))   &   REPT(\"Arriba de 120 días\",Invoices[[#This Row],[Días]]>120))","v":"Arriba de 120 días"}]
[null,"2013-12-13","A-121","López",788.06,"2014-02-02","No",{"$f":"IF(Invoices[[#This Row],[Pago?]]=\"Si\",\"\",ReportDate-F8)","v":214},{"$f":"IF(Invoices[[#This Row],[Pago?]]=\"Si\",\"\",REPT(\"1 - 30 Days\",Invoices[[#This Row],[Días]]<31)   &   REPT(\"31 - 60 Días\",Invoices[[#This Row],[Días]]=MEDIAN(Invoices[[#This Row],[Días]],31,60))   &   REPT(\"61 - 90 Días\",Invoices[[#This Row],[Días]]=MEDIAN(Invoices[[#This Row],[Días]],61,90))   &   REPT(\"91 - 120 Días\",Invoices[[#This Row],[Días]]=MEDIAN(Invoices[[#This Row],[Días]],91,120))   &   REPT(\"Arriba de 120 días\",Invoices[[#This Row],[Días]]>120))","v":"Arriba de 120 días"}]
[null,"2013-01-13","A-172","Monsato",15,"2013-01-13","Si",{"$f":"IF(Invoices[[#This Row],[Pago?]]=\"Si\",\"\",ReportDate-F9)","v":""},{"$f":"IF(Invoices[[#This Row],[Pago?]]=\"Si\",\"\",REPT(\"1 - 30 Days\",Invoices[[#This Row],[Días]]<31)   &   REPT(\"31 - 60 Días\",Invoices[[#This Row],[Días]]=MEDIAN(Invoices[[#This Row],[Días]],31,60))   &   REPT(\"61 - 90 Días\",Invoices[[#This Row],[Días]]=MEDIAN(Invoices[[#This Row],[Días]],61,90))   &   REPT(\"91 - 120 Días\",Invoices[[#This Row],[Días]]=MEDIAN(Invoices[[#This Row],[Días]],91,120))   &   REPT(\"Arriba de 120 días\",Invoices[[#This Row],[Días]]>120))","v":""}]
[null,"2013-01-15","A-312","Evangelia",150,"2013-02-04","Si",{"$f":"IF(Invoices[[#This Row],[Pago?]]=\"Si\",\"\",ReportDate-F10)","v":""},{"$f":"IF(Invoices[[#This Row],[Pago?]]=\"Si\",\"\",REPT(\"1 - 30 Days\",Invoices[[#This Row],[Días]]<31)   &   REPT(\"31 - 60 Días\",Invoices[[#This Row],[Días]]=MEDIAN(Invoices[[#This Row],[Días]],31,60))   &   REPT(\"61 - 90 Días\",Invoices[[#This Row],[Días]]=MEDIAN(Invoices[[#This Row],[Días]],61,90))   &   REPT(\"91 - 120 Días\",Invoices[[#This Row],[Días]]=MEDIAN(Invoices[[#This Row],[Días]],91,120))   &   REPT(\"Arriba de 120 días\",Invoices[[#This Row],[Días]]>120))","v":""}]
[null,"2013-01-16","A-412","Surcore",1500,"2013-01-16","No",{"$f":"IF(Invoices[[#This Row],[Pago?]]=\"Si\",\"\",ReportDate-F11)","v":596},{"$f":"IF(Invoices[[#This Row],[Pago?]]=\"Si\",\"\",REPT(\"1 - 30 Days\",Invoices[[#This Row],[Días]]<31)   &   REPT(\"31 - 60 Días\",Invoices[[#This Row],[Días]]=MEDIAN(Invoices[[#This Row],[Días]],31,60))   &   REPT(\"61 - 90 Días\",Invoices[[#This Row],[Días]]=MEDIAN(Invoices[[#This Row],[Días]],61,90))   &   REPT(\"91 - 120 Días\",Invoices[[#This Row],[Días]]=MEDIAN(Invoices[[#This Row],[Días]],91,120))   &   REPT(\"Arriba de 120 días\",Invoices[[#This Row],[Días]]>120))","v":"Arriba de 120 días"}]
[null,"2013-01-18","A-444","Lima",1456.23,"2013-01-18","No",{"$f":"IF(Invoices[[#This Row],[Pago?]]=\"Si\",\"\",ReportDate-F12)","v":594},{"$f":"IF(Invoices[[#This Row],[Pago?]]=\"Si\",\"\",REPT(\"1 - 30 Days\",Invoices[[#This Row],[Días]]<31)   &   REPT(\"31 - 60 Días\",Invoices[[#This Row],[Días]]=MEDIAN(Invoices[[#This Row],[Días]],31,60))   &   REPT(\"61 - 90 Días\",Invoices[[#This Row],[Días]]=MEDIAN(Invoices[[#This Row],[Días]],61,90))   &   REPT(\"91 - 120 Días\",Invoices[[#This Row],[Días]]=MEDIAN(Invoices[[#This Row],[Días]],91,120))   &   REPT(\"Arriba de 120 días\",Invoices[[#This Row],[Días]]>120))","v":"Arriba de 120 días"}]
[null,"2013-01-21","A-788","Araoz",9735.9500000000007,"2013-02-02","No",{"$f":"IF(Invoices[[#This Row],[Pago?]]=\"Si\",\"\",ReportDate-F13)","v":579},{"$f":"IF(Invoices[[#This Row],[Pago?]]=\"Si\",\"\",REPT(\"1 - 30 Days\",Invoices[[#This Row],[Días]]<31)   &   REPT(\"31 - 60 Días\",Invoices[[#This Row],[Días]]=MEDIAN(Invoices[[#This Row],[Días]],31,60))   &   REPT(\"61 - 90 Días\",Invoices[[#This Row],[Días]]=MEDIAN(Invoices[[#This Row],[Días]],61,90))   &   REPT(\"91 - 120 Días\",Invoices[[#This Row],[Días]]=MEDIAN(Invoices[[#This Row],[Días]],91,120))   &   REPT(\"Arriba de 120 días\",Invoices[[#This Row],[Días]]>120))","v":"Arriba de 120 días"}]
[null,"2013-01-21","A-992","Lareza",1520,"2013-02-02","No",{"$f":"IF(Invoices[[#This Row],[Pago?]]=\"Si\",\"\",ReportDate-F14)","v":579},{"$f":"IF(Invoices[[#This Row],[Pago?]]=\"Si\",\"\",REPT(\"1 - 30 Days\",Invoices[[#This Row],[Días]]<31)   &   REPT(\"31 - 60 Días\",Invoices[[#This Row],[Días]]=MEDIAN(Invoices[[#This Row],[Días]],31,60))   &   REPT(\"61 - 90 Días\",Invoices[[#This Row],[Días]]=MEDIAN(Invoices[[#This Row],[Días]],61,90))   &   REPT(\"91 - 120 Días\",Invoices[[#This Row],[Días]]=MEDIAN(Invoices[[#This Row],[Días]],91,120))   &   REPT(\"Arriba de 120 días\",Invoices[[#This Row],[Días]]>120))","v":"Arriba de 120 días"}]
[null,"2013-01-25","A-995","Minuro",60,"2013-02-02","No",{"$f":"IF(Invoices[[#This Row],[Pago?]]=\"Si\",\"\",ReportDate-F15)","v":579},{"$f":"IF(Invoices[[#This Row],[Pago?]]=\"Si\",\"\",REPT(\"1 - 30 Days\",Invoices[[#This Row],[Días]]<31)   &   REPT(\"31 - 60 Días\",Invoices[[#This Row],[Días]]=MEDIAN(Invoices[[#This Row],[Días]],31,60))   &   REPT(\"61 - 90 Días\",Invoices[[#This Row],[Días]]=MEDIAN(Invoices[[#This Row],[Días]],61,90))   &   REPT(\"91 - 120 Días\",Invoices[[#This Row],[Días]]=MEDIAN(Invoices[[#This Row],[Días]],91,120))   &   REPT(\"Arriba de 120 días\",Invoices[[#This Row],[Días]]>120))","v":"Arriba de 120 días"}]

{"sheet":"Reporte","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Reporte de facturas vencidas"]
[]
[null,"Hoy",{"$f":"TODAY()","v":"2014-09-04"}]
[null,"Vendedor","(Todas)"]
[null,"Pago?","No"]
[null,"Para actualizar la tabla, apriete botón derecho del mouse y elija \"Actualizar\""]
[null,"Suma de Total",null,null,"Período"]
[null,"Factura #","Fecha de factura","Vencimiento","Arriba de 120 días","Total"]
[null,"A-120","2013-12-10","2014-02-02",206.48,206.48]
[null,"A-121","2013-12-13","2014-02-02",788.06,788.06]
[null,"A-412","2013-01-16","2013-01-16",1500,1500]
[null,"A-444","2013-01-18","2013-01-18",1456.23,1456.23]
[null,"A-788","2013-01-21","2013-02-02",9735.9500000000007,9735.9500000000007]
[null,"A-992","2013-01-21","2013-02-02",1520,1520]
[null,"A-995","2013-01-25","2013-02-02",60,60]
[null,"Total",null,null,15266.720000000001,15266.720000000001]