{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["TS_Miller","TS_Smith","TS_Brown","Summary","Aux"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"TS_Miller","index":0,"n_rows":60,"n_cols":9,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[null,"Task1"]
[null,"Defect","App","DT_Date","Act_Date","TAE_Date","WE_Hrs","Status","Remarks"]
[null,1204,"App1","2010-02-17","2010-03-18","2010-11-07",0.25,"Open","Likeg"]
[null,2588,"App4","2010-12-15","2010-11-13","2010-02-28",0.33333333333333331,"Resolved","Bibof"]
[null,6414,"App6","2010-06-12","2010-02-05","2010-05-16",8.3333333333333329E-2,"Closed","Maked"]
[null,7488,"App7","2010-10-24","2010-12-01","2010-05-10",0.16666666666666666,"Restored","Rupet"]
[null,8232,"App3","2010-02-03","2010-12-05","2010-02-12",0.29166666666666669,"Open","Kufuc"]
[null,8864,"App6","2010-10-18","2010-05-25","2010-01-29",0.20833333333333334,"Resolved","Rofog"]
[null,9264,"App7","2010-09-29","2010-03-18","2010-08-20",0.25,"Closed","Loceh"]
[null,9492,"App3","2010-12-19","2010-08-28","2010-08-12",8.3333333333333329E-2,"In Progress","Sakug"]
[null,"Total",null,null,null,null,{"$f":"SUBTOTAL(109,Table2[WE_Hrs])","v":1.6666666666666665}]
[]
[null,"Task2"]
[null,"Incident","Group","I_Date","Severity","WE_Hrs","Status","Remarks"]
[null,1396,"WG6","2010-08-30","Sev_3",0.125,"Restored","Meres"]
[null,2103,"WG6","2010-12-10","Sev_1",0.29166666666666669,"In Progress","Fikog"]
[null,2349,"WG9","2010-09-09","Sev_4",4.1666666666666664E-2,"In Progress","Pitoh"]
[null,2634,"WG2","2010-08-01","Sev_4",4.1666666666666664E-2,"Hold","Katek"]
[null,6865,"WG6","2010-05-18","Sev_4",8.3333333333333329E-2,"Open","Petom"]
[null,7795,"WG9","2010-04-24","Sev_3",4.1666666666666664E-2,"Open","Fafot"]
[null,8640,"WG7","2010-07-12","Sev_1",0.16666666666666666,"Closed","Lasom"]
[null,8924,"WG2","2010-08-23","Sev_2",0.125,"Hold","Hunit"]
[null,9015,"WG6","2010-08-23","Sev_4",0.125,"Restored","Bemep"]
[null,"Total",null,null,null,{"$f":"SUBTOTAL(109,Table3[WE_Hrs])","v":1.0416666666666665}]
[]
[null,"Task3"]
[null,"RFS","App","Act_Date","TAE_Date","WE_Hrs","Status","Remarks"]
[null,1481,"App2","2010-01-23","2010-08-29",0.16666666666666666,"Restored","Mekin"]
[null,5508,"App5","2010-07-19","2010-03-10",0.29166666666666669,"Resolved","Heceh"]
[null,5915,"App6","2010-05-01","2010-07-13",0.25,"Resolved","Pipek"]
[null,6542,"App8","2010-12-05","2010-03-05",0.20833333333333334,"Hold","Gisuk"]
[null,6855,"App5","2010-03-13","2010-03-09",4.1666666666666664E-2,"Hold","Bisom"]
[null,6882,"App1","2010-02-11","2010-05-19",0.16666666666666666,"Hold","Kubof"]
[null,7523,"App5","2010-01-04","2010-06-11",0.29166666666666669,"Open","Satuc"]
[null,9420,"App2","2010-01-02","2010-09-28",0.20833333333333334,"Open","Hasar"]
[null,"Total",null,null,null,{"$f":"SUBTOTAL(109,Table4[WE_Hrs])","v":1.625},null,{"$f":"SUBTOTAL(103,Table4[Remarks])","v":8}]
[]
[null,"Task4"]
[null,"Change","App","CRI_Date","Desc","WE_Hrs","Status","Remarks"]
[null,{"$f":"RANDBETWEEN(1000,9999)","v":5741},{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App1"},{"$f":"DATE(2010,RANDBETWEEN(1,12),RANDBETWEEN(1,31))","v":"2010-06-26"},{"$f":"INDEX(UpK,RANDBETWEEN(1,16))&INDEX(vowel,RANDBETWEEN(1,5))&INDEX(LoK,RANDBETWEEN(1,13))&INDEX(vowel,RANDBETWEEN(1,5))&INDEX(LoK,RANDBETWEEN(1,13))","v":"Totak"},{"$f":"RANDBETWEEN(1,8)/24","v":8.3333333333333329E-2},{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Open"},{"$f":"INDEX(UpK,RANDBETWEEN(1,16))&INDEX(vowel,RANDBETWEEN(1,5))&INDEX(LoK,RANDBETWEEN(1,13))&INDEX(vowel,RANDBETWEEN(1,5))&INDEX(LoK,RANDBETWEEN(1,13))","v":"Lecek"}]
[null,9146,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App8"},"2010-09-18","Vareh",0.29166666666666669,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Resolved"},"Wened"]
[null,7131,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App8"},"2010-12-08","Mesod",4.1666666666666664E-2,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Closed"},"Didud"]
[null,9789,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App7"},"2010-07-18","Togok",8.3333333333333329E-2,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"In Progress"},"Lodar"]
[null,5610,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App5"},"2010-10-28","Dabun",0.25,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Open"},"Siros"]
[null,2526,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App8"},"2010-04-09","Kadod",4.1666666666666664E-2,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Restored"},"Resig"]
[null,9165,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App6"},"2010-01-25","Vepas",0.20833333333333334,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Closed"},"Nenec"]
[null,9803,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App3"},"2010-01-09","Potif",0.25,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Closed"},"Gikos"]
[null,"Total",null,null,null,{"$f":"SUBTOTAL(109,Table5[WE_Hrs])","v":1.25}]
[]
[null,"Task5"]
[null,"SME","MN_T","App","Desc","R_Date","C_Date","WE_Hrs","Status"]
[null,{"$f":"RANDBETWEEN(1000,9999)","v":4065},{"$f":"RANDBETWEEN(10,99)","v":74},{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App1"},{"$f":"INDEX(UpK,RANDBETWEEN(1,16))&INDEX(vowel,RANDBETWEEN(1,5))&INDEX(LoK,RANDBETWEEN(1,13))&INDEX(vowel,RANDBETWEEN(1,5))&INDEX(LoK,RANDBETWEEN(1,13))","v":"Hakus"},{"$f":"DATE(2010,RANDBETWEEN(1,12),RANDBETWEEN(1,31))","v":"2010-05-30"},{"$f":"DATE(2010,RANDBETWEEN(1,12),RANDBETWEEN(1,31))","v":"2010-12-05"},{"$f":"RANDBETWEEN(1,8)/24","v":0.33333333333333331},{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Hold"}]
[null,4638,21,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App5"},"Rupak","2010-08-10","2010-11-05",0.20833333333333334,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Closed"}]
[null,3543,32,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App2"},"Koneh","2010-10-05","2010-02-24",0.33333333333333331,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"In Progress"}]
[null,5266,82,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App2"},"Mebeg","2010-11-15","2010-03-21",8.3333333333333329E-2,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Restored"}]
[null,8902,71,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App3"},"Matuf","2010-12-18","2010-10-01",0.29166666666666669,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Resolved"}]
[null,2300,39,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App3"},"Wegob","2010-09-18","2010-04-20",0.16666666666666666,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Hold"}]
[null,3993,23,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App1"},"Berof","2010-10-25","2010-03-29",0.33333333333333331,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Hold"}]
[null,3934,92,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App1"},"Fabig","2010-04-14","2010-08-16",0.29166666666666669,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Hold"}]
[null,"Total",null,null,null,null,null,{"$f":"SUBTOTAL(109,Table6[WE_Hrs])","v":2.0416666666666665}]

