Feature Request: Perfect Grain Toggle within Finished Faces Subassembly should look at material sizes

Within S!Finished_Faces:

The method for checking weather or not to use perfect grain is slightly flawed. Sometimes we will use 5x8 or 5x10 sheets to nest the doors and drawers because of their sizes. There were occasional failures in this because of the first part of the Perfect_Grain prompt's formula is looking to see if the product width is greater than about 46.85 inches "M2U(1190,G!Accuracy)" ..

It would be much better if it looked at the material's width instead.. so:

Get the width of the sheet stock used:

This should work weather or not you're using Formula Driven Materials:

=INDIRECT("[M]SheetStockLibrary!$AZ$"&MATCH(Door_Material,[M]SheetStockLibrary!$A:$A,FALSE))

If you are using FDM, this is how you get the sheet width (only checking the first sheet size)

=INDIRECT("W!"&SUBSTITUTE(INDIRECT("[M]SheetStockLibrary!$N$"&MATCH(Door_Material,[M]SheetStockLibrary!$A:$A,FALSE))," ","_")&"_Sheet_Width")

S!Perfect_Grain prompt formula:

Old:

=IF(AND(L!Width>M2U(1190,G!Accuracy),Grain_Direction="Length"),0,IF(G!Perfect_Grain=1,IF(AND(Bay_Position>59,Bay_Position<67),IFERROR(VLOOKUP(Drawer_Front_Material,M!MFSH,6,FALSE),0),IFERROR(VLOOKUP(Door_Material,M!MFSH,6,FALSE),0)),0))

New (only looking for the first sheet size in sheet stock):

=IF(AND(L!Width>IFERROR(INDIRECT("[M]SheetStockLibrary!$AZ$"&MATCH(Door_Material,[M]SheetStockLibrary!$A:$A,FALSE)),UCN(48,1190)),Grain_Direction="Length"),0,IF(G!Perfect_Grain=1,IF(AND(Bay_Position>59,Bay_Position<67),IFERROR(VLOOKUP(Drawer_Front_Material,M!MFSH,6,FALSE),0),IFERROR(VLOOKUP(Door_Material,M!MFSH,6,FALSE),0)),0))

New FDM only (checking for two sheet sizes):

=IF(AND(L!Width>OR(INDIRECT("W!"&SUBSTITUTE(INDIRECT("[M]SheetStockLibrary!$N$"&MATCH(Door_Material,[M]SheetStockLibrary!$A:$A,FALSE))," ","_")&"_Sheet_Width"),IFERROR(L!Width>INDIRECT("W!"&SUBSTITUTE(INDIRECT("[M]SheetStockLibrary!$N$"&MATCH(Door_Material,[M]SheetStockLibrary!$A:$A,FALSE))," ","_")&"_Sheet_Width_2"),UCN(120,3000))),Grain_Direction="Length"),0,IF(G!Perfect_Grain=1,IF(AND(Bay_Position>59,Bay_Position<67),IFERROR(VLOOKUP(Drawer_Front_Material,M!MFSH,6,FALSE),0),IFERROR(VLOOKUP(Door_Material,M!MFSH,6,FALSE),0)),0))

Tested and working with Library 26.0112 and 26.0527 so far.