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 ,
Other files: LiddleStephen.example.Econ.xls ,
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.