Savitsky Power Prediction

Discussion in 'Software' started by guest12020101217, Sep 23, 2003.

  1. guest12020101217
    Joined: May 2003
    Posts: 40
    Likes: 0, Points: 0, Legacy Rep: 10

    guest12020101217 Junior Member

    Hi all

    I am writing a savitsky planing power prediction porgram in Mircosoft excel at the moment. Well in fact l am writing two! One using the thoery in principles of yacht design and the other from copies of savitsky's and others papers.

    Can anybody tell me how l can get Excel to solve equations like the one below. I need to solve for CLo.

    CLb = CLo - 0.0065*B*CLo^0.6

    CLb = Deadrise Lift Coefficient
    CLo = Flat Plate lift Coefficient
    B = deadrise angle.

    I can do it by getting excel to plots graphs and me having to pick the value off and enter it in, but l really want excel to solve it.

    I want to do the same when solving for the wetted length/wetted beam ratio (L).

    CLo =t^1.1 x {0.012L^0.5 + (0.0055L^(5/2))/Cv^2}

    t=running trim
    L=wetted length/wetted beam ratio
    Cv= Speed coefficient

    Plan to develop the programs over time and use Maxsurf's Hullspeed as base data. May but the program on net when happy with it.

    Any help or comments are very welcome.
     
  2. Dim
    Joined: May 2003
    Posts: 315
    Likes: 3, Points: 0, Legacy Rep: 114
    Location: somewhere

    Dim Senior Member

    all input data - "from my mind". Check formulas, please.
     

    Attached Files:

  3. guest12020101217
    Joined: May 2003
    Posts: 40
    Likes: 0, Points: 0, Legacy Rep: 10

    guest12020101217 Junior Member

    To Dim

    Thanks for your help, but think l didn't explain what l needed help on clearly. Need excel to find CLo from a inputted value of CLb, in the first equation and then use that value to solve for the wetted length/wetted beam ration "L" in the second equation.
    But, once again thanks for the reply.
     
  4. Dim
    Joined: May 2003
    Posts: 315
    Likes: 3, Points: 0, Legacy Rep: 114
    Location: somewhere

    Dim Senior Member

    on first to yours post, I have understood (not correctly has understood), that the help on job with Excel is simply necessary.
    :)
    Dim.
     
  5. BrettM
    Joined: Apr 2002
    Posts: 204
    Likes: 3, Points: 0, Legacy Rep: 16
    Location: Australia

    BrettM Senior Member

    Use solver... May be easier to rewrite the eqn to equal zero so you don't have to think next time.... Can also set up a macro button to automate it. Good Luck.
     
  6. nevd
    Joined: Nov 2003
    Posts: 99
    Likes: 0, Points: 0, Legacy Rep: 10
    Location: Australia

    nevd Junior Member

    Hello,

    As a new member, I think your project will be very useful to myself and many other members.

    Please advise how the programme is progressing.

    nevd
     
  7. nico
    Joined: Jan 2003
    Posts: 190
    Likes: 6, Points: 0, Legacy Rep: 52
    Location: SF

    nico Senior Member

    Hi,

    When u think that all the formular are right,etc.. If i have the file, i could program a bit and add some macros using the solver from excel (I am already using it for a VPP). I think it is easy to understand VB language so it ll be easy to change.

    Nico
     
  8. guest12020101217
    Joined: May 2003
    Posts: 40
    Likes: 0, Points: 0, Legacy Rep: 10

    guest12020101217 Junior Member

    Thank you for the offer. It been on the back bench as l am still waiting for copies of the papers by savitsky from SNAME. Want included pre planing prediction. I will be making the program free on the WEB but not until l am 100% happy with it. Plan to learn VB myself as there is other plans for programs l want to follow up.
     
  9. tspeer
    Joined: Feb 2002
    Posts: 2,319
    Likes: 303, Points: 83, Legacy Rep: 1673
    Location: Port Gamble, Washington, USA

    tspeer Senior Member

    Did you ever get a real answer to your Excel question?

    There are a couple of ways to solve the equation. One is go to the Tools menu and using Goal Seek. Tell it to set Clb to the value you want by varying Clo.

    If you have several sets of equations to solve for, you can have a column of desired values for Clb, a column of Clo values (loaded with initial guesses), a column of Clb's calculated from the formulae, and a column of squared errors. Sum the squared errors in one cell, and use Tools/Solver to minimize the sum of the squared errors using the Clo cells as the parameters to vary.

    You can also do it by intentionally setting up an implicit loop and going to manual calculation. Hit F9 repeatedly to iterate to the solution once you have your starting guesses entered.
     
  10. Guest

    Guest Guest

    On the web

    Congratulations for taking the time to do learn Savitsky by doing this instead of just using available programs.

    However, if you want to have a benchmark to check your answers, search on "fishmeal" and "kamen". His site has a free Savitsky program for download.
     
  11. guest12020101217
    Joined: May 2003
    Posts: 40
    Likes: 0, Points: 0, Legacy Rep: 10

    guest12020101217 Junior Member

    To Guest

    Thank you for your support and links. They where very useful
     
  12. Humberto Rodrìg
    Joined: Dec 2003
    Posts: 9
    Likes: 0, Points: 0, Legacy Rep: 10
    Location: Venezuela

    Humberto Rodrìg Junior Member


    I´d like to have more info on your program. Please contactme at HumbertoR92@hotmail.com
     
  13. Guest

    Guest Guest

    I have already written an Excel spreadsheet to solve Savitsky's planing hulls. Give me your e-mail and I will send it to you. You can either use it, or see how I get Excel to solve Clo by itself.
     
  14. gonzo
    Joined: Aug 2002
    Posts: 16,790
    Likes: 1,714, Points: 123, Legacy Rep: 2031
    Location: Milwaukee, WI

    gonzo Senior Member

    Would you post it?
     

  15. Dingo
    Joined: Dec 2003
    Posts: 43
    Likes: 5, Points: 0, Legacy Rep: 89
    Location: South Australia

    Dingo Junior Member

    Here is my spreadsheet on Savitsky and other methods. It contains various allowances for trim-tabs and shafts etc. Unfortunately, it was written by me in Dutch and Afrikaans, but the symbols and references should pose no problem. Any translation problems just e-mail me at: dingo at postmark dot net.
     

    Attached Files:

Loading...
Forum posts represent the experience, opinion, and view of individual users. Boat Design Net does not necessarily endorse nor share the view of each individual post.
When making potentially dangerous or financial decisions, always employ and consult appropriate professionals. Your circumstances or experience may be different.