New User Guide

A new SHEETMATE User Guide is now available for HP3000 users. The User Guide is offered FREE with each demonstration copy of SHEETMATE. Simply create the required CIC account with the command listed below and then contact us either by email sales@hillarysoftware.com or phone (1-800-445-5279 or 1-732-974-8484) and one of our representatives will install SHEETMATE on your HP3000 today!

Please use the following command to create the CIC Account on your HP3000:

:NEWACCT CIC,MGR;CAP=AM,ND,SF,IA,BA,PH,DS;ACCESS=(R,X,L:ANY;W,A:AC)

Note: If you prefer to install the SHEETMATE demo on your HP3000, we will send SHEETMATE to you on disk. The Installation Chapter on page 13 of the SHEETMATE User Guide provides complete demo installation guidelines.The manual contains nearly 500 pages of detailed information, with dozens of examples to help you get the most from SHEETMATE. It includes samples showing how to automate SHEETMATE using Batch Jobs and FTP transfers with Novell and NT Networks.

The SHEETMATE User Guide is an instrumental tutorial and gives you troubleshooting advice right at your fingertips. To obtain information on how to receive this manual, please email us.

To receive the full Introduction from the Manual please click on the link. It will open an Adobe Acrobat PDF file sheetm_1.pdf. The Introduction describes many of the features of SHEETMATE.

Introducing SHEETMATE

What is SHEETMATE?

SHEETMATE is an incredibly useful software system that makes information from your HP3000 computer available on PC and Apple Macintosh computers.

SHEETMATE can read spool files, MPE files, SD (self describing) files, COGNOS subfiles, and Image databases.

SHEETMATE creates real formatted spreadsheets, databases, word processing files, print files and other PC data files directly on the HP3000 and can trigger a PC file transfer so the HP3000 information moves to your PC ready to use. The data arrives in the PC format of your choice!

Because SHEETMATE completes PC file conversions on the HP3000, users can FTP PC formatted information directly to Novell or NT LAN servers. So HP3000 data is converted and moved all automatically arriving ready for end users; complete with PC format file extensions!

SHEETMATE can be run in batch mode taking data which originates on your HP3000 and converting it into familiar PC formatted user-ready files. This can all be done without user intervention during overnight batch operations.

SHEETMATE is a one-step bridge between the HP3000 and direct-connected PCs or network servers with any number of supported PC or MAC workstations.

SHEETMATE User Features

• SHEETMATE requires no re-programing or disruption of your current systems. Users have nothing new to learn. The reports they receive now on paper are simply made available to them in a spreadsheet or other PC format. No new report-writers are required; just the power to use what you already have to better advantage.
• Any report produced on an HP3000 computer can be read and translated into spreadsheet format. This is true regardless of whether the report is generated "in house" or is produced from a 'third party' software package running on your HP3000.
• SHEETMATE can interact with your IMAGE databases collecting information directly from IMAGE data sets.
• SHEETMATE also reads COGNOS subfiles and QUIZ users can invoke QUIZ right inside SHEETMATE. QUERY can also be used inside SHEETMATE to retrieve and convert information found in IMAGE databases.
• SHEETMATE delivers converted PC formats with correct PC file extensions not just ASCII delimited formats.
• SHEETMATE generates and downloads spreadsheet files directly while setting justification and column widths automatically. (SHEETMATE parses data thereby creating spreadsheet "cells" for you.) This is not possible with clumsy "Print File" (.PRN) formats.
• SHEETMATE deliberately parses files to automatically determine columns for you. This provides a major advantage for spreadsheet users.
• SHEETMATE doesn't only convert files, but has the capability to choose only the information you need presented. You may wish to select row information (horizontal slices) or choose particular columns (vertical slices).
• SHEETMATE provides powerful selection and formatting commands to give you control over the output file. All of the selection and formatting commands are optional. You decide how you wish to utilize SHEETMATE. Follow a simple, basic procedure for producing entire reports in their existing format. Or, with the addition of a few simple commands, you can change the layout of your data in sophisticated and helpful ways.
• SHEETMATE can save a series of commands which request particular areas of a report that you need. You can invoke these "batch" files on a daily or weekly basis.
• SHEETMATE can be set up to automatically send PC formatted files to your Novell or NT network server as part of your normal MIS operations. SHEETMATE System Features
• A wide variety of "PC" computers is supported. SHEETMATE supports HP Vectras, IBM PC/XT/ATs, compatibles or PS/2s, and Apple Macintosh personal computers.
• SHEETMATE only requires that it be run with one of the many popular HP terminal emulators, such as:
  • Reflection (DOS, Windows or MAC)
  • AdvanceLink (DOS or Windows)
  • MINISOFT 92 (DOS or Windows)
  • Business Session (DOS, Windows or MAC)
• SHEETMATE is loaded once onto your host HP3000. All your PC or LAN based PC computers can use SHEETMATE without additional setup. You don't have to put SHEETMATE on each PC!
• SHEETMATE resides on your HP3000. So, once loaded, it becomes available for use by any PC or terminal engaged in a session with the HP3000.
• SHEETMATE has a major advantage over client based PC conversion tools. Since SHEETMATE resides on the host, SHEETMATE can strip unwanted HP3000 host information to just convert and move the actual information required. For example: Moving an entire 200-page sales report to the Sales Department's network server is not necessary. If the Sales Department only needs a Total line from each page of the 200-page report, then SHEETMATE "grabs" only one specified Total line from each page and leaves the remaining data behind.

How You'll Learn SHEETMATE

The SHEETMATE User's Guide contains detailed information about installing and using the SHEETMATE system utility operating on the HP3000. To help you learn SHEETMATE and produce PC formatted files the printed documentation and online Help includes the following features.

Quick Steps for Creating a PC Formatted Spreadsheet File In Learning SHEETMATE you will find out how easy it is to create and download a PC formatted file using an existing report residing on your HP3000. We lead you through the quick steps needed to create a spreadsheet formatted file.

Online Help The online documentation includes a Novice Mode to provide the user with a guided tour of SHEETMATE and its functions. The Novice Mode leads the new or infrequent SHEETMATE user through the commands needed to generate a PC formatted file. Also available online are Nuts and Bolts descriptions of SHEETMATE commands. These commands give you control over the creation of formatted files.

Complete Installation and Configuration Instructions In Installation you will receive detailed instructions for installing SHEETMATE onto your HP3000. If you require further detailed information to run SHEETMATE, we provide additional information in Configuration.

Easy to Follow Exercises In order to utilize SHEETMATE's powerful commands in helpful and specific ways we have included Using SHEETMATE. We lead you through detailed exercises to teach you how to select particular report information or save a series of commands to be used at a later time.

MIS Automation and Setup Find hints on putting SHEETMATE into batch jobs. We provide examples on using FTP and HP3000 ARPA services to completely automate PC conversions with SHEETMATE and distributing this HP3000 information directly to Novell and NT LAN servers.

Appendix and Index The appendixes of the SHEETMATE User's Guide provide useful reference information such as emulator compatibility, SHEETMATE user support, and changes from previous versions of SHEETMATE. The index equips the user to quickly search for information pertaining to a specific topic of interest.

SHEETMATE Home | New Enhancements