Spreadsheet: 144645d1331074148-dashboard-advice-sought-how-would-you-improve-this-dashboard-query
Sheet: Sheet1

Directorate 1: |  |  |  |  |  |  | Directorate 2: |  |  |  |  |  |  | Directorate 3:
Department A | Reported | Actual | Var | Var % |  |  | Department F | Reported | Actual | Var | Var % |  |  | Department J | Reported | Actual | Var | Var %
Income Stream 1 | -30129.85 | -30129.85000000001 | -7.275957614183426e-12 | 2.414866856019338e-16 | 1 |  | Income Stream 37 | -1284.52 | -1284.52 | 0 | 0 | 1 |  | Income Stream 85 | -226958.97 | -232870.11 | -5911.140000000014 | 0.02604497191717082 | 1.026044971917171
Income Stream 2 | -24079.36 | -24489.93 | -410.5699999999961 | 0.01705070234424819 | 1.017050702344248 |  | Income Stream 38 | -3400.19 | -3366.06 | 34.12999999999965 | -0.01003767436525596 | 0.9899623256347441 |  | Income Stream 86 | -185971.45 | -185940.19 | 31.26000000000931 | -0.0001680903170890441 | 0.9998319096829109
Income Stream 3 | -69230.26 | -69400.73999999999 | -170.4799999999959 | 0.002462507001995889 | 1.002462507001996 |  | Income Stream 39 | -176816.73 | -171388.4399999999 | 5428.290000000066 | -0.0307000926891933 | 0.9692999073108067 |  | Income Stream 87 | -11576.83 | -11116.83 | 460 | -0.03973453872951404 | 0.960265461270486
Income Stream 4 | 21666.81 | 21716.81000000001 | 50.00000000000728 | 0.002307677041521446 | 1.002307677041521 |  | Income Stream 40 | -24539.44 | -24039.44 | 500 | -0.02037536308897024 | 0.9796246369110297 |  |  | -424507.2500000001 | -429927.1300000001 | -5419.880000000005 | 0.01276746156867758 | 1.012767461568677
Income Stream 5 | -964064 | -997107.9800000001 | -33043.9800000001 | 0.03427571198592635 | 1.034275711985926 |  | Income Stream 41 | -1476874.38 | -1483182.47 | -6308.090000000084 | 0.004271243435071359 | 1.004271243435071
Income Stream 6 | -214455.93 | -215353.01 | -897.0800000000454 | 0.00418305056894461 | 1.004183050568945 |  | Income Stream 42 | -723179.58 | -715802.3599999999 | 7377.220000000088 | -0.01020109002524669 | 0.9897989099747533 |  | Department K | Reported | Actual | Var | Var %
Income Stream 7 | -11773.39 | -6628.24 | 5145.15 | -0.4370151672542912 | 0.5629848327457088 |  | Income Stream 43 | -604908.86 | -605961.23 | -1052.369999999995 | 0.001739716624418421 | 1.001739716624418 |  | Income Stream 88 | -208735.78 | -188587.49 | 20148.28999999998 | -0.09652532977336219 | 0.9034746702266379
Income Stream 8 | -63673.99 | -64619.53999999999 | -945.5499999999956 | 0.01484986255769421 | 1.014849862557694 |  | Income Stream 44 | -78270.97 | -79976.2 | -1705.229999999996 | 0.02178623824388526 | 1.021786238243885 |  | Income Stream 89 | -1600 | 0 | 1600 | -1 | 0
Income Stream 9 | -253800.24 | -258529.3 | -4729.060000000056 | 0.01863300050464907 | 1.018633000504649 |  |  | -3089274.67 | -3085000.72 | 4273.949999999721 | -0.001383480090489889 | 0.9986165199095101 |  |  | -210335.78 | -188587.49 | 21748.28999999998 | -0.1033979573042683 | 0.8966020426957316
Income Stream 10 | -45308.62 | -45554.18000000001 | -245.5600000000049 | 0.005419719249891189 | 1.005419719249891
Income Stream 11 | -294590.61 | -305765.6799999999 | -11175.06999999995 | 0.03793423693986699 | 1.037934236939867 |  | Department G | Reported | Actual | Var | Var % |  |  | Department L | Reported | Actual | Var | Var %
Income Stream 12 | -1381989.88 | -1449078.699999999 | -67088.8199999996 | 0.0485450877541879 | 1.048545087754188 |  | Income Stream 45 | -699246.31 | -663387.78 | 35858.53000000003 | -0.05128168642034024 | 0.9487183135796597 |  | Income Stream 90 | -1213538.17 | -1356338.17 | -142800 | 0.1176724420625352 | 1.117672442062535
Income Stream 13 | -228272.7 | -241007.7999999999 | -12735.09999999989 | 0.0557889752037799 | 1.05578897520378 |  | Income Stream 46 | -269668.63 | -279063.6800000001 | -9395.050000000047 | 0.03483923955114856 | 1.034839239551149 |  | Income Stream 91 | -417134.44 | -417134.4399999999 | 5.820766091346741e-11 | -1.395417288331968e-16 | 0.9999999999999999
Income Stream 14 | -6608.03 | -7191.829999999998 | -583.7999999999984 | 0.08834705653576004 | 1.08834705653576 |  | Income Stream 47 | -54810.48 | -47456.77 | 7353.710000000006 | -0.1341661302728968 | 0.8658338697271032 |  | Income Stream 92 | -262331.88 | -197117.83 | 65214.05000000002 | -0.2485936897947745 | 0.7514063102052255
 | -3566310.05 | -3693139.97 | -126829.9199999999 | 0.03556334649030303 | 1.035563346490303 |  | Income Stream 48 | -58411.48 | -65509.01 | -7097.529999999999 | 0.1215091622400254 | 1.121509162240026 |  |  | -1893004.49 | -1970590.44 | -77585.95000000019 | 0.04098561329878314 | 1.040985613298783
 |  |  |  |  |  |  | Income Stream 49 | -1400597.75 | -1444276.02 | -43678.27000000025 | 0.0311854492126667 | 1.031185449212667
