Hello aramis,
General rules of math in english, as taught in grade 5
if it says "Y for each X" or "Y for every X", round up Y.
if it says "Y for every full X", round down Y
If it asks, "how many Y given X rate", round down Y, as the fraction can't.
Now I know why I'm so bad at English and why I can't remember grade 5 math.
From Basic Math Refresher by Stephen Hearne copyright 2005 ISBN 0-7386-0052-0 page 75 in an English format I understand.
"Rounding works like this. First, you choose the decimal place that you want to round to. Then, you look at the digit in the decimal place to the right of it. If it is 5 or greater then round up. If it is 4 or less, then leave it alone. Lastly, get rid of all the remaining digits to the right of the decimal place that you want."
Example Set 1 page 76:
Round the following number to the nearest tenths.
21.36 ≈ 21.4
The number to the right of the tenth place is 6. Since 6 is greater than 5, round the 3 up to 4. Lastly drop the 6. Note that the symbol ≈ means approximately equal to.
Round the following number to the nearest tenths.
21.34 ≈ 21.3
The number to the right of the tenth place is 4. Since 4 is less than 5, leave the 3 alone. Lastly drop the 4.
Example Set 2 page 78
Round the following number to the nearest tenths.
3.6 ≈ 4
The number to the right of the ones place is 5. Since 6 is greater than 5, round the 3 up to 4. Lastly drop the 6.
Example Set 4 page 81:
The following numbers are rounded to the nearest ones.
23.4 ≈ 23; 4.5 ≈ 5; 97.28 ≈ 97; 12.57 ≈ 13; 9.62 ≈ 10; 24.367 ≈ 24
This informs the language in HG, as does common sense.
Common sense says that if you don't have at least as many as the unrounded number, you're undercrewed. (TNE allows undercrewing, but has rules to cover it.)
I always round up all the fractions in crew calculations, because of that very principle.
EG: if the ratio works out to 1.333 engineers needed, 1 engineer isn't meeting the requirement. 2 is, but life is easier on both of them.
As a house rule (not a house rule, but a rule in TNE) round up to the nearest 10th and see if you can put in a multi-role position...
Apparently the Navy's common sense is different from match reality the submarine sonar divisions when I during my time in service was supposed to have 12 trained sonar personnel assigned which broke down to 3 watch sections of 4 sonar personnel. On all four submarines we had 11 sonar technicians/operators. The Chief Leading Petty Officer, when there was one, and Leading Petty Officer usually got pulled to stand watches outside of sonar. Interesting that we where undermanned and when we couldn't get someone like the corpsman or undesignated strikers the number of times one or more of the sonar types stood more watches.
So once again my experience is at odds with the rules, not to mention all the math books I've dug through in addition to Basic Math Refresher.
Another, adjustment to my spreadsheet is in the works.
This takes care of the engineers, but I'm still trying to figure out how to calculate the number of stewards required.
Would the best way to handle the stewards be to subtract the number staterooms needed for the pilot, navigator, engineers, medics and at least 1 steward then divide by 8 high passengers.
The liner has 30 staterooms at least 6 staterooms are needed for the crew without stewards. Using this method 24 staterooms are available to book high passengers. The number of stewards needed would be 24/8 = 3. The 3 stewards each require a stateroom which drops the available staterooms to 21. To check the number 21/8 = 2.6250 or 3 stewards.
Would that be a good fix or is there another way to go about the calculation.