have you compared it to other existing similar tools ?
Not yet, but I can tell you about my approach and my sources :
For the residuary drag :
I used the available output data of model tests as reported by :
- P. van Oossanen in « Resistance prediction of small high-speed displacement vessels » where I picked up the ones for slender hulls (i.e. Lw/Bw > 7) in Series 64, SSPA series and NPL series.
- Molland & al. in « Resistance experiments on a systematic series of high speed catamaran forms – Variation on length-displacement ratio and breadth-draught ratio », the Southampton series.
The 2 papers are attached, I put all these data in same units and presented the results in the form of adimensional data and curves ready to use in « Data to estimate the residuary drag of a catamaran » also attached, from which I have developed the spreadsheet file.
The key point for narrow monohulls of Lw/Bw > 7, highlighted by P. Oossanen in his paper and confirmed later on by Molland results was that, I quote P.Oossanen (page 219), «Up to Fn-value of about 0,9, the results for the 3 B/T values are almost identical, again leading to the observation that in the speed range of Fn 0,4 – 0,9 the length-displacement ratio is the only significant parameter », the LD ratio being Lw/Dc^1/3 (Lw waterline length, Dc displacement of the canoe body hull).
The other crucial point is the amplification factor due to interaction between the 2 hulls, fully adressed by Southampton series / Molland experiences. In adimensional, Residuary drag : Dr/Mg (%) Cata = (1+K) * Dr/Mg (%) Monohull
Here it is less simple to resume the respective role of Lw, Bw, Tc and Dc combined with S the space between hull axis. You can see the various cases in Fig. 3 to 12 of my paper, that we can average in Fig. 2 when keeping only S as main parameter. Currently for my spreadsheet, I use an enveloppe of all the "Molland" cases which actually look likes the Fig.2 with space S as unique parameter and is a priori a conservative approach, but I hope to do better for the final version.
So in conclusion, one can estimate that way the residuary drag of a catamaran for Fn 0,4 – 0,9 (let'say 0,3 - 1,0 still acceptable) and under the condition that Lw/Bw > 7.
Why no longer reliable for Fn > 0,9 -1,0 ? : because then the hulls are no longer primarily in displacement mode, dynamic lift forces occur, and then a lot of parameters like sections shape (circular or in U), Bw/Tc, trim, … can change the resulting drag.
Why possibly inacurate for Fn < 0,3-0,4 ? : because the wave fields and their interaction are more complicated, but it should be noted that such speed is usually not a design objective except for slow by purpose catamaran.
For the friction drag and the aero drag :
State of the art formulations as for any boat project, for friction I use the ITTC57 formula for Cf with the Reynolds based on 0,7 Lw as recommended by Larsson & Eliasson in « Principles of Yacht design ». The key points being of course to have a right value of the wetted surface for the design displacement (for friction drag), of the frontal area and its global Cx (for the aero drag).