Spreadsheet: 692820d1598589861-multiple-indexs-across-non-continuous-ranges-template-copy
Sheet: Master Price DB

Notes | PCS | D | I | M | B | Length | In | [NAME] | Board Ft. | Lumber Type/Placement | Price | Unit Price | SKU | # | Notes | PCS | D | I | M | B | In | Length | Lumber Type/Placement | SQ.Footage | Price | Unit Price | SKU |  | # | Notes | PCS | D | I | M | B | In | Length | [NAME] | Lumber Type/Placement | Price | Unit Price | SKU
1st [NAME] | 14 | 2 | x | 4 | 21 | 16 |  | 224 | 150 | DF#2-PT             -1Mudsill | 0 |  |  |  | Attic Platform | 3 | 4 | x | 8 | 73 | S | 3/4" | T&G OSB 48/24 -1Attic Platform | 96 | 0 |  |  |  | 1 | 2nd Flr Beams | 1 | 5 1/8  x 16 1/2 |  |  | 66 | 0 | 21 | 21 | GlbDF24FV4         -1Beam | 0
1st [NAME] | 1 | 2 | x | 6 | 21 | 20 |  | 20 | 20 | DF#2-PT             -1Mudsill | 0 |  |  |  | 1st Flr Shear | 5 | 4 | x | 9 | 52 | S | 15/32" | OSB                     -1Shear | 180 | 0 |  |  |  | 2 | 2nd Flr Beams | 2 | 1 3/4  x 14 |  |  | 66 | 0 | 4 | 8 | LSL                     -2Beam | 0
1st [NAME] | 1 | 3 | x | 4 | 21 | 20 |  | 20 | 20 | DF#2-PT             -1Mudsill | 0 |  |  |  | 1st Flr Shear | 11 | 4 | x | 9 | 52 | S | 3/8" | OSB                     -1Shear | 396 | 0 |  |  |  | 3 | 2nd Flr Beams | 1 | 3 1/2  x 14 |  |  | 66 | 0 | 4 | 4 | Parallam              -2Beam | 0
1st Plate | 34 | 2 | x | 4 | 22 | 20 |  | 680 | 454 | DF#2/Btr            -1Plate | 0 |  |  |  | 1st Flr Shear Furring | 9 | 4 | x | 9 | 165 | S | 3/8" | OSB                     -1Shear | 324 | 0 |  |  |  | 4 | 2nd Flr Beams | 1 | 3 1/2  x 14 |  |  | 66 | 0 | 7 | 7 | Parallam              -2Beam | 0
1st Plate | 5 | 2 | x | 6 | 22 | 20 |  | 100 | 100 | DF#2/Btr            -1Plate | 0 |  |  |  | 1st Stair Tread | 6 | 1.125 | x | 11.875 | 59 | S | 12 | OSB/SuperTrd    -1StairSht | 80 | 0 |  |  |  | 5 | 2nd Flr Beams | 1 | 3 1/2  x 14 |  |  | 66 | 0 | 9 | 9 | Parallam              -2Beam | 0
1st Rake Wall Studs | 5 | 2 | x | 4 | 35 | 12 |  | 60 | 40 | DF#2                    -1Stud | 0 |  |  |  | 1st Stair Landing Ply | 1 | 4 | x | 8 | 61 | S | 3/4" | T&G OSB 48/24 -1StairSht | 32 | 0 |  |  |  | 6 | 2nd Flr Beams | 1 | 3 1/2  x 14 |  |  | 66 | 0 | 11 | 11 | Parallam              -2Beam | 0
1st [NAME] | 25 | 2 | x | 6 | 29 | 104.25 | * | 226 | 226 | DF#2/Btr      -1Stud | 0 |  |  |  | 1st Stair Risers | 2 | 4 | x | 8 | 60 | S | 3/4" | T&G OSB 48/24 -1StairSht | 64 | 0 |  |  |  | 7 | 2nd Flr Beams | 1 | 5 1/4  x 14 |  |  | 66 | 0 | 17 | 17 | Parallam              -2Beam | 0
1st Rake Wall Studs | 2 | 2 | x | 4 | 35 | 8 |  | 16 | 11 | DFStd/Btr             -1Stud | 0 |  |  |  | 2nd [NAME] | 37 | 4 | x | 8 | 68 | S | 3/4" | T&G OSB 48/24  -2SubFlr | 1184 | 0 |  |  |  | 8 | 1st Garage Hdr | 1 | 5 1/8  x 12 |  |  | 42 | 0 | 22 | 22 | GlbDF24FV4     -1Headr | 0
1st Rake Wall Studs | 4 | 2 | x | 4 | 35 | 10 |  | 40 | 27 | DFStd/Btr             -1Stud | 0 |  |  |  | 2nd Flr Shear | 13 | 4 | x | 8 | 93 | S | 3/8" | OSB                      -2Shear | 416 | 0 |  |  |  | 9 | 2nd Joist | 7 | 2 1/16 x 14 | 0 | 0 | 67 |  | 6 | 42 | BCI 6000        -2Joist | 0
1st [NAME] | 242 | 2 | x | 4 | 29 | 104.25 | * | 2178 | 1452 | DFStd/Btr     -1Stud | 0 |  |  |  | 2nd Flr Shear Furring | 11 | 4 | x | 8 | 166 | S | 3/8" | OSB                      -2Shear | 352 | 0 |  |  |  | 10 | 2nd Joist | 4 | 2 1/16 x 14 | 0 | 0 | 67 |  | 11 | 44 | BCI 6000        -2Joist | 0
1st Posts | 1 | 6 | x | 6 | 40 | 104.25 | * | 9 | 27 | DF#1                  -1Post | 0 |  |  |  | [NAME] | 55 | 4 | x | 8 | 135 | S | 15/32" | LP Tech Shield   -RfSheath | 1760 | 0 |  |  |  | 11 | 2nd Joist | 2 | 2 1/16 x 14 | 0 | 0 | 67 |  | 16 | 32 | BCI 6000        -2Joist | 0
1st Posts | 10 | 4 | x | 4 | 40 | 104.25 | * | 90 | 120 | DF#2/Btr              -1Post | 0 |  |  |  | [NAME] | 2 | 4 | x | 8 | 138 | S | 3/8" | OSB                      -RfShear | 64 | 0 |  |  |  | 12 | 2nd Joist | 5 | 2 1/16 x 14 | 0 | 0 | 67 |  | 22 | 110 | BCI 6000        -2Joist | 0
1st Posts | 9 | 4 | x | 6 | 40 | 104.25 | * | 81 | 162 | DF#2/Btr              -1Post | 0 |  |  |  | Eave Starter Board | 6 | 12 | * | 96 | 134 | S | 15/32" | CCX-PTS             -RfStartrBrd | 50 | 0 |  |  |  | 13 | 2nd Joist | 3 | 2 1/16 x 14 | 0 | 0 | 67 |  | 24 | 72 | BCI 6000        -2Joist | 0
1st Posts | 1 | 4 | x | 8 | 40 | 104.25 | * | 9 | 24 | DF#2/Btr              -1Post | 0 |  |  |  | Barge Starter Board | 24 | 12 | * | 96 | 167 | S | 15/32" | CCX-PTS             -RfStartrBrd | 200 | 0 |  |  |  | 14 | 2nd Joist | 13 | 2 1/16 x 14 | 0 | 0 | 67 |  | 38 | 494 | BCI 6000        -2Joist | 0
1st Post@Abutt | 6 | 4 | x | 4 | 160 | 104.25 | * | 54 | 72 | DF#2/Btr              -1ShearBreak | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 2nd Rim Joist | 6 | 1 1/4 x 14 | 0 | 0 | 69 |  | 20 | 120 | LSL         -2Rim | 0
1st Post@Abutt | 1 | 4 | x | 6 | 160 | 104.25 | * | 9 | 18 | DF#2/Btr              -1ShearBreak | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | 2nd Joist Blocks | 0 | 2 1/16 x 14 | 0 | 0 | 70 | * | 14.4375 | 46 | BCI 6000       -2JoistBlk | 0
1st Flr P & L Braces | 23 | 2 | x | 4 | 50 | 14 |  | 322 | 215 | DFStd/Btr     -1PlumLine | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
1st Cut Porch Hdr | 1 | 4 | x | 6 | 41 | 10 | 0 | 10 | 20 | DF#2/Btr               -1Beam | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
1st Cut Hdr | 3 | 4 | x | 10 | 49 | 51 | * | 16 | 54 | DF#2/Btr              -1Headr | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
1st Cut Hdr | 2 | 4 | x | 10 | 49 | 75 | * | 16 | 54 | DF#2/Btr              -1Headr | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
1st Cut Sills & Crips | 6 | 2 | x | 4 | 154 | 48 | * | 24 | 16 | DFStd/Btr             -1WinSill | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21
1st Cut Sills & Crips | 4 | 2 | x | 4 | 154 | 72 | * | 24 | 16 | DFStd/Btr             -1WinSill | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
1st Cut Sills & Crips | 15 | 2 | x | 4 | 154 | 43.75 | * | 56 | 38 | DFStd/Btr             -1WinBtmCrip | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
1st Cut Sills & Crips | 14 | 2 | x | 4 | 154 | 19.75 | * | 24 | 16 | DFStd/Btr             -1WinBtmCrip | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
1st Trimmers | 10 | 2 | x | 4 | 43 | 94.75 | * | 80 | 54 | DFStd/Btr     -1WinTrimmer | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25
1st Cut Hdr | 2 | 4 | x | 10 | 49 | 41 | * | 8 | 27 | DF#2/Btr              -1DrHeadr | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26
1st Cut Hdr | 4 | 4 | x | 4 | 49 | 41 | * | 16 | 22 | DF#2/Btr              -1DrHeadr | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27
1st Cut Hdr | 1 | 3.5 | x | 9.5 | 49 | 77 | * | 8 | 8 | PSL                      -1DrHeadr | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28
1st Cut Sills & Crips | 16 | 2 | x | 4 | 155 | 6 | * | 8 | 6 | DFStd/Btr            -1DrTopCrip | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29
1st Trimmers | 14 | 2 | x | 4 | 44 | 94.75 | * | 112 | 75 | DFStd/Btr     -1DrTrimmer | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
1st Stair Landing Frame | 5 | 2 | x | 6 | 58 | 8 |  | 40 | 40 | DF#2/Btr           -1StairLanding | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
1st Stair Stringers | 3 | 1.75 | x | 14 | 57 | 18 |  | 54 | 54 | LSL                   -1StairStringer | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32
1st Sheetrock Backing | 22 | 2 | x | 4 | 74 | 16 |  | 352 | 235 | DFStd/Btr     -1Backing | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33
2nd Plate | 52 | 2 | x | 4 | 75 | 20 |  | 1040 | 694 | DF#2/Btr              -2Plate | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34
2nd Plate | 3 | 2 | x | 6 | 75 | 20 |  | 60 | 60 | DF#2/Btr              -2Plate | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35
2nd [NAME] | 20 | 2 | x | 6 | 78 | 92.25 | * | 160 | 160 | DF#2/Btr              -2Stud | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36
2nd [NAME] | 293 | 2 | x | 4 | 78 | 92.25 | * | 2344 | 1563 | DFStd/Btr     -2Stud | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37
2nd [NAME] | 20 | 2 | x | 4 | 78 | 42 | * | 80 | 54 | DFStd/Btr     -2Stud | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38
2nd Posts | 6 | 4 | x | 4 | 86 | 92.25 | * | 48 | 64 | DF#2/Btr              -2Post | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39
2nd Flr P & L Braes | 21 | 2 | x | 4 | 91 | 14 |  | 294 | 196 | DFStd/Btr     -2PlumLine | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
2nd Cut Hdr | 1 | 3.5 | x | 9.5 | 90 | 102 | * | 10 | 10 | Parallam              -2Headr | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41
2nd Cut Hdr | 11 | 4 | x | 10 | 90 | 51 | * | 56 | 187 | DF#2/Btr             -2WinHeadr | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42
2nd Cut Sills & Crips | 22 | 2 | x | 4 | 156 | 48 | * | 88 | 59 | DFStd/Btr            -2WinSill | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43
2nd Cut Sills & Crips | 2 | 2 | x | 4 | 156 | 96 | * | 16 | 11 | DFStd/Btr            -2WinSill | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44
2nd Cut Sills & Crips | 55 | 2 | x | 4 | 156 | 2.25 | * | 12 | 8 | DFStd/Btr             -2WinTopCrip | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45
2nd Cut Sills & Crips | 9 | 2 | x | 4 | 156 | 2.25 | * | 2 | 2 | DFStd/Btr             -2WinTopCrip | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46
2nd Cut Sills & Crips | 55 | 2 | x | 4 | 156 | 29.5 | * | 136 | 91 | DFStd/Btr            -2WinBtmCrip | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 47
2nd Cut Sills & Crips | 9 | 2 | x | 4 | 156 | 5.5 | * | 6 | 4 | DFStd/Btr            -2WinBtmCrip | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48
2nd Trimmers | 26 | 2 | x | 4 | 45 | 80.5 | * | 182 | 122 | DFStd/Btr       -2WinTrimmer | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49
2nd Cut Hdr | 8 | 4 | x | 4 | 90 | 41 | * | 32 | 43 | DF#2/Btr              -2DrHeadr | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50
2nd Cut Hdr | 2 | 4 | x | 4 | 90 | 65 | * | 12 | 16 | DF#2/Btr              -2DrHeadr | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51
2nd Cut Sills & Crips | 32 | 2 | x | 4 | 157 | 8 | * | 22 | 15 | DFStd/Btr             -2DrTopCrip | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52
2nd Cut Sills & Crips | 12 | 2 | x | 4 | 157 | 8 | * | 8 | 6 | DFStd/Btr             -2DrTopCrip | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 53
2nd Trimmers | 20 | 2 | x | 4 | 46 | 80.75 | * | 140 | 94 | DFStd/Btr     -2DrTrimmer | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 54
2nd Sheetrock Backing | 19 | 2 | x | 4 | 111 | 16 |  | 304 | 203 | DFStd/Btr     -2Backing | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55
Rf-OverFraming | 2 | 2 | x | 6 | 162 | 16 |  | 32 | 32 | DF#2/Btr      -RfRafter | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56
Rf-OverFraming | 1 | 2 | x | 8 | 162 | 8 |  | 8 | 11 | DF#2/Btr      -RfRidge | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57
Rf-OverFraming | 4 | 2 | x | 8 | 162 | 16 |  | 64 | 86 | DF#2/Btr       -RfSleeper | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 58
[NAME] | 6 | 2 | x | 6 | 124 | 12 |  | 72 | 72 | DF#2/Btr              -RfBrace | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59
Roof Z-barBacking | 4 | 1 | x | 4 | 164 | 16 |  | 64 | 22 | DFStd/Btr              -RfBrace | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60
[NAME] | 10 | 2 | x | 4 | 124 | 12 |  | 120 | 80 | DFStd/Btr              -RfBrace | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 61
[NAME] | 5 | 2 | x | 4 | 163 | 16 |  | 80 | 54 | DFStd/Btr             -RfBrace | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62
[NAME] | 2 | 2 | x | 6 | 120 | 16 |  | 32 | 32 | DF#2/Btr               -RfLedgr | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 63
[NAME] | 3 | 2 | x | 6 | 130 | 16 |  | 48 | 48 | KD-SPF-R/S1S-Pr   -RfBarge | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 64
[NAME] | 1 | 2 | x | 6 | 130 | 10 |  | 10 | 10 | KD-SPF-R/S1S-Pr   -RfBarge | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65
Gable Rake Trim | 4 | 2 | x | 3 | 153 | 16 |  | 64 | 32 | KD-SprR/S1S-Pr   -GableRakeTrim | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 66
[NAME] | 10 | 2 | x | 4 | 128 | 12 |  | 120 | 80 | DF#2/Btr              -RfOutRigrs | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 67
Garage Head & Jamb | 2 | 2 | x | 6 | 148 | 18 |  | 36 | 36 | KD-SPF-R/S1S-Pr   -GrgJam | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 68