Patent ID: 7146378

Claim:
A computer-based method of summarizing a status of a plurality of service orders, the method comprising: importing a first data set that includes a plurality of records into a database application, wherein at least some of the plurality of records correspond to respective ones of the plurality of service orders; executing at least one query on the first data set to generate a second data set that comprises at least part of the first data set and one or more labels that have been appended to at least some of the plurality of records in the first data set for use by a spreadsheet application; importing the second data set into the spreadsheet application; using a pivot table to automatically generate within the spreadsheet application a summary of the status of the service orders based on at least some of data from the second data set, wherein the summary of the status of the service orders summarizes a first status indicia and a second status indicia of the plurality of service orders, and wherein the plurality of service orders comprise orders for initiation of telephone service, and wherein the first status indicia summarizes a number of service orders that are in respective ones of a plurality of possible processing stages and wherein the second status indicia summarizes the status of the service orders at each processing stage with respect to facility assignments.