Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using LINEST for non-linear curve fitting
- Using Goal Seek on Multiple Cells
- Contour plots with Excel and Matplotlib
- Cubic Splines
- Brent's Method; Update and Examples
Recent Comments
mindOnion on Drawing a Buckyball in Ex… dougaj4 on Drawing a Buckyball in Ex… mindOnion on Drawing a Buckyball in Ex… mindOnion on Drawing in Excel 7 – Cre… Veronica Davenport on Asymmetric Catenary Function py_UMom spreadsheet… on More on combined shear and ben… Skip on xlwings – dataframes and… dougaj4 on xlwings – dataframes and… More on combined she… on RC Design Functions 9.03; comp… skip on xlwings – dataframes and… skip on mpmath for Excel dougaj4 on mpmath for Excel skip on mpmath for Excel dougaj4 on Composite Beam Spreadsheet Upd… metroxx on Composite Beam Spreadsheet Upd…
Tag Archives: Visual Studio C++ Express
Linking Excel to C – 3; Avoiding bottlenecks
The previous post in this series included a C dll to solve cubic polynomial equations that could be called from VBA. The performance of this routine is compared with a VBA routine using a similar algorithm in the sceenshot below (rows … Continue reading
Posted in Arrays, Excel, Link to dll, UDFs, VBA
Tagged C++, dll, Excel, Visual Studio C++ Express
2 Comments
Linking Excel to C – 2
In the previous post I decribed how to create four simple functions in Visual C++, and how to link them to an Excel spreadsheet or a VBA User Defined Function (UDF). This post will cover: Accessing arrays created in C++ functions … Continue reading
Posted in Excel, Link to dll, UDFs, VBA
Tagged C++, dll, Excel, Visual Studio C++ Express
22 Comments
Linking Excel to C
One of the reasons often given for preferring programs like Matlab to Excel for scientific and engineering uses is the large body of specialist mathematical and scientific applications available to these programs. In this and following posts I will describe how … Continue reading
Posted in Excel, Link to dll, UDFs, VBA
Tagged C++, dll, Excel, Visual Studio C++ Express
28 Comments