How to check whether a worksheet exists in your spreadsheet
Moving things like your data tables, calculations, and the user interface to separate sheets is often a good idea to not confuse your users and give spreadsheets a nice look. However, as you add more sheets, it can get hard to keep track and you might want to check...
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
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...
Extricating Business Logic From Your Development Lifecycle
The Emergence of the Modern FrameworkSoftware development is an expansive, self-propagating industry, wherein innovative technologies are perpetually driving the future and expansion – or, in some sense, the compression – of the software...