Validating profile... 0% complete

What is your current level of experience in freelance work?

 

 

Estimate Excel sheet

We are an electrical contractor and I created a basic template excel sheet to help produce small estimates quicker. This is attached. It does basic hours x labor rate. Tax, Mark Up, Etc. It works great for what it is. I have a database of about 200 items and growing on a separate sheet, that the material will pull pricing from when entered. As well as additional sheets that populate from when we have items in stock or not. All manually entered. I need to maintain all the current features. Looking to change or add the following: ( not sure the best way to go about it ): 1. To add more lines to in the material area. Some jobs will have more material then lines allow. We currently can expand the lines, but we have some jobs that this does not work, we need more lines. 2. Is there a way to quickly save as or export as pdf to same root folder that the xls resides in? Our job costing software will open a pdf but not a xls. 3. I need a way to turn tax on or off on labor. A drop down menu for labor. With either " Labor", "Capital Improvement Labor" or "Tax Exempt Labor". Entered tax value applies to only "Labor".