Slashdot Mirror


VisiCalc Turns 25, Creators Interviewed

Xaroth writes "It's hard to believe that it's already been 25 years since the release of one of the world's first 'killer apps.' 1979 saw the creation of VisiCalc, the first microcomputer-based spreadsheet and the single application that launched widespread computer use among businesses. To remember this event, PC World has published portions of interviews with the three co-creators of the modern spreadsheet: Dan Bricklin, Bob Frankston, and Dan Fylstra. Alternately, check out the Software History website for more information on this and other historical bits."

51 of 149 comments (clear)

  1. Test it out! by JThundley · · Score: 5, Informative

    Run it yourself!

    I bet there's a Linux one floating around out there, I guess I'll try to WINE this one.

  2. Software History website basically a placeholder by Blakey+Rat · · Score: 4, Informative

    Don't bother with that Software History website linked to in the article. There's very little content, and it seems to be mostly a placeholder and a place for people to give them donations.

    As far as I can tell, it has absolutely zero content about Visicalc, and I have no idea why it was linked to in the first place.

  3. Would they... by Jailbrekr · · Score: 2, Funny

    Would they have ever written it, knowing that, in the end, a paper clip would be used to teach people how to use a spreadsheet.....

    --
    Feed the need: Digitaladdiction.net
    1. Re:Would they... by fm6 · · Score: 2, Interesting

      Sure they'd patent it. They considered doing it 25 years ago, but an unimaginative lawyer told them that software wasn't patentable. More here.

  4. They needed databases, too... by wizbit · · Score: 3, Interesting

    Don't forget DB Master for the Apple II. Sold several million copies - a modernized version of it is still used in public works offices around the world, even 20 years later.

    The original author still does DB work for this company.

    1. Re:They needed databases, too... by Anonymous Coward · · Score: 3, Insightful

      Since there were only slightly more than two million Apple II's ever made, it's pretty unlikely then "several million copies" of any software title were ever sold for it. Don't just make stuff up.

    2. Re:They needed databases, too... by wizbit · · Score: 4, Informative

      Total sales, including the PC port, were about 2.5 million. This was a pretty common tale, too, many programs (including visicalc) had some history on the apple 2 series before being ported for the PC.

    3. Re:They needed databases, too... by AndroidCat · · Score: 2, Insightful

      If that's the number of genuine Apple IIs, then multiply it by a large factor for all the clones. (And where did you get that two million figure from?)

      --
      One line blog. I hear that they're called Twitters now.
    4. Re:They needed databases, too... by wsxyz · · Score: 3, Informative

      He got it out of his butt.

      Well over 10 million Apple IIs were manufactured and sold. Remember that "Apple II" as a general term includes Apple II, Apple II plus, Apple IIe, Apple IIc, Apple IIc+, and Apple IIgs machines. On top of that there were millions of clones produced all over the world.

  5. Small fact... by networkGhettoWhore · · Score: 5, Interesting

    I dont think the article mentioned this, but VisiCalc was also the first (known) enterprise app to be ported from the Apple OS to a *Nix based system.

    --
    Natural Selection: self-destruction of the poor and lazy
  6. Happy Anniversary -- Remember the Visicalc song! by Hobart · · Score: 4, Funny

    Visicalc
    Mail-from: : SU-NET host SU-LOTS-A rcvd at 3-Jan-83 0246-PST
    Date: : 3 Jan 1983 0246-PST
    From: : K.Kanef at SU-LOTS-A (Bob Kanefsky)
    Subject: : Visicalc
    To: : Songs at SU-LOTS-A
    Parody-of: : Physical (Olivia Newton John)

    Visicalc
    Parody written by Bob Kanefsky
    Idea suggested by Judy Anderson

    Been working out the figures day and night,
    Making good column'ation.
    I gotta add them up just right --
    And know what they mean.

    I pencil in the fields I \guess/ you want,
    Adding and subtracting duly,
    Movin' my eraser up and down and
    Horizontally.

    Let's get Visicalc,
    Visicalc.
    I wanna get Visicalc.
    Lemme get your budget done,
    Your budget done.
    Lemme get your budget done,

    (chorus)

    I been patient, I been good.
    Tryin' to make a hand-drawn table.
    My interest in your figures wanes --
    You know what I mean.

    I'm sure you'll understand my point of view;
    We know each other fiscally:
    You gotta know you're gettin' up
    My semi-annual fee.

    (chorus)

    (chorus)

    Let's get annual,
    Annual.
    I wanna get annual.
    Let's get into annual.
    Lemme get your budget done,
    Your budget done.
    Lemme get your budget done,

    (I know there was another version of this in an old Atari magazine that said something about "lemme see your diode's rock", but Google hasn't seen it. ;)

    --
    o/~ Join us now and share the software ...
  7. Re:jEdit beats the pants off it by King+of+the+Trolls · · Score: 2, Funny

    and it only takes 2Gb RAM to run it in sluggish mode.

  8. Ah ... by Sonic+McTails · · Score: 2, Funny

    Hmm, a program from 1975 is still better then Execl 2004

    --
    This signature was left intentionally blank.
    1. Re:Ah ... by Wavicle · · Score: 4, Informative

      You haven't got the slightest idea what you are talking about.

      Good thing you posted as anonymous coward so that the world will not know just how clueless you really are.

      Even difficult problems like the travelling salesman or Towers of Hanoi have been solved and added to the calculation engine. This kind of feature adding essentially reduces the calculation time of these problems to a O(1) table lookup.

      WHAT? Start making sense. Towers of Hanoi is a 2^n problem, but it doesn't actually "solve" anything. A look-up table would make absolutely no sense. Do you need a look up table to figure out what a stack of rings looks like on peg 2 as opposed to peg 1? You could make a LUT for "move X", but the problem grows so fast, you can quickly see that just 40 discs would create a LUT that would fill most raid arrays.

      The traveling salesman is NP-complete. Transforming it to a problem in P has never been done. The notion of a LUT for this problem is silly. You can only precompute the LUT for one instance of the problem. If you can convert all possible such problems to an O(1) lookup table though, you will have solved the P=NP problem and can claim the US$1million prize.

      Because you are probably a sysadmin with a degree from DeVry and don't understand that notation, I'll explain it simply: O(1) means "really fast".

      You've never taken computing theory yourself, have you? The next paragraph you write emphasizes that either you didn't, or you slept through the class:

      If we consider that a signed 16 bit integer can only handle values between -16k through 16k,

      2^15 ~= 32K

      it becomes obvious that Visicalc simply couldn't handle the types of calculations that we are performing today

      Even back in 1979, computers had the same computational power as a turing machine. They could perform the same calculations as computers today, their only limiting factor is available memory and available time.

      (32 bits allows us values of +-2 trillion).

      2^31 ~= 2 billion (or if you're one of those UK types, 2 thousand million)

      --
      Education is a better safeguard of liberty than a standing army.
      Edward Everett (1794 - 1865)
    2. Re:Ah ... by bhmit1 · · Score: 2, Interesting

      Because you are probably a sysadmin with a degree from DeVry and don't understand that notation, I'll explain it simply: O(1) means "really fast".

      <CS101>
      If we are being educational, lets do it right. O(1) does not mean really fast. A calculation that takes 6 years could still be O(1). O(1) simply means the calculation is constant, regardless of what is input. O(n) basically means the more data (n) you give it, the longer it takes. And you can take it from there (double it, square it, take a log, whatever floats your boat). One thing to keep in mind is that the more complex you get to speed things up and get closer to an O(1), the more likely you are to take longer for the simple calculations than a basic O(n) formula. Or to put it another way, all of us that want to do a quick sum of columns of a small table would prefer not to wait 10 minutes while the kitchen sink and travelling salesman algorithms load.
      </CS101>

    3. Re:Ah ... by nelsonal · · Score: 2, Interesting

      Heard an interesting story about the Lotus development of macros. They were a debugging tool that was in a close to final release for testing before someone realized these might be a useful feature in the final product.

      --
      Degaussing scares the bad magnetism out of the monitor and fills it with good karma.
  9. Some Special on TV by aliens · · Score: 4, Interesting

    I remember watching something about the early days of PC's and there was an interview with one of Visicalc's creators and he discussed the first time he showed it to an accountant.

    The accountant supposedly started visibly shaking and proclaimed "Do you realize just how much time this will save me??"

    I just found that bit interesting for all the people who hold onto "the good old days" and question if computers have really helped or hindered us.

    In my mind I try to imagine just where we would be if we still only had large main frames. The power of the PC is truely amazing.

    (sorry just got back from a workout and am high on endorphines (or whatever they are))

    --
    -- taking over the world, we are.
    1. Re:Some Special on TV by Blakey+Rat · · Score: 4, Interesting

      What's interesting is that it doesn't actually save any time, it just means that they do more, and different kinds, or financial reports.

    2. Re:Some Special on TV by aliens · · Score: 2, Insightful

      Well I don't think that everyone would have a Mainframe to connect to, to run spreadsheets. Now every business large and small can easily keep records that would have been done by hand.

      --
      -- taking over the world, we are.
    3. Re:Some Special on TV by dillon_rinker · · Score: 2, Insightful

      And THAT is why we have the standard of living that we enjoy.

  10. Re:jEdit beats the pants off it by RidiculousPie · · Score: 4, Insightful

    What's the difference between what you describe and the idea of Lotus Improv?
    Improv was a truly innovative system, which I think represents a logical method of fast data handling.
    Also, could jEdit have been developed if VisiCalc and Improv had not come before it?

    --
    ah, mod points ... now where is my crack?
  11. Re:jEdit beats the pants off it by JoeShmoe950 · · Score: 5, Insightful

    Not to be a flaimbait or anything, but I think that your completely wrong about Visicalc. Computers aren't designed to mimic things from the real world. Many good programs don't. The spreadsheet is productive, very. In fact, it doesn't mimic paper+calc+pencil for doing banking, it superceeds it.

  12. what about the NEXT killer app? by Whitecloud · · Score: 2, Interesting
    Excellent quote from Dan Bricklin:

    I think that community is coming back. With the Web, blogs, e-mail, and cell phones, we're seeing a resurgence in community. Technology is now something for bringing people together.

    Visiclac kicked off ebusiness, email gave us instant global communications, mobile phones let us do that on the move, whats next?

    --

    Do you need a website upgrade?

    1. Re:what about the NEXT killer app? by awful · · Score: 2, Funny

      "Visiclac kicked off ebusiness, email gave us instant global communications, mobile phones let us do that on the move, whats next?"

      Rocketpacks with streaming audio obviously...

  13. Dosemu works by cheezycrust · · Score: 5, Informative

    It seems to work under Dosemu and Freedos (Dos emulation for Linux). WINE is overkill, since it doesn't use any Windows stuff.

    --
    Teenagers these days don't have as much sex as they want each other to think they do.
  14. You mean.. by dj245 · · Score: 2, Funny

    You mean to tell me that solitare was not the first killer app?

    --
    Even those who arrange and design shrubberies are under considerable economic stress at this period in history.
    1. Re:You mean.. by PCM2 · · Score: 3, Funny

      The second killer app was clearly the hotkey you could press in games that would instantly switch over to a simulated VisiCalc spreadsheet when the boss walked by your workstation.

      --
      Breakfast served all day!
  15. Wine ? But its a dos program by nurb432 · · Score: 2, Insightful

    Why would you expect it to work when its a DOS program? I thought WINE only re-implemented win32 calls..

    Even if it did, there are plenty of dos emulation tools out there... that are FULLY functional.

    ( not slamming the WINE people, they just arent finished yet.. )

    --
    ---- Booth was a patriot ----
  16. too bad they didn't GPL it by argoff · · Score: 4, Interesting

    Boy, if they would have, it would have stopped alot of the anticompetitive business practices that's happened in the 25 years since, they could have locked out execl before it even happened.

    1. Re:too bad they didn't GPL it by pauljlucas · · Score: 4, Insightful

      The GPL does nothing to prevent anybody from writing their own version not using any GPL'd code. The GPL wouldn't have stopped anything in this case.

      --
      If you reply, do so only to what I explicitly wrote. If I didn't write it, don't assume or infer it.
  17. Other Small Fact... by ackthpt · · Score: 4, Interesting
    I dont think the article mentioned this, but VisiCalc was also the first (known) enterprise app to be ported from the Apple OS to a *Nix based system.

    Some time ago there was the question raised concerning ownership and transfer of patents, etc. of the spreadsheet, which everyone and his kid brother eventually made their own version of. IIRC the creators didn't feel they actually sold all rights or something to that effect (sound similar to the SCO/Linux debacle?) Anyone know what has been determined in that regard? Seems if it was still unresolved it would make SCO/Linux look like a tempest in a teapot by comparison.

    --

    A feeling of having made the same mistake before: Deja Foobar
    1. Re:Other Small Fact... by JuggleGeek · · Score: 2, Informative
      Some time ago there was the question raised concerning ownership and transfer of patents, etc. of the spreadsheet

      Visicalc came out in 1979. At that time, software patents were rarely granted. (Our legal system has corrupted patents since that time.) Dan Bricklin has some information about Visicalc and panents on his website.

      http://www.bricklin.com/patenting.htm

  18. Software like this would still be useful by hattig · · Score: 2

    Most spreadsheets are overkill for most tasks.

    I wouldn't mind some cut down spreadsheet software, a number-processing equivalent of a plain text editor compared to a full blown word processor.

    Shouldn't be too hard to create something like this, I'm sure. EasySheet. KSheet. GSheet. OhSheet!

    Too much software has been enticed by the lure of features and complexity, at the expense of simplicity and doing what most people need it to do.

  19. Neglecting key points there... by Impeesa · · Score: 3, Insightful

    The spreadsheet only has no real-life corollary because Visicalc made doing it by hand completely and utterly obsolete. Writing a letter isn't really sped up a whole lot by using a computer (as compared to writing it by hand, or on a typewriter). Spreadsheets are a whole different story. They were done by hand at one point, but changing some numbers and carrying forward all the calculations used to be a full time job for some people. Now it's 10 seconds with Excel. Think on that for a bit. :)

  20. Re:jEdit beats the pants off it by nelsonal · · Score: 5, Insightful

    I agree with you, but we're both probably spreadsheet experts. Have you ever seen a user with only basic training, and a limited understanding of math? They know certain things are possible (because they saw us do them) but to them the spreadsheet is not intuitive. To us they are. Once you grasp relative v absolute references (and cell naming) you are usually on your way to being unstoppable.
    One thing that would be nice would be a sheet that had a different display for user input data and calc'd data (I have my own shorthand but wouldn't it be nice if the sheet just formatted them automatically?
    My employer spend millions of dollars redesigning their database input and report forms so they would be the same as the old mainframe systems. Dumb to us, but most users were rendered helpless by something different, even if it was more efficient. Something that looks like what a user is comfortable with is sometimes more useful than a powerful, flexible, but different tool.

    --
    Degaussing scares the bad magnetism out of the monitor and fills it with good karma.
  21. First Programming gig... by bokmann · · Score: 3, Interesting

    I didn't even realize it until I saw tihs article, but my first programming gig was with Visicalc...

    It was 1982, I was 13, and a guy paid me $50 to create a spreadsheet for him that would let him calculate his cost per share of some stock he was buying over multiple purchases (dollar cost averaging).

  22. VisiCalc vs. Microsoft Multiplan by SIGALRM · · Score: 2, Interesting

    Bricklin and Frankston did some innovating work in (the quite stable) VisiCalc... not to be outdone, in 1982 Microsoft released Multiplan 1.0 which was a pioneer in some, shall we say, more infamous terms. It was a revenue bomb, and it's miscalculations cost customers umpteen $$. I remember hearing somewhere that the legal threats due to Multiplan almost shut down Microsoft's early operations.

    Apparently, rumor was that SCO was hired to port Multiplan (to various *nix's I would guess).

    Anyway, it's interesting that one of Microsoft's first attempt to unseat a software application was targeted at Visicalc. Did they succeed?

    --
    Sigs cause cancer.
    1. Re:VisiCalc vs. Microsoft Multiplan by AKAImBatman · · Score: 3, Interesting

      Anyway, it's interesting that one of Microsoft's first attempt to unseat a software application was targeted at Visicalc. Did they succeed?

      Nope. In fact, Microsoft kept failing at spreadsheets until long after Lotus 123 became popular. It wasn't until Microsoft was able to leverage Windows that they finally gained a foothold. Of course, that's a story in itself.

      Interestingly enough, the whole Windows story has a lot to do with VisiCalc. You see, VisiCalc took all their hard earned money and put it into creating a piece of software known as VisiOn. VisiOn was the first PC GUI for DOS. Given that Graphical User Interfaces had been the domain of expensive Unix machines, this worried Microsoft a great deal. So they announced Microsoft Windows.

      In typical Microsoft fashion, they really didn't have anything. But they managed to spam the media and make everyone put off purchasing VisiOn in hopes that this mystical "Windows" would be a far better investment.

      The early betas of MS Windows were actually nothing more than a way of multitasking different DOS apps. By pressing certain keys, you could switch from one "Full Screen Window" to another. About that time, Apple introduced the world to a true WIMP interface. This caused Microsoft to change directions. When the first version of MS Windows was delivered, it allowed for multiple programs to run in tiled windows. One window could be maximized at any time, thus obscuring the other windows. To be blunt, this sucked.

      Windows 2.0 was only slightly better, but it sucked too. Windows 3.0 finally hit the mark by delivering a full WIMP interface and a program manager. Why Microsoft thought the program manager was a good idea when the Macintosh showed otherwise, is a mystery that will forever remain unsolved.

    2. Re:VisiCalc vs. Microsoft Multiplan by geekoid · · Score: 2, Insightful

      Howmany people know what VisiCalc was? How many people know what excel is? I'd say they succeeded.

      Like a lot of great computer scivement, VisiCalc lacked good marketing.

      --
      The Kruger Dunning explains most post on /. http://en.wikipedia.org/wiki/Dunning%E2%80%93Kruger_effect
    3. Re:VisiCalc vs. Microsoft Multiplan by AKAImBatman · · Score: 2, Interesting

      I think you are confusing TopView, which was an IBM product, with early versions of Windows.

      No, I'm talking about the pre-release stuff that Microsoft sent to the computer mags of the time. They described how a slight change to your DOS code would make it "Windows Compatible", which basically meant that it could be suspended and replaced on the screen at any time.

      As for preannouncing, my source is the book "Barbarians Led by Bill Gates", an insider's description of what happened inside Microsoft. It's really a great read. My favorite part was how the author inadvertantly insulted Bill Gates for his lousy BASIC code. :-)

  23. Implementing Visicalc by Gatton · · Score: 4, Informative
    Feel free to mod redundant if it's already been posted but I didn't see it.

    Read this website several months ago and it's quite detailed. Maybe more than you wanted to know but it's very detailed and is a good read.

    Implementing Visicalc

  24. Re:Didn't save any time by rewt66 · · Score: 2, Interesting

    Yes, the amount of time spent doing financial reports has pretty much stayed the same. But the ability to create scenarios, to play "what if" games, has led to much better financial information being available to corporate planners.

    It's like many other situations: You'll pay for as much information as you can get, rather than just get the same information more cheaply.

  25. Re:jEdit beats the pants off it by benzapp · · Score: 4, Insightful

    Not only that, but the original designer of VisiCalc describes this very issue in the article, and how the uniqueness of the spreadsheet made it very difficult to describe to the public at large. Only through immersion in the technology can you really understand and appreciate it.

    so, you forgot to preface your post with RTFA.

    --
    I don't read or respond to AC posts
  26. Re:jEdit beats the pants off it by OscarGunther · · Score: 5, Interesting
    The spreadsheet is productive, very. In fact, it doesn't mimic paper+calc+pencil for doing banking, it superceeds it.

    And yet VisiCalc was designed to mimic a real-world operation. IIRC, industrial planners used to have large blackboards divided into grids and each square in the grid could hold a number or an equation. When a number was changed in one square, all the dependent squares had to be recalculated. Of course, the concern was that something had been missed. I believe Bricklin heard one of his professors describe this process and chose it as his model for what eventually became VisiCalc.

    I think I read this in Cringely's Accidental Empires.

  27. Lotus Improv by jenglish · · Score: 2, Interesting

    Lotus Improv certainly sounds like something truly nifty (Google for it, there are a handful of articles about it on the web besides the one cited above). Which reminds me of Lotus Agenda, another reportedly supercool application that you can only read about today.

    I wonder how many other revolutionary applications Lotus developed and later buried?

    1. Re:Lotus Improv by I_M_Noman · · Score: 3, Interesting
      Lotus Agenda, another reportedly supercool application that you can only read about today. I wonder how many other revolutionary applications Lotus developed and later buried?
      You're correct -- Agenda was beyond cool. It remains my favorite piece of software ever. Damn, that thing ran my life for about three years. Then Lotus bought Organizer from Threadz and killed off development of an Agenda for Windows.

      As to your other question, let's see...Agenda was best-of-breed, as was was Magellan. I always liked LotusWorks better than MS Works on a DOS platform. Improv absolutely killed on the NExT, but was slow as shit on Windows. Oh, let's not forget Notes, which, when I saw it for the first time in '91, caused me to say "Well, that's the future right there."

      Ami Pro, while a terrific program, wasn't developed by Lotus. They bought it from Samna around the time that 1-2-3 r2.4 and r3.5 came out. Then they bundled it with those products (and a runtime version of Windows). I was convinced that Ami Pro was the coolest word processor I'd ever seen. I think I still am.
  28. Am I the only one... by trudyscousin · · Score: 2, Insightful

    ...who reads the name "Software Arts" and thinks of the innocence it implies?

    There once was a time when software really was art. Now, it's a steely business. Back in 1979, Bill Gates was only some weenie whining because people were pirating paper tapes of his BASIC.

    --
    Those who can, do. Those who can't, write technology blogs.
  29. Re:jEdit beats the pants off it by saddino · · Score: 3, Insightful

    The spreadsheet has no real-life corollary

    Technically, it was real-life that gave Bricklin his idea in the first place. To quote:

    Bricklin has spoken of watching his university professor create a table of calculation results on a blackboard. When the professor found an error, he had to tediously erase and rewrite a number of sequential entries in the table, triggering Bricklin to think that he could replicate the process on a computer....

  30. Re:Capitalism by IncohereD · · Score: 2

    in a non-captialist society, we could work less. But since we are all wage slaves, we'll keep working all week.

    Nah...because there'd always be someone working harder than you in some other society, and eventually they'd come take your cake. Sad but true.

  31. And still going strong! (probably) by Sabu+mark · · Score: 2, Interesting

    I'll bet you a million dollars that there's at least one company, or even more likely a government agency, that still uses VisiCalc because they never had the motivation to update all their data.

    --

    What Would Jesus Do
    (for a Klondike bar)?
  32. Re:Software History website basically a placeholde by Xaroth · · Score: 2, Informative

    Quoth the article:

    In May, the Software History Center in Boston reunited veterans of the PC's first decade to reminisce and exchange war stories. The luminaries included the three principals behind VisiCalc: Dan Bricklin, who conceived the idea; Bob Frankston, who programmed VisiCalc; and Dan Fylstra, whose VisiCorp brought the product to a surprised world. Here are edited versions of interviews with all three.

    Given that it was the original source of the interviews, it seemed appropriate to mention it in the synopsis.