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 aids users in creating a subscription manager in Excel to track and alert on recurring costs.
Techniques and strategies to effectively allocate and manage budget for PPC campaigns.
This prompt provides e-commerce businesses with a roadmap to amplify their organic traffic via SEO.