184|CHATGPT – Law Firm Collections

BYU Student Author: @Dallin_Gardner
Reviewers: @Jacob_Dutton, @Carter_Lee
Estimated Time to Solve:* 15 Minutes

We provide the solution to this challenge using:

  • ChatGPT

Need a program? Click here.

Overview
Your uncle runs a law firm in Utah, hears you’re pretty good with technology. He gives you a call and says he has a rather large list of clients who haven’t paid him for his services over the last quarter. He has you come into the office and explains that he wants to send a letter to each of the individuals requesting payment. He shows you the excel spreadsheet with some data from exported from their Enterprise Resource Planning (ERP) software, which you have below.

He’s found a service that’ll let him import the spreadsheet to their website and they will send the letters for him. However, the spreadsheet is very particular, and it must be set up to their exact parameters to upload properly. He’s started hardcoding the information onto another sheet formatted correctly but says “There has to be a faster way!” This is where you come in, and you are excited to put your ChatGPT skills to the test.

Instructions

  1. Download the file and to understand the current format of the data and the desired format (Sheet2)
  2. Upload the excel file to ChatGPT 4 (Unfortunately ChatGPT 3.5 is unable to complete this challenge. However, you can get a trial for ChatGPT add-in for Excel. See note in hints)
  3. Ask ChatGPT to copy the names into another sheet and spilt the address into the appropriate columns. Then have ChatGPT input the following message in the language noted in the preferred language column “Please remit payment of xxxx to Fake law firm for our services rendered previously"
  4. The xxxx should equal the appropriate value from “Amount Owed”
  5. Get an updated file and compare the new file to the first 3 rows that were previously hardcoded to make sure they match

Data Files

Suggestions and Hints
  • Ask ChatGPT to give you a preview of a few lines of the spreadsheet before downloading the file
  • Sometimes ChatGPT will give you unnecessary information in the chart, so you may need to correct and clarify depending on the response generated
  • If you do not have ChatGPT 4 you can download a Chatgpt add-in from Microsoft store that has functions such as =ai.extract() and =ai.translate() that will allow you to complete this challenge in another way

Solution