EZ-Calc

OTHER VERSIONS WITH THE SAME TITLE (1)

• Royal Software (version 1.2)Spain · 1986

INSTRUCTIONS

                              EZCALC 
                  Copyright 1986 Royal Software

NOTICE: The following was deleted from our manual any reference 
 to it will be found here. 

LOGICAL OPERATORS          

     @TRUE     The value 1
     @FALSE    The value 0 

                      CORRECTIONS TO MANUAL
Page 34

 @PMT - The proper order is:  principle amount,  interest (decimal 
      value)  divided  by  number of payments,  number  of  years  times 
      payments per year.
               Example-  @PMT(45000,.10/12,30*12)

               Document for the EZ Graph Accessory.


Introduction.
    The graphing accessory will help you visualize your data  from 
EZ Calc quickly and easily.   The program was designed to be  used 
while  you're in EZ Calc and allows your spreadsheet to remain  in 
memory and readily available.  There is no need to go back to  the 
GEM Desktop to do anything.
    EZ  Graph has three of the most common  business  graphs  with 
various options for each.  These graphs are the Bar, Line, and Pie 
graphs.  There can be up to 32 bars, line nodes, or slices.

Using EZ Graph.

  To start using the accessory,  click on it's name under the Desk 
menu on the EZ Calc menu bar.  The accessory will then create it's 
window on the upper right hand side of the screen.
 Adding Labels.

  EZ Graph gives you four general labels to change or remove. Make 
sure that your spreadsheet window is sized and you can see all  of 
the  graphing window.   Then simply click and hold on a  label  in 
your spreadsheet like you where going to move it, and then move it 
over  one  of  the labels on the graph named in  table  1  in  the 
graphing window and release the mouse button.  The label will then 
change to the label that you picked.  That was easy, wasn't it?

   You can continue to drag more labels onto the graph or you  can 
type them in yourself.  To do this make the graphing window active 
and  then  click once on the label you want to  change.   A  small 
black box will appear at the end of the label.   This box is  your 
cursor to tell you that you are in input mode.   Now you can press 
the 'Esc' key on the keyboard to clear the label or just backspace 
over  the  label and enter what you want.   The  'Undo'  key  will 
change  the  label to what it was before you entered  input  mode.  
The 'Help' key will tell you the function available in input  mode 
in case you forget.  When you type the label you want , it will be 
centered in the graph.

  Don't worry if your cursor disappears,  this will happen if  you 
enter  a label that can not be displayed in the  graphing  window.  
To get the cursor back, just press the Backspace key until you see 
it again.   To exit from input mode,  click on the mouse button or 
press Return or Undo.

    Graph Title
    YTitle
    XTitle 1
    XTitle 2

    Table 1

Adding Data.

    Now  you  may  want  to make your  own  graph  so  select  the 
spreadsheet window and click and hold on a number you want to  put 
in the graph,  similar to what you did with the labels.  Then drop 
the number on top of the big bar on the graph.   This will  change 
that bar to the number you dropped on it and rearrange the graph.

   To add more than one item to the graph,  which I'm sure  you'll 
want to do,  drag a number to the outside of where the bar is  but 
not over a label and drop it.   A good place to remember for  this 
feature  is the very right hand side of the graphing  window  just 
after the dotted line.

   You can also drag and drop a range of numbers to the graph.  If 
you drop the range on top of one of the bars, it will replace that 
bar and then replace the next bar until it runs out of bars.  Then 
it will add bars to the graph.   So to make a whole new graph from 
scratch,  select  a range on the spreadsheet and drop them on  the 
first bar.

Changing Item Titles.

    When you add numbers to the graph,  just below the bar  is  an 
item title that says "XXX".   This title can be changed just  like 
changing a label, by clicking on it.

   You can also drag over a range of title,  like month names, and 
drop  them  on top of the title to change.   It's exactly  like  a 
range of numbers only with labels.

The EZ Graph Menu Bar.

   EZ Graph has a special feature that makes it easy for you to do 
