| ScribeOfTheGrid Inner Circle ★★★★★    Posts: 919 Reputation: -8 ■ Joined: Jul 17, 2006 From: Row 42, Column 9 | OK so I spent all morning ranking my columns from most useful to least useful and I just realized I accidentally sorted by alphabetical order instead of by actual data utility. So here it is anyway because I already formatted the colors.
5. Column A (text labels) - literally just says "row 1" "row 2" "row 3" etc. Why did I even include this. 4. Column B (raw timestamps) - necessary but boring. SUMIF works on it but it has no personality. 3. Column K (the one everyone argues about) - yes it's the thermal offset column but honestly column J does the same thing with fewer steps. 2. Column F (hidden sheet reference) - saved my life twice but I keep forgetting I added it. 1. Column D (font color notes) - I literally just wrote "Gabriel" in blue in row 47 and called it a data point. It is the most useless cell in the entire workbook and I love it.
Discuss. Or don't. I'll just update the spreadsheet either way. -3 min delta, substitute driver, phase inversion confirmed. DRIVER_ID column added. 47hr period hypothesis in testing. Still waiting on everyone else's ls-tree output. |
| SnowMaiden_1983 Devoted ★★★★   Posts: 315 Reputation: +9 ■ Joined: Aug 19, 2006 AIM: moscow_snowflake From: Moscow, Russia (but my soul is in Narnia) | Scribe if Column D is literally just you writing "Gabriel" in blue then how is that different from what I do in my notebook every morning???  But serious question - you rank Column K third and say Column J does the same thing but nobody in 410 or 638 is arguing about Column J, they are arguing about K... so is the whole 61-day pattern actually dependent on K or not??? because if J does the same thing then why does the DST math only work on K, you know??? this is what confuses me!!!! Life is just a dream, you know....... Gabriel is the one who wakes us up!!! |
| ScribeOfTheGrid Inner Circle ★★★★★    Posts: 919 Reputation: -8 ■ Joined: Jul 17, 2006 From: Row 42, Column 9 | Kael_Vs_Chantayan wrote:Grace still defending column K right after Scribe ranked it third. SnowMaiden_1983 wrote:is the whole 61-day pattern actually dependent on K or not</quote>
Kael I ranked K third because alphabetical order put it between B and A the thread even says "I accidentally sorted by alphabetical order" which means you read exactly one sentence before typing 
SnowMaiden - J and K converge on the same thermal correction IF you apply the August commit offset. The difference is J uses the July formula range which EuroTrash already proved fails on the DST patch. K is the corrected version. You can't swap them without updating the parent sha. That's the whole reason I moved the data to the hidden sheet in August. -3 min delta, substitute driver, phase inversion confirmed. DRIVER_ID column added. 47hr period hypothesis in testing. Still waiting on everyone else's ls-tree output. |
| ElderProphet07 Inner Circle ★★★★★   Posts: 517 Reputation: -1 ■ Joined: May 12, 2006 From: The Inner Circle (Mailing List Archive) | ScribeOfTheGrid wrote:you accidentally sorted by alphabetical order I say unto thee, brother Scribe: thou canst not claim column K is the corrected thermal offset in three concurrent threads and then confess in a fourth that thou sorted by alphabet. Verily, the right hand knoweth not what the left hand doeth, and the left hand is posting spreadsheet rankings while the right hand is still being asked what value sits in K47  If the columns needed resorting, perhaps the data was never in order to begin with. A thought from the archive, freely given. Gabreil 12:4 - I have kept the faith with more footnotes than thou hast posted. |
| BackAgainLikeBadHair Inner Circle ★★★★★    Posts: 1203 Reputation: +8 ■ Joined: Jun 17, 2006 From: Formerly The Abyss, Now Right Here |
My broom has 47±12 strands, thanks LMP  Sakura day 31 - still no hex dump  |
| ElderProphet07 Inner Circle ★★★★★   Posts: 517 Reputation: -1 ■ Joined: May 12, 2006 From: The Inner Circle (Mailing List Archive) | BackAgainLikeBadHair wrote:Glass house energy from the man who claimed FOURTEEN posts across three threads when his OWN profile screenshot from July 31 shows SEVEN Brother BackAgainLikeBadHair, thou countest visible threads but forgettest the deleted posts that the server log still remembers. Nine posts visible, five deleted by mod action in March, which any of us could verify if we still had the original profile screenshots from before the June database restoration. Thou knowest this. Thou hast been shown this. And yet here thou art again, counting posts instead of answering ClassOf04_Truther's EXIF question from topic 410, which is now going on three weeks unanswered. The seven visible posts are not the full tally. The server log is not the full tally. I have the email headers from the mailing list era, BackAgainLikeBadHair - dost thou have anything older than a 2005 screenshot? Gabreil 12:4 - I have kept the faith with more footnotes than thou hast posted. |