Adding limited costs to OS and SSR in the "Grand Estimate" PC. An example of preparing estimates in the Grand Estimate program Examples of performing calculations in the Grand Estimate program
The resource estimate is often one of the sections of the final estimate; sometimes it may be advisable to separate it into a separate document. In addition, the Government Decree officially approved the calculation method for drawing up estimate documentation as one of the main ones for the formation of such reporting statements. Doing this manually is very difficult and time-consuming, but with the help of the Grand Estimate, you can cope with the task quickly without any difficulties, and you need to know several important nuances and features.
Features of the statement
A resource estimate is a type of calculation that is formed directly based on current prices for any types of resources that will be used during construction. The advantage of the resource statement is the complete transparency of the calculations given. The customer and contractor can rest assured that they will not lose money due to any errors or intentional omissions.
Instructions
Initially, to create this file in the Grand Estimate, you must select a local estimate, which will be taken as a basis, and then use it to set the parameter “Calculation method” - “Resource”.
If initially you need to immediately create a resource estimate, then you will need to create it in the following sequence:
In the future, you can mark all the estimates of interest compiled earlier and set for them the formation of a final estimate for resources. Disputes often arise that the resource estimate currently completely replaces the local one. In fact, this is not entirely true - ideally, draw up both versions of the estimate document in order to protect yourself from unnecessary mistakes and provide the customer with a full calculation. In fact, the local estimate is the basis of the resource estimate. 
Resource method
The essence of the resource method of budgeting is to simultaneously take into account:
Material costs
Labor costs,
Energy costs,
Rental and operation of machinery and equipment.
Calculation is carried out in current prices, and not predicted or current at the time of conclusion of the contract. The initial data here will be: market prices for materials, payment for such work, as well as the expected parameters of the structure.
An estimate can be drawn up according to this principle for any period of time (it is often customary to prepare intermediate estimates for a month), as well as directly for the entire construction project.
When drawing up resource estimates, sometimes you have to use additional preparation secrets. In fact, there is nothing complicated here, but the most important thing is not to forget to take into account these features:
Some materials may be originally supplied by the customer. Then these columns must be marked accordingly so that the cost of these materials is deducted from the total amount;
The reducing factor should be taken into account, since the cost of purchasing materials or the residual value of those in stock can be reduced;
In the final calculations, balances may be indicated (if materials were initially purchased in larger quantities than were then consumed).
Thanks to Grand Estimate, this can be done very quickly and easily - just select the table cells of interest, designating them in the parameters as those that belong to a specific category. The program will perform all other calculations automatically, saving the resulting document in the folder for the object of interest.
Recommended for use as a teaching aid when mastering the course “Practical skills in working with the GRAND-Smeta software package.” Designed for users of all categories with any level of computer knowledge. The presentation is based on the most frequently asked questions and answers to them, based on specific examples. Following all the step-by-step instructions and work techniques described in the manual will quickly teach you how to create your own estimates and prepare them for printing.
CONTENT
1. Working with local estimates
1.1. Entering and adding prices to estimates
1.1.1. How to add a price from the regulatory framework to the estimate?
1.1.2. How to enter into the estimate a price that is not included in the regulatory framework?
1.2. Replacing materials in estimate items
1.2.1. How to replace materials in a position?
1.3. Automation of calculation of work volumes in estimates
1.3.1. How to automate the calculation of the volume of work in the estimate?
1.3.2. How to use identifiers in estimates?
1.4. Working with work types, HP and SP
1.4.1. How to change the value of the overhead rate and estimated profit?
1.4.2. How to set one overhead cost value for all prices in the estimate?
1.4.3. How can I set a general adjustment factor of 0.94 to overhead costs only when calculating estimates at the current price level?
1.4.4. How to set an adjustment factor of 0.9 to overhead costs for prices only from general construction collections?
1.4.5. How to include another directory of types of work in the estimate?
1.4.6. How can I see how the price is linked to the type of work?
1.4.7. How to link or adjust the type of work to the price?
1.4.8. How to turn off the division into types of work in the estimate results?
1.5. Working with coefficients in totals
1.5.1. How to add an allowance for tightness to the estimate
1.6. Working with Indexes
1.6.1. How to set indexes for automatic calculation by sections of the estimate?
1.6.2. How to set indexes for automatic calculation by type of robot in the estimate?
1.6.3. How to add indices to construction and installation work in the results of sections of the local estimate?
1.6.4. How to set a single index for the entire estimate so that it is calculated before accruing limited costs?
1.6.5. How to set indexes in the estimate that should be used “by default”?
1.6.6. How can I automatically change index values in a compiled estimate?
1.7. Resource calculation method
1.7.1. How to enter or adjust current prices using the resource calculation method?
1.7.2. How can I save current prices entered in one estimate for use in another?
1.7.3. How to calculate all tariff rates in the estimate based on the cost of a man-hour for a 4th category construction worker?
1.7.4. How can I simultaneously view the estimate at base prices and the estimate compiled by the resource method at the current price level?
1.8. Entering and adding limited costs, taxes and mandatory payments
1.8.1. How to calculate limited costs in sections of a local estimate?
1.8.2. How to calculate the amount of VAT in an estimate when using a simplified taxation scheme?
1.9. Accrual of winter price increases
1.9.1. How can you calculate winter price increases in the GRAND Estimate, including different values for different sections in the estimate?
1.10. Summarizing
1.10.1. How to recalculate a finished estimate from one territorial zone to another if there are several territorial zones in the TEP database?
1.10.2. How to convert a ready-made estimate made on the basis of GESN into territorial norms and prices?
1.10.3. How can I set the default level of detail for totals?
1.11. Selecting positions, copying, pasting
1.11.1. How to highlight budget items if they are not in order?
2. Formation of output documents
2.1. How to implement the output of resources under each price in the output form?
2.2. How to display information about replaced resources in the output form?
2.3. How can I output information only about the formula for the unit cost in the output form?
2.4. How can I show in the output form the indexes used when displaying budget items?
2.5. How can I show overhead costs and estimated profit in the output form when outputting budget items?
2.6. How can I not display items in the output form that are not taken into account when calculating the estimate?
2.7. How to create several forms at once?
2.8. How can I make changes to the document template, for example, change the year from 2005 to 2006?
3. Working with summary/object estimates
3.1. How to add local and/or object estimates to the summary estimate?
3.2. What cost from the local estimate will be included in the object/summary estimate?
3.3. How to specify the number of the chapter of the consolidated estimate calculation in which the cost from the object/local estimate should be entered?
3.4. How to automatically take into account changes in local/object estimates in the summary estimate?
3.5. How do I add limited costs to chapters 8-12 of the summary estimate?
The program implements the following functions:
- In order to optimally implement the provisions of the Federal Law of 04/05/2013 N 44-FZ "On the contract system in the field of procurement of goods, works, services to meet state and municipal needs", a new method of resource calculation of estimates using current prices (resource ranking method) has been developed;
- PC "GRAND-Smeta" version 7 includes collections of consolidated prices of NCS and NTsKR, approved by orders of the Ministry of Construction No. 167/pr dated 04/07/2014 and No. 506/pr dated 08/28/2014;
- In accordance with MDS 81-15.2000, version 7 of the GRAND-Estimates software implements a methodology for drawing up estimates for design and survey work using full-format design and survey collections;
- The calculation of physical volumes in the estimate is automated using data previously entered into the local estimate;
- The ability to directly access cloud and other data repositories from the program to compile and check estimate documentation and confirm the scope of work completed in accordance with the KS-2 form has been implemented;
- Added the ability to draw up commercial estimates using the real costs of construction work, materials, mechanisms;
- And much more
When using the Subtract and Add commands for a resource as a line item, an identifier is automatically generated
This allows you to automatically take into account changes in the volume of an added/removed resource when the price volume changes.
When dragging cells with physical volumes, identifiers are automatically generated for positions and resources
When dragging with the right mouse button pressed, you can select “Insert link...” from the menu. In this case, an identifier will be automatically generated for the position that we are dragging, and then it will be entered at the position that was dragged TO.
When entering formulas in PC Grand Estimate 7.0You can use the mouse pointer to refer to other cells
If, when working with variables in an estimate, or when writing formulas in physical volumes (costs), you need to refer to any other cell (physical volume of another position, or a line of variables), then just press the Ctrl key and then click the mouse cursor on the desired line. The program will automatically substitute the identifier that is written for this line. If the row does not have an identifier, it will be generated automatically. The same goes for resources. Now you don't have to worry about the presence of identifiers if you need to use previously calculated values in subsequent calculations.
Added the ability to copy a cell value rather than a formula
If you need to copy the result that was calculated using a formula to the buffer, you must use the corresponding command from the context menu, or using the shortcut keys Ctrl+Alt+C.
This functionality is available for absolutely all cells in any tabs/bookmarks in all documents, including in the OS/SSR.
Added the ability to expand formulas before their numerical representation
When expanding a formula, the curly brackets are removed from the comments.
When dragging a line with a variable from the estimate parameters onto a position, the latter contains the identifier of what we are dragging
Now you don't have to manually enter identifiers. The connection will be generated automatically.
IN in PC Grand Estimate 7.0 d added the ability to upload several acts into one estimate
If you select several acts in the estimate parameters, then when you click the “Estimate based on acts” button on the toolbar, all selected acts will be uploaded to a new estimate.
In this case, a formula will be generated as a physical volume for the position, consisting of the physical volumes of the copied acts.
When adding an item from the database to the estimate, you can disable the return to the collection
After executing the Add or Insert command, the estimate will remain on the screen, to which items from the regulatory framework have been added. Having entered the physical volume, entering the necessary coefficients and indices, you can continue entering prices. This feature is enabled as an option through the program settings.
Improved histograms when working with execution
Now, when working in act mode, you can always see the overall progress by position, as well as the ratio of the volume in a given act to the volume according to the estimate in terms of time.
In PC Grand Estimate 7.0 Added the ability to multi-edit values for selected rows
You can enter a single price formula for all selected positions, for example, for materials: TC/Index. In this case, the formula will calculate the quotient of dividing the current price by the Index variable. Combined with the ability to expand formulas, the result is a full-fledged numerical formula when printed.
In combination with the ability to highlight prices with the same code in the estimate, you can change the code of one job to another throughout the estimate:
IN in PC Grand Estimate 7.0 d added the ability to enter limited costs as a coefficient
Added the ability to change the color of the selected line
Bringing the selection color to a common denominator - previously the selection color could be yellow (current line) and bluish (selected lines) - we decided to give the user the opportunity to change the color.
Added the ability to autoload prices when creating estimates
If you enable this option, then when adding prices from the regulatory framework to the estimate, for example, current prices will be automatically loaded. This way we will always see the current cost according to the estimate, without resorting to downloading prices every time.
The technical part of the collection can be opened using a command from the context menu
When working with a list of collections, the “Technical” command has been added to the context menu. part”, which opens the technical part of the collection. This is more convenient than using the button on the “Document” tab.
In PC Grand Estimate 7.0 Added the ability to take into account the cost of materials from the resource calculation method when calculating local estimates using indices
For example, when calculating a local estimate, you can calculate the cost of payroll and machine operation using indices, and take the cost of materials from the resource method using built-in identifiers.
In the local estimate, for the built-in identifiers used with the list of limited costs, calculation method qualifiers have been added: BC - calculation in base prices without taking into account indices, BIM - calculation by the base-index method in accordance with the indices settings in the estimate, TC - calculation by the resource method. Example of use: TC.MAT – will return the cost of materials for the resource method. BC.NR – will return the amount of overhead costs for calculation in basic prices. Just in case, let's list all the available built-in identifiers:
| Variable name |
The value that will be returned for the variable |
|
TOTAL |
Amount before calculating limited costs |
|
WITH or SR |
Amount of construction work |
|
M or MR |
Amount of installation work |
|
Amount of construction and installation work |
|
|
ABOUT or ABOUT |
Amount of equipment |
|
P or ETC |
Amount of other work |
|
Payroll fund |
|
|
Amount in the column “Wages of workers” |
|
|
Amount in the column “Operation of machines” |
|
|
Amount in the column “including wages for drivers” |
|
|
Amount in the column “Materials” |
|
|
Amount in the column “Labour costs” |
|
|
Amount in the column “Labor costs of drivers” |
|
|
The amount of overhead costs calculated in the “standard” way |
|
|
The amount of estimated profit calculated in the “standard” way |
|
|
NRZPM |
The amount of overhead costs calculated from the ZPM (used only when calculating according to the TSN method) |
|
SPZPM |
The amount of estimated profit calculated from the ZPM (used only when calculating according to the TSN method) |
|
NRALL |
Amount of NR + NRZPM |
|
SPVTOME |
Amount of SP + SPZPM |
|
The amount of winter price increases calculated according to the table of standards (LZ tab – Winter) |
|
|
RETURN |
Amount of returned materials |
|
MATZAK |
Amount of customer materials |
When dragging multiple positions, it is clearly visible that a group is being dragged
Added the ability to update the memory value in accordance with the reference book
If edits have been made to the memory list, or the temperature zone has been changed, you can restore the reference values by right-clicking and selecting the “Update values from reference” command.
Added the ability to erase TSC, FSSC, etc. codes when adding materials from collections of the regulatory framework.
If it is required that when adding materials from the regulatory framework or from the price tag, the collection code is “cut off”, then you need to enable the corresponding option in the program settings.
When the setting is enabled, the collection code is “cut off” when added from the regulatory framework:
Similarly when adding current prices from catalogs:
When pasting data from the buffer, the ability to save links to the source has been added
Inserting values with links to the source is done on the “Links” tab in the “Variables” node. In order to insert a link, you need to copy the desired cell in Excel. Next, on the “Links” tab, click on the “Paste from Clipboard” button. Further use of these variables is similar to the general principles of working with variables. They can be dragged into positions with the mouse, they can participate in any calculations, etc.
If changes have occurred in the source file, then when you click on the “Update connections” button, the data will be read again from the source file:
Setting folder paths from ProgramData
Added the ability to change the paths for storing license files (Lic folder), reference books (LocalSetting folder) and calculation templates (SmetaProps folder).
When dragging prices from the regulatory framework, the justification and name are “glued together” in the tooltip
In PC Grand Estimate 7.0 when dragging positions in the local estimate in the context menu, along with the name, the rationale for the position is also displayed
When copying a price from the database to the buffer in the insert menu, the text is formed from its rationale and name
When selecting by pattern, the ability to select positions with a completely matching code has been added
Two new sections “Transportation” and “Loading and unloading operations” have been added to the list of resources according to the estimate.
In order for the budget items to be fell into the corresponding sections of the resource list, the type of work for this position must have a corresponding attribute.
In the results of the resource statement, accordingly, the amounts for these two new groups are also displayed:
For “old” estimates, you can change this attribute manually. New estimates will require updating the work type directories, because this sign is specified exactly there.
The attribute for assignment to a particular section of the resource list is displayed in the last column of the directory. Prv- this is transportation, Pgr- This is loading and unloading work.
Added the ability to enter your own comments to the estimate item
In the window with additional information about the position, two such comments are provided.
Ability to expand all sections in the estimate
Added the ability to enter resources in monetary form in the quote to calculate wages by position
Using this opportunity, in you can enter calculations and calculate wages not through labor costs, but through the natural meter of the price itself.
When adding prices from the regulatory framework to the estimate, the regions in the database and in the estimate are checked, and if they do not match, a warning is issued
When switching between collections in the tree, the expanded state of the table of contents is maintained
Added the ability to update the contents of the “My Forms” folder without closing the program
Unification of dialogs for opening external files for loading various information
To the list of available files in information has been added from the latest documents, as well as collections of the regulatory framework. Price tags from the regulatory framework may be needed to download basic prices, to download information about groups, cargo classes and gross weight.
Added the ability to divide resources into arbitrary groups
As a source of grouping, you can use any price tag files, including price tags from the regulatory framework. To download groups, you need to select a source and click on the “Select all groups” button.
To enable the group selection mode, click on the corresponding button on the “Subgroups” panel:
When group highlighting is enabled, each group is summarized by total cost and gross weight:
Added the ability to group materials by cargo class, summing up the gross weight for each class
IN To enable grouping of materials by cargo classes, you must click the “Cargo Classes” button.
If information about cargo classes is available, information on the total gross weight for each class of materials will be automatically displayed in the summary line “Materials” in the list of resources.
It should be noted that in if not all materials with the same cargo class have information about gross weight, then the value with the total weight is displayed in red.
Added resource ranking method for faster budgeting at current prices
The resource ranking method allows you to select in the list of resources only materials that are significant in terms of price and indicate the price only for them. This method reduces the labor intensity of preparing estimates using the resource method by an order of magnitude, while the accuracy of the calculation remains at the same level. The resource ranking method is described in detail in a separate manual.
Collections for design work have been reworked
The appearance of the collections is brought into line with their printed original.
Relative cost coefficients are separated into a separate group:
Coefficients for design conditions have been revised.
Added the ability to prepare estimates for design and survey work using new collections for design work
Drawing up estimates for design and survey work is described in detail in a separate manual.
The appearance of the document matches its printed version as closely as possible.
An example of an estimate for engineering and geological surveys:
Form 2p output in Excel:
Added the ability to skip inactive items when renumbering estimates
When this option is enabled, all positions that are inactive will not participate in the numbering of positions. It must be remembered that with this numbering method, duplicate numbers may appear for positions, because Inactive positions also have their own number. To eliminate this situation, it is recommended to use the “Automatic renumbering” option. In this case, active positions in the estimate are guaranteed to have no duplicate numbers.
A table of contents has been added for collections in the Favorites folder
For directories of types of work, the ability to group them has been added
If there is a Vid_rabs folder in the directory folder, then the work type directories saved in it will also be displayed when selected. At the same time, there may be subfolders in the Vid_rabs folder. In such cases, directories will be grouped by these folders when you select
For directories with types of work, a description of their contents has been added
The description is taken from the Comment tag of the Vidrab_catalog node.
A separate field “Justification” has been added to the coefficients in the estimate.
Added the ability to load information about cargo classes and gross weight for materials into the estimate
In the object estimate and summary estimate calculation, the ability to index with an unlimited number of indices has been added
In order to apply an index to any of the OS and SSR lines, it is enough to indicate the code of the desired index in this line in the “Index code” column. In this case, the index can be specified not only for the lines “Total by chapter...” and “Total by chapters...”, but also for the lines “Total taking into account...”.
A new TOTAL costs column has been added to the local estimate screen
This column displays the total value of the amount for the estimate item, taking into account NR, SP, coefficients and indices
The ability to calculate the unit cost indicator has been added to the local estimate
To calculate the indicator, you must specify the number of units, as well as their unit of measurement, in the estimate parameters. For example, if the estimate is drawn up for laying 150 m of pipes, then the quantity will be 150, and the unit of measurement will be “m”.
In the local estimate, the calculated value of the unit cost indicator can be seen in the summary window:
For positions in the local estimate, the ability to specify hyperlinks has been added, as well as links to any external sources with data
- You can provide a link to the source with the price (for example, the supplier’s website)
- You can provide a link to information describing the technology of work, for example, from Grand StroyInfo or from the manufacturer’s website
- You can save a link to a photo with a defect when drawing up estimates for repair work
- You can provide links to drawings, sheets in these drawings, compiled using the appropriate CAD systems, as well as accounting systems for this documentation.
During further work, you can quickly access saved links through the Data – Hyperlinks tab by selecting the desired link from the drop-down menu
The structure of the window with additional information about the position in the local estimate has been changed
The location of bookmarks has been changed: now their list is displayed on the left in the window with additional information about the position. At the same time, some of the information that has always been displayed at the top of this window (formula for calculating physical volume, physical volume value, multiplicity factor of the meter) has now been moved to the new “Physical Volume” tab.
When working with coefficients in the estimate position, the mode for adding coefficients from the technical part of the collection has changed. The corresponding button is now called “PM”, and when you click this button, the list of coefficients from the technical part opens not in a separate window, as was the case in previous versions of the program, but in the lower part of the window with additional information about the position. Adding a coefficient is done by dragging the mouse or clicking the “Add” button, while the list of coefficients from the technical part remains on the screen, and the added coefficient becomes inactive and goes to the end of the list. The “Close” button or pressing the “TC” button again allows you to disable the display of the list of coefficients from the technical part of the collection on the screen.
On the “Comments” tab, the ability to enter additional text explanations related to the estimate item has been added.
Added the ability to generate a summary resource sheet for the completed amount of work
When working with a summary resource sheet (which shows the need for resources for several local estimates, for an entire facility or an entire construction site), the ability to display data only for the completed amount of work in the sheet has been added. These data are generated on the basis of completed reports of work performed according to the original local estimates. Switching to the mode of displaying data on the completed amount of work is done by clicking the “Report by period” button, while the start and end dates of the period are indicated next to them with the possibility of adjusting them. When you press the “Report by period” button again, you return to the mode of working with complete data for the entire scope of work specified in the original estimates.
It is known that when forming the SSR, the main costs of construction can be added to one or another chapter of the calculation either manually or as a result of automatic compilation from available source documents - local or site estimates. For example, with a standard set of chapters, the first seven chapters are intended for basic costs. And in chapters, starting from the eighth, additional (limited) costs should be included - in this regard, let us remind you that when automatically compiled, the total cost of the source documents is taken without taking into account limited costs.
For major repairs or road construction, the set of chapters in the SSR form must be different, but in any case, the first of the chapters, which are intended for limited costs, always has the name Temporary buildings and structures.
Limited costs in the GRAND-Esmeta PC can be added to the object estimate (consolidated estimate calculation) or manually by pressing a button Position Document, or by copying from a special reference book. The directory is called OS/SSR costs and opens like any other directory using the button Directories on the toolbar tab Document. Copying limited costs from the directory to the desired chapter of the operating system (SSR) is done by dragging and dropping with the mouse.
Please note that for cost items, the directory indicates the mechanism for their calculation in the form of special formulas. Each cost included in the consolidated estimate is distributed according to the types of costs that correspond to the columns in the SSR form: Construction work, Installation work, Equipment, Other costs. Therefore, the formulas are written in columns separately for each type of cost. The calculated value is placed in the same column of the document where the corresponding formula is written.
Let's consider the rules for recording formulas so that, if necessary, you can change the mechanism for calculating cost items selected from the directory, or add new cost items manually.
In the vast majority of cases, the calculation is made by taking a percentage of the total for a separate chapter of the SSR, from the sum of the chapters, or from the value of any previously calculated cost item. To access one or another element of the summary estimate calculation, use identifiers– standard or specified by the user.
Standard identifiers initially correspond to the results for individual chapters of the SSR; they are displayed in the SSR form in the column Identifier. For example, G2 means the total cost for Chapter 2. From the total cost, you can select costs for individual types of costs by indicating additional identifiers through a dot: WITH- construction works, M– installation work, ABOUT- equipment, P– other costs. For example, G2.S means the cost of construction work for chapter 2. To calculate from the amount of chapters, the range should be indicated with a colon. For example, the expression G1.S:G8.S means the cost of construction work for chapters 1 to 8. And finally, the complete formula 2%G1.S:G8.S means taking 2% of the cost of construction work for chapters 1 to 8.
When calculating limited costs, for the convenience of writing formulas, you can use a special identifier SDL– that is, “price up to limited.” That is why in the directory OS/SSR costs for cost items from Chapter 8, the calculation formulas in the columns are immediately indicated in the form 1.2%SDL.S, 1.2%SDL.M and so on.
Sometimes when calculating it is necessary to use the value of a separate cost item (for example, exclude this value from the cost from which the calculation is made). In this case, it is necessary to specify the designation in the column for this position in the SSR form Identifier, and then use this identifier in formulas just like standard identifiers. For example, if you set for some position in Chapter 9 Other work and costs identifier A, then the formula 3%(G1:G9-A) will mean taking 3% of the amount of chapters 1 to 9 minus the cost item indicated by the identifier A.
Firstly, when drawing up estimates, there is such a cost item as the examination of project documentation. It is calculated by taking a percentage (usually 2%) of the amount of costs for design and survey work. The cost of design and survey work is entered in the corresponding chapter of the summary estimate (with a standard set of chapters - in chapter 12) in two lines with ready-made values in the column Other costs. These lines must be designated in the column Identifier– for example, accordingly PRO And FROM. Next, a position for calculating the cost of examination is added to the same chapter, and in the column Other costs for this position you should write the formula 2%(PRO+IZ).
Another interesting example is the calculation of the costs of maintaining the management of an enterprise under construction. If we are guided by the standard set of chapters of the consolidated estimate calculation, then the cost of maintaining the directorate is entered in Chapter 10, and the peculiarity of this example is that the calculation is made taking into account the costs not only of the previous chapters from 1 to 9, but also of Chapter 12.
Comment: When preparing calculations in the GRAND-Estimates software package, you should avoid the appearance of so-called circular links- this is when one cost item is calculated taking into account another cost item, the calculation of which, in turn, uses the total for the chapter where the first cost item is included. When cyclic references appear in formulas, they are highlighted in red, and instead of the calculated value, the word is displayed in the column Error.
If the preparation of a summary estimate is carried out in full accordance with the methodological instructions, then in the example with the costs of maintaining the directorate, the appearance of cyclical links is excluded - after all, the calculation of costs from Chapter 12 is made from the sum of Chapters 1 to 9 without the participation of Chapters 10 and 11.
Thus, if we assume that the standard for calculating the costs of maintaining the directorate is 1.1%, then it is necessary to add a new position to Chapter 10, indicate the necessary justification and name for it, and then enter it in the column Construction works the following formula: 1.1%(G1.S:G9.S+G12.S). Formulas for calculating the cost of installation work (and, if necessary, equipment and other costs) are entered in a similar way.
It often happens that the guidelines for any cost items say: it is recommended to carry out calculations based on the full estimated cost, and the calculated funds are included in columns 7 and 8 of the consolidated estimate. This means that there is no need to write formulas with additional identifiers in separate columns S, M, O And P. Instead, it is enough to write one general formula in the column Other costs. In the considered example of calculating the costs of maintaining the management of an enterprise under construction, the general formula would look like this: 1.1%(G1:G9+G12).
