{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Pivot","Intro","Data","Controls","Dashboard"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":33,"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":"Pivot","index":0,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":true,"merged":[[1,3,1,6]]}
[]
[null,null,null,{"$f":"B4&\" comparison \" & CHAR(10) &\" 2011 vs. 2012\"","v":"Person 4 comparison \n 2011 vs. 2012"}]
[]
["Sales Person - Name","Person 4",null,null,null,4,null,null,null,"Customer Type","Customer 1",null,null,"Customer Type","Customer 1"]
[]
["Row Labels","Sum of 2011","Sum of 2012",null,{"$f":"INDEX(Controls!$E$3:$E$14,Pivot!F4)","v":"Person 4"},2011,2012,null,null,"Product","Sum of 2011",null,null,"Product","Sum of 2012"]
["Product 1",8478,8806,null,{"$f":"\"Prod \"& CHAR(10) & 1","v":"Prod \n1"},8478,8806,null,null,"Product 4",0.38554184404806813,null,null,"Product 9",0.37813689261485856]
["Product 2",8346,8368,null,{"$f":"\"Prod \"& CHAR(10) & 2","v":"Prod \n2"},8346,8368,null,null,"Product 9",0.35873255375330065,null,null,"Product 4",0.36823672163697535]
["Product 3",8370,8100,null,{"$f":"\"Prod \"& CHAR(10) & 3","v":"Prod \n3"},8370,8100,null,null,"Product 5",0.25572560219863122,null,null,"Product 10",0.25362638574816615]
["Product 4",8783,8623,null,{"$f":"\"Prod \"& CHAR(10) & 4","v":"Prod \n4"},8783,8623,null,null,"Grand Total",1,null,null,"Grand Total",1]
["Product 5",13716,12544,null,{"$f":"\"Prod \"& CHAR(10) & 5","v":"Prod \n5"},13716,12544]
["Product 6",8782,8763,null,{"$f":"\"Prod \"& CHAR(10) & 6","v":"Prod \n6"},8782,8763]
["Product 7",8120,8470,null,{"$f":"\"Prod \"& CHAR(10) & 7","v":"Prod \n7"},8120,8470]
["Product 8",8413,8572,null,{"$f":"\"Prod \"& CHAR(10) & 8","v":"Prod \n8"},8413,8572]
["Product 9",9699,9256,null,{"$f":"\"Prod \"& CHAR(10) & 9","v":"Prod \n9"},9699,9256,null,null,"Customer Type","Customer 1"]
["Product 10",13200,13429,null,{"$f":"\"Prod \"& CHAR(10) & 10","v":"Prod \n10"},13200,13429]
["Product 11",8860,8996,null,{"$f":"\"Prod \"& CHAR(10) & 11","v":"Prod \n11"},8860,8996,null,null,"Product","Sum of 2011","Sum of 2012"]
["Product 12",8344,8579,null,{"$f":"\"Prod \"& CHAR(10) & 12","v":"Prod \n12"},8344,8579,null,null,"Product 1",8214,8141]
["Grand Total",113111,112506,null,null,{"$f":"SUM(F7:F18)","v":113111},{"$f":"SUM(G7:G18)","v":112506},null,null,"Product 2",8174,8189]
[null,null,null,null,null,null,{"$f":"G19/F19*100","v":99.465127175959907},null,null,"Product 3",8451,9106]
[null,null,null,null,{"$f":"Salesrep&\" Index of \" &TEXT(G20,\"#,##\")&CHAR(10)& \" 2012 over 2011\"","v":"Person 4 Index of 99\n 2012 over 2011"},null,null,null,null,"Product 4",14309,13353]
[null,null,null,null,null,null,null,null,null,"Product 5",9491,8599]
[null,null,null,null,null,null,null,null,null,"Product 6",8376,8332]
[null,null,null,null,null,null,null,null,null,"Product 7",8320,7733]
[null,null,null,null,null,null,null,null,null,"Product 8",8584,8628]
[null,null,null,null,null,null,null,null,null,"Product 9",13314,13712]
[null,null,null,null,null,null,null,null,null,"Product 10",9035,9197]
[null,null,null,null,null,null,null,null,null,"Product 11",8076,8554]
[null,null,null,null,null,null,null,null,null,"Product 12",7807,8434]
[null,null,null,null,null,null,null,null,null,"Grand Total",112151,111978]

{"sheet":"Intro","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Data","index":2,"n_rows":146,"n_cols":30,"rows_kept":146,"cut":false,"hidden":false,"merged":[[0,4,0,27]]}
[null,null,null,null,"Sales"]
["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]
["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":"SUM(E3:P3)","v":8214},{"$f":"SUM(Q3:AB3)","v":8141}]
["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,{"$f":"SUM(E4:P4)","v":13465},{"$f":"SUM(Q4:AB4)","v":11679}]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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,8385,8244]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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,8413,8405]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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,8376,8332]
["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]
["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]
["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]
["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]
["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,{"$f":"SUM(E68:P68)","v":8173},{"$f":"SUM(Q68:AB68)","v":8295}]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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,8592,8244]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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,8353,8327]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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,8076,8554]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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,{"$f":"SUM(E132:P132)","v":9054},{"$f":"SUM(Q132:AB132)","v":9579}]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]
["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]

{"sheet":"Controls","index":3,"n_rows":31,"n_cols":19,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Region","Product","Customer Type","Sales Person - Name",null,"Region","Product 1","Product 2","Product 3","Product 4","Product 5","Product 6","Product 7","Product 8","Product 9","Product 10","Product 11","Product 12"]
[null,"Region 1","Product 1","Customer 1","Person 1",null,"Region 1",{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G3,Product,Controls!H$2)","v":9701},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G3,Product,Controls!I$2)","v":9774},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G3,Product,Controls!J$2)","v":9508},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G3,Product,Controls!K$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G3,Product,Controls!L$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G3,Product,Controls!M$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G3,Product,Controls!N$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G3,Product,Controls!O$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G3,Product,Controls!P$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G3,Product,Controls!Q$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G3,Product,Controls!R$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G3,Product,Controls!S$2)","v":0}]
[null,"Region 2","Product 2","Customer 2","Person 2",null,"Region 2",{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G4,Product,Controls!H$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G4,Product,Controls!I$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G4,Product,Controls!J$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G4,Product,Controls!K$2)","v":9701},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G4,Product,Controls!L$2)","v":9616},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G4,Product,Controls!M$2)","v":9856},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G4,Product,Controls!N$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G4,Product,Controls!O$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G4,Product,Controls!P$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G4,Product,Controls!Q$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G4,Product,Controls!R$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G4,Product,Controls!S$2)","v":0}]
[null,"Region 3","Product 3","Customer 3","Person 3",null,"Region 3",{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G5,Product,Controls!H$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G5,Product,Controls!I$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G5,Product,Controls!J$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G5,Product,Controls!K$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G5,Product,Controls!L$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G5,Product,Controls!M$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G5,Product,Controls!N$2)","v":9517},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G5,Product,Controls!O$2)","v":9116},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G5,Product,Controls!P$2)","v":10243},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G5,Product,Controls!Q$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G5,Product,Controls!R$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G5,Product,Controls!S$2)","v":0}]
[null,"Region 4","Product 4","Customer 4","Person 4",null,"Region 4",{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G6,Product,Controls!H$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G6,Product,Controls!I$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G6,Product,Controls!J$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G6,Product,Controls!K$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G6,Product,Controls!L$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G6,Product,Controls!M$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G6,Product,Controls!N$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G6,Product,Controls!O$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G6,Product,Controls!P$2)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G6,Product,Controls!Q$2)","v":9425},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G6,Product,Controls!R$2)","v":9362},{"$f":"SUMIFS(INDIRECT(Dashboard!$G$16),Region,Controls!$G6,Product,Controls!S$2)","v":9431}]
[null,null,"Product 5","Customer 5","Person 5"]
[null,null,"Product 6","Customer 6","Person 6",null,"Region","Product 1","Product 2","Product 3","Product 4","Product 5","Product 6","Product 7","Product 8","Product 9","Product 10","Product 11","Product 12"]
[null,null,"Product 7","Customer 7","Person 7",null,"Region 1",{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G9,Product,Controls!H$8)","v":9138},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G9,Product,Controls!I$8)","v":9424},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G9,Product,Controls!J$8)","v":9445},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G9,Product,Controls!K$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G9,Product,Controls!L$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G9,Product,Controls!M$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G9,Product,Controls!N$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G9,Product,Controls!O$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G9,Product,Controls!P$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G9,Product,Controls!Q$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G9,Product,Controls!R$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G9,Product,Controls!S$8)","v":0}]
[null,null,"Product 8","Customer 8","Person 8",null,"Region 2",{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G10,Product,Controls!H$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G10,Product,Controls!I$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G10,Product,Controls!J$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G10,Product,Controls!K$8)","v":9697},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G10,Product,Controls!L$8)","v":9210},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G10,Product,Controls!M$8)","v":9542},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G10,Product,Controls!N$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G10,Product,Controls!O$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G10,Product,Controls!P$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G10,Product,Controls!Q$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G10,Product,Controls!R$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G10,Product,Controls!S$8)","v":0}]
[null,null,"Product 9","Customer 9","Person 9",null,"Region 3",{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G11,Product,Controls!H$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G11,Product,Controls!I$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G11,Product,Controls!J$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G11,Product,Controls!K$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G11,Product,Controls!L$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G11,Product,Controls!M$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G11,Product,Controls!N$8)","v":9992},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G11,Product,Controls!O$8)","v":9010},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G11,Product,Controls!P$8)","v":9736},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G11,Product,Controls!Q$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G11,Product,Controls!R$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G11,Product,Controls!S$8)","v":0}]
[null,null,"Product 10","Customer 10","Person 10",null,"Region 4",{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G12,Product,Controls!H$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G12,Product,Controls!I$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G12,Product,Controls!J$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G12,Product,Controls!K$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G12,Product,Controls!L$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G12,Product,Controls!M$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G12,Product,Controls!N$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G12,Product,Controls!O$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G12,Product,Controls!P$8)","v":0},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G12,Product,Controls!Q$8)","v":10011},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G12,Product,Controls!R$8)","v":10094},{"$f":"SUMIFS(INDIRECT(Dashboard!$H$16),Region,Controls!$G12,Product,Controls!S$8)","v":9559}]
[null,null,"Product 11","Customer 11","Person 11",null,null,null,{"$f":"IF(G14=1,2,IF(G14=2,5,IF(G14=3,8,11)))","v":5},{"$f":"I13+1","v":6},{"$f":"J13+1","v":7}]
[null,null,"Product 12","Customer 12","Person 12",null,2,{"$f":"CHOOSE(G14,G9,G10,G11,G12)","v":"Region 2"},{"$f":"IF($G$14=1,H8,IF($G$14=2,K8,IF($G$14=3,N8,Q8)))","v":"Product 4"},{"$f":"IF($G$14=1,I8,IF($G$14=2,L8,IF($G$14=3,O8,R8)))","v":"Product 5"},{"$f":"IF($G$14=1,J8,IF($G$14=2,M8,IF($G$14=3,P8,S8)))","v":"Product 6"}]
[null,null,null,null,null,null,null,null,{"$f":"IF($G$14=1,VLOOKUP($H$14,$G$3:$S$6,I$13,FALSE),IF($G$14=2,VLOOKUP($H$14,$G$3:$S$6,I$13,FALSE),IF($G$14=3,VLOOKUP($H$14,$G$3:$S$6,I13,FALSE),VLOOKUP($H$14,$G$3:$S$6,I$13,FALSE))))","v":9701},{"$f":"IF($G$14=1,VLOOKUP($H$14,$G$3:$S$6,J$13,FALSE),IF($G$14=2,VLOOKUP($H$14,$G$3:$S$6,J$13,FALSE),IF($G$14=3,VLOOKUP($H$14,$G$3:$S$6,J13,FALSE),VLOOKUP($H$14,$G$3:$S$6,J$13,FALSE))))","v":9616},9856,2011]
[null,null,null,null,null,null,null,null,{"$f":"IF($G$14=1,VLOOKUP($H$14,$G$9:$S$12,I$13,FALSE),IF($G$14=2,VLOOKUP($H$14,$G$9:$S$12,I$13,FALSE),IF($G$14=3,VLOOKUP($H$14,$G$9:$S$12,I$13,FALSE),VLOOKUP($H$14,$G$9:$S$12,I$13,FALSE))))","v":9697},{"$f":"IF($G$14=1,VLOOKUP($H$14,$G$9:$S$12,J$13,FALSE),IF($G$14=2,VLOOKUP($H$14,$G$9:$S$12,J$13,FALSE),IF($G$14=3,VLOOKUP($H$14,$G$9:$S$12,J$13,FALSE),VLOOKUP($H$14,$G$9:$S$12,J$13,FALSE))))","v":9210},9542,2012]
[null,null,"Jan_11","Jan_12"]
[null,null,"Feb_11","Feb_12"]
[null,null,"Mar_11","Mar_12",null,null,"Product"]
[null,null,"Apr_11","Apr_12",null,null,"Product 1"]
[null,null,"May_11","May_12",null,null,"Product 2"]
[null,null,"Jun_11","Jun_12",null,null,"Product 3"]
[null,null,"Jul_11","Jul_12",null,null,"Product 4"]
[null,null,"Aug_11","Aug_12",null,null,"Product 5"]
[null,null,"Sep_11","Sep_12",null,null,"Product 6"]
[null,null,"Oct_11","Oct_12",null,null,"Product 7"]
[null,null,"Nov_11","Nov_12",null,null,"Product 8"]
[null,null,"Dec_11","Dec_12",null,null,"Product 9"]
[null,null,null,null,null,null,"Product 10"]
[null,null,null,null,null,null,"Product 11"]
[null,null,null,null,null,null,"Product 12"]

