But let us imagine we together built a ship. Or something looking like a ship. A smaller one may be. If I want to know the answers to these questions, one thing is for sure. We need to be able to understand the language of ship stability. But not if you know the basics of ship stability. Once you know these basics, all other parts of ship stability will be as easy as eating a pancake. Why does a small metal ball sink in water but not ship?

Probably the first question that a Pre-sea cadet is asked during his training. The answer lies in the Archimedes principle. A body wholly or partially immersed in a liquid is subject to an upthrust equal to the weight of the liquid displaced by the body.

Try to force a ball down into the water. You will feel a force stopping you from doing that. This is the upthrust we are talking about in Archimedes principle. This upthrust will be there on any object you place in water. When we place any object into the water, that object would displace some water. I bet everyone knows it because even the birds know it. Remember the story of thirsty crow? So if we drop a stone in a jar completely filled with water, some water would spill out of the jar because the stone has displaced some water.

Now let us see what Archimedes principle is trying to say? It is giving us a way to calculate the amount of upthrust that an object will feel when immersed in water or in any liquid. So if we have to make something float, all we 4age 20v to do is to make sure that it displaces more water than its own weight.Discussion in ' Stability ' started by Hussein AtwiApr 12, Log in or Sign up.

Boat Design Net. Hi, I currently started my first internship after graduating, I work mainly on Heavy haul. I have been tasked to learn and attempt to create an excel sheet that does Hydrostatic stability calculation for barges. In essence, what they want me to create is If we have Object ABC and we know the size of the barge that will be used to Offload the pieces etc. I want to be able to calculate all what is required on to ensure nothing tilts I guess. Sorry, I'm a newbie and would appreciate help or guidance on what I should look into and what to focus on.

I will also add an example of the barge that we commonly work on.

### Marine Calculators

Hussein AtwiApr 12, We definitely shouldn't give you a strict answer how to do it. This should be your lesson. But I'm sure we can guide you. Excel gives you opportunity to implement your own code. This is visual basic if I remember correctly. So use it. All the software works in similar way. You get a volume, which you integrate to treat as a series of areas, and those areas you also integrate to treat as a series of smaller areas.

In your case you should treat this task in 2D rather than 3D, which makes it fairly trivial. I think what you should concentrate on is how to describe a introspection.

In simplest case you will have X,Y coordinates of 4 corners of crossection and by interpolation you search for remaining 2 points, which are the intersection of your shape with waterline. This way you will get all the 2D coordinates you need, and with use of them you can calculate area properties.

Thank you for the prompt response, Of course I was not aiming to get the right answer. I am just trying to limit my searches to what I should be focusing on.Seperti janji saya kemarin pada postingan sebelumnya bahwa saya akan membahas tentang perhitungan stabilitas kapal, kawan pelaut sebagai nakhoda ataupun officer diatas kapal sangatlah penting mengetahui stabilitas kapal dari kapal kawan pelaut mengingat selain jiwa manusia yang dipertaruhkan banyak kerugian lainnya yang dampaknya sangat besar seperti kerugian financial serta dampak bagi lingkungan.

Oh iya stabilitas kapal penting juga dipahami oleh petugas syahbandar sebagai otoritas suatu pelabuhan, jadi stabilitas kapal bukan hanya penting untuk nahkoda atau officer saja.

**Calculating Stability Parameters with a simple Excel Macro**

Disini saya sepertinya gak perlu menjelaskan pajang lebar mengenai pentingnya pengetahuan tentang stabilitas kapal, saya yakin kawan pelaut semua tahu semua jika tidak kawan pelaut buka lagi buku- buku usangnya.

Saya mempunyai suatu program excel yang saya buat untuk memudahkan pekerjaan saya dan saya mau berbagi lewat blog saya yang kumuh ini.

Sebenarnya untuk membuatnya sangatlah mudah, kita hanya menerapkan semua rumus yang kita dapat dari sekolah lalu sedikit pengetahuan tentang excel, sayapun awalnya coba - coba karena sebelumnya saya gak pernah mengikuti kursus computer.

Karena keingintahuan saya yang besar akan computer, sayapun membeli komputer saat punya rezeki sedikit. Sejak saat itulah saya belajar computer secara otodidak. Apalagi setelah mengenal yang namanya internet serta berkenalan sama mbah google apapun terasa mudah karena apapun pertanyaan yang ada di kepala pasti bisa dijawab sama mbah google. Seperti postingan sebelumnya kawan pelaut harus menyesuaikan data di file sesuai dengan data kapal kawan pelaut karena data pada file ini adalah data kapal MV.

