Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 01-25-2023, 03:16 PM
Dmacleod101 Dmacleod101 is offline Material usage based on formula Windows 10 Material usage based on formula Office 2021
Material usage based on formula
Join Date: Jan 2023
Posts: 1
Dmacleod101 is on a distinguished road
Default 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.
Reply With Quote

calculated field, custom field, resource

Thread Tools
Display Modes

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
Material usage based on formula 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
Material usage based on formula BOM (bill of material) umairn Project 1 04-17-2017 02:11 PM
Material usage based on formula Sum Average usage Based on two sheets bremen22 Excel 3 09-03-2013 11:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:34 AM.

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