r/programming • • May 08 '18

Excel adds JavaScript support

https://dev.office.com/blogs/azure-machine-learning-javascript-custom-functions-and-power-bi-custom-visuals-further-expand-developers-capabilities-with-excel
2.4k Upvotes

585 comments sorted by

View all comments

Show parent comments

1

u/yopla May 08 '18

You've just repeated the same thing so just assume my answer is still about your limited understanding how how companies need to prioritize their capex spending and how small, intermediate, zero added cost, DIY solutions can provide a lot of benefit to a company.

1

u/therealcreamCHEESUS May 08 '18

As I said, I work in the industry and have worked with clients managing over £150 billion in assets servicing internal e-invoicing and procurement systems. From intergrations with accounting systems such as Sage and Microsoft Dynamics to reporting and managing workflow systems administering costs. My limited understanding once discovered and helped recover a charity over £1 million in lost assets. The bread and butter product of my last employer was a software package to reduce internal expenditure of organisations. They made a lot of money from replacing things like home brew access solutions.

Please tell me... what experience are you talking from? Do you know any DML languages? Have you ever worked on the backend of financial or reporting systems?

1

u/yopla May 08 '18

I work in the financial industry and I happen to have at least a few dozen of developers working for me who can honestly claim to be working on systems handling hundred of billions of dollars but couldn't budget their way out of a paper bag. I'm not sure who you're trying to impress.

And anyway you're again missing the point because of your short-sightedness. Find me a solution for a company with $200 budget who need to buy office not a friggin F500 bank.

1

u/therealcreamCHEESUS May 08 '18

Here you go, all do e-invoicing packages under £30/month found with a quick google. Similar options exist for payrole, timesheets, you have reporting GUIs like openBI that are free. Why reinvent the wheel hacking together a crappy in house system when there are many free or cheap options available.

https://www.freshbooks.com/ https://www.zoho.eu/invoice/ https://due.com/

I've had to deal with messes that overzealous managers like yourself have left behind because they insisted on an inhouse solution when they had neither the capabilties nor the money/time to maintain and expand it.

1

u/yopla May 08 '18

Hehehe. Fantastic link. Makes my point for me: https://www.zoho.eu/creator/ .

1

u/therealcreamCHEESUS May 08 '18

Im not sure what your point is.

My stance is that microsoft access has no use. Its a poor database engine and an overly complicated spreadsheet combined. It requires a solid understanding of acid and dml principles to use properly which defeats its purpose of being a database for non technical people.

What exactly do you think you have proven? Cause you asked for cheap alternatives and I got you them.