Spreadsheet: 167363d1341961555-excel-2007-copying-editing-conditional-sum-formulas-check-register
Sheet: PULLTABS

Pulltabs
 | Machine | Drawer |  |  | Pouch
Date | Total Cash         From Machine | Tickets | Cash | Drawer    Total | To                Pouch | From          Pouch | Pouch           Total | Notes
[NAME]. | 378090 |  |  |  |  |  |  | existing balance on machine
2011-11-03 00:00:00 | 3132 | 1846 | 154 | 2000 | 286
2011-11-03 00:00:00 | 2368 | 2842 | 158 | 3000 |  | 474
2011-11-03 00:00:00 |  |  |  |  | 200 |  |  | Took 200.00 from change bag for drawer
2011-11-07 00:00:00 | 1598 | 877 | 2122 | 2999 | 520 |  |  | Put 200.00 back into change bag
2011-11-07 00:00:00 |  |  |  |  |  | 175 |  | For 5 Bears jerseys.
2011-11-08 00:00:00 |  |  |  |  | 175 |  |  | 175. replaced from jerseys
2011-11-09 00:00:00 | 2789 | 2630 | 377 | 3007 | 159 |  |  | 20. short on total from machine
2011-11-11 00:00:00 | 1321 | 968 | 2032 | 3000 | 353 |  |  | 20. over on total from machine
2011-11-15 00:00:00 | 4144 | 2599 | 403 | 3002 | 1545 |  |  | machine # off- 38.00 over res. Total
2011-11-16 00:00:00 |  |  |  |  |  | 1589 |  | money from pouch to steve-did not count
2011-11-16 00:00:00 | 1207 | 1362 | 1639 | 3001 |  | 155
2011-11-18 00:00:00 | 2182 | 512 | 2493 | 3005 | 1670
2011-11-19 00:00:00 | 1654 | 1294 | 1723 | 3017 | 360
2011-11-19 00:00:00 |  |  |  |  |  | 13 |  | adjust pouch [NAME] short
2011-11-22 00:00:00 | 1402 | 943 | 2060 | 3003 | 459
2011-11-25 00:00:00 | 1872 | 852 | 2139 | 2991 | 957 |  |  |  | 3204 | Michelle, [NAME], [NAME]
2011-11-28 00:00:00 |  |  |  |  |  | 3200 |  | gave to [NAME]
2011-11-28 00:00:00 | 2195 | 1989 | 1010 | 2999 | 206
 | Machine | Drawer |  |  | Pouch
Date | Total Cash         From Machine | Tickets | Cash | Drawer    Total | To                Pouch | From          Pouch | Pouch           Total | Notes
2011-12-01 00:00:00 | 2807 | 2123 | 868 | 2991 | 684 |  |  | used $9 from drawer to test [NAME].  Malfunc.
2011-12-02 00:00:00 |  |  |  |  |  | 1080 |  | Put all 20s in ATM 1080.00
2011-12-03 00:00:00 | 2178 | 1245 | 1759 | 3004 | 765
2011-12-05 00:00:00 |  |  |  |  |  | 920 |  | Put all 20s in ATM 920.00
2011-12-05 00:00:00 | 213 |  |  |  | 213 |  |  | filled machine
2011-12-09 00:00:00 | 2782 | 2477 | 522 | 2999 | 304
2011-12-09 00:00:00 |  | 130 | 2870 | 3000 |  | 130
2011-12-12 00:00:00 | 1644 | 408 | 2594 | 3002 | 1236
2011-12-14 00:00:00 |  |  |  |  |  | 1500 |  | gave to [NAME]
2011-12-15 00:00:00 | 1516 | 1029 | 1965 | 2994 |  | 449
2011-12-19 00:00:00 | 3399 | 2995 | 5 | 3000 | 404
2011-12-23 00:00:00 | 2002 | 1216 | 1784 | 3000 | 786
2011-12-24 00:00:00 |  |  |  |  |  | 1000 |  | gave to [NAME]
2011-12-28 00:00:00 | 3132 | 2234 | 766 | 3000 | 898
2011-12-30 00:00:00 |  |  |  |  |  | 1000 |  | gave to [NAME]
 | Machine | Drawer |  |  | Pouch
