SCA WorkBench

.... a companion product to the PC SCA Statistical System thatprovides forecasting and data analysis links to popular spreadsheets!

SCA WorkBench runs on MS Windows operating systems. SCA WorkBench uses high speed external DLLs and the latest Object Linking and Embedding (OLE) technology to control access to various spreadsheet, word processing, and utility programs from a central work area. SCA WorkBench provides an intuitive andeasy-to-use graphical user interface (GUI) for applications in time series analysis andforecasting. It also provides awesome features to benchmark model performance usingrolling forecasting techniques, handle large amounts of data through links to popularspreadsheets, automate analysis and forecasting procedures through task and projectgrouping, and much more. SCA WorkBench provides a convenient and easy to use application environments for several nonlinear modeling methods such as Multiple Adaptive Regression Splines (MARSPLINE), Generalized Additive Modeling (GAM), Alternating Conditional Expectations (ACE), and Projection Pursuit Regression (PPREG). The application environment provides a simple GUI to build models, compare results with a baseline linear model, holdout data for prediction performance, and view a variety of diagnostic tables and graphics. SCAB34S SPLINES module required. SCA WorkBench provides a flexible tool to extract data from databases and spreadhseet applications (e.g., Access, Excel, FoxPro, and tab-delimited file) into an SCA data macro using variable references or pass-through SQL language. SCA WorkBench enhances your ability to automate various analysis tasks through SCA macroprocedures. It provides a variety of utilities to organize macro procedures by task andgroup multiple tasks into a project. SCA WorkBench provides an internal mechanism to link an analysis task to a data source.This is a tremendous benefit if you manage your data in spreadsheets and require aconvenient way to access the data in the PC SCA System. SCA WorkBench provides a seamlesslink into Microsoft Excel, Lotus 1-2-3, Corel Quattro Pro, dBase, Clipper, FoxPro,as well as tab-delimited textfiles. Other data formats may be included in future updates. SCA WorkBench allows you to run an unlimited number of tasks in a session. If youspecify a data link with a spreadsheet, SCA WorkBench gives you the option to include anynew data in your spreadsheet before it runs the analysis task. This allows applicationsinvolving large numbers of data series to be handled easily within this general framework.Data may be maintained and managed directly in your spreadsheet avoiding the hassle ofupdating data in more than one data source. SCA WorkBench may be customized to handle a variety of decision support applications.If you have a need to automate a decision support application, contact SCA Consulting andSupport Services for more information. SCA WorkBench provides an intuitive and easy-to-use graphical user interface (GUI) tobuild ARIMA, transfer function and intervention models using an automatic time seriesmodeling or user-defined modeling environment. SCA WorkBench provides comprehensive features to benchmark time series models andevaluate forecasting performance using rolling forecasting. Also offers advancedcapabilities to evaluate forecasting performance in the presence of outliers. Variousperformance criteria available in rolling forecasting include standard and robustcalculations of root mean square error (RMSE); mean absolute percentage error (MAPE);mean absolute deviation (MAD); and and cumulative sum of errors (CUSUM). These results can thenbe exported to an Excel spreadsheet or standard text file. SCA WorkBench enhances connectivity between the PC SCA System and Microsoft Excel. SCAWorkBench allows you to write SCA results into a an Excel spreadsheet. SCA WorkBench now includes an automatic task and macro building capability. Using this feature, you can specify a master SCA macro file that is to be applied to all variables (or selected variables) in a data source. All tasks are then automatically organized in a project file that can then be executed in a batch manner. This capability also supports macro replication that allows users to define do loops in a master macro. As the tasks and macro files are being generated, the do loops defined in the master macro procedure automatically replicate (or expand) SCA commands. SCA WorkBench provides links to programs that are developed in the SCAB34S applet development environment. The SCAB34S product offers a comprehensive mathematical and statistical programming environment. The SCAB34S development toolkit comes with hundreds of pre-programmed subroutines, functions, and programs addressing applications using general nonlinear model estimation, constrained nonlinear programming, matrix programming, GARCH-M model estimation, and much more. Please contact SCA if you are interested in purchasing the SCAB34S applet development environment. No compiler is required. User-specified programs and other off-the-shelf programs can now be added dynamically to the Program menu of SCA WorkBench. Once a program is added to the Program menu, it can be executed directly from SCA WorkBench. The help system for SCA Statistical System syntax has been improved in SCA WorkBench.All SCA commands are categorized by function allowing users to find a specific command easily. Users can also search, print, edit, reorganize, add and delete SCA help files. Help for SCA applet programs (e.g., XLSREAD, XLSWRITE, and SCAB34S) are also accessible from SCA WorkBench. The help facilities are designed in a manner such that users can build help files for other programs accessed by SCA WorkBench. This includes programs that were developed using the SCAB34S applet development environment, SCA applet development toolkit, or any off-the-shelf software product. As an added convenience, the user can automatically load and execute sample programs that are associated with a help file. Because the help system is extensible, users can add additional sample programs and share these programs among other users. Univariate Time Series Model Extraction Engine: With the model extraction engine in SCA WorkBench,users can parse multiple SCA output files and extract information related to ARIMA, transfer function, and intervention models. The model information is then automatically collated and tabulated in a tab-delimited summary table. The summary table may then be imported into any spreadsheet or database application. Among the information that may be parsed include source filename; model instance; model name; dependent variable name; differencing operators; residual standard error; AIC and SIC; parameter estimates, standard errors, and t-values; and more. SCA WorkBench provides a convenient graphical user interface (GUI) for users interested in estimating conditional heteroscedastic (ARCH/GARCH) models. Through the ARCH/GARCH modeling environment, users can select various types of models under a simple GUI and automatically submit those models for estimation in the SCA System or SCAB34S GARCH module. Current models supported include ARCH, GARCH, GARCH-M, Exponential GARCH, Integrated GARCH, GJR GARCH, and threshold GARCH estimation. Alternative error distributions including student-t, Cauchy, and General Error Distribution (GED).