{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Control Sheet","Cut Sheet 1","Cut Sheet 2","Cut Sheet 3","Cut Sheet 4","Cut Sheet 5","Cut Sheet 6","Cut Sheet 7","Invoice","3000 Price Sheet","2000 Price Sheet","1000 Price Sheet"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Control Sheet","index":0,"n_rows":46,"n_cols":11,"rows_kept":46,"cut":false,"hidden":false,"merged":[[24,8,24,14],[31,8,31,14],[38,8,38,14],[45,8,45,14],[45,0,45,6],[32,0,36,6],[39,0,43,6],[24,0,24,6],[46,0,50,6],[25,8,29,14],[32,8,36,14],[39,8,43,14],[46,8,50,14],[31,0,31,6],[38,0,38,6],[25,0,29,6],[8,1,8,6],[7,1,7,6],[1,1,1,6],[2,1,2,6],[3,1,3,6],[4,1,4,6],[5,1,5,6],[6,1,6,6]]}
[]
["Customer Name:",null,null,null,null,null,null,null,"Item","Head Length","Sill Length"]
["Customer Address:",null,null,null,null,null,null,null,1,{"$f":"'Cut Sheet 1'!B19","v":""},{"$f":"'Cut Sheet 1'!B20","v":""}]
["Customer Contact Info",null,null,null,null,null,null,null,2,{"$f":"'Cut Sheet 2'!B19","v":""},{"$f":"'Cut Sheet 2'!B19","v":""}]
["Date:",null,null,null,null,null,null,null,3,{"$f":"'Cut Sheet 3'!B19","v":""},{"$f":"'Cut Sheet 3'!B20","v":""}]
["Delivery Date:",null,null,null,null,null,null,null,4,{"$f":"'Cut Sheet 4'!B19","v":""},{"$f":"'Cut Sheet 4'!B20","v":""}]
["Order #/ Quote:",null,null,null,null,null,null,null,5,{"$f":"'Cut Sheet 5'!B19","v":""},{"$f":"'Cut Sheet 5'!B20","v":""}]
["PO Number:",null,null,null,null,null,null,null,6,{"$f":"'Cut Sheet 6'!B19","v":""},{"$f":"'Cut Sheet 6'!B20","v":""}]
["Tax Rate",null,null,null,null,null,null,null,7,{"$f":"'Cut Sheet 7'!B19","v":""},{"$f":"'Cut Sheet 7'!B20","v":""}]
[]
[]
[]
[]
[]
[]
["Item","Panels","Series","Size","Color","Mirror Type","H&S Type","Mutin Bars?","Mutin Bar #","Price"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[]
["Invoice Comments",null,null,null,null,null,null,null,"Cut Sheet 1 Comments"]
[]
[]
[]
[]
[]
[]
["Cut Sheet 2 Comments",null,null,null,null,null,null,null,"Cut Sheet 3 Comments"]
[]
[]
[]
[]
[]
[]
["Cut Sheet 4 Comments",null,null,null,null,null,null,null,"Cut Sheet 5 Comments"]
[]
[]
[]
[]
[]
[]
["Cut Sheet 6 Comments",null,null,null,null,null,null,null,"Cut Sheet 7 Comments"]

{"sheet":"Cut Sheet 1","index":1,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[[24,0,24,1],[25,0,28,1]]}
["Date",{"$f":"Invoice!G2","v":"00:00:00"}]
["Order #",{"$f":"Invoice!G1","v":0}]
["Customer",{"$f":"Invoice!B8","v":0}]
["Purchase Order #",{"$f":"Invoice!G4","v":0}]
["Column1","Column2"]
["Item",1]
["# Of Panels",{"$f":"'Control Sheet'!B17","v":0}]
["Style",{"$f":"'Control Sheet'!C17","v":0}]
["Size",{"$f":"'Control Sheet'!D17","v":0}]
["Color",{"$f":"'Control Sheet'!E17","v":0}]
["Mirror Type",{"$f":"'Control Sheet'!F17","v":0}]
["Mirror size",{"$f":"IF($B$8=1000,\n  TEXT(\n    (VALUE(LEFT($B$9,FIND(\"x\",$B$9)-1))\n     - (2 + ($B$7-2)*0.25)\n    ) / $B$7,\n    \"# ?/32\"\n  )&CHAR(34)&\" x \"&\n  TEXT(\n    IF(\n      $B$22=\"Yes\",\n      (VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-6-$B$23*1.25)/($B$23+1),\n      VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-6\n    ),\n    \"# ?/32\"\n  )&CHAR(34),\n\nIF($B$8=2000,\n  TEXT(\n    (VALUE(LEFT($B$9,FIND(\"x\",$B$9)-1))\n     + (1.25 + ($B$7-2)*1.375)\n    ) / $B$7,\n    \"# ?/?\"\n  )&CHAR(34)&\" x \"&\n  TEXT(\n    IF(\n      $B$22=\"Yes\",\n      (VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-2.25-$B$23*1.25)/($B$23+1),\n      VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-2.25\n    ),\n    \"# ?/16\"\n  )&CHAR(34),\n\nIF($B$8=3000,\n  TEXT(\n    (VALUE(LEFT($B$9,FIND(\"x\",$B$9)-1))\n     - (7.5 + ($B$7-2)*2.25)\n    ) / $B$7,\n    \"# ?/16\"\n  )&CHAR(34)&\" x \"&\n  TEXT(\n    IF(\n      $B$22=\"Yes\",\n      (VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-6-$B$23*1.25)/($B$23+1),\n      VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-6\n    ),\n    \"# ?/16\"\n  )&CHAR(34),\n\"\")))","v":""}]
["# Of Lites",{"$f":"IF($B$22=\"Yes\", ($B$23 + 1) * $B$7, $B$7)","v":0}]
["Rail #",{"$f":"B7*2","v":0}]
["Rail Size",{"$f":"IF(\n  $B$8=1000,\n    TEXT(\n      (\n        (VALUE(LEFT($B$9, FIND(\"x\",$B$9)-1))\n         - (2     + ($B$7-2)*0.25)\n        ) / $B$7\n        - 0.75\n      ),\n      \"# ?/16\"\n    ) & \"″\",\n\n  IF(\n    $B$8=2000,\n      \"cut to size\",\n\n    IF(\n      $B$8=3000,\n        TEXT(\n          (\n            (VALUE(LEFT($B$9, FIND(\"x\",$B$9)-1))\n             - (7.5   + ($B$7-2)*2.25)\n            ) / $B$7\n            - 0.75\n          ),\n          \"# ?/16\"\n        ) & \"″\",\n      \"\"\n    )\n  )\n)","v":""}]
["Vertical #",{"$f":"B7*2","v":0}]
["Vertical size",{"$f":"IF(\n  $B$8=1000,\n    TEXT(\n      VALUE(MID($B$9, FIND(\"x\",$B$9)+1, 99))\n      - 2,\n      \"# ?/16\"\n    )&\"″\",\n\n  IF(\n    $B$8=2000,\n      \"cut to size\",\n\n    IF(\n      $B$8=3000,\n        TEXT(\n          VALUE(MID($B$9, FIND(\"x\",$B$9)+1, 99))\n          - 2,\n          \"# ?/16\")&\"″\",\n      \"\"\n    )\n  )\n)","v":""}]
["Cut Style H&S",{"$f":"'Control Sheet'!G17","v":0}]
["Head Length",{"$f":"IF(B18=\"Cut To Size\",\nTRIM(TEXT(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),\"# ??/16\"))&\"″\",\nIF(B18=\"Cut To Size TT\",\nTRIM(TEXT(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),\"# ??/16\"))&\"″ TT\",\nIF(B18=\"Extra Length\",\nTRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),0)+2,\"# ??/16\"))&\"″\",\nIF(B18=\"Extra Length TT\",\nTRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),0)+2,\"# ??/16\"))&\"″ TT\",\n\"\"))))","v":""}]
["Sill Length",{"$f":"IF(B18=\"Cut To Size\",\nTRIM(TEXT(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),\"# ??/16\"))&\"″\",\nIF(B18=\"Cut To Size TT\",\nTRIM(TEXT(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),\"# ??/16\"))&\"″ TT\",\nIF(B18=\"Extra Length\",\nTRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),0)+2,\"# ??/16\"))&\"″\",\nIF(B18=\"Extra Length TT\",\nTRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),0)+2,\"# ??/16\"))&\"″ TT\",\n\"\"))))","v":""}]
["S.S. Track Length",{"$f":"IF(ISNUMBER(SEARCH(\"Cut To Size\", B18)),\n   TRIM(TEXT(VALUE(TRIM(LEFT(B9, FIND(\"x\", B9)-1))), \"# ??/16\")) & \"″ \" & IF(ISNUMBER(SEARCH(\"TT\", B18)), \"(3)\", \"(2)\"),\nIF(ISNUMBER(SEARCH(\"Extra Length\", B18)),\n   TRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9, FIND(\"x\", B9)-1))), 0) + 2, \"# ??/16\")) & \"″ \" & IF(ISNUMBER(SEARCH(\"TT\", B18)), \"(3)\", \"(2)\"),\n\"\"))","v":""}]
["Mutin Bars?",{"$f":"'Control Sheet'!H17","v":0}]
["Total Mutin Bars",{"$f":"'Control Sheet'!I17","v":0}]
["Mutin Bar Width",{"$f":"IF($B$22=\"Yes\",\n   IF($B$8=1000,\n      TEXT(((VALUE(LEFT($B$9, FIND(\"x\",$B$9)-1)) - (2 + ($B$7-2)*0.25)) / $B$7 - 0.75), \"# ?/16\") & \"″\",\n   IF($B$8=2000,\n      \"cut to size\",\n   IF($B$8=3000,\n      TEXT(((VALUE(LEFT($B$9, FIND(\"x\",$B$9)-1)) - (7.5 + ($B$7-2)*2.25)) / $B$7 - 0.75), \"# ?/16\") & \"″\",\n   \"\"))),\n\"\")","v":""}]
["Cut Sheet Comments"]
[{"$f":"'Control Sheet'!I26","v":0}]

{"sheet":"Cut Sheet 2","index":2,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[[24,0,24,1],[25,0,28,1]]}
["Date",{"$f":"Invoice!G2","v":"00:00:00"}]
["Order #",{"$f":"Invoice!G1","v":0}]
["Customer",{"$f":"Invoice!B8","v":0}]
["Purchase Order #",{"$f":"Invoice!G4","v":0}]
["Column1","Column2"]
["Item",2]
["# Of Panels",{"$f":"'Control Sheet'!B18","v":0}]
["Style",{"$f":"'Control Sheet'!C18","v":0}]
["Size",{"$f":"'Control Sheet'!D18","v":0}]
["Color",{"$f":"'Control Sheet'!E18","v":0}]
["Mirror Type",{"$f":"'Control Sheet'!F18","v":0}]
["Mirror size",{"$f":"IF($B$8=1000,\n  TEXT(\n    (VALUE(LEFT($B$9,FIND(\"x\",$B$9)-1))\n     - (2 + ($B$7-2)*0.25)\n    ) / $B$7,\n    \"# ?/16\"\n  )&CHAR(34)&\" x \"&\n  TEXT(\n    IF(\n      $B$22=\"Yes\",\n      (VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-6-$B$23*1.25)/($B$23+1),\n      VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-6\n    ),\n    \"# ?/16\"\n  )&CHAR(34),\n\nIF($B$8=2000,\n  TEXT(\n    (VALUE(LEFT($B$9,FIND(\"x\",$B$9)-1))\n     + (1.25 + ($B$7-2)*1.375)\n    ) / $B$7,\n    \"# ?/16\"\n  )&CHAR(34)&\" x \"&\n  TEXT(\n    IF(\n      $B$22=\"Yes\",\n      (VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-2.25-$B$23*1.25)/($B$23+1),\n      VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-2.25\n    ),\n    \"# ?/16\"\n  )&CHAR(34),\n\nIF($B$8=3000,\n  TEXT(\n    (VALUE(LEFT($B$9,FIND(\"x\",$B$9)-1))\n     - (7.5 + ($B$7-2)*2.25)\n    ) / $B$7,\n    \"# ?/16\"\n  )&CHAR(34)&\" x \"&\n  TEXT(\n    IF(\n      $B$22=\"Yes\",\n      (VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-6-$B$23*1.25)/($B$23+1),\n      VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-6\n    ),\n    \"# ?/16\"\n  )&CHAR(34),\n\"\")))","v":""}]
["# Of Lites",{"$f":"IF($B$22=\"Yes\", ($B$23 + 1) * $B$7, $B$7)","v":0}]
["Rail #",{"$f":"B7*2","v":0}]
["Rail Size",{"$f":"IF(\n  $B$8=1000,\n    TEXT(\n      (\n        (VALUE(LEFT($B$9, FIND(\"x\",$B$9)-1))\n         - (2     + ($B$7-2)*0.25)\n        ) / $B$7\n        - 0.75\n      ),\n      \"# ?/16\"\n    ) & \"″\",\n\n  IF(\n    $B$8=2000,\n      \"cut to size\",\n\n    IF(\n      $B$8=3000,\n        TEXT(\n          (\n            (VALUE(LEFT($B$9, FIND(\"x\",$B$9)-1))\n             - (7.5   + ($B$7-2)*2.25)\n            ) / $B$7\n            - 0.75\n          ),\n          \"# ?/16\"\n        ) & \"″\",\n      \"\"\n    )\n  )\n)","v":""}]
["Vertical #",{"$f":"B7*2","v":0}]
["Vertical size",{"$f":"IF(\n  $B$8=1000,\n    TEXT(\n      VALUE(MID($B$9, FIND(\"x\",$B$9)+1, 99))\n      - 2,\n      \"# ?/16\"\n    )&\"″\",\n\n  IF(\n    $B$8=2000,\n      \"cut to size\",\n\n    IF(\n      $B$8=3000,\n        TEXT(\n          VALUE(MID($B$9, FIND(\"x\",$B$9)+1, 99))\n          - 2,\n          \"# ?/16\")&\"″\",\n      \"\"\n    )\n  )\n)","v":""}]
["Cut Style H&S",{"$f":"'Control Sheet'!G18","v":0}]
["Head Length",{"$f":"IF(B18=\"Cut To Size\",\nTRIM(TEXT(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),\"# ??/16\"))&\"″\",\nIF(B18=\"Cut To Size TT\",\nTRIM(TEXT(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),\"# ??/16\"))&\"″ TT\",\nIF(B18=\"Extra Length\",\nTRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),0)+2,\"# ??/16\"))&\"″\",\nIF(B18=\"Extra Length TT\",\nTRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),0)+2,\"# ??/16\"))&\"″ TT\",\n\"\"))))","v":""}]
["Sill Length",{"$f":"IF(B18=\"Cut To Size\",\nTRIM(TEXT(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),\"# ??/16\"))&\"″\",\nIF(B18=\"Cut To Size TT\",\nTRIM(TEXT(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),\"# ??/16\"))&\"″ TT\",\nIF(B18=\"Extra Length\",\nTRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),0)+2,\"# ??/16\"))&\"″\",\nIF(B18=\"Extra Length TT\",\nTRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),0)+2,\"# ??/16\"))&\"″ TT\",\n\"\"))))","v":""}]
["S.S. Track Length",{"$f":"IF(ISNUMBER(SEARCH(\"Cut To Size\", B18)),\n   TRIM(TEXT(VALUE(TRIM(LEFT(B9, FIND(\"x\", B9)-1))), \"# ??/16\")) & \"″ \" & IF(ISNUMBER(SEARCH(\"TT\", B18)), \"(3)\", \"(2)\"),\nIF(ISNUMBER(SEARCH(\"Extra Length\", B18)),\n   TRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9, FIND(\"x\", B9)-1))), 0) + 2, \"# ??/16\")) & \"″ \" & IF(ISNUMBER(SEARCH(\"TT\", B18)), \"(3)\", \"(2)\"),\n\"\"))","v":""}]
["Mutin Bars?",{"$f":"'Control Sheet'!H18","v":0}]
["Total Mutin Bars",{"$f":"'Control Sheet'!I18","v":0}]
["Mutin Bar Width",{"$f":"IF($B$22=\"Yes\",\n   IF($B$8=1000,\n      TEXT(((VALUE(LEFT($B$9, FIND(\"x\",$B$9)-1)) - (2 + ($B$7-2)*0.25)) / $B$7 - 0.75), \"# ?/16\") & \"″\",\n   IF($B$8=2000,\n      \"cut to size\",\n   IF($B$8=3000,\n      TEXT(((VALUE(LEFT($B$9, FIND(\"x\",$B$9)-1)) - (7.5 + ($B$7-2)*2.25)) / $B$7 - 0.75), \"# ?/16\") & \"″\",\n   \"\"))),\n\"\")","v":""}]
["Cut Sheet Comments"]
[{"$f":"'Control Sheet'!A33","v":0}]

{"sheet":"Cut Sheet 3","index":3,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[[24,0,24,1],[25,0,28,1]]}
["Date",{"$f":"Invoice!G2","v":"00:00:00"}]
["Order #",{"$f":"Invoice!G1","v":0}]
["Customer",{"$f":"Invoice!B8","v":0}]
["Purchase Order #",{"$f":"Invoice!G4","v":0}]
["Column1","Column2"]
["Item",3]
["# Of Panels",{"$f":"'Control Sheet'!B19","v":0}]
["Style",{"$f":"'Control Sheet'!C19","v":0}]
["Size",{"$f":"'Control Sheet'!D19","v":0}]
["Color",{"$f":"'Control Sheet'!E19","v":0}]
["Mirror Type",{"$f":"'Control Sheet'!F19","v":0}]
["Mirror size",{"$f":"IF($B$8=1000,\n  TEXT(\n    (VALUE(LEFT($B$9,FIND(\"x\",$B$9)-1))\n     - (2 + ($B$7-2)*0.25)\n    ) / $B$7,\n    \"# ?/16\"\n  )&CHAR(34)&\" x \"&\n  TEXT(\n    IF(\n      $B$22=\"Yes\",\n      (VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-6-$B$23*1.25)/($B$23+1),\n      VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-6\n    ),\n    \"# ?/16\"\n  )&CHAR(34),\n\nIF($B$8=2000,\n  TEXT(\n    (VALUE(LEFT($B$9,FIND(\"x\",$B$9)-1))\n     + (1.25 + ($B$7-2)*1.375)\n    ) / $B$7,\n    \"# ?/16\"\n  )&CHAR(34)&\" x \"&\n  TEXT(\n    IF(\n      $B$22=\"Yes\",\n      (VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-2.25-$B$23*1.25)/($B$23+1),\n      VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-2.25\n    ),\n    \"# ?/16\"\n  )&CHAR(34),\n\nIF($B$8=3000,\n  TEXT(\n    (VALUE(LEFT($B$9,FIND(\"x\",$B$9)-1))\n     - (7.5 + ($B$7-2)*2.25)\n    ) / $B$7,\n    \"# ?/16\"\n  )&CHAR(34)&\" x \"&\n  TEXT(\n    IF(\n      $B$22=\"Yes\",\n      (VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-6-$B$23*1.25)/($B$23+1),\n      VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-6\n    ),\n    \"# ?/16\"\n  )&CHAR(34),\n\"\")))","v":""}]
["# Of Lites",{"$f":"IF($B$22=\"Yes\", ($B$23 + 1) * $B$7, $B$7)","v":0}]
["Rail #",{"$f":"B7*2","v":0}]
["Rail Size",{"$f":"IF(\n  $B$8=1000,\n    TEXT(\n      (\n        (VALUE(LEFT($B$9, FIND(\"x\",$B$9)-1))\n         - (2     + ($B$7-2)*0.25)\n        ) / $B$7\n        - 0.75\n      ),\n      \"# ?/16\"\n    ) & \"″\",\n\n  IF(\n    $B$8=2000,\n      \"cut to size\",\n\n    IF(\n      $B$8=3000,\n        TEXT(\n          (\n            (VALUE(LEFT($B$9, FIND(\"x\",$B$9)-1))\n             - (7.5   + ($B$7-2)*2.25)\n            ) / $B$7\n            - 0.75\n          ),\n          \"# ?/16\"\n        ) & \"″\",\n      \"\"\n    )\n  )\n)","v":""}]
["Vertical #",{"$f":"B7*2","v":0}]
["Vertical size",{"$f":"IF(\n  $B$8=1000,\n    TEXT(\n      VALUE(MID($B$9, FIND(\"x\",$B$9)+1, 99))\n      - 2,\n      \"# ?/16\"\n    )&\"″\",\n\n  IF(\n    $B$8=2000,\n      \"cut to size\",\n\n    IF(\n      $B$8=3000,\n        TEXT(\n          VALUE(MID($B$9, FIND(\"x\",$B$9)+1, 99))\n          - 2,\n          \"# ?/16\")&\"″\",\n      \"\"\n    )\n  )\n)","v":""}]
["Cut Style H&S",{"$f":"'Control Sheet'!G19","v":0}]
["Head Length",{"$f":"IF(B18=\"Cut To Size\",\nTRIM(TEXT(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),\"# ??/16\"))&\"″\",\nIF(B18=\"Cut To Size TT\",\nTRIM(TEXT(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),\"# ??/16\"))&\"″ TT\",\nIF(B18=\"Extra Length\",\nTRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),0)+2,\"# ??/16\"))&\"″\",\nIF(B18=\"Extra Length TT\",\nTRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),0)+2,\"# ??/16\"))&\"″ TT\",\n\"\"))))","v":""}]
["Sill Length",{"$f":"IF(B18=\"Cut To Size\",\nTRIM(TEXT(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),\"# ??/16\"))&\"″\",\nIF(B18=\"Cut To Size TT\",\nTRIM(TEXT(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),\"# ??/16\"))&\"″ TT\",\nIF(B18=\"Extra Length\",\nTRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),0)+2,\"# ??/16\"))&\"″\",\nIF(B18=\"Extra Length TT\",\nTRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),0)+2,\"# ??/16\"))&\"″ TT\",\n\"\"))))","v":""}]
["S.S. Track Length",{"$f":"IF(ISNUMBER(SEARCH(\"Cut To Size\", B18)),\n   TRIM(TEXT(VALUE(TRIM(LEFT(B9, FIND(\"x\", B9)-1))), \"# ??/16\")) & \"″ \" & IF(ISNUMBER(SEARCH(\"TT\", B18)), \"(3)\", \"(2)\"),\nIF(ISNUMBER(SEARCH(\"Extra Length\", B18)),\n   TRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9, FIND(\"x\", B9)-1))), 0) + 2, \"# ??/16\")) & \"″ \" & IF(ISNUMBER(SEARCH(\"TT\", B18)), \"(3)\", \"(2)\"),\n\"\"))","v":""}]
["Mutin Bars?",{"$f":"'Control Sheet'!H19","v":0}]
["Total Mutin Bars",{"$f":"'Control Sheet'!I19","v":0}]
["Mutin Bar Width",{"$f":"IF($B$22=\"Yes\",\n   IF($B$8=1000,\n      TEXT(((VALUE(LEFT($B$9, FIND(\"x\",$B$9)-1)) - (2 + ($B$7-2)*0.25)) / $B$7 - 0.75), \"# ?/16\") & \"″\",\n   IF($B$8=2000,\n      \"cut to size\",\n   IF($B$8=3000,\n      TEXT(((VALUE(LEFT($B$9, FIND(\"x\",$B$9)-1)) - (7.5 + ($B$7-2)*2.25)) / $B$7 - 0.75), \"# ?/16\") & \"″\",\n   \"\"))),\n\"\")","v":""}]
["Cut Sheet Comments"]
[{"$f":"'Control Sheet'!I33","v":0}]

{"sheet":"Cut Sheet 4","index":4,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[[24,0,24,1],[25,0,28,1]]}
["Date",{"$f":"Invoice!G2","v":"00:00:00"}]
["Order #",{"$f":"Invoice!G1","v":0}]
["Customer",{"$f":"Invoice!B8","v":0}]
["Purchase Order #",{"$f":"Invoice!G4","v":0}]
["Column1","Column2"]
["Item",4]
["# Of Panels",{"$f":"'Control Sheet'!B20","v":0}]
["Style",{"$f":"'Control Sheet'!C20","v":0}]
["Size",{"$f":"'Control Sheet'!D20","v":0}]
["Color",{"$f":"'Control Sheet'!E20","v":0}]
["Mirror Type",{"$f":"'Control Sheet'!F20","v":0}]
["Mirror size",{"$f":"IF($B$8=1000,\n  TEXT(\n    (VALUE(LEFT($B$9,FIND(\"x\",$B$9)-1))\n     - (2 + ($B$7-2)*0.25)\n    ) / $B$7,\n    \"# ?/16\"\n  )&CHAR(34)&\" x \"&\n  TEXT(\n    IF(\n      $B$22=\"Yes\",\n      (VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-6-$B$23*1.25)/($B$23+1),\n      VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-6\n    ),\n    \"# ?/16\"\n  )&CHAR(34),\n\nIF($B$8=2000,\n  TEXT(\n    (VALUE(LEFT($B$9,FIND(\"x\",$B$9)-1))\n     + (1.25 + ($B$7-2)*1.375)\n    ) / $B$7,\n    \"# ?/16\"\n  )&CHAR(34)&\" x \"&\n  TEXT(\n    IF(\n      $B$22=\"Yes\",\n      (VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-2.25-$B$23*1.25)/($B$23+1),\n      VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-2.25\n    ),\n    \"# ?/16\"\n  )&CHAR(34),\n\nIF($B$8=3000,\n  TEXT(\n    (VALUE(LEFT($B$9,FIND(\"x\",$B$9)-1))\n     - (7.5 + ($B$7-2)*2.25)\n    ) / $B$7,\n    \"# ?/16\"\n  )&CHAR(34)&\" x \"&\n  TEXT(\n    IF(\n      $B$22=\"Yes\",\n      (VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-6-$B$23*1.25)/($B$23+1),\n      VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-6\n    ),\n    \"# ?/16\"\n  )&CHAR(34),\n\"\")))","v":""}]
["# Of Lites",{"$f":"IF($B$22=\"Yes\", ($B$23 + 1) * $B$7, $B$7)","v":0}]
["Rail #",{"$f":"B7*2","v":0}]
["Rail Size",{"$f":"IF(\n  $B$8=1000,\n    TEXT(\n      (\n        (VALUE(LEFT($B$9, FIND(\"x\",$B$9)-1))\n         - (2     + ($B$7-2)*0.25)\n        ) / $B$7\n        - 0.75\n      ),\n      \"# ?/16\"\n    ) & \"″\",\n\n  IF(\n    $B$8=2000,\n      \"cut to size\",\n\n    IF(\n      $B$8=3000,\n        TEXT(\n          (\n            (VALUE(LEFT($B$9, FIND(\"x\",$B$9)-1))\n             - (7.5   + ($B$7-2)*2.25)\n            ) / $B$7\n            - 0.75\n          ),\n          \"# ?/16\"\n        ) & \"″\",\n      \"\"\n    )\n  )\n)","v":""}]
["Vertical #",{"$f":"B7*2","v":0}]
["Vertical size",{"$f":"IF(\n  $B$8=1000,\n    TEXT(\n      VALUE(MID($B$9, FIND(\"x\",$B$9)+1, 99))\n      - 2,\n      \"# ?/16\"\n    )&\"″\",\n\n  IF(\n    $B$8=2000,\n      \"cut to size\",\n\n    IF(\n      $B$8=3000,\n        TEXT(\n          VALUE(MID($B$9, FIND(\"x\",$B$9)+1, 99))\n          - 2,\n          \"# ?/16\")&\"″\",\n      \"\"\n    )\n  )\n)","v":""}]
["Cut Style H&S",{"$f":"'Control Sheet'!G20","v":0}]
["Head Length",{"$f":"IF(B18=\"Cut To Size\",\nTRIM(TEXT(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),\"# ??/16\"))&\"″\",\nIF(B18=\"Cut To Size TT\",\nTRIM(TEXT(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),\"# ??/16\"))&\"″ TT\",\nIF(B18=\"Extra Length\",\nTRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),0)+2,\"# ??/16\"))&\"″\",\nIF(B18=\"Extra Length TT\",\nTRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),0)+2,\"# ??/16\"))&\"″ TT\",\n\"\"))))","v":""}]
["Sill Length",{"$f":"IF(B18=\"Cut To Size\",\nTRIM(TEXT(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),\"# ??/16\"))&\"″\",\nIF(B18=\"Cut To Size TT\",\nTRIM(TEXT(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),\"# ??/16\"))&\"″ TT\",\nIF(B18=\"Extra Length\",\nTRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),0)+2,\"# ??/16\"))&\"″\",\nIF(B18=\"Extra Length TT\",\nTRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),0)+2,\"# ??/16\"))&\"″ TT\",\n\"\"))))","v":""}]
["S.S. Track Length",{"$f":"IF(ISNUMBER(SEARCH(\"Cut To Size\", B18)),\n   TRIM(TEXT(VALUE(TRIM(LEFT(B9, FIND(\"x\", B9)-1))), \"# ??/16\")) & \"″ \" & IF(ISNUMBER(SEARCH(\"TT\", B18)), \"(3)\", \"(2)\"),\nIF(ISNUMBER(SEARCH(\"Extra Length\", B18)),\n   TRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9, FIND(\"x\", B9)-1))), 0) + 2, \"# ??/16\")) & \"″ \" & IF(ISNUMBER(SEARCH(\"TT\", B18)), \"(3)\", \"(2)\"),\n\"\"))","v":""}]
["Mutin Bars?",{"$f":"'Control Sheet'!H20","v":0}]
["Total Mutin Bars",{"$f":"'Control Sheet'!I20","v":0}]
["Mutin Bar Width",{"$f":"IF($B$22=\"Yes\",\n   IF($B$8=1000,\n      TEXT(((VALUE(LEFT($B$9, FIND(\"x\",$B$9)-1)) - (2 + ($B$7-2)*0.25)) / $B$7 - 0.75), \"# ?/16\") & \"″\",\n   IF($B$8=2000,\n      \"cut to size\",\n   IF($B$8=3000,\n      TEXT(((VALUE(LEFT($B$9, FIND(\"x\",$B$9)-1)) - (7.5 + ($B$7-2)*2.25)) / $B$7 - 0.75), \"# ?/16\") & \"″\",\n   \"\"))),\n\"\")","v":""}]
["Cut Sheet Comments"]
[{"$f":"'Control Sheet'!A40","v":0}]

{"sheet":"Cut Sheet 5","index":5,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[[24,0,24,1],[25,0,28,1]]}
["Date",{"$f":"Invoice!G2","v":"00:00:00"}]
["Order #",{"$f":"Invoice!G1","v":0}]
["Customer",{"$f":"Invoice!B8","v":0}]
["Purchase Order #",{"$f":"Invoice!G4","v":0}]
["Column1","Column2"]
["Item",5]
["# Of Panels",{"$f":"'Control Sheet'!B21","v":0}]
["Style",{"$f":"'Control Sheet'!C21","v":0}]
["Size",{"$f":"'Control Sheet'!D21","v":0}]
["Color",{"$f":"'Control Sheet'!E21","v":0}]
["Mirror Type",{"$f":"'Control Sheet'!F21","v":0}]
["Mirror size",{"$f":"IF($B$8=1000,\n  TEXT(\n    (VALUE(LEFT($B$9,FIND(\"x\",$B$9)-1))\n     - (2 + ($B$7-2)*0.25)\n    ) / $B$7,\n    \"# ?/16\"\n  )&CHAR(34)&\" x \"&\n  TEXT(\n    IF(\n      $B$22=\"Yes\",\n      (VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-6-$B$23*1.25)/($B$23+1),\n      VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-6\n    ),\n    \"# ?/16\"\n  )&CHAR(34),\n\nIF($B$8=2000,\n  TEXT(\n    (VALUE(LEFT($B$9,FIND(\"x\",$B$9)-1))\n     + (1.25 + ($B$7-2)*1.375)\n    ) / $B$7,\n    \"# ?/16\"\n  )&CHAR(34)&\" x \"&\n  TEXT(\n    IF(\n      $B$22=\"Yes\",\n      (VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-2.25-$B$23*1.25)/($B$23+1),\n      VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-2.25\n    ),\n    \"# ?/16\"\n  )&CHAR(34),\n\nIF($B$8=3000,\n  TEXT(\n    (VALUE(LEFT($B$9,FIND(\"x\",$B$9)-1))\n     - (7.5 + ($B$7-2)*2.25)\n    ) / $B$7,\n    \"# ?/16\"\n  )&CHAR(34)&\" x \"&\n  TEXT(\n    IF(\n      $B$22=\"Yes\",\n      (VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-6-$B$23*1.25)/($B$23+1),\n      VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-6\n    ),\n    \"# ?/16\"\n  )&CHAR(34),\n\"\")))","v":""}]
["# Of Lites",{"$f":"IF($B$22=\"Yes\", ($B$23 + 1) * $B$7, $B$7)","v":0}]
["Rail #",{"$f":"B7*2","v":0}]
["Rail Size",{"$f":"IF(\n  $B$8=1000,\n    TEXT(\n      (\n        (VALUE(LEFT($B$9, FIND(\"x\",$B$9)-1))\n         - (2     + ($B$7-2)*0.25)\n        ) / $B$7\n        - 0.75\n      ),\n      \"# ?/16\"\n    ) & \"″\",\n\n  IF(\n    $B$8=2000,\n      \"cut to size\",\n\n    IF(\n      $B$8=3000,\n        TEXT(\n          (\n            (VALUE(LEFT($B$9, FIND(\"x\",$B$9)-1))\n             - (7.5   + ($B$7-2)*2.25)\n            ) / $B$7\n            - 0.75\n          ),\n          \"# ?/16\"\n        ) & \"″\",\n      \"\"\n    )\n  )\n)","v":""}]
["Vertical #",{"$f":"B7*2","v":0}]
["Vertical size",{"$f":"IF(\n  $B$8=1000,\n    TEXT(\n      VALUE(MID($B$9, FIND(\"x\",$B$9)+1, 99))\n      - 2,\n      \"# ?/16\"\n    )&\"″\",\n\n  IF(\n    $B$8=2000,\n      \"cut to size\",\n\n    IF(\n      $B$8=3000,\n        TEXT(\n          VALUE(MID($B$9, FIND(\"x\",$B$9)+1, 99))\n          - 2,\n          \"# ?/16\")&\"″\",\n      \"\"\n    )\n  )\n)","v":""}]
["Cut Style H&S",{"$f":"'Control Sheet'!G21","v":0}]
["Head Length",{"$f":"IF(B18=\"Cut To Size\",\nTRIM(TEXT(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),\"# ??/16\"))&\"″\",\nIF(B18=\"Cut To Size TT\",\nTRIM(TEXT(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),\"# ??/16\"))&\"″ TT\",\nIF(B18=\"Extra Length\",\nTRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),0)+2,\"# ??/16\"))&\"″\",\nIF(B18=\"Extra Length TT\",\nTRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),0)+2,\"# ??/16\"))&\"″ TT\",\n\"\"))))","v":""}]
["Sill Length",{"$f":"IF(B18=\"Cut To Size\",\nTRIM(TEXT(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),\"# ??/16\"))&\"″\",\nIF(B18=\"Cut To Size TT\",\nTRIM(TEXT(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),\"# ??/16\"))&\"″ TT\",\nIF(B18=\"Extra Length\",\nTRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),0)+2,\"# ??/16\"))&\"″\",\nIF(B18=\"Extra Length TT\",\nTRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),0)+2,\"# ??/16\"))&\"″ TT\",\n\"\"))))","v":""}]
["S.S. Track Length",{"$f":"IF(ISNUMBER(SEARCH(\"Cut To Size\", B18)),\n   TRIM(TEXT(VALUE(TRIM(LEFT(B9, FIND(\"x\", B9)-1))), \"# ??/16\")) & \"″ \" & IF(ISNUMBER(SEARCH(\"TT\", B18)), \"(3)\", \"(2)\"),\nIF(ISNUMBER(SEARCH(\"Extra Length\", B18)),\n   TRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9, FIND(\"x\", B9)-1))), 0) + 2, \"# ??/16\")) & \"″ \" & IF(ISNUMBER(SEARCH(\"TT\", B18)), \"(3)\", \"(2)\"),\n\"\"))","v":""}]
["Mutin Bars?",{"$f":"'Control Sheet'!H21","v":0}]
["Total Mutin Bars",{"$f":"'Control Sheet'!I21","v":0}]
["Mutin Bar Width",{"$f":"IF($B$22=\"Yes\",\n   IF($B$8=1000,\n      TEXT(((VALUE(LEFT($B$9, FIND(\"x\",$B$9)-1)) - (2 + ($B$7-2)*0.25)) / $B$7 - 0.75), \"# ?/16\") & \"″\",\n   IF($B$8=2000,\n      \"cut to size\",\n   IF($B$8=3000,\n      TEXT(((VALUE(LEFT($B$9, FIND(\"x\",$B$9)-1)) - (7.5 + ($B$7-2)*2.25)) / $B$7 - 0.75), \"# ?/16\") & \"″\",\n   \"\"))),\n\"\")","v":""}]
["Cut Sheet Comments"]
[{"$f":"'Control Sheet'!I40","v":0}]

{"sheet":"Cut Sheet 6","index":6,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[[24,0,24,1],[25,0,28,1]]}
["Date",{"$f":"Invoice!G2","v":"00:00:00"}]
["Order #",{"$f":"Invoice!G1","v":0}]
["Customer",{"$f":"Invoice!B8","v":0}]
["Purchase Order #",{"$f":"Invoice!G4","v":0}]
["Column1","Column2"]
["Item",6]
["# Of Panels",{"$f":"'Control Sheet'!B22","v":0}]
["Style",{"$f":"'Control Sheet'!C22","v":0}]
["Size",{"$f":"'Control Sheet'!D22","v":0}]
["Color",{"$f":"'Control Sheet'!E22","v":0}]
["Mirror Type",{"$f":"'Control Sheet'!F22","v":0}]
["Mirror size",{"$f":"IF($B$8=1000,\n  TEXT(\n    (VALUE(LEFT($B$9,FIND(\"x\",$B$9)-1))\n     - (2 + ($B$7-2)*0.25)\n    ) / $B$7,\n    \"# ?/16\"\n  )&CHAR(34)&\" x \"&\n  TEXT(\n    IF(\n      $B$22=\"Yes\",\n      (VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-6-$B$23*1.25)/($B$23+1),\n      VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-6\n    ),\n    \"# ?/16\"\n  )&CHAR(34),\n\nIF($B$8=2000,\n  TEXT(\n    (VALUE(LEFT($B$9,FIND(\"x\",$B$9)-1))\n     + (1.25 + ($B$7-2)*1.375)\n    ) / $B$7,\n    \"# ?/16\"\n  )&CHAR(34)&\" x \"&\n  TEXT(\n    IF(\n      $B$22=\"Yes\",\n      (VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-2.25-$B$23*1.25)/($B$23+1),\n      VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-2.25\n    ),\n    \"# ?/16\"\n  )&CHAR(34),\n\nIF($B$8=3000,\n  TEXT(\n    (VALUE(LEFT($B$9,FIND(\"x\",$B$9)-1))\n     - (7.5 + ($B$7-2)*2.25)\n    ) / $B$7,\n    \"# ?/16\"\n  )&CHAR(34)&\" x \"&\n  TEXT(\n    IF(\n      $B$22=\"Yes\",\n      (VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-6-$B$23*1.25)/($B$23+1),\n      VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-6\n    ),\n    \"# ?/16\"\n  )&CHAR(34),\n\"\")))","v":""}]
["# Of Lites",{"$f":"IF($B$22=\"Yes\", ($B$23 + 1) * $B$7, $B$7)","v":0}]
["Rail #",{"$f":"B7*2","v":0}]
["Rail Size",{"$f":"IF(\n  $B$8=1000,\n    TEXT(\n      (\n        (VALUE(LEFT($B$9, FIND(\"x\",$B$9)-1))\n         - (2     + ($B$7-2)*0.25)\n        ) / $B$7\n        - 0.75\n      ),\n      \"# ?/16\"\n    ) & \"″\",\n\n  IF(\n    $B$8=2000,\n      \"cut to size\",\n\n    IF(\n      $B$8=3000,\n        TEXT(\n          (\n            (VALUE(LEFT($B$9, FIND(\"x\",$B$9)-1))\n             - (7.5   + ($B$7-2)*2.25)\n            ) / $B$7\n            - 0.75\n          ),\n          \"# ?/16\"\n        ) & \"″\",\n      \"\"\n    )\n  )\n)","v":""}]
["Vertical #",{"$f":"B7*2","v":0}]
["Vertical size",{"$f":"IF(\n  $B$8=1000,\n    TEXT(\n      VALUE(MID($B$9, FIND(\"x\",$B$9)+1, 99))\n      - 2,\n      \"# ?/16\"\n    )&\"″\",\n\n  IF(\n    $B$8=2000,\n      \"cut to size\",\n\n    IF(\n      $B$8=3000,\n        TEXT(\n          VALUE(MID($B$9, FIND(\"x\",$B$9)+1, 99))\n          - 2,\n          \"# ?/16\")&\"″\",\n      \"\"\n    )\n  )\n)","v":""}]
["Cut Style H&S",{"$f":"'Control Sheet'!G22","v":0}]
["Head Length",{"$f":"IF(B18=\"Cut To Size\",\nTRIM(TEXT(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),\"# ??/16\"))&\"″\",\nIF(B18=\"Cut To Size TT\",\nTRIM(TEXT(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),\"# ??/16\"))&\"″ TT\",\nIF(B18=\"Extra Length\",\nTRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),0)+2,\"# ??/16\"))&\"″\",\nIF(B18=\"Extra Length TT\",\nTRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),0)+2,\"# ??/16\"))&\"″ TT\",\n\"\"))))","v":""}]
["Sill Length",{"$f":"IF(B18=\"Cut To Size\",\nTRIM(TEXT(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),\"# ??/16\"))&\"″\",\nIF(B18=\"Cut To Size TT\",\nTRIM(TEXT(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),\"# ??/16\"))&\"″ TT\",\nIF(B18=\"Extra Length\",\nTRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),0)+2,\"# ??/16\"))&\"″\",\nIF(B18=\"Extra Length TT\",\nTRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),0)+2,\"# ??/16\"))&\"″ TT\",\n\"\"))))","v":""}]
["S.S. Track Length",{"$f":"IF(ISNUMBER(SEARCH(\"Cut To Size\", B18)),\n   TRIM(TEXT(VALUE(TRIM(LEFT(B9, FIND(\"x\", B9)-1))), \"# ??/16\")) & \"″ \" & IF(ISNUMBER(SEARCH(\"TT\", B18)), \"(3)\", \"(2)\"),\nIF(ISNUMBER(SEARCH(\"Extra Length\", B18)),\n   TRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9, FIND(\"x\", B9)-1))), 0) + 2, \"# ??/16\")) & \"″ \" & IF(ISNUMBER(SEARCH(\"TT\", B18)), \"(3)\", \"(2)\"),\n\"\"))","v":""}]
["Mutin Bars?",{"$f":"'Control Sheet'!H22","v":0}]
["Total Mutin Bars",{"$f":"'Control Sheet'!I22","v":0}]
["Mutin Bar Width",{"$f":"IF($B$22=\"Yes\",\n   IF($B$8=1000,\n      TEXT(((VALUE(LEFT($B$9, FIND(\"x\",$B$9)-1)) - (2 + ($B$7-2)*0.25)) / $B$7 - 0.75), \"# ?/16\") & \"″\",\n   IF($B$8=2000,\n      \"cut to size\",\n   IF($B$8=3000,\n      TEXT(((VALUE(LEFT($B$9, FIND(\"x\",$B$9)-1)) - (7.5 + ($B$7-2)*2.25)) / $B$7 - 0.75), \"# ?/16\") & \"″\",\n   \"\"))),\n\"\")","v":""}]
["Cut Sheet Comments"]
[{"$f":"'Control Sheet'!A47","v":0}]

{"sheet":"Cut Sheet 7","index":7,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[[24,0,24,1],[25,0,28,1]]}
["Date",{"$f":"Invoice!G2","v":"00:00:00"}]
["Order #",{"$f":"Invoice!G1","v":0}]
["Customer",{"$f":"Invoice!B8","v":0}]
["Purchase Order #",{"$f":"Invoice!G4","v":0}]
["Column1","Column2"]
["Item",7]
["# Of Panels",{"$f":"'Control Sheet'!B23","v":0}]
["Style",{"$f":"'Control Sheet'!C23","v":0}]
["Size",{"$f":"'Control Sheet'!D23","v":0}]
["Color",{"$f":"'Control Sheet'!E23","v":0}]
["Mirror Type",{"$f":"'Control Sheet'!F23","v":0}]
["Mirror size",{"$f":"IF($B$8=1000,\n  TEXT(\n    (VALUE(LEFT($B$9,FIND(\"x\",$B$9)-1))\n     - (2 + ($B$7-2)*0.25)\n    ) / $B$7,\n    \"# ?/16\"\n  )&CHAR(34)&\" x \"&\n  TEXT(\n    IF(\n      $B$22=\"Yes\",\n      (VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-6-$B$23*1.25)/($B$23+1),\n      VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-6\n    ),\n    \"# ?/16\"\n  )&CHAR(34),\n\nIF($B$8=2000,\n  TEXT(\n    (VALUE(LEFT($B$9,FIND(\"x\",$B$9)-1))\n     + (1.25 + ($B$7-2)*1.375)\n    ) / $B$7,\n    \"# ?/16\"\n  )&CHAR(34)&\" x \"&\n  TEXT(\n    IF(\n      $B$22=\"Yes\",\n      (VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-2.25-$B$23*1.25)/($B$23+1),\n      VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-2.25\n    ),\n    \"# ?/16\"\n  )&CHAR(34),\n\nIF($B$8=3000,\n  TEXT(\n    (VALUE(LEFT($B$9,FIND(\"x\",$B$9)-1))\n     - (7.5 + ($B$7-2)*2.25)\n    ) / $B$7,\n    \"# ?/16\"\n  )&CHAR(34)&\" x \"&\n  TEXT(\n    IF(\n      $B$22=\"Yes\",\n      (VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-6-$B$23*1.25)/($B$23+1),\n      VALUE(MID($B$9,FIND(\"x\",$B$9)+1,99))-6\n    ),\n    \"# ?/16\"\n  )&CHAR(34),\n\"\")))","v":""}]
["# Of Lites",{"$f":"IF($B$22=\"Yes\", ($B$23 + 1) * $B$7, $B$7)","v":0}]
["Rail #",{"$f":"B7*2","v":0}]
["Rail Size",{"$f":"IF(\n  $B$8=1000,\n    TEXT(\n      (\n        (VALUE(LEFT($B$9, FIND(\"x\",$B$9)-1))\n         - (2     + ($B$7-2)*0.25)\n        ) / $B$7\n        - 0.75\n      ),\n      \"# ?/16\"\n    ) & \"″\",\n\n  IF(\n    $B$8=2000,\n      \"cut to size\",\n\n    IF(\n      $B$8=3000,\n        TEXT(\n          (\n            (VALUE(LEFT($B$9, FIND(\"x\",$B$9)-1))\n             - (7.5   + ($B$7-2)*2.25)\n            ) / $B$7\n            - 0.75\n          ),\n          \"# ?/16\"\n        ) & \"″\",\n      \"\"\n    )\n  )\n)","v":""}]
["Vertical #",{"$f":"B7*2","v":0}]
["Vertical size",{"$f":"IF(\n  $B$8=1000,\n    TEXT(\n      VALUE(MID($B$9, FIND(\"x\",$B$9)+1, 99))\n      - 2,\n      \"# ?/16\"\n    )&\"″\",\n\n  IF(\n    $B$8=2000,\n      \"cut to size\",\n\n    IF(\n      $B$8=3000,\n        TEXT(\n          VALUE(MID($B$9, FIND(\"x\",$B$9)+1, 99))\n          - 2,\n          \"# ?/16\")&\"″\",\n      \"\"\n    )\n  )\n)","v":""}]
["Cut Style H&S",{"$f":"'Control Sheet'!G23","v":0}]
["Head Length",{"$f":"IF(B18=\"Cut To Size\",\nTRIM(TEXT(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),\"# ??/16\"))&\"″\",\nIF(B18=\"Cut To Size TT\",\nTRIM(TEXT(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),\"# ??/16\"))&\"″ TT\",\nIF(B18=\"Extra Length\",\nTRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),0)+2,\"# ??/16\"))&\"″\",\nIF(B18=\"Extra Length TT\",\nTRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),0)+2,\"# ??/16\"))&\"″ TT\",\n\"\"))))","v":""}]
["Sill Length",{"$f":"IF(B18=\"Cut To Size\",\nTRIM(TEXT(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),\"# ??/16\"))&\"″\",\nIF(B18=\"Cut To Size TT\",\nTRIM(TEXT(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),\"# ??/16\"))&\"″ TT\",\nIF(B18=\"Extra Length\",\nTRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),0)+2,\"# ??/16\"))&\"″\",\nIF(B18=\"Extra Length TT\",\nTRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9,FIND(\"x\",B9)-1))),0)+2,\"# ??/16\"))&\"″ TT\",\n\"\"))))","v":""}]
["S.S. Track Length",{"$f":"IF(ISNUMBER(SEARCH(\"Cut To Size\", B18)),\n   TRIM(TEXT(VALUE(TRIM(LEFT(B9, FIND(\"x\", B9)-1))), \"# ??/16\")) & \"″ \" & IF(ISNUMBER(SEARCH(\"TT\", B18)), \"(3)\", \"(2)\"),\nIF(ISNUMBER(SEARCH(\"Extra Length\", B18)),\n   TRIM(TEXT(ROUNDUP(VALUE(TRIM(LEFT(B9, FIND(\"x\", B9)-1))), 0) + 2, \"# ??/16\")) & \"″ \" & IF(ISNUMBER(SEARCH(\"TT\", B18)), \"(3)\", \"(2)\"),\n\"\"))","v":""}]
["Mutin Bars?",{"$f":"'Control Sheet'!H23","v":0}]
["Total Mutin Bars",{"$f":"'Control Sheet'!I23","v":0}]
["Mutin Bar Width",{"$f":"IF($B$22=\"Yes\",\n   IF($B$8=1000,\n      TEXT(((VALUE(LEFT($B$9, FIND(\"x\",$B$9)-1)) - (2 + ($B$7-2)*0.25)) / $B$7 - 0.75), \"# ?/16\") & \"″\",\n   IF($B$8=2000,\n      \"cut to size\",\n   IF($B$8=3000,\n      TEXT(((VALUE(LEFT($B$9, FIND(\"x\",$B$9)-1)) - (7.5 + ($B$7-2)*2.25)) / $B$7 - 0.75), \"# ?/16\") & \"″\",\n   \"\"))),\n\"\")","v":""}]
["Cut Sheet Comments"]
[{"$f":"'Control Sheet'!I47","v":0}]

{"sheet":"Invoice","index":8,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[20,0,24,3],[0,2,0,4],[1,2,1,4],[2,2,2,4],[3,2,3,4],[4,2,4,4],[5,2,5,4],[7,1,7,6],[8,1,8,6],[9,1,9,6]]}
[null,null,"McCoy Doors & More",null,null,"Order/Quote #:",{"$f":"'Control Sheet'!B7","v":0}]
[null,null,"505 North Smith Ave. #101",null,null,"Date:",{"$f":"'Control Sheet'!B5","v":0}]
[null,null,"Corona, CA 92878",null,null,"Delivery Date:",{"$f":"'Control Sheet'!B6","v":0}]
[null,false,"Telephone: (951)393-0300",null,null,"PO #:",{"$f":"'Control Sheet'!B8","v":0}]
[null,null,"Fax: (951)393-0374"]
[null,null,"Email: Office@McCoyDoorsMore.com"]
[]
["Customer Name:",{"$f":"'Control Sheet'!B2","v":0}]
["Address:",{"$f":"'Control Sheet'!B3","v":0}]
["Contact Info:",{"$f":"'Control Sheet'!B4","v":0}]
[]
["Item #","Panels","Series","Size (in inches)","Color","Mirror","Total"]
[{"$f":"IF('Control Sheet'!D17 = \"\",\"\",'Control Sheet'!A17)","v":""},{"$f":"'Control Sheet'!B17","v":0},{"$f":"'Control Sheet'!C17","v":0},{"$f":"'Control Sheet'!D17","v":0},{"$f":"'Control Sheet'!E17","v":0},{"$f":"'Control Sheet'!F17","v":0},{"$f":"'Control Sheet'!J17","v":0}]
[{"$f":"IF('Control Sheet'!D18 = \"\",\"\",'Control Sheet'!A18)","v":""},{"$f":"'Control Sheet'!B18","v":0},{"$f":"'Control Sheet'!C18","v":0},{"$f":"'Control Sheet'!D18","v":0},{"$f":"'Control Sheet'!E18","v":0},{"$f":"'Control Sheet'!F18","v":0},{"$f":"'Control Sheet'!J18","v":0}]
[{"$f":"IF('Control Sheet'!D19 = \"\",\"\",'Control Sheet'!A19)","v":""},{"$f":"'Control Sheet'!B19","v":0},{"$f":"'Control Sheet'!C19","v":0},{"$f":"'Control Sheet'!D19","v":0},{"$f":"'Control Sheet'!E19","v":0},{"$f":"'Control Sheet'!F19","v":0},{"$f":"'Control Sheet'!J19","v":0}]
[{"$f":"IF('Control Sheet'!D20 = \"\",\"\",'Control Sheet'!A20)","v":""},{"$f":"'Control Sheet'!B21","v":0},{"$f":"'Control Sheet'!C20","v":0},{"$f":"'Control Sheet'!D20","v":0},{"$f":"'Control Sheet'!E20","v":0},{"$f":"'Control Sheet'!F20","v":0},{"$f":"'Control Sheet'!J20","v":0}]
[{"$f":"IF('Control Sheet'!D21 = \"\",\"\",'Control Sheet'!A21)","v":""},{"$f":"'Control Sheet'!B22","v":0},{"$f":"'Control Sheet'!C21","v":0},{"$f":"'Control Sheet'!D21","v":0},{"$f":"'Control Sheet'!E21","v":0},{"$f":"'Control Sheet'!F21","v":0},{"$f":"'Control Sheet'!J21","v":0}]
[{"$f":"IF('Control Sheet'!D22 = \"\",\"\",'Control Sheet'!A22)","v":""},{"$f":"'Control Sheet'!B22","v":0},{"$f":"'Control Sheet'!C22","v":0},{"$f":"'Control Sheet'!D22","v":0},{"$f":"'Control Sheet'!E22","v":0},{"$f":"'Control Sheet'!F22","v":0},{"$f":"'Control Sheet'!J22","v":0}]
[{"$f":"IF('Control Sheet'!D23 = \"\",\"\",'Control Sheet'!A23)","v":""},{"$f":"'Control Sheet'!B23","v":0},{"$f":"'Control Sheet'!C23","v":0},{"$f":"'Control Sheet'!D23","v":0},{"$f":"'Control Sheet'!E23","v":0},{"$f":"'Control Sheet'!F23","v":0},{"$f":"'Control Sheet'!J23","v":0}]
[null,null,null,null,null,"Subtotal:",{"$f":"SUM(G13:G19)","v":0}]
[{"$f":"'Control Sheet'!A26","v":0},null,null,null,null,{"$f":"\"Tax (\" & TEXT('Control Sheet'!B9 * 100, \"0.00\") & \"%)\"","v":"Tax (0.00%)"},{"$f":"G20*'Control Sheet'!B9","v":0}]
[null,null,null,null,null,"Total:",{"$f":"SUM(G20:G21)","v":0}]

