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/therealcreamCHEESUS May 08 '18

One of the many cheap software packages for managing invoices and internal cashflow could be bought or a simple excel spreadsheet at that volume.

If its too complex for a spreadsheet then either get a software package or a proper database. If you go down the access route you are hindering yourself later on. If you are absolutely sure your business won't expand or your requirements and volume of data will never change significantly and know access well then maybe but few businesses operate on the principle of staying stagnent. You at the very least need to know DML concepts to design a decent access database anyway. You can struggle on without that knowledge but it will cost you later.

Thanks for your comments on my narrow vision, FYI my background is in reporting. I literally work in the industry you are saying I have a narrow vision of. Again if your business model is stagnent then go ahead but people like me get paid to sort out the situation a few years down the line after some inspired soul decides to hack together an access 'solution' round a core business process.

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.