{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Source","PivotTable","View","Chart1"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":1},"unopened":[{"sheet":"Chart1","index":3,"reason":"not_a_worksheet"}],"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":"Source","index":0,"n_rows":125,"n_cols":8,"rows_kept":125,"cut":false,"hidden":false,"merged":[]}
[null,"Start","End"]
[null,{"$f":"DATE(2007,1,1)","v":"2007-01-01"},{"$f":"DATE(2008,12,31)","v":"2008-12-31"}]
[]
[null,"Table1",null,null,null,null,"Table10"]
[null,"Type","DDate","Amt",null,null,"USA","WRS"]
[null,"Mortgage",{"$f":"DATE(YEAR(RANDBETWEEN(Start,End)),MONTH(RANDBETWEEN(Start,End)),DAY(RANDBETWEEN(Start,End)))","v":"2008-09-04"},1030,null,null,"Jan","Jan"]
[null,"Insurance","2008-10-15",218,null,null,"Feb","Feb"]
[null,"Power","2008-12-29",51.62,null,null,"Mar","Mar"]
[null,"Gas","2008-12-05",509.8,null,null,"Apr","Apr"]
[null,"Phone","2008-12-02",193.4,null,null,"May","May"]
[null,"Mortgage","2008-10-13",1021,null,null,"Jun","Jun"]
[null,"Insurance","2007-10-25",256,null,null,"Jul","Jul"]
[null,"Power","2007-04-09",54.11,null,null,"Aug","Aug"]
[null,"Gas","2007-06-18",495.22,null,null,"Sep","Sep"]
[null,"Phone","2008-05-24",194.3,null,null,"Oct","Oct"]
[null,"Mortgage","2008-07-01",974,null,null,"Nov","Nov"]
[null,"Insurance","2008-03-12",265,null,null,"Dec","Dec"]
[null,"Power","2007-06-12",51.91]
[null,"Gas","2007-09-02",448.96]
[null,"Phone","2008-09-04",126.5]
[null,"Mortgage","2008-05-18",991]
[null,"Insurance","2008-11-07",297]
[null,"Power","2008-06-04",57.76]
[null,"Gas","2008-02-07",409.7]
[null,"Phone","2007-03-23",163]
[null,"Mortgage","2008-09-12",919]
[null,"Insurance","2007-04-13",351]
[null,"Power","2008-04-25",55.88]
[null,"Gas","2007-01-02",345.49]
[null,"Phone","2008-06-01",143.80000000000001]
[null,"Mortgage","2008-11-29",887]
[null,"Insurance","2008-10-03",364]
[null,"Power","2008-06-03",53.75]
[null,"Gas","2007-01-24",325.41000000000003]
[null,"Phone","2008-10-12",113.9]
[null,"Mortgage","2007-02-05",822]
[null,"Insurance","2008-03-14",397]
[null,"Power",{"$f":"DATE(YEAR(RANDBETWEEN(Start,End)),MONTH(RANDBETWEEN(Start,End)),DAY(RANDBETWEEN(Start,End)))","v":"2008-12-22"},52.97]
[null,"Gas","2008-06-29",325.83]
[null,"Phone","2008-02-22",121]
[null,"Mortgage","2007-05-30",814]
[null,"Insurance","2007-09-14",430]
[null,"Power","2008-10-07",57.16]
[null,"Gas","2008-08-09",322.17]
[null,"Phone","2008-11-02",160]
[null,"Mortgage","2008-12-27",828]
[null,"Insurance","2007-07-13",471]
[null,"Power","2007-12-01",54.42]
[null,"Gas","2007-10-23",374.43]
[null,"Phone","2008-07-13",171.4]
[null,"Mortgage","2008-02-14",818]
[null,"Insurance","2008-12-08",481]
[null,"Power","2007-02-25",57.43]
[null,"Gas","2008-01-18",416.15]
[null,"Phone","2008-07-09",170.4]
[null,"Mortgage","2008-07-16",722]
[null,"Insurance","2008-09-14",515]
[null,"Power","2008-05-18",56.38]
[null,"Gas","2008-08-11",481.54]
[null,"Phone","2007-11-25",186.2]
[null,"Mortgage","2008-02-13",688]
[null,"Insurance","2007-05-14",544]
[null,"Power","2008-11-12",51.09]
[null,"Gas","2007-05-14",502.91]
[null,"Phone","2008-02-20",107.4]
[null,"Mortgage","2007-05-10",686]
[null,"Insurance","2008-01-06",576]
[null,"Power","2008-03-02",53.69]
[null,"Gas","2008-11-13",515.79999999999995]
[null,"Phone",{"$f":"DATE(YEAR(RANDBETWEEN(Start,End)),MONTH(RANDBETWEEN(Start,End)),DAY(RANDBETWEEN(Start,End)))","v":"2008-01-25"},109.4]
[null,"Mortgage","2008-12-18",652]
[null,"Insurance","2008-12-09",600]
[null,"Power","2008-06-07",56.83]
[null,"Gas","2008-05-12",488.22]
[null,"Phone","2008-08-14",176.3]
[null,"Mortgage","2008-02-03",614]
[null,"Insurance","2007-10-01",636]
[null,"Power","2008-03-29",50.4]
[null,"Gas","2007-02-23",460.37]
[null,"Phone","2007-04-27",104.1]
[null,"Mortgage","2008-04-06",567]
[null,"Insurance","2008-09-16",669]
[null,"Power","2007-01-11",58.31]
[null,"Gas","2008-06-11",408.99]
[null,"Phone","2007-09-15",168.5]
[null,"Mortgage","2008-06-19",540]
[null,"Insurance","2008-01-13",705]
[null,"Power","2008-11-04",52.47]
[null,"Gas","2008-01-28",354.13]
[null,"Phone","2008-03-01",116.9]
[null,"Mortgage","2007-08-09",507]
[null,"Insurance","2008-07-13",727]
[null,"Power","2007-08-18",58.64]
[null,"Gas","2007-01-12",316.77]
[null,"Phone","2007-03-03",158.6]
[null,"Mortgage","2007-10-01",471]
[null,"Insurance","2008-04-04",764]
[null,"Power","2007-11-04",52.43]
[null,"Gas","2008-05-09",301.07]
[null,"Phone","2008-06-03",130.5]
[null,"Mortgage","2007-05-27",493]
[null,"Insurance",{"$f":"DATE(YEAR(RANDBETWEEN(Start,End)),MONTH(RANDBETWEEN(Start,End)),DAY(RANDBETWEEN(Start,End)))","v":"2007-10-10"},803]
[null,"Power","2008-02-03",53.48]
[null,"Gas","2008-04-02",329.24]
[null,"Phone","2008-08-26",173.6]
[null,"Mortgage","2008-06-03",487]
[null,"Insurance","2008-03-29",815]
[null,"Power","2008-12-04",51.34]
[null,"Gas","2008-03-01",390.04]
[null,"Phone","2008-11-05",187.1]
[null,"Mortgage","2007-07-23",445]
[null,"Insurance","2007-12-01",858]
[null,"Power","2007-01-30",55.77]
[null,"Gas","2008-01-17",415.86]
[null,"Phone","2008-01-27",166.4]
[null,"Mortgage","2008-01-15",414]
[null,"Insurance","2007-02-20",873]
[null,"Power","2007-01-13",54.7]
[null,"Gas","2008-11-06",483.87]
[null,"Phone","2008-06-01",122.4]
[null,"Mortgage","2008-05-15",365]
[null,"Insurance","2007-09-14",911]
[null,"Power","2007-01-19",55.33]
[null,"Gas","2007-06-10",523.54]
[null,"Phone","2008-03-18",119.1]

