User's Manual

Forms
Version: 2.3 110 10/15/2009
SCRAM MONTHLY BILLING WORKSHEET
The Monthly Billing Worksheet shown below illustrates the type of information that is
imported into an MSExcel spreadsheet. The data, which matches the information in the
Monthly Device Assignments Report, can be used as the beginning of a custom billing
worksheet to track the billing information for your clients, thus aligning the number of
days you are being billed by AMS with your monthly billing.
Refer to the “Importing xml into an MSExcel Spreadsheet” procedures on page 93 to
view the steps performed to generate this spreadsheet.
Figure 65: Monthly Billing Worksheet
Note: Because of space restrictions, not all columns are displayed in the image below.
The actual spreadsheet contains 24 columns of billing information when the data
importation is complete. Examples of the data available are:
Agency AssignDays JudgeName
Bracelet Region CaseNumber
ClientName CourtID ServiceProviderName
CourtName CourtShortName DateCheckin
DateCheckout DeviceAssignmentID Location
DeviceType JudgeID RegionName