Author
Updated
2/16/2021Released
1/9/2018Note: Because this is an ongoing series, viewers will not receive a certificate of completion.
Skill Level Intermediate
Duration
Views
- [Bonnie] Hi, Bonnie Biafore here. Contingency funds represent money that management hands out to respond to issues that arise. In this tip, I'll show you how to create formulas to track contingency fund status. So here we have our project and we've already created the custom view to track these funds. And I have the four custom fields that I created in the previous tip already in the table. Now we're going to add calculations to the fields. We don't have to do anything with total contingency because that's just a value that's associated to the entire project and we've entered that value. So we're going to start with allocated contingency. I'm going to right-click that heading. And then on the shortcut menu, choose Custom Fields. Now, management may allocate the funds, not only to the project, but to the tasks within the project. What we want to do is we want to make sure that we are tracking how much has been allocated from that total. So once we select the field, I'm going to go down to where it says Calculation for task and group summary rows. I'm going to select Rollup. And the function that I want is sum. That Way, the allocated contingency is summed up all the way to the project summary task. So management will know when everything is handed out. Now we're going to go to Used Contingency and we're going to do exactly the same thing because we want to see that rolled up all the way to the top of the project. So I'm going to select Rollup in the calculation section and choose Sum. So the last thing we have to do is the remaining total contingency, and this does have a formula but it's really simple. I select that field and then click Formula. The first thing I insert is total contingency. I click the Field button, point at Cost, Custom Cost, and then choose Total Contingency. Then I'm going to add the minus sign and I'm going to subtract the used contingency. So I'm going to click Field, point at Cost again, go to Custom Cost, and this time choose used contingency. And that's the formula. So I'm going to click OK and then click OK to dismiss this message about the existing data. Once again, we want to roll this up. So in the calculation section, I'm going to select Rollup. But as opposed to using the sum, I'm going to use this Use formula button. So I select that, and then I'm going to click OK. You can see that the allocated contingency rolls up and the remaining total rolls up, but let's go ahead and go back to our task 13, which has $2,000 allocated. If you look over at the variance column, $1,300 was spent over what was budgeted. And let's say that that money was used to correct whatever the issue was. So let's add that into the used contingency cell for that task. When I do that, because I rolled up used contingency, you'll see that the summary tasks have that value. And when I go back up to the top, it rolls up all the way to the project summary task. And that way, you can see that the remaining total contingency has what's been used deducted from what management gave the project. And that's how you track the consumption of contingency funds with project custom fields.
Related Courses
-
Outlook Quick Tips
with Garrick Chow33m 46s Intermediate -
Excel: PivotTables for Beginners
with Dave Ludwig23m 52s Beginner
-
New This Week
-
Introduction
-
Welcome50s
-
-
Previous Microsoft Project Tips
-
Create a hammock task4m 7s
-
Rename column headings3m 58s
-
Save a new view5m 53s
-
Find hidden task bars4m 56s
-
Set additional baselines5m 6s
-
Find a command4m 29s
-
Track ancillary project costs11m 33s
-
Designate who reports status3m 21s
-
Control how a view prints5m 42s
-
Switch date constraints2m 21s
-
Data entry shortcuts2m 46s
-
Find in-progress assignments3m 13s
-
Beware the Autolink option3m 48s
-
Make exporting data easy5m 22s
-
Set currency options1m 47s
-
Update OLE links3m 58s
-
Share customized elements3m 31s
-
Document your customizations4m 23s
-
DEPRECATED
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Contingency funds, part 2: Calculate used funds