The Codist - Programmerthink

Apple's Numbers Spreadsheet - Like My Trapeze Spreadsheet But 20 Years Later

Posted: 08/07/2007, Perm Link Readers: 3307


It's interesting looking at the features and marketing behind Apple's new Numbers Spreadsheet (just added in iWork 08). So familiar to me as I and the rest of Data Tailor (Bob Murphy, Ken Clark) in 1987 released Trapeze, a spreadsheet program for the Mac with a lot of the same features (and some different).

Like Numbers, Trapeze featured smart tables (which we called blocks), charts (2D and 3D), graphics and text, all freely movable around a canvas (which we called a sheet). Blocks were related by name (either the whole block, or tables where each column had a subname). Smart resizing occurred when you change related block sizes (i.e. add rows to a block and all dependent blocks resized and shifted location if necessary).

The big difference visually of course is a 20 year newer UI, I had to build mine in the old Quickdraw, supporting only 8 colors, and running on a 8mhz 68000. Still it worked well enough that 13,000 people bought a copy before the second owner (we sold the company to someone else) eventually phased it out in 1990. I still get emails from people who miss it, a testament to its power way before the hardware really caught up. One user kept old Macs around for 10 years just to run Trapeze, which was the basis of his business modeling practice.

So it's with gentle humor that I read the Apple marketing stuff and remembering how we said much of the same things with one glaring problem: in those days we couldn't import Excel files and have it fit into our block model, and thus many people couldn't get over that hurdle. Those who saw the power of Trapeze to build large interactive models and present them in one document were able to do amazing things not possible in any other spreadsheet. But Excel killed every spreadsheet program, not just ours. Such is life.

Our solution would have been to build a spreadsheet block, exactly like what Apple has done, except we were never able to invest the time, and eventually we worked on Deltagraph which made the publisher way more money. Trapeze faded into obscurity. Until today, sort of.

So congrats to Apple for reinventing the concept in a new modern package. Better 20 years late then never!

Robert MacLeay 08/08/2007 01:12

AND it had a better function set than Excel has even today!

I even used it for desktop publishing before Quark came along.

Running on System 6 it was great, but it never worked right under System 7.

Jim Harrison 08/08/2007 07:26

There were a number of great ideas in competing software packages in the late '80s and early '90s, before they were killed off by MS Office. It's interesting to speculate what the world might be like if a standard data container (OpenDoc) had been successful in preventing proprietary file lock-in and allowed multiple tools to continue to compete based on UI, etc. In any case, it's great to see worthy ideas from that time reappear.

codist 08/08/2007 09:30

I also contributed to Persuasion, a presentation app from Aldus/Adobe that ultimately got killed off by Office having Powerpoint in it for "free".

Art Busbey 08/08/2007 09:42

Using the block design and matrix algebra I had some really elegant multivariate stat sheets running - far easier to understand and implement than in Excel. I also miss Trapeze... so elegant and obvious (IMHO).

Stephen 08/08/2007 13:17

You must mean 8 bit color. My Mac II did 256 colors in 1987. Now it has 24 bit color. It also does 8 bit gray, something my PC still doesn't do.

Does color matter much to a numeric spreadsheet? Did it create graphs? CGA would have been enough for that. Was there a DOS port?

codist 08/08/2007 14:44

No the original quickdraw color model was 3 bit color, I wrote to that spec in 1986. Once color was actually shipped they added a real 8 bit color model later on in 1987. Color at the time was new. It was useful for presentation of data (like charts) which was one of Trapeze's strengths. At the time spreadsheets were used for analysis only. Still even with our color support most printers were still black and white.

Mac version only.

David Foster 08/08/2007 22:24

I am so excited. I was one of those 13,000 users of Trapeze in the 1987-1989 era and have always missed the program. I did some amazing stuff with the program handling data from plate readers while a scientist at Genentech. It took awhile to learn, but for many tasks it was much more adaptable than Excel and it excelled at generating appealing output. I discovered the old manual and a floppy the other day while rummaging around in a very old box and must admit I wished I could have pushed the disk into my MacPro (an absolute impossibility of course) and played around with it again. I am excited that perhaps I can do far better than that now. I can predict that most Excel power users will find this program perplexing and many won't get it unless they approach it from a new perspective and build anew, discarding their past worksheets. It may be too much to hope that the Excel generation will take the effort, but at least the millions now being introduced to Mac computing may have the opportunity to discover there is more than one way to skin a spreadsheet.

codist 08/08/2007 23:49

I don't have a copy of Trapeze anymore. There is a macplus emulator called "vMac" (a couple of versions exist) but I don't know if it works on Tiger.

Michael Toy 08/10/2007 14:48

