Solved

Need Suggestions for a Real-Time Tracking System

Posted on 2014-02-17
7
428 Views
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!
0
Comment
Question by:gurutc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 11

Expert Comment

by:Gregory Miller
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.
0
 
LVL 16

Author Comment

by:gurutc
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
0
 
LVL 11

Expert Comment

by:Gregory Miller
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.
0
Business Impact of IT Communications

What are the business impacts of how well businesses communicate during an IT incident? Targeting, speed, and transparency all matter. Find out more in this infographic.

 
LVL 16

Author Comment

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

- gurutc
0
 
LVL 11

Expert Comment

by:Gregory Miller
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.
0
 
LVL 16

Author Comment

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

- gurutc
0
 
LVL 11

Accepted Solution

by:
Gregory Miller 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 @ geekpatrol.com

Thanks,
-greg
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In the wake of AWS' S3 outage, we want to discuss the importance of storage and data diversification in the event of a hack, crash, or system disruption. We spoke with Experts Exchange’s COO Gene Richardson for a deeper understanding.
We asked our MSP customer base what their favorite tools were and how they help them serve clients. We focused our questions on favorite tools in the following categories: >PSA tools >RMM tools >Alert management tools >Communication tools and Mo…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

734 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