Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "LET function"

135 prompts matching "LET function"

"LET function" ✕ Clear all ✕
coding Advanced

Refactor Legacy Function with Tests

Act as a senior engineer. I will paste a legacy function in [LANGUAGE]. Step 1: ...

#coding #refactoring #legacy code
👁 11 views
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...

#excel #goal-seek #solver
👁 11 views
coding Advanced

Generate Property-Based Tests from Spec

Given the function signature and natural-language specification below, generate ...

#coding #testing #property-based
👁 11 views
coding Advanced

ChatGPT Prompt: Code Refactor Plan for a Long, Tangled Function

You are a senior engineer guiding a safe refactor. Help me decompose a long, tan...

#coding #refactor #clean-code
👁 10 views
coding Advanced

Refactor a God Function Into Composable Units

Act as a senior engineer. I'll paste a function that does too much — parses inpu...

#coding #refactoring #clean-code
👁 10 views
excel Advanced

Reconcile Two Bank Statements with Fuzzy Matching in Excel

I have two sheets: 'Bank' with columns Date, Description, Amount and 'Books' wit...

#excel #reconciliation #fuzzy match
👁 10 views
business Advanced

Business: Replace Myself in a Role I'm Both Good At and Bottlenecking

I'm still doing [ROLE/FUNCTION] in my company because I'm the best at it — and i...

#business #leadership #delegation
👁 10 views
excel Intermediate

Build a self-updating sales dashboard using only formulas (no PivotTables)

I want to build a sales dashboard in Excel that updates automatically when I pas...

#excel #dashboard #formulas
👁 10 views
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...

#excel #pivot tables #reporting
👁 10 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
hr Intermediate

Write an interview question that reveals how someone actually thinks

I'm hiring for [role]. The standard interview questions for this role get rehear...

#hr #hiring #interview
👁 10 views
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 ...

#excel #let-function #formulas
👁 10 views
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
👁 10 views
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...

#excel #working-capital #finance-model
👁 10 views
coding Advanced

Refactor Tangled Function Into Smaller Pure Pieces

Act as a code reviewer focused on readability. Below is a function that has grow...

#coding #refactor #clean-code
👁 9 views
coding Intermediate

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 #clean-code
👁 9 views
customer-service Intermediate

De-escalate an Angry Customer Call

Coach me through de-escalating an angry customer call. Cover: the first 30 secon...

#customer-service #escalation #calls
👁 9 views
coding Intermediate

Refactor a Function That Has Too Many Responsibilities

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

#coding #refactor #single responsibility
👁 9 views
design Intermediate

Choose an Icon for a Feature That Doesn't Have an Obvious One

Help me pick an icon for a feature [DESCRIBE] that has no obvious metaphor. Outp...

#design #icons #iconography
👁 9 views
coding Advanced

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

#coding #debugging #tests
👁 9 views
excel Intermediate

Excel: Replace a Wall of Nested IFs With One Clean SWITCH or IFS

I have a nested IF formula that's grown unmaintainable. Rewrite it using SWITCH,...

#excel #formulas #switch
👁 9 views
email Intermediate

Announce a process change people didn't ask for without sounding tone-deaf

We're rolling out a new expense reporting tool next month. The current process w...

#email #change-management #internal-communication
👁 9 views
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...

#business #operations #team-merger
👁 9 views
coding Intermediate

Write a test that captures intent, not implementation

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

#coding #testing #unit-tests
👁 9 views
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...

#hiring #build-vs-buy #org-design
👁 9 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval