Custom fields. Who to Give the Family Business to Creating Custom List-of-Value Fields

Knowledge a person in the mode of ignorance gives rise to attachment to one type of activity as the only important one, is very poor and does not reflect the truth. His activity is done in illusion, in disregard for the instructions of the Shastras, without concern for the slavery, violence or suffering caused to others. Executor: He is constantly engaged in activities contrary to the instructions of the sastras, materialistic, stubborn, deceitful and sophisticated in insulting others, lazy, gloomy and slow. Understanding: He takes unbelief for faith, and faith for unbelief, is under the cover of illusion and darkness, always directed in the wrong direction. His determination does not help to overcome sleep, fear, sadness, gloom and delusion. His happiness blind to self-realization, ghostly from beginning to end, and stems from drowsiness, laziness and illusion.

Verses 45-54.

1. How should a person regard his natural inclinations?

If one has not yet risen above the modes of material nature, one should perform duties according to one's natural propensity for the satisfaction of the Lord. Thus, by worshiping the all-pervading Lord, everyone can achieve perfection.

2. Why is it better to do your own own business than doing someone else's work?

The fulfillment of duties prescribed according to the nature of each one never provokes sinful reactions, therefore it is better to follow one's duty, even if it is imperfectly performed, than to perfectly perform someone else's.

The fulfillment of other people's duties leads to the following: 1) activity at one's own whim is encouraged (that is, sense gratification becomes the motive), which ultimately leads to chaos; 2) the foundations of society are undermined (if a person decides to change the type of his activity, then those who depend on his activity may suffer); 3) a person is engaged in something to which he has no natural inclination, this causes him dissatisfaction and threatens moral decay. (Fulfilling the duties of others is not as easy as it may seem, because the tendencies that condition us are rooted in us much deeper than we realize.)

Summarize the main points of verse 48 and its commentary.

Just as fire is always accompanied by smoke, so all activities are contaminated by the modes of material nature. Despite this, if any professional activity is carried out for the satisfaction of Krishna, all the defects inherent in this activity are eliminated. Therefore, a person should perform his prescribed duties, even if this activity is full of flaws.

4. Why does a person in Krsna consciousness automatically become a sannyasi?

True renunciation means that a person is constantly aware of himself as part and parcel of the Supreme Lord, and therefore considers that the results of his work should be enjoyed by the Supreme. This is Krsna consciousness. Thus one who acts in Krishna Consciousness is a bona fide sannyasi. he is not attached to anything material.

5. If devotional service begins after one attains Brahman consciousness (18.55), should we first become self-realized and then take to Krishna consciousness?

That is unnecessary. Devotional service is both an end and a means. In the pre-liberation stage, bhakti is the means of purification by which one gets rid of false ego and reaches the stage of brahma-bhuta. After liberation, bhakti is the natural quality of the soul in its eternal relationship with Krishna.

Therefore Krishna consciousness should be practiced even if we are not yet liberated.

Verses 55-63.

1. What does the words "bhaktya mam abhijanati" mean to scientists and empiricist philosophers?

The supreme divine personality is incomprehensible to the speculators and unbelievers. The truth about the Supreme Personality can be revealed only to a person engaged in pure devotional service.

2. Answer the following statement: "Because the devotee deals with the material energy, he must receive karmic reactions."

For a devotee who is fully Krishna conscious, everything is spiritual because he engages everything in the devotional service of the Lord. The energy of the Lord begins to act as material only when we try to enjoy it, and when a person uses the energy of the Lord according to its original purpose - in the service of the Lord, then this energy remains spiritual. Therefore a pure devotee is always free from the fruitive reactions of his activities.

3. How would you answer the question (referring to texts 18.59-60) "Why work hard for Krishna?"

A living being is forced to act actively. If one refuses to act according to Krishna's instructions, he will still be forced to act according to the material modes. But anyone who voluntarily devotes himself completely to the service of Krishna will overcome all the obstacles of conditional life and attain perfection.

Verses 64-78.

1. Summarize in your own words the most important instructions of the Bhagavad-gita given in verses 65 and 66.

The most confidential part of knowledge is that one should become a pure devotee of Krishna. always think of Him and act for Him. The Lord promises that anyone who is in Krishna consciousness will return to the abode of Krishna. It is recommended to fix your mind on the original form of Lord Krishna. The concentration of the mind on this form is the essence of the most secret part of knowledge.

