{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sales Dashboard","Dashboard"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":4},"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":"Sales Dashboard","index":0,"n_rows":146,"n_cols":38,"rows_kept":146,"cut":false,"hidden":false,"merged":[[0,4,0,27],[0,28,0,29],[0,30,0,33],[0,34,0,37]]}
[null,null,null,null,"Sales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly",null,2011,null,null,null,2012]
["Region","Product","Customer Type","Sales Person - Name","2011-01-01","2011-02-01","2011-03-01","2011-04-01","2011-05-01","2011-06-01","2011-07-01","2011-08-01","2011-09-01","2011-10-01","2011-11-01","2011-12-01","2012-01-01","2012-02-01","2012-03-01","2012-04-01","2012-05-01","2012-06-01","2012-07-01","2012-08-01","2012-09-01","2012-10-01","2012-11-01","2012-12-01",2011,2012,"2011_Q1","2011_Q2","2011_Q3","2011_Q4","2012_Q1","2012_Q2","2012_Q3","2012_Q4"]
["Region 1","Product 1","Customer 1","Person 1",717,641,654,752,595,769,793,710,564,677,619,723,639,757,746,758,562,563,782,559,640,669,774,692,{"$f":"SUMPRODUCT(--(YEAR($E$2:$AB$2)=AC$2),$E3:$AB3)","v":8214},8141,{"$f":"SUM(OFFSET($E3,,3*COLUMN(A$1)-3,,3))","v":2012},{"$f":"SUM(OFFSET($E3,,3*COLUMN(B$1)-3,,3))","v":2116},{"$f":"SUM(OFFSET($E3,,3*COLUMN(C$1)-3,,3))","v":2067},2019,2142,1883,1981,2135]
["Region 1","Product 1","Customer 2","Person 2",1400,1220,1114,899,1351,835,873,909,888,1278,1350,1348,931,1298,1164,800,903,958,836,909,853,918,1223,886,13465,11679,{"$f":"SUM(OFFSET($E4,,3*COLUMN(A$1)-3,,3))","v":3734},{"$f":"SUM(OFFSET($E4,,3*COLUMN(B$1)-3,,3))","v":3085},{"$f":"SUM(OFFSET($E4,,3*COLUMN(C$1)-3,,3))","v":2670},{"$f":"SUM(OFFSET($E4,,3*COLUMN(D$1)-3,,3))","v":3976},{"$f":"SUM(OFFSET($E4,,3*COLUMN(E$1)-3,,3))","v":3393},{"$f":"SUM(OFFSET($E4,,3*COLUMN(F$1)-3,,3))","v":2661},{"$f":"SUM(OFFSET($E4,,3*COLUMN(G$1)-3,,3))","v":2598},{"$f":"SUM(OFFSET($E4,,3*COLUMN(H$1)-3,,3))","v":3027}]
["Region 1","Product 1","Customer 3","Person 3",696,643,644,596,645,649,612,675,794,591,709,561,733,771,792,577,586,727,678,753,652,689,767,643,7815,8368,1983,1890,2081,1861,2296,1890,2083,2099]
["Region 1","Product 1","Customer 4","Person 4",732,628,628,667,819,640,850,755,612,644,622,881,854,766,713,784,667,711,733,677,637,815,756,693,8478,8806,1988,2126,2217,2147,2333,2162,2047,2264]
["Region 1","Product 1","Customer 5","Person 5",607,602,636,869,847,806,895,835,843,799,834,785,744,858,799,677,867,605,828,620,655,704,784,635,9358,8776,1845,2522,2573,2418,2401,2149,2103,2123]
["Region 1","Product 1","Customer 6","Person 6",800,607,737,621,660,733,743,666,630,644,617,695,653,648,788,731,710,745,788,756,627,669,731,650,8153,8496,2144,2014,2039,1956,2089,2186,2171,2050]
["Region 1","Product 1","Customer 7","Person 7",1064,863,1316,1141,933,872,1185,1358,1173,1343,1164,1275,1364,828,1299,863,910,1146,915,941,1093,1224,938,946,13687,12467,3243,2946,3716,3782,3491,2919,2949,3108]
["Region 1","Product 1","Customer 8","Person 8",667,609,780,559,673,727,730,550,787,609,762,604,555,747,640,649,565,725,602,594,799,721,786,589,8057,7972,2056,1959,2067,1975,1942,1939,1995,2096]
["Region 1","Product 1","Customer 9","Person 9",890,751,645,807,845,820,832,771,724,696,657,899,693,705,749,758,774,652,801,815,649,638,615,896,9337,8745,2286,2472,2327,2252,2147,2184,2265,2149]
["Region 1","Product 1","Customer 10","Person 10",711,624,804,885,873,628,666,648,879,779,782,605,830,775,895,707,826,719,845,615,839,779,822,866,8884,9518,2139,2386,2193,2166,2500,2252,2299,2467]
["Region 1","Product 1","Customer 11","Person 11",651,788,748,703,701,692,771,738,646,608,786,737,603,604,632,680,729,756,795,772,663,768,735,683,8569,8420,2187,2096,2155,2131,1839,2165,2230,2186]
["Region 1","Product 1","Customer 12","Person 12",1075,1154,866,1055,990,1364,934,1193,1161,1323,1060,1058,1117,944,1004,1172,1074,1283,840,1050,1031,852,1192,1113,13233,12672,3095,3409,3288,3441,3065,3529,2921,3157]
["Region 1","Product 2","Customer 1","Person 1",580,682,641,761,759,787,595,654,763,591,639,722,745,685,678,641,600,690,766,783,662,592,636,711,8174,8189,1903,2307,2012,1952,2108,1931,2211,1939]
["Region 1","Product 2","Customer 2","Person 2",756,790,609,886,656,620,668,786,755,738,742,655,793,647,653,856,687,744,874,795,881,806,772,883,8661,9391,2155,2162,2209,2135,2093,2287,2550,2461]
["Region 1","Product 2","Customer 3","Person 3",779,659,813,800,859,844,714,764,881,693,739,753,860,872,833,833,835,870,863,896,775,867,617,702,9298,9823,2251,2503,2359,2185,2565,2538,2534,2186]
["Region 1","Product 2","Customer 4","Person 4",658,681,756,717,621,766,780,712,765,620,651,619,682,696,749,757,735,654,729,755,677,610,700,624,8346,8368,2095,2104,2257,1890,2127,2146,2161,1934]
["Region 1","Product 2","Customer 5","Person 5",1230,817,1030,1078,1093,1172,1323,1053,1121,1301,1103,1190,1248,1007,1003,908,830,1107,800,1117,1189,1352,1084,1012,13511,12657,3077,3343,3497,3594,3258,2845,3106,3448]
["Region 1","Product 2","Customer 6","Person 6",727,586,583,673,706,610,645,556,560,646,658,592,630,576,657,574,586,600,625,568,597,698,588,596,7542,7295,1896,1989,1761,1896,1863,1760,1790,1882]
["Region 1","Product 2","Customer 7","Person 7",642,778,843,881,726,850,827,759,721,618,757,899,632,853,824,833,880,787,760,726,637,669,844,875,9301,9320,2263,2457,2307,2274,2309,2500,2123,2388]
["Region 1","Product 2","Customer 8","Person 8",888,697,861,701,748,779,850,744,720,613,651,870,651,871,870,725,691,848,689,847,615,706,755,754,9122,9022,2446,2228,2314,2134,2392,2264,2151,2215]
["Region 1","Product 2","Customer 9","Person 9",605,749,605,729,600,795,695,680,606,782,765,774,767,705,740,627,696,615,693,626,625,712,710,728,{"$f":"SUMPRODUCT(--(YEAR($E$2:$AB$2)=AC$2),$E23:$AB23)","v":8385},8244,1959,2124,1981,2321,2212,1938,1944,2150]
["Region 1","Product 2","Customer 10","Person 10",1073,1161,905,1017,895,1224,1130,1314,1213,1254,942,903,870,1151,807,878,1325,804,905,1057,1193,1375,923,1093,13031,12381,3139,3136,3657,3099,2828,3007,3155,3391]
["Region 1","Product 2","Customer 11","Person 11",689,688,737,759,581,608,576,704,789,617,743,684,617,554,638,611,614,697,721,691,771,570,704,764,8175,7952,2114,1948,2069,2044,1809,1922,2183,2038]
["Region 1","Product 2","Customer 12","Person 12",715,636,679,832,780,711,879,660,880,737,602,735,684,721,838,806,855,872,605,675,802,662,600,721,8846,8841,2030,2323,2419,2074,2243,2533,2082,1983]
["Region 1","Product 3","Customer 1","Person 1",637,646,671,714,744,786,784,697,636,654,760,722,889,631,744,834,670,853,830,827,650,696,631,851,8451,9106,1954,2244,2117,2136,2264,2357,2307,2178]
["Region 1","Product 3","Customer 2","Person 2",692,716,645,726,681,601,733,627,783,614,602,705,756,746,623,682,780,672,679,624,751,727,779,761,8125,8580,2053,2008,2143,1921,2125,2134,2054,2267]
["Region 1","Product 3","Customer 3","Person 3",1284,1302,1316,1210,823,1206,1253,1043,1223,1400,1094,881,1006,1045,1173,1102,1065,1363,1132,1212,1196,1189,962,1359,14035,13804,3902,3239,3519,3375,3224,3530,3540,3510]
["Region 1","Product 3","Customer 4","Person 4",660,750,649,652,738,694,756,551,768,647,725,780,608,673,752,698,642,671,575,633,704,652,717,775,8370,8100,2059,2084,2075,2152,2033,2011,1912,2144]
["Region 1","Product 3","Customer 5","Person 5",880,775,830,713,825,722,779,768,715,708,664,609,822,630,652,732,733,849,880,848,850,788,768,612,8988,9164,2485,2260,2262,1981,2104,2314,2578,2168]
["Region 1","Product 3","Customer 6","Person 6",804,646,608,674,698,850,617,751,655,656,673,877,608,794,631,743,843,800,705,860,686,896,663,779,8509,9008,2058,2222,2023,2206,2033,2386,2251,2338]
["Region 1","Product 3","Customer 7","Person 7",712,663,689,778,603,785,600,776,714,785,681,762,634,720,780,789,644,606,683,708,718,773,600,777,8548,8432,2064,2166,2090,2228,2134,2039,2109,2150]
["Region 1","Product 3","Customer 8","Person 8",826,1022,1238,993,1219,1107,965,867,1205,872,892,944,1281,993,1254,1366,834,883,898,1255,1114,1137,900,1291,12150,13206,3086,3319,3037,2708,3528,3083,3267,3328]
["Region 1","Product 3","Customer 9","Person 9",786,614,706,763,695,648,728,578,680,573,701,645,795,763,674,628,559,702,685,663,550,708,680,776,8117,8183,2106,2106,1986,1919,2232,1889,1898,2164]
["Region 1","Product 3","Customer 10","Person 10",800,674,757,825,779,751,693,608,675,705,892,653,608,619,814,823,759,740,873,731,796,866,773,878,8812,9280,2231,2355,1976,2250,2041,2322,2400,2517]
["Region 1","Product 3","Customer 11","Person 11",754,664,667,787,894,740,803,883,755,708,612,730,832,674,771,704,867,791,747,695,704,671,874,829,8997,9159,2085,2421,2441,2050,2277,2362,2146,2374]
["Region 1","Product 3","Customer 12","Person 12",782,660,631,685,646,605,701,709,699,725,725,753,665,645,698,682,779,757,773,778,726,652,776,724,8321,8655,2073,1936,2109,2203,2008,2218,2277,2152]
["Region 2","Product 4","Customer 1","Person 1",1194,1397,1397,1064,1211,1183,827,1088,1394,1076,1106,1372,1107,871,910,1305,1054,1122,1314,1360,801,1275,1316,918,14309,13353,3988,3458,3309,3554,2888,3481,3475,3509]
["Region 2","Product 4","Customer 2","Person 2",733,607,647,786,719,775,567,620,577,671,689,762,609,780,753,590,696,695,581,739,564,598,634,689,8153,7928,1987,2280,1764,2122,2142,1981,1884,1921]
["Region 2","Product 4","Customer 3","Person 3",666,815,820,862,847,752,657,620,869,848,848,886,831,712,632,883,786,821,631,615,712,870,785,794,9490,9072,2301,2461,2146,2582,2175,2490,1958,2449]
["Region 2","Product 4","Customer 4","Person 4",746,702,886,608,748,652,755,807,607,810,778,684,756,759,673,638,795,785,601,755,699,715,618,829,8783,8623,2334,2008,2169,2272,2188,2218,2055,2162]
["Region 2","Product 4","Customer 5","Person 5",753,690,646,653,795,736,667,668,733,674,620,778,757,738,661,721,639,601,732,621,668,764,742,761,{"$f":"SUMPRODUCT(--(YEAR($E$2:$AB$2)=AC$2),$E43:$AB43)","v":8413},8405,2089,2184,2068,2072,2156,1961,2021,2267]
["Region 2","Product 4","Customer 6","Person 6",1271,1188,1090,856,840,1217,933,1296,976,971,869,896,1323,1247,1081,985,1091,951,1175,1299,1254,857,1360,1386,12403,14009,3549,2913,3205,2736,3651,3027,3728,3603]
["Region 2","Product 4","Customer 7","Person 7",797,641,785,621,709,657,570,565,560,759,573,741,728,717,689,634,756,563,626,748,792,673,679,787,7978,8392,2223,1987,1695,2073,2134,1953,2166,2139]
["Region 2","Product 4","Customer 8","Person 8",686,637,731,863,821,678,833,840,748,838,618,822,625,820,865,616,606,793,626,726,664,603,794,657,9115,8395,2054,2362,2421,2278,2310,2015,2016,2054]
["Region 2","Product 4","Customer 9","Person 9",618,782,753,691,642,833,633,829,656,758,626,874,778,884,739,833,665,766,614,619,843,614,600,875,8695,8830,2153,2166,2118,2258,2401,2264,2076,2089]
["Region 2","Product 4","Customer 10","Person 10",737,604,749,669,740,724,600,671,603,624,700,693,631,701,693,792,672,691,698,683,643,668,719,702,8114,8293,2090,2133,1874,2017,2025,2155,2024,2089]
["Region 2","Product 4","Customer 11","Person 11",849,989,1062,1241,1193,847,1212,1000,1378,1198,1319,898,1203,800,1341,861,1383,1198,1186,921,1358,1352,1376,1387,13186,14366,2900,3281,3590,3415,3344,3442,3465,4115]
["Region 2","Product 4","Customer 12","Person 12",655,552,783,759,655,754,796,634,600,652,585,707,767,601,684,755,713,756,729,610,699,755,685,752,8132,8506,1990,2168,2030,1944,2052,2224,2038,2192]
["Region 2","Product 5","Customer 1","Person 1",828,752,854,899,822,701,826,833,724,612,872,768,797,699,645,835,765,610,685,608,674,613,847,821,9491,8599,2434,2422,2383,2252,2141,2210,1967,2281]
["Region 2","Product 5","Customer 2","Person 2",701,880,768,803,629,688,764,814,832,883,721,879,674,727,633,733,746,682,839,610,753,847,641,745,9362,8630,2349,2120,2410,2483,2034,2161,2202,2233]
["Region 2","Product 5","Customer 3","Person 3",636,608,662,734,766,627,673,761,785,685,769,705,678,644,726,793,786,693,713,701,650,637,770,608,8411,8399,1906,2127,2219,2159,2048,2272,2064,2015]
["Region 2","Product 5","Customer 4","Person 4",854,1079,1313,1214,1393,1176,1272,1288,829,1277,1165,856,953,1070,1297,1261,1037,1179,1147,838,1038,895,804,1025,13716,12544,3246,3783,3389,3298,3320,3477,3023,2724]
["Region 2","Product 5","Customer 5","Person 5",678,599,569,766,664,650,763,662,733,718,726,585,568,612,603,716,623,782,725,753,774,672,570,732,8113,8130,1846,2080,2158,2029,1783,2121,2252,1974]
["Region 2","Product 5","Customer 6","Person 6",848,755,642,600,749,742,667,642,601,831,792,743,605,834,884,795,728,791,641,832,696,684,810,692,8612,8992,2245,2091,1910,2366,2323,2314,2169,2186]
["Region 2","Product 5","Customer 7","Person 7",739,850,712,733,873,638,850,900,725,735,824,735,811,870,793,712,771,881,894,651,684,674,763,878,9314,9382,2301,2244,2475,2294,2474,2364,2229,2315]
["Region 2","Product 5","Customer 8","Person 8",799,763,771,671,763,675,735,798,744,627,730,677,783,661,769,630,778,642,662,799,690,727,794,664,8753,8599,2333,2109,2277,2034,2213,2050,2151,2185]
["Region 2","Product 5","Customer 9","Person 9",1253,1047,1370,1061,974,853,927,1030,1163,890,1057,1025,1084,895,951,1186,1084,931,1064,997,1070,1265,1294,1277,12650,13098,3670,2888,3120,2972,2930,3201,3131,3836]
["Region 2","Product 5","Customer 10","Person 10",798,727,572,608,602,800,688,617,800,658,675,618,717,635,566,618,697,761,552,760,609,686,733,698,8163,8032,2097,2010,2105,1951,1918,2076,1921,2117]
["Region 2","Product 5","Customer 11","Person 11",794,698,694,834,760,817,807,706,801,775,760,610,781,635,816,757,841,660,819,794,899,657,827,665,9056,9151,2186,2411,2314,2145,2232,2258,2512,2149]
["Region 2","Product 5","Customer 12","Person 12",854,631,878,807,833,886,708,875,879,681,673,737,875,898,877,743,860,801,713,618,673,879,670,643,9442,9250,2363,2526,2462,2091,2650,2404,2004,2192]
["Region 2","Product 6","Customer 1","Person 1",778,663,675,714,785,625,604,642,731,646,715,798,734,664,784,656,783,732,607,667,707,629,626,743,{"$f":"SUMPRODUCT(--(YEAR($E$2:$AB$2)=AC$2),$E63:$AB63)","v":8376},8332,2116,2124,1977,2159,2182,2171,1981,1998]
["Region 2","Product 6","Customer 2","Person 2",1017,884,1098,1292,927,889,974,919,1393,1027,999,1230,1245,1284,1061,1192,1387,1256,1076,1188,821,1063,1088,937,12649,13598,2999,3108,3286,3256,3590,3835,3085,3088]
["Region 2","Product 6","Customer 3","Person 3",708,715,723,711,774,653,557,779,586,744,590,793,656,585,601,788,618,611,793,679,689,640,645,596,8333,7901,2146,2138,1922,2127,1842,2017,2161,1881]
["Region 2","Product 6","Customer 4","Person 4",654,738,647,799,620,897,625,839,653,651,871,788,642,809,795,825,894,615,622,646,766,753,674,722,8782,8763,2039,2316,2117,2310,2246,2334,2034,2149]
["Region 2","Product 6","Customer 5","Person 5",617,798,891,674,605,844,804,857,836,648,640,776,711,849,759,758,744,775,799,649,830,707,858,855,8990,9294,2306,2123,2497,2064,2319,2277,2278,2420]
["Region 2","Product 6","Customer 6","Person 6",707,603,687,671,628,764,799,623,740,640,609,702,624,633,687,716,711,611,760,752,655,614,762,770,8173,8295,{"$f":"SUM(OFFSET($E68,,3*COLUMN(A$1)-3,,3))","v":1997},{"$f":"SUM(OFFSET($E68,,3*COLUMN(B$1)-3,,3))","v":2063},{"$f":"SUM(OFFSET($E68,,3*COLUMN(C$1)-3,,3))","v":2162},{"$f":"SUM(OFFSET($E68,,3*COLUMN(D$1)-3,,3))","v":1951},{"$f":"SUM(OFFSET($E68,,3*COLUMN(E$1)-3,,3))","v":1944},{"$f":"SUM(OFFSET($E68,,3*COLUMN(F$1)-3,,3))","v":2038},{"$f":"SUM(OFFSET($E68,,3*COLUMN(G$1)-3,,3))","v":2167},{"$f":"SUM(OFFSET($E68,,3*COLUMN(H$1)-3,,3))","v":2146}]
["Region 2","Product 6","Customer 7","Person 7",845,900,1044,982,1390,810,973,802,1320,1185,1175,907,1218,1089,942,1276,1388,1171,1277,897,1130,812,1280,1307,12333,13787,2789,3182,3095,3267,3249,3835,3304,3399]
["Region 2","Product 6","Customer 8","Person 8",647,558,571,578,794,759,652,704,616,574,787,581,551,794,605,566,646,760,573,640,592,695,554,639,7821,7615,1776,2131,1972,1942,1950,1972,1805,1888]
["Region 2","Product 6","Customer 9","Person 9",622,743,803,851,749,810,797,700,718,784,606,601,787,645,665,624,731,683,713,626,728,854,740,635,8784,8431,2168,2410,2215,1991,2097,2038,2067,2229]
["Region 2","Product 6","Customer 10","Person 10",601,608,782,844,688,666,777,699,751,762,706,878,736,744,822,881,694,761,757,744,806,782,820,728,8762,9275,1991,2198,2227,2346,2302,2336,2307,2330]
["Region 2","Product 6","Customer 11","Person 11",674,674,748,650,762,665,638,710,664,753,624,791,604,776,715,647,625,681,610,607,705,638,647,685,8353,7940,2096,2077,2012,2168,2095,1953,1922,1970]
["Region 2","Product 6","Customer 12","Person 12",805,808,1291,1234,1361,1241,1095,1151,848,1105,1332,1264,1280,1307,874,1278,1137,928,1352,1056,1113,1132,920,1014,13535,13391,2904,3836,3094,3701,3461,3343,3521,3066]
["Region 3","Product 7","Customer 1","Person 1",589,749,694,739,752,723,667,723,557,671,754,702,591,571,722,678,715,780,637,597,579,572,568,723,8320,7733,2032,2214,1947,2127,1884,2173,1813,1863]
["Region 3","Product 7","Customer 2","Person 2",766,779,632,885,607,737,611,817,738,795,670,646,875,746,675,842,865,841,697,633,682,844,863,897,8683,9460,2177,2229,2166,2111,2296,2548,2012,2604]
["Region 3","Product 7","Customer 3","Person 3",887,876,616,862,876,623,750,745,784,804,849,623,889,652,784,874,767,884,694,647,832,745,644,610,9295,9022,2379,2361,2279,2276,2325,2525,2173,1999]
["Region 3","Product 7","Customer 4","Person 4",635,741,692,646,626,605,672,693,667,718,709,716,738,649,770,760,656,618,660,789,784,617,797,632,8120,8470,2068,1877,2032,2143,2157,2034,2233,2046]
["Region 3","Product 7","Customer 5","Person 5",916,1331,814,1060,1097,949,1173,830,1153,1345,1085,1106,1055,1399,1100,1195,1122,1340,905,1369,1312,981,1229,1398,12859,14405,3061,3106,3156,3536,3554,3657,3586,3608]
["Region 3","Product 7","Customer 6","Person 6",694,705,666,661,710,657,649,655,643,570,670,697,664,620,563,572,580,628,789,699,778,697,563,599,7977,7752,2065,2028,1947,1937,1847,1780,2266,1859]
["Region 3","Product 7","Customer 7","Person 7",805,859,755,871,889,758,652,800,804,890,828,741,831,688,821,617,687,604,896,831,832,802,774,861,9652,9244,2419,2518,2256,2459,2340,1908,2559,2437]
["Region 3","Product 7","Customer 8","Person 8",670,622,810,726,827,780,622,897,603,639,786,868,884,667,839,725,685,663,616,847,885,762,806,686,8850,9065,2102,2333,2122,2293,2390,2073,2348,2254]
["Region 3","Product 7","Customer 9","Person 9",680,799,641,796,641,657,715,759,753,612,775,764,685,769,754,674,759,671,643,676,624,684,641,664,{"$f":"SUMPRODUCT(--(YEAR($E$2:$AB$2)=AC$2),$E83:$AB83)","v":8592},8244,2120,2094,2227,2151,2208,2104,1943,1989]
["Region 3","Product 7","Customer 10","Person 10",875,944,866,1224,1184,1149,1386,1120,1375,1185,1188,1003,1322,1175,1140,1002,892,1149,1204,1216,1312,957,1104,1188,13499,13661,2685,3557,3881,3376,3637,3043,3732,3249]
["Region 3","Product 7","Customer 11","Person 11",749,609,788,755,763,645,606,651,660,630,775,795,664,714,667,642,654,676,552,595,644,785,633,800,8426,8026,2146,2163,1917,2200,2045,1972,1791,2218]
["Region 3","Product 7","Customer 12","Person 12",756,603,666,739,774,706,878,658,780,664,700,656,684,894,685,713,626,691,776,801,728,600,603,689,8580,8490,2025,2219,2316,2020,2263,2030,2305,1892]
["Region 3","Product 8","Customer 1","Person 1",657,775,756,642,840,734,703,711,617,683,760,706,748,687,639,764,802,748,775,624,815,647,692,687,8584,8628,2188,2216,2031,2149,2074,2314,2214,2026]
["Region 3","Product 8","Customer 2","Person 2",631,643,767,774,742,711,673,742,717,779,647,657,607,762,797,670,661,789,615,748,630,764,782,623,8483,8448,2041,2227,2132,2083,2166,2120,1993,2169]
["Region 3","Product 8","Customer 3","Person 3",1156,1230,858,1239,1009,1191,1043,1051,971,874,1135,1246,1049,1143,1369,1317,835,990,1002,992,900,1154,1120,1361,13003,13232,3244,3439,3065,3255,3561,3142,2894,3635]
["Region 3","Product 8","Customer 4","Person 4",681,610,753,709,689,723,566,673,796,720,728,765,789,765,723,746,767,673,662,577,571,787,712,800,8413,8572,2044,2121,2035,2213,2277,2186,1810,2299]
["Region 3","Product 8","Customer 5","Person 5",693,684,887,827,836,885,743,767,868,655,900,643,777,714,714,671,666,798,731,655,731,827,751,653,9388,8688,2264,2548,2378,2198,2205,2135,2117,2231]
["Region 3","Product 8","Customer 6","Person 6",693,659,792,899,758,748,733,674,689,859,642,682,875,754,857,897,839,818,617,815,756,794,682,899,8828,9603,2144,2405,2096,2183,2486,2554,2188,2375]
["Region 3","Product 8","Customer 7","Person 7",673,744,669,660,650,635,724,644,667,687,707,617,655,655,646,612,722,619,736,636,617,638,718,761,8077,8015,2086,1945,2035,2011,1956,1953,1989,2117]
["Region 3","Product 8","Customer 8","Person 8",1189,924,875,1162,822,924,1207,1108,875,1363,825,1342,1238,887,1185,859,1375,922,1309,1076,941,1100,939,881,12616,12712,2988,2908,3190,3530,3310,3156,3326,2920]
["Region 3","Product 8","Customer 9","Person 9",776,768,581,702,713,763,568,614,675,661,704,604,791,648,650,732,749,590,759,777,647,589,668,559,8129,8159,2125,2178,1857,1969,2089,2071,2183,1816]
["Region 3","Product 8","Customer 10","Person 10",680,862,810,794,818,752,663,769,855,894,697,853,881,899,716,875,651,606,686,641,862,734,642,797,9447,8990,2352,2364,2287,2444,2496,2132,2189,2173]
["Region 3","Product 8","Customer 11","Person 11",632,606,731,692,724,848,661,858,772,655,661,715,724,762,685,608,864,857,900,628,858,678,711,604,8555,8879,1969,2264,2291,2031,2171,2329,2386,1993]
["Region 3","Product 8","Customer 12","Person 12",666,725,764,796,726,627,707,682,614,731,663,689,702,708,668,644,702,713,631,738,682,771,725,630,8390,8314,2155,2149,2003,2083,2078,2059,2051,2126]
["Region 3","Product 9","Customer 1","Person 1",1098,802,1077,1150,839,1364,1057,960,1385,1004,1356,1222,833,1379,1184,980,1137,1310,889,1275,1275,983,1190,1277,13314,13712,2977,3353,3402,3582,3396,3427,3439,3450]
["Region 3","Product 9","Customer 2","Person 2",740,556,672,650,606,558,769,662,613,554,718,579,612,682,780,559,796,578,630,709,695,654,698,636,7677,8029,1968,1814,2044,1851,2074,1933,2034,1988]
["Region 3","Product 9","Customer 3","Person 3",772,896,827,868,883,807,673,693,635,710,836,796,837,898,808,760,635,881,668,877,736,646,743,836,9396,9325,2495,2558,2001,2342,2543,2276,2281,2225]
["Region 3","Product 9","Customer 4","Person 4",829,814,879,898,755,793,667,835,896,830,789,714,848,727,887,833,724,736,798,618,716,880,624,865,9699,9256,2522,2446,2398,2333,2462,2293,2132,2369]
["Region 3","Product 9","Customer 5","Person 5",755,635,727,621,643,706,669,726,744,767,713,647,659,774,602,697,758,622,623,730,781,677,633,771,{"$f":"SUMPRODUCT(--(YEAR($E$2:$AB$2)=AC$2),$E103:$AB103)","v":8353},8327,2117,1970,2139,2127,2035,2077,2134,2081]
["Region 3","Product 9","Customer 6","Person 6",991,879,810,1277,1074,1010,1287,883,1260,887,1327,1018,1021,807,1240,832,1214,993,1334,1084,901,881,819,1396,12703,12522,2680,3361,3430,3232,3068,3039,3319,3096]
["Region 3","Product 9","Customer 7","Person 7",648,681,677,602,769,715,571,588,669,695,605,766,623,774,759,677,670,585,680,741,551,765,609,760,7986,8194,2006,2086,1828,2066,2156,1932,1972,2134]
["Region 3","Product 9","Customer 8","Person 8",856,662,742,799,636,865,621,653,731,756,708,614,728,807,633,841,767,637,696,633,706,687,754,736,8643,8625,2260,2300,2005,2078,2168,2245,2035,2177]
["Region 3","Product 9","Customer 9","Person 9",750,735,716,883,635,798,779,612,695,659,640,630,641,761,624,605,651,883,870,890,803,888,773,838,8532,9227,2201,2316,2086,1929,2026,2139,2563,2499]
["Region 3","Product 9","Customer 10","Person 10",615,786,686,603,725,667,658,646,643,636,681,649,774,638,786,641,766,778,646,649,646,717,632,788,7995,8461,2087,1995,1947,1966,2198,2185,1941,2137]
["Region 3","Product 9","Customer 11","Person 11",907,935,1026,1002,1248,1339,1183,1337,1189,1393,1337,1064,904,1076,834,1142,1169,1115,1354,1316,1268,1283,1393,958,13960,13812,2868,3589,3709,3794,2814,3426,3938,3634]
["Region 3","Product 9","Customer 12","Person 12",751,560,567,605,587,550,753,737,783,637,644,687,709,748,768,557,609,671,736,609,658,768,560,700,7861,8093,1878,1742,2273,1968,2225,1837,2003,2028]
["Region 4","Product 10","Customer 1","Person 1",697,725,800,658,819,761,661,700,819,796,894,705,893,672,663,854,847,624,823,736,725,824,659,877,9035,9197,2222,2238,2180,2395,2228,2325,2284,2360]
["Region 4","Product 10","Customer 2","Person 2",733,808,765,898,611,816,848,615,628,717,891,762,884,654,800,875,690,751,693,874,860,769,702,767,9092,9319,2306,2325,2091,2370,2338,2316,2427,2238]
["Region 4","Product 10","Customer 3","Person 3",645,799,669,749,688,800,669,686,624,666,636,729,675,789,754,722,621,799,625,651,771,711,721,651,8360,8490,2113,2237,1979,2031,2218,2142,2047,2083]
["Region 4","Product 10","Customer 4","Person 4",844,1170,1292,1009,1103,919,1377,1352,1277,899,1131,827,1375,882,812,1274,1172,1170,879,1274,1208,943,1187,1253,13200,13429,3306,3031,4006,2857,3069,3616,3361,3383]
["Region 4","Product 10","Customer 5","Person 5",675,649,717,641,610,715,661,764,703,614,561,694,738,703,728,565,737,706,699,788,736,791,762,696,8004,8649,2041,1966,2128,1869,2169,2008,2223,2249]
["Region 4","Product 10","Customer 6","Person 6",661,804,658,603,631,639,635,662,627,679,709,844,766,819,832,603,645,657,688,750,758,650,899,793,8152,8860,2123,1873,1924,2232,2417,1905,2196,2342]
["Region 4","Product 10","Customer 7","Person 7",618,672,876,900,799,742,624,898,623,883,679,617,766,684,768,669,749,874,805,747,789,781,768,778,8931,9178,2166,2441,2145,2179,2218,2292,2341,2327]
["Region 4","Product 10","Customer 8","Person 8",619,686,692,771,672,675,769,640,721,641,678,698,781,648,665,748,743,653,770,640,730,789,768,617,8262,8552,1997,2118,2130,2017,2094,2144,2140,2174]
["Region 4","Product 10","Customer 9","Person 9",1363,1185,1078,1197,897,1218,1070,1145,1290,1299,1154,1375,1034,1215,999,1392,1248,1284,1084,1036,1248,986,1399,1161,14271,14086,3626,3312,3505,3828,3248,3924,3368,3546]
["Region 4","Product 10","Customer 10","Person 10",638,736,607,652,694,607,670,652,774,552,755,622,665,559,583,736,599,714,756,566,693,621,575,797,7959,7864,1981,1953,2096,1929,1807,2049,2015,1993]
["Region 4","Product 10","Customer 11","Person 11",616,778,650,655,737,786,745,865,604,886,639,611,770,684,714,603,724,705,751,874,891,604,890,742,8572,8952,2044,2178,2214,2136,2168,2032,2516,2236]
["Region 4","Product 10","Customer 12","Person 12",899,712,668,683,851,697,692,796,735,741,651,851,810,659,861,742,680,664,706,716,602,634,852,853,8976,8779,2279,2231,2223,2243,2330,2086,2024,2339]
["Region 4","Product 11","Customer 1","Person 1",671,721,658,729,627,632,693,650,778,649,602,666,787,760,761,755,717,602,746,701,754,640,638,693,{"$f":"SUMPRODUCT(--(YEAR($E$2:$AB$2)=AC$2),$E123:$AB123)","v":8076},8554,2050,1988,2121,1917,2308,2074,2201,1971]
["Region 4","Product 11","Customer 2","Person 2",1232,1311,1225,1087,1128,1320,943,1289,1186,1328,928,1345,1167,812,801,1374,949,980,1108,1058,1175,1201,1034,1376,14322,13035,3768,3535,3418,3601,2780,3303,3341,3611]
["Region 4","Product 11","Customer 3","Person 3",788,586,639,789,778,632,774,681,614,635,561,581,659,737,745,564,749,764,793,684,789,718,551,742,8058,8495,2013,2199,2069,1777,2141,2077,2266,2011]
["Region 4","Product 11","Customer 4","Person 4",617,783,802,757,888,738,840,691,653,809,611,671,616,798,768,657,758,776,896,680,702,842,897,606,8860,8996,2202,2383,2184,2091,2182,2191,2278,2345]
["Region 4","Product 11","Customer 5","Person 5",630,769,882,600,764,646,900,797,708,857,789,862,772,665,633,779,796,615,723,649,888,692,631,635,9204,8478,2281,2010,2405,2508,2070,2190,2260,1958]
["Region 4","Product 11","Customer 6","Person 6",631,796,639,606,759,781,744,692,682,620,746,696,636,695,614,783,630,629,703,795,714,769,795,632,8392,8395,2066,2146,2118,2062,1945,2042,2212,2196]
["Region 4","Product 11","Customer 7","Person 7",1079,1033,931,1336,1208,1345,903,1330,976,1104,968,901,1237,1252,1390,885,1228,998,888,995,1189,1328,1131,1260,13114,13781,3043,3889,3209,2973,3879,3111,3072,3719]
["Region 4","Product 11","Customer 8","Person 8",782,638,762,710,749,643,622,660,586,568,777,688,638,712,583,578,575,726,603,575,634,579,696,746,8185,7645,2182,2102,1868,2033,1933,1879,1812,2021]
["Region 4","Product 11","Customer 9","Person 9",627,839,729,701,691,646,804,663,861,793,706,820,845,884,736,853,621,887,759,709,817,702,637,684,8880,9134,2195,2038,2328,2319,2465,2361,2285,2023]
["Region 4","Product 11","Customer 10","Person 10",625,706,782,896,670,631,847,898,628,854,617,900,890,704,814,720,900,814,811,797,837,858,728,706,9054,9579,{"$f":"SUM(OFFSET($E132,,3*COLUMN(A$1)-3,,3))","v":2113},{"$f":"SUM(OFFSET($E132,,3*COLUMN(B$1)-3,,3))","v":2197},{"$f":"SUM(OFFSET($E132,,3*COLUMN(C$1)-3,,3))","v":2373},{"$f":"SUM(OFFSET($E132,,3*COLUMN(D$1)-3,,3))","v":2371},{"$f":"SUM(OFFSET($E132,,3*COLUMN(E$1)-3,,3))","v":2408},{"$f":"SUM(OFFSET($E132,,3*COLUMN(F$1)-3,,3))","v":2434},{"$f":"SUM(OFFSET($E132,,3*COLUMN(G$1)-3,,3))","v":2445},{"$f":"SUM(OFFSET($E132,,3*COLUMN(H$1)-3,,3))","v":2292}]
["Region 4","Product 11","Customer 11","Person 11",681,793,757,666,737,654,638,610,647,770,770,797,669,601,745,630,663,768,767,719,748,726,770,675,8520,8481,2231,2057,1895,2337,2015,2061,2234,2171]
["Region 4","Product 11","Customer 12","Person 12",950,1060,1276,1073,1238,802,1207,1115,1043,1170,1236,1318,1204,1212,1350,1276,939,1081,1006,981,847,1120,1332,1029,13488,13377,3286,3113,3365,3724,3766,3296,2834,3481]
["Region 4","Product 12","Customer 1","Person 1",620,562,647,598,643,598,695,636,781,566,734,727,800,780,739,685,555,644,769,759,688,657,651,707,7807,8434,1829,1839,2112,2027,2319,1884,2216,2015]
["Region 4","Product 12","Customer 2","Person 2",856,724,765,883,892,761,857,796,613,723,716,842,802,616,839,661,834,698,625,655,624,659,775,689,9428,8477,2345,2536,2266,2281,2257,2193,1904,2123]
["Region 4","Product 12","Customer 3","Person 3",662,794,893,667,605,812,604,880,898,788,886,755,609,848,602,857,686,673,655,750,752,794,734,661,9244,8621,2349,2084,2382,2429,2059,2216,2157,2189]
["Region 4","Product 12","Customer 4","Person 4",719,787,609,634,700,725,759,640,745,615,773,638,709,764,644,761,614,752,761,720,781,692,705,676,8344,8579,2115,2059,2144,2026,2117,2127,2262,2073]
["Region 4","Product 12","Customer 5","Person 5",1239,1385,823,1069,1336,857,869,901,812,1352,1084,1081,1323,1261,1334,1372,949,1165,962,1211,1304,956,1214,1097,12808,14148,3447,3262,2582,3517,3918,3486,3477,3267]
["Region 4","Product 12","Customer 6","Person 6",665,781,580,798,618,685,571,672,730,588,610,568,712,746,602,599,661,587,586,693,622,681,614,706,7866,7809,2026,2101,1973,1766,2060,1847,1901,2001]
["Region 4","Product 12","Customer 7","Person 7",688,716,797,618,628,745,731,773,724,741,656,611,750,755,890,776,726,849,627,679,781,875,803,898,8428,9409,2201,1991,2228,2008,2395,2351,2087,2576]
["Region 4","Product 12","Customer 8","Person 8",833,736,643,887,725,702,653,682,753,712,800,668,856,666,692,770,672,896,674,817,898,769,674,638,8794,9022,2212,2314,2088,2180,2214,2338,2389,2081]
["Region 4","Product 12","Customer 9","Person 9",749,683,739,714,742,767,676,670,629,683,625,616,646,625,717,604,758,604,715,647,753,704,764,721,8293,8258,2171,2223,1975,1924,1988,1966,2115,2189]
["Region 4","Product 12","Customer 10","Person 10",819,870,817,1178,917,941,1017,1118,1316,1035,1045,1026,1348,1302,1119,1181,1210,1157,902,1311,1097,1199,1034,1118,12099,13978,2506,3036,3451,3106,3769,3548,3310,3351]
["Region 4","Product 12","Customer 11","Person 11",653,727,768,756,595,577,796,740,551,776,601,651,637,561,608,658,621,787,702,582,611,698,694,695,8191,7854,2148,1928,2087,2028,1806,2066,1895,2087]
["Region 4","Product 12","Customer 12","Person 12",727,696,821,629,715,847,760,759,879,697,690,844,668,624,657,834,795,730,896,790,648,782,777,845,9064,9046,2244,2191,2398,2231,1949,2359,2334,2404]

