{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["01E","016"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"01E","index":0,"n_rows":126,"n_cols":6,"rows_kept":126,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["GT40 Gearbox"]
["Selection"]
["Max Allowable RPM=",null,6500]
["Tire Diameter (inches)=",null,25.8]
["Target mph for RPM Calc=",null,75]
[]
["Box S/N","EKN",null,"Effective","RPM AFTER","Percentage"]
[null,"Ratio","Max Speed","Overall",6500,"RPM DROP"]
["Final",3.75,null,"Ratio","SHIFT"]
["First",3.88,34.33502363092784,14.549999999999999]
["Second",2.19,60.831000770776264,8.2125,3670,44]
["Third",1.42,93.81682513239438,5.324999999999999,4220,35]
["Fourth",1.03,129.33970066796115,3.8625000000000003,4720,27]
["Fifth",0.73,182.4930023123288,2.7375,4610,29]
["Sixth",0.6,222.03315281333334,2.25,5350,18]
["Target RPM",null,2197.6744186046512]
[]
["Box S/N","CYB",null,"Effective","RPM AFTER","Percentage"]
[null,"Ratio","Max Speed","Overall",6500,"RPM DROP"]
["Final",3.88,null,"Ratio","SHIFT"]
["First",3.75,34.33502363092784,14.549999999999999]
["Second",2.06,62.50307699804826,7.9928,3570,45]
["Third",1.32,97.54268076968137,5.1216,4170,36]
["Fourth",1.07,120.33302674390596,4.1516,5270,19]
["Fifth",0.73,176.37854604928688,2.8324,4440,32]
["Sixth",0.6,214.59389769329903,2.328,5350,18]
["Target RPM",null,2273.860465116279]
[]
["Box S/N","FRM",null,"Effective","RPM AFTER","Percentage"]
[null,"Ratio","Max Speed","Overall",6500,"RPM DROP"]
["Final",3.75,null,"Ratio","SHIFT"]
["First",3.88,34.33502363092784,14.549999999999999]
["Second",2.19,60.831000770776264,8.2125,3670,44]
["Third",1.42,93.81682513239438,5.324999999999999,4220,35]
["Fourth",1.03,129.33970066796115,3.8625000000000003,4720,27]
["Fifth",0.73,182.4930023123288,2.7375,4610,29]
["Sixth",0.6,222.03315281333334,2.25,5350,18]
["Target RPM",null,2197.6744186046512]
[]
["Box S/N","DQS",null,"Effective","RPM AFTER","Percentage"]
[null,"Ratio","Max Speed","Overall",6500,"RPM DROP"]
["Final",3.88,null,"Ratio","SHIFT"]
["First",3.5,36.78752531885126,13.58]
["Second",1.89,68.12504688676158,7.3332,3510,46]
["Third",1.23,104.67995009429221,4.7724,4230,35]
["Fourth",0.87,147.99579151261997,3.3756,4600,29]
["Fifth",0.73,176.37854604928688,2.8324,5460,16]
["Sixth",0.56,229.9220332428203,2.1728,4990,23]
["Target RPM",null,2122.2697674418605]
[]
["Box S/N","FPN",null,"Effective","RPM AFTER","Percentage"]
[null,"Ratio","Max Speed","Overall",6500,"RPM DROP"]
["Final",3.88,null,"Ratio","SHIFT"]
["First",3.5,36.78752531885126,13.58]
["Second",1.89,68.12504688676158,7.3332,3510,46]
["Third",1.23,104.67995009429221,4.7724,4230,35]
["Fourth",1.07,120.33302674390596,4.1516,5660,13]
["Fifth",0.73,176.37854604928688,2.8324,4440,32]
["Sixth",0.6,214.59389769329903,2.328,5350,18]
["Target RPM",null,2273.860465116279]
[]
["Box S/N","FRL",null,"Effective","RPM AFTER","Percentage"]
[null,"Ratio","Max Speed","Overall",6500,"RPM DROP"]
["Final",3.88,null,"Ratio","SHIFT"]
["First",3.5,36.78752531885126,13.58]
["Second",1.89,68.12504688676158,7.3332,3510,46]
["Third",1.23,104.67995009429221,4.7724,4230,35]
["Fourth",1.07,120.33302674390596,4.1516,5660,13]
["Fifth",0.73,176.37854604928688,2.8324,4440,32]
["Sixth",0.6,214.59389769329903,2.328,5350,18]
["Target RPM",null,2273.860465116279]
[]
["Box S/N","FRG",null,"Effective","RPM AFTER","Percentage"]
[null,"Ratio","Max Speed","Overall",6500,"RPM DROP"]
["Final",3.88,null,"Ratio","SHIFT"]
["First",3.5,36.78752531885126,13.58]
["Second",1.89,68.12504688676158,7.3332,3510,46]
["Third",1.23,104.67995009429221,4.7724,4230,35]
["Fourth",0.87,147.99579151261997,3.3756,4600,29]
["Fifth",0.67,192.1736397253424,2.5996,5010,23]
["Sixth",0.56,229.9220332428203,2.1728,5440,16]
["Target RPM",null,2122.2697674418605]
[]
["Box S/N","GBA",null,"Effective","RPM AFTER","Percentage"]
[null,"Ratio","Max Speed","Overall",6500,"RPM DROP"]
["Final",3.88,null,"Ratio","SHIFT"]
["First",3.5,36.78752531885126,13.58]
["Second",1.89,68.12504688676158,7.3332,3510,46]
["Third",1.23,104.67995009429221,4.7724,4230,35]
["Fourth",1.07,120.33302674390596,4.1516,5660,13]
["Fifth",0.73,176.37854604928688,2.8324,4440,32]
["Sixth",0.6,214.59389769329903,2.328,5350,18]
["Target RPM",null,2273.860465116279]
[]
["Box S/N","GAZ",null,"Effective","RPM AFTER","Percentage"]
[null,"Ratio","Max Speed","Overall",6500,"RPM DROP"]
["Final",3.88,null,"Ratio","SHIFT"]
["First",3.5,36.78752531885126,13.58]
["Second",1.89,68.12504688676158,7.3332,3510,46]
["Third",1.23,104.67995009429221,4.7724,4230,35]
["Fourth",0.87,147.99579151261997,3.3756,4600,29]
["Fifth",0.67,192.1736397253424,2.5996,5010,23]
["Sixth",0.56,229.9220332428203,2.1728,5440,16]
["Target RPM",null,2122.2697674418605]
[]
["Box S/N","GEA",null,"Effective","RPM AFTER","Percentage"]
[null,"Ratio","Max Speed","Overall",6500,"RPM DROP"]
["Final",3.88,null,"Ratio","SHIFT"]
["First",3.75,34.33502363092784,14.549999999999999]
["Second",2.19,58.79284868309562,8.4972,3800,42]
["Third",1.52,84.70811751051276,5.8976,4520,30]
["Fourth",0.97,132.73849341853546,3.7636,4150,36]
["Fifth",0.73,176.37854604928688,2.8324,4900,25]
["Sixth",0.6,214.59389769329903,2.328,5350,18]
["Target RPM",null,2273.860465116279]
[]
["Box S/N","DPV",null,"Effective","RPM AFTER","Percentage"]
[null,"Ratio","Max Speed","Overall",6500,"RPM DROP"]
["Final",3.88,null,"Ratio","SHIFT"]
["First",3.5,36.78752531885126,13.58]
["Second",1.89,68.12504688676158,7.3332,3510,46]
["Third",1.32,97.54268076968137,5.1216,4540,30]
["Fourth",1.07,120.33302674390596,4.1516,5270,19]
["Fifth",0.73,176.37854604928688,2.8324,4440,32]
["Sixth",0.6,214.59389769329903,2.328,5350,18]
["Target RPM",null,2273.860465116279]

{"sheet":"016","index":1,"n_rows":186,"n_cols":7,"rows_kept":186,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["GT40 Gearbox"]
["Selection"]
["Max Allowable RPM=",null,6500]
["Tire Diameter (inches)=",null,26.6,null,null,null,"RPM at"]
["Target mph for RPM Calc=",null,75,null,null,null,"75mph"]
[]
["Box S/N","AEY",null,"Effective","RPM AFTER","Percentage"]
[null,"Ratio","Max Speed","Overall",6500,"RPM DROP"]
["Final",4.11,null,"Ratio","SHIFT"]
["First",3.6,34.81111644430927,14.796000000000001]
["Second",2.13,58.83568976502976,8.7543,3850,41]
["Third",1.46,85.8356295887078,6.0006,4460,31]
["Fourth",1.07,117.12151327057326,4.3977,4770,27]
["Fifth",0.86,145.72095255757372,3.5346,5230,20,3345.43517211357]
["Target RPM",null,3348.5684210526306]
[]
["Box S/N","APT",null,"Effective","RPM AFTER","Percentage"]
[null,"Ratio","Max Speed","Overall",6500,"RPM DROP"]
["Final",4.11,null,"Ratio","SHIFT"]
["First",3.6,34.81111644430927,14.796000000000001]
["Second",2.12,59.11321660354405,8.7132,3830,41]
["Third",1.45,86.42759944794027,5.9595,4450,32]
["Fourth",1.02,122.86276392109156,4.192200000000001,4580,30]
["Fifth",0.85,147.43531670530987,3.4935,5420,17,3306.5347631355057]
["Target RPM",null,3309.6315789473683]
[]
["Box S/N","AAZ",null,"Effective","RPM AFTER","Percentage"]
[null,"Ratio","Max Speed","Overall",6500,"RPM DROP"]
["Final",3.89,null,"Ratio","SHIFT"]
["First",3.6,36.77986853113397,14.004000000000001]
["Second",2.13,62.1631580807898,8.2857,3850,41]
["Third",1.46,90.69008678909745,5.6794,4460,31]
["Fourth",1.07,123.74535206736661,4.1623,4770,27]
["Fifth",0.86,153.96224036288638,3.3454,5230,20,3166.360783338634]
["Target RPM",null,3169.3263157894735]
[]
["Box S/N","AMM, AMN",null,"Effective","RPM AFTER","Percentage"]
[null,"Ratio","Max Speed","Overall",6500,"RPM DROP"]
["Final",4.77,null,"Ratio","SHIFT"]
["First",3.6,29.9944839803168,17.172]
["Second",1.88,57.436245919755585,8.9676,3400,48]
["Third",1.19,90.73961540263907,5.6762999999999995,4120,37]
["Fourth",0.84,128.547788487072,4.006799999999999,4590,29]
["Fifth",0.68,158.79432695461836,3.2436,5270,19,3070.008918765228]
["Target RPM",null,3072.8842105263157]
[]
[]
["Box S/N","3V",null,"Effective","RPM AFTER","Percentage"]
[null,"Ratio","Max Speed","Overall",6500,"RPM DROP"]
["Final",3.89,null,"Ratio","SHIFT"]
["First",3.6,36.77986853113397,14.004000000000001]
["Second",2.13,62.1631580807898,8.2857,3850,41]
["Third",1.46,90.69008678909745,5.6794,4460,31]
["Fourth",1.07,123.74535206736661,4.1623,4770,27]
["Fifth",0.83,159.52714061696662,3.2287,5050,22,3055.9063374082166]
["Target RPM",null,3058.768421052631]
[]
["Box S/N","AAX, AAY",null,"Effective","RPM AFTER","Percentage"]
[null,"Ratio","Max Speed","Overall",6500,"RPM DROP"]
["Final",4.56,null,"Ratio","SHIFT"]
["First",3.6,31.37580890046297,16.416]
["Second",1.88,60.08133619237591,8.572799999999999,3400,48]
["Third",1.19,94.91841348039219,5.426399999999999,4120,37]
["Fourth",0.84,134.46775243055558,3.8303999999999996,4590,29]
["Fifth",0.68,166.10722359068632,3.1008,5270,19,2934.8512934107835]
["Target RPM",null,2937.5999999999995]
[]
["Box S/N","3K, APS",null,"Effective","RPM AFTER","Percentage"]
[null,"Ratio","Max Speed","Overall",6500,"RPM DROP"]
["Final",3.89,null,"Ratio","SHIFT"]
["First",3.6,36.77986853113397,14.004000000000001]
["Second",2.125,62.309424335097546,8.26625,3840,41]
["Third",1.36,97.3584755235899,5.290400000000001,4160,36]
["Fourth",0.97,136.5026048578168,3.7733,4640,29]
["Fifth",0.78,169.75323937446447,3.0342000000000002,5230,20,2871.8155941908544]
["Target RPM",null,2874.5052631578947]
[]
["Box S/N","5N",null,"Effective","RPM AFTER","Percentage"]
[null,"Ratio","Max Speed","Overall",6500,"RPM DROP"]
["Final",4.11,null,"Ratio","SHIFT"]
["First",3.6,34.81111644430927,14.796000000000001]
["Second",2.13,58.83568976502976,8.7543,3850,41]
["Third",1.36,92.14707294081867,5.589600000000001,4150,36]
["Fourth",0.97,129.19589608197256,3.9867000000000004,4640,29]
["Fifth",0.73,171.6712591774156,3.0003,4900,25,2839.7298553987284]
["Target RPM",null,2842.3894736842103]
[]
["Box S/N","MR",null,"Effective","RPM AFTER","Percentage"]
["          not MR , same as BMO","Ratio","Max Speed","Overall",6500,"RPM DROP"]
["Final",3.89,null,"Ratio","SHIFT"]
["First",3.6,36.77986853113397,14.004000000000001]
["Second",2.12,62.45638052456711,8.2468,3830,41]
["Third",1.36,97.3584755235899,5.290400000000001,4170,36]
["Fourth",0.96,137.92450699175237,3.7344,4590,29]
["Fifth",0.77,171.95782689880818,2.9953000000000003,5220,20]
["Target RPM",null,2837.652631578947]
[]
["Box S/N","2U,  6U",null,"Effective","RPM AFTER","Percentage"]
[null,"Ratio","Max Speed","Overall",6500,"RPM DROP"]
["Final",4.56,null,"Ratio","SHIFT"]
["First",3.6,31.37580890046297,16.416]
["Second",1.88,60.08133619237591,8.572799999999999,3400,48]
["Third",1.19,94.91841348039219,5.426399999999999,4120,37]
["Fourth",0.84,134.46775243055558,3.8303999999999996,4590,29]
["Fifth",0.64,176.48892506510424,2.9183999999999997,4960,24,2762.212982033678]
["Target RPM",null,2764.7999999999997]
[]
["Box S/N","APU, AFC",null,"Effective","RPM AFTER","Percentage"]
[null,"Ratio","Max Speed","Overall",6500,"RPM DROP"]
["Final",3.89,null,"Ratio","SHIFT"]
["First",3.6,36.77986853113397,14.004000000000001]
["Second",2.13,62.1631580807898,8.2857,3850,41]
["Third",1.36,97.3584755235899,5.290400000000001,4150,36]
["Fourth",0.97,136.5026048578168,3.7733,4640,29]
["Fifth",0.73,181.3801735781949,2.8397,4900,25,2687.7248509734923]
["Target RPM",null,2690.242105263158]
[]
["Box S/N","HE, AAW, AAV",null,"Effective","RPM AFTER","Percentage"]
["remove HE, it is a 013 box","Ratio","Max Speed","Overall",6500,"RPM DROP"]
["Final",4.11,null,"Ratio","SHIFT"]
["First",3.46,36.21965872818306,14.220600000000001]
["Second",1.79,70.01118391034268,7.3569,3370,48]
["Third",1.13,110.90267185797647,4.6443,4110,37]
["Fourth",0.83,150.98797493917277,3.4113,4780,26]
["Fifth",0.68,184.29414588163735,2.7948000000000004,5330,18]
["Target RPM",null,2647.705263157895]
[]
["Box S/N","HF",null,"Effective","RPM AFTER","Percentage"]
[" this is a 013 box","Ratio","Max Speed","Overall",6500,"RPM DROP"]
["Final",4.11,null,"Ratio","SHIFT"]
["First",3.46,36.21965872818306,14.220600000000001]
["Second",1.79,70.01118391034268,7.3569,3370,48]
["Third",1.13,110.90267185797647,4.6443,4110,37]
["Fourth",0.83,150.98797493917277,3.4113,4780,26]
["Fifth",0.68,184.29414588163735,2.7948000000000004,5330,18]
["Target RPM",null,2647.705263157895]
[]
["Box S/N","AAV, AAW",null,"Effective","RPM AFTER","Percentage"]
[null,"Ratio","Max Speed","Overall",6500,"RPM DROP"]
["Final",4.11,null,"Ratio","SHIFT"]
["First",3.6,34.81111644430927,14.796000000000001]
["Second",1.88,66.65958468059223,7.7268,3400,48]
["Third",1.19,105.31094050379278,4.8909,4120,37]
["Fourth",0.84,149.19049904703976,3.4524000000000004,4590,29]
["Fifth",0.68,184.29414588163735,2.7948000000000004,5270,19,2645.227810508404]
["Target RPM",null,2647.705263157895]
[]
["Box S/N","BMO, WV, UW,","MO, MR","Effective","RPM AFTER","Percentage"]
[null,"Ratio","Max Speed","Overall",6500,"RPM DROP"]
["Final",3.89,null,"Ratio","SHIFT"]
["First",3.6,36.77986853113397,14.004000000000001]
["Second",1.94,68.2513024289084,7.5466,3510,46]
["Third",1.23,107.6483957008799,4.7847,4120,37]
["Fourth",0.9,147.11947412453588,3.5010000000000003,4760,27]
["Fifth",0.68,194.7169510471798,2.6452000000000004,4920,24,2503.6341077561297]
["Target RPM",null,2505.9789473684214]
[]
["Box S/N","APN, APP, 4V, 5V",null,"Effective","RPM AFTER","Percentage"]
[null,"Ratio","Max Speed","Overall",6500,"RPM DROP"]
["Final",4.11,null,"Ratio","SHIFT"]
["First",3.6,34.81111644430927,14.796000000000001]
["Second",1.88,66.65958468059223,7.7268,3400,48]
["Third",1.19,105.31094050379278,4.8909,4120,37]
["Fourth",0.84,149.19049904703976,3.4524000000000004,4590,29]
["Fifth",0.64,195.81252999923967,2.6304000000000003,4960,24,2489.626174596145]
["Target RPM",null,2491.9578947368423]
{"$rows_empty":11}
["Box S/N","3U",null,"Effective","RPM AFTER","Percentage"]
[null,"Ratio","Max Speed","Overall",6500,"RPM DROP"]
["Final",3.89,null,"Ratio","SHIFT"]
["First",3.6,36.77986853113397,14.004000000000001]
["Second",1.88,70.42953548515015,7.3132,3400,48]
["Third",1.19,111.26682916981706,4.6291,4120,37]
["Fourth",0.84,157.62800799057413,3.2676,4590,29]
["Fifth",0.64,206.88676048762858,2.4896000000000003,4960,24,2356.3615131822394]
["Target RPM",null,2358.5684210526315]