Spreadsheet: 565600d1521037042-balance-lottery-sales-swift-101-daily-report
Sheet: 1

Scrath Off sales Straigh way |  |  |  |  |  |  |  |  |  |  |  |  |  | Scrath Off sales Opposite way
Box | $ | Tickets | Open | End | Sale |  | Box | $ | Tickets | Open | End | Sale |  | Box | $ | End | Total |  | Box | $ | End | Total
1 | 5 | 75 | 1 | 25 |  |  | 34 |  |  |  |  |  |  | 1 | 5 | 5 |  |  | 34
2 | 1 | 125 | 5 | 4 |  |  | 35 |  |  |  |  |  |  | 2 | 5 | 6 |  |  | 35
3 |  |  |  |  |  |  | 36 |  |  |  |  |  |  | 3 | 5 | 30 |  |  | 36
4 |  |  |  |  |  |  | 37 |  |  |  |  |  |  | 4 | 5 | 25 |  |  | 37
5 |  |  |  |  |  |  | 38 |  |  |  |  |  |  | 5 |  |  |  |  | 38
6 |  |  |  |  |  |  | 39 |  |  |  |  |  |  | 6 |  |  |  |  | 39
7 |  |  |  |  |  |  | 40 |  |  |  |  |  |  | 7 |  |  |  |  | 40
8 |  |  |  |  |  |  | 41 |  |  |  |  |  |  | 8 |  |  |  |  | 41
9 |  |  |  |  |  |  | 42 |  |  |  |  |  |  | 9 |  |  |  |  | 42
10 |  |  |  |  |  |  | 43 |  |  |  |  |  |  | 10 |  |  |  |  | 43
11 |  |  |  |  |  |  | 44 |  |  |  |  |  |  | 11 |  |  |  |  | 44
12 |  |  |  |  |  |  | 45 |  |  |  |  |  |  | 12 |  |  |  |  | 45
13 |  |  |  |  |  |  | 46 |  |  |  |  |  |  | 13 |  |  |  |  | 46
15 |  |  |  |  |  |  | 47 |  |  |  |  |  |  | 15 |  |  |  |  | 47
16 |  |  |  |  |  |  | 48 |  |  |  |  |  |  | 16 |  |  |  |  | 48
17 |  |  |  |  |  |  | 49 |  |  |  |  |  |  | 17 |  |  |  |  | 49
18 |  |  |  |  |  |  | 50 |  |  |  |  |  |  | 18 |  |  |  |  | 50
19 |  |  |  |  |  |  | 51 |  |  |  |  |  |  | 19 |  |  |  |  | 51
20 |  |  |  |  |  |  | 52 |  |  |  |  |  |  | 20 |  |  |  |  | 52
21 |  |  |  |  |  |  | 53 |  |  |  |  |  |  | 21 |  |  |  |  | 53
22 |  |  |  |  |  |  | 54 |  |  |  |  |  |  | 22 |  |  |  |  | 54
23 |  |  |  |  |  |  | 55 |  |  |  |  |  |  | 23 |  |  |  |  | 55
24 |  |  |  |  |  |  | 56 |  |  |  |  |  |  | 24 |  |  |  |  | 56
25 |  |  |  |  |  |  | 57 |  |  |  |  |  |  | 25 |  |  |  |  | 57
26 |  |  |  |  |  |  | 58 |  |  |  |  |  |  | 26 |  |  |  |  | 58
27 |  |  |  |  |  |  | 59 |  |  |  |  |  |  | 27 |  |  |  |  | 59
28 |  |  |  |  |  |  | 60 |  |  |  |  |  |  | 28 |  |  |  |  | 60
29 |  |  |  |  |  |  |  |  | Total Scratch Off Sales |  |  |  |  | 29 |  |  |  |  | Total Inventory
30 |  |  |  |  |  |  |  |  | Online Lotto Sales |  |  | 100 |  | 30
31 |  |  |  |  |  |  |  |  | Total Sales |  |  |  |  | 31 |  |  |  |  | opening inventory |  |  | 600
32 |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 |  |  |  |  | Added-returned Inventory |  |  | 250
33 |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 |  |  |  |  | Total Online lotto Net Sales |  |  | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Sale
I am just intending to help others if don’t like it just trash it but don’t blame me and if you find error and know how to fix it then please fix and help others and me too LOL
total wining amount paid totals,total online sold,total adjustment all this we can get from machine report , atleast in texas
online sales means from the machine you sold examle mega million or powerball
Please Lock The Cells After You modify
Straigh Way Rules
As You Can see you can not put new pack at same day after you sold out the ticket  from same slot or box
tickets mens total number of tickets in the pack
conditional formating is used as you can see if the value is ? Or nagative the cell turn in red
opposite way rules
it is basicaly counting your inventory and at the end of the day it minus from previous day inventory
if you have added or returned some of the tickets from boxes and games which are in curruntly selling then you can write total figure to add in for sales counting
you don’t have to count online net sales in total sales if you don’t want to