{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Introduction","Order Sheet","Parts Descriptions","Assembly Instructions","Pricing","Drawing","Notes"],"not_rendered":{"charts":0,"images":44,"macros":1,"external_links":0,"defined_names":5,"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":"Introduction","index":0,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":false,"merged":[[35,1,35,10],[28,1,28,10],[33,1,33,10],[10,1,10,10],[14,1,14,10],[18,1,18,10],[22,1,22,10],[26,1,26,10],[30,1,30,10],[24,1,24,10],[4,1,6,10],[8,1,8,10],[12,1,12,10],[16,1,16,10],[20,1,20,10]]}
[]
[]
[]
[]
[null,"Americas Quick-Guard Fencing Configurator"]
[]
[]
[]
[null,"Introduction of Americas Quick-Guard"]
[]
[null,"Americas Quick-Guard is ABB's on-the-shelf fencing solution.\nSome of the main benefits are fast pricing, fast delivery, fast assembly and easily modified.\nIt provides a variety of posts, panels, doors and hardware kits to satisfy your basic guarding needs.\nIf this Configurator cannot satisfy your requirements, please contact your local salesperson."]
[]
[null,"How the \"Automatic Generator\" (Red) Tab Works"]
[]
[null,"Fill in the yellow mandatory and optional fields with information that applies to your application.\nOnce you've completed the form, press the \"Calculate Button\" to generate your price and bill of material which are carried forward in the other red tabs (see information on those below).\nIf there is any missing information, you will be prompted to fill in the required fields."]
[]
[null,"How the \"Manual Items\" (Red) Tab Works"]
[]
[null,"The manual tab is used for any manual modification to the generated bill of material.\nFor example, when purchasing express fencing, you may want to change some express 44x44 posts to 44x88 posts.\nOnly the yellow fields can be modified."]
[]
[null,"How the \"Order Sheet\" (Red) Tab Works"]
[]
[null,"Any modifications made to the Manual Items tab will be carried forward to this tab.\nThe yellow fields can be modified to add extra components needed if spare parts are required.\nOnce the form has been completed, press the \"Print PDF\" button to save a PDF file of the bill of materials."]
[]
[null,"How the \"Parts Descriptions\" (Blue) Tab Works"]
[]
[null,"This tab is informational only.\nUse the \"Quick Search Selection\" section to search any of the parts offered in the Americas Quick-Guard portfolio."]
[]
[null,"How the \"Assembly Instructions\" (Blue) Tab Works"]
[]
[null,"This tab is informational only and provides basic assembly instructions."]
[]
[]
[null,"Disclaimer"]
[]
[null,"Americas Quick-Guard configurator is intended to give an estimation of the price for a specific fencing solution and should not be used as a guaranteed project pricing tool. The accuracy of the result is dependent on the information that is entered into the configurator. Validation of the \"Order Sheet\" tab is recommended."]

