Spreadsheet: 178444d1346791281-more-efficient-way-to-pull-weightings-other-than-a-nested-if-statement-ifstatement
Sheet: Sheet1

Sector [NAME] |  |  |  |  |  | 1 |  |  | 2 |  |  | 3
Priority |  | Wieghting |  |  |  | Ratio | Rank | Weight | Ratio | Rank | Weight | Ratio | Rank | Weight
1 | 0.0325 | 0.035 |  |  |  | A | 4 | 0.0575 | A |  | N/A | A |  | N/A
2 |  | 0.0425 |  |  |  | B | 2 | 0.0425 | B |  | N/A | B |  | N/A
3 |  | 0.05 |  |  |  | C |  | N/A | C |  | N/A | C |  | N/A
4 |  | 0.0575 |  |  |  | D |  | N/A | D |  | N/A | D |  | N/A
5 |  | 0.065 |  |  |  | E |  | N/A | E |  | N/A | E |  | N/A
6 |  | 0.0725 |  |  |  | F |  | N/A | F |  | N/A | F |  | N/A
7 |  | 0.0725 |  |  |  | G |  | N/A | G |  | N/A | G |  | N/A
8 |  | 0.07999999999999999 |  |  |  | H |  | N/A | H |  | N/A | H |  | N/A
9 |  | 0.0875 |  |  |  | I |  | N/A | I |  | N/A | I |  | N/A
10 |  | 0.095 |  |  |  | J |  | N/A | J |  | N/A | J |  | N/A
11 |  | 0.1025 |  |  |  | K |  | N/A | K |  | N/A | K |  | N/A
12 |  | 0.11 |  |  |  | L |  | N/A | L |  | N/A | L |  | N/A
 |  | 0.87 |  |  |  |  | 3 | 0.1 |  | #N/A | 0 |  | #N/A | 0
 |  |  |  |  |  |  | Ok | 0.77 |  | #N/A | 0.87 |  | #N/A | 0.87
 |  |  |  |  |  | 4 |  |  | 5 |  |  | 6
 |  |  |  |  |  | Ratio | Rank | Weight | Ratio | Rank | Weight | Ratio | Rank | Weight
 |  |  |  |  |  | A |  | N/A | A |  | N/A | A |  | N/A
 |  |  |  |  |  | B |  | N/A | B |  | N/A | B |  | N/A
 |  |  |  |  |  | C |  | N/A | C |  | N/A | C |  | N/A
 |  |  |  |  |  | D |  | N/A | D |  | N/A | D |  | N/A
 |  |  |  |  |  | E |  | N/A | E |  | N/A | E |  | N/A
 |  |  |  |  |  | F |  | N/A | F |  | N/A | F |  | N/A
 |  |  |  |  |  | G |  | N/A | G |  | N/A | G |  | N/A
 |  |  |  |  |  | H |  | N/A | H |  | N/A | H |  | N/A
 |  |  |  |  |  | I |  | N/A | I |  | N/A | I |  | N/A
 |  |  |  |  |  | J |  | N/A | J |  | N/A | J |  | N/A
 |  |  |  |  |  | K |  | N/A | K |  | N/A | K |  | N/A
 |  |  |  |  |  | L |  | N/A | L |  | N/A | L |  | N/A
 |  |  |  |  |  |  | #N/A | 0 |  | #N/A | 0 |  | #N/A | 0
 |  |  |  |  |  |  | #N/A | 0.87 |  | #N/A | 0.87 |  | #N/A | 0.87
 |  |  |  |  |  | 7 |  |  | 8 |  |  | 9 |  |  | 10
 |  |  |  |  |  | Ratio | Rank | Weight | Ratio | Rank | Weight | Ratio | Rank | Weight | Ratio | Rank | Weight
 |  |  |  |  |  | A |  | N/A | A |  | N/A | A |  | N/A | A |  | N/A
 |  |  |  |  |  | B |  | N/A | B |  | N/A | B |  | N/A | B |  | N/A
 |  |  |  |  |  | C |  | N/A | C |  | N/A | C |  | N/A | C |  | N/A
 |  |  |  |  |  | D |  | N/A | D |  | N/A | D |  | N/A | D |  | N/A
 |  |  |  |  |  | E |  | N/A | E |  | N/A | E |  | N/A | E |  | N/A
 |  |  |  |  |  | F |  | N/A | F |  | N/A | F |  | N/A | F |  | N/A
 |  |  |  |  |  | G |  | N/A | G |  | N/A | G |  | N/A | G |  | N/A
 |  |  |  |  |  | H |  | N/A | H |  | N/A | H |  | N/A | H |  | N/A
 |  |  |  |  |  | I |  | N/A | I |  | N/A | I |  | N/A | I |  | N/A
 |  |  |  |  |  | J |  | N/A | J |  | N/A | J |  | N/A | J |  | N/A
 |  |  |  |  |  | K |  | N/A | K |  | N/A | K |  | N/A | K |  | N/A
 |  |  |  |  |  | L |  | N/A | L |  | N/A | L |  | N/A | L |  | N/A
 |  |  |  |  |  |  | #N/A | 0 |  | #N/A | 0 |  | #N/A | 0 |  | #N/A | 0
 |  |  |  |  |  |  | #N/A | 0.87 |  | #N/A | 0.87 |  | #N/A | 0.87 |  | #N/A | 0.87