spencersoccer
New Member
- Joined
- Mar 16, 2015
- Messages
- 4
Hello all,
I was given the task at work to make an excel document to make a calculation. I've never used excel before but after an hour or so I finished a spreadsheet with a simple multiplication formula. It did not satisfy the boss. So i'm here hoping to achieve what he wants with your help.
I'm given the name of a robot, each robot has 3 different axis's. each axis has a max speed and a max payload. Each speed is broken down into 33%, 66%, and 100% of the max. The payload is broken down the same way. This gives me 3 different speeds for axis one, and nine different possibilities for the payload because payload also depends on speed. I'd upload an example but I can't figure out how with a screenshot.
This data needs to take the select a max speed by rounding up what the user inputs to the nearest percent.
EX: if the user inputs 50mph and the Max speed is 100MPH then the data used would round up to the 66% value.
This table also needs to select the correct max payload number. and then take those two numbers and give me my final answer.
My problem is I have no idea how to make excel round up and select numbers like that or to determine the difference between my three different axis's.
Hopefully that all makes sense, I'll try to upload a picture or figure out how to upload an attachment of my current excel document to help explain it all. Thanks for your help guys.
I was given the task at work to make an excel document to make a calculation. I've never used excel before but after an hour or so I finished a spreadsheet with a simple multiplication formula. It did not satisfy the boss. So i'm here hoping to achieve what he wants with your help.
I'm given the name of a robot, each robot has 3 different axis's. each axis has a max speed and a max payload. Each speed is broken down into 33%, 66%, and 100% of the max. The payload is broken down the same way. This gives me 3 different speeds for axis one, and nine different possibilities for the payload because payload also depends on speed. I'd upload an example but I can't figure out how with a screenshot.
This data needs to take the select a max speed by rounding up what the user inputs to the nearest percent.
EX: if the user inputs 50mph and the Max speed is 100MPH then the data used would round up to the 66% value.
This table also needs to select the correct max payload number. and then take those two numbers and give me my final answer.
My problem is I have no idea how to make excel round up and select numbers like that or to determine the difference between my three different axis's.
Hopefully that all makes sense, I'll try to upload a picture or figure out how to upload an attachment of my current excel document to help explain it all. Thanks for your help guys.
Last edited:
