{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Data Entry","Calculations","Formulas","Model tables","Chart1","Daves scratchpad 2"," Daves scratchpad 1"],"not_rendered":{"charts":26,"images":5,"defined_names":21,"comments":2},"unopened":[{"sheet":"Chart1","index":4,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900"}

{"sheet":"Data Entry","index":0,"n_rows":41,"n_cols":36,"rows_kept":41,"merged":[[0,2,0,11],[0,13,0,14],[0,15,0,18],[0,20,0,22],[0,23,0,25],[0,31,1,31],[0,32,0,33],[0,34,0,35],[1,13,1,14],[1,15,1,18],[2,4,2,8],[3,11,6,19],[3,21,4,21],[4,1,4,3],[5,1,5,3],[5,21,6,21],[6,1,6,3],[8,1,9,4],[8,6,9,9],[8,11,9,14],[8,16,9,19],[11,31,12,31],[11,32,11,33],[11,34,11,35],[16,6,18,7],[16,8,18,8],[16,9,18,9],[17,2,17,3],[18,11,19,11],[18,12,19,12],[18,13,19,13],[18,16,18,17],[18,18,18,19],[19,6,19,7],[19,16,19,17],[19,18,19,19],[20,6,20,7],[20,16,20,17],[20,18,20,19],[21,6,21,7],[21,16,21,17],[21,18,21,19],[22,31,23,31],[22,32,22,33],[22,34,22,35],[30,31,31,31]]}
[null,null,"DATA ENTRY FOR SIZING OF TCAE COUPLINGS",{"$nulls":10},"Customer Name:",{"$nulls":5},"Date:",{"$nulls":3},"Document Revision History",{"$nulls":7},"TCAE R MODEL","DBSE mm",null,"DBSE inches"]
[{"$nulls":13},"Distributor Name:",{"$nulls":9},"A","Draft release","2019-12-06",{"$nulls":6},"Min","Max","Min","Max"]
[{"$nulls":4},"DESIGN LIFE CALCULATION",{"$nulls":18},"B","warranty period formula changed","2019-12-19",{"$nulls":5},"TCAE-0-R",82,90,{"$f":"AG3/25.4","v":{"v":3.2283464566929134,"d":"3.23"}},{"$f":"AH3/25.4","v":{"v":3.5433070866141736,"d":"3.54"}}]
[{"$nulls":4},"SELECTED",null,"HOURS","DAYS","YEARS",null,null,"The DBSE (Minimum and Maximum) for our TCAE-R; TCAE-L and TCAE-CM Series Couplings are listed in the columns AF-AH on the right.  We make smaller DBSE's with our TCAE-S Range but these are to order.  If you don't fit to our normal DBSE sizes, can you move your motor or driven shaft.  Print and send to us or call +61405 970 995.",{"$nulls":9},"YES",null,"C","Procedure page","2019-12-23",{"$nulls":5},"TCAE-1-R",130,147,{"$f":"AG4/25.4","v":{"v":5.118110236220473,"d":"5.12"}},{"$f":"AH4/25.4","v":{"v":5.78740157480315,"d":"5.79"}}]
[null,"REDUCED LIFE",null,null,{"$f":"IF('Model tables'!AD28=1,'Model tables'!AO28,+IF('Model tables'!AD33=1,'Model tables'!AF33,+IF('Model tables'!AD38=1,'Model tables'!AF38,+IF('Model tables'!AD43=1,'Model tables'!AF43))))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF('Model tables'!AD28=1,'Model tables'!AM28,+IF('Model tables'!AD33=1,'Model tables'!AH33,+IF('Model tables'!AD38=1,'Model tables'!AH38,+IF('Model tables'!AD43=1,'Model tables'!AH43))))","v":{"$error":"#DIV/0!"}},{"$f":"G5/hours","v":{"$error":"#DIV/0!"}},{"$f":"+G5/hourpa","v":{"$error":"#DIV/0!"}},{"$nulls":14},2,"Releasaed","2019-12-30",{"$nulls":5},"TCAE-2-R",136,162,{"v":5.354330708661418,"d":"5.35"},{"v":6.377952755905512,"d":"6.38"}]
[null,"RECOMMENDED",null,null,{"$f":"IF('Model tables'!AD28=1,'Model tables'!AO29,+IF('Model tables'!AD33=1,'Model tables'!AF34,+IF('Model tables'!AD38=1,'Model tables'!AF39,+IF('Model tables'!AD43=1,'Model tables'!AF44))))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(IF('Model tables'!Z32=1,'Model tables'!AI32,+IF('Model tables'!Z37=1,'Model tables'!AD37,+IF('Model tables'!Z42=1,'Model tables'!AD42,+IF('Model tables'!Z47=1,'Model tables'!AD47))))<hourpa*4,IF('Model tables'!Z32=1,'Model tables'!AI32,+IF('Model tables'!Z37=1,'Model tables'!AD37,+IF('Model tables'!Z42=1,'Model tables'!AD42,+IF('Model tables'!Z47=1,'Model tables'!AD47)))),hourpa*4)","v":0},{"$f":"+G6/hours","v":{"$error":"#DIV/0!"}},{"$f":"+G6/hourpa","v":{"$error":"#DIV/0!"}},{"$nulls":12},"NO",null,3,"fixed error in R series","2020-01-19",{"$nulls":5},"TCAE-3-R",240,270,{"v":9.448818897637796,"d":"9.45"},{"v":10.62992125984252,"d":"10.63"}]
[null,"EXTENDED LIFE",null,null,{"$f":"IF('Model tables'!AD28=1,'Model tables'!AO30,+IF('Model tables'!AD33=1,'Model tables'!AF35,+IF('Model tables'!AD38=1,'Model tables'!AF40,+IF('Model tables'!AD43=1,'Model tables'!AF45))))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(IF('Model tables'!Z32=1,'Model tables'!AI32,+IF('Model tables'!Z37=1,'Model tables'!AD37,+IF('Model tables'!Z42=1,'Model tables'!AD42,+IF('Model tables'!Z47=1,'Model tables'!AD47))))<hourpa*5,IF('Model tables'!Z32=1,'Model tables'!AI32,+IF('Model tables'!Z37=1,'Model tables'!AD37,+IF('Model tables'!Z42=1,'Model tables'!AD42,+IF('Model tables'!Z47=1,'Model tables'!AD47)))),hourpa*5)","v":0},{"$f":"+G7/hours","v":{"$error":"#DIV/0!"}},{"$f":"+G7/hourpa","v":{"$error":"#DIV/0!"}},{"$nulls":14},4,"Changed Layout","2020-04-23",{"$nulls":5},"TCAE-4-R",276,285,{"v":10.866141732283465,"d":"10.87"},{"v":11.220472440944883,"d":"11.22"}]
[{"$nulls":23},5,"fixed error in R series","2020-05-07",{"$nulls":5},"TCAE-5-R",276,300,{"v":10.866141732283465,"d":"10.87"},{"v":11.811023622047244,"d":"11.81"}]
[null,"MOTOR DETAILS",{"$nulls":4},"DRIVEN SHAFT DETAILS",{"$nulls":4},"IF GEARBOX CONNECTED",{"$nulls":4},"MACHINE OPERATIONAL DUTY TIME",{"$nulls":6},6,"fixed error in R series","21/05/202o",{"$nulls":5},"TCAE-6-R",291,312,{"v":11.456692913385828,"d":"11.46"},{"v":12.283464566929135,"d":"12.28"}]
[{"$nulls":23},7,"mm & inches added","2020-05-23",{"$nulls":5},"TCAE-7-R",310,330,{"v":12.20472440944882,"d":"12.20"},{"v":12.992125984251969,"d":"12.99"}]
[{"$nulls":31},"TCAE-8-R",326,344,{"v":12.834645669291339,"d":"12.83"},{"v":13.543307086614174,"d":"13.54"}]
[{"$nulls":31},"TCAE L MODEL","DBSE",null,"DBSE"]
[{"$nulls":32},"Min","Max","Min","Max"]
[{"$nulls":31},"TCAE-0-L",90,1500,{"$f":"AG14/25.4","v":{"v":3.5433070866141736,"d":"3.54"}},{"$f":"AH14/25.4","v":{"v":59.05511811023622,"d":"59.06"}}]
[{"$nulls":31},"TCAE-1-L",147,1800,{"$f":"AG15/25.4","v":{"v":5.78740157480315,"d":"5.79"}},{"$f":"AH15/25.4","v":{"v":70.86614173228347,"d":"70.87"}}]
[{"$nulls":31},"TCAE-2-L",162,2000,{"v":6.377952755905512,"d":"6.38"},{"v":78.74015748031496,"d":"78.74"}]
[{"$nulls":6},"DISTANCE BETWEEN SHAFT ENDS (MOTOR TO DRIVEN SHAFT OR GEARBOX TO DRIVEN SHAFT",null,null,{"$f":"D21","v":"Click Here"},{"$nulls":21},"TCAE-3-L",270,2000,{"v":10.62992125984252,"d":"10.63"},{"v":78.74015748031496,"d":"78.74"}]
[null,"TYPE","Click Here",{"$nulls":28},"TCAE-4-L",285,2000,{"v":11.220472440944883,"d":"11.22"},{"v":78.74015748031496,"d":"78.74"}]
[null,"POWER",null,"Click Here",{"$nulls":7},"SHAFT DIAMETER",null,{"$f":"D21","v":"Click Here"},null,null,"HOURS PER DAY",{"$nulls":14},"TCAE-5-L",300,2000,{"v":11.811023622047244,"d":"11.81"},{"v":78.74015748031496,"d":"78.74"}]
[null,"SPEED",null,"RPM",null,null,"DRIVEN SHAFT DIAMETER",null,null,{"$f":"D21","v":"Click Here"},{"$nulls":6},"DAYS PER WEEK",{"$nulls":14},"TCAE-6-L",312,2000,{"v":12.283464566929135,"d":"12.28"},{"v":78.74015748031496,"d":"78.74"}]
[null,"SHAFT DIAMETER",null,"Click Here",null,null,"MACHINE DUTY SERVICE TYPE",null,"Click Here","See Examples Below",null,"RATIO : 1",{"$nulls":4},"WEEKS PER YEAR",{"$nulls":14},"TCAE-7-L",330,2000,{"v":12.992125984251969,"d":"12.99"},{"v":78.74015748031496,"d":"78.74"}]
[null,"SHAFT ANGLE DEGREES",null,"<5⁰",null,null,"MACHINE SERVICE FACTOR",null,{"$f":"VLOOKUP(I21,Calculations!G14:H20,2)","v":{"$error":"#N/A"}},null,null,"FINAL SPEED",{"$f":"IF(RATIO=\"\",\"\",+output_speed)","v":""},{"$nulls":3},"TOTAL HOURS PA",null,{"$f":"hours*days*weeks","v":0},{"$nulls":12},"TCAE-8-L",344,2000,{"v":13.543307086614174,"d":"13.54"},{"v":78.74015748031496,"d":"78.74"}]
[{"$nulls":31},"TCAE CM MODEL","DBSE",null,"DBSE"]
[{"$nulls":32},"Min","Max","Min","Max"]
[{"$nulls":31},"TCAE-9-CM",500,2500,{"$f":"AG25/25.4","v":{"v":19.68503937007874,"d":"19.69"}},{"$f":"AH25/25.4","v":{"v":98.4251968503937,"d":"98.43"}}]
[{"$nulls":31},"TCAE-10-CM",550,2500,{"$f":"AG26/25.4","v":{"v":21.653543307086615,"d":"21.65"}},{"$f":"AH26/25.4","v":{"v":98.4251968503937,"d":"98.43"}}]
[{"$nulls":31},"TCAE-11-CM",600,3000,{"v":23.62204724409449,"d":"23.62"},{"v":118.11023622047244,"d":"118.11"}]
[{"$nulls":31},"TCAE-12-CM",650,3000,{"v":25.590551181102363,"d":"25.59"},{"v":118.11023622047244,"d":"118.11"}]
[{"$nulls":31},"TCAE-13-CM",700,3000,{"v":27.559055118110237,"d":"27.56"},{"v":118.11023622047244,"d":"118.11"}]
[{"$nulls":31},"TCAE-14-CM",700,3000,{"v":27.559055118110237,"d":"27.56"},{"v":118.11023622047244,"d":"118.11"}]
[{"$nulls":31},"TCAE S MODEL","Dia ",null,"Dia "]
[{"$nulls":32},"Max",null,"Max"]
[{"$nulls":31},"TCAE-6-S",60,null,{"$f":"AG33/25.4","v":{"v":2.362204724409449,"d":"2.36"}}]
[{"$nulls":31},"TCAE-7-S",80,null,{"v":3.1496062992125986,"d":"3.15"}]
[{"$nulls":31},"TCAE-8-S",90,null,{"v":3.5433070866141736,"d":"3.54"}]
[{"$nulls":31},"TCAE-9-S",130,null,{"v":5.118110236220473,"d":"5.12"}]
[{"$nulls":31},"TCAE-10-S",145,null,{"v":5.708661417322835,"d":"5.71"}]
[{"$nulls":31},"TCAE-11-S",180,null,{"v":7.086614173228347,"d":"7.09"}]
[{"$nulls":31},"TCAE-12-S",200,null,{"v":7.874015748031496,"d":"7.87"}]
[{"$nulls":31},"TCAE-13-S",190,null,{"v":7.480314960629921,"d":"7.48"}]
[{"$nulls":31},"TCAE-14-S",250,null,{"v":9.84251968503937,"d":"9.84"}]

