WORKBOOKQUARTERLY REVENUE REVIEW
BUILDER
createWorkbook()SHEETS
4OOXML PARTS
18 filesFEATURES
8DATASET
mediumOrders become a plan-vs-actual overview with a combo chart, a quarterly pivot by region with its pivot chart, and a channel mix with a doughnut.
schema.ts
OverviewA1:P14, frozen at A3
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
Revenue vs plan, last 12 months
Month
Revenue
Plan
vs plan
Cost
Margin %
Oct 25
980,197
1,000,000
-2.0%
333,342
66.0%
Nov 25
1,012,747
1,040,000
-2.6%
331,400
67.3%
Dec 25
982,448
1,080,000
-9.0%
310,631
68.4%
Jan 26
1,081,085
1,120,000
-3.5%
357,613
66.9%
Feb 26
1,112,756
1,160,000
-4.1%
376,108
66.2%
Mar 26
1,097,631
1,200,000
-8.5%
371,414
66.2%
Apr 26
1,225,232
1,240,000
-1.2%
392,007
68.0%
May 26
1,222,241
1,280,000
-4.5%
409,780
66.5%
Jun 26
1,496,494
1,320,000
+13.4%
523,869
65.0%
Jul 26
1,396,096
1,360,000
+2.7%
466,147
66.6%
Aug 26
1,341,912
1,400,000
-4.1%
437,158
67.4%
Sep 26
1,619,975
1,440,000
+12.5%
520,331
67.9%
Cell in the file