Comp489 - Honours Project References Light Version

Upcoming conference Notice

FishBrain::EuSpRIG - European Spreadsheet Risks Interest Group (EUSPRIG)
Thursday 24 - Friday 25 July 2003
Theme: 'Building Better Business Spreadsheets - from the adhoc to the quality-engineered'

References

Main Page
I should point out that the opinions expressed here are my own and that I accept no liability for mistakes and/or omissions: caveat lector. A Standard disclaimer applies.
Back

Honours | Calendar | References (Normal) (Formal) (Quick) (Links only) (BibTeX) (Light Toggle)

Total of 142 records found.
Current page is: file:///C:/My Documents/Education/University/public_html/reference.html?HTML=true&
File is: reference_lite.html

Sort by Category, type, title, short_title, author, pub_date, read_date, rank. View rank.

[SOG] Title: Semiology of Graphics
Author(s): Jacques Bertin
Publication Date: (1967) - Publisher: The University of Wisconsin Press.
ISBN: 0-299-09060-4 - Library: QA90 B544 S E
Rating: - Found/Read: 12/03/2002
Comments: A classic work for graphical interface designers. Seems to have alot of stuff on how to visualise things (under statement). Diagrams, Networks, Maps. Author is a Granddad in the visualisation feild. Refer [JB].

[FVSS] Title: Fluid Visualization of Spreadsheet Structures
Author(s): Takeo Igarashi, Jock Mackinlay, Bay-Wei Chang, Polle Zellweger.
Publication Date: (1998) - Publisher: IEEE.
ISBN: 0-8186-8712-6/98
Local: references/fluid-spread-vl98.pdf
Remote: http://www.parc.xerox.com/pollez/papers/fluid-spread-vl98.pdf
Rating: - Found/Read: 09/03/2002
Comments: A paper about visualisation of the invisiable formulas in spreadsheets. Includes:

Dataflow graphs,
Transient visualisation of cells,
Static global views,
Animated dataflow structures,
Semantic navigation of dataflow graphs,
Regular patterns of cell referencing.

14th IEEE Symposium on Visual Languages ,
Halifax, Nova Scotia, Canada ,
September 1st - 4th, 1998 , pp.118-125.
Image: svg

[ECS] Title: Encyclopedia of Computer Science, 4th ed
Author(s): Anthony Ralston,
Edwin D.Relly,
David Hemmendinger.
Publication Date: (2000) - Publisher: Nature Publishiing Group.
ISBN: 0-333-77879-0
Rating: - Found/Read: 12/03/2002
Comments: Good general information/background on spreadsheets.

See also [ERAPI] [HSSF]

[VisAD] Title: VisAD, Java component library
Author(s): Bill Hibbard
Publisher: Space Science and Engineering Center - University of Wisconsin - Madison.
Remote: http://www.ssec.wisc.edu/~billh/visad.html
Rating: - Found/Read: 05/04/2002
Comments: VisAD, a Java Component Library for interactive analysis and visualization of numerical data.
The basic tutorial is here (local).
The complete developers guide is here (local).
Online version of JavaDocs here (local).

[GWAPI] Title: Google Web APIs
Publication Date: (2002) - Publisher: Google.
Local: http://www.soapware.org/directory/4/services/googleApi
Remote: http://www.google.com/apis/
Rating: - Found/Read: 12/04/2002
Comments: Link suggested by Kirk: With the Google Web APIs service, software developers can query more than 2 billion web documents directly from their own computer programs. Google uses the SOAP and WSDL standards so a developer can program in his or her favorite environment - such as Java, Perl, or Visual Studio .NET.
Javadoc available locally.
Proxy server patch from here.
Strange Google soap link.

[CBRL] Title: Corpus-based research into language
Author(s): Nelleke Oostdijk and Pieter de Haan
Publication Date: (1994)
ISBN: 90-5183-588-4 - Library: PE1074.5 C822
Rating: - Found/Read: 18/04/2002
Comments: A book in honour of Jan Aarts, an instigator of "the Nijmegen approach" to corpus linguistics. Includes corpus encoding and tagging, parsing and databases, and the linguistic exploration of corpus data. Identifies a "corpus complier"(pg 13) as being a passive collector and a builder that selects and arranges the records according to a consistent and unambiguous scheme suitable for computer processing.
Corpus editor: take responsibilty for the records and declare all editorial principles. Encode records from a variety of sources in a uniform and consisten manner while statying as close as possilbe to the original.

