Dr. Ralf Kneuper
Dr. Ralf Kneuper Consulting
Software Quality Management
and Process Improvement
Release Notes: PIID and SCAMPI Tool (PST) Version 1.3.3
Version 1.3.3 of PST does contain a number of small updates and corrections
but no major changes of functionality.
Migration of data
- Provided a functionality for copying PIIDs to a different file in the new
file PST-TransferPIID.xls. This can be
used to migrate PIID data to a new PST version, or to provide a revised PIID
back to the organization after an assessment. Please read the instructions
in this Excel workbook for details. (R71)
Note: This function is no longer available to non-registered users.
Changes in file names and structure
General and Instructions sheets
Findings sheet
- Filled cell AD3 of the Findings sheet which should reference
weaknesses for the instantiation ORG and SP1.1 but was empty
for the process areas on maturity level 3.
- Corrected typo "Signifcant" in cell AC2. (R73)
- Set the row height consistently to 12.5 pt in the findings sheet. (R42)
Practice sheets
- Added the lines 7 to 9 (which were previously empty) to
allow the organization to provide specific guidance to the projects
in filling in the PIID, such as typical work products in this
organization. Previously, this information was usually provided
in lines 12 and 13 but led to confusion with the genuine
artefacts of the organization considered as an instance in itself.
- Added "Source: Statement" in comment for F2F confirmations. (R74)
- Corrected typo "Strenght" in practice sheets. (R73)
- Corrected the protection which was sometimes applied to the wrong fields,
in particular to the process description fields. (R64)
- Formatting of goals was sometimes incorrect (bold, large typeface),
e.g. SG2 in SP 2.1 for OPF, OT and RSKM, IPM, SG1/SP1. (R68)
- Consistently added an identifier in front of all goal and practice statements
where the goal identifier includes the PA, the practice identifier does not
(since this would duplicate the information on the same page in consecutive
lines) (R72)
- The practice sheet for MA, SP2.3, did not allow "NA" as a legal entry for
"DA OK?". The item "NA" is missing in the value list. This has been
corrected. (R80)
Tracking workbook
- Corrected several incorrect links to the findings sheets
- Added links for maturity level 3 process areas
- Added sheets L2 and L3 which give a summary of the practice
characterizations but without the goals. Additionally, these
compute a CMMI satisfaction percentage for each process area
according to the following table. In order to use this table
for SCAMPI B and C which require a three-value scale, the
values PI and NI are considered identical. The resulting
percentages are visualized as a spider diagram.
| characterization | numeric value |
|---|
| FI | 1 |
| LI | 0,5 |
| PI | 0 |
| NI | 0 |
This change is a very first step in the way to support SCAMPI B
and C; further steps are planned to follow soon.
Configuration workbook
Open issues, requirements and known problems
| ID | Priority | Issue |
|---|
| R1 | low |
The LA should be able to see what
has been changed as compared to the previous version, perhaps
using a log file |
| R2 | low |
User (LA, assessment team, PIID author) and maintenance documentation. |
| R19 | medium |
If a practice is not applicable, e.g. a PP practice for ORG,
and you only add this information in column E in the practice sheet,
not column B (which would duplicate the information), then in both
the findings and the general sheet, the DA / IA counts as not written.
So you may end up with 100% of DA OK, but only 80% written |
| R31 | medium |
OU characterization of practices should not be allowed as long
as not all instances have been characterized (possibly "NA"). |
| R31a | medium |
Goal rating should not turn red when empty. If the OU practice
characterizations for one goal (column AK) are all filled with values
other than "FI", then goal rating can contain an arbitrary value
(other than "S") without turning red. (Perhaps handle using validation?) |
| R41 | low |
Distinguish "NA" and "not rated". Document both in instructions. |
| R54 | low |
Those parts of the "Findings" sheet that are decided by the whole team
(OU rating etc.) should be locked so they can only be changed with the LA
password. |
| R56 | high |
Write the administration data on the "General" sheet once in preparation
of the appraisal so that there is no more need for SCAMPI-CONFIG.xls.
This should also solve the problem that these references sometimes contain
the full path rather than just the filename, which leads to problems when
moving the files. |
| R57 | medium |
Rename remaining files, command bar as "PST ..." |
| R61 | high |
Also support SCAMPI B&C and support transitioning of data from
SCAMPI B&C to SCAMPI A |
| R62 | medium |
No characterization as long as information is needed |
| R75 | low |
Use white font on red backgrounds, in particular with conditional formatting, to
make it easier to read. |
| R76 | medium |
Correct references to "<PA>" in GP statements. |
| R77 | medium |
Consistent handling of "NA" in the percentages in row 1 of the findings sheet.
For IA the percentage should exclude NA entries. |
| R78 | medium |
Always show column AZ of findings sheet, but use white font to make it invisible.
Using conditional formatting, mark the cell red if the value is 1, i.e. there is an
inconsistency. |
| R79 | medium |
Fix the practice sheet after row 2 so that the practice statement always
stays visible. |
The following items refer to the macros which are not yet part of
the published version.
| ID | Priority | Issue |
|---|
| M1 | medium |
Expand macro "Release" for maintenance
with the following functionality: Set protection; hide columns |
| M2 | medium |
The macro CL2 should also work for the SCAMPI-Tracking.xls sheet. |
| M3 | medium |
Separate lock / unlock user entries and team entries.
Turn protection and unprotection into separate subroutines? |
| M4 | medium |
Generate reports such as "all missing information for project X", etc.
(probably using a macro) |
| M5 | medium |
Only make macros visible where that is needed.
Other macros should be private. |
| M6 | medium |
The macro SetVersion does not handle cancelling from the input box correctly.
Similarly, MarkNA and password check do no handle cancelling correctly. |
| M7 | high |
Convert the macros into VB6 and then publish them as part of the package. |
| M8 | medium |
Create a draft presentation from the results in the worksheets |
| M9 | medium |
Use constants everytime instead of literals |
| M10 | medium |
Set up systematic error handling. |
| M11 | high |
In OPD, mark as NA (e.g. "P1, P2, P3, P4")
⇒ ORG is marked NA. |
|
|