Metode dari excel report kpg 2017-2023
dicemplungin ke ChatGPT

Kesimpulan ChatGPT

Here is the data showing the total number of sales for each of the top 10 authors from 2017 to 2023:

  1. LEILA S. CHUDORI: 171,931 sales
  2. TEMPO: 154,166 sales
  3. MARCHELLA FP: 120,125 sales
  4. NAELA ALI: 88,901 sales
  5. YUVAL NOAH HARARI: 62,376 sales
  6. HARUKI MURAKAMI: 48,604 sales
  7. CHARLES DUHIGG: 45,034 sales
  8. TIM KIDDO: 39,758 sales
  9. HAEMIN SUNIM: 37,321 sales
  10. LARRY GONICK: 28,760 sales

Here is the data showing the average annual sales for each of the top 10 authors over the 6-year period from 2017 to 2023:

  1. LEILA S. CHUDORI: Approximately 28,655 sales/year
  2. TEMPO: Approximately 25,694 sales/year
  3. MARCHELLA FP: Approximately 20,021 sales/year
  4. NAELA ALI: Approximately 14,817 sales/year
  5. YUVAL NOAH HARARI: Approximately 10,396 sales/year
  6. HARUKI MURAKAMI: Approximately 8,101 sales/year
  7. CHARLES DUHIGG: Approximately 7,506 sales/year
  8. TIM KIDDO: Approximately 6,626 sales/year
  9. HAEMIN SUNIM: Approximately 6,220 sales/year
  10. LARRY GONICK: Approximately 4,793 sales/year

Here is the detailed information showing the total number of unique book titles (ItemDesc) for each of the top 10 authors:

  1. LEILA S. CHUDORI: 10 titles
  2. TEMPO: 76 titles
  3. MARCHELLA FP: 8 titles
  4. NAELA ALI: 14 titles
  5. YUVAL NOAH HARARI: 4 titles
  6. HARUKI MURAKAMI: 15 titles
  7. CHARLES DUHIGG: 3 titles
  8. TIM KIDDO: 2 titles
  9. HAEMIN SUNIM: 2 titles
  10. LARRY GONICK: 15 titles
Data Excel Penulis dan Judul buku mereka

Analisa detail 10 penulis ini

1. Leila S Chudori
SIDEWAYS, WHERE’S THE SUPPORT??

Rata-rata penjualan buku Leila tinggal 4.000 eksemplar perbulan.
Kekuatan Leila S.Chudori sudah terlihat dengan kemampuannya bertahan menjual rata-rata 1.000 buku sejak september 2017 hingga mei 2021.
Sejak Agustus 2021 Leila melesat diatas 2.000 eksemplar. Bahkan pernah mencapai hampir 14.000 eksemplar sebulan.

Data diatas adalah hasil penjualan 5 judul buku Leila S.Chudori dibawah:

  1. Laut Bercerita
  2. Malam Terakhir
  3. Pulang
  4. Nadira
  5. Namaku Alam

Data yang dipakai disini hanya dari jan 2017 sampai Juni 2023

2. Seri Tempo
DOWNTREN ABIS. CUT LOSS!!!!!

Total ada 76 judul buku Tempo

Here is the detailed information showing the total sales for each book title (ItemDesc) authored by TEMPO from 2017 to 2023:

  • SERI TEMPO: SUDIRMAN (NEW): 6,395 sales
  • SERI TEMPO: WIJI THUKUL (NEW): 5,906 sales
  • SERI TEMPO: SUKARNO (NEW): 5,466 sales
  • SERI TEMPO: TAN MALAKA – NEW: 5,250 sales
  • BUKU SAKU TEMPO: HATTA: 5,046 sales
  • … (and many more, totaling 76 titles)

PENJUALAN DI JUNI 2023 SEMUA BUKU TEMPO CUMA 101 (DARI 76 JUDUL BUKU)
CHART TURUN. SUDAH SELESAI MASANYA!!! BYE BYE TEMPO. DOWN TREND TO DIE DIE DIE!

3. MARCHELLA FP