Date | Total Cash         From Machine | Tickets | Cash | Drawer    Total | To                Pouch | From          Pouch | Pouch           Total | Notes
2012-01-02 00:00:00 | 3059 | 2647 | 353 | 3000 | 412
2012-01-06 00:00:00 |  |  |  |  |  | 180 |  | Repair of ovens next door
2012-01-09 00:00:00 | 4144 | 2887 | 113 |  | 1257
2012-01-09 00:00:00 |  |  |  |  |  | 1000 |  | to [NAME]
2012-01-12 00:00:00 |  |  |  |  |  | 350 |  | To Chad for cleaning
2012-01-13 00:00:00 | 2609 | 2390 | 576 | 2966 | 219
2012-01-14 00:00:00 |  |  |  |  |  | 70 |  | For cleaning [NAME]
2012-01-16 00:00:00 | 1955 | 1122 | 1883 | 3005 | 72
2012-01-17 00:00:00 |  |  |  |  |  | 200 |  | For repair of oven therm
2012-01-18 00:00:00 |  |  |  |  |  | 35 |  | for egg-crate vents in restaurant
2012-01-19 00:00:00 | 1782 | 752 | 2248 | 3000 | 1030
2012-01-21 00:00:00 | 1830 | 1089 | 1911 | 3000 | 841
2012-01-23 00:00:00 |  |  |  |  |  | 325 |  | more repair of oven
2012-01-23 00:00:00 |  |  |  |  |  | 1500 |  | to [NAME]
2012-01-25 00:00:00 | 2160 | 2692 | 299 | 2991 |  | 101 |  | 2500.00 in drawer/ not enough in pouch
2012-01-27 00:00:00 | 853 | 789 | 1711 | 2500 | 64
2012-01-27 00:00:00 |  |  |  |  |  | 120 |  | payment for cleaning
2012-01-27 00:00:00 | 1256 |  |  |  | 1256
2012-01-28 00:00:00 |  |  |  |  |  | 70 |  | final payment to j. evans for cleaning
2012-01-30 00:00:00 | 2169 | 2218 | 282 | 2500 |  | 49
2012-01-30 00:00:00 |  |  |  |  |  | 1000 |  | to [NAME]
2012-02-03 00:00:00 | 2808 | 2319 | 182 | 2501 | 489 |  |  | 100?
2012-02-06 00:00:00 |  |  |  |  |  | 120 |  | Last squares on pool for superbolw.
2012-02-06 00:00:00 | 2136 | 2087 | 403 | 2490 | 49
2012-02-10 00:00:00 | 2710 | 2252 | 248 | 2500 | 458
2012-02-10 00:00:00 |  |  |  |  |  | 250 |  | Money to chad & Rich/
2012-02-13 00:00:00 |  |  |  |  |  | 513 |  | put into drawer. Need to bal machine
2012-02-13 00:00:00 |  |  |  |  | 513 |  |  | Put back into pouch
2012-02-13 00:00:00 | 3919 | 2509 | 504 | 3013 | 1410
2012-02-13 00:00:00 |  |  |  |  |  | 1400 |  | to [NAME]
2012-02-17 00:00:00 | 2562 | 2683 | 17 | 2700 |  | 121
2012-02-20 00:00:00 | 3445 | 2392 | 109 | 2501 | 1053
2012-02-20 00:00:00 |  |  |  |  |  | 1000 |  | To Niki-bullpen
2012-02-22 00:00:00 | 1620 | 2210 | 290 | 2500 |  | 590 |  | tnt refilled machine -
2012-02-24 00:00:00 |  |  |  |  |  | 203 |  | to deposit drawer empty
2012-02-25 00:00:00 |  |  |  |  |  | 410 |  | to drawer from pouch
2012-02-26 00:00:00 | 3460 | 3106 | 111 | 3217 | 354
2012-02-26 00:00:00 |  |  |  |  |  | 980 |  | to atm-
2012-02-28 00:00:00 |  |  |  |  | 980 |  |  | back into pouch from atm
2012-02-29 00:00:00 |  |  |  |  |  | 980 |  | to [NAME]
2012-03-01 00:00:00 |  |  |  |  | 698 |  |  | Pouch adj. - balance not (-615) is 83.00?????
2012-03-01 00:00:00 | 3968 | 2026 | 479 | 2505 | 1463
2012-03-02 00:00:00 | 1422 | 1606 | 894 | 2500 |  | 184
2012-03-02 00:00:00 |  |  |  |  |  | 500 |  | to [NAME]
2012-03-05 00:00:00 | 3500 | 1709 | 792 | 2501 | 1791
2012-03-05 00:00:00 |  |  |  |  |  | 2000 |  | I think to [NAME]????
2012-03-09 00:00:00 | 3884 | 2187 | 293 | 2480 | 1697 |  | 2857
2012-03-09 00:00:00 |  |  |  |  |  | 300 |  | payment to guys for cleaning. [NAME] 1 more.
2012-03-09 00:00:00 |  |  |  |  |  | 1000 |  | to [NAME]
2012-03-12 00:00:00 | 2866 | 3051 | 48 | 3099 |  | 185
2012-03-16 00:00:00 | 1626 | 1590 | 992 | 2582 | 36
2012-03-16 00:00:00 |  |  |  |  |  | 500 |  | to [NAME]
2012-03-16 00:00:00 |  |  |  |  |  | 250 |  | final cleaning payments
2012-03-23 00:00:00 | 2173 | 1960 | 540 | 2500 | 213
2012-03-26 00:00:00 | 2115 | 2038 | 467 | 2505 | 77
2012-03-30 00:00:00 | 2753 | 1783 | 717 | 2500 | 970
2012-03-30 00:00:00 |  |  |  |  |  | 1000 |  | to [NAME]
 | Machine | Drawer |  |  | Pouch