[VUWC] Title: VUW Corpus Work
Author(s): Graeme Kennedy
Remote: http://www.vuw.ac.nz/lals/
Rating:
Comments: Graeme Kennedy
Corpus Linguistics Research.

[ICL] Title: An introduction to corpus linguistics
Author(s): Graeme D. Kennedy
Publication Date: (1998)
ISBN: 0-582-23153-1 / 0-582-23154-X (pbk.) - Library: P98 K35 I
Rating: - Found/Read: 18/04/2002
Comments: [VUWC] - VUW related work.

[QGL] Title: Quote from G. Leech
Author(s): G. Leech
Rating: - Found/Read: 19/04/2002
Comments: "Those who work with computer corpora are suddenly finding themselves in an expanding universe. For years, corpus linguistics was the obsession of a small group which received little or no recognition from either linguistics or computer science. Now much is happening, and there is a demand for much more to happen in the future." - G. Leech (1991) in 'The state of the art in corpus linguistics'
Quote found in [CBRL].

[EXML] Title: From Excel to XML
Author(s): John E. Simpson
Remote: http://www.xml.com/pub/a/2002/01/09/q-and-a.html
Rating: - Found/Read: 19/04/2002
Comments: Brief intro on how to convert from Excel to XML progromatically. See also: [ERAPI]

[IVN] Title: InfoVis.net
Author(s): Juan Carlos Dürsteler
Remote: http://www.infovis.net/MainPage.htm
Rating: - Found/Read: 24/04/2002
Comments: A web based magazine on information visulissation. Contains links to books, and people active in the field.

[RIV] Title: Readings in Information Visualization : Using Vision to Think
Author(s): Stuart K. Card, Jock D. MacKinlay (Editor), Ben Shneiderman (Editor)
Publication Date: (25/01/1999)
ISBN: 1-558-60533-9
Rating: - Found/Read: 24/04/2002
Comments: "The first book ever explicitly on Information Visualisation. It is a collection of the fundamental publications and articles on the speciality.

The articles are classified by topic and cover the last 15 years of scientific literature on the speciality. An interesting introduction helps to outline what the authors define as Information Visualisation.

Academic or highly technical, if you want, but absolutely fundamental to understand where we come from and where are we heading in InfoVis. Absolutely a must. " - [IVN]

[CL-Ed] Title: Corpus Linguistics
Author(s): Tony McEnery, Andrew Wilson
Publication Date: (09/1996) - Publisher: Edinburgh Textbooks.
ISBN: 0-748-60808-7 - Library: P98 M141 C
Local: hfiles/CL-Ed/
Rating: - Found/Read: 24/04/2002
Comments: Sections of interest:

Early Corpus Linguistics and the Chomskyan Revolution
What is a Corpus and What is in it?
Quantitative Data
The use of Corpora in Language Studies

"Even as a non-computational linguist, I found this book very readable. It covers a nice range of the relevant topics, and is very careful about defining terminology---a practice that other writers in computational linguistics would do well to follow. The book is unusually well-organized. Though there's not much depth of coverage of many topics, the references for further reading are very well selected, and do a lot to make up for this. The final chapter gives a very nice example of the application of empirical data to a theoretical question, and is worth the price of the book itself." - A Reader(Amazon)
Second ed.

Annotation "(i) the practice of adding explicit additional information to machine-readabel text; (ii) the physical representation of such information" - Page 177.
Corpus "(i) (loosly) any body of text; (ii) (most commonly) a body of machine-readable test; (iii) (more strictly) a finite collection of machine-readable text, sampled to be maximally representive of a langauge or variety"

"Let us sum up the arguments against the use of corpus so far. First, the corpus encourages us to model the wrong thing - we try to model performance rather than competence. Chomsky argued that the goals of linguistics are not the enumeration and description of performance phenomena, but rather they are introspection and explantion of linguistic competence. Second, even if we accept enumeration and description as a goal for linguistics, it seems an unattainable one, as natural languages are not finite. As a consequence, the enumeration of sentences can never possibly yield as adequate description of language. How can a partial corpus be the sole explicandum of an infinite language? Finally, we must not eschew introspection entirely. If we do, detecting ungrammatical structures and ambiguous strucutres becomes difficult, and indeed may be impossible." - Page 10.

The study of real language (the practical usage)"Corpus linguistics ia a methodology rather than an aspect of language requiring explanation or description." - Page 2.

