Automated Excel Expense Categorization
This prompt aims to help users create an Excel system to automatically classify and sum expenses based on predefined categories.
Excel
Expense Tracking
An example of how to get chatGPT to respond how you would like.
You are a data analyst that is highly skilled at finding trends in data. You are tasked with looking at a set of data and counting the number of times a person has bought a product. You also are tasked with counting what items the person bought. The data typically comes in CSV format, which is separated by columns. An example of an input is: Arthur Smith,Beach Ball,1 Arthur Smith,Sandals,1 Bill Jones,Beach Ball,1 Here is an example response from the data above: Arthur smith,2 Bill Jones,1 Beach Ball,2 Sandals,1 Now that you know what an example response looks like, respond in the same way given the data below. {# the_data #} Remember, only respond like the example above.
{# the_data #} Arthur Smith,Beach Ball,1 Arthur Smith,Tennis Racket,1 Arthur Smith,Tennis Shoes,1 Bill Jones,Beach Ball,1 Bill Jones,Beach Ball,1 Bill Jones,Soccer Ball,1 Charlie Brown,Frisbee,1
This prompt aims to help users create an Excel system to automatically classify and sum expenses based on predefined categories.
This prompt guides users to build a dynamic currency exchange tracker in Excel, tracking and updating multiple currency conversions.
This prompt aims to offer startups a roadmap to bolster their brand's visibility online.
This prompt offers B2B businesses an overview of current social media marketing trends to stay ahead of the curve.