When I create the 3 scenarios for a project I usualy have to change the Material Consumption [per Unit Volume] for each material assign an activity. This is very time consuming since I usualy have 100+ materials for a project. When I asign materials to activities I use either the activity properties box or the activities tab in the materials properties box. Is there a faster way to modify the material consumption other than using the activity properties box or the activities tab in the materials properties box?
For example when I want to modify the productivity of resources for the 3 scenarios I use a formula:
Productivity = Productivity * x, where x<1 or x>1.