A Primer on Spreadsheet Analytics - Computer Science > Software EngineeringReportar como inadecuado




A Primer on Spreadsheet Analytics - Computer Science > Software Engineering - Descarga este documento en PDF. Documentación en PDF para descargar gratis. Disponible también para leer online.

Abstract: This paper provides guidance to an analyst who wants to extract insight froma spreadsheet model. It discusses the terminology of spreadsheet analytics, howto prepare a spreadsheet model for analysis, and a hierarchy of analyticaltechniques. These techniques include sensitivity analysis, tornado charts,andbacksolving or goal-seeking. This paper presents native-Excel approaches forautomating these techniques, and discusses add-ins that are even moreefficient. Spreadsheet optimization and spreadsheet Monte Carlo simulation arebriefly discussed. The paper concludes by calling for empirical research, anddescribing desired features spreadsheet sensitivity analysis and spreadsheetoptimization add-ins.



Autor: Thomas A. Grossman

Fuente: https://arxiv.org/







Documentos relacionados