Spreadsheet: 195826d1353675833-in-vlook-if-value-comes-to-n-a-i-want-there-0-new-clustwise-nov-12
Sheet: raw2

GCN Freight Summary report
Your Query
RCC | 6
Location | All
Customer Code | All
Date Range | 23 Oct 12 - 23 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 | 38 | 54194 | 51100 | 7459 | 9000 | 105294 | 16459
2 | 0135 : AHMEDNAGAR | Booking | 3 | 2100 | 0 | 360 | 0 | 2100 | 360
 |  | Delivery
3 | 0335 : NANDED | Booking | 1 | 793 | 0 | 70 | 0 | 793 | 70
 |  | Delivery
3 | 0275 : KARAD | Booking | 1 | 793 | 0 | 70 | 0 | 793 | 70
 |  | Delivery
3 | 1253 : GOKUL SHIRGAON | Booking | 1 | 793 | 0 | 70 | 0 | 793 | 70
 |  | Delivery
3 | 0652 : PANJIM | Booking | 1 | 793 | 0 | 70 | 0 | 793 | 70
 |  | Delivery
3 | 0209 : LONAVALA | Booking | 1 | 793 | 0 | 70 | 0 | 793 | 70
 |  | Delivery
3 | 0242 : PIMPRI-CHINCHWAD | Booking | 1 | 793 | 0 | 70 | 0 | 793 | 70
 |  | Delivery
3 | 0340 : PHURSUNGI | Booking | 1 | 793 | 0 | 70 | 0 | 793 | 70
 |  | Delivery
3 | 0342 : SOLAPUR | Booking | 1 | 793 | 0 | 70 | 0 | 793 | 70
 |  | Delivery
3 | 0721 : TALEGAON | Booking | 1 | 793 | 0 | 70 | 0 | 793 | 70
 |  | Delivery
3 | 1025 : TATHWADE | Booking | 1 | 793 | 0 | 70 | 0 | 793 | 70
 |  | Delivery
3 | 1235 : KURULI | Booking | 1 | 793 | 0 | 70 | 0 | 793 | 70
 |  | Delivery
3 | 1277 : CHAKAN INDL AREA | Booking | 1 | 793 | 0 | 70 | 0 | 793 | 70
 |  | Delivery
3 | 1280 : HADAPSAR | Booking | 1 | 793 | 0 | 70 | 0 | 793 | 70
 |  | Delivery
3 | 1288 : TALAWADE | Booking | 1 | 793 | 0 | 70 | 0 | 793 | 70
 |  | Delivery
3 | 0583 : KOREGAON BHIMA | Booking | 1 | 793 | 0 | 70 | 0 | 793 | 70
 |  | Delivery
3 | 0583 : KOREGAON BHIMA | Booking | 1 | 793 | 0 | 70 | 0 | 793 | 70
 |  | Delivery
3 | 0583 : KOREGAON BHIMA | Booking | 1 | 793 | 0 | 70 | 0 | 793 | 70
 |  | Delivery
3 | 0117 : WAGHOLI | Booking | 1 | 793 | 0 | 70 | 0 | 793 | 70
 |  | Delivery
3 | 0490 : MALEGAON | Booking | 1 | 793 | 0 | 70 | 0 | 793 | 70
 |  | Delivery
3 | 0113 : BELGAUM CITY | Booking | 1 | 793 | 0 | 70 | 0 | 793 | 70
 |  | Delivery
3 | 0195 : MADHAVNAGAR | Booking | 1 | 793 | 0 | 70 | 0 | 793 | 70
 |  | Delivery
3 | 0238 : SATARA | Booking | 1 | 793 | 0 | 70 | 0 | 793 | 70
 |  | Delivery
3 | 0140 : AURANGABAD | Booking | 1 | 793 | 0 | 70 | 0 | 793 | 70
 |  | Delivery
