Spreadsheet: 39839d1238100958-multiple-columns-example12-2
Sheet: Store

 |  |  | Weeks Gone | 1 |  |  |  | weeks left | 12
 |  |  | % Per Wk | 0.077
 |  |  | Cummulitive | 0.077
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
SIS Weights | SALES | Quarterly Target | wk 1 | wk 2 | wk 3 | wk 4 | wk 5 | wk 6 | wk 7 | wk 8 | wk 9 | wk 10 | wk 11 | wk 12 | wk 13 | Total | Achievement | Success Index Score | Remaining | Weekly Target to hit 100% | Average Week to date
0.1 | ??? | 12.37623762376238 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 2 | 1 | 2 | 16 | 1.2928 | 0.125 | -3.623762376237623 | 0.952018278750952 | 16
 |  | Weekly Target | 0.952018278750952 | 0.9432943294329433 | 0.9376237623762377 | 0.9306930693069307 | 0.9220297029702971 | 0.9108910891089109 | 0.8960396039603961 | 0.8752475247524754 | 0.5940594059405941 | 0.4587458745874589 | -0.3118811881188117 | -1.623762376237623 | -3.623762376237623 | 12.37623762376238
 |  | Input
 | ??? | 2.475247524752475 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 2.475247524752476
 |  | Weekly Target | 0.1904036557501904 | 0.1904036557501904 | 0.1904036557501904 | 0.1904036557501904 | 0.1904036557501904 | 0.1904036557501904 | 0.1904036557501904 | 0.1904036557501904 | 0.1904036557501904 | 0.1904036557501904 | 0.1904036557501904 | 0.1904036557501904 | 0.1904036557501904 | 2.475247524752476
 | ??? | 4.95049504950495 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 4.950495049504951
 |  | Weekly Target | 0.3808073115003808 | 0.3808073115003808 | 0.3808073115003808 | 0.3808073115003808 | 0.3808073115003808 | 0.3808073115003808 | 0.3808073115003808 | 0.3808073115003808 | 0.3808073115003808 | 0.3808073115003808 | 0.3808073115003808 | 0.3808073115003808 | 0.3808073115003808 | 4.950495049504951
0.2 | ??? | 12.37623762376238 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 12.37623762376238
 |  | Weekly Target | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 12.37623762376238
 | ??? | 12.37623762376238 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 12.37623762376238
 |  | Weekly Target | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 12.37623762376238
0.1 | ??? | 12.37623762376238 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 12.37623762376238
 |  | Weekly Target | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 12.37623762376238
 | ??? | 12.37623762376238 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 12.37623762376238
 |  | Weekly Target | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 12.37623762376238
 | ??? | 12.37623762376238 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 12.37623762376238
 |  | Weekly Target | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 12.37623762376238
0.2 | ??? | 12.37623762376238 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 12.37623762376238
 |  | Weekly Target | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 12.37623762376238
 | ??? | 12.37623762376238 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 12.37623762376238
 |  | Weekly Target | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 12.37623762376238
 | ??? | 12.37623762376238 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 12.37623762376238
 |  | Weekly Target | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 12.37623762376238
 | ??? | 12.37623762376238 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 12.37623762376238
 |  | Weekly Target | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 12.37623762376238
 | ??? | 12.37623762376238 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 12.37623762376238
 |  | Weekly Target | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 12.37623762376238
 | ??? | 12.37623762376238 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 12.37623762376238
 |  | Weekly Target | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 12.37623762376238
0.1 | ??? | 12.37623762376238 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 12.37623762376238
 |  | Weekly Target | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 12.37623762376238
0.1 | ??? | 12.37623762376238 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 12.37623762376238
 |  | Weekly Target | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 12.37623762376238
 | ??? | 12.37623762376238 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 12.37623762376238
 |  | Weekly Target | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 12.37623762376238
 | ??? | 12.37623762376238 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 12.37623762376238
 |  | Weekly Target | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 0.952018278750952 | 12.37623762376238
 | ??? |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | #N/A |  | 0
 |  | Weekly Target | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0.1 | ??? | 0.0649 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0.1 | 0.065
 |  | Weekly Target | 0.0649 | 0.0649 | 0.0649 | 0.0649 | 0.0649 | 0.0649 | 0.0649 | 0.0649 | 0.0649 | 0.0649 | 0.0649 | 0.0649 | 0.0649 | 0.065
0.1 | ??? | 371 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 371
 |  | Weekly Target | 371 | 371 | 371 | 371 | 371 | 371 | 371 | 371 | 371 | 371 | 371 | 371 | 371 | 371
Operational Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Success index score |  | 0.225
Sickness Leave
Annual Leave
Over Time