WORKBOOKLOGICAL VS PHYSICAL SUMMARY
BUILDER
createWorkbook()SHEETS
1OOXML PARTS
5 filesFEATURES
5DATASET
smallA compact artifact that makes sub-row expansion and row-aware summaries legible by showing logical rows and physical rows side by side.
schema.ts
Logical vs PhysicalA1:E15, frozen at C2
click a cell to inspect itfx
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
Logical Rows vs Physical Rows
Customer
Segment
Monthly Amount
Row Avg
Row Total
Northwind Labs
Startup
$10.00
$20.00
$60.00
$20.00
$30.00
Helios Systems
Enterprise
$100.00
$150.00
$300.00
$200.00
Pinecrest Health
Enterprise
$80.00
$125.00
$500.00
$120.00
$140.00
$160.00
Physical total
$860.00
Physical average
$95.56
Logical average
$98.33
$98.33
Logical sum
$295.00
$860.00
Cell in the file