• 1 Post
  • 146 Comments
Joined 1 year ago
cake
Cake day: July 8th, 2023

help-circle




  • Excel is never ever going to break backwards compatability. In fact, quite some “features” in Excel are just there to stay bug-for-bug compatible with existing systems.

    Example: Excel stores dates internally as a float - called the serial date, you can view it by running DATEVALUE on any cell that contains a date. It is supposed to be the number of days since 1 January 1900. However, since early Excel versions had to be compatible with Lotus1-2-3, Excel had to be compatible with a bug in Lotus123: they had erroneously assumed 1900 to be a leap year. In addition, the indexing is off by one. So the actual 0 epoch of an Excel serial date is 30 December 1899 for all dates starting 1 March 1900.






  • Chatgpt flat out hallucinates quite frequently in my experience. It never says “I don’t know / that is impossible / no one knows” to queries that simply don’t have an answer. Instead, it opts to give a plausible-sounding but completely made-up answer.

    A good AI system wouldn’t do this. It would be honest, and give no results when the information simply doesn’t exist. However, that is quite hard to do for LLMs as they are essentially glorified next-word predictors. The cost metric isn’t on accuracy of information, it’s on plausible-sounding conversation.