Free TimeTrex resource
Review interval forecast errors, see demand-weighted error and separate over-forecasting from under-forecasting.
Enter non-overlapping intervals in the same unit: decimal labor-demand hours. Keep the same team, demand definition and forecast lead time. The seven rows are an illustrative example, not business data. Blank inputs are errors; use 0 only for a confirmed zero.
For each interval, F is forecast demand and A is actual demand. Signed error is F − A; absolute error is |F − A|. With n intervals, MAE = sum of absolute errors ÷ n. WAPE = sum of absolute errors ÷ sum of actual demand × 100. Total signed bias = sum of forecast demand − sum of actual demand; bias percentage = total signed bias ÷ sum of actual demand × 100. Over-forecast hours sum max(F − A, 0); under-forecast hours sum max(A − F, 0). This worksheet uses non-negative demand and retains hundredths of an hour before division.
The seven example forecasts total 700 hours; actual demand also totals 700 hours. Absolute interval errors sum to 80 hours, so WAPE is 80 ÷ 700 × 100 = 11.43% and MAE is 80 ÷ 7 = 11.43 hours per interval. Over-forecast and under-forecast totals are each 40 hours, producing zero net bias. Equal totals therefore do not establish accurate interval forecasts.
Lower WAPE and MAE indicate smaller errors on the particular comparison set; the tool supplies no universal good or bad threshold. Compare methods over the same intervals, population, demand definition and lead time. A different demand mix can change WAPE even when hour errors are similar. Net zero bias can conceal substantial mistakes. The results do not identify why a forecast missed, predict future accuracy, measure service quality or recommend headcount changes.
When total actual demand is zero, WAPE and bias percentage display N/A, while hour errors remain visible. An individual zero-actual interval still contributes its absolute hour error to the total. WAPE above 100% remains visible and is not capped. This tool does not convert error into a misleading 100 minus WAPE accuracy score. Percentage results use total actual demand, not an average of interval percentage errors. Display values round to two decimals; CSV retains unrounded ratios. No individual employee or customer information is needed.
Copy this CSV if your browser blocks the download.
Checked October 30, 2026. This independent worksheet applies standard error measures to user-entered labor-demand hours. It is not a vendor report or an automated forecasting model.
Disclaimer: This voluntary aggregate worksheet evaluates the historical forecasts and actual labor-demand hours you enter; it does not create a forecast or determine staffing requirements. Worked hours can be constrained by understaffing and must not be assumed to equal demand. Intervals, teams, units and forecast lead times must match. Signed bias uses forecast minus actual; over- and under-forecast errors can cancel in the total but not in WAPE. Zero total actual demand makes percentage metrics undefined. Results do not establish service levels, productivity, legal compliance, individual performance or employment decisions, and no universal error threshold is implied. Verify all inputs, results and assumptions against appropriate records and obtain qualified advice before relying on them. To the fullest extent permitted by applicable law, this resource is provided “as is” without warranties of accuracy, completeness or fitness for a particular purpose, and TimeTrex and its affiliates disclaim liability for losses, damages, costs or claims arising from its use, inability to use, or reliance on it, including errors or omissions. Nothing in this disclaimer excludes or limits liability or rights that cannot lawfully be excluded or limited.
Trusted By
Join our ever-growing community of satisfied customers today and experience the unparalleled benefits of TimeTrex.
Strength In Numbers
Time To Clock-In
Experience the Ultimate Workforce Solution and Revolutionize Your Business Today
Saving businesses time and money through better workforce management since 2003.
Copyright © 2026 TimeTrex. All Rights Reserved.