Hybrid Car – More Fun with Less Gas

Ideal Gas Law help please - Page 4

register ::  Login Password  :: Lost Password?
Posted by Curbie on December 26, 2010, 12:43 am
 

Morris,

I posted this link before, but apparently wasn't clear on it what it
was, it's not only steam tables, but more importantly, it contains the
code in VBA (formulas) that generates the steam tables.

http://www.x-eng.com/Download/Excel_Steam_Tables/XSteam_Excel_v2.6.xls

They also has the same code for OpenOffice (I think) if you'd prefer,
if you don't use either, I'll post the VBA code as text if would
prefer that way to convert if to C.

Curbie


Posted by Curbie on December 26, 2010, 2:44 am
 

Morris,

I DEFINITELY wasn't clear, it does NOT contain steam tables, just the
code in VBA (formulas) that generates the steam tables; I generated my
own steam tables using this code, my apologies!

Here's an image of the steam table the code generated for me:
http://i825.photobucket.com/albums/zz177/Curbie_Pics/SteamTable.jpg

The steam table's results are not in the metric units you want, but I
think the function names are the same in the metric version of the
code, the point of the image is that the function hooks into the code
are shown on row 6 of the image's spread-sheet which are the formula
expressions to generate the table results for each column.

Sorry, I just don't remember the details of code I played with last
week, let alone years ago, just play with too much of it.

Curbie


Posted by Morris Dovey on December 26, 2010, 2:50 am
 On 12/25/2010 6:43 PM, Curbie wrote:


I can open the spreadsheet with OO, but would very much appreciate the
VBA code if the variables are more clear than row:column references.

Thanks.

--
Morris Dovey
http://www.iedu.com/DeSoto/
PGP Key ID EBB1E70E


Posted by daestrom on December 27, 2010, 12:55 am
 On 12/24/2010 15:21 PM, Morris Dovey wrote:

Funny, this reference says the 22.4 is at 0 C, not 20 C.  That's why I
mentioned it.

http://hyperphysics.phy-astr.gsu.edu/hbase/kinetic/idegas.html#c4

<snip>

daestrom

Posted by Morris Dovey on December 29, 2010, 10:58 pm
 On 12/26/2010 6:55 PM, daestrom wrote:

Further exploration confirms this. I seem to have a talent for looking
in the wrong places. :-/

I'm not sure where I found the info at this point, but I may have been
confused by the (sub)article at

   http://en.wikipedia.org/wiki/Avogadro%27s_law#Molar_volume

Whatever - I've made corrections where needed and ordered a textbook and
an engineering reference to (I hope) provide a more consistent quality
of information.

Thanks!

--
Morris Dovey
http://www.iedu.com/DeSoto/
PGP Key ID EBB1E70E


This Thread
Bookmark this thread:
 
 
 
 
 
 
  •  
  • Subject
  • Author
  • Date
please rate this thread