Jika pada postingan kemarin saya katakan hiraukan table sebelah kanan maka pada postingan ini kawan pelaut harus menyesuaikannya dengan data - data kapal kawan pelaut.

Sedangkan untuk sheet stability calculation kawan pelaut harus menyesuaikannya dengan data particular kapal kawan pelaut seperti yang saya lingkari biru pada gambar dibawah ini. Setelah menyesuaikan data —data di atas pekerjaan kawan pelaut dah selesai. Kawan pelaut bisa mendapat informasi data—data tentang stabilitas kapal, trim, draft, dll ditengah dari sheet seperti gambar di bawah yang saya lingkari biru.

Kurva disebelah kanan dari sheet adalah kurva GZ untuk masing — masing kemiringan pada displacement kapal saat itu seperti gambar dibawah ini. Stability calculation ini bisa diterapkan di semua type kapal contoh diatas adalah contoh perhitungan untuk kapal general cargo, misal.

Mungkin penjelasan saya kurang jelas kawan pelaut bisa beri koment di bawah, atau lewat contact me lewat email atau lewat form document begitu juga jika kawan pelaut ingin mendapatkan program excelnya, dan jangan lupa klik disini. Baca juga disini tata caranya. File excel ini hanya bisa digunakan untuk sister ships dari unipac 3, jika diterapkan untuk kapal yang berbeda maka butuh banyak penyesuaian.

Sekarang saya telah membuat perhitungan stabilitas excel yang bisa diterapkan untuk semua kapal untuk itu baca postingan saya berikut.

Blognya perwira laut menyediakan fasilitas berbagi dibawah artikel ini silahkan klik pada tombol berbaginya. Blognya perwira laoet menulis artikel inipun dengan maksud berbagi kepada kawan-kawan. My name is kartheek, doing my master's in renewable energy wind energy. The important thing is that I have been facing problems for calculating the righting arm and heeling moment of a rectangular barge dimensions L, B, H is 60,40,20 with a draft of 10 Meters. I have seen few calculations in the web but still i'm unable to figure it out.

It would be great if you could explain me little bit more in detail if you know. Calculating this stuff is more crucial part in my Master thesis.

Thanks in advance here is my email address karthikreddy. I would like to answer your question M. Hello, Can anyone help me out in calculating the righting arm and heeling moment curves of a rectangular barge. I was been spending so much time on it but i couldn't manage to find the correct results. If any of you knew it or done it in their past please do let me know. Boleh dong ndan minta calculasi untuk stability n draft surveynya Email ane gama. Terima kasih Gan atas ilmu-nya Benar-benar bermanfaat Ogut minta Stability Calculation Excel-nya ya Gan.

Trima kasih sebelumnya email : dayonea gmail. Mantepp postingnya bro Makasih bro and sukses selalu Masbro, minta tolong kirim ke ikhsan. Tolong dikirimkan ke email saya maslah perhitungan stabilitas kapalnya sekaligus yang ada di Microsoft Excel,berhubung tidak bisa sebagian saya buka,terima kasih!Page 3. System of c onstructi on. Page 4. Page 5. Page 6. Void sp aces. Page 7. The barge will be designed as an unmanned, non-propelled steel deck barge for launching jackets up to 30, t.

Load out and launching operations will be performed in the X area. In addition to launching operations the barge will be used as transportation barge for miscellaneous items, such as topsides and process equipment. It is the intention of this specification to provide a description, covering the design and technical requirements for the building, outfitting, testing and delivery of the Barge.

The specified data shall be verified by the Yard during the Detailed Design Stage. Page 8. The axes convention used in the project is presented in Figure 2.

Figure 2. The origin of the system is as follows:. X positive to bow. Y positive to PS. Z positive upwards. The units as used in this document are summarized in Table 2. Table 2. Lubrication Oil. Marine Gas Oil. Page 9. The SI metric system shall be used as the primary means to describe physical quantities. Common commercial designations, when used in a descriptive manner not involving calculations, may be expressed in the customary units.

The following SI units, SI derived units and permissible non-SI units should be used in all drawings, specifications, etc. Plane angle. Speed velocity Power Angular velocity Acceleration Force. Pascal Stress deck load per square meter kilogram per cubic meter metric ton per cubic meter. Specific volume. Rate of flow. Electric current. Electric voltage. Electric power. Suction head. Page The following terms appearing in this specification shall be understood as stated here after:.

