{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Straights","Fittings","Results","Reference Data"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":2,"defined_names":32,"comments":1,"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":"Straights","index":0,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,1,30,13],[28,2,28,14],[29,2,29,14],[26,2,26,14],[9,0,9,4],[27,2,27,14],[10,0,10,4],[11,0,11,4],[12,0,12,4],[13,0,13,4],[1,2,1,14],[2,2,2,14],[3,2,3,14],[7,0,7,4],[8,0,8,4],[8,8,8,12],[7,8,7,12],[4,4,4,8],[5,4,5,6]]}
[]
[null,null,"Eaton's B-Line Business KwikSplice™ Cable Tray Savings Calculator"]
[null,null,"Optimizing Support Spans and Minimizing Labor Costs"]
[null,null,"The purpose of this calculator is to demonstrate total cost differences between B-Line's KwikSplice™ cable tray and other cable management methods.  This sheet focuses on differences in material costs, labor costs associated with straight sections, and possible support structure cost savings."]
["Instructions:",null,null,null,"Make changes in yellow shaded areas for specified project."]
[null,null,null,null,"Select choice from blue drop down menus."]
[]
["Labor Rate ($/hr)",null,null,null,null,null,100,null,"Wirebasket Splice Method (if applicable)",null,null,null,null,null,"WASHER SPL KIT"]
["Cable Tray Straight Run Length (ft)",null,null,null,null,null,1000,null,"Welded Cable Tray Splice Hardware Quantity (per splice)",null,null,null,null,null,4]
["Support Install Time (minutes) **",null,null,null,null,null,30]
["Cable Management Comparison Type",null,null,null,null,null,"Wirebasket"]
[{"$f":"\"Select \" &G11&\" Height (Inches)\"","v":"Select Wirebasket Height (Inches)"},null,null,null,null,null,4]
[{"$f":"\"Select \" &G11&\" Width (Inches)\"","v":"Select Wirebasket Width (Inches)"},null,null,null,null,null,24,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Reference Data'!T17","v":"W4"}]
[{"$f":"\"Select \" &G11&\" Length (Feet)\"","v":"Select Wirebasket Length (Feet)"},null,null,null,null,null,10]
[]
["Splice Location\nMaterial/Labor Savings",null,"Splice Location\nQuantity",null,"Straight Section Splice Quantity ",null,"Time Per Splice\n(Minutes) ***",null,"Labor Cost Per Splice Location",null,"Material Cost Per Splice Location *",null,null,null,"Splice Material and Labor Cost",null,null,"Splice Material and\n Labor Savings"]
[{"$f":"IF(G11=\"Wirebasket\",'Reference Data'!A2,'Reference Data'!B2)","v":"FT4X24X10"},null,{"$f":"ROUNDUP(G9/G14,0)","v":100},null,{"$f":"IF(G11=\"Wirebasket\",IF(O8='Reference Data'!B5,VLOOKUP('Reference Data'!A2,'Reference Data'!A5:E31,2,FALSE),IF(O8='Reference Data'!C5,VLOOKUP('Reference Data'!A2,'Reference Data'!A5:E31,3,FALSE),IF(O8='Reference Data'!D5,VLOOKUP('Reference Data'!A2,'Reference Data'!A5:E31,4,FALSE),IF(O8='Reference Data'!E5,VLOOKUP('Reference Data'!A2,'Reference Data'!A5:E31,5,2),0)))),2)","v":8},null,{"$f":"IF(G11=\"Wirebasket\",(IF(O8='Reference Data'!A42,'Reference Data'!B42,IF(O8='Reference Data'!A43,'Reference Data'!B43,IF(O8='Reference Data'!A44,'Reference Data'!B44,IF(O8='Reference Data'!A45,'Reference Data'!B45,FALSE))))),'Reference Data'!B56)","v":0.5},null,{"$f":"IF(OR(E17=(Straights!B3),E17=('Reference Data'!D11)),0,(((E17*G17)/60)*G8))","v":6.666666666666667},null,{"$f":"IF(G11=\"Wirebasket\",(IF(O8='Reference Data'!A42,2.3*E17,IF(O8='Reference Data'!A43,2.8*E17,IF(O8='Reference Data'!A44,0.7*E17,IF(O8='Reference Data'!A45,2.4*E17,FALSE))))),0)","v":18.399999999999999},null,null,null,{"$f":"IF(OR(E17='Reference Data'!B6,E17='Reference Data'!D11),(I17*C17),(I17*C17)+(K17*C17))","v":2506.6666666666665}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(E17='Reference Data'!B6,E17='Reference Data'!D11),\"Reselect Proper Splice\",O17-O19)","v":2226.6666666666665}]
["Kwik-Splice Cable Tray",null,{"$f":"ROUNDUP(G9/G25,0)","v":84},null,2,null,{"$f":"'Reference Data'!B55","v":1},null,{"$f":"(((E19*G19)/60)*G8)","v":3.3333333333333335},null,0,null,null,null,{"$f":"(I19*C19)+(K19*E19*C19)","v":280}]
[]
["Support Structure Savings",null,null,null,"Tray Price \nper Foot *",null,"Support \nSpan (ft)",null,"Individual Support Cost **",null,"Number of Supports Required",null,"Labor  Per \nSupport Location",null,"Cable Tray\n & Support Cost",null,null,"Cable Tray Material and\n Support Savings"]
[]
[{"$f":"IF(G11=\"Wirebasket\",'Reference Data'!A2,'Reference Data'!B2)","v":"FT4X24X10"},null,null,null,4,null,5,null,75,null,{"$f":"(G9/G23)","v":200},null,{"$f":"G8*G10/60","v":50},"=",{"$f":"(G9*E23)+(K23*(I23+M23))","v":29000},null,null,{"$f":"O23-O25","v":14333.333333333334}]
[]
["Kwik-Splice Cable Tray",null,null,null,4.25,null,12,null,75,null,{"$f":"(G9/G25)","v":83.333333333333329},null,{"$f":"G8*G10/60","v":50},"=",{"$f":"(G9*E25)+(K25*(I25+M25))","v":14666.666666666666}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Savings"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R18=\"Reselect Proper Splice\",R23,R23+R18)","v":16560}]
[null,null,"Include linear footage calculated for fittings in Cable Tray Project Length.  Material cost difference factors are assumed to be the same across fittings and straight sections (excluding labor).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(IF(R27>=0,\"KwikSplice\",A23)&\" IS\"&\" BEST\"&\" OPTION\")","v":"KwikSplice IS BEST OPTION"}]
["*  ",null,"One pair of splice plates are included in the price of a straight section of Kwik Splice Cable Tray.  Wirebasket splicing accessories are sold seperately."]
["**  ",null,"Indoor support includes anchors, threaded rod, trapeze structure (strut commonly used), hold down clamps, etc.  Outdoor supports include structural steel support columns.  Be sure to add support labor cost to material cost of each support (See support and Splice Install Time input cells).  This will make a dramatic difference to the total.  "]
["***  ","Labor rates for splicing accessories based on industry standard practice and are to be used as an estimate only."]

