Spreadsheet: 137177d1326989039-excel-2007-slope-determination-and-translation-along-horizontal-axis-test_14-knife-edge-_02_jpr73
Sheet: Data

 |  | Bending Moment (Nm) | Angle (degrees) |  |  |  | Slope determination and translation along horizontal axis
 |  | 0.0002323718400003039 | 0
 |  | 9.959807999987388e-05 | 0.007568848824027549
 |  | 0.0003596755200000072 | 0.008650535823751818
 |  | 0.0006188294400002108 | 0.008650535823751818
 |  | 0.001651324800000444 | 0.01088022011704402
 |  | 0.001524518400000455 | 0.01300984685295684
 |  | 0.001910976000000362 | 0.01520578386376303
 |  | 0.001910976000000362 | 0.02064322919768535
 |  | 0.001778202239999932 | 0.0228367978002624
 |  | 0.0002323718400003039 | 0.01300984685295684
 |  | 0.0007456358400002005 | 0.0228367978002624
 |  | 0.001005287040000118 | 0.01956154230944394
 |  | 0.001132093440000108 | 0.01848163157623623
 |  | 0.001132093440000108 | 0.01415606795625457
 |  | 0.001132093440000108 | 0.01088022011704402
 |  | 0.001132093440000108 | 0.02608067415976764
 |  | 0.001524518400000455 | 0.01628391846541426
 |  | 0.001778202239999932 | 0.01520578386376303
 |  | 0.001778202239999932 | 0.02172491607121157
 |  | 0.001778202239999932 | 0.01848163157623623
 |  | 0.002038279680000065 | 0.02172491607121157
 |  | 0.002038279680000065 | 0.01736560539353622
 |  | 0.002038279680000065 | 0.02827424258461982
 |  | 0 | 0.0006181068693588333
 |  | 0.0002596511999999173 | 0.002783257079219754
 |  | 0.0007665926399999472 | 0.007015276109933449
 |  | 0.0001268774400001333 | 0.01041486381191095
 |  | 0.0008997926399999473 | 0.002657741125182275
 |  | 0.0005133350400000404 | 0.0004943670842194154
 |  | 0.0007665926399999472 | 0.002783257079219754
 |  | 0.0005133350400000404 | 0.005935365271497904
 |  | 0.0005133350400000404 | 0.001699793890317623
 |  | 0.0005133350400000404 | 0.00373765197405072
 |  | 0.0002596511999999173 | 0.002657741125182275
 |  | 0.0005133350400000404 | 0.009175097771087725
 |  | 0.00063971520000046 | 0.008093410774257537
 |  | 0.0005133350400000404 | 0.003864944096973467
 |  | 0.0005133350400000404 | 0.004819338989413616
 |  | 0.0005133350400000404 | 0.09097234789722133
 |  | 0.001026670080000081 | 0.170449571078338
 |  | 0.0007665926399999472 | 0.2728269945805433
 |  | 0.001159372800000367 | 0.3806973122096353
 |  | 0.0008997926399999473 | 0.5170021692003023
 |  | 0.001286250239999854 | 0.6523119765545158
 |  | 0.0007665926399999472 | 0.8018613795453817
 |  | 0.0007665926399999472 | 0.9446907348945452
 |  | 0.001159372800000367 | 1.118856174764376
 |  | 0.001159372800000367 | 1.290932752612702 |  | Slope | Intercept
 |  | 0.01895325888000042 | 1.543806444970824
 |  | 0.04369109184000043 | 1.708515105875785 |  | y | x | Offset x | x1
 |  | 0.06042292991999992 | 1.883135528276249 |  | 0 |  | 2
 |  | 0.07444906752000034 | 2.073190812465167 |  | 1.2 |  | 2
 |  | 0.08962228800000017 | 2.264439478767449
 |  | 0.1185265459199999 | 2.5815860191354
 |  | 0.1431671251200002 | 2.958249615282376
 |  | 0.16701745536 | 3.210289997747186
 |  | 0.1903244716800004 | 3.42212440630078
 |  | 0.2133291417599998 | 3.611086531113271
 |  | 0.2319505017600002 | 3.824226639073643
 |  | 0.2520990796800001 | 4.157781725223336
 |  | 0.27005614464 | 4.389734951490619
 |  | 0.2886352358400002 | 4.575819386314481
 |  | 0.3058011993600004 | 4.756597035317126
 |  | 0.3226893964800002 | 4.963857924216806
 |  | 0.3394453171199999 | 5.130796689682925
 |  | 0.3570822758400005 | 5.362188920959908
 |  | 0.3738136166400002 | 5.617662017691826
 |  | 0.3900257971200005 | 5.809835942429726
 |  | 0.4075295558400003 | 6.003199861619312
 |  | 0.4249374105600001 | 6.245708171893911
 |  | 0.4414391500799999 | 6.459358222237642
 |  | 0.4595954112000004 | 6.676999951087809
 |  | 0.47735974464 | 6.912095178512063
 |  | 0.4968862963200003 | 7.153718204440927
 |  | 0.5150002176000004 | 7.388832875944493 |  |  | Intersect row
 |  | 0.5337425587199999 | 7.609823373778367
 |  | 0.5524661452800003 | 7.853652823854276 |  | x | Curve | Line
 |  | 0.57079744896 | 8.109445167985465 | A
 |  | 0.5892437664000004 | 8.47398808356629 | B
 |  | 0.61085356608 | 8.719723528994756
 |  | 0.6261781728000003 | 8.981245124976393 |  | Gradient
 |  | 0.6418592582400002 | 9.240917985475422 |  | Intercept
 |  | 0.6585479040000001 | 9.508248223956413
 |  | 0.6837567321599999 | 9.821401278771148 |  |  | Intercept
 |  | 0.70334423616 | 10.0944121261769 |  | y |  |  | 0
 |  | 0.7243079270400004 | 10.34074665266241 |  | x |  |  |  |  | 0
 |  | 0.74386545216 | 10.56079483801835
 |  | 0.7612546944000002 | 10.79969566748416
 |  | 0.7778650540800001 | 11.02203927196502
 |  | 0.7959853689600002 | 11.25950391339377 |  | y line | Curve-Line | Intercept
 |  | 0.8124448396800005 | 11.49108515307402
 |  | 0.82763035008 | 11.67862406571137
 |  | 0.8410408550400001 | 11.90543219951208
 |  | 0.8559008601600002 | 12.10693867108579
 |  | 0.8699874528000002 | 12.31477854849097
 |  | 0.8816525760000002 | 12.48152947992083
 |  | 0.8917963776 | 12.66176624530219
 |  | 0.9011736576 | 12.81720548498145
 |  | 0.9125737305600002 | 12.98383416741033
 |  | 0.92219787456 | 13.16652405147005
 |  | 0.9311823744 | 13.34495436960466
 |  | 0.9411811123200003 | 13.53611992913098
 |  | 0.9520560576 | 13.73660184547988
 |  | 0.9614147251200003 | 13.94808412790747
 |  | 0.9710211091200003 | 14.1356810654143
 |  | 0.97998784896 | 14.35011998446413
 |  | 0.99008938176 | 14.57169326217213
 |  | 0.9995571667200003 | 14.82493501771143
 |  | 1.00750910016 | 15.04680530898405
 |  | 1.04196158208 | 16.52552961220863
 |  | 1.04700002304 | 16.76313175052417
 |  | 1.05015171264 | 16.96897639377854
 |  | 1.0517912448 | 17.25605213831028
 |  | 1.0519148544 | 17.45939942084434
 |  | 1.05392898048 | 17.65475207308191
 |  | 1.055066544 | 17.86421987087257
 |  | 1.05600860544 | 18.05279845819498
 |  | 1.055501664 | 18.26106400861443
 |  | 1.05739715328 | 18.45182600331494
 |  | 1.05663645696 | 18.63019672381884
 |  | 1.05651284736 | 18.8080118551966
 |  | 1.055881728 | 18.98094926509683
 |  | 1.05481286016 | 19.15079106365979
 |  | 1.055881728 | 19.31844114552763
 |  | 1.055881728 | 19.49502766913499
 |  | 1.0557549216 | 19.64464406454965
 |  | 1.0546832832 | 19.80057101538315
 |  | 1.05600860544 | 19.9611873092842
 |  | 1.05493696704 | 20.11461638592996
 |  | 1.05418223808 | 20.28071302210929
 |  | 1.05443549568 | 20.44777485796912
 |  | 1.05455960256 | 20.6405291047622
 |  | 1.05512429952 | 20.82620906321251
 |  | 1.05266958336 | 21.02755119408144
 |  | 1.05342750912 | 21.23391421451959
 |  | 1.0519148544 | 21.42953995365054
 |  | 1.0498980288 | 21.66304616168407
 |  | 1.04788482624 | 21.8781183337385
 |  | 1.04725377792 | 22.09595033230814
 |  | 1.04599210752 | 22.30502096757762
 |  | 1.04612168448 | 22.51987856101131
 |  | 1.04574382272 | 22.71541807456557
 |  | 1.04725377792 | 22.97728381279279
 |  | 1.04826219072 | 23.16518359183719
 |  | 1.04952109056 | 23.37237111013449
 |  | 1.04927017728 | 23.57197030036895
 |  | 1.0486395552 | 23.76817112206984
 |  | 1.04914692288 | 23.94996739243307
 |  | 1.04826219072 | 24.14654092739872
 |  | 1.04750746176 | 24.32495622749013
 |  | 1.04612168448 | 24.5035751423885
 |  | 1.04511639744 | 24.66409914413583
 |  | 1.04322367872 | 24.83205713071454
 |  | 1.04372472384 | 24.99044252507911
 |  | 1.04309999808 | 25.26788127941917
 |  | 1.04107997568 | 25.39470074583105
 |  | 1.03969462464 | 25.50633200241129
 |  | 1.03919315328 | 25.64853640686139
 |  | 1.03654293504 | 25.78851300353632
 |  | 1.03541041536 | 25.92101830462
 |  | 1.0346556864 | 26.06340104173473
 |  | 1.03213504512 | 26.19555770435624
 |  | 1.03036920384 | 26.3495827042965
 |  | 1.02973765824 | 26.496538137748
 |  | 1.02835188096 | 26.66423427009525
 |  | 1.02633278208 | 26.82305556497203
 |  | 1.02343435008 | 26.99902367638373
 |  | 1.02343435008 | 27.16777970508653
 |  | 1.02104058624 | 27.35965190939868
 |  | 1.01927424768 | 27.53422831383974
 |  | 1.01586930048 | 27.71887046934878
 |  | 1.01258760768 | 27.94820938930492
 |  | 1.00981285632 | 28.0988800104273
 |  | 1.00741632192 | 28.24486522247725
 |  | 1.00552317696 | 28.54660784351754
 |  | 1.00148398464 | 28.72091178728916
 |  | 1.00047599808 | 28.88312893747375
 |  | 0.9988333401600001 | 29.05752146780321
 |  | 0.99745075968 | 29.23774418677758
 |  | 0.9959294380800001 | 29.40173716112234
 |  | 0.9928982323200004 | 29.56655041459547
 |  | 0.9905008454400002 | 29.7264263105656
 |  | 0.9883576396800005 | 29.88389390986369
 |  | 0.9860874854400004 | 30.02711784352444
 |  | 0.98368420224 | 30.18182236572842
 |  | 0.9812872415999998 | 30.31765768761307
 |  | 0.9805266163200004 | 30.46370482956656
 |  | 0.9781296556800004 | 30.59935759631228
 |  | 0.9758531788799999 | 30.73377381082796
 |  | 0.9718081612800002 | 30.87975654095498
 |  | 0.97003905216 | 31.00241680859645
 |  | 0.9686500780800003 | 31.13749726445423
 |  | 0.9657402796800001 | 31.25445756171608
 |  | 0.9643513055999998 | 31.39019196932155
 |  | 0.9630892089600003 | 31.51763146757309
 |  | 0.9620807961600004 | 31.66632211237635
 |  | 0.9592973779199998 | 31.81322020605502
 |  | 0.9570213273600001 | 31.9651988131638
 |  | 0.95550554688 | 32.12456560752488
 |  | 0.9518410195200004 | 32.28274674330603
 |  | 0.9484233561600002 | 32.44998780687861
 |  | 0.9448852089600004 | 32.6593565301821
 |  | 0.9408396940800003 | 32.83373217384618
 |  | 0.9370419667200002 | 32.99737134386084
 |  | 0.9329904844800004 | 33.15180247403902
 |  | 0.9275446291200005 | 33.31510582506704
 |  | 0.92438661696 | 33.4679135645579
 |  | 0.9186870067200005 | 33.63490258528584
 |  | 0.9160300396800005 | 33.78356493674263
 |  | 0.9133675315200003 | 33.94226134943245
 |  | 0.9102036230400002 | 34.09957584317788
 |  | 0.9057661804800002 | 34.24722162289582
 |  | 0.9019679558400003 | 34.40297411182102
 |  | 0.8972768294400002 | 34.54483282063247
 |  | 0.8938591660799999 | 34.69451691613943
 |  | 0.88892025216 | 34.82806140403173
 |  | 0.8846032934400001 | 34.95950399649954
 |  | 0.88232731392 | 35.09058376462133
 |  | 0.8787768767999999 | 35.21772714617376
 |  | 0.8759811686400002 | 35.34623740653288
 |  | 0.8724312287999999 | 35.46898076685513
 |  | 0.86748592128 | 35.60139278745314
 |  | 0.8650712716800004 | 35.71857305731892
 |  | 0.8620277760000002 | 35.83837935119015
 |  | 0.8589788812800004 | 35.94883999967694
 |  | 0.8563164441600003 | 36.06414654885558
 |  | 0.8549151801600003 | 36.1922149292879
 |  | 0.8514920467200001 | 36.31847014927579
 |  | 0.8488232159999999 | 36.44204527825531
 |  | 0.8462875852799999 | 36.57816770783343
 |  | 0.8410826976000002 | 36.76811689122953
 |  | 0.83778011904 | 36.90191128476219
 |  | 0.8337104505600003 | 37.05540601579764
 |  | 0.8280408902400002 | 37.20775385619702
 |  | 0.8237421177600003 | 37.36691053103472
 |  | 0.8184285388800003 | 37.52016123885677
 |  | 0.8105794003200004 | 37.66441981652714
 |  | 0.8047529836800001 | 37.81412406416708
 |  | 0.8009552563200001 | 37.95490524496841
 |  | 0.7932265305600003 | 38.10452463142473
 |  | 0.7884144230400002 | 38.23746689374224
 |  | 0.7829685676800002 | 38.3784393742395
 |  | 0.7813200134400002 | 38.52465937888613
 |  | 0.7803061305600002 | 38.66457657581424
 |  | 0.7786570790400005 | 38.80603700177745
 |  | 0.7786570790400005 | 38.93561187592555
 |  | 0.7888700025600003 | 39.74370435989867
 |  | 0.7893769440000005 | 39.86333025075105
 |  | 0.7889968799999998 | 39.97943929128274
 |  | 0.78861589248 | 40.09176130006809
 |  | 0.78925056384 | 40.20795384241404
 |  | 0.7891232601600002 | 40.31413666639324
 |  | 0.78861589248 | 40.42725381287604
 |  | 0.7883626348800001 | 40.5376415822261
 |  | 0.7893769440000005 | 40.65926284908421
 |  | 0.7874747059200002 | 40.77222192045963
 |  | 0.7883626348800001 | 40.90081582067037
 |  | 0.7869681907200006 | 41.02457200606952
 |  | 0.78861589248 | 41.15766382406322
 |  | 0.7876015123200003 | 41.32948175504198
 |  | 0.7878556934400002 | 41.50315484693913
 |  | 0.7867145068800003 | 41.64073090252113
 |  | 0.7845585139199999 | 41.78548690038077
 |  | 0.7849449715199999 | 41.91897572173501
 |  | 0.7821492633600002 | 42.06207760384775
 |  | 0.7816482892800001 | 42.19134167102843
 |  | 0.7834237209600002 | 42.32687606097333
 |  | 0.7822825344000004 | 42.45066293851401
 |  | 0.7788589747199999 | 42.54027812929754
 |  | 0.7736599833600004 | 42.56944471822737
 |  | 0.7693489209600003 | 42.57077249557256
 |  | 0.7657980576 | 42.57670489854625
 |  | 0.7640230521600001 | 42.57472209827746
 |  | 0.76085275008 | 42.57739512488239
 |  | 0.7602130348800002 | 42.57273788759856
 |  | 0.7597119897600004 | 42.57406552474029
 |  | 0.75793066176 | 42.57406552474029
 |  | 0.7574232940800004 | 42.57142689079284
 |  | 0.7569163526400002 | 42.57472209827746
 |  | 0.75577516608 | 42.57208255662825
 |  | 0.7555214822400005 | 42.57868853578776
 |  | 0.7548876633600002 | 42.57142689079284
 |  | 0.7543802956800001 | 42.57739512488239
 |  | 0.7537464767999998 | 42.57604932989687
 |  | 0.7531122316800001 | 42.57604932989687
 |  | 0.7527316703999999 | 42.57406552474029
 |  | 0.7524784127999999 | 42.57670489854625
 |  | 0.7514641036800003 | 42.57273788759856
 |  | 0.7517173612800003 | 42.57472209827746
 |  | 0.7507029811199998 | 42.57406552474029
 |  | 0.7501960396800005 | 42.57208255662825
 |  | 0.75044979456 | 42.57539374746387
 |  | 0.7501960396800005 | 42.57406552474029
 |  | 0.7487952729600003 | 42.57739512488239
 |  | 0.7487952729600003 | 42.57340990059716
 |  | 0.7494290918400004 | 42.5780506652364
 |  | 0.7486738656000002 | 42.57670489854625
 |  | 0.746259216 | 42.57142689079284
 |  | 0.7500687360000001 | 42.57539374746387
 |  | 0.7474004025600004 | 42.57472209827746
 |  | 0.7465124735999998 | 42.58003196982715
 |  | 0.7494290918400004 | 42.57539374746387
 |  | 0.746259216 | 42.57604932989687
 |  | 0.7471467187200003 | 42.5780506652364
 |  | 0.7475267827200002 | 42.57604932989687
 |  | 0.7472735251200002 | 42.5780506652364
 |  | 0.74676615744 | 42.57077249557256
 |  | 0.7457517772800002 | 42.57739512488239
 |  | 0.7466392799999999 | 42.57604932989687
 |  | 0.7457517772800002 | 42.57739512488239
 |  | 0.7457517772800002 | 42.57208255662825
 |  | 0.7460055321599999 | 42.57604932989687
 |  | 0.7444778880000001 | 42.57670489854625
 |  | 0.746259216 | 42.57604932989687
 |  | 0.744991152 | 42.57604932989687
 |  | 0.7458790809599999 | 42.57077249557256
 |  | 0.7452444095999999 | 42.57406552474029
 |  | 0.7444778880000001 | 42.5780506652364
 |  | 0.74473107456 | 42.57937775517736
 |  | 0.7439768428800004 | 42.57273788759856
 |  | 0.7448643456 | 42.57077249557256
 |  | 0.7444778880000001 | 42.57208255662825
 |  | 0.7433367014400004 | 42.57273788759856
 |  | 0.7444778880000001 | 42.57868853578776
 |  | 0.7439768428800004 | 42.57604932989687