TPM Salary

📋 File 1: Rate Sheet

Required columns (row 1 header):

• • From — weight range start (in carats)
• • To — weight range end (in carats)
• • Rate — salary rate for this bracket
• • Unit — pcs (salary = Rate × Iss Pc) or ct (salary = Rate × Dm Wt)

Last row must have DL KAPAN in the From column with its rate — applied to all rows where Cut No starts with "DL".

📋 File 2: TPM Detail Sheet

Required columns (any order):

• • Iss Factory Name — employee name
• • Cut No — if starts with "DL" (e.g. DL-7), the DL Kapan rate is used instead of the weight bracket
• • Iss Pc — pieces issued
• • Dm Wt — diamond weight (used for bracket lookup and ct-based calculation)