{"sheet":"Fittings","index":1,"n_rows":24,"n_cols":18,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,2,1,14],[2,2,2,14],[3,2,3,14],[7,0,7,4],[8,0,8,4],[7,9,7,14],[21,2,21,14],[22,1,22,14],[23,1,23,14],[10,9,10,14],[8,9,8,10],[9,0,9,4],[12,13,12,16],[19,2,19,14],[20,2,20,14],[11,9,11,11]]}
[]
[null,null,"Eaton's B-Line Business KwikSplice™ Cable Tray Savings Calculator"]
[null,null,"Fittings"]
[null,null,"The purpose of this calculator is to demonstrate total cost differences between between B-Line's KwikSplice™ cable tray and other cable management methods.  This sheet focuses on differences in labor costs associated with splicing and field fabricating fittings."]
["Instructions:",null,null,null,"Make changes in yellow shaded areas for specified project."]
[null,null,null,null,"Select choice from blue drop down menus."]
[]
["Horizontal Bends",null,null,null,null,null,30,null,null,"Radiused Bends * (applies to Wirebasket only)"]
["Horizontal Tees",null,null,null,null,null,4,null,null,"YES"]
["Horizontal Crosses",null,null,null,null,null,5]
[null,null,null,null,"Vertical Bends",null,15,null,null,"Flextray Cutting Tool ** (applies to Wirebasket only)"]
[null,null,null,null,null,null,null,null,null,"CLEANSHEAR (MANUAL)"]
[{"$f":"IF(Straights!G11=\"Wirebasket\",'Reference Data'!A2,'Reference Data'!B2)&\" SELECTED\"","v":"FT4X24X10 SELECTED"}]
[null,null," Total\nSplice Quantity",null,"Total Tray Field Cuts ",null,"Splice Installation Time (Minutes) ***",null,"Fitting Splice Labor Cost",null,"Total Field Cut Time (Minutes)",null,"Fitting Cut Labor Cost",null,"Fitting Installation Cost",null,null,"Labor Savings"]
[{"$f":"IF(Straights!G11=\"Wirebasket\",'Reference Data'!A2,'Reference Data'!B2)","v":"FT4X24X10"},null,{"$f":"A16+C16","v":960},null,{"$f":"IF(Straights!G11=\"Wirebasket\",(IF(J9='Reference Data'!A48,((G8*(VLOOKUP('Reference Data'!A2,'Reference Data'!A6:O31,7,FALSE)))+(G9*(VLOOKUP('Reference Data'!A2,'Reference Data'!A6:O31,11,FALSE)))+(G10*(VLOOKUP('Reference Data'!A2,'Reference Data'!A6:O31,13,FALSE)))+(G11*(VLOOKUP('Reference Data'!A2,'Reference Data'!A6:O31,15,FALSE)))),IF(J9='Reference Data'!A49,((G8*(VLOOKUP('Reference Data'!A2,'Reference Data'!A6:O31,9,FALSE)))+(G9*(VLOOKUP('Reference Data'!A2,'Reference Data'!A6:O31,11,FALSE)))+(G10*(VLOOKUP('Reference Data'!A2,'Reference Data'!A6:O31,13,FALSE)))+(G11*(VLOOKUP('Reference Data'!A2,'Reference Data'!A6:O31,15,FALSE))))))),0)","v":10186},null,{"$f":"IF(Straights!G11=\"Wirebasket\",(C15*(IF(Straights!O8='Reference Data'!A42,'Reference Data'!B42,IF(Straights!O8='Reference Data'!A43,'Reference Data'!B43,IF(Straights!O8='Reference Data'!A44,'Reference Data'!B42,IF(Straights!O8='Reference Data'!A45,'Reference Data'!B42,FALSE)))))),C15*'Reference Data'!B56)","v":480},null,{"$f":"(G15/60)*Straights!G8","v":800},null,{"$f":"IF(J12='Reference Data'!A51,('Reference Data'!B51)/60*Fittings!E15,IF(J12='Reference Data'!A52,('Reference Data'!B52)/60*Fittings!E15,FALSE))","v":1332.6683333333333},null,{"$f":"(K15/60)*Straights!G8","v":2221.1138888888891},null,{"$f":"M15+I15","v":3021.1138888888891}]
[{"$f":"IF(Straights!G11=\"Wirebasket\",(IF(J9='Reference Data'!A48,((G8*(VLOOKUP('Reference Data'!A2,'Reference Data'!A6:O31,6,FALSE)))+(G9*(VLOOKUP('Reference Data'!A2,'Reference Data'!A6:O31,10,FALSE)))+(G10*(VLOOKUP('Reference Data'!A2,'Reference Data'!A6:O31,12,FALSE)))+(G11*(VLOOKUP('Reference Data'!A2,'Reference Data'!A6:O31,14,FALSE)))),IF(J9='Reference Data'!A49,((G8*(VLOOKUP('Reference Data'!A2,'Reference Data'!A6:O31,8,FALSE)))+(G9*(VLOOKUP('Reference Data'!A2,'Reference Data'!A6:O31,10,FALSE)))+(G10*(VLOOKUP('Reference Data'!A2,'Reference Data'!A6:O31,12,FALSE)))+(G11*(VLOOKUP('Reference Data'!A2,'Reference Data'!A6:O31,14,FALSE))))))),Fittings!C17)","v":416},null,{"$f":"IF(Straights!G11=\"Wirebasket\",(Straights!E17*(Fittings!G8+(Fittings!G9*2)+(Fittings!G10*3)+Fittings!G11)),0)","v":544},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(E15='Reference Data'!B6,E15='Reference Data'!D11),\"Reselect Proper Splice\",O15-O17)","v":2794.4472222222225}]
["Kwik-Splice Cable Tray",null,{"$f":"(G8*2)+(G9*4)+(G10*6)+(G11*2)","v":136},null,0,null,{"$f":"C17*'Reference Data'!B55","v":136},null,{"$f":"((G17/60)*Straights!G8)","v":226.66666666666666},null,0,null,{"$f":"(K17/60)*Straights!G10","v":0},null,{"$f":"M17+I17","v":226.66666666666666}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Savings ****"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R16","v":2794.4472222222225}]
["*  ",null,"Radiused bends are based on a 12\" radius.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(IF(R20>=0,\"KwikSplice\",A15)&\" IS\"&\" BEST\"&\" OPTION\")","v":"KwikSplice IS BEST OPTION"}]
["**  ",null,"Field cutting Flextray wirebasket times are based on industry experience and are an average based on the time it takes to set up and cut through one cross sectional wire."]
["***  ","Labor rates for splicing accessories based on industry standard practice and are to be used as an estimate only. Flextray wirebasket involves all connecting hardware splices (Note: FLEXMATE2 or FTSTLC can not be used to connect fittings.  Only WASHER SPL KIT, FTSWN, or other approved splice hardware can be used to connect fittings).  Kwik Splice cable tray involves one set of splice plates and corresponding hardware needed to connect to sections of cable tray together."]
["****  ","Material Cost differences for fittings are taken into consideration on \"Straights\" sheet.  Redi-rail and Flextray fittings are assumed to be the same as straight section pricing per linear foot for simplicity purposes.  Cable tray pricing may vary."]

