Abstract: This invention relates to an automatable method to rapidly assess individual water purification needs, and the system that can quickly optimize the filtration formulation. In this method, information from multiple sources is merged to create a composite functional requirement for the filtration needs. With a priori knowledge of filtration characteristics of various solid phase extraction media, an optimized formulation can be identified that fixes the problems associated with the point of use.