EXCEL ADD ON SOFTWARE
for MS Excel  8.0...10.0, Office 97...2003.., Win 95,98 and WINNT, WIN2000, WIN XP
Program description:

XYFIT 453 Excel ADD-ON
This program offers many useful features like:
-least square fit of polynomial, logarithmic, exponential, fourier fitting    
-statistical data evaluation 
-regression analysis
-multiple cumulative distributions with fits  
-statistical cleaning
-Weibull statistics
-multiple curves from 2 or 3 dimensional tables  
-multilinear regressions to forecast and analyze complex markets  
-polar coordinates  
 -easy table calculations
-Conversion of numbers with many functions
- 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.

Compare 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 receive a 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 should be.

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 seconds.

Size 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 skills.

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.