Preferred values can be selected according to the following criteria:

	The nearest preferred value to that specified.
	The pair of preferred values having the closest approximation to the required Ratio.
	The pair of preferred values having the closest approximation to the required Difference.
	Pairs of preferred values which, when placed in series or parallel provide the closest approximation to the required value.
	The preferred value required in parallel with an existing value to provide the closest approximation to the required value.

The following are two examples of the program's user interface and output: The program's output can be printed, saved or appended to a text file or copied (in part or in full) to the clipboard.
RVal also includes the facility to output a list of the values in the selected range.

You are welcome to download the latest version (2.00) of the program now (42KB). Installation is simply a matter of expanding the ZIP file into a directory of your choice.

For those who supply an e-mail address to which the licence details are to be sent, a free gift will be included consisting of an add-in for Excel that adds the functions VNearest() and HNearest(). These work in the same way as Excel's V/HLOOKUP() functions except that they return the nearest value, not the nearest below. Also included in this add-in are the functions MaxA() and MinA() which allow the lists passed to them to include alphabetic entries. Although now duplicated by Excel's own versions (they weren't at the time of their creation) my versions have the ability to return the index number of the maximum or minimum entry in the list and so still offer some value. They do not conflict with Excel's functions.

New in RVal V2.00:

1. User defined ranges - The file 'Ranges.ini' can be used to add your own ranges of values to the standard selection.
2. Save settings - The window size & position and your choice of Function, Range & Tolerance can now be saved at will or on program exit.
3. Values can now be entered in the form '1.23k' as well as '1k23'. This also applies to values in 'Ranges.ini'.
4. Improved completeness of results, e.g. Requesting the nearest value to 45 in the E24 range now lists 47 as well as 43.
5. Use of geometric errors where appropriate to improve the accuracy of the results.

Please note that I have changed the license key algorithm for v2.00 to overcome a weakness in the original. It is not my intention to cut-off existing users, so if you have an old license and I have not managed to get a new key to you please apply for a new key by emailing me giving your name and address as it appears in your RVal license.

New in RVal V1.12:

1. The program now behaves correctly on systems where the decimal point character has been defined as something other than '.'

New in RVal V1.11:

1. E192 range added.
2. User interface colours now obey system colour choice!

New in RVal V1.10:

1. Finding the preferred value required in parallel with an existing resistance to produce a desired value.
2. Support for E48 range now that some suppliers are providing this range.
3. Added the actual Ratio/Difference/Value to the Results display.
4. Various minor user interface improvements.
5. Asking for a value of 0 when requesting serial and parallel pairs used to hang the program.
6. Fixed a bug where some applications (e.g. Excel) sometimes failed to get RVal's data from the clipboard correctly.

This program has been written using Microsoft Visual Basic version 3.0, so it will run under 16 or 32 bit Windows operating systems (Windows 3.x or Windows 95/98/Me and NT/2000/XP). This version has been tested on Windows  Me, 2000 and XP. Previous versions were tested on Windows 3.1x, 95, 98 and NT 4.0.

If you do not already have the file "VBRun300.DLL" on your machine (probably in the "Windows\System" directory) then you will need to obtain a copy from Microsoft (226K). If that fails try searching the web for "VBrun300" or (as a last resort) e-mail me and I'll send you a copy.

An unregistered copy of RVal is fully functional and allows you to try it for a period of 30 days (it will disable access 60 days after you first execute it). The registration fee is £12 for a single licence with reductions for greater quantities. The fee can be paid directly to me at the postal address given in the program details or by using your credit card at:

I will take the licensee's details from the delivery address if it is different from the card holder's details. If this is not correct please give details in the 'comments to vendor' section of the order form.

If you wish to Suggest improvements or report any problems I will be pleased to hear from you.