Project completion settlement sheet It refers to the economic document that the construction enterprise handles the project price settlement with the construction unit (owner) according to the contract and the completed quantities. The free download of the project completion statement form is provided by Huajun Software Park. The source file is in xlsx format. You can edit and modify the content and style by downloading the source file. For more information about the free download of the project completion statement form, please pay attention to Huajun Software Park.
General skills of grid form of project completion settlement sheet 1: IF function condition judgment IF function is one of the most commonly used judgment functions, which can complete either or judgment. The standard of assessment score is 9 points, and it is necessary to judge whether the assessment score in column B is qualified. =IF (B4>=9, "qualified", "unqualified") 2: Fast sum and average If you want to know the sum or average value of some numbers directly, you can select those numbers directly. After selection, summation, average value, and count are displayed in the bottom status bar. 3: Interlaced fill color makes the table more cool Ctrl + T First, use the shortcut key Ctrl+shift+right arrow+down arrow to select all tables, and then press Ctrl+T. The Ctrl+T method is very fast. It can fill the table with colors quickly, but it can't achieve the color selection. Filling method of self selected color First, use the shortcut keys Ctrl+shift+right arrow+down arrow to select all tables. Then select Conditional Format - New Rule in the Start Menu Select the cell to be formatted using the formula, and then enter=MOD (ROW(), 2)=0 * 0 in the format to fill even rows and 1 to fill odd rows Then select the format key, open the fill tab, and select your favorite color to fill
Project completion settlement sheet update log:
1. More outstanding details!
2. No trace of bug
Recommended by the Chinese military editor:
The project completion statement and word-of-mouth software are guaranteed to solve all your problems! I recommend you! There are similar software on this website 360 Browser If you are interested, you can download it!