{"sheet":"3000 Price Sheet","index":9,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
["40681483<80\"",471,695,508,734,null,{"$f":"LEFT(A1,6)","v":"406814"}]
["50681 60\"x80'",517,728,570,785,null,{"$f":"LEFT(A2,6)","v":"50681 "}]
["60681 72\"x80\"",555,760,621,828,null,"60681 "]
["70681843(80'",596,793,677,876,null,"706818"]
["80681963<80\"",643,822,734,916,null,"806819"]
["100681 120\"x80\"",718,"N/A",816,"N/A",null,"100681"]
["40801485<96\"",528,737,610,821,null,"408014"]
["50801603<96\"",569,776,650,859,null,"508016"]
["60801720<96",609,804,687,891,null,"608017"]
["70801 84\"x9&",645,841,733,935,null,"70801 "]
["80801965<96\"",694,875,789,972,null,"808019"]
["1008011203<96\"",773,"N/A",895,"N/A",null,"100801"]
["ax E"]
["7668 90\"x80",770,1026,860,1116]
["90681 1@8\"x80\"",837,1122,931,216]
["1066811263<80\"",904,1169,1005,1270]
["120681 144\"x80\"",973,1204,1076,1307]
["150681 1803<80\"",1105,"N/A",122,"N/A"]
["U"]
["7680 90\"x96",861,1119,985,1244]
["90801 108\"x96'",935,1172,1063,1299]
["106801 126\"x96\"",1009,1229,1135,1355]
["120801144996\"",1081,1274,123,1415]
["150801 180\"x96\"",1217,"N/A",1373,"N/A"]
["4X"]
["100681 120\"x80\"",1006,1421,1137,1552]
["120681 144\")(80\"",1109,1510,1238,1639]
["140681 168\"x80\"",1212,1571,1343,1702]
["160681 192\"x80\"",1316,1019,1435,1738]
["100801 120\"x96\"",1109,1493,1250,1633]
["120801 144996\"",1232,1554,1357,1690]
["140801 168\"x96\"",1355,1622,1511,1778]
["160801 192996\"",1461,1687,1664,1889]

{"sheet":"2000 Price Sheet","index":10,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":true,"merged":[[1,0,1,2],[13,0,13,2],[24,0,24,2]]}
[]
["2X"]
["Door Size","Product Code","Net Panel Size","Standard Size Bronze & White","Special Size Bronze & White","Standard Size Nickel &Chrome","Special Size Nickel & Chrome"]
["48\"x80\"",4068,"25\"x78\"",506,664,545,684]
["60\"x80\"",5068,"31\"x78\"",543,755,584,768]
["72\"x80\"",6068,"37\"x78\"",583,806,634,833]
["84\"x80\"",7068,"43\"x78\"",631,903,683,932]
["96\"x80\"",8068,"49\"x79\"",681,975,734,1005]
["48\"x96\"",4080,"25\"x94\"",559,757,603,789]
["60\"x96\"",5080,"31\"x94\"",610,850,646,878]
["72\"x96\"",6080,"37\"x94\"",652,941,699,969]
["84\"x96\"",7080,"43\"x94\"",699,1025,752,1090]
["96\"x96\"",8080,"49\"x94\"",747,1108,799,1141]
["3X"]
["72\"x80\"",6068,"25\"x78\"",748,988,789,1026]
["90\"x80\"",7668,"31\"x78\"",812,1098,864,1114]
["108\"x80\"",9068,"37\"x78\"",887,1229,943,1279]
["126\"x80\"",10668,"43\"x78\"",971,1361,1019,1406]
["144\"x80\"",12068,"49\"x78\"",1046,1489,1106,1538]
["72\"x96\"",6080,"25\"x94\"",821,1099,865,1136]
["90\"x96\"",7680,"31\"x94\"",899,1237,946,1277]
["108\"x96\"",9080,"37\"x94\"",980,1389,1036,1439]
["126\"x96\"",10680,"43\"x94\"",1043,1504,1114,1567]
["144\"x96\"",12080,"49\"x94\"",1122,1646,1186,1703]
["4X"]
["96\"x80\"",8068,"25\"x78\"",985,1318,1043,1370]
["120\"x80\"",10068,"31\"x78\"",1080,1480,1144,1536]
["144\"x80\"",12068,"37\"x78\"",1182,1647,1249,1707]
["168\"x80\"",14068,"43\"x78\"",1287,1830,1362,1894]
["192\"x80\"",16068,"49\"x78\"",1397,1999,1477,2074]
["96\"x96\"",8080,"25\"x94\"",1076,1459,1130,1512]
["120\"x96\"",10080,"31\"x94\"",1175,1641,1237,1699]
["144\"x96\"",12080,"37\"x94\"",1279,1827,1346,1890]
["168\"x96\"",14080,"43\"x94\"",1384,2013,1456,2074]
["192\"x96\"",16080,"49\"x94\"",1489,2198,1568,2264]

{"sheet":"1000 Price Sheet","index":11,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
[null,"moto GEMEB GNAMED MONUMENT SERÎEB"]
[null,"W)/łw.ctr-Nît P OAR!K PRON,țE","GO/","WHITE, cumn",null,"nrrrtt_)'tl CLENI. & BPI%' IFO","BRITE DIP CLEAR. & BRUSHED N 'CHEL"]
[null,null,"p DARII prototE"]
["ex","W/","W/V16•W'łr",null,"ITE","W' lepton OP $l.•oorł/"]
["40681 48*x80•",366,586,null,null,398,618]
["5068160*\\80*",422,616,null,null,457,663]
["60681 72*x80*",449,650,null,null,507,708]
["70681 84țx8ô'",488,676,null,null,561,747]
["80681 96•x80*",533,705,null,null,616,787]
["100681 120Șx80•",607,"NIA",null,null,696,"NIA"]
["40801 ô8•-x96•",401,605,null,null,474,667]
["5080 60•x96Ș",439,631,null,null,512,705]
["60801 72'x96•",478,660,null,null,548,734]
["70801 84'x96ș",512,695,null,null,593,780]
["80801 96•x96•",562,730,null,null,649,816]
["100801 1.20*x96•",640,"NIA",null,null,752,"NIA"]
["3x"]
["76681 go•x80•",606,854,null,null,693,942]
["90681 108'x80'",670,948,null,null,762,1040]
["106681 126•x80•",737,984,null,null,833,1080]
["120681 144'x80'",803,1017,null,null,904,1118]
["150681 180'xao•",931,"NIA",null,null,1045,"NIA"]
["76801 90'x96•",665,918,null,null,786,1037]
["90801 108•x96-",737,968,null,null,862,1093]
["106801 126'x96•",811,1022,null,null,931,1143]
["120801 144'x96•",879,1067,null,null,1016,1204]
["150801 180X9ć•",1012,"NIA",null,null,1163,"NUA"]
["14)("]
["100681120'*80*",786,1189,null,null,912,1316]
[120681,887,1276,null,null,1012,1401]
["14068 1 166x80-",985,1324,null,null,1113,1453]
["160681 197x80'",1088,1374,null,null,1202,1489]
["100811120%'96•",850,1224,null,null,985,1358]
["120801144'/96'",969,1282,null,null,1091,1415]
["140801 168ŕx9ł•",1089,1349,null,null,1241,1501]
["160801192•x96•",1193,1412,null,null,1388,1608]