11–20 of 78 posts
"Ok, we're definitively in hell" - C Bel, 2018. This is amazing, computation in Excel is becoming a solid meme. I've got to ask (and I hope this isn't non-PC or some such), but is English the author's first language? Where's he from? I wish that I had Excel so that I could try it out! :) More about the choice of random digits, sin x + cos x, would be nice to read.
Earlier quoted context omitted.
or whatever it is that finance people turn into once they go hackers Payroll analysts
Economists and data scientists. /waves
I'm an absolute nerd for sports stats, and have a friend that moved out of the finance/BI world in the hospitality sector and landed herself an impressive gig at ESPN-of all things, as a stats editor.
It seems a relevant jaunt (because all I know of her profession is that she's an incredible mathematician) but the gap seems wide just from a perspective of domain knowledge; she openly states not caring at all for sports but the new job location puts her close to family.
My question is: is Data Science so applied that one can make that kind of jump domains easily? This gal is one of the smartest people I know but the more I look into what it is you folks do, the more I am simultaneously intimidated yet interested in the field.
Excel w/o vba is the ultimate in functional programming.
And I'm not sure the things that make Excel so crappy could really be fixed without sacrificing the things that make it such a flexible and useful tool. For instance, adding the ability to recurse or iterate sanely would remove the transparency of having every iteration of a computation clearly visualized cell-by-copy-pasted-cell.
Excel w/o vba is the ultimate in functional programming.
=GET(SUM(A3:B97))Excel w/o vba is the ultimate in functional programming.
You jest, but people really do underestimate Excel. Yes, it sucks - but there is a reason that despite all its flaws, people keep trying to use it for things . (And no, that reason is not "they're too stupid to learn how to code") And I'm not sure the things that make Excel so crappy could really be fixed without sacrificing the things that make it such a flexible and useful tool. For instance, adding the ability to…
ps. Excel does some things OK, like drawing pretty graphs on smallish datasets and visualize quick analysis with pivot tables. It just lacks a sensible scripting language and is generally very brittle once the data is getting nontrivial and more than one person is involved.
Earlier quoted context omitted.
You jest, but people really do underestimate Excel. Yes, it sucks - but there is a reason that despite all its flaws, people keep trying to use it for things . (And no, that reason is not "they're too stupid to learn how to code") And I'm not sure the things that make Excel so crappy could really be fixed without sacrificing the things that make it such a flexible and useful tool. For instance, adding the ability to…
For me it usually is "I would like to use some sensible tools, but corporate policy requires me to not do that (because they are not available) - so I have to (ab)use Excel/Office/VBA to get things done." It's not pretty, stable, efficient or really maintainable, but if you are forced to use a hammer.. ps. Excel does some things OK, like drawing pretty graphs on smallish datasets and visualize quick analysis with piv…
"Ok, we're definitively in hell" - C Bel, 2018. This is amazing, computation in Excel is becoming a solid meme. I've got to ask (and I hope this isn't non-PC or some such), but is English the author's first language? Where's he from? I wish that I had Excel so that I could try it out! :) More about the choice of random digits, sin x + cos x, would be nice to read.