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. "
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?
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,
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.
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.
Developers: We can use your help.
WikiCalc - the site where you get to decide what 2 + 2 equals...
This guy's the limit!
"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.
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.
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!"
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.
This sounds pretty similar to JotSpot Tracker.
Calcopedia?
Calco Anarchy?
Developers: We can use your help.
...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.
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.
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.
:-), 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)
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
Animoog.org
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
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.
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.
This is all well and good, until every cell reads "Penis".
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.
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.
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.
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:
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!.
Unstable Apps: Our Android Apps Don't Suck
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.
It's been done...
Num Sum
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
Dabble DB
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:
What I really want to know is, can multiple people play Sudoku using it?!
Can I invest... pleaze!!!! I only want 60% of the returns when Google buys you out!
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.
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 ----
Microsoft announces WikiPoint as an robust alternative to the venerable PowerPoint.
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.
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...
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
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.
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.
Ever heard of ODBC?
Yes, but...
In Soviet Russia, the expression evaluates you.
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.
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.
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.
Uh oh... Is "wiki" becoming the new "i" which was the new "e" a few years ago?
Hexy - a strategy game for iPhone/iPod Touch
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.
Not just that - but Office SharePoint 2007 includes Excel Services so that you can work with spreadsheet from your browser0 502.aspx
see http://blogs.msdn.com/excel/archive/2005/11/08/49
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!)
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.
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.
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!
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?
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".
--- Often in error; never in doubt!
FileMaker Pro 8.
Sig Hansen?
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?
"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
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.
WisiCalc.
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.
>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.
Imagine that, a webpage that uses tables for tabular data.
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.
Table-ized A.I.
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.
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.
For those who don't know already, VisiCalc was the first spreadsheet program ever.
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.
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.
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."
"How to Do Nothing," kids activities, back in print!