# Single-file HTML: Auto-fills ABKramer-style timesheet from Payout Report.
# Pulls ONLY: Hours Worked, Commission %, Due to Barbers (svc), Product commission (from low-% rows), Tips (total).
# Rules:
# - Managers (Anthony, Krys) = $18/hr; Hailey = $15/hr; others $13/hr
# - If CommissionTotal >= Hours*Rate → Reg Hours left blank. Else Reg Hours = Hours
# - Always include roster even if missing (0s)
# - Columns: Emp Num, Employee Name, S/H, Reg Hours, Comm Amount, CATip Amount, PCTip Amount, Vac Hours, Hol Hours, Reimb Amount, OT Hours, Bonus Amount
# - Simple inline edits allowed; Export CSV / Print
html = r"""
Sharp Top — ABKramer Timesheet (Auto)
"""
open("/mnt/data/sharp-top-abkramer_auto.html","w").write(html)
print("Saved to /mnt/data/sharp-top-abkramer_auto.html")
ABKramer Timesheet
| Emp Num | Employee Name | S/H | Reg Hours | Comm Amount | CATip Amount | PCTip Amount | Vac Hours | Hol Hours | Reimb Amount | OT Hours | Bonus Amount |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Totals |