110 likes | 203 Views
Finalising the selection for Level 1 and Level 2 sorting at NSH /ICH Steps involved. Steps involved. Get the volume of SPAs dispatched Segregate the Volumes for TD and NTD Sort the TD Volume in Descending Order Sort the NTD Volume in Descending Order
E N D
Finalising the selection for Level 1 and Level 2 sorting at NSH /ICH Steps involved
Steps involved Get the volume of SPAs dispatched Segregate the Volumes for TD and NTD Sort the TD Volume in Descending Order Sort the NTD Volume in Descending Order Top 50 Destinations of TD Volume will form Level 1 TD and next 50 Destinations of TD Volume will form Level 2 TD Top 50 Destinations of NTD Volume will form Level 1 NTD and next 38 Destinations will form Level 2 NTD
Steps in-detail We have to get the volume of SPAs dispatched from our NSH to all the other destinations (TD and NTD) for a specified Period The period can be between 1 to 6 months The volume has to be extracted from the Speednet Database through a SQL Query This extract has to be exported to MS Excel Seggregated as TD and NTD Data has to be sorted in Descending Order of Volume Dispatched for TD and NTD separately Top 50 Destinations will form level 1 and subsequent destinations will form level 2 Finally Sorting Diagram can be designed
Result of Query Query executed for NSH Bangalore for July 2013
Sorting Diagram / Selection for Level – 1 NTD Sorting at Jaipur LEVEL 1 TOTAL : 2,89,328 Based on Data for 10th June- 31st July 2014 Source : Mail Network Optimization Project India Post | 8
Sorting Diagram / Selection for Level – 2 NTD Sorting at Jaipur LEVEL 2 TOTAL : 15,512 Based on Data for 10th June- 31st July 2014 Source : Mail Network Optimization Project India Post | 9
Sorting Diagram / Selection for Level 1 TD Sorting at Jaipur LEVEL 1 TOTAL : 6,73,323 Based on Data for 10th June- 31st July 2014 Source : Mail Network Optimization Project India Post | 10
Sorting Diagram / Selection for Level 2 TD Sorting at Jaipur LEVEL 2 TOTAL : 55,223 Based on Data for 10th June- 31st July 2014 Source : Mail Network Optimization Project India Post | 11