When you open the Excel program for Windows (Microsoft), we are looking at a sheet clean calculation, that at the bottom shows several "tabs": Sheet 1, Sheet 2, etc.
Right of "Mouse", we click on the tab 1, you'll see a menu and move the cursor to the legend "renaming" or "rename" put the cursor over the tab and you will name "MATERIALS"
Right of "Mouse", we click on the tab 1, you'll see a menu and move the cursor to the legend "renaming" or "rename" put the cursor over the tab and you will name "MATERIALS"
let us go to the Main Menu, Group "File" or "File", move the cursor to the " Save as "or" Save as "and in the window that opens, put the name that will identify our" Book "can be" Unit Prices "or" PU-xx-"the name that best identifies our database . We enter and we have kept our book. This will be our first DATABASE, we'll give it high all the materials
require a work 
For clarity, it is desirable to bring together the materials for "families", assigning a name to each matrerial, which can be numerals "0025" alphanumeric "M-001), or alphabetical "arena", "cementogris", etc. Personally, I recommend the simple alphanumeric system "M-0001", where the letter "M" names of materials and the number identifies the product. I have used several systems and the simplest is this. When assigning numbers, let broad ranges between each family, as is normal that we should use new materials and can be grouped into the family concerned.
Let's start to register our products: We have the column "A" to set the key or product name, the column "B" for the description, Column "C" for the unit we will use the product: M2, M3, Ton, Kg, etc., in Column "D" is for the purchase price. Here it is worth to take a break, because the cost can be very useful, at some point, including VAT, in another budget maybe we should break it down. In order to do a quick and safe removal of tax on our cost, or we can change the value of same as the area of \u200b\u200bthe country in which we will build, take a box outside the lines in our database. Consider that the sheet will, as the heading, our personal or company data, perhaps a logo, so that the first five or six lines are out of the data, therefore, we take the boxes "F5" or " G5 "for our breakdown of VAT.
Let's start to register our products: We have the column "A" to set the key or product name, the column "B" for the description, Column "C" for the unit we will use the product: M2, M3, Ton, Kg, etc., in Column "D" is for the purchase price. Here it is worth to take a break, because the cost can be very useful, at some point, including VAT, in another budget maybe we should break it down. In order to do a quick and safe removal of tax on our cost, or we can change the value of same as the area of \u200b\u200bthe country in which we will build, take a box outside the lines in our database. Consider that the sheet will, as the heading, our personal or company data, perhaps a logo, so that the first five or six lines are out of the data, therefore, we take the boxes "F5" or " G5 "for our breakdown of VAT.
Let's see in the "F5" will the legend "VAT value" and "G5", the value of such tax 1.15 or 1.10, depending on the region in which estimation. Now, let to our database and let us register a product, in this case, Cement Grey: Key M-0080; Description: Cement Grey; Unit: Ton, Cost: $ 1,722.60 * $ G $ 5, if in Box G5 we have 1.10 for the Value Added Tax, our result is $ 1,894.86, but do require the price without VAT, G5 will value of "1" and our prices listed as $ 1,722.60, in this way, with one change, modify entire catalog Prices . Similarly, if we only ask Manpower in'll G5 "0" and all materials appear worthless. It is desirable to be shaping our database, as explained above, leave a wide margin between "Families of materials," because quite often we will be specified to include new products to our database, although we have increased the use of numerals or literal, P. eg. In the event that we had no space between M-0079 and M-0089 and we asked an analysis with a special cement, maybe we could call MX-0080, or M-0080X, finally, the possibilities are many, the important thing is to be logical to find them easily. We must always take care of our database, simple and clear. PROBABLE
Group for "FAMILIA" MATERIAL
a) Aggregate stone. Arena gravel, stone, tepetate, volcanic rock, etc..
b) cement powder. cement gray cement, white, calhidra, plaster, etc.
c) Materials for walls. partitions, brick, block, concrete block, blocks, etc.
d) steel and armor. rods, wire, wire, armor, mesh, nails, etc.
e) Concrete and cellular accessories. panels, partitions, cements, mortars, tools, etc.
f) Timber. Plywood, cimbraplay, poles, bars, staves, etc.
g) Sheetrock, Durock and accessories. Table plaster, cement board, tape patching, pastas wood putty, metal profiles, accessories, etc.
h) Pasta decorative. quartz pastes, pastas acrylic, cement pastes, etc.
i) Floors and trimmings. mosaic, terrazzo, marble, glazed floors, tile, vinyl tile, etc.
j) Carpentry. doors, casing, hinges, plates, etc.
k) fixture. water tanks, heaters, toilets, sinks, laundries, etc.
The list will grow as much as the needs of your work, you can claim facilities families Galvanized Iron, Copper, PVC, carbon steel, cast iron, etc., Separating the lines of Water, Sanitary, Gas, Industrial, etc. The list seems endless and will be as large as required, so you should plan to calm the naming system to be used.
An important point, the spreadsheet has a lot of rows, but if you want a preview, you show up to line 54, but if you want displayed on each page display your logo, you must do the following:
Move the cursor to the main menu "File" and select "Page Setup"
b) cement powder. cement gray cement, white, calhidra, plaster, etc.
c) Materials for walls. partitions, brick, block, concrete block, blocks, etc.
d) steel and armor. rods, wire, wire, armor, mesh, nails, etc.
e) Concrete and cellular accessories. panels, partitions, cements, mortars, tools, etc.
f) Timber. Plywood, cimbraplay, poles, bars, staves, etc.
g) Sheetrock, Durock and accessories. Table plaster, cement board, tape patching, pastas wood putty, metal profiles, accessories, etc.
h) Pasta decorative. quartz pastes, pastas acrylic, cement pastes, etc.
i) Floors and trimmings. mosaic, terrazzo, marble, glazed floors, tile, vinyl tile, etc.
j) Carpentry. doors, casing, hinges, plates, etc.
k) fixture. water tanks, heaters, toilets, sinks, laundries, etc.
The list will grow as much as the needs of your work, you can claim facilities families Galvanized Iron, Copper, PVC, carbon steel, cast iron, etc., Separating the lines of Water, Sanitary, Gas, Industrial, etc. The list seems endless and will be as large as required, so you should plan to calm the naming system to be used.
An important point, the spreadsheet has a lot of rows, but if you want a preview, you show up to line 54, but if you want displayed on each page display your logo, you must do the following:
Move the cursor to the main menu "File" and select "Page Setup"
By choosing the option "Configure .." will open a dialog window where you will choose the tab for "road" place the cursor and click in the window called "Rows to repeat at top" and select the items to where they are key, concept, etc. Go then to the bottom of the box and click "OK" and ready, and you can view all pages of this sheet with your headers done, so, if you must print, each page will come with its own header.
We already have our database list of materials, remember that will grow as you will require analysis of different materials prices. It is important to remember that when we use the database, it falls between "rank" that is, if the range is between A8 and E560 ", which is outside this range can not take you where you need it, this observation is because as you are to gain items, the range will be expanded, but you'll have to take into account to make the necessary changes, perhaps at this point not to assimilate, but Remind because the deal later.
Let us go to the next chapter, the Database of Labor.
0 comments:
Post a Comment