Spreadsheet: 885704d1735533242-match-and-array-not-working-at-all-worksheet-not-working
Sheet: FORMULA

 | (1) TO DETERMINE EQUAL DISTANCE .. TOP&BOTTOM |  |  |  |  |  |  |  |  |  | TRANSOM CONNECTOR |  |  | EARLUG UP |  |  | NO-LINTEL-SEAL |  |  | GAP, TOP |  |  | TOP EXTRUSION |  |  | SIDE EXTRUSION
 | Opening Width: |  |  | 0 | Overall Cut Width: |  |  |  |  |  |  |  |  |  |  |  | 45
 | No# of Mullions: |  |  |  |  |  |  |  |  | 0 | MULLION CONNECTOR |  |  | AXLE |  |  | LINTEL-SEAL |  |  | GAP, BOTTOM |  |  | BTM EXTRUSION |  |  | TOP & BOTTOM
 | No# of Negative Space: |  |  |  | Overall [NAME] (-65x2): |  |  |  |  |  | 12 |  |  |  |  |  | 54
 |  |  |  |  |  |  |  |  |  |  |  |  |  | EARLUG DOWN |  |  |  |  |  | GAP, SIDES |  |  | TRANSOMS
 |  |  |  |  | Overall Internal Cut Length (-Transom x 2): |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25
 |  |  |  | 0
 |  |  |  |  | Width minus No# of Bars:
 | (2) TOP/BOTTOM EQUAL DISTANCE |  |  |  |  |  |  |  |  |  | (4) TO DETERMINE EQUAL DISTANCE .. LEFT |  |  |  |  |  |  |  |  |  | (5) TO DETERMINE EQUAL DISTANCE .. RIGHT
 | Equal Distance: |  |  |  |  |  |  |  |  |  | Opening Height: |  |  |  | Intermediate Position: |  |  |  |  |  | Opening Height: |  |  |  | Overall Frame Height:
 |  |  |  |  |  |  | FINAL | MULLION | EDGE |  | No# of Transoms: |  |  |  | Frame Height (w/ Ext) |  |  |  |  |  | No# of Transoms: |  |  |  | Frame Height (w/ Ext)
 | CNC Position (First): |  |  |  |  | First: |  |  |  |  | No# of Negative Space: |  |  |  | Intermediate Position: |  |  |  |  |  | No# of Negative Space: |  |  |  | Intermediate Position:
 | CNC Position (Second): |  |  |  |  | Second: |  |  |  |  |  |  |  |  | Height (- Intermediate): |  |  |  |  |  |  |  |  |  | Height (- Intermediate):
 | CNC Position (Third): |  |  |  |  | Third: |  |  |  |  |  |  |  |  | Final Height: |  |  |  |  |  |  |  |  |  | Final Height:
 | CNC Position (Fourth): |  |  |  |  | Fourth: |  |  |  |  |  |  |  |  | Left Hand Tapper?: |  |  |  |  |  |  |  |  |  | Right Hand Tapper?:
 | CNC Position (Fifth): |  |  |  |  | Fifth:
 | CNC Position (Sixth): |  |  |  |  | Sixth: |  |  |  |  | Equal Distance: |  |  |  |  |  |  |  |  |  | Equal Distance:
 | CNC Position (Seventh): |  |  |  |  | Seventh: |  |  |  |  |  |  |  |  |  |  | FINAL | TRANSOM | EDGE |  |  |  |  |  |  |  | FINAL | TRANSOM | EDGE
 | CNC Position (Eighth): |  |  |  |  | Eighth: |  |  |  |  | CNC Position (First): |  |  |  |  | First: |  |  |  |  | CNC Position (First): |  |  |  |  | First:
 | CNC Position (Nineth): |  |  |  |  | [NAME]: |  |  |  |  | CNC Position (Second): |  |  |  |  | Second: |  |  |  |  | CNC Position (Second): |  |  |  |  | Second:
 |  |  |  |  |  |  |  |  |  |  | CNC Position (Third): |  |  |  |  | Third: |  |  |  |  | CNC Position (Third): |  |  |  |  | Third:
 | (3) EQUAL DISTANCE .. MIDDLE HORIZONTAL (100x50) |  |  |  |  |  |  |  |  |  | CNC Position (Fourth): |  |  |  |  | Fourth: |  |  |  |  | CNC Position (Fourth): |  |  |  |  | Fourth:
 | Internal Width: |  |  | Equal Distance (T/B): |  |  |  |  |  |  | CNC Position (Fifth): |  |  |  |  | Fifth: |  |  |  |  | CNC Position (Fifth): |  |  |  |  | Fifth:
 | No# of Bars:
 | No# of Spaces:
 |  |  |  |  |  |  | FINAL | MULLION | CONNECTOR
 | CNC Bar Position (First): |  |  |  |  | First:
 | CNC Bar Position (Second): |  |  |  |  | Second:
 | CNC Bar Position (Third): |  |  |  |  | Third:
 | CNC Bar Position (Fourth): |  |  |  |  | Fourth:
 | CNC Bar Position (Fifth): |  |  |  |  | Fifth:
 | CNC Bar Position (Sixth): |  |  |  |  | Sixth:
 | CNC Bar Position (Seventh): |  |  |  |  | Seventh:
 | CNC Bar Position (Eighth): |  |  |  |  | Eighth:
 | CNC Bar Position (Nineth): |  |  |  |  | [NAME]:
 | LEFT EQUAL DISTANCE |  |  |  | CNC POSITION ([NAME]):
 | Equal Distance: |  |  |  | 1
 | Half of Bar (50/2=25): |  |  |  | 2
 |  |  |  |  | 3
 | Equal Distance: |  |  |  | 4
 | Bar (50):
 | RIGHT EQUAL DISTANCE |  |  |  | CNC POSITION (RIGHT):
 | Equal Distance: |  |  |  | 1
 | Half of Bar (50/2=25): |  |  |  | 2
 |  |  |  |  | 3
 | Equal Distance: |  |  |  | 4
 | Bar (50):