What are Fixed Calc Entries and How Can They Be Used? Article

What are Fixed Calc Entries and How Can They Be Used? Article

Fixed Calc Entries are a spreadsheet-like data entry form in which the rows can be user specified and the columns are the months in the fiscal year.  Fixed Calc Entries spreadsheets are setup on the Manage Fixed Calc Templates and Configure Fixed Calc Variables screens.  The spreadsheets are viewed and depending on how the spreadsheet template is setup, user controlled data is entered on the Fixed Calc Entry screen.  


The functionality that is available to setup and customize the spreadsheet is discussed in detail on the Manage Fixed Calc Templates and Configure Fixed Calc Variables screens.  Below are some example of how this functionality can be used.


A.  User Enters Total Number of Units to be Sold which is then Allocated Using a Formula to Specific Products.  Revenue per Product is Calculated 

This is how the Manage Fixed Calc Template screen would be setup:




And this is how the Fixed Calc Entry screen would look to the user:



1. Number of Units Sold entered by User, in this case, Patient Encounters.

2. Percent allocated to each product entered by User (Multiplier) and then calculation is according to setup.

    • Related Articles

    • Allocations By Accounts - Fixed Article

      The Allocations module provides different methodologies to both calculate the amount to be allocated and how it is allocated. The amount is allocated to designated Budget Account/s (the "Destination Account/s"). To designate a Budget Account as a ...
    • Allocations By OrgUnits - Fixed Article

      The Allocations module provides different methodologies to both calculate the amount to be allocated and how it is allocated. The amount is allocated to designated Budget Account/s (the "Destination Account/s"). To designate a Budget Account as a ...
    • Lookup Article

      This standard functionality provides the ability to access data that is within the system and then copy the data to the appropriate Assumption Grid. The general process will be discussed first followed by a review of the available data. The Lookup ...
    • Can I Change the Number of Annual Payroll Hours Used in Calculations? Article

      The number of hours can be changed on the App Config/Menu Editor as per below.  Enter the number of hours you would to use and then click . For example, the number of hours per payroll year is used in calculating the AnnualizedSalary on Hourly ...
    • Column Formats Article

      Column formats can be defined in the following Setup screens: Define Custom Reports; Define Basic Budgets Entry Forms; and Define Custom Budgets Entry Forms. There are two options to setup Column formats: a) Grid Layout Tab This format supports Copy ...