{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["List","Data","Chart","Report"],"not_rendered":{"charts":1,"images":3,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"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":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Selection","Region","Type"]
[1,"Europe","Revenue"]
[2,"Americas","Expenses"]
[3,"Asia Pac","EBIT"]

{"sheet":"Data","index":1,"n_rows":88,"n_cols":16,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
["Type","ActPlan","Country","2013-01-01","2013-02-02","2013-03-06","2013-04-07","2013-05-09","2013-06-10","2013-07-12","2013-08-13","2013-09-14","2013-10-16","2013-11-17","2013-12-19","Total"]
["Revenue","Actual","England",703.8,761.3,752.1,736,678.5,692.3,637.1,598,598,604.9,657.8,678.5,{"$f":"SUM(D2:O2)","v":8098.3}]
["Revenue","Actual","Scotland",535.9,526.70000000000005,512.9,496.8,517.5,492.2,441.6,416.3,386.4,420.9,404.8,437,{"$f":"SUM(D3:O3)","v":5589}]
["Revenue","Actual","Wales",425.5,416.3,404.8,425.5,450.8,414,377.2,365.7,384.1,423.2,414,434.7,4935.7999999999993]
["Revenue","Actual","Ireland",742.9,772.8,777.4,731.4,752.1,791.19999999999993,837.2,897,816.5,816.5,880.9,959.1,9775]
["Revenue","Actual","Germany",756.7,786.60000000000014,768.2,715.3,763.6,710.7,724.5,731.4,710.7,690,669.3,662.4,8689.4]
["Revenue","Actual","France",841.8,860.2,894.7,814.2,823.4,880.9,862.5,828,795.79999999999984,763.6,770.5,809.6,9945.1999999999989]
["Revenue","Actual","Italy",197.79999999999998,193.2,186.3,177.1,172.5,156.4,167.9,170.2,188.6,184,193.2,184,2171.1999999999998]
["Revenue","Actual","Spain",1196,1202.9000000000001,1235.0999999999999,1147.7,1159.2,1276.5,1237.4000000000001,1288.0000000000002,1352.4,1216.7,1276.5,1276.5,14864.9]
["Revenue","Actual","Greece",1097.0999999999999,1122.4000000000001,1136.2,1205.2,1324.8,1205.2,1156.9000000000001,1145.4000000000001,1145.4000000000001,1076.4000000000001,1120.0999999999999,1108.5999999999999,13843.699999999999]
["Revenue","Actual","Portugal",620.49400000000003,645.01199999999994,629.92399999999998,586.54600000000005,626.15200000000004,582.774,594.09,599.74800000000005,582.774,565.79999999999995,548.82600000000002,543.16800000000001,7125.308]
[]
["Revenue","Plan","England",668.61,723.23500000000001,714.495,699.2,644.57500000000005,657.68499999999995,605.245,568.1,544.17999999999995,550.45899999999995,598.59799999999996,617.43499999999995,{"$f":"SUM(D13:O13)","v":7591.8169999999991}]
["Revenue","Plan","Scotland",509.10500000000002,500.36500000000001,487.255,471.96,491.625,467.59,419.52,395.48500000000001,351.62400000000002,383.01900000000001,368.36799999999999,397.67,{"$f":"SUM(D14:O14)","v":5243.5860000000011}]
["Revenue","Plan","Wales",404.22500000000002,395.48500000000001,384.56,404.22500000000002,428.26,393.3,358.34,347.41500000000002,349.53100000000001,385.11200000000002,376.74,395.577,4622.7700000000004]
["Revenue","Plan","Ireland",705.755,734.16,738.53,694.83,714.495,751.63999999999987,795.34,852.15,743.01499999999999,743.01499999999999,801.61900000000003,872.78099999999995,9147.3300000000017]
["Revenue","Plan","Germany",832.37000000000012,865.26000000000022,845.0200000000001,786.83000000000015,839.96000000000015,781.7700000000001,796.95000000000016,665.57399999999996,646.73699999999997,627.9,609.06299999999999,602.78399999999999,8900.2179999999989]
["Revenue","Plan","France",799.71,817.19,849.96500000000003,773.49,782.23,836.85500000000002,819.375,786.6,724.17799999999988,694.87599999999998,701.15499999999997,736.73599999999999,9322.3600000000024]
["Revenue","Plan","Italy",190.9,172.5,156.4,140.30000000000001,126.5,112.7,101.2,92,82.8,73.599999999999994,66.7,59.8,1375.3999999999999]
["Revenue","Plan","Spain",1315.6,1323.19,1358.61,1262.47,1275.1199999999999,1341.6015,1300.5074,1353.6880000000003,1421.3724,1278.7517,1341.6015,1341.6015,15914.114000000001]
["Revenue","Plan","Greece",1042.2449999999999,1066.28,1079.3900000000001,1144.94,1258.56,1144.94,1099.0550000000001,1088.1300000000001,1042.3140000000001,979.524,1019.2910000000001,1008.826,12973.494999999999]
["Revenue","Plan","Portugal",682.54340000000002,709.51320000000021,692.91640000000007,645.20060000000012,688.76720000000012,641.05140000000006,653.49900000000002,545.77067999999997,530.32434000000001,514.87799999999993,499.43165999999997,494.28287999999992,7298.1787599999998]
[]
["Expenses","Actual","England",633.41999999999996,685.17,676.89,662.4,610.65,623.07000000000005,573.39,538.20000000000005,538.20000000000005,544.41,592.02,610.65,{"$f":"SUM(D24:O24)","v":7288.4699999999993}]
["Expenses","Actual","Scotland",482.31,474.03,461.61,447.12,465.75,442.98,397.44,374.67,347.76,378.81,364.32,393.3,{"$f":"SUM(D25:O25)","v":5030.1000000000004}]
["Expenses","Actual","Wales",382.95,374.67,364.32,382.95,405.72,372.6,339.48,329.13,345.69,380.88,372.6,391.23,4442.22]
["Expenses","Actual","Ireland",668.61,695.52,699.66,658.26,676.89,712.07999999999993,753.48,807.3,734.85,734.85,792.81,863.19,8797.5000000000018]
["Expenses","Actual","Germany",681.03,707.94000000000017,691.38,643.77,687.24,639.63,652.04999999999995,658.26,639.63,621,602.37,596.16,7820.4600000000009]
["Expenses","Actual","France",757.62,774.18,805.23,732.78,741.06,792.81,776.25,745.2,716.21999999999991,687.24,693.45,728.64,8950.6799999999985]
["Expenses","Actual","Italy",178.01999999999998,173.88,167.67,159.38999999999999,155.25,140.76,151.11000000000001,153.18,169.74,165.6,173.88,165.6,1954.08]
["Expenses","Actual","Spain",1076.4000000000001,1082.6099999999999,1111.5899999999999,1032.93,1043.28,1148.8499999999999,1113.6600000000001,1159.2000000000003,1217.1600000000001,1095.03,1148.8499999999999,1148.8499999999999,13378.410000000002]
["Expenses","Actual","Greece",987.39,1010.16,1022.58,1084.68,1192.32,1084.68,1041.21,1030.8599999999999,1030.8599999999999,968.76,1008.09,997.74,12459.330000000002]
["Expenses","Actual","Portugal",558.44459999999992,580.51080000000002,566.9316,527.89139999999998,563.53680000000008,524.49659999999994,534.68100000000004,539.77320000000009,524.49659999999994,509.22,493.9434,488.85120000000001,6412.7772000000004]
[]
["Expenses","Plan","England",601.74900000000002,650.91150000000005,643.04549999999995,629.28,580.11749999999995,591.91650000000004,544.72050000000002,511.29,489.762,495.41310000000004,538.73820000000012,555.69150000000002,{"$f":"SUM(D35:O35)","v":6832.635299999999}]
["Expenses","Plan","Scotland",458.19450000000001,450.32850000000002,438.52949999999998,424.76400000000001,442.46249999999998,420.83100000000002,377.56799999999998,355.93650000000002,316.46160000000003,344.71710000000002,331.53120000000001,357.90300000000002,{"$f":"SUM(D36:O36)","v":4719.2273999999998}]
["Expenses","Plan","Wales",363.80250000000001,355.93650000000002,346.10399999999998,363.80250000000001,385.43400000000003,353.97,322.50599999999997,312.67349999999999,314.5779,346.60079999999999,339.06599999999997,356.01929999999999,4160.4929999999995]
["Expenses","Plan","Ireland",635.17949999999996,660.74400000000003,664.67700000000002,625.34699999999998,643.04549999999995,676.47599999999989,715.80600000000004,766.93499999999995,668.71349999999995,668.71349999999995,721.45709999999997,785.50290000000007,8232.5969999999979]
["Expenses","Plan","Germany",749.13300000000015,778.73400000000026,760.51800000000014,708.14700000000016,755.96400000000017,703.59300000000007,717.25500000000011,599.01659999999993,582.06330000000003,565.11,548.15670000000011,542.50559999999996,8010.1962000000003]
["Expenses","Plan","France",719.73900000000003,735.471,764.96849999999995,696.14099999999996,704.00699999999995,753.16949999999997,737.4375,707.94,651.76019999999994,625.38840000000005,631.03949999999998,663.06240000000003,8390.1239999999998]
["Expenses","Plan","Italy",171.81,155.25,140.76,126.27,113.85,101.43,91.08,82.8,74.52,66.239999999999995,60.03,53.82,1237.8600000000001]
["Expenses","Plan","Spain",1184.04,1190.8710000000001,1222.749,1136.223,1147.6079999999999,1207.4413500000001,1170.4566599999998,1218.3192000000001,1279.23516,1150.87653,1207.4413500000001,1207.4413500000001,14322.702600000001]
["Expenses","Plan","Greece",938.02049999999997,959.65200000000004,971.45100000000002,1030.4459999999999,1132.704,1030.4459999999999,989.14949999999999,979.31700000000001,938.08259999999996,881.57159999999999,917.36189999999999,907.9434,11676.145500000001]
["Expenses","Plan","Portugal",614.28906000000006,638.5618800000002,623.62476000000004,580.68054000000018,619.89048000000014,576.94626000000005,588.14909999999998,491.19361199999997,477.29190599999998,463.39019999999994,449.488494,444.85459199999997,6568.3608840000006]
[]
["EBIT","Actual","England",{"$f":"D2-D24","v":70.38},{"$f":"E2-E24","v":76.13},75.210000000000036,73.600000000000023,67.850000000000023,69.229999999999905,63.710000000000036,59.799999999999955,59.799999999999955,60.490000000000009,65.779999999999973,67.850000000000023,{"$f":"SUM(D46:O46)","v":809.82999999999993}]
["EBIT","Actual","Scotland",{"$f":"D3-D25","v":53.589999999999975},52.670000000000073,51.289999999999964,49.680000000000007,51.75,49.21999999999997,44.160000000000025,41.629999999999995,38.639999999999986,42.089999999999975,40.480000000000018,43.699999999999989,{"$f":"SUM(D47:O47)","v":558.90000000000009}]
["EBIT","Actual","Wales",{"$f":"D4-D26","v":42.550000000000011},41.629999999999995,40.480000000000018,42.550000000000011,45.079999999999984,41.399999999999977,37.71999999999997,36.569999999999993,38.410000000000025,42.319999999999993,41.399999999999977,43.46999999999997,493.57999999999993]
["EBIT","Actual","Ireland",{"$f":"D5-D27","v":74.289999999999964},77.279999999999973,77.740000000000009,73.139999999999986,75.210000000000036,79.12,83.720000000000027,89.700000000000045,81.649999999999977,81.649999999999977,88.090000000000032,95.909999999999968,977.5]
["EBIT","Actual","Germany",{"$f":"D6-D28","v":75.670000000000073},78.659999999999968,76.82000000000005,71.529999999999973,76.360000000000014,71.07000000000005,72.450000000000045,73.139999999999986,71.07000000000005,69,66.92999999999995,66.240000000000009,868.94000000000017]
["EBIT","Actual","France",{"$f":"D7-D29","v":84.17999999999995},86.020000000000095,89.470000000000027,81.420000000000073,82.340000000000032,88.090000000000032,86.25,82.799999999999955,79.579999999999927,76.360000000000014,77.049999999999955,80.960000000000036,994.5200000000001]
["EBIT","Actual","Italy",{"$f":"D8-D30","v":19.78},19.319999999999993,18.630000000000024,17.710000000000008,17.25,15.640000000000015,16.789999999999992,17.019999999999982,18.859999999999985,18.400000000000006,19.319999999999993,18.400000000000006,217.12]
["EBIT","Actual","Spain",{"$f":"D9-D31","v":119.59999999999991},120.29000000000019,123.50999999999999,114.76999999999998,115.92000000000007,127.65000000000009,123.74000000000001,128.79999999999995,135.24,121.67000000000007,127.65000000000009,127.65000000000009,1486.4900000000005]
["EBIT","Actual","Greece",{"$f":"D10-D32","v":109.70999999999992},112.24000000000012,113.62,120.51999999999998,132.48000000000002,120.51999999999998,115.69000000000005,114.54000000000019,114.54000000000019,107.6400000000001,112.00999999999988,110.8599999999999,1384.3700000000006]
["EBIT","Actual","Portugal",{"$f":"D11-D33","v":62.049400000000105},64.501199999999926,62.992399999999975,58.654600000000073,62.615199999999959,58.277400000000057,59.408999999999992,59.974799999999959,58.277400000000057,56.579999999999927,54.882600000000025,54.316800000000001,712.5308]
[]
["EBIT","Plan","England",{"$f":"D13-D35","v":66.86099999999999},72.323499999999967,71.449500000000057,69.920000000000073,64.457500000000095,65.768499999999904,60.524499999999989,56.81,54.41799999999995,55.045899999999904,59.859799999999836,61.743499999999926,{"$f":"SUM(D57:O57)","v":759.18169999999964}]
["EBIT","Plan","Scotland",{"$f":"D14-D36","v":50.910500000000013},50.03649999999999,48.725500000000011,47.19599999999997,49.162500000000023,46.758999999999958,41.951999999999998,39.54849999999999,35.162399999999991,38.301899999999989,36.836799999999982,39.766999999999996,{"$f":"SUM(D58:O58)","v":524.35859999999991}]
["EBIT","Plan","Wales",{"$f":"D15-D37","v":40.422500000000014},39.54849999999999,38.456000000000017,40.422500000000014,42.825999999999965,39.329999999999984,35.834000000000003,34.74150000000003,34.953100000000006,38.511200000000031,37.674000000000035,39.557700000000011,462.2770000000001]
["EBIT","Plan","Ireland",{"$f":"D16-D38","v":70.575500000000034},73.41599999999994,73.852999999999952,69.483000000000061,71.449500000000057,75.163999999999987,79.533999999999992,85.215000000000032,74.301500000000033,74.301500000000033,80.16190000000006,87.278099999999881,914.73300000000006]
["EBIT","Plan","Germany",{"$f":"D17-D39","v":83.236999999999966},86.525999999999954,84.501999999999953,78.682999999999993,83.995999999999981,78.177000000000021,79.69500000000005,66.55740000000003,64.67369999999994,62.789999999999964,60.906299999999874,60.278400000000033,890.02179999999976]
["EBIT","Plan","France",{"$f":"D18-D40","v":79.971000000000004},81.719000000000051,84.996500000000083,77.349000000000046,78.22300000000007,83.685500000000047,81.9375,78.659999999999968,72.417799999999943,69.487599999999929,70.115499999999997,73.673599999999965,932.2360000000001]
["EBIT","Plan","Italy",{"$f":"D19-D41","v":19.090000000000003},17.25,15.640000000000015,14.030000000000015,12.650000000000006,11.269999999999996,10.120000000000005,9.2000000000000028,8.2800000000000011,7.3599999999999994,6.6700000000000017,5.9799999999999969,137.54000000000005]
["EBIT","Plan","Spain",{"$f":"D20-D42","v":131.55999999999995},132.31899999999996,135.86099999999988,126.24700000000007,127.51199999999994,134.16014999999993,130.05074000000013,135.36880000000019,142.13724000000002,127.87517000000003,134.16014999999993,134.16014999999993,1591.4114]
["EBIT","Plan","Greece",{"$f":"D21-D43","v":104.22449999999992},106.62799999999993,107.93900000000008,114.49400000000014,125.85599999999999,114.49400000000014,109.90550000000007,108.8130000000001,104.23140000000012,97.952400000000011,101.92910000000006,100.88260000000002,1297.3495000000007]
["EBIT","Plan","Portugal",{"$f":"D22-D44","v":68.254339999999956},70.95132000000001,69.291640000000029,64.520059999999944,68.876719999999978,64.105140000000006,65.349900000000048,54.577067999999997,53.032434000000023,51.487799999999993,49.943165999999962,49.428287999999952,729.81787599999973]
[]
[{"$f":"OFFSET(List!$C$1,Report!$D$7,,1,1)","v":"Expenses"},"Actual",{"$f":"C57","v":"England"},{"$f":"SUMPRODUCT(($A$2:$A$66=$A68)*($B$2:$B$66=$B68)*($C$2:$C$66=$C68)*(D$2:D$66))","v":633.41999999999996},{"$f":"SUMPRODUCT(($A$2:$A$66=$A68)*($B$2:$B$66=$B68)*($C$2:$C$66=$C68)*(E$2:E$66))","v":685.17},676.89,662.4,610.65,623.07000000000005,573.39,538.20000000000005,538.20000000000005,544.41,592.02,610.65,{"$f":"SUM(D68:O68)","v":7288.4699999999993}]
[{"$f":"OFFSET(List!$C$1,Report!$D$7,,1,1)","v":"Expenses"},"Actual",{"$f":"C58","v":"Scotland"},{"$f":"SUMPRODUCT(($A$2:$A$66=$A69)*($B$2:$B$66=$B69)*($C$2:$C$66=$C69)*(D$2:D$66))","v":482.31},474.03,461.61,447.12,465.75,442.98,397.44,374.67,347.76,378.81,364.32,393.3,{"$f":"SUM(D69:O69)","v":5030.1000000000004}]
[{"$f":"OFFSET(List!$C$1,Report!$D$7,,1,1)","v":"Expenses"},"Actual","Wales",382.95,374.67,364.32,382.95,405.72,372.6,339.48,329.13,345.69,380.88,372.6,391.23,4442.22]
[{"$f":"OFFSET(List!$C$1,Report!$D$7,,1,1)","v":"Expenses"},"Actual","Ireland",668.61,695.52,699.66,658.26,676.89,712.07999999999993,753.48,807.3,734.85,734.85,792.81,863.19,8797.5000000000018]
[{"$f":"OFFSET(List!$C$1,Report!$D$7,,1,1)","v":"Expenses"},"Actual","Germany",681.03,707.94000000000017,691.38,643.77,687.24,639.63,652.04999999999995,658.26,639.63,621,602.37,596.16,7820.4600000000009]
[{"$f":"OFFSET(List!$C$1,Report!$D$7,,1,1)","v":"Expenses"},"Actual","France",757.62,774.18,805.23,732.78,741.06,792.81,776.25,745.2,716.21999999999991,687.24,693.45,728.64,8950.6799999999985]
[{"$f":"OFFSET(List!$C$1,Report!$D$7,,1,1)","v":"Expenses"},"Actual","Italy",178.01999999999998,173.88,167.67,159.38999999999999,155.25,140.76,151.11000000000001,153.18,169.74,165.6,173.88,165.6,1954.08]
[{"$f":"OFFSET(List!$C$1,Report!$D$7,,1,1)","v":"Expenses"},"Actual","Spain",1076.4000000000001,1082.6099999999999,1111.5899999999999,1032.93,1043.28,1148.8499999999999,1113.6600000000001,1159.2000000000003,1217.1600000000001,1095.03,1148.8499999999999,1148.8499999999999,13378.410000000002]
[{"$f":"OFFSET(List!$C$1,Report!$D$7,,1,1)","v":"Expenses"},"Actual","Greece",987.39,1010.16,1022.58,1084.68,1192.32,1084.68,1041.21,1030.8599999999999,1030.8599999999999,968.76,1008.09,997.74,12459.330000000002]
[{"$f":"OFFSET(List!$C$1,Report!$D$7,,1,1)","v":"Expenses"},"Actual","Portugal",558.44459999999992,580.51080000000002,566.9316,527.89139999999998,563.53680000000008,524.49659999999994,534.68100000000004,539.77320000000009,524.49659999999994,509.22,493.9434,488.85120000000001,6412.7772000000004]
[]
[{"$f":"OFFSET(List!$C$1,Report!$D$7,,1,1)","v":"Expenses"},"Plan",{"$f":"C68","v":"England"},{"$f":"SUMPRODUCT(($A$2:$A$66=$A79)*($B$2:$B$66=$B79)*($C$2:$C$66=$C79)*(D$2:D$66))","v":601.74900000000002},{"$f":"SUMPRODUCT(($A$2:$A$66=$A79)*($B$2:$B$66=$B79)*($C$2:$C$66=$C79)*(E$2:E$66))","v":650.91150000000005},643.04549999999995,629.28,580.11749999999995,591.91650000000004,544.72050000000002,511.29,489.762,495.41310000000004,538.73820000000012,555.69150000000002,{"$f":"SUM(D79:O79)","v":6832.635299999999}]
[{"$f":"OFFSET(List!$C$1,Report!$D$7,,1,1)","v":"Expenses"},"Plan",{"$f":"C69","v":"Scotland"},{"$f":"SUMPRODUCT(($A$2:$A$66=$A80)*($B$2:$B$66=$B80)*($C$2:$C$66=$C80)*(D$2:D$66))","v":458.19450000000001},450.32850000000002,438.52949999999998,424.76400000000001,442.46249999999998,420.83100000000002,377.56799999999998,355.93650000000002,316.46160000000003,344.71710000000002,331.53120000000001,357.90300000000002,{"$f":"SUM(D80:O80)","v":4719.2273999999998}]
[{"$f":"OFFSET(List!$C$1,Report!$D$7,,1,1)","v":"Expenses"},"Plan","Wales",363.80250000000001,355.93650000000002,346.10399999999998,363.80250000000001,385.43400000000003,353.97,322.50599999999997,312.67349999999999,314.5779,346.60079999999999,339.06599999999997,356.01929999999999,4160.4929999999995]
[{"$f":"OFFSET(List!$C$1,Report!$D$7,,1,1)","v":"Expenses"},"Plan","Ireland",635.17949999999996,660.74400000000003,664.67700000000002,625.34699999999998,643.04549999999995,676.47599999999989,715.80600000000004,766.93499999999995,668.71349999999995,668.71349999999995,721.45709999999997,785.50290000000007,8232.5969999999979]
[{"$f":"OFFSET(List!$C$1,Report!$D$7,,1,1)","v":"Expenses"},"Plan","Germany",749.13300000000015,778.73400000000026,760.51800000000014,708.14700000000016,755.96400000000017,703.59300000000007,717.25500000000011,599.01659999999993,582.06330000000003,565.11,548.15670000000011,542.50559999999996,8010.1962000000003]
[{"$f":"OFFSET(List!$C$1,Report!$D$7,,1,1)","v":"Expenses"},"Plan","France",719.73900000000003,735.471,764.96849999999995,696.14099999999996,704.00699999999995,753.16949999999997,737.4375,707.94,651.76019999999994,625.38840000000005,631.03949999999998,663.06240000000003,8390.1239999999998]
[{"$f":"OFFSET(List!$C$1,Report!$D$7,,1,1)","v":"Expenses"},"Plan","Italy",171.81,155.25,140.76,126.27,113.85,101.43,91.08,82.8,74.52,66.239999999999995,60.03,53.82,1237.8600000000001]
[{"$f":"OFFSET(List!$C$1,Report!$D$7,,1,1)","v":"Expenses"},"Plan","Spain",1184.04,1190.8710000000001,1222.749,1136.223,1147.6079999999999,1207.4413500000001,1170.4566599999998,1218.3192000000001,1279.23516,1150.87653,1207.4413500000001,1207.4413500000001,14322.702600000001]
[{"$f":"OFFSET(List!$C$1,Report!$D$7,,1,1)","v":"Expenses"},"Plan","Greece",938.02049999999997,959.65200000000004,971.45100000000002,1030.4459999999999,1132.704,1030.4459999999999,989.14949999999999,979.31700000000001,938.08259999999996,881.57159999999999,917.36189999999999,907.9434,11676.145500000001]
[{"$f":"OFFSET(List!$C$1,Report!$D$7,,1,1)","v":"Expenses"},"Plan","Portugal",614.28906000000006,638.5618800000002,623.62476000000004,580.68054000000018,619.89048000000014,576.94626000000005,588.14909999999998,491.19361199999997,477.29190599999998,463.39019999999994,449.488494,444.85459199999997,6568.3608840000006]

{"sheet":"Chart","index":2,"n_rows":46,"n_cols":5,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["Desc","Region","Country","Actual","Plan"]
["Actual","Europe","England",62,72]
["Actual","Europe","Scotland",48,52.8]
["Actual","Europe","Wales",52,60]
["Actual","Europe","Ireland",66,74.399999999999991]
["Actual","Europe","Germany",68,60]
["Actual","Europe","France",74,79]
["Actual","Europe","Italy",48,49]
["Actual","Europe","Spain",70,77]
["Actual","Europe","Greece",50,39]
["Actual","Europe","Portugal",54,72]
[]
["Actual","Americas","USA",62,72]
["Actual","Americas","Canada",52,60]
["Actual","Americas","Mexico",42,50.4]
["Actual","Americas","Columbia",66,76.8]
["Actual","Americas","Brazil",70,66]
["Actual","Americas","Chile",76,66]
["Actual","Americas","Venezuala",70,73]
["Actual","Americas","Cuba",45,50]
["Actual","Americas","Uraguay",39,57]
["Actual","Americas","Argentina",56,67.2]
[null,null,null,0,0]
["Actual","Asia Pac","Australia",64,57.599999999999994]
["Actual","Asia Pac","New Zealand",58,62.4]
["Actual","Asia Pac","China",48,50.4]
["Actual","Asia Pac","Hong Kong",68,72]
["Actual","Asia Pac","India",47,60]
["Actual","Asia Pac","Pakistan",76,57.599999999999994]
["Actual","Asia Pac","Bangladesh",44,45.6]
["Actual","Asia Pac","Vietnam",50,60]
["Actual","Asia Pac","Cambodia",50,39]
["Actual","Asia Pac","Laos",34,36]
[null,null,null,0]
[]
[]
["Actual","Americas",{"$f":"OFFSET(C1,MATCH(B37,$B$2:$B$34,0),0,1)","v":"USA"},{"$f":"SUMPRODUCT(($A$2:$A$34=$A37)*($C$2:$C$34=$C37)*(D$2:D$34))","v":62},72]
["Actual","Americas","Canada",52,60]
["Actual","Americas","Mexico",42,50.4]
["Actual","Americas","Columbia",66,76.8]
["Actual","Americas","Brazil",70,66]
["Actual","Americas","Chile",76,66]
["Actual","Americas","Venezuala",70,73]
["Actual","Americas","Cuba",45,50]
["Actual","Americas","Uraguay",39,57]
["Actual","Americas","Argentina",56,67.2]

{"sheet":"Report","index":3,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,2]
[]
[null,"Country",{"$f":"Data!A68","v":"Expenses"},"Plan","Var"]
[null,{"$f":"Data!C68","v":"England"},{"$f":"Data!P68","v":7288.4699999999993},{"$f":"Data!P79","v":6832.635299999999},{"$f":"C10-D10","v":455.83470000000034}]
[null,{"$f":"Data!C69","v":"Scotland"},{"$f":"Data!P69","v":5030.1000000000004},{"$f":"Data!P80","v":4719.2273999999998},{"$f":"C11-D11","v":310.8726000000006}]
[null,{"$f":"Data!C70","v":"Wales"},{"$f":"Data!P70","v":4442.22},{"$f":"Data!P81","v":4160.4929999999995},281.72700000000077]
[null,{"$f":"Data!C71","v":"Ireland"},{"$f":"Data!P71","v":8797.5000000000018},{"$f":"Data!P82","v":8232.5969999999979},564.90300000000389]
[null,{"$f":"Data!C72","v":"Germany"},{"$f":"Data!P72","v":7820.4600000000009},{"$f":"Data!P83","v":8010.1962000000003},-189.73619999999937]
[null,{"$f":"Data!C73","v":"France"},{"$f":"Data!P73","v":8950.6799999999985},{"$f":"Data!P84","v":8390.1239999999998},560.55599999999868]
[null,{"$f":"Data!C74","v":"Italy"},{"$f":"Data!P74","v":1954.08},{"$f":"Data!P85","v":1237.8600000000001},716.2199999999998]
[null,{"$f":"Data!C75","v":"Spain"},{"$f":"Data!P75","v":13378.410000000002},{"$f":"Data!P86","v":14322.702600000001},-944.29259999999886]
[null,{"$f":"Data!C76","v":"Greece"},{"$f":"Data!P76","v":12459.330000000002},{"$f":"Data!P87","v":11676.145500000001},783.18450000000121]
[null,{"$f":"Data!C77","v":"Portugal"},{"$f":"Data!P77","v":6412.7772000000004},{"$f":"Data!P88","v":6568.3608840000006},-155.58368400000018]