4 | 0176 : KOLHAPUR (SHIROLI) | Booking | 6 | 9230 | 34147 | 596 | 14128 | 43377 | 14724
 |  | Delivery
5 | 0229 : HUBLI | Booking | 5 | 5963 | 29440 | 1018 | 32000 | 35403 | 33018
 |  | Delivery
6 | 0283 : CHAKAN | Booking | 5 | 13238.28 | 0 | 2839 | 0 | 13238.28 | 2839
 |  | Delivery
7 | 0288 : BELGAUM (UDYAMBAUG) | Booking | 8 | 8576 | 0 | 836 | 0 | 8576 | 836
 |  | Delivery
8 | 0337 : WALUJ (AURANGABAD) | Booking | 30 | 62024.33 | 0 | 10496 | 0 | 62024.33 | 10496
 |  | Delivery
 |  | Delivery Hub
9 | 0342 : SHOLAPUR | Booking | 1 | 3149.66 | 0 | 30 | 0 | 3149.66 | 30
10 | 0449 : PIRANGUT | Booking | 1 | 0 | 21500 | 0 | 6000 | 21500 | 6000
 |  | Delivery
11 | 0467 : BHOSARI | Booking | 1 | 5520.45 | 0 | 1000 | 0 | 5520.45 | 1000
12 | 0597 : URULIKANCHAN | Booking | 5 | 13938 | 0 | 2380 | 0 | 13938 | 2380
 |  | Delivery
13 | 0651 : VERNA | Booking | 6 | 54660 | 0 | 7729 | 0 | 54660 | 7729
 |  | Delivery
 |  | Delivery Hub
14 | 0653 : MAPUSA | Booking | 11 | 5063.1 | 0 | 276 | 0 | 5063.1 | 276
 |  | Delivery
15 | 0704 : SANGAMNER | Booking | 1 | 0 | 40070 | 0 | 4310 | 40070 | 4310
 |  | Delivery
16 | 0710 : SINNAR (MIDC) | Booking | 4 | 31366.59 | 0 | 5643 | 0 | 31366.59 | 5643
 |  | Delivery
17 | 0752 : BARAMATI | Booking | 5 | 5685 | 0 | 299 | 0 | 5685 | 299
 |  | Delivery
18 | 0768 : KHEDSHIVAPUR | Booking | 10 | 9033.21 | 0 | 687 | 0 | 9033.21 | 687
 |  | Delivery
19 | 0777 : WADGAON BUDRUK | Booking | 9 | 12598 | 0 | 1595 | 0 | 12598 | 1595
 |  | Delivery
20 | 1008 : MARGAO CITY | Booking | 1 | 747 | 0 | 10 | 0 | 747 | 10
 |  | Delivery
21 | 1091 : PONDA KURTI | Booking | 11 | 19472.27 | 0 | 2573 | 0 | 19472.27 | 2573
 |  | Delivery
22 | 1219 : RANJANGAON | Booking | 2 | 7630 | 0 | 1050 | 0 | 7630 | 1050
 |  | Delivery
23 | 1248 : KURKUMBH | Booking | 3 | 19575 | 0 | 5255 | 0 | 19575 | 5255
 |  | Delivery
24 | 1278 : CHAKAN MIDC | Booking | 18 | 28321.4 | 56300 | 4008 | 36000 | 84621.4 | 40008
25 | 1286 : POONA CITY BKG | Booking | 4 | 5237.39 | 0 | 701 | 0 | 5237.39 | 701
26 | 1288 : TALWADE | Booking | 5 | 0 | 105600 | 0 | 15609 | 105600 | 15609
27 | 1289 : BHOSARIGAON | Booking | 22 | 40699.72 | 90020 | 5453 | 11700 | 130719.72 | 17153
Sub Total |  |  | 216 | 418815.4 | 428177 | 62363 | 128747 | 846992.4 | 191110
Grand Total |  |  | 216 | 418815.4 | 428177 | 62363 | 128747 | 846992.4 | 191110