| CAFRMAN'S COMPUTER PROGRAM |
This computer program is designed to be used by almost anyone because it is very simple to use.
We recommend a directory with the name "CAFR Review Program" be created. The downloaded zipped file should be placed in this directory.
The downloaded zipped file can be unzipped by going to your file management program (E.g. Windows Explorer) and double clicking on the ZipCAFR.exe file. Follow the directions and unzip the files to the "CAFR Review Program" directory previously established.
The unzipped files will be in three directories:
1. CAFR Computer Program
2. Review
Guide
3. SetupExe
Establishing the CAFR.exe in Proper Directory
The steps to setting up your computer to be able to run the CAFR.exe program:
1. Go to the SetupExe directory
2.
Locate and double click on the Setup.exe file
3. Follow the instructions
provided; however, when the instructions state:
a. On the screen labelled "Project Setup" click on the OK button.
b. On the next screen, begin the installation by clicking the "Change Directory" button.
c. Change the "Directory" to "C:\CAFR Review Program\CAFR Computer Program".
d. Follow the rest of the instructions.
This should install the program on your computer and it will place a "CAFR.exe" file in your C:\CAFR Review Program\CAFR Computer Program directory.
Here is a list of the required files for each directory.
SetupExe Directory:
AsycFilt.dl_ Setup.exe CAFR.ex_ Setup.lst ComCat.dl_ Setup1.ex_ Comctl32.oc_ Spr32x30.oc_ Comdlg32.oc_ St5unst.ex_ Ctl3d32,dl_ StdOle2.tl_ Mscomm32.oc_ VB5StKit.dl OleAut32.dl_ Fpspr30.oc_ OlePro32.dl_ CAFR Computer Program:
CAFR.exe Master-Econ2C.ss3 Master-Rev1.ss3 Master-Econ2D.ss3 Master-Rev2.ss3 Master-ESC.ss3 Master-Ret1.ss3 Master-FilesNames.ss3 Master-Sum1.ss3 Master.FormsList.ss3 Master-Econ1.ss3 PrintFormsNames.ss3 Master-Econ2A.ss3 The .ss3 forms you have created. Master-Econ2B.ss3 If you move the file "CAFR.exe" to another directory, you should also move all the files.
The file names used for forms has a standard format. The file name is as follows:
| Type of Review | Form Name | Abbreviated Organization Name | Page Number | Extension |
Example: Directory Path + \S2-Rev1-WaterUtilComm-1.ss3
| S2 | Rev1 | WaterUtilComm | 1 | .ss3 |
The files always have the ".ss3" extension. So if you decide to change a file name be sure it includes a .ss3 extension.
All Master Form files have the following format: Directory Path + Master-Rev1.ss3. Master files cannot and should not be saved because these files are needed many times during the review of different CAFRs.
There are four key operations that are used many times on the forms. The keys are:
Enter - Moves the cursor down one cell.
Tab - Moves the cursor and focus one cell to the right and if at the end of the table then to the first cell on the next row down.
Shift-Tab - Moves the cursor and focus one cell to the left and if at the beginning of a table then to the last cell in the previous row.
Editing a Data Entry - Double clicking on a cell will place the cell in the edit mode and data entries can be edited. A single click on a cell allows for initial entries.
Legal Stuff - Legal considerations regarding the use of this program.
Instructions - Explains where to locate and use the CAFRman's Review Program Guide
Review Program- When this button is clicked the following buttons are shown:
New Form - This is for retrieving a new form to use. When this button is clicked a separate widow is shown. The window states at the top "Select directory/path where the Master Form can be found".
Double click on the appropriate directory/path where the Master Forms are located and then click on Continue. This will take you to the Master Forms List screen shown below. (Note: It is important to double click on the appropriate directory/path or the proper directory/path will not be selected.)
Existing Form - This will open the File Management screen in order to select from existing forms that have been worked on and explained below.
Project Management - This is a form to assist in managing review projects. When this button is clicked a separate widow is shown. The window states at the top "Select directory/path where the Master Form can be found".
Double click on the appropriate directory/path where the Project Management Form is located and then click on Continue.
Exit - Closes the program.
The list of forms screen provides for selection of a new form from the kinds of forms associated with each Type of Review based on the CAFR Schematic. This helps to quickly find the form that is appropriate to type of review being conducted.
To select a new form click on one of the buttons left of the corresponding form you want to use.
Drive (c:) - You can change the drive here.
Directory (Path) - must double click in order to change directory
Files in this Directory- this list only includes the .ss3 files in a selected directory. This makes it easier to locate the proper directory and locate the file that you want by not showing files not associated with this program.
Current File (Data Entry Box) - This is the either the file selected or where you can edit the file name. Make sure the file directory and file name contain the proper Form Name (Rev1, Econ1, Ret1, etc.) and the extension .ss3 or you will not be able to keep track of the forms. You can always go to your Windows or other file management system and change the file name to the proper file name in the event you made a mistake in designating the file or directory properly.
Open - once you are satisfied with the directory and file name shown in the "Current File" box described above, then click on Open and the file will be retrieved in the proper form.
Cancel - Returns to the previous screen/form.
Delete - Deletes the file selected and contained in the Current File. In order to insure that the file was deleted, double click on the "c:" or other drive selected in the Directory (Path) area and then double click on the directory in which the deleted file was previously shown. The file should not appear in the Files in this Directory list.
Exit - Returns to the Main Page of the program
Type Review - When a row in this column is clicked a pop up menu appears and provides the only selections allowed for the Type of Review.
Form - When a row in this column is clicked a pop up menu appears and provides the only selections allowed for the types of forms used in this program.
Organization Name - This is the full name of the government/organization that the form pertains to.
Page Number - Normally you would enter "1" in this cell. However, there may be times when you want to look at a form/analysis in two or more different ways. You can call your first analysis page "1", second analysis plage "2". For example, you may want to look at the review or economic analysis using the retirement surpluses and not using the retirement surpluses as part of the overall potential surpluses of a government or other government entity.
Abbreviated Organizational Name - The above Organization Name can become very long and cumbersome for inclusion in a file name. You should decide on a smaller abbreviated name for the file name. For example: the Xyz County Housing Improvement District could reduced to XyzHseImpDist or something similar.
STATE, COUNTY, CITY, SCHOOLS, and COMBINATION - You can keep track of your work by entering the data listed above under one of these categories. In this way you not have to figure out what you have accomplished from a file listing in a directory. This segregates your work by government. For example, all S1/S2/Ret1/Ret2 (State-level government) forms would be listed under STATE.
File Name Designation and Saving Files
This data input form provides for a uniform file name for each form in order to keep track of the work being performed. When a Master Form is called, this form appears in order to insure that a proper file name is provided so the completed form will not be saved back to a Master Form and lose the ability to use this Master Form again in other reviews.
Type Review -When this data input block is clicked a pop up menu appears and provides the allowable choices for this program.
Review Form - The review form selected either by selecting a Master Form or an existing file will be displaced in this block. This block cannot be edited. The form name must be associated with the proper file containing the data of that form.
Organization Name - See Organization Name under Project Management above.
Abbreviated Organization Name - See Abbreviated Organization Name under Project Management above.
Page Number - See Page Number Name under Project Management above.
New File Name - If this is a new file name you will see "?" for that portion of the file name that has not been completed. A proper file name does not contain "?s".
OK - This will record the new or edited file name and display the information on the top of the form you are using.
Cancel - This will remove the File Name Designation form from the screen and take you back to the current form you are working on at the time.
This calculator is a little different than most calculators. It has two display blocks. The top portion displays the numbers as they are entered. The second display block displays the numbers with the appropriate commas in order to see exactly what you entered. How much is 200000000? Do you have enough zeros or too many? The second block displays 200,000,000, which is much easier to compare when adding data from the CAFR.
In addition and probably more important is that you can make computations and paste the results to a particular cell in a form: (You can use this feature on every Rev1 and Rev2 form many times.)
Click on the cell in which you want the result to appear.
Click on the Calculator menu item. The calculator appears.
Perform the calculations you want and click on the "=" button.
Click on the "Paste" button on the calculator and the results will be transferred to the cell in which you had originally clicked above.
The executable file is "CAFR.exe". You can start the program from three sources:
1. From your file management program (e.g. Windows® Explorer) by double clicking on the CAFR.exe file.
2. In Microsoft® Windows click on START, then click on RUN, then BROWSE until you find the CAFR.exe file, and click OK.
3. Establish a short cut with an icon. Follow your computer instructions for creating an icon.