{"sheet":"Order Sheet","index":1,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,4,1,5]]}
[]
[null,null,"Budgetary Cost:",null,{"$f":"SUM(F6:F26)","v":0}]
[]
[]
[null,"Part Number","Description","Manual Qty","Unit Cost","Total Cost"]
[0,"2TLA140034R1000","Kit for end post",0,{"$f":"VLOOKUP(B6,Pricing[],3,FALSE)","v":0},{"$f":"IF(E6=\"\",0,E6*D6)","v":0}]
[1,"2TLA140034R1100","Kit for inside post",7,{"$f":"VLOOKUP(B7,Pricing[],3,FALSE)","v":0},{"$f":"IF(E7=\"\",0,E7*D7)","v":0}]
[2,"2TLA140034R1200","Kit for corner post",3,{"$f":"VLOOKUP(B8,Pricing[],3,FALSE)","v":0},0]
[3,"2TLA140034R1300","Kit for inside post 44x88",0,{"$f":"VLOOKUP(B9,Pricing[],3,FALSE)","v":0},0]
[4,"2TLA140034R1400","Kit for Express Door",0,{"$f":"VLOOKUP(B10,Pricing[],3,FALSE)","v":0},0]
[5,"2TLA140034R1500","Kit for Std Door at end",0,{"$f":"VLOOKUP(B11,Pricing[],3,FALSE)","v":0},0]
[6,"2TLA140034R1600","Kit for Std Door on inside",0,{"$f":"VLOOKUP(B12,Pricing[],3,FALSE)","v":0},0]
[7,"2TLA140034R1700","Kit for Std Door in corner",1,{"$f":"VLOOKUP(B13,Pricing[],3,FALSE)","v":0},0]
[8,"2TLA140037R1000","44x44mm Post",10,{"$f":"VLOOKUP(B14,Pricing[],3,FALSE)","v":0},0]
[9,"2TLA140037R1100","44x88mm Post",0,{"$f":"VLOOKUP(B15,Pricing[],3,FALSE)","v":0},0]
[10,"2TLA140037R3000","Mesh Door",1,{"$f":"VLOOKUP(B16,Pricing[],3,FALSE)","v":0},0]
[11,"2TLA140037R3100","Polycarb Door",0,{"$f":"VLOOKUP(B17,Pricing[],3,FALSE)","v":0},0]
[12,"2TLA140039R1000","Standard Polycarb Panel",0,{"$f":"VLOOKUP(B18,Pricing[],3,FALSE)","v":0},0]
[13,"2TLA140039R1100","Standard Polycarb Filler Panel",0,{"$f":"VLOOKUP(B19,Pricing[],3,FALSE)","v":0},0]
[14,"2TLA140039R3000","Express Polycarb Panel",0,{"$f":"VLOOKUP(B20,Pricing[],3,FALSE)","v":0},0]
[15,"2TLA140039R3100","Express Polycarb Filler Panel",0,{"$f":"VLOOKUP(B21,Pricing[],3,FALSE)","v":0},0]
[16,"2TLA140040R1000","Standard Mesh Panel",9,{"$f":"VLOOKUP(B22,Pricing[],3,FALSE)","v":0},0]
[17,"2TLA140040R1100","Standard Mesh Filler Panel",1,{"$f":"VLOOKUP(B23,Pricing[],3,FALSE)","v":0},0]
[18,"2TLA140040R3000","Express Mesh Panel",0,{"$f":"VLOOKUP(B24,Pricing[],3,FALSE)","v":0},0]
[19,"2TLA140040R3100","Express Mesh Filler Panel",0,{"$f":"VLOOKUP(B25,Pricing[],3,FALSE)","v":0},0]
[20,"2TLA140034R1800","Kit for T Post",0,{"$f":"VLOOKUP(B26,Pricing[],3,FALSE)","v":0},0]

{"sheet":"Parts Descriptions","index":2,"n_rows":6,"n_cols":28,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,7,1,27],[1,1,1,2]]}
[]
[null,"Quick Search Section",null,null,null,null,null,"Full Parts List"]
[null,"Part Number","2TLA140034R1000",null,null,null,null,"Part Number","2TLA140034R1000","2TLA140034R1100","2TLA140034R1200","2TLA140034R1300","2TLA140034R1400","2TLA140034R1500","2TLA140034R1600","2TLA140034R1700","2TLA140037R1000","2TLA140037R1100","2TLA140037R3000","2TLA140037R3100","2TLA140039R1000","2TLA140039R1100","2TLA140039R3000","2TLA140039R3100","2TLA140040R1000","2TLA140040R1100","2TLA140040R3000","2TLA140040R3100"]
[null,"Description",{"$f":"IF(OR(C3=\"* Please Select * \",C3=\"\"),\"\",HLOOKUP(C3,I3:AB6,2,FALSE))","v":"Kit for end post"},null,null,null,null,"Description","Kit for end post","Kit for inside post","Kit for corner post","Kit for inside post 44x88","Kit for Express Door","Kit for Std Door at end","Kit for Std Door on inside","Kit for Std Door in corner","44x44mm Post\nSize: 2000mm","44x88mm Post\nH = 2000mm","Mesh Door\nH = 2000mm // W = 914mm\nSweep = 152mm","Polycarb Door\nH = 2000mm // W = 914mm\nSweep = 152mm","Standard Polycarb Panel\nH = 1848mm // W = 1219mm\nSweep = 152mm","Standard Polycarb Filler Panel\nH = 1848mm // W = 261mm\nSweep = 152mm","Express Polycarb Panel\nH = 1833mm // W = 1219mm\nSweep = 152mm","Express Polycarb Filler Panel\nH = 1833mm // W = 261mm\nSweep = 152mm","Standard Mesh Panel\nH = 1848mm // W = 1474mm\nSweep = 152mm","Standard Mesh Filler Panel\nH = 1848mm // W = 516mm\nSweep = 152mm","Express Mesh Panel\nH = 1843mm // W = 1474mm\nSweep = 152mm","Express Mesh Filler Panel\nH = 1843mm // W = 516mm\nSweep = 152mm"]
[null,"Items",{"$f":"IF(OR(C3=\"* Please Select * \",C3=\"\"),\"\",HLOOKUP(C3,I3:AB6,3,FALSE))","v":"3 x L-brackets"},null,null,null,null,"Items","3 x L-brackets","3 x T-brackets","4 x L-brackets \n1 x angle bracket","2 x T-brackets \n2 x angle brackets","4 x L-brackets","2 x T-brackets \n3 x L-brackets","4 x T-brackets \n2 x L-brackets","2 x T-brackets \n4 x L-brackets \n1 x angle bracket","1 x 44x44 extrusion \n2 x floor brackets","1 x 44x88 extrusion \n2 x floor brackets","1 x Mesh door \nDoor accessories \n2 x 44x44 extusions\nMagnetic latch","1 x Poly door \nDoor accessories \n2 x 44x44 extusions\nMagnetic latch","1 x Poly panel \n2 x 44x44 extrusions \n8 x panel locks","1 x Poly panel\n2 x 44x44 extrusions\n6 x panel locks","1 x Poly panel\n2 x U-channel extrusion \n6 x panel locks \n2 x support screws","1 x Poly panel\n2 x U-channel extrusion \n6 x panel locks \n2 x support screws","1 x Mesh panel\n2 x 44x44 extrusion \n12 x netlocks","1 x Mesh panel\n2 x 44x44 extrusion \n12 x netlocks","1 x Mesh \n1 x U-channel extrusion \n1 x H-channel extrusion \n8 x netlocks \n2 x support screws","1 x Mesh panel\n1 x U-channel extrusion \n1 x H-channel extrusion \n8 x netlocks \n2 x support screws"]
[null,"Drawing",null,null,null,null,null,"Drawing",null," "]