Krishna advises Arjuna to simply surrender to Him, giving up all other forms of dharma. One might think that without being free from all sinful reactions, one cannot enter the path of devotional service. To dispel such doubts, Krishna says that he Himself will deliver the devotee from all the consequences of his past sinful activities. In this way, simply by surrendering to Krishna, one can immediately achieve all the positive results, avoiding unnecessary waste of time.

2. Who should be taught the science of Bhagavad-gita and who-No?

This confidential knowledge should not be given to someone who has not gone through the tapasya of the religious process, who has never tried to serve the Lord devotional, who has not assisted pure devotees, and especially to someone who considers Krishna a mere historical figure or is envious of His greatness. The Bhagavad-gita should be explained only to those who are ready to recognize Krishna as the Supreme Personality of Godhead.

3. What is the result of teaching and studying Bhagavad-gita?

One who explains this supreme secret to the devotees of Krishna will certainly rise to pure devotional service and eventually return to the Lord. And one who listens to the Bhagavad-gita with faith and without envy, is then freed from the consequences of sinful actions and reaches the planets inhabited by the righteous.

4. Explain the connection between the first and last verses of the Bhagavad-gita (1.1 and 18.78).

The Bhagavad Gita begins with questions from Dhritarashtra. The king hoped for the victory of his sons. However, after explaining the essence of what was happening on the battlefield, Sanjaya said to the king: “You are thinking about victory, but my opinion is that where Krishna and Arjuna are, there will certainly be abundance, victory, extraordinary strength and morality.” Victory is guaranteed to Arjuna's side, for Krishna was there.

Parents often support their adult children financially by helping them buy their first car or pay their rent. Miles Dunkley's father, Graham, went even further - he gave his son a share in the expensive cosmetics and hygiene products company, which he founded 15 years earlier. Miles took a 25% stake in his father's SLG company just as she closed her first deal to buy another business.

It was in 2000: Dunkley was 33 and his 63-year-old father was preparing to retire from running the business. Five years later, the father handed over control of the entire company to his son. Dunkley is currently in office CEO SLG, the company has £40m in revenue and 160 employees in the UK and Shanghai.

The transfer of control is easier if the heir is no longer a young man and he has enough experience, as in the case of SLG. If there are multiple children in the family, there is a risk that someone will feel left out, said Bernard Rennell, head of family management and company succession at HSBC.

David Glassman, a freelance lecturer at the Cranfield School of Management and a family business advisor, says the most important thing when transferring control of a business is to avoid favoritism or any hint of it. “For all positions in the company, use clear performance criteria. A well-thought-out system will give all current and future employees a clear idea that the most talented achieve success here,” he advises.

Difficult decision

98% 2/3 of companies worldwide are family owned. However, for many of them, the transition from a startup to a smoothly functioning family business is not easy, Cohen points out. “When a business is built from the ground up, it’s hard for entrepreneurs to let both experienced managers and their own kids run the business,” he says.

Dunkley Jr. had the opportunity to show his father what he was capable of: before joining the co-ownership of the company, he worked there for several years as a manager. “I was eager to move the company forward, and my father, understandably, slowed down,” he recalls. Dunkley received a second, majority stake from his father when SLG began to grow rapidly through acquisitions and the strategy chosen by his son.

Money is at the root of the problem, according to Allan Cohen, a professor at Babson College, a business school specializing in entrepreneurship studies. “If the company is the source of the future financial well-being the whole family, relatives may fear that the family member who is chosen to run the company will not be able to ensure the prosperity of the business,” he explains.

Dunkley Jr. has three children and could pass his business on to the next generation. However, the eldest is only 16 years old, and it is still premature to make a decision. To always remember his own good fortune, Dunkley keeps in his office a framed birthday card from his father, written during the days when he handed over the management of the company to his son. “I consider myself lucky because from the very first day my father believed in me incredibly,” says Dunkley, adding that so far he has been able to justify this trust, “without breaking the wood.”

Translated by Nadezhda Belichenko

A solemn summing up of the results of the All-Russian project "RATINGS OF THE AUTO OF THE YEAR - 2018" took place in Moscow. Representatives of the press, participants of the "Auto of the Year" quest, executives of large companies, representatives of PR and marketing of automotive companies and autobloggers.

