preadsh eet program s for person al com pu ters are u sefu l for storin g, retrievin g, graph in g, an d reportin g data an d for perform in g repetitiou s calcu lation s. Th ey can be u sed to au tom ate ch em ical equ ilibriu m calcu lation s th at can be perform ed by h an d, i.e., system s of equ ation s th at can be solved in closed form or with reason able sim plifyin g approxim ation s. Su ch problem s, h owever, are u su ally limited to a few u n kn own s. For exam ple, th e calcite satu ration in dex (SI cal ) in dicates th e ten den cy of water to precipitate or dissolve CaCO 3 . At pH valu es of m ost potable water sou rces, th e Langelier in dex 1 (LI) closely Lo tu s 1-2-3® w o rk sh e e ts fo r calcu latin g th e calcite satu ratio n in d e x (SI) an d calciu m carbo n ate p re cip itatio n p o te n tial o f a w ate r sam p le are d e scribe d . A sim p lifie d w o rk sh e e t illu strate s th e p rin cip le s o f th e m e th o d , an d a m o re co m p le x w o rk sh e e t su itable fo r m o d e lin g m o st p o table w ate r so u rce s is brie fly d e scribe d . Bo th w o rk sh e e ts in clu d e io n p airin g an d ad ju stm e n ts o f e qu ilibriu m co n stan ts fo r te m p e ratu re an d io n ic stre n gth . Fo r se ve ral te st case s w ith a w id e ran ge o f te m p e ratu re , alk alin ity, p H, an d calciu m co n ce n tratio n , th e w o rk sh e e t SI valu e s d iffe re d <1 p e rce n t fro m th o se co m p u te d by WATEQX. Fo r w ate r qu ality m o d e lin g, sp re ad sh e e ts h ave se ve ral ad van tage s co m p are d w ith large e qu ilibriu m co d e s: fle x ible in p u t an d o u tp u t, e ase o f m ain tain in g th e th e rm o d yn am ic d atabase , an d re lative ly sm all m e m o ry an d m ass-sto rage re qu ire m e n ts. Mo d e lin g o f arch ive d ch e m ical d ata is p o ssible th ro u gh th e co m bin atio n o f d atabase m an age m e n t an d co m p u tatio n al cap abilitie s o f m an y co m m e rcially available p ro gram s. Th e w o rk sh e e ts can be o btain e d fro m th e au th o rs.