Complex random name generation from lists

[Smythers00]

I'd like to think I know what I'm doing in excel 2010, but this one is a bit more than I can chew. Any help would be appreciated.

I'm playing a pirate game... not very professional, but still a spreadsheet related question

I have a complex list of names and ranks and sometimes, during a battle, some of the (fictional) crew get hurt or killed (to be clear - it's a game, no one gets hurt in real life, it'd be just my luck the NSA was listening in on me). I want to be able to enter the number of casualties and have a random list come up.

There are 4 ranks of crew members, and each rank has a list of names.

rank 1 has a 10% chance of being hurt
rank 2 has a 15% chance of being hurt
rank 3 has a 25% chance of being hurt
rank 4 has a 50% chance of being hurt

So if the number of people hurt is 10, I would like to be able to input 10 and this formula will figure out how many in which rank, then figure out randomly from that rank who was hurt.

Example

I input 10 casualties, the formula figures out the following:

1 casualty from rank 1 - generate 1 random name from rank 1
0 from rank 2 - No generation required
1 casualty from rank 3 - generate 1 random name from rank 3
8 casualties from rank 4 - generate 8 random names from rank 4

The idea seems simple, but the coding is a little beyond me.

Thanks for your time

[gak67]

It needs some tidying up, but is this anything like you want?
Pirate.xlsx

[Smythers00]

That works quite nicely. Thank you very much for the help