Managing Workbooks¶

Workbooks are the foundation of CalcBridge. This guide covers everything you need to know about uploading, viewing, editing, organizing, and managing your Excel workbooks in the platform.

Overview¶

A workbook in CalcBridge represents an uploaded Excel file containing one or more sheets with data and formulas. Once uploaded, CalcBridge:

1. Parses all sheets, cells, and formulas
2. Validates formula syntax and references
3. Stores the data in a secure, multi-tenant database
4. Enables calculations, compliance testing, and what-if scenarios

Uploading Workbooks¶

Upload via UI¶

Upload via API¶

curl -X POST https://api.calcbridge.io/api/v1/workbooks/upload \
  -H "Authorization: Bearer $TOKEN" \
  -F "file=@portfolio.xlsx" \
  -F "name=Q1 2025 Portfolio" \
  -F "tags=quarterly,portfolio"

Upload Options¶

Upload Validation¶

During upload, CalcBridge validates:

• File format and integrity
• Formula syntax across all sheets
• Cell references (internal and cross-sheet)
• Data types and formats
• File size limits (max 100MB)

Viewing Workbook Data¶

Workbook Details Page¶

Click any workbook to open its details page, which includes:

• Summary - Basic info, metadata, and status
• Sheets - List of all sheets with row/column counts
• Formulas - Formula cells and their dependencies
• History - Upload and calculation history
• Compliance - Latest compliance test results

Viewing Sheet Data¶

1. Click on a sheet name to open the data viewer
2. Use the grid to browse cells
3. Click any cell to see its value and formula (if applicable)

Grid Navigation¶

Viewing Formulas¶

To view formulas in a sheet:

1. Toggle the Show Formulas switch in the toolbar
2. Cells display formulas instead of calculated values
3. Formula dependencies are highlighted when a cell is selected

Cell B5 contains: =SUM(B2:B4)
Dependencies: B2, B3, B4
Dependents: B10 (where B5 is referenced)

Editing Data¶

Inline Editing¶

CalcBridge supports inline editing of cell values:

1. Double-click a cell to enter edit mode
2. Modify the value or formula
3. Press Enter to save or Esc to cancel
4. Formulas are automatically recalculated

Batch Editing¶

For bulk updates, use the batch edit feature:

1. Select a range of cells
2. Click Edit Selected in the toolbar
3. Apply transformations:
   • Set value (replace all with a single value)
   • Apply formula (apply the same formula to all cells)
   • Find and replace
4. Review changes and confirm

Editing via API¶

# Update a single cell
curl -X PUT https://api.calcbridge.io/api/v1/workbooks/{id}/sheets/{sheet}/data/A1 \
  -H "Authorization: Bearer $TOKEN" \
  -H "Content-Type: application/json" \
  -d '{"value": 12345.67}'

# Update multiple cells
curl -X PATCH https://api.calcbridge.io/api/v1/workbooks/{id}/sheets/{sheet}/data \
  -H "Authorization: Bearer $TOKEN" \
  -H "Content-Type: application/json" \
  -d '{
    "updates": [
      {"cell": "A1", "value": 100},
      {"cell": "A2", "value": 200},
      {"cell": "B1", "formula": "=A1+A2"}
    ]
  }'

Edit History¶

All edits are tracked in the workbook's history:

• Who made the change
• When the change was made
• What was changed (old value, new value)
• Why (optional comment)

Access edit history from the workbook's History tab.

Organizing Workbooks¶

Tags¶

Use tags to categorize and filter workbooks:

Examples:
- quarterly, monthly, weekly (frequency)
- portfolio-a, portfolio-b (portfolio)
- trustee, internal, audit (purpose)
- 2024, 2025 (year)

Managing Tags¶

1. Open workbook details
2. Click the Tags section
3. Add or remove tags
4. Tags appear in the workbook list for filtering

Folders¶

Organize workbooks into folders for hierarchical structure:

CLO Portfolios/
+-- ABC CLO 2024/
|   +-- Q1 Trustee Report.xlsx
|   +-- Q2 Trustee Report.xlsx
+-- XYZ CLO 2023/
    +-- Monthly Portfolio.xlsx

Creating Folders¶

1. Navigate to Workbooks
2. Click New Folder
3. Enter folder name
4. Drag workbooks into folders or use Move to Folder action

Filtering and Searching¶

The workbook list supports powerful filtering:

Combine filters with boolean operators:

tag:quarterly AND uploaded:2025 AND status:calculated

Deleting Workbooks¶

Single Deletion¶

1. Navigate to Workbooks
2. Click the ... menu on the workbook
3. Select Delete
4. Confirm the deletion

Bulk Deletion¶

1. Select multiple workbooks using checkboxes
2. Click Delete Selected in the toolbar
3. Review the list of workbooks to delete
4. Confirm the deletion

Deletion via API¶

# Delete a single workbook
curl -X DELETE https://api.calcbridge.io/api/v1/workbooks/{id} \
  -H "Authorization: Bearer $TOKEN"

# Delete multiple workbooks
curl -X POST https://api.calcbridge.io/api/v1/workbooks/batch-delete \
  -H "Authorization: Bearer $TOKEN" \
  -H "Content-Type: application/json" \
  -d '{"ids": ["uuid-1", "uuid-2", "uuid-3"]}'

Archiving vs Deleting¶

Instead of deleting, consider archiving workbooks:

1. Move to an Archive folder
2. Add an archived tag
3. Set retention policy

Archived workbooks remain searchable and accessible for audit purposes.

Workbook Properties¶

Metadata¶

Each workbook stores the following metadata:

Status¶

Workbooks have the following status values:

Best Practices¶

Naming Conventions¶

Use consistent, descriptive names:

[Deal Name] - [Report Type] - [Period]

Examples:
- ABC CLO 2024-1 - Trustee Report - Q1 2025
- XYZ Portfolio - Compliance Test - 2025-01-15
- Monthly Holdings - January 2025

Version Control¶

Maintain version history by:

1. Including dates in filenames
2. Using the Duplicate feature to create new versions
3. Adding version tags (e.g., v1, v2, draft, final)

Data Quality¶

Before uploading, ensure your Excel files:

• Have valid formulas (no #REF! or #NAME? errors)
• Use consistent column headers
• Avoid merged cells in data ranges
• Remove unnecessary formatting

Troubleshooting¶

Common Upload Issues¶

Common Editing Issues¶

For more troubleshooting help, see the Troubleshooting Guide.