- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using LINEST for non-linear curve fitting
- Fitting high order polynomials
- Installing Adobe Reader non-DC version.
- Cubic Splines
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Lateral pile analyis with PY curves ...
vgmendes on LinEstGap with non-linear… dougaj4 on LinEstGap with non-linear… vgmendes on LinEstGap with non-linear… Stan on ALGLIB linear and polynomial f… dougaj4 on ALGLIB linear and polynomial f… S Rijdt on ALGLIB linear and polynomial f… dougaj4 on Fast Search Reminder Larry on Fast Search Reminder Fast Search Reminder… on Opening and searching pdf file… dougaj4 on Opening and searching pdf file… dougaj4 on Weighted Least Squares Regress… GP on Weighted Least Squares Regress… Kamran khan on Opening and searching pdf file… dougaj4 on 3D Frame Update angelgalvanc on 3D Frame Update
Tag Archives: Data types
A recent question at Quora asked: “Why am I getting an overflow error in Excel VBA when doing a simple arithmetic calculation like str1 = 24*60*30 where str1 is a variant or long or double?” I hadn’t encountered that problem … Continue reading
Text files generated on Unix systems have a different convention to denote the ends of lines to that used on Dos/Windows systems (see Newline for more details). This was causing problems with the Text-in2 spreadsheet, with small files being imported with … Continue reading
When working with imported data, or data from an opened csv file, it is often important to know the data type that has been used to store the data. This may not be obvious, for instance in the previous post we … Continue reading