YoureOnTime StaffTimeCardSummary Telerik report adapter. Telerik report type: "YoureOnTime.Web.TelerikReports.StaffTimeCardSummary, YoureOnTime.Reports" Sheet name: "StaffTimeCard" (NOT "StaffTimeCardSummary" — the plan placeholder was wrong; confirmed from the captured XLSX fixt
// YoureOnTime StaffTimeCardSummary Telerik report adapter.
//
// Telerik report type:
// "YoureOnTime.Web.TelerikReports.StaffTimeCardSummary, YoureOnTime.Reports"
//
// Sheet name: "StaffTimeCard" (NOT "StaffTimeCardSummary" — the plan placeholder was wrong;
// confirmed from the captured XLSX fixture in sample-staff-timecard-findings.md).
//
// The workbook is 26 columns wide. Layout repeats for each location → each staff member:
//
// [location header row] col[0] = location name, other cols empty
// [staff name row] col[0] = '', col[1] = staff name, other cols empty
// [subheader A row] col[11] = "Scheduled" (skip)
// [subheader B row] empty / merge row (skip)
// [column header row] col[0] = "Date" (skip)
// [shift data rows...] col[0] matches /^\d{4
... (truncated -- full source via MCP)
See the full source, get the GitHub permalink, and search 40K more like it.
Get a free API key