Stephen W. Liddle



Liddle, Stephen W. and Lawson, John S. (2003), Implementing Legacy Statistical Algorithms in a Spreadsheet Environment, Computing Science and Statistics, 35, I2003Proceedings/LiddleStephen/LiddleStephen.paper.pdf

Liddle, Stephen W. and Lawson, John S. (2003), Implementing Legacy Statistical Algorithms in a Spreadsheet Environment, Computing Science and Statistics, 35, I2003Proceedings/LiddleStephen/LiddleStephen.presentation.pdf ,
I2003Proceedings/LiddleStephen/LiddleStephen.presentation.ppt


Other files: LiddleStephen.example.Econ.xls ,
LiddleStephen.example.ORPS.xls



Implementing Legacy Statistical Algorithms in a Spreadsheet Environment
Stephen W. Liddle, (Brigham Young University), liddle@byu.edu, and
John S. Lawson, (Brigham Young University), lawson@byu.edu

Abstract

Over the years creative researchers in the field of statistics have published many useful and freely available FORTRAN programs implementing novel statistical computations. But it is becoming less common to find a FORTRAN compiler installed on the average workstation, making this prior work less accessible to the masses who rely on personal computers running Windows. We propose a methodology for converting legacy FORTRAN algorithms to run as VBA macros in the Excel environment. Using our approach, moderately literate programmers can effectively migrate legacy algorithms to the ubiquitous Excel spreadsheet tool, where users will again have ready access to past algorithm contributions.


Take me back to the main proceedings page.