{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Source","PivotTable","Chart1"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":1},"unopened":[{"sheet":"Chart1","index":2,"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":4,"rows_kept":125,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Type","DDate","Amt"]
[null,"Mortgage","2007-01-10",{"$f":"RANDBETWEEN(1000,1100)-([DDate]-INDEX([DDate],1))","v":1068}]
[null,"Insurance","2007-01-12",{"$f":"([DDate]-INDEX([DDate],1))+RANDBETWEEN(200,230)","v":225}]
[null,"Power","2007-01-14",{"$f":"RANDBETWEEN(5000,5900)/100","v":55.06}]
[null,"Gas","2007-01-19",{"$f":"ROUND(COS(([DDate]-INDEX([DDate],1))/365*2*PI())*100+400+RANDBETWEEN(0,30),2)","v":498.8}]
[null,"Phone","2007-01-22",{"$f":"RANDBETWEEN(1001,1999)/10","v":177.6}]
[null,"Mortgage","2007-02-10",{"$f":"RANDBETWEEN(1000,1100)-([DDate]-INDEX([DDate],1))","v":1046}]
[null,"Insurance","2007-02-12",{"$f":"([DDate]-INDEX([DDate],1))+RANDBETWEEN(200,230)","v":259}]
[null,"Power","2007-02-14",{"$f":"RANDBETWEEN(5000,5900)/100","v":51.44}]
[null,"Gas","2007-02-19",{"$f":"ROUND(COS(([DDate]-INDEX([DDate],1))/365*2*PI())*100+400+RANDBETWEEN(0,30),2)","v":486.22}]
[null,"Phone","2007-02-22",{"$f":"RANDBETWEEN(1001,1999)/10","v":153.9}]
[null,"Mortgage","2007-03-10",{"$f":"RANDBETWEEN(1000,1100)-([DDate]-INDEX([DDate],1))","v":1010}]
[null,"Insurance","2007-03-12",{"$f":"([DDate]-INDEX([DDate],1))+RANDBETWEEN(200,230)","v":270}]
[null,"Power","2007-03-14",{"$f":"RANDBETWEEN(5000,5900)/100","v":50.4}]
[null,"Gas","2007-03-19",{"$f":"ROUND(COS(([DDate]-INDEX([DDate],1))/365*2*PI())*100+400+RANDBETWEEN(0,30),2)","v":457.96}]
[null,"Phone","2007-03-22",{"$f":"RANDBETWEEN(1001,1999)/10","v":178.6}]
[null,"Mortgage","2007-04-10",{"$f":"RANDBETWEEN(1000,1100)-([DDate]-INDEX([DDate],1))","v":992}]
[null,"Insurance","2007-04-12",{"$f":"([DDate]-INDEX([DDate],1))+RANDBETWEEN(200,230)","v":299}]
[null,"Power","2007-04-14",{"$f":"RANDBETWEEN(5000,5900)/100","v":51.12}]
[null,"Gas","2007-04-19",{"$f":"ROUND(COS(([DDate]-INDEX([DDate],1))/365*2*PI())*100+400+RANDBETWEEN(0,30),2)","v":401.7}]
[null,"Phone","2007-04-22",{"$f":"RANDBETWEEN(1001,1999)/10","v":191.6}]
[null,"Mortgage","2007-05-10",{"$f":"RANDBETWEEN(1000,1100)-([DDate]-INDEX([DDate],1))","v":932}]
[null,"Insurance","2007-05-12",{"$f":"([DDate]-INDEX([DDate],1))+RANDBETWEEN(200,230)","v":340}]
[null,"Power","2007-05-14",{"$f":"RANDBETWEEN(5000,5900)/100","v":57.85}]
[null,"Gas","2007-05-19",{"$f":"ROUND(COS(([DDate]-INDEX([DDate],1))/365*2*PI())*100+400+RANDBETWEEN(0,30),2)","v":361.49}]
[null,"Phone","2007-05-22",{"$f":"RANDBETWEEN(1001,1999)/10","v":120.2}]
[null,"Mortgage","2007-06-10",{"$f":"RANDBETWEEN(1000,1100)-([DDate]-INDEX([DDate],1))","v":936}]
[null,"Insurance","2007-06-12",{"$f":"([DDate]-INDEX([DDate],1))+RANDBETWEEN(200,230)","v":353}]
[null,"Power","2007-06-14",{"$f":"RANDBETWEEN(5000,5900)/100","v":56.75}]
[null,"Gas","2007-06-19",{"$f":"ROUND(COS(([DDate]-INDEX([DDate],1))/365*2*PI())*100+400+RANDBETWEEN(0,30),2)","v":323.41000000000003}]
[null,"Phone","2007-06-22",{"$f":"RANDBETWEEN(1001,1999)/10","v":140.5}]
[null,"Mortgage","2007-07-10",{"$f":"RANDBETWEEN(1000,1100)-([DDate]-INDEX([DDate],1))","v":912}]
[null,"Insurance","2007-07-12",{"$f":"([DDate]-INDEX([DDate],1))+RANDBETWEEN(200,230)","v":399}]
[null,"Power","2007-07-14",{"$f":"RANDBETWEEN(5000,5900)/100","v":57.06}]
[null,"Gas","2007-07-19",{"$f":"ROUND(COS(([DDate]-INDEX([DDate],1))/365*2*PI())*100+400+RANDBETWEEN(0,30),2)","v":323.83}]
[null,"Phone","2007-07-22",{"$f":"RANDBETWEEN(1001,1999)/10","v":159.80000000000001}]
[null,"Mortgage","2007-08-10",{"$f":"RANDBETWEEN(1000,1100)-([DDate]-INDEX([DDate],1))","v":810}]
[null,"Insurance","2007-08-12",{"$f":"([DDate]-INDEX([DDate],1))+RANDBETWEEN(200,230)","v":435}]
[null,"Power","2007-08-14",{"$f":"RANDBETWEEN(5000,5900)/100","v":52.25}]
[null,"Gas","2007-08-19",{"$f":"ROUND(COS(([DDate]-INDEX([DDate],1))/365*2*PI())*100+400+RANDBETWEEN(0,30),2)","v":342.17}]
[null,"Phone","2007-08-22",{"$f":"RANDBETWEEN(1001,1999)/10","v":149.5}]
[null,"Mortgage","2007-09-10",{"$f":"RANDBETWEEN(1000,1100)-([DDate]-INDEX([DDate],1))","v":776}]
[null,"Insurance","2007-09-12",{"$f":"([DDate]-INDEX([DDate],1))+RANDBETWEEN(200,230)","v":448}]
[null,"Power","2007-09-14",{"$f":"RANDBETWEEN(5000,5900)/100","v":53.77}]
[null,"Gas","2007-09-19",{"$f":"ROUND(COS(([DDate]-INDEX([DDate],1))/365*2*PI())*100+400+RANDBETWEEN(0,30),2)","v":392.43}]
[null,"Phone","2007-09-22",{"$f":"RANDBETWEEN(1001,1999)/10","v":126.1}]
[null,"Mortgage","2007-10-10",{"$f":"RANDBETWEEN(1000,1100)-([DDate]-INDEX([DDate],1))","v":749}]
[null,"Insurance","2007-10-12",{"$f":"([DDate]-INDEX([DDate],1))+RANDBETWEEN(200,230)","v":490}]
[null,"Power","2007-10-14",{"$f":"RANDBETWEEN(5000,5900)/100","v":54.77}]
[null,"Gas","2007-10-19",{"$f":"ROUND(COS(([DDate]-INDEX([DDate],1))/365*2*PI())*100+400+RANDBETWEEN(0,30),2)","v":439.15}]
[null,"Phone","2007-10-22",{"$f":"RANDBETWEEN(1001,1999)/10","v":152.4}]
[null,"Mortgage","2007-11-10",{"$f":"RANDBETWEEN(1000,1100)-([DDate]-INDEX([DDate],1))","v":793}]
[null,"Insurance","2007-11-12",{"$f":"([DDate]-INDEX([DDate],1))+RANDBETWEEN(200,230)","v":521}]
[null,"Power","2007-11-14",{"$f":"RANDBETWEEN(5000,5900)/100","v":55.48}]
[null,"Gas","2007-11-19",{"$f":"ROUND(COS(([DDate]-INDEX([DDate],1))/365*2*PI())*100+400+RANDBETWEEN(0,30),2)","v":466.54}]
[null,"Phone","2007-11-22",{"$f":"RANDBETWEEN(1001,1999)/10","v":157.4}]
[null,"Mortgage","2007-12-10",{"$f":"RANDBETWEEN(1000,1100)-([DDate]-INDEX([DDate],1))","v":750}]
[null,"Insurance","2007-12-12",{"$f":"([DDate]-INDEX([DDate],1))+RANDBETWEEN(200,230)","v":565}]
[null,"Power","2007-12-14",{"$f":"RANDBETWEEN(5000,5900)/100","v":57.68}]
[null,"Gas","2007-12-19",{"$f":"ROUND(COS(([DDate]-INDEX([DDate],1))/365*2*PI())*100+400+RANDBETWEEN(0,30),2)","v":516.91}]
[null,"Phone","2007-12-22",{"$f":"RANDBETWEEN(1001,1999)/10","v":152.5}]
[null,"Mortgage","2008-01-10",{"$f":"RANDBETWEEN(1000,1100)-([DDate]-INDEX([DDate],1))","v":699}]
[null,"Insurance","2008-01-12",{"$f":"([DDate]-INDEX([DDate],1))+RANDBETWEEN(200,230)","v":591}]
[null,"Power","2008-01-14",{"$f":"RANDBETWEEN(5000,5900)/100","v":54.5}]
[null,"Gas","2008-01-19",{"$f":"ROUND(COS(([DDate]-INDEX([DDate],1))/365*2*PI())*100+400+RANDBETWEEN(0,30),2)","v":528.79999999999995}]
[null,"Phone","2008-01-22",{"$f":"RANDBETWEEN(1001,1999)/10","v":129.9}]
[null,"Mortgage","2008-02-10",{"$f":"RANDBETWEEN(1000,1100)-([DDate]-INDEX([DDate],1))","v":629}]
[null,"Insurance","2008-02-12",{"$f":"([DDate]-INDEX([DDate],1))+RANDBETWEEN(200,230)","v":618}]
[null,"Power","2008-02-14",{"$f":"RANDBETWEEN(5000,5900)/100","v":55.12}]
[null,"Gas","2008-02-19",{"$f":"ROUND(COS(([DDate]-INDEX([DDate],1))/365*2*PI())*100+400+RANDBETWEEN(0,30),2)","v":495.22}]
[null,"Phone","2008-02-22",{"$f":"RANDBETWEEN(1001,1999)/10","v":177.6}]
[null,"Mortgage","2008-03-10",{"$f":"RANDBETWEEN(1000,1100)-([DDate]-INDEX([DDate],1))","v":601}]
[null,"Insurance","2008-03-12",{"$f":"([DDate]-INDEX([DDate],1))+RANDBETWEEN(200,230)","v":628}]
[null,"Power","2008-03-14",{"$f":"RANDBETWEEN(5000,5900)/100","v":52.33}]
[null,"Gas","2008-03-19",{"$f":"ROUND(COS(([DDate]-INDEX([DDate],1))/365*2*PI())*100+400+RANDBETWEEN(0,30),2)","v":466.37}]
[null,"Phone","2008-03-22",{"$f":"RANDBETWEEN(1001,1999)/10","v":179.5}]
[null,"Mortgage","2008-04-10",{"$f":"RANDBETWEEN(1000,1100)-([DDate]-INDEX([DDate],1))","v":606}]
[null,"Insurance","2008-04-12",{"$f":"([DDate]-INDEX([DDate],1))+RANDBETWEEN(200,230)","v":688}]
[null,"Power","2008-04-14",{"$f":"RANDBETWEEN(5000,5900)/100","v":53.89}]
[null,"Gas","2008-04-19",{"$f":"ROUND(COS(([DDate]-INDEX([DDate],1))/365*2*PI())*100+400+RANDBETWEEN(0,30),2)","v":389.99}]
[null,"Phone","2008-04-22",{"$f":"RANDBETWEEN(1001,1999)/10","v":184.5}]
[null,"Mortgage","2008-05-10",{"$f":"RANDBETWEEN(1000,1100)-([DDate]-INDEX([DDate],1))","v":583}]
[null,"Insurance","2008-05-12",{"$f":"([DDate]-INDEX([DDate],1))+RANDBETWEEN(200,230)","v":690}]
[null,"Power","2008-05-14",{"$f":"RANDBETWEEN(5000,5900)/100","v":53.67}]
[null,"Gas","2008-05-19",{"$f":"ROUND(COS(([DDate]-INDEX([DDate],1))/365*2*PI())*100+400+RANDBETWEEN(0,30),2)","v":353.13}]
[null,"Phone","2008-05-22",{"$f":"RANDBETWEEN(1001,1999)/10","v":192.4}]
[null,"Mortgage","2008-06-10",{"$f":"RANDBETWEEN(1000,1100)-([DDate]-INDEX([DDate],1))","v":502}]
[null,"Insurance","2008-06-12",{"$f":"([DDate]-INDEX([DDate],1))+RANDBETWEEN(200,230)","v":736}]
[null,"Power","2008-06-14",{"$f":"RANDBETWEEN(5000,5900)/100","v":54.76}]
[null,"Gas","2008-06-19",{"$f":"ROUND(COS(([DDate]-INDEX([DDate],1))/365*2*PI())*100+400+RANDBETWEEN(0,30),2)","v":320.77}]
[null,"Phone","2008-06-22",{"$f":"RANDBETWEEN(1001,1999)/10","v":138.30000000000001}]
[null,"Mortgage","2008-07-10",{"$f":"RANDBETWEEN(1000,1100)-([DDate]-INDEX([DDate],1))","v":475}]
[null,"Insurance","2008-07-12",{"$f":"([DDate]-INDEX([DDate],1))+RANDBETWEEN(200,230)","v":756}]
[null,"Power","2008-07-14",{"$f":"RANDBETWEEN(5000,5900)/100","v":51.99}]
[null,"Gas","2008-07-19",{"$f":"ROUND(COS(([DDate]-INDEX([DDate],1))/365*2*PI())*100+400+RANDBETWEEN(0,30),2)","v":302.07}]
[null,"Phone","2008-07-22",{"$f":"RANDBETWEEN(1001,1999)/10","v":174.4}]
[null,"Mortgage","2008-08-10",{"$f":"RANDBETWEEN(1000,1100)-([DDate]-INDEX([DDate],1))","v":467}]
[null,"Insurance","2008-08-12",{"$f":"([DDate]-INDEX([DDate],1))+RANDBETWEEN(200,230)","v":808}]
[null,"Power","2008-08-14",{"$f":"RANDBETWEEN(5000,5900)/100","v":56.82}]
[null,"Gas","2008-08-19",{"$f":"ROUND(COS(([DDate]-INDEX([DDate],1))/365*2*PI())*100+400+RANDBETWEEN(0,30),2)","v":343.24}]
[null,"Phone","2008-08-22",{"$f":"RANDBETWEEN(1001,1999)/10","v":148.80000000000001}]
[null,"Mortgage","2008-09-10",{"$f":"RANDBETWEEN(1000,1100)-([DDate]-INDEX([DDate],1))","v":409}]
[null,"Insurance","2008-09-12",{"$f":"([DDate]-INDEX([DDate],1))+RANDBETWEEN(200,230)","v":813}]
[null,"Power","2008-09-14",{"$f":"RANDBETWEEN(5000,5900)/100","v":55.73}]
[null,"Gas","2008-09-19",{"$f":"ROUND(COS(([DDate]-INDEX([DDate],1))/365*2*PI())*100+400+RANDBETWEEN(0,30),2)","v":372.04}]
[null,"Phone","2008-09-22",{"$f":"RANDBETWEEN(1001,1999)/10","v":110.7}]
[null,"Mortgage","2008-10-10",{"$f":"RANDBETWEEN(1000,1100)-([DDate]-INDEX([DDate],1))","v":406}]
[null,"Insurance","2008-10-12",{"$f":"([DDate]-INDEX([DDate],1))+RANDBETWEEN(200,230)","v":867}]
[null,"Power","2008-10-14",{"$f":"RANDBETWEEN(5000,5900)/100","v":52.38}]
[null,"Gas","2008-10-19",{"$f":"ROUND(COS(([DDate]-INDEX([DDate],1))/365*2*PI())*100+400+RANDBETWEEN(0,30),2)","v":433.86}]
[null,"Phone","2008-10-22",{"$f":"RANDBETWEEN(1001,1999)/10","v":170.1}]
[null,"Mortgage","2008-11-10",{"$f":"RANDBETWEEN(1000,1100)-([DDate]-INDEX([DDate],1))","v":395}]
[null,"Insurance","2008-11-12",{"$f":"([DDate]-INDEX([DDate],1))+RANDBETWEEN(200,230)","v":899}]
[null,"Power","2008-11-14",{"$f":"RANDBETWEEN(5000,5900)/100","v":56.03}]
[null,"Gas","2008-11-19",{"$f":"ROUND(COS(([DDate]-INDEX([DDate],1))/365*2*PI())*100+400+RANDBETWEEN(0,30),2)","v":489.87}]
[null,"Phone","2008-11-22",{"$f":"RANDBETWEEN(1001,1999)/10","v":146.9}]
[null,"Mortgage","2008-12-10",{"$f":"RANDBETWEEN(1000,1100)-([DDate]-INDEX([DDate],1))","v":313}]
[null,"Insurance","2008-12-12",{"$f":"([DDate]-INDEX([DDate],1))+RANDBETWEEN(200,230)","v":924}]
[null,"Power","2008-12-14",{"$f":"RANDBETWEEN(5000,5900)/100","v":53.79}]
[null,"Gas","2008-12-19",{"$f":"ROUND(COS(([DDate]-INDEX([DDate],1))/365*2*PI())*100+400+RANDBETWEEN(0,30),2)","v":500.54}]
[null,"Phone","2008-12-22",{"$f":"RANDBETWEEN(1001,1999)/10","v":121.7}]

{"sheet":"PivotTable","index":1,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Month",null,"Year"]
[]
[]
[]
[]
[null,"DDate","May"]
[]
[null,"Years","Type","Sum of Amt"]
[null,"2008","Gas",353.13]
[null,null,"Insurance",692]
[null,null,"Mortgage",587]
[null,null,"Phone",197.7]
[null,null,"Power",58.92]
[null,"Grand Total",null,1888.7500000000002]