Part 3 of the story introduced the formal analysis of spreadsheets that examined how this new technology incorporates other media starting with zero and the Indo-Arabic numerals. The base-10 decimal system, within a positional place-value notation, gave the zero-based numerical system a previously unprecedented calculative ability. Other representational systems in Part 4 include alphabetical writing and list technology. Below, I introduce the importance of the table as an epistemological technology that is empowered by the computerized spreadsheet and is part of a system of knowledge production that has transformed modern forms of bureaucratic and corporate organization.

Bonnie A. Nardi and James R. Miller of Hewlett-Packard Laboratories noted that the effectiveness of a spreadsheet program derives from two major properties: its ability to provide low-level calculation and computational capabilities to lightly trained users and its “table-oriented interface” that displays and organizes information in a perceptual geometric space that shows categories and relationships.[1]

The columnar spreadsheet had an important, if non-distinguished history as the bedrock of the accounting and bookkeeping professions. It became universally more relevant when it was programmed into the first electronic spreadsheet for the Apple II. VisiCalc was created when its co-inventor, Dan Bricklin, needed to make tedious calculations for an MBA course he was taking.

As its name suggests, VisiCalc combines the two most important components of the electronic spreadsheet – visual display and calculative ability. Tables are both communicative and analytical technologies that provide familiar ways to convey relatively simple or complex information as well as structure data so that new dimensional relationships are produced. These became particularly useful for accounting and sales, as well as finance.[1]

The interactivity of the personal computer keyboard and screen was a prominent advantage in the growing popularity of the electronic spreadsheet. It provided immediate feedback and reduced the learning curve of spreadsheet applications like VisiCalc and later Lotus 1-2-3 for the IBM PC and its clones. Getting immediate feedback rather than waiting hours or days to pick up printouts from the computer center made the PC spreadsheets much more valuable than the mainframe (or mini) produced results. PC users could quickly isolate individual cells and input information while applying formulas ranging from simple mathematical calculations to more complex statistical analyses.

Later, the graphical user interface and the mouse made the Apple Mac and Windows-based PCs even more interactive and user-friendly. Initially designed for the Apple Mac, Microsoft Excel emerged as the dominant spreadsheet program. Drop-down menus that could be accessed by the user with a mouse-controlled cursor provided instructions and options to help use the spreadsheet. Users could quickly learn how to complete various “high-level, task-specific functions” such as adding the values of a range of cells or finding the statistical median in a selected range within a column. More about this in the next post on formulas.

Nardi and Miller also pointed to the visual aspects of the spreadsheet. The table combines an easily viewable display format in a simple geometric space. The tabular grid of the computer spreadsheet interface provides a powerful visual format for entering, viewing, and structuring data in meaningful ways. Users could view large quantities of data on a single screen without scrolling. Relationships between variables become discernible due to the table display. This grid facilitates pattern recognition and the ability to isolate specific items. Organized around the intersection of rows and columns at a point called the “cell,” spreadsheets provide relatively simple but critical computational and display solutions for information work.

Tables draw deeply on the meaning-creating capabilities of the list, an integral component of the spreadsheet. The list was one of the first uses of writing and an ancient technology of organization and management for the palace and military. It is a visual technology that produces a verbless and decontextualized organization of concepts or things that creates boundaries between categories and thus organizes knowledge in new ways. In the spreadsheet, lists form the rows and columns of the table. They can isolate individual items or connect them visually to other items, creating new categories and taxonomies.[2] The synergy of this new formulation in the spreadsheet, a conjunction of vertical lists or “columns” with horizontal lists called “rows” creates a powerful new intellectual dynamism for tracking resources and assigning associated values.

Lists and tables are “remediated” in the spreadsheet.[3] In the tradition of Marshall McLuhan, new media can be seen as incorporating and recombining previous media. In other words, the list takes on new significance in the spreadsheet as it is re-purposed horizontally as well as vertically to create the tabular format. The term remediate comes from the Italian remediari and means “to heal.” The list is “healed” as it becomes part of the table because it attempts to provide a more authentic access to reality. In the table, additional dimensions to a list are created, offering new lists and displaying the possibilities of new relationships. The history of media, including spreadsheets, is one of attempting to develop more advanced systems of representation through the process of remediation that strive to provide new and better ways to view and understand the world.

The table acts as a problem-solving medium, a cognitive tool that classifies and structures data and offers ways to analyze it. The rows and columns provide the parameters of the problem, and individual cells invite input and interpretation. The table format also suggests connections, dependencies, and relations between different sets of data. The table makes it easy to discern categories represented in the vertical and horizontal dimensions, scan for individual data values, and get a sense of the range of values and other patterns, such as a rough average.

To recap, the formal analysis of the spreadsheet focuses on the various components of the spreadsheet and how they combine to give it its extraordinary capabilities. The spreadsheet has emerged as both a personal productivity tool and a vehicle for group collaboration. Spreadsheets produce representational frameworks for garnering and organizing labor and material resources. Numerical innovation stemming from the adoption of zero and other systems of mathematical representation has made the computerized spreadsheet a central component of modern life. It has also helped establish the centrality of financial knowledge as the working philosophy of contemporary

In this post, I discuss how spreadsheets, in conjunction with other forms of financial and managerial representation, not only produce the ongoing flows of knowledge that run the modern economy but have created a technologically enhanced epistemology for garnering resources, registering value, and allocating wealth.[4]

Citation APA (7th Edition)

Pennings, A.J. (2016, May 6) Digital Spreadsheets – Part 5 – Ease and Epistemology. apennings.com https://apennings.com/meaning-makers/digital-spreadsheets-power-over-people-and-resources/

Notes

[1] Bonnie A. Nardi and James R. Miller (In D. Diaper et al (Eds.), “The Spreadsheet Interface: A Basis for End-user Programming,” Human-Computer Interaction: INTERACT ’90. Amsterdam: North-Holland, 1990. Spring, 1990.
[2] Jack Goody’s (1984) Writing and the Organization of Society is informative on the use of the list as a historical management tool.
[3] Bolter, J. and Grusin R. (2000) Remediation: Understanding New Media. MIT Press.
[4] Hood, John. “Capitalism and the Zero,” The Freeman: Foundation for Economic Education. N.p., 01 Dec. 2000. Web. 10 Jan. 2015.

Share

© ALL RIGHTS RESERVED

Anthony J. Pennings, PhD is Professor at the Department of Technology and Society at the State University of New York (SUNY) in South Korea. Previously, he taught at St. Edwards University in Austin, Texas and was on the faculty of New York University from 2002-2012. He also taught at Victoria University in Wellington, New Zealand and was a Fellow at the East-West Center in Hawaii in the 1990s.