Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- Cubic Splines
- Filling Blanks with Go To-Special (and local help rant)
- Writing Arrays to the worksheet - VBA function
- XLDennis, the MSDN Library, and VBA rant
- Daily Download 5: Frame Analysis
- Downloads
- The angle between two vectors, Python version
Recent Comments
Author Archives: dougaj4
Two exceptional musicians
On Saturday night we were treated to fine performances from two exceptional young musicians. The first was Stefan Jackiw, performing with The Australian Chamber Orchestra at Angel Place. Here he is playing a Beethoven piece in 2009: Then after the … Continue reading
Baby Names and Pivot Tables
Baby Boom: An Excel Tutorial on Analyzing Large Data Sets is a comprehensive (and free) tutorial looking at analysing public databases of baby names, using Excel: There are professional data analysts out there who tackle “big data” with complex software, … Continue reading
Posted in Charts, Excel
Tagged Analysing data, Excel, large data sets, Pivot charts, pivot tables, tutorial
Leave a comment
Managing Data Using Excel …
… is a new book by Mark Gardener, published by Pelagic Publishing.* It is subtitled “Organising, summarising and visualising scientific data”. The publishers say of the book: Microsoft Excel is a powerful tool that can transform the way you use … Continue reading
Posted in Charts, Excel, Newton
Tagged Charts, pivot tables, Scientific data analysis
Leave a comment
Avoid si Aibohphobia is di ova …
… which loosely translated means, if you have inherited the rare but debilitating condition known as aibohphobia, or fear of palindromes, then read no further, and don’t even think about clicking on the Vimeo video below. Since today (for those of … Continue reading
xlSciPy 1.01
The xlSciPy spreadsheet, introduced here, has been updated with many new functions. The new version, including full open source code (VBA and Python) can be downloaded from: xlSciPy.zip The spreadsheet requires Python to be installed, including NumPy and SciPy. It … Continue reading
Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA
Tagged Excel. VBA, ExcelPython, Fast Fourier Transform, Python, SciPy distance functions, sparse solvers, UDF
Leave a comment