There’s More Than One Way to Round a Number

When we were in school, we all learned the general rule for rounding – if a significant digit is followed by a number that is greater than or equal…


Calculating an Average Annual Growth Rate in MetrixND

After finishing my forecast, I like to present forecast average annual growth rates.  These results are calculated by converting the monthly forecast…


Seasonal Sales? Not a Problem.

There is a client who has a reporting issue problem. Let’s call him Ray. His annual sales are to be split into summer and winter sales, but on a…


Forecast Tests in MetrixND

Out-of-sample tests are a useful tool for seeing how well a model performs with data it hasn’t seen before (i.e., data that weren’t used to estimate…


Who is Forecasting Long-Term Solar Generation?

In this last forecasting brown bag presentation on solar load forecasting, we asked participants who had developed a long-term solar load forecast…


Using In-Line Transformation in the Report Object

  I’m developing a forecast that requires base, high, and low scenarios.  After building the base scenario, the high and low scenarios are…