Assistance with Spreadsheet that is constantly crashing/over complicated formulas

[willow1985]

My boss created a spreadsheet that crashes consistently no matter what you do in it. I know there are too many lines and the formula's are too complicated/have errors.

What he wants is an employee list that is repetitive for every employee/visitors for every single day of the year = 11003 rows!

Eng - QA RAIL.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
1	Tue Feb 14 2023		ROLLING ACTION ITEM LIST - Engieering & Quality Assurance			Total Action items: 0, Open Items: 0, Completed on Time: 0				0	0
2	Row#	Date	From	Topic	Owner	Action	Target Completion Date	Complete Y/N	Actual Completion Date	Action Items	Late	Completion Date Week Number
3	3	Sun Jan 01 2023	Employee 1					.		0	0
4	4	Sun Jan 01 2023	Employee 2					.		0	0
5	5	Sun Jan 01 2023	Employee 3					.		0	0
6	6	Sun Jan 01 2023	Employee 4					.		0	0
7	7	Sun Jan 01 2023	Employee 5					.		0	0
8	8	Sun Jan 01 2023	Employee 6					.		0	0
9	9	Sun Jan 01 2023	Employee 7					.		0	0
10	10	Sun Jan 01 2023	Employee 8					.		0	0
11	11	Sun Jan 01 2023	Employee 9					.		0	0
12	12	Sun Jan 01 2023	Employee 10					.		0	0
13	13	Sun Jan 01 2023	Employee 11					.		0	0
14	14	Sun Jan 01 2023	Employee 12					.		0	0
15	15	Sun Jan 01 2023	Employee 13					.		0	0
16	16	Sun Jan 01 2023	Employee 14					.		0	0
17	17	Sun Jan 01 2023	Employee 15					.		0	0
18	18	Sun Jan 01 2023	Employee 16					.		0	0
19	19	Sun Jan 01 2023	Employee 17					.		0	0
20	20	Sun Jan 01 2023	Employee 18					.		0	0
21	21	Sun Jan 01 2023	Employee 19					.		0	0
22	22	Sun Jan 01 2023	Visitor					.		0	0
23	23	Sun Jan 01 2023	Visitor					.		0	0
24	24	Sun Jan 01 2023	Visitor					.		0	0
25	25	Sun Jan 01 2023	Visitor					.		0	0
26	26	Sun Jan 01 2023	Visitor					.		0	0
27	27	Sun Jan 01 2023	Visitor					.		0	0
28	28	Sun Jan 01 2023	Visitor					.		0	0
29	29	Sun Jan 01 2023	Visitor					.		0	0
30	30	Sun Jan 01 2023	Visitor					.		0	0
31	31	Sun Jan 01 2023	Visitor					.		0	0
32	32	Sun Jan 01 2023	Visitor					.		0	0
33	33	Mon Jan 02 2023	Employee 1					.		0	0
34	34	Mon Jan 02 2023	Employee 2					.		0	0
35	35	Mon Jan 02 2023	Employee 3					.		0	0
36	36	Mon Jan 02 2023	Employee 4					.		0	0
37	37	Mon Jan 02 2023	Employee 5					.		0	0
38	38	Mon Jan 02 2023	Employee 6					.		0	0
39	39	Mon Jan 02 2023	Employee 7					.		0	0
40	40	Mon Jan 02 2023	Employee 8					.		0	0
41	41	Mon Jan 02 2023	Employee 9					.		0	0
42	42	Mon Jan 02 2023	Employee 10					.		0	0
43	43	Mon Jan 02 2023	Employee 11					.		0	0
44	44	Mon Jan 02 2023	Employee 12					.		0	0
45	45	Mon Jan 02 2023	Employee 13					.		0	0
46	46	Mon Jan 02 2023	Employee 14					.		0	0
47	47	Mon Jan 02 2023	Employee 15					.		0	0
48	48	Mon Jan 02 2023	Employee 16					.		0	0
49	49	Mon Jan 02 2023	Employee 17					.		0	0
50	50	Mon Jan 02 2023	Employee 18					.		0	0
51	51	Mon Jan 02 2023	Employee 19					.		0	0
52	52	Mon Jan 02 2023	Visitor					.		0	0
53	53	Mon Jan 02 2023	Visitor					.		0	0
54	54	Mon Jan 02 2023	Visitor					.		0	0
55	55	Mon Jan 02 2023	Visitor					.		0	0
56	56	Mon Jan 02 2023	Visitor					.		0	0
57	57	Mon Jan 02 2023	Visitor					.		0	0
58	58	Mon Jan 02 2023	Visitor					.		0	0
59	59	Mon Jan 02 2023	Visitor					.		0	0
60	60	Mon Jan 02 2023	Visitor					.		0	0
61	61	Mon Jan 02 2023	Visitor					.		0	0
62	62	Mon Jan 02 2023	Visitor					.		0	0
2023

Cell Formulas
Range	Formula
A1	A1	=TODAY()
F1	F1	="Total Action items: "&J1&", Open Items: "&COUNTIF(H3:H62,"N")&", Completed on Time: "&K1
J1:K1	J1	=SUM(J3:J62)
A3:A62	A3	=ROW()
J3:J62	J3	=COUNT(G3)
K3:K62	K3	=IF(ISBLANK(I3),0,IF(I3<=G3,1,0))
L3:L62	L3	=IF(I3="","",ISOWEEKNUM(I3))
B4:B32,B34:B62	B4	=B3
B33	B33	=B32+1
H3:H62	H3	=IF(B3<$A$1,IF(WEEKNUM(B3)=WEEKNUM($A$1),"Week "&WEEKNUM($A$1),"."),IF(B3=$A$1,"o",IF(B3>$A$1,IF(WEEKNUM(B3)=WEEKNUM($A$1),"Week "&WEEKNUM($A$1),""))))

Named Ranges
Name	Refers To	Cells
'2023'!Print_Area	='2023'!$A$1:$H$62	H3:H62

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D3:D62,F3:F62	Cell	contains a blank value	text	NO
C3:C62,H4:I62,A5:G62	Expression	=$H3="Y"	text	NO
C3:C62,H4:I62,A5:G62	Expression	=$G3<1	text	NO
C3:C62,H4:I62,A5:G62	Expression	=$G3<=TODAY()	text	NO
B3:B62	Dates Occurring	today	text	NO

Any help re-creating this would be greatly appreciated!

 

[willow1985]

I cleaned up his conditional formats and that helped a lot. Still looking for some ideas on the formulas if anyone has. Thank you