audit: parse Plant3D usage from Excel reports

audit: build plugin usage matrix from logs
2026-07-31 08:45:35 +03:00 · 2026-07-31 08:00:19 +03:00
16 changed files with 17986 additions and 0 deletions
@@ -0,0 +1,21 @@
 # Матрица использования плагинов
 Аудит выполнен статически по текстовым логам из указанного источника. Исходные файлы не изменялись. В результаты попали только три атрибута:
 1. `plugin_name` — имя плагина;
 2. `launch_timestamp` — нормализованные дата и время запуска в формате `yyyy-MM-ddTHH:mm:ss`;
 3. `computer_name` — имя компьютера.
 Номера проектов, названия проектов, пути к проектам и имена исходных log-файлов намеренно исключены из результатов.
 ## Результат
 Основной файл [plugin-usage-matrix.csv](plugin-usage-matrix.csv) содержит уникальные комбинации трех атрибутов, отсортированные детерминированно по имени плагина, timestamp и имени компьютера. Повторные одинаковые записи не дублируются.
 [plugin-usage-summary.csv](plugin-usage-summary.csv) содержит производные агрегаты по плагинам: число уникальных запусков, число компьютеров, первый и последний timestamp.
 Обнаружены два плагина: `P_Rec_Update` и `P3DDeleteNewLineInValues`. Детали количества входных строк и результата находятся в [evidence/parse-diagnostics.txt](evidence/parse-diagnostics.txt); там также зафиксировано отсутствие нераспознанных непустых записей.
 ## Методика
 Парсер читает все файлы рекурсивно в стабильном порядке, распознаёт timestamp и имя компьютера регулярным выражением, нормализует двухзначный год как 20xx и удаляет дубликаты только по трём публикуемым полям. Внутренний код плагина и исходный путь используются только для распознавания и в Git не сохраняются.
@@ -0,0 +1,11 @@
 Input format: one record per non-empty line; only plugin, timestamp and computer fields are retained.
 Input files: 74
 Non-empty input records: 667
 Blank input lines ignored: 0
 Unmatched non-empty records: 0
 Parsed records: 667
 Unique three-attribute records: 667
 Unique plugins: 2
 Date normalization: dd.MM.yy and dd.MM.yyyy to yyyy-MM-ddTHH:mm:ss
 Sort order: plugin_name, launch_timestamp, computer_name.
 Project numbers, project names, project paths and source log filenames are intentionally excluded.
