Slashdot Mirror


VisiCalc Creator Developing WikiCalc

An anonymous reader writes "ZDNet has an article about a new wiki that is trying to combine the collaboration of wiki technology and the data manipulation attributes of a spreadsheet. The creator of VisiCalc, Dan Bricklin, is working on an alpha version of WikiCalc for sometime late in February." From the article: "'It holds a lot of promise, both because it's using the spreadsheet metaphor, which is the one thing people know for working with quantitative information and because 'there's nobody better in the world to build this thing,' said Ross Mayfield, CEO of collaboration software maker SocialText. To Mayfield, WikiCalc is the answer to a problem that has been percolating for some time in the world of IT. That is, he said, that spreadsheets have traditionally been a single-user application screaming for functionality that could let multiple people edit data quickly and easily. "

139 comments

  1. Yup, exactly what buisness needs by AuMatar · · Score: 5, Funny

    The ability to make more absolutely pointless spreadsheets.

    Hell, why not just a regular wiki anyway? I figure 90-95% of all the spreadsheets I see don't do any calculations, they're just used as a way to put things in columns.

    --
    I still have more fans than freaks. WTF is wrong with you people?
    1. Re:Yup, exactly what buisness needs by lawpoop · · Score: 1

      "Hell, why not just a regular wiki anyway? I figure 90-95% of all the spreadsheets I see don't do any calculations, they're just used as a way to put things in columns."

      Do regular wikis have column and cell editing features? Most of what I'm familiar with work like line editors.

      --
      Computers are useless. They can only give you answers.
      -- Pablo Picasso
    2. Re:Yup, exactly what buisness needs by caffeinemessiah · · Score: 5, Interesting

      Perhaps many business won't need it, but I know a lot people who will. The combination of a web interface with easy and intuitive (read: not MS Office's reviewing features) multi-user functionality could help, for example, a manager easily collect numbers from multiple people on a team. For the manager, all the data is in one location as it comes in and accessible when he wants it, not as emails with separate Excel attachments which he has to paste together. Or if I'm collecting data in my lab but want to review it at home, then I can just use an online spreadsheet and don't have to do the usual transfer via network/ftp/usb/email/cvs. Believe me, the applications for online tools ARE out there -- there's a reason Microsoft is releasing their uncharacteristic Windows Live nonsense.

      --
      An old-timer with old-timey ideas.
    3. Re:Yup, exactly what buisness needs by truthsearch · · Score: 2, Insightful

      In the financial industry I've seen mini-applications where spreadsheets were the whole data store. Many financial analysts live in Excel. Spreadsheets can be a powerful, useful tool. But most often they grow into horribly ugly monsters that the IT department has to de-tangle and cram into custom apps.

    4. Re:Yup, exactly what buisness needs by bb5ch39t · · Score: 4, Insightful

      I've seen this problem here (I'm in IT). A really smart Actuarial creates a very good, effective spreadsheet. It becomes both production and "mission critical" to them. The Actuarial leaves. Oh, did I mention that there is nothing documented? And the person is a Ph.D using calculations that are not understandable to mortal man (or even a woman!). Who supports this? Especially when it breaks because desktop support rolls out the next version of Excel. Screams abound!

      And I giggle because I'm a dino running on old, obsolete mainframe technology where the end user can't just slap something together and put it into production.

    5. Re:Yup, exactly what buisness needs by Anonymous Coward · · Score: 0

      TWikiCalc already exists, but could be better. If anyone used it (they don't locally anyway). Someone imagines this can be turned into a business?

    6. Re:Yup, exactly what buisness needs by dr.badass · · Score: 3, Insightful

      I figure 90-95% of all the spreadsheets I see don't do any calculations, they're just used as a way to put things in columns.

      This is exactly the reason that one of my favorite apps, OmniOutliner (Mac OS X) was created.

      "when the Excel product manager got up on stage at MacWorld several years ago and said, "We've found that 85% of our customers use Excel just to make lists and outlines," we (Omni) said, "Shoot, that'll be our next product. We can do a GOOD job of making lists and outlines, and sell it for a lot less."" -- Wil Shipley, Omni co-founder

      It seems like there might be a market opening up in the "things that people are already misusing Office for" sector.

      --
      Don't become a regular here -- you will become retarded.
    7. Re:Yup, exactly what buisness needs by Anonymous Coward · · Score: 0

      Twiki http://twiki.org/ has a module that lets you edit cells. See Edittable in the list at http://twiki.org/cgi-bin/view/Plugins/PluginPackag e.

    8. Re:Yup, exactly what buisness needs by metallic · · Score: 2, Informative

      There's already Microsoft SharePoint out there already that allows you to do just that... and it's been out there for quite some time now too.

      --
      Karma: Positive. Mostly effected by cowbell.
    9. Re:Yup, exactly what buisness needs by WindBourne · · Score: 1

      Yeah, we should be doing this with Power Point instead. Then we will have REAL productivity from PM's, PHBs, etc. Soon, we can all work together on nice displays.

      --
      I prefer the "u" in honour as it seems to be missing these days.
    10. Re:Yup, exactly what buisness needs by Bing+Tsher+E · · Score: 1

      And I giggle because I'm a dino running on old, obsolete mainframe technology where the end user can't just slap something together and put it into production.

      You find it sort of amusing to maintain a chokehold on the data, eh? For better or for worse, there are whole categories of management now dedicated to eliminating people like you from the hierarchy.

      Your aforementioned cited problem isn't solved by ossified data structures and vintage business hierarchies. Which you are a part of.

  2. Prior art? by grub · · Score: 5, Funny


    a new wiki that is trying to combine the collaboration of wiki technology and the data manipulation attributes of a spreadsheet.

    Isn't that how Enron ran its entire accounting department?

    --
    Trolling is a art,
  3. Cool by Anonymous Coward · · Score: 0

    It'll be useful for general estimates and stuff but if I really want to know the reliable accurate values, I will have to look elsewhere.

    1. Re:Cool by Jonnty · · Score: 1

      I hope you're joking.

      --
      Any grammatical or spelling errors above are for comic effect, and do not signify imperfection in the writer.
  4. Databases and custom UIs by truthsearch · · Score: 4, Insightful

    spreadsheets have traditionally been a single-user application screaming for functionality that could let multiple people edit data quickly and easily.

    Hence corporations all having relational databases with custom GUI applications. Spreadsheets are most useful for tabular data, which of course works well in relational database tables. While spreadsheets are great at free-form manipulation and "playing" with the data, it's the custom apps that are required to sqeeze that data into the corporation's customs workflows. For at least 20 years what corporations have been doing is creating the custom apps and having them export to more freeform data models like spreadsheets as needed. This seems to work pretty well.

    But "supercharging" spreadsheets won't really be providing power to the people that need it. The people that most need power over large amounts of data have hundreds of people working in their IT departments.

    1. Re:Databases and custom UIs by hey! · · Score: 4, Insightful

      preadsheets are most useful for tabular data, which of course works well in relational database tables.

      I'd go farther. Spreadsheets exist to capture the structure of calculations. Data should as far as possible never go in them. The only unequivocal exception to this are parameters used in the calculations (e.g. "assuming the rate of inflation is i...").

      In practice people do have to stage derived data in their spreadsheets, but this is dangerous and leads down the road to the major use of spreadsheets in businesses today: as an ad hoc "direct manipulation" database. This is a dreadful, hair-raising practice. Many a time I've looked at results that don't make sense, because one cell got separated from its brethren in a sort.

      --
      Post may contain irony: discontinue use if experiencing mood swings, nausea or elevated blood pressure.
    2. Re:Databases and custom UIs by hazem · · Score: 2, Interesting

      because one cell got separated from its brethren in a sort.

      I was "upgraded" to excel 2003 this summer, which caused such a decrease in my productivity.

      One new "feature" is that the ever ubiquitous ctrl-A, which every other app, and all older versions of Excel used to "select ALL", no longer selects ALL. Excel 2003 now tries to look at the group of cells you're currently sitting in, and selects what it thinks is a convenient group. The problem is, if there's a gap in a column, it won't reach across all of your data - just to that column-border.

      So, you do a ctrl-A, and a sort, and all of a sudden all your data is no longer correctly associated across the row like it used to be.

      What a great surprise that was, to get this great new feature... especially when I got to throw out an entire day's work because I had no way to rearrange my data back into the correct order.

      The fix is to use the box at the corner of column letters and row numbers (upper left). Or, as is entirely obvious, and just like all other aps... hit ctrl-A twice.

      Thank you, Microsoft.

    3. Re:Databases and custom UIs by Bing+Tsher+E · · Score: 1

      There's nothing worse than a 'Usability' cretin at Microsoft who decides that because the majority of tards using their product poke around at the data with a mouse like a small child with a plate full of vegetables, we all poke away at our data with mouses. The specific way this has become apparent to me was an instance of 'popup help' recently. I enter data in the lab from time to time into an Excel sheet. I also periodically use the [alt][file][save] keystroke sequence to save the data when I have finished a subgroup within the test (this is a Microsoft product we are talking about- it WILL crash and take the data with it).

      Little old clippy popped up after I had done this a few times with the 'helpful tip' that I could 'just click the save icon' up on the toolbar. Yeah. I could reach over to the mouse, drag a pointer all across the screen to a specific location, then click it, instead of just hitting [alt][f][s]. Luckly there was a 'stfu and NEVER bug me about crap like that again' option in the Clippy popup window.

      It's funny in a sad, pathetic way, to watch a mouse-bound Windows user navigating a screen. So often there is a 'click click click' method of keyboard shortcuts they could use.

      If you're in a particularly cruel mood and it isn't an essential task being completed, you can walk up to a mouse-poker's keyboard and fire off some [alt][f4] sequences. Snap! Snap! Snap! everything is closed, even sometimes the whole machine initiates a shutdown sequence. And poor mouse-poker-tard doesn't know what you did. Usually they just grip the mouse even harder, holding on for dear life.

    4. Re:Databases and custom UIs by adoll · · Score: 1
      Sounds like more people should be using linear algebra and matrix math. Just don't try it in Excel.

      And another oddball use of spreadsheets that will curl most people's short hairs.

      -AD

    5. Re:Databases and custom UIs by Pentagram · · Score: 1

      Surely Ctrl-s works in Excel?

    6. Re:Databases and custom UIs by hazem · · Score: 1

      I like the rhythm of Alt-F, S... I can hit "Alt" with the thumb, rock forward to hit F, and roll over to to hit S.

      Ctrl-S requires and ackward attack with the pinky.

      The thing it, wouldn't it be irritating if in a new versin of Excel they change "ctrl-S" from "save" to "exit without saving" - and didn't bother to tell anyone.

      Their unadvertised change of ctrl-A lost me just as much work - and it can't have been an accident. The new action of ctrl-A had to have been specifically programmed. They're good at pop-up boxes. Why not have a pop-up happen the first time I use ctrl-A telling me "You're trying to select all. We've enhanced ctrl-A so it doesn't select all." I'm sure that could have fit somewhere in all that bloat.

    7. Re:Databases and custom UIs by Bing+Tsher+E · · Score: 1

      I wouldn't know, based on the 'shortcut help' clippy offers.

    8. Re:Databases and custom UIs by Anonymous Coward · · Score: 0

      Or, as is entirely obvious, and just like all other aps... hit ctrl-A twice.

      why, of course it's obvious, you ... erm ... select all 'alls'?

  5. WikiCalc by gEvil+(beta) · · Score: 5, Funny

    WikiCalc - the site where you get to decide what 2 + 2 equals...

    --
    This guy's the limit!
  6. Total Bullshit by chill · · Score: 5, Informative

    "With (Excel), you get people playing e-mail volleyball with attachments all day long, so it's grossly inefficient," Mayfield said. "How do you track changes on a spreadsheet? What happens if you don't have just two people going back and forth, (but) have a finance department of 40 people trying to roll up numbers."

    Share the workbook and multiple people can edit at the same time. I do this daily and have been using this feature for quite some time. Changes are highlighted w/notes on who made what change whenever you save. I haven't played "e-mail volleyball" regarding spreadsheets.

      -Charles

    --
    Learning HOW to think is more important than learning WHAT to think.
    1. Re:Total Bullshit by chill · · Score: 3, Informative

      To clarify, he's talking about doing instantaneous updates which would be an excellent feature that Excel does NOT have. But, to slam Excel as not being able to share AT ALL is pure BS.

        -Charles

      --
      Learning HOW to think is more important than learning WHAT to think.
    2. Re:Total Bullshit by verisimilitudo · · Score: 2, Interesting

      Shared workbooks in Excel are very good for specific instances: they work fine, so longs as the datasets aren't huge, everyone knows when they're going to synchronise/update, nobody, but nobody get's a connection problem, Excel doesn't crash and nobody's box goes down. And if one of those happens mid-save, your spreadsheet could be toast.

      Excel has many features that allow it to be used as a sort of database - I've even seen heavily 'locked down' workbooks relying on enormous quantities of VBA code working as client applications to databases. Encouraging that, though, is a sure-fire way to ensure that you IT/IS department will have to intervene when the next system upgrade breaks something.

      Don't use them for anything mission-critical. That would be silly. You'd even be safer with Access for that.

    3. Re:Total Bullshit by Anonymous Coward · · Score: 0

      Groove (MS) already does this, although updating conflicts do limit it's utility when many people are saving at the same time.
      http://www.groove.net/index.cfm/pagename/hp_forms? home=hp-data

    4. Re:Total Bullshit by rachit · · Score: 1

      I think you need to chill.

    5. Re:Total Bullshit by sootman · · Score: 1

      Except that turning on sharing doesn't work well across teh intarnets.

      --
      Dear Slashdot: next time you want to mess with the site, add a rich-text editor for comments.
    6. Re:Total Bullshit by danharan · · Score: 1

      Sure, people could share files, and email the link.

      In practice, offices don't do that. It'll be easier for the PHB to have it explained that you can do this in a browser than how to turn on sharing.

      --
      Information: "I want to be anthropomorphized"
    7. Re:Total Bullshit by chill · · Score: 1

      In practice, offices don't do that. It'll be easier for the PHB to have it explained that you can do this in a browser than how to turn on sharing.

      Uh, no. Tools --> Share Workbook.

      And PHBs may not know much, but I guarantee you they grasp the basics of at least PowerPoint and Excel, with the Outlook Calendar not far behind.

      In practice, most offices that use spreadsheets at all do just that. They put the sheet on a shared drive that is mapped on boot and access it thru a link in their "My Documents" or on their desktop. Excel is massively popular and sharing workbooks is very simple. The main drawback is it is difficult to do thru the Internet or a WAN link.

        -Charles

      --
      Learning HOW to think is more important than learning WHAT to think.
    8. Re:Total Bullshit by Anonymous Coward · · Score: 0

      Great ! Drive mapping. Nice path for worms...

    9. Re:Total Bullshit by marcello_dl · · Score: 1

      Well sharing is a solution, but a perfectly working excel shared document is nowhere as flexible as one available to internet clients. Its not always feasible or economical to get an excel environment to remotely add review spreadsheet data (Id have to dual boot into osx and get an office license, for example. And, would sharing work with office-mac?)

      And what about other web clients, like PDAs? Net cafes kiosks?

      --
      ---- MISSING MISCELLANEOUS DATA SEGMENT --- [sigdash] trolololol
  7. Don't discount it... by New+Breeze · · Score: 4, Insightful

    Think about things like budgeting/forcasting in a large operation with multiple departments, all of whom need to work on their individual sections. You end up with either lots of spreadsheets that are linked together if you're lucky, or everyone taking turns at the master spreadsheet. If they get a decent selection of formulas working this could really simplify things for stuff like that.

    1. Re:Don't discount it... by truthsearch · · Score: 1

      I don't see how this could really be accomplished anytime soon without custom apps. Any large corporation has hundreds of software developers. One core job the IT department is workflow. They've been writing custom apps to handle this sort of thing for decades.

      Would it be nice for a more generic app to save on software development? Of course. But I can't imagine a magical tool that easily fits in without needing massive customization.

  8. I don't even understand what that means by Anonymous Coward · · Score: 3, Funny

    What exactly would you do with a spreadsheet/wiki cross if you had one? I just can't visualize a use case. It sounds like the people doing this chose their product by taking a bag full of buzzwords written on refrigerator magnets and pulling out two at random. "Oh, we're going to make an AJAX... microcontroller!"

    1. Re:I don't even understand what that means by koh · · Score: 1

      You want a use case? I'll give you a use case.

      At home, my wife and myself already use a wiki to keep track of things to do, current events, the progress of our baby, etc.

      A wiki coupled with a spreadsheet would bring us:
      - An easier way to share tabular content or to format content in tabular form (file listings, tasks, events),
      - An easier way to balance accounts. Well, easier than GNUCash anyway :)
      - A collaborative framework to implement useful computations. If you consider formulas as functions, you have an easy-to-use language to create, use, or extend functions, coupled with a transparent revision control system.

      Needless to say, since Visicalc was The First One, I'm more than interested in this idea, and I think that, properly handled, it has quite a potential.

      --
      Karma cannot be described by words alone.
    2. Re:I don't even understand what that means by coofercat · · Score: 2, Interesting

      I've got another one:

      In my small business, I have to send my accountant monthly spreadsheets of the bank activity, what invoices I've sent, and what expenses I've claimed. Pretty simple stuff.

      Now if I have two people doing that, we can both be adding stuff in, and our accountant gets to see it as it happens.

      Granted, this is possible with Excel sharing, or SharePoint, but the point here being that (a) it's simple and (b) is web based and (c) it doesn't require all of us to share a fileserver and (d) it's open (standards|source).

      If I could convince my accountant to use something like this, it would save a lot of batting spreadsheets about (since we don't share a file server).

      I'm not convinced it's 'revolutionary' (or even that unique), but It's certainly a Good Thing, and no doubt has possibilities I/we haven't thought of (just like Wikis a few years back).

    3. Re:I don't even understand what that means by geekoid · · Score: 1

      can't you use a financial program like quicken and then send your accountant a report? I believe(could be wrong though) you can export the reports to excel.

      --
      The Kruger Dunning explains most post on /. http://en.wikipedia.org/wiki/Dunning%E2%80%93Kruger_effect
    4. Re:I don't even understand what that means by Anonymous Coward · · Score: 0

      Having edited a number of wikipedia articles, I can definitely see how a combined spreadsheet-wiki could improve wikipedia:

      1) Easy handling of tabular data, which is currently a pain in wikipedia. Whenever the tabular data consists of numbers, basic spreadsheet functions become useful for summary rows and columns.

      2) Links between numerical data in different articles - currently there are plenty of articles that refer to the same numbers, and consistency is up to the people editing the stuff. A spreadsheet-wiki combination should make it easy to keep each number in a single place, yet show the same data (or simple functions of data, such as the maximum or minimum) in multiple artciles.

      The clincher is whether such functionality can be made easy to use. With the current state of web interfaces, I'm skeptical, but if they can do it, it could be wonderful.

  9. Mod Parent UP! by mekkab · · Score: 2, Informative

    We have conference calls sitting around an excel sheet populated by other data, and we make our updates, save 'em, and let the main conference holders know, they reload, and its all populated and shared. In near-real time. And we use net meeting, too.

    --
    In the future, I would want to not be isolated from my friends in the Space Station.
    1. Re:Mod Parent UP! by ediron2 · · Score: 1

      Yeah, that's as good as a wiki.

      Not.

      One company I was at (several hundred very-distributed people) paid $45000 to put in a conference call server. It paid for itself in a few months, we'd gotten so addicted to conference calls without paying attention to the per-line per-minute costs. Even WITH the conference server and a VOIP or similar way of making intra-corporate calls insanely cheap, there's still a per-office broadband cost to shuttling a gig per day of voice data around, especially when you're talking about something as lightweight as a few fields changing in spreadsheet data.

      Meanwhile, a wiki server runs on old crap hardware from anywhere, the client is ubiquitous and can run on even the oldest PC, and the wiki tracks changes automatically. I'd imagine a wiki-spreadsheet would allow people to create personal sheets that wander off on tangents (blue-sky ideas, projections, personalized metrics that they care about) and still retain source linkages to *real* data. Those tangents would be shared by default, which would be cool considering off uses like field-editing crappy company phone/email directories and etc. I've encountered over the years.

      Don't get me wrong, there's *VALUE* to quick/easy solutions like conference-calls for discussing revisions. The best tools are ones easy enough to be widely used, after all. But don't mock a wiki for being useless just because other tools exist. Besides, hitting 'refresh' on a browser is faster and easier than any shared-Excel paradigm you can possibly contrive. It just IS.

    2. Re:Mod Parent UP! by mekkab · · Score: 1

      Yeah, that's as good as a wiki.

      Not.


      FYI: saying "not" went out in 1995. Welcome to the future! ;)

      Even WITH the conference server and a VOIP or similar way of making intra-corporate calls insanely cheap, there's still a per-office broadband cost to shuttling a gig per day of voice data around, especially when you're talking about something as lightweight as a few fields changing in spreadsheet data.

      Okay, perhaps I wasn't clear enough on our usage. The conference call is going to happen anyway. Wiki or Excel, it doesn't matter. These are mission critical issues that need to be addressed on a daily basis because they involve integrating different groups. Perhaps its a bit micromanaging, but there is no room in the schedule. So this is a Business Process issue, not really a spreadsheet technology choice.

      As for the spreadsheet, how it works is this: you make your changes to the rows that concern you. If you're good, you do it before the meeting even happens; no extra network overhead. If you miss a few things, you update the rows of interest to you; be it 2, or be it 20. You push out your changes (less than a megabyte for the sheet) the central people reload the changes (Meanwhile, a wiki server runs on old crap hardware from anywhere
      You sure about that? I mean, a server is a server; and a crappy server will buckle under load. WE're talking about networking now; not about "Layer 7" applications (to use the OSI model).

      But don't mock a wiki for being useless just because other tools exist. Besides, hitting 'refresh' on a browser is faster and easier than any shared-Excel paradigm you can possibly contrive. It just IS.

      I'm not mocking a wiki for being useless, I'm mocking Mr. VisiCalc for ignoring the current world around him.
      And I dunno, hitting refresh on Excel is pretty damn easy. YMMV.

      --
      In the future, I would want to not be isolated from my friends in the Space Station.
  10. JotSpot Tracker? by br0ck · · Score: 1, Interesting

    This sounds pretty similar to JotSpot Tracker.

  11. Or... by truthsearch · · Score: 1

    Calcopedia?

    Calco Anarchy?

    1. Re:Or... by Anonymous Coward · · Score: 0

      Do the world a favor and never try to name anything.

    2. Re:Or... by mikiN · · Score: 1

      I vote for Wikimathica, to go with the lingo

      --
      The Hacker's Guide To The Kernel: Don't panic()!
  12. Great, he's handing... by WED+Fan · · Score: 2, Insightful

    ...a new tool to add money to the big boys' pockets. Saw an interview with him years ago. He tried to make it sound as if creating a program that eventually put billions into the coffers at Lotus and Microsoft but left him with a teachers salary didn't sting all that much. But, it was evident in his eyes that he was stung and felt he missed the boat that made young millionaires out of the geeks of the late '70s.

    --
    Politics is the art of looking for trouble, finding it everywhere, diagnosing it incorrectly and applying the wrong fix.
  13. OT: Check out his "Writings" page by Anonymous Coward · · Score: 0

    On his "Writings" page he has some interesting thoughts about the music industry. He seems like a pretty levelheaded guy to me - not one of the "downloaders should be jailed" types, but not a raving "everything should be free" fanatic either. Worth your time IMO.

  14. Maturity of alternatives by Lord+Satri · · Score: 1

    From TFA: WikiCalc's potential success, however, also assumes that Bricklin--who in recent years has been consulting, speaking and running his small software company, Software Garden--can effectively get the word out.

    This appears to be a main point to me. Marketing and user adoption. The article refers to various existing alternatives: honestly, I don't care that much about having 5 collabo-spreadsheet alternatives, I just want one that will do what I want bugless with plenty of features. Take OpenOffice spreadsheet (I love OOo :-), you can't export spreadsheets to html (xhtml actually) with graphics and diagrams. This is only one example. I want mature OSS, and only once that is achieved, then OSS becomes really interesting alternatives to commercial software. (and yes, I do help the developers to the best of my abilities)

  15. It's dead if it doesn't do Excel macros by winkydink · · Score: 1

    because that's what a lot of the budgeting and forcasting stuff is built on. Think those bean counters are going to take a flyer on some new app, learn a new way to write macros and see what happens? In every company I've worked for, the finance department is an extremely busy place.

    --

    "I'd rather be a lightning rod than a seismometer." -Ken Kesey

  16. Uh, sharepoint? by briancnorton · · Score: 4, Informative

    I know there isn't an opensharepoint yet, but MS Sharepoint lets you do much of what they discuss. It was developed for exactly the same reasons, and it does a pretty good job if people know it and use it.

    --

    People who think they know everything really piss off those of us that actually do.

    1. Re:Uh, sharepoint? by bill_kress · · Score: 1

      PLEASE tell me how to use it!! We have been trying for ages now.

      The biggest problem is that it is virtually impossible to navigate the areas. For word documents you get a semi-sharing system. It's sort of what you'd get if you put a document in version control--the merge isn't good, but it's possible.

      However, as far as I can tell, the Excel portion is horrific. There is really no decent merge, it's no better than putting it in version control.

      If I'm wrong about it, would you please refer me to a summary of how to use this tool?

      Thanks

    2. Re:Uh, sharepoint? by nollaigoc · · Score: 1

      "If I'm wrong about it, would you please refer me to a summary of how to use this tool?" Hey, we don't do user interface information, EU don't need interface information either, but we will license the source code for $50K.

  17. a way to put things in columns by Expert+Determination · · Score: 3, Interesting
    So true. I wonder if someone could release a spreadsheet for a few hundred bucks that has no computational facilities only. Just arranges things in a grid and allows you to choose your font. That would probably satisfy 95% of users of Excel.

    Personally, I was disappointed when I found that spreadsheets only ran the formulas forward so that if I typed in A1=2*B2 it wouldn't work out B2 from A1. Seems almost as useless as formattable grid to me.

    --
    "The White House is not an intelligence-gathering agency," -- Scott McClellan, Whitehouse spokesman.
    1. Re:a way to put things in columns by d'fim · · Score: 2, Funny

      If you consider auto-increment to be part of "arrangement", then I'm with you.

      --
      Adherence to the truth is a form of disloyalty.
    2. Re:a way to put things in columns by MindStalker · · Score: 1

      Personally, I was disappointed when I found that spreadsheets only ran the formulas forward so that if I typed in A1=2*B2 it wouldn't work out B2 from A1. Seems almost as useless as formattable grid to me.

      Your kidding right???

    3. Re:a way to put things in columns by mikiN · · Score: 1

      Maybe the GPP is generalizing too much on all spreadsheet software out there, but I can think of several scenarios which many spreadsheets may have difficulty solving.

      Given the example, what if B2 contains a formula which itself (recursively, conditionally) depends on A1?
      Only if the spreadsheet app contains or has access to a reasonably sophisticated CAS (Computer Algebra System) like Maple or Mathematica can you expect it perform well in this regard.

      --
      The Hacker's Guide To The Kernel: Don't panic()!
    4. Re:a way to put things in columns by MindStalker · · Score: 1

      And what I meant was he has to be kidding if he seriously expects a spread sheet to do that. Yes possibly a very specialized app but not one included with every office suite.

    5. Re:a way to put things in columns by Expert+Determination · · Score: 2, Interesting

      You don't need a computer algebra system at all. There is a tendency for people to reach for computer algebra tools (that cost thousands) when a much smaller tool would do. In this case every numerical methods book has algorithms for solving nonlinear sets of equations. They fail for many problems, but most are good enough to solve the kinds of equations that might occur in everyday life for spreadsheet users: eg. "what time period should I pay this loan over if I can afford this monthly payment?" or "how many of these widgets do we need to sell to break even next quarter?". I was so let down when I first discovered that most spreadsheets couldn't do this. (Though you can buy plugins that will.)

      --
      "The White House is not an intelligence-gathering agency," -- Scott McClellan, Whitehouse spokesman.
    6. Re:a way to put things in columns by Anonymous Coward · · Score: 0

      Why should he be kidding ? Excel killed the competition.

      I remember when TK!Solver (http://en.wikipedia.org/wiki/TK_Solver>) on the Mac was the hot thing (ouch, I show my age). Of course, if you want to go to the current TK website, you'll end up with deserved error messages (hey, the web site is .asp with sql server, what would you expect ?), but you can get screen shots on the web anyway (http://www.economicsnetwork.ac.uk/cheer/ch15_1/tk solver.htm>)

      Unfortunate that excel killed competition and failed to innovate. A spreadsheet could be much more than what excel is...

    7. Re:a way to put things in columns by Anonymous Coward · · Score: 0

      (With working links)

      Why should he be kidding ? Excel killed the competition.

      I remember when TK!Solver (http://en.wikipedia.org/wiki/TK_Solver) on the Mac was the hot thing (ouch, I show my age). Of course, if you want to go to the current TK website, you'll end up with deserved error messages (hey, the web site is .asp with sql server, what would you expect ?), but you can get screen shots on the web anyway (http://www.economicsnetwork.ac.uk/cheer/ch15_1/tk solver.htm)

      Unfortunate that excel killed competition and failed to innovate. A spreadsheet could be much more than what excel is...

    8. Re:a way to put things in columns by jgclark123 · · Score: 1

      M$ Excel's interface is enough to make someone convert to OpenOffice. And for such a complicated interface, one would expect a lot of complex features. One would be mistaken.
      I guess the best bet would be to make OpenOffice Math actually perform equations, rather than just format them. Then it could be integrated into OpenOffice Calc.

      I know it's a little off topic, but as a little side note about calculus programs, I copied the Derive program files folder onto my USB thumb drive at school, so now I have a PortableDerive. Unfortunately, I need to install two fonts for it to not look like shit...

      --
      "May evil beware, and may good dress warmly and eat plenty of fresh vegetables." -The Tick
    9. Re:a way to put things in columns by Anonymous Coward · · Score: 0

      Why not? Yes, it's difficult to implement and would not be able to solve everything, but surely it's the computer program that should be doing the effort, not the (on average) dumb user. After all, even if the solver in the uber-spreadsheet is incomplete, I'm sure it would beat the solving abilities of the average spreadsheet user. Right now, when faced with complications the user is stumped, but he/she would love to have the computer work out the problem for him/her. That's what the computer is for.

      Creating a sufficiently smart, complete and user-friendly solver might grow into a user effort, but there happens to be a spreadsheet vendor that is making monopoly profits and could afford such an effort... and it doesn't have to solve everything in the first version.

    10. Re:a way to put things in columns by bobbyjack · · Score: 1

      M$ Excel's interface is enough to make someone convert to OpenOffice.


      More worrying is their proposed 'solution' to managing that complexity.
    11. Re:a way to put things in columns by bhtooefr · · Score: 1

      And there are features like that buried in Excel. Reverse Calculation or something like that.

      Just remember, it's BURIED.

  18. Careful where you tread... by RyoShin · · Score: 4, Funny

    This is all well and good, until every cell reads "Penis".

  19. Disconcerning by chill · · Score: 1

    And what happens when, like the author suggests, you get 40 people together to edit a single spreadsheet? Let me see how well they -- the people -- handle seeing a spreadsheet automagically updating it self from 40 different sources at once. They're not going to know what is safe to touch, what is up to date, or WTF is going on. It is going to be sensory overload as stuff keeps chaning on your screen while you're typing.

      -Charles

    --
    Learning HOW to think is more important than learning WHAT to think.
    1. Re:Disconcerning by RollingThunder · · Score: 1

      Indeed. I have this vision of a spreadsheet behaving like the Fridge Magnet site, with letters constantly getting yanked out from underneath you.

      http://web.okaygo.co.uk/apps/letters/flashcom/inde x2.htm

    2. Re:Disconcerning by poopdeville · · Score: 1

      Have you ever used a wiki? If two people edit simultaneously but one finishes first, the second has to merge the first edit into the second. That's all. SVN works like this too. There's no "stuff moving on the screen."

      --
      After all, I am strangely colored.
    3. Re:Disconcerning by chill · · Score: 1

      Have you ever used a wiki? If two people edit simultaneously but one finishes first, the second has to merge the first edit into the second. That's all. SVN works like this too. There's no "stuff moving on the screen."

      Quoth the article: "Bricklin's answer is to make it possible for anyone using WikiCalc to enter data and for anyone else to edit that data and have those edits be reflected on everyone's computers instantaneously."

      I updates come across to my screen when someone else merges, then that is what I'm talking about. What happens when 20-30 people hit "merge" a few seconds apart? What is *my* screen going to do? If it starts popping in updates while I'm scrolling/typing/editing it is going to create serious problems.

      Spreadsheets aren't text documents. With a traditional wiki the vast majority of your users are doing one word edits then updating. If this thing automatically updates when someone finishes editing a cell, then chaos will ensue in direct proportion to the number of people editing.

      If it doesn't do this, then how the hell is it all that different from Excel or any traditional spreadsheet that allows multiple users to edit at the same time? If it is just because it is "on the web", that isn't a huge deal and not what they seem to be pushing.

        -Charles

      --
      Learning HOW to think is more important than learning WHAT to think.
  20. that's the point! by poptones · · Score: 4, Interesting

    But "supercharging" spreadsheets won't really be providing power to the people that need it. The people that most need power over large amounts of data have hundreds of people working in their IT departments.

    Your last sentence summed it up very well: companies presently pay a LOT of people simply to move data from app to app. A collaborative spreadsheet could change workflows in significant ways that we, having never before used such an app, cannot readily predict.

    I think it's a bloody fantastic idea, and so simple and obvious it seems odd to think such an app doesn't yet exist.

    1. Re:that's the point! by poopdeville · · Score: 2, Insightful

      It does. This is obviously just an RDBMS with a web front end and hooks for writing (and probably saving) your own "mathematical" SELECT statements. Big deal.

      --
      After all, I am strangely colored.
    2. Re:that's the point! by rsborg · · Score: 2, Insightful
      It does. This is obviously just an RDBMS with a web front end and hooks for writing (and probably saving) your own "mathematical" SELECT statements. Big deal.

      And a podcast is just a RSS based distribution of sound and video media. But it is a good implementation and use of RSS, and a WikiCalc would be a great use of wiki.

      Some of the best most obvious innovations seem rediculously obvious in hindsight, but that doesn't detract from their greatness (in fact, you could just say they were elegant)

      --
      Make sure everyone's vote counts: Verified Voting
    3. Re:that's the point! by poopdeville · · Score: 1

      The point is that it's been done. Many times. myspreadsheet.com is an example. It wasn't just obvious in hindsight. It was always obvious.

      --
      After all, I am strangely colored.
  21. Database? by j_kenpo · · Score: 1

    Hmmm lets see. A rows and columns type structure similar to a spreadsheet that lets multiple users edit and view data, and can link in other similar structures in some sort of relational way.... and provides simple functions for doing calculations... this sounds like a RDMS. Im not sure, but I have the feeling this technology has been around for many years.

    1. Re:Database? by j_kenpo · · Score: 1

      Oh... almost forgot. It uses the technology of the minute, AJAX, so it must be revolutionary.

      While I admit that an AJAX front-end giving the look and feel of a spreadsheet that allows large-scale collaboration for companies is a cool concept, now it will allow for any idiot to change those crucial forecasting numbers for the 4th quarter, which is kind of from a business standpoint, even if it is internal only.

    2. Re:Database? by Zigg · · Score: 1

      it will allow for any idiot to change those crucial forecasting numbers for the 4th quarter

      Riiiight... because "any idiot" is the policy Wikipedia has chosen, therefore anything with "wiki" in its name must also adopt the same policy!

      See if you can try to separate the technology from the policy. It's fun!

      (And if this hasn't beat some sense into you, then I'll spell it out plainly -- wiki technology is widely used in restricted environments, usernames and passwords, people with varying levels of access to the documents, etc., audit trails... nothing about this project suggests it's going to be a security nightmare.)

    3. Re:Database? by Lugae · · Score: 1

      A database is the correct structure for this kind of thing. However, not all of us want to us a database. Actually, I do. I prefer use a database to a spreadsheet any day. It's handy. I ask for the information that I need, and I get it back. I write a script to help me visualize the data or perform calculations, and it's great.

      However, to a CSR, a spreadsheet is life. Unfortunately, the RDBMS isn't what a CSR is ready to use. CSRs want auto-filter, column-rearranging, sorting, etc. And they don't want to wait for a RDBMS geek to write them a script for their one task. They want to be able to do it immediately without asking anyone else.

    4. Re:Database? by j_kenpo · · Score: 1

      http://politics.slashdot.org/article.pl?sid=06/02/ 09/0433252
      http://politics.slashdot.org/article.pl?sid=06/01/ 29/1732238

      Even with usernames/audit trails, the only difference is the "idiot" is identifiable. I'm not condemning Wiki, in fact as far as knowledge bases are concerned, it is incredibly powerful as a starting point of research, and for the most part fairly accurate. But erronious information does make its way into Wiki, and as the above artcles point out, people with an agenda of their own can make changes, and no amount of "accountability" is going to change that. The same thing will occur with an online spreadsheet like application with Wiki-type properties. While it has potential to be a useful technology, just like anything, if not set properly, it will be abused.

      So I defend myself from your virtual "beating sense into my head" with an opionion better expressed by others.

      Or better yet from here.

  22. This is an Awesome Idea!! by logicnazi · · Score: 1

    I'm not entierly sure how many buisnesses will be willing to trust such a system. One needs to be carefull that your competitor hasn't inserted some special logic to screw things up when *your* data is entered into the system. Unlike wikipedia where everyone can see any devious attempts to change things code or calculations can seem fine and work fine on most data but contain subtle bugs.

    However, for plenty of individuals and personal buisnesses this seems like a great idea. All the time there are common calculational tasks we do that are programed over and over again. Super simple examples are dates being turned into days of the week or dollar amounts in various years being turned into 1970 (or some other amount) dollars. Some of these are tought because they require the right data (rate of inflation for each year) others are tough because they just involve lots of special cases. In any case having a wiki where people can use other people's work and build off of it seems like a great idea.

    In particular it seems like a code repository where you can just run the code right there. This is the biggest problem with code repositories now, often downloading the already written code and figuring out how the API works just takes too much time and since there is no guarantee that someone will download a whole code repository people tend to reinvent the wheel many many times.

    It would be great if ultimately this could support more than just a spreadsheet interface. A general wiki for *online* DHTML calculation tools, especially if it also had functionality to let you download the code or acess it as a web serice, would just be awesome. Maybe this already exists somewhere and I don't know about it but the idea seems great.

    Where ohh where will the magical internet take us next?

    --

    If you liked this thought maybe you would find my blog nice too:

  23. WikiPoop by GweeDo · · Score: 2, Funny

    I have just started working on WiKiPooP.com. This is a colabrative site where people can help each other figure out how to poop. Anyone can edit anyone elses poop to make it more accurate and to the point. This just goes to show that the WiKi is the future of allt hings!.

    1. Re:WikiPoop by Quintios · · Score: 2, Funny

      I could be wrong, but dang, http://www.wikipoop.com/ got /.'ed... :(

      --
      Anonymous Cowards are at -6...
    2. Re:WikiPoop by chris_eineke · · Score: 1

      POOP: Professional Object-Oriented Programming :-)

      --
      "All you have to do is be fragile and grateful. So stay the underdog." Chuck Palahniuk, Choke
    3. Re:WikiPoop by Anonymous Coward · · Score: 1, Funny

      The problem is that your toilet doesn't have broadband.

  24. In other words.. by tirnacopu · · Score: 1

    Dan Bricklin is currently the CEO of an unknown company, trying to make a living by selling a 27-year old idea with the "collaborative" buzz-word attached.

    1. Re:In other words.. by Anonymous Coward · · Score: 0

      If Bricklin wouldn't have come up with the idea when he did, someone else would have dumped it on the world six months later. The concept mimics the old ledger books that accountants spent hours penciling over, he was just the first to make it available in a computer form.

      Smart guy, sure, no doubt there. Honestly, though, what has he done since VisiCalc? He's just better at reminding people of his accomplishment.

  25. Num Sum by k3v1n · · Score: 1

    It's been done...

    Num Sum

  26. Prior bad art by digitaldc · · Score: 1

    Isn't that how Enron ran its entire accounting department?

    No, they just lied and made stuff up. No need for any data entry, ingenuity or even common sense.

    --
    He who knows best knows how little he knows. - Thomas Jefferson
  27. Sounds like... by slappy · · Score: 3, Informative
  28. That Will Teach Me to Post So Fast by logicnazi · · Score: 1

    I was being an idiot. He doesn't actually seem to be setting up a public wiki to host these kind of calculations but creating a spreadsheet sharing system for inside a company. Still usefull but much more boring.

    Hopefully someone will come along and do what I suggested anyway.

    --

    If you liked this thought maybe you would find my blog nice too:

  29. Sudoku! by cching · · Score: 1

    What I really want to know is, can multiple people play Sudoku using it?!

  30. AJAX.. hmm that's Good (TM) .. Microcontroller! by Anonymous Coward · · Score: 0

    Can I invest... pleaze!!!! I only want 60% of the returns when Google buys you out!

  31. Origin labs by andy314159pi · · Score: 1

    I think that they should use the origin labs program for feature ideas and whatnot. Linux needs a data visualization program like this. In the science community this is a final barrier for linux adoption. It is easy to write specialized programs for particular problems in linux, but for general data visualization and curve fitting there is no good alternative. The current spreadsheet programs are modeled after excel which is much more limited.

  32. Internal Audiance by nurb432 · · Score: 1

    I would agree with you, unless you restrict access to 'trusted individuals' only. Then its not much different then sending a spreadsheet around the office for updates.

    --
    ---- Booth was a patriot ----
  33. And in other late breaking news ... by grouchobear · · Score: 1

    Microsoft announces WikiPoint as an robust alternative to the venerable PowerPoint.

    1. Re:And in other late breaking news ... by chivo243 · · Score: 1

      is this taking wikipower to the breakingpoint?

      --
      Sig Hansen?
  34. Microsoft Products ..... by Anonymous Coward · · Score: 0, Funny
    Are illegal to be mentioned here on /.!

    You must be new here. So, I'll explain, Microsoft is Evil. Apple is Good. Google is in Pergatory.

    Gates is Satan, Jobs is God. McNeally of SUN, is good even though he is a MBA. Bill Joy, another God. Metcalf another member of the Panteon. You will learn about the others. Unfortunately, it will cost you moderation points and, maybe, have to post at -1 until you start another account.

  35. Wonderful... by Hank+Reardon · · Score: 1

    Now managers everywhere will have a Web-based, collaborative application to use in place of a database...

    --
    There's so little difference between politics and jihad lately...
  36. Revision Tracking with multiple users in Excel by everphilski · · Score: 3, Informative

    On the Tools menu, click Share Workbook, and then click the Editing tab.
    Select the Allow changes by more than one user at the same time check box.
    Click the Advanced tab.
    Under Track changes, click Keep change history for, and in the Days box, type the number of days of change history (change history: In a shared workbook, information that is maintained about changes made in past editing sessions. The information includes the name of the person who made each change, when the change was made, and what data was changed.) that you want to keep.
    Be sure to enter a large-enough number of days because Microsoft Excel permanently erases any change history older than this number of days.
    Click OK, and if prompted to save the file, click OK.
    easy enough. Straght from TFM

  37. and you're a bigger loser then? by Anonymous Coward · · Score: 0

    And you, what are your lame acheivements? This guy changed the world with his idea for the spreadsheet.

    Your worth to us is a lot less.

  38. Curse of dependencies by G4from128k · · Score: 2, Insightful

    The intricacies of spreadsheets make them much harder to edit in parallel. On a wikipedia entry it doesn't matter if one person edits something about the history of something while another person expands a section on the future. Aside from minor inconsistencies, which are easy to spot, the document is essentially the sum of its parts.

    In contrast, the parts of a spreadsheet have strict dependencies that can span the spreadsheet and affect correctness in subtle ways. For example, if one person adds a row in one section, how should formulas in a different section react (do range references to the row above expand to encompass the new row or do range references to the row below expand or neither?). "Trace dependencies" functions can help but only if each editor recognizes that the scope of their edits is potentially unbounded.

    The point is that it's harder to allow simultaneous independent edits because the internals of a spreasheet don't have independence.

    --
    Two wrongs don't make a right, but three lefts do.
  39. "New"?!? by Anonymous Coward · · Score: 0

    Ever heard of ODBC?

  40. calculation collaboration? by Anonymous Coward · · Score: 0

    Yes, but...

    In Soviet Russia, the expression evaluates you.

  41. MediaWiki already has semi-protection by tepples · · Score: 1

    The possibility of vandalism is why most publicly visible wiki spreadsheets would be run in semi-protected mode, where only logged-in users can edit. Many wikis already use semi-protection as the default for most or all pages.

  42. Just what I need... by Kozar_The_Malignant · · Score: 1

    A whole bunch of people mucking about with my data.

    --
    Some mornings it's hardly worth chewing through the restraints to get out of bed.
  43. the mire of shared documents by kevin.fowler · · Score: 1

    I work in content development that requires lots of data tracking, with multiple people working with the data at once. More than a few times, a shared doc has lead to some data toe-stepping. We actually use expressions to generate monthly reports, so I could see some sweet applications of this in-house.

    --
    Bury me in mashed potatoes.
  44. Wiki by BigZaphod · · Score: 3, Funny

    Uh oh... Is "wiki" becoming the new "i" which was the new "e" a few years ago?

    1. Re:Wiki by Anonymous Coward · · Score: 0

      I'll let you know as soon as I try out my new wikiPod.

  45. TurboDbAdmin? by poopie · · Score: 3, Interesting

    Sounds a lot like the turbodbadmin demo to me... just with support for formulas.

    http://turboajax.com/turbodbadmin.html

    in other words, "ajax-based web spreadsheet that uses a databse for backend datastore"

    Great idea - it effectively could kill excel for always-connected corporate environments where people are constantly fighting with different spreadsheet revisions and 2nd hand data.

    Give users the interface they know and mostly seem to love. No stupid ODBC drivers necessary. Works in any modern browser. Give the company accurate data in a real database. Win-Win.

  46. Excel Services by umeshunni · · Score: 1

    Not just that - but Office SharePoint 2007 includes Excel Services so that you can work with spreadsheet from your browser
    see http://blogs.msdn.com/excel/archive/2005/11/08/490 502.aspx

    1. Re:Excel Services by molarmass192 · · Score: 1

      Yeah ... but it's implemented as an ActiveX control ... so scratch "from your browser" and make that "from IE".

      --

      Good people do not need laws to tell them to act responsibly, while bad people will find a way around the laws-Plato
    2. Re:Excel Services by BradleyUffner · · Score: 2, Informative
      Yeah ... but it's implemented as an ActiveX control ... so scratch "from your browser" and make that "from IE".


      Umm... NO, read the artical linked. Read the snpped section below and note how it specificly says "No ActiveX".

      So what happened, exactly, to get the spreadsheet in the browser? Behind the scenes, Excel Services opened the file the sales analyst saved to SharePoint, refreshed any external data in the spreadsheet, calculated any formulas, and rendered the results in the browser. Specifically, Excel services sends only DHTML to the browser (no ActiveX), so the sales manager could be using any modern browser. The result is a very high-fidelity version of the analysis that the sales manager can interact with in the browser or, if they have permissions to do so, open up back in Excel. One point I want to make clear is that Excel 12 is the authoring tool for spreadsheets that run on Excel Services.

  47. SubEthaEdit by Anonymous Coward · · Score: 0

    It'd rather have SubEthaCalc, like the awesome OS X app "SubEthaEdit which allows you to edit a document with multiple users at the same time (easily!)

  48. mod parent "insightful" by Brunellus · · Score: 1

    Most people I work for seem to think "oh, Excel. Great--something we can use to make tables!"

    They'd be shocked to know it calculates.

  49. existing browser-based spreadsheets? by uw_badgers · · Score: 1

    Are there any currently existing broswer-based, sharable, editable spreadsheets? Or a place that hosts a sandbox for wikiCalc? I couldn't find a place to test out wikiCalc online.

  50. Next up: Wordstar by maynard · · Score: 3, Funny

    Yup. Now all we need is Michael Shrayer, the original author of The Electric Pencil, to write a decent wordprocessor / text editor for Wiki and we'll have an online Office replacement with wiki capabilities....

    Oh how I love all the recent computing innovation!

    1. Re:Next up: Wordstar by Anonymous Coward · · Score: 0

      writely.com is an excellent online collaborative and secure word processor. I already have 10 documents in there. Two of them are technical references for things like asterisk configuration with a certain voip router. My point is: it's good enough to use and it is compatible with OOo, Word, and pdf files.

  51. Already Out There? by wolff000 · · Score: 1

    I can see a use for it but why not just stick a regular spreadsheet out on a server and just have a shortcut. My office uses this for numerous things. The information is centralized everyone sees the updates and it's already in a format people are used to manipulating. So why make something else when we have solutions? I guess just becuase they can.

    --
    WTF?
  52. Office 2007 - Excel Server by Anonymous Coward · · Score: 0

    To me, this sounds very much like MS Office 2007's Excel server. The funny thing is that I had been saying that the last thing this world needs is server based spreadsheets.

    I guess I lack "vision".

  53. Bricklin has screenshots on his blog by elwinc · · Score: 4, Informative
    At the risk of injecting facts into an otherwise perfectly pleasant slashdot discussion, I thought I'd provide a link to the wikiCalk post on Bricklin's blog. Oh, and while we're on the subject, how about the "home page for the wikiCalc Alpha Test." You can download Mac, Windows and Perl versions there, assiming Dan's server can handle the load. Uh oh, I better paste in the text of the page; hopefully most of you will read this rather than crash Bricklin's host...

    This is the home page for the wikiCalc Alpha Test

    Introduction

    The wikiCalc program is a web authoring tool for pages that include data that is more than just unformatted prose. It combines some of the ease of authoring and multi-person editing of a wiki with the familiar visual formatting and data organizing metaphor of a spreadsheet. It can be easily set up to publish to basic web server space accessed by FTP and there is no need to set up server-side programs like CGI. It can, though, run on a server and be used with nothing more than a browser on the client.

    wikiCalc is currently released in Alpha test. This means that it is largely untested, has bugs, and is missing features that will hopefully be in the 1.0 release (and Beta versions leading up to that). It does, though, implement a large enough subset of the targeted features to get a good idea of what the product is all about. It is also useful in its own right and seems to be able to create, publish, and maintain a wide variety of web pages already. For example, this page and many of the ones it links to about wikiCalc were created with the wikiCalc Alpha. (The graphical design comes from a CSS file and the side bar is in a simple custom template. Much like a blogging tool, you can automatically wrap the output in static nice-looking stuff if you don't want the default.)

    The Alpha release is available for use on Windows, Mac, Linux/Unix, and other platforms that can run the Perl language. On Windows you need only download a single .exe file that will install wikiCalc, a Perl runtime, and assorted sample files. Other platforms need to have Perl already installed (but they commonly come with it pre-installed).

    The program is written by Dan Bricklin (me) and is available under a GPL 2.0 license. When shipped it will also be available with a dual-license non-GPL proprietary license. You can read my essay explaining a little more about what wikiCalc is and why I created it on the "About wikiCalc 0.1" page on my blog.

    Note that this is the 0.2 alpha version which uses AJAX techniques when editing cells. It includes a "Demonstration Setup" option to get you up to speed quickly if you just want to see what a browser-based spreadsheet feels like.

    wikiCalc is currently aimed at users who are comfortable figuring out how best to use a new tool. It is very flexible and there are many options to meet many different needs. It should be especially of interest to the DIY (Do It Yourself) and VAR (Value Added Reseller) crowd. Such people can set it up for use by others.

    . . . skipping part about downloading and running . . .

    News and Reviews

    Here are links to some of what others have written about wikiCalc:

    David Berlind on ZDNet

    --
    --- Often in error; never in doubt!
  54. Only Three words by chivo243 · · Score: 1

    FileMaker Pro 8.

    --
    Sig Hansen?
  55. This has been out for a while by Jenova_Six · · Score: 1

    The OP says Bricklin's been working on an alpha, that will be out soon.

    Does nobody here realize that version Alpha 0.1 and 0.2 have already been released, and are available for anyone to try? And have been for a while?

  56. It has been done before. by Colin+Smith · · Score: 1

    "I think it's a bloody fantastic idea, and so simple and obvious it seems odd to think such an app doesn't yet exist."

    It *has* been done before and it *does* exist, in fact there are loads of them... All you have to do is look.

    --
    Deleted
  57. Time to start registering domain names! by shmlco · · Score: 2, Funny
    Time to start registering domain names!

    Let's see: WikiWord and WikiPoint and WikiPencil and WikiDraw and WikiPaint and WikiShop and WikiPage and WikiWeaver and.......

    --
    Any sect, cult, or religion will legislate its creed into law if it acquires the political power to do so.
  58. Re:Should have named it by slickwillie · · Score: 1

    WisiCalc.

  59. VisiCalc and copyright by Bacon+Bits · · Score: 1

    Every time I see the program VisiCalc mentioned, it get irked by the fact that the stupid thing will be covered by copyright until like 2050.

    Copyright law is so broken.

    --
    The road to tyranny has always been paved with claims of necessity.
  60. Usability versus good design? by Beryllium+Sphere(tm) · · Score: 2, Interesting

    >Spreadsheets exist to capture the structure of calculations. Data should as far as possible never go in them.

    I see your point -- there are these things called "data"bases for storing data, which have a lot of features for keeping the data safer and more meaningful than it would be in a spreadsheet.

    On the other hand, one of the stories about usability engineering was that Microsoft discovered that customers were using Excel to store lists of things, so they added features to speed up creating and sorting lists of things. Pursuing usability took them further from the path you identified as good design.

    1. Re:Usability versus good design? by mdfst13 · · Score: 1

      "Pursuing usability took them further from the path you identified as good design."

      Only in that they didn't follow through with it. What this really means is that something like Access should be included with Excel by default. Microsoft wants to avoid doing this, as Access is an upgrade product (they sell office both with and without Access). The net result is that people use Excel to store data, since it requires some minimal ability to do that.

      Proper design (rather than the after the fact fix that they actually applied) would have had the data always being stored separate from the calculations. In fact, you can use Excel this way. However, it does very little to push you to use it this way.

      I.e. what they should have done was created a single interface (Excel?) that allows both data entry (stored in data files) and formula entry (stored in calculation files). Of course, the history of spreadsheets makes that counter intuitive for existing users.

      Usability testing is essential to good design, but it does not supply good design automatically. Many of the holes in the Microsoft security model exist for the same reason. Usability says to maximize features. Security restricts them. Sometimes good compromises exist, and a feature can be offered securely.

      Other times no compromise is possible, e.g. allowing only white hats to auto install software without your explicit permission. The Popcap games problem of being listed as a virus by some AV software is a perfect example. For most of the people to whom this happens, this is purely annoying.

      It is the job of designers to sometimes deny usability. However, it can be difficult to argue a theoretic position against the evident desires of customers.

  61. Weird by extrasolar · · Score: 1

    Imagine that, a webpage that uses tables for tabular data.

  62. TrollCalc by Tablizer · · Score: 1

    I am inventing TrollCalc, a spreadsheet that lets trolls flamewar each other's content in a grid-like fashion. After that comes OfftopicCalc and SpamCalc. Never mind the last one, http://milliondollarhomepage.com/ beat me to it.

  63. This has huge potential by theolein · · Score: 1

    I don't really know, of course, and I have yet to try his software out, but the ability to even do simple spreadsheets in a webapplication opens up so many doors that I think this will become as large as wikis itself. The real innovation here is that Briklin is using the flexibility of web apps to have it run locally, on the web, distributed or possibly any mix thereof. It can be huge for all those millions of people who have no need of the advanced features of excel, but need simple functions on data or theability to adjust various parts of a sheet without touching the original data. Can you imagine how much scientists would like something like this as a front end to various data heavy research back end apps, or how finance or sales could use it to colate data?

    What makes me laugh is that all the excel fundis here feel somehow threatend by this or suggest ridiculous alternatives like MS sharepoint server which isn't exactly cheap.

    Mmm, maybe I shouldn't be laughing. Maybe this will eclipse excel over time.

  64. awful by penguin-collective · · Score: 1

    VisiCalc was great at a time when bell bottom pants and leisure suits were still more than a dim memory, but the user interface sucks from a 21st century perpective.

    There have been a number of new takes on the spreadsheet since VisiCalc, permitting manipulation of tabular data but in a more intuitive way than formulas involving row and column references. Unfortunately, Microsoft Excel killed all that with its mediocre imitation of the original VisiCalc.

    I hope that web-based spreadsheets will happen. I also hope that whatever succeeds in that space, it'll finally exorcise the ghost of VisiCalc and Excel.

  65. VisiCalc by jacoplane · · Score: 1

    For those who don't know already, VisiCalc was the first spreadsheet program ever.

  66. What next? WikiTetris by Bing+Tsher+E · · Score: 1

    I would think that there would be 'nobody better in the world to create' WikiTetris than the original Russian dude who created Tetris. (I'm pleased to report his name has slipped my mind)

    WikiTetris: where you enter your information into little Tetris(tm) blocks which slowly fill the screen, then it all disappears when the screen is full.

    From my point of view, this is just as worthy a 'metaphor transfer' as is being discussed here. Bricklin is a fine individual, but having been the first to come up with the Spreadsheet concept doesn't make him anything special enough to warrant this hoopala.

  67. Cluestick... by ediron2 · · Score: 1

    Show me. Post some instructions or a URL. I'd like you to demo *FOR ME* your insanely-easy way for us to shared-edit an excel workbook. For simplicity's sake, your example must do only ONE thing to convince me:

    I change a field and hit excel's save icon, you hit refresh and we're both on the same page again.

    I won't hold my breath. And THAT is the generic case, not some in-LAN trusted share. A wiki does it. Web apps, as I mentioned and you ignored, have the advantage of platform/client being free and anywhere. Second time you've dissed Bricklin without hearing the underlying message. You may not personally in your narrow use-case see this as a need. Also my second and last attempt to explain that you've got tunnel vision. Nobody cares if YOU have a niche use for Excel's sharing that works for you. We're all looking at the same outside world you just mocked Bricklin for ignoring. Then again, you also took a potshot at me for using the word Not. It's a pity your grey matter is limited enough that you have storage quotas-- I heartily recommend you upgrade. Life and language are a lot more colorful if you keep all that slang around. Dip, dope, rube, moron, dolt, dullard, bozo, idiot, plank, toss-pot, wanker, plonker, dipstick, ding-dong, dickhead, dill, fathead, fsckwit, PHB, 1D10T, newbie, clueless... life's grey enough without datestamping cool slang.

  68. Alas, it works just the other way around by dpbsmith · · Score: 1

    Circa 1985 and 1986, I used two lovely applications, Cricket Graph and DeltaGraph to create graphs and charts. Then Microsoft Excel came out. In my next three jobs, whenever I attempted to purchase graphing or charting software, my manager turned me down on the grounds that "Excel can do graphs and charts."