… is the title of a paper by Boris Peon. Here is the abstract:
Hinchliffe has asserted that whenever the title of a paper is a question with a yes/no answer, the answer is always no. This paper demonstrates that Hinchliffe’s assertion is false, but only if it is true.
From New Scientist, 16 August 2014
Download the full paper
… and crowd-funded production, directed by my daughter:
The story of the project
At the start of 2014, sparked by the funding opportunity Raw Nerve (A Metroscreen and Screen Australia initiative) Kerinne Jenkins (director), Harry Windsor (writer) and Nic Douglas (producer) conceived of the short film “ Long Lost”.
After applying with a video pitch, our project was chosen as one of three successful candidates. We were then invited to participate in a three-month development process with the other Breaks filmmakers and mentors Lachlan Philpott, Karel Segers and Jonathan Wald.
Now that the script has been developed, we’ve been given a start in realizing this project, with an initial amount of funding and it’s up to us to raise the rest to bring this story to life.
Visit the link below, have a look at the video with more on the background to the project, and contribute to allow it to proceed:
The latest version (4.2) of the numerical integration spreadsheet by Graeme Dennes is now available for download from Tanh_Sinh Quadrature.
For more details of the background see: Faster Integration with the Tanh-Sinh Method and subsequent posts on this subject.
In addition to the code and examples on the use of Tanh-Sinh quadrature and a number of other techniques, the download file contains examples and thoroughly documented code for a range of other spreadsheet and VBA functions, including:
The revisions included in Ver. 4.2 are listed below. In the next post in this series I will look in more detail at how these functions can be incorporated in other spreadsheets.
Version 4.2 Release Notes
- Following a private suggestion, all quadrature programs now provide the number of function evaluations as a more useful performance metric.
- The Romberg program runs in 30 percent of the time taken by the previous (V4.1) release, and accuracy averages only one digit less than Tanh-Sinh. The Romberg algorithm implemented herein by the author may be the fastest and most accurate to date.
- The function plotter is located on a separate worksheet for convenience.
- Finite interval test functions total 400, which may be the largest set of diverse test integrals available (with answers) at no cost.
Graeme Dennes
The polynomial spreadsheet (details here) provides functions to solve polynomial equations of any order; using an “exact” method for up to quartic, and an iterative procedure for higher orders. The input for the functions requires the equation coefficients to be in a continuous column or row range. This is convenient for many cases, but there are times when it is necessary to enter each coefficient separately.
I have now added a new function to the spreadsheet, which has the coefficients entered separately, and calls the appropriate solver function, depending on the number of coefficients. The new function, including full open source code, may be downloaded from Polynomial.zip.The screenshot below shows an example of usage of the new function (included in the download file):
In this example three coefficients of a cubic equation are constant, but the fourth varies. The solution to the equation can be set up easily as follows:
The spreadsheet to calculate ultimate moment capacity of a reinforced or prestressed concrete section under combined axial load and biaxial bending, last presented here, has been updated to use the QuadBrent solver, rather than the Excel Goal Seek function, for better performance. The new solver function reduces the time to calculate the neutral axis angle from about 1 second down to 2 to 5 milliseconds, which is quite a respectable improvement in performance.
The new file can be downloaded from ULS Design Functions, including full open-source code.
The screenshot below shows the new FindNAAng function, which returns the calculated Neutral Axis angle for the specified combination of axial load and biaxial bending:
As in the previous version, the Neutral Axis angle may be entered manually on the input sheet, or updated automatically with the Adjust NA Angle button:
An output summary is given on the input sheet (as shown above) or detailed output data is provided on the Out sheet. Alternatively interaction diagrams may be plotted for a range of neutral axis angles, as shown below:
See the previous post, or download, for more details.
Newton Excel Bach, not (just) an Excel Blog 