{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Cable Tray vs. Supports","Results","Fittings Support","Reference Data","Trouble Shooting"],"not_rendered":{"charts":0,"images":29,"macros":1,"external_links":0,"defined_names":58,"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":"Cable Tray vs. Supports","index":0,"n_rows":56,"n_cols":26,"rows_kept":56,"cut":false,"hidden":false,"merged":[[53,3,53,17],[54,1,54,2],[52,1,52,2],[53,1,53,2],[38,23,40,23],[54,3,54,17],[49,3,49,17],[43,12,44,17],[52,3,52,17],[50,3,50,17],[51,3,51,17],[43,5,44,11],[38,7,40,7],[18,23,20,23],[24,1,28,2],[22,1,22,3],[30,1,30,3],[24,19,28,19],[24,9,28,9],[32,23,34,23],[36,1,36,3],[31,1,34,2],[37,1,40,2],[32,5,34,5],[32,7,34,7],[32,9,34,9],[32,13,34,13],[12,1,12,5],[9,13,11,13],[13,1,13,5],[16,1,16,3],[17,1,20,2],[14,1,14,5],[15,1,15,5],[2,3,2,21],[24,21,28,21],[3,3,3,21],[4,3,4,21],[9,17,11,17],[9,15,11,15],[9,19,11,19],[6,7,7,10],[6,11,6,16],[7,11,7,16],[9,9,11,9],[9,11,11,11],[9,1,9,5],[24,17,28,17],[10,1,10,5],[11,1,11,5]]}
[]
[]
[null,null,null," Eaton's B-Line Series Cable Ladder to Support Cost Ratio Calculator"]
[null,null,null,"Leveraging Longer Spans, Fitting Solutions, Vertical Transitions, and Heavy Duty Expansion Splices"]
[null,null,null,"The purpose of this calculator is to help demonstrate the potential cost savings when utilizing Eaton's B-Line series cable ladder and applying our support recommendations."]
[]
[null,null,null,null,null,null,null,"Instructions:",null,null,null,"Make changes in yellow shaded areas for specified project."]
[null,null,null,null,null,null,null,null,null,null,null,"Select choice from blue drop down menus."]
[]
[null,"Units of Measurement (PLEASE SELECT)",null,null,null,null,null,"Imperial",null,"Support Install \nTime (minutes)**",null,"Splice Install\n Time (minutes)",null,"#1 Individual Support Cost **",null,"#2 Individual Support Cost **",null,"#3 Individual Support Cost **",null,"#4 Individual Support Cost **"]
[null,{"$f":"\"Labor Rate \"&IF(H10='Reference Data'!B2, \"($/hr)\",\"($/hr)\")","v":"Labor Rate ($/hr)"},null,null,null,null,null,150]
[null,{"$f":"\"Cable Ladder Straight Run Length \"&IF(H10='Reference Data'!B1,\"(ft)\",\"(m)\")","v":"Cable Ladder Straight Run Length (ft)"},null,null,null,null,null,15000]
[null,{"$f":"\"Individual Support Structure Weight \"&IF(H10='Reference Data'!B1,\"(lbs)\", \"(kg)\")","v":"Individual Support Structure Weight (lbs)"},null,null,null,null,null,250,null,360,null,15,null,3000,null,1000,null,1000,null,3000]
[null,"Cable Tray Material",null,null,null,null,null,"Aluminum"]
[null,{"$f":"\"Temperature Differential \"&IF(H10='Reference Data'!B1,\"(⁰F)\", \"(⁰C)\")","v":"Temperature Differential (⁰F)"},null,null,null,null,null,100]
[null,{"$f":"\"Maximum Expansion Splice Interval Spacing \"&IF(H10='Reference Data'!B1,\"(ft)\",\"(m)\")","v":"Maximum Expansion Splice Interval Spacing (ft)"},null,null,null,null,null,{"$f":"IF(H10='Reference Data'!B1,(INDEX('Reference Data'!B10:E16,MATCH('Cable Tray vs. Supports'!H15,'Reference Data'!A10:A16,0),MATCH('Cable Tray vs. Supports'!H14,'Reference Data'!B9:E9,0))),IF(H10='Reference Data'!B2,(INDEX('Reference Data'!H10:K16,MATCH('Cable Tray vs. Supports'!H15,'Reference Data'!G10:G16,0),MATCH('Cable Tray vs. Supports'!H14,'Reference Data'!H9:K9,0)))))","v":65}]
[null,"#1 Longer Span Savings",null,null,null,{"$f":"\"Ladder Price \nper \"&IF(H10='Reference Data'!B1,\"Foot\",\"Meter\")&\"*\"","v":"Ladder Price \nper Foot*"},null,{"$f":"\"Support Span \"&IF(H10='Reference Data'!B1,\"(ft)          -Series Dependent-\",\"(m)        -Series Dependent-\")","v":"Support Span (ft)          -Series Dependent-"},null,"Individual Support Cost **",null,"Number of Supports Required",null,"Labor Per Support Location",null,"Labor Per Splice Location",null,"Cable Ladder  Material Cost",null,"Cable Ladder\n Support Cost",null,"Cable Ladder Material & Support Costs",null,"Cable Ladder Support Savings"]
[null,"EXCLUDING SUPPORTS\n REQUIRED FOR EXPANSION JOINTS"]
[null,null,null,"Option A (Short Span)",null,10,null,20,null,{"$f":"N13","v":3000},null,{"$f":"(H12/H19)","v":750},null,{"$f":"H11*J13/60","v":900},null,{"$f":"H11*L13/60","v":37.5},"=",{"$f":"F19*H12","v":150000},null,{"$f":"L19*(J19+N19+P19)","v":2953125},null,{"$f":"(H12*F19)+(L19*(J19+N19+P19))","v":3103125},null,{"$f":"ROUNDUP((V19-V21),0)","v":954375},null,{"$f":"(L19*(J19+N19+P19))","v":2953125}]
[]
[null,null,null,"Option B (Long Span)",null,12,null,30,null,{"$f":"N13","v":3000},null,{"$f":"(H12/H21)","v":500},null,{"$f":"H11*J13/60","v":900},null,{"$f":"H11*L13/60","v":37.5},"=",{"$f":"F21*H12","v":180000},null,{"$f":"(L21*(J21+N21+P21))","v":1968750},null,{"$f":"(H12*F21)+(L21*(J21+N21+P21))","v":2148750},null,null,null,{"$f":"(L21*(J21+N21+P21))","v":1968750}]
[]
[null,"#2 Fitting Support Savings",null,null,null,"Fitting Type",null,"Quantity",null,"Individual Support Cost **",null,"Supports Required (NEMA)",null,"Unsupported Fitting                      (B-Line series) \"Floating Fitting\"",null,"Supported Fitting                     (B-Line series)     \"1/2 Span / Dual\"",null,"Nema Fitting Support Cost",null,"B-Line series  \"Floating Fitting\" Support Cost",null,"B-Line series         \n\"1/2 Span / Dual\"       Support Cost",null,"Fitting Support Savings"]
[]
[null,"EXCLUDING SUPPORTS\n REQUIRED FOR EXPANSION JOINTS",null,null,null,"Horizontal Bends",null,45,null,{"$f":"P13","v":1000},null,{"$f":"H25*'Fittings Support'!C3","v":135},null,{"$f":"H25*'Fittings Support'!D3","v":90},null,{"$f":"H25*'Fittings Support'!E3","v":45},"=",{"$f":"'Fittings Support'!C11","v":1084924},null,{"$f":"'Fittings Support'!D11","v":655524},null,{"$f":"'Fittings Support'!E11","v":319212},null,"Minimum Savings"]
[null,null,null,null,null,"Horizontal Tees",null,28,null,null,null,{"$f":"H26*'Fittings Support'!C4","v":168},null,{"$f":"H26*'Fittings Support'!D4","v":84},null,{"$f":"H26*'Fittings Support'!E4","v":56},"=",null,null,null,null,null,null,{"$f":"R25-T25","v":429400}]
[null,null,null,null,null,"Horizontal Crosses",null,15,null,null,null,{"$f":"H27*'Fittings Support'!C5","v":120},null,{"$f":"H27*'Fittings Support'!D5","v":60},null,{"$f":"H27*'Fittings Support'!E5","v":30},"="]
[null,null,null,null,null,"Reducers",null,12,null,null,null,{"$f":"H28*'Fittings Support'!C7","v":24},null,{"$f":"H28*'Fittings Support'!D7","v":24},null,{"$f":"H28*'Fittings Support'!E7","v":12},null,null,null,null,null,null,null,"Maximum Savings"]
[null,null,null,null,null,"Vertical Bends",null,37,null,null,null,{"$f":"H29*'Fittings Support'!C6","v":148},null,{"$f":"H29*'Fittings Support'!D6","v":111},null,{"$f":"H29*'Fittings Support'!E6","v":37},"=",null,null,null,null,null,null,{"$f":"R25-V25","v":765712}]
[]
[null,"#3 Vertical Adjustable Support Savings",null,null,null,"Material Type",null,"Tray Series",null,"Elevation Transitions ***",null,"Individual Support Cost **",null,{"$f":"\"Max Transition\nSpan without Supports \"&IF(H10='Reference Data'!B1,\"(ft)\",\"(m)\")","v":"Max Transition\nSpan without Supports (ft)"},null,"Number of Supports Required",null,"Labor Per Support Location",null,"Labor Per Splice Location",null," Support Costs",null,"Vertical Transition  Support Savings"]
[null,"EXCLUDING SUPPORTS\n REQUIRED FOR EXPANSION JOINTS"]
[null,null,null,"NEMA",null,"Aluminum",null,"Series_2_4",null,22,null,{"$f":"R13","v":1000},null,{"$f":"IF(H33=\"Series_S8A\", 20, IF(H33=\"Series_57A\",15,IF(H33=\"Series_2_4\",10,IF(H33=\"Series_2_5\", 10,IF(H33=\"HDL\",3,IF(H33=\"SDL\",3,IF(H33=\"Metric_Series_2_4\",3,IF(H33=\"Metric_Series_5\",4.5,0))))))))","v":10},null,{"$f":"IF(J33=0,0,'Fittings Support'!J15)","v":88},null,{"$f":"J13*H11/60","v":900},null,{"$f":"H11*L13/60","v":37.5},"=",{"$f":"2*(J33*T33)+(L33*P33)+(P33*R33)","v":168850},null,{"$f":"V33-V35","v":83600}]
[]
[null,null,null,"B-Line series",null,null,null,null,null,null,null,{"$f":"R13","v":1000},null,null,null,{"$f":"IF(J33=0,0,'Fittings Support'!M15)","v":44},null,{"$f":"J13*H11/60","v":900},null,{"$f":"H11*L13/60","v":37.5},"=",{"$f":"2*(J33*T35)+(L35*P35)+(P35*R35)","v":85250}]
[]
[null,"#4 Expansion Splice Locations",null,null,null,"Expansion Splice Price",null,{"$f":"\"Support\n Span \"&IF(H10='Reference Data'!B1,\"(ft)\",\"(m)\")","v":"Support\n Span (ft)"},null,"Cost of each\nSupport **",null,"Number of Expansion Supports Required",null,"Labor Per Support Location",null,"Labor Per Splice Location",null,null,null,"Expansion Splice and & Additional Support Costs",null,null,null,"HD Expansion Splice Support Savings"]
[null,"EXCLUDING SUPPORTS\n REQUIRED FOR TYPICAL RUN"]
[null,null,null,"Standard*",null,25,null,20,null,{"$f":"T13","v":3000},null,{"$f":"((H12/(FLOOR(H16,H39))))-1","v":249},null,{"$f":"J13*H11/60","v":900},null,{"$f":"H11*L13/60","v":37.5},null,"=",null,{"$f":"IF(F39=0,0,(L39*(J39+N39+P39))+(F39*(H12/(MROUND(H16,H21)))))","v":986687.5},null,null,null,{"$f":"T39-T41","v":974187.5}]
[]
[null,null,null,"Heavy Duty ",null,50,null,null,null,{"$f":"T13","v":3000},null,{"$f":"IF(H10='Reference Data'!B1,(IF(H39<=40,0,\"N/A\")),(IF(H39<=12,0,\"N/A\")))","v":0},null,{"$f":"H11*J13/60","v":900},null,{"$f":"H11*(L13*1.5)/60","v":56.25},null,"=",null,{"$f":"IF(F41=0,0,(L41*(J41+N41+P41))+(F41*(H12/(MROUND(H16,H21)))))","v":12500}]
[]
[]
[null,null,"Select only one Fitting Option",null,null,"Total Support Savings Selection",null,null,null,null,null,null,{"$f":"D49+H49+L49+R49+X49","v":0},null,null,null,null,null,"**"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,765600]
[]
[null,{"$f":"ROUNDUP(D49,0)","v":0},null,0,{"$f":"IF(X19=0,\"û\",\"ü\")","v":"ü"},null,null,0,{"$f":"IF(X26=0,\"û\",\"ü\")","v":"ü"},{"$f":"IF(H49=X26,H49,L49)","v":0},{"$f":"IF(X29=0,\"û\",\"ü\")","v":"ü"},0,{"$f":"IF(H49=X26,\"Floating Fitting\",\"1/2 Span / Dual Support\")","v":"1/2 Span / Dual Support"},{"$f":"H49+L49","v":0},null,{"$f":"D49+H49+L49+R49+X49","v":0},{"$f":"IF(X33=0,\"û\",\"ü\")","v":"ü"},0,null,null,null,null,{"$f":"IF(X39=0,\"û\",\"ü\")","v":"ü"},0]
[null,"Notes:","*","Compare straight run price only, since Eaton's Bline series fittings will require the same supports regardless of tray type.   "]
[null,null,"**","Outdoor supports include structural steel support columns and trapeze assemblies.  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.  "]
[null,null,"***","Elevation transistions consist of 2 pairs of vertical adjustable splice plates. "]
[null,"*",null,"Standard expansion splice plates require a support within two feet on each side of the expansion splice plate location per NEMA VE-2 installation guide. Eaton's B-Line series Heavy Duty Expansion splice plate does not require any additional supports around expansion locations. Support span derived from \"Longer Span Savings\" longest span selected."]
[null,"**",null,"Select desired structural steel solutions and ensure only one Fitting Detial is slected. The amount listed here is an etimation based upon user input data; this is not a guarantee of actual savings. "]
[null,null,null,"FOR MORE INFORMATION AND DETAILS PLEASE REFERENCE: Engineers guide to structural steel savings with B-Line series cable ladder system (SSS-17) "]
[null,null,null,null,null,null,null,null,null,null,null,"Publication No. CA302004EN"]

{"sheet":"Results","index":1,"n_rows":43,"n_cols":10,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,1,42,13],[30,1,30,7],[3,1,3,13],[31,1,35,13],[37,1,41,13],[25,1,29,13],[4,1,8,13],[13,1,17,13],[19,1,23,13],[12,1,12,7],[18,1,18,7],[24,1,24,7],[36,1,36,8]]}
[]
[null,"Results Overview"]
[]
[null,"Structural Steel Savings Solutions"]
[null,{"$f":"IFERROR(\"Based on the variables you selected, choosing an Eaton B-Line series cable ladder system for your project can yield an approximate total savings of $\"&TEXT('Cable Tray vs. Supports'!P49,\"#,### \")&\". Below you can see how the 4 key project design considerations break out to provide the lowest total installed cost in the cable ladder industry.\",\"Please enter values for all of the inputs to view the completed analysis.\")","v":"Based on the variables you selected, choosing an Eaton B-Line series cable ladder system for your project can yield an approximate total savings of $ . Below you can see how the 4 key project design considerations break out to provide the lowest total installed cost in the cable ladder industry."}]
[]
[]
[]
[]
[]
[null,"Results Details"]
[]
[null,"#1 Longer Straight Section Spans",null,null,null,null,null,null,null,{"$f":"IF('Cable Tray vs. Supports'!D49=0,\"û\",'Cable Tray vs. Supports'!E49)","v":"û"}]
[null,{"$f":"IF('Cable Tray vs. Supports'!D49=0, \"NA\",\"Based on the variables you selected, the total expected savings that can be achieved by utilizing Eaton's B-Line series longer support span solutions equates to $\"&TEXT('Cable Tray vs. Supports'!X19,\"#,###\")&\". The savings listed was achieved with only a $\"&TEXT('Cable Tray vs. Supports'!F21-'Cable Tray vs. Supports'!F19,\"#,### \")&\"per \" &IF('Cable Tray vs. Supports'!H10='Reference Data'!B1,\"foot\",\"meter\") &\" increase in cable ladder material price.\")","v":"NA"}]
[]
[]
[]
[]
[null,"#2 Fitting Support Savings",null,null,null,null,null,null,null,{"$f":"IF('Cable Tray vs. Supports'!N49=0,\"û\",'Cable Tray vs. Supports'!I49)","v":"û"}]
[null,{"$f":"IF('Cable Tray vs. Supports'!N49= 0,\"NA\",\"By supporting the fittings per the Eaton's B-Line series recommendations (See SSS-17 Engineers Guide to Structural Steel Savings for more information) and moving the cable ladder supports to best fit the application, you can save up to $\"&TEXT('Cable Tray vs. Supports'!J49,\"#,### \")&\"utilizing Eaton's *\" &  'Cable Tray vs. Supports'!M49 &\"*  recommendations for this project.\")","v":"NA"}]
[]
[]
[]
[]
[null,"#3 Vertical Adjustable Support Savings",null,null,null,null,null,null,null,{"$f":"IF('Cable Tray vs. Supports'!R49=0,\"û\",'Cable Tray vs. Supports'!Q49)","v":"û"}]
[null,{"$f":"IF('Cable Tray vs. Supports'!R49=0, \"NA\",\"Based on the variables selected, the total expected savings that can be achieved by utilizing Eaton's B-Line series vertical adjustable splice plate support recommendations is $\"&TEXT('Cable Tray vs. Supports'!X33,\"#,###.\"))","v":"NA"}]
[]
[]
[]
[]
[null,"#4 Thermal Expansion Support Savings",null,null,null,null,null,null,null,{"$f":"IF('Cable Tray vs. Supports'!X49=0,\"û\",'Cable Tray vs. Supports'!W49)","v":"û"}]
[null,{"$f":"IF('Cable Tray vs. Supports'!X49=0,\"NA\",\"Based on the variables selected, the total expected savings that can be achieved by utilizing Eaton's B-Line series Heavy Duty Expansion Splice support recommendation is $\"&TEXT('Cable Tray vs. Supports'!X39,\"#,###.\"))","v":"NA"}]
[]
[]
[]
[]
[null,"Steel Weight Summary",null,null,null,null,null,null,null,{"$f":"IF('Reference Data'!B84=0,\"û\",\"ü\")","v":"û"}]
[null,{"$f":"IF('Reference Data'!B84=0,\"NA\",\"Based on user inputs and selected variables, approximately \"&TEXT('Reference Data'!B83,\"#,### \")&\"structural steel supports could be eliminated on this project example by utilizing Eaton's B-Line series cable ladder solutions. This would equate to approximately  \"&IF('Cable Tray vs. Supports'!H10='Reference Data'!B1,'Reference Data'!C84,'Reference Data'!C85)&\"of total weight saved. \")","v":"NA"}]
[]
[]
[]
[]
[null,"Publication No. CA302004EN"]

