Download
| Description | Size | Download |
|---|---|---|
The template works with both the Microsoft Store edition and the desktop edition of the app. Make sure you have installed one of them. How to use:
| 406 KB | Download |
License: Private Use (not for distribution or resale). See our Terms of Use.
Screenshot
Detail
This two-column engineering invoice template is suitable for project architects and engineers that offer service to customers and have the need to bill the customers.
The template has two columns: Description and Total. Both are manually editable fields.
One thing that may not be obvious from the screenshots is that it supports changing order. In project management, a change order is a component of the change management process whereby changes in the Scope of Work agreed to by the owner, contractor, and architect or engineer are implemented.
In order to implement the support for change orders, we modified the Excel formula of the Total cell so that it searches for the keyword "Change Order" on the description column, and if that keyword is present, the total will be the amount that appears on the change order line; if the "Change Order" keyword isn't present, the total is calculated from the line totals.
The formula for searching "change order" is as follows:
=VLOOKUP("change order",oknProductName_1:oknLineTotal_17,11,FALSE)
The formula for the "Total" is as follows:
=IF(ISERROR(oknChangeOrder),oknSumLineTotal,oknChangeOrder)
For a variant of this template that does not support change order, see Architect (c2010).
Format and Specification
| Template# | c2006 |
| Belongs to | |
| Format (XLS or XLSX) | .xlsx |
| Columns | 2 |
| Lines | 16 |
| Line Height (Points) | 12.75 |
| Print Area | $F$3:$R$55 |
| Papaer Orientation | Portrait |
| Default Margins (Points) | |
| Left | 36.00 |
| Right | 36.00 |
| Top | 72.00 |
| Bottom | 72.00 |
| Price | Free |
