{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Cash Report"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Cash Report","index":0,"n_rows":34,"n_cols":7,"rows_kept":34,"merged":[[1,2,3,4],[30,2,30,4],[31,2,31,4],[32,2,32,4],[33,2,33,4]]}
[]
[null,null,"Cash Report"]
[{"$nulls":5},"Report for Date:","2013-06-01"]
[{"$nulls":5},"Cashier:","Kim Abercrombie"]
[]
[]
[null,null,"#","Receipt No.","Payment Method","Description","Amount"]
[null,null,1,12365,"Cash","Cashier 1",{"v":100,"d":"$100.00"}]
[null,null,2,12367,"Check","Cashier 1",{"v":20,"d":"$20.00"}]
[null,null,3,12384,"Credit Card","Cashier 1",{"v":30,"d":"$30.00"}]
[null,null,4,12396,"Other","Cashier 1",{"v":40,"d":"$40.00"}]
[null,null,5,12405,"Cash","Cashier 2",{"v":50,"d":"$50.00"}]
[null,null,6,12406,"Check","Cashier 2",{"v":60,"d":"$60.00"}]
[null,null,7,12432,"Credit Card","Cashier 2",{"v":1070,"d":"$1,070.00"}]
[null,null,8]
[null,null,9]
[null,null,10]
[null,null,11]
[null,null,12]
[null,null,13]
[null,null,14]
[null,null,15]
[null,null,16]
[null,null,17]
[null,null,18]
[null,null,19]
[null,null,20]
[{"$nulls":5},"Total",{"$f":"SUBTOTAL(109,tblReceipts[Amount])","v":{"v":1370,"d":"$1,370.00"}}]
[]
[{"$nulls":5},"Total Receipts:",{"$f":"COUNTA(tblReceipts[Payment Method])","v":7}]
[null,null,"  Last Reported Receipt #:  ",null,null,"Cash",{"$f":"SUMIF(tblReceipts[Payment Method],F31,tblReceipts[Amount])","v":{"v":150,"d":"$150.00"}}]
[null,null,"  Name:  ",null,null,"Check",{"$f":"SUMIF(tblReceipts[Payment Method],F32,tblReceipts[Amount])","v":{"v":80,"d":"$80.00"}}]
[null,null,"  Signature:  ",null,null,"Credit Card",{"$f":"SUMIF(tblReceipts[Payment Method],F33,tblReceipts[Amount])","v":{"v":1100,"d":"$1,100.00"}}]
[null,null,"  Date:  ",null,null,"Other",{"$f":"SUMIF(tblReceipts[Payment Method],F34,tblReceipts[Amount])","v":{"v":40,"d":"$40.00"}}]