Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-05-2013, 03:40 AM
Guloluseus Guloluseus is offline Linking related resources Windows 7 64bit Linking related resources Office 2007
Competent Performer
Linking related resources
 
Join Date: Mar 2013
Posts: 168
Guloluseus is on a distinguished road
Default Linking related resources

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
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Related automatic numbering in the text sebdes Word 3 11-04-2012 06:29 PM
Linking related resources project related info - One Note? pm_newbie Project 5 01-07-2012 06:16 AM
Linking related resources Setting up resources icw Project 2 09-04-2011 03:55 AM
listing out everything related to a project Dave HSE Outlook 0 03-15-2011 03:46 PM
Choice section related mrudula Misc 0 03-06-2007 12:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:36 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft