The PARAMETER ADDITIONS module allows you to add new calculation equations to the Budget Parameter module by the use of a two character calculation code. This calculation code identifies an arithmetic equation of up to 10 steps. Each step is performed in the order it appears on the record, and the calculations are cumulative, arriving at a total based on all calculation parameters referenced in this code.
01 = CALCULATION #
Enter the 2 digit number assigned to this set of calculations. The system accepts up to 98 numeric calculation codes. Code '99' is reserved for Budget Detail Entry and cannot be used for any other purpose.
02 = DESCRIPTION
Enter the name (maximum 30 characters) that describes the calculation.
03 = SPECIFICATIONS
The symbolic formulae for this calculation (01-10). The system will accept up to 10 calculations steps per code.
All calculation symbols must reference a BPS budget year. To reference the current year, the symbol '#' is used as the first character preceding the symbol itself. To reference the previous year, the first character will be a 1, to access two years previous, the symbol is a 2, etc.
Example: #BUBA=1BUBA+1ACEX denotes that the base budget for the current year is to be the sum of the base budget for the previous year, plus the actual expenses for the previous year.
We recommend that a calculation code be established to clear the balances on all accounts. Each time a Budget Projection is run, the results are cumulative. If you do not wish previous balances to be considered in each projection run, a code must be set up as follows:
CALCULATION #
CLEAR ALL BUDGET FIELDS
-
- #BUBA=#BUBA-#BUBA
-
- #BUIN=#BUIN-#BUIN
-
- #BUDE=#BUDE-#BUDE
-
- #BUNE=#BUNE-#BUNE
All calculations by numeric should be rounded to 2 decimal places. The valid Budget Symbols for use in the Parameter Calculations fields are:
UNIT: The unit types as specified in the BPS Profile Record. BUBA: Base Budget for the specified year.
BUIN: Increase in budget for the specified year. (Option 1) BUNE: New budget money for the specified year. (Option 2) BUDE: Deleted budget for the specified year. (Option 3) ACEX: Actual expenses for the specified year.
ORBU: Original budget for the specified year. ACBU: Actual budget for the specified year.
FACT: The factor, as defined in the Specifications Module. LOLM: The low limit, as defined in the Specifications Module. HILM: The high limit, as defined in the Specifications Module. XX??: The work field for the calculation (literals may be used).
+ : Addition
- : Subtraction
* : Multiplication
/ : Division
= : Equal to
NOTE: THE RESULTS OF A DIVISION BY ZERO, WILL ALWAYS BE EQUAL TO ZERO!!!