hydrostatics calculation
DESCRIPTION
A sample of hydrostatic calculation using ExcelTRANSCRIPT
Sheet1Waterplane Area
WL - 1WL - 2WL - 3WL - 4WL - 5
ST NO.YSMY X SMST NO.YSMY X SMST NO.YSMY X SMST NO.YSMY X SMST NO.YSMY X SM000.50000.50000.50000.50000.500.50200.50200.50200.50200.57.609215.21819.32419.324111.339111.339112.047112.047112.638112.638113.092113.0921.510.774221.5481.512.104224.2081.512.664225.3281.513.057226.1141.513.327226.654211.9371.517.9055212.8091.519.2135213.1221.519.683213.391.520.085213.4571.520.1855312.915451.66313.35453.4313.427453.708313.482453.928313.5454413.5227413.5227413.5227413.5227413.5227513.5454513.5454513.5454513.5454513.5454613.5227613.5227613.5227613.5227613.5227712.135448.54 712.69450.76713.09452.36713.373453.492713.545488.0921.512.13889.0951.513.642589.8871.514.8305810.5691.515.8535811.1721.516.7588.54.14728.2948.55.414210.8288.56.281212.5628.57.087214.1748.57.859215.71892.23612.23693.50913.50994.40614.40695.10415.10495.65515.6559.50.91521.839.51.70423.4089.52.28724.5749.52.76125.5229.53.13526.271000.50100.1190.50.0595100.20.50.1100.2020.50.101100.1220.50.061281.4755298.3675307.5985315.0115335.6115
Area of WL - 12964.8752666667Area of WL - 23142.8043333333Area of WL - 33240.0375333333Area of WL - 43318.1211333333Area of WL - 53535.1078Volume upto different Waterlines
From0 to1
WLAreaSMArea X SMLeverProduct for Moment00500012964.8752666667823719.0021333333123719.002133333323142.8043333333-1-3142.80433333332-6285.608666666720576.197817433.3934666667WLDraftLength(from Drawing)11.7144.981Volumefrom0to12914.96135523.4146.17335.1147.195Momentfrom0to14198.542259888946.8148.4758.5151.274KB11.4403423403
From0 to2
WLAreaSMArea X SMLeverProduct for Moment00100012964.8752666667411859.5010666667111859.501066666723142.804333333313142.804333333326285.608666666715002.305418145.1097333333
Volumefrom0to28501.3063933333
Momentfrom0to217479.7890431111
KB22.0561297563
From0 to3
WLAreaSMArea X SMLeverProduct for Moment00100012964.875266666738894.625818894.625823142.804333333339428.413218856.82633240.037533333313240.037533333339720.112621563.076333333337471.5644
Volumefrom0to313746.4611625
Momentfrom0to340609.8079185
KB32.9542008986
From0 to4
WLAreaSMArea X SMLeverProduct for Moment00100012964.8752666667411859.5010666667111859.501066666723142.804333333326285.6086666667212571.217333333333240.0375333333412960.1501333333338880.450443318.121133333313318.1211333333413272.484533333334423.38176583.6533333333
Volumefrom0to419506.5825666667
Momentfrom0to473775.5860444444
KB43.7820866773
From0 to5
WLAreaSMArea X SMLeverProduct for Moment000.400012964.875266666712964.875266666712964.875266666723142.804333333313142.804333333326285.608666666733240.037533333313240.037533333339720.112643318.121133333313318.1211333333413272.484533333353535.10780.41414.0431257070.215614079.881386666739313.2966666667
Volumefrom0to524933.1232888889
Momentfrom0to5118349.403506944
KB54.7466738176
Transverse Metacenter
WL- 1
ST NO.YY^3SMProduct0000.500.5002019.324810.6003642241810.6003642241.510.7741250.63596482422501.271929648211.9371700.9266339531.52551.3899509295312.9152154.18616087548616.7446435413.52460.37524920.75513.52460.37549841.5613.52460.37524920.75712.1351786.97856037547147.914241588.092529.8679146881.5794.8018720328.54.14771.3184845232142.63696904692.23611.179320256111.1793202569.50.9150.76606087521.5321217510000.5042261.0714128855
Transverse moment of inertiaIT148383.317405242
Transverse metacenterBMT50.9040427417KMT52.344385082
WL- 2
ST NO.YY^3SMProduct0000.500.50020111.3391457.88835121911457.8883512191.512.1041773.31850086423546.637001728212.8092101.5787911291.53152.3681866935313.352379.27037549517.0815413.52460.37524920.75513.52460.37549841.5613.52460.37524920.75712.692043.54810948174.19243689.095752.3295323751.51128.49429856258.55.414158.6918979442317.38379588893.50943.206601229143.2066012299.51.7044.94776166429.895523328100.1190.0016851590.50.000842579547030.1485372275
Transverse moment of inertiaIT165128.077086265
Transverse metacenterBMT19.4238472825KMT21.4799770389
WL- 3
ST NO.YY^3SMProduct0000.500.50020112.0471748.38362782311748.3836278231.512.6642031.01301094424062.026021888213.1222259.4362918481.53389.154437772KMT313.4272420.67768548349682.71074193252.344385082413.52460.37524920.7521.4799770389513.52460.37549841.515.620909386613.52460.37524920.7513.1024817417713.092242.94662948971.78651612.377116213389.887966.4816271031.51449.72244065458.56.281247.7914860412495.58297208294.40685.532955416185.5329554169.52.28711.961853903223.923707806100.20.0080.50.00449591.8274213735
Transverse moment of inertiaIT174122.416279489
Transverse metacenterBMT12.6667084875KMT15.620909386
WL- 4LCB
ST NO.YY^3SMProductSTATION NO.WLWLWLWLWLWLAreaAreaAreaAreaAreaSMProductProductProductProductProductLeverP2P2P2P2P20000.500123450-10-20-30-40-50-10-20-30-40-50-10-20-30-40-50.500200 (F.P.)000000000000.500000500000112.6382018.52927807212018.5292780720.5000007.609000010.77941666672000021.55883333334.5000097.014751.513.0572226.02589619324452.051792386109.32411.33912.04712.63813.09217.921683333375.623933333394.3959136.9066666667179.1545117.921683333375.623933333394.3959136.9066666667179.1545471.6867333333302.4957333333377.5836547.6266666667716.618213.392400.7212191.53601.08182851.5010.77412.10412.66413.05713.32720.991681.4345333333103.65495148.4859333333191.001375241.9832162.8690666667207.3099296.9718666667382.002753.5146.9412570.0417333333725.584651039.40153333331337.009625313.4822450.54661616849802.1864646722011.93712.80913.12213.3913.45723.427983333386.4676666667111.384157.8098666667200.60283333331.535.141975129.7015167.076236.7148300.904253105.425925389.1045501.228710.1444902.71275413.52460.37524920.753012.91513.3513.42713.48213.525.491590.3742666667117.58305164.9566666667207.44958333334101.966361.4970666667470.3322659.8266666667829.79833333332203.932722.9941333333940.66441319.65333333331659.5966666667513.52460.37549841.54013.513.513.513.513.526.77591.8120.4875168.3210.375253.55183.6240.975336.6420.75153.55183.6240.975336.6420.75613.52460.37524920.755013.513.513.513.513.526.77591.8120.4875168.3210.3754107.1367.2481.95673.2841.5SUM581.53585833332168.23612786.035653953.42593333335133.7017916667713.3732391.58892611749566.3557044686013.513.513.513.513.526.77591.8120.4875168.3210.375253.55183.6240.975336.6420.75153.55183.6240.975336.6420.75810.5691180.5970500091.51770.89557501357012.13512.6913.0913.37313.523.910586.1163333333111.645375158.2734200.77495.642344.4653333333446.5815633.0936803.082191.284688.9306666667893.1631266.18721606.168.57.087355.9486075032711.897215006808.0929.0959.88710.56911.17215.7649561.606866666778.3462114.0983333333149.14595833331.523.64742592.4103117.5193171.1475223.7189375370.942275277.2309352.5579513.4425671.156812595.104132.9633648641132.9633648648.504.1475.4146.2817.0877.8597.865936.361866666744.579167.577266666792.3404583333215.731872.723733333389.1582135.1545333333184.68091666673.555.0613254.5330666667312.0537473.0408666667646.38320833339.52.76121.047437081242.094874162902.2363.5094.4065.1045.6554.0740523.435066666727.59227543.848666666762.03937514.0740523.435066666727.59227543.848666666762.039375416.296293.7402666667110.3691175.3946666667248.1575100.2020.0082424080.50.0041212049.500.9151.7042.2872.7613.1351.591211.353733333312.933621.507266666731.595208333323.182422.707466666725.867243.014533333363.19041666674.514.3208102.1836116.4024193.5654284.35687551781.060218347510 (A.P.)000.1190.20.2020.122-0.03371666670.76613333330.7101751.40533333332.01804166670.5-0.01685833330.38306666670.35508750.70266666671.00902083335-0.08429166671.91533333331.77543753.51333333335.0451041667553.4736752020.21653333332610.08756253703.78154734.1373333333SUM401.37028333331602.13383333332027.29653752961.74396666673882.0095Diff-180.165575-566.1022666667-758.7391125-991.6819666667-1251.6922916667Transverse moment of inertiaIT181809.055877753
Transverse metacenterBMT9.3203950644KMT13.1024817417LCB-2.6041430064-2.2417488713-2.3255591066-2.1419880555-2.11517698541.73.45.16.88.5WL- 5-2.6041430064-2.2417488713-2.3255591066-2.1419880555-2.1151769854ST NO.YY^3SMProduct0000.500.57.609440.5373675292881.074735058113.0922243.97487468812243.9748746881.513.3272366.99419678324733.988393566213.4572436.9395549931.53655.4093324895313.52460.37549841.5413.52460.37524920.750.50.50.50.50.555555513.52460.37549841.5222224.54.54.54.54.5613.52460.37524920.751111144444713.52460.37549841.5222223.53.53.53.53.5811.1721394.4173604481.52091.6260406721.51.51.51.51.533333DraftLCB8.57.859485.4023407792970.80468155844444222221.7-2.604143006495.655180.8413863751180.84138637522222111113.4-2.24174887139.53.13530.811485375261.6229707544444000005.1-2.3255591066100.1220.0018158480.50.00090792422222111116.8-2.141988055554185.343323080544444222228.5-2.11517698541.51.51.51.51.533333222223.53.53.53.53.5Transverse moment of inertiaIT190250.7610010381111144444222224.54.54.54.54.5Transverse metacenterBMT7.6304423957KMT12.37711621330.50.50.50.50.555555
Calculation of LCF, BML, KML, MCT 1M
WL -1WL -2WL -3WL -4WL -5
ST NO.PRODUCT of AreaLEVERPRODUCT OF MOMENTMULIFLIERS OF MIPRODUCT of MIST NO.PRODUCT of AreaLEVERPRODUCT OF MOMENTMULIFLIERS OF MIPRODUCT of MIST NO.PRODUCT of AreaLEVERPRODUCT OF MOMENTMULIFLIERS OF MIPRODUCT of MIST NO.PRODUCT of AreaLEVERPRODUCT OF MOMENTMULIFLIERS OF MIPRODUCT of MIST NO.PRODUCT of AreaLEVERPRODUCT OF MOMENTMULIFLIERS OF MIPRODUCT of MI0050500050500050500050500050500.504.504.500.504.504.500.504.504.500.504.504.500.515.2184.568.4814.5308.164519.324437.2964149.184111.339445.3564181.424112.047448.1884192.752112.638450.5524202.208113.092452.3684209.4721.521.5483.575.4183.5263.9631.524.2083.584.7283.5296.5481.525.3283.588.6483.5310.2681.526.1143.591.3993.5319.89651.526.6543.593.2893.5326.5115217.9055353.71653161.1495219.2135357.64053172.9215219.683359.0493177.147220.085360.2553180.765220.1855360.55653181.6695351.662103.322206.64353.42106.82213.6353.7082107.4162214.832353.9282107.8562215.7123542108221642712712742712712742712712742712712742712712755400005540000554000055400005540000SUM296.7505SUM321.5245SUM330.301SUM337.062SUM409.6945627127127627127127627127127627127127627127127748.54297.082194.16750.762101.522203.04752.362104.722209.44753.4922106.9842213.96875421082216812.138336.4143109.242813.6425340.92753122.7825814.8305344.49153133.4745815.8535347.56053142.6815816.758350.2743150.8228.58.2943.529.0293.5101.60158.510.8283.537.8983.5132.6438.512.5623.543.9673.5153.88458.514.1743.549.6093.5173.63158.515.7183.555.0133.5192.545592.23648.944435.77693.509414.036456.14494.406417.624470.49695.104420.416481.66495.655422.62490.489.51.834.58.2354.537.05759.53.4084.515.3364.569.0129.54.5744.520.5834.592.62359.55.5224.524.8494.5111.82059.56.274.528.2154.5126.96751005050100.059550.297551.4875100.150.552.5100.10150.50552.525100.06150.30551.525SUM206.702SUM1312.7735SUM237.015SUM1503.6025SUM258.8855SUM1611.4175SUM276.9235SUM1698.872SUM291.427SUM2074.1575Difference-90.0485Difference-84.5095Difference-71.4155Difference-60.1385Difference-118.2675
Momentaboutmiddle ordinate-14986.4716933333Momentaboutmiddle ordinate-14064.6343866667Momentaboutmiddle ordinate-11885.4436133333Momentaboutmiddle ordinate-10008.6500933333Momentaboutmiddle ordinate-19682.8658
CF(aft)about amidship-5.0546718986CF(aft)about amidship-4.4751861379CF(aft)about amidship-3.6683042993CF(aft)about amidship-3.0163606725CF(aft)about amidship-5.5678261919
Moment of Inertiaaboutmiddle ordinate3451992.17955467Moment of Inertiaaboutmiddle ordinate3953784.92265333Moment of Inertiaaboutmiddle ordinate4237288.92150667Moment of Inertiaaboutmiddle ordinate4467254.14404267Moment of Inertiaaboutmiddle ordinate5454082.87809333
Moment of InertiaaboutC.F3376240.48222691Moment of InertiaaboutC.F3890843.06581149Moment of InertiaaboutC.F4193689.49760111Moment of InertiaaboutC.F4437064.44551585Moment of InertiaaboutC.F5344492.10236061
BML1158.2453662501KMLMCT 1mLCFBML457.6759013018BML308.2458002403BML227.4649816467BML214.35309329031159.685708590420096.669537065-5.0546718986KML1159.6857085904459.732031058123159.7801536398-4.4751861379KML459.7320310581KML311.2000011389KML231.2470683239KML217.3530932903311.200001138924962.4374857209-3.6683042993MCT 1m20096.669537065231.247068323926411.0978899753-3.0163606725MCT 1m23159.7801536398MCT 1m24962.4374857209MCT 1m26411.0978899753MCT 1m31812.4529902417217.353093290331812.4529902417-5.5678261919
MIDSHIP SECTION AREA CALCULATIONS
From0 to1From0 to2From0 to3From0 to4From0 to5
WLYSMY x SMWLYSMY x SMWLYSMY x SMWLYSMY x SMWLYSMY x SM0050001000100010000.40113.58108113.5454113.5340.5113.5454113.5113.5213.5-1-13.5213.5113.5213.5340.5213.5227213.5113.5313.5113.5313.5454313.5113.5413.5113.5413.5113.5513.50.45.494.567.594.5148.559.4
Midship Section Area upto WL526.775Midship Section Area upto WL576.5Midship Section Area upto WL5120.4875Midship Section Area upto WL5168.3Midship Section Area upto WL5210.375
Calculation of CB , CM, CP
WLDraftVolumeBLAmCBCMCP11.72914.96135527144.98126.7750.44898609420.58333333330.769690447123.48501.306393333327146.17376.50.64938117190.83333333330.779257406335.113746.461162527147.195120.48750.69516480540.8750.794474063346.819506.582566666727148.47168.30.733489110.91666666670.800169938258.524933.123288888927151.274210.3750.73612839340.91666666670.8030491564
Summary
WL No.DraftWaterplane AreaDisplacementKBKMTMCT 1mKMLCBCMCPLCBLCF(m)(m^2)(tonnes)(m)(m)(Ton-m)(m)(m)(m)
11.72964.87526666672987.8353888751.440342340352.34438508220096.6695370651159.68570859040.44898609420.58333333330.7696904471-2.6041430064-5.054671898623.43142.80433333338713.83905316672.056129756321.479977038923159.7801536398459.73203105810.64938117190.83333333330.7792574063-2.2417488713-4.475186137935.13240.037533333314090.12269156252.954200898615.62090938624962.4374857209311.20000113890.69516480540.8750.7944740633-2.3255591066-3.668304299346.83318.121133333319994.24713083333.782086677313.102481741726411.0978899753231.24706832390.733489110.91666666670.8001699382-2.1419880555-3.016360672558.53535.107825556.45137111114.746673817612.377116213331812.4529902417217.35309329030.73612839340.91666666670.8030491564-2.1151769854-5.5678261919
Graphs
DisplacementDisplacementDraft(tonnes)(m)
2987.8353888751.78713.83905316673.414090.12269156255.119994.24713083336.825556.45137111118.5
Waterplane AreaWaterplane AreaDraft(m^2)(m)
2964.87526666671.73142.80433333333.43240.03753333335.13318.12113333336.83535.10788.5
KBKBDraft(m)(m)
1.44034234031.72.05612975633.42.95420089865.13.78208667736.84.74667381768.5
KMTKMTDraft(m)(m)
52.3443850821.721.47997703893.415.6209093865.113.10248174176.812.37711621338.5
MCT 1mMCT 1mDrafttonne-m(m)
20096.6695370651.723159.78015363983.424962.43748572095.126411.09788997536.831812.45299024178.5
KMLKMLDraft(m)(m)
1159.68570859041.7459.73203105813.4311.20000113895.1231.24706832396.8217.35309329038.5
LCFLCFDraft(m)(m)
-5.05467189861.7-4.47518613793.4-3.66830429935.1-3.01636067256.8-5.56782619198.5
LCB
LCBDraft(m)(m)-2.60414300641.7-2.24174887133.4-2.32555910665.1-2.14198805556.8-2.11517698548.5
CBDraft(m)CB
1.70.44898609423.40.64938117195.10.69516480546.80.733489118.50.7361283934
CMDraftCM(m)
1.70.58333333333.40.83333333335.10.8756.80.91666666678.50.9166666667
WLWL
Sheet2
Sheet3
Sheet4
Sheet5