Spreadsheet: 82579d1282652107-fill-a-cell-based-on-3-inputs-that-correspond-to-multiple-data-tables-crew-manning-example
Sheet: Marine Manning Analysis

 | INPUTS
 | POB | 41 - 50 | CONDITiON 1
 | PERIOD | 2011-06-30 00:00:00 | IGNORE
 | REGION | AUSTRALIA | IGNORE
 | WORK TYPE | OPERATIONAL | CONDITION 2 |  |  |  |  |  |  |  | REGION | PERIOD | POB | WORK TYPE
 |  |  |  |  |  |  |  |  |  |  | ASIA | 2009-12-31 00:00:00 | 0 - 12 | OPERATIONAL
 |  |  |  |  |  |  |  |  |  |  | UK | 2010-06-30 00:00:00 | 13 - 18 | CONSTRUCTION
 | MANNING COSTS |  |  |  |  |  |  |  |  |  | AUSTRALIA | 2010-09-05 00:00:00 | 19 - 30 | TRANSIT
 |  |  | Company 1 | Company 2 | Company 3 | Company 4 |  |  |  |  |  | 2011-06-30 00:00:00 | 31 - 40 | NON-DUTY MANNING
 | POB |  |  |  |  |  |  |  |  |  |  | 2012-06-30 00:00:00 | 41 - 50
 | Crew List | Requirements | Amount | Amount | Amount | Amount |  |  |  |  |  |  | 51 - 60
 |  |  | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 61 - 70
 | Master |  | 1000 |  |  |  |  |  |  |  |  |  | 71 - 85
 | Chief Mate / First Officer |  | 800 |  |  |  |  |  |  |  |  |  | 86 - 95
 | Second Mate |  | 700 |  |  |  |  |  |  |  |  |  | 96 +
 | Chief Engineer |  | 700
 | First Engineer |  | 600
 | Second Engineer |  | 1000
 | Electrician |  | 1000 |  |  |  |  |  |  |  | OPERATIONAL
 | Chief Integrated Rating ([NAME]) |  | 500 |  |  |  |  |  |  |  | POB | 0 - 12 | 13 - 18 | 19 - 30 | 31 - 40 | 41 - 50 | 51 - 60 | 61 - 70 | 71 - 85 | 86 - 95 | 96 +
 | Integrated Rating |  | 500 |  |  |  |  |  |  |  | Master | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Crane Operator |  | 500 |  |  |  |  |  |  |  | Chief Mate / First Officer | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | Chief Caterer |  | 500 |  |  |  |  |  |  |  | Second Mate | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | Chief [NAME] |  | 500 |  |  |  |  |  |  |  | Chief Engineer | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | [NAME] |  | 500 |  |  |  |  |  |  |  | First Engineer | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | Caterer ([NAME]) |  | 500 |  |  |  |  |  |  |  | Second Engineer | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 |  |  |  |  |  |  |  |  |  |  | Electrician | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | OTHER MARINE CREW COSTS |  |  |  |  |  |  |  |  |  | Chief Integrated Rating ([NAME]) | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | Integrated Rating | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
 | Valid To |  |  |  |  |  |  |  |  |  | Crane Operator | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | Native Currency |  | AUD | AUD | AUD | AUD |  |  |  |  | Chief Caterer | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Variation Factor |  | 0 | 0 | 0 | 0 |  |  |  |  | Chief [NAME] | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Construction Allowance |  | 103 |  |  |  |  |  |  |  | [NAME] | 0 | 1 | 2 | 1 | 1 | 2 | 2 | 3 | 3 | 3
 | [NAME] (2 beds) |  | 40.25 |  |  |  |  |  |  |  | Caterer ([NAME]) | 0 | 0 | 1 | 1 | 2 | 2 | 3 | 3 | 4 | 5
 | [NAME] (3 beds) |  | 51.95 |  |  |  |  |  |  |  | Total Manning
 | [NAME] (4 beds) |  | 63.65
 | Victualling per man per day |  | 29.5 |  |  |  |  |  |  |  | CONSTRUCTION
 | Casual Meals (per meal) |  | 10 |  |  |  |  |  |  |  | POB | 0 - 12 | 13 - 18 | 19 - 30 | 31 - 40 | 41 - 50 | 51 - 60 | 61 - 70 | 71 - 85 | 86 - 95 | 96 +
 | Training Allowance ( < 9 months in Australia) |  | 1200 |  |  |  |  |  |  |  | Master | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | Chief Mate / First Officer | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | NON-DUTY MANNING COSTS |  |  |  |  |  |  |  |  |  | Second Mate | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 |  |  |  |  |  |  |  |  |  |  | Chief Engineer | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Valid To |  | 2009-12-31 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00 |  |  |  |  | First Engineer | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | Native Currency |  | AUD | AUD | AUD | AUD |  |  |  |  | Second Engineer | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | Variation Factor |  | 0 | 0 | 0 | 0 |  |  |  |  | Electrician | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Master |  | 850 |  |  |  |  |  |  |  | Chief Integrated Rating ([NAME]) | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Chief Mate / First Officer |  | 700 |  |  |  |  |  |  |  | Integrated Rating | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
 | Second Mate |  | 650 |  |  |  |  |  |  |  | Crane Operator | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | Chief Engineer |  | 850 |  |  |  |  |  |  |  | Chief Caterer | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | First Engineer |  | 700 |  |  |  |  |  |  |  | Chief [NAME] | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Second Engineer |  | 650 |  |  |  |  |  |  |  | [NAME] | 0 | 1 | 2 | 1 | 1 | 2 | 2 | 3 | 3 | 3
 | Electrician |  | 650 |  |  |  |  |  |  |  | Caterer ([NAME]) | 0 | 0 | 1 | 1 | 2 | 2 | 3 | 3 | 4 | 5
 | Chief Integrated Rating ([NAME]) |  | 600 |  |  |  |  |  |  |  | Total Manning
 | Integrated Rating |  | 550
 | Crane Operator |  | 600 |  |  |  |  |  |  |  | TRANSIT
 | Chief Caterer |  | 600 |  |  |  |  |  |  |  | POB | 0 - 12 | 13 - 18 | 19 - 30 | 31 - 40 | 41 - 50 | 51 - 60 | 61 - 70 | 71 - 85 | 86 - 95 | 96 +
 | Chief [NAME] |  | 600 |  |  |  |  |  |  |  | Master |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | [NAME] |  | 550 |  |  |  |  |  |  |  | Chief Mate / First Officer |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 | Caterer ([NAME]) |  | 550 |  |  |  |  |  |  |  | Second Mate |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | Chief Engineer |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | First Engineer |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | GRAND TOTAL |  |  |  |  |  |  |  |  | Second Engineer |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 |  |  |  |  |  |  |  |  |  |  | Electrician |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | Chief Integrated Rating ([NAME]) |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | Integrated Rating |  |  | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
 |  |  |  |  |  |  |  |  |  |  | Crane Operator |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | Chief Caterer |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | Chief [NAME] |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | 1 | 1 | 1 | 2 | 2 | 3 | 3 | 3
 |  |  |  |  |  |  |  |  |  |  | Caterer ([NAME]) |  |  | 0 | 1 | 2 | 2 | 3 | 3 | 4 | 5
 |  |  |  |  |  |  |  |  |  |  | Total Manning