{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Readme","DERIVF","VBA","DERIVXY","Partial Derivatives"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":3,"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":"Readme","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"DERIVF","index":1,"n_rows":36,"n_cols":24,"rows_kept":36,"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,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"f(x)",{"$f":"X1*SIN(X1^2)+1","v":1},null,null,"Analytical derivative formulas"]
[null,null,null,"At x=0"]
[null,null,"f'",{"$f":"_xll.DERIVF(D23,X1,0)","v":3.1860332061455693E-15},null,null,{"$f":"SIN(X1^2)+2*X1^2*COS(X1^2)","v":0}]
[null,null,"f''",{"$f":"_xll.DERIVF(D23,X1,0,2)","v":0},null,null,{"$f":"6*X1*COS(X1^2)-4*X1^3*SIN(X1^2)","v":0}]
[null,null,"f'''",{"$f":"_xll.DERIVF(D23,X1,0,3)","v":6.0000000000122524},null,null,{"$f":"6*COS(X1)-8*X1^4*COS(X1^2)-24*X1^2*SIN(X1^2)","v":6}]
[null,null,"f''''",{"$f":"_xll.DERIVF(D23,X1,0,4)","v":1.2789621213945185E-15},null,null,{"$f":"16*X1^5*SIN(X1^2)-80*X1^3*COS(X1^2)-60*X1*SIN(X1^2)","v":0}]
[]
[]
[]
[null,null,null,"At x=1"]
[null,null,"f'",{"$f":"_xll.DERIVF(D23,X1,1)","v":1.9220755965441478},null,null,{"$f":"SIN(X2^2)+2*X2^2*COS(X2^2)","v":1.922075596544176}]
[null,null,"f''",{"$f":"_xll.DERIVF(D23,X1,1,2)","v":-0.12407010401091294},null,null,{"$f":"6*X2*COS(X2^2)-4*X2^3*SIN(X2^2)","v":-0.12407010402274743}]
[null,null,"f'''",{"$f":"_xll.DERIVF(D23,X1,1,3)","v":-21.275908247434309},null,null,{"$f":"6*COS(X2^2)-8*X2^4*COS(X2^2)-24*X2^2*SIN(X2^2)","v":-21.275908247125795}]
[null,null,"f''''",{"$f":"_xll.DERIVF(D23,X1,1,4)","v":-80.248907801650191},null,null,{"$f":"16*X2^5*SIN(X2^2)-80*X2^3*COS(X2^2)-60*X2*SIN(X2^2)","v":-80.248907800998623}]

