Juniper Workspace Cloud: Tiered usage bill
Tiered usage bill for Juniper Workspace Cloud. 6 accounts billed on the rate card. The tier columns split each account's exports across the three bands and always sum back to billable_exports. Export charges total 16.65, storage charges 7.89 and the usage bill 24.54. Account ACC-06 is the only one to reach the third tier, with 1 unit above 20.
csv
text/csv
- Document Set
- saas
- Industry
- software
- Source Kit
- saas-subscriptions
- Synthetic
- true
- As Of
- 2026-09-08
- Rows
- 6
Binary csv: no in-browser preview. Download it above to open in a compatible application.
Specifications
- Document Set
- saas
- Industry
- software
- Source Kit
- saas-subscriptions
- Synthetic
- true
- As Of
- 2026-09-08
- Rows
- 6
- Export Charges
- 16.65
- Storage Charges
- 7.89
- Usage Total
- 24.54
- Encoding
- UTF-8
Testing contract
Expected to pass- Scenario
- Recompute each account's charge from usage-events.csv and usage-rate-card.csv.
- Expected result
- For every row tier1 + tier2 + tier3 equals billable_exports, export_charge equals tier2 * 0.4000 + tier3 * 0.2500, and storage_charge equals chargeable_storage_mb * 0.0150 rounded half up. The columns sum to 16.65, 7.89 and 24.54.
What is a .csv file?
CSV (Comma-Separated Values) is a plain-text tabular format where rows are lines and fields are separated by commas, with quoting rules for values that contain delimiters, quotes, or newlines. It has no formal type system and depends on encoding and dialect conventions. It is the most portable format for tabular data exchange.
How to use this file
Use an example CSV to test parsers against quoting and embedded-delimiter edge cases, header handling, encoding detection, and import pipelines into databases or spreadsheets.
How to use this file for testing
“Juniper Workspace Cloud: Tiered usage bill” 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: 6 rows · UTF-8. 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.
Data fixtures document their exact quirks (delimiters, encodings, null handling, schema, and row counts) in the spec table. Point your parser or importer at the file and assert it handles the documented edge cases; clean and deliberately-messy siblings make before/after diffs straightforward.
Code examples
import pandas as pd
df = pd.read_csv("usage-billing-tiered.csv")
print(df.head())
print(df.dtypes)Related files
- jsonJuniper Workspace Cloud: Billing reconciliation assertionsBilling reconciliation assertions for Juniper Workspace Cloud. The six identities this set claims with their exact figures: opening MRR 235.00, closing MRR 236.00, September invoiced 245.00, usage 24.54 and lifetime billings equal to recognition at 1963.20.
- csvJuniper Workspace Cloud: Closing MRR by accountClosing MRR by account for Juniper Workspace Cloud. 6 accounts with the plan each one holds at 2026-09-30 and the recurring revenue that plan carries. Two accounts are cancelled and carry 0.00; the remaining four sum to 236.00, the closing figure on mrr-movement.csv.
- csvJuniper Workspace Cloud: Dunning sequenceDunning sequence for Juniper Workspace Cloud. The 6 escalation steps against invoice INV-10 for account ACC-04, the one invoice in the model carrying an outstanding balance of 19.00. Steps run 2026-09-01 to 2026-09-30: reminder, two card retries that fail on insufficient_funds, a final notice, a third retry that fails on do_not_honor, then cancellation. Each row's next_action_date equals the attempt_date of the following row, and the last row has none.
- jsonJuniper Workspace Cloud: Dunning sequence JSONDunning sequence JSON for Juniper Workspace Cloud. The same 6 steps as dunning-sequence.csv with the retry policy and the terminal state named. terminalState is cancelled.
- csvJuniper Workspace Cloud: Failed payment attempt logFailed payment attempt log for Juniper Workspace Cloud. The 3 card attempts behind the dunning sequence, with UTC timestamps, the gateway status and the decline code. All three are for 19.00 against invoice INV-10 and all three failed, which is why the balance never moves.
- csvJuniper Workspace Cloud: Invoice register widened to 40 columnsInvoice register widened to 40 columns for Juniper Workspace Cloud. The same 17 invoices as invoice-register.csv followed by 29 empty custom_field_NN columns, 40 in total. Every custom field is present in the header and empty in every row, which is what a billing platform export looks like when the tenant has defined no custom fields.
Generated by generation/industry_documents.py. Free for any use, no attribution required, license.