this study present several examples of using Excel spreadsheets to and simulate physical phenomena, namely projectile motion, falling motion in The air, wave function particles a one-dimensional box, nuclear radioactive decay. Spreadsheets are used analyze the projectiles with without resistance, objects different terminal velocities, graphs functions probabilities values n, i.e. n=1 n=4, decay...

Spreadsheets are widely used in industry, because they are flexible and easy to use. Often they are used for business-critical applications. It is however difficult for spreadsheet users to correctly assess the quality of spreadsheets, especially with respect to the understandability. Understandability of spreadsheets is important, since spreadsheets often have a long lifespan, during which the...

Spreadsheets are widely used in industry. Companies take important decisions based on information coming from spreadsheets. But, spreadsheets also suffer from typical software maintenance issues. Previous research shows that they contain code smells, lack documentation and testing, have a long live span and during this life span are transferred multiple times from one user to another. To obtain...

This management paper looks at the real world issues faced by practitioners managing spreadsheets through the production phase of their life cycle. It draws on the commercial experience of several developers working with large corporations, either as employees or consultants or contractors. It provides commercial examples of some of the practicalities involved with spreadsheet use around the en...

Spreadsheet programs, artifacts developed by non-programmers, are used for a variety of important tasks and decisions. Yet a significant proportion of them have severe quality problems. To address this issue, our previous work presented an interval-based testing methodology for spreadsheets. Interval-based testing rests on the observation that spreadsheets are mainly used for numerical computat...

Refactoring is a change made to the internal structure of software to make it easier to understand and cheaper to modify without changing its observable behaviour. A database refactoring is a small change to the database schema which improves its design without changing its semantics. The paper shall present example ‘spreadsheet refactorings’, derived from the above and taking into account the ...

The use of process management technology constitutes a salient factor for a multitude of business domains as it particularly addresses the flexibility demands of the digital enterprise. Still, spreadsheet applications are more likely to be used in many scenarios in which process management technology appears to be a more appropriate solution. Especially in the context of human-centric and knowl...

Spreadsheet software is the tool of choice for ad-hoc tabular data management, manipulation, querying, and visualization with adoption by billions of users. However, spreadsheets are not scalable, unlike database systems. We develop DATASPREAD, a system that holistically unifies databases and spreadsheets with a goal to work with massive spreadsheets: DATASPREAD retains all of the advantages of...