Forum Discussion
Unit and Work question
so i am a Electrical Contractor. Using Microsoft Projects to try to make Schedules for up coming work. is there a way to add Units and a Labor rate to it?
ex. i have 2600' of Conduit to install in a Area of work. the Labor Rate for my Conduit task is .95 hrs per 1' of Conduit. can i set up Col to have the total Footage(unit) in it and have the Labor Rate be in the Work to give me Duration in Rough Days per Area we work in?
hope this all makes sense New person to Microsoft Projects still learning.
Sorry, but it doesn't quite make sense. You say you have a labor rate of .95 hrs per foot of conduit. That doesn't compute. Labor rate is cost per time (e.g. $/hr), so are you saying the cost is 95 cents per hour or 95 cents per foot? Or maybe you're not talking about labor rate but really mean performance rate (i.e. it takes 57 minutes to lay 1 foot of conduit).
If you are referring to performance rate, then yes, you can create a custom field for the total length of conduit to be laid, which is a value you enter, and a second custom field that calculates the total time based on the performance rate. You can then enter that calculated value into the Duration field.
For example, in this case I set up the Number1 field as the entry field for the total length of conduit run. I set up the Duration1 field with the formula to calculate the duration (Note, Project calculated all time values in minutes). The next step is to manually enter the calculated value in the Duration1 field into the Duration field. And yes, manual entry is the best way to enter the calculated value into the Duration field although with a simple VBA macro there would be no need for the custom field formula in the Duration1 field and no value would need to be copied, it would all be handled in code.
John
