"There is a great satisfaction in building good tools for other people to use."
Freeman Dyson (Born: 1923); British-born U.S. physicist and mathematician.
Three Dimensional Interpolate and Extrapolate Functions; Two Dimensional Interpolate, Extrapolate, Cubic Spline, Polynomial Curve Fitting, Line Intersections, Minima, Maxima, First Derivative, Second Derivative, and other functions.
XlXtrFun.xll is a collection of functions which extends the capabilities of Microsoft Excel; developed primarily to facilitate, interpolation of 2-dimensional and 3-dimensional data, and simplify 2-variable curve fitting |
|
Courtesy - http://www.xlxtrfun.com/XlXtrFun/XlXtrFun.htm
Excel Spline Curve, finding dy/dx, ddy/dx^2 with instructions
|
|
Use Excel's Add-In Manager to install XlXtrFun.xll.
1. To install an Excel 2007 add-in, click on the Office Button, the big round decoration in the top left of the Excel window.
2. This opens the Office Menu. Click the Excel Options button at the bottom of this menu.
3.The Excel Options dialog opens up. Click the Add-Ins item in the list along the left edge of the dialog to see the Add-Ins panel.
4.Make sure the Manage dropdown at the bottom shows Excel Add-Ins, then click the "Go" button. This brings up the Add-Ins dialog.
5. Click Browse, and use the Browse dialog to locate the add-in file which is in this case- "XlXtrFun.xll".
6.Click "OK"
1. To install an Excel 2007 add-in, click on the Office Button, the big round decoration in the top left of the Excel window.
2. This opens the Office Menu. Click the Excel Options button at the bottom of this menu.
3.The Excel Options dialog opens up. Click the Add-Ins item in the list along the left edge of the dialog to see the Add-Ins panel.
4.Make sure the Manage dropdown at the bottom shows Excel Add-Ins, then click the "Go" button. This brings up the Add-Ins dialog.
5. Click Browse, and use the Browse dialog to locate the add-in file which is in this case- "XlXtrFun.xll".
6.Click "OK"
spline-slope_curve_example__2_.xlsx | |
File Size: | 27 kb |
File Type: | xlsx |
MS Excel Examples-
Drop Down , CountIf, Date, Time, Sort, Vlookup
Drop Down , CountIf, Date, Time, Sort, Vlookup
countif_vlookup_and_others_-nov_13-2018_v1.xlsx | |
File Size: | 265 kb |
File Type: | xlsx |
Numerical Analysis
Bisection and Newton Raphson and Secant Method Example Excel File
bisection-newton_and_secant_method_example-11-6-2018.xlsx | |
File Size: | 75 kb |
File Type: | xlsx |
bisection_method-bracket-methods.xlsx | |
File Size: | 41 kb |
File Type: | xlsx |
bisect_newton.xlsx | |
File Size: | 19 kb |
File Type: | xlsx |
Materials for Construction- Soil, Sand etc.
Sieve analysis_Gradation Curve and Fineness Modulus of Fine aggregate
|
|
Sieve Analysis of Soil
|
|
grainsizegraph_en.xlsx | |
File Size: | 18 kb |
File Type: | xlsx |
sieveplot.xlsx | |
File Size: | 16 kb |
File Type: | xlsx |
soil-_sieve_analysis-gradation_graph_paper.pdf | |
File Size: | 10 kb |
File Type: |
Liquid and Plastic Limit _AL_Data_Template
|
|
Maximum Density of Soil
maximum_density_example-_proctor_test1.xlsx | |
File Size: | 22 kb |
File Type: | xlsx |
Courtesy - IMI Research Group