Spreadsheet: 39836d1238099766-multiple-columns-example12
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 | 3 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 16 | #N/A | #N/A | #N/A | #N/A | 16
 |  | Weekly Target | 0.952018278750952 | 0.7614761476147615 | 0.7376237623762376 | 0.7084708470847085 | 0.6720297029702971 | 0.6251768033946252 | 0.5627062706270628 | 0.4752475247524753 | 0.3440594059405941 | 0.1254125412541255 | -0.3118811881188117 | -1.623762376237623 | #N/A | #N/A
 |  | 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 |  | #N/A
Sickness Leave
Annual Leave
Over Time