{"sheet":"TS_Smith","index":1,"n_rows":60,"n_cols":9,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[null,"Task1"]
[null,"Defect","App","DT_Date","Act_Date","TAE_Date","WE_Hrs","Status","Remarks"]
[null,1417,"App1","2010-01-11","2010-07-18","2010-03-31",0.125,"Closed","Bufos"]
[null,3572,"App2","2010-02-20","2010-06-27","2010-08-17",0.33333333333333331,"Resolved","Jofap"]
[null,4060,"App4","2010-03-26","2010-01-12","2010-08-02",8.3333333333333329E-2,"Closed","Dakem"]
[null,4921,"App5","2010-03-16","2010-07-03","2010-06-18",0.25,"Restored","Wacap"]
[null,5906,"App3","2010-03-04","2010-10-17","2010-10-11",8.3333333333333329E-2,"Resolved","Muhog"]
[null,6010,"App8","2010-11-17","2010-09-02","2010-03-29",0.16666666666666666,"In Progress","Hubok"]
[null,6131,"App8","2010-08-08","2010-12-24","2010-05-23",4.1666666666666664E-2,"Open","Pekep"]
[null,8866,"App1","2010-11-22","2010-06-03","2010-05-07",0.16666666666666666,"In Progress","Sefap"]
[null,"Total",null,null,null,null,{"$f":"SUBTOTAL(109,Table7[WE_Hrs])","v":1.2500000000000002}]
[]
[null,"Task2"]
[null,"Incident","Group","I_Date","Severity","WE_Hrs","Status","Remarks"]
[null,1324,"WG2","2010-07-01","Sev_3",0.20833333333333334,"In Progress","Luhog"]
[null,2865,"WG7","2010-07-08","Sev_2",4.1666666666666664E-2,"Hold","Lugaf"]
[null,3378,"WG6","2010-12-23","Sev_3",8.3333333333333329E-2,"In Progress","Vabem"]
[null,4083,"WG2","2010-11-19","Sev_4",8.3333333333333329E-2,"In Progress","Bocur"]
[null,6632,"WG2","2010-07-01","Sev_4",0.16666666666666666,"In Progress","Higef"]
[null,6854,"WG3","2010-06-13","Sev_4",0.16666666666666666,"In Progress","Fenom"]
[null,8002,"WG2","2010-12-17","Sev_2",0.33333333333333331,"Restored","Ronin"]
[null,8671,"WG8","2010-04-22","Sev_1",0.29166666666666669,"Open","Segek"]
[null,8846,"WG9","2010-01-07","Sev_1",4.1666666666666664E-2,"Resolved","Ginut"]
[null,"Total",null,null,null,{"$f":"SUBTOTAL(109,Table8[WE_Hrs])","v":1.4166666666666667}]
[]
[null,"Task3"]
[null,"RFS","App","Act_Date","TAE_Date","WE_Hrs","Status","Remarks"]
[null,1239,"App6","2010-08-26","2010-11-10",0.20833333333333334,"Hold","Gemuc"]
[null,2306,"App3","2010-03-20","2010-06-08",0.16666666666666666,"In Progress","Heran"]
[null,3970,"App1","2010-10-07","2010-08-12",4.1666666666666664E-2,"Open","Fapoc"]
[null,5445,"App1","2010-09-10","2010-12-14",0.33333333333333331,"In Progress","Tafih"]
[null,5814,"App5","2010-03-05","2010-02-10",4.1666666666666664E-2,"Hold","Mecet"]
[null,5865,"App3","2010-12-12","2010-05-07",0.25,"Closed","Nocin"]
[null,6280,"App5","2010-08-19","2010-06-15",0.25,"In Progress","Pebim"]
[null,9648,"App1","2010-11-17","2010-02-23",0.20833333333333334,"Hold","Gadab"]
[null,"Total",null,null,null,{"$f":"SUBTOTAL(109,Table9[WE_Hrs])","v":1.4999999999999998},null,{"$f":"SUBTOTAL(103,Table9[Remarks])","v":8}]
[]
[null,"Task4"]
[null,"Change","App","CRI_Date","Desc","WE_Hrs","Status","Remarks"]
[null,{"$f":"RANDBETWEEN(1000,9999)","v":5335},{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App4"},{"$f":"DATE(2010,RANDBETWEEN(1,12),RANDBETWEEN(1,31))","v":"2010-06-25"},{"$f":"INDEX(UpK,RANDBETWEEN(1,16))&INDEX(vowel,RANDBETWEEN(1,5))&INDEX(LoK,RANDBETWEEN(1,13))&INDEX(vowel,RANDBETWEEN(1,5))&INDEX(LoK,RANDBETWEEN(1,13))","v":"Lirip"},{"$f":"RANDBETWEEN(1,8)/24","v":0.29166666666666669},{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"In Progress"},{"$f":"INDEX(UpK,RANDBETWEEN(1,16))&INDEX(vowel,RANDBETWEEN(1,5))&INDEX(LoK,RANDBETWEEN(1,13))&INDEX(vowel,RANDBETWEEN(1,5))&INDEX(LoK,RANDBETWEEN(1,13))","v":"Ribuf"}]
[null,1097,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App5"},"2010-10-30","Nomip",0.29166666666666669,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Open"},"Sedas"]
[null,4957,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App4"},"2010-09-02","Gusek",0.20833333333333334,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Resolved"},"Temof"]
[null,1715,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App4"},"2010-02-23","Bonad",0.20833333333333334,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Resolved"},"Sufan"]
[null,1214,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App8"},"2010-04-18","Fibes",0.33333333333333331,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"In Progress"},"Damag"]
[null,5206,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App5"},"2010-04-20","Rafus",0.33333333333333331,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Open"},"Wodud"]
[null,6926,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App7"},"2010-04-24","Wobug",4.1666666666666664E-2,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Closed"},"Bofob"]
[null,5474,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App6"},"2010-02-03","Gerur",0.33333333333333331,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Hold"},"Kobah"]
[null,"Total",null,null,null,{"$f":"SUBTOTAL(109,Table10[WE_Hrs])","v":2.0416666666666665}]
[]
[null,"Task5"]
[null,"SME","MN_T","App","Desc","R_Date","C_Date","WE_Hrs","Status"]
[null,{"$f":"RANDBETWEEN(1000,9999)","v":5905},{"$f":"RANDBETWEEN(10,99)","v":63},{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App4"},{"$f":"INDEX(UpK,RANDBETWEEN(1,16))&INDEX(vowel,RANDBETWEEN(1,5))&INDEX(LoK,RANDBETWEEN(1,13))&INDEX(vowel,RANDBETWEEN(1,5))&INDEX(LoK,RANDBETWEEN(1,13))","v":"Nahuf"},{"$f":"DATE(2010,RANDBETWEEN(1,12),RANDBETWEEN(1,31))","v":"2010-01-05"},"2010-06-07",{"$f":"RANDBETWEEN(1,8)/24","v":0.20833333333333334},{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Restored"}]
[null,8994,28,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App3"},"Rugun","2010-11-30","2010-09-28",0.125,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Hold"}]
[null,1627,60,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App5"},"Fisef","2010-08-01","2010-06-09",8.3333333333333329E-2,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Closed"}]
[null,2199,93,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App2"},"Kacot","2010-10-29","2010-09-30",0.20833333333333334,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Restored"}]
[null,7703,37,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App7"},"Bapib","2010-09-28","2010-06-14",8.3333333333333329E-2,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Closed"}]
[null,3163,65,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App3"},"Wepok","2010-07-27","2010-07-19",0.20833333333333334,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Resolved"}]
[null,2200,56,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App3"},"Dacib","2010-11-28","2010-12-08",0.16666666666666666,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Hold"}]
[null,7842,49,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App4"},"Puted","2010-05-04","2010-05-21",0.125,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Hold"}]
[null,"Total",null,null,null,null,null,{"$f":"SUBTOTAL(109,Table11[WE_Hrs])","v":1.2083333333333335}]

