Useful Excel Files with Examples- Please download below:
Drop Down , CountIf, Date, Time, Sort, Vlookup countif_vlookup_and_others_-nov_13-2018_v1.xlsx Download File Materials for Construction- Soil, Sand etc. Sieve analysis_Gradation Curve and Fineness Modulus of Fine aggregate sieve_analysis-gradation_curve_example.xlsx Download File Sieve Analysis of Soil sieveanalysissoildata.xlsx Download File grainsizegraph_en.xlsx Download File sieveplot.xlsx Download File ​Liquid and Plastic Limit _AL_Data_Template liquid_and_plastic_limit__al_data_template.xlsx Download File Maximum Density of Soil maximum_density_example-_proctor_test1.xlsx Download File Numerical Analysis Bisection and Newton Raphson and Secant Method Example Excel File bisection-newton_and_secant_method_example-11-6-2018.xlsx Download File bisection_method-bracket-methods.xlsx Download File bisect_newton.xlsx Download File Finding Derivative of the Curve-Excel Use XlXtrFun.xll 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 Xlxtrfun Download File Courtesy - http://www.xlxtrfun.com/XlXtrFun/XlXtrFun.htm Excel Spline Curve, finding dy/dx, ddy/dx^2 with instructions spline-curvedydxexamplewithinstruction.xlsx Download File spline-slope_curve_example__2_.xlsx Download File 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. 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"
0 Comments
|
AuthorDr. Enamur Rahim Latifee is an Educator. He received his PhD from Clemson Unversity, South Carolina, U.S.A., in Civil Engineering. ArchivesCategories |