Spreadsheet: 196725d1354090571-vba-or-macro-to-copy-specific-value-to-another-worksheet-from-raw-sheet-clustwise-nov-12
Sheet: raw1

GCN Freight Summary report
Your Query
RCC | 6
Location | All
Customer Code | All
Date Range | 01 Oct 12 - 25 Oct 12
Sr. | Location | Function | Total GCNs | Sundry Freight | FTL Freight | Sundry Tonnage | FTL Tonnage | Total Freight | Total Tonnage
06 : MAH
1 | 0112 : SATPUR | Booking | 806 | 1319362 | 834601 | 187441 | 184405 | 2153963 | 371846
2 | 0113 : BELGAUM CITY | Booking | 15 | 13090 | 0 | 2151 | 0 | 13090 | 2151
 |  | Delivery
3 | 0117 : WAGHOLI | Booking | 83 | 164515.85 | 66260 | 16893 | 27000 | 230775.85 | 43893
 |  | Delivery
4 | 0135 : AHMEDNAGAR | Booking | 41 | 74716.97 | 38200 | 11665 | 9500 | 112916.97 | 21165
 |  | Delivery
5 | 0140 : AURANGABAD | Booking | 231 | 410258.47 | 22650 | 72477 | 5723 | 432908.47 | 78200
 |  | Delivery
6 | 0176 : KOLHAPUR (SHIROLI) | Booking | 82 | 157611.18 | 253855 | 13710 | 109607 | 411466.18 | 123317
 |  | Delivery
7 | 0195 : MADHAVNAGAR | Booking | 6 | 9806 | 0 | 1957 | 0 | 9806 | 1957
 |  | Delivery
8 | 0209 : LONAVALA | Booking | 108 | 220377.83 | 0 | 34020 | 0 | 220377.83 | 34020
 |  | Delivery
9 | 0229 : HUBLI | Booking | 79 | 150667.77 | 348230.71 | 22930 | 128000 | 498898.48 | 150930
 |  | Delivery
10 | 0238 : SATARA | Booking | 79 | 194084.7 | 0 | 31632 | 0 | 194084.7 | 31632
 |  | Delivery
11 | 0242 : PIMPRI-CHINCHWAD | Booking | 290 | 620363.48 | 358998 | 80197 | 144000 | 979361.48 | 224197
12 | 0275 : KARAD | Booking | 15 | 14062 | 0 | 2561 | 0 | 14062 | 2561
 |  | Delivery
13 | 0283 : CHAKAN | Booking | 123 | 199410.53 | 52200 | 39967 | 8500 | 251610.53 | 48467
 |  | Delivery
14 | 0288 : BELGAUM (UDYAMBAUG) | Booking | 138 | 190995.98 | 829280.42 | 32319 | 222535 | 1020276.4 | 254854
 |  | Delivery
15 | 0335 : NANDED | Booking | 2 | 4563.01 | 0 | 620 | 0 | 4563.01 | 620
 |  | Delivery
16 | 0337 : WALUJ (AURANGABAD) | Booking | 614 | 744203.99 | 424229.66 | 135861 | 96041 | 1168433.65 | 231902
 |  | Delivery
 |  | Delivery Hub
17 | 0340 : PHURSUNGI | Booking | 23 | 68697 | 0 | 8950 | 0 | 68697 | 8950
 |  | Delivery
18 | 0342 : SHOLAPUR | Booking | 13 | 31889.37 | 0 | 2230 | 0 | 31889.37 | 2230
19 | 0449 : PIRANGUT | Booking | 45 | 138784.09 | 39500 | 18498 | 11000 | 178284.09 | 29498
 |  | Delivery
20 | 0467 : BHOSARI | Booking | 15 | 46254.74 | 0 | 7475 | 0 | 46254.74 | 7475
21 | 0490 : MALEGAON | Booking | 11 | 42527 | 0 | 6529 | 0 | 42527 | 6529
 |  | Delivery