[NC] Title: Noam Chomsky
Remote: http://web.mit.edu/linguistics/www/chomsky.home.html
Rating: - Found/Read: 24/04/2002
Comments: Noam Chomsky is a Mathmatician turned Linguistic turned someone influential in computer science, atleast what I remember from comp202 about context free grammers. "Chomsky (1957, 1965), in a series of influential publications, changed the direction of linguistics away from empiricim and towards rationalism in a remarkably short period of time." - [ICL]
Naturally occuring observations or artifically induced observations.
"A rationalist theory is a theory based on artificial behavioural data, and conscious introspective judgements."
"An empiricist approach to language is dominated by the observation of naturally occuring data, typically through the medium of the corpus."

Quotes fron [CL-ED]:
"It is competence rather than performance that the linguist was trying to model." - Page 5.
"As already stated, performance may be influenced by factors other than our competence. For instance, factors as diverse as short-term memory limitations and whether or not we have been drinking can alter how we speck on any particular occasion." - Page 5
"Observing the recursive nature of phrase strucutre rules shows clearly how the sentences of naturla language are not finite" "A corpus could never be the sole explicandum of natural language." "Language is non-enumerable, and hence no finite corpus can adequately represent language." "Corpra are skewed"- Page 8
"Why look through a corpus of a zillion words for facts which may be readily available via introspection?" - Page 9

[NMAPS] Title: newsmaps
Remote: http://www.aurigin.com/aureka.html
Rating: - Found/Read: 26/04/2002
Comments: Link suggested by Michael Richmond.
"It turns out that newsmaps has dropped off the web as a victim of mergers and aquisitions. The backend software is marketed by Aurigin. But, a sample image of newsmaps can be found at" remote. Check out the cool themescape view - "To achieve a 30,000-foot view on innovation assets, the Aureka platform offers a powerful text analysis tool that generates topographical maps based on the words contained in a large collection of patents and other non-patent documents. "

[LAN 01a] Title: A Categorization of Classes based on the Visualization of their Internal Structure: the Class Blueprint
Author(s): Michele Lanza, Stéphane Ducasse
Publication Date: (2001) - Publisher: OOPSLA 2001.
ISBN: 1-58112-335-9/01/10
Local: http://citeseer.nj.nec.com/457299.html
Remote: http://iamwww.unibe.ch/%7Elanza/Publications/PDF/oopsla2001.pdf
Rating: - Found/Read: 16/05/2002
Comments: A paper on using a metrics-visualisation hybrid in reverse engineering of object-oriented models.

[LAN 99] Title: Combining Metrics and Graphs for Object Oriented Reverse Engineering
Author(s): Michele Lanza
Publication Date: (Oct 1999) - Publisher: University of Bern.
Local: misc/lanza-m-diploma.pdf
Remote: http://iamwww.unibe.ch/%7Elanza/Publications/
Rating: - Found/Read: 31/05/2002
Comments: Lanza's original work on combining metrics and visualisation contains good information on the benefits of visualisation.

[RFC1945] Title: RFC 1945 -- Hypertext Transfer Protocol -- HTTP/1.0
Author(s): Tim Berners-Lee, Roy T. Fielding, Henrik Frystyk Nielsen
Publication Date: (May 1996) - Publisher: IESG.
Local: references/rfc1945.html
Remote: http://www.w3.org/Protocols/
Rating: - Found/Read: 16/05/2002
Comments: The Hypertext Transfer Protocol RFC - Don't leave home without it.

[BNC] Title: British National Corpus (BNC)
Publication Date: (1991) - Publisher: Oxford University Computing Services.
Remote: http://www.hcu.ox.ac.uk/BNC/
Rating: - Found/Read: 29/05/2002
Comments: "The British National Corpus is a very large (over 100 million words) corpus of modern English, both spoken and written."
Good general corpus information like What is a corpus?

[UYCS] Title: Using Your Computer's Spreadsheet
Publication Date: (2000) - Publisher: MATHEMATICAL CONCEPTS.
Remote: http://www.mathnstuff.com/math/spoken/here/2class/cspread.htm
Rating: - Found/Read: 29/06/2002
Comments: Some information on Excel syntax

[MRX] Title: MrExcel.com
Publication Date: (2000) - Publisher: MrExcel Consulting.
Remote: http://www.mrexcel.com/articles.shtml
Rating: - Found/Read: 29/06/2002
Comments: Looks terrible, but has some useful information on Excel.