Here is the detailed information showing the total sales for each book title (ItemDesc) authored by MARCHELLA FP from 2017 to 2023:

  • NANTI KITA CERITA TENTANG HARI INI: 89,088 sales
  • NANTI KITA CERITA TENTANG HARI INI (TAMBAHAN PESAN SORE): 10,317 sales
  • NANTI KITA CERITA TENTANG HARI INI (TAMBAHAN PESAN SIANG): 8,480 sales
  • NANTI KITA CERITA TENTANG HARI INI (TAMBAHAN PESAN PAGI): 6,824 sales
  • GENERASI 90AN: 3,254 sales
  • GENERASI 90AN: ANAK KEMAREN SORE: 1,856 sales
  • FP GENERASI 90-AN: ANAK KEMARIN SORE: 263 sales
  • DIARY SUKA2 GENERASI 90-AN: 43 sales

Adapun demikian sudah sejak 2.5 tahun belakangan penjualan rata-rata semua buku Marchella FP hanya kurang dari 200 eksemplar perbulan

4. NAELA ALI

Here is the detailed information showing the total sales for each book title (ItemDesc) authored by NAELA ALI from 2017 to 2023:

  • STORIES FOR RAINY DAYS: 23,772 sales
  • STORIES FOR RAINY DAYS VOL. 2: 17,735 sales
  • THINGS & THOUGHTS I DREW WHEN I WAS BORED: 15,296 sales
  • STORIES FOR RAINY DAYS VOLUME III: 8,974 sales
  • NOT SO SILLY JOURNAL: 5,989 sales
  • FLOATING IN SPACE: 5,494 sales
  • SILLY GILLY DAILY: 5,454 sales
  • NOT SO SILLY STICKER & POSTCARD BOOK: 1,872 sales
  • SILLY GILLY DAILY: STAY AT HOME: 1,348 sales
  • DREAMS ARE MADE OF A BOX OF CRAYONS: 1,273 sales
  • RECORDS OF RAINY DAYS: 1,084 sales
  • STORIES FOR RAINY DAYS (2023): 370 sales
  • STORIES FOR RAINY DAYS VOLUME 3 (2023): 122 sales
  • STORIES FOR RAINY DAYS VOLUME 2 (2023): 118 sales

Menarik melihat chart sideways ini karena on average buku2 Naela terjual sekitar 500 eksemplar perbulan. Gimana bisa naikin…..

5. YUVAL NOAH HARARI

Here is the detailed information showing the total sales for each book title (ItemDesc) authored by YUVAL NOAH HARARI from 2017 to 2023:

  • SAPIENS: 54,993 sales
  • SAPIENS GRAFIS: KELAHIRAN UMAT MANUSIA: 4,477 sales
  • SAPIENS GRAFIS VOL.2: PILARREGULARPILAR PERADABAN: 2,033 sales
  • SAPIENS (HC): 873 sales

6. HARUKI MURAKAMI

Here is the detailed information showing the total sales for each book title (ItemDesc) authored by HARUKI MURAKAMI from 2017 to 2023:

  • NORWEGIAN WOOD: 10,935 sales
  • 1Q84 JILID 1 (NEW): 9,497 sales
  • TSUKURU TAZAKI TANPA WARNA DAN TAHUN ZIARAHNYA: 6,241 sales
  • DENGARLAH NYANYIAN ANGIN: 5,119 sales
  • 1Q84 JILID 2 (NEW): 4,179 sales
  • 1Q84 JILID 3 (NEW): 3,559 sales
  • LELAKI LELAKI TANPA PEREMPUAN: 3,030 sales
  • NORWEGIAN WOOD (NEW): 2,174 sales
  • KRONIK BURUNG PEGAS: 1,870 sales
  • MEMBUNUH COMMENDATORE JILID I: IDEA YANG MENJELMA: 918 sales
  • MEMBUNUH COMMENDATORE JILID II: METAFORA YANG BERSALIN RUPA: 565 sales
  • ORANG PERTAMA TUNGGAL: 462 sales
  • FP NORWEGIAN WOOD: 43 sales
  • I184 JILID 2: 7 sales
  • 1Q84 JILID 3: 5 sales

7. CHARLES DUHIGG

Here is the detailed information showing the total sales for each book title (ItemDesc) authored by CHARLES DUHIGG from 2017 to 2023:

  • THE POWER OF HABIT (2019): 21,984 sales
  • THE POWER OF HABIT: 14,518 sales
  • SMARTER FASTER BETTER: 8,532 sales

8. TIM KIDDO:

Here is the detailed information showing the total sales for each book title (ItemDesc) authored by TIM KIDDO from 2017 to 2023:

  • AKU NAURA: 39,547 sales

9. HAEMIN SUNIM

The total sales for each “ItemDesc” by the author “HAEMIN SUNIM” from the years 2017 to 2023 are as follows:

  1. “THE THINGS YOU CAN SEE ONLY WHEN YOU SLOW DOWN”: 26,672 units
  2. “LOVE FOR IMPERFECT THINGS”: 12,293 units

Rata-rata oenjualan perbulan diatas 700 eksemplar perbulan = bagus!!!!
pernah melesat lebih dari 2.000 buku!

10. LARRY GONNICK

Here is the detailed information showing the total sales for each book title (ItemDesc) authored by LARRY GONICK from 2017 to 2023:

  • KARTUN FISIKA (2020): 5,217 sales
  • KARTUN KIMIA (2020): 4,319 sales
  • KARTUN RIWAYAT PERADABAN JILID 1: 2,832 sales
  • KARTUN STATISTIK (2020): 2,295 sales
  • KARTUN RIWAYAT PERADABAN JILID III: 2,134 sales
  • KARTUN RIWAYAT PERADABAN JILID II: 2,121 sales
  • KARTUN BIOLOGI: 2,033 sales
  • KARTUN ALJABAR: 1,678 sales
  • KARTUN KALKULUS: 1,664 sales
  • KARTUN GENETIKA (2020): 1,173 sales
  • KARTUN LINGKUNGAN (2021): 1,075 sales
  • KARTUN (NON) KOMUNIKASI (2021): 891 sales
  • KARTUN RIWAYAT PERADABAN MODERN JILID I: 552 sales
  • KARTUN RIWAYAT PERADABAN MODERN JILID II: 498 sales
  • KARTUN RIWAYAT PERADABAN JILID I: 278 sales

11. BONUS CHART KATEGORI ENSIKLOPEDIA KPG
(CLS ENCYCLOPEDIAS)

The total sales for the class “CLS ENCYCLOPEDIAS” from the years 2017 to 2023 amount to 113,241 units.

The list of “ItemDesc” under the class “CLS ENCYCLOPEDIAS,” along with their respective total sales from the years 2017 to 2023, is as follows:

  1. NG ATLAS PERANG DUNIA II: 3,991 units
  2. NAT GEO ANTARIKSAPEDIA EDISI KEDUA: 1,264 units
  3. NG KUCINGPEDIA: 2,778 units
  4. NATIONAL GEOGRAPHIC LAUTPEDIA: 5,560 units
  5. MENGAPA?: 6,584 units
  6. SAINSPEDIA: 6,714 units
  7. NG ATLAS ANTARIKSA: 3,328 units
  8. NG HIUPEDIA: 2,676 units
  9. REPTILPEDIA: 3,852 units
  10. NG SERANGGAPEDIA NEW: 2,269 units
  11. NG TUBUHPEDIA: 3,430 units
  12. NAT GEO CUACAPEDIA: 144 units
  13. MITOLOGI YUNANI: 4,753 units
  14. NG BAGAIMANA BENDA BEKERJA: 2,594 units
  15. NG APA JADINYA?: 2,065 units
  16. FAUNAPEDIA (NEW): 6,658 units
  17. MITOLOGI MESIR: 2,576 units
  18. NG ANJINGPEDIA: 736 units
  19. NG PREDATORPEDIA: 1,624 units
  20. NG MENGAPA TIDAK?: 784 units
  21. NG DINOPEDIA EDISI KEDUA: 2,403 units
  22. NG KISAHREGULARKISAH ALKITAB PERJANJIAN LAMA: 482 units
  23. NG ROMAWI KUNO NEW: 3,421 units
  24. NG YUNANI KUNO NEW: 3,819 units
  25. NG MUSIKPEDIA: 314 units
  26. NG TIONGKOK KUNO NEW: 3,342 units
  27. NG MESIR KUNO NEW: 4,243 units
  28. NG AZTEK KUNO NEW: 2,238 units
  29. NG 1000 FAKTA ALKITAB: 1,684 units
  30. KISAH 1001 MALAM: 1,352 units
  31. SERBA SERAM!: 1,027 units
  32. ANGRY BIRDS PLAYGROUND: BINATANG: 714 units
  33. NG SERBA GAGAL!: 1,252 units
  34. 1000 FAKTA ALKITAB: 888 units
  35. NG DINOPEDIA (COVER BARU): 2,986 units
  36. NG BUKU PARA JAGOAN: KUMPULAN KISAH PEREMPUAN BERNYALI: 506 units
  37. ANTARIKSAPEDIA (NEW): 5,662 units
  38. 1001 PENEMUAN & FAKTA MEMPESONA PERADABAN MUSLIM (NEW): 2,983 units
  39. SERBA RAHASIA!: 1,825 units
  40. NG AFRIKA KUNO NEW: 1,237 units
  41. FP 1001 PENEMUAN & FAKTA MEMPESONA PERADABAN MUSLIM: 410 units
  42. FP SERBA JIJIK!: 644 units
  43. MOMMIES DAILY ME TIME: MEMASTIKAN IBU TETAP “WARAS”: 1 unit
  44. FP NG SERANGGAPEDIA: 313 units
  45. FP FAUNAPEDIA: 67 units
  46. ANTARIKSAPEDIA: 94 units
  47. ENSIKLOPEDIA KEPERCAYAAN TERHADAP TUHAN YANG MAHA ESA: 1 unit
  48. NG BUKU PARA JAGOAN: KUMPULAN KISAH LAKI-LAKI PEMBERANI: 910 units
  49. MITOLOGI NORSE: 1,351 units
  50. ANGRY BIRDS PLAYGROUND: DINOSAURUS: 741 units
  51. SERBA MAUT!: 1,951 units

