Skip to main content
ARS Home » Southeast Area » Fort Pierce, Florida » U.S. Horticultural Research Laboratory » Subtropical Insects and Horticulture Research » Research » Software

headline bar

ARS-Media for Excel

An ion solution calculator that uses Excel's linear programming optimization add-in Solver.

ARS-Media utilizes Excel’s internal linear programming optimization algorithm to determine the combination of salts, acids, and bases that satisfy any given target solution of ions.  The spreadsheet is designed for the formulation of nutrient media used in such applications as plant tissue culture, hydroponics, algal culture, fertilizer formulations, microbial culture, and any application that requires the definition of a specific culture media by its ion composition.  The spreadsheet is formula-based and uses no macros that can sometimes conflict with institutional IT security systems.