Saturday, October 14, 2023
Annular Eclipse - 14 Oct 2023
Friday, October 13, 2023
Excel and Big Decisions - 13 October 2023
Friday the Thirteenth is famous for its association with bad luck. That makes today a fitting day to explore the use of Excel in corporations.
In a recent report, mistakes in Excel programming caused major, embarassing errors in hiring doctors in the UK (reference at the end). The headline screams "Excel recruitment time bomb makes top trainee doctors 'unappointable'" and the sub-head explains that "Mangled mismatch of formats, macros, and VLOOKUP practice hits wannabe anesthetists". Although this particular failure is significant to those affected, there is a larger problem that affects us all. We start from two facts.One. Microsoft Excel spreadsheets are nearly impossible to debug, thus they contain numerous errors.
Two. Microsoft Excel spreadsheets are used to make key decisions in nearly all businesses and institutions.
When we combine these, it is easy to see that key decisions in business and institutions are made based on bad data. These include billion-dollar decisions as well as smaller decisions in hiring and promotion. I spent years building budget and planning spreadsheets on behalf of my boss, often working with another, more skilled Excel practitioner and budgetmaster (hi, Nick!). After many, many errors, we taught each other to put debug checks into our spreadsheets. Not only did we sum across the matrix, but we summed down the matrix and compared the results. As one example, we would build large matrices of spending or staffing numbers, and if the result of sum-across did not equal the result of sum-down, a cell in the sheet would turn red with a warning. We were careful to cut-and-paste links rather then values, so that if the original values changed, the links would update. (This cut-and-paste is a manual operation, so it was subject to errors, but we tried.) These sheets would be used to create plans for hiring of staff and interns for the coming year, a critical decision that could cause us to fail to me business objectives if the numbers were wrong. If our budget was too low, we might lack the staff necessary to do the work; if our budget were too high, we would overspend (and no one ever got Executive sympathy for overspending).
In this particular report (from The Register), some bad hiring decisions were made for doctors in the UK, but we all know that mergers and acquisitions are decided based on Excel calculations. M&A can be measured in billions of dollars.
To be fair, Excel, itself, is not the direct cause of the problem. Excel is merely doing what the programmers are telling it to do. Excel will happily sum 11 months of costs and report the sum to a reader expecting to see 12 months of costs. And so on. The fault is that Excel is not designed to allow programmers to detect and fix errors. Further, most of the "programmers" are business people, not trained computer programmers, and so they lack many of the programming disciplines required to produce reliable, usable code (Excel macros, in this case).
To fix this problem, Microsoft needs to add checking and debugging features to Excel and the Excel programming community needs to learn to use them. I do not expect this to happen any time soon.
https://www.theregister.com/2023/10/12/excel_anesthetist_recruitment_blunder/?td=rt-3a
Tuesday, October 03, 2023
Trials - 3 October 2023
Trials and court cases seem to be the mark of our times. Today is the start of Sam Bankman-Fried's trial for the FTX debacle and yesterday was the start of the penalties phase of Donald J. Trump's trial for real estate fraud in New York. Defendants along with Donald are Don, Jr., and Eric. No one has explained how Ivanka (or Jared) escaped, but they do not seem to be on the indictments.
I have long enjoyed a podcast called All the President's Lawyers with Ken White and Josh Barro. That podcast ended about a year ago and morphed into Serious Trouble, in part because Trump's legal problems had metastasized far beyond Trump himself.
It is a comment on our founding fathers that they assumed that actors on the political stage would have some sort of values and a sense of decency. Others have fractured that assumption, but Trump has blown it into dust. Teapot Dome, Watergate, and other scandals have rocked the United States, but none of them compare to the constant, flagrant scandals of Trump. The fact that some 40% of the US voting population cannot see his criminality, fraud, and deceipt is something that astounds me. In any other country, he would be forgotten (e.g., Boris Johnson) or gone (e.g., your favorite revolution). Somehow, Trump combines deceipt and fraud with deep white nationalism and misogyny, yet retaining his base of supporters. SMH.During these trying times (no apologies), the USA has depended on a trustworthy judicial system. I refer here specifically to courts and judges. Unfortunately, Trump and the Republicans have spent years - decades - installing incompetent, biased, and corrupt judges throughout the federal judicial system, enough of these such that the judicial system is losing its trustworthyness. If you have any doubts, look at Thomas and Alito on the US Supreme Court; if doubts remain, look at the rest of the recent appointments such as Kavanaugh and note that Roberts is no shining example of anything, himself.
My point is that democracy needs to be strengthened against attacks by political, financial, and judicial hacks.
Monday, September 11, 2023
How lost luggage led to living in the moment - 11 September 2023
Saturday, August 19, 2023
BC is Burning - 19 Aug 2023
Wednesday, August 16, 2023
Twitter shitter - 16 Aug 2023
Absent from Blogger for a while, a couple recent events have forced me back to record the progress of Twitter-X as it swirls ever downward.
Earlier this week, it was announced that Twitter-X had resisted federal supoena efforts to obtain information about Trump's tweets-xeets. This was evidently an effort by Elon Musk to protect TFG from Jack Smith's investigations.Also earlier this week, it was announced that the Twitter-X URL shortener (t.co or something similar) was injecting delays of 5 seconds when redirecting to sites that were not in Elon Musk's good graces, including newspapers that had reported unflatteringly about Elon. Shortly after this was documented and reported, the delay went away.
And just today, it was reported that a podcaster and professor at NYU, Scott Galloway, had been locked out of his Twitter-X account after he released a podcast unflattering to Elon Musk. Evidently Galloway said something about unsubstantiated (inflated) range quotes from Tesla.
The only conclusion is that Elon Musk is a thin-skinned adolescent-minded twerp.
Photo is of blackberries coming into ripeness.
https://gizmodo.com/scott-galloway-locked-out-twitter-musk-1850743635
Sunday, July 16, 2023
Wormholes, psychadelic drugs, and a dryer - 16 July 2023
Well, this looks interesting.
July 17 at 9am ET, a new web-only series by Steven Soderbergh called Command-Z premieres in which Michael Cera leads a team using a wormhole in a washing machine to alter the present by traveling back in time.
https://extension765.com/blogs/soderblog/command-z
Saturday, July 15, 2023
Is it time to unretire? - 15 July 2023
Now we find that the universe might be older than conventionally thought. Rather than 13.7 billion years of universal evolution, it may be as old as 26.7 billion years. Fortunately, the age is added to the early years of the universe (to allow galaxies to form).
https://phys.org/news/2023-07-age-universe-billion-years-previously.html
Thursday, July 13, 2023
Trouble in AI Land - 13 July 2023
Forgetting. As I understand the European data rules, one has the right to be forgotten. At first, this sounds odd. Although it can be abused, it makes sense when you think of it. If a mistaken or outrageous screed about you gets injected into the Internet, you should have the right to get it removed - to be forgotten. Now think about AI engines.
Similar to search engines, AI engines today will crawl the web looking for input materials. No single AI company can generate the vast amount of input data needed for AI training, so they pretty much are left with crawling the web. The information they find is incorporated into the training models and used in the "predictive" part when the AI model generates output. It is likely that somewhere in the depths of ChatGPT that there is a copy of Moby Dick, Shakespeare, and your master's thesis, all wrapped up in "the model" and existing as a latent copy of your work.Now, suppose you wish for your thesis to be forgotten, removed from the Internet, relegated to nothingness. You can get the data pulled from a search engine, but how does one get data pulled from an AI model? The developers do not know how information is incorporated into the model (whle they know in vague terms, "the algorithm", they cannot trace any particular data item into the model). I suppose they would have to retrain using the old input dataset but without your work, and that would be very expensive. Training is often the most expensive part of developing an AI model.
To emphasize this problem, there is already a lawsuit by someone who claims that their copyrighted material has been included in an AI model without their consent (ref. Sarah Silverman).
So the AI folks are in a pickle.
https://www.theregister.com/2023/07/13/ai_models_forgotten_data/?td=rt-3a
Sunday, June 25, 2023
Yevgeny Prigozhin turns away from Moscow - 25 June 2023
Ending his quest to take on Vladimir Putin, Yevgeny Prigozhin has ordered his Wagner Group to stop their advance on Moscow. Lukashenko of Belarus claims he has negotiated a peace between Prigozhin and Putin such that Prigozhin will go to Belarus and Putin will drop the charges of rebellion.
I am not involved in diplomacy, but I do not think this is the end. Putin will return to Moscow and restore his reign, but Prigozhin is not to be found. No one knows where he is and he has not commented on the (supposed) agreement. I have two predictions, one for Prigozhin and one for Putin.For Prigozhin, I predict a defenestration. Wherever he shows up, it will be at the foot of a tall building with many windows. It may have happened already or it may happen six months from now, but he will show up dead or show up not at all. Putin will express regrets.
For Putin, I predict replacement. He has been shown as weak and cowardly (fleeing to one's hideout is not a signal of bravery). One way or the other, Putin will be deposed, probably by the end of 2023. Some new gangster will take his place, and although I cannot guess who it will be, it will not be Prigozhin.
Time will tell. The situation is changing rapidly and reports are squirrelly.
Saturday, June 24, 2023
Prigozin's Wagner Division invades Russia - 24 June 2023
Noting the event, the mercenary Wagner Group has left Ukraine to invade Russia. A column is moving toward Moscow. Putin has fled to his stronghold. Senior government ministers are leaving (one has flown to Turkiye). The Wagner groups in Venezula and Syria are unstable and may be leaving soon for Russia, leaving al-Assad and other dictators with reduced support.
It seems unlikely that Prigozin will unseat Putin, however one of them will not survive this. Furthermore, it is predicted that this is only the first wave and that Putin will succumb to a second, third, or fourth wave.
Ukraine seems happy.
Just putting this post here as an historical marker so that we can remember how it started. Or should I say, how it ended?
Friday, June 23, 2023
US Supreme Court faces a legacy of self-redemption or of corruption - 23 June 2023
SCOTUS, the Supreme Court Of The United States, has faced some recent tests. No, I am not referring to the infamous confirmation shows for the last 2-3 justices, but rather to the recent relevations about Clarence Thomas and Sam Alito.
Clarence Thomas had rambunctious hearings when he was nominated. Anita Hill came forward with shocking allegations that would have derailed any other nominee, but Clarence Thomas cruised on to confirmation. I do not remember Sam Alito's confirmation hearings, but I suspect he was better coached and trained such that the hearings went more smoothly. The most recent three, Amy Coney Barrett, Neil M. Gorsuch, and Brett M. Kavanaugh, were a sorry bunch, both through their own antics and with contributions from Senator Mitch McConnell as supported by the Republican members of the Senate. These are old news.
In the last month or so, journalists have uncovered allegations (being formal here - just allegations) that Thomas has accepted hundreds of thousands of dollars of "gifts" from a Republican billionaire named (ironicaly) Crow. Crow took Thomas and his wife on all-expenses-paid junkets around the world and bought the birthplace home of Thomas - and gave Thomas' mother free rent to live there. Is this bad? Yes, but Thomas failed to report these gifts even though he is required by law to report such gifts. More recently, he was given a window to restate and refile his attestation paperwork, and he has blown through the deadline.
While Thomas is redoing his paperwork, journalists have uncovered similar allegations (being formal here - just allegations) that Alito has accepted thousands and thousands of dollars of gifts, including an infamous salmon fishing trip to Alaska, none of which he reported as required. Alito claims some wordplay that exempts him from reporting requirements, claiming an trip in a private jet is some sort of infrastructure? It is hard to explain his position because it is stupid.
Both Alito and Thomas offer explanations that the law is complex. If true, then they are not qualified for their current positions and honorable people would resign. If we assume that they are smart enough on the law to hold their jobs as the ultimate arbiters of the law in the US, that SCOTUS gig, then they are disengenuous and honorable people would resign, again. It is quite clear that honor, impartiality, and the appearance of impartiality mean more about theatrics than actual compliance to Alito and Thomas. Even if the allegations of corruption are merely appearances and not actual corruption, these two men have failed.
Chief Justice John Roberts, Jr., has a choice: he can redeem SCOTUS, impose ethics standards, and evict Alito and Thomas based on severe ethical lapses, or the Chief Justice can continue to oversee and overlook corruption on SCOTUS. It strikes me that this is not a difficult choice, but the fact that Roberts continues to dither suggests that he is willing to tolerate severe ethical failures, making him a co-conspirator of the failings.
God Save SCOTUS,
Thursday, June 22, 2023
Deeper and Deeper into Stupidity - 22 June 2023
According to press reports, Musk and Zuck have agreed to a fight. Yep, you read that right - the headline reads
Mark Zuckerberg Says He's Down to Fight Elon Musk in a Cage Match
reference - https://gizmodo.com/elon-musk-mark-zuckerberg-twitter-meta-cage-match-fight-1850563649
It is hard for me to believe that these two guys could get more stupid. They are trolling at Trumpian levels of stupidity. I hope they do not hurt each other, but I hope they learn serious lessons. Let me correct that: I hope the viewers of this debacle learn serious lessons. Musk and Zuck are beyond learning.
#birdbrains
Saturday, June 03, 2023
ChatGPT AI replacing workers - 2June 2023
Thursday, May 25, 2023
I am not even remotely sympathetic - 25 May 2023
Sunday, May 21, 2023
Smoke has passed - 21 May 2023
Trouble, right here in River City - 21 May 2023
Tuesday, May 09, 2023
Travel to the Following States is Restricted - 9 May 2023
Today, Louisiana achieves Do Not Travel status with the shooting of a small girl who was playing hide-and-seek, straying into the neighbor's yard. The neighbor promptly shot her. Fortunately, she survived, but rampant firearms are not a joke.
I will not travel to or spend money in Texas, Florida, or Louisana until the state leaders demonstrate that they value life.
Cat photo for soothing purposes.
https://people.com/crime/louisiana-homeowner-accused-shooting-14-year-old-girl-in-the-back-of-head/
Wednesday, March 22, 2023
Amazon.com Hiring and Recent Revelations - 22 March 2023
According to news reports, internal documents obtained from Amazon show that they hired too many people. Not as in "planned hiring was too high" but rather "unapproved hiring was too high". From the article:
Amazon Web Services posted 24,988 job openings in 2022, but the department was only approved to recruit for 7,798 positions. The document addresses Amazon’s lack of governance as an issue that led to the disconnect between job listings and open positions.
When I worked at Amazon (circa 2000), this was generally true: there were few, if any, business controls in place. I did not see it at the time (having been raised in corporations that routinely imposed controls and audits for budgets, hiring, travel, and the like), so I did not exploit it, but it was obvious even then that there were really no controls. I have always been astounded at the success of Amazon given the internal workings of the company. On the other hand, recent examples like Credit Suisse and Silicon Valley Bank make me wonder if it is more a case of all-companies-all-the-time.
Source: https://gizmodo.com/amazon-layoffs-andy-jassy-amazon-web-services-aws-1850251481
Another clip from the article:
After Amazon announced another round of layoffs affecting 9,000 employees earlier this week, a leaked document from inside the company revealed that listing too many job openings and subsequently over-hiring in some departments may have been a part of the problem.
A leaked document obtained by Insider reveals that Amazon put hiring power in the hands of managers, and that the company had little oversight on the hiring process until 2022. This apparently led managers to recruit and hire more employees than they were approved to.
Tuesday, March 21, 2023
New Application of AI Technology - 21 March 2023
Applying AI technology to analyze banks and prevent blow-outs would be a useful application of Silicon Valley technology. I wonder why the wizards of Silicon Valley overlooked this self-protective opportunity.