Spreadsheet: 287538d1388851254-intersecting-value-of-graph-graph-intersection-value
Sheet: Sheet1

TRACTIVE EFFORT ( N ) |  |  |  |  |  |  |  |  | VEHICLE SPEED ( KMPH )
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
86723.05397552649 | 60154.32573479175 | 42782.46496200364 | 31609.97411205365 | 23707.48058404024 | 17303.7358285811 | 12330.61490146921 | 9128.742523739631 | 6812.494420701216 | 2.673159887248056 | 3.853830732125453 | 5.418682382908877 | 7.333906328592188 | 9.77854177145625 | 13.39737219081407 | 18.80073224567279 | 25.39501892885653 | 34.02932536466775
87481.23192591214 | 60680.22607272616 | 43156.49147641227 | 31886.32491250843 | 23914.74368438132 | 17455.01406848522 | 12438.41553699143 | 9208.550729043382 | 6872.052782868194 | 2.940475875972861 | 4.239213805337998 | 5.960550621199764 | 8.067296961451406 | 10.75639594860188 | 14.73710940989548 | 20.68080547024007 | 27.93452082174218 | 37.43225790113452
83330.64405533158 | 57801.22443115301 | 41108.91159995933 | 30373.46334774065 | 22780.09751080548 | 16626.85278087527 | 11848.26910763159 | 8771.64674266648 | 6546.005031840657 | 3.207791864697667 | 4.624596878550544 | 6.502418859490652 | 8.800687594310624 | 11.7342501257475 | 16.07684662897689 | 22.56087869480735 | 30.47402271462783 | 40.8351904376013
80590.7075337116 | 55900.70286902381 | 39757.23828057414 | 29374.77478055159 | 22031.08108541369 | 16080.15688418126 | 11458.69447258586 | 8483.232371969641 | 6330.770426843015 | 3.34144985906007 | 4.817288415156817 | 6.773352978636096 | 9.167382910740235 | 12.22317721432031 | 16.74671523851759 | 23.50091530709099 | 31.74377366107066 | 42.53665670583469
78783.43845762569 | 54647.11402834523 | 38865.67113227725 | 28716.03726970803 | 21537.02795228102 | 15719.55488471086 | 11201.73005564042 | 8292.993521855336 | 6188.801135712938 | 3.475107853422472 | 5.009979951763089 | 7.044287097781539 | 9.534078227169843 | 12.71210430289312 | 17.41658384805829 | 24.44095191937462 | 33.01352460751349 | 44.23812297406807
73623.10140762679 | 51067.71291668064 | 36319.9589033697 | 26835.12887127952 | 20126.34665345964 | 14689.91968384698 | 10468.01363297757 | 7749.800148171241 | 5783.432946396449 | 3.742423842147277 | 5.395363024975635 | 7.586155336072427 | 10.26746886002906 | 13.68995848003875 | 18.7563210671397 | 26.3210251439419 | 35.55302650039913 | 47.64105551053484
69793.07321540231 | 48411.06335365298 | 34430.51844404765 | 25439.10916885049 | 19079.33187663787 | 13925.71924329316 | 9923.445602504178 | 7346.639285831822 | 5482.566631217779 | 4.009739830872084 | 5.78074609818818 | 8.128023574363315 | 11.00085949288828 | 14.66781265718438 | 20.09605828622111 | 28.20109836850918 | 38.09252839328479 | 51.04398804700163
64629.75871379417 | 44829.59697115495 | 31883.33737019854 | 23557.11550919127 | 17667.83663189345 | 12895.48995546246 | 9189.305834404353 | 6803.13249618886 | 5076.964549394671 | 4.277055819596889 | 6.166129171400724 | 8.669891812654202 | 11.7342501257475 | 15.64566683433 | 21.43579550530252 | 30.08117159307646 | 40.63203028617044 | 54.44692058346839
61201.85619951975 | 42451.87668827646 | 30192.27470015586 | 22307.66793132534 | 16730.75094849401 | 12211.52511757896 | 8701.91356803855 | 6442.300652581026 | 4807.687054164945 | 4.544371808321694 | 6.551512244613271 | 9.21176005094509 | 12.46764075860672 | 16.62352101147562 | 22.77553272438393 | 31.96124481764374 | 43.1715321790561 | 57.84985311993517
56474.97530251794 | 39173.13683591777 | 27860.39630006383 | 20584.75140641659 | 15438.56355481244 | 11268.37684747805 | 8029.827596037506 | 5944.734242370308 | 4436.368837589783 | 4.8116877970465 | 6.936895317825816 | 9.753628289235978 | 13.20103139146594 | 17.60137518862125 | 24.11526994346533 | 33.84131804221102 | 45.71103407194175 | 61.25278565640195
52506.10439087073 | 36420.18081472023 | 25902.46155339106 | 19138.12445983033 | 14353.59334487275 | 10476.47330344161 | 7465.518377649333 | 5526.958356933761 | 4124.595788756537 | 5.079003785771305 | 7.322278391038361 | 10.29549652752686 | 13.93442202432515 | 18.57922936576687 | 25.45500716254674 | 35.7213912667783 | 48.2505359648274 | 64.65571819286872
49055.87450805111 | 34026.97344116979 | 24200.38428205506 | 17880.53870521265 | 13410.4040289095 | 9788.053515353482 | 6974.951520783387 | 5163.776264005381 | 3853.564376123418 | 5.346319774496111 | 7.707661464250907 | 10.83736476581775 | 14.66781265718438 | 19.5570835429125 | 26.79474438162815 | 37.60146449134558 | 50.79003785771306 | 68.0586507293355
45950.48582012886 | 31872.96070634232 | 22668.42505502036 | 16748.64526358192 | 12561.48394768644 | 9168.439433081483 | 6533.41550152657 | 4836.89324422409 | 3609.621824047828 | 5.613635763220916 | 8.09304453746345 | 11.37923300410864 | 15.40120329004359 | 20.53493772005812 | 28.13448160070955 | 39.48153771591286 | 53.32953975059871 | 71.46158326580226
42597.07447970875 | 29546.91026361573 | 21014.1105838626 | 15526.34922119784 | 11644.76191589839 | 8499.337720224683 | 6056.614674648299 | 4483.902576811448 | 3346.195952844364 | 5.880951751945722 | 8.478427610675997 | 11.92110124239953 | 16.13459392290281 | 21.51279189720375 | 29.47421881979096 | 41.36161094048013 | 55.86904164348437 | 74.86451580226904
Total Resistance (0.00% )
2687.693998784769 | 2689.544583336026 | 2693.029061388603 | 2698.894291035054 | 2708.940295173429 | 2729.080886023357 | 2770.860201235705 | 2840.846890325403 | 2964.060579468293
2688.05435852957 | 2690.293565836592 | 2694.50978428021 | 2701.606712152415 | 2713.762377159849 | 2738.132492088263 | 2788.685463495203 | 2873.369357293737 | 3022.457921156635
2688.449038250068 | 2691.113880003878 | 2696.131528399589 | 2704.577459090478 | 2719.043705049738 | 2748.046155873635 | 2808.208369779415 | 2908.98920206858 | 3086.416914434342
2688.659248101202 | 2691.550786462541 | 2696.995283419693 | 2706.159704742272 | 2721.856586208483 | 2753.326259411496 | 2818.606439430789 | 2927.960641133442 | 3120.482030419208
2688.87803794626 | 2692.005525837884 | 2697.89429374674 | 2707.806531849241 | 2724.784278843095 | 2758.821877379474 | 2829.428920088341 | 2947.706424649931 | 3155.937559301416
2689.341357618147 | 2692.968503338611 | 2699.798080321662 | 2711.293930428706 | 2730.984098539921 | 2770.459656605781 | 2852.347114421982 | 2989.52102503779 | 3231.019855757855
2689.838997265731 | 2694.002812506059 | 2701.842888124358 | 2715.039654828871 | 2737.643164140215 | 2782.959493552554 | 2876.962952780336 | 3034.433003232156 | 3311.66380380366
2690.370956889009 | 2695.108453340227 | 2704.028717154824 | 2719.043705049738 | 2744.761475643978 | 2796.321388219795 | 2903.276435163405 | 3082.442359233031 | 3397.869403438831
2690.937236487982 | 2696.285425841116 | 2706.355567413063 | 2723.306081091305 | 2752.33903305121 | 2810.545340607503 | 2931.287561571188 | 3133.549093040414 | 3489.636654663368
2691.537836062651 | 2697.533730008725 | 2708.823438899075 | 2727.826782953574 | 2760.375836361909 | 2825.631350715678 | 2960.996332003685 | 3187.753204654305 | 3586.965557477271
2692.172755613016 | 2698.853365843055 | 2711.432331612858 | 2732.605810636544 | 2768.871885576079 | 2841.579418544321 | 2992.402746460895 | 3245.054694074704 | 3689.856111880539
2692.841995139076 | 2700.244333344105 | 2714.182245554413 | 2737.643164140215 | 2777.827180693715 | 2858.38954409343 | 3025.50680494282 | 3305.453561301611 | 3798.308317873173
2693.545554640832 | 2701.706632511876 | 2717.073180723741 | 2742.938843464587 | 2787.241721714821 | 2876.061727363006 | 3060.308507449459 | 3368.949806335026 | 3912.322175455172
2694.283434118282 | 2703.240263346367 | 2720.10513712084 | 2748.49284860966 | 2797.115508639396 | 2894.59596835305 | 3096.807853980812 | 3435.54342917495 | 4031.897684626539