Microsoft Excel is a great Office application from Microsoft and it does not need any introduction. It helps every one of us, in many ways by making our tasks simpler. In this post we will see how to ...

前回までの記事で解説した最適化手法について、Excelのソルバーを使って実践的に最適化問題を解いていきます。 ※この記事はシリーズになっておりますので、初めての方は下の記事をご覧ください。 解析ツールの位置付け 前回までの記事で、最適化手法 ...

Excelに標準搭載されているデータタブのソルバーを使えば、数理最適化問題を簡単に解くことができます。数理最適化とは、与えられた条件の中で「最も良い解」を数学的に探す方法です。目的と制約条件を数式化し、その中で最適な答えを導き出します。

The Solver add-in for Microsoft Excel is one of the most important, so we can understand the frustrations when users cannot get it to work as they hope. In older versions of Excel, folks had to ...

Stratified mean-per-unit sampling is a key tool used by auditors. The popularity of this statistical procedure arises from its unique ability to produce trustworthy ...

A popular add-on for helping Excel users creating optimization models has made its return to Excel 2008. Solver for Excel had been among the casualties of Microsoft’s decision to drop Visual Basic for ...