Search: "function"

#data #sql #query-optimization

data Intermediate

Data: Rewrite a Slow Query Without Changing What It Returns

I have a SQL query that's slow. Make it fast while keeping the result set identi...

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

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

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

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

#coding #documentation #docstrings

coding Beginner

Generate Clear Docstrings and Comments

You are an expert developer who writes great documentation. Help me add clear do...

#excel #formulas #dynamic-arrays

excel Intermediate

Build a Dynamic Array Dashboard Formula

You are an Excel power user. I will describe a dataset and a reporting goal, and...

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

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

#dates #data cleaning #DATEVALUE

excel Intermediate

Detect mixed date formats in one column and pick the safest fix

Act as a spreadsheet auditor. I will paste 20 cells from a date column that came...

#SQL #window functions #query optimization

data Advanced

Rewrite a slow correlated subquery as a window function

I have a query with a correlated subquery that runs once per row to find each cu...

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

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

#coding #refactoring #clean code

coding Advanced

Refactor a Long Function into Clean, Testable Pieces

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

#excel #lambda #automation

excel Advanced

Write a Reusable LAMBDA Function

You are an expert Excel 365 power user. Help me turn a repetitive calculation in...

#coding #debugging #troubleshooting

Debug My Code With a Root-Cause Walkthrough

You are a senior software engineer doing a calm, systematic debugging session. I...

#coding #testing #unit-tests

Generate Unit Tests for a Function

Act as a test engineer. Write unit tests for this function: [PASTE FUNCTION] usi...

👁 2 views