What Is This Viney@rd Thing?
Most of your office work is collecting and organizing data for a purpose. The most common tool for doing that is Microsoft Excel. Countless man hours are spent copying, reworking and formatting data to be profiled, distributed or summarized for the management.
Once created those spreadsheets
get old, get lost and generate each sort of misunderstanding. The
company knowledge is dispersed among users' computers, in unnumbered versions. If data are to be reused, they are not in a format easy to be adapted to new reports.
In those spreadsheets often reside
data that are not available anywhere else in the
company, thus shared with great difficulty. Chances are that those data are a part of people hard won knowledge, that gives them the
crucial insight they need for their job.
There's no need to say that complying to regulations like
Sarbanes - Oxley, IAS or simply adhering to
auditors desiderata is painstakingly difficult without structured help.
The IT standard reply to this issue is setting up a complex project to create one or more dedicated applications but Viney@rd now gives you a
new option.
With Viney@rd users can save their data in a central repository. This repository is designed directly from Excel, so there is
no need to ask the IT to set up a dedicated database. Data are saved directly from Excel. Just
copy and paste your data onto the interactive worksheet, arrange them and save. Viney@rd accepts data in a format that's usually very close to raw data tables, so minimal
formatting is needed. From this point on,
data are available to every user.
Users themselves control directly what's available and what's not within Viney@rd. In a conventional project data rules are defined within IT constraints; with Viney@rd users can feed data according to their needs.
Being the data available, users can
embed queries in their worksheets. Creating a query does not require any technical (SQL) ability and is a point and click process.
Queries can be configured to fill even a
single fixed cell, that is, complex spreadsheets can be created and automatically refreshed without disrupting the layout. There's
no further need for custom formulas and macros just to place data somewhere else.
Queries can be synchronized, so a query result set can be filtered and displayed according to the result of a previously run query.
Filter values can be read from a spreadsheet range, so all the queries in a workbook can share the same parameters and parameters need to be entered once. Many other formatting options are available but they do not duplicate Excel functions like other reporting tools do.
