Metal pricing from Kitco.com is provided in the GemGuide Appraisal Software in the Daily Exchange and Metal Rates window that displays the first time the GAS software is opened for the day. If you need to change any rates during the day, go to System Functions>Change Daily Rates in the main menu of the GAS software.

In the Reports section across the top of the screen, select Export Customer File/Mail Merge. Select all customers or a select group of customers such as those that have old appraisals in need of updating. You can then do a mail merge to a document for mailing letters to your clients. Options include opening the selected clients in an excel spreadsheet or a Word mail merge feature. The templates for labels and letters have been provided by the GemGuide Appraisal software. For detailed instructions, please click on the following link.
This is a handy tip for your busy season: how to print multiple appraisals for a client. From the Add New/Edit Appraisal Information screen, locate the list of appraisal numbers at the top left. Click on the blank box to the left of the appraisal numbers to select appraisals for printing. An “X” can be viewed for the appraisals selected. When all the reports you would like to print are selected, click the Print button under Appraisal Actions. Note: the appraisals will print in the order you select them.
The second method is far more secure and you do not need to export it to Word Processing. You will need a PDF printer driver installed. These PDF writers are very inexpensive software options. You can check out one called Cute PDF at www.cutepdf.com. This software sells for only $49.95. Once installed, when you go to print the appraisal, select the PDF printer and the document will be converted to a PDF file. PDF readers are free with computers so when you attach the PDF file with the email, the recipient will be able to open, view, and print the document but will not be able to alter it. (Note: some PDF’s can be altered but it is much more difficult.)
If you are currently using Win 7 or Vista and receive and error message with error code 21 after updating the pricing, please follow the directions below to correct this error.
1. Go to windows Explorer (the folder icon on your task bar at the bottom right of your desktop) or Start>Computer.
2. Click on Computer in the left hand column of the screen, then click on Disk C to view contents of the local disk drive.
3. Find the GASWIN folder and double click to open. Find the file named "fileupd.exe" and delete it. You might not be able to view the extension "exe, this is OK.
4. RE-download the pricing files as noted below, but NOT within the GAS program. You need to update the pricing via our website.
UPDATE PRICING VIA WEBSITE:
- Go to http://www.gemguide.com/login.htm
- Enter username and password
- Id: guide
- Password: (current password)
- Go to the UPDATE PRICING section of the current web page. In the first row, middle column, Click on the Update Pricing for Vista and Win 7 Users and Run the file.
- A window with an explanation of the unzip path location will appear. Click on OK.
- A small unzip window will appear. The default location to unzip the pricing files is C:\GASWIN\DATA007. If your dataset is in a different location, change the location by clicking on the Browse button and selecting the correct data folder name, i.e. E:\GASWIN\Data007, C:\JJWIN\Data007, or C:\Program Files\GASWIN\Data007.
- Click on Unzip to save the new pricing files to the location of your current dataset.
- Open the GemGuide Appraisal Software, go to System Functions>System Status. Check the Current Pricing Data under Miscellaneous Information to verify the prices have been updated.
Version 2.06: You can print up to 2 photos or images on one appraisal. You have the option to select more than two images for your reference for each appraisal item. For complete instructions on selecting images for an appraisal click on the following link: Multiple Photo Selection. If you need to print more than 2 photos, please refer to the instructions for version 2.05a or less below.
Versions 2.05a or less: When you are finished with the appraisal, select Print and then select Export to Word Processor. When you do this, the software will go to your word processing program, i.e., Microsoft Word and it will bring in the entire appraisal document with photo. From here, the options are endless. You can move the photo anywhere on the document. You can import more photos such as a side view and top view, you can combine items to a single page, you can import additional pages created elsewhere, etc. One caveat however, is that the grading report is still handled in our software as a separate document and cannot be exported to word processing. Again we stress that this option, while it creates tremendous flexibility, defeats the true purpose of the software which is to do the work for you. There will be some users that will insist on this option but we always teach editing as a "last resort" for those documents that must be refined in some way.
A credit card size report can be printed using the Print option under Appraisal Actions or by clicking the View/Print button when editing an appraisal. On the Appraisal Report Type Selection window click on Card Appraisal Report and then OK to Print Report. Microsoft Word will open and your card will be prepared using the template provided by the GemGuide Appraisal Software program.

For detailed instructions on editing the template, then creating, editing and the saving the individual credit card report, please click on the following link: Credit Card Report.
When you select Edited Appraisal Report, the function is the same as the previous edit features in that only text will appear for editing. It will first come in highlighted (blocked) and you can then place the cursor anywhere and make changes to the text, the spacing, the fonts, etc. This feature is a quick method for editing an appraisal and then allows you to go directly to print. Newly added to this version is an automatic reminder that the appraisal has been edited once you decide to use this feature for a report.
Technical support hours:
9am to 4pm (Central Time)
Monday through Friday
Please limit calls to questions pertaining to GAS only
Customer service hours:
9am to 5pm (Central Time)
Monday through Friday
Here is a great trick when using the tab key. As you tab through the various fields, you may need to go back to a previous field to edit an entry. Solution: hold down the shift key and hit the tab key. Your cursor will return to the previous field. While holding down the shift key, the tab key can be hit multiple times to keep moving back to the previous fields in the program.
Using the tab key to move forward and the shift + tab keys to move backwards is the easiest, fastest, and preferred way to navigate the GemGuide Appraisal Software. Try it today. It will make a difference.
Select "No Specific Species" for your species and then "Other" for your variety, making sure you use the TAB key to move between the fields. An "Other Colored Stone Description" field will be displayed to use for entry of your colored stone. The stone description you enter in the Other Colored Stone Description field will be printed on the appraisal exactly as entered, so be mindful of capitalization and other font characteristics.
The Weight Override will automatically be checked as formulas are not provided for any stone selected with No Specific Species. Because weight cannot be calculated within the program, you must enter the weight of the stone manually. The Hue will display all colors available for selecting in the drop down list. Please note: NO pricing is available using No Specific Species.
For example, you have a White Zircon and do not have a stated or calculated weight. Select Blue Zircon and enter the stone measurements to get a stone calculated weight as the properties are the same for Blue and White Zircon. Then change the stone species to No
Specific Species>Other and enter White Zircon. The color White (number 35) will be contained in the drop down list for Hue when you use No Specific Species.
When your subscription is 30 days from expiration, GAS will remind you how many days are left. The message will appear every day when you open your program until you reauthorize. If it expires before you reauthorize or we are not available to assist you, do not be concerned. The program will continue to function normally with the exception that you must look up prices in the books and enter them in the program.
Please allow 7-10 days after you mail in your renewal before calling for authorization so we may process your order. For immediate authorization, please call in your renewal with a credit card. Also note that if you renew for multiple years, your GAS program’s pricing will be authorized for the same duration. Multi-year renewals will reduce how many times you need to call us for authorizations.
To view the status of your expiration date for The Guide pricing and the number of available appraisals, go to System Functions>System Status.
If it is inconvenient to call during business hours (M-F 8:30am to 5:00pm CST), please use the fax authorization request in the software. For more information on authorization routines, please see the GAS User Manual or email us at support@gemguide.com
By changing the Appraisal Type to Stone Only, the first button on the Appraisal Checklist becomes Stone Description. You can enter a brief description and/or background information on the strand or go directly to the Pearl Module to begin the appraisal.
Normally, the pearls make up the majority of the strand’s value. By changing the Appraisal Type, the pearls will be the primary valuation and the first entry on your appraisal, not the clasp- which is generally negligible. The clasp type can be entered in the Pearl Module. Click the Pearl button and enter the strand information in Detail Pearl Information. Select the clasp description under Type of Clasp.
Listing the clasp type is often more a matter of documentation than of valuation. If the clasp is heavy, ornate, or contains other stones, it should be listed separately under the Appraisal Type Mount and Stone.
An alternative is to use newer grading methods, such as those shown in The Guide Reference Manual. To enter alternative grading, skip the Pearl Grading tab and move to the Comments tab. Here, you can manually enter any grading information desired. This is especially helpful for pearl varieties such as Tahitian blacks when using a system such as Poema grading. In all these situations, be sure to manually overwrite the pricing.
Remember that throughout the GAS program, tab = calculate. Also, remember that you are always working with wholesale pricing until the final markup screen.
Here is how to change the date on an existing appraisal without altering your computer date. Select the appraisal. Click the Edit button under Appraisal Actions. At the bottom right of the screen, type in the new date. If you double click the date, a calendar will pop up for date selection.
Like customer and appraisal numbers, the stones you add to your appraisals are assigned numbers too. The stones on your appraisal print in the order they are entered. For example, if the ring you are appraising has a large sapphire as the center stone with two side diamonds and assorted melee, you would add the sapphire first, the side diamonds second, and the melee last. That way, the stones are listed both in order of importance and in the order you entered them.
GAS does not save a copy of the image with the appraisal-- it saves the location or path name of the image. GAS does not use imbedded images like other programs such as Microsoft Word. If the image is moved to another folder or deleted from your hard drive, GAS cannot view the image because it looks for the original path. If you delete an image, GAS knows where it used to be, but it cannot be found and loaded on your document. The location or path name is viewable at the lower right of your appraisal screen.
If you are working on an appraisal and select the wrong photo, you can simply click Select Image and reselect a different image. However, if you click the Delete Image button, you will be prompted by the question to remove it from your hard drive. If you click No, the image is removed from the appraisal only. If you click Yes, it is deleted from your computer; it does not go into the recycle bin. So if you click Yes, be very sure you no longer need the image.
You have two options. You can create a folder on your hard drive or network drive that has no spaces, i.e. C:\Appraisal_Photos or J:\CannonPictures. Or you can save your images in the preferred location-- your GemGuide Appraisal Software Photos folder. When you installed the program, a new folder was created: either GASWin or JJWin. In that folder you have a subfolder named Photos.
The path C:\GASWin\Photos, or C:\JJWin\Photos, contains no spaces, and will be read correctly when you select an image from it. Plus, you will always know that those images are for appraisals (versus inventory, catalogs, or website publishing).
Some programs may simply offer to save the image in the last place you selected. When you open the program and click Save to load appraisal photos on your computer, the camera software returns to the last place you selected. So, you would select your appraisal photo folder and save the images. The next time you open the camera software, the browser window will contain your previous saved location.
In other programs, you may have the option to select a default save location. It can often be found under Edit>Preferences, Tools>Options, Tools>Customize, or in a setup menu. Consult your camera software manual or help files for this option. Once you make that selection, whenever you save an image in your camera software, it will automatically return to your designated appraisal photos location-- saving you the hassle of reselecting that folder every time you want to save appraisal photos.
UPDATE PRICING VIA WEBSITE:
- Verify the location of your dataset, Open GAS and click on System Functions>System Status and look under Miscellaneous Information for the Current Data Directory. The default location on installation is C:\GASWIN\DATA007.
- Go to http://www.gemguide.com/login.htm
- Enter user name and password
- Id: guide
- Password: (current password)
- Go to the UPDATE PRICING section of the current web page. In the first row, middle column, click on the Update Pricing for Vista and Win 7 Users and Run the file.
- A window with an explanation of the unzip path location will appear. Click on OK.
- A small unzip window will appear. The default location to unzip the pricing files is C:\GASWIN\DATA007. If your dataset is in a different location, change the location by clicking on the Browse button and selecting the correct data folder name, i.e., E:\GASWIN\Data007, C:\JJWIN\Data007, or C:\Program Files\GASWIN\Data007.
- Click on Unzip to save the new pricing files to the location of your current dataset.
- Open the GemGuide Appraisal Software, go to System Functions>System Status. Check the Current Pricing Date under Miscellaneous Information to verify the prices have been updated.
Another useful feature in the print preview is the set of page navigation buttons, located to the top left of the print preview window. The single left and right arrows advance you one page backward or forward. The double left and right arrows advance you to the first or last page. The button with a page and right arrow will prompt you for the number of the page you would like to view; that is a handy feature in long, multi-item reports. The other buttons from left to right are—close window, print, and export to RTF.
In the mount description menu, under Jewelry Style, choose engagement. For Jewelry Type, choose ring & wedding band. These are already in your User Table supplied with the software. Of course, you can add any jewelry descriptions to the User Table. Now, the Selected Narrative to the right should read "engagement ring & wedding band." Continue filling in the other pertinent data. Now, in the Additional Narrative field, you may want to add your own detailed description, especially if there are diamonds in the band. A sample might read as follows: "...In the engagement ring, there are six diamonds and in the matching wedding band there are seven diamonds."
Close the mount description window. Click on the diamond symbol and add diamonds (or other gems) as needed. If all the diamonds are the same relative size, you can group them as one entry since you already detailed their distribution between the two rings in the Additional Narrative. Weigh the rings together as one unit. The finished appraisal will automatically read "Total Weight of Ring and Wedding Band..."
You may choose to include additional information at the bottom of the appraisal. This would be information such as the individual weights and/or values of the rings since only one total weight and one total value will be listed. This is optional. To do so, click the Comments button on your Appraisal Checklist and enter the information as you would like it to appear on the finished document.
Vinyl sleeves, designed to protect your appraisal documents while presenting a polished final product. They are clear on the front with a pocket for your business card. They are frosted on the backside. 100 $45.00 500 $175.00
Appraisal Covers, designed to staple your forms and then fold over in a tri-fold manner to hide the staples. Approximately 10 pages can fit in one cover depending on paper thickness. 100 $55.00 500 $210.00
Prices do not include shipping. FedEx ground charges apply. Illinois residents please add 9.25% sales tax.
MK Digital Direct recently introduced their new Gem E-Box. This affordable lightbox will render professional photographs and is compatible with any camera mount. The controlled lighting will ensure accurate color on diamonds, rubies, sapphires, and all colored gemstones.
The light box will make digital imaging faster, easier, and more professional. It has switches for different light sources: the LED lighting is best for diamonds while the halogen bulbs enhance colored stones. The lighted platform eliminates shadows and the special stands provided for rings, earrings, bracelets, etc., hold all jewelry types. The universal camera brackets will support any digital camera.
Besides the use for GAS, this complete system can also be used for producing catalogues, website images, inventory records, and repair take-in documentation. The system, complete with basic catalog software, is $495.00 (plus shipping). Please see MKDD's website www.mkdigitaldirect.com or contact us for purchase details.
The CD has several modules that are easily accessible from the main menu. The first module consists of entering a new customer's information and appraising a solitaire engagement ring, complete with grading report. Other appraisal modules include appraising a colored stone and diamond pendant, and a pearl strand. Users also have access to demonstrations of how to maintain and customize their program, including-- initial program set up, downloading and updating Guide pricing, authorizing appraisals and pricing. The CD's modules can be used an unlimited number of times, allowing one CD to train an entire store.
The CD is free to all current and new users. To obtain a copy of this CD, please send an email with the subject line "Training CD Request" containing the user's name & business name to mwatts@gemguide.com.
Before moving your Guide Appraisal Software to another computer, you need to be using the most current version of the GAS program, version 2.06a (Click on Help>About to view your current program version). If you are not on version 2.06a, upgrade your program on your computer by clicking on this link Upgrade to version 2.06a and RUN the upgrade program.
Back up for current data base on your old computer:
Open the GAS program, go to File>Backup/Restore>Backup. This will create a backup of the GAS data and system configurations in a zip file. The file is named GASBackup_current date.zip and will be stored on the external peripheral that you designate (Click on browse under option 2 in the Backup window and select your external peripheral such as a thumb drive or CD rom drive, the default is your C drive).
To restore you database to your new computer:
Install the Guide Appraisal Software on the new computer. You must have the CD or link for the current version 2.06a. Please email Support@GemGuide.com to receive the link to download the current version of GAS. Once you receive the link to install the program, click on Run.
To restore the file, open the GAS software on the new computer and click on Restore when the dataset cannot be found message is displayed. Click on browse in Option 1 and select the zip file you created using the backup feature on the old computer. Restore to the original location unless you have changed the install location when installing the GemGuide Appraisal Software to your new computer.
For Network users of the GemGuide Appraisal Software:
To install the Guide Appraisal Software on the client machines click on Run to install the program and install the program set only. When the program is opened for the first time, click on Restore when the dataset cannot be found message is displayed. Restore the backup instead of selecting a dataset and make sure to change the location for restoring to your server. For other client machines, when the GAS program is first opened, select the dataset from the server that was previously restored (or folder location of the data files). All updates to pricing, adding appraisals, and changes to any user tables or program preferences are made to the server or data set.
Change the disk drive in option 2 of the backup window to an external peripheral. Click on the Browse button, then select the CD rom drive, an external hard drive, or other peripheral recognized by your computer.
Click on Start to begin the backup.
If you are using the CD rom drive as your "save to" disk drive:
After the backup is complete, Windows will write the zip file to the CD Rom. (Windows may display a balloon in the lower right hand corner of your computer asking to "Write files to CD." You need to click on "Write files to CD" to complete the backup.)
Guide Appraisal Software is a Windows or PC based software product. To use this software on a Macintosh computer, the user must have Boot Camp software installed (available on new Mac computers). This allows the Mac computer to emulate the PC so any PC based program can operate on the Mac. You need to bootup or start the Mac computer in Boot Camp to use the PC mode and then reboot the computer to use the Macintosh software.
If Boot Camp is not an option for you, other programs such as PC Emulator, Fusion, Virtual PC or Parallels can be installed on a Mac to be able to run Guide Appraisal Software or any PC based program. These programs perform a similar function as the Boot Camp program provided by Macintosh, except the user can move between the PC and MAC mode without rebooting.
1. Click on System Functions, System File Updates, then click on the Update User Tables. Click on Appraisers under User Table Descriptions, then click on ADD and enter the name in the description field.
2. Click on System Functions, then System Setup Menu. Select the Appraiser name by clicking down on the arrow.
Follow the above steps to add in your Gemologist Title.
Customer Private Notes are a great way to remember pertinent information about your customer. It can be used to keep track of what you charged for their appointment or what is due to be paid at a follow up appointment. It can be used to record a potential problem with the client. You can enter in information to help recall the client from one appointment to the next and be able to ask them a question pertinent to them. And you said you had a bad memory.
Appraiser Notes are best used to make notes on a particular piece such as where it was actually purchased, what price was paid, etc. You can also keep track of a potential problem with the item or anything else out of the ordinary.
You are charged a "click" for an appraisal when you select Add under Appraisal Actions. You are also charged a click when you copy an appraisal. If you select to make 6 copies you are charged 6 clicks.
Your internal counter registers to -25 appraisals. This is built into the system in case you have to do numerous appraisals on a weekend or afterhours when we are unavailable. The next time you order appraisals, this negative number is deducted from the order in your internal counter.
1. Make a copy of the appraisal by choosing the Copy feature under Appraisal Actions. OR
2. Update the original appraisal by choosing the Edit feature under Appraisal Actions.
The advantage of the first method is that the original appraisal will still be available in the database for any future reference. However, you will now have two appraisals for the same item in the client's database and since the GAS software keeps a cumulative tally of the dollar values, this item will be added twice. This method will also cost you one more "click." Using the second method will not cost an additional click.
With either method you need to be aware of the following items that need updating.
1. Check the appraiser name and title. To change the appraiser name and/or title, simple use the pull-down menus on the Add New/Edit Appraisal Information screen.
2. Check the date located in the lower right hand corner of the Add New/Edit Appraisal Information screen and make any changes required.
3. Update the pricing for this appraisal.
-re-select the metal group under Mount Description and tab thru the carat, color and price per gram/penny weight.
-click on the pricing tab in the edit diamonds and colored stones window. The pricing window will show you the original selected price and you can choose from the new prices.
4. Proceed to the Mount Valuation and Markup. Click on Re-calculate. The appraisal value will re-calculate using the new pricing values that have been changed in the metal group and the diamond and colored stone modules.
Change the Appraisal Type to Stone Only on the appraisal. You have selected Mount and Stone which will print the metal price if you selected print metal price in the System Setup Menu.
1.) You need to rebuild your limiting conditions report to include the new changes in the program. Go to System Functions, System File Updates, Limiting Conditions and select the paragraphs that you want included in your limited conditions page. OR
2.) Send via e-mail the files limitcon.*, limitusr.*, and usrtbl.* located in your \JJWIN\Data folder to support@gemguide.com. The files will be updated and returned via e-mail to you. The new files can then be copied back into your \JJWIN\Data folder and you should be able to print you default limiting conditions report.
Yes, you can use any third-party backup software to backup your data for your appraisals. If your program and data are located in the default folders at installation, C:\GASWIN, simply add the GASWIN folder and all subfolders to your list in the third-party backup software.
You will also need to include the picture folder you currently use to save and select your images for your appraisals. The default folder for pictures is located in GASWIN\Photos, but the My Pictures folder is frequently used to save and select images. Make sure you also list any picture folders in your third-party backup software.
If you changed the folder name at installation or installed on a network scenario, you need to first determine the location of your dataset. Open the GemGuide Appraisal Software, click on System Functions>System Status. Find the "Current Data Directory" listed in the lower left hand corner of the System Status window (See below). This states the location of you dataset and the folder name you will need to list in the third-party backup software. You will also need to add the following configuration files: conf00X.dbf, conf00X.dbt, sysdata.ovl.

