|
ENHANCE23 R5 TIPS and FAQs
- How do I find out why my @DSUM
ENHANCE23 function returns ERR ?
- I have already upgraded to ENHANCE23 or Lotus
Millenium Edition. How can I use ENHANCE23?
- ENHANCE23 and Windows 95/98?
- Does ENHANCE23 support external (not in memory)
spreadsheet files?
- What are the limitations of
the @soundex add-in function?
- Can I combine @soundex and @TYPEX
add-in functions?
- How do I load and use ENHANCE23 ?
- How do I register ENHANCE23 ?
- How do I set up a
SmartIcon to start ENHANCE23 ?
- How do bring up Help for ENHANCE23 ?
- How do I use multiple
input database ranges in @D.. functions?
|
|
Simple with ENHANCE23 R5 loaded as an add-in to 123 R5 just type "?"
after the name of the @D.. function e.g.
Original Formula:
@DSUM(WIDGETS,"Sales",REGION="N")
Result: ERR
With ENHANCE23 activated: @DSUM?(WIDGETS,"Sales",REGION="N")
Result: ERROR: 3020
CRITERIA ARGUMENT "REGION="N"", has field component "REGION"
that matches a range with the same name in the current file. Add a range qualifier e.g.
RANGE.FIELD.
@D-Helper attempts to provide an answer to every type of ERR return from the
standard @D.. 123 database functions. There will be a small number of cases
where @D-Helper does not detect the reason for or existence of the error (@ERR) or
cases where a mistaken diagnosis is made, these need to be reported contact page for inclusion in upgrades.
|
|
2 I have already upgraded to Lotus 97 or Lotus
Millenium Edition. How can I use ENHANCE23?
Until the release of ENHANCE23 LS , it is possible to run two versions of 123
e.g. Release 5 and Release 97 or Millenium Edition. You can then save your spreadsheet
from Release 97 to Release 5 and then open the file in Release 5 apply ENHANCE23 and using the results in your original Release 97 spreadsheet. The
trick is to be sure to select a unique directory for the Release 97 installation (i.e. not
over the top of your Release 5 installation). To start your older version
of 123 set up an icon (shortcut) on the desktop pointing to its *.exe
(e.g. C:\LOTSUITE\123R5W\PROGRAMS\123W.EXE)
|
|
123 Release 4 and 5 can happily work under Windows 95 and Windows
98 (see above for details of how you can run 123 R5 with 123 R97 or Mill). ENHANCE23 works well in these conditions.
|
|
4 Does
ENHANCE23 support external (out of memory) spreadsheet files?
Yes the fully licensed version of ENHANCE23 R1.0 to
R1.5 and the free version R5 support out of memory spreadsheet files e.g.: even though the
file C:\WORK\TAXRATES.WK4 is not in memory the following @D-Helper
helper function will work.
@<<EN23>>DSUM?(<<C:\WORK\TAXRATES.WK4>>RATES,"Total",SALARY>50000)
|
|
The SOUNDEX sound alike test was first applied to the 1880 USA census as a means
of cataloging surnames in sound alike categories. The simple algorithm was amenable to
hand translation of surnames into soundex codes. Since then the computing world
(mainframes initially) took up the algorithm and it has been extensively used to provide
sound alike database lookups ever since. SOUNDEX is also extensively used in genealogy to
compare related names. See links for more history and usage.
The simple @soundex algorithm can be fooled for example using the 5
character soundex option:
STRING |
@SOUNDEX(STRING) |
Euler |
E4600 |
Ellery |
E4600 |
Gauss |
G2000 |
Ghosh |
G2000 |
Hilbert |
H4163 |
Heilbronn |
H4165 |
Knuth |
K5300 |
Kant |
K5300 |
Lloyd |
L3000 |
Ladd |
L3000 |
Lukasiewicz |
L2220 |
Lissajous |
L2220 |
In the above some of the like comparisons are dubious e.g. Lukasiewicz and
Lissajous or Knuth and Kant.
|
Yes there is a special function in ENHANCE23 @NEAR which performs both a
@SOUNDEX and an @TYPEX comparison e.g. @NEAR(NAME,"SMITH") where NAME is a range
name or database field name when used in a criteria formula.
|
The installation program will place the EN23.ADW file in the ..\programs\addins\
directory. So when you select
"Tools=>Addins=>Load" the "EN23" selection will load ENHANCE23 .
A splash logo picture will appear for 2 or 3 seconds with your license status. A new menu
item (Release 1.04+) will be on the e 123 main tool bar (after Help).
This item brings up an About dialog box. For older R1.05 it also enables
users to register their trial or full license. It also provides access to the add-in Help
file.
Load the test spreadsheet "EN23.WK4" in
"../programs/addins/ENHANCE23/" directory. This spreadsheet has typical usage of
all the ENHANCE23 add-in functions.
|
The ENHANCE23R5 add-in for 123 Release 5 is now free and does not need to be
registered.
|
The installation program will place a file EN23.bmp in the .\sheetico\ directory
this icon will be available to set as a ENHANCE23 start smarticon.
Select "Tools=>SmartIcons". Scroll to the bottom of the
"Available Icons" list box. You should find the new ENHANCE23 icon. Move it over
to the right list box (left mouse button down on top of the icon and drag across). You
don't need to select "EditIcon" as the installation program has set up a macro
for you already.
NB: 123 under Win95 can/will cause a "general protection fault: MAIN123W at
00d7:00000179" if you try to use "EditIcons".
|
The installation program will place a file EN23.hlp in the
\Programs\Addin\ENHANC23\ directory. Access to this is via the "About ENHANCE23"
item in the "Help" LOTUS123W menu item.
|
The purpose of having more than one input range in an @D... 123 database
function such as the one below is to perform a database join:
@DSUM(NORTH_SALARY,NAMES,"SALARY",NORTH_SALARY.NAME=NAMES.NAME#AND#NAMES.STATE="NY")
In the above the user wants to sum the "Salary" field in the
NORTH_SALARY database table but only where the employee comes from the state
"NY". The criteria argument links the two tables through the NAME filed. See the
example database table ranges below.
| NORTH_SALARY |
NAMES |
| NAME |
SALARY |
| J DOE |
1050 |
| F GUMP |
892 |
| B GOOD |
1100 |
| S FOO |
980 |
|
| NAME |
STATE |
| J DOE |
NY |
| F GUMP |
WA |
| B GOOD |
NY |
| S FOO |
WA |
|
A third column in the NORTH_SALARY table could have specified the STATE but so
would every other table in the organisation. By separating the data into a number of
smaller purpose specific tables you can save duplication throughout a large number of
tables and make it easier to modify the data for the organisation. In the above example if
J DOE moved to WA you would only have to modify the NAMES table!
For a join to work and not produce wild results you need to create a valid join
. In the above example 'NORTH_SALARY.NAME=NAMES.NAME'
this says "use both the NAMES and NORTH_SALARY tables and match up the NAME
field". Next you need to set up the specific criterion
#AND#NAMES.STATE="NY"
i.e. match names and pick only the "NY"
The summed field is "SALARY" which needs to be unique to both tables 123 will
find the right table but you can add a file qualifier if there is any doubt e.g.
"NORTH_SALARY.SALARY" NB: do not use a file qualifier i.e.
"<<C:\MYFILE.WK4>>NORTH_SALARY.SALARY" as 123 will not allow this in
the field specifier.
|
|
