{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Report","Data","Xtract","Graph"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Report","index":0,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9]]}
["St Paul Catholic Church"]
["August 2013 Offertory Collection"]
[]
[]
[]
["Masses","2013-08-03","2013-08-04","2013-08-10","2013-08-11","2013-08-17","2013-08-18","2013-08-23","2013-08-24","Total"]
[]
["08:30:00",0,{"$f":"SUM(Data!$E$2:$E$7*(Data!$B$2:$B$7=Report!C$6)*(Data!$A$2:$A$7=Report!$A8))","v":700},0,750,0,800,0,780,{"$f":"SUM(B8:I8)","v":3030}]
["10:00:00",{"$f":"SUM(Data!$E$2:$E$7*(Data!$B$2:$B$7=Report!B$6)*(Data!$A$2:$A$7=Report!$A9))","v":1000},1500,900,1550,950,1600,1100,1590,{"$f":"SUM(B9:I9)","v":10190}]
["13:00:00",850,1600,1000,1400,1100,1300,980,1450,9680]
["18:00:00",0,1700,0,1600,0,1750,0,1800,6850]
["Total",{"$f":"SUM(B8:B11)","v":1850},{"$f":"SUM(C8:C11)","v":5500},1900,5300,2050,5450,2080,5620,29750]

{"sheet":"Data","index":1,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Masses","Date","Last Name","First Name","Amount"]
["08:30:00","2013-08-04","Doe","John",400]
["08:30:00","2013-08-04","Newman","Bob",300]
["10:00:00","2013-08-03","James","Bill",600]
["10:00:00","2013-08-03","Doe","John",400]
["08:30:00","2013-08-11","Doe","John",600]
["08:30:00","2013-08-11","Newman","Bob",150]

{"sheet":"Xtract","index":2,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Masses","Date","Last Name","First Name","Amount"]
["08:30:00","2013-08-04"]
[]
["Masses","Date","Last Name","First Name","Amount"]
["08:30:00","2013-08-04","Doe","John",400]
["08:30:00","2013-08-04","Newman","Bob",300]

{"sheet":"Graph","index":3,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2013-08-03","2013-08-04","2013-08-10","2013-08-11","2013-08-17","2013-08-18","2013-08-23","2013-08-24"]
["Total",{"$f":"VLOOKUP($A$21,Report!$A$6:$I$12,2,FALSE)","v":1850},{"$f":"VLOOKUP($A$21,Report!$A$6:$I$12,MATCH(C$20,Report!$A$6:$I$6,0),FALSE)","v":5500},{"$f":"VLOOKUP($A$21,Report!$A$6:$I$12,MATCH(D$20,Report!$A$6:$I$6,0),FALSE)","v":1900},{"$f":"VLOOKUP($A$21,Report!$A$6:$I$12,MATCH(E$20,Report!$A$6:$I$6,0),FALSE)","v":5300},{"$f":"VLOOKUP($A$21,Report!$A$6:$I$12,MATCH(F$20,Report!$A$6:$I$6,0),FALSE)","v":2050},{"$f":"VLOOKUP($A$21,Report!$A$6:$I$12,MATCH(G$20,Report!$A$6:$I$6,0),FALSE)","v":5450},{"$f":"VLOOKUP($A$21,Report!$A$6:$I$12,MATCH(H$20,Report!$A$6:$I$6,0),FALSE)","v":2080},{"$f":"VLOOKUP($A$21,Report!$A$6:$I$12,MATCH(I$20,Report!$A$6:$I$6,0),FALSE)","v":5620}]