3 ms·

See. You've got answers to something that you haven't asked a single question about. But in your judgement the company should have had the right developer on st

See. You've got answers to something that you haven't asked a single question about. But in your judgement the company should have had the right developer on staff. That's what's frustrating about these anti-Excel discussions. Ok. What happens when I say that the company bought another company and it had a product line that the new company wanted to pay sales people commissions on? And the compensation plan around it was complex. For whatever reasons, that's not a report the DBA was up for developing from scratch (or, someone decided his time wasn't to be used that way). That's just the reality. We can talk about what should have been or what ought to have been, but that doesn't change the reality. The reality is that I ended up doing most of it ACCURATELY in Excel.

deknos 6y ago
> But in your judgement the company should have had the right developer on staff. Yes, like a janitor for example. > The reality is that I ended up doing most of it ACCURATELY in Excel. Yes it's the hammer for all your nails. You could also use Python+Jupyter. There are selfhosted and managed versions. Because of guys like you, municipial installations run their sewage system with an excel sheet because some guy implemented a vba macro to talk to the sewage api endpoint. let it go.
Aeolun 6y ago
I think the company would quickly realize that they need a different solution if they have no Excel wizard on staff, and the team spends weeks just calculating sales commissions. Or maybe not, and they’d just hire more people solely to calculate commission :/
heavenlyblue 6y ago
I would say that you probably do not know what you did wrong having done it in Excel. Stuff gets complicated really fast in Excel thus it’s much easier to do something that you can’t possibly debug and thus live in blissful ignorance.
- OzCrimson 6y ago
  It's just unbelievable ... how people KNOW about situations that they weren't in and don't ask any questions. But since you brought it up I can tell you about my accuracy in Excel: - The process involved 2 people checking my work before it was sent to payroll. And we did catch and correct mistakes. We were able to trace back where and how the mistakes were make, and build in ways to prevent or flag future mistakes. - The job was necessary because of all the garbage in the database. Excel's data-checking and data-cleansing and flexibility was superior to the database. - After 1 year all of my work was audited. For several dozen sales people, there was ONE person I wasn't 100% accurate with. And that one was off by 0.5%. SUCCESS! - If we'd gone with the report coming out of the database, things would have been such a confused mess.
  - heavenlyblue 6y ago
    It has nothing to do with your particular situation. This is a reasonable assumption to make if somebody comes and wants a solution in Excel. But ok. So what you are saying your Excel was reviewed by somebody else. How is this any different from reviewing somebody else’s code? I work in a company where even the least technical analysts are capable of using numpy. We have libraries to use Google Sheets as input-output data. So you get the best of the two worlds. What does Excel resolve here?
  - heavenlyblue 6y ago
    Also I don’t believe that you could not use Excel to cleanse the data and then put it back in the database. And I also do not believe that a python script would not do the same cleansing of the data in a much more maintainable way.
    - OzCrimson 6y ago
      You've got all the answers about a company in Chicago in 2005-2008 and how it should have been run. Why didn't you jump in and help us?
      - 6y ago

deknos 6y ago

> But in your judgement the company should have had the right developer on staff. Yes, like a janitor for example. > The reality is that I ended up doing most of it ACCURATELY in Excel. Yes it's the hammer for all your nails. You could also use Python+Jupyter. There are selfhosted and managed versions. Because of guys like you, municipial installations run their sewage system with an excel sheet because some guy implemented a vba macro to talk to the sewage api endpoint. let it go.

Aeolun 6y ago

I think the company would quickly realize that they need a different solution if they have no Excel wizard on staff, and the team spends weeks just calculating sales commissions. Or maybe not, and they’d just hire more people solely to calculate commission :/

heavenlyblue 6y ago

I would say that you probably do not know what you did wrong having done it in Excel. Stuff gets complicated really fast in Excel thus it’s much easier to do something that you can’t possibly debug and thus live in blissful ignorance.

OzCrimson 6y ago
It's just unbelievable ... how people KNOW about situations that they weren't in and don't ask any questions. But since you brought it up I can tell you about my accuracy in Excel: - The process involved 2 people checking my work before it was sent to payroll. And we did catch and correct mistakes. We were able to trace back where and how the mistakes were make, and build in ways to prevent or flag future mistakes. - The job was necessary because of all the garbage in the database. Excel's data-checking and data-cleansing and flexibility was superior to the database. - After 1 year all of my work was audited. For several dozen sales people, there was ONE person I wasn't 100% accurate with. And that one was off by 0.5%. SUCCESS! - If we'd gone with the report coming out of the database, things would have been such a confused mess.
- heavenlyblue 6y ago
  It has nothing to do with your particular situation. This is a reasonable assumption to make if somebody comes and wants a solution in Excel. But ok. So what you are saying your Excel was reviewed by somebody else. How is this any different from reviewing somebody else’s code? I work in a company where even the least technical analysts are capable of using numpy. We have libraries to use Google Sheets as input-output data. So you get the best of the two worlds. What does Excel resolve here?
- heavenlyblue 6y ago
  Also I don’t believe that you could not use Excel to cleanse the data and then put it back in the database. And I also do not believe that a python script would not do the same cleansing of the data in a much more maintainable way.
  - OzCrimson 6y ago
    You've got all the answers about a company in Chicago in 2005-2008 and how it should have been run. Why didn't you jump in and help us?
    - 6y ago