Morning all



Question time. I have to use 2 resources related to each other, specifically tonnage of material and lorries used to transport them. Lorries may take more than one load per day, so the quantity transported by a lorry could vary as a multiple (20T/day, 40t/day, etc).

I have set up resources so that all items are work, not materials (there is a reason for this, as the programme is being used as a levelling and predictive tool as opposed to an actual planning one) and currently I need to input the amount of material, divide by the number of tonnes/ lorry, and use this as another resource- e.g. we need to move 600T of "stuff" and each lorry can make 3 runs a day. each lorry can carry 60t/day, so we need 10 lorries (600/60) in total. time i snot a factor as I have set resources to either fixed work or fixed units, depending on other factors.

Is it possible to link a resource to a resource so that the number of lorries could be set automatically, instead of a manual input? If I could set the divider (tones/lorry/day) it would be great, otherwise a single value would be fine- generally 40T works, and other values are less likely.

thanks in advance

Sorry, no. There may be a method through VBA - but that is no particularly my skill set.

You can do some calculation in spare number fields, but you will still need to manually input.

If you want to pursue the VBA option, try posting to:

http://social.technet.microsoft.com/...stprog/threads

I was fairly sure this was the case, ir was really a case of hoping someone had done similar work and found a method. Thanks for the answer, I dont need to keep looking for a non existant answer

You're welcome and thanks for the feedback.
Julie

Quick follow up- due to the way that our system works, the amount of lorries has become more variable than I originally thought. As a result, it is a lot easier to use a calculator and manually input the values. real life is too fickle

Thanks for the follow up. Certainly there are times when a calculator is more efficient that trying to work out the details in Project.