{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Defects","User Acceptance Testing","Production","Analysis","Summary"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":3,"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":"Defects","index":0,"n_rows":5,"n_cols":13,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,12],[1,0,1,12],[2,0,2,12]]}
["State of Michigan"]
["<Insert System or Project Name Here>"]
["Defect Tracking Log - Defects"]
["Defect #","Detected In","Security Role","Area or Deliverable","Detected By"," Detected Date","Defect Type","Priority","Status","Description","Assigned To","Resolution Date","Resolution"]
[1]

{"sheet":"User Acceptance Testing","index":1,"n_rows":5,"n_cols":13,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,12],[1,0,1,12],[2,0,2,12]]}
["State of Michigan"]
[{"$f":"IF(Defects!A2=\"<Insert System or Project Name Here>\",\"\",Defects!A2)","v":""}]
["Defect Tracking Log - User Acceptance Testing (UAT)"]
["Defect #","Detected In","Security Role","Area","Detected By"," Detected Date","Defect Type","Priority","Status","Description","Assigned To","Resolution Date","Resolution"]
[1]

{"sheet":"Production","index":2,"n_rows":5,"n_cols":13,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,12],[1,0,1,12],[2,0,2,12]]}
["State of Michigan"]
[{"$f":"IF(Defects!A2=\"<Insert System or Project Name Here>\",\"\",Defects!A2)","v":""}]
["Defect Tracking Log - Production"]
["Defect #","Detected In","Security Role","Area","Detected By"," Detected Date","Defect Type","Priority","Status","Description","Assigned To","Resolution Date","Resolution"]
[1]