{"sheet":"Calculations","index":1,"n_rows":50,"n_cols":18,"rows_kept":50,"hidden":true,"merged":[[3,6,3,7],[3,12,3,14],[21,6,21,7]]}
[]
[null,"2. Gather the data entry values to perform initial calculations",{"$nulls":14},"LISTS","Fomula"]
[null,"Power",{"$f":"+POWER","v":{"$error":"#VALUE!"}},"kW",null,null,"Tables for constants"]
[null,"Speed",{"$f":"+SPEED","v":0},"rpm",null,null,"Machine service factor K1",null,null," time factor K2",null,null,"Angle factor K3",{"$nulls":3},"Power Source","kw to BHP"]
[null,"Gear ratio",{"$f":"+IF(+RATIO=0,1,+RATIO)","v":1},{"$nulls":3},"Motor type","K1m",null,"hpd","K2",null,"Angle ","K3bjd","K3doj",null,"Click Here"]
[null,"output speed",{"$f":"+C4/C5","v":0},"rpm",null,null,"Click Here",null,null,2,0.63,null,0,0.99,0.99,null,"kW"]
[{"$nulls":6},"Diesel 3cyl or less",3,null,4,0.8,null,1,0.98,0.94,null,"BHP",{"$f":"ROUNDUP(IF('Data Entry'!D19=\"click Here\",\"\",IF('Data Entry'!D19=\"kW\",'Data Entry'!C19,IF('Data Entry'!D19=\"BHP\",'Data Entry'!C19/1.341,0))),1)","v":{"$error":"#VALUE!"}}]
[null,"Motor type",{"$f":"+TYPE","v":"Click Here"},{"$nulls":3},"Diesel 4+ cyl",2,null,6,0.91,null,2,0.96,0.89]
[{"$nulls":6},"Electric motor",1,null,8,1,null,3,0.94,0.85]
[null,"Machine type",{"$f":"+MSF","v":"Click Here"},{"$nulls":3},"Petrol 3cyl or less",1.5,null,10,1.08,null,4,0.92,0.82,null,"Size","mm to inches"]
[null,null,{"$f":"+hours","v":0},"hpd",null,null,"Petrol 4+cyl",1.25,null,12,1.15,null,5,0.9,0.78,null,"Motor shaft",{"$f":"ROUNDUP(IF('Data Entry'!D21=\"click Here\",0,IF('Data Entry'!D21=\"mm\",'Data Entry'!C21,IF('Data Entry'!D21=\"inches\",'Data Entry'!C21*25.4,0))),0)","v":0}]
[null,null,{"$f":"+days","v":0},"dpw",null,null,"Turbine",1,null,14,1.2,null,6,0.88,0.75,null,"gear shaft dia",{"$f":"ROUNDUP(IF('Data Entry'!N19=\"click Here\",0,IF('Data Entry'!N19=\"mm\",'Data Entry'!M19,IF('Data Entry'!N19=\"inches\",'Data Entry'!M19*25.4,0))),0)","v":0}]
[null,null,{"$f":"+weeks","v":0},"wpa",null,null,"Driven type","K1d",null,16,1.26,{"$nulls":5},"Driven shaft",{"$f":"ROUNDUP(IF('Data Entry'!J20=\"click Here\",0,IF('Data Entry'!J20=\"mm\",'Data Entry'!I20,IF('Data Entry'!J20=\"inches\",'Data Entry'!I20*25.4,0))),0)","v":0}]
[{"$nulls":6},"extreme shock",3,null,18,1.31,{"$nulls":5},"DBSE",{"$f":"ROUNDUP(IF('Data Entry'!J17=\"click Here\",0,IF('Data Entry'!J17=\"mm\",'Data Entry'!I17,IF('Data Entry'!J17=\"inches\",'Data Entry'!I17*25.4,0))),0)","v":0}]
[null,"Motor shaft",{"$f":"+DriveShaftdia.","v":0},"mm",null,null,"heavy duty",2,null,20,1.35]
[null,"gear shaft dia",{"$f":"+gearshaftdia","v":0},"mm",null,null,"light duty",1.25,null,22,1.4,{"$nulls":5},"Size"]
[null,"Driven shaft",{"$f":"+DrivenShaftdia.","v":0},"mm",null,null,"medium duty",1.75,null,24,1.44,{"$nulls":5},"Click Here"]
[null,"DBSE",{"$f":"+DBSE.","v":0},"mm",null,null,"moderate duty",1.5,{"$nulls":8},"inches"]
[null,"Angle",{"$f":"+ANGLE","v":0},"degs",null,null,"Smooth",1,{"$nulls":8},"mm"]
[{"$nulls":6},"very heavy duty",2.5]
[]
["Calculations:",{"$nulls":5},"For List only In Procedure V24"]
[null,"Motor torque",{"$f":"+C3*9550/C4","v":{"$error":"#VALUE!"}},"Nm",null,null,"Click Here"]
[null,"Gear torque",{"$f":"+C23*C5","v":{"$error":"#VALUE!"}},"Nm",null,null,"Smooth",1]
[{"$nulls":6},"Light Duty",1.25]
[null,"Drive torque",{"$f":"+MAX(C23:C24)","v":{"$error":"#VALUE!"}},"Nm",null,null,"Moderate Duty",1.5]
[{"$nulls":6},"Medium Duty",1.75]
[null,"Machine Service Factor K1",{"$nulls":4},"Heavy Duty",2]
[null,"K1m",{"$f":"+VLOOKUP(C8,G7:H12,2)","v":{"$error":"#N/A"}},{"$nulls":3},"Very Heavy Duty",2.5]
[null,"K1d",{"$f":"+VLOOKUP(C10,G14:H20,2)","v":{"$error":"#N/A"}},{"$nulls":3},"Extreme Shock",3]
[]
[null,"K1",{"$f":"+MAX(C29:C30)","v":{"$error":"#N/A"}}]
[]
[null,"Operating time factor K2"]
[null,"K2",{"$f":"+VLOOKUP(C11,J6:K17,2)","v":{"$error":"#N/A"}}]
[]
[null,"Angle factor K3"]
[null,"K3 BJD series",{"$f":"+VLOOKUP(C19,M6:O12,2)","v":0.99}]
[null,"K3 DOJ series",{"$f":"+VLOOKUP(C19,M6:O12,3)","v":0.99}]
[]
[]
["Effective Torque calculation"]
[null,"Teff = ",{"$f":"+C26*C32*C35/C38","v":{"$error":"#VALUE!"}},"Nm","assume for BJD series"]
[null,"Teff = ",{"$f":"+C26*C32*C35/C39","v":{"$error":"#VALUE!"}},"Nm","assume for DOJ series"]
[]
["Derate torque for actual power usage"]
[null,"Load capacity factor",{"v":0.7,"d":"70%"}]
[]
["Final torque effective BJD",null,{"$f":"+C43*C47","v":{"$error":"#VALUE!"}},"Nm"]
["Final torque effective DOJ",null,{"$f":"+C44*C47","v":{"$error":"#VALUE!"}}]