22 | 0583 : KOREGAON BHIMA | Booking | 83 | 196997 | 0 | 35688 | 0 | 196997 | 35688
 |  | Delivery
23 | 0597 : URULIKANCHAN | Booking | 46 | 143368.07 | 0 | 27226 | 0 | 143368.07 | 27226
 |  | Delivery
24 | 0651 : VERNA | Booking | 38 | 126904 | 206795 | 18522 | 82310 | 333699 | 100832
 |  | Delivery
 |  | Delivery Hub
25 | 0652 : PANJIM | Booking | 2 | 2275 | 0 | 85 | 0 | 2275 | 85
 |  | Delivery
26 | 0653 : MAPUSA | Booking | 101 | 70884.02 | 163885 | 8442 | 63447 | 234769.02 | 71889
 |  | Delivery
27 | 0704 : SANGAMNER | Booking | 11 | 31691 | 80140 | 5276 | 9410 | 111831 | 14686
 |  | Delivery
28 | 0710 : SINNAR (MIDC) | Booking | 126 | 220706.93 | 590380 | 43154 | 243739 | 811086.93 | 286893
 |  | Delivery
29 | 0721 : TALEGAON | Booking | 25 | 73773.26 | 0 | 6480 | 0 | 73773.26 | 6480
 |  | Delivery
30 | 0752 : BARAMATI | Booking | 85 | 159585.37 | 0 | 17200 | 0 | 159585.37 | 17200
 |  | Delivery
31 | 0768 : KHEDSHIVAPUR | Booking | 143 | 253445.9 | 91825 | 30124 | 36000 | 345270.9 | 66124
 |  | Delivery
32 | 0777 : WADGAON BUDRUK | Booking | 109 | 253714.17 | 19400 | 46003 | 4200 | 273114.17 | 50203
 |  | Delivery
33 | 1008 : MARGAO CITY | Booking | 15 | 11375 | 0 | 546 | 0 | 11375 | 546
 |  | Delivery
34 | 1025 : TATHWADE | Booking | 24 | 49112.05 | 0 | 7601 | 0 | 49112.05 | 7601
 |  | Delivery
35 | 1091 : PONDA KURTI | Booking | 61 | 200985.75 | 100800 | 24881 | 38583 | 301785.75 | 63464
 |  | Delivery
36 | 1219 : RANJANGAON | Booking | 18 | 52188 | 0 | 8296 | 0 | 52188 | 8296
 |  | Delivery
37 | 1248 : KURKUMBH | Booking | 88 | 304058.5 | 17740 | 70718 | 10500 | 321798.5 | 81218
 |  | Delivery
38 | 1253 : GOKUL SHIRGAON | Booking | 43 | 87800.31 | 0 | 7570 | 0 | 87800.31 | 7570
 |  | Delivery
39 | 1277 : CHAKAN INDL AREA | Booking | 117 | 145326.76 | 0 | 39455 | 0 | 145326.76 | 39455
40 | 1278 : CHAKAN MIDC | Booking | 256 | 460373.96 | 673840 | 69115 | 267500 | 1134213.96 | 336615
41 | 1280 : HADAPSAR | Booking | 6 | 0 | 74100.39 | 0 | 11122 | 74100.39 | 11122
42 | 1286 : POONA CITY BKG | Booking | 318 | 254010.15 | 184111 | 27530 | 60833 | 438121.15 | 88363
43 | 1288 : TALWADE | Booking | 6 | 0 | 124220 | 0 | 16626 | 124220 | 16626
44 | 1289 : BHOSARIGAON | Booking | 89 | 185592.18 | 301740 | 22631 | 71200 | 487332.18 | 93831
Sub Total |  |  | 4629 | 8100409.34 | 5896981.18 | 1246626 | 1861781 | 13997390.52 | 3108407
Grand Total |  |  | 4629 | 8100409.34 | 5896981.18 | 1246626 | 1861781 | 13997390.52 | 3108407