Maximum task completeness in Excel: 72.0857%

Today’s XKCD comic is an inspiration. Click on the image to see the full size cartoon and then come back here to wallow in nerdiness.

Of course, I had to see whether the formula would actually work so, I plugged it into Excel and it looks like this:
=A2-(POWER(EXP(1),(20.3444*POWER(B2,3)+3))-POWER(EXP(1), 3))

Hopefully it is obvious that cell A2 contains the current date and cell B2 is the percentage completion expressed as a fraction.

It works, after a fashion, although the date acceleration is nothing like that suggested by the cartoon. More amusingly, though, is the fact that the Excel date function breaks when I exceed 72.0857% completed. This is obviously because nothing can ever be more than 72.0857% complete when Microsoft are involved.

One thought on “Maximum task completeness in Excel: 72.0857%

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s