Sở Tài nguyên môi trường HB

Phần mềm hỗ trợ: https://drive.google.com/drive/folders/1zz-gL_pSF7R_vPXtsygtMMlypnXknA0C?usp=share_link

Hàm lấy vị trí dấu chấm đầu tiên I2 =FIND(".", F2)+1
Hàm lấy vị trí dấu chấm cuối cùng =FIND("@", SUBSTITUTE(F2, ".", "@", LEN(F2) - LEN(SUBSTITUTE(F2, ".", ""))))
Hàm lấy vị trí dấu chấm thứ 2 từ cuối J2 =FIND("@", SUBSTITUTE(F2, ".", "@", LEN(F2) - LEN(SUBSTITUTE(F2, ".", "")) - 1))
------------------------------------------------
Hàm lấy chuỗi Sau dấu đầu - Trước dấu cấm thứ 2 từ cuối: =mid(F2,I2,J2-I2)
Gộp =mid(F2, (FIND(".", F2)+1), (FIND("@", SUBSTITUTE(F2, ".", "@", LEN(F2) - LEN(SUBSTITUTE(F2, ".", "")) - 1))) - (FIND(".", F2)+1))

Master: https://docs.google.com/spreadsheets/d/1wQxyJDlOFcZW3L-rxEqY-t6ZzUp4JDn9T-5HPGZ5YP4/edit#gid=885545289

1. Scan tài liệu: https://drive.google.com/drive/folders/1OPutwLuHcZL70fJKddlSV31UyTzTe6sr

2. Tách hồ sơ: https://drive.google.com/drive/folders/1GJDlUx5TeiqwuNrb1c3T5lsZdElyDt0h

  1. - Tân thịnh (Niên) : https://docs.google.com/spreadsheets/d/1PXB6NTAbw9rRBG-TtjwVyOvsI-TRtSlF
  2. - Dân chủ (Giang): https://docs.google.com/spreadsheets/d/1iLbsSkh6AroAF-Rt_hdPYx8pddzquhjW
  3. - Quỳnh Lâm (Giang, Hưng): https://drive.google.com/drive/folders/1r8wT8Ie6FXb1EOArtyAOx6V2Xmx8O5xQ
  4. - Phương Lâm Đài (Giang, Hưng): https://drive.google.com/drive/folders/1xCIaUwiMKOj7nA5yXFgws7VRKmAVxJod
  5. - Chăm Mát (Hưng): https://docs.google.com/spreadsheets/d/1M2posJq7cnMwTfGiYZwnU5n5sOjYHdtPaxZsaDVQKaI
  6. - Mông Hoá - Tuy: https://docs.google.com/spreadsheets/d/1EueMQSW44luXvaKKPjWiV8FrDuf_-psqkrZmmJTS77o
  7. - Dân Hòa - Quang: https://docs.google.com/spreadsheets/d/14wd5MtkLQFIVY-OaqDXGkTGDVUbHyaE-uZ-u_ydG3CU
  8. - Yên Quang - Trang: https://docs.google.com/spreadsheets/d/1DUaLFAFESSMpNBPRQmmVWmnG-HjP4WG8VOMKy78e7Lg
  9. - Hòa Bình - ok: https://docs.google.com/spreadsheets/d/1b0NdEzLcUqUJ9oqBvEqhSFOoaXUwi3QK8qlhObcCiBY
  10. - Hợp Thành - ok: https://docs.google.com/spreadsheets/d/1LjEPj0HrA2aqmw0KNsiY3wXUKJ9EKQa6IPkWcvmyM7Y
  11. - Yên Mông: https://docs.google.com/spreadsheets/d/1lr0DC9N0Dc4bJRImBpim41vsUItJEu2ms7qbhJLc9JE
  12. - BS Tân Thịnh: https://docs.google.com/spreadsheets/d/1PXB6NTAbw9rRBG-TtjwVyOvsI-TRtSlF

3. Nhập liệu: https://drive.google.com/drive/folders/1SbTKF76_G4nRzHoXDEFMIgyuUe_Mmbwn

Mẫu nhập liệu: https://docs.google.com/spreadsheets/d/1GItJL6i1Tpwr6Sq714wmo8XjXJRde8mfxzZzQ-Gi2ro

Trong quá trình số hoá, xuất hiện số lỗi ko tự xử lý được, Ae có lỗi gì đẩy hết vào đây: https://docs.google.com/spreadsheets/d/1oryejkYWvxuKp2z4dLwU6AX0ZvPtr7gqhMkhYtPP6cI/edit#gid=0

4.  Bàn giao (nhóm nhập liệu): https://drive.google.com/drive/folders/1W3sTvfdItT6v2q8ybKl7vlDBNCs0HUZv

