Validating the unit correctness of spreadsheet programs

[Wikipedia] Testing conducted internally by the manufacturer, alpha testing takes a new product through a protocol of testing procedures to verify product functionality and capability. Anomalies may be found during, but not limited to, reviewing, testing, analysis, compilation, or use of software products or applicable documentation.

[IEEE] An application programming interface (API) is an interface in computer science that defines the ways by which an application program may request services from libraries and/or operating systems.

[ISTQB]Testing practice for projects using agile methodologies, such as extreme programming (XP), treating development as the customer of testing and emphasizing a test-first design paradigm. [ISTQB] A software testing practice that follows the principles of agile software development.

Agile testing does not emphasize testing procedures and focuses on ongoing testing against newly developed code until quality software from an end customer's perspective results.

The process of comparing the program to its initial requirements and the current needs of its end users.

It is an unusual type of test in that it is usually performed by the program's customer or end user, and normally is not considered the responsibility of the development organization. Myers] Testing carried out informally; no formal test preparation takes place, no recognized test design technique is used, there are no expectations for results and arbitrariness guides the test execution activity.

~ Oxford Dictionary of Computing The process of transforming a mental plan of desired actions for a computer into a representation that can be understood by the computer. Users create a "tope" to describe rules for recognizing and reformatting a certain kind of data, such as phone numbers, and then associate a tope with spreadsheet cells, web form textfields, web macro variables, or other fields.

Examples of end-user programmers include graphic designers, owners of mom-and-pop businesses, secretaries, and physicists. Available at as: Marc Fisher II and Gregg Rothermel.

This page is a collection of materials, resources, and programs about end-user software engineering.

When end users develop software, they do more then just program. London: Academic Press, 1990, 139-156.) Here are the currently active conferences and journals most likely to contain papers relevant to end-user software engineering, roughly in order by likelihood.

Download Development & Validation Process for Analyse-it for Microsoft Excel (.pdf) Evaluating the Numerical Accuracy of Analyse-it For purposes of U. Food and Drug Administration (FDA) validation, Analyse-it for Microsoft Excel should be considered off-the-shelf software.

For that reason Analyse-it is not directly responsible for compliance with FDA regulations. To that end, you should read this document to assess the adequacy of our software development process and determine what, if any, additional efforts you need to take to establish that the software is validated for the intended use.


Leave a Reply