|
Lesson 12 - Worksheets Scroll down What You Will Learn • How to open a Material Takeoff Worksheet. • How to use the Material Takeoff Worksheet window. • How to add a catalogue item to the worksheet. • How to edit a worksheet item. Getting Started What is a Material Takeoff Worksheet? A Material Takeoff Worksheet is an area in Winpriser that is used to store a list of materials. The Worksheet can be used to create a Bill of Materials, an Estimate, an Invoice or a Purchase Order. A Worksheet can also be used as an Assembly of items that are commonly installed together. There is no limit to the number of worksheets that you can store in Winpriser.
Lesson 1
1 Click on the Worksheets OR
Select the File | Open Worksheet menu option from the Catalogue Lookup menu:
2 The Worksheet Directory lists all the worksheets that you have stored on your system. You can use the Customer View tab to list the worksheets by customer name. The Job View tab lists worksheets by Worksheet Description or job name.
Click on the New
The left side of the window contains a list of all the available worksheet views:
• Job Setup – Contains the fields that you use to identify the job.
• Material Extension Views – Contain spreadsheets for the material items that you have added to the current job.
Each material extension view allows you to isolate "like" items to help you organize and complete the worksheet.
• Direct Labour – Contains an area to itemize labour for a job. • Job Summary – Allows you to "fine tune" your job pricing. • Job Notes – Contains a simple word processor for you to use to compose detailed job descriptions, covering letters etc.
3 We will now identify the worksheet. Click on Job Setup. 4 We will want to specify a Customer Name for this worksheet. Click on the Customers Click on the Add button.
5 Enter the customer name in the Summary tab and press the Enter key.
6 Use the Detail and Supplementary Info tabs to complete the customer information.
Click on the Close button to return to the Customer Database window.
7 Select the customer name by clicking on the down arrow at the right end of the Customer Name field or by clicking on the Search
8 Highlight the default Worksheet Description, "Untitled 00001", and type a name for this worksheet.
9 You have two windows inside Winpriser’s main program window – the Catalogue Lookup window and the Worksheet window. You can switch between windows within Winpriser by selecting Window | Catalogue Lookup or Window | Worksheet from the Winpriser menu.
OR Press and hold the Control (Ctrl) key while you press the Tab key on your keyboard. Select the Catalogue Lookup window.
10 Click on the Group tab. 11 In the Group list box, select COPPER PIPE.
12 Each component of the COPPER PIPE group contains sized items. Select a size from any component:
13 As shown above, the Takeoff toolbar button should be enabled to indicate that at least one Worksheet window is opened and available. Click on the F6 - Takeoff toolbar button.
14 The Takeoff window will appear:
Let’s take a look at the different controls on the Takeoff window:
To select a discount, place a checkmark in the checkbox next to the supplier’s name. If only one supplier has been assigned to the current takeoff item, that supplier is automatically checkmarked.
When the unit of measure is changed, the list price is adjusted to reflect the new unit of measure, as shown above. This copper pipe item is now sized per feet and the list price per foot is $6.18. You can now enter "50" as a new takeoff quantity in the Add Quantity data entry field.
15 Enter a quantity in the Add Quantity data field and press the Enter key on your keyboard.
You will be returned to the Catalogue Lookup window to continue selecting more product items for takeoff into a worksheet. Add as many new worksheet items as you want using whichever Lookup tabs that you want. When you are finished, return to the Worksheet window.
16 You should now have several product items listed in your worksheet. To view the list of material items that you have added to the worksheet, click on the Extensions | Extension View | View All view on the left side of the Worksheet:
The right side of the Worksheet window will now display All of the price extensions for each material item that you have taken off for this job:
If you click on the Labour tab you will see a list of labour extensions for each material item taken off:
17 Click on the Material tab.
18 If you have added more than 1 material item to your worksheet, you can view these items by Product Group, Product Type, Supplier or Job Phase:
You can use the appropriate Extension View to select a specific group of items to view. For example, click on the + sign beside View by Product Group. Click on one of the product groups listed. Once you have selected a product group from the View by Product Groups list, only the worksheet items that belong to the selected product group will be loaded into the worksheet’s extension table on the right side of the Worksheet window.
19 To edit a worksheet item, either point to the item, click the right mouse button and select the menu option Edit Selected Item from the popup menu:
OR Click on the Edit toolbar button as shown below:
The worksheet Material Edit window will appear:
The Material Edit window allows you to change most of the values that were copied to the worksheet from the original price catalogue. Discount, Markup, Markdown, Quoted, Supplier, Job Phase can all be revised.
If required, you can also select multiple material items from the Material tab extension view to edit. Move back to the Material tab on the worksheet and, while holding down the Ctrl button on your keyboard, click on some material items until you have several highlighted as shown below:
20 Click on the Edit toolbar button. The Multiple Material Edit dialog window appears:
A new All
21 Click on the Save button when ready to continue.
22 Use Material Edit to enter a Discount and a Markup for each worksheet item.
|
to see complete section. 
Open the RedBook Catalogue Lookup window. If you are not sure how to open the RedBook Catalogue Lookup window refer to:
button in the Winpriser toolbar
button to open a new worksheet.
You can change the order of the columns in the Material Extension Views by clicking on the column heading and dragging the column to its new position (click and hold left mouse button and move mouse pointer).
View All - Displays all the product items of the worksheet in the order in which the products were added.
toolbar button. The Customer Database window will open. 
button.
If there is more than one Worksheet window opened, you can select which worksheet will receive this item:
This ability to isolate specific worksheet items according to product type, product group, supplier, or job phase is a very powerful tool. For example, when editing the worksheet, you can apply pricing operations (i.e. assigning discounts, markups or markdowns) to a particular range of worksheet items. 
control has been added to the edit window. If All is checked, the associated field in all the highlighted items will be revised. If this All is not checked, this field will NOT be changed in any of the highlighted items.
beside the item will turn from yellow to green.
End of LessonCopyright Allpriser Ltd - 2011