complex  function with the accessory.   This feature is  the  drop 
down  menu in the graphing window,  just below the title and  move 
bar.  This menu bar is only active when the graphing window is and 
works identical to the standard GEM menu bar.  From now on, when I 
refer to the "menu bar" I'm referring to the EZ Graph menu bar.

Line and Pie Graphs.

    You  can now see what your graph looks like as a line  or  pie 
graph.   Just  select the graphing window if not already  selected 
and move your mouse over the Graph title in the  menu bar.   Three 
options will appear showing you Bar,  Line,  and Pie.   Move  your 
mouse  pointer over one of these options and click  on  it.   Just 
like a typical menu bar.

   Your graph will now change to the graph type you selected.   It 
is  still possible to add numbers or change labels in the Line  or 
Pie graphs.  The only difference is in the Pie graph when it comes 
to adding numbers.   Instead of dragging the number over the  bars 
or  circles (for lines),  drag them over the box identifying  that 
pie slice by it's title.

The Options Menu.

   The options menu in the menu bar has several items that let you 
customize  your graph.   The first item,  Clear,  will clear  your 
graph,  erasing all data entered.   The Grid item lets you turn on 
and off the dotted lines in the graph.   The Color item only works 
if you are in a color mode,  and lets you turn the coloring of the 
numbers on and off.

Stacking.

   Stacking data is more complex.   When you turn stacking on,  by 
selecting  that  item in the options menu,  your graph  will  turn 
black  and white and add a legend to the right side of the  graph.  
This mode only works in Bar or Line graph mode,  Pie graphs always 
show the first set of data.

    Now you can take another set of numbers from your  spreadsheet 
and  drop them on top of the appropriate bar or line.   This  will 
make  two bars or lines for the same title.   You can  keep  doing 
this until you have 4 numbers stacked per bar or line.   This also 
adds another legend index and title for each level of the stack.

   You can,  of course, change the title that goes with the legend 
index box or circle by clicking on it to go into input  mode.   In 
stacking mode,  you can also switch between horizontal or vertical 
stacking of the bars.

Selecting Items.

    If you have entered a number that you don't want,  or want  to 
insert a number in between two numbers,  select the item to change 
by clicking on the bar,  line node,  or slice index.   Now you can 
use  the  Insert Item or Delete Item option in the  options  menu.  
Insert Item creates an item with the same value as the first  item 
in the graph just before the item selected.   You can then drag  a 
number  on  top of that item to change  it.   Delete  Item  simply 
deletes that item from the graph.

   The Pull Slice item in the options menu only works in pie graph 
mode.   When  you select an item in this mode,  you can then  pull 
that slice out of the pie.   When you select that slice again  the 
Pull Slice item in the options menu now says Push Slice so you can 
push the slice back into place.

Loading and Saving Graphs.

   After you have made your graph you may save it by selecting the 
Save item under the File menu.   You can then recall that graph by 
selecting the Load item.   Loading destroys all data in the  graph 
by replacing it with the graph to be loaded.

    All information,  including the graph type and grid  state  is 
saved in the .EZG file.

Printing a Graph.

   To print a graph to an Epson (tm) or compatible printer  select 
the 'To Printer' item under the Print menu in the menu bar.   Make 
sure  your  printer  is  on and selected  and  has  paper  in  the 
carriage.

                   
                      Printer Driver Program

A separate printer driver program is included on the EZ CALC disk 
to accommodate all types of printers. To set up a printer driver 
for your printer, from the main disk menu, select the file 
PRINT.PRG and double click.

     If your printer is an Epson, an Okidata, a Prowriter, a 
Daisywheel-type printer or a printer that is completely compatible 
with one of these four printers, creating a printer driver is just 
a matter of clicking the appropriate button.

     A small window will open informing you that a printer driver 
named PRINTER.TYP has been created for your printer. Press Exit 
and you are all set to go. Remember to keep this file on the same 
disk with the main EZ CALC program.

     If your printer is not compatible with any of the printers 
