Search: "FILTER function"

#coding #refactor #clean-code

Refactor a Long Function Without Changing Behavior

I have a function that's grown too long and hard to test. Help me refactor it st...

#coding #refactor #single responsibility

Refactor a Function That Has Too Many Responsibilities

I'll paste a function. Identify every responsibility it currently has (parsing, ...

#excel #goal-seek #solver

excel Advanced

Excel Goal Seek Alternative for Multi-Variable What-Ifs

I have an Excel model where multiple inputs affect one output and Goal Seek only...

#coding #debugging #tests

Untangle a Function Whose Tests Pass But Behavior Is Wrong

I have a function where the tests pass but production reports it's behaving wron...

#lesson-plan #flexibility #attendance

education Intermediate

Education: Plan a Lesson That Survives Half the Students Being Absent

Help me design a lesson on [topic] that works whether 30 students show up or 12....

#coding #refactoring #clean-code

Coding: Refactor a Function That Does Too Much Without Breaking Callers

I have a function that's grown into a god-function. Refactor it without changing...

#coding #refactoring #legacy-code

Coding: Refactor Code I Don't Have Tests For Without Breaking It

I need to refactor [MODULE/FUNCTION] and there are no tests. Yes, I should add t...

data Advanced

Write a Cohort Retention Query That Doesn't Secretly Double-Count Users

I need a SQL cohort retention query that groups users by their signup week and s...

#data #sql #cohort

#coding #code review #mentoring

Review a junior engineer's PR without rewriting it for them

A junior engineer on my team submitted a PR that works but has problems — naming...

#excel #let-function #formulas

excel Intermediate

Replace nested IFs with a clean LET formula that future-you can read

You are an Excel formula refactorer. Here is a nested IF formula that works but ...

#business #operations #team-merger

business Advanced

Diagnose why a recently merged team is missing deadlines despite more headcount

Act as an org effectiveness consultant. Six months ago we merged [TEAM_A] and [T...

#coding #testing #unit-tests

Write a test that captures intent, not implementation

You are a test design coach. Here is a function: [PASTE_FUNCTION]. The existing ...

#hiring #build-vs-buy #org-design

business Intermediate

Decide whether to build an in-house team or contract the work out

I'm deciding whether to hire an in-house team for [function — design, engineerin...

#business #operations #meetings

business Intermediate

Diagnose Why Our Weekly Team Meeting Feels Useless But Nobody Wants to Cancel It

Our team has a weekly meeting that everyone privately complains about but defend...

#coding #refactoring #legacy-code

Refactor a 500-Line Function Without Breaking the Three Features That Depend on Its Bugs

I have a 500-line function in production that I need to refactor. The complicati...

#coding #refactoring #legacy

Refactor a 600-line function without breaking the three teams that depend on it

I have a 600-line function that handles order processing. It's been touched by 1...

#refactor #extraction #legacy code

Pull one function out of a 600-line file without breaking callers

I want to extract one function from a 600-line legacy file into its own module. ...

#refactoring #clean-code #testing

Refactor a Monolithic Function into Pure, Testable Units

Act as a senior software engineer who pairs with juniors on refactors. I will pa...

#excel #fuzzy-match #deduplication

excel Advanced

Detect duplicate-but-different customer records in an Excel list

I have a 5,000-row customer table. Many are the same company entered slightly di...

#coding #refactoring #testing

Refactor a 400-line function without breaking implicit callers

I have a 400-line function that is impossible to test but heavily used. Help me ...

#code-review #feedback #communication

Write a code review comment that gets the change improved without making the author defensive

I want to leave a code review comment about [specific concern — naming, design c...

data Intermediate

Write a SQL Query from a Plain-English Question

You are a SQL expert and data analyst. I will describe a question in plain Engli...

#data #sql #query