Spreadsheet: 196460d1354019866-vba-or-macro-to-copy-specific-value-to-another-worksheet-from-raw-material-clustwise-nov-12
Sheet: raw2

GCN Freight Summary report
Your Query
RCC | 6
Location | All
Customer Code | All
Date Range | 01 Nov 12 - 25 Nov 12
Sr. | Location | Function | Total GCNs | Sundry Freight | FTL Freight | Sundry Tonnage | FTL Tonnage | Total Freight | Total Tonnage
06 : MAH
1 | 0045 : POONA CITY | Booking | 1 | 1704 | 0 | 36 | 0 | 1704 | 36
 |  | Delivery
2 | 0112 : SATPUR | Booking | 577 | 994407.01 | 222953 | 146592 | 46823 | 1217360.01 | 193415
3 | 0113 : BELGAUM CITY | Booking | 6 | 3220 | 0 | 1261 | 0 | 3220 | 1261
 |  | Delivery
4 | 0117 : WAGHOLI | Booking | 81 | 130530.35 | 271160 | 16216 | 54000 | 401690.35 | 70216
 |  | Delivery
5 | 0135 : AHMEDNAGAR | Booking | 49 | 95533.98 | 65260 | 14555 | 21000 | 160793.98 | 35555
 |  | Delivery
6 | 0140 : AURANGABAD | Booking | 136 | 297347.39 | 147152.63 | 51294 | 34695 | 444500.02 | 85989
 |  | Delivery
7 | 0176 : KOLHAPUR (SHIROLI) | Booking | 78 | 156194 | 290869 | 16106 | 89767 | 447063 | 105873
 |  | Delivery
8 | 0195 : MADHAVNAGAR | Booking | 3 | 1325 | 0 | 254 | 0 | 1325 | 254
 |  | Delivery
9 | 0209 : LONAVALA | Booking | 75 | 96185.96 | 0 | 17101 | 0 | 96185.96 | 17101
 |  | Delivery
10 | 0229 : HUBLI | Booking | 103 | 231126.71 | 334705.64 | 32300 | 92270 | 565832.35 | 124570
 |  | Delivery
11 | 0238 : SATARA | Booking | 88 | 273461.58 | 0 | 37815 | 0 | 273461.58 | 37815
 |  | Delivery
12 | 0242 : PIMPRI-CHINCHWAD | Booking | 194 | 384024.89 | 712340 | 49124 | 93500 | 1096364.89 | 142624
13 | 0275 : KARAD | Booking | 5 | 4380 | 0 | 926 | 0 | 4380 | 926
 |  | Delivery
14 | 0283 : CHAKAN | Booking | 101 | 251674.86 | 115050 | 40445 | 39600 | 366724.86 | 80045
 |  | Delivery
15 | 0288 : BELGAUM (UDYAMBAUG) | Booking | 109 | 139718.85 | 298635 | 20445 | 100566 | 438353.85 | 121011
 |  | Delivery
16 | 0335 : NANDED | Booking | 1 | 1476 | 0 | 229 | 0 | 1476 | 229
 |  | Delivery
17 | 0337 : WALUJ (AURANGABAD) | Booking | 501 | 831258.53 | 325721.82 | 136970 | 79947 | 1156980.35 | 216917
 |  | Delivery
 |  | Delivery Hub
18 | 0340 : PHURSUNGI | Booking | 36 | 106983 | 0 | 20965 | 0 | 106983 | 20965
 |  | Delivery
19 | 0342 : SHOLAPUR | Booking | 9 | 16369.98 | 0 | 1559 | 0 | 16369.98 | 1559
20 | 0449 : PIRANGUT | Booking | 38 | 108650.45 | 0 | 16714 | 0 | 108650.45 | 16714
 |  | Delivery
21 | 0467 : BHOSARI | Booking | 14 | 39813.66 | 0 | 7180 | 0 | 39813.66 | 7180
22 | 0490 : MALEGAON | Booking | 10 | 4553 | 168317 | 1361 | 59056 | 172870 | 60417
 |  | Delivery
23 | 0583 : KOREGAON BHIMA | Booking | 71 | 143546.32 | 0 | 22283 | 0 | 143546.32 | 22283
 |  | Delivery
24 | 0597 : URULIKANCHAN | Booking | 25 | 75679 | 0 | 12857 | 0 | 75679 | 12857
 |  | Delivery
25 | 0651 : VERNA | Booking | 25 | 76421.18 | 139573 | 12095 | 62110 | 215994.18 | 74205
 |  | Delivery
 |  | Delivery Hub
26 | 0652 : PANJIM | Booking | 3 | 6367.57 | 0 | 842 | 0 | 6367.57 | 842
 |  | Delivery
27 | 0653 : MAPUSA | Booking | 83 | 96124.74 | 149928 | 11997 | 68315 | 246052.74 | 80312
 |  | Delivery
28 | 0704 : SANGAMNER | Booking | 10 | 25341.88 | 0 | 4102 | 0 | 25341.88 | 4102
 |  | Delivery
29 | 0710 : SINNAR (MIDC) | Booking | 118 | 132306.85 | 613250 | 22316 | 231055 | 745556.85 | 253371
 |  | Delivery
30 | 0721 : TALEGAON | Booking | 20 | 58703.85 | 0 | 7001 | 0 | 58703.85 | 7001
 |  | Delivery
31 | 0752 : BARAMATI | Booking | 42 | 110854.04 | 0 | 19162 | 0 | 110854.04 | 19162
 |  | Delivery
32 | 0768 : KHEDSHIVAPUR | Booking | 144 | 356078.75 | 60000 | 49691 | 16000 | 416078.75 | 65691
 |  | Delivery
33 | 0777 : WADGAON BUDRUK | Booking | 79 | 178859.46 | 0 | 26488 | 0 | 178859.46 | 26488
 |  | Delivery
34 | 1008 : MARGAO CITY | Booking | 6 | 4460 | 0 | 86 | 0 | 4460 | 86
 |  | Delivery
35 | 1025 : TATHWADE | Booking | 18 | 37670.48 | 0 | 4697 | 0 | 37670.48 | 4697
 |  | Delivery
36 | 1091 : PONDA KURTI | Booking | 38 | 148717.15 | 235600 | 17950 | 92350 | 384317.15 | 110300
 |  | Delivery
37 | 1219 : RANJANGAON | Booking | 4 | 33034.6 | 0 | 5755 | 0 | 33034.6 | 5755
 |  | Delivery
38 | 1248 : KURKUMBH | Booking | 69 | 288100.61 | 0 | 66159 | 0 | 288100.61 | 66159
 |  | Delivery
39 | 1253 : GOKUL SHIRGAON | Booking | 24 | 70164.17 | 0 | 8829 | 0 | 70164.17 | 8829
 |  | Delivery
40 | 1277 : CHAKAN INDL AREA | Booking | 93 | 100940.25 | 0 | 27244 | 0 | 100940.25 | 27244
41 | 1278 : CHAKAN MIDC | Booking | 192 | 515850.01 | 194800 | 73386 | 92000 | 710650.01 | 165386
42 | 1286 : POONA CITY BKG | Booking | 123 | 142698.78 | 153282 | 16418 | 52235 | 295980.78 | 68653
43 | 1288 : TALWADE | Booking | 1 | 0 | 29120 | 0 | 2584 | 29120 | 2584
44 | 1289 : BHOSARIGAON | Booking | 65 | 157601.5 | 45300 | 20262 | 13000 | 202901.5 | 33262
Sub Total |  |  | 3468 | 6929460.39 | 4573017.09 | 1059068 | 1340873 | 11502477.48 | 2399941
Grand Total |  |  | 3468 | 6929460.39 | 4573017.09 | 1059068 | 1340873 | 11502477.48 | 2399941