Difference between revisions of "Capacity Forecasting Tool"
Jump to navigation
Jump to search
| Line 5: | Line 5: | ||
= Implementation = | = Implementation = | ||
MRTG clients which POST data to data repository. Web based application displays data and performs periodic forecasting runs for which graphs are generated for display via a web server. The application will have the ability to | MRTG clients which POST data to data repository. Web based application displays data and performs periodic forecasting runs for which graphs are generated for display via a web server. The application will have the ability to export forecasts as Excel Spreadsheets to facilitate what-if analysis. | ||
= Generating Excel Files = | = Generating Excel Files = | ||
Revision as of 13:34, 16 December 2007
Introduction
A web based tool to analyse data extracted from various devices via MRTG and generate a capacity forecast.
Implementation
MRTG clients which POST data to data repository. Web based application displays data and performs periodic forecasting runs for which graphs are generated for display via a web server. The application will have the ability to export forecasts as Excel Spreadsheets to facilitate what-if analysis.
Generating Excel Files
See Generating Excel Spreadsheets Programatically
Parsing MRTG Files
Generating Graphs
Us the Python module matplotlib to generate images for data encapsulated in a MySQL database. Images will be displayed via a web server.
UNIX Packages Required
| Name | Required by | Download Location |
|---|---|---|
| Python | Application | http://www.python.org |
| matplotlib | http://matplotlib.sourceforge.com | |
| numpy | matplotlib | http://sourceforge.net/projects/numpy/ |
| ATLAS | numpy | http://sourceforge.net/projects/math-atlas/ |
| BLAS | numpy | |
| PERL | Application | http://ww.perl.org/ |
| SpreadSheet::WriteExcel | http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.20/lib/Spreadsheet/WriteExcel.pm | |
| Parse::RecDescent | SpreadSheet::WriteExcel | http://search.cpan.org/~dconway/Parse-RecDescent-v1.95.1/lib/Parse/RecDescent.pm |
| OLE::StorageLite | SpreadSheet::WriteExcel | http://search.cpan.org/~jmcnamara/OLE-Storage_Lite-0.15/Storage_Lite.pm |
| LWP::UserAgent | http://search.cpan.org/~gaas/libwww-perl-5.808/lib/LWP.pm | |
| MySQL | Application | http://www.mysql.org/ |
See Help onTables