Page Comparison

...

1. Check the IntelliSearch box.
   
2. Click on the Manufacturers drop down and select Watts Regulator Company.
   Image Modified
   
3. Click on the Category drop down and select Valves.
   Image Modified
   
4. Click on the Sub-Category drop down and select Ball-Brz.
   Image Modified
   
5. Click on the Go button.
   Image Modified
   The following screen appears, showing Watts’ Brz Ball Valves.
   Image Modified
6. Click the Catalog button to search by the manufacturer's Catalog part #.
7. Click on the items you would like to import into QuoteSoft Pipe. (They will highlight green.)
   
8. Right click on the selected items, and then select Send Selected Items to the BOM (Bill of Materials) Work Area.
   
   E-Office sends the selected items to the BOM Work Area. Here you will see the Catalog #, HPH-Code, Size, Description, Manufacturer, Qty, List Price, Ext Price, and Effective Date.
   
9. Right click inside the BOM Work Area. The following screen appears.
   Image Modified
   
10. Click on Save As. The following screen appears.
    Image Modified
11. Click OK.
    The following screen appears. It allows Customers to save the BOM (Bill of Materials) inside of Harrison's E-Office.
    Image Modified
    
12. The BOM will be saved under the Scratch Pad/Project-Entered. Next to BOM, type the Name of the BOM you would like to save. (Watts B6080 Brnz Thrd Ball Valve)
13. Click OK. E-Office will show you the Default E-Office Screen.
    
14. Right click in the BOM (Bill of Materials) work area and select Clear BOM Work Area.
    Image Modified
    
15. Scroll down the list of BOMs and find the one named Watts B6080 Brnz Thrd Ball Valve.
16. Right click on the BOM and select Export to File.
    
    The following screen appears.
    
    
17. In the top-left corner of the screen, select QuoteSoft Pipe BOM (New Item).
18. In the field in the middle of the screen, select the Location to save the file.
19. Type the Name of the file that you want to save. The file must end in “.dat” in order for QuoteSoft Pipe to recognize it.
    
20. Click on Export. The following screen appears.
    Image Modified
    
21. Click on No (unless you created the BOM previously). Before exporting the file you want to make sure that you have the latest list price. The file Watts B6080 Brnz Thrd Ball Valve.dat will now be saved to the Desktop.
    The following screen appears.
    Image Modified
22. Click on Exit.
23. Close all the way out of Harrison's E-Office.

...

1. Open QuoteSoft Pipe by double clicking the icon on your Desktop.
   
2. From the Main Menu, click on the Database tab.
   
3. On the top left corner, click on the Tools menu and select Import Wizard.
   
   The following screen appears.
   
4. On the top left corner, click on the Import Items button. A screen appears where you can select the “.dat” file you created in E-Office.
   
   When done, the following screen appears.
   
5. Click on OK. The following is the import of the Watts B6080 Brnz Thrd Ball Valve.
6. Click on Continue to Next Step.
   
   The following screen appears.
   
7. Click Yes. (The list was already edited when creating the BOM.) The following screen appears.
   
8. Click No. The Short Description contains sizes which you do not want. You want to use the Long Description. Here is a sample of the Long Description.
   Image Modified
   The following screen appears. First choose the Select All Items button.
   Image Modified
9. On this screen, you will need to change the Size 2 to match Size 1 on all items listed. (Ball Valves need to have two Joint Sizes so QuoteSoft Pipe can add the correct number of joints.) Example: (2x2x2) Tees have 3 joints so you need to match all 3 sizes. (2x2x1) Reducing tees would also use 3 joints but the 3rd Size would be different from Size 1 or 2.
   The following screen appears after changing all the sizes.
   Image Modified
10. Click on the Set the selected Item’s Family, Group, SubClass, Class, and Type button. This will help you set where the items are to be located in the Database.
    The following screen appears.
    Image Modified
11. Select the Family and Group you want the item to be added in the Database. If you need to add a new Class, click on the Add New Class button.
12. Enter a new Subclass: Watts Brnz
13. Enter a new Class: B6080 600WOG FP Thrd Brnz
    
14. Click OK. This will set the new Subclass and new Class. The following screen appears.
    Image Modified
    
15. Click on the Add New Type button.
16. Scroll down on the right hand side tool bar and select the Threaded Ball Valve.
    
17. Click OK. The following screen appears.
    Image Modified
    
18. Click on the Set item/s to selected Family/Group/Class/Type button. The Import screen re-appears.
    Image Modified
19. Select the sizes you need to show (1) and set the others to hide (2, 3, and 4). (Because a valve has the same input and output size, you need to only show one size in Takeoff.)
    Image Modified
20. Change ALL Joint Groups to Threaded.
    Image Modified
21. Change ALL Joint Classes to Female Iron Pipe Thread.
    Image Modified
    If the item you are importing can use more that one type of Joint or Joint Class, set the Joint Group and Joint Class to SPEC and SPEC. This will allow you to set the Joint Group and Joint Class in the SPEC instead of the Database.
    Image Modified
    
22. Change the Labor Group if it already exists in the Labor Groups Table.
    
    The following screen appears.
    

    
23. Select Screwed Ball Valves from the Labor Group List.
24. Change the Material Group if there is a group that already exists in the material multipliers group.
    
    The following screen appears.
    
    
25. Select the Ball Valves: Watts from the Material Multipliers list. If you need to create a new material multiplier, click the Edit Material Discount Groups button at the bottom of the screen. Add a material Multiplier as normal and then select it as shown under item 25 above. To add Labor Groups follow the same procedure as above for the material groups but use the Labor Factor Group instead.
    
26. If needed, you can also set the Labor for each item or you can import items and then use the Edit All and Excel Export functions in the database to add these items.
    
    Labor 1 = Quote Labor, Labor 2 = MCAA, Labor 3 = PHCC, and Labor 4 = User
27. Click Save Current Import Session for later use and save the file to your desktop.
28. Click Verify information and Import Items to the database.
    
    The system asks you the following questions.
    
29. Click OK. If you have missing information or the system found a duplicate, you will receive the following message.
    Image Modified
    If you receive this window, go back and make sure you followed all the steps given.
    Still having problems? Call 1-800-813-7020 and Technical Support will help you with the import.
30. Testing the data: Once you have entered all the items, test the data to make sure it is accurate.
31. Go into the Database and verify all information.
    
32. Go into a spec and assign the new ball valve.
    
33. Go into a Zone and takeoff the item you added.
    
34. Run a Calculation with that job and see if the data is accurate.