jayfehr
Joined 15 years ago
Joined 15 years ago
If Excel had a real scripting language as it's Macro language the problem wouldn't be nearly so bad. All that business code could just be copy/pasted, have some unit tests implemented then refactored so that the accountants code is now updated by the developer. As it is now the code has to completely rewritten in a new language.
As for the language choice, VB.Net or C# would be fine. I'm not saying it has to be Python. My complaint is that the code is non-transferrable. The apps cannot grow past Excel, and the email the most recent version to the next guy game gets you into versioning hell rather quickly.
Also, Calc has Python (and other language scripting) which puts it above Excel in my book. For built in functions yes Excel is better. As soon as you start venturing outside of Spreadsheets and into data analysis (where Macro's come into play) stop using Excel. Move to Matlab or Pandas. Excel Macro's should not be used as a selling point, they are rarely, if ever, the right tool for the job. At least with Calc you can take the business logic from your Macro's and move them into a real script. VBA isn't C# nor VB.Net compatable.
Since most of this stuff is based off of open source hardware it's pretty much identical to the name brand stuff. So it pretty much comes down to a cost/time ratio consideration when first starting out. Before you know it though, you will have quite a large collection of parts built up.
Also remember you can hit garage sales, recycle yards, and thrift shops to find a lot of old hardware that you can salvage valuable parts out of for less than the price of the parts themselves.
Edit: made link clickable
I went paperless a few years ago, one of the biggest deciding factors was my huge collection of dead-tree books that continued to take up space even though the content was obsolete.
A $20 digital version for me would be an instant buy. A $40 dead-tree only version is a no-sale.
Anyway, I guess my point is to try and see if other sites you visit will allow threads to share Dropbox invites. It is spam but since the referrals benefit both the invitee and inviter evenly some forums may allow it.
edit: I see there are some comments in thread already doing just that.
My issues with Excel come from the perspective of modifying these ad-hoc apps (many business run off these for a long time as they grow). Yes, there are other great features, but for me, for growth, Calc is taking a better approach.