It’s a tool; a ratio, providing us simple rules for doing circular estimates. Admired regularly – and we all remember that today’s pi! Hooray! Let’s eat pie.
You may have noticed that the first paragraph of this article was immensely poorly written, and didn’t sound like good writing at all. And you’d be right – except writing it wasn’t easy as you’d think. I’ve written it under a constraint – that is, I’ve picked an arbitrary rule to follow, and have had to choose my words carefully in order to do so.
Users of Microsoft’s flagship 2D-array-based data-organisation tool Excel will be aware of some if its more recondite functions. From the occasionally useful
RIGHT: returns the substring of a given length from the right-hand end of a cell’s contents
to the wilfully obscure
TBILLPRICE: gives “the price per $100 face value for a Treasury bill” when supplied with its settlement date, maturity date and discount rate
to the downright cryptic
N: obviously, converts its argument to a numeric format if it can
along with approximately 340 others, Excel’s abilities are near limitless.
But one function seems singular in the sheer decadence of its inclusion.
This year, π day will be celebrated, as always, on 14th March. Unlike most years, π day will be more accurate than usual – owing to the fact that the year, 2015, will give the date 3/14/15 (provided you’re using a US calendar date format) – and for this reason, some people are calling it Ultimate π day. But how truly Ultimate is it?
People with an interest in date coincidences are probably already getting themselves slightly over-excited about the fact that this month will include what can only be described as Ultimate π Day. That is, on 14th March 2015, written under certain circumstances by some people as 3/14/15, we’ll be celebrating the closest that the date can conceivably get to the exact value of π (in that format).
Of course, sensible people would take this as an excuse to have a party, so here’s my top $\tau$ recommendations for having a π party on π day.
Sam’s dad is in a mathematical conundrum – so she’s asked Katie, one of our editors, if maths can save the day.
Dear The Aperiodical,
My dad is going away on a golfing holiday with seven of his friends and, since I know a little bit about mathematics, he’s asked me to help him work out the best way to arrange the teams for the week. I’ve tried to work out a solution, but can’t seem to find one that fits.
They’ll be playing 5 games during the week, on 5 different days, and they’d like to split the group of 8 people into two teams of four each day. The problem is, they’d each like to play with each of their friends roughly the same amount – so each golfer should be on the same team as each other golfer at least twice, but no more than three times.
Can you help me figure it out?
Sam Coates, Manchester
In an idle moment of wondering, I asked a simple question on Twitter:
The response was overwhelming. Here’s a guide to the non-existent number crunchers you should know about, and some you probably already do.