Power Formula Auditing: The Power Tool for every Excel User

Proceedings of the Warm Up Workshop for ACM/IEEE ICSE 2010
.
ACM, 2009.
Baker, John, and Stephen J. Sugden. "Spreadsheets in education–The first 25
years." 
Spreadsheets in Education (eJSiE)
1.1 (2007): 2.
Bewig, Philip L. "How do you know your spreadsheet is right?." 
arXiv
preprint arXiv:1301.5878
(2013).
Bishop, Brian, and Kevin McDaid. "An empirical study of end-user behaviour
in spreadsheet error detection & correction." 
arXiv preprint arXiv:0802.3479
(2008).
Chan, H. C., C. Ying, and C. B. Peh. "Strategies and visualization tools for
enhancing user auditing of spreadsheet models." 
Information and Software
Technology
42.15 (2000): 1037-1043.
Chan, Hock Chuan. "Spreadsheet visualization effects on error correction."
SIGHCI 2004 Proceedings (2004): 1.
Chan, Hock Chuan, Suparna Goswami, and Hee-Woong Kim. "An alternative
fit through problem representation in cognitive fit theory." Journal of Database
Management (JDM) 23.2 (2012): 22-43.
Clermont, Markus. A scalable approach to spreadsheet visualization. na, 2003.
Davis, J. Steve. "Tools for spreadsheet auditing." 
International Journal of
Human-Computer Studies
45.4 (1996): 429-442.
Galletta, Dennis F., et al. "Spreadsheet presentation and error detection: an
experimental study." 
Journal of Management Information Systems
13.3
(1996): 45-63.
Goswami, Suparna, Hock Chuan Chan, and Hee Woong Kim. "The role of
visualization tools in spreadsheet error correction from a cognitive fit
perspective." 
Journal of the Association for Information Systems
9.6 (2008):
321.

---

Hendry, David G., and Thomas RG Green. "Creating, comprehending and
explaining spreadsheets: a cognitive interpretation of what discretionary users
think of the spreadsheet model." 
International Journal of Human-Computer
Studies
40.6 (1994): 1033-1065.
Hermans, Felienne, Martin Pinzger, and Arie Van Deursen. "Supporting
professional spreadsheet users by generating leveled dataflow diagrams."
Proceedings of the 33rd International Conference on Software Engineering
.
ACM, 2011.
Igarashi, Takeo, et al. "Fluid visualization of spreadsheet structures." 
Visual
Languages, 1998. Proceedings. 1998 IEEE Symposium on
. IEEE, 1998.
Jannach, Dietmar, et al. "Avoiding, finding and fixing spreadsheet errors–a
survey of automated approaches for spreadsheet QA." 
Journal of Systems and
Software
94 (2014): 129-150.
Leitão, Roxanne, and Chris Roast. "Developing visualisations for spreadsheet
formulae: towards increasing the accessibility of science, technology,
engineering and maths subjects."
McKeever, Ruth, and Kevin McDaid. "How do range names hinder novice
spreadsheet debugging performance?."arXiv preprint arXiv:1009.2765 (2010).
Middleton, M. "Decision Modeling using EXCEL." 
University of San
Francisco
(2003).
Mittermeir, Roland, and Markus Clermont. "Finding high-level structures in
spreadsheet programs." 
Reverse Engineering, 2002. Proceedings
. Ninth
Working Conference on. IEEE, 2002.
O'Donnell, Peter. "The Use of Influence Diagrams in the Design of Spreadsheet
Models: an experimental study." 
Australasian Journal of Information
Systems.
9.1 (2001).
Panko, Raymond R., and Ralph H. Sprague. "Hitting the wall: errors in
developing and code inspecting a simple spreadsheet model." 
Decision
Support Systems
22.4 (1998): 337-353.
Panko, Raymond R., and Richard P. Halverson Jr. "An experiment in

---

collaborative spreadsheet development." 
Journal of the Association for
Information Systems
2.1 (2001): 4.
Plane, Donald R. Management science: A spreadsheet approach for Windows.
Course Technology Press, 1995.
Powell, Stephen G., Kenneth R. Baker, and Barry Lawson. "An auditing
protocol for spreadsheet models." 
Information & Management
45.5 (2008):
312-320.
Roy, Sohon, and Felienne Hermans. "Dependence tracing techniques for
spreadsheets: an investigation." 
Software Engineering Methods in
Spreadsheets
(2014): 1-4.
Saariluoma, Pertti, and Jorma Sajaniemi. "Transforming verbal descriptions
into mathematical formulas in spreadsheet calculation." 
International Journal
of Human-Computer Studies
41.6 (1994): 915-948.
Shiozawa, Hidekazu, Ken-ichi Okada, and Yutaka Matsushita. "3d interactive
visualization for inter-cell dependencies of spreadsheets." 
Information
Visualization, 1999.(Info Vis' 99) Proceedings
. 1999 IEEE Symposium on.
IEEE, 1999.
Simkin, Mark G. "How to validate spreadsheets." 
Journal of Accountancy
164.5 (1987): 130.
Teo, Thompson SH, and Margaret Tan. "Spreadsheet development and ‘what-
if’analysis: quantitative versus qualitative errors." 
Accounting, Management
and Information Technologies
9.3 (1999): 141-160.
Teo, Thompson SH, and Joo Eng Lee-Partridge. "Effects of error factors and
prior incremental practice on spreadsheet error detection: an experimental
study." 
Omega
29.5 (2001): 445-456.
Wetzel, Laura R., and Peter J. Whicker. "Quick Correct: A method to
automatically evaluate student work in MS Excel spreadsheets." 
Spreadsheets
in Education (eJSiE)
2.3 (2007): 1.

---

Appendix A. How to add Power Formula Auditing to
Excel?
There are many “add-ins” software or applications. Excel has very detailed
guides on how to add in an “add-ins” application. Power Formula Auditing is
an “add-ins” application.
The steps are as follow:
·
Download the Power Formula Auditing add-in software
(
PowerFormulaAudit_1.0.xlam
) into any directory in your computer.
·
Add the software with the following steps:
o
Click the