A friend gave me an excell file with a table of data, this data has four columns, one…
- User
A friend gave me an excell file with a table of data, this data has four columns, one for a code of a company named Código, another with a date named Fecha, another with a value named Débito and another with another value named Crédito. This table has the values for each date and for each code in Debito and Credito and what he needs is to group by codigo, and then by month, and have a result of the subtotal of that month that comes from the movements of Debito and Credito of each date for that Codigo in that month. I need you to write a prompt that I can introduce into google ai studio for it to help me or give me the instructions on how to write the formulas that can do this and how to present the results in the best way possible following best practices. please use the skills of prompt engineering to help me write this prompt that i mention at the end and even make the prompt suggest how to solve this yearly table and then once this is done, even propose a template that can be used in order to import the data provided by the accounting software that gives this data so that i could just import the data and have the answers given or solved, kind of like a template. How to prompt engineer
The prompt engineering pages in this section have been organized from most broadly effective techniques to more specialized techniques. When troubleshooting performance, we suggest you try these techniques in order, although the actual impact of each technique will depend on our use case.
Prompt generator
Be clear and direct
Use examples (multishot)
Let Claude think (chain of thought)
Use XML tags
Give Claude a role (system prompts)
Prefill Claude’s response
Chain complex prompts
Long context tips
- Assistant
Sure, I'd be happy to help you craft a prompt for Google AI Studio that utilizes prompt engineering techniques to achieve your goal. Here's a prompt that incorporates best practices:
Prompt:
As an expert in Excel and data analysis, please help me with the following task:
I have an Excel file containing transactional data with four columns:
- Código (Company Code) - Column A
- Fecha (Date) - Column B
- Débito (Debit Value) - Column C
- Crédito (Credit Value) - Column D
Objective:
- Group the data first by Código and then by month.
- For each Código and each month, calculate the subtotal of Débito and Crédito transactions.
- Present the results in the best possible way, following Excel best practices for clarity and usability.
- Propose a template that allows me to import new data from our accounting software so that the calculations and presentations update automatically.
Requirements:
-
Instructions and Formulas:
- Provide step-by-step instructions on how to perform the grouping and subtotal calculations.
- Include any necessary Excel formulas or functions.
- Suggest how to handle the date formatting to extract months from the dates.
-
Presentation:
- Advise on the best way to present the results for readability (e.g., using PivotTables, charts, or formatted tables).
- Explain how to format the results to highlight key information.
-
Template Creation:
- Describe how to set up the Excel file so that I can import data from the accounting software and have all calculations and presentations update automatically.
- Include instructions on how to maintain the template for future use.
Example Data:
To illustrate, here is a small sample of the data:
Código Fecha Débito Crédito 001 2023-01-15 500 0 001 2023-01-20 0 200 002 2023-02-10 300 0 001 2023-02-25 0 150 002 2023-01-05 400 0 002 2023-02-15 0 100 Desired Output:
A table or report that shows the subtotals of Débito and Crédito for each Código by month, like this:
Código Month Total Débito Total Crédito 001 January 500 200 001 February 0 150 002 January 400 0 002 February 300 100 Additional Context:
- Let me know if there are multiple ways to achieve this and which one is considered the best practice.
- Feel free to use Excel features like PivotTables, SUMIFS, or any other functions that simplify the process.
- Keep in mind that I'm looking for a scalable solution that works as new data is added.
This prompt is clear and direct, provides examples (multishot), and gives the AI a specific role (Excel and data analysis expert). It also uses a structured format to make the requirements clear.
How to Use This Prompt:
- Copy and paste the prompt into Google AI Studio.
- Run the prompt to receive detailed instructions and suggestions.
- Follow the provided steps to set up your Excel file accordingly.
Benefits of This Prompt:
- Clarity: By being specific about the data structure and desired output, the AI can provide precise instructions.
- Examples: Including sample data helps the AI understand the data types and formats you're working with.
- Role Assignment: Specifying the AI's role guides it to provide expert-level advice.
- Template Creation: Asking for a template ensures you get a reusable solution.
By using this prompt, you should receive comprehensive guidance on how to process your Excel data to achieve your goal.
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.