Department B | Reported | Actual | Var | Var % |  |  | Income Stream 50 | -14206.21 | -37120.44 | -22914.23 | 1.612972777398054 | 2.612972777398054 |  | Department M | Reported | Actual | Var | Var %
Income Stream 15 | -485645.76 | -516703.3500000002 | -31057.5900000002 | 0.0639511194332268 | 1.063951119433227 |  | Income Stream 51 | -57106.4 | -54532.43000000001 | 2573.969999999994 | -0.04507323172183843 | 0.9549267682781616 |  | Income Stream 93 | -813968.72 | -792768.72 | 21200 | -0.02604522689766261 | 0.9739547731023374
Income Stream 16 | -873829.1 | -877803.2499999995 | -3974.149999999558 | 0.004547971680045397 | 1.004547971680045 |  | Income Stream 52 | -112743.37 | -109650.88 | 3092.489999999991 | -0.02742946214930413 | 0.9725705378506959
Income Stream 17 | -149004.36 | -117360.34 | 31644.02000000002 | -0.2123697588446407 | 0.7876302411553593 |  | Income Stream 53 | -317331.59 | -307685.8 | 9645.789999999979 | -0.03039656404835074 | 0.9696034359516492
Income Stream 18 | -270226.43 | -280658.7600000001 | -10432.33000000007 | 0.03860588322171179 | 1.038605883221712 |  | Income Stream 54 | -348602.88 | -320544.7200000002 | 28058.1599999998 | -0.08048745896763618 | 0.9195125410323638
Income Stream 19 | -273069.22 | -278172.4199999997 | -5103.199999999721 | 0.01868830181592682 | 1.018688301815927 |  | Income Stream 55 | -16356.35 | -12656.35 | 3699.999999999998 | -0.2262118382157387 | 0.7737881617842612 |  | Summary:
Income Stream 20 | -1539.92 | -1549.01 | -9.090000000000146 | 0.005902904046963573 | 1.005902904046964 |  | Income Stream 56 | -195017 | -118628.06 | 76388.93999999997 | -0.3917040052918462 | 0.6082959947081538
Income Stream 21 | -21394.06 | -23525 | -2130.939999999995 | 0.09960428268407188 | 1.099604282684072 |  | Income Stream 57 | -6.03 | -6.03 | 0 | 0 | 1 |  |  | Reported | Actual | Var | Var %
 | -2074708.85 | -2095772.129999999 | -21063.27999999956 | 0.01015240282991976 | 1.01015240282992 |  | Income Stream 58 | -1554.94 | -1254.94 | 300 | -0.1929334893950892 | 0.8070665106049109 |  | Directorate 1 | -10303923.86 | -10467440.87 | -163517.0099999979 | 0.01586939230352561 | 1.015869392303526
 |  |  |  |  |  |  | Income Stream 59 | -482736.38 | -498328.9799999997 | -15592.59999999974 | 0.0323004452243681 | 1.032300445224368 |  | Directorate 2 | -29604820.5 | -29515518.4 | 89302.09999999776 | -0.003016471591172045 | 0.996983528408828
