Universal Asset Assessment System Based on Excel
At the 2009 IEEE International Conference on Technologies for Homeland Security the author presented a paper entitled "Comparing Apples to Oranges" which showed the fundamental problem of ranking assets on multiple-factors. In particular, the talk showed that programs like Carver2 cannot consistently order targets. In particular, the author contends that using a spreadsheet such as Excel™ permits users to do as good a job of assessing targets more dedicated systems. To improve the usefulness of Excel™ for target selection, the author has written a module that permits the spreadsheet to identify Condorcet cycles so that users will get a more realistic understanding of the vulnerability of their various assets. This paper describes the theoretical basis for this module and illustrates its operation. This module is available from the author.
G. Markowsky, "Universal Asset Assessment System Based on Excel," Proceedings of the IEEE 6th International Conference on Intelligent Data Acquisition and Advanced Computing Systems (IDAACS) (2011, Prague, Czech Republic), vol. 2, pp. 747-752, Institute of Electrical and Electronics Engineers (IEEE), Sep 2011.
The definitive version is available at https://doi.org/10.1109/IDAACS.2011.6072870
IEEE 6th International Conference on Intelligent Data Acquisition and Advanced Computing Systems, IDAACS 2011 (2011: Sep. 15-17, Prague, Czech Republic)
Keywords and Phrases
component; Condorcet cycles; consistent decisions; Multiple factors; target selection; Data acquisition; Fruits; Spreadsheets; Risk assessment; target ranking
International Standard Book Number (ISBN)
Article - Conference proceedings
© 2011 Institute of Electrical and Electronics Engineers (IEEE), All rights reserved.
01 Sep 2011