







                               WINE CELLAR 2













	NOTE:  This is a SHAREWARE VERSION of WINE CELLAR Version 2.0.a
	
	                   Give copies to your friends!

		If you find WINE CELLAR to be useful, please send $25,
		and your suggestions for improving WINE CELLAR to:

                               KCS SOFTWARE
                              927 Mears Court
                         Stanford, CA  94305-1041


              Registered users will be informed of upgrades.










                          (C) Copyright 1986-1992


                               KCS SOFTWARE
                              927 Mears Court
                          Stanford, CA 94305-1041
                       (415) 493-7210 (Voice or FAX)







                             TABLE OF CONTENTS





			CHAPTER 1.  ORGANIZING YOUR OWN WINE CELLAR

			CHAPTER 2.  GETTING STARTED WITH WINE CELLAR 2

			CHAPTER 3.  MAIN MENU

			CHAPTER 4.  ENTER DATA ON YOUR WINES

			CHAPTER 5.  CORRECT YOUR WINE LIST

			CHAPTER 6.  DELETE LISTINGS FOR YOUR WINES

			CHAPTER 7.  SEARCH YOUR WINE CELLAR

			CHAPTER 8.  PRINT A LIST OF YOUR WINES BY NUMBER

			CHAPTER 9.  CONVERTING DATA FROM VERSION 1.52 TO VERSION 2.0

			CHAPTER 10. PRINTING ON A LASERJET PRINTER

			CHAPTER 11. SUBJECT INDEX
























CHAPTER 1.  ORGANIZING YOUR OWN WINE CELLAR


	You obviously enjoy good wines, and you want to evaluate your wines 
