EXCEL ADD ON SOFTWARE
for MS Excel 8.0...10.0, Office
97...2003.., Win 95,98 and WINNT, WIN2000,
XYFIT 453 Excel ADD-ON
This program offers many useful features like:
-least square fit of polynomial, logarithmic, exponential, fourier
-statistical data evaluation
-multiple cumulative distributions with fits
-multiple curves from 2 or 3 dimensional tables
-multilinear regressions to forecast and analyze complex
-easy table calculations
-Conversion of numbers with many
- Fast conversion of text date to real date
-Arrange charts and objects on a worksheet
..... and more useful tasks ......
It is a tool especially designed to help scientists, engineers and persons, who handle a
lot of data. Statistics is needed to specify test conditions, to
evaluate reliability, to find a system weakness. Xyfit 453 is designed
to perform these tasks.
An example are
Electronic devices, tested under different conditions. Each test parameter
shows a distribution, which is influenced by the sum of different input distributions and
internal parts and failures. Based on these distributions companies introduce test limits
and guarantee wider limits in their data sheets. But the knowledge of means, standard
deviations and failures is not enough and will not help to identify the weakness of a device. It is very important for
engineers to know, why and where do devices fail. How do they work in a different
environment. Are failures possible, which can pass the tests or creates the test
itself the problems. Do the tests have to be extended and what causes the failures of
unexpected distributions. Here XYFIT 453 helps with statistical data evaluation.
Utility contains 3 programs, one to load data files, text or a
ASCII file on the active worksheet cell. Different files can be loaded on the same sheet.
Lines that contain a key word can be extracted from these files. A second program
adjusts the curve to the axes. With a 3rd program charts can be copied and pasted on
a chart. The curves of the copied charts appear in one chart. It groups and
sizes charts to fit to a page or window. All programs are used for easy data
evaluation in the industry, labs and science.
compares two tables and finds the values matching the criteria defined by the user. A
first table range must be selected in a workbook and copied. In any workbook a second
table upper left cell must be selected and the compare icon pressed. The range of the
second table will be compared for the differences of the values matching the defined
criteria. The matching values change their color. Notes are inserted into the matching
cells with the percentage of gain and the date. Personal notes can be included. It is
ideal to find changes in financial and commercial tables. The content of the
cells of the table are not affected. Formats and Notes can be removed using the clear
format and clear notes command.
Arrange_chart is a tool for
everybody, who needs to display or print an array of charts or just one chart. Usually
they don't fit correctly to the screen or page or their size is different. To
professional looking print out of your charts use Arrange_chart, which does
all the work for
you. It recognizes also the zoom of a chart and organizes the charts exactly as they
Convert allows to multiply or divide all numbers selected in a
worksheet. Select a range or multiple ranges and click the Icon
"div". There are many other functions like trigonometric functions,
integer, absolute, square root, power, 1/x, exponential, logarithmic, which convert the
selected numbers. Formulae, text and all non constants are ignored. Convert is
used to convert large financial currency tables into other currencies within a few
let the user define the size and the length of the axes of a chart or object and how
to group the charts sorted in the X,Y-direction, space and number of columns. The values
of an arrangement can be stored and reloaded at any time..
Copy_Special copies only
values, text, formulae, formats. It corresponds to the Excel "Goto"
dialog. Using this command is easier than browsing through the EXCEL menus.
Calculus is a macro for children 's exercise in
Math.( Addition, Subtraction, Multiplication and Division) . The
range of the numbers can be
defined. The child can use numbers up to 10, 100 .... more, to test his or her
FMEA creates a "Potential Failure Mode and Effects
Analysis" for product developments in the industry. Two macros
are included with a ranking by a RPN number and one ( FMEA2.XLA)
with a ranking of expected costs.
Scale adjusts the minimum values of the x and y axis to
the minimum points of a selected curve. The maximum values still are controlled by
Excel. The crossing of the x and y axis is also set to the minimum values.
Select a curve and click the Icon Scale.