{"sheet":"Assembly Instructions","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Pricing","index":4,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Part Number","Description","End User Price","List Price USD",null,"Option","%"]
[null,"2TLA140034R1000","Kit --> for end pole",{"$f":"Pricing[[#This Row],[List Price USD]]+IF($H$3>0,(Pricing[[#This Row],[List Price USD]]*$H$3),0)-IF($H$4>0,((Pricing[[#This Row],[List Price USD]]*$H$4)),0)","v":0},null,null,"Markup:"]
[null,"2TLA140034R1100","Kit --> for inside pole",{"$f":"Pricing[[#This Row],[List Price USD]]+IF($H$3>0,(Pricing[[#This Row],[List Price USD]]*$H$3),0)-IF($H$4>0,((Pricing[[#This Row],[List Price USD]]*$H$4)),0)","v":0},null,null,"Discount:"]
[null,"2TLA140034R1200","Kit --> for corner pole",{"$f":"Pricing[[#This Row],[List Price USD]]+IF($H$3>0,(Pricing[[#This Row],[List Price USD]]*$H$3),0)-IF($H$4>0,((Pricing[[#This Row],[List Price USD]]*$H$4)),0)","v":0}]
[null,"2TLA140034R1300","Kit --> for inside pole 44x88",{"$f":"Pricing[[#This Row],[List Price USD]]+IF($H$3>0,(Pricing[[#This Row],[List Price USD]]*$H$3),0)-IF($H$4>0,((Pricing[[#This Row],[List Price USD]]*$H$4)),0)","v":0}]
[null,"2TLA140034R1400","Kit --> for Express Door",{"$f":"Pricing[[#This Row],[List Price USD]]+IF($H$3>0,(Pricing[[#This Row],[List Price USD]]*$H$3),0)-IF($H$4>0,((Pricing[[#This Row],[List Price USD]]*$H$4)),0)","v":0}]
[null,"2TLA140034R1500","Kit --> for Std Door at end",{"$f":"Pricing[[#This Row],[List Price USD]]+IF($H$3>0,(Pricing[[#This Row],[List Price USD]]*$H$3),0)-IF($H$4>0,((Pricing[[#This Row],[List Price USD]]*$H$4)),0)","v":0}]
[null,"2TLA140034R1600","Kit --> for Std Door on inside",{"$f":"Pricing[[#This Row],[List Price USD]]+IF($H$3>0,(Pricing[[#This Row],[List Price USD]]*$H$3),0)-IF($H$4>0,((Pricing[[#This Row],[List Price USD]]*$H$4)),0)","v":0}]
[null,"2TLA140034R1700","Kit --> for Std Door in corner",{"$f":"Pricing[[#This Row],[List Price USD]]+IF($H$3>0,(Pricing[[#This Row],[List Price USD]]*$H$3),0)-IF($H$4>0,((Pricing[[#This Row],[List Price USD]]*$H$4)),0)","v":0}]
[null,"2TLA140037R1000","Pole --> 44x44",{"$f":"Pricing[[#This Row],[List Price USD]]+IF($H$3>0,(Pricing[[#This Row],[List Price USD]]*$H$3),0)-IF($H$4>0,((Pricing[[#This Row],[List Price USD]]*$H$4)),0)","v":0}]
[null,"2TLA140037R1100","Pole --> 44x88",{"$f":"Pricing[[#This Row],[List Price USD]]+IF($H$3>0,(Pricing[[#This Row],[List Price USD]]*$H$3),0)-IF($H$4>0,((Pricing[[#This Row],[List Price USD]]*$H$4)),0)","v":0}]
[null,"2TLA140037R3000","Door --> Mesh",{"$f":"Pricing[[#This Row],[List Price USD]]+IF($H$3>0,(Pricing[[#This Row],[List Price USD]]*$H$3),0)-IF($H$4>0,((Pricing[[#This Row],[List Price USD]]*$H$4)),0)","v":0}]
[null,"2TLA140037R3100","Door --> Poly",{"$f":"Pricing[[#This Row],[List Price USD]]+IF($H$3>0,(Pricing[[#This Row],[List Price USD]]*$H$3),0)-IF($H$4>0,((Pricing[[#This Row],[List Price USD]]*$H$4)),0)","v":0}]
[null,"2TLA140039R1000","Panel --> Poly + Std",{"$f":"Pricing[[#This Row],[List Price USD]]+IF($H$3>0,(Pricing[[#This Row],[List Price USD]]*$H$3),0)-IF($H$4>0,((Pricing[[#This Row],[List Price USD]]*$H$4)),0)","v":0}]
[null,"2TLA140039R1100","Panel --> Poly + Std + Small",{"$f":"Pricing[[#This Row],[List Price USD]]+IF($H$3>0,(Pricing[[#This Row],[List Price USD]]*$H$3),0)-IF($H$4>0,((Pricing[[#This Row],[List Price USD]]*$H$4)),0)","v":0}]
[null,"2TLA140039R3000","Panel --> Poly + Express",{"$f":"Pricing[[#This Row],[List Price USD]]+IF($H$3>0,(Pricing[[#This Row],[List Price USD]]*$H$3),0)-IF($H$4>0,((Pricing[[#This Row],[List Price USD]]*$H$4)),0)","v":0}]
[null,"2TLA140039R3100","Panel --> Poly + Express + Small",{"$f":"Pricing[[#This Row],[List Price USD]]+IF($H$3>0,(Pricing[[#This Row],[List Price USD]]*$H$3),0)-IF($H$4>0,((Pricing[[#This Row],[List Price USD]]*$H$4)),0)","v":0}]
[null,"2TLA140040R1000","Panel --> Mesh + Std",{"$f":"Pricing[[#This Row],[List Price USD]]+IF($H$3>0,(Pricing[[#This Row],[List Price USD]]*$H$3),0)-IF($H$4>0,((Pricing[[#This Row],[List Price USD]]*$H$4)),0)","v":0}]
[null,"2TLA140040R1100","Panel --> Mesh + Std + Small",{"$f":"Pricing[[#This Row],[List Price USD]]+IF($H$3>0,(Pricing[[#This Row],[List Price USD]]*$H$3),0)-IF($H$4>0,((Pricing[[#This Row],[List Price USD]]*$H$4)),0)","v":0}]
[null,"2TLA140040R3000","Panel --> Mesh + Express",{"$f":"Pricing[[#This Row],[List Price USD]]+IF($H$3>0,(Pricing[[#This Row],[List Price USD]]*$H$3),0)-IF($H$4>0,((Pricing[[#This Row],[List Price USD]]*$H$4)),0)","v":0}]
[null,"2TLA140040R3100","Panel --> Mesh + Express + Small",{"$f":"Pricing[[#This Row],[List Price USD]]+IF($H$3>0,(Pricing[[#This Row],[List Price USD]]*$H$3),0)-IF($H$4>0,((Pricing[[#This Row],[List Price USD]]*$H$4)),0)","v":0}]
[null,"2TLA140034R1800","Kit --> for T post",{"$f":"Pricing[[#This Row],[List Price USD]]+IF($H$3>0,(Pricing[[#This Row],[List Price USD]]*$H$3),0)-IF($H$4>0,((Pricing[[#This Row],[List Price USD]]*$H$4)),0)","v":0}]

{"sheet":"Drawing","index":5,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Corner Post","Panel","Inside Post","Panel","Corner Post"]
["Panel",null,null,null,"Corner Door"]
["Inside Post",null,null,null,"Inside Post"]
["Panel",null,null,null,"Panel"]
["Inside Post",null,null,null,"Inside Post"]
["Panel",null,null,null,"Panel"]
["Corner Post","Panel","Inside Post","Panel","Corner Post"]

{"sheet":"Notes","index":6,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":true,"merged":[[0,1,0,4]]}
[null,"Drop-down List"]
[null,"Type of Fencing","Type of Infill","Unit of measure","Parts"]
[null,"* Please Select * ","* Please Select * ","* Please Select * ","* Please Select * "]
[null,"Standard","Mesh","Meters","2TLA140034R1000"]
[null,"Express","Polycarb","Millimeters","2TLA140034R1100"]
[null,null,null,"Feet","2TLA140034R1200"]
[null,null,null,"Inches","2TLA140034R1300"]
[null,null,null,null,"2TLA140034R1400"]
[null,null,null,null,"2TLA140034R1500"]
[null,null,null,null,"2TLA140034R1600"]
[null,null,null,null,"2TLA140034R1700"]
[null,null,null,null,"2TLA140037R1000"]
[null,null,null,null,"2TLA140037R1100"]
[null,null,null,null,"2TLA140037R3000"]
[null,null,null,null,"2TLA140037R3100"]
[null,null,null,null,"2TLA140039R1000"]
[null,null,null,null,"2TLA140039R1100"]
[null,null,null,null,"2TLA140039R3000"]
[null,null,null,null,"2TLA140039R3100"]
[null,null,null,null,"2TLA140040R1000"]
[null,null,null,null,"2TLA140040R1100"]
[null,null,null,null,"2TLA140040R3000"]
[null,null,null,null,"2TLA140040R3100"]