Editorial contribution · business
Think through a spreadsheet before you build it
Want a spreadsheet that will still make sense later? Get suitable columns, sample rows and, where needed, formulas with a check you can follow.
Published: · Version 1
A prompt to try
Help me design a spreadsheet for [PURPOSE]. Software and language: [SOFTWARE, LANGUAGE]. Suggest columns with their data types and meanings. Show five explicitly fictional sample rows and explain which inputs need regular updates. If formulas are needed, provide them for the specified software and explain a test case. Do not claim to have run formulas or created a file. Ask if a metric has not yet been clearly defined in its business context.
Copy the text into your AI, fill in the placeholders and check the answer.
What you need
- Your own access to a suitable AI. Only add information you are comfortable sharing.
How to start
- Copy the prompt and paste it into your AI.
- Replace the placeholders and add any missing information.
- Check the answer and ask follow-up questions to adapt it to your situation.