Spreadsheet: 148211d1333257085-i-need-help-with-volume-cuts-sheet-test-acc-cost-work-book
Sheet: Reference

Tracks |  | colors | centermates |  | For invoice | angles
2" W/ TRACK | 2.55 | CLEAR | F/ P BUT | 7.5 | ACCORDION LOW PROFILE FLAT CMATE | 1X2.5 AGL | 0 | Opening | # [NAME] | Finish |  | # [NAME] |  | # Blade Right |  | OPENING  WIDTH | #  BLADES | FINISHED WIDTH | STACK | W Width | T Width | Stack W | # Blades
STD W TRACK | 0 | BEIGE | HD L/LOCK | 8.25 | ACCORDION HD CMATE & L LOCK | 1X4 AGL | 0.95 | [NAME] |  | [NAME] | Stack |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CEILING TRACK | 0 | IVORY | HD/HD LOCK | 8.5 | ACCORDION HD LOCK & CMATE | EA/ AGL | 2.85 |  | 1 | 10.75 | 3.75 |  |  |  |  | 6 | 2 | 11 | 5.125 | 1 | 13.75 | 4 | 3
W/O TRACK | 0 | WHITE | F/C/M RAIN/G | 8 | ACCORDION WITH RAIN GUARD |  |  | 7 | 2 | 14 | 4 | 1 |  | 1 |  | 11.75 | 4 | 17.5 | 5.75 | 12 | 20.25 | 4.5 | 5
ADJ/F TRACK | 0 | BRONZE |  |  |  |  |  | 10 | 3 | 17.25 | 4.25 | 2 |  | 1 |  | 17.5 | 6 | 24 | 6.375 | 18 | 26.75 | 5 | 7
 |  |  |  |  |  |  |  | 13 | 4 | 20.5 | 4.5 | 2 |  | 2 |  | 23.25 | 8 | 30.25 | 7 | 24 | 33.25 | 5.5 | 9
 |  |  |  |  |  |  |  | 16 | 5 | 23.75 | 4.75 | 3 |  | 2 |  | 29 | 10 | 36.75 | 7.625 | 30 | 40 | 6 | 11
 |  |  |  |  |  |  |  | 19 | 6 | 27 | 5 | 3 |  | 3 |  | 35 | 12 | 43 | 8.25 | 36 | 46.5 | 6.5 | 13
 |  |  |  |  |  |  |  | 22 | 7 | 30.25 | 5.25 | 4 |  | 3 |  | 40.75 | 14 | 49.5 | 8.875 | 42 | 53 | 7 | 15
Sale percentage options |  | job total | Lock |  |  |  |  | 25 | 8 | 33.5 | 5.5 | 4 |  | 4 |  | 46.5 | 16 | 56 | 9.5 | 48 | 59.5 | 7.5 | 17
1 | 0.2 |  | PUSH |  |  |  |  | 28 | 9 | 36.75 | 5.75 | 5 |  | 4 |  | 52.25 | 18 | 62.5 | 10.125 | 54 | 66 | 8 | 19
2 | 0.26 |  | L LOCK |  |  |  |  | 31 | 10 | 40 | 6 | 5 |  | 5 |  | 58 | 20 | 69 | 10.75 | 60 | 72.5 | 8.5 | 21
3 | 0.3 |  |  |  |  |  |  | 34 | 11 | 43.25 | 6.25 | 6 |  | 5 |  | 64 | 22 | 75.5 | 11.375 | 66 | 79 | 9 | 23
4 | 0.4 |  |  |  |  |  |  | 37 | 12 | 46.5 | 6.5 | 6 |  | 6 |  | 69.75 | 24 | 81.75 | 12 | 72 | 85.5 | 9.5 | 25
5 | 0.5 |  |  |  |  |  |  | 40 | 13 | 49.75 | 6.75 | 7 |  | 6 |  | 75.5 | 26 | 88 | 12.625 | 78 | 92 | 10 | 27
 |  |  |  |  |  |  |  | 43 | 14 | 53 | 7 | 7 |  | 7 |  | 81.5 | 28 | 94.75 | 13.25 | 84 | 98.5 | 10.5 | 29