{"sheet":"Results","index":2,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,0,4,12],[7,0,7,12],[8,0,12,12],[13,0,13,12],[14,0,18,12]]}
["Results Overview"]
[{"$f":"IFERROR(\"Based on the variables given, choosing B-Line's KwikSplice cable tray system for your project can yield savings up to $\"&TEXT(Straights!R27,\"#,###\")&\" in labor, material and support span costs for straight sections, and up to $\"&TEXT(Fittings!R20,\"#,###\")&\" in fitting support costs for a total potential maximum savings of $\"&TEXT('Reference Data'!A64,\"#,###\")&\" on your project.\",\"Please enter values for all of the inputs to view the completed analysis.\")","v":"Based on the variables given, choosing B-Line's KwikSplice cable tray system for your project can yield savings up to $16,560 in labor, material and support span costs for straight sections, and up to $2,794 in fitting support costs for a total potential maximum savings of $19,354 on your project."}]
[]
[]
[]
["Results Details"]
[]
["Straight Section Analysis"]
[{"$f":"\"Based on the variables you selected, the total expected savings associated with purchasing and installing straight sections is $\"&TEXT(Straights!R27,\"#,###\")&\".  This consists of $\"&TEXT('[1]Cable Tray vs. Supports'!V20,\"#,###\")&\" in support savings with only a $\"&TEXT('Reference Data'!B69,\"#,###\")&\" increase in cable tray material price.\"","v":"Based on the variables you selected, the total expected savings associated with purchasing and installing straight sections is $16,560.  This consists of $ in support savings with only a $250 increase in cable tray material price."}]
[]
[]
[]
[]
["Fitting Assembly Solutions Analysis"]
[{"$f":"\"By utilizing KwikSplice cable tray, you can save $\"&TEXT(Fittings!R20,\"#,###\")&\" on this project. By eliminating the labor required to install and/or fabricate fittings, you could save $\"&TEXT(Fittings!R20,\"#,###\")&\" on this project.\"","v":"By utilizing KwikSplice cable tray, you can save $2,794 on this project. By eliminating the labor required to install and/or fabricate fittings, you could save $2,794 on this project."}]

{"sheet":"Reference Data","index":3,"n_rows":76,"n_cols":24,"rows_kept":76,"cut":false,"hidden":true,"merged":[[3,9,3,10],[3,5,3,6],[3,7,3,8],[3,11,3,12],[3,13,3,14]]}
["Flextray P/N Selection","Cable Tray P/N"]
[{"$f":"IF(Straights!G11=\"Wirebasket\",(\"FT\"&Straights!G12&\"X\"&Straights!G13&\"X10\"),FALSE)","v":"FT4X24X10"},{"$f":"IF(Straights!G11=\"Welded Cable Tray\",(Straights!G12&\"x\"&Straights!G13&\" Cable Tray\"),0)","v":0}]
[]
[null,null,null,null,null,"Radiused HB",null,"No Radius HB",null,"Horizontal Tee",null,"Horizontal Cross",null,"Vertical Bend"]
["Flextray P/N's","WASHER SPL KIT","FTSWN","FLEXMATE2","FTSTLC","Splices","Cuts","Splices","Cuts","Splices","Cuts","Splices","Cuts","Splices","Cuts",null,"Redi-Rail P/N's"]
["FT2X2x10","NC","NC","NC",2,3,{"$f":"2*3*2","v":12},1,{"$f":"2*3","v":6},2,5,{"$f":"J6*2","v":4},{"$f":"K6*2","v":10},0,4,null,"RSI","04","A","06","SL",null,"06",120]
["FT2X4x10","NC","NC","NC",2,3,{"$f":"2*4*2","v":16},1,{"$f":"2*4","v":8},2,6,{"$f":"J7*2","v":4},{"$f":"K7*2","v":12},0,4,null,null,"05",null,"09",null,"050KO","09",144]
["FT2X6x10",4,4,5,4,4,{"$f":"2*5*3","v":30},1,{"$f":"2*5","v":10},3,7,6,14,0,4,null,null,"06",null,"12",null,"075KO",12]
["FT2X8x10",4,4,5,4,5,{"$f":"2*6*4","v":48},1,{"$f":"2*6","v":12},3,8,6,16,0,4,null,null,"07",null,"VB",null,"100KO",18]
["FT2X12x10",4,4,5,4,7,{"$f":"2*8*6","v":96},1,{"$f":"2*8","v":16},4,9,8,18,0,4,null,null,null,null,"SB",null,null,24]
["FT2X16x10",4,4,"NOT RATED",4,8,{"$f":"2*10*7","v":140},3,{"$f":"2*10","v":20},4,10,8,20,0,4,null,null,null,null,null,null,null,30]
["FT2X18x10",4,4,"NOT RATED",4,9,{"$f":"2*11*7","v":154},3,{"$f":"2*11","v":22},4,11,8,22,0,4,null,null,null,null,null,null,null,36]
["FT2X20x10",5,5,"NOT RATED",5,11,{"$f":"2*12*10","v":240},3,{"$f":"2*12","v":24},4,11,8,22,0,4]
["FT2X24x10",5,5,"NOT RATED",5,12,{"$f":"2*14*11","v":308},3,{"$f":"2*14","v":28},4,12,8,24,0,4]
["FT2X30x10",6,6,"NOT RATED",6,14,{"$f":"2*17*13","v":442},4,{"$f":"2*17","v":34},5,13,10,26,0,4]
["FT2X32x10",6,6,"NOT RATED",6,14,{"$f":"2*18*13","v":468},4,{"$f":"2*18","v":36},5,13,10,26,0,4]
["FT4X4x10",4,4,5,4,3,{"$f":"2*5*2","v":20},1,{"$f":"2*5","v":10},2,8,4,16,0,6,null,null,null,{"$f":"IF(Straights!G11=\"Wirebasket\",\"W\",(IF(Straights!G11=\"Welded Cable Tray\",\"CT\",FALSE)))","v":"W"},{"$f":"S17&S18&\"\"","v":"W4"}]
["FT4X6x10",5,5,6,5,4,{"$f":"2*6*3","v":36},1,{"$f":"2*6","v":12},3,9,6,18,0,6,null,null,null,{"$f":"IF(Straights!G12=2,\"2\",(IF(Straights!G12=4,\"4\",(IF(Straights!G12=5,\"5\",(IF(Straights!G12=6,\"6\",FALSE)))))))","v":"4"}]
["FT4X8x10",6,6,7,6,5,{"$f":"2*7*4","v":56},1,{"$f":"2*7","v":14},3,10,6,20,0,6,null,2]
["FT4X12x10",6,6,7,6,7,{"$f":"2*9*6","v":108},1,{"$f":"2*9","v":18},4,11,8,22,0,6,null,4]
["FT4X16x10",7,7,"NOT RATED",7,8,{"$f":"2*11*7","v":154},3,{"$f":"2*11","v":22},4,12,8,24,0,6,null,6]
["FT4X18x10",7,7,"NOT RATED",7,9,{"$f":"2*12*7","v":168},3,{"$f":"2*12","v":24},4,13,8,26,0,6,null,"W2",null,"W4",null,"W6"]
["FT4X20x10",7,7,"NOT RATED",7,11,{"$f":"2*13*10","v":260},3,{"$f":"2*13","v":26},4,13,8,26,0,6,null,"Wirebasket Height","Widths","Wirebasket Height","Widths","Wirebasket Height","Widths","Length"]
["FT4X24x10",8,8,"NOT RATED",8,12,{"$f":"2*15*11","v":330},3,{"$f":"2*15","v":30},4,14,8,28,0,6,null,2,2,4,4,6,8,10]
["FT4X30x10",9,9,"NOT RATED",9,14,{"$f":"2*18*13","v":468},4,{"$f":"2*18","v":36},5,15,10,30,0,6,null,null,4,null,6,null,12]
["FT6X8x10",6,6,7,6,5,{"$f":"2*8*4","v":64},1,{"$f":"2*8","v":16},3,12,6,24,0,8,null,null,6,null,8,null,16]
["FT6X12x10",6,6,7,6,7,{"$f":"2*10*6","v":120},1,{"$f":"2*10","v":20},4,13,8,26,0,8,null,null,8,null,12,null,18]
["FT6X16x10",7,7,"NOT RATED",7,8,{"$f":"2*12*7","v":168},3,{"$f":"2*12","v":24},4,14,8,28,0,8,null,null,12,null,16,null,20]
["FT6X18x10",7,7,"NOT RATED",7,9,{"$f":"2*13*7","v":182},3,{"$f":"2*13","v":26},4,15,8,30,0,8,null,null,16,null,18,null,24]
["FT6X20x10",7,7,"NOT RATED",7,11,{"$f":"2*14*10","v":280},3,{"$f":"2*14","v":28},4,15,8,30,0,8,null,null,18,null,20]
["FT6X24x10",8,8,"NOT RATED",8,12,{"$f":"2*16*11","v":352},3,{"$f":"2*16","v":32},4,16,8,32,0,8,null,null,20,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32]
["Flextray Support Span",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CT4",null,"CT5",null,"CT6"]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cable Tray Height",null,"Cable Tray Height",null,"Cable Tray Height",null,"Length"]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4",6,"5",6,"6",6,10]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5",9,null,9,null,9,12]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6",12,null,12,null,12,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,null,18,null,18]
[null,"Labor per splice (min)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,null,24,null,24]
["WASHER SPL KIT",0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,null,30,null,30]
["FTSWN",0.33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,null,36,null,36]
["FLEXMATE2",0.25]
["FTSTLC",0.25]
[]
[]
["YES"]
["NO"]
[null,"SECONDS"]
["CLEANSHEAR (MANUAL)",{"$f":"B52*1.57","v":7.8500000000000005}]
["BATTERY OPERATED TOOL",5]
[]
[null,"Minutes (per splice)"]
["\"Kwik Splice\" Splice Time",1]
["Welded Cable Tray",{"$f":"0.5*Straights!O9","v":2}]
[]
["Cable Tray Types"]
["Wirebasket"]
["Welded Cable Tray"]
[]
[]
["Total Saved"]
[{"$f":"Straights!R27+Fittings!R20","v":19354.447222222221}]
[]
["Straight Section Material Cost"]
["Tray Being Compared",{"$f":"Straights!E23*Straights!G9","v":4000}]
["Kwik Splice",{"$f":"Straights!E25*Straights!G9","v":4250}]
["Difference",{"$f":"B68-B67","v":250}]
[]
[]
["Lengths"]
["Wirebasket",10]
["Welded Cable tray",10]
["Welded Cable tray",12]
["Welded Cable tray",20]