{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["T3 Belts Calculator","T3 Chain Calculator"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"T3 Belts Calculator","index":0,"n_rows":152,"n_cols":22,"rows_kept":152,"cut":false,"hidden":false,"merged":[[2,16,2,17],[9,16,11,17],[42,5,42,8],[0,0,0,3],[0,5,0,8],[0,10,0,17],[2,10,2,11],[2,13,2,14],[7,10,7,11],[7,13,7,14]]}
["5mm GT2 Pulleys",null,null,null,null,"5mm HTD/GT3 Belts (includes belts listed in this spreadsheet)",null,null,null,null,"TRUCK TOWN THUNDER | BELT CALCULATOR",null,null,null,null,null,null,null,null,null,"VexPro","mcmaster"]
["Groove Count","Pitch Diameter","Outer Diameter",15.958170000000001,null,"# of Teeth","Length (mm)","Length (in)","Gates PN",null,null,null,null,null,null,null,null,null,null,null,60,{"$f":"37","v":37}]
[18,1.1279999999999999,1.083,"Grooves / In",null,45,225,{"$f":"G3*0.0393701","v":8.8582725},"300-",null,"Pulley 1",null,null,"Pulley 2",null,null,"Center Distance",null,null,null,70,{"$f":"43","v":43}]
[19,1.1910000000000001,1.1459999999999999,null,null,54,270,10.629927,"355-",null,"Groove Count",18,null,"Groove Count",32,null,"Desired Center (in)",5,null,null,80,53]
[20,1.2529999999999999,1.208,4.4729999999999999E-2,null,60,300,11.811029999999999,"375-",null,"Outer Diameter",{"$f":"IF(L6=\"\",\"\",IF(R8=\"3mm\",L6-D42,L6-D5))","v":1.083218881356697},null,"Outer Diameter",{"$f":"IF(O6=\"\",\"\",IF(R8=\"3mm\",O6-D42,O6-D5))","v":1.9605124557452389},null,"Center Add",2E-3,null,null,90,61]
[21,1.3160000000000001,1.2709999999999999,"Belt Thickness (IN)",null,70,350,13.779534999999999,"400-",null,"Pitch Diameter",{"$f":"IF(L4=\"\",\"\",IF(R8=\"3mm\",L4/C42,L4/D2))","v":1.1279488813566969},null,"Pitch Diameter",{"$f":"IF(O4=\"\",\"\",IF(R8=\"3mm\",O4/C42,O4/D2))","v":2.0052424557452388},null,"Ratio",{"$f":"IFERROR(IF(O4>L4,CONCATENATE(ROUND(O4/L4,3),\":1\"),CONCATENATE(\"1:\",ROUND(L4/O4,3))),\"\")","v":"1.778:1"},null,null,100,92]
[22,1.379,1.3340000000000001,null,null,75,375,14.763787499999999,"405-",null,null,null,null,null,null,null,"Belt Width","9mm",null,null,104,75]
[23,1.4410000000000001,1.3959999999999999,null,null,80,400,15.74804,"425-",null,"Larger Belt Choice",null,null,"Smaller Belt Choice",null,null,"Belt Pitch","5mm",null,null,110,80]
[24,1.504,1.4590000000000001,null,null,90,450,17.716545,"450-",null,"# of Teeth",80,null,"# of Teeth",75,null,null,null,null,null,120,95]
[25,1.5669999999999999,1.522,null,null,100,500,19.68505,"500-",null,"Center Distance",5.397372054242199,null,"Center Distance",4.9034459326126685,null,null,null,null,null,130,98]
[26,1.629,1.5840000000000001,null,null,104,520,20.472452000000001,"535-",null,"P1 Teeth in Mesh",8.5338405758705544,null,"P1 Teeth in Mesh",8.486763962135619,null,null,null,null,null,140,100]
[28,1.7549999999999999,1.71,null,null,110,550,21.653554999999997,"565-",null,"P2 Teeth in Mesh",16.828727865119017,null,"P2 Teeth in Mesh",16.912419622870011,null,null,null,null,null,150,104]
[30,1.88,1.835,null,null,120,600,23.622059999999998,"575-",null,null,null,null,null,null,null,null,null,null,null,160,110]
[32,2.0049999999999999,1.96,null,null,130,650,25.590564999999998,"580-",null,null,null,null,null,null,null,null,null,null,null,170,129]
[34,2.1309999999999998,2.0859999999999999,null,null,140,700,27.559069999999998,"600-",null,null,null,null,null,null,null,null,null,null,null,180,134]
[36,2.2559999999999998,2.2109999999999999,null,null,150,750,29.527574999999999,"625-",null,null,null,null,null,null,null,null,null,null,null,200,140]
[38,2.3809999999999998,2.3359999999999999,null,null,160,800,31.496079999999999,"650-",null,null,null,null,null,null,null,null,null,null,null,225,148]
[40,2.5070000000000001,2.4620000000000002,null,null,170,850,33.464585,"700-",null,null,null,null,null,null,null,null,null,null,null,250,150]
[44,2.7570000000000001,2.7120000000000002,null,null,180,900,35.43309,"750-",null,null,null,null,null,null,null,null,null,null,null,null,151]
[45,2.82,2.7749999999999999,null,null,200,1000,39.370100000000001,"800-",null,null,null,null,null,null,null,null,null,null,null,null,160]
[48,3.008,2.9630000000000001,null,null,225,1125,44.291362499999998,"815-",null,null,null,null,null,null,null,null,null,null,null,null,200]
[50,3.133,3.0880000000000001,null,null,250,1250,49.212624999999996,"850-",null,null,null,null,null,null,null,null,null,null,null,null,284]
[52,3.2589999999999999,3.214,null,null,259,1295,50.9842795,"900-",null,null,null,null,null,null,null,null,null,null,null,null,285]
[56,3.5089999999999999,3.464,null,null,315,1575,62.007907499999995,"1000-"]
[60,3.76,3.7149999999999999,null,null,320,1600,62.992159999999998,"1150-"]
[64,4.01,3.9649999999999999,null,null,344,1720,67.716571999999999,"1300-"]
[68,4.2610000000000001,4.2160000000000002,null,null,351,1755,69.094525500000003,"1450-"]
[null,null,null,null,null,420,2100,82.677210000000002,"1600-"]
[null,null,null,null,null,344,1720,67.72,"1720-"]
[null,null,null,null,null,351,1755,69.09,"1755-"]
[null,null,null,null,null,420,2100,82.68,"2100-"]
[]
[]
[null,null,null,"Belt Pitches",null,"Belt Widths"]
[null,null,null,"3mm","3M","9mm","09"]
[null,null,null,"5mm","5M","15mm",15]
[null,null,null,null,null,"25mm",25]
[]
[null,null,null,null,null,"Vlookup",{"$f":"VLOOKUP(R7,F35:G37,2,0)","v":"09"}]
[]
[]
["3mm GT2 Pulleys",null,26.61551,2.8435999999999999E-2]
["Grooves","Pitch Diameter","Outer Diameter",null,null,"3mm GT3 Belts"]
[9,8.6,null,null,null,"# of Teeth","Length (mm)","Length (in)","Gates PN"]
[10,9.5,null,null,null,33,{"$f":"F45*3","v":99},{"$f":"G45/25.4","v":3.8976377952755907},{"$f":"CONCATENATE(G45,\"-\")","v":"99-"}]
[11,10.5,null,null,null,35,105,4.1338582677165361,"105-"]
[12,11.5,null,null,null,37,111,4.3700787401574805,"111-"]
[13,12.4,null,null,null,40,120,4.7244094488188981,"120-"]
[14,13.4,null,null,null,41,123,4.8425196850393704,"123-"]
[15,14.3,null,null,null,43,129,5.0787401574803148,"129-"]
[16,15.3,null,null,null,45,135,5.3149606299212602,"135-"]
[17,16.2,null,null,null,48,144,5.6692913385826778,"144-"]
[18,17.2,null,null,null,50,150,5.9055118110236222,"150-"]
[19,18.100000000000001,null,null,null,53,159,6.2598425196850398,"159-"]
[20,19.100000000000001,null,null,null,54,162,6.377952755905512,"162-"]
[21,20.100000000000001,null,null,null,55,165,6.4960629921259843,"165-"]
[22,21,null,null,null,58,174,6.8503937007874018,"174-"]
[23,22,null,null,null,59,177,6.9685039370078741,"177-"]
[24,22.9,null,null,null,60,180,7.0866141732283472,"180-"]
[25,23.9,null,null,null,61,183,7.2047244094488194,"183-"]
[26,24.8,null,null,null,62,186,7.3228346456692917,"186-"]
[27,25.8,null,null,null,63,189,7.4409448818897639,"189-"]
[28,26.7,null,null,null,64,192,7.559055118110237,"192-"]
[29,27.7,null,null,null,65,195,7.6771653543307092,"195-"]
[30,28.6,null,null,null,66,198,7.7952755905511815,"198-"]
[31,29.6,null,null,null,67,201,7.9133858267716537,"201-"]
[32,30.6,null,null,null,68,204,8.0314960629921259,"204-"]
[33,31.5,null,null,null,70,210,8.2677165354330722,"210-"]
[34,32.5,null,null,null,72,216,8.5039370078740166,"216-"]
[35,33.4,null,null,null,73,219,8.6220472440944889,"219-"]
[36,34.4,null,null,null,75,225,8.8582677165354333,"225-"]
[37,35.299999999999997,null,null,null,77,231,9.0944881889763778,"231-"]
[38,36.299999999999997,null,null,null,78,234,9.2125984251968518,"234-"]
[39,37.200000000000003,null,null,null,80,240,9.4488188976377963,"240-"]
[40,38.200000000000003,null,null,null,81,243,9.5669291338582685,"243-"]
[42,40.1,null,null,null,82,246,9.6850393700787407,"246-"]
[44,42,null,null,null,84,252,9.9212598425196852,"252-"]
[45,43,null,null,null,85,255,10.039370078740157,"255-"]
[48,45.8,null,null,null,89,267,10.511811023622048,"267-"]
[50,47.7,null,null,null,90,270,10.62992125984252,"270-"]
[52,49.7,null,null,null,92,276,10.866141732283465,"276-"]
[54,51.6,null,null,null,94,282,11.102362204724409,"282-"]
[56,53.5,null,null,null,95,285,11.220472440944883,"285-"]
[60,57.3,null,null,null,96,288,11.338582677165356,"288-"]
[62,59.2,null,null,null,97,291,11.456692913385828,"291-"]
[64,61.1,null,null,null,98,294,11.5748031496063,"294-"]
[66,63,null,null,null,100,300,11.811023622047244,"300-"]
[68,64.900000000000006,null,null,null,101,303,11.929133858267717,"303-"]
[70,66.8,null,null,null,103,309,12.165354330708663,"309-"]
[72,66.8,null,null,null,104,312,12.283464566929135,"312-"]
[75,71.599999999999994,null,null,null,108,324,12.755905511811024,"324-"]
[80,76.400000000000006,null,null,null,110,330,12.992125984251969,"330-"]
[90,85.9,null,null,null,113,339,13.346456692913387,"339-"]
[100,95.5,null,null,null,116,348,13.700787401574804,"348-"]
[110,105,null,null,null,118,354,13.937007874015748,"354-"]
[120,114.6,null,null,null,119,357,14.05511811023622,"357-"]
[130,124.1,null,null,null,120,360,14.173228346456694,"360-"]
[140,133.69999999999999,null,null,null,121,363,14.291338582677167,"363-"]
[150,143.19999999999999,null,null,null,125,375,14.763779527559056,"375-"]
[160,152.80000000000001,null,null,null,128,384,15.118110236220474,"384-"]
[null,null,null,null,null,129,387,15.236220472440946,"387-"]
[null,null,null,null,null,130,390,15.354330708661418,"390-"]
[null,null,null,null,null,131,393,15.472440944881891,"393-"]
[null,null,null,null,null,133,399,15.708661417322835,"399-"]
[null,null,null,null,null,136,408,16.062992125984252,"408-"]
[null,null,null,null,null,138,414,16.299212598425196,"414-"]
[null,null,null,null,null,140,420,16.535433070866144,"420-"]
[null,null,null,null,null,148,444,17.480314960629922,"444-"]
[null,null,null,null,null,149,447,17.598425196850396,"447-"]
[null,null,null,null,null,150,450,17.716535433070867,"450-"]
[null,null,null,null,null,152,456,17.952755905511811,"456-"]
[null,null,null,null,null,158,474,18.661417322834648,"474-"]
[null,null,null,null,null,160,480,18.897637795275593,"480-"]
[null,null,null,null,null,161,483,19.015748031496063,"483-"]
[null,null,null,null,null,163,489,19.251968503937007,"489-"]
[null,null,null,null,null,165,495,19.488188976377955,"495-"]
[null,null,null,null,null,167,501,19.7244094488189,"501-"]
[null,null,null,null,null,168,504,19.84251968503937,"504-"]
[null,null,null,null,null,170,510,20.078740157480315,"510-"]
[null,null,null,null,null,171,513,20.196850393700789,"513-"]
[null,null,null,null,null,174,522,20.551181102362207,"522-"]
[null,null,null,null,null,179,537,21.141732283464567,"537-"]
[null,null,null,null,null,180,540,21.259842519685041,"540-"]
[null,null,null,null,null,184,552,21.73228346456693,"552-"]
[null,null,null,null,null,187,561,22.086614173228348,"561-"]
[null,null,null,null,null,188,564,22.204724409448819,"564-"]
[null,null,null,null,null,190,570,22.440944881889767,"570-"]
[null,null,null,null,null,194,582,22.913385826771655,"582-"]
[null,null,null,null,null,196,588,23.1496062992126,"588-"]
[null,null,null,null,null,200,600,23.622047244094489,"600-"]
[null,null,null,null,null,207,621,24.448818897637796,"621-"]
[null,null,null,null,null,210,630,24.803149606299215,"630-"]
[null,null,null,null,null,219,657,25.866141732283467,"657-"]
[null,null,null,null,null,228,684,26.929133858267718,"684-"]
[null,null,null,null,null,232,696,27.401574803149607,"696-"]
[null,null,null,null,null,245,735,28.937007874015748,"735-"]
[null,null,null,null,null,250,750,29.527559055118111,"750-"]
[null,null,null,null,null,262,786,30.944881889763781,"786-"]
[null,null,null,null,null,280,840,33.070866141732289,"840-"]
[null,null,null,null,null,283,849,33.425196850393704,"849-"]
[null,null,null,null,null,299,897,35.314960629921259,"897-"]
[null,null,null,null,null,308,924,36.377952755905511,"924-"]
[null,null,null,null,null,315,945,37.204724409448822,"945-"]
[null,null,null,null,null,350,1050,41.338582677165356,"1050-"]
[null,null,null,null,null,360,1080,42.519685039370081,"1080-"]
[null,null,null,null,null,424,1272,50.078740157480318,"1272-"]
[null,null,null,null,null,512,1536,60.472440944881896,"1536-"]
[null,null,null,null,null,529,1587,62.480314960629926,"1587-"]
[null,null,null,null,null,555,1665,65.551181102362207,"1665-"]
[null,null,null,null,null,564,1692,66.614173228346459,"1692-"]
[null,null,null,null,null,687,2061,81.141732283464577,"2061-"]
[null,null,null,null,null,820,2460,96.850393700787407,"2460-"]

{"sheet":"T3 Chain Calculator","index":1,"n_rows":38,"n_cols":16,"rows_kept":38,"cut":false,"hidden":false,"merged":[[12,1,15,2],[12,4,15,5],[17,1,20,2],[17,4,20,5],[0,1,0,8],[2,1,2,2],[2,4,2,5],[2,7,2,8],[7,1,7,2],[7,4,7,5],[8,7,10,8]]}
[null,"TRUCK TOWN THUNDER | CHAIN CALCULATOR",null,null,null,null,null,null,null,null,null,"z"]
[]
[null,"Sprocket 1",null,null,"Sprocket 2",null,null,"Center Distance"]
[null,"Tooth Count",18,null,"Tooth Count",32,null,"Desired Center (in)",6.101]
[null,"Outer Diameter",{"$f":"$M$14*(0.6 + 1 / TAN(RADIANS(180/C4)))","v":1.5678204549044272},null,"Outer Diameter",{"$f":"$M$14*(0.6 + 1 / TAN(RADIANS(180/F4)))","v":2.6882925969022153},null,"Center Add",-5.0000000000000001E-3]
[null,"Pitch Diameter",{"$f":"$M$14/SIN(RADIANS(180/C4))","v":1.4396926207859084},null,"Pitch Diameter",{"$f":"$M$14/SIN(RADIANS(180/F4))","v":2.5505743093445821},null,"Ratio",{"$f":"IFERROR(IF(F4>C4,CONCATENATE(ROUND(F4/C4,3),\":1\"),CONCATENATE(\"1:\",ROUND(C4/F4,3))),\"\")","v":"1.778:1"}]
[null,null,null,null,null,null,null,"Chain Pitch","#25 Chain"]
[null,"Ideal Chain",null,null,"Chain with Half Link"]
[null,"# of Links",{"$f":"IF(P19=ODD(P19),P28,P19)","v":74},null,"# of Links",{"$f":"IF(P19=ODD(P19),P19,P28)","v":75},null,"Avoid Odd Number of Links When Possible. Additional Side Clearance Required for Half Link."]
[null,"Center Distance",{"$f":"IF(P19=ODD(P19),P26+I5,P22+I5)","v":6.0945640736656035},null,"Center Distance",{"$f":"IF(P19=ODD(P19),P22+I5,P26+I5)","v":6.2200769244235854}]
[null,"Cut Chain Length",{"$f":"IF(P19=ODD(P19),P32,P23)","v":18.25},null,"Cut Chain Length",{"$f":"IF(P19=ODD(P19),P23,P32)","v":18.25}]
[]
[null,{"$f":"IFERROR(IF(P37<0, \"Desired center too small!\", \"\"),\"\")","v":""},null,null,{"$f":"IFERROR(IF(P38<0, \"Desired center too small!\", \"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"p = pitch",{"$f":"IF($I$7=\"#25 Chain\",0.25,IF($I$7=\"#35 Chain\",0.375,IF($I$7=\"Bike Chain\",0.5,\"\")))","v":0.25},0.25,0.25,0.25]
[null,null,null,null,null,null,null,null,null,null,null,"t1 = teeth(1)",{"$f":"$C$4","v":18},18,18,18]
[null,null,null,null,null,null,null,null,null,null,null,"t2 = teeth(2) Larger",{"$f":"$F$4","v":32},32,32,32]
[null,null,null,null,null,null,null,null,null,null,null,"cd = center distance",{"$f":"I4","v":6.101},{"$f":"M22","v":6.099570060243841},6.0995640986299078,6.0995640737692733]
[null,{"$f":"IFERROR(IF(AND(P21<=0.0005,P21>=-0.0005), \"\", \"Final Iteration Not Complete!\"),\"\")","v":""},null,null,{"$f":"IFERROR(IF(AND(P30<=0.0005,P30>=-0.0005), \"\", \"Final Iteration Not Complete!\"),\"\")","v":""},null,null,null,null,null,null,"L= Length",{"$f":"(M14/2)*(M15+M16)+(2*M17)+(1/(4*M17))*((M16-M15)*(M14/PI()))^2","v":18.502859879512318},18.500011923227866,18.500000049721269,18.50000000020734]
[null,null,null,null,null,null,null,null,null,null,null,"l = Links*",{"$f":"ROUNDDOWN(M18/M14,0)","v":74},74,74,74]
[null,null,null,null,null,null,null,null,null,null,null,"Chain Target length",{"$f":"M19*M14","v":18.5},18.5,18.5,18.5]
[null,null,null,null,null,null,null,null,null,null,null,"Difference",{"$f":"(M20-M18)/2","v":-1.4299397561590155E-3},-5.9616139331808427E-6,-2.486063443996045E-8,-1.0366996150423802E-10]
[null,null,null,null,null,null,null,null,null,null,null,"New Center Distance",{"$f":"M17+M21","v":6.099570060243841},6.0995640986299078,6.0995640737692733,6.0995640736656034]
[null,null,null,null,null,null,null,null,null,null,null,"Chain Cut Length",null,null,null,{"$f":"IF(P19=ODD(P19),P14*(P19-2),P14*(P19-1))","v":18.25}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Alternate !!"]
[null,null,null,null,null,null,null,null,null,null,null,"Center Distance",{"$f":"P17+M14/2","v":6.2245640737692733},{"$f":"M31","v":6.2250748710088581},6.2250769162351967,6.2250769244235853]
[null,null,null,null,null,null,null,null,null,null,null,"Length",{"$f":"M14/2*(M15+M16)+2*M26+1/(4*M26)*((M16-M15)*M14/PI())^2","v":18.74897840552083},18.749995909547323,18.749999983623223,18.749999999934438]
[null,null,null,null,null,null,null,null,null,null,null,"Links",{"$f":"M19+1","v":75},75,75,75]
[null,null,null,null,null,null,null,null,null,null,null,"Chain Target length",{"$f":"M28*M14","v":18.75},18.75,18.75,18.75]
[null,null,null,null,null,null,null,null,null,null,null,"Difference",{"$f":"(M29-M27)/2","v":5.1079723958480372E-4},2.0452263385095648E-6,8.1883886338118828E-9,3.2780889114292222E-11]
[null,null,null,null,null,null,null,null,null,null,null,"New Center Distance",{"$f":"M26+M30","v":6.2250748710088581},6.2250769162351967,6.2250769244235853,6.2250769244563662]
[null,null,null,null,null,null,null,null,null,null,null,"Chain Cut Length",null,null,null,{"$f":"IF(P28=ODD(P28),M14*(P28-2),M14*(P28-1))","v":18.25}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"tooth  r1",{"$f":"M$14*(0.6+1/TAN(PI()/M15))/2","v":0.78391022745221361},0.78391022745221361,0.78391022745221361,0.78391022745221361]
[null,null,null,null,null,null,null,null,null,null,null,"tooth r2",{"$f":"M$14*(0.6+1/TAN(PI()/M16))/2","v":1.3441462984511077},1.3441462984511077,1.3441462984511077,1.3441462984511077]
[null,null,null,null,null,null,null,null,null,null,null,"min cd",{"$f":"SUM(M34:M35)","v":2.1280565259033213},2.1280565259033213,2.1280565259033213,2.1280565259033213]
[null,null,null,null,null,null,null,null,null,null,null,"tooth to tooth clearance # ",null,null,null,{"$f":"P17-P36","v":3.9715075478659521}]
[null,null,null,null,null,null,null,null,null,null,null,"altrnate t to t clearance  #",null,null,null,{"$f":"P26-P36","v":4.0970203985202645}]