{"sheet":"TS_Brown","index":2,"n_rows":60,"n_cols":9,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[null,"Task1"]
[null,"Defect","App","DT_Date","Act_Date","TAE_Date","WE_Hrs","Status","Remarks"]
[null,1568,"App1","2010-04-24","2010-04-01","2010-06-29",4.1666666666666664E-2,"Hold","Momut"]
[null,2567,"App6","2010-05-15","2010-05-18","2010-11-09",0.125,"In Progress","Vedit"]
[null,3145,"App6","2010-08-09","2010-12-19","2010-08-18",0.25,"In Progress","Kotak"]
[null,4073,"App8","2010-04-12","2010-12-18","2010-12-14",0.29166666666666669,"Restored","Fisos"]
[null,4213,"App6","2010-11-27","2010-11-26","2010-12-28",0.20833333333333334,"Open","Vogoc"]
[null,5383,"App5","2010-03-31","2010-08-05","2010-08-18",0.125,"Restored","Bibor"]
[null,6598,"App3","2010-10-09","2010-09-25","2010-04-18",8.3333333333333329E-2,"Open","Hegot"]
[null,9759,"App1","2010-02-01","2010-11-23","2010-12-21",0.16666666666666666,"Hold","Wosic"]
[null,"Total",null,null,null,null,{"$f":"SUBTOTAL(109,Table12[WE_Hrs])","v":1.2916666666666665}]
[]
[null,"Task2"]
[null,"Incident","Group","I_Date","Severity","WE_Hrs","Status","Remarks"]
[null,3957,"WG6","2010-06-25","Sev_1",0.20833333333333334,"Hold","Vogef"]
[null,4025,"WG5","2010-08-20","Sev_1",4.1666666666666664E-2,"In Progress","Pehef"]
[null,5574,"WG3","2010-10-01","Sev_2",4.1666666666666664E-2,"Restored","Fugid"]
[null,7081,"WG9","2010-11-14","Sev_1",0.125,"Resolved","Wirig"]
[null,7441,"WG2","2010-12-06","Sev_2",0.29166666666666669,"Closed","Fupeh"]
[null,8022,"WG3","2010-12-02","Sev_2",8.3333333333333329E-2,"Resolved","Bekot"]
[null,8139,"WG5","2010-05-26","Sev_2",0.20833333333333334,"Resolved","Lepef"]
[null,9584,"WG6","2010-12-01","Sev_3",4.1666666666666664E-2,"Resolved","Vusuh"]
[null,9865,"WG7","2010-05-20","Sev_4",0.29166666666666669,"Hold","Tefad"]
[null,"Total",null,null,null,{"$f":"SUBTOTAL(109,Table13[WE_Hrs])","v":1.3333333333333335}]
[]
[null,"Task3"]
[null,"RFS","App","Act_Date","TAE_Date","WE_Hrs","Status","Remarks"]
[null,1258,"App1","2010-12-18","2010-04-21",8.3333333333333329E-2,"In Progress","Juher"]
[null,3082,"App1","2010-11-04","2010-04-07",8.3333333333333329E-2,"Open","Wabuh"]
[null,3393,"App4","2010-06-11","2010-04-09",8.3333333333333329E-2,"Resolved","Memeh"]
[null,3560,"App6","2010-12-09","2010-05-20",4.1666666666666664E-2,"Restored","Vator"]
[null,4308,"App6","2010-10-13","2010-07-17",0.29166666666666669,"Closed","Titud"]
[null,4414,"App2","2010-04-20","2010-01-30",0.25,"Closed","Dapik"]
[null,4798,"App5","2010-01-10","2010-03-08",0.125,"Closed","Lapab"]
[null,9499,"App5","2010-07-01","2010-03-02",0.125,"In Progress","Vatig"]
[null,"Total",null,null,null,{"$f":"SUBTOTAL(109,Table14[WE_Hrs])","v":1.0833333333333335},null,{"$f":"SUBTOTAL(103,Table14[Remarks])","v":8}]
[]
[null,"Task4"]
[null,"Change","App","CRI_Date","Desc","WE_Hrs","Status","Remarks"]
[null,{"$f":"RANDBETWEEN(1000,9999)","v":4842},{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App3"},{"$f":"DATE(2010,RANDBETWEEN(1,12),RANDBETWEEN(1,31))","v":"2010-08-07"},{"$f":"INDEX(UpK,RANDBETWEEN(1,16))&INDEX(vowel,RANDBETWEEN(1,5))&INDEX(LoK,RANDBETWEEN(1,13))&INDEX(vowel,RANDBETWEEN(1,5))&INDEX(LoK,RANDBETWEEN(1,13))","v":"Miseb"},{"$f":"RANDBETWEEN(1,8)/24","v":0.25},{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"In Progress"},{"$f":"INDEX(UpK,RANDBETWEEN(1,16))&INDEX(vowel,RANDBETWEEN(1,5))&INDEX(LoK,RANDBETWEEN(1,13))&INDEX(vowel,RANDBETWEEN(1,5))&INDEX(LoK,RANDBETWEEN(1,13))","v":"Sihuk"}]
[null,3201,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App3"},"2010-01-16","Wehid",0.125,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Restored"},"Pahad"]
[null,2468,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App7"},"2010-04-16","Lopak",0.33333333333333331,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Resolved"},"Poked"]
[null,5067,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App6"},"2010-05-01","Nogec",0.33333333333333331,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Hold"},"Jobot"]
[null,6991,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App3"},"2010-03-05","Mifob",0.125,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"In Progress"},"Lamic"]
[null,3820,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App2"},"2010-10-03","Vebih",0.25,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Closed"},"Bohet"]
[null,1834,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App2"},"2010-10-08","Jigom",0.20833333333333334,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Open"},"Vimap"]
[null,1331,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App8"},"2010-11-21","Lopih",0.25,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Restored"},"Modef"]
[null,"Total",null,null,null,{"$f":"SUBTOTAL(109,Table15[WE_Hrs])","v":1.8749999999999998}]
[]
[null,"Task5"]
[null,"SME","MN_T","App","Desc","R_Date","C_Date","WE_Hrs","Status"]
[null,{"$f":"RANDBETWEEN(1000,9999)","v":1029},{"$f":"RANDBETWEEN(10,99)","v":29},{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App8"},{"$f":"INDEX(UpK,RANDBETWEEN(1,16))&INDEX(vowel,RANDBETWEEN(1,5))&INDEX(LoK,RANDBETWEEN(1,13))&INDEX(vowel,RANDBETWEEN(1,5))&INDEX(LoK,RANDBETWEEN(1,13))","v":"Garah"},{"$f":"DATE(2010,RANDBETWEEN(1,12),RANDBETWEEN(1,31))","v":"2010-06-25"},"2010-01-29",{"$f":"RANDBETWEEN(1,8)/24","v":0.33333333333333331},{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Closed"}]
[null,3829,12,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App5"},"Fanas","2010-07-23","2010-05-13",8.3333333333333329E-2,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Closed"}]
[null,2565,40,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App8"},"Gonam","2010-08-09","2010-08-16",0.20833333333333334,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Hold"}]
[null,7748,90,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App4"},"Dader","2010-07-27","2010-05-25",0.25,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Open"}]
[null,2763,94,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App6"},"Migep","2010-08-22","2010-04-25",0.16666666666666666,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"In Progress"}]
[null,6004,30,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App8"},"Dagut","2010-04-28","2010-05-28",0.33333333333333331,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"In Progress"}]
[null,2578,49,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App6"},"Jipud","2010-11-28","2010-06-18",0.29166666666666669,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Restored"}]
[null,4729,35,{"$f":"INDEX(Table1[Apps],RANDBETWEEN(1,8))","v":"App2"},"Togor","2010-09-05","2010-11-12",0.29166666666666669,{"$f":"INDEX(Table1[S_1],RANDBETWEEN(1,6))","v":"Hold"}]
[null,"Total",null,null,null,null,null,{"$f":"SUBTOTAL(109,Table16[WE_Hrs])","v":1.9583333333333335}]

{"sheet":"Summary","index":3,"n_rows":30,"n_cols":30,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Task1",null,null,null,null,null,null,null,null,null,null,"Task2",null,null,null,null,null,null,null,null,null,"Task3"]
[null,"NName","Defect","App","DT_Date","Act_Date","TAE_Date","WE_Hrs","Status","Remarks",null,null,"NName","Incident","Group","I_Date","Severity","WE_Hrs","Status","Remarks",null,null,"NName","RFS","App","Act_Date","TAE_Date","WE_Hrs","Status","Remarks"]
[null,"Brown",1568,"App1","2010-04-24","2010-04-01","2010-06-29",4.1666666666666699E-2,"Hold","Momut",null,null,"Brown",3957,"WG6","2010-06-25","Sev_1",0.20833333333333301,"Hold","Vogef",null,null,"Brown",1258,"App1","2010-12-18","2010-04-21",8.3333333333333301E-2,"In Progress","Juher"]
[null,"Brown",2567,"App6","2010-05-15","2010-05-18","2010-11-09",0.125,"In Progress","Vedit",null,null,"Brown",4025,"WG5","2010-08-20","Sev_1",4.1666666666666699E-2,"In Progress","Pehef",null,null,"Brown",3082,"App1","2010-11-04","2010-04-07",8.3333333333333301E-2,"Open","Wabuh"]
[null,"Brown",3145,"App6","2010-08-09","2010-12-19","2010-08-18",0.25,"In Progress","Kotak",null,null,"Brown",5574,"WG3","2010-10-01","Sev_2",4.1666666666666699E-2,"Restored","Fugid",null,null,"Brown",3393,"App4","2010-06-11","2010-04-09",8.3333333333333301E-2,"Resolved","Memeh"]
[null,"Brown",4073,"App8","2010-04-12","2010-12-18","2010-12-14",0.29166666666666702,"Restored","Fisos",null,null,"Brown",7081,"WG9","2010-11-14","Sev_1",0.125,"Resolved","Wirig",null,null,"Brown",3560,"App6","2010-12-09","2010-05-20",4.1666666666666699E-2,"Restored","Vator"]
[null,"Brown",4213,"App6","2010-11-27","2010-11-26","2010-12-28",0.20833333333333301,"Open","Vogoc",null,null,"Brown",7441,"WG2","2010-12-06","Sev_2",0.29166666666666702,"Closed","Fupeh",null,null,"Brown",4308,"App6","2010-10-13","2010-07-17",0.29166666666666702,"Closed","Titud"]
[null,"Brown",5383,"App5","2010-03-31","2010-08-05","2010-08-18",0.125,"Restored","Bibor",null,null,"Brown",8022,"WG3","2010-12-02","Sev_2",8.3333333333333301E-2,"Resolved","Bekot",null,null,"Brown",4414,"App2","2010-04-20","2010-01-30",0.25,"Closed","Dapik"]
[null,"Brown",6598,"App3","2010-10-09","2010-09-25","2010-04-18",8.3333333333333301E-2,"Open","Hegot",null,null,"Brown",8139,"WG5","2010-05-26","Sev_2",0.20833333333333301,"Resolved","Lepef",null,null,"Brown",4798,"App5","2010-01-10","2010-03-08",0.125,"Closed","Lapab"]
[null,"Brown",9759,"App1","2010-02-01","2010-11-23","2010-12-21",0.16666666666666699,"Hold","Wosic",null,null,"Brown",9584,"WG6","2010-12-01","Sev_3",4.1666666666666699E-2,"Resolved","Vusuh",null,null,"Brown",9499,"App5","2010-07-01","2010-03-02",0.125,"In Progress","Vatig"]
[null,"Miller",1204,"App1","2010-02-17","2010-03-18","2010-11-07",0.25,"Open","Likeg",null,null,"Brown",9865,"WG7","2010-05-20","Sev_4",0.29166666666666702,"Hold","Tefad",null,null,"Miller",1481,"App2","2010-01-23","2010-08-29",0.16666666666666699,"Restored","Mekin"]
[null,"Miller",2588,"App4","2010-12-15","2010-11-13","2010-02-28",0.33333333333333298,"Resolved","Bibof",null,null,"Miller",1396,"WG6","2010-08-30","Sev_3",0.125,"Restored","Meres",null,null,"Miller",5508,"App5","2010-07-19","2010-03-10",0.29166666666666702,"Resolved","Heceh"]
[null,"Miller",6414,"App6","2010-06-12","2010-02-05","2010-05-16",8.3333333333333301E-2,"Closed","Maked",null,null,"Miller",2103,"WG6","2010-12-10","Sev_1",0.29166666666666702,"In Progress","Fikog",null,null,"Miller",5915,"App6","2010-05-01","2010-07-13",0.25,"Resolved","Pipek"]
[null,"Miller",7488,"App7","2010-10-24","2010-12-01","2010-05-10",0.16666666666666699,"Restored","Rupet",null,null,"Miller",2349,"WG9","2010-09-09","Sev_4",4.1666666666666699E-2,"In Progress","Pitoh",null,null,"Miller",6542,"App8","2010-12-05","2010-03-05",0.20833333333333301,"Hold","Gisuk"]
[null,"Miller",8232,"App3","2010-02-03","2010-12-05","2010-02-12",0.29166666666666702,"Open","Kufuc",null,null,"Miller",2634,"WG2","2010-08-01","Sev_4",4.1666666666666699E-2,"Hold","Katek",null,null,"Miller",6855,"App5","2010-03-13","2010-03-09",4.1666666666666699E-2,"Hold","Bisom"]
[null,"Miller",8864,"App6","2010-10-18","2010-05-25","2010-01-29",0.20833333333333301,"Resolved","Rofog",null,null,"Miller",6865,"WG6","2010-05-18","Sev_4",8.3333333333333301E-2,"Open","Petom",null,null,"Miller",6882,"App1","2010-02-11","2010-05-19",0.16666666666666699,"Hold","Kubof"]
[null,"Miller",9264,"App7","2010-09-29","2010-03-18","2010-08-20",0.25,"Closed","Loceh",null,null,"Miller",7795,"WG9","2010-04-24","Sev_3",4.1666666666666699E-2,"Open","Fafot",null,null,"Miller",7523,"App5","2010-01-04","2010-06-11",0.29166666666666702,"Open","Satuc"]
[null,"Miller",9492,"App3","2010-12-19","2010-08-28","2010-08-12",8.3333333333333301E-2,"In Progress","Sakug",null,null,"Miller",8640,"WG7","2010-07-12","Sev_1",0.16666666666666699,"Closed","Lasom",null,null,"Miller",9420,"App2","2010-01-02","2010-09-28",0.20833333333333301,"Open","Hasar"]
[null,"Smith",1417,"App1","2010-01-11","2010-07-18","2010-03-31",0.125,"Closed","Bufos",null,null,"Miller",8924,"WG2","2010-08-23","Sev_2",0.125,"Hold","Hunit",null,null,"Smith",1239,"App6","2010-08-26","2010-11-10",0.20833333333333301,"Hold","Gemuc"]
[null,"Smith",3572,"App2","2010-02-20","2010-06-27","2010-08-17",0.33333333333333298,"Resolved","Jofap",null,null,"Miller",9015,"WG6","2010-08-23","Sev_4",0.125,"Restored","Bemep",null,null,"Smith",2306,"App3","2010-03-20","2010-06-08",0.16666666666666699,"In Progress","Heran"]
[null,"Smith",4060,"App4","2010-03-26","2010-01-12","2010-08-02",8.3333333333333301E-2,"Closed","Dakem",null,null,"Smith",1324,"WG2","2010-07-01","Sev_3",0.20833333333333301,"In Progress","Luhog",null,null,"Smith",3970,"App1","2010-10-07","2010-08-12",4.1666666666666699E-2,"Open","Fapoc"]
[null,"Smith",4921,"App5","2010-03-16","2010-07-03","2010-06-18",0.25,"Restored","Wacap",null,null,"Smith",2865,"WG7","2010-07-08","Sev_2",4.1666666666666699E-2,"Hold","Lugaf",null,null,"Smith",5445,"App1","2010-09-10","2010-12-14",0.33333333333333298,"In Progress","Tafih"]
[null,"Smith",5906,"App3","2010-03-04","2010-10-17","2010-10-11",8.3333333333333301E-2,"Resolved","Muhog",null,null,"Smith",3378,"WG6","2010-12-23","Sev_3",8.3333333333333301E-2,"In Progress","Vabem",null,null,"Smith",5814,"App5","2010-03-05","2010-02-10",4.1666666666666699E-2,"Hold","Mecet"]
[null,"Smith",6010,"App8","2010-11-17","2010-09-02","2010-03-29",0.16666666666666699,"In Progress","Hubok",null,null,"Smith",4083,"WG2","2010-11-19","Sev_4",8.3333333333333301E-2,"In Progress","Bocur",null,null,"Smith",5865,"App3","2010-12-12","2010-05-07",0.25,"Closed","Nocin"]
[null,"Smith",6131,"App8","2010-08-08","2010-12-24","2010-05-23",4.1666666666666699E-2,"Open","Pekep",null,null,"Smith",6632,"WG2","2010-07-01","Sev_4",0.16666666666666699,"In Progress","Higef",null,null,"Smith",6280,"App5","2010-08-19","2010-06-15",0.25,"In Progress","Pebim"]
[null,"Smith",8866,"App1","2010-11-22","2010-06-03","2010-05-07",0.16666666666666699,"In Progress","Sefap",null,null,"Smith",6854,"WG3","2010-06-13","Sev_4",0.16666666666666699,"In Progress","Fenom",null,null,"Smith",9648,"App1","2010-11-17","2010-02-23",0.20833333333333301,"Hold","Gadab"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Smith",8002,"WG2","2010-12-17","Sev_2",0.33333333333333298,"Restored","Ronin"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Smith",8671,"WG8","2010-04-22","Sev_1",0.29166666666666702,"Open","Segek"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Smith",8846,"WG9","2010-01-07","Sev_1",4.1666666666666699E-2,"Resolved","Ginut"]

{"sheet":"Aux","index":4,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"NName","Apps","WG","S_1","S_2","S_3","Sev"]
[null,"Name1","App1","WG1","Open","Completed","Open","Sev_1"]
[null,"Name2","App2","WG2","In Progress","In Progress","In Progress","Sev_2"]
[null,"Name3","App3","WG3","Hold","On Hold","Completed","Sev_3"]
[null,"Name4","App4","WG4","Restored","Not Started",null,"Sev_4"]
[null,"Name5","App5","WG5","Resolved"]
[null,null,"App6","WG6","Closed"]
[null,null,"App7","WG7"]
[null,null,"App8","WG8"]
[null,null,null,"WG9"]