{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["P(1)","P(1an)","P(2)","P(2an)","P(3)","P(3an)","P(4)","P(4an)","P(5)","P(5an)","P(6)","P(6an)","P(7)","P(7an)","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"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":"P(1)","index":0,"n_rows":101,"n_cols":31,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"In cell \"&ADDRESS(ROW(A4),COLUMN(A4),4)&\" add a drop-down list for \"&A3&\". Then in range \"&ADDRESS(ROW(B4),COLUMN(B4),4)&\":\"&ADDRESS(ROW(E4),COLUMN(E4),4)&\" create a formula that will retrieve the employee data from the table below.\"","v":"In cell A4 add a drop-down list for Employee ID. Then in range B4:E4 create a formula that will retrieve the employee data from the table below."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rand:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Employee ID","FirstName","LastName","HireDate","Salary"]
["Employee ID","FirstName","LastName","HireDate","Salary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHAR(65+INT(RAND()*25+1))&CHAR(65+INT(RAND()*25+1))&CHAR(65+INT(RAND()*25+1))&CHAR(65+INT(RAND()*25+1))&\"-\"&RANDBETWEEN(1000,9999)&\"-\"&TEXT(ROWS(AA$2:AA3),\"0000\")","v":"CYHO-6881-0002"},"FirstName1","LastName2",{"$f":"RANDBETWEEN(37000,40300)","v":"2009-11-03"},{"$f":"RANDBETWEEN(29000,59000)","v":36729}]
["JWSO-6243-0009"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Employee ID","FirstName","LastName","HireDate","Salary"]
["GJSM-6396-0001","FirstName1","LastName2","2005-06-29",53543]
["MLUC-2070-0002","FirstName2","LastName3","2005-05-06",29713]
["BRPB-8723-0003","FirstName3","LastName4","2010-01-11",58222]
["FRMJ-5156-0004","FirstName4","LastName5","2010-04-12",31083]
["EXUP-5444-0005","FirstName5","LastName6","2008-02-25",38656]
["DSFC-6917-0006","FirstName6","LastName7","2001-08-30",56298]
["QKZI-1300-0007","FirstName7","LastName8","2001-10-13",40540]
["XZTE-6923-0008","FirstName8","LastName9","2002-08-06",32458]
["JWSO-6243-0009","FirstName9","LastName10","2003-03-09",58644]
["DWTP-6758-0010","FirstName10","LastName11","2003-11-07",36264]
["QIGS-2445-0011","FirstName11","LastName12","2005-10-11",34630]
["OMCL-7737-0012","FirstName12","LastName13","2002-09-07",52432]
["TLJE-7153-0013","FirstName13","LastName14","2002-12-09",39565]
["XRGR-3012-0014","FirstName14","LastName15","2010-04-08",32941]
["YLGX-6164-0015","FirstName15","LastName16","2006-04-23",52813]
["NNZI-2914-0016","FirstName16","LastName17","2002-09-10",48002]
["MSEH-9132-0017","FirstName17","LastName18","2003-09-28",30414]
["VORH-3055-0018","FirstName18","LastName19","2002-03-26",46956]
["KGDD-2833-0019","FirstName19","LastName20","2008-12-18",45420]
["PPPN-9499-0020","FirstName20","LastName21","2008-02-13",38059]
["VHMG-9677-0021","FirstName21","LastName22","2004-11-10",51869]
["VGJS-6331-0022","FirstName22","LastName23","2004-03-07",32333]
["SJIE-7711-0023","FirstName23","LastName24","2006-10-25",56868]
["EPKZ-6633-0024","FirstName24","LastName25","2009-08-08",31846]
["VHHU-7337-0025","FirstName25","LastName26","2004-01-04",45553]
["BROM-3764-0026","FirstName26","LastName27","2003-05-02",37253]
["FNVM-4820-0027","FirstName27","LastName28","2003-11-15",53211]
["CHWO-4264-0028","FirstName28","LastName29","2005-03-22",44756]
["UIJD-1053-0029","FirstName29","LastName30","2004-04-11",52914]
["HUDV-8097-0030","FirstName30","LastName31","2004-03-10",38639]
["HJNR-5696-0031","FirstName31","LastName32","2008-07-18",39784]
["MSRU-2603-0032","FirstName32","LastName33","2004-09-05",47441]
["LDYS-7266-0033","FirstName33","LastName34","2003-11-19",29245]
["NQHG-3241-0034","FirstName34","LastName35","2005-09-06",50076]
["VRZK-8901-0035","FirstName35","LastName36","2010-03-16",55045]
["WOEH-6654-0036","FirstName36","LastName37","2004-06-15",48541]
["KOYM-7312-0037","FirstName37","LastName38","2007-12-30",58564]
["RTWO-6122-0038","FirstName38","LastName39","2009-04-11",39727]
["XVXW-7820-0039","FirstName39","LastName40","2009-03-10",36487]
["ICML-3006-0040","FirstName40","LastName41","2006-09-04",40059]
["TUGQ-2347-0041","FirstName41","LastName42","2005-12-27",53426]
["RNUL-8806-0042","FirstName42","LastName43","2001-07-20",29305]
["NMCD-3108-0043","FirstName43","LastName44","2002-11-22",58331]
["BXPY-8972-0044","FirstName44","LastName45","2008-10-04",29585]
["LLXL-6681-0045","FirstName45","LastName46","2007-03-01",33046]
["VNEV-1225-0046","FirstName46","LastName47","2007-01-01",45022]
["EWUV-8350-0047","FirstName47","LastName48","2001-09-10",46361]
["MBEF-3369-0048","FirstName48","LastName49","2007-01-07",53093]
["ORLI-2707-0049","FirstName49","LastName50","2008-05-25",57760]
["NHKJ-9309-0050","FirstName50","LastName51","2001-10-24",50068]
["ZMUZ-6955-0051","FirstName51","LastName52","2005-09-27",34946]
["QXBG-6338-0052","FirstName52","LastName53","2009-05-28",47062]
["UMCO-5443-0053","FirstName53","LastName54","2008-01-13",36840]
["JHCR-1640-0054","FirstName54","LastName55","2009-03-28",56499]
["KPOV-2953-0055","FirstName55","LastName56","2002-01-01",30813]
["FQGD-5774-0056","FirstName56","LastName57","2001-06-10",46092]
["EFEP-3329-0057","FirstName57","LastName58","2002-05-28",33192]
["MKZF-5213-0058","FirstName58","LastName59","2005-07-31",41632]
["RYLQ-8912-0059","FirstName59","LastName60","2008-01-12",37236]
["VEVB-4734-0060","FirstName60","LastName61","2004-11-10",58741]
["OKYK-3386-0061","FirstName61","LastName62","2005-04-08",40138]
["VSQR-6062-0062","FirstName62","LastName63","2005-08-26",42648]
["USQK-7805-0063","FirstName63","LastName64","2005-12-19",40470]
["QGOX-2944-0064","FirstName64","LastName65","2005-01-23",55414]
["CONT-7797-0065","FirstName65","LastName66","2002-12-18",37570]
["QEJO-9720-0066","FirstName66","LastName67","2009-10-17",37093]
["SLQV-9064-0067","FirstName67","LastName68","2005-08-01",49595]
["PMXY-8858-0068","FirstName68","LastName69","2007-07-11",34085]
["HEIS-2128-0069","FirstName69","LastName70","2005-12-26",53954]
["LSJX-6419-0070","FirstName70","LastName71","2006-10-10",47233]
["OOBC-6864-0071","FirstName71","LastName72","2007-07-14",51492]
["LZSM-9341-0072","FirstName72","LastName73","2009-11-10",38646]
["BOTV-7343-0073","FirstName73","LastName74","2002-04-07",33528]
["FOUU-8104-0074","FirstName74","LastName75","2001-09-28",36251]
["XBUM-1403-0075","FirstName75","LastName76","2006-09-14",48782]
["USEL-1263-0076","FirstName76","LastName77","2004-05-03",35037]
["JIUQ-1432-0077","FirstName77","LastName78","2007-12-12",42336]
["PVRX-9385-0078","FirstName78","LastName79","2005-11-26",31082]
["WZGE-3448-0079","FirstName79","LastName80","2006-08-04",38708]
["CUHC-4209-0080","FirstName80","LastName81","2009-10-31",47936]
["YJXY-6033-0081","FirstName81","LastName82","2005-10-20",35066]
["DENU-9897-0082","FirstName82","LastName83","2004-11-02",46057]
["LPUJ-2730-0083","FirstName83","LastName84","2005-08-06",37358]
["ECFF-4229-0084","FirstName84","LastName85","2007-02-28",50486]

{"sheet":"P(1an)","index":1,"n_rows":101,"n_cols":31,"rows_kept":101,"cut":false,"hidden":true,"merged":[]}
[{"$f":"\"In cell \"&ADDRESS(ROW(A4),COLUMN(A4),4)&\" add a drop-down list for \"&A3&\". Then in range \"&ADDRESS(ROW(B4),COLUMN(B4),4)&\":\"&ADDRESS(ROW(E4),COLUMN(E4),4)&\" create a formula that will retrieve the employee data from the table below.\"","v":"In cell A4 add a drop-down list for Employee ID. Then in range B4:E4 create a formula that will retrieve the employee data from the table below."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rand:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Employee ID","FirstName","LastName","HireDate","Salary"]
["Employee ID","FirstName","LastName","HireDate","Salary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHAR(65+INT(RAND()*25+1))&CHAR(65+INT(RAND()*25+1))&CHAR(65+INT(RAND()*25+1))&CHAR(65+INT(RAND()*25+1))&\"-\"&RANDBETWEEN(1000,9999)&\"-\"&TEXT(ROWS(AA$2:AA3),\"0000\")","v":"VYFW-7394-0002"},"FirstName1","LastName2",{"$f":"RANDBETWEEN(37000,40300)","v":"2002-11-08"},{"$f":"RANDBETWEEN(29000,59000)","v":56430}]
["JWSO-6243-0009",{"$f":"VLOOKUP($A4,$A$18:$E$101,COLUMNS($B4:B4)+1,0)","v":"FirstName9"},{"$f":"VLOOKUP($A4,$A$18:$E$101,COLUMNS($B4:C4)+1,0)","v":"LastName10"},{"$f":"VLOOKUP($A4,$A$18:$E$101,COLUMNS($B4:D4)+1,0)","v":"2003-03-09"},{"$f":"VLOOKUP($A4,$A$18:$E$101,COLUMNS($B4:E4)+1,0)","v":58644}]
[]
["Employee ID","FirstName","LastName","HireDate","Salary"]
[{"$f":"A4","v":"JWSO-6243-0009"},{"$f":"VLOOKUP($A7,$A$18:$E$101,COLUMNS($A7:B7),0)","v":"FirstName9"},{"$f":"VLOOKUP($A7,$A$18:$E$101,COLUMNS($A7:C7),0)","v":"LastName10"},{"$f":"VLOOKUP($A7,$A$18:$E$101,COLUMNS($A7:D7),0)","v":"2003-03-09"},{"$f":"VLOOKUP($A7,$A$18:$E$101,COLUMNS($A7:E7),0)","v":58644}]
[]
["Employee ID","FirstName","LastName","HireDate","Salary"]
[{"$f":"A7","v":"JWSO-6243-0009"},{"$f":"VLOOKUP($A10,$A$18:$E$101,MATCH(B9,$A$17:$E$17,0),0)","v":"FirstName9"},{"$f":"VLOOKUP($A10,$A$18:$E$101,MATCH(C9,$A$17:$E$17,0),0)","v":"LastName10"},"2003-03-09",58644]
[]
[]
[]
[]
[]
[]
["Employee ID","FirstName","LastName","HireDate","Salary"]
["GJSM-6396-0001","FirstName1","LastName2","2005-06-29",53543]
["MLUC-2070-0002","FirstName2","LastName3","2005-05-06",29713]
["BRPB-8723-0003","FirstName3","LastName4","2010-01-11",58222]
["FRMJ-5156-0004","FirstName4","LastName5","2010-04-12",31083]
["EXUP-5444-0005","FirstName5","LastName6","2008-02-25",38656]
["DSFC-6917-0006","FirstName6","LastName7","2001-08-30",56298]
["QKZI-1300-0007","FirstName7","LastName8","2001-10-13",40540]
["XZTE-6923-0008","FirstName8","LastName9","2002-08-06",32458]
["JWSO-6243-0009","FirstName9","LastName10","2003-03-09",58644]
["DWTP-6758-0010","FirstName10","LastName11","2003-11-07",36264]
["QIGS-2445-0011","FirstName11","LastName12","2005-10-11",34630]
["OMCL-7737-0012","FirstName12","LastName13","2002-09-07",52432]
["TLJE-7153-0013","FirstName13","LastName14","2002-12-09",39565]
["XRGR-3012-0014","FirstName14","LastName15","2010-04-08",32941]
["YLGX-6164-0015","FirstName15","LastName16","2006-04-23",52813]
["NNZI-2914-0016","FirstName16","LastName17","2002-09-10",48002]
["MSEH-9132-0017","FirstName17","LastName18","2003-09-28",30414]
["VORH-3055-0018","FirstName18","LastName19","2002-03-26",46956]
["KGDD-2833-0019","FirstName19","LastName20","2008-12-18",45420]
["PPPN-9499-0020","FirstName20","LastName21","2008-02-13",38059]
["VHMG-9677-0021","FirstName21","LastName22","2004-11-10",51869]
["VGJS-6331-0022","FirstName22","LastName23","2004-03-07",32333]
["SJIE-7711-0023","FirstName23","LastName24","2006-10-25",56868]
["EPKZ-6633-0024","FirstName24","LastName25","2009-08-08",31846]
["VHHU-7337-0025","FirstName25","LastName26","2004-01-04",45553]
["BROM-3764-0026","FirstName26","LastName27","2003-05-02",37253]
["FNVM-4820-0027","FirstName27","LastName28","2003-11-15",53211]
["CHWO-4264-0028","FirstName28","LastName29","2005-03-22",44756]
["UIJD-1053-0029","FirstName29","LastName30","2004-04-11",52914]
["HUDV-8097-0030","FirstName30","LastName31","2004-03-10",38639]
["HJNR-5696-0031","FirstName31","LastName32","2008-07-18",39784]
["MSRU-2603-0032","FirstName32","LastName33","2004-09-05",47441]
["LDYS-7266-0033","FirstName33","LastName34","2003-11-19",29245]
["NQHG-3241-0034","FirstName34","LastName35","2005-09-06",50076]
["VRZK-8901-0035","FirstName35","LastName36","2010-03-16",55045]
["WOEH-6654-0036","FirstName36","LastName37","2004-06-15",48541]
["KOYM-7312-0037","FirstName37","LastName38","2007-12-30",58564]
["RTWO-6122-0038","FirstName38","LastName39","2009-04-11",39727]
["XVXW-7820-0039","FirstName39","LastName40","2009-03-10",36487]
["ICML-3006-0040","FirstName40","LastName41","2006-09-04",40059]
["TUGQ-2347-0041","FirstName41","LastName42","2005-12-27",53426]
["RNUL-8806-0042","FirstName42","LastName43","2001-07-20",29305]
["NMCD-3108-0043","FirstName43","LastName44","2002-11-22",58331]
["BXPY-8972-0044","FirstName44","LastName45","2008-10-04",29585]
["LLXL-6681-0045","FirstName45","LastName46","2007-03-01",33046]
["VNEV-1225-0046","FirstName46","LastName47","2007-01-01",45022]
["EWUV-8350-0047","FirstName47","LastName48","2001-09-10",46361]
["MBEF-3369-0048","FirstName48","LastName49","2007-01-07",53093]
["ORLI-2707-0049","FirstName49","LastName50","2008-05-25",57760]
["NHKJ-9309-0050","FirstName50","LastName51","2001-10-24",50068]
["ZMUZ-6955-0051","FirstName51","LastName52","2005-09-27",34946]
["QXBG-6338-0052","FirstName52","LastName53","2009-05-28",47062]
["UMCO-5443-0053","FirstName53","LastName54","2008-01-13",36840]
["JHCR-1640-0054","FirstName54","LastName55","2009-03-28",56499]
["KPOV-2953-0055","FirstName55","LastName56","2002-01-01",30813]
["FQGD-5774-0056","FirstName56","LastName57","2001-06-10",46092]
["EFEP-3329-0057","FirstName57","LastName58","2002-05-28",33192]
["MKZF-5213-0058","FirstName58","LastName59","2005-07-31",41632]
["RYLQ-8912-0059","FirstName59","LastName60","2008-01-12",37236]
["VEVB-4734-0060","FirstName60","LastName61","2004-11-10",58741]
["OKYK-3386-0061","FirstName61","LastName62","2005-04-08",40138]
["VSQR-6062-0062","FirstName62","LastName63","2005-08-26",42648]
["USQK-7805-0063","FirstName63","LastName64","2005-12-19",40470]
["QGOX-2944-0064","FirstName64","LastName65","2005-01-23",55414]
["CONT-7797-0065","FirstName65","LastName66","2002-12-18",37570]
["QEJO-9720-0066","FirstName66","LastName67","2009-10-17",37093]
["SLQV-9064-0067","FirstName67","LastName68","2005-08-01",49595]
["PMXY-8858-0068","FirstName68","LastName69","2007-07-11",34085]
["HEIS-2128-0069","FirstName69","LastName70","2005-12-26",53954]
["LSJX-6419-0070","FirstName70","LastName71","2006-10-10",47233]
["OOBC-6864-0071","FirstName71","LastName72","2007-07-14",51492]
["LZSM-9341-0072","FirstName72","LastName73","2009-11-10",38646]
["BOTV-7343-0073","FirstName73","LastName74","2002-04-07",33528]
["FOUU-8104-0074","FirstName74","LastName75","2001-09-28",36251]
["XBUM-1403-0075","FirstName75","LastName76","2006-09-14",48782]
["USEL-1263-0076","FirstName76","LastName77","2004-05-03",35037]
["JIUQ-1432-0077","FirstName77","LastName78","2007-12-12",42336]
["PVRX-9385-0078","FirstName78","LastName79","2005-11-26",31082]
["WZGE-3448-0079","FirstName79","LastName80","2006-08-04",38708]
["CUHC-4209-0080","FirstName80","LastName81","2009-10-31",47936]
["YJXY-6033-0081","FirstName81","LastName82","2005-10-20",35066]
["DENU-9897-0082","FirstName82","LastName83","2004-11-02",46057]
["LPUJ-2730-0083","FirstName83","LastName84","2005-08-06",37358]
["ECFF-4229-0084","FirstName84","LastName85","2007-02-28",50486]

{"sheet":"P(2)","index":2,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["In Column I create a formula that will determine the low bid for each product. Then in Column J create a look formula that will show the suppliers name associated with the low bid."]
[]
[]
["Product/Supplier","Supplier 1","Supplier 2","Supplier 3","Supplier 4","Supplier 5","Supplier 6","Supplier 7","Low Bid","Supplier Name"]
["Product 1",57.97,72.2,39.01,60.33,71.400000000000006,72.819999999999993,60.93]
["Product 2",51.67,29.87,52.23,48.34,51.37,52.58,51.64]
["Product 3",64.73,40.590000000000003,61.76,35.56,28.81,74.77,64.55]
["Product 4",73.02,64.98,53.34,62.14,29.69,50.67,48.59]
["Product 5",72.36,32.44,65.069999999999993,35.71,52.5,52.86,43]
["Product 6",47.52,47.39,26.32,47.34,49.11,56.24,73.069999999999993]
["Product 7",66.02,68.8,33.14,60.98,28.11,54.45,56.33]
["Product 8",74.569999999999993,43.65,41.36,39.86,39.22,58.92,67.209999999999994]
["Product 9",71.55,55.67,57.99,69.540000000000006,47.16,72.78,48.83]
["Product 10",50.06,70.11,41.98,63.71,51.05,26.44,30.49]
["Product 11",39.92,69.05,71.14,62.54,59.59,55.17,65.290000000000006]
["Product 12",31.03,60.19,31.82,30.53,62.71,46.56,44.78]
["Product 13",65.98,49.93,60.68,72.040000000000006,68.239999999999995,55.82,34.57]
["Product 14",40.090000000000003,27.33,62.3,41.04,44.3,40.67,26.93]
["Product 15",73.59,58.8,56.93,47.5,43.76,27.49,58.85]
["Product 16",57.86,62.93,48.05,37.69,32.81,50.7,46.65]
["Product 17",59.02,42.07,45.23,62.1,60.28,52.26,36.049999999999997]

{"sheet":"P(2an)","index":3,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["In Column I create a formula that will determine the low bid for each product. Then in Column J create a look formula that will show the suppliers name associated with the low bid."]
[]
[]
["Product/Supplier","Supplier 1","Supplier 2","Supplier 3","Supplier 4","Supplier 5","Supplier 6","Supplier 7","Low Bid","Supplier Name"]
["Product 1",57.97,72.2,39.01,60.33,71.400000000000006,72.819999999999993,60.93,{"$f":"MIN(B5:H5)","v":39.01},{"$f":"INDEX($B$4:$H$4,MATCH(I5,B5:H5,0))","v":"Supplier 3"}]
["Product 2",51.67,29.87,52.23,48.34,51.37,52.58,51.64,29.87,{"$f":"INDEX($B$4:$H$4,MATCH(I6,B6:H6,0))","v":"Supplier 2"}]
["Product 3",64.73,40.590000000000003,61.76,35.56,28.81,74.77,64.55,28.81,"Supplier 5"]
["Product 4",73.02,64.98,53.34,62.14,29.69,50.67,48.59,29.69,"Supplier 5"]
["Product 5",72.36,32.44,65.069999999999993,35.71,52.5,52.86,43,32.44,"Supplier 2"]
["Product 6",47.52,47.39,26.32,47.34,49.11,56.24,73.069999999999993,26.32,"Supplier 3"]
["Product 7",66.02,68.8,33.14,60.98,28.11,54.45,56.33,28.11,"Supplier 5"]
["Product 8",74.569999999999993,43.65,41.36,39.86,39.22,58.92,67.209999999999994,39.22,"Supplier 5"]
["Product 9",71.55,55.67,57.99,69.540000000000006,47.16,72.78,48.83,47.16,"Supplier 5"]
["Product 10",50.06,70.11,41.98,63.71,51.05,26.44,30.49,26.44,"Supplier 6"]
["Product 11",39.92,69.05,71.14,62.54,59.59,55.17,65.290000000000006,39.92,"Supplier 1"]
["Product 12",31.03,60.19,31.82,30.53,62.71,46.56,44.78,30.53,"Supplier 4"]
["Product 13",65.98,49.93,60.68,72.040000000000006,68.239999999999995,55.82,34.57,34.57,"Supplier 7"]
["Product 14",40.090000000000003,27.33,62.3,41.04,44.3,40.67,26.93,26.93,"Supplier 7"]
["Product 15",73.59,58.8,56.93,47.5,43.76,27.49,58.85,27.49,"Supplier 6"]
["Product 16",57.86,62.93,48.05,37.69,32.81,50.7,46.65,32.81,"Supplier 5"]
["Product 17",59.02,42.07,45.23,62.1,60.28,52.26,36.049999999999997,36.049999999999997,"Supplier 7"]

{"sheet":"P(3)","index":4,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"In cell \"&ADDRESS(ROW(F3),COLUMN(F3),4)&\" create a formula that will calculate the biggest improvement in stock value from 2008 to 2009. Then in cell \"&ADDRESS(ROW(F4),COLUMN(F4),4)&\" create a formula that will lookup the Stock name associated with the  biggest improvement.\"","v":"In cell F3 create a formula that will calculate the biggest improvement in stock value from 2008 to 2009. Then in cell F4 create a formula that will lookup the Stock name associated with the  biggest improvement."}]
[]
["Stock","End Value 2008","End Value 2009",null,"Biggest Improvement In Value"]
["KUVOW Stock",16.12,20.91,null,"Stock Name"]
["HKXZG Stock",14.85,22.68]
["NFPCI Stock",15.38,19.829999999999998]
["HDSDS Stock",11.43,5.2299999999999995]
["LGOTV Stock",38.47,40.6]
["ZUKKR Stock",30.5,24.59]
["YQWJX Stock",9.02,19.899999999999999]
["RVGOL Stock",22.96,16.03]
["MRYQD Stock",10.11,3.8099999999999996]
["OGDGP Stock",43.64,39.270000000000003]
["FCYRU Stock",9.51,8.8000000000000007]
["TVTZI Stock",41.41,44.75]
["LSRYT Stock",26.48,30.990000000000002]
["GQFEY Stock",20.010000000000002,14.700000000000001]
["FDIWU Stock",29.6,35.69]
["QHVMX Stock",24.22,19.439999999999998]
["GDLKS Stock",23.76,21.86]
["LIPTF Stock",29.37,21.89]

{"sheet":"P(3an)","index":5,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[{"$f":"\"In cell \"&ADDRESS(ROW(F3),COLUMN(F3),4)&\" create a formula that will calculate the biggest improvement in stock value from 2008 to 2009. Then in cell \"&ADDRESS(ROW(F4),COLUMN(F4),4)&\" create a formula that will lookup the Stock name associated with the  biggest improvement.\"","v":"In cell F3 create a formula that will calculate the biggest improvement in stock value from 2008 to 2009. Then in cell F4 create a formula that will lookup the Stock name associated with the  biggest improvement."}]
[]
["Stock","End Value 2008","End Value 2009",null,"Biggest Improvement In Value",{"$f":"MAX(C4:C21-B4:B21)","v":10.879999999999999}]
["KUVOW Stock",16.12,20.91,null,"Stock Name",{"$f":"INDEX(A4:A21,MATCH(F3,C4:C21-B4:B21,0))","v":"YQWJX Stock"}]
["HKXZG Stock",14.85,22.68]
["NFPCI Stock",15.38,19.829999999999998]
["HDSDS Stock",11.43,5.2299999999999995]
["LGOTV Stock",38.47,40.6]
["ZUKKR Stock",30.5,24.59]
["YQWJX Stock",9.02,19.899999999999999]
["RVGOL Stock",22.96,16.03]
["MRYQD Stock",10.11,3.8099999999999996]
["OGDGP Stock",43.64,39.270000000000003]
["FCYRU Stock",9.51,8.8000000000000007]
["TVTZI Stock",41.41,44.75]
["LSRYT Stock",26.48,30.990000000000002]
["GQFEY Stock",20.010000000000002,14.700000000000001]
["FDIWU Stock",29.6,35.69]
["QHVMX Stock",24.22,19.439999999999998]
["GDLKS Stock",23.76,21.86]
["LIPTF Stock",29.37,21.89]

{"sheet":"P(4)","index":6,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["In the D column create a formula that will show the InStore category for each Database category.  (The problem here is that the database uses the categories RAD, SPORT, and OUTDOOR, but our records must show the InStore category)."]
[]
[]
[]
["Date","Category","Sales","InStore Category"]
["2010-05-16","OUTDOOR",131.07,null,null,null,null,"Database Category",{"$f":"D5","v":"InStore Category"}]
["2010-05-17","OUTDOOR",159.47999999999999,null,null,null,null,"RAD","RAD-1084"]
["2010-05-18","SPORT",84.98,null,null,null,null,"SPORT","SPORT-1876"]
["2010-05-19","OUTDOOR",85.33,null,null,null,null,"OUTDOOR","OUTDOOR-1570"]
["2010-05-20","SPORT",109.55]
["2010-05-21","RAD",151.96]
["2010-05-22","RAD",87.65]
["2010-05-23","SPORT",135.76]
["2010-05-24","RAD",153.51]
["2010-05-25","RAD",113.04]
["2010-05-26","SPORT",138.41999999999999]
["2010-05-27","RAD",154.69]
["2010-05-28","OUTDOOR",145.99]
["2010-05-29","OUTDOOR",97.45]
["2010-05-30","OUTDOOR",130.43]
["2010-05-31","OUTDOOR",118.56]
["2010-06-01","OUTDOOR",127.48]
["2010-06-02","OUTDOOR",95.27]
["2010-06-03","SPORT",146.35]

{"sheet":"P(4an)","index":7,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["In the D column create a formula that will show the InStore category for each Database category.  (The problem here is that the database uses the categories RAD, SPORT, and OUTDOOR, but our records must show the InStore category)."]
[]
[]
[]
["Date","Category","Sales","InStore Category"]
["2010-05-16","OUTDOOR",131.07,{"$f":"VLOOKUP(B6,$H$7:$I$9,2,0)","v":"OUTDOOR-1570"},null,null,null,"Database Category",{"$f":"D5","v":"InStore Category"}]
["2010-05-17","OUTDOOR",159.47999999999999,{"$f":"VLOOKUP(B7,$H$7:$I$9,2,0)","v":"OUTDOOR-1570"},null,null,null,"RAD","RAD-1084"]
["2010-05-18","SPORT",84.98,"SPORT-1876",null,null,null,"SPORT","SPORT-1876"]
["2010-05-19","OUTDOOR",85.33,"OUTDOOR-1570",null,null,null,"OUTDOOR","OUTDOOR-1570"]
["2010-05-20","SPORT",109.55,"SPORT-1876"]
["2010-05-21","RAD",151.96,"RAD-1084"]
["2010-05-22","RAD",87.65,"RAD-1084"]
["2010-05-23","SPORT",135.76,"SPORT-1876"]
["2010-05-24","RAD",153.51,"RAD-1084"]
["2010-05-25","RAD",113.04,"RAD-1084"]
["2010-05-26","SPORT",138.41999999999999,"SPORT-1876"]
["2010-05-27","RAD",154.69,"RAD-1084"]
["2010-05-28","OUTDOOR",145.99,"OUTDOOR-1570"]
["2010-05-29","OUTDOOR",97.45,"OUTDOOR-1570"]
["2010-05-30","OUTDOOR",130.43,"OUTDOOR-1570"]
["2010-05-31","OUTDOOR",118.56,"OUTDOOR-1570"]
["2010-06-01","OUTDOOR",127.48,"OUTDOOR-1570"]
["2010-06-02","OUTDOOR",95.27,"OUTDOOR-1570"]
["2010-06-03","SPORT",146.35,"SPORT-1876"]

{"sheet":"P(5)","index":8,"n_rows":19,"n_cols":1,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["In cell B3 create a formula that will randomly choose an employee name."]
[]
["Randomly Select Name:"]
[]
["Employee Name"]
["Sioux"]
["Sue"]
["Phil"]
["Chin"]
["Pham"]
["Sheliadawn"]
["Frank"]
["Tina"]
["Mo"]
["Moe"]
["Jackson"]
["Isaac"]
["Sarah"]
["Amy"]

{"sheet":"P(5an)","index":9,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["In cell B3 create a formula that will randomly choose an employee name."]
[]
["Randomly Select Name:",{"$f":"INDEX(A6:A19,RANDBETWEEN(1,COUNTA(A6:A19)))","v":"Sue"},{"$f":"INDEX(A6:A19,INT(RAND()*COUNTA(A6:A19)+1))","v":"Phil"}]
[]
["Employee Name"]
["Sioux"]
["Sue"]
["Phil"]
["Chin"]
["Pham"]
["Sheliadawn"]
["Frank"]
["Tina"]
["Mo"]
["Moe"]
["Jackson"]
["Isaac"]
["Sarah"]
["Amy"]

{"sheet":"P(6)","index":10,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Use INDEX / MATCH as a substitute for VLOOKUP when the value you want to return is to the left of the lookup column.",null,null,null,"Customer Asks For a Boomerang That Flies A Certain Range. In cell F3 and G3 create a formula that will retrieve the Product name and Price."]
["Product","Price","Description",null,"Description","Product","Price"]
["Carlota",23,"Flying Range is 20",null,"Flying Range is 15"]
["Quad",30,"Flying Range is 15"]
["Bellen",22,"Flying Range is 25"]
["Sunshine",25,"Flying Range is 30"]
["Majestic Beaut",23.5,"Flying Range is 40"]
["Phenolic Sunshine",45,"Flying Range is 60"]
[]
["We need to return an item\nfrom this\n\ncolumn ==>>",null,"Lookup\n\nColumn ==>>"]

{"sheet":"P(6an)","index":11,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Use INDEX / MATCH as a substitute for VLOOKUP when the value you want to return is to the left of the lookup column.",null,null,null,"Customer Asks For a Boomerang That Flies A Certain Range. In cell F3 and G3 create a formula that will retrieve the Product name and Price."]
["Product","Price","Description",null,"Description","Product","Price"]
["Carlota",23,"Flying Range is 20",null,"Flying Range is 15",{"$f":"INDEX(A3:A8,MATCH($E3,$C$3:$C$8,0))","v":"Quad"},{"$f":"INDEX(B3:B8,MATCH($E3,$C$3:$C$8,0))","v":30}]
["Quad",30,"Flying Range is 15"]
["Bellen",22,"Flying Range is 25"]
["Sunshine",25,"Flying Range is 30"]
["Majestic Beaut",23.5,"Flying Range is 40"]
["Phenolic Sunshine",45,"Flying Range is 60"]
[]
["We need to return an item\nfrom this\n\ncolumn ==>>",null,"Lookup\n\nColumn ==>>"]

{"sheet":"P(7)","index":12,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["The commissions must be determined in column F. ProductLine1 must use the table in the range H4:I7 and ProductLine2 must use the table in the range K4:L7 ."]
[]
["Date","Sales","Product","Product Line","Sales Rep","Commission",null,"ProductLine1: Straight Dollar Commission",null,null,"ProductLine2: Commission Rate times the Sales Amount."]
["2010-05-17",3214.21,"Product3","ProductLine1","Noreen Surrett",null,null,"Product1",100,null,"Product5",0.02]
["2010-05-18",2839.58,"Product3","ProductLine1","Darren Rosson",null,null,"Product2",150,null,"Product6",0.03]
["2010-05-19",4080.47,"Product4","ProductLine1","Karina Speier",null,null,"Product3",125,null,"Product7",2.5000000000000001E-2]
["2010-05-20",4393.67,"Product5","ProductLine2","Jerri Palos",null,null,"Product4",110,null,"Product8",2.75E-2]
["2010-05-21",4479.6000000000004,"Product8","ProductLine2","Guy Beem"]
["2010-05-22",2654.98,"Product5","ProductLine2","Erik Barlowe"]
["2010-05-23",3994.22,"Product7","ProductLine2","Milagros Roots"]
["2010-05-24",4098.8,"Product2","ProductLine1","Annabelle Tobler"]
["2010-05-25",4734.34,"Product6","ProductLine2","Hugh Cutchin"]
["2010-05-26",3493.1,"Product1","ProductLine1","Guy Elsea"]
["2010-05-27",3284.31,"Product2","ProductLine1","Karina Heaps"]
["2010-05-28",4766.3999999999996,"Product6","ProductLine2","Julianne Billie"]
["2010-05-29",3601.61,"Product3","ProductLine1","Avis Koury"]
["2010-05-30",4272.68,"Product7","ProductLine2","Mathew Hindle"]
["2010-05-31",2142.69,"Product3","ProductLine1","Penelope Kaspar"]
["2010-06-01",4389.33,"Product6","ProductLine2","Carmella Brey"]
["2010-06-02",3876.18,"Product4","ProductLine1","Lakisha River"]
["2010-06-03",3907.71,"Product2","ProductLine1","Rosalinda Mansker"]
["2010-06-04",4150.7,"Product4","ProductLine1","Carlene Wiedeman"]
["2010-06-05",2773.03,"Product5","ProductLine2","Tyrone Rast"]
["2010-06-06",2145.5100000000002,"Product6","ProductLine2","Zelma Greek"]

{"sheet":"P(7an)","index":13,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["The commissions must be determined in column F. ProductLine1 must use the table in the range H4:I7 and ProductLine2 must use the table in the range K4:L7 ."]
[]
["Date","Sales","Product","Product Line","Sales Rep","Commission",null,"ProductLine1: Straight Dollar Commission",null,null,"ProductLine2: Commission Rate times the Sales Amount."]
["2010-05-17",3214.21,"Product3","ProductLine1","Noreen Surrett",{"$f":"IF(D4=\"ProductLine1\",VLOOKUP(C4,$H$4:$I$7,2,0),VLOOKUP(C4,$K$4:$L$7,2,0)*B4)","v":125},null,"Product1",100,null,"Product5",0.02]
["2010-05-18",2839.58,"Product3","ProductLine1","Darren Rosson",{"$f":"IF(D5=\"ProductLine1\",VLOOKUP(C5,$H$4:$I$7,2,0),VLOOKUP(C5,$K$4:$L$7,2,0)*B5)","v":125},null,"Product2",150,null,"Product6",0.03]
["2010-05-19",4080.47,"Product4","ProductLine1","Karina Speier",110,null,"Product3",125,null,"Product7",2.5000000000000001E-2]
["2010-05-20",4393.67,"Product5","ProductLine2","Jerri Palos",87.873400000000004,null,"Product4",110,null,"Product8",2.75E-2]
["2010-05-21",4479.6000000000004,"Product8","ProductLine2","Guy Beem",123.18900000000001]
["2010-05-22",2654.98,"Product5","ProductLine2","Erik Barlowe",53.099600000000002]
["2010-05-23",3994.22,"Product7","ProductLine2","Milagros Roots",99.855500000000006]
["2010-05-24",4098.8,"Product2","ProductLine1","Annabelle Tobler",150]
["2010-05-25",4734.34,"Product6","ProductLine2","Hugh Cutchin",142.03020000000001]
["2010-05-26",3493.1,"Product1","ProductLine1","Guy Elsea",100]
["2010-05-27",3284.31,"Product2","ProductLine1","Karina Heaps",150]
["2010-05-28",4766.3999999999996,"Product6","ProductLine2","Julianne Billie",142.99199999999999]
["2010-05-29",3601.61,"Product3","ProductLine1","Avis Koury",125]
["2010-05-30",4272.68,"Product7","ProductLine2","Mathew Hindle",106.81700000000001]
["2010-05-31",2142.69,"Product3","ProductLine1","Penelope Kaspar",125]
["2010-06-01",4389.33,"Product6","ProductLine2","Carmella Brey",131.6799]
["2010-06-02",3876.18,"Product4","ProductLine1","Lakisha River",110]
["2010-06-03",3907.71,"Product2","ProductLine1","Rosalinda Mansker",150]
["2010-06-04",4150.7,"Product4","ProductLine1","Carlene Wiedeman",110]
["2010-06-05",2773.03,"Product5","ProductLine2","Tyrone Rast",55.460600000000007]
["2010-06-06",2145.5100000000002,"Product6","ProductLine2","Zelma Greek",64.365300000000005]

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

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