Navigate to NUPlans Contributor
Navigation: NUPlans.northwestern.edu
Then click NUPlans Contributor Login.
- The Contributor applications page appears with a choice of budget preparation files by year.
- Click NUPlans_FYxx_Budget for the desired year. The Contributor Dashboard opens.
Contributor Dashboard
Navigational Icons
Located in the upper right corner of the Dashboard
State Icons
The dashboard tells you the status of the budget group in the State column.
Permissions Icons
Depending on the budget grouping you are working with and the permissions you have for it, you can submit a single child budget grouping, multiple children, or a parent budget grouping.
How to Open the Budget Preparation File
- If you have access to both child and parent (rollup) levels, expand the tree to see all budget groupings to which you have access.
- To enter budget data, click the name of the child budget grouping to open the budget preparation file in a new window.
- Alternatively, you may right-click the child in the expandable tree at left and click Open NUPlans Contributor.
Contributor Budget Preparation File
Contributor Toolbar Icons
Icons used by NU are described below in order of appearance. Active icons are in color. Inactive icons are grayed out.
|
Icon
|
Name
|
Description
|
|
|
Actions Menu
|
The Actions Menu groups some icons and functions:
 Export data in the following formats:
Slice to Excel – not recommended
Snapshot to Excel - Exports data to a new Excel spreadsheet, excluding the formulas. The spreadsheet does not maintain a connection with the server.
Export to PDF - not recommended. Export to Excel, then convert to PDF.
 Reset Data enables you to erase all changes you made since you last took ownership and committed data. Use this feature carefully, because all changes saved to your personal folder are lost. It erases data in green or blue.
 Reset View reestablishes the default layout of the view(s) and restores all default behavior, including auto- recalculation and zero suppression.
· Reset Current View – affects only the view you are currently working in
· Reset All Views – affects all views
· Reset Tabs– restores all tabs to their original default order
· Reset Both Views and Tabs - restores all views/tabs to their default behavior
 – Closes the grid. The dashboard remains open.
