Javelin Software

Javelin Software Corporation (1984–1988) was a company in Cambridge, Massachusetts, USA, which developed an innovative modeling and data analysis product, also called ''Javelin'' (versions 1.0 in 1984 to 1.1), and later ''Javelin Plus'' (versions 1.0 in May 1987 to 3.5 in 1993). Seen as the successor technology to spreadsheet software in reviews of the time, and rival to the then-dominant ''Lotus 1-2-3'', Javelin won numerous industry awards, including beating Microsoft's new ''Excel'' for the InfoWorld Software Product of the Year award.

Javelin Software fell on difficult times when its initial public offering had to be cancelled due to it being scheduled for only a few days after the stock market crash of 1987. The company's assets were later purchased by Information Resources, Incorporated (IRI), which sold enhancements to ''Javelin'' until 1994 when IRI was itself purchased by Oracle Corporation, which promptly discontinued the product.

Unlike models in a spreadsheet, ''Javelin'' models are built on objects called variables, not on data in cells of a report. For example, a time series, or any variable, is an object in itself, not a collection of cells which happen to appear in a row or column. Variables have many attributes, including complete awareness of their connections to all other variables, data references, and text and image notes. Calculations are performed on these objects, as opposed to a range of cells, so adding two time series automatically aligns them in calendar time, or in a user-defined time frame.

Data are independent of worksheets—variables, and therefore data, cannot be destroyed by deleting a row, column or entire worksheet. For instance, January's costs are subtracted from January's revenues, regardless of where or whether either appears in a worksheet. This permits actions later used in pivot tables, except that flexible manipulation of report tables is but one of many capabilities supported by variables. Moreover, if costs are entered by week and revenues by month, Javelin can allocate or interpolate as appropriate. This object design enabled variables and whole models to reference each other with user-defined variable names, and to perform multidimensional analysis and massive, but easily editable consolidations.

''Javelin'' encourages viewing data and algorithms in various self-documenting ways, including simultaneous multiple synchronized views. For example, users can move through the connections between variables on a diagram while seeing the logical roots and branches of each variable. This is an example of what is perhaps its primary contribution—the concept of traceability of a user's logic or model structure through its twelve views. Among its dynamically linked views were: diagram, formulas, table, chart, QuickGraph, worksheet, notes, errors, macro and graph. A complex model can be dissected and understood by others who had no role in its creation, and this remains unique even today.

The second fundamental advance in ''Javelin''s design is extensive built-in time series modeling, including calendar intelligence.

''Javelin'' was used primarily for corporate and governmental financial modeling, but was also used to build instructional models in college chemistry courses, to model the world's economies, and by the military early in the "Star Wars" project. It is still in use by institutions for which model integrity is mission critical.

''Javelin'' received multiple awards, including "Best of 1985" for technical excellence from ''PC Magazine'', "Most Significant Product" from '' PC Week'' and "Software Product of the Year".

The ''InfoWorld'' award apparently created some consternation in the top ranks of number two Microsoft:

''Javelin'' was conceived by co-founder Rob Firmin, chairman and CEO, whose University of Chicago doctorate research and subsequent financial planning work at Prime Computer led him to creation of the concepts. His co-founder, Stan Kugell, president, worked with Firmin on the user interface. The ''Javelin'' development team was led by Christopher Herot, vice president of engineering, and included Charles Frankston, brother of the spreadsheet co-inventor Bob Frankston, Arye Gittelman, John R. Levine, Louise Cousins (Pathe) and Peter Pathe.

Some parts of ''Javelin''s approach were later used by other products such as Lotus's ''Improv''. Lotus essentially copied two ''Javelin'' features (named data arrays and pivot tables) onto a NeXTSTEP-based and later Windows-based GUI to create ''Improv''. Since ''Improv'' was not based on 1980s MS-DOS technology, it suffered less memory-based limitations than ''Javelin'', though ''Javelin'' performed well with DOS extended and expanded memory.

While its business failure has been attributed to the infancy of business GUI software at the time, as well as an ill-conceived marketing plan that placed it head to head with the popular spreadsheet ''1-2-3'',
enterprise-wide financial models converted into ''Javelin'' models at times strained the PC resources of the day. Despite this, it remained a standard for financial modeling and econometrics for several years after it was discontinued by Oracle. For example, the World Bank modeled the world's economies in ''Javelin'' and distributed them in ''Javelin'' format for a number of years.

References

{{reflist, refs=
{{Cite web, url=https://winworldpc.com/product/javelin/plus-10, title = Javelin Plus 1.0
{{Cite web, url=https://books.google.com/books?id=jE2OlZ9PkrkC&pg=PA148, title = PC Mag, date = 27 October 1987, via=Google Books
{{Cite web, url=https://books.google.com/books?id=_7aEwukQQ0AC&pg=PA19, title=PC Mag, date=15 March 1994, via=Google Books
{{cite magazine , url=https://www.pcmag.com/article2/0,1759,1167677,00.asp , title=The 2nd Annual Awards (1985) , magazine=PC Magazine , access-date=2007-09-30 , date=2002-03-12
{{cite web , url=http://archive.infoworld.com/pageone/news/features/anniversary/98ann.backstage.shtml , title=Backstage: InfoWorld's movers and shakers , author-first=Scott , author-last=Mace , publisher= InfoWorld Media Group Inc. , date=1998 , access-date=2007-09-30 , archive-url=https://web.archive.org/web/20070611171523/http://archive.infoworld.com/pageone/news/features/anniversary/98ann.backstage.shtml , archive-date=2007-06-11
{{cite web , url=http://www.cs.umd.edu/class/spring2002/cmsc434-0101/MUIseum/applications/spreadsheethistory2.html , title=Historical Background of Spreadsheets , author-first=Christopher , author-last=Browne , date=Spring 2002 , url-access=subscription

External links

Original advertisement explaining some capabilities

Javelin on the Computer Chronicles public television show
at 10:00 minute mark





Defunct software companies of the United States
Defunct companies based in Massachusetts
Companies based in Cambridge, Massachusetts
American companies established in 1984
Software companies established in 1984
Software companies disestablished in 1988
Spreadsheet software