{"sheet":"Dashboard","index":4,"n_rows":30,"n_cols":20,"rows_kept":30,"cut":false,"hidden":false,"merged":[[15,3,15,5],[15,0,15,2],[15,8,15,15],[29,16,31,19],[0,16,14,19],[15,16,15,19]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Pivot!E21","v":"Person 4 Index of 99\n 2012 over 2011"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["By Region, By Product",null,null,"Choose month\n comparison",null,null,"Sep_11","Sep_12","Person comparison for each product - 2011 vs. 2012",null,null,null,null,null,null,null,"YoY Index for each person"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SKU",2011,2012,"Rating"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Pivot!J18","v":"Product 1"},{"$f":"Pivot!K18","v":8214},{"$f":"Pivot!L18","v":8141},{"$f":"S18-R18","v":-73}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Pivot!J19","v":"Product 2"},{"$f":"Pivot!K19","v":8174},{"$f":"Pivot!L19","v":8189},{"$f":"S19-R19","v":15}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Pivot!J20","v":"Product 3"},{"$f":"Pivot!K20","v":8451},{"$f":"Pivot!L20","v":9106},655]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Pivot!J21","v":"Product 4"},{"$f":"Pivot!K21","v":14309},{"$f":"Pivot!L21","v":13353},-956]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Pivot!J22","v":"Product 5"},{"$f":"Pivot!K22","v":9491},{"$f":"Pivot!L22","v":8599},-892]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Pivot!J23","v":"Product 6"},{"$f":"Pivot!K23","v":8376},{"$f":"Pivot!L23","v":8332},-44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Pivot!J24","v":"Product 7"},{"$f":"Pivot!K24","v":8320},{"$f":"Pivot!L24","v":7733},-587]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Pivot!J25","v":"Product 8"},{"$f":"Pivot!K25","v":8584},{"$f":"Pivot!L25","v":8628},44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Pivot!J26","v":"Product 9"},{"$f":"Pivot!K26","v":13314},{"$f":"Pivot!L26","v":13712},398]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Pivot!J27","v":"Product 10"},{"$f":"Pivot!K27","v":9035},{"$f":"Pivot!L27","v":9197},162]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Pivot!J28","v":"Product 11"},{"$f":"Pivot!K28","v":8076},{"$f":"Pivot!L28","v":8554},478]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Pivot!J29","v":"Product 12"},{"$f":"Pivot!K29","v":7807},{"$f":"Pivot!L29","v":8434},627]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YoY comparison for each Product by Customer"]