Spreadsheet: 39793d1238077775-multiple-columns-example1
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 | 2 | 0.8523852385238524 | 0.8523852385238524 | 0.8523852385238525 | 0.8523852385238525 | 0.8523852385238525 | 0.8523852385238526 | 0.8523852385238527 | 0.8523852385238526 | 0.8523852385238525 | 0.8523852385238522 | 0.8523852385238531 | 12.37623762376238 | 1 | 0.1 | 0 | 0.952018278750952 | 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
 |  | Input | 1 | 2
 | ??? | 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.2
Sickness Leave
Annual Leave
Over Time