Navigation:
ProControl® 6.1
en Español
in DeutschStatistics in Excel for Laboratories and Industry
Validation, Calibration, Trend Analysis and Forecasting, Uncertainty in Measurements
Validation, Calibration, Trend Analysis and Forecasting, Uncertainty in Measurements
| Highlights of ProControl® features and performance: | ||
| • | New: ProControl®-AtOnce, Version 6.1 is available from now on. ProControl withProControl-Ribbon Bars - in Excel 12.0 but still compatible down to Excel 8.0. Stability or Calibration, Spiking and Forecasting: One single click guides you to results. ProControl includes the risk in estimations and specifies the uncertainty in measurements (GUM). A flash trailer evaluating trends will soon be published in english, not only introducing the ProControl®-Ribbon Bar. | |
| • | NEW: Quality Control Charts in ProControl®6.1LE-Limited Edition Overview: Functions & Features and command buttons in ProControl® 14-Days-Trial-Version order for free. | |
| • | It's a unique feature: Trend analysis, forecasts, extrapolation evaluation of stability data, shelf life prediction (compliant to ICH-guidelines Q1D, Q1E) Command bars and dialogues guide you to the appropriate result. | |
| ... to prove a trend significant, describe and predict.. Why you shouldn't try a prognosis of your business characteristics either? We provide a film trailer (no. 9) "evaluation and prediction of shelf life" free to download. In spite of the excel-surface in german, the trailer will provide a good impression about the evaluations to proceed. more information in german language: Abstract of a presentation at InCom 2003.... Why do real measurements won't care about ICH Q1e-guidance?... | ||
| • | It's a world debut: quantifying concentration of unknown samples by adding calibration standards of
ascending
concentrations is supported, evaluation of uncertainty included | |
| ProControl requires your input of signal value '0'
(zero) and reports instantly the result and, more important, the uncertainty. Charts of calibration and residual functions make it clear and easy to understand. | ||
| • | It's our customer's decision: enhanced guarantee of compatibility ProControl®proves compatible to all (!!) Excel versions at the market. i.e. 12.0/ 11.0/ 10.0 / 9.0 / 8.0 We do think, our customers should keep all power of decision for any software update. | |
| • | It's an example of additional modules (Add-Ons): Statistics compliant to AOAC guidances for interlaboratory studies and
proficiency
testings ProControl®add-on on your demand provides statistical methods compliant to guidances of AOAC - Association of Analytical Communities, thus completing results of the standard version compliant to ISO 5725 . |  |
| Standard features of ProControl® 6.1 | ||
| • | Statistical tests and characteristics compliant to DIN and ISO standards | |
| Excel standard worksheets provide the statistical evaluations of your
data. ProControl®is compatible to all currently available Excel versions. | ||
| • | Interactive procedures, easy documentation of your results | |
| Dialogue fields guide you through the possibilities and options under MS-Excel. | ||
| • | Immediate control of your measuring results | |
| You type in a value and all calculations and results are immediately actualised. | ||
| • | Your advantage is an instant access and overviews to all characteristics. | |
| you immediately recognize and prove significant differences of results , series of inhomogeneous variances or outliers,.... | ||
| • | ....as well as comparing arithm. means, at no further requirements to variances' homogeneity and at no moment's hesitation... | |
| Differences of arithm. means are displayed whether variances are homogeneous or not | | |
| The excellence is -- only supported by ProControl®: | ||
| • | Prediction intervals ... | |
| ...show and tell you instantly the range of uncertainty, where you should expect reliable analytical results, reporting accuracy and precision by your first calibration already. | ||
| • | You get the results for uncertainty in measurements at the earliest time possible...... | |
| ... provided in standard excel worksheets as well as graphically displayed. Results are even provided for up to regressions of 4th. order, any weighting supported too. It needs just one touch on the appropriate button of ProControl command bars. | ||
| • | Only provided by ProControl, or where else? ... | |
| ...even some special statistics software use to focus only on evaluating the confidence intervals of the calibration function, whereas the much more essential estimation of uncertainty, which is surely well defined as the prediction interval, just gets neglected. | | |
| • | New and unique world wide : Trend analysis doesn't mean only extrapolation but uncertainty too. | |
| ... to prove a trend, describe it and extrapolate is not enough. In forecasting
,
ProControl includes the prediction limits too, thus providing the uncertainty of
forecasting.
... einen Trend signifikant nachweisen, beschreiben und extrapolieren -
Vorhersagebereiche eingeschlossen! You choose the presetting, whether it should be a limiting specification (value 'y') or limiting time (value 'x'), ... ProControl even provides to take any weighting into account. This way you get results of any forecasting at a calculated risk, that you define (1% or 5%). ProControl is validated software. Reliability to ISO and DIN standard results has been proved. Although there are no standard results available for linear regressions that exceed 2nd. order, we were able to prove traceability of the applied formulas to existing standard references. | ||
| Extended features for evaluating calibration characteristics. | ||
| • | Test for outliers of regressioncompliant to recommendations of DEV-documents (Deutsche- Einheits-Verfahren) | |
| To recognize and exclude outliers of the regression, where marking and eliminated outliers is justified, may avoid to encounter systematic deviations and errors of analytical results. | ||
| • | Regression models, any commonly justified weighting included | |
| Apply, as justified, provided options to choose regression order and weighting. Thus ProControl prevents you from evaluating wrong calibration characteristics, that just may arouse due to variability that was underestimated in your initial studies (inhomogeneity of variances). | ||
| • | Results displayed at your choice | |
| Characteristics of the regression, Method characteristics compared to DIN 32645-standard formulas applied, Analytical results including uncertainty, best regression model, on a statistical basis that meets your practice. | ||
| • | Results display graphically | |
| Current measurements, calibration function with confidence and prediction
limits, Residuals of all measured values explicitly, Confidence and prediction limits in a residual scale (ProControl residual chart) the analytical result, uncertainty in measurement included Limits of decision (limit of detection), confidence interval included | | |
| ProControl® 6.1 Demo download |
| ProControl® 6.1plus The solution for extensive data arising | ||
| • | On your demand we offer the extended version of ProControl, that supports input of up to 700 measurements, i.e. results in 35 columns and 20 rows. Whether data refer to your interlaboratory study, proficiency testing or pooled stability studies, ProControl® 6.1plus should enable you to evaluate the desired statistics. | |
| • | some examples in german language only, former version 2.0 (PDF file, approx. 860 KBytes) | • | more details for ProControl users | • | ordering form for desktop films and more excel sheets |
| Any questions, please contact for ProControlDr. Stefan Schömer |
