Wimpie
Board Regular
- Joined
- Aug 12, 2008
- Messages
- 210
Hi please assist
Column A = Number of the branch/offsite e.g H917
Column B = Name of the branch/offsite e.g Main branch
Column C = Clasification e.g branch/offsite
Column D = Can be serviced as an branch/offsite e.g yes/no
Column E = Cash delivery e.g shared/dedicated
Column F = Average number of deliveries per week e.g 1 - 3
Column G = Kilometres from town e.g 1 to 200km's
Column H = Band 1 - 4
Cloumn I = Cost per band e.g band 1 = 247
Column J = Monthly cost per Band (colmn f*I*4)
Column K = Service provider e.g SSB/ Branch or Canister swop
I need to see diffrent senarious out of this if we can look at them one by one please.
1. I need to see the number of branches as follows 0-5km's from town, 5-50km's from town and 50km's plus from town but per service provider(column K), I need to see the same for the offsites.
If the service provider in column K is SSB the monthly cost in K needs to be shown as well.
Column A = Number of the branch/offsite e.g H917
Column B = Name of the branch/offsite e.g Main branch
Column C = Clasification e.g branch/offsite
Column D = Can be serviced as an branch/offsite e.g yes/no
Column E = Cash delivery e.g shared/dedicated
Column F = Average number of deliveries per week e.g 1 - 3
Column G = Kilometres from town e.g 1 to 200km's
Column H = Band 1 - 4
Cloumn I = Cost per band e.g band 1 = 247
Column J = Monthly cost per Band (colmn f*I*4)
Column K = Service provider e.g SSB/ Branch or Canister swop
I need to see diffrent senarious out of this if we can look at them one by one please.
1. I need to see the number of branches as follows 0-5km's from town, 5-50km's from town and 50km's plus from town but per service provider(column K), I need to see the same for the offsites.
If the service provider in column K is SSB the monthly cost in K needs to be shown as well.