{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":1,"images":2,"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":"Sheet1","index":0,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Input: (user)"]
["p","qmax","R","n1","n2"]
[1,{"$f":"Sheet3!I17*PI()/180","v":1.1344640137963142},{"$f":"Sheet3!I12","v":20},{"$f":"Sheet3!H4","v":1.3},{"$f":"Sheet3!J4","v":1.35}]
["Loop: (program)"]
["cos(q0)","sin(q0)","f0","cos(f0)","sin(f0)"]
[0.98000000000000054,{"$f":"SQRT(1-A6^2)","v":0.1989974874213214},5.9999999999999982,{"$f":"COS(C6)","v":0.96017028665036552},{"$f":"SIN(C6)","v":-0.27941549819892758}]
[]
["p'",null,"r0",null,"rotation 1",null,null,null,"r0'",null,"R2-y0'>0?"]
[{"$f":"-B6","v":-0.1989974874213214},null,{"$f":"Sheet3!H8","v":0},null,{"$f":"D6","v":0.96017028665036552},{"$f":"E6","v":-0.27941549819892758},0,null,{"$f":"MMULT(E9:G11,C9:C11)","v":0},null,{"$f":"(C3^2-I10^2)/ABS(C3^2-I10^2)","v":1}]
[0,null,0,null,{"$f":"-E6","v":0.27941549819892758},{"$f":"D6","v":0.96017028665036552},0,null,0]
[{"$f":"-A6","v":-0.98000000000000054},null,{"$f":"Sheet3!J8","v":-10},null,0,0,1,null,-10]
[]
["A","B","C","B2-4AC>0?","z1","x1"]
[{"$f":"1/A6^2","v":1.0412328196584746},{"$f":"-2*(I9*B6/A6+I11)","v":20},{"$f":"I9^2+I10^2+I11^2-C3^2","v":-300},{"$f":"K9*(B14^2-4*A14*C14)/ABS(B14^2-4*A14*C14)","v":1},{"$f":"(SQRT(B14^2-4*A14*C14)-B14)/(2*A14)","v":9.898738679477816},{"$f":"E14*B6/A6","v":2.010024618220748}]
[]
["r2"]
[{"$f":"F14-I9","v":2.010024618220748}]
[{"$f":"-I10","v":0},null,"(x22+y22)1/2"]
[{"$f":"E14-I11","v":19.898738679477816},null,{"$f":"SQRT(A17^2+A18^2)","v":2.010024618220748}]
[]
["cos(q2)","sin(q2)","cos(f2)","sin(f2)"]
[{"$f":"A19/C3","v":0.99493693397389082},{"$f":"C19/C3","v":0.1005012309110374},{"$f":"IF(C19<>0,A17/C19,1)","v":1},{"$f":"IF(C19<>0,A18/C19,1)","v":0}]
[]
["rotation 2",null,null,null,"p1",null,"rotation 3",null,null,null,"p''"]
[{"$f":"C22","v":1},{"$f":"D22","v":0},0,null,{"$f":"MMULT(A25:C27,A9:A11)","v":-0.1989974874213214},null,{"$f":"A22","v":0.99493693397389082},0,{"$f":"-B22","v":-0.1005012309110374},null,{"$f":"MMULT(G25:I27,E25:E27)","v":-9.9498743710660711E-2}]
[{"$f":"-D22","v":0},{"$f":"C22","v":1},0,null,0,null,0,1,0,null,0]
[0,0,1,null,-0.98000000000000054,null,{"$f":"B22","v":0.1005012309110374},0,{"$f":"A22","v":0.99493693397389082},null,-0.99503768772846002]
[]
["(px''2+py''2)1/2","q3","q3'","sin(qe)","cos(f3)","sin(f3)"]
[{"$f":"SQRT(K25^2+K26^2)","v":9.9498743710660711E-2},{"$f":"ATAN(A30/ABS(K27))","v":9.9663652367404529E-2},{"$f":"ASIN(D3*SIN(B30)/E3)","v":9.5960812759314604E-2},{"$f":"SIN(2*C30-B30)","v":9.2127152697894274E-2},{"$f":"IF(A30<>0,K25/A30,1)","v":-1},{"$f":"IF(A30<>0,K26/A30,1)","v":0}]
[]
["pf''",null,"inv rot 3",null,null,null,"pf1",null,"inv rot 2",null,null,null,"pf'"]
[{"$f":"D30*E30","v":-9.2127152697894274E-2},null,{"$f":"A22","v":0.99493693397389082},0,{"$f":"B22","v":0.1005012309110374},null,{"$f":"MMULT(C33:E35,A33:A35)","v":-0.19173453123579087},null,{"$f":"C22","v":1},{"$f":"-D22","v":0},0,null,{"$f":"MMULT(I33:K35,G33:G35)","v":-0.19173453123579087}]
[{"$f":"D30*F30","v":0},null,0,1,0,null,0,null,{"$f":"D22","v":0},{"$f":"C22","v":1},0,null,0]
[{"$f":"-COS(2*C30-B30)","v":-0.9957472509305656},null,{"$f":"-B22","v":-0.1005012309110374},0,{"$f":"A22","v":0.99493693397389082},null,-0.98144682460731991,null,0,0,1,null,-0.98144682460731991]
[]
["inv rot 1",null,null,null,"pf",null,"P",null,"Paverage"]
[{"$f":"D6","v":0.96017028665036552},{"$f":"-E6","v":0.27941549819892758},0,null,{"$f":"MMULT(A38:C40,M33:M35)","v":-0.18409779981744279},null,{"$f":"A9*D6-E38","v":-6.9736747225898899E-3},null,5.5454349077614477E-4]
[{"$f":"E6","v":-0.27941549819892758},{"$f":"D6","v":0.96017028665036552},0,null,5.3573599567186346E-2,null,{"$f":"A9*E6-E39","v":2.0293825209769939E-3},null,-2.3078244908345199E-5]
[0,0,1,null,-0.98144682460731991,null,{"$f":"A11-E40","v":1.4468246073193747E-3},null,-4.0878391984266529E-2]

