1{2 "version": 5,3 "names": {"Lost": "#REF!", "Rate": "Lists!B1", "Units": "Sales!C2:C9"},4 "macroOrigin": "fixture-machine",5 "macros": [6 {"name": "Bold header", "key": "1", "api": 1, "source": "select(\"A1:E1\")\nrun(\"format.bold\")\n"},7 {"name": "Fill totals", "api": 1, "source": "set(\"F2\", \"=SUM(C2:C9)\")\n"}8 ],9 "sheets": [10 {11 "name": "Sales",12 "widths": {"A": 12, "E": 14},13 "lines": {"A:XFD": {"italic":true}, "D:D": {"format":"currency","decimals":2}, "1:1": {"bold":true,"align":"center"}},14 "freeze": {"rows":1,"cols":1},15 "filter": {"range":"A1:E9","columns":{"B":{"hidden":["West"]},"C":{"condition":"gt","value":"2"}}},16 "protected": [{"range":"E2:E9","description":"Totals"}],17 "cells": {18 "A1": "Date",19 "B1": "Region",20 "C1": "Units",21 "D1": "Price",22 "E1": "Total",23 "G1": "Share",24 "H1": "Regions",25 "I1": "Scaled",26 "A2": {"input":"2026-01-05","format":"date"},27 "B2": "North",28 "C2": "3",29 "D2": "12.5",30 "E2": {"input":"=C2*D2","format":"currency","decimals":2,"own":true},31 "G2": {"input":"=C2/SUM(Units)","format":"percent","decimals":1},32 "H2": "=SORT(UNIQUE(B2:B9))",33 "I2": "=LET(r, Rate, MAP(C2:C4, LAMBDA(x, x*r)))",34 "A3": {"input":"2026-01-12","format":"date"},35 "B3": {"input":"South","note":"Includes returns"},36 "C3": "5",37 "D3": "9.75",38 "E3": "=C3*D3",39 "G3": {"input":"=C3/SUM(Units)","format":"custom","pattern":"0.00%;[Red]-0.00%"},40 "A4": {"input":"2026-02-02","format":"date"},41 "B4": "West",42 "C4": "1",43 "D4": "40",44 "E4": "=C4*D4",45 "A5": {"input":"2026-02-16","format":"date"},46 "B5": "North",47 "C5": "7",48 "D5": "12.5",49 "E5": "=C5*D5",50 "A6": {"input":"2026-03-01","format":"date"},51 "B6": "East",52 "C6": {"input":"2","bold":true,"italic":true,"underline":true,"strikethrough":true},53 "D6": "22",54 "E6": "=C6*D6",55 "A7": {"input":"2026-03-09","format":"date"},56 "B7": "South",57 "C7": {"input":"4","align":"left"},58 "D7": "9.75",59 "E7": "=C7*D7",60 "A8": {"input":"2026-03-20","format":"date"},61 "B8": "East",62 "C8": "6",63 "D8": "22",64 "E8": "=C8*D8",65 "A9": {"input":"2026-03-31","format":"date"},66 "B9": "West",67 "C9": "8",68 "D9": "40",69 "E9": "=C9*D9",70 "A11": {"input":"A long title merged across three columns","align":"center"},71 "A12": "Tall",72 "B12": "clipped text that does not spill over",73 "C12": "TRUE",74 "D12": "=IFERROR(1/0, \"none\")",75 "E12": {"input":"=Lists!B1*2","format":"number","decimals":3},76 "F12": "'00123",77 "F13": "=HYPERLINK(\"https://example.com\", \"site\")"78 },79 "charts": [80 {"type":"column","data":"A1:C9","at":"K2","width":40,"height":12,"header":true,"labels":true,"title":"Units by date"},81 {"type":"line","data":"C1:E9","at":"K16","width":36,"height":10,"header":true,"stack":"stacked","trend":true,"min":0,"max":400,"gridlines":false,"legend":"none"},82 {"type":"pie","data":"B1:C5","at":"K28","width":30,"height":10,"header":true,"labels":true,"legend":"right"},83 {"type":"scatter","data":"C1:D9","at":"K40","width":30,"height":10,"header":true,"trend":true,"log":true},84 {"type":"bar","data":"B1:C9","at":"K52","width":30,"height":10,"header":true,"stack":"percent"},85 {"type":"area","data":"C1:D9","at":"K64","width":30,"height":10,"byRow":true,"header":true}86 ],87 "conditionalFormats": [88 {"ranges":"C2:C9","condition":"gt","values":["5"],"text":"red","bold":true},89 {"ranges":"B2:B9","condition":"contains","values":["th"],"fill":"yellow","italic":true},90 {"ranges":"E2:E9","condition":"formula","values":["=$C2\u003e4"],"text":"green","strikethrough":true},91 {"ranges":"C2:C9","condition":"between","values":["2","4"],"fill":"cyan"},92 {"ranges":"D2:D9","scale":[{"type":"min","color":"green"},{"type":"percentile","value":"50","color":"yellow"},{"type":"max","color":"red"}]}93 ],94 "validations": [95 {"ranges":"B2:B9","criteria":"list","items":["North","South","East","West"],"help":"Pick a region"},96 {"ranges":"C2:C9","criteria":"number","condition":"between","values":["0","80"],"reject":true},97 {"ranges":"A2:A9","criteria":"date","condition":"gt","values":["2025-12-31"]},98 {"ranges":"C12","criteria":"checkbox"},99 {"ranges":"F2:F9","criteria":"range","source":"Lists!A1:A4"},100 {"ranges":"G5:G9","criteria":"length","condition":"le","values":["10"]},101 {"ranges":"H12","criteria":"formula","values":["=H12\u003c\u003e\"\""]}102 ]103 },104 {105 "name": "Lists",106 "hidden": true,107 "protected": [{"sheet":true}],108 "cells": {109 "A1": "North",110 "B1": {"input":"1.5","note":"Rate used by Sales!I2"},111 "A2": "South",112 "A3": "East",113 "A4": "West"114 }115 },116 {117 "name": "Pivot Table 1",118 "cells": {},119 "pivot": {"source":"Sales!A1:E9","rows":[{"column":"B"},{"column":"A","order":"desc","sortBy":1}],"columns":[{"column":"C"}],"values":[{"column":"E","summarize":"sum"},{"column":"C","summarize":"counta","showAs":"percent_of_total","name":"Share"}],"filters":[{"column":"B","hidden":["West"]}],"rowTotals":true,"columnTotals":false}120 },121 {122 "name": "Notebook 1",123 "widths": {"A": 20},124 "cells": {}125 }126 ]127}