Spreadsheet: 149874d1334169450-excel-2007-copy-and-sum-specified-cells-to-another-worksheet-if-date-cell-is-between-date-range-2011-case-statistics
Sheet: Sheet1

Quantities | B/Book | Date IN | Store no. |  | Judge /     Pvt Agmnt - Date | Destruction Date | Billings        Date Sent | Billings Amount €uro | Payment Entered @ A/c Date | BANK |  | Official [NAME] |  | HAULAGE | VACIS | FTM workers | RENT
11964 | 57/11 | 2011-02-23 00:00:00 | MV 09 |  | 19/05/2011 | 2011-08-24 00:00:00 | 2011-08-25 00:00:00 | 1591.6 | 2011-11-03 00:00:00 | Lombard |  | B280770 | closed
2085 | 54/11 | 2011-02-14 00:00:00 | NP 05 |  | 08/07/2011 | 2011-08-04 00:00:00 | 2011-08-08 00:00:00 | 414.65 | 2011-10-03 00:00:00 | Lombard |  | B280760 | closed
3225 | 54/11 | 2011-02-14 00:00:00 | NP 05 |  | 19/05/2011 | 2011-08-17 00:00:00 | 2011-08-18 00:00:00 | 700.93 | 2011-10-25 00:00:00 | Lombard |  | B280769 | closed
13380 | 51/11 | 2011-02-14 00:00:00 | NP 07 |  | 2011-07-08 00:00:00 | 2011-08-17 00:00:00 | 2011-08-18 00:00:00 | 2320.04 | 2011-10-25 00:00:00 | Lombard |  | B280769 | closed
5670 | 54/11 | 2012-02-14 00:00:00 | NP 05 |  | 2011-10-12 00:00:00 | 2012-01-23 00:00:00 | 2012-01-24 00:00:00 | 1764.11 | 2012-03-28 00:00:00 | BoV |  | B281401 | closed | 378 | 12.72 | 77.47 | 1295.92
886 | 58/11 | 2011-02-23 00:00:00 | MV 09 |  | 2011-06-02 00:00:00 | 2011-08-03 00:00:00 | 2011-08-04 00:00:00 | 356.33 | 2011-09-29 00:00:00 | Lombard |  | B280755 | Closed
1517 | 58/11 | 2011-02-23 00:00:00 | MV 09 |  | 2011-05-19 00:00:00 | 2011-06-16 00:00:00 | 2011-07-18 00:00:00 | 855.25 | 2011-12-09 00:00:00 | Lombard |  | B280778 | closed
264 | 58/11 | 2011-02-23 00:00:00 | MV 09 |  | 2011-10-13 00:00:00 | 2012-02-16 00:00:00 | 2012-01-23 00:00:00 | 135.62 | 2012-03-28 00:00:00 | BoV |  | B281401 | closed | 30.98 | 1.46 | 18.64 | 84.54
 | 68/11 | 2011-03-08 00:00:00 | NP 20 |  | 2011-06-02 00:00:00 | 2011-08-04 00:00:00 | 2011-08-08 00:00:00 | 274.15 | 2011-10-03 00:00:00 | Lombard |  | B280760 | closed
 | 68/11 | 2011-03-08 00:00:00 | NP 20 |  | 2011-05-19 00:00:00 | 2011-08-25 00:00:00 | 2011-08-29 00:00:00 | 2323.38 | 2011-11-10 00:00:00 | Lombard |  | B280771 | closed
