RCP SOFTWARE DEMONSTRATIONS
    Self-Calculating Criminal Case Abstract of Judgment

As those of you who operate in the California court system regularly will know, there are a number of
Judicial Council forms for standard pleadings. Most are relatively straightforward to design in electronic
format. And the JC has a number of fillable forms that are available on the Web. In a modern system, all
or virtually all documents would be in electronic format. Most such forms are easy to design. However,
in addition to such basic forms, it is possible to enable forms to do various types of calculations and
determinations. The demonstrations here will be limited to the more complex types of forms.

This first example is a sentencing abstract which will automatically calculate the total unstayed
sentence. You would need Excel 2007 to run the current version that would be part of a modern justice
data management system but I have now placed a binary version up here for demonstration purposes
since I realized that some people may not be able to open the XML-based version but could still see the
demonstration with their present computers if the demo was converted backwards. You will need at
least Excel 2002 to run the demonstration. When it opens in Excel, just start by typing the name of your
county. Then press the Tab key. You can get general instructions and helpful hints by passing your
mouse over the cells that have the red triangles. Ready? Click on the link below to get started.


This demo is Beta 1 level software prepared without any input from outside alpha or beta testers so it is
still subject to being modified and may need some modifications. All viewers are invited to e-mail
comments on this software.

To get instructions, start by passing your mouse cursor over cell A2. The software also contains a self-
teaching tutorial. There are additional hints and information in other cells that have a red triangle in the
upper right hand corner. Formatting of the software is not necessarily final and you may notice some
pieces of tentative ideas for additional features but it will work. You MUST have Excel 2002 or later to
run it. This is Beta level software but this should give you a pretty good idea of what is possible in this
modern electronic age.

The interesting part of this demo mathematically (for the geeks out there) is getting the years and
months to add up correctly since our number system is based on 10 and the calendar is based on 12
months.