Kerenan diCombo aka Wuling Rangga!!

Guys

Gw mengakui Wuling Huang Gong X keren sekali!

Tp gw kurang suka tampang depan nya

Terlalu mirip konsep tampak depan Mitsubishi Expander, Toyota Velox, dan mungkin juga Nissan Juke


Jadi nya gw COMBO sesuai menurut gw best nya gimana!!


Jadi nya Wuling Rangga HYBRID:

Pengerjaan Machine Learning to be shared in Mom's Dissertation assist

 Jadi gini gan

Gw bantu2 Emak ktk dalam proses menulis Disertasi S3 Emak gw

Dan dalam pengerjaan nya membutuhkan pemrosesan dgn Machine Learning dalam pengolahan data

Seru!

Dan ini gw share dokumentasi pengerjaan nya


nb:

Bagian gw aja ya

Ga usah semua Disertasi Emak


MachineLearning by ANM

Pencatatan utk SummaryPurpose Kontrak dgn SubKontrak dan desain semi custom "standar" ERP umum serta desainDatabase

 Guys

Punya kenangan di 2012

Jadi

Ada klien audit gw ("sebagai bagian dr audit firm tempat kerja" tetep!)

Dan waktu itu software ERP customizable sangat mahal!

Dimana sisi customizable ini sangat penting utk menerapkan sistem yg gw desain based on pemahaman gw terhadap klien gw

Gw pernah share di tempat lain (blog wordpress gw yg dolo!)

Dan sekarang gw share di blogspot ana!

Share!!


nb: 

masih acak2an seh

belum gw REFINE lagi : (


GSI 2012

Kok angka dgn tanda negatif di Ms Excel ga dalam kurung dan berwarna merah lagi ya?

Tips supaya format angka di Excel ky dolo lagi!

#.##0;[Red](#.##0)


CONTOH:


KLIK KANAN DAN PILIH FORMAT CELLS

PILIH OPSI CUSTOM DAN PASTE KODINGAN SHARE DR GW:

DONE!!


My Own Words of Purchasing Cycle + ChatGPT

Misi agan2

Mo share gambaran Siklus Pembelian (Purchasing Cycle) secara umum di Perusahaan dgn kata2 gw sendiri dalam bahasa Inggris dan diKERENIN by ChatGPT!

My Writing

Company send Purchase Requisition to otential suppliers; at least 3 best supplier candidates. Supplier selected mainly due to best price offer; keep in mind mainly but not only. For selected supplier, Company send Purchase Order describing item and amount requested. Supplier send Goods requested furthermore with their Delivery Order document; no unit price nor total unit price in Supplier Delivery Order. Supplier Invoice could be send simultaneously or sent later; not after such a too long time would be wise. Company receives all of them (Delivery Order send by Company to request purchase, Supplier Delivery Order, and Supplier Invoice) by Company Receiving Department. Receiving Department sign Supplier Delivery Order as proof for Supplier that Goods ordered by Company has been received by Company with no flaws at all, and simultaneously as strong base document for later on Supplier could be collecting payment by issuing Invoice to Company. Receiving Report summarize daily receivement of Goods from “can be” many Suppliers, with “a must” copy of Suppliers’ Delivery Orders. Receiving Department send Daily Receipt Summary to Accounting Department to post Receivements in Acconting System; noted that the posting date journal must according to date of Goods actually received by Receiving Department. The accounting journal is Inventory (Dr.) and Account Payable (Cr.); noted that it is recording process and no payment by Company done. After a while, Company need to pay Goods received. Accounting Department, as a control activity to before doing payment, must ensure payment is done for only real transactions, means that no payment done for fictious purchase nor for never received Goods fake transactions. Therefore, as both preventing and mitigating risk activity, Accounting and match and examine consistencies among Company Purchase Order, Receiving Report and copy of Supplier Delivery Order, and Supplier Delivery Order accompanying Supplier Invoice itself. Then after matching and examining, Company do payement. The accounting journal is Account Payable (Dr.) and Cash/Bank (Cr.); noted that the posting date journal must according to date of Cash Payment to Supplier or Bank Transfer to Supplier. Then, a whole Purchasing Cycle activity is done. For additional, Company usually keep unpaid payment documents sorted by date of the documents, althought each would be arrived at Accounting Department in different date of occurences. Because, it is important to pay Suppliers early as possible as mandatory documents completed; first come first serve. And after payment, those mandatory documents or a must requisite documents, filed by Suppliers’ name. Thus, can be recalled by Accounting Department as simple as possible for each Supplier when an accounting department activity regarding those each suppliers’ document must be done. For example, in the worst case, differences occur between Company book and Supplier book.

  

ChatGPT Improvement

STORY style:

The company sends a Purchase Requisition to potential suppliers, targeting at least three of the best supplier candidates. Suppliers are selected primarily based on the best price offer, though other factors may also be considered. For the selected supplier, the company sends a Purchase Order describing the requested items and quantities.

The supplier delivers the requested goods along with their Delivery Order document, which does not include unit prices or total amounts. The Supplier Invoice may be sent simultaneously or at a later date, but it is advisable to avoid delays. The company receives all relevant documents—such as the Purchase Requisition, the Supplier Delivery Order, and the Supplier Invoice—through its Receiving Department.

The Receiving Department signs the Supplier Delivery Order as proof that the goods ordered by the company have been received without defects. This signed document serves as a strong basis for the supplier to later collect payment by issuing an invoice to the company. Additionally, the Receiving Department prepares a Receiving Report summarizing daily goods receipts, which must include copies of the suppliers’ Delivery Orders. The Receiving Department then sends the Daily Receipt Summary to the Accounting Department to record the receipts in the accounting system.

Note: The posting date for journal entries must correspond to the date the goods were actually received. The journal entry for this recording is as follows:

  • Inventory (Dr.)
  • Accounts Payable (Cr.)

This process is purely for recording purposes; no payment is made at this stage.

When the company needs to pay for the received goods, the Accounting Department performs a control check to ensure that payments are made only for genuine transactions. This involves verifying the consistency among the company’s Purchase Order, the Receiving Report (with copies of Supplier Delivery Orders), and the Supplier Invoice accompanied by the Supplier Delivery Order. Once the documents are verified, the company proceeds with the payment.

The journal entry for the payment is as follows:

  • Accounts Payable (Dr.)
  • Cash/Bank (Cr.)

The posting date for this journal entry must correspond to the actual date of payment to the supplier, whether by cash or bank transfer.

At this point, the Purchasing Cycle is complete. Additionally, the company organizes unpaid payment documents by their document date, even if they arrive at the Accounting Department on different dates. This system ensures prompt payments on a first-come, first-served basis, as soon as all mandatory documents are received.

After payment, these documents are filed under the respective supplier's name for easy retrieval. This filing system simplifies future activities involving the suppliers' documents, such as reconciling discrepancies between the company's records and the supplier's records.

 

ChatGPT Improvement

POINTS style:

Purchasing Cycle Flowchart

  1. Purchase Requisition (Company)
    • Action: Send Purchase Requisition to potential suppliers.
    • Output: At least three supplier candidates.
  2. Supplier Selection (Company)
    • Input: Supplier quotes.
    • Action: Select the supplier (based on price and other criteria).
    • Output: Best supplier chosen.
  3. Purchase Order (Company)
    • Action: Send Purchase Order to the selected supplier.
    • Output: Describes requested items and quantities.
  4. Goods Delivery (Supplier)
    • Action: Deliver goods with a Delivery Order (no prices listed).
    • Output: Goods and Delivery Order received by the company.
  5. Receiving Goods (Receiving Department)
    • Action: Verify and sign the Delivery Order.
    • Output: Proof of receipt and Receiving Report.
  6. Accounting Entries (Accounting Department)
    • Input: Documents from Receiving Department.
    • Action: Post inventory receipt with journal entry:
      • Dr.: Inventory
      • Cr.: Accounts Payable
  7. Payment Verification (Accounting Department)
    • Input: Match and verify consistency among:
      • Purchase Order
      • Receiving Report
      • Delivery Order
      • Invoice
    • Action: Ensure payment for genuine transactions only.
  8. Payment Processing (Company)
    • Action: Pay supplier via cash or bank transfer.
    • Output: Payment made, journal entry posted:
      • Dr.: Accounts Payable
      • Cr.: Cash/Bank
  9. Document Filing (Accounting Department)
    • Action: File documents by supplier name.
    • Purpose: Easy retrieval for reconciliation or review.

My "first car" Chevrolet Spark (the car is already in my name/vehicle registration)

Dear my Chevrolet Spark,

At first, I was overexcited.
After a while, it got worse—it became a habit.


When going out to find food in the middle of the night,
I felt a bit sleepy, my eyes tired and heavy.

There was a silver Jazz inviting me to "speed up."
For a moment, I felt challenged.
Not long after, I joined in, speeding—
(though I’m still slower in speeding at that time)

Unfortunately, sadly, I had an accident.

My car flipped over and got severe damage.

Masalah CCTV V380 Pro tidak connect "lagi" karena harus di RESET!

 Gan

Mau cerita, curhat, atau apa lah

Emak baru beli CCTV brand V380 Pro

Nah

Ditugaskanlah gw buat masang

Dan

Gw coba dulu dong di kamar gw

Dan berhasil!


NAMUN!!!

Pas gw pasang di tempat yg seharusnya dipasang

ERROR!!!

Selidik punya selidik

Masalah nya HARUS DI RESET!!

Dan penyebab nya:

Ketika gw memindahkan setting WiFi CCTV dr WiFi kamar gw ke WiFi tempat yg seharus nya ada masalah yg terjadi

Yaitu kesulitan LOG IN


Jadi TIPS PENTING DR GW!!!!

Pada saat coba2 di awal (di kamar misal nya; dgn WiFi kamar agan2 tentu nya) koneksikan saja ke WiFi HP agan2 jd nanti di tempat baru TETAP bisa konek yaitu ke konek ke WiFi HP agan2

Dan baru lah setelah tak masalah konek lagi
Agan2 bisa setting ulang WiFi nya 
Di kasus gw
Dgn WiFi pada tempat yg emak gw suruh pasang :)

