references.bib

@inproceedings{Panko2008,
  author    = {R.R. Panko},
  title     = {Security and Sarbanes Oxley: What about the Spreadsheets?},
}


@inproceedings{DBLP:conf/icsm/Alalfi2012,
  author    = {Manar H. Alalfi and James R. Cordy and Thomas R. Dean and Matthew Stephan and Andrew Stevenson},
  title     = {Models are Code too: Near-miss Clone Detection for Simulink Models},
  booktitle = {Proc. of ICSM '12},
  year      = {2012},
  bibsource = {DBLP, http://dblp.uni-trier.de},
}



@inproceedings{Jansen2015,
  author    = {B. Jansen and F. Hermans},
  title     = {CODE SMELLS IN SPREADSHEET FORMULAS REVISITED ON AN INDUSTRIAL DATASET},
  note      = {to appear},
  booktitle = {Proceedings of the International Conference on Software Maintenance and Evolution (ICSME '15)},
  year = {2012}
}

@inproceedings{Hermans2015,
 author = {Hermans, Felienne and Murphy-Hill, Emerson},
 title = {Enron's Spreadsheets and Related Emails: A Dataset and Analysis},
 booktitle = {Proceedings of the 37th International Conference on Software Engineering - Volume 2},
 series = {ICSE '15},
 year = {2015},
 location = {Florence, Italy},
 pages = {7--16},
 numpages = {10},
 url = {http://dl.acm.org/citation.cfm?id=2819009.2819013},
 acmid = {2819013},
 publisher = {IEEE Press},
 address = {Piscataway, NJ, USA},
} 

@inproceedings{conf/msr/BarikLSSM15,
  added-at = {2015-09-14T00:00:00.000+0200},
  author = {Barik, Titus and Lubick, Kevin and Smith, Justin and Slankas, John and Murphy-Hill, Emerson R.},
  biburl = {http://www.bibsonomy.org/bibtex/25c0290964eddca7acb95700a5e82cf5f/dblp},
  booktitle = {MSR},
  crossref = {conf/msr/2015},
  ee = {http://dl.acm.org/citation.cfm?id=2820594},
  interhash = {15e4398ce56b7ea5d89f32213e12cc58},
  intrahash = {5c0290964eddca7acb95700a5e82cf5f},
  isbn = {978-0-7695-5594-2},
  keywords = {dblp},
  pages = {486-489},
  publisher = {IEEE},
  timestamp = {2015-09-15T11:38:06.000+0200},
  title = {Fuse: A Reproducible, Extendable, Internet-Scale Corpus of Spreadsheets.},
  url = {http://dblp.uni-trier.de/db/conf/msr/msr2015.html#BarikLSSM15},
  year = 2015
}




@inproceedings{DBLP:conf/icsm/Roy09,
  author    = {Chanchal K. Roy},
  title     = {Detection and analysis of near-miss software clones},
  booktitle = {Proc. of ICSM '09},
  year      = {2009},
  pages     = {447-450},
  ee        = {http://dx.doi.org/10.1109/ICSM.2009.5306301},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

@inproceedings{DBLP:conf/cascon/Johnson93,
  author    = {J. Howard Johnson},
  title     = {Identifying redundancy in source code using fingerprints},
  booktitle = {Proc. of CASCON '93},
  year      = {1993},
  pages     = {171-183},
  ee        = {http://doi.acm.org/10.1145/962305},
  crossref  = {DBLP:conf/cascon/1993},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}



@inproceedings{Scaf2005,
  author    = {C. Scaffidi and M. Shaw and B. A. Myers},
  title     = {Estimating the Numbers of End Users and End User Programmers},
  booktitle = {Proc. of VL/HCC '05},
  year      = {2005},
  pages     = {207-214},
  ee        = {http://doi.ieeecomputersociety.org/10.1109/VLHCC.2005.34},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}


@article{Ko2011,
 author = {Ko, Andrew J. and Abraham, Robin and Beckwith, Laura and Blackwell, Alan and Burnett, Margaret and Erwig, Martin and Scaffidi, Chris and Lawrance, Joseph and Lieberman, Henry and Myers, Brad and Rosson, Mary Beth and Rothermel, Gregg and Shaw, Mary and Wiedenbeck, Susan},
 title = {The State of the Art in End-user Software Engineering},
 journal = {ACM Comput. Surv.},
 issue_date = {April 2011},
 volume = {43},
 number = {3},
 month = apr,
 year = {2011},
 issn = {0360-0300},
 pages = {21:1--21:44},
 articleno = {21},
 numpages = {44},
 url = {http://doi.acm.org/10.1145/1922649.1922658},
 doi = {10.1145/1922649.1922658},
 acmid = {1922658},
 publisher = {ACM},
 address = {New York, NY, USA},
 keywords = {End-user software engineering, end-user development, end-user programming, human-computer interaction, visual programming},
} 

@inproceedings{Ko2004,
 author = {Ko, Andrew J. and Myers, Brad A. and Aung, Htet Htet},
 title = {Six Learning Barriers in End-User Programming Systems},
 booktitle = {Proceedings of the 2004 IEEE Symposium on Visual Languages - Human Centric Computing},
 series = {VLHCC '04},
 year = {2004},
 isbn = {0-7803-8696-5},
 pages = {199--206},
 numpages = {8},
 url = {http://dx.doi.org/10.1109/VLHCC.2004.47},
 doi = {10.1109/VLHCC.2004.47},
 acmid = {1034570},
 publisher = {IEEE Computer Society},
 address = {Washington, DC, USA},
} 

@inproceedings{Hermans2013-Cascon,
  author    = {Felienne Hermans},
  title     = {Improving spreadsheet test practices},
  booktitle = {Center for Advanced Studies on Collaborative Research, {CASCON} '12,
               Toronto, ON, Canada, November 18-20, 2013},
  pages     = {56--69},
  year      = {2013},
  crossref  = {DBLP:conf/cascon/2013},
  url       = {http://dl.acm.org/citation.cfm?id=2555531},
  timestamp = {Wed, 14 May 2014 15:57:05 +0200},
  biburl    = {http://dblp.uni-trier.de/rec/bib/conf/cascon/Hermans13},
  bibsource = {dblp computer science bibliography, http://dblp.org}
}

@article{Panko1998,
 author = {Panko, Raymond R.},
 title = {What We Know About Spreadsheet Errors},
 journal = {Journal of End User Computing},
 issue_date = {Spring 1998},
 volume = {10},
 number = {2},
 month = may,
 year = {1998},
 issn = {1063-2239},
 pages = {15--21},
 numpages = {7},
 url = {http://dl.acm.org/citation.cfm?id=287893.287899},
 acmid = {287899},
 publisher = {IGI Global},
 address = {Hershey, PA, USA},
} 

@article{Herndon2014,
author = {Herndon, Thomas and Ash, Michael and Pollin, Robert}, 
title = {Does high public debt consistently stifle economic growth? A critique of Reinhart and Rogoff},
volume = {38}, 
number = {2}, 
pages = {257-279}, 
year = {2014}, 
doi = {10.1093/cje/bet075}, 
URL = {http://cje.oxfordjournals.org/content/38/2/257.abstract}, 
eprint = {http://cje.oxfordjournals.org/content/38/2/257.full.pdf+html}, 
journal = {Cambridge Journal of Economics} 
}


@INPROCEEDINGS{Ko2004-Why,
    author = {Andrew J. Ko and Brad A. Myers},
    title = {Designing the Whyline: A debugging interface for asking questions about program behavior},
    booktitle = {In Proceedings of the SIGCHI Conference on Human Factors in Computing Systems. ACM},
    year = {2004},
    pages = {151--158}
}


@inproceedings{Rothermel1997,
 author = {Rothermel, Gregg and Li, Lixin and Burnett, Margaret},
 title = {Testing Strategies for Form-Based Visual Programs},
 booktitle = {Proceedings of the Eighth International Symposium on Software Reliability Engineering},
 series = {ISSRE '97},
 year = {1997},
 isbn = {0-8186-8120-9},
 pages = {96--},
 url = {http://dl.acm.org/citation.cfm?id=851010.856084},
 acmid = {856084},
 publisher = {IEEE Computer Society},
 address = {Washington, DC, USA},
} 

@inproceedings{Rothermel2000,
 author = {Rothermel, Karen J. and Cook, Curtis R. and Burnett, Margaret M. and Schonfeld, Justin and Green, T. R. G. and Rothermel, Gregg},
 title = {WYSIWYT testing in the spreadsheet paradigm: an empirical evaluation},
 booktitle = {Proc. of INCSE '00},
 pages = {230-239},
  year = {2000},
 numpages = {10}
}

@article{Kruck2006,
  author    = {S. E. Kruck},
  title     = {Testing spreadsheet accuracy theory},
  journal   = {Information {\&} Software Technology},
  volume    = {48},
  number    = {3},
  year      = {2006},
  pages     = {204-213},
  ee        = {http://dx.doi.org/10.1016/j.infsof.2005.04.005},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

@inproceedings{Burnett2003,
 author = {Burnett, Margaret and Cook, Curtis and Pendse, Omkar and Rothermel, Gregg and Summet, Jay and Wallace, Chris},
 title = {End-user software engineering with assertions in the spreadsheet paradigm},
 booktitle = {Proc. of ICSE '03},
 year = {2003},
 pages = {93-103},
 numpages = {11},
 url = {http://dl.acm.org/citation.cfm?id=776816.776828},
 acmid = {776828},
}

@book{Mattessich1964,
author = {R. Mattessich},
year = {1964},
title = {Simulation of the Firm through a Budget Computer Program},
publisher = {R.D. Irwin, Illinois}
}

@book{Chatfield1996,
author = {M. Chatfield and R. Vangermeersch},
year = {1996},
title = {The History of Accounting-An International Encyclopedia},
pages = {404-406},
publisher = {Garland Publishing, New York}
}

@book{Slater1989,
author = {Robert Slater},
title = {Portraits In Silicon},
publisher = {The MIT PRess},
year = {1989}
}

@book{Freedman2006,
author = {Roy S. Freedman},
year = {20066},
title = {Introduction to Financial Technology},
publisher= {Academic Press}
}


@book{Nardi1993,
 author = {B. A. Nardi},
 title = {A small matter of programming: perspectives on end user computing},
 year = {1993},
 isbn = {0-262-1405305},
 publisher = {MIT Press},
 }
 
 @inproceedings{Barrett2004,
	address = {New York, NY, USA},
	series = {{CSCW} '04},
	title = {Field {Studies} of {Computer} {System} {Administrators}: {Analysis} of {System} {Management} {Tools} and {Practices}},
	isbn = {1-58113-810-5},
	doi = {10.1145/1031607.1031672},
	booktitle = {Proceedings of the 2004 {ACM} {Conference} on {Computer} {Supported} {Cooperative} {Work}},
	publisher = {ACM},
	author = {Barrett, Rob and Kandogan, Eser and Maglio, Paul P. and Haber, Eben M. and Takayama, Leila A. and Prabaker, Madhu},
	year = {2004},
	pages = {388--395},
}

@book{brandt_opportunistic_2008,
	title = {Opportunistic {Programming}: {How} {Rapid} {Ideation} and {Prototyping} {Occur} in {Practice}},
	author = {Brandt, Joel and Guo, Philip J. and Lewenstein, Joel and Klemmer, Scott R.},
	year = {2008},
}

@inproceedings{myers_how_2008,
	title = {How designers design and program interactive behaviors},
	doi = {10.1109/VLHCC.2008.4639081},
	eventtitle = {{IEEE} Symposium on Visual Languages and Human-Centric Computing, 2008. {VL}/{HCC} 2008},
	pages = {177--184},
	booktitle = {{IEEE} Symposium on Visual Languages and Human-Centric Computing, 2008. {VL}/{HCC} 2008},
	author = {Myers, Brad and Park, Sun Young and Nakano, Y. and Mueller, G. and Ko, A.},
	date = {2008-09},
}
 
 
@online{Turing2013,
  author = {Felienne Hermans},
  title = {Excel Turing Machine},
  year = 2013,
  url = { http://www.felienne.com/archives/2974},
  urldate = {2015-09-24}
}

@online{Victor2012,
  author = {Bret Victor},
  title = {Inventing on Principle},
  organization = {Invited talk at the Canadian University Software Engineering Conference (CUSEC)},
  year = 2012,
  url = {http://vimeo.com/36579366}
  urldate = {2015-10-08}
}

@book{Fowl1999,
 title = {Refactoring: improving the design of existing code},
 year = {1999},
 isbn = {0-201-48567-2},
 publisher = {Addison-Wesley Longman Publishing Co., Inc.},
 address = {Boston, MA, USA},
 author = {M. Fowler}
 }
 

@online{Kelso2012,
  author = {Paul Kelso},
  title = {London 2012 Olympics: lucky few to get 100m final tickets after synchronised swimming was overbooked by 10,000},
  year = 2012,
  url = {http://www.telegraph.co.uk/sport/olympics/8992490/London-2012-Olympics-lucky-few-to-get-100m-final-tickets-after.-synchronised-swimming-was-overbooked-by-10000.html}
  urldate = {2015-10-08}
}




 
@online{BLS2003,
  author = {\relax {USA Bureau of} Labor Statistics},
  title = {COMPUTER AND INTERNET USE AT WORK IN 2003},
  year = 2005,
  url = {http://www.bls.gov/news.release/pdf/ciuaw.pdf},
  urldate = {2015-09-24}
}


@online{Wellnomics2007,
  author = {Wellnomics},
  title = {An analysis of computer use across 95
organisations in Europe, North America and
Australasia },
  year = 2007,
  url = {http://wellnomics.com/assets/Uploads/White-Papers/Wellnomics-white-paper-Comparison-of-Computer-Use-across-dif.ferent-Countries.pdf},
  urldate = {2015-09-24}
}

@online{CBS2013,
  author = {\relax{Dutch Bureau} of Statistics},
  title = {ICT gebruik van personen naar persoonskenmerken},
  year = 2014,
  url = {http://statline.cbs.nl/Statweb/publication/?DM=SLNL&PA=71098ned&D1=23,29&D2=0-2&D3=a&VW=T},
  urldate = {2015-09-24}
}

@inproceedings{Aivaloglou_2015,
	title = {A grammar for spreadsheet formulas evaluated on two large datasets},
	note = (to appear},
	booktitle = {15th IEEE International Working Conference on Source Code Analysis and Manipulation (SCAM '15)},
	author = {Efthimia Aivaloglou, David Hoepelman, and Felienne Hermans},
	date = {2015},
}

@MastersThesis{hoepelman_thesis_2015,
    author     =     {David Hoepelman},
    title     =     {Tool-assisted Spreadsheet Refactoring and Parsing Spreadsheet Formulas},
    school     =     {Delft University of Technology},
    address     =     {the Netherlands},
    year     =     {2015},
    }
	
@MastersThesis{badame_thesis_2012,
    author     =     {Sandro Badame},
    title     =     {REFACTORING MEETS SPREADSHEET FORMULAS},
    school     =     {University of Illinois at Urbana-Champaign},
    address     =     {United States of America},
    year     =     {2012},
    }




%---------------------------------------------------------------------------------------------------------
%----------------------Zotero output
%------------------------------------------------------------------------------------------------------

@inproceedings{dou_is_2014,
	address = {New York, NY, USA},
	series = {{ICSE} 2014},
	title = {Is {Spreadsheet} {Ambiguity} {Harmful}? {Detecting} and {Repairing} {Spreadsheet} {Smells} {Due} to {Ambiguous} {Computation}},
	isbn = {978-1-4503-2756-5},
	shorttitle = {Is {Spreadsheet} {Ambiguity} {Harmful}?},
	url = {http://doi.acm.org/10.1145/2568225.2568316},
	doi = {10.1145/2568225.2568316},
	abstract = {Spreadsheets are widely used by end users for numerical computation in their business. Spreadsheet cells whose computation is subject to the same semantics are often clustered in a row or column. When a spreadsheet evolves, these cell clusters can degenerate due to ad hoc modifications or undisciplined copy-and-pastes. Such degenerated clusters no longer keep cells prescribing the same computational semantics, and are said to exhibit ambiguous computation smells. Our empirical study finds that such smells are common and likely harmful. We propose AmCheck, a novel technique that automatically detects and repairs ambiguous computation smells by recovering their intended computational semantics. A case study using AmCheck suggests that it is useful for discovering and repairing real spreadsheet problems.},
	urldate = {2015-10-29},
	booktitle = {Proceedings of the 36th {International} {Conference} on {Software} {Engineering}},
	publisher = {ACM},
	author = {Dou, Wensheng and Cheung, Shing-Chi and Wei, Jun},
	year = {2014},
	keywords = {ambiguous computation, repair, smell, spreadsheet},
	pages = {848--858},
	file = {ACM Full Text PDF:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\UBVQ5Q3A\\Dou et al. - 2014 - Is Spreadsheet Ambiguity Harmful Detecting and Re.pdf:application/pdf}
}


@article{hermans_bumblebee:_2014,
	title = {{BumbleBee}: {A} refactoring environment for spreadsheet formulas},
	shorttitle = {{BumbleBee}},
	url = {http://files.figshare.com/1757475/bumblebee.pdf},
	urldate = {2015-10-29},
	journal = {Proceedings of the 22nd ACM SIGSOFT International Symposium on Foundations of Software Engineering, ser. FSE},
	author = {Hermans, Felienne and Dig, Danny},
	year = {2014},
	pages = {747--750},
	file = {[PDF] from figshare.com:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\DTT3WJDB\\Hermans and Dig - 2014 - BumbleBee A refactoring environment for spreadshe.pdf:application/pdf}
}---

@incollection{burnett_visual_2001,
	title = {Visual {Programming}},
	copyright = {Copyright © 1999 by John Wiley \& Sons, Inc.},
	isbn = {978-0-471-34608-1},
	url = {http://onlinelibrary.wiley.com/doi/10.1002/047134608X.W1707/abstract},
	abstract = {The sections in this article are},
	language = {en},
	urldate = {2015-10-29},
	booktitle = {Wiley {Encyclopedia} of {Electrical} and {Electronics} {Engineering}},
	publisher = {John Wiley \& Sons, Inc.},
	author = {Burnett, Margaret M.},
	year = {2001},
	file = {Snapshot:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\42HVS3TN\\abstract\;jsessionid=890D77C4F34271648DB0D377BF7AFA8C.html:text/html}
}


@article{shneiderman_direct_1983,
	title = {Direct {Manipulation}: {A} {Step} {Beyond} {Programming} {Languages}},
	volume = {16},
	issn = {0018-9162},
	shorttitle = {Direct {Manipulation}},
	doi = {10.1109/MC.1983.1654471},
	abstract = {Not Available},
	number = {8},
	journal = {Computer},
	author = {Shneiderman, B.},
	month = aug,
	year = {1983},
	keywords = {Command languages, Computer interfaces, Computer languages, Displays, Human factors, Interactive systems, Office automation, Power system modeling, Publishing, user interfaces},
	pages = {57--69},
	file = {IEEE Xplore Abstract Record:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\KUIDWSPM\\abs_all.html:text/html;IEEE Xplore Full Text PDF:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\GTU84IMD\\Shneiderman - 1983 - Direct Manipulation A Step Beyond Programming Lan.pdf:application/pdf}
}


@inproceedings{maloney_directness_1995,
	address = {New York, NY, USA},
	series = {{UIST} '95},
	title = {Directness and {Liveness} in the {Morphic} {User} {Interface} {Construction} {Environment}},
	isbn = {0-89791-709-X},
	url = {http://doi.acm.org/10.1145/215585.215636},
	doi = {10.1145/215585.215636},
	urldate = {2015-10-28},
	booktitle = {Proceedings of the 8th {Annual} {ACM} {Symposium} on {User} {Interface} and {Software} {Technology}},
	publisher = {ACM},
	author = {Maloney, John H. and Smith, Randall B.},
	year = {1995},
	keywords = {animation, automatic layout, direct manipulation, directness, live editing, liveness, structural reification, user interface construction, user interface frameworks},
	pages = {21--28},
	file = {ACM Full Text PDF:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\NZ4683II\\Maloney and Smith - 1995 - Directness and Liveness in the Morphic User Interf.pdf:application/pdf}
}

@inproceedings{barowy_checkcell:_2014,
	address = {New York, NY, USA},
	series = {{OOPSLA} '14},
	title = {{CheckCell}: {Data} {Debugging} for {Spreadsheets}},
	isbn = {978-1-4503-2585-1},
	shorttitle = {{CheckCell}},
	url = {http://doi.acm.org/10.1145/2660193.2660207},
	doi = {10.1145/2660193.2660207},
	abstract = {Testing and static analysis can help root out bugs in programs, but not in data. This paper introduces data debugging, an approach that combines program analysis and statistical analysis to automatically find potential data errors. Since it is impossible to know a priori whether data are erroneous, data debugging instead locates data that has a disproportionate impact on the computation. Such data is either very important, or wrong. Data debugging is especially useful in the context of data-intensive programming environments that intertwine data with programs in the form of queries or formulas. We present the first data debugging tool, CheckCell, an add-in for Microsoft Excel. CheckCell identifies cells that have an unusually high impact on the spreadsheet's computations. We show that CheckCell is both analytically and empirically fast and effective. We show that it successfully finds injected typographical errors produced by a generative model trained with data entry from 169,112 Mechanical Turk tasks. CheckCell is more precise and efficient than standard outlier detection techniques. CheckCell also automatically identifies a key flaw in the infamous Reinhart and Rogoff spreadsheet.},
	urldate = {2015-10-27},
	booktitle = {Proceedings of the 2014 {ACM} {International} {Conference} on {Object} {Oriented} {Programming} {Systems} {Languages} \& {Applications}},
	publisher = {ACM},
	author = {Barowy, Daniel W. and Gochev, Dimitar and Berger, Emery D.},
	year = {2014},
	keywords = {data-debugging, debugging, errors, inputs, Spreadsheets},
	pages = {507--523},
	file = {ACM Full Text PDF:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\5FBNFCQE\\Barowy et al. - 2014 - CheckCell Data Debugging for Spreadsheets.pdf:application/pdf}
}

@incollection{cunha_towards_2012,
	series = {Lecture {Notes} in {Computer} {Science}},
	title = {Towards a {Catalog} of {Spreadsheet} {Smells}},
	copyright = {©2012 Springer-Verlag Berlin Heidelberg},
	isbn = {978-3-642-31127-7 978-3-642-31128-4},
	url = {http://link.springer.com/chapter/10.1007/978-3-642-31128-4_15},
	abstract = {Spreadsheets are considered to be the most widely used programming language in the world, and reports have shown that 90\% of real-world spreadsheets contain errors. In this work, we try to identify spreadsheet smells, a concept adapted from software, which consists of a surface indication that usually corresponds to a deeper problem. Our smells have been integrated in a tool, and were computed for a large spreadsheet repository. Finally, the analysis of the results we obtained led to the refinement of our initial catalog.},
	language = {en},
	number = {7336},
	urldate = {2015-10-27},
	booktitle = {Computational {Science} and {Its} {Applications} – {ICCSA} 2012},
	publisher = {Springer Berlin Heidelberg},
	author = {Cunha, Jácome and Fernandes, João P. and Ribeiro, Hugo and Saraiva, João},
	editor = {Murgante, Beniamino and Gervasi, Osvaldo and Misra, Sanjay and Nedjah, Nadia and Rocha, Ana Maria A. C. and Taniar, David and Apduhan, Bernady O.},
	month = jun,
	year = {2012},
	note = {DOI: 10.1007/978-3-642-31128-4\_15},
	keywords = {Algorithm Analysis and Problem Complexity, Code Smells, Computer Communication Networks, Data Mining and Knowledge Discovery, EUSES Corpus, Information Systems Applications (incl. Internet), Simulation and Modeling, Software Engineering, Spreadsheets},
	pages = {202--216},
	file = {Full Text PDF:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\HFC4PZQS\\Cunha et al. - 2012 - Towards a Catalog of Spreadsheet Smells.pdf:application/pdf;Snapshot:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\6KS9G96Q\\10.html:text/html}
}

@inproceedings{vos_g.:_2012,
	title = {G.: {Reconstructing} {Semantics} of {Scientific} {Models} : a {Case} {Study}},
	shorttitle = {G.},
	abstract = {Abstract. Spreadsheets are frequently used by scientists to store and analyze research data. To enable integration and reusability of scientific spreadsheet data it is important to explicate the underlying concepts and relations. In this paper we explore to which extent the conceptual model of a research project can be recognized in its spreadsheet implementation. We perform a manual analysis of spreadsheets of existing research from the domain of environmental science. We formally describe the semantics of the spreadsheets in an ontology and record our approach in heuristics. We interview the original developers of the spreadsheets to compare our findings with their views. Our reconstructed conceptual model does not conflict with the developer’s views, but represents a different perspective, as the developers are primarily focussed on the calculation workflow.},
	booktitle = {In: {Proceedings} of the {OEDW} workshop on},
	author = {Vos, Martine De and Hage, Willem Robert Van and Ros, Jan and Schreiber, Guus},
	year = {2012},
	file = {Citeseer - Full Text PDF:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\6F9ZGXCW\\Vos et al. - 2012 - G. Reconstructing Semantics of Scientific Models .pdf:application/pdf;Citeseer - Snapshot:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\CKXGFSK8\\summary.html:text/html}
}

@inproceedings{de_vos_methodology_2015,
	address = {New York, NY, USA},
	series = {K-{CAP} 2015},
	title = {A {Methodology} for {Constructing} the {Calculation} {Model} of {Scientific} {Spreadsheets}},
	isbn = {978-1-4503-3849-3},
	url = {http://doi.acm.org/10.1145/2815833.2815843},
	doi = {10.1145/2815833.2815843},
	abstract = {Spreadsheets models are frequently used by scientists to analyze research data. These models are typically described in a paper or a report, which serves as single source of information on the underlying research project. As the calculation workflow in these models is not made explicit, readers are not able to fully understand how the research results are calculated, and trace them back to the underlying spreadsheets. This paper proposes a methodology for semi-automatically deriving the calculation workflow underlying a set of spreadsheets. The starting point of our methodology is the cell dependency graph, representing all spreadsheet cells and connections. We automatically aggregate all cells in the graph that represent instances and duplicates of the same quantities, based on analysis of the formula syntax. Subsequently, we use a set of heuristics, incorporating knowledge on spreadsheet design, computational procedures and domain knowledge, to select those quantities, that are relevant for understanding the calculation workflow. We explain and illustrate our methodology by actually applying it on three sets of spreadsheets from existing research projects in the domains of environmental and life science. Results from these case studies show that our constructed calculation models approximate the ground truth calculation workflows, both in terms of content and size, but are not a perfect match.},
	urldate = {2015-10-27},
	booktitle = {Proceedings of the 8th {International} {Conference} on {Knowledge} {Capture}},
	publisher = {ACM},
	author = {de Vos, Martine and Wielemaker, Jan and Schreiber, Guus and Wielinga, Bob and Top, Jan},
	year = {2015},
	keywords = {Calculation Model, Graph Aggregation, Heuristics, Spreadsheets},
	pages = {2:1--2:8},
	file = {ACM Full Text PDF:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\W8UJX539\\de Vos et al. - 2015 - A Methodology for Constructing the Calculation Mod.pdf:application/pdf}
}

@book{management_2003,
	author = {Powell, S.G. and Baker, K.P. },
	address = {Hoboken, N.J},
	title = {The {Art} of {Modeling} with {Spreadsheets}},
	isbn = {978-0-470-53067-2},
	shorttitle = {Management {Science}},
	language = {English},
	publisher = {John Wiley \& Sons, Inc.},
	year = {2003}
}

@inproceedings{engels_classsheets:_2005,
	address = {New York, NY, USA},
	series = {{ASE} '05},
	title = {{ClassSheets}: {Automatic} {Generation} of {Spreadsheet} {Applications} from {Object}-oriented {Specifications}},
	isbn = {1-58113-993-4},
	shorttitle = {{ClassSheets}},
	url = {http://doi.acm.org/10.1145/1101908.1101929},
	doi = {10.1145/1101908.1101929},
	abstract = {Spreadsheets are widely used in all kinds of business applications. Numerous studies have shown that they contain many errors that sometimes have dramatic impacts. One reason for this situation is the low-level, cell-oriented development process of spreadsheets.We improve this process by introducing and formalizing a higher-level object-oriented model termed ClassSheet. While still following the tabular look-and feel of spreadsheets, ClassSheets allow the developer to express explicitly business object structures within a spreadsheet, which is achieved by integrating concepts from the UML (Unified Modeling Language). A stepwise automatic transformation process generates a spreadsheet application that is consistent with the ClassSheet model. Thus, by deploying the formal underpinning of ClassSheets, a large variety of errors can be prevented that occur in many existing spreadsheet applications today.The presented ClassSheet approach links spreadsheet applications to the object-oriented modeling world and advocates an automatic model-driven development process for spreadsheet applications of high quality.},
	urldate = {2015-10-27},
	booktitle = {Proceedings of the 20th {IEEE}/{ACM} {International} {Conference} on {Automated} {Software} {Engineering}},
	publisher = {ACM},
	author = {Engels, Gregor and Erwig, Martin},
	year = {2005},
	keywords = {end-user software engineering, spreadsheet, UML},
	pages = {124--133},
	file = {ACM Full Text PDF:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\KQRWHGEJ\\Engels and Erwig - 2005 - ClassSheets Automatic Generation of Spreadsheet A.pdf:application/pdf}
}

@inproceedings{cunha_automatically_2010,
	address = {Washington, DC, USA},
	series = {{VLHCC} '10},
	title = {Automatically {Inferring} {ClassSheet} {Models} from {Spreadsheets}},
	isbn = {978-0-7695-4206-5},
	url = {http://dx.doi.org/10.1109/VLHCC.2010.22},
	doi = {10.1109/VLHCC.2010.22},
	abstract = {Many errors in spreadsheet formulas can be avoided if spreadsheets are built automatically from higher-level models that can encode and enforce consistency constraints. However, designing such models is time consuming and requires expertise beyond the knowledge to work with spreadsheets. Legacy spreadsheets pose a particular challenge to the approach of controlling spreadsheet evolution through higher-level models, because the need for a model might be overshadowed by two problems: (A) The benefit of creating a spreadsheet is lacking since the legacy spreadsheet already exists, and (B) existing data must be transferred into the new model-generated spreadsheet. To address these problems and to support the model-driven spreadsheet engineering approach, we have developed a tool that can automatically infer ClassSheet models from spreadsheets. To this end, we have adapted a method to infer entity/relationship models from relational database to the spreadsheets/ClassSheets realm. We have implemented our techniques in the HaExcel framework and integrated it with the ViTSL/Gencel spreadsheet generator, which allows the automatic generation of refactored spreadsheets from the inferred ClassSheet model. The resulting spreadsheet guides further changes and provably safeguards the spreadsheet against a large class of formula errors. The developed tool is a significant contribution to spreadsheet (reverse) engineering, because it fills an important gap and allows a promising design method (ClassSheets) to be applied to a huge collection of legacy spreadsheets with minimal effort.},
	urldate = {2015-10-27},
	booktitle = {Proceedings of the 2010 {IEEE} {Symposium} on {Visual} {Languages} and {Human}-{Centric} {Computing}},
	publisher = {IEEE Computer Society},
	author = {Cunha, Jacome and Erwig, Martin and Saraiva, Joao},
	year = {2010},
	keywords = {ClassSheets inference, Spreadsheets},
	pages = {93--100}
}

@article{obeirne_spreadsheet_2010,
	series = {{EuSpRIG} '10},
	title = {Spreadsheet {Refactoring}},
	url = {http://arxiv.org/abs/1009.1412},
	abstract = {Refactoring is a change made to the internal structure of software to make it easier to understand and cheaper to modify without changing its observable behaviour. A database refactoring is a small change to the database schema which improves its design without changing its semantics. This paper presents example 'spreadsheet refactorings', derived from the above and taking into account the unique characteristics of spreadsheet formulas and VBA code. The techniques are constrained by the tightly coupled data and code in spreadsheets.},
	urldate = {2015-10-08},
	journal = {European Spreadsheet Risks Interest Group 11th Annual Conference},
	author = {O'Beirne, Patrick},
	month = sep,
	year = {2010},
	note = {arXiv: 1009.1412},
	keywords = {Computer Science - Software Engineering},
	file = {arXiv\:1009.1412 PDF:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\CWKH6HMN\\O'Beirne - 2010 - Spreadsheet Refactoring.pdf:application/pdf;arXiv.org Snapshot:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\ZUAGURZ6\\1009.html:text/html}
}

@inproceedings{myers_how_2008,
	title = {How designers design and program interactive behaviors},
	doi = {10.1109/VLHCC.2008.4639081},
	abstract = {Designers are skilled at sketching and prototyping the look of interfaces, but to explore various behaviors (what the interface does in response to input) typically requires programming using Javascript, ActionScript for Flash, or other languages. In our survey of 259 designers, 86\% reported that the behavior is more difficult to prototype than the appearance. Often (78\% of the time), designing the behavior requires collaborating with developers, but 76\% of designers reported that communicatin1g the behavior to developers was more difficult than the appearance. Other results include that annotations such as arrows and paragraphs of text are used on top of sketches and storyboards to explain behaviors, and designers want to explore multiple versions of behaviors, but todaypsilas tools make this difficult. The results provide new ideas for future tools.},
	booktitle = {{IEEE} {Symposium} on {Visual} {Languages} and {Human}-{Centric} {Computing}, 2008. {VL}/{HCC} 2008},
	author = {Myers, Brad and Park, Sun Young and Nakano, Y. and Mueller, G. and Ko, A.},
	month = sep,
	year = {2008},
	keywords = {collaboration, Computer interfaces, Human computer interaction, interactive behavior, Java, Motion pictures, Programming profession, Prototypes, Sun, user interface, user interfaces, Web pages},
	pages = {177--184},
	file = {IEEE Xplore Abstract Record:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\5CVMSXDP\\abs_all.html:text/html;IEEE Xplore Full Text PDF:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\SFRNFGK5\\Myers et al. - 2008 - How designers design and program interactive behav.pdf:application/pdf}
}

@article{ko_state_2011,
	title = {The {State} of the {Art} in {End}-user {Software} {Engineering}},
	volume = {43},
	issn = {0360-0300},
	url = {http://doi.acm.org/10.1145/1922649.1922658},
	doi = {10.1145/1922649.1922658},
	number = {3},
	journal = {ACM Comput. Surv.},
	author = {Ko, Andrew J. and Abraham, Robin and Beckwith, Laura and Blackwell, Alan and Burnett, Margaret and Erwig, Martin and Scaffidi, Chris and Lawrance, Joseph and Lieberman, Henry and Myers, Brad and Rosson, Mary Beth and Rothermel, Gregg and Shaw, Mary and Wiedenbeck, Susan},
	month = apr,
	year = {2011},
	keywords = {end-user development, end-user programming, End-user software engineering, human-computer interaction, visual programming},
	pages = {21:1--21:44},
	file = {a21-ko.pdf:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\4P23J4SW\\a21-ko.pdf:application/pdf}
}

@article{herndon_does_2014,
	title = {Does high public debt consistently stifle economic growth? {A} critique of {Reinhart} and {Rogoff}},
	volume = {38},
	issn = {0309-166X, 1464-3545},
	shorttitle = {Does high public debt consistently stifle economic growth?},
	url = {http://cje.oxfordjournals.org/content/38/2/257},
	doi = {10.1093/cje/bet075},
	abstract = {We replicate Reinhart and Rogoff (2010A and 2010B) and find that selective exclusion of available data, coding errors and inappropriate weighting of summary statistics lead to serious miscalculations that inaccurately represent the relationship between public debt and GDP growth among 20 advanced economies. Over 1946–2009, countries with public debt/GDP ratios above 90\% averaged 2.2\% real annual GDP growth, not −0.1\% as published. The published results for (i) median GDP growth rates for the 1946–2009 period and (ii) mean and median GDP growth figures over 1790–2009 are all distorted by similar methodological errors, although the magnitudes of the distortions are somewhat smaller than with the mean figures for 1946–2009. Contrary to Reinhart and Rogoff’s broader contentions, both mean and median GDP growth when public debt levels exceed 90\% of GDP are not dramatically different from when the public debt/GDP ratios are lower. The relationship between public debt and GDP growth varies significantly by period and country. Our overall evidence refutes RR’s claim that public debt/GDP ratios above 90\% consistently reduce a country’s GDP growth.},
	language = {en},
	number = {2},
	urldate = {2015-10-08},
	journal = {Cambridge Journal of Economics},
	author = {Herndon, Thomas and Ash, Michael and Pollin, Robert},
	month = mar,
	year = {2014},
	keywords = {Austerity, E60, E62, E65, Public debt},
	pages = {257--279},
	file = {Snapshot:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\U2DF8VN6\\Herndon et al. - 2014 - Does high public debt consistently stifle economic.html:text/html}
}

@inproceedings{hermans_data_2013,
	title = {Data clone detection and visualization in spreadsheets},
	url = {http://dl.acm.org/citation.cfm?id=2486827},
	urldate = {2015-10-08},
	booktitle = {Proceedings of the 2013 {International} {Conference} on {Software} {Engineering}},
	publisher = {IEEE Press},
	author = {Hermans, Felienne and Sedee, Ben and Pinzger, Martin and Deursen, Arie van},
	year = {2013},
	pages = {292--301},
	file = {Snapshot:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\3I3AW4WM\\citation.html:text/html}
}

@article{hermans_detecting_2014,
	title = {Detecting and refactoring code smells in spreadsheet formulas},
	volume = {20},
	url = {http://link.springer.com/article/10.1007/s10664-013-9296-2},
	number = {2},
	urldate = {2015-10-08},
	journal = {Empirical Software Engineering},
	author = {Hermans, Felienne and Pinzger, Martin and van Deursen, Arie},
	year = {2014},
	pages = {549--575},
	file = {[PDF] from tudelft.nl:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\NG6RTXCU\\Hermans et al. - 2014 - Detecting and refactoring code smells in spreadshe.pdf:application/pdf;Snapshot:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\DWD9764T\\s10664-013-9296-2.html:text/html}
}

@inproceedings{hermans_supporting_2011,
	address = {New York, NY, USA},
	series = {{ICSE} '11},
	title = {Supporting {Professional} {Spreadsheet} {Users} by {Generating} {Leveled} {Dataflow} {Diagrams}},
	isbn = {978-1-4503-0445-0},
	url = {http://doi.acm.org/10.1145/1985793.1985855},
	doi = {10.1145/1985793.1985855},
	abstract = {Thanks to their flexibility and intuitive programming model, spreadsheets are widely used in industry, often for businesscritical applications. Similar to software developers, professional spreadsheet users demand support for maintaining and transferring their spreadsheets. In this paper, we first study the problems and information needs of professional spreadsheet users by means of a survey conducted at a large financial company. Based on these needs, we then present an approach that extracts this information from spreadsheets and presents it in a compact and easy to understand way, with leveled dataflow diagrams. Our approach comes with three different views on the dataflow that allow the user to analyze the dataflow diagrams in a top-down fashion. To evaluate the usefulness of the proposed approach, we conducted a series of interviews as well as nine case studies in an industrial setting. The results of the evaluation clearly indicate the demand for and usefulness of our approach in ease the understanding of spreadsheets.},
	urldate = {2015-09-24},
	booktitle = {Proceedings of the 33rd {International} {Conference} on {Software} {Engineering}},
	publisher = {ACM},
	author = {Hermans, Felienne and Pinzger, Martin and van Deursen, Arie},
	year = {2011},
	keywords = {data flow diagrams, end-user programming, spreadsheets, visualization},
	pages = {451--460}
}

@Article{7_pichitlamken_kajkamhaeng_uthayopas_kaewpuang_2010,
  Title                    = {High performance spreadsheet simulation on a desktop grid},
  Author                   = {Pichitlamken, J and Kajkamhaeng, S and Uthayopas, P and Kaewpuang, R},
  Journal                  = {Journal of Simulation},
  Year                     = {2010},
  Number                   = {4},
  Pages                    = {266-278},
  Volume                   = {5}
  
  @Book{6_abramson_roe_kotler_mather_2001,
  Title                    = {ActiveSheets Super-Computing with Spreadsheets},
  Author                   = {ABRAMSON, D. and ROE, P. and KOTLER, L. and MATHER, D.},
  Year                     = {2001}
}

@Article{10_nadiminti_chiu_teoh_luther_venugopal_buyya_2004,
  Title                    = {ExcelGrid: A .NET Plug-in for Outsourcing Excel Spreadsheet Workload to Enterprise and Global Grids},
  Author                   = {Nadiminti, Krishna and Chiu, Yi-Feng and Teoh, Nick and Luther, Akshay and Venugopal, Srikumar and Buyya, Rajkumar},
  Year                     = {2004},

  Booktitle                = {International Conference on Advanced Computing and Communication (ADCOM 2004)},
  Urldate                  = {2015-7-7}
}


@article{hermans_detecting_2012,
	title = {Detecting {Code} {Smells} in {Spreadsheet} {Formulas}},
	url = {http://ieeexplore.ieee.org/xpls/abs_all.jsp?arnumber=6405300},
	urldate = {2015-10-08},
	journal = {Proceedings of the International Conference on Software Maintenance (ICSM)},
	author = {Hermans, Felienne and Pinzger, Martin and Deursen, A. V.},
	year = {2012},
	file = {[PDF] from tudelft.nl:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\JR7AENIJ\\Hermans et al. - 2012 - Detecting Code Smells in Spreadsheet Formulas.pdf:application/pdf;Snapshot:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\2K6MQ4HX\\abs_all.html:text/html}
}

@inproceedings{hermans_detecting_2012-1,
	title = {Detecting and visualizing inter-worksheet smells in spreadsheets},
	url = {http://dl.acm.org/citation.cfm?id=2337275},
	urldate = {2015-10-08},
	booktitle = {Proceedings of the 34th {International} {Conference} on {Software} {Engineering}},
	publisher = {IEEE Press},
	author = {Hermans, Felienne and Pinzger, Martin and Deursen, Arie van},
	year = {2012},
	pages = {441--451},
	file = {[PDF] from tudelft.nl:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\BGXABVXE\\Hermans et al. - 2012 - Detecting and visualizing inter-worksheet smells i.pdf:application/pdf;Snapshot:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\XT2VM96S\\citation.html:text/html}
}

@incollection{hermans_automatically_2010,
	series = {Lecture {Notes} in {Computer} {Science}},
	title = {Automatically {Extracting} {Class} {Diagrams} from {Spreadsheets}},
	copyright = {©2010 Springer-Verlag Berlin Heidelberg},
	isbn = {978-3-642-14106-5 978-3-642-14107-2},
	url = {http://link.springer.com/chapter/10.1007/978-3-642-14107-2_4},
	language = {en},
	number = {6183},
	urldate = {2015-09-24},
	booktitle = {{ECOOP} 2010 – {Object}-{Oriented} {Programming}},
	publisher = {Springer Berlin Heidelberg},
	author = {Hermans, Felienne and Pinzger, Martin and Deursen, Arie van},
	editor = {D’Hondt, Theo},
	month = jun,
	year = {2010},
	keywords = {Antibodies, Computer Communication Networks, Logics and Meanings of Programs, Programming Languages, Compilers, Interpreters, Software Engineering, Software Engineering/Programming and Operating Systems},
	pages = {52--75},
	file = {Snapshot:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\T4KTZ6CI\\Hermans et al. - 2010 - Automatically Extracting Class Diagrams from Sprea.html:text/html}
}

@inproceedings{fisher_euses_2005,
	address = {New York, NY, USA},
	series = {{WEUSE} {I}},
	title = {The {EUSES} {Spreadsheet} {Corpus}: {A} {Shared} {Resource} for {Supporting} {Experimentation} with {Spreadsheet} {Dependability} {Mechanisms}},
	isbn = {1-59593-131-7},
	shorttitle = {The {EUSES} {Spreadsheet} {Corpus}},
	url = {http://doi.acm.org/10.1145/1082983.1083242},
	doi = {10.1145/1082983.1083242},
	abstract = {In recent years several tools and methodologies have been developed to improve the dependability of spreadsheets. However, there has been little evaluation of these dependability devices on spreadsheets in actual use by end users. To assist in the process of evaluating these methodologies, we have assembled a corpus of spreadsheets from a variety of sources. We have ensured that these spreadsheets are suitable for evaluating dependability devices in Microsoft Excel (the most commonly used commercial spreadsheet environment) and have measured a variety of feature of these spreadsheets to aid researchers in selecting subsets of the corpus appropriate to their needs.},
	urldate = {2015-09-24},
	booktitle = {Proceedings of the {First} {Workshop} on {End}-user {Software} {Engineering}},
	publisher = {ACM},
	author = {Fisher, Marc and Rothermel, Gregg},
	year = {2005},
	keywords = {end-user programming, end-user software engineering},
	pages = {1--5}
}

@book{brandt_opportunistic_2008,
	title = {Opportunistic {Programming}: {How} {Rapid} {Ideation} and {Prototyping} {Occur} in {Practice}},
	shorttitle = {Opportunistic {Programming}},
	abstract = {At times, programmers work opportunistically, emphasizing speed and ease of development over code robustness and maintainability. They do this to prototype, ideate, and discover; to understand as quickly as possible what the right solution is. Despite its importance, opportunistic programming remains poorly understood when compared with traditional software engineering. Through fieldwork and a laboratory study, we observed five characteristics of opportunistic programming: Programmers build software from scratch using high-level tools, often add new functionality via copyand-paste, iterate more rapidly than in traditional development, consider code to be impermanent, and face unique debugging challenges because their applications often comprise many languages and tools composed without upfront design. Based on these characteristics, we discuss future research on tools for debugging, code foraging and reuse, and documentation that are specifically targeted at this style of development.},
	author = {Brandt, Joel and Guo, Philip J. and Lewenstein, Joel and Klemmer, Scott R.},
	year = {2008},
	file = {Citeseer - Full Text PDF:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\UIVCREHV\\Brandt et al. - 2008 - Opportunistic Programming How Rapid Ideation and .pdf:application/pdf;Citeseer - Snapshot:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\CI9MPPFS\\summary.html:text/html}
}

@inproceedings{barrett_field_2004,
	address = {New York, NY, USA},
	series = {{CSCW} '04},
	title = {Field {Studies} of {Computer} {System} {Administrators}: {Analysis} of {System} {Management} {Tools} and {Practices}},
	isbn = {1-58113-810-5},
	shorttitle = {Field {Studies} of {Computer} {System} {Administrators}},
	url = {http://doi.acm.org/10.1145/1031607.1031672},
	doi = {10.1145/1031607.1031672},
	abstract = {Computer system administrators are the unsung heroes of the information age, working behind the scenes to configure, maintain, and troubleshoot the computer infrastructure that underlies much of modern life. However, little can be found in the literature about the practices and problems of these highly specialized computer users. We conducted a series of field studies in large corporate data centers, observing organizations, work practices, tools, and problem-solving strategies of system administrators. We found system administrators operate within large-scale, complex environments that present significant technical, social, cognitive, and business challenges. In this paper, we describe system administrator tool use in critical, high-cost, labor-intensive work through observational, survey, and interview data. We discuss our findings concerning administrator needs for coordinating work, maintaining situation awareness, planning and rehearsing complex procedures, building tools, and supporting complicated interleaved workflows.},
	urldate = {2015-09-23},
	booktitle = {Proceedings of the 2004 {ACM} {Conference} on {Computer} {Supported} {Cooperative} {Work}},
	publisher = {ACM},
	author = {Barrett, Rob and Kandogan, Eser and Maglio, Paul P. and Haber, Eben M. and Takayama, Leila A. and Prabaker, Madhu},
	year = {2004},
	keywords = {collaboration, command-line interfaces, ethnography, situation awareness, system administration},
	pages = {388--395},
	file = {ACM Full Text PDF:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\IWJZ8MH4\\Barrett et al. - 2004 - Field Studies of Computer System Administrators A.pdf:application/pdf}
}

@inproceedings{badame_refactoring_2012,
	title = {Refactoring meets spreadsheet formulas},
	doi = {10.1109/ICSM.2012.6405299},
	abstract = {The number of end-users who write spreadsheet programs is at least an order of magnitude larger than the number of trained programmers who write professional software. We studied a corpus of 3691 spreadsheets and we found that their formulas are riddled with the same smells that plague professional software: hardcoded constants, duplicated expressions, unnecessary complexity, and unsanitized input. These make spreadsheets difficult to read and expensive to maintain. Like automated refactoring in the object-oriented domain, spreadsheet refactoring can be transformative. In this paper we present seven refactorings for spreadsheet formulas implemented in RefBook, a plugin for Microsoft Excel. To evaluate the usefulness of RefBook, we employed three kinds of empirical methods. First, we conducted a User Survey with 28 Excel users to find out whether they preferred the refactored formulas. Second, we conducted a Controlled Experiment with the same 28 participants to measure their productivity when doing manual refactorings. Third, we performed a Retrospective Case Study on the EUSES Spreadsheet Corpus with 3691 spreadsheets to determine how often we could apply the refactorings supported by RefBook. The results show: (i) users prefer the improved quality of refactored formulas, (ii) RefBook is faster and more reliable than manual refactoring, and (iii) the refactorings are widely applicable. On average RefBook is able to apply the refactorings in less than half the time that users performed the refactorings manually. 92.54\% of users introduced errors or new smells into the spreadsheet or were unable to complete the task.},
	booktitle = {2012 28th {IEEE} {International} {Conference} on {Software} {Maintenance} ({ICSM})},
	author = {Badame, S. and Dig, D.},
	month = sep,
	year = {2012},
	keywords = {automated refactoring, computational complexity, Computer architecture, Conferences, duplicated expressions, EUSES spreadsheet corpus, hardcoded constants, Microprocessors, Microsoft Excel, object-oriented domain, Productivity, professional software, REFBOOK, software maintenance, spreadsheet formulas, spreadsheet programs, unnecessary complexity, unsanitized input},
	pages = {399--409},
	file = {IEEE Xplore Abstract Record:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\6KJZJUUS\\abs_all.html:text/html;IEEE Xplore Full Text PDF:C\:\\Users\\Felienne\\AppData\\Roaming\\Zotero\\Zotero\\Profiles\\dgizxtry.default\\zotero\\storage\\6J3PU233\\Badame and Dig - 2012 - Refactoring meets spreadsheet formulas.pdf:application/pdf}
}

@inproceedings{igarashi1998fluid,
  title={Fluid visualization of spreadsheet structures},
  author={Igarashi, Takeo and Mackinlay, Jock D and Chang, Bay-Wei and Zellweger, Polle T},
  booktitle={Proceedings.  IEEE Symposium on Visual Languages, 1998},
  pages={118--125},
  year={1998},
  organization={IEEE}
}

@inproceedings{shiozawa19993d,
  title={3d interactive visualization for inter-cell dependencies of spreadsheets},
  author={Shiozawa, Hidekazu and Okada, Ken-ichi and Matsushita, Yutaka},
  booktitle={ Proceedings. 1999 IEEE Symposium on Information Visualization, 1999.(Info Vis' 99) },
  pages={79--82},
  year={1999},
  organization={IEEE}
}

@inproceedings{ballinger2003spreadsheet,
  title={Spreadsheet visualisation to improve end-user understanding},
  author={Ballinger, Daniel and Biddle, Robert and Noble, James},
  booktitle={Proceedings of the Asia-Pacific symposium on Information visualisation-Volume 24},
  pages={99--109},
  year={2003},
  organization={Australian Computer Society, Inc.}
}