Help figuring out how to do this.

[Lpiazza]

Alright, so a company that I work with makes racks for a large company to use. They are new and I go in every day and watch the racks when they get placed and make note of the rack number, time in and out, any issues that come from the robot etc.
So we are trying to figure out now, an easy-clean way to list everything. Something easy to read or be able to transfer from the daily sheets to a total sheet.
We mainly need to keep track of the racks that have issues, amount of times we see them in their place if the issue persists.
I can email or something images of what we have so far, apparently the images are too large to upload here.

 

[kweaver]

Welcome to Mr. Excel,

Is there any reason not to keep a spreadsheet with column headers: Rack #, Time In, Time Out, Issues?

Ultimately, how would you want to query this information to tell you what?

 

[Lpiazza]

Welcome to Mr. Excel,

Is there any reason not to keep a spreadsheet with column headers: Rack #, Time In, Time Out, Issues?

Ultimately, how would you want to query this information to tell you what?

That's pretty much what we have now. Our main thing is trying to cut down time on marking which racks have had issues, which has come back that had issues and have issues still.

Rack Data.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
30	2/17/2021	Yes	Yes	N/A		1		C	321	Yes	1	Parts shifted to the left
31		Yes	Yes	N/a		1		c	138	No	3	1/4"-1/2" unlevel had past issues
32		Yes	9	12:40		2		c	81	N/a		Parts from 138 picked and moved to 081
33	2/18/2021	N/a	5	17-Feb		1		C	27	Yes
34		N/a	9	17-Feb		2		c	81	Yes
35		Yes	Yes	7:15		1		C	256	Yes
36		Yes	Yes	7:17		2		C	281	Yes
37		Yes	Yes	7:39		1		c	89	Yes	4	Part 4 angel was too far back
38		Yes	Yes	7:57		2		C	342	Yes
39		Yes	Yes	10:16		2		C	51	Yes	1	Part's were too far to the left.
40		Yes	Yes	11:12		1		c	331	Yes
41		Yes	Yes	12:20		2		C	319	Yes
42		Yes	Yes	12:46		1		C	217	Yes
43		yes	Yes	1:34		2		c	210	N/a
44		yes	Yes	1:58		1		C	371	N/a
45	2/19/2021	n/a	0	18-Feb		1		C	371	Yes
46		n/a	0	18-Feb		2		C	210	Yes
47		Yes	Yes	6:19		2		c	387	Yes
48		Yes	Yes	6:50		1		C	173	Yes
49		No	Yes	7:21		2		C	284	no	1	Bent back bracket on cell, rack uneven.
50		No	Yes	7:36		1		C	284	Yes		Was moved from cell 2 to cell 1
51		Yes	Yes	7:37		2		c	382	Yes
52		Yes	Yes	7:52		1		C	134	Yes
53		Yes	Yes	8:46		1		C	90	Yes
54		Yes	Yes	10:18		2		C	403	Yes
55		Yes	Yes	10:49		1		c	372	Yes
56		Yes	Yes	11:08		2		C	327	Yes
57		Yes	Yes	11:10		1		C	133	Yes
58		Yes	Yes	11:35		2		C	392	Yes
59		Yes	Yes	12:39		1		c	299	n/a
60		Yes	Yes	12:57		2		C	143	no	1	Was able to tip rack forward, once on ground could see about a 1/2" gap from floor.
61		Yes	Yes	1:17		2		C	248	n/a
62	2/22/2021	n/a	0	19-Feb		1		C	299	Yes
63		n/a	Yes	19-Feb		2		c	248	Yes
64		Yes	Yes	6:42		1		C	392	Yes
65		Yes	Yes	7:07		2		C	218	no	1	Rack not sitting flat. Moved to cell 1.
66		Yes	Yes	7:18		1		C	209	no	6	Moved to cell 2 to check rack 218
67		n/a	6	7:26		2		c	209	Yes
68		n/a	Yes	7:26		1		C	218	no	1	From cell 2, still not hitting switch. Green Tagged
69		Yes	Yes	7:27		1		C	311	Yes
70		Yes	Yes	9:40		1		C	302	Yes		Parts from 218
71		Yes	Yes	9:44		2		c	315	Yes	3	Light Curtain broken
72		Yes	Yes	10:23		1		C	313	Yes
73		Yes	Yes	11:33		2		C	410	Yes
74		no	Yes	12:27		1		C	191	n/a	1	Came unlocked, all parts too far over left.
75		Yes	Yes	12:29		2		c	285	Yes
76		Yes	Yes	12:51		2		C	399	n/a
Data

Book2.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20
2	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40
3	41	42	43	44	45	46	47	48	49	50	51	52	53	54	55	56	57	58	59	60
4	61	62	63	64	65	66	67	68	69	70	71	72	73	74	75	76	77	78	79	80
5	81	82	83	84	85	86	87	88	89	90	91	92	93	94	95	96	97	98	99	100
6	101	102	103	104	105	106	107	108	109	110	111	112	113	114	115	116	117	118	119	120
7	121	122	123	124	125	126	127	128	129	130	131	132	133	134	135	136	137	138	139	140
8	141	142	143	144	145	146	147	148	149	150	151	152	153	154	155	156	157	158	159	160
9	161	162	163	164	165	166	167	168	169	170	171	172	173	174	175	176	177	178	179	180
10	181	182	183	184	185	186	187	188	189	190	191	192	193	194	195	196	197	198	199	200
11	201	202	203	204	205	206	207	208	209	210	211	212	213	214	215	216	217	218	219	220
12	221	222	223	224	225	226	227	228	229	230	231	232	233	234	235	236	237	238	239	240
13	241	242	243	244	245	246	247	248	249	250	251	252	253	254	255	256	257	258	259	260
14	261	262	263	264	265	266	267	268	269	270	271	272	273	274	275	276	277	278	279	280
15	281	282	283	284	285	286	287	288	289	290	291	292	293	294	295	296	297	298	299	300
16	301	302	303	304	305	306	307	308	309	310	311	312	313	314	315	316	317	318	319	320
17	321	322	323	324	325	326	327	328	329	330	331	332	333	334	335	336	337	338	339	340
18	341	342	343	344	345	346	347	348	349	350	351	352	353	354	355	356	357	358	359	360
19	361	362	363	364	365	366	367	368	369	370	371	372	373	374	375	376	377	378	379	380
20	381	382	383	384	385	386	387	388	389	390	391	392	393	394	395	396	397	398	399	400
21	401	402	403	404	405	406	407	408	409	410	411	412	413	414	415	416	417	418	419	420
22	421	422	423	424	425	426	427	428	429	430	431	432	433	434	435	436	437	438	439	440
23	441	442	443	444	445	446	447	448	449	450	451	452	453	454	455	456	457	458	459	460
24	461	462	463	464	465	466	467	468	469	470	471	472	473	474	475	476	477	478	479	480
25	481	482	483	484	485	486	487	488	489	490	491	492	493	494	495	496	497	498	499	500
Sheet1

Racks.xlsx
	A	B	C	D
174	173	n
175	174	y	2	2/23: Angle of parts too far back, parts 1,3,5, and 7. In cell 2. 2/24: Placed in Cell 1, now parts 3 and 6 were angled too far.
176	175
177	176	n
178	177
179	178
180	179
181	180
182	181	n
183	182	n
184	183
185	184
186	185
187	186
188	187
189	188
190	189
191	190	n
192	191	y		Received unlocked. Parts shifted to the left.
193	192
194	193	y		Robot failed to pick part
Sheet1