Excel Tips

Excel Tips:

1. Convert Xd Xh, e.g. 2d 3h to hours

=IF(ISNUMBER(FIND("d",A1)),LEFT(A1,FIND("d",A1)-1)*8)+IF(ISNUMBER(FIND("h",A1)),MID(0&A1,MAX(1,FIND("h",0&A1)-2),2))

CMMI Constellations

A good presentation on CMMI Constellations: http://www.gpiasia.net/wp-content/uploads/2010/02/presentation-cmmi_overview.pdf
CMMI Contellations demystified: http://www.jcse.org.za/upload/events/76/cmmi_constellations.pdf
CMMI Constellations (misses service constellation): http://seispin.wikispaces.com/file/view/CMMI+on+the+Web.pdf

CMMI Tutorial

This is a nice training on CMMI
http://www.tutorialspoint.com/cmmi/index.htm

SDLC Links

https://buildsecurityin.us-cert.gov/bsi/articles/knowledge/sdlc/326-BSI.html

Estimation Techniques Tools: http://www.nysforum.org/documents/pdf/pmo-9-30-04/EstimatingTechniquesandTools.pdf

Software Estimation: http://www.softwaremetrics.com/Articles/estimating.htm

Lean Tools - Software Configuration Management

* Visual Control Charts:
For important / critical CIs - have visual control charts with information of: CI version, CI status (checked-in, out) ,Person working on CI, Changes being made to CI, Expected date of completion, % completion, storage location of CI, etc.

* 5S:
To establish configuration management process - as per my earlier blog

* DSM (Design Structure Matrix):
To understand the dependencies of CIs and complexity wrt - # of CIs having same cluster, # of people working on the same CIs, etc. Following are the other benefits you may achieve using DSM:

1. Creating teams / modules - depending upon the CI cluster
2. CI dependecies / Impact Analysis
3. CI complexity - Higher the CI interaction, higher is the complexity
4. Planning / scheduling of CI work
5. CIs that can be developed in Parallel - Concurrent Engineering

Applying Lean principles in SCM

7 Wastes:
1. Overproduction - sharing the links of the folders containing latest version rather than sending the latest document thru emails
2. Waiting Time - Notification of check in, check out
3. Defects - Always the use of latest version (system not allowing wrong naming convention to be entered)
4. Overprocessing - Automation of : status accounting, configuration audits, Archiving of the old files
5. Transportation - Folder structure (storing files) , naming convention, indexing (path of files), sending links of folder containing latest version,
6. Inventory - status accounting and Indexing ( can be automated)
7. Motion - Indexing of files will help in searching of files, creating shortcuts / links to he files & folders

Lean in Configuration Management

- Using 5S principles in Software Configuration Management
1st S (Sort) -
Logical folder structure - based on way of working (PMI, Prince2, etc.)
Naming Convention
2nd S (Set in Order) -
Create a common share drive, sharepoint, CM Tool
3rd S (Shine) -
Status Accounting,
CI Indexing
4th S (Standardise) -
Trainings??
5th S (Sustain) -
Configuration Audits