User:Krasovskys/SpreadsheetWEB

SpreadsheetWEB

SpreadsheetWEB logo SpreadsheetWEB logo
SpreadsheetWEB screenshot SpreadsheetWEB screenshot SpreadsheetWEB
Developer(s)	Pagos, Inc.
Stable release	3.2 / February 11, 2011 (2011-02-11)
Written in	C#
Type	Web-Based Spreadsheet Applications, Dashboard Reporting, Business Intelligence
Website	http://www.spreadsheetweb.com

SpreadsheetWEB (SSW) is a tool developed by Pagos, Inc., that is used to create web applications from Microsoft Excel documents. SSW is capable of converting and publishing over 333 built-in Excel formulas and incorporates support for charts, maps and images. It is designed to convert spreadsheet-based processes into database-driven, web-based applications. In most cases, applications created by SpreadsheetWEB don't look like conventional spreadsheets. Rather, they are designed to look like more traditional web applications. The product has two main components: the SSW Wizard and the SSW Control Panel.

SSW Wizard

The Wizard is a Microsoft Excel add-in, accessed from a ribbon after installation. It is compatible with Microsoft Office 2003 and above. It is responsible for the conversion of the Excel file prior to server upload. The Wizard features a series of steps, from choosing a display range to setting input cells to creating save cells. Formatting options from Excel are also conserved, including validation settings, color schemes, fonts, multiple tabs/worksheets, form controls and images. There are also options for AJAX automated calculations as well as support for scripting and creating PDF reports.

SSW Control Panel

Once an Excel file is converted with the SSW Wizard, it is uploaded either to a Pagos-hosted dedicated server or a self-hosted server running the SSW server software. Both of these are controlled through an application manager called the SSW Control Panel. Along with hosting the files, it also allows for the creation of user groups, management of account settings and generation of codes for website integration. The Control Panel is split into seven tabs accessible by the system administrator:

• Applications, which allows for application management and settings
• Processes, which allows you to run batch processes, including data record import
• Data, where data that is collected by applications or imported can be viewed, edited and analyzed
• Users & Groups, where administrators can set privileges for specific users or whole groups
• Specials, where code can be generated for the implementation of SSW applications into websites or blogs
• My Account, where account settings are managed
• Administration, where custom role definitions are set, as well as LDAP settings and server status

Dashboard Reporting

Dashboard reporting has been implemented in the most recent versions of SSW. Dashboards are an analytic tool used to create data visualizations in order to discover trends or patterns in large data sets. SSW supports two types of dashboard reports: cubes (where the data set is entirely imported and the report is not linked to a data collection application) and dashboard reports (where data sets can be imported but are linked directly to a SSW data collection application). These reports are real-time data visualizers controlled by certain filters, parameters and dimensions, all of which are set in the SSW's dashboard creation environment. They are made up of charts, graphs, maps, images and pivot tables. All facets of these environments can be customized, including the background color, position and size of dashboard elements, titles, chart legends, static text fields, grids and worksheets. Multiple worksheet dashboards are also supported.

System Requirements

SpreadsheetWEB requires Windows Vista or Windows XP, Excel 2000 or higher and the .NET Framework 3.5 (free). SpreadsheetWEB can also be used with Microsoft Excel 2007.

Licensing

SpreadsheetWEB is available to organizations and individuals as Software as a Service. Available editions include individual, team, professional and enterprise.

A server license is also available for companies to install SpreadsheetWEB on their own servers, allowing unlimited usage.

Versions

Version 3.2 Released on February 7, 2011

• Version control support
• Server status monitoring
• Mapping support in dashboard reporting
• Support for multipage dashboard reports

Version 3.1 Released on November 2, 2010

• Support for Microsoft SQL Analysis Services (SSAS) server and cubes
• Support for Microsoft Excel 2010
• Record History Support
• Support for Custom Data Tab views

Version 3.0

• Released on July 19, 2010
• Scripting Support
• New Control Panel user interface
• Improved server performance and memory management
• Excel Add-in features:
  • Ribbon support
  • Connect to Workbook support
  • Installation for 64-bit servers
  • Microsoft SQL 2008 support

Version 2.5 Released on February 18, 2010

• Dashboard Reporting
• Improvements in Grid control to handle large data sets
• Added controls for caching

Version 2.4 Released on November 27, 2009

• Support for custom role definitions
• Sparkline support
• Support for assigning an application to multiple groups
• Improvements in web service support
• Improvements in chart support

Version 2.3 Released on August 5, 2009

• Mapping support
• Web services support
• Support for textbox validation
• Comment support

Version 2.2 Released on May 26, 2009

• "Import to Database" feature
• New Batch Process feature
• PDF support
• Filter, Sort and Search capabilities in viewing saved records through Control Panel
• Dynamic Image rendering feature integrated with worksheet formulas and hyperlinks
• Custom Action Button
• Support for scroll bar input control

Version 2.1 Released on March 30, 2009

• File attachment support
• Support for unique data entries
• Single record application support
• Support for Control Panel customization (Server licensing only)
• Improved Chart support
• Ability to prevent concurrent data editing
• 333 built-in Excel functions supported
• Miscellaneous wizard improvements
• New worksheet formulas to query and render images and files from SpreadsheetWEB database

Version 2.0 Released on November 11, 2008

• AJAX based input controls
• Required field support
• LDAP support
• Improved Pivot Table support
• Improved Chart support
• Support for Excel 2007 file format (XLSX)
• Support for server clustering

Version 1.6 Released on August 22, 2008

• Extended chart support
• Support for auto responder emails
• Page forwarding support
• New user roles
• Secure access (SSL) support

Version 1.5 Released on March 07, 2008

• Support for PivotTables®
• New tools for a rich user interface experience
• Additional access control functionalities
• Addtional SpreadsheetWEB database features

Version 1.4 Released on December 10, 2007

• support for multiple worksheet web applications
• 325 built-in Excel functions supported
• Database support including Excel's query functionalities
• Many other performance, security and stability improvements

Version 1.3 Released on July 19, 2007

• New input type 'grid', which allows to assign a range of cells (matrix) to be assigned to one single input cell
• Template library
• Custom application button positioning
• Support for hyperlinks
• performance and stability were improved significantly

Version 1.2 Released on May 3, 2007

• Completely re-designed SpreadsheetWEB Control Panel
• New and very easy to use concept for managing web applications, users, and groups
• Code generator for easy integration of web applications with your own website, blog, etc.
• Supports 300 Excel functions
• Save data from your web application to an Excel-compatible file
• Permanent links for web applications
• Improved layout conversion

Version 1.1 Released on October 6, 2006

• Completely re-designed SpreadsheetWEB Wizard
• Converts Excel charts
• Converts embedded images
• Converts Excel's built-in form controls
• Allows users of a web application to submit the current contents; an email is sent to a pre-defined email address

Version 1.0 Released on June 11, 2006

• Supports 265 Excel functions
• Create form controls using SpreadsheetWEB's form control tool
• Converts most common cell and text formatting

External links

• SpreadsheetWEB
• SpreadsheetWEB Video Tutorials