When I heard about Numbers I said to myself "Sounds like Trapeze, finally". I'm one of the 13,000 (in fact i just looked, i still have my manual and floppies) and have missed Trapeze ever since my Macs grew up enough to no longer be able to run Trapeze.

Trapeze was "insanely great", I salute you and your co-developers. I'll be thinking of you, and silently thanking you, every time I stretch out a block of data in Numbers.

codist 08/12/2007 18:29

There were many times during the past years I wanted to write Trapeze over again. Guess I don't need to now. Of course Trapeze had more features than Numbers, but writing it just for fun now would be too much work...

Nelson Byrne 08/13/2007 16:58

Michael Toy: "Trapeze was "insanely great", I salute you and your co-developers."

I second that. It made nice graphs, too. The auto block resizing was wonderful. One could include text blocks for comments and explanation. The formulas were SOO easy to use and easy to understand and explain. I don't think Excel ever had a Gudermannian function, by the way.

Blocks would reveal their names with cmd-y, very handy. Ah, we miss it today.

And it was a database handler too.

It was the single best app I ever owned.

About all it lacked was cell phone capability.

(I also used and liked Persuasion before it got eaten by someone - Aldus?)

(and I used DeltaGraph a lot after Trapeze)

Kudos to the developers. You must all still be very proud.

GrahamW 08/13/2007 17:19

Another ex-Trapeze user. Have been lamenting lack of independent blocks ever since... funny how it's now twenty &^%$# years!

Bob Murphy 08/13/2007 20:33

Andrew came up with the basic idea for the program, which was to have growable blocks and layout capabiities. For at least the first major version, he also did the entire user interface, and all graphics, including the charts. Ken did a lot of underlying guts, like memory management and the calculation ordering (which, if I'm not mistaken, was the first natural-order approach to spreadsheet-type calculations). And I did the formula parser and the block-based calculations.

That's pretty funny about the Gudermannian. I threw it in as a joke - never thought anyone would actually pay attention to it. :-) Anyway, it's nice to hear people still like Trapeze!

king 08/18/2007 00:15

i searched for screenshots ofthis program yet i couldnt find any,

can u provide some?

codist 08/18/2007 11:21

I haven't been able to run Trapeze in like 15 years, so the only screen shots are in the old manual I still have, which aren't very useful.

Gary Lang 08/19/2007 20:59

I installed Numbers yesterday and wondered if anyone would remember Trapeze. I always thought Trapeze was a work of art, and was surprised to see these useful notions finally come out again.

And bobert - where are you? Give me a buzz.

Rob Beynon 08/29/2007 16:17

I used to use Trapeze to write highly specific and valuable laboratory tools. The control of tables, the ability to break away from rows and columns, and the functions - matrix arithmetic for example. It was so far ahead of its time that the learning curve was a bit steep, and Excel won over, against common sense and logic. But, if it ever came back again...I still have the Trapeze manual for sentimental reasons.

Gavnodes 09/09/2007 07:30

I was another Trapeze fan who was sorry to see it go. I kept my manuals and floppies around in the hope it would reappear, but it never did (now I know why!).

I'm glad Apple has taken up the baton, as it were. It's just a pity you're not getting the recognition you richly deserve for it.

Gav

Steve Wille 09/09/2007 21:51

One problem with running Trapeze in modern simulator environments is that I think it is not 32-bit clean (for those of you that remember that MacOS issue).

To me, the similarity between Trapeze and Numbers is superficial. The real power of Trapeze was in the formula-per-block concept and the clever way in which block sized themselves based on the inputs, all of which are foreign to Numbers.

Sitting on my to-do someday list is to write a new modern freeware or shareware Mac application that borrows these brilliant aspects of Trapeze's design. I wish the source for Trapeze had been released into the public domain when it was mothballed. It a shame that this work is just sitting there gathering dust or was destroyed.

Another possibility might be for Apple to bolt-on these sorts of features in a future version of Numbers. This might be done with little disruption to the current functionality (basically a table could have a single formula or per-cell formulas). It would be nice to have Trapeze's power living inside the high-quality and feature-rich graphic canvas implemented in Numbers.

codist 09/10/2007 14:53

I don't even have a copy of the source anymore. I do still know the core functionality so I'm sure I could rebuild it again, give suitable resources. But it's too complex to do part time.

Vern Klukas 03/15/2008 15:33

I still have my Trapeze tshirt, "fly through the figures with the greatest of ease".

And the user mentioned doing the business modelling could quite possibly be a pal of mine, though there could of course be many of those, given how excellent Trapeze was for scenario modelling.

David Dlugos 03/15/2008 17:42

One user kept old Macs around for 10 years just to run Trapeze, which was the basis of his business modeling practice.

A friend (hi Vern) pointed me to this blog, pretty sure the above was me

I still can run it, and until OS 7.6 quit talking to my OS X machines i was using it fairly regularily. I'd still like to get it running again... my hope is that those trying to keep Classic running in Leopard will build an emulator that will also run 7.6.1, the couple times i have attempted to make them work, i haven't been able to get them to boot.

Trapeze -- even on my ancient 50/100 68040 machine -- still runs circles around Excel. Numbers may have a veneer of what Trapeze looked like, but when you actually try to do something not really... and if you actually try to write a program in numbers it falls on its face.

dave

Galen Gisler 06/17/2008 03:13

I too was one of those 13,000, and did lots of work with Trapeze. I remember the MacUser review that effectively sank the project, and thought at the time how wrong it was. It was a great program to use, and gave me very useful insights into the data I was examining (outputs of numerical simulations run on supercomputers) that would have taken much longer with Excel.

I'm brand new to Numbers as of this month, and reminded, as other readers of this column have been, of how great and innovative Trapeze was.

I still have some Trapeze files hanging around that I haven't been able to open in many years, analyses of particle acceleration studies that we did in the late 1980s. Questions arise regarding those studies that aren't answered by the reports we wrote, so it might be useful to examine them again. Is the format of Trapeze files sufficiently documented that an importer for Numbers might be written?

Galen

codist 06/18/2008 20:01

I no longer even have the source. If you still have some old install disks, I think someone wrote a mac plus emulator (Mini vMac), maybe its possible to rerun it. No clue though. All I have left is a manual and memories. The file format was binary but after 20 years I remember nothing of it.

David Dlugos 06/26/2008 12:22

I have given lots of thot to a resurrenction of Trapeze. In the end the coming of the Intel Macs and no Classic will hopefully lead to better & more robust Classic emulators that will allow the running of Trapeze -- i still have very valuable work in Trapeze and would use it in an emulator over any spreadsheet out there.

I don't think Numbers is anywhere close to powerful enuff to support a Trapeze sheet (or Excel for that matter). One of the Math processors like Octave would have a better chance. The Trapeze text format would be the only viable way of exchange -- which means you'd have to get the sheets open long enuff to export them.

dave

Richard D. Saam 10/03/2008 06:17

trapeze runs on sheepshaver installed on OS 10.5

Richard Coon 11/13/2008 01:56

I just came across this site and wanted to add my comments. I was also one of the 13,000 users. I am a chemical engineer and used Trapeze to do simple material and energy balances for chemical processes. I also kept years of plant data in tables and performed calculations from the table. The linear algebra capabilities made Trapeze perfect for this. I was forced to port these calculations to Excel and found that my 5 minute re-calc became 5 hours. And adding a new row to an "array" in Excel took forever to re-calc. I sure miss Trapeze.

kilo 11/24/2008 06:37

I take up the cry - "show us some screenshots !!"

codist 11/24/2008 08:43

I wish I could, I can't run the app.

srw 09/10/2009 19:21

Is Trapeze downloadable?

codist 09/11/2009 18:05

It hasn't existed since 1989 except in memories of those who loved it :-)

cmon 10/27/2009 00:18

Also as one of those 13,00 users missed it though have had regular doses as can run (reasonably with only a few glitches) on a 540c laptop that I acquired when chucked out by my workplace many moons ago. Also, as an experiment, just got it running fine using Mini vMac (MacPlus emulator) but in B&W and very small screen (lots and lots of scrolling to use). Though spreadsheets may not have really improved at least the hardware has.

grace 01/26/2010 14:03

january 1-26-10

how are you.

grace power

gioca Video Slots 02/18/2010 22:51

The iPhone 3GS doesn't make the same grand leap that the iPhone 3G made from the first-generation model, but the latest Apple handset is still a compelling upgrade for some users. The iPhone 3GS is faster and we appreciate the new features and extended battery life, but call quality and 3G reception still need improvement.

EHz 06/11/2010 11:16

I was another of the 13,000 and a rabid Trapeze fan. I still remember Felicity Wasser, the helpful person at the help desk who answered many of my questions.

Trapeze allowed me to build models of electronic measurement systems that were crucial to our understanding and development work. We kept it going until about 1997 when a manager killed all Macs at the company.

Now I need to build a model of a developmental computer system and wish I had Trapeze to explore the design space. Today I was working with Mathematica and laughing at how crude it is (except for analytical solutions). The thought crossed my mind: "I wonder if Trapeze has been resurrected?" Too bad to hear it hasn't, although I did hear a year or so ago from someone who said he was developing something similar. I will try to find and post info about the new program.