{"sheet":"Sheet2","index":1,"n_rows":102,"n_cols":9,"rows_kept":102,"cut":false,"hidden":false,"merged":[[14,5,14,11]]}
["index","angle","x","z(sphere)",null,"R","x0","y0","z0"]
[0,{"$f":"A2*PI()/50","v":0},{"$f":"$F$2*SIN(B2)","v":0},{"$f":"$F$2*COS(B2)","v":20},null,{"$f":"Sheet3!I12","v":20},{"$f":"Sheet3!H8","v":0},0,{"$f":"Sheet3!J8","v":-10}]
[{"$f":"A2+1","v":1},{"$f":"A3*PI()/50","v":6.2831853071795868E-2},{"$f":"$F$2*SIN(B3)","v":1.2558103905862674},{"$f":"$F$2*COS(B3)","v":19.960534568565432}]
[{"$f":"A3+1","v":2},0.12566370614359174,2.5066646712860852,19.842294026289558,null,"Px","Py","Pz","P"]
[3,0.18849555921538758,3.747626291714492,19.645745014573773,null,-6.9587021283364363E-5,6.4369973194492287E-6,1.5792856819068932E-2,{"$f":"SQRT(F5^2+G5^2+H5^2)","v":1.5793011438483721E-2}]
[4,0.25132741228718347,4.9737977432970961,19.371663222572622]
[5,0.31415926535897931,6.1803398874989481,19.021130325903069,null,"Plots:"]
[6,0.37699111843077515,7.3624910536935584,18.595529717765029,null,{"$f":"-G2","v":0},{"$f":"-I2","v":10},{"$f":"-G2","v":0},{"$f":"-I2","v":10}]
[7,0.43982297150257105,8.5155858313014541,18.096541049320393,null,80,{"$f":"G8 +(F9-F8)/TAN(Sheet1!B3)","v":47.304612652399889},-80,{"$f":"I8+(H8-H9)/TAN(Sheet1!B3)","v":47.304612652399889}]
[8,0.50265482457436694,9.635073482034306,17.526133600877273]
[9,0.56548667764616278,10.716535899579933,16.886558510040302]
[10,0.62831853071795862,11.755705045849464,16.180339887498949,null,0,0]
[11,0.69115038378975446,12.748479794973793,15.410264855515784,null,{"$f":"300*F5","v":-2.0876106385009308E-2},{"$f":"300*H5","v":4.7378570457206797}]
[12,0.7539822368615503,13.690942118573773,14.579372548428232]
[13,0.81681408993334625,14.579372548428232,13.690942118573773,null,"Sheet 2 contains the data necessary to construct the chart on sheet 3."]
[14,0.87964594300514209,15.410264855515784,12.748479794973795]
[15,0.94247779607693782,16.180339887498945,11.755705045849465]
[16,1.0053096491487339,16.886558510040302,10.716535899579931]
[17,1.0681415022205298,17.526133600877273,9.6350734820343025]
[18,1.1309733552923256,18.096541049320393,8.5155858313014541]
[19,1.1938052083641213,18.595529717765025,7.3624910536935619]
[20,1.2566370614359172,19.021130325903069,6.180339887498949]
[21,1.3194689145077132,19.371663222572622,4.9737977432970943]
[22,1.3823007675795089,19.645745014573773,3.7476262917144947]
[23,1.4451326206513047,19.842294026289554,2.5066646712860896]
[24,1.5079644737231006,19.960534568565432,1.2558103905862705]
[25,1.5707963267948966,20,1.22514845490862E-15]
[26,1.6336281798666925,19.960534568565432,-1.2558103905862681]
[27,1.6964600329384882,19.842294026289558,-2.5066646712860829]
[28,1.7592918860102842,19.645745014573773,-3.747626291714492]
[29,1.8221237390820801,19.371663222572622,-4.973797743297097]
[30,1.8849555921538756,19.021130325903073,-6.1803398874989419]
[31,1.9477874452256716,18.595529717765029,-7.3624910536935548]
[32,2.0106192982974678,18.09654104932039,-8.5155858313014541]
[33,2.0734511513692637,17.526133600877269,-9.6350734820343078]
[34,2.1362830044410597,16.886558510040299,-10.716535899579938]
[35,2.1991148575128552,16.180339887498949,-11.75570504584946]
[36,2.2619467105846511,15.410264855515784,-12.748479794973795]
[37,2.3247785636564471,14.579372548428228,-13.690942118573775]
[38,2.3876104167282426,13.690942118573776,-14.579372548428227]
[39,2.4504422698000385,12.748479794973797,-15.410264855515782]
[40,2.5132741228718345,11.755705045849465,-16.180339887498945]
[41,2.57610597594363,10.71653589957994,-16.886558510040295]
[42,2.6389378290154264,9.6350734820343042,-17.526133600877273]
[43,2.7017696820872219,8.5155858313014576,-18.096541049320386]
[44,2.7646015351590179,7.3624910536935628,-18.595529717765025]
[45,2.8274333882308138,6.1803398874989499,-19.021130325903069]
[46,2.8902652413026093,4.973797743297105,-19.371663222572618]
[47,2.9530970943744057,3.7476262917144916,-19.645745014573773]
[48,3.0159289474462012,2.5066646712860905,-19.842294026289554]
[49,3.0787608005179972,1.2558103905862716,-19.960534568565432]
[50,3.1415926535897931,2.45029690981724E-15,-20]
[51,3.2044245066615891,-1.255810390586267,-19.960534568565432]
[52,3.267256359733385,-2.5066646712860856,-19.842294026289558]
[53,3.330088212805181,-3.7476262917144956,-19.645745014573773]
[54,3.3929200658769765,-4.9737977432970917,-19.371663222572625]
[55,3.4557519189487724,-6.1803398874989455,-19.021130325903073]
[56,3.5185837720205684,-7.3624910536935584,-18.595529717765029]
[57,3.5814156250923639,-8.5155858313014452,-18.096541049320393]
[58,3.6442474781641603,-9.6350734820343078,-17.526133600877269]
[59,3.7070793312359558,-10.716535899579929,-16.886558510040302]
[60,3.7699111843077513,-11.755705045849453,-16.180339887498956]
[61,3.8327430373795477,-12.748479794973793,-15.410264855515784]
[62,3.8955748904513432,-13.690942118573767,-14.579372548428235]
[63,3.9584067435231396,-14.579372548428232,-13.690942118573773]
[64,4.0212385965949355,-15.410264855515788,-12.74847979497379]
[65,{"$f":"A67*PI()/50","v":4.0840704496667311},{"$f":"$F$2*SIN(B67)","v":-16.180339887498945},{"$f":"$F$2*COS(B67)","v":-11.755705045849465}]
[{"$f":"A67+1","v":66},4.1469023027385274,-16.886558510040306,-10.716535899579927]
[67,4.209734155810323,-17.526133600877273,-9.635073482034306]
[68,4.2725660088821193,-18.096541049320397,-8.5155858313014434]
[69,4.3353978619539149,-18.595529717765029,-7.3624910536935566]
[70,4.3982297150257104,-19.021130325903069,-6.1803398874989508]
[71,4.4610615680975068,-19.371663222572625,-4.973797743297089]
[72,4.5238934211693023,-19.645745014573773,-3.7476262917144925]
[73,4.5867252742410978,-19.842294026289554,-2.5066646712860918]
[74,4.6495571273128942,-19.960534568565432,-1.2558103905862641]
[75,4.7123889803846897,-20,-3.67544536472586E-15]
[76,4.7752208334564852,-19.960534568565432,1.2558103905862565]
[77,4.8380526865282816,-19.842294026289558,2.5066646712860847]
[78,4.9008845396000771,-19.645745014573773,3.7476262917144854]
[79,4.9637163926718735,-19.371663222572622,4.9737977432970988]
[80,5.026548245743669,-19.021130325903073,6.1803398874989446]
[81,5.0893800988154645,-18.595529717765032,7.3624910536935486]
[82,5.15221195188726,-18.096541049320397,8.5155858313014363]
[83,5.2150438049590573,-17.526133600877266,9.6350734820343149]
[84,5.2778756580308528,-16.886558510040299,10.716535899579934]
[85,5.3407075111026483,-16.180339887498953,11.755705045849458]
[86,5.4035393641744438,-15.410264855515791,12.748479794973786]
[87,5.4663712172462393,-14.579372548428243,13.690942118573759]
[88,5.5292030703180357,-13.69094211857378,14.579372548428225]
[89,5.5920349233898321,-12.748479794973793,15.410264855515788]
[90,5.6548667764616276,-11.755705045849467,16.180339887498945]
[91,5.7176986295334231,-10.716535899579942,16.886558510040295]
[92,5.7805304826052186,-9.635073482034322,17.526133600877262]
[93,5.843362335677015,-8.5155858313014594,18.096541049320386]
[94,5.9061941887488114,-7.3624910536935575,18.595529717765029]
[95,5.9690260418206069,-6.1803398874989526,19.021130325903069]
[96,6.0318578948924024,-4.9737977432971068,19.371663222572618]
[97,6.0946897479641988,-3.7476262917144938,19.645745014573773]
[98,6.1575216010359943,-2.5066646712860932,19.842294026289554]
[{"$f":"A100+1","v":99},6.2203534541077907,-1.2558103905862652,19.960534568565432]
[{"$f":"A101+1","v":100},6.2831853071795862,-4.90059381963448E-15,20]

