#19 eChecklist by-Control Statistics

[JeffOdegard]

Add a tab to the eChecklist that provides statistics for each checklist tab based on affected RMF control familiies. This is very useful for analysis and reporting, and would be part of the Sagacity Pro release.

There is a sample with all the formulas needed in Google Drive, Sagacity, RMF called eChecklist-analysis tab. You would add this tab after the cover sheet tab, and add a section for each checklist tab. This would require that the IA Control column on the spreadsheets contain RMF controls rather than CCIs (which is another PRO feature).

I had to build this tab manually, and it was very time consuming. I think it could be done pretty quickly by Sagacity on eChecklist import, since you are just adding the columns to the analysis tab and the appropriate formulas. Excel does all the computation. (Although these numbers would be helpful for a procedural analysis page in Sagacity, too. - maybe 1.3.4)
eChecklist-analysisTab-15Aug17 (1).xlsx