Spreadsheet Server, Powered by the QueryExchange™ (formerly known as EDASH) is the backbone of our Microsoft® Excel-based Automation Roadmap that allows organizations to gain live and dynamic access from their respective ERP or relational database from within Microsoft® Excel to data such as: GL, AP, AR, PO, Inventory, Manufacturing, Rent Roll, Sales, Projects, Time & Attendance information and more…

Spreadsheet Server converts Excel into a tightly integrated analytical tool for any ERP system. Users can leverage the strength of their spreadsheets with seamless dynamic integration to their Information, along with powerful drill-down capability to the lowest level of detail. It allows users to build a range of reports from simple ad hoc workbooks to complex dashboard-type views of critical business data. Spreadsheet Server eliminates the re-keying or downloading of data into the spreadsheet and makes the spreadsheet an integral part of the application.

While maintaining the full functionality of their Excel spreadsheet application, Spreadsheet Server allows the user to mix GL and Non-GL data in a single worksheet. The combination of powerful spreadsheet functions (charting, graphing, text formatting and sorting) and dynamic information provides the basics for building accurate, elegant income statements, balance sheets, and other critical statements.

The Spreadsheet Server application consists of three components:

• Excel Add-in— Allows the user to execute QueryDesigner queries on a spreadsheet, returning dynamic business data.
• QueryDesigner— A visual tool which allows users to design, maintain and run queries.
• QueryExchange™— An online depository of queries from which the user may download selected queries to the QueryDesigner and then utilize them in Excel.

Spreadsheet Server Configurations are listed below, including our Designer GL Series for any system you do not see listed.

Click one of the links below for more information.

		Coca-Cola Bottling Co.Consolidated ERP System: SAP® Products: Spreadsheet Server, Distribution Manager (PDF)
		Solo Cup Company Inc. ERP System: Oracle® Products: Spreadsheet Server, Distribution Manager (PDF)
		Crocs Inc. ERP System: JD Edwards® Products: Spreadsheet Server, Distribution Manager (PDF)
		AEP Industries, Inc. ERP System: QAD® Products: Spreadsheet Server, Distribution Manager (PDF)
		Hunter Fan Company ERP System: JD Edwards® Products: Spreadsheet Server, Distribution Manager (PDF)
		BMI ERP System: Oracle® Products: Spreadsheet Server, Distribution Manager (PDF)
		St. John's Knit ERP System: MOVEX® Products: Spreadsheet Server, Distribution Manager (PDF)
		Bassett Furniture ERP System: JD Edwards® Products: Spreadsheet Server, Distribution Manager (PDF)
		Gate Petroleum Company ERP System: Infinium® Products: Spreadsheet Server, Distribution Manager,Budget Manager (PDF)
		Interfloor Group Limited ERP System: MOVEX® Products: Spreadsheet Server, Distribution Manager (PDF)
		Old Second Bancorp ERP System: Jack Henry® Products: Spreadsheet Server, Distribution Manager, Executive DASH (PDF)

		Coca-Cola Bottling Co. Consolidated Christy Ruth Director, Financial Systems & Business Integration Products: Spreadsheet Server Distribution Manager
		La-Z-Boy Linda Nelson Corporate Accounting Manager ERP: JD Edwards® Products: Spreadsheet Server
		Guthy-Renker Janice Reitman Accounting Manager ERP: Oracle® E-Business Suite Products: Spreadsheet Server
		Metromont Jim Hutcheson Systems Manager ERP: Oracle® Products: Spreadsheet Server
		Regency Centers Julie Gayes Business Analyst ERP: JD Edwards® Products: Spreadsheet Server
		Centro Properties Group Shane McConnell Director - IT ERP: Oracle® Products: Spreadsheet Server

Minimum Software	Recommended
Windows XP SP3	Windows 7 (32-bit or 64-bit)
Excel 2003	Excel 2010 (32-bit only)
IBM iSeries Access for Windows V5R1*	IBM iSeries Access for Windows V5R2 or higher
Microsoft .Net Framework 4.0
Microsoft Visual Studio 2010 Tools for Office
SAP R3 4.7 or higher**	SAP R3 Netweaver 7.0/ECC6***

* if using the iSeries
** if using SAP classic ledgers (FI,CO,PCA)
*** if using SAP NewGL or any Spreadsheet Server Designer GL's against SAP

For all Spreadsheet Server installations knowledge of the Database host name or IP address, the Database/Library/SID or Catalog where the Data resides, as well as a Username and Password on the database system will be needed.

• 1. Does Spreadsheet Server require a Server?
• No, there is no additional hardware required to implement Spreadsheet Server.
• 2. Will I need a data warehouse for Spreadsheet Server?
• No, there is no data warehouse or additional hardware required.
• 3. Do I need training? How long is training?
• Yes, if users are familiar with Excel, they will need minimal training to use Spreadsheet Server. No programming or query knowledge is necessary. Users simply utilize the standard Excel spreadsheet capabilities supplemented with simple cell formulas to gain access to their dynamic financial information.
• 4. Can I do reporting beyond the GL?
• Yes, please inquire about our ad hoc capabilities and other components in our Excel Automation Roadmap (i.e. Enterprise Budgeting, etc).
• 5. Is this a Business Intelligence tool? What if I already have a BI tool?
• Spreadsheet Server is not a BI tool, but is a compliment to the leading BI tools (i.e. Cognos,Business Objects, Hyperion, etc). In fact, over 83% of Global Software Inc.'s 4,000+ clients in 40 countries use a leading BI tool in conjunction with Global Software's Excel automation tools.
• 6. Where do I find which versions of my ERP are supported?
• We support most worldwide ERP systems, but you may contact us directly regarding your specific needs.
• 7. What is the difference between this tool and my current reporting strategy?
• Every reporting environment is different, however most prospective users we encounter are either using a data warehouse that reflects yesterday's data, manually rekeying data or have an IT maintain the current reporting environment exclusively. With our application(s) users are empowered to be self-sufficient while accessing 'live' data in a secure environment.
• 8. I've invested significant time in my current reporting strategy, will I lose reports I have already created?
• No, Spreadsheet Server is compatible with any Excel reports already developed.