Section 8.2. The Data

8.2. The Data

As with all applications in this book, the data is on a worksheet named Data. There are no formulas or meaningful formatting on this sheet. The Data sheet is shown in Figure 8-7.

Figure 8-7. The Data sheet

Column A contains the queue name. Here we see part of the extended research queue (EXT). Column B has the status. The date and time that the document entered the queue are in column C. The date and time the document was assigned to an agent are in column D. Column E has the value of the item being worked on. The employee number of the agent assigned to the document is in Column F. The name of the file containing the document image is in column G.

This application is only an example. It is not connected to a data source and cannot update. In a production situation the Data sheet would be re-populated frequently, perhaps once an hour. Each time the update runs, the entire data sheet is copied to a sheet named OldData, which is used to draw the gray bars on the charts.