【School】 Excel2000 weak in project cost management application method (a).

<br> <BR> one, with the preparation of the fixed unit valuation table Excel2000 <BR> <BR> fixed unit valuation table is mainly text, figures and tables. .Especially in the form of digital composition and calculation of relationship between tables is more complex. .Using FoxPro database software, or other large database software program calculated the valuation table, the table on the calculated valuation and a printed draft layout (print format and requirements of the anti-word paper with sulfuric acid), often with the aid of other publishing software .. .The use of spreadsheet software Excel2000 programming terms, it can deal with the valuation table Fixed text editing, data calculations, tables for layout and print output and so on, so that we see on the computer after the printing format is the format received .WYSIWYG. .Other methods of eliminating the first database file and then convert the layout format for the trouble caused by the layout and error. .Ensure that the work efficiency and accuracy of the data consistent. .<BR> <BR> Excel2000 in the spreadsheet prepared by "fixed valuation table" function can be calculated on any data, you can move the whole scale subheadings, you can insert or delete any item, any material or machinery, you can increase or decrease .Note the content and form of work. .Using tables for layout Excel2000 powerful editing functions can be arbitrary layout of project needs. .Excel2000 programmed with, simply adjust the labor, materials, machinery budget price, it can quickly generate "fixed unit valuation table." .I have successfully compiled using Excel a "unified national construction Jixietaiban fixed costs" (99 years, the budget price in Jiangsu Province) and the "unified national budget for public works fixed valuation table in Jiangsu Province" (2001), by the Jiangsu Provincial Construction .Office of the promulgation, implementation in the province. .<BR> <BR> Second, to achieve with Excel2000 BOQ <BR> <BR> 1, BOQ methods currently envisaged <BR> <BR> the Ministry of Construction has issued a uniform pattern of BOQ. .Some City, Jiangsu Province, also in the pilot in this area, there are calls for the abolition of scale. .I think the scale should not be completely abolished, the United Kingdom is similar to the fixed direct costs in China by the Royal Institution of Chartered Surveyors and the Building Owners Association of the United Kingdom "compiled by the amount of the standard construction method," Japan also has work quota. .We should refer to the principles of international general offer of the existing pricing model for reform. .WTO rules should be combined to reduce the project cost the government administrative intervention. .Foreign project cost management should learn the essence of science to establish a set of China's national conditions and with the international standards of general quotations BOQ method. .Specific methods are as follows: <BR> <BR> first step: an integrated unit method. .<BR> <BR> Quantities present method is used in the pilot integrated unit method. .Establishment of a "list of quantities", so that the "fixed unit valuation table" in the labor costs, material costs, machine costs a "list of quantities" part of the one relationship established under the subheading number. .The percentage of labor costs by project estimated to develop social enterprise employees health insurance and pension insurance accounting standards. .Provided by the "list of quantities," the project to calculate the direct costs, employee social medical insurance, endowment insurance and quota management fees for project cost, not allowed to compete in the bidding prices down. .This will ensure the quality of the project played a role in lower prices to avoid the corporate standard pressure caused by the blind "rubbish" project. .Also enable the project cost of approved operational. .General indirect costs of engineering the content contained in the form determined by the file, but opening overhead rates and comprehensive project plan profitability. .By the enterprises according to their level of construction technology, business management, operations and market supply and demand freely determine the works and plans for comprehensive indirect costs profit. .Reform of the provincial unit labor costs provides a unified approach to cities noted in the local labor market conditions unit labor cost estimates released. .To achieve labor, materials prices, project costs and plans Comprehensive Indirect market profits. .<BR> <BR> Second step: the introduction of BOQ law. .<BR> <BR> When the construction market in China has fully matured, no longer appears that some state-owned enterprises operating company CEOs were forced to lower the cost of purchase. .When the construction project quality standards system has been fully established, the project cost and bidding terms of supporting laws and regulations have been introduced. .When the cost of information network has been operating successfully has completed construction cost data, engineering data in the price and timely access to the Internet can be. .Can be implemented at this time BOQ law. .The United Kingdom's experience in the form of quantities of construction on the proposed project in terms of quantity and quality to be comprehensive and accurate description of the measurement of construction works to install in place of net quantities shall prevail. .Physical consumption of engineering and engineering construction measures consumption of phase separation, only the column on the quantities calculated from the engineering drawings of the number of entities, construction measures consumption by the enterprise itself noted in construction technology and construction management to determine. .This does not appear in the quantities that we appear in pilot enterprises for the same amount of engineering calculations of the project is inconsistent, resulting in the number of both parties on the project passing phenomenon. .Because our project includes the construction division plan the amount of works, and construction measures as different enterprises, construction design is not the same, resulting in a number of construction measures of different quantities. .<BR> <BR> <BR> <BR>.