Unregistered Carriers on 10/01/2009 - 1933
Unregistered Carriers on 10/02/2009 - 1930
Tool #2 - Daily Change List
---------------------------
You may recall that a few months ago, we purchased an inexpensive software tool (the name escapes me at the moment but it cost us $39, I think) that compares two Excel spreadsheets. Why did we buy that? Because if we run the UCR-Link Unregistered List for today, save it, then run the Unregistered List tomorrow and save it, we can compare the two lists and create the Daily Change List. Actually, you can run lists anytime and compare them (we sometimes do a couple lists a day), but the main point is that we create a change list for two different points in time and compare them. Because we run our own system, we make sure that everybody that has been "added" to in the change list is in our system. We try to make sure that everybody who was "deleted" in the change list can be accounted for through the reconciliation process and we try to make sure that everybody whose information is "different" from the last list is modified in our system.
The Daily Change List helps us to keep track of every single carrier who comes and goes from our Unregistered List and helps us feed the Troll List, which we'll talk about in the next post.
No comments:
Post a Comment