Rotation list

  • Replies:0
  • OpenNot stickiedUnanswered
  • Forum posts: 1

Jan 18, 2016, 12:47:43 AM via Website

Take a look in the image below. It's actually three images put together, from three different events.
They were created by an excel worksheet, using VBA. I have to send an image like that to nine people, using whatsapp.

Now let me tell you the story behind the images:
Say nine NFL players live together and share their vehicules to go trainning.
They are:
- J.J. Watt
- Aaron Rodgers
- Tom Brady
- DeMarco Murray
- Peyton Manning
- Calvin Johnson
- Andrew Luck
- Antonio Brown
- Marshawn Lynch

They have four cars (a Toyota, a GM, a Volkswagen and a Hyundai), three motorcycles (a Kawasaki, a BMW and a Ducati) and two bikes.
They always change vehicules in a certain order (bike, car, motorcycle, car, bike, car, motorcycle, car, motorcycle), in a way that the first guy who drives the Toyota will get to drive it again after 8 rotations.
Say day one the sequence for players is 1, 2, 3, 4, 5, 6, 7, 8 and 9.
Day two would be 9, 1, 2, 3, 4, 5, 6, 7 and 8.
Day tree would be 8, 9, 1, 2, 3, 4, 5, 6 and 7.

If today player "5" takes the BMW, it means player "4" takes the Volkswagen and player "6" takes the Hyundai. Tomorrow (or in the next rotation), player "5" will take the Hyunday, player "4" will take the BMW and player "6" will take the Ducati.

I make such rotation work with the mentioned VBA, but it would be nice if I could make it work on the cell phone.

I'm just starting to learn about Java and Android. Could anybody help me?...
Thanks a lot. image

Recommended by NextPit