{"sheet":"Dashboard","index":1,"n_rows":29,"n_cols":40,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,5,0,9]]}
[null,"Dropdown---------->",null,"Customer Type",null,"Sales Dashboard - developed by Vikas Gautam",null,null,null,null,"Dropdown---------->",null,"Sales Person - Name",2011,null,null,null,null,null,null,null,null,null,"Row Labels","2011 ","2012 ",null,null,"Drop Down",null,null,"Year",null,"Quarters"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Customer1",112151,111978,null,null,"Region",null,null,2011,null,"Q1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Customer10",115819,119312,null,null,"Product",null,null,2012,null,"Q2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Customer11",112560,112992,null,null,"Customer Type",null,null,null,null,"Q3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Customer12",117868,117414,null,null,"Sales Person - Name",null,null,null,null,"Q4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Customer2",118100,116574]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Customer3",114738,114552]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Customer4",113111,112506]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Customer5",117989,119121]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Customer6",107310,111036]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Customer7",117349,119601]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Customer8",110368,110430,null,null," 2011_Q1"," 2011_Q2"," 2011_Q3"," 2011_Q4"," 2012_Q1"," 2012_Q2"," 2012_Q3"," 2012_Q4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Customer9",112665,112639]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total",1370028,1378155]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Row Labels"," 2011_Q1"," 2011_Q2"," 2011_Q3"," 2011_Q4",null,null,null,null,null,null,"Row Labels"," 2012_Q2",null,"Row Labels"," 2011_Q1"," 2012_Q1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Person1",27705,28519,27658,28269,null,null,null,null,null,null,"Customer 1",28230,null,"Product 1",28712,29638]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Person10",27411,29320,30067,29021,null,null,null,null,null,null,"Customer 10",29539,null,"Product 10",28204,28304]
["Dropdowns:",null,null,null,null,null,null,"Dropdowns:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Person11",26974,28413,28694,28479,null,null,null,null,null,null,"Customer 11",27988,null,"Product 11",29430,29892]
["Customer Type",null,null,null,null,null,null,"Product",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Person12",28322,29843,29980,29723,null,null,null,null,null,null,"Customer 12",29918,null,"Product 12",27593,28851]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Person2",29882,29429,28599,30190,null,null,null,null,null,null,"Customer 2",29472,null,"Product 2",27328,27807]
["Year:",null,null,null,null,null,null,"Quarter:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Person3",29082,29236,28021,28399,null,null,null,null,null,null,"Customer 3",29115,null,"Product 3",28156,28003]
[2012,null,null,null,null,null,null,"Q1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Person4",28018,28338,29023,27732,null,null,null,null,null,null,"Customer 4",28795,null,"Product 4",29658,29466]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Person5",28859,29374,29843,29913,null,null,null,null,null,null,"Customer 5",29220,null,"Product 5",28976,28066]
["Quarter:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Person6",26993,27206,26588,26523,null,null,null,null,null,null,"Customer 6",26878,null,"Product 6",27327,29277]
["Q2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Person7",28804,29852,29079,29614,null,null,null,null,null,null,"Customer 7",29157,null,"Product 7",27279,28946]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Person8",27492,28183,27491,27202,null,null,null,null,null,null,"Customer 8",27158,null,"Product 8",27600,28869]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Person9",28780,28327,27725,27833,null,null,null,null,null,null,"Customer 9",28079,null,"Product 9",28059,29165]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total",338322,346040,342768,342898,null,null,null,null,null,null,"Grand Total",343549,null,"Grand Total",338322,346284]