Average penjualan perbulan diatas 750 eksemplar

12. BONUS ZIGGY

13. BONUS MAMAN SUHERMAN

14. ALAN TH

15. Ayu Utami

The total number of units sold for all “ItemDesc” by the author “AYU UTAMI” from the years 2017 to 2023 amounts to 27,618 units.

Below are the “ItemDesc” along with their total sales from 2017 to 2023 for the author “AYU UTAMI”:

  1. MENULIS & BERPIKIR KREATIF CARA SPIRITUALISME KRITIS 1 (SOFT: 256 units
  2. BILANGAN FU (2023): 156 units
  3. SAMAN (2023): 252 units
  4. MEMBACA GOENAWAN MOHAMAD: 141 units
  5. MENULIS & BERPIKIR KREATIF CARA SPIRITUALISME KRITIS 2 (SOFT: 103 units
  6. LARUNG (2023): 113 units
  7. BILANGAN FU (2018): 2955 units
  8. ANATOMI RASA: 3391 units
  9. MANJALI: 1012 units
  10. MENULIS & BERPIKIR KREATIF (NEW): 2109 units
  11. SAMAN (2018): 2319 units
  12. LARUNG (2018): 1047 units
  13. MENULIS & BERPIKIR KREATIF 2: 1342 units
  14. SIMPLE MIRACLES (2019): 1060 units
  15. LARUNG (NEW): 2019 units
  16. LALITA (NEW): 725 units
  17. MAYA (NEW): 715 units
  18. SAMAN: 2366 units
  19. SIMPLE MIRACLES: 42 units
  20. FP CERITA CINTA ENRICO: 394 units
  21. CL70 SIMPLE MIRACLES (NEW): 1291 units
  22. PENGAKUAN : EKS PARASIT LAJANG: 743 units
  23. SI PARASIT LAJANG: 445 units
  24. CL70 MENULIS & BERPIKIR KREATIF: 317 units
  25. NOTES KREATIF AYU UTAMI: 1 unit
  26. LARUNG: 0 units
  27. SAMAN (EDISI-INGGRIS): 72 units
  28. SI PARASIT LAJANG (NEW): 2188 units
  29. LALITA: 24 units
  30. MAYA: 20 units

TOTAL PENULIS DIBAWAH KALO DIJAGAIN UDAH BISA NGEJUAL 100.000 EKSEMPLAR SETAHUN. SEMENTARA RATA-RATA UNTUK NGEJAR BILLING PENJUALAN KPG ADALAH 200.000
ARTINYA SETENGAH BILLING TERCAPAI DENGAN JAGAIN KEY CREATOR DIBAWAH