According to the head of the Car of the Year in Russia project Vladimir Bezukladnikov, the “Ratings” differ from the spring project “Car of the Year Award” in that people from all over the country vote in them. They choose cars according to the same criteria as in life. The "premium" is selected according to the indicators of manufacturers. This year the voting was held in four nominations - "Workhorses", "Modern", "Family", "Reliable" cars.

LADA Largus took the first place in the Workhorses category by a large margin of almost 5,000 votes. Second and third place went to HYUNDAI, SOLARIS and GAZ, GAZEL NEXT. Among the "Modern" SUBARU, FORESTER are in the lead. It is followed by VOLVO, XC90, respectively, with a small margin, and 3rd place by AUDI, A8. The first three "Family" are divided among themselves at SKODA, KODIAQ, SUBARU, FORESTER, LADA, LARGUS. TOYOTA, LAND CRUISER PRADO, has been the first among the most “Reliable”, for many years now. Russians consider this car the most adapted to Russian roads. In second and third place are SUBARU, FORESTER and TOYOTA, CAMRY. In general, in this category, TOYOTA products take 5 places out of the top ten.

One of the winners of the contest, the beautiful SUBARU, FORESTER, was given as a prize to the winner of the "Auto of the Year" quest, which recently ended in Sochi. Captain Evgeny Kopytov, together with his team, successfully completed all the tasks and deservedly received the award. In addition to the keys to the car, the gift included a set of premium Continental VikingContact 7 tires and a spare engine oil TOTAL Quartz. The rest of the team also received certificates for sets of tires as a gift.

Custom fields are designed to store information about tasks or resources that cannot be placed in a note field. Custom text fields are useful for storing small pieces of information that don't require formatting, such as the result of a task.

It would seem, in what cases notes may not be suitable? The main advantage of notes is the ability to attach external files to tasks or use text formatting commands. Since these advanced features are not needed in order to simply indicate the result of the work in text form unformatted, they should be left for their intended use.

The advantage of custom fields is that they allow you to easily structure information about tasks or resources. For example, a project sponsor wants to understand what specific work is done during the execution of tasks and what results are achieved after the completion of each task. Using notes to store two types of information is inconvenient because you cannot view the description of the work separately from the results. But if you create two custom fields, one of which will contain a description of the work, and the other - their result, you can structure the data and use them separately in the future. Notes will be reserved for storing files and other additional supporting information.

Create custom fields

The "internal" tables of MS Project include a set of fields that the user can customize at their discretion and place their data in them. These fields can refer to either resources or tasks and differ in the types of data they can store. Working with custom fields is carried out in the Customize Fields dialog box, called either from the context menu of the table header, or using the Tools> Customize> Fields menu command (Tools> Customize> Fields).

The margin settings dialog box consists of two tabs. On the first tab, Custom Fields (Custom fields), and work with custom fields is carried out (Fig. 13.16, file 15.mpp).

Before setting up a field, you need to decide whether its content belongs to tasks or resources, and, accordingly, select the Task (Tasks) or Resource (Resources) radio button. Then, in the Type drop-down list, you need to determine the data type (Table 13.1) of this field.

Table 13.1. Custom Field Types in MS Project

Rice. 13.16. Margins dialog box

Having selected the required data type (in our example, 15.mpp is text), you need to select the field, and then configure it and give it a name so that you don’t forget that such and such data is stored in the field, for example, Textl. The Rename button is intended for this, after clicking on which a dialog box for entering the name of the field opens. Let's say we want to specify the result of a task in a custom field. Let's name the field Result, and its name will appear in the list of fields next to the field name Textl.

This operation is enough to create a simple custom field. We'll look at the rest of the options on this dialog box later when we set up other fields in our plan. You can now click the OK button to exit the dialog box and try out the convenience of using custom fields.

Populating with data

There are two ways to populate custom fields. The first, traditional for previous versions of MS Project, is to add a field to the table and edit the data in it in the same way as in other fields. The second way that you can edit custom field values, new only in MS Project 2002, is to use the Custom Fields tab in the task or resource details dialog box.

