Skip to content
Novus Examples
xlsx10.1 KB

Juniper Workspace Cloud: Subscription billing workbook

Subscription billing workbook for Juniper Workspace Cloud. Five worksheets carrying the whole set: Invoice register (17 rows), September lines (9), MRR movement (6), Usage bill (6) and Revenue recognition (15). Amounts are stored as text so a reader cannot silently change a cent through a float conversion.

Rendered preview of Juniper Workspace Cloud: Subscription billing workbook

Rendered preview of the xlsx file (10.1 KB). Download above for the original.

Specifications

Document Set
saas
Industry
software
Source Kit
saas-subscriptions
Synthetic
true
As Of
2026-09-08
Sheets
5
Rows
53

Testing contract

Expected to pass
Scenario
Open the workbook and reconcile the MRR movement sheet against the September lines sheet without leaving the file.
Expected result
The recurring lines on the September lines sheet sum to 235.00, which is the opening row of the MRR movement sheet, and the movement sheet closes at 236.00. All five sheets carry a header row and freeze it.

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

“Juniper Workspace Cloud: Subscription billing 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: 53 rows · 5 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("subscription-billing.xlsx")
ws = wb.active
print(ws.title, ws.max_row, ws.max_column)

Generated by generation/industry_documents.py. Free for any use, no attribution required, license.