Search: "filter function"

#LET function #nested IF #refactor

excel Advanced

Replace a fragile nested IF with a clean LET-based formula

Here is a nested IF that has grown to 7 branches and is breaking when someone ad...

#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 #unit testing #tdd

Generate Unit Tests with Edge Cases for a Function

Act as a test engineer who is obsessed with edge cases. I will give you a functi...

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

#coding #refactoring #clean-code

Refactor This Function Without Changing Behavior

Act as a senior engineer who refactors safely. I'll paste a function and you'll ...

#coding #refactoring #clean code

Refactor a 400-Line Function Into Cohesive Smaller Pieces

I'll paste a 400-line function that does too much. Help me refactor it. Walk thr...

#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....

#business #hiring #decision-making

business Intermediate

Business: Decide Whether to Hire, Contract, or Outsource a New Function

I need a new function in the company (e.g., design, finance, ops) and I'm torn b...

#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...

#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 ...

#email #internal-comms #leadership

email Advanced

Announce a leadership departure without rumor-mill spillover

You are an internal communications lead. Draft a company-wide email announcing t...

#productivity #calendar #meetings

productivity Advanced

Audit a calendar that's 70% meetings to find what to cut without political fallout

Act as an executive chief of staff. Audit my calendar for the last 4 weeks — [PA...

#code-comprehension #review #refactor

coding Beginner

Explain what a function does without me reading every line

Act as a senior engineer pairing with me. I will paste a function. Tell me in pl...

#excel #dropdown #data validation

excel Advanced

Build a dynamic dropdown that filters a second dropdown

I want two dependent dropdowns in Excel: pick a Region in cell A2, and the City ...

#coding #refactoring #clean code

Refactor a Long Function into Clean, Testable Pieces

You are a software craftsperson focused on readable, maintainable code. I will p...

#strategy #offsite #decisions

business Intermediate

Business: Diagnose Why a 'Strategy Offsite' Didn't Produce Decisions

We did a 2-day strategy offsite and left without any decisions made — just slide...

#creative #brainstorming #ideation

creative Beginner

Brainstorm without falling into the first idea that feels okay

I keep settling on the first decent idea I have instead of pushing through to th...

#coding #code review #maintainability

Review code like you actually have to maintain it next year

Review the code below as if you'll be the one maintaining it in twelve months. D...

#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. ...

#coding #code review #explanation

coding Beginner

Explain what this unfamiliar code actually does, line by line

I'll paste a function or script in a language I half-know. Explain it in plain E...

#coding #code review #edge cases

Review my function for the bug I can't see

Here's a function that passes my obvious tests but feels fragile. Act as a caref...