This tab lists all of the task-related custom fields that exist in the project (and the resource-specific fields will be located on a similar tab in the resource details dialog box). The table in the center of the dialog box has two columns. In the left column, Custom Field Name (Custom field name), the name of the field is indicated, and in the right column, Value (Value), its value for the current task. For example, in fig. 13.17 (file IS.mpp) we edit the value of the Result field for the Collect proposals from authors task. The output of the task will be an Editorial Proposal File.

Rice. 13.17. Populating a custom field value for a task

NOTE

In order for MS Project to "understand" that you want to use a custom field and display it in the dialog box, you must first rename this field.

As you can see in fig. 13.17, the WBS field (WBS) is also in the custom list. This happened because we changed its settings. If you do not configure the structure of task codes, then this field will not be listed in the list of customizable ones.

View content on a plan

You can display the contents of the fields in the table by adding the corresponding field to it, or directly on the Gantt chart, next to the tasks. To do this, in the dialog box for setting styles of bars, you need to edit the corresponding types of bars, adding the required field to the number of displayed data (for information on how to select fields to display next to bars, see the section “Setting text information displayed next to a bar”). You can also use the text style formatters to highlight the values ​​of these fields in a special font (see Formatting Text Styles).

For example, in the diagram in Fig. On 13.18 (file 18.mpp), we edited the Task line type and added a Result field in the settings for the text displayed next to the line, so that it appears below the line. Then, in the Format Text Styles dialog box, we changed the font of the text displayed below the bars in the chart by adding an underline.

Rice. 13.18. The results of the tasks are displayed on the diagram next to the tasks

Create custom list-of-value fields

Often additional information in custom fields is not unique for each task (as is the case with the Result field), but is repeated. For example, if a custom field contains information about the importance of achieving a result for the project, then the value of the field can be "High importance", "Medium" and "Low".

If a custom field can have a limited set of values, then it makes no sense to manually fill in the field for each task. It is much more convenient to create a list of possible values ​​and then, while editing a custom field for a task, select a value from the list.

In order to define a list of values ​​for a field, in the field settings dialog (see Figure 13.16), after selecting a custom field from the list, select the radio button next to the Value List button in the Custom attributes section. At the same time, MS Project will warn you that when you set the value list for the Pse Rapse field, the entered data may be lost, and if you are sure that you want to continue, then click OK in the warning window.

The list of field values ​​is set in the Value List dialog box, which opens after clicking on the button of the same name in the field settings dialog box. On fig. 13.19 in this dialog box, we set up the text field Importance of the result (file 14.mpp).

Rice. 13.19. Entering a list of values ​​for a custom field

In the center of the dialog box is a table consisting of two columns: Value (Value) and Description (Description). The first is where you enter the possible values ​​for the custom field, and the second where you enter the descriptions. Descriptions will be displayed when selecting a value from the list at the time of filling the field.

Sometimes it is convenient that when creating a new task (or resource, if the custom field refers to resources), one value from the list is automatically substituted into the field. For example, if most of the project's tasks are of medium importance, then you can substitute the default value of Medium, and select other values ​​from the list if necessary.

To make one of the values ​​the default value, select the Use a value from the list as a default entry for the field check box. After that, the Set Default button will become available, clicking on which turns the value selected in the table into the default value. After we assigned Average as the default value, the row containing this value and the table began to be highlighted in color.

NOTE

The default value will be set in the custom field only for new tasks or resources. If the resources were added before the field was configured, then the field value for them will be undefined (leave empty).

The Data entry options section defines the order in which the custom field is populated. If you select the Restrict fields to items in the value list radio button, then when filling in the field, the selection will be limited to the existing list and you will not be able to enter arbitrary values. If you select the radio button Allow additional items to be entered into the field (Other elements are allowed in the field), then when filling this field, you can both select items from the list and enter arbitrary values.

If you want arbitrary values ​​entered in the field to be automatically added to the list of field values, then you need to select the Append new entries to the value list check box. And in order for the program to ask for confirmation before adding a value to the list, you need to check the box Prompt before adding new values ​​(Request before adding new elements).

An input mode that has the last two checkboxes checked (as in Figure 13.19) is quite handy because it allows you to add a new item to the list of values ​​without going into the field setup dialog box. On the other hand, warnings can help you avoid accidentally adding a value.