{"sheet":"PivotTable","index":1,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"View"]
[null,2]
[]
[]
[]
[]
[null,"DDate","(Multiple Items)"]
[]
[null,"Years","Type","Sum of Amt"]
[null,"2007","Gas",1850.0800000000002]
[null,null,"Insurance",2593]
[null,null,"Mortgage",2492]
[null,"2008","Gas",2340.48]
[null,null,"Insurance",2440]
[null,null,"Mortgage",1921]
[null,"Grand Total",null,13636.56]

{"sheet":"View","index":2,"n_rows":61,"n_cols":2,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[]
["View 1"]
[null,"Table11"]
[null,"Type"]
[null,"Gas"]
[null,"Insurance"]
[null,"Mortgage"]
[null,"Phone"]
[null,"Power"]
[]
[null,"Table12"]
[null,"Month"]
[null,"Jan"]
[null,"Feb"]
[null,"Mar"]
[null,"Apr"]
[null,"May"]
[null,"Jun"]
[null,"Jul"]
[null,"Aug"]
[null,"Sep"]
[null,"Oct"]
[null,"Nov"]
[null,"Dec"]
[]
[null,"Table13"]
[null,"Year"]
[null,2007]
[null,2008]
[]
[]
[]
["View 2"]
[]
[null,"Table21"]
[null,"Type"]
[null,"Gas"]
[null,"Insurance"]
[null,"Mortgage"]
[null,"Phone"]
[null,"Power"]
[]
[null,"Table22"]
[null,"Month"]
[null,"Jan"]
[null,"Feb"]
[null,"Mar"]
[null,"Apr"]
[null,"May"]
[null,"Jun"]
[null,"Jul"]
[null,"Aug"]
[null,"Sep"]
[null,"Oct"]
[null,"Nov"]
[null,"Dec"]
[]
[null,"Table23"]
[null,"Year"]
[null,2007]
[null,2008]