interpol - When you have calculated the answer on a sheet...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Sheet1 Page 1 Interpolation This spreadsheet enables you to practice interpolations of the type you need to perform when using thermodynamic tables. In this instance, the generic x and y will be used, instead of the usual p, v, T, h, s, . .., of thermodynamic problems. To receive a new problem, click on the Office logo, and enable the "developer"'s tools This will create a new menu tab at the top of the spreadsheet, click on Macro and doubleclick on interpol Then you need to allow the macros to run (macro security)
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: When you have calculated the answer on a sheet of paper, enter it in the dialog box The result will be plotted automatically and an evaluation of your result will be displayed. x y x1, y1: first pair 0.5724756 0.9606287 interpolate here 0.4985351 0.50-17.21% <--- % error x2, y2: second pair 0.4170147 0.2106242 0.4 0.42 0.44 0.46 0.48 0.5 0.52 0.54 0.56 0.58 0.6 0.2 0.4 0.6 0.8 1 1.2 Interpolation 0.9606287479 0.2106241584 0.50 X Y...
View Full Document

Ask a homework question - tutors are online