Help with Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2444002%22%20slang%3D%22en-US%22%3EHelp%20with%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2444002%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EAttached%20is%20a%20sample%20of%20a%20spreadsheet%20I%20have%20been%20working%20on.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI'm%20having%20trouble%20solving%20how%20to%20complete%20the%20%22Machines%20die%20can%20run%20on%22%20column.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EEach%20machine%20on%20the%20Macnines%20tab%20has%20a%20max%20width%20they%20can%20work%20up%20to.%20EG%20the%205100%20can%20go%20to%20a%20maximum%20width%20of%20280%20and%20the%205000%20to%20a%20maximum%20width%20of%20530.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EThen%20listed%20below%20each%20machine%20is%20the%20repeat%20around%20sizes%20each%20machine%20can%20achive%20(this%20is%20an%20exact%20figure).%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EThe%20Dies%20sheet%20is%20a%20list%20of%20all%20Dies%20we%20currently%20have%20(over%205300).%20What%20I%20need%20is%20to%20know%20whch%20machine%20each%20die%20is%20capable%20if%20being%20installed%20onto.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EThe%202%20examples%20that%20I%20have%20competed%20by%20hand%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EFFOLD%2F01449%20has%20a%20repeat%20around%20of%20228.6%20so%20only%20those%20machines%20on%20the%20machines%20tab%20that%20has%20the%20possiblity%20of%20mactching%20the%20repeat%20around%20should%20be%20selected.%20It%20also%20has%20a%20Min%20paper%20width%20of%20117%20therefore%20all%20machines%20tick%20this%20criteria.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EFFOLD%2F00587%20firstly%20the%20total%20minmum%20paper%20width%20is%20322.8%20so%20any%20machine%20that%20has%20a%20max%20width%20below%20this%20shopuld%20not%20be%20selected.%20The%20Repeat%20Around%20of%20406.4%20although%208%20machines%20match%20thi%20criteria%20only%202%20have%20aouth%20width%20to%20match%20te%20322.8%20width.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2444002%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2467143%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2467143%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1078272%22%20target%3D%22_blank%22%3E%40TClifton%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20table%20below%20need%20to%20be%20normalized%20and%20therefore%20some%20clarifications%20need%20to%20be%20made.%3C%2FP%3E%3CP%3E%3CU%3E%3CSTRONG%3EClarification%3C%2FSTRONG%3E%3C%2FU%3E%20what%20do%20the%20highlighted%20numbers%20represent%2C%20Machine%20Width%3F%20or%20Minimum%20Width%3F%3C%2FP%3E%3CP%3EI%20understand%20the%20numbers%20across%20are%20the%20Maximum%20Width%20for%20each%20machine.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Yea_So_0-1624304899330.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F290358i029CEC7EDC67C0A1%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Yea_So_0-1624304899330.png%22%20alt%3D%22Yea_So_0-1624304899330.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Attached is a sample of a spreadsheet I have been working on.

 

I'm having trouble solving how to complete the "Machines die can run on" column.

 

Each machine on the Macnines tab has a max width they can work up to. EG the 5100 can go to a maximum width of 280 and the 5000 to a maximum width of 530.
Then listed below each machine is the repeat around sizes each machine can achive (this is an exact figure).
The Dies sheet is a list of all Dies we currently have (over 5300). What I need is to know whch machine each die is capable if being installed onto.
The 2 examples that I have competed by hand:
FFOLD/01449 has a repeat around of 228.6 so only those machines on the machines tab that has the possiblity of mactching the repeat around should be selected. It also has a Min paper width of 117 therefore all machines tick this criteria.
FFOLD/00587 firstly the total minmum paper width is 322.8 so any machine that has a max width below this shopuld not be selected. The Repeat Around of 406.4 although 8 machines match thi criteria only 2 have aouth width to match te 322.8 width.

1 Reply

Hi @TClifton ,

 

The table below need to be normalized and therefore some clarifications need to be made.

Clarification what do the highlighted numbers represent, Machine Width? or Minimum Width?

I understand the numbers across are the Maximum Width for each machine.

Yea_So_0-1624304899330.png

 

Cheers