The spreadsheet below shows how a gravimetric mixture problem is composed.  A solution follows using the advanced spreadsheet features of Microsoft Excel.  Note that the simultaneous equations produced could easily be solved by hand.

David L. Zellmer
Chemistry 102
Spring 1998