{"text_format":"3","workbook":"xls","n_sheets":5,"sheets":["应收账款分析模型","高级筛选结果","应收账款账龄分析表","应收账款分析模型 ","应付账款分析模型"],"not_rendered":{"charts":1,"images":1,"external_links":1,"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"应收账款分析模型","index":0,"n_rows":9,"n_cols":5,"rows_kept":9,"flags":["formulas_cached_only"]}
["开票日期","发票号码","公司名称","应收金额","付款期"]
["2002-01-02",11456,"A公司",{"v":50000,"d":"50000.00"},30]
["2002-03-05",22451,"B公司",{"v":25000,"d":"25000.00"},20]
["2002-05-04",65423,"D公司",{"v":12500,"d":"12500.00"},60]
["2002-07-11",45216,"E公司",{"v":45452,"d":"45452.00"},40]
["2002-09-03",45456,"G公司",{"v":2450,"d":"2450.00"},30]
["2002-10-10",45123,"H公司",{"v":12350,"d":"12350.00"},50]
["2002-11-02",12655,"F公司",{"v":32000,"d":"32000.00"},20]
["2002-11-05",63251,"W公司",{"v":32510,"d":"32510.00"},20]

{"sheet":"高级筛选结果","index":1,"n_rows":8,"n_cols":14,"rows_kept":8,"merged":[[0,10,0,13]],"flags":["formulas_cached_only"]}
[null,"应收账款清单",{"$nulls":5},"今天日期","2002-11-01",null,"逾期天数"]
["开票日期","发票号码","公司名称","应收金额","已收款金额","未收款金额","收款期","到期日期","是否到期","未到期金额","0～30","30～60","60～90","90天以上"]
["2002-01-02",11456,"A公司",{"v":50000,"d":"50000.00"},{"v":20000,"d":"20000.00"},{"v":30000,"d":"30000.00"},30,"2002-02-01","是",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":30000,"d":"30000.00"}]
["2002-03-05",22451,"B公司",{"v":25000,"d":"25000.00"},{"v":5000,"d":"5000.00"},{"v":20000,"d":"20000.00"},20,"2002-03-25","是",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":20000,"d":"20000.00"}]
["2002-06-09",12345,"C公司",{"v":3000,"d":"3000.00"},{"v":0,"d":"0.00"},{"v":3000,"d":"3000.00"},30,"2002-07-09","是",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":3000,"d":"3000.00"}]
["2002-05-04",65423,"D公司",{"v":12500,"d":"12500.00"},{"v":10500,"d":"10500.00"},{"v":2000,"d":"2000.00"},60,"2002-07-03","是",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":2000,"d":"2000.00"}]
["2002-07-11",45216,"E公司",{"v":45452,"d":"45452.00"},{"v":5452,"d":"5452.00"},{"v":40000,"d":"40000.00"},40,"2002-08-20","是",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":40000,"d":"40000.00"},{"v":0,"d":"0.00"}]
["2002-09-03",45456,"G公司",{"v":2450,"d":"2450.00"},{"v":0,"d":"0.00"},{"v":2450,"d":"2450.00"},30,"2002-10-03","是",{"v":0,"d":"0.00"},{"v":2450,"d":"2450.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]

{"sheet":"应收账款账龄分析表","index":2,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,0,0,2]],"flags":["formulas_cached_only"]}
["应收账款账龄分析表"]
[null,"2002-11-01"]
["账龄","应收金额","百分比（％）"]
["未到期",16350,{"v":0.14367311072056238,"d":"14.37%"}]
["0～30",2450,{"v":0.021528998242530756,"d":"2.15%"}]
["30～60",0,{"v":0,"d":"0.00%"}]
["60～90",40000,{"v":0.351493848857645,"d":"35.15%"}]
["90天以上",55000,{"v":0.4833040421792619,"d":"48.33%"}]
["合计",113800,{"v":1,"d":"100.00%"}]

{"sheet":"应收账款分析模型 ","index":3,"n_rows":11,"n_cols":14,"rows_kept":11,"merged":[[0,10,0,13]],"flags":["formulas_cached_only"]}
[null,"应收账款清单",{"$nulls":5},"今天日期","2002-11-01",null,"逾期天数"]
["开票日期","发票号码","公司名称","应收金额","已收款金额","未收款金额","收款期","到期日期","是否到期","未到期金额","0～30","30～60","60～90","90天以上"]
["2002-01-02",11456,"A公司",{"v":50000,"d":"50000.00"},{"v":20000,"d":"20000.00"},{"v":30000,"d":"30000.00"},30,"2002-02-01","是",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":30000,"d":"30000.00"}]
["2002-03-05",22451,"B公司",{"v":25000,"d":"25000.00"},{"v":5000,"d":"5000.00"},{"v":20000,"d":"20000.00"},20,"2002-03-25","是",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":20000,"d":"20000.00"}]
["2002-06-09",12345,"C公司",{"v":3000,"d":"3000.00"},{"v":0,"d":"0.00"},{"v":3000,"d":"3000.00"},30,"2002-07-09","是",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":3000,"d":"3000.00"}]
["2002-05-04",65423,"D公司",{"v":12500,"d":"12500.00"},{"v":10500,"d":"10500.00"},{"v":2000,"d":"2000.00"},60,"2002-07-03","是",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":2000,"d":"2000.00"}]
["2002-07-11",45216,"E公司",{"v":45452,"d":"45452.00"},{"v":5452,"d":"5452.00"},{"v":40000,"d":"40000.00"},40,"2002-08-20","是",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":40000,"d":"40000.00"},{"v":0,"d":"0.00"}]
["2002-11-02",12655,"F公司",{"v":32000,"d":"32000.00"},{"v":16000,"d":"16000.00"},{"v":16000,"d":"16000.00"},20,"2002-11-22","否",{"v":16000,"d":"16000.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["2002-09-03",45456,"G公司",{"v":2450,"d":"2450.00"},{"v":0,"d":"0.00"},{"v":2450,"d":"2450.00"},30,"2002-10-03","是",{"v":0,"d":"0.00"},{"v":2450,"d":"2450.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["2002-10-10",45123,"H公司",{"v":12350,"d":"12350.00"},{"v":12000,"d":"12000.00"},{"v":350,"d":"350.00"},50,"2002-11-29","否",{"v":350,"d":"350.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":16350,"d":"16350.00"},{"v":2450,"d":"2450.00"},{"v":0,"d":"0.00"},{"v":40000,"d":"40000.00"},{"v":55000,"d":"55000.00"}]

{"sheet":"应付账款分析模型","index":4,"n_rows":10,"n_cols":14,"rows_kept":10,"merged":[[0,10,0,13]],"flags":["formulas_cached_only"]}
[null,"应付账款清单",{"$nulls":5},"今天日期","2002-11-01",null,"逾期天数"]
["开票日期","发票号码","公司名称","应付金额","已付款金额","未付款金额","付款期","到期日期","是否到期","未到期金额","0～30","30～60","60～90","90天以上"]
["2002-01-02",11456,"A公司",{"v":50000,"d":"50000.00"},{"v":20000,"d":"20000.00"},{"v":30000,"d":"30000.00"},30,"2002-02-01","是",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":30000,"d":"30000.00"}]
["2002-03-05",22451,"B公司",{"v":25000,"d":"25000.00"},{"v":5000,"d":"5000.00"},{"v":20000,"d":"20000.00"},20,"2002-03-25","是",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":20000,"d":"20000.00"}]
["2002-06-09",12345,"C公司",{"v":3000,"d":"3000.00"},{"v":0,"d":"0.00"},{"v":3000,"d":"3000.00"},30,"2002-07-09","是",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":3000,"d":"3000.00"}]
["2002-05-04",65423,"D公司",{"v":12500,"d":"12500.00"},{"v":10500,"d":"10500.00"},{"v":2000,"d":"2000.00"},60,"2002-07-03","是",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":2000,"d":"2000.00"}]
["2002-07-11",45216,"E公司",{"v":45452,"d":"45452.00"},{"v":5452,"d":"5452.00"},{"v":40000,"d":"40000.00"},40,"2002-08-20","是",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":40000,"d":"40000.00"},{"v":0,"d":"0.00"}]
["2002-11-02",12655,"F公司",{"v":32000,"d":"32000.00"},{"v":16000,"d":"16000.00"},{"v":16000,"d":"16000.00"},20,"2002-11-22","否",{"v":16000,"d":"16000.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["2002-09-03",45456,"G公司",{"v":2450,"d":"2450.00"},{"v":0,"d":"0.00"},{"v":2450,"d":"2450.00"},30,"2002-10-03","是",{"v":0,"d":"0.00"},{"v":2450,"d":"2450.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["2002-10-10",45123,"H公司",{"v":12350,"d":"12350.00"},{"v":12000,"d":"12000.00"},{"v":350,"d":"350.00"},50,"2002-11-29","否",{"v":350,"d":"350.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]