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 . 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: . Put your distribution disk away in a safe place. Put your copy of WINE CELLAR in drive A, and reboot the system (press all at once). When you see A:> , type: WC , 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\ ) type MD\WC to make a subdirectory named WC. Then type CD\WC 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: . Now type: WC 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: nter WINES? orrect RECORDS? earch RECORDS?

rint RECORDS by NUMBER? Se COLOR? 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 to activate your selection. If you want to display or print records on specific numbered bottles of wine, then select

rint RECORDS by NUMBER. If you want to display or print records on wines selected by any other criterion, then select earch RECORDS. If you have a color monitor, use the Se 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: or - Save entry as shown - Move to previous lines - Restore original text - Jump left one character - Jump right one character - Jump to front of line - Jump to end of line - Toggle Insert ON/OFF or - 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 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 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, 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

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 and the original entry will be restored so that you can try again. If you missed a line, just use the key to get back to the line that you want to correct. Then use or to get back down the list. "" 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 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 ) or of returning to the Main Menu (type: M ). 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 , 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

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

rint RECORDS by NUMBER routine. If you want to locate wines by any other criterion and display/print a list, then use the earch RECORDS routine (see CHAPTER 7). The first Menu of the

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 , or you can return to the Main Menu by typing: M . 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 , 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 , 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 . 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 . [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