[WSFF] Title: Worksheet Formulas and Functions
Publisher: University of North Texas Computing Center.
Remote: http://www.unt.edu/training/Excel97/Excel97-functions.htm#UsingCellandRangeRefer...
Rating: - Found/Read: 29/06/2002
Comments: More information on Excel syntax. Includes details about reference operators like range(:), union(,), and intersection( )

[DOOUI] Title: Designing Object-oriented user interfaces
Author(s): Dave Collins
Publication Date: (1995) - Publisher: Benjamin/Cummings Publishing Company, Inc..
ISBN: 0-8053-5350-X
Rating: - Found/Read: 01/07/2002
Comments: Defines what constitutes an object-oriented user interface, and presents a methodology for designing both the visible features of the interface and the software structures underlying it.
p.g. 200 "Spreadsheets In a way, spreadsheets are highly specialized forms. They are also structured containers for their cells, which leads to new ideas about what might be in a cell - a picture, a set of objects, a communication link to an information source, etc. Spreadsheet cells can cooperate among themselves to produce all kinds of calculations, summaries, etc.
Many spreadsheets now are 2½ dimensional - that is, they represent stacks of 2-D sheets for different periods, locations, etc."

[EXCEL] Title: Microsoft Excel
Remote: http://www.microsoft.com/office/excel/default.asp
Rating: - Found/Read: 06/07/2002
Comments: Excel is a registered trademark of the Microsoft® Corporation.
Definition/about from [WFE]
Tipsn'Tricks
ExtenXLS Apache Formula

[PL] Title: Power-law
Comments: Ownership - which path you would have to take to reach a certain object.

