B. Ronen, M. A. Palley, and Henry C. Luca. Spreadsheet analysis and design. Communications of the ACM, 32(1):84--93, 1989.  Home/Search   Document Not in Database   Summary   ACM   TOC   Related Articles   Check

....et al. s, in which even expert users could find only about 50 of the faults placed in their spreadsheets [13] There have been attempts to reduce the number of faults in spreadsheets. Many of these attempts are proposals to apply common software development practices. For example, Ronen et al. [24] propose a structured approach to designing spreadsheets. Their approach includes a proposed layout of the spreadsheet model and a spreadsheet flow diagram similar to the data flow diagrams in structured analysis that encourage structured top down design. Another approach is for the spreadsheet to ....

B. Ronen, R. Palley, and H. Lucas, "Spreadsheet Analysis and Design," Communications of the ACM 32 (1), 84-93, Jan. 1989.

....3) This was a flexible analytical tool that gave non programmers the ability to perform complex data analysis on nontrivial volumes of data. The real impact of this program was that it allowed users to develop their own data models, as opposed to relying on someone else s programming skills [52]. It also gave users the ability to perform speculative analysis of data quickly and easily. This could be useful, for example, in forecasting the repercussions of a particular financial decision such as raising the profit margin. VisiCalc based its user interface metaphor on the journals and ....

....the user s first hands on experience with a computing device of any kind. This also includes the first handson experience with many disciplines which are, for most other computer users, normally acquired through training. These include such critical disciplines as programming and documentation [52]. Work by Isakowitz, Schocken and Lucas [23] indicates that 25 of a sample of spreadsheets collected from ten large organizations contained errors. Isakowitz, Schocken and Lucas also mention several studies that conclude that spreadsheet errors are not only prevalent, but also elusive. ....

[Article contains additional citation context not shown here]

B. Ronen, M. A. Palley, and H. C. Lucas, Jr. Spreadsheet analysis and design. Communications of the ACM, 32(1):84--93, January 1989.

.... There has also been studies of individual spreadsheet users at their work settings (Green and Hendry, 1993, Hendry and Green, 1994) and some studies concentrating on spreadsheet errors during development (Brown and Gould, 1987, Doyle, 1990, Lerch et al. 1989, Panko and Halverson Jr, 1994, Ronen et al. 1989). Panko (1997) has collected a web site (Spreadsheet Research, SSR) to gather information of research on spreadsheet development, testing, use, and technology. The web site contains, e.g. lots of references to spreadsheet errors in practical every day usage. The number of erroneous spreadsheets ....

Ronen, B., Palley, M. A. & Lucas, H. C. J. (1989). Spreadsheet Analysis and Design.

....the user divides logically grouped data into smaller physical clusters in order to see and understand the workings of the application. Third, there are errors due to limitations of the current spreadsheet calculation model. For example, naming the cells is the only way to structure computations (Ronen, Palley, Lucas 1989), the specification of absolute and relative cell referencing is vague (Sajaniemi 2000, Doyle 1990) and the connection between the computation and the data is established by referencing to locations in a sheet, Tukiainen ii PPIG 2000, Cozenza Italy www.ppig.org not the actual data structures ....

....and the data is established by referencing to locations in a sheet, Tukiainen ii PPIG 2000, Cozenza Italy www.ppig.org not the actual data structures in the model. These reasons for errors have been attributed to the low conceptual level of current spreadsheet systems (Lewis Olson 1987; Ronen et al. 1989). The low conceptual level of current spreadsheet systems manifests itself especially in the absence of the connection between the computation in the large and the data areas. The spreadsheet user enters formulae once and is supposed to remember to make changes to the referenced addresses if the ....

Ronen, B., Palley, M. A., & Lucas, H. C. J. (1989). Spreadsheet Analysis and Design.

....one cell it is possible only to request arrows that show one dependence level. The dataflow graph tool draws a graph using different symbols to categorize cells as input, output, decision variables, parameters, or formulas. This graph is similar to the graph suggested by Ronen, Palley and Lucas [28], however it is generated automatically by the system instead of being drawn by the user. Our testing and debugging methodology utilizes dataflow arrows similar to those used by Excel and Davis s tools. Unlike Excel arrows, however, our dataflow arrows allow users to display an entire slice at ....

B. Ronen, M.A. Palley, and H.C. Lucas. Spreadsheet analysis and design. Communications of the ACM, 32(1):84--93, January 1989.

....been to add built in functions, to improve the user interface, and to provide additional output options (2 and 3d charts, graphs, etc. The programming power of the spreadsheet, however, has not changed significantly. This is probably because the spreadsheet is primarily a user programmed tool [RPLJ89], not one that is programmed by professional staff. 2.2 Research Applications In the literature, there has been some work that encompasses spreadsheets or their derivatives. Du and Wadge [DW90] DW88] have developed a three dimensional spreadsheet based on intensional logic. This spreadsheet has ....

Boaz Ronen, Michael A Palley, and Henry C Lucas Jr. Spreadsheet analysis and design. Communcations of the ACM, 32(1):84--93, January 1989.

....that automatically created visualizations of computational structures can be used to highlight anomalies that show that a potential error exists and where it can be found. Spreadsheet visualization tools (e.g. Davis, 1996; Hendry Green, 1993; Isakowitz al. 1995; Lakshmanan al. 1998; Ronen al. 1989) have been developed for various purposes: error detection, debugging, comprehension, documenting, etc. As a result, the amount of user assistance may vary from tool 2 to tool. For example, Lakshmanan al. 1998) ask the user to specify the lay out of the spreadsheet in order to build ....

....of the FFR model above. It does not make use of any naming or protection information except in arrow descriptions. 24 3. 5 On line Data Dependency Diagrams The other auditing tool suggested by Davis (1996) on line data dependency diagrams, is based on spreadsheet flow diagrams introduced by Ronen al. 1989) for documenting spreadsheet designs. While spreadsheet flow diagrams are supposed to be constructed by users, on line data dependency diagrams are supposed to be generated automatically. Visualization. The visualization is not superimposed on the spreadsheet display but is presented as separate ....

[Article contains additional citation context not shown here]

Ronen, B., Palley, M. A. & Lucas, H. C. Jr. (1989) Spreadsheet Analysis and Design. Communications of the ACM, 32(1), 84-93.

No context found.

B. Ronen, M. A. Palley, and Henry C. Luca. Spreadsheet analysis and design. Communications of the ACM, 32(1):84--93, 1989.

No context found.

Ronen, B., R. Palley, and H. Lucas. "Spreadsheet Analysis and Design." Communications of the ACM 32.1 (Jan. 1989): 84-93.

No context found.

Boaz Ronen, Michael Palley, and Henry Lucas. Spreadsheet analysis and design. Communication of the ACM, 32(1):84--93, January 1989.

Online articles have much greater impact   More about CiteSeer.IST   Add search form to your site   Submit documents   Feedback  

CiteSeer.IST - Copyright Penn State and NEC