Appendix. The Early Warning System-Details
In Chapter 4, page 78, we mentioned that additional details and examples for steps 5–9 would be provided in this section.
Step 5: Entering Leading, Lagging, and Connectors into a Spreadsheet
The sample spreadsheet, Table A.1, shows where the leading (columns A-D), connector (E–G), and lagging indicators (columns H-J) and variances are entered. You can also clearly see in the spreadsheet how after each forecasted indicator and connector assumption, that “actual” results or numbers from a campaign are entered.
Table A.1 Example of a Causal Forecast
Table A.1 covers in detail steps 5–9 from Chapter 4 ...