#1
|
|||
|
|||
Display largest figure within the range
I have spread sheet which has a double calculation.
Fall A The calculation is load x distance 2 x length of chain A (2000 kg x 3 MTR x 5.10 MTR) = 30594.117 Then another calculation Height x Distance 3 (5 MTR x4 MTR =20) 30594.117 divided by 20 = 1529.71 kg of tension Fall B The calculation is load x distance 1 x length of chain B (2000 kg x 1 MTR x 5.83 MTR) = 11661.904 Then another calculation Height x Distance 3 (5 MTR x4 MTR =20) 11661.904 divided by 20 = 1529.71 kg of tension The result is correct however to find the maximum tension figure throughout the cycle I would have to enter various lengths heights which would take forever. How would I go about displaying the max tension within the range. |
#2
|
|||
|
|||
Updated
Spread sheet to go with the post
|
#3
|
|||
|
|||
Have you considered graphing it?
/Møller |
#4
|
|||
|
|||
No never thought about it looked at pivot charts etc The input required is not infinite as most spans and heights of floors are uniformed and would never go beyond a max figure But i also have no idea how to create a graph based on four value inputs based on a mathematical equation
|
#5
|
|||
|
|||
Would I be on the right path having a spread sheet with the formulas with all the range of distances loads etc say in small increments across the range then finding the largest figure by a search or by just displaying it all in a graph
|
#6
|
|||
|
|||
Precisely.
It\s pretty much how you learned it in school. Calculate y for a reasonable amount of x values and plot those. Calculating y in excel is of course much faster. /Møller |
#7
|
|||
|
|||
How to mark solved
Still cant mark as solved must be me
|
#8
|
||||
|
||||
Marked solved :-)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Name a Range in a Word Document and then copy that range to the end of the doc w button click | DanNatCorning | Word VBA | 1 | 04-29-2016 10:47 PM |
Is this possible? - Calculate and Display the date range between 2 specific dates | Premier-UK | Excel | 2 | 08-18-2014 05:43 AM |
Caption Order: Figure 4 Figure 3 Figure 2 | golfarchitect13 | Word | 5 | 05-07-2014 07:15 PM |
Convert "Figure", "Figure", "Figure" to "Figure1", "Figure2", etc. | altjx | Word | 4 | 06-04-2013 05:29 AM |
largest string | gsrikanth | Excel | 1 | 05-12-2012 01:53 AM |