# 1017: Backward in Time

(Difference between revisions)

 Backward in Time Title text: People tell me I have too much time on my hands, but really the problem is that there's too much time, PERIOD.

## Explanation

Here's the spreadsheet which Randall used to calculate the times and dates for the comic. It also has a lot of other percentages and dates, so take a look if you are interested.

Cueball/Randall creates this formula which helps him wait for long stretches of time which goes increasingly faster into the past as more time goes by, which gives him the effect of looking like the time goes by quickly. Which assists in the waiting process.

As far as the actual math is concerned, the formula is an exponential function (i.e. the variable appears in the exponent). The effect that the function grows faster and faster as p grows, is due to T(p) being exponential. More precisely, when you repeatedly add some constant to the exponent, you will repeatedly multiply some (other) constant with the value of the function. Compare how "slow" a value grows by adding even high values (1, 1001, 2001, 3001, 4001, 5001…) and how fast it grows by multiplying even low values (1, 10, 100, 1000, 10000, 100000…)

Finally, the result is subtracted from the current date for aesthetical reasons. The formula could tell you "20 yrs ago", or it could read "February 1992". Randall decided the latter would be better.

## Transcript

When I have a boring task to get through — a three-hour lecture, a giant file download, or a long term point goal in fitocracy — I use this formula to convert the percentage completed (p) into a date:
T=(Current Date) - (e^(20.3444*p^3+3) - e^3) years
When the task is 0% done, it gives today's date, and as I make progress, I move further and further back in time
(inverse given in lighter colors)
Inverse: p = sqrt((ln(T+e^3)-3)/20.3444)
[Line Graph explaining the correlation between completion percentages and temporal deltas.
0% = now (Date of comic is 2012-02-14T00:00-0500, approx. 1329195600 UNIX)
10% = September 2011
20% = 2008
30% = 1997
40% = 1958
50% = 1776
70% = 22,000 years ago
80% = 671,000 years ago
90% = 55 million years ago
100% = 13.8 billion years ago
]
It moves slowly through the first few years, then steadily accelerates. I tuned the formula so the time spent in each part of the past is loosely proportional to how well I know it. This means I hit familiar landmarks with each bit of progress, giving me a satisfying sense of movement.
[The following are panels detailing completion percentages, correlated time periods, and notable events from this time period.]
7.308% December 18, 2011
Around this time:
Kim Jong-Il dies. US leaves Iraq.
31.12% February 1995
Around this time:
Windows 95 debuts. OJ found not guilty.
47.91% 1844
Around this time:
Rubber vulcanized, bicycle invented, wrench patented.
70.33% 24,000 years ago
Around this time:
Caves painted, ceramic art made. Neanderthals extinct.
90.42% 68 million years ago
Around this time:
First flowering plants. Chicxulub impact kills off most dinosaurs.
100% 13.76 billion years ago
Around this time:
Universe begins. First stars ignite.
[Cueball watches a download progress on a laptop in amazement and happiness. Megan stands nearby and looks at Cueball with a bemused posture.]
Cueball: Swoosh! Watching all that time blur past is such a rush!
Megan: So... you've tried to make an extreme sport out of.. waiting.
Cueball: Swoosh!

# Discussion

That spreadsheet is going to need updating in the future. Jimmy C (talk) 20:30, 6 November 2012 (UTC)

If you're running Excel, the formula is =SUM(EXP(20.3444*(B8^3)+3)-EXP(3)) BlueRoll18 (talk) 10:43, 14 June 2013 (UTC)

I find it more aesthetically pleasing to have the time running forwards; starting with the big bang and ending in the present day. Which reminds me strongly of the introduction to the Big Bang Theory series. Popup (talk) 09:27, 28 June 2013 (UTC)

I am not sure, but it looks like Randall acted up the inverse. It has no reference to the current date, and I am not sure, but I think it should be a cube root. 72.70.180.234 19:39, 21 October 2013 (UTC)