Jadi tidak menemui kesulitan saat dipasang pada tempat nya

Kan logika nya, WiFi CCTV terkonek dulu ke WiFi yg sudah gw setting, yaitu WiFi yg di kamar gw

Nah CCTV gw bingung; ya kan cari2 WiFi kamar gw yg gw setting diawal ga nemu2 kan ya

Ga bisa connect di awalan di tempat yg semesti nya dipasang jd nya

DAN SOLUSI DR AGAN2 YOUTUBE ADALAH DENGAN MERESET YA GAN!

DAN MULAI DR AWAL; PENYETINGAN WIFI UTK CCTV YG MANA


Duh
Pusing ana gan
Sama kaya kasus WiFi Repeater Xiaomi gw

HARUS DIRESET SPY BISA DISETTING ULANG


OK agan2
Sekian dr ana!!

saduran dr Youtube (lokasi utk reset)

NEMUIN TOMBOL UTK DIPENCET NYA AGAK TRICKI YA GAN

PENCET DAN TAHAN SEKITAR 5 DETIK SAMPAI NYAUT CCTV NYA


Link Youtube nya gan! dr sohib di WorldWideWeb


https://www.youtube.com/watch?v=Qsfsx8XRu20

Odner berSub MapPlastik2

Odner berSub MapPlastik2

Saya ada tips utk merapikan file2 saudara!

Kan tujuan menggunakan odner agar kita bisa menyimpan file2

Trus gimana kalau penyusunan filing kita mau nya ada “sub2” lagi dari Odner “utama” itu sendiri

 

Kalau saya (baru coba jg sih!) dgn cara menempatkan MapPlastik2 didalam Odner utama itu sendiri

Baik MapPlasik2 dan Odner utama sama2 menyimpan dgn sistem penyimpanan kertas dengan metode lubang (2bh); bukan sistem penjepit

 

Awal nya siap kan Odner dan MapPlastik2



Tahap 1: Pengukuran utk DOUBLE TAPE PENGGANJAL

Nah kan utk dijadikan “Sub”

Maka MapPlastik2 tersebut harus menggunakan sistem 2 pelubangan

Yg pertama utk MapPlastik itu sendiri

Dan yg kedua utk Odner utama

siapkan double tape (kita menggunakan aspek “tebal” double tape)


potong double tape secukupnya dari sisi panjang, dan yg terutama dari sisi lebar dibuat tebal “tepat” 8mm

 

pasang/lekatkan di pembolong kertas sbg “pengganjal” utk menciptakan lubang ganda yg sejajar

jarak lubang ke dinding pembolong 1cm

Jarak lebar double tape custom yg disediakan 8mm sehingga ada selisih 2mm sebagai jarak lubang ganda paralel kedua dari sisi paling pinggir/kiri


Tampak(an) besar/jarak jauh



Tahap 2: Pengukuran utk MapPlastik2

Ukuran tinggi MapPlastik2 adalah 34.4cm

Titik tengah utk dasar/patokan pelubang utk pelubangan lubang ganda/paralel adalah 17.2cm

UKUR 


LETAKKAN


POTONG DAN HASIL

nb: lepaskan dulu pengait bagian dalam utk mempermudah pelubangan


 
 

PASANG KEMBALI KAIT2 bawaan MapPlastik tersebut

 

PASANG(KAN) MapPlastik ke kait ODNER UTAMA


SELESAI!



TAMBAHAN

(contoh dgn menggunakan Kertas)


 


EXTRA TAMBAHAN

(Permasalahan Ukuran MapPlastik dgn Odner)

“lupa/alfa” mengukur kesesuaian Odner utama dgn MapPlastik mengakibatkan LEBAR MapPlastik berlebih/keluar batas ketika dimasukkan ke Odner utama”



SOLUSI!

Pemilihan Odner

