{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Interpolation"],"not_rendered":{"charts":2,"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":"Interpolation","index":0,"n_rows":216,"n_cols":12,"rows_kept":216,"cut":false,"hidden":false,"merged":[]}
[null,"X","Y","F'(xi)","f''i(Xi-1)","f''i(xi)","di","ci","bi","ai",null,"Check- to see whether Y co-ords match correctly"]
[null,0,30,{"$f":"((3*(C3-C2))/(2*(B3-B2))-(D3/2))","v":14.090909090909092},null,null,null,null,null,null,null,{"$f":"J3+(I3*B2) + (H3*(B2^2)) + (G3*(B2^3))","v":30}]
[null,10,130,{"$f":"2 / (((B4-B3)/(C4-C3)) + ((B3-B2)/(C3-C2)))","v":1.8181818181818181},{"$f":"-(2*(D3+(2*D2)) / (B3-B2)) + (6 *( (C3-C2)/((B3-B2)^2)))","v":0},{"$f":"(2*((2*D3)+D2) / (B3-B2)) - (6 *( (C3-C2)/((B3-B2)^2)))","v":-2.4545454545454546},{"$f":"(F3-E3)/(6*(B3-B2))","v":-4.0909090909090909E-2},{"$f":"((B3*E3) - (B2*F3)) / (2*(B3-B2))","v":0},{"$f":"((C3-C2) - (H3*(B3^2  - B2^2)) - (G3*(B3^3  - B2^3))  ) / (B3-B2)","v":14.09090909090909},{"$f":"C2-(I3*B2)-(H3*(B2^2))-(G3*(B2^3))","v":30},null,129.99999999999997]
[null,30,150,0,-6.3636363636363602E-2,-0.11818181818181822,-4.5454545454545514E-4,{"$f":"((B4*E4) - (B3*F4)) / (2*(B4-B3))","v":-1.818181818181815E-2},2.3181818181818175,109.09090909090909,null,150]
[null,50,150,0,0,0,0,0,0,150,null,150]
[null,70,170,{"$f":"2 / (((B7-B6)/(C7-C6)) + ((B6-B5)/(C6-C5)))","v":1.4285714285714286},0.1571428571428572,-1.4285714285714346E-2,-1.4285714285714294E-3,0.29285714285714304,-18.571428571428587,525.00000000000045,null,170.00000000000006]
[null,90,220,{"$f":"2 / (((B8-B7)/(C8-C7)) + ((B7-B6)/(C7-C6)))","v":4},6.4285714285714279E-2,0.19285714285714284,1.0714285714285713E-3,-0.19285714285714284,12.678571428571431,-140.00000000000017,null,220.00000000000364]
[null,100,320,{"$f":"((3 * (C8-C7)) /( 2 * (B8-B7))) - (D7/2)","v":13},1.7999999999999998,{"$f":"(2*((2*D8)+D7) / (B8-B7)) - (6 *( (C8-C7)/((B8-B7)^2)))","v":0},{"$f":"(F8-E8)/(6*(B8-B7))","v":-2.9999999999999995E-2},{"$f":"((B8*E8) - (B7*F8)) / (2*(B8-B7))","v":8.9999999999999982},-886.99999999999966,{"$f":"C7-(I8*B7)-(H8*(B7^2))-(G8*(B7^3))","v":29019.999999999982},null,{"$f":"J8+(I8*B8) + (H8*(B8^2)) + (G8*(B8^3))","v":320.00000000000364}]
[]
[]
[]
[]
[]
[]
[null,"X","Y(Linear Interp)",null,"X","Y (Constrained Spline Interp)"]
[null,0,{"$f":"interpolate(B16,$C$2:$C$8,$B$2:$B$8)","v":30},null,0,{"$f":"SplineInterpolation(E16,$C$2:$C$8,$B$2:$B$8)","v":30}]
[null,0.5,{"$f":"interpolate(B17,$C$2:$C$8,$B$2:$B$8)","v":35},null,0.5,{"$f":"SplineInterpolation(E17,$C$2:$C$8,$B$2:$B$8)","v":37.040340909090908}]
[null,{"$f":"B17+0.5","v":1},40,null,{"$f":"E17+0.5","v":1},44.050000000000004]
[null,1.5,45,null,1.5,50.998295454545449]
[null,2,50,null,2,57.854545454545452]
[null,2.5,{"$f":"interpolate(B21,$C$2:$C$8,$B$2:$B$8)","v":55},null,2.5,64.588068181818173]
[null,3,60,null,3,71.168181818181807]
[null,3.5,65,null,3.5,77.564204545454544]
[null,4,70,null,4,83.745454545454535]
[null,4.5,75,null,4.5,89.681249999999991]
[null,5,80,null,5,95.340909090909093]
[null,5.5,85,null,5.5,100.69374999999999]
[null,6,90,null,6,105.70909090909089]
[null,6.5,95,null,6.5,110.35624999999999]
[null,7,100,null,7,114.60454545454544]
[null,7.5,105,null,7.5,118.42329545454547]
[null,8,110,null,8,121.78181818181818]
[null,8.5,115,null,8.5,124.6494318181818]
[null,9,120,null,9,126.99545454545454]
[null,9.5,125,null,9.5,128.78920454545454]
[null,10,130,null,10,129.99999999999997]
[null,10.5,130.5,null,10.5,130.90107954545456]
[null,11,131,null,11,131.78590909090912]
[null,11.5,131.5,null,11.5,132.65414772727271]
[null,12,132,null,12,133.50545454545454]
[null,12.5,132.5,null,12.5,134.33948863636363]
[null,13,133,null,13,135.15590909090909]
[null,13.5,133.5,null,13.5,135.954375]
[null,14,134,null,14,136.73454545454544]
[null,14.5,134.5,null,14.5,137.49607954545453]
[null,15,135,null,15,138.23863636363635]
[null,15.5,135.5,null,15.5,138.96187499999996]
[null,16,136,null,16,139.66545454545454]
[null,16.5,136.5,null,16.5,140.34903409090907]
[null,17,137,null,17,141.01227272727272]
[null,17.5,137.5,null,17.5,141.65482954545453]
[null,18,138,null,18,142.27636363636364]
[null,18.5,138.5,null,18.5,142.87653409090908]
[null,19,139,null,19,143.45499999999998]
[null,19.5,139.5,null,19.5,144.01142045454543]
[null,20,140,null,20,144.54545454545453]
[null,20.5,140.5,null,20.5,145.05676136363635]
[null,21,141,null,21,145.54499999999999]
[null,21.5,141.5,null,21.5,146.00982954545455]
[null,22,142,null,22,146.45090909090908]
[null,22.5,142.5,null,22.5,146.86789772727275]
[null,23,143,null,23,147.26045454545454]
[null,23.5,143.5,null,23.5,147.62823863636362]
[null,24,144,null,24,147.97090909090909]
[null,24.5,144.5,null,24.5,148.28812499999998]
[null,25,145,null,25,148.57954545454544]
[null,25.5,145.5,null,25.5,148.84482954545453]
[null,26,146,null,26,149.08363636363634]
[null,26.5,146.5,null,26.5,149.29562499999997]
[null,27,147,null,27,149.48045454545453]
[null,27.5,147.5,null,27.5,149.63778409090909]
[null,28,148,null,28,149.76727272727274]
[null,28.5,148.5,null,28.5,149.86857954545451]
[null,29,149,null,29,149.94136363636366]
[null,29.5,149.5,null,29.5,149.98528409090909]
[null,30,150,null,30,150]
[null,30.5,150,null,30.5,150]
[null,31,150,null,31,150]
[null,31.5,150,null,31.5,150]
[null,32,{"$f":"interpolate(B80,$C$2:$C$8,$B$2:$B$8)","v":150},null,32,{"$f":"SplineInterpolation(E80,$C$2:$C$8,$B$2:$B$8)","v":150}]
[null,32.5,150,null,32.5,150]
[null,{"$f":"B81+0.5","v":33},150,null,{"$f":"E81+0.5","v":33},150]
[null,33.5,150,null,33.5,150]
[null,34,150,null,34,150]
[null,34.5,150,null,34.5,150]
[null,35,150,null,35,150]
[null,35.5,150,null,35.5,150]
[null,36,150,null,36,150]
[null,36.5,150,null,36.5,150]
[null,37,150,null,37,150]
[null,37.5,150,null,37.5,150]
[null,38,150,null,38,150]
[null,38.5,150,null,38.5,150]
[null,39,150,null,39,150]
[null,39.5,150,null,39.5,150]
[null,40,150,null,40,150]
[null,40.5,150,null,40.5,150]
[null,41,150,null,41,150]
[null,41.5,150,null,41.5,150]
[null,42,150,null,42,150]
[null,42.5,150,null,42.5,150]
[null,43,150,null,43,150]
[null,43.5,150,null,43.5,150]
[null,44,150,null,44,150]
[null,44.5,150,null,44.5,150]
[null,45,150,null,45,150]
[null,45.5,150,null,45.5,150]
[null,46,150,null,46,150]
[null,46.5,150,null,46.5,150]
[null,47,150,null,47,150]
[null,47.5,150,null,47.5,150]
[null,48,150,null,48,150]
[null,48.5,150,null,48.5,150]
[null,49,150,null,49,150]
[null,49.5,150,null,49.5,150]
[null,50,150,null,50,150]
[null,50.5,150.5,null,50.5,150.01946428571426]
[null,51,151,null,51,150.07714285714286]
[null,51.5,151.5,null,51.5,150.17196428571432]
[null,52,152,null,52,150.30285714285714]
[null,52.5,152.5,null,52.5,150.46875]
[null,53,153,null,53,150.66857142857143]
[null,53.5,153.5,null,53.5,150.90124999999995]
[null,54,154,null,54,151.1657142857143]
[null,54.5,154.5,null,54.5,151.46089285714288]
[null,55,155,null,55,151.78571428571433]
[null,55.5,155.5,null,55.5,152.139107142857]
[null,56,156,null,56,152.51999999999992]
[null,56.5,156.5,null,56.5,152.92732142857147]
[null,57,157,null,57,153.35999999999984]
[null,57.5,157.5,null,57.5,153.81696428571416]
[null,58,158,null,58,154.29714285714283]
[null,58.5,158.5,null,58.5,154.79946428571441]
[null,59,159,null,59,155.32285714285706]
[null,59.5,159.5,null,59.5,155.86624999999998]
[null,60,160,null,60,156.42857142857144]
[null,60.5,160.5,null,60.5,157.00874999999979]
[null,61,161,null,61,157.60571428571427]
[null,61.5,161.5,null,61.5,158.21839285714287]
[null,62,162,null,62,158.84571428571428]
[null,62.5,162.5,null,62.5,159.48660714285705]
[null,63,163,null,63,160.14000000000016]
[null,63.5,163.5,null,63.5,160.8048214285713]
[null,64,{"$f":"interpolate(B144,$C$2:$C$8,$B$2:$B$8)","v":164},null,64,{"$f":"SplineInterpolation(E144,$C$2:$C$8,$B$2:$B$8)","v":161.47999999999996}]
[null,64.5,164.5,null,64.5,162.16446428571425]
[null,{"$f":"B145+0.5","v":65},165,null,{"$f":"E145+0.5","v":65},162.85714285714278]
[null,65.5,165.5,null,65.5,163.55696428571423]
[null,66,166,null,66,164.26285714285706]
[null,66.5,166.5,null,66.5,164.97374999999982]
[null,67,167,null,67,165.68857142857132]
[null,67.5,167.5,null,67.5,166.40625000000006]
[null,68,168,null,68,167.1257142857142]
[null,68.5,168.5,null,68.5,167.84589285714281]
[null,69,169,null,69,168.56571428571436]
[null,69.5,169.5,null,69.5,{"$f":"SplineInterpolation(E155,$C$2:$C$8,$B$2:$B$8)","v":169.28410714285707}]
[null,70,170,null,70,{"$f":"SplineInterpolation(E156,$C$2:$C$8,$B$2:$B$8)","v":170.00000000000006}]
[null,70.5,171.25,null,70.5,{"$f":"SplineInterpolation(E157,$C$2:$C$8,$B$2:$B$8)","v":170.72245535714302}]
[null,71,172.5,null,71,{"$f":"SplineInterpolation(E158,$C$2:$C$8,$B$2:$B$8)","v":171.46178571428561}]
[null,71.5,173.75,null,71.5,172.21879464285712]
[null,72,175,null,72,172.99428571428575]
[null,72.5,176.25,null,72.5,173.78906249999994]
[null,73,177.5,null,73,174.60392857142847]
[null,73.5,178.75,null,73.5,175.43968749999999]
[null,74,180,null,74,{"$f":"SplineInterpolation(E164,$C$2:$C$8,$B$2:$B$8)","v":176.29714285714294}]
[null,74.5,181.25,null,74.5,177.17709821428576]
[null,75,182.5,null,75,178.08035714285717]
[null,75.5,183.75,null,75.5,{"$f":"SplineInterpolation(E167,$C$2:$C$8,$B$2:$B$8)","v":179.00772321428576}]
[null,76,185,null,76,179.95999999999987]
[null,76.5,186.25,null,76.5,180.93799107142854]
[null,77,187.5,null,77,181.94250000000011]
[null,77.5,188.75,null,77.5,182.97433035714289]
[null,78,190,null,78,184.03428571428577]
[null,78.5,191.25,null,78.5,185.12316964285719]
[null,79,192.5,null,79,186.24178571428581]
[null,79.5,193.75,null,79.5,187.39093750000018]
[null,80,195,null,80,188.57142857142844]
[null,80.5,196.25,null,80.5,189.78406250000012]
[null,81,197.5,null,81,191.02964285714268]
[null,81.5,198.75,null,81.5,192.30897321428563]
[null,82,200,null,82,193.62285714285713]
[null,82.5,201.25,null,82.5,194.97209821428578]
[null,83,202.5,null,83,196.35749999999996]
[null,83.5,203.75,null,83.5,197.7798660714285]
[null,84,205,null,84,199.2399999999999]
[null,84.5,206.25,null,84.5,200.73870535714286]
[null,85,207.5,null,85,202.27678571428555]
[null,85.5,208.75,null,85.5,203.85504464285714]
[null,86,210,null,86,205.47428571428577]
[null,86.5,211.25,null,86.5,207.13531249999983]
[null,87,212.5,null,87,208.8389285714286]
[null,87.5,213.75,null,87.5,210.58593750000011]
[null,88,215,null,88,212.37714285714287]
[null,88.5,216.25,null,88.5,214.21334821428559]
[null,89,217.5,null,89,216.09535714285721]
[null,89.5,218.75,null,89.5,218.02397321428566]
[null,90,220,null,90,220.00000000000364]
[null,90.5,225,null,90.5,222.22125000000233]
[null,91,230,null,91,224.87000000000262]
[null,91.5,235,null,91.5,227.92375000000175]
[null,92,240,null,92,231.36000000000422]
[null,92.5,245,null,92.5,235.15625000000364]
[null,93,250,null,93,239.29000000000451]
[null,93.5,255,null,93.5,243.73875000000407]
[null,94,260,null,94,248.4800000000032]
[null,94.5,265,null,94.5,253.49125000000276]
[null,95,270,null,95,258.75000000000364]
[null,95.5,275,null,95.5,264.23375000000306]
[null,96,{"$f":"interpolate(B208,$C$2:$C$8,$B$2:$B$8)","v":280},null,96,{"$f":"SplineInterpolation(E208,$C$2:$C$8,$B$2:$B$8)","v":269.92000000000553}]
[null,96.5,285,null,96.5,275.78625000000466]
[null,{"$f":"B209+0.5","v":97},290,null,{"$f":"E209+0.5","v":97},281.81000000000495]
[null,97.5,295,null,97.5,287.96875000000364]
[null,98,300,null,98,294.24000000000524]
[null,98.5,305,null,98.5,300.60125000000335]
[null,99,310,null,99,307.03000000000611]
[null,99.5,315,null,99.5,313.50375000000349]
[null,100,320,null,100,320.00000000000364]