BILLING WITH MS EXCEL (V-1)
For Construction billing of buildings
Many ERP Solutions Require.
Additionally the best billing practices (Procedure) require the process to be:
2. Transparent and Electronically Audit-able.
HOW EXCEL CAN HELP?
The formula further rounds up (shown in red colour above) the calculation to only the three decimal places (A SAP requirement).
For your bills, you need not reinvent the wheel and the above formula may be copied and pasted. But don’t forget to copy the column labels also. In fact it may be easier to copy the whole sheet from the Excel training file and then delete the measurement portion.
SKILL-2: DATA VALIDATION
- Select the cells for which you want to create name with the wished-for one at the top. (In the example the Towers are at the top of the cell selection.)