What does this Excel App do?
This Excel sheet helps you calculate the propeller particulars from Wageningen B-series data
****IMPORTANT: To Run this application, you need to enable the Solver Add-In of Excel. Please to see steps —>
How to use?
The user is asked for some inputs for the propeller and vessel engine details. The Input cells are highlighted in blue.
The user has to provide all the inputs highlighted in blue in the Worksheet “Inputs”
ONLY INPUT THE CELLS HIGHLIGHTED IN BLUE. LEAVE ALL OTHER CELLS UNTOUCHED!
In the ‘Calculation Methods’ excel sheet, there are three options. Choose either of them.
Once all inputs provided and a calculation method selected, the propeller particulars are calculated and displayed in the ‘Outputs’ worksheet
1. This application is limited to design of Wageningen B-series propellers
1. Principles of Naval Architecture, Part 2, Edward V. Lewis