The order in which list items are displayed when selected is determined by the radio buttons in the lower section of the dialog box, Display order for dropdown list. Values ​​can be sorted by row number in the table if you select the By row number radio button, or alphabetically if you select the Sort ascending or Sort descending radio button. The first option is the most convenient, because it allows you to customize the order of the records in the table and arrange the values ​​according to the expected frequency of their use.

Using formulas

Sometimes custom field values ​​can be filled in automatically using formulas. For example, if you know how long it takes on average to edit 1 page of text, then by specifying the number of pages in an article, you can use the formula to calculate the total duration of the article editing task.

In order to enter a formula in a custom field, in the field settings dialog box (see Figure 13.16), select the custom field from the list, and then in the Custom attributes section, select the radio button next to the Formula button. MS Project will warn you that when you set up a formula for a field, all previously entered data may be lost, and if you are sure that you want to continue, then click OK in the warning window.

To edit the formula, you need to click the Formula button (Formula), after which the MS Project formula editor will be loaded (Fig. 13.20, IS.mpp file). The editor consists of a formula editing area and a set of buttons, by clicking on which you can enter formula fragments. The formula can be completely printed manually, or you can enter it by pressing the buttons.

Rice. 13.20. MS Project formula editor

In the formula, you can use operations on other MS Project fields. For example, to determine the total edit time for an article, multiply the number of pages in the article by the edit time per page. In our project (IS.mpp), we renamed the custom field Duration1(Duration1) to Page Editing Time, and the field Numberl(Number1) to Number of pages in the article. So, to determine the value of the Duration2 (Duration2) field, or the Total time for editing an article, you need to multiply the value of the Durationl (Duration1) field by Number1 (Number1). In the formula, as we see in the figure, the field names (as in filters) must be enclosed in square brackets.

In order to substitute the name of the field in the formula, you can use the button Field (Field), and to insert one of the dozens of available functions, the button Function (Function). In addition, using the Import Formula button, you can insert a formula into the field from another field in any of the open projects.

On fig. 13.21 (file IS.mpp) you can see how the settings we made work. After filling in the Number of pages in the article and Page editing time fields, the Total article editing time field is recalculated.

Rice. 13.21. Calculation using formulas works

However, the current scoring mode has one disadvantage: the duration calculated for each task does not sum up for the phase. This means that we cannot automatically determine its duration. To automatically recalculate values ​​in a custom field for summary tasks, you need to configure it in a special way.

Custom fields and summary tasks

You can determine how the custom field data will be displayed for summary tasks in the field settings dialog box, in the Calculation for task and group summary rows section, by selecting the required field in the list (Fig. 13.22, file 16 .mpp).

Rice. 13.22. Set up calculations for summary tasks. The contents of the drop-down list depend on the type of the selected field

The section contains three switches: None (No), Rollup (Reduced) and Use formula (Use formula). If you select the first one, then the custom field data will only be calculated for normal tasks, not for summary tasks. The second radio button allows you to calculate the custom field value for summary tasks using one of the operations provided in the drop-down list. The composition of this list varies depending on the types of fields (Table 13.2), in addition, you cannot summarize data for text fields.

Operation nameCustom field typesDescription
AndFlag (Flag)Logical AND. If all nested rows in this field are Yes, then the result of the operation is also Yes. If at least one of the strings in this field contains the value No, then the result of the logical operation will be No
OR (OR)Flag (Flag)Logical OR. If at least one of the rows contains the value Yes in this field, then the flattening operation will also give Yes
Average The pivot will be the average of all nested non-summary series values
Average First Sublevel (Average of the first sublevel)Cost (Costs), Duration (Duration), Number (Number)The pivot will be the average of all values ​​of nested non-summary series and of all values ​​of nested first-level summary series
Count All (Add all)Number (Number)When rolling, all total and non-total rows will be added
Count First Sublevel (Add the first sublevel)Number (Number)Pivot will add first level total series and all nested non-total series
Count Nonsummaries (Add non-total)Number (Number)Pivot will add up all non-summary tasks
maximum The result of the rollup will be the maximum value among all the values ​​below
minimumCost (Costs), Duration (Duration), Number (Number), Start (Start), Finish (End)The result of the rollup will be the minimum value among all the values ​​below
Sum (Amount)Cost (Costs), Duration (Duration), Number (Number)The result of the rollup will be the sum of all the values ​​below

