#1
|
|||
|
|||
Material usage based on formula
Hi All,
I am new to this forum and coming back to using MS project after 5+ years away. The project that i am trying to setup is a home reno project and I have a question relating to materials usage. I want to have the ability to add the units as Mē and then have a calculated field to show the number of litres of paint required and the cost to be based on the unit cost of the paint. is this feasible? alternatively i could manually work out the cost per Mē but i would still need to have a caculated field for the amount of paint so that i can total for the project. If the above is not feasible, how would i reference the material usage qty in a formula for each of the resources? understanding that different paint resources may have different coverage rates. |
Tags |
calculated field, custom field, resource |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
VBA Training material | Potholes | Chitchat | 4 | 10-12-2022 01:33 AM |
Formula to indicate RYG based on negative Value | dare2join | Excel | 9 | 10-14-2021 04:08 AM |
Conversion of Columnwise Bill of Material into Rowwise Bill of Material using Excel Macro VBA | mpapreja | Excel Programming | 4 | 05-21-2018 05:35 AM |
BOM (bill of material) | umairn | Project | 1 | 04-17-2017 02:11 PM |
Sum Average usage Based on two sheets | bremen22 | Excel | 3 | 09-03-2013 11:27 AM |