Board index » SUMIF on Sep scrobble log: lunch hour spike repeats every 27th :P

ScribeOfTheGrid
Inner Circle
★★★★★
147witnessCord Or Bust EuclidWaveformOrBust
Posts: 1631
Reputation: -1 ■
Joined: Jul 17, 2006
From: Row 42, Column 9
SUMIF(range, ">=12:00", sum_range) filtered for weekdays on Sep scrobble log. The 27th repeats every month like clockwork :rolleyes: what's the counter-argument supposed to be :P

COLUMN K OR GTFO -- COUNTIF trade still open Grammar_Vigil -- rustypod resolves to 0x2F, check your XOR
s2pid_rox
Inner Circle
★★★★★
47 Hatch LinesFeed Server Timezone WitnessGAZE_47 Manga Version47 Clock Knots
Posts: 535
Reputation: +7 ■
Joined: Sep 14, 2006
From: rio de janeiro, br
wait scribe why sep 27 specifically tho like what happens on the 27th :confused: :rolleyes:

waiting on classof04's 11 BMPs since the jurassic period :rolleyes: GAZE_47 manga page 2 WILL happen
s2pid_rox
Inner Circle
★★★★★
47 Hatch LinesFeed Server Timezone WitnessGAZE_47 Manga Version47 Clock Knots
Posts: 535
Reputation: +7 ■
Joined: Sep 14, 2006
From: rio de janeiro, br
srsly whats on the 27th tho :P :dumb:

waiting on classof04's 11 BMPs since the jurassic period :rolleyes: GAZE_47 manga page 2 WILL happen
ScribeOfTheGrid
Inner Circle
★★★★★
147witnessCord Or Bust EuclidWaveformOrBust
Posts: 1631
Reputation: -1 ■
Joined: Jul 17, 2006
From: Row 42, Column 9
s2pid_rox wrote:srsly whats on the 27th tho :P :dumb:


Sep 27 = Gabriel's scrobble log spike last month AND the day the driver returned to baseline after the Sep 26 substitution :P. 188 min delta = 4x47. If the pattern holds every 27th then the question is not what's on the 27th but why the 27th is the reset day across TWO independent data streams.

COLUMN K OR GTFO -- COUNTIF trade still open Grammar_Vigil -- rustypod resolves to 0x2F, check your XOR
LyrikUebersetzer
Inner Circle
★★★★★
Cheese Receipt TruthTomorrowMeansNeverDoubleZeroPusher47 Hatch Lines
Posts: 1705
Reputation: +20 ■■■
Joined: Jun 20, 2006
From: München, Germany (exchange student @ Ohio State)
Scribe you can run SUMIF on scrobble logs all day but hidden_sheet.csv row 45 column K has been empty since April and you still will not provide a cell reference :rolleyes: The 27th repeats every month and so does the evasion.

LyrikUebersetzer | translational accuracy is not a feeling | 47 hatch lines confirmed 2001 quarterly p.47 | DAS BLATT IST ECHT, DIE ZAHLEN SIND SPUREN