is appropriate while doing the matrices will be going up the catalog, to chaining his way through the arrays themselves, because once completed, if you do not have this care, it is very slow to find a Matrix.
The procedure is simple, consider the first step:
The procedure is simple, consider the first step:
SHEET 1
Once this happened, we will name the columns that we will use: Column "A" will be occupied by the "KEY", "B" with "Concept", the "C" for "unity", the "D" for the "direct costs", the "E" Cost "INDIRECT" and "F" for the "unit price".
is appropriate to the last three columns, because when we do a budget, it can be to us direct costs required, so that we would use the data in column "D" (4); if we are asked to UNIT PRICE, then take the data in column "F" (6). Let's see what it will look:
is appropriate to the last three columns, because when we do a budget, it can be to us direct costs required, so that we would use the data in column "D" (4); if we are asked to UNIT PRICE, then take the data in column "F" (6). Let's see what it will look:
SHEET 2
We have prepared our catalog sheet, we can now start loading the elements that we created. It is important to define what will be the order in which you will put your concepts, you can be in consecutive order according to their numbers or you can group them by activity, ie a space for primary concepts, such as mortars, fillers, etc.., One for Preliminary work, such as strokes, trims. Land clearing, etc. Finally, it will accommodate you as you are more practical, now let's just watch the procedure:
In Column "A", corresponding to the key, put the sign "=" then we'll go to the road we want to link matrices, to place in the key matrix chosen.
In Column "A", corresponding to the key, put the sign "=" then we'll go to the road we want to link matrices, to place in the key matrix chosen.
LAMINA 3
When demos "Enter", you automatically return to our catalog sheet, but we'll see that the legend B-0100 appears in the box A9
LAMINA 4
The next step will be the long description of the concept tested with the number B-0100: PLATE
5
so that the legend of the concept we fit in the space of column B, you need to make a slight adjustment:
PLATE 6
By accepting, we will see how the line expands to accommodate the entire legend. Now we continue with the column "C", corresponding to the Unit, for being so simple, we chose to drive directly in the case before us is an hourly rate (CH)
PLATE 7
Then we will go page of "UNITS" and place the cursor on the box that has the direct cost. LAMINA
8
The next step is to find the indirect cost, remember that this is the value that will be the implementation of each unit that we use in this matrix. Calculation table is at the bottom of the sheet LABOR, so the catalog will link the box with that of LABOR:
SHEET 9
Table indirect analysis, we present may be different, always according to their own needs, the important thing is to have a final percentage will choose to bind it to our catalog: SHEET
10
carrying this value to our catalog sheet, we just do the operation to Direct Cost multiplying the percentage of the Indirect. LAMINA
11
For all other Matrices they emerge, will follow the same procedure, so that when we finish analyzing our pricing, we have already available the catalog unit price.
We have seen the basics of build our own unit price system, we will now search tools at our disposal to quickly locate items within each page.
We have seen the basics of build our own unit price system, we will now search tools at our disposal to quickly locate items within each page.
0 comments:
Post a Comment