[NAME] manufactures | Location | Key | Stack |  |  |  |  | 46 | 15 | 56.25 | 7.25 | 8 |  | 7 |  | 87 | 30 | 101 | 13.875 | 90 | 105 | 11 | 31
 | F door | P/O | 50-50 |  |  |  |  | 49 | 16 | 59.5 | 7.5 | 8 |  | 8 |  | 93 | 32 | 107.5 | 14.5 | 96 | 111.5 | 11.5 | 33
 | abv door | P/I | 90 R |  |  |  |  | 52 | 17 | 62.75 | 7.75 | 9 |  | 8 |  | 98 | 34 | 114 | 15.125 | 102 | 118 | 12 | 35
 | w north | L L/O | 70 R |  |  |  |  | 55 | 18 | 66 | 8 | 9 |  | 9 |  | 104.75 | 36 | 120.5 | 15.75 | 108 | 124.5 | 12.5 | 37
 | w south | L L/I | 90 L |  |  |  |  | 58 | 19 | 69.25 | 8.25 | 10 |  | 9 |  | 110.5 | 38 | 127 | 16.375 | 114 | 131 | 13 | 39
 | w east |  | 70 L |  |  |  |  | 61 | 20 | 72.5 | 8.5 | 10 |  | 10 |  | 116.25 | 40 | 133.25 | 17 | 120 | 137.5 | 13.5 | 41
 | w west |  |  |  |  |  |  | 64 | 21 | 75.75 | 8.75 | 11 |  | 10 |  | 122 | 42 | 139.75 | 17.625 | 126 | 144 | 14 | 43
 | d north |  |  |  |  |  |  | 67 | 22 | 79 | 9 | 11 |  | 11 |  | 128 | 44 | 146 | 18.25 | 132 | 150.5 | 14.5 | 45
paint | d south |  | TRAPPED |  |  |  |  | 70 | 23 | 82.25 | 9.25 | 12 |  | 11 |  | 133.75 | 46 | 152.5 | 18.875 | 138 | 157 | 15 | 47
1 | d east |  | YES |  |  |  |  | 73 | 24 | 85.5 | 9.5 | 12 |  | 12 |  | 139.5 | 48 | 159 | 19.5 | 144 | 163.5 | 15.5 | 49
2 | d west |  | NO |  |  |  |  | 76 | 25 | 88.75 | 9.75 | 13 |  | 12 |  | 145.25 | 50 | 165.5 | 20.125 | 150 | 170 | 16 | 51
2 | slider |  |  |  |  |  |  | 79 | 26 | 92 | 10 | 13 |  | 13 |  | 151 | 52 | 172 | 20.75 | 156 | 176.5 | 16.5 | 53
4 | lanai |  |  |  |  |  |  | 82 | 27 | 95.25 | 10.25 | 14 |  | 13 |  | 157 | 54 | 178.5 | 21.375 | 162 | 183 | 17 | 55
 |  |  |  |  |  |  |  | 85 | 28 | 98.5 | 10.5 | 14 |  | 14 |  | 162.75 | 56 | 184.75 | 22 | 168 | 189.5 | 17.5 | 57