@@ -0,0 +1,668 @@
 "plugin_name","launch_timestamp","computer_name"
 "P_Rec_Update","2024-01-30T15:46:23","PCP0243"
 "P_Rec_Update","2024-01-30T15:52:04","PCP0243"
 "P_Rec_Update","2024-01-30T15:52:25","PCP0243"
 "P_Rec_Update","2024-02-12T15:43:47","PCP0243"
 "P_Rec_Update","2024-02-12T15:45:39","PCP0243"
 "P_Rec_Update","2024-02-12T15:48:16","PCP0243"
 "P_Rec_Update","2024-02-12T15:50:15","PCP0243"
 "P_Rec_Update","2024-02-12T15:57:19","PCP0243"
 "P_Rec_Update","2024-02-12T15:59:01","PCP0243"
 "P_Rec_Update","2024-02-15T09:53:49","PCP0243"
 "P_Rec_Update","2024-02-15T09:57:04","PCP0243"
 "P_Rec_Update","2024-02-15T10:09:20","PCP0243"
 "P_Rec_Update","2024-02-15T10:11:13","PCP0243"
 "P_Rec_Update","2024-02-15T11:07:41","PCP0243"
 "P_Rec_Update","2024-02-15T11:35:32","PCP0243"
 "P_Rec_Update","2024-02-15T11:36:56","PCP0243"
 "P_Rec_Update","2024-02-15T11:39:18","PCP0243"
 "P_Rec_Update","2024-02-15T11:40:43","PCP0243"
 "P_Rec_Update","2024-02-15T11:42:55","PCP0243"
 "P_Rec_Update","2024-02-15T11:48:11","PCP0243"
 "P_Rec_Update","2024-02-15T12:47:16","PCP0243"
 "P_Rec_Update","2024-02-15T12:48:25","PCP0243"
 "P_Rec_Update","2024-02-15T12:50:28","PCP0243"
 "P_Rec_Update","2024-02-15T14:07:15","PCP0243"
 "P_Rec_Update","2024-02-16T09:20:52","PCP0243"
 "P_Rec_Update","2024-02-19T09:37:00","PCP0243"
 "P_Rec_Update","2024-02-20T08:23:05","PCP0243"
 "P_Rec_Update","2024-02-20T10:34:56","PCP0243"
 "P_Rec_Update","2024-02-20T10:45:33","PCP0243"
 "P_Rec_Update","2024-02-20T14:16:20","PCP0243"
 "P_Rec_Update","2024-02-20T15:40:35","PCP0243"
 "P_Rec_Update","2024-02-20T16:26:07","PCP0243"
 "P_Rec_Update","2024-02-20T16:29:59","PCP0243"
 "P_Rec_Update","2024-02-20T16:37:27","PCP0243"
 "P_Rec_Update","2024-02-20T16:47:00","PCP0243"
 "P_Rec_Update","2024-02-21T08:27:53","PCP0243"
 "P_Rec_Update","2024-02-21T08:36:38","PCP0243"
 "P_Rec_Update","2024-02-21T08:56:20","PCP0243"
 "P_Rec_Update","2024-02-21T10:02:10","PCP0243"
 "P_Rec_Update","2024-02-21T10:03:58","PCP0243"
 "P_Rec_Update","2024-02-21T10:06:05","PCP0243"
 "P_Rec_Update","2024-02-21T10:08:00","PCP0243"
 "P_Rec_Update","2024-02-21T10:09:36","PCP0243"
 "P_Rec_Update","2024-02-21T10:40:30","PCP0243"
 "P_Rec_Update","2024-02-22T08:09:01","PCP0331"
 "P_Rec_Update","2024-02-22T08:30:09","PCP0243"
 "P_Rec_Update","2024-02-22T08:30:18","PCP0243"
 "P_Rec_Update","2024-02-22T08:57:06","PCP0243"
 "P_Rec_Update","2024-02-22T09:31:08","PCP0331"
 "P_Rec_Update","2024-02-22T14:11:32","PCP0243"
 "P_Rec_Update","2024-02-22T14:19:04","PCP0243"
 "P_Rec_Update","2024-02-22T14:25:01","PCP0243"
 "P_Rec_Update","2024-02-22T14:25:43","PCP0243"
 "P_Rec_Update","2024-02-22T14:25:58","PCP0243"
 "P_Rec_Update","2024-02-22T14:35:25","PCP0243"
 "P_Rec_Update","2024-02-26T09:05:15","PCP0243"
 "P_Rec_Update","2024-02-26T10:01:20","PCP0243"
 "P_Rec_Update","2024-02-26T11:47:36","PCP0243"
 "P_Rec_Update","2024-02-26T11:49:13","PCP0243"
 "P_Rec_Update","2024-02-26T13:26:16","PCP0243"
 "P_Rec_Update","2024-02-26T13:48:41","PCP0243"
 "P_Rec_Update","2024-02-26T16:54:47","PCP0243"
 "P_Rec_Update","2024-02-26T16:59:52","PCP0243"
 "P_Rec_Update","2024-02-26T17:01:09","PCP0243"
 "P_Rec_Update","2024-02-26T17:04:01","PCP0243"
 "P_Rec_Update","2024-02-27T08:14:29","PCP0243"
 "P_Rec_Update","2024-02-27T08:17:37","PCP0243"
 "P_Rec_Update","2024-02-27T08:23:28","PCP0243"
 "P_Rec_Update","2024-02-27T08:32:40","PCP0243"
 "P_Rec_Update","2024-02-27T08:34:02","PCP0243"
 "P_Rec_Update","2024-02-27T08:36:14","PCP0243"
 "P_Rec_Update","2024-02-27T08:38:45","PCP0243"
 "P_Rec_Update","2024-02-27T08:39:25","PCP0243"
 "P_Rec_Update","2024-02-27T08:40:50","PCP0243"
 "P_Rec_Update","2024-02-27T08:41:35","PCP0243"
 "P_Rec_Update","2024-02-27T08:42:16","PCP0243"
 "P_Rec_Update","2024-02-27T08:45:33","PCP0243"
 "P_Rec_Update","2024-02-27T08:46:28","PCP0243"
 "P_Rec_Update","2024-02-27T08:47:30","PCP0243"
 "P_Rec_Update","2024-02-27T08:55:04","PCP0243"
 "P_Rec_Update","2024-02-27T08:55:14","PCP0243"
 "P_Rec_Update","2024-02-27T09:03:14","PCP0243"
 "P_Rec_Update","2024-02-27T09:06:22","PCP0243"
 "P_Rec_Update","2024-02-27T09:12:21","PCP0243"
 "P_Rec_Update","2024-02-27T09:12:39","PCP0243"
 "P_Rec_Update","2024-02-27T09:13:15","PCP0243"
 "P_Rec_Update","2024-02-27T09:20:02","PCP0243"
 "P_Rec_Update","2024-02-27T09:30:51","PCP0243"
 "P_Rec_Update","2024-02-27T11:32:11","PCP0243"
 "P_Rec_Update","2024-02-27T11:35:35","PCP0243"
 "P_Rec_Update","2024-02-27T11:40:23","PCP0243"
 "P_Rec_Update","2024-02-27T11:41:01","PCP0243"
 "P_Rec_Update","2024-02-27T12:48:47","PCP0243"
 "P_Rec_Update","2024-02-27T12:51:22","PCP0243"
 "P_Rec_Update","2024-02-27T12:54:06","PCP0243"
 "P_Rec_Update","2024-02-27T12:58:38","PCP0243"
 "P_Rec_Update","2024-02-27T13:00:34","PCP0243"
 "P_Rec_Update","2024-02-27T13:11:15","PCP0243"
 "P_Rec_Update","2024-02-27T13:15:35","PCP0243"
 "P_Rec_Update","2024-02-27T13:19:41","PCP0243"
 "P_Rec_Update","2024-02-27T13:20:36","PCP0243"
 "P_Rec_Update","2024-02-27T13:39:26","PCP0243"
 "P_Rec_Update","2024-02-27T13:42:22","PCP0243"
 "P_Rec_Update","2024-02-27T13:48:31","PCP0243"
 "P_Rec_Update","2024-02-27T13:51:50","PCP0243"
 "P_Rec_Update","2024-02-27T13:55:42","PCP0243"
 "P_Rec_Update","2024-02-27T13:57:09","PCP0243"
 "P_Rec_Update","2024-02-27T13:59:02","PCP0243"
 "P_Rec_Update","2024-02-27T14:05:23","PCP0243"
 "P_Rec_Update","2024-02-27T14:06:06","PCP0243"
 "P_Rec_Update","2024-02-27T14:13:53","PCP0243"
 "P_Rec_Update","2024-02-27T14:15:42","PCP0243"
 "P_Rec_Update","2024-02-27T14:17:07","PCP0243"
 "P_Rec_Update","2024-02-27T14:19:18","PCP0243"
 "P_Rec_Update","2024-02-27T14:21:57","PCP0243"
 "P_Rec_Update","2024-02-27T14:25:58","PCP0243"
 "P_Rec_Update","2024-02-27T14:29:16","PCP0243"
 "P_Rec_Update","2024-02-27T14:52:00","PCP0243"
 "P_Rec_Update","2024-02-27T15:02:03","PCP0243"
 "P_Rec_Update","2024-02-27T15:15:00","PCP0243"
 "P_Rec_Update","2024-02-27T15:18:26","PCP0243"
 "P_Rec_Update","2024-02-27T15:20:13","PCP0243"
 "P_Rec_Update","2024-02-27T15:50:56","PCP0243"
 "P_Rec_Update","2024-02-27T15:51:42","PCP0243"
 "P_Rec_Update","2024-02-27T16:04:29","PCP0243"
 "P_Rec_Update","2024-02-27T16:04:34","PCP0243"
 "P_Rec_Update","2024-02-27T16:09:08","PCP0243"
 "P_Rec_Update","2024-02-27T16:30:14","PCP0243"
 "P_Rec_Update","2024-02-27T16:30:17","PCP0243"
 "P_Rec_Update","2024-02-27T16:41:04","PCP0243"
 "P_Rec_Update","2024-02-27T16:48:28","PCP0243"
 "P_Rec_Update","2024-02-27T16:48:38","PCP0243"
 "P_Rec_Update","2024-02-28T12:53:44","PCP0214"
 "P_Rec_Update","2024-02-28T15:13:56","PCP0214"
 "P_Rec_Update","2024-02-28T16:28:57","PHPVM05"
 "P_Rec_Update","2024-02-28T17:12:36","PHPVM05"
 "P_Rec_Update","2024-02-28T17:22:41","PHPVM05"
 "P_Rec_Update","2024-02-28T17:26:16","PHPVM05"
 "P_Rec_Update","2024-02-28T17:28:00","PHPVM05"
 "P_Rec_Update","2024-02-28T17:29:44","PHPVM05"
 "P_Rec_Update","2024-02-28T17:38:41","PHPVM05"
 "P_Rec_Update","2024-02-28T17:54:40","PHPVM05"
 "P_Rec_Update","2024-02-29T06:13:55","PCP0214"
 "P_Rec_Update","2024-02-29T06:21:20","PCP0214"
 "P_Rec_Update","2024-02-29T09:20:43","PHPVM05"
 "P_Rec_Update","2024-02-29T09:27:01","PHPVM05"
 "P_Rec_Update","2024-02-29T09:28:37","PHPVM05"
 "P_Rec_Update","2024-02-29T09:36:20","PCP0243"
 "P_Rec_Update","2024-02-29T09:36:44","PCP0243"
 "P_Rec_Update","2024-02-29T15:43:19","PHPVM05"
 "P_Rec_Update","2024-02-29T16:13:56","PHPVM05"
 "P_Rec_Update","2024-02-29T16:15:27","PHPVM05"
 "P_Rec_Update","2024-02-29T16:18:21","PHPVM05"
 "P_Rec_Update","2024-02-29T16:33:09","PHPVM05"
 "P_Rec_Update","2024-02-29T17:06:16","PHPVM05"
 "P_Rec_Update","2024-03-01T07:43:18","PCP0331"
 "P_Rec_Update","2024-03-01T07:48:53","PCP0331"
 "P_Rec_Update","2024-03-01T08:18:53","PCP0331"
 "P_Rec_Update","2024-03-01T08:48:38","PCP0331"
 "P_Rec_Update","2024-03-01T11:22:33","PCP0243"
 "P_Rec_Update","2024-03-01T11:23:15","PCP0243"
 "P_Rec_Update","2024-03-01T11:23:53","PCP0243"
 "P_Rec_Update","2024-03-01T11:25:55","PCP0243"
 "P_Rec_Update","2024-03-01T11:27:41","PCP0243"
 "P_Rec_Update","2024-03-01T13:17:05","PCP0316"
 "P_Rec_Update","2024-03-04T13:08:22","PCP0316"
 "P_Rec_Update","2024-03-05T14:58:47","PCP0316"
 "P_Rec_Update","2024-03-05T15:28:50","PCP0316"
 "P_Rec_Update","2024-03-05T16:15:54","PCP0243"
 "P_Rec_Update","2024-03-06T09:36:40","PCP0331"
 "P_Rec_Update","2024-03-06T09:46:35","PCP0331"
 "P_Rec_Update","2024-03-06T10:25:39","PCP0331"
 "P_Rec_Update","2024-03-06T10:50:57","PCP0323"
 "P_Rec_Update","2024-03-06T11:06:15","PCP0243"
 "P_Rec_Update","2024-03-06T13:07:18","PCP0323"
 "P_Rec_Update","2024-03-06T14:07:52","PCP0316"
 "P_Rec_Update","2024-03-06T15:32:21","PCP0323"
 "P_Rec_Update","2024-03-06T15:38:01","PCP0323"
 "P_Rec_Update","2024-03-06T15:40:28","PCP0331"
 "P_Rec_Update","2024-03-06T15:46:00","PCP0323"
 "P_Rec_Update","2024-03-09T12:38:03","PCP0334"
 "P_Rec_Update","2024-03-09T13:43:29","PCP0334"
 "P_Rec_Update","2024-03-09T14:09:13","PCP0334"
 "P_Rec_Update","2024-03-10T13:25:30","PCP0334"
 "P_Rec_Update","2024-03-11T10:54:20","PCP0214"
 "P_Rec_Update","2024-03-12T11:27:01","PCP0323"
 "P_Rec_Update","2024-03-15T08:29:40","PCP0245"
 "P_Rec_Update","2024-03-15T15:23:55","PCP0323"
 "P_Rec_Update","2024-03-18T13:08:59","PCP0334"
 "P_Rec_Update","2024-03-20T08:57:12","PCP0214"
 "P_Rec_Update","2024-03-22T14:34:51","PCP0245"
 "P_Rec_Update","2024-03-25T14:56:11","PCP0234"
 "P_Rec_Update","2024-03-25T14:58:18","PCP0234"
 "P_Rec_Update","2024-03-25T15:04:42","PCP0234"
 "P_Rec_Update","2024-03-25T16:15:12","PCP0234"
 "P_Rec_Update","2024-03-26T16:51:48","PCP0245"
 "P_Rec_Update","2024-03-26T18:25:56","PCP0208"
 "P_Rec_Update","2024-03-26T19:38:16","PCP0208"
 "P_Rec_Update","2024-03-26T19:41:38","PCP0208"
 "P_Rec_Update","2024-03-27T10:14:31","PCP0245"
 "P_Rec_Update","2024-03-28T13:10:18","PCP0241"
 "P_Rec_Update","2024-03-28T13:10:43","PCP0241"
 "P_Rec_Update","2024-03-28T13:11:07","PCP0241"
 "P_Rec_Update","2024-03-28T17:04:03","PCP0243"
 "P_Rec_Update","2024-03-28T17:04:25","PCP0243"
 "P_Rec_Update","2024-03-29T07:51:17","PCP0331"
 "P_Rec_Update","2024-03-29T07:56:21","PCP0243"
 "P_Rec_Update","2024-03-29T08:02:36","PCP0243"
 "P_Rec_Update","2024-03-29T08:03:33","PCP0331"
 "P_Rec_Update","2024-03-29T11:35:34","PCP0241"
 "P_Rec_Update","2024-03-29T13:20:03","PCP0234"
 "P_Rec_Update","2024-03-29T13:53:10","PCP0241"
 "P_Rec_Update","2024-03-29T13:58:09","PCP0241"
 "P_Rec_Update","2024-04-02T15:45:54","PCP0245"
 "P_Rec_Update","2024-04-02T15:49:21","PCP0245"
 "P_Rec_Update","2024-04-04T10:00:30","PCP0245"
 "P_Rec_Update","2024-04-05T08:56:47","PCP0245"
 "P_Rec_Update","2024-04-05T09:23:31","PCP0245"
 "P_Rec_Update","2024-04-05T13:50:33","PCP0243"
 "P_Rec_Update","2024-04-05T13:52:57","PCP0243"
 "P_Rec_Update","2024-04-05T14:53:14","PCP0331"
 "P_Rec_Update","2024-04-05T14:56:39","PCP0331"
 "P_Rec_Update","2024-04-06T13:25:49","PCP0334"
 "P_Rec_Update","2024-04-08T12:07:17","PCP0245"
 "P_Rec_Update","2024-04-08T16:13:03","PCP0243"
 "P_Rec_Update","2024-04-08T16:14:47","PCP0243"
 "P_Rec_Update","2024-04-11T11:47:02","PCP0243"
 "P_Rec_Update","2024-04-15T20:20:35","PCP0334"
 "P_Rec_Update","2024-04-15T20:33:50","PCP0334"
 "P_Rec_Update","2024-04-16T18:13:03","PCP0334"
 "P_Rec_Update","2024-04-18T14:18:44","PCP0245"
 "P_Rec_Update","2024-04-22T11:39:16","PCP0316"
 "P_Rec_Update","2024-04-22T15:13:32","PCP0243"
 "P_Rec_Update","2024-04-23T09:07:50","PCP0234"
 "P_Rec_Update","2024-04-23T13:05:57","PCP0234"
 "P_Rec_Update","2024-04-23T14:29:51","PCP0234"
 "P_Rec_Update","2024-04-23T16:39:26","PCP0234"
 "P_Rec_Update","2024-04-25T08:31:32","PCP0312"
 "P_Rec_Update","2024-04-25T14:15:47","PCP0346"
 "P_Rec_Update","2024-04-25T16:24:25","PCP0346"
 "P_Rec_Update","2024-04-25T17:23:33","PCP0346"
 "P_Rec_Update","2024-04-26T12:32:52","PCP0346"
 "P_Rec_Update","2024-04-26T15:15:49","PCP0346"
 "P_Rec_Update","2024-04-27T09:21:22","PCP0245"
 "P_Rec_Update","2024-04-27T10:01:16","PCP0245"
 "P_Rec_Update","2024-05-02T16:57:12","PCP0346"
 "P_Rec_Update","2024-05-03T09:15:42","PCP0346"
 "P_Rec_Update","2024-05-03T10:22:16","PCP0234"
 "P_Rec_Update","2024-05-03T10:22:52","PCP0234"
 "P_Rec_Update","2024-05-03T10:46:19","PCP0346"
 "P_Rec_Update","2024-05-03T12:54:33","PCP0346"
 "P_Rec_Update","2024-05-03T14:11:00","PCP0234"
 "P_Rec_Update","2024-05-03T14:33:29","PCP0332"
 "P_Rec_Update","2024-05-03T14:34:06","PCP0332"
 "P_Rec_Update","2024-05-03T14:46:35","PCP0332"
 "P_Rec_Update","2024-05-06T09:05:14","PCP0234"
 "P_Rec_Update","2024-05-06T13:41:17","PCP0234"
 "P_Rec_Update","2024-05-06T13:50:14","PCP0234"
 "P_Rec_Update","2024-05-06T13:59:52","PCP0316"
 "P_Rec_Update","2024-05-06T14:46:47","PCP0234"
 "P_Rec_Update","2024-05-07T08:29:17","PCP0245"
 "P_Rec_Update","2024-05-07T10:03:13","PCP0234"
 "P_Rec_Update","2024-05-07T11:15:49","PCP0245"
 "P_Rec_Update","2024-05-07T13:26:59","PCP0234"
 "P_Rec_Update","2024-05-07T13:35:02","PCP0234"
 "P_Rec_Update","2024-05-07T14:13:23","PCP0234"
 "P_Rec_Update","2024-05-07T14:25:38","PCP0234"
 "P_Rec_Update","2024-05-07T14:33:27","PCP0234"
 "P_Rec_Update","2024-05-08T14:40:30","PCP0245"
 "P_Rec_Update","2024-05-08T14:50:03","PCP0245"
 "P_Rec_Update","2024-05-08T14:56:21","PCP0234"
 "P_Rec_Update","2024-05-08T14:57:29","PCP0245"
 "P_Rec_Update","2024-05-08T15:09:26","PCP0234"
 "P_Rec_Update","2024-05-08T15:28:37","PCP0234"
 "P_Rec_Update","2024-05-09T11:10:46","PCP0334"
 "P_Rec_Update","2024-05-10T13:11:24","PCP0334"
 "P_Rec_Update","2024-05-13T07:52:54","PCP0234"
 "P_Rec_Update","2024-05-13T08:10:26","PCP0234"
 "P_Rec_Update","2024-05-14T07:48:08","PCP0316"
 "P_Rec_Update","2024-05-14T10:03:12","PCP0346"
 "P_Rec_Update","2024-05-14T13:27:45","PCP0312"
 "P_Rec_Update","2024-05-14T13:45:36","PCP0245"
 "P_Rec_Update","2024-05-14T14:28:05","PCP0332"
 "P_Rec_Update","2024-05-14T15:26:11","PCP0245"
 "P_Rec_Update","2024-05-14T15:34:06","PCP0312"
 "P_Rec_Update","2024-05-14T16:18:44","PCP0215"
 "P_Rec_Update","2024-05-14T17:04:04","PCP0245"
 "P_Rec_Update","2024-05-15T09:45:47","PCP0245"
 "P_Rec_Update","2024-05-15T10:29:08","PCP0234"
 "P_Rec_Update","2024-05-15T11:39:16","PCP0234"
 "P_Rec_Update","2024-05-15T14:01:20","PCP0346"
 "P_Rec_Update","2024-05-15T14:44:17","PCP0215"
 "P_Rec_Update","2024-05-15T15:02:52","PCP0245"
 "P_Rec_Update","2024-05-15T18:21:48","PCP0316"
 "P_Rec_Update","2024-05-16T08:49:42","PCP0346"
 "P_Rec_Update","2024-05-16T11:54:08","PHPVM05"
 "P_Rec_Update","2024-05-16T12:01:40","PHPVM05"
 "P_Rec_Update","2024-05-16T13:44:52","PHPVM05"
 "P_Rec_Update","2024-05-16T15:47:38","PCP0316"
 "P_Rec_Update","2024-05-16T15:55:09","PCP0234"
 "P_Rec_Update","2024-05-17T09:20:39","PCP0316"
 "P_Rec_Update","2024-05-17T09:46:31","PCP0346"
 "P_Rec_Update","2024-05-17T09:58:09","PCP0234"
 "P_Rec_Update","2024-05-17T10:00:37","PCP0234"
 "P_Rec_Update","2024-05-17T10:06:14","PHPVM05"
 "P_Rec_Update","2024-05-17T10:56:50","PCP0316"
 "P_Rec_Update","2024-05-17T12:46:41","PCP0312"
 "P_Rec_Update","2024-05-17T15:15:18","PCP0312"
 "P_Rec_Update","2024-05-19T11:23:30","PCP0334"
 "P_Rec_Update","2024-05-20T09:15:30","PCP0316"
 "P_Rec_Update","2024-05-20T10:20:16","PCP0316"
 "P_Rec_Update","2024-05-20T11:08:50","PCP0312"
 "P_Rec_Update","2024-05-20T13:24:36","PCP0234"
 "P_Rec_Update","2024-05-21T08:37:29","PCP0245"
 "P_Rec_Update","2024-05-21T09:21:55","PCP0234"
 "P_Rec_Update","2024-05-21T09:46:01","PCP0234"
 "P_Rec_Update","2024-05-21T10:31:09","PHPVM05"
 "P_Rec_Update","2024-05-21T11:22:00","PHPVM05"
 "P_Rec_Update","2024-05-21T18:33:36","PCP0316"
 "P_Rec_Update","2024-05-22T15:18:11","PCP0245"
 "P_Rec_Update","2024-05-23T09:50:28","PCP0232"
 "P_Rec_Update","2024-05-24T08:32:03","PCP0312"
 "P_Rec_Update","2024-05-27T09:06:31","PCP0316"
 "P_Rec_Update","2024-05-27T09:15:48","PCP0316"
 "P_Rec_Update","2024-05-27T09:50:50","PCP0234"
 "P_Rec_Update","2024-05-27T10:18:48","PCP0214"
 "P_Rec_Update","2024-05-27T10:25:03","PCP0243"
 "P_Rec_Update","2024-05-27T10:26:20","PCP0243"
 "P_Rec_Update","2024-05-27T10:27:12","PCP0243"
 "P_Rec_Update","2024-05-27T10:32:55","PCP0243"
 "P_Rec_Update","2024-05-27T10:34:25","PCP0243"
 "P_Rec_Update","2024-05-27T11:00:05","PCP0243"
 "P_Rec_Update","2024-05-27T11:41:50","PCP0243"
 "P_Rec_Update","2024-05-27T11:43:11","PCP0234"
 "P_Rec_Update","2024-05-27T11:48:13","PCP0243"
 "P_Rec_Update","2024-05-27T11:48:42","PCP0243"
 "P_Rec_Update","2024-05-27T11:53:12","PCP0243"
 "P_Rec_Update","2024-05-27T13:20:11","PCP0332"
 "P_Rec_Update","2024-05-27T13:25:29","PCP0243"
 "P_Rec_Update","2024-05-27T13:27:16","PCP0243"
 "P_Rec_Update","2024-05-27T13:29:25","PCP0234"
 "P_Rec_Update","2024-05-27T13:47:17","PCP0243"
 "P_Rec_Update","2024-05-28T06:51:16","PCP0214"
 "P_Rec_Update","2024-05-28T06:52:10","PCP0214"
 "P_Rec_Update","2024-05-28T08:26:37","PCP0243"
 "P_Rec_Update","2024-05-28T08:57:20","PCP0332"
 "P_Rec_Update","2024-05-28T11:11:08","PCP0346"
 "P_Rec_Update","2024-05-28T13:16:48","PCP0332"
 "P_Rec_Update","2024-05-28T14:29:16","PCP0316"
 "P_Rec_Update","2024-05-28T15:28:49","PCP0346"
 "P_Rec_Update","2024-05-29T08:36:49","PCP0346"
 "P_Rec_Update","2024-05-29T14:48:46","PCP0214"
 "P_Rec_Update","2024-05-29T15:19:40","PCP0332"
 "P_Rec_Update","2024-05-29T15:52:35","PCP0316"
 "P_Rec_Update","2024-05-29T15:53:32","PCP0316"
 "P_Rec_Update","2024-05-30T09:49:07","PCP0332"
 "P_Rec_Update","2024-05-30T15:15:01","PCP0316"
 "P_Rec_Update","2024-05-30T17:23:25","PCP0316"
 "P_Rec_Update","2024-05-31T03:42:04","PCP0214"
 "P_Rec_Update","2024-05-31T08:05:44","PCP0334"
 "P_Rec_Update","2024-05-31T14:26:43","PCP0332"
 "P_Rec_Update","2024-05-31T14:30:31","PCP0245"
 "P_Rec_Update","2024-05-31T15:13:13","PCP0332"
 "P_Rec_Update","2024-05-31T16:08:41","PCP0316"
 "P_Rec_Update","2024-06-01T18:57:09","PCP0214"
 "P_Rec_Update","2024-06-01T18:58:56","PCP0214"
 "P_Rec_Update","2024-06-02T07:55:19","PCP0214"
 "P_Rec_Update","2024-06-02T07:56:21","PCP0214"
 "P_Rec_Update","2024-06-02T08:04:11","PCP0214"
 "P_Rec_Update","2024-06-02T08:14:45","PCP0214"
 "P_Rec_Update","2024-06-02T08:23:39","PCP0214"
 "P_Rec_Update","2024-06-02T08:26:18","PCP0214"
 "P_Rec_Update","2024-06-02T08:30:43","PCP0214"
 "P_Rec_Update","2024-06-02T08:34:37","PCP0214"
 "P_Rec_Update","2024-06-02T16:22:03","PCP0214"
 "P_Rec_Update","2024-06-02T16:22:37","PCP0214"
 "P_Rec_Update","2024-06-02T16:43:03","PCP0214"
 "P_Rec_Update","2024-06-05T03:53:09","PCP0214"
 "P_Rec_Update","2024-06-05T11:31:08","PCP0234"
 "P_Rec_Update","2024-06-05T11:54:13","PCP0234"
 "P_Rec_Update","2024-06-05T11:57:13","PCP0234"
 "P_Rec_Update","2024-06-05T12:55:02","PCP0234"
 "P_Rec_Update","2024-06-05T13:02:52","PCP0234"
 "P_Rec_Update","2024-06-05T13:09:50","PCP0234"
 "P_Rec_Update","2024-06-05T13:15:38","PCP0234"
 "P_Rec_Update","2024-06-05T13:29:41","PCP0234"
 "P_Rec_Update","2024-06-05T13:45:38","PCP0234"
 "P_Rec_Update","2024-06-05T14:34:49","PCP0234"
 "P_Rec_Update","2024-06-05T15:07:59","PCP0234"
 "P_Rec_Update","2024-06-05T15:15:06","PCP0234"
 "P_Rec_Update","2024-06-05T15:41:55","PCP0234"
 "P_Rec_Update","2024-06-06T08:32:48","PCP0234"
 "P_Rec_Update","2024-06-06T08:41:49","PCP0234"
 "P_Rec_Update","2024-06-06T10:21:40","PCP0312"
 "P_Rec_Update","2024-06-06T11:45:58","PCP0234"
 "P_Rec_Update","2024-06-06T11:52:39","PCP0312"
 "P_Rec_Update","2024-06-06T12:39:33","PCP0214"
 "P_Rec_Update","2024-06-06T13:13:47","PCP0234"
 "P_Rec_Update","2024-06-06T16:08:26","PCP0234"
 "P_Rec_Update","2024-06-06T16:44:44","PCP0234"
 "P_Rec_Update","2024-06-07T10:58:00","PCP0156"
 "P_Rec_Update","2024-06-07T11:18:42","PCP0241"
 "P_Rec_Update","2024-06-07T11:20:12","PCP0241"
 "P_Rec_Update","2024-06-07T11:21:02","PCP0241"
 "P_Rec_Update","2024-06-07T14:48:41","PCP0241"
 "P_Rec_Update","2024-06-08T09:06:08","PCP0334"
 "P_Rec_Update","2024-06-08T09:25:25","PCP0334"
 "P_Rec_Update","2024-06-11T03:46:55","PCP0214"
 "P_Rec_Update","2024-06-11T08:08:48","PCP0214"
 "P_Rec_Update","2024-06-11T08:39:02","PCP0312"
 "P_Rec_Update","2024-06-11T08:39:24","PCP0312"
 "P_Rec_Update","2024-06-11T08:52:12","PCP0312"
 "P_Rec_Update","2024-06-11T08:58:35","PCP0312"
 "P_Rec_Update","2024-06-11T10:19:30","PCP0312"
 "P_Rec_Update","2024-06-11T11:49:48","PCP0214"
 "P_Rec_Update","2024-06-11T15:29:04","PCP0312"
 "P_Rec_Update","2024-06-12T11:32:55","PCP0214"
 "P_Rec_Update","2024-06-12T16:05:30","PCP0245"
 "P_Rec_Update","2024-06-13T03:52:21","PCP0214"
 "P_Rec_Update","2024-06-13T04:14:59","PCP0214"
 "P_Rec_Update","2024-06-13T09:20:25","PCP0245"
 "P_Rec_Update","2024-06-13T09:42:23","PCP0312"
 "P_Rec_Update","2024-06-13T11:31:37","PCP0346"
 "P_Rec_Update","2024-06-13T11:35:18","PCP0346"
 "P_Rec_Update","2024-06-13T11:37:46","PCP0346"
 "P_Rec_Update","2024-06-13T13:57:33","PCP0245"
 "P_Rec_Update","2024-06-13T15:22:51","PCP0312"
 "P_Rec_Update","2024-06-14T08:24:35","PCP0331"
 "P_Rec_Update","2024-06-14T10:16:04","PCP0243"
 "P_Rec_Update","2024-06-14T10:17:39","PCP0245"
 "P_Rec_Update","2024-06-14T13:21:59","PCP0245"
 "P_Rec_Update","2024-06-14T13:22:18","PCP0243"
 "P_Rec_Update","2024-06-14T13:22:57","PCP0243"
 "P_Rec_Update","2024-06-14T13:23:16","PCP0243"
 "P_Rec_Update","2024-06-14T13:24:02","PCP0245"
 "P_Rec_Update","2024-06-14T13:24:09","PCP0245"
 "P_Rec_Update","2024-06-14T13:27:26","PCP0245"
 "P_Rec_Update","2024-06-14T13:27:44","PCP0243"
 "P_Rec_Update","2024-06-14T13:35:05","PCP0243"
 "P_Rec_Update","2024-06-14T13:39:00","PCP0243"
 "P_Rec_Update","2024-06-14T13:42:11","PCP0243"
 "P_Rec_Update","2024-06-14T13:44:29","PCP0243"
 "P_Rec_Update","2024-06-14T13:45:59","PCP0243"
 "P_Rec_Update","2024-06-14T15:19:56","PCP0346"
 "P_Rec_Update","2024-06-14T15:23:10","PCP0243"
 "P_Rec_Update","2024-06-17T08:19:54","PCP0346"
 "P_Rec_Update","2024-06-17T08:21:10","PCP0346"
 "P_Rec_Update","2024-06-17T08:47:40","PCP0214"
 "P_Rec_Update","2024-06-17T14:21:00","PCP0245"
 "P_Rec_Update","2024-06-18T09:29:00","PCP0245"
 "P_Rec_Update","2024-06-18T09:29:29","PCP0245"
 "P_Rec_Update","2024-06-18T10:32:04","PCP0332"
 "P_Rec_Update","2024-06-18T11:14:49","PCP0234"
 "P_Rec_Update","2024-06-18T12:50:03","PCP0245"
 "P_Rec_Update","2024-06-18T14:32:25","PCP0234"
 "P_Rec_Update","2024-06-18T16:10:30","PCP0346"
 "P_Rec_Update","2024-06-19T08:54:07","PCP0234"
 "P_Rec_Update","2024-06-19T08:57:21","PCP0234"
 "P_Rec_Update","2024-06-19T09:08:28","PCP0346"
 "P_Rec_Update","2024-06-19T11:25:56","PCP0346"
 "P_Rec_Update","2024-06-19T14:01:19","PCP0208"
 "P_Rec_Update","2024-06-19T15:17:01","PCP0316"
 "P_Rec_Update","2024-06-19T19:00:08","PCP0208"
 "P_Rec_Update","2024-06-20T10:52:58","PCP0346"
 "P_Rec_Update","2024-06-20T13:15:03","PCP0214"
 "P_Rec_Update","2024-06-20T13:49:00","PCP0214"
 "P_Rec_Update","2024-06-20T23:16:40","PCP0208"
 "P_Rec_Update","2024-06-21T11:35:15","PCP0316"
 "P_Rec_Update","2024-06-21T13:11:14","PCP0208"
 "P_Rec_Update","2024-06-21T15:08:55","PCP0208"
 "P_Rec_Update","2024-06-26T13:05:10","PCP0346"
 "P_Rec_Update","2024-06-26T14:08:25","PCP0346"
 "P_Rec_Update","2024-06-26T14:11:10","PCP0232"
 "P_Rec_Update","2024-06-26T14:37:01","PCP0232"
 "P_Rec_Update","2024-06-26T15:35:51","PCP0232"
 "P_Rec_Update","2024-06-27T09:38:21","PCP0345"
 "P_Rec_Update","2024-06-28T09:10:41","PCP0346"
 "P_Rec_Update","2024-07-01T14:21:40","PCP0312"
 "P_Rec_Update","2024-07-02T14:59:11","PCP0245"
 "P_Rec_Update","2024-07-03T15:41:54","PCP0332"
 "P_Rec_Update","2024-07-03T16:34:54","PCP0332"
 "P_Rec_Update","2024-07-03T16:35:03","PCP0332"
 "P_Rec_Update","2024-07-03T17:11:38","PCP0312"
 "P_Rec_Update","2024-07-04T09:21:29","PCP0245"
 "P_Rec_Update","2024-07-04T11:22:59","PCP0245"
 "P_Rec_Update","2024-07-04T15:25:03","PCP0245"
 "P_Rec_Update","2024-07-08T16:20:34","PCP0245"
 "P_Rec_Update","2024-07-08T16:51:24","PCP0245"
 "P_Rec_Update","2024-07-09T09:12:53","PCP0245"
 "P_Rec_Update","2024-07-09T11:08:04","PCP0245"
 "P_Rec_Update","2024-07-09T12:51:22","PCP0245"
 "P_Rec_Update","2024-07-09T13:10:35","PCP0245"
 "P_Rec_Update","2024-07-11T05:06:53","PCP0214"
 "P_Rec_Update","2024-07-11T10:32:28","PCP0214"
 "P_Rec_Update","2024-07-11T10:40:04","PCP0245"
 "P_Rec_Update","2024-07-11T10:54:44","PCP0346"
 "P_Rec_Update","2024-07-11T11:24:28","PCP0214"
 "P_Rec_Update","2024-07-11T13:55:35","PCP0214"
 "P_Rec_Update","2024-07-12T10:03:12","PCP0214"
 "P_Rec_Update","2024-07-12T10:23:44","PCP0214"
 "P_Rec_Update","2024-07-12T10:26:25","PCP0346"
 "P_Rec_Update","2024-07-12T10:32:08","PCP0214"
 "P_Rec_Update","2024-07-12T10:32:41","PCP0346"
 "P_Rec_Update","2024-07-12T10:51:56","PCP0346"
 "P_Rec_Update","2024-07-12T13:01:21","PCP0346"
 "P_Rec_Update","2024-07-12T13:09:03","PCP0234"
 "P_Rec_Update","2024-07-12T13:50:04","PCP0346"
 "P_Rec_Update","2024-07-15T14:05:42","PCP0312"
 "P_Rec_Update","2024-07-15T14:17:24","PCP0316"
 "P_Rec_Update","2024-07-15T14:39:46","PCP0346"
 "P_Rec_Update","2024-07-15T14:40:27","PCP0346"
 "P_Rec_Update","2024-07-15T16:08:07","PCP0316"
 "P_Rec_Update","2024-07-15T16:10:18","PCP0316"
 "P_Rec_Update","2024-07-15T16:11:14","PCP0316"
 "P_Rec_Update","2024-07-16T10:03:24","PCP0346"
 "P_Rec_Update","2024-07-16T10:33:39","PCP0346"
 "P_Rec_Update","2024-07-16T12:56:26","PCP0346"
 "P_Rec_Update","2024-07-16T14:48:11","PCP0234"
 "P_Rec_Update","2024-07-17T12:06:56","PCP0245"
 "P_Rec_Update","2024-07-17T12:58:41","PCP0312"
 "P_Rec_Update","2024-07-17T13:00:34","PCP0312"
 "P_Rec_Update","2024-07-17T13:26:53","PCP0208"
 "P_Rec_Update","2024-07-17T13:47:54","PCP0234"
 "P_Rec_Update","2024-07-17T17:27:06","PCP0234"
 "P_Rec_Update","2024-07-18T08:02:45","PCP0234"
 "P_Rec_Update","2024-07-18T08:08:48","PCP0346"
 "P_Rec_Update","2024-07-18T09:47:34","PCP0245"
 "P_Rec_Update","2024-07-18T15:26:17","PCP0245"
 "P_Rec_Update","2024-07-18T16:19:49","PCP0312"
 "P_Rec_Update","2024-07-19T09:24:28","PCP0241"
 "P_Rec_Update","2024-07-19T11:29:49","PCP0331"
 "P_Rec_Update","2024-07-22T08:52:12","PCP0245"
 "P_Rec_Update","2024-07-22T08:56:46","PCP0245"
 "P_Rec_Update","2024-07-22T08:57:06","PCP0245"
 "P_Rec_Update","2024-07-22T09:38:36","PCP0241"
 "P_Rec_Update","2024-07-22T12:14:15","PCP0245"
 "P_Rec_Update","2024-07-22T13:48:18","PCP0346"
 "P_Rec_Update","2024-07-22T16:09:39","PCP0245"
 "P_Rec_Update","2024-07-23T08:52:57","PCP0346"
 "P_Rec_Update","2024-07-25T08:45:27","PCP0214"
 "P_Rec_Update","2024-07-25T14:04:56","PCP0245"
 "P_Rec_Update","2024-07-25T15:58:37","PCP0334"
 "P_Rec_Update","2024-07-25T16:02:40","PCP0343"
 "P_Rec_Update","2024-07-26T08:46:01","PCP0332"
 "P_Rec_Update","2024-07-26T12:31:10","PCP0258"
 "P_Rec_Update","2024-07-26T12:37:14","PCP0258"
 "P_Rec_Update","2024-07-26T13:02:26","PCP0258"
 "P_Rec_Update","2024-07-26T13:16:26","PCP0258"
 "P_Rec_Update","2024-07-26T13:20:02","PCP0258"
 "P_Rec_Update","2024-07-26T13:56:18","PCP0208"
 "P_Rec_Update","2024-07-26T14:56:09","PCP0208"
 "P_Rec_Update","2024-07-26T15:58:51","PCP0334"
 "P_Rec_Update","2024-07-26T16:00:50","PCP0334"
 "P_Rec_Update","2024-07-29T10:57:14","PCP0346"
 "P_Rec_Update","2024-07-29T11:09:32","PCP0214"
 "P_Rec_Update","2024-07-29T11:39:04","PCP0258"
 "P_Rec_Update","2024-07-29T12:21:56","PCP0208"
 "P_Rec_Update","2024-07-30T07:44:53","PCP0346"
 "P_Rec_Update","2024-07-30T13:07:00","PCP0258"
 "P_Rec_Update","2024-07-30T13:16:17","PCP0258"
 "P_Rec_Update","2024-07-31T11:25:22","PCP0258"
 "P_Rec_Update","2024-07-31T16:19:56","PCP0346"
 "P_Rec_Update","2024-07-31T18:20:08","PCP0334"
 "P_Rec_Update","2024-07-31T18:23:48","PCP0334"
 "P_Rec_Update","2024-08-01T10:20:56","PCP0343"
 "P_Rec_Update","2024-08-01T10:22:18","PCP0343"
 "P_Rec_Update","2024-08-01T10:38:11","PCP0343"
 "P_Rec_Update","2024-08-01T13:10:05","PCP0343"
 "P_Rec_Update","2024-08-02T10:45:35","PCP0245"
 "P_Rec_Update","2024-08-02T10:53:31","PCP0346"
 "P_Rec_Update","2024-08-05T06:15:25","PCP0214"
 "P_Rec_Update","2024-08-05T06:58:00","PCP0214"
 "P_Rec_Update","2024-08-05T08:34:12","PCP0346"
 "P_Rec_Update","2024-08-05T09:51:00","PCP0214"
 "P_Rec_Update","2024-08-05T12:54:28","PCP0334"
 "P_Rec_Update","2024-08-05T12:57:33","PCP0334"
 "P_Rec_Update","2024-08-05T17:12:39","PCP0232"
 "P_Rec_Update","2024-08-05T19:25:39","PCP0232"
 "P_Rec_Update","2024-08-05T19:25:58","PCP0232"
 "P_Rec_Update","2024-08-05T19:29:38","PCP0205"
 "P_Rec_Update","2024-08-05T19:57:34","PCP0232"
 "P_Rec_Update","2024-08-06T10:35:24","PCP0343"
 "P_Rec_Update","2024-08-06T12:40:23","PCP0214"
 "P_Rec_Update","2024-08-06T13:20:17","PCP0208"
 "P_Rec_Update","2024-08-06T14:01:17","PCP0208"
 "P_Rec_Update","2024-08-06T17:37:26","PCP0334"
 "P_Rec_Update","2024-08-08T13:21:18","PCP0258"
 "P_Rec_Update","2024-08-08T21:18:39","PCP0208"
 "P_Rec_Update","2024-08-08T21:55:36","PCP0208"
 "P_Rec_Update","2024-08-08T21:55:54","PCP0208"
 "P_Rec_Update","2024-08-09T09:20:34","PCP0258"
 "P_Rec_Update","2024-08-12T11:52:07","PCP0343"
 "P_Rec_Update","2024-08-12T11:53:31","PCP0234"
 "P_Rec_Update","2024-08-12T12:54:46","PCP0343"
 "P_Rec_Update","2024-08-13T09:21:00","PCP0218"
 "P_Rec_Update","2024-08-13T09:36:39","PCP0218"
 "P_Rec_Update","2024-08-13T11:01:28","PCP0218"
 "P_Rec_Update","2024-08-13T11:45:25","PCP0245"
 "P_Rec_Update","2024-08-30T10:56:47","PCP0234"
 "P_Rec_Update","2024-09-06T10:52:05","PCP0332"
 "P_Rec_Update","2024-09-06T13:04:59","PCP0332"
 "P_Rec_Update","2024-09-06T14:32:24","PHPVM05"
 "P_Rec_Update","2024-09-12T13:41:10","PCP0332"
 "P_Rec_Update","2024-09-14T14:40:26","PCP0218"
 "P_Rec_Update","2024-09-14T15:25:20","PCP0218"
 "P_Rec_Update","2024-09-14T15:36:12","PCP0218"
 "P_Rec_Update","2024-09-16T14:36:41","PHPVM05"
 "P_Rec_Update","2024-09-17T09:45:05","PCP0218"
 "P_Rec_Update","2024-09-17T10:14:03","PCP0218"
 "P_Rec_Update","2024-09-18T12:55:16","PCP0218"
 "P_Rec_Update","2024-09-18T13:50:41","PCP0218"
 "P_Rec_Update","2024-09-18T16:27:19","PCP0218"
 "P_Rec_Update","2024-09-18T20:31:11","PCP0241"
 "P_Rec_Update","2024-09-19T07:39:51","PCP0218"
 "P_Rec_Update","2024-09-19T07:57:19","PCP0241"
 "P_Rec_Update","2024-09-19T13:16:16","PCP0218"
 "P_Rec_Update","2024-09-19T13:27:29","PCP0218"
 "P_Rec_Update","2024-09-19T14:05:56","PCP0218"
 "P_Rec_Update","2024-09-19T14:20:37","PCP0218"
 "P_Rec_Update","2024-09-19T15:29:58","PCP0218"
 "P_Rec_Update","2024-09-19T15:45:30","PCP0218"
 "P_Rec_Update","2024-09-19T15:49:35","PCP0218"
 "P_Rec_Update","2024-09-20T14:28:20","PCP0331"
 "P_Rec_Update","2024-09-20T14:34:14","PCP0331"
 "P_Rec_Update","2024-09-23T07:38:58","PCP0218"
 "P_Rec_Update","2024-09-23T07:43:01","PCP0218"
 "P_Rec_Update","2024-09-23T07:45:29","PCP0218"
 "P_Rec_Update","2024-09-23T08:05:05","PCP0218"
 "P_Rec_Update","2024-09-23T08:43:47","PCP0218"
 "P_Rec_Update","2024-09-23T16:20:38","PCP0316"
 "P_Rec_Update","2024-09-25T15:55:27","PCP0316"
 "P_Rec_Update","2024-09-26T08:19:46","PCP0316"
 "P_Rec_Update","2024-09-26T10:53:22","PCP0316"
 "P_Rec_Update","2024-09-26T15:03:37","PCP0316"
 "P_Rec_Update","2024-09-26T15:34:02","PCP0316"
 "P_Rec_Update","2024-09-26T15:37:04","PCP0316"
 "P_Rec_Update","2024-09-30T14:55:13","PCP0218"
 "P_Rec_Update","2024-10-07T08:19:28","PCP0331"
 "P_Rec_Update","2024-10-07T08:21:10","PCP0331"
 "P_Rec_Update","2024-10-15T08:04:44","PCP0356"
 "P_Rec_Update","2024-10-15T08:31:31","PCP0356"
 "P_Rec_Update","2024-10-15T08:40:26","PCP0356"
 "P_Rec_Update","2024-10-15T09:06:23","PCP0356"
 "P_Rec_Update","2024-10-15T09:50:03","PCP0356"
 "P_Rec_Update","2024-10-15T10:00:17","PCP0356"
 "P_Rec_Update","2024-10-15T10:06:55","PCP0356"
 "P_Rec_Update","2024-10-15T10:47:09","PCP0356"
 "P_Rec_Update","2024-10-15T10:59:57","PCP0356"
 "P_Rec_Update","2024-10-15T11:06:06","PCP0356"
 "P_Rec_Update","2024-10-15T11:08:03","PCP0356"
 "P_Rec_Update","2024-10-15T11:14:54","PCP0356"
 "P_Rec_Update","2024-10-15T11:17:40","PCP0356"
 "P_Rec_Update","2024-10-15T11:21:01","PCP0356"
 "P_Rec_Update","2024-10-15T11:25:48","PCP0356"
 "P_Rec_Update","2024-10-29T10:05:12","PCP0345"
 "P_Rec_Update","2024-10-30T11:23:48","PCP0356"
 "P_Rec_Update","2024-10-31T14:13:24","PCP0238"
 "P_Rec_Update","2024-10-31T16:39:04","PCP0238"
 "P_Rec_Update","2024-11-02T14:00:02","PCP0356"
 "P_Rec_Update","2024-11-05T15:53:36","PCP0356"
 "P3DDeleteNewLineInValues","2024-01-30T15:48:15","PCP0243"
 "P3DDeleteNewLineInValues","2024-01-30T15:48:22","PCP0243"
 "P3DDeleteNewLineInValues","2024-01-30T15:52:12","PCP0243"
 "P3DDeleteNewLineInValues","2024-01-30T15:52:18","PCP0243"
 "P3DDeleteNewLineInValues","2024-01-30T15:52:34","PCP0243"
 "P3DDeleteNewLineInValues","2024-01-30T15:52:40","PCP0243"
 "P3DDeleteNewLineInValues","2024-01-30T15:52:46","PCP0243"
