This sure looked like a great list of potential SQL Smells could be derived from this list.

Here is the macro I use in my personal.xlsb that eliminates the errors I get when pasting data from SSMS:

Sub SelectAllFormatAsText()

'

' SelectAllFormatAsText Macro

'

'

Cells.Select

Selection.NumberFormat = "@"

Range("A1").Select

End Sub

If you make the sheet text only it doesn't

I think what Excel is poor on is documenting the way they process the data.

Looks like a zoom password

If you can send me a file I'll give it a whirl on how I would process it.  robert@sterbal.com

As far as I know Excel uses the same logic for converting typed, pasted and imported text. If you select a sheet can switch it all to text, everything is...

It takes less than 10 keystrokes to convert a column to text. (Ctrl + space, alt + 1, alt + C, t, t enter)

I'm getting the impression that you think...

In nearly 30 years of using excel there are very few situations that don't have a straight forward work around.

I too was surprised that this piece was about BMW and not Tesla

Just curious how many of us use case insensitive fields?

Just a note that I've been using a wiki as a notebook of sorts for 6+ years. It is a nice alternative for documentation that is more than just code.

My favorite link about weight loss:

Probability of an Obese Person Attaining Normal Body Weight: Cohort Study Using Electronic Health Records

http://ajph.aphapublications.org/doi/pdf/10.2105/AJPH.2015.302773

How often are you interrupted? Is there a pattern?

Thank you. Excellent advice.

I think that would be a better way of phrasing it:

I'd like to know the decisions AI and ML are making for me.

I'd love to have AI go through my...