## How to Assign Work Using Evolutionary Engine?

Previously, I have made a brief introduction on the Evolutionary engine when discussing GRG engine. Today, I’d like to show you how to use Evolutionary Engine to solve a problem in real life. 1....

Previously, I have made a brief introduction on the Evolutionary engine when discussing GRG engine. Today, I’d like to show you how to use Evolutionary Engine to solve a problem in real life. 1....

Previously I have written an article on how to rate sports team using GRG Nonlinear engine, today I’d like to continue to discuss GRG Nonlinear engine in more details. 1. Understand GRG Nonlinear Engine...

So, you mastered VBA (or not) and automated that extremely complicated operation that consumes all your time. Let’s call your invention SuperFunction. But what would you do if your boss tells you to do...

Ratings are numerical representations of competitive strength which is directly comparable. It is often applied directly to predict the game outcome between any two teams. The Sports rating systems have been around for almost...

Most of us need to determine the monthly payment or the amount of money to be saved for retirement over life. It is not easy to do such kind of calculations manually. Fortunately, Excel...

Companies need to know which projects should be undertaken in order to produce greatest NPV (net present value) when there are limited resources. Applying Excel Solver can help solve this kind of problem. To...

It is well known that companies not only manufacture products at different locations but also ship their products to the customer at different locations. Distribution managers need to allocate and ship merchandise in the...

I have written an article on how to determine the optimal product mix using Excel Solver. Today, I’d like to discuss how to schedule workforce with the same method. Schedule a workforce is also...

In many situations, we may want to find the best way to do something. For example, companies often need to determine the amount of each product that should be produced during a month to...

If you’re a regular follower of my blog, you know that I have started writing a series of articles on Excel Array Formula. In the first article, I have demonstrated what are arrays in...

If you know the result of a formula, but you are not sure which input value the formula needs to get that result, you can use the Goal Seek Command. Suppose that you want...

Today, I will talk about the basics of Array Formulas. Most Excel users find it one of the hardest topics to understand in Excel. There are several articles online already on this topic. Then...

We are all familiar with Cut/Copy and Paste commands. They’ve been around since the early days of word processing, and they are universal across almost every Windows application. By pressing “Ctrl-V” or clicking “Paste”,...

I have introduced you with how to do sensitivity analysis using data table in one of my previous posts – Sensitivity Analysis In Excel Using One or Two Variables Data Table. It is useful...

Today I’d like to introduce you to Excel’s OFFSET Function with 3 real life examples. At first, I will describe the formula syntax and then I’m going to talk about how the OFFSET function...