INTRODUCTION to SPECWRITER
- SpecWriter is an Excel spreadsheet program designed to write specifications and prepare estimates for residential and light commercial construction projects.
- SpecWriter works by providing you with a Checklist of specifications from which you select those that apply to your project.
- Once you’ve selected your specifications, the menu command “Generate Specifications” will copy them to the Specifications page, re-group them by section, number, outline and format them to create your customized specifications.
- SpecWriter’s Checklist contains over 6,500 pre-written specifications for your immediate use.
- You can add, edit, overwrite or delete anything on the Checklist, which means you can customize it specifically for your business.
- You can change the Checklist selections and re-generate new specifications at any time.
- You may also create an Estimate Worksheet with the same categories and specifications as your contract documents.
- Follow the installations instructions to install SpecWriter.
- The installation program will…
- Create a folder on your hard disc named “PowerTools”
- Create a sub-folder named “SpecWriter”
- Copy a file named “SpecWriter365 Master File.xlsm” into the folder.
GENERAL FILE MANAGEMENT
- All your SpecWriter files should be kept in a folder named “c:\PowerTools\SpecWriter”.
- This folder will contain your SpecWriter365 Master File and the project files you create from your SpecWriter365 Master File.
- The SpecWriter365 Master File.xls is your primary copy of SpecWriter.
- Each time you want to start a new project, you will…
- Open SpecWriter365 Master File.xls
- Use File | Enter Project Name to enter the new project’s name.
- Use File | Save to Hard Disc to save the file using the new project name.
- Each time you want to make permanent changes to the Checklist in your SpecWriter365 Master File, you will…
- Open your current SpecWriter365 Master File.
- Make the desired revisions.
- Select File | Save to Hard Disc
- It’s OK to replace the SpecWriter365 Master File with a version you’ve modified with permanent changes as a new Master File.
- Do Not replace the SpecWriter365 Master File with a version you’ve setup for a specific project.
UNDERSTAND the EIGHT SECTION SYSTEM
- To use SpecWriter, you need to understand the 8 Section specification format.
- Unfortunately, until you work with the Checklist, the 8 Sections won’t have a lot of meaning.
- Nevertheless, we needed to introduce the concept at some point, so just read this section and understand that you won’t really understand it’s application until later.
- There are Eight main Sections to any project’s Specifications.
- Sec 1 General Description of the Scope of Work
- Sec 2 Descriptions of Work in Specific Areas
- Sec 3 Items included in the Basic Contract Price
- Sec 4 Unit Cost Allowances
- Sec 5 Fixed Cost Allowances
- Sec 6 Options and Upgrades
- Sec 7 Tasks by Owner
- Checklist Specifications written for Section 1 & 2 apply only to those sections.
- Checklist Specifications written for Sections 3 through 8 are organized together by category because these selections must be made in relation to each other.
- In other words, the Scope of Work for all parties for any given subject must be decided together.
- The color-coded bar on the left side of the Checklist will visually identify the Section where the selected Specification will appear.
FIRST TIME OPENING the FILE
- Start Microsoft Excel, Select Open
- Look in “c:\PowerTools\SpecWriter”
- Open “SpecWriter365 Master File.xlsm”
COMPANY NAME & DISPLAY SETTINGS
- The Program Settings control many important aspects of the program.
- As you become experienced in SpecWriter, you will probably change one or more of them to suit how you wish to operate the program.
- For the time being, we recommend you leave the settings alone except for the two you need to review before you can proceed.
- Use Settings | Program Settings | Display | Screen Resolution to adjust SpecWriter’s page size to match your monitor.
- When you’re done, use File | Save to Hard Drive to save the file as a new SpecWriter Master File.
- From then on, when you open your SpecWriter Master File to start a project, it will already have your company name entered.
MOVING AROUND the PROGRAM
- Use the arrow keys to move around any page.
- Use the right side scroll bars to move up and down a page.
- Use the mouse pointer on the file tabs at the bottom of the screen to move between pages.
- Use Checklist | Lookup/Goto to view an alphabetical list of checklist categories you can select and jump to.
LEARNING YOUR WAY AROUND
- The fastest way to learn your way around SpecWriter is to open the master copy and go tearing through it for about an hour.
- You should check out every menu command, examine every screen, click every button, and try to figure out what everything does to everything else.
- Be bold, try to break the program!
- When you’re finished, simply close the file without saving it!
YOUR FIRST PROJECT
BASIC PROCEDURE for USING SPECWRITER
- Double-Click the SpecWriter Icon on the desktop to open the SpecWriter Master File.
- Use File | Enter Project Name to enter the project name.
- Select a Checklist Template (optional)
- Use Specifications | Generate Specifications to generate test Specifications using the template settings.
- Select the desired specifications from the Checklist.
- Use Specifications | Generate Specifications to continue.
- Review and revise as necessary.
- Use Estimate | Generate Estimate Worksheet to continue.
- Complete the Estimate and Summary, revise as necessary.
- You may preview and/or print any document at any time.
- Use File | Save to Hard Drive to save file at any time, and always save the file at the end of your work session.
- Start at the top of the Checklist, with the square box cursor in the tag column.
- Use the arrow keys to move down the Checklist, and use the small “x” key to select the specifications and descriptions that describe the project.
- You may also delete an “x” with the delete key at any time.
- Always select at least one header for each specification group. The headers are in bold, dark blue print on the screen.
- Use the color coded left side column to remind you which section of the Specifications page that specification will appear.
- Use Specifications | Generate Specifications to initiate the procedure. SpecWriter will then…
- Copy the specifications you “Tagged” from the Checklist to the Specifications page.
- Re-sort the Specifications by Section.
- Organize the Specifications in an outline.
- Use Specifications | Preview to review how your specifications will appear when printed.
- If you wish to change anything in the Specifications, just change the Checklist and generate new Specifications.
- You may generate specifications as many times as you wish.
CREATING an ESTIMATE
- Use Estimate | Generate Estimate Worksheet to initiate the procedure.
- SpecWriter will then…
- Copy the specifications you “Tagged” from the Checklist to the Estimate page.
- Re-sort the specifications by Section.
- Organize the Specifications in an outline.
- Place the specifications into a worksheet with additional columns for unit costs, quantity, costs, etc.
- Add the Cost Codes.
- When you create a second estimate, SpecWriter will ask you if you want to save the first estimate for reference.
SET CUSTOMER TYPE
- Use File | Set Customer Type.
- This command will allow you to replace the word “Owner” with any of the displayed alternates throughout the entire Program.
- You may switch back to “Owner” at any time.
- Use Settings | Program Settings to access the Settings dialog box.
- Checklist Columns will display or hide certain columns on the Checklist.
- Pages to Display will determine which of the pages are visible.
- Estimate Font Sizes will allow you to change the fonts, most notably when the dollar figures are too wide for the columns.
- Screen Resolution will change the zoom level to fit your monitor.
- The Default Folder is the location of your SpecWriter Files.
- Display Caution Messages allows you to turn the messages off.
- The Default Rates allow you to set the defaults used in the Estimate.
CUSTOMIZING the CHECKLIST
- Once you’ve gotten used to what SpecWriter actually does, you’ll want to start customizing it for your business.
- First, scan down the Checklist, and use the “Collapse/Expand” feature to “Collapse” (hide) entire Categories of Specifications you don’t think you’ll need on a regular basis.
- Simply Click on the little ” + ” plus sign in the left column, at the end of the black line, adjacent to the bottom of each Category.
- Clicking the ” – ” minus sign will expand the Category at any time.
- Also, while scanning the checklist, use the “Red Letter” feature to identify your Standard Specifications.
- Select any specification, then press “Control-R” to change it’s color from black to red.
- This is a visual tool designed to assist you in making you checklist selections.
CUSTOMIZING the SPECIFICATIONS
- Most users will add between 30 to 100 customized specifications.
- You can add specifications to your Master SpecWriter File at any time.
- Use the F-2 key to edit a specification at any time.
- Use Checklist | Add Specification Line to insert a blank specification row at any point in the Checklist.
- Use Checklist | Delete Specification Lines(s) to remove the selected rows completely.
- Use Checklist | Insert Special Note to insert a new row with the text “Special Note:” in the beginning of the specification.
- Use Checklist | Insert New Category to insert an entire new, blank category description ready for further editing.
- Use Checklist | Insert Allowance to insert a blank allowance description at the bottom of the current category.
- Always keep your specifications to one row maximum. Break up long specifications into separate rows if needed.
- Always save the SpecWriter Master File after you’ve added new specifications.
USING the TAKEOFF
- The Takeoff page provides you with an area to calculate and record the Project’s basic quantitative measurements.
- Based upon your entries, the Takeoff will perform calculations for masonry, roofing, drywall, etc.
- Once you’ve completed the Takeoff, you can access and transfer any of the figures from the Takeoff into the Estimate page by pressing “Control-L” from the Estimate page at any time.
CUSTOMIZING the TAKEOFF
- Open the Takeoff menu to view the menu options.
- You can add, edit or delete any row in the Takeoff.
- You can also insert a blank new section anywhere in the Takeoff.
USING the ESTIMATE
- The Estimate is a worksheet formatted to assist you in calculating and summarizing the many figures in a typical estimate.
- The Estimate worksheet contains the same specifications as the project specifications with two notable exceptions:
- The allowances are NOT grouped together. They are positioned with their applicable specifications.
- The idea here is to proceed down the worksheet, category by category, and enter your estimated cost for that category.
- Your estimated cost might be calculated from historical unit costs, or it could be a bid or quote your received, or it could simply be a SWAG.
- Use Estimate | Presentation Options to change the estimate to different formats as your situation may require.
- Without regard to how you determined the estimated costs, the Estimate Summary will:
- Total all the figures in each applicable column.
- Allow you to add percentages for Supervision and other project overhead costs.
- Allow you to enter percentages for Overhead and your Compensation (Profit).
- Please note that the Overhead and Profit dollar figures are a margin as a percent of the Total Price, NOT a markup on the costs.
USING the SCHEDULE OF VALUES
- The Schedule of Values is comprised of the headers you selected from the Checklist, with adjacent columns for entering costs, markup and price.
- The SOV is designed for commercial projects that require you to submit a Schedule of Values as part of a bid submission package.
- Some residential lenders also want a SOV with the loan application because they will utilize it as the basis for the draw schedule.
- Some Builders use the SOV to estimate their projects or simply as a “Preliminary Rough Estimate”
- You can always generate the SOV, view it, and then decide if it’s of any use to you.
- If you don’t need to use the SOV, just ignore it.
USING FIELD NOTES
- Field Notes are a document created from your Checklist that is specially formatted to be used to take notes during discussions with potential customers.
- When you return to your computer to write the specifications, your printed notes match your SpecWriter Checklist.
- When you select the menu command “Generate Field Notes” the program will copy the checklist in that file, exactly as you have it customized, exactly as you’ve collapsed it, to the Field Notes page, where it will go through a process that will reformat the page, place checkboxes next to each specifications, and reduced the font size to create room for handwritten notes.
- I recommend generating and printing up Field Notes only when you’ve made changes to the Checklist since you’re last printing.
- It’s easier to bring the Field Notes to a print shop and have them print you multiple copies.
SAVING the MASTER FILE
- Always make any permanent changes to your SpecWriter Master File. (SpecWriter Master File.xls)
- After making any permanent changes, always save the SpecWriter Master File by using File | Save to Hard Disc to replace your previous copy of your SpecWriter Master File.
USING CHECKLIST TEMPLATES
- Templates are Checklist selections you decided to name and memorized as a group.
- In other words, you can memorize what you’ve tagged on the entire Checklist, give it a name, and later recall that template at any time.
- Templates are intended to allow you to pre-configure typical projects as a “quick start” for writing specifications for a new project.
- For example, you can memorize the basic specifications for a commercial tenant build-out (demo, metal stud walls, suspended ceiling, etc.) in your Master File, then use the template each time you are specifying that type of project.
- After selecting a template to get started, you should then proceed with reviewing the Checklist to make any necessary changes and additions.
USING TEMPLATE FILES
- Template Files are SpecWriter files you’ve setup for a specific purpose.
- Template Files can be setup for your model homes, which will allow you to quickly revise them for a specific buyer.
- Template Files can also be setup for re-occurring projects, such as a standard detached two-car garage you build constantly.
- Don’t get confused by the concept of a Template File, they are simply files you’ve already created for a general type of project that you will open and continue to customize for a specific project.
WHILE in EXCEL MENU, PLEASE DO NOT…
- Change the height of any row anywhere in the Program.
- Perform massive moving and copying of the Checklist Categories.
- Attempt to word wrap a specification that’s too long for one row.
- Change the font sizes.
- Ask us to fix anything you did while you were in the Excel menu, and outside of our programming control.
COPYING SPECWRITER FILES
COPYING SPECWRITER FILES
- SpecWriter365 files are completely portable.
- Each SpecWriter365 file is completely self-contained with all the programming code included in each file.
- You may move or copy SpecWriter365 files by any regular file transfer method, including copying a file to or from a thumbnail drive.
- You may also email SpecWriter365 files as an attachment.
- SpecWriter is a tool for creating documents used in the course of administrating construction projects.
- The SpecWriter program, it’s manual and this website ARE NOT legal dissertations, legal opinions, or legal advice.
- You, as the Program User, MUST REVIEW every document created by the Program for accuracy, completeness and correct use BEFORE implementing the document.
- You, as the Program User, MUST obtain the advice of an Attorney BEFORE using any of these documents.
- You, as the Program User, accept ALL LIABILITY for the accuracy, correctness, correct use and correct application of the documents provided herein or created by you.
- PowerTools Software, Inc. accepts NO LIABILITY for the accuracy or correctness of the documents, or for the correct use or application of any documents provided herein or created by the user, or for the contents of the program, it’s manual, or the website.
- This is only a part of the full LEGAL DISCLAIMER, which is incorporated into the installation program and may also be viewed at www.PowerTools Software.com