Cobalt Operations Team: Hours and payroll workbook
Hours and payroll workbook for Cobalt Operations Team. Two worksheets: Shifts (48 rows) and Register (9 rows). The Register sheet is derived entirely from the Shifts sheet plus the declared rates, so the workbook carries the input and the output of one payroll run and both total 9072.00 gross.
Rendered preview of the xlsx file (8.3 KB). Download above for the original.
Specifications
- Document Set
- payroll
- Industry
- people-operations
- Source Kit
- people-operations
- Synthetic
- true
- As Of
- 2026-09-08
- Sheets
- 2
- Shifts
- 48
- Employees
- 8
Testing contract
Expected to pass- Scenario
- Open the workbook and rebuild the Register sheet from the Shifts sheet.
- Expected result
- Grouping the 48 Shifts rows by employee and applying the rates reproduces all 8 Register rows including net pay, and both sheets agree on 9072.00 of gross.
What is a .xlsx file?
XLSX is the default Microsoft Excel format, an Office Open XML spreadsheet stored as a ZIP archive containing worksheet XML, shared strings, styles, and formulas. It supports multiple sheets, cell formatting, charts, and calculated values. It is the standard for editable tabular workbooks.
How to use this file
Use an example XLSX to test spreadsheet parsing, formula and multi-sheet handling, shared-string extraction, and pipelines that read or generate Excel workbooks.
How to use this file for testing
“Cobalt Operations Team: Hours and payroll workbook” is a deterministic Novus Examples fixture for Data import. Realistic faker-generated datasets with documented schemas for testing import and ETL flows.
Documented properties for this file: 2 sheets. Compare results against paired or grouped companions on this page when present (clean↔damaged, searchable↔scanned, or format twins) so scores stay reproducible across runs.
Download the file once, keep the path stable in CI or local scripts, and treat the spec table as the contract: dimensions, seeds, field lists, and roles are intentional. Corrupt or invalid samples are labelled as such, expect parsers to fail loudly rather than silently accept them.
Document fixtures list their internal structure (pages, fields, tracked changes, embedded objects) in the spec table. Test extractors, converters, and OCR against that known structure, and compare searchable↔scanned or format-twin companions when present.
Code examples
from openpyxl import load_workbook
wb = load_workbook("timesheet-hours.xlsx")
ws = wb.active
print(ws.title, ws.max_row, ws.max_column)Related files
- mdCobalt Operations Team: Document set READMEDocument set README for Cobalt Operations Team. 29 files, 1 of them intentionally invalid, with the reconciliation identities and the exact defect in each broken file named in full.
- xlsxCobalt Operations Team: Leave workbookLeave workbook for Cobalt Operations Team. Two worksheets: Balances (9 rows including TOTAL) and Requests (4 rows). The approved requests on the second sheet are the approved_future_hours on the first; the pending ones are not, which is visible by comparing the two sheets side by side.
- xlsxCobalt Operations Team: Payroll register workbookPayroll register workbook for Cobalt Operations Team. One worksheet with the 8 employee rows and the TOTAL row, the same values as payroll-register.csv. Amounts are stored as text with two decimals, so a net pay ending in a zero cent is not displayed short and cannot be silently re-rounded by a recalculation.
- pdfCobalt Operations Team: Payroll summary PDFPayroll summary PDF for Cobalt Operations Team. A one-page summary of the run. The employee table closes on 9,072.00 gross, (2,422.56) of deductions and 6,649.44 net; the deduction analysis splits the same 2,422.56 three ways; and the employer cost table adds 1,470.17 of employer contributions to reach 10,542.17.
- pdfCobalt Operations Team: Payslip PDF for EMP-03Payslip PDF for EMP-03 for Cobalt Operations Team. A one-page payslip for Team member 3. The period table runs 1,008.00 gross through three deductions to 734.16 net, the employer-cost table shows 30.24, 77.11 and 63.00 that are not deducted from pay, and the year-to-date table shows 5 periods at 3,670.80 net.
- pdfCobalt Operations Team: Payslip PDF for EMP-08Payslip PDF for EMP-08 for Cobalt Operations Team. A one-page payslip for Team member 8. The period table runs 1,428.00 gross through three deductions to 1,057.56 net, the employer-cost table shows 42.84, 109.24 and 63.00 that are not deducted from pay, and the year-to-date table shows 5 periods at 5,287.80 net.
Generated by generation/industry_documents.py. Free for any use, no attribution required, license.