Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Downloads
- XLDennis, the MSDN Library, and VBA rant
- About Newton Excel Bach
- Cubic Splines
- Filling Blanks with Go To-Special (and local help rant)
- Automating chart scale limits - update
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Writing Arrays to the worksheet - VBA function
Recent Comments
Author Archives: dougaj4
Building dances to an earthquake’s beat
Adam Pascale from the Seismology Research Centre recently shared this animation (click on controls bottom right for High Quality and Full Screen views): … it’s from a building in the Philippines about 130km (hypocentral distance) from a magnitude 6.1 earthquake … Continue reading
Posted in Animation, Computing - general, Newton
Tagged Earthquake animation, Seismology Research Centre
Leave a comment
More from Malinda …
… and some of her mates, from here and there:
New sort functions and sorting to groups
I first posted a user defined function (UDF) to sort spreadsheet or VBA data back in 2009. Finally Microsoft have caught up, and Excel 365 subscribers now have two built in sort functions available: =SORT(array,[sort_index],[sort_order],[by_col]) =SORTBY(array, by_array1, [sort_order1], [by_array2, sort_order2],…) … Continue reading
Posted in Excel, UDFs, VBA
Tagged Excel, GroupSort Function, Sort Function, Sortby Function, UDF, VBA
Leave a comment
Lennox Bridge
Last December I joined Bill Harvey on a visit to Lennox Bridge west of Sydney. Bill has now documented the visit in his Bridge of the Month site, including history, comments on the structural form, and a dynamic 3D model … Continue reading
Posted in Arch structures, Historic Bridges, Newton
Tagged 3D Model, Bill Harvey, Bridge of the Month, Lennox Bridge, stone arch bridge
Leave a comment
The Concrete Institute of Australia – Golden Jubilee
The Concrete Institute of Australia will celebrate 50 years in 2020. The Institute was originally formed when members of the Australia Prestressed Concrete Group proposed a change in 1968 where it was resolved to adopt the name Concrete Institute of … Continue reading