@@ -0,0 +1,3 @@
 "plugin_name","unique_launches","unique_computers","first_launch_timestamp","last_launch_timestamp"
 "P_Rec_Update","660","24","2024-01-30T15:46:23","2024-11-05T15:53:36"
 "P3DDeleteNewLineInValues","7","1","2024-01-30T15:48:15","2024-01-30T15:52:46"
@@ -0,0 +1,33 @@
 # Plant3D usage from XLSX
 Source is read-only. Only Plant3D sheets are analyzed; other sheets are ignored.
 XLSX files: 151
 Temporary XLSX ignored: 0
 Files with Plant3D: 148
 Files without Plant3D: 3
 Files parsed: 148
 Files failed: 0
 Candidate rows examined: 16713
 Unique events: 0
 Duplicates: 0
 Rejected rows: 16716
 Date range:
 Unique plugins: 0
 Unique computers: 0
 Most used plugin:
 Most active computer:
 Source modified: NO
 The Plant3D tables contain plugin and date fields but no computer-name column. The user field was not substituted for computer and was not published. Rows without a computer are rejected with COMPUTER_NOT_FOUND.
 Top plugins:
 - нет валидных событий
 Top computers:
 - нет валидных событий
 Repeat:
 ./tools/plugin-usage/Build-Plant3DExcelUsageMatrix.ps1 -SourceRoot C:/dev/TEMP/CheckPlugin -SheetName Plant3D -OutputDirectory ./migration/audits/plugin-usage-plant3d-xlsx-20260731
 SourceFile values are anonymized as source-0001.xlsx. Project numbers, names, users and paths are not stored.
