1. Operations Workbook Optimization
Background
A large operations workbook contains monthly data that is difficult to navigate due to the lack of frozen headers and unorganized data blocks.
Problem
The user needs to keep the top header row visible and group specific data ranges to make the sheet easier to read.
How to use
Upload the file, set 'Freeze Rows' to 1, and provide the grouping JSON to define the data blocks.
[{"from": 2, "to": 15, "level": 1}, {"from": 16, "to": 28, "level": 1}]Outcome
The first row is locked, and the specified row ranges are organized into collapsible outline groups.