vba to assign work to students

[stephanietnt]

Good day, i know very little about vba and i am in need of code to assist with a class. This is what is needed:

The class has about 30 students, male and female
everyday for 48 days, 5 students are needed to carry out 5 different assignments.
3 out of 5 of those assignments are only for the men, while the other two, both men and women can do.
A person should only be used twice only when everyone else has been selected

So when the code is run i would like to get a table showing who will be handling the 5 assignments for each of the 48 days

Can anyone get me started with some simple code. I would really appreciate it.
thank you

 

[duggie33]

Fun, you should make this their assignment for Day 1.

With 48 days, 5 assignments per day, if there are 30 students, they each will do an assignment eight out of the 48 days unless the gender requirement changes that. I think the person who solves this will need to know the total number of students, and how many are male.

I am not sure it will require code...

Doug

 

[Herakles]

Good day, i know very little about vba and i am in need of code to assist with a class. This is what is needed:

The class has about 30 students, male and female
everyday for 48 days, 5 students are needed to carry out 5 different assignments.
3 out of 5 of those assignments are only for the men, while the other two, both men and women can do.
A person should only be used twice only when everyone else has been selected

So when the code is run i would like to get a table showing who will be handling the 5 assignments for each of the 48 days

Can anyone get me started with some simple code. I would really appreciate it.
thank you

Are you still using Excel 2010 and if not, what version are you using?

How do you want the assignment table to be structured?

Three variables, names, assignments and dates.
One to go along the top to form the columns, one to go in column one to form the rows and the remaining one to go in the body of the table.

 

[Joe4]

Are you still using Excel 2010 and if not, what version are you using?

Seeing as how they just joined the forum 2 days ago, I would guess that is probably accurate.

 

[duggie33]

Here is a possible solution if there are 30 students, 20 male, 10 female...

Book1
	A	B	C	D	E	F	G	H	I	J
1	DAY	ASSIGNMENT 1_MALE	ASSIGNMENT 2_MALE	ASSIGNMENT 3_MALE	ASSIGNMENT 4_EITHER	ASSIGNMENT 5_EITHER			MALES	FEMALES
2	1	M1	M2	M3	M4	F1			M1	F1
3	2	M5	M6	M7	M8	F2			M2	F2
4	3	M9	M10	M11	F3	F4			M3	F3
5	4	M12	M13	M14	F5	F6			M4	F4
6	5	M15	M16	M17	F7	F8			M5	F5
7	6	M18	M19	M20	F9	F10			M6	F6
8	7	M1	M2	M3	M4	F1			M7	F7
9	8	M5	M6	M7	M8	F2			M8	F8
10	9	M9	M10	M11	F3	F4			M9	F9
11	10	M12	M13	M14	F5	F6			M10	F10
12	11	M15	M16	M17	F7	F8			M11
13	12	M18	M19	M20	F9	F10			M12
14	13	M1	M2	M3	M4	F1			M13
15	14	M5	M6	M7	M8	F2			M14
16	15	M9	M10	M11	F3	F4			M15
17	16	M12	M13	M14	F5	F6			M16
18	17	M15	M16	M17	F7	F8			M17
19	18	M18	M19	M20	F9	F10			M18
20	19	M1	M2	M3	M4	F1			M19
21	20	M5	M6	M7	M8	F2			M20
22	21	M9	M10	M11	F3	F4
23	22	M12	M13	M14	F5	F6
24	23	M15	M16	M17	F7	F8
25	24	M18	M19	M20	F9	F10
26	25	M1	M2	M3	M4	F1
27	26	M5	M6	M7	M8	F2
28	27	M9	M10	M11	F3	F4
29	28	M12	M13	M14	F5	F6
30	29	M15	M16	M17	F7	F8
31	30	M18	M19	M20	F9	F10
32	31	M1	M2	M3	M4	F1
33	32	M5	M6	M7	M8	F2
34	33	M9	M10	M11	F3	F4
35	34	M12	M13	M14	F5	F6
36	35	M15	M16	M17	F7	F8
37	36	M18	M19	M20	F9	F10
38	37	M1	M2	M3	M4	F1
39	38	M5	M6	M7	M8	F2
40	39	M9	M10	M11	F3	F4
41	40	M12	M13	M14	F5	F6
42	41	M15	M16	M17	F7	F8
43	42	M18	M19	M20	F9	F10
44	43	M1	M2	M3	M4	F1
45	44	M5	M6	M7	M8	F2
46	45	M9	M10	M11	F3	F4
47	46	M12	M13	M14	F5	F6
48	47	M15	M16	M17	F7	F8
49	48	M18	M19	M20	F9	F10
Sheet2

 

[Herakles]

Here is a possible solution if there are 30 students, 20 male, 10 female...

Book1
	A	B	C	D	E	F	G	H	I	J
1	DAY	ASSIGNMENT 1_MALE	ASSIGNMENT 2_MALE	ASSIGNMENT 3_MALE	ASSIGNMENT 4_EITHER	ASSIGNMENT 5_EITHER			MALES	FEMALES
2	1	M1	M2	M3	M4	F1			M1	F1
3	2	M5	M6	M7	M8	F2			M2	F2
4	3	M9	M10	M11	F3	F4			M3	F3
5	4	M12	M13	M14	F5	F6			M4	F4
6	5	M15	M16	M17	F7	F8			M5	F5
7	6	M18	M19	M20	F9	F10			M6	F6
8	7	M1	M2	M3	M4	F1			M7	F7
9	8	M5	M6	M7	M8	F2			M8	F8
10	9	M9	M10	M11	F3	F4			M9	F9
11	10	M12	M13	M14	F5	F6			M10	F10
12	11	M15	M16	M17	F7	F8			M11
13	12	M18	M19	M20	F9	F10			M12
14	13	M1	M2	M3	M4	F1			M13
15	14	M5	M6	M7	M8	F2			M14
16	15	M9	M10	M11	F3	F4			M15
17	16	M12	M13	M14	F5	F6			M16
18	17	M15	M16	M17	F7	F8			M17
19	18	M18	M19	M20	F9	F10			M18
20	19	M1	M2	M3	M4	F1			M19
21	20	M5	M6	M7	M8	F2			M20
22	21	M9	M10	M11	F3	F4
23	22	M12	M13	M14	F5	F6
24	23	M15	M16	M17	F7	F8
25	24	M18	M19	M20	F9	F10
26	25	M1	M2	M3	M4	F1
27	26	M5	M6	M7	M8	F2
28	27	M9	M10	M11	F3	F4
29	28	M12	M13	M14	F5	F6
30	29	M15	M16	M17	F7	F8
31	30	M18	M19	M20	F9	F10
32	31	M1	M2	M3	M4	F1
33	32	M5	M6	M7	M8	F2
34	33	M9	M10	M11	F3	F4
35	34	M12	M13	M14	F5	F6
36	35	M15	M16	M17	F7	F8
37	36	M18	M19	M20	F9	F10
38	37	M1	M2	M3	M4	F1
39	38	M5	M6	M7	M8	F2
40	39	M9	M10	M11	F3	F4
41	40	M12	M13	M14	F5	F6
42	41	M15	M16	M17	F7	F8
43	42	M18	M19	M20	F9	F10
44	43	M1	M2	M3	M4	F1
45	44	M5	M6	M7	M8	F2
46	45	M9	M10	M11	F3	F4
47	46	M12	M13	M14	F5	F6
48	47	M15	M16	M17	F7	F8
49	48	M18	M19	M20	F9	F10
Sheet2

I think that we may be missing some information here.

We obviously don't know the mix but it may be that each student needs to do each assignment at least x times and that there needs to be at least x number of days between
a student doing an assignment.

 

[duggie33]

Yeah, the OP is leaving a lot of questions hanging on this...