@@ -0,0 +1 @@
 ComputerName,ComputerNameNormalized,TotalLaunches,UniquePlugins,FirstLaunch,LastLaunch,ActiveDays,MostUsedPlugin,MostUsedPluginLaunches
@@ -0,0 +1 @@
 Plugin
@@ -0,0 +1 @@
 Plugin,TotalLaunches,Computers,FirstLaunch,LastLaunch
@@ -0,0 +1 @@
 PluginName,PluginNameNormalized,TotalLaunches,ComputerCount,FirstLaunch,LastLaunch,ActiveDays,ActiveMonths,MostActiveComputer,MostActiveComputerLaunches,ShareOfAllLaunches
@@ -0,0 +1 @@
 EventId,PluginName,PluginNameNormalized,LaunchDateTime,LaunchDate,LaunchMonth,ComputerName,ComputerNameNormalized,SourceFile,SourceSheet,SourceRow,ParseRule,DuplicateCount
@@ -0,0 +1,152 @@
 "SourceFile","HasPlant3DSheet","ActualSheetName","RowCount","ColumnCount","Headers","SHA256","ParseResult","RejectedRows"
 "source-0001.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","A15A619FCBD036043644B235D1B5116C019838A42091CA6A451CD82DFCC41749","PARSED","1"
 "source-0002.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","A5B3F1451F88798417B3621F6BC6690BC0B1BA94E8F69B75BB4C6CB961B29BFB","PARSED","1"
 "source-0003.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","1DAA47089E28D62C9DF05541266ECEF512AACF87248BDA4576F42346EA6BE543","PARSED","1"
 "source-0004.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","B5AA0708B2C97B8F6AA13E4DA09C9FC4B205BB2A44D6A6993E7DB0ED26F9CEA5","PARSED","1"
 "source-0005.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","310124BF67ED7185513C834FBF3BC96A0AB243CF5114A41E2F78CE383D04F15F","PARSED","1"
 "source-0006.xlsx","False","","0","0","","484B6D563FFC782565DE9FE7AFBA18406017627D192CA2C3789EF8CEA63E20CE","SHEET_NOT_FOUND","1"
 "source-0007.xlsx","False","","0","0","","E5C9642AEA336BB0040B2FA290AAFD723AB6CE6F04519C5A003AAB927270F6C3","SHEET_NOT_FOUND","1"
 "source-0008.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","0323A416C468D838726E5792D887A7F9A381B2A1C13C65A340C57D472CCD8441","PARSED","1"
 "source-0009.xlsx","True","Plant3D","6","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","3CE17A1F2C385F2D3E8FC288D4342026FA329894C2FFD292521A94F8ECEC5FE8","PARSED","5"
 "source-0010.xlsx","True","Plant3D","414","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","A28C34A53E3D3342A20E013F1C8ECB0535369386C8A384F72DC2FB8A8EE22028","PARSED","413"
 "source-0011.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","F1B81195DA589C392940461EFFB4241A1531B1DA70BFC547896366AB94626473","PARSED","1"
 "source-0012.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","2C3506BA50204A3E8A1E42E0B466587103F80C8F8BEE692F27ED1FD2A7977E43","PARSED","1"
 "source-0013.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","BF74975CF82BB0CEB2CE6BF005A679BE2514D33A9E7F145DFCF91ED261A875B6","PARSED","1"
 "source-0014.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","7D2AE6636424016E60AF73B6826F4D9992A0A20356593C7D5D1034E3EBA47173","PARSED","1"
 "source-0015.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","D60671EADF93813991C84959F6C3E9CFEEB60F8F44522A6DB27FE64C0CCD8B7A","PARSED","1"
 "source-0016.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","A2B3F6E746DF732AA7FF721BCEE5A4C44442FC74851AE8ECA112B19D87671774","PARSED","1"
 "source-0017.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","B9430EC9C2BD7E6231F1A27390F63241111844956B6A32C01FADA6E8C0CB33AA","PARSED","1"
 "source-0018.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","1945DBF7EDD39F7F66605465E72C61FD405A1196D66DEA146E49D04DB8C2BF39","PARSED","1"
 "source-0019.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","1432526CC6D04A23B0AFFD7F0D7758D95CBC801ECC80CC868100A9849B8DFA05","PARSED","1"
 "source-0020.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","EF46F7969E767613029508068B0389A70F78B7781DEB1B1D5B57A55368CE14BF","PARSED","1"
 "source-0021.xlsx","True","Plant3D","1","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","2661112A136177954233F1D2AAD0ADA66DFBF0F8BC4FDF7845DF8B4C4604F431","PARSED","0"
 "source-0022.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","32637F9E79E4DD99E894B0920945135A3CB17A140A82596E1D02C9309F73FC39","PARSED","1"
 "source-0023.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","9E4660630442D118F09FCB11DBE975E25433197A8A5DFB12CC612C153E0F725E","PARSED","1"
 "source-0024.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","2BBF8C9E52E7B98ACE642BB19D16F3E3CC2F376E39A05E53BF992FF9050B8A1E","PARSED","1"
 "source-0025.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","A1325DC1797468286A02EDE3733DF8219B254E916154D31F34F4B461B6D2BC80","PARSED","1"
 "source-0026.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","FB1E886E31C2FB3D52CA0DBBD9E74CD091938B57E7C6F6FCF4966A7FE704392C","PARSED","1"
 "source-0027.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","C4FEC6A05FB2720D6C4341B8735C85900A8AA15805C5CE245E551C5FFA4EEBF8","PARSED","1"
 "source-0028.xlsx","True","Plant3D","56","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","66B28C7AB727BE7F77491313B75FB62F498C39500DE1CFB41C54A78EB184DFA1","PARSED","55"
 "source-0029.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","5F8D42AD0580CFD7F4CB407B45A1B7E4D4F26D9A04A2ADF7DDA7028499BD2146","PARSED","1"
 "source-0030.xlsx","True","Plant3D","90","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","F512D38F97E6848FFA80D30D226E8E79B6422AE96096D3B137A8D18D9C7283DD","PARSED","89"
 "source-0031.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","670D5DA7859B4FAE24EB4F5929939786865CD2B32C7FE829B8C553A74AAF82F8","PARSED","1"
 "source-0032.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","F08A03A625EBE9807A89BDD9357C92A1475AE7F19A5A3B488B3E8D7356A0D981","PARSED","1"
 "source-0033.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","0532B42C2AB5F10B2900A137D8C72745DACDE4EDF8C9612628E07CD388C9FC92","PARSED","1"
 "source-0034.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","205F5F22C7E7DD5C9F04B9CA730BC3E79A23A561E280838C62AC4B79741462D5","PARSED","1"
 "source-0035.xlsx","True","Plant3D","252","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","7A93BB9B4F04A534D1ABE7B36118288A5B6BA799E829B75B73C8DECAAD78D22C","PARSED","251"
 "source-0036.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","AB6211135C2391355AEB089B4893A2485869B94D9D4AFFE73936ED59C458676D","PARSED","1"
 "source-0037.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","08EFD4B8B47E13F5F7F1621B884EE7D75CA060C28F7D6521C0D5BC4EABC79A32","PARSED","1"
 "source-0038.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","514E2773029F9D5F827A3CDE7EC28F1F466C98ACBAABD65729FE69CE586DE0A8","PARSED","1"
 "source-0039.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","C199078B83D9FE0D78DF631A1534B6308CE801E4CE1AB61404BE33F039C728F6","PARSED","1"
 "source-0040.xlsx","True","Plant3D","3","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","C7BF9E922FF6813037E20C4AFF1B37FA6CEFB275F628BC15E5CFAC8DF374F89E","PARSED","2"
 "source-0041.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","BE31C9D8AC380F283989D5BA048ECB803111AB9599B8E2698834B5B4891E623C","PARSED","1"
 "source-0042.xlsx","True","Plant3D","586","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","2865FF71486B4BD98B0B6B30D92E05F21E483DC71C52C7D77C00760D889CDDB4","PARSED","585"
 "source-0043.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","3F73CDB5FB6F42172E1D23AC7B63EAB3764E8A97A6000B7D3678F896CBDD58BF","PARSED","1"
 "source-0044.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","FDD351196C3D124CCA31AFDBEF582DCBFE76C88E4119CF3601BB7D1D0B9EAAFE","PARSED","1"
 "source-0045.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","7DA92F660D6F73EC0333B4E637819DB88ADC6E40A7D2E2E9D780D1E7851D4025","PARSED","1"
 "source-0046.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","EF3485449D9F5CEF104B14FE4D16BFDC3A27199C6117732D15CFC994F361F32F","PARSED","1"
 "source-0047.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","170D835A968A0590ACEA2909AE9DD204A8A7B2B01FD4254FBFD30F7216B2D4C4","PARSED","1"
 "source-0048.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","AAC46741C97CA9D5DBBADA8815D0D894F99F37F1CF6CD0FF6E2D1F090D3AD920","PARSED","1"
 "source-0049.xlsx","True","Plant3D","734","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","F49CD86C04D7CFDA8F1FE0FB6131F9F28A86916A6C9012D54B116E9F272C8ABE","PARSED","733"
 "source-0050.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","A024F33FD3CD408C7FC62C59D6511F2FB8CA257DF5872A3C793875AD700F0623","PARSED","1"
 "source-0051.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","63FC0734C4B58165B3C53E06320ACC86A8D9B11F1B71EE4796071E462C291794","PARSED","1"
 "source-0052.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","170D835A968A0590ACEA2909AE9DD204A8A7B2B01FD4254FBFD30F7216B2D4C4","PARSED","1"
 "source-0053.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","86AF67FAC7778F3EAEBF51BCF0C643387CCBFADA9020D48B0C0B7403E52E45C4","PARSED","1"
 "source-0054.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","76EDCFF3616F370F7EBAF4917EB430B9C606DCAC88B2782A11511B725ED30E84","PARSED","1"
 "source-0055.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","1C1116CDE1D4D33F5B5C03710999EB74D546E9FD21780DF4F8BFA51F7683FFD1","PARSED","1"
 "source-0056.xlsx","True","Plant3D","25","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","CBAA90125E90F981FC9C9E7C1866C4D7A4AC80020D02B939E3010BA76D5889A5","PARSED","24"
 "source-0057.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","F50FF129D9F408BD431DC7D9997F675037E3822ED0A2F3EEDDDC37D2E783A2C2","PARSED","1"
 "source-0058.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","6B378A5C23A90C23762B9257C36E5DFC6357A7A924E8A435BFA97CD438E94B66","PARSED","1"
 "source-0059.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","E4736511A4CE16692ADCF5DF17C006A0CA6BD10E135DFFC4770EA1CCA1FB9EF0","PARSED","1"
 "source-0060.xlsx","True","Plant3D","895","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","DCE700252D4065DF7A03B22FED55E36D75B468DA6207439E968DAEFDB05270F8","PARSED","894"
 "source-0061.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","F1221EBEAA1FAEFFCCC41A921F55378B1E301806DE862A71A30EC101B37A74E9","PARSED","1"
 "source-0062.xlsx","True","Plant3D","460","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","7727E99AC47171CDA1F590B2E6380BC96F7DED676AA335637CE1436612B52D56","PARSED","459"
 "source-0063.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","CA8F71B9B2ECF4B27B7B581E3E4BA770873B1E73EEEFEB538ED441C5C8757A0B","PARSED","1"
 "source-0064.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","C7A1E4C8CB9CB27D05C62D89133A40665F791484431B192A73F59B8F9A6DB29E","PARSED","1"
 "source-0065.xlsx","True","Plant3D","237","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","89A2AD33216311E5982DE7D311A4B7BBA5F9120B74B3F45EE480512BDACA650B","PARSED","236"
 "source-0066.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","AAEA49E5B294B77A9C1ABD2530E84BCE3B5814CEAA8D43638D921D03ADB0B3D7","PARSED","1"
 "source-0067.xlsx","True","Plant3D","117","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","23AD7BE9E3CD38A6141171BC7848CA024AD9DDEA1613719781F8E4F0A695A4EB","PARSED","116"
 "source-0068.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","ADE70DE40D2ECBBDF6C92CAFAC598A4E79FB1EF4B42B7FD29B86358EDFB882FB","PARSED","1"
 "source-0069.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","9F995F5F40ABAD9FA72913BD8CD66D4D94252A247ABA1B6AAF1F618C02CC8807","PARSED","1"
 "source-0070.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","954F040E98D6D0AB8DA5E3D9226C2F2DDC1320CFA25FA84355346406E89A5562","PARSED","1"
 "source-0071.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","861D3B078EE1520FAC14F8BAB765C804DA233545B46C548EACC0894FED45CECF","PARSED","1"
 "source-0072.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","7CC2D143DCDA82A368F478D246086934AE20BC21B8EBCD19B17488D6A1B5C9DA","PARSED","1"
 "source-0073.xlsx","True","Plant3D","1","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","658B087B7CDB15130678A5F58E4FA1B1FA5688457FA2FA03DFA7A218D3EA0CCC","PARSED","0"
 "source-0074.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","D8039752750039DD7A8DA647C21087A12944F4ACDCD636D27BD8624D86375125","PARSED","1"
 "source-0075.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","CC9C45987C6DA9646FC4FD771F8D8B6C2F3F466C609203C2AAE31C1AD79C595B","PARSED","1"
 "source-0076.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","9FE880A33CA691260B76A025145339D1757B8295942323DC1A24020B9D2E1BE1","PARSED","1"
 "source-0077.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","69233E373BA94FF1D0F5BEBAE67880BD34BA873992875344E1458254B64B9E8A","PARSED","1"
 "source-0078.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","D7C5B3583FA52CF6D4DDB4B8D673BE12ECFA7C18C40CED86679D691E3D6E32B6","PARSED","1"
 "source-0079.xlsx","True","Plant3D","697","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","EFD4FC75BDED4E45A774945511D527F71433C58EC86C4F20275AC2D97CE7AAA1","PARSED","696"
 "source-0080.xlsx","True","Plant3D","287","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","222E65CCAB8CA101B3DA836BB2D87FBC77A46B309066270A5A13D48C5FDC8E00","PARSED","286"
 "source-0081.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","35044B7D3E03E7C67E7C04AA532E307522226A4CE7D50A51107B4CC2B7AE3117","PARSED","1"
 "source-0082.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","BF54E9EC75A0716BC4AD71E310AC8558E3EA7FF4FF1AE7616FB6C546F3D05D75","PARSED","1"
 "source-0083.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","C2D6E13731016E523F582D065480F385E3D8EFC9379C6CB20A8FEC288330BD33","PARSED","1"
 "source-0084.xlsx","True","Plant3D","1860","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","ED0BC02534ECB9636BE0C2268926942C8DEB9ADDC75823CF6A1E241E188E96DF","PARSED","1859"
 "source-0085.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","30B54423173405FB2179C2F0C1532DEF28A292A7E3249C5483CED353F692691A","PARSED","1"
 "source-0086.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","BE7148B01F6BF466650D93ED1A1CFF736AFC5DF43567FA4D62C319ED0739863B","PARSED","1"
 "source-0087.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","27EA9A83CEDB02328F8E99D914CAB7EC9325313458D36678FC14994F028A7C66","PARSED","1"
 "source-0088.xlsx","True","Plant3D","152","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","35C2F37E1453CC52B85BFAA335695931D469844C660CDBE8356FF60FA5EDC094","PARSED","151"
 "source-0089.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","FF6B2808D71FD697AC2AD83400152E258EE428FF50CF00D22915AE70CA4F2D19","PARSED","1"
 "source-0090.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","4C5AB590CDC6F764326B8DCE845E0DBFB51C9A8710DCA65671173A06B1F4C8BE","PARSED","1"
 "source-0091.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","9A68D1C2B05E2A1AE7DC08F56A203F12094064DC90CF4A753E6B024944058953","PARSED","1"
 "source-0092.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","AA4CF707135416550D390D59275F4EF96597CA413553ED998BAD249266C1BB0C","PARSED","1"
 "source-0093.xlsx","True","Plant3D","60","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","6E9634C35B174D2CA2BF67E7E5D5A5D322E8E33366231D419927335D67118158","PARSED","59"
 "source-0094.xlsx","True","Plant3D","810","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","7826F33C15EA6164E46A9BB762DDA073ED113B918F81E3BFF9BACBD4F9E9862A","PARSED","809"
 "source-0095.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","4FE1B8234D58BB533E118659489AD5497E17EC58C935FB467B78FE00AE868782","PARSED","1"
 "source-0096.xlsx","True","Plant3D","3","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","AC2B780B38BBF7B0BDFC6F3134633536A4A64DB3A2C71F010079A99ABC698EBF","PARSED","2"
 "source-0097.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","FF6A99D2F4042CDEDC0D8AB2863FCA5B74128D9CD39A6FF42E4DCA3CFC8CF62B","PARSED","1"
 "source-0098.xlsx","True","Plant3D","91","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","CFDF4380ABFF2899C15963155D1AC991CFDC2E0F6F5615191DC983F7CE8E3708","PARSED","90"
 "source-0099.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","ACF37ECD1F508F39F352C3112113F6214741032F642012233F7C0EB71D57FAE3","PARSED","1"
 "source-0100.xlsx","True","Plant3D","1039","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","BE19C25F151B4525E0058F7C974B250AFEC651585F71A2B0BC9A28C6D2639521","PARSED","1038"
 "source-0101.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","5F8D42AD0580CFD7F4CB407B45A1B7E4D4F26D9A04A2ADF7DDA7028499BD2146","PARSED","1"
 "source-0102.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","219ACB4310303A5EE9E5A825998AF9012AD80F597F693B730583ACEC5856B935","PARSED","1"
 "source-0103.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","96074CB9DECE06172FD88185CF379830582046A83C7405AD7B41D7F6196BD0C0","PARSED","1"
 "source-0104.xlsx","True","Plant3D","74","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","16D424D7B51535AFF74B02F1FAA113E35A501E7A5C6E991382853FAB0F14AB02","PARSED","73"
 "source-0105.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","2BD63E06782C45CAF3A77C301F980ABE6421C098E549DDD639918894987CFD4B","PARSED","1"
 "source-0106.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","23F20D79B82DA3BE0E979AB55939B308F5CE35264C687A13FAF0B0EFA31912C9","PARSED","1"
 "source-0107.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","1843EDAF7DBFB71036D62B9C80DBC256199969EF64B1881E9E5A051B1EADEDD5","PARSED","1"
 "source-0108.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","BE04A1D538CB18E1F909E0F0F911AC7D8DE0C614FD107E5F9209E843F2AE1311","PARSED","1"
 "source-0109.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","205F5F22C7E7DD5C9F04B9CA730BC3E79A23A561E280838C62AC4B79741462D5","PARSED","1"
 "source-0110.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","1A04C1D1FEC0D6DE24AE5B59A303FAC8617D6DCB7C79BA61F493797E249F6BE7","PARSED","1"
 "source-0111.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","69D6ECE741A1CE49B9188F9191F04DD49B8FB1D36AE79492D302DAF8BC55DE0D","PARSED","1"
 "source-0112.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","67E4B2F304BD98BC953742C319AD9FDC60E1DDF809317D264AB92B5DD496D153","PARSED","1"
 "source-0113.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","5207B2F0DC0DB9C5399A32A1505310665180EC74D6A26015475986DCBF379563","PARSED","1"
 "source-0114.xlsx","True","Plant3D","107","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","BB0EA311890606D735E090E3CC009275EE1EA0430A861A36E1B5B887619FB9BB","PARSED","106"
 "source-0115.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","90AF2345A620F5735BA47A7B0A6355CF1FC6ACD508DD566123B20F7FD3E40BCF","PARSED","1"
 "source-0116.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","B5B54A5399281FE2F6439D499496EF27B110BBB1DE8008428F80BD5E3FE9B6E7","PARSED","1"
 "source-0117.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","777C7A38D2F97998426FB4E6A39AA7C4ADA7343D48C00427DEA58FBA915B3D67","PARSED","1"
 "source-0118.xlsx","True","Plant3D","3","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","AC66A34DA4BA02E8452B1CA0CDCFF381AA7F56C2ECF206C6D3E39DC49DFD8B86","PARSED","2"
 "source-0119.xlsx","True","Plant3D","703","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","630481E3722EF0E4F271C812FCB686BFEC679EC2A90B1CE60929FA178276B746","PARSED","702"
 "source-0120.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","217E8F2CE5C0E50FFECDFDC69C99629EFF86F8F1C5820B804472CCBB96C83693","PARSED","1"
 "source-0121.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","606068897D6B8B66ABABDF0F123679A46864CCD8D3D8F7A64C5DB8242B910AA7","PARSED","1"
 "source-0122.xlsx","False","","0","0","","775B72ABA7A5F3277F857C4431A9795192451621DDDA9E568952EE5FC4B818E2","SHEET_NOT_FOUND","1"
 "source-0123.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","77C0DBDA49BCF2A61E1E8661FE56069B13F5CD76372B60CCBCB4FED4D9FCC300","PARSED","1"
 "source-0124.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","11E3CB994067C2944C72783818094A3B0070E9B20F16E65E4DF5EEC4BC7D4BEF","PARSED","1"
 "source-0125.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","A8D15E45344B4F9914F28EB471C74B90F4C8AB09F588C5932ADEC6A69EF3A1F1","PARSED","1"
 "source-0126.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","973258780339702C9EAF6E67B69C8835B5585E00D21764598B619A8490EF6334","PARSED","1"
 "source-0127.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","B276743CAB8202E42B5E6578DCFD33FAC968CC809EF258D3D083D1858D42FF9A","PARSED","1"
 "source-0128.xlsx","True","Plant3D","3128","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","88200AC6044F16B2B18F5448F6B4BC5BAF6E1F9EE5446E1FD30EB321AC2B8BDC","PARSED","3127"
 "source-0129.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","78A70F71CF77C11855ADA80A805FAD5F04FF8B5D55516FC6565C1FB86E46D4D5","PARSED","1"
 "source-0130.xlsx","True","Plant3D","65","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","D934BC7DB6C68A6458FFFE801C61B622BDCB10979CCB3B22431867A346DF3559","PARSED","64"
 "source-0131.xlsx","True","Plant3D","1027","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","E0192943F2454E18F72092D794D3E73A55536B7757269638BAD922BBF7E58DCF","PARSED","1026"
 "source-0132.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","10EB6F3BB853E29C25D5C7781F7DBE32AB66DEFCF74F33A0E041326DB3E058C1","PARSED","1"
 "source-0133.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","013EBC9D96D0A2330A708C04C715A97830337DF0E85A13A46B9CEB46B641A662","PARSED","1"
 "source-0134.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","480B287CB70F44135B538D406934BC84D48A9907EAC15BCDBE566606F9459814","PARSED","1"
 "source-0135.xlsx","True","Plant3D","1970","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","6213EE80A8303E74E0C5D8D0706F4BF18BA8C66CF7D521269D83342DC129456C","PARSED","1969"
 "source-0136.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","F2351A9EE055766BA23389341EDE4F646EF93A6F4EC5D643FABDC938D6856741","PARSED","1"
 "source-0137.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","7BF721DA2ACE12EEBEAE8B810BB36E1609A716312D57123AB8DE5E3AB88A2C67","PARSED","1"
 "source-0138.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","B5EFA1E2A03AD1E58DE3A8BD8E654DAE2D6D3BEE25ABD83A1F2DAAA7D1ACBBA0","PARSED","1"
 "source-0139.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","D01E5620808DC870F30C7A2F8FBB142989BC64B47ACA75C33EB8891261210D61","PARSED","1"
 "source-0140.xlsx","True","Plant3D","499","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","1E4BA218B03A56523525B6B62FCFA2381CC6C142018426EFB8BC12FD8B5B248E","PARSED","498"
 "source-0141.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","B39C734C901C75D4E297A7F1044068B28FA2459A2ECD3518BB9FE4B325052344","PARSED","1"
 "source-0142.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","A69931EA29521E1AB9CE9EEFAD29E07687B57A6B35CBC0023FD8CEAB706BF2AA","PARSED","1"
 "source-0143.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","6BF892D6DB59C80850AD3FD316CBC6B6BAAB93AD54D1B7273C525C26141405EE","PARSED","1"
 "source-0144.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","4940E6C9CBB4C3B8D327F463A3EADA1FEBD622E8065D038D97364CA99D1D2D7F","PARSED","1"
 "source-0145.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","106F64274F9146D16FC5915A19FE112C287CB91FBE1F466C25D535746A3398AE","PARSED","1"
 "source-0146.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","EFF26E58F20FCEE544B341129C608788C6A3D96C1BDCD22AF34B6D10BE220492","PARSED","1"
 "source-0147.xlsx","True","Plant3D","181","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","55846ECDE3A730B781564A2059D3DAC56536EC3AAEF69B09BB07178AC8720212","PARSED","180"
 "source-0148.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","94278E1422D937D2C6D365036C35732C5D9C24BF70AB51ED78606668D848AB9D","PARSED","1"
 "source-0149.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","85B5D8D2537326FA82CFCBA6158AE0F852E0FB7DA4D342C1507CEC4F233D9681","PARSED","1"
 "source-0150.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","CF4DB120F80B11598077A842CD458703C2938D010C773D5A5C6E41AE707950C3","PARSED","1"
 "source-0151.xlsx","True","Plant3D","2","6","Файл;Пользователь;Плагин;Дата;Количество запусков;Номер проекта","F6DE7BCCBCC3B6B4CEC6FA81F0C5F17DE7E0725E8AE7BF6384798429C431A38D","PARSED","1"