Department C | Reported | Actual | Var | Var % |  |  | Income Stream 60 | -823039.9 | -703730.8099999999 | 119309.0900000001 | -0.1449614897163553 | 0.8550385102836447 |  | Directorate 3 | -3341816.239999999 | -3381873.78 | -40057.54000000097 | 0.01198675723713671 | 1.011986757237137
Income Stream 22 | -538472.71 | -569509.2900000002 | -31036.58000000019 | 0.05763816702985782 | 1.057638167029858 |  | Income Stream 61 | -284820.21 | -275285.5600000001 | 9534.649999999907 | -0.033476030370176 | 0.966523969629824 |  |  | -43250560.6 | -43364833.05 | -114272.4499999955 | 0.002642103325708003 | 1.002642103325708
 |  |  |  |  |  |  | Income Stream 62 | -5844.52 | -5429.15 | 415.3700000000008 | -0.07106999377194377 | 0.9289300062280562
Department D | Reported | Actual | Var | Var % |  |  | Income Stream 63 | -2608.57 | -1608.57 | 1000 | -0.383351798111609 | 0.616648201888391
Income Stream 23 | -11333.66 | -9902.91 | 1430.75 | -0.1262390084050519 | 0.8737609915949481 |  | Income Stream 64 | 0 | 0 | 0 | 0 | 0
Income Stream 24 | -85266.78 | -90428.03999999998 | -5161.25999999998 | 0.0605307248614288 | 1.060530724861429 |  |  | -5144709 | -4946155.980000001 | 198553.0199999986 | -0.03859363474202304 | 0.961406365257977
Income Stream 25 | -43450.43 | -43410.61 | 39.81999999999971 | -0.0009164466266501784 | 0.9990835533733499
Income Stream 26 | -819294.3 | -807287.3200000001 | 12006.97999999998 | -0.01465527100579118 | 0.9853447289942088 |  | Department H | Reported | Actual | Var | Var %
 | -959345.17 | -951028.8800000001 | 8316.28999999992 | -0.008668715140349245 | 0.9913312848596507 |  | Income Stream 65 | -361821.11 | -334718.5400000002 | 27102.56999999983 | -0.0749059942909352 | 0.9250940057090649
 |  |  |  |  |  |  | Income Stream 66 | -123824.65 | -113021.17 | 10803.47999999998 | -0.08724821753988388 | 0.9127517824601161
