What I am trying to do is I create a massive rate calculator. I have different tabs to calculate the rate for different operations i.e. Saw Strips or Saw Pieces, Waterjet etc... What these calculators do is based off certain inputs, generates rates in hours to make a 100 pieces, or Hrs/C Pieces. Each calculator needs inputs which are the same, and can vary from each other.
What I want to do is to create a separate tab which allows you to put in several operations i.e. (Shear Strips, CNC Radius, Saw Parts, Deburr) which would be the necessary operations to manufacture a part. Based on these operation inputs, I want a list of the necessary inputs for those specific calculators to generate in that input tab. What it would need to do is generate all the inputs from those calculators that are dissimilar, and the same; however, remove the duplicate inputs.
Then you can enter those inputs into that new field. Then click a macro button or something which sends the inputs to those specific calculators, and retrieves the output data (setup times and rates) and brings it back to the input tab.
I am trying to think of how to do this, but am unsure of how to start.
It probably helps that the inputs start on the same cell in each calculator, and that the rates start at the same cell on each calculator, but each calculator will have varying amounts of the inputs and end results.
Is this possible? I was thinking of having column A be the inputs for the various operations. Then click a button which generates a userform which has the different inputs (removing possible duplicate inputs), and then using another macro button which sends the data to the calculators. Then just using formulas to return the results.
Bookmarks