Description
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
Limitations
1. This application is limited to design of Wageningen B-series propellers
References
1. Principles of Naval Architecture, Part 2, Edward V. Lewis
Anonymous (verified owner) –
Very useful & powerful tool for propeller performance analysis, proved invaluable to us
ANDREW BAKER (verified owner) –
I have used this spreadsheet a few times now and found it easy to use. It does exactly what it promises to do.
Nigel H. (verified owner) –
Handy little spreadsheet that allowed me to quickly confirm gearbox ratio without having to trawl through PNA. Thank you!