(1) The amount of advance payment for the project, the payment time limit and the deduction method;
(2) Payment method, amount and time limit for project progress payment;
(3) When changes occur during project construction, the project price adjustment method, claim method, time limit requirements and amount payment method;
(4) Solutions to project price disputes;
(5) Agree on the scope and extent of risk-taking and the adjustment methods for exceeding the agreed scope and extent;
(6) The settlement and payment method, amount and time limit of the project completion price;
(7) The amount, withholding method and time limit of project quality assurance (warranty) money;
(8) Safety measures and accident insurance costs;
(9) Rewards and penalties for advancing or postponing the construction period;
(10) Guarantee matters related to the performance of the contract and payment of the price.
1. Quick sum? Use “Alt + ="
Excel’s functions are very powerful, and summation should be one of the most commonly used functions. Just press the shortcut keys "alt" and "=" continuously to find the sum of a series of numbers.
2. Quickly select discontinuous cells
Press the key combination "Shift+F8" to activate the "Add Selected" mode. At this time, the words "Add to Selection" will be displayed in the status bar below the worksheet. Then click on discontinuous cells or cells respectively. You can select a grid area without holding down the Ctrl key.
3. Change number format
Excel’s shortcut keys are not chaotic, but follow a certain logic.
For example, if you want to quickly change the format of a number, you can immediately add a dollar sign to the number, because the $ symbol and the number 4 share the same key.
In the same way, "Ctrl+shift+5" can quickly change the number into the form of percentage (%).
4. Display all formulas with one click “CTRL + `”
When you try to check whether there are errors in the data, you can display the formula behind the number with one click.
The "`" key is just to the left of the number 1 key:)
Project Payment Application FormIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Project management department dispatches work orders,Low-rent housing application acceptance recordsDownload to get the source file, which you can edit, modify and replace. Download the project payment application form and go to Huajun Software Park.
it works
it works
it works