listed, creating your printer driver will take some work. First 
find your printer manual and locate the control codes. These will 
be written in both decimal and hexidecimal notation and will 
consist of either one, two, or three numbers for each control 
code. We will be using only the decimal codes. (Decimal numbers 
run from 0 to 9. Hexidecimal numbers run from 0 through F.)

     Once you have located your control codes, press the Other 
button, and following the prompts, type the name of your printer 
and press [Return]. At this point you are ready to enter your 
printer codes on the line with the three blanks. 

     Even if a particular code has only one or two numbers, three 
numbers must be listed on the printer code line. Type in the number 
255 in the extra blank (type it twice if you have two blanks). 
Always remember to press [Return] after each number.

     To edit the printer codes, two commands should be all you need. 
  - Use the [Escape] key to erase an entire number.
  - Use the [Backspace] key to erase a single character to the 
    left of the Cursor.

     After three numbers have been entered on the printer line 
(or three [Returns] have been pressed to advance the Cursor 
without changing anything), a new printer code heading will appear 
automatically. Continue entering codes until you are no longer 
prompted with printer code headings (the last one is Emphasize 
Off). 
     At this point you will be informed that a printer driver 
named PRINTER.TYP has been created. You can return to the main 
menu by pressing Exit. While it is not necessary to keep the file 
PRINT.PRG on the same disk as your working copy of EZ CALC, always 
keep the file PRINT.TYP with your EZ CALC program.


                              EZCALC 
                  Copyright 1986 Royal Software

                     Convert Utility Program


Introduction:

The Convert utility is used to transfer worksheets from VIP or 
Lotus 123 to the EZ-CALC spreadsheet program.  It will not, 
however, convert VIP or Lotus graphics commands or macros since 
EZ-Calc does not use those type of commands.


                          Using Convert:

     To convert a file or a group of files, simply click on the 
CONVERT.TOS program from the desktop.  Your screen will show
prompts for source and destination files.  After that you will
be asked for the name of the file or files to convert. 
When this happens, enter the file name you wish to convert without
the .NAT or .WKS extension.  Convert will then look for your file
on the disk and convert the spreadsheet in it.  Convert automatic-
ally knows if your file is a Lotus worksheet or a VIP worksheet,
so you don't have to worry about it.

     Convert has a special feature for users with many files to be 
converted.  If you wish to convert ALL the files on a disk, simply 
enter a "*" and Convert will convert all the files on that disk 
that are Lotus or VIP worksheets.  

For users with several files to be converted, the question mark,?, 
also works as a "wild card" to convert all files that have a 
common group of characters in the file name.  For example, if your 
worksheets were named,

      WRK001, WRK002, WRK003   or     ACLNN, ACWEN, ACDRN

then all you would need to type is, 

     WRK00?              or        AC??N

and Convert will convert all three files. Three files named, 
KLM001, KRR, KTYR, can all be converted with the command, K*.


Special Conversions:

Convert turns macros into normal labels in EZ-Calc, since they 
are not used in EZ-Calc.  This way you can keep your macros as 
labels for later reference.  Also, all graphics commands are left 
out of the formulas since EZ-Calc does not use them.  Date 
functions are left in, but are not used by EZ-Calc.  The dates 
themselves are turned into labels so you can read them properly.  
All functions in Lotus or VIP are left in, but the few that are 
not recognized by EZ-Calc may cause errors.


Messages from Convert:

Convert has several messages which are displayed during the 
conversion process.  Their purpose is only so that you can be sure 
that the conversion process is progressing smoothly.

     The first of these is a message that tells you whether 
Convert is trying to convert a Lotus or a VIP worksheet.  Next it 
will tell you the global column width of the worksheet and of the 
individual column widths.  After that a message will 
appear that the worksheet has been found.
  
     Several letters are used to show you what type of cell 
Convert is trying to convert.  These letters are:

      L:   For a Label cell.
      F:   For a Formula cell.
      I:   For an Integer cell.
      *:   For an unknown cell (or a redundant cell that  EZ-CALC 
           does not need)

When Convert has finished the converting process, a message will 
appear telling you that it is done.

The resulting file made from Convert is a file with your original 
name except it has the .EZC extension and will now work with EZ-
CALC.