@@ -0,0 +1,19 @@
 {
    "XlsxFilesFound":  151,
    "TemporaryXlsxIgnored":  0,
    "FilesWithPlant3DSheet":  148,
    "FilesWithoutPlant3DSheet":  3,
    "FilesParsed":  148,
    "FilesFailed":  0,
    "RawRows":  16713,
    "ValidRows":  0,
    "UniqueEvents":  0,
    "Duplicates":  0,
    "RejectedRows":  16716,
    "DateRange":  "",
    "UniquePlugins":  0,
    "UniqueComputers":  0,
    "MostUsedPlugin":  "",
    "MostActiveComputer":  "",
    "SourceModified":  "NO"
 }
@@ -0,0 +1,65 @@
 param(
    [string]$Source = 'C:\dev\TEMP\Reports',
    [string]$Output = 'C:\dev\autodesk\migration\audits\plugin-usage-matrix-20260731'
 )
 $ErrorActionPreference = 'Stop'
 $utf8 = New-Object System.Text.UTF8Encoding($false)
 $outputEvidence = Join-Path $Output 'evidence'
 New-Item -ItemType Directory -Force -Path $outputEvidence | Out-Null
 # The source is read only. Only the three fields captured below are emitted.
 $pattern = '^.*?\s+(?<plugin>\S+)\s+(?<internal_code>\S+)\s+(?<time>\d{2}:\d{2}:\d{2})\s+(?<date>\d{2}\.\d{2}\.\d{2,4})\s+(?<computer>\S+)\s*$'
 $records = [System.Collections.Generic.List[object]]::new()
 $fileCount = 0
 $lineCount = 0
 $blankCount = 0
 $unmatchedCount = 0
 foreach ($file in (Get-ChildItem -LiteralPath $Source -Recurse -File | Sort-Object FullName)) {
    $fileCount++
    foreach ($line in Get-Content -LiteralPath $file.FullName -Encoding UTF8) {
        $text = $line.Trim()
        if ([string]::IsNullOrWhiteSpace($text)) { $blankCount++; continue }
        $lineCount++
        if ($text -notmatch $pattern) { $unmatchedCount++; continue }
        $dateText = $matches.date
        $format = if ($dateText.Length -eq 8) { 'dd.MM.yy' } else { 'dd.MM.yyyy' }
        $date = [DateTime]::ParseExact(($dateText + ' ' + $matches.time), ($format + ' HH:mm:ss'), [Globalization.CultureInfo]::InvariantCulture, [Globalization.DateTimeStyles]::None)
        $records.Add([pscustomobject]@{
            plugin_name = $matches.plugin
            launch_timestamp = $date.ToString('yyyy-MM-ddTHH:mm:ss', [Globalization.CultureInfo]::InvariantCulture)
            computer_name = $matches.computer
        })
    }
 }
 $unique = $records | Sort-Object plugin_name,launch_timestamp,computer_name -Unique
 $unique | Export-Csv (Join-Path $Output 'plugin-usage-matrix.csv') -NoTypeInformation -Encoding UTF8
 $summary = $unique | Group-Object plugin_name | Sort-Object Name | ForEach-Object {
    $items = $_.Group | Sort-Object launch_timestamp,computer_name
    [pscustomobject]@{
        plugin_name = $_.Name
        unique_launches = $items.Count
        unique_computers = ($items.computer_name | Sort-Object -Unique).Count
        first_launch_timestamp = $items[0].launch_timestamp
        last_launch_timestamp = $items[-1].launch_timestamp
    }
 }
 $summary | Export-Csv (Join-Path $Output 'plugin-usage-summary.csv') -NoTypeInformation -Encoding UTF8
 $diagnostics = @(
    'Input format: one record per non-empty line; only plugin, timestamp and computer fields are retained.',
    ('Input files: ' + $fileCount),
    ('Non-empty input records: ' + $lineCount),
    ('Blank input lines ignored: ' + $blankCount),
    ('Unmatched non-empty records: ' + $unmatchedCount),
    ('Parsed records: ' + $records.Count),
    ('Unique three-attribute records: ' + $unique.Count),
    ('Unique plugins: ' + (($unique.plugin_name | Sort-Object -Unique).Count)),
    ('Date normalization: dd.MM.yy and dd.MM.yyyy to yyyy-MM-ddTHH:mm:ss'),
    'Sort order: plugin_name, launch_timestamp, computer_name.',
    'Project numbers, project names, project paths and source log filenames are intentionally excluded.'
 )
 [IO.File]::WriteAllLines((Join-Path $outputEvidence 'parse-diagnostics.txt'), $diagnostics, $utf8)
