Analyzing Common Mass Balance Problems Using Spreadsheet Tools

The determination of mass balances is the first step in analyzing the performance of processing circuits. Although conceptually very simple, the mathematics associated with mass balances can be cumbersome when conflicting data sets and/or complex circuits are evaluated. Fortunately, many of the spreadsheet programs available today include powerful search routines which can be adapted to solve common mass balance problems. To demonstrate these capabilities, a generalized mass balance program has been developed using the Microsoft Excel? spreadsheet. Compared to commercial programs, the spreadsheet format is user-friendly, more versatile and easier to customize. This paper reviews the mass balance problem and describes how spreadsheet tools can be used to reconcile conflicting data.