The unmanned, non self-propelled launch barge, of which the design, technical requirements and construction details are defined in this specification and the accompanying plans. The present specifications and accompanying plans and documents representing this design.Excel Categories. Close Window. Get Your Free Excel ebook! Top 15 Excel Tutorials. Instant Access! The download link for the file has been sent to the email you provided.

If you don't see it, check your spam or promotions folder. Stability Spreadsheet. Similar Topics.

Stability Spreadsheet - Excel View Answers. First time user. I've been going OK with the basic functions. Column addition, links, row multiplication etc. Thought I had it cracked and looking like really good gear for my ship stability calculations.

Not even close. Is there a way of tracking the blunder or resetting cells to zip? Hello, I have a number of different files that I often need to run a macro on. In order for me to do it on the files I have at any given time, I need to open one, run the macro, close and save, then open the next one.

Is it possible to write a macro that will start with the first file in a folder, open it and update links, run a macro, save and close, and open the next file in the folder until it has open all the files in the folder. I have experience with creating macros that reference different workbooks, but not sure how to go about opening files with different filenames without referencing the exact filename. I'd like to be able to have basic code for opening, saving and closing, opening next file, saving and closing, etc.

Is this possible? Any help is greatly appreciated!! Thanks, Jason. Tracking Attendance Percentages - Excel. I have created an excel spreadsheet to track attendance of an exercise class I am teaching. I would like to know each person's current percent attendance. I would like it to keep a running tab, so as I add in the person's attendace it will continue that count, up to the 26 classes that are being offered. Do you have a suggestion that would work? I did a bit of browsing on this problem.

Found others suffering the same but haven't found any conclusive answer yet. Every so often when I attempt to save a file, including save asExcel won'r let me. By won't let me I mean: using Save doesn't appear to do anything using Save As doesn't either do anything, the dialog is not displayed and if I am doing via the File menu then the File menu is exited and the previous ribbon tab is displayed i.While rolling on 0-point is at start of ramp on land side While rolling off 0-point is at start of ramp on barge side Reference point is at mid keel at the bow.

Weight per row mT Overall Weight on land mT 1, Total OK? Pumped Quantity LBS 24, 0,0 0 0,0, 0 00, 0 22. Total pumped water LBS Nos. Tank 1 portside bow Tank 1 port center bow Tank 1 starboard center bow Tank 1 starboard side bow Tank 2 portside Tank 2 port center Tank 2 starboard center Tank 2 starboard side Tank 3 portside Tank 3 port center Tank 3 starboard center Tank 3 starboard side Tank 4 portside Tank 4 port center Tank 4 starboard center Tank 4 starboard side Tank 5 portside Tank 5 port center Tank 5 starboard center Tank 5 starboard side Tank 6 portside Tank 6 port center Tank 6 starboard center Tank 6 starboard side Tank 7 portside Tank 7 port center Tank 7 starboard center Tank 7 starboard side Tank 8 portside stern Tank 8 port center stern Tank 8 starboard center stern Tank 8 starboard side stern.

Weight mT 0. TCG mtr 0. LCG mtr 0.

VCG mtr 0. Pumped Quantity mT 0. Buoyancy Long. Cntr Flotation Moment to change trim Metacentric Height. Tank 1 is at bow 4. If capacity is 0, this tank is not present 5. Reference point is at mid keel at the bow 6.

Overall pump time excludes handling time. Ramps Ramps Ramps P1 4 Nos. Freeboard at jetty Jetty - water distance Barge - Jetty distance Time involved to pre-ballast Start, time elapsed since mean tide Time elapsed since mean tide. Boyancy Long. Freeboard at jetty Jetty - water distance Barge - Jetty distance Time involved ballast step 1 Time elapsed since pre-ballast Time elapsed since mean tide. Freeboard at jetty Jetty - water distance Barge - Jetty distance Time involved ballast step 2 Time elapsed since pre-ballast Time elapsed since mean tide.

Freeboard at jetty Jetty - water distance Barge - Jetty distance Time involved ballast step 3 Time elapsed since pre-ballast Time elapsed since mean tide. Freeboard at jetty Jetty - water distance Barge - Jetty distance Time involved ballast step 4 Time elapsed since pre-ballast Time elapsed since mean tide.

