Health Checks

Run a Defense Contract Management Agency 14 Point Health Check for All Tasks or Select Tasks. Even the CPLI and Critical Path checks can be ran.

Setup

ItMakesSense was built with a focus on exporting to Excel first, not building forms that can't be returned to without running the tool again. Several methods have been created to view the data in MS Project.

Below is the button you select in the MS Excel Add-in to show the current list of tasks in MS Project. One nice feature is that you can filter tasks in the 14pt/DECM checks and only visible tasks (unfiltered) will be shown in MS Project.

Clipboard filter can also be used to isolate tasks you want to show in MS Project. Clipboard filter can be used in any application without an add-in.

You can find the setup for the 14pt Healthcheck in Application Settings - 14 Pt HC tab. The 14 Point Health Check only works on tasks that are baselined. The number of tasks that are not baselined show up under 'Not Baselined'. These settings are a one-time setup and saved in the tools ProgramData folder.

The fields you select here show up in Columns P-AJ in the report. Below is an image of the 14 Point Health Check settings screen.

Most reports are designed to cross utilize multiple tabs. The 14 Point also utilizes the Cobra tab to get report data. In this way more fields are available to export.

MS Excel Worksheets

The tool creates a worksheet for each check and a summary page. A hyperlink is on the summary page pointing to the applicable check and each check has a hyperlink in cell A1 that returns to the summary page. As mentioned above, Clipboard Filter or 'View HC Data in Project' will display the list of tasks/milestones in the current worksheet in MS Project.

Here is a list of the MS Excel sheets that are created

  • Summary
  • Missing Logic
  • Leads
  • Lags
  • Relationship Types (A sheet for each type)
  • Hard Constraints
  • High Float
  • Negative Float
  • High Duration
  • Invalid Dates
  • No Resources
  • Missed Tasks
  • Critical Path Length Index
  • Baseline Execution Index

You can choose to export external tasks or summary tasks with the check box's at the top. At the bottom of the settings page you can choose a field to exclude tasks that are set to True/Yes. You can also isolate tasks by selecting run on selected tasks at the first prompt.