{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":4,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Sheet1","index":0,"n_rows":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,0,1,5],[0,1,0,5],[10,0,10,4]]}
["Q2)"]
["Given: Generating function y=exp(x)  within 0<x<1"]
["Solution:"]
["xin",0,null,"yin",{"$f":"+EXP(B4)","v":1},"Conversion",{"$f":"PI()/180","v":1.7453292519943295E-2}]
["xfin",1,null,"yfin",{"$f":"+EXP(B5)","v":2.7182818284590451}]
["qin",20]
["fin",60]
["Dq",45,null,"rx",{"$f":"+B8/(B5-B4)","v":45}]
["Df",55,null,"ry",{"$f":"+B9/(E5-E4)","v":32.008718877812953}]
[]
["Use Chebyshev Spacing for the precission points"]
[]
["x1",{"$f":"+(B5+B4)/2-(B5-B4)/2*COS(PI()/6)","v":6.6987298107780646E-2},null,"y1",{"$f":"+EXP(B13)","v":1.0692818961849444},null,"q1",{"$f":"+B6+E8*(B13-B4)","v":23.01442841485013},"f1",{"$f":"+B7+E9*(E13-E4)","v":62.217624738305709}]
["x2",{"$f":"+(B5+B4)/2-(B5-B4)/2*COS(PI()/2)","v":0.49999999999999994},null,"y2",{"$f":"+EXP(B14)","v":1.648721270700128},null,"q2",{"$f":"+B6+E8*(B14-B4)","v":42.5},"f2",{"$f":"+B7+E9*(E14-E4)","v":80.764736783898002}]
["x3",{"$f":"+(B5+B4)/2-(B5-B4)/2*COS(5*PI()/6)","v":0.93301270189221941},null,"y3",{"$f":"+EXP(B15)","v":2.5421564118475337},null,"q3",{"$f":"+B6+E8*(B15-B4)","v":61.98557158514987},"f3",{"$f":"+B7+E9*(E15-E4)","v":109.36245105244444}]
[]
[null,null,null,null,null,null,null,"For drowing mechanism."]
["q1",{"$f":"+H13","v":23.01442841485013},"f1",{"$f":"+J13","v":62.217624738305709},null,null,null,0.5]
["q2",{"$f":"+H14","v":42.5},"f2",{"$f":"+J14","v":80.764736783898002},null,null,null,20,0,0,null,"For Deviation"]
["q3",{"$f":"+H15","v":61.98557158514987},"f3",{"$f":"+J15","v":109.36245105244444},null,null,null,{"$f":"FourBar(B30,B31,B32,B29,1,H19*PI()/180)","v":1.0544721886473554},{"$f":"+B30*COS(H19*PI()/180)","v":0.3474123912705922},{"$f":"+B30*SIN(H19*PI()/180)","v":0.12644776943773897},null,{"$f":"FrbarTA(B30,B31,B32,B29,H19*PI()/180)*180/PI()","v":55.618944472474979}]
["Coef. Matrix",null,null,null,null,null,null,null,{"$f":"+B29+B32*COS(H20)","v":1.1080257618586593},{"$f":"+B32*SIN(H20)","v":0.1902896702518056}]
[{"$f":"+COS(D18*PI()/180)","v":0.46611451257843872},{"$f":"-COS(B18*PI()/180)","v":-0.9204064290468108},1,null,{"$f":"+COS((D18-B18)*PI()/180)","v":0.77490922887890956},null,null,null,{"$f":"+B29","v":1},0]
[{"$f":"+COS(D19*PI()/180)","v":0.1604886994942612},{"$f":"-COS(B19*PI()/180)","v":-0.73727733681012397},1,null,{"$f":"+COS((D19-B19)*PI()/180)","v":0.78515767059935182},null,null,{"$f":"+H19*PI()/180+PI()","v":3.4906585039886591},{"$f":"+H20*180/PI()","v":60.416806023416221}]
[{"$f":"+COS(D20*PI()/180)","v":-0.33154291702109706},{"$f":"-COS(B20*PI()/180)","v":-0.46969389471404638},1,null,{"$f":"+COS((D20-B20)*PI()/180)","v":0.67717295139573019},null,"For Error",{"$f":"+B4+1/E8*(H23*180/PI()-B6-180)","v":0}]
["Inverse  Matrix",null,null,null,null,null,null,{"$f":"+EXP(H24)","v":1},{"$f":"+(I23-$B$7)/$E$9","v":1.3021640291424877E-2},{"$f":"+H25-I25-1","v":-1.302164029142483E-2}]
[{"$f":"MINVERSE(A22:C24)","v":-32.142555875835988},54.14031864321727,-21.997762767381303,"K1",{"$f":"MMULT(A26:C28,E22:E24)","v":2.7048333461831007}]
[-59.103633627839571,95.815900639595654,-36.712267011756083,"K2",4.5700839892941474]
[-38.417252606000304,62.953982718369694,-23.536730112369387,"K3",3.7204818371470889]
["a1",1]
["a2",{"$f":"+B29/E26","v":0.36970854467286879}]
["a3",{"$f":"+SQRT(B29^2+B30^2+B32^2-2*E28*B30*B32)","v":0.76328794554669432}]
["a4",{"$f":"+B29/E27","v":0.21881435928586745}]
["For the three positions of the mechanism "]
["For q1",null,null,"For q2",null,null,"For q3"]
[0,0,null,0,0,null,0,0]
[{"$f":"+B30*COS(B18*PI()/180)","v":0.3402821213904485},{"$f":"+B30*SIN(B18*PI()/180)","v":0.14454233243637207},null,{"$f":"+B30*COS(B19*PI()/180)","v":0.27257773121235945},{"$f":"+B30*SIN(B19*PI()/180)","v":0.24977147245282702},null,{"$f":"+B30*COS(B20*PI()/180)","v":0.17364984625646174},{"$f":"+B30*SIN(B20*PI()/180)","v":0.32638955084260562}]
[{"$f":"+B29+B32*COS(D18*PI()/180)","v":1.1019925484236954},{"$f":"+B32*SIN(D18*PI()/180)","v":0.19359040238535799},null,{"$f":"+B29+B32*COS(D19*PI()/180)","v":1.0351172319524589},{"$f":"+B32*SIN(D19*PI()/180)","v":0.21597801705192565},null,{"$f":"+B29+B32*COS(D20*PI()/180)","v":0.92745364903626115},{"$f":"+B32*SIN(D20*PI()/180)","v":0.20643824934234137}]
[{"$f":"+B29","v":1},0,null,{"$f":"+B29","v":1},0,null,{"$f":"+B29","v":1},0]
["x","y(req)","q","f","f in degrees","y (realized)","error","q in degrees","m","Deviation"]
[0,{"$f":"+EXP(A40)","v":1},{"$f":"+($B$6+$E$8*(A40-$A$40))*PI()/180","v":0.3490658503988659},{"$f":"FourBar(($B$30),$B$31,($B$32),$B$29,1,C40)","v":1.0544721886473554},{"$f":"+D40*180/PI()","v":60.416806023416221},{"$f":"+(E40-$B$7)/$E$9+1","v":1.0130216402914249},{"$f":"+B40-F40","v":-1.3021640291424941E-2},{"$f":"+C40*180/PI()","v":20},{"$f":"FrbarTA($B$30,$B$31,$B$32,$B$29,C40)/conv","v":55.618944472474986},{"$f":"90-I40","v":34.381055527525014}]
[0.1,{"$f":"+EXP(A41)","v":1.1051709180756477},0.42760566673861072,1.1036073402581872,{"$f":"+D41*180/PI()","v":63.232042836452315},{"$f":"+(E41-$B$7)/$E$9+1","v":1.1009738268123135},4.1970912633342294E-3,24.5,60.073976705767528,{"$f":"90-I41","v":29.926023294232472}]
[0.2,1.2214027581601699,0.50614548307835561,1.1652331652122057,66.762942515329556,1.2112843860182525,1.0118372141917353E-2,29,65.124365999329243,24.875634000670757]
[0.3,1.3498588075760032,0.58468529941810032,1.2375456250148902,70.906141268232801,1.3407240792693038,9.134728306699369E-3,33.499999999999993,70.701947218368133,19.298052781631867]
[0.4,1.4918246976412703,0.66322511575784515,1.3192607092317927,75.588070716417405,1.4869945209591746,4.8301766820957326E-3,38,76.765669824927969,13.234330175072031]
[0.5,1.6487212707001282,0.74176493209759009,1.4096105763855939,80.764736783897874,1.6487212707001242,3.9968028886505635E-15,42.5,83.302252915154483,6.697747084845517]
[0.6,1.8221188003905089,0.82030474843733492,1.508350189937903,86.422099911197932,1.8254657117661957,-3.3469113756867674E-3,47,90.328465033945179,-0.32846503394517867]
[0.7,2.0137527074704766,0.89884456477707964,1.6158203089747971,92.579684155780541,2.0178378047602323,-4.0850972897557014E-3,51.5,97.897698516528365,-7.8976985165283651]
[0.8,2.2255409284924679,0.97738438111682457,1.7331316806304433,99.301130640539697,2.2278257930460792,-2.284864553611321E-3,56,106.11537690323701,-16.115376903237006]
[0.9,2.4596031111569499,1.0559241974565694,1.8626191282660267,106.72021488997986,2.4596090230391656,-5.9118822157699924E-6,60.5,115.17419895693895,-25.174198956938952]
[1,2.7182818284590451,1.1344640137963142,2.0090181383942092,115.1082602952177,2.7216640411502491,-3.3822126912039785E-3,65,125.44290611968768,-35.442906119687677]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}