Date | Total Cash         From Machine | Tickets | Cash | Drawer    Total | To                Pouch | From          Pouch | Pouch           Total | Notes
2012-04-04 00:00:00 | 2305 | 1108 | 1200 | 2497 | 1200
 |  |  |  |  |  | 2000 |  | [NAME]
2012-04-06 00:00:00 | 1877 | 2273 | 224 | 2101 |  |  |  | ??????  On vacation
2012-04-07 00:00:00 | 1936 | 1093 | 471 | 1564 |  | 57 |  | new balance 61.00. don’t know prior. KK
2012-04-11 00:00:00 | 3676 | 1739 | 762 | 2501 | 1937
2012-04-13 00:00:00 |  |  |  |  |  | 550 |  | to drawer from pouch
2012-04-13 00:00:00 |  |  |  |  |  | 1448 |  | to drawer from pouch
2012-04-13 00:00:00 | 3174 | 3714 | 667 | 4381 | 1341
2012-04-14 00:00:00 | 2047 | 1089 | 1411 | 2500 | 958
2012-04-14 00:00:00 |  |  |  |  |  | 1300
2012-04-18 00:00:00 | 2250 | 2362 | 138 | 2500 |  | 112
2012-04-20 00:00:00 | 2401 | 1994 | 505 | 2499 | 407
2012-04-23 00:00:00 | 2736 | 2218 | 281 | 2499 | 518 |  |  | $416 short  only 1396
 |  |  |  |  |  | 200 |  | change for solo cup weekend/side envelope | [NAME] took env. With 150. put 50 in qtrs in drawer 4-26
 |  |  |  |  |  | 200 |  | advance for james 200 weekend of 27 28
 |  |  |  |  |  | 1396 |  | [NAME]
2012-04-26 00:00:00 | 1062 | 4385 | 332 | 4717 | 0 | 0 |  | tickets left from mon. Dean-1062 into drawer | 50 in qtrs put into drawer. [NAME] replenished drawer.
2012-04-26 00:00:00 |  |  |  |  | 200 |  |  | back to pouch from [NAME]
2012-04-30 00:00:00 | 731 | 326 | 2144 | 2470 | 375
2012-04-30 00:00:00 |  |  |  |  |  | 500 |  | to dean
 | Machine | Drawer |  |  | Pouch
