Need Suggestions for a Real-Time Tracking System

I'm tasked with duplicating a proof of concept that my team has developed in Google Docs Spreadsheet.  I need a commercial solution that meets the following criteria.  Partial matches and suggestions will receive credit!

1.      Utilize a spreadsheet-style interface allowing dynamic filtering and update.

2.      Provide a multi-user interface where all users see any changes in real-time with functionality for this identical to Google Docs Spreadsheet.

3.      Provide user-rights level settings. This includes update, filter, browse and others.

4.      Provide segregation of some real-time view functions ie real-time content update but not real-time global distribution of view/filter settings.

5.      Use an LDAP Authentication and Security model based on Active Directory userids and groups.

6.      Provides color-based highlighting for severity/importance levels.

7.      Provides visual feedback of real-time editing by other users.

8.      Include full change-history including userids, specific modifications, and all previous versions history.

9.      Ability to save copies, export, lock versions by date or other criteria.

10.      Provide encrypted access from public networks.

Thanks Experts!
LVL 16
gurutcAsked:
Who is Participating?
 
Gregory MillerConnect With a Mentor General ManagerCommented:
I did not mean for this to turn into a sales pitch and if we continue, I would request that we take it off of EE so we don't irritate anyone.

There would be a lot of dependency on which features you would need or want. SharePoint by itself is $4-8 per seat. Other components are similar in price as individual pieces. The whole suite including Office Pro Plus that has both desktop apps as well as the web based equivalent for Word, Power Point, Excel and others, SharePoint, Exchange, Lync, and other pieces goes for $20-24 per seat. The Full subscription allows a single user to install their subscription on up to five computer or devices. This is a nice perk for users who would like the benefit of using the software from home but do not want to shell out personally for the individual Office license. If the employee ever leaves the company, the subscription is controlled by the company and can be suspended and reassigned. You can also mix and match and have users only have access to a sub set of parts and others who have access to everything. If you use MS Office, and Exchange and SharePoint in the organization now, the TCO are much less and you can control the licenses with more flexibility.
Everything is administered via web portal and some advanced functions from Powershell. Administrative users get 24x7 telephone support included in price from Microsoft.

The number of seats you are asking about would undoubtedly bring a discounted price. I would encourage you to let me set you up with a trial account which will give you Full usage for 30 days. Let me know if you want to explore any further and I can get you more details. my email address is gmiller @ geekpatrol.com

Thanks,
-greg
0
 
Gregory MillerGeneral ManagerCommented:
Why are you re-creating this if it works in Google Docs now?

Serious question so that suggestions take that fact into consideration.
0
 
gurutcAuthor Commented:
We would like to bring the app more 'in-house' and some of the functionality isn't there in Google docs like the AD-integrated authentication for one.

- gurutc
0
Improved Protection from Phishing Attacks

WatchGuard DNSWatch reduces malware infections by detecting and blocking malicious DNS requests, improving your ability to protect employees from phishing attacks. Learn more about our newest service included in Total Security Suite today!

 
Gregory MillerGeneral ManagerCommented:
Have you looked at the Microsoft O365, Sharepoint Server and Excel 2013. You can do AD integration there and Excel works similar to Google Docs with the near real time, multi-user access to sheets. This could give you a very rapid deployment.

I do not know if you can do the web apps if you self-host the SharePoint server but it might be worth the look.
0
 
gurutcAuthor Commented:
Checking the O365 per your suggestion.  Sharepoint Server won't do it.  That was our first try.

- gurutc
0
 
Gregory MillerGeneral ManagerCommented:
Not SharePoint by itself but with the office web-apps integration. If you want a trial account on O365, let me know and I can set you up with an E3 account for 30 days at no cost.
0
 
gurutcAuthor Commented:
If the O365 were to work, what's the cost for ~$4000 seats?

- gurutc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.