# ChatGPT to actually get some work done

**URL:** <https://community.goactuary.com/t/chatgpt-to-actually-get-some-work-done/6952>\
**Category:** Software/Technology\
**Created:** [December 7, 2022, 9:51pm UTC](https://community.goactuary.com/t/chatgpt-to-actually-get-some-work-done/6952 "2022-12-07T21:51:05Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![meep](https://community.goactuary.com/user_avatar/community.goactuary.com/meep/32/44_2.png) [@meep](https://community.goactuary.com/u/meep)\
**Post date:** [December 7, 2022, 9:51pm UTC](https://community.goactuary.com/t/chatgpt-to-actually-get-some-work-done/6952/1 "2022-12-07T21:51:05Z")

</div>

supposedly

> <https://twitter.com/tsrandall/status/1600257537974341632>

 ![image](https://community.goactuary.com/uploads/default/original/3X/e/5/e56f179f08262f6de8534c38d9234abfb9f74811.png)

So, let us look at what he’s claiming.

> ChatGPT saved me an hour of spreadsheet work today. It wrote a complex sorting script beyond my ability, explained how it works, and helped me deploy it.
> 
> The party tricks have been fun, but this was a whoa moment for me similar to the first time I used Google Search.  
> Some are asking if I could share the prompt that I used. But that’s just it—I’m not an expert in Excel and it wasn’t a single well-written prompt. It was more like a long chat with an Excel expert who was eager to help.  
> I think I started with something like “Help me write a script in Google Sheets.” Then just started describing the data and everything I wanted it to do. When something didn’t work, I’d feed the whole code back to it and ask what changes I need to make in order to do X.  
> I asked for rows within a range to be sorted based on values in several columns in order of priority. When certain conditions are met, values in a range are summed and added to another sheet. There’s a timestamp for new data. That sort of thing. It’s best to work in chunks.  
> Some issues came up, and I’d just post the error code or describe how it wasn’t doing what I expected and ask for some potential reasons why it wasn’t working. That was very effective—it would give me a clear list of possible problems, and often it was number 3 or 4.  
> Sorry I can’t be more specific—it’s trial and error. The key is ChatGPT’s natural language abilities. Just have a conversation like you would with a colleague on Slack—no need for a perfect prompt.

I’ve had some VBA macros stop working after recent Office updates.

Maybe I’ll see if ChatGPT can rewrite them for me. Or come up with a better solution.

---

<div class="post-metadata">

**Author:** ![John.S.Mill](https://community.goactuary.com/user_avatar/community.goactuary.com/john.s.mill/32/9771_2.png) [@John.S.Mill](https://community.goactuary.com/u/John.S.Mill)\
**Post date:** [December 8, 2022, 4:05am UTC](https://community.goactuary.com/t/chatgpt-to-actually-get-some-work-done/6952/2 "2022-12-08T04:05:10Z")

</div>

very smart!

---

<div class="post-metadata">

**Author:** ![Actuary321](https://community.goactuary.com/letter_avatar_proxy/v4/letter/a/ed8c4c/32.png) [@Actuary321](https://community.goactuary.com/u/Actuary321)\
**Post date:** [February 13, 2023, 5:57pm UTC](https://community.goactuary.com/t/chatgpt-to-actually-get-some-work-done/6952/3 "2023-02-13T17:57:08Z")

</div>

A video from Matty McTech about using ChatGPT for Excel. With what Meep posted above with what he does, sounds like it might be worth trying.

[![](https://community.goactuary.com/uploads/default/original/3X/7/d/7d04bed2ce1846ef56035de6ac4b5aa81aafc270.jpeg "I Mastered Excel with ChatGPT") ](https://www.youtube.com/watch?v=AjGz3VPveAE)

@meep, do you have any updates on its use?

---

<div class="post-metadata">

**Author:** ![meep](https://community.goactuary.com/user_avatar/community.goactuary.com/meep/32/44_2.png) [@meep](https://community.goactuary.com/u/meep)\
**Post date:** [February 13, 2023, 9:50pm UTC](https://community.goactuary.com/t/chatgpt-to-actually-get-some-work-done/6952/4 "2023-02-13T21:50:56Z")

</div>

Okay, I actually did not use ChatCPT for anything myself

HOWEVER

I really liked the discussion over ChatGPT in education:

[![](https://community.goactuary.com/uploads/default/original/3X/9/2/927d965d97b206bc1d1f9f4af65f5fe0e75150e9.jpeg "Impact of ChatGPT on Education Systems") ](https://www.youtube.com/watch?v=e6Lo2QP_iIw)

One of the uses the guy in education talked about was using it to generate examples for use in lesson plans, which I really liked. Using it to generate text on the same topic but with different tones, as it were.

Also, I’ve used AI tools for a couple things lately - not ChatGPT, but something called Lex, and if you’re interested in it, I’ve got 11 invites currently.

I’ve used Lex to generate titles/subtitles for stuff I’m writing. It supposedly helps kick people out of writer’s block, but writer’s block is far from my problem.

Generating titles is a problem for me, so on a recent piece I was working on, I took the executive summary, fed it into Lex, and asked it to generate 10 titles for me, and then asked my colleagues to pick the best one.

---

<div class="post-metadata">

**Author:** ![meep](https://community.goactuary.com/user_avatar/community.goactuary.com/meep/32/44_2.png) [@meep](https://community.goactuary.com/u/meep)\
**Post date:** [March 6, 2023, 8:15pm UTC](https://community.goactuary.com/t/chatgpt-to-actually-get-some-work-done/6952/5 "2023-03-06T20:15:22Z")

</div>

Something else:

[![](https://community.goactuary.com/uploads/default/original/3X/e/0/e09f0ea2d2c0f10cd87e2532426d23f9ccd55a82.jpeg "Bring ChatGPT INSIDE Excel to Solve ANY Problem Lightning FAST") ](https://www.youtube.com/watch?v=kQPUWryXwag)

---

<div class="post-metadata">

**Author:** ![1695814](https://community.goactuary.com/user_avatar/community.goactuary.com/1695814/32/38506_2.png) [@1695814](https://community.goactuary.com/u/1695814)\
**Post date:** [May 31, 2023, 4:29pm UTC](https://community.goactuary.com/t/chatgpt-to-actually-get-some-work-done/6952/6 "2023-05-31T16:29:32Z")

</div>

I think I’ll put this here…it’s a discussion using ChatGPT at work:  
[https://www.marketwatch.com/story/using-chatgpt-at-work-could-seriously-damage-your-career-but-are-you-tempted-e0173714?cx\_testId=3&cx\_testVariant=cx\_160&cx\_artPos=6&mod=WTRN#cxrecs\_s](https://www.marketwatch.com/story/using-chatgpt-at-work-could-seriously-damage-your-career-but-are-you-tempted-e0173714?cx_testId=3&cx_testVariant=cx_160&cx_artPos=6&mod=WTRN#cxrecs_s)

> **link to text**
>
> [https://pdf.fivefilters.org/makepdf.php?v=2.6&url=https%3A%2F%2Fwww.marketwatch.com%2Fstory%2Fusing-chatgpt-at-work-could-seriously-damage-your-career-but-are-you-tempted-e0173714%3Fcx\_testId%3D3%26cx\_testVariant%3Dcx\_160%26cx\_artPos%3D6%26mod%3DWTRN%23cxrecs\_s&api\_key=&mode=multi-story&output=pdf&template=A4&images=1&date=1&sub=&title=Your+Personal+Newspaper&order=desc&date\_start=&submit=Create](https://pdf.fivefilters.org/makepdf.php?v=2.6&url=https%3A%2F%2Fwww.marketwatch.com%2Fstory%2Fusing-chatgpt-at-work-could-seriously-damage-your-career-but-are-you-tempted-e0173714%3Fcx_testId%3D3%26cx_testVariant%3Dcx_160%26cx_artPos%3D6%26mod%3DWTRN%23cxrecs_s&api_key=&mode=multi-story&output=pdf&template=A4&images=1&date=1&sub=&title=Your+Personal+Newspaper&order=desc&date_start=&submit=Create)

Hang on while I go as ChatGPT to craft my opinion on this article.

Seriously, though, it should be common sense that you need to read & understand its output before you use it.

---

<div class="post-metadata">

**Author:** ![JFG](https://community.goactuary.com/user_avatar/community.goactuary.com/jfg/32/8801_2.png) [@JFG](https://community.goactuary.com/u/JFG)\
**Post date:** [May 31, 2023, 5:40pm UTC](https://community.goactuary.com/t/chatgpt-to-actually-get-some-work-done/6952/7 "2023-05-31T17:40:16Z")

</div>

> [@1695814](#):
>
> Seriously, though, it should be common sense that you need to read & understand its output before you use it.

If you haven’t noticed, critical thinking is in decline, despite all those who “do their own research.”

---

<div class="post-metadata">

**Author:** ![dr\_t\_non-fan](https://community.goactuary.com/letter_avatar_proxy/v4/letter/d/a8b319/32.png) [@dr\_t\_non-fan](https://community.goactuary.com/u/dr_t_non-fan)\
**Post date:** [May 31, 2023, 6:01pm UTC](https://community.goactuary.com/t/chatgpt-to-actually-get-some-work-done/6952/8 "2023-05-31T18:01:48Z")

</div>

> [@1695814](#):
>
> Seriously, though, it should be common sense that you need to read & understand its output before you use it.

Agreed.  
Same goes for GPS, “autopilot,” the gauge that tells you how many miles you have left in your tank, any black-box model at work, …

---

<div class="post-metadata">

**Author:** ![Kenny](https://community.goactuary.com/user_avatar/community.goactuary.com/kenny/32/53_2.png) [@Kenny](https://community.goactuary.com/u/Kenny)\
**Post date:** [May 31, 2023, 6:14pm UTC](https://community.goactuary.com/t/chatgpt-to-actually-get-some-work-done/6952/9 "2023-05-31T18:14:58Z")

</div>

The unwritten part at the end of numbers’ sentence was “as your own”, that is not the case for GPS, auto-pilot and a fuel gauge. The black box model at work, there’s an ASOP for that.

---

<div class="post-metadata">

**Author:** ![dr\_t\_non-fan](https://community.goactuary.com/letter_avatar_proxy/v4/letter/d/a8b319/32.png) [@dr\_t\_non-fan](https://community.goactuary.com/u/dr_t_non-fan)\
**Post date:** [May 31, 2023, 6:27pm UTC](https://community.goactuary.com/t/chatgpt-to-actually-get-some-work-done/6952/10 "2023-05-31T18:27:58Z")

</div>

> [@Kenny](#):
>
> The black box model at work, there’s an ASOP for that.

Black boxes are in a lot of places that we just take for granite (solidly, like a rock) that they work properly (“they” wouldn’t allow them if they weren’t tested and approved, right?). I can’t seem to think of any at the moment.  
OK: Google will often show business hours of businesses. What is the source of that info? The proprietor? Other users whose word we must take? How old is that info? Sure, it would be nice if the source was legitimate.  
Same for Waze or Google Maps: says there is some slow-down, and on Waze, someone has piped in to say there is an accident and left lane is closed. Why should we blindly trust that info? How many drivers are taking that alternative route that is now also slowing down? Fun question: how do these apps know the speed of traffic? Via ground sensors? Via turned-on cell phones in cars? Via cars’ computers sending info?

---

<div class="post-metadata">

**Author:** ![NormalDan](https://community.goactuary.com/user_avatar/community.goactuary.com/normaldan/32/1013_2.png) [@NormalDan](https://community.goactuary.com/u/NormalDan)\
**Post date:** [May 31, 2023, 6:52pm UTC](https://community.goactuary.com/t/chatgpt-to-actually-get-some-work-done/6952/11 "2023-05-31T18:52:40Z")

</div>

Based on what research!?

---

<div class="post-metadata">

**Author:** ![meep](https://community.goactuary.com/user_avatar/community.goactuary.com/meep/32/44_2.png) [@meep](https://community.goactuary.com/u/meep)\
**Post date:** [June 1, 2023, 8:49am UTC](https://community.goactuary.com/t/chatgpt-to-actually-get-some-work-done/6952/12 "2023-06-01T08:49:32Z")

</div>

I love how people are all “OMG AI’S GONNA KILL US!!!” and I’m thinking, why the hell are you giving it access to those sorts of systems… you’re not even putting controls on your spreadsheets.

…oh yeah

Seriously, humans are lazy and stupid, and we lie. We created AI in our own image.

---

<div class="post-metadata">

**Author:** ![The\_Polymath](https://community.goactuary.com/user_avatar/community.goactuary.com/the_polymath/32/83081_2.png) [@The\_Polymath](https://community.goactuary.com/u/The_Polymath)\
**Post date:** [June 1, 2023, 9:50am UTC](https://community.goactuary.com/t/chatgpt-to-actually-get-some-work-done/6952/13 "2023-06-01T09:50:27Z")

</div>

I just had a chat with a higher up today (CFO)

AI is not going to be used anytime soon over here as there are too many issues still to iron out.

At most we will only be rolling out AI-assisted MSFT apps once they come out with something workable.

It will definitely improve productivity as a lot of manual work (not sensitive) can be automated. Minutes of meetings for example. Much easier with AI-assisted audio transcription (the current one they have is not very good).

---

<div class="post-metadata">

**Author:** ![meep](https://community.goactuary.com/user_avatar/community.goactuary.com/meep/32/44_2.png) [@meep](https://community.goactuary.com/u/meep)\
**Post date:** [June 1, 2023, 10:47am UTC](https://community.goactuary.com/t/chatgpt-to-actually-get-some-work-done/6952/14 "2023-06-01T10:47:41Z")

</div>

UUUUUGH

[https://www.microsoft.com/en-us/research/project/calc-intelligence/](https://www.microsoft.com/en-us/research/project/calc-intelligence/)

The text below came from an abstract via EuSprIG (European Spreadsheet Risks Interest Group)

> **Bringing generative AI to the Excel grid: from research to practice (Keynote)**
> 
> Andrew D. Gordon and Jack Williams,  
> Calc Intelligence Microsoft Research  
> Team link: [https://aka.ms/CalcIntel](https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Faka.ms%2FCalcIntel&data=05%7C01%7CSThorne%40cardiffmet.ac.uk%7C9fa3489ff98a424fcd3508db4597b777%7C189dc61c769b40488b0f6de074bba26c%7C0%7C0%7C638180290150275111%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=dUziJJCYoxhSt%2FQ%2B0%2Fe5V%2F0KgBvM5x3j6YDJnGsldPk%3D&reserved=0)
> 
> Abstract
> 
> Learn how to transform your textual data within the Excel grid using the new LABS.GENERATIVEAI() function. It empowers Excel users with OpenAI’s pre-trained language models. It’s part of the new add-in _Excel Labs, a Microsoft Garage project_ that also delivers new formula editing and reuse features, including easy editing of LAMBDAs. We’ll showcase the productivity benefits of using LABS.GENERATIVEAI() in conjunction with LAMBDA-defined functions. These features build on our research in the Calc Intelligence team at Microsoft Research in Cambridge and arise from a long-term partnership with Excel

---

<div class="post-metadata">

**Author:** ![meep](https://community.goactuary.com/user_avatar/community.goactuary.com/meep/32/44_2.png) [@meep](https://community.goactuary.com/u/meep)\
**Post date:** [June 1, 2023, 12:29pm UTC](https://community.goactuary.com/t/chatgpt-to-actually-get-some-work-done/6952/15 "2023-06-01T12:29:16Z")

</div>

Two other AI-related abstracts from the list:

> **ChatGPT and Excel – trust, but verify**
> 
> Patrick O’Beirne
> 
> Systems Modelling Ltd
> 
> **ABSTRACT**
> 
> This paper adopts a critical approach to GPT-4, showing how its huge reach makes it a useful tool for people with simple requirements but a bad, even misleading guide to those with more complex problems which are more rarely present in the training data and even more rarely have straightforward solutions.
> 
> It concludes with a practical guide for how to add an Excelscript button, with system and user prompts, to the GPT-4 API into the Excel desktop environment, supported by a blog post giving the technical details for those interested.
> 
> **Experimenting with ChatGPT3 for Spreadsheet Formulae Generation: The Risks of AI Generated Spreadsheets**
> 
> Simon Thorne
> 
> Cardiff Metropolitan University
> 
> **Abstract**
> 
> Large Language Models (LLM) have become sophisticated enough that complex computer programs can be created through interpretation of plain English sentences and implemented in a variety of modern languages such as Python, Java Script, C++ and Spreadsheets. These tools are powerful and relatively accurate and therefore provide broad access to computer programming regardless of the background or knowledge of the individual using them. This paper presents a series of experiments with ChatGPT to explore it’s ability to produce valid spreadsheet formulae and related computational outputs in situations where ChatGPT has to deduce, infer and problem solve the answer. The results show that in certain circumstances, ChatGPT can produce correct spreadsheet formulae with correct reasoning, deduction and inference. However, when information is limited, uncertain or the problem is too complex, the accuracy of ChatGPT breaks down as does its ability to reason, infer and deduce. This can also result in false statements and “hallucinations” that all subvert the process of creating spreadsheet formulae.

---

<div class="post-metadata">

**Author:** ![Gonzo](https://community.goactuary.com/user_avatar/community.goactuary.com/gonzo/32/834_2.png) [@Gonzo](https://community.goactuary.com/u/Gonzo)\
**Post date:** [June 2, 2023, 6:16pm UTC](https://community.goactuary.com/t/chatgpt-to-actually-get-some-work-done/6952/16 "2023-06-02T18:16:42Z")

</div>

anyone use this new thingamajing to write an actuarial memo? Asking for a friend

---

<div class="post-metadata">

**Author:** ![1695814](https://community.goactuary.com/user_avatar/community.goactuary.com/1695814/32/38506_2.png) [@1695814](https://community.goactuary.com/u/1695814)\
**Post date:** [June 2, 2023, 6:19pm UTC](https://community.goactuary.com/t/chatgpt-to-actually-get-some-work-done/6952/17 "2023-06-02T18:19:45Z")

</div>

I used it to clean up some awkward language in our cash flow testing memo…but not to write the whole thing.

---

<div class="post-metadata">

**Author:** ![meep](https://community.goactuary.com/user_avatar/community.goactuary.com/meep/32/44_2.png) [@meep](https://community.goactuary.com/u/meep)\
**Post date:** [June 2, 2023, 10:12pm UTC](https://community.goactuary.com/t/chatgpt-to-actually-get-some-work-done/6952/18 "2023-06-02T22:12:06Z")

</div>

![](https://community.goactuary.com/uploads/default/original/3X/e/d/ed88a02125b72cb79f58711cd1f361f7845b2c5a.gif "Here We Go Sitdown GIF - Here We Go Sitdown Chair - Discover & Share GIFs")

---

<div class="post-metadata">

**Author:** ![MayanActuary](https://community.goactuary.com/user_avatar/community.goactuary.com/mayanactuary/32/8794_2.png) [@MayanActuary](https://community.goactuary.com/u/MayanActuary)\
**Post date:** [June 3, 2023, 12:42am UTC](https://community.goactuary.com/t/chatgpt-to-actually-get-some-work-done/6952/19 "2023-06-03T00:42:56Z")

</div>

I am never writing a cover letter alone again. This thing is awesome at those and I hate those

---

<div class="post-metadata">

**Author:** ![SredniVashtar](https://community.goactuary.com/user_avatar/community.goactuary.com/srednivashtar/32/2894_2.png) [@SredniVashtar](https://community.goactuary.com/u/SredniVashtar)\
**Post date:** [June 6, 2023, 4:13pm UTC](https://community.goactuary.com/t/chatgpt-to-actually-get-some-work-done/6952/20 "2023-06-06T16:13:05Z")

</div>

I plan to use GPT for all of my SAS problems, because I fracking hate googling for SAS help.

[Next page](https://community.goactuary.com/t/chatgpt-to-actually-get-some-work-done/6952.md?page=2)
