Spreadsheet: 148646d1333491971-way-to-shorten-this-formula-example
Sheet: Program Sheet

531 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 531 | 5x5 | 432 | 4x8 | 3x10 | 3x6-8-10 | 3x8-10-12 | 3xMAX | 3x6 | Custom1 | Custom2 | Custom3
0.3 | x10 |  |  | 0.3 | x10 |  |  | 0.3 | x10 |  |  | 0.3 | x10
0.5 | x4 |  |  | 0.5 | x4 |  |  | 0.5 | x4 |  |  | 0.5 | x4
0.65 | x5 |  |  | 0.7 | [NAME] |  |  | 0.65 | x5 |  |  | 0.4 | x5
0.75 | x5 |  |  | 0.8 | [NAME] |  |  | 0.75 | x5 |  |  | 0.5 | x5
0.85 | x5+ |  |  | 0.9 | x3+ |  |  | 0.85 | [NAME] |  |  | 0.6 | x5
 |  |  |  |  |  |  |  | 0.95 | x1+
5x5
0.3 | x10 |  |  | 0.3 | x10 |  |  | 0.3 | x10 |  |  | 0.3 | x10
0.5 | x4 |  |  | 0.5 | x4 |  |  | 0.5 | x4 |  |  | 0.5 | x4
0.65 | x5 |  |  | 0.7 | x5 |  |  | 0.75 | x5 |  |  | 0.8 | x5
0.65 | x5 |  |  | 0.7 | x5 |  |  | 0.75 | x5 |  |  | 0.8 | x5
0.65 | x5 |  |  | 0.7 | x5 |  |  | 0.75 | x5 |  |  | 0.8 | x5
0.65 | x5 |  |  | 0.7 | x5 |  |  | 0.75 | x5 |  |  | 0.8 | x5
0.65 | x5 |  |  | 0.7 | x5 |  |  | 0.75 | x5 |  |  | 0.8 | x5
4x8
0.3 | x10 |  |  | 0.3 | x10 |  |  | 0.3 | x10 |  |  | 0.3 | x10
0.5 | x6 |  |  | 0.5 | x6 |  |  | 0.5 | x6 |  |  | 0.5 | x6
0.6 | [NAME] |  |  | 0.6 | [NAME] |  |  | 0.65 | [NAME] |  |  | 0.65 | [NAME]
0.6 | [NAME] |  |  | 0.6 | [NAME] |  |  | 0.65 | [NAME] |  |  | 0.65 | [NAME]
0.6 | [NAME] |  |  | 0.6 | [NAME] |  |  | 0.65 | [NAME] |  |  | 0.65 | [NAME]
0.6 | [NAME] |  |  | 0.6 | [NAME] |  |  | 0.65 | [NAME] |  |  | 0.65 | [NAME]
3x10
0.65 | x10 |  |  | 0.65 | x10 |  |  | 0.65 | x10 |  |  | 0.65 | x10
0.65 | x10 |  |  | 0.65 | x10 |  |  | 0.65 | x10 |  |  | 0.65 | x10
0.65 | x10 |  |  | 0.65 | x10 |  |  | 0.65 | x10 |  |  | 0.65 | x10
3x6-8-10
0.75 | x6 |  |  | 0.75 | [NAME] |  |  | 0.75 | x10 |  |  | 0.65 | [NAME]
0.75 | x6 |  |  | 0.75 | [NAME] |  |  | 0.75 | x10 |  |  | 0.65 | [NAME]
0.75 | x6 |  |  | 0.75 | [NAME] |  |  | 0.75 | x10 |  |  | 0.65 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | 0.65 | [NAME]
3x8-10-12
 | [NAME] |  |  |  | x10 |  |  |  | x12 |  |  |  | x12
 | [NAME] |  |  |  | x10 |  |  |  | x12 |  |  |  | x12
 | [NAME] |  |  |  | x10 |  |  |  | x12 |  |  |  | x12
3x10
0.65 | 10 |  |  | 0.65 | 10 |  |  | 0.65 | 10 |  |  | 0.65 | 10
0.65 | 10 |  |  | 0.65 | 10 |  |  | 0.65 | 10 |  |  | 0.65 | 10
0.65 | 10 |  |  | 0.65 | 10 |  |  | 0.65 | 10 |  |  | 0.65 | 10
3xMAX
0.3 | x10 |  |  | 0.3 | x10 |  |  | 0.3 | x10 |  |  | 0.3 | x10
0.5 | x6 |  |  | 0.5 | x6 |  |  | 0.5 | x6 |  |  | 0.5 | x6
0.6 | [NAME] |  |  | 0.6 | [NAME] |  |  | 0.65 | [NAME] |  |  | 0.65 | [NAME]
0.6 | [NAME] |  |  | 0.6 | [NAME] |  |  | 0.65 | [NAME] |  |  | 0.65 | [NAME]
0.6 | [NAME] |  |  | 0.6 | [NAME] |  |  | 0.65 | [NAME] |  |  | 0.65 | [NAME]
0.6 | [NAME] |  |  | 0.6 | [NAME] |  |  | 0.65 | [NAME] |  |  | 0.65 | [NAME]
3x6
0.75 | x6 |  |  | 0.78 | x6 |  |  | 0.82 | x6 |  |  | 0.7 | x6
0.75 | x6 |  |  | 0.78 | x6 |  |  | 0.82 | x6 |  |  | 0.7 | x6
0.75 | x6 |  |  | 0.78 | x6 |  |  | 0.82 | x6 |  |  | 0.7 | x6
Custom 2
 | x10 |  |  |  | x12 |  |  |  | x15 |  |  |  | [NAME]
 | x15 |  |  |  | x12 |  |  |  | x10 |  |  |  | [NAME]
Custom 3
 | x40
432
0.5 | x4 |  |  | 0.5 | x4 |  |  | 0.5 | x4 |  |  | 0.5 | x4
0.65 | x4 |  |  | 0.65 | x4 |  |  | 0.8 | x4 |  |  | 0.75 | x4
0.8 | x4 |  |  | 0.88 | [NAME] |  |  | 0.93 | x2 |  |  | 0.85 | x2
0.8 | x4 |  |  | 0.88 | [NAME] |  |  | 0.93 | x2 |  |  | 1 | x1
0.8 | x4 |  |  | 0.88 | [NAME] |  |  | 0.93 | x2
0.8 | x4 |  |  | 0.88 | [NAME] |  |  | 0.93 | x2
 |  |  |  | 0.88 | [NAME] |  |  | 0.93 | x2
 |  |  |  |  |  |  |  | 0.93 | x2