|
|
|
Commit
|
Commit also saves and recalculates. Additionally, it makes your changes public. Commit does not lock the budget from additional changes. You should commit data early and often to ensure your colleagues see the most up-to-date budget preparation file.
|
|
|
Take Ownership
|
To add or edit data, you must first take ownership of the budget preparation file. There may be one owner at a time.
|
|
|
Submit
|
Submitting data saves the budget preparation file and locks it from further changes. It signals to the next reviewer to begin the review.
|
|
|
Copy
|
Copy data to paste it to other cells. You may also right-click in a cell to find it.
|
|
|
Paste
|
Paste copied data into cells. Use the toolbar, or right-click in a cell to find it.
|
|
|
Undo
|
Undo the last recalculated data change. If you recalculated multiple times, you can undo/redo multiple times. When you undo, all affected values are also undone, even in cells not visible on the active view. Undo/redo applies only to the current logged in session. After you commit data, you cannot undo.
|
|
|
Redo
|
After you undo a data change, you can restore the change.
|
|
|
Recalculate
|
Recalculate saves the data you entered, runs all related calculations, updates and saves all affected cells in the budget preparation file.
A keyboard shortcut is the <Enter> or <Return> key.
Recalculate allows you to see the effect of your data entry before making it public. Recalculated data is saved in a secure but personal folder on the NUPlans network server. You may close the budget preparation file knowing your data is saved for personal use and resume work on the budget at a later time. However, your data entry is not public. Colleagues cannot see it.
|
|
|
Help
|
TM1 Application Web Help - opens the TM1 Applications Guide in a new tab
View Help – Specifically written for Northwestern budgeters
|
Budget Data Entry Workflow
1. Take Ownership
If you are not the current owner, the budget preparation file opens in view-only mode. Before you can edit data, you must take ownership.
- Click the Take Ownership
icon if the dashboard indicates the state is available.
- If someone else has ownership, you will receive an error if you try to take ownership.
- The current owner must release their ownership to you using this icon
on the Contributor Dashboard.
- Once you have taken ownership, the budget grid changes from view-only to edit mode.
- Cells that you can edit now have a white background.
- Cells that are read-only have a gray background.
2. Edit Data
Edit a value in a white cell in one of the following two ways.
- Replace a value – Single-click a white cell and type any value to replace the existing value. The data you entered is green to indicate it is new but not saved. Exit the cell with the arrow keys on your keyboard to move left, right, up, or down; or use your mouse to move through the grid.
- Selectively edit a value – Double-click a white cell to insert the cursor so that you can selectively edit. Position the cursor with the left and right arrow keys, then add, change, or delete. Use the
<Backspace> and <Delete> keys to remove one digit at a time. Exit the cell using <Tab> or
<Shift>+<Tab>.
3. Recalculate Data
- When you are ready to save, click recalculate
or press the Enter key on your keyboard. Result: The view refreshes and calculations occur. Your data entries and all data affected by the calculation are blue to indicate the edits are stored securely on the NUPlans application server in your private folder. No one else can see your edits.
4. Commit data
- When you click the Commit icon
all edits are written to the public folder for the budget group. All users with access to your budget group can see the changes and continue editing.
- After you commit, values are black to indicate they are public again. Anyone may continue to edit the values (including yourself).
5. Submit a Child Budget Grouping to Reviewers
- Click the Submit icon
to initiate a review of the budget grouping.
- Click Yes to confirm. The result as it appears to reviewers is shown below.
- When you click Submit, the node is locked from all further edits.
- For that reason, do not click Submit until you are ready for the budget review.
- If you mistakenly click Submit, you may ask your Reviewer to reject the budget grouping, which will unlock the budget for further edits.
Budget Review Workflow
Reject a Budget Grouping
Reject is a solution if a budgeter clicked Submit by mistake. Budget groupings must be rejected at the child level.
1. On the Dashboard, locate the Name of the child budget grouping.
- Click the Reject icon
next to the name to request further edits to budget grouping.
- Click Yes to confirm. When you click Reject, the node is unlocked to allow further edits.
Submit a Parent Budget Grouping to Reviewers (Approve)
Budget groupings may be organized into parent levels that represent interim departmental or operational reviews. After the operational review, it is necessary to submit the parent budget grouping to a review by area finance. This is how you indicate approval.
- On the Dashboard, locate the Name of the parent budget grouping and confirm the state is Ready.
- Click the Submit icon
.
- Click Yes to confirm. Result: the next level of reviewers (area finance or the budget office) sees the state of the next parent level change to Ready.
Drill to Details
From most fund and compensation summary views of NUPlans, drills are available in many cells that lead to supporting detail.
- Right-click in the cell you wish to drill on.
- Mouse over the drill icon or the word Drill.
- Click the drill name.
- Result: the details appear in a new contributor tab to the far right.
- Be sure to close each new tab when you finish.
Drills in NUPlans Contributor
|
In this view
|
Right-click in these cells
|
And drill to
|
|
Comp Summary
|
Any cell in the view
|
Comp Pos Input Summary Map – Employee-level data
|
|
Comp Fund Overview
|
Any cell in the view
|
Compensation Position Input –
Funding source details per employee
|
|
Comp Budget by Chart String
|
Budgeted Salary from Comp Input
|
Compensation Pos Input Map
– Employee-level data
|
|
All Fund views
|
myHR Enc and myHR Act
(expand current FY YTD Obligations,
drill on salary accounts)
|
Compensation Pos Input Map -
– Employee-level data
|
|
All Fund views
|
Linked from Compensation (expand Total Linked In)
|
Compensation Chart String Input
|
|
All Fund views
|
Linked from Grants (expand Total Linked In)
|
Grant Drill Map – Grant details
|
|
All Fund views
|
Linked from Commitments (expand Total Linked In)
|
Commitment Transaction Map
– Commitment transactions details
|
Export Data to Excel
You can export data from Contributor views to Excel spreadsheets.
Steps
- On the toolbar, click the Actions Menu icon
.
- Select/hover over Export.
- Select Snapshot to Excel.
- Below the heading “Number of rows to export,” select the option that best encompasses the data you want to see:
- Export rows in the current page.
- Export rows from beginning to current page.
- Export all rows in the view.
Ignore the heading “Title dimension to export.”
- Click OK. Depending on which browser you are using:
- The file will open (Chrome, Firefox)
- The browser’s file download dialog appears (Edge).
- Open with Microsoft Excel (default) or
- Save File to save the file in a directory on your computer or network.
For additional assistance please contact the IT Support Center at 847-491-4357 (1-HELP) or email servicedesk@northwestern.edu.