clear clear clear clear clear clear clear clear clear clear
   
Home
About EuSpRIG
EuSpRIG 2017 Annual Conference
EuSpRIG 2017 Programme
Register for EuSpRIG 2017 Conference
Basic Research
Best Practice
Horror Stories
Regulators' Presentations
Conference Abstracts, Papers & Indexes
Conference Reports & Videos
Delegates
   
Constitution
History
Our Talks & Presentations
Quotable Quotes
Press & Website
Committees
Yahoo Group
Training Videos
Humour
Sponsors
Useful Links
Contact
EuSpRIG Home
clear clear clear clear clear clear
           
    PAPERS & PRESENTATIONS FROM EuSpRIG 2016      
             
    Formal papers will be uploaded to arxiv.org soon. Here are links to the presentations:

“Teaching methods are erroneous: approaches which lead to erroneous end-user computing” Mária Csernoch highlighted boring textbooks that teach Excel following the Ribbon interface, rather than working from simple to advanced problems. She liked the Walkenbach books because they show array formulas, and urged the adoption of the Hungarian Sprego syllabus for teaching Excel in schools using few building blocks including array formulas.
http://www.eusprig.org/mcsernoch-2016.pdf

“Characteristics of Spreadsheets Developed with the SSMI Methodology” by Paul Mireault described the way he teaches how to structure spreadsheets. His architecture separates interface from calculation, simple formulas with few operators, and makes extensive use of range names for constants and rows of data. He advocates drawing a data flow and process diagram first so that you really understand how the solution should be organized before you starting writing formulas.
http://www.eusprig.org/pmireault-2016.pdf

“A Programmatic Approach to the development of Solutions in Excel” by Peter Bartholomew took the challenge of using range names to its ultimate conclusion. Against those who deprecate the use of names, he uses only names, and his rewriting of a FAST debt repayment model shows that it can be done. One advantage of this is that documenting the formulas becomes as easy as listing the names.
http://www.eusprig.org/pbartholomew-2016.pdf

“A Conceptual Model for Measuring the Complexity of Spreadsheets” by Thomas Reschenhofer presented a number of possible complexity metrics from analogies with software engineering and linguistics, such as the ratio of formula cells, and the numbers of precedents and dependents. I look forward to his extending the work to establish which of them form a sufficient set of metrics which can be efficiently derived.
http://www.eusprig.org/treschenhofer-2016.pdf

“A Pilot Study Exploring Spreadsheet Risk in Scientific Research” is a student paper by Ghada AlTarawneh, presented by Simon Thorne. He presented the results of interviews with researchers about their use of spreadsheets and their perception of risk.
http://www.eusprig.org/sthorne-2016.pdf

“The use of the Power Query / Get & Transform tools in Excel” by Simon Hurst was one of the rare excursions into data analysis in Excel. This is a column-oriented world rather than the row-oriented world inhabited by financial modellers. He showed how Power Query can be many times more efficient at handling large amounts of data than the common practice of VLOOKUP for data matching. He demonstrated how to consolidate account balance data from several separate Excel workbooks and use the consolidated data to create a structure management report.
http://www.eusprig.org/shurst-2016.pdf

We finished up with a general discussion of the direction of Eusprig and how we could publicise the event better, and how we can attract a broader audience. Do please give us your opinion on this.

Please sign up to our moderated Eusprig discussion forum to continue the discussion.  Simply send a blank email to

image
     
             
           
    Our Sponsors      
F1F9University of Wales Institute Cardiff CIMCON Software
C
oralityThe University of Greenwich Institute of Chartered Accountants in England and WalesInfotronInfotron
Isaca Northern IrelandAuditNetSystems Modelling Ltdoperis
   
         
Web Design by KINET e-Solutions