Turning Excel Hell into Excel Heaven

Turning Excel Hell into Excel Heaven

Many Excel projects start with a small assignment to solve a simple problem. The individual tasked to solve the problem puts together an Excel workbook. As its usage expands, it is distributed to more and more individuals in the company. As more individuals utilize...

Implementing Goal Seek with SpreadsheetWEB

What is Goal Seek? In numerical analysis, goal seek constitutes a question: under a given set of criteria, what degree of change is required to achieve a convergence between the actual and a theoretical result? It can be understood as a tool for determining the cause...
Decoupling Business Logic with Excel-based Microservices

Decoupling Business Logic with Excel-based Microservices

Most applications, albeit web-based or otherwise, incorporate some resemblance of business logic – “the part of the program that encodes the real-world business rules that determine how data can be created, displayed, stored, and changed.”[1] Not only do these rules...