ChatGPTにテキストを表にまとめてもらう
インドネシアの最低賃金は毎年更新され、年末になると翌年の最低基準が順次公表される。しかし、政府の公式サイトには一覧表がないため、民間メディア等がニュース記事にしたものが一般に出回る。統計局が過年度のデータを後々まとめて公表するが、速報はメディアの記事が一次データとなる。
https://money.kompas.com/read/2023/11/22/075527026/daftar-ump-2024-di-seluruh-indonesia-dki-jakarta-tertinggi
しかし、これをコピーして貼り付けると、以下のようなテキスト形式で生成される。一昔前であれば、若手社員にエクセル表に見やすくまとめるよう指示を出していた作業だ。
| UMP Aceh Rp 3.460.672 (Naik 1,38 persen dibandingkan 2023) UMP Sumatera Utara Rp 2.809.915 (Naik Rp 99.122 atau 3,67 persen dibandingkan 2023) UMP Sumatera Barat Rp 2.811.449 (Naik Rp 68.973 atau 2,52 persen dibandingkan 2023) UMP Riau Rp 3.294.625 (Naik Rp 102.963 dibandingkan 2023) UMP Kepulauan Riau Rp 3.402.492 (Naik 3,76 persen dibandingkan 2023) UMP Jambi Rp 3.037.121 (Naik Rp 94.000 atau 3,2 persen dibandingkan 2023) UMP Sumatera Selatan Rp 3.456.874 (Naik Rp 52.000 atau 1,55 persen dibandingkan 2023) UMP Bengkulu Rp 2.507.000 (Naik 3,86 persen dibandingkan 2023) UMP Bangka Belitung Rp 3.640.000 (Naik Rp 139.904 atau 4,066 persen dibandingkan 2023) UMP Lampung Rp 2.716.496 (Naik Rp 83.212 atau 3,16 persen dibandingkan 2023) UMP Banten Rp 2.727.812 (Naik Rp 66.532 atau 2,50 persen dibandingkan 2023) UMP DKI Jakarta Rp 5.067.381 (Naik Rp 3,3 persen dibandingkan 2023) UMP Jawa Barat Rp 2.057.495 (Naik 3,57 persen) UMP Jawa Tengah Rp 2.036.947 (Naik 4,02 persen) UMP DIY Rp 2.125.897 (Naik Rp 144.115 atau 7,27 persen dibandingkan 2023) UMP Jawa Timur Rp 2.165.244 (Naik Rp 125.000 atau 6,13 persen dibandingkan 2023) UMP Bali Rp 2.813.672 (Naik Rp 100.000 atau 3,68 persen dibandingkan 2023). UMP Nusa Tenggara Barat Rp 2.444.067 (Naik Rp 72.660 atau 3,06 persen) UMP Nusa Tenggara Timur Rp 2.186.826 (Naik Rp 62.832 atau 2,96 persen) UMP Kalimantan Barat Rp 2.702.616 (Naik 3,6 persen) UMP Kalimantan Tengah, belum ada putusan resmi UMP Kalimantan Selatan Rp 3.282.812 (Naik Rp 132.835 atau 4,22 persen) UMP Kalimantan Timur Rp 3.360.858 (Naik Rp 159.459 atau 6,20 persen) UMP Kalimantan Utara belum ada putusan resmi UMP Sulawesi Utara Rp 3.545.000 (Naik Rp 57.920 atau 1,67 persen) UMP Sulawesi Tengah Rp 2.736.698 (Naik Rp 137.152 atau 8,73 persen) UMP Sulawesi Selatan Rp 3.434.298,00 (Naik 1,45 persen) UMP Sulawesi Tenggara Rp 2.885.964 (Naik Rp 126.980 atau 4,6 persen) UMP Gorontalo Rp 3.025.100 (Naik 1,19 persen) UMP Sulawesi Barat Rp 2.914.958 (Naik Rp 43.163 atau 1,50 persen) UMP Maluku belum ada putusan resmi UMP 2024 Maluku Utara Rp 3.200.000 (Naik Rp 221.646,57 atau 7,5 persen) UMP Papua Rp 4.024.270 (Naik Rp 159.574 atau 4,14 persen). |
今はChat GPTを使う。この手の単純作業は機械が得意。以下のように指示を出す。
| The following is a list of the 2024 minimum wage set by 33 provinces. The values of minimum wages are written in Indonesian rupiah (IDR) – ignore ‘UMP’. Make a table. Column 1= Province; Column 2 Minimum wage; Column 3 remarks. Use tab between neighbouring columns. Remove IDR.
Aceh UMP IDR 3,460,672 (1.38 percent increase compared to 2023) North Sumatra UMP IDR 2,809,915 (Increase IDR 99,122 or 3.67 percent compared to 2023) West Sumatra UMP IDR 2,811,449 (Increase IDR 68,973 or 2.52 percent compared to 2023) Riau UMP Rp. 3,294,625 (Increase Rp. 102,963 compared to 2023) Riau Islands UMP IDR 3,402,492 (Increase 3.76 percent compared to 2023) Jambi UMP IDR 3,037,121 (Increase IDR 94,000 or 3.2 percent compared to 2023) South Sumatra UMP IDR 3,456,874 (Increase by IDR 52,000 or 1.55 percent compared to 2023) Bengkulu UMP IDR 2,507,000 (Increase 3.86 percent compared to 2023) Bangka Belitung UMP IDR 3,640,000 (Increase IDR 139,904 or 4.066 percent compared to 2023) Lampung UMP Rp. 2,716,496 (Increase Rp. 83,212 or 3.16 percent compared to 2023) Banten UMP Rp. 2,727,812 (Increase Rp. 66,532 or 2.50 percent compared to 2023) DKI Jakarta UMP IDR 5,067,381 (Increase by IDR 3.3 percent compared to 2023) West Java UMP IDR 2,057,495 (Increase 3.57 percent) Central Java UMP IDR 2,036,947 (Up 4.02 percent) DIY UMP Rp. 2,125,897 (Increase Rp. 144,115 or 7.27 percent compared to 2023) East Java UMP Rp. 2,165,244 (Increase Rp. 125,000 or 6.13 percent compared to 2023) Bali UMP IDR 2,813,672 (an increase of IDR 100,000 or 3.68 percent compared to 2023). West Nusa Tenggara UMP Rp. 2,444,067 (Increase Rp. 72,660 or 3.06 percent) East Nusa Tenggara UMP Rp. 2,186,826 (Increase Rp. 62,832 or 2.96 percent) West Kalimantan UMP IDR 2,702,616 (Increase 3.6 percent) Central Kalimantan UMP, there is no official decision yet South Kalimantan UMP Rp. 3,282,812 (Increase Rp. 132,835 or 4.22 percent) East Kalimantan UMP Rp. 3,360,858 (Increase Rp. 159,459 or 6.20 percent) North Kalimantan UMP has not yet made an official decision North Sulawesi UMP Rp. 3,545,000 (Increase Rp. 57,920 or 1.67 percent) Central Sulawesi UMP Rp. 2,736,698 (Increase Rp. 137,152 or 8.73 percent) South Sulawesi UMP IDR 3,434,298.00 (Increase 1.45 percent) Southeast Sulawesi UMP Rp. 2,885,964 (Increase Rp. 126,980 or 4.6 percent) Gorontalo UMP IDR 3,025,100 (Increase 1.19 percent) West Sulawesi UMP Rp. 2,914,958 (Increase Rp. 43,163 or 1.50 percent) There has been no official decision on the Maluku UMP UMP 2024 North Maluku IDR 3,200,000 (Increase IDR 221,646.57 or 7.5 percent) Papua UMP Rp. 4,024,270 (Increase Rp. 159,574 or 4.14 percent). |
ものの数秒で、以下のような一覧表を作成してくれる。