Numerical Recipes Forum  

Go Back   Numerical Recipes Forum > Obsolete Editions Forum > NR in Other Computer Languages

Thread Tools Display Modes
Old 01-02-2009, 08:15 AM
MPD78 MPD78 is offline
Registered User
Join Date: Dec 2008
Location: Pittsburgh, PA
Posts: 196
Convergence problem in VBA in Access

Hello, I am a database developer/Mech. Engineer and amateur mathemagician and my problem is this;

I have a simple convergence loop that is used in a heat transfer problem of radial geometry to pedict the interface and outer surface temperatures in an insulation system with a varying thermal conductivity. I am following the ASTM C-680 procedure and this method works fine for plane insulation systems but blows up on radial insulation systems. I think this problem is due to the log function that is required in the heat transfer equations of a radial system.

Basically the way this works is as follows;

The program makes a geuss at what the outer surface and interface temperatures are in a system of 3 layers. (2 interface temperatures and the outer surface temp.) This geuss is based on the hot face temperature. The program then executes in a do...until loop which simply compares the previously calculated temperatures with the newely calculated temperatures until their difference is less than 0.01. In the radial system calculations the intial guess temperature runs through the loop and then in the next iteration a new temperature is calculated based on the previous temperature and for some reason on this second iteration the temperatures go up into the thousands of degrees when it should be at most a couple of hundered degrees.

Does anyone know of a way to "damp" this problem and achieve convergence?

In C++ I don't have this problem but I have to use Access on this project.

Thank you very much.
Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is On

Forum Jump

All times are GMT -5. The time now is 12:16 AM.

Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.