Hi all,
I am having a problem determining scheduling needs and hope someone can help me out with this.
I have a list of pilots that are trained to fly three differenct aircraft types. I would like to generate a list that shows all the possible combinations on a weekly basis. They can only fly one aircraft type per day. The problem is that all three aircraft types (variables) are depandant and I do not kow how to handle this.
I did a similar list with other staff trained on two aircraft types (below) and that was much simpler. If they are not flying one, they are flying the other. How do I generate a list with three aircraft types, showing all the different combinations?
A1=Aircraft 1 A2=Aircraft 2 (the numbers are total worked shifts/week from the entire staff)
A1 A2
50 0
49 1
48 2
47 3
46 4
45 5
44 6
43 7
42 8
41 9
40 10
39 11
38 12
37 13
36 14
35 15
34 16
33 17
32 18
31 19
30 20
29 21
28 22
27 23
26 24
25 25
24 26
23 27
22 28
21 29
20 30
Thanks for any help you can provide.
Bookmarks