{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["List","Data","Piv","Calcs","Dash"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":2},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"List","index":0,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["List","Row Labels",null,"Colour","Arrows"]
["Toys","Toys",null,"Green",0.01]
["Clothing",null,null,"Yellow",0]
["Outdoors"]
["All"]

{"sheet":"Data","index":1,"n_rows":193,"n_cols":7,"rows_kept":193,"cut":false,"hidden":false,"merged":[]}
["Year","QTR","Dept","List","Labour","Overheads ","Revenue"]
["CY","Q1","Toys","Admin",293,111,837]
["CY","Q1","Toys","Corporate",227,155,824]
["CY","Q1","Toys","Finance",236,100,764]
["CY","Q1","Toys","HR",246,186,705]
["CY","Q1","Toys","IT ",123,178,894]
["CY","Q1","Toys","Legal",172,155,885]
["CY","Q1","Toys","Marketing",196,154,753]
["CY","Q1","Toys","R&D",292,171,735]
["CY","Q1","Clothing","Admin",106,128,422]
["CY","Q1","Clothing","Corporate",161,124,498]
["CY","Q1","Clothing","Finance",197,166,348]
["CY","Q1","Clothing","HR",200,109,504]
["CY","Q1","Clothing","IT ",103,142,542]
["CY","Q1","Clothing","Legal",193,143,466]
["CY","Q1","Clothing","Marketing",151,149,493]
["CY","Q1","Clothing","R&D",189,144,327]
["CY","Q1","Outdoors","Admin",185,179,488]
["CY","Q1","Outdoors","Corporate",179,169,347]
["CY","Q1","Outdoors","Finance",196,179,541]
["CY","Q1","Outdoors","HR",100,135,362]
["CY","Q1","Outdoors","IT ",189,183,502]
["CY","Q1","Outdoors","Legal",143,190,451]
["CY","Q1","Outdoors","Marketing",143,169,412]
["CY","Q1","Outdoors","R&D",193,102,439]
["CY","Q2","Toys","Admin",351.59999999999997,92.13,887.22]
["CY","Q2","Toys","Corporate",267.86,145.69999999999999,683.92]
["CY","Q2","Toys","Finance",238.36,107,641.76]
["CY","Q2","Toys","HR",214.02,182.28,838.94999999999993]
["CY","Q2","Toys","IT ",141.44999999999999,154.85999999999999,911.88]
["CY","Q2","Toys","Legal",165.12,133.30000000000001,761.1]
["CY","Q2","Toys","Marketing",170.52,143.22,602.4]
["CY","Q2","Toys","R&D",327.04000000000002,138.51000000000002,882]
["CY","Q2","Clothing","Admin",119.77999999999999,152.32,354.47999999999996]
["CY","Q2","Clothing","Corporate",152.94999999999999,119.03999999999999,473.09999999999997]
["CY","Q2","Clothing","Finance",200.94,192.55999999999997,306.24]
["CY","Q2","Clothing","HR",190,95.92,594.71999999999991]
["CY","Q2","Clothing","IT ",87.55,123.54,504.06]
["CY","Q2","Clothing","Legal",218.08999999999997,163.01999999999998,428.72]
["CY","Q2","Clothing","Marketing",144.96,140.06,497.93]
["CY","Q2","Clothing","R&D",173.88,116.64000000000001,356.43]
["CY","Q2","Outdoors","Admin",179.45,161.1,453.84000000000003]
["CY","Q2","Outdoors","Corporate",207.64,189.28000000000003,385.17]
["CY","Q2","Outdoors","Finance",196,214.79999999999998,465.26]
["CY","Q2","Outdoors","HR",82,110.69999999999999,325.8]
["CY","Q2","Outdoors","IT ",215.45999999999998,162.87,602.4]
["CY","Q2","Outdoors","Legal",157.30000000000001,169.1,410.41]
["CY","Q2","Outdoors","Marketing",131.56,165.62,379.04]
["CY","Q2","Outdoors","R&D",179.49,97.92,377.54]
["CY","Q3","Toys","Admin",336.95,118.77000000000001,753.30000000000007]
["CY","Q3","Toys","Corporate",249.70000000000002,168.95000000000002,964.07999999999993]
["CY","Q3","Toys","Finance",212.4,97,893.88]
["CY","Q3","Toys","HR",204.17999999999998,212.04,662.69999999999993]
["CY","Q3","Toys","IT ",135.30000000000001,163.76000000000002,1063.8599999999999]
["CY","Q3","Toys","Legal",170.28,130.19999999999999,938.1]
["CY","Q3","Toys","Marketing",184.23999999999998,183.26,745.47]
["CY","Q3","Toys","R&D",309.52000000000004,193.23,610.04999999999995]
["CY","Q3","Clothing","Admin",107.06,142.08000000000001,358.7]
["CY","Q3","Clothing","Corporate",143.29,110.36,398.40000000000003]
["CY","Q3","Clothing","Finance",228.51999999999998,154.38,285.35999999999996]
["CY","Q3","Clothing","HR",182,88.29,443.52]
["CY","Q3","Clothing","IT ",84.46,124.96,634.14]
["CY","Q3","Clothing","Legal",175.63,121.55,559.19999999999993]
["CY","Q3","Clothing","Marketing",179.69,123.66999999999999,483.14]
["CY","Q3","Clothing","R&D",171.99,151.20000000000002,336.81]
["CY","Q3","Outdoors","Admin",194.25,193.32000000000002,556.31999999999994]
["CY","Q3","Outdoors","Corporate",193.32000000000002,180.83,329.65]
["CY","Q3","Outdoors","Finance",231.28,187.95000000000002,541]
["CY","Q3","Outdoors","HR",88,109.35000000000001,434.4]
["CY","Q3","Outdoors","IT ",187.10999999999999,197.64000000000001,406.62]
["CY","Q3","Outdoors","Legal",117.25999999999999,207.10000000000002,392.37]
["CY","Q3","Outdoors","Marketing",161.58999999999997,197.73,329.6]
["CY","Q3","Outdoors","R&D",165.98,95.88,412.65999999999997]
["CY","Q4","Toys","Admin",407.85599999999994,91.208699999999993,825.11460000000011]
["CY","Q4","Toys","Corporate",297.32460000000003,150.071,642.88479999999993]
["CY","Q4","Toys","Finance",255.04520000000002,126.25999999999999,596.83680000000004]
["CY","Q4","Toys","HR",184.05719999999999,145.82400000000001,914.45550000000003]
["CY","Q4","Toys","IT ",113.16,173.44319999999999,939.2364]
["CY","Q4","Toys","Legal",156.864,143.96400000000003,852.43200000000013]
["CY","Q4","Toys","Marketing",184.16160000000002,147.51660000000001,506.01599999999996]
["CY","Q4","Toys","R&D",317.22880000000004,128.81430000000003,855.54]
["CY","Q4","Clothing","Admin",136.54919999999998,159.93600000000001,308.39759999999995]
["CY","Q4","Clothing","Corporate",182.01049999999998,133.32480000000001,406.86599999999999]
["CY","Q4","Clothing","Finance",217.01520000000002,211.816,361.36320000000001]
["CY","Q4","Clothing","HR",199.5,85.368800000000007,660.13919999999996]
["CY","Q4","Clothing","IT ",98.056000000000012,133.42320000000001,599.83140000000003]
["CY","Q4","Clothing","Legal",235.53719999999998,151.6086,445.86880000000002]
["CY","Q4","Clothing","Marketing",134.81280000000001,138.65940000000001,423.2405]
["CY","Q4","Clothing","R&D",144.32039999999998,125.97120000000002,285.14400000000001]
["CY","Q4","Outdoors","Admin",157.916,183.65399999999997,499.2240000000001]
["CY","Q4","Outdoors","Corporate",191.02879999999999,227.13600000000002,350.50470000000001]
["CY","Q4","Outdoors","Finance",217.56000000000003,236.28,409.42879999999997]
["CY","Q4","Outdoors","HR",69.7,111.80699999999999,364.89600000000007]
["CY","Q4","Outdoors","IT ",174.52259999999998,140.06819999999999,710.83199999999988]
["CY","Q4","Outdoors","Legal",187.18700000000001,191.08299999999997,455.5551000000001]
["CY","Q4","Outdoors","Marketing",106.56360000000001,152.37040000000002,329.76480000000004]
["CY","Q4","Outdoors","R&D",165.13080000000002,109.67040000000001,362.4384]
["PY","Q1","Toys","Admin",281.27999999999997,130.97999999999999,912.33]
["PY","Q1","Toys","Corporate",181.60000000000002,142.6,650.96]
["PY","Q1","Toys","Finance",228.92,96,733.43999999999994]
["PY","Q1","Toys","HR",275.52000000000004,187.86,564]
["PY","Q1","Toys","IT ",129.15,201.14,902.94]
["PY","Q1","Toys","Legal",178.88,141.05000000000001,787.65]
["PY","Q1","Toys","Marketing",219.52,158.62,685.23]
["PY","Q1","Toys","R&D",283.24,136.80000000000001,823.2]
["PY","Q1","Clothing","Admin",92.22,108.8,434.66]
["PY","Q1","Clothing","Corporate",157.78,135.16,433.26]
["PY","Q1","Clothing","Finance",161.54,161.01999999999998,327.12]
["PY","Q1","Clothing","HR",206,94.83,443.52]
["PY","Q1","Clothing","IT ",83.43,156.20000000000002,476.96]
["PY","Q1","Clothing","Legal",183.35,121.55,470.66]
["PY","Q1","Clothing","Marketing",167.61,138.57,493]
["PY","Q1","Clothing","R&D",221.13,115.2,372.78]
["PY","Q1","Outdoors","Admin",175.75,180.79,448.96000000000004]
["PY","Q1","Outdoors","Corporate",144.99,141.96,340.06]
["PY","Q1","Outdoors","Finance",205.8,202.26999999999998,470.67]
["PY","Q1","Outdoors","HR",110.00000000000001,108,336.66]
["PY","Q1","Outdoors","IT ",158.76,192.15,582.31999999999994]
["PY","Q1","Outdoors","Legal",150.15,148.20000000000002,496.1]
["PY","Q1","Outdoors","Marketing",157.30000000000001,158.85999999999999,473.79999999999995]
["PY","Q1","Outdoors","R&D",158.26,81.600000000000009,469.73]
["PY","Q2","Toys","Admin",344.56799999999998,89.366099999999989,816.24240000000009]
["PY","Q2","Toys","Corporate",235.71680000000001,120.93099999999998,622.36720000000003]
["PY","Q2","Toys","Finance",245.51080000000002,121.97999999999999,603.25439999999992]
["PY","Q2","Toys","HR",207.5994,169.52040000000002,704.71799999999996]
["PY","Q2","Toys","IT ",144.279,176.54039999999998,884.52359999999999]
["PY","Q2","Toys","Legal",171.72480000000002,130.63400000000001,707.82300000000009]
["PY","Q2","Toys","Marketing",138.12120000000002,140.35560000000001,704.80799999999988]
["PY","Q2","Toys","R&D",353.20320000000004,160.67160000000001,740.88]
["PY","Q2","Clothing","Admin",119.77999999999999,173.64479999999998,322.57679999999999]
["PY","Q2","Clothing","Corporate",136.12549999999999,98.80319999999999,406.86599999999999]
["PY","Q2","Clothing","Finance",221.03400000000002,181.00639999999996,260.30399999999997]
["PY","Q2","Clothing","HR",207.10000000000002,78.654399999999995,553.0895999999999]
["PY","Q2","Clothing","IT ",97.180500000000009,106.2444,408.28860000000003]
["PY","Q2","Clothing","Legal",209.36639999999997,167.91059999999999,480.16640000000007]
["PY","Q2","Clothing","Marketing",144.96,161.06899999999999,388.3854]
["PY","Q2","Clothing","R&D",187.79040000000001,127.13760000000002,285.14400000000001]
["PY","Q2","Outdoors","Admin",181.24449999999999,156.267,526.45439999999996]
["PY","Q2","Outdoors","Corporate",178.57039999999998,168.45920000000004,427.53870000000006]
["PY","Q2","Outdoors","Finance",217.56000000000003,234.13200000000001,535.04899999999998]
["PY","Q2","Outdoors","HR",65.600000000000009,126.19799999999998,342.09000000000003]
["PY","Q2","Outdoors","IT ",232.6968,127.0386,710.83199999999988]
["PY","Q2","Outdoors","Legal",133.70500000000001,152.19,430.93050000000005]
["PY","Q2","Outdoors","Marketing",131.56,168.9324,341.13600000000002]
["PY","Q2","Outdoors","R&D",211.79820000000001,76.377600000000001,415.29400000000004]
["PY","Q3","Toys","Admin",283.03799999999995,124.70850000000002,828.63000000000011]
["PY","Q3","Toys","Corporate",252.19700000000003,162.19200000000001,954.43919999999991]
["PY","Q3","Toys","Finance",233.64000000000001,105.73,831.30840000000001]
["PY","Q3","Toys","HR",204.17999999999998,248.08679999999998,748.85099999999989]
["PY","Q3","Toys","IT ",150.18300000000002,144.10880000000003,840.44939999999997]
["PY","Q3","Toys","Legal",189.01080000000002,117.17999999999999,750.48]
["PY","Q3","Toys","Marketing",204.50639999999999,205.25120000000001,618.74009999999998]
["PY","Q3","Toys","R&D",250.71120000000005,218.34989999999996,512.44199999999989]
["PY","Q3","Clothing","Admin",114.55420000000001,144.92160000000001,337.178]
["PY","Q3","Clothing","Corporate",111.7662,118.0852,386.44800000000004]
["PY","Q3","Clothing","Finance",269.65359999999998,179.08079999999998,231.14159999999998]
["PY","Q3","Clothing","HR",212.94,78.578100000000006,368.12159999999994]
["PY","Q3","Clothing","IT ",90.372199999999992,141.20479999999998,602.43299999999999]
["PY","Q3","Clothing","Legal",149.28549999999998,115.4725,520.05599999999993]
["PY","Q3","Clothing","Marketing",159.92410000000001,108.82959999999999,502.46559999999999]
["PY","Q3","Clothing","R&D",171.99,130.03200000000001,397.43579999999997]
["PY","Q3","Outdoors","Admin",203.96250000000001,189.45360000000002,445.05599999999998]
["PY","Q3","Outdoors","Corporate",214.58520000000004,159.13040000000001,342.83600000000001]
["PY","Q3","Outdoors","Finance",191.9624,199.22700000000003,503.13000000000005]
["PY","Q3","Outdoors","HR",91.52000000000001,117.00450000000002,495.21599999999995]
["PY","Q3","Outdoors","IT ",205.821,169.97040000000001,378.15660000000003]
["PY","Q3","Outdoors","Legal",104.36139999999999,163.60900000000004,404.14109999999999]
["PY","Q3","Outdoors","Marketing",143.81509999999997,223.43489999999997,270.27199999999999]
["PY","Q3","Outdoors","R&D",159.34079999999997,100.67399999999999,412.65999999999997]
["PY","Q4","Toys","Admin",481.27007999999989,72.96696,693.09626400000002]
["PY","Q4","Toys","Corporate",288.40486200000004,166.57881,527.16553599999986]
["PY","Q4","Toys","Finance",262.69655600000004,138.886,704.26742400000001]
["PY","Q4","Toys","HR",180.37605600000001,151.65696000000003,978.46738500000004]
["PY","Q4","Toys","IT ",129.00239999999999,197.72524799999997,948.62876400000005]
["PY","Q4","Toys","Legal",131.76576,145.40364000000002,1005.8697600000002]
["PY","Q4","Toys","Marketing",182.31998400000003,131.28977400000002,556.61760000000004]
["PY","Q4","Toys","R&D",247.43846400000004,110.78029800000003,872.6508]
["PY","Q4","Clothing","Admin",151.56961200000001,126.34944000000002,265.22193599999997]
["PY","Q4","Clothing","Corporate",180.19039499999997,141.32428800000002,370.24806000000001]
["PY","Q4","Clothing","Finance",180.12261600000002,188.51624000000001,404.72678400000007]
["PY","Q4","Clothing","HR",191.51999999999998,69.148728000000006,653.53780799999993]
["PY","Q4","Clothing","IT ",86.289280000000005,137.42589600000002,497.86006200000003]
["PY","Q4","Clothing","Legal",277.93389599999995,118.25470799999999,401.28192000000001]
["PY","Q4","Clothing","Marketing",141.55344000000002,109.54092600000001,338.5924]
["PY","Q4","Clothing","R&D",147.20680799999997,115.89350400000002,316.50984000000005]
["PY","Q4","Outdoors","Admin",183.18256,202.01939999999999,459.28608000000014]
["PY","Q4","Outdoors","Corporate",200.58024,268.02048000000002,399.57535799999999]
["PY","Q4","Outdoors","Finance",252.36960000000002,245.7312,356.20305599999995]
["PY","Q4","Outdoors","HR",80.155000000000001,108.45278999999998,426.92832000000004]
["PY","Q4","Outdoors","IT ",146.59898399999997,163.87979399999998,746.3735999999999]
["PY","Q4","Outdoors","Legal",192.80261000000002,212.10212999999999,405.44403900000009]
["PY","Q4","Outdoors","Marketing",104.43232800000001,178.273368,352.84833600000007]
["PY","Q4","Outdoors","R&D",165.13080000000002,115.15392000000001,308.07263999999998]

{"sheet":"Piv","index":2,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Year","CY"]
["Dept","(All)"]
[]
["Row Labels","Labour A","Overheads B"]
["R&D",2628.58,1574.8359]
["Finance",2626.1203999999998,1973.0459999999998]
["Admin",2575.4112,1712.5186999999999]
["Corporate",2452.1238999999996,1872.6917999999998]
["Legal",2091.2682,1898.9256]

{"sheet":"Calcs","index":3,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"CY","Labour"]
[null,"Line","Department","Q1","Q2","Q3","Q4","Total","PY"]
[null,"Labour","Toys",{"$f":"SUMIFS(Data!$E$2:$E$194,Data!$A$2:$A$194,$B$4,Data!$B$2:$B$194,D$5,Data!$C$2:$C$194,$C6)","v":1785},{"$f":"SUMIFS(Data!$E$2:$E$194,Data!$A$2:$A$194,$B$4,Data!$B$2:$B$194,E$5,Data!$C$2:$C$194,$C6)","v":1875.9700000000003},{"$f":"SUMIFS(Data!$E$2:$E$194,Data!$A$2:$A$194,$B$4,Data!$B$2:$B$194,F$5,Data!$C$2:$C$194,$C6)","v":1802.57},{"$f":"SUMIFS(Data!$E$2:$E$194,Data!$A$2:$A$194,$B$4,Data!$B$2:$B$194,G$5,Data!$C$2:$C$194,$C6)","v":1915.6974000000002},{"$f":"SUM(D6:G6)","v":7379.2374},{"$f":"SUMIFS(Data!$E$2:$E$194,Data!$A$2:$A$194,$I$5,Data!$C$2:$C$194,$C6)","v":7289.5737620000009}]
[null,"Labour","Clothing",{"$f":"SUMIFS(Data!$E$2:$E$194,Data!$A$2:$A$194,$B$4,Data!$B$2:$B$194,D$5,Data!$C$2:$C$194,$C7)","v":1300},{"$f":"SUMIFS(Data!$E$2:$E$194,Data!$A$2:$A$194,$B$4,Data!$B$2:$B$194,E$5,Data!$C$2:$C$194,$C7)","v":1288.1500000000001},{"$f":"SUMIFS(Data!$E$2:$E$194,Data!$A$2:$A$194,$B$4,Data!$B$2:$B$194,F$5,Data!$C$2:$C$194,$C7)","v":1272.6400000000001},{"$f":"SUMIFS(Data!$E$2:$E$194,Data!$A$2:$A$194,$B$4,Data!$B$2:$B$194,G$5,Data!$C$2:$C$194,$C7)","v":1347.8012999999999},{"$f":"SUM(D7:G7)","v":5208.5913},{"$f":"SUMIFS(Data!$E$2:$E$194,Data!$A$2:$A$194,$I$5,Data!$C$2:$C$194,$C7)","v":5233.2686469999981}]
[null,"Labour","Outdoors",{"$f":"SUMIFS(Data!$E$2:$E$194,Data!$A$2:$A$194,$B$4,Data!$B$2:$B$194,D$5,Data!$C$2:$C$194,$C8)","v":1328},{"$f":"SUMIFS(Data!$E$2:$E$194,Data!$A$2:$A$194,$B$4,Data!$B$2:$B$194,E$5,Data!$C$2:$C$194,$C8)","v":1348.8999999999999},{"$f":"SUMIFS(Data!$E$2:$E$194,Data!$A$2:$A$194,$B$4,Data!$B$2:$B$194,F$5,Data!$C$2:$C$194,$C8)","v":1338.79},{"$f":"SUMIFS(Data!$E$2:$E$194,Data!$A$2:$A$194,$B$4,Data!$B$2:$B$194,G$5,Data!$C$2:$C$194,$C8)","v":1269.6088},5285.2987999999996,{"$f":"SUMIFS(Data!$E$2:$E$194,Data!$A$2:$A$194,$I$5,Data!$C$2:$C$194,$C8)","v":5254.3654219999989}]
[null,"Labour","*",{"$f":"SUMIFS(Data!$E$2:$E$194,Data!$A$2:$A$194,$B$4,Data!$B$2:$B$194,D$5,Data!$C$2:$C$194,$C9)","v":4413},{"$f":"SUMIFS(Data!$E$2:$E$194,Data!$A$2:$A$194,$B$4,Data!$B$2:$B$194,E$5,Data!$C$2:$C$194,$C9)","v":4513.0200000000004},{"$f":"SUMIFS(Data!$E$2:$E$194,Data!$A$2:$A$194,$B$4,Data!$B$2:$B$194,F$5,Data!$C$2:$C$194,$C9)","v":4414},{"$f":"SUMIFS(Data!$E$2:$E$194,Data!$A$2:$A$194,$B$4,Data!$B$2:$B$194,G$5,Data!$C$2:$C$194,$C9)","v":4533.1075000000001},17873.127500000002,{"$f":"SUMIFS(Data!$E$2:$E$194,Data!$A$2:$A$194,$I$5,Data!$C$2:$C$194,$C9)","v":17777.207831}]
[]
[null,null,"Overheads"]
[null,"Line","Category","Q1","Q2","Q3","Q4","Total","PY"]
[null,"Overheads","Toys",{"$f":"SUMIFS(Data!$F$2:$F$98,Data!$B$2:$B$98,D$5,Data!$C$2:$C$98,$C13)","v":1340.98},{"$f":"SUMIFS(Data!$F$2:$F$98,Data!$B$2:$B$98,E$5,Data!$C$2:$C$98,$C13)","v":1097},{"$f":"SUMIFS(Data!$F$2:$F$98,Data!$B$2:$B$98,F$5,Data!$C$2:$C$98,$C13)","v":1267.21},{"$f":"SUMIFS(Data!$F$2:$F$98,Data!$B$2:$B$98,G$5,Data!$C$2:$C$98,$C13)","v":1107.1018000000001},{"$f":"SUM(D13:G13)","v":4812.2918},{"$f":"SUMIFS(Data!$F$2:$F$194,Data!$A$2:$A$194,$I$5,Data!$C$2:$C$194,$C13)","v":4745.9439900000007}]
[null,"Overheads","Clothing",{"$f":"SUMIFS(Data!$F$2:$F$98,Data!$B$2:$B$98,D$5,Data!$C$2:$C$98,$C14)","v":1105},{"$f":"SUMIFS(Data!$F$2:$F$98,Data!$B$2:$B$98,E$5,Data!$C$2:$C$98,$C14)","v":1103.0999999999999},{"$f":"SUMIFS(Data!$F$2:$F$98,Data!$B$2:$B$98,F$5,Data!$C$2:$C$98,$C14)","v":1016.49},{"$f":"SUMIFS(Data!$F$2:$F$98,Data!$B$2:$B$98,G$5,Data!$C$2:$C$98,$C14)","v":1140.1079999999999},{"$f":"SUM(D14:G14)","v":4364.6980000000003},{"$f":"SUMIFS(Data!$F$2:$F$194,Data!$A$2:$A$194,$I$5,Data!$C$2:$C$194,$C14)","v":4148.4587300000012}]
[null,"Overheads","Outdoors",{"$f":"SUMIFS(Data!$F$2:$F$98,Data!$B$2:$B$98,D$5,Data!$C$2:$C$98,$C15)","v":1306},{"$f":"SUMIFS(Data!$F$2:$F$98,Data!$B$2:$B$98,E$5,Data!$C$2:$C$98,$C15)","v":1271.3899999999999},{"$f":"SUMIFS(Data!$F$2:$F$98,Data!$B$2:$B$98,F$5,Data!$C$2:$C$98,$C15)","v":1369.8000000000002},{"$f":"SUMIFS(Data!$F$2:$F$98,Data!$B$2:$B$98,G$5,Data!$C$2:$C$98,$C15)","v":1352.0689999999997},5299.259,{"$f":"SUMIFS(Data!$F$2:$F$194,Data!$A$2:$A$194,$I$5,Data!$C$2:$C$194,$C15)","v":5239.5616820000005}]
[null,"Overheads","*",{"$f":"SUMIFS(Data!$F$2:$F$98,Data!$B$2:$B$98,D$5,Data!$C$2:$C$98,$C16)","v":3751.98},{"$f":"SUMIFS(Data!$F$2:$F$98,Data!$B$2:$B$98,E$5,Data!$C$2:$C$98,$C16)","v":3471.49},{"$f":"SUMIFS(Data!$F$2:$F$98,Data!$B$2:$B$98,F$5,Data!$C$2:$C$98,$C16)","v":3653.4999999999991},{"$f":"SUMIFS(Data!$F$2:$F$98,Data!$B$2:$B$98,G$5,Data!$C$2:$C$98,$C16)","v":3599.2788},14476.248799999998,{"$f":"SUMIFS(Data!$F$2:$F$194,Data!$A$2:$A$194,$I$5,Data!$C$2:$C$194,$C16)","v":14133.964402000003}]
[]
[null,null,"Revenue"]
[null,"Line","Category","Q1","Q2","Q3","Q4","Total","PY"]
[null,"Revenue","Toys",{"$f":"SUMIFS(Data!$G$2:$G$98,Data!$B$2:$B$98,D$5,Data!$C$2:$C$98,$C20)","v":7309.33},{"$f":"SUMIFS(Data!$G$2:$G$98,Data!$B$2:$B$98,E$5,Data!$C$2:$C$98,$C20)","v":6209.23},{"$f":"SUMIFS(Data!$G$2:$G$98,Data!$B$2:$B$98,F$5,Data!$C$2:$C$98,$C20)","v":6631.4400000000005},{"$f":"SUMIFS(Data!$G$2:$G$98,Data!$B$2:$B$98,G$5,Data!$C$2:$C$98,$C20)","v":6132.5160999999998},{"$f":"SUM(D20:G20)","v":26282.516100000001},{"$f":"SUMIFS(Data!$G$2:$G$194,Data!$A$2:$A$194,$I$5,Data!$C$2:$C$194,$C20)","v":24216.470233000004}]
[null,"Revenue","Clothing",{"$f":"SUMIFS(Data!$G$2:$G$98,Data!$B$2:$B$98,D$5,Data!$C$2:$C$98,$C21)","v":3600},{"$f":"SUMIFS(Data!$G$2:$G$98,Data!$B$2:$B$98,E$5,Data!$C$2:$C$98,$C21)","v":3515.6799999999994},{"$f":"SUMIFS(Data!$G$2:$G$98,Data!$B$2:$B$98,F$5,Data!$C$2:$C$98,$C21)","v":3499.2699999999995},{"$f":"SUMIFS(Data!$G$2:$G$98,Data!$B$2:$B$98,G$5,Data!$C$2:$C$98,$C21)","v":3490.8507},{"$f":"SUM(D21:G21)","v":14105.8007},{"$f":"SUMIFS(Data!$G$2:$G$194,Data!$A$2:$A$194,$I$5,Data!$C$2:$C$194,$C21)","v":13150.039209999997}]
[null,"Revenue","Outdoors",{"$f":"SUMIFS(Data!$G$2:$G$98,Data!$B$2:$B$98,D$5,Data!$C$2:$C$98,$C22)","v":3542},{"$f":"SUMIFS(Data!$G$2:$G$98,Data!$B$2:$B$98,E$5,Data!$C$2:$C$98,$C22)","v":3399.4599999999996},{"$f":"SUMIFS(Data!$G$2:$G$98,Data!$B$2:$B$98,F$5,Data!$C$2:$C$98,$C22)","v":3402.6199999999994},{"$f":"SUMIFS(Data!$G$2:$G$98,Data!$B$2:$B$98,G$5,Data!$C$2:$C$98,$C22)","v":3482.6437999999998},13826.723799999998,{"$f":"SUMIFS(Data!$G$2:$G$194,Data!$A$2:$A$194,$I$5,Data!$C$2:$C$194,$C22)","v":14053.823729000005}]
[null,"Revenue","*",{"$f":"SUMIFS(Data!$G$2:$G$98,Data!$B$2:$B$98,D$5,Data!$C$2:$C$98,$C23)","v":14451.33},{"$f":"SUMIFS(Data!$G$2:$G$98,Data!$B$2:$B$98,E$5,Data!$C$2:$C$98,$C23)","v":13124.37},{"$f":"SUMIFS(Data!$G$2:$G$98,Data!$B$2:$B$98,F$5,Data!$C$2:$C$98,$C23)","v":13533.33},{"$f":"SUMIFS(Data!$G$2:$G$98,Data!$B$2:$B$98,G$5,Data!$C$2:$C$98,$C23)","v":13106.010600000001},54215.0406,{"$f":"SUMIFS(Data!$G$2:$G$194,Data!$A$2:$A$194,$I$5,Data!$C$2:$C$194,$C23)","v":51420.333171999999}]
[]
[null,null,"Choice Consolidated"]
[null,"Line",{"$f":"IF(List!B2=\"All\",\"*\",List!B2)","v":"Toys"},"Q1","Q2","Q3","Q4","Total","PY"]
[null,{"$f":"$C$26","v":"Toys"},"Labour",{"$f":"SUMIFS(D$6:D$24,$B$6:$B$24,$C27,$C$6:$C$24,$C$26)","v":1785},{"$f":"SUMIFS(E$6:E$24,$B$6:$B$24,$C27,$C$6:$C$24,$C$26)","v":1875.9700000000003},1802.57,1915.6974000000002,7379.2374,7289.5737620000009]
[null,{"$f":"$C$26","v":"Toys"},"Overheads",{"$f":"SUMIFS(D$6:D$24,$B$6:$B$24,$C28,$C$6:$C$24,$C$26)","v":1340.98},1097,1267.21,1107.1018000000001,4812.2918,4745.9439900000007]
[null,"Toys","Revenue",7309.33,6209.23,6631.4400000000005,6132.5160999999998,26282.516100000001,24216.470233000004]
[null,"Toys","Net",{"$f":"D29-D28-D27","v":4183.3500000000004},{"$f":"E29-E28-E27","v":3236.2599999999993},3561.6600000000008,3109.7168999999994,14090.986900000002,12180.952481000004]

{"sheet":"Dash","index":4,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Top 5 Exp by Labour Dept"]
["#","Dept",{"$f":"Data!E1","v":"Labour"},{"$f":"Data!F1","v":"Overheads "},"Total"]
[1,{"$f":"Piv!A5","v":"R&D"},{"$f":"Piv!B5","v":2628.58},{"$f":"Piv!C5","v":1574.8359},{"$f":"SUM(C6:D6)","v":4203.4159}]
[2,{"$f":"Piv!A6","v":"Finance"},{"$f":"Piv!B6","v":2626.1203999999998},{"$f":"Piv!C6","v":1973.0459999999998},{"$f":"SUM(C7:D7)","v":4599.1664000000001}]
[3,{"$f":"Piv!A7","v":"Admin"},{"$f":"Piv!B7","v":2575.4112},{"$f":"Piv!C7","v":1712.5186999999999},4287.9299000000001]
[4,{"$f":"Piv!A8","v":"Corporate"},{"$f":"Piv!B8","v":2452.1238999999996},{"$f":"Piv!C8","v":1872.6917999999998},4324.8156999999992]
[5,{"$f":"Piv!A9","v":"Legal"},{"$f":"Piv!B9","v":2091.2682},{"$f":"Piv!C9","v":1898.9256},3990.1938]
[]
[]
["#","Line Item","CY","PY","Var"]
[1,"Labour",{"$f":"Calcs!H27","v":7379.2374},{"$f":"Calcs!I27","v":7289.5737620000009},{"$f":"-(C14-D14)/C14","v":-1.2150800027113788E-2}]
[2,"Overheads",{"$f":"Calcs!H28","v":4812.2918},{"$f":"Calcs!I28","v":4745.9439900000007},{"$f":"-(C15-D15)/C15","v":-1.3787154386606253E-2}]
[3,"Revenue",{"$f":"Calcs!H29","v":26282.516100000001},{"$f":"Calcs!I29","v":24216.470233000004},{"$f":"(C16-D16)/C16","v":7.8609135409223513E-2}]
[4,"Net",{"$f":"Calcs!H30","v":14090.986900000002},{"$f":"Calcs!I30","v":12180.952481000004},{"$f":"(C17-D17)/C17","v":0.13555008123668028}]