I have updated the Downloads spreadsheet on Skydrive to include all new files added this year, and I have also added two Category columns, which link to the Download by Category page, giving more details and links for each file. The list can be sorted on-line if you select “edit” mode, or download and open in Excel.
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Deflections and Moments in Rectangular Plates
- Latex Maths Text in Excel
- Downloads by category
- Retrieving unique values from a range or array ...
- Fitting high order polynomials
- Using conditional formatting with array formulas
- P-Y Curve function