Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
dropdown menu ? other ideas?
My company makes tubes. The tubes have different inside diameters,
and wall thicknesses. All of these tubes, start from 1 size tube, then they get drawn down (extruded) into different sizes. For example, if I needed a tube that was .250 inch inside, and .050 wall thickness, I have to go through 5 steps from the original part. To get a tube .125 inch ID and a .050 wall thicknesses, I have to go through 7 steps from the original part. NOW..I can also get from the first tube I mentioned, to the second in 2 steps. I have 84 total tubes combinations when it comes to the final part. They can all come from the original 1 size, or I can get from any size larger tube to any size smaller tube. I want to write a spreadsheet where someone can select the tube they have now, and then the tube they NEED, and it will list the steps needed to get to that point. What is the best way to go about that? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
dropdown menu ? other ideas?
On Sep 2, 8:26*am, Ratedr wrote:
My company makes tubes. *The tubes have different inside diameters, and wall thicknesses. *All of these tubes, start from 1 size tube, then they get drawn down (extruded) into different sizes. *For example, if I needed a tube that was .250 inch inside, and .050 wall thickness, I have to go through 5 steps from the original part. *To get a tube .125 inch ID and a .050 wall thicknesses, I have to go through 7 steps from the original part. *NOW..I can also get from the first tube I mentioned, to the second in 2 steps. *I have 84 total tubes combinations when it comes to the final part. *They can all come from the original 1 size, or I can get from any size larger tube to any size smaller tube. I want to write a spreadsheet where someone can select the tube they have now, and then the tube they NEED, and it will list the steps needed to get to that point. * *What is the best way to go about that? http://www.contextures.com/excelfiles.html#DataVal |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
dropdown menu ? other ideas?
awesome..the only thing is this reads like a different language to me,
I will do all of the work, just asking for suggestions as to which one of these you think would best solve my issue. I will download that one and fill in all of the info, etc On Sep 2, 10:05*am, Don Guillett Excel MVP wrote: On Sep 2, 8:26*am, Ratedr wrote: My company makes tubes. *The tubes have different inside diameters, and wall thicknesses. *All of these tubes, start from 1 size tube, then they get drawn down (extruded) into different sizes. *For example, if I needed a tube that was .250 inch inside, and .050 wall thickness, I have to go through 5 steps from the original part. *To get a tube .125 inch ID and a .050 wall thicknesses, I have to go through 7 steps from the original part. *NOW..I can also get from the first tube I mentioned, to the second in 2 steps. *I have 84 total tubes combinations when it comes to the final part. *They can all come from the original 1 size, or I can get from any size larger tube to any size smaller tube. I want to write a spreadsheet where someone can select the tube they have now, and then the tube they NEED, and it will list the steps needed to get to that point. * *What is the best way to go about that? http://www.contextures.com/excelfiles.html#DataVal |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
dropdown menu ? other ideas?
If you have a free second, please just help me by pointing towards the
right sheet, I will do all of the work, Im not asking for you to do the actual sheet for me, just as someone with the knowledge you have, would like you to help me find which one of those sheets will be best suited for my issue On Sep 2, 10:20*am, Ratedr wrote: awesome..the only thing is this reads like a different language to me, I will do all of the work, just asking for suggestions as to which one of these you think would best solve my issue. *I will download that one and fill in all of the info, etc On Sep 2, 10:05*am, Don Guillett Excel MVP wrote: On Sep 2, 8:26*am, Ratedr wrote: My company makes tubes. *The tubes have different inside diameters, and wall thicknesses. *All of these tubes, start from 1 size tube, then they get drawn down (extruded) into different sizes. *For example, if I needed a tube that was .250 inch inside, and .050 wall thickness, I have to go through 5 steps from the original part. *To get a tube .125 inch ID and a .050 wall thicknesses, I have to go through 7 steps from the original part. *NOW..I can also get from the first tube I mentioned, to the second in 2 steps. *I have 84 total tubes combinations when it comes to the final part. *They can all come from the original 1 size, or I can get from any size larger tube to any size smaller tube. I want to write a spreadsheet where someone can select the tube they have now, and then the tube they NEED, and it will list the steps needed to get to that point. * *What is the best way to go about that? http://www.contextures.com/excelfiles.html#DataVal- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
dropdown menu ? other ideas?
On Sep 2, 12:44*pm, Ratedr wrote:
If you have a free second, please just help me by pointing towards the right sheet, I will do all of the work, Im not asking for you to do the actual sheet for me, just as someone with the knowledge you have, would like you to help me find which one of those sheets will be best suited for my issue On Sep 2, 10:20*am, Ratedr wrote: awesome..the only thing is this reads like a different language to me, I will do all of the work, just asking for suggestions as to which one of these you think would best solve my issue. *I will download that one and fill in all of the info, etc On Sep 2, 10:05*am, Don Guillett Excel MVP wrote: On Sep 2, 8:26*am, Ratedr wrote: My company makes tubes. *The tubes have different inside diameters, and wall thicknesses. *All of these tubes, start from 1 size tube, then they get drawn down (extruded) into different sizes. *For example, if I needed a tube that was .250 inch inside, and .050 wall thickness, I have to go through 5 steps from the original part. *To get a tube .125 inch ID and a .050 wall thicknesses, I have to go through 7 steps from the original part. *NOW..I can also get from the first tube I mentioned, to the second in 2 steps. *I have 84 total tubes combinations when it comes to the final part. *They can all come from the original 1 size, or I can get from any size larger tube to any size smaller tube. I want to write a spreadsheet where someone can select the tube they have now, and then the tube they NEED, and it will list the steps needed to get to that point. * *What is the best way to go about that? http://www.contextures.com/excelfiles.html#DataVal-Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - Please learn to refer to excel files as file or workBOOKS. Sheets are tabs within the workbook. Read her documentation and download several to see which fits your needs. If you need custom work, post back. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
dropdown menu ? other ideas?
On 9/2/2010 6:26 AM, Ratedr wrote:
My company makes tubes. The tubes have different inside diameters, and wall thicknesses. All of these tubes, start from 1 size tube, then they get drawn down (extruded) into different sizes. For example, if I needed a tube that was .250 inch inside, and .050 wall thickness, I have to go through 5 steps from the original part. To get a tube .125 inch ID and a .050 wall thicknesses, I have to go through 7 steps from the original part. NOW..I can also get from the first tube I mentioned, to the second in 2 steps. I have 84 total tubes combinations when it comes to the final part. They can all come from the original 1 size, or I can get from any size larger tube to any size smaller tube. I want to write a spreadsheet where someone can select the tube they have now, and then the tube they NEED, and it will list the steps needed to get to that point. What is the best way to go about that? Can you come up with a set of generalized rules that can be applied to each size transformation (drawing down the tube to a different diameter and thickness) or does each one have to be hard coded? What I mean is can you determine what each step in the process will be based on the current condition (size, wall thickness, etc.) and the target condition, i.e. can you come up with a complete set of logical rules that will apply to every possible starting condition, that will be able to produce every possible ending condition? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
dropdown menu ? other ideas?
On Sep 2, 4:26*pm, Ratedr wrote:
My company makes tubes. *The tubes have different inside diameters, and wall thicknesses. *All of these tubes, start from 1 size tube, then they get drawn down (extruded) into different sizes. *For example, if I needed a tube that was .250 inch inside, and .050 wall thickness, I have to go through 5 steps from the original part. *To get a tube .125 inch ID and a .050 wall thicknesses, I have to go through 7 steps from the original part. *NOW..I can also get from the first tube I mentioned, to the second in 2 steps. *I have 84 total tubes combinations when it comes to the final part. *They can all come from the original 1 size, or I can get from any size larger tube to any size smaller tube. I want to write a spreadsheet where someone can select the tube they have now, and then the tube they NEED, and it will list the steps needed to get to that point. * *What is the best way to go about that? You have not mentioned the height of the tubes. Do they not play any crucial role when converting one product to another? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
select From dropdown and return another dropdown menu | Excel Discussion (Misc queries) | |||
Ideas for a menu | Excel Programming | |||
filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
Create Dropdown menu without using the Validation on the Data Menu | Excel Worksheet Functions | |||
dropdown menu or Jump menu | Excel Discussion (Misc queries) |