Spreadsheets are widely used in industry, because they are flexible and easy to use. Often, they are even used for business-critical applications. It is however difficult for spreadsheet users to correctly assess the maintainability of spreadsheets. Maintainability of spreadsheets is important, since spreadsheets often have a long lifespan, during which they are used by several users. In this p...

Previous spreadsheet inspection experiments have had human subjects look for seeded errors in spreadsheets. In this study, subjects attempted to find errors in human-developed spreadsheets to avoid the potential artifacts created by error seeding. Human subject success rates were compared to the successful rates for error-flagging by spreadsheet static analysis tools (SSATs) applied to the same...

Experimental studies have pointed out that operational spreadsheets contain a lot of errors. In this paper, we propose to use a multidimensional rule-based data manipulation language to specify spreadsheets. This language allows formal declarative deenition of spreadsheet tabular data treatments. The main contribution of this paper is to show that from textual rule-based speciications, we can g...

We performed an estimation of longitudinal (T1) and transverse relaxation (T2) time using the general-purpose spreadsheet software Microsoft Excel. The Excel tool "solver" is useful for the simultaneous estimation of both T1 and steady-state magnetization from the non-linear least square method. The estimation time is quick enough for the purpose. T1 and T2 estimated from handwritten semi-log p...

Experimental studies have pointed out that operational spreadsheets contain a lot of errors In this paper we propose to use a multidimensional rule based data manipulation language to specify spreadsheets This language allows formal declarative de nition of spreadsheet tabular data treatments The main contribution of this paper is to show that from textual rule based speci cations we can genera...

This paper describes how a spreadsheet program can assist electromagnetics education at the undergraduate level. Spreadsheet software has proven to be an important pedagogical tool for a variety of problems in electrical engineering education. Using the power of the 123 macros, a menu driven spreadsheet program is used to compute the solution of some electrostatic boundary value problems for an...

This paper describes a framework for a systematic classification of spreadsheet errors. This classification or taxonomy of errors is aimed at facilitating analysis and comprehension of the different types of spreadsheet errors. It is far more comprehensive than any presented or published before. The taxonomy is an outcome of a thorough investigation of the widespread problem of spreadsheet erro...

Courses in information resource management often include discussion and practice in capacity planning. This requires students to understand a variety of topics related to business transaction processing, workload characteristics, system demand, forecasting methods, and system performance measurement. This article presents a student project that combines these topics in a spreadsheet application...