Live data from Hacker News

Demo of =GPT3() as a spreadsheet feature

twitter.com

61–70 of 149 posts

Re: Demo of =GPT3() as a spreadsheet feature

#61
post #14

Of all the places spreadsheet is probably the one place you don’t want AI generated content. Half the time it’s financial info so sorta correct simply isn’t good enough

When I see something is in a spreadsheet I immediately assume there are at least 3 things wrong with the data, 1 of which is obvious.

Re: Demo of =GPT3() as a spreadsheet feature

#62
post #5

From one of the replies: “This is awesome. I also love how 20% of the zip codes are wrong. Messy AI future seems really fun and chaotic.”

A human developer once told me that bad data is better than no data. So of course a human developer made an AI that makes bad data.

FWIW, the actual saying is that for the purposes of collection by enemies (like Facebook and Google or KGB and NSA), the only thing better than no data is bad data.

Re: Demo of =GPT3() as a spreadsheet feature

#63
post #41
post #14

Of all the places spreadsheet is probably the one place you don’t want AI generated content. Half the time it’s financial info so sorta correct simply isn’t good enough

Most real-world spreadsheets contained significant errors in this 2005 review: https://www.researchgate.net/publication/228662532_What_We_K... Is there any reason to think the situation has substantially improved since then?

This is not a good excuse to actively and knowingly make it worse

Re: Demo of =GPT3() as a spreadsheet feature

#64
post #5

From one of the replies: “This is awesome. I also love how 20% of the zip codes are wrong. Messy AI future seems really fun and chaotic.”

>I also love how 20% of the zip codes are wrong. Only they aren't. Check the video again, they come out fine. Edit: Oh dang, you're all right, several of them have wrong digits. :l

Row 15 includes the zip code 92105 in column A but the output is 92101. Similar for Row 5.

Re: Demo of =GPT3() as a spreadsheet feature

#65

51s -- "We are truly grateful", says the heartfelt thankyou card that was written by an algorithm in a spreadsheet.

Oh, this is nothing new.

I remember in like 2007 or something, in the early days of Facebook, someone made a CLI interface to the FB API. And I wrote a random-timed daily cron job that ran a Bash script that checked "which of my FB friends have their birthday today", went through that list, selected a random greeting from like 15 different ones I'd put into an array, and posted this to the wall of person $i. Complete with a "blacklist" with names of close friends and family, where the script instead sent me an email reminder to write a manual, genuine post.

I used to have a golfed version of that script as my Slashdot signature.

Re: Demo of =GPT3() as a spreadsheet feature

#67

This is terrific stuff, honestly. I could see an Airtable integration being really quite useful. There were lots of times when I will run some quick scraping, some cleaning up via an Upworker, and then join against something else. Here volume matters, and all misses are just lost data which I'm fine with. The general purpose nature of the tool makes it tremendous. There was a time when I would have easily paid $0.05…

Was anyone able to test if the Airtable implementation works as well as the twitter 'ad'?

Re: Demo of =GPT3() as a spreadsheet feature

#68
There is a huge potential for language models to get close to messy text problems (many of which are in Excel and Sheet). I am the founder of promptloop.com - the author of this tweet has been an early user.

The challenge to making something like this, or Co-pilot / Ghostwrite, work well is about meeting users where they are. Spreadsheet users dont want to deal with API keys or know what temperature is - but anyone (like this tweet) can set up direct API use with generic models in 10 minutes. This document has all the code to do so ;). [1]

For non-engineers - or folks who need a reliable and familiar syntax to use at scale and across their org - promptloop [2] is the best way to do that. All comments in here are great though. We have been live with users since the summer - no waitlist. And as a note - despite the name "prompt engineering" has almost nothing to do with making this work at scale.

[1] https://docs.google.com/spreadsheets/d/1lSpiz2dIswCXGIQfE69d... [2] https://www.promptloop.com/

Re: Demo of =GPT3() as a spreadsheet feature

#70
post #46

Do I understand that correctly? When I have to create a spreadsheet like this, there are 2 options. Option 1 I write a table zipcode to state and use this table to generate my column. If I carefully check my table my spreadsheet would be okay. Option 2 I ask GPT3 to do my work. But I have to check the whole spreadsheet for errors.

I dealt with something similar. I was creating a large directory of childcare centres in Canada. I had thousands of listings with a url but no email address. I created a Mechanical Turk job to ask turkers to go to website and find an email address. Many came back with email addresses like admin@>.com. After checking a few, I realized that the turkers were just guessing that admin@ would work and I'd approve their work. I ended up having to double check all the work.
Post reply on HN