Software build:  25.2.227.641

Library build:  26.0112

When I enter a 90" tall cabinet, and it gives me five hinges, and I select a fixed shelf, the middle hinge is centered on the door, intersecting the location of the fixed shelf.  There are conditional statements written into the location formula for vertical dividers based on G!Hinge_At_Division_Control and Hinge_At_Division_Offset.  These parameters seem misplaced in this formula as they relate to vertical dividers rather than horizontal fixed shelves.  For now I'm subtracting 2 inches from that formula to get the results I want, but y'all might want to re-think that.

The formula for the location of the hinge is this (Hinge Location 4):

=ROUND(IF(System_32=1,(ROUND(((Hinge_Location_Top-Hinge_Location_Bottom)/G!Shelf_Hole_Spacing)/(Third_Hinge+Fourth_Hinge+Fifth_Hinge+Sixth_Hinge+Seventh_Hinge+Eighth_Hinge+1),0)*G!Shelf_Hole_Spacing)*2+Hinge_Location_Bottom,IF(Eighth_Hinge=1,(((Hinge_Location_Top-Hinge_Location_Bottom)/7)*2)+Hinge_Location_Bottom,IF(Seventh_Hinge=1,(((Hinge_Location_Top-Hinge_Location_Bottom)/6)*2)+Hinge_Location_Bottom,IF(Sixth_Hinge=1,(((Hinge_Location_Top-Hinge_Location_Bottom)/5)*2)+Hinge_Location_Bottom,IF(Fifth_Hinge=1,(((Hinge_Location_Top-Hinge_Location_Bottom)/4)*2)+Hinge_Location_Bottom,IF(Fourth_Hinge=1,(((Hinge_Location_Top-Hinge_Location_Bottom)/3)*2)+Hinge_Location_Bottom,0)))))),UCN(3,2))+IF(AND(G!Hinge_At_Division_Control="Left Side",IS_Division_Right=1,Bay_Position>29,Bay_Position<60),Hinge_At_Division_Offset,IF(AND(G!Hinge_At_Division_Control="Right Side",IS_Division_Left=1,Bay_Position>0,Bay_Position<29),Hinge_At_Division_Offset,0))