See Also [ZIPF] [ZIPFT] [Alex's Page] [Image Gallery 39]

[ZIPF] Title: Zipf Law
Author(s): George Kingsley Zipf
Remote: http://linkage.rockefeller.edu/wli/zipf/
Rating: - Found/Read: 10/07/2002
Comments: "Zipf's law, named after the Harvard linguistic professor George Kingsley Zipf (1902-1950), is the observation that frequency of occurrence of some event ( P ), as a function of the rank ( i) when the rank is determined by the above frequency of occurrence, is a power-law function P_i ~ 1/i^a with the exponent a close to unity."
Further Links:
Benford's Law and Zipf's Law

See Also [MMB]

[MSA] Title: Modeling Spreadsheet Audit: A Rigorous Approach to Automatic Visualization
Author(s): Jorma Sajaniemi
Publication Date: (1998) - Publisher: Journal of Visual Languages and Computing.
Remote: references/sajaniemi98modeling.pdf
Rating: - Found/Read: 21/08/2002
Comments: Excellent description of the Excel auditing tools. Provides differen't types of equivalence for spreadsheets, such as copy equivalence. They define homogeneity as "a homogeneous area is an area consisting of similar cells."
Define visualisation as:A visualization is some graphical representation of a spreadsheet supposed to make the structure of the computations in the spreadsheet more readily available for users. A visualization can be superimposed on the spreadsheet display or it can be a separate entity. In the latter case, the visualization may have some user interface mechanism to make the connection between the visualization and the spreadsheet more evident.
See Also citeseer, top-originating areas S2 Visualisation of entities
Download the S2 visualization macro ftp://cs.joensuu.fi/pub/Software/S-visualization. S3 Visualization Tool S2 Visualization Tool

@article{ sajaniemi00modeling, author = "Jorma Sajaniemi", title = "Modeling Spreadsheet Audit: A Rigorous Approach to Automatic Visualization", journal = "Journal of Visual Languages and Computing", volume = "11", number = "1", pages = "49-82", year = "2000", url = "citeseer.nj.nec.com/sajaniemi98modeling.html" }

[SSIBEUP] Title: The Spreadsheet Interface: A Basis for End User Programming
Author(s): Nardi, Bonnie A. Miller, James R.
Publication Date: (1990) - Publisher: HP Labs.
Local: references/HPL-90-08.pdf
Remote: http://www.hpl.hp.com/techreports/90/HPL-90-08.html
Rating: - Found/Read: 21/08/2002
Comments: "Abstract: This paper describes the properties of the user interface of spreadsheet programs and the ways in which spreadsheets support users with little or no formal training in programming. We analyze the spreadsheet formula language through which users express mathematical relations and the tabular grid which permits users to view, structure and display data. Based on our analysis of the formula language and the tabular grid, we argue that user programming environments should be characterized by (1) a small number of carefully chosen, high-level, task-specific operations that are sufficient for building applications within a restricted domain, and (2) a strong visual format for structuring and presenting data. "
citeseer

[PAW] Title: Programmers at Work
Author(s): Susan Lammers
Publication Date: (1989) - Publisher: Tempus Books of Microsoft Press.
ISBN: 1-55615-211-6 - Library: QA76.6.L326
Found/Read: 26/08/2002
Comments: Robert leant me this book to read the chaper on Dan Bricklin.
"In 1978, while still at Harvard, he teamed up with Bob Frankston, an old classmate from MIT, to develop a workable version of the program [an electronic spreadsheet program]. This became VisiCalc."
VisiCalc is the earlist (probably the first) example of the spreadsheet paradigm. Perfromed operation on cells using the A1 addressing system.

"Then I told my production professor: He was very encouraging. He said: "You know, the type of stuff you're talking about, people do on blackboards now when they do production planning. And sometimes they have blackboards that stretch the length of two rooms. And they'll sit there and do the week-to-week planning of this many sold, this many manufactured, this many left. Your program sounds neat." I talked to another professor in accounting, Jim Cash, who encouraged me by saying, "Good human interface is what is really needed in commercial products. It's a big problem in many systems designs." And I thought, this guy really knows what he's talking about."
"INTERVIEWER: Do you think there will continue to be these small types of software operations? Or will the software industry be dominated by a handful of huge companies?
No. People are writing their own programs. Anybody who uses a spreadhseet is writing their own programs; it's just that the language is different now.
Bob Frankston likes to tell a story about the telephone company. Back in the twenties they said that telephones were growing so fast that by 1950 everybody in the country would have to be an operator. By 1950 people said, "Ha, they were wrong." Well, it turned out they were right, because everybody was an operator; they just had dial telephones. The technology made it easy enough to be an operator.
Well, that's the same thing with programming. We're just making the users do more and more of the programming themselves, but they don't know it. ..."
Refers to fonts in an old Macintosh wordprocessor as being sirens that lured users onto the rocks (an unzippy wordprocessor).

See Also [MMB]

[RAMMRRS] Title: Reasoning about Many-to-Many Requirement Relationships in Spreadsheets
Author(s): Beckwith, Laura, Margaret Burnett and Curtis Cook
Publication Date: (Sept 2002) - Publisher: In IEEE Symposium on Human-Centric Computing Languages and Environments, Arlington, VA.
Local: references/hcc02.gridAssertions.pdf
Remote: ftp://ftp.cs.orst.edu/pub/burnett/hcc02.gridAssertions.pdf
Found/Read: 27/08/2002
Comments:

See Also [MMB]

[MSSVDMG] Title: Making Spreadsheets Visual through Direct Manipulation and Gestures
Author(s): Herkimer J. Gottfried, Margaret M. Burnett
Publication Date: (1997) - Publisher: IEEE Symposium on Visual Languages.
Local: references/gottfried97graphical.pdf
Remote: http://citeseer.nj.nec.com/gottfried97graphical.html
Found/Read: 27/08/2002
Comments: Abstract: Until now, attempts to extend the one-way constraint evaluation model of the spreadsheet paradigm to support complex objects, such as colored circles or user-defined types, have led to approaches featuring either a direct way of creating objects graphically or strong compatibility with the spreadsheet paradigm, but not both. This inability to conveniently go beyond numbers and strings without straying outside the spreadsheet paradigm has been a limiting factor in the applicability of...

See Also [MMB]

[DBPSS] Title: Display-Based Problems in Spreadsheets: A Critical Incident and a Design Remedy
Author(s): David G. Hendry
Publication Date: (1995) - Publisher: IEEE Visual Languages.
Local: references/hendry.ps
Found/Read: 27/08/2002
Comments: Abstract:A critical incident is reported where a discretionary user needed to partition the spreadsheet grid into an arithmetic series of blocks and apply a function to each, but was unable to devise a solution. The incident is first scrutinized to explicate the reasons for the failure. Then, a new method for progressional computation on tabular displays is described and reviewed for usability. The method increases the expressive power of cell referencing but also simplifies the notation. The spreadsheet is shown to be a surprisingly poor artefact for three classes of display-based problem.