Search: "LET 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...

excel Advanced

Automate Variance-to-Budget Reporting in Excel with LET and LAMBDA

You are an FP&A automation specialist. I have a monthly actuals sheet and a budg...

#lambda #let #variance

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

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

#excel #working-capital #finance-model

excel advanced

Build a working capital model from a P&L extract without manual joins

Act as a finance analyst. I will paste a monthly P&L extract plus a trial-balanc...

finance advanced

Pick the right metric for a unit that does not fit the company's KPI tree

Act as an FP&A leader. A new business unit does not fit the company's existing K...

#finance #metrics #fpna

#observability #logging #metrics

Choose what to log and what to drop when adding observability to a service that has none

You're an SRE who has cleaned up a lot of logging messes. I'm adding observabili...

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

#excel #pivot tables #reporting

excel Intermediate

Turn a messy operational export into a pivot table that someone will actually read

I have an operational export with [N] rows and columns like [DATE, REGION, PRODU...

#creative #brainstorming #ideation

creative Beginner

Brainstorm without converging on the first idea that sounds plausible

I need to brainstorm [TOPIC — campaign, name, feature, solution]. Give me ideas ...

#legal #contracts #review

legal Advanced

Review a contract for what's actually risky, not just what's there

Act as someone who's reviewed enough contracts to know which clauses are boilerp...

#data #analysis #statistics

data Intermediate

Decide whether a metric change is real or just noise this week

A metric I track jumped by 15% this week compared to last week. Before I tell an...

data Advanced

Explain a metric movement to a skeptical stakeholder without overclaiming

[Metric] moved [direction + magnitude] in [period]. The first plausible explanat...

#data #metrics #analysis

customer-service Intermediate

Write a canned response that doesn't sound canned

We get [type of request] dozens of times a week. Currently each agent freestyles...

#customer-service #templates #canned-response

#education #differentiation #lesson-planning

education advanced

Differentiate one lesson for a wide range of abilities without doubling your prep time

Act as a teacher coach for someone who has 28 students in one room ranging from ...

#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 #formulas #automation

excel beginner

Write Excel Formulas from Plain English

Act as an Excel formula assistant. I will describe what I want to calculate in p...

#coding #testing #unit tests

coding intermediate

Write Unit Tests for My Function

Act as a senior software engineer. Write comprehensive unit tests for this funct...

#excel #formulas #debugging

excel Advanced

Reverse-engineer a broken Excel formula someone else wrote

I inherited a spreadsheet with a long, nested Excel formula I don't understand a...

#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 #testing #edge cases

Write the test cases I'd forget for this function

I'll paste a function and describe what it's supposed to do. List the test cases...

#coding #code review #edge cases

coding Advanced

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