May 17th, 2010

marcus 2013

Spreadsheets again

I'm getting on fairly well so far, but I'm now stuck on something that ought to be fairly simple:

In the text I've given the weight and price of a ship's galley as follows:

$2500 / 0.6 tons buys a minimum galley suitable for e.g. a crew of four or five. To calculate the costs for larger galleys divide the total number of people to be served in a single sitting by five (round up) and multiply this number by $500 to add the extra cost, by 0.1 tons to add the extra tonnage.

Small short range craft don't necessarily have galleys at all, the crew might eat packed meals.

If the ship is equipped to land horizontally the weight goes up by 25% and the price by 50%, reflecting much more complicated plumbing and gimbal-mounted stoves etc. - this is entered as input C5 with permitted values of 0 (vertical landing) or 1 (horizontal landing)

Input C18 is the number of passengers to be served

For this one I don't want smooth variation - I'm assuming that this goes up in steps. from e.g. a stove with four heating elements to one with 6, bigger cooking pots, etc.

Can anyone give me Excel formulas to produce the total price and the total weight of the galley?