NOTE: This program is built upon, and designed to work with, Microsoft’s Excel spreadsheet application.
Attorneys - Blank List
Attorneys - Attorneysheet
Attorneys - submit to court
Use of the BlankList aids in communication between parties in developing and organizing the list of their assets. It permits cut and paste and allows changing the order of asset listing. An attorney or party may list the assets and enter that party’s values. The asset list could then be exchanged with the other party for completion, and worked on until a joint asset list is agreed upon.
The BlankList, when completed, is then pasted to the attorneysheet (using the PasteList macro found on the Attorney toolbar).
Or, you may start in the attorneysheet, realizing that the attorneysheet has less flexibility than the BlankList.
In addition to the list of assets and each party’s proposed values, the attorneysheet requires additional entries to indicate positions of the parties on asset distribution – if agreement as to distribution, what the distribution shall be; if no agreement, each party’s desired distribution. It allows the parties to identify those assets whose status as marital property is disputed. The note column is optional; it may be used to categorize marital property or add a commentary.
When the attorneysheet is completed, reflecting the joint list of the parties and their respective positions:
1. Save the attorneysheet as a file.
2. Print the attorneysheet (using the PrintAttySheet macro found on the Attorney toolbar).
4. Email the attorneysheet file as an attachment to the judge’s administrative assistant so that the judge receives the sheet in electronic form before trial.
(The attorneysheet will then be exported by the judge and ready for use in the judge’s format for trial.)
Page 2 of the attorneysheet (which consists of each party’s proposed distribution) is for use of the parties in comparing their respective positions and should provide a starting point for negotiations or adjustments. Alternatively, the parties may “play judge” by exporting to the judge’s sheet using the Export macro (found on the Judge Toolbar), and completing it consistently with the party’s position for either settlement or advocacy.
 If, for appearance and organizational purposes, you wish to categorize property and debt using blank or non-asset rows, type any symbol/character/text in Column A; type "." in Columns B and C of that non-asset row.
Any row without text in Column A marks the end of the list that will be pasted.
 Use the Print macro to print the sheet. (If you don’t use the Print macro, but just print the attorneysheet, you will print many sheets containing all 500 rows, even if unused/blank. Save a tree.)
You must receive a joint property list from the parties, in the PropDiv attorneysheet format. Separate lists will not work and serve no function.
Upon receipt of the attorney’s sheet:
1. Open it
2. In the pop-up box, select to use as "Judge”
3. Immediately invoke the Export macro on the Judge toolbar
This transforms the data into the judge’s format ("judgesheet") which, when completed, will embody the judge’s property division decision. At the conclusion of trial, it can be printed and distributed in open court.
NOTE: Red cells designate where a judicial decision is required. Elimination of red cells tend to indicate completion of judge’s decision-making re: asset valuation and distribution.
When you’re done, save your work; print the judgesheet using the Print macro found on the Judge toolbar.
 For red cells in Column D which the judge wants to make non-red, but not make a value decision (i.e., rows which were used as "blank" or "non-asset" rows by the attorney), the judge should enter a period in the Ct Value cell. The red cells in that row should become non-red.
If the sheet is being compiled for attorney’s use (disclosure, pretrial, or submission to the court), select Attorney toolbar.
The Attorney toolbar appears by default so this sheet can be compiled for the judge.
If toolbars are not visible, they can be made visible:
View | Toolbars
check appropriate toolbar:
“prop div – atty”
“prop div – judge”
Once you've downloaded the program, samples of the worksheets are available in the PropDiv folder on your hard drive (i.e., "C:\PropDiv\"):
"1SampleL" - Example of BlankList worksheet
"2SampleA" - Example of Attorney worksheet
"3SampleJ" - Example of Judgesheet
"4SampleD" - Example of Judgesheet worked by Judge ("Decision")