id
	10393
Url
	https://chloe.cnr.it/s/BiDiAr/item/10393
Resource template
	Academic Article
Resource class
	bibo:AcademicArticle
Title
	Sériations et traitements de données archéologiques avec le logiciel Microsoft Excel sur Macintosh (ou compatible IBM)
Creator
	Ruby, Pascal
Date
	1993
Language
	fra
Rights
	https://creativecommons.org/licenses/by-nc-nd/4.0/deed.en CC BY-NC-ND 4.0
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.
Is Part Of
	https://chloe.cnr.it/s/BiDiAr/item/2002
Pages
	81-111
Uri
	http://www.archcalc.cnr.it/journal/id.php?id=52
Volume
	4
Homepage
	https://www.zotero.org/groups/5293298/bidiar/items/ANV7DMFV/item-list

--