Pafko Unit Conversions (pafkoUNC.xls/xla)
Add unit conversion capabilities right into Excel! Compound & custom units supported. Complete VBA source code included. Best of all, it's FREE! Once you start using it you won't be able to stop...
pafkoUNC.xls (Excel, 220k)
To Get Started: Enter a number in a cell. Select that cell. Then run the macro "ApplyUnits()" to add units (press Ctrl+Shift+U). Use the function "Convert(source)" to convert from the source cell units to the destination cell units. Note: When loaded as an excel file you will need to call the function as "pafkoUNC.xls!Convert(source)".
To add your own custom units unhide the sheet (Windows/Unhide) then add your units in the "units" sheet of pafkoUNC.xls.
If you like it, just add it to your XLSTART folder & it will load everytime excel starts.
Transient 1D Conductive Heat Transfer
Mathcad file that calculates transient conduction in a slab using a finite difference algorithm.
wmp_finite_difference.mcd (Mathcad 8+), wmp_finite_difference.pdf (Acrobate)
Heat & Mass Transfer 'C' Code
The following c code solves transient heat & mass transfer problems. They are relatively straightforward, however the code has several special features:
Here's the code (just remove the .txt extension, change the defines to match your problem, compile, & execute)...
Compile with Microsoft Visual C++ v4.0 or higher.
© 2001 Wayne Pafko (firstname.lastname@example.org).