Load survey spreadsheet
Full spreadsheet to calculate cargo, displacement of commercial vessels, adopted direct from Lloyds survey, used by Upper Canada Steamship, Algoma shipping,and Federal shipping
Survey form
Observed draft
Corrected draft 1
Corrected draft 2
Displacement 1
Displacement 2
Trim correction
Consumables 1
Consumables 2
Factors
Observed draft
Corrected draft 1
Corrected draft 2
Displacement 1
Displacement 2
Trim correction
Consumables 1
Consumables 2
Factors
| SGS Canada | ||||||||||
| File no | SGS001 | |||||||||
| Vessel MV | ||||||||||
| at | ||||||||||
| Cargo described | ||||||||||
| Loaded | Light | |||||||||
| 1 | Draft forward Corrected | 26.250 | 12.917 | |||||||
| Draft Aft Corrected | 26.417 | 17.750 | ||||||||
| Draft Fore & Aft Mean | 26.333 | 15.333 | ||||||||
| 2 | Draft Amidships Port | 26.167 | 14.667 | |||||||
| Draft Amidships Starboard | 26.250 | 14.667 | ||||||||
| Draft Amidships | 26.208 | 14.667 | ||||||||
| 3 | Draft Corrected for Deformation | 26.240 | 14.833 | |||||||
| 4 | Displacment | LT | 33950 | 18648.83 | ||||||
| 5 | Displacement Corrected for Trim | 18555.71 | ||||||||
| Loaded | light | |||||||||
| 6 | Mean Observed Density | 1 | 1 | corr | nil | nil | ||||
| 7 | Diplacement Corrected for density | LT | ||||||||
| MT | ||||||||||
| 8 | Consumables, Ballast, ETC (MT) | LT | ||||||||
| a | fuel oils | 176 | 173.2192 | 160 | ||||||
| b | Fresh wate | #DIV/0! | 54.99 | 49.99 | ||||||
| c | Ballast | 112.19 | 112.19 | 10582 | ||||||
| d | Others | |||||||||
| Total | #DIV/0! | 340.3992 | 10791.99 | |||||||
| 9 | Net displacement | LT | 26029.6 | 183.72 | ||||||
| 10 | Cargo discharged | 25845.88 | ||||||||
| 26260.71 | Metric tonnes | 25845.88 | long tons | short tons | ||||||
| Remarks | ||||||||||
| Light ship | MT | 7580 | LT | |||||||
| Constant | MT | LT | ||||||||
| Commence discharge | 16:30 | 25-Apr-99 | ||||||||
| Complete discharge | 26-Apr-99 | |||||||||
| Trim Correction | ||||||||||||
| Metric | ||||||||||||
| First Trim Correction | ||||||||||||
| Trim (cm) x TPC (t/cm) x LCF (cm) | ||||||||||||
| FTC(t)= | LBP (cm) | |||||||||||
| FTC : | FTC first trim correction | |||||||||||
| Trim : | Trim diff between aft and fore drafts corrected to perpendiculars | |||||||||||
| TPC : | Metric tons per cm immersion at mean draft form dispalcement table | |||||||||||
| LBP : | length between forward and aft perpendiculards from gen particulars | |||||||||||
| LCF : | Position of centre of flotation( dist between admidships and centre of flotation) hydro static data | |||||||||||
| Trim (cm) x TPC (t/cm) x LCF (cm) | ||||||||||||
| FTC(t)= | LBP (cm) | x 100 | ||||||||||
| Imperial | Vessel tirmed by the stern | |||||||||||
| trim(inch) x TPI(LT/inch) x LCF (inch) | - the correction will be minus if LCF forward of amidships | |||||||||||
| FTC (LT) | LBP(inch) | + the correction will be plus if LCF is aft of amidships | ||||||||||
| TPI : | Long tons per inch immersion at the mean draft | Vessel trimed by the head | ||||||||||
| - the correction will be minus if LCF aft of amidships | ||||||||||||
| + the correction will be plus if LCF is forward of amidships | ||||||||||||
| trim(ft) x TPI(LT/inch) x LCF (ft) | ||||||||||||
| FTC (LT) | LBP(ft) | x 12 | ||||||||||
| Example | ||||||||||||
| Mean forward draft | 300 | |||||||||||
| Mean aft draft | 650 | |||||||||||
| trim | 350 | |||||||||||
| length between cof LCF and amidship | -200 | - forward | ||||||||||
| LBP | 17000 | |||||||||||
| TPC | 30 | t/cm | ||||||||||
| as per formula | -123.529 | |||||||||||
| Mean forward draft | 12.91667 | 155 | ||||||||||
| Mean aft draft | 17.75 | 213 | ||||||||||
| trim | 4.833333 | 58 | ||||||||||
| length between cof LCF and amidsh | 10.4 | 124.8 | ||||||||||
| LBP | 709 | 3 | 8511 | |||||||||
| TPI | 109.5 | |||||||||||
| as per formula | 93.12711 | |||||||||||
| Second trim correction | ||||||||||||
| STC(t)= | trim2 (m2) | x 50 (cm) x dM (txm/cm | x dM | (t x m/cm | ||||||||
| LBP (m) | m | dz | (m) | |||||||||
| STC(LT)= | trim2 (sqft) | x 6 (inch) x | x dM | (LT x feet/inch | ||||||||
| LBP (feet) | ft | dz | (feet) | |||||||||
| Moment to change trim 1cm or 1inch | ||||||||||||
| Trimming moment from tables | ||||||||||||
| MTC | @ the mean draft +50cm and -50cm | |||||||||||
| MTI | @ the mean draft +6" and -6" | |||||||||||
| = | MTC1 | - | MTC2 | |||||||||
| dz | dz | |||||||||||
| Mean draf | 600 | cm | ||||||||||
| MTC1 | mean draft + | 50 | ||||||||||
| MTC2 | mean draft - | 50 | ||||||||||
Trim Correction page
Survey form