Date | Total Cash         From Machine | Tickets | Cash | Drawer    Total | To                Pouch | From          Pouch | Pouch           Total | Notes
2012-05-03 00:00:00 | 3023 | 2423 | 86 | 2509 | 600
2012-05-04 00:00:00 | 1922 | 2150 | 349 | 2499 |  | 228 |  | 454 BALANCE
2012-05-05 00:00:00 | 1888 | 1554 | 946 | 2500 | 733 |  |  | I messed up at close counting machine $
2012-05-07 00:00:00 |  |  |  |  |  | 700 |  | to [NAME]
2012-05-09 00:00:00 | 3198 | 1397 | 1300 | 2697 | 1800 |  |  | drawer was 197 over ????? That corrects bal. | [NAME] took money from change but that was corrct also
2012-05-09 00:00:00 |  |  |  |  | 203 |  |  | balance correction ??????
2012-05-09 00:00:00 |  |  |  |  |  | 1500
2012-05-11 00:00:00 | 1746 | 2663 | 87 | 2750 |  | 917 |  | replaced 250 into change box --Jen 5-10
2012-05-14 00:00:00 | 2474 | 1813 | 387 | 2200 | 661
2012-05-15 00:00:00 |  |  |  |  |  | 600 |  | 600 from pouch into drawer
2012-05-19 00:00:00 | 3292 | 1938 | 613 | 2551 | 1354
2012-05-19 00:00:00 |  |  |  |  |  | 600 |  | pouch bal 43 short????
2012-05-21 00:00:00 |  |  |  |  |  | 940 |  | to niko
2012-05-22 00:00:00 | 2638 | 2499 | 21 | 2520 | 139
2012-05-29 00:00:00 | 3019 | 1956 | 541 | 2497 | 1063
2012-05-29 00:00:00 |  |  |  |  |  | 1000 |  | to [NAME]
 | Machine | Drawer |  |  | Pouch
Date | Total Cash         From Machine | Tickets | Cash | Drawer    Total | To                Pouch | From          Pouch | Pouch           Total | Notes
2012-06-01 00:00:00 | 3509 | 2236 | 254 | 2490 | 1273
2012-06-04 00:00:00 |  |  |  |  |  | 1000 |  | envelope in safe
2012-06-04 00:00:00 | 2713 | 2401 | 99 | 2500 | 312
2012-06-07 00:00:00 | 2093 | 2066 | 434 | 2500 | 27
2012-06-11 00:00:00 | 3452 | 1827 | 673 | 2500 | 1625
2012-06-11 00:00:00 |  |  |  |  |  | 2000
2012-06-13 00:00:00 | 2239 |  | 357 | 2380 | 96 |  | 804
2012-06-13 00:00:00 |  |  |  |  |  | 500 | 304 | to niko 500
2012-06-15 00:00:00 | 1003 | 1791 | 589 | 1592
2012-06-18 00:00:00 | 2976 | 1592 | 0 | 2490 | 486 |  | 780
2012-06-20 00:00:00 | 2482 | 1304 | 1103 | 2500 | 1085 |  | 1865
 |  |  |  |  |  | 865 | 1000 | to niko 865
2012-06-22 00:00:00 | 1169 | 837 | 1663 | 2500 | 332 |  | 1332 | 1902 from drawer and 293 from bag to set @ $2500
2012-06-23 00:00:00 | 1902 | 2195 | 305 |  | 0 | 293
2012-06-25 00:00:00 | 774 | 386 | 2114 | 2114 | 774 |  | 1813
 |  |  |  |  |  |  | 1000 | Niko 813
2012-06-27 00:00:00 | 1847 | 1857
2012-06-27 00:00:00 |  | 0 | 2500 |  |  | 399 |  | JM
2012-07-02 00:00:00 | 2505 | 1838 | 649 | 2500 | 654 |  | 1000
2012-07-06 00:00:00 |  | 2125 | 391 |  |  |  |  | over $11
2012-07-06 00:00:00 | 3984 | 0 | 2500 |  | 1875 |  |  | JM
2012-07-06 00:00:00 |  |  |  |  |  | 1850 |  | [NAME]
2012-07-07 00:00:00 |  | 2316 | 184 |  |  |  |  | JM
2012-07-07 00:00:00 | 2515 | 0 | 2500 |  | 199 |  |  | JM
2012-07-09 00:00:00 |  | 2449 | 53 |  |  |  |  | over $2
2012-07-09 00:00:00 | 3408 | 0 | 2500 |  | 961 |  |  | JM