Skip to main content
SpringerLink
Log in

SheetGit: A Tool for Collaborative Spreadsheet Development

  • Conference paper
  • First Online:
Software Technologies: Applications and Foundations (STAF 2016)

Part of the book series: Lecture Notes in Computer Science ((LNPSE,volume 9946))

  • 841 Accesses

Abstract

Spreadsheets play a pivotal role in many organizations. They serve to store/manipulate data, and are often used to help in the decision process of organizations, thus having a direct impact on their success.

As the research community already realized, spreadsheets tend to have the same issues “professional” software has.

One of the most used mechanisms to manage software projects is version control. Thus, we present a version control system oriented for end-user programmers. It allows for seamless and risk-free collaboration between users, to graphically visualize the history of spreadsheet versions, to switch between different versions just by pointing and clicking, and to visualize the differences between two spreadsheets in an animated way.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Notes

  1. 1.

    http://github.com/nicoespeon/gitgraph.js.

  2. 2.

    https://products.office.com/en-us/sharepoint/.

  3. 3.

    https://www.google.com/sheets/.

  4. 4.

    https://xltools.net/.

  5. 5.

    https://www.pathio.com/.

References

  1. Atlassian: Bitbucket. https://bitbucket.org/. Accessed 03 Mar 2016

  2. Bradley, L., McDaid, K.: Using Bayesian statistical methods to determine the level of error in large spreadsheets. In: 31st International Conference on Software Engineering-Companion, ICSE-Companion 2009, vol. 2009, pp. 351–354. IEEE (2009)

    Google Scholar 

  3. Chambers, C., Erwig, M., Luckey, M.: SheetDiff: a tool for identifying changes in spreadsheets. In: 2010 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC), pp. 85–92, September 2010

    Google Scholar 

  4. Deloitte: spreadsheet management: not what you figured (2009). http://www2.deloitte.com/us/en/pages/audit/articles/spreadsheet-management.html. Accessed 18 Jan 2016

  5. GitHub, Inc.: Github. https://github.com/. Accessed 03 Mar 2016

  6. Kuttal, S.K., Sarma, A., Rothermel, G.: On the benefits of providing versioning support for end users: an empirical study. ACM Trans. Comput. Hum. Interact. 21(2), 901–943 (2014). http://doi.acm.org/10.1145/2560016

    Article  Google Scholar 

  7. Mitchell, L.: You’re not using source control? Read this! (2014). http://www.lornajane.net/wp-content/uploads/2013/01/source-control-whitepaper-v1.1.pdf. Accessed 11 Jan 2016

  8. Panko, R.R.: What we know about spreadsheet errors. J. Organ. End User Comput. (JOEUC) 10(2), 15–21 (1998)

    Article  Google Scholar 

  9. Panko, R., Halverson, R.P.: Spreadsheets on trial: a survey of research on spreadsheet risks. In: Proceedings of HICSS-29, 29th Hawaii International Conference on System Sciences, vol. 2, pp. 326–335 (1996)

    Google Scholar 

Download references

Acknowledgements

This work has been partially supported by NOVA LINCS through the FCT project with reference UID/CEC/04516/2013.

Author information

Authors and Affiliations

  1. NOVA LINCS, DI, FCT, Universidade NOVA de Lisboa, Lisbon, Portugal

    Ricardo Moreira

Authors
  1. Ricardo Moreira
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Ricardo Moreira .

Editor information

Editors and Affiliations

  1. Dipartimento di Informatica, Universita di Pisa, Pisa, Italy

    Paolo Milazzo

  2. Budapest University of Technology and Economics, Budapest, Hungary

    Dániel Varró

  3. Vienna University of Technology, Vienna, Austria

    Manuel Wimmer

Rights and permissions

Reprints and permissions

Copyright information

© 2016 Springer International Publishing AG

About this paper

Cite this paper

Moreira, R. (2016). SheetGit: A Tool for Collaborative Spreadsheet Development. In: Milazzo, P., Varró, D., Wimmer, M. (eds) Software Technologies: Applications and Foundations. STAF 2016. Lecture Notes in Computer Science(), vol 9946. Springer, Cham. https://doi.org/10.1007/978-3-319-50230-4_32

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-50230-4_32

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-50229-8

  • Online ISBN: 978-3-319-50230-4

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation