Slashdot Mirror
Implementing VisiCalc
David Leppik writes "The author of VisiCalc, the first spreadsheet program, has
an article about how it was designed. VisiCalc is why businesses started to take the Apple ][ (and personal computers in general) seriously. It also changed accounting forecasts forever, which triggered the investment boom that brought us the "greed is good" era. Oh, and you can still
download VisiCalc in case you run DOS or Windows and have 27,520 bytes to spare."
Before that all real-estate transactions needed to make sense on the back of an envelope.
How many of you have run into dumb decisions by management that looked good in the spreadsheet?
"Learning is not compulsory... neither is survival."
--Dr.W.Edwards Deming
Uh, uh, loggin' in now
Wanna run wit my crew, hah?
Rule cyberspace and crunch numbers like I do?
They call me the king of the spreadsheets
Got em all printed out on my bedsheets
My new computer's got the clocks, it rocks
But it was obsolete before I opened the box
You say you've had your desktop for over a week?
Throw that junk away, man, it's an antique!
Your laptop is a month old? Well, that's great
If you could use a nice, heavy paperweight.
Do not read this sig.
It also changed accounting forecasts forever, which triggered the investment boom that brought us the "greed is good" era.
I highly doubt that this one application started an era of "greed is good." People have always been greedy, this just let them be greedying is a slighly more sucessful manner.
What's that?
It's WHAT century?
Shit. Oh well. No Cholera for me. . .
You are not the customer.
Besides schools, where were Apple II's embraced by business?
Mind you, I was too busy designing newspapers in Grade 3 on Apple IIe's to consider using VisiCalc on it. And damn AppleWorks was a bad wordprocessor. I guess Word isn't so bad after all, at least I don't have to change floppies to do a spell check.
Saskboy's blog is good. 9 out of 10 dentists agree.
Dan Bricklin has a page or two on the history from his perspective.
Unlike many software programs after it, the basic concepts of Visicalc were never patented.
You can read about why Visicalc wasn't patented here.
Kids at the nearby school, still have a room of apple 2s with this still running on them. They still use it for basic spreadsheet training too. Amazing that some schools are so poor the can't afford new PCs. At least this one picked something powerful for its time.
No.
Set this running full screen on your machine and scare people away...
The reason I first got my hands on an Apple ][ at the ripe age of six was because my father wanted it for forecasting and doing bookkeeping. The seed planted in my brain at that time led to an awful lot more than what he expected from the machine. If it hadn't been for that box, I probably never would have started an ISP later in life, and I probably would not be nearly the techno/gadget geek I have become since.
It is a mixed bag, admittedly. On the plus side, Visicalc indirectly led me to doing a pile of neat-o things. On the minus side, I've probably gotten laid less.
GF.
Lots of petrified grits
Okay, I downloaded it. Now how do I get to the flight simulator?
'which triggered the investment boom that brought us the "greed is good" era'
Assuming by the 'greed is good' era, you are referring to the Gordon Gecko speech in the movie 'Wall Street', you are talking about the 80s LBO boom, you're pretty far off base. That boom was enabled by a lot of things, but the biggest factor was the rise of the ability to evaluate a company's value by free cash flow rather than earnings, and the ability to nearly instantaneously gain access to huge amounts of debt (brought about by Milken's junk bond machine and certain regulatory changes affecting thrifts and insurance companies, which could really be traced back necessity-wise to the breakdown of the Bretton Woods system in 1972.)
This won't open my Excel spreadsheets! Clearly inferior software. . .;)P
You are not the customer.
Perhaps no one if when VisiCalc came out a unix machine wasn't an ungodly sum of money.
I've only got 640k, I was told that's all I'd ever need.
And thus it was in the beginning. Excel was originally a Mac program. I remember one of my chemistry profs laughing at our "toy" computer and its funny li'l "mouse". Laughing 'til he saw the output, anyway. Off a networked postscript laserprinter. The year was 1985.
Besides schools, where were Apple II's embraced by business?
Depends. Lots of small businesses bought them. My folks did, and they ran some custom accounting apps for years on an Apple ][ (which predated PCs by quite a bit), later an Apple ][e, and stil later on a GS.
Just like today, run whatever scratches your itch.
GF.
Lots of petrified grits
I actually wish a lot of schools would just buy older Apple II's and then use eBay as a source for programs. I run these programs through emulation on my iMac and they really are perfect for the purpose.
Yell & scream & rant & rave... it's no use... you need a shaaaave ~ Bugs Bunny
That was an actual statement made at an Apple dealer I was visiting when I was kid, so the salesperson sold him an Apple ][, and pretty much one of everything in the store (the guy also sprang for a 132 column daisy wheel printer....).
William
Sphinx of black quartz, judge my vow.
There's a nice little plaque at Harvard Biz School, in the classroom where Dan Bricklin first developed the VisiCalc idea (Aldrich 108). He came to my Managing Product Development class while I was at HBS, really cool guy. Tells a great story about doing a calculation in a very roundabout way, and then getting asked by the professor in class the next day "right answer, but why didn't you just use a ratio?" Dan said "well, this way will be more accurate." Truth of the matter was, he hadn't gotten the divide function working yet. :)
I remember running VisiCalc on my Apple //c (128k RAM, integrated 5.25" drive).
VisiCalc came in a green and white small binder, if I remember correctly. It help me learn some of the basics of spreadsheet software. I imagine I still have the binder and disk(s?) around somewhere.
From the license agreement:
1) use the Program for your personal use, not commercially,
So much for basing my business on VisiCalc these days...
I also recently downloaded a DOS game, TankWars (before Scorched Earth, for anyone that played that) and have been playing it frequently on my office computer.
- (c) 2018 Hank Zimmerman
Oh, and you can still download VisiCalc in case you run DOS or Windows and have 27,520 bytes to spare.
Oh yeah, let me just go ahead and break out my extra 50 gig hard drive I just happen to have sittin... did you say bytes?
my religion lies somewhere between buddhism and super monkey ball - pamphlet?
"VisiCalc was a product, not a program. Decisions were made with the product in mind and, to the extent possible the programming was towards this end" I only wish that all the present day s/w are built like that
Understanding is a three edged sword. - Ambassador Kosh Naranek, Babylon 5
Many schools are dirt poor and happy to have what ever they can get. Some can barely afford PAPER, and the teachers end up buying some out of their own pocket so they can teach.
Our children are the future and our most valued possession.. yet we treat their education like a 'irritant ' and wont get involved or support it..
Plus don't forget, fundamentals don't change... and fundamentals are important, regardless of what some people/educators believe these days.
---- Booth was a patriot ----
My father's business was facing a possible audit. All the books were kept on ledger sheets (one page of paper per customer) and his accountant was horrified.
I spent several long days typing the ledger sheets into VisiCalc sheets, which would then print out in a similar format, but with the balance figured by computer, not by hand.
Granted, if you look at this with 2003's perspective, it looks like banging the rocks together to make ones and zeros. But at the time, it would have cost a pile of money to get someone with a snazzy mainframe to do, and here's some kid knocking it off in the basement. The accountant was floored.
And I got paid for playing on a computer. My lord, how little has changed.
--
Besides schools, where were Apple II's embraced by business?
Before the first IBM PC? Pretty much everywhere. Up till that point, most business microcomputers ran CP/M. VisiCalc was the original "killer app", and it put Apple on the map. Within a year of VisiCalc's release, Apple IIs had gone from just-another-home-computer (toy) to being the best-selling business microcomputers around.
Of course, the release of the original IBM PC a couple of years later completely overshadowed Apple's moment in the sun.
>B7:"Priceless /W1 /GOC /GRA /GC9 /X>A1:>B7:
>A7:"Never making a dime
>B5:11000
>A5:"Two Apple ]['s
>B4:2000
>A4:"Junk-food for programmers
>B3:50000
>A3:"Two Programers
>A1:"Visi Calc:
Current software in general is so over bloated we don't use but a small percentage of its features..
VisiCalc ( and many other older applications )still does more then many people would ever need.
---- Booth was a patriot ----
Open the damn thing up and see where it goes. It may not go anywhere or it may turn into K-Visi or something.
Since it was probably written in pure assembly language (most microcomputer apps were at the time), it's unlikely to be of much use to modern development teams. And in any case, there are already a plethora of clones available; the oldest free one I know of is sc, which runs on dos and text-based unix systems. Originally by James Gosling of gosmacs and java fame. If you really want a tiny, underpowered spreadsheet, that's where I'd start. Otherwise, why not just stick with KSpread or Gnumeric or something similar.
(I feel like I should mention oreo too, the emacs to sc's vi, but I couldn't quite work it in.)
Oregon Trail
Am I not merciful??? :)
Luck favors the prepared, darling.
As old and archaic as the interface is, my old man is still using it.
//e compatibility card for it (Apple made a PDS card that you could plug into a Mac that had a //e on it, and software emulated all of the add-on cards, and you could plug a 5.25in. floppy into the back. It even had a port to plug in a joystick or paddles!) He has continued to use these spreadsheets with his original VisiCalc 1.0 8-sector diskette on that machine, even though he has since bought a PowerMac and an iBook. The good ol 33Mhz '030 based Mac with the //e card still sits proudly in his home office with the ImageWriter pin-banger next to the Epson Stylus Photo.
He has spreadsheets that he originally wrote on the Apple II+ in 1980, and has continually updated to the point of such huge complexity it would take weeks to remake them in a more modern OS / Application.
Even when he finally broke down and bought a Mac in 1994, he bought a
What's funny is that he knows he is really screwed if that disk fails - you can't copy it because of the 8-sector format, and the manual says "if the disk ever goes bad, just mail us at $address and we'll send you a new one"
I can't believe that disk hasn't become completely degaussed after the 23+ years it has been in use
Slashdot still doesnâ(TM)t support Unicode after it was added to the HTML standard in 1997.
You mean it's not available on Linux yet ? WTF?
Seriously though, 27k is a nice size for an
app that did so much. If only openoffice could
lean down their suite a bit so it loads in less than
45seconds on my AMD K7-650. (Not trying to troll)
I recall tuning my DOS system to have Lotus 123
load in less than a second. Good days
90 minutes of cassette tape for one kilobyte of data
good christ! what, did it record the voice of someone saying "one...zero....zero....one...one...one..." or what?
Gentlemen...BEHOLD!
-Dr. Weird
Ha! You obviously haven't used Linux before. Using Linux is exactly like using VisiCalc. Klunky, retarted interface with cryptic commands and config files spread across the universe. As an added bonus, you get Penguinites and GPL zealots... Anti-Capitalist idealouges who have never had a real job in their lives and like things like butterflies and mountain biking.
This thread is no doubt inspired by the panel last night at the computer history museum on the legacy of Visicalc. It was a great time, and a lot of those of us who had worked on Visicalc's development and marketing came out, some I had not seen for 20 years.
Charles Simonyi, onetime competitor to VisiCalc, was the moderator, but he made a remarkable claim about its role in history.
What he starts with is true. Visicalc was the first app that caused people to buy personal computers in numbers, and in particular for business people to do so. In the past, people wanted an Apple ][ or a Pet. This changed, so that they wanted VisiCalc, and an Apple was the way to get something to run it on.
As such, VisiCalc sparked the PC industry, which begat, well, all of this. Quite a juncture in history.
Of course, something else would have come along, PCs are just too useful for this not to happen, but the course of it was definitely set and changed by Dan Bricklin, Bob Frankston and Dan Fylstra -- and Mitch Kapor, who was product manager for VisiCalc before he went to found Lotus and eventually defeat VisiCalc in the market.
The meseum at computerhistory.org will probably put up the video of the panel before too long, so you can check it out.
Has it been over a year since you last donated to the Electronic Frontier Foundation
Just so everyone knows, this required 90 minutes of cassette tape for one kilobyte of data
Nope. The Apple's cassette port used Manchester-encoded data at 1200 bps (the same speed as the Commodore 64's floppy drive).
A couple of friends and I used audio amplifier chips to simulate rudimentary 1200-bps half-duplex modems with the Apple cassette ports. Like everything else on that machine, there really weren't many limits to the I/O hacking possibilities.
Dahlmann tightly grips the knife, which he may have no idea how to use, and steps out into the plain.
In 1979, our utility bought all our power from other suppliers and inflation was causing rates to go up incessantly. If we didn't raise our rates we would have been out of business in months. I worked in the rate dept where we would make our calculations on desk calculators and give them to the secretarys to type on the word processor (Wang?). When an error was made or new information came in - recalculate all the sheets again and then print them all.
My co-worker's (are you there Joe?) roommate worked at Apple and they had a new program called Visicalc. We tried their system for a couple of weeks, and then bought a $10K Apple II and a daisy wheel printer (how many people know what that is?). The mainframe people could not understand why we wanted a 1.2Mhz, 16K, 160K floppy machine with a yellow monitor!
We used this machine and a couple others to put together complete rate cases that totalled tens of millions of dollars. After about a year, the CA Public Utilities Commission can over to see why our numbers always added up and didn't have eraser marks all over them.
We were estatic when we upgraded to 64K and then got an Apple III. These were used until Steve Jobs got greedy and closed the box for his Lisa.
After that I try every competitor to Visicalc and didn't stop until I found a new company at a SF computer show in a 10'x10' booth. The company was, of course, Lotus 123 and we made the switch to a couple of Compaq suitcase computers (the only way IT would allow us to avoid buying overpriced IBM PC's).
We never looked back, and it wasn't too much later that I used Lotus to manage a $40M capital budget.
It's hard to get by these days without knowing at least a little bit about how to use a PC.
Well, you're right about that, but it misses the point. The educational value of a computer does not, for the most part, lie in learning how to use the computer for its own sake. A computer is a general purpose information tool and one goal in owning a computer is education. Education can include reading, writing, math, science, social studies, etc. A computer can, to an extent, help with all of those subjects.
Note that an Apple ][ will help you just as much with your math as a PC, as long as the software on each is roughly equivalent.
I do get tired of hearing about school districts that just dropped $250,000 for a brand new computer lab, and then they turn around and lay off teachers then complain about the student:teacher ratio. It doesn't make sense to do that when you consider that they really don't even need the lab.
The above probably set you to thinking about how inadequate an Apple would be to learn computer science subjects. You would be right to an extent, but a lab really sees far more uses than just for computer science education. If the goal is to best serve the majority of the student body, then buying your computer equipment (and by extension the education software) around the needs of your computer science oriented students is a poor choice.
Please mod this post only if you think others should/n't read this. I have enough ego^H^H^Hkarma. Thanks!
I have reread your comment several times, and I'm not sure if I should disagree, or agree.
First off, dongle, cd check, product key, all these things are trivial to circumvent. There is no technological frontier of copy protection. There is a binary with a loop that checks for a valid device. This binary loop stands out like a sore thumb in a hex editor. It is easy to take one JMP and redirect it past the loop. If you don't belive it is easy, just look at some of the Cracker FAQs. I'm not saying it is as easy as falling out of bed, but it definately is easier than designing a copy protection scheme in the first place.
Second, copy protection is like snake-oil of the gaming industry. You have companies with names like SafeDisk and WriteBlock. You have people writing huge databases for online product activation. Think about how much it costs MS just to run their call center to process activation. Think about how much Activision paid in royalties to SafeDisk. And for what? Just so I can spend all of 30 seconds at GameCopyWorld do download a no-cd crack.
About 3 nights ago, I was hanging at a friend's house for some gaming. His copy of WinXP crapped out on him. It took 20 minutes on a long-distance call from Tokyo to Washington to get his crap working agian. Oddly enough, my "leaked" serial code has worked perfectly since the day I downloaded it.
I'd rather you do it wrong, than for me to have to do it at all.
Actually, running VisiCalc back then is very similar to running a Java program in a 2.0 Ghz machine with 512 MB memory.
They both run at the same speed!
Or if you're not, you're totally off base. Those were the days when programming was really fun, man! I remember being really excited when the PalmPilot came out, cuz it sounded like a good opportunity to get back to programming the way folks were meant to do it.
Who's with me??
Breakfast served all day!
ME!
I've been having fun doing that very thing.
Of course, my phone (Kyocera 6035) has four times more pixels than my first computer, 2048 times more memory than my first computer, and a CPU that's 11 times faster than my first computer.
But even now, Palm programming's more like programming for a Mac in 1985.
Eloi, Eloi, lema sabachtani?
www.fogbound.net
[Visicalc] also changed accounting forecasts forever, which triggered the investment boom that brought us the "greed is good" era.
I highly doubt that this one application started an era of "greed is good." People have always been greedy, this just let them be greedying is a slighly more sucessful manner.
"Greed is good", IMNSHO, came from Ayn Rand, via the Objectivist society, the Society(?) for Individiual Liberties (SIL), the Libertarian Party (and non-party-member libertarians).
Rand's thesis is a reaction to, and an analysis of the reasons for, the success of Capitalism in the US, contrasted with the despotism that arose from Socialism, National Socialism, and Communism in Europe (especially her native Russia).
Objectivism's prescription for social organization: instead of attempting to perfect the individual and train him to work against his instincts, you organize inter-individual interactions so that the so-called "vices" lead the individual into what the society (and most individuals) define as MORAL behavior.
Interestingly: Just about the ONLY way that has been found to turn psychopaths into law-abiding citizens with a high success rate is to teach them Objectivism. (Since a psychopath is precicely a person who reasons solely from "What's in it for me?", this is exactly what you'd expect if the social design of Objectivist philosophy was successful. B-) )
Where libertarians stop with "stay off me and I'll stay off you", Objectivists have a well-reasoned party line that INCLUDES that as a basic element. So Objectivists tend to be revolted by many libertarians' personal morals, yet they still get along. (That's because they share that basic principle of "don't hit first", so arguments go on forever but fights never start.)
Bantam Dominique roosters crow a four-note song. Once you've heard it as "Happy BIRTHday" you can't NOT hear it that way
I'm running it on MacOS X. I do have virtual PC however.
Doesn't it make you feel good to know that our freedoms are protected by politicans, lawyers and journalists.
We had a PDP-11/40 with six 20mA current loop connections pluggable to any of 22 campus jacks (five years ago the contractors for our UTP retrofit on the 1978 building spent most of a day scratching their heads about this bunch of wires). Apple ][s with cassette interfaces and plain old TVs were a godsend for teaching programming. A spreadsheet was manna. BeagleBrothers were gods. And in 1991 I was still able to communicte with a class in Sofia by a deuling banjos style interchange on their Pravetz clones in Apple graphics (PLOT and HPLOT and HPLOTTO on "GR" or "HGR" or "HGR2" were a universal language - like the Close Encounters scene...) i think the commands and such from Apple ][ are in my DNA now... I still have my HHGG from Infocom and a //c+ to run it on!
"Win treats sysadmins better than users. Mac treats users better than sysadmins. Linux treats everyone like sysadmins."
It's interesting how Frankston talks about skidding. Since VisiCalc has a typeahead buffer, he did not buffer the arrow keys which prevented overshooting a destination on the slow Apple II.
I find this interesting because NeXTstep had a terrible problem with typeahead when it came to scrolling in almost any application. It's a good thing those guys fixed it for OS X. At least it seems to have been fixed for OS X.
ch00t, ch00t!
][ in middle east!
Karma: The shiznight, mostly because I am the Drizzle.
And all young programmers should be made to sit an exam based on this.
:
:-) )
With concepts like
"VisiCalc was a product, not a program"
"The goal was to give the user a conceptual model which was unsurprising -- it was called the principle of least surprise. We were illusionists synthesizing an experience."
"One guiding principle was to always have functioning code. It was the scaffolding and all I needed to do was flesh it out. Or not. Since the program held together omitting a feature was a choice and it gave us flexibility"
and from the section on 'kidding'
"I doubt if any but the most geeky users were even aware that there was an issue let alone a solution. This is the kind of design detail that makes a program feel good even if you don't know why."
I've tried to tell several younger coders things like this on many occassions, and getting the message through can be hard work !
This article shows not only why these principles are important, but how to approach projects overall. Someone should carve it in stone (then hit newbie programmers over the head with it until it sinks in
-- You can't give it, you can't even buy it, and you just don't get it!
I remember when spreadsheet "macros" were the rage. Basically you record (or transcribe) the keystrokes used to select the menus and commands. Most menus were based on pressing a single letter to drill down to the next menu. Later they added an IF-statement and a goto of sorts, making it a Turing-complete language.
Accountants became de-facto programmers and did some pretty nifty things with macros. With this came the downsides of amature programmers also, such as hard-to-figure-out coding and other maintenance headaches.
The accountant-as-programmer trend more or less ended when Excel replaced Lotus-123 as the "in" spreadsheet package, and keyboard macros gave way to Excel Basic (I don't remember the exact MS name). Excel Basic sucked as a language. Besides, macros did not require learning anything really new because they were pretty much the very menu sequence that users typed anyhow. But Excel Basic was a completely different language that had almost no direct relationship to the user menus. Mousing instead of typing also diminished letter-centric thinking.
Astute macro users were pissed at being forced to MS, but generally appear to have eventually just given up or scaled way back on spreadsheet programming. I believe Excel had a "macro recorder" of its own, but one could not add IF statements and loops nearly as easily as 123 without getting into VB-like programming syntax.
An interesting era of end-user programming came and went.
Table-ized A.I.
[cassette tape for one kilobyte] good christ! what, did it record the voice of someone saying "one...zero....zero....one...one...one..." or what?
Actually it was something like "high beep, low beep, low beep, high beep, high beep, high beep..."
(Forget about speaking Klingon, real geeks learn Modem-ese.)
Table-ized A.I.
I once invented spreadsheet software for Enron, it was called InvisiCalc.
Table-ized A.I.
What's funny is that he knows he is really screwed if that disk fails - you can't copy it because of the 8-sector format
Actually you can copy it. You just need a "bit copier". I know because I did it way back in `82.
nohup rm -rf ~/. >& zen &