01825 733222

Capurx Forms for Excel can automate any paper based system

Only Capturx Forms for Excel enables teams to design forms in Excel, print them on ordinary paper, and have the handwritten data automatically digitised and formatted back into the original Excel fields. Non-technical teams get the ease-of-use and independence of simply working with Excel and paper, while also getting structured data which they can use within Excel or provide to IT for easy integration into databases or other backend systems.

Teams get the simplicity of working with pen and paper and all the advantages of immediate access to structured digital data.

• Easily design forms in Excel. Capturx provides teams with the power and flexibility to create or use their own existing forms with a familiar software application – Microsoft Office Excel. No new tools to buy or scripting languages to learn.
• Easily collect data on paper. Forms are printed on ordinary paper with a special watermark that enables them to be used with a digital pen. Teams can fill out paper forms in any environment without extra equipment or training. The pen leaves behind a written paper record while also instantly digitizing the information for use with Excel.
• Immediate access to rich data in Excel. Capturx automatically uploads the data and inserts it into the right formatted cells within Excel. Teams can view, share, and store the original ink strokes or the converted digital data for each form. Capturx also provides aggregated data tables which can be used for analysis within Excel or integrated into other databases or back end applications.

Capturx can automate data collection for a broad range of mobile and field
scenarios including:

Order Entry, Facilities Management, Maintenance, Inspection, Retail Management, Construction, Project Management, Public Safety, Asset Management, Expenses tracking and much more 

Components of Capturx Forms for Microsoft Office Excel

Capturx Forms for Excel

Capturx is an add-in that works within Microsoft Office Excel 2007. Forms designed in Excel can be easily prepared and printed for use with a digital pen. The Capturx add-in also enables the uploading, converting and viewing of handwritten data within Excel.

Digital Pen

Capturx includes a digital pen, which writes with regular ink, digitizes and stores the handwriting using a built-in sensor and local memory. The pen recharges and uploads data using an included USB connection. The pen supports use of up to 10 days with a single charge.

Key Features

Design Forms in Excel. Capturx works with any form within Excel. You can create new
forms or simply work with existing forms or templates.

Handwriting Converted to Digital Text. Capturx includes character recognition
functionality which converts handwritten form entries into digital text within Excel.

Broad Set of Formatting Options. When Capturx converts data – it matches the
formatting specified in the Excel form. In addition to standard Excel formats such as
numbers, dates, currencies, and text – Capturx also support check boxes, digital ink
signatures, names, addresses, and more.

Predefined Word Lists. You can create the equivalent of dropdown lists, where
handwritten entries will be matched to predefined lists of such categories as part numbers,
customers, team members, or locations.

Easy Review and Editing. A review pane can show the original ink and converted data
for each cell side by side, making it easy to review and edit any entries.
Ink and data view of each completed form. After data is uploaded into Excel,
each completed form can be easily viewed, stored, or shared as digital text or with
the original handwriting.

Summary Data Table. Capturx also offers a summary data table view – which aggregates
all the entries on each form and creates a table which can be used for analysis with Excel
or saved as csv for use in databases or other backend applications.

Easy Searching: Each form in the summary data table includes a link to the original form
making it easy to drill into specific forms. Data can also be easily searched with Excel’s native
“find” commands which can search complete workbooks for words, dates and numbers.

Collecting data from multiple forms. Individuals can use Capturx to collect data
on multiple forms at the same time. Capturx tracks the data for each type of form and
each form entry.

Collecting data from multiple team members. Multiple team members can
simultaneously collect form data using individual pens and forms. The data can be
aggregated into the same source. Capturx tracks data by user, pen, and time -- enabling
easy uploading, consolidation and management of team data.

Printing. Any custom form or template from Excel can be printed on ordinary paper, in a
broad range of sizes, using many common color printers.

Easy ways to add custom terms to the Capturx handwriting recognition dictionary to
improve handwriting recognition of words not included with standard dictionaries.

System Requirements

Basic: Requires Microsoft Office Excel 2007, Word 2007, and Office 2007 SP2
Operating System: Microsoft Windows XP SP2, Windows Vista SP2, Windows 7
Work Platform: .NET Framework 3.5