=ROUND(BN6*BN8*BN9/210,-1). I am using 218 for the divisor and round the result. For the approximate dimensions, in Amsterdam feet, for the Dutch flagship Brederode, the size is calculated to be 350 lasten (lasts).
Saturday, January 19, 2008
My approximate "lasts" formula
I have a spreadsheet that I use for generating proportions for drawing Dutch ships from the period of 1628 to 1678. One of the figures that I calculate is just for information: the size of the ship in lasts. There is a VOC-related page that gives the formula: length x beam x depth / 200. My Excel formula is somewhat different: