{"text_format":"1","workbook":"xlsx","n_sheets":30,"sheets":["Topics","1 of 2 things in cell","IF(1)","IF(1an)","IF(2)","IF(2an)","IF(3)","IF(3an)","V(1)","V(1an)","V(2)","V(2an)","V(3)","V(3an)","V(4)","V(4an)","V(5)","V(5an)","V(6)","V(6an)","V(7)","V(7an)","HW(1)","HW(1an)","HW(2)","HW(2an)","HW(3)","HW(3an)","HW(4)","HW(4an)"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Topics","index":0,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Topics","Office Video #","Excel Basics Video #"]
["IF Function",45,27]
["VLOOKUP Function",46,28]

{"sheet":"1 of 2 things in cell","index":1,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Employee","Sales","Bonus? TRUE or FALSE?",null,"Contact reads: \"If employee has sales of $20,000 or"]
["Rod Barbaria",20382,null,null,"more they get a bonus"]
["Elinore Cromedy",19504]
["Twanda Spruce",21579]
["Darius Raffety",12117]
["Frida Vickerson",26081]
[]
["Employee","Sales","Bonus?\n0 or $750",null,"Contact reads: \"If employee has sales of $20,000 or"]
["Rod Barbaria",20382,null,null,"more they get a bonus of $750"]
["Elinore Cromedy",19504]
["Twanda Spruce",21579]
["Darius Raffety",12117]
["Frida Vickerson",26081]
[]
[]
[]
["Product","Sales","Bonus Commission? 5% or 1.5%",null,"Contact Reads if you have sales of $30,000 or more,"]
["Eagle Flyer",15000,null,null,"you earn a 5% bonus, otehrwise you get a 1.5%"]
["Quad",25000,null,null,"bonus"]
["Quad",65000]
["Carlota",15896]
["Bellen",35240]
["Bellen",24990]
["Eagle Flyer",54000]

{"sheet":"IF(1)","index":2,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Office 2013 Class #44, Excel Basics 26:",null,null,null,null,null,null,null,"Comparative Operators"]
["IF Function Made Easy!",null,null,"IF for putting 1 of 2 Things is a Cell",null,null,null,null," > Greater Than"]
[null,null,null,null,null,null,null,null," >= Greater Than Or Equal To"]
[null,null,null,"Debit Numbers","Credit Numbers",null,null,null," < Less Than"]
["Bonus Amount",500,null,58,58,null,null,null," <= Less Than Or Equal To"]
["Bonus Hurdle",50000,null,30,30,null,null,null," = Equal To"]
[null,null,null,43,43,null,null,null," <> Not Equal To"]
["Your Sales",65000,null,21.001000000000001,21]
["Do You Get Bonus?"]
["Your Bonus",null,null,null,null,null,"In Balance?"]
[null,null,null,{"$f":"SUM(D5:D10)","v":152.001},{"$f":"SUM(E5:E10)","v":152}]
[]
["Click on this link to see more about the IF function:"]
["Excel Magic Trick 452: IF Function Formula 16 Examples "]
["http://www.youtube.com/watch?v=nzph9tXO2d0"]

{"sheet":"IF(1an)","index":3,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Office 2013 Class #44, Excel Basics 26:",null,null,null,null,null,null,null,"Comparative Operators"]
["IF Function Made Easy!",null,null,"IF for putting 1 of 2 Things is a Cell",null,null,null,null," > Greater Than"]
[null,null,null,null,null,null,null,null," >= Greater Than Or Equal To"]
[null,null,null,"Debit Numbers","Credit Numbers",null,null,null," < Less Than"]
["Bonus Amount",500,null,58,58,null,null,null," <= Less Than Or Equal To"]
["Bonus Hurdle",50000,null,30,30,null,null,null," = Equal To"]
[null,null,null,43,43,null,null,null," <> Not Equal To"]
["Your Sales",100000,null,21.001000000000001,21]
["Do You Get Bonus?",{"$f":"B8>=B6","v":true}]
["Your Bonus",{"$f":"IF(B8>=B6,B5,0)","v":500},null,null,null,null,"In Balance?"]
[null,null,null,{"$f":"SUM(D5:D10)","v":152.001},{"$f":"SUM(E5:E10)","v":152},null,{"$f":"D11=E11","v":false}]
[null,null,null,null,null,null,{"$f":"IF(D11=E11,\"In Balance\",\"Not In Balance\")","v":"Not In Balance"}]
["Click on this link to see more about the IF function:"]
["Excel Magic Trick 452: IF Function Formula 16 Examples "]
["http://www.youtube.com/watch?v=nzph9tXO2d0"]

{"sheet":"IF(2)","index":4,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,null,"Logical Formula or\nlogical_test","IF used to put 1 of 2 words in cell","IF used to put 1 of 2 numbers in cell"]
["Employee","Sales","Bonus:\nTRUE or FALSE","Bonus:\n\"Yes\" or \"No\"","Bonus Amount"]
["Rod Barbaria",20382]
["Elinore Cromedy",19504]
["Twanda Spruce",21579]
["Darius Raffety",12117]
["Frida Vickerson",26081]
[]
["Bonus Hurdle",20000]
["Bonus Amount If Hurdle Equaled or Passed",750]
[]
["Click on this link to see more about the IF function:"]
["Excel Magic Trick 452: IF Function Formula 16 Examples "]
["http://www.youtube.com/watch?v=nzph9tXO2d0"]

{"sheet":"IF(2an)","index":5,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,null,"Logical Formula or\nlogical_test","IF used to put 1 of 2 words in cell","IF used to put 1 of 2 numbers in cell"]
["Employee","Sales","Bonus:\nTRUE or FALSE","Bonus:\n\"Yes\" or \"No\"","Bonus Amount"]
["Rod Barbaria",20382,{"$f":"B3>=$B$9","v":true},{"$f":"IF(B3>=$B$9,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(B3>=$B$9,$B$10,0)","v":750}]
["Elinore Cromedy",19504,{"$f":"B4>=$B$9","v":false},{"$f":"IF(B4>=$B$9,\"Yes\",\"No\")","v":"No"},{"$f":"IF(B4>=$B$9,$B$10,0)","v":0}]
["Twanda Spruce",21579,true,"Yes",750]
["Darius Raffety",12117,false,"No",0]
["Frida Vickerson",26081,true,"Yes",750]
[]
["Bonus Hurdle",20000]
["Bonus Amount If Hurdle Equaled or Passed",750]
[]
["Click on this link to see more about the IF function:"]
["Excel Magic Trick 452: IF Function Formula 16 Examples "]
["http://www.youtube.com/watch?v=nzph9tXO2d0"]

{"sheet":"IF(3)","index":6,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Product","Sales",{"$f":"\"Bonus Commission? \"&TEXT($G$2,\"0.00%\")&\" or \"&TEXT($H$2,\"0.00%\")","v":"Bonus Commission? 1.75% or 5.25%"},"$ Commission",null,"Hurdle","Commission Rate Low","Commission Rate High"]
["Eagle Flyer",15000,null,null,null,30000,1.7500000000000002E-2,5.2499999999999998E-2]
["Quad",25000]
["Quad",65000]
["Carlota",15896]
["Bellen",35240]
["Bellen",24990]
["Eagle Flyer",54000]
[]
["Product","Sales","$ Commission",null,"Hurdle","Commission Rate Low","Commission Rate High"]
["Eagle Flyer",15000,null,null,{"$f":"F2","v":30000},1.7500000000000002E-2,5.2499999999999998E-2]
["Quad",25000]
["Quad",65000]
["Carlota",15896]
["Bellen",35240]
["Bellen",24990]
["Eagle Flyer",54000]

{"sheet":"IF(3an)","index":7,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Product","Sales",{"$f":"\"Bonus Commission? \"&TEXT($G$2,\"0.00%\")&\" or \"&TEXT($H$2,\"0.00%\")","v":"Bonus Commission? 1.75% or 5.25%"},"$ Commission",null,"Hurdle","Commission Rate Low","Commission Rate High"]
["Eagle Flyer",15000,{"$f":"IF(B2>=$F$2,$H$2,$G$2)","v":1.7500000000000002E-2},{"$f":"ROUND(B2*C2,2)","v":262.5},null,30000,1.7500000000000002E-2,5.2499999999999998E-2]
["Quad",25000,{"$f":"IF(B3>=$F$2,$H$2,$G$2)","v":1.7500000000000002E-2},{"$f":"ROUND(B3*C3,2)","v":437.5}]
["Quad",65000,5.2499999999999998E-2,3412.5]
["Carlota",15896,1.7500000000000002E-2,278.18]
["Bellen",35240,5.2499999999999998E-2,1850.1]
["Bellen",24990,1.7500000000000002E-2,437.33]
["Eagle Flyer",54000,5.2499999999999998E-2,2835]
[]
["Product","Sales","$ Commission",null,"Hurdle","Commission Rate Low","Commission Rate High"]
["Eagle Flyer",15000,{"$f":"IF(B11>=$F$2,$H$2,$G$2)*B11","v":262.5},null,{"$f":"F2","v":30000},1.7500000000000002E-2,5.2499999999999998E-2]
["Quad",25000,{"$f":"IF(B12>=$F$2,$H$2,$G$2)*B12","v":437.50000000000006}]
["Quad",65000,3412.5]
["Carlota",15896,278.18]
["Bellen",35240,1850.1]
["Bellen",24990,437.32500000000005]
["Eagle Flyer",54000,2835]

{"sheet":"V(1)","index":8,"n_rows":89,"n_cols":9,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
["Office 2013 Class #45, Excel Basics 27:"]
["VLOOKUP Function Made Easy (12 Examples)"]
[]
["VLOOKUP retrieves (goes and gets) something from a table and brings it back to the cell"]
["Looking stuff up in tables is one of THE MOST COMMON TASKS. Everyone does it: employee table, commission table, product table,"]
["Lookup tables are EVERYWHERE!!!",null,null,null,null,null,null,"tax table, grade table."]
["Most tables are Vertical: meaning: the thing you are looking up in in the first column of the table and the table is orientated VERTICALLY."]
[]
["What is \"Chukes, Hal\" Hire Date?"]
["What is \"June, Aler\" Address?"]
[]
["Employee","Address","City","State","Zip","E-mail","Phone","Hire Date","Salary"]
["June, Aler","3557 1st St.","Seattle","WA",981147,"JNV@yahoo.com","206-594-4524","2005-11-11",79284]
["Acero, Natisha","6281 173rd St.","Tacoma","WA",981317,"HDT641@fun.edu","253-831-6211","2008-10-08",39555]
["Bruess, Natisha","7149 1st Ave.","Seattle","WA",981335,"YSE222@fun.edu","206-817-3217","2013-03-07",38066]
["Chukes, Hal","7726 66th Ave.","Tacoma","WA",981118,"MGF675@fun.edu","253-522-4565","2012-05-17",35751]
["Dahnke, Georgeann","316 66th Blvd. 151st St.","Kent","WA",981244,"RWN@fun.edu","253-716-7665","2011-03-28",61883]
["Dillaman, Darius","965 151st St.","Kent","WA",981162,"MJG@yahoo.com","253-585-7294","2004-04-10",70157]
["Durtschi, Dane","7582 4th Lane","Tacoma","WA",981177,"KVC@gmail.com","253-860-3024","2005-06-16",57280]
["Fila, Bryon","1654 66th St.","Seattle","WA",981143,"QKC@gmail.com","206-801-4535","2008-11-15",63015]
["Fukumoto, Marvis","3653 4th Blvd.","Seattle","WA",981280,"PKF@yahoo.com","206-563-8203","2008-08-14",54005]
["General, Marlin","7900 173rd Lane","Kent","WA",981266,"KFP@yahoo.com","253-547-6428","2009-01-09",41404]
[]
["What is your earned commission if your sales were $6000?"]
[]
["Your Sales","Commission"]
[0,0]
[5000,200]
[12500,625]
[15000,975]
[20000,1700.0000000000002]
[]
["What is the price for Quad?"]
[]
["Product","Supplier","Price"]
["Flying Eagle","Channel Craft",19]
["V Range","Colordao",18]
["Quad","Gel Boom",40]
["Bellen","Gel Boom",25]
["Carlota","Gel Boom",24]
[]
["If your Income is $3000, what is your tax?"]
[]
["Income","Tax"]
[0,0]
[1000,25]
[2000,60]
[5000,120]
[10000,175]
[]
["If your % grade is 89.5%, what is your decimal grade?"]
[]
["% Grade","Decimal Grade"]
[0.94,4]
[0.93049999999999999,3.9]
[0.92099999999999993,3.8]
[0.91149999999999998,3.7]
[0.90199999999999991,3.6]
[0.89249999999999996,3.5]
[0.88300000000000001,3.4]
[0.87349999999999994,3.3]
[0.86399999999999999,3.2]
[0.85449999999999993,3.1]
[0.84499999999999997,3]
[0.83549999999999991,2.9]
[0.82599999999999996,2.8]
[0.8165,2.7]
[0.80699999999999994,2.6]
[0.79749999999999999,2.5]
[0.78799999999999992,2.4]
[0.77849999999999997,2.2999999999999998]
[0.76899999999999991,2.2000000000000002]
[0.75949999999999995,2.1]
[0.75,2]
[0.74049999999999994,1.9]
[0.73099999999999998,1.8]
[0.72149999999999992,1.7]
[0.71199999999999997,1.6]
[0.7024999999999999,1.5]
[0.69299999999999995,1.4]
[0.6835,1.3]
[0.67399999999999993,1.2]
[0.66449999999999998,1.1000000000000001]
[0.65500000000000003,1]
[0.64549999999999996,0.9]
[0.6359999999999999,0.80000000000000104]
[0.62649999999999995,0.70000000000000095]
[0.61699999999999999,0]
[0,0]

{"sheet":"V(1an)","index":9,"n_rows":89,"n_cols":9,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
["Office 2013 Class #45, Excel Basics 27:"]
["VLOOKUP Function Made Easy (12 Examples)"]
[]
["VLOOKUP retrieves (goes and gets) something from a table and brings it back to the cell"]
["Looking stuff up in tables is one of THE MOST COMMON TASKS. Everyone does it: employee table, commission table, product table,"]
["Lookup tables are EVERYWHERE!!!",null,null,null,null,null,null,"tax table, grade table."]
["Most tables are Vertical: meaning: the thing you are looking up in in the first column of the table and the table is orientated VERTICALLY."]
[]
["What is \"Chukes, Hal\" Hire Date?"]
["What is \"June, Aler\" Address?"]
[]
["Employee","Address","City","State","Zip","E-mail","Phone","Hire Date","Salary"]
["June, Aler","3557 1st St.","Seattle","WA",981147,"JNV@yahoo.com","206-594-4524","2005-11-11",79284]
["Acero, Natisha","6281 173rd St.","Tacoma","WA",981317,"HDT641@fun.edu","253-831-6211","2008-10-08",39555]
["Bruess, Natisha","7149 1st Ave.","Seattle","WA",981335,"YSE222@fun.edu","206-817-3217","2013-03-07",38066]
["Chukes, Hal","7726 66th Ave.","Tacoma","WA",981118,"MGF675@fun.edu","253-522-4565","2012-05-17",35751]
["Dahnke, Georgeann","316 66th Blvd. 151st St.","Kent","WA",981244,"RWN@fun.edu","253-716-7665","2011-03-28",61883]
["Dillaman, Darius","965 151st St.","Kent","WA",981162,"MJG@yahoo.com","253-585-7294","2004-04-10",70157]
["Durtschi, Dane","7582 4th Lane","Tacoma","WA",981177,"KVC@gmail.com","253-860-3024","2005-06-16",57280]
["Fila, Bryon","1654 66th St.","Seattle","WA",981143,"QKC@gmail.com","206-801-4535","2008-11-15",63015]
["Fukumoto, Marvis","3653 4th Blvd.","Seattle","WA",981280,"PKF@yahoo.com","206-563-8203","2008-08-14",54005]
["General, Marlin","7900 173rd Lane","Kent","WA",981266,"KFP@yahoo.com","253-547-6428","2009-01-09",41404]
[]
["What is your earned commission if your sales were $6000?"]
[]
["Your Sales","Commission"]
[0,0]
[5000,200]
[12500,625]
[15000,975]
[20000,1700.0000000000002]
[]
["What is the price for Quad?"]
[]
["Product","Supplier","Price"]
["Flying Eagle","Channel Craft",19]
["V Range","Colordao",18]
["Quad","Gel Boom",40]
["Bellen","Gel Boom",25]
["Carlota","Gel Boom",24]
[]
["If your Income is $3000, what is your tax?"]
[]
["Income","Tax"]
[0,0]
[1000,25]
[2000,60]
[5000,120]
[10000,175]
[]
["If your % grade is 89.5%, what is your decimal grade?"]
[]
["% Grade","Decimal Grade"]
[0.94,4]
[0.93049999999999999,3.9]
[0.92099999999999993,3.8]
[0.91149999999999998,3.7]
[0.90199999999999991,3.6]
[0.89249999999999996,3.5]
[0.88300000000000001,3.4]
[0.87349999999999994,3.3]
[0.86399999999999999,3.2]
[0.85449999999999993,3.1]
[0.84499999999999997,3]
[0.83549999999999991,2.9]
[0.82599999999999996,2.8]
[0.8165,2.7]
[0.80699999999999994,2.6]
[0.79749999999999999,2.5]
[0.78799999999999992,2.4]
[0.77849999999999997,2.2999999999999998]
[0.76899999999999991,2.2000000000000002]
[0.75949999999999995,2.1]
[0.75,2]
[0.74049999999999994,1.9]
[0.73099999999999998,1.8]
[0.72149999999999992,1.7]
[0.71199999999999997,1.6]
[0.7024999999999999,1.5]
[0.69299999999999995,1.4]
[0.6835,1.3]
[0.67399999999999993,1.2]
[0.66449999999999998,1.1000000000000001]
[0.65500000000000003,1]
[0.64549999999999996,0.9]
[0.6359999999999999,0.80000000000000104]
[0.62649999999999995,0.70000000000000095]
[0.61699999999999999,0]
[0,0]

{"sheet":"V(2)","index":10,"n_rows":52,"n_cols":9,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["You start with a table with items you want to lookup in the first column (like employee name)."]
["You want to lookup the item so that you can get data about the item (like employee's e-mail address)."]
["V means Vertical, so you use VLOOKUP."]
["VLOOKUP retrieves (goes and gets) something from a table and brings it back to the cell"]
["VLOOKUP: =VLOOKUP( lookup_value , table_array , col_index_num , [range_lookup] )"]
["lookup_value = thing you look at BEFORE you go over to the table."]
["table_array = vertical table = VLOOKUP table"]
["col_index_num = which column in the table has the thing you want to go and get and bring back to the cell."]
["[range_lookup] = Exact Match = FALSE or 0. Approximate Match = TRUE or 1 or omitted."]
["Exact Match:"]
["VLOOKUP will look though each item in the first column of the VLOOKUP table and try to find a match"]
["If VLOOKUP cannot find a match it will be polite and say that it is not available: #N/A!"]
["If you are doing Exact Match use: Data Validation List:",null,null,null,"Keyboard: Alt, D, L"]
["Data Ribbon Tab, Data Tools, Data Validation, Allow textbox = List, Source = first column of VLOOKUP table_array."]
["Click on this link to see more about the VLOOKUP function:"]
["VLOOKUP Function Beginner to Advanced 26 Examples: How To Use Excel VLOOKUP Function "]
["http://www.youtube.com/watch?v=-hJxIMBbmZY"]
[]
[]
["Employee","Address","City","State","Zip","E-mail","Phone","Hire Date","Salary"]
["June, Aler","3557 1st St.","Seattle","WA",981147,"JNV@yahoo.com","206-594-4524","2005-11-11",79284]
["Acero, Natisha","6281 173rd St.","Tacoma","WA",981317,"HDT641@fun.edu","253-831-6211","2008-10-08",39555]
["Bruess, Natisha","7149 1st Ave.","Seattle","WA",981335,"YSE222@fun.edu","206-817-3217","2013-03-07",38066]
["Chukes, Hal","7726 66th Ave.","Tacoma","WA",981118,"MGF675@fun.edu","253-522-4565","2012-05-17",35751]
["Dahnke, Georgeann","316 66th Blvd. 151st St.","Kent","WA",981244,"RWN@fun.edu","253-716-7665","2011-03-28",61883]
["Dillaman, Darius","965 151st St.","Kent","WA",981162,"MJG@yahoo.com","253-585-7294","2004-04-10",70157]
["Durtschi, Dane","7582 4th Lane","Tacoma","WA",981177,"KVC@gmail.com","253-860-3024","2005-06-16",57280]
["Fila, Bryon","1654 66th St.","Seattle","WA",981143,"QKC@gmail.com","206-801-4535","2008-11-15",63015]
["Fukumoto, Marvis","3653 4th Blvd.","Seattle","WA",981280,"PKF@yahoo.com","206-563-8203","2008-08-14",54005]
["General, Marlin","7900 173rd Lane","Kent","WA",981266,"KFP@yahoo.com","253-547-6428","2009-01-09",41404]
[]
["Employee","E-mail"]
["Chukes, Hal"]
[]
["Employee","Phone"]
[]
[]
["Employee","Address"]
[]
[]
[]
[]
[]
[]
["Employee","Salary"]
["General, Marlin"]
["Chukes, Hal"]
["June, Aler"]
["Fukumoto, Marvis"]
["Acero, Natisha"]
["Bruess, Natisha"]
["Dahnke, Georgeann"]

{"sheet":"V(2an)","index":11,"n_rows":52,"n_cols":9,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["You start with a table with items you want to lookup in the first column (like employee name)."]
["You want to lookup the item so that you can get data about the item (like employee's e-mail address)."]
["V means Vertical, so you use VLOOKUP."]
["VLOOKUP retrieves (goes and gets) something from a table and brings it back to the cell"]
["VLOOKUP: =VLOOKUP( lookup_value , table_array , col_index_num , [range_lookup] )"]
["lookup_value = thing you look at BEFORE you go over to the table."]
["table_array = vertical table = VLOOKUP table"]
["col_index_num = which column in the table has the thing you want to go and get and bring back to the cell."]
["[range_lookup] = Exact Match = FALSE or 0. Approximate Match = TRUE or 1 or omitted."]
["Exact Match:"]
["VLOOKUP will look though each item in the first column of the VLOOKUP table and try to find a match"]
["If VLOOKUP cannot find a match it will be polite and say that it is not available: #N/A!"]
["If you are doing Exact Match use: Data Validation List:",null,null,null,"Keyboard: Alt, D, L"]
["Data Ribbon Tab, Data Tools, Data Validation, Allow textbox = List, Source = first column of VLOOKUP table_array."]
["Click on this link to see more about the VLOOKUP function:"]
["VLOOKUP Function Beginner to Advanced 26 Examples: How To Use Excel VLOOKUP Function "]
["http://www.youtube.com/watch?v=-hJxIMBbmZY"]
[]
[]
["Employee","Address","City","State","Zip","E-mail","Phone","Hire Date","Salary"]
["June, Aler","3557 1st St.","Seattle","WA",981147,"JNV@yahoo.com","206-594-4524","2005-11-11",79284]
["Acero, Natisha","6281 173rd St.","Tacoma","WA",981317,"HDT641@fun.edu","253-831-6211","2008-10-08",39555]
["Bruess, Natisha","7149 1st Ave.","Seattle","WA",981335,"YSE222@fun.edu","206-817-3217","2013-03-07",38066]
["Chukes, Hal","7726 66th Ave.","Tacoma","WA",981118,"MGF675@fun.edu","253-522-4565","2012-05-17",35751]
["Dahnke, Georgeann","316 66th Blvd. 151st St.","Kent","WA",981244,"RWN@fun.edu","253-716-7665","2011-03-28",61883]
["Dillaman, Darius","965 151st St.","Kent","WA",981162,"MJG@yahoo.com","253-585-7294","2004-04-10",70157]
["Durtschi, Dane","7582 4th Lane","Tacoma","WA",981177,"KVC@gmail.com","253-860-3024","2005-06-16",57280]
["Fila, Bryon","1654 66th St.","Seattle","WA",981143,"QKC@gmail.com","206-801-4535","2008-11-15",63015]
["Fukumoto, Marvis","3653 4th Blvd.","Seattle","WA",981280,"PKF@yahoo.com","206-563-8203","2008-08-14",54005]
["General, Marlin","7900 173rd Lane","Kent","WA",981266,"KFP@yahoo.com","253-547-6428","2009-01-09",41404]
[]
["Employee","E-mail"]
["Fukumoto, Marvis",{"$f":"VLOOKUP(A33,A21:I30,6,FALSE)","v":"PKF@yahoo.com"}]
[]
["Employee","Phone"]
["General, Marlin",{"$f":"VLOOKUP(A36,A21:I30,7,FALSE)","v":"253-547-6428"}]
[]
["Employee","Address"]
["Bruess, Natisha",{"$f":"VLOOKUP(A39,A21:I30,2,0)","v":"7149 1st Ave."}]
[]
[]
[]
[]
[]
["Employee","Salary"]
["General, Marlin",{"$f":"VLOOKUP(A46,$A$21:$I$30,9,0)","v":41404}]
["Chukes, Hal",{"$f":"VLOOKUP(A47,$A$21:$I$30,9,0)","v":35751}]
["June, Aler",79284]
["Fukumoto, Marvis",54005]
["Acero, Natisha",39555]
["Bruess, Natisha",38066]
["Dahnke, Georgeann",61883]

{"sheet":"V(3)","index":12,"n_rows":108,"n_cols":14,"rows_kept":108,"cut":false,"hidden":false,"merged":[]}
["Approximate Match:"]
["For Approximate Match the VLOOKUP table MUST be sorted on the first column: Ascending, A to Z, Small to Big."]
["For Approximate Match VLOOKUP will race through the first column:"]
["1) If the first value in the table is smaller than the lookup_value, VLOOKUP returns a Not Available Error: #N/A!"]
["2) It looks through the first column until it bumps into the first value bigger than it and then jump back one row (it actually does a binary search which is really fast compared to Exact Match)."]
["3) If the lookup_value is bigger than the last value, it stops at the last row."]
[]
["Your Sales","Commission",null,"Your Sales","Commission",null,null,null,"Your Sales","Commission",null,"Employee","Sales","Commission"]
[0,0,null,7500,null,null,null,null,0,0,null,"Antonio May",9635.25]
[5000,200,null,null,null,null,null,null,5000,200,null,"Brittany Ellis",3856]
[12500,625,null,null,null,null,null,null,12500,625,null,"Clyde Haynes",33567]
[15000,975,null,null,null,null,null,null,15000,975,null,"Johnnie Jones",6895]
[20000,1700.0000000000002,null,null,null,null,null,null,20000,1700.0000000000002,null,"Emmett Fleming",13210]
[null,null,null,null,null,null,null,null,null,null,null,"Krista Kennedy",25912]
["Your Sales","Commission Rate",null,"Your Sales","Commission Rate","Commission Amount",null,null,null,null,null,"Bernadette Barber",24954]
[0,7.4999999999999997E-3,null,7500,null,null,null,null,null,null,null,"Marvin Wood",15364]
[5000,4.7500000000000001E-2,null,null,null,null,null,null,null,null,null,"Wendy Thomas",2415]
[12500,5.7500000000000002E-2,null,"*** Approximate Match = TRUE or 1 or omitted.",null,null,null,null,null,null,null,"Heidi Ross",33198]
[15000,7.2500000000000009E-2,null,null,null,null,null,null,null,null,null,"Otis Harrison",23569]
[20000,9.2499999999999999E-2,null,null,null,null,null,null,null,null,null,"Dale Edwards",6242]
[null,null,null,null,null,null,null,null,null,null,null,"Matt Malone",9111]
["Income","Tax",null,"Income","Tax",null,null,null,null,null,null,"Robin Moran",138]
[0,0,null,6895.25,null,null,null,null,null,null,null,"Penny Casey",9487]
[1000,25,null,null,null,null,null,null,null,null,null,"Marilyn Daniels",3607]
[2000,60,null,null,null,null,null,null,null,null,null,"Rodolfo Bryan",24144]
[5000,120,null,null,null,null,null,null,null,null,null,"Walter Simpson",18774]
[10000,175,null,null,null,null,null,null,null,null,null,"Thelma Jacobs",12464]
[null,null,null,null,null,null,null,null,null,null,null,"Priscilla French",13162]
[null,null,null,"Your % Grade","Your Decimal Grade:",null,null,null,null,null,null,"Catherine Burgess",6318]
[null,null,null,0.93500000000000005,null,null,null,null,null,null,null,"Jody Fitzgerald",15656]
[null,null,null,null,null,null,null,null,null,null,null,"Mandy Graves",13148]
["How it apears in Syllabus:",null,null,"How it must be setup for VLOOKUP:",null,null,null,null,null,null,null,"Blanche Martinez",2467]
[null,null,null,null,null,null,null,null,null,null,null,"Shane Watkins",6900]
["% Grade","Decimal Grade",null,"% Grade","Decimal Grade",null,null,null,null,null,null,"Martin Wright",11455]
[0.94,4,null,{"$f":"INDEX($A$35:$B$69,ROWS($D35:$D$69),COLUMNS($D35:D35))","v":0},{"$f":"INDEX($A$35:$B$69,ROWS($D35:$D$69),COLUMNS($D35:E35))","v":0},null,null,null,null,null,null,"Robin Santos",5527]
[0.93049999999999999,3.9,null,{"$f":"INDEX($A$35:$B$69,ROWS($D36:$D$69),COLUMNS($D36:D36))","v":0.62649999999999995},{"$f":"INDEX($A$35:$B$69,ROWS($D36:$D$69),COLUMNS($D36:E36))","v":0.70000000000000095},null,null,null,null,null,null,"Cedric Parker",4629]
[0.92099999999999993,3.8,null,{"$f":"INDEX($A$35:$B$69,ROWS($D37:$D$69),COLUMNS($D37:D37))","v":0.6359999999999999},{"$f":"INDEX($A$35:$B$69,ROWS($D37:$D$69),COLUMNS($D37:E37))","v":0.80000000000000104},null,null,null,null,null,null,"Bonnie Schultz",28609]
[0.91149999999999998,3.7,null,{"$f":"INDEX($A$35:$B$69,ROWS($D38:$D$69),COLUMNS($D38:D38))","v":0.64549999999999996},{"$f":"INDEX($A$35:$B$69,ROWS($D38:$D$69),COLUMNS($D38:E38))","v":0.9},null,null,null,null,null,null,"Della Hernandez",19679]
[0.90199999999999991,3.6,null,{"$f":"INDEX($A$35:$B$69,ROWS($D39:$D$69),COLUMNS($D39:D39))","v":0.65500000000000003},{"$f":"INDEX($A$35:$B$69,ROWS($D39:$D$69),COLUMNS($D39:E39))","v":1},null,null,null,null,null,null,"Sonia Lee",11486]
[0.89249999999999996,3.5,null,{"$f":"INDEX($A$35:$B$69,ROWS($D40:$D$69),COLUMNS($D40:D40))","v":0.66449999999999998},{"$f":"INDEX($A$35:$B$69,ROWS($D40:$D$69),COLUMNS($D40:E40))","v":1.1000000000000001},null,null,null,null,null,null,"Anna Pena",19776]
[0.88300000000000001,3.4,null,{"$f":"INDEX($A$35:$B$69,ROWS($D41:$D$69),COLUMNS($D41:D41))","v":0.67399999999999993},{"$f":"INDEX($A$35:$B$69,ROWS($D41:$D$69),COLUMNS($D41:E41))","v":1.2},null,null,null,null,null,null,"Sara Poole",1585]
[0.87349999999999994,3.3,null,{"$f":"INDEX($A$35:$B$69,ROWS($D42:$D$69),COLUMNS($D42:D42))","v":0.6835},{"$f":"INDEX($A$35:$B$69,ROWS($D42:$D$69),COLUMNS($D42:E42))","v":1.3},null,null,null,null,null,null,"Claire Gibson",11501]
[0.86399999999999999,3.2,null,{"$f":"INDEX($A$35:$B$69,ROWS($D43:$D$69),COLUMNS($D43:D43))","v":0.69299999999999995},{"$f":"INDEX($A$35:$B$69,ROWS($D43:$D$69),COLUMNS($D43:E43))","v":1.4},null,null,null,null,null,null,"Eleanor Cunningham",34247]
[0.85449999999999993,3.1,null,{"$f":"INDEX($A$35:$B$69,ROWS($D44:$D$69),COLUMNS($D44:D44))","v":0.7024999999999999},{"$f":"INDEX($A$35:$B$69,ROWS($D44:$D$69),COLUMNS($D44:E44))","v":1.5},null,null,null,null,null,null,"Elena Newton",7377]
[0.84499999999999997,3,null,{"$f":"INDEX($A$35:$B$69,ROWS($D45:$D$69),COLUMNS($D45:D45))","v":0.71199999999999997},{"$f":"INDEX($A$35:$B$69,ROWS($D45:$D$69),COLUMNS($D45:E45))","v":1.6},null,null,null,null,null,null,"Renee Reid",24817]
[0.83549999999999991,2.9,null,{"$f":"INDEX($A$35:$B$69,ROWS($D46:$D$69),COLUMNS($D46:D46))","v":0.72149999999999992},{"$f":"INDEX($A$35:$B$69,ROWS($D46:$D$69),COLUMNS($D46:E46))","v":1.7},null,null,null,null,null,null,"Maurice Gardner",24509]
[0.82599999999999996,2.8,null,{"$f":"INDEX($A$35:$B$69,ROWS($D47:$D$69),COLUMNS($D47:D47))","v":0.73099999999999998},{"$f":"INDEX($A$35:$B$69,ROWS($D47:$D$69),COLUMNS($D47:E47))","v":1.8},null,null,null,null,null,null,"Juanita Kelley",15938]
[0.8165,2.7,null,{"$f":"INDEX($A$35:$B$69,ROWS($D48:$D$69),COLUMNS($D48:D48))","v":0.74049999999999994},{"$f":"INDEX($A$35:$B$69,ROWS($D48:$D$69),COLUMNS($D48:E48))","v":1.9},null,null,null,null,null,null,"Lynne Joseph",27338]
[0.80699999999999994,2.6,null,{"$f":"INDEX($A$35:$B$69,ROWS($D49:$D$69),COLUMNS($D49:D49))","v":0.75},{"$f":"INDEX($A$35:$B$69,ROWS($D49:$D$69),COLUMNS($D49:E49))","v":2},null,null,null,null,null,null,"Frederick Cohen",28257]
[0.79749999999999999,2.5,null,{"$f":"INDEX($A$35:$B$69,ROWS($D50:$D$69),COLUMNS($D50:D50))","v":0.75949999999999995},{"$f":"INDEX($A$35:$B$69,ROWS($D50:$D$69),COLUMNS($D50:E50))","v":2.1},null,null,null,null,null,null,"Kent Spencer",21829]
[0.78799999999999992,2.4,null,{"$f":"INDEX($A$35:$B$69,ROWS($D51:$D$69),COLUMNS($D51:D51))","v":0.76899999999999991},{"$f":"INDEX($A$35:$B$69,ROWS($D51:$D$69),COLUMNS($D51:E51))","v":2.2000000000000002},null,null,null,null,null,null,"Scott Roberts",13999]
[0.77849999999999997,2.2999999999999998,null,{"$f":"INDEX($A$35:$B$69,ROWS($D52:$D$69),COLUMNS($D52:D52))","v":0.77849999999999997},{"$f":"INDEX($A$35:$B$69,ROWS($D52:$D$69),COLUMNS($D52:E52))","v":2.2999999999999998},null,null,null,null,null,null,"Hannah Love",22301]
[0.76899999999999991,2.2000000000000002,null,{"$f":"INDEX($A$35:$B$69,ROWS($D53:$D$69),COLUMNS($D53:D53))","v":0.78799999999999992},{"$f":"INDEX($A$35:$B$69,ROWS($D53:$D$69),COLUMNS($D53:E53))","v":2.4},null,null,null,null,null,null,"Rafael Mckenzie",3969]
[0.75949999999999995,2.1,null,{"$f":"INDEX($A$35:$B$69,ROWS($D54:$D$69),COLUMNS($D54:D54))","v":0.79749999999999999},{"$f":"INDEX($A$35:$B$69,ROWS($D54:$D$69),COLUMNS($D54:E54))","v":2.5},null,null,null,null,null,null,"Rosie Vega",12072]
[0.75,2,null,{"$f":"INDEX($A$35:$B$69,ROWS($D55:$D$69),COLUMNS($D55:D55))","v":0.80699999999999994},{"$f":"INDEX($A$35:$B$69,ROWS($D55:$D$69),COLUMNS($D55:E55))","v":2.6},null,null,null,null,null,null,"Ryan Phillips",16733]
[0.74049999999999994,1.9,null,{"$f":"INDEX($A$35:$B$69,ROWS($D56:$D$69),COLUMNS($D56:D56))","v":0.8165},{"$f":"INDEX($A$35:$B$69,ROWS($D56:$D$69),COLUMNS($D56:E56))","v":2.7},null,null,null,null,null,null,"Lorene Thompson",32260]
[0.73099999999999998,1.8,null,{"$f":"INDEX($A$35:$B$69,ROWS($D57:$D$69),COLUMNS($D57:D57))","v":0.82599999999999996},{"$f":"INDEX($A$35:$B$69,ROWS($D57:$D$69),COLUMNS($D57:E57))","v":2.8},null,null,null,null,null,null,"Nellie Freeman",16905]
[0.72149999999999992,1.7,null,{"$f":"INDEX($A$35:$B$69,ROWS($D58:$D$69),COLUMNS($D58:D58))","v":0.83549999999999991},{"$f":"INDEX($A$35:$B$69,ROWS($D58:$D$69),COLUMNS($D58:E58))","v":2.9},null,null,null,null,null,null,"Elvira Cannon",31439]
[0.71199999999999997,1.6,null,{"$f":"INDEX($A$35:$B$69,ROWS($D59:$D$69),COLUMNS($D59:D59))","v":0.84499999999999997},{"$f":"INDEX($A$35:$B$69,ROWS($D59:$D$69),COLUMNS($D59:E59))","v":3},null,null,null,null,null,null,"Kerry Norris",34687]
[0.7024999999999999,1.5,null,{"$f":"INDEX($A$35:$B$69,ROWS($D60:$D$69),COLUMNS($D60:D60))","v":0.85449999999999993},{"$f":"INDEX($A$35:$B$69,ROWS($D60:$D$69),COLUMNS($D60:E60))","v":3.1},null,null,null,null,null,null,"Rosalie Nunez",26559]
[0.69299999999999995,1.4,null,{"$f":"INDEX($A$35:$B$69,ROWS($D61:$D$69),COLUMNS($D61:D61))","v":0.86399999999999999},{"$f":"INDEX($A$35:$B$69,ROWS($D61:$D$69),COLUMNS($D61:E61))","v":3.2},null,null,null,null,null,null,"Elias Lloyd",34179]
[0.6835,1.3,null,{"$f":"INDEX($A$35:$B$69,ROWS($D62:$D$69),COLUMNS($D62:D62))","v":0.87349999999999994},{"$f":"INDEX($A$35:$B$69,ROWS($D62:$D$69),COLUMNS($D62:E62))","v":3.3},null,null,null,null,null,null,"Mona Tate",7654]
[0.67399999999999993,1.2,null,{"$f":"INDEX($A$35:$B$69,ROWS($D63:$D$69),COLUMNS($D63:D63))","v":0.88300000000000001},{"$f":"INDEX($A$35:$B$69,ROWS($D63:$D$69),COLUMNS($D63:E63))","v":3.4},null,null,null,null,null,null,"Blanca Terry",24034]
[0.66449999999999998,1.1000000000000001,null,{"$f":"INDEX($A$35:$B$69,ROWS($D64:$D$69),COLUMNS($D64:D64))","v":0.89249999999999996},{"$f":"INDEX($A$35:$B$69,ROWS($D64:$D$69),COLUMNS($D64:E64))","v":3.5},null,null,null,null,null,null,"Kyle Reyes",14395]
[0.65500000000000003,1,null,{"$f":"INDEX($A$35:$B$69,ROWS($D65:$D$69),COLUMNS($D65:D65))","v":0.90199999999999991},{"$f":"INDEX($A$35:$B$69,ROWS($D65:$D$69),COLUMNS($D65:E65))","v":3.6},null,null,null,null,null,null,"Delores Coleman",33789]
[0.64549999999999996,0.9,null,{"$f":"INDEX($A$35:$B$69,ROWS($D66:$D$69),COLUMNS($D66:D66))","v":0.91149999999999998},{"$f":"INDEX($A$35:$B$69,ROWS($D66:$D$69),COLUMNS($D66:E66))","v":3.7},null,null,null,null,null,null,"Amanda Black",2856]
[0.6359999999999999,0.80000000000000104,null,{"$f":"INDEX($A$35:$B$69,ROWS($D67:$D$69),COLUMNS($D67:D67))","v":0.92099999999999993},{"$f":"INDEX($A$35:$B$69,ROWS($D67:$D$69),COLUMNS($D67:E67))","v":3.8},null,null,null,null,null,null,"Grant Gibbs",29477]
[0.62649999999999995,0.70000000000000095,null,{"$f":"INDEX($A$35:$B$69,ROWS($D68:$D$69),COLUMNS($D68:D68))","v":0.93049999999999999},{"$f":"INDEX($A$35:$B$69,ROWS($D68:$D$69),COLUMNS($D68:E68))","v":3.9},null,null,null,null,null,null,"Emily Carr",31158]
[0,0,null,{"$f":"INDEX($A$35:$B$69,ROWS($D69:$D$69),COLUMNS($D69:D69))","v":0.94},{"$f":"INDEX($A$35:$B$69,ROWS($D69:$D$69),COLUMNS($D69:E69))","v":4},null,null,null,null,null,null,"Lee Ruiz",3350]
[null,null,null,null,null,null,null,null,null,null,null,"Eloise Beck",22735]
[null,null,null,null,null,null,null,null,null,null,null,"Norman Sanders",8853]
[null,null,null,null,null,null,null,null,null,null,null,"Glenda Page",14882]
[null,null,null,null,null,null,null,null,null,null,null,"Ian Neal",6835]
[null,null,null,null,null,null,null,null,null,null,null,"Mae Sparks",10569]
[null,null,null,null,null,null,null,null,null,null,null,"Tricia Curtis",17916]
[null,null,null,null,null,null,null,null,null,null,null,"Howard Wilkerson",3846]
[null,null,null,null,null,null,null,null,null,null,null,"Cary Stephens",26659]
[null,null,null,null,null,null,null,null,null,null,null,"Jeanne Boyd",23916]
[null,null,null,null,null,null,null,null,null,null,null,"Terrell Walsh",12124]
[null,null,null,null,null,null,null,null,null,null,null,"Javier Bennett",19504]
[null,null,null,null,null,null,null,null,null,null,null,"Jonathon Manning",30158]
[null,null,null,null,null,null,null,null,null,null,null,"Myra Hubbard",15801]
[null,null,null,null,null,null,null,null,null,null,null,"Lucille Graham",1586]
[null,null,null,null,null,null,null,null,null,null,null,"Craig Bryant",27113]
[null,null,null,null,null,null,null,null,null,null,null,"Krystal Wagner",32183]
[null,null,null,null,null,null,null,null,null,null,null,"Katrina Carter",11047]
[null,null,null,null,null,null,null,null,null,null,null,"Sergio Lucas",34753]
[null,null,null,null,null,null,null,null,null,null,null,"Joyce Taylor",12187]
[null,null,null,null,null,null,null,null,null,null,null,"Marta Watts",17897]
[null,null,null,null,null,null,null,null,null,null,null,"Candace Holloway",10202]
[null,null,null,null,null,null,null,null,null,null,null,"Gwen James",27823]
[null,null,null,null,null,null,null,null,null,null,null,"Lela Snyder",1352]
[null,null,null,null,null,null,null,null,null,null,null,"Louise Mathis",5515]
[null,null,null,null,null,null,null,null,null,null,null,"Maxine Miller",15066]
[null,null,null,null,null,null,null,null,null,null,null,"Omar Gonzales",8636]
[null,null,null,null,null,null,null,null,null,null,null,"Loren Delgado",2377]
[null,null,null,null,null,null,null,null,null,null,null,"Brandi Shelton",20270]
[null,null,null,null,null,null,null,null,null,null,null,"Jimmie Walters",2893]
[null,null,null,null,null,null,null,null,null,null,null,"Gilberto Robbins",26703]
[null,null,null,null,null,null,null,null,null,null,null,"Dianne Pearson",14065]
[null,null,null,null,null,null,null,null,null,null,null,"Derek Clayton",28685]
[null,null,null,null,null,null,null,null,null,null,null,"Jon Robinson",5415]
[null,null,null,null,null,null,null,null,null,null,null,"Silvia Johnston",13310]
[null,null,null,null,null,null,null,null,null,null,null,"Denise Morris",527]
[null,null,null,null,null,null,null,null,null,null,null,"Orlando Vasquez",24990]
[null,null,null,null,null,null,null,null,null,null,null,"Cindy Chavez",30968]
[null,null,null,null,null,null,null,null,null,null,null,"Andrea Day",12466]
[null,null,null,null,null,null,null,null,null,null,null,"Vincent Summers",3791]

{"sheet":"V(3an)","index":13,"n_rows":108,"n_cols":14,"rows_kept":108,"cut":false,"hidden":false,"merged":[]}
["Approximate Match:"]
["For Approximate Match the VLOOKUP table MUST be sorted on the first column: Ascending, A to Z, Small to Big."]
["For Approximate Match VLOOKUP will race through the first column:"]
["1) If the first value in the table is smaller than the lookup_value, VLOOKUP returns a Not Available Error: #N/A!"]
["2) It looks through the first column until it bumps into the first value bigger than it and then jump back one row (it actually does a binary search which is really fast compared to Exact Match)."]
["3) If the lookup_value is bigger than the last value, it stops at the last row."]
[]
["Your Sales","Commission",null,"Your Sales","Commission",null,null,null,"Your Sales","Commission",null,"Employee","Sales","Commission"]
[0,0,null,7500,{"$f":"VLOOKUP(D9,A9:B13,2,TRUE)","v":200},null,null,null,0,0,null,"Antonio May",9635.25,{"$f":"VLOOKUP(M9,$I$9:$J$13,2,TRUE)","v":200}]
[5000,200,null,null,null,null,null,null,5000,200,null,"Brittany Ellis",3856,{"$f":"VLOOKUP(M10,$I$9:$J$13,2,TRUE)","v":0}]
[12500,625,null,null,null,null,null,null,12500,625,null,"Clyde Haynes",33567,1700.0000000000002]
[15000,975,null,null,null,null,null,null,15000,975,null,"Johnnie Jones",6895,200]
[20000,1700.0000000000002,null,null,null,null,null,null,20000,1700.0000000000002,null,"Emmett Fleming",13210,625]
[null,null,null,null,null,null,null,null,null,null,null,"Krista Kennedy",25912,1700.0000000000002]
["Your Sales","Commission Rate",null,"Your Sales","Commission Rate","Commission Amount",null,null,null,null,null,"Bernadette Barber",24954,1700.0000000000002]
[0,7.4999999999999997E-3,null,7500,{"$f":"VLOOKUP(D16,A16:B20,2)","v":4.7500000000000001E-2},{"$f":"ROUND(D16*E16,2)","v":356.25},null,null,null,null,null,"Marvin Wood",15364,975]
[5000,4.7500000000000001E-2,null,null,null,null,null,null,null,null,null,"Wendy Thomas",2415,0]
[12500,5.7500000000000002E-2,null,"*** Approximate Match = TRUE or 1 or omitted.",null,null,null,null,null,null,null,"Heidi Ross",33198,1700.0000000000002]
[15000,7.2500000000000009E-2,null,null,null,null,null,null,null,null,null,"Otis Harrison",23569,1700.0000000000002]
[20000,9.2499999999999999E-2,null,null,null,null,null,null,null,null,null,"Dale Edwards",6242,200]
[null,null,null,null,null,null,null,null,null,null,null,"Matt Malone",9111,200]
["Income","Tax",null,"Income","Tax",null,null,null,null,null,null,"Robin Moran",138,0]
[0,0,null,6895.25,{"$f":"VLOOKUP(D23,A23:B27,2)","v":120},null,null,null,null,null,null,"Penny Casey",9487,200]
[1000,25,null,null,null,null,null,null,null,null,null,"Marilyn Daniels",3607,0]
[2000,60,null,null,null,null,null,null,null,null,null,"Rodolfo Bryan",24144,1700.0000000000002]
[5000,120,null,null,null,null,null,null,null,null,null,"Walter Simpson",18774,975]
[10000,175,null,null,null,null,null,null,null,null,null,"Thelma Jacobs",12464,200]
[null,null,null,null,null,null,null,null,null,null,null,"Priscilla French",13162,625]
[null,null,null,"Your % Grade","Your Decimal Grade:",null,null,null,null,null,null,"Catherine Burgess",6318,200]
[null,null,null,0.93500000000000005,{"$f":"VLOOKUP(D30,D35:E69,2)","v":3.9},null,null,null,null,null,null,"Jody Fitzgerald",15656,975]
[null,null,null,null,null,null,null,null,null,null,null,"Mandy Graves",13148,625]
["How it apears in Syllabus:",null,null,"How it must be setup for VLOOKUP:",null,null,null,null,null,null,null,"Blanche Martinez",2467,0]
[null,null,null,null,null,null,null,null,null,null,null,"Shane Watkins",6900,200]
["% Grade","Decimal Grade",null,"% Grade","Decimal Grade",null,null,null,null,null,null,"Martin Wright",11455,200]
[0.94,4,null,{"$f":"INDEX($A$35:$B$69,ROWS($D35:$D$69),COLUMNS($D35:D35))","v":0},{"$f":"INDEX($A$35:$B$69,ROWS($D35:$D$69),COLUMNS($D35:E35))","v":0},null,null,null,null,null,null,"Robin Santos",5527,200]
[0.93049999999999999,3.9,null,{"$f":"INDEX($A$35:$B$69,ROWS($D36:$D$69),COLUMNS($D36:D36))","v":0.62649999999999995},{"$f":"INDEX($A$35:$B$69,ROWS($D36:$D$69),COLUMNS($D36:E36))","v":0.70000000000000095},null,null,null,null,null,null,"Cedric Parker",4629,0]
[0.92099999999999993,3.8,null,{"$f":"INDEX($A$35:$B$69,ROWS($D37:$D$69),COLUMNS($D37:D37))","v":0.6359999999999999},{"$f":"INDEX($A$35:$B$69,ROWS($D37:$D$69),COLUMNS($D37:E37))","v":0.80000000000000104},null,null,null,null,null,null,"Bonnie Schultz",28609,1700.0000000000002]
[0.91149999999999998,3.7,null,{"$f":"INDEX($A$35:$B$69,ROWS($D38:$D$69),COLUMNS($D38:D38))","v":0.64549999999999996},{"$f":"INDEX($A$35:$B$69,ROWS($D38:$D$69),COLUMNS($D38:E38))","v":0.9},null,null,null,null,null,null,"Della Hernandez",19679,975]
[0.90199999999999991,3.6,null,{"$f":"INDEX($A$35:$B$69,ROWS($D39:$D$69),COLUMNS($D39:D39))","v":0.65500000000000003},{"$f":"INDEX($A$35:$B$69,ROWS($D39:$D$69),COLUMNS($D39:E39))","v":1},null,null,null,null,null,null,"Sonia Lee",11486,200]
[0.89249999999999996,3.5,null,{"$f":"INDEX($A$35:$B$69,ROWS($D40:$D$69),COLUMNS($D40:D40))","v":0.66449999999999998},{"$f":"INDEX($A$35:$B$69,ROWS($D40:$D$69),COLUMNS($D40:E40))","v":1.1000000000000001},null,null,null,null,null,null,"Anna Pena",19776,975]
[0.88300000000000001,3.4,null,{"$f":"INDEX($A$35:$B$69,ROWS($D41:$D$69),COLUMNS($D41:D41))","v":0.67399999999999993},{"$f":"INDEX($A$35:$B$69,ROWS($D41:$D$69),COLUMNS($D41:E41))","v":1.2},null,null,null,null,null,null,"Sara Poole",1585,0]
[0.87349999999999994,3.3,null,{"$f":"INDEX($A$35:$B$69,ROWS($D42:$D$69),COLUMNS($D42:D42))","v":0.6835},{"$f":"INDEX($A$35:$B$69,ROWS($D42:$D$69),COLUMNS($D42:E42))","v":1.3},null,null,null,null,null,null,"Claire Gibson",11501,200]
[0.86399999999999999,3.2,null,{"$f":"INDEX($A$35:$B$69,ROWS($D43:$D$69),COLUMNS($D43:D43))","v":0.69299999999999995},{"$f":"INDEX($A$35:$B$69,ROWS($D43:$D$69),COLUMNS($D43:E43))","v":1.4},null,null,null,null,null,null,"Eleanor Cunningham",34247,1700.0000000000002]
[0.85449999999999993,3.1,null,{"$f":"INDEX($A$35:$B$69,ROWS($D44:$D$69),COLUMNS($D44:D44))","v":0.7024999999999999},{"$f":"INDEX($A$35:$B$69,ROWS($D44:$D$69),COLUMNS($D44:E44))","v":1.5},null,null,null,null,null,null,"Elena Newton",7377,200]
[0.84499999999999997,3,null,{"$f":"INDEX($A$35:$B$69,ROWS($D45:$D$69),COLUMNS($D45:D45))","v":0.71199999999999997},{"$f":"INDEX($A$35:$B$69,ROWS($D45:$D$69),COLUMNS($D45:E45))","v":1.6},null,null,null,null,null,null,"Renee Reid",24817,1700.0000000000002]
[0.83549999999999991,2.9,null,{"$f":"INDEX($A$35:$B$69,ROWS($D46:$D$69),COLUMNS($D46:D46))","v":0.72149999999999992},{"$f":"INDEX($A$35:$B$69,ROWS($D46:$D$69),COLUMNS($D46:E46))","v":1.7},null,null,null,null,null,null,"Maurice Gardner",24509,1700.0000000000002]
[0.82599999999999996,2.8,null,{"$f":"INDEX($A$35:$B$69,ROWS($D47:$D$69),COLUMNS($D47:D47))","v":0.73099999999999998},{"$f":"INDEX($A$35:$B$69,ROWS($D47:$D$69),COLUMNS($D47:E47))","v":1.8},null,null,null,null,null,null,"Juanita Kelley",15938,975]
[0.8165,2.7,null,{"$f":"INDEX($A$35:$B$69,ROWS($D48:$D$69),COLUMNS($D48:D48))","v":0.74049999999999994},{"$f":"INDEX($A$35:$B$69,ROWS($D48:$D$69),COLUMNS($D48:E48))","v":1.9},null,null,null,null,null,null,"Lynne Joseph",27338,1700.0000000000002]
[0.80699999999999994,2.6,null,{"$f":"INDEX($A$35:$B$69,ROWS($D49:$D$69),COLUMNS($D49:D49))","v":0.75},{"$f":"INDEX($A$35:$B$69,ROWS($D49:$D$69),COLUMNS($D49:E49))","v":2},null,null,null,null,null,null,"Frederick Cohen",28257,1700.0000000000002]
[0.79749999999999999,2.5,null,{"$f":"INDEX($A$35:$B$69,ROWS($D50:$D$69),COLUMNS($D50:D50))","v":0.75949999999999995},{"$f":"INDEX($A$35:$B$69,ROWS($D50:$D$69),COLUMNS($D50:E50))","v":2.1},null,null,null,null,null,null,"Kent Spencer",21829,1700.0000000000002]
[0.78799999999999992,2.4,null,{"$f":"INDEX($A$35:$B$69,ROWS($D51:$D$69),COLUMNS($D51:D51))","v":0.76899999999999991},{"$f":"INDEX($A$35:$B$69,ROWS($D51:$D$69),COLUMNS($D51:E51))","v":2.2000000000000002},null,null,null,null,null,null,"Scott Roberts",13999,625]
[0.77849999999999997,2.2999999999999998,null,{"$f":"INDEX($A$35:$B$69,ROWS($D52:$D$69),COLUMNS($D52:D52))","v":0.77849999999999997},{"$f":"INDEX($A$35:$B$69,ROWS($D52:$D$69),COLUMNS($D52:E52))","v":2.2999999999999998},null,null,null,null,null,null,"Hannah Love",22301,1700.0000000000002]
[0.76899999999999991,2.2000000000000002,null,{"$f":"INDEX($A$35:$B$69,ROWS($D53:$D$69),COLUMNS($D53:D53))","v":0.78799999999999992},{"$f":"INDEX($A$35:$B$69,ROWS($D53:$D$69),COLUMNS($D53:E53))","v":2.4},null,null,null,null,null,null,"Rafael Mckenzie",3969,0]
[0.75949999999999995,2.1,null,{"$f":"INDEX($A$35:$B$69,ROWS($D54:$D$69),COLUMNS($D54:D54))","v":0.79749999999999999},{"$f":"INDEX($A$35:$B$69,ROWS($D54:$D$69),COLUMNS($D54:E54))","v":2.5},null,null,null,null,null,null,"Rosie Vega",12072,200]
[0.75,2,null,{"$f":"INDEX($A$35:$B$69,ROWS($D55:$D$69),COLUMNS($D55:D55))","v":0.80699999999999994},{"$f":"INDEX($A$35:$B$69,ROWS($D55:$D$69),COLUMNS($D55:E55))","v":2.6},null,null,null,null,null,null,"Ryan Phillips",16733,975]
[0.74049999999999994,1.9,null,{"$f":"INDEX($A$35:$B$69,ROWS($D56:$D$69),COLUMNS($D56:D56))","v":0.8165},{"$f":"INDEX($A$35:$B$69,ROWS($D56:$D$69),COLUMNS($D56:E56))","v":2.7},null,null,null,null,null,null,"Lorene Thompson",32260,1700.0000000000002]
[0.73099999999999998,1.8,null,{"$f":"INDEX($A$35:$B$69,ROWS($D57:$D$69),COLUMNS($D57:D57))","v":0.82599999999999996},{"$f":"INDEX($A$35:$B$69,ROWS($D57:$D$69),COLUMNS($D57:E57))","v":2.8},null,null,null,null,null,null,"Nellie Freeman",16905,975]
[0.72149999999999992,1.7,null,{"$f":"INDEX($A$35:$B$69,ROWS($D58:$D$69),COLUMNS($D58:D58))","v":0.83549999999999991},{"$f":"INDEX($A$35:$B$69,ROWS($D58:$D$69),COLUMNS($D58:E58))","v":2.9},null,null,null,null,null,null,"Elvira Cannon",31439,1700.0000000000002]
[0.71199999999999997,1.6,null,{"$f":"INDEX($A$35:$B$69,ROWS($D59:$D$69),COLUMNS($D59:D59))","v":0.84499999999999997},{"$f":"INDEX($A$35:$B$69,ROWS($D59:$D$69),COLUMNS($D59:E59))","v":3},null,null,null,null,null,null,"Kerry Norris",34687,1700.0000000000002]
[0.7024999999999999,1.5,null,{"$f":"INDEX($A$35:$B$69,ROWS($D60:$D$69),COLUMNS($D60:D60))","v":0.85449999999999993},{"$f":"INDEX($A$35:$B$69,ROWS($D60:$D$69),COLUMNS($D60:E60))","v":3.1},null,null,null,null,null,null,"Rosalie Nunez",26559,1700.0000000000002]
[0.69299999999999995,1.4,null,{"$f":"INDEX($A$35:$B$69,ROWS($D61:$D$69),COLUMNS($D61:D61))","v":0.86399999999999999},{"$f":"INDEX($A$35:$B$69,ROWS($D61:$D$69),COLUMNS($D61:E61))","v":3.2},null,null,null,null,null,null,"Elias Lloyd",34179,1700.0000000000002]
[0.6835,1.3,null,{"$f":"INDEX($A$35:$B$69,ROWS($D62:$D$69),COLUMNS($D62:D62))","v":0.87349999999999994},{"$f":"INDEX($A$35:$B$69,ROWS($D62:$D$69),COLUMNS($D62:E62))","v":3.3},null,null,null,null,null,null,"Mona Tate",7654,200]
[0.67399999999999993,1.2,null,{"$f":"INDEX($A$35:$B$69,ROWS($D63:$D$69),COLUMNS($D63:D63))","v":0.88300000000000001},{"$f":"INDEX($A$35:$B$69,ROWS($D63:$D$69),COLUMNS($D63:E63))","v":3.4},null,null,null,null,null,null,"Blanca Terry",24034,1700.0000000000002]
[0.66449999999999998,1.1000000000000001,null,{"$f":"INDEX($A$35:$B$69,ROWS($D64:$D$69),COLUMNS($D64:D64))","v":0.89249999999999996},{"$f":"INDEX($A$35:$B$69,ROWS($D64:$D$69),COLUMNS($D64:E64))","v":3.5},null,null,null,null,null,null,"Kyle Reyes",14395,625]
[0.65500000000000003,1,null,{"$f":"INDEX($A$35:$B$69,ROWS($D65:$D$69),COLUMNS($D65:D65))","v":0.90199999999999991},{"$f":"INDEX($A$35:$B$69,ROWS($D65:$D$69),COLUMNS($D65:E65))","v":3.6},null,null,null,null,null,null,"Delores Coleman",33789,1700.0000000000002]
[0.64549999999999996,0.9,null,{"$f":"INDEX($A$35:$B$69,ROWS($D66:$D$69),COLUMNS($D66:D66))","v":0.91149999999999998},{"$f":"INDEX($A$35:$B$69,ROWS($D66:$D$69),COLUMNS($D66:E66))","v":3.7},null,null,null,null,null,null,"Amanda Black",2856,0]
[0.6359999999999999,0.80000000000000104,null,{"$f":"INDEX($A$35:$B$69,ROWS($D67:$D$69),COLUMNS($D67:D67))","v":0.92099999999999993},{"$f":"INDEX($A$35:$B$69,ROWS($D67:$D$69),COLUMNS($D67:E67))","v":3.8},null,null,null,null,null,null,"Grant Gibbs",29477,1700.0000000000002]
[0.62649999999999995,0.70000000000000095,null,{"$f":"INDEX($A$35:$B$69,ROWS($D68:$D$69),COLUMNS($D68:D68))","v":0.93049999999999999},{"$f":"INDEX($A$35:$B$69,ROWS($D68:$D$69),COLUMNS($D68:E68))","v":3.9},null,null,null,null,null,null,"Emily Carr",31158,1700.0000000000002]
[0,0,null,{"$f":"INDEX($A$35:$B$69,ROWS($D69:$D$69),COLUMNS($D69:D69))","v":0.94},{"$f":"INDEX($A$35:$B$69,ROWS($D69:$D$69),COLUMNS($D69:E69))","v":4},null,null,null,null,null,null,"Lee Ruiz",3350,0]
[null,null,null,null,null,null,null,null,null,null,null,"Eloise Beck",22735,1700.0000000000002]
[null,null,null,null,null,null,null,null,null,null,null,"Norman Sanders",8853,200]
[null,null,null,null,null,null,null,null,null,null,null,"Glenda Page",14882,625]
[null,null,null,null,null,null,null,null,null,null,null,"Ian Neal",6835,200]
[null,null,null,null,null,null,null,null,null,null,null,"Mae Sparks",10569,{"$f":"VLOOKUP(M74,$I$9:$J$13,2,TRUE)","v":200}]
[null,null,null,null,null,null,null,null,null,null,null,"Tricia Curtis",17916,975]
[null,null,null,null,null,null,null,null,null,null,null,"Howard Wilkerson",3846,0]
[null,null,null,null,null,null,null,null,null,null,null,"Cary Stephens",26659,1700.0000000000002]
[null,null,null,null,null,null,null,null,null,null,null,"Jeanne Boyd",23916,1700.0000000000002]
[null,null,null,null,null,null,null,null,null,null,null,"Terrell Walsh",12124,200]
[null,null,null,null,null,null,null,null,null,null,null,"Javier Bennett",19504,975]
[null,null,null,null,null,null,null,null,null,null,null,"Jonathon Manning",30158,1700.0000000000002]
[null,null,null,null,null,null,null,null,null,null,null,"Myra Hubbard",15801,975]
[null,null,null,null,null,null,null,null,null,null,null,"Lucille Graham",1586,0]
[null,null,null,null,null,null,null,null,null,null,null,"Craig Bryant",27113,1700.0000000000002]
[null,null,null,null,null,null,null,null,null,null,null,"Krystal Wagner",32183,1700.0000000000002]
[null,null,null,null,null,null,null,null,null,null,null,"Katrina Carter",11047,200]
[null,null,null,null,null,null,null,null,null,null,null,"Sergio Lucas",34753,1700.0000000000002]
[null,null,null,null,null,null,null,null,null,null,null,"Joyce Taylor",12187,200]
[null,null,null,null,null,null,null,null,null,null,null,"Marta Watts",17897,975]
[null,null,null,null,null,null,null,null,null,null,null,"Candace Holloway",10202,200]
[null,null,null,null,null,null,null,null,null,null,null,"Gwen James",27823,1700.0000000000002]
[null,null,null,null,null,null,null,null,null,null,null,"Lela Snyder",1352,0]
[null,null,null,null,null,null,null,null,null,null,null,"Louise Mathis",5515,200]
[null,null,null,null,null,null,null,null,null,null,null,"Maxine Miller",15066,975]
[null,null,null,null,null,null,null,null,null,null,null,"Omar Gonzales",8636,200]
[null,null,null,null,null,null,null,null,null,null,null,"Loren Delgado",2377,0]
[null,null,null,null,null,null,null,null,null,null,null,"Brandi Shelton",20270,1700.0000000000002]
[null,null,null,null,null,null,null,null,null,null,null,"Jimmie Walters",2893,0]
[null,null,null,null,null,null,null,null,null,null,null,"Gilberto Robbins",26703,1700.0000000000002]
[null,null,null,null,null,null,null,null,null,null,null,"Dianne Pearson",14065,625]
[null,null,null,null,null,null,null,null,null,null,null,"Derek Clayton",28685,1700.0000000000002]
[null,null,null,null,null,null,null,null,null,null,null,"Jon Robinson",5415,200]
[null,null,null,null,null,null,null,null,null,null,null,"Silvia Johnston",13310,625]
[null,null,null,null,null,null,null,null,null,null,null,"Denise Morris",527,0]
[null,null,null,null,null,null,null,null,null,null,null,"Orlando Vasquez",24990,1700.0000000000002]
[null,null,null,null,null,null,null,null,null,null,null,"Cindy Chavez",30968,1700.0000000000002]
[null,null,null,null,null,null,null,null,null,null,null,"Andrea Day",12466,200]
[null,null,null,null,null,null,null,null,null,null,null,"Vincent Summers",3791,0]

{"sheet":"V(4)","index":14,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Description for learning:",null,"Category Label for learning:",null,"Your Sales","Commission"]
[{"$f":"DOLLAR(E2,0)&\" or more, all the way up to, but not including \"&DOLLAR(E3,0)","v":"$0 or more, all the way up to, but not including $5,000"},null,{"$f":"DOLLAR(E2,0)&\" <= \"&E$1&\" < \"&DOLLAR(E3,0)","v":"$0 <= Your Sales < $5,000"},null,0,0]
[{"$f":"DOLLAR(E3,0)&\" or more, all the way up to, but not including \"&DOLLAR(E4,0)","v":"$5,000 or more, all the way up to, but not including $12,500"},null,{"$f":"DOLLAR(E3,0)&\" <= \"&E$1&\" < \"&DOLLAR(E4,0)","v":"$5,000 <= Your Sales < $12,500"},null,5000,200]
["$12,500 or more, all the way up to, but not including $15,000",null,"$12,500 <= Your Sales < $15,000",null,12500,625]
["$15,000 or more, all the way up to, but not including $20,000",null,"$15,000 <= Your Sales < $20,000",null,15000,975]
[{"$f":"\"Bigger than or equal to \"&DOLLAR(E6,0)","v":"Bigger than or equal to $20,000"},null,{"$f":"DOLLAR(E6,0)&\" <= \"&E1","v":"$20,000 <= Your Sales"},null,20000,1700.0000000000002]
[]
[null,null,null,null,"Your Sales","Commission"]
[null,null,null,null,7500,{"$f":"VLOOKUP(E9,E2:F6,2)","v":200}]

{"sheet":"V(4an)","index":15,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Description for learning:",null,"Category Label for learning:",null,"Your Sales","Commission"]
[{"$f":"DOLLAR(E2,0)&\" or more, all the way up to, but not including \"&DOLLAR(E3,0)","v":"$0 or more, all the way up to, but not including $5,000"},null,{"$f":"DOLLAR(E2,0)&\" <= \"&E$1&\" < \"&DOLLAR(E3,0)","v":"$0 <= Your Sales < $5,000"},null,0,0]
[{"$f":"DOLLAR(E3,0)&\" or more, all the way up to, but not including \"&DOLLAR(E4,0)","v":"$5,000 or more, all the way up to, but not including $12,500"},null,{"$f":"DOLLAR(E3,0)&\" <= \"&E$1&\" < \"&DOLLAR(E4,0)","v":"$5,000 <= Your Sales < $12,500"},null,5000,200]
["$12,500 or more, all the way up to, but not including $15,000",null,"$12,500 <= Your Sales < $15,000",null,12500,625]
["$15,000 or more, all the way up to, but not including $20,000",null,"$15,000 <= Your Sales < $20,000",null,15000,975]
[{"$f":"\"Bigger than or equal to \"&DOLLAR(E6,0)","v":"Bigger than or equal to $20,000"},null,{"$f":"DOLLAR(E6,0)&\" <= \"&E1","v":"$20,000 <= Your Sales"},null,20000,1700.0000000000002]
[]
[null,null,null,null,"Your Sales","Commission"]
[null,null,null,null,7500,{"$f":"VLOOKUP(E9,E2:F6,2)","v":200}]

{"sheet":"V(5)","index":16,"n_rows":113,"n_cols":9,"rows_kept":113,"cut":false,"hidden":false,"merged":[]}
["Date","Product","Region","SalesRep","Customer","Units","COGS","Sales","Sales Category"]
["2011-01-26","Bellen","West","Pham","FRED",7,70,154]
["2011-01-10","Bellen","MidWest","Gault","FM",61,610,1342]
["2011-01-03","Sunshine","South","Sioux","DDH",6,48,114]
["2011-01-07","Sunset","West","Pham","T",61,564.25,1281]
["2011-01-18","Sunshine","West","Sioux","AST",8,64,152]
["2011-01-20","Carlota","East","Chin","ET",59,649,1357]
["2011-01-26","Bellen","MidWest","Gault","PSA",21,210,462]
["2011-01-07","Carlota","MidWest","Franks","HHH",12,132,276]
["2011-01-05","Carlota","West","Franks","ITTW",60,660,1380]
["2011-01-17","Quad","East","Franks","HII",62,899,1674]
["2011-01-28","Sunshine","South","Smith","FRED",51,408,969]
["2011-01-17","Quad","East","Gault","SFWK",43,623.5,1161]
["2011-01-16","Bellen","MidWest","Sioux","YTR",56,560,1232]
["2011-01-15","Sunshine","MidWest","Chin","YTR",11,88,209]
["2011-01-12","Bellen","South","Chin","WT",7,70,154]
["2011-01-03","Sunset","South","Pham","WSD",23,212.75,483]
["2011-01-22","Carlota","South","Smith","KBTB",29,319,667]
["2011-01-21","Quad","West","Gault","ITW",56,812,1512]
["2011-01-13","Sunshine","MidWest","Pham","PSA",33,264,627]
["2011-01-10","Quad","West","Smith","KBTB",65,942.5,1755]
["2011-01-08","Quad","West","Chin","HII",16,232,432]
["2011-01-06","Quad","West","Sioux","PCC",64,928,1728]
["2011-01-26","Sunset","South","Sioux","DFGH",44,407,924]
["2011-01-21","Sunshine","MidWest","Smith","QT",64,512,1216]
["2011-01-07","Bellen","West","Smith","T",27,270,594]
["2011-01-20","Bellen","East","Gault","PSA",10,100,220]
["2011-01-09","Bellen","South","Chin","WSD",26,260,572]
["2011-01-07","Sunset","MidWest","Smith","PCC",22,203.5,462]
["2011-01-29","Bellen","East","Chin","AST",50,500,1100]
["2011-01-30","Sunshine","South","Sioux","TTT",23,184,437]
["2011-01-30","Sunshine","West","Gault","DFR",49,392,931]
["2011-01-28","Carlota","West","Smith","LOP",15,165,345]
["2011-01-01","Quad","East","Sioux","AA",16,232,432]
["2011-01-30","Quad","South","Sioux","TTT",25,362.5,675]
["2011-01-16","Carlota","South","Smith","QT",31,341,713]
["2011-01-24","Quad","West","Gault","HII",63,913.5,1701]
["2011-01-25","Sunshine","MidWest","Franks","JAQ",21,168,399]
["2011-01-21","Sunshine","MidWest","Pham","DFR",23,184,437]
["2011-01-18","Bellen","East","Pham","DFR",59,590,1298]
["2011-01-13","Bellen","MidWest","Pham","PLOT",57,570,1254]
["2011-01-21","Quad","East","Chin","FM",58,841,1566]
["2011-01-09","Sunshine","East","Smith","PCC",42,336,798]
["2011-01-09","Bellen","South","Sioux","QT",15,150,330]
["2011-01-27","Carlota","West","Gault","QT",10,110,230]
["2011-01-06","Carlota","West","Sioux","KPSA",18,198,414]
["2011-01-10","Sunset","East","Gault","TRU",27,249.75,567]
["2011-01-21","Sunset","South","Pham","HHH",13,120.25,273]
["2011-01-22","Bellen","West","Sioux","YTR",35,350,770]
["2011-01-03","Sunshine","East","Pham","FM",38,304,722]
["2011-01-10","Carlota","East","Pham","AA",63,693,1449]
["2011-01-22","Quad","South","Franks","FM",29,420.5,783]
["2011-01-28","Sunset","East","Smith","ZAT",36,333,756]
["2011-01-10","Quad","East","Smith","DFR",17,246.5,459]
["2011-01-17","Bellen","MidWest","Smith","PCC",16,160,352]
["2011-01-20","Sunshine","West","Sioux","YTR",58,464,1102]
["2011-01-18","Bellen","East","Franks","DFGH",20,200,440]
["2011-01-13","Bellen","MidWest","Pham","PSA",40,400,880]
["2011-01-14","Carlota","East","Franks","JAQ",34,374,782]
["2011-01-17","Quad","MidWest","Chin","EPP",61,884.5,1647]
["2011-01-12","Sunset","MidWest","Gault","ITW",19,175.75,399]
["2011-01-06","Sunshine","South","Smith","QT",40,320,760]
["2011-01-19","Bellen","South","Sioux","T",35,350,770]
["2011-01-26","Bellen","East","Chin","KPSA",17,170,374]
["2011-01-05","Sunset","South","Pham","TTT",57,527.25,1197]
["2011-01-28","Carlota","South","Franks","MNGD",46,506,1058]
["2011-01-10","Sunshine","South","Chin","TRU",30,240,570]
["2011-01-07","Sunset","West","Pham","WT",53,490.25,1113]
["2011-01-28","Quad","MidWest","Smith","YTR",42,609,1134]
["2011-01-02","Quad","West","Pham","AST",30,435,810]
["2011-01-15","Sunset","East","Gault","AST",63,582.75,1323]
["2011-01-10","Sunset","East","Smith","MBG",17,157.25,357]
["2011-01-23","Quad","East","Pham","WT",22,319,594]
["2011-01-06","Sunshine","East","Franks","PSA",54,432,1026]
["2011-01-18","Carlota","South","Smith","YTR",53,583,1219]
["2011-01-11","Quad","East","Smith","BBT",49,710.5,1323]
["2011-01-21","Bellen","South","Smith","TRU",11,110,242]
["2011-01-18","Sunset","East","Gault","MNGD",12,111,252]
["2011-01-10","Sunshine","MidWest","Smith","TTT",8,64,152]
["2011-01-17","Sunshine","MidWest","Franks","HHH",59,472,1121]
["2011-01-23","Sunshine","South","Chin","T",49,392,931]
["2011-01-23","Quad","East","Franks","PCC",44,638,1188]
["2011-01-28","Sunset","West","Chin","FM",62,573.5,1302]
["2011-01-29","Quad","MidWest","Gault","PLOT",10,145,270]
["2011-01-13","Carlota","South","Smith","FM",52,572,1196]
["2011-01-18","Quad","MidWest","Smith","PLOT",17,246.5,459]
["2011-01-04","Sunset","MidWest","Sioux","BBT",29,268.25,609]
["2011-01-28","Bellen","South","Sioux","QT",25,250,550]
["2011-01-11","Quad","East","Franks","ITW",14,203,378]
["2011-01-22","Bellen","West","Pham","AST",53,530,1166]
["2011-01-10","Sunset","South","Sioux","MBG",47,434.75,987]
["2011-01-24","Carlota","MidWest","Franks","BBT",13,143,299]
["2011-01-05","Sunshine","West","Franks","ET",12,96,228]
["2011-01-03","Carlota","MidWest","Chin","FM",20,220,460]
["2011-01-09","Bellen","East","Pham","EPP",40,400,880]
["2011-01-23","Bellen","East","Gault","DFGH",9,90,198]
["2011-01-09","Carlota","East","Franks","WSD",38,418,874]
["2011-01-02","Bellen","South","Gault","KBTB",24,240,528]
["2011-01-17","Quad","West","Chin","TTT",10,145,270]
["2011-01-28","Quad","South","Gault","KBTB",56,812,1512]
["2011-01-18","Sunshine","MidWest","Chin","LOP",62,496,1178]
["2011-01-28","Quad","South","Franks","YTR",44,638,1188]
["2011-01-17","Carlota","East","Sioux","GRR",39,429,897]
["2011-01-18","Sunshine","East","Franks","AA",24,192,456]
["2011-01-22","Bellen","West","Smith","WT",6,60,132]
["2011-01-02","Bellen","West","Pham","SFWK",19,190,418]
[]
[null,null,null,null,null,null,null,"Category Lower Limit","Sales Category"]
[null,null,null,null,null,null,null,0,"Subpar"]
[null,null,null,null,null,null,null,100,"OK"]
[null,null,null,null,null,null,null,500,"Good"]
[null,null,null,null,null,null,null,750,"Great"]
[null,null,null,null,null,null,null,1000,"Exceptional"]

{"sheet":"V(5an)","index":17,"n_rows":113,"n_cols":9,"rows_kept":113,"cut":false,"hidden":false,"merged":[]}
["Date","Product","Region","SalesRep","Customer","Units","COGS","Sales","Sales Category"]
["2011-01-26","Bellen","West","Pham","FRED",7,70,154,{"$f":"VLOOKUP(H2,$H$109:$I$113,2)","v":"OK"}]
["2011-01-10","Bellen","MidWest","Gault","FM",61,610,1342,{"$f":"VLOOKUP(H3,$H$109:$I$113,2)","v":"Exceptional"}]
["2011-01-03","Sunshine","South","Sioux","DDH",6,48,114,"OK"]
["2011-01-07","Sunset","West","Pham","T",61,564.25,1281,"Exceptional"]
["2011-01-18","Sunshine","West","Sioux","AST",8,64,152,"OK"]
["2011-01-20","Carlota","East","Chin","ET",59,649,1357,"Exceptional"]
["2011-01-26","Bellen","MidWest","Gault","PSA",21,210,462,"OK"]
["2011-01-07","Carlota","MidWest","Franks","HHH",12,132,276,"OK"]
["2011-01-05","Carlota","West","Franks","ITTW",60,660,1380,"Exceptional"]
["2011-01-17","Quad","East","Franks","HII",62,899,1674,"Exceptional"]
["2011-01-28","Sunshine","South","Smith","FRED",51,408,969,"Great"]
["2011-01-17","Quad","East","Gault","SFWK",43,623.5,1161,"Exceptional"]
["2011-01-16","Bellen","MidWest","Sioux","YTR",56,560,1232,"Exceptional"]
["2011-01-15","Sunshine","MidWest","Chin","YTR",11,88,209,"OK"]
["2011-01-12","Bellen","South","Chin","WT",7,70,154,"OK"]
["2011-01-03","Sunset","South","Pham","WSD",23,212.75,483,"OK"]
["2011-01-22","Carlota","South","Smith","KBTB",29,319,667,"Good"]
["2011-01-21","Quad","West","Gault","ITW",56,812,1512,"Exceptional"]
["2011-01-13","Sunshine","MidWest","Pham","PSA",33,264,627,"Good"]
["2011-01-10","Quad","West","Smith","KBTB",65,942.5,1755,"Exceptional"]
["2011-01-08","Quad","West","Chin","HII",16,232,432,"OK"]
["2011-01-06","Quad","West","Sioux","PCC",64,928,1728,"Exceptional"]
["2011-01-26","Sunset","South","Sioux","DFGH",44,407,924,"Great"]
["2011-01-21","Sunshine","MidWest","Smith","QT",64,512,1216,"Exceptional"]
["2011-01-07","Bellen","West","Smith","T",27,270,594,"Good"]
["2011-01-20","Bellen","East","Gault","PSA",10,100,220,"OK"]
["2011-01-09","Bellen","South","Chin","WSD",26,260,572,"Good"]
["2011-01-07","Sunset","MidWest","Smith","PCC",22,203.5,462,"OK"]
["2011-01-29","Bellen","East","Chin","AST",50,500,1100,"Exceptional"]
["2011-01-30","Sunshine","South","Sioux","TTT",23,184,437,"OK"]
["2011-01-30","Sunshine","West","Gault","DFR",49,392,931,"Great"]
["2011-01-28","Carlota","West","Smith","LOP",15,165,345,"OK"]
["2011-01-01","Quad","East","Sioux","AA",16,232,432,"OK"]
["2011-01-30","Quad","South","Sioux","TTT",25,362.5,675,"Good"]
["2011-01-16","Carlota","South","Smith","QT",31,341,713,"Good"]
["2011-01-24","Quad","West","Gault","HII",63,913.5,1701,"Exceptional"]
["2011-01-25","Sunshine","MidWest","Franks","JAQ",21,168,399,"OK"]
["2011-01-21","Sunshine","MidWest","Pham","DFR",23,184,437,"OK"]
["2011-01-18","Bellen","East","Pham","DFR",59,590,1298,"Exceptional"]
["2011-01-13","Bellen","MidWest","Pham","PLOT",57,570,1254,"Exceptional"]
["2011-01-21","Quad","East","Chin","FM",58,841,1566,"Exceptional"]
["2011-01-09","Sunshine","East","Smith","PCC",42,336,798,"Great"]
["2011-01-09","Bellen","South","Sioux","QT",15,150,330,"OK"]
["2011-01-27","Carlota","West","Gault","QT",10,110,230,"OK"]
["2011-01-06","Carlota","West","Sioux","KPSA",18,198,414,"OK"]
["2011-01-10","Sunset","East","Gault","TRU",27,249.75,567,"Good"]
["2011-01-21","Sunset","South","Pham","HHH",13,120.25,273,"OK"]
["2011-01-22","Bellen","West","Sioux","YTR",35,350,770,"Great"]
["2011-01-03","Sunshine","East","Pham","FM",38,304,722,"Good"]
["2011-01-10","Carlota","East","Pham","AA",63,693,1449,"Exceptional"]
["2011-01-22","Quad","South","Franks","FM",29,420.5,783,"Great"]
["2011-01-28","Sunset","East","Smith","ZAT",36,333,756,"Great"]
["2011-01-10","Quad","East","Smith","DFR",17,246.5,459,"OK"]
["2011-01-17","Bellen","MidWest","Smith","PCC",16,160,352,"OK"]
["2011-01-20","Sunshine","West","Sioux","YTR",58,464,1102,"Exceptional"]
["2011-01-18","Bellen","East","Franks","DFGH",20,200,440,"OK"]
["2011-01-13","Bellen","MidWest","Pham","PSA",40,400,880,"Great"]
["2011-01-14","Carlota","East","Franks","JAQ",34,374,782,"Great"]
["2011-01-17","Quad","MidWest","Chin","EPP",61,884.5,1647,"Exceptional"]
["2011-01-12","Sunset","MidWest","Gault","ITW",19,175.75,399,"OK"]
["2011-01-06","Sunshine","South","Smith","QT",40,320,760,"Great"]
["2011-01-19","Bellen","South","Sioux","T",35,350,770,"Great"]
["2011-01-26","Bellen","East","Chin","KPSA",17,170,374,"OK"]
["2011-01-05","Sunset","South","Pham","TTT",57,527.25,1197,"Exceptional"]
["2011-01-28","Carlota","South","Franks","MNGD",46,506,1058,"Exceptional"]
["2011-01-10","Sunshine","South","Chin","TRU",30,240,570,{"$f":"VLOOKUP(H67,$H$109:$I$113,2)","v":"Good"}]
["2011-01-07","Sunset","West","Pham","WT",53,490.25,1113,"Exceptional"]
["2011-01-28","Quad","MidWest","Smith","YTR",42,609,1134,"Exceptional"]
["2011-01-02","Quad","West","Pham","AST",30,435,810,"Great"]
["2011-01-15","Sunset","East","Gault","AST",63,582.75,1323,"Exceptional"]
["2011-01-10","Sunset","East","Smith","MBG",17,157.25,357,"OK"]
["2011-01-23","Quad","East","Pham","WT",22,319,594,"Good"]
["2011-01-06","Sunshine","East","Franks","PSA",54,432,1026,"Exceptional"]
["2011-01-18","Carlota","South","Smith","YTR",53,583,1219,"Exceptional"]
["2011-01-11","Quad","East","Smith","BBT",49,710.5,1323,"Exceptional"]
["2011-01-21","Bellen","South","Smith","TRU",11,110,242,"OK"]
["2011-01-18","Sunset","East","Gault","MNGD",12,111,252,"OK"]
["2011-01-10","Sunshine","MidWest","Smith","TTT",8,64,152,"OK"]
["2011-01-17","Sunshine","MidWest","Franks","HHH",59,472,1121,"Exceptional"]
["2011-01-23","Sunshine","South","Chin","T",49,392,931,"Great"]
["2011-01-23","Quad","East","Franks","PCC",44,638,1188,"Exceptional"]
["2011-01-28","Sunset","West","Chin","FM",62,573.5,1302,"Exceptional"]
["2011-01-29","Quad","MidWest","Gault","PLOT",10,145,270,"OK"]
["2011-01-13","Carlota","South","Smith","FM",52,572,1196,"Exceptional"]
["2011-01-18","Quad","MidWest","Smith","PLOT",17,246.5,459,"OK"]
["2011-01-04","Sunset","MidWest","Sioux","BBT",29,268.25,609,"Good"]
["2011-01-28","Bellen","South","Sioux","QT",25,250,550,"Good"]
["2011-01-11","Quad","East","Franks","ITW",14,203,378,"OK"]
["2011-01-22","Bellen","West","Pham","AST",53,530,1166,"Exceptional"]
["2011-01-10","Sunset","South","Sioux","MBG",47,434.75,987,"Great"]
["2011-01-24","Carlota","MidWest","Franks","BBT",13,143,299,"OK"]
["2011-01-05","Sunshine","West","Franks","ET",12,96,228,"OK"]
["2011-01-03","Carlota","MidWest","Chin","FM",20,220,460,"OK"]
["2011-01-09","Bellen","East","Pham","EPP",40,400,880,"Great"]
["2011-01-23","Bellen","East","Gault","DFGH",9,90,198,"OK"]
["2011-01-09","Carlota","East","Franks","WSD",38,418,874,"Great"]
["2011-01-02","Bellen","South","Gault","KBTB",24,240,528,"Good"]
["2011-01-17","Quad","West","Chin","TTT",10,145,270,"OK"]
["2011-01-28","Quad","South","Gault","KBTB",56,812,1512,"Exceptional"]
["2011-01-18","Sunshine","MidWest","Chin","LOP",62,496,1178,"Exceptional"]
["2011-01-28","Quad","South","Franks","YTR",44,638,1188,"Exceptional"]
["2011-01-17","Carlota","East","Sioux","GRR",39,429,897,"Great"]
["2011-01-18","Sunshine","East","Franks","AA",24,192,456,"OK"]
["2011-01-22","Bellen","West","Smith","WT",6,60,132,"OK"]
["2011-01-02","Bellen","West","Pham","SFWK",19,190,418,"OK"]
[]
[null,null,null,null,null,null,null,"Category Lower Limit","Sales Category"]
[null,null,null,null,null,null,null,0,"Subpar"]
[null,null,null,null,null,null,null,100,"OK"]
[null,null,null,null,null,null,null,500,"Good"]
[null,null,null,null,null,null,null,750,"Great"]
[null,null,null,null,null,null,null,1000,"Exceptional"]

{"sheet":"V(6)","index":18,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Product","Supplier","Price",null,"Product","Price"]
["Flying Eagle","Channel Craft",19]
["V Range","Colordao",18]
["Quad","Gel Boom",40]
["Bellen","Gel Boom",25]
["Carlota","Gel Boom",24]
[]
["Click on this link to see more about the VLOOKUP function:"]
["VLOOKUP Function Beginner to Advanced 26 Examples: How To Use Excel VLOOKUP Function "]
["http://www.youtube.com/watch?v=-hJxIMBbmZY"]

{"sheet":"V(6an)","index":19,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Product","Supplier","Price",null,"Product","Price"]
["Flying Eagle","Channel Craft",19,null,"Bellen",{"$f":"VLOOKUP(E2,A2:C6,3,0)","v":25}]
["V Range","Colordao",18]
["Quad","Gel Boom",40]
["Bellen","Gel Boom",25]
["Carlota","Gel Boom",24]
[]
["Click on this link to see more about the VLOOKUP function:"]
["VLOOKUP Function Beginner to Advanced 26 Examples: How To Use Excel VLOOKUP Function "]
["http://www.youtube.com/watch?v=-hJxIMBbmZY"]

{"sheet":"V(7)","index":20,"n_rows":64,"n_cols":4,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
["Invoice"]
["Fly High Boomerangs"]
[]
["Sell To:",null,"Invoice #",1255]
["Kite Flight",null,"Date","2013-11-11"]
["1414 43rd Ave."]
["Watermore"]
[]
["Item purchased","Quantity","Price Each","Line Item Total"]
["Quad",15]
["Majestic Beaut",10]
["Bellen",25]
[]
[]
[null,null,"Subtotal",{"$f":"SUM(D10:D14)","v":0}]
["Shipping Terms:","Shipping Point","Shipping",15]
["Terms:","2/15, 1/30, net 45","Invoice Total",{"$f":"SUM(D15:D16)","v":15}]
[]
["Boomerangs Available","Wholesale Cost"]
["Quad",{"$f":"C50","v":17.239999999999998}]
["Bellen",13.89]
["Carlota",9.8800000000000008]
["Carlota Doublers",29.09]
["Majestic Beaut",11.02]
["Sunshine 5 Ply",7.7]
["Sunshine 10 Ply",10.25]
["Sunset",11.75]
["Sunbell",14.55]
["Flattop",12.36]
["Bellen Dancer",14.08]
["Bellen Wind Dancer",15.16]
["GelFast",12.9]
["Phenolic Sunshine",15.62]
["Icarus MTA",18.68]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["List Price","Trade Discount %","Net Cost (Wholesale Cost)"]
[30.25,0.43,{"$f":"ROUND(A50*(1-B50),2)","v":17.239999999999998}]
[25.25,0.45,13.89]
[21.95,0.55000000000000004,9.8800000000000008]
[55.95,0.48,29.09]
[23.95,0.54,11.02]
[19.25,0.6,7.7]
[20.5,0.5,10.25]
[23.5,0.5,11.75]
[26.95,0.46,14.55]
[20.95,0.41,12.36]
[29.95,0.53,14.08]
[32.25,0.53,15.16]
[21.5,0.4,12.9]
[35.5,0.56000000000000005,15.62]
[35.25,0.47,18.68]

{"sheet":"V(7an)","index":21,"n_rows":64,"n_cols":8,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
["Invoice"]
["Fly High Boomerangs"]
[]
["Sell To:",null,"Invoice #",1255]
["Kite Flight",null,"Date","2013-11-11"]
["1414 43rd Ave."]
["Watermore"]
[]
["Item purchased","Quantity","Price Each","Line Item Total",null,null,"Price Each","Line Item Total"]
["Carlota",25,{"$f":"_xlfn.IFNA(VLOOKUP(A10,$A$20:$B$34,2,0),\"\")","v":9.8800000000000008},{"$f":"IFERROR(ROUND(C10*B10,2),\"\")","v":247},null,null,{"$f":"IF(ISNUMBER(B10),VLOOKUP(A10,$A$20:$B$34,2,0),\"\")","v":9.8800000000000008},{"$f":"IF(C10=\"\",\"\",ROUND(B10*C10,2))","v":247}]
[null,null,{"$f":"_xlfn.IFNA(VLOOKUP(A11,$A$20:$B$34,2,0),\"\")","v":""},{"$f":"IFERROR(ROUND(C11*B11,2),\"\")","v":""},null,null,{"$f":"IF(ISNUMBER(B11),VLOOKUP(A11,$A$20:$B$34,2,0),\"\")","v":""},{"$f":"IF(C11=\"\",\"\",ROUND(B11*C11,2))","v":""}]
[null,null,"","",null,"Earlier versions: >>>>>>>","",""]
[null,null,"","",null,null,"",""]
[null,null,"","",null,null,"",""]
[null,null,"Subtotal",{"$f":"SUM(D10:D14)","v":247}]
["Shipping Terms:","Shipping Point","Shipping",15]
["Terms:","2/15, 1/30, net 45","Invoice Total",{"$f":"SUM(D15:D16)","v":262}]
[]
["Boomerangs Available","Wholesale Cost"]
["Quad",{"$f":"C50","v":17.239999999999998}]
["Bellen",13.89]
["Carlota",9.8800000000000008]
["Carlota Doublers",29.09]
["Majestic Beaut",11.02]
["Sunshine 5 Ply",7.7]
["Sunshine 10 Ply",10.25]
["Sunset",11.75]
["Sunbell",14.55]
["Flattop",12.36]
["Bellen Dancer",14.08]
["Bellen Wind Dancer",15.16]
["GelFast",12.9]
["Phenolic Sunshine",15.62]
["Icarus MTA",18.68]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["List Price","Trade Discount %","Net Cost (Wholesale Cost)"]
[30.25,0.43,{"$f":"ROUND(A50*(1-B50),2)","v":17.239999999999998}]
[25.25,0.45,13.89]
[21.95,0.55000000000000004,9.8800000000000008]
[55.95,0.48,29.09]
[23.95,0.54,11.02]
[19.25,0.6,7.7]
[20.5,0.5,10.25]
[23.5,0.5,11.75]
[26.95,0.46,14.55]
[20.95,0.41,12.36]
[29.95,0.53,14.08]
[32.25,0.53,15.16]
[21.5,0.4,12.9]
[35.5,0.56000000000000005,15.62]
[35.25,0.47,18.68]

{"sheet":"HW(1)","index":22,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,null,"1) Using a formula for this column, assign a sales category to each employee.","2) Using a formula for this column, Put the word \"Yes\" or \"No\" in each cell to state whether or not the employee got the bonus","3) Using a formula for this column, put the bonus amount that each employee earned in each cell."]
[]
["Employee","Sales","Sales Category","Bonus Yes/No?","Bonus Amount",null,"Sales",{"$f":"C3","v":"Sales Category"}]
["Felipe Truscott",9181,null,null,null,null,0,"Poor"]
["Johnathan Godlewski",7827,null,null,null,null,7500,"Good"]
["Johnathan Iannone",6477,null,null,null,null,10000,"Great"]
["Cathrine Beaston",9358,null,null,null,null,12500,"Excellent"]
["Damon Czyz",14915]
["Rudolph Seabaugh",8670,null,null,null,null,"Bonus Hurdle",10000]
["Felipe Gramling",12413,null,null,null,null,"Bonus If Hurdle Surpassed",750]
["Kelvin Likes",6291]
["Rudolph Niewiadomski",6083]
["Alton Berrey",12633]
["Shanda Bovard",14428]
["Bennie Margulies",9192]
["Lashawn Vicks",6620]
["Daniela Vadenais",8246]
["Geoffrey Kennebeck",11769]
["Lyn Glade",11654]
["Shanda Lorentzen",6388]
["Valencia Tenpenny",6134]
["Bella Wohlenhaus",14715]
["Adelina Fontenette",5266]

{"sheet":"HW(1an)","index":23,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,null,"1) Using a formula for this column, assign a sales category to each employee.","2) Using a formula for this column, Put the word \"Yes\" or \"No\" in each cell to state whether or not the employee got the bonus","3) Using a formula for this column, put the bonus amount that each employee earned in each cell."]
[]
["Employee","Sales","Sales Category","Bonus Yes/No?","Bonus Amount",null,"Sales",{"$f":"C3","v":"Sales Category"}]
["Felipe Truscott",9181,{"$f":"VLOOKUP(B4,$G$4:$H$7,2)","v":"Good"},{"$f":"IF(B4>=H$9,\"Yes\",\"No\")","v":"No"},{"$f":"IF(B4>=H$9,H$10,0)","v":0},null,0,"Poor"]
["Johnathan Godlewski",7827,{"$f":"VLOOKUP(B5,$G$4:$H$7,2)","v":"Good"},{"$f":"IF(B5>=H$9,\"Yes\",\"No\")","v":"No"},{"$f":"IF(B5>=H$9,H$10,0)","v":0},null,7500,"Good"]
["Johnathan Iannone",6477,"Poor","No",0,null,10000,"Great"]
["Cathrine Beaston",9358,"Good","No",0,null,12500,"Excellent"]
["Damon Czyz",14915,"Excellent","Yes",750]
["Rudolph Seabaugh",8670,"Good","No",0,null,"Bonus Hurdle",10000]
["Felipe Gramling",12413,"Great","Yes",750,null,"Bonus If Hurdle Surpassed",750]
["Kelvin Likes",6291,"Poor","No",0]
["Rudolph Niewiadomski",6083,"Poor","No",0]
["Alton Berrey",12633,"Excellent","Yes",750]
["Shanda Bovard",14428,"Excellent","Yes",750]
["Bennie Margulies",9192,"Good","No",0]
["Lashawn Vicks",6620,"Poor","No",0]
["Daniela Vadenais",8246,"Good","No",0]
["Geoffrey Kennebeck",11769,"Great","Yes",750]
["Lyn Glade",11654,"Great","Yes",750]
["Shanda Lorentzen",6388,"Poor","No",0]
["Valencia Tenpenny",6134,"Poor","No",0]
["Bella Wohlenhaus",14715,"Excellent","Yes",750]
["Adelina Fontenette",5266,"Poor","No",0]

{"sheet":"HW(2)","index":24,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["In the Price Each column use the IF and VLOOKUP functions together to create formula that will lookup the price of the boomerang."]
["In the Line Item Total column, create a formula that will multiply Price Each times Quantity."]
["For both of these formulas, make sure that the formula shows nothing if the line in the invoice is not being used."]
[]
["Invoice",null,null,null,null,"Boomerangs Available","Supplier","Wholesale Cost"]
["Fly High Boomerangs",null,null,null,null,"Quad","Gel Booms",17.239999999999998]
[null,null,null,null,null,"Bellen","Gel Booms",13.89]
["Sell To:",null,"Invoice #",1256,null,"Aspen","Colorado Booms",9.8800000000000008]
["Top Ten Toys",null,"Date","2013-11-12",null,"Crested Beaut","Colorado Booms",11.02]
["North",null,null,null,null,"Sunset","Gel Booms",11.75]
["Seattle",null,null,null,null,"Sunbell","Gel Booms",14.55]
[]
["Item purchased","Quantity","Price Each","Line Item Total"]
["Sunset",5]
["Sunbell",6]
["Quad",15]
[]
[]
[null,null,"Subtotal",{"$f":"SUM(D14:D18)","v":0}]
["Shipping Terms:","Shipping Point","Shipping",15]
["Terms:","1/10, net 30","Invoice Total",{"$f":"SUM(D19:D20)","v":15}]

{"sheet":"HW(2an)","index":25,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["In the Price Each column use the IF and VLOOKUP functions together to create formula that will lookup the price of the boomerang."]
["In the Line Item Total column, create a formula that will multiply Price Each times Quantity."]
["For both of these formulas, make sure that the formula shows nothing if the line in the invoice is not being used."]
[]
["Invoice",null,null,null,null,"Boomerangs Available","Supplier","Wholesale Cost"]
["Fly High Boomerangs",null,null,null,null,"Quad","Gel Booms",17.239999999999998]
[null,null,null,null,null,"Bellen","Gel Booms",13.89]
["Sell To:",null,"Invoice #",1256,null,"Aspen","Colorado Booms",9.8800000000000008]
["Top Ten Toys",null,"Date","2013-11-12",null,"Crested Beaut","Colorado Booms",11.02]
["North",null,null,null,null,"Sunset","Gel Booms",11.75]
["Seattle",null,null,null,null,"Sunbell","Gel Booms",14.55]
[]
["Item purchased","Quantity","Price Each","Line Item Total",null,"Price Each","Line Item Total"]
["Sunset",5,{"$f":"_xlfn.IFNA(VLOOKUP(A14,$F$6:$H$11,3,0),\"\")","v":11.75},{"$f":"IFERROR(ROUND(B14*C14,2),\"\")","v":58.75},null,{"$f":"IF(ISNUMBER(B14),VLOOKUP(A14,$F$6:$H$11,3,0),\"\")","v":11.75},{"$f":"IF(B14=\"\",\"\",ROUND(C14*B14,2))","v":58.75}]
["Sunbell",6,{"$f":"_xlfn.IFNA(VLOOKUP(A15,$F$6:$H$11,3,0),\"\")","v":14.55},{"$f":"IFERROR(ROUND(B15*C15,2),\"\")","v":87.3},"Or >>",{"$f":"IF(ISNUMBER(B15),VLOOKUP(A15,$F$6:$H$11,3,0),\"\")","v":14.55},87.3]
["Quad",15,17.239999999999998,258.60000000000002,null,{"$f":"IF(ISNUMBER(B16),VLOOKUP(A16,$F$6:$H$11,3,0),\"\")","v":17.239999999999998},{"$f":"IF(B16=\"\",\"\",ROUND(C16*B16,2))","v":258.60000000000002}]
[null,null,"","",null,{"$f":"IF(ISNUMBER(B17),VLOOKUP(A17,$F$6:$H$11,3,0),\"\")","v":""},{"$f":"IF(B17=\"\",\"\",ROUND(C17*B17,2))","v":""}]
[null,null,"","",null,{"$f":"IF(ISNUMBER(B18),VLOOKUP(A18,$F$6:$H$11,3,0),\"\")","v":""},""]
[null,null,"Subtotal",{"$f":"SUM(G14:G18)","v":404.65000000000003}]
["Shipping Terms:","Shipping Point","Shipping",15]
["Terms:","1/10, net 30","Invoice Total",{"$f":"SUM(D19:D20)","v":419.65000000000003}]

{"sheet":"HW(3)","index":26,"n_rows":44,"n_cols":5,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["In Cell E5, create a formula that can lookup your grade."]
[]
[]
[null,null,null,"Your % Grade","Your Decimal Grade:"]
[null,null,null,0.89500000000000002]
[]
["How it apears in Syllabus:",null,null,"How it must be setup for VLOOKUP:"]
[]
["% Grade","Decimal Grade",null,"% Grade","Decimal Grade"]
[0.94,4,null,0,0]
[0.93049999999999999,3.9,null,0.62649999999999995,0.70000000000000095]
[0.92099999999999993,3.8,null,0.6359999999999999,0.80000000000000104]
[0.91149999999999998,3.7,null,0.64549999999999996,0.9]
[0.90199999999999991,3.6,null,0.65500000000000003,1]
[0.89249999999999996,3.5,null,0.66449999999999998,1.1000000000000001]
[0.88300000000000001,3.4,null,0.67399999999999993,1.2]
[0.87349999999999994,3.3,null,0.6835,1.3]
[0.86399999999999999,3.2,null,0.69299999999999995,1.4]
[0.85449999999999993,3.1,null,0.7024999999999999,1.5]
[0.84499999999999997,3,null,0.71199999999999997,1.6]
[0.83549999999999991,2.9,null,0.72149999999999992,1.7]
[0.82599999999999996,2.8,null,0.73099999999999998,1.8]
[0.8165,2.7,null,0.74049999999999994,1.9]
[0.80699999999999994,2.6,null,0.75,2]
[0.79749999999999999,2.5,null,0.75949999999999995,2.1]
[0.78799999999999992,2.4,null,0.76899999999999991,2.2000000000000002]
[0.77849999999999997,2.2999999999999998,null,0.77849999999999997,2.2999999999999998]
[0.76899999999999991,2.2000000000000002,null,0.78799999999999992,2.4]
[0.75949999999999995,2.1,null,0.79749999999999999,2.5]
[0.75,2,null,0.80699999999999994,2.6]
[0.74049999999999994,1.9,null,0.8165,2.7]
[0.73099999999999998,1.8,null,0.82599999999999996,2.8]
[0.72149999999999992,1.7,null,0.83549999999999991,2.9]
[0.71199999999999997,1.6,null,0.84499999999999997,3]
[0.7024999999999999,1.5,null,0.85449999999999993,3.1]
[0.69299999999999995,1.4,null,0.86399999999999999,3.2]
[0.6835,1.3,null,0.87349999999999994,3.3]
[0.67399999999999993,1.2,null,0.88300000000000001,3.4]
[0.66449999999999998,1.1000000000000001,null,0.89249999999999996,3.5]
[0.65500000000000003,1,null,0.90199999999999991,3.6]
[0.64549999999999996,0.9,null,0.91149999999999998,3.7]
[0.6359999999999999,0.80000000000000104,null,0.92099999999999993,3.8]
[0.62649999999999995,0.70000000000000095,null,0.93049999999999999,3.9]
[0,0,null,0.94,4]

{"sheet":"HW(3an)","index":27,"n_rows":44,"n_cols":5,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["In Cell E5, create a formula that can lookup your grade."]
[]
[]
[null,null,null,"Your % Grade","Your Decimal Grade:"]
[null,null,null,0.89500000000000002,{"$f":"VLOOKUP(D5,$D$10:$E$44,2)","v":3.5}]
[]
["How it apears in Syllabus:",null,null,"How it must be setup for VLOOKUP:"]
[]
["% Grade","Decimal Grade",null,"% Grade","Decimal Grade"]
[0.94,4,null,0,0]
[0.93049999999999999,3.9,null,0.62649999999999995,0.70000000000000095]
[0.92099999999999993,3.8,null,0.6359999999999999,0.80000000000000104]
[0.91149999999999998,3.7,null,0.64549999999999996,0.9]
[0.90199999999999991,3.6,null,0.65500000000000003,1]
[0.89249999999999996,3.5,null,0.66449999999999998,1.1000000000000001]
[0.88300000000000001,3.4,null,0.67399999999999993,1.2]
[0.87349999999999994,3.3,null,0.6835,1.3]
[0.86399999999999999,3.2,null,0.69299999999999995,1.4]
[0.85449999999999993,3.1,null,0.7024999999999999,1.5]
[0.84499999999999997,3,null,0.71199999999999997,1.6]
[0.83549999999999991,2.9,null,0.72149999999999992,1.7]
[0.82599999999999996,2.8,null,0.73099999999999998,1.8]
[0.8165,2.7,null,0.74049999999999994,1.9]
[0.80699999999999994,2.6,null,0.75,2]
[0.79749999999999999,2.5,null,0.75949999999999995,2.1]
[0.78799999999999992,2.4,null,0.76899999999999991,2.2000000000000002]
[0.77849999999999997,2.2999999999999998,null,0.77849999999999997,2.2999999999999998]
[0.76899999999999991,2.2000000000000002,null,0.78799999999999992,2.4]
[0.75949999999999995,2.1,null,0.79749999999999999,2.5]
[0.75,2,null,0.80699999999999994,2.6]
[0.74049999999999994,1.9,null,0.8165,2.7]
[0.73099999999999998,1.8,null,0.82599999999999996,2.8]
[0.72149999999999992,1.7,null,0.83549999999999991,2.9]
[0.71199999999999997,1.6,null,0.84499999999999997,3]
[0.7024999999999999,1.5,null,0.85449999999999993,3.1]
[0.69299999999999995,1.4,null,0.86399999999999999,3.2]
[0.6835,1.3,null,0.87349999999999994,3.3]
[0.67399999999999993,1.2,null,0.88300000000000001,3.4]
[0.66449999999999998,1.1000000000000001,null,0.89249999999999996,3.5]
[0.65500000000000003,1,null,0.90199999999999991,3.6]
[0.64549999999999996,0.9,null,0.91149999999999998,3.7]
[0.6359999999999999,0.80000000000000104,null,0.92099999999999993,3.8]
[0.62649999999999995,0.70000000000000095,null,0.93049999999999999,3.9]
[0,0,null,0.94,4]

{"sheet":"HW(4)","index":28,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["In cells A6 and A8 add Data Validation List to add a drop down for the ID."]
["In cells B6 and B8 create a formula that can lookup the ID and retrieve the Phone and First Name."]
[]
[]
["ID","Phone"]
[]
["ID","First"]
[]
[]
["ID","Last","First","E-mail","Phone"]
[{"$f":"\"880-\"&ROWS(A11:A$69)+9999","v":"880-10058"},"Leff","Julianne",{"$f":"B11&UPPER(LEFT(C11,1))&\"@PBY.com\"","v":"LeffJ@PBY.com"},"253-559-4034"]
[{"$f":"\"880-\"&ROWS(A12:A$69)+9999","v":"880-10057"},"Piano","Milagros",{"$f":"B12&UPPER(LEFT(C12,1))&\"@PBY.com\"","v":"PianoM@PBY.com"},"253-553-4381"]
[{"$f":"\"880-\"&ROWS(A13:A$69)+9999","v":"880-10056"},"Coller","Kathrine","CollerK@PBY.com","206-762-2195"]
[{"$f":"\"880-\"&ROWS(A14:A$69)+9999","v":"880-10055"},"Stackpole","Lonnie","StackpoleL@PBY.com","253-764-6538"]
[{"$f":"\"880-\"&ROWS(A15:A$69)+9999","v":"880-10054"},"Lintz","Kurt","LintzK@PBY.com","206-736-4510"]
[{"$f":"\"880-\"&ROWS(A16:A$69)+9999","v":"880-10053"},"Dudgeon","Penelope","DudgeonP@PBY.com","253-452-9723"]
[{"$f":"\"880-\"&ROWS(A17:A$69)+9999","v":"880-10052"},"Hughs","Pearlie","HughsP@PBY.com","253-719-7600"]

{"sheet":"HW(4an)","index":29,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["In cells A6 and A8 add Data Validation List to add a drop down for the ID."]
["In cells B6 and B8 create a formula that can lookup the ID and retrieve the Phone and First Name."]
[]
[]
["ID","Phone"]
["880-10057",{"$f":"VLOOKUP(A6,$A$11:$E$17,5,0)","v":"253-553-4381"}]
["ID","First"]
[{"$f":"A6","v":"880-10057"},{"$f":"VLOOKUP(A8,$A$11:$E$17,2,0)","v":"Piano"}]
[]
["ID","Last","First","E-mail","Phone"]
[{"$f":"\"880-\"&ROWS(A11:A$69)+9999","v":"880-10058"},"Leff","Julianne",{"$f":"B11&UPPER(LEFT(C11,1))&\"@PBY.com\"","v":"LeffJ@PBY.com"},"253-559-4034"]
[{"$f":"\"880-\"&ROWS(A12:A$69)+9999","v":"880-10057"},"Piano","Milagros",{"$f":"B12&UPPER(LEFT(C12,1))&\"@PBY.com\"","v":"PianoM@PBY.com"},"253-553-4381"]
[{"$f":"\"880-\"&ROWS(A13:A$69)+9999","v":"880-10056"},"Coller","Kathrine","CollerK@PBY.com","206-762-2195"]
[{"$f":"\"880-\"&ROWS(A14:A$69)+9999","v":"880-10055"},"Stackpole","Lonnie","StackpoleL@PBY.com","253-764-6538"]
[{"$f":"\"880-\"&ROWS(A15:A$69)+9999","v":"880-10054"},"Lintz","Kurt","LintzK@PBY.com","206-736-4510"]
[{"$f":"\"880-\"&ROWS(A16:A$69)+9999","v":"880-10053"},"Dudgeon","Penelope","DudgeonP@PBY.com","253-452-9723"]
[{"$f":"\"880-\"&ROWS(A17:A$69)+9999","v":"880-10052"},"Hughs","Pearlie","HughsP@PBY.com","253-719-7600"]