{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["fk_stiffer_sh_percent","results_targ_03_USE","results_targ_03_USE (2)","results_targ_03_proposed","fk_3791_targ_03","sh_2349_targ_03","results_act_02","fk_3791_act_02","sh_3694_act_02","results_targ_01","fk_3791_targ_01","sh_2349_targ_01"],"not_rendered":{"charts":3,"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":"fk_stiffer_sh_percent","index":0,"n_rows":56,"n_cols":35,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," TAB FOR POLY 2",null,null,null,null,null,null,null,null,null,null," EBD"]
[" 8-31-22"]
["   The forks are stiffer than the shock."]
["   We cannot increase fork target by 30% and then stiffen stiffen shock 109 x 1.30."]
["   The shock gets too stiff."]
["   We will devise a separate linear percentage scale for the shock",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1/0.075","v":13.333333333333334}]
["    using ReStackor Energy to find correct percentage for Enduro, XC and MX."]
["   Consider two shock percentage scales with one simply more aggressive."]
[null," Forks are 20% stiffer than shock at 4\" bump"]
[null,"    [10% stiffer for rocks & roots]"]
[null,"    [20% stiffer mostly dirt XC]",null,null,null,null,null,null,null,null,null,null,null,null,"have 2 linear curve with one more aggressive"]
[null,"    [30 - 50% stiffer MX]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"linear"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.SINGLE(INDEX(LINEST(P$17:P$18,($O$17:$O$18)^{1}),1))","v":7.4999999999999956E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USE THIS ONE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(LINEST(P$17:P$18,($O$17:$O$18)^{1}),1,2)","v":0.92500000000000016},null,null,null,null,null,null,null,null,null,null,null,null,null,null," poly 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STIFF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ips"," poly 2"]
[null,null," Actual fork % change  SOFT",null,null,null,"% inverse",null,null,null,null,null,null,null,"ips","linear","ips","linear",null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,65.099999999999994]
[null,1," aver",1,null,null,null,null,null,null,null,null,null,"aver",1,1,1,{"$f":"(R$13*($Q17)^1)+(R$14)","v":1},"inverse",null,null,null,null,null,null,null,null,null,null,null,null,null,40,82.4]
[null,2," soft",0.89700000000000002,"  (60.4 / 67.6 = .897)",null,{"$f":"1/D18","v":1.1148272017837235},null,null,null,null,null,null," stiff",2,1.075,2,1.0750000000000002,{"$f":"1/R18","v":0.93023255813953476},null,null,null,null,null,null,null,null,null,null,null,null,null,50,100]
[null,3," soft+1",0.80100000000000005,"  (53.9 / 67.3 = .801)",null,{"$f":"1/D19","v":1.2484394506866416},null,null,null,null,null,null," stiff+1",3,1.2509999999999999,3,1.1499999999999999,{"$f":"1/R19","v":0.86956521739130443},null,null,null,null,null,null,null,null,null,null,null,null,null,60,119.69999999999999]
[null,4," soft+2",0.73299999999999998,"  (49.3 / 67.3 = .733)",null,1.3642564802182811,null,null,null,null,null,null," stiff+2",4,1.4059999999999999,4,1.2250000000000001,{"$f":"1/R20","v":0.81632653061224481},null,null,null,null,null,null,null,null,null,null,null,null,null,70,140.19999999999999]
[null,5," soft+3",0.66600000000000004,"  (44.8 / 67.3 = .666)",null,1.5015015015015014,null,null,null,null,null,null," stiff+3",5,1.5840000000000001,5,1.2999999999999998,{"$f":"1/R21","v":0.76923076923076938}]
[null,6," soft+4",0.60599999999999998,"  (40.8 / 67.3 = .606",null,1.6501650165016502,null,null,null,null,null,null," stiff+4",6,1.7889999999999999,6,1.375,0.72727272727272729,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"poly 2"]
[null,7," soft+5",0.55700000000000005,"  (37.5 / 67.3 = .557)",null,1.7953321364452421,null,null,null,null,null,null," stiff+5",7,2.024,7,1.4499999999999997,0.68965517241379326,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(LINEST(AH$16:AH$20,($AG$16:$AG$20)^{1,2}),1)","v":6.071428571428561E-3}]
[null,8," soft+6",0.51300000000000001,"  (34.5 / 67.3 = .513)",null,1.9493177387914229,null,null,null,null,null,null," stiff+6",8,2.2909999999999999,8,1.5249999999999999,0.65573770491803285,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(LINEST(AH$16:AH$20,($AG$16:$AG$20)^{1,2}),2)","v":1.2678571428571435}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.93,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(LINEST(AH$16:AH$20,($AG$16:$AG$20)^{1,2}),3)","v":21.694285714285702}]
[null,null," Actual fork % change  STIFF",null,null,null,"% inverse",null,null,null,null,null,null,null,null,null,null,null,null,null," x",1.2250000000000001]
[null,1," aver",1,null,null,null,null,null,null,null,null,null,null,"have 2 linear curve with one more aggressive",null,null,null,null,null,null,{"$f":"V25*V26","v":1.1392500000000001},null,null,null,null,null,null,null,null,null,null,"ips"," poly 2"]
[null,2," stiff",1.1160000000000001,"  (60.4 / 67.6 = .897)",null,{"$f":"1/D28","v":0.8960573476702508},null,null,null,null,null,null,null,null,null,null,"linear",null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,{"$f":"(AH$23*($AG28)^2)+(AH$24*($AG28)^1)+(AH$25)","v":65.194285714285712}]
[null,3," stiff+1",1.2509999999999999,"  (53.9 / 67.3 = .801)",null,{"$f":"1/D29","v":0.79936051159072752},null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.SINGLE(INDEX(LINEST(P$33:P$34,($O$33:$O$34)^{1}),1))","v":3.7500000000000089E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,{"$f":"(AH$23*($AG29)^2)+(AH$24*($AG29)^1)+(AH$25)","v":82.122857142857129}]
[null,4," stiff+2",1.4059999999999999,"  (49.3 / 67.3 = .733)",null,0.71123755334281658,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(LINEST(P$33:P$34,($O$33:$O$34)^{1}),1,2)","v":0.96249999999999991},null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,{"$f":"(AH$23*($AG30)^2)+(AH$24*($AG30)^1)+(AH$25)","v":100.26571428571428}]
[null,5," stiff+3",1.5840000000000001,"  (44.8 / 67.3 = .666)",null,0.63131313131313127,null,null,null,null,null,null,null,null,"STIFF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,{"$f":"(AH$23*($AG31)^2)+(AH$24*($AG31)^1)+(AH$25)","v":119.62285714285713}]
[null,6," stiff+4",1.7889999999999999,"  (40.8 / 67.3 = .606",null,0.55897149245388489,null,null,null,null,null,null,null,"ips","linear","ips","linear",1,null,null,null,null,null,null,null,null,null,null,null,null,null,70,{"$f":"(AH$23*($AG32)^2)+(AH$24*($AG32)^1)+(AH$25)","v":140.19428571428571}]
[null,7," stiff+5",2.024,"  (37.5 / 67.3 = .557)",null,0.49407114624505927,null,null,null,null,null,null,"aver",1,1,1,{"$f":"(R$29*($Q33)^1)+(R$30)","v":1},{"$f":"R33*S$32","v":1}]
[null,8," stiff+6",2.294,"  (34.5 / 67.3 = .513)",null,0.4359197907585004,null,null,null,null,null,null," stiff",2,1.0375000000000001,2,{"$f":"(R$29*($Q34)^1)+(R$30)","v":1.0375000000000001},{"$f":"R34*S$32","v":1.0375000000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," stiff+1",3,1.2509999999999999,3,1.0750000000000002,1.0750000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null," stiff+2",4,1.4059999999999999,4,1.1125000000000003,1.1125000000000003]
[null,null,null,null,null,null,null," ",null,null,null,null,null," stiff+3",5,1.5840000000000001,5,1.1500000000000004,1.1500000000000004]
[null,null,0,126,null,null,null,null,null,null,null,null,null," stiff+4",6,1.7889999999999999,6,1.1875000000000004,1.1875000000000004]
[null,null,3,129,null,null,null,null,null,null,null,null,null," stiff+5",7,2.024,7,1.2250000000000005,1.2250000000000005]
[null,null,5,145,null,null,null,null,null,null,null,null,null," stiff+6",8,2.2909999999999999,8,1.2625000000000006,1.2625000000000006]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"have 2 linear curve with one more aggressive"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"linear"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.SINGLE(INDEX(LINEST(P$49:P$50,($O$49:$O$50)^{1}),1))","v":1.8750000000000044E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(LINEST(P$49:P$50,($O$49:$O$50)^{1}),1,2)","v":0.98124999999999984},null,null,null,null,{"$f":"630*1.05","v":661.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STIFF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ips","linear","ips","linear",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"aver",1,1,1,{"$f":"(R$45*($Q49)^1)+(R$46)","v":0.99999999999999989},{"$f":"R49*S$48","v":0.99999999999999989}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," stiff",2,1.01875,2,{"$f":"(R$45*($Q50)^1)+(R$46)","v":1.0187499999999998},{"$f":"R50*S$48","v":1.0187499999999998}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," stiff+1",3,1.2509999999999999,3,1.0375000000000001,1.0375000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null," stiff+2",4,1.4059999999999999,4,1.0562499999999999,1.0562499999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null," stiff+3",5,1.5840000000000001,5,1.0750000000000002,1.0750000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null," stiff+4",6,1.7889999999999999,6,1.09375,1.09375]
[null,null,null,null,null,null,null,null,null,null,null,null,null," stiff+5",7,2.024,7,1.1125000000000003,1.1125000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null," stiff+6",8,2.2909999999999999,8,1.1312500000000001,1.1312500000000001]

{"sheet":"results_targ_03_USE","index":1,"n_rows":71,"n_cols":22,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null," 8-31-22",null," vdb / excel / sh_fk_ratio_interpolate.xlsm"]
[null,null,null,null,null," 2349s",null," CO WOGAS"," CO WOGAS",null,null,"Use this to verify calculations are correct.",null,null,null,null,null,null,null," 3791f"," CO WOGAS"," CO WOGAS"]
[null," SHOCK"," 2349s",null,null,"temp",null,"stash","stash",null,null,null,null,null,null," FORK"," CO WOGAS",null,null,"temp","stash","stash"]
[null,null," CO WOGAS"," %",null,"copy",null," 2349s"," 109 x 1.0",null,null,null,null,null,null,null," 3791f"," drag"," %","copy"," 3791f"," 3791f"]
[null,"   ips   ","[actual]",1,null,"[actual]",null,"[actual]","TARGET",null,null,null,null,null,null,"ips","TARGET",0,1,"[actual]","[actual]","TARGET"]
[null,1,38.6,null,null,38.6,null,38.6,40.1,null,null,null,null,null,null,1,10.36,{"$f":"(Q6+R$5)","v":10.36},null,10.36,10.36,10.3]
[null,2,78.2,null,null,78.2,null,78.2,73.2,null,null,null,null,null,null,2,11.39,{"$f":"(Q7+R$5)","v":11.39},null,11.39,11.39,11.4]
[null,3,100.9,null,null,100.9,null,100.9,97.2,null,null,null,null,null,null,3,12.68,12.68,null,12.68,12.68,12.7]
[null,4,121.4,null,null,121.4,null,121.4,117.4,null,null,null,null,null,null,4,13.97,13.97,null,13.97,13.97,13.9]
[null,5,138.9,null,null,138.9,null,138.9,137.80000000000001,null,null,null,null,null,null,5,14.59,14.59,null,14.59,14.59,14.8]
[null,10,216.7,null,null,216.7,null,216.7,221.5,null,null,null,null,null,null,10,16.829999999999998,16.829999999999998,null,16.829999999999998,16.829999999999998,18]
[null,20,360.5,null,null,360.5,null,360.5,371.9,null,null,null,null,null,null,20,20.51,20.51,null,20.51,20.51,23]
[null,30,483.5,null,null,483.5,null,483.5,495.1,null,null,null,null,null,null,30,24.3,24.3,null,24.3,24.3,27.1]
[null,40,596.9,null,null,596.9,null,596.9,606.29999999999995,null,null,null,null,null,null,40,28.36,{"$f":"(Q14+R$5)","v":28.36},null,28.36,28.36,31.3]
[null,50,701.1,null,null,701.1,null,701.1,714.6,null,null,null,null,null,null,50,32.450000000000003,32.450000000000003,null,32.450000000000003,32.450000000000003,36.299999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,36.68,{"$f":"(Q16+R$5)","v":36.68},null,36.68,36.68,41.9]
[null," dyno wheel velocity and dyno force at the wheel",null,null,null,null,null,null,null,null,null,null,null,null,null,70,41.4,{"$f":"(Q17+R$5)","v":41.4},null,41.4,41.4,46.7]
[null,null,null,null,null,null,null,"this matches/aligns everything by sh LR 2.52 and fk LR 1.11",null,null,null,null,null,null,null,80,45.92,{"$f":"(Q18+R$5)","v":45.92},null,45.92,45.92,52.1]
[null," ips x LR","cowogas x LR",null," ips / LR","cowogas x 2 x LR",null,"HOWEVER, we decided not to use fork numbers at the shaft  [i.e. LR = 1.0]",null,null,null,null,null,null,null,90,50.91,{"$f":"(Q19+R$5)","v":50.91},null,50.91,50.91,58.1]
[null,"Shock",null,"LR","Fork",null,null,"u.whl","F.shk","F.fk",null,null,null,null,null,100,55.37,{"$f":"(Q20+R$5)","v":55.37},null,55.37,55.37,63]
[null,"u.whl","F.wheel",2.52,"u.whl","F.wheel","F.bush",null,"[extrapolote sh]","[extropalate fk]","[fk/sh ratio]",null,null,null,null,110,{"$f":"T33","v":60.18333333333333}]
[1,{"$f":"B6*D$21","v":2.52},{"$f":"C6/D$21","v":15.317460317460318},null,{"$f":"P6/G$24","v":1},{"$f":"(2*Q6*G$24)+G$22","v":20.72},0,1,{"$f":"intrp(H22,$B$22:$B$31,$C$22:$C$31)","v":{"$error":"#VALUE!"}},{"$f":"intrp(H22,$E$22:$E$38,$F$22:$F$38)","v":20.72},{"$f":"I22/J22","v":{"$error":"#VALUE!"}},null,null,null,null,120,{"$f":"T34","v":64.908333333333331}]
[2,{"$f":"B7*D$21","v":5.04},{"$f":"C7/D$21","v":31.031746031746032},null,{"$f":"P7/G$24","v":2},{"$f":"(2*Q7*G$24)+G$22","v":22.78},"LR [1.114]",2,{"$f":"intrp(H23,$B$22:$B$31,$C$22:$C$31)","v":{"$error":"#VALUE!"}},{"$f":"intrp(H23,$E$22:$E$38,$F$22:$F$38)","v":22.78},{"$f":"I23/J23","v":{"$error":"#VALUE!"}}]
[3,{"$f":"B8*D$21","v":7.5600000000000005},{"$f":"C8/D$21","v":40.039682539682545},null,{"$f":"P8/G$24","v":3},25.36,1,3,{"$f":"intrp(H24,$B$22:$B$31,$C$22:$C$31)","v":18.310657596371883},{"$f":"intrp(H24,$E$22:$E$38,$F$22:$F$38)","v":25.36},0.72202908503043706,null," F.shk =  dyno numbers converted to fwhl"]
[4,{"$f":"B9*D$21","v":10.08},{"$f":"C9/D$21","v":48.174603174603178},null,{"$f":"P9/G$24","v":4},27.94,null,4,{"$f":"intrp(H25,$B$22:$B$31,$C$22:$C$31)","v":24.546485260770975},{"$f":"intrp(H25,$E$22:$E$38,$F$22:$F$38)","v":27.94},0.87854277955515292,null," F.fk =  dyno numbers converted to fwhl",null,null,null,"Use linear trend line to get fork ",null,null,"linear"]
[5,{"$f":"B10*D$21","v":12.6},{"$f":"C10/D$21","v":55.11904761904762},null,{"$f":"P10/G$24","v":5},29.18,{"$f":"F26/2","v":14.59},5,{"$f":"intrp(H26,$B$22:$B$31,$C$22:$C$31)","v":30.782312925170068},{"$f":"intrp(H26,$E$22:$E$38,$F$22:$F$38)","v":29.18},1.0549113408214554,null," now they are compareable not including air spr",null,null,null,"co wogas at 110ips to prevent",null,null,{"$f":"_xlfn.SINGLE(INDEX(LINEST(R$30:R$32,($Q$30:$Q$32)^{1}),1))","v":0.47249999999999986}]
[10,{"$f":"B11*D$21","v":25.2},{"$f":"C11/D$21","v":85.992063492063494},null,{"$f":"P11/G$24","v":10},33.659999999999997,{"$f":"F27/2","v":16.829999999999998},10,{"$f":"intrp(H27,$B$22:$B$31,$C$22:$C$31)","v":47.916351725875536},{"$f":"intrp(H27,$E$22:$E$38,$F$22:$F$38)","v":33.659999999999997},1.4235398611371224,null,null,null,null,null,"error at J36",null,null,{"$f":"INDEX(LINEST(R$30:R$32,($Q$30:$Q$32)^{1}),1,2)","v":8.2083333333333428}]
[20,{"$f":"B12*D$21","v":50.4},{"$f":"C12/D$21","v":143.05555555555554},null,{"$f":"P12/G$24","v":20},41.02,20.51,20,{"$f":"intrp(H28,$B$22:$B$31,$C$22:$C$31)","v":73.250818846056944},{"$f":"intrp(H28,$E$22:$E$38,$F$22:$F$38)","v":41.02},1.7857342478317146,null," Save for comparison",null,null,null,null,"co wogas"]
[30,{"$f":"B13*D$21","v":75.599999999999994},{"$f":"C13/D$21","v":191.86507936507937},null,{"$f":"P13/G$24","v":30},48.6,24.3,30,{"$f":"intrp(H29,$B$22:$B$31,$C$22:$C$31)","v":96.861300075585788},{"$f":"intrp(H29,$E$22:$E$38,$F$22:$F$38)","v":48.6},1.993030865752794,null," sh manual interpolate formula for 40ips",null,null,null,"ips","linear","ips","linear"]
[40,{"$f":"B14*D$21","v":100.8},{"$f":"C14/D$21","v":236.86507936507937},null,{"$f":"P14/G$24","v":40},56.72,28.36,40,{"$f":"intrp(H30,$B$22:$B$31,$C$22:$C$31)","v":119.50554295792391},{"$f":"intrp(H30,$E$22:$E$38,$F$22:$F$38)","v":56.72},2.1069383455205202,null,{"$f":"C27+(C28-C27)/(B28-B27)*(H30-B27)","v":119.50554295792391},null,null,null,{"$f":"P18","v":80},{"$f":"Q18","v":45.92},{"$f":"P18","v":80},{"$f":"(T$26*($S30)^1)+(T$27)","v":46.008333333333333}]
[50,{"$f":"B15*D$21","v":126},{"$f":"C15/D$21","v":278.21428571428572},null,{"$f":"P15/G$24","v":50},64.900000000000006,32.450000000000003,50,{"$f":"intrp(H31,$B$22:$B$31,$C$22:$C$31)","v":142.14978584026201},{"$f":"intrp(H31,$E$22:$E$38,$F$22:$F$38)","v":64.900000000000006},2.1902894582474883,null,null,null,null,null,{"$f":"P19","v":90},{"$f":"Q19","v":50.91},{"$f":"P19","v":90},{"$f":"(T$26*($S31)^1)+(T$27)","v":50.733333333333327}]
[60,null,null,null,{"$f":"P16/G$24","v":60},73.36,36.68,60,{"$f":"intrp(H32,$B$22:$B$31,$C$22:$C$31)","v":161.64965986394557},{"$f":"intrp(H32,$E$22:$E$38,$F$22:$F$38)","v":73.36},2.2035122664114719,null," 1 / 1.4 = .71","    IF forks 1.4 stiffer",null,null,100,55.37,100,55.458333333333329]
[70,"   We need 30 & 40ips to match",null,null,{"$f":"P17/G$24","v":70},82.8,41.4,70,{"$f":"intrp(H33,$B$22:$B$31,$C$22:$C$31)","v":181.01851851851853},{"$f":"intrp(H33,$E$22:$E$38,$F$22:$F$38)","v":82.8},2.1862139917695478,null,{"$f":"1/1.4","v":0.7142857142857143},null,null,null,null,null,110,60.18333333333333]
[80,"   fork velocity of 100ips",null,null,{"$f":"P18/G$24","v":80},91.84,45.92,80,{"$f":"intrp(H34,$B$22:$B$31,$C$22:$C$31)","v":199.72222222222223},{"$f":"intrp(H34,$E$22:$E$38,$F$22:$F$38)","v":91.84},2.174675764614789,null,null,null,null,null,null,null,120,64.908333333333331]
[90,null,null,null,{"$f":"P19/G$24","v":90},101.82,50.91,90,{"$f":"intrp(H35,$B$22:$B$31,$C$22:$C$31)","v":217.57936507936509},{"$f":"intrp(H35,$E$22:$E$38,$F$22:$F$38)","v":101.82},2.1369020337788753,null," sh manual interpolate formula for 100ips"]
[100,null,null,null,{"$f":"(P20/G$24)","v":100},110.74,55.37,100,{"$f":"intrp(H36,$B$22:$B$31,$C$22:$C$31)","v":235.43650793650795},{"$f":"intrp(H36,$E$22:$E$38,$F$22:$F$38)","v":110.74},{"$f":"I36/J36","v":2.1260295099919446},null,{"$f":"C29+(C30-C29)/(B30-B29)*(H36-B29)","v":235.43650793650795}]
[null," 2.52 LR just happens to match",null,null,{"$f":"(P21/G$24)+0.01","v":110.01},120.36666666666666,60.18333333333333]
[null," fork 100ips at shock 40ips",null,null,{"$f":"(P22/G$24)+0.01","v":120.01},{"$f":"(2*Q22*G$24)+G$22","v":129.81666666666666},{"$f":"F38/2","v":64.908333333333331}]
[null,null,null,null,null,null,null," As per  openDynoSh_press_a_target.php  line 1950,"]
[null,null,null,null,null,null,null,"we can't just compare dyno numbers, we have to"]
[null,null,null,null,null,null,null,"add fixed gas force numbers for total fk air spr force"]
[null,null,null,null,null,null,null,"and shock spr + gas force."]
[]
[null,null,null,null,null,null,null,100,{"$f":"intrp(H44,$B$22:$B$31,$C$22:$C$31)","v":235.43650793650795},{"$f":"intrp(H44,$E$22:$E$38,$F$22:$F$38)","v":110.74}]
[null,null,null,null,null,null,null,null,120.25,327,null," <-- shock spring + gas force AND fork total air spring force  [spring + air spr + icspr]"]
[null,null,null,null,null,null,null,100,{"$f":"SUM(I44:I45)","v":355.68650793650795},{"$f":"SUM(J44:J45)","v":437.74},{"$f":"J46/I46","v":1.2306904823000457}," <-- fk/sh ratio that matches VDB"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"  =    C27   +   (     C28      -      C27     )   /   (B28-B27)  *  (H34-B27)"]
[null,null,null,null," we used this with target sh/fk ratio",null,null,null,null,null,null,null,194.9,239.8,194.9,100.8,100]
[null,null,null,null,"aver",1,null,0.9," factor",null,null,null,null,null,null,75.599999999999994,75.599999999999994]
[null,null,null,null," soft",0.89700000000000002,{"$f":"1/F54","v":1.1148272017837235},{"$f":"G54*H$53","v":1.0033444816053512},null,null,null,null," $fwhl_LR_30"," $fwhl_LR_40"," $fwhl_LR_30"," $uwhl_LR_40",100]
[null,null,null,null," stiff+1",0.80100000000000005,{"$f":"1/F55","v":1.2484394506866416},{"$f":"G55*H$53","v":1.1235955056179776},null,null,null,null,null,null,null," $uwhl_LR_30"," $uwhl_LR_30"]
[null,null,null,null," stiff+2",0.73299999999999998,1.3642564802182811,{"$f":"G56*H$53","v":1.2278308321964531}]
[null,null,null,null," stiff+3",0.66600000000000004,1.5015015015015014,{"$f":"G57*H$53","v":1.3513513513513513},null,null,null,null,"  =  $fwhl_LR_30 +   ( $fwhl_LR_40  - $fwhl_LR_30 )   /   ($uwhl_LR_40 - $uwhl_LR_30)  *  (100 -  $uwhl_LR_30)"]
[null,null,null,null," stiff+4",0.60599999999999998,1.6501650165016502,{"$f":"G58*H$53","v":1.4851485148514851}]
[null,null,null,null," stiff+5",0.55700000000000005,1.7953321364452421,{"$f":"G59*H$53","v":1.6157989228007179}]
[null,null,null,null," stiff+6",0.52600000000000002,1.9011406844106462,{"$f":"G60*H$53","v":1.7110266159695817}]
[]
[]
[]
[null,null,null,null,null,null,null,0.9," factor"]
[null,null,null,null,null,null,1.1160000000000001,{"$f":"G65*H$64","v":1.0044000000000002}]
[null,null,null,null,null,null,1.2509999999999999,{"$f":"G66*H$64","v":1.1258999999999999}]
[null,null,null,null,null,null,1.4059999999999999,{"$f":"G67*H$64","v":1.2653999999999999}]
[null,null,null,null,null,null,1.5840000000000001,{"$f":"G68*H$64","v":1.4256000000000002}]
[null,null,null,null,null,null,1.7889999999999999,{"$f":"G69*H$64","v":1.6100999999999999}]
[null,null,null,null,null,null,2.024,{"$f":"G70*H$64","v":1.8216000000000001}]
[null,null,null,null,null,null,2.294,{"$f":"G71*H$64","v":2.0646}]

{"sheet":"results_targ_03_USE (2)","index":2,"n_rows":58,"n_cols":22,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null," 8-31-22",null," vdb / excel / sh_fk_ratio_interpolate.xlsm"]
[null,null,null,null,null," 2349s",null,null,null,null,null,"Use this to verify calculations are correct.",null,null,null,null,null,null,null," 3791f"]
[null," SHOCK",null,null,null,"COPY NUMBERS",null,null," CO WOGAS",null,null,null,null,null,null," FORK"," CO WOGAS",null,null,"COPY NUMBERS",null," CO WOGAS"]
[null,null," CO WOGAS"," %",null,"HERE",null," 109 x 1.0"," 2349s",null,null,null,null,null,null,null," 3791f"," drag"," %","HERE"," 3791f"," 3791f"]
[null,"   ips   ","[actual]",1,null,"[actual]",null,"[actual]","TARGET",null,null,null,null,null,null,"ips","TARGET",0,1,"[actual]","[actual]","TARGET"]
[null,1,40.1,null,null,111.1,null,40.6,40.1,null,null,null,null,null,null,1,10.3,{"$f":"(Q6+R$5)","v":10.3},null,13.9,10.36,10.3]
[null,2,73.2,null,null,144.19999999999999,null,80.2,73.2,null,null,null,null,null,null,2,11.4,{"$f":"(Q7+R$5)","v":11.4},null,15,11.39,11.4]
[null,3,97.2,null,null,168.2,null,102.9,97.2,null,null,null,null,null,null,3,12.7,12.7,null,16.2,12.68,12.7]
[null,4,117.4,null,null,188.4,null,123.4,117.4,null,null,null,null,null,null,4,13.9,13.9,null,17.399999999999999,13.97,13.9]
[null,5,137.80000000000001,null,null,208.8,null,140.9,137.80000000000001,null,null,null,null,null,null,5,14.8,14.8,null,18.3,14.59,14.8]
[null,10,221.5,null,null,292.5,null,218.7,221.5,null,null,null,null,null,null,10,18,18,null,21.4,16.829999999999998,18]
[null,20,371.9,null,null,442.9,null,362.5,371.9,null,null,null,null,null,null,20,23,23,null,26.4,20.51,23]
[null,30,495.1,null,null,566.1,566.1,485.5,495.1,null,null,null,null,null,null,30,27.1,27.1,null,30.5,24.3,27.1]
[null,40,606.29999999999995,null,null,677.3,677.3,598.9,606.29999999999995,null,null,null,null,null,null,40,31.3,31.3,null,34.6,28.36,31.3]
[null,50,714.6,null,null,785.6,null,703.1,714.6,null,null,null,null,null,null,50,36.299999999999997,36.299999999999997,null,39.700000000000003,32.450000000000003,36.299999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,41.9,41.9,null,45.4,36.68,41.9]
[null," dyno wheel velocity and dyno force at the wheel",null,null,null,null,null,null,null,null,null,null,null,null,null,70,46.7,46.7,null,50.3,41.4,46.7]
[null,"Shock",null,"LR","Fork",null,null,null,null,null,null,null,null,null,null,80,52.1,52.1,null,55.9,45.92,52.1]
[null,"u.whl","F.wheel",2.52,"u.whl","F.wheel","F.bush","u.whl","F.shk","F.fk",null,null,null,null,null,90,58.1,58.1,null,62.1,50.91,58.1]
[1,{"$f":"B6*D$19","v":2.52},{"$f":"C6/D$19","v":15.912698412698413},null,{"$f":"P6/G$22","v":0.89766606822262107},{"$f":"2*Q6*G$22+G$20","v":22.948400000000003},0,1,{"$f":"intrp(H20,$B$20:$B$29,$C$20:$C$29)","v":{"$error":"#VALUE!"}},{"$f":"intrp(H20,$E$20:$E$34,$F$20:$F$34)","v":23.227791200000002},{"$f":"I20/J20","v":{"$error":"#VALUE!"}},null,null,null,null,100,63,63,null,67.3,55.37,63]
[2,{"$f":"B7*D$19","v":5.04},29.047619047619047,null,{"$f":"P7/G$22","v":1.7953321364452421},{"$f":"2*Q7*G$22+G$20","v":25.399200000000004},"LR [1.11]",2,{"$f":"intrp(H21,$B$20:$B$29,$C$20:$C$29)","v":{"$error":"#VALUE!"}},{"$f":"intrp(H21,$E$20:$E$34,$F$20:$F$34)","v":26.059579200000005},{"$f":"I21/J21","v":{"$error":"#VALUE!"}},null,null,null,null,111,{"$f":"T31","v":69.178333333333313}]
[3,7.5600000000000005,38.571428571428569,null,{"$f":"P8/G$22","v":2.6929982046678633},{"$f":"2*Q8*G$22+G$20","v":28.2956},1.1140000000000001,3,{"$f":"intrp(H22,$B$20:$B$29,$C$20:$C$29)","v":18.414588057445201},{"$f":"intrp(H22,$E$20:$E$34,$F$20:$F$34)","v":29.209971200000002},0.63042130138920505,null," F.shk =  dyno numbers converted to fwhl"]
[4,10.08,46.587301587301589,null,3.5906642728904843,{"$f":"2*Q9*G$22+G$20","v":30.969200000000004},null,4,{"$f":"intrp(H23,$B$20:$B$29,$C$20:$C$29)","v":23.626858150667676},{"$f":"intrp(H23,$E$20:$E$34,$F$20:$F$34)","v":31.883571200000006},0.74103550077438229,null," F.fk =  dyno numbers converted to fwhl",null,null,null,null,null,null,"linear"]
[5,12.6,54.682539682539684,null,4.4883303411131052,32.974400000000003,{"$f":"F24/2","v":16.487200000000001},5,{"$f":"intrp(H24,$B$20:$B$29,$C$20:$C$29)","v":28.839128243890151},{"$f":"intrp(H24,$E$20:$E$34,$F$20:$F$34)","v":33.787174400000005},0.85355253157512179,null," now they are compareable not including air spr",null,null,null,null,null,null,{"$f":"_xlfn.SINGLE(INDEX(LINEST(R$28:R$30,($Q$28:$Q$30)^{1}),1))","v":0.54499999999999993}]
[10,25.2,87.896825396825392,null,8.9766606822262105,40.104000000000006,{"$f":"F25/2","v":20.052000000000003},10,{"$f":"intrp(H25,$B$20:$B$29,$C$20:$C$29)","v":46.332829428067527},{"$f":"intrp(H25,$E$20:$E$34,$F$20:$F$34)","v":41.373960000000011},1.119854841742669,null,null,null,null,null,null,null,null,{"$f":"INDEX(LINEST(R$28:R$30,($Q$28:$Q$30)^{1}),1,2)","v":8.68333333333333}]
[20,50.4,{"$f":"C12/D$19","v":147.57936507936506},null,17.953321364452421,51.244000000000007,25.622000000000003,20,{"$f":"intrp(H26,$B$20:$B$29,$C$20:$C$29)","v":74.189342403628117},{"$f":"intrp(H26,$E$20:$E$34,$F$20:$F$34)","v":53.326734400000007},1.3912223060039488,null," SAVE !!",null,null,null,null,"STIFF"]
[30,75.599999999999994,{"$f":"C13/D$19","v":196.46825396825398},null,{"$f":"P13/G$22","v":26.929982046678631},60.378800000000005,30.189400000000003,30,{"$f":"intrp(H27,$B$20:$B$29,$C$20:$C$29)","v":99.264928193499614},{"$f":"intrp(H27,$E$20:$E$34,$F$20:$F$34)","v":63.579099200000009},1.5612823937823201,null," manual interpolate formula",null,null,null,"ips","linear","ips","linear"]
[40,100.8,{"$f":"C14/D$19","v":240.59523809523807},null,{"$f":"P14/G$22","v":35.906642728904842},69.736400000000003,34.868200000000002,40,{"$f":"intrp(H28,$B$20:$B$29,$C$20:$C$29)","v":122.94847568657092},{"$f":"intrp(H28,$E$20:$E$34,$F$20:$F$34)","v":74.816240000000008},1.6433394098202596,null,{"$f":"C25+(C26-C25)/(B26-B25)*(H28-B25)","v":122.94847568657092},null,null,null,80,{"$f":"Q18","v":52.1},80,{"$f":"(T$24*($S28)^1)+(T$25)","v":52.283333333333324}]
[50,126,{"$f":"C15/D$19","v":283.57142857142856},null,44.883303411131052,80.876400000000004,40.438200000000002,50,{"$f":"intrp(H29,$B$20:$B$29,$C$20:$C$29)","v":146.6320231796422},{"$f":"intrp(H29,$E$20:$E$34,$F$20:$F$34)","v":87.98817600000001},1.6664969072622007,null,null,null,null,null,90,{"$f":"Q19","v":58.1},90,{"$f":"(T$24*($S29)^1)+(T$25)","v":57.733333333333327}]
[60,null,null,null,53.859964093357263,93.353200000000001,46.676600000000001,60,{"$f":"intrp(H30,$B$20:$B$29,$C$20:$C$29)","v":166.2037037037037},{"$f":"intrp(H30,$E$20:$E$34,$F$20:$F$34)","v":100.66816960000001},1.6510055200576894,null," 1 / 1.4 = .71","    IF forks 1.4 stiffer",null,null,100,63,100,{"$f":"(T$24*($S30)^1)+(T$25)","v":63.183333333333323}]
[70,null,null,null,62.836624775583481,104.04760000000002,52.023800000000008,70,{"$f":"intrp(H31,$B$20:$B$29,$C$20:$C$29)","v":185.60405643738977},{"$f":"intrp(H31,$E$20:$E$34,$F$20:$F$34)","v":113.64849760000003},1.63314131164889,null,{"$f":"1/1.4","v":0.7142857142857143},null,null,null,null,null,111,{"$f":"(T$24*($S31)^1)+(T$25)","v":69.178333333333313}]
[80,null,null,null,71.813285457809684,116.07880000000002,58.039400000000008,80,{"$f":"intrp(H32,$B$20:$B$29,$C$20:$C$29)","v":204.1729654824893},{"$f":"intrp(H32,$E$20:$E$34,$F$20:$F$34)","v":128.27041600000004},1.5917385461858113]
[90,null,null,null,{"$f":"P19/G$22","v":80.789946140035894},{"$f":"2*Q19*G$22+G$20","v":129.44680000000002},64.723400000000012,90,{"$f":"intrp(H33,$B$20:$B$29,$C$20:$C$29)","v":221.68367346938777},{"$f":"intrp(H33,$E$20:$E$34,$F$20:$F$34)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null," manual interpolate formula"]
[100,null,null,null,{"$f":"(P20/G$22)","v":89.766606822262105},{"$f":"2*Q20*G$22+G$20","v":140.364},70.182000000000002,100,{"$f":"intrp(H34,$B$20:$B$29,$C$20:$C$29)","v":239.19438145628621},{"$f":"intrp(H34,$E$20:$E$35,$F$20:$F$35)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,{"$f":"C27+(C28-C27)/(B28-B27)*(H34-B27)","v":239.19438145628621}]
[null,null,null,null,{"$f":"(P21/G$22)+0.01","v":99.650933572710954},{"$f":"2*Q21*G$22+G$20","v":154.12932666666663},77.064663333333314]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"  =    C27   +   (     C28      -      C27     )   /   (B28-B27)  *  (H34-B27)"]
[null,null,null,null,null,null,null,null,null,null,null,null,194.9,239.8,194.9,100.8,100]
[null,null,null,null," we used this with target sh/fk ratio",null,null,null,null,null,null,null,null,null,null,75.599999999999994,75.599999999999994]
[null,null,null,null,"aver",1,null,0.9," factor",null,null,null," $fwhl_LR_30"," $fwhl_LR_40"," $fwhl_LR_30"," $uwhl_LR_40",100]
[null,null,null,null," soft",0.89700000000000002,{"$f":"1/F41","v":1.1148272017837235},{"$f":"G41*H$40","v":1.0033444816053512},null,null,null,null,null,null,null," $uwhl_LR_30"," $uwhl_LR_30"]
[null,null,null,null," stiff+1",0.80100000000000005,{"$f":"1/F42","v":1.2484394506866416},1.1235955056179776]
[null,null,null,null," stiff+2",0.73299999999999998,1.3642564802182811,1.2278308321964531,null,null,null,null,"  =  $fwhl_LR_30 +   ( $fwhl_LR_40  - $fwhl_LR_30 )   /   ($uwhl_LR_40 - $uwhl_LR_30)  *  (100 -  $uwhl_LR_30)"]
[null,null,null,null," stiff+3",0.66600000000000004,1.5015015015015014,1.3513513513513513]
[null,null,null,null," stiff+4",0.60599999999999998,1.6501650165016502,1.4851485148514851]
[null,null,null,null," stiff+5",0.55700000000000005,1.7953321364452421,1.6157989228007179]
[null,null,null,null," stiff+6",0.52600000000000002,1.9011406844106462,1.7110266159695817]
[]
[]
[]
[null,null,null,null,null,null,null,0.9," factor"]
[null,null,null,null,null,null,1.1160000000000001,{"$f":"G52*H$51","v":1.0044000000000002}]
[null,null,null,null,null,null,1.2509999999999999,{"$f":"G53*H$51","v":1.1258999999999999}]
[null,null,null,null,null,null,1.4059999999999999,1.2653999999999999]
[null,null,null,null,null,null,1.5840000000000001,1.4256000000000002]
[null,null,null,null,null,null,1.7889999999999999,1.6100999999999999]
[null,null,null,null,null,null,2.024,1.8216000000000001]
[null,null,null,null,null,null,2.294,2.0646]

{"sheet":"results_targ_03_proposed","index":3,"n_rows":58,"n_cols":22,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[null," Make changes here to match  openDynoFk__Shpress_target.php",null,null,null,null,null,null,null,null,null," 8-31-22",null," vdb / excel / sh_fk_ratio_interpolate.xlsm"]
[null," Looks like we started this but stopped.",null,null,null," 2349s",null,null,null,null,null,"Use this to verify calculations are correct.",null,null,null,null,null,null,null," 3791f"]
[null," SHOCK",null,null,null,"COPY NUMBERS",null,null," CO WOGAS",null,null,null,null,null,null," FORK"," CO WOGAS",null,null,"COPY NUMBERS",null," CO WOGAS"]
[null,null," CO WOGAS"," %",null,"HERE",null," 109 x 1.0"," 2349s",null,"Shock lev ratio",null,null,"Fork lev ratio",null,null," 3791f"," drag"," %","HERE"," 3791f"," 3791f"]
[null,"   ips   ","[actual]",1,null,"[actual]",null,"[actual]","TARGET",null," wheel",300,null," wheel",278.39999999999998,"ips","TARGET",0,1,"[actual]","[actual]","TARGET"]
[null,1,40.1,null,null,111.1,null,40.6,40.1,null,"shaft",135,null,"shaft",310,1,10.3,{"$f":"(Q6+R$5)","v":10.3},null,13.9,10.36,10.3]
[null,2,73.2,null,null,144.19999999999999,null,80.2,73.2,null," LR = wh/shaft",{"$f":"L5/L6","v":2.2222222222222223},null," LR = wh/shaft",{"$f":"O5/O6","v":0.89806451612903215},2,11.4,{"$f":"(Q7+R$5)","v":11.4},null,15,11.39,11.4]
[null,3,97.2,null,null,168.2,null,102.9,97.2,null,null,null,null,null,null,3,12.7,12.7,null,16.2,12.68,12.7]
[null,4,117.4,null,null,188.4,null,123.4,117.4,null,"SHOCK (shaft moves less than the wheel)",null,null,null,null,4,13.9,13.9,null,17.399999999999999,13.97,13.9]
[null,5,137.80000000000001,null,null,208.8,null,140.9,137.80000000000001,null,null,null,null,null,null,5,14.8,14.8,null,18.3,14.59,14.8]
[null,10,221.5,null,null,292.5,null,218.7,221.5,null,null,null,"FORK  (shaft moves more than wheel)",null,null,10,18,18,null,21.4,16.829999999999998,18]
[null,20,371.9,null,null,442.9,null,362.5,371.9,null,null,null,"shaft","LR","wheel",20,23,23,null,26.4,20.51,23]
[null,30,495.1,{"$f":"495.1/2.52","v":196.46825396825398},null,566.1,566.1,485.5,495.1,null,null,null,310,0.89800000000000002,{"$f":"M13*N13","v":278.38},30,27.1,27.1,null,30.5,24.3,27.1]
[null,40,606.29999999999995,{"$f":"606.3/2.52","v":240.59523809523807},null,677.3,677.3,598.9,606.29999999999995,null,null,null,300,0.89800000000000002,{"$f":"M14*N14","v":269.40000000000003},40,31.3,31.3,null,34.6,28.36,31.3]
[null,50,714.6,null,null,785.6,null,703.1,714.6,null,null,null,290,0.89800000000000002,260.42,50,36.299999999999997,36.299999999999997,null,39.700000000000003,32.450000000000003,36.299999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,41.9,41.9,null,45.4,36.68,41.9]
[null," dyno wheel velocity and dyno force at the wheel",null,null,null,null,null,null,null,null,null,null,null,null,null,70,46.7,46.7,{"$f":"R17/1.114","v":41.921005385996409},50.3,41.4,46.7]
[null,"Shock",null,"LR","Fork",null,null,null,null,null,null,null,null,null,null,80,52.1,52.1,{"$f":"R18/1.114","v":46.768402154398558},55.9,45.92,52.1]
[null,"u.whl","F.wheel",2.52,"u.whl","F.wheel"," double",null,"u.whl","F.shk","F.fk",null,null,null,null,90,58.1,58.1,52.15439856373429,62.1,50.91,58.1]
[1,{"$f":"B6*D$19","v":2.52},{"$f":"C6/D$19","v":15.912698412698413},null,{"$f":"P6*H$22","v":0.89800000000000002},{"$f":"Q6/H$22","v":11.469933184855234},{"$f":"F20*2","v":22.939866369710469},null,{"$f":"P6*H$22","v":0.89800000000000002},{"$f":"intrp(I20,$B$20:$B$29,$C$20:$C$29)","v":{"$error":"#VALUE!"}},{"$f":"intrp(I20,$E$20:$E$34,$F$20:$F$34)","v":11.469933184855234},{"$f":"J20/K20","v":{"$error":"#VALUE!"}},null,null,null,100,63,63,56.552962298025129,67.3,55.37,63]
[2,{"$f":"B7*D$19","v":5.04},29.047619047619047,null,{"$f":"P7*H$22","v":1.796},{"$f":"Q7/H$22","v":12.694877505567929},{"$f":"F21*2","v":25.389755011135858},"LR [1.11]",{"$f":"P7*H$22","v":1.796},{"$f":"intrp(I21,$B$20:$B$29,$C$20:$C$29)","v":{"$error":"#VALUE!"}},{"$f":"intrp(I21,$E$20:$E$34,$F$20:$F$34)","v":12.694877505567929},{"$f":"J21/K21","v":{"$error":"#VALUE!"}},null,null,null,110,{"$f":"T31","v":68.633333333333326}]
[3,7.5600000000000005,38.571428571428569,null,2.694,14.142538975501113,28.285077951002226,0.89800000000000002,2.694,{"$f":"intrp(I22,$B$20:$B$29,$C$20:$C$29)","v":16.819633408919124},{"$f":"intrp(I22,$E$20:$E$34,$F$20:$F$34)","v":14.142538975501113},1.1892937638747538," F.shk =  dyno numbers converted to fwhl",null,null,120,{"$f":"T32","v":74.083333333333314}]
[4,10.08,46.587301587301589,null,3.5920000000000001,15.478841870824054,30.957683741648108,null,3.5920000000000001,{"$f":"intrp(I23,$B$20:$B$29,$C$20:$C$29)","v":21.500251952632905},{"$f":"intrp(I23,$E$20:$E$34,$F$20:$F$34)","v":15.478841870824054},1.3890090829830466," F.fk =  dyno numbers converted to fwhl",null,null,null,null,null,null,"linear"]
[5,12.6,54.682539682539684,null,4.49,16.48106904231626,32.962138084632521,null,4.49,{"$f":"intrp(I24,$B$20:$B$29,$C$20:$C$29)","v":26.180870496346689},{"$f":"intrp(I24,$E$20:$E$34,$F$20:$F$34)","v":16.48106904231626},1.5885420071431975," now they are compareable not including air spr",null,null,null,null,null,null,{"$f":"_xlfn.SINGLE(INDEX(LINEST(R$28:R$30,($Q$28:$Q$30)^{1}),1))","v":0.54499999999999993}]
[10,25.2,87.896825396825392,null,8.98,20.044543429844097,40.089086859688194,null,8.98,{"$f":"intrp(I25,$B$20:$B$29,$C$20:$C$29)","v":43.088309397833207},{"$f":"intrp(I25,$E$20:$E$34,$F$20:$F$34)","v":20.044543429844097},2.149627879958568,null,null,null,null,null,null,null,{"$f":"INDEX(LINEST(R$28:R$30,($Q$28:$Q$30)^{1}),1,2)","v":8.68333333333333}]
[20,50.4,{"$f":"C12/D$19","v":147.57936507936506},null,17.96,25.612472160356347,51.224944320712694,null,17.96,{"$f":"intrp(I26,$B$20:$B$29,$C$20:$C$29)","v":68.811791383219955},{"$f":"intrp(I26,$E$20:$E$34,$F$20:$F$34)","v":25.612472160356347},2.6866516809622398," SAVE !!",null,null,null,null,"STIFF"]
[30,75.599999999999994,{"$f":"C13/D$19","v":196.46825396825398},null,26.94,30.178173719376392,60.356347438752785,null,26.94,{"$f":"intrp(I27,$B$20:$B$29,$C$20:$C$29)","v":92.017762660619809},{"$f":"intrp(I27,$E$20:$E$34,$F$20:$F$34)","v":30.178173719376392},3.0491494785696158," manual interpolate formula",null,null,null,"ips","linear","ips","linear"]
[40,{"$f":"B14*D$19","v":100.8},{"$f":"C14/D$19","v":240.59523809523807},null,35.92,34.855233853006681,69.710467706013361,null,35.92,{"$f":"intrp(I28,$B$20:$B$29,$C$20:$C$29)","v":113.28558830939782},{"$f":"intrp(I28,$E$20:$E$34,$F$20:$F$34)","v":34.855233853006681},3.2501743866402317,{"$f":"C25+(C26-C25)/(B26-B25)*(I28-B25)","v":113.28558830939782},null,null,null,80,{"$f":"Q18","v":52.1},80,{"$f":"(T$24*($S28)^1)+(T$25)","v":52.283333333333324}]
[50,{"$f":"B15*D$19","v":126},{"$f":"C15/D$19","v":283.57142857142856},null,44.9,40.423162583518923,80.846325167037847,null,44.9,{"$f":"intrp(I29,$B$20:$B$29,$C$20:$C$29)","v":134.55341395817584},{"$f":"intrp(I29,$E$20:$E$34,$F$20:$F$34)","v":40.423162583518923},3.3286216455769124,null,null,null,null,90,{"$f":"Q19","v":58.1},90,{"$f":"(T$24*($S29)^1)+(T$25)","v":57.733333333333327}]
[60,null,null,null,53.88,46.659242761692646,93.318485523385291,null,53.88,{"$f":"intrp(I30,$B$20:$B$29,$C$20:$C$29)","v":154.33068783068782},{"$f":"intrp(I30,$E$20:$E$34,$F$20:$F$34)","v":46.659242761692646},3.3076123549393239," 1 / 1.4 = .71","    IF forks 1.4 stiffer",null,null,100,63,100,{"$f":"(T$24*($S30)^1)+(T$25)","v":63.183333333333323}]
[70,null,null,null,62.86,52.00445434298441,104.00890868596882,null,62.86,{"$f":"intrp(I31,$B$20:$B$29,$C$20:$C$29)","v":171.75220458553792},{"$f":"intrp(I31,$E$20:$E$34,$F$20:$F$34)","v":52.00445434298441},3.3026441053064892,{"$f":"1/1.4","v":0.7142857142857143},null,null,null,null,null,110,{"$f":"(T$24*($S31)^1)+(T$25)","v":68.633333333333326}]
[80,null,null,null,71.84,58.017817371937639,116.03563474387528,null,71.84,{"$f":"intrp(I32,$B$20:$B$29,$C$20:$C$29)","v":189.17372134038803},{"$f":"intrp(I32,$E$20:$E$34,$F$20:$F$34)","v":58.017817371937639},3.2606142373064961,null,null,null,null,null,null,120,{"$f":"(T$24*($S32)^1)+(T$25)","v":74.083333333333314}]
[90,null,null,null,{"$f":"P19*H$22","v":80.820000000000007},64.699331848552333,129.39866369710467,null,80.820000000000007,{"$f":"intrp(I33,$B$20:$B$29,$C$20:$C$29)","v":205.608843537415},{"$f":"intrp(I33,$E$20:$E$34,$F$20:$F$34)","v":64.699331848552333},3.1779129345369825," manual interpolate formula"]
[100,null,null,null,{"$f":"P20*H$22+0.01","v":89.81},{"$f":"Q20/H$22","v":70.155902004454347},140.31180400890869,null,89.8,{"$f":"intrp(I34,$B$20:$B$29,$C$20:$C$29)","v":221.33345930964978},{"$f":"intrp(I34,$E$20:$E$34,$G$20:$G$34)","v":140.29966480945174},{"$f":"J34/K34","v":1.5775765366956096},{"$f":"C27+(C28-C27)/(B28-B27)*(I34-B27)","v":221.33345930964978}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"  =    C27   +   (     C28      -      C27     )   /   (B28-B27)  *  (H34-B27)"]
[null,null,null,null,null,null,null,null,null,null,null,null,194.9,239.8,194.9,100.8,100]
[null,null,null,null," we used this with target sh/fk ratio",null,null,null,null,null,null,null,null,null,null,75.599999999999994,75.599999999999994]
[null,null,null,null,"aver",1,null,0.9," factor",null,null,null," $fwhl_LR_30"," $fwhl_LR_40"," $fwhl_LR_30"," $uwhl_LR_40",100]
[null,null,null,null," soft",0.89700000000000002,{"$f":"1/F41","v":1.1148272017837235},{"$f":"G41*H$40","v":1.0033444816053512},null,null,null,null,null,null,null," $uwhl_LR_30"," $uwhl_LR_30"]
[null,null,null,null," stiff+1",0.80100000000000005,{"$f":"1/F42","v":1.2484394506866416},1.1235955056179776,null,null,null,null,"  =  $fwhl_LR_30 +   ( $fwhl_LR_40  - $fwhl_LR_30 )   /   ($uwhl_LR_40 - $uwhl_LR_30)  *  (100 -  $uwhl_LR_30)"]
[null,null,null,null," stiff+2",0.73299999999999998,1.3642564802182811,1.2278308321964531]
[null,null,null,null," stiff+3",0.66600000000000004,1.5015015015015014,1.3513513513513513]
[null,null,null,null," stiff+4",0.60599999999999998,1.6501650165016502,1.4851485148514851,null,null,null,null,"START"]
[null,null,null,null," stiff+5",0.55700000000000005,1.7953321364452421,1.6157989228007179,null,null,null,null,"shaft",11.8," inch"]
[null,null,null,null," stiff+6",0.52600000000000002,1.9011406844106462,1.7110266159695817,null,null,null,null,"velocity",100," ips"]
[null,null,null,null,null,null,null,null,null,null,null,null," shaft/vel = seconds",{"$f":"N46/N47","v":0.11800000000000001}," sec"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"REVERSE"]
[null,null,null,null,null,null,null,0.9," factor",null,null,null,"shaft",11.8," inch"]
[null,null,null,null,null,null,1.1160000000000001,{"$f":"G52*H$51","v":1.0044000000000002},null,null,null,null,"seconds",0.11799999999999999," sec"]
[null,null,null,null,null,null,1.2509999999999999,{"$f":"G53*H$51","v":1.1258999999999999},null,null,null,null," shaft/sec = vel",{"$f":"N51/N52","v":100.00000000000001}," ips"]
[null,null,null,null,null,null,1.4059999999999999,1.2653999999999999]
[null,null,null,null,null,null,1.5840000000000001,1.4256000000000002,null,null,null,null,"CALC SHORTER SHAFT WITH SAME TIME"]
[null,null,null,null,null,null,1.7889999999999999,1.6100999999999999,null,null,null,null,"shaft",10.6," inch"]
[null,null,null,null,null,null,2.024,1.8216000000000001,null,null,null,null,"seconds",0.11799999999999999," sec"]
[null,null,null,null,null,null,2.294,2.0646,null,null,null,null," shaft/sec = vel",{"$f":"N56/N57","v":89.830508474576277}," ips"]

{"sheet":"fk_3791_targ_03","index":4,"n_rows":26,"n_cols":13,"rows_kept":26,"cut":false,"hidden":false,"merged":[[3,1,3,12],[4,1,4,12],[5,1,5,5],[6,8,6,9]]}
[]
[null," use this to verify calculations are correct"]
[]
[null,"  (3791)  2010 CRF SC 250"]
[null,"  ReStackor copy yellow highlighted columns      reb force is positive for ReStackor TARGETFORK"]
[null,"   target uses actual gas force and drag, defaults to targ if act empty"]
[null,null,null,null,null,"TARGET","FORK",null,"   spr rate =    dbl = .944"]
[null,null,"   $comp1_zeta_wogas   ","chrtd = 8",null,"   bv aver b x 1.0   ","   mv aver b x 1.0   ",null,null,null,null,"chrtd = 8","   .30-.65s x 1.0  "]
[null,null,"   + $gas_load1   ","  $comp1_zeta_wogas  ","  $comp1_zeta_wogas  ","  $comp1_zeta_bv  ","  $comp1_zeta_mv  ","   $gas_load1   ","   $drag1   ","   $ctg_drag   ","   $reb1_zeta   ","   $reb1_zeta_total   "]
[null,null,"  co wgas   ","   co wogas +chrtd   ","   co wogas   ","   bv force   ","   mv force   ","   gas force   ","   c ctg drag   ","   c ctg drag   ","   ro wogas   ","   ro wogas +chrtd    ","   r-zeta   "]
[null,"    ips    ","[targ]","[targ]","[targ]","[targ]","[targ]","[act]","[act]","[targ]","[targ]","[targ]","[targ]"]
[null,1,13.9,10.3,2.2999999999999998,0.7,0.1,11.6,1.5,1.2,0.9,8.9,2.91]
[null,2,15,11.4,3.4,1.6,0.1,11.6,1.7,1.2,2.2999999999999998,10.3,1.68]
[null,3,16.2,12.7,4.7,2.8,0.1,11.5,1.8,1.2,3.9,11.9,1.29]
[null,4,17.399999999999999,13.9,5.9,3.9,0.1,11.5,1.9,1.2,5.7,13.7,1.1200000000000001]
[null,5,18.3,14.8,6.8,4.7,0.1,11.5,2,1.2,7.8,15.8,1.03]
[null,10,21.4,18,10,6.9,0.9,11.4,2.2000000000000002,1.2,17.399999999999999,25.4,0.83]
[null,20,26.4,23,15,9.4,3,11.4,2.5,1.2,37.1,45.1,0.73]
[null,30,30.5,27.1,19.100000000000001,11,5.6,11.4,2.5,1.2,57.1,65.099999999999994,0.71]
[null,40,34.6,31.3,23.3,12.6,8.3000000000000007,11.3,2.4,1.2,77.099999999999994,85.1,0.69]
[null,50,39.700000000000003,36.299999999999997,28.3,14.1,11.8,11.5,2.5,1.2,97.2,105.2,0.69]
[null,60,45.4,41.9,33.9,15.4,15.7,11.5,2.8,1.2,117.3,125.3,0.68]
[null,70,50.3,46.7,38.700000000000003,16.600000000000001,19.5,11.6,2.6,1.2,137.1,145.1,0.68]
[null,80,55.9,52.1,44.1,17.8,23.9,11.8,2.4,1.2]
[null,90,62.1,58.1,50.1,19.2,28.3,12,2.6,1.2]
[null,100,67.3,63,55,20.3,32.299999999999997,12.3,2.4,1.2]

{"sheet":"sh_2349_targ_03","index":5,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[[3,1,3,10],[4,1,4,10]]}
[]
[null," use this to verify calculations are correct"]
[]
[null,"  (2349)  2020 SXF 450"]
[null,"  ReStackor copy yellow highlighted columns      reb force is positive for ReStackor"]
[null,null,2349,null,null,"TARGET","SHOCK",null,null,"  spr = 4.55"]
[null,null,"   109_74_38_g x 1.0  ",null,null,null,null,null,null,"  L 55-997 / 73_69_66 x 1.0  "]
[null,null,"  $co_wogas_targ1  ","  c+ca+dynm drag  ",null,"  "]
[null,null,"  + ds_sgas  ","  $co_wogas_targ1  ","  $c_force1_targ  ","  $ca_force1_targ  ","  ztnshc_gasforce_1  ","  $fixed_drag1  ","  $drag1  ","  $ro_wogas1_targ  "]
[null,null,"  co wgas  ","  co wogas  ","   c force   ","   ca force   ","   gas force   ","   drag force   ","   drag force   "," ro wogas ","     r-zeta     "]
[null,"   ips   ","[target]","[target]","[target]","[target]","[target]","[target]","[actual]","[target]","[targ]"]
[null,1,111.1,40.1,30.5,0.6,75,4.7,4.7,31.3,0.83]
[null,2,144.19999999999999,73.2,59.7,1.8,75,7.9,7.9,55,0.73]
[null,3,168.2,97.2,81.900000000000006,3.2,75,8.6,8.6,79.8,0.71]
[null,4,188.4,117.4,99.5,4.8,75,9.6,9.6,104.6,0.69]
[null,5,208.8,137.80000000000001,115.3,6.7,75,12.6,12.6,129.4,0.69]
[null,10,292.5,221.5,184.6,19.2,75,14.4,14.4,253.3,0.67]
[null,20,442.9,371.9,306.39999999999998,45.9,75,16.5,16.5,501.2,0.67]
[null,30,566.1,495.1,411.9,61.8,75,18,18,749.1,0.66]
[null,40,677.3,606.29999999999995,508.1,76.2,76,17.899999999999999,17.899999999999999,997.1,0.66]
[null,50,785.6,714.6,602,90.4,77,16.8,16.8,1245,0.66]

{"sheet":"results_act_02","index":6,"n_rows":57,"n_cols":20,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null," vdb / excel / sh_fk_ratio_interpolate.xlsm"]
[null,null,null,null,null," 3694S",null,null," WITH GAS"]
[null," SHOCK",null,null,null,"COPY NUMBERS",null,null,null,null,null,null,null,null,null," FORK"," CO WGAS",null,null,"COPY NUMBERS"]
[null,null," CO WGAS"," %",null,"HERE",null,null,null,null,null,null,null,null,null,null,null," drag"," %","HERE"]
[null,"   ips   ","[actual]",1,null,"[actual]",null,null,null,null,null,null,null,null,null,"ips","[actual]",0,1,"[actual]"]
[null,1,{"$f":"F6*D$5","v":109},null,null,109,null,null,null,null,null,null,null,null,null,1,{"$f":"(T6*S$5)+R$5","v":14},{"$f":"(Q6+R$5)","v":14},null,14]
[null,2,{"$f":"F7*D$5","v":148.19999999999999},null,null,148.19999999999999,null,null,null,null,null,null,null,null,null,2,{"$f":"(T7*S$5)+R$5","v":14.99},{"$f":"(Q7+R$5)","v":14.99},null,14.99]
[null,3,172.3,null,null,172.3,null,null,null,null,null,null,null,null,null,3,16.21,16.21,null,16.21]
[null,4,190.9,null,null,190.9,null,null,null,null,null,null,null,null,null,4,17.5,17.5,null,17.5]
[null,5,208.6,null,null,208.6,null,null,null,null,null,null,null,null,null,5,18.100000000000001,18.100000000000001,null,18.100000000000001]
[null,10,287.10000000000002,null,null,287.10000000000002,null,null,null,null,null,null,null,null,null,10,20.2,20.2,null,20.2]
[null,20,439,null,null,439,null,null,null,null,null,null,null,null,null,20,23.9,23.9,null,23.9]
[null,30,562.20000000000005,null,null,562.20000000000005,null,null,null,null,null,null,null,null,null,30,27.69,27.69,null,27.69]
[null,40,675.2,null,null,675.2,null,null,null,null,null,null,null,null,null,40,31.7,31.7,null,31.7]
[null,50,785.7,null,null,785.7,null,null,null,null,null,null,null,null,null,50,35.9,35.9,null,35.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,40.21,40.21,null,40.21]
[null," dyno wheel velocity and dyno force at the wheel",null,null,null,null,null,null,null,null,null,null,null,null,null,70,45,45,null,45]
[null,"Shock",null,"LR","Fork",null,null,null,null,null,null,null,null,null,null,80,49.69,49.69,null,49.69]
[null,"u.whl","F.wheel",2.52,"u.whl","F.wheel","F.bush","u.whl","F.shk","F.fk",null,null,null,null,null,90,54.89,54.89,null,54.89]
[1,{"$f":"B6*D$19","v":2.52},{"$f":"C6/D$19","v":43.253968253968253},null,{"$f":"P6/G$22","v":1},{"$f":"2*Q6*G$22+G$20","v":28},0,1,{"$f":"intrp(H20,$B$20:$B$29,$C$20:$C$29)","v":{"$error":"#VALUE!"}},{"$f":"intrp(H20,$E$20:$E$34,$F$20:$F$34)","v":28},{"$f":"I20/J20","v":{"$error":"#VALUE!"}},null,null,null,null,100,59.7,59.7,null,59.7]
[2,{"$f":"B7*D$19","v":5.04},58.809523809523803,null,{"$f":"P7/G$22","v":2},{"$f":"2*Q7*G$22+G$20","v":29.98},"LR [1.11]",2,{"$f":"intrp(H21,$B$20:$B$29,$C$20:$C$29)","v":{"$error":"#VALUE!"}},{"$f":"intrp(H21,$E$20:$E$34,$F$20:$F$34)","v":29.98},{"$f":"I21/J21","v":{"$error":"#VALUE!"}}]
[3,7.5600000000000005,68.373015873015873,null,{"$f":"P8/G$22","v":3},{"$f":"2*Q8*G$22+G$20","v":32.42},1,3,{"$f":"intrp(H22,$B$20:$B$29,$C$20:$C$29)","v":46.216931216931215},{"$f":"intrp(H22,$E$20:$E$34,$F$20:$F$34)","v":32.42},1.4255685137856635]
[4,10.08,75.753968253968253,null,4,{"$f":"2*Q9*G$22+G$20","v":35},null,4,{"$f":"intrp(H23,$B$20:$B$29,$C$20:$C$29)","v":52.38977072310405},{"$f":"intrp(H23,$E$20:$E$34,$F$20:$F$34)","v":35},1.4968505920886872,null,null,null,null," F.shk =  dyno numbers converted to fwhl"]
[5,12.6,82.777777777777771,null,5,36.200000000000003,null,5,{"$f":"intrp(H24,$B$20:$B$29,$C$20:$C$29)","v":58.562610229276892},{"$f":"intrp(H24,$E$20:$E$34,$F$20:$F$34)","v":36.200000000000003},1.6177516637921792,null,null,null,null," F.fk =  dyno numbers converted to fwhl"]
[10,25.2,113.92857142857143,null,10,40.4,null,10,{"$f":"intrp(H25,$B$20:$B$29,$C$20:$C$29)","v":75.519652305366591},{"$f":"intrp(H25,$E$20:$E$34,$F$20:$F$34)","v":40.4},1.8692983243902623,null,null,null,null," now they are compareable not including air spr"]
[20,50.4,{"$f":"C12/D$19","v":174.20634920634922},null,20,47.8,null,20,{"$f":"intrp(H26,$B$20:$B$29,$C$20:$C$29)","v":101.0726883345931},{"$f":"intrp(H26,$E$20:$E$34,$F$20:$F$34)","v":47.8},2.1144913877529938,null," SAVE !!"]
[30,75.599999999999994,{"$f":"C13/D$19","v":223.0952380952381},null,30,55.38,null,30,{"$f":"intrp(H27,$B$20:$B$29,$C$20:$C$29)","v":125.41005291005291},{"$f":"intrp(H27,$E$20:$E$34,$F$20:$F$34)","v":55.38},2.2645368889500346,null," manual interpolate formula",null,null,null,null,null,{"$f":"1/0.557","v":1.7953321364452421}]
[40,100.8,{"$f":"C14/D$19","v":267.93650793650795},null,40,63.4,null,40,{"$f":"intrp(H28,$B$20:$B$29,$C$20:$C$29)","v":149.32980599647266},{"$f":"intrp(H28,$E$20:$E$34,$F$20:$F$34)","v":63.4},2.3553597160326918,null,{"$f":"C25+(C26-C25)/(B26-B25)*(H28-B25)","v":149.32980599647266}]
[50,126,{"$f":"C15/D$19","v":311.78571428571428},null,50,71.8,null,50,{"$f":"intrp(H29,$B$20:$B$29,$C$20:$C$29)","v":173.24955908289243},{"$f":"intrp(H29,$E$20:$E$34,$F$20:$F$34)","v":71.8},2.4129465053327639]
[60,null,null,null,60,80.42,null,60,{"$f":"intrp(H30,$B$20:$B$29,$C$20:$C$29)","v":192.83068783068785},{"$f":"intrp(H30,$E$20:$E$34,$F$20:$F$34)","v":80.42},2.3977951732241714,null," 1 / 1.4 = .71","    IF forks 1.4 stiffer",null,null,null,null,7.9,7.9]
[70,null,null,null,70,90,null,70,{"$f":"intrp(H31,$B$20:$B$29,$C$20:$C$29)","v":212.23104056437393},{"$f":"intrp(H31,$E$20:$E$34,$F$20:$F$34)","v":90},2.3581226729374882,null,{"$f":"1/1.4","v":0.7142857142857143},null,null,null,null,null,12.6,12.6]
[80,null,null,null,80,99.38,null,80,{"$f":"intrp(H32,$B$20:$B$29,$C$20:$C$29)","v":230.92466616276141},{"$f":"intrp(H32,$E$20:$E$34,$F$20:$F$34)","v":99.38},2.323653312163025,null,null,null,null,null,null,null,1.4,1.4]
[90,null,null,null,90,109.78,null,90,{"$f":"intrp(H33,$B$20:$B$29,$C$20:$C$29)","v":248.71882086167801},{"$f":"intrp(H33,$E$20:$E$34,$F$20:$F$34)","v":109.78},2.2656114124765714,null," manual interpolate formula",null,null,null,null,null,{"$f":"SUM(S30:S32)","v":21.9},10.4]
[100,null,null,null,100.01,{"$f":"2*Q20*G$22+G$20","v":119.4},null,100,{"$f":"intrp(H34,$B$20:$B$29,$C$20:$C$29)","v":266.51297556059461},{"$f":"intrp(H34,$E$20:$E$34,$F$20:$F$34)","v":119.3903896103896},2.2322816470430724,null,{"$f":"C27+(C28-C27)/(B28-B27)*(H34-B27)","v":266.51297556059461},null,null,null,null,null,null,{"$f":"SUM(T30:T33)","v":32.299999999999997}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"  =    C27   +   (     C28      -      C27     )   /   (B28-B27)  *  (H34-B27)"]
[null,null,null,null,null,null,null,null,null,null,null,null,194.9,239.8,194.9,100.8,100]
[null,null,null,null," we used this with target sh/fk ratio",null,null,null,null,null,null,null,null,null,null,75.599999999999994,75.599999999999994]
[null,null,null,null,"aver",1,null,0.9," factor",null,null,null," $fwhl_LR_30"," $fwhl_LR_40"," $fwhl_LR_30"," $uwhl_LR_40",100]
[null,null,null,null," soft",0.89700000000000002,{"$f":"1/F40","v":1.1148272017837235},{"$f":"G40*H$39","v":1.0033444816053512},null,null,null,null,null,null,null," $uwhl_LR_30"," $uwhl_LR_30"]
[null,null,null,null," stiff+1",0.80100000000000005,{"$f":"1/F41","v":1.2484394506866416},1.1235955056179776]
[null,null,null,null," stiff+2",0.73299999999999998,1.3642564802182811,1.2278308321964531,null,null,null,null,"  =  $fwhl_LR_30 +   ( $fwhl_LR_40  - $fwhl_LR_30 )   /   ($uwhl_LR_40 - $uwhl_LR_30)  *  (100 -  $uwhl_LR_30)"]
[null,null,null,null," stiff+3",0.66600000000000004,1.5015015015015014,1.3513513513513513]
[null,null,null,null," stiff+4",0.60599999999999998,1.6501650165016502,1.4851485148514851]
[null,null,null,null," stiff+5",0.55700000000000005,1.7953321364452421,1.6157989228007179]
[null,null,null,null," stiff+6",0.52600000000000002,1.9011406844106462,1.7110266159695817]
[]
[null,null,null,null,null,null,null,null,null,null,null,101.3,112.79,123.55,129.55000000000001,46.33,77.61]
[null,null,null,null,null,null,null,null,null,null,null,39.549999999999997,41.92,44.12,46.43]
[null,null,null,null,null,null,null,0.9," factor",null,null,51.5,60.12,68.44,77.61]
[null,null,null,null,null,null,1.1160000000000001,{"$f":"G51*H$50","v":1.0044000000000002},null,null,null,9.31,9.65,9.81,10.19]
[null,null,null,null,null,null,1.2509999999999999,{"$f":"G52*H$50","v":1.1258999999999999},null,null,null,{"$f":"L48-L49-L50-L51","v":0.9399999999999995},{"$f":"M48-M49-M50-M51","v":1.1000000000000068},1.1800000000000086,-4.6799999999999944]
[null,null,null,null,null,null,1.4059999999999999,1.2653999999999999]
[null,null,null,null,null,null,1.5840000000000001,1.4256000000000002]
[null,null,null,null,null,null,1.7889999999999999,1.6100999999999999]
[null,null,null,null,null,null,2.024,1.8216000000000001]
[null,null,null,null,null,null,2.294,2.0646]

{"sheet":"fk_3791_act_02","index":7,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[[3,1,3,10],[4,1,4,10],[5,1,5,5],[5,8,5,9]]}
[]
[]
[]
[null,"  (3791)  2010 CRF SC 250"]
[null,"  ReStackor copy yellow highlighted columns      reb force is positive for ReStackor"]
[null,null,null,null,null,null,"ACTUAL","FORK","   spr rate =    dbl = .944"]
[null,null,null,null,"chrtd = 2.5",null,null,null,null,null,"chrtd = 2.5"]
[null,null,"co wgas","co wogas","co wogas","bv force","mv force","gas force","drag force","ro wogas","ro wogas"]
[null,"ips","[act]","[bv+mv+drag]","[bv+mv+drag+chtd]","[act]","[act]","[act]","[act]","[act]","[+chtd]"]
[null,1,14,2.36,4.8600000000000003,0.44,0.41,11.64,1.51,2.4,4.9000000000000004]
[null,2,14.99,3.39,5.89,1.29,0.41,11.6,1.69,3.6,6.1]
[null,3,16.21,4.68,7.18,2.4,0.51,11.53,1.77,5.0999999999999996,7.6]
[null,4,17.5,5.97,8.4700000000000006,3.52,0.51,11.53,1.94,6.7,9.1999999999999993]
[null,5,18.100000000000001,6.59,9.09,4.07,0.51,11.51,2.0099999999999998,9,11.5]
[null,10,20.2,8.83,11.33,5.71,0.92,11.37,2.2000000000000002,18.899999999999999,21.4]
[null,20,23.9,12.51,15.01,7.48,2.5,11.39,2.5299999999999998,38.4,40.9]
[null,30,27.69,16.3,18.8,8.98,4.8499999999999996,11.39,2.4700000000000002,59,61.5]
[null,40,31.7,20.36,22.86,10.37,7.61,11.34,2.38,81.2,83.7]
[null,50,35.9,24.45,26.95,11.47,10.53,11.45,2.4500000000000002,103.8,106.3]
[null,60,40.21,28.68,31.18,12.52,13.39,11.53,2.77,126.7,129.19999999999999]
[null,70,45,33.4,35.9,13.66,17.170000000000002,11.6,2.57,149,151.5]
[null,80,49.69,37.92,40.42,14.68,20.85,11.77,2.39]
[null,90,54.89,42.91,45.41,15.65,24.63,11.98,2.63]
[null,100,59.7,47.37,49.87,16.45,28.51,12.33,2.41]

{"sheet":"sh_3694_act_02","index":8,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[[3,1,3,10],[4,1,4,10],[5,8,5,9]]}
[]
[]
[]
[null,"  (3694)  2021 XCF 350"]
[null,"  ReStackor copy yellow highlighted columns      reb force is positive for ReStackor"]
[null,null,3694,null,"$new_cowogas1",null,"ACTUAL","SHOCK"," 4.55 spr"]
[null,null,"  ds_sc1_wgas  ","  ds_sc1_wogas  ","  c+ca+dynm drag  ","  $c_load1  ","  $ca_load1  ","  $gas_load1  ","  $drag1  ","  ds_sr1_wogas  "]
[null,null,"    co wgas    ","    co wogas    ","    co wogas    ","    c force    ","    ca force    ","    gas force    ","    drag force    ","    ro wogas    ","    r-zeta    "]
[null,"   ips   ","[act]","[act]","[act]","[act]","[act]","[act]","[act]","[act]","[act]"]
[null,1,109,39,38,28.6,0.9,75.7,3.8,27.5,0.73]
[null,2,148.19999999999999,78.2,77.2,66.2,1.6,75.3,5.0999999999999996,55.2,0.73]
[null,3,172.3,102.3,101.3,88.7,2.6,74.8,6.2,80.599999999999994,0.71]
[null,4,190.9,120.9,119.9,105.4,3.8,74.5,7.1,104,0.69]
[null,5,208.6,138.6,137.6,120.5,5.0999999999999996,74.5,8.5,126.7,0.67]
[null,10,287.10000000000002,217.1,216.1,186.8,15.1,74.599999999999994,10.6,265.3,0.7]
[null,20,439,369,368,308.10000000000002,44,74.5,12.4,538.70000000000005,0.72]
[null,30,562.20000000000005,492.2,491.2,412.2,63.1,74.900000000000006,12,794.4,0.7]
[null,40,675.2,605.20000000000005,604.20000000000005,508.1,78.8,75.400000000000006,12.9,1059.9000000000001,0.7]
[null,50,785.7,715.7,714.7,601.9,93.8,76.599999999999994,13.4,1337.8,0.71]
[null,60,0,0,0,0,0,0,0,0,0]
[null,70,0,0,0,0,0,0,0,0,0]

{"sheet":"results_targ_01","index":9,"n_rows":34,"n_cols":20,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 3791f","target",null,null," 3791f"]
[null," 3249s","target",null,null," 3249s",null,null,null,null,null,null,null,null,null,null,"co wogas"]
[null,null,"  co wogas  "," %",null,"COPY",null,null,null,null,null,null,null,null,null,null,null," drag"," %","COPY"]
[null,"   ips   ","[target]",1,null,"[target]",null,null,null,null,null,null,null,null,null,"ips","[targ]",16,1,"[targ]"]
[null,1,40.1,null,null,40.1,null,null,null,null,null,null,null,null,null,1,{"$f":"(T6*S$5)+R$5","v":18.3},{"$f":"(Q6+R$5)","v":34.299999999999997},null,2.2999999999999998]
[null,2,73.2,null,null,73.2,null,null,null,null,null,null,null,null,null,2,{"$f":"(T7*S$5)+R$5","v":19.399999999999999},{"$f":"(Q7+R$5)","v":35.4},null,3.4]
[null,3,97.2,null,null,97.2,null,null,null,null,null,null,null,null,null,3,20.7,36.700000000000003,null,4.7]
[null,4,117.4,null,null,117.4,null,null,null,null,null,null,null,null,null,4,21.9,37.9,null,5.9]
[null,5,137.80000000000001,null,null,137.80000000000001,null,null,null,null,null,null,null,null,null,5,22.8,38.799999999999997,null,6.8]
[null,10,221.5,null,null,221.5,null,null,null,null,null,null,null,null,null,10,26,42,null,10]
[null,20,371.9,null,null,371.9,null,null,null,null,null,null,null,null,null,20,31,47,null,15]
[null,30,495.1,null,null,495.1,null,null,null,null,null,null,null,null,null,30,35.1,51.1,null,19.100000000000001]
[null,40,606.29999999999995,null,null,606.29999999999995,null,null,null,null,null,null,null,null,null,40,39.299999999999997,55.3,null,23.3]
[null,50,714.6,null,null,714.6,null,null,null,null,null,null,null,null,null,50,44.3,60.3,null,28.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,49.9,65.900000000000006,null,33.9]
[null," dyno wheel velocity and dyno force at the wheel",null,null,null,null,null,null,null,null,null,null,null,null,null,70,54.7,70.7,null,38.700000000000003]
[null,"Shock",null,"LR","Fork",null,null,null,null,null,null,null,null,null,null,80,60.1,76.099999999999994,null,44.1]
[null,"u.whl","F.wheel",2.52,"u.whl","F.wheel","F.bush","u.whl","F.shk","F.fk",null,null,null,null,null,90,66.099999999999994,82.1,null,50.1]
[1,{"$f":"B6*D$19","v":2.52},{"$f":"C6/D$19","v":15.912698412698413},null,{"$f":"P6/G$22","v":1},{"$f":"2*Q6*G$22+G$20","v":36.6},0,1,{"$f":"intrp(H20,$B$20:$B$29,$C$20:$C$29)","v":{"$error":"#VALUE!"}},{"$f":"intrp(H20,$E$20:$E$34,$F$20:$F$34)","v":36.6},{"$f":"I20/J20","v":{"$error":"#VALUE!"}},null,null,null,null,100,71,87,null,55]
[2,5.04,29.047619047619047,null,{"$f":"P7/G$22","v":2},{"$f":"2*Q7*G$22+G$20","v":38.799999999999997},"LR [1.11]",2,{"$f":"intrp(H21,$B$20:$B$29,$C$20:$C$29)","v":{"$error":"#VALUE!"}},{"$f":"intrp(H21,$E$20:$E$34,$F$20:$F$34)","v":38.799999999999997},{"$f":"I21/J21","v":{"$error":"#VALUE!"}}]
[3,7.5600000000000005,38.571428571428569,null,3,41.4,1,3,{"$f":"intrp(H22,$B$20:$B$29,$C$20:$C$29)","v":18.414588057445201},{"$f":"intrp(H22,$E$20:$E$34,$F$20:$F$34)","v":41.4},0.44479681298176815]
[4,10.08,46.587301587301589,null,4,43.8,null,4,{"$f":"intrp(H23,$B$20:$B$29,$C$20:$C$29)","v":23.626858150667676},{"$f":"intrp(H23,$E$20:$E$34,$F$20:$F$34)","v":43.8},0.53942598517506113,null,null,null,null," F.shk =  dyno numbers converted to fwhl"]
[5,12.6,54.682539682539684,null,5,45.6,null,5,{"$f":"intrp(H24,$B$20:$B$29,$C$20:$C$29)","v":28.839128243890151},{"$f":"intrp(H24,$E$20:$E$34,$F$20:$F$34)","v":45.6},0.63243702289232784,null,null,null,null," F.fk =  dyno numbers converted to fwhl"]
[10,25.2,87.896825396825392,null,10,52,null,10,{"$f":"intrp(H25,$B$20:$B$29,$C$20:$C$29)","v":46.332829428067527},{"$f":"intrp(H25,$E$20:$E$34,$F$20:$F$34)","v":52},0.89101595053976013,null,null,null,null," now they are compareable not including air spr"]
[20,50.4,147.57936507936506,null,20,62,null,20,{"$f":"intrp(H26,$B$20:$B$29,$C$20:$C$29)","v":74.189342403628117},{"$f":"intrp(H26,$E$20:$E$34,$F$20:$F$34)","v":62},1.1966022968327115]
[30,75.599999999999994,196.46825396825398,null,30,70.2,null,30,{"$f":"intrp(H27,$B$20:$B$29,$C$20:$C$29)","v":99.264928193499614},{"$f":"intrp(H27,$E$20:$E$34,$F$20:$F$34)","v":70.2},1.414030316146718,null," SAVE !!"]
[40,100.8,240.59523809523807,null,40,78.599999999999994,null,40,{"$f":"intrp(H28,$B$20:$B$29,$C$20:$C$29)","v":122.94847568657092},{"$f":"intrp(H28,$E$20:$E$34,$F$20:$F$34)","v":78.599999999999994},1.5642299705670601,null," manual interpolate formula"]
[50,126,{"$f":"C15/D$19","v":283.57142857142856},null,50,88.6,null,50,{"$f":"intrp(H29,$B$20:$B$29,$C$20:$C$29)","v":146.6320231796422},{"$f":"intrp(H29,$E$20:$E$34,$F$20:$F$34)","v":88.6},1.6549889749395283,null,{"$f":"C25+(C26-C25)/(B26-B25)*(H29-B25)","v":146.6320231796422}]
[60,null,null,null,60,99.8,null,60,{"$f":"intrp(H30,$B$20:$B$29,$C$20:$C$29)","v":166.2037037037037},{"$f":"intrp(H30,$E$20:$E$34,$F$20:$F$34)","v":99.8},1.6653677725822014]
[70,null,null,null,70,109.4,null,70,{"$f":"intrp(H31,$B$20:$B$29,$C$20:$C$29)","v":185.60405643738977},{"$f":"intrp(H31,$E$20:$E$34,$F$20:$F$34)","v":109.4},1.6965635871790654,null," 1 / 1.4 = .71","    IF forks 1.4 stiffer"]
[80,null,null,null,80,120.2,null,80,{"$f":"intrp(H32,$B$20:$B$29,$C$20:$C$29)","v":204.1729654824893},{"$f":"intrp(H32,$E$20:$E$34,$F$20:$F$34)","v":120.2},1.698610361751159,null,{"$f":"1/1.4","v":0.7142857142857143}]
[90,null,null,null,90,132.19999999999999,null,90,{"$f":"intrp(H33,$B$20:$B$29,$C$20:$C$29)","v":221.68367346938777},{"$f":"intrp(H33,$E$20:$E$34,$F$20:$F$34)","v":132.19999999999999},1.6768810398592118]
[100,null,null,null,100.01,142,null,100,{"$f":"intrp(H34,$B$20:$B$29,$C$20:$C$29)","v":239.19438145628621},{"$f":"intrp(H34,$E$20:$E$34,$F$20:$F$34)","v":141.99020979020978},1.6845836188966505]

{"sheet":"fk_3791_targ_01","index":10,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[[7,2,7,3],[7,9,7,11],[8,2,8,5],[8,9,8,11],[3,1,3,11],[4,1,4,11],[5,1,5,3],[5,4,5,6],[6,2,6,3],[6,9,6,11]]}
[]
[]
[]
[null,"  (3791)  2010 CRF SC 250"]
[null,"  Reb numbers are positive for ReStackor"]
[null,"   stdrag = 8",null,null,"   spr rate =    dbl = .944"]
[null,null," bv aver b x 1.0 ",null,null,null,null,null,null,".30-.65s"]
[null,null," mv aver b x 1.0 ",null,null,null,null,null,null,"r-zeta factor 1.0"]
[null,null,"co wogas uses target drag if actual is empty"]
[null,null,"co wogas","co wogas","bv force","mv force","gas force","ctg drag","ctg drag","ro wogas","ro wogas"]
[null,null,"+chrtd",null,null,null,null,"comp","comp",null,"+chrtd","r-zeta"]
[null,"ips","[targ]","[targ]","[targ]","[targ]","[act]","[act]","[targ]","[targ]","[targ]","[targ]"]
[null,1,10.3,2.2999999999999998,0.7,0.1,11.6,1.5,1.2,0.9,8.9,2.91]
[null,2,11.4,3.4,1.6,0.1,11.6,1.7,1.2,2.2999999999999998,10.3,1.68]
[null,3,12.7,4.7,2.8,0.1,11.5,1.8,1.2,3.9,11.9,1.29]
[null,4,13.9,5.9,3.9,0.1,11.5,1.9,1.2,5.7,13.7,1.1200000000000001]
[null,5,14.8,6.8,4.7,0.1,11.5,2,1.2,7.8,15.8,1.03]
[null,10,18,10,6.9,0.9,11.4,2.2000000000000002,1.2,17.399999999999999,25.4,0.83]
[null,20,23,15,9.4,3,11.4,2.5,1.2,37.1,45.1,0.73]
[null,30,27.1,19.100000000000001,11,5.6,11.4,2.5,1.2,57.1,65.099999999999994,0.71]
[null,40,31.3,23.3,12.6,8.3000000000000007,11.3,2.4,1.2,77.099999999999994,85.1,0.69]
[null,50,36.299999999999997,28.3,14.1,11.8,11.5,2.5,1.2,97.2,105.2,0.69]
[null,60,41.9,33.9,15.4,15.7,11.5,2.8,1.2,117.3,125.3,0.68]
[null,70,46.7,38.700000000000003,16.600000000000001,19.5,11.6,2.6,1.2,137.1,145.1,0.68]
[null,80,52.1,44.1,17.8,23.9,11.8,2.4,1.2]
[null,90,58.1,50.1,19.2,28.3,12,2.6,1.2]
[null,100,63,55,20.3,32.299999999999997,12.3,2.4,1.2]

{"sheet":"sh_2349_targ_01","index":11,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[3,1,3,9],[4,4,4,5]]}
[]
[]
[]
[null,"  reb force is positive for ReStackor"]
[null,null,2349,null,"TARGET NUMBERS",null,null,null,"  spr = 4.55"]
[null,null,"   109_74_38_g x 1.0  ",null,"  ",null,null,null,"  D46 51-997 / 68_60_66 x 1.0  "]
[null,null,"  actual drag  ",null,"  "]
[null,null,"  co wogas  ","   c force   ","   ca force   ","   gas force   ","   drag force   ","   drag force   ","ro wogas","    r-zeta    "]
[null,"   ips   ","[target]","[target]","[target]","[target]","[target]","[actual]","[target]","[targ]"]
[null,1,40.1,30.5,0.6,75,4.7,4.7,29.1,0.77]
[null,2,73.2,59.7,1.8,75,7.9,7.9,51,0.68]
[null,3,97.2,81.900000000000006,3.2,75,8.6,8.6,71.2,0.63]
[null,4,117.4,99.5,4.8,75,9.6,9.6,91.6,0.61]
[null,5,137.80000000000001,115.3,6.7,75,12.6,12.6,112.3,0.6]
[null,10,221.5,184.6,19.2,75,14.4,14.4,219.4,0.57999999999999996]
[null,20,371.9,306.39999999999998,45.9,75,16.5,16.5,453,0.6]
[null,30,495.1,411.9,61.8,75,18,18,712.3,0.63]
[null,40,606.29999999999995,508.1,76.2,76,17.899999999999999,17.899999999999999,997.1,0.66]
[null,50,714.6,602,90.4,77,16.8,16.8,1307.5,0.69]