Slashdot Mirror
Stop Using Excel, Finance Chiefs Tell Staffs (wsj.com)
Tatyana Shumsky, reporting for WSJ: Adobe's finance chief Mark Garrett says his team struggles keeping track of which jobs have been filled at the software company. The process can take days and requires finance staff to pull data from disparate systems that house financial and human-resources information into Microsoft's Excel spreadsheets. From there they can see which groups are hiring and how salary spending affects the budget. "I don't want financial planning people spending their time importing and exporting and manipulating data, I want them to focus on what is the data telling us," Mr. Garrett said. He is working on cutting Excel out of this process, he said. CFOs at companies including P.F. Chang's China Bistro, ABM Industries and Wintrust Financial are on a similar drive to reduce how much their finance teams use Excel for financial planning, analysis and reporting (Editor's note: the link could be paywalled; an alternative source wasn't immediately available). Finance chiefs say the ubiquitous spreadsheet software that revolutionized accounting in the 1980s hasn't kept up with the demands of contemporary corporate finance units. Errors can bloom because data in Excel is separated from other systems and isn't automatically updated.
well, it doesnt have to be, sounds like you have an IT problem, not a spreadsheet problem
nor is it an invoicing system. If you're a small company you can get away with using it as such. In the 70s they were probably still better than paper. But it always amazing and mildly frightens me how many folks in big companies still use it for major parts of their business because, hey, it's already there and I know how to use it.
Hi! I make Firefox Plug-ins. Check 'em out @ https://addons.mozilla.org/en-US/firefox/addon/youtube-mp3-podcaster/
Excel is the case in point use of Law of the instrument.
In engineering I've seen Excel used to share images, a database, run a production line with some VBA/oracle black magic integration.
"I don't want financial planning people spending their time importing and exporting and manipulating data, I want them to focus on what is the data telling us," .......If this is the case they need to have that data in some sort of format that is useful. It sounds to me like he is simply looking to replace Excel rather than get rid of it. If he's replacing it with something the company will most likely need to train employees on it. This process will in turn create more time wasted.
Sent from my TARDIS
Yes, Excel is a staple in work environments... but what software out there can replace it that is just effective? I know some consulting groups would love to replace it with their own, expensive solution. However, for 99.99% of what is out there, LibreOffice Calc, Numbers, or Excel can do the job well.
After all these years, are there any programs at all that work like Javelin? Where you create a worksheet (not a spreadsheet) that brings together all the underlying "variables" (simple values or time series data which are automatically converted between days, months, seconds, years, quarters, or whatever)...? Javelin was popular before databases and networks were widespread, but extending its concepts to modern systems could be as simple as defining a "variable" as the result of a SQL query.
It's laughable to read any commentary from anonymous finance chiefs decrying Excel's inability to keep up with "x". These folks truly do not use Excel in any meaningful way. Truly.
Every business person in every industry I've ever worked in (telecom, pharma, housing, transportation, manufacturing) rely on Excel as the glue application for everything. I have to persuade people to use Word instead of Excel for actual documentation requirements, that's how reliant everyone is on this magical tool.
Actuaries use Excel almost exclusively to perform calcs for clients. I don't care who you work for, you're using Excel and not ProVal for the majority of your work.
Engineers use Excel for *everything*. What other application imports and exports to so many different formats, and allows any calculation you can dream up?
You write reports? You write complex reports? Try connecting your queries to Excel and let your end users twist the results on their own. You're not writing layouts any longer, and THAT'S FUCKING AWESOME.
Face it, orgs should roll it out and become Excel experts in house, and use it for as much as they can. For the value it delivers, it's dead-cheap and nobody has an app to match it.
--#
The problem is that it isn't just (or primarily) with ad hoc and custom analyses.
It is that regular business functions are run with these sheets all the time. Business types do this because the are familiar with the tool, and they can implement the process themselves without calling in a dev team.
And all of this is perfectly understandable. Would you call in an outside dev team, explain requirements, and then have to wait for an acceptable product to be produced, when you could do it yourself quickly?
This is inevitable unless considerable effort is expended by the organization to identify and pull these business functions into formal, administered, monitored systems.
A decree not to use Excel at all (if this is what it is) is stupid.
The emphasis should be on educating the business on treating these "normal function" spreadsheets as prototypes of the function that must be implemented formally going forward, and the necessary resources must be provided to make this happen, and suitable reward structures must exist to encourage businessmen to identify and bring forward these functions for proper automation. Without all of this this decree will be useless.
Second class citizen of the New Gilded Age
Back in 2005, it was not about being on different systems, but there was an article entitled The subtle tyranny of spreadsheets and link https://tech.slashdot.org/stor....
WARNING: Smartphones have side effects--most of them undocumented.
And all of this is perfectly understandable. Would you call in an outside dev team, explain requirements, and then have to wait for an acceptable product to be produced, when you could do it yourself quickly? This is inevitable unless considerable effort is expended by the organization to identify and pull these business functions into formal, administered, monitored systems.
Also important is that once it's moved outside Excel they often lose transparancy and flexiblity. They can't step-by-step it through the cells, they can't easily simulate it on a set of test data, they can't try tweaking a formula and see how it turns out unless somebody did a lot of work to enable that. Getting the initial version out of Excel is only half the fun, it's making the result maintainable that's the challenge. We experienced somewhat the same here migrating from SPSS syntax to SQL, people that used to be very hands-on suddenly felt it was a black box they didn't really understand and couldn't trace through the process.
Live today, because you never know what tomorrow brings
My (IT) staff and I always joke about how Excel is the #1 reporting tool. Unfortunately, with decades of COTS and other vendor systems in play, the only good way to get any decent real-time reporting with sorting and filtering is in Excel. I just exported my 2016/2017 fiscal year purchases out of our $150M AMS Advantage ERP system into Excel so I can analyse the data correctly. The ERP system simply cannot handle the flexibility i need.
The Kai's Semi-Updated Website Thingy
Excel use by information workers doesn't follow the typical patterns of other application software.
Spreadsheets belong to the family of End-User Development software, a research tradition which has more in common with IDEs than with office suites. EUD focus on allowing end users to create automations without the need to understand the logic of classic programming languages, i.e. without learning a formal grammar nor having to follow the execution path of a program runtime in your head.
In spreadsheets, in addition to a simplified domain-specific programming language, you get a dead-simple modeling tool for your data schemas (with simple visual queries), and mixing the data and code in-place, which helps as much as your preferred debugger. End users usually don't get as powerful debugging tools as developers, and spreadsheets are typically the only environment where a clever power user has access to similarly powerful tools.
Singularity: a belief in the "God" idea with the "demiurge" relation inverted.
Their multi billion dollar asset tracking system and SEC reporting system involves exchanging excel files. They made a great leap forward by using a common shared drive instead of emailing each other excel files.
They don't even have a version control system, to create an audit trail of changes. The process always starts with "Copy last month spreadsheet into a new name for this month". It is insane. But, on the other hand, had she been sane she might not have married me.
sed -e 's/Chuck Norris/Rajnikant/g' joke > fact
Did he tell them to stop using pdf files first, before stopping the use of Excel?
sed -e 's/Chuck Norris/Rajnikant/g' joke > fact
If Adobe can't find COTS software that meets their needs, it blows my mind why they wouldn't develop it and sell it. They are a software company.
The people at Adobe doing the financial analysis work are decidedly NOT software developers. That has a lot to do with it.
As it turns out, programming a functional and useful general purpose accounting and finance system is the very definition of a non-trivial endeavor. I say this as a a certified accountant and have done this sort of work professionally. Seriously, it's a lot harder than you think. People get very upset if you mess up the software that tracks the money. Replacing spreadsheets is going to be near impossible for a lot of tasks. Plus you need a tool that is flexible enough to roll with all sorts of unexpected business processes and analysis.
Despite it's many flaws, nobody has come up with a better general purpose tool for ad-hoc analysis and reporting than a spreadsheet and most finance geeks use Excel. There also is a strong whiff of "if the only tool you have is a hammer every problem becomes a nail". Finance people go to spreadsheets because it's the tool they already know how to use and have available. Yes sometimes there are better ways to do things but when you are asked to get the job done in some absurdly short time frame (which happens ALL the time in finance/accounting) you're going to go with what you know even if it isn't ideal. That said, Excel and other spreadsheets could do a LOT better job integrating with data sources and adapting to the real world needs of financial professionals. Frankly Microsoft (and Libreoffice) have been quite lazy in this regard. It remains an unnecessarily huge pain in the ass to pull data from outside sources into spreadsheets. And even when you can do it it is quite fragile and easy to break.
Actually if you really want to be depressed, you would be amazed at how many accountants still use paper tape calculators even when they have a spreadsheet available to them. Good luck getting those people to move to a custom designed piece of software.