How to keep stockrecord of reinforcements in excel? My dought is that after deducting the cutting length how to understand how much stock is left with
How to keep stockrecord of reinforcements in excel?
- Thread starter Karthiknair1195
- Start date
Dnyan Deshmukh
Staff member
Calculation of cutting length and number of bars required for cutting those bars and shape are two different things.
Cutting length gives you the length and number of bars required for particular shape.
If cutting of the bars done without considering for remaining pieces of bars which will be left utilised then the wastage will be increased.
The fitter or engineer first need to arrange the shapes of bars to ensure when the full length bar is cut to required cut length, the remaining piece or wastage should be minimum and that too is unitised in places like layer pins, chairs etc.
Normally a full length rebar comes in length of 12 meters + / - 150 mm (this is not fixed but approximate indicative, i had seen rebar so far with length of 12.05 to 12.15 meter).
Now you will get idea on to construct all shapes of bars, how much full bars you required. You can further devide it into for Columns & Walls and for Slab & Beams.
Once you know the Quantity of bars required, you can easily keep the stock and issue the required rebar quantity.
Not to scale example
say for the column and walls, you required 8mm - 100 bars, 12 mm - 50 bars, 25mm - 30 bars, 16 mm - 300 bars etc.
Now the working of slab is going on and in few days, it will be casted and further work need to be done above it once the concrete is done.
Its time to issue the required number of bars for column and wall works, so that they can cut and bend it before concreting of slab.
Now when you have unused bars in your stock yard - its your steel stock either in number of bars or converted to MT.
When you issue number of bars for work, you make its entry for that day and you will get quantity of consumption and closing stock.
The bar bending work is done on number of bars because we too fix steel in position base on numbers required in structure and not as per the weight in MT or Kg.
Steel comes at site in form of Weight in MT or Kg as the rate or mode of payment is per Kg or MT.
As its a manufactured product, the actual weight is not same as that of theoretical and there will be deviation which should be within the specified limits of IS 1786
When the steel is underweight, there are very less issues related to getting reconciliation, but if you got insane supplier and steel is accepted without QC check at site and is overweight, you will find more difficulties for doing reconciliation because you may find scrap is not available at site of required weight and some amount of steel is missing from site.
So stock is recorded as MT (some also keeps record as number of bars for each dia above 16 mm)
Steel is issued floor wise and component wise to keep track of issued, consumed and balance (in short reconciliation).
You can not make calculations of balance stock by comparing it with cutting length of steel bar unless the wastage factors are calculated as per the current design by practically cutting and bending bars for one floor and recording of every scrap and shape detail.
Cutting length gives you the length and number of bars required for particular shape.
If cutting of the bars done without considering for remaining pieces of bars which will be left utilised then the wastage will be increased.
The fitter or engineer first need to arrange the shapes of bars to ensure when the full length bar is cut to required cut length, the remaining piece or wastage should be minimum and that too is unitised in places like layer pins, chairs etc.
Normally a full length rebar comes in length of 12 meters + / - 150 mm (this is not fixed but approximate indicative, i had seen rebar so far with length of 12.05 to 12.15 meter).
Now you will get idea on to construct all shapes of bars, how much full bars you required. You can further devide it into for Columns & Walls and for Slab & Beams.
Once you know the Quantity of bars required, you can easily keep the stock and issue the required rebar quantity.
Not to scale example
say for the column and walls, you required 8mm - 100 bars, 12 mm - 50 bars, 25mm - 30 bars, 16 mm - 300 bars etc.
Now the working of slab is going on and in few days, it will be casted and further work need to be done above it once the concrete is done.
Its time to issue the required number of bars for column and wall works, so that they can cut and bend it before concreting of slab.
Now when you have unused bars in your stock yard - its your steel stock either in number of bars or converted to MT.
When you issue number of bars for work, you make its entry for that day and you will get quantity of consumption and closing stock.
The bar bending work is done on number of bars because we too fix steel in position base on numbers required in structure and not as per the weight in MT or Kg.
Steel comes at site in form of Weight in MT or Kg as the rate or mode of payment is per Kg or MT.
As its a manufactured product, the actual weight is not same as that of theoretical and there will be deviation which should be within the specified limits of IS 1786
When the steel is underweight, there are very less issues related to getting reconciliation, but if you got insane supplier and steel is accepted without QC check at site and is overweight, you will find more difficulties for doing reconciliation because you may find scrap is not available at site of required weight and some amount of steel is missing from site.
So stock is recorded as MT (some also keeps record as number of bars for each dia above 16 mm)
Steel is issued floor wise and component wise to keep track of issued, consumed and balance (in short reconciliation).
You can not make calculations of balance stock by comparing it with cutting length of steel bar unless the wastage factors are calculated as per the current design by practically cutting and bending bars for one floor and recording of every scrap and shape detail.
Similar threads