{"sheet":"Analysis","index":3,"n_rows":71,"n_cols":5,"rows_kept":71,"cut":false,"hidden":false,"merged":[[6,0,6,18],[0,0,0,18],[1,0,1,18],[2,0,2,18],[4,0,4,18]]}
["State of Michigan"]
[{"$f":"IF(Defects!A2=\"<Insert System or Project Name Here>\",\"\",Defects!A2)","v":""}]
["Defect Tracking Log - Analysis"]
[]
["There are 3 pivot tables in this sheet.  Scroll down to view / access.   WARNING!  DO NOT REMOVE SPACING BETWEEN PIVOT TABLES - THIS SPACE IS NEEDED FOR PIVOT TABLE EXPANSION."]
[]
["To update / expand the Pivot Tables (each Pivot Table must be updated individually):\nRight Click anywhere within the desired Pivot Table then Click \"Refresh Data\" ( Red Exclamation Mark - ! )"]
[]
["Defect Analysis Pivot Table"]
[]
["Count of Defect #",null,"Status","Priority"]
[null,null,"(blank)","(blank) Total","Grand Total"]
["Detected In","Defect Type","(blank)"]
["(blank)","(blank)",1,1,1]
["(blank) Total",null,1,1,1]
["Grand Total",null,1,1,1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["UAT Defect Analysis Pivot Table"]
[]
["Count of Defect #",null,"Status","Priority"]
[null,null,"(blank)","(blank) Total","Grand Total"]
["Detected In","Defect Type","(blank)"]
["(blank)","(blank)",1,1,1]
["(blank) Total",null,1,1,1]
["Grand Total",null,1,1,1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Production Defect Analysis Pivot Table"]
[]
["Count of Defect #",null,"Status","Priority"]
[null,null,"(blank)","(blank) Total","Grand Total"]
["Detected In","Defect Type","(blank)"]
["(blank)","(blank)",1,1,1]
["(blank) Total",null,1,1,1]
["Grand Total",null,1,1,1]

{"sheet":"Summary","index":4,"n_rows":49,"n_cols":5,"rows_kept":49,"cut":false,"hidden":false,"merged":[[47,2,47,4],[48,2,48,4],[42,2,42,4],[43,2,43,4],[44,2,44,4],[45,2,45,4],[0,0,0,5],[1,0,1,5],[2,0,2,5],[46,2,46,4],[8,1,8,4],[20,1,20,4],[32,1,32,4]]}
["State of Michigan"]
[{"$f":"IF(Defects!A2=\"<Insert System or Project Name Here>\",\"\",Defects!A2)","v":""}]
["Defect Tracking Log - Summary"]
[]
[]
[]
[null,"DEFECT TALLY SUMMARY"]
[]
[null,"  Defect Tally"]
[null,"New:",{"$f":"COUNTIF(Defects!I5:I991,\"New\")","v":0},"N/A and Future Release defects are removed "]
[null,"Closed:",{"$f":"COUNTIF(Defects!I5:I991,\"Closed\")","v":0},"from the Total number of defects"]
[null,"Reopened:",{"$f":"COUNTIF(Defects!I5:I991,\"Reopened\")","v":0},"summarized"]
[null,"Open/In-progress:",{"$f":"COUNTIF(Defects!I5:I991,\"Open/In-progress\")","v":0},"N/A:",{"$f":"COUNTIF(Defects!I5:I991,\"N/A\")","v":0}]
[null,"Fixed:",{"$f":"COUNTIF(Defects!I5:I991,\"Fixed\")","v":0},"Future Release:",{"$f":"COUNTIF(Defects!I5:I991,\"Future Release\")","v":0}]
[null,"Net Total Defects:",{"$f":"COUNTA(Defects!I5:I991) - (COUNTIF(Defects!I5:I991,\"N/A\") + COUNTIF(Defects!I5:I991, \"Future Release\"))","v":0}]
[]
[]
[]
[null,"UAT TALLY SUMMARY"]
[]
[null,"  User Acceptance Testing Defect Tally"]
[null,"New:",{"$f":"COUNTIF('User Acceptance Testing'!I5:I1000,\"New\")","v":0},"N/A and Future Release defects are removed "]
[null,"Closed:",{"$f":"COUNTIF('User Acceptance Testing'!I5:I1000,\"Closed\")","v":0},"from the Total number of defects"]
[null,"Reopened:",{"$f":"COUNTIF('User Acceptance Testing'!I5:I1000,\"Reopened\")","v":0},"summarized"]
[null,"Open/In-progress:",{"$f":"COUNTIF('User Acceptance Testing'!I5:I1000,\"Open/In-progress\")","v":0},"N/A:",{"$f":"COUNTIF('User Acceptance Testing'!I5:I1000,\"N/A\")","v":0}]
[null,"Fixed:",{"$f":"COUNTIF('User Acceptance Testing'!I5:I1000,\"Fixed\")","v":0},"Future Release:",{"$f":"COUNTIF('User Acceptance Testing'!I5:I1000,\"Future Release\")","v":0}]
[null,"Net Total Defects:",{"$f":"COUNTA('User Acceptance Testing'!I5:I1000) - (COUNTIF('User Acceptance Testing'!I5:I1000,\"N/A\") + COUNTIF('User Acceptance Testing'!I5:I1000, \"Future Release\"))","v":0}]
[]
[]
[]
[null,"PRODUCTION TALLY SUMMARY"]
[]
[null,"  Production Defect Tally"]
[null,"New:",{"$f":"COUNTIF(Production!I5:I1000,\"New\")","v":0},"N/A and Future Release defects are removed "]
[null,"Closed:",{"$f":"COUNTIF(Production!I5:I1000,\"Closed\")","v":0},"from the Total number of defects"]
[null,"Reopened:",{"$f":"COUNTIF(Production!I5:I1000,\"Reopened\")","v":0},"summarized"]
[null,"Open/In-progress:",{"$f":"COUNTIF(Production!I5:I1000,\"Open/In-progress\")","v":0},"N/A:",{"$f":"COUNTIF(Production!I5:I1000,\"N/A\")","v":0}]
[null,"Fixed:",{"$f":"COUNTIF(Production!I5:I1000,\"Fixed\")","v":0},"Future Release:",{"$f":"COUNTIF(Production!I5:I1000,\"Future Release\")","v":0}]
[null,"Net Total Defects:",{"$f":"COUNTA(Production!I5:I1000) - (COUNTIF(Production!I5:I1000,\"N/A\") + COUNTIF(Production!I5:I1000, \"Future Release\"))","v":0}]
[]
[]
[]
[null,"New:","Tester reports new defect."]
[null,"Closed:","Tester accepts fix. Defect closed."]
[null,"Reopened:","Tester does NOT accept fix. Defect reopened."]
[null,"Open/In-progress:","Developer working on defect issue."]
[null,"Fixed:","Developer indicates fix is ready to test."]
[null,"N/A:","Not applicable."]
[null,"Future Release:","Will not implement in current release."]