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

{"sheet":"Aging Report","index":0,"n_rows":15,"n_cols":9,"rows_kept":15}
[null,"INVOICE AGING REPORT",{"$nulls":5},"Invoices"]
[null,"TODAY",{"$f":"TODAY()","v":"2017-05-20"}]
[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","Not Yet Overdue","GRAND TOTAL"]
[null,"AF0065","2017-04-16","2017-01-16",null,null,{"v":1500,"d":"1,500.00"},null,{"v":1500,"d":"1,500.00"}]
[null,"AF5006","2017-03-10","2016-12-09",null,206.48,null,null,206.48]
[null,"AF5089","2017-04-21","2017-02-02",{"v":9735.95,"d":"9,735.95"},{"$nulls":3},{"v":9735.95,"d":"9,735.95"}]
[null,"CB2154","2017-05-20","2017-05-27",{"$nulls":3},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"}]
[null,"CB2995","2017-04-21","2017-02-02",{"v":1520,"d":"1,520.00"},{"$nulls":3},{"v":1520,"d":"1,520.00"}]
[null,"CT0029","2017-04-18","2017-04-18",null,null,{"v":1456.23,"d":"1,456.23"},null,{"v":1456.23,"d":"1,456.23"}]
[null,"LW4001","2017-03-13","2017-03-13",null,788.06,null,null,788.06]
[null,"GRAND TOTAL",null,null,{"v":11255.95,"d":"11,255.95"},994.54,{"v":2956.23,"d":"2,956.23"},{"v":60,"d":"60.00"},{"v":15266.72,"d":"15,266.72"}]

{"sheet":"Invoices","index":1,"n_rows":11,"n_cols":10,"rows_kept":11}
[null,"INVOICES",{"$nulls":7},"Aging Report"]
[null,"INVOICE DATE","INVOICE #","VENDOR","TOTAL DUE","DUE DATE","PAID","PAID DATE","DAYS","PERIOD"]
[null,{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-2,10)","v":"2017-03-10"},"AF5006","AFF1",{"v":206.48,"d":"$206.48"},{"$f":"Invoices[[#This Row],[INVOICE DATE]]-1","v":"2017-03-09"},"No",null,{"$f":"IFERROR(IF(Invoices[[#This Row],[PAID]]=\"Yes\",0,IF(ReportDate-Invoices[[#This Row],[DUE DATE]]=0,-1,ReportDate-Invoices[[#This Row],[DUE DATE]])),\"\")","v":72},{"$f":"REPT(\"Paid\",Invoices[[#This Row],[DAYS]]=0) & REPT(\"Not Yet Overdue\",Invoices[[#This Row],[DAYS]]<0) & REPT(\"1 - 30 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],1,30))   &   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,{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-2,13)","v":"2017-03-13"},"LW4001","LWM1",{"v":788.06,"d":"$788.06"},{"$f":"Invoices[[#This Row],[INVOICE DATE]]","v":"2017-03-13"},"No",null,{"$f":"IFERROR(IF(Invoices[[#This Row],[PAID]]=\"Yes\",0,IF(ReportDate-Invoices[[#This Row],[DUE DATE]]=0,-1,ReportDate-Invoices[[#This Row],[DUE DATE]])),\"\")","v":68},{"$f":"REPT(\"Paid\",Invoices[[#This Row],[DAYS]]=0) & REPT(\"Not Yet Overdue\",Invoices[[#This Row],[DAYS]]<0) & REPT(\"1 - 30 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],1,30))   &   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,{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,13)","v":"2017-04-13"},"LW4002","LWM1",{"v":15,"d":"$15.00"},{"$f":"Invoices[[#This Row],[INVOICE DATE]]","v":"2017-04-13"},"Yes",{"$f":"Invoices[[#This Row],[INVOICE DATE]]","v":"2017-04-13"},{"$f":"IFERROR(IF(Invoices[[#This Row],[PAID]]=\"Yes\",0,IF(ReportDate-Invoices[[#This Row],[DUE DATE]]=0,-1,ReportDate-Invoices[[#This Row],[DUE DATE]])),\"\")","v":0},{"$f":"REPT(\"Paid\",Invoices[[#This Row],[DAYS]]=0) & REPT(\"Not Yet Overdue\",Invoices[[#This Row],[DAYS]]<0) & REPT(\"1 - 30 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],1,30))   &   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":"Paid"}]
[null,{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,15)","v":"2017-04-15"},"HL0015","HLS1",{"v":150,"d":"$150.00"},{"$f":"Invoices[[#This Row],[INVOICE DATE]]+20","v":"2017-05-05"},"Yes",{"$f":"Invoices[[#This Row],[INVOICE DATE]]+18","v":"2017-05-03"},{"$f":"IFERROR(IF(Invoices[[#This Row],[PAID]]=\"Yes\",0,IF(ReportDate-Invoices[[#This Row],[DUE DATE]]=0,-1,ReportDate-Invoices[[#This Row],[DUE DATE]])),\"\")","v":0},{"$f":"REPT(\"Paid\",Invoices[[#This Row],[DAYS]]=0) & REPT(\"Not Yet Overdue\",Invoices[[#This Row],[DAYS]]<0) & REPT(\"1 - 30 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],1,30))   &   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":"Paid"}]
[null,{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,16)","v":"2017-04-16"},"AF0065","AFS1",{"v":1500,"d":"$1,500.00"},{"$f":"Invoices[[#This Row],[INVOICE DATE]]","v":"2017-04-16"},"No",null,{"$f":"IFERROR(IF(Invoices[[#This Row],[PAID]]=\"Yes\",0,IF(ReportDate-Invoices[[#This Row],[DUE DATE]]=0,-1,ReportDate-Invoices[[#This Row],[DUE DATE]])),\"\")","v":34},{"$f":"REPT(\"Paid\",Invoices[[#This Row],[DAYS]]=0) & REPT(\"Not Yet Overdue\",Invoices[[#This Row],[DAYS]]<0) & REPT(\"1 - 30 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],1,30))   &   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,{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,18)","v":"2017-04-18"},"CT0029","CTB1",{"v":1456.23,"d":"$1,456.23"},{"$f":"Invoices[[#This Row],[INVOICE DATE]]","v":"2017-04-18"},"No",null,{"$f":"IFERROR(IF(Invoices[[#This Row],[PAID]]=\"Yes\",0,IF(ReportDate-Invoices[[#This Row],[DUE DATE]]=0,-1,ReportDate-Invoices[[#This Row],[DUE DATE]])),\"\")","v":32},{"$f":"REPT(\"Paid\",Invoices[[#This Row],[DAYS]]=0) & REPT(\"Not Yet Overdue\",Invoices[[#This Row],[DAYS]]<0) & REPT(\"1 - 30 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],1,30))   &   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,{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,21)","v":"2017-04-21"},"AF5089","AFF1",{"v":9735.95,"d":"$9,735.95"},{"$f":"Invoices[[#This Row],[INVOICE DATE]]+12","v":"2017-05-03"},"No",null,{"$f":"IFERROR(IF(Invoices[[#This Row],[PAID]]=\"Yes\",0,IF(ReportDate-Invoices[[#This Row],[DUE DATE]]=0,-1,ReportDate-Invoices[[#This Row],[DUE DATE]])),\"\")","v":17},{"$f":"REPT(\"Paid\",Invoices[[#This Row],[DAYS]]=0) & REPT(\"Not Yet Overdue\",Invoices[[#This Row],[DAYS]]<0) & REPT(\"1 - 30 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],1,30))   &   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,{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,21)","v":"2017-04-21"},"CB2995","CBA2",{"v":1520,"d":"$1,520.00"},{"$f":"Invoices[[#This Row],[INVOICE DATE]]+12","v":"2017-05-03"},"No",null,{"$f":"IFERROR(IF(Invoices[[#This Row],[PAID]]=\"Yes\",0,IF(ReportDate-Invoices[[#This Row],[DUE DATE]]=0,-1,ReportDate-Invoices[[#This Row],[DUE DATE]])),\"\")","v":17},{"$f":"REPT(\"Paid\",Invoices[[#This Row],[DAYS]]=0) & REPT(\"Not Yet Overdue\",Invoices[[#This Row],[DAYS]]<0) & REPT(\"1 - 30 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],1,30))   &   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,{"$f":"TODAY()","v":"2017-05-20"},"CB2154","CBA2",{"v":60,"d":"$60.00"},{"$f":"Invoices[[#This Row],[INVOICE DATE]]+7","v":"2017-05-27"},"No",null,{"$f":"IFERROR(IF(Invoices[[#This Row],[PAID]]=\"Yes\",0,IF(ReportDate-Invoices[[#This Row],[DUE DATE]]=0,-1,ReportDate-Invoices[[#This Row],[DUE DATE]])),\"\")","v":-7},{"$f":"REPT(\"Paid\",Invoices[[#This Row],[DAYS]]=0) & REPT(\"Not Yet Overdue\",Invoices[[#This Row],[DAYS]]<0) & REPT(\"1 - 30 Days\",Invoices[[#This Row],[DAYS]]=MEDIAN(Invoices[[#This Row],[DAYS]],1,30))   &   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":"Not Yet Overdue"}]