Tidak semua Odner dan MapPlastik tidak bisa diselaraskan. Di saya, solusi nya dgn menggunakan Odner dgn brand COMBO bukan PAKAR seperti pada CONTOH below:

Non-Standard Encoding saat proses Convert ke format aplikasi2 Microsoft Office (dan setipenya) | IMAGE TO OFFICE

Guys

Pernah punya masalah begini ga pas convert PDF

Masalahnya nongol error yg ditunjukkan dgn balon text berkisar kira-kira masalah kesulitan menconvert dikarenakan source tidak dikenal dgn baik aka "non-standard encoding"


Update ke PDF converter terbaru ya guys

Kemungkinan karena belum update ke versi converter yg mengenali pengkodean PDF terbaru

Kalo saya mah karena soal hepeng jg jadi ya cukup pake software online yg "free limited" jg gpp

Jadi ngakalinnya, daripada kebutuhan pengenalan pengkodean PDF terbaru...
Gw crop aja halaman website (dalam hal ini kasus nya tabel yg ada di website) yg mo gw convert secara image, bukan secara print ke PDF baru gw convert ke (dalam hal ini) program spreadsheet

Gunakan ini ya guys 

 imagetoexcel.com

Dengan website tool online tersebut memudahkan gw convert (dalam hal ini) table dr website (yg memuat tabel data yg gw inginkan), yg masalah (di gw) nya yakni website source ini menggunakan pengkodean "non-standard encoding" 


Lampiran Sequences of Work

(sampel: https://www.prosperity.com/rankings)

Website appearance

PART ONE Convert ERROR
1) web to pdf

2) pdf to excel BY NitroPDF (error showed!)

PART TWO [main] Convert SUCCESS
1) Web to image (imagetoexcel.com) to Ms. Excel Spreadsheet

2) Result in website application interface shown

nb:
download button (at the bottom)

3) Result in Excel
additional tips to repair "number format"
(i) block 
(ii) copy and paste
      a) error code will be shown in triangle at top left corner of each cell
      b) click the main triangle showing error in top left corner of all   
     c) click and choose to "convert to number"

     d) done and check for mathematic calculation




Thank you guys!

Happy ngeCat Lemari Kayu for REUSED!

Agan2 sekalian
Mo curhat nukang
Sekalian share ketululan ane

Jadi gini
Gw disuruh Emak ngeCat lemari pakaian yg berjamur
Mo dibuang kan sayang
Sangat sangat bisa dipergunakan kembali
600rb geto (harga toko onsite)

Dan
Gw memutuskan bereksperimen menggunakan cat minyak
Bukan nya pilox gitu
Soal nya gw ada kompresor cat mini yg rada jarang gw pergunakan

Awal nya gw beli cat minyak 100ml 2 kaleng
Pada akhirnya jadi 6 kaleng gitu
Dan pada saat pengerjaan
Ketika mencampur dgn thinner
Malah gw ngeyel dr anjuran internet yg gw baca, yaitu 1:3/4 (1 kaleng cat utk 3/4 pernis)
Gw pake nya jadi 1:1/2
Dalam hati biar hasil nya OK (gw kira)
Dengan asumsi cat tebal nanti nya

Dan ternyata!!!
Malah MACET semprotan nya!
Solusi nya harus ditambahkan thinner lagi biar encer dan semprotable

Gw harus nya patuh sama referensi internet utk campuran nya harus nya 1:3/4 (4:3), jangan 2:1 (4:2)
Setelah gw tambahkan thinner lagi
Lancar tenan semprotan pengecatan gw!
Memang agak shock dr yg awal nya kekentalan macet2 jd "terasa" over semburan nya

Jangan lupa ya agan2 utk hati2 dgn tekanan spray yg sudah 4:3
Tetap usahakan rada jauhan lebih kurang 30cm dan tipis2 per tiap pengecatan yg jg dgn interval 20 menit

Hasil pengecetan gw kurang memuaskan karena tdk efisien dan rapi dr awal
Pengecatan boros dan tidak merata (maklum newbie gan!)
Dan berhubung sudah habis 6 kaleng
Males ah gw beli lagi utk merapikan
Pusying krn sudah habis 200rb!
Kan lemari nya cuma 600rb jg 

OK
Sekian share ana ya!
😃

nb: 
korban "proses belajar" mengecat ana 🤭

LPK Sekolah TInggi Teknik Immanuel Medan (Aneka macam kursus2; termasuk didalamnya OTOMOTIF!)

 Guys!

Di Medan ada lembaga pelatihan utk yg berminat ber"tukang-tukang" ria lho!

Sembari tentu nya yg fokus utk lahan mata pencaharian 😀


Gw berminat tp belum kesampaian 😓



Cekidot dan silahkan dipertimbangkan khusus utk teman2 di Medan! 😁