Welcome to Pagos

Demo Applications by Business Need: Data Collection

Any Microsoft Excel spreadsheet can be turned into a web application for collecting data online. Setting up web form fields is easy and only takes minutes. SpreadsheetWEB provides submitted data in convenient Excel reports.

For advanced users SpreadsheetWEB offers the possibility to create web applications that work with a database in the background. But all you need to set up such an application is knowledge of Excel.

 

Demo Applications

Project Proposal Template

Small or large, most companies use spreadsheets to collect data from users. The ease of adding or removing data fields, and advanced formatting features, make spreadsheets an ideal platform for data collection. One can create a data collection template for practically any purpose or business need in a matter of hours if not minutes using standard spreadsheet software like Microsoft Excel. Users fill in necessary data and send the spreadsheet back to the person in charge of compiling data. This person typically compiles data from each individual file into a master spreadsheet for processing and reporting. While spreadsheets offer tremendous flexibility and speed, they typically lack automation, version control and security. Most of the time data needs to be manually copied multiple times which leads to inefficiencies and errors. It is also difficult to keep the data current as different versions of spreadsheet files move around.

SpreadsheetWEB offers an ideal solution to those issues like the lack of automation, version control, and security. At the same time it allows you to continue building and maintaining your data collection templates in Excel.

Let’s take a very common example. This financial services company has been using a spreadsheet template for managing new project proposals. You can download the file from the link link . The fact that each department can customize this template for their requirements prevents this organization from investing into a complex web based solution. High development and maintenance cost for such a system is certainly another factor.

With SpreadsheetWEB, this template can be turned into a professional looking web form in a matter of minutes. Each department can continue creating their customized forms in the same manner. They simply make their changes on the original template and use SpreadsheetWEB Conversion Wizard to create the web form. Data on each project can be modified through the same web form. Users can change the status of the project based on a list of statuses defined at the time of conversion.

Example: Project Proposal Template

 

Employee Evaluation

This example demonstrates how an Employee Evaluation Web Form can be created using SpreadsheetWEB. This form collects the information from the user, saves it to the online database, which then can be viewed by administrators of the website using the control panel. The second application demonstrates how a resulting page can be created which displays the results.

Example: Employee Evaluation

 

Expense Tracking

In any business, there are expense reports which need to be completed. If you are detached from an office, this process can be tedious. With SpreadsheetWEB, you can have a web enabled system that is available to everyone independent of location. Individual reports, generated from a database, can be rolled up at management levels to determine cost of doing business and adherence to budgets. If you have Excel spreadsheets now to report expenses, they can easily be transformed to web based applications.

Example: Expense tracking

 

Online Voting

We all take votes periodically. Two of the most important items for the voter are ease of use and at their own pace. By using a voting system driven by the Internet, you can solicit consumer input on your product or service, without the stigma of intrusion. SpreadsheetWEB allows your business to convert desktop Excel files to web applications with ease. The output is a report which can be used for business applications including consumer, distributor, salesperson and others.

Example: Online voting

 

Market Survey

In any organization, marketing intelligence is crucial to the survival of the business. The Internet is a very efficient way to conduct the surveys. With SpreadsheetWEB, you can turn those Excel spreadsheet models into active data gathering instruments in order to determine your position in the marketplace. It is simple to convert, and cost effective. The reports can be your best insight into market leadership.

Example: Market survey

 

General Survey

Does your company publish surveys? Many times it is a desirable way to gather information for marketing, consumer preferences, product acceptance, or for many other purposes. The Internet is a very beneficial way to conduct the surveys. With SpreadsheetWEB, you can turn those Excel spreadsheet models into active data gathering instruments in order to answer the many questions you may have. It is simple to convert, and cost effective.

Example: General Survey

 

Microsoft Windows Vista, Microsoft Windows XP, Microsoft Windows 2000, Microsoft Excel 2000, Microsoft Excel 2002, Microsoft Excel 2003 and Visual Basic are either registered trademarks or trademarks of the Microsoft Corporation in the United States and/or other countries.