when you drink them, and keep a permanent record of your evaluations.  
WINE CELLAR is ideal for storing and updating records on your wines, and 
more importantly, for searching and printing your records.  With WINE 
CELLAR you can search for any of the data fields, e.g., variety of wine, 
color, vintage year, winery, etc. (see below for a list of all fields), 
and print them to the screen or to a printer.  The statistics for your 
search (e.g., how many bottles found, total cost, etc. will also be 
printed, or you can print the statistics for a search ONLY.  You can also 
print out the wine list by number (all or part of the list).  Before a 
party, just consult your own Wine List, and make the appropriate 
selection.

	The data fields and their sizes are:

			  Name of Winery  (30 spaces)
			  Variety of Wine  (30 spaces)
			  Color of Wine (R/W/B/RO)  (2 spaces)
			  Vintage Year (as 85)  (2 spaces)
			  In Cellar? (Y/N)  (1 space)
			  Where Grown  (25 spaces)
			  Where Bottled  (25 spaces)
			  Cost (as 99.99)  (5 spaces)
			  Percent Alcohol (as 12.5)  (4 spaces)
			  Date in Cellar (as ??-??-YY)  (8 spaces)
			  Comments  (78 spaces)       (Total spaces: 210)

	A sample printout for WINE CELLAR is listed below.   The first listing 
is the wine bottle number (automatically assigned by the computer), the 
remaining listings are for the data fields listed above.  [The "??" in the 
date field means to enter the style of date that you want.]


104  HEITZ CELLARS                 CABERNET SAUVIGNON            R   67 N
MARTHA'S VINEYARD      ST. HELENA, CA             $8.50   12.5%  06-26-81
08-27-85, GOOD NOSE, ASTRINGENT, FULL BODIED, EXCELLENT


	If there is some item of information about a wine that you want to 
save, but it is not listed above as one of the data-field names, you can 
enter it in the COMMENTS line.  The SEARCH routine will find it there.

	There are many ways to organize a WINE CELLAR, so let us explain how 
this one is organized.  Each bottle of wine is numbered consecutively.  
Use permanent label tape or adhesive tape and a waterproof marker pen, and 
label BOTH ends of each bottle, then you will still have a number on the 
bottle when you remove the cork.  You don't have to enter these numbers 
into the computer, because the computer keeps track of the numbers for 
you.


                                    1-1
	After you drink a bottle of wine, write down the DATE and your 
COMMENTS on that wine so that you can enter this information into the 
computer when convenient.  At that time you will also change data field 
"In Cellar? (Y/N)" from  "Y"  to  "N", i.e., the wine is no longer in your 
cellar.

	Since all of the wines are numbered consecutively, as you drink up 
wines you will need to occasionally move your wine bottles up to the front 
of the line to fill the spaces in your cellar so that you can buy more 
wines.

	There may be an interim time when you don't want to reposition all of 
your wines to fill in the gaps in your cellar, but you need to put new 
wines in your cellar.  If you have a cellar with neat columns and rows you 
can label the columns with letters and the rows with numbers (as in a 
spreadsheet).  Then, for example, you can put your new wine No. 605 in 
slot A5, and then enter  A5  in the COMMENTS line for wine No. 605.  Now 
when you print out the listing for wine No. 605 you will see that it is 
located in slot  A5.  When time permits, you can reposition your wines to 
be in proper numerical order.

	WHAT IF YOU HAVE 200 BOTTLES OF ONE WINE?  Sometimes you may buy ten 
or twenty cases of an excellent "every day" wine, and you don't want to 
enter every bottle of this wine into WINE CELLAR.  We suggest that you 
just enter a bottle into WINE CELLAR each time that you want to enter your 
tasting comments, e.g., after drinking the first bottle, and again some 
months later if your tasting notes change as the wine improves with age.  
You can keep track of how many bottles of this wine are left in your 
cellar by putting this number on the COMMENTS line of the first entry, and 
correcting this number as needed.

	WINE CELLAR holds the information on 100 wines in each data file 
(called WC1.DAT, WC2.DAT, etc.).  Each full data file requires 21,000 
bytes of disk memory.  The WINE CELLAR program (WC.EXE) uses 105,156 
bytes.  There are two small data files generated by the program. 
WCTOTCLR.DAT (21 bytes) keeps track of the total number of wines on file, 
the date the last entry or correction was made, and the color choices for 
your monitor.  WCVARIAB.DAT (121 bytes) stores the variables needed for 
searching multiple files.  A double-sided, double-density disk holds 
362,496 bytes.  Therefore, on a floppy disk you can hold the above working 
files plus 11 data files on your wines, or a total of 1100 wines on a 
disk.  If you have more wines than this, you will need to install WINE 
CELLAR on a hard disk, where the number of records that you can store on 
your wines is almost unlimited.  Alternatively, you can start a second 
floppy disk and start numbering your new wines from 1-1100 again, perhaps 
using a different color for the labels for numbering your new wines.








                                    1-2
CHAPTER 2. GETTING STARTED WITH WINE CELLAR 2


(1) SYSTEM REQUIREMENTS.

	IBM PC/XT/AT and PS/2 and compatibles.
	Any monitor (color or monochrome).
	Any printer.
	A hard disk or a 3.5 inch disk is required for a large wine cellar.
	DOS 2.1 or higher; 512K RAM.

(2) CONTENTS OF THE DISTRIBUTION DISK

	WC.EXE  		WINE CELLAR program.

	WC1.DAT		Sample Data file for you to play with.  You
			                should make a copy of the Distribution Disk 
                              before playing with the data, however.

	WCTOTCLR.DAT	Data file for total number of wines on file,
				the date the last entry was made,
				and the color choices for your monitor.

	CONV152.EXE	Conversion program for people with Version 
				1.52.  This converts the old data to the 
				new format for Version 2.0 (see CHAPTER 9).

	WCMAN.TXT		Manual for WINE CELLAR (17 pages).  At the
			                DOS prompt type: PRINT WCMAN.TXT <RETURN>.

	LJMARGIN.EXE              Program to set the left margin on a LaserJet 
                              printer (see CHAPTER 10).



NOTE: You only need to copy WC.EXE to use for your own wines.
	  WC.EXE creates its own data files automatically (see below).



(3) MAKE A WORKING COPY OF WINE CELLAR

	USING A FLOPPY DISK.  Prepare a specially formatted disk in drive B 
that carries the COMMAND.COM (e.g., with a DOS disk in drive A type: 
FORMAT B: /S).  For more information on formatting disks, see your DOS 
Manual.

	Copy your new WINE CELLAR program (WC.EXE) from drive A to your 
formatted disk in drive B; type: COPY A:WC.EXE B: <RETURN>.  Put your 
distribution disk away in a safe place.  Put your copy of WINE CELLAR in 
drive A, and reboot the system (press <Ctrl><Alt><Del> all at once).  When 
you see  A:> , type:  WC  <RETURN>, and WINE CELLAR will run.


                                    2-1
	USING A HARD DISK.  For those who want to run WINE CELLAR on a hard 
disk, first set up a special subdirectory, e.g., from the root directory 
(type CD\ <RETURN>) type MD\WC <RETURN> to make a subdirectory named  WC.  
Then type CD\WC <RETURN> to enter your new WC subdirectory.

	To transfer your new WINE CELLAR program to your hard disk, put your 
WINE CELLAR distribution disk in drive A, and type:  COPY A:WC.EXE C: 
<RETURN>.  Now type:  WC <RETURN> and WINE CELLAR will run.














































                                    2-2
CHAPTER 3.  MAIN MENU


	The Main Menu shows how many wines are listed in your WINE CELLAR data 
files, and the date on which the files were last updated.  The current 
date and time are also displayed.

	You are asked to select what you want to do:

			<E>nter WINES?
			<C>orrect RECORDS?
			<S>earch RECORDS?
			<P>rint RECORDS by NUMBER?
			Se<T> COLOR?

			<Q>uit?




NOTE:  You can either use the single key-stroke letters in the brackets to
       make your menu selections, or you can use the up and down arrows to
       make your selection with the colored bars, and then hit <RETURN> to
       activate your selection.




	If you want to display or print records on specific numbered bottles 
of wine, then select <P>rint RECORDS by NUMBER. 

	If you want to display or print records on wines selected by any other 
criterion, then select <S>earch RECORDS.

	If you have a color monitor, use the Se<T> COLOR routine to set the 
colors for your monitor.


















                                    3-1
CHAPTER 4.  ENTER DATA ON YOUR WINES


	You are shown the number to use for your next bottle of wine.

	When you enter data, the number of spaces available is shown.  The 
Line Editor prevents you from entering more data than permitted in each 
data field.

All entries of letters are automatically converted to capital letters.  
Some of the data fields permit the entry of any keyboard character, some 
data fields permit only numbers plus a period and a minus sign, one field 
allows only numbers, one field allows only letters, and one field allows 
only the letters "Y" and "N" to be entered.  If you press an incorrect key 
you will hear a "BEEP", and no entry will be shown on the screen.

Several special keys are activated to help you edit your entries:

		<RETURN>  or  <Down Arrow> -  Save entry as shown
		<Up Arrow>                 -  Move to previous lines
		<Esc>                      -  Restore original text
		<Left Arrow>               -  Jump left one character
		<Right Arrow>              -  Jump right one character
		<Ctrl>  <Left Arrow>       -  Jump to front of line
		<Ctrl>  <Right Arrow>      -  Jump to end of line
		<Ins>                      -  Toggle Insert ON/OFF
		<Del>  or  <BACKSPACE>     -  Delete current character


	For the color of the wine, R = red; W = white; B = blush; and RO = 
rose.

	ENTERING A CASE OF WINE.  When entering a case of wine, you certainly 
don't want to type everything over 12 times, and with WINE CELLAR you 
don't have to.  WINE CELLAR has a repeat feature.  After you type in all 
the information for the first bottle of wine, you will be shown the number 
for the next bottle of wine and will be asked to enter the Name Of The 
Winery.  Since it is the same as the winery just entered for the previous 
bottle, just key  <Alt><R> and the entry for the previous bottle of wine 
will be repeated for the current bottle of wine, and will be displayed on 
the screen.  Continue this process for the rest of the entries for that 
case of wine. 


[NOTE:  The  <Alt><R>  keys will not work on the first entry of new 
session of entering data.  These keys just work on the second and 
subsequent entries of a given session.  Also, <Alt><R> will not work for 
the first entry if you fill a data file of 100 wines while entering a case 
of wine, and start a new file.]





                                    4-1
	Why do you need 12 entries for a case of wine?  First, you need to 
keep track of how many bottles you have on hand, and second, the COMMENTS 
on the different bottles of wine in the case may change with time.  For 
example, the COMMENTS for the first bottle of the case may suggest that 
the wine needs more aging before you drink the second bottle, and your 
COMMENTS will probably continue to change as the wine matures.  [See Page 
1-2 if you have more than just one or two cases of the same wine.]

	If you want to make more comments than the 78-space COMMENTS line will 
hold, you can set up an abbreviation code system.  You could assign 
numbers to mean different things, for example, the number "1" could mean 
"crisp", the number "2" could mean "sweet", etc.  You would type in these 
numbers surrounded by asterisks, e.g., *1*4*13*22*44*.  Then your search 
string would be a number surrounded by asterisks, for example, *11* .  By 
entering asterisks and searching with asterisks, the computer can 
distinguish, for example, between "1" and "11".

	After you have entered all of your wines into WINE CELLAR, we suggest 
that you print out a total list of your wines (use the <P>rint RECORDS by 
NUMBER routine).  Then print out a SEARCH for your wines by their color as 
a handy list for selecting your next wine to drink.

	Actually, you will probably find that you will use these "hard copies" 
more frequently than you will use your computer.  The computer will be 
used mostly for updating your WINE CELLAR (i.e., adding new wines, and 
comments on the wines that you have drunk, etc.), for performing special 
searches, and for impressing your friends.



























                                    4-2
CHAPTER 5.  CORRECT YOUR WINE LIST


	The screen shows how many wines are on file.  Then you are asked to 
enter the number of the wine that you want to correct.  The computer then 
loads the correct file, and displays the record for the wine whose number 
you have selected.

	The cursor is automatically positioned on the "In Cellar?  (Y/N)" 
field, since the most frequent corrections that you will make will be to 
change this field from "Y" to "N", and to enter your COMMENTS after you 
have enjoyed your wine.  If you mess up a correction, just key  <Esc>  and 
the original entry will be restored so that you can try again.  If you 
missed a line, just use the  <Up Arrow>  key to get back to the line that 
you want to correct.  Then use  <RETURN>  or  <Down Arrow> to get back 
down the list.

	"<Alt><D>" is shown on the screen by the line for COMMENTS.  These 
keys can be used to add today's date to the COMMENTS line if you wish.

	After you have gone through all of the data fields for that wine, you 
will be asked if you want to correct another record in that same file of 
100 wines.  If the answer is  YES, you will again be asked to specify the 
number of the wine to be corrected.  If the answer is  NO, then your 
corrected records will be saved, and you will be returned to the Main 
Menu.




























                                    5-1
CHAPTER 6.  DELETE LISTINGS FOR YOUR WINES


	Since WINE CELLAR is set up to be a permanent record of your wine 
experience, there is no direct provision for deleting a record from the 
computer.  However, what do you do if you break a bottle of wine before 
you have a chance to drink it?  We hope that this doesn't happen, but if 
you do need to delete a wine, just use the CORRECT routine and delete the 
data in each field.  The wine number will be saved so that you can enter 
another wine for this number by again using the CORRECT routine to add the 
new information.











































                                    6-1
CHAPTER 7.  SEARCH YOUR WINE CELLAR


	The first menu of the <S>earch RECORDS routine asks you to choose 
whether you want to display the results of your search on the computer 
screen or to print your search on your printer.  Just make the appropriate 
entry.

	Then you are told how many wines are on file, and how many data files 
there are (N.B., There are 100 wines per data file).  You are then asked 
to choose which file you want your search to start with.   After you have 
enjoyed the first 100 bottles of wine, you may not want the computer to 
search through these older records each time.  This is why you are allowed 
to specify which data file to start the search with.

	Then you are shown a list of all the data fields, and are asked to 
select which data field you want to search on (e.g., Name of Winery, 
Variety of Wine, Color of Wine, etc.)

	Then you are asked to enter your SEARCH STRING (i.e., the word or 
phrase to be searched for).  If the search string contains more than one 
word, e.g., PINOT NOIR, then put a slash (/) between each word instead of 
a space, e.g., PINOT/NOIR.

	Be very specific in choosing your search string.  If you just type in 
a partial name the computer will find it.  For example, if you just type  
PINOT  for the Variety Of Wine, the computer will print out all of your 
PINOT NOIRs as well as your PINOT BLANCs.  Obviously, the more restrictive 
that the search string is the more exact and the faster your search will 
be.  Yes, a large search string will be found faster than a small one.

	Then you are asked if the search is to be only among the wines that 
are currently in your cellar, or among the wines that you have already 
enjoyed (i.e., listed in the computer, but no longer in your wine cellar), 
or do you want to search through all of your wines, past and present.

	Then you are asked if you want to show ONLY the statistics of the 
search.  The statistics are:

	Begin Search With File #:
			 Search String:
		 No. of Wines Found:
	     Cost of Wines Found:
   No. of Wines with no Cost:
		     Date of Search:                In Cellar / Not In / All

	The search then begins, and you are shown which File No. is currently 
being searched.  When a wine is found that matches your search string, it 
will either be displayed on the screen or printed on the printer, as you 
selected.




                                    7-1
	Five wines are displayed on the screen at a time, and you are given 
the choice of continuing the display on the screen (key  <RETURN> ) or of 
returning to the Main Menu (type: M  <RETURN>).


	The SEARCH STATISTICS are printed at the end of the list of wines 
found in your search, or if you choose STATISTICS ONLY, the wines won't be 
shown, but the statistics will.


	If the computer doesn't find what you are searching for it will show 
on the screen  *** NOT FOUND ***,  DID YOU TYPE IN THE SEARCH STRING 
CORRECTLY?  You might want to try entering your search string again.


	If you need to stop the printer, just turn it off.  In a few moments 
the computer screen will show "Device time out ----"   "Hit any key to 
return to system".  Just hit any key, and then type  WC  <RETURN>, and the 
WINE CELLAR program will restart.



































                                    7-2
CHAPTER 8.  PRINT A LIST OF YOUR WINES BY NUMBER


	S_a_m_p_l_e_ _P_r_i_n_t_o_u_t_:  

104  HEITZ CELLARS                 CABERNET SAUVIGNON            R   67 N
MARTHA'S VINEYARD      ST. HELENA, CA            $8.50    12.5%  06-06-81
8/27/85, GOOD NOSE, ASTRINGENT, FULL BODIED, EXCELLENT

	For an explanation of the various data fields, see Page 1-1.


	The <P>rint RECORDS by NUMBER routine is especially useful when you 
want to print a partial list of wines, e.g., the wines that you just 
finished entering (e.g., wines 70 - 85) so that you can check for 
typographical errors, etc.

	If you want to print the record for a certain bottle number, or the 
records for a group of bottle numbers, then use the <P>rint RECORDS by 
NUMBER routine.  If you want to locate wines by any other criterion and 
display/print a list, then use the <S>earch RECORDS routine (see CHAPTER 
7).

	The first Menu of the <P>rint RECORDS by NUMBER routine asks if you 
want to display your list of wines on the screen, or to print it on your 
printer.  If the latter, the screen warns you to turn on your printer.  
The printed list will also show the date that the list was printed.

	Your are then asked to specify which wines are to be printed.  You are 
asked to enter the number of the wine to be printed first, and then are 
asked to enter the number of the wine to be printed last.

	If you only want to print the record on one bottle of wine, then enter 
that number twice, i.e., both for the number of the wine to be printed 
first and last.

	If you specified that you wanted the wines displayed on the screen, 
five wines at a time will be shown.  You can continue the display by 
keying  <RETURN> , or you can return to the Main Menu by typing: M 
<RETURN>.

	If you want to stop the printer, just turn it off.  In a few moments 
the computer screen will show "Device time out ----"   "Hit any key to 
return to system".  Just hit any key, and then type  WC  <RETURN>, and the 
WINE CELLAR program will restart.









                                    8-1
CHAPTER 9.  CONVERTING DATA FROM VERSION 1.52 TO VERSION 2.0


FIRST, back up your Version 1.52 data files.

Then copy CONV152.EXE to your WC subdirectory or disk, and type:
	CONV152 <RETURN>, and convert your data.

Now delete CONV152.EXE from your subdirectory or disk, and also delete the 
data file called WCTOTDAT.DAT.

Now copy WC.EXE to your subdirectory or disk, and you are ready to use 
Version 2 of WINE CELLAR.  Just type  WC <RETURN> .









































                                    9-1
CHAPTER 10.  PRINTING ON A LASERJET PRINTER


	(1.)  Select an appropriate font by whatever means that you have at 
your disposal.  A font with 12 letters per inch gives a nicer looking 
printout than does 10 letters per inch, and leaves enough margin so that 
the paper can be punched for a notebook.

	(2.)  Set the printer to 60 lines per page (use the buttons on the 
front panel of the printer).

	(3.)  To set the left margin on your LaserJet, run the program 
included on your Distribution Disk called LJMARGIN.EXE.  From the DOS 
prompt, type:  LJMARGIN  <RETURN> .  [NOTE:  Your printer must be ON when 
you run LJMARGIN, otherwise your computer will "freeze".]  A left margin 
of 10 spaces looks nice if your font has 12 letters per inch, but suit 
yourself.  To return the printer to the default left margin, either run 
LJMARGIN again and set the margin to zero, or just turn off the printer 
and turn it on again (this action also erases soft fonts, however).



































                                   10-1
CHAPTER 11.  SUBJECT INDEX


Abbreviation Codes For COMMENTS .....................................  4-2

Contents of the Distribution Disk ...................................  2-1

Converting Data From Version 1.52 to Version 2.0 ....................  9-1

Correct Your Wine List ..............................................  5-1

Data Fields Defined .................................................  1-1

Delete Listings For Your Wines ......................................  6-1

Enter Data on Your Wines ............................................  4-1

Entering a Case of Wine .............................................  4-1

Floppy Disk (using a) ...............................................  2-1

Getting Started with WINE CELLAR 2 ..................................  2-1

Hard Disk (using a) .................................................  2-2

How Many Wines Will WINE CELLAR Hold? ...............................  1-2

Line Editor Explained ...............................................  4-1

Main Menu ...........................................................  3-1

Make a Working Copy of WINE CELLAR ..................................  2-1

Organizing Your Own Wine Cellar .....................................  1-1

Print a List of Your Wines by Number ................................  8-1

Printing on a LaserJet Printer ...................................... 10-1

Repeating Entries in WINE CELLAR ....................................  4-1

Sample Printout of WINE CELLAR .................................. 1-1, 8-1

Search Your Wine Cellar .............................................  7-1

Statistics for Your Searches ........................................  7-1

Stopping Your Printer ........................................... 7-1, 8-1

System Requirements .................................................  2-1

What if You Break a Bottle of Wine? .................................  6-1

What if You Have 200 Bottles of One Wine? ...........................  1-2
                                   11-1