{"sheet":"VBA","index":2,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Macros must be enabled to run this example"]
[]
[]
[null,null,{"$f":"vbMyFunction(X1,1)","v":0}]
[null,null,{"$f":"_xll.DERIVF(C11,X1,2)","v":"#Name? error returned by vbMyFunction()"}]

{"sheet":"DERIVXY","index":3,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"ISLOPE",0]
[null,null,null,null,null,null,null,null,"ESLOPE",-30.933006687013375]
[]
[null,"x ","y","exact derivative",null,"without end slopes","% error",null,"with defined end slopes","% error"]
[null,0,{"$f":"B9*SIN(B9^2)+1","v":1},{"$f":"SIN(B9^2)+2*B9^2*COS(B9^2)","v":0},null,{"$f":"_xll.DERIVXY(x_data,y_data,B9)","v":-6.2561083937771045E-3},1,null,{"$f":"_xll.DERIVXY(x_data,y_data,B9,,end_slopes)","v":0},0]
[null,0.25,{"$f":"B10*SIN(B10^2)+1","v":1.0156148294605951},0.18721525667989258,null,{"$f":"_xll.DERIVXY(x_data,y_data,B10)","v":0.1892893516665293},{"$f":"ABS((F10-D10)/D10)","v":1.1078664332272224E-2},null,{"$f":"_xll.DERIVXY(x_data,y_data,B10,,end_slopes)","v":0.18761296611471523},{"$f":"ABS((I10-D10)/D10)","v":2.1243430790614686E-3}]
[null,0.5,1.1237019796272614,0.73186017010984528,null,{"$f":"_xll.DERIVXY(x_data,y_data,B11)","v":0.73352245725479392},2.2713179550393555E-3,null,{"$f":"_xll.DERIVXY(x_data,y_data,B11,,end_slopes)","v":0.73397189106828309},2.8854158822727892E-3]
[null,0.75,1.3999770051520151,1.4849677351709716,null,{"$f":"_xll.DERIVXY(x_data,y_data,B12)","v":1.4889669276113362},2.6931173961865051E-3,null,{"$f":"_xll.DERIVXY(x_data,y_data,B12,,end_slopes)","v":1.4888455779091943},2.6113986495310587E-3]
[null,1,1.8414709848078965,1.922075596544176,null,{"$f":"_xll.DERIVXY(x_data,y_data,B13)","v":1.9238378944674799},9.1687232618342142E-4,null,{"$f":"_xll.DERIVXY(x_data,y_data,B13,,end_slopes)","v":1.9238738594625655},9.3558386653609443E-4]
[null,1.25,2.2499569820978111,1.0258913095028064,null,{"$f":"_xll.DERIVXY(x_data,y_data,B14)","v":1.0154412178682897},1.0186353600735054E-2,null,{"$f":"_xll.DERIVXY(x_data,y_data,B14,,end_slopes)","v":1.0154187075901095},1.0208295767484698E-2]
[null,1.5,2.1671097953318821,-2.0487081053644052,null,{"$f":"_xll.DERIVXY(x_data,y_data,B15)","v":-2.077937039652805},1.4267007687364431E-2,null,{"$f":"_xll.DERIVXY(x_data,y_data,B15,,end_slopes)","v":-2.0778829635351634},1.4240612459318071E-2]
[null,1.75,1.1382678793079319,-6.0268418467248468,null,{"$f":"_xll.DERIVXY(x_data,y_data,B16)","v":-6.043962292735614},2.8406993988187956E-3,null,{"$f":"_xll.DERIVXY(x_data,y_data,B16,,end_slopes)","v":-6.0441560869280444},2.8728545801490783E-3]
[null,2,-0.5136049906158564,-5.9859514622168239,null,{"$f":"_xll.DERIVXY(x_data,y_data,B17)","v":-5.9147912207776105},1.1887874782877053E-2,null,{"$f":"_xll.DERIVXY(x_data,y_data,B17,,end_slopes)","v":-5.9140701201255261},1.2008340285585516E-2]
[null,2.25,-1.1135029370203964,2.5335615644844953,null,{"$f":"_xll.DERIVXY(x_data,y_data,B18)","v":2.6818773799061093},5.8540442632500959E-2,null,{"$f":"_xll.DERIVXY(x_data,y_data,B18,,end_slopes)","v":2.6791867714903077},5.7478456038798802E-2]
[null,2.5,0.917051958631108,12.459938511258684,null,{"$f":"_xll.DERIVXY(x_data,y_data,B19)","v":12.355165092116742},8.4088231292048492E-3,null,{"$f":"_xll.DERIVXY(x_data,y_data,B19,,end_slopes)","v":12.365206425127898},7.6029336778177126E-3]
[null,2.75,3.6340026552092861,5.3043157680308877,null,{"$f":"_xll.DERIVXY(x_data,y_data,B20)","v":4.8675293583831198},8.2345476542003707E-2,null,{"$f":"_xll.DERIVXY(x_data,y_data,B20,,end_slopes)","v":4.8300546347542159},8.9410426154310746E-2]
[null,3,2.2363554557252696,-15.988226228682427,null,{"$f":"_xll.DERIVXY(x_data,y_data,B21)","v":-15.993640560519278},3.3864493530484337E-4,null,{"$f":"_xll.DERIVXY(x_data,y_data,B21,,end_slopes)","v":-15.85378299901477},8.408889625696513E-3]
[null,3.25,-1.9499595955201059,-9.7730660350839766,null,{"$f":"_xll.DERIVXY(x_data,y_data,B22)","v":-7.9005141250587174},0.19160332113822343,null,{"$f":"_xll.DERIVXY(x_data,y_data,B22,,end_slopes)","v":-8.4224696474478176},0.13819577016953552]
[null,3.5,-8.8917742433945568E-2,22.972966398176872,null,{"$f":"_xll.DERIVXY(x_data,y_data,B23)","v":19.69241868284357},0.14280035318354209,null,{"$f":"_xll.DERIVXY(x_data,y_data,B23,,end_slopes)","v":21.640383210895376},5.8006578871209684E-2]
[null,3.75,4.7395514455202461,3.0952706722252432,null,{"$f":"_xll.DERIVXY(x_data,y_data,B24)","v":9.4049718861686635},2.0384973988098003,null,{"$f":"_xll.DERIVXY(x_data,y_data,B24,,end_slopes)","v":2.1350692963505509},0.31021564107166988]
[null,4,-0.1516132666602612,-30.933006687013375,null,{"$f":"_xll.DERIVXY(x_data,y_data,B25)","v":-58.064652518234013},0.87710988154964376,null,{"$f":"_xll.DERIVXY(x_data,y_data,B25,,end_slopes)","v":-30.933006687013386},3.4455561155896681E-16]

{"sheet":"Partial Derivatives","index":4,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"f(x,y)",{"$f":"COS(X1*Y1)","v":1}]
[]
[null,"f'",{"$f":"_xll.DERIVF(D10,X1,PI())","v":0}]
[null,"f''",{"$f":"_xll.DERIVF(C12,Y1,PI())","v":9.3394486379311701}]