Table 13.2. Operations to Roll Up Data in Summary Tasks

If a formula is used to calculate the custom field, then the third radio button, Use formula, becomes available. If you select it, the same formula is used to calculate custom field values ​​for summary tasks as for regular tasks. In our case (file 16.mpp), it is more convenient to use the addition of custom field values ​​for tasks than a formula. After all, our formula uses the values ​​of other fields when calculating, which means that they also need to configure the parameters for determining the value for summary tasks. If this is not done, then the values ​​of these fields for summary tasks will always be zero, and the result of our formula will also be zero.

On fig. 13.23 shows a table from file 16.mpp with calculations of the total duration of editing articles after we set up the summation of values ​​for phases in the field Total article editing time. Now the values ​​in it are summarized, but the rest of the custom fields are still not.

Rice. 13.23. Now the total time for editing articles is summed up

The duration calculated by us is actually the labor costs for the execution of the editing work. However, this data cannot be automatically entered into the project plan, that is, in the Work field (Labor costs) of the corresponding tasks, since this field is not customizable and formulas cannot be entered into it. Therefore, you can only enter the data we received into this field manually.

A model in which data is automatically calculated in one field when other fields are changed and then manually transferred to the project plan is fraught with one danger: you can accidentally forget to enter labor data into the project plan. In this case, the planned effort of the task will be incorrect, which means that the project plan as a whole will be inaccurate. To ensure that the task effort always matches the data in the Total article editing time custom field, we will use indicators.

Using indicators

MS Project contains the ability to display color indicators instead of data in a custom field. The color of the indicator depends on the fulfillment or non-fulfillment of the logical condition. For example, in our case (file 17.mpp), you can create the Updated field and configure it so that if the data in the Total article editing time field is equal to the data in the Work field, then a green indicator is displayed in it, and if they are not equal - then red.

In principle, such an indicator could also be displayed in the Total Article Editing Time field itself, but we will create an Updated field of type Flag to demonstrate how to work with fields of this type.

In the field definitions dialog box, rename the Flagl field (Flag!) to Updated, and then open the formula setup dialog box for it. Enter the formula = ([Duration2] = [Labor]). Flag fields can only contain the value Yes (Yes) or No (No), and if the condition of the formula is met (that is, the total editing time of the article is equal to labor costs), then the field will contain Yes (Yes), and if the condition is not met - No ( Not).

Now you need to configure the display of indicators. To do this, in the Values ​​to display section of the field setup dialog box (see Figure 13.16), select the radio button next to the Graphical Indicators button. Then, to configure the indicators, you need to click this button. In the window that opens (Fig. 13.24, file 17.mpp), you need to set the criteria for displaying indicators for different tasks.

Rice. 13.24. Dialog box for setting the display of indicators

In the upper part of the dialog box, select the radio button corresponding to the type of tasks for which the criteria for displaying indicators are configured: Nonsummary rows, Summary rows, or Project summary. At the same time, for each type, you can configure your own criteria for displaying the indicator.

In order for indicators to be displayed for summary tasks according to the same criteria as for regular tasks, you need to select the Summary rows inherit criteria from nonsummary rows check box. And in order for the project summary task to use the same criteria as summary tasks, you need to select the Project summary inherits criteria from summary rows check box (The project summary task inherits conditions from summary rows). If both checkboxes are checked, then by configuring the settings for normal tasks, you thereby determine the display settings for all other tasks in the project. The settings for displaying indicators are made in the table in the center of the dialog box.

The table contains three columns: Test for (Field check), Values ​​(Values) and Image (Figure). In the first column, a condition is selected from the list, which the value in the second column must meet. The list of conditions is the same as the one we used when creating filters in Lesson 4, Sorting, Grouping, and Filtering Data in Tables (see Table 4.1).

You can use specific values, for example Yes (Yes) or No (No), as in our case, or you can select the value of any of the fields. In the last field, a picture is selected from the list to be used as an indicator if the condition described in the first two fields is met. So, in our case, if the field value is Yes (Yes), a green indicator should be displayed, and if it is No (No) - red.

Field value checks are performed in turn from top to bottom, and the first time the condition is matched, the indicator to be displayed is selected. To move the conditions up and down the list, use the arrow buttons located on the side of the list.

