171–180 of 377 posts
Yes, some things could be done better with a separate application or custom software, but that requires approval and contracts etc.
With Excel you can just build that crap yourself and share it or not.
I like the programmers on here telling the professional users that Excel is overblown and they could just use Numbers, OpenOffice or Google sheets. Imagine an accountant coming on here and telling you that you don't need vi, emacs, sublime text or VSCode. You certainly don't need your IDEs. After all it's perfectly possible to code in Notepad. You also don't need your languages. BASIC was perfectly good. The killer f…
Excel spreadsheets are auditable? If that's the case, why do studies show that so many Excel spreadsheets have major errors in them? https://theconversation.com/spreadsheet-errors-can-have-disa... https://phys.org/news/2024-08-business-spreadsheets-critical... https://duckduckgo.com/?q=study+excel+spreadsheets+contain+e...
In my old job, we had to switch away from our working but ancient Information System to SAP for similar reasons.
I like the programmers on here telling the professional users that Excel is overblown and they could just use Numbers, OpenOffice or Google sheets. Imagine an accountant coming on here and telling you that you don't need vi, emacs, sublime text or VSCode. You certainly don't need your IDEs. After all it's perfectly possible to code in Notepad. You also don't need your languages. BASIC was perfectly good. The killer f…
Excel spreadsheets are auditable? If that's the case, why do studies show that so many Excel spreadsheets have major errors in them? https://theconversation.com/spreadsheet-errors-can-have-disa... https://phys.org/news/2024-08-business-spreadsheets-critical... https://duckduckgo.com/?q=study+excel+spreadsheets+contain+e...
The year was 1986, pre-spreadsheets. Writing up an undergrad physics experiment in 1986, I needed to do a hundred or so similar calculations and present the results in a table. Luckily, a computer science acquaintance wrote a small program to do this task for me. Thanks, Dan.
In 1989, before Excel, there was Lotus 1-2-3. Loved that spreadsheet software. My PhD task involved plotting lots of data points, including smoothing some of them. Doable with Lotus 1-2-3, probably not doable otherwise.
More recent times.
Spaghetti Excel. An engineering acquaintance told me his student summer job, at an aluminum refinery, was to check and simplify their Excel spreadsheets. Apparently they had numerous spreadsheets linked to each other. I assume the main purpose was inventory control. I know I didn't envy him his task.
"Please, not just Excel." I took a class of high school students to a uni chem lab and had a small argument with a chemistry tutor who insisted the students use Excel to plot their data. I wanted them to first do it by hand with graph paper. This would have given them a much better feel for their data.
"Rinse-and-repeat Excel". I was tutoring a construction guy trying to learn maths. His job as an assistant on a high-rise construction job involved putting lots of numbers into an Excel spreadsheet. The check for this was to repeat the process and see if he got an identical result. I thank G*d his boss made him do this.
And that's it. Helped other people to use Excel, but I'm thankful that I haven't had to spend my life inputting data into spreadsheets.
I like the programmers on here telling the professional users that Excel is overblown and they could just use Numbers, OpenOffice or Google sheets. Imagine an accountant coming on here and telling you that you don't need vi, emacs, sublime text or VSCode. You certainly don't need your IDEs. After all it's perfectly possible to code in Notepad. You also don't need your languages. BASIC was perfectly good. The killer f…
And it's not just a matter of functionality: there's an enormous difference in performance. I've had to push the limits of Excel to do data analysis and visualization on huge spreadsheets with complex lookup formulas. It worked great. Then I tried to import into Google Sheets to share with colleagues and it completely choked. Like I let it churn for hours and it never finished recalculating. Google Sheets is "good en…
Earlier quoted context omitted.
Excel spreadsheets are auditable? If that's the case, why do studies show that so many Excel spreadsheets have major errors in them? https://theconversation.com/spreadsheet-errors-can-have-disa... https://phys.org/news/2024-08-business-spreadsheets-critical... https://duckduckgo.com/?q=study+excel+spreadsheets+contain+e...
Excel users can make mistakes, therefore Excel spreadsheets can't be audited? Is that your point?
Edit: My contention is that spreadsheets are in fact, very opaque, and it is incredibly difficult to check that every part of a spreadsheet is actually doing what its users think it is supposed to be doing. Specifically, I posit that it is harder to check a spreadsheet, than it is to check a "traditional" program in a normal programming language, which works on pure data.
Earlier quoted context omitted.
This is exactly right. I work in investment banking and the reason I believe Excel will never go away is because of how easy it is to follow extremely complex financing structures. If I build a financial model, the 60 year old CFO needs to be able to understand it and agree with it. One other aspect is all of the shortcuts and hot keys. If you switched to a different software you’d have to relearn shortcuts that you…
Worked for a company whose automated options trading system was an.... excel spreadsheet. Every now and then I would need to RDP to a machine to RDP into another machine to restart it. Pain. So much pain.
I like the programmers on here telling the professional users that Excel is overblown and they could just use Numbers, OpenOffice or Google sheets. Imagine an accountant coming on here and telling you that you don't need vi, emacs, sublime text or VSCode. You certainly don't need your IDEs. After all it's perfectly possible to code in Notepad. You also don't need your languages. BASIC was perfectly good. The killer f…
Excel spreadsheets are auditable? If that's the case, why do studies show that so many Excel spreadsheets have major errors in them? https://theconversation.com/spreadsheet-errors-can-have-disa... https://phys.org/news/2024-08-business-spreadsheets-critical... https://duckduckgo.com/?q=study+excel+spreadsheets+contain+e...
I started to really loath the spreadsheet data model. "it's a big bag of cells" was not really doing anything for me. I started wanting better data structures and programing environments to work on that data.
For the data storage and basic calculations on that stored data role, I mainly use a relational database, most of what I wanted in a spreadsheet was row level security, that is, for my rows to stick together(one to many bad sorts I guess), and relational databases provided this in spades.
I like the programmers on here telling the professional users that Excel is overblown and they could just use Numbers, OpenOffice or Google sheets. Imagine an accountant coming on here and telling you that you don't need vi, emacs, sublime text or VSCode. You certainly don't need your IDEs. After all it's perfectly possible to code in Notepad. You also don't need your languages. BASIC was perfectly good. The killer f…
It was SO. IMPOSSIBLY. SLOW.
Maybe it's different now with M4 macs, but I still remember a friend telling me that response times above 1/10th of a second were not interactive anymore. Made total sense after that.