{"sheet":"Sheet3","index":2,"n_rows":32,"n_cols":13,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[30,0,30,6],[31,0,31,6],[7,10,8,12],[23,12,23,14],[24,12,24,14],[25,12,25,14],[27,0,27,6],[28,0,28,6],[29,0,29,6],[3,10,3,12],[12,10,12,12],[16,10,16,12],[19,10,19,12]]}
["Optical Tweezers"]
["50 mW HeNe laser with uniform intensity profile and circular cross section"]
[null,null,null,null,null,null,null,"n1",null,"n2"]
[null,null,null,null,null,null,null,1.3,null,1.35,"Change the index of refraction."]
[]
[]
[null,null,null,null,null,null,null,"x0",null,"z0"]
[null,null,null,null,null,null,null,0,null,-10,"Move the beam with respect to the sphere."]
[]
[]
[null,null,null,null,null,null,null,null,"R"]
[null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,"Change the radius of the sphere."]
[]
[]
[null,null,null,null,null,null,null,null,"qmax"]
[null,null,null,null,null,null,null,null,65,null,"Change the focusing angle."]
[]
[]
[null,null,null,null,null,null,null,null,"F (pN)",null,"Force on the sphere"]
[null,null,null,null,null,null,null,null,{"$f":"Sheet2!I5*L25*L26*1000000000000","v":3.421819145004807}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"6.672E-34*300000000/0.0000006328","v":3.1630847029077117E-19},"Photon energy (J)"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"0.05/L24","v":1.5807354116706637E+17},"Number of photons /s"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"H4*L24/300000000","v":1.3706700379266752E-27},"Photon momentum (Js/m)"]
[]
["Calculate the force due to the refraction of the light."]
["The red lines represent the edges of the focused laser beam in the xz-plane."]
["The blue circle represents the intersection of the sphere with the xz-plane."]
["The green arrow points into the direction of the force on the sphere."]
["Its length is proportional to the magnitude of the force."]