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.

Meeting Name

IEEE 6th International Conference on Intelligent Data Acquisition and Advanced Computing Systems, IDAACS 2011 (2011: Sep. 15-17, Prague, Czech Republic)


Computer Science

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)


Document Type

Article - Conference proceedings

Document Version


File Type





© 2011 Institute of Electrical and Electronics Engineers (IEEE), All rights reserved.

Publication Date

01 Sep 2011