 |
 |
 |
 |
|
|
|
Spreadsheet-to-Web and Spreadsheet-to-Database Systems
How can you collect data from clients, brokers, manufacturers, and other
companies you deal with in spreadsheet formats without accumulating HUGE
amounts of data? Well, more than 75% of an average spreadsheet's size is
consumed by its design elements. When you receive it, you'll likely extract
the data into another spreadsheet or data system to be analyized, right? So
there's no need to suffer the overhead of sending huge spreadsheet files across the
Internet.
Our data systems can take most common spreadsheet formats, including
Microsoft Excel® and Lotus 123® and translate them into
platform-independent data files that can be formatted for display on the
Web, entry into a relational database, or restructured back into any spreadsheet application. Check out the example below:
The original spreadsheet:
This spreadsheet was in Microsoft Excel® format and was approximately
700 Kb in size.
The OPAL Group provided code in Excel's native Visual Basic language, and
allowed the client to place a button, like the one seen to the right, on
each spreadsheet they use. When the button is clicked, our "smart" processor strips the data out of the
spreadsheet into a platform-independant format, encrypts it, and sends it through the
network to a central Web server where it is authenticated, verified, and
then formatted for display or database storage.
Size of data sent across the Internet: 1.54 Kb!!!
That's a reduction of 99.9978% for this small amount of "real" data! Most
spreadsheets will see reductions of more than 75%.
The companies you deal with will LOVE the convenience of sending data in
their native spreadsheet formats, rather than entering and re-entering data
several times in multiple systems! Now, all of your applications can talk
to all of their applications.
This is a very simple example with only 2 data rows and
some top-level summary information, but this system can easily handle
systems with thousands of rows, and Megabytes of raw data. The results of
those operations are seen below.
|
|
|
|
A sampling of what we have to offer.
|
Your Company, LLC