@@ -0,0 +1,292 @@
 param(
    [Parameter(Mandatory=$false)][string]$SourceRoot = 'C:\dev\TEMP\CheckPlugin',
    [Parameter(Mandatory=$false)][string]$SheetName = 'Plant3D',
    [Parameter(Mandatory=$false)][string]$OutputDirectory = 'C:\dev\autodesk\migration\audits\plugin-usage-plant3d-xlsx-20260731'
 )
 $ErrorActionPreference = 'Stop'
 Add-Type -AssemblyName System.IO.Compression.FileSystem
 $utf8Bom = New-Object System.Text.UTF8Encoding($true)
 $utf8 = New-Object System.Text.UTF8Encoding($false)
 $nsMainUri = 'http://schemas.openxmlformats.org/spreadsheetml/2006/main'
 $nsRelUri = 'http://schemas.openxmlformats.org/officeDocument/2006/relationships'
 $nsPkgRelUri = 'http://schemas.openxmlformats.org/package/2006/relationships'
 $outputEvidence = Join-Path $OutputDirectory 'evidence'
 New-Item -ItemType Directory -Force -Path $outputEvidence | Out-Null
 function Get-XmlEntry([IO.Compression.ZipArchive]$Zip, [string]$Name) {
    $entry = $Zip.GetEntry($Name.TrimStart('/'))
    if ($null -eq $entry) { return $null }
    $reader = [IO.StreamReader]::new($entry.Open())
    try { return [xml]$reader.ReadToEnd() } finally { $reader.Dispose() }
 }
 function Get-ColumnNumber([string]$Reference) {
    $letters = ([regex]::Match($Reference, '^[A-Z]+')).Value
    $number = 0
    foreach ($letter in $letters.ToCharArray()) { $number = $number * 26 + ([int][char]$letter - 64) }
    return $number
 }
 function Normalize-Header([string]$Value) {
    if ($null -eq $Value) { return '' }
    return (($Value.Trim().ToLowerInvariant()) -replace '[\s_\-\.]+','')
 }
 function Normalize-Plugin([string]$Value) {
    $v = if ($null -eq $Value) { '' } else { $Value.Trim() }
    return (($v -replace '(?i)\.(dll|exe)$','').Trim().ToUpperInvariant())
 }
 function Normalize-Computer([string]$Value) {
    if ($null -eq $Value) { return '' }
    return $Value.Trim().ToUpperInvariant()
 }
 function Get-SharedStrings([IO.Compression.ZipArchive]$Zip) {
    $xml = Get-XmlEntry $Zip 'xl/sharedStrings.xml'
    $values = [System.Collections.Generic.List[string]]::new()
    if ($null -eq $xml) { return $values }
    $manager = New-Object Xml.XmlNamespaceManager($xml.NameTable)
    $manager.AddNamespace('m',$nsMainUri)
    foreach ($item in $xml.SelectNodes('//m:si',$manager)) { $values.Add((($item.SelectNodes('.//m:t',$manager) | ForEach-Object InnerText) -join '')) }
    return $values
 }
 function Get-CellText($Cell, $Manager, $SharedStrings) {
    if ($null -eq $Cell) { return '' }
    $inline = $Cell.SelectSingleNode('./m:is',$Manager)
    if ($null -ne $inline) { return (($inline.SelectNodes('.//m:t',$Manager) | ForEach-Object InnerText) -join '') }
    $value = $Cell.SelectSingleNode('./m:v',$Manager)
    if ($null -eq $value) { return '' }
    $raw = $value.InnerText
    if ([string]$Cell.t -eq 's') {
        $index = 0
        if ([int]::TryParse($raw,[ref]$index) -and $index -lt $SharedStrings.Count) { return $SharedStrings[$index] }
    }
    return $raw
 }
 function Get-DateValue([string]$Text, [bool]$Numeric, [int]$Style, $DateStyles) {
    if ([string]::IsNullOrWhiteSpace($Text)) { return $null }
    $dateLike = $false
    if ($Numeric -and $DateStyles.Contains($Style)) { $dateLike = $true }
    if ($dateLike) {
        $serial = 0.0
        if ([double]::TryParse($Text,[Globalization.NumberStyles]::Float,[Globalization.CultureInfo]::InvariantCulture,[ref]$serial)) {
            return [pscustomobject]@{ Date = [DateTime]::FromOADate($serial); Rule = 'EXCEL_SERIAL_DATE' }
        }
    }
    $clean = ($Text.Trim() -replace '[Tt]',' ' -replace '[\u00A0]',' ' -replace '\s+',' ')
    $formats = @('yyyy MM dd HH:mm:ss','yyyy MM dd H:mm:ss','yyyy MM dd','dd.MM.yyyy HH:mm:ss','dd.MM.yyyy H:mm:ss','dd.MM.yyyy','dd.MM.yy HH:mm:ss','dd.MM.yy H:mm:ss','dd.MM.yy','yyyy-MM-dd HH:mm:ss','yyyy-MM-dd','dd/MM/yyyy HH:mm:ss','dd/MM/yyyy')
    foreach ($format in $formats) {
        $parsed = [DateTime]::MinValue
        if ([DateTime]::TryParseExact($clean,$format,[Globalization.CultureInfo]::InvariantCulture,[Globalization.DateTimeStyles]::AllowWhiteSpaces,[ref]$parsed)) {
            $rule = if ($format -match 'H|s') { 'TEXT_DATETIME' } else { 'DATE_ONLY' }
            return [pscustomobject]@{ Date = $parsed; Rule = $rule }
        }
    }
    $parsed = [DateTime]::MinValue
    if ([DateTime]::TryParse($clean,[Globalization.CultureInfo]::GetCultureInfo('ru-RU'),[Globalization.DateTimeStyles]::AllowWhiteSpaces,[ref]$parsed)) {
        return [pscustomobject]@{ Date = $parsed; Rule = if ($clean -match ':') { 'TEXT_DATETIME' } else { 'DATE_ONLY' } }
    }
    return $null
 }
 function Get-DateStyles([IO.Compression.ZipArchive]$Zip) {
    $set = [Collections.Generic.HashSet[int]]::new()
    foreach ($i in 14..22) { [void]$set.Add($i) }
    $styles = Get-XmlEntry $Zip 'xl/styles.xml'
    if ($null -eq $styles) { return $set }
    $manager = New-Object Xml.XmlNamespaceManager($styles.NameTable); $manager.AddNamespace('m',$nsMainUri)
    $dateWords = 'yy|yyyy|mm|dd|hh|ss|am/pm'
    $formats = @{}
    foreach ($format in $styles.SelectNodes('//m:numFmts/m:numFmt',$manager)) { $formats[[int]$format.numFmtId] = [string]$format.formatCode }
    $index = 0
    foreach ($xf in $styles.SelectNodes('//m:cellXfs/m:xf',$manager)) {
        $id = [int]$xf.numFmtId
        if (($formats.ContainsKey($id) -and $formats[$id] -match $dateWords) -or ($id -ge 14 -and $id -le 22)) { [void]$set.Add($index) }
        $index++
    }
    return $set
 }
 function Get-WorkbookSheet($Zip, [string]$WantedName) {
    $workbook = Get-XmlEntry $Zip 'xl/workbook.xml'
    $relationships = Get-XmlEntry $Zip 'xl/_rels/workbook.xml.rels'
    if ($null -eq $workbook -or $null -eq $relationships) { throw 'READ_ERROR: workbook metadata is missing' }
    $manager = New-Object Xml.XmlNamespaceManager($workbook.NameTable); $manager.AddNamespace('m',$nsMainUri); $manager.AddNamespace('r',$nsRelUri)
    $relManager = New-Object Xml.XmlNamespaceManager($relationships.NameTable); $relManager.AddNamespace('p',$nsPkgRelUri)
    $wanted = $WantedName.Trim().ToLowerInvariant()
    foreach ($sheet in $workbook.SelectNodes('//m:sheets/m:sheet',$manager)) {
        if ([string]$sheet.name.Trim().ToLowerInvariant() -eq $wanted) {
            $id = $sheet.GetAttribute('id',$nsRelUri)
            $rel = $relationships.SelectSingleNode("//p:Relationship[@Id='$id']",$relManager)
            if ($null -eq $rel) { throw 'READ_ERROR: worksheet relationship is missing' }
            $target = ([string]$rel.Target).TrimStart('/')
            if ($target -notmatch '^xl/') { $target = 'xl/' + $target }
            return [pscustomobject]@{ Name = [string]$sheet.name; Target = $target }
        }
    }
    return $null
 }
 function Get-WorksheetRows($Zip, [string]$Target, $SharedStrings, $DateStyles) {
    $xml = Get-XmlEntry $Zip $Target
    if ($null -eq $xml) { throw 'READ_ERROR: worksheet is missing' }
    $manager = New-Object Xml.XmlNamespaceManager($xml.NameTable); $manager.AddNamespace('m',$nsMainUri)
    $rows = [System.Collections.Generic.List[object]]::new()
    foreach ($row in $xml.SelectNodes('//m:sheetData/m:row',$manager)) {
        $cells = @{}
        foreach ($cell in $row.SelectNodes('./m:c',$manager)) {
            $column = Get-ColumnNumber ([string]$cell.r)
            $raw = Get-CellText $cell $manager $SharedStrings
            $numeric = ([string]$cell.t -eq '' -or [string]$cell.t -eq 'n')
            $style = if ([string]$cell.s) { [int]$cell.s } else { 0 }
            $cells[$column] = [pscustomobject]@{ Text = $raw; Date = Get-DateValue $raw $numeric $style $DateStyles }
        }
        $rows.Add([pscustomobject]@{ Number = [int]$row.r; Hidden = ([string]$row.hidden -eq '1'); Cells = $cells })
    }
    return [pscustomobject]@{ Rows = $rows; ColumnCount = (($rows | ForEach-Object { if($_.Cells.Count){($_.Cells.Keys|Measure-Object -Maximum).Maximum}else{0} } | Measure-Object -Maximum).Maximum) }
 }
 function Get-Cell($Row,[int]$Column) { if($Row.Cells.ContainsKey($Column)){return $Row.Cells[$Column].Text}; return '' }
 function Find-Header($Rows) {
    $pluginAliases = @('плагин','названиеплагина','plugin','pluginname','module','command')
    $dateAliases = @('дата','время','датазапуска','датаивремя','date','time','datetime','timestamp','launchdate')
    $computerAliases = @('пк','компьютер','имяпк','computer','computername','machine','machinename','host','hostname')
    foreach($row in $Rows | Select-Object -First 30) {
        $map = @{}
        foreach($key in $row.Cells.Keys){$map[(Normalize-Header (Get-Cell $row $key))]=[int]$key}
        $plugin = ($pluginAliases | ? {$map.ContainsKey($_)} | Select -First 1)
        $date = ($dateAliases | ? {$map.ContainsKey($_)} | Select -First 1)
        $computer = ($computerAliases | ? {$map.ContainsKey($_)} | Select -First 1)
        if($plugin -and $date){return [pscustomobject]@{ Row = $row; PluginColumn = $map[$plugin]; DateColumn = $map[$date]; TimeColumn = if($map.ContainsKey('время')){$map['время']}elseif($map.ContainsKey('time')){$map['time']}else{$null}; ComputerColumn = if($computer){$map[$computer]}else{$null}; Rule='HEADER_ALIASES' }}
    }
    return $null
 }
 function Get-Sha256([string]$Path) { return (Get-FileHash -LiteralPath $Path -Algorithm SHA256).Hash }
 function Get-RowHash([string]$SourceId,[int]$Row,[string]$Plugin,[string]$Date,[string]$Computer) { $text = "$SourceId|$Row|$Plugin|$Date|$Computer"; $sha = [Security.Cryptography.SHA256]::Create(); try { return (([BitConverter]::ToString($sha.ComputeHash([Text.Encoding]::UTF8.GetBytes($text)))) -replace '-','') } finally { $sha.Dispose() } }
 function Csv([object[]]$Rows,[string]$Path) {
    if($null -eq $Rows){$Rows=@()}
    if($Rows.Count -gt 0){$Rows | Export-Csv -LiteralPath $Path -NoTypeInformation -Encoding UTF8; return}
    $headers = switch ([IO.Path]::GetFileName($Path)) {
        'plugin-usage-events.csv' { 'EventId,PluginName,PluginNameNormalized,LaunchDateTime,LaunchDate,LaunchMonth,ComputerName,ComputerNameNormalized,SourceFile,SourceSheet,SourceRow,ParseRule,DuplicateCount' }
        'plugin-summary.csv' { 'PluginName,PluginNameNormalized,TotalLaunches,ComputerCount,FirstLaunch,LastLaunch,ActiveDays,ActiveMonths,MostActiveComputer,MostActiveComputerLaunches,ShareOfAllLaunches' }
        'pc-summary.csv' { 'ComputerName,ComputerNameNormalized,TotalLaunches,UniquePlugins,FirstLaunch,LastLaunch,ActiveDays,MostUsedPlugin,MostUsedPluginLaunches' }
        'plugin-pc-matrix.csv' { 'Plugin,TotalLaunches,Computers,FirstLaunch,LastLaunch' }
        'plugin-month-matrix.csv' { 'Plugin' }
        'rejected-records.csv' { 'SourceFile,SourceSheet,SourceRow,ReasonCode,DetectedPlugin,DetectedDateTime,DetectedComputer,RowHash' }
        'source-inventory.csv' { 'SourceFile,HasPlant3DSheet,ActualSheetName,RowCount,ColumnCount,Headers,SHA256,ParseResult,RejectedRows' }
    }
    [IO.File]::WriteAllText($Path, $headers + "`r`n", $utf8Bom)
 }
 $files = @(Get-ChildItem -LiteralPath $SourceRoot -Recurse -File -Filter '*.xlsx' | Where-Object Name -notlike '~$*' | Sort-Object FullName)
 $eventsRaw = [Collections.Generic.List[object]]::new(); $rejected = [Collections.Generic.List[object]]::new(); $inventory = [Collections.Generic.List[object]]::new(); $fileIndex=0; $rawRowsExamined=0; $temporaryIgnored = @(Get-ChildItem -LiteralPath $SourceRoot -Recurse -File -Filter '~$*.xlsx' -ErrorAction SilentlyContinue).Count
 foreach($file in $files) {
    $fileIndex++; $sourceId = ('source-{0:D4}.xlsx' -f $fileIndex); $beforeSize=$file.Length; $beforeTime=$file.LastWriteTimeUtc; $hash=Get-Sha256 $file.FullName
    $plant=$false; $sheetActual=''; $rowCount=0; $columnCount=0; $result='FAILED'; $rejectedBefore=$rejected.Count
    try {
        $zip=[IO.Compression.ZipFile]::OpenRead($file.FullName)
        try {
            $sheet=Get-WorkbookSheet $zip $SheetName
            if($null -eq $sheet) { $rejected.Add([pscustomobject]@{SourceFile=$sourceId;SourceSheet='';SourceRow='';ReasonCode='SHEET_NOT_FOUND';DetectedPlugin='';DetectedDateTime='';DetectedComputer='';RowHash=(Get-RowHash $sourceId 0 '' '' '')}); $inventory.Add([pscustomobject]@{SourceFile=$sourceId;HasPlant3DSheet=$false;ActualSheetName='';RowCount=0;ColumnCount=0;Headers='';SHA256=$hash;ParseResult='SHEET_NOT_FOUND';RejectedRows=1}); continue }
            $plant=$true; $sheetActual=$sheet.Name; $shared=Get-SharedStrings $zip; $dates=Get-DateStyles $zip; $worksheet=Get-WorksheetRows $zip $sheet.Target $shared $dates; $rowCount=$worksheet.Rows.Count; $columnCount=$worksheet.ColumnCount; $header=Find-Header $worksheet.Rows
            if($null -eq $header){$rejected.Add([pscustomobject]@{SourceFile=$sourceId;SourceSheet=$sheetActual;SourceRow='';ReasonCode='HEADER_NOT_FOUND';DetectedPlugin='';DetectedDateTime='';DetectedComputer='';RowHash=(Get-RowHash $sourceId 0 '' '' '')});continue}
            $headerText=(($header.Row.Cells.Keys|Sort-Object|ForEach-Object { Get-Cell $header.Row $_ }) -join ';')
            foreach($row in $worksheet.Rows | Where-Object Number -gt $header.Row.Number) {
                $plugin=(Get-Cell $row $header.PluginColumn).Trim(); $dateText=(Get-Cell $row $header.DateColumn).Trim(); $timeText=if($header.TimeColumn){(Get-Cell $row $header.TimeColumn).Trim()}else{''}; $computer=if($header.ComputerColumn){(Get-Cell $row $header.ComputerColumn).Trim()}else{''}; $dateInfo=$row.Cells[$header.DateColumn].Date
                if(!$plugin -and !$dateText -and !$computer){continue}
                $rawRowsExamined++
                $reason=''; if(!$plugin){$reason='PLUGIN_NOT_FOUND'} elseif(!$dateText){$reason='DATE_NOT_FOUND'} elseif($null -eq $dateInfo){$reason='INVALID_DATE'} elseif(!$computer){$reason='COMPUTER_NOT_FOUND'}
                if($reason){$rejected.Add([pscustomobject]@{SourceFile=$sourceId;SourceSheet=$sheetActual;SourceRow=$row.Number;ReasonCode=$reason;DetectedPlugin=$plugin;DetectedDateTime=($dateText+' '+$timeText).Trim();DetectedComputer=$computer;RowHash=(Get-RowHash $sourceId $row.Number $plugin $dateText $computer)});continue}
                $date=$dateInfo.Date; if($timeText){$timeInfo=Get-DateValue $timeText $false 0 $dates;if($null -ne $timeInfo){$date=$date.Date.Add($timeInfo.Date.TimeOfDay)}}
                $eventsRaw.Add([pscustomobject]@{PluginName=$plugin;PluginNameNormalized=(Normalize-Plugin $plugin);LaunchDateTime=$date.ToString('yyyy-MM-ddTHH:mm:ss');LaunchDate=$date.ToString('yyyy-MM-dd');LaunchMonth=$date.ToString('yyyy-MM');ComputerName=$computer;ComputerNameNormalized=(Normalize-Computer $computer);SourceFile=$sourceId;SourceSheet=$sheetActual;SourceRow=$row.Number;ParseRule=if($dateInfo.Rule -eq 'DATE_ONLY'){'DATE_ONLY'}else{'DATE_TIME'} })
            }
            $result='PARSED'
        } finally { $zip.Dispose() }
    } catch { $rejected.Add([pscustomobject]@{SourceFile=$sourceId;SourceSheet=$sheetActual;SourceRow='';ReasonCode='READ_ERROR';DetectedPlugin='';DetectedDateTime='';DetectedComputer='';RowHash=(Get-RowHash $sourceId 0 '' '' '')}) }
    $rejectedCount=$rejected.Count-$rejectedBefore; if($file.Length -ne $beforeSize -or $file.LastWriteTimeUtc -ne $beforeTime -or (Get-Sha256 $file.FullName) -ne $hash){throw "Source modified: $sourceId"}
    $inventory.Add([pscustomobject]@{SourceFile=$sourceId;HasPlant3DSheet=$plant;ActualSheetName=$sheetActual;RowCount=$rowCount;ColumnCount=$columnCount;Headers=$headerText;SHA256=$hash;ParseResult=$result;RejectedRows=$rejectedCount})
 }
 $grouped = $eventsRaw | Group-Object { if($_.ParseRule -eq 'DATE_ONLY'){"$($_.PluginNameNormalized)|$($_.LaunchDateTime)|$($_.ComputerNameNormalized)|$($_.SourceFile)|$($_.SourceRow)"}else{"$($_.PluginNameNormalized)|$($_.LaunchDateTime)|$($_.ComputerNameNormalized)"} } | Sort-Object Name
 $events=[Collections.Generic.List[object]]::new(); foreach($group in $grouped){$item=$group.Group|Sort-Object SourceFile,SourceRow|Select -First 1;$events.Add([pscustomobject]@{EventId=('EVT-{0:D6}' -f ($events.Count+1));PluginName=$item.PluginName;PluginNameNormalized=$item.PluginNameNormalized;LaunchDateTime=$item.LaunchDateTime;LaunchDate=$item.LaunchDate;LaunchMonth=$item.LaunchMonth;ComputerName=$item.ComputerName;ComputerNameNormalized=$item.ComputerNameNormalized;SourceFile=$item.SourceFile;SourceSheet=$item.SourceSheet;SourceRow=$item.SourceRow;ParseRule=$item.ParseRule;DuplicateCount=$group.Count})}
 $events=@($events|Sort-Object PluginNameNormalized,LaunchDateTime,ComputerNameNormalized,SourceFile,SourceRow)
 $pluginSummary=[Collections.Generic.List[object]]::new(); foreach($group in ($events|Group-Object PluginNameNormalized)){ $g=@($group.Group); $pc=$g|Group-Object ComputerNameNormalized|Sort-Object Count -Descending|Select-Object -First 1; $pluginSummary.Add([pscustomobject]@{PluginName=$g[0].PluginName;PluginNameNormalized=$group.Name;TotalLaunches=$g.Count;ComputerCount=($g.ComputerNameNormalized|Sort-Object -Unique).Count;FirstLaunch=($g.LaunchDateTime|Sort-Object|Select-Object -First 1);LastLaunch=($g.LaunchDateTime|Sort-Object|Select-Object -Last 1);ActiveDays=($g.LaunchDate|Sort-Object -Unique).Count;ActiveMonths=($g.LaunchMonth|Sort-Object -Unique).Count;MostActiveComputer=$pc.Name;MostActiveComputerLaunches=$pc.Count;ShareOfAllLaunches=if($events.Count){[math]::Round($g.Count/$events.Count,6)}else{0}}) }; $pluginSummary=@($pluginSummary|Sort-Object PluginName|Sort-Object TotalLaunches -Descending)
 $pcSummary=[Collections.Generic.List[object]]::new(); foreach($group in ($events|Group-Object ComputerNameNormalized)){ $g=@($group.Group); $plugin=$g|Group-Object PluginNameNormalized|Sort-Object Count -Descending|Select-Object -First 1; $pcSummary.Add([pscustomobject]@{ComputerName=$g[0].ComputerName;ComputerNameNormalized=$group.Name;TotalLaunches=$g.Count;UniquePlugins=($g.PluginNameNormalized|Sort-Object -Unique).Count;FirstLaunch=($g.LaunchDateTime|Sort-Object|Select-Object -First 1);LastLaunch=($g.LaunchDateTime|Sort-Object|Select-Object -Last 1);ActiveDays=($g.LaunchDate|Sort-Object -Unique).Count;MostUsedPlugin=$plugin.Name;MostUsedPluginLaunches=$plugin.Count}) }; $pcSummary=@($pcSummary|Sort-Object ComputerNameNormalized)
 $months=@($events.LaunchMonth|Sort -Unique); $plugins=@($events|Group PluginNameNormalized|Sort Name); $pluginPc=@(); foreach($p in $plugins){$r=[ordered]@{Plugin=$p.Group[0].PluginName;TotalLaunches=$p.Count;Computers=($p.Group.ComputerNameNormalized|Sort -Unique).Count;FirstLaunch=($p.Group.LaunchDateTime|Sort|Select -First 1);LastLaunch=($p.Group.LaunchDateTime|Sort|Select -Last 1)};foreach($pc in @($events.ComputerNameNormalized|Sort -Unique)){$r[$pc]=(@($p.Group|? ComputerNameNormalized -eq $pc)).Count};$pluginPc+=[pscustomobject]$r}
 $monthRows=@();foreach($p in $plugins){$r=[ordered]@{Plugin=$p.Group[0].PluginName};foreach($m in $months){$r[$m]=(@($p.Group|? LaunchMonth -eq $m)).Count};$monthRows+=[pscustomobject]$r}
 $eventView=@($events|%{[pscustomobject]@{Плагин=$_.PluginName;'Дата и время запуска'=$_.LaunchDateTime;Компьютер=$_.ComputerName;'Исходный XLSX'=$_.SourceFile;'Исходная строка'=$_.SourceRow}})
 Csv $events (Join-Path $OutputDirectory 'plugin-usage-events.csv'); Csv $pluginSummary (Join-Path $OutputDirectory 'plugin-summary.csv'); Csv $pcSummary (Join-Path $OutputDirectory 'pc-summary.csv'); Csv $pluginPc (Join-Path $OutputDirectory 'plugin-pc-matrix.csv'); Csv $monthRows (Join-Path $OutputDirectory 'plugin-month-matrix.csv'); Csv $rejected (Join-Path $OutputDirectory 'rejected-records.csv'); Csv $inventory (Join-Path $OutputDirectory 'source-inventory.csv')
 $summaryObj=[pscustomobject]@{XlsxFilesFound=$files.Count;TemporaryXlsxIgnored=$temporaryIgnored;FilesWithPlant3DSheet=($inventory|? HasPlant3DSheet).Count;FilesWithoutPlant3DSheet=($inventory|? {-not $_.HasPlant3DSheet}).Count;FilesParsed=($inventory|? ParseResult -eq 'PARSED').Count;FilesFailed=($inventory|? ParseResult -eq 'FAILED').Count;RawRows=$rawRowsExamined;ValidRows=$eventsRaw.Count;UniqueEvents=$events.Count;Duplicates=(($events|Measure DuplicateCount -Sum).Sum-$events.Count);RejectedRows=$rejected.Count;DateRange=if($events.Count){"$($events[0].LaunchDate) .. $($events[-1].LaunchDate)"}else{''};UniquePlugins=($events.PluginNameNormalized|Sort -Unique).Count;UniqueComputers=($events.ComputerNameNormalized|Sort -Unique).Count;MostUsedPlugin=if($pluginSummary.Count){$pluginSummary[0].PluginName}else{''};MostActiveComputer=if($pcSummary.Count){$pcSummary[0].ComputerName}else{''};SourceModified='NO'}
 [IO.File]::WriteAllText((Join-Path $OutputDirectory 'summary.json'),($summaryObj|ConvertTo-Json -Depth 4),$utf8)
 function XmlEscape([string]$Value){if($null -eq $Value){return ''};return [Security.SecurityElement]::Escape($Value)}
 function ExcelColumn([int]$N){$s='';while($N -gt 0){$N--; $s=([char](65+($N%26)))+$s;$N=[math]::Floor($N/26)};return $s}
 function SheetXml([object[]]$Rows){$sb=[Text.StringBuilder]::new();[void]$sb.Append('<worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><sheetData>');$r=1;foreach($row in $Rows){[void]$sb.Append(('<row r="'+$r+'">'));$c=1;foreach($prop in $row.PSObject.Properties){$v=XmlEscape ([string]$prop.Value);$ref=(ExcelColumn $c)+$r;[void]$sb.Append(('<c r="'+$ref+'" t="inlineStr"><is><t xml:space="preserve">'+$v+'</t></is></c>'));$c++};[void]$sb.Append('</row>');$r++};[void]$sb.Append('</sheetData></worksheet>');return $sb.ToString()}
 function Build-Workbook([string]$Path,[System.Collections.IDictionary]$Sheets){
    $fs=[IO.File]::Create($Path); $zip=[IO.Compression.ZipArchive]::new($fs,[IO.Compression.ZipArchiveMode]::Create)
    try {
        $types='<?xml version="1.0" encoding="UTF-8" standalone="yes"?><Types xmlns="http://schemas.openxmlformats.org/package/2006/content-types"><Default Extension="rels" ContentType="application/vnd.openxmlformats-package.relationships+xml"/><Default Extension="xml" ContentType="application/xml"/><Override PartName="/xl/workbook.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml"/>'
        for($i=1;$i -le $Sheets.Count;$i++){$types+=('<Override PartName="/xl/worksheets/sheet'+$i+'.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml"/>')}; $types+='</Types>'
        $root='<?xml version="1.0" encoding="UTF-8" standalone="yes"?><Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" Target="xl/workbook.xml"/></Relationships>'
        $work='<?xml version="1.0" encoding="UTF-8" standalone="yes"?><workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"><sheets>'
        $rels='<?xml version="1.0" encoding="UTF-8" standalone="yes"?><Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships">'
        $i=1; foreach($name in $Sheets.Keys){$work+=('<sheet name="'+(XmlEscape $name)+'" sheetId="'+$i+'" r:id="rId'+$i+'"/>');$rels+=('<Relationship Id="rId'+$i+'" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet" Target="worksheets/sheet'+$i+'.xml"/>');$i++}; $work+='</sheets></workbook>'; $rels+='</Relationships>'
        $entries=[ordered]@{'[Content_Types].xml'=$types;'_rels/.rels'=$root;'xl/workbook.xml'=$work;'xl/_rels/workbook.xml.rels'=$rels}; $i=1; foreach($name in $Sheets.Keys){$entries[('xl/worksheets/sheet'+$i+'.xml')]=SheetXml $Sheets[$name];$i++}
        foreach($item in $entries.GetEnumerator()){$entry=$zip.CreateEntry($item.Key);$entry.LastWriteTime=[DateTimeOffset]::new(2000,1,1,0,0,0,[TimeSpan]::Zero);$writer=[IO.StreamWriter]::new($entry.Open(),$utf8);try{$writer.Write($item.Value)}finally{$writer.Dispose()}}
    } finally {$zip.Dispose();$fs.Dispose()}
 }
 $summaryRows=@([pscustomobject]@{Плагин='Плагин';'Количество запусков'='Количество запусков';'Количество компьютеров'='Количество компьютеров';'Первый запуск'='Первый запуск';'Последний запуск'='Последний запуск';'Активных дней'='Активных дней';'Активных месяцев'='Активных месяцев';'Самый активный компьютер'='Самый активный компьютер';'Запусков на самом активном компьютере'='Запусков на самом активном компьютере';'Доля всех запусков'='Доля всех запусков'})+@($pluginSummary|%{[pscustomobject]@{Плагин=$_.PluginName;'Количество запусков'=$_.TotalLaunches;'Количество компьютеров'=$_.ComputerCount;'Первый запуск'=$_.FirstLaunch;'Последний запуск'=$_.LastLaunch;'Активных дней'=$_.ActiveDays;'Активных месяцев'=$_.ActiveMonths;'Самый активный компьютер'=$_.MostActiveComputer;'Запусков на самом активном компьютере'=$_.MostActiveComputerLaunches;'Доля всех запусков'=$_.ShareOfAllLaunches}})
 $pluginPcHeader=[ordered]@{Plugin='Плагин';TotalLaunches='Всего запусков';Computers='Компьютеров';FirstLaunch='Первый запуск';LastLaunch='Последний запуск'}; foreach($pc in @($events.ComputerNameNormalized|Sort-Object -Unique)){$pluginPcHeader[$pc]=$pc}; $pluginPcRows=@([pscustomobject]$pluginPcHeader)+@($pluginPc)
 $pcRows=@([pscustomobject]@{Компьютер='Компьютер';'Всего запусков'='Всего запусков';'Уникальных плагинов'='Уникальных плагинов';'Первый запуск'='Первый запуск';'Последний запуск'='Последний запуск';'Активных дней'='Активных дней';'Самый используемый плагин'='Самый используемый плагин';'Количество его запусков'='Количество его запусков'})+@($pcSummary|%{[pscustomobject]@{Компьютер=$_.ComputerName;'Всего запусков'=$_.TotalLaunches;'Уникальных плагинов'=$_.UniquePlugins;'Первый запуск'=$_.FirstLaunch;'Последний запуск'=$_.LastLaunch;'Активных дней'=$_.ActiveDays;'Самый используемый плагин'=$_.MostUsedPlugin;'Количество его запусков'=$_.MostUsedPluginLaunches}})
 $monthRowsFinal=@([pscustomobject]@{Плагин='Плагин'})+@($monthRows); $eventRowsFinal=@([pscustomobject]@{Плагин='Плагин';'Дата и время запуска'='Дата и время запуска';Компьютер='Компьютер';'Исходный XLSX'='Исходный XLSX';'Исходная строка'='Исходная строка'})+@($eventView)
 $finalSheets=[ordered]@{'Итог'=$summaryRows;'Плагин × ПК'=$pluginPcRows;'По компьютерам'=$pcRows;'По месяцам'=$monthRowsFinal;'События'=$eventRowsFinal}
 Build-Workbook (Join-Path $OutputDirectory 'plugin-usage-final.xlsx') $finalSheets
 $topPlugins=if($pluginSummary.Count){($pluginSummary|Select -First 20|%{"- $($_.PluginName): $($_.TotalLaunches)"}) -join "`n"}else{'- нет валидных событий'}
 $topComputers=if($pcSummary.Count){($pcSummary|Select -First 20|%{"- $($_.ComputerName): $($_.TotalLaunches)"}) -join "`n"}else{'- нет валидных событий'}
 $readme=@"
 # Plant3D usage from XLSX
 Source is read-only. Only Plant3D sheets are analyzed; other sheets are ignored.
 XLSX files: $($summaryObj.XlsxFilesFound)
 Temporary XLSX ignored: $($summaryObj.TemporaryXlsxIgnored)
 Files with Plant3D: $($summaryObj.FilesWithPlant3DSheet)
 Files without Plant3D: $($summaryObj.FilesWithoutPlant3DSheet)
 Files parsed: $($summaryObj.FilesParsed)
 Files failed: $($summaryObj.FilesFailed)
 Candidate rows examined: $($summaryObj.RawRows)
 Unique events: $($summaryObj.UniqueEvents)
 Duplicates: $($summaryObj.Duplicates)
 Rejected rows: $($summaryObj.RejectedRows)
 Date range: $($summaryObj.DateRange)
 Unique plugins: $($summaryObj.UniquePlugins)
 Unique computers: $($summaryObj.UniqueComputers)
 Most used plugin: $($summaryObj.MostUsedPlugin)
 Most active computer: $($summaryObj.MostActiveComputer)
 Source modified: NO
 The Plant3D tables contain plugin and date fields but no computer-name column. The user field was not substituted for computer and was not published. Rows without a computer are rejected with COMPUTER_NOT_FOUND.
 Top plugins:
 $topPlugins
 Top computers:
 $topComputers
 Repeat:
 ./tools/plugin-usage/Build-Plant3DExcelUsageMatrix.ps1 -SourceRoot C:/dev/TEMP/CheckPlugin -SheetName Plant3D -OutputDirectory ./migration/audits/plugin-usage-plant3d-xlsx-20260731
 SourceFile values are anonymized as source-0001.xlsx. Project numbers, names, users and paths are not stored.
 "@
 $readme=[regex]::Replace($readme,'(?m)[ \t]+$','')
 [IO.File]::WriteAllText((Join-Path $OutputDirectory 'README.md'),$readme,$utf8)
Author	SHA1	Message	Date
codex	6f29a5bce4	audit: parse Plant3D usage from Excel reports	2026-07-31 08:45:35 +03:00
codex	871499fa03	audit: build plugin usage matrix from logs	2026-07-31 08:00:19 +03:00
		`@@ -0,0 +1 @@`
							`ComputerName,ComputerNameNormalized,TotalLaunches,UniquePlugins,FirstLaunch,LastLaunch,ActiveDays,MostUsedPlugin,MostUsedPluginLaunches`
		`@@ -0,0 +1 @@`
							`Plugin,TotalLaunches,Computers,FirstLaunch,LastLaunch`
		`@@ -0,0 +1 @@`
							`PluginName,PluginNameNormalized,TotalLaunches,ComputerCount,FirstLaunch,LastLaunch,ActiveDays,ActiveMonths,MostActiveComputer,MostActiveComputerLaunches,ShareOfAllLaunches`
		`@@ -0,0 +1 @@`
							`EventId,PluginName,PluginNameNormalized,LaunchDateTime,LaunchDate,LaunchMonth,ComputerName,ComputerNameNormalized,SourceFile,SourceSheet,SourceRow,ParseRule,DuplicateCount`