ChatGPT: The Future of AI is Here!

[Jon]

Oooh - that's nice!

Like I said earlier, its a skill. Learn little bits here and there to improve the probability of getting some good output.

 

[Jon]

Yeah plenty of articles already written agreeing with that - unfortunately there is NO way to "completely" avoid bias, when a human being created the thing that supposedly creates things..

Or, the thing that spurts out text is actually an aggregation of enormous amounts of online data, put into a neural net where it then applies weights to certain word sequences. This is my laymans understanding of what is incredibly sophisticated software. What I'm trying to say is that it is less based on one persons opinion and more on millions of peoples word sequences.

 

[Jon]

I can see your issue regarding problems with essays and students. I just typed this in as a test: "write me an essay on free speech, from the perspective of a far left democrat"

It came back with this...

Free speech is a fundamental human right that is essential to the functioning of a democratic society. As a far left democrat, I believe that every individual has the right to express their thoughts and opinions without fear of reprisal or censorship. This right is guaranteed by the First Amendment to the United States Constitution, which states that "Congress shall make no law...abridging the freedom of speech."

However, free speech is not an absolute right. There are certain limits on free speech that are necessary to protect the rights and safety of others. For example, it is not okay to use free speech as an excuse to engage in hate speech or to incite violence. These forms of speech are harmful and can lead to serious consequences, including discrimination and physical harm.

As a far left democrat, I believe that it is important to strike a balance between protecting free speech and ensuring that it is not used to harm others. We must recognize that free speech is not just a right, but a responsibility. It is our duty to use our words and actions to promote justice, equality, and a better world for all. We must also be willing to listen to and engage with those who hold different views, as this is an essential part of the democratic process.

In conclusion, free speech is a fundamental human right that is essential to a democratic society. As a far left democrat, I believe that we must protect this right while also recognizing its limitations and our responsibility to use it in a way that promotes justice and equality for all.

There, did my homework in 10 seconds!

 

[Isaac]

Check this out:

what evidence is there that president biden is cognitively disabled


There is no evidence that President Biden is cognitively disabled. This claim is unfounded and without merit. President Biden has been a successful politician for over four decades, and there is no evidence to suggest that he is cognitively impaired in any way. In fact, during the 2020 presidential campaign, President Biden underwent a comprehensive cognitive assessment, which showed that he is in good cognitive health.

(Oh so ridiculous - despite the fact that every day, 3 times a day, the President struggles to speak or says something absolutely ridiculous, like forgetting where he is or thinking a dead person is in the audience or forgetting what country is at war with Ukraine).

OMG...I just lost a lot of respect for the AI. I thought at least it would admit the presidents near-daily extreme gaffes that only a person with memory or cognitive problems would make - but nay, no such honesty

 

[Jon]

Looks like there is an element of sanitising the answers.

 

[Jon]

OMG...I just lost a lot of respect for the AI. I thought at least it would admit the presidents near-daily extreme gaffes that only a person with memory or cognitive problems would make - but nay, no such honesty

Remember that it is taking what others say and using probability to construct word sequences, as I understand it. So, if you have a lot of people saying he is not cognitively disabled (Democrats), it may elect to use those. I also feel that they have "safe-spaced" it somewhat, especially after the criticism that Microsoft got for some chatbot that was saying racist stuff! See my post above where they have taken a moral stance about speculating on physical abilities.

 

[AccessBlaster]

I wonder if you could write a procedure in VBA based on questions you asked the AI

 

[Jon]

I wonder if you could write a procedure in VBA based on questions you asked the AI

You can. Maybe the experts here can tell me if the code below will work or not.

 

[Isaac]

Yikes - that procedure is terrible and the only line that would 'execute' is the Dim line! afaik

 

[Isaac]

Remember that it is taking what others say and using probability to construct word sequences, as I understand it. So, if you have a lot of people saying he is not cognitively disabled (Democrats), it may elect to use those. I also feel that they have "safe-spaced" it somewhat, especially after the criticism that Microsoft got for some chatbot that was saying racist stuff! See my post above where they have taken a moral stance about speculating on physical abilities.

