[edwinnathaniel]

Hang on...

WAT?!

SharePoint is a CMS mixed with Document Management Systems with a sprinkle of Workflows plus a platform for small (but limited features) web-apps.

Some companies chose SharePoint because of the features and the idea of avoiding "NIH" or writing web-apps from scratch.

I think this is where the "hackers" (or geeks, whatever, hackers aren't hackers anymore these days) mindset don't jelled well with internal IT systems: we all want to develop something from scratch the way we want it, the way we know, the way we hope it will be.

Once your users are asking features of Excel to be implemented in your web-apps that use Ext-JS GRID as front-end you'll know what you're signing for...(and at that point pulling a 37signals makes you look...let's just say less useful...)

[viandante]

What features of excel? I work with Excel everyday (I'm a finance, not a hacker) and I can't really see what features, besides filters and pivots, you may want to implement in an app. The best piece of software I worked with is "Hyperion", which great just because limits the "Excel power" so that nobody feels entitled to creativity every time there is report to do.

Didn't know of the web apps in SP, would like to see some examples although, don't trust it just yet...

[edwinnathaniel]

Here's an example of a web-app (web-parts) built in SharePoint:

http://store.bamboosolutions.com/project_management_suite.as...

Sharepoint also does Workflow, good for companies that have red-tapes.

Not everybody have red-tapes but for some that do have them, Sharepoint is there to red-taped-taped you :D

Oh and excel in the browser: filters, pivots, formula, sorting, etc.

Also, Excel for data entry! (Excel to Sharepoint List).

Don't forget InfoPath forms to fill out expenses!

SharePoint also solves the problem (depending on how you look at it) with business people not wanting to use Subversion or version control system. It has "Check in" and "Check out" features.

At the end of the day, you can't replicate Sharepoint features with scrappy web-apps. I know it's enticing, but it's a very very super hard sell because the numbers don't add up.

[viandante]

I hear you and nice web app too, but basically you are telling me that Excel and SP are more cost effective than a good app made for the specifics of your needs.

I don't know, in finance at my company with put huge ammounts of man hours in crafting, correcting, dealing, with tons of excel files. There are analysts that spend most of the time putting data in Excel sheets from the data warehouse system and shipping in outlook or uploading on SP. Is this cost effective? I doubt it. It is also an horrible way of working, you have no programmatic/easy way of comparing data: start trying to understand where a certain variation from the forecast, from a certain account, came from out of 30+ entities. It just drives people mad.

I think that some way in the middle is the solution...