Today's activity report #19

Today I started developing an add-in for Excel to speed up the processing of existing databases and reduce the number of errors due to the automation of checking the values ​​of some database fields. I defined the main logical blocks: checking the correctness of the entered data, interaction with the database of interviewed people and moving buttons of standard functions to improve access to them.

Developed macros:

1. quick conversion of formulas into values;
2. correction and conversion of dates of birth;
3. reproduction of lost dates of birth (if possible);
4. checking the subordination of territorial units;

Scheduled:

1. Batch cleaning of data from garbage;
2. Automatic determination of a person's gender by name (to supplement partial data);
3. Highlighting the current row to simplify navigation on the sheet.

Time spent: 8h