Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Downloads
- Writing Arrays to the worksheet - VBA function
- Linking Excel to C - 2
- Frame Analysis with Excel - 3, Continuous beam or frame
Recent Comments
Author Archives: dougaj4
Larkin Poe
Larkin Poe is an American roots rock band originally from north Georgia, currently based in Nashville, Tennessee,[1] and fronted by sisters Rebecca Lovell (born January 30, 1991) and Megan Lovell (born May 12, 1989). Featuring strong southern harmonies, heavy electric guitar riffs, and slide guitar, they are … Continue reading
Display Matplotlib animations in Excel
The latest version of pyxll (5.4.0) allows animations generated in Matplotlib to be simply copied to Excel. A spreadsheet with the examples shown below, and the associated Python code can be downloaded from: Animations2.zip The screenshot below shows the simple … Continue reading
Posted in Animation, Drawing, Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged animation, Excel, Mandelbrot animation, Mandelbrot Set, MatPlotlib, Python, PyXLL, UDFs
3 Comments
Free resources for earthquake design in Australia
… and other regions with low to moderate seismicity: The SRIA’s free pdf Guide to Seismic design and detailing of Reinforced Concrete Buildings in Australia is available from the link below. It was published in 2016 and was a precursor … Continue reading
Posted in Concrete, Newton
Tagged AEES, AS 1170.4, AS 3600, free publications, Quake-Advice, Seismic design, SRIA
Leave a comment
Rounding to significant figures
Edited 19th Feb 22, following comment from Larry Schuster Excel does not have a function to round numbers to a specified number of significant numbers, and (rather to my surprise) neither does Python. It is not too hard to write … Continue reading
Posted in Excel, Link to Python, Maths, NumPy and SciPy, PyXLL, UDFs, VBA
Tagged Excel, Python, PyXLL, Round, Significant figures, UDF, VBA
7 Comments
Clearing OneDrive download files in Android
I recently found that downloaded files on OneDrive on my Android pad had almost filled my storage space to capacity, and that the procedure to delete them was not at all obvious. I eventually found a link with detailed instructions … Continue reading