Apr 07 2018
07:59 AM
- last edited on
Jul 25 2018
11:36 AM
by
TechCommunityAP
Apr 07 2018
07:59 AM
- last edited on
Jul 25 2018
11:36 AM
by
TechCommunityAP
Hello,
I have been trying to figure out this one for a few hours and I cannot find the solution myself. What I would like to have in my file is that in collum G(plan hours) is shown how much hours it takes to produce something.
The time it takes to produce something is bases on collum E, F and I from tab Test. The tab Base routings should work as a database for collums E, F and I. So depending on which machine is entered and material you get a (plan hours) based on collum C from the tab base items.
I hope I explained it well enough
Apr 07 2018 08:18 AM
Apr 07 2018 08:25 AM
Okay I have entered it manually. Like this?
Apr 07 2018 08:34 AM
SolutionRamon,
my guess would be:
=F2*LOOKUP(PI(),1/('Base routings'!$B$3:$B$332=E2)/('Base routings'!$A$3:$A$332=I2),'Base routings'!$C$3:$C$332)/60/60
Apr 07 2018 08:34 AM
SolutionRamon,
my guess would be:
=F2*LOOKUP(PI(),1/('Base routings'!$B$3:$B$332=E2)/('Base routings'!$A$3:$A$332=I2),'Base routings'!$C$3:$C$332)/60/60