4P Salary

Upload a rate sheet and a staff data sheet to calculate 4P salary by carat brackets.

📋 File 1: Rate Sheet

Columns (Row 1): min, max, rate, unit

  • • min = minimum carat
  • • max = maximum carat
  • • rate = calculation rate
  • • unit = pc/pcs (use Iss Pc × Rate) or ct (use Iss Wt × Rate)

📋 File 2: Staff Data Sheet

Columns (Row 1): Iss Wt, Iss Pc, Employee Name

  • • Iss Wt is matched to rate sheet (min ≤ Iss Wt ≤ max)
  • • If unit is pc or pcs: amount = Iss Pc × Rate
  • • If unit is ct: amount = Iss Wt × Rate

Output

One row per employee. Columns: Employee Name, then for each rate bracket (min–max): Pc, Wt, Amount, and a final Total column.