Another excellent UK musician I had never heard of, and judging by the number of YouTube hits, neither have you:
Someone comments that John Martyn comes to mind, so maybe this duo is not so surprising:
Recent Comments
Max, Min, and Aggregate
Recently I needed to find the maximum and minimum of a range of values including some #N/A values. Searching found a variety of solutions, of which the simplest (that works in all versions) seems to be:
- =MAX(IF(ISNUMBER(datarange),datarange))
- =MIN(IF(ISNUMBER(datarange),datarange))
The function must be entered as an array function, i.e. type the function, then press Ctrl-Shift-Enter, rather than just Enter. The screenshot below shows a simple example:
The search also found the Aggregate function, which is new in Excel 2010, and provides a number of options for ignoring sub-totals as well as errors. The Aggregate function will return a number of different statistical functions, as well as Max and Min. These are documented with a tool=tip as the function is entered, as shown in the screen-shot below:
ConBeamU 4.08
The continuous beam spreadsheet has had another update to fix a problem when point loads were applied to cantilevers, and the first support position was not listed as an output point. The new version (4.08) can be downloaded from:
The spreadsheet results have been checked against Strand7 results for 15 different span arrangements, each with 1 of 6 different support conditions:
The results are summarised in the file Check conbeamU28Nov15.xlsb (included in the download zip file). Typical results are shown below for a 3 span beam with two cantilevers, showing near exact agreement with the Strand7 results.
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA
Tagged ConBeamU, continuous beam analysis, Excel, moving load, Strand7, UDF, VBA
1 Comment
Announcing Excel Summit South 2016!
After 2 years of organising, Charles Williams recently announced:
Excel Summit South
EXTEND YOUR SKILLS
This is a unique opportunity to:
- Learn from six of the world’s leading Excel MVP’s as they discuss the Excel topics most useful to you.
- Hear industry leading speakers from around the world give you the latest views on Financial Modelling best practices, standards and spreadsheet risk.
- Shape the future of Excel: Interact with members of the Microsoft Excel Dev Team as you explore with them the future of Excel.
- Choose the sessions that best suit your needs from 23 masterclass sessions over two days of twin tracks for modellers and analysts.
INTERACT WITH THE EXPERTS AND MEMBERS OF THE EXCEL DEV TEAM
EXCEL SUMMIT SOUTH PLACES ARE LIMITED: REGISTER NOW
EarlyBird 20% discount available for registrations before December 31 2015.
Don’t miss out out on this unique Excel opportunity.
Posted in Excel
Tagged Auckland, Charles Williams, Excel Conference, Excel Summit South, Melbourne, Sydney
1 Comment
Paper bridge
Making a model bridge out of paper is pretty easy.
Making a full size bridge, strong enough to carry a Range Rover, out of just paper takes a bit of doing:
It seems the guy who built the bridge (Steve Messam) has been interested in paper bridges for some time:
Posted in Arch structures, Newton
Tagged Arch bridges, China, Paper bridge, Range Rover
Leave a comment
Newton Excel Bach, not (just) an Excel Blog 