Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Commenting a block of code in VBA
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Downloads
- Latex Maths Text in Excel
- Retrieving unique values from a range or array ...
Recent Comments
Jose Luna on More updates to ArcSpline and… Lucas Beattie on Drawing in Excel – … marcengineer on More on combined shear and ben… dougaj4 on More on combined shear and ben… Marc on More on combined shear and ben… Sukrit Ghorai on Biaxial bending update dougaj4 on Biaxial bending update Sukrit on Biaxial bending update A not so easy proble… on Pint, MPmath and implied units… dougaj4 on ULS design of circular reinfor… Dakota on ULS design of circular reinfor… Marcus747 on Commenting a block of code in… dougaj4 on Biaxial bending update Sukrit on Biaxial bending update DT67 on Using ConbeamU
Tag Archives: Open source
Units for Excel
One of the reasons that programs like MathCad tend to be preferred to Excel for engineering and scientific applications is that they have much better facilities for dealing with different units of measurement. This isn’t difficult, since the only built-in function provided … Continue reading
Posted in Excel, Newton, UDFs, VBA
Tagged Conversion, Excel, Open source, UDF, Units, VBA
8 Comments
Some VBA maths resources
In the past week I have discovered a couple of sites with open source maths related VBA code that I was previously unaware of, and which deserve to be better known: AlgLib: “ALGLIB is a cross-platform numerical analysis and data processing library. … Continue reading
Daniel’s XL Toolbox
I downloaded this yesterday: Daniel’s XL Toolbox “Daniel’s XL Toolbox is a free, open source add-in for Excel® that helps you to analyze and present data.” See the link for a full description. I’ve only had a brief look, but … Continue reading