Established Since Sep 2003
Call: UK
+44 1223 597 940
|
US:
+1 415 800 4228
|
✉
info@projectsolution.com
Do you want to Synchronize data between Project and Excel?
Learn More | Pricing | FREE Trial | FAQ | Contact Us
Want to Integrate calculated Excel data with Project Data?
Use the power of Microsoft Excel to Capture/ Manage additional Project Data e.g. initial budget, BOM, Cost Benefit Analysis, NPV, expenses, Actions List etc. Use this solution framework to embed Excel to any Project Detail Page (PDP). Synchronise values of selected Excel cells to and from Project Server fields.
Work the way you want to. Utilize best of breed tools to achieve optimum results!! Improve the way you manage your business!
Use best-of-breed tools to effectively manage your work/projects. Use the right tool for the right job!
No need for elaborate custom development of calculation tools within Project Server/Online. Use Excel!!
Dynamic Configurable rules to synch multiple data sets between Excel and Project Server/Online.
Reduce Multiple Points of Data Entry. Enter data in either Excel or Project Server.
Use Project data in Microsoft Excel to perform complex calculations and Analysis. Utilise the results from Excel back in Project Server/Online!
Enhanced Joined up reporting in Project Server/Online by synchronising calculated/analysed data from Excel.
Retain your existing business processes e.g. initial budget estimation, benefits management, quality analysis etc within Excel.
Enhance your business processes to include additional capabilities beyond what Project Server/Online can deliver.
What are the key Benefits?
Improved end-user adoption
Improved Business Processes
Improved Productivity
Improved Reporting capability
What Business Issues are overcome?
1. Within Microsoft Project Server/Online, there is no out-of-box functionality for synchronising data between Project and Excel.
2. Users try to create multitude of Enterprise fields and complex formulas in Project Server, to emulate calculations that would normally be done in Excel.
3. Users undertaking analysis in Excel (e.g. BOM, Cost Benefit Analysis, Initial Budget), have to manually update Project Server Enterprise Custom Field values. This sometimes causes data inconsistencies and additional administrative effort.
4. Users adding to-do and action items in Project WBS.
5. Users not able to easily map their existing business processes to Project Server where some of the calculation is done in Excel.
6. User Adoption issue as result of multiple points of data entry and disparate systems for calculating/analysing business data.
Business Process Automation / Connectivity
Multi-tenancy - supports multiple instances of PWA on same environment/farm. Deploy on single server or multi server, multi-tier deployment.
Flexibility - Configuration application to easily map your existing system metadata/custom fields which can be used for integration with Excel ‘Cells’.
Standardisation - Creating new projects based on configured EPTs, will automatically inherit the Excel integration. Data values in mapped cells in Excel will automatically be synchronised with associated Project Server Enterprise Attributes/Custom Field Values, on Save.
Pricing & Packages
Framework - Configuration App
PWA configuration for mapping Project fields to Excel Workbook cells.
Synchronise from Excel to Project Server/Online
Synchronise Multiple Excel workbook integration and unlimited Excel Cell mapping to Project Server/Online fields.
Synchronise from Project Server/Online to Excel
Map and synchronise multiple unlimited Project fields to multiple Excel workbook cells.
Multi-Tenancy
Support for multiple PWA instances.
Technical Support
Free Basic Technical Support
Get started from £1 - £5/user/month, depending on number of users. Use the Pricing Calculator below and see purchase options.
If you need quote/invoice in local currency, please contact us.
SharePoint & Project Server/Online Technical Support
To provide extra peace of mind FREE basic Technical Support is provided with products developed by Project Solution.
If you encounter an issue and need assistance, you can raise a support ticket directly on our helpdesk.
The helpdesk is accessed via the link below.
New User? choose the Sign up link the login page.
Forgotten password? choose 'Forgot My Password' link on that login page.
Note: remember to use your business/organisational email address you use to communicate with us.
Presentation
Use the Cost Calculator (below) for the Licensing plan that works for your business. Pricing is dependent on the total number of users (with AD Logon) within Project Online. This provides an assessment of the scale of usage and the size of deployment of Microsoft Project Server/Online. Minimum 25 users. If you need a local currency invoice to be sent to your purchasing team, or for discounted pricing for Education and Charity, please contact us.
Per user. Min 25 users
One-time Purchase. Cost based on total number of users within Microsoft Project Online.
FREE Deployment, Configuration and Technical Support.
Per user/ month. Min 25 users
Monthly subscription based on total number of users within Microsoft Project Online. Minimum three-month initial term.
FREE Deployment, Configuration and Technical Support.
Per user/ month. Min 25 users
Save 25% with Annual Term Licensing Vs Monthly. Cost based on total number of users within Project Online. FREE Deployment, Configuration and Technical Support.
This tool works with both Project Server and Project Online.
Supported versions of Project Server are: 2013, 2016 and 2019.
Absolutely, we can organise a FREE demonstration to review the workings of the software solution with you and your team. And, to clarify any queries you may have.
We also, offer a FREE deployment service to help you get started quickly with a FREE Trial for 30days! Our aim is to make the deployment process simple and hassel free. Let our experts help you get started, for FREE.
Yes absolutely, FREE Break-fix Technical Support is provided with all products developed by Project Solution.
1y FREE Technical Support & Software Maintenance is provided for all products, including, FREE deployment assistance.
Beyond the 1st year, FREE Break-fix Technical Support is provided where issue is determined to be as result of unfound bug(s) that can be replicated on our lab test environment. All users are provided with a software update/fix to resolve these types of issues.
We offer a FREE trial of all our products with FREE deployment and support, making it simple, easy and hassel-free for you to test the solution thoroughly in your own environment.