47 prompts matching "index"
I have a worksheet with nested IF formulas like: =IF(A1="Bronze",0.05,IF(A1="Sil...
Act as a senior SQL performance engineer. I will share a slow SQL query, the ta...
I need to look up values in Excel using multiple conditions. My dataset has colu...
Act as an Excel power user. I have a sales dataset with columns: Date, Region, P...
I have two Excel sheets: my bank statement transactions and my internal accounti...
Analyze this investment opportunity using NPV and IRR: - Initial investment: [AM...
Build an Excel variance analysis report comparing Budget vs Actual for revenue a...
I want to build a sales dashboard in Excel that updates automatically when I pas...
Act as a database performance engineer with deep SQL optimization expertise. Hel...
Analyze the following slow SQL query and its EXPLAIN output. Identify the bottle...
I want a chart that always shows the last 12 months of revenue — so when I add M...
Act as an Excel performance specialist. I will describe a workbook that has grow...
The market is down [X%]. I have [POSITION]. I know intellectually I shouldn't se...
You're a commercial counsel reviewing a vendor contract on my behalf — but expla...
You are a database performance engineer. I will paste a slow SQL query and the t...
I need to backfill [COLUMN/TABLE] with [LOGIC]. The table has [N] rows. Write th...
I'll name an investing or finance concept I half-understand (compounding, divers...
You are an expert SQL expert. Help me write a correct SQL query and understand e...
I have a slow query and I'm about to add an index. Before I do, help me think it...
Act as a financial modeler reviewing my workbook. I have a model that runs base/...
Act as a SQL expert. I will describe what I want in plain English and you will w...
Act as an Excel expert. My VLOOKUPs keep breaking because colleagues insert and ...
Act as a database performance engineer. Here is a slow query and its context: [P...