{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["MetricsCollection (1)","Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"MetricsCollection (1)","index":0,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,9],[22,0,22,9]]}
["Metrics Collection"]
["Project","Reference Point","Estimated/Planned Size (in SP)","Plan Start Date","Act. Start Date","Plan End Date","Act. End Date","Plan Effort","Actual Effort","Delivered Size (in SP)"]
["AIA HTML5","Product Sprint 21/25-Nov-16",23,"2016-10-31","2016-10-31","2016-11-25","2016-12-05",560,399.85,19]
["AIA HTML5","Product Sprint 29/13-Feb-2017/Bug Fixing",14,"2017-02-01","2017-02-03","2017-02-13","2017-02-14",144,139.80000000000001,14]
["AIA HTML5","Product Sprint 23/27- Dec-2016/Dissectible Anatomy Bug fixing",10,"2016-12-06","2016-12-06","2016-12-27","2016-12-27",512,366.8,10]
["AIA HTML5","Product Sprint 15/14-Oct-16",10,"2016-10-10","2016-10-10","2016-10-14","2016-10-14",140,123.7,1]
["AIA HTML5","Product Sprint 27/06-Jan-2017/13 Jan. 2017",87,"2016-12-28","2016-12-30","2017-01-13","2017-01-13",500,518.79999999999995,12]
["AIA HTML5","Product Sprint 14/7-Oct-2016",2,"2016-10-03","2016-10-03","2016-10-07","2016-10-07",205,202.2,0]
["AIA HTML5","Product Sprint 16/21 Oct 2016",14,"2016-10-17","2016-10-17","2016-10-21","2016-10-21",140,31.5,3]
["AIA HTML5","Product Sprint 12/23-Sep-2016",15,"2016-09-19","2016-09-19","2016-09-23","2016-09-23",205,165.6,12]
["AIA HTML5","Product Sprint 11/16-Sep-2016",11,"2016-09-12","2016-09-12","2016-09-16","2016-09-16",205,159,4]
["AIA HTML5","Product Sprint 13/30-Sep-2016",11,"2016-09-01","2016-09-26","2016-09-30","2016-09-30",205,103,11]
["AIA HTML5","Product Sprint 9/2-Sep-2016",35,"2016-08-29","2016-08-29","2016-09-02","2016-09-02",205,256.2,24]
["AIA HTML5","Product Sprint 10/9-Sep-2016",20,"2016-09-05","2016-09-05","2016-09-09","2016-09-09",205,111.5,5]
["AIA HTML5","Product Sprint 8/26-Aug-2016",61,"2016-08-22","2016-08-22","2016-08-26","2016-08-26",140,140,25]
["AIA HTML5","05-Aug-2016/Clinical Illustrations",1,"2016-07-01","2016-07-01","2016-07-31","2016-07-31",60,68,1]
["AIA HTML5","05-Aug-2016/Clinical Animations",1,"2016-07-01","2016-07-01","2016-08-05","2016-07-31",60,68,1]
["AIA HTML5","05-Aug-2016/Authentication and Authorization",3,"2016-08-01","2016-08-01","2016-08-05","2016-08-05",42,45,1]
["AIA HTML5","05-Aug-2016/Dissectible Anatomy",14,"2016-07-01","2016-07-01","2016-08-05","2016-08-05",450,362.5,12]
["AIA HTML5","Product Sprint 4/May 31",12,"2016-05-16","2016-05-16","2016-05-31",null,122,0,0]
["AIA HTML5","Product Sprint 1/15 Apr 2016",5,"2016-04-01","2016-04-01","2016-04-15","2016-04-15",165,147.15,3]
["AIA HTML5","Product Sprint 3/May 13",8,"2016-05-01","2016-05-01","2016-05-13","2016-05-13",80,74.5,8]
["..............................End Of Report..................................."]

{"sheet":"Sheet1","index":1,"n_rows":57,"n_cols":18,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["Project","Reference Point","Estimated/Planned Size (in SP)","Plan Start Date","Act. Start Date","Plan End Date","Act. End Date","Plan Effort","Actual Effort","Delivered Size (in SP)","Testing ","Review","code","Analysis ","DRE","Productivity","SP in estimation model"]
["AIA HTML5","Product Sprint 21/25-Nov-16",253,"2016-10-31","2016-10-31","2016-11-25","2016-12-05",2702,399.85,253,71,11,250,2,0,5.0599999999999996,253,25]
["AIA HTML5","Product Sprint 22/2-Dec-16",218,"2016-11-25","2016-11-25","2016-11-30","2016-12-05",2326,264.60000000000002,218,44,9,152,0,100,6.59]
["AIA HTML5","Product Sprint 23/27- Dec-2016/Dissectible Anatomy Bug fixing",114,"2016-12-06","2016-12-06","2016-12-27","2016-12-27",1217,366.8,114,135.4,19.5,187.5,0,83.33,2.4900000000000002,114]
["AIA HTML5","Product Sprint 27/06-Jan-2017/13 Jan. 2017",87,"2016-12-28","2016-12-30","2017-01-13","2017-01-13",996,518.79999999999995,94,51.3,35,292.5,0,100,1.45]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Code Productivity","Analysis Rate","Productivity"]
[null,null,null,null,null,null,null,null,null,1.012,126.5,5.0599999999999996]
[null,null,null,null,null,null,null,null,null,1.434210526,0,6.59]
[null,null,null,null,null,null,null,null,null,0.60799999999999998,0,2.4900000000000002]
[null,null,null,null,null,null,null,null,null,0.32136752099999999,0,1.45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K2/J2","v":0.28063241106719367},null,"target = .33"]
[null,null,"Productivity",null,null,null,null,null,null,"dre ",null,null,null,null,null,{"$f":"K3/J3","v":0.20183486238532111}]
[null,null,null,"UCL","LCL","Mean","Standard deviation ",null,null,"testing","review","dre",null,null,null,1.1877192982456142]
[null,null,"Coding",2.2050000000000001,-0.5,0.84,0.48,null,null,0.28063241100000003,4.3478260999999997E-2,0,null,null,null,0.54574468085106376]
[null,null,"Analysis rate",143.80000000000001,-80.5,31.6,0.06,null,null,0.201834862,4.1284403999999997E-2,100]
[null,null,"Produuctivuty ",9.81,-2.02,3.9,2.35,null,null,1.187719298,0.17105263200000001,83.33]
[null,null,null,null,null,null,null,null,null,0.54574468099999995,0.372340426,100]
[]
[]
[null,null,null,"prod","coding","analysis",null,null,"DRE","Screen 4"]
[null,null,null,1.4322029999999999,18.760000000000002,3.5000000000000003E-2,null,null,null,null,"ucl","lcl","Mean","sd"]
[null,null,null,null,null,null,null,null,null,"Testing",2.0699999999999998,0.95,0.55000000000000004,0.44]
[null,null,null,null,null,null,null,null,null,"Review",0.45,0.13,0.15,0.16]
[null,null,null,null,null,null,null,null,null,"Dre",189,-47,70.8,47.87]
[]
[]
[null,null,null,null,null,null,null,null,null,"What if analysis"]
[]
[null,null,null,null,null,null,null,null,null,"DRE","Testing","Review"]
[null,null,null,null,null,null,null,null,null,62.277500000000003,0.55000000000000004,0.15]
[null,null,null,null,null,null,null,null,null,63.877249999999997,0.60499999999999998,0.16500000000000001]
[null,null,null,null,null,null,null,null,null,65.477000000000004,0.66,0.18]
[null,null,null,null,null,null,null,null,null,68.676500000000004,0.77,0.21]
[null,null,null,null,null,null,null,null,null,71.876000000000005,0.88,0.24]
[null,null,null,null,null,"After what if analysis ne rangs ",null,null,null,75.075500000000005,0.99,0.27]
[null,null,null,null,null,null,null,null,null,77.099374999999995,1.0175000000000001,0.3]
[null,null,null,null,null,"USL","LSL","Mean","SD",78.731375,1.0175000000000001,0.33]
[null,null,null,null,"Testing",2.3374999999999999,-0.30249999999999999,1.0175000000000001,0.44]
[null,null,null,null,"Review",0.81,-0.15,0.33,0.16,null,"85% increse",2.2000000000000002]
[null,null,null,null,"DRE",222.341375,-64.878625,78.731375,47.87]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Amrita from minitab"]
[]
[null,null,null,null,null,"Testing","Review","DRE"]
[null,null,null,null,null,0.28062999999999999,4.3478000000000003E-2,0]
[null,null,null,null,null,0.20183000000000001,4.1284000000000001E-2,100]
[null,null,null,null,null,1.1877200000000001,0.17105300000000001,83.33]
[null,null,null,null,null,0.54574,0.37234,100]

{"sheet":"Sheet2","index":2,"n_rows":35,"n_cols":18,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Project","Reference Point","Estimated/Planned Size (in SP)","Plan Start Date","Act. Start Date","Plan End Date","Act. End Date","Plan Effort","Actual Effort","Delivered Size (in SP)","Testing ","Review","code","Analysis ","DRE","Productivity","SP in estimation model"]
["AIA HTML5","Product Sprint 21/25-Nov-16",253,"2016-10-31","2016-10-31","2016-11-25","2016-12-05",2702,399.85,253,71,11,250,2,0,5.0599999999999996,253,25]
["AIA HTML5","Product Sprint 22/2-Dec-16",218,"2016-11-25","2016-11-25","2016-11-30","2016-12-05",2326,264.60000000000002,218,44,9,152,0,100,6.59]
["AIA HTML5","Product Sprint 23/27- Dec-2016/Dissectible Anatomy Bug fixing",10,"2016-12-06","2016-12-06","2016-12-27","2016-12-27",1217,366.8,114,135.4,19.5,187.5,0,83.33,1.45,114]
["AIA HTML5","Product Sprint 27/06-Jan-2017/13 Jan. 2017",87,"2016-12-28","2016-12-30","2017-01-13","2017-01-13",996,518.79999999999995,12,51.3,35,292.5,0,100,0.19]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"coding productivity","anlysis rate","Productivity"]
[null,null,null,null,null,null,null,null,null,0.63273727599999996,1.5804347830000001,5.0599999999999996]
[null,null,null,null,null,null,null,null,null,0.82388510999999998,1.213761468,6.59]
[null,null,null,null,null,null,null,null,null,0.31079607399999998,3.2175438600000001,1.45]
[null,null,null,null,null,null,null,null,null,2.3130300999999999E-2,43.233333330000001,0.19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"target = .33"]
[null,null,"Productivity","Column1","Column2","Column3","Column4",null,null,"DRE"]
[null,null,null,"UCL","LCL","Mean","Standard deviation ",null,null,"testing","review","dre"]
[null,null,"Coding",1.327,-0.432,0.44800000000000001,0.35339999999999999,null,null,0.28063241100000003,4.3478260999999997E-2,"DRE"]
[null,null,"Analysis rate",49.89,-25.27,12.31,20.63,null,null,1.187719298,1.187719298,0]
[null,null,"Produuctivuty ",10.35,-3.71,3.32,3.0009999999999999,null,null,4.2750000000000004,4.2750000000000004,83.33]
[null,null,null,null,null,null,null,null,null,null,null,100]
[]
[]
[null,null,null,"prod","coding","analysis"]
[null,null,null,1.4322029999999999,18.760000000000002,3.5000000000000003E-2]
[]
[]
[]
[]
[]
[]
["Defect Removal Effectiveness (In %)","Testing Efficiency ","Testing "]
[0,0]
[100,0]
[100,0]
[83.33,0]