Spreadsheet Server is a new add-on product developed for the MXP environment by our partner Global Software. Most of the information below is taken directly from their website, which you can access at www.glbsoft.com.
Spreadsheet
Server is an innovative Microsoft® Excel add-in that allows users to
access 'live' data within Excel, while maintaining the full ability to drill
down to supporting details. Spreadsheet Server enables users to leverage the
familiarity of Microsoft Excel as a reporting and analysis tool while providing
up-to-the-minute dynamic data. The key is to keep it simple. Spreadsheet Server
is the tool of choice because of its ease of use. Users of Spreadsheet Server
can simply open a spreadsheet and watch the balances of their spreadsheet
populate with dynamic financial balances. The unique drill down capability takes
the tool to a new level of detail by allowing individual transactions to be
monitored.
The highly volatile nature of financial reporting creates a need for dynamic information. Leveraging spreadsheet functionality with Global’s technology, the integrity of critical MXP financial data is maintained. Spreadsheet Server for use with Foresight's MXP is also intuitive to install and maintain. No server-side deployment means no day-to-day IT support is required.
Dynamic Balances
Retrieve dynamic period, year-to-date, life-to-date and quarter balances using simple Excel formulas. Formula wizard is available to assist users in creating new formula expressions. Segment descriptions can also be retrieved for single accounts.
Account Combinations
Use wild cards, ranges, or segment lists to retrieve any combination of accounts into a single spreadsheet row. Segment Lists are user defined combinations of segments that are set at the local level or can be shared among multiple users.
Drill
Down Capabilities
Dynamic drill down capabilities allow for review of detailed account balances and journal entry information. Capabilities also include configurable drill-down to additional detail, including financial and non-financial data. Combine your financial reporting with account analysis to achieve more efficient analysis of your key data.
Security Features
Security can be configured by user to restrict the areas of data that an individual can access. The security, which is controlled by an administrator, is based upon account segment information.
Distribution Manager
Automate the distribution process of your financial statements by using Distribution Manager within Spreadsheet Server. Configure multiple report packages that supply parameters, calculate, and then print or email your reports, all with the click of a button.
Spreadsheet Server for MXP is sold and supported directly by Foresight Software. For more information about this, or any of our products, please contact us using the links to the left.