Freeboard at jetty Jetty - water distance Barge - Jetty distance Time involved ballast step 5 Time elapsed since pre-ballast Time elapsed since mean tide. Freeboard at jetty Jetty - water distance Barge - Jetty distance Time involved ballast step 6 Time elapsed since pre-ballast Time elapsed since mean tide. Freeboard at jetty Jetty - water distance Barge - Jetty distance Time involved ballast step 7 Time elapsed since pre-ballast Time elapsed since mean tide.

Freeboard at jetty Jetty - water distance Barge - Jetty distance Time involved ballast step 8 Time elapsed since pre-ballast Time elapsed since mean tide.

Freeboard at jetty Jetty - water distance Barge - Jetty distance Time involved ballast step 9 Time elapsed since pre-ballast Time elapsed since mean tide. Freeboard at jetty Jetty - water distance Barge - Jetty distance Time involved ballast step 10 Time elapsed since pre-ballast Time elapsed since mean tide. Freeboard at jetty Jetty - water distance Barge - Jetty distance Time involved ballast step 11 Time elapsed since pre-ballast Time elapsed since mean tide.

Freeboard at jetty Jetty - water distance Barge - Jetty distance Time involved ballast step 12 Time elapsed since pre-ballast Time elapsed since mean tide. Freeboard at jetty Jetty - water distance Barge - Jetty distance Time involved ballast step 13 Time elapsed since pre-ballast Time elapsed since mean tide. Freeboard at jetty Jetty - water distance Barge - Jetty distance Time involved ballast step 14 Time elapsed since pre-ballast Time elapsed since mean tide.

Freeboard at jetty Jetty - water distance Barge - Jetty distance Time involved ballast step 15 Time elapsed since pre-ballast Time elapsed since mean tide. Freeboard at jetty Jetty - water distance Barge - Jetty distance Time involved ballast step 16 Time elapsed since pre-ballast Time elapsed since mean tide. Freeboard at jetty Jetty - water distance Barge - Jetty distance Time involved ballast step 17 Time elapsed since pre-ballast Time elapsed since mean tide.This article is focused on quickly determining trim, list and initial stability of simplified box barges.

## Barge Design Spec

There are several benefits this approach. First, because it is quick and simple, it is efficient. Second it helps a person to easily and firmly grasp complex hydrostatics concepts involving trim, list and stability.

With this method one can approximate how barge deck cargo distribution affects operating trim, list and GM metacentric height. Another use would be to estimate how much a barge trims and lists with a crane and a hook load present. This article is primarily focused on initial stability.

These types of calculations normally apply from zero up to about ten degrees of heel. As a vessel rolls into larger angles of heel another calculative method is required. This second approach is not within the scope of this article. This second method often involves the use of a computer model for the hull. This later approach requires considerable labor. From a safety point of view, this second calculative is normally more important than the first method, especially with regard to sea going vessels and sailing crafts of all types.

Note that a computer model can also be conveniently used with the first method, but it is usually necessary with the second method. A computer model is also more flexible in the variety of hull orientations that it can handle. For formal calculations, which are prepared for submittal to regulatory agencies and other maritime entities, a computer model is often required. The approach here is aimed at assisting with operational decision making, and it is focused on processing data quickly and simply without the use of a computer model.

Conditions for Applicability. There are important restrictions that apply to trim and list with this simplified method.

Also some operating guidelines and their rationale are discussed in this part. For box barges, no portion of the bottom of the hull should be allowed to be lifted out of the water.

If any portion of the barge bottom lifts out of the water these simplified calculations do not compensate for this effect. It is important to remember that the trim is based on the longitudinal weight distribution.

However, if weights are unbalanced in the transverse direction, say due to a crane lifting a load over the side, then the vessel will heel. So in cases like this, both trim and list effects require consideration.

### Barge Stability

Similarly, no portion of the barge deck maybe submerged. If the barge deck submerges the accuracy of the results diminish with this method. Water on deck is also unsafe for personal and equipment. It is also good marine practice to keep trim and heel to a minimum. So, for safety reasons a vessel operator should keep vessel trim and heel to a minimum. Further operational margins should be established, so that the bottom never gets exposed to the air, and the deck never gets submerged. Free surface effects of any liquids on board are not within the scope of this article.

If large free surfaces are present, the operator should compensate for these effects. Effects of Rakes and Sharpened Ends. The effects of rakes are ignored with this method. If forward and after rakes are present, and the length of these rakes are equal, this method will give conservative results.

## thoughts on “Barge stability calculation excel”