Another key change to the software is the addition of new GIA colored gemstone grading terminology. Previously, GIA used the same clarity scale for diamonds when grading colored gems. Now, the scales have been changed to more meaningful terms such as slightly included, moderately included, etc. All current terms are in this release.
As for diamonds, the new GIA cut grading system uses the following cut grades: excellent, very good, good, fair, and poor. The GemGuide has associated these new grades with premiums and discounts. The new pricing guidelines are coded into the software to improve accuracy of pricing. Since we have taken sole ownership of the software in 2002, more than 500 changes and improvements have been made!
Click on the following link to upgrade to Version 2.04*:
GemGuide Appraisal Software New Upgrade - Version 2.04
*Remember to backup your database before upgrading. This upgrade not applicable to Version 1.3.
The pricing is refreshed every minute and indicates whether the price has gone down, gone up, or stayed the same. With Kcast, there is no need to visit websites to check market activity. Kcast is not compatible with Windows 7. Visit
If you are using Windows 7 and have version 2.06a or earlier, you will need to update the pricing via the website at www.gemguide.com.
You must have a current GemGuide Pricing subscription to update your pricing. If you would like to renew or subscribe to the GemGuide Pricing, please call 888.436.4843 (888-GEMGUID).
![[Most Recent Quotes from www.kitco.com]](http://www.kitconet.com/images/sp_en_6.gif)
