{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["IF(1)","IF(1an)","IF(2)","IF(2an)","V(1)","V(1an)","V(2)","V(2an)"],"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":"IF(1)","index":0,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Debit Numbers","Credit Numbers"]
["Bonus Amount",500,null,58,58]
["Bonus Hurdle",50000,null,30,30]
[null,null,null,43,43]
["Your Sales",50000,null,21,21]
["Do You Get Bonus?",null,null,12,12]
["Your Bonus",null,null,null,null,null,"In Balance?"]
[null,null,null,{"$f":"SUM(D2:D7)","v":164},{"$f":"SUM(E2:E7)","v":164}]
[]
[]
["Click on this link to see more about the IF function:"]
["Office 2010 Class #38: Excel IF Function Formula Made Easy (7 examples)"]

{"sheet":"IF(1an)","index":1,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Debit Numbers","Credit Numbers"]
["Bonus Amount",500,null,58,58]
["Bonus Hurdle",50000,null,30,30]
[null,null,null,43,43]
["Your Sales",50000,null,21,21]
["Do You Get Bonus?",{"$f":"B5>=B3","v":true},null,12,12]
["Your Bonus",{"$f":"IF(B5>=B3,B2,0)","v":500},null,null,null,null,"In Balance?"]
[null,null,null,{"$f":"SUM(D2:D7)","v":164},{"$f":"SUM(E2:E7)","v":164},null,{"$f":"D8=E8","v":true}]
[null,null,null,null,null,null,{"$f":"IF(D8=E8,\"In Balance\",\"Not In Balance\")","v":"In Balance"}]
[]
["Click on this link to see more about the IF function:"]
["Office 2010 Class #38: Excel IF Function Formula Made Easy (7 examples)"]

{"sheet":"IF(2)","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"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]

{"sheet":"IF(2an)","index":3,"n_rows":10,"n_cols":5,"rows_kept":10,"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]

{"sheet":"V(1)","index":4,"n_rows":114,"n_cols":20,"rows_kept":114,"cut":false,"hidden":false,"merged":[[1,14,5,14]]}
["Date","Product","Region","SalesRep","Customer","Units","COGS","Sales","Sales Category",null,"Math Categories to help understand VLOOKUP","Category Lower Limit","Sales Category",null,null,null,0,{"$f":"Q2","v":100},null,{"$f":"MIN(H2:H106)","v":114}]
["2011-01-26","Bellen","West","Pham","FRED",7,70,154,null,null,{"$f":"Q1&\" <= Sales < \"&R1","v":"0 <= Sales < 100"},{"$f":"Q1","v":0},"Subpar",null,"Lookup Table",null,100,{"$f":"Q3","v":500}]
["2011-01-10","Bellen","MidWest","Gault","FM",61,610,1342,null,null,{"$f":"Q2&\" <= Sales < \"&R2","v":"100 <= Sales < 500"},{"$f":"Q2","v":100},"OK",null,null,null,500,750]
["2011-01-03","Sunshine","South","Sioux","DDH",6,48,114,null,null,{"$f":"Q3&\" <= Sales < \"&R3","v":"500 <= Sales < 750"},{"$f":"Q3","v":500},"Good",null,null,null,750,1000]
["2011-01-07","Sunset","West","Pham","T",61,564.25,1281,null,null,{"$f":"Q4&\" <= Sales < \"&R4","v":"750 <= Sales < 1000"},{"$f":"Q4","v":750},"Great",null,null,null,1000]
["2011-01-18","Sunshine","West","Sioux","AST",8,64,152,null,null,{"$f":"\"Sales >= \"&Q5","v":"Sales >= 1000"},{"$f":"Q5","v":1000},"Exceptional"]
["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,"Sales","Sales Category"]
[null,null,null,null,null,null,null,154,{"$f":"IF(H109>=$L$6,$M$6,IF(H109>=$L$5,$M$5,IF(H109>=$L$4,$M$4,IF(H109>=$L$3,$M$3,$M$2))))","v":"OK"}]
[null,null,null,null,null,null,null,1342,{"$f":"IF(H110>=$L$6,$M$6,IF(H110>=$L$5,$M$5,IF(H110>=$L$4,$M$4,IF(H110>=$L$3,$M$3,$M$2))))","v":"Exceptional"}]
[null,null,null,null,null,null,null,114,"OK"]
[null,null,null,null,null,null,null,1281,"Exceptional"]
[null,null,null,null,null,null,null,152,"OK"]
[null,null,null,null,null,null,null,1357,"Exceptional"]

{"sheet":"V(1an)","index":5,"n_rows":114,"n_cols":20,"rows_kept":114,"cut":false,"hidden":false,"merged":[[1,14,5,14]]}
["Date","Product","Region","SalesRep","Customer","Units","COGS","Sales","Sales Category",null,"Math Categories to help understand VLOOKUP","Category Lower Limit","Sales Category",null,null,null,0,{"$f":"Q2","v":100},null,{"$f":"MIN(H2:H106)","v":114}]
["2011-01-26","Bellen","West","Pham","FRED",7,70,154,{"$f":"VLOOKUP(H2,$L$2:$M$6,2)","v":"OK"},null,{"$f":"Q1&\" <= Sales < \"&R1","v":"0 <= Sales < 100"},{"$f":"Q1","v":0},"Subpar",null,"Lookup Table",null,100,{"$f":"Q3","v":500}]
["2011-01-10","Bellen","MidWest","Gault","FM",61,610,1342,{"$f":"VLOOKUP(H3,$L$2:$M$6,2)","v":"Exceptional"},null,{"$f":"Q2&\" <= Sales < \"&R2","v":"100 <= Sales < 500"},{"$f":"Q2","v":100},"OK",null,null,null,500,750]
["2011-01-03","Sunshine","South","Sioux","DDH",6,48,114,"OK",null,{"$f":"Q3&\" <= Sales < \"&R3","v":"500 <= Sales < 750"},{"$f":"Q3","v":500},"Good",null,null,null,750,1000]
["2011-01-07","Sunset","West","Pham","T",61,564.25,1281,"Exceptional",null,{"$f":"Q4&\" <= Sales < \"&R4","v":"750 <= Sales < 1000"},{"$f":"Q4","v":750},"Great",null,null,null,1000]
["2011-01-18","Sunshine","West","Sioux","AST",8,64,152,"OK",null,{"$f":"\"Sales >= \"&Q5","v":"Sales >= 1000"},{"$f":"Q5","v":1000},"Exceptional"]
["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,$L$2:$M$6,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,"Sales","Sales Category"]
[null,null,null,null,null,null,null,154,{"$f":"IF(H109>=$L$6,$M$6,IF(H109>=$L$5,$M$5,IF(H109>=$L$4,$M$4,IF(H109>=$L$3,$M$3,$M$2))))","v":"OK"}]
[null,null,null,null,null,null,null,1342,{"$f":"IF(H110>=$L$6,$M$6,IF(H110>=$L$5,$M$5,IF(H110>=$L$4,$M$4,IF(H110>=$L$3,$M$3,$M$2))))","v":"Exceptional"}]
[null,null,null,null,null,null,null,114,"OK"]
[null,null,null,null,null,null,null,1281,"Exceptional"]
[null,null,null,null,null,null,null,152,"OK"]
[null,null,null,null,null,null,null,1357,"Exceptional"]

{"sheet":"V(2)","index":6,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Product","Price",null,"Product","Price"]
["Bellen",19,null,"Quad"]
["Sunshine",18]
["Carlota",17]
["Quad",32]
["Boom1",24]
[]
["Income","Tax",null,"Income","Tax"]
[0,0,null,2555]
[1000,25]
[2000,60]
[5000,120]
[10000,175]
[]
["Click on this link to see more about the VLOOKUP function:"]
["Office 2010 Class #39: Excel VLOOKUP Function Formula Made Easy (3 Examples)"]

{"sheet":"V(2an)","index":7,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Product","Price",null,"Product","Price"]
["Bellen",19,null,"Quad",{"$f":"VLOOKUP(D2,A2:B6,2,0)","v":32}]
["Sunshine",18]
["Carlota",17]
["Quad",32]
["Boom1",24]
[]
["Income","Tax",null,"Income","Tax"]
[0,0,null,2555,{"$f":"VLOOKUP(D9,A9:B13,2)","v":60}]
[1000,25]
[2000,60]
[5000,120]
[10000,175]
[]
["Click on this link to see more about the VLOOKUP function:"]
["Office 2010 Class #39: Excel VLOOKUP Function Formula Made Easy (3 Examples)"]