Home

User`s Manual - Durand & Associates

1. e OPW P 11 El td El Bj b Pd ob EJ P SUBTOTAL MULTIPLIER DEFAULT 1 ASSEMBLY TOTAL Assembly MakeUp Sheet 7 ASSEMBLY MAKEUP SHEET 7 DATE DESCRIPTION SW 2G 1 1P l 4W EST BY ITEM a M PRICE M EXT L UNIT EMT 1 2 823 77C S4 04 2 92 C EMT COUP 55 DC 1 2 Sube DS 20 23 4 50C CONN SS DC 1 2 S21 30C 0 43 4 50C STRAP 1H 1 2 12 90C 0 39 4 50 504 1 5D 1 2 KO 5103 97 1 04 22 50C SQ4 RING 2G RAISE 1 2 582 63 50 83 4 50 SW 20A IV 5120 21 S162 96C 18 00 SW 4W 20A IV CS420 21 51 200 00 12 44 00 WIRENUT RED Sie Peleg i 50 23 2 70 C 10 PLATE SWITCH 2G IV 540 08 50 40 Jut 11 THHN CU SOLID 12 547 43 55 69 4 50M 12 13 14 15 16 17 18 19 20 W p ut O C O C CO C IL t F p Ei d B PB ob B b id Am dui SUBTOTAL MULTIPLIER DEFAULT 1 ASSEMBLY TOTAL 5 1 5 Copyright 1998 Durand amp Associates SAMPLE PRINTOUTS Assembly MakeUp Sheet 8 ASSEMBLY MAKEUP SHEET 8 DATE DESCRIPTION SW 2G 2 3W EST BY ITEM QTY M PRICE M EXT L UNIT EMT 1 4 17 522 770 4 04 EMT COUP SS DC 1 2 522 63 50 23 amp 50 EMT CONN SS DC 1 2 S21 30C 0 43 4 50C EMT STRAP 1H 1 2 512900 50 38 4 50C 504 1 5D 1 2 KO 103 97C 51 04 SO4 R
2. DOUBLE CLICK Electrical Estimating SAMPLE BWB File Edit Recap Assembly Sheets Pricing Sheets Quotes Other 8 Pricing Menu x ASSEMBLY HA KEUP PRINT HANAGER Print Manager Start Printing MAKEUP 1 HAKEUP 2 ugs MAKEUP 21 22 ugs MAKEUP 61 52 MAKEUP 83 MAKEUP 04 MAKEUP 85 MakeUp Manager MAKEUP 64 MAKEUP 65 Select Print and Start Printing MakeUps from the pulldown menu NOTE Printing takes 20 60 seconds per page and printing all sheets can take 30 90 minutes 6 1 5 Copyright 1998 Durand amp Associates DATA IMPORT SCREEN Linked To Database Use this screen to select items to import Single Item Double click on the description Hot Cell to import one single item Multi Item Double click on the Automatic Cells to select multiple items and then double click on Import Tagged Items Hot Cell to import tagged items Double click to import tagged items Double click to select pricing level Double click to tag items Brown active indicates pricing level selection Double click to import a single item Double click to return to price sheet without importing prices To view labor units used the pagedown key Double click to select labor level Brown active indicates labor level selection 6 16 Copyright 1998 Durand amp Associates MENUBARS MENUS and COMMANDS Double
3. OVERHEAD SUMMARY TOTAL LABOR HOURS TERT LABOR X 54 126 00 LABOR RATE x C 38 33 73 MATERIAL X 1 326 43 COST QUOTES X 192 30 OF LOST TIME 51 309 84 JOB COST X 3e LABOR COST 27 506 70 OVERHEAD 55 878 2 MATERIAL COST 58 842 89 QUOTES 52 403 70 PROFIT COST 52 335 00 Double click on Labor to gg PRIME COST 41 088 29 MATERI access this worksheet 229 OVERHEAD 55 878 24 QUOTES 19 NET COST The Labor Rate has been PERDE JOB COST X PROFIT 5 247 23 PROFIT SE 247 23 forwarded here from the AX Labor Rate Worksheet SALES SUMMARY LABOR B MATERIAL QUOTES X SUBTOTAL 52 000 55 JOB COST X BOND E o erret SALES 674 80 SELLIHG PRICE Sod peed ae GENERAL BIDS EXCLUSIONS SCORE PROPOSAL PRINT MANAGER ASSEMBIY MANAGER STEP 16 Double click on the Labor Hot Button DOUBLE CLICK Electrical Estimating SAMPLE BWE File Edit Recap Assembly Sheets Pricing Sheets Quotes Other Print Pricing Menu x LARBOR RATE WORESHEET JOB NAME SAMPLE RECAP ENTER PROJECT DURATION IN CALENDAR DAYS ENTER NUMBER OF WORE DAYS PER WEEE ENTER NUMBER OF WORE HOURS PER WORE DAY HA NHOUES FORWARDED FROM RECAP 663 40 WORE DAYS PROJECT DURATION 26 57 TOTAL MANDAYS 85 42 AVERAGE CREW SIZE REQUIRED 2 79 NUMBER DESCRIPTION RATE EXTENSION 540 00 550 00 25 00 This Labor Rate has been forwarded to the Recap Sheet 3 MAH CREW AVE
4. Select Quotes and Power from pulldown menu oc OF 4 PQ STEP 14 Rather than returning to the Recap Sheet lets jump to Power Quotations Using the mouse select Quotes and Power from the pulldown menu DOUBLE CLICK Electrical Estimating SAMPLE BWB File Edit Recap Assembly Sheets Pricing Sheets Quotes Other Print Pricing Menu 8 x POWER QUOTATIONS JOB SAMPLE 2 VENDOR CONTACT PHONE DATEZTIME PRICE There are two 2 power quotations shown The second quotation from West Coast Power is the lowest quote and is automatically forwarded to the Recap Sheet LOWEST QUOTE FORWARDED TO RECAP 51 075 00 5 rs W n C READY 9868 908 8 P 0 STEP 15 From the pulldown menu select Recap Bottom or use the CTRL S keys DOUBLE CLICK Electrical Estimating SAMPLE BWE File Edt Assembly Sheets Recap Recap Middle Ctrl D Recap Bottom 5 Pricing Sheets Quotes Other Print Pricing Menu JOB SAMPLE VENDOR CONTACT DATE TIME PRICE Select Recap Bottom from pulldown menu 4 6 Copyright 1998 Durand amp Associates The lower portion of the Recap Sheet is now displayed DOUBLE CLICK Electrical Estimating SAMPLE BWE File Edit Recap Assembly Sheets Pricing Sheets Quotes Other Print Pricing Menu x e
5. XO CO Fo N Q b p 13 14 15 16 1 18 19 20 ti pop Bop p d n B pd Ld bi bb Ej Hi SUBTOTAL MULTIPLIER DEFAULT 1 ASSEMBLY TOTAL 5 1 7 Copyright 1998 Durand amp Associates SAMPLE PRINTOUTS Assembly MakeUp Sheet 13 ASSEMBLY MAKEUP SHEET 13 DATE 9 15 98 DESCRIPTION SW 3G 1 1P 2 3W EST BY PAUL ITEM QTY M PRICE M EXT L UNIT L EXT EMT 3 4 17 40 37C 56 86 3 15C 0 54 EMT COUP SS DC 3 4 36 65C 0 37 5 40 05 EMT CONN 88 DC 3 4 33 69C 0 67 5 400 211 EMT STRAP 3 4 816 970 0 51 5 400 Ag GANG BOX 1 5 8 DEEP 3G 890 89C 88 91 19 80C 20 GANG RING RAISE 3 4 3G 5574 22C 5 74 9 00C 09 SW 20A IV CS120 2I 162 96C 1 63 18 00 18 SW 3W 20A IV 8320 2 251 64C 5 03 22 50C 45 WIRENUT RED 5 59C 0 22 2 70 11 PLATE SWITCH 3G IV 60 12C 0 69 4 50C 04 THHN CU SOLID 12 47 43M 7 59 4 50M 278 CO CO HP O C 2 O OG Cc C ON FR b H on ixi 15 16 17 18 19 20 t b tu Dd op d n J Di td BJ HJ b pd iu SUBTOTAL MULTIPLIER DEFAULT 1 ASSEMBLY TOTAL Assembly MakeUp Sheet 14 ASSEMBLY MAKEUP SHEET 414 DATE DESCRIPTION SW 3G 2 1P 1 4W EST BY ITEM QTY M PRICE M EXT L UNIT EMT 1 2 9 8422776 54 04 2 92C EMT COUP SS DC 1 2 522 63 50 23 4 50 EMT CONN SS DC 1 2 821 300 0 43 4 50
6. 0 32 20 THEN CU SOLID 412 3 200 547 43M 151 78 4 50M 14 40 21 WIRENUT RED 160 5 59C 8 94 2 70C 4 32 22 FLEX STEEL 1 2 40 22 20C 58 88 2 9045 1 08 23 FLEX CONN SQ DC 1 2 20 38 18C a7 a 4 50 0 90 24 E E 25 E E 26 E E 27 E E 28 E E 29 E E 30 E E 31 E E 32 E E 33 E E 34 E E 35 E E 36 E E 39 E E 38 E E 39 E E 40 E E 41 E E 42 E E 43 E E 44 E E SUBTOTAL 653 73 85 53 MULTIPLIER DEFAULT 1 X 1 00 X 1 00 SHEET TOTALS FORWARDED TO RECAP 653 73 85 53 5 5 Copyright 1998 Durand amp Associates SAMPLE PRINTOUTS Pricing Sheet 3 PRICING SHEET 3 DATE 9 15 98 JOB NAME SAMPLE EST 123 DESCRIPTION BRANCH CIRCUIT SITE LIGHTING EST BY PAUL ITEM M PRICE M EXT L UNIT L EXT PVC 40 3 4 350 17 05C 59 66 2 34C 8 19 PVC 40 ELL 3 4 14 584 04 11 77 40C 76 PVC 40 COUP 3 4 42 520 99 8 81 70 13 THHN CU SOLID 830 1 200 73 11M 87 73 A0M 48 WIRENUT GRAY 26 10 60C 2 76 60 94 GJ in N OH o p ON H LJ HF dt ii ix Bo ho PO N p m N O to MOA Om e t N QU WwW LO LO BO BJ NO BO P mA ATAU RB P C OQ J D UJ bd Pp PJ bd PE E fH DE b B Dd Pi B ti dot b tu Pi bd b tu td b b Bi DH f pio Hi ti bj opi ee D DP o pi Di ti b pci t D Di ci PJ PJ d opi p t pi
7. the program will automatically add the BWB extension List Files of Type Drives Workbks amp c 1 New filename appears on menubar 28 DOUBLE CLICK Electrical Estimating TEST BWB File Edt Recap Assembly Sheets Sheets 101165 Other Pricing Menu x XEST TZST BWB RECAP SHEET VERSION 1 04 JOB DATE EST BY EST SHEET MATERIAL LABOR Al ASSEMBLIES 21 50 2E 212 13 ASSEMBLIES 50 100 638 61 104 04 1 BRAHCH CIRCUIT POWER eea 144 2 BRANCH CIRCUIT LIGHTING S553 wu 95 53 3 BRANCH CIRCUIT SITE LIGHTING 170 73 17 50 4 FEDDER CONDUITS 2 835 47 41 48 5 HOT USED amp HOT USED 2 HOT USED 8 HOT USED 8 3 Copyright 1998 Durand amp Associates NOTE Simply type the new filename in 8 letters or less and DELETING A FILE You may not delete a file from Double Click To delete a file return to Windows and select the C EST folder EST folder lice 2 056 6 Est 2058 8 Sample 2058 8 Blank bat Sample bdt 371KB T File BwB File BB File EDT File EDT File 10 3 38 11 52 AM 10 2 38 11 00 AM 10 2 38 10 57 AM 10 2 38 10 55 AM 10 2 38 10 46 Send k 2 058KB EWE File EB File BB File BDT File 10 3 38 11 52 AM 10 2 38 11 00 10 2 38 10 57 AM 10 2 38 10 55 Cut Copy Far ee JF IKE BDT File 10 2 38 10 45 5 Create
8. EMT STRAP 1H 1 2 BIN SUC 50 39 4 50 GANG BOX 1 5 8 DEEP 3G 890 89C 8 91 19 80 GANG RING RAISE 3 4 3G 574 22C 5 74 9 00 SW 1P 20A IV 5120 21 5162 96 3 26 18 00 SW 4W 20A IV CS420 2I 51 200 00 813 98 27 00 WIRENUT RED 55 59 50 28 PLATE SWITCH 3G IV 60 12C 0 60 4 50C THHN CU SOLID 12 47 43M 6 64 4 50M p ce awn OY d WN cd e uo C p Ul rm PO PL Ew 12 E 13 14 15 16 17 18 19 20 Ej BJ fi pb dx Ej p pb or dd pn SUBTOTAL MULTIPLIER DEFAULT 1 ASSEMBLY TOTAL 5 1 8 Copyright 1998 Durand amp Associates SAMPLE PRINTOUTS Assembly MakeUp Sheet 15 DESCRIPTION ON OP NO amp NO 19 11 12 13 14 15 16 17 18 19 20 ITEM EMT 3 4 EMT COUP SS DC 3 4 EMT CONN SS DC 3 4 EMT STRAP 1H 3 4 GANG BOX 1 5 8 DEEP 3G 3G GANG RING RAISE 3 4 SW 3W 20A IV CS320 21 WIRENUT RED PLATE SWITCH 3G IV THHN CU SOLID 12 SUBTOTAL MULTIPLIER DEFAULT 1 ASSEMBLY TOTAL Assembly MakeUp Sheet 51 DESCRIPTION 1 Oi Un i U N P3 dt 10 11 12 13 14 15 16 19 18 19 20 ITEM EMT 1 2 EMT COUP SS DC 1 2 EMT CONN SS DC 1 2 EMT STRAP 1H 1 2 504 1 5D 1 2 KO SQ4 RING 1G RAISE 1 2 DUPLEX 15 IV 5320 ICP WIRENUT RED PLATE DUPLEX 1G IV CU STRANDED 12 SUBTOTAL MULTIPLIER DEFAULT 1 ASSEMBLY TOT
9. Ten 5 HOT USED HOT USED HOT USED 3 HOT USED STEP 10 Once the pricing sheet is displayed you may review the sample material items The totals at the bottom of the pricing sheets are automatically forwarded to the Recap Sheet 41 42 43 44 SUBTOTAL MULTIPLIER DEFAULT 1 x SHEET TOTALS FORWARDED TO gt gt gt NOTE total material cost and labor are forwarded to Recap Sheet TN p 9 READY 9768 3 34PM 4 4 Copyright 1998 Durand amp Associates STEP 11 Now we are going to return to the recap sheet We want to go to the quotes portion of the recap sheet Hold the CTRL key down and press D DOUBLE CLICK Electrical Estimating SAMPLE BWE 5 File Edit Recap Assembly Sheets Pricing Sheets Quotes Other Print Pricing Menu x QUOTATIONS LIGHTING LIGHTING QUOTATION SUMMARY 1 328 70 POWER POWER 1 075 00 QUOTE 1 QUOTE 2 QUOTE 3 QUOTE 4 QUOTE 5 QUOTE 6 QUOTE 7 QUOTE 8 QUOTED MATERIAL COST 2 403 70 STEP 12 Now displayed is the middle portion of the Recap Sheet This area of the recap lists the quotations Let us access the Lighting Quotation Summary by double clicking on the Lighting Hot Button DOUBLE CLICK Electrical Estimating ISAMHPLE BwB File Edit Recap Assembly Sheets Pricing Sheets Quotes Other Print Pricing Menu 8 x LIGHTING QUOTATION SUMMARY JOB SAMPL
10. about to replace the data in the current file with data from a Ckick OK to display a list of template files Double click on the template file you wish to read Load Template File Name sample bdt Path c Xest Double click on the file you want to read List Files of Type Drives Workbks bwb 1 9 1 Copyright 1998 Durand amp Associates After double clicking the program will read the template file Typical file reading times Pentium 133 MHZ 25 seconds Pentium Il 300 MHZ 14 seconds Reading Template After the template has been read all information in the active file has been replaced The filename for the active BWB remains the same Filename remains the same O DOUBLE CLICK Electrical Estimating EST BwB 5j File Edit Recap Assembly Sheets Pierrat C XEST EST B Emotes Other Print Pricing Menu RECAP SHEET JOB NAME DATE EST BY EST SHEET HATERIAL LABOR HRS Al ASSEHELIES 1 50 2 ASSEMBLIES 50100 BRANCH CIRCUIT POWER BRANCH CIRCUIT LIGHTING 3 BRANCH CIRCUIT SITE LIGHTING 4 FEDDER CONDUITS E B 8 information has changed Template files are files you create to use as a beginning point for an estimate The template files should have material items prices and labor units In a template file all quantities should be zero Let s look at the sample file assembly sheet DOUBLE CLICK Electrica
11. LABOR 300 00 24 00 PRICING SHEET MATERIAL TOTALS 58 842 89 QUOTATIONS LIGHTING LIGHTING QUOTATION SUMMARY 51 328 70 30 00 POWER POWER 51 075 00 24 00 QUOTE 1 QUOTE 2 QUOTE 3 QUOTE 4 QUOTE 5 QUOTE 6 QUOTE 7 QUOTE 8 QUOTED MATERIAL COST 2 403 70 OVERHEAD SUMMARY TOTAL LABOR HOURS 683 40 LABOR 15 4 126 00 LABOR RATE x 38 33 MATERIAL 15 1 326 43 SUBTOTAL LABOR COST 26 196 86 QUOTES 8 5192 30 5 OF LOST TIME 1 309 84 JOB COST 10 233 50 LABOR COST 27 506 70 OVERHEAD 5 878 24 MATERIAL COST 8 842 89 QUOTES 2 403 70 PROFIT SUMMARY JOB COST 2 335 00 LABOR 15 64 126 00 PRIME COST 41 088 29 MATERIAL 10 884 29 OVERHEAD 5 878 24 QUOTES 5 120 19 NET COST 46 966 53 JOB COST 5 116 75 PROFIT 5 247 23 PROFIT 5 247 23 SALES TAX 674 80 SALES TAX SUMMARY LABOR MATERIAL 6530 57 QUOTES 5144 22 SUBTOTAL 552 888 55 JOB COST BOND 1 432 77 SALES TAX 674 80 SELLING PRICE 54 321 32 5 1 Copyright 1998 Durand amp Associates SAMPLE PRINTOUTS Assembly Price Sheet 1 ASSEMBLY PRICE SHEET 1 IP DATE 9 15 98 JOB NAME SAMPLE EST 123 ASSEMBLIES 1 50 EST BY PAUL ITEM QTY M PRICE M EXT L UNIT L EXT 1 SW 1G 1 1P 1 9 50E 9 50 1 33E 1 33 2 SW 1G 1 3W 2 12 28E 24 57 1 56E 3 48 3 SW 1G 1 4W 3 899 72 68 15 1 69E 5 08 4 E m E 5 SW 28 2 1 4 13 56E 54 26 1 765 7 08 6 SW 2G 1 1P 1 3W 5 16 40E 82 02 2 01E 10 05 SW 26 Dew 6 26 89E
12. s sJ 174 GRC 1 1 4 377 44 225 GRC 1 172 458 81 C 225 GREG 2 515 18 ELER GRC 2 1 2 1 001 77 GRO 3 1 204 60 GRC 3 172 1 562 07 ib 1 GRC 4 1 825 06 1 360 GRO 5 EETA 10 GRC 5 5 072 45 C 3 804 TRADE PRICES ARE ALLIED 3 30 96 SHOW LABOR UHITS 1 0 3 Copyright 1998 Durand amp Associates WORKING IN THE DATABASE MODE In the DATABASE mode you may do the following Lookup material prices and labor units Change adjustments for material prices or labor units Enter user data for material prices and labor units Save changes to database Print database sheet Using the mouse select EMT conduit from the database menu DOUBLE CLICK Pricing k Labor PL BwB 77 File Goto Fittings Hangers Fasteners Boxes Wireway Wire Devices Power Defaults Print x Rigid EMT Aluminum Elbows Couplings Connectors IMC Rigid PWC 40 Select EMT Conduit 89000 Straps PC Duct ENT Flex LT Flex The screen now displays EMT database information CHANGING DATABASE ADJUSTMENT You may now change the adjustments by selecting a cell and typing in a new number DOUBLE CLICK Pricing Labor PL BWB OO x File Goto Conduit Fittings Hangers Fasteners Boxes Wireway wire Devices Power Defaults Print TRADE ADJ
13. 161 35 2178 1303 8 SW 2G 2 3W 7 18 24E 197 67 2 148 15 01 9 SW 2G 1 3W 1 41 8 32 26E 258 05 2 43 19 40 Jo E EB 11 SW 30 3 1P 9 29 18E 262 65 2 08E 18 73 12 SW 3G 2 1P 1 3W 10 532 025 320 24 2 335 23 33 1 SW 36 dete 2520 11 38 14E 419 54 2 65E 29 16 14 SW 36 2 1P 1 4W 12 642 5158 510 14 2 50E 29 94 15 SW 3G 3 3W 13 40 09E 521 13 2 84 36 91 16 E E 17 E E 18 E E 19 E E 20 E E 21 E E 22 E E 23 E E 24 E E 25 E E 26 E E 27 E E 28 E E 29 E E 30 E E 31 E E 32 E E 33 E E 34 E E 35 36 a E E 38 E E 39 E E 40 E E 41 E E 42 E E 43 E E 44 E E 45 E E 46 E E 47 E E 48 E E 49 E E 250 SHEET TOTALS FORWARDED RECAP 52 819 28 21 5 2 Copyright 1998 Durand amp Associates SAMPLE PRINTOUTS Assembly Price Sheet 2 ASSEMBLY PRICE SHEET 2 DATE 9 15 98 JOB NAME SAMPLE EST 123 ASSEMBLIES 51 100 EST BY PAUL ITEM QTY M PRICE M EXT L UNIT L EXT 51 DUPLEX 1 15A 14 59 69 5135 79 1 55E 21 70 52 DUPLEX 2 15 15 10 18E 152 64 1 80E 26 97 53 DUPLEX 1 20 16 14 14E 226 23 1 558 24 80 54 DUPLEX 2 20A 17 519 06 5323 95 1 80E 30 56 55 E E 56 E E 57 E E 58 E E 59 E E 60 E E 61 E E 62 E E 63 E E 64 E E 65 E E 66 E E 67 E E 68 E E 69 E E 70 E E 95 E 72 E 73 E E 74 E E 75 E E 76 29 E E 78 E E 79 E E 80 E E 81 E E 82 E E 83 E E 84 E E 85 E E 86 E E 87 E E 88 E E 89 E E 90 E E 91 92 93 E E 94 E
14. 3 05 10 2 92 EMT 3 4 3 50 10 3 18 EMT 1 4 00 C 10 3 60 EMT 1 1 4 4 50 10 4 05 EMT 1 1 2 506 10 4 95 EMT 2 7 00 10 6 30 EMT 2 1 2 9 00 G 10 8 10 EMT 3 1000 X 9 00 EMT 3 1 2 11209 C 10 9 90 EMT 4 12 09 10 10 80 C C LABOR UNITS ARE DURAND amp ASSOCIATES 2 1 98 1 0 6 Copyright 1998 Durand amp Associates WORKING IN THE ESTIMATING MODE In the ESTIMATING mode you may do the following Use the pricing sheet Import item from database to pricing sheet Print pricing sheet Use recap sheet Print recap sheet Using the mouse select Goto and Pricing Sheet commands from the pulldown menu DOUBLE CLICK Pricing k Labor PL BwB File Conduit Fittings Hangers Fasteners Boxes Wireway Wire Devices Power Defaults Print 5 Database This command will display the pricing sheet Recap Sheet PRICING SHEET Once the pricing sheet is displayed you may use the database menus to import items DATABASE MENUS DOUBLE CLICK Pricing k Labor PL BWB File Goto Conduit Fittings Hangers Fasteners Boxes Wireway wire Devices Power Defaults Print la x RECAP PRICING SHEET DATE JOE HAHE EST EST BT ITEM L EXT osm N e CO 1 0 7 Copyright 1998 Durand amp Associates DATABASE MENU DOUBLE CLICK Pricing La
15. Associates INDEX Abbreviations Active cell Adjusted labor units Adjusted pricing levels Assembly make up sheet Assembly Menu Assembly price sheet Automatic price updates Backing up your files Bonding cost worksheet Cell active Changing database adjustments Closing files Cursor down Cursor right Data entry Data import screen Data Warning Database Menu Database Mode Database screen Default Menu Default Menu Deleting files Edit Menu Edit Menu Estimating Mode Exclusions sheet File Menu File Menu Filename Flow Chart General project information Getting around Hardware requirements 13 1 7 4 10 2 10 2 7 2 6 3 10 1 12 1 6 10 7 4 10 4 8 1 7 7 7 6 6 1 6 16 9 1 7 4 10 3 7 4 7 5 7 6 8 4 7 1 7 3 10 4 6 13 7 1 7 3 8 3 2 2 6 11 4 1 1 4 14 1 Copyright 1998 Durand amp Associates INDEX continued Hot buttons How this program works Import Menu Industry standard pricing Installation Job cost worksheet Labor rate worksheet Labor units Lighting quotations Loading a blank template Loading instructions Main Menu MakeUp manager Material abbreviations Material List Module Opening files Other Menu Outgoing bids Permit cost worksheet Please wait Power quotations Pricing amp Labor Software Pricing information Pricing Menubar Pricing sheet Pricing Sheet Menu Print manager Print Menu Printing Printing database sheet Proposal sheet Quotes Menu R
16. Click has a feature called Smart Menus The program automatically displays a different menubar when working with various sheets MAIN MENUBAR 28 DOUBLE CLICK Electrical Estimating SAMPLE BWE File Edit Recap Assembly Sheets Pricing Sheets Quotes Other Print Pricing Menu x The Pricing Menu command is grayed out and is only active when working with a pricing or makeup sheet FILE MENU DEFAULT SAMPLE BWB OO xj File Edit Recap Assembly Sheets Pricing Sheets Quotes Other Print Pricing Menu x Open Open Opens a file stored on your hard disk ave Save As Close Closes current file Esport MAT Files Temple see Save Saves current file Template Head SaveAs Saves current file with a new name Template Blank Printer Setup Template Save Saves a template file E wit Template Read Heads a template file Template Blank Reads a blank template file Export MAT Files Exports files to Material List Module Printer Setup Allows you to select a printer Exit Exits Double Click returns to Windows EDIT MENU 29 DOUBLE CLICK Electrical Estimating SAMPLE BWB File Recap Assembly Sheets Pricing Sheets Quotes Other Print Pricing Meru la x Clear Active Worksheet Copy Active Worksheet Paste Clipboard Worksheet Clear Active Worksheet Clears active sheet Arrange Active Worksheet Copy Active Worksheet Non Active grayed out Paste Clipboard Worksheet Non Active
17. Durand amp Associates SAMPLE PRINTOUTS Permit Cost Worksheet PERMIT COST CALCULATION JOB NAME SAMPLE DESCRIPTION COST EACH EXTENSION LOT PRICE 450 00 450 00 PERMIT TOTAL FORAWRDED TO JOB COST WORKSHEET 5450 00 Bonding Cost Worksheet BONDING COST WORKSHEET JOB NAME SUBTOTAL FROM RECAP 542 888 BREAK POINT AMOUNT RATE 825 000 09 25 000 00 550 000 00 25 000 00 45 000 00 2 888 55 100 000 00 5 BONDING COST FORWARDED TO RECAP 5 1 2 Copyright 1998 Durand amp Associates SAMPLE PRINTOUTS Assembly MakeUp Sheet 1 ASSEMBLY MAKEUP SHEET 1 DATE DESCRIPTION SW 1G 1 1P EST BY ITEM M EXT L UNIT EMT 1 2 17 523 77 54 04 2 92C EMT COUP SS DC 1 2 1 22 63C 0 23 4 50 EMT CONN SS DC 1 2 21 30C 50 43 4 50C EMT STRAP 1H 1 2 512 000 0 39 4 50 C 504 1 5D 1 2 KO 103 97C 1 04 22 50 SQ4 RING 1G RAISE 1 2 60 170 0 60 A 50C SW 1P 20A IV CS120 2I 162 96C 1 63 18 00C PLATE SWITCH 1G IV 20 04C 0 20 22980 THHN CU SOLID 2 47 43M 0 95 4 50M Ui BP N cH O CO xi Ei 12 13 14 15 16 17 18 19 20 t Ed Di pci D pm on bb PE op Ff p SUBTOTAL MULTIPLIER DEFAULT 1 ASSEMBLY TOTAL Assembly MakeUp Sheet 2 ASSEMBLY MAKEUP SHEET 2 DATE DESCRIPTION SW 1G 1 3W EST BY ITEM QTY M PRICE M EXT L UNIT EMT 1 2 17 823 77 54 04 2 92
18. INFORMATION SHEET 1 LIST OF BIDS 1 LIST OF EXCLUSIONS 1 SCOPE OF WORK 1 TITLE PAGE 1 PROPOSAL SHEET Most forms or worksheets forward their totals to the recap sheet Some worksheets forward totals directly to the recap sheet while others do the forwarding indirectly On the next page is a flow chart graphically illustrating how these worksheets interact Please take a few minutes to review the flow chart on the next page before proceeding further 2 1 Copyright 1998 Durand amp Associates SNOISTh2X3 5018 31111 40 1811 JO 1811 OdNI SI NHOJ GALOANNOO NON 9 L 8 1 Sql1ono 5910 OSIN AHVININQS S3lono 5910 H3MOd 1 35 dOdV 1 9 OL 001 16 09 1 Sd 1 3 VIN Sd 1 3 VIN 81 1 SLAAHS c 133HS LASHS SIVLOL SIVLOL A I8IN3SSV A I8IN3SSV eO L dHVMIJOS SNILVINILS3 IVOId194 13 YONO 318n0 AO 1d LAAHSMYOM 1509 1433 3 dVO3d l33HS4HOM 1SOO LAAHSMYOM 1509 LAAHSMYOM 1SOO ONIGNO Copyright 1998 Durand amp Associates 2 2 HECAP SHEET Quantity 1 The recap sheet totals the information forwarded from the other worksheets This is where you input direct job cost overhead profit taxes etc You may also choose which prici
19. LABOR lost imo 683 40 LABOR RATE x 38 33 SUBTOTAL ZABOR COST 26 196 56 2 OF LOST TIME 1 309 84 LABOR COST 627 506 70 MATERIAL COST 58 842 89 QUOTES 52 403 70 COST s2 PRIME COST 541 088 29 OVERHEAD 55 878 24 515 966 53 PROFIT items Bg 207 2 2 Enter cost of items 552 888 2 C EI sido 221742 PROPOSAL Copyright 1998 Durand amp Associates ASSEMBLY PRICE SHEET Assembly descriptions forwarded from makeup sheets RECAP JOB ASSEMBLIES 1 ITEM SW 1G SW 1G SW 1G SAMPLE SW SW 2 ZW 2 2G els els 25 ww Des RES e o 2 sU sU sU sU als als als als RO M 3 3 RO RO RO C RJ CO CO 1 DO n2 oo cn Typical ra hot cells A A A A 0 DO DO DO D bp C x CO CO PO D OO CD dm LC SHEET TOTALS FORWARDED TO EECAP Material costs forwarded from makeup sheets ASSEMBLY PENE SHEET 1 23 512 522 513 S16 26 18 532 5239 532 538 542 240 28 fe 55 40 89 24 26 18 14 51 09 Er Er Dr Dr Dr Er Er Er Er Dr Er Er F F DG Dr Dr E Enter quant
20. SS DC 1 2 S22 63C s 0 23 4 500 EMT CONN SS DC 1 2 S21 30 C 20 43 amp 50C EMT STRAP 1 2 512 90 0 39 4 50C 504 1 5D 1 2 KO 5103 97 51 04 224001 SQ4 RING 1G RAISE 1 2 60 17 0 60 1 500 DUPLEX 20A IV 5342 I 5486 30 59 72 22 50 WIRENUT RED 55 590 0 17 2 70C PLATE DUPLEX 2G IV 40 08C 0 40 2 69 C i0 THHN CU SOLID 12 47 43M 2 04 4 50M 11 12 13 14 15 16 17 18 19 20 51 Ul N P3 L3 LS PO PS C C gt Ed t b Pd dab PJ pui b amp t td Epi p ti p bj Pa SUBTOTAL MULTIPLIER DEFAULT 1 ASSEMBLY TOTAL 5 21 Copyright 1998 Durand amp Associates SAMPLE PRINTOUTS Material List Printout from Material List Module MATERIAL LIST JOB UNTITLED FILE C EST MAT2 BWB FILE C EST MAT2 BWB DATE 09 01 98 DATE 09 01 98 ITEM ITEM WIRENUT RED 51 EMT 1 WIRENUT CRAY 52 DUPLEX 20A TV 5342 1 THHN CU STRANDED 300 23 DUPLEX 15A IV 5320 ICP THHN CU STRANDED 3 0 54 DUPLEX 15A IV 5242 1 THHN CU STRANDED 812 55 BUSHING PLASTIC 3 THHN CU SOLID 12 56 BUSHING PLASTIC 2 THHN CU SOLID 10 57 MATERIAL LIST JOB UNTITLED LO uk SW 4W SW 3W SW lP SW 1 50411 20 5420 21 20 IV CS320 21 20 IV CSl20e21 15A IV CS115 2I COVER BLANK 2 1D T EO 58 59 60 61 62 63 50411 SQ4 RING 2G RAISE 1 2 64 SQ4 RING 1G
21. Shortcut Rename Select the Delete command Properties Windows will ask if you are sure you want to send the file to the Recycle Bin Confirm File Delete Are sure want to send Test to the Recycle Bin Click YES to delete file File has been deleted 2 058 BB File 10 2 38 11 00 AM 2 058 BB File 10 2 38 10 57 AM 3BBKB File 10 2 38 10 55 Sarnple bdt 1 5 BDT File 10 2 38 10 46 EI Est LST File 10 2 38 10 43 AM 1 nbject s selected 172KB NOTE Windows will not let you delete a file that is in use 8 4 Copyright 1998 Durand amp Associates TEMPLATE FILES You may save or read template files Template files differ from regular BWB files in that they have a BDT extension READING TEMPLATE FILES To read a template file select File and Template Read commands from the pulldown menu DOUBLE CLICK Electrical Estimating EST BwB Oy xj a Edit Recap Assembly Sheets Pricing Sheets Quotes Other Print Pricing Menu x Open Close Save Save As Export MAT Files Template Save 111 This command will start the template read process Template Blank Printer Setup E wit DATA WARNING When you read a template file all information in the active file will be replaced with the information from the template file Data Warming template file Are you shure you want to replace this data e You
22. Z0 E E 21 E E 22 E E 23 24 25 26 E E 27 28 29 E E 30 E E 31 E E 32 E E as E F 34 E E 25 E E 36 E E 37 E E 38 E E 39 40 E 41 E 42 amp 3 E E 24 SUBTOTAL 9975 44 MULTIPLIER DEFAULT 1 X 1 00 X SHEET TOTALS FORWARDED TO gt gt gt RECAP 5975 44 1 0 1 1 Copyright 1998 Durand amp Associates Using the mouse select Goto and Recap Sheet from the pulldown menu DOUBLE CLICK Pricing k Labor PL BwB Em File Conduit Fittings Hangers Fasteners Boxes Wireway Wie Devices Power Defaults Print 2 x Datahase Pricing Sheet Recap Sheet This command will display the recap sheet RECAP SHEET Enter date and estimate number E DOUBLE CLICK Pricing amp Labor PL Bw B E File Goto Conduit Fittings Hangers Fasteners Boxes Wireway wire Devices Power Defaults Print BHE RECAP SHEET Enter job name JOB HAME EST BY and estimator s NERSGION 1 LABOR HRS 1111 19 02 MISC MATERIAL amp LABOR QUOTED MATERIAL COST TOTAL MATERIAL COST SUMMARY gt gt gt PROFIT SALES TAX SELLING PRICE 975 44 PRINT RECAP SHEET If you want to print the recap sheet select Print and Print Recap commands from the pulldown menu DOUBLE CLICK Pricing amp Labor PL BwB Ej File Goto Conduit Fittings
23. bd ri p D dd tg bd p DJ tu RS d SUBTOTAL 170 73 17 50 MULTIPLIER DEFAULT 1 X 1 00 X 1 00 SHEET TOTALS FORWARDED TO gt gt gt RECAP 5170 73 17 50 5 6 Copyright 1998 Durand amp Associates SAMPLE PRINTOUTS Pricing Sheet 4 PRICING SHEET 4 DATE 9 15 98 JOB NAME SAMPLE EST 123 DESCRIPTION FEDDER CONDUITS EST BY PAUL i ITEM M EXT L UNIT L EXT 1 egg 60 369 11C 221 46 9 00 5 40 2 GRC 3 120 963 45C 1 156 14 12 600 15 12 3 GRC ELL 2 2 886 55C 8297244 63 00C 1 26 4 GRC ELL 3 3 2 946 91C 88 41 112 50 3 38 5 GRC COUP 2 6 207 67C 12 46 13 50 0 81 6 GRC COUP 3 10 785 84C 78 58 22 50 2 25 i LOCKNUT 2 4 58 66C 2 35 8 10C 0 32 8 LOCKNUT 3 4 5227 189 9 08 13 50C 0 54 9 BUSHING PLASTIC 2 2 75 17C 1 50 9 00 0 18 10 BUSHING PLASTIC 3 217 51C 4 35 13 50C 0 27 11 THHN CU STRANDED 3 0 240 1 305 15M 313 24 15 30M 3 67 12 THHN CU STRANDED 300 400 2 325 39M 930 16 20 70M 8 28 13 E E 14 E E 15 E E 16 E E 17 E E 18 E E 19 E E 20 E E 2 E E 22 E E 23 E E 24 E E 25 E E 26 E E 27 E E 28 E E 29 E E 30 E E 31 E E 32 E E 33 E E 34 E E 35 E 36 E E 37 E E 38 E E 39 E E 40 E E 41 E E 42 E 43 44 E SUBTOTAL 2 835 47 41 48 MULTIPLIER DEFAULT 1 I X 1 00 X 1 00 SHEET TOTALS FORWARDED TO gt gt gt RECAP 52 035 47 41 48 5 7 Copyright 1998 Durand amp Associates SAMPLE PRINTOUTS Lighting Quotation S
24. bdt sample Enter new filename then click OK List Files of Type Drives NOTE Simply type the new filename in 8 letters or less and 80 Files bdt BITS the program will automatically add the BDT extension 9 3 Copyright 1998 Durand amp Associates Always save input cells Always select input cells Q Input Cells and Formula Results all celts NOTE Always save input cells Saving in any other format will result in loss of data LOAD A BLANK TEMPLATE Select the File and Template Blank commands from the pulldown menu 22 DOUBLE CLICK Electrical Estimating EST BwB I xj 1 Edit Recap Assembly Sheets Pricing Sheets uates Other Print Pricing Menu Open Close Save Save As Export MAT Files Template Save Template Read Template Blank This command will load a blank template Printer Setup Exit Template Blank command is useful in clearing all data from the file DELETING TEMPLATE FILES Using Windows you may delete template BDT files the same way as you delete BWB files 9 4 Copyright 1998 Durand amp Associates PRICING amp LABOR SOFTWARE Included with your purchase of your Double Click Electrical Estimating Software is a FREE 1 Year subscription to the Pricing amp Labor Software The installation program will automatically install your first pricing update You will automatically receive updated prices every four 4 months Two additi
25. grayed out Arrange Active Worksheet Non Active grayed out RECAP MENU 28 DOUBLE CLICK Electrical Estimating SAMPLE BWB File Edt af Assembly Sheets Pricing Sheets Quotes Other Print Pricing Menu 8 x Hecap Top tr R Recap Middle Ctrl D Recap Bottom Ctrl 5 Recap Top Displays top portion of recap sheet Recap Middle Displays middle portion of recap sheet Recap Bottom Displays bottom portion of recap sheet 7 1 Copyright 1998 Durand amp Associates ASSEMBLY MENU 28 DOUBLE CLICK Electrical Estimating SAMPLE BwB File Edt Recap 20 002213 Pricing Sheets Quotes Assembles 1 50 Assembles 51 100 MakeUp 1 10 MakeUp 11 20 MakeUp 21 30 MakeUp 31 40 MakeUp 41 50 MakeUp 51 50 MakeUp 61 70 MakeUp 71 80 MakeUp 61 90 MakeUp 91 100 w ww xr w w w FF w PRICING SHEET MENU Other Pricing Menu 18 Assemblies 1 50 Displays Assembly Price Sheet 1 Assemblies 51 100 Displays Assembly Price Sheet 2 MakeUp 1 100 Displays selected makeup sheet 28 DOUBLE CLICK Electrical Estimating SAMPLE BWB File Edit Recap Assembly Sheets Quotes Oth Pricing Sheet 1 Pricing Sheet 2 QUOTES MENU Pricing Sheet 17 Pricing Sheet 18 er Print Pricing Menu 1 1 Pricing Sheet 1 18 Displays selected pricing sheet 2 DOUBLE CLICK Electrical Estimating S amp MPLE B wB File Edt Recap Ass
26. your database and lookup prices and labor units When using the DATABASE mode you may lookup any price change any discount or enter your own prices Any changes you make to the database can be saved to the hard disk In this mode you may also print out any page from the database There are over 900 pages of pricing and labor information in the database ESTIMATING MODE In the ESTIMATING mode you can use the pricing sheet with both prices and labor units use a recap sheet to summarize your selling price and printout an estimate This ESTIMATING mode is ideal for change orders or estimating small jobs you need to prepare large estimates you should use the Double Click Electrical Estimating Program STARTING THE PROGRAM Double click on the PL icon located on the desktop This will start your Pricing amp Labor Software The program automatically loads the default file PL BWB at start up When you receive your program this file is blank Program File loading times Pentium 133 MHZ 12 seconds Pentium Il 300 MHZ 5 seconds Once the programs starts it will display the database screen for rigid conduit DOUBLE CLICK Pricing amp Labor IPL BwB File Goto Conduit Fittings Hangers Fasteners Boxes Wireway wire Devices Power Defaults Print 8 x MATERIAL TRADE P ADJUST ADJUSTED USER PRICE E 0 PRICE PRICE GALVANIZED RIGID CONDUIT ITEM 1 2 5151 56 590 GRC 3 4 2193 88 115 GREC 1
27. 2 60 17C 0 60 4 50 DUPLEX 15A IV 5320 42 30C 0 22500 WIRENUT RED 5 59C 0 17 2 908 PLATE DUPLEX 2G IV 40 08C 0 40 3 60 THHN CU SOLID 12 547 43 52 04 4 50M e on ON LJ N E ODO gt 18 19 20 E t Pd p Pd ci di Ej tj ti pi pbi tu Dd pd SUBTOTAL MULTIPLIER DEFAULT 1 ASSEMBLY TOTAL Assembly MakeUp Sheet 53 ASSEMBLY MAKEUP SHEET 53 DATE DESCRIPTION DUPLEX 1 20A EST BY ITEM M PRICE M EXT L UNIT EMT i74 17 Bas 7C 4 04 2 92 EMT COUP SS DC 1 2 592 530 90 23 4 50C EMT CONN SS DC 1 2 521 200 50 43 4 50C EMT STRAP 1H 1 2 S12 90C 50 39 4 50C 504 1 50 1 2 5103 87 0 51 04 22 50C SQ4 RING 1G RAISE 1 2 550 170 50 60 4 50C DUPLEX 20 IV 5342 486 30C 4 86 24 900 WIRENUT RED 834591 0 17 d QC PLATE DUPLEX 1G IV 20 04 0 20 2 70 10 THHN CU STRANDED 12 54 66M 25219 4 50M 11 12 L3 14 15 16 17 18 19 20 e on LJ ut C FW p C C C Bob tu bt p otc Ei bj r d PJ op t Ei SUBTOTAL MULTIPLIER DEFAULT 1 ASSEMBLY TOTAL 5 20 Copyright 1998 Durand amp Associates SAMPLE PRINTOUTS Assembly MakeUp Sheet 54 ASSEMBLY MAKEUP SHEET 54 DATE DESCRIPTION DUPLEX 2 20A EST BY ITEM QTY M PRICE M EXT L UNIT EMT 1 2 S23 77C 4 04 EMT COUP
28. 29 E E 30 E E 31 E E 32 E E 33 E E 34 E E 35 E E 36 E E 37 E E 38 E E 39 40 41 42 43 44 E E SUBTOTAL i 1 225 09 144 73 MULTIPLIER DEFAULT 1 X 1 00 X 1 00 SHEET TOTALS FORWARDED gt gt gt 1 225 09 144 73 5 4 Copyright 1998 Durand amp Associates SAMPLE PRINTOUTS Pricing Sheet 2 PRICING SHEET 2 DATE 9 15 98 JOB NAME SAMPLE EST 193 DESCRIPTION BRANCH CIRCUIT LIGHTING EST BY PAUL ITEM QTY M PRICE M EXT L UNIT L EXT 1 EMT 1 2 800 233 770 190 18 2 922 23 40 202 EMT 3 4 230 40 37C 92 86 3 15 7 98 3 EMT 1 60 68 96C 41 38 3 60C 2 16 4 EMT COUP SS DC 1 2 96 522 530 R 4 50 4 32 5 COUP SS DC 3 4 28 36 65C 510 26 5 40C 1 51 6 EMT COUP SS DC 1 8 59 89C 4 79 7 20C 0 58 7 CONN SS DC 1 2 54 21 30C 11 50 4 50C 243 8 EMT CONN SS DC 3 4 16 533 69 5 39 5 40C 0 86 9 EMT CONN SS DC 1 55 48C 1 11 6 30C 0 13 10 EMT STRAP 1H 1 2 200 12 90C 25 80 4 50C 9 00 11 EMT STRAP 1H 3 4 58 516 970 9 84 5 40C 3 13 12 EMT STRAP 1 15 828 04 54 21 7 300 1 08 13 SQ4 1 5D COMBO 39 5109 00 523 98 22 50C 4 95 14 50411 2 1D 1 KO 2 277 80C 5 56 22 50C 0 45 15 SQ4 COVER BLANK 10 40 54C 4 05 4 50C 0 45 16 SQ411 COVER BLANK 2 72 34C 1 45 5 40 2141 17 SQ4 RING 1G RAISE 1 2 12 560 17 93 24 4 50 0 54 18 SW 1P 15A IV 8115 2 12 106 62C e179 18 00C 2 16 19 PLATE SWITCH 1G IV 20 04C 2 40 2 70
29. 50 130 140 52 16 46 20 8 250 113 26 60 4 10 4 50 50 50 4 800 210 5 23 M PRICE PER Copyright 1998 Durand amp Associates DATA ENTRY GENERAL Screens are divided into four 4 cell types listed below 1 FIXED CELLS No entry allowed MATERIAL 22 019 25 The fixed cells have black letters on a gray back 2838 51 ground You may enter data in a fixed cell If you 1 225 03 try you will get an error message protected cell 5553 73 170 73 22 035 47 the X on or off 3 ENTRY CELLS Input numbers or letters The entry cells have blue letters on a yellow back ground With the mouse activate the cell and from the keyboard type in the numbers or letters LIGHTING POWER QUOTE QUOTE 2 4 HOT CELLS Double click to select item QUOTE 3 QUOTE 4 The hot cells have red letters on a gray background Simply double click on the cell to select an item QUOTE 5 QUOTE 6 QUOTE 7 QUOTE 5 6 1 Copyright 1998 Durand amp Associates 2 AUTOMATIC CELLS Double click to toggle The automatic cells have red letters on a green background Simply double click on the cell to toggle RECAP SHEET Enter estimator s name Enter the name of the project EST JOB EST BY SHEET Al ASSEMBLIES 1 50 2 ASSEMBLIES 650 100 1 BRANCH CIRCUIT POWER 2 BR
30. AL ASSEMBLY MAKEUP SHEET 15 SW 3G 3 3W QTY px pa Qo ASSEMBLY MAKEUP SHEET 51 e DWF WwW M PRICE 40 S36 533 516 890 574 5251 560 547 DUPLEX 1 15A M PRICE OTY 17 1 2 3 1 1 1 d 1 0 4 523 522 521 12 103 560 542 S5 20 554 5 19 65 C 69 C 97 C 22 64C 59 12 C td pi Dd PJ Di bi Bi Pd Ei 63 C 30 C 90 C 97 C 17 C 2290 04 66M E PJ Bi cd pi bj bd dud mi 43M M EXT Sus 50 0 0 8 S5 50 S0 58 86 37 67 51 91 74 55 34 60 54 DATE EST BY L UNIT 24 15 C 5 40 C 5 40C 5 40C 19 80 C 9 00C 50 C 70C 50 C 50 M E Hee ob Fj BH op HE DATE EST BY M EXT 4 50 0 50 51 50 50 80 0 52 04 23 43 38 04 60 42 17 20 12 L UNIT CER EIS 4 50C 4 50 4 50 44 505 4 50C 22 50 C 2 70C 2 70 C 4 50M oo O coc O bj PJ Dd tu Copyright 1998 Durand amp Associates SAMPLE PRINTOUTS Assembly MakeUp Sheet 52 ASSEMBLY MAKEUP SHEET 52 DATE DESCRIPTION DUPLEX 2 15A EST BY ITEM QTY M PRICE M EXT L UNTT EMT 1 2 17 5472772 4 04 2 92C EMT COUP SS DC 1 2 E 522 63 0 23 4 50C EMT CONN SS DC 1 2 21 30C 0 43 4 50C EMT STRAP 1H 1 2 12 90C 0 39 50 504 1 55 1 2 KO 103 97C 1 220 500 SQ4 RING 1G RAISE 1
31. ANCH CIRCUIT LIGHTING a BRANCH CIRCUIT SITE LIGHTING 4 EDDER CONDUITS Double click to 8 toggle on and off X 10 If you want the 11 assembly or pricing 1 sheet totals 13 forwarded to recap 14 cell must have X 15 17 18 HISC MATERIAL amp LABOR PRICING SHEET MATERIAL TOTALS QUOTATIONS LIGHTING LISHTING QUOTATION SUMMARY POWER POWER QUOTE 1 2 Typical OUOTE 4 hot cells QUOTE 5 QUOTE 6 QUOTE 7 QUOTE 8 QUOTED MATERIAL COS Enter 96 OVERHEAD SUMMARY LABOR 24 MATERIAL X 1 326 43 QUOTES lt 192 30 JOB COST S2 3 SN OVERHEAD 5 878 24 PROFIT SUMMARY LABOR 4 MATERIAL X 25 QUOTES Silen 15 JOB COST X 116 75 PROFIT 5 SALES TAX SUMMARY Enter sales tax LABOR MATERIAL S53D 57 QUOTES 144 22 JOB COST X SALES T X 574 80 GENERAL Es 1115311111 PRINT HAHAGER ASSEMBLY MANAGER HOT HOT HOT HOT HOT HOT HOT HOT HOT HOT HOT HOT HOT HOT SALES TAX SUBTOTAL BOND SELLIHG FRICE SEURE RECAP SHEET USED USED USED USED USED USED USED USED Enter misc material cost Enter quote labor Enter estimate number Enter date VERSION DATE M MATERIAL LABOR 2 019 25 838 51 104 04 Si eem Mg 144 73 553 73 eS 170 73 17 50 pores 41 48 Enter misc labor 58 042 99 51 175 00 if necessary Enter 96 TOTAL
32. ASSEMBLY MAKEUP SHEET 5 DATE DESCRIPTION SW 2G 2 1P EST BY ITEM QTY M PRICE M EXT L UNIT EMT 1 2 17 523 77C 4 04 2 4 EMT COUP SS DC 1 2 1 222 030 0 23 4 50C EMT CONN SS DC 1 2 821 30 0 43 4 50C EMT STRAP 1H 1 2 12 90C 0 39 4 50 04 1 5D 1 2 KO 103 97C 1 04 BUD SQ4 RING 2G RAISE 1 2 S82 63C 50 83 502 SW 20A IV CS120 2I 162 96C 53 26 00 C WIRENUT RED 5 58C 0 11 70C PLATE SWITCH 2G IV 40 08C 0 40 60C THHN CU SOLID 12 47 43M 52 85 50M Ov Ul 4 w N 3k oo 12 13 14 15 16 17 18 19 20 He pi fee bi Bl amp ti pj td p b bd pn bp p SUBTOTAL MULTIPLIER DEFAULT 1 ASSEMBLY TOTAL 5 1 4 Copyright 1998 Durand amp Associates SAMPLE PRINTOUTS Assembly MakeUp Sheet 6 ASSEMBLY MAKEUP SHEET 6 DATE DESCRIPTION SW 2G L LP 1 3 EST BY ITEM QTY M PRICE M EXT L UNIT EMT 1 2 S23 77C 4 04 2 92 C COUP SS DC 1 2 522 63 50 23 4 50C EMT CONN SS DC 1 2 521 230 0 43 4 50C EMT STRAP 1 2 18 900 50 29 4 50 504 1 5D 1 2 KO 5103 97 51 04 24 500 SQ4 RING 2G RAISE 1 2 S82 63C 0 83 4 50C SW LP 20 IV CS120 21 S162 96C 51 63 18 00C SW 3W 20A IV 5320 21 5251 64 2 52 22 500 WIRENUT RED 55 590 S0 17 2 70C PLATE SWITCH 2G IV 40 08C 0 40 350 THHN CU SOLID 12 47 43M 54 74 4 50M 12 E 13 14 15 16 17 18 19 20 LA J Ce co Ul H
33. DEFAULT 1 E E ASSEMBLY TOTAL 4 3 Copyright 1998 Durand amp Associates STEP 8 You may access any sheet at any time Let us return to the Recap Sheet by using the CTRL R keys DOUBLE CLICK Electrical Estimating SAMPLE BWE File Edit Recap Assembly Sheets Pricing Sheets Quotes Other Print Pricing Menu RECAP SHEET DATE EST MATERIAL LABOR HES ASSEMBLIES 1 50 2 819 28 212 13 ASSEMBLIES 5 0 100 8390 61 104 04 BRANCH CIRCUIT POWER sj 22503 144 73 BRANCH CIRCUIT LIGHTING 653 73 BD 53 a BRAHCH CIRCUIT SITE LIGHTING 170 73 17 50 4 FEDDER COHDUITS 2 035 47 41 48 5 USED HOT USED HOT USED n WAT Ten STEP 9 The program has 18 Pricing Sheets per estimate and the Sample Estimate uses Pricing Sheets 1 4 To access a Pricing Sheet 1 double click on the pricing sheet number DOUBLE CLICK Electrical Estimating SAMPLE BWE File Edit Recap Assembly Sheets Pricing Sheets Quotes Other Print Pricing Menu C XEST SAMPLE BWB RECAP SHEET VERSION 1 JOB C SAMPER M e EST BY At certain times you will see the Please SHEET Wait dialog box Our tests indicate a wait l ASSEMBLIES 1 50 m ue m time of 3 seconds on a 133 MHZ iacu BRANCH CIRCUIT 1 2 seconds a 300 MHZ machine 23 2 BRANCH CIRCUIT LIGHTING 53 a 17 50 4 2 835 47 41 48
34. E RECEP VENDOR PRICE VENDOR 1 ABC SUPPLY 1 378 22 VENDOR 2 LOW BID SUPPLY 1 328 70 VENDOR 3 VENDOR 4 There are two 2 lighting quotations shown The second VENDOR 5 quotation from Low Bid Supply is the lowest quote and is automatically forwarded to the Recap Sheet VENDOR 6 LOWEST PRICE FORWARDED TO RECAP CE STEP 13 To view a breakdown of the Low Bid Supply double click on Vendor 2 DOUBLE CLICK Electrical Estimating SAMPLE BWB File Edit Recap Assembly Sheets Pricing Sheets Quotes Other Print Pricing Menu im xl LIGHTING FIXTURE QUOTATION FROM VENDOR 2 JOB NAME SAMPLE A VENDOR TIME CONTACT DATE PHONE FAX QTY PRICE EA QTY PRICE EA EET 1 18 2 2 3 2 4 2 5 2 6 2 7 2 B 2 3 10 Displayed is the cost breakdown for this quote 11 The price is automatically forwarded to the 12 Lighting Quotation Summary 13 15 15 16 iy 18 VENDOR TOTAL FORWARDED TO LIGHTING QUOTATION gt gt gt SUMMARY Cel 328 70 5 4 5 Copyright 1998 Durand amp Associates DOUBLE CLICK Electrical Estimating SAMPLE BWE File Edit Recap Assembly Sheets Pricing Sheets Other Print Pricing Menu 8 x LIGHTING FIXTURE QUOTATION FROM VE Lighting JOB SAMPLE E YENDOR Power TIME CONTACT Quote 1 DATE PHONE Quote 2 Quote 3 Quote4 um Quote 5 Quote 6 Quote 7 Quote 8
35. E 95 E E 96 E E 97 E E 98 E E 99 E E 100 E E SHEET TOTALS FORWARDED TO RECAP 838 61 104 04 5 3 Copyright 1998 Durand amp Associates SAMPLE PRINTOUTS Pricing Sheet 1 PRICING SHEET 41 DATE 9 15 98 JOB NAME SAMPLE EST 123 DESCRIPTION BRANCH CIRCUIT POWER EST BY PAUL ITEM QTY M PRICE M EXT L UNIT L EXT 1 EMT 1 2 1 200 503 285 26 2 990 35 10 2 EMT 3 4 450 240 37 5181 68 3 15C 14 18 3 EMT 1 130 68 96C 89 65 3 60 4 68 4 EMT COUP SS DC 1 2 140 22 63C 31 68 4 50C 6 30 5 EMT COUP SS DC 3 4 52 36 65C 19 06 5 40 2 81 6 EMT COUP SS DC 1 16 59 89C 9 58 79296 1 15 7 EMT CONN SS DC 1 2 46 521 30 9 79 4 50C 2207 8 CONN SS DC 3 4 20 33 69C 6 74 5 40C 1 08 9 EMT CONN SS DC 1 8 55 48C 4 44 6 30C 0 50 10 EMT STRAP 1H 1 2 260 812 900 533 54 4 50C 11 79 11 EMT STRAP 1H 3 4 DI 16 97C 19 18 5 40C 6 10 12 EMT STRAP 1H 1 26 28 04C 5 49 7 20 1 87 13 504 1 55 COMBO 60 109 00C 565 40 22 50 13 50 14 80411 3 15 1 KO 4 277 80C 22 50 0 90 15 SQ4 COVER BLANK 10 40 54C 4 05 4 50C 0 45 16 50411 COVER BLANK 4 72 340 62 89 5 40C 0 29 17 SQ4 RING 1G RAISE 1 2 50 460 17 30 09 4 50C 2 25 18 DUPLEX 15A IV 5242 I 50 328 44C 164 22 22 506 11 25 19 PLATE DUPLEX 1G IV 50 520 04 10 02 2 70 1 35 20 THEN CU SOLID 12 4 800 47 43M 227 66 4 50M 21 60 21 WIRENUT RED 210 5 59C 511 73 2 70 5 67 pr E E 23 E E 24 E E 25 E E 26 E E 27 E E 28 E E
36. E 5 08 4 E E 20 2 1P 13 56 E 254 26 1 76 E TRIS 501 2G 1 1P 1 30 15 40 E 582 02 2 01 171 et 1 1P 1 4W 25 89 E 5161 35 15 Ma 8 SW 2G 2 3W 18 24 E 127 67 2 14 E 15 D1 SW NG 1 3W 1 4W 32 26 E 2258 05 2 43 E 19 40 10 E E 11 3 2 3 4 29 18 E 262 65 2 08 E 18 73 12 35 A 1P 1 30 32 02 E 320 24 2 33 E 23 33 SW 35 INP 2 30 38 14 E 419 54 2 65 E 29 16 14 SW 3G 2 1 1 40 42 51 E 510 14 2 50 29 94 SW 3G 3 3 40 09 E sb 2 94 E 36 91 16 E E 17 E E 18 E E 1 E 20 Assembly Price Sheet 1 in now displayed The first E 21 assembly is a 1 gang 1 pole switch To access the E 25 assembly MakeUp Sheet 1 double click on the 1 28 E 5 E E HT READY 9768 116PM P 0 STEP 7 Double click on 1 to display MakeUp 1 DOUBLE CLICK Electrical Estimating 5 File Edit Conduit Fittings Hangers Fasteners Boxes Wireway Wire Devices Power Defaults Main Menu 18 x ASSEMSLY SHEET ASSEMBLY MAKEUP SHEET 1 DATE 9 15 98 DESCRIPTION EST PAUL H EXT L UHIT LEET ER 4 04 0 50 2 Sj 23 0 04 3 0 43 0 09 4 0 39 0 14 5 51 04 0 23 20 50 0 04 0 19 B 50 20 0 03 9 0 09 10 11 12 13 14 gt NOTE The total material cost and labor T are forwarded to Assembly Price Sheet 18 1 as shown above 13 SUBTOTAL 9 50 15222 MULTIPLIER
37. E DATE TIME PRICE ABC SUPPLY TED 988 6265 9 1 98 11AM 51 256 00 WEST COAST POWER 981 2562 9 2 98 5 1 075 00 LOWEST QUOTE FORWARDED TO RECAP 1 075 00 Labor Rate Worksheet LARBOR RATE WORKSHEET JOB NAME SAMPLE ENTER PROJECT DURATION IN CALENDAR DAYS 40 ENTER NUMBER OF WORK DAYS PER WEEK 5 ENTER NUMBER OF WORK HOURS PER WORK DAY 8 MANHOURS FORWARDED FROM RECAP 40 WORK DAYS PROJECT DURATION 57 TOTAL MANDAYS 42 AVERAGE CREW SIZE REQUIRED lt 99 NUMBER DESCRIPTION EXTENSION JOURNEYMAN 40 00 FOREMAN 50 00 HELPER 25 00 MAN CREW AVERAGE LABOR RATE FORWARDED TO RECAP 5 1 0 Copyright 1998 Durand amp Associates SAMPLE PRINTOUTS Job Cost Worksheet JOB COST WORKSHEET JOB NAME SAMPLE FIELD OFFICE EXPENSE VEHICLE EXPENSE TRAILER PICKUP PHONE FLATBED FAX CAR CELL PHONE BOOM TRUCK PAGER COMPUTER PRINTER COPY MACHINE FURNITURE RENTAL COFFEE MACHINE TOILET PROJECT MANAGEMENT EXPENSE TEMP POWER 400 00 PROJECT MANAGER 1 100 00 SUPERINTENDENT GENERAL FOREMAN FOREMAN MATERIAL HANDLER ESTIMATOR ENGINEER DRAFTSMAN SECETARY PERMIT FEE 450 00 FIELD STORAGE amp TOOLS OTHER EXPENSE STORAGE TRAILER GANG BOXES 150 00 CHAINS amp LOCKS DUMPSTER SIGN SCAFFOLDS WELDER GENERATOR TRENCHER 150 00 CONDUIT BENDER CABLE PULLER HOIST LADDERS 85 00 SUBTOTAL 3 785 00 SUBTOTAL 2 51 550 00 TOTAL FORWARDED TO RECAP 2 335 00 5 1 1 Copyright 1998
38. ED MakeUp 51 30 HOT USED MakeUp 91 100 HOT USED HOT USED Method 2 Double click on the red A1 DOUBLE CLICK Electrical Estimating SAMPLE BWwB File Edit Recap Assembly Sheets Pricing Sheets Quotes Other Print Pricing Menu RECAP SHEET 92 019 BRANCH CIRCU Hot Button 3 BRAHCH CIRCUIT SITE LIGHTING 4 FEDDER CONDUITS E Bem E HOT USED NOTE Anytime you see a Hot Button red text on the screen you may double click on the red text to activate that worksheet Method 3 You may also use one of the Quick Keys In this case hold down the CTRL key while pressing the A key For a complete list of CTRL keys see the Quick Keys card in the back of your binder After selecting Assemblies 1 50 your screen will display the assembly infor mation There are a total of 50 assembly items on this worksheet To display the lower portion of the sheet press the pagedown key or use the scroll bar 4 2 Copyright 1998 Durand amp Associates DOUBLE CLICK Electrical Estimating SAMPLE BWwB File Edit Recap Assembly Sheets Pricing Sheets Quotes Other Print Pricing Menu 8 x RECAP ASSEMBLY PRICE SHEET 1 DATE 9 15 98 JOE HAHE SAMPLE EST 123 p ASSEMBLIES 1 50 EST FAUL M EXT L UHIT L EET 09 SW 1G 1 1P 59 50 E 9 50 IPR 33 1G 1 3W 12 28 E 24 57 1 56 E aa dL 2 a SW 1G 1 4W mu 58 15 Jb d
39. EMT COUP SS DC 1 2 1 522 63 50 23 4 50C EMT CONN SS DC 1 2 521 30 0 43 4 506 EMT STRAP 1 2 12 90C 0 39 1 50 804 1 5D 172 KO 8103 9 30 1 04 22 50C SQ4 RING 1G RAISE 1 2 960 17 50 60 4 506 SW 3 20A IV 5320 21 8251 64C 52 52 22 50 PLATE SWITCH 1G IV 20 04C 0 20 2 70C THHN CU SOLID 12 47 43M 2 85 4 50M 1 Ul 4 c 40 11 12 12 14 15 16 17 18 18 20 Eri i E E E E E E E E E E E E E E E E E E SUBTOTAL MULTIPLIER DEFAULT 1 ASSEMBLY TOTAL 5 1 3 Copyright 1998 Durand amp Associates SAMPLE PRINTOUTS Assembly MakeUp Sheet 3 ASSEMBLY MAKEUP SHEET 3 DATE DESCRIPTION SW 1G 1 4 EST BY ITEM QTY M PRICE M EXT L UNIT EMT 1 2 523 776 54 04 2 92 EMT COUP SS DC 1 2 S22 63C 20 23 4 50C EMT CONN SS DC 1 2 S21 30C 0 43 4 50C EMT STRAP 1H 1 2 S12 90C 0 39 4 50C 504 1 5D 1 2 KO S103 97C 1 04 22 50C SQ4 RTNG 1G RAISE 1 2 560 17 0 60 4 50C SW 4W 20A IV CS420 2I 91 200 000 12 00 27 00 PLATE SWITCH 1G IV 20 04 0 20 2 70C THHN CU SOLID 12 47 43M 3 79 4 50M 1 Ov Ul i NO D OF R N Fe pop P gt tO Fa id 13 14 15 16 17 18 19 20 pd EJ Fd to tb oni pi i t td BE D tu bj du pj SUBTOTAL MULTIPLIER DEFAULT ASSEMBLY TOTAL Assembly MakeUp Sheet 5
40. ENSION iur IE eee B8 5450 00 a DOUBLE CLICK Electrical Estimating SAMPLE BwE Select Recap Bottom from pulldown menu File Edit Recap Assembly Sheets Pricing Sheets 55 Other Print Pricing Menu m xl a OVERHEAD SUMMARY TOTAL LABOR HOURS 683 40 LABOR S4 126 00 LABOR RATE x mi MATERIAL 1 326 43 SUBTOTAL LABOR COST 26 196 86 QUOTES DN 5 X OF LOST TIME sl 3038 JOB COST Ep LABOR COST 27 506 70 OVERHEAD 5 878 24 MATERIAL COST 0 842 99 QUOTES 2 403 70 PROFIT SUMMARY JOB COST a2 ooo LABOR Zo B PRIME COST 41 088 23 MATERIAL X 5 878 24 ee 3 The Bonding Cost has been s forwarded here from the Double click on Bond to access this worksheet Bonding Cost Worksheet BOND SALES TAX 5574 GENERAL BILS EXCLUSIONS SERIES PROPOSAL PRINT MANAGER ASSEMBLY MAHAGER STEP 21 4 9 Double click on the Bond Hot Button Copyright 1998 Durand amp Associates DOUBLE CLICK Electrical Estimating SAMPLE BWB File Edit Recap Assembly Sheets Pricing Sheets Quotes Other Print Pricing Menu 8 x BONDING COSI WORKSHEET JOB NAME SAMPLE RECAP SUBTOTAL FROM RECAP 62 898 55 BREAK POINT AMOUNT RATE 1ST TIER 25 000 00 750 00 2ND TIER 25 000 00 625 00 This Bondin h 3FD Sond 9 Cost has BE been forwarded to the P Recap S
41. EW COVER TYPE SINGLE DOOR SKIP A DAY TYPE SERVICE ENTRANCE CABLE SERVICE SELF GROUNDING SERVICE ENTRANCE LB SHEET METAL CREWS SQUEEZE TYPE SQUEEZE TYPE INSULATED 4 SQUARE BOX 4 11 16 SQUARE BOX SET SREW TYPE STAINLESS STEEL 13 5 Copyright 1998 Durand amp Associates SS SSD SSW SSW STRAND STRUT STRUT STRUT BRACKET DOUBLE STRUT BRACKET SINGLE STRUT CLAMP STRUT CLIP STRUT S NUTS STRUT S STUDS STRUT STRAP SUPP SW SW REC SWPL SWSW T T CLOCK T SCREW TC TLM TOG TOMIC TOMIC I U CARPET W B W BAR W BKT W N WH WP X XF XP SET SCREW TYPE INSULATED SAFETY SWITCH DOUBLE THROW SAFETY SWITCH SAFETY SWITCH STRANDED UNISTRUT SUPPORT CHANNEL SUPPORT CHANNEL UNISTRUT BRACKET DOUBLE STRUT RIGHT ANGLE UNISTRUT BRACKET SINGLE STRUT RIGHT ANGLE UNISTRUT CONDUIT CLAMP SET SCREW TYPE UNISTRUT CONDUIT SUPPORT CLIP SPRING TYPE UNISTRUT SPRING NUTS UNISTRUT SPRING STUDS UNISTRUT CONDUIT STRAP 2 PIECE W BOLT SUPPORT SWITCH SWITCH amp RECEPTACLE COMBINATION SWITCH amp PILOT COMBINATION SWITCH amp SWITCH COMBINATION STYLE OF CONDUIT BODY TIME CLOCK MECHANICAL TEK SCREW TILE COVER TURN LOCK MOUNT TOGGLE TYPE SCREW IN TYPE SCREW IN TYPE INSULATED UNDERCARPET WITH BRACKET WITH BAR HANGER WITH MOUNTING BRACKET WITH NAILS WHITE WEATHER PRROF STYLE OF CONDUIT BODY DRY TRANSFORMER EXPLOSION PROOF 13 6 Copyright 1998 Durand amp
42. Hangers Fasteners Boxes wiway Wire Devices Power Defaults x Print Database Sheet This command will print pricing sheet Print Recap Print Pricing Sheet 1 0 1 2 Copyright 1998 Durand amp Associates PRINTOUT OF RECAP SHEET VPL PL BWB RECAP SHEET VERSION JOB NAME SAMBLE DATE 9 15 98 EST BY TED ESTH 123 MATERIAL LABOR HRS PRICING SHEET 975 44 19 02 MISC MATERIAL amp LABOR 100 00 8 00 QUOTED MATERIAL COST TOTAL MATERIAL COST 1 075 44 SUMMARY gt gt gt TOTAL LABOR HOURS 27 02 LABOR RATE 45 00 LABOR COST 1 215 90 MATERIAL COST 1 075 44 JOB COST 50 00 PRIME COST 2 341 34 OVERHEAD 25 5585 33 NET COST 52 926 67 PROFIT 10 5292 67 SALES TAX 65 64 53 SELLING PRICE 3 283 86 1 0 1 3 Copyright 1998 Durand amp Associates CLEAR ACTIVE SHEET E DOUBLE CLICK Pricing amp Labor PL BWB TELE Goto Conduit Fittings Hangers Fasteners Boxes Wireway wire Devices Power Defaults Print 1 1 1 Dpen Close Save Save As Save Charges to Database This command will clear the active worksheet Clear Active Sheet Printer Setup Exit FILE SAVE DOUBLE CLICK Pricing Labor PL BWB THEN Goto Conduit Fittings Hangers Fasteners Boxes Wireway Wire Devices Power Defaults Print 8 x This command saves the current file Save As Save Charges to Database Clear Active Sheet Printer Se
43. ILE C EST MAT2 BWB DATE 09 01 98 DATE 09 01 98 ITEM ITEM WIRENUT RED 51 EMT 1 WIRENUT CRAY 52 DUPLEX 20A TV 5342 1 THHN CU STRANDED 300 23 DUPLEX 15A IV 5320 ICP THHN CU STRANDED 3 0 54 DUPLEX 15A IV 5242 1 THHN CU STRANDED 812 55 BUSHING PLASTIC 3 THHN CU SOLID 12 56 BUSHING PLASTIC 2 THHN CU SOLID 10 57 MATERIAL LIST JOB UNTITLED LO uk SW 4W SW 3W SW lP SW 1 50411 20 5420 21 20 IV CS320 21 20 IV CSl20e21 15A IV CS115 2I COVER BLANK 2 1D T EO 58 59 60 61 62 63 50411 SQ4 RING 2G RAISE 1 2 64 SQ4 RING 1G RAISE 1 2 65 04 COVER BLANK 66 504 1 5D COMBO 67 S04 1 5D 3 4 KO 68 904 1 5D 1 2 KO 69 PVC 40 ELL 3 4 70 PVC 40 COUP 3 4 71 PVC 40 3 4 72 PLATE SWITCH 3G 73 PLATE SWITCH 2G 74 PLATE SWITCH 1G 75 PLATE DUPLEX 2G 76 PLATE DUPLEX 1G 2 LOCKNUT 3 78 LOCKNUT 2 79 ELL 3 80 GRC ELL 2 81 GRC COUP 3 82 GRC COUP 2 83 GRC 3 84 GRC 2 85 GANG RING RAISE 3 4 3G 86 GANG BOX 1 5 8 DEEP 3G 87 FLEX STEEL 1 2 88 FLEX CONN SQ DC 1 2 53 EMT STRAP 1H 3 4 90 EMT STRAP 1H 1 2 91 EMT STRAP 1H 1 92 EMT COUP SS DC 3 4 93 EMT COUP SS DC 1 2 94 EMT COUP SS DC 1 95 EMT CONN SS DC 3 4 96 EMT CONN SS DC 1 2 97 EMT CONN SS DC 1 98 EMT 3 4 99 EMT 1 2 100 Copyright 1998 Durand amp Associates 11 5 BACKING UP YOUR FILES There is no substitute for backing up your files We recommend a good remova
44. ING 2G RAISE 1 2 582 853 0 83 50 C SW 3W 20A IV 8320 2 5251 64 55 03 50 C WTRENUT RED 55 59 0 17 STUE PLATE SWITCH 2G IV 40 08C 0 40 60 C THHN CU SOLID 12 47 43M 55 69 50M p OY BP UL b p Gt bh O oOo C O O PR rR PB N P ti 16 LT 18 13 20 Bi pi p b t t bd Fa Bio p Bs Dd op Pd bd Ej SUBTOTAL MULTIPLIER DEFAULT 1 ASSEMBLY TOTAL Assembly MakeUp Sheet 9 ASSEMBLY MAKEUP SHEET 9 DATE DESCRIPTION SW 2G 1 3W 1 4W EST BY ITEM QTY M PRICE M EXT L UNIT EMT 3 4 17 540 37 6 86 15C EMT COUP SS DC 3 4 1 36 65C 0 37 40C EMT CONN SS DC 3 4 2 33 69C 0 67 40 EMT STRAP 3 4 3 16 97C 0 51 40 SO4 RING 2G RAISE 1 2 1 82 63C 0 83 50 SW 3W 20A IV CS320 2I 1 251 64C EE 50 1 5 1 0 1 C N N gt UI SW 4W 20A IV 5420 21 1 200 000 12 00 00C WIRENUT RED 5 59C 0 28 70C PLATE SWITCH 2G IV 40 08C 0 40 60C THHN CU SOLID 12 14 47 43M 6 64 50 M 504 1 5D 3 4 KO S118 03C 51 18 50 C Ul N p t XO e 2 P 12 13 14 15 16 17 18 19 20 53 td pi p p ot pi HJ B t E D p DP pb p SUBTOTAL MULTIPLIER DEFAULT 1 ASSEMBLY TOTAL 5 1 6 Copyright 1998 Durand amp Associates SAMPLE P
45. IT BODY LOADCENTER SINGLE PHASE LOADCENTER THREE PHASE LEVITON BRAND NAME STYLE OF CONDUIT BODY STYLE OF CONDUIT BODY STYLE OF CONDUIT BODY TYPE OF LIQUID TIGHT FLEXIBLE CONDUIT FLEXIBLE CONDUIT LIQUID TIGHT LOW VOLTAGE CABLE LOW VOLTAGE PLENUM CABLE LOW VOLTAGE TELEPHONE CABLE MOTOR STARTER MANUAL TYPE MALE TYPE WITH MAIN BREAKER METAL INSULATED TYPE METER MAIN LOADCENTER RINGLESS SURFACE SEMIFLUSH MAIN LUG ONLY FOR LAODCENTERS MAIN LUG ONLY METER MAIN SURFACE SEMIFLUSH MOUNT METER MAIN LOADCENTER SURFACE SEMIFLUSH MOUNT METER MAIN RINGLESS SURFACE SEMIFLUSH MOUNT METER MAIN SURFACE MOUNT ONLY MOUNTED NEMA 1 NEMA 12 OR 13 NEMA 3R NEMA 3R NEMA 7 OR 9 NON FUSED NM B TYPE OF ROMEX NON SHIELDED OCTAGON 1 3 4 Copyright 1998 Durand amp Associates OR OS PAN PAR PB PB1 PB3 PB3H PBOX PCD PNL PVC 40 PVC 80 R CLAMP RA RD RD BUSH RD WASH REC RK1 RK5 RND SBOX SG SCVR SD SD SEC SER SG SLB SM SCREWS SQ SQ I SQ4 50411 55 55 OVERALL SHIELD PANHEAD PARALLEL PUSH BUTTON TYPE PANELBOARD SINGLE PHASE 240V PANELBOARD THREE PHASE 240V PANELBOARD THREE PHASE 480V PLASTIC OUTLET BOX POWER amp COMMUNICATIONS DUCT PANEL PVC CONDUIT SCHEDULE 40 PVC CONDUIT SCHEDULE 80 ROMEX CLAMP RIGHT ANGLE RED REDUCING BUSHING REDUCING WASHER RECEPTACLE FUSE UL CLASS RK1 FUSE UL CLASS RK5 ROUND SWITCH BOX STEEL SCREW COVER TYPE SCR
46. L COUPLING EXTERNAL ELL TYPE OF LIQUID TIGHT FLEXIBLE CONDUIT ELBOW 90 DEGREE STANDARD RADIUS UNLESS MARKED ELBOW 30 DEGREE ELBOW 45 DEGREE 1 3 2 Copyright 1998 Durand amp Associates EMT ENT EXPAN EXT EY EYA EYD EYDM EZS FE FLEX AL FLEX COUP FLEX STEEL FSCVR FU FWS GD GND GRC GRC GRC PVC GY ELECTRICAL METALLIC TUBING ELECTRICAL NON METALLIC TUBING EXPANSION COUPLING EXTENSION STYLE OF EXPLOSION PROOF SEALOFF STYLE OF EXPLOSION PROOF SEALOFF STYLE OF EXPLOSION PROOF SEALOFF STYLE OF EXPLOSION PROOF SEALOFF STYLE OF EXPLOSION PROOF SEALOFF FEMALE TYPE FLEXIBLE ALUMINUM CONDUIT FLEXIBILE COUPLING FLEXIBLE STEEL CONDUIT FLUSH SCREW COVER FUSED FLEXIBLE WIRING SYSTEM GENERAL DUTY GROUNDING TYPE GALVANIZED RIGID CONDUIT GALVANIZED RIGID CONDUIT GALVANIZED RIGID CONDUIT PVC COATED GRAY HINGE CLAMP COVER HEAVEY DUTY HEX HEAD HANGER HOMLINE BY SQUARE D HIGH VOLTAGE INTERNAL COUPLING INTERAL ELBOW ISOLATED GROUND INTERMEDIATE METAL CONDUIT INSULATED TYPE INTERMEDIATE IRON TYPE IVORY FUSE UL CLASS J FUSE UL CLASS J TIME DELAY 1 3 3 Copyright 1998 Durand amp Associates K5 KO KV LA LB LC1 LC3 LEV LL LR LRL LT LTFLEX LVC LVPC LVTC M STARTER MA MB METAL I ML ML MLO MM MP MR MS MTD N1 N12 N3 N3R NF NM B NS OCT FUSE UL CLASS K5 KNOCKOUT KILOVOLT FUSE UL CLASS L TYPE OF LIQUID TIGHT FLEXIBLE CONDUIT STYLE OF CONDU
47. LER PICKUP PHONE FLATBED FAX CAR CELL PHONE BOOM PAGER COMPUTER PRINTER The Permit Fee has been COPY MACHINE FURNITURE RENTAL COFFEE MACHINE 111111 FIELD STORAGE amp TOOLS OTHER EXPENSE STORAGE Ak 4 19 TEMP POWER E READY 9 68 99 1035 AM forwarded here from the Permit Cost Worksheet PROJECT MANAGEMENT PROJECT MANAGER SUPERINTENDENT GENERAL FOREMAN FOREMAN MATERIAL HANDLER ESTIMATOR ENGINEER DRERAFTSHAN XPENSE Double click on Permit Fee to access this worksheet 5450 00 TRAILEE Double click on the Permit Fee Hot Button 4 8 Copyright 1998 Durand amp Associates DOUBLE CLICK Electrical Estimating SAMPLE BWB File Edit Recap Assembly Sheets Pricing Sheets Guotes JOB NAME JOB COST DESCRIPTION SAMPLE PERMIT TOTAL FORWARDED TO gt gt gt Other QTY Pnnt Pricing Menu l x COST EACH EXTENSION 450 00 This Permit Fee has been forwarded to the Job Cost Worksheet JOE ECT 5450 00 STEP 20 From the pulldown menu select Recap Bottom or use the CTRL S keys DOUBLE CLICK Electrical Estimating SAMPLE BWE File Edit 28288 Assembly Sheets Pricing Sheets Quotes Other Print Pricing Menu a x PERMIT Recap Top JOB NAME Recap Middle Ctrl D SAMPLE Recap Bottom Ctrl 5 DESCRIPTION COST EACH EXT
48. LICK Electrical Estimating SAMPLE BWE B X Fie Edit Conduit Fittings Hangers Fasteners Boxes Wireway Wire Devices Power Defaults Main Menu Return to main menu RETURN to PRICING MENU 28 DOUBLE CLICK Electrical Estimating SAMPLE BWE x Return to Main Menu File Edit Recap Assembly Sheets Pricing Sheets Quotes Other Print Retur to Pricing Menu Price Menu Return to price menu 7 7 Copyright 1998 Durand amp Associates SAVING OPENING amp DELETING FILES When you start the Double Click Electrical Estimating Software the program always loads the default file EST BWB When you receive your program this file is blank We recommend you leave this file blank until such time as you are completely familiar with this program MAIN MENUBAR FILENAME Current filename displayed in brackets EST BWB DOUBLE CLICK Electrical Estimating EST BWE ue File Edit Recap Assembly Sheets Pricing sheets Quotes Other Print Pricing Menu x CLOSING A FILE We recommend you only work with one file at a time Before opening a file select the File amp Close commands from the pulldown menu ff DOUBLE CLICK Electrical Estimating EST BWB File Edit Recap Assembly Sheets Pricing Sheets Quotes Other Prnt Pricing Menu x This command will close the active file Save As Export MAT Files Template Save Template Rea
49. LS 58 842 89 QUOTATIONS LIGHTING LIGHTING QUOTATION SUMMARY 1 328 70 POWER POWER 1 075 00 QUOTE 1 QUOTE 2 QUOTE 3 4 READY gi738 11 23 AM IP STEP 5 You are now looking at the top portion of the Recap Sheet Pick up the flow chart and observe how the different sheets report to the Recap Sheet The top portion of the Recap Sheet receives information from Assembly Totals 1 and 2 and from Pricing Sheets 1 18 4 1 Copyright 1998 Durand amp Associates STEP 6 In this Sample Estimate we have used both Assembly Pricing and Material Line Item methods of estimating Most estimates will use one estimating method however you may on occasion want to use both methods The first line of our Recap displays the Material and Labor totals forwarded from Assembly Totals 1 50 We are now going to access the Assembly totals 1 50 There are several ways to navigate in Double Click Method 1 Use the pulldown menu to select worksheet 28 DOUBLE CLICK Electrical Estimating SAMPLE B wB File Edit Recap 21 090228 Pricing Sheets Other Print Pricing Menu C SESTSSRMPLE E Assemblies 1 50 RECAP SHEET Assemblies 51 100 Ctr MakeUp 1 10 MakeUp 11 20 MakeUp 21 30 5838 61 MakeUp 31 40 1 225 09 MakeUp 41 50 MakeUp 51 60 MakeUp 61 70 553 73 Using the mouse select the sheet you want T w w w w w F MakeUp 71 80 HOT US
50. ND TIER 25 000 00 5625 00 3RD TIER 2 888 55 57 77 ITA TIFE Total forwarded Typical to recap hot cells STE TUER BONDING COST FORWARDED TO gt gt 432 Standard Method Enter percentage value for bonding rate at 5th tier Do not enter ascending dollar values for 1st 2nd 3rd and 4th tiers Do not enter any percentage values for bonding rates at 1st 2nd 3rd or 4th tiers BONDING COST WORKSHEET JOB NAME SAMPLE Typical hot cells No entry Or zero BREAK POINT BTOTAL FROM RECAP 52 888 55 No entry or zero RATE 15T TIER TIER SRD TIER Enter percentage 4TH TIER Total forwarded to recap CTH TIER 0 52 888 55 1 82 11 54 BONDING COST FORWARDED TO gt gt RECAP S2 a LLS B 6 1 0 Copyright 1998 Durand amp Associates GENERAL PROJECT INFORMATION Non Linked Worksheet Enter general Enter information Enter date project information regarding documents of documents 6 11 O Copyright 1998 Durand amp Associates OUTGOING BIDS Non Linked Worksheet Enter contact name Typical hot cells 6 12 O Copyright 1998 Durand amp Associates EXCLUSIONS SCOPE TITLE and PROPOSAL FORMS Non Linked Worksheets Enter information Typical hot cells 6 13 Copyright 1998 Durand amp Associates PRINT MANAGER Non Linked Worksheets The print manager is used to select the worksheets you w
51. OTE Pricing Sheets Quotes Other Print SUMMARY VENDOR VENDOR VENDOR VENDOR VENDOR VENDOR QUOTES 1 2 3 4 5 6 X s indicate which sheets program will print Pricing Menu ABOR RATE WORESHEET 1 COST WORESHEET 2 RMIT COST WORKSHEET 3 OHDING COST WORESHEET 4 HERAL 5 BIDS OUTGOING 6 EXCLUSIONS SCOPE OF WORK TITLE PAGE PROPOSAL 1 FPFEICIHG SHEETS PFIHTIHG TAKES 20 60 SECONDS PER PAGE PRINTING ALLSHEETS TAKES 20 45 HIH WITHOUT EXTENSIONS AND LABOR UNITS The sample estimate will print 15 worksheets 4 11 Copyright 1998 Durand amp Associates STEP 25 OPTIONAL STEP If you wish to print the sample estimate on your printer select Print and Start Printing from the pulldown menu DOUBLE CLICK Electrical Estimating SAMPLE BWB File Edit Recap Assembly Sheets Pricing Sheets Quotes Other 8 Pricing Menu 8 x PRINT MA HAGER Print Manager Start Printing BOR RATE WORESHEET B COST WORESHEET 11 COST WORKSHEET BONDING COST WORESHEET RECAP SHEET ASSEMBLY SHEET 1 zh VEN OPTIONAL STEP Select Print and Start Printing from the pulldown menu MakeUp Manager Start Printing PHT ING VENDOR 2 3 NOTE If you choose not to print the sample estimate a sample printout is included in Section 5 of this manual STEP 26 Selec
52. P 2 7D 2 7 8 DEEP 22K 22 000 RMS 24R 24 RADIUS 2C 2 CABLE 2G 2 GANG 2GT 2 GANG TANDEM TYPE 2H 2 HOLE TYPE 25 20 2 SHIELDED 2 UNSHIELDED 3 5D 3 1 2 DEEP 36R 36 RADIUS 3D 3 DEEP 3G 3 GANG 3PH THREE PHASE 48R 48 RADIUS 4G 4 GANG 4M EXPANSION COUPLING WITH 4 MOVEMENT 8M EXPANSION COUPLING WITH 8 MOVEMENT AL ALUMINUM ALM ALMOND AM MAIN BREAKER AMPS ARC ALUMINUM RIGID CONDUIT ASTRO 24 HOUR WITH ASTRONOMIC DIAL ATLA TYPE OF LIQUID TIGHT FLEXIBLE CONDUIT BKR BREAKER 1 3 1 Copyright 1998 Durand amp Associates BM BOND JUMPER BR C C ADAPTER C BODY C STARTER C STUD CB CB2 CBB CBQT CBSN CBT CFM 4 CIR CL2 CN COMBO CONN COUP CP CSM CVR D CLOCK DBL DC DIM DIST E COUP E ELL EF ELL ELL 30 ELL 45 BEAM CLAMP BONDING JUMPER FOR EXPANSION COUPLING BROWN STYLE OF CONDUIT BODY CONDUIT ADAPTER CONDUIT BODIE COMBINATION DISCONECT MOTOR STARTER CONCRETE STUD ANCHORS RED HEAD CIRCUIT BREAKER PLUG IN TYPE CIRCUIT BREAKER HALF SIZE CIRCUIT BREAKER BOLT ON TYPE CIRCUIT BREAKER QUAD TANDEM CIRCUIT BREAKER SWITCHED NEUTRAL CIRCUIT BREAKER TANDEM CONDUIT FIXED MOUNT CUBIC INCH CIRCUIT TYPE OF COAX CABLE CONNECTOR COMBINATION 1 2 amp 3 4 KNOCKOUTS CONNECTOR COUPLING COMPRESSION TYPE COMPRESSION TYPE INSULATED CONDUIT SWIVEL MOUNT COVER TIME CLOCK DIGITAL DOUBLE DIE CAST TYPE DIMMER DISTRIBUTION STYLE OF CONDUIT BODY EXTERNA
53. RAGE LABOR RATE FORWARDED STEP 17 Return to the Recap Sheet by double clicking on the Recap Hot Button Copyright 1998 Durand amp Associates STEP STEP DOUBLE CLICK Electrical Estimating SAMPLE BWE File Edit Recap Assembly Sheets Pricing Sheets Quotes Other Print Pricing Menu E x ass ET 12 OVERHEAD SUMMARY TOTAL LABOR HOURS 683 40 EN LABOR lt 4 126 00 LABOR RATE x 38 33 m MATERIAL sj age ss SUBTOTAL LABOR COST 26 196 86 QUOTES lt aM LOST 21 309 84 JOB COST 5223 50 LABOR COST 27 506 70 OVERHEAD 5 878 24 MATERIAL COST 8 842 89 878 D PROFIT SUMHARY JOB COST 2 335 00 7 LABOR A ELLO Se MATERIAL X OVERHEAD 5 878 24 QUOTES HET COST 45 965 53 JOB COST X PROFIT 55 47 PROFI EB SALES LABOR MATER QUOTES lt JOB COST X SUBTOTAL 552 888 BOND forwarded here from the 51 432 77 SALES TAK 674 80 SELLING P Labor Rate Worksheet 554 321 32 to access this worksheet Double click on Job Cost 5 The Job Cost has been GENERAL BIDS EXCLUSIONS SCOPE PROPOSAL PRINT MANAGER ASSEMBLY MANAGER 18 Double click on the Job Cost Hot Button DOUBLE CLICK Electrical Estimating 5AMPLE BWB File Edit Recap Assembly Sheets Pricing Sheets Quotes Other Print Pricing Menu 18 x JOB NAME SAMPLE E RECAP FIELD OFFICE EXPENSE VEHICLE EXPENSE TRAI
54. RAISE 1 2 65 04 COVER BLANK 66 504 1 5D COMBO 67 S04 1 5D 3 4 KO 68 904 1 5D 1 2 KO 69 PVC 40 ELL 3 4 70 PVC 40 COUP 3 4 71 PVC 40 3 4 72 PLATE SWITCH 3G 73 PLATE SWITCH 2G 74 PLATE SWITCH 1G 75 PLATE DUPLEX 2G 76 PLATE DUPLEX 1G 2 LOCKNUT 3 78 LOCKNUT 2 79 ELL 3 80 GRC ELL 2 81 GRC COUP 3 82 GRC COUP 2 83 GRC 3 84 GRC 2 85 GANG RING RAISE 3 4 3G 86 GANG BOX 1 5 8 DEEP 3G 87 FLEX STEEL 1 2 88 FLEX CONN SQ DC 1 2 53 EMT STRAP 1H 3 4 90 EMT STRAP 1H 1 2 91 EMT STRAP 1H 1 92 EMT COUP SS DC 3 4 93 EMT COUP SS DC 1 2 94 EMT COUP SS DC 1 95 EMT CONN SS DC 3 4 96 EMT CONN SS DC 1 2 97 EMT CONN SS DC 1 98 EMT 3 4 99 EMT 1 2 100 Copyright 1998 Durand amp Associates 5 22 SAMPLE PRINTOUTS Pricing Sheet Without Prices and Extensions JOB NAME DESCRIPTION O N dt 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 2 28 29 30 31 32 34 35 36 377 38 39 40 41 42 43 44 ITEM EMT 1 2 EMT 3 4 EMT 1 EMT COUP SS DC 1 2 EMT COUP SS DC 3 4 EMT COUP SS DC 1 EMT CONN SS DC 1 2 EMT CONN SS DC 3 4 EMT CONN SS DC 1 EMT STRAP 1H 1 2 EMT STRAP 1H 3 4 EMT STRAP 1H 1 504 1 5D COMBO 50411 2 1D 1 KO SO4 COVER BLANK 50411 COVER BLANK SQ4 RING 1G RAISE 1 2 DUPLEX 15A IV 5242 I PLATE DUPLEX 1G IV THHN CU SOLID 12 WIRENUT RED PRICING SHEET 1 SAMPLE BRANCH CIRCUIT POWER QTY 1 200 4
55. RINTOUTS Assembly MakeUp Sheet 11 ASSEMBLY MAKEUP SHEET 11 DATE DESCRIPTION SW 3G 3 1P EST BY ITEM M PRICE M EXT L UNIT EMT 1 2 23 77C 4 04 2 92 C EMT COUP SS DC 1 7 S22 63C 0 23 4 50 EMT CONN SS DC 1 2 531 230 0 43 4 50C EMT STRAP 1H 1 2 12 90C 0 39 4 50C GANG BOX 1 5 8 DEEP 3G 5890 89 58 91 29 80 GANG RING RAISE 3 4 3G 574 22C 5 74 9 00 C SW 1P 20A 5120 21 162 96C 4 89 18 00 WIRENUT RED 5 59C 0 17 2 70 PLATE SWITCH 3G IV S60 12C S0 60 4 50 THEN CU SOLID 12 47 43M 23 79 4 50M J C u UJ PW NB 1 2 3 4 5 6 7 8 9 10 11 Ei tzi Oo E bd FJ t bi D Hi HOW fA wee iu SUBTOTAL MULTIPLIER DEFAULT 1 ASSEMBLY TOTAL Assembly MakeUp Sheet 12 ASSEMBLY MAKEUP SHEET 12 DATE DESCRIPTION SW 3G 2 1 1 3 EST BY TIEN QTY M PRICE M EXT L UNIT EMT 1 2 17 523 770 4 04 2 92C EMT COUP SS DC 1 2 522 63 20 23 4 50 EMT SS DC 1 2 521 300 0 43 4 50C EMT STRAP 1H 1 2 512 90 50 39 4 50C GANG BOX 1 5 8 DEEP 3G 890 89C 58 91 19 80C GANG RING RAISE 3 4 3G 5574 220 5 74 9 00C SW 20 IV CS120 21 S162 96C S3 26 16 00C Sw 3W 20A IV CS320 21 5251 64 2 52 22 50 WIRENUT RED 25 59 50 22 2 40 PLATE SWITCH 3G IV 60 12C 20 60 4 50C THEN CU SOLID 12 47 43M 55 69 4 50M p oN OV Ul w N dr p O C C
56. T JOB NAME SAMPLE ENTER PROJECT DURATION IN CALEHDAR DAYS ENTER HUMBER OF WORE DAYS PER WEEK ENTER NUMBER OF WORK HOURS PER WORK DAY 7 MANHOURS FORWARDED FROM RECAP 683 40 Should be cloce WORK DAYS PROJECT DURATION 28 57 arar MANDAYS Enter E CREW SIZE REQUIRED m of men Enter employee NUMBER DESCRIPTION description RATE EXTENSION 540 00 550 00 525 00 Enter rate per hour Total forwarded Typical hot cells k x H CREW AVERAGE LABOR RATE FORWARDED TO gt gt RECAP 38 33 6 7 Copyright 1998 Durand amp Associates JOB COST WORKSHEET Enter description Enter description Typical Total forwarded from permit worksheet Enter description Enter description Total forwarded to recap Typical hot cells 6 8 O Copyright 1998 Durand amp Associates PERMIT COST WORKSHEET Enter Enter Enter description quantity cost each Total forwarded to Typical job cost worksheet hot cells 6 9 O Copyright 1998 Durand amp Associates BONDING COST WORKSHEET There are two methods of using this worksheet Tiered Method Enter ascending dollar values for 1st 2nd 3rd and 4th tiers Then enter descending percentage values for bonding rates BONDING COST WORKSHEET JOB NAME SAMPLE Enter descending percentage values Enter ascending dollar values BREAK POINT RECAP 552 888 5 15T TIER 25 000 00 00 X 5750 00 2
57. UST USER Enter user PRICE E 22 pricing here PRICE F EMT CONDUIT ITEM EMT 1 2 C 23 7 EMT 3 4 C 40 3 EMT 1 C 68 9 EMT 11 4 C 36 3 number here EMT 1 142 C 115 4 EMT 2 Example 45 C 143 2 EMT 2 1 2 C 365 7 EMT 3 480 9 EMT 3 1 2 C 557 4 EMT 4 C 750 1 Show labor units TRADE PRI ARE ALLIED Hot cell SHOW LABOR UNITS To view labor units double click on the Show Labor Units hot cell 1 0 4 Copyright 1998 Durand amp Associates Once the labor units are displayed you may change the adjustments CLICK Pricing k Labor PL BwB File Goto Conduit Fittings Hangers Fasteners Boxes Wireway wire Devices Power Defaults Print LABOR EMT COHDUIT ITEM EMT EMT EMT LABOR UHITS SHOW MATERIAL PRICES STANDARD LABOR UNIT Enter new number here Example 45 Show material prices DURAND 4 Hot cell C C fy O CI lolx 1 1 ADJUST d Enter user labor here C am A mo A s co Mm F ce To return to the material prices double click on the Show Material Prices hot cell SAVING CHANGES TO DATABASE If you make changes to the database screen you must save these changes to the database file Using the mouse select the File
58. WHY THIS PROGRAM WAS DEVELOPED Having completed the programming for the Double Click software now comes the task of writing some meaningful documentation Writing a user s manual is not what you would call fun If you sometimes get bored reading this manual just imagine how l felt writing it Before describing how this program works would like to take the time to cover some brief history about estimating and computer systems This should help you understand how this program was designed for you the contractor HISTORY OF ESTIMATING Electrical contractors have been asked to give firm quotations for electrical work for as long as can remember The standard method of estimating has been to count every piece of material required to complete a project and list those items on a pricing sheet Once the contractor has listed all the materials he would then obtain material costs for each item and list them on his pricing sheets Next he would assign a labor unit to each material item and list that unit on the pricing sheet Then using a calculator or adding machine he would extend the totals and forward those totals to a recapitulation recap sheet where overhead profit and other job costs would be entered This method of estimating has been the standard of the industry for over sixty 60 years and is still the most widely used method today HOW MANUFACTURERS USE COMPUTERS In the 1950 s and 60 s large manufacturers of electrical equipm
59. al Estimating SAMPLE BWB File Edi p OVERHEAD LABOR MATERIAL QUOTES JOB COST OVERHEAD SUMMARY PROFIT SUMMARY LABOR MATERIAL QUOTES JOB COST PROFIT Recap Assembly Sheets Pricing Sheets Quotes Other Print Pricing Menu E 6 x TOTAL LABOR HOURS 583 40 4 126 00 LABOR RATE x S 3833 1 326 43 SUBTOTAL LABOR COST 26 196 86 2192 30 LOST 21 309 84 5223 50 LABOR COST 27 506 70 5 878 24 MATERIAL COST 0 842 89 QUOTES 2 403 70 JOB COST 2 335 00 4 126 00 PRIHE COST 241 088 29 884 23 OVERHEAD 55 878 24 ELE L5 COST 46 966 53 PROFIT 25 247 23 242 23 SALES TAK 674 80 SALES TAX SUMMARY LABOR MATERIAL QUOTES JOB COST SALES TAX GENERAL ETS PRINT MANAGER STEP 24 ASSEMBLY MANAGER DOUBLE CLICK Electrical Estimating SAMPLE BWE Double click on Print Manager to display the print manager screen TETCTZ 52 888 55 BOND E 432 772 2574 80 SELLING PRICE SEA 2210 42 PROPOSAL Double click on the Print Manager Hot Button File Edi PRINT HANAGER Recap Assembly Sheets SHEET ASSEMBLY SHEET 1 ASSEMBLY SHEET 2 SHEET 1 SHEET 2 SHEET 3 SHEET 4 SHEET 5 SHEET 6 SHEET 7 SHEN 8 SHEET SHEET 10 SHEET 11 SHEET 12 SHEET 13 SHEET 14 SHEET 15 SHEET 15 SHEET 17 SHEET 18 H
60. and Save changes to Database command DOUBLE CLICK Pricing k Labor PL BWB Oy x im File Goto Conduit Fittings Hangers Fasteners Boxes Wireway Wire Devices Power Defaults Print Open Close Save Save As save Charges to Database Clear Active Sheet Printer Setup Exit PRINTING DATABASE SHEET 1 1 2 This command will save changes to database NOTE Changes must be save for each screen If you want you may print the database sheet by using the mouse to select the Print and Print Database Sheet command DOUBLE CLICK Pricing k Labor PL BwB File Goto Conduit Fittings Hangers Fasteners Boxes Wireway Wire Devices Power Defaults Ey This command will print database 10 5 Print Database Sheet Print Recap Print Pricing Sheet Copyright 1998 Durand amp Associates PRINTOUT OF DATABASE SHEET MATERIAL TRADE P ADJUST ADJUSTED USER PRICE E PRICE PRICE R EMT CONDUIT ITEM EMT 1 2 39 62 40 523 77 EMT 372 67 29 40 40 37 EMT 1 114 94 C 40 68 96 EMT 1 1 4 160 52 C 40 96 31 EMT 1 1 2 192 39 C 40 115 43 EMT 2 238 68 40 149 21 2 1 2 5487 63 25 365 72 3 641 24 25 480 93 EMT 3 1 2 889 92 C 25 667 44 EMT 4 1 000 20 C 25 750 15 di TRADE PRICES ARE ALLIED 3 30 98 LABOR STANDARD P ADJUST ADJUSTED USER LABOR E LABOR LABOR UNIT R UNTT UNIT EMT CONDUIT ITEM EMT 1 2
61. ard Worksheet Paste clipboard to active sheet Arrange Active Worksheet Delete items with zero quantities 7 3 Copyright 1998 Durand amp Associates DATABASE MENU DATABASE MENU DOUBLE CLICK Electrical Estimating SAMPLE BWB Fie Edit Fittings Hangers Fasteners Boxes Wireway Wie Devices Power Defaults Main Menu la x Rigid EMT Aluminum Using the database menus you may select any mate IMC rial item in the database Rigid PY gt Conduit PYE 40 Elbows k Standard Radius Couplings 36 Radius Sweeps NOTE PE Duct 46 Radius Sweeps ENT To use a database menu the active cell must be in Flex the item column on the pricing or makeup sheet LT Flex ACTIVE CELL IN ITEM COLUMN RECAP PRICING SHEET 1 JOB NAME SAMPLE DESCRIPTION BRANCH ITEH 1 2 3 4 5 5 DATABASE SCREEN Once you have selected an item the following screen will appear IMPORT TAGGED MATERIAL 7 im TRADE P ADJUST ADJUSTED USER nad PRICE E x PRICE PRICE tagged items R Double click GALVANIZED RIGID CONDUIT pricing level TAG ITEM vm ACTIVE 22 151 56 40 590 to tag items B GRC 3 4 193 88 C gt 40 116 rown active ene 201 25 40 174 pricing level aa E 377 44 40 DDS R ae 458 81 C 40 395 ERES H as E 40 369 ib imperi 1 DD1 77 51 single it
62. average labor rate Totals are automatically forwarded to Recap Sheet LIGHTING QUOTES SUMMARY Quantity 1 This is where the summary of lighting quotes is displayed The total price for each vendor appears on this sheet and the lowest vender price is forwarded to the recap sheet 2 3 Copyright 1998 Durand amp Associates LIGHTING VENDOR SHEETS Quantity 6 This is where you enter the price quoted for each type of fixture Totals are automatically forwarded to Lighting Quotes Summary POWER QUOTES SHEET Quantity 1 This is where you enter the lump sum quote from each power vendor Totals are automati cally forwarded to Recap Sheet MISCELLANEOUS QUOTES SHEETS Quantity 8 This is where you enter lump sum quotes for various items Totals are automatically for warded to Recap Sheet GENERAL INFORMATION SHEET Quantity 1 This is where you enter the name of the architect and engineer You may also list the bid documents you have used for preparing your bid This sheet does not forward information LIST OF BIDS Quantity 1 Here you list the bids you have given to various contractors This sheet does not forward information LIST OF EXCLUSIONS Quantity 1 Here you list any exclusion to your bid This sheet does not forward information SCOPE OF WORK Quantity 1 Here you list the scope of work included in your estimate This sheet does not forward information TITLE PAGE Quantity 1 This is a blank page
63. ble media backup system with backups performed weekly WHAT TO BACKUP The following folders need to be backed up LJ Uprice Est The following folders do not need to be backed up This information is on the original disks and does not change in your computer LJ Tprice Mat 1 2 1 Copyright 1998 Durand amp Associates BACKING UP USER PRICE FILES TO FLOPPY The user price files contain the adjustments you make in your database These files may be backed up to a floppy disk using Windows STEP 1 STEP 2 STEP 3 STEP 4 Insert a blank floppy disk in your A Drive Right click on the UPRICE folder Select Send To and 3 1 2 Floppy commands from the menu NOTE Backing up the UPRICE folder to a floppy takes 20 minutes Open Explore Find 3 Floppy A Cut 253 Desktop as Shortcut Copy G Fax Recipient Create Shortcut Mail Recipient Delete Be Mail Recipient Using Microsoft Outlook Rename My Briefcase Properties Wait 20 25 minutes for backup to complete Copying 2200 65 From LIPRICE ta LIPRICE Other files are to large to backup onto floppy disk 1 2 2 Copyright 1998 Durand amp Associates ABBREVIATIONS These abbreviations are used in the material database 1 5D 1 1 2 DEEP 1 7D 1 7 8 DEEP 10K 10 000 RMS 1C 1 CABLE 1D 1 DEEP 1G 1 GANG 1H 1 HOLE TYPE 1PH SINGLE PHASE 2 1D 2 1 8 DEEP 2 5D 2 1 2 DEE
64. bor PL BWB OO xj 77 File Goto Fittings Hangers Fasteners Boxes Wireway Wire Devices Power Defaults Print 8 x Elbows Standard Radius ee 0 Using the database menus you may select ne Po Connectors gt CNRC Lun any material item in the database Skap k 46 Radius Sweeps i PvC40 80 Duct is 4 Flex To use a database menu the active cell must be in LT Flex the item column on the pricing or makeup sheet ACTIVE CELL IN ITEM COLUMN RECAP PRICING SHEET 1 JOB SAMPLE DESCRIPTION ITEM 1 2 3 4 5 5 DATABASE SCREEN Once you have selected an item the following screen will appear MATERIAL TRADE P ADJUST ADJUSTED USER PRICE PRICE PRICE R Double click GALVANIZED RIGID ELBOWS to select 96 RADIUS pricing level ITEM ACTIVE GRC ELL 36R 2 72 13 54 10 ELL 36R 2 1 2 98 87 Brown active 74 15 GRC ELL 3 130 15 indicates q 21 pricing level GRC ELL 36R 3 1 2 169 51 127 13 ELL 36R 4 189 86 142 40 GRC ELL 36R Double click 306 07 25 229 55 to import a GRC ELL 36R 6 P 336 27 25 252 20 single item P P TRADE PRICES ARE BASED CONDUIT amp PIPE PRODUCTS 1271 96 1 0 8 Copyright 1998 Durand amp Associates Double click on the first item and it will be imported into the pricin
65. cell right and enter quantity arrow one cell right and enter the price arrow one cell right and enter multiplier E C or M arrow two cells right and enter the labor unit and arrow one cell right and enter multiplier E C or M 6 4 Copyright 1998 Durand amp Associates PRICING SHEET Activate the cell you wish to import into Material prices automatically Labor units automatically and select material from pulldown menu imported from database imported from database RECAP PRICING SHEET 1 DATE 015 989 JOB SAMPLE EST 123 DESCRIPTION EST BY PAUL LAUNZ LEFT I m JJ w 285 26 EIE 2 181 68 14 18 3 89 65 4 68 4 31 68 6 30 5 19 06 2 81 6 9 58 7 5 7E 2 07 8 56 74 1 08 9 54 44 0 50 10 533 54 11 70 11 Lk 6 10 12 7 25 1 87 13 65 40 13 50 l4 31111 0 90 15 54 05 0 45 16 52 89 0 22 17 30 09 2 25 18 164 22 11 25 19 10 02 i 20 5227 66 21 60 21 211 E Rn 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 Typical 44 to recap SUBTOTAL 21225 144 73 MULTIPLIER DEFAULT 1 X B D SHEET TOTALS FORWARDED TO gt gt gt 31 225 144 25 If you wish you may manually enter items on the pricing sheet Type in the description arrow one cell right and enter quantity arrow one cell right and enter the price arrow one cell right and enter multiplier E C or M arrow two cells rig
66. d Template Blank Printer Setup E wit SAVING CHANGES BEFORE CLOSING If you have not saved changes in the active file the program will ask you if you want to save changes before closing Application Yes Click Yes to save changes Save changes in EST BwB Click No to close active file without saving changes Click Cancel to return to the active file If you click Yes or No the file will closed and no file will be displayed on screen 8 i Hab ee Copyright 1998 Durand amp Associates OPENING A FILE To open a file select File and Open commands from the pulldown menu E DOUBLE CLICK Electrical Estimating OO xj NIE Edit Recap Assembly Sheets Pricing Sheets Quotes Other Prnt Pricing Menu Close Bc This command will display a list of files Save Save Esport MAT Files Template Save Template Head Template Blank Printer Setup E wit Double click on the file you wish to open File Open File sample bwb Path c Xest 2 111 11 1 1 Double click on filename List Files of Type Drives Workbks bwb amp c 1 After double clicking the file will load Typical file loading times Pentium 133 MHZ 68 seconds Pentium 300 MHZ 42 seconds Filename appears on menubar T 28 DOUBLE CLICK Electrical Estimating S amp MPLE BwB 5j File Edit Recap Assembly Sheet
67. e we have offered FREE unlimited telephone support for our products The word FREE is very important because the only way we can continue to offer FREE support is to write trouble free and simple to use programs Most other estimating programs charge a yearly support fee Double Click incorporates the features and functions of our DOS based programs The features and functions were developed over 13 years by listening to our customers requests Our policy is if enough customers request a program change we will change it The three most requested changes from our customers over the past three years are 1 Provide a Windows based version of our software 2 Add additional pricing sheets to the program 3 Include tagging of multiple items when selecting material 4 Provide a tiered bonding rate worksheet All of these changes are included with the new Double Click program HOW THIS PROGRAM WORKS Before we get into the actual operation of the estimating program it is important to understand how the various forms or worksheets interface with each other Below is a list of the worksheets available within this program 1 RECAP SHEET 18 PRICING SHEETS 2 ASSEMBLY TOTALS SHEETS 100 ASSEMBLY MAKE UP SHEETS 1 BONDING COST WORKSHEET 1 JOB COST WORKSHEET 1 PERMIT CALCULATION SHEET 1 LABOR COST WORKSHEET 1 LIGHTING QUOTES SUMMARY 6 LIGHTING VENDOR SHEETS 1 POWER QUOTES SHEET 8 MISCELLANEOUS QUOTES SHEETS 1 GENERAL
68. eading template file Recap Menu Recap sheet 4 2 2 1 7 5 10 1 3 1 6 8 6 7 10 2 6 6 9 4 3 1 7 1 6 15 13 1 11 1 8 2 7 2 6 12 6 9 4 4 6 7 10 1 10 1 73 6 5 7 2 6 14 7 8 6 14 10 5 6 13 7 2 9 2 7 1 6 2 14 2 Copyright 1998 Durand amp Associates INDEX continued Return Menu Sample printouts SaveAs Saving a template file Saving changes before closing Saving changes to database Saving files Scope sheet Special Tags Menu Speed of program Supplier discounts Tag Menu Template files Title sheet User labor units User pricing 7 6 5 1 8 3 9 3 8 1 10 5 8 3 6 13 7 5 1 2 10 1 7 5 9 1 6 13 10 2 10 2 14 3 Copyright 1998 Durand amp Associates
69. em 1 264 60 gt 25 363 3 1 2 Se te 226 1 171 Gre 2252125 25 iL Ss 3 3 629 89 25 DAN CE ac 87298 dE BEES Double click to return to price sheet without TRADE PRICES ARE ALLIED 3 30 98 importing prices TAG ALL ITEMS SPECIAL TAGS RETURN ue Wee ABOUNT SPECIAL TAGS 7 4 Copyright 1998 Durand amp Associates DATABASE MENUBAR Once the database screen displays the Database Menubar appears 28 DOUBLE CLICK Electrical Estimating SAMPLE BwB S Import Tagltems Special Tags Defaults Retum x IMPORT MENU E DOUBLE CLICK Electrical Estimating SAMPLE BWEB OF x Tagltems 395 Defaults Return x Import Tagged Items Import Tagged Items Any items marked with tags will be transferred to the pricing or makeup sheet TAG MENU E DOUBLE CLICK Electrical Estimating SAMPLE Bw B J Import BERE Special Tags Defaults Retum l xl GAC 1 2 3 4 GRC 1 GAC 1 1 4 GAC 1 17 2 2 GAC 2 1 2 GAC 3 GAC 31 72 GAC 4 GRC 5 GRAC 6 Tag All Items Clear All Tags You may tag single items tag all items or clear all tags from the pulldown menu SPECIAL TAGS MENU DOUBLE CLICK Electrical Estimating SAMPLE S Import Tagltems Defaults Retum x Tag 1st Three Items About Special Tags You may tag the first three items in a material group by using the Tag 1st Three I
70. embly Sheets Pricing Sheets Oth er Prnt Pricing Menu Summan OTHER MENU Power Quote 1 Quote 2 Quote 3 uote 4 Quote 5 Quote 6 Quote 7 Quote 8 Vendar 1 Vendor 2 Vendor 3 Vendor 4 Vendor Vendor 5 18 Lighting Displays Lighting Quotes Summary Vendor 1 6 Displays selected quote Power Displays Power Quote Quote 1 8 Displays selected quote DOUBLE CLICK Electrical Estimating SAMPLE BWB 5j File Edt Recap Assembly Sheets Pricing Sheets Quotes Bids Displays outgoing bids Bond Displays bonding worksheet Exclusions Displays exclusions General Displays project information Job Cost Displays Job Cost Labor Rate Displays labor rate Permit Fee Displays permit cost Proposal Displays proposal Scope of Work Display scope of work Title Page Displays title page Bids Band Exclusions General Job Cost Labor Rate Permit Fee Proposal Scope of work Title Page Print Pricing Menu Ctrl B Ctrl C Ctrl E Ctrl L Ctrl Ctrl O Ctrl F Ctrl T 15 Copyright 1998 Durand amp Associates PRINT MENU E DOUBLE CLICK Electrical Estimating SAMPLE BWB File Edt Recap Assembly Sheets Pricing Sheets Quotes Other Pricing Menu 5 x Print Manager Print Manager Activates print manager start Printing 9 P 9 NOTE MakeUp Manager Start Printing Makellps Print Manager or MakeUp Man MakeUp Manager Activa
71. ent invested thousands of dollars in computer hardware and software to automate their manufacturing process Because these computer systems could only deal with numbers the manufacturers would assign a part number to each and every piece of material HOW DISTRIBUTORS USE COMPUTERS In the 1970 s and 80 s electrical wholesale houses began installing computers to automate their operations Because wholesale houses purchased and resold material from many different manufacturers a universal numbering system was developed This numbering system assigned a number to each material item regardless of the manufacturer This universal numbering system is of great value to the manufacturers and distributors however its value to a contractor is somewhat limited Let us look at an example of the numbering system A 4 Square Box with 1 2 KOs 1 1 2 deep may have as many as 47 different numbers depending on who is the manufacturer The distributor needs a number for each part so his computer can keep track of inventory and automatically reorder as necessary The contractor on the other hand could care less who the manufacturer is and would require only one part number or description in his computer estimating system COMPUTERS FOR CONTRACTORS In the 1970 s a new industry was born This industry was called systems houses Systems houses were companies that bought computer hardware and wrote custom programs for various industries These companies would the
72. ercise is to help you become familiar with the program flow STEP 1 STEP 2 STEP 3 STEP 4 Remove the Flow Chart from the front pocket of your user s manual and place it next to your computer Double click on the EST icon located on the desktop This will start your estimating program The program automatically loads the default file EST BWB at start up When you receive your program this file is blank Program File loading times Pentium 133 MHZ 68 seconds Pentium Il 300 MHZ 42 seconds Using the mouse go to the FILE menu and select CLOSE You will be asked if you wish to save changes in EST BWB click NO Using the mouse go to the FILE menu and select OPEN You will be asked to select a file Double click on SAMPLE BWB This will open the sample file Once the sample file is open the recap portion of the file appears on the screen DOUBLE CLICK Electrical Estimating SA amp MPLE BWwB File Edit Recap Assembly Sheets Pricing Sheets Quotes Other Print Pricing Menu SESTSSAMPLE BWB RECAP SHEET DATE EST MATERIAL 2 819 28 212 13 838 61 104 04 1 225 09 144 73 2 653 73 85 53 3 BRANCH CIRCUIT SITE LIGHTING 170 73 1750 4 FEDDER CONDUITS 2 835 47 41 48 5 NOT USED NOT USED NOT USED 8 HOT USED 9 NOT USED 10 NOT USED 11 NOT USED 12 NOT USED 13 NOT USED 14 NOT USED 15 NOT USED 16 NOT USED i NOT USED 18 NOT USED MISC MATERIAL amp LABOR 00 PRICING SHEET MATERIAL TOTA
73. g Sheets Quotes Other Print Pricing Menu XEST SAMPLE BWB RECAP SHEET ASSEMBLIES 1 5 2 019 838 1 229 553 2170 2 835 HOT USED TT TT The Material List Module will also compile only those assembly makeups which have a quantity greater than zero If you do not wish to compile an assembly makeup enter a zero quantity for that assembly FERAE ASSEHBLY PRICE SHEET 1 DATE JOB SAMPLE EST ASSEMBLIES 1 50 EST BY ITEM M EXT 1 1 1 SW 15 1 1FP 9 50 E Si 1899 SW 1G 1 3W 12 28 E 524 57 198 E SW 15 1 4W 222 4 Enter zero if you do SU 2G 2 1 not want assembly 1 6 SU 2G 1 1 1 20 makeups compiled 2 SW 2G 1 1P 1 4WU 25 89 E S TBI 35 8 SW 265 2 30 18 24 E 127 67 24 9 SW 205 1 30 1 40 32 26 E 5258 05 z 1 1 1 Copyright 1998 Durand amp Associates OTEP 5 The Material List Module will also compile only those items on a pricing sheet which have a quantity greater than zero you do not want a specific item on a pricing sheet to be compiled enter a zero quantity for that item RECAP PRICIHG SHEET 1 JOE HAME SAMPLE DESCRIPTION ITEM QTY H PRICE 1 3 Enter zero if you do not want a specific 5 item compiled 5 8 STEP 6 Using the mouse select the File and Export MAT Files commands from the pulldown menu DOUBLE CLICK Electrical Estimat
74. g sheet RECAP PRICING SHEET LATE JOE HAHE EST DESCRIPTION EST BY x ITEH M EXT L UHIT L EST 1 2 3 4 Enter 3 quantity 5 hear You may now enter the quantity and the program will perform all extensions DEFAULTS MENU E DOUBLE CLICK Pricing amp Labor IPL BwB File Goto Conduit Fittings Hangers Fasteners Boxes Wireway wire Devices Power Print 1 1 1 wv Trade Price m Adjusted Price You may also set pricing and labor levels from quM the pulldown menu Standard Labor You may also set the Cursor Right or Cursor User Labor Down defaults Cursor Right Active levels marked with a check mark Cursor Down CURSOR RIGHT If you set the cursor right default the active cell will move one cell right after material has been transferred from database Before Transfer RECAP PRICING SHEET 1 JOB NAME SAMPLE DESCRIPTION ITEH QTY M PRICE 1 2 3 4 Active cell position before transfer After Transfer RECAP PRICING SHEET 1 JOB HAHE SAMPLE DESCRIPTION ITEM Fe Active cell position after transfer 1 0 9 Copyright 1998 Durand amp Associates The cursor right default is ideal if you select one item at a time and wish to input the quantity after transferring data from the database If you plan to transfer more than one material item or you do not plan to input quantities after tra
75. heet Double click on Recap to return to Recap Sheet STH TIER BONDING COST FORWARDED TO STEP 22 Double click on the Recap Hot Button f DOUBLE CLICK Electrical Estimating SAMPLE BWB File Edit Recap Assembly Sheets Pricing Sheets Quotes Other Print Pricing Menu x OVERHEAD SUMMARY TOTAL LABOR HOURS 683 40 LABOR lt 4 126 00 LABOR RATE x 38 33 m MATERIAL 1 326 43 SUBTOTAL LABOR COST 26 196 56 QUOTES lt 5192 30 5 X OF LOST TIME 1 309 a4 JOB COST 5223 50 LABOR COST 27 506 70 OVERHEAD 5 878 24 MATERIAL COST 0 842 89 QUOTES 2 403 70 PROFIT SUMMARY 2 335 00 LABOR 15 4 126 00 PRIME COST 41 088 29 MATERIAL X 884 29 OVERHEAD 25 878 24 QUOTES Sup HET COST 45 966 53 JOB COST x 116 75 PROFIT 5 247 23 PROFIT 5 247 23 SALES 674 80 SALES T X SUMMA LABOR lt MATERIAL S53 DET mO TES 2144 22 SUBTOTAL 52 000 55 JOB COST X BOND 1 432 77 SALES S674 80 SELLING PRICE 54 321 37 GEHERAL BIDS EXCLUSIONS ED PROPOSAL PRINT MANAGER STEP 23 ASSEMBLY MANAGER There are six 6 unlinked worksheets in the program General Bids Exclusions Scope Title and Proposal If you wish you may visit these worksheets before proceeding These worksheets are blank in the sample estimate To display the worksheets simply double click on the Hot Buttons Copyright 1998 Durand amp Associates 4 10 DOUBLE CLICK Electric
76. ht and enter the labor unit and arrow one cell right and enter multiplier E C or M 6 5 Copyright 1998 Durand amp Associates LIGHTING QUOTATION SUMMARY LIGHTING QUOTATION SUMMARY JOB HAHE SAMPLE FECAP VENDOR NAME PRICE VEHDOR 1 SUPPLY VENDOR 2 LOW BID SUPPLY Totals forwarded 1 328 70 from lighting fixture quotations VEHDOR 3 VEHDOR 4 Typical hot cells VENDOR 5 Total forwarded to recap VEHDOR 6 LOWEST PRICE FORWARDED TO RECAP 320 70 LIGHTING FIXTURE QUOTATION Enter vendor name contact and phone Enter time date and fax SAMPD LIGHTING FIXTURE QU VEHDOR 2 JOB HAHE VENDOR TIME CONTACT DATE PHONE E FAX TYPE QTY PRICE EXT TYPE QTY PRICE EA EXT 2 3 4 5 6 Enter price each Enter quantity Enter fixture type Total forwarded to lighting summary hot cells VENDOR TOTAL FORWARDED TO LIGHTING QUOTATION gt gt gt SUMMARY 1 328 70 6 6 Copyright 1998 Durand amp Associates POWER OR MISC QUOTATION Enter description of quote POWER QUOTATIONS JOB NAME SAMPLE VENDOR CONTACT PHOHE DATE TIME PRICE Enter 1 contact name Enter vendor name Total forwarded to recap LOWEST QUOTE FORWARDED TO RECAP 51 075 00 Typical hot cells LABOR RATE WORKSHEET Enter calendar days work days and work hours LARBOR RATE WORKSHEE
77. ight or Cursor w Adjusted Labor Down defaults User Labor Cursor Right Active levels marked with a check mark vw Cursor Down CURSOR RIGHT If you set the cursor right default the active cell will move one cell right after material has been transferred from database Before Transfer RECAP PRICING SHEET 1 JOB NAME SAMPLE DESCRIPTION t ITEM Sess 2 4 2 3 4 Active cell position before transfer After Transfer RECAP PRICING SHEET 1 JOB NAME SAMPLE DESCRIPTION ITEM Fe Active cell position after transfer 7 6 Copyright 1998 Durand amp Associates The cursor right default is ideal if you select one item at a time and wish to input the quantity after transferring data from the database If you plan to transfer more than one material item or you do not plan to input quantities after transferring data you should use the cursor down default CURSOR DOWN Before Transfer RECAP PRICING SHEET 1 JOB HAHE SAHFLE DESCRIPTION ITEH 1 2 3 4 After Transfer PFICIHG SHEET 1 JOB HAHE SAMPLE DESCRIPTION ITEH QTY MPRICE M Active cell position before transfer Active cell position after transfer The cursor down position leaves the active cell in the item column so you can access the database menu without repositioning the cursor RETURN to MAIN MENU 28 DOUBLE C
78. ing SAMPLE BWB File Edit Recap Assembly Sheets Pricing Sheets Quotes Other Print Pricing Menu x Open Close Save Save As Export MAT Files This command will export files to the material list module Printer Setup wit After exporting files exit the Double Click Estimating Program STEP 7 STARTING THE MATERIAL LIST MODULE To startthe Material List Module double click on the MAT icon Once the program has loaded the following screen will be displayed Menu la x HATERIAL LIST JOE FILE DATE 09714 95 ITEH QTY 1 2 3 4 5 5 g 3 10 11 12 13 14 1 1 2 Copyright 1998 Durand amp Associates STEP 8 COMPILING A MATERIAL LIST Using the mouse select the Menu and Compile List commands from the pulldown menu E DOUBLE CLICK Matenal List Module Mil xj Menu xj Compile List Print i Printer Setup This command will compile the material list The compile process can take up to five minutes TIME WARNING AN The compile process can take up to five minutes If you wish to proceed click OK SAMPLE COMPILE TIMES Our tests indicate the following compile times Pentium 133 MHZ 5 minutes 68 seconds Pentium Ill 300 MHZ 2 minutes 50 seconds During the compile process a status bar will display progress COMPILE STATUS 40 11 3 Copyright 1998 Durand amp Associa
79. ish to print Simply double click on the automatic cells to select the sheets you wish to print PRINT MAHAGEE RECAP JOB COST hot cells BONDING COST WORKSHEET GEHERAL BIDS OUTGOING EXCLUSIONS SCOPE OF WORE RECAP SHEET LIGHTING SUMMARY ASSEMBLY SHEET 1 LIGHTING VENDOR 1 ASSEMBLY SHEET 2 LIGHTING VENDOR 2 PRICING SHEET 1 LIGHTING VENDOR 3 PRICING SHEET 2 LIGHTING VENDOR 4 PRICING SHEET 3 LIGHTING VENDOR 5 LIGHTING VENDOR 5 to select QUOTES sheet QUOTE 1 QUOTE 2 QUOTE 3 QUOTE 4 QUOTE 5 QUOTE 6 PRICING PRICING SHEET 5 PRICING SHEET 9 PRICING SHEET 10 PRICING SHEET 11 PRICING SHEET 12 QUOTE 7 PRINT PRICING SHEETS SHEET 13 QUOTE 8 WITHOUT EXTENSIONS PRICING SHEET 14 AND LABOR UNITS PRICING SHEET 15 PRICING SHEET 16 PRICING SHEET 17 PRICING SHEET 18 PRINTING TAKES 20 60 SECONDS PER PAGE PRINTING ALLSHEETS TAKES 20 45 HIH After selecting worksheets goto the pulldown menu and select Start Printing SE DOUBLE CLICK Electrical Estimating File Edit Recap Assembly Sheets Pricing Sheets Quotes Other 00 Pricing Menu 21 x PRINT M HAGER Print Manager CAP Start Printing BOR RATE WORESHEET B COST WORESHEET PERMIT COST WORKSHEET BONDING COST WORESHEET MakeUp Manager ASSEMBLY SHEET 1 Start Printing MakeLlps Select Print and Start Printing fro
80. ity Labor units forwarded from makeup sheets DAT EST 2 123 Es Jar PAUL H EXT L UNIT L EXT 59 50 157212 24 57 1 55 gb 60 15 1 69 5 08 554 26 1 76 7 03 582 02 2 01 10 05 161 35 2T 13 03 127 67 2 14 15 01 258 15 2 43 19 40 262 55 2 08 18 73 320 24 2233 Bg 419 54 EB 29 16 510 14 2 50 29 94 521 13 2 84 35 91 of assemblies tz Dr FJ Er Er Er x Dr Dr Er Er Er Ez 1 FP Er FJ FJ PZ 2 015 E E E E E E E E E E E E E E E E E E E E E E E E E E E E E E E E E E E E E E E E E E Totals forwarded to recap 28 ecd Copyright 1998 Durand amp Associates ASSEMBLY MAKEUP SHEET Enter description Material prices automatically of assembly imported from database Activate the cell you wish to import into Labor units automatically and select material from pulldown menu imported from database ASSEMSLY SHEET ASSEMBLY MAKEUP SHEET 1 DATE 4 15 98 DESCRIPTION EST PAUL TEH M EXT LEET 1 4 04 0 50 2 0 23 0 04 3 0 43 0 09 4 50 39 0 14 5 hot cells 1 04 25 5 0 60 0 04 7 51 63 0 18 B 0 20 0 03 9 50 95 0 03 10 12 13 14 15 15 17 18 20 assembly sheets SUBTOTAL 59 50 MULTIPLIER DEFAULT 13 X X ASSEMBLY TOTAL If you wish you may manually enter items on the makeup sheet Type in the description arrow one
81. l Estimating EST BWB oO x File Edit Recap Assembly Sheets Pricing Sheets Quotes Other Print Pricing Menu la x ASSEMBLY PRICE SHEET 1 DATE a JOB SAMPLE TEMPLATE EST ASSEMBLIES 1 50 EST BY ITEM QTY M EXT LZUHIT LEET 1 SU 1G 1 1P 9 50 E 1 33 E 2 SU 15 1 3 ELE m 1 55 E 3 SU 15 1 4W 522 72 E 1 63 E 4 E E 5 SU 2G 2 1P 513 55 E 1 75 E 6 SU 2G 1 1P 1 3W 516 MD E 2 04E 7 SU 2d 1 1P 1 40 26 89 E 2 1Y E 8 SU 2G 2 3U 518 44 E 2 1 E Assembly Assembly Assembly descriptions prices labor entered entered entered No quantities entered 9 2 Copyright 1998 Durand amp Associates Let s look at the sample file pricing sheet File Edit Conduit Fittings Hangers Fasteners Boxes Wireway Wie Devices Power Defaults Main Menu la x FRICING SHEET 1 DATE JOB EST DESCRIPTION BRANCH CIRCUIT POWER EST BY ITEM H EXT LEET 1 2 3 4 5 5 g Material Material Labor descriptions prices units entered entered entered No quantities entered SAVING A TEMPLATE FILE Select the File and Template Save commands from the pull down menu a Edit Recap Assembly Sheets Pricing Sheets Quotes Other Print Pricing Menu la x Open Close Save Save As Export MAT Files Template Save This command will start the template save process Template Read Template Blank Printer Setup Enter new filename Put Version blank
82. m the pulldown menu PHT ING VENDOR 2 3 NOTE Printing takes 20 60 seconds per page and printing all sheets can take 20 45 minutes 6 1 4 Copyright 1998 Durand amp Associates MAKEUP MANAGER Non Linked Worksheets The makeup manager is used to select the makeup sheets you wish to print Simply double click on the automatic cells to select the sheets you wish to print ASSEMBLY MAKEUP PRINT MANAGER RECAP 21 MAKEUP 41 MAKEUP KEUP 81 22 MAKEUP 42 MAKEUP 1 hot cells 82 23 MAKEUP 43 HAKEUP KEUP 83 24 MAKEUP 44 HAKEUP 64 MAKEUP 84 25 45 MAKEUP 65 85 26 MAKEUP 46 MAKEUP 66 MAKEUP 86 27 MAKEUP 47 MAKEUP 67 MAKEUP 87 28 MAKEUP 48 MAKEUP 68 MAKEUP 98 29 49 69 89 AE id 30 MAKEUP 50 MAKEUP 70 HAKEUP 90 Pain 31 MAKEUP 51 71 91 32 MAKEUP 52 72 MAKEUP 92 33 53 73 93 234 MAKEUP 54 MAKEUP 74 MAKEUP 94 35 MAKEUP 55 MAKEUP 75 MAKEUP 95 36 MAKEUP 56 MAKEUP 76 HAKEUP 96 37 MAKEUP 57 MAKEUP 77 HAKEUP 97 38 MAKEUP 58 MAKEUP 78 MAKEUP 98 239 MAKEUP 59 MAKEUP 79 MAKEUP 99 40 MAKEUP 60 MAKEUP 80 MAKEUP 100 PRINTING TAKES 20 60 SECONDS PER PAGE PRINTING ALLSHEETS TAKES 30 90 After selecting worksheets goto the pulldown menu and select Start Printing MakeUps
83. n puzzled as to why companies publishing estimating software want to reinvent the wheel The first time saw a demonstration of an estimating software package the guy doing the demo said Just type in the part number for a 4 Square Box and presto up pops the price and labor unit That s neat said But how do find the number for a 4 Square Box He said Turn to Section 7 in the user s manual turned to Section 7 which contained 154 pages of part numbers So much for presto 1 2 Most of the estimating programs have reviewed force the estimator to learn a totally new way of estimating Additionally the estimator is forced to read a large user s manual to become familiar with this new way of estimating Sometimes it s faster to estimate the job by hand rather than go through all the set up functions in these complex computer programs STICKING WITH THE BEST In the early 1980 s I thought to myself how great it would be if someone would develop an estimating system that did not require the users to learn a new way of thinking This estimating system would display standard pricing sheets and the user would enter information in familiar places The program would instantly perform all extensions and any single change would be reflected in the final price on the recap sheet In 1992 we shipped a DOS estimating program call Estimator 386 Since that time thousands of electrical contractors have used our programs In 1994 we changed
84. n sell hardware and software packaged together in a turnkey system 1 1 The first turnkey systems were for accounting and payroll The software was written by accountants and programmers These turn key systems cost around 20 000 Today you can buy accounting software for your personal computer for around 300 As competition among systems houses increased their products became more specialized New systems were developed adding job costing and estimating to the accounting packages These new features or modules as they were called were after thoughts and were somewhat less than user friendly SYSTEMS FOR ELECTRICAL CONTRACTORS The 1980 s saw the introduction of wide spread use of the personal computer With the reduced cost of computer equipment new companies emerged that could now address a larger market opecialized systems were developed for electrical contractors Many of these systems were put together by former electrical contractors and addressed the needs of the industry These new firms would write estimating software purchase accounting software and interface these packages with pricing software used by the electrical wholesale industry They would then package this software with computer hardware and sell it to electrical contractors These packaged systems sold for around 16 000 In a six month period during 1986 saw fifty four 54 companies advertising estimating software packages for electrical contractors In 1995
85. ndustry to use these TRADE PRICES for the basis of calculating your actual cost We did not create this standard it simply evolved over time While this may not be the best system itis the most widely used and accurate system we have found SUPPLIER DISCOUNTS Your local electrical supplier can provide you with a list of discounts to be used with these trade prices These discounts can be entered in the program thus providing you with adjusted cost When you receive your program typical discounts have already been entered in the database You may change these discounts to more accurately reflect your market conditions 1 0 1 Copyright 1998 Durand amp Associates ADJUSTED PRICING LEVELS We highly recommend you change the discount levels to reflect your adjusted pricing levels This way when the trade prices are updated the adjusted prices will reflect these changes USER PRICING The Pricing amp Labor Software also allows the user to enter his own price for any material item If you enter user pricing you will have the enormous task of updating you own prices We highly recommend using the adjusted pricing levels BID LEVEL PRICING Itis important to understand that bidding work at today s actual cost can result in loss of profits If you bid at your cost these prices may change prior to purchasing the materials It was with this thought in mind that we created the database of discount levels in the program The adjusted prices in this
86. ng and assembly sheets you want to use PRICING SHEETS Quantity 18 The pricing sheets are where you enter the material description price and labor units These pricing sheets are identical to the standard pricing sheets used for over fifty 50 years in our industry Totals are automatically forwarded to Recap Sheet ASSEMBLY TOTALS SHEETS Quantity 2 The assembly totals sheets are where you enter the number of assemblies required on a given estimate If you wish to change an assembly you must go to the appropriate make up sheet Totals are automatically forwarded to Recap Sheet MAKE UP SHEETS Quantity 100 The make up sheet is where you name the assembly and enter the material and labor required for one typical assembly The total cost of this make up sheet is forwarded to the appropriate line of the assembly totals sheet BONDING COST WORKSHEET Quantity 1 This is where you calculate the bonding cost You may enter a flat percentage or a tiered bonding percentage Totals are automatically forwarded to Recap Sheet JOB COST WORKSHEET Quantity 1 This is where you calculate the direct job cost associated with a particular estimate Totals are automatically forwarded to Recap Sheet PERMIT CALCULATION SHEET Quantity 1 This is where you calculate the permit cost associated with a particular estimate Totals are automatically forwarded to Job Cost Worksheet LABOR COST WORKSHEET Quantity 1 This is where you calculate your
87. nsferring data you should use the cursor down default CURSOR DOWN Before Transfer PRICING SHEET 1 JOB SAMPLE DESCRIPTION ITEM QTY M PRICE 1 Ee 2 3 4 After Transfer RECAP PRICING SHEET 1 JOB SAMPLE DESCRIPTION ITEH M PRICE 93 93 3 Y T 2 3 4 Active cell position after transfer Active cell position before transfer The cursor down position leaves the active cell in the item column so you can access the database menu without repositioning the cursor PRINT PRICING SHEET If you want to print the pricing sheet select Print and Print Pricing Sheet commands from the pulldown menu DOUBLE CLICK Pricing amp Labor PL BwB Ej File Goto Conduit Fittings Hangers Fasteners Boxes Wireway Wire Devices This command will print pricing sheet 10 10 Power Defaults Print Database Sheet Print Recap Print Pricing Sheet Copyright 1998 Durand amp Associates PRINTOUT OF PRICING SHEET PRICING SHEET DATE JOB NAME EST DESCRIPTION EST BY ITEM OTY M PRICE M EXT L UNIT L EXT 1 GRC ELL 36R 2 du S72 138 S865 56 0 85E 10 20 2 TOGGLE BOLT 3 16 X 6 26 S39 80C 510 35 7 00 1 82 3 50411 2 1D COMBO 2 2349 29C 517 46 25 00C 1 25 4 SINGLE REC 15A BR 5015 23 S356 80C 582 06 25 00 C Telg 5 E E 6 E E 7 E E 8 E E 9 E E 10 E E 11 E E 12 E 13 E 12 E 15 E E 16 E E La E E 18 E E L9 E E
88. onal pricing updates will be shipped during the FREE 1 Year period After the first year your renewal subscription to the Pricing amp Labor software is only 295 per year An invoice will automatically be sent to you when your FREE subscription is about to expire INTRODUCTION The Pricing amp Labor Software is a subscription service program designed to aid electrical contractors in the preparation of cost estimates The program contains a database of both material cost Trade Prices and labor units The program also allows the user to estimate small jobs or change orders on the built in pricing and recap sheets AUTOMATIC PRICE UPDATES Subscribers to the Pricing amp Labor Software receive three price updates per year The prices are updated via diskette in January May and September NEW ITEMS OR DELETIONS In addition to updated prices three times per year the database is periodically updated with information about new or deleted items by the manufacturers LINK TO ESTIMATING PROGRAM The Pricing amp Labor Software also links to the Double Click Electrical Estimating Program PRICING INFORMATION The prices in this program are TRADE PRICES and are the published prices of various manufacturers Trade prices are updated by the manufactures every 9 18 months Each pricing screen in the program lists the manufacturer price and the date the prices were published INDUSTRY STANDARD PHICING It has long been the standard of the i
89. only six 6 of these companies were still in business Of the six 6 remaining companies in 1995 only three 3 remain today MICROSOFT S OPERATING SYSTEM DOS The first IBM PC s ran at 5 MZ and used DOS Disk Operating System to control how the computer operated The DOS operating system is a non graphical system which does not support the use of a mouse During the late 80 s and early 90 s electrical estimating programs were written for use in DOS WINDOWS In 1995 Microsoft introduced it s first graphic user interface GUI operating system called Windows 95 Since this new operating system supports the use of a mouse electrical contractors are now demanding estimating programs with graphic user interfaces GRAPHIC USER INTERFACE WINDOWS The simplicity of point and click mouse control is a tremendous improvement in the user interface IF IT S NOT BROKEN DON T FIX IT Remember when digital wrist watches first came to market They had a red colored crystal and you had to push a button to activate the LED display With these new watches it took two 2 hands to read the time and you better be standing in the shade Over the years electric wrist watches have improved Today these watches can be read by using one hand and the display is back to the tried and proven little hand big hand Over the past fifty 50 years the standard estimating method of pricing amp recap sheets has served our industry well Therefore have bee
90. program should be somewhat higher than your actual cost Please check these discounts with your supplier LABOR UNITS INFORMATION The labor units in the program are from the Electrical Contractors Labor Units Manual published by Durand amp Associates These labor units were compiled over the past 30 years using actual job cost data from various electrical contractors COMPETITIVE LABOR UNITS The labor units in this program are competitive Meaning they are more realistic than labor units found in the NECA or R S MEANS manuals We consider these labor units to be Bid Level Competitive ADJUSTED LABOR UNITS When you receive your program a 10 adjustment factor has been entered in the labor adjustment column You may change these adjustment factors to more accurately reflect your market conditions USER LABOR UNITS This program also allows the user to enter his own labor unit for any material item BID LEVEL LABOR It is important to understand bidding work with excessively low labor units can result in loss of profits The adjusted labor units in this program should be somewhat higher than your actual labor Please check these adjustments against your past productivity levels 1 0 2 Copyright 1998 Durand amp Associates ABOUT THIS PROGRAM The Pricing amp Labor Program is actually two 2 programs in one Firstis the DATABASE mode and second is the ESTIMATING mode DATABASE MODE The DATABASE mode is used to maintain
91. s Pricing Other Print Pricing Menu XEST SAMPLE EBWEB RECAP SHEET VERSION 1 04 JOB DATE EST SHEET MATERIAL LABOR HES Al ASSEMBLIES 1 50 2 019 28 212 13 SSEHBLIES 50 100 2838 51 104 04 al RANCH CIRCUIT POWER Sio 144 73 2 RANCH CIRCUIT LIGHTING 653 73 65 53 3 RANCH CIRCUIT SITE LIGHTING 170 73 17 50 4 EDDER CONDUITS 2 835 47 41 48 5 HOT USED 5 HOT USED HOT USED 8 HOT USED 8 2 Copyright 1998 Durand amp Associates SAVE A FILE To save the active file select File and Save commands from the pulldown menu EE DOUBLE CLICK Electrical Estimating SAMPLE Oy xj lee Edit Recap Assembly Sheets Pricing Sheets Quotes Other Print Pricing Menu x Open Close This command will save active file Save Export MAT Files Template Save Template Read Template Blank Printer Setup E xit SAVE A FILE BY A NEW NAME To save the active file by a new filename select File and SaveAs commands from the pulldown menu EE DOUBLE CLICK Electrical Estimating SAMPLE xj lee Edt Recap Assembly Sheets Pricing Sheets Quotes Other Print Pricing Menu 2 x Open Close Save This command will prompt you to enter a new filename Esport MAT Files Template Save Template Head Template Blank Printer Setup E wit Enter new filename File Save est bwb sample hwh Enter new filename then click OK
92. t 17 Assembly MakeUp Sheets 4 1 2 Copyright 1998 Durand amp Associates STEP 25 OPTIONAL STEP If you wish to print the Assembly MakeUp Sheets from the sample estimate on your printer select Print and Start Printing MakeUps from the pulldown menu DOUBLE CLICK Electrical Estimating SAMPLE BWE File Edit Recap Assembly Sheets Pricing Sheets Quotes Other DINI Pricing Menu x ASSEMBLY MAKEUP PRINT MANAGER Print Manager Start Printing MAKEUP 1 MAKEUP 21 61 OPTIONAL STEP Fa 63 Select Print and Start Printing MAKEUP 64 MakeUps from the pulldown menu MAKEUP 65 NOTE If you choose not to print the Assembly MakeUp Sheets from the sample estimate a sample printout is included in Section 5 of this manual 4 1 3 Copyright 1998 Durand amp Associates SAMPLE PRINTOUTS Hecap Sheet C EST SAMPLE BWB RECAP SHEET JOB NAME SAMPLE DATE 9 15 98 EST BY PAUL 123 SHEET MATERIAL LABOR HRS A1 X ASSEMBLIES 41 50 2 819 28 212 13 A2 X ASSEMBLIES 50 100 838 61 104 04 1 X BRANCH CIRCUIT POWER 1 225 09 144 73 2 X BRANCH CIRCUIT LIGHTING 653 73 85 53 3 X BRANCH CIRCUIT SITE LIGHTING 170 73 17 50 4 X FEDDER CONDUITS 2 835 47 41 48 5 NOT USED 6 NOT USED 7 NOT USED 8 NOT USED 9 NOT USED 10 NOT USED 141 NOT USED 12 NOT USED 13 NOT USED 14 NOT USED 15 NOT USED 16 NOT USED 17 NOT USED 18 NOT USED MISC MATERIAL amp
93. t MakeUp Manager from the pulldown menu DOUBLE CLICK Electrical Estimating SAMPLE BWE File Edit Recap Assembly Sheets Pricing Sheets Quotes Other Pricing Menu x PRINT Print Manager CAP Start Printing BOR RATE WORESHEET B COST WORESHEET PERMIT COST WORESHEET BONDING COST WORESHEET RECAP SHEET ASSEMBLY SHEET 1 Select MakeUp Manager from the pulldown menu MakeUp Manager Start Printing DOUBLE CLICK Electrical Estimating SAMPLE BWE File Edit Recap Assembly Sheets Pricing Sheets Quotes Other Print Pricing Menu 8 x ASSEMBLY MAKEUP PRIHT HAHAGEE RECAP 1 21 MAKEUP 61 MAKEUP 81 2 X22 MAKEUP 62 MAEEUP 82 3 235 MAKEUP 63 MAKEUP 83 4 zd MAKEUP X54 MAEEUP 54 5 25 MAKEUP 65 MAKEUP 85 6 26 MAKEUP 66 86 E 27 MAKEUP X57 87 5 25 MAKEUP 69 MAKEUP 88 9 29 MAKEUP 69 MAKEUP 89 10 30 MAKEUP 70 MAEEUP 90 11 31 MAKEUP 71 MAKEUP 91 12 32 MAKEUP X72 MAKEUP 92 13 33 MAKEUP E73 493 14 34 MAKEUP Hyd MAKEUP 94 x 35 MAKEUP 75 95 16 36 MAKEUP 76 MAEEUP 96 17 7 MAKEUP 7 MAKEUP 97 18 38 I 19 39 20 40 PRINTING TAKES 20 60 SECONDS PER PAGE PRINTING ALLSHEETS TAKES 30 90 HIH 4 ESSE READY 9 8198 1 20 P caLc The sample estimate will prin
94. tems command This can be very helpful when taking off branch circuit wiring EXAMPLE 1 2 3 4 and 1 items are used on branch circuit wiring and may be tagged with one action of the mouse DEFAULTS MENU DOUBLE CLICK Electrical Estimating S amp MPLE B wB Import Special Tags Retum 28 x Trade Price w Adjusted Price User Frice You may also set pricing and labor levels from the pulldown menu Standard Labor w Adjusted Labor Active levels marked with a check mark User Labor 7 5 Copyright 1998 Durand amp Associates RETURN MENU DOUBLE CLICK Electrical Estimating SAMPLE BWB Import Special Tags Defaults x Return ta Pricing or MakeUp Sheet Return Return to main menu without importing items PRICING MENUBAR continued After returning from the database screen the pricing menubar will reappear 2 DOUBLE CLICK Electrical Estimating SAMPLE Mil xj File Edit Conduit Fittings Hangers Fasteners Boxes Wireway Wire Devices Power Defaults Main Menu 2 x DEFAULTS MENU 2E DOUBLE CLICK Electrical Estimating S amp MPLE B wB xj File Edit Conduit Fittings Hangers Fasteners Boxes Wireway Wie Devices Power Main Menu 8 x Trade Price Adjusted Pri You may also set pricing and labor levels from T E ser Price the pulldown menu Standard Labor You may also set the Cursor R
95. tes Once the compile process is complete the material list will be displayed on your screen 2 DOUBLE CLICK Material List Module HAT BWB Menu MATERIAL LIST JOB SAMPLE FILE EST SAMPLE EBWB DATE 09 14 98 ITEM WIRENUT RED WIRENUT GRAY THHN CU STRAHDED 300 THHN CU STRANDED 3 0 THHN CU STRANDED 12 THHN CU SOLID 12 THHN CU SOLID 10 SW 4W 20 IV C5420 2I 9 SY 3W 20 320 22 10 SW 20 IV 5120 21 11 154 IV 5115 21 12 204111 COVER BLAHE 13 50411 2 1D 1 14 BSO4 RING 2G RAISE 1 2 15 SO4 RING 1G RAISE 1 2 15 504 COVER BLAHE 17 514 1 5D COMBO 18 S04 1 5D 344 KO 13 S04 1 50 172 Eo 0 PVC 40 ELL 3 4 21 PVC 40 COUP 3 4 22 PVC 40 3 4 4 CO CO H QTY 313 26 400 240 200 zB 875 ed 4 00 102 12 5 5 3l 130 20 82 g 20 14 42 350 wr pu READY 9 1 4 38 4 45 CALC STEP 9 PRINTING MATERIAL LIST To print the material list select the Menu and Print commands from the pulldown menu E DOUBLE CLICK Matenal List Module IMAT 41 1 OO xj Compile List 18 This command will print the material list Printer Setup wit 11 4 Copyright 1998 Durand amp Associates SAMPLE PRINTOUTS Material List Printout from Material List Module MATERIAL LIST JOB UNTITLED FILE C EST MAT2 BWB F
96. tes makeup manager ager must be displayed be fore print commands will work Start Printing Non active grayed out Start Printing MakeUps Non active grayed out PRICING MENUBAR The pricing menu bar activates anytime you display a pricing or makeup sheet DOUBLE CLICK Electrical Estimating SAMPLE BWB B x File Edit Conduit Fittings Hangers Fasteners Boxes Wireway wie Devices Power Defaults 8 x To return to main menu use the Main Menu command FILE MENU DOUBLE CLICK Electrical Estimating SAMPLE BWB LE x a Edit Conduit Fittings Hangers Fasteners Boxes Wieway Wire Devices Power Defaults Main Menu la x Open Open Opens a file stored on your hard disk ave Save Close Closes current file Export Files i Save Saves current file Printer Setup SaveAs Saves current file with a new name Export MAT Files Exports files to Material List Module Printer Setup Allows you to select a printer Exit Exits Double Click returns to Windows EDIT MENU 2 DOUBLE CLICK Electrical Estimating S amp MPLE B wB File Conduit Fittings Hangers Fasteners Boxes Wrmeway Wire Devices Power Defaults Main Menu x Clear Active Worksheet Copy Active Worksheet Paste Clipboard Worksheet Arrange Active Worksheet Clear Active Worksheet Clears active sheet Copy Active Worksheet Copy active sheet to clipboard Paste Clipbo
97. the name of the program to Estimator 2000 and added a 23 000 part database called Pricing amp Labor Software and Material List Module In April of 1996 we started development of the Windows based Double Click estimating program Programming in the Windows environment is much more time consuming than programming in DOS This explains why there are so few Windows based estimating programs It has been a long road developing this program and we are proud to be shipping this product KISS KEEP IT SIMPLE STUPID When began writing the Double Click program my goal was to create a simple user friendly program One that would be easy to use and quick to learn did not want to teach the user a new way of estimating rather wanted the computer to display familiar forms that would need little or no explanation We designed Double Click to take advantage of the easy use of pulldown menus Unlike other estimating programs which require the user to scroll through never ending lists of materials with Double Click you simply select material from pulldown menus What you see is what you get In Double Click you can view or work with any form while estimating the cost of the job When your estimate is printed it looks the same as the display on the screen This may sound simple but it is not Most estimating programs do not offer this feature LISTENING TO OUR CUSTOMERS Customers first started using our estimating software in 1987 Since that tim
98. tup Exit FILE SAVEAS DOUBLE CLICK Pricing amp Labor PL BWB Goto Conduit Fittings Hangers Fasteners Boxes Wiemway Wire Devices Power Defaults Print gt Close Save This command saves the current file by a new name Save Charges to Database Clear Active Sheet Printer Setup Exit 10 14 Copyright 1998 Durand amp Associates MATERIAL LIST MODULE The Material List Module is used to compile a material list from an estimate This module will count all materials on pricing sheets and within assembly makeups and provide a printout of material EXPORTING ESTIMATE FILES TO MATERIAL LIST MODULE Prior to using the material list module you must first export the files from the Double Click Electrical Estimating Program STEP 1 STEP 2 S IEP 3 STEP 4 Start the estimating program Open the estimating file you wish to export The Material List Module will compile only those pricing sheets used in your estimate If a pricing sheet is marked with an X on the recap sheet the Material List Module will compile all material on that pricing sheet If a pricing sheet is not marked with an X on the recap sheet the Material List Module will ignore that pricing sheet If you have any pricing sheets you do want compiled turn those sheets off on the recap sheet DOUBLE CLICK Electrical Estimating SAMPLE_B WB File Edit Recap Assembly Sheets Pricin
99. ummary SUMMARY OF LIGHTING QUOTATIONS VENDOR VENDOR VENDOR VENDOR VENDOR VENDOR LOWEST VENDOR NAME ABC SUPPLY LOW BID SUPPLY PRICE FORWARDED TO RECAP JOB NAME SAMPLE PRICE 1 378 22 1 328 70 1 328 70 Copyright 1998 Durand amp Associates SAMPLE PRINTOUTS Lighting Fixture Quotation Vendor 1 LIGHTING FIXTURE QUOTATION FROM VENDOR 1 JOB NAME SAMPLE VENDOR ABC SUPPLY TIME 11 TED DATE g 1 98 PHONE 988 6265 PAX 988 6335 TYPE QTY PRICE EA TYPE QTY PRICE EA 10 545 60 19 2 S89 30 20 521 67 21 84 00 22 S72 65 23 24 25 26 27 28 29 30 31 15 32 15 33 16 34 L7 35 18 36 1 2 3 4 3 6 7 8 9 w N VENDOR TOTAL FORWARDED TO LIGHTING QUOTATION gt gt gt SUMMARY 1 378 22 Lighting Fixture Quotation Vendor 2 LIGHTING FIXTURE QUOTATION FROM VENDOR 2 JOB NAME SAMPLE VENDOR LOW BID SUPPLY TIME 11 30AM CONTACT TEX DATE 9 4 98 PHONE 986 5656 FAX 986 5551 TYPE QTY PRICE TYPE QTY PRICE A 10 844 10 19 91 25 20 26 00 od 78 30 69 80 23 24 25 26 27 28 29 30 31 32 15 33 16 34 15 35 18 36 UI e wW N VENDOR TOTAL FORWARDED TO LIGHTING QUOTATION gt gt gt SUMMARY 31 328 70 5 9 Copyright 1998 Durand amp Associates SAMPLE PRINTOUTS Power Quotations POWER QUOTATIONS JOB NAME SAMPLE RECAP VENDOR CONTACT PHON
100. you may use for a cover page to your estimate This sheet does not forward information PROPOSAL SHEET Quantity 1 This is a page you may use for a proposal page This sheet does not forward information 2 4 Copyright 1998 Durand amp Associates LOADING INSTRUCTION It is important to understand that the installation of Double Click will create the following folders on your C drive CAEST CATPRICE CAUPRICE These folders must be installed on your C drive for the proper operation of Double Click NOTE IF YOU ALREADY HAVE FOLDERS BY THESE NAMES YOU MUST RENAME YOUR EXISTING FOLDERS Insert the CD in your CD Drive After a few seconds the installation program will start Follow the instructions to complete your installation After installation is complete Click OK Dopo Im The installation program will place three 3 shortcuts on your desktop The EST shortcut will start the Estimating Program The PL shortcut will start the Pricing amp Labor Software The MAT shortcut will start the Material List Module These shortcuts will also be placed in the START PROGRAMS menu fug DOUBLE CLICK Shortcut Ea PL EXE Shortcut ta EST EXE Shortcut to MAT EXE 3 1 GETTING AROUND The quickest way to learn this program is to review the sample estimate included with this program This estimate has been completed and therefore will not require any user input The sole purpose of this sample ex

User`s Manual - Durand & Associates

Contents

Download Pdf Manuals

Related Search

Related Contents

User`s Manual - Durand &amp; Associates

Contents

Download Pdf Manuals

Related Search

Related Contents

User`s Manual - Durand & Associates