JOB WIDTH | JOB HEIGHT | TOTAL | FASTENERS |  |  |  |  | 88 | 29 | 101.75 | 10.75 | 15 |  | 14 |  | 168.5 | 58 | 191 | 22.625 | 174 | 196 | 18 | 59
 |  |  |  |  |  |  |  | 91 | 30 | 105 | 11 | 15 |  | 15 |  | 174.5 | 60 | 197.75 | 23.25 | 180 | 202.5 | 18.5 | 61
 |  |  |  |  |  |  |  | 94 | 31 | 108.25 | 11.25 | 16 |  | 15 |  | 180 | 62 | 204 | 23.875 | 186 | 209 | 19 | 63
 |  |  |  |  |  |  |  | 97 | 32 | 111.5 | 11.5 | 16 |  | 16 |  | 186 | 64 | 210.5 | 24.5 | 192 | 215.5 | 19.5 | 65
 |  |  |  |  |  |  |  | 100 | 33 | 114.75 | 11.75 | 17 |  | 16 |  | 192 | 66 | 217 | 25.125 | 198 | 222 | 20 | 67
 |  |  |  |  |  |  |  | 103 | 34 | 118 | 12 | 17 |  | 17 |  | 197.75 | 68 | 223.5 | 25.75 | 204 | 228.5 | 20.5 | 69
 |  |  |  |  |  |  |  | 106 | 35 | 121.25 | 12.25 | 18 |  | 17 |  | 203.5 | 70 | 230 | 26.375 | 210 | 235 | 21 | 71
 |  |  |  |  |  |  |  | 109 | 36 | 124.5 | 12.5 | 18 |  | 18 |  | 209.25 | 72 | 236.25 | 27 | 216 | 241.5 | 21.5 | 73
 |  |  |  |  |  |  |  | 112 | 37 | 127.75 | 12.75 | 19 |  | 18 |  | 215 | 74 | 242.75 | 27.625 | 222 | 248 | 22 | 75
 |  |  |  |  |  |  |  | 115 | 38 | 131 | 13 | 19 |  | 19 |  | 221 | 76 | 249 | 28.25 | 228 | 254.5 | 22.5 | 77
 |  |  |  |  |  |  |  | 118 | 39 | 134.25 | 13.25 | 20 |  | 19 |  | 226.75 | 78 | 255.5 | 28.875 | 234 | 261 | 23 | 79
 |  |  |  |  |  |  |  | 121 | 40 | 137.5 | 13.5 | 20 |  | 20 |  | 232.5 | 80 | 262 | 29.5 | 240 | 267.5 | 23.5 | 81
 |  |  |  |  |  |  |  | 124 | 41 | 140.75 | 13.75 | 21 |  | 20 |  | 238.25 | 82 | 266.5 | 30.125 | 246 | 274 | 24 | 83
 |  |  |  |  |  |  |  | 127 | 42 | 144 | 14 | 21 |  | 21 |  | 244 | 84 | 274.75 | 30.75 | 252 | 280.5 | 24.5 | 85
 |  |  |  |  |  |  |  | 130 | 43 | 147.25 | 14.25 | 22 |  | 21 |  | 250 | 86 | 281.5 | 31.375 | 258 | 267 | 25 | 87
 |  |  |  |  |  |  |  | 133 | 44 | 150.5 | 14.5 | 22 |  | 22 |  | 255.75 | 88 | 287.75 | 32 | 264 | 293.5 | 25.5 | 89
 |  |  |  |  |  |  |  | 136 | 45 | 153.75 | 14.75 | 23 |  | 22 |  | 262.5 | 90 | 294 | 32.625 | 270 | 300 | 26 | 91
 |  | ROUND UP NEXT 100 |  |  |  |  |  | 139 | 46 | 157 | 15 | 23 |  | 23 |  | 267.5 | 92 | 300.75 | 33.25 | 276 | 306.5 | 26.5 | 93
 |  |  |  |  |  |  |  | 142 | 47 | 160.25 | 15.25 | 24 |  | 23 |  | 273 | 94 | 307 | 33.875 | 282 | 313 | 27 | 95
 |  |  |  |  |  |  |  | 145 | 48 | 163.5 | 15.5 | 24 |  | 24 |  | 279 | 96 | 313.5 | 34.5 | 288 | 319.5 | 27.5 | 97
 |  |  |  |  |  |  |  | 148 | 49 | 166.75 | 15.75 | 25 |  | 24 |  | 285 | 98 | 320 | 35.125 | 294 | 326 | 28 | 99
 |  |  |  |  |  |  |  | 151 | 50 | 170 | 16 | 25 |  | 25 |  | 290.75 | 100 | 326.5 | 35.75 | 300 | 332.5 | 28.5 | 101
 |  |  |  |  |  |  |  | 154 | 51 | 173.25 | 16.25 | 26 |  | 25 |  | 296.5 | 102 | 333 | 36.375 | 306 | 339 | 29 | 103
 |  |  |  |  |  |  |  | 157 | 52 | 176.5 | 16.5 | 26 |  | 26 |  | 302.25 | 104 | 339.25 | 37 | 312 | 345.5 | 29.5 | 105
 |  |  |  |  |  |  |  | 160 | 53 | 179.75 | 16.75 | 27 |  | 26 |  | 308 | 106 | 345.75 | 37.625 | 318 | 352 | 30 | 107
 |  |  |  |  |  |  |  | 163 | 54 | 183 | 17 | 27 |  | 27 |  | 314 | 108 | 352 | 38.25 | 324 | 358.5 | 30.5 | 109
 |  |  |  |  |  |  |  | 166 | 55 | 186.25 | 17.25 | 28 |  | 27 |  | 319.75 | 110 | 358.5 | 38.875 | 330 | 365 | 31 | 111
 |  |  |  |  |  |  |  | 169 | 56 | 189.5 | 17.5 | 28 |  | 28 |  | 325.5 | 112 | 365 | 39.5 | 336 | 371.5 | 31.5 | 113
 |  |  |  |  |  |  |  | 172 | 57 | 192.75 | 17.75 | 29 |  | 28 |  | 331.5 | 114 | 372.5 | 40.125 | 342 | 378 | 32 | 115
 |  |  |  |  |  |  |  | 175 | 58 | 196 | 18 | 29 |  | 29 |  | 337 | 116 | 378 | 40.75 | 348 | 384.5 | 32.5 | 117
 |  |  |  |  |  |  |  | 178 | 59 | 199.25 | 18.25 | 30 |  | 29 |  | 343 | 118 | 384.5 | 41.375 | 354 | 391 | 33 | 119
 |  |  |  |  |  |  |  | 181 | 60 | 202.5 | 18.5 | 30 |  | 30 |  | 348.75 | 120 | 390.75 | 42 | 360 | 397.5 | 33.5 | 121
 |  |  |  |  |  |  |  | 184 | 61 | 205.75 | 18.75 | 31 |  | 30 |  | 354.75 | 122 | 397 | 42.625 | 366 | 404 | 34 | 123
 |  |  |  |  |  |  |  | 187 | 62 | 209 | 19 | 31 |  | 31 |  | 360.5 | 124 | 403.75 | 43.25 | 372 | 410.5 | 34.5 | 125
 |  |  |  |  |  |  |  | 190 | 63 | 212.25 | 19.25 | 32 |  | 31 |  | 366 | 126 | 410 | 43.875 | 378 | 417 | 35 | 127
 |  |  |  |  |  |  |  | 193 | 64 | 215.5 | 19.5 | 32 |  | 32 |  | 372 | 128 | 416.5 | 44.5 | 384 | 423.5 | 35.5 | 129
 |  |  |  |  |  |  |  | 196 | 65 | 218.75 | 19.75 | 33 |  | 32 |  | 378 | 130 | 423 | 45.125 | 390 | 430 | 36 | 131
 |  |  |  |  |  |  |  | 199 | 66 | 222 | 20 | 33 |  | 33 |  | 383.75 | 132 | 429.5 | 45.75 | 396 | 436.5 | 36.5 | 133
 |  |  |  |  |  |  |  | 202 | 67 | 225.25 | 20.25 | 34 |  | 33 |  | 389.5 | 134 | 436 | 46.375 | 402 | 443 | 37 | 135
 |  |  |  |  |  |  |  | 205 | 68 | 228.5 | 20.5 | 34 |  | 34 |  | 395.25 | 136 | 442.25 | 47 | 408 | 449.5 | 37.5 | 137
 |  |  |  |  |  |  |  | 208 | 69 | 231.75 | 20.75 | 35 |  | 34 |  | 401 | 138 | 448.75 | 47.625 | 414 | 456 | 38 | 139
 |  |  |  |  |  |  |  | 211 | 70 | 235 | 21 | 35 |  | 35 |  | 407 | 140 | 455 | 48.25 | 420 | 462.5 | 38.5 | 141
 |  |  |  |  |  |  |  | 214 | 71 | 238.25 | 21.25 | 36 |  | 35 |  |  |  |  |  | 426 | 469 | 39 | 143
 |  |  |  |  |  |  |  | 217 | 72 | 241.5 | 21.5 | 36 |  | 36 |  |  |  |  |  | 432 | 475.5 | 39.5 | 145
 |  |  |  |  |  |  |  | 220 | 73 | 244.75 | 21.75 | 37 |  | 36 |  |  |  |  |  | 438 | 482 | 40 | 147
 |  |  |  |  |  |  |  | 223 | 74 | 248 | 22 | 37 |  | 37 |  |  |  |  |  | 444 | 488.5 | 40.5 | 149
 |  |  |  |  |  |  |  | 226 | 75 | 251.25 | 22.25 | 38 |  | 37 |  |  |  |  |  | 450 | 495 | 41 | 151
 |  |  |  |  |  |  |  | 229 | 76 | 254.5 | 22.5 | 38 |  | 38 |  |  |  |  |  | 456 | 501.5 | 41.5 | 153
 |  |  |  |  |  |  |  | 232 | 77 | 257.75 | 22.75 | 39 |  | 38 |  |  |  |  |  | 462 | 508 | 42 | 155
 |  |  |  |  |  |  |  | 235 | 78 | 261 | 23 | 39 |  | 39 |  |  |  |  |  | 468 | 514.5 | 42.5 | 157
 |  |  |  |  |  |  |  | 238 | 79 | 264.25 | 23.25 | 40 |  | 39 |  |  |  |  |  | 474 | 521 | 43 | 159
 |  |  |  |  |  |  |  | 241 | 80 | 267.5 | 23.5 | 40 |  | 40 |  |  |  |  |  | 480 | 527.5 | 43.5 | 161
 |  |  |  |  |  |  |  | 244 | 81 | 270.75 | 23.75 | 41 |  | 40 |  |  |  |  |  | 486 | 534 | 44 | 163
 |  |  |  |  |  |  |  | 247 | 82 | 274 | 24 | 41 |  | 41 |  |  |  |  |  | 492 | 540.5 | 44.5 | 165
 |  |  |  |  |  |  |  | 250 | 83 | 277.25 | 24.25 | 42 |  | 41
 |  |  |  |  |  |  |  | 253 | 84 | 280.5 | 24.5 | 42 |  | 42
 |  |  |  |  |  |  |  | 256 | 85 | 283.75 | 24.75 | 43 |  | 42
 |  |  |  |  |  |  |  | 259 | 86 | 287 | 25 | 43 |  | 43
 |  |  |  |  |  |  |  | 262 | 87 | 290.25 | 25.25 | 44 |  | 43
 |  |  |  |  |  |  |  | 265 | 88 | 293.5 | 25.5 | 44 |  | 44
 |  |  |  |  |  |  |  | 268 | 89 | 296.75 | 25.75 | 45 |  | 44
 |  |  |  |  |  |  |  | 271 | 90 | 300 | 26 | 45 |  | 45
 |  |  |  |  |  |  |  | 274 | 91 | 303.25 | 26.25 | 46 |  | 45
 |  |  |  |  |  |  |  | 277 | 92 | 306.5 | 26.5 | 46 |  | 46
 |  |  |  |  |  |  |  | 280 | 93 | 309.75 | 26.75 | 47 |  | 46
 |  |  |  |  |  |  |  | 283 | 94 | 313 | 27 | 47 |  | 47
 |  |  |  |  |  |  |  | 286 | 95 | 316.25 | 27.25 | 48 |  | 47
 |  |  |  |  |  |  |  | 289 | 96 | 319.5 | 27.5 | 48 |  | 48
 |  |  |  |  |  |  |  | 292 | 97 | 322.75 | 27.75 | 49 |  | 48
 |  |  |  |  |  |  |  | 295 | 98 | 326 | 28 | 49 |  | 49
 |  |  |  |  |  |  |  | 298 | 99 | 329.25 | 28.25 | 50 |  | 49
 |  |  |  |  |  |  |  | 301 | 100 | 332.5 | 28.5 | 50 |  | 50
 |  |  |  |  |  |  |  | 304