Spreadsheet: 114845d1310553018-count-totals-by-week-and-month-from-separate-worksheet-big-pnl-sample
Sheet: Daily Sales

 | CASH | VISA | MASTERCARD | AMEX | CARDS | UNSETTLED | VVIP | VVIP OCUS | CLOAKROOM | TICKETS | ENT Staff | ENT DJ | ENT Mgr | ENT Flr Mgr | [NAME] | [NAME] | ENT PR | ENT XTRVG | ENTs TOTAL | WASTE | NET BAR | TOTAL NET | GRAND BAR | GRAND TOTAL
1.01 | 3027 | 3750 | 930 | 2070 |  | 0 | 512 | 1197 | 0 | 0 | 1575 | 130 | 425 | 75 | 4495 | 0 | 2275 | 0 |  | 0
2.01 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
3.01 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
4.01 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 410 | 0 | 0 | 0 | 150 | 0 | 50 | 0 |  | 0
5.01 | 939 | 2680 | 2000 | 500 |  | 0 | 660 | 0 | 0 | 0 | 880 | 0 | 1125 | 150 | 1235 | 150 | 0 | 0 |  | 0
6.01 | 2826 | 5276 | 270 | 6426 |  | 0 | 0 | 4644 | 0 | 0 | 1665 | 80 | 630 | 205 | 1405 | 80 | 1235 | 0 |  | 0
7.01 | 26352 | 21409 | 11721 | 21298 |  | 10511 | 0 | 0 | 0 | 0 | 2520 | 580 | 3710 | 220 | 3795 | 800 | 1900 | 0 |  | 590
8.01 | 29166 | 32782 | 11998 | 22362 |  | 20680 | 0 | 0 | 0 | 0 | 3240 | 935 | 1195 | 250 | 4630 | 345 | 1960 | 0 |  | 0
9.01 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
10.01
11.01
12.01
13.01
14.01
15.01
16.01
17.01
18.01
19.01
20.01
21.01
22.01
23.01
24.01
25.01
26.01
27.01
28.01
29.01
30.01
31.01
1.02
2.02
3.02
4.02
5.02
6.02
7.02
8.02
9.02
10.02
11.02
12.02
13.02
14.02
15.02
16.02
17.02
18.02
19.02
20.02
21.02
22.02
23.02
24.02
25.02
26.02
27.02
28.02
1.03
2.03
3.03
4.03
5.03
6.03
7.03
8.03
9.03
10.03
11.03
12.03
13.03
14.03
15.03
16.03
17.03
18.03
19.03
20.03
21.03
22.03
23.03
24.03
25.03
26.03
27.03
28.03
29.03
30.03
31.03
1.04
2.04
3.04
4.04
5.04
6.04
7.04
8.04
9.04
10.04
11.04
12.04
13.04
14.04
15.04
16.04
17.04
18.04
19.04
20.04
21.04
22.04
23.04
24.04
25.04
26.04
27.04
28.04
29.04
30.04
1.05
2.05
3.05
4.05
5.05
6.05
7.05
8.05
9.05
10.05
11.05
12.05
13.05
14.05
15.05
16.05
17.05
18.05
19.05
20.05
21.05
22.05
23.05
24.05
25.05
26.05
27.05
28.05
29.05
30.05
31.05
1.06
2.06
3.06
4.06
5.06
6.06
7.06
8.06
9.06
10.06
11.06
12.06
13.06
14.06
15.06
16.06
17.06
18.06
19.06
20.06
21.06
22.06
23.06
24.06
25.06
26.06
27.06 | 89 | 0 | 0 | 132 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
28.06
29.06
30.06
1.07
2.07 | 28910 | 23360 | 9992 | 31622 |  | 0 | 7497 | 168 | 280 | 12450 | 2735 | 410 | 1325 | 1435 | 4480 | 936 | 10895 | 0
3.07
4.07 | 442
5.07
6.07
7.07 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CORRECT FORMULA NETS
8.07 | 27358 | 17743 | 13418 | 44049 |  | 0 | 9257 | 5201 | 220
9.07
10.07
11.07
12.07
13.07
14.07
15.07
16.07
17.07
18.07
19.07
20.07
21.07
22.07
23.07
24.07
25.07
26.07
27.07
28.07
29.07
30.07
31.07
1.08
2.08
3.08
4.08
5.08
6.08
7.08
8.08
9.08
10.08
11.08
12.08
13.08
14.08
15.08
16.08
17.08
18.08
19.08
20.08
21.08
22.08
23.08
24.08
25.08
26.08
27.08
28.08
29.08
30.08
31.08
1.09
2.09
3.09
4.09
5.09
6.09
7.09
8.09
9.09
10.09
11.09
12.09
13.09
14.09
15.09
16.09
17.09
18.09
19.09
20.09
21.09
22.09
23.09
24.09
25.09
26.09
27.09
28.09
29.09
30.09
1.1
2.1
3.1
4.1
5.1
6.1
7.1
8.1
9.1
10.1
11.1
12.1
13.1
14.1
15.1
16.1
17.1
18.1
19.1
20.1
21.1
22.1
23.1
24.1
25.1
26.1
27.1
28.1
29.1
30.1
31.1
1.11
2.11
3.11
4.11
5.11
6.11
7.11
8.11
9.11
10.11
11.11
12.11
13.11
14.11
15.11
16.11
17.11
18.11
19.11
20.11
21.11
22.11
23.11
24.11
25.11
26.11
27.11
28.11
29.11
30.11
1.12
2.12
3.12
4.12
5.12
6.12
7.12
8.12
9.12
10.12
11.12
12.12
13.12
14.12
15.12
16.12
17.12
18.12
19.12
20.12
21.12
22.12
23.12
24.12
25.12
26.12
27.12
28.12
29.12
30.12
31.12
1.01
2.01
3.01
4.01
5.01
6.01
7.01
8.01
9.01
10.01
11.01
12.01
13.01
14.01
15.01
16.01
17.01
18.01
19.01
20.01
21.01
22.01
23.01
24.01
25.01
26.01
27.01
28.01
29.01
30.01
31.01
TYPE | CASH | VISA | MASTERCARD | AMEX | CARDS | UNSETTLED | VVIP | VVIP OCUS | CLOAKROOM | TICKETS | ENT Staff | ENT DJ | ENT Mgr | ENT Flr Mgr | [NAME] | [NAME] | ENT PR | ENT XTRVG | ENTs TOTAL |  | NET BAR | TOTAL NET | GRAND BAR | GRAND TOTAL