Chat GPT & Generative AI tools

A place to discuss anything.
Post Reply
User avatar
ShaunWhite
Posts: 9924
Joined: Sat Sep 03, 2016 3:42 am

I changed my setting so it has an option rather than being neutral.
I'd been grumbling about techs obsession with renaming things.....

Tech terms like "action handler" could definitely use a dose of humor and humility. "Action handler" indeed—might as well call it "thing that does stuff when you tell it to" and be done with it!


:D
User avatar
jimibt
Posts: 4163
Joined: Mon Nov 30, 2015 6:42 pm
Location: Narnia

ShaunWhite wrote:
Wed Jan 08, 2025 4:38 pm
jimibt wrote:
Mon Jan 06, 2025 1:15 pm
got similarly bad results. 2 images of where i live (town square, plus shore with island in background). Identified it as being in russia
Didn't realise it had temperature analysis. :D
you may be onto summit there!! certainly today would place us somewhere north of siberia!!

hope you've got that boutique bathroom completed. :) in fact, i'm sure gpt has redesigned your entire living space since last talking!!
Michael5482
Posts: 1683
Joined: Fri Jan 14, 2022 8:11 pm

I see Starmer is about to give a speech regarding unleashing AI, be interesting what he has to say.

I'm never comfortable with Government (whatever the party) and technology they haven't got their heads around the internet or social media and now appear to be moving into AI.
User avatar
Euler
Posts: 25723
Joined: Wed Nov 10, 2010 1:39 pm
Location: Bet Angel HQ

Ultimately, it looks like we will be handing money to our US cousins regarding AI.

We should establish areas of excellence, encourage inward investment, and think longer term. Despite inventing investment banking, we are not structurally set up for entrepreneurs in the UK. We need to be at the forefront of developments, not lagging behind.

Also, the public sector needs to be brutal in its adoption. I’d imagine they will spend money in the public sector and see lots of resistance and little or no change in productivity. So much change has occured in technology but the public sector never seems to be more productive!
Michael5482
Posts: 1683
Joined: Fri Jan 14, 2022 8:11 pm

Euler wrote:
Mon Jan 13, 2025 11:58 am
Ultimately, it looks like we will be handing money to our US cousins regarding AI.

We should establish areas of excellence, encourage inward investment, and think longer term. Despite inventing investment banking, we are not structurally set up for entrepreneurs in the UK. We need to be at the forefront of developments, not lagging behind.

Also, the public sector needs to be brutal in its adoption. I’d imagine they will spend money in the public sector and see lots of resistance and little or no change in productivity. So much change has occured in technology but the public sector never seems to be more productive!
I see the unions have just put a statement out already on AI :lol: This country in a nutshell really far too much regulation, and blockers everywhere you turn.

I agree with the US, Trump is about to slash red tape and clean up.
User avatar
firlandsfarm
Posts: 3214
Joined: Sat May 03, 2014 8:20 am

I recently found this video on YouTube ... for me it was a real eye-opener. Has anyone tried using AI to draft their prompts and/or come across other imaginative uses?
User avatar
firlandsfarm
Posts: 3214
Joined: Sat May 03, 2014 8:20 am

Using ChatGPT to sort some football data and produce a CSV file for me to download but 'special' characters are appearing in the team names such as "Leganés vs. Atlético Madrid" ... is there a setting I need to adjust?
sionascaig
Posts: 1520
Joined: Fri Nov 20, 2015 9:38 am

firlandsfarm wrote:
Sat Jan 18, 2025 10:08 am
Using ChatGPT to sort some football data and produce a CSV file for me to download but 'special' characters are appearing in the team names such as "Leganés vs. Atlético Madrid" ... is there a setting I need to adjust?
You could try telling it to run this on your data:

Sub ReplaceAccentedChar()
Const sFm As String = "ŠŽšžŸÀÁÂÃÄÅÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖÙÚÛÜÝàáâãäåçèéêëìíîïðñòóôõöùúûüýÿ"
Const sTo As String = "SZszYAAAAAACEEEEIIIIDNOOOOOUUUUYaaaaaaceeeeiiiidnooooouuuuyy"
Dim i As Long, ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
For i = 1 To Len(sFm)
ws.Cells.Replace Mid(sFm, i, 1), Mid(sTo, i, 1), LookAt:=xlPart, MatchCase:=True
Next i
Next ws
End Sub

And that will leave just the czechoslovakia special chars + a few others e.g.

Ø
ć
ø
č
ğ
ă
ș
ß
Č
ź
ń
ı
š
İ

edit - although looking at your data issue more closely - looks like something else is going on !
User avatar
firlandsfarm
Posts: 3214
Joined: Sat May 03, 2014 8:20 am

sionascaig wrote:
Sat Jan 18, 2025 10:27 am
firlandsfarm wrote:
Sat Jan 18, 2025 10:08 am
Using ChatGPT to sort some football data and produce a CSV file for me to download but 'special' characters are appearing in the team names such as "Leganés vs. Atlético Madrid" ... is there a setting I need to adjust?
You could try telling it to run this on your data:

