{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Topics","V(1)","V(1an)","V(2)","V(2an)","V(3)","V(3an)","L(1)","L(1an)","M&I(1)","M&I(1an)","M&I(2)","M&I(2an)","M&I(3)","M&I(3an)","M&I(4)","M&I(4an)","C(1)","C(1an)"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":6,"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":17,"n_cols":1,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["VLOOKUP with COLUMNS or ROWS"]
["VLOOKUP Tax"]
["VLOOKUP conditional Formatting"]
["LOOKUP horizontal or vertical"]
["LOOKUP Last Value"]
["MATCH to find Ordinal Position"]
["MATCH to find Ordinal Position for Row and Column Header"]
["INDEX 2 way lookup to find commission rate"]
["MATCH to ask is record in other table"]
["MATCH to ask is record NOT in other table"]
["INDEX 1 way lookup Left  (1 way lookup - row number)"]
["INDEX & MATCH & MAX to lookup High Sales Name (1 way lookup column number)"]
["INDEX & MATCH & array to lookup name associated (1 way lookup - row number)"]
["INDEX & MATCH Whole Column"]
["INDEX & MATCH Whole Row"]
["INDEX & MATCH to find first non-blank"]
["CHOOSE to select different LOOKUP Tables"]

{"sheet":"V(1)","index":1,"n_rows":35,"n_cols":12,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Account#","Fname","Lname","Balance","E-mail",null,null,"Account#","Fname","Lname","Balance","E-mail"]
["1258-DaDo-7418","Danielle","Dowell",4191.5599999999995,"DaDo@gmail.com"]
["1258-ViHo-1321","Victor","Horvath",3676.61,"ViHo@gmail.com"]
["1258-HoSh-4750","Howard","Shah",7350.44,"HoSh@gmail.com",null,"Account#"]
["1258-MaKo-6449","Mark","Koehler",1367.3600000000001,"MaKo@gmail.com",null,"Fname"]
["1258-DeSt-7389","Debbie","Stephen",3196.24,"DeSt@gmail.com",null,"Lname"]
["1258-KuWe-1748","Kurt","Weckerly",7052.93,"KuWe@gmail.com",null,"Balance"]
["1258-GuSu-6102","Guy","Sur",1445.17,"GuSu@gmail.com",null,"E-mail"]
["1258-OdLa-8740","Odessa","Lauria",7812.45,"OdLa@gmail.com"]
["1258-ElRh-4436","Elinor","Rhames",6225.46,"ElRh@gmail.com"]
["1258-NeSu-3274","Neva","Sumler",4749.54,"NeSu@gmail.com"]
["1258-TyBr-8211","Tyrone","Brite",6943.25,"TyBr@gmail.com"]
["1258-JaSe-8984","Javier","Segers",8101.48,"JaSe@gmail.com"]
["1258-ClWi-5671","Clare","Wimbush",6647.43,"ClWi@gmail.com"]
["1258-HiHi-3444","Hillary","Hillen",5095.71,"HiHi@gmail.com"]
["1258-MaZo-8107","Mathew","Zobel",6533.32,"MaZo@gmail.com"]
["1258-JeSo-6445","Jeanie","Solley",4790.2800000000007,"JeSo@gmail.com"]
["1258-MaLe-7052","Marcie","Levis",3611.78,"MaLe@gmail.com"]
["1258-ZeSe-6140","Zelma","Semones",1844.15,"ZeSe@gmail.com"]
["1258-DaCa-8640","Darryl","Canela",8910.2000000000007,"DaCa@gmail.com"]
["1258-JuGo-1604","Julio","Gondek",7341.38,"JuGo@gmail.com"]
["1258-LoSt-8418","Louisa","Strecker",7140.8,"LoSt@gmail.com"]
["1258-JaCl-8766","Javier","Claflin",5994.36,"JaCl@gmail.com"]
["1258-AnEv-6862","Annabelle","Everest",1556.44,"AnEv@gmail.com"]
["1258-ElMe-1003","Elinor","Meinke",6420.78,"ElMe@gmail.com"]
["1258-MaOp-8230","Max","Opp",1989.48,"MaOp@gmail.com"]
["1258-TeOs-1454","Ted","Oscar",8832.36,"TeOs@gmail.com"]
["1258-LoDe-6705","Lonnie","Debus",1623.9299999999998,"LoDe@gmail.com"]
["1258-TaWa-4457","Tania","Warburton",7312.21,"TaWa@gmail.com"]
["1258-HuPa-4126","Hugh","Patron",7792.32,"HuPa@gmail.com"]
["1258-KeCa-5697","Kelly","Carn",4898.3999999999996,"KeCa@gmail.com"]
["1258-JaEp-1979","Jamie","Epperly",1810.45,"JaEp@gmail.com"]
["1258-ClMe-7851","Clinton","Mellen",2813.8199999999997,"ClMe@gmail.com"]
["1258-JeKa-3017","Jessie","Kappler",1135.83,"JeKa@gmail.com"]
["1258-JeKa-3825","Jessie","Kappler",6875.03,"JeKa@gmail.com"]

{"sheet":"V(1an)","index":2,"n_rows":35,"n_cols":12,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Account#","Fname","Lname","Balance","E-mail",null,null,"Account#","Fname","Lname","Balance","E-mail"]
["1258-DaDo-7418","Danielle","Dowell",4191.5599999999995,"DaDo@gmail.com",null,null,"1258-HoSh-4750",{"$f":"VLOOKUP($H2,$A$2:$E$35,COLUMNS($H2:I2),0)","v":"Howard"},{"$f":"VLOOKUP($H2,$A$2:$E$35,COLUMNS($H2:J2),0)","v":"Shah"},{"$f":"VLOOKUP($H2,$A$2:$E$35,COLUMNS($H2:K2),0)","v":7350.44},{"$f":"VLOOKUP($H2,$A$2:$E$35,COLUMNS($H2:L2),0)","v":"HoSh@gmail.com"}]
["1258-ViHo-1321","Victor","Horvath",3676.61,"ViHo@gmail.com"]
["1258-HoSh-4750","Howard","Shah",7350.44,"HoSh@gmail.com",null,"Account#",{"$f":"H2","v":"1258-HoSh-4750"},null,{"$f":"TRANSPOSE(H2:L2)=H4:H8","v":true}]
["1258-MaKo-6449","Mark","Koehler",1367.3600000000001,"MaKo@gmail.com",null,"Fname",{"$f":"VLOOKUP(H$4,$A$2:$E$35,ROWS(H$4:H5),0)","v":"Howard"},null,true]
["1258-DeSt-7389","Debbie","Stephen",3196.24,"DeSt@gmail.com",null,"Lname",{"$f":"VLOOKUP(H$4,$A$2:$E$35,ROWS(H$4:H6),0)","v":"Shah"},null,true]
["1258-KuWe-1748","Kurt","Weckerly",7052.93,"KuWe@gmail.com",null,"Balance",{"$f":"VLOOKUP(H$4,$A$2:$E$35,ROWS(H$4:H7),0)","v":7350.44},null,true]
["1258-GuSu-6102","Guy","Sur",1445.17,"GuSu@gmail.com",null,"E-mail",{"$f":"VLOOKUP(H$4,$A$2:$E$35,ROWS(H$4:H8),0)","v":"HoSh@gmail.com"},null,true]
["1258-OdLa-8740","Odessa","Lauria",7812.45,"OdLa@gmail.com"]
["1258-ElRh-4436","Elinor","Rhames",6225.46,"ElRh@gmail.com"]
["1258-NeSu-3274","Neva","Sumler",4749.54,"NeSu@gmail.com"]
["1258-TyBr-8211","Tyrone","Brite",6943.25,"TyBr@gmail.com"]
["1258-JaSe-8984","Javier","Segers",8101.48,"JaSe@gmail.com"]
["1258-ClWi-5671","Clare","Wimbush",6647.43,"ClWi@gmail.com"]
["1258-HiHi-3444","Hillary","Hillen",5095.71,"HiHi@gmail.com"]
["1258-MaZo-8107","Mathew","Zobel",6533.32,"MaZo@gmail.com"]
["1258-JeSo-6445","Jeanie","Solley",4790.2800000000007,"JeSo@gmail.com"]
["1258-MaLe-7052","Marcie","Levis",3611.78,"MaLe@gmail.com"]
["1258-ZeSe-6140","Zelma","Semones",1844.15,"ZeSe@gmail.com"]
["1258-DaCa-8640","Darryl","Canela",8910.2000000000007,"DaCa@gmail.com"]
["1258-JuGo-1604","Julio","Gondek",7341.38,"JuGo@gmail.com"]
["1258-LoSt-8418","Louisa","Strecker",7140.8,"LoSt@gmail.com"]
["1258-JaCl-8766","Javier","Claflin",5994.36,"JaCl@gmail.com"]
["1258-AnEv-6862","Annabelle","Everest",1556.44,"AnEv@gmail.com"]
["1258-ElMe-1003","Elinor","Meinke",6420.78,"ElMe@gmail.com"]
["1258-MaOp-8230","Max","Opp",1989.48,"MaOp@gmail.com"]
["1258-TeOs-1454","Ted","Oscar",8832.36,"TeOs@gmail.com"]
["1258-LoDe-6705","Lonnie","Debus",1623.9299999999998,"LoDe@gmail.com"]
["1258-TaWa-4457","Tania","Warburton",7312.21,"TaWa@gmail.com"]
["1258-HuPa-4126","Hugh","Patron",7792.32,"HuPa@gmail.com"]
["1258-KeCa-5697","Kelly","Carn",4898.3999999999996,"KeCa@gmail.com"]
["1258-JaEp-1979","Jamie","Epperly",1810.45,"JaEp@gmail.com"]
["1258-ClMe-7851","Clinton","Mellen",2813.8199999999997,"ClMe@gmail.com"]
["1258-JeKa-3017","Jessie","Kappler",1135.83,"JeKa@gmail.com"]
["1258-JeKa-3825","Jessie","Kappler",6875.03,"JeKa@gmail.com"]

{"sheet":"V(2)","index":3,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Corporate Tax Table"]
["VLOOKUP\nReference","Over -","But Not Over","Tax Amount From\nPrevious Bracket","Tax Rate For\nRemaining Amount"]
[0,0,50000,null,0.15]
[{"$f":"B4+1","v":50001},{"$f":"C3","v":50000},75000,{"$f":"E3*C3","v":7500},0.25]
[75001,75000,100000,{"$f":"D4+(C4-C3)*E4","v":13750},0.34]
[100001,100000,335000,22250,0.39]
[335001,335000,10000000,113900,0.34]
[10000001,10000000,15000000,3400000.0000000005,0.35]
[15000001,15000000,18333333,5150000,0.38]
[18333334,18333333,null,6416666.54,0.35]
[]
["Manufacturers Plus"]
["Income Statement"]
["Projected Net Income For The Years Ended December 31"]
[]
[null,2003,{"$f":"B16+1","v":2004},{"$f":"C16+1","v":2005},{"$f":"D16+1","v":2006},{"$f":"E16+1","v":2007},{"$f":"F16+1","v":2008}]
["Net Revenues",450000,{"$f":"B17*(1+$B28)","v":495000.00000000006},544500.00000000012,598950.00000000023,658845.00000000035,724729.50000000047]
["Expenses",500000,510000,520200,530604,541216.07999999996,552040.40159999998]
["Net Income Before Income Taxes",{"$f":"B17-B18","v":-50000},-14999.999999999942,24300.000000000116,68346.000000000233,117628.92000000039,172689.09840000048]
["Tax Expense"]
["Net Income",{"$f":"B19-B20","v":-50000},-14999.999999999942,24300.000000000116,68346.000000000233,117628.92000000039,172689.09840000048]
[]
[]
[]
[]
[]
["Assumptions"]
["Increase In Sales",0.1]
["Increase in Expenses",0.02]

{"sheet":"V(2an)","index":4,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Corporate Tax Table"]
["VLOOKUP\nReference","Over -","But Not Over","Tax Amount From\nPrevious Bracket","Tax Rate For\nRemaining Amount"]
[0,0,50000,null,0.15]
[{"$f":"B4+1","v":50001},{"$f":"C3","v":50000},75000,{"$f":"E3*C3","v":7500},0.25]
[75001,75000,100000,{"$f":"D4+(C4-C3)*E4","v":13750},0.34]
[100001,100000,335000,22250,0.39]
[335001,335000,10000000,113900,0.34]
[10000001,10000000,15000000,3400000.0000000005,0.35]
[15000001,15000000,18333333,5150000,0.38]
[18333334,18333333,null,6416666.54,0.35]
[]
["Manufacturers Plus"]
["Income Statement"]
["Projected Net Income For The Years Ended December 31"]
[]
[null,2003,{"$f":"B16+1","v":2004},{"$f":"C16+1","v":2005},{"$f":"D16+1","v":2006},{"$f":"E16+1","v":2007},{"$f":"F16+1","v":2008}]
["Net Revenues",450000,{"$f":"B17*(1+$B28)","v":495000.00000000006},544500.00000000012,598950.00000000023,658845.00000000035,724729.50000000047]
["Expenses",500000,510000,520200,530604,541216.07999999996,552040.40159999998]
["Net Income Before Income Taxes",{"$f":"B17-B18","v":-50000},-14999.999999999942,24300.000000000116,68346.000000000233,117628.92000000039,172689.09840000048]
["Tax Expense",{"$f":"IFERROR(VLOOKUP(B19,Tax,4)+(B19-VLOOKUP(B19,Tax,2))*VLOOKUP(B19,Tax,5),0)","v":0},0,3645.0000000000173,12086.500000000058,{"$f":"IFERROR(VLOOKUP(F19,Tax,4)+(F19-VLOOKUP(F19,Tax,2))*VLOOKUP(F19,Tax,5),0)","v":29125.278800000153},50598.748376000192]
["Net Income",{"$f":"B19-B20","v":-50000},-14999.999999999942,20655.000000000098,56259.500000000175,88503.641200000246,122090.35002400029]
[]
[null,null,null,null,null,{"$f":"D6+(F19-B6)*E6","v":29125.278800000153}]
[]
[]
[]
["Assumptions"]
["Increase In Sales",0.1]
["Increase in Expenses",0.02]

{"sheet":"V(3)","index":5,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,0,8,0]]}
[null,null,"Product Commission Rate"]
[null,null,"Pro1","Pro2","Pro3","Pro4","Pro5"]
["Sales",0,{"$f":"(ROW()+COLUMN())/1000","v":6.0000000000000001E-3},7.0000000000000001E-3,8.0000000000000002E-3,8.9999999999999993E-3,0.01]
[null,{"$f":"B3+1500","v":1500},7.0000000000000001E-3,8.0000000000000002E-3,8.9999999999999993E-3,0.01,1.0999999999999999E-2]
[null,{"$f":"B4+1500","v":3000},8.0000000000000002E-3,8.9999999999999993E-3,0.01,1.0999999999999999E-2,1.2E-2]
[null,4500,8.9999999999999993E-3,0.01,1.0999999999999999E-2,1.2E-2,1.2999999999999999E-2]
[null,6000,0.01,1.0999999999999999E-2,1.2E-2,1.2999999999999999E-2,1.4E-2]
[null,7500,1.0999999999999999E-2,1.2E-2,1.2999999999999999E-2,1.4E-2,1.4999999999999999E-2]
[null,9000,1.2E-2,1.2999999999999999E-2,1.4E-2,1.4999999999999999E-2,1.6E-2]
[]
[null,"Pro","Pro3"]
[null,{"$f":"A3","v":"Sales"},5000]

{"sheet":"V(3an)","index":6,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,0,8,0]]}
[null,null,"Product Commission Rate"]
[null,null,"Pro1","Pro2","Pro3","Pro4","Pro5"]
["Sales",0,{"$f":"(ROW()+COLUMN())/1000","v":6.0000000000000001E-3},7.0000000000000001E-3,8.0000000000000002E-3,8.9999999999999993E-3,0.01]
[null,{"$f":"B3+1500","v":1500},7.0000000000000001E-3,8.0000000000000002E-3,8.9999999999999993E-3,0.01,1.0999999999999999E-2]
[null,{"$f":"B4+1500","v":3000},8.0000000000000002E-3,8.9999999999999993E-3,0.01,1.0999999999999999E-2,1.2E-2]
[null,4500,8.9999999999999993E-3,0.01,1.0999999999999999E-2,1.2E-2,1.2999999999999999E-2]
[null,6000,0.01,1.0999999999999999E-2,1.2E-2,1.2999999999999999E-2,1.4E-2]
[null,7500,1.0999999999999999E-2,1.2E-2,1.2999999999999999E-2,1.4E-2,1.4999999999999999E-2]
[null,9000,1.2E-2,1.2999999999999999E-2,1.4E-2,1.4999999999999999E-2,1.6E-2]
[]
[null,"Pro","Pro3"]
[null,{"$f":"A3","v":"Sales"},5000]

{"sheet":"L(1)","index":7,"n_rows":59,"n_cols":41,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
["V",null,null,"H"]
[0,0,null,0,100,500,1000]
[100,0.01,null,0,0.01,0.03,0.05]
[500,0.03]
[1000,0.05]
[]
["Sales",555]
["Tax",null,"from vertical table"]
["Tax",null,"from horizontal table"]
[]
[null,null,null,null,null,null,null,"Stock Value at End of Week"]
["LOOKUP:",null,null,null,null,null,"Last Value Entered","Week 1","Week 2","Week 3","Week 4","Week 5","Week 6","Week 7","Week 8","Week 9","Week 10","Week 11","Week 12","Week 13","Week 14","Week 15","Week 16","Week 17","Week 18","Week 19","Week 20","Week 21","Week 22","Week 23","Week 24","Week 25","Week 26","Week 27","Week 28","Week 29","Week 30","Week 31","Week 32","Week 33","Week 34"]
["1) 1st column sorted ascending",null,null,null,null,null,null,55,57,null,49,null,40,38.5,39,38.75]
["2) only does approximate lookup"]
["3) always returns value from last column / row",null,null,null,null,null,null,null,"Stock Value at End of Week"]
["4) can do V or H Lookup",null,null,null,null,null,null,null,"Week 1",5]
["5) can have 2 vectors",null,null,null,null,null,"Last Value Entered",null,"Week 2",3]
["6) lookup last value in row or column",null,null,null,null,null,null,null,"Week 3",4.2]
[null,null,null,null,null,null,null,null,"Week 4",4]
[null,null,null,null,null,null,null,null,"Week 5",3.99]
[null,null,null,null,null,null,null,null,"Week 6"]
[null,null,null,null,null,null,null,null,"Week 7",4.1500000000000004]
[null,null,null,null,null,null,null,null,"Week 8"]
[null,null,null,null,null,null,null,null,"Week 9"]
[null,null,null,null,null,null,null,null,"Week 10"]
[null,null,null,null,null,null,null,null,"Week 11"]
[null,null,null,null,null,null,null,null,"Week 12"]
[null,null,null,null,null,null,null,null,"Week 13"]
[null,null,null,null,null,null,null,null,"Week 14"]
[null,null,null,null,null,null,null,null,"Week 15"]
[null,null,null,null,null,null,null,null,"Week 16"]
[null,null,null,null,null,null,null,null,"Week 17"]
[null,null,null,null,null,null,null,null,"Week 18"]
[null,null,null,null,null,null,null,null,"Week 19"]
[null,null,null,null,null,null,null,null,"Week 20"]
[null,null,null,null,null,null,null,null,"Week 21"]
[null,null,null,null,null,null,null,null,"Week 22"]
[null,null,null,null,null,null,null,null,"Week 23"]
[null,null,null,null,null,null,null,null,"Week 24"]
[null,null,null,null,null,null,null,null,"Week 25"]
[null,null,null,null,null,null,null,null,"Week 26"]
[null,null,null,null,null,null,null,null,"Week 27",6.95]
[null,null,null,null,null,null,null,null,"Week 28"]
[null,null,null,null,null,null,null,null,"Week 29"]
[null,null,null,null,null,null,null,null,"Week 30"]
[null,null,null,null,null,null,null,null,"Week 31"]
[null,null,null,null,null,null,null,null,"Week 32"]
[null,null,null,null,null,null,null,null,"Week 33"]
[null,null,null,null,null,null,null,null,"Week 34"]
[null,null,null,null,null,null,null,null,"Week 35"]
[null,null,null,null,null,null,null,null,"Week 36"]
[null,null,null,null,null,null,null,null,"Week 37"]
[null,null,null,null,null,null,null,null,"Week 38"]
[null,null,null,null,null,null,null,null,"Week 39"]
[null,null,null,null,null,null,null,null,"Week 40"]
[null,null,null,null,null,null,null,null,"Week 41"]
[null,null,null,null,null,null,null,null,"Week 42"]
[null,null,null,null,null,null,null,null,"Week 43"]
[null,null,null,null,null,null,null,null,"Week 44"]

{"sheet":"L(1an)","index":8,"n_rows":59,"n_cols":41,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
["V",null,null,"H"]
[0,0,null,0,100,500,1000]
[100,0.01,null,0,0.01,0.03,0.05]
[500,0.03]
[1000,0.05]
[]
["Sales",555]
["Tax",{"$f":"LOOKUP(B7,A2:B5)","v":0.03},"from vertical table"]
["Tax",{"$f":"LOOKUP(B7,D2:G3)","v":0.03},"from horizontal table"]
[]
[null,null,null,null,null,null,null,"Stock Value at End of Week"]
["LOOKUP:",null,null,null,null,null,"Last Value Entered","Week 1","Week 2","Week 3","Week 4","Week 5","Week 6","Week 7","Week 8","Week 9","Week 10","Week 11","Week 12","Week 13","Week 14","Week 15","Week 16","Week 17","Week 18","Week 19","Week 20","Week 21","Week 22","Week 23","Week 24","Week 25","Week 26","Week 27","Week 28","Week 29","Week 30","Week 31","Week 32","Week 33","Week 34"]
["1) 1st column sorted ascending",null,null,null,null,null,{"$f":"LOOKUP(9.99999999999999E+307,H13:AO13)","v":38.75},55,57,null,49,null,40,38.5,39,38.75]
["2) only does approximate lookup",null,null,null,null,null,{"$f":"HLOOKUP(9.99999999999999E+307,H13:AO13,1)","v":38.75}]
["3) always returns value from last column / row",null,null,null,null,null,null,null,"Stock Value at End of Week"]
["4) can do V or H Lookup",null,null,null,null,null,null,null,"Week 1",5]
["5) can have 2 vectors",null,null,null,null,null,"Last Value Entered",null,"Week 2",3]
["6) lookup last value in row or column",null,null,null,null,null,{"$f":"LOOKUP(9.99999999999999E+307,J16:J59)","v":6.95},null,"Week 3",4.2]
[null,null,null,null,null,null,{"$f":"VLOOKUP(9.99999999999999E+307,J16:J59,1)","v":6.95},null,"Week 4",4]
[null,null,null,null,null,null,null,null,"Week 5",3.99]
[null,null,null,null,null,null,null,null,"Week 6"]
[null,null,null,null,null,null,null,null,"Week 7",4.1500000000000004]
[null,null,null,null,null,null,null,null,"Week 8"]
[null,null,null,null,null,null,null,null,"Week 9"]
[null,null,null,null,null,null,null,null,"Week 10"]
[null,null,null,null,null,null,null,null,"Week 11"]
[null,null,null,null,null,null,null,null,"Week 12"]
[null,null,null,null,null,null,null,null,"Week 13"]
[null,null,null,null,null,null,null,null,"Week 14"]
[null,null,null,null,null,null,null,null,"Week 15"]
[null,null,null,null,null,null,null,null,"Week 16"]
[null,null,null,null,null,null,null,null,"Week 17"]
[null,null,null,null,null,null,null,null,"Week 18"]
[null,null,null,null,null,null,null,null,"Week 19"]
[null,null,null,null,null,null,null,null,"Week 20"]
[null,null,null,null,null,null,null,null,"Week 21"]
[null,null,null,null,null,null,null,null,"Week 22"]
[null,null,null,null,null,null,null,null,"Week 23"]
[null,null,null,null,null,null,null,null,"Week 24"]
[null,null,null,null,null,null,null,null,"Week 25"]
[null,null,null,null,null,null,null,null,"Week 26"]
[null,null,null,null,null,null,null,null,"Week 27",6.95]
[null,null,null,null,null,null,null,null,"Week 28"]
[null,null,null,null,null,null,null,null,"Week 29"]
[null,null,null,null,null,null,null,null,"Week 30"]
[null,null,null,null,null,null,null,null,"Week 31"]
[null,null,null,null,null,null,null,null,"Week 32"]
[null,null,null,null,null,null,null,null,"Week 33"]
[null,null,null,null,null,null,null,null,"Week 34"]
[null,null,null,null,null,null,null,null,"Week 35"]
[null,null,null,null,null,null,null,null,"Week 36"]
[null,null,null,null,null,null,null,null,"Week 37"]
[null,null,null,null,null,null,null,null,"Week 38"]
[null,null,null,null,null,null,null,null,"Week 39"]
[null,null,null,null,null,null,null,null,"Week 40"]
[null,null,null,null,null,null,null,null,"Week 41"]
[null,null,null,null,null,null,null,null,"Week 42"]
[null,null,null,null,null,null,null,null,"Week 43"]
[null,null,null,null,null,null,null,null,"Week 44"]

{"sheet":"M&I(1)","index":9,"n_rows":67,"n_cols":9,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[{"$f":"ROWS(A$1:A1)&\")\"","v":"1)"},"The MATCH function looks up a value and tells you what relative (ordinal) position it is in the list.",null,null,null,null,null,null,"If match_type is -1, MATCH finds the smallest value that is greater than or equal to lookup_value. Lookup_array must be placed in descending order: TRUE, FALSE, Z-A, ...2, 1, 0, -1, -2, ..., and so on."]
[{"$f":"ROWS(A$1:A2)&\")\"","v":"2)"},"The list can be horizontal or vertical.",null,null,null,null,null,null,"If match_type is 1, MATCH finds the largest value that is less than or equal to lookup_value. Lookup_array must be placed in ascending order: ...-2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE."]
[{"$f":"ROWS(A$1:A3)&\")\"","v":"3)"},"MATCH(lookup_value,lookup_array,match_type)",null,null,null,null,null,null,"If match_type is 0, MATCH finds the first value that is exactly equal to lookup_value. Lookup_array can be in any order."]
[{"$f":"ROWS(A$1:A4)&\")\"","v":"4)"},"Just like VLOOKUP, MATCH can do an approximate or exact match lookup.\nIf match_type is omitted, it is assumed to be 1.\n"]
[]
[null,"Commission Table"]
[null,"Product/SalesMade",500,2000,5000,10000,20000]
[null,"Pro1",{"$f":"((ROW()+COLUMN())/100-0.05)/2","v":0.03},3.4999999999999996E-2,0.04,4.5000000000000005E-2,4.9999999999999996E-2]
[null,"Pro2",3.4999999999999996E-2,0.04,4.5000000000000005E-2,4.9999999999999996E-2,5.5E-2]
[null,"Pro3",0.04,4.5000000000000005E-2,4.9999999999999996E-2,5.5E-2,6.0000000000000005E-2]
[null,"Pro4",4.5000000000000005E-2,4.9999999999999996E-2,5.5E-2,6.0000000000000005E-2,6.5000000000000002E-2]
[null,"Pro5",4.9999999999999996E-2,5.5E-2,6.0000000000000005E-2,6.5000000000000002E-2,7.0000000000000007E-2]
[null,"Pro6",5.5E-2,6.0000000000000005E-2,6.5000000000000002E-2,7.0000000000000007E-2,7.5000000000000011E-2]
[null,"Pro7",6.0000000000000005E-2,6.5000000000000002E-2,7.0000000000000007E-2,7.5000000000000011E-2,7.9999999999999988E-2]
[null,"Pro8",6.5000000000000002E-2,7.0000000000000007E-2,7.5000000000000011E-2,7.9999999999999988E-2,8.4999999999999992E-2]
[null,"Pro9",7.0000000000000007E-2,7.5000000000000011E-2,7.9999999999999988E-2,8.4999999999999992E-2,0.09]
[null,"Pro10",7.5000000000000011E-2,7.9999999999999988E-2,8.4999999999999992E-2,0.09,9.5000000000000001E-2]
[]
[null,null,null,"Relative (ordinal) position:"]
[null,"Select Item >>","Pro3"]
[null,"Type Sales Amount >>",50087.5]
[]
["5)","INDEX can do 2 way lookup. It can find the intersection of a row and column inside a table. This is in comparision to the VLOOKUP that only does a 1 way lookup, in that it only looks through the first column of a table and finds a certain row."]
["6)","INDEX(array,row_num,column_num)\nThe INDEX function has two possibilities - we will only use the first (because there is a better alternative (that we will see later using the CHOOSE function) for the second option."]
["7)","INDEX is usually used with the MATCH function. The MATCH will give the INDEX the row and column number needed for the 2 way lookup."]
["8)","INDEX can return a single value to a cell or a cell reference to a formula."]
[]
[null,"Commission Table"]
[null,"Product/SalesMade",500,2000,5000,10000,20000]
[null,"Pro1",{"$f":"((ROW()+COLUMN())/100-0.05)/2","v":0.14000000000000001},0.14500000000000002,0.15,0.155,0.16]
[null,"Pro2",0.14500000000000002,0.15,0.155,0.16,0.16500000000000001]
[null,"Pro3",0.15,0.155,0.16,0.16500000000000001,0.17]
[null,"Pro4",0.155,0.16,0.16500000000000001,0.17,0.17500000000000002]
[null,"Pro5",0.16,0.16500000000000001,0.17,0.17500000000000002,0.18]
[null,"Pro6",0.16500000000000001,0.17,0.17500000000000002,0.18,0.185]
[null,"Pro7",0.17,0.17500000000000002,0.18,0.185,0.19]
[null,"Pro8",0.17500000000000002,0.18,0.185,0.19,0.19500000000000001]
[null,"Pro9",0.18,0.185,0.19,0.19500000000000001,0.2]
[null,"Pro10",0.185,0.19,0.19500000000000001,0.2,0.20500000000000002]
[]
[null,null,null,"Relative (ordinal) position:"]
[null,"Select Item >>","Pro3"]
[null,"Type Sales Amount >>",50087.5]
[null,"Commission Rate:"]
[null,"Commission Rate:"]
["a"]
[null,"Total Commission"]
[]
[]
[]
[]
["Prospective Customer List"]
["List 1",null,"List 2","Is Record in Other Table?"]
["Customer 63",null,"Customer 63"]
["Customer 18",null,"Customer 18"]
["Customer 37",null,"Customer 43"]
["Customer 12",null,"Customer 73"]
["Customer 73",null,"Customer 76"]
["Customer 76",null,"Customer 11"]
["Customer 72"]
["Customer 15",null,"List 2","Is Record in NOT Other Table?"]
[null,null,"Customer 63"]
[null,null,"Customer 18"]
[null,null,"Customer 43"]
[null,null,"Customer 73"]
[null,null,"Customer 76"]
[null,null,"Customer 11"]

{"sheet":"M&I(1an)","index":10,"n_rows":67,"n_cols":9,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[{"$f":"ROWS(A$1:A1)&\")\"","v":"1)"},"The MATCH function looks up a value and tells you what relative (ordinal) position it is in the list.",null,null,null,null,null,null,"If match_type is -1, MATCH finds the smallest value that is greater than or equal to lookup_value. Lookup_array must be placed in descending order: TRUE, FALSE, Z-A, ...2, 1, 0, -1, -2, ..., and so on."]
[{"$f":"ROWS(A$1:A2)&\")\"","v":"2)"},"The list can be horizontal or vertical.",null,null,null,null,null,null,"If match_type is 1, MATCH finds the largest value that is less than or equal to lookup_value. Lookup_array must be placed in ascending order: ...-2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE."]
[{"$f":"ROWS(A$1:A3)&\")\"","v":"3)"},"MATCH(lookup_value,lookup_array,match_type)",null,null,null,null,null,null,"If match_type is 0, MATCH finds the first value that is exactly equal to lookup_value. Lookup_array can be in any order."]
[{"$f":"ROWS(A$1:A4)&\")\"","v":"4)"},"Just like VLOOKUP, MATCH can do an approximate or exact match lookup.\nIf match_type is omitted, it is assumed to be 1.\n"]
[]
[null,"Commission Table"]
[null,"Product/SalesMade",500,2000,5000,10000,20000]
[null,"Pro1",{"$f":"((ROW()+COLUMN())/100-0.05)/2","v":0.03},3.4999999999999996E-2,0.04,4.5000000000000005E-2,4.9999999999999996E-2]
[null,"Pro2",3.4999999999999996E-2,0.04,4.5000000000000005E-2,4.9999999999999996E-2,5.5E-2]
[null,"Pro3",0.04,4.5000000000000005E-2,4.9999999999999996E-2,5.5E-2,6.0000000000000005E-2]
[null,"Pro4",4.5000000000000005E-2,4.9999999999999996E-2,5.5E-2,6.0000000000000005E-2,6.5000000000000002E-2]
[null,"Pro5",4.9999999999999996E-2,5.5E-2,6.0000000000000005E-2,6.5000000000000002E-2,7.0000000000000007E-2]
[null,"Pro6",5.5E-2,6.0000000000000005E-2,6.5000000000000002E-2,7.0000000000000007E-2,7.5000000000000011E-2]
[null,"Pro7",6.0000000000000005E-2,6.5000000000000002E-2,7.0000000000000007E-2,7.5000000000000011E-2,7.9999999999999988E-2]
[null,"Pro8",6.5000000000000002E-2,7.0000000000000007E-2,7.5000000000000011E-2,7.9999999999999988E-2,8.4999999999999992E-2]
[null,"Pro9",7.0000000000000007E-2,7.5000000000000011E-2,7.9999999999999988E-2,8.4999999999999992E-2,0.09]
[null,"Pro10",7.5000000000000011E-2,7.9999999999999988E-2,8.4999999999999992E-2,0.09,9.5000000000000001E-2]
[]
[null,null,null,"Relative (ordinal) position:"]
[null,"Select Item >>","Pro3",{"$f":"MATCH(C20,B8:B17,0)","v":3}]
[null,"Type Sales Amount >>",50087.5,{"$f":"MATCH(C21,C7:G7)","v":5}]
[]
["5)","INDEX can do 2 way lookup. It can find the intersection of a row and column inside a table. This is in comparision to the VLOOKUP that only does a 1 way lookup, in that it only looks through the first column of a table and finds a certain row."]
["6)","INDEX(array,row_num,column_num)\nThe INDEX function has two possibilities - we will only use the first (because there is a better alternative (that we will see later using the CHOOSE function) for the second option."]
["7)","INDEX is usually used with the MATCH function. The MATCH will give the INDEX the row and column number needed for the 2 way lookup."]
["8)","INDEX can return a single value to a cell or a cell reference to a formula."]
[]
[null,"Commission Table"]
[null,"Product/SalesMade",500,2000,5000,10000,20000]
[null,"Pro1",{"$f":"((ROW()+COLUMN())/100-0.05)/2","v":0.14000000000000001},0.14500000000000002,0.15,0.155,0.16]
[null,"Pro2",0.14500000000000002,0.15,0.155,0.16,0.16500000000000001]
[null,"Pro3",0.15,0.155,0.16,0.16500000000000001,0.17]
[null,"Pro4",0.155,0.16,0.16500000000000001,0.17,0.17500000000000002]
[null,"Pro5",0.16,0.16500000000000001,0.17,0.17500000000000002,0.18]
[null,"Pro6",0.16500000000000001,0.17,0.17500000000000002,0.18,0.185]
[null,"Pro7",0.17,0.17500000000000002,0.18,0.185,0.19]
[null,"Pro8",0.17500000000000002,0.18,0.185,0.19,0.19500000000000001]
[null,"Pro9",0.18,0.185,0.19,0.19500000000000001,0.2]
[null,"Pro10",0.185,0.19,0.19500000000000001,0.2,0.20500000000000002]
[]
[null,null,null,"Relative (ordinal) position:"]
[null,"Select Item >>","Pro3",{"$f":"MATCH(C42,B30:B39,0)","v":3}]
[null,"Type Sales Amount >>",50087.5,{"$f":"MATCH(C43,C29:G29)","v":5}]
[null,"Commission Rate:",{"$f":"INDEX(C30:G39,D42,D43)","v":0.17}]
[null,"Commission Rate:",{"$f":"INDEX(C30:G39,MATCH(C43,C29:G29),MATCH(C42,B30:B39,0))","v":0.17}]
["a"]
[null,"Total Commission",{"$f":"C43*INDEX(C30:G39,MATCH(C42,B30:B39,0),MATCH(C43,C29:G29))","v":8514.875}]
[]
[]
[]
[]
["Prospective Customer List"]
["List 1",null,"List 2","Is Record in Other Table?"]
["Customer 63",null,"Customer 63",{"$f":"ISNUMBER(MATCH(C54,$A$54:$A$61,0))","v":true}]
["Customer 18",null,"Customer 18",true]
["Customer 37",null,"Customer 43",false]
["Customer 12",null,"Customer 73",true]
["Customer 73",null,"Customer 76",true]
["Customer 76",null,"Customer 11",false]
["Customer 72"]
["Customer 15",null,"List 2","Is Record in NOT Other Table?"]
[null,null,"Customer 63",{"$f":"ISNA(MATCH(C62,$A$54:$A$61,0))","v":false}]
[null,null,"Customer 18",false]
[null,null,"Customer 43",true]
[null,null,"Customer 73",false]
[null,null,"Customer 76",false]
[null,null,"Customer 11",true]

{"sheet":"M&I(2)","index":11,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["9)","INDEX & MATCH can do 1 way lookups that VLOOKUP cannot do."]
["10)","INDEX & MATCH can do \"lookup to the Left\"."]
[]
[null,"Product","ID#","Price",null,"Invoice"]
[null,"Pro1",10002,13]
[null,"Pro2",10003,15,null,"ID","Product","Price","Units","Total"]
[null,"Pro3",10004,15,null,10004,null,null,5,{"$f":"I7*H7","v":0}]
[null,"Pro4",10005,14,null,10005,null,null,2,{"$f":"I8*H8","v":0}]
[null,"Pro5",10006,15,null,10006,null,null,1,0]
[null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(J7:J9)","v":0}]
[]
["11)","INDEX & MATCH High Sales Name (1 way lookup - looking up column number).\nIf there are only columns, you can enter column number into the second argument (row_num)."]
[]
[null,"Sales Name","Sioux","Phil","Chin","Mo","Sales Rep Who Got Highest Sales"]
[null,"Day 1",{"$f":"ROUND(RAND()*800+500,2)","v":653.66999999999996},1079.76,1263.5899999999999,879.93]
[null,"Day 2",1101.98,611.80999999999995,620.89,1204.47]
[null,"Day 3",1161.44,1135.68,726.5,1102.9000000000001]
[null,"Day 4",542.07000000000005,1217.03,1185.06,592.34]
[null,"Day 5",1019.03,1142.3699999999999,1239.06,852.09]
[null,"Day 6",692.3,1065.05,548.20000000000005,710.69]
[null,"Day 7",823.66,1280.17,657.68,1142.75]
[]
[{"$f":"ROWS(A$1:A12)&\")\"","v":"12)"},"INDEX & MATCH & array to lookup name associated.  (1 way lookup - looking up row number)"]
[]
["Sales 2008","Sales 2009","Name"]
[69979,100000,"Suix"]
[92964,101998,"Fred"]
[79522,85916,"Chin"]
[80956,81000,"Ali"]
[90906,99368,"Jeff"]
[]
[]
[null,"Max Improvement"]
[null,"Name"]

{"sheet":"M&I(2an)","index":12,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["9)","INDEX & MATCH can do 1 way lookups that VLOOKUP cannot do."]
["10)","INDEX & MATCH can do \"lookup to the Left\"."]
[]
[null,"Product","ID#","Price",null,"Invoice"]
[null,"Pro1",10002,13]
[null,"Pro2",10003,15,null,"ID","Product","Price","Units","Total"]
[null,"Pro3",10004,15,null,10004,{"$f":"INDEX($B$5:$B$9,MATCH(F7,$C$5:$C$9,0))","v":"Pro3"},{"$f":"VLOOKUP(F7,C5:D9,2,0)","v":15},5,{"$f":"I7*H7","v":75}]
[null,"Pro4",10005,14,null,10005,{"$f":"INDEX($B$5:$B$9,MATCH(F8,$C$5:$C$9,0))","v":"Pro4"},{"$f":"VLOOKUP(F8,C6:D10,2,0)","v":14},2,{"$f":"I8*H8","v":28}]
[null,"Pro5",10006,15,null,10006,"Pro5",15,1,15]
[null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(J7:J9)","v":118}]
[]
["11)","INDEX & MATCH High Sales Name (1 way lookup - looking up column number).\nIf there are only columns, you can enter column number into the second argument (row_num)."]
[]
[null,"Sales Name","Sioux","Phil","Chin","Mo","Sales Rep Who Got Highest Sales"]
[null,"Day 1",{"$f":"ROUND(RAND()*800+500,2)","v":1266.48},718.64,1148.92,655.81,{"$f":"INDEX($C$14:$F$14,MATCH(MAX(C15:F15),C15:F15,0))","v":"Sioux"}]
[null,"Day 2",719.18,539.64,744.61,792.27,"Mo"]
[null,"Day 3",1188.92,1089.06,1186.55,953.86,"Sioux"]
[null,"Day 4",1237.8599999999999,893.22,1088.8599999999999,1014.93,"Sioux"]
[null,"Day 5",950.42,985.44,1255.97,1105.28,"Chin"]
[null,"Day 6",907.95,878.33,665.08,842.58,"Sioux"]
[null,"Day 7",1132.06,1174.9000000000001,504.21,988.92,"Phil"]
[]
[{"$f":"ROWS(A$1:A12)&\")\"","v":"12)"},"INDEX & MATCH & array to lookup name associated.  (1 way lookup - looking up row number)"]
[]
["Sales 2008","Sales 2009","Name"]
[69979,100000,"Suix"]
[92964,101998,"Fred"]
[79522,85916,"Chin"]
[80956,81000,"Ali"]
[90906,99368,"Jeff"]
[]
[]
[null,"Max Improvement",{"$f":"MAX(B26:B30-A26:A30)","v":30021}]
[null,"Name",{"$f":"IF(C33=\"\",\"\",INDEX(C26:C30,MATCH(C33,B26:B30-A26:A30,0)))","v":"Suix"}]

{"sheet":"M&I(3)","index":13,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["13)","INDEX & MATCH to lookup whole column.\nA 0 (zero) in the row_num means take the whole column or \"all the rows\"."]
[]
[null,"Jan","Feb","Mar","April",null,"Month:","April"]
[null,1081.95,619.12,707.45,756.59,null,"Total"]
[null,913.1,730.87,969.9,609.61]
[null,1212.3800000000001,840.17,1222.96,577.57000000000005]
[null,735.08,560.67999999999995,1096.3,1070.3900000000001]
[null,685.48,1225.95,596.01,1009.88]
[null,1088.7,793.41,1010.52,1105.98]
[null,1169.79,983.38,1274.46,1287.75]
[null,1248.8,518.23,946.49,1199.03]
[null,1156.68,578.71,712.75,1223]
[null,651.29,1130.21,637.21,1285.6099999999999]
[null,810.08,843.39,735.55,970.38]
[null,1212.19,534.34,1096.9000000000001,953.78]
[null,549,747.09,723.65,712.64]
[]
["14)","INDEX & MATCH to lookup whole row.\nA 0 (zero) in the column_num means take the whole row or \"all the columns\"."]
[]
[null,"Week","Ratings Team Member 1","Ratings Team Member 2","Ratings Team Member 3","Ratings Team Member 4","Ratings Team Member 5","Ratings Team Member 6","Ratings Team Member 7","Ratings Team Member 8"]
[null,"Week 1",4.51,4.1100000000000003,4.8099999999999996,2.78,4.8899999999999997,5.0999999999999996,1.23,2.2599999999999998]
[null,"Week 2",3.47,1.04,3.42,4.7,5.64,1.1000000000000001,3.3,5.08]
[null,"Week 3",4.5199999999999996,3.45,3.84,2.76,1.7,1.61,3.3,4.92]
[null,"Week 4",1.47,1.99,5.52,2.34,3.26,1.7,5.6,4.09]
[null,"Week 5",5.68,3.72,4.37,2.46,4.5599999999999996,1.59,5.5,1.2]
[null,"Week 6",1.36,3.52,2.0499999999999998,1.61,1.61,2.21,3.62,4.72]
[null,"Week 7",3.07,3.38,4.26,5.25,2.64,2.59,4.63,5.52]
[null,"Week 8",1.06,5.04,4.8499999999999996,3.54,4.38,4.21,1.54,3.66]
[null,"Week 9",1.45,3.77,1.1200000000000001,5.21,3.79,1.87,4.29,2.1]
[null,"Week 10",2.1,3.34,5.5,3.11,3.1,1.57,3.76,1.81]
[null,"Week 11",1.77,4.63,2.58,5.3,5.14,2.1,1.73,4.8]
[null,"Week 12",2.93,2,3.25,3.41,1.41,4.7699999999999996,5.98,4.78]
[null,"Week 13",5.14,4.03,1.33,4.47,4.75,3.88,1.03,4.34]
[null,"Week 14",3.51,3.56,4.51,5.27,4.75,5.78,1.02,1.74]
[null,"Week 15",1.48,5.37,1.66,3.99,5.08,5.5,1.53,1.55]
[null,"Week 16",4.82,5.14,5.31,5.64,5.77,2.73,4.34,5.32]
[]
[null,"Week","Week 3"]

{"sheet":"M&I(3an)","index":14,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["13)","INDEX & MATCH to lookup whole column.\nA 0 (zero) in the row_num means take the whole column or \"all the rows\"."]
[]
[null,"Jan","Feb","Mar","April",null,"Month:","April"]
[null,1081.95,619.12,707.45,756.59,null,"Total",{"$f":"SUM(INDEX(B4:E16,0,MATCH(H3,B3:E3,0)))","v":12762.21}]
[null,913.1,730.87,969.9,609.61]
[null,1212.3800000000001,840.17,1222.96,577.57000000000005]
[null,735.08,560.67999999999995,1096.3,1070.3900000000001]
[null,685.48,1225.95,596.01,1009.88]
[null,1088.7,793.41,1010.52,1105.98]
[null,1169.79,983.38,1274.46,1287.75]
[null,1248.8,518.23,946.49,1199.03]
[null,1156.68,578.71,712.75,1223]
[null,651.29,1130.21,637.21,1285.6099999999999]
[null,810.08,843.39,735.55,970.38]
[null,1212.19,534.34,1096.9000000000001,953.78]
[null,549,747.09,723.65,712.64]
[]
["14)","INDEX & MATCH to lookup whole row.\nA 0 (zero) in the column_num means take the whole row or \"all the columns\"."]
[]
[null,"Week","Ratings Team Member 1","Ratings Team Member 2","Ratings Team Member 3","Ratings Team Member 4","Ratings Team Member 5","Ratings Team Member 6","Ratings Team Member 7","Ratings Team Member 8"]
[null,"Week 1",4.51,4.1100000000000003,4.8099999999999996,2.78,4.8899999999999997,5.0999999999999996,1.23,2.2599999999999998]
[null,"Week 2",3.47,1.04,3.42,4.7,5.64,1.1000000000000001,3.3,5.08]
[null,"Week 3",4.5199999999999996,3.45,3.84,2.76,1.7,1.61,3.3,4.92]
[null,"Week 4",1.47,1.99,5.52,2.34,3.26,1.7,5.6,4.09]
[null,"Week 5",5.68,3.72,4.37,2.46,4.5599999999999996,1.59,5.5,1.2]
[null,"Week 6",1.36,3.52,2.0499999999999998,1.61,1.61,2.21,3.62,4.72]
[null,"Week 7",3.07,3.38,4.26,5.25,2.64,2.59,4.63,5.52]
[null,"Week 8",1.06,5.04,4.8499999999999996,3.54,4.38,4.21,1.54,3.66]
[null,"Week 9",1.45,3.77,1.1200000000000001,5.21,3.79,1.87,4.29,2.1]
[null,"Week 10",2.1,3.34,5.5,3.11,3.1,1.57,3.76,1.81]
[null,"Week 11",1.77,4.63,2.58,5.3,5.14,2.1,1.73,4.8]
[null,"Week 12",2.93,2,3.25,3.41,1.41,4.7699999999999996,5.98,4.78]
[null,"Week 13",5.14,4.03,1.33,4.47,4.75,3.88,1.03,4.34]
[null,"Week 14",3.51,3.56,4.51,5.27,4.75,5.78,1.02,1.74]
[null,"Week 15",1.48,5.37,1.66,3.99,5.08,5.5,1.53,1.55]
[null,"Week 16",4.82,5.14,5.31,5.64,5.77,2.73,4.34,5.32]
[]
[null,"Week","Week 3"]
[null,null,{"$f":"SUM(INDEX($C$21:$J$36,MATCH(C38,B21:B36,0),0))","v":26.1}]

{"sheet":"M&I(4)","index":15,"n_rows":23,"n_cols":20,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["15)","INDEX & MATCH to lookup first non-blank"]
["16)","When doing Exact Math lookup when there are duplicates, the first one is returned."]
[]
["First",{"$f":"A4&\" Day\"","v":"First Day"},"Last",{"$f":"C4&\" Day\"","v":"Last Day"},"Stock","Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7","Day 8","Day 9","Day 10","Day 11","Day 12","Day 13","Day 14","Day 15"]
[null,null,null,null,"XRJ stock",19.580000000000002,19.720000000000002,20.05,20.970000000000002,22.540000000000003,23.380000000000003,25.89,24.02,22.08,23.29,22.869999999999997,22.259999999999998,21.009999999999998]
[null,null,null,null,"GML stock",22.080000000000002,21.98,24.19,26.05,26.12,28.43,30.85,32.380000000000003,34.93,37.909999999999997,39.5,41.53,null,41.370000000000005]
[null,null,null,null,"YNO stock",null,16.240000000000002,null,null,20.170000000000005,null,22.480000000000004,22.790000000000003,null,null,null,24.140000000000004]
[null,null,null,null,"OWH stock",null,14.75,14.86,15.129999999999999,13.34,15.31,13.51,14.32,null,null,14.56,14.190000000000001,null,15.06]
[null,null,null,null,"WFN stock",10.029999999999999,9.11,9.0599999999999987,8.4599999999999991,null,9.91,12.42,11.879999999999999,11.1,11.879999999999999,14.049999999999999,16.04,18.649999999999999,19.079999999999998]
[null,null,null,null,"DUN stock",null,null,null,null,22.869999999999997,21.199999999999996,23.939999999999998,22.409999999999997,24.059999999999995,23.039999999999996,25.489999999999995]
[null,null,null,null,"LDX stock",null,null,null,null,32.819999999999993,32.749999999999993,null,33.059999999999995,33.169999999999995,34.379999999999995,37.01,36.57,39.08,40.229999999999997,39.299999999999997]
[null,null,null,null,"PZP stock",null,13.48,13.68,12.43,13.92,14.8,null,15.73,13.97,null,11.850000000000001,null,11.750000000000002,10.970000000000002,12.390000000000002]
[null,null,null,null,"BSN stock",null,null,null,null,null,null,23.259999999999998,26.169999999999998,null,26.65,26,27.16,30.13,null,28.02]
[null,null,null,null,"OFI stock",null,null,null,null,null,null,null,null,24.38,23.52,25.38,null,23.77]
[null,null,null,null,"WNX stock",null,null,null,null,null,null,23.29,21.52,19.669999999999998,18.77,21.419999999999998,22.189999999999998,null,20.709999999999997]
[null,null,null,null,"CSR stock",8.94,9.7099999999999991,8.129999999999999,10.309999999999999,10.399999999999999,11.719999999999999,14.419999999999998,17.04,15.669999999999998,15.199999999999998,16.859999999999996,18.289999999999996]
[null,null,null,null,"SRW stock",null,null,null,null,17.34,19.36,21.73,23.07]
[null,null,null,null,"UQR stock",7.6099999999999994,null,9.2899999999999991,11.479999999999999,10.239999999999998,11.909999999999998,null,14.369999999999997,15.709999999999997,null,null,16.72,15.7]
[null,null,null,null,"DBZ stock",null,28.57,31.17,null,null,32.659999999999997,34.51,null,38.950000000000003,38.56,36.85,39.61,40.96,40.840000000000003]
[null,null,null,null,"XFB stock",null,null,null,null,null,null,null,12.190000000000001,14.780000000000001,14.280000000000001,15.490000000000002,15.430000000000001,16.400000000000002,17.690000000000001,17.73]
[null,null,null,null,"FZM stock",16.170000000000002,17.080000000000002,17.770000000000003,20.190000000000005,22.270000000000003,20.970000000000002,22.320000000000004,23.710000000000004,26.300000000000004,27.040000000000003,null,30.03,29.64,28.400000000000002]
[null,null,null,null,"HMM stock",null,null,null,null,null,23.440000000000005,22.520000000000003,24.830000000000002,26.57,27.25,29.22,null,31.729999999999997,34.15,34.6]
[null,null,null,null,"WGJ stock",30.37,31.720000000000002,null,31.1,30.18,29.13,null,27.75,29.17,30.900000000000002]

{"sheet":"M&I(4an)","index":16,"n_rows":23,"n_cols":20,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["15)","INDEX & MATCH to lookup first non-blank"]
["16)","When doing Exact Math lookup when there are duplicates, the first one is returned."]
[]
["First",{"$f":"A4&\" Day\"","v":"First Day"},"Last",{"$f":"C4&\" Day\"","v":"Last Day"},"Stock","Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7","Day 8","Day 9","Day 10","Day 11","Day 12","Day 13","Day 14","Day 15"]
[{"$f":"INDEX(F5:T5,MATCH(TRUE,F5:T5<>\"\",0))","v":19.580000000000002},{"$f":"INDEX(F$4:T$4,MATCH(TRUE,F5:T5<>\"\",0))","v":"Day 1"},{"$f":"LOOKUP(100000,E5:T5)","v":21.009999999999998},{"$f":"INDEX(F$4:T$4,MATCH(100000,F5:T5))","v":"Day 13"},"XRJ stock",19.580000000000002,19.720000000000002,20.05,20.970000000000002,22.540000000000003,23.380000000000003,25.89,24.02,22.08,23.29,22.869999999999997,22.259999999999998,21.009999999999998]
[{"$f":"INDEX(F6:T6,MATCH(TRUE,F6:T6<>\"\",0))","v":22.080000000000002},{"$f":"INDEX(F$4:T$4,MATCH(TRUE,F6:T6<>\"\",0))","v":"Day 1"},{"$f":"LOOKUP(100000,E6:T6)","v":41.370000000000005},{"$f":"INDEX(F$4:T$4,MATCH(100000,F6:T6))","v":"Day 14"},"GML stock",22.080000000000002,21.98,24.19,26.05,26.12,28.43,30.85,32.380000000000003,34.93,37.909999999999997,39.5,41.53,null,41.370000000000005]
[{"$f":"INDEX(F7:T7,MATCH(TRUE,F7:T7<>\"\",0))","v":16.240000000000002},{"$f":"INDEX(F$4:T$4,MATCH(TRUE,F7:T7<>\"\",0))","v":"Day 2"},24.140000000000004,"Day 12","YNO stock",null,16.240000000000002,null,null,20.170000000000005,null,22.480000000000004,22.790000000000003,null,null,null,24.140000000000004]
[{"$f":"INDEX(F8:T8,MATCH(TRUE,F8:T8<>\"\",0))","v":14.75},{"$f":"INDEX(F$4:T$4,MATCH(TRUE,F8:T8<>\"\",0))","v":"Day 2"},15.06,"Day 14","OWH stock",null,14.75,14.86,15.129999999999999,13.34,15.31,13.51,14.32,null,null,14.56,14.190000000000001,null,15.06]
[{"$f":"INDEX(F9:T9,MATCH(TRUE,F9:T9<>\"\",0))","v":10.029999999999999},{"$f":"INDEX(F$4:T$4,MATCH(TRUE,F9:T9<>\"\",0))","v":"Day 1"},19.079999999999998,"Day 14","WFN stock",10.029999999999999,9.11,9.0599999999999987,8.4599999999999991,null,9.91,12.42,11.879999999999999,11.1,11.879999999999999,14.049999999999999,16.04,18.649999999999999,19.079999999999998]
[{"$f":"INDEX(F10:T10,MATCH(TRUE,F10:T10<>\"\",0))","v":22.869999999999997},{"$f":"INDEX(F$4:T$4,MATCH(TRUE,F10:T10<>\"\",0))","v":"Day 5"},25.489999999999995,"Day 11","DUN stock",null,null,null,null,22.869999999999997,21.199999999999996,23.939999999999998,22.409999999999997,24.059999999999995,23.039999999999996,25.489999999999995]
[{"$f":"INDEX(F11:T11,MATCH(TRUE,F11:T11<>\"\",0))","v":32.819999999999993},{"$f":"INDEX(F$4:T$4,MATCH(TRUE,F11:T11<>\"\",0))","v":"Day 5"},39.299999999999997,"Day 15","LDX stock",null,null,null,null,32.819999999999993,32.749999999999993,null,33.059999999999995,33.169999999999995,34.379999999999995,37.01,36.57,39.08,40.229999999999997,39.299999999999997]
[{"$f":"INDEX(F12:T12,MATCH(TRUE,F12:T12<>\"\",0))","v":13.48},{"$f":"INDEX(F$4:T$4,MATCH(TRUE,F12:T12<>\"\",0))","v":"Day 2"},12.390000000000002,"Day 15","PZP stock",null,13.48,13.68,12.43,13.92,14.8,null,15.73,13.97,null,11.850000000000001,null,11.750000000000002,10.970000000000002,12.390000000000002]
[{"$f":"INDEX(F13:T13,MATCH(TRUE,F13:T13<>\"\",0))","v":23.259999999999998},{"$f":"INDEX(F$4:T$4,MATCH(TRUE,F13:T13<>\"\",0))","v":"Day 7"},28.02,"Day 15","BSN stock",null,null,null,null,null,null,23.259999999999998,26.169999999999998,null,26.65,26,27.16,30.13,null,28.02]
[{"$f":"INDEX(F14:T14,MATCH(TRUE,F14:T14<>\"\",0))","v":24.38},{"$f":"INDEX(F$4:T$4,MATCH(TRUE,F14:T14<>\"\",0))","v":"Day 9"},23.77,"Day 13","OFI stock",null,null,null,null,null,null,null,null,24.38,23.52,25.38,null,23.77]
[{"$f":"INDEX(F15:T15,MATCH(TRUE,F15:T15<>\"\",0))","v":23.29},{"$f":"INDEX(F$4:T$4,MATCH(TRUE,F15:T15<>\"\",0))","v":"Day 7"},20.709999999999997,"Day 14","WNX stock",null,null,null,null,null,null,23.29,21.52,19.669999999999998,18.77,21.419999999999998,22.189999999999998,null,20.709999999999997]
[{"$f":"INDEX(F16:T16,MATCH(TRUE,F16:T16<>\"\",0))","v":8.94},{"$f":"INDEX(F$4:T$4,MATCH(TRUE,F16:T16<>\"\",0))","v":"Day 1"},18.289999999999996,"Day 12","CSR stock",8.94,9.7099999999999991,8.129999999999999,10.309999999999999,10.399999999999999,11.719999999999999,14.419999999999998,17.04,15.669999999999998,15.199999999999998,16.859999999999996,18.289999999999996]
[{"$f":"INDEX(F17:T17,MATCH(TRUE,F17:T17<>\"\",0))","v":17.34},{"$f":"INDEX(F$4:T$4,MATCH(TRUE,F17:T17<>\"\",0))","v":"Day 5"},23.07,"Day 8","SRW stock",null,null,null,null,17.34,19.36,21.73,23.07]
[{"$f":"INDEX(F18:T18,MATCH(TRUE,F18:T18<>\"\",0))","v":7.6099999999999994},{"$f":"INDEX(F$4:T$4,MATCH(TRUE,F18:T18<>\"\",0))","v":"Day 1"},15.7,"Day 13","UQR stock",7.6099999999999994,null,9.2899999999999991,11.479999999999999,10.239999999999998,11.909999999999998,null,14.369999999999997,15.709999999999997,null,null,16.72,15.7]
[{"$f":"INDEX(F19:T19,MATCH(TRUE,F19:T19<>\"\",0))","v":28.57},{"$f":"INDEX(F$4:T$4,MATCH(TRUE,F19:T19<>\"\",0))","v":"Day 2"},40.840000000000003,"Day 14","DBZ stock",null,28.57,31.17,null,null,32.659999999999997,34.51,null,38.950000000000003,38.56,36.85,39.61,40.96,40.840000000000003]
[{"$f":"INDEX(F20:T20,MATCH(TRUE,F20:T20<>\"\",0))","v":12.190000000000001},{"$f":"INDEX(F$4:T$4,MATCH(TRUE,F20:T20<>\"\",0))","v":"Day 8"},17.73,"Day 15","XFB stock",null,null,null,null,null,null,null,12.190000000000001,14.780000000000001,14.280000000000001,15.490000000000002,15.430000000000001,16.400000000000002,17.690000000000001,17.73]
[{"$f":"INDEX(F21:T21,MATCH(TRUE,F21:T21<>\"\",0))","v":16.170000000000002},{"$f":"INDEX(F$4:T$4,MATCH(TRUE,F21:T21<>\"\",0))","v":"Day 1"},28.400000000000002,"Day 14","FZM stock",16.170000000000002,17.080000000000002,17.770000000000003,20.190000000000005,22.270000000000003,20.970000000000002,22.320000000000004,23.710000000000004,26.300000000000004,27.040000000000003,null,30.03,29.64,28.400000000000002]
[{"$f":"INDEX(F22:T22,MATCH(TRUE,F22:T22<>\"\",0))","v":23.440000000000005},{"$f":"INDEX(F$4:T$4,MATCH(TRUE,F22:T22<>\"\",0))","v":"Day 6"},34.6,"Day 15","HMM stock",null,null,null,null,null,23.440000000000005,22.520000000000003,24.830000000000002,26.57,27.25,29.22,null,31.729999999999997,34.15,34.6]
[{"$f":"INDEX(F23:T23,MATCH(TRUE,F23:T23<>\"\",0))","v":30.37},{"$f":"INDEX(F$4:T$4,MATCH(TRUE,F23:T23<>\"\",0))","v":"Day 1"},30.900000000000002,"Day 10","WGJ stock",30.37,31.720000000000002,null,31.1,30.18,29.13,null,27.75,29.17,30.900000000000002]

{"sheet":"C(1)","index":17,"n_rows":675,"n_cols":22,"rows_kept":675,"cut":false,"hidden":false,"merged":[]}
["Date","Sales Rep","Sales","Product","Commission",null,null,null,null,null,null,null,null,null,null,null,null,"Rand:"]
["2009-10-16","SR6",5301,"P2",null,null,null,null,"Commissions for P1",null,null,"Products and Table #",null,null,null,null,null,{"$f":"RANDBETWEEN(40100,40150)","v":"2009-10-24"},{"$f":"\"SR\"&RANDBETWEEN(1,6)","v":"SR4"},{"$f":"RANDBETWEEN(VLOOKUP(U2,{\"P1\",0,5000;\"P2\",2000,10000;\"P3\",0,100},2),VLOOKUP(U2,{\"P1\",0,5000;\"P2\",2000,10000;\"P3\",0,100},3))","v":4222},{"$f":"\"P\"&INT(RAND()*3+1)","v":"P1"},{"$f":"VLOOKUP(T2,CHOOSE(VLOOKUP(U2,$L$3:$M$5,2,0),$I$3:$J$6,$I$9:$J$12,$I$15:$J$18),2)","v":0.03}]
["2009-10-22","SR1",49,"P3",null,null,null,null,0,0,null,"P1",1]
["2009-10-18","SR2",4684,"P2",null,null,null,null,100,0.01,null,"P2",2]
["2009-11-14","SR5",89,"P3",null,null,null,null,500,0.02,null,"P3",3]
["2009-11-04","SR5",42,"P1",null,null,null,null,1000,0.03]
["2009-10-31","SR3",3082,"P1"]
["2009-11-26","SR2",3,"P3",null,null,null,null,"Commissions for P2"]
["2009-10-24","SR2",4847,"P1",null,null,null,null,0,0]
["2009-10-28","SR2",1170,"P1",null,null,null,null,4000,0.02]
["2009-11-11","SR2",59,"P3",null,null,null,null,8000,0.03]
["2009-11-22","SR4",5592,"P2",null,null,null,null,9000,4.4999999999999998E-2]
["2009-10-16","SR1",2765,"P1"]
["2009-11-19","SR2",6889,"P2",null,null,null,null,"Commissions for P3"]
["2009-11-18","SR6",1756,"P1",null,null,null,null,0,0]
["2009-10-18","SR4",91,"P3",null,null,null,null,50,5.0000000000000001E-3]
["2009-11-29","SR2",3228,"P2",null,null,null,null,75,0.01]
["2009-10-17","SR6",4875,"P1",null,null,null,null,90,1.4999999999999999E-2]
["2009-11-12","SR5",9246,"P2"]
["2009-11-02","SR3",50,"P3"]
["2009-11-28","SR3",84,"P3"]
["2009-10-26","SR6",1781,"P1"]
["2009-10-18","SR2",3850,"P1"]
["2009-11-15","SR4",1055,"P1"]
["2009-11-05","SR1",4193,"P1"]
["2009-10-31","SR3",34,"P3"]
["2009-11-30","SR6",6017,"P2"]
["2009-10-22","SR3",3420,"P2"]
["2009-11-01","SR4",3203,"P1"]
["2009-11-18","SR3",7477,"P2"]
["2009-12-03","SR2",12,"P3"]
["2009-11-04","SR4",2418,"P2"]
["2009-10-25","SR2",1851,"P1"]
["2009-11-24","SR4",3106,"P2"]
["2009-10-15","SR5",994,"P1"]
["2009-11-30","SR6",2,"P3"]
["2009-10-30","SR2",29,"P3"]
["2009-11-10","SR4",28,"P3"]
["2009-10-18","SR3",73,"P3"]
["2009-11-26","SR2",15,"P3"]
["2009-10-22","SR2",6322,"P2"]
["2009-11-01","SR6",11,"P3"]
["2009-10-23","SR1",1620,"P1"]
["2009-10-27","SR4",554,"P1"]
["2009-11-23","SR5",3029,"P2"]
["2009-10-15","SR5",1174,"P1"]
["2009-11-02","SR2",3471,"P2"]
["2009-11-19","SR2",26,"P3"]
["2009-12-03","SR5",57,"P3"]
["2009-11-25","SR4",3567,"P1"]
["2009-10-31","SR2",3,"P3"]
["2009-10-28","SR6",5715,"P2"]
["2009-11-04","SR3",3396,"P1"]
["2009-11-29","SR4",6054,"P2"]
["2009-11-23","SR3",3770,"P1"]
["2009-10-16","SR5",45,"P3"]
["2009-11-19","SR4",6977,"P2"]
["2009-11-18","SR4",1693,"P1"]
["2009-12-03","SR2",4033,"P2"]
["2009-11-13","SR1",4174,"P2"]
["2009-11-09","SR2",51,"P3"]
["2009-11-26","SR3",4719,"P2"]
["2009-11-28","SR4",9167,"P2"]
["2009-10-21","SR2",7517,"P2"]
["2009-12-01","SR2",4427,"P1"]
["2009-10-14","SR2",5589,"P2"]
["2009-12-02","SR3",3273,"P1"]
["2009-10-29","SR5",9278,"P2"]
["2009-11-26","SR2",4026,"P2"]
["2009-11-16","SR3",6955,"P2"]
["2009-11-02","SR3",7566,"P2"]
["2009-11-03","SR6",7191,"P2"]
["2009-10-20","SR1",4631,"P2"]
["2009-11-13","SR1",2195,"P1"]
["2009-10-14","SR5",1755,"P1"]
["2009-11-17","SR4",18,"P3"]
["2009-11-17","SR3",87,"P3"]
["2009-10-29","SR1",3965,"P1"]
["2009-10-25","SR1",64,"P3"]
["2009-11-13","SR2",5908,"P2"]
["2009-11-09","SR1",1083,"P1"]
["2009-11-03","SR3",72,"P3"]
["2009-11-29","SR6",63,"P3"]
["2009-11-13","SR1",8,"P3"]
["2009-10-25","SR6",36,"P3"]
["2009-11-02","SR2",3354,"P1"]
["2009-11-29","SR3",1758,"P1"]
["2009-11-11","SR5",430,"P1"]
["2009-10-14","SR6",2525,"P1"]
["2009-10-30","SR1",795,"P1"]
["2009-11-05","SR4",6016,"P2"]
["2009-10-27","SR4",3642,"P2"]
["2009-11-14","SR3",9770,"P2"]
["2009-10-28","SR3",2078,"P2"]
["2009-10-22","SR6",45,"P3"]
["2009-11-01","SR5",3858,"P2"]
["2009-11-25","SR1",1941,"P1"]
["2009-10-17","SR5",8029,"P2"]
["2009-11-23","SR6",62,"P3"]
["2009-10-15","SR5",2136,"P1"]
["2009-10-25","SR5",50,"P3"]
["2009-11-15","SR4",13,"P3"]
["2009-11-03","SR5",58,"P3"]
["2009-10-20","SR1",39,"P3"]
["2009-10-19","SR4",505,"P1"]
["2009-12-01","SR6",4104,"P2"]
["2009-11-23","SR1",9460,"P2"]
["2009-11-05","SR1",2498,"P2"]
["2009-10-23","SR1",61,"P3"]
["2009-10-20","SR5",9294,"P2"]
["2009-11-01","SR3",20,"P3"]
["2009-10-22","SR2",75,"P3"]
["2009-10-30","SR5",4866,"P2"]
["2009-11-27","SR4",4713,"P1"]
["2009-11-08","SR2",1811,"P1"]
["2009-12-02","SR3",3580,"P2"]
["2009-11-03","SR3",24,"P3"]
["2009-11-21","SR5",7794,"P2"]
["2009-12-01","SR3",4392,"P2"]
["2009-11-30","SR2",9168,"P2"]
["2009-11-13","SR4",88,"P3"]
["2009-10-27","SR4",4050,"P2"]
["2009-11-29","SR1",89,"P3"]
["2009-11-21","SR6",4847,"P1"]
["2009-11-29","SR1",6899,"P2"]
["2009-11-19","SR2",4817,"P1"]
["2009-11-01","SR2",7729,"P2"]
["2009-11-15","SR4",2078,"P2"]
["2009-11-14","SR1",65,"P3"]
["2009-11-29","SR4",32,"P3"]
["2009-11-03","SR1",0,"P3"]
["2009-10-14","SR3",9457,"P2"]
["2009-11-29","SR3",967,"P1"]
["2009-10-16","SR2",60,"P3"]
["2009-11-05","SR2",397,"P1"]
["2009-11-18","SR5",3638,"P1"]
["2009-11-23","SR6",216,"P1"]
["2009-11-02","SR3",3436,"P1"]
["2009-11-10","SR4",4883,"P1"]
["2009-10-18","SR2",2,"P3"]
["2009-11-12","SR5",9607,"P2"]
["2009-11-28","SR3",66,"P3"]
["2009-10-24","SR4",3775,"P1"]
["2009-11-07","SR4",8745,"P2"]
["2009-11-23","SR1",99,"P3"]
["2009-11-23","SR6",323,"P1"]
["2009-10-25","SR2",7003,"P2"]
["2009-10-17","SR1",6744,"P2"]
["2009-11-28","SR5",2566,"P1"]
["2009-11-03","SR1",4969,"P1"]
["2009-11-16","SR1",2775,"P2"]
["2009-11-08","SR2",77,"P3"]
["2009-10-20","SR5",5,"P3"]
["2009-10-24","SR1",5320,"P2"]
["2009-10-16","SR3",47,"P3"]
["2009-11-20","SR2",30,"P3"]
["2009-10-18","SR4",4370,"P1"]
["2009-11-27","SR3",6659,"P2"]
["2009-11-08","SR5",7004,"P2"]
["2009-11-01","SR6",2029,"P1"]
["2009-11-11","SR6",6603,"P2"]
["2009-12-01","SR3",73,"P3"]
["2009-11-12","SR3",4665,"P1"]
["2009-10-25","SR6",5034,"P2"]
["2009-11-05","SR6",2738,"P2"]
["2009-11-25","SR5",3319,"P1"]
["2009-11-16","SR6",6594,"P2"]
["2009-11-03","SR5",4606,"P1"]
["2009-10-27","SR5",2088,"P1"]
["2009-11-15","SR1",56,"P3"]
["2009-11-11","SR5",66,"P3"]
["2009-11-08","SR3",31,"P3"]
["2009-11-25","SR2",8365,"P2"]
["2009-11-22","SR3",68,"P3"]
["2009-11-06","SR6",4107,"P1"]
["2009-11-05","SR3",7134,"P2"]
["2009-11-13","SR6",7277,"P2"]
["2009-11-19","SR5",4730,"P1"]
["2009-10-31","SR3",6457,"P2"]
["2009-11-19","SR5",5423,"P2"]
["2009-12-02","SR1",3775,"P1"]
["2009-11-04","SR4",2394,"P1"]
["2009-11-17","SR6",984,"P1"]
["2009-11-19","SR1",4928,"P1"]
["2009-10-28","SR6",2442,"P1"]
["2009-11-12","SR1",8535,"P2"]
["2009-10-18","SR3",4032,"P1"]
["2009-10-21","SR1",2412,"P1"]
["2009-11-22","SR1",0,"P3"]
["2009-10-22","SR2",3573,"P1"]
["2009-11-01","SR5",8145,"P2"]
["2009-12-02","SR5",7109,"P2"]
["2009-10-16","SR1",3015,"P1"]
["2009-11-29","SR5",2557,"P1"]
["2009-10-18","SR5",3316,"P2"]
["2009-11-26","SR4",0,"P3"]
["2009-10-21","SR2",60,"P3"]
["2009-11-02","SR5",4285,"P2"]
["2009-11-05","SR4",3209,"P1"]
["2009-10-20","SR2",45,"P3"]
["2009-10-28","SR4",746,"P1"]
["2009-11-22","SR1",8895,"P2"]
["2009-12-03","SR4",52,"P3"]
["2009-11-08","SR3",7489,"P2"]
["2009-12-03","SR3",81,"P3"]
["2009-10-18","SR5",988,"P1"]
["2009-10-31","SR2",3979,"P1"]
["2009-10-20","SR6",4295,"P1"]
["2009-10-22","SR1",3593,"P2"]
["2009-11-23","SR1",8671,"P2"]
["2009-11-28","SR6",41,"P3"]
["2009-11-11","SR6",86,"P3"]
["2009-11-11","SR6",51,"P3"]
["2009-11-20","SR6",37,"P3"]
["2009-11-23","SR6",37,"P3"]
["2009-11-01","SR3",96,"P3"]
["2009-12-02","SR2",2787,"P2"]
["2009-10-29","SR2",4044,"P1"]
["2009-10-28","SR4",2989,"P1"]
["2009-11-30","SR1",9492,"P2"]
["2009-11-28","SR5",68,"P3"]
["2009-11-25","SR2",4880,"P1"]
["2009-11-29","SR3",6221,"P2"]
["2009-12-01","SR1",72,"P3"]
["2009-12-03","SR1",990,"P1"]
["2009-10-31","SR6",2802,"P1"]
["2009-11-18","SR6",9521,"P2"]
["2009-12-02","SR2",2496,"P1"]
["2009-11-23","SR1",8286,"P2"]
["2009-12-03","SR5",9995,"P2"]
["2009-11-15","SR1",3451,"P2"]
["2009-11-21","SR2",37,"P3"]
["2009-11-12","SR1",4330,"P1"]
["2009-11-03","SR2",2003,"P1"]
["2009-11-15","SR3",41,"P3"]
["2009-11-12","SR2",4393,"P1"]
["2009-12-02","SR6",1536,"P1"]
["2009-11-07","SR5",4445,"P1"]
["2009-10-25","SR3",2421,"P2"]
["2009-11-27","SR4",99,"P3"]
["2009-11-06","SR1",8257,"P2"]
["2009-10-25","SR2",2738,"P1"]
["2009-10-22","SR5",5763,"P2"]
["2009-10-27","SR5",1667,"P1"]
["2009-11-17","SR3",1315,"P1"]
["2009-11-13","SR4",66,"P3"]
["2009-11-01","SR4",67,"P3"]
["2009-11-16","SR6",3205,"P1"]
["2009-11-30","SR3",20,"P1"]
["2009-11-03","SR3",19,"P3"]
["2009-10-28","SR3",81,"P3"]
["2009-10-21","SR1",9080,"P2"]
["2009-11-05","SR2",923,"P1"]
["2009-11-02","SR2",54,"P3"]
["2009-11-04","SR6",76,"P3"]
["2009-12-01","SR5",2088,"P1"]
["2009-11-13","SR5",64,"P3"]
["2009-12-03","SR4",9237,"P2"]
["2009-11-03","SR6",4419,"P1"]
["2009-11-10","SR6",4112,"P1"]
["2009-10-30","SR1",4974,"P2"]
["2009-10-20","SR1",4048,"P1"]
["2009-11-11","SR6",2308,"P2"]
["2009-10-31","SR4",3350,"P1"]
["2009-10-15","SR5",4506,"P1"]
["2009-12-01","SR2",95,"P3"]
["2009-11-17","SR5",2875,"P1"]
["2009-12-03","SR1",3714,"P1"]
["2009-10-29","SR2",677,"P1"]
["2009-11-13","SR6",4604,"P1"]
["2009-11-17","SR5",9322,"P2"]
["2009-11-25","SR4",7174,"P2"]
["2009-10-26","SR3",2252,"P1"]
["2009-10-29","SR5",54,"P3"]
["2009-11-04","SR5",56,"P3"]
["2009-11-14","SR4",67,"P3"]
["2009-10-30","SR5",933,"P1"]
["2009-10-17","SR6",25,"P3"]
["2009-10-26","SR3",3094,"P1"]
["2009-11-08","SR5",311,"P1"]
["2009-10-26","SR6",8236,"P2"]
["2009-11-24","SR1",48,"P3"]
["2009-11-12","SR6",2131,"P1"]
["2009-11-09","SR5",5286,"P2"]
["2009-11-23","SR3",47,"P3"]
["2009-10-26","SR2",2662,"P1"]
["2009-11-27","SR1",3752,"P1"]
["2009-12-02","SR2",3437,"P2"]
["2009-11-01","SR2",2557,"P1"]
["2009-10-23","SR5",7987,"P2"]
["2009-10-25","SR6",81,"P3"]
["2009-10-15","SR5",14,"P3"]
["2009-11-15","SR3",65,"P3"]
["2009-11-28","SR5",8263,"P2"]
["2009-10-31","SR2",56,"P3"]
["2009-11-18","SR2",3763,"P1"]
["2009-11-09","SR2",2566,"P1"]
["2009-11-19","SR2",2289,"P2"]
["2009-11-29","SR1",25,"P3"]
["2009-11-29","SR2",4,"P3"]
["2009-11-02","SR2",65,"P3"]
["2009-11-23","SR1",2737,"P2"]
["2009-10-19","SR3",10,"P3"]
["2009-11-28","SR2",2957,"P1"]
["2009-11-02","SR6",1004,"P1"]
["2009-10-16","SR1",8797,"P2"]
["2009-10-24","SR1",5816,"P2"]
["2009-10-23","SR3",4666,"P2"]
["2009-10-16","SR4",8328,"P2"]
["2009-11-20","SR1",4874,"P1"]
["2009-10-30","SR5",44,"P3"]
["2009-10-26","SR3",86,"P3"]
["2009-11-23","SR2",379,"P1"]
["2009-11-09","SR6",7935,"P2"]
["2009-10-30","SR1",2764,"P1"]
["2009-11-23","SR4",48,"P3"]
["2009-11-23","SR3",57,"P3"]
["2009-10-28","SR3",91,"P3"]
["2009-10-27","SR2",4787,"P1"]
["2009-11-02","SR3",5065,"P2"]
["2009-10-31","SR1",15,"P3"]
["2009-10-19","SR6",2210,"P1"]
["2009-11-12","SR6",4815,"P2"]
["2009-11-06","SR3",1538,"P1"]
["2009-10-24","SR4",9998,"P2"]
["2009-11-06","SR1",27,"P3"]
["2009-11-04","SR1",3118,"P1"]
["2009-11-21","SR5",69,"P3"]
["2009-11-03","SR3",9482,"P2"]
["2009-10-24","SR3",2466,"P1"]
["2009-11-18","SR2",2202,"P2"]
["2009-11-20","SR4",1174,"P1"]
["2009-11-25","SR1",41,"P3"]
["2009-11-30","SR6",100,"P3"]
["2009-11-22","SR6",7194,"P2"]
["2009-10-18","SR5",65,"P3"]
["2009-11-19","SR6",60,"P3"]
["2009-11-25","SR6",7372,"P2"]
["2009-11-06","SR3",47,"P3"]
["2009-12-02","SR3",8678,"P2"]
["2009-11-21","SR5",2127,"P1"]
["2009-10-14","SR1",3856,"P1"]
["2009-11-11","SR5",71,"P3"]
["2009-11-26","SR5",1856,"P1"]
["2009-11-06","SR4",1704,"P1"]
["2009-10-16","SR5",6,"P3"]
["2009-11-27","SR3",2374,"P2"]
["2009-10-24","SR3",83,"P3"]
["2009-10-16","SR3",125,"P1"]
["2009-11-15","SR5",59,"P3"]
["2009-11-11","SR6",3594,"P2"]
["2009-11-22","SR5",4989,"P1"]
["2009-11-06","SR4",6327,"P2"]
["2009-11-24","SR6",1904,"P1"]
["2009-11-15","SR1",2176,"P2"]
["2009-11-04","SR6",6696,"P2"]
["2009-10-27","SR2",6799,"P2"]
["2009-10-20","SR3",6476,"P2"]
["2009-11-12","SR6",210,"P1"]
["2009-10-15","SR4",2290,"P2"]
["2009-10-31","SR3",53,"P3"]
["2009-11-25","SR3",93,"P3"]
["2009-11-02","SR2",99,"P3"]
["2009-10-16","SR6",6369,"P2"]
["2009-11-14","SR6",268,"P1"]
["2009-10-21","SR6",35,"P3"]
["2009-11-06","SR4",6733,"P2"]
["2009-10-14","SR3",9529,"P2"]
["2009-10-26","SR3",7000,"P2"]
["2009-10-21","SR4",27,"P3"]
["2009-10-24","SR3",8655,"P2"]
["2009-10-27","SR1",8823,"P2"]
["2009-11-06","SR4",1970,"P1"]
["2009-11-15","SR5",4838,"P1"]
["2009-11-07","SR3",4180,"P1"]
["2009-11-15","SR6",2651,"P1"]
["2009-10-25","SR2",3877,"P1"]
["2009-11-19","SR3",9366,"P2"]
["2009-11-23","SR5",3298,"P2"]
["2009-11-26","SR2",5017,"P2"]
["2009-11-28","SR4",4229,"P2"]
["2009-11-02","SR2",42,"P3"]
["2009-11-23","SR5",8074,"P2"]
["2009-10-23","SR6",5231,"P2"]
["2009-10-29","SR1",4747,"P1"]
["2009-10-20","SR1",6235,"P2"]
["2009-11-04","SR2",9208,"P2"]
["2009-10-19","SR3",81,"P3"]
["2009-10-22","SR6",4793,"P1"]
["2009-11-30","SR4",3670,"P2"]
["2009-10-14","SR5",8058,"P2"]
["2009-11-04","SR3",66,"P3"]
["2009-10-16","SR2",1176,"P1"]
["2009-10-20","SR2",2,"P3"]
["2009-10-31","SR3",58,"P3"]
["2009-10-25","SR1",8590,"P2"]
["2009-11-21","SR6",4370,"P1"]
["2009-11-16","SR1",5247,"P2"]
["2009-12-02","SR1",20,"P3"]
["2009-11-14","SR2",18,"P3"]
["2009-11-14","SR2",8979,"P2"]
["2009-10-29","SR3",47,"P3"]
["2009-10-21","SR2",99,"P3"]
["2009-11-19","SR2",4540,"P1"]
["2009-11-27","SR2",1605,"P1"]
["2009-11-11","SR2",3343,"P2"]
["2009-11-29","SR1",7203,"P2"]
["2009-12-02","SR4",788,"P1"]
["2009-11-15","SR3",5888,"P2"]
["2009-10-19","SR3",3014,"P1"]
["2009-11-13","SR4",4696,"P1"]
["2009-11-08","SR6",1937,"P1"]
["2009-10-17","SR3",4595,"P1"]
["2009-11-08","SR3",8803,"P2"]
["2009-11-20","SR6",2928,"P1"]
["2009-12-01","SR2",5675,"P2"]
["2009-10-21","SR5",2083,"P1"]
["2009-11-25","SR4",4566,"P1"]
["2009-11-09","SR5",7706,"P2"]
["2009-12-03","SR4",4447,"P1"]
["2009-11-02","SR4",5375,"P2"]
["2009-10-31","SR4",2626,"P1"]
["2009-11-21","SR1",1407,"P1"]
["2009-10-27","SR6",2302,"P1"]
["2009-11-21","SR6",8,"P3"]
["2009-10-24","SR3",68,"P3"]
["2009-11-15","SR2",8773,"P2"]
["2009-11-27","SR4",48,"P3"]
["2009-11-12","SR1",9397,"P2"]
["2009-10-18","SR6",3658,"P2"]
["2009-10-15","SR2",5952,"P2"]
["2009-12-02","SR5",5822,"P2"]
["2009-11-28","SR3",4804,"P1"]
["2009-11-06","SR2",64,"P3"]
["2009-11-27","SR4",43,"P3"]
["2009-10-23","SR2",6667,"P2"]
["2009-11-17","SR5",443,"P1"]
["2009-11-21","SR3",13,"P3"]
["2009-11-18","SR4",1039,"P1"]
["2009-11-16","SR3",2655,"P1"]
["2009-11-28","SR5",31,"P3"]
["2009-11-14","SR3",27,"P3"]
["2009-10-18","SR1",166,"P1"]
["2009-12-01","SR4",68,"P3"]
["2009-11-12","SR6",1166,"P1"]
["2009-10-15","SR5",3173,"P1"]
["2009-11-16","SR4",75,"P3"]
["2009-11-27","SR2",1530,"P1"]
["2009-10-17","SR6",4799,"P2"]
["2009-11-02","SR6",3994,"P2"]
["2009-11-28","SR2",88,"P3"]
["2009-12-01","SR5",3119,"P1"]
["2009-11-11","SR1",1332,"P1"]
["2009-11-10","SR4",9948,"P2"]
["2009-10-20","SR3",1083,"P1"]
["2009-11-13","SR4",80,"P3"]
["2009-11-26","SR2",52,"P1"]
["2009-10-16","SR1",8341,"P2"]
["2009-11-17","SR4",87,"P3"]
["2009-11-03","SR4",9063,"P2"]
["2009-11-04","SR1",9757,"P2"]
["2009-10-23","SR5",93,"P3"]
["2009-11-27","SR4",2108,"P1"]
["2009-11-14","SR5",52,"P3"]
["2009-10-14","SR4",3090,"P1"]
["2009-12-03","SR5",4263,"P2"]
["2009-11-16","SR6",3994,"P1"]
["2009-10-16","SR4",65,"P3"]
["2009-11-20","SR6",64,"P3"]
["2009-11-30","SR4",9268,"P2"]
["2009-11-16","SR2",4002,"P1"]
["2009-10-21","SR4",97,"P3"]
["2009-11-11","SR6",6192,"P2"]
["2009-10-21","SR1",2704,"P1"]
["2009-11-22","SR5",3634,"P2"]
["2009-11-08","SR3",8180,"P2"]
["2009-11-28","SR4",5932,"P2"]
["2009-11-10","SR2",812,"P1"]
["2009-12-01","SR4",2263,"P2"]
["2009-11-10","SR5",8411,"P2"]
["2009-12-02","SR4",68,"P3"]
["2009-10-29","SR2",46,"P3"]
["2009-11-27","SR3",7135,"P2"]
["2009-11-19","SR6",6125,"P2"]
["2009-11-22","SR4",3393,"P1"]
["2009-11-26","SR5",2987,"P1"]
["2009-11-03","SR1",6,"P3"]
["2009-11-24","SR3",73,"P3"]
["2009-11-22","SR1",2648,"P1"]
["2009-10-27","SR3",9402,"P2"]
["2009-11-05","SR4",81,"P3"]
["2009-11-25","SR4",8053,"P2"]
["2009-10-16","SR5",7793,"P2"]
["2009-10-17","SR6",4715,"P1"]
["2009-10-16","SR4",6844,"P2"]
["2009-10-29","SR2",5921,"P2"]
["2009-12-01","SR1",2295,"P1"]
["2009-10-24","SR5",6537,"P2"]
["2009-12-03","SR2",2385,"P1"]
["2009-11-20","SR2",2000,"P2"]
["2009-11-19","SR2",24,"P3"]
["2009-11-06","SR4",61,"P3"]
["2009-11-17","SR6",7776,"P2"]
["2009-11-27","SR3",88,"P3"]
["2009-10-26","SR4",4465,"P1"]
["2009-11-01","SR3",31,"P3"]
["2009-11-19","SR4",7787,"P2"]
["2009-10-20","SR1",2587,"P2"]
["2009-11-28","SR2",3841,"P1"]
["2009-11-18","SR5",5043,"P2"]
["2009-12-02","SR6",4448,"P2"]
["2009-11-07","SR6",7477,"P2"]
["2009-11-07","SR6",3895,"P1"]
["2009-11-22","SR6",4747,"P1"]
["2009-11-06","SR2",1855,"P1"]
["2009-11-01","SR5",88,"P3"]
["2009-11-12","SR2",38,"P3"]
["2009-10-18","SR2",11,"P3"]
["2009-10-19","SR5",82,"P3"]
["2009-10-28","SR1",81,"P3"]
["2009-10-26","SR6",89,"P3"]
["2009-11-26","SR6",4910,"P1"]
["2009-10-28","SR3",1250,"P1"]
["2009-10-26","SR1",8340,"P2"]
["2009-11-19","SR3",3783,"P2"]
["2009-12-03","SR5",4327,"P1"]
["2009-11-16","SR2",7067,"P2"]
["2009-11-20","SR4",9603,"P2"]
["2009-11-04","SR4",4716,"P1"]
["2009-10-22","SR5",6408,"P2"]
["2009-11-09","SR2",7910,"P2"]
["2009-10-25","SR1",7771,"P2"]
["2009-11-08","SR3",47,"P3"]
["2009-11-28","SR3",3954,"P1"]
["2009-11-30","SR6",3308,"P1"]
["2009-10-18","SR4",52,"P3"]
["2009-11-15","SR3",7344,"P2"]
["2009-10-16","SR6",8602,"P2"]
["2009-11-19","SR4",7436,"P2"]
["2009-10-23","SR4",60,"P3"]
["2009-10-23","SR3",93,"P3"]
["2009-11-28","SR6",2,"P3"]
["2009-10-18","SR4",771,"P1"]
["2009-10-19","SR1",472,"P1"]
["2009-11-22","SR2",1401,"P1"]
["2009-11-02","SR4",6935,"P2"]
["2009-11-13","SR2",85,"P3"]
["2009-12-01","SR2",1953,"P1"]
["2009-10-17","SR4",2670,"P1"]
["2009-11-04","SR3",5152,"P2"]
["2009-11-06","SR6",1974,"P1"]
["2009-11-04","SR3",7996,"P2"]
["2009-10-22","SR2",4253,"P1"]
["2009-10-24","SR6",4474,"P1"]
["2009-11-16","SR5",3547,"P1"]
["2009-11-27","SR6",5703,"P2"]
["2009-11-07","SR4",3537,"P1"]
["2009-10-27","SR5",4042,"P2"]
["2009-11-12","SR1",8034,"P2"]
["2009-11-25","SR1",13,"P3"]
["2009-11-21","SR6",38,"P3"]
["2009-10-23","SR6",8958,"P2"]
["2009-11-28","SR5",46,"P3"]
["2009-11-16","SR6",6132,"P2"]
["2009-11-01","SR4",2508,"P2"]
["2009-10-20","SR6",13,"P3"]
["2009-11-11","SR4",83,"P3"]
["2009-11-22","SR5",7280,"P2"]
["2009-10-24","SR3",42,"P3"]
["2009-11-25","SR1",3508,"P1"]
["2009-11-29","SR4",6562,"P2"]
["2009-11-01","SR5",121,"P1"]
["2009-11-26","SR1",2872,"P2"]
["2009-11-28","SR5",6,"P3"]
["2009-11-03","SR5",66,"P3"]
["2009-11-20","SR2",9540,"P2"]
["2009-11-11","SR2",71,"P3"]
["2009-12-02","SR4",83,"P3"]
["2009-11-30","SR3",5697,"P2"]
["2009-12-02","SR6",2821,"P1"]
["2009-11-20","SR4",57,"P3"]
["2009-11-14","SR1",3391,"P1"]
["2009-10-20","SR5",3925,"P2"]
["2009-10-21","SR2",3149,"P1"]
["2009-10-20","SR2",373,"P1"]
["2009-11-15","SR4",8050,"P2"]
["2009-11-13","SR1",1580,"P1"]
["2009-10-17","SR5",2777,"P1"]
["2009-11-28","SR4",4258,"P2"]
["2009-10-18","SR3",8174,"P2"]
["2009-11-28","SR6",37,"P3"]
["2009-10-26","SR2",87,"P3"]
["2009-10-20","SR1",2246,"P1"]
["2009-11-22","SR6",3405,"P1"]
["2009-10-29","SR1",229,"P1"]
["2009-10-16","SR1",36,"P3"]
["2009-10-16","SR2",40,"P3"]
["2009-10-17","SR3",4116,"P1"]
["2009-11-14","SR4",45,"P3"]
["2009-10-26","SR3",82,"P3"]
["2009-10-22","SR5",63,"P3"]
["2009-10-29","SR6",2631,"P1"]
["2009-10-31","SR2",7095,"P2"]
["2009-11-16","SR5",4946,"P2"]
["2009-11-28","SR1",1232,"P1"]
["2009-10-24","SR1",3985,"P2"]
["2009-11-06","SR3",2010,"P1"]
["2009-10-22","SR2",6356,"P2"]
["2009-11-06","SR4",1707,"P1"]
["2009-10-15","SR3",5674,"P2"]
["2009-11-25","SR6",5391,"P2"]
["2009-10-24","SR6",782,"P1"]
["2009-11-21","SR2",5914,"P2"]
["2009-10-22","SR5",9133,"P2"]
["2009-10-18","SR1",4542,"P1"]
["2009-10-16","SR1",6372,"P2"]
["2009-12-02","SR5",64,"P3"]
["2009-10-22","SR1",68,"P3"]
["2009-11-17","SR5",1850,"P1"]
["2009-11-01","SR3",575,"P1"]
["2009-10-23","SR1",31,"P3"]
["2009-11-03","SR2",9212,"P2"]
["2009-11-25","SR3",4216,"P1"]
["2009-11-25","SR5",6408,"P2"]
["2009-11-19","SR2",3083,"P1"]
["2009-10-20","SR3",7277,"P2"]
["2009-11-08","SR2",19,"P3"]
["2009-12-01","SR3",946,"P1"]
["2009-10-16","SR3",44,"P3"]
["2009-10-29","SR3",3269,"P1"]
["2009-10-30","SR1",83,"P3"]
["2009-11-03","SR3",37,"P3"]
["2009-11-17","SR4",7050,"P2"]
["2009-10-15","SR4",20,"P3"]
["2009-11-26","SR4",4268,"P1"]
["2009-11-07","SR3",68,"P3"]
["2009-11-04","SR1",89,"P3"]
["2009-12-02","SR6",5809,"P2"]
["2009-11-10","SR3",46,"P3"]
["2009-10-25","SR5",34,"P3"]
["2009-11-14","SR6",49,"P3"]
["2009-10-24","SR4",8460,"P2"]
["2009-11-20","SR1",1026,"P1"]
["2009-11-20","SR3",12,"P3"]
["2009-10-15","SR4",5225,"P2"]
["2009-10-17","SR4",6096,"P2"]
["2009-10-17","SR3",4434,"P1"]
["2009-10-18","SR3",2335,"P1"]
["2009-10-27","SR1",1563,"P1"]
["2009-11-19","SR2",72,"P3"]
["2009-10-18","SR3",3250,"P1"]
["2009-10-23","SR6",71,"P3"]
["2009-10-24","SR3",9316,"P2"]
["2009-10-27","SR3",2860,"P1"]
["2009-10-21","SR1",9969,"P2"]
["2009-10-22","SR6",8693,"P2"]
["2009-11-24","SR6",2018,"P2"]
["2009-11-14","SR3",4014,"P2"]
["2009-11-17","SR4",4201,"P1"]
["2009-11-11","SR1",2,"P3"]
["2009-10-23","SR3",1615,"P1"]
["2009-10-29","SR3",4005,"P1"]
["2009-11-10","SR3",9789,"P2"]
["2009-10-17","SR1",4414,"P1"]
["2009-10-25","SR2",3598,"P1"]
["2009-11-13","SR1",1384,"P1"]
["2009-11-07","SR4",92,"P3"]
["2009-11-18","SR1",5,"P3"]
["2009-10-21","SR2",2421,"P1"]
["2009-10-14","SR4",5920,"P2"]
["2009-10-17","SR5",44,"P3"]
["2009-10-20","SR1",4921,"P1"]
["2009-11-22","SR3",47,"P3"]
["2009-11-11","SR3",9146,"P2"]
["2009-11-16","SR5",2517,"P1"]

{"sheet":"C(1an)","index":18,"n_rows":675,"n_cols":22,"rows_kept":675,"cut":false,"hidden":false,"merged":[]}
["Date","Sales Rep","Sales","Product","Commission",null,null,null,null,null,null,null,null,null,null,null,null,"Rand:"]
["2009-10-16","SR6",5301,"P2",{"$f":"VLOOKUP(C2,CHOOSE(VLOOKUP(D2,$L$3:$M$5,2,0),$I$3:$J$6,$I$9:$J$12,$I$15:$J$18),2)*C2","v":106.02},null,null,null,"Commissions for P1",null,null,"Products and Table #",null,null,null,null,null,{"$f":"RANDBETWEEN(40100,40150)","v":"2009-11-28"},{"$f":"\"SR\"&RANDBETWEEN(1,6)","v":"SR3"},{"$f":"RANDBETWEEN(VLOOKUP(U2,{\"P1\",0,5000;\"P2\",2000,10000;\"P3\",0,100},2),VLOOKUP(U2,{\"P1\",0,5000;\"P2\",2000,10000;\"P3\",0,100},3))","v":62},{"$f":"\"P\"&INT(RAND()*3+1)","v":"P3"},{"$f":"VLOOKUP(T2,CHOOSE(VLOOKUP(U2,$L$3:$M$5,2,0),$I$3:$J$6,$I$9:$J$12,$I$15:$J$18),2)","v":5.0000000000000001E-3}]
["2009-10-22","SR1",49,"P3",{"$f":"VLOOKUP(C3,CHOOSE(VLOOKUP(D3,$L$3:$M$5,2,0),$I$3:$J$6,$I$9:$J$12,$I$15:$J$18),2)*C3","v":0},null,null,null,0,0,null,"P1",1]
["2009-10-18","SR2",4684,"P2",93.68,null,null,null,100,0.01,null,"P2",2]
["2009-11-14","SR5",89,"P3",0.89,null,null,null,500,0.02,null,"P3",3]
["2009-11-04","SR5",42,"P1",0,null,null,null,1000,0.03]
["2009-10-31","SR3",3082,"P1",92.46]
["2009-11-26","SR2",3,"P3",0,null,null,null,"Commissions for P2"]
["2009-10-24","SR2",4847,"P1",145.41,null,null,null,0,0]
["2009-10-28","SR2",1170,"P1",35.1,null,null,null,4000,0.02]
["2009-11-11","SR2",59,"P3",0.29499999999999998,null,null,null,8000,0.03]
["2009-11-22","SR4",5592,"P2",111.84,null,null,null,9000,4.4999999999999998E-2]
["2009-10-16","SR1",2765,"P1",82.95]
["2009-11-19","SR2",6889,"P2",137.78,null,null,null,"Commissions for P3"]
["2009-11-18","SR6",1756,"P1",52.68,null,null,null,0,0]
["2009-10-18","SR4",91,"P3",1.365,null,null,null,50,5.0000000000000001E-3]
["2009-11-29","SR2",3228,"P2",0,null,null,null,75,0.01]
["2009-10-17","SR6",4875,"P1",146.25,null,null,null,90,1.4999999999999999E-2]
["2009-11-12","SR5",9246,"P2",416.07]
["2009-11-02","SR3",50,"P3",0.25]
["2009-11-28","SR3",84,"P3",0.84]
["2009-10-26","SR6",1781,"P1",53.43]
["2009-10-18","SR2",3850,"P1",115.5]
["2009-11-15","SR4",1055,"P1",31.65]
["2009-11-05","SR1",4193,"P1",125.78999999999999]
["2009-10-31","SR3",34,"P3",0]
["2009-11-30","SR6",6017,"P2",120.34]
["2009-10-22","SR3",3420,"P2",0]
["2009-11-01","SR4",3203,"P1",96.09]
["2009-11-18","SR3",7477,"P2",149.54]
["2009-12-03","SR2",12,"P3",0]
["2009-11-04","SR4",2418,"P2",0]
["2009-10-25","SR2",1851,"P1",55.53]
["2009-11-24","SR4",3106,"P2",0]
["2009-10-15","SR5",994,"P1",19.88]
["2009-11-30","SR6",2,"P3",0]
["2009-10-30","SR2",29,"P3",0]
["2009-11-10","SR4",28,"P3",0]
["2009-10-18","SR3",73,"P3",0.36499999999999999]
["2009-11-26","SR2",15,"P3",0]
["2009-10-22","SR2",6322,"P2",126.44]
["2009-11-01","SR6",11,"P3",0]
["2009-10-23","SR1",1620,"P1",48.6]
["2009-10-27","SR4",554,"P1",11.08]
["2009-11-23","SR5",3029,"P2",0]
["2009-10-15","SR5",1174,"P1",35.22]
["2009-11-02","SR2",3471,"P2",0]
["2009-11-19","SR2",26,"P3",0]
["2009-12-03","SR5",57,"P3",0.28500000000000003]
["2009-11-25","SR4",3567,"P1",107.00999999999999]
["2009-10-31","SR2",3,"P3",0]
["2009-10-28","SR6",5715,"P2",114.3]
["2009-11-04","SR3",3396,"P1",101.88]
["2009-11-29","SR4",6054,"P2",121.08]
["2009-11-23","SR3",3770,"P1",113.1]
["2009-10-16","SR5",45,"P3",0]
["2009-11-19","SR4",6977,"P2",139.54]
["2009-11-18","SR4",1693,"P1",50.79]
["2009-12-03","SR2",4033,"P2",80.66]
["2009-11-13","SR1",4174,"P2",83.48]
["2009-11-09","SR2",51,"P3",0.255]
["2009-11-26","SR3",4719,"P2",94.38]
["2009-11-28","SR4",9167,"P2",412.51499999999999]
["2009-10-21","SR2",7517,"P2",150.34]
["2009-12-01","SR2",4427,"P1",132.81]
["2009-10-14","SR2",5589,"P2",111.78]
["2009-12-02","SR3",3273,"P1",{"$f":"VLOOKUP(C67,CHOOSE(VLOOKUP(D67,$L$3:$M$5,2,0),$I$3:$J$6,$I$9:$J$12,$I$15:$J$18),2)*C67","v":98.19}]
["2009-10-29","SR5",9278,"P2",417.51]
["2009-11-26","SR2",4026,"P2",80.52]
["2009-11-16","SR3",6955,"P2",139.1]
["2009-11-02","SR3",7566,"P2",151.32]
["2009-11-03","SR6",7191,"P2",143.82]
["2009-10-20","SR1",4631,"P2",92.62]
["2009-11-13","SR1",2195,"P1",65.849999999999994]
["2009-10-14","SR5",1755,"P1",52.65]
["2009-11-17","SR4",18,"P3",0]
["2009-11-17","SR3",87,"P3",0.87]
["2009-10-29","SR1",3965,"P1",118.94999999999999]
["2009-10-25","SR1",64,"P3",0.32]
["2009-11-13","SR2",5908,"P2",118.16]
["2009-11-09","SR1",1083,"P1",32.49]
["2009-11-03","SR3",72,"P3",0.36]
["2009-11-29","SR6",63,"P3",0.315]
["2009-11-13","SR1",8,"P3",0]
["2009-10-25","SR6",36,"P3",0]
["2009-11-02","SR2",3354,"P1",100.61999999999999]
["2009-11-29","SR3",1758,"P1",52.739999999999995]
["2009-11-11","SR5",430,"P1",4.3]
["2009-10-14","SR6",2525,"P1",75.75]
["2009-10-30","SR1",795,"P1",15.9]
["2009-11-05","SR4",6016,"P2",120.32000000000001]
["2009-10-27","SR4",3642,"P2",0]
["2009-11-14","SR3",9770,"P2",439.65]
["2009-10-28","SR3",2078,"P2",0]
["2009-10-22","SR6",45,"P3",0]
["2009-11-01","SR5",3858,"P2",0]
["2009-11-25","SR1",1941,"P1",58.23]
["2009-10-17","SR5",8029,"P2",240.87]
["2009-11-23","SR6",62,"P3",0.31]
["2009-10-15","SR5",2136,"P1",64.08]
["2009-10-25","SR5",50,"P3",0.25]
["2009-11-15","SR4",13,"P3",0]
["2009-11-03","SR5",58,"P3",0.28999999999999998]
["2009-10-20","SR1",39,"P3",0]
["2009-10-19","SR4",505,"P1",10.1]
["2009-12-01","SR6",4104,"P2",82.08]
["2009-11-23","SR1",9460,"P2",425.7]
["2009-11-05","SR1",2498,"P2",0]
["2009-10-23","SR1",61,"P3",0.30499999999999999]
["2009-10-20","SR5",9294,"P2",418.22999999999996]
["2009-11-01","SR3",20,"P3",0]
["2009-10-22","SR2",75,"P3",0.75]
["2009-10-30","SR5",4866,"P2",97.320000000000007]
["2009-11-27","SR4",4713,"P1",141.38999999999999]
["2009-11-08","SR2",1811,"P1",54.33]
["2009-12-02","SR3",3580,"P2",0]
["2009-11-03","SR3",24,"P3",0]
["2009-11-21","SR5",7794,"P2",155.88]
["2009-12-01","SR3",4392,"P2",87.84]
["2009-11-30","SR2",9168,"P2",412.56]
["2009-11-13","SR4",88,"P3",0.88]
["2009-10-27","SR4",4050,"P2",81]
["2009-11-29","SR1",89,"P3",0.89]
["2009-11-21","SR6",4847,"P1",145.41]
["2009-11-29","SR1",6899,"P2",137.97999999999999]
["2009-11-19","SR2",4817,"P1",144.51]
["2009-11-01","SR2",7729,"P2",154.58000000000001]
["2009-11-15","SR4",2078,"P2",0]
["2009-11-14","SR1",65,"P3",0.32500000000000001]
["2009-11-29","SR4",32,"P3",0]
["2009-11-03","SR1",0,"P3",{"$f":"VLOOKUP(C131,CHOOSE(VLOOKUP(D131,$L$3:$M$5,2,0),$I$3:$J$6,$I$9:$J$12,$I$15:$J$18),2)*C131","v":0}]
["2009-10-14","SR3",9457,"P2",425.565]
["2009-11-29","SR3",967,"P1",19.34]
["2009-10-16","SR2",60,"P3",0.3]
["2009-11-05","SR2",397,"P1",3.97]
["2009-11-18","SR5",3638,"P1",109.14]
["2009-11-23","SR6",216,"P1",2.16]
["2009-11-02","SR3",3436,"P1",103.08]
["2009-11-10","SR4",4883,"P1",146.48999999999998]
["2009-10-18","SR2",2,"P3",0]
["2009-11-12","SR5",9607,"P2",432.315]
["2009-11-28","SR3",66,"P3",0.33]
["2009-10-24","SR4",3775,"P1",113.25]
["2009-11-07","SR4",8745,"P2",262.34999999999997]
["2009-11-23","SR1",99,"P3",1.4849999999999999]
["2009-11-23","SR6",323,"P1",3.23]
["2009-10-25","SR2",7003,"P2",140.06]
["2009-10-17","SR1",6744,"P2",134.88]
["2009-11-28","SR5",2566,"P1",76.98]
["2009-11-03","SR1",4969,"P1",149.07]
["2009-11-16","SR1",2775,"P2",0]
["2009-11-08","SR2",77,"P3",0.77]
["2009-10-20","SR5",5,"P3",0]
["2009-10-24","SR1",5320,"P2",106.4]
["2009-10-16","SR3",47,"P3",0]
["2009-11-20","SR2",30,"P3",0]
["2009-10-18","SR4",4370,"P1",131.1]
["2009-11-27","SR3",6659,"P2",133.18]
["2009-11-08","SR5",7004,"P2",140.08000000000001]
["2009-11-01","SR6",2029,"P1",60.87]
["2009-11-11","SR6",6603,"P2",132.06]
["2009-12-01","SR3",73,"P3",0.36499999999999999]
["2009-11-12","SR3",4665,"P1",139.94999999999999]
["2009-10-25","SR6",5034,"P2",100.68]
["2009-11-05","SR6",2738,"P2",0]
["2009-11-25","SR5",3319,"P1",99.57]
["2009-11-16","SR6",6594,"P2",131.88]
["2009-11-03","SR5",4606,"P1",138.18]
["2009-10-27","SR5",2088,"P1",62.64]
["2009-11-15","SR1",56,"P3",0.28000000000000003]
["2009-11-11","SR5",66,"P3",0.33]
["2009-11-08","SR3",31,"P3",0]
["2009-11-25","SR2",8365,"P2",250.95]
["2009-11-22","SR3",68,"P3",0.34]
["2009-11-06","SR6",4107,"P1",123.21]
["2009-11-05","SR3",7134,"P2",142.68]
["2009-11-13","SR6",7277,"P2",145.54]
["2009-11-19","SR5",4730,"P1",141.9]
["2009-10-31","SR3",6457,"P2",129.14000000000001]
["2009-11-19","SR5",5423,"P2",108.46000000000001]
["2009-12-02","SR1",3775,"P1",113.25]
["2009-11-04","SR4",2394,"P1",71.819999999999993]
["2009-11-17","SR6",984,"P1",19.68]
["2009-11-19","SR1",4928,"P1",147.84]
["2009-10-28","SR6",2442,"P1",73.259999999999991]
["2009-11-12","SR1",8535,"P2",256.05]
["2009-10-18","SR3",4032,"P1",120.96]
["2009-10-21","SR1",2412,"P1",72.36]
["2009-11-22","SR1",0,"P3",0]
["2009-10-22","SR2",3573,"P1",107.19]
["2009-11-01","SR5",8145,"P2",244.35]
["2009-12-02","SR5",7109,"P2",142.18]
["2009-10-16","SR1",3015,"P1",90.45]
["2009-11-29","SR5",2557,"P1",76.709999999999994]
["2009-10-18","SR5",3316,"P2",{"$f":"VLOOKUP(C195,CHOOSE(VLOOKUP(D195,$L$3:$M$5,2,0),$I$3:$J$6,$I$9:$J$12,$I$15:$J$18),2)*C195","v":0}]
["2009-11-26","SR4",0,"P3",0]
["2009-10-21","SR2",60,"P3",0.3]
["2009-11-02","SR5",4285,"P2",85.7]
["2009-11-05","SR4",3209,"P1",96.27]
["2009-10-20","SR2",45,"P3",0]
["2009-10-28","SR4",746,"P1",14.92]
["2009-11-22","SR1",8895,"P2",266.84999999999997]
["2009-12-03","SR4",52,"P3",0.26]
["2009-11-08","SR3",7489,"P2",149.78]
["2009-12-03","SR3",81,"P3",0.81]
["2009-10-18","SR5",988,"P1",19.760000000000002]
["2009-10-31","SR2",3979,"P1",119.36999999999999]
["2009-10-20","SR6",4295,"P1",128.85]
["2009-10-22","SR1",3593,"P2",0]
["2009-11-23","SR1",8671,"P2",260.13]
["2009-11-28","SR6",41,"P3",0]
["2009-11-11","SR6",86,"P3",0.86]
["2009-11-11","SR6",51,"P3",0.255]
["2009-11-20","SR6",37,"P3",0]
["2009-11-23","SR6",37,"P3",0]
["2009-11-01","SR3",96,"P3",1.44]
["2009-12-02","SR2",2787,"P2",0]
["2009-10-29","SR2",4044,"P1",121.32]
["2009-10-28","SR4",2989,"P1",89.67]
["2009-11-30","SR1",9492,"P2",427.14]
["2009-11-28","SR5",68,"P3",0.34]
["2009-11-25","SR2",4880,"P1",146.4]
["2009-11-29","SR3",6221,"P2",124.42]
["2009-12-01","SR1",72,"P3",0.36]
["2009-12-03","SR1",990,"P1",19.8]
["2009-10-31","SR6",2802,"P1",84.06]
["2009-11-18","SR6",9521,"P2",428.44499999999999]
["2009-12-02","SR2",2496,"P1",74.88]
["2009-11-23","SR1",8286,"P2",248.57999999999998]
["2009-12-03","SR5",9995,"P2",449.77499999999998]
["2009-11-15","SR1",3451,"P2",0]
["2009-11-21","SR2",37,"P3",0]
["2009-11-12","SR1",4330,"P1",129.9]
["2009-11-03","SR2",2003,"P1",60.089999999999996]
["2009-11-15","SR3",41,"P3",0]
["2009-11-12","SR2",4393,"P1",131.79]
["2009-12-02","SR6",1536,"P1",46.08]
["2009-11-07","SR5",4445,"P1",133.35]
["2009-10-25","SR3",2421,"P2",0]
["2009-11-27","SR4",99,"P3",1.4849999999999999]
["2009-11-06","SR1",8257,"P2",247.70999999999998]
["2009-10-25","SR2",2738,"P1",82.14]
["2009-10-22","SR5",5763,"P2",115.26]
["2009-10-27","SR5",1667,"P1",50.01]
["2009-11-17","SR3",1315,"P1",39.449999999999996]
["2009-11-13","SR4",66,"P3",0.33]
["2009-11-01","SR4",67,"P3",0.33500000000000002]
["2009-11-16","SR6",3205,"P1",96.149999999999991]
["2009-11-30","SR3",20,"P1",0]
["2009-11-03","SR3",19,"P3",0]
["2009-10-28","SR3",81,"P3",0.81]
["2009-10-21","SR1",9080,"P2",408.59999999999997]
["2009-11-05","SR2",923,"P1",18.46]
["2009-11-02","SR2",54,"P3",0.27]
["2009-11-04","SR6",76,"P3",0.76]
["2009-12-01","SR5",2088,"P1",62.64]
["2009-11-13","SR5",64,"P3",0.32]
["2009-12-03","SR4",9237,"P2",415.66499999999996]
["2009-11-03","SR6",4419,"P1",{"$f":"VLOOKUP(C259,CHOOSE(VLOOKUP(D259,$L$3:$M$5,2,0),$I$3:$J$6,$I$9:$J$12,$I$15:$J$18),2)*C259","v":132.57}]
["2009-11-10","SR6",4112,"P1",123.36]
["2009-10-30","SR1",4974,"P2",99.48]
["2009-10-20","SR1",4048,"P1",121.44]
["2009-11-11","SR6",2308,"P2",0]
["2009-10-31","SR4",3350,"P1",100.5]
["2009-10-15","SR5",4506,"P1",135.18]
["2009-12-01","SR2",95,"P3",1.425]
["2009-11-17","SR5",2875,"P1",86.25]
["2009-12-03","SR1",3714,"P1",111.42]
["2009-10-29","SR2",677,"P1",13.540000000000001]
["2009-11-13","SR6",4604,"P1",138.12]
["2009-11-17","SR5",9322,"P2",419.49]
["2009-11-25","SR4",7174,"P2",143.47999999999999]
["2009-10-26","SR3",2252,"P1",67.56]
["2009-10-29","SR5",54,"P3",0.27]
["2009-11-04","SR5",56,"P3",0.28000000000000003]
["2009-11-14","SR4",67,"P3",0.33500000000000002]
["2009-10-30","SR5",933,"P1",18.66]
["2009-10-17","SR6",25,"P3",0]
["2009-10-26","SR3",3094,"P1",92.82]
["2009-11-08","SR5",311,"P1",3.11]
["2009-10-26","SR6",8236,"P2",247.07999999999998]
["2009-11-24","SR1",48,"P3",0]
["2009-11-12","SR6",2131,"P1",63.93]
["2009-11-09","SR5",5286,"P2",105.72]
["2009-11-23","SR3",47,"P3",0]
["2009-10-26","SR2",2662,"P1",79.86]
["2009-11-27","SR1",3752,"P1",112.56]
["2009-12-02","SR2",3437,"P2",0]
["2009-11-01","SR2",2557,"P1",76.709999999999994]
["2009-10-23","SR5",7987,"P2",159.74]
["2009-10-25","SR6",81,"P3",0.81]
["2009-10-15","SR5",14,"P3",0]
["2009-11-15","SR3",65,"P3",0.32500000000000001]
["2009-11-28","SR5",8263,"P2",247.89]
["2009-10-31","SR2",56,"P3",0.28000000000000003]
["2009-11-18","SR2",3763,"P1",112.89]
["2009-11-09","SR2",2566,"P1",76.98]
["2009-11-19","SR2",2289,"P2",0]
["2009-11-29","SR1",25,"P3",0]
["2009-11-29","SR2",4,"P3",0]
["2009-11-02","SR2",65,"P3",0.32500000000000001]
["2009-11-23","SR1",2737,"P2",0]
["2009-10-19","SR3",10,"P3",0]
["2009-11-28","SR2",2957,"P1",88.71]
["2009-11-02","SR6",1004,"P1",30.119999999999997]
["2009-10-16","SR1",8797,"P2",263.90999999999997]
["2009-10-24","SR1",5816,"P2",116.32000000000001]
["2009-10-23","SR3",4666,"P2",93.320000000000007]
["2009-10-16","SR4",8328,"P2",249.84]
["2009-11-20","SR1",4874,"P1",146.22]
["2009-10-30","SR5",44,"P3",0]
["2009-10-26","SR3",86,"P3",0.86]
["2009-11-23","SR2",379,"P1",3.79]
["2009-11-09","SR6",7935,"P2",158.70000000000002]
["2009-10-30","SR1",2764,"P1",82.92]
["2009-11-23","SR4",48,"P3",0]
["2009-11-23","SR3",57,"P3",0.28500000000000003]
["2009-10-28","SR3",91,"P3",1.365]
["2009-10-27","SR2",4787,"P1",143.60999999999999]
["2009-11-02","SR3",5065,"P2",101.3]
["2009-10-31","SR1",15,"P3",0]
["2009-10-19","SR6",2210,"P1",66.3]
["2009-11-12","SR6",4815,"P2",{"$f":"VLOOKUP(C323,CHOOSE(VLOOKUP(D323,$L$3:$M$5,2,0),$I$3:$J$6,$I$9:$J$12,$I$15:$J$18),2)*C323","v":96.3}]
["2009-11-06","SR3",1538,"P1",46.14]
["2009-10-24","SR4",9998,"P2",449.90999999999997]
["2009-11-06","SR1",27,"P3",0]
["2009-11-04","SR1",3118,"P1",93.539999999999992]
["2009-11-21","SR5",69,"P3",0.34500000000000003]
["2009-11-03","SR3",9482,"P2",426.69]
["2009-10-24","SR3",2466,"P1",73.98]
["2009-11-18","SR2",2202,"P2",0]
["2009-11-20","SR4",1174,"P1",35.22]
["2009-11-25","SR1",41,"P3",0]
["2009-11-30","SR6",100,"P3",1.5]
["2009-11-22","SR6",7194,"P2",143.88]
["2009-10-18","SR5",65,"P3",0.32500000000000001]
["2009-11-19","SR6",60,"P3",0.3]
["2009-11-25","SR6",7372,"P2",147.44]
["2009-11-06","SR3",47,"P3",0]
["2009-12-02","SR3",8678,"P2",260.33999999999997]
["2009-11-21","SR5",2127,"P1",63.809999999999995]
["2009-10-14","SR1",3856,"P1",115.67999999999999]
["2009-11-11","SR5",71,"P3",0.35499999999999998]
["2009-11-26","SR5",1856,"P1",55.68]
["2009-11-06","SR4",1704,"P1",51.12]
["2009-10-16","SR5",6,"P3",0]
["2009-11-27","SR3",2374,"P2",0]
["2009-10-24","SR3",83,"P3",0.83000000000000007]
["2009-10-16","SR3",125,"P1",1.25]
["2009-11-15","SR5",59,"P3",0.29499999999999998]
["2009-11-11","SR6",3594,"P2",0]
["2009-11-22","SR5",4989,"P1",149.66999999999999]
["2009-11-06","SR4",6327,"P2",126.54]
["2009-11-24","SR6",1904,"P1",57.12]
["2009-11-15","SR1",2176,"P2",0]
["2009-11-04","SR6",6696,"P2",133.92000000000002]
["2009-10-27","SR2",6799,"P2",135.97999999999999]
["2009-10-20","SR3",6476,"P2",129.52000000000001]
["2009-11-12","SR6",210,"P1",2.1]
["2009-10-15","SR4",2290,"P2",0]
["2009-10-31","SR3",53,"P3",0.26500000000000001]
["2009-11-25","SR3",93,"P3",1.395]
["2009-11-02","SR2",99,"P3",1.4849999999999999]
["2009-10-16","SR6",6369,"P2",127.38000000000001]
["2009-11-14","SR6",268,"P1",2.68]
["2009-10-21","SR6",35,"P3",0]
["2009-11-06","SR4",6733,"P2",134.66]
["2009-10-14","SR3",9529,"P2",428.80500000000001]
["2009-10-26","SR3",7000,"P2",140]
["2009-10-21","SR4",27,"P3",0]
["2009-10-24","SR3",8655,"P2",259.64999999999998]
["2009-10-27","SR1",8823,"P2",264.69]
["2009-11-06","SR4",1970,"P1",59.099999999999994]
["2009-11-15","SR5",4838,"P1",145.13999999999999]
["2009-11-07","SR3",4180,"P1",125.39999999999999]
["2009-11-15","SR6",2651,"P1",79.53]
["2009-10-25","SR2",3877,"P1",116.31]
["2009-11-19","SR3",9366,"P2",421.46999999999997]
["2009-11-23","SR5",3298,"P2",0]
["2009-11-26","SR2",5017,"P2",100.34]
["2009-11-28","SR4",4229,"P2",84.58]
["2009-11-02","SR2",42,"P3",0]
["2009-11-23","SR5",8074,"P2",242.22]
["2009-10-23","SR6",5231,"P2",104.62]
["2009-10-29","SR1",4747,"P1",142.41]
["2009-10-20","SR1",6235,"P2",124.7]
["2009-11-04","SR2",9208,"P2",{"$f":"VLOOKUP(C387,CHOOSE(VLOOKUP(D387,$L$3:$M$5,2,0),$I$3:$J$6,$I$9:$J$12,$I$15:$J$18),2)*C387","v":414.35999999999996}]
["2009-10-19","SR3",81,"P3",0.81]
["2009-10-22","SR6",4793,"P1",143.79]
["2009-11-30","SR4",3670,"P2",0]
["2009-10-14","SR5",8058,"P2",241.73999999999998]
["2009-11-04","SR3",66,"P3",0.33]
["2009-10-16","SR2",1176,"P1",35.28]
["2009-10-20","SR2",2,"P3",0]
["2009-10-31","SR3",58,"P3",0.28999999999999998]
["2009-10-25","SR1",8590,"P2",257.7]
["2009-11-21","SR6",4370,"P1",131.1]
["2009-11-16","SR1",5247,"P2",104.94]
["2009-12-02","SR1",20,"P3",0]
["2009-11-14","SR2",18,"P3",0]
["2009-11-14","SR2",8979,"P2",269.37]
["2009-10-29","SR3",47,"P3",0]
["2009-10-21","SR2",99,"P3",1.4849999999999999]
["2009-11-19","SR2",4540,"P1",136.19999999999999]
["2009-11-27","SR2",1605,"P1",48.15]
["2009-11-11","SR2",3343,"P2",0]
["2009-11-29","SR1",7203,"P2",144.06]
["2009-12-02","SR4",788,"P1",15.76]
["2009-11-15","SR3",5888,"P2",117.76]
["2009-10-19","SR3",3014,"P1",90.42]
["2009-11-13","SR4",4696,"P1",140.88]
["2009-11-08","SR6",1937,"P1",58.11]
["2009-10-17","SR3",4595,"P1",137.85]
["2009-11-08","SR3",8803,"P2",264.08999999999997]
["2009-11-20","SR6",2928,"P1",87.84]
["2009-12-01","SR2",5675,"P2",113.5]
["2009-10-21","SR5",2083,"P1",62.489999999999995]
["2009-11-25","SR4",4566,"P1",136.97999999999999]
["2009-11-09","SR5",7706,"P2",154.12]
["2009-12-03","SR4",4447,"P1",133.41]
["2009-11-02","SR4",5375,"P2",107.5]
["2009-10-31","SR4",2626,"P1",78.78]
["2009-11-21","SR1",1407,"P1",42.21]
["2009-10-27","SR6",2302,"P1",69.06]
["2009-11-21","SR6",8,"P3",0]
["2009-10-24","SR3",68,"P3",0.34]
["2009-11-15","SR2",8773,"P2",263.19]
["2009-11-27","SR4",48,"P3",0]
["2009-11-12","SR1",9397,"P2",422.86500000000001]
["2009-10-18","SR6",3658,"P2",0]
["2009-10-15","SR2",5952,"P2",119.04]
["2009-12-02","SR5",5822,"P2",116.44]
["2009-11-28","SR3",4804,"P1",144.12]
["2009-11-06","SR2",64,"P3",0.32]
["2009-11-27","SR4",43,"P3",0]
["2009-10-23","SR2",6667,"P2",133.34]
["2009-11-17","SR5",443,"P1",4.43]
["2009-11-21","SR3",13,"P3",0]
["2009-11-18","SR4",1039,"P1",31.169999999999998]
["2009-11-16","SR3",2655,"P1",79.649999999999991]
["2009-11-28","SR5",31,"P3",0]
["2009-11-14","SR3",27,"P3",0]
["2009-10-18","SR1",166,"P1",1.6600000000000001]
["2009-12-01","SR4",68,"P3",0.34]
["2009-11-12","SR6",1166,"P1",34.979999999999997]
["2009-10-15","SR5",3173,"P1",95.19]
["2009-11-16","SR4",75,"P3",0.75]
["2009-11-27","SR2",1530,"P1",45.9]
["2009-10-17","SR6",4799,"P2",95.98]
["2009-11-02","SR6",3994,"P2",0]
["2009-11-28","SR2",88,"P3",{"$f":"VLOOKUP(C451,CHOOSE(VLOOKUP(D451,$L$3:$M$5,2,0),$I$3:$J$6,$I$9:$J$12,$I$15:$J$18),2)*C451","v":0.88}]
["2009-12-01","SR5",3119,"P1",93.57]
["2009-11-11","SR1",1332,"P1",39.96]
["2009-11-10","SR4",9948,"P2",447.65999999999997]
["2009-10-20","SR3",1083,"P1",32.49]
["2009-11-13","SR4",80,"P3",0.8]
["2009-11-26","SR2",52,"P1",0]
["2009-10-16","SR1",8341,"P2",250.23]
["2009-11-17","SR4",87,"P3",0.87]
["2009-11-03","SR4",9063,"P2",407.83499999999998]
["2009-11-04","SR1",9757,"P2",439.065]
["2009-10-23","SR5",93,"P3",1.395]
["2009-11-27","SR4",2108,"P1",63.239999999999995]
["2009-11-14","SR5",52,"P3",0.26]
["2009-10-14","SR4",3090,"P1",92.7]
["2009-12-03","SR5",4263,"P2",85.26]
["2009-11-16","SR6",3994,"P1",119.82]
["2009-10-16","SR4",65,"P3",0.32500000000000001]
["2009-11-20","SR6",64,"P3",0.32]
["2009-11-30","SR4",9268,"P2",417.06]
["2009-11-16","SR2",4002,"P1",120.06]
["2009-10-21","SR4",97,"P3",1.4549999999999998]
["2009-11-11","SR6",6192,"P2",123.84]
["2009-10-21","SR1",2704,"P1",81.11999999999999]
["2009-11-22","SR5",3634,"P2",0]
["2009-11-08","SR3",8180,"P2",245.39999999999998]
["2009-11-28","SR4",5932,"P2",118.64]
["2009-11-10","SR2",812,"P1",16.240000000000002]
["2009-12-01","SR4",2263,"P2",0]
["2009-11-10","SR5",8411,"P2",252.32999999999998]
["2009-12-02","SR4",68,"P3",0.34]
["2009-10-29","SR2",46,"P3",0]
["2009-11-27","SR3",7135,"P2",142.70000000000002]
["2009-11-19","SR6",6125,"P2",122.5]
["2009-11-22","SR4",3393,"P1",101.78999999999999]
["2009-11-26","SR5",2987,"P1",89.61]
["2009-11-03","SR1",6,"P3",0]
["2009-11-24","SR3",73,"P3",0.36499999999999999]
["2009-11-22","SR1",2648,"P1",79.44]
["2009-10-27","SR3",9402,"P2",423.09]
["2009-11-05","SR4",81,"P3",0.81]
["2009-11-25","SR4",8053,"P2",241.59]
["2009-10-16","SR5",7793,"P2",155.86000000000001]
["2009-10-17","SR6",4715,"P1",141.44999999999999]
["2009-10-16","SR4",6844,"P2",136.88]
["2009-10-29","SR2",5921,"P2",118.42]
["2009-12-01","SR1",2295,"P1",68.849999999999994]
["2009-10-24","SR5",6537,"P2",130.74]
["2009-12-03","SR2",2385,"P1",71.55]
["2009-11-20","SR2",2000,"P2",0]
["2009-11-19","SR2",24,"P3",0]
["2009-11-06","SR4",61,"P3",0.30499999999999999]
["2009-11-17","SR6",7776,"P2",155.52000000000001]
["2009-11-27","SR3",88,"P3",0.88]
["2009-10-26","SR4",4465,"P1",133.94999999999999]
["2009-11-01","SR3",31,"P3",0]
["2009-11-19","SR4",7787,"P2",155.74]
["2009-10-20","SR1",2587,"P2",0]
["2009-11-28","SR2",3841,"P1",115.22999999999999]
["2009-11-18","SR5",5043,"P2",100.86]
["2009-12-02","SR6",4448,"P2",88.960000000000008]
["2009-11-07","SR6",7477,"P2",149.54]
["2009-11-07","SR6",3895,"P1",116.85]
["2009-11-22","SR6",4747,"P1",142.41]
["2009-11-06","SR2",1855,"P1",{"$f":"VLOOKUP(C515,CHOOSE(VLOOKUP(D515,$L$3:$M$5,2,0),$I$3:$J$6,$I$9:$J$12,$I$15:$J$18),2)*C515","v":55.65}]
["2009-11-01","SR5",88,"P3",0.88]
["2009-11-12","SR2",38,"P3",0]
["2009-10-18","SR2",11,"P3",0]
["2009-10-19","SR5",82,"P3",0.82000000000000006]
["2009-10-28","SR1",81,"P3",0.81]
["2009-10-26","SR6",89,"P3",0.89]
["2009-11-26","SR6",4910,"P1",147.29999999999998]
["2009-10-28","SR3",1250,"P1",37.5]
["2009-10-26","SR1",8340,"P2",250.2]
["2009-11-19","SR3",3783,"P2",0]
["2009-12-03","SR5",4327,"P1",129.81]
["2009-11-16","SR2",7067,"P2",141.34]
["2009-11-20","SR4",9603,"P2",432.13499999999999]
["2009-11-04","SR4",4716,"P1",141.47999999999999]
["2009-10-22","SR5",6408,"P2",128.16]
["2009-11-09","SR2",7910,"P2",158.20000000000002]
["2009-10-25","SR1",7771,"P2",155.42000000000002]
["2009-11-08","SR3",47,"P3",0]
["2009-11-28","SR3",3954,"P1",118.61999999999999]
["2009-11-30","SR6",3308,"P1",99.24]
["2009-10-18","SR4",52,"P3",0.26]
["2009-11-15","SR3",7344,"P2",146.88]
["2009-10-16","SR6",8602,"P2",258.06]
["2009-11-19","SR4",7436,"P2",148.72]
["2009-10-23","SR4",60,"P3",0.3]
["2009-10-23","SR3",93,"P3",1.395]
["2009-11-28","SR6",2,"P3",0]
["2009-10-18","SR4",771,"P1",15.42]
["2009-10-19","SR1",472,"P1",4.72]
["2009-11-22","SR2",1401,"P1",42.03]
["2009-11-02","SR4",6935,"P2",138.70000000000002]
["2009-11-13","SR2",85,"P3",0.85]
["2009-12-01","SR2",1953,"P1",58.589999999999996]
["2009-10-17","SR4",2670,"P1",80.099999999999994]
["2009-11-04","SR3",5152,"P2",103.04]
["2009-11-06","SR6",1974,"P1",59.22]
["2009-11-04","SR3",7996,"P2",159.92000000000002]
["2009-10-22","SR2",4253,"P1",127.58999999999999]
["2009-10-24","SR6",4474,"P1",134.22]
["2009-11-16","SR5",3547,"P1",106.41]
["2009-11-27","SR6",5703,"P2",114.06]
["2009-11-07","SR4",3537,"P1",106.11]
["2009-10-27","SR5",4042,"P2",80.84]
["2009-11-12","SR1",8034,"P2",241.01999999999998]
["2009-11-25","SR1",13,"P3",0]
["2009-11-21","SR6",38,"P3",0]
["2009-10-23","SR6",8958,"P2",268.74]
["2009-11-28","SR5",46,"P3",0]
["2009-11-16","SR6",6132,"P2",122.64]
["2009-11-01","SR4",2508,"P2",0]
["2009-10-20","SR6",13,"P3",0]
["2009-11-11","SR4",83,"P3",0.83000000000000007]
["2009-11-22","SR5",7280,"P2",145.6]
["2009-10-24","SR3",42,"P3",0]
["2009-11-25","SR1",3508,"P1",105.24]
["2009-11-29","SR4",6562,"P2",131.24]
["2009-11-01","SR5",121,"P1",1.21]
["2009-11-26","SR1",2872,"P2",0]
["2009-11-28","SR5",6,"P3",0]
["2009-11-03","SR5",66,"P3",0.33]
["2009-11-20","SR2",9540,"P2",429.3]
["2009-11-11","SR2",71,"P3",0.35499999999999998]
["2009-12-02","SR4",83,"P3",0.83000000000000007]
["2009-11-30","SR3",5697,"P2",{"$f":"VLOOKUP(C579,CHOOSE(VLOOKUP(D579,$L$3:$M$5,2,0),$I$3:$J$6,$I$9:$J$12,$I$15:$J$18),2)*C579","v":113.94}]
["2009-12-02","SR6",2821,"P1",84.63]
["2009-11-20","SR4",57,"P3",0.28500000000000003]
["2009-11-14","SR1",3391,"P1",101.72999999999999]
["2009-10-20","SR5",3925,"P2",0]
["2009-10-21","SR2",3149,"P1",94.47]
["2009-10-20","SR2",373,"P1",3.73]
["2009-11-15","SR4",8050,"P2",241.5]
["2009-11-13","SR1",1580,"P1",47.4]
["2009-10-17","SR5",2777,"P1",83.31]
["2009-11-28","SR4",4258,"P2",85.16]
["2009-10-18","SR3",8174,"P2",245.22]
["2009-11-28","SR6",37,"P3",0]
["2009-10-26","SR2",87,"P3",0.87]
["2009-10-20","SR1",2246,"P1",67.38]
["2009-11-22","SR6",3405,"P1",102.14999999999999]
["2009-10-29","SR1",229,"P1",2.29]
["2009-10-16","SR1",36,"P3",0]
["2009-10-16","SR2",40,"P3",0]
["2009-10-17","SR3",4116,"P1",123.47999999999999]
["2009-11-14","SR4",45,"P3",0]
["2009-10-26","SR3",82,"P3",0.82000000000000006]
["2009-10-22","SR5",63,"P3",0.315]
["2009-10-29","SR6",2631,"P1",78.929999999999993]
["2009-10-31","SR2",7095,"P2",141.9]
["2009-11-16","SR5",4946,"P2",98.92]
["2009-11-28","SR1",1232,"P1",36.96]
["2009-10-24","SR1",3985,"P2",0]
["2009-11-06","SR3",2010,"P1",60.3]
["2009-10-22","SR2",6356,"P2",127.12]
["2009-11-06","SR4",1707,"P1",51.21]
["2009-10-15","SR3",5674,"P2",113.48]
["2009-11-25","SR6",5391,"P2",107.82000000000001]
["2009-10-24","SR6",782,"P1",15.64]
["2009-11-21","SR2",5914,"P2",118.28]
["2009-10-22","SR5",9133,"P2",410.98499999999996]
["2009-10-18","SR1",4542,"P1",136.26]
["2009-10-16","SR1",6372,"P2",127.44]
["2009-12-02","SR5",64,"P3",0.32]
["2009-10-22","SR1",68,"P3",0.34]
["2009-11-17","SR5",1850,"P1",55.5]
["2009-11-01","SR3",575,"P1",11.5]
["2009-10-23","SR1",31,"P3",0]
["2009-11-03","SR2",9212,"P2",414.53999999999996]
["2009-11-25","SR3",4216,"P1",126.47999999999999]
["2009-11-25","SR5",6408,"P2",128.16]
["2009-11-19","SR2",3083,"P1",92.49]
["2009-10-20","SR3",7277,"P2",145.54]
["2009-11-08","SR2",19,"P3",0]
["2009-12-01","SR3",946,"P1",18.920000000000002]
["2009-10-16","SR3",44,"P3",0]
["2009-10-29","SR3",3269,"P1",98.07]
["2009-10-30","SR1",83,"P3",0.83000000000000007]
["2009-11-03","SR3",37,"P3",0]
["2009-11-17","SR4",7050,"P2",141]
["2009-10-15","SR4",20,"P3",0]
["2009-11-26","SR4",4268,"P1",128.04]
["2009-11-07","SR3",68,"P3",0.34]
["2009-11-04","SR1",89,"P3",0.89]
["2009-12-02","SR6",5809,"P2",116.18]
["2009-11-10","SR3",46,"P3",0]
["2009-10-25","SR5",34,"P3",0]
["2009-11-14","SR6",49,"P3",0]
["2009-10-24","SR4",8460,"P2",253.79999999999998]
["2009-11-20","SR1",1026,"P1",{"$f":"VLOOKUP(C643,CHOOSE(VLOOKUP(D643,$L$3:$M$5,2,0),$I$3:$J$6,$I$9:$J$12,$I$15:$J$18),2)*C643","v":30.779999999999998}]
["2009-11-20","SR3",12,"P3",0]
["2009-10-15","SR4",5225,"P2",104.5]
["2009-10-17","SR4",6096,"P2",121.92]
["2009-10-17","SR3",4434,"P1",133.01999999999998]
["2009-10-18","SR3",2335,"P1",70.05]
["2009-10-27","SR1",1563,"P1",46.89]
["2009-11-19","SR2",72,"P3",0.36]
["2009-10-18","SR3",3250,"P1",97.5]
["2009-10-23","SR6",71,"P3",0.35499999999999998]
["2009-10-24","SR3",9316,"P2",419.21999999999997]
["2009-10-27","SR3",2860,"P1",85.8]
["2009-10-21","SR1",9969,"P2",448.60499999999996]
["2009-10-22","SR6",8693,"P2",260.78999999999996]
["2009-11-24","SR6",2018,"P2",0]
["2009-11-14","SR3",4014,"P2",80.28]
["2009-11-17","SR4",4201,"P1",126.03]
["2009-11-11","SR1",2,"P3",0]
["2009-10-23","SR3",1615,"P1",48.449999999999996]
["2009-10-29","SR3",4005,"P1",120.14999999999999]
["2009-11-10","SR3",9789,"P2",440.505]
["2009-10-17","SR1",4414,"P1",132.41999999999999]
["2009-10-25","SR2",3598,"P1",107.94]
["2009-11-13","SR1",1384,"P1",41.519999999999996]
["2009-11-07","SR4",92,"P3",1.38]
["2009-11-18","SR1",5,"P3",0]
["2009-10-21","SR2",2421,"P1",72.63]
["2009-10-14","SR4",5920,"P2",118.4]
["2009-10-17","SR5",44,"P3",0]
["2009-10-20","SR1",4921,"P1",147.63]
["2009-11-22","SR3",47,"P3",0]
["2009-11-11","SR3",9146,"P2",411.57]
["2009-11-16","SR5",2517,"P1",75.509999999999991]