5 ms·
It amazes me to see companies big and small that basically run on Excel. Why do you think Excel is so ingrained into all kinds of companies and processes?
by pier25 7y ago
It amazes me to see companies big and small that basically run on Excel.
Why do you think Excel is so ingrained into all kinds of companies and processes?
- SonOfLilit 7y agoBecause spreadsheets are at the sweet spot of most complicated programming language that non-technologists can reasonably be expected to learn on their own. Because you should have a reeeealy good justification to write a single line of code for something that can be done in Excel much cheaper, and mostly you don't.
- SonOfLilit 7y agoI guess what I'm trying to say is: it's a feature, not a bug, and it's really important for entrepreneurs to understand this because otherwise they might think they have no competition where their competition is with the most useful piece of software humanity ever produced.
- discordance 7y agoIt's accessible and empowers the individual. Not everyone can code, but everyone can transform data in a spreadsheet and email it off to the next person.
- pier25 7y agoI guess everyone accessing the same data at all times is not so valuable after all. I've seen people having multiple versions of the same excel file and not remembering which was the last one...
- Flyer1 7y agoI agree with most of the answers already posted about why Excel is so ubiquitous. To respond to this comment specifically, though, I'll just mention that we use a product called EASA to enable us put a web app on top of critical spreadsheets while also connecting to a database i.e. you can "de-couple" the data from the logic. There are some use-cases that describes this here: https://easasoftware.com/case-studies/amlin-reducing-risks-errors-excel-data-input-aggregation/ https://easasoftware.com/case-studies/amlin-reducing-risks-e... ...and here: https://easasoftware.com/case-studies/leaseplan-transforming-scenario-pricing-models-spreadsheet-tools-into-enterprise-web-applications/ https://easasoftware.com/case-studies/leaseplan-transforming...
- wvenable 7y agoMost programmers mistake the majority of the use of Excel as the creation of software. It isn't. It's mostly just construction of reports; sometimes just for one-off purposes. I would theoretically be possible to write some software/reporting solution for every use of Excel but it wouldn't be an efficient use of resources.
- ben509 7y agoAnd even the one-off reports represent the ability to do coding in tiny increments, precisely tuned to the demand. You can find some report from months ago and just open it up and add to it. And as you're adding features, you instantly see the results; even as you type if you use the formula builder. If you're working on any kind of software tooling, watching how people work with Excel is incredibly insightful.
- sethhochberg 7y agoAnybody being able to quickly make a significant change has its ups and downs, though... On more than one occasion I've caught word of some fancy spreadsheet a different team in a company has been using to draw insights for months, only to have nontrivial critiques of the source data or interpretation of the data that caused big changes in the results - stuff we would have ideally caught in a dev team's code review or QA workflow, but those processes are entirely bypassed when someone on the marketing team makes a spreadhsheet on their computer and dumps audience data from an advertising platform to seed it. Spreadsheets are nontechnical users' version of "move fast and break things". Often times that can be useful, even essential, but there are many more cases where the primary utility of working that way is also the major flaw. Its faster than traditional report development because it skips any kind of review or QA.
- cr0sh 7y ago> I would theoretically be possible to write some software/reporting solution for every use of Excel but it wouldn't be an efficient use of resources. One company I know which did this was called "Actuate"; that was years ago, a quick googling shows they were bought, now called "OpenText" (?) - also had something to do with MongoDB and something called BIRT (Business Intelligence and Reporting Tools)... Last I had any involvement with them for a company I worked for, it was with their reporting suite of tools; the company I worked for became a VAR for them, so anytime the tool had a bug, we could quickly get them in an IRC chat (told you it was a while back) and get a patch within a few hours to a day or so, depending on the issue. The reporting system was fairly unique for the time; a basic WYSIWYG drag and drop editor, ala VB - and for more complex designs, a VB-like object-oriented "reporting design" language. It was essentially what VB6 should have been on the OOP side of things, but geared entirely toward reporting. Reports could pull data from any number of different sources, from flat ascii files, to excel documents, to database engines, ODBC, etc. One of the last things I heard from them, at a seminar they put on that my company sent me to in Santa Monica, was this idea of reforming people using Excel spreadsheets. They called the whole sharing and copying of such spreadsheets, such that there was no one single authoritative source - a "spreadmart". So they wanted to do something about it. They came up with some kind of Java-based solution with a custom front-end that looked exactly like Excel of the time, worked just like it - pivot tables, whole nine yards. But it interfaced to a backend using these "business logic" modules. The idea was all instances of the "spreadsheet" could see the same data via those modules, and those modules would be created by an IT staff (or DBA or something), and anything interacting with them in a company would have to go thru them - reports, gui, excel spreadsheets, etc. The idea was to present one cohesive view of the data for all users. I don't know where it ended up - if they launched the product or not (we were being given a sneak peek at it at the seminar - it was a pretty nice demo, overall for the time). A couple of weeks after coming back from the seminar, the company let me go (I'd worked for them for about 8 years - missed the whole "dot-com" thing because I believed in this company so much - lived and learned).
- Gpetrium 7y agoExcel allows for the democratization of technology, decreasing the barriers to entry and allowing for easier user experience. People/teams/companies need different degrees of security, complexity, data, etc to their day-to-day operations. Someone may be interested in fiddling with data without others seeing, others may not want to share certain data broadly (answering your point below). Excel has served as a way to unify these needs for the most part. Some other options available tends to fall on the outer-layers, where excel may not be optimal and someone felt a specialized tool could improve speed/quality/cost.
- crispyambulance 7y ago> Why do you think Excel is so ingrained into all kinds of ... Because it works. Programmers underestimate and put down excel all the time, but I think it's actually how many projects they end up with get started. Someone had a problem, solved it for themselves using excel, got noticed, expanded the solution to other problems until the excel solution itself became the problem and then... it ends up as a project for you. There's nothing wrong with that. It does the job, and it's not like the first course of action when there's a problem should be to assemble a scrum team with a cast of characters like a sitcom, and blow a million dollars to implement a bespoke software solution. Sometimes excel is just enough (and then some).
- plafl 7y agoMy first job consisted in updating Visual Basic code behind an Excel file that specified the hydraulic circuit for an aircraft. It was a simplified version of the circuit for use in a simulation that was used to calculate pressure loss based on several valve and pipes parameters. The results were exported to a txt file to be loaded by the simulator. Also in the same project I remember another Excel file with mechanical calculations that actually updated a nice graphic that simulated all the linkages and different extensions of the actuators and computed forces at different points. The unholy alliance of elegant Lagrangian mechanics with Visual Basic. I hope to never touch Basic again but it was a valuable lesson about getting things done and I'm glad I took it so early in my career.
- dustingetz 7y agoit grew that way from inception. no inception -> no growth
- ww520 7y agoExcel is declarative programming at its finest in practice.
- mmckelvy 7y ago- Because a spreadsheet is the best UI for many business applications (far better than an HTML table on a webpage). - Because Excel allows the user to (i) perform ad-hoc calculations, (ii) audit the input and outputs, and (iii) easily modify the functionality in real time. - People don't like filling out forms and most web apps are basically filling out forms.
- all2 7y agoPoints 1 and 2 sound like a REPL. Say we had a REPL that also had a table (like excel, each cell has an address... a 2D stack if you will). Say we interact using a mouse to select a cell or in the REPL to specify what cell we want to write to. Then, if we use a Lisp, we have tabular code and tabular data... I might code this up for fun.
- opportune 7y agoThis exists already - Jupyter + Python + Pandas. Or a spark interactive cluster with a notebook interface if you have more data than can fit on a single machine
- airstrike 7y agoThis is fine and dandy for small sheets, but if you're trying to build a sheet with multiple tabs, circularity, self-referencing IF statements, or lots of data, it will get really hard Also, the #1 Excel rule in Wall Street is "never use your mouse" IMHO, I think the better project is an equivalent of an RMarkdown / RStudio tool that generates a final report from a declarative set of instructions.
- jimbosis 7y agoI don't know if it is what you are envisioning, but there is a spreadsheet program called Scheme In A Grid (Siag) [1] (part of Siag Office [2]). From the "Introduction" [3] of its Online Documentation: "Siag is an X-based spreadsheet for Unix. It uses Scheme (a Lisp dialect) both for expressions and as an extension language, which makes it easy to create new functions (for native Lispers, that is). There is no requirement to know Scheme to use Siag, expressions can be entered in traditional spreadsheet syntax as well." [1] http://siag.nu/siag/ http://siag.nu/siag/ [2] http://siag.nu/index.shtml http://siag.nu/index.shtml [3] http://siag.nu/online-docs/siag/intro.html http://siag.nu/online-docs/siag/intro.html
- jpindar 7y agoPeople use Excel because their manager wants them to use Excel. Their manager wants them to use Excel because all their past managers have wanted them to use Excel. And so on. Also, it's already there on all the computers.
- jyriand 7y agoYou only need one tool to run your business. You can use Excel for bookkeeping, inventory, salaries, invoices, project management, budgeting, presentations, planning, forecast, brainstorming, timetable, to-do list and so on. If you would use a separate app for each of these you would go insane. Easier to learn one powerful tool than hundred small ones. Take a look a talk by Joel Spolsky called You Suck at Excel. It's on YouTube. It will give you a quick glimpse into how Excel powerusers are using it and how fast you can create something useful.
- ako 7y agoBecause it allows business to get shit done: * No need to depend on an IT department which is already overbooked * No need to find budget to fund a project * No need to wait forever for the IT project to finish. It gives an business person control, as they can do it themselves.