Calcudoku puzzle forum
https://www.calcudoku.org/forum/

Calcudoku.org 20 Million Solved Puzzles Analysis
https://www.calcudoku.org/forum/viewtopic.php?f=2&t=1177
Page 1 of 10

Author:  skeeter84  [ Sun Nov 03, 2019 5:30 am ]
Post subject:  Calcudoku.org 20 Million Solved Puzzles Analysis

Hi, guys. Everybody on calcudoku.org is eagerly anticipating the moment puzzle number 20 million is solved. Given my investigative nature and affinity for math and science, I’ve done an experiment to estimate when that spectacular moment will occur. I've printscreened and recorded the total number of solved puzzles at 18:00 USA/Canada EST/EDT for 10 days. Day 1 is Monday, October 21, 2019 and will be x = 0 on a Cartesian coordinate plot. I found the number of puzzles solved on each of the ten days, took an average of those ten days and used a trendline. Last but not least, I compared the trendline equation with my 10 day average to estimate when number 20 million will arrive.

First, here's a summary of my data.

Image

The left to go readings were calculated by subtracting a given day's 18:00 reading away from 20 million. I found the puzzles solved on a given day by subtracting that day's 18:00 reading from the next day's 18:00 reading.

In other words,

Day 1 puzzles solved = Day 2 18:00 reading - Day 1 18:00 reading or

19,135,658 - 19,127,738 = 7,920 puzzles solved on Day 1.

I took an 18:00 reading on Day 11 because I needed it compute the puzzles solved on Day 10.

To estimate when the puzzles left to go will equal 0, I decided to compute the slope of a trendline after each day of my analysis. I couldn't do that on Day 1 since 2 points are needed. You may remember from algebra that slope is equal to the change in y over the change in x (colloquially referred to as "rise over run"). Furthermore, a linear equation is written in slope-intercept form as

y = mx + b where m is the slope and b is the y-intercept of the line (where x is 0).

In my experiment, the y-intercept is 872,262.

I used the following to obtain the slope for Days 1 and 2:

(0, 872,262) and (1, 864,342)
x1 y1 x2 y2

or m = (864,342 - 872,262)/(1-0) = -7920

Therefore, the equation of the line for Days 1 and 2 is y = -7,920x + 872,262.

To find the trendline for Day 3, I plotted the x values for the first 3 days against the left to go values for those days in Microsoft Excel. I displayed the equation and R^2 value on the chart, and I set the intercept to 872,262. In doing so, the equation I got was:

y = -8,404.8x +872,262 with an R^2 value of 0.998.

I repeated this process each day for all 10 days, obtaining a final trendline of

y = -8,178x + 872,262 and an R^2 value of 0.9982.

I looked at the slopes of my trendlines, obtaining an average slope of -8,108.3. Additionally, the average number of puzzles solved per day worked out to 8,314, which is fairly close to 8,108. Those trendlines were set equal to 0 and solved for x, the number of days it would take for the left to go number to equal 0. I rounded my x numbers to 3 decimal places, and I figured out the hours, minutes, and seconds as well. From my calculations, I estimate that puzzle number 20 million will be solved somewhere in the time ranges shown below.

US/Canada Eastern Time: between Sunday, February 2, 2020 at 12:45 to Saturday, February 8, 2020 at 22:41

Central European Time (CET)/Patrick's Time: between Sunday, February 2, 2020 at 17:45 to Sunday, February 9, 2020 at 03:41

Last but not least, I wanted to include screenshots of the 18:00 readings I took for each day. I'll fix this post up later if my pictures didn't show up.

Image

Image

Image

Image

skeeter84

P.S. Now that I think about it, I'll go back on imgur to resize my stuff.

Author:  beaker  [ Sun Nov 03, 2019 5:54 am ]
Post subject:  Re: Calcudoku.org 20 Million Solved Puzzles Analysis

Funny you should do all this math as I have done a little speculative math myself and figure there should be at least 3 users attaining 200,000 points in the same time period [biggrin]

Author:  pnm  [ Sun Nov 03, 2019 2:08 pm ]
Post subject:  Re: Calcudoku.org 20 Million Solved Puzzles Analysis

Wow [scared]

I did a "back of the envelope" calculation myself, and arrived at February 1st
(took less time than your calculation [lol] )

This gives me an idea: guess when the 20th million puzzle will be solved,
down to the second !

(minutes and seconds needed to break ties)

The winner wins a prize (to be determined [smile] )

Deadline for entries: ~ one week from now (so Sunday Nov. 10th, 13.00 CET)

Author:  jpoos  [ Mon Nov 04, 2019 12:57 pm ]
Post subject:  Re: Calcudoku.org 20 Million Solved Puzzles Analysis

pnm wrote:
This gives me an idea: guess when the 20th million puzzle will be solved,
down to the second !

(minutes and seconds needed to break ties)

The winner wins a prize (to be determined [smile] )

Deadline for entries: ~ one week from now (so Sunday Nov. 10th, 13.00 CET)


I'll guess 02-02-2020 at 02:02 am and 20 seconds [thumbup]

Author:  fzpowerman47  [ Mon Nov 04, 2019 8:47 pm ]
Post subject:  Re: Calcudoku.org 20 Million Solved Puzzles Analysis

so, maybe between the 3rd and the 5th February ??

Author:  eclipsegirl  [ Tue Nov 05, 2019 11:20 pm ]
Post subject:  Re: Calcudoku.org 20 Million Solved Puzzles Analysis

Feb 5, 2020 05:05:05

Author:  rafaelhoukes  [ Fri Nov 08, 2019 12:13 pm ]
Post subject:  Re: Calcudoku.org 20 Million Solved Puzzles Analysis

My guess is Jan 31-01-2020 at 13:31:13.

Author:  beaker  [ Fri Nov 08, 2019 10:03 pm ]
Post subject:  Re: Calcudoku.org 20 Million Solved Puzzles Analysis

I will say: Feb 4 at 4:04 and 404 milliseconds CET

Author:  sjs34  [ Fri Nov 08, 2019 11:40 pm ]
Post subject:  Re: Calcudoku.org 20 Million Solved Puzzles Analysis

02/01/20 at 01:02.10

Author:  beaker  [ Sat Nov 09, 2019 2:14 am ]
Post subject:  Re: Calcudoku.org 20 Million Solved Puzzles Analysis

Should one include the time zone or is it understood that if no time zone is mentioned then the default time zone is CET?

Page 1 of 10 All times are UTC + 1 hour [ DST ]
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/