Spreadsheet for checking recruitment chances
So I was getting annoyed at my poor attempts of getting more lisbeths and constantly getting into the 20-30% range so ended up making a spreadsheet to work out my chances of recruiting a commander. The link is here , just save a copy and use away.
This sheet is based on a cumulative chance to capture a unit, so the chance to capture a unit and youve worked from 0% up to 3% is calculated based on the chance to capture at 1% + 2% + 3%.
The sheet has 3 boxes where to enter values, a 1% recruitment increment rate that starts at 1% for second and subsequent capture cycles, a 1% recruitment increment rate with a starting percentage of 5% based on the first capture cycle of a unit and finally a 5% recruitment increment rate with a starting percentage of 5% for the second and subsequent capture cycles.
Any feedback or criticism is welcome.