Dynamic Filtering Help
Hello-
I need help filtering the difference in settings based on the 9 column headers. I would like to filter differences in adjustments on current setup to adjustments on the next setup, example: I am currently set up for 12oz 4pk and will be switching to 12oz 6pk. Ideally I would see a much more condensed list of adjustments on 12oz 6pk because some of the settings do not change. Is this possible?
Adj #DescriptionReference Point12oz 4pk12oz 6pk12oz 6pk Half Flaps12oz 12pk12oz 24pk16oz 6pk16oz 4pk16oz 24pk19.2oz 12pk1Magazine Drive HeightPosition Indicator2.632.632.6357.251.251.251.252.312Magazine BackstopPosition Indicator4.234.692.994.624.626.055.795.796.133Magazine Drive Belt WidthPosition Indicator5.547.757.091015.627.755.545.5410.384Magazine Picture FrameChange Part12oz 4pk12oz 6pk12oz 6pk Half Flaps12oz 12pk12oz 24pk16oz 6pk16oz 4pk16oz 24pk19.2oz 12pk5Magazine HeightPosition Indicator6.115.766.158.210.2565.6211.647.636Setup HeightPosition Indicator4.814.814.814.814.816.256.256.257.447A-CVacuum Cup WidthScale4 1/2″ 6 9/16″ NA4″ 6 3/4″ 9 5/8″4″ 6 3/4″ 9 5/8″4″ 8″ 12″5 1/2″ 10 1/2″ 15 1/2″4″ 6 3/4″ 9 5/8″4 1/2″ 6 9/16″ N/A5 1/2″ 10 1/2″ 15 1/2″5 1/4″ 8″ 11″8Left Setup GuideScale5 1/4″5 1/8″5 1/8″7 7/8″10 1/2″5 1/8″5 1/4″10 1/2″7 3/4″9Right Setup GuideScale5 1/4″5 1/8″5 1/8″7 7/8″10 1/2″5 1/8″5 1/4″10 1/2″7 3/4″10A-CCase Squaring WidthScale4 7/8″7 3/4″7 3/4″10 1/2″15 5/8″7 3/4″4 1/4″15 5/8″10 3/8″11Tool BarPosition Indicator5.087.757.7510.4415.697.755.0815.9810.3812Right Upper Flap Guide HeightPosition Indicator4.814.814.814.814.816.196.196.197.4413Right Glue Gun HeightScale111 1/4″11111 1/4″2 1/4″14Right Ram HeightScale1/2″1/2″1/2″1/2″1/2″1/2″1/2″1/2″1/2″15Right Upper Flap Plow HeightScale4.54.54.54.54.54.54.54.56 1/2″16Load DeckChange PartNot UsedCCBACNot UsedAB17Carton Support RailChange PartNot UsedNot UsedNot UsedUsedUsedNot UsedNot UsedUsedUsed18Carton Support RailChange PartNot UsedNot UsedNot UsedUsedUsedNot UsedNot UsedUsedUsed19Left Upper Flap Plow HeightScale4 5/8″4 5/8″4 5/8″4 5/8″4 5/8″4 5/8″4 5/8″4 5/8″6 1/2″20Left Ram HeightScale1/2″1/2″1/2″1/2″1/2″1/2″1/2″1/2″1/2″21Left Glue Gun HeightScale111.2511111 1/4″2 1/4″22Left Upper Flap Guide HeightPosition Indicator5.115.115.115.115.116.46.46.357.5423Selector BarsChange Part2 dot2 dot2 dot3 dot4 dot2 dot2 dot4 dot3 dot26Preload Air Cylinders HeightPosition Indicator777777.457.457.458.7530Infeed GuidesScale6 1/8″8 7/16″8 7/16″1115 5/16″8 7/16″6 7/16″15 5/16″10 7/8″32Infeed GuidesScale12 5/8″12 9/16″12 9/16″15 1/4″20 1/8″12 9/16″12 5/8″20 1/8″15 3/8″35Tipped Product Flags HeightScale4 13/16″4 13/16″4 13/16″4 13/16″4 13/16″6 3/16″6 3/16″6 3/16″7 3/8″36Tipped Product Flags Up/DownLanes 1 2Lanes 1 2 3Lanes 1 2 3Lanes 1 2 3 4All LanesLanes 1 2 3Lanes 1 2All LanesLanes 1 2 3 437Lane Guide 1Change PartAAABBAABB38Lane Guide 2Change PartBNot UsedNot UsedNot UsedNot UsedNot UsedBNot UsedNot Used39Lane Guide 3Change PartNot UsedAANot UsedNot UsedANot UsedNot UsedNot Used40Lane Guide 4Change PartNot UsedNot UsedNot UsedANot UsedNot UsedNot UsedNot UsedA42Lane Guide 5Change PartNot UsedNot UsedNot UsedNot UsedANot UsedNot UsedANot Used
Hello-I need help filtering the difference in settings based on the 9 column headers. I would like to filter differences in adjustments on current setup to adjustments on the next setup, example: I am currently set up for 12oz 4pk and will be switching to 12oz 6pk. Ideally I would see a much more condensed list of adjustments on 12oz 6pk because some of the settings do not change. Is this possible? Adj #DescriptionReference Point12oz 4pk12oz 6pk12oz 6pk Half Flaps12oz 12pk12oz 24pk16oz 6pk16oz 4pk16oz 24pk19.2oz 12pk1Magazine Drive HeightPosition Indicator2.632.632.6357.251.251.251.252.312Magazine BackstopPosition Indicator4.234.692.994.624.626.055.795.796.133Magazine Drive Belt WidthPosition Indicator5.547.757.091015.627.755.545.5410.384Magazine Picture FrameChange Part12oz 4pk12oz 6pk12oz 6pk Half Flaps12oz 12pk12oz 24pk16oz 6pk16oz 4pk16oz 24pk19.2oz 12pk5Magazine HeightPosition Indicator6.115.766.158.210.2565.6211.647.636Setup HeightPosition Indicator4.814.814.814.814.816.256.256.257.447A-CVacuum Cup WidthScale4 1/2″ 6 9/16″ NA4″ 6 3/4″ 9 5/8″4″ 6 3/4″ 9 5/8″4″ 8″ 12″5 1/2″ 10 1/2″ 15 1/2″4″ 6 3/4″ 9 5/8″4 1/2″ 6 9/16″ N/A5 1/2″ 10 1/2″ 15 1/2″5 1/4″ 8″ 11″8Left Setup GuideScale5 1/4″5 1/8″5 1/8″7 7/8″10 1/2″5 1/8″5 1/4″10 1/2″7 3/4″9Right Setup GuideScale5 1/4″5 1/8″5 1/8″7 7/8″10 1/2″5 1/8″5 1/4″10 1/2″7 3/4″10A-CCase Squaring WidthScale4 7/8″7 3/4″7 3/4″10 1/2″15 5/8″7 3/4″4 1/4″15 5/8″10 3/8″11Tool BarPosition Indicator5.087.757.7510.4415.697.755.0815.9810.3812Right Upper Flap Guide HeightPosition Indicator4.814.814.814.814.816.196.196.197.4413Right Glue Gun HeightScale111 1/4″11111 1/4″2 1/4″14Right Ram HeightScale1/2″1/2″1/2″1/2″1/2″1/2″1/2″1/2″1/2″15Right Upper Flap Plow HeightScale4.54.54.54.54.54.54.54.56 1/2″16Load DeckChange PartNot UsedCCBACNot UsedAB17Carton Support RailChange PartNot UsedNot UsedNot UsedUsedUsedNot UsedNot UsedUsedUsed18Carton Support RailChange PartNot UsedNot UsedNot UsedUsedUsedNot UsedNot UsedUsedUsed19Left Upper Flap Plow HeightScale4 5/8″4 5/8″4 5/8″4 5/8″4 5/8″4 5/8″4 5/8″4 5/8″6 1/2″20Left Ram HeightScale1/2″1/2″1/2″1/2″1/2″1/2″1/2″1/2″1/2″21Left Glue Gun HeightScale111.2511111 1/4″2 1/4″22Left Upper Flap Guide HeightPosition Indicator5.115.115.115.115.116.46.46.357.5423Selector BarsChange Part2 dot2 dot2 dot3 dot4 dot2 dot2 dot4 dot3 dot26Preload Air Cylinders HeightPosition Indicator777777.457.457.458.7530Infeed GuidesScale6 1/8″8 7/16″8 7/16″1115 5/16″8 7/16″6 7/16″15 5/16″10 7/8″32Infeed GuidesScale12 5/8″12 9/16″12 9/16″15 1/4″20 1/8″12 9/16″12 5/8″20 1/8″15 3/8″35Tipped Product Flags HeightScale4 13/16″4 13/16″4 13/16″4 13/16″4 13/16″6 3/16″6 3/16″6 3/16″7 3/8″36Tipped Product Flags Up/DownLanes 1 2Lanes 1 2 3Lanes 1 2 3Lanes 1 2 3 4All LanesLanes 1 2 3Lanes 1 2All LanesLanes 1 2 3 437Lane Guide 1Change PartAAABBAABB38Lane Guide 2Change PartBNot UsedNot UsedNot UsedNot UsedNot UsedBNot UsedNot Used39Lane Guide 3Change PartNot UsedAANot UsedNot UsedANot UsedNot UsedNot Used40Lane Guide 4Change PartNot UsedNot UsedNot UsedANot UsedNot UsedNot UsedNot UsedA42Lane Guide 5Change PartNot UsedNot UsedNot UsedNot UsedANot UsedNot UsedANot Used Read More