6912 | 67/11 | 2011-03-04 00:00:00 | MV 02 |  | 2011-06-15 00:00:00 | 2011-09-15 00:00:00 | 2011-09-19 00:00:00 | 37.14 | 2011-09-29 00:00:00 | HSBC |  | B280759 | Closed
3504  66000  7680 | 67/11 | 2011-03-04 00:00:00 | MV 02 |  | 2011-06-30 00:00:00 | 2011-09-01 00:00:00 | 2011-09-12 00:00:00 | 993.86 | 2011-10-18 00:00:00 | BoV |  | [NAME] | Closed
64800  136500 | 67/11 | 2011-03-04 00:00:00 | MV 02 |  | 2011-06-15 00:00:00 | 2011-10-27 00:00:00 | 2011-10-28 00:00:00 | 1136.88 | 2011-11-15 00:00:00 | HSBC |  | B280775 | Closed
14400 | 67/11 | 2011-03-04 00:00:00 | MV 02 |  | 2011-10-12 00:00:00 | 2012-01-16 00:00:00 | 2012-01-23 00:00:00 | 415.26
5000 | 104/11 | 2011-04-20 00:00:00 | NP 05 |  | 2011-10-12 00:00:00 | 2011-12-07 00:00:00 | 2011-12-15 00:00:00 | 852.53 | 2012-02-23 00:00:00 | Lombard |  | B281173 | closed | 268 | 12.6 | 81 | 490.93
4500 | 104/11 | 2011-04-20 00:00:00 | NP 05 |  | 2011-12-12 00:00:00 | 2012-01-23 00:00:00 | 2012-01-24 00:00:00 | 767.22 | 2012-03-28 00:00:00 | BoV |  | B281401 | Closed | 228 | 10.7 | 69 | 459.52
1000 | 137/11 | 2011-07-27 00:00:00 | MV 03 |  | 2011-05-06 00:00:00 | 2011-07-27 00:00:00 | 2011-08-01 00:00:00 | 80.84 | 2011-08-16 00:00:00 | HSBC |  | B33351 | Closed
1800 | 137/11 | 2011-07-27 00:00:00 | MV 03 |  | 2011-05-06 00:00:00 | 2011-07-27 00:00:00 | 2011-08-01 00:00:00 | 80.84 | 2011-08-24 00:00:00 | HSBC |  | B33358 | Closed
215 | 137/11 | 2011-07-27 00:00:00 | MV 03 |  | 2011-05-06 00:00:00 | 2011-07-27 00:00:00 | 2011-08-01 00:00:00 | 40.85 | 2011-09-01 00:00:00 | HSBC |  | B33367 | Closed
150 | 137/11 | 2011-07-27 00:00:00 | MV 03 |  | 2011-05-06 00:00:00 | 2011-07-27 00:00:00 | 2011-08-01 00:00:00 | 40.85 | 2011-09-01 00:00:00 | HSBC |  | B33366 | Closed
432 | 137/11 | 2011-06-01 00:00:00 | MV 03 |  | 2011-05-10 00:00:00 | 2011-06-01 00:00:00 | 2011-08-01 00:00:00 | 163.41 | 2011-10-25 00:00:00 | Lombard |  | B280769 | closed
2420 | 137/11 | 2011-07-27 00:00:00 | MV 03 |  | 2011-04-27 00:00:00 | 2011-07-27 00:00:00 | 2011-09-23 00:00:00 | 204.26 | 2012-01-23 00:00:00 | BoV |  | B280789 | closed | 123.9 | 5.82 | 74.54 | 204.26
1192 | 137/11 | 2012-01-01 00:00:00 | MV 03 |  | 2011-05-04 00:00:00 | 2011-06-01 00:00:00 | 2011-08-01 00:00:00 | 163.41 | 2012-03-28 00:00:00 | Lombard |  | B281402 | closed | 99.12 | 4.66 | 59.63 | 163.41
500 | 137/11 | 2011-07-27 00:00:00 | MV 03 |  | 2011-05-06 00:00:00 | 2011-07-27 00:00:00 | 2011-08-01 00:00:00 | 40.85
34150 | 133/11 | 2011-05-26 00:00:00 | MV 09 |  | 2011-10-17 00:00:00 | 2012-01-16 00:00:00 | 2012-01-23 00:00:00 | 1932.72
92050 | 133/11 | 2011-05-26 00:00:00 | MV 09 |  | 2011-10-17 00:00:00 | 2012-01-16 00:00:00 | 2012-01-23 00:00:00 | 966.65
800 | 133/11 | 2011-05-26 00:00:00 | MV 09 |  | 2011-10-17 00:00:00 | 2012-01-16 00:00:00 | 2012-01-23 00:00:00 | 191.6
14620 | 131/11 | 2011-05-19 00:00:00 | NP 05 |  | 2011-10-12 00:00:00 | 2011-12-01 00:00:00 | 2011-12-02 00:00:00 | 2094.89 | 2012-02-15 00:00:00 | Lombard |  | B280799 | closed | 802 | 18.25 | 117.57 | 1157.07
3040 | 131/11 | 2011-05-19 00:00:00 | NP 05 |  | 2011-10-12 00:00:00 | 2012-02-07 00:00:00 | 2012-02-08 00:00:00 | 696.06 |  | HSBC
29 ctns | 142/11 | 2011-06-06 00:00:00 | MV 03 |  | 2011-05-13 00:00:00 | 2011-08-25 00:00:00 | 2011-08-29 00:00:00 | 397.77 | 2012-01-11 00:00:00 | Lombard |  | B280784 | Closed | 206.5 | 23.3 | 149.08 | 18.89
360 | 136/11 | 2011-06-01 00:00:00 | MV 03 |  | 2011-11-23 00:00:00 | 2012-01-12 00:00:00 | 2012-01-23 00:00:00 | 441.25 | 2012-02-09 00:00:00 | HSBC |  | B280797 | Closed | 247.8 | 11.65 | 75.54 | 106.26
432 | 136/11 | 2011-06-01 00:00:00 | MV 03 |  | 2011-06-18 00:00:00 | 2012-01-12 00:00:00 | 2012-01-23 00:00:00 | 441.25 | 2012-03-28 00:00:00 | BoV |  | B281401 | Closed | 248 | 11.65 | 75.54 | 106.26
7140 | 143/11 | 2011-06-08 00:00:00 | NP 20 |  | 2011-11-16 00:00:00 | 2012-02-16 00:00:00 | 2012-02-21 00:00:00 | 1457.02
8600 | 143/11 | 2011-06-08 00:00:00 | NP 20 |  | 2011-10-12 00:00:00 | 2012-02-16 00:00:00 | 2012-02-21 00:00:00 | 485.01
5840 | 143/11 | 2011-06-08 00:00:00 | NP 20 |  | 04/10/211 | 2012-02-17 00:00:00 | 2012-02-21 00:00:00 | 1169.55
130 | 164/11 | 2011-07-18 00:00:00 | MV03 |  |  | 2011-08-11 00:00:00 | 2011-09-23 00:00:00 | 838.32 | 2012-01-23 00:00:00 | BoV |  | [NAME] | Closed | 609.67 | 19.41 | 124.23 | 85.01
4 | 164/11 | 2011-07-18 00:00:00 | MV03 |  |  | 2012-01-16 00:00:00 | 2012-01-18 00:00:00 | 120.75
13 | 164/11 | 2011-07-18 00:00:00 | MV03 |  |  | 2012-01-16 00:00:00 | 2012-01-18 00:00:00 | 60.36
1350 | 144/11 | 2011-06-13 00:00:00 | NP 17 |  | 2011-11-01 00:00:00 | 2011-12-02 00:00:00 | 2011-12-05 00:00:00 | 150.03 | 2012-02-14 00:00:00 | Lombard |  | B280798 | Closed | 59.48 | 0 | 9.32 | 81.23
3250 | 144/11 | 2011-06-13 00:00:00 | NP 17 |  | 2011-10-12 00:00:00 | 2011-12-07 00:00:00 | 2011-12-15 00:00:00 | 456.73 | 2012-02-23 00:00:00 | Lombard |  | B281173 | closed | 172 | 6 | 27.95 | 250.78
12930 | 144/11 | 2011-06-13 00:00:00 | NP 17 |  | 2011-10-24 00:00:00
1830 | 144/11 | 2011-06-13 00:00:00 | NP 17 |  | 2011-10-04 00:00:00 | 2012-02-16 00:00:00 | 2012-02-21 00:00:00 | 270.3
12000 | 154/11 | 2011-06-22 00:00:00 | NP 17 |  | 2011-11-01 00:00:00 | 2011-12-02 00:00:00 | 2011-12-05 00:00:00 | 1461.23 | 2012-02-23 00:00:00 | Lombard |  | B281173 | closed | 673 | 23.3 | 149.08 | 615.85
12000 | 154/11 | 2011-06-22 00:00:00 | NP 17 |  | 2011-11-01 00:00:00 | 2011-12-02 00:00:00 | 2011-12-05 00:00:00 | 1461.23 | 2012-02-23 00:00:00 | Lombard |  | B281173 | closed | 673 | 23.3 | 149.08 | 615.85
40416 | 147/11 | 2011-06-16 00:00:00 | NP 17 |  | 2011-10-12 00:00:00 | 2011-02-08 00:00:00 | 2012-02-08 00:00:00 | 2872.24 |  | HSBC
26020 | 163/11 | 2011-07-13 00:00:00 | MV 06 |  | 2011-10-04 00:00:00 | 2011-12-04 00:00:00 | 2011-12-06 00:00:00 | 2226.75 | 2012-01-26 00:00:00 | HSBC |  | B280796 | closed | 732 | 23.3 | 149.08 | 1322.37
47652 | 174/11 | 2011-07-27 00:00:00 | MV 03 |  | 2011-11-16 00:00:00 | 2012-02-14 00:00:00 | 2012-02-16 00:00:00 | 1615.72 | 2012-03-07 00:00:00 | HSBC |  | B281178 | closed | 672.6 | 23.29 | 149.08 | 770.75
720 | 186/11 | 2011-08-10 00:00:00 | MV 09 |  | 2011-11-16 00:00:00 | 2012-02-17 00:00:00 | 2012-02-21 00:00:00 | 636.29
252 | 186/11 | 2011-08-10 00:00:00 | MV 09 |  | 2011-11-16 00:00:00
240 | 186/11 | 2011-08-10 00:00:00 | MV 09 |  | No Action | No Action | No Action | No Action
12600 | 171/11 | 2011-07-25 00:00:00 | MV 09 |  | 2011-10-26 00:00:00 | 2011-12-09 00:00:00 | 2011-12-12 00:00:00 | 1226.59 | 2012-02-14 00:00:00 | Lombard |  | B280798 | Closed | 528 | 13.5 | 86.6 | 1226.59
6300 | 171/11 | 2011-07-25 00:00:00 | MV 09 |  | 2011-10-26 00:00:00 | 2012-02-17 00:00:00 | 2012-02-21 00:00:00 | 816.64
2400 | 171/11 | 2011-07-25 00:00:00 | MV 09 |  | 2011-10-19 00:00:00
6380 | 190/11 | 2011-08-16 00:00:00 | NP 20 |  | 2011-11-30 00:00:00 | 2012-02-16 00:00:00 | 2012-02-21 00:00:00 | 1197.05
3560 | 190/11 | 2011-08-16 00:00:00 | NP 20 |  | 2011-11-16 00:00:00 | 2012-02-16 00:00:00 | 2012-02-21 00:00:00 | 658.47
3260 | 190/11 | 2011-08-16 00:00:00 | NP 20
210 | 190/11 | 2011-08-16 00:00:00 | NP 14 Auction Sales
46000 | 190/11 | 2011-08-16 00:00:00 | NP 14 Auction Sales
1152 | 197/11 | 2011-08-29 00:00:00 | MV 03
10800 | 197/11 | 2011-08-29 00:00:00 | MV 03 |  | 2011-11-16 00:00:00 | 2012-02-03 00:00:00 | 2012-02-07 00:00:00 | 292.7 | 2012-03-07 00:00:00 | BOV |  | B281179 | closed | 121.93 | 2.91 | 18.64 | 149.22
3024 | 197/11 | 2011-08-29 00:00:00 | MV 03 |  | 2011-12-12 00:00:00 | 2012-02-03 00:00:00 | 2012-02-07 00:00:00 | 109.75 | 2012-03-07 00:00:00 | BOV |  | B281180 | closed | 45.72 | 1.09 | 6.99 | 55.95
65832 | 197/11 | 2011-08-29 00:00:00 | MV 03
23328 | 197/11 | 2011-08-29 00:00:00 | MV 03
2880 | 197/11 | 2011-08-29 00:00:00 | MV 03
1440 | 197/11 | 2011-08-29 00:00:00 | MV 03