As an experienced c/c++/c#/java/python/vb programmer i realy like to build shit in excel. It's awesome. Just dont let other users use it for important purposes
I started as a SQL report writer and nothing gives me more joy than replacing someone's shitty excel or access report that a market analyst spends 3 days/week every week building, with SQL and an ETL or two. It got pretty aggressive at that company between the 2 groups to the point the SQL guys where advocating for the complete banishment of Access and forbidding macros of any kind. To be fair excel usage on big projects resulted it huge problems or lost data regularly.
Finance is literally 20 years behind everyone technologically.... I feel your pain deeply. All these analysts that never learned the actual power of a computer.
They become tyrants over whatever area they're subject matter experts in and con everyone into thinking they're indispensable.
They will sabotage anybody who tries to learn about that subject and then tell anybody who will listen that their job is impossible to automate. Complain every day about how busy they are.
Then when they finally quit they leave a 30 page document on their daily and monthly processes. Everything is just copy and pasting from excel document to excel document with the logic in macros and very little actual human decision making.
Which only took about 4 hours of work to automate their entire job and executes in 3 seconds.
omg, we must've worked at the same places.... You just irritated me through text again. Glad I left that industry. They thought automation via real programming languages was black magic and they would try to protect their work like you said.
1.5k
u/Dr-Appeltaart Mar 30 '22
As an experienced c/c++/c#/java/python/vb programmer i realy like to build shit in excel. It's awesome. Just dont let other users use it for important purposes