work-8

Mocproject.xlsx

Home >Business & Finance homework help >Accounting homework help >work-8

Issue Tracker

	OPEN vs. CLOSED ISSUE TRACKER					TYPE	PRIORITY	DATE	LAST (days)
						*	*	5/30/21	30
Issue Tracker Chart showing Opened vs. Closed issues per day for a given time frame is in cells A2 through J4.
	#	ISSUE	TYPE	PRIORITY	OPENED ON	OPENED BY	CLOSED ON	CLOSED BY	NOTES
	1	Issue #1	Type 2	Medium	2/1/21	James	2/4/21	James
	2	Issue #2	Type 2	Low	2/1/21	Kim	2/1/21	James
	3	Issue #3	Type 3	Low	2/4/21	Lilly	2/4/21	Lilly
	4	Issue #4	Type 1	Medium	2/4/21	Lilly	2/5/21	Lilly
	5	Issue #5	Type 1	Medium	2/4/21	James	2/4/21	Ted
	6	Issue #6	Type 1	Low	2/8/21	Ted	2/8/21	James
	7	Issue #7	Type 1	High	2/8/21	Kim	2/13/21	James
	8	Issue #8	Type 2	Medium	2/8/21	Kim	2/11/21	James
	9	Issue #9	Type 3	Medium	2/8/21	Kim	2/11/21	Kim
	10	Issue #10	Type 4	High	2/12/21	Ted	2/12/21	Lilly
	11	Issue #11	Type 2	Medium	2/12/21	Kim	2/13/21	Lilly
	12	Issue #12	Type 1	High	2/15/21	Ted	2/18/21	James
	13	Issue #13	Type 2	High	2/20/21	Kim	2/20/21	Kim
	14	Issue #14	Type 2	High	2/23/21	Ted	2/23/21	James
	15	Issue #15	Type 2	Low	2/26/21	James	2/27/21	Lilly
	16	Issue #16	Type 4	Medium	2/26/21	Lilly	2/26/21	James
	17	Issue #17	Type 2	Low	2/26/21	Ted	2/26/21	Ted
	18	Issue #18	Type 3	High	2/27/21	Lilly	2/27/21	Lilly
	19	Issue #19	Type 2	Low	2/27/21	Ted	2/27/21	Lilly
	20	Issue #20	Type 3	Low	3/4/21	Lilly	3/4/21	Ted
	21	Issue #21	Type 4	Low	3/4/21	Lilly	3/7/21	Kim
	22	Issue #22	Type 3	Low	3/4/21	Ted	3/9/21	Kim
	23	Issue #23	Type 3	Medium	3/5/21	Kim	3/5/21	James
	24	Issue #24	Type 3	Medium	3/5/21	Lilly	3/5/21	James
	25	Issue #25	Type 1	High	3/6/21	Kim	3/10/21	Ted
	26	Issue #26	Type 1	High	3/6/21	Kim	3/8/21	Kim
	27	Issue #27	Type 1	High	3/6/21	James	3/8/21	Ted
	28	Issue #28	Type 4	Low	3/11/21	Ted	3/12/21	James
	29	Issue #29	Type 3	Low	3/12/21	Kim	3/13/21	Kim
	30	Issue #30	Type 2	Medium	3/12/21	Lilly	3/13/21	Kim
	31	Issue #31	Type 4	Medium	3/17/21	Lilly	3/19/21	James
	32	Issue #32	Type 4	Low	3/21/21	Ted	3/26/21	James
	33	Issue #33	Type 4	Low	3/25/21	James	3/26/21	Lilly
	34	Issue #34	Type 3	Low	3/25/21	Kim	3/30/21	Lilly
	35	Issue #35	Type 1	Low	3/29/21	James	3/29/21	Kim
	36	Issue #36	Type 4	Medium	3/31/21	Ted	4/4/21	Lilly
	37	Issue #37	Type 4	Medium	4/5/21	James	4/6/21	Lilly
	38	Issue #38	Type 2	High	4/9/21	Lilly	4/14/21	James
	39	Issue #39	Type 4	Low	4/10/21	Lilly	4/12/21	Ted
	40	Issue #40	Type 3	Low	4/10/21	Ted	4/13/21	Lilly
	41	Issue #41	Type 4	Low	4/12/21	James	4/13/21	James
	42	Issue #42	Type 1	Medium	4/16/21	Kim	4/16/21	Ted
	43	Issue #43	Type 2	Medium	4/18/21	Lilly	4/18/21	Kim
	44	Issue #44	Type 1	Medium	4/18/21	Ted	4/22/21	Kim
	45	Issue #45	Type 1	Medium	4/22/21	Lilly	4/23/21	Kim
	46	Issue #46	Type 2	High	4/23/21	James	4/24/21	Kim
	47	Issue #47	Type 1	Medium	4/25/21	Ted	4/25/21	Lilly
	48	Issue #48	Type 3	Medium	4/30/21	Ted	5/1/21	Kim
	49	Issue #49	Type 1	Medium	5/5/21	Lilly	5/5/21	Ted
	50	Issue #50	Type 2	Medium	5/5/21	Kim	5/9/21	James
	51	Issue #51	Type 2	High	5/8/21	James	5/12/21	Kim
	52	Issue #52	Type 3	Low	5/11/21	James	5/14/21	Ted
	53	Issue #53	Type 4	Medium	5/11/21	James	5/11/21	Ted
	54	Issue #54	Type 1	Low	5/12/21	James	5/12/21	Ted
	55	Issue #55	Type 1	Low	5/15/21	Ted	5/15/21	James
	56	Issue #56	Type 1	Medium	5/17/21	Lilly	5/17/21	Lilly
	57	Issue #57	Type 1	High	5/17/21	Lilly	5/21/21	Kim
	58	Issue #58	Type 1	High	5/17/21	Lilly	5/19/21	Lilly
	59	Issue #59	Type 3	Medium	5/21/21	Kim	5/21/21	Ted
	60	Issue #60	Type 3	High	5/24/21	Ted	5/26/21	Kim
	61	Issue #61	Type 2	Medium	5/25/21	Kim	5/25/21	Lilly
	62	Issue #62	Type 3	Low	5/30/21	Lilly	6/3/21	James
	63	Issue #63	Type 4	Low	6/4/21	James	6/4/21	James
	64	Issue #64	Type 4	Low	6/7/21	Ted	6/9/21	Ted
	65	Issue #65	Type 4	High	6/7/21	Ted	6/7/21	James
	66	Issue #66	Type 4	Medium	6/12/21	Kim	6/12/21	Kim
	67	Issue #67	Type 1	Medium	6/17/21	Ted	6/17/21	James
	68	Issue #68	Type 4	Low	6/18/21	Lilly	6/18/21	James
	69	Issue #69	Type 3	Medium	6/18/21	James	6/18/21	Lilly
	70	Issue #70	Type 4	High	6/18/21	Lilly	6/18/21	Kim
	71	Issue #71	Type 3	High	6/19/21	James	6/19/21	Lilly
	72	Issue #72	Type 2	High	6/23/21	Ted	6/23/21	James
	73	Issue #73	Type 4	Low	6/28/21	James	6/30/21	Kim
	74	Issue #74	Type 1	Low	6/28/21	Kim	6/28/21	Kim
	75	Issue #75	Type 4	High	7/3/21	James	7/3/21	Kim
	76	Issue #76	Type 3	High	7/4/21	Kim	7/8/21	Ted
	77	Issue #77	Type 2	High	7/4/21	Ted	7/4/21	Kim
	78	Issue #78	Type 2	High	7/5/21	Ted	7/10/21	Lilly
	79	Issue #79	Type 4	Medium	7/10/21	James	7/15/21	Lilly
	80	Issue #80	Type 1	High	7/10/21	Ted	7/12/21	James
	81	Issue #81	Type 4	High	7/11/21	Lilly	7/13/21	Ted
	82	Issue #82	Type 1	High	7/15/21	Lilly	7/18/21	Kim
	83	Issue #83	Type 4	High	7/17/21	Kim	7/20/21	Ted
	84	Issue #84	Type 2	Low	7/20/21	James	7/20/21	Lilly
	85	Issue #85	Type 1	Medium	7/23/21	James	7/23/21	Ted
	86	Issue #86	Type 3	Medium	7/28/21	Kim	7/28/21	Kim
	87	Issue #87	Type 2	Medium	7/28/21	Lilly	8/2/21	Kim
	88	Issue #88	Type 2	Medium	7/31/21	Ted	7/31/21	James
	89	Issue #89	Type 3	High	8/2/21	Kim	8/6/21	Lilly
	90	Issue #90	Type 4	Medium	8/6/21	Kim	8/6/21	James
	91	Issue #91	Type 2	High	8/8/21	Kim	8/10/21	Lilly