Sub ReplaceAccentedChar()
Const sFm As String = "ŠŽšžŸÀÁÂÃÄÅÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖÙÚÛÜÝàáâãäåçèéêëìíîïðñòóôõöùúûüýÿ"
Const sTo As String = "SZszYAAAAAACEEEEIIIIDNOOOOOUUUUYaaaaaaceeeeiiiidnooooouuuuyy"
Dim i As Long, ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
For i = 1 To Len(sFm)
ws.Cells.Replace Mid(sFm, i, 1), Mid(sTo, i, 1), LookAt:=xlPart, MatchCase:=True
Next i
Next ws
End Sub

And that will leave just the czechoslovakia special chars + a few others e.g.

Ø
ć
ø
č
ğ
ă
ș
ß
Č
ź
ń
ı
š
İ

edit - although looking at your data issue more closely - looks like something else is going on !
Thanks sionascaig, that was food for thought and caused me to try a more simple solution first. I gave the following instruction "run LaLigaTemplate using only English characters in your response" and it did ... problem solved. :D
sionascaig
Posts: 1520
Joined: Fri Nov 20, 2015 9:38 am

firlandsfarm wrote:
Sat Jan 18, 2025 10:47 am
sionascaig wrote:
Sat Jan 18, 2025 10:27 am

edit - although looking at your data issue more closely - looks like something else is going on !
Thanks sionascaig, that was food for thought and caused me to try a more simple solution first. I gave the following instruction "run LaLigaTemplate using only English characters in your response" and it did ... problem solved. :D
Nice... I like simple )
User avatar
jimibt
Posts: 4163
Joined: Mon Nov 30, 2015 6:42 pm
Location: Narnia

firlandsfarm wrote:
Tue Jan 14, 2025 9:23 am
I recently found this video on YouTube ... for me it was a real eye-opener. Has anyone tried using AI to draft their prompts and/or come across other imaginative uses?
this is brilliant. i have my own approach to prompts but this literally takes you down a path where the required output is tailored to exactly what you want. love it...
sionascaig
Posts: 1520
Joined: Fri Nov 20, 2015 9:38 am

jimibt wrote:
Sat Jan 18, 2025 11:11 am
firlandsfarm wrote:
Tue Jan 14, 2025 9:23 am
I recently found this video on YouTube ... for me it was a real eye-opener. Has anyone tried using AI to draft their prompts and/or come across other imaginative uses?
this is brilliant. i have my own approach to prompts but this literally takes you down a path where the required output is tailored to exactly what you want. love it...
Yup, nice find firlandsfarms...

Thanks for sharing..
User avatar
firlandsfarm
Posts: 3214
Joined: Sat May 03, 2014 8:20 am

I'm only just getting into ChatGPT (version 4o) so consider myself a newbie and am probably asking a newbie question! Is there a form of limit on what you can ask it to do, not by complexity but volume of work to perform a task?

I'm asking it to gather/report some data on the day's matches in the top European football leagues (EPL, Championship, LaLiga, Bundesliga 1, Serie A and Ligue 1) but it seems to be having difficulty identifying today's matches and even after I have cajoled it into find the matches it seems reluctant to pass my data collection template over all the matches (23 according to BA/Bf) sometimes only reporting on 3 or 4 matches and when I point out there are many matches missing it agrees and happily returns a table for all matches. It's as if it is a lazy worker that needs constant monitoring!

Is this behaviour to be expected or am I missing something fundamental.

edit: yes I've asked it the best way to ask itself but it's still lazy!
User avatar
firlandsfarm
Posts: 3214
Joined: Sat May 03, 2014 8:20 am

Yes, I'm like a kid with a new toy! :lol: But I thought I would ask ChatGPT where is forecast to be the warmest place in Europe next week (it interpreted that as being tomorrow x 7 days). It predicted Gran Canaria at 72F - 75F and maybe 81F on Friday. Sounds good so I than asked it if I could get a flight from Gatwick tomorrow and it responded with £53 return Easyjet. I confess to not having tested the flight as this was just an exploratory game but if it's correct what a wonderful way to find some winter sun. :D
User avatar
wearthefoxhat
Posts: 3415
Joined: Sun Feb 18, 2018 9:55 am

firlandsfarm wrote:
Sun Jan 19, 2025 12:08 pm
I'm only just getting into ChatGPT (version 4o) so consider myself a newbie and am probably asking a newbie question! Is there a form of limit on what you can ask it to do, not by complexity but volume of work to perform a task?

I'm asking it to gather/report some data on the day's matches in the top European football leagues (EPL, Championship, LaLiga, Bundesliga 1, Serie A and Ligue 1) but it seems to be having difficulty identifying today's matches and even after I have cajoled it into find the matches it seems reluctant to pass my data collection template over all the matches (23 according to BA/Bf) sometimes only reporting on 3 or 4 matches and when I point out there are many matches missing it agrees and happily returns a table for all matches. It's as if it is a lazy worker that needs constant monitoring!

Is this behaviour to be expected or am I missing something fundamental.

edit: yes I've asked it the best way to ask itself but it's still lazy!
:lol:

GPT has transformed the way I tackle a task. I find it works best on the framework of an idea, ie: Excel Conditions, Formulae, Ratings, Maths. It's also good at comparing your approach with some other existing method and suggest improvements.

It does sometimes throw a wobble, but that's usually cos I may have described my request a little ambiguously.

If I remember correctly, the original GPT model didn't have access to the last 2 years news information, (by creators choice), that might have changed with the newer version.(I'll ask it sometime)
Post Reply

Return to “General discussion”