« More than just NECA | Main | What's in a NPA-NXX »
March 16, 2009
So Many Miles, So Little Time
Mileage can be calculated in mass through formulas using V-H coordinates for End Offices, rather than looking up mileage individually with an industry tool. The V-H coordinates can be found in LERG 7 or NECA tables and a table with V-H coordinates can be produced for any given invoice by joining either the CLLI code or NPA-NXX to LERG 7 or NECA. The mileage is then calculated using the formula provided in NECA No. 4, Section 11.
- There are cases where there is no exact match for the CLLI code in the LERG/NECA tables. In these cases, check first 8 characters of the CLLI code (Building Code). If there is no match, then an industry software tool may be the best bet to verify mileage.
- The square root function forces basic rounding (i.e. <0.5 rounds down). A ceiling function can be used to force rounding up, to eliminate disputes that are off by 1 mile or less.
Using this method, mileage can be verified for a large number of invoice entries very quickly. Then only the discrepancies need to be manually verified.
Trackback Pings
TrackBack URL for this entry:
http://www.telcocost.com/cgi-bin/mt/mtb.cgi/127
Comments
Post a comment
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)
