Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-28-2016, 06:09 AM
RAH RAH is offline Display largest figure within the range Windows 10 Display largest figure within the range Office 2016
Advanced Beginner
Display largest figure within the range
 
Join Date: Jun 2016
Posts: 31
RAH is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 07-16-2016, 05:48 AM
RAH RAH is offline Display largest figure within the range Windows 10 Display largest figure within the range Office 2016
Advanced Beginner
Display largest figure within the range
 
Join Date: Jun 2016
Posts: 31
RAH is on a distinguished road
Default Updated

Spread sheet to go with the post
Attached Files
File Type: xlsm Drifting loads .xlsm (187.0 KB, 12 views)
Reply With Quote
  #3  
Old 07-16-2016, 10:10 AM
c991257 c991257 is offline Display largest figure within the range Windows 10 Display largest figure within the range Office 2016
Advanced Beginner
 
Join Date: Mar 2014
Location: Zambia
Posts: 61
c991257 is on a distinguished road
Default

Have you considered graphing it?


/Møller
Reply With Quote
  #4  
Old 07-16-2016, 11:00 AM
RAH RAH is offline Display largest figure within the range Windows 10 Display largest figure within the range Office 2016
Advanced Beginner
Display largest figure within the range
 
Join Date: Jun 2016
Posts: 31
RAH is on a distinguished road
Default

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
Reply With Quote
  #5  
Old 07-17-2016, 11:53 AM
RAH RAH is offline Display largest figure within the range Windows 10 Display largest figure within the range Office 2016
Advanced Beginner
Display largest figure within the range
 
Join Date: Jun 2016
Posts: 31
RAH is on a distinguished road
Default

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
Reply With Quote
  #6  
Old 07-17-2016, 11:53 PM
c991257 c991257 is offline Display largest figure within the range Windows 10 Display largest figure within the range Office 2016
Advanced Beginner
 
Join Date: Mar 2014
Location: Zambia
Posts: 61
c991257 is on a distinguished road
Default

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
Reply With Quote
  #7  
Old 07-24-2016, 01:01 PM
RAH RAH is offline Display largest figure within the range Windows 10 Display largest figure within the range Office 2016
Advanced Beginner
Display largest figure within the range
 
Join Date: Jun 2016
Posts: 31
RAH is on a distinguished road
Default How to mark solved

Still cant mark as solved must be me
Reply With Quote
  #8  
Old 07-24-2016, 11:35 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now Display largest figure within the range Windows 7 64bit Display largest figure within the range Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Display largest figure within the range 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
Display largest figure within the range 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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:16 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft