{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Aging Report","Invoices"],"not_rendered":{"defined_names":4,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Aging Report","index":0,"n_rows":17,"n_cols":8,"rows_kept":17}
[]
[null,"INVOICE AGING REPORT"]
[]
[null,"TODAY",{"$f":"TODAY()","v":"2013-02-26"}]
[null,"VENDOR","(All)"]
[null,"PAID","No"]
[]
[null,"INVOICE TABLE",null,null," "]
[null,"INVOICE #","INVOICE DATE","DUE DATE","1 - 30 Days","61 - 90 Days","31 - 60 Days","GRAND TOTAL"]
[null,"AF0065","2013-01-16","2013-01-16",null,null,{"v":1500,"d":"1,500.00"},{"v":1500,"d":"1,500.00"}]
[null,"AF5006","2012-12-10","2012-12-09",null,206.48,null,206.48]
[null,"AF5089","2013-01-21","2013-02-02",{"v":9735.95,"d":"9,735.95"},null,null,{"v":9735.95,"d":"9,735.95"}]
[null,"CB2154","2013-01-25","2013-02-02",{"v":60,"d":"60.00"},null,null,{"v":60,"d":"60.00"}]
[null,"CB2995","2013-01-21","2013-02-02",{"v":1520,"d":"1,520.00"},null,null,{"v":1520,"d":"1,520.00"}]
[null,"CT0029","2013-01-18","2013-01-18",null,null,{"v":1456.23,"d":"1,456.23"},{"v":1456.23,"d":"1,456.23"}]
[null,"LW4001","2012-12-13","2012-12-13",null,788.06,null,788.06]
[null,"GRAND TOTAL",null,null,{"v":11315.95,"d":"11,315.95"},994.54,{"v":2956.23,"d":"2,956.23"},{"v":15266.72,"d":"15,266.72"}]

{"sheet":"Invoices","index":1,"n_rows":13,"n_cols":9,"rows_kept":13}
[]
[null,"INVOICES"]
[]
[null,"INVOICE DATE","INVOICE #","VENDOR","TOTAL DUE","DUE DATE","PAID","DAYS","PERIOD"]
[null,"2012-12-10","AF5006","AFF1",{"v":206.48,"d":"$206.48"},"2012-12-09","No",{"$f":"ReportDate-F5","v":79},{"$f":"REPT(\"1 - 30 Days\",Invoices[[#This Row],[DAYS]]<31)   &   REPT(\"31 - 60 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],31,60))   &   REPT(\"61 - 90 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],61,90))   &   REPT(\"91 - 120 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],91,120))   &   REPT(\"Over 120 Days\",Invoices[[#This Row],[DAYS]]>120)","v":"61 - 90 Days"}]
[null,"2012-12-13","LW4001","LWM1",{"v":788.06,"d":"$788.06"},"2012-12-13","No",75,{"$f":"REPT(\"1 - 30 Days\",Invoices[[#This Row],[DAYS]]<31)   &   REPT(\"31 - 60 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],31,60))   &   REPT(\"61 - 90 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],61,90))   &   REPT(\"91 - 120 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],91,120))   &   REPT(\"Over 120 Days\",Invoices[[#This Row],[DAYS]]>120)","v":"61 - 90 Days"}]
[null,"2013-01-13","LW4002","LWM1",{"v":15,"d":"$15.00"},"2013-01-13","Yes",44,{"$f":"REPT(\"1 - 30 Days\",Invoices[[#This Row],[DAYS]]<31)   &   REPT(\"31 - 60 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],31,60))   &   REPT(\"61 - 90 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],61,90))   &   REPT(\"91 - 120 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],91,120))   &   REPT(\"Over 120 Days\",Invoices[[#This Row],[DAYS]]>120)","v":"31 - 60 Days"}]
[null,"2013-01-15","HL0015","HLS1",{"v":150,"d":"$150.00"},"2013-02-04","Yes",22,{"$f":"REPT(\"1 - 30 Days\",Invoices[[#This Row],[DAYS]]<31)   &   REPT(\"31 - 60 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],31,60))   &   REPT(\"61 - 90 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],61,90))   &   REPT(\"91 - 120 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],91,120))   &   REPT(\"Over 120 Days\",Invoices[[#This Row],[DAYS]]>120)","v":"1 - 30 Days"}]
[null,"2013-01-16","AF0065","AFS1",{"v":1500,"d":"$1,500.00"},"2013-01-16","No",41,{"$f":"REPT(\"1 - 30 Days\",Invoices[[#This Row],[DAYS]]<31)   &   REPT(\"31 - 60 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],31,60))   &   REPT(\"61 - 90 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],61,90))   &   REPT(\"91 - 120 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],91,120))   &   REPT(\"Over 120 Days\",Invoices[[#This Row],[DAYS]]>120)","v":"31 - 60 Days"}]
[null,"2013-01-18","CT0029","CTB1",{"v":1456.23,"d":"$1,456.23"},"2013-01-18","No",39,{"$f":"REPT(\"1 - 30 Days\",Invoices[[#This Row],[DAYS]]<31)   &   REPT(\"31 - 60 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],31,60))   &   REPT(\"61 - 90 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],61,90))   &   REPT(\"91 - 120 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],91,120))   &   REPT(\"Over 120 Days\",Invoices[[#This Row],[DAYS]]>120)","v":"31 - 60 Days"}]
[null,"2013-01-21","AF5089","AFF1",{"v":9735.95,"d":"$9,735.95"},"2013-02-02","No",24,{"$f":"REPT(\"1 - 30 Days\",Invoices[[#This Row],[DAYS]]<31)   &   REPT(\"31 - 60 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],31,60))   &   REPT(\"61 - 90 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],61,90))   &   REPT(\"91 - 120 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],91,120))   &   REPT(\"Over 120 Days\",Invoices[[#This Row],[DAYS]]>120)","v":"1 - 30 Days"}]
[null,"2013-01-21","CB2995","CBA2",{"v":1520,"d":"$1,520.00"},"2013-02-02","No",24,{"$f":"REPT(\"1 - 30 Days\",Invoices[[#This Row],[DAYS]]<31)   &   REPT(\"31 - 60 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],31,60))   &   REPT(\"61 - 90 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],61,90))   &   REPT(\"91 - 120 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],91,120))   &   REPT(\"Over 120 Days\",Invoices[[#This Row],[DAYS]]>120)","v":"1 - 30 Days"}]
[null,"2013-01-25","CB2154","CBA2",{"v":60,"d":"$60.00"},"2013-02-02","No",24,{"$f":"REPT(\"1 - 30 Days\",Invoices[[#This Row],[DAYS]]<31)   &   REPT(\"31 - 60 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],31,60))   &   REPT(\"61 - 90 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],61,90))   &   REPT(\"91 - 120 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],91,120))   &   REPT(\"Over 120 Days\",Invoices[[#This Row],[DAYS]]>120)","v":"1 - 30 Days"}]