No you do not get Sharepoint AND Exchange servers with Office365. Sure you can access them, but that's not what you said.
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.
> 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.
I see Excel users in 2 camps:
Those that don't know what functions are, and if the do, tread carefully with '=if(...,...)' and get intrigued. Though those that get intrigued are in a minority.
Those that know what functions are have Excel act as a full-fledged IDE, which it does pretty well. This second camp either write libraries to call from Excel, or have someone write them in C++ if the libraries are that important.
Excel is exceedingly good for hacking, or I should say, playing. It is not a spreadsheet, it is an extension of skin from keyboard to screen for visualizing data, from brain to 2D hackable multi-dimensional grid, that is as easy as playdough.
There are a plethora of plugins to do monte-carlo simulations, linear programming, statistical models and anything else a business user would do in the data analysis world.
Vendors include SAS, Oracle, IBM, Predixion.
Also Excel is used as a self-service BI tool. It has ETL, OLAP and dynamic dashobarding.
My first job out of college was converting all the Excel spreadsheets that ran the business to web apps so I certainly know how they are used, and more importantly, how they are abused.
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.
But you're a developer. A sales manager (for example) couldn't care less about your objections.
He wants his pivot tables, KPIs and Solver and some macros. He wants point-and-click ETL. If it's a department/cross-department model, do it in SQL Server, or whatever else you use. You can use your IT kung-fu there. This is about what libre office lacks. Excel has power and flexibility and remains easy to use for non-programmers.
I agree with those points. My comments are in regards to Macros. Why is VBA better for a sales manager? Why not use VB.Net, Python or C#? There is nothing inherently better about VBA.
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.
My company uses SAS fairly heavily for data analysis and bussiness reporting. It's also our go to tool for ad-hoc querries of production databases (essentialy a SQL gui).
Excel (and other spreadsheet packages like Calc) are good for non technical users it's useful for rapidly prototyping stuff but it is absolutely a pain for automation and any type of statistical heavy lifting. Once a spreadsheet reaches a certain level of complexity it becomes a pain to support and maintain much better to have a real database driving things.
I've heard a lot about R which is kind of an open-source version of SAS (at least the statistical parts) not sure what its automation and reporting support is like my limited understanding is it doesn't have the BI parts.
You don't have to, but it would probably be best to keep it consistent. You could run your live server on barebones OS as you normally would, then create a docker image to mirror that. However, as we all know, mirrors often get out of sync fairly quick. But if you use the same image and only update using a Fabric or Ansible script, then you can be pretty certain that all your environments are identical. Not to mention that any newly created environments will brought up to the same point in no time at all.
Try it in a VM first. Most things will be fine, however if it were production ready it wouldn't be marked beta. Something that you need may be disabled or in flux leaving you hanging.
You should build the coolest project you can think off. I highly doubt that a simple laser cut alarm clock is going to get you very far in this contest.
I've used http://www.dx.com quite a bit. Prices are really, really low. Shipping is free. However, you may have to wait two months for your products to arrive.
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.
Having ordered lot's of cheap prototype/evaluation boards through dx.com/ebay/aliexpress.com, I can say for sure, that quality does differ.
Seed and co have higher standards for soldering/reflow quality, wheras random factory churns out boards, probably even not doing any sort of testing apart of "hmm, looks connected".
That being said, most of the stuff still works fine despite shobby soldering and cheapest parts they could get at the market that week.
I'd buy the book in a heartbeat if it were digital.
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.
As someone who has moved between continents a little bit too much, a $40 digital no-DRM version would be an instant buy. A $20 dead-tree version is a no-sale.
Reddit used to be big on karma parties, so when Dropbox first increased the limit from 5GB to 10GB I figured I would try a Dropbox party. I posted my referral link and encouraged others to do the same. A couple hours later I had maxed out my referrals. Since then I've seen others try, and at first they were well received but now they get downvoted pretty quickly.
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.
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.