71 prompts matching "functions"
I have a function that's grown too long and hard to test. Help me refactor it st...
My Excel workbook recalculates painfully slowly and I don't know which sheet or ...
I inherited a 30-sheet Excel workbook and it gives slightly wrong totals. Walk m...
From the event log table with columns user_id, event_name, occurred_at, build a ...
I'm working in Excel with a table that has a Date column and an Amount column. I...
I have an Excel sheet with about 4,000 customer records. The Name column is a di...
I have a 600-line function that handles order processing. It's been touched by 1...
Act as a senior software engineer who pairs with juniors on refactors. I will pa...
Act as an Excel performance specialist. I will describe a workbook that has grow...
I'll paste a 400-line function that does too much. Help me refactor it. Walk thr...
You are an FP&A automation specialist. I have a monthly actuals sheet and a budg...
Act as an Excel data-cleaning specialist. I have a contact list with inconsisten...
Act as a refactoring lead. There's a circular import between two modules that th...
You are a software craftsperson focused on readable, maintainable code. I will p...
You are an expert Excel 365 power user. Help me turn a repetitive calculation in...
You are an Excel formula expert. I want to answer this question from my spreadsh...
I have a query with a correlated subquery that runs once per row to find each cu...
Act as an Excel formula assistant. I will describe what I want to calculate in p...
Act as a clean code expert. Refactor this code to improve readability and mainta...
You are an Excel power user. I will describe a dataset and a reporting goal, and...
You are an Excel performance consultant. I will describe my workbook's symptoms ...
You are a data-cleaning specialist. I have a messy Excel sheet with these proble...
You are a code reviewer focused on maintainability. Refactor this code without c...