1. Tân Thịnh: https://docs.google.com/spreadsheets/d/1qbNJCscLcpSU3yR_gjPQyLyWcsYkYprcqE_42lsWZRQ/
2. Dân Chủ: https://docs.google.com/spreadsheets/d/1DASHz44ZOaMLv5ds-oP3lpYcEEbj11yr5tQ3lPoQ0eE/
3. Quỳnh Lâm - Sủi Ngòi: https://docs.google.com/spreadsheets/d/1zAnLQCGhP7e9rmXUvc4q5X0PYf3dy0oX7wB8OuNnuj4/
4. Phương Lâm: https://docs.google.com/spreadsheets/d/18DUTyxzdHJXkOTNkAhDBQoEazPq-HNCdrP5lPS918UI/
5. Chăm Mát: https://docs.google.com/spreadsheets/d/17ydFwfoOWJZqwIm1mrjzfZbAKd-wC44yPcKT76jGZlk/
6. Mông Hóa: https://docs.google.com/spreadsheets/d/1QI0IxT-_QkPIGPzIyjqA6W1AO-947GUkm6uw3ecC2so/
7. Dân Hòa: https://docs.google.com/spreadsheets/d/1KA7sQP-48UL7gtGs75ECkGMwHzqJqXCTM5-eddnZ0f4/
8. Yên Quang: https://docs.google.com/spreadsheets/d/1NPxp1o0oRp3iUP-LuHyWJO-8rxgfdqP5aRPcf8haTjg/
9. Hòa Bình: https://docs.google.com/spreadsheets/d/1SgNNSWgRIot93UfvT_8u7yk7z_gu1PuWHPdsJEGKfyQ/
10. Hợp Thành: https://docs.google.com/spreadsheets/d/1QbgsaPAzZgKiAMDJoI7ZSE51_3Ck7Ij7BAfDFEdAJxQ/
11. Yên Mông: https://docs.google.com/spreadsheets/d/1VuvsmX45lfVjgEacW3QQ-7ng-ie4FXQ3Nv4yXKODR2g/
12. Đồng Tiến (A3): https://docs.google.com/spreadsheets/d/1F10yk-Cn_t8mCJCA5ZipofkyRdUrK4RMBG0UOlky7Do
13. Hữu nghị: https://docs.google.com/spreadsheets/d/1sSHQuI0uOzRklytBQnki89Dz5tULp6N28qqHsctgwHI/edit#gid=1011816766

Gộp hộ Quỳnh (dùng tìm kiếm): https://drive.google.com/open?id=1HqCF5-uxtyjdB3pjHIXo5m4eMVgBfTLK&usp=drive_fs

Import vào Phần mềm FSI: https://drive.google.com/drive/u/3/folders/10vT6_8guWJPsHG6wpfrSgN03iXEDYxsi
Gửi a Long bản cuối: https://drive.google.com/drive/u/0/folders/1atxX6QslU6IVoClZLACLcPLJqOgY5iS6

Sinh chia lại:

HoaBinh_TNMT_VanBan_2022_part1: https://drive.google.com/drive/u/0/folders/0APMtsDNqu1o2Uk9PVA
1.TAN_THINH
2.DAN_CHU

HoaBinh_TNMT_VanBan_2022_part2: https://drive.google.com/drive/u/0/folders/0AHH6sf7ODThCUk9PVA
3.MONG_HOA
4.HUU_NGHI

HoaBinh_TNMT_VanBan_2023: https://drive.google.com/drive/u/0/folders/0AOeTrzDrBHWzUk9PVA
5.QUYNH_LAM
6.CHAM_MAT
7.DAN_HOA
8.YEN_QUANG
9.HOA_BINH
10.HOP_THANH
11.YEN_MONG
12.DONG_TIEN

HoaBinh_TNMT_VanBan_2024: https://drive.google.com/drive/u/0/folders/0AGilTynIaEI-Uk9PVA
13.TAN_HOA
14.THINH_LANG
15.PHUONG_LAM_
16.BS_TAN_THINH

Lỗi tách lại (Sinh liệt kê): https://docs.google.com/spreadsheets/d/1bW41Lu33KIHdSy3K8OhXZ40S5ZNV8Wu-/edit#gid=2085325395

Sau tết: Sinh gửi ổ cứng 4TB nhờ a Long đã copy vào SRV (192.168.1.35) tại đường dẫn: Z:\Data\TNMT_Signed (Ngày copy 5/3/2024)

  1. Z:\Data\TNMT_Signed\1.Chăm Mát
  2. Z:\Data\TNMT_Signed\2.Hoà Bình
  3. Z:\Data\TNMT_Signed\3.Yên Mông
  4. Z:\Data\TNMT_Signed\4.Quỳnh Lâm
  5. Z:\Data\TNMT_Signed\5.Phương Lâm
  6. Z:\Data\TNMT_Signed\6.Yên Quang
  7. Z:\Data\TNMT_Signed\7.Hợp Thành
  8. Z:\Data\TNMT_Signed\8.Đồng Tiến
  9. Z:\Data\TNMT_Signed\9.Thịnh Lang
  10. Z:\Data\TNMT_Signed\10.Tân Hoà

Link thư mục Metadata gửi a Long lần 3 (Gói 1 năm 2023 đã thêm đường dẫn vật lý): https://drive.google.com/drive/folders/1PePCCbC8uZh6MutQKkEMoAhfg0FwFFFe?usp=sharing

Tổng kết cuối năm: https://docs.google.com/spreadsheets/d/1ghs9cG7Q1mMgMpcH3jtCYOuMtWufQ0rzqO5o8PTIAeQ/edit#gid=702178519

Mục lục all sinh gửi: https://drive.google.com/drive/folders/1FCUp_BNyycvxw6-jKDkP8rUsuxaOOKoE