Department E | Reported | Actual | Var | Var % |  |  | Income Stream 67 | -74340.67 | -76132.52 | -1791.850000000006 | 0.02410322640352859 | 1.024103226403529
Income Stream 27 | -653379.22 | -656261.4099999999 | -2882.189999999944 | 0.004411205486455391 | 1.004411205486455 |  | Income Stream 68 | -52880.44 | -41033.51 | 11846.93 | -0.2240323643297976 | 0.7759676356702024
Income Stream 28 | -547280.1 | -554910.95 | -7630.849999999977 | 0.01394322578145995 | 1.01394322578146 |  | Income Stream 69 | -39600 | -39952.01 | -352.010000000002 | 0.008889141414141466 | 1.008889141414141
Income Stream 29 | -89955 | -67455 | 22500 | -0.2501250625312657 | 0.7498749374687343 |  |  | -652466.8700000001 | -604857.7500000002 | 47609.11999999988 | -0.0729678734492678 | 0.9270321265507322
Income Stream 30 | -787006.27 | -788136.31 | -1130.040000000037 | 0.00143587166084463 | 1.001435871660845
Income Stream 31 | -198305.26 | -196316.71 | 1988.550000000017 | -0.01002772190712449 | 0.9899722780928755 |  | Department I | Reported | Actual | Var | Var %
Income Stream 32 | -15510.58 | -20022.55 | -4511.970000000003 | 0.2908962785401966 | 1.290896278540197 |  | Income Stream 70 | -694859.49 | -694852.8400000001 | 6.649999999906868 | -9.57028017262435e-06 | 0.9999904297198273
Income Stream 33 | -41106 | -41106 | 0 | 0 | 1 |  | Income Stream 71 | -14350598.31 | -14350598.31 | 3.725290298461914e-09 | -2.595912879720144e-16 | 0.9999999999999998
Income Stream 34 | -126666 | -126666 | 0 | 0 | 1 |  | Income Stream 72 | -1322846.9 | -1323738.7 | -891.8000000000466 | 0.0006741520881970896 | 1.000674152088197
Income Stream 35 | -8660.42 | -8846 | -185.5799999999999 | 0.02142852194235383 | 1.021428521942354 |  | Income Stream 73 | -1681764.67 | -1785916.17 | -104151.5 | 0.06192988939409698 | 1.061929889394097
Income Stream 36 | -697218.23 | -698269.67 | -1051.440000000061 | 0.001508050069201519 | 1.001508050069202 |  | Income Stream 74 | -18662 | -18662 | 0 | 0 | 1
 | -3165087.08 | -3157990.6 | 7096.479999999981 | -0.002242112087481644 | 0.9977578879125184 |  | Income Stream 75 | -506071.21 | -464413.22 | 41657.98999999999 | -0.08231645898212622 | 0.9176835410178737
 |  |  |  |  |  |  | Income Stream 76 | -1882193.84 | -1834741.84 | 47452.00000000023 | -0.02521100589724607 | 0.9747889941027539
 |  |  |  |  |  |  | Income Stream 77 | -10221.03 | -10221.82000000001 | -0.7900000000063301 | 7.729162325189634e-05 | 1.000077291623252
 |  |  |  |  |  |  | Income Stream 78 | -20310.58 | -20384.03 | -73.45000000000073 | 0.003616341827756801 | 1.003616341827757
 |  |  |  |  |  |  | Income Stream 79 | -215725.29 | -159505.1400000015 | 56220.14999999848 | -0.2606099173629502 | 0.7393900826370498
 |  |  |  |  |  |  | Income Stream 80 | -281.31 | -281.31 | 0 | 0 | 1
 |  |  |  |  |  |  | Income Stream 81 | 58673.66 | -111539.5 | -170213.16 | -2.901014867659526 | -1.901014867659526
 |  |  |  |  |  |  | Income Stream 82 | -8755 | -8755 | 0 | 0 | 1
 |  |  |  |  |  |  | Income Stream 83 | -82500 | -82500 | 0 | 0 | 1
 |  |  |  |  |  |  | Income Stream 84 | 17746.01 | -13394.07000000001 | -31140.08000000001 | -1.754765155660343 | -0.7547651556603435
 |  |  |  |  |  |  |  | -20718369.96 | -20879503.95 | -161133.9899999984 | 0.007777348812242099 | 1.007777348812242