Closed Area 1 1 1 1 2 2 2 2 3 3 4 6 6 7 8 8 9 9 10 10 12 12 12 12 13 14 14 14 14 14 Opened 44317 44318 44319 44320 44321 44322 44323 44324 44325 44326 44327 44328 44329 44330 44331 44332 44333 44334 44335 44336 44337 44338 44339 44340 44341 44342 44343 44344 44345 44346 0 0 0 0 2 2 2 3 3 3 5 6 6 6 7 7 10 10 10 10 11 11 11 12 13 13 13 13 13 14 Closed 44317 44318 44319 44320 44321 44322 44323 44324 44325 44326 44327 44328 44329 44330 44331 44332 44333 44334 44335 44336 44337 44338 44339 44340 44341 44342 44343 44344 44345 44346 1 1 1 1 2 2 2 2 3 3 4 6 6 7 8 8 9 9 10 10 12 12 12 12 13 14 14 14 14 14 Opened Lables

44317 44318 44319 44320 44321 44322 44323 44324 44325 44326 44327 44328 44329 44330 44331 44332 44333 44334 44335 44336 44337 44338 44339 44340 44341 44342 44343 44344 44345 44346 0.56000000000000005 0.56000000000000005 0.56000000000000005 0.56000000000000005 2.56 2.56 2.56 3.56 3.56 3.56 5.5600000000000005 6.5600000000000005 6.5600000000000005 6.5600000000000005 7.5600000000000005 7.5600000000000005 10.56 10.56 10.56 10.56 11.56 11.56 11.56 12.56 13.56 13.56 13.56 13.56 13.56 14.56 Closed Labels

