Суммарное время, проведенное на kappa по вторникам (если время меньше 10 минут, то соответствующее поле оставлено пустым):
login | Mar 5 | Mar 12 | Mar 19 | Mar 26 | Apr 2 | Apr 9 | Apr 16 | Apr 23 | Apr 30 | May 7 | May 14 | May 21 | ananin | 01:34 | 05:47 | 01:52 | 01:37 | 02:23 | 00:51 | ----- | 02:40 | 02:46 | 04:48 | 00:23 | 00:47 | kirilich | 01:30 | ----- | ----- | ----- | 01:24 | 00:35 | 01:06 | 01:19 | ----- | ----- | 01:10 | ----- | marinin | 01:38 | 02:01 | 02:12 | 00:49 | 01:50 | 01:58 | 01:27 | 01:05 | 04:33 | 02:24 | 05:35 | 01:26 | otlivanc | 02:08 | 01:21 | 03:41 | ----- | 02:29 | 00:59 | 01:26 | 01:02 | 00:46 | 02:14 | 00:57 | 02:50 | pytko | 01:34 | 02:17 | 05:14 | 09:31 | 06:49 | 05:30 | 00:40 | 06:03 | 00:44 | 02:11 | 09:27 | 01:36 | solomato | 02:27 | 05:33 | 03:31 | 17:51 | 03:38 | 02:53 | 00:36 | 01:56 | ----- | ----- | 06:21 | 00:25 | surikov | 03:42 | 02:39 | 01:47 | 03:42 | 01:35 | 01:36 | 01:45 | 01:10 | 01:34 | 05:45 | 03:33 | 01:07 | kryshen | ----- | 00:55 | ----- | 01:33 | ----- | 02:12 | ----- | 02:50 | ----- | 04:43 | ----- | ----- | lazareva | ----- | 00:49 | 00:21 | 01:30 | 00:55 | 01:04 | ----- | 02:59 | 00:48 | 01:25 | 00:57 | 03:32 | rafalson | 00:36 | 01:02 | ----- | 00:41 | 01:33 | 01:31 | ----- | ----- | 00:31 | ----- | ----- | 00:27 | simakov | ----- | 01:30 | ----- | ----- | 01:27 | 01:35 | 00:14 | 05:38 | 00:12 | 00:32 | ----- | 01:12 | simanovi | ----- | 00:50 | ----- | 01:22 | 01:07 | 01:15 | ----- | 01:29 | ----- | 00:37 | ----- | 00:13 | gorinov | 01:37 | 02:27 | ----- | ----- | 00:59 | ----- | ----- | 01:17 | ----- | ----- | 01:33 | ----- | poikalai | ----- | ----- | ----- | ----- | 05:57 | ----- | 01:12 | ----- | ----- | ----- | ----- | ----- | radzhabo | 01:11 | ----- | ----- | ----- | 01:29 | ----- | ----- | ----- | ----- | ----- | 01:05 | ----- | belov | 01:27 | ----- | ----- | ----- | 01:33 | ----- | ----- | 00:52 | ----- | ----- | 01:36 | ----- | kuznecov | 01:34 | 00:17 | ----- | ----- | 01:26 | ----- | 00:26 | 01:19 | ----- | ----- | 01:31 | ----- | sarv | 01:24 | 00:51 | 01:24 | ----- | ----- | ----- | 00:18 | 02:57 | 01:13 | ----- | 01:20 | ----- | stepanov | 01:05 | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | chegesov | 01:03 | ----- | 01:04 | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ilin | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | voronov | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | 00:27 | ----- | ----- | ----- | shitov | ----- | 00:13 | ----- | ----- | ----- | ----- | ----- | 00:12 | ----- | ----- | ----- | ----- | pyanzin | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | medvedev | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | taibakov | 04:05 | 01:26 | 01:39 | ----- | 01:14 | 00:31 | ----- | ----- | 00:12 | 01:18 | 01:24 | 01:19 | kuznecov | 01:34 | 00:17 | ----- | ----- | 01:26 | ----- | 00:26 | 01:19 | ----- | ----- | 01:31 | ----- | charov | ----- | ----- | 00:48 | ----- | 02:53 | 00:23 | ----- | ----- | ----- | ----- | 00:41 | 00:30 | hairutdi | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ivanovz | ----- | 03:56 | 06:01 | 07:32 | 01:48 | 02:59 | ----- | 04:05 | 04:15 | 03:48 | 05:25 | 05:57 | kuricyn | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ----- | ptichkin | ----- | ----- | 01:53 | ----- | ----- | ----- | 00:14 | ----- | ----- | ----- | ----- | 01:34 | yakovlev | 01:36 | ----- | 01:51 | ----- | 00:30 | 02:11 | 04:34 | ----- | ----- | ----- | 01:56 | 04:00 |
Программа на языке shell, с помощью которой была получена таблица:
#!/bin/sh # заголовок таблицы printf "%-8s | " "login" for day in "Mar 5" "Mar 12" "Mar 19" "Mar 26" \ "Apr 2" "Apr 9" "Apr 16" "Apr 23" "Apr 30" \ "May 7" "May 14" "May 21" do printf "%6s | " "$day" done printf "\n" # цикл по login'ам for login in \ ananin kirilich marinin otlivanc pytko solomato surikov \ kryshen lazareva rafalson simakov simanovi \ gorinov poikalai radzhabo \ belov kuznecov sarv stepanov chegesov \ ilin voronov shitov pyanzin medvedev taibakov kuznecov charov hairutdi \ ivanovz kuricyn ptichkin yakovlev do # вывести login в начале строки printf "%-8s | " $login # цикл по вторникам for day in "Mar 5" "Mar 12" "Mar 19" "Mar 26" \ "Apr 2" "Apr 9" "Apr 16" "Apr 23" "Apr 30" \ "May 7" "May 14" "May 21" do # подсчет суммарного времени (awk), # которое провел $login (last -f wtmp $login) # за сутки $day (grep "$day") на kappa time=` last -f wtmp $login |\ grep "$day" |\ awk ' BEGIN { s = 0 } { s += 60 * substr($10, 2, 2) + substr($10, 5, 2) } END { if (s > 10) printf("%02d:%02d", s/60, s%60); else printf("-----") } ' ` # вывод суммарного времени printf "%6s | " "$time" # конец цикла по вторникам done # перевод строки printf "\n" # конец цикла по login'ам done
Т.к. считается суммарное время то если открыто 3 терминала в течении
1.5 часа то общее время получается 4.5 часа.