![]() Enter a name for the template and click "Save. ![]() ![]() To save the file as a template, select "Excel Template" in the Save as Type list. Save the worksheet by pressing "Ctrl-S" or clicking the "Save" button on the Quick Access Toolbar. ![]() Type "=SUM(I6:I75)" to automatically calculate the total cost to date. Select cell I4 and click inside the Formula Bar. Click and drag the handle down the column to copy the formula to all of the cells required. Point to the lower-right corner of cell I6 until you see a solid cross, which is the Fill Handle. Type "=PRODUCT(G6,H6)" to automatically calculate the total cost for that row. Select cell I6 and click inside the Formula bar. Type "Item No." in cell A5, "Name" in B5, "Description" in C5, "Part No." in D5, "Type" in E5, "Date" in F5, "Qty." in G5, "Unit Price" in H5 and "Total" in I5. Download Road Work Estimate and Building Estimate Sheet. Download Estimate breakdown of the works - Excel Template Sample. Click the "Borders" button in the Font group and select "All Borders." 4 Forms for Construction Contractor - Breakeven Point Worksheet, New Job Checklist, Profit & Loss Statement, Overhead Expense Chart. Click on "Orientation" in the Page Setup group and choose "Landscape."Ĭlick on cell B1 and type "Product Name:" and then click on cell B2 and type "Product Number." Type "Date:" in cell E1 and "Last Update:" in cell E2.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |