Shared Guides

• Magic eP
• eP Specifications
• eP Harga
• Bidding Price — Peralatan
• Bidding Price — ICT
• Recommended Apps
• Inventory-Related Apps
• Design Apps - Alternatives for Adobe Photoshop & Illustrator
• Productivity Apps

Magic eP

eP Specifications

How to:

1. Upload excel files containing the specifications as extracted from ePerolehan website.
2. Click the Run all button or run for individual excel files.
3. Copy the script that will automatically filled in the details and remarks.
4. Click Compliance button to copy the script for Ya/Tidak options.
   

---

1 - Upload file

2 - Click Run

3 - Copy script

Example:

maklumbalas_arr = [`1 PPHD 1001 ROTARY HAMMER DRILL`,
`Please specify the product country origin, brand name and model number
The ROTARY HAMMER DRILL should have minimum requirement as below :
1.0 GENERAL SPECIFICATION / DESCRIPTION
1.1 The tool for hammer drilling in concrete, brick and stone. It is also suitable for wood, metal, ceramic and plastic.
1.2 Electronic control and forward/reverse rotation`,
]

catatan_arr = [``,
]


var textareas = document.querySelectorAll('textarea[id^="_scSupplierProposal_WAR_NGePportlet_:form:j_idt"]');
var id = textareas[0].id.match(/idt(\d+)/)[1];

maklumbalas_arr.forEach((data, i) => {
  var txt = document.getElementById(`_scSupplierProposal_WAR_NGePportlet_:form:j_idt${id}:questionTbl:${i}:answerText`);
  if (txt!=null) {
    txt.value = data;
  }
});

catatan_arr.forEach((data, i) => {
  var remarks = document.getElementById(`_scSupplierProposal_WAR_NGePportlet_:form:j_idt${id}:questionTbl:${i}:answerRemarks`);
  if (remarks!=null) {
    remarks.value = data;
  }
});

4 - Optional Actions (Download, View cleaned)

• Download button lets you download the code/script above.
• View cleaned button lets you see the information that will be filled in including the characters length of each row data.
  • Future improvements: Highlight the row with >1000 length.

eP Harga

How to:

1. Copy price list from excel file and paste it in "List Harga". For example: 2,250.00 7,100.00 5,397.00
2. Fill in the remarks Catatan.
3. Click the Run button.
4. Copy the output on the left side to automatically fill in the prices and remarks.
5. (Optional) Copy the output on the right side to change only the remarks Catatan for other bidding companies.

---

Example after running the program

Bidding Price — Peralatan

How to:

1. Copy the items' prices from excel file and paste it in the field List Harga
2. Copy the items' units from excel file and paste it in the field Units
3. Copy the bidding companies' target prices and paste it in the field Targets
4. Click the Run button.
5. Copy the output.

---

Example after running the program

Bidding Price — ICT

How to:

1. Copy one example of items' prices from excel file and paste it in the field List Harga
2. Copy the items' units from excel file and paste it in the field Units
3. Copy the number of months from excel file and paste it in the field Months
4. Copy the bidding companies' target prices and paste it in the field Targets
5. Set the first item price for each targets in Lock Price Item 1

   • If there is only one item, this field will be ignored and the bidding price will be calculated as follows;
     Price = Target ÷ (Units × Months)
     

6. Click the Run button.
7. Copy the output.

---

Case 1 — Predict prices for multiple items

Case 2 — Predict price for one item

Recommended Apps

Inventory-Related Apps

Mobile Inventory by Bino Solutions (For Android Users)

play.google.com/store/apps/details?id=ro.bino.inventory&hl=en

Inventory app for stock counting, barcode scanning, stock taking, and warehouse inventory management.

Mobile Inventory helps you count stock as a team, scan barcodes fast, and track quantities across one or many locations from a phone or tablet. It works offline, has no ads, and keeps stock control simple for daily operations, audits, and warehouse workflows.

---

Inventory Scanner Stock Count (For Iphone Users)

apps.apple.com/my/app/inventory-scanner-stock-count

Scan barcodes, update quantities automatically, and export clean CSV files for Excel or Sheets.

Inventory Scanner Stock Count is built for small businesses, sellers, and operators who need a fast way to scan barcodes,
count stock, and export the result.

Start a count session, scan items, and keep moving. Duplicate scans automatically update quantities, so you do not have to
stop after every item. Review your live count list, edit quantities, rename items, and search inside the session when needed. When the count is done, export a clean CSV file that is easy to open in Excel, Google Sheets, or your own workflow. Use
recount and variance review tools when you need to compare expected and counted quantities.

Use it for:

• Small business stock counts
• Pop-up shop inventory checks
• Event seller inventory
• Backroom or shelf counts
• Office, asset, or library counts
• Simple barcode-based item counts

It focuses on one job: scan items, count stock, and export clean CSV.

Design Apps - Alternatives for Adobe Photoshop & Illustrator

affinity by Canva

affinity.studio/get-affinity

Productivity Apps

Raycast

www.raycast.com/windows

Your shortcut to everything
A collection of powerful productivity tools all within
an extendable launcher. Fast, ergonomic and reliable.

Microsoft PowerToys

github.com/microsoft/PowerToys

Microsoft PowerToys is a collection of utilities that help you customize Windows and streamline everyday tasks.