Chat GPT & Generative AI tools

[jimibt]

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.

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]

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.

[Euler]

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]

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 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.

[firlandsfarm]

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?

[firlandsfarm]

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]

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 !

[firlandsfarm]

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.

[sionascaig]

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.

Nice... I like simple )

[jimibt]

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]

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..

[firlandsfarm]

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!

[firlandsfarm]

Yes, I'm like a kid with a new toy! 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.

[wearthefoxhat]

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!

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)

[wearthefoxhat]

Update: Just checked.

Access.png