Velocity Chart

[Frank Bacchus]

Hi All:

Have you developed a Velocity Chart before? In my attached spreadsheet I have several variables to consider for this problem:

(1) Individuals
(2) Number of closed issues
(3) Number of added issues
(3) Issue Creation Date
(4) Issues Closed Date (Modified Date)
(5) Issue effort level (L, M, H)
​

I am trying to find out (1) the overall rate of closure from the create date to the closure date (status = close, modified date) (2) Overall closure rate by individual (3) the overall closure rate for each effort level and (4) the closure rate for each individual within their effort level (H,M,L). In essence, velocity rate in closing issues. What's your thoughts?

thanks

frank

 

[Faseeh]

Please see attachment. Hope it works for you.

 

[Frank Bacchus]

View attachment 35110 Please see attachment. Hope it works for you.

Faseeh: Thanks. Just reviewing it, it looks as if you calculated the averages for all cases. In essence, the average number of day is the velocity rate. One last question, I see you populated column "L" in the data sheet with a count of how many issues an individual worked on, where else did you use this column? Thanks

frank

 

[Faseeh]

Hello Frank,

I used Col L to filter out unique names from the list, you delete it if you want. BTW was that sheet helpful or was just another sheet? Is the averaging method correct or you were looking for something else?

 

[Frank Bacchus]

Hello Frank,

I used Col L to filter out unique names from the list, you delete it if you want. BTW was that sheet helpful or was just another sheet? Is the averaging method correct or you were looking for something else?

Faseeh:

Thanks for the response. I appreciate it. I am still trying to grasp the methods you used. The results looked good and I was wondering how to best represent it in a Pivot Chart. Any Ideas? We have set a standard where we say that a low issues takes 3 days, a medium issue takes 5 days and a High issue takes 10 days. This exercise is to check how well we are doing relatively to those standards and how we can improve the throughput. Any ideas will help. Thanks.

frank

 

[Faseeh]

Hello,

Glad it is helpful. Please see the chart for analysis of effort level against standard and avg value. We can create a dashboard (sought of). You need to select the effor level from R20

 

[Frank Bacchus]

Hello,

Glad it is helpful. Please see the chart for analysis of effort level against standard and avg value. We can create a dashboard (sought of). You need to select the effor level from R20

View attachment 35155

Faseeh:

This looks super. What would the dashboard look like with all the pertinent information for the analysis?

frank

 

[Faseeh]

Thank you. We can create two more charts: person vise closure and level vise closures. Any thing else you can suggest.

 

[Faseeh]

Please see attachment

 

[Frank Bacchus]

View attachment 35161 Please see attachment

Faseeh:

This looks good. I need to review it to see if I can understand the concepts behind it . I want to create 2 other simple (1) a chart with 3 trend lines that would should Open, Closed and Added items over time (I would continuously add data to it) and (2) how can I tell if the individuals are getting better over time. Thoughts?

frank

 

[Faseeh]

Sorry for replying late, today was a busy day at office. Plz see attachment, avg values of individuals over time. I have been unable to understand your first idea, can you explain it?

 

[Frank Bacchus]

Sorry for replying late, today was a busy day at office. Plz see attachment, avg values of individuals over time. I have been unable to understand your first idea, can you explain it?

Thanks Faseeh. I don't think the attachment is for what we have been discussing. This is associated to "Roadside Assistance Service Comprehensive & Third Party Cover Only"

Basically, the first chart I was mentioning is, what I call, a continuous measurement chart, with three lines - (1) for open items at a point in time, (2) one for closed items at a point in time and (3) a third trend line total new (added) at a point in time. Something that looks like Sheet4 in the Sample attachment.