×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Excel CFD
2

Excel CFD

Excel CFD

(OP)
I already know what you're thinking... why? Maybe even "how?"

Independant work, using the tools I have available on my home laptop. I'm not wealthy enough for the fancy software packages for personal use.

I have found a nice solver algorithm package as a good starting point, but I want more. I understand and have written my own Navier-Stokes equations / solver in MatLab before, but no longer have access to that software. Do any of you know some macros or VBA code for running simulations in Excel? Or even a really good refresher publication for how to set up the equations and get them ready for programming?

Conditions would be simple: steady state, incompressible flow at low reynolds numbers. The idea is to calculate the drag on a submerged object in water, for example.

Thanks!

RE: Excel CFD

Maybe you can upgrade the tools on your laptop inexpensively; have you had a look at CAElinux? It has modules for meshing, FEA, and CFD. It is open source in case you want to inspect the inner workings or expand what is there.
 

RE: Excel CFD

Octave might be an easier step.  Matlab-like and free.

RE: Excel CFD

(OP)
Free is good. Open source is also excellent for what I want to do. In the end, I plan to resurrect my old GA for shape optimization. It'd be nice to figure out how to get that to talk to whatever package I end up running.

I'm pretty confident I can get this Excel thing to work. It may seem silly, but for some fun side project, the fun is the challenge. I guess I should get my old class notes out.

Thanks!

RE: Excel CFD

Quote (Enginerd9):

I have found a nice solver algorithm package as a good starting point
Is the solver package functional code? If so, you may be able to get VBA to pass information between Excel and the solver. Reference thread770-279111: ALGLIB Statistics functions for Excel to see an example from Excel expert (and eng-tips member) Doug Jenkins (aka IDS).

RE: Excel CFD

(OP)
Yes! Great link!

http://www.basicnumerics.com/bflow/

It's actually a really nice package to start with. I've only run a couple of example problems through it, but it seems solid enough. I'm still evaluating it.

Thanks!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources