|
|
|
775 Old Westtown Road, West Chester, Pa.
19382-4960 |
|
artisan`s estimating v3.0 |
|
|
| |
|
|
|
artisan`s estimating |
|
(Ooo_artEst_4th07_v3.xls/.ods) Expiration date
July,4th 2007 ** |
|
|
|
|
|
Module Resource Locator |
|
|
|
artisan`s estimating spreadsheet workbook |
| |
|
The spreadsheet template you will be working with is "User
Friendly", and by sticking to the basic Module Format you will find
that once you have assembled your data, you can stay with it for
years. |
| |
|
By updating your data (vendor prices) on a regular basis, you can
estimate quickly |
|
and accurately. |
| |
|
Because of the extensive list of products and manufacturers needed
to supply a database, and to keep the price low enough for you to
purchase. I have provided a limited
amount of generic data. Any additional data entry is left to you.
In time, you will be able to maintain a database of your own. I have
begun the Module Assembly process, so that you may get started right
away. |
| |
|
This estimating program is made up of 19 worksheets, and they are: |
| |
|
tobins: |
|
This worksheet contains brief explanations of the components of the
estimating modules. |
| |
|
residential: |
|
Ninety Six residential wiring modules, for receptacles, switches,
recessed lighting, general lighting, appliances, heating and air
conditioning components, electric baseboard heat etc. etc.. |
| |
|
restally: |
|
A one-page printable tally sheet of all the components used for the
estimating project. |
| |
|
commercial: |
|
Unlike its brother "Residential", "Commercial" provides greater
flexibility. Five TID entry points. Five Individual TID time
overrides, plus a conduit and wire run section. |
| |
|
commtally: |
|
Here is a similar sheet to "restally", only twice as many pages of
stuff to print out. TID'S used in your "residential" worksheet work
here and versa visa. |
| |
|
data:
In a centralized location! |
|
Twenty columns of RAW Horsepower. data is the heart of the workbook. |
| |
|
industrial: |
|
Ninety six estimating modules. A commercial clone here. We've added
some extras. Two more TID's, for more complex systems. |
| |
|
industally: |
|
Here is a similar sheet to "commtally", only four times as many
pages of stuff to print out. TID'S used in your "residential"
worksheet work here and versa visa. |
| |
|
framer: |
|
Our most recent addition, framer is a 60 module estimating worksheet
designed with the carpenter in mind. |
| |
|
framer tally: |
|
This tally worksheet is similar to all the others tally worksheets |
| |
|
service: |
|
Ten different service modules awaiting you, plus what I call "Two
Page Est". |
|
Great flexibility here! |
| |
|
data ii: |
|
Here is where all them numbers, your accountant tells you to use,
can go. |
|
##### data ii also contains the "Square Footage Multiplier. ##### |
| |
|
lookup: |
|
This worksheet is the repository of all the modules in the workbook.
All the data in this worksheet are transferred to the tally sheets
when you enter a CID and press the F9 key. |
| |
|
timing: |
|
A handy reference table that converts seconds into tenths of hours. |
| |
|
assemblies: |
|
When you have a module component that requires little more tweaking,
here is where you get to work your magic. |
| |
|
##### Assembly CID'S should be prefixed with the ASSM header. ##### |
|
|
|
linker: |
|
This worksheet provides you with a link to all your estimating
modules. |
|
|
|
tally sort: |
|
This worksheet is just an ordinary worksheet used for whatever you
need. |
|
|
|
register: |
|
Current pricing, registration, licensing and commentary worksheet. |
|
|
|
|
|
|
|
The Residential Estimating Module contains 15 sections, |
| |
|
Division and Title Bar: |
| |
 |
|
There are 5 estimating module columns with 16 Modules for individual
assemblies. Each Module contains a Division section, and a Title
section. They are not made of Granite, and may be modified to suit
a particular taste. |
| |
|
Vendor Component ID Entry Section: |
| |
|
Vendor Component ID, be certain that you use the "Paste
Special/Values" function provided with your *"Excel" office package. |
|
|
 |
|
The 1st four cells are for the major components of your assembly,
and are highlighted in( Bold/Blue ). This formatting is identical
with the "CID" on the "DATA" sheet, for easy copy and pasting. The
5th cell is a "Dealers Choice" type cell, you may enter an
assembly, i.e. wire nuts, staples, ( per NEC )and ground fittings. |
| |
|
The 5th cell has been formatted with a different text color, for
ease of Identification. |
|
|
|
If you need to add another component, I suggest you add the
additional component in the "Assembly" section to maintain
conformity. |
| |
|
Run Length: |
|
The anticipated footage of the wire run is entered into the
right-most cell of this two-cell section in order to achieve a
calculation free from format errors when there is no wire involved,
the footage of run should contain the value 0.0001, this is a
necessity in "Excel". |
|
|
|
Wire ID: |
|
The Type of wire you anticipate using is entered into the left-most
cell, using the protocol established in the "DATA" section. This
item may be hand entered, or transferred from the "DATA" section
using "Excels" ( Copy/Paste/Special Values ) function. The
right-most cell contains a lookup function and must not be cleared,
deleted, or changed. |
|
|
|
Wattage Entry Section: |
|
The purpose of this section, is to provide the spreadsheet, with a
wattage value, so that it may compute a percentage of use of a
breakers load. It applies the cost of installing a breaker,
connector, and conductor to the spreadsheet. It also provides the
spreadsheet with a value, which is applied to the material list,
which is located on the "TALLY" sheet. In order to achieve a
calculation free from format errors when. there is no wattage
involved, the wattage cell should contain the value 0.0001, this is
a necessity in "Excel". |
|
|
|
Breaker Designation Section: |
| |
|
The left-most cell must always contain a "CID" or an asterisk * .
Highlighted in ( Bold / Blue ) format, this two-cell section
contains a data entry cell in the left-most cell. The rightmost cell
contains a lookup function and must not be cleared, deleted, or
changed. |
|
|
| |
|
When you enter breaker data in the data section, you must include
the wattage the breaker is designed to handle, this information, is
a necessity for the spreadsheet. Without this, the spreadsheet will
return an error value, and will corrupt the entire template. |
|
Vendor Data ID Pricing Section: |
| |
|
The left-most cells of this section are simply Labels, and need be
of no concern. |
|
|
| |
|
The cell identified as the Breaker Labor cell, is a calculated cell.
This cell returns a value based on a calculation of, the amount of
time it takes to install a breaker, and a wire into a load center,
and energize. This calculation is then divided by the percentage of
breaker use. You may over-ride this calculation by entering a Zero
into the Breaker Labor cell. |
|
Caution!! Once overwritten, you will need to copy information from
another cell to this one. |
|
The cell identified "Breaker use %" is a calculated cell and is
needed by the formula for "Breaker Labor". The cell identified as
"Device Labor" is a user entry cell. I don't know how you arrive at
a value for this calculation. I got my times from a book at the
Library. Of course, these times may not suit you, and I don't
expect them to. |
| |
|
Your time must be entered in decimal format, so I have provided a
printable conversion chart for you, it is located in the "timing"
worksheet. |
| |
|
Material and Labor Verification Section: |
|
|
| |
|
The first and second cells in this section verify the "Vendor ID"
entered in the Conductor Choice section and the "Breaker ID"
section. The remaining three cells, are labels, which identify the
cell to their right. |
| |
|
The value on the right of the "Wire ID" cell verifies the value
entered into the right-most cell of the "Wire ID and Run" section,
this value is also transferred to the "Tally" section for wire
tabulation. The value to the right of the "Breaker ID" cell returns
a value, calculated by the spreadsheet, which is used to calculate
the total amount of breakers needed in the estimating project. The
cell to the right of "Device Minutes" returns a value, in minutes,
to confirm to you how much time the Module application should take
to complete. |
|
The dark grayed out section to the right of the verification section
are linking cells. Clicking on anyone of the five cells will take
you to that section of the workbook. The cell to the right of
Circuit Wattage is the modules ID. |
| |
|
Dealers Choice: |
|
|
|
This section verifies the total of amounts entered in the "dataii"
worksheet. They are local override cells. If you have a high
ticket item, and want to adjust any of these mark-ups, you may do so
by entering a value until you arrive at a "List Price" you live
with. |
|
Caution!! You will need to restore the formula, to use the
spreadsheet for another estimate. |
| |
|
Cost, Profit, List and Component ID: |
|
|
|
The top line, of calculated values, applies the mark-up values to
the vendor cost. |
|
For example: |
| |
|
Cost: Formula: =(D13*F9) or (vendor price * materials
cost) |
|
Profit: Formula: =((D13+E13)+*F10) or ((vendor price + cost
mark-up)* profit mark-up) |
|
List: Formula: =SUM(D13:F13) this is a no brainer. |
| |
|
The device Component ID (CID) "R/DUPLEX"
should have relevance to the device use. |
| |
|
The second line, of calculated values, applies the mark-up values of
Labor to the first two cells and sums it up in the third. |
| |
|
Cost: Formula: =(D14*F11) or (labor price * labor
cost) |
|
Profit: Formula: =((D14+E14)+*F10) or ((labor price + labor
mark-up)* profit mark-up) |
|
List: Formula: =SUM(D14:F14) this is a no brainer. |
| |
|
Tobin`s |
|
|
|
** Excluding the student version. This workbook is a 90 day demo,
and will render itself inoperative on this date. |
All
office suite
applications are developed, or customized free of charge, and are done on a first come
first served
basis.
Registration is required for email support!
|
Customer
Support:
mike.tobin@artisans-estimating.com
|
| |
