Need Suggestions for a Real-Time Tracking System

Posted on 2014-02-17
Last Modified: 2014-02-19
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!
Question by:gurutc
  • 4
  • 3
LVL 11

Expert Comment

ID: 39865736
Why are you re-creating this if it works in Google Docs now?

Serious question so that suggestions take that fact into consideration.
LVL 16

Author Comment

ID: 39865747
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
LVL 11

Expert Comment

ID: 39865776
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.
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

LVL 16

Author Comment

ID: 39865801
Checking the O365 per your suggestion.  Sharepoint Server won't do it.  That was our first try.

- gurutc
LVL 11

Expert Comment

ID: 39865826
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.
LVL 16

Author Comment

ID: 39870369
If the O365 were to work, what's the cost for ~$4000 seats?

- gurutc
LVL 11

Accepted Solution

Technodweeb earned 500 total points
ID: 39870586
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 @


Featured Post

Free camera licenses with purchase of My Cloud NAS

Milestone Arcus software is compatible with thousands of industry-leading cameras for added flexibility. Upon installation on your My Cloud NAS, you will receive two (2) camera licenses already enabled in the software. And for a limited time, get additional camera licenses FREE.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Contact management 16 178
WordPress AWS: site goes down 2 91
force domain users to enter username at login 2 68
Migrating From One Mac To Another 2 46
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
Exchange server is not supported in any cloud-hosted platform (other than Azure with Azure Premium Storage).
Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Sending a Secure fax is easy with eFax Corporate ( First, just open a new email message. In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now