i-nth logo

Authors

Jairus Hihn, Scott Lewicki, & Belinda Wilkinson

Abstract

Spreadsheets, spreadsheets everywhere and nary a page of documentation. JPL is NASA's prime center for deep space missions. In all of our missions, spreadsheets have played a major role in managing parts lists, managing requirements, monitoring progress, planning budgets, developing the initial concept designs, and providing the backbone of our infrastructure.

In this paper we will share our lessons learned in building various spreadsheet intensive systems and applications. Based on our experience in developing and using these various systems we will propose a number of exploratory ideas as to the dimensions of spreadsheet system complexity. In addition, we will share our approaches to documentation, review, and verification of these types of systems.

Sample

SMART system overview
SMART system overview

Software Measures Archiving and Reporting Tool (SMART), is a metrics system that helps a software manager plan a task, track and communicate the status of the task, and make decisions.

SMART consists of a metrics repository, a management dashboard containing charts based on an analysis of the metrics, and planning and cost models.

Publication

2009, 42nd Hawaii International Conference on System Sciences, December, pages 1-9

Full article

How spreadsheets get us to Mars and beyond