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.
Yesterday was 23/11, also known in some parts as 11/23, and you may recognise this as being a date made of the first four Fibonacci numbers. (Such numerical date-based Fibonacci coincidences haven’t been as exciting since 5/8/13, but at least this is one we can celebrate annually.) This meant that mathematicians everywhere got excited about #FibonacciDay, and spent the day talking about the amazing sequence. Here’s a round-up of some of the best bits, so you can celebrate Fibonacci day in style.
Every year, the Eurovision Song Contest brings with it fresh accusations that the results are affected more by politics than music. But how much of the outcome is in fact determined by mathematics?