Excel Ran Out of Resources: Troubleshooting

Have you ever experienced the frustration of working on a large Excel spreadsheet, only to have Excel crash and display the message “Excel ran out of resources”? This message can be caused by several factors, and it can be a real pain to figure out which one is the culprit. In this post, we’ll provide you with a list of possible causes, explain how to check if those causes are the problem, and share some best practices to prevent this annoying issue.

excel ran out of resources
Continue reading “Excel Ran Out of Resources: Troubleshooting”

The 6 W’s explained: who, what, when, where, why and how

The Six W’s is a technique used in continuous improvement projects (posts about six sigma) to gather essential information and improve problem-solving capabilities. This approach is rooted in the principles of journalism and is commonly used in project management and marketing to gather information.

In this blog post, we’ll take a closer look at the Six W’s, explain the theory behind this technique, discuss each of the six questions, give examples of each, and provide an example of use in the context of continuous improvement work.

six W's
Continue reading “The 6 W’s explained: who, what, when, where, why and how”

What is mathematical programming

Mathematical programming is a field of mathematics that deals with the optimization of complex systems and processes. It has a rich history that dates back to the 1940s when George Dantzig, an American mathematician, developed the simplex method for solving linear programming problems. Since then, it has grown into a vast and dynamic discipline that has found applications in various fields such as finance, transportation, engineering, and operations research.

In this blog post, I will explore the origins of mathematical programming, provide an example of a problem that can be tackled and list some classical problems. I will also discuss some of the software products used in mathematical programming, both open-source and commercial.

mathematical programming
Continue reading “What is mathematical programming”

The shortest superstring problem

I was introduced to the shortest superstring problem by a request I got on Fiverr. The request turned out to be a waste of time but I really enjoyed learning about it.

Problem statement

The shortest common superstring problem aims to find a string with a minimal length that contains every string in a given set.

shortest superstring problem
Continue reading “The shortest superstring problem”

College Basketball Rankings using Neural Networks

Now, in addition to the College Football Rankings that I publish here and I introduced and explained in an earlier post, I moved from a site I dropped (Sportheory.com) into this site a ranking of College Basketball teams calculated with a neural network.

College Basketball Rankings Neural Networks
A beautiful network
Continue reading “College Basketball Rankings using Neural Networks”