If only the other forum. Counted ....
LOL! It has crossed my mind a few times...
but then a bunch of us would really be flaunting how great we are at wasting time..
🎪🎯🎻🥁💥🦆🦓🐘🐖🐑🍄🥨🤪
If only the other forum. Counted ....
If only the other forum. Counted ....
If only the other forum. Counted ....
I added it to my ignore list. It's really not necessary. But I digress.Personally, I don't even think that other forum should exist.
Well everyone ELSE is wrong and in need of eternally being correctedLOL! It has crossed my mind a few times...
but then a bunch of us would really be flaunting how great we are at wasting time..
🎪🎯🎻🥁💥🦆🦓🐘🐖🐑🍄🥨🤪
Well... your "likes" count... so there's that.If only the other forum. Counted ....
That's a value per post you can't buy.
Well everyone ELSE is wrong and in need of eternally being corrected![]()
Grady said:Perhaps they need a good talking to, if you don't mind my saying so. Perhaps a bit more. My girls, sir, they didn't care for the Overlook at first. One of them actually stole a pack of matches, and tried to burn it down. But I "corrected" them sir. And when my wife tried to prevent me from doing my duty, I "corrected" her.
Hmmm... selling "likes" could be a new revenue source!That's a value per post you can't buy.
I do take paypal...........Hmmm... selling "likes" could be a new revenue source!
Same, was one of the main reasons I stopped posting on these forums as much as I use to. Love talking tech but good grief when political stuff gets posted on here it just goes right down the tubes. Way to many rude comments and when they don't stop publicly they take it to private.. then I have to block 20 or 30 accounts from the same person who is still on this forum.. blows my mind how they continue to allow this person to keep posting but I don't own the forum so best to do is stop posting and just read the tech sections. Definitely glad they don't reward those in the other place.I added it to my ignore list. It's really not necessary. But I digress.
I'd looked into doing this once before, but the numbers were all over the place. This is because Likes are counted in some forums where Posts aren't. So any ratio isn't a real reflection of the other stated numbers for the user. For example, someone could have 5 counted posts and 1000 likes, but that won't be their real Likes/Posts ratio, because they have 3000 posts in an uncounted forum (such as PRSI or Political News).Could you please add a column comparing 6-mo posts to 6-mo likes? Ie. just divide one up the other, or something similar you feel cool.
Then there won't be popcorn till the Heat Death of the Universe.... It's important (at least to me) to know that Jaffa Cake will pass mad jew in April 8265. Another event worthy of popcorn spectatorship!
I'll look into this later today, and post what I find.How long until Apple fanboy is expected to pass my post count? When the time comes, I'd like to get a big tub of popcorn and watch it happen.
Apple Likes+Hmmm... selling "likes" could be a new revenue source!
I’m waiting with baited breath and a tub of popcorn for the good doctor. Although I though @Doctor Q was more of a pie man!I'll look into this later today, and post what I find.
5 0 obj
<< /Length 1809 >>
stream
Perhaps you'll enjoy this as much as I did:Re two previous posts, strictly my opinion: you guys have gone off edge of coffee table. (not an insult)
It's fascinating even if your day job employers might call for butterfly nets and straitjackets.
Absolutely fascinating. Outstanding detail!Supplemental Projections
In post #22 @Doctor Q asked:
How long until Apple fanboy is expected to pass my post count? When the time comes, I'd like to get a big tub of popcorn and watch it happen.
An approximate answer to this question is provided below. Following that is a detailed explanation of how the answer was obtained.
Executive Summary: An Approximate Answer
First, @Apple fanboy will have to surpass @Go Cubs Go. This should happen about 13 weeks from now.
Second, @Apple fanboy is expected to surpass @Doctor Q about 30 weeks from now.
Detailed Explanation, with Photos and Annotations
Part 1: Surpassing Go Cubs Go
Rather than use numerical methods to answer the question, I decided to go Old School and do this using mechanical graphical methods.
That is, given a graph of the posts for the 3 users of interest, with an X axis representing time, use a straightedge and other mechanical drawing equipment to approximate the X-position where @Apple fanboy's extrapolated line crosses @Go Cubs Go's line, and then @Doctor Q's.
I figured as long as I was wasting time, I should be extravagant about it: Go big or go home.
Making the graph was straightforward. I simply tweaked one of the Detail graphs shown earlier in the thread, so it contained only the 3 users of interest, and a sufficient range of time to allow decent linear extrapolation. Here is that graph as a GIF:
View attachment 887059
This graph originated as a PDF, which has much better accuracy. I've attached it to this post, so interested readers can download it and repeat the experiment.
In the graph, notice that Go Cubs Go is nearly a horizontal line. This means that a very simple linear extrapolation will suffice to estimate this first crossover.
To do this extrapolation, I used dividers set to the vertical distance between Apple Fanboy (AFB) and Go Cubs Go (GCG), for the last date on the graph: 2020-01-05.
I then "flipped" the dividers so one point was below AFB's final graphed datum. I put a pencil mark here.
Next, I placed a drafting triangle so one edge was on the mark, and the perpendicular edge was parallel to the last vertical date line. I then struck a horizontal pencil line across until it intersected AFB's graphed line.
The number of weeks between then and now is how long it took AFB to increase his post-count by the nmber of posts now remaining between him and GCG.
Here's a photo of the printed graph, showing the dividers flipped down, and the upper edge of the triangle at that distance, perpendicular to the last vertical gridline in the graph.
View attachment 887060
Here's a detail showing the horizontal line and one of the divider points.
View attachment 887061
The vertical distance downward of that intersection is identical to the vertical distance between AFB's current data point and GCG's current data point. That is, it represents the number of posts that AFB needs in order to match GCG's current post count. Call that number of posts P.Going downwards from AFB's final graphed point then represents the same number of posts, P. We can then look backwards (leftwards) to see how long ago AFB had that post count. If we measure how many weeks ago that was (W), then it should take AFB the same number of weeks (W) to increase his post count by P, assuming a linear relationship.
The detail photo above shows the crossover is around 13 weeks ago. So it should take AFB about 13 weeks to surpass GCG.
Part 2: Surpassing Doctor Q
Extrapolating for Doctor Q won't be as simple in the mechanics, but it might be easier to understand because it's easier to visualize.
Go Cubs Go was mechanically simple because her post rate is nearly zero, so her post count barely changes. That means Apple Fanboy is effectively approaching a stationary target.
Doctor Q is a moving target, not a stationary one. This means that by the time AFB has reached where DrQ's post count is now, DrQ will have increased his own post count, and thus be that much farther away.
Oh sure, I could probably write a program to iterate both counts using their respective post rates, or perhaps develop a simultaneous equation, but that's too conventional. Instead, I used the same graphical methods as above, making an actual linear extrapolation.
First I had to place an additional piece of paper so I could draw the extrapolated lines. I used the back of a previously printed graph, so in the following photos, you'll see some faint lines showing through that should be ignored.
Here's a photo showing all the constructed lines, along with some letter labels for significant points:
View attachment 887062
The first extrapolated line extends AFB's line graph into the future. It crosses GCG's extrapolated line at the point I've labeled C.
The next extrapolated line extends DrQ's line graph into the future. I bungled the first line, so the upper line is the one to use. It crosses AFB's extrapolated line at the point I've labeled B.
I've also expanded the dividers so they match the distance between A and B. This distance represents how long from now it will take AFB to surpass DrQ's post count, taking both their current post rates into account.
The next photo shows the dividers moved onto the graph so they extend over a countable number of weeks. Then it's simply a matter of counting the vertical gridlines to reach the estimate of when AFB will surpass DrQ.
That count is about 30. This places it after the next Statistics Day, which will occur in about 26 weeks.
View attachment 887063
I also checked whether the horizontal distance between A and C matched up with the 13-week approximation made above. It did.
The extra marks and lines on the drawing were some additional points of reference.
The large + mark with the half-hidden "37333" is an extrapolation of the top Y-axis mark from the printed graph.
The "25 wks" line was an earlier estimate for a different projection: how long it will take for AFB to reach DrQ's current post count of 37333.
Going Bigger
For thecuriousintrepid, the numerical data to populate a spreadsheet and perform a linear interpolation can be extracted from the PDF file. It can be opened in a text editor, and the uncompressed PDF examined.
The polylines for each line graph are in Object 5, which starts with this:
Code:5 0 obj << /Length 1809 >> stream
Each polyline begins with 2 coordinates (X Y) and a PDF 'move' command (m). That's followed by a series of XY coordinates and 'lineto' commands (l). The end is an 'S' (stroke) command that draws the polyline assembled at that point.
The numbers themselves are PDF page coordinates, measured in points (72nds of an inch). The fractional digit is rounded from a double, starting from the raw data (integer counts).
Strip off the 'm' and 'l' commands, and the numbers should go into a spreadsheet just fine. Graph them and it should be clear which one belongs to whom.
Better put a note in your diary for 30 weeks time: buy popcorn!Bravo for doing this computation mechanically! I can tell you had fun.
I have a compass in my desk drawer, and I wish I had more occasion to use it for something, as you did here. I remember trying to see if I could divide an angle in thirds with a compass and straightedge, even though it's known to be impossible. The last time I used my compass was to draw a design of concentric circles around a point for a decoration I was making.
It's simplest to assume that a user will continue posting at their latest post rate, which isn't always the case. You were fortunate that Apple Fanboy and I have almost linear post growth. This mechanical computation would have been a lot harder (or simply a lot less accurate) if either of us had an accelerating or decelerating post rate.
On the negative side, 30 weeks seems a bit too soon. Using the algebraic solution, you'd compute
numberDays = ( user2posts - user1posts ) / ( user1rate - user2rate )
WIth the data from Table 1 you'd get
( 37330 - 34122 ) / ( 17.86 - 8.29 ) = 335.21 days
which is 335.21 / 7 = 47.89 weeks. Of course the data is 3 days old, so it's obsolete anyway!
Fascinating thread, and some terrific posts @chown33 & @DoctorQ; must say that I love reading this stuff.
Perhaps you'll enjoy this as much as I did: