Analysis of tracer tests with simple spreadsheet models

Akin S.

COMPUTERS & GEOSCIENCES, vol.27, no.2, pp.171-178, 2001 (SCI-Expanded) identifier identifier

  • Publication Type: Article / Article
  • Volume: 27 Issue: 2
  • Publication Date: 2001
  • Doi Number: 10.1016/s0098-3004(00)00084-4
  • Journal Indexes: Science Citation Index Expanded (SCI-EXPANDED), Scopus
  • Page Numbers: pp.171-178
  • Keywords: tracer, spreadsheet, computer model, non-linear optimization, fracture
  • Middle East Technical University Affiliated: Yes


Interpretations of tracer tests involve matching field data by the use of computer simulation programs. As the complexity of the simulator model increases, the number of trial runs needed to fit field data satisfactorily increases rapidly. The conventional fitting procedure can thus become cumbersome and can involve prohibitive computer costs. This study presents a new methodology that is devised to model tests in heterogeneous formations. These rigorous simulators written in high-level computer languages are replaced by simple response functions generated in spreadsheet software. Matching the tracer data now involves function evaluations rather than full simulator runs, resulting in a large reduction in computing time. Analyzing laboratory tracer tests shows the uses of spreadsheet models. Advantages and disadvantages of the technique are discussed. (C) 2001 Elsevier Science Ltd. All rights reserved.