Student progress tracker

[DJPowelly]

Hi, I have been struggling with this for weeks now, trawling through various web pages, so any help would be greatly appreciated.
I have a number of learners who's progress I wish to track. They have a number of criteria that they must meet twice using two separate log sheets.
Some of the criteria only has one option that must be met twice, some criteria have multiple options that must all be met twice and other have multiple criteria that you can use a selection of to meet twice.
From the sample below every criteria in row 1 must have two different log sheets entered in row 4
3.1, 3.3 and 3.4 have to have at least 2 different log sheets entered in row 4.
3.2 must use a, b and c, using at least 2 different log sheets entered in row 4 - this could be a & b on 1 sheet and c on a different one or various combinations.
3.5 must be met at least twice but only has to use two, it can be more but must be at least two of a,b,c or d.
4.1 must be met at least twice, but could be 2 different options from a - f or you can use one option twice.

then to add one more thing, I need to keep a running progress percentage of the unit progress.

Example.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH
1		3.1		3.2						3.3		3.4		3.5 - Cover Two:								4.1 - Cover One: (e.g. over the assessment occasions cover one item twice or two different items once)
2				a workplace policies (company and site)		b supplier information		c manufacturer’s instructions						a ladder		b tower scaffold or MEWP		c stepladder		d platform.		a Environmental Protection Act		b Hazardous Waste Regulations		c Pollution Prevention and Control Act		d Control of Pollution Act		e Control of Noise at Work Regulations		f Environment Act
3		1	2	1	2	1	2	1	2	1	2	1	2	1	2	1	2	1	2	1	2	1	2	1	2	1	2	1	2	1	2	1	2
4	Learner 1																																	% completed goes here
Sheet1

Any help or guidance would be greatly appreciated.

Thank you