Event 1 Software’s Office Connector, already favored by over 1,000 end users, now brings its power to Prolog
September 1, 2007 - Vancouver, WA - Event 1 Software, Inc. (Event 1) creators of the award winning Integrator for Trimble Prolog Manager and Sage 300 Construction and Real Estate, has released its newest product, Office Connector Query for Prolog Manager and Microsoft Excel.
Microsoft Excel is widely considered the most popular information analysis software in use world wide. Event 1 has already experienced overwhelming success with Office Connector for Excel and Sage 300 Construction and Real Estate (STO), with over 1,200 STO customers choosing Office Connector and Excel as their preferred information management tool. The introduction of Office Connector for Prolog Manager brings to Prolog users unprecedented functionality and convenience when accessing their Prolog information from within Excel.
"We regularly hear from Prolog users who want to do cost forecasting, reporting across projects and more from within Excel. Many of them are aware of Event 1 Forecast (Project Manager distributed cost forecasting) and Office Connector for Sage 300 Construction and Real Estate and have wanted the same access to their Prolog information", says James Coyle, President, Event 1 Software. "In fact, customers often want to forecast costs based on Prolog information, then have those cost forecasts integrate automatically with their Sage 300 Construction and Real Estate data. Office Connector can do that and much more!"
Office Connector Query for Prolog Manager is an add-in for Microsoft Excel that allows users to directly connect Excel to their data source (in this case Prolog Manager data). The Office Connector toolbar in Excel gives the users access to wizards allowing them to directly connect a cell in Excel to data in Prolog, or connect a range of cells to fields and tables in Prolog. Wizards even allow the users to conditionally pull data from Prolog based on variables (e.g. a range of dates) and those variables can be cell values within the workbook.
The result is that by changing a range of dates, a project number or some other criteria the workbook can conditionally and automatically refresh the data from Prolog. This allows Office Connector customers to focus on their preferred worksheet layout, cell formats and more, leveraging the full power of Excel, including automatic sort and subtotaling, Auto Filters, Hyperlinks and more. Existing Office Connector users claim extraordinary increases in productivity through the use of Excel and Office Connector, including work processes that once took days now taking hours or minutes!
What’s New in this Generation
Office Connector Query for Prolog Manager brings the familiar, interactive data-integration tools prior versions of Office Connector have offered, with the following improvements:
- Ability to draw information from multiple databases simultaneously
- Expanded functions (Lookup, Count, Sum, Min, Max, Avg etc.)
- Wizard access to sorting, summing, conditioning and linking tables
- Ability to link tables via the wizard
About Event 1 Software
Located in Vancouver, WA, Event 1 Software is a premier developer of Microsoft Excel based Business Intelligence software. Since 1998, Event 1 Software has provided technology to thousands of forward thinking end users through its suite of Excel-based integration products, including Office Connector Query, Office Connector Write, and Forecast. In addition, Event 1 Integrator for Prolog Manager and Sage 300 Construction and Real Estate is widely recognized as the most successful strategic integration with over 60 companies relying on Integrator for seamless Prolog/Timberline integration.
Contact Event 1 Software, Inc. via email - firstname.lastname@example.org, or call (360) 567-3750, or visit our website at event1software.com.