Excel formula only 3d engine
-
Spreadsheet are a powerful tool that everyone has to learn to use for almost every business jobs. Yet, when most people come to solve most complexes problems, they want to use VBA language, without even knowing why. And once they started learning it, they try to use it for any kind of problem, even simple search or rendering. Today, as an excel teacher, I'm trying to explain to these people why writing VBA macro for any problem while not being educated on computer programming is not only a real waste of time, but also a serious risk for their spreadsheet quality.
For those of you who thought writing a turing machine using Power Point was insufficiently insane.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies. -- Sarah Hoyt
-
Spreadsheet are a powerful tool that everyone has to learn to use for almost every business jobs. Yet, when most people come to solve most complexes problems, they want to use VBA language, without even knowing why. And once they started learning it, they try to use it for any kind of problem, even simple search or rendering. Today, as an excel teacher, I'm trying to explain to these people why writing VBA macro for any problem while not being educated on computer programming is not only a real waste of time, but also a serious risk for their spreadsheet quality.
For those of you who thought writing a turing machine using Power Point was insufficiently insane.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies. -- Sarah Hoyt
I do feel like quibbling with one of his points on why formulas should be preferred to macros:
Quote:
Easier to maintain for anyone but professional analyst programmer. (while macro are mostly unusable once the initial developer is gone)
While this is true for basic operations once you start doing crazy stuff in formulas it becomes more self obfuscating than perl. For my sins in a previous job I wrote a set of formulas to do run length encoding in a spreadsheet. I'm 99% sure that even I couldn't tweak them now if it was needed to make any changes to the encoding step, and would probably struggle to even use the thing again if I needed to. Whereas the intended audience of any reuse of the spreadsheet - EE's - could apply the programming 101 in C they got as part of an embedded hardware class to figure out what the VBA did almost as easily as any conventional programmer who'd successfully avoided VBA his/her entire career could have. And that's before taking into consideration that the macro editor would have allowed me to leave copious comments explaining how it worked.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies. -- Sarah Hoyt
-
Spreadsheet are a powerful tool that everyone has to learn to use for almost every business jobs. Yet, when most people come to solve most complexes problems, they want to use VBA language, without even knowing why. And once they started learning it, they try to use it for any kind of problem, even simple search or rendering. Today, as an excel teacher, I'm trying to explain to these people why writing VBA macro for any problem while not being educated on computer programming is not only a real waste of time, but also a serious risk for their spreadsheet quality.
For those of you who thought writing a turing machine using Power Point was insufficiently insane.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies. -- Sarah Hoyt
Dan Neely wrote:
For those of you who thought writing a turing machine using Power Point was insufficiently insane.
And for those who have no idea what that reference is to, [here you go](https://www.youtube.com/watch?v=uNjxe8ShM-8).
Latest Article - Code Review - What You Can Learn From a Single Line of Code Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny Artificial intelligence is the only remedy for natural stupidity. - CDP1802
-
Spreadsheet are a powerful tool that everyone has to learn to use for almost every business jobs. Yet, when most people come to solve most complexes problems, they want to use VBA language, without even knowing why. And once they started learning it, they try to use it for any kind of problem, even simple search or rendering. Today, as an excel teacher, I'm trying to explain to these people why writing VBA macro for any problem while not being educated on computer programming is not only a real waste of time, but also a serious risk for their spreadsheet quality.
For those of you who thought writing a turing machine using Power Point was insufficiently insane.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies. -- Sarah Hoyt
This is so awesome :cool:
Up, Up, Down, Down, Left, Right, Left, Right, B, A.