Sometimes you want to view the field values ​​hidden “under” the indicator. If you check the Show data values ​​in ToolTips checkbox, the data will be displayed when you hover over the indicator with the mouse.

The result of setting up indicators for the Updated field is shown in fig. 13.25 (file 17.mpp). As we can see, if the data in the Total article editing time field is not equal to the task effort, the field contains a red indicator, and if equal, it is green.

Rice. 13.25. Result of indicator settings

However, the figure also shows a discrepancy - the labor costs in the summary task are 40 hours (5 days), and the total time for editing articles calculated using the formula is three. However, the box displays a green indicator. What's the matter?

If we place the cursor on a cell with an indicator in the row of a regular task, we will see that the field cannot be edited (since its value is calculated by a formula), and if we place the cursor on the row of a summary task, we will see that the cell can be edited. That is, when setting up the formula for the Updated field, we forgot to define the formula for calculating the value for summary tasks.

Let's go to the fields settings dialog box and select the data summation operation for the Updated field (similar to Fig. 13.22). Since this is a field of type Flag (Flag), the set of operations (in accordance with Table 13.2) will not be the same as for a field of type Duration (Duration). Among them, the operation And (And) is suitable for us: if all ordinary tasks inside the summary have the value Yes (Yes), then the value of the summary will be the same. And if among the regular tasks there is at least one field with the value No (No), then the value in the field of the summary task will also be No. This is exactly what we need: if the work of at least one of the regular tasks is not updated and does not match the formula calculations, then the work of the summary task is also not correct. Now the indicator of the summary task will be green only when the indicators of all the tasks nested in it are also green. On fig. 13.26 shows the results of these settings (IS.mpp). We copied the summary task and its subtasks to demonstrate how joining works for a Flag type field. In the first case, when there is one with a red indicator among the nested tasks of the phase, the phase indicator is also red. In the second case, when all sub-task indicators are green, the indicator for the phase is also green.

Rice. 13.26. Configuring Indicators with Combining Values ​​for Summary Tasks

.
The research organization "Levada-Center" noted an almost twofold increase in the number of Russians dissatisfied with the rich.

In the case of fraud with real estate in the MiG corporation, the former general director of the corporation's subsidiary, OJSC MiG-Rost, Alexei Ozerov, and the deputy general director of PJSC Tupolev, Yegor Noskov, were arrested, Kommersant found out
According to the publication, we are talking about the events of 2001, when MiG decided to get rid of its supposedly non-core asset with an area of ​​22 thousand square meters. m in Moscow on Polikarpova street. The property was transferred to economic management"MiG-Rost", which was headed by Ozerov. Subsequently, when a plan appeared on the centralized sale of space that would be freed up when the production facilities of the DGC were removed from Moscow, the assets were encumbered with a lease agreement, which was then extended for 49 years.

In 2004, the complex of buildings on Polikarpova Street was sold to Business-Active LLC, established in the same year. And a year later, this company with an asset of hundreds of millions of rubles for only 10 thousand rubles. bought by businessman Yegor Noskov, who is now the deputy general director of Tupolev PJSC for the property complex. "Business-Active" ceased to exist in 2010, and "MiG-Rost" - two years later, the newspaper writes.
The investigation also found that in 2005, all the property that once belonged to MiG was resold for almost 50 million rubles. Liberta-investment LLC, which has been leasing it for ten years, including to structures, included in the United aircraft corporation(UAC). The investigators have no claims against Liberta-investment LLC as a bona fide buyer, the newspaper writes.

What will the accumulation of explosives of discontent in society lead to? The madness of the hedonists who are prozhiratsya the country is capable of causing a social explosion.
After all, everyone sees how the social sphere is being cut against the background of the furiously hysterical consumption of small groups of citizens covered at the highest state level. Here Ulyukaev speaks, and talks about the taxation system. Say, no progressive scale!
The rich will pay the same personal income tax as the poor. What is this, Europe? No. This is the robbery of the population and the fattening of the elite, who stole people's property in the course of gangster privatization and firmly stuck to it.

What, do you really need a new October? Continue to pressure the people with juvenile technologies, the destruction of education, falling incomes, non-transparent political games. At the same time defiantly eat three throats and take bribes of millions of euros.
Well, of course, wait.

"- Okay, okay, kids, just give me time,
There will be a squirrel for you, there will be a whistle!