Tips for using materials schedule
Material planningHow to compile the table:
1. Material planning is a control plan for materials and is the basis for external procurement and ordering, so special attention must be paid to balance.
2. The material plan is prepared based on the signed project contract and annual construction plan, with reference to the project structure and construction period requirements, and based on the budget quota or estimated budget quota.
3. The requirement for material planning is to have strong predictability, specifications, varieties, and quality must be determined and implemented. Generally, changes should not be made after ordering.
The IF function is one of the most commonly used judgment functions, which can complete either-or judgments.
The assessment score standard is 9 points. It is necessary to judge whether the assessment results in column B are qualified.
=IF(B4>=9,"qualified","unqualified")
2: Multi-condition judgment
If the department is production and the position is mainly for operations, there is a high temperature subsidy. Use the formula in column D:
=IF(AND(B2="Production",C2="Main Operator"),"Yes","No")
Recommended by the editor of Huajun Software Park
Material scheduleIt is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need to download the material plan, please download it quickly. also,Short term investment schedule,Graduate School Leaving Procedure CardIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works