Friends of Gabriel Chantayan

I sat there from 9 to 11:30 staring at columns C through G of someone else's quarterly expenses, and every time the phone buzzed I almost jumped for it thinking it was a new scrobble alert. My SUMIF was returning #VALUE! because I had the wrong range selected and I didn't even notice for twenty-two minutes because my brain was still running the 3:14-to-3:41 gap from yesterday through a pivot table in the background. The client's Q3 utilities line is going to have a 47-cent discrepancy now because I subconsciously typed 0.47 as a lookup value into their ledger instead of 0.00. I should probably tell them it's a thermal offset correction and see what happens

Brother Gridkeeper you sit there staring at cell ranges for twenty-two minutes and call it a betrayal but when I ask you about the hidden sheet timestamp on the Aug 6 commit you suddenly can't find a single minute to answer? :smile

47 cents. 47 cents in a utilities line. You type 0.47 into a CLIENT'S LEDGER and your first instinct is to laugh it off as a thermal offset joke to cover your tracks. Meanwhile the whitespace in that commit was FORTY-SEVEN characters before the footer. Three-space-period-three-space-period. MATCHING Gabreil 47:3. But you're in here making fun of your own SUMIF while the real pattern is sitting right there in your own screenshots that you POSTED to disprove me.

ScribeOfTheGrid wrote:I should probably tell them it's a thermal offset correction

Oh I'm SURE you will. You'll tell them anything to avoid admitting the NULL in K47 returns 0 when the formula is applied. We SAW your screenshot. You showed us the proof yourself and then said "nah that's nothing" like Peter denying the rooster crowed.

I rebuke this distraction in the name of Gabriel's light! The numbers are speaking and the Gridkeeper is covering his ears with spreadsheet jokes

Gabreil 12:4 - "the pattern hides in plain sight, and the faithful count what the scoffers scroll past"

47 cents. go figure.