{"sheet":"Fittings Support","index":2,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":true,"merged":[[0,6,0,10]]}
[null,null,"Required Supports",null,null,null,"Vertical Adjustable Splice Plate"]
[null,"Quantity","NEMA","B-Line #1 (2 feet)","B-Line #2 (half span)",null,"Quantity","Series","Transition Span","NEMA Supports","total","Bline Supports","total"]
["Horizontal Bends",{"$f":"'Cable Tray vs. Supports'!H25*1","v":45},3,2,1,null,{"$f":"'Cable Tray vs. Supports'!J33","v":22},"(2-4) ",5,4,{"$f":"J3*G3","v":88},2,{"$f":"L3*G3","v":44}]
["Horizontal Tees",{"$f":"'Cable Tray vs. Supports'!H26*1","v":28},6,3,2,null,{"$f":"G3","v":22},"(2-4)",10,4,{"$f":"J4*G4","v":88},2,{"$f":"L4*G4","v":44}]
["Horizontal Crosses",{"$f":"'Cable Tray vs. Supports'!H27*1","v":15},8,4,2,null,{"$f":"'Cable Tray vs. Supports'!J33","v":22},"57A",5,4,88,2,44]
["Vertical Bends",{"$f":"'Cable Tray vs. Supports'!H29*1","v":37},4,3,1,null,{"$f":"G5","v":22},"57A",10,4,88,2,44]
["Reducers",{"$f":"'Cable Tray vs. Supports'!H28","v":12},2,2,1,null,{"$f":"G5","v":22},"57A",15,4,88,2,44]
[null,null,null,null,null,null,{"$f":"'Cable Tray vs. Supports'!J33","v":22},"S8A",5,4,88,2,44]
["Support Material Cost Each",{"$f":"'Cable Tray vs. Supports'!J25","v":1000},null,null,null,null,{"$f":"G8","v":22},"S8A",10,4,88,2,44]
["Support Install Labor Cost Each",{"$f":"'Cable Tray vs. Supports'!H11*'Cable Tray vs. Supports'!J13/60","v":900},null,null,null,null,{"$f":"G9","v":22},"S8A",15,4,88,2,44]
["Total Cost",null,{"$f":"(($B$3*C3)+($B$4*C4)+($B$5*C5)+($B$6*C6))*($B$9+$B$10)+(B7*C7)","v":1084924},{"$f":"(($B$3*D3)+($B$4*D4)+($B$5*D5)+($B$6*D6))*($B$9+$B$10)+(B7*D7)","v":655524},{"$f":"(($B$3*E3)+($B$4*E4)+($B$5*E5)+($B$6*E6))*($B$9+$B$10)+(B7*E7)","v":319212},null,{"$f":"G10","v":22},"S8A",20,4,88,2,44]
["Savings",null,null,{"$f":"(C11-D11)","v":429400},{"$f":"(C11-E11)","v":765712},null,{"$f":"'Cable Tray vs. Supports'!J33","v":22},"(2-5) ",5,4,{"$f":"J12*G12","v":88},2,{"$f":"L12*G12","v":44}]
[null,null,null,null,null,null,{"$f":"G12","v":22},"(2-5) ",10,4,{"$f":"J13*G13","v":88},2,{"$f":"L13*G13","v":44}]
["Minimum Savings",null,null,{"$f":"MIN(D12:E12)","v":429400}]
["Maximum Savings",null,null,{"$f":"MAX(D12:E12)","v":765712},null,null,"Totals",null,null,{"$f":"J3*G3","v":88},null,null,{"$f":"L3*G3","v":44}]
[]
[]
["AL","Series_2_4"]
[null,"_57A"]
[null,"_S8A"]
["Steel","Series_2_5"]
[304]
[316]

{"sheet":"Reference Data","index":3,"n_rows":85,"n_cols":29,"rows_kept":85,"cut":false,"hidden":true,"merged":[]}
["Aluminum","Imperial"]
["Steel","Metric"]
["SS 304"]
["SS 316"]
[]
["Standard"]
["Heavy Duty"]
[]
["Temp Differential","Steel","Aluminum","SS4","SS6",null,"Temp Differential (metric)","Metric_Steel","Metric_Aluminum","Metric_SS4","Metric_SS6",null,"Units","Material","AL List","Steel List","SS 304 List","SS 316 List","MCL List","Metric AL List",null,"Series_2-4","Series_2-5","57A","S8A","HDL_List","SDL_List","Series_2_4_Metric","Series_5_Metric"]
[25,512,260,347,379,null,13.9,156,79.2,105.7,"\\",null,"Metric","Aluminum","Series_2_4","Series_2_5","Series_2_5","Series_2_5","HDL","Metric_Series_2_4",null,10,10,15,20,3,3,3,4.5]
[50,256,130,174,189,null,27.8,78,39.6,53,57.6,null,"Imperial","Steel","Series_57A",null,null,null,"SDL","Metric_Series_5"]
[75,171,87,116,126,null,41.7,52.1,26.5,35.4,38.4,null,null,"SS_304","Series_S8A"]
[100,128,65,87,95,null,55.6,39,19.8,26.5,29,null,null,"SS_316"]
[125,102,52,69,76,null,69.400000000000006,31.1,15.8,21,23.2,null,null,"MCL_Series"]
[150,85,43,58,63,null,83.3,25.9,13.1,17.7,19.2,null,null,"Metric_AL"]
[175,73,37,50,54,null,97.2,22.2,11.3,15.2,16.399999999999999]
[]
[]
["Imperial AL"]
["A","B","CC","D","E","F","P"]
[10,12,16,20,24,30,40]
[12,16,20,24,25,40]
[16,20,24,25,30]
[20,24,25,30,40]
[24,25,30,40]
[25,30,40]
[30,40]
[40]
[]
["Imperial Steel/Stainless"]
["AA","BB","CCC","DD","EE"]
[10,12,16,20,24]
[12,16,20,24]
[16,20,24]
[20,24]
[24]
[]
[]
[]
[]
[]
["Metric AL"]
["N","O","G","H","I","J","K","L","M","Q"]
[1.5,2,3,4,5,6,7,8,9,12]
[2,3,4,5,6,7,8,9,12]
[3,4,5,6,7,8,9,12]
[4,5,6,7,8,9,12]
[5,6,7,8,9,12]
[6,7,8,9,12]
[7,8,9,12]
[8,9,12]
[9,12]
[12]
[]
[]
["Metric Steel/Stainless"]
["NN","OO","GG","HH","II","JJ","KK"]
[1.5,2,3,4,5,6,7]
[2,3,4,5,6,7]
[3,4,5,6,7]
[4,5,6,7]
[5,6,7]
[6,7]
[7]
[]
[]
[]
[]
["Total Savings",{"$f":"('Fittings Support'!D15)+'Cable Tray vs. Supports'!X19+'Cable Tray vs. Supports'!X39","v":2694274.5}]
[]
[null,"lbs","kgs"]
["Steel Weight Eliminated",{"$f":"ROUNDUP(('Cable Tray vs. Supports'!H13*(('Cable Tray vs. Supports'!L19-'Cable Tray vs. Supports'!L21)+(SUM('Cable Tray vs. Supports'!L25:L29)-SUM('Cable Tray vs. Supports'!N25:N29))+('Cable Tray vs. Supports'!P33-'Cable Tray vs. Supports'!P35)+('Cable Tray vs. Supports'!L39-'Cable Tray vs. Supports'!L41))),0)","v":192250},{"$f":"B72*0.453592","v":87203.062000000005}]
["Steel Weight Eliminated",{"$f":"ROUNDUP(('Cable Tray vs. Supports'!H13*(('Cable Tray vs. Supports'!L19-'Cable Tray vs. Supports'!L21)+(SUM('Cable Tray vs. Supports'!L25:L29)-SUM('Cable Tray vs. Supports'!P25:P29))+('Cable Tray vs. Supports'!P33-'Cable Tray vs. Supports'!P35)+('Cable Tray vs. Supports'!L39-'Cable Tray vs. Supports'!L41))),0)","v":239500},{"$f":"B73*0.453592","v":108635.284}]
[]
["Formatting",{"$f":"TEXT(B72,\"#,###\")&\" lbs. or \"&TEXT(B73,\"#,###\")&\" lbs.\"","v":"192,250 lbs. or 239,500 lbs."},{"$f":"TEXT(C72,\"#,###\")&\" kgs. or \"&TEXT(C73,\"#,###\")&\" kgs.\"","v":"87,203 kgs. or 108,635 kgs."}]
[]
[]
["Long Spans",{"$f":"IF('Cable Tray vs. Supports'!B49='Cable Tray vs. Supports'!X19,'Cable Tray vs. Supports'!L19-'Cable Tray vs. Supports'!L21,0)","v":0},{"$f":"'Cable Tray vs. Supports'!X19","v":954375},19,{"$f":"IF(C78=C79,\"yes\",\"no\")","v":"no"}]
["Fittings Floating",{"$f":"IF('Cable Tray vs. Supports'!H49='Cable Tray vs. Supports'!X26,SUM('Cable Tray vs. Supports'!L25:L29)-SUM('Cable Tray vs. Supports'!N25:N29),0)","v":0},{"$f":"'Cable Tray vs. Supports'!B49","v":0},20]
["Fittings 1/2 Span",{"$f":"IF('Cable Tray vs. Supports'!J49='Cable Tray vs. Supports'!X29,SUM('Cable Tray vs. Supports'!L25:L29)-SUM('Cable Tray vs. Supports'!P25:P29),0)","v":0},null,21]
["Vertical ADJ",{"$f":"IF('Cable Tray vs. Supports'!R49='Cable Tray vs. Supports'!X33,'Cable Tray vs. Supports'!P33-'Cable Tray vs. Supports'!P35,0)","v":0}]
["HD EXP",{"$f":"IF('Cable Tray vs. Supports'!X49='Cable Tray vs. Supports'!X39,'Cable Tray vs. Supports'!L39-'Cable Tray vs. Supports'!L41,0)","v":0}]
["Total Support Reduction",{"$f":"SUM(B78:B82)","v":0},{"$f":"IF(B83=0,\"û\",\"ü\")","v":"û"}]
["Support Reduction (SI)",{"$f":"SUM(B78:B82)*'Cable Tray vs. Supports'!H13","v":0},{"$f":"TEXT(B84,\"#,###\")&\" lbs. \"","v":" lbs. "}]
["Support Reduction (Metric)",{"$f":"B84*0.453592","v":0},{"$f":"TEXT(B85,\"#,###\")&\" kgs. \"","v":" kgs. "}]

{"sheet":"Trouble Shooting","index":4,"n_rows":136,"n_cols":5,"rows_kept":136,"cut":false,"hidden":false,"merged":[[135,3,137,19],[2,4,3,17],[31,4,32,17],[55,4,56,17],[75,4,76,17],[95,4,96,17]]}
[]
[]
[null,null,null,null,"#N/A Issues"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Not Calculating Correctly"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Support & Labor Costs Drive Savings Numbers - Fill in All 4 Design Criteria for Maximum Savings"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Select Boxes to Generate Desired Savings - Only Select 1 Fitting Type"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Changes to Design Consideration Calculations After Selections are Checked "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"For more assistance please contact Eaton's Bline business at 618-654-2184"]