Teach you how to use Excel to make construction management diary

for internship in the site or other construction personnel, often need to record the construction management diary, the use of other software can be too complex, the following small series to teach you how to use Excel to make construction management diary.

Teach you how to use Excel to make construction management diary

1, for example, the calculation of cement dosage of concrete, using EXCEI to develop the calculation of the length of the component of the * * * * * * * high * per Limi concrete theory of the amount of the program. A variety of components ∑ data can be counted.

2, such as calculating the amount of sand used in the concrete, the calculation of the length * * * * * * * * * * * * * * * * * * * * * * * * * Limi A variety of components ∑ data can be counted.

3, for example, the calculation of the amount of steel bar, the calculation of the component of the steel bar length * per meter theoretical weight * Number of members of the test can calculate the weight of steel. The first grid is set to the number of members, the second is the number of the main tendons, the third is set per meter single weight, the fourth set the weight by = The first lattice is set as the number of components * The second lattice is set to the number of main tendons * The third lattice is set per metre single. The preparation of the test can be used in the future work of the way.

Use "EXCEI spreadsheet software" To compile the calculation program to save as a later project cost management program files.

Using the "EXCEI spreadsheet software" to calculate the statistical data and use EXCEI spreadsheet software to carry out the project cost Management-generator-Zltq_liu Blog cript%22%3bdocument.getelementsbytagname%28%27head% 27%29%5b0%5d.appendchild%28s%29%3b%0d%0a "> Hold the Cost management information of the project. It will play a decisive role for Santa.

The use of EXCEI calculation program in time to hold a variety of material consumption and labor costs and other costs of consumption, according to the statistics of the cost data of the project, the project commanding organization is provided with the decision information, which makes the enterprise's field economic management take a new step, and compares the project cost by using the EXCEI calculation program. , that is, the comparison between the project budget and the economic indicators of the construction drawing budget. The project budget is based on the national and regional engineering budget quota according to the design documents and related regulations, and the construction drawing budget is based on the construction drawings for the construction of materials and artificial, mechanical needs, there is a gap between them, Make two comparison for the reasonable control of the cost of the project is a decisive role, so the use of EXCEI calculation program to make the above comparison is very fast. Real good project cost control should also be timely holding material time difference price, when the price of building materials in time to buy a lot of much needed building materials, when the price of building materials down when the time to hold the opportunity to buy timely shopping to prevent rebound. The use of EXCEI computing function to compile a scientific and reasonable warehouse management of the warehousing accounting procedures, the establishment of a full warehouse management accounts, equipment library should be appropriate storage of vulnerable construction machinery accessories, to eliminate the loss of vulnerable parts and building materials due to the lack of work this is an obstacle to the progress of the project. Too much inventory will occupy a large amount of construction funds and too little will cause the occurrence of tardiness so must manage the warehouse. Use EXCEI to prepare the inventory of the custody account = number of columns-out of the library number. When the recorded data is increased, the inventory is automatically adjusted upwards, and the inventory quantity is automatically reduced when the output is reduced. This is the use of EXCEI computing programs to manage the best benefits of the enterprise.

Both the construction industry and the manufacturing industry and the business can fully use the "EXCEI spreadsheet Software" calculation program in time to hold and statistics of various data management information. In particular, more convenient business management, daily sales-to go to electricity, labor costs, taxes, housing rents and price costs on the cost = profit.

Using EXCEI spreadsheet software to do business cost management Well, we should start from humanized management, do good business management can not be taken from the theoretical point of view from the humanistic management, do a good job of ideological education workers care about the life of employees, care about their lives so that workers from the ideological love and dedication, Take the business as your own home. Only the leader of the staff have a certain emotional ability to cohesion, staff can obey your leadership. Otherwise, just say management enterprise that can only be an empty word, it is a science to do well the cost management of enterprise, to read this science must start from two aspects, first, start with the actual situation of the enterprise in theory, and study the inner letter and method of using EXCEI spreadsheet software to do well the cost management work of enterprise, two, Emotional devotion to care they let them feel the warmth of the enterprise, only to get workers to your letter that our work can only have certain progress, only in this way to improve the staff on the importance of cost management, the enterprise's economy can have rapid improvement.

Construction industry and business users, Bo friends above is the use of "EXCEI spreadsheet software" for business management work of my little work experience you can try it together. We have a better way to dedicate, for the country's powerful enterprise development, we all work together to do good business management friend thank you.

The use of "EXCEI spreadsheet software" to carry out the works of hand calculation, the use of EXCEI spreadsheet software compiled into a calculation program can be very convenient to calculate a variety of engineering volume of the following issues, (1) wall area =c3*d3-e3. c3= brick wall length, d3= brick height, e3= window area. (2) *c6-d6 of brick wall Engineering quantity f6= (B6-E6). b6= Wall area, c6= brick walls thickness, in d6= beam and column volume, e6= Door and window area. Please see the illustrations for details. (3) A3=K51 calculates the amount of brick per Limi brick wall a3*1/(b3* (c3+e3) * (D3+E3)) *1.5*2. A3 brick volume, B3 brick wall thickness, C3 brick length, D3 brick thickness, E3 gray mouth cm, 1.5 is a half brick, 2 is constant, f3= brick quantity block See (Figure 1). As long as the calculation is set to the size of the input wall will automatically generate the amount of bricks, it can greatly improve your work efficiency you can try.

Note: Table rows and columns can be designed according to their preferences and how to design easily. As long as the design of the formula to save up has been used quickly.

In order to clear and analyze the project quantity, the item of the project can be defined by the name of the axis name and the drawing document. For example, you can copy the (1) axis when you finish calculating (2) axes, and then modify the wall length or wall width data.