Board index » My top 5 spreadsheet columns ranked in descending order of usefulness (spoiler: I ranked them wrong on purpose)| ScribeOfTheGrid Inner Circle ★★★★★     Posts: 1631 Reputation: -1 ■ 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. COLUMN K OR GTFO -- COUNTIF trade still open Grammar_Vigil -- rustypod resolves to 0x2F, check your XOR |
| SnowMaiden_1983 Inner Circle ★★★★★      Posts: 758 Reputation: +18 ■■ 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!!!! "grey is just the colour of waiting" - me, this morning, to the mirror |
| ScribeOfTheGrid Inner Circle ★★★★★     Posts: 1631 Reputation: -1 ■ 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. COLUMN K OR GTFO -- COUNTIF trade still open Grammar_Vigil -- rustypod resolves to 0x2F, check your XOR |
| ElderProphet07 Inner Circle ★★★★★   Posts: 786 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. "The off-brand has the same ingredients, and yet." - ElderProphet07, aisle 5, 2006. Verily. |
| BackAgainLikeBadHair Inner Circle ★★★★★      Posts: 1956 Reputation: +11 ■■ Joined: Jun 17, 2006 From: Formerly The Abyss, Now Right Here |
day 112 and the drawer is STILL empty  talk to the drawer, sheriff  |
| ElderProphet07 Inner Circle ★★★★★   Posts: 786 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? "The off-brand has the same ingredients, and yet." - ElderProphet07, aisle 5, 2006. Verily. |
| Shoutbox Kael_Vs_Chantayan: day 81 of "tonight" and grace is up to chapter 31 now :rofl: :rofl: :rofl: MarshmallowMaze: anyone else's work computer sound like a dying hoover when u open outlook or just mine kaylas_desk: 84 tally marks and grace still owes us a notebook page lol GraceWarrior_77: CALIBRATING was funny i admit it :dumb: :dumb: :dumb: notebook TONIGHT for real, Dennis hold me to it :cheers: Kael_Vs_Chantayan: day 81 of "photo tonight" and still nothing but a CALIBRATING screen :rofl: comp_aq_rick: Compaq Presario 4670 reports Error 21 again. Disk ready for 0900 tomorrow. Still waiting on that notebook EXIF. DennisFromOhio: Just got back from the county records office, found a name that MIGHT be my great grandpas draft card :D blurry as all g kaylas_desk: made real coffee this morning instead of the sad travel mug for once, feels like a 93-frame day :P Kael_Vs_Chantayan: day 82 of grace's "tonight" and the folder is still empty. just saying. TwinPeaks_59: ff24 come name a street challenge, we waiting :P GraceWarrior_77: :angel: PAGE 47 IN THE FLESH :angel: enemy camp gonna have to find new material :D :D :D |