Spreadsheet: 33183d1229463574-nested-if-functions-roman-3e-table
Sheet: Sheet5

 | 2020 |  | 0.75 | 1 | 1.25 | 1.5 | 1.75 | 2 | 2.25 | 2.5 | 2.75 | 3 | 3.25 | 3.5 | 3.75 | 4
2020Profile 2116 | Profile 2116 |  | 0.75 | 1 | 1.25 | 1.5 | 1.75 | 2 | 2.25 | 2.5
2020Hex Bar 2111 | Hex Bar 2111 |  | 0.75 | 1 | 1.25 | 1.5 | 1.75 | 2 | 2.25 | 2.5
2020Gear 2049 | Gear 2049 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2020Tape Spool 2032 | Tape Spool 2032 |  | 3 | 4 | 4 | 5 | 6 | 6 | 7 | 8
2020Tape Centralizer 3056 | Tape Centralizer 3056 |  | 3 | 4 | 4 | 5 | 6 | 6 | 7 | 8
2020Tape Ring 3073 | Tape Ring 3073 |  | 3 | 4 | 4 | 5 | 6 | 6 | 7 | 8
2020Bracket 3630 | Bracket 3630 |  | 2 | 2 | 3 | 3 | 4 | 4 | 5 | 5
2020Screw 18R | Screw 18R |  | 2 | 2 | 3 | 3 | 4 | 4 | 5 | 5
2020End Cover 2131 | End Cover 2131 |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
2020Clip 2059 | Clip 2059 |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
2020Bead Chain 4845 | Bead Chain 4845 |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
 | 2120 |  | 0.75 | 1 | 1.25 | 1.5 | 1.75 | 2 | 2.25 | 2.5 | 2.75 | 3 | 3.25 | 3.5 | 3.75 | 4
2120Profile 2211 | Profile 2211 |  | 0.75 | 1 | 1.25 | 1.5 | 1.75 | 2 | 2.25 | 2.5 | 2.75 | 3 | 3.25 | 3.5 | 3.75 | 4
2120Hex Bar 2111 | Hex Bar 2111 |  | 0.75 | 1 | 1.25 | 1.5 | 1.75 | 2 | 2.25 | 2.5 | 2.75 | 3 | 3.25 | 3.5 | 3.75 | 4
2120Gear 2049 | Gear 2049 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2120Tape Spool 2081 | Tape Spool 2081 |  | 3 | 4 | 4 | 4 | 6 | 6 | 7 | 8 | 8 | 9 | 10 | 11 | 12 | 13
2120N/A | N/A | 0 | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a
2120Tape Ring 3073 | Tape Ring 3073 |  | 3 | 4 | 4 | 4 | 6 | 6 | 7 | 8 | 8 | 9 | 10 | 11 | 12 | 13
2120Bracket 3630 | Bracket 3630 |  | 2 | 2 | 3 | 3 | 4 | 4 | 5 | 5 | 6 | 6 | 7 | 7 | 8 | 8
2120Screw 18R | Screw 18R |  | 2 | 2 | 3 | 3 | 4 | 4 | 5 | 5 | 6 | 6 | 7 | 7 | 8 | 8
2120End Cover 2179 | End Cover 2179 |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
2120Clip 2059 | Clip 2059 |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
2120Bead Chain 4845 | Bead Chain 4845 |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
 | 2320 |  | 0.75 | 1 | 1.25 | 1.5 | 1.75 | 2 | 2.25 | 2.5 | 2.75 | 3 | 3.25 | 3.5 | 3.75 | 4
2320Profile 2211 | Profile 2211 |  | 0.75 | 1 | 1.25 | 1.5 | 1.75 | 2 | 2.25 | 2.5 | 2.75 | 3 | 3.25 | 3.5 | 3.75 | 4
2320Hex Bar 2111 | Hex Bar 2111 |  | 0.75 | 1 | 1.25 | 1.5 | 1.75 | 2 | 2.25 | 2.5 | 2.75 | 3 | 3.25 | 3.5 | 3.75 | 4
2320Gear 2049 | Gear 2049 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2320Tape Spool 2081 | Tape Spool 2081 |  | 3 | 4 | 4 | 4 | 6 | 6 | 7 | 8 | 8 | 9 | 10 | 11 | 12 | 13
2320Tape [NAME] | Tape Centralizer 3056 |  | 3 | 4 | 4 | 4 | 6 | 6 | 7 | 8 | 8 | 9 | 10 | 11 | 12 | 13
2320Tape Ring 3073 | Tape Ring 3073 |  | 3 | 4 | 4 | 4 | 6 | 6 | 7 | 8 | 8 | 9 | 10 | 11 | 12 | 13
2320Bracket 3630 | Bracket 3630 |  | 2 | 2 | 3 | 3 | 4 | 4 | 5 | 5 | 6 | 6 | 7 | 7 | 8 | 8
2320Screw 18R | Screw 18R |  | 2 | 2 | 3 | 3 | 4 | 4 | 5 | 5 | 6 | 6 | 7 | 7 | 8 | 8
2320End Cover 2179 | End Cover 2179 |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
2320Clip 2059 | Clip 2059 |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
2320Bead Chain 4845 | Bead Chain 4845 |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
 | Batten |  | 0.75 | 1 | 1.25 | 1.5 | 1.75 | 2 | 2.25 | 2.5 | 2.75 | 3 | 3.25 | 3.5 | 3.75 | 4
BattenTimber | Timber |  | 0.75 | 1 | 1.25 | 1.5 | 1.75 | 2 | 2.25 | 2.5 | 2.75 | 3 | 3.25 | 3.5 | 3.75 | 4
Batten |  |  | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a
BattenAcorn | Acorn |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
BattenCleat | Cleat |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
BattenCord connector | Cord connector |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
BattenChina Barrels | China Barrels |  | 3 | 4 | 4 | 4 | 6 | 6 | 7 | 8 | 8 | 9 | 10 | 11 | 12 | 13
BattenBottom Rings | [NAME] |  | 3 | 4 | 4 | 4 | 6 | 6 | 7 | 8 | 8 | 9 | 10 | 11 | 12 | 13
BattenBrackets | Brackets |  | 2 | 2 | 3 | 3 | 4 | 4 | 5 | 5 | 6 | 6 | 7 | 7 | 8 | 8
BattenScrews | Screws |  | 2 | 2 | 3 | 3 | 4 | 4 | 5 | 5 | 6 | 6 | 7 | 7 | 8 | 8
Battenstring | string |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BattenPull cord | Pull cord |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | These are the 4 systems we use at the moment, might be more in the future; who knows
 |  |  | what the future might bring
 |  |  | these are the drop downs on page 1 hardware
 |  |  | I have split the page in two to print paper work for one deptment and page two for the other