{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["General info","info. Statement"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"General info","index":0,"n_rows":29,"n_cols":40,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,18,1,24],[2,22,2,24],[2,25,2,27],[2,31,2,33],[2,34,2,36],[2,37,2,39],[2,0,2,8],[2,9,2,17],[2,28,2,30],[2,18,2,21],[1,37,1,39],[1,28,1,30],[1,31,1,33],[1,34,1,36],[1,25,1,27]]}
["今天日期：",{"$f":"TODAY()","v":"2011-12-08"},null,null,null,null,null,{"$f":"DATE(YEAR(B1),MONTH(B1),1)","v":"2011-12-01"},{"$f":"DATE(YEAR(B1)+1,1,1)","v":"2012-01-01"},null,null,null,"是",null,null,null,null,null,null,{"$f":"DATE(YEAR(B1),MONTH(B1)+1,1)","v":"2012-01-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"否",null,null,null,null,null,"全部帐单",null,null,null,null,null,null,"待处理帐单",null,null,"下月帐单",null,null,"本月帐单日",null,null,"上一月帐单",null,null,"上二月帐单"]
["General Information",null,null,null,null,null,null,null,null,"Other Information",null,null,null,null,null,null,null,null,"Total Bills",null,null,null,"Payment Info",null,null,null,null,null,"Next Bill Info.",null,null,"Current Bill",null,null,"Last Bill Info.",null,null,"Last Second Info."]
["Bank","Card No.","Bill","Days left to pay","The last day to pay","Pay Date","Left Available Amount","Times used this month","Times used this year","User Name","Amount","Used Amount","Is Regular Pay Day","Days no Interests","Regular Date","Ways to Pay","Issue Date","Months been Issued","Total Amount of Bills","Times Used","Billed Amount","Unbilled Amount","Paid Amount","Payment Times","Left Bill Amount","Bill Date","Last Pay Date","Days left to pay","Next Bill Date","Bill Numbers","Bill Amounts","Bill Date","Bill Numbers","Bill Amounts","Last Bill Date","Bill Numbers","Bill Amounts","Bill Date","Bill Numbers","Bill Amounts"]
["WellsFargo","x0000","N/A",{"$f":"AB5","v":54},{"$f":"AA5","v":"2012-01-31"},7,{"$f":"K5-L5","v":0},{"$f":"COUNT(IF(('info. Statement'!$C$3:$C$1997=B5)*('info. Statement'!$F$3:$F$1997>0)*('info. Statement'!$G$3:$G$1997>=$H$1)*('info. Statement'!$G$3:$G$1997<$T$1),'info. Statement'!$E$3:$E$1997))","v":0},{"$f":"COUNT(IF(('info. Statement'!$C$3:$C$1997=B5)*('info. Statement'!$F$3:$F$1997>0)*('info. Statement'!$G$3:$G$1997<$I$1)*('info. Statement'!$G$3:$G$1997<$T$1),'info. Statement'!$E$3:$E$1997))","v":0},"****",0,{"$f":"Y5","v":0},"No",25,null,"Check/Cash/Transfer","2011-01-01",{"$f":"ROUND((TODAY()-Q5)/30,0)","v":11},{"$f":"U5+V5","v":0},{"$f":"COUNT(IF(('info. Statement'!$C$3:$C$1997=B5)*('info. Statement'!$F$3:$F$1997>0),'info. Statement'!$E$3:$E$1997))","v":0},{"$f":"SUM(IF(('info. Statement'!$C$3:$C$5016=$B5)*('info. Statement'!$G$3:$G$5016<=Z5)*('info. Statement'!$F$3:$F$5016>0),'info. Statement'!$F$3:$F$5016))","v":0},{"$f":"SUM(IF(('info. Statement'!$C$3:$C$5016=$B5)*('info. Statement'!$G$3:$G$5016>Z5)*('info. Statement'!$F$3:$F$5016>0),'info. Statement'!$F$3:$F$5016))","v":0},{"$f":"SUM(IF(('info. Statement'!$C$3:$C$5016=$B5)*('info. Statement'!$F$3:$F$5016<0),'info. Statement'!$F$3:$F$5016))","v":0},{"$f":"COUNT(IF(('info. Statement'!$C$3:$C$1997=B5)*('info. Statement'!$F$3:$F$1997<0),'info. Statement'!$E$3:$E$1997))","v":0},{"$f":"W5+S5","v":0},{"$f":"IF(AN5>0,AL5,IF(AK5>0,AI5,IF(AH5>0,AF5,IF(AE5>0,AC5,AC5))))","v":"2012-01-07"},{"$f":"IF(Z5=\"\",\"\",IF(M5=\"否\",Z5+N5,IF(O5<DAY(Z5),DATE(YEAR(Z5),MONTH(Z5)+1,O5),DATE(YEAR(Z5),MONTH(Z5),O5))))","v":"2012-01-31"},{"$f":"IF(AA5=\"\",\"\",AA5-TODAY())","v":54},{"$f":"DATE(YEAR(AF5),MONTH(AF5)+1,DAY(AF5))","v":"2012-01-07"},{"$f":"SUM(IF(('info. Statement'!$C$3:$C$5016=$B5)*('info. Statement'!$G$3:$G$5016<=AC5)*('info. Statement'!$F$3:$F$5016>0),'info. Statement'!$F$3:$F$5016))","v":0},{"$f":"AD5+W5","v":0},{"$f":"DATE(YEAR($B$1),MONTH($B$1),F5)","v":"2011-12-07"},{"$f":"SUM(IF(('info. Statement'!$C$3:$C$5016=$B5)*('info. Statement'!$G$3:$G$5016<=AF5)*('info. Statement'!$F$3:$F$5016>0),'info. Statement'!$F$3:$F$5016))","v":0},{"$f":"AG5+W5","v":0},{"$f":"DATE(YEAR(AF5),MONTH(AF5)-1,DAY(AF5))","v":"2011-11-07"},{"$f":"SUM(IF(('info. Statement'!$C$3:$C$5016=$B5)*('info. Statement'!$G$3:$G$5016<=AI5)*('info. Statement'!$F$3:$F$5016>0),'info. Statement'!$F$3:$F$5016))","v":0},{"$f":"AJ5+W5","v":0},{"$f":"DATE(YEAR(AF5),MONTH(AF5)-2,DAY(AF5))","v":"2011-10-07"},{"$f":"SUM(IF(('info. Statement'!$C$3:$C$5016=$B5)*('info. Statement'!$G$3:$G$5016<=AL5)*('info. Statement'!$F$3:$F$5016>0),'info. Statement'!$F$3:$F$5016))","v":0},{"$f":"AM5+W5","v":0}]
["WellsFargo",1234567,"N/A",{"$f":"AB6","v":35},{"$f":"AA6","v":"2012-01-12"},1,{"$f":"K6-L6","v":4000},{"$f":"COUNT(IF(('info. Statement'!$C$3:$C$1997=B6)*('info. Statement'!$F$3:$F$1997>0)*('info. Statement'!$G$3:$G$1997>=$H$1)*('info. Statement'!$G$3:$G$1997<$T$1),'info. Statement'!$E$3:$E$1997))","v":0},{"$f":"COUNT(IF(('info. Statement'!$C$3:$C$1997=B6)*('info. Statement'!$F$3:$F$1997>0)*('info. Statement'!$G$3:$G$1997<$I$1)*('info. Statement'!$G$3:$G$1997<$T$1),'info. Statement'!$E$3:$E$1997))","v":0},"Mingyan",4000,{"$f":"Y6","v":0},"Yes",10,12,null,"2010-12-08",{"$f":"ROUND((TODAY()-Q6)/30,0)","v":12},{"$f":"U6+V6","v":0},{"$f":"COUNT(IF(('info. Statement'!$C$3:$C$1997=B6)*('info. Statement'!$F$3:$F$1997>0),'info. Statement'!$E$3:$E$1997))","v":0},{"$f":"SUM(IF(('info. Statement'!$C$3:$C$5016=$B6)*('info. Statement'!$G$3:$G$5016<=Z6)*('info. Statement'!$F$3:$F$5016>0),'info. Statement'!$F$3:$F$5016))","v":0},{"$f":"SUM(IF(('info. Statement'!$C$3:$C$5016=$B6)*('info. Statement'!$G$3:$G$5016>Z6)*('info. Statement'!$F$3:$F$5016>0),'info. Statement'!$F$3:$F$5016))","v":0},{"$f":"SUM(IF(('info. Statement'!$C$3:$C$5016=$B6)*('info. Statement'!$F$3:$F$5016<0),'info. Statement'!$F$3:$F$5016))","v":0},{"$f":"COUNT(IF(('info. Statement'!$C$3:$C$1997=B6)*('info. Statement'!$F$3:$F$1997<0),'info. Statement'!$E$3:$E$1997))","v":0},{"$f":"W6+S6","v":0},{"$f":"IF(AN6>0,AL6,IF(AK6>0,AI6,IF(AH6>0,AF6,IF(AE6>0,AC6,AC6))))","v":"2012-01-01"},{"$f":"IF(Z6=\"\",\"\",IF(M6=\"否\",Z6+N6,IF(O6<DAY(Z6),DATE(YEAR(Z6),MONTH(Z6)+1,O6),DATE(YEAR(Z6),MONTH(Z6),O6))))","v":"2012-01-12"},{"$f":"IF(AA6=\"\",\"\",AA6-TODAY())","v":35},{"$f":"DATE(YEAR(AF6),MONTH(AF6)+1,DAY(AF6))","v":"2012-01-01"},{"$f":"SUM(IF(('info. Statement'!$C$3:$C$5016=$B6)*('info. Statement'!$G$3:$G$5016<=AC6)*('info. Statement'!$F$3:$F$5016>0),'info. Statement'!$F$3:$F$5016))","v":0},{"$f":"AD6+W6","v":0},{"$f":"DATE(YEAR($B$1),MONTH($B$1),F6)","v":"2011-12-01"},{"$f":"SUM(IF(('info. Statement'!$C$3:$C$5016=$B6)*('info. Statement'!$G$3:$G$5016<=AF6)*('info. Statement'!$F$3:$F$5016>0),'info. Statement'!$F$3:$F$5016))","v":0},{"$f":"AG6+W6","v":0},{"$f":"DATE(YEAR(AF6),MONTH(AF6)-1,DAY(AF6))","v":"2011-11-01"},{"$f":"SUM(IF(('info. Statement'!$C$3:$C$5016=$B6)*('info. Statement'!$G$3:$G$5016<=AI6)*('info. Statement'!$F$3:$F$5016>0),'info. Statement'!$F$3:$F$5016))","v":0},{"$f":"AJ6+W6","v":0},{"$f":"DATE(YEAR(AF6),MONTH(AF6)-2,DAY(AF6))","v":"2011-10-01"},{"$f":"SUM(IF(('info. Statement'!$C$3:$C$5016=$B6)*('info. Statement'!$G$3:$G$5016<=AL6)*('info. Statement'!$F$3:$F$5016>0),'info. Statement'!$F$3:$F$5016))","v":0},{"$f":"AM6+W6","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C5:C24)","v":0},null,null,null,{"$f":"SUM(G6:G24)","v":4000},{"$f":"SUM(H5:H24)","v":0},{"$f":"SUM(I5:I24)","v":0},null,{"$f":"SUM(K6:K24)","v":4000},{"$f":"SUM(L6:L24)","v":0},null,null,null,null,null,null,{"$f":"SUM(S6:S24)","v":0},{"$f":"SUM(T5:T24)","v":0},{"$f":"SUM(U6:U24)","v":0},{"$f":"SUM(V6:V24)","v":0},{"$f":"SUM(W6:W24)","v":0},{"$f":"SUM(X5:X24)","v":0},{"$f":"SUM(Y5:Y24)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"45000-44625","v":375}]

{"sheet":"info. Statement","index":1,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
["Use Location","Bank","Card No.","卡主姓名","卡额度","Amount","Date","事由"]
["Macy",null,"16239888",null,null,30,"2011-12-08","shopping"]
["provo",null,"1234567",null,null,40,"2011-12-08","shopping"]