Sériations et traitements de données archéologiques avec le logiciel Microsoft Excel sur Macintosh (ou compatible IBM)

Pascal Ruby

«Archeologia e Calcolatori» 1993, 4, 81-111

Abstract

The article describes the transformation of a number of procedures for archaeological data processing into Excel (Macintosh and MS Dos versions) macro-programming language. Automatic seriation is dealt with first. The general principles of the two best known algorithms - the reciprocal averaging method and P. Ihm’s correspondence analysis - are discussed. The Excel programme text is then presented and commented. After detailed analysis of the comparative merits of the two algorithms, a number of general remarks of a methodological nature are made about problems posed by seriation and particularly by automatic seriation techniques. The article then turns to the construction of incidence (presence/absence) tables and co-occurrence matrices. Here again, general principles are discussed before presentation of the programme text and comments on the macro. The last macro presented carries out replacements of cell contents. The conclusion contains some general methodological remarks about Excel and the writing of macro-programmes in Excel’s macro-programming language.

Figures

View figures in Interactive Atlas of Digital Images