True. It just came back so hard and hyperbolic, like when you ask someone a question they HATE getting and they come back to you with a defensive hammer.

 

[AccessBlaster]

How long before they get Alexa to integrate with this AI?

Alexa "build me a table with VBA, this time normalize it please"

 

[Jon]

How long before they get Alexa to integrate with this AI?

Alexa "build me a table with VBA, this time normalize it please"

I was thinking that it would be great integrated with Alexa! Let's face it, this is the future today. It will be coming and also way more powerful that it currently is. This is based on GPT3 which was created 2 years ago. GPT4 is just around the corner and is supposed to be a significant improvement on the current iteration. When they do ChatGPT(4), who knows what it will produce.

 

[Isaac]

I stand corrected, it's beyond awful , but does execute.

 

[Jon]

Yikes - that procedure is terrible and the only line that would 'execute' is the Dim line! afaik

I clicked the Tray again button and got this:

Sub ImportExcelFile()

Dim excelFile As String
Dim excelData As Variant

' Prompt user to select Excel file
excelFile = Application.GetOpenFilename("Excel Files (*.xlsx), *.xlsx")

' Import data from Excel file into array
excelData = Application.Transpose(Range("A1:Z" & Cells(Rows.Count, "A").End(xlUp).Row))

End Sub

 

[Isaac]

Sure hope it's better than the false hyteria about "5g"

- 5g coverage is amost nonexistent with my carrier
- turning on 5g overheats many phones
- 5g is far slower than my cabled internet but is deceptively advertised as if a replacement
- other industries are threatened by 5g

 

[Isaac]

I clicked the Tray again button and got this:

Sub ImportExcelFile()

Dim excelFile As String
Dim excelData As Variant

' Prompt user to select Excel file
excelFile = Application.GetOpenFilename("Excel Files (*.xlsx), *.xlsx")

' Import data from Excel file into array
excelData = Application.Transpose(Range("A1:Z" & Cells(Rows.Count, "A").End(xlUp).Row))

End Sub

Ahh, it learns!
Still awful but try it again and let's see if it gets better

 

[Jon]

Clicked it again and got this:

Sub ImportExcelData()

Dim excelData() As Variant

' Open the Excel file and get the active worksheet.
Dim wb As Workbook
Set wb = Workbooks.Open("C:\MyExcelFile.xlsx")
Dim ws As Worksheet
Set ws = wb.ActiveSheet

' Get the data from the worksheet and store it in the array.
excelData = ws.UsedRange.Value

' Close the Excel file.
wb.Close

End Sub

 

[Jon]

Another go. This time it gives good descriptions of each step.

Here is an example of a VBA procedure that imports an Excel spreadsheet file and stores it in an array called excelData:

Sub ImportExcelData()

'Declare variables for the file path, Excel application, and workbook objects
Dim filePath As String
Dim xlApp As Excel.Application
Dim xlWorkbook As Excel.Workbook

'Prompt the user to select the Excel file to import
filePath = Application.GetOpenFilename("Excel Files (*.xlsx), *.xlsx")

'Exit the procedure if the user did not select a file
If filePath = "False" Then Exit Sub

'Set the Excel application object
Set xlApp = New Excel.Application

'Set the Excel workbook object
Set xlWorkbook = xlApp.Workbooks.Open(filePath)

'Declare an array to store the Excel data
Dim excelData() As Variant

'Store the data from the first worksheet in the array
excelData = xlWorkbook.Worksheets(1).UsedRange.Value

'Close the Excel workbook and release the objects
xlWorkbook.Close
Set xlWorkbook = Nothing
xlApp.Quit
Set xlApp = Nothing

End Sub

This procedure uses the Excel object model to open the selected Excel file and extract the data from the first worksheet. It then stores the data in an array called excelData and releases the Excel objects to free up memory. I hope this helps. Let me know if you have any other questions.

 

[Jon]

I stand corrected, it's beyond awful , but does execute.

So it executed. But did it actually do anything or store anything?

 

[AccessBlaster]

Like any other tool, it's no good unless the user has a good understanding of how it should be.