1.56 1.56 1.56 1.56 2.56 2.56 2.56 2.56 3.56 3.56 4.5600000000000005 6.5600000000000005 6.5600000000000005 7.5600000000000005 8.56 8.56 9.56 9.56 10.56 10.56 12.56 12.56 12.56 12.56 13.56 14.56 14.56 14.56 14.56 14.56

calculations

* This sheet should remain hidden *
			Min	1/1/20
			Max
			Days	30
			Date	5/30/21	0
			Type	*
			Priority	*
					ERROR:#VALUE!	ERROR:#VALUE!
					4	3	Sorted	Sorted
		Date	Opened	Closed	Types	Priorities	Types	Priorities
					*	*
	1	5/1/21	0	1	Type 2	Medium	*	*
	2	5/2/21	0	1	Type 3	Low	Type 1	High
	3	5/3/21	0	1	Type 1	High	Type 2	Low
	4	5/4/21	0	1	Type 4	ERROR:#N/A	Type 3	Medium
	5	5/5/21	2	2	ERROR:#N/A	ERROR:#N/A	Type 4	ERROR:#NUM!
	6	5/6/21	2	2	ERROR:#N/A	ERROR:#N/A	ERROR:#NUM!	ERROR:#NUM!
	7	5/7/21	2	2	ERROR:#N/A	ERROR:#N/A	ERROR:#NUM!	ERROR:#NUM!
	8	5/8/21	3	2	ERROR:#N/A	ERROR:#N/A	ERROR:#NUM!	ERROR:#NUM!
	9	5/9/21	3	3	ERROR:#N/A	ERROR:#N/A	ERROR:#NUM!	ERROR:#NUM!
	10	5/10/21	3	3	ERROR:#N/A	ERROR:#N/A	ERROR:#NUM!	ERROR:#NUM!
	11	5/11/21	5	4	ERROR:#N/A	ERROR:#N/A	ERROR:#NUM!	ERROR:#NUM!
	12	5/12/21	6	6	ERROR:#N/A	ERROR:#N/A	ERROR:#NUM!	ERROR:#NUM!
	13	5/13/21	6	6	ERROR:#N/A	ERROR:#N/A	ERROR:#NUM!	ERROR:#NUM!
	14	5/14/21	6	7	ERROR:#N/A	ERROR:#N/A	ERROR:#NUM!	ERROR:#NUM!
	15	5/15/21	7	8	ERROR:#N/A	ERROR:#N/A	ERROR:#NUM!	ERROR:#NUM!
	16	5/16/21	7	8	ERROR:#N/A	ERROR:#N/A	ERROR:#NUM!	ERROR:#NUM!
	17	5/17/21	10	9	ERROR:#N/A	ERROR:#N/A	ERROR:#NUM!	ERROR:#NUM!
	18	5/18/21	10	9	ERROR:#N/A	ERROR:#N/A	ERROR:#NUM!	ERROR:#NUM!
	19	5/19/21	10	10	ERROR:#N/A	ERROR:#N/A	ERROR:#NUM!	ERROR:#NUM!
	20	5/20/21	10	10	ERROR:#N/A	ERROR:#N/A	ERROR:#NUM!	ERROR:#NUM!
	21	5/21/21	11	12	ERROR:#N/A	ERROR:#N/A	ERROR:#NUM!	ERROR:#NUM!
	22	5/22/21	11	12	ERROR:#N/A	ERROR:#N/A	ERROR:#NUM!	ERROR:#NUM!
	23	5/23/21	11	12	ERROR:#N/A	ERROR:#N/A	ERROR:#NUM!	ERROR:#NUM!
	24	5/24/21	12	12	ERROR:#N/A	ERROR:#N/A	ERROR:#NUM!	ERROR:#NUM!
	25	5/25/21	13	13	ERROR:#N/A	ERROR:#N/A	ERROR:#NUM!	ERROR:#NUM!
	26	5/26/21	13	14	ERROR:#N/A	ERROR:#N/A	ERROR:#NUM!	ERROR:#NUM!
	27	5/27/21	13	14	ERROR:#N/A	ERROR:#N/A	ERROR:#NUM!	ERROR:#NUM!
	28	5/28/21	13	14	ERROR:#N/A	ERROR:#N/A	ERROR:#NUM!	ERROR:#NUM!
	29	5/29/21	13	14	ERROR:#N/A	ERROR:#N/A	ERROR:#NUM!	ERROR:#NUM!
	30	5/30/21	14	14	ERROR:#N/A	ERROR:#N/A	ERROR:#NUM!	ERROR:#NUM!
	31	5/31/21	14	14
	32	6/1/21	14	14
	33	6/2/21	14	14
	34	6/3/21	14	15
	35	6/4/21	15	16
	36	6/5/21	15	16
	37	6/6/21	15	16
	38	6/7/21	17	17
	39	6/8/21	17	17
	40	6/9/21	17	18
	41	6/10/21	17	18
	42	6/11/21	17	18
	43	6/12/21	18	19
	44	6/13/21	18	19
	45	6/14/21	18	19
	46	6/15/21	18	19
	47	6/16/21	18	19
	48	6/17/21	19	20
	49	6/18/21	22	23
	50	6/19/21	23	24
	51	6/20/21	23	24
	52	6/21/21	23	24
	53	6/22/21	23	24
	54	6/23/21	24	25
	55	6/24/21	24	25
	56	6/25/21	24	25
	57	6/26/21	24	25
	58	6/27/21	24	25
	59	6/28/21	26	26
	60	6/29/21	26	26
	61	6/30/21	26	27
	62	7/1/21	26	27
	63	7/2/21	26	27
	64	7/3/21	27	28
	65	7/4/21	29	29