How It Works
There are four standard features available in the Budget tab. As an admin, you can choose which features to use and how you’d like to set them up.
The first, smaller table has up to 10 line items and is great for capturing funding sources. There are up to five columns available for applicant data entry, and up to five extra columns can be added to present calculated data to administrators and reviewers in their version of the application, as well as in the application’s print preview or PDF versions.
The second, larger table has up to 20 line items and is great for capturing funding uses. As with section 1, there are up to five columns available for applicant data entry, and up to five extra columns can be added to present calculated data to administrators and reviewers in their version of the application, as well as in the application’s print preview or PDF versions.
Budget Total Comparisons
These two fields can be used to compare the totals from any column in either of the budget tables – including the columns of applicant data and the calculated columns. The results of the comparison(s) are displayed to the reviewers and administrators in their version of the application, as well as in the application’s print preview or PDF versions.
This feature is especially helpful if applicants are required to have a certain percent match, or if the totals of columns from the two tables need to match. The system can do the calculation for you and present the results to administrators and reviewers right there within the application.
This feature presents a paragraph-style text field to the applicants in which they can provide a narrative response, according to whatever instructions you provide.
The Contract Budget feature is part of the Funding Sources feature. Please contact us more information about this feature.
How To Set It Up
- In Program Setup, click into the Settings tab.
- Turn the Budget module ‘on’.
- Click into the Budget tab.
- Give the tab a Tab Label and provide instructions for your applicants.
- Set up the features that you’d like to use (complete instructions below).
- Use the Applicant View to check your work.
Sections 1 & 2
- Decide whether you want applicants to be able to edit the item descriptions/line items.
- Choose ‘Yes’ to allow your applicants to enter their own items and/or edit those that you have entered as your defaults. Applicants will be able to use up to 10 line items in the section 1 and up to 20 in section 2.
- Choose ‘No’ to prevent your applicants from entering their own or editing those that you have set up. Applicants will be limited to the line items that you have entered (up to 10 in section 1 and up to 20 in section 2).
- Provide instructions.
- Give the section a title.
- Pre-populate line items (if applicable).
- If you are allowing the items to be edited by the applicants, applicants will be presented with every line in the section, regardless of whether you enter a sample description. You can leave them all blank, if you want applicants to enter their own items.
- If you are not allowing the applicants to edit the items, only those lines with text in the Item Description fields will be presented. Applicants will not be able to use the additional lines.
- Add Column Headers – Only columns with headers will be displayed.
- Add Calculated Columns – Click the show/hide link to add or edit your calculated columns. For admins and reviewers, calculated columns appear, in grey, alongside the applicant-provided data. Applicants can refer to the print preview or PDF version of their applications to see the calculations.
- Column Title
- Field 1 Column – What column do you want to use as the first part of the calculation?
- Operator – What do you want to do in your calculation?
- addition (+)
- subtraction (-)
- multiplication (*)
- division (/)
- % of total – Ex: (A/total of B)*100, where Field 1 Column is A and Field 2 column is B
- % of field – Ex: (A/B)*100, where Field 1 Column is A and Field 2 column is B
- % change – Ex: ((B-A)/A)*100, where Field 1 Column is A and Field 2 column is B
- sum (multi) – Ex: A+B+C+D, where A is the Field 1 Column and D is the Field 2 column
- Field 2 Column – What other column are you using in your calculation?
- Position After Column – After what column do you want this calculated column to appear?
Budget Total Comparison
- Add a Budget Total Comparison label.
- Set up your formula.
- Use the dropdowns to choose which columns to include in your calculation. The system will pull the totals from those columns to use in the calculation.
- Choose the operator to use in the comparison of the totals from each column.
- Type a description to explain what the calculation represents.
- Turn it ‘on’.
- Enter your instructions.
The character limit will be the same as the program default character limit, as set in the Settings tab.
One of the budget tables isn’t showing up.
A section will show up as soon as it has a title and at least one column header. If a table is not appearing, verify that you have entered a title and set up one or more columns. If you’re not allowing applicants to edit the item descriptions, be sure that you have also entered at least one line item.
Calculated columns do not appear for the applicants.
Calculated columns are presented to admins and reviewers in their version of the application. Applicants can see the calculated columns in the print preview or PDF versions of their applications.
An applicant needs more line items.
Section 1 can have up to 10 lines. Section 2 can have up to 20 lines. If you’ve chosen to allow applicants to edit the line item descriptions, they’ll be able to have up to the maximum number of lines in each section. If you are not allowing applicants to edit the line items, they’ll be limited to the standard items that you have set up. Additional lines are not available.