{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Cashier Balance Sheet"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Cashier Balance Sheet","index":0,"n_rows":65,"n_cols":5,"rows_kept":65,"merged":[[4,3,5,5]]}
[]
[null,"CASHIER BALANCE SHEET"]
[]
[null,"NAME",null,"SIGNATURE"]
[null,"KIM ABERCROMBIE"]
[]
[]
[]
[]
[null,"DATE","2013-06-01"]
[null,"DRAWER TOTAL",{"v":9123.87,"d":"$9,123.87"}]
[null,"COUNTED TOTAL",{"$f":"SUM($E$18:$E$23,$E$28:$E$33,$E$38:$E$43,$E$48:$E$53,$E$58:$E$64)","v":{"v":10614.08,"d":"$10,614.08"}}]
[null,"CASH TOTAL",{"$f":"SUM($E$18:$E$23,$E$28:$E$33,$E$38:$E$43,$E$48:$E$53,INDEX($E$58:$E$64,MATCH(\"odd change or bills\",$B$58:$B$64,0)))","v":{"v":9120.86,"d":"$9,120.86"}}]
[null,"OVER / SHORT",{"$f":"DrawerTotal-CountedTotal","v":{"v":-1490.2099999999991,"d":"($1,490.21)"}}]
[]
[]
[null,"ROLLED COINS","COUNT","ROLL VALUE","VALUE"]
[null,"DOLLAR COINS",0,{"v":25,"d":"$25.00"},{"$f":"'Cashier Balance Sheet'!$C18*'Cashier Balance Sheet'!$D18","v":{"v":0,"d":"$0.00"}}]
[null,"HALF DOLLARS",0,{"v":10,"d":"$10.00"},{"$f":"'Cashier Balance Sheet'!$C19*'Cashier Balance Sheet'!$D19","v":{"v":0,"d":"$0.00"}}]
[null,"QUARTERS",2,{"v":10,"d":"$10.00"},{"$f":"'Cashier Balance Sheet'!$C20*'Cashier Balance Sheet'!$D20","v":{"v":20,"d":"$20.00"}}]
[null,"DIMES",3,{"v":5,"d":"$5.00"},{"$f":"'Cashier Balance Sheet'!$C21*'Cashier Balance Sheet'!$D21","v":{"v":15,"d":"$15.00"}}]
[null,"NICKELS",1,{"v":2,"d":"$2.00"},{"$f":"'Cashier Balance Sheet'!$C22*'Cashier Balance Sheet'!$D22","v":{"v":2,"d":"$2.00"}}]
[null,"PENNIES",1,{"v":0.5,"d":"$0.50"},{"$f":"'Cashier Balance Sheet'!$C23*'Cashier Balance Sheet'!$D23","v":{"v":0.5,"d":"$0.50"}}]
[null,"TOTAL",{"$f":"SUM('Cashier Balance Sheet'!$C$18:$C$23)","v":7},null,{"$f":"SUBTOTAL(109,'Cashier Balance Sheet'!$E$18:$E$23)","v":{"v":37.5,"d":"$37.50"}}]
[]
[]
[null,"LOOSE COINS","COUNT","COIN VALUE","VALUE"]
[null,"SILVER DOLLARS",0,{"v":1,"d":"$1.00"},{"$f":"'Cashier Balance Sheet'!$C28*'Cashier Balance Sheet'!$D28","v":{"v":0,"d":"$0.00"}}]
[null,"HALF DOLLARS",0,{"v":0.5,"d":"$0.50"},{"$f":"'Cashier Balance Sheet'!$C29*'Cashier Balance Sheet'!$D29","v":{"v":0,"d":"$0.00"}}]
[null,"QUARTERS",42,{"v":0.25,"d":"$0.25"},{"$f":"'Cashier Balance Sheet'!$C30*'Cashier Balance Sheet'!$D30","v":{"v":10.5,"d":"$10.50"}}]
[null,"DIMES",33,{"v":0.1,"d":"$0.10"},{"$f":"'Cashier Balance Sheet'!$C31*'Cashier Balance Sheet'!$D31","v":{"v":3.3000000000000003,"d":"$3.30"}}]
[null,"NICKELS",22,{"v":0.05,"d":"$0.05"},{"$f":"'Cashier Balance Sheet'!$C32*'Cashier Balance Sheet'!$D32","v":{"v":1.1,"d":"$1.10"}}]
[null,"PENNIES",11,{"v":0.01,"d":"$0.01"},{"$f":"'Cashier Balance Sheet'!$C33*'Cashier Balance Sheet'!$D33","v":{"v":0.11,"d":"$0.11"}}]
[null,"TOTAL",{"$f":"SUM('Cashier Balance Sheet'!$C$28:$C$33)","v":108},null,{"$f":"SUBTOTAL(109,'Cashier Balance Sheet'!$E$28:$E$33)","v":{"v":15.01,"d":"$15.01"}}]
[]
[]
[null,"STRAPPED BILLS","COUNT","BUNDLE VALUE","VALUE"]
[null,"HUNDREDS",1,{"v":1000,"d":"$1,000.00"},{"$f":"'Cashier Balance Sheet'!$C38*'Cashier Balance Sheet'!$D38","v":{"v":1000,"d":"$1,000.00"}}]
[null,"FIFTIES",2,{"v":1000,"d":"$1,000.00"},{"$f":"'Cashier Balance Sheet'!$C39*'Cashier Balance Sheet'!$D39","v":{"v":2000,"d":"$2,000.00"}}]
[null,"TWENTIES",3,{"v":1000,"d":"$1,000.00"},{"$f":"'Cashier Balance Sheet'!$C40*'Cashier Balance Sheet'!$D40","v":{"v":3000,"d":"$3,000.00"}}]
[null,"TENS",4,{"v":250,"d":"$250.00"},{"$f":"'Cashier Balance Sheet'!$C41*'Cashier Balance Sheet'!$D41","v":{"v":1000,"d":"$1,000.00"}}]
[null,"FIVES",5,{"v":250,"d":"$250.00"},{"$f":"'Cashier Balance Sheet'!$C42*'Cashier Balance Sheet'!$D42","v":{"v":1250,"d":"$1,250.00"}}]
[null,"DOLLARS",6,{"v":50,"d":"$50.00"},{"$f":"'Cashier Balance Sheet'!$C43*'Cashier Balance Sheet'!$D43","v":{"v":300,"d":"$300.00"}}]
[null,"TOTAL",{"$f":"SUM('Cashier Balance Sheet'!$C$38:$C$43)","v":21},null,{"$f":"SUBTOTAL(109,'Cashier Balance Sheet'!$E$38:$E$43)","v":{"v":8550,"d":"$8,550.00"}}]
[]
[]
[null,"LOOSE BILLS","COUNT","BILL VALUE","VALUE"]
[null,"HUNDREDS",2,{"v":100,"d":"$100.00"},{"$f":"'Cashier Balance Sheet'!$C48*'Cashier Balance Sheet'!$D48","v":{"v":200,"d":"$200.00"}}]
[null,"FIFTIES",3,{"v":50,"d":"$50.00"},{"$f":"'Cashier Balance Sheet'!$C49*'Cashier Balance Sheet'!$D49","v":{"v":150,"d":"$150.00"}}]
[null,"TWENTIES",4,{"v":20,"d":"$20.00"},{"$f":"'Cashier Balance Sheet'!$C50*'Cashier Balance Sheet'!$D50","v":{"v":80,"d":"$80.00"}}]
[null,"TENS",5,{"v":10,"d":"$10.00"},{"$f":"'Cashier Balance Sheet'!$C51*'Cashier Balance Sheet'!$D51","v":{"v":50,"d":"$50.00"}}]
[null,"FIVES",6,{"v":5,"d":"$5.00"},{"$f":"'Cashier Balance Sheet'!$C52*'Cashier Balance Sheet'!$D52","v":{"v":30,"d":"$30.00"}}]
[null,"DOLLARS",7,{"v":1,"d":"$1.00"},{"$f":"'Cashier Balance Sheet'!$C53*'Cashier Balance Sheet'!$D53","v":{"v":7,"d":"$7.00"}}]
[null,"TOTAL",{"$f":"SUM('Cashier Balance Sheet'!$C$48:$C$53)","v":27},null,{"$f":"SUBTOTAL(109,'Cashier Balance Sheet'!$E$48:$E$53)","v":{"v":517,"d":"$517.00"}}]
[]
[]
[null,"MISC","AMOUNT",null,"VALUE"]
[null,"EBT FOOD STAMPS",{"v":250,"d":"$250.00"},null,{"$f":"C58","v":{"v":250,"d":"$250.00"}}]
[null,"EBT CASH",null,null,{"$f":"C59","v":{"v":0,"d":"$0.00"}}]
[null,"WIC",null,null,{"v":0,"d":"$0.00"}]
[null,"CREDIT CARDS",{"v":457.23,"d":"$457.23"},null,{"v":457.23,"d":"$457.23"}]
[null,"CHECKS",{"v":785.99,"d":"$785.99"},null,{"v":785.99,"d":"$785.99"}]
[null,"COUPONS",null,null,{"v":0,"d":"$0.00"}]
[null,"ODD CHANGE OR BILLS",{"v":1.35,"d":"$1.35"},null,{"v":1.35,"d":"$1.35"}]
[null,"TOTAL",{"$f":"SUM('Cashier Balance Sheet'!$C$58:$C$64)","v":{"v":1494.57,"d":"$1,494.57"}},null,{"$f":"SUBTOTAL(109,'Cashier Balance Sheet'!$E$58:$E$64)","v":{"v":1494.57,"d":"$1,494.57"}}]