Spreadsheet: 193442d1352833071-could-anyone-help-me-simplify-a-very-long-and-drawn-out-process-ef263_october-sales-analysis-revised
Sheet: month_summary

 | Select MONTH: | 10
 | Select YEAR: | 2012
 | AB |  |  |  |  |  | SK |  |  |  |  |  | WP
Day | # of invoices | Daily total | Daily gross profit | Avg. $/trans |  | Day | # of invoices | Daily total | Daily gross profit | Avg. $/trans |  | Day | # of invoices | Daily total | Daily gross profit | Avg. $/trans
28
29
30
31
1 |  |  |  |  |  | 1 |  |  |  |  |  | 1
2 |  |  |  |  |  | 2 |  |  |  |  |  | 2
3 |  |  |  |  |  | 3 |  |  |  |  |  | 3
4 |  |  |  |  |  | 4 |  |  |  |  |  | 4
5 |  |  |  |  |  | 5 |  |  |  |  |  | 5
6 |  |  |  |  |  | 6 |  |  |  |  |  | 6
7 |  |  |  |  |  | 7 |  |  |  |  |  | 7
8 |  |  |  |  |  | 8 |  |  |  |  |  | 8
9 |  |  |  |  |  | 9 |  |  |  |  |  | 9
10 |  |  |  |  |  | 10 |  |  |  |  |  | 10
11 |  |  |  |  |  | 11 |  |  |  |  |  | 11
12 |  |  |  |  |  | 12 |  |  |  |  |  | 12
13 |  |  |  |  |  | 13 |  |  |  |  |  | 13
14 |  |  |  |  |  | 14 |  |  |  |  |  | 14
15 |  |  |  |  |  | 15 |  |  |  |  |  | 15
16 |  |  |  |  |  | 16 |  |  |  |  |  | 16
17 |  |  |  |  |  | 17 |  |  |  |  |  | 17
18 |  |  |  |  |  | 18 |  |  |  |  |  | 18
19 |  |  |  |  |  | 19 |  |  |  |  |  | 19
20 |  |  |  |  |  | 20 |  |  |  |  |  | 20
21 |  |  |  |  |  | 21 |  |  |  |  |  | 21
22 |  |  |  |  |  | 22 |  |  |  |  |  | 22
23 |  |  |  |  |  | 23 |  |  |  |  |  | 23
24 |  |  |  |  |  | 24 |  |  |  |  |  | 24
25 |  |  |  |  |  | 25 |  |  |  |  |  | 25
26 |  |  |  |  |  | 26 |  |  |  |  |  | 26
27 |  |  |  |  |  | 27 |  |  |  |  |  | 27
 |  |  |  | MONTHLY | invoices
 |  |  |  | MONTHLY | total
 |  |  |  | MONTHLY | profit
 |  |  |  | MONTHLY | average
 | 34 | 6536.42 | 18897.26 | 555.8017647058824
 | 16 | 5646.34 | 20124.89 | 1257.805625
 | 23 | 4056.41 | 12479.72 | 542.5965217391305
 | 23 | 4112.86 | 12015.82 | 522.4269565217392
 | 20 | 4154.1 | 11719.94 | 585.9970000000001
 | 23 | 9824.51 | 29438.95 | 1279.954347826087
 | 18 | 2895.34 | 9135.7 | 507.5388888888889
 | 35 | 15389.61 | 50297.35999999999 | 1437.067428571428
 | 34 | 19102.99 | 56950 | 1675
 | 35 | 10986.31 | 42836.64000000001 | 1223.904
 | 16 | 5903.679999999999 | 18497.4 | 1156.0875
 | 26 | 9719.400000000001 | 31819 | 1223.807692307692
 | 9 | 2260.53 | 5863.93 | 651.5477777777778
 | 22 | 3832.78 | 10303.04 | 468.3200000000001
 | 41 | -1440.4 | 4823.819999999999 | 117.6541463414634
 | 12 | 18757.31 | 75800.04000000001 | 6316.670000000001
 | 12 | 13876.32 | 52315.43 | 4359.619166666666
 | 15 | 2677.06 | 9839.99 | 655.9993333333333
 | 10 | 1304.1 | 4286.03 | 428.603
 | 8 | 977.8 | 3138.38 | 392.2975
 | 8 | 9705.75 | 44126.3 | 5515.787499999999
 | 8 | 402.23 | 1187.77 | 148.47125
 | 4 | 713.3599999999999 | 2260 | 564.9999999999999
 | 7 | 717.6800000000001 | 2344.1 | 334.8714285714286
 | 6 | 1060.85 | 3694.46 | 615.7433333333332
 | 9 | 2892.94 | 10497.39 | 1166.376666666667
 | 7 | 19236.75 | 81470.92 | 11638.70285714286
 | 4 | 634.66 | 2653.38 | 663.345
 | 12 | 4966.74 | 19018.77 | 1584.8975
 | 6 | 768.21 | 2379.13 | 396.5216666666667
 | 7 | 3078.28 | 12638.18 | 1805.454285714286
 | 5 | 3088.55 | 8043.41 | 1608.682
 | 11 | 5176.95 | 15935.77 | 1448.706363636364
 | 10 | 1761.76 | 6386.43 | 638.643
 | 1 | -1195 | -1395 | -1395
 | 22 | -1503.009619047617 | 23658.36 | 1075.38
 | 13 | 3516.26 | 16673.44 | 1282.572307692308
 | 19 | 6398.999999999999 | 19935.61 | 1049.242631578947
 | 11 | 1811.19 | 7558.29 | 687.1172727272727
 | 13 | 5412.72 | 23791.42 | 1830.109230769231
 | 14 | 4021.37 | 9657.35 | 689.8107142857143
 | 10 | 2617.29 | 10500.75 | 1050.075
 | 12 | 2429.46 | 9167.03 | 763.9191666666667
 | 12 | 6627.559999999999 | 23176.92 | 1931.41
 | 27 | 10938.38 | 49406.37 | 1829.865555555555
 | 8 | 2299.4 | 7946.950000000001 | 993.3687500000001
 | 18 | 14402.72 | 35944.02999999999 | 1996.890555555555
 | 22 | 14798.23 | 61510.94 | 2795.951818181818
 | 14 | 17076 | 53462.35 | 3818.739285714285
 | 10 | 493.5799999999999 | 199.9500000000007 | 19.99500000000007
 | 3 | 703.11 | 1830.94 | 610.3133333333333
 | 13 | 3672.44 | 19921.35 | 1532.411538461538
 | 12 | 36718.36 | 95487.57 | 7957.297500000001
 | 10 | 3986.76 | 33305.73 | 3330.572999999999
 | 1 | -2119.69 | -8209.6 | -8209.6
 | 1 | -294000 | -323904 | -323904