{"sheet":"Formulas","index":2,"n_rows":93,"n_cols":21,"rows_kept":93,"hidden":true,"merged":[[76,10,76,12]]}
["Calculation of coupling type from data entry page"]
["final speed",{"$f":"+output_speed","v":0},"rpm"]
["operational hours",{"$f":"+Calculations!C11","v":0},"hpd"]
["equiv torque BJD",{"$f":"+Calculations!C49","v":{"$error":"#VALUE!"}},"Nm"]
["equiv torque DOJ",{"$f":"+Calculations!C50","v":{"$error":"#VALUE!"}},"Nm",{"$nulls":3},"Initial selection","life hrs","life days","life yrs"]
["warranty period",1,"years",{"$f":"+hourpa*Formulas!B6","v":0},"hrs","LESSER",{"$f":"INDEX(A12:A29,MATCH(G7,A12:A29,0)-1,1)","v":{"$error":"#DIV/0!"}},{"$f":"+VLOOKUP(G6,A12:C29,3)","v":{"$error":"#DIV/0!"}},{"$f":"+H6/hours","v":{"$error":"#DIV/0!"}},{"$f":"+H6/(hourpa)","v":{"$error":"#DIV/0!"}}]
["warranty period",1,"years",{"$f":"+hourpa*Formulas!B7","v":0},"hrs","IDEAL",{"$f":"+IF(D7<C12,A12,+IF(D7<C13,A13,+IF(D7<C14,A14,+IF(D7<C15,A15,+IF(D7<C16,A16,+IF(D7<C17,A17,+IF(D7<C18,A18,+IF(D7<C19,A19,+IF(D7<C20,A20,+IF(D7<C21,A21,+IF(D7<C22,A22,+IF(D7<C23,A23,+IF(D7<C24,A24,+IF(D7<C25,A25,+IF(D7<C26,A26,+IF(D7<C27,A27,+IF(D7<C28,A28,+IF(D7<C29,A29,A30))))))))))))))))))","v":{"$error":"#DIV/0!"}},{"$f":"+VLOOKUP(G7,A12:C29,3)","v":{"$error":"#DIV/0!"}},{"$f":"+H7/hours","v":{"$error":"#DIV/0!"}},{"$f":"+H7/(hourpa)","v":{"$error":"#DIV/0!"}}]
["warranty period",1,"years",{"$f":"+hourpa*Formulas!B8","v":0},"hrs","GREATER",{"$f":"INDEX(A12:A29,MATCH(G7,A12:A29,0)+1,1)","v":{"$error":"#DIV/0!"}},{"$f":"+VLOOKUP(G8,A12:C29,3)","v":{"$error":"#DIV/0!"}},{"$f":"+H8/hours","v":{"$error":"#DIV/0!"}},{"$f":"+H8/(hourpa)","v":{"$error":"#DIV/0!"}}]
[]
["Calculated torque limit values at speed",{"$nulls":10},"Working torque vs speed"]
["Coupling","limit torque","life calc hrs",null,"torque ","at speed","torque ","at speed","max speed",null,"Coupling","range 0-1000 rpm",null,"equation","torque at","torque at","range 1000-4000 rpm",null,"equation","torque at"]
["BC75",{"$f":"IF(B2<1000,395.68*(B2^-0.187),1012.1*(B2^-0.329))","v":{"$error":"#DIV/0!"}},{"$f":"+(B12/$B$4)^3*7200","v":{"$error":"#DIV/0!"}},null,{"$f":"+L13","v":245},{"$f":"+M13","v":13},{"$f":"+O13","v":{"v":108.72867584995565,"d":"109"}},1000,3600,null,null,"Torque","Speed","0-1000 rpm",1000,10,"Torque","Speed","1000-4000 rpm",4000,"rpm"]
["BJ095",{"$f":"IF(B2<1000,940.1*(B2^-0.204),1661.6*(B2^-0.292))","v":{"$error":"#DIV/0!"}},{"$f":"+(B13/$B$4)^3*7200","v":{"$error":"#DIV/0!"}},null,{"$f":"+L16","v":588},{"$f":"+M16","v":10},{"$f":"+O16","v":{"v":229.70690625876034,"d":"230"}},1000,3600,null,"BC75",245,13,"y = 395.68x-0.187",{"$f":"395.68*(O12^-0.187)","v":{"v":108.72867584995565,"d":"109"}},{"$f":"395.68*(P12^-0.187)","v":{"v":257.24331587495413,"d":"257"}},98,1200,"y = 1012.1x-0.329",{"$f":"1012.1*(T12^-0.329)","v":{"v":66.09151203217603,"d":"66"}}]
["BJ125",{"$f":"IF(B2<1000,2019.8*(B2^-0.185),5699.8*(B2^-0.335))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"+L19","v":981},{"$f":"+M19","v":50},{"$f":"+O19","v":{"v":562.740753639841,"d":"563"}},1000,3600,null,null,147,200,{"$nulls":3},78,2400]
["BJ150",{"$f":"IF(B2<1000,3680.8*(B2^-0.201),6144.4*(B2^-0.275))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"+L22","v":1960},{"$f":"+M22","v":23},{"$f":"+O22","v":{"v":918.2104270931626,"d":"918"}},1000,3000]
["BJ175",{"$f":"IF(B2<1000,6101.9*(B2^-0.209),15026*(B2^-0.339))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"+L25","v":2940},{"$f":"+M25","v":33},{"$f":"+O25","v":{"v":1440.3402131044563,"d":"1440"}},1000,3000,null,"BJ95",588,10,"y = 940.1x-0.204",{"$f":"940.1*(O12^-0.204)","v":{"v":229.70690625876034,"d":"230"}},{"$f":"940.1*(P12^-0.204)","v":{"v":587.7248484784222,"d":"588"}},196,1500,"y = 1661.6x-0.292",{"$f":"1661.6*(T12^-0.292)","v":{"v":147.47722803417454,"d":"147"}}]
["BJ200",{"$f":"IF(B2<1000,8596.5*(B2^-0.19),31800*(B2^-0.379))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"+L28","v":3920},{"$f":"+M28","v":62},{"$f":"+O28","v":{"v":2313.7778941957736,"d":"2314"}},1000,3000,null,null,294,300,{"$nulls":3},{"v":147.15,"d":"147"},4000]
["BJ225",{"$f":"IF(B2<1000,12361*(B2^-0.2),30734*(B2^-0.332))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"+L31","v":6867},{"$f":"+M31","v":19},{"$f":"+O31","v":{"v":3104.942817988992,"d":"3105"}},1000,1800]
["BJ250",{"$f":"IF(B2<1000,15962*(B2^-0.184),51095*(B2^-0.352))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"+L34","v":9810},{"$f":"+M34","v":14},{"$f":"+O34","v":{"v":4478.033172898526,"d":"4478"}},1000,1800,null,"BJ125",981,50,"y = 2019.8x-0.185",{"$f":"2019.8*(O12^-0.185)","v":{"v":562.740753639841,"d":"563"}},{"$f":"2019.8*(P12^-0.185)","v":{"v":1319.1930902373647,"d":"1319"}},{"$f":"50*9.81","v":{"v":490.5,"d":"491"}},1500,"y = 5699.8x-0.335",{"$f":"5699.8*(T12^-0.335)","v":{"v":354.13554525686965,"d":"354"}}]
["BJ300",{"$f":"+IF(B2<1000,19897*(B2^-0.176),71535*(B2^-0.361))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"+L37","v":9810},{"$f":"+M37","v":55},{"$f":"+O37","v":{"v":5899.125015736584,"d":"5899"}},1000,1800,null,null,588,800,{"$nulls":3},353,4000]
[{"$f":"+K39","v":"DOJ 225"},{"$f":"+IF(B2<=I21,8794*(B2^-0.193))","v":{"$error":"#DIV/0!"}},{"$f":"+(B21/$B$5)^3*7200","v":{"$error":"#DIV/0!"}},null,{"$f":"+L39","v":5640},{"$f":"+M39","v":10},{"$f":"+O39","v":{"v":2318.3898206948393,"d":"2318"}},{"$f":"+M40","v":1000},1800]
[{"$f":"+K42","v":"DOJ 250"},{"$f":"+IF(B2<=I22,13805*(B2^-0.195))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"+L42","v":8820},{"$f":"+M42","v":10},{"$f":"+O42","v":{"v":3589.5202769496577,"d":"3590"}},{"$f":"+M43","v":1000},1800,null,"BJ150",1960,23,"y = 3680.8x-0.201",{"$f":"3680.8*(O12^-0.201)","v":{"v":918.2104270931626,"d":"918"}},{"$f":"3680.8*(P12^-0.201)","v":{"v":2317.0863578607728,"d":"2317"}},{"$f":"+O22","v":{"v":918.2104270931626,"d":"918"}},{"$f":"+O12","v":1000},"y = 6144.4x-0.275",{"$f":"6144.4*(T12^-0.275)","v":{"v":627.9325309143701,"d":"628"}}]
[{"$f":"+K45","v":"DOJ 300"},{"$f":"+IF(B2<=I23,17989*(B2^-0.194))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"+L45","v":11500},{"$f":"+M45","v":10},{"$f":"+O45","v":{"v":4709.849413485132,"d":"4710"}},{"$f":"+M46","v":1000},1800,null,null,981,720,{"$nulls":3},627,4000]
["DOJ350",{"$f":"+IF(B2<=I24,23502*(B2^-0.149))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"$L$48","v":18100},{"$f":"$M$48","v":10},{"$f":"$O$48","v":{"v":8396.626242246633,"d":"8397"}},1000,1800]
["DOJ400",{"$f":"+IF(B2<=I25, 48453*(B2^-0.217))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"$L$51","v":26900},{"$f":"$M$51","v":10},{"$f":"$O$51","v":{"v":10822.327491280774,"d":"10822"}},1000,1800,null,"BJ175",2940,33,"y = 6101.9x-0.209",{"$f":"6101.9*(O12^-0.209)","v":{"v":1440.3402131044563,"d":"1440"}},{"$f":"6101.9*(P12^-0.209)","v":{"v":3771.0742720045996,"d":"3771"}},{"$f":"+O25","v":{"v":1440.3402131044563,"d":"1440"}},{"$f":"+O12","v":1000},"y = 15026x-0.339",{"$f":"15026*(T12^-0.339)","v":{"v":903.1191420194533,"d":"903"}}]
["DOJ450",{"$f":"+IF(B2<=I26,76118*(B2^-0.245))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"$L$54","v":38300},{"$f":"$M$54","v":10},{"$f":"$O$54","v":{"v":14011.5883207814,"d":"14012"}},1000,1800,null,null,1960,230,{"$nulls":3},981,3100]
["DOJ500",{"$f":"+IF(B2<=I27,86221*(B2^-0.189))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"$L$57","v":52700},{"$f":"$M$57","v":10},{"$f":"$O$57","v":{"v":23367.543269326037,"d":"23368"}},1000,1800]
["DOJ550",{"$f":"+IF(B2<=I28,107025*(B2^-0.176))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"$L$60","v":70400},{"$f":"$M$60","v":10},{"$f":"$O$60","v":{"v":31731.107946384273,"d":"31731"}},1000,1800,null,"BJ200",3920,62,"y = 8596.5x-0.19",{"$f":"8596.5*(O12^-0.19)","v":{"v":2313.7778941957736,"d":"2314"}},{"$f":"8596.5*(P12^-0.19)","v":{"v":5550.366579896416,"d":"5550"}},{"$f":"+O28","v":{"v":2313.7778941957736,"d":"2314"}},{"$f":"+O12","v":1000},"y = 31800x-0.379",{"$f":"31800*(T12^-0.379)","v":{"v":1371.6597133308605,"d":"1372"}}]
["DOJ625",{"$f":"+IF(B2<=I29,135671*(B2^-0.17))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"$L$63","v":99000},{"$f":"$M$63","v":10},{"$f":"$O$63","v":{"v":41926.34716245514,"d":"41926"}},1000,1800,null,null,2452,730,{"$nulls":3},1471,3300]
["n/a"]
[{"$nulls":10},"BJ225",6867,19,"y = 12361x-0.2",{"$f":"12361*(O12^-0.2)","v":{"v":3104.942817988992,"d":"3105"}},{"$f":"12361*(P12^-0.2)","v":{"v":7799.263735119669,"d":"7799"}},{"$f":"+O31","v":{"v":3104.942817988992,"d":"3105"}},{"$f":"+O12","v":1000},"y = 30734x-0.332",{"$f":"30734*(T12^-0.332)","v":{"v":1957.6505458315748,"d":"1958"}}]
["HD Series",{"$nulls":10},3920,315,{"$nulls":3},1960,4000]
["Model","TCAE","Speed Max"]
["DOX 225F","TCAE-04-HD",3000,{"$nulls":7},"BJ250",9810,14,"y = 15962x-0.184",{"$f":"15962*(O12^-0.184)","v":{"v":4478.033172898526,"d":"4478"}},{"$f":"15962*(P12^-0.184)","v":{"v":10449.302610461844,"d":"10449"}},{"$f":"+O34","v":{"v":4478.033172898526,"d":"4478"}},{"$f":"+O12","v":1000},"y = 51095x-0.352",{"$f":"51095*(T12^-0.352)","v":{"v":2757.1048774658348,"d":"2757"}}]
["DOX 250F","TCAE-05-HD",3000,{"$nulls":8},4905,600,{"$nulls":3},2940,3300]
["DOX 285F","TCAE-06-HD",3000]
["DOX 300F","TCAE-07-HD",3000,{"$nulls":7},"BJ300",9810,55,"y = 19897x-0.176",{"$f":"19897*(O12^-0.176)","v":{"v":5899.125015736584,"d":"5899"}},{"$f":"19897*(P12^-0.176)","v":{"v":13267.45428704344,"d":"13267"}},{"$f":"+O37","v":{"v":5899.125015736584,"d":"5899"}},{"$f":"+O12","v":1000},"y = 71535x-0.361",{"$f":"71535*(T12^-0.361)","v":{"v":3582.4069981504063,"d":"3582"}}]
["DOX 315F","TCAE-08-HD",3000,{"$nulls":8},5880,1000,{"$nulls":3},3920,3100]
["DOX 350F","TCAE-09-HD",3000,{"$nulls":7},"DOJ 225",5640,10,"y = 8794x-0.193",{"$f":"8794*(O12^-0.193)","v":{"v":2318.3898206948393,"d":"2318"}},{"$f":"8794*(P12^-0.193)","v":{"v":5638.797016489912,"d":"5639"}}]
["DOX 390F","TCAE-10-HD",3000,{"$nulls":8},2320,1000]
["DOX440F","TCAE-11-HD",2500]
["DOX 490F","TCAE-12-HD",2500,{"$nulls":7},"DOJ 250",8820,10,"y = 13805x-0.195",{"$f":"13805*(O12^-0.195)","v":{"v":3589.5202769496577,"d":"3590"}},{"$f":"13805*(P12^-0.195)","v":{"v":8811.227426860523,"d":"8811"}}]
["DOX550F","TCAE-13-HD",2000,{"$nulls":8},3600,1000]
["DOX625F","TCAE-14-HD",2000]
[{"$nulls":10},"DOJ 300",11500,10,"y = 17989x-0.194",{"$f":"17989*(O12^-0.194)","v":{"v":4709.849413485132,"d":"4710"}},{"$f":"17989*(P12^-0.194)","v":{"v":11508.189955497357,"d":"11508"}}]
["S series",{"$nulls":10},4700,1000]
["Model","limit torque","life calc hrs","BORE d","TCAE MODEL","weight","dia"]
[{"$nulls":3},"max ",null,"kgs","mm",{"$nulls":3},"DOJ350",18100,10,"y = 23502x-0.149",{"$f":" 23502*(O12^-0.149)","v":{"v":8396.626242246633,"d":"8397"}},{"$f":" 23502*(P12^-0.149)","v":{"v":16676.496702675562,"d":"16676"}}]
["BC225 - F",{"$f":"5977.3*($B$2^-0.214)","v":{"$error":"#DIV/0!"}},{"$f":"+(B49/$B$4)^3*7200","v":{"$error":"#DIV/0!"}},60,"TCAE-6-S",30,244,{"$nulls":4},{"$f":"(9810-7850)/2+7850","v":8830},1000]
["BC240 - F",{"$f":"8433*($B$2^-0.212)","v":{"$error":"#DIV/0!"}},{"$f":"+(B50/$B$4)^3*7200","v":{"$error":"#DIV/0!"}},80,"TCAE-7-S",39,272]
["BC287 - F",{"$f":"14994*($B$2^-0.21)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},90,"TCAE-8-S",50,292,{"$nulls":3},"DOJ400",26900,10,"y = 48453x-0.217",{"$f":"48453*(O12^-0.217)","v":{"v":10822.327491280774,"d":"10822"}},{"$f":"48453*(P12^-0.217)","v":{"v":29398.19537755185,"d":"29398"}}]
["BC350 - F",{"$f":"24172*($B$2^-0.21)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},130,"TCAE-9-S",74,336,{"$nulls":4},11000,1000]
["BC410 - F",{"$f":"36373*($B$2^-0.209)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},145,"TCAE-10-S",103,376]
["BC450 - F",{"$f":"50250*($B$2^-0.202)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},180,"TCAE-11-S",137,420,{"$nulls":3},"DOJ450",38300,10,"y = 76118x-0.245",{"$f":"76118*(O12^-0.245)","v":{"v":14011.5883207814,"d":"14012"}},{"$f":"76118*(P12^-0.245)","v":{"v":43299.94738997152,"d":"43300"}}]
["BC500 - F",{"$f":"69123*($B$2^-0.202)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},200,"TCAE-12-S",181,462,{"$nulls":4},15700,1000]
["BC550 - F",{"$f":"92168*($B$2^-0.201)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},190,"TCAE-13-S",226,504]
["BC600 - F",{"$f":"166875*($B$2^-0.201)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},250,"TCAE-14-S",274,548,{"$nulls":3},"DOJ500",52700,10,"y =  86221x-0.189",{"$f":"  86221*(O12^-0.189)","v":{"v":23367.543269326037,"d":"23368"}},{"$f":" 86221*(P12^-0.189)","v":{"v":55797.283472458585,"d":"55797"}}]
[{"$nulls":11},21700,1000]
[]
[{"$nulls":10},"DOJ550",70400,10,"y = 107025x-0.176",{"$f":" 107025*(O12^-0.176)","v":{"v":31731.107946384273,"d":"31731"}},{"$f":" 107025*(P12^-0.176)","v":{"v":71364.99447508791,"d":"71365"}}]
[{"$nulls":11},29000,1000]
[]
[{"$nulls":10},"DOJ625",99000,10,"y = 135671x-0.17",{"$f":" 135671*(O12^-0.17)","v":{"v":41926.34716245514,"d":"41926"}},{"$f":" 135671*(P12^-0.17)","v":{"v":91724.85335440557,"d":"91725"}}]
[{"$nulls":11},40700,1000]
[]
[{"$nulls":10},"BC225",null,null,"y = 5977.3x-0.214"]
[{"$nulls":10},"BC240",null,null,"y = 8433x-0.212"]
[{"$nulls":10},"BC287",null,null,"y = 14994x-0..21"]
[{"$nulls":10},"BC350",null,null,"y = 24172x-0.21"]
[{"$nulls":10},"BC410",null,null,"y = 36373x-0.209"]
[{"$nulls":10},"BC450",null,null,"y = 50250x-0.202"]
[{"$nulls":10},"BC500",null,null,"y = 69123x-0.202"]
[{"$nulls":10},"BC550",null,null,"y = 92168x-0.201"]
[{"$nulls":10},"BC600",null,null,"y = 166875x-0.201"]
[]
[]
[{"$nulls":10},"This table shows the static rated capacities of the AE couplings. Use these values when: Duty cycle is very low (less than 1 hour per day) or when the rotation speed is very low (less than 100 rpm)   \n"]
[{"$nulls":10},"NTN ref","Static load and non reversing and minimal starts & stops (Nm)","Static load and reversing and frequent starts & stops (Nm)"]
[{"$nulls":9},"TCAE 0","BJ 75 DS",588,392]
[{"$nulls":9},"TCAE 1","BJ 95 DS",{"v":1130,"d":"1,130"},637]
[{"$nulls":9},"TCAE 2","BJ 125 DS",{"v":2750,"d":"2,750"},{"v":1470,"d":"1,470"}]
[{"$nulls":9},"TCAE 3","BJ 150 DS",{"v":4710,"d":"4,710"},{"v":2890,"d":"2,890"}]
[{"$nulls":9},"TCAE 4","BJ 175 DS",{"v":6720,"d":"6,720"},{"v":4020,"d":"4,020"}]
[{"$nulls":9},"TCAE 5","BJ 200 DS",{"v":11200,"d":"11,200"},{"v":5880,"d":"5,880"}]
[{"$nulls":9},"TCAE 6","BJ 225 DS",{"v":14700,"d":"14,700"},{"v":7550,"d":"7,550"}]
[{"$nulls":9},"TCAE 7","BJ 250 DS",{"v":20700,"d":"20,700"},{"v":10700,"d":"10,700"}]
[{"$nulls":9},"TCAE 8","BJ 300 DS",{"v":29100,"d":"29,100"},{"v":15800,"d":"15,800"}]
[{"$nulls":9},"TCAE 9","DO J350",{"v":0,"d":"0.00"},{"v":22900,"d":"22,900"}]
[{"$nulls":9},"TCAE 10","DOJ 400",{"v":0,"d":"0.00"},{"v":34100,"d":"34,100"}]
[{"$nulls":9},"TCAE 11","DOJ 450",{"v":0,"d":"0.00"},{"v":48500,"d":"48,500"}]
[{"$nulls":9},"TCAE 12","DOJ 500",{"v":0,"d":"0.00"},{"v":66800,"d":"66,800"}]
[{"$nulls":9},"TCAE 13","DOJ 550",{"v":0,"d":"0.00"},{"v":89100,"d":"89,100"}]
[{"$nulls":9},"TCAE 14","DOJ 625",{"v":0,"d":"0.00"},{"v":116000,"d":"116,000"}]

{"sheet":"Model tables","index":3,"n_rows":64,"n_cols":41,"rows_kept":64,"hidden":true,"merged":[[6,4,7,4],[6,5,6,6],[6,7,7,7],[6,8,7,8],[6,12,7,12],[6,13,6,14],[6,16,7,16],[6,21,6,22],[6,24,7,24],[6,31,7,31],[21,4,21,5],[21,12,21,13],[21,20,21,21],[26,0,26,1],[26,30,26,31],[27,0,27,1],[28,0,28,1],[29,0,29,1],[31,30,31,31],[36,30,36,31],[41,30,41,31],[47,9,47,12]]}
["Model tables"]
["From initial selection "]
["life reqd 1yr",{"$f":"+Formulas!D6","v":0},"hrs"]
["life reqd 1yr",{"$f":"+Formulas!D7","v":0},"hrs"]
["life reqd 1yr",{"$f":"+Formulas!D8","v":0},"hrs"]
[{"$nulls":4},"R series",{"$nulls":7},"L series",{"$nulls":7},"CM series",{"$nulls":7},"S series",{"$nulls":7},"HD Series"]
[{"$nulls":4},"Model","D.B.S.E. ",null,"TCAE MODEL","LIFE hrs","weight","dia",null,"Model","D.B.S.E. ",null,"TCAE MODEL","LIFE hrs","weight","dia",null,"Model","D.B.S.E. ",null,"TCAE MODEL","LIFE hrs","weight","dia",null,"Model","BORE d","TCAE MODEL","LIFE hrs","weight","dia"]
["Coupling","limit torque","life calc hrs",null,null,"min","max 1",null,null,"kgs","mm",null,null,"max 1","max 2",null,null,"kgs","mm",null,null,"max 1","max 2",null,null,"kgs","mm",null,null,"max ",null,null,"kgs","mm",null,null,"Model","TCAE","Speed Max"]
["BC75",{"v":85.94859282334248,"d":"86"},{"v":0.013234862433706189,"d":"0"},null,"BC75 - R",82,90,"TCAE-0-R",{"$f":"+Formulas!C12","v":{"$error":"#DIV/0!"}},{"v":3.9,"d":"4"},"117",null,"BC75 - L",90,1500,"TCAE-0-L",{"$f":"+Formulas!C12","v":{"$error":"#DIV/0!"}},"L dependant","117",null,"DOJ350 - CM",500,2500,"TCAE-09-CM",{"$f":"+Formulas!C24","v":{"$error":"#DIV/0!"}},"L dependant","336",null,"BC225 - F",{"$f":"+Formulas!D49","v":60},"TCAE-06-S",{"$f":"+Formulas!C49","v":{"$error":"#DIV/0!"}},30,244,null,null,"DOX 225F","TCAE-04-HD",3000]
["BJ095",{"v":186.20310213734226,"d":"186"},{"v":0.13457483486602362,"d":"0"},null,"BJ095 - R",130,147,"TCAE-1-R",{"$f":"+Formulas!C13","v":{"$error":"#DIV/0!"}},{"v":9.1,"d":"9"},"148",null,"BJ095 - L",147,1800,"TCAE-1-L",{"$f":"+Formulas!C13","v":{"$error":"#DIV/0!"}},"L dependant","148",null,"DOJ400 - CM",550,2500,"TCAE-10-CM",{"$f":"+Formulas!C25","v":{"$error":"#DIV/0!"}},"L dependant","376",null,"BC240 - F",{"$f":"+Formulas!D50","v":80},"TCAE-07-S",{"$f":"+Formulas!C50","v":{"$error":"#DIV/0!"}},39,272,null,null,"DOX 250F","TCAE-05-HD",3000]
["BJ125",{"v":462.7466972877206,"d":"463"},{"v":2.0655375894434926,"d":"2"},null,"BJ125 - R",136,162,"TCAE-2-R",{"$f":"+Formulas!C14","v":{"$error":"#DIV/0!"}},{"v":14.7,"d":"15"},"178",null,"BJ125 - L",162,2000,"TCAE-2-L",{"$f":"+Formulas!C14","v":{"$error":"#DIV/0!"}},"L dependant","178",null,"DOJ450 - CM",600,3000,"TCAE-11-CM",{"$f":"+Formulas!C26","v":{"$error":"#DIV/0!"}},"L dependant","420",null,"BC287 - F",{"$f":"+Formulas!D51","v":90},"TCAE-08-S",{"$f":"+Formulas!C51","v":{"$error":"#DIV/0!"}},50,292,null,null,"DOX 285F","TCAE-06-HD",3000]
["BJ150",{"v":782.1310755614405,"d":"782"},{"v":9.973365707081804,"d":"10"},null,"BJ150 - R",240,270,"TCAE-3-R",{"$f":"+Formulas!C15","v":{"$error":"#DIV/0!"}},{"v":31.5,"d":"32"},"215",null,"BJ150 - L",270,2000,"TCAE-3-L",{"$f":"+Formulas!C15","v":{"$error":"#DIV/0!"}},"L dependant","215",null,"DOJ500 - CM",650,3000,"TCAE-12-CM",{"$f":"+Formulas!C27","v":{"$error":"#DIV/0!"}},"L dependant","462",null,"BC350 - F",{"$f":"+Formulas!D52","v":130},"TCAE-09-S",{"$f":"+Formulas!C52","v":{"$error":"#DIV/0!"}},74,336,null,null,"DOX 300F","TCAE-07-HD",3000]
["BJ175",{"v":1183.875424308071,"d":"1184"},{"v":34.587656345792176,"d":"35"},null,"BJ175 - R",276,285,"TCAE-4-R",{"$f":"+Formulas!C16","v":{"$error":"#DIV/0!"}},{"v":45.5,"d":"46"},"253",null,"BJ175 - L",285,2000,"TCAE-4-L",{"$f":"+Formulas!C16","v":{"$error":"#DIV/0!"}},"L dependant","253",null,"DOJ550 - CM",700,3000,"TCAE-13-CM",{"$f":"+Formulas!C28","v":{"$error":"#DIV/0!"}},"L dependant","504",null,"BC410 - F",{"$f":"+Formulas!D53","v":145},"TCAE-10-S",{"$f":"+Formulas!C53","v":{"$error":"#DIV/0!"}},103,376,null,null,"DOX 315F","TCAE-08-HD",3000]
["BJ200",{"v":1856.4311221926196,"d":"1856"},{"v":133.36431576069475,"d":"133"},null,"BJ200 - R",276,300,"TCAE-5-R",{"$f":"+Formulas!C17","v":{"$error":"#DIV/0!"}},{"v":58.2,"d":"58"},"278",null,"BJ200 - L",300,2000,"TCAE-5-L",{"$f":"+Formulas!C17","v":{"$error":"#DIV/0!"}},"L dependant","278",null,"DOJ625 - CM",700,3000,"TCAE-14-CM",{"$f":"+Formulas!C29","v":{"$error":"#DIV/0!"}},"L dependant","580",null,"BC450 - F",{"$f":"+Formulas!D54","v":180},"TCAE-11-S",{"$f":"+Formulas!C54","v":{"$error":"#DIV/0!"}},137,420,null,null,"DOX 350F","TCAE-09-HD",3000]
["BJ225",{"v":2551.9291645602752,"d":"2552"},{"v":346.4247922475012,"d":"346"},null,"BJ225 - R",291,312,"TCAE-6-R",{"$f":"+Formulas!C18","v":{"$error":"#DIV/0!"}},74,"300",null,"BJ225 - L",312,2000,"TCAE-6-L",{"$f":"+Formulas!C18","v":{"$error":"#DIV/0!"}},"L dependant","300",null,"N/A",{"$nulls":7},"BC500 - F",{"$f":"+Formulas!D55","v":200},"TCAE-12-S",{"$f":"+Formulas!C55","v":{"$error":"#DIV/0!"}},181,462,null,null,"DOX 390F","TCAE-10-HD",3000]
["BJ250",{"v":3651.9303135083483,"d":"3652"},{"v":1015.2443109347605,"d":"1,015"},null,"BJ250 - R",310,330,"TCAE-7-R",{"$f":"+Formulas!C19","v":{"$error":"#DIV/0!"}},103,"330",null,"BJ250 - L",330,2000,"TCAE-7-L",{"$f":"+Formulas!C19","v":{"$error":"#DIV/0!"}},"L dependant","330",{"$nulls":9},"BC550 - F",{"$f":"+Formulas!D56","v":190},"TCAE-13-S",{"$f":"+Formulas!C56","v":{"$error":"#DIV/0!"}},226,504,null,null,"DOX440F","TCAE-11-HD",2500]
["BJ300",{"v":4779.310067181934,"d":"4779"},{"v":2275.614754222496,"d":"2,276"},null,"BJ300 - R",326,344,"TCAE-8-R",{"$f":"+Formulas!C20","v":{"$error":"#DIV/0!"}},116,"370",null,"BJ300 - L",344,2000,"TCAE-8-L",{"$f":"+Formulas!C20","v":{"$error":"#DIV/0!"}},"L dependant","370",{"$nulls":9},"BC600 - F",{"$f":"+Formulas!D57","v":250},"TCAE-14-S",{"$f":"+Formulas!C57","v":{"$error":"#DIV/0!"}},274,548,null,null,"DOX 490F","TCAE-12-HD",2500]
["DOJ350",{"v":7692.5303551182515,"d":"7693"},{"v":8373.675158139991,"d":"8,374"},null,"N/A",500,500,"use S or CM series",{"$nulls":4},"N/A",{"$nulls":15},"N/A",{"$nulls":7},"DOX550F","TCAE-13-HD",2000]
["DOJ400",{"v":9526.350103346074,"d":"9526"},{"v":15903.32989425121,"d":"15,903"},null,{"$f":"IF(E20=E9,E9,INDEX(E9:E17,MATCH(E20,E9:E17,0)-1,1))","v":{"$error":"#DIV/0!"}},"LESSER",{"$nulls":6},{"$f":"IF(M20=M9,M9,INDEX(M9:M17,MATCH(M20,M9:M17,0)-1,1))","v":{"$error":"#DIV/0!"}},"LESSER",{"$nulls":6},{"$f":"IF(U20=U9,U9,INDEX(U9:U14,MATCH(U20,U9:U14,0)-1,1))","v":{"$error":"#DIV/0!"}},"LESSER",{"$nulls":6},{"$f":"IF(AC20=AC9,AC9,INDEX(AC9:AC17,MATCH(AC20,AC9:AC17,0)-1,1))","v":{"$error":"#DIV/0!"}},"LESSER",{"$nulls":6},"DOX625F","TCAE-14-HD",2000]
["DOJ450",{"v":12132.368839043957,"d":"12132"},{"v":32850.74839582939,"d":"32,851"},null,{"$f":"+IF(Formulas!$D$7<'Model tables'!I9,'Model tables'!E9,+IF(Formulas!$D$7<'Model tables'!I10,'Model tables'!E10,+IF(Formulas!$D$7<'Model tables'!I11,'Model tables'!E11,+IF(Formulas!$D$7<'Model tables'!I12,'Model tables'!E12,+IF(Formulas!$D$7<'Model tables'!I13,'Model tables'!E13,+IF(Formulas!$D$7<'Model tables'!I14,'Model tables'!E14,+IF(Formulas!$D$7<'Model tables'!I15,'Model tables'!E15,+IF(Formulas!$D$7<'Model tables'!I16,'Model tables'!E16,+IF(Formulas!$D$7<'Model tables'!I17,'Model tables'!E17,E18)))))))))","v":{"$error":"#DIV/0!"}},"IDEAL",{"$nulls":6},{"$f":"+IF(Formulas!$D$7<'Model tables'!Q9,'Model tables'!M9,+IF(Formulas!$D$7<'Model tables'!Q10,'Model tables'!M10,+IF(Formulas!$D$7<'Model tables'!Q11,'Model tables'!M11,+IF(Formulas!$D$7<'Model tables'!Q12,'Model tables'!M12,+IF(Formulas!$D$7<'Model tables'!Q13,'Model tables'!M13,+IF(Formulas!$D$7<'Model tables'!Q14,'Model tables'!M14,+IF(Formulas!$D$7<'Model tables'!Q15,'Model tables'!M15,+IF(Formulas!$D$7<'Model tables'!Q16,'Model tables'!M16,+IF(Formulas!$D$7<'Model tables'!Q17,'Model tables'!M17,M18)))))))))","v":{"$error":"#DIV/0!"}},"IDEAL",{"$nulls":6},{"$f":"+IF(Formulas!$D$7<'Model tables'!Y9,'Model tables'!U9,+IF(Formulas!$D$7<'Model tables'!Y10,'Model tables'!U10,+IF(Formulas!$D$7<'Model tables'!Y11,'Model tables'!U11,+IF(Formulas!$D$7<'Model tables'!Y12,'Model tables'!U12,+IF(Formulas!$D$7<'Model tables'!Y13,'Model tables'!U14,+IF(Formulas!$D$7<'Model tables'!Y14,'Model tables'!U13,U15))))))","v":{"$error":"#DIV/0!"}},"IDEAL",{"$nulls":6},{"$f":"+IF(Formulas!$D$7<'Model tables'!AF9,'Model tables'!AC9,+IF(Formulas!$D$7<'Model tables'!AF10,'Model tables'!AC10,+IF(Formulas!$D$7<'Model tables'!AF12,'Model tables'!AC11,+IF(Formulas!$D$7<'Model tables'!AF11,'Model tables'!AC12,+IF(Formulas!$D$7<'Model tables'!AF13,'Model tables'!AC13,+IF(Formulas!$D$7<'Model tables'!AF14,'Model tables'!AC14,+IF(Formulas!$D$7<'Model tables'!AF15,'Model tables'!AC15,+IF(Formulas!$D$7<'Model tables'!AF16,'Model tables'!AC16,+IF($B$4<AF17,AC17,AC18)))))))))","v":{"$error":"#DIV/0!"}},"IDEAL"]
["DOJ500",{"v":20910.602774025814,"d":"20911"},{"v":168193.07451617598,"d":"168,193"},null,{"$f":"IF(E20=E17,E17,INDEX(E9:E17,MATCH(E20,E9:E17,0)+1,1))","v":{"$error":"#DIV/0!"}},"GREATER",{"$nulls":6},{"$f":"IF(M20=M17,M17,INDEX(M9:M17,MATCH(M20,M9:M17,0)+1,1))","v":{"$error":"#DIV/0!"}},"GREATER",{"$nulls":6},{"$f":"IF(U20=U14,U14,INDEX(U9:U14,MATCH(U20,U9:U14,0)+1,1))","v":{"$error":"#DIV/0!"}},"GREATER",{"$nulls":6},{"$f":"IF(AC20=AC17,AC17,INDEX(AC9:AC17,MATCH(AC20,AC9:AC17,0)+1,1))","v":{"$error":"#DIV/0!"}},"GREATER"]
["DOJ550",{"v":28612.596842852447,"d":"28613"},{"v":430903.7563467428,"d":"430,904"},null,"DBSE",{"$nulls":7},"DBSE",{"$nulls":7},"DBSE"]
["DOJ625",{"v":37939.421128383336,"d":"37939"},{"v":1004570.8082530169,"d":"1,004,571"},null,"min","max",{"$nulls":6},"min","max",{"$nulls":6},"min","max"]
[{"$nulls":4},{"$f":"+VLOOKUP(E20,E9:G18,2)","v":{"$error":"#DIV/0!"}},{"$f":"+VLOOKUP(E20,E9:G18,3)","v":{"$error":"#DIV/0!"}},{"$nulls":6},{"$f":"+VLOOKUP(M20,M9:O17,2)","v":{"$error":"#DIV/0!"}},{"$f":"+VLOOKUP(M20,M9:O17,3)","v":{"$error":"#DIV/0!"}},{"$nulls":6},{"$f":"+VLOOKUP(U20,U9:W17,2)","v":{"$error":"#DIV/0!"}},{"$f":"+VLOOKUP(U20,U9:W17,3)","v":{"$error":"#DIV/0!"}}]
["Determine final selection based on shaft details",{"$nulls":22},{"$f":"INDEX(A12:A29,MATCH(G7,A12:A29,0)-1,1)","v":{"$error":"#N/A"}}]
["Given from data entry",{"$nulls":32}," max shaft  dia",null,null,"FINAL SELECTION"]
["motor shaft diameter",null,{"$f":"+DriveShaftdia.","v":0},"mm",null,null,"Arg 1",{"$nulls":22},"Arg 1",{"$f":"+IF(AD28=1,\"S Series Required\",0)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"+MAX(C27:C29)","v":0},"check S series against life required",{"$nulls":4},"check S series against life shaft diameter size","TCAE model"]
["driven shaft diameter",null,{"$f":"+DrivenShaftdia.","v":0},"mm",null,"\"S\" series",{"$f":"+IF(C30<E24,1,0)","v":{"$error":"#DIV/0!"}},{"$nulls":21},"\"S\" series",{"$f":"+IF(G33<>1,+IF(G28=1,1,+IF(V28=1,1,0)))","v":{"$error":"#DIV/0!"}},"Selected",{"$f":"+IF(AD28=1,+IF(AH27<=AD9,AC9,+IF(AH27<=AD10,AC10,+IF(AH27<=AD11,AC11,+IF(AH27<=AD12,AC12,+IF(AH27<=AD13,AC13,+IF(AH27<=AD14,AC14,+IF(AH27<=AD15,AC15,+IF(AH27<=AD16,AC16,+IF(AH27<=AD17,AC17,AC18))))))))))","v":{"$error":"#DIV/0!"}},"LESSER",{"$f":"+VLOOKUP(AF28,AC9:AF17,4)","v":{"$error":"#DIV/0!"}},{"$f":"+IF(AH28<B3,\"Larger model required\",\"OK\")","v":{"$error":"#DIV/0!"}},null,{"$f":"+IF(AI28<>\"OK\",AC19,AF28)","v":{"$error":"#DIV/0!"}},"LESSER",{"$f":"+VLOOKUP(AK28,AC9:AF17,4)","v":{"$error":"#DIV/0!"}},{"$f":"+IF(+VLOOKUP(AK28,AC9:AD17,2)>=AH27,\"OK\",\"check shaft diameter\")","v":{"$error":"#DIV/0!"}},{"$f":"+VLOOKUP(AK28,AC9:AE17,3)","v":{"$error":"#DIV/0!"}}]
["gearbox shaft diameter",null,{"$f":"+gearshaftdia","v":0},"mm",{"$nulls":27},{"$f":"+IF(AD28=1,+IF(AH27<=AD9,AC9,+IF(AH27<=AD10,AC10,+IF(AH27<=AD11,AC11,+IF(AH27<=AD12,AC12,+IF(AH27<=AD13,AC13,+IF(AH27<=AD14,AC14,+IF(AH27<=AD15,AC15,+IF(AH27<=AD16,AC16,+IF(AH27<=AD17,AC17,AC18))))))))))","v":{"$error":"#DIV/0!"}},"IDEAL",{"$f":"+VLOOKUP(AF29,AC9:AF17,4)","v":{"$error":"#DIV/0!"}},{"$f":"+IF(AH29<B4,\"Larger model required\",\"OK\")","v":{"$error":"#DIV/0!"}},null,{"$f":"+IF(AI29<>\"OK\",AC20,AF29)","v":{"$error":"#DIV/0!"}},"IDEAL",{"$f":"+VLOOKUP(AK29,AC9:AF17,4)","v":{"$error":"#DIV/0!"}},{"$f":"+IF(+VLOOKUP(AK29,AC9:AD17,2)>=AH27,\"OK\",\"check shaft diameter\")","v":{"$error":"#DIV/0!"}},{"$f":"+VLOOKUP(AK29,AC9:AE17,3)","v":{"$error":"#DIV/0!"}}]
["DBSE",null,{"$f":"+DBSE.","v":0},"mm",{"$nulls":27},{"$f":"+IF(AD28=1,+IF(AH27<=AD9,AC9,+IF(AH27<=AD10,AC10,+IF(AH27<=AD11,AC11,+IF(AH27<=AD12,AC12,+IF(AH27<=AD13,AC13,+IF(AH27<=AD14,AC14,+IF(AH27<=AD15,AC15,+IF(AH27<=AD16,AC16,+IF(AH27<=AD17,AC17,AC18))))))))))","v":{"$error":"#DIV/0!"}},"GREATER",{"$f":"+VLOOKUP(AF30,AC9:AF17,4)","v":{"$error":"#DIV/0!"}},{"$f":"+IF(AH30<B5,\"Larger model required\",\"OK\")","v":{"$error":"#DIV/0!"}},null,{"$f":"+IF(AI30<>\"OK\",AC21,AF30)","v":{"$error":"#DIV/0!"}},"GREATER",{"$f":"+VLOOKUP(AK30,AC9:AF17,4)","v":{"$error":"#DIV/0!"}},{"$f":"+IF(+VLOOKUP(AK30,AC9:AD17,2)>=AH27,\"OK\",\"check shaft diameter\")","v":{"$error":"#DIV/0!"}},{"$f":"+VLOOKUP(AK30,AC9:AE17,3)","v":{"$error":"#DIV/0!"}}]
[]
[{"$nulls":6},"Arg 2",{"$nulls":6},"Arg 2",{"$nulls":7},"Arg 2",{"$nulls":7},"Arg 2",{"$f":"+IF(AD33=1,\"R series Required\",0)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},"\"R\" series",{"$f":"+IF(C30<=F24,+IF(C30>=E24,1,0))","v":{"$error":"#DIV/0!"}},{"$nulls":5},"\"R\" series",{"$f":"+IF(C30<=N24,+IF(H32>=M24,1,0))","v":{"$error":"#DIV/0!"}},{"$nulls":6},"\"R\" series",{"$f":"+IF(C30<=V24,+IF(P32>=U24,1,0))","v":{"$error":"#DIV/0!"}},{"$nulls":6},"\"R\" series",{"$f":"+IF(G33=1,1,0)","v":{"$error":"#DIV/0!"}},"Selected",{"$f":"+IF(AD33=1,+VLOOKUP(E19,E9:H18,4))","v":{"$error":"#DIV/0!"}},"LESSER",{"$f":"+VLOOKUP(AF33,H9:I17,2)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":31},{"$f":"+IF(AD33=1,+VLOOKUP(E20,E9:H18,4))","v":{"$error":"#DIV/0!"}},"IDEAL",{"$f":"+VLOOKUP(AF34,H9:I17,2)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":31},{"$f":"+IF(AD33=1,+VLOOKUP(E21,E9:H18,4))","v":{"$error":"#DIV/0!"}},"GREATER",{"$f":"+VLOOKUP(AF35,H9:I17,2)","v":{"$error":"#DIV/0!"}}]
[]
[{"$nulls":6},"Arg 3",{"$nulls":6},"Arg 3",{"$nulls":7},"Arg 3",{"$nulls":7},"Arg 3",{"$f":"+IF(AD38=1,\"L series Required\",0)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},"\"L\" series",{"$f":"+IF(C30<=N24,+IF(C33>=M24,1,0))","v":{"$error":"#DIV/0!"}},{"$nulls":5},"\"L\" series",{"$f":"+IF(C30<=N24,+IF(C30>=M24,+IF(M20<>\"N/A\",1,0)))","v":{"$error":"#DIV/0!"}},{"$nulls":6},"\"L\" series",{"$f":"+IF(C30<=V24,+IF(C30>=U24,+IF(M20<>\"N/A\",1,0)))","v":{"$error":"#DIV/0!"}},{"$nulls":6},"\"L\" series",{"$f":"+IF(N38=1,1,0)","v":{"$error":"#DIV/0!"}},"Selected",{"$f":"+IF(AD38=1,+VLOOKUP(M19,M9:P17,4))","v":{"$error":"#DIV/0!"}},"LESSER",{"$f":"+VLOOKUP(AF38,P9:Q17,2)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":31},{"$f":"+IF(AD38=1,+VLOOKUP(M20,M9:P17,4))","v":{"$error":"#DIV/0!"}},"IDEAL",{"$f":"+VLOOKUP(AF39,P9:Q17,2)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":31},{"$f":"+IF(AD38=1,+VLOOKUP(M21,M9:P17,4))","v":{"$error":"#DIV/0!"}},"GREATER",{"$f":"+VLOOKUP(AF40,P9:Q17,2)","v":{"$error":"#DIV/0!"}}]
[]
[{"$nulls":6},"Arg 4",{"$nulls":6},"Arg 4",{"$nulls":7},"Arg 4",{"$nulls":7},"Arg 4",{"$f":"+IF(AD43=1,\"CM series Required\",0)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},"\"CM\" series",{"$f":"+IF(E20=\"n/a\",0)","v":{"$error":"#DIV/0!"}},{"$nulls":5},"\"CM\" series",{"$f":"+IF(M20=\"n/a\",0)","v":{"$error":"#DIV/0!"}},{"$nulls":6},"\"CM\" series",{"$f":"+IF(C30<=V24,+IF(C30>=U24,+IF(E20=\"N/A\",+IF(M20=\"N/A\",1,\"N/A\"))))","v":{"$error":"#DIV/0!"}},{"$nulls":6},"\"CM\" series",{"$f":"+IF(V43=1,1,0)","v":{"$error":"#DIV/0!"}},"Selected",{"$f":"+IF(AD43=1,+VLOOKUP(U19,U9:X14,4))","v":{"$error":"#DIV/0!"}},"LESSER",{"$f":"+VLOOKUP(AF43,X9:Y14,2)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":31},{"$f":"+IF(AD43=1,+VLOOKUP(U20,U9:X14,4))","v":{"$error":"#DIV/0!"}},"IDEAL",{"$f":"+VLOOKUP(AF44,X9:Y14,2)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":31},{"$f":"+IF(AD43=1,+VLOOKUP(U21,U9:X14,4))","v":{"$error":"#DIV/0!"}},"GREATER",{"$f":"+VLOOKUP(AF45,X9:Y14,2)","v":{"$error":"#DIV/0!"}}]
[]
[]
[{"$nulls":8},"WEIGHT","SHAFT SIZE /\nBORE SIZE",{"$nulls":3},"DIAMETER","TAPER LOCK"]
[{"$nulls":8},"kg","mm",null,null,"inch","mm","#"]
[{"$nulls":7},"TCAE-0",{"v":3.9,"d":"4"},"14 to 50",null,null,"0.75 to 2.0","117","1615"]
["Arg 1 - defines if S series or not based on DBSE <min",{"$nulls":6},"TCAE-1",{"v":9.1,"d":"9"},"16 to 60",null,null,"0.75 to 2.5","148","2517"]
["Arg 2 - defines if R series or not based on DBSE >min and <max1",{"$nulls":6},"TCAE-2",{"v":14.7,"d":"15"},"16 to 60",null,null,"0.75 to 2.5","178","2517"]
["Arg 3 - defines if L series or not based on DBSE >max1 and <max2",{"$nulls":6},"TCAE-3",{"v":31.5,"d":"32"},"25 to 75",null,null,"1.0 to 3.0","215","3020"]
["Arg 4 - defines if CM series or not based on model size N/A",{"$nulls":6},"TCAE-4",{"v":45.5,"d":"46"},"35 to 90",null,null,"1.375 to 3.5","253","3525"]
[{"$nulls":7},"TCAE-5",{"v":58.2,"d":"58"},"35 to 90",null,null,"1.375 to 3.5","278","3525"]
[{"$nulls":7},"TCAE-6",74,"35 to 90",null,null,"1.375 to 3.5","300","3525"]
[{"$nulls":7},"TCAE-7",103,"35 to 90",null,null,"1.375 to 3.5","330","3525"]
[{"$nulls":7},"TCAE-8",116,"35 to 90",null,null,"1.375 to 3.5","370","3525"]
[{"$nulls":7},"TCAE-9-CM","n/a",170,{"$nulls":3},"336","bore & key"]
[{"$nulls":7},"TCAE-10-CM","n/a",190,{"$nulls":3},"376","bore & key"]
[{"$nulls":7},"TCAE-11-CM","n/a",210,{"$nulls":3},"420","bore & key"]
[{"$nulls":7},"TCAE-12-CM","n/a",235,{"$nulls":3},"462","bore & key"]
[{"$nulls":7},"TCAE-13-CM","n/a",250,{"$nulls":3},"504","bore & key"]
[{"$nulls":7},"TCAE-14-CM","n/a",290,{"$nulls":3},"580","bore & key"]

{"sheet":"Daves scratchpad 2","index":5,"n_rows":123,"n_cols":32,"rows_kept":123,"hidden":true,"merged":[[1,1,1,11],[3,1,3,6],[4,5,4,7],[4,18,4,31],[35,16,41,16],[35,17,35,18],[35,19,35,20],[35,22,35,23],[35,24,35,25],[36,17,36,18],[36,19,36,20],[36,22,36,23],[36,24,36,25],[37,17,37,18],[37,19,37,20],[37,22,37,23],[37,24,37,25],[38,17,38,18],[38,19,38,20],[38,22,38,23],[38,24,38,25],[39,17,39,18],[39,19,39,20],[39,22,39,23],[39,24,39,25],[40,17,40,18],[40,19,40,20],[40,22,40,23],[40,24,40,25],[41,17,41,18],[41,19,41,20],[41,22,41,23],[41,24,41,25],[42,17,42,18],[44,1,44,6],[45,4,45,17],[55,17,63,17],[83,20,83,21],[83,24,83,25],[84,16,84,17],[84,20,84,21],[84,24,84,25],[85,16,85,17],[85,20,85,21],[85,24,85,25],[86,16,86,17],[86,20,86,21],[86,24,86,25],[87,16,87,17],[87,20,87,21],[87,24,87,25],[88,16,88,17],[88,20,88,21],[89,16,89,17],[89,20,89,21],[90,16,90,17],[90,20,90,21],[90,24,90,25],[91,16,91,17],[91,20,91,21],[92,16,92,17],[92,20,92,21],[93,16,93,17],[93,20,93,21],[93,24,93,25],[94,16,94,17],[94,20,94,21],[95,16,95,17],[95,20,95,21],[96,16,96,17],[96,20,96,21],[97,16,97,17],[97,20,97,21],[98,1,98,6],[102,0,110,0],[114,0,122,0]]}
[null,"OBJECTIVE: "]
[2,"Determine the correlation between Service life data and strength data for BJ and DOJ to apply to BCF models"]
[]
[null,"BJ-D Series comparison of dynamic torque to life torques"]
[{"$nulls":5},"formulas",{"$nulls":5},"Rule 1","Rule 2",{"$nulls":5},"rpm"]
[null,"Model","static","dyn rev","dyn fwd","static ","dyn fwd","dyn rev",null,"rev/static","fwd/static","Dyn fwd","Dyn rev",null,"Model","static","dyn fwd","dyn rev",10,50,100,200,300,400,500,600,800,1000,1500,2000,3000,4000]
[1,"BJ75",1520,392,558,{"$f":"+(998.24*A7^2)-(2886.5*A7)+4599","v":{"v":2710.74,"d":"2,711"}},{"$f":"+(475.67*A7^2)-(1369.7*A7)+1952.2","v":{"v":1058.17,"d":"1,058"}},{"$f":"+(249.43*(A7^2))-(713.79*A7)+1147.6","v":{"v":683.24,"d":"683"}},null,{"$f":"+H7/F7","v":{"v":0.25204925592273697,"d":"0.252"}},{"$f":"+H7/G7","v":{"v":0.6456807507300338,"d":"0.646"}},{"$f":"+M7/0.54","v":{"v":703.7037037037037,"d":"704"}},{"$f":"0.25*C7","v":380},null,"BJ75",1520,558,392,285,209,183,160,151,140,134,129,122,117,102,93,81,74]
[2,"BJ95",2500,637,{"v":1127,"d":"1,127"},{"$f":"+(998.24*A8^2)-(2886.5*A8)+4599","v":{"v":2818.96,"d":"2,819"}},{"$f":"+(475.67*A8^2)-(1369.7*A8)+1952.2","v":{"v":1115.48,"d":"1,115"}},{"v":717.74,"d":"718"},null,{"$f":"+H8/F8","v":{"v":0.2546116298209269,"d":"0.255"}},{"$f":"+H8/G8","v":{"v":0.6434360096102126,"d":"0.643"}},{"v":1157.4074074074074,"d":"1,157"},625,null,"BJ95",2500,{"v":1127,"d":"1,127"},637,570,415,365,320,300,280,270,260,245,234,205,186,162,148]
[3,"BJ125",5780,1470,{"v":2744,"d":"2,744"},{"v":4923.66,"d":"4,924"},{"v":2124.129999999999,"d":"2,124"},{"v":1251.1,"d":"1251"},null,{"v":0.2540995925795039,"d":"0.254"},{"v":0.5889940822830996,"d":"0.589"},{"v":2675.9259259259256,"d":"2,676"},{"v":1445,"d":"1,445"},null,"BJ125",5780,{"v":2744,"d":"2,744"},1470,{"v":1350,"d":"1,350"},980,860,730,710,660,630,610,580,550,485,440,385,350]
[4,"BJ150",11564,2890,{"v":4704,"d":"4,704"},{"v":9024.84,"d":"9,025"},{"v":4084.12,"d":"4,084"},{"v":2283.32,"d":"2283"},null,{"v":0.2530039313716365,"d":"0.253"},{"v":0.5590727010959522,"d":"0.559"},{"v":5353.7037037037035,"d":"5,354"},{"v":2891,"d":"2,891"},null,"BJ150",11564,{"v":4704,"d":"4,704"},2890,{"v":2300,"d":"2,300"},1700,1450,1300,1200,1150,1100,1050,980,940,820,750,650,600]
[5,"BJ175",15680,4018,{"v":6713,"d":"6,713"},{"v":15122.5,"d":"15,123"},{"v":6995.45,"d":"6,995"},{"v":3814.4,"d":"3814"},null,{"v":0.2522334270127294,"d":"0.252"},{"v":0.5452687103760302,"d":"0.545"},{"v":7259.259259259259,"d":"7,259"},{"v":3920,"d":"3,920"},null,"BJ175",15680,{"v":6713,"d":"6,713"},4018,{"v":3650,"d":"3,650"},2650,2350,2050,1950,1800,1700,1650,1550,1500,1300,1200,1050,940]
[6,"BJ200",23912,5880,{"v":11172,"d":"11,172"},{"v":23216.64,"d":"23,217"},{"v":10858.119999999999,"d":"10,858"},{"v":5844.34,"d":"5844"},null,{"v":0.25173065525416255,"d":"0.252"},{"v":0.5382460315413718,"d":"0.538"},{"v":11070.37037037037,"d":"11,070"},{"v":5978,"d":"5,978"},null,"BJ200",23912,{"v":11172,"d":"11,172"},5880,{"v":5500,"d":"5,500"},4000,3500,3050,2900,2700,2550,2500,2350,2250,1950,1800,1550,1400]
[7,"BJ225",29694,7546,{"v":14700,"d":"14,700"},{"v":33307.26,"d":"33,307"},{"v":15672.130000000003,"d":"15,672"},{"v":8373.14,"d":"8373"},null,{"v":0.2513908379134158,"d":"0.251"},{"v":0.5342694324255859,"d":"0.534"},{"v":13747.22222222222,"d":"13,747"},{"v":7423.5,"d":"7,424"},null,"BJ225",29694,{"v":14700,"d":"14,700"},7546,{"v":7800,"d":"7,800"},5700,5000,4350,4150,3800,3650,3550,3350,3200,2800,2550,2200,2000]
[8,"BJ250",42238,10682,{"v":20678,"d":"20,678"},{"v":45394.36,"d":"45,394"},{"v":21437.48,"d":"21,437"},{"v":11400.800000000001,"d":"11401"},null,{"v":0.25115014288118614,"d":"0.251"},{"v":0.5318162395953256,"d":"0.532"},{"v":19554.629629629628,"d":"19,555"},{"v":10559.5,"d":"10,560"},null,"BJ250",42238,{"v":20678,"d":"20,678"},10682,{"v":10600,"d":"10,600"},7800,6800,6000,5700,5200,5000,4850,4600,4400,3800,3450,3050,2750]
[9,"BJ300",63112,15780,{"v":29106,"d":"29,106"},{"v":59477.94,"d":"59,478"},{"v":28154.170000000002,"d":"28,154"},{"v":14927.320000000002,"d":"14927"},null,{"v":0.25097237732174316,"d":"0.251"},{"v":0.5301992564511758,"d":"0.530"},{"v":29218.51851851852,"d":"29,219"},{"v":15778,"d":"15,778"},null,"BJ300",63112,{"v":29106,"d":"29,106"},15780,{"v":14100,"d":"14,100"},10300,9000,7900,7500,6900,6700,6300,6100,5800,5100,4600,4000,3650]
[{"$nulls":9},{"$f":"AVERAGE(J7:J15)","v":{"v":0.2523602055642268,"d":"0.252"}},{"$f":"AVERAGE(K7:K15)","v":{"v":0.5685536904565319,"d":"0.569"}},"fair","good"]
[{"$nulls":3},"Rules:"]
[null,null,1,"Dynamic reversing = 0.54 x Dynamic fwd (non reversing)"]
[null,null,2,"Dynamic reversing = 0.25 x Static"]
{"$rows_empty":15}
[{"$nulls":12},"Correlation Summary",null,null,"R2 coeff"]
[{"$nulls":12},"torque at rpm","Dynamic Rev","Dynamic Fwd","Static","Most accurate parameter","Linear equation Dynamic Fwd",null,"inverse equation for dynamic Fwd",null,null,"Linear equation Dynamic Rev",null,"inverse equation for dynamic Rev"]
[{"$nulls":12},10,0.9918,0.9972,0.99,null,"2.0185x - 184.87",null,"(y-184.87)/2.0185",null,null,"1.0617x + 32.667",null,"(y-32.667)/1.0617"]
[{"$nulls":12},100,0.9911,0.9967,0.9892,null,"3.1548x - 176.69",null,"(y-176.69)/3.1548",null,null,"1.6591x + 37.583",null,"(y-37.583)/1.6591"]
[{"$nulls":12},500,0.993,0.9978,0.9913,null,"4.2631x - 127.94",null,"(y-127.94)/4.2631",null,null,"2.2429x + 60.951",null,"(y-60.951)/2.2429"]
[{"$nulls":12},1000,0.9912,0.9969,0.9894,null,"4.8915x - 154.63",null,"(y-154.63)/4.8915",null,null,"2.5724x + 49.256",null,"(y-49.256)/2.5724"]
[{"$nulls":12},2000,0.9918,0.9971,0.9901,null,"6.1911x - 199.04",null,"(y-199.04)/6.1911",null,null,"3.2564x + 24.918",null,"(y-24.918)/3.2564"]
[{"$nulls":12},4000,0.9922,0.9973,0.9904,null,"7.8041x - 162.31",null,"(y-162.31)/7.8041",null,null,"4.1051x + 43.836",null,"(y-43.836)/4.1051"]
[{"$nulls":12},"AVG",{"$f":"AVERAGE(N37:N42)","v":{"v":0.99185,"d":"0.9919"}},{"$f":"AVERAGE(O37:O42)","v":{"v":0.9971666666666666,"d":"0.9972"}},{"$f":"AVERAGE(P37:P42)","v":{"v":0.9900666666666665,"d":"0.9901"}}]
[]
[null,"DOJ Series comparison of dynamic torque to life torques"]
[{"$nulls":4},"rpm"]
[null,"Model","static","dyn rev",10,50,100,200,300,400,500,600,800,1000,1500,2000,3000,4000]
[null,"DOJ68",1090,275,180,130,118,104,97,93,89,87,81,78,69,61,56,49]
[null,"DOJ75",1520,392,250,176,167,148,137,132,125,122,110,110,98,88,79,69]
[null,"DOJ87",2500,640,400,284,260,230,215,205,196,190,180,172,154,137,124,108]
[null,"DOJ100",3720,880,580,420,387,343,318,303,289,284,264,255,225,200,184,160]
[null,"DOJ125",5780,1470,1180,862,784,686,637,617,588,568,540,515,460,410,370,323]
[null,"DOJ150",11560,2890,2060,1470,1370,1176,1120,1070,1030,980,930,900,800,715,647,558]
[null,"DOJ175",15680,4010,3330,2440,2130,1870,730,1630,560,1520,1430,1370,1190,1080,950,860]
[null,"DOJ200",23900,5880,5450,3990,3500,3050,2830,2670,2560,2480,2350,2240,1960,1781,1558,1410]
[null,"DOJ225",29700,7200,5640,4150,3630,3170,2940,2770,2660,2570,2430,2320,2020,1870,1640]
[null,"DOJ250",42000,11000,8820,6470,5600,4960,4600,4340,4150,4000,3800,3600,3180,2920,2550]
[null,"DOJ300",63000,14500,11500,8400,7350,6400,5900,5600,5400,5200,4900,4700,4120,3800,3330]
[null,"DOJ350",92000,23000,18100,13300,11600,10200,9400,8900,8500,8200,7800,7500,6520,6020,5260]
[null,"DOJ400",142000,34000,26900,19800,17200,15000,14000,13200,12700,12200,11500,11000,9690,8900,7830]
[null,"DOJ450",187000,49000,38300,28100,24600,21500,19900,18800,18000,17400,16400,15700,13800,12700,11100]
[null,"DOJ500",260000,67000,52700,38700,33800,29600,27400,25800,24800,24000,22600,21700,19300,17500,15300]
[null,"DOJ550",343000,89000,70400,51600,45200,39500,36500,34600,33100,32000,30000,29000,25700,23400,20400]
[null,"DOJ625",618000,116000,99000,72700,63600,55600,51400,48700,46600,45000,42600,40700,36300,33000,28800]
{"$rows_empty":18}
[{"$nulls":13},"Correlation Summary",null,null,"R2 coeff"]
[{"$nulls":13},"torque at rpm","Dynamic Rev","Static","Linear equation Dynamic Rev",{"$nulls":3},"inverse equation for dynamic reverse",{"$nulls":3},"inverse equation for dynamic Rev"]
[{"$nulls":13},10,0.9976,0.9809,"1.2135x + 466.27",{"$nulls":3},"(y-466.27)/1.2135",{"$nulls":3},"(y-32.667)/1.0617"]
[{"$nulls":13},50,0.9976,null,"1.653x + 478.84",{"$nulls":3},"(y-478.84)/1.653",{"$nulls":3},"(y-37.583)/1.6591"]
[{"$nulls":13},100,0.9976,0.981,"1.8899x + 477.35",{"$nulls":3},"(y-477.35)/1.8899",{"$nulls":3},"(y-60.951)/2.2429"]
[{"$nulls":13},200,0.9976,null,"2.1597x + 538.33",{"$nulls":3},"(y-538.33)/2.1597",{"$nulls":3},"(y-49.256)/2.5724"]
[{"$nulls":13},300,0.9976,null,"2.3299x + 713.64",{"$nulls":3},"(y-643.72)/2.3321"]
[{"$nulls":13},400,0.9976,null,"2.4675x + 533.71",{"$nulls":3},"(y-463.5)/2.4698"]
[{"$nulls":13},500,0.9975,0.9805,"2.5698x + 735.4",{"$nulls":3},"(y-735.4)/2.5698",{"$nulls":3},"(y-24.918)/3.2564"]
[{"$nulls":13},600,0.9977,null,"2.6676x + 520.47",{"$nulls":3},"(y-450.2)/2.6702"]
[{"$nulls":13},800,0.9973,null,"2.8271x + 527.28",{"$nulls":3},"(y-527.28)/2.8271"]
[{"$nulls":13},1000,0.9977,0.9807,"2.9485x +520.95",{"$nulls":3},"(y-520.95)/2.9485",{"$nulls":3},"(y-43.836)/4.1051"]
[{"$nulls":13},1500,0.9973,null,"3.3127x + 653.13",{"$nulls":3},"(y-653.13)/3.3127"]
[{"$nulls":13},2000,0.9975,0.98,"3.6421x + 577.43",{"$nulls":3},"(y-577.43)/3.6421"]
[{"$nulls":13},3000,0.9975,0.9814,"4.1744x + 526.93",{"$nulls":3},"(y-526.93)/4.1744"]
[{"$nulls":13},4000,0.9913,0.9814,"4.1933x + 200.65",{"$nulls":3},"(y-200.65)/4.1933"]
[null,"BCF Series comparison of dynamic torque to life torques",{"$nulls":11},"AVG",{"$f":"AVERAGE(O85:O97)","v":{"v":0.9975461538461539,"d":"0.9975"}},{"$f":"AVERAGE(P85:P97)","v":{"v":0.98075,"d":"0.9808"}}]
[]
[{"$nulls":4},"rpm"]
[null,"Model","Static Nm","dyn rev",10,50,100,200,300,400,500,600,800,1000,1500,2000,3000]
["Correlation with DOJ data","BC225F",16170,4753,{"$f":"+(D103-466.27)/1.2135","v":{"v":3532.533992583436,"d":"3533"}},{"$f":"+(D103-478.84)/1.653","v":{"v":2585.698729582577,"d":"2586"}},{"$f":"+(D103-477.35)/1.8899","v":{"v":2262.3683792793267,"d":"2262"}},{"$f":"+(D103-538.33)/2.1597","v":{"v":1951.5071537713573,"d":"1952"}},{"$f":"+(D103-713.64)/2.3299","v":{"v":1733.70530924074,"d":"1734"}},{"$f":"+(D103-533.71)/2.4675","v":{"v":1709.9452887537996,"d":"1710"}},{"$f":"+(D103-735.4)/2.5698","v":{"v":1563.3901470931592,"d":"1563"}},{"$f":"+(D103-520.47)/2.6676","v":{"v":1586.6434248013193,"d":"1587"}},{"$f":"+(D103-527.28)/2.8271","v":{"v":1494.7189699692265,"d":"1495"}},{"$f":"+(D103-520.95)/2.9585","v":{"v":1430.4715227311137,"d":"1430"}},{"$f":"+(D103-653.13)/3.3127","v":{"v":1237.6218794336946,"d":"1238"}},{"$f":"+(D103-577.43)/3.6421","v":{"v":1146.4731885450701,"d":"1146"}},{"$f":"+(D103-526.93)/4.1744","v":{"v":1012.3778267535453,"d":"1012"}}]
[null,"BC240F",22187,6527,{"$f":"+(D104-466.27)/1.2135","v":{"v":4994.421096003296,"d":"4994"}},{"$f":"+(D104-478.84)/1.653","v":{"v":3658.898971566848,"d":"3659"}},{"$f":"+(D104-477.35)/1.8899","v":{"v":3201.042383194878,"d":"3201"}},{"$f":"+(D104-538.33)/2.1597","v":{"v":2772.9175348428025,"d":"2773"}},{"$f":"+(D104-713.64)/2.3299","v":{"v":2495.1113781707368,"d":"2495"}},{"$f":"+(D104-533.71)/2.4675","v":{"v":2428.8915906788247,"d":"2429"}},{"$f":"+(D104-665.53)/2.5723","v":{"v":2278.6883333981264,"d":"2279"}},{"$f":"+(D104-520.47)/2.6676","v":{"v":2251.660668765932,"d":"2252"}},{"$f":"+(D104-527.28)/2.8271","v":{"v":2122.2171129425915,"d":"2122"}},{"$f":"+(D104-520.95)/2.9585","v":{"v":2030.0997126922427,"d":"2030"}},{"$f":"+(D104-653.13)/3.3127","v":{"v":1773.1367162737345,"d":"1773"}},{"$f":"+(D104-577.43)/3.6421","v":{"v":1633.5548172757474,"d":"1634"}},{"$f":"+(D104-526.93)/4.1744","v":{"v":1437.3490801073206,"d":"1437"}}]
[null,"BC287F",38328,11270,{"v":8902.95014421096,"d":"8903"},{"v":6528.227465214761,"d":"6528"},{"v":5710.698978781947,"d":"5711"},{"v":4969.055887391767,"d":"4969"},{"v":4530.8210652817725,"d":"4531"},{"v":4351.08004052685,"d":"4351"},{"v":4122.563464603662,"d":"4123"},{"v":4029.6633678212625,"d":"4030"},{"v":3799.908032966644,"d":"3800"},{"v":3633.276998478959,"d":"3633"},{"v":3204.8993268330973,"d":"3205"},{"v":2935.825485296944,"d":"2936"},{"v":2573.5602721349173,"d":"2574"}]
[null,"BC350F",60868,17905,{"v":14370.605686032139,"d":"14371"},{"v":10542.141560798547,"d":"10542"},{"v":9221.466744272186,"d":"9221"},{"v":8041.241839144325,"d":"8041"},{"v":7378.582771792781,"d":"7379"},{"v":7040.036474164134,"d":"7040"},{"v":6701.967111145668,"d":"6702"},{"v":6516.917828759933,"d":"6517"},{"v":6146.835980333204,"d":"6147"},{"v":5875.96755112388,"d":"5876"},{"v":5207.797265070788,"d":"5208"},{"v":4757.57667279866,"d":"4758"},{"v":4163.010252970486,"d":"4163"}]
[null,"BC410F",90856,26725,{"v":21638.838071693448,"d":"21639"},{"v":15877.894736842105,"d":"15878"},{"v":13888.380337584,"d":"13888"},{"v":12125.142380886233,"d":"12125"},{"v":11164.152967938538,"d":"11164"},{"v":10614.504559270517,"d":"10615"},{"v":10130.805116044008,"d":"10131"},{"v":9823.260608786923,"d":"9823"},{"v":9266.640727247002,"d":"9267"},{"v":8857.208044617204,"d":"8857"},{"v":7870.278020949679,"d":"7870"},{"v":7179.256472913978,"d":"7179"},{"v":6275.88875047911,"d":"6276"}]
[null,"BC450F",129360,38053,{"v":30973.819530284305,"d":"30974"},{"v":22730.88929219601,"d":"22731"},{"v":19882.348272395368,"d":"19882"},{"v":17370.31532157244,"d":"17370"},{"v":16026.164213056356,"d":"16026"},{"v":15205.386018237084,"d":"15205"},{"v":14534.646036620925,"d":"14535"},{"v":14069.774328984853,"d":"14070"},{"v":13273.573626684589,"d":"13274"},{"v":12686.175426736523,"d":"12686"},{"v":11289.845141425425,"d":"11290"},{"v":10289.549984898822,"d":"10290"}]
[null,"BC500F",177449,52195,{"v":42627.7132262052,"d":"42628"},{"v":31286.24319419238,"d":"31286"},{"v":27365.283877453836,"d":"27365"},{"v":23918.447006528684,"d":"23918"},{"v":22095.952615992104,"d":"22096"},{"v":20936.693009118542,"d":"20937"},{"v":20032.449558760643,"d":"20032"},{"v":19371.16884090568,"d":"19371"},{"v":18275.872802518483,"d":"18276"},{"v":17466.300490113234,"d":"17466"},{"v":15558.870407824434,"d":"15559"},{"v":14172.474671206171,"d":"14172"}]
[null,"BC550F",236190,69462,{"v":56856.80263700041,"d":"56857"},{"v":41732.09921355112,"d":"41732"},{"v":36501.74612413355,"d":"36502"},{"v":31913.538917442238,"d":"31914"},{"v":29507.00030044208,"d":"29507"},{"v":27934.464032421478,"d":"27934"},{"v":26745.119154064458,"d":"26745"},{"v":25844.028340080968,"d":"25844"},{"v":24383.544975416502,"d":"24384"},{"v":23302.704073009972,"d":"23303"},{"v":20771.234944305248,"d":"20771"},{"v":18913.42082864282,"d":"18913"}]
[null,"BC600F",441980,125440,{"v":102986.18046971569,"d":"102986"},{"v":75596.58802177859,"d":"75597"},{"v":66121.30271442933,"d":"66121"},{"v":57832.879566606476,"d":"57833"},{"v":53532.92415983519,"d":"53533"},{"v":50620.58358662614,"d":"50621"},{"v":48506.96652800996,"d":"48507"},{"v":46828.433798170634,"d":"46828"},{"v":44184.04725690637,"d":"44184"},{"v":42223.77894203144,"d":"42224"},{"v":37669.23355570984,"d":"37669"},{"v":34283.125120123004,"d":"34283"}]
[]
[{"$nulls":4},"rpm"]
[null,"Model","Static Nm","dyn rev",10,50,100,200,300,400,500,600,800,1000,1500,2000,3000,4000]
["Correlation with BJD data","BC225F",16170,4753,{"$f":"+(D115-32.667)/1.0617","v":{"v":4446.013939907694,"d":"4446"}},null,{"$f":"+(D115-37.583)/1.6591","v":{"v":2842.153577240673,"d":"2842"}},{"$nulls":3},{"$f":"+(D115-60.951)/2.2429","v":{"v":2091.956395737661,"d":"2092"}},null,null,{"$f":"+(D115-49.256)/2.5724","v":{"v":1828.542994868605,"d":"1829"}},null,{"$f":"+(D115-24.918)/3.2564","v":{"v":1451.9352659378455,"d":"1452"}},null,{"$f":"+(D115-43.836)/4.1051","v":{"v":1147.1496431268422,"d":"1147"}}]
[null,"BC240F",22187,6527,{"$f":"+(D116-32.667)/1.0617","v":{"v":6116.919092022227,"d":"6117"}},null,{"$f":"+(D116-37.583)/1.6591","v":{"v":3911.407992284974,"d":"3911"}},{"$nulls":3},{"$f":"+(D116-60.951)/2.2429","v":{"v":2882.896696241473,"d":"2883"}},null,null,{"v":2518.1713574871715,"d":"2518"},null,{"v":1996.7086353027883,"d":"1997"},null,{"v":1579.295023263745,"d":"1579"}]
[null,"BC287F",38328,11270,{"v":10584.282754073654,"d":"10584"},null,{"v":6770.186848291241,"d":"6770"},{"$nulls":3},{"v":4997.569664273931,"d":"4998"},null,null,{"v":4361.974809516405,"d":"4362"},null,{"v":3453.225033779634,"d":"3453"},null,{"v":2734.6870965384524,"d":"2735"}]
[null,"BC350F",60868,17905,{"v":16833.694075539228,"d":"16834"},null,{"v":10769.343017298535,"d":"10769"},{"$nulls":3},{"v":7955.793392482945,"d":"7956"},null,null,{"v":6941.278183797232,"d":"6941"},null,{"v":5490.75113622405,"d":"5491"},null,{"v":4350.9692821124945,"d":"4351"}]
[null,"BC410F",90856,26725,{"v":25141.12555335782,"d":"25141"},null,{"v":16085.478271351938,"d":"16085"},{"$nulls":3},{"v":11888.202327344063,"d":"11888"},null,null,{"v":10369.982895350644,"d":"10370"},null,{"v":8199.263603979854,"d":"8199"},null,{"v":6499.516211541741,"d":"6500"}]
[null,"BC450F",129360,38053,{"v":35810.80625412075,"d":"35811"},null,{"v":22913.276475197395,"d":"22913"},{"$nulls":3},{"v":16938.80645592759,"d":"16939"},null,null,{"v":14773.652620121287,"d":"14774"},null,{"v":11677.951725832207,"d":"11678"},null,{"v":9259.01049913522,"d":"9259"}]
[null,"BC500F",177449,52195,{"v":49130.95318828294,"d":"49131"},null,{"v":31437.174974383703,"d":"31437"},{"$nulls":3},{"v":23244.036292300145,"d":"23244"},null,null,{"v":20271.242419530397,"d":"20271"},null,{"v":16020.78430168284,"d":"16021"},null,{"v":12703.993568975176,"d":"12704"}]
[null,"BC550F",236190,69462,{"v":65394.49279457473,"d":"65394"},null,{"v":41844.624796576456,"d":"41845"},{"$nulls":3},{"v":30942.551607294125,"d":"30943"},null,null,{"v":26983.651065153168,"d":"26984"},null,{"v":21323.265569340372,"d":"21323"},null,{"v":16910.224842269374,"d":"16910"}]
[null,"BC600F",441980,125440,{"v":118119.36799472543,"d":"118119"},null,{"v":75584.60430353806,"d":"75585"},{"$nulls":3},{"v":55900.41865442061,"d":"55900"},null,null,{"v":48744.65246462448,"d":"48745"},null,{"v":38513.414199729756,"d":"38513"},null,{"v":30546.433460817032,"d":"30546"}]

{"sheet":" Daves scratchpad 1","index":6,"n_rows":52,"n_cols":34,"rows_kept":52,"hidden":true,"merged":[[2,1,2,11],[22,0,22,1],[22,5,22,6],[22,10,22,11],[22,15,22,16],[22,20,22,21],[22,25,22,26],[22,30,22,31],[43,2,43,5]]}
[]
[null,"OBJECTIVE: "]
[1,"Determine the optimum duty factor for TCAE based on real life failed coupling life"]
[]
[]
["Case 1 - Visy","PM3 turbo pump",{"$nulls":3},"Case 2 - Visy","PM6 turbo pump",{"$nulls":3},"Case 3 - CHH K1","Kiln 1 Fan 1",{"$nulls":3},"Case 4 - CHH K1","Kiln 6 Fan 8",{"$nulls":3},"Case 5 - CHH K1","Kiln7 Fan 7",{"$nulls":3},"Case 6 - CHH K1","Kiln 9 Fan 7",{"$nulls":3},"Case 7 - CHH K1","Kiln 10 Fan 3"]
["Motor",18.5,"kW",null,null,"Motor",22,"kW",null,null,"Motor",15,"kW",null,null,"Motor",15,"kW",null,null,"Motor",15,"kW",null,null,"Motor",15,"kW",null,null,"Motor",15,"kW"]
["speed",1440,"rpm",null,null,"speed",1450,"rpm",null,null,"speed",980,"rpm",null,null,"speed",980,"rpm",null,null,"speed",980,"rpm",null,null,"speed",980,"rpm",null,null,"speed",980,"rpm"]
["MSF",1.25,{"$nulls":3},"MSF",1.25,{"$nulls":3},"MSF",1.25,{"$nulls":3},"MSF",1.25,{"$nulls":3},"MSF",1.25,{"$nulls":3},"MSF",1.25,{"$nulls":3},"MSF",1.25]
["DCF",1.44,{"$nulls":3},"DCF",1.44,{"$nulls":3},"DCF",1.44,{"$nulls":3},"DCF",1.44,{"$nulls":3},"DCF",1.44,{"$nulls":3},"DCF",1.44,{"$nulls":3},"DCF",1.44]
["AF",0.95,{"$nulls":3},"AF",0.95,{"$nulls":3},"AF",0.95,{"$nulls":3},"AF",0.95,{"$nulls":3},"AF",0.95,{"$nulls":3},"AF",0.95,{"$nulls":3},"AF",0.95]
["Load capacity",{"v":0.8,"d":"80%"},{"$nulls":3},"Load capacity",{"v":0.8,"d":"80%"},{"$nulls":3},"Load capacity",{"v":0.8,"d":"80%"},{"$nulls":3},"Load capacity",{"v":0.8,"d":"80%"},{"$nulls":3},"Load capacity",{"v":0.8,"d":"80%"},{"$nulls":3},"Load capacity",{"v":0.8,"d":"80%"},{"$nulls":3},"Load capacity",{"v":0.8,"d":"80%"}]
["Original result","TCAE","Life hours","Life days",null,"Original result","TCAE","Life hours","Life days",null,"Original result","TCAE","Life hours","Life days",null,"Original result","TCAE","Life hours","Life days",null,"Original result","TCAE","Life hours","Life days",null,"Original result","TCAE","Life hours","Life days",null,"Original result","TCAE","Life hours","Life days"]
[null,"TCAE 1R",{"v":8842,"d":"8,842"},{"$f":"+C14/24","v":{"v":368.4166666666667,"d":"368"}},null,null,"TCAE 1R",{"v":5328,"d":"5,328"},222,null,null,"TCAE 1R",{"$nulls":4},"TCAE 1R",{"$nulls":4},"TCAE 1R",{"$nulls":4},"TCAE 1R",{"$nulls":4},"TCAE 1R"]
[null,"TCAE 2R",{"v":139678,"d":"139,678"},{"$f":"+C15/24","v":{"v":5819.916666666667,"d":"5,820"}},null,null,"TCAE 2R",{"v":84192,"d":"84,192"},{"v":3508,"d":"3,508"},null,null,"TCAE 2R",{"$nulls":4},"TCAE 2R",{"$nulls":4},"TCAE 2R",{"$nulls":4},"TCAE 2R",{"$nulls":4},"TCAE 2R"]
[]
["Actual service history",{"$nulls":4},"Actual service history",{"$nulls":4},"Actual service history",{"$nulls":4},"Actual service history",{"$nulls":4},"Actual service history",{"$nulls":4},"Actual service history",{"$nulls":4},"Actual service history"]
["Model installed",{"$f":"+B14","v":"TCAE 1R"},{"$nulls":3},"Model installed",{"$f":"+G14","v":"TCAE 1R"},{"$nulls":3},"Model installed",{"$f":"+L14","v":"TCAE 1R"},{"$nulls":3},"Model installed",{"$f":"+Q14","v":"TCAE 1R"},{"$nulls":3},"Model installed",{"$f":"+V14","v":"TCAE 1R"},{"$nulls":3},"Model installed",{"$f":"+AA14","v":"TCAE 1R"},{"$nulls":3},"Model installed",{"$f":"+AF14","v":"TCAE 1R"}]
["Installed ","2016-12-13",{"$nulls":3},"Installed ","2017-01-01",{"$nulls":3},"Installed ","2017-01-05",{"$nulls":3},"Installed ","2017-01-05",{"$nulls":3},"Installed ","2017-01-06",{"$nulls":3},"Installed ","2016-11-07",{"$nulls":3},"Installed ","2017-01-05"]
["Failed","2019-01-01",{"$nulls":3},"Failed","2018-05-28",{"$nulls":3},"Failed","2017-08-19",{"$nulls":3},"Failed","2018-03-06",{"$nulls":3},"Failed","2017-11-23",{"$nulls":3},"Failed","2017-06-21",{"$nulls":3},"Failed","2018-04-10"]
["Operation time",{"$f":"+B20-B19","v":749},{"$nulls":3},"Operation time",{"$f":"+G20-G19","v":512},{"$nulls":3},"Operation time",{"$f":"+L20-L19","v":226},{"$nulls":3},"Operation time",{"$f":"+Q20-Q19","v":425},{"$nulls":3},"Operation time",{"$f":"+V20-V19","v":321},{"$nulls":3},"Operation time",{"$f":"+AA20-AA19","v":226},{"$nulls":3},"Operation time",{"$f":"+AF20-AF19","v":460}]
[]
["Updated calculation results",null,"hours","days",null,"Updated calculation results",null,"hours","days",null,"Updated calculation results",null,"hours","days",null,"Updated calculation results",null,"hours","days",null,"Updated calculation results",null,"hours","days",null,"Updated calculation results",null,"hours","days",null,"Updated calculation results",null,"hours","days"]
["Load capacity",{"v":0.8,"d":"80%"},{"$nulls":3},"Load capacity",{"v":0.8,"d":"80%"},{"$nulls":3},"Load capacity",{"v":0.8,"d":"80%"},{"$nulls":3},"Load capacity",{"v":0.8,"d":"80%"},{"$nulls":3},"Load capacity",{"v":0.8,"d":"80%"},{"$nulls":3},"Load capacity",{"v":0.8,"d":"80%"},{"$nulls":3},"Load capacity",{"v":0.8,"d":"80%"}]
["REDUCED LIFE","TCAE-0-R",{"v":972.4156022800536,"d":"972"},{"v":40.5173167616689,"d":"41"},null,"REDUCED LIFE","TCAE-1-R",{"v":5821,"d":"5,821"},243,null,"REDUCED LIFE","TCAE-0-R",{"v":944.6524406451941,"d":"945"},{"v":39.360518360216425,"d":"39"},null,"REDUCED LIFE","TCAE-0-R",{"v":944.6524406451941,"d":"945"},{"v":39.360518360216425,"d":"39"},null,"REDUCED LIFE","TCAE-0-R",{"v":944.6524406451941,"d":"945"},{"v":39.360518360216425,"d":"39"},null,"REDUCED LIFE","TCAE-0-R",{"v":944.6524406451941,"d":"945"},{"v":39.360518360216425,"d":"39"},null,"REDUCED LIFE","TCAE-0-R",{"v":944.6524406451941,"d":"945"},{"v":39.360518360216425,"d":"39"}]
["RECOMMENDED","TCAE-1-R",{"v":9645.823947505127,"d":"9,646"},{"v":401.90933114604695,"d":"402"},null,"RECOMMENDED","TCAE-2-R",{"v":91866,"d":"91,866"},{"v":3828,"d":"3,828"},null,"RECOMMENDED","TCAE-1-R",{"v":8916.807317398849,"d":"8,917"},{"v":371.533638224952,"d":"372"},null,"RECOMMENDED","TCAE-1-R",{"v":8916.807317398849,"d":"8,917"},{"v":371.533638224952,"d":"372"},null,"RECOMMENDED","TCAE-1-R",{"v":8916.807317398849,"d":"8,917"},{"v":371.533638224952,"d":"372"},null,"RECOMMENDED","TCAE-1-R",{"v":8916.807317398849,"d":"8,917"},{"v":371.533638224952,"d":"372"},null,"RECOMMENDED","TCAE-1-R",{"v":8916.807317398849,"d":"8,917"},{"v":371.533638224952,"d":"372"}]
["EXTENDED LIFE","TCAE-2-R",{"v":152373.68477593124,"d":"152,374"},{"v":6348.903532330468,"d":"6,349"},null,"EXTENDED LIFE","TCAE-3-R",{"v":426637.4120803756,"d":"426,637"},{"v":17776.558836682318,"d":"17,777"},null,"EXTENDED LIFE","TCAE-2-R",{"v":130952.02360149057,"d":"130,952"},{"v":5456.334316728774,"d":"5,456"},null,"EXTENDED LIFE","TCAE-2-R",{"v":130952.02360149057,"d":"130,952"},{"v":5456.334316728774,"d":"5,456"},null,"EXTENDED LIFE","TCAE-2-R",{"v":130952.02360149057,"d":"130,952"},{"v":5456.334316728774,"d":"5,456"},null,"EXTENDED LIFE","TCAE-2-R",{"v":130952.02360149057,"d":"130,952"},{"v":5456.334316728774,"d":"5,456"},null,"EXTENDED LIFE","TCAE-2-R",{"v":130952.02360149057,"d":"130,952"},{"v":5456.334316728774,"d":"5,456"}]
["Load capacity",{"v":0.7,"d":"70%"},{"$nulls":3},"Load capacity",{"v":0.7,"d":"70%"},{"$nulls":3},"Load capacity",{"v":0.85,"d":"85%"},{"$nulls":3},"Load capacity",{"v":0.75,"d":"75%"},{"$nulls":3},"Load capacity",{"v":0.85,"d":"85%"},{"$nulls":3},"Load capacity",{"v":0.85,"d":"85%"},{"$nulls":3},"Load capacity",{"v":0.75,"d":"75%"}]
["REDUCED LIFE","TCAE-0-R",{"v":1451.5358261439883,"d":"1,452"},{"v":60.48065942266618,"d":"60"},null,"REDUCED LIFE","TCAE-1-R",{"v":8688.524263592892,"d":"8,689"},{"v":362.0218443163705,"d":"362"},null,"REDUCED LIFE","TCAE-1-R",{"v":7434.000157147508,"d":"7,434"},{"v":309.7500065478128,"d":"310"},null,"REDUCED LIFE","TCAE-0-R",{"v":1146.4581916689526,"d":"1,146"},{"v":47.76909131953969,"d":"48"},null,"REDUCED LIFE","TCAE-1-R",{"v":7434.000157147508,"d":"7,434"},{"v":309.7500065478128,"d":"310"},null,"REDUCED LIFE","TCAE-1-R",{"v":7434.000157147508,"d":"7,434"},{"v":309.7500065478128,"d":"310"},null,"REDUCED LIFE","TCAE-0-R",{"v":1146.4581916689526,"d":"1,146"},{"v":47.76909131953969,"d":"48"}]
["RECOMMENDED","TCAE-1-R",{"v":14398.431081990164,"d":"14,398"},{"v":599.9346284162568,"d":"600"},null,"RECOMMENDED","TCAE-2-R",{"v":137128.88551935548,"d":"137,129"},{"v":5713.703563306478,"d":"5,714"},null,"RECOMMENDED","TCAE-2-R",{"v":109175.5523451467,"d":"109,176"},{"v":4548.981347714446,"d":"4,549"},null,"RECOMMENDED","TCAE-1-R",{"v":10821.70156209353,"d":"10,822"},{"v":450.90423175389714,"d":"451"},null,"RECOMMENDED","TCAE-2-R",{"v":109175.5523451467,"d":"109,176"},{"v":4548.981347714446,"d":"4,549"},null,"RECOMMENDED","TCAE-2-R",{"v":109175.5523451467,"d":"109,176"},{"v":4548.981347714446,"d":"4,549"},null,"RECOMMENDED","TCAE-1-R",{"v":10821.70156209353,"d":"10,822"},{"v":450.90423175389714,"d":"451"}]
["EXTENDED LIFE","TCAE-2-R",{"v":227449.93179380998,"d":"227,450"},{"v":9477.08049140875,"d":"9,477"},null,"EXTENDED LIFE","TCAE-3-R",{"v":636846.5159916981,"d":"636,847"},{"v":26535.27149965409,"d":"26,535"},null,"EXTENDED LIFE","TCAE-3-R",{"v":474731.5588069073,"d":"474,732"},{"v":19780.481616954472,"d":"19,780"},null,"EXTENDED LIFE","TCAE-2-R",{"v":158927.2559027275,"d":"158,927"},{"v":6621.96899594698,"d":"6,622"},null,"EXTENDED LIFE","TCAE-3-R",{"v":474731.5588069073,"d":"474,732"},{"v":19780.481616954472,"d":"19,780"},null,"EXTENDED LIFE","TCAE-3-R",{"v":474731.5588069073,"d":"474,732"},{"v":19780.481616954472,"d":"19,780"},null,"EXTENDED LIFE","TCAE-2-R",{"v":158927.2559027275,"d":"158,927"},{"v":6621.96899594698,"d":"6,622"}]
["Load capacity",{"v":0.65,"d":"65%"},{"$nulls":3},"Load capacity",{"v":0.62,"d":"62%"},{"$nulls":3},"Load capacity",{"v":0.95,"d":"95%"},{"$nulls":3},"Load capacity",{"v":0.76,"d":"76%"},{"$nulls":3},"Load capacity",{"v":0.86,"d":"86%"},{"$nulls":3},"Load capacity",{"v":0.94,"d":"94%"},{"$nulls":3},"Load capacity",{"v":0.74,"d":"74%"}]
["REDUCED LIFE","TCAE-0-R",{"v":1812.9332302863456,"d":"1,813"},{"v":75.5388845952644,"d":"76"},null,"REDUCED LIFE","TCAE-0-R",{"v":1259.6330456896567,"d":"1,260"},{"v":52.48471023706903,"d":"52"},null,"REDUCED LIFE","TCAE-1-R",{"v":5324.864086902711,"d":"5,325"},{"v":221.86933695427965,"d":"222"},null,"REDUCED LIFE","TCAE-0-R",{"v":1101.7961109726714,"d":"1,102"},{"v":45.908171290527974,"d":"46"},null,"REDUCED LIFE","TCAE-1-R",{"v":7702.673419629716,"d":"7,703"},{"v":320.94472581790484,"d":"321"},null,"REDUCED LIFE","TCAE-1-R",{"v":5496,"d":"5,496"},229,null,"REDUCED LIFE","TCAE-0-R",{"v":1193.5671372138358,"d":"1,194"},{"v":49.731964050576494,"d":"50"}]
["RECOMMENDED","TCAE-1-R",{"v":17983.29307645926,"d":"17,983"},{"v":749.3038781858025,"d":"749"},null,"RECOMMENDED","TCAE-1-R",{"v":12504.463690428156,"d":"12,504"},{"v":521.0193204345065,"d":"521"},null,"RECOMMENDED","TCAE-2-R",{"v":78200.82937333515,"d":"78,201"},{"v":3258.367890555631,"d":"3,258"},null,"RECOMMENDED","TCAE-1-R",{"v":10400.125169731851,"d":"10,400"},{"v":433.3385487388271,"d":"433"},null,"RECOMMENDED","TCAE-2-R",{"v":113121.28159074881,"d":"113,121"},{"v":4713.386732947867,"d":"4,713"},null,"RECOMMENDED","TCAE-2-R",{"v":80723,"d":"80,723"},{"v":3363,"d":"3,363"},null,"RECOMMENDED","TCAE-1-R",{"v":11266.374515103276,"d":"11,266"},{"v":469.4322714626365,"d":"469"}]
["EXTENDED LIFE","TCAE-2-R",{"v":284079.47785262374,"d":"284,079"},{"v":11836.644910525989,"d":"11,837"},null,"EXTENDED LIFE","TCAE-2-R",{"v":197354.9382915097,"d":"197,355"},{"v":8223.122428812903,"d":"8,223"},null,"EXTENDED LIFE","TCAE-3-R",{"v":340043.1766173402,"d":"340,043"},{"v":14168.465692389174,"d":"14,168"},null,"EXTENDED LIFE","TCAE-2-R",{"v":152735.99486979505,"d":"152,736"},{"v":6363.99978624146,"d":"6,364"},null,"EXTENDED LIFE","TCAE-3-R",{"v":491888.8999438034,"d":"491,889"},{"v":20495.370830991807,"d":"20,495"},null,"EXTENDED LIFE","TCAE-3-R",{"v":351011,"d":"351,011"},{"v":14625,"d":"14,625"},null,"TCAE-0-R","TCAE-2-R",{"v":165457.71248485576,"d":"165,458"},{"v":6894.071353535656,"d":"6,894"}]
{"$rows_empty":8}
[null,null,"Summary"]
[null,null,"Case #","Plant","Type","%load factor"]
[null,null,1,"Visy","pump",{"$f":"+B32","v":{"v":0.65,"d":"65%"}}]
[null,null,2,"Visy","pump",{"$f":"+G32","v":{"v":0.62,"d":"62%"}}]
[null,null,7,"CHH K10F3","fan ",{"$f":"+AF32","v":{"v":0.74,"d":"74%"}}]
[null,null,4,"CHH K6F8","fan ",{"$f":"+Q32","v":{"v":0.76,"d":"76%"}}]
[null,null,5,"CHH K7F7","fan ",{"$f":"+V32","v":{"v":0.86,"d":"86%"}}]
[null,null,6,"CHH K9F7","fan ",{"$f":"+AA32","v":{"v":0.94,"d":"94%"}}]
[null,null,3,"CHH K1F1","fan ",{"$f":"+L32","v":{"v":0.95,"d":"95%"}}]