The invention relates to a ship loading calculation method based on Excel, the basic formula is F = W-B, M = summing F * d (x), the ship loading calculation method comprises the following steps: a, calculating the shearing force, and the formula is that the shearing force F = W-B; a1, calculating the weight W of the ship; a2, calculating the
buoyancy B of the ship; a2.1, calculating draught; a2, referring to a formula: D < head > = D < horizontal floating > +
delta < head >, and D <
tail > = D < horizontal floating > +
delta <
tail >; a2.2, calculating the volume, namely
buoyancy, according tothe final draft calculated in the step a2.1; a3, the shearing force of each rib
station number is obtained through F = W-B; b, calculating
bending moment, wherein the formula is M = summing F * d (x); c, which comprises
water area density, cabin
liquid density, allowable shearing force values under different working conditions and allowable
bending moment values under different working conditions; d,
stowage and automatic calculation, wherein
stowage comprises
stowage of a
ballast compartment and stowage of other compartments; compiling a function to generate hydrostatic data; last-key automatic computation. The method guarantees that the ship strength does not exceed the allowable value, guarantees the safe navigation of the ship, saves the
software and
time cost, and greatly improves the efficiency.