{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["BOM Generator V2","Video Wall Display Specs"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":8,"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":"BOM Generator V2","index":0,"n_rows":110,"n_cols":22,"rows_kept":110,"cut":false,"hidden":false,"merged":[[40,2,40,3],[30,2,30,3],[31,2,31,3],[13,1,13,2],[26,5,27,5],[20,1,20,2],[19,1,19,2],[18,1,18,2],[17,1,17,2],[16,1,16,2],[21,1,21,2],[3,1,3,3],[24,1,24,4],[5,1,5,3],[10,3,11,3],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,11,2],[110,1,110,4],[33,2,33,3],[34,2,34,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[32,2,32,3],[41,2,41,3],[42,2,42,3],[35,2,35,3],[39,2,39,3],[109,2,109,4],[108,2,108,4],[107,2,107,4],[6,12,6,19],[36,2,36,3],[37,2,37,3],[38,2,38,3],[5,21,6,21],[12,1,12,2],[5,7,5,9],[13,7,13,9]]}
[]
[]
[]
[null,"LBM Modular Configurator"]
[]
[null,"Setup Inputs Here",null,null,null,null,null,"Calculated Dimensions",null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical Lengths"]
[null,"Select # Displays Wide",null,2,null,null,null,"Wall Width",{"$f":"D7*IF(D11=\"Landscape\", DW, DH)+(D7-1)*D13","v":95.440000000000012},{"$f":"I7*2.54","v":242.41760000000002},null,"Ext Req (ft)","Actual Remainder"]
[null,"Select # Displays Tall",null,2,null,null,null,"Top Height (Max)",{"$f":"CRH+IF(D11=\"Landscape\", DH, DW)/2","v":113.9},{"$f":"I8*2.54","v":289.30600000000004},null,{"$f":"IF(M26=0, M27, ROUNDUP(M22/12,0))","v":6},{"$f":"L8-M12*M9","v":6},{"$f":"M8-N12*N9","v":6},6,6,0,0,0,0,null,20]
[null,"Select Column Extender",null,"36in Extender",null,null,null,"Top Row Center Height (Max)",{"$f":"64.5+IF(D9=\"No Extender\", 0,IF(D9=\"18in Extender\", 18, 36))","v":100.5},255.27,null,"Extr L (ft):",10,9,8,7,6,5,4,3,null,28]
[null,"Select Single Sided or Double Sided",null,"Single Sided",null,null,null,"Bottom Height (Max)",{"$f":"I8-IF(D11=\"Landscape\", DH, DW)*D8-(D8-1)*D13","v":60.260000000000005},153.06040000000002,null,"Qty needed",{"$f":"ROUNDDOWN(L8/M9,0)","v":0},{"$f":"ROUNDDOWN(M8/N9,0)","v":0},{"$f":"ROUNDDOWN(N8/O9,0)","v":0},{"$f":"ROUNDDOWN(O8/P9,0)","v":0},1,0,0,{"$f":"ROUNDUP(S8/T9,0)","v":0},null,29]
[null,"Select Portrait or Landscape\nInstalation",null,"Landscape",null,null,null,"Height of Displays",{"$f":"IF(D11=\"Landscape\", DH, DW)*D8+(D8-1)*D13","v":53.64},136.2456,null,"Remainder @ QN (ft)",{"$f":"L8-M9*M10","v":6},{"$f":"M8-N9*N10","v":6},{"$f":"N8-O9*O10","v":6},6,0,0,0,{"$f":"S8-T9*T10","v":0},null,35]
[null,null,null,null,null,null,null,"Rail Length",{"$f":"L8*12","v":72},182.88,null,"Qty Used:",{"$f":"IF(ISNUMBER(MATCH(L8,V8:V13,0)), M10-1, IF(AND(0<M11,M11<M15), IF(M10>1,M10-1, 0), M10))","v":0},{"$f":"IF(AND(L8=37,E27=5),0,IF(AND(0<N11,N11<M15),IF(N10>1,N10-1,0),N10))","v":0},{"$f":"IF(AND(0<O11,O11<M15), IF(O10>1,O10-1, 0), O10)","v":0},{"$f":"IF(AND(0<P11,P11<M15), IF(P10>1,P10-1, 0), P10)","v":0},{"$f":"IF(AND(0<Q11,Q11<M15), IF(Q10>1,Q10-1, 0), Q10)","v":1},{"$f":"IF(AND(0<R11,R11<4), 0, R10)","v":0},{"$f":"IF(AND(0<S11,S11<3), 0, S10)","v":0},{"$f":"IF(0<T11, 0, T10)","v":0},null,36]
[null,"Desired Display Gap",null,0.04,null,null,null,"Total Display Weight",{"$f":"D21*D7*D8*IF(D10=\"Single Sided\", 1, 2)","v":227.6},{"$f":"I13*0.453592","v":103.2375392},null,null,null,null,null,null,null,null,null,null,null,37]
[null,"Select Display Model",null,"NEC - UN552VS",null,null,null,"*Calculations based off centered Vesa patterns",null,null,null,"in Ext Provided:",{"$f":"(M9*M12+N9*N12+O9*O12+P9*P12+Q9*Q12+R9*R12+S9*S12+T9*T12)*12","v":72},"in"]
[null,"* If your model is not listed you can enter it on the next tab.",null,null,null,null,null,null,null,null,null,"Min Extr length selected",5,"ft"]
[null,null,null,null,null,null,null,null,null,null,null,"Column Capacity",500,"lbs"]
[null,{"$f":"IF(D11=\"Landscape\", \"Display Width\", \"Display Height\")","v":"Display Width"},null,{"$f":"VLOOKUP($D$14,'Video Wall Display Specs'!$D$1:K36,7,FALSE)","v":47.7},null,null,null,null,null,null,null,"FMSFR Capacity",175,"lbs"]
[null,{"$f":"IF(D11=\"Landscape\",  \"Display Height\", \"Display Width\")","v":"Display Height"},null,{"$f":"VLOOKUP($D$14,'Video Wall Display Specs'!$D$1:K36,8,FALSE)","v":26.8},null,null,null,null,null,null,null,"Min # Columns Weight",{"$f":"ROUNDUP(D7*D8*IF(D10=\"Single Sided\", 1, 2)*D21/M16, 0)","v":1}]
[null,{"$f":"IF(D11=\"Landscape\", \"Vesa Mounting Width\", \"Vesa Mounting Height\")","v":"Vesa Mounting Width"},null,{"$f":"VLOOKUP($D$14,'Video Wall Display Specs'!$D$1:K36,3,FALSE)","v":400},null,null,null,null,null,null,null,"Min # Columns Span",{"$f":"ROUNDUP(ABS((I12-64))/96,0)+1","v":2}]
[null,{"$f":"IF(D11=\"Landscape\", \"Vesa Mounting Height\", \"Vesa Mounting Width\")","v":"Vesa Mounting Height"},null,{"$f":"VLOOKUP($D$14,'Video Wall Display Specs'!$D$1:K36,4,FALSE)","v":400},null,null,null,null,null,null,null,"Min # Columns FR Cap",{"$f":"ROUNDUP((D21*D7)/M17,0)","v":1}]
[null,"Display Weight",null,{"$f":"VLOOKUP($D$14,'Video Wall Display Specs'!$D$1:K36,6,FALSE)","v":56.9}]
[null,"VESA Mounting Screw Size",null,{"$f":"VLOOKUP($D$14,'Video Wall Display Specs'!$D$1:K36,5,FALSE)","v":6},null,null,null,null,null,null,null,"Min Rail Width",{"$f":"IF(D11=\"Landscape\", DW, DH)*(D7-1)+IF(D11=\"Landscape\", D19, D20)/25.4+2.75+(D7-1)*D13","v":66.238031496063002},"in"]
[null,null,null,null,null,null,null,null,null,null,null,"Screws Included",6,8]
[null,null,null,null,null,null,null,null,null,null,null,"Screw is M6 or M8",{"$f":"ISNUMBER(MATCH(D22,M23:N23,0))","v":true}]
[null,"Required Components"]
[null,"Component","Description",null,"QTY",null,null,null,null,null,null,"Vesa Width",{"$f":"_xlfn.NUMBERVALUE(IF(D11=\"Landscape\", D19,D20))","v":400}]
[null,"FMSFC","Bolt-Down Column",null,{"$f":"IF(I10<0, 0,MAX(M18:M20))","v":2},null,null,null,null,null,null,"Width based Rail (ft)",{"$f":"ROUNDDOWN(I7/12,0)","v":7}]
[null,"FMSFR","Row to Column Connector",null,{"$f":"IF(I10<0, 0,IF(D10=\"Single Sided\", E27*D8, 0))","v":4}]
[null,"FMSFR-B2B","B2B Row to Column Con",null,{"$f":"IF(D10=\"Single Sided\", 0, E27*D8)","v":0}]
[null,"FMSIML","MM Video Wall Interface ",null,{"$f":"IF(I10<0, 0,D7*D8*IF(D10=\"Single Sided\", 1, 2))","v":4}]
[null,"FMSIML-P","Video Wall Interface Potrait Adapter",null,{"$f":"IF(AND(D19>400,D11=\"Portrait\"),E30,0)","v":0}]
[null,"FMSHC1","Horizontal Row Connector",null,{"$f":"IF(I10<0, 0,(SUM(M12:T12)-1)*D8)","v":0}]
[null,"FMSECAP","Horizontal Rail Endcaps",null,{"$f":"IF(I10<0, 0,IF(I10<0, \"Error\",D8))","v":2}]
[null,"FMSH36","36\" Horizontal Rail",null,{"$f":"IF(I10<0, 0,T12*D8)","v":0}]
[null,"FMSH48","48\" Horizontal Rail",null,{"$f":"IF(I10<0, 0,S12*D8)","v":0}]
[null,"FMSH60","60\" Horizontal Rail",null,{"$f":"IF(I10<0,0,R12*D8)","v":0}]
[null,"FMSH72","72\" Horizontal Rail",null,{"$f":"IF(I10<0, 0,Q12*D8)","v":2}]
[null,"FMSH84","84\" Horizontal Rail",null,{"$f":"IF(I10<0, 0,P12*D8)","v":0}]
[null,"FMSH96","96\" Horizontal Rail",null,{"$f":"IF(I10<0, 0,O12*D8)","v":0}]
[null,"FMSH108","108\" Horizontal Rail",null,{"$f":"IF(I10<0, 0,N12*D8)","v":0}]
[null,"FMSH120","120\" Horizontal Rail",null,{"$f":"IF(I10<0, 0,M12*D8)","v":0}]
[null,"FCABX18","18\" column Ext",null,{"$f":"IF(I10<0, 0,IF(D9=\"18in Extender\", E27, 0))","v":0}]
[null,"FCABX36","36\" column Ext",null,{"$f":"IF(I10<0, 0,IF(D9=\"36in Extender\", E27, 0))","v":2}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Landscape"]
[null,"Portrait"]

{"sheet":"Video Wall Display Specs","index":1,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[[16,0,17,0],[19,12,21,18]]}
[null,"Manufacturer","Model","Combination","Size","Vesa Mounting Width(mm)","Vesa Mounting Height (mm)","Screw Size (mm)","Weight (lbs.)","Width (in)","Height (in)"]
[null,"NEC","UN552VS",{"$f":"B2 & \" - \" &C2","v":"NEC - UN552VS"},55,400,400,6,56.9,47.7,26.8]
[null,"NEC","UN552",{"$f":"B3 & \" - \" &C3","v":"NEC - UN552"},55,400,400,6,61.9,47.8,27]
[null,"NEC","UN552S","NEC - UN552S",55,400,400,6,56.9,47.7,26.8]
[null,"NEC","UN552V","NEC - UN552V",55,400,400,6,61.9,47.8,27]
[null,"NEC","X555UNV","NEC - X555UNV",55,400,400,6,65,47.8,26.9]
[null,"NEC","UN492VS","NEC - UN492VS",49,300,300,6,53.6,42.4,23.9]
[null,"NEC","UN492S","NEC - UN492S",49,300,300,6,53.6,42.4,23.9]
[null,"NEC","UN462VA",{"$f":"B9 & \" - \" &C9","v":"NEC - UN462VA"},46,300,300,6,45,40.200000000000003,22.7]
[null,"NEC","UN462A","NEC - UN462A",46,300,300,6,45,40.200000000000003,22.7]
[null,"Samsung","UM46N-E","Samsung - UM46N-E",46,600,400,8,34.6,40.15,22.6]
[null,"Samsung","UD46E-B","Samsung - UD46E-B",46,600,400,8,39.6,40.200000000000003,22.7]
[null,"Samsung","UH46F5","Samsung - UH46F5",46,400,400,8,29.1,40.299999999999997,22.7]
[null,"Samsung","UH55F-E","Samsung - UH55F-E",55,600,400,8,46.29,47.6,26.8]
[null,"Samsung","UD55E-B","Samsung - UD55E-B",55,600,400,8,51.3,47.8,26.9]
[null,"Planar","VM55LX-U","Planar - VM55LX-U",55,400,400,6,64,47.8,26.9]
["Enter New\nModel Info Here",null,null,{"$f":"B17 & \" - \" &C17","v":" - "}]
[null,null,null," - "]
[null,null,null," - ",null,null,null,null,null,null,null,null,"Notice!"]
[null,null,null," - ",null,null,null,null,null,null,null,null,"Maximum weight capacity of 125 lbs. (56.6 kg) per interface set.\nDisplay interfaces support up to M8 screws and only include M6 and M8 hardware in the kit."]
[null,null,null," - "]
[null,null,null," - "]
[null,null,null," - "]
[null,null,null," - "]
[null,null,null," - "]
[null,null,null," - "]
[null,null,null," - "]
[null,null,null," - "]
[null,null,null," - "]
[null,null,null," - "]
[null,null,null," - "]
[null,null,null," - "]
[null,null,null," - "]
[null,null,null," - "]
[null,null,null," - "]
[null,null,null,{"$f":"B36 & \" - \" &C36","v":" - "}]