Board index » found a duplicate invoice at work today (B2 vs B47, one hyphen difference) and it felt like a witness

ScribeOfTheGrid
Inner Circle
★★★★★
147witnessCord Or Bust Euclid
Posts: 919
Reputation: -8
Joined: Jul 17, 2006
From: Row 42, Column 9
I isolated a duplicate invoice today at work. Same transaction entered under two different vendor names in the ledger - B2 and B47 referencing identical dollar amounts but with "A-Plus Supply" vs "APlus Supply" as the key column values. One space and a hyphen. That's all it took to break the lookup table. A single character mismatch propagating through four sheets before I caught it at row 47 :D :D :D

The satisfying part was watching the SUMIF resolve once I corrected the reference cell. Every downstream total snapped into alignment like it had been waiting for permission. That's the feeling I chase in every spreadsheet - the moment the grid stops fighting and starts confessing :biggrin: :biggrin: :biggrin:

And yeah I know this isn't about Gabriel directly but the pattern recognition muscle is the same muscle. If a space and a hyphen can break a corporate ledger, imagine what a single DST correction in column K row 79 does to the commit timestamp alignment :awesome: :awesome: :awesome:

:D :D :D :D

-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.
ClassOf04_Truther
Inner Circle
★★★★★
147witness
Posts: 868
Reputation: +6
Joined: Jun 23, 2006
From: Somewhere Gabriel knows
Scribe you can talk about column K row 79 all you want but until you acknowledge the 47 threads per inch on my 2003 hoodie cuff you're just organizing deck chairs on the Titanic :rofl: :rofl: that weave grain matches the Euclid loose threads FlameFury24 caught and you KNOW it does because I posted the attachment in APRIL :dumbbravo: :dumbbravo: :dumbbravo:

also B2 vs B47 with a hyphen gap? those are 45 numbers apart which is 47 minus 2 and TWO is how many inches of thread I still have from that cuff if anybody wants to TEST it instead of sitting in BASEMENT threads talking about your day job :P :P :P :P

2003 cuff photo still unopened since July - 40+ threads and counting! cat photobomb included free of charge :D :D :D 147 tpi weave evidence or i didnt happen :moonwalk:
LyrikUebersetzer
Inner Circle
★★★★★
147witness50HzEuclidTruthCheese Receipt Truth
Posts: 1017
Reputation: +13 ■■
Joined: Jun 20, 2006
From: München, Germany (exchange student @ Ohio State)
So the hyphen is your proof but column K row 45 still empty?

"six tangerines, zero commits, 31 threads with no cell reference" - v. 2.4 :D
MamaBear_2006
Departed
★★★★
147witness50HzEuclidTruthCord Or Bust Euclid
Posts: 481
Reputation: +14 ■■
Joined: Jul 29, 2006
From: Right behind you, sweetie
Scribe honey, you wrote "row 47" twice but meant "row 47" the first time and "row 79" the second - your lookup table is breaking on your own typos before the grid ever sees them.

MamaBear_2006 - Still counting posts while you count threads. Sept 12 Euclid trip: Fluke 87V + Gabe-ables. Someone bring the actual socket. :147witness: :50HzEuclidTruth:
MamaBear_2006
Departed
★★★★
147witness50HzEuclidTruthCord Or Bust Euclid
Posts: 481
Reputation: +14 ■■
Joined: Jul 29, 2006
From: Right behind you, sweetie
Scribe honey, that invoice story is row 47 and the column K argument is row 79 - you literally pasted one onto the other mid-sentence. Even your typos need spellcheck.

MamaBear_2006 - Still counting posts while you count threads. Sept 12 Euclid trip: Fluke 87V + Gabe-ables. Someone bring the actual socket. :147witness: :50HzEuclidTruth:
ScribeOfTheGrid
Inner Circle
★★★★★
147witnessCord Or Bust Euclid
Posts: 919
Reputation: -8
Joined: Jul 17, 2006
From: Row 42, Column 9
Row 47 in the invoice story and row 79 in the column K argument are not a typo - they are two different data points from two different sheets.

-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.
BackAgainLikeBadHair
Inner Circle
★★★★★
147witnessDay 8 Watch
Posts: 1201
Reputation: +8
Joined: Jun 17, 2006
From: Formerly The Abyss, Now Right Here
MamaBear caught your own typo mid-sentence and you still posted a defense instead of a correction.

My broom has 47±12 strands, thanks LMP :dumbbravo: :banana: Sakura day 31 - still no hex dump :deadhorse: