I require a solution in excel, access or similar platform that can help compare carrier call tariffs and come up with a least cost route/rate based on an analysis of all carrier rates loaded..
This would be done by comparing the destination prefixes, optimizing/standardising these prefixes (if required) and matching or analysing different rates per prefix..
A simple vlookup is not the solution as different carries adopt different prefix lenghts which makes it tricky..
It must be able to compare at least 4 carrier rates (6-8 optimal)..
I have attached rates in excel from 4 carriers...