U Value (Heat Loss) Calculator

[Harry Taylor]

Does any have a U valve / heat loss calculator in Access I could have?

I have one in Excel, written many years ago by someone else and very long winded.
There are plenty on the internet but I'm looking for an access standalone program I can incorporate into our database system.

I know its a long shot, but I thought id ask

Thanks again
Harry

 

[June7]

I once had to convert an Excel workbook that did a very complex calculation involving matrix multiplication. I tested 2 ways of calculating within Access VBA and compared to the Excel workbook. I got 3 different results.

Will probably have to program this yourself and beware of results.

 

[MajP]

Can you post an example of the Excel worksheet? I assume there is much more to this, but the equations I am seeing look pretty basic. Looks like it is 1/sum(individual resistance). Can you describe your inputs and how they are stored in the db? I probably can roll a calculator.