Monthly Archives: June 2017

Build Bridges, Not Walls

Posted on 28/06/2017 by dougaj4

I don’t often do politics here, but with an opening line like “build bridges, not walls” how can I deny Jeremy Corbyn a spot, especially when he is talking at The Glastonbury Festival:

Posted in Bach | Tagged , | 1 Comment

Plotting Freeze-Thaw Data …

Posted on 21/06/2017 by dougaj4

… or other irregular cyclic data. Another Eng-Tips question asked how to approximate ice area over a freeze-thaw cycle using a function based on a sine or cosine curve.  The screen-shot below shows three alternatives: Using built in Excel functions requires … Continue reading →

Posted in Arrays, Curve fitting, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , | 1 Comment

Counting non-pecked chicks

Posted on 16/06/2017 by dougaj4

Download file:  Binary Chicks.zip. This post is based on a recent discussion at Cosmic Horizons looking at numerical methods to solve the following problem: The answer to the question is straightforward: With a little thought, you should be able to realise … Continue reading →

Posted in Excel, Link to Python, Maths, Newton, UDFs, VBA, xlwings | Tagged , , , , , , , | Leave a comment

Taming Symbols in Excel

Posted on 08/06/2017 by dougaj4

You can enter an ASCII character in Excel (if you know the ASCII code) by holding  down the Alt key and entering the decimal code value on the numeric key pad.  This has two problems: It doesn’t work in Excel … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , , , | 1 Comment

Green grow the laurels

Posted on 07/06/2017 by dougaj4

from Sandy Denny: Not to be confused with:  

Posted in Bach | Tagged , , , | Leave a comment