can someone explain the formulas I would use in excel to solve this please? and show the formulas used on excel?

Week 2 Assignment In the Excel file Week2.xlsx, use advanced filters in the filter sheet to complete the following: 1- List all orders with sales greater than or equal 7000 2- List all orders with sales greater than 4800 and quantity greater than 36 3- List all orders with sales between $4000 and $6000 inclusive 4- List all orders with a dealsize medium or small and country is Canada 5- List all orders with product line motorcycles and country is USA or Canada 6- List all orders with a country with an "n" as the third character and with sales greater than $3000 7- List all orders from the states of NJ, NY or MA with quantity greater than 30 and sales greater than $5000 8- List all orders from a country that has "a" as the second letter and sales greater than $3000 9- List all orders from countries that start with a "U" and dealsize is medium 10- List all orders made between 1/1/2004 and 1/1/2005 and with sales greater than $5000 NYC USA 10134 385434 Week2-Assignment Bus 308.xlsx ORDERNUMBERQUANTITYORDERED PRICEEACH ERLINE SALES ORDERDATE STATUS PRODUCTLINE CITY STATE COUNTRDEALSIZE 10107 30 95.7 2 2871 2/2403 000 Shipped Motorcycles NY Small 10121 34 81.35 5 27659 $/7/03 0:00 Shipped Motorcycles Reims France Small 41 94.74 2 7/1/03 0:00 Shipped Motorcycles Paris France Medium 10145 45 89.26 6 3746.7 8/2503 0.00 Shipped Motorcycles Pasadena CA USA Medium 10139 49 100 14 5205.27 10/10/03 0:00 Shipped Motorcyeles San Francis CA USA Medium 10168 36 96.66 1 3479,76 10/2003 0:00 Shipped Motorcycles Burlingame CA USA Medium 10180 29 86.13 9 2497.77 11/11/01 0:00 Shipped Motorcycles Lille France Small 10188 48 100 1 5512.12 11/1NOJ 0:00 Shipped Motorcycles Bergen Norway Medium 10201 22 9857 2 2168.54 12/1/03 0:00 Shipped Motorcycles San Francis CA USA Small 10211 41 100 14 4708.44 1/15040:00 Shipped Motorcycles Paris France Medium 10223 37 100 1 3965,66 2/2004 0:00 Shipped Motorcycles Melbourne Victoria Australia Medium 10237 23 100 7 2333.12 4/5040-00 Shipped Motorcycles NYC NY USA Small 10251 28 100 2 3188.64 31804 0:00 Shipped Motorcycles Newark NJ USA Medium 10263 34 100 2 1676.76 620040,00 Shipped Motorcycles Bridgewatery USA Medium 10275 92.83 1 4177.35 7/2104000 Shipped Motorcycles Nantes Medium 10285 36 100 6 4099.68 8/2704000 Shipped Motorcycles Cambridge MA USA Medium 10299 23 100 9 2597.39 9/2004 000 Shipped Motorcycles Helsinki Finland Small 10309 100 5 43943 10/1504 0:00 Shipped Motorcycles Storvem Norway Medium 101N 94.74 1 435.04 11/204000 Shipped Motorcycles Allentown PA USA Medium 10329 49 100 1 4396.14 11/15040.00 Shipped Motorcycles NYC NY USA Medium much NEAR 45 France Dashboard IE Calendar To Do D Notifications MInbox Week2-Assignment Bus 308.xlsx 41 20 21 42 24 UK Large Starve 26 29 38 37 Large 10341 10361 10375 10388 10403 10417 10103 10112 10126 10140 10130 10163 10174 10183 10194 10206 10215 10228 10245 10258 10270 10280 9 13 12 4 7 2 11 1 11 11 8 1 4 SARRERAS 100 72.55 34.91 76.36 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 7737.93 1451 733,11 3207.12 2434.56 7516,05 540462 7209.11 7329.06 73741 10993.5 4860.24 801482 5372.57 7290.36 44.89 00753 6463.23 6120.14 7680.64 1905 19 2014.3 11/2404 0:00 Shipped Motorcycles 12/17/04 0:00 Shipped Motorcycles 2/3/05 000 Shipped Motorcycles 33705 0:00 Shipped Motorcycles 4/8/05 0:00 Shipped Motorcycles 5/1305 0:00 Disputed Motorcycles 1/2903 0:00 Shipped Classic Cars 32403 0:00 Shipped Classic Cars 5/2003 0:00 Shipped Classic Cars 7/2403 0:00 Shipped Classic Cars 91903 0.00 Shipped Classic Cars 10/2003 000 Shipped Classic Cars 11/303 0:00 Shipped Classic Cars 11/1103 0:00 Shipped Classic Cars 11/2503 0:00 Shipped Classic Cars 12/503 0:00 Shipped Classic Cars 1/2904 0:00 Shipped Classic Cars 110040,00 Shipped Classic Cars 5140400 Shipped Classic Cars VISO4000 Shipped Classic Cars 7/1904000 Shipped Claude Cars MIM04 0:00 Shipped Classic Cars Salzburg Austria Large Chatswood NSW Australia Small Nantes France Small New BedforMA USA Medium Liverpool Small Madrid Spain Norway Medium Lale Sweden Madrid Spain Large Burlingame CA USA Large Singapore Singapore Large NYC NY USA Medium South Brisb Queensland Australia Large Philadelphi: PA USA Medium Lyon France Large Vancouver BC Canada Large Burbank CA USA Medium Cambridge MA USA Medium New Haven CT USA Medium Minato-ku Tokyo Japan Large Chatswood NSW Australia Medium Torine Italy Large 21 34 23 42 47 11 6 3 2 9 6 29 14 32 21 34 2 Dashboard IE Calendar To Do Notifications Minbox 10291 10304 10312 10322 10333 10347 10359 10369 10381 10391 10411 10424 10107 10120 10134 10145 10159 10168 10180 10188 10201 10910 37 47 48 40 26 30 32 41 36 24 23 30 39 29 27 37 37 27 42 38 24 23 : Week2-Assignment Bus 308.xlsx 100 11 7136.19 9040.00 Shipped Classic Cars 100 6 10172.7 10/11/04 0:00 Shipped Classic Cars 100 3 11623.7 10/21/04 0:00 Shipped Classic Cars 100 1 60004 11/4/04 0:00 Shipped Classic Cars 100 3 3003 11/1804 0:00 Shipped Classic Cars 100 1 3944.7 11/2904 0:00 Shipped Classic Cars 100 10 $691.84 12/10/04 0:00 Shipped Classic Cars 100 2 4514.92 1/2005 0:00 Shipped Classic Cars 100 3 82548 2/17/05 0:00 Shipped Classic Cars 100 4 2416.56 1/905 0:00 Shipped Classic Cars 100 9 4140.23 5/1/0S 000 Shipped Classic Cars 100 6 12001 5/31/05 0:00 In Process Classic Cars 99.91 $ 3896.49 2/2403 0:00 Shipped Motorcycles 96.34 3 2793.86 4/2003 0:00 Shipped Motorcycles 100 $ 3307.77 1/1/03 0:00 Shipped Motorcycles 100 9 5192.95 B/2503 000 Shipped Motorcycles 100 17 501683 10/100) 0:00 Shipped Motorcycles 100 4 3660.91 10/2003 0:00 Shipped Motorcycles 100 12 4695,6 11/11/03 0.00 Shipped Motorcycles 96.34 4 3660.92 11/1800.00 Shipped Motorcycles 100 5 3025.92 12/1/03 0:00 Shipped Motorcycles 100 2 3000.00 1/1204000 Shipped Motorcycles Boras Sweden Large Versailles France Large San Rafael CA USA Large Nashwa NH USA Medium San Francis CA USA Medium Melbourne Victoria Australia Medium San Rafael CA USA Medium Brickhaven MA USA Medium San Francis CA USA Large North Sydns NSW Australia Small Montreal Queber Canada Medium Madrid Spain Large NYC NY USA Medium Melbourne Victoria Australia Small France Medium Pasadena CA USA Medium San Francis CA USA Medium Burlingame CA USA Medium Lille France Medium Bergen Norway Medium San Francis CA USA Medium Ouka Osaka Japan Medium Dashboard IE Calendar To Do D Notifications Inbox Week2-Assignment Bus 308.xlsx 10323 10236 10251 10263 10275 10285 10298 1010 10318 10129 10039 10361 10374 10388 10402 10417 10107 10120 10114 10143 10159 1016 ENCARANSERS 47 22 44 40 22 47 39 34 45 20 40 26 39 50 45 45 27 46 100 100 100 100 100 100 96.34 100 100 100 68.92 SL.IS 100 44.51 100 100 100 100 100 100 100 100 4 1 5 $ 4 9 1 2 4 2 4 8 5 $ 1 $ 4 2 4 5 16 $422.39 2852.03 5756.52 4472 290444 5484.59 1757.26 4043.96 55665 3176 2756.8 1329.9 5288.01 22255 58338 588735 6065.55 9266 7023.98 $176 15 41127 4K) 2/2004 0:00 Shipped Motorcycles 4/3/04 0:00 Shipped Motorcycles 5/18/04 0:00 Shipped Moforcycles 62804000 Shipped Motorcycles 7/21040.00 Shipped Motorcycles N27/04 0:00 Shipped Motorcycles 9/27/04 0:00 Shipped Motorcycles 10/15:04 0:00 Shipped Motorcycles 11/2004 0:00 Shipped Motorcycles 11/15-04 0:00 Shipped Motorcycles 11/21040:00 Shipped Motorcycles 12/17/04 0:00 Shipped Motorcycles 2/2005 0:00 Shipped Motorcycles 3/3705 0:00 Shipped Motorcycles 4/7/05 0:00 Shipped Motorcycles 130S 0:00 Disputed Motorcycles 2/2401 0:00 Shipped Motorcycles 4/2003 0.0 Shipper Morelos 7/1/01 0:00 Shipped Motorcycles N250 0:00 Shipped Motorcycles 10/10010 00 Shipped Motorcycles 100 000 Shipped Motorcycles Melbourne Victoria Australia Medium Philadelphia PA USA Small Newark NU USA Medium Bridgewater USA Medium Nantes France Small Cambridge MA USA Medium Nantes France Medium White Plain NY USA Medium Allentown PA USA Medium NYC NY USA Medium Minato-ku Tokyo Japan Small Chatswood NSW Australia Small South Brish Queensland Australia Medium New BedforMA USA Small Pris France Medium Madrid Spain Medium NY Medium Melbourne Victoria Australie Large I' France Large Pasadena CA USA Medium Se Francis CA USA Medium Burlingame CA USA Medium NYC USA 33 20 Dashboard IE Calendar To Do Notifications inbox Inbox Week2-Assignment Bus 308.xlsx G France Medium 3 4 1 3 9 + 4 3 39 43 La La 1010 10188 10201 10210 10223 10237 10251 10269 10275 105 1000 1610 103N 10329 10119 10162 10174 ION 10403 10412 10105 10119 27 29 20 37 26 100 100 100 100 100 100 100 100 100 100 100 100 100 100 76.67 100 100 3679 100 100 100 100 BOSSES N92 N7147 8065.89 01234 9774,03 7023.9 70782) 8336.94 192 S438.07 6683.14 45704 7667.14 5862 299013 16641 383438 3N22.17 118866 9218.16 7208 SOX 11/11/0300 Shipped Motorcycles 11/10000 Shipped Motorcycles 12/1/03 000 Shipped Motorcycles 1/1204000 Shipped Motorcycles 2/2004 0.00 Shipped Motorcycle 4504000 Shipped Motorcycles 5/181040,00 Shipped Motorcycles 62804000 Shipped Motorcycles 7/21040:00 Shipped Motorcycles 1/27/040 00 Shipped Motorcycles 9/2004 0:00 Shipped Motorcycles 10151010 00 Shipped Motorcycles 11/2004 0:00 Shipped Motorcycles 11/15 010 00 Shipped Morcycle 11/210000 Shipped Motorcycles 1/50000 Shipped Myles 2/20 000 Shipped Motorcycles VUOS 000 Shipped Mecanceles 4/05 0:00 Shipped Motorcycles /130S 0:00 Disputed Matches 2/11/10 00 Shipped Car 4203000 Shipped Classic Cars 11 1 3 3 3 4 1 7 9 4 2 11 NY Lille Large Bergen Norway Large San FCA USA Large Daka Osaka Japan Melbourne Victoria Australia Large NYC NY USA Newark N USA BridgewatcCY USA Large Nantes France Medium Cambridge MA USA Medium Helsinki Finland Medium White Plain NY USA Medium Allentown PA USA Large NYC USA Medium Minato-ko Tokyo Small Burlingame CA USA Me South Hirish Queensland Australia Medium New lied MA USA Small Liverpool UK Large Madrid Spain Large Kobenhavn Demak Large Salburg Austria Medium 22 22 21 00 Dashboard IE Calendar To Do Notifications Minbox Week2-Assignment Bus 308.xlsx G 32 44 24 20 UR Spain 59 10129 10143 10155 10167 1017 10186 10197 10200 10022 10248 10261 10273 1028 10295 1010 10116 10139 10119 10150 10159 10173 10184 BSA2888 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 6493 480S 75.47 54.6% 100 100 2 13 13 9 12 9 6 3 12 3 1 4 6 1 . 17 6 27 4398.34 5397.76 4526,08 5934.16 3492.48 3854.24 53244 $197.92 59976 2910.4 3378.24 350RS 2992 34272 2092 412.05 305171 1201.25 192.22 263464 4616.25 48467 W1203000 Shipped Classic Cars N1001 0:00 Shipped Classic Cars 100 000 Shipped Claus 102303 0:00 Cancelled Claw Cars 11/0 000 Shipped Classic Cars 11/14/01 000 Shipped Classic Cars 11/2003 0:00 Shipped Classic Cars 1/900000 Shipped Classic Cars 2/1904 0:00 Shipped Classic Cars 5/7/040,00 Cancelled Classic Cars (17040:00 Shipped Classic Cars 7/21/040.00 Shipped Classic Cars 82004000 Shipped Classic Cars 910010.00 Shipped Classic Cars 10/140400 Shipped Classic Cars 11/1/0400 Shipped Classic Cars 11/300000 Shipped Claus Cats 11/21/04000 Shippel Cha Can 12/2010 00 Shipped Clas Car 12/15:04 0:00 Shipped Classic Cars 1/31/08000 Shipped Classic Cars 2/2000 Shipped Clan Cans London UK New BedforMA USA Helsinki Finland Boras Sweden Toulouse France London Barcelona Los AngeleCA USA San Diego CA USA NYC NY USA Montreal Quebec Canada Bruxelles Belgium Tawassen BC Canada Boston MA USA Philadelphia USA Cowes tale of Wig UK Starver Norway NYC NY USA Madrid Spain Reims France Ole Finland San FCA USA Medium Medium Medium Medium Medit Medium Med Medium Medium Small Medium Medium Small Medium Small Medium Medium Small 23 24 22 47 25 20 48 Small 6 1 4 Small Medium Medium 54 Dashboard IE Calendar To Do Notifications Minbox * Week2-Assignment Bus 308.xlsx 32 2 9 3 4 19 42 22 10395 10400 10414 10103 10114 10126 10140 10150 10164 10175 10183 10194 10202 10212 10320 10245 10249 10910 10281 10791 1030s 1011) ARRA ARRASAAN 20 21 33 28 20 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 3370.56 906144 2764.88 $198.26 410525 3347.74 3188.12 1191.2 3536.82 $363.3 3433.36 4263.74 4076.19 7020.45 64265 459172 4033.18 4302.03 7020,64 38559 60. 4 1 2 9 1 4 15 4 9 2 12 2 9 4 13 7 3/17/05 0:00 Shipped Classic Cars 4/1/05 0:00 Shipped Classic Cars SOOS 0:00 On Home Classic Cars 1/29 030 00 Shipped Classic Cars 4/1/03000 Shipped Classic Cars 52801 0:00 Shipped Classic Cars 7/2403 0:00 Shipped Clasic Cars 9/19-01 000 Shipped Classic Cars 1021/030,00 Resolved Classic Cars 11/60000 Shippet Classic Cars 11/1VOJ 0:00 Shipped Classic Cars 11/2503 0:00 Shipped Classic Cars 12/01 0:00 Shipped Classic Cars 2004000 Shipped Classic Cars V11/040.00 Shipped Claus 540400 Shipped Clai Ca IVIS 04 0:00 Shipped Classic Cars 7/100100 Shipped Classic Cars M190.000 Shipped Classic Cars 904000 Shipped Classic Cars 10/108000 Shippel Classic Cars 102204000 Shipped Paris San Jose CA Boston MA Staver Paris Madrid Burlingame CA Singapore Grat London Philadelphi Lyon Boston MA Singapore San Rafael CA New HCT Singapore Chatwood NSW Allentown Boras Cambridge MA Vancouver France Medium USA Large USA Small Norway Medium France Medium Spain Medium USA Medium Singapore Medium Austria Medium UK Medium USA Medium Franec Medium USA Medium Singapore Large USA Medium USA Medium Singapore Medium Australia Medium USA Large Sueden Medium USA Medium Canal Medium 48 26 10 3 Dashboard IE Calendar To Do Notifications Minbox Week2-Assignment Bus308.xlsx G 9 1 4 15 4 0 10175 101R 10194 10207 10217 10229 10345 10259 10270 ROZRI 1039 100 10313 10322 10314 10147 10357 10370 103NI 10191 5362.83 343336 426.74 407619 7020:48 64265 4591.72 4031 4102 ON 702004 33 28 26 31 48 SU) 28 26 13 44 10 18 40 46 26 22 41 35 37 17 100 100 100 100 100 100 100 10 100 100 100 100 100 61.09 100 100 100 65.63 100 16 12 2 9 4 13 11603000 Shipped 1203 0:00 Shipped 11/2503 0:00 Shipped 12/903 0,00 Shipped 2400000 Shipped 3/11 0:00 Shipped 5:4014 0:00 Shipped 6:15/000,00 Shipped 1190000 Shipped /1964000 Shipped 98704 000 Shipped IM000 Shipped 10:22/04000 Shipped 11:40400 Shipped 11/10040,00 Hold 11/2904000 Shipped 12/10 000 Shipped 1/2008 000 Shipped 2/1700.00 Shipped 380S 0:00 Shipped Classic Cars Classic Cars Classic Cars Classic Cars Classic Cars Classic Cars Classic Cars Classic Cars Classic Cars Classic Cars Classic Cars Classic Can Classic Care Classic Cars Classic Cars Classic Cars Classic Cars Classic Cars Classic Can Classic Cars London Philadelphia PA Lyon Boston MA Singapore San Rafael CA New Haven CT Singapore Chu NSW Allentown PA Horas Cuernbede MA Vac BC Nahua NH Ende Melbourne Victoria Kanare CA North SydneNSW San CA North SNSW UK Medium USA Medium France Medium USA Medium Singapore Large USA Medium USA Medium Sing Medium Australia Medium USA Large Sweden Medium USA Medium Canada Medium USA Small Sweden Medium Austru Medium USA Medium Australia Small USA Medium Australia Small N 2 2 667 25154 318812 4428 $710.92 229705 31.54 1735.3 4 6 7 Week 2 Assignment In the Excel file Week2.xlsx, use advanced filters in the filter sheet to complete the following: 1- List all orders with sales greater than or equal 7000 2- List all orders with sales greater than 4800 and quantity greater than 36 3- List all orders with sales between $4000 and $6000 inclusive 4- List all orders with a dealsize medium or small and country is Canada 5- List all orders with product line motorcycles and country is USA or Canada 6- List all orders with a country with an "n" as the third character and with sales greater than $3000 7- List all orders from the states of NJ, NY or MA with quantity greater than 30 and sales greater than $5000 8- List all orders from a country that has "a" as the second letter and sales greater than $3000 9- List all orders from countries that start with a "U" and dealsize is medium 10- List all orders made between 1/1/2004 and 1/1/2005 and with sales greater than $5000 NYC USA 10134 385434 Week2-Assignment Bus 308.xlsx ORDERNUMBERQUANTITYORDERED PRICEEACH ERLINE SALES ORDERDATE STATUS PRODUCTLINE CITY STATE COUNTRDEALSIZE 10107 30 95.7 2 2871 2/2403 000 Shipped Motorcycles NY Small 10121 34 81.35 5 27659 $/7/03 0:00 Shipped Motorcycles Reims France Small 41 94.74 2 7/1/03 0:00 Shipped Motorcycles Paris France Medium 10145 45 89.26 6 3746.7 8/2503 0.00 Shipped Motorcycles Pasadena CA USA Medium 10139 49 100 14 5205.27 10/10/03 0:00 Shipped Motorcyeles San Francis CA USA Medium 10168 36 96.66 1 3479,76 10/2003 0:00 Shipped Motorcycles Burlingame CA USA Medium 10180 29 86.13 9 2497.77 11/11/01 0:00 Shipped Motorcycles Lille France Small 10188 48 100 1 5512.12 11/1NOJ 0:00 Shipped Motorcycles Bergen Norway Medium 10201 22 9857 2 2168.54 12/1/03 0:00 Shipped Motorcycles San Francis CA USA Small 10211 41 100 14 4708.44 1/15040:00 Shipped Motorcycles Paris France Medium 10223 37 100 1 3965,66 2/2004 0:00 Shipped Motorcycles Melbourne Victoria Australia Medium 10237 23 100 7 2333.12 4/5040-00 Shipped Motorcycles NYC NY USA Small 10251 28 100 2 3188.64 31804 0:00 Shipped Motorcycles Newark NJ USA Medium 10263 34 100 2 1676.76 620040,00 Shipped Motorcycles Bridgewatery USA Medium 10275 92.83 1 4177.35 7/2104000 Shipped Motorcycles Nantes Medium 10285 36 100 6 4099.68 8/2704000 Shipped Motorcycles Cambridge MA USA Medium 10299 23 100 9 2597.39 9/2004 000 Shipped Motorcycles Helsinki Finland Small 10309 100 5 43943 10/1504 0:00 Shipped Motorcycles Storvem Norway Medium 101N 94.74 1 435.04 11/204000 Shipped Motorcycles Allentown PA USA Medium 10329 49 100 1 4396.14 11/15040.00 Shipped Motorcycles NYC NY USA Medium much NEAR 45 France Dashboard IE Calendar To Do D Notifications MInbox Week2-Assignment Bus 308.xlsx 41 20 21 42 24 UK Large Starve 26 29 38 37 Large 10341 10361 10375 10388 10403 10417 10103 10112 10126 10140 10130 10163 10174 10183 10194 10206 10215 10228 10245 10258 10270 10280 9 13 12 4 7 2 11 1 11 11 8 1 4 SARRERAS 100 72.55 34.91 76.36 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 7737.93 1451 733,11 3207.12 2434.56 7516,05 540462 7209.11 7329.06 73741 10993.5 4860.24 801482 5372.57 7290.36 44.89 00753 6463.23 6120.14 7680.64 1905 19 2014.3 11/2404 0:00 Shipped Motorcycles 12/17/04 0:00 Shipped Motorcycles 2/3/05 000 Shipped Motorcycles 33705 0:00 Shipped Motorcycles 4/8/05 0:00 Shipped Motorcycles 5/1305 0:00 Disputed Motorcycles 1/2903 0:00 Shipped Classic Cars 32403 0:00 Shipped Classic Cars 5/2003 0:00 Shipped Classic Cars 7/2403 0:00 Shipped Classic Cars 91903 0.00 Shipped Classic Cars 10/2003 000 Shipped Classic Cars 11/303 0:00 Shipped Classic Cars 11/1103 0:00 Shipped Classic Cars 11/2503 0:00 Shipped Classic Cars 12/503 0:00 Shipped Classic Cars 1/2904 0:00 Shipped Classic Cars 110040,00 Shipped Classic Cars 5140400 Shipped Classic Cars VISO4000 Shipped Classic Cars 7/1904000 Shipped Claude Cars MIM04 0:00 Shipped Classic Cars Salzburg Austria Large Chatswood NSW Australia Small Nantes France Small New BedforMA USA Medium Liverpool Small Madrid Spain Norway Medium Lale Sweden Madrid Spain Large Burlingame CA USA Large Singapore Singapore Large NYC NY USA Medium South Brisb Queensland Australia Large Philadelphi: PA USA Medium Lyon France Large Vancouver BC Canada Large Burbank CA USA Medium Cambridge MA USA Medium New Haven CT USA Medium Minato-ku Tokyo Japan Large Chatswood NSW Australia Medium Torine Italy Large 21 34 23 42 47 11 6 3 2 9 6 29 14 32 21 34 2 Dashboard IE Calendar To Do Notifications Minbox 10291 10304 10312 10322 10333 10347 10359 10369 10381 10391 10411 10424 10107 10120 10134 10145 10159 10168 10180 10188 10201 10910 37 47 48 40 26 30 32 41 36 24 23 30 39 29 27 37 37 27 42 38 24 23 : Week2-Assignment Bus 308.xlsx 100 11 7136.19 9040.00 Shipped Classic Cars 100 6 10172.7 10/11/04 0:00 Shipped Classic Cars 100 3 11623.7 10/21/04 0:00 Shipped Classic Cars 100 1 60004 11/4/04 0:00 Shipped Classic Cars 100 3 3003 11/1804 0:00 Shipped Classic Cars 100 1 3944.7 11/2904 0:00 Shipped Classic Cars 100 10 $691.84 12/10/04 0:00 Shipped Classic Cars 100 2 4514.92 1/2005 0:00 Shipped Classic Cars 100 3 82548 2/17/05 0:00 Shipped Classic Cars 100 4 2416.56 1/905 0:00 Shipped Classic Cars 100 9 4140.23 5/1/0S 000 Shipped Classic Cars 100 6 12001 5/31/05 0:00 In Process Classic Cars 99.91 $ 3896.49 2/2403 0:00 Shipped Motorcycles 96.34 3 2793.86 4/2003 0:00 Shipped Motorcycles 100 $ 3307.77 1/1/03 0:00 Shipped Motorcycles 100 9 5192.95 B/2503 000 Shipped Motorcycles 100 17 501683 10/100) 0:00 Shipped Motorcycles 100 4 3660.91 10/2003 0:00 Shipped Motorcycles 100 12 4695,6 11/11/03 0.00 Shipped Motorcycles 96.34 4 3660.92 11/1800.00 Shipped Motorcycles 100 5 3025.92 12/1/03 0:00 Shipped Motorcycles 100 2 3000.00 1/1204000 Shipped Motorcycles Boras Sweden Large Versailles France Large San Rafael CA USA Large Nashwa NH USA Medium San Francis CA USA Medium Melbourne Victoria Australia Medium San Rafael CA USA Medium Brickhaven MA USA Medium San Francis CA USA Large North Sydns NSW Australia Small Montreal Queber Canada Medium Madrid Spain Large NYC NY USA Medium Melbourne Victoria Australia Small France Medium Pasadena CA USA Medium San Francis CA USA Medium Burlingame CA USA Medium Lille France Medium Bergen Norway Medium San Francis CA USA Medium Ouka Osaka Japan Medium Dashboard IE Calendar To Do D Notifications Inbox Week2-Assignment Bus 308.xlsx 10323 10236 10251 10263 10275 10285 10298 1010 10318 10129 10039 10361 10374 10388 10402 10417 10107 10120 10114 10143 10159 1016 ENCARANSERS 47 22 44 40 22 47 39 34 45 20 40 26 39 50 45 45 27 46 100 100 100 100 100 100 96.34 100 100 100 68.92 SL.IS 100 44.51 100 100 100 100 100 100 100 100 4 1 5 $ 4 9 1 2 4 2 4 8 5 $ 1 $ 4 2 4 5 16 $422.39 2852.03 5756.52 4472 290444 5484.59 1757.26 4043.96 55665 3176 2756.8 1329.9 5288.01 22255 58338 588735 6065.55 9266 7023.98 $176 15 41127 4K) 2/2004 0:00 Shipped Motorcycles 4/3/04 0:00 Shipped Motorcycles 5/18/04 0:00 Shipped Moforcycles 62804000 Shipped Motorcycles 7/21040.00 Shipped Motorcycles N27/04 0:00 Shipped Motorcycles 9/27/04 0:00 Shipped Motorcycles 10/15:04 0:00 Shipped Motorcycles 11/2004 0:00 Shipped Motorcycles 11/15-04 0:00 Shipped Motorcycles 11/21040:00 Shipped Motorcycles 12/17/04 0:00 Shipped Motorcycles 2/2005 0:00 Shipped Motorcycles 3/3705 0:00 Shipped Motorcycles 4/7/05 0:00 Shipped Motorcycles 130S 0:00 Disputed Motorcycles 2/2401 0:00 Shipped Motorcycles 4/2003 0.0 Shipper Morelos 7/1/01 0:00 Shipped Motorcycles N250 0:00 Shipped Motorcycles 10/10010 00 Shipped Motorcycles 100 000 Shipped Motorcycles Melbourne Victoria Australia Medium Philadelphia PA USA Small Newark NU USA Medium Bridgewater USA Medium Nantes France Small Cambridge MA USA Medium Nantes France Medium White Plain NY USA Medium Allentown PA USA Medium NYC NY USA Medium Minato-ku Tokyo Japan Small Chatswood NSW Australia Small South Brish Queensland Australia Medium New BedforMA USA Small Pris France Medium Madrid Spain Medium NY Medium Melbourne Victoria Australie Large I' France Large Pasadena CA USA Medium Se Francis CA USA Medium Burlingame CA USA Medium NYC USA 33 20 Dashboard IE Calendar To Do Notifications inbox Inbox Week2-Assignment Bus 308.xlsx G France Medium 3 4 1 3 9 + 4 3 39 43 La La 1010 10188 10201 10210 10223 10237 10251 10269 10275 105 1000 1610 103N 10329 10119 10162 10174 ION 10403 10412 10105 10119 27 29 20 37 26 100 100 100 100 100 100 100 100 100 100 100 100 100 100 76.67 100 100 3679 100 100 100 100 BOSSES N92 N7147 8065.89 01234 9774,03 7023.9 70782) 8336.94 192 S438.07 6683.14 45704 7667.14 5862 299013 16641 383438 3N22.17 118866 9218.16 7208 SOX 11/11/0300 Shipped Motorcycles 11/10000 Shipped Motorcycles 12/1/03 000 Shipped Motorcycles 1/1204000 Shipped Motorcycles 2/2004 0.00 Shipped Motorcycle 4504000 Shipped Motorcycles 5/181040,00 Shipped Motorcycles 62804000 Shipped Motorcycles 7/21040:00 Shipped Motorcycles 1/27/040 00 Shipped Motorcycles 9/2004 0:00 Shipped Motorcycles 10151010 00 Shipped Motorcycles 11/2004 0:00 Shipped Motorcycles 11/15 010 00 Shipped Morcycle 11/210000 Shipped Motorcycles 1/50000 Shipped Myles 2/20 000 Shipped Motorcycles VUOS 000 Shipped Mecanceles 4/05 0:00 Shipped Motorcycles /130S 0:00 Disputed Matches 2/11/10 00 Shipped Car 4203000 Shipped Classic Cars 11 1 3 3 3 4 1 7 9 4 2 11 NY Lille Large Bergen Norway Large San FCA USA Large Daka Osaka Japan Melbourne Victoria Australia Large NYC NY USA Newark N USA BridgewatcCY USA Large Nantes France Medium Cambridge MA USA Medium Helsinki Finland Medium White Plain NY USA Medium Allentown PA USA Large NYC USA Medium Minato-ko Tokyo Small Burlingame CA USA Me South Hirish Queensland Australia Medium New lied MA USA Small Liverpool UK Large Madrid Spain Large Kobenhavn Demak Large Salburg Austria Medium 22 22 21 00 Dashboard IE Calendar To Do Notifications Minbox Week2-Assignment Bus 308.xlsx G 32 44 24 20 UR Spain 59 10129 10143 10155 10167 1017 10186 10197 10200 10022 10248 10261 10273 1028 10295 1010 10116 10139 10119 10150 10159 10173 10184 BSA2888 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 6493 480S 75.47 54.6% 100 100 2 13 13 9 12 9 6 3 12 3 1 4 6 1 . 17 6 27 4398.34 5397.76 4526,08 5934.16 3492.48 3854.24 53244 $197.92 59976 2910.4 3378.24 350RS 2992 34272 2092 412.05 305171 1201.25 192.22 263464 4616.25 48467 W1203000 Shipped Classic Cars N1001 0:00 Shipped Classic Cars 100 000 Shipped Claus 102303 0:00 Cancelled Claw Cars 11/0 000 Shipped Classic Cars 11/14/01 000 Shipped Classic Cars 11/2003 0:00 Shipped Classic Cars 1/900000 Shipped Classic Cars 2/1904 0:00 Shipped Classic Cars 5/7/040,00 Cancelled Classic Cars (17040:00 Shipped Classic Cars 7/21/040.00 Shipped Classic Cars 82004000 Shipped Classic Cars 910010.00 Shipped Classic Cars 10/140400 Shipped Classic Cars 11/1/0400 Shipped Classic Cars 11/300000 Shipped Claus Cats 11/21/04000 Shippel Cha Can 12/2010 00 Shipped Clas Car 12/15:04 0:00 Shipped Classic Cars 1/31/08000 Shipped Classic Cars 2/2000 Shipped Clan Cans London UK New BedforMA USA Helsinki Finland Boras Sweden Toulouse France London Barcelona Los AngeleCA USA San Diego CA USA NYC NY USA Montreal Quebec Canada Bruxelles Belgium Tawassen BC Canada Boston MA USA Philadelphia USA Cowes tale of Wig UK Starver Norway NYC NY USA Madrid Spain Reims France Ole Finland San FCA USA Medium Medium Medium Medium Medit Medium Med Medium Medium Small Medium Medium Small Medium Small Medium Medium Small 23 24 22 47 25 20 48 Small 6 1 4 Small Medium Medium 54 Dashboard IE Calendar To Do Notifications Minbox * Week2-Assignment Bus 308.xlsx 32 2 9 3 4 19 42 22 10395 10400 10414 10103 10114 10126 10140 10150 10164 10175 10183 10194 10202 10212 10320 10245 10249 10910 10281 10791 1030s 1011) ARRA ARRASAAN 20 21 33 28 20 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 3370.56 906144 2764.88 $198.26 410525 3347.74 3188.12 1191.2 3536.82 $363.3 3433.36 4263.74 4076.19 7020.45 64265 459172 4033.18 4302.03 7020,64 38559 60. 4 1 2 9 1 4 15 4 9 2 12 2 9 4 13 7 3/17/05 0:00 Shipped Classic Cars 4/1/05 0:00 Shipped Classic Cars SOOS 0:00 On Home Classic Cars 1/29 030 00 Shipped Classic Cars 4/1/03000 Shipped Classic Cars 52801 0:00 Shipped Classic Cars 7/2403 0:00 Shipped Clasic Cars 9/19-01 000 Shipped Classic Cars 1021/030,00 Resolved Classic Cars 11/60000 Shippet Classic Cars 11/1VOJ 0:00 Shipped Classic Cars 11/2503 0:00 Shipped Classic Cars 12/01 0:00 Shipped Classic Cars 2004000 Shipped Classic Cars V11/040.00 Shipped Claus 540400 Shipped Clai Ca IVIS 04 0:00 Shipped Classic Cars 7/100100 Shipped Classic Cars M190.000 Shipped Classic Cars 904000 Shipped Classic Cars 10/108000 Shippel Classic Cars 102204000 Shipped Paris San Jose CA Boston MA Staver Paris Madrid Burlingame CA Singapore Grat London Philadelphi Lyon Boston MA Singapore San Rafael CA New HCT Singapore Chatwood NSW Allentown Boras Cambridge MA Vancouver France Medium USA Large USA Small Norway Medium France Medium Spain Medium USA Medium Singapore Medium Austria Medium UK Medium USA Medium Franec Medium USA Medium Singapore Large USA Medium USA Medium Singapore Medium Australia Medium USA Large Sueden Medium USA Medium Canal Medium 48 26 10 3 Dashboard IE Calendar To Do Notifications Minbox Week2-Assignment Bus308.xlsx G 9 1 4 15 4 0 10175 101R 10194 10207 10217 10229 10345 10259 10270 ROZRI 1039 100 10313 10322 10314 10147 10357 10370 103NI 10191 5362.83 343336 426.74 407619 7020:48 64265 4591.72 4031 4102 ON 702004 33 28 26 31 48 SU) 28 26 13 44 10 18 40 46 26 22 41 35 37 17 100 100 100 100 100 100 100 10 100 100 100 100 100 61.09 100 100 100 65.63 100 16 12 2 9 4 13 11603000 Shipped 1203 0:00 Shipped 11/2503 0:00 Shipped 12/903 0,00 Shipped 2400000 Shipped 3/11 0:00 Shipped 5:4014 0:00 Shipped 6:15/000,00 Shipped 1190000 Shipped /1964000 Shipped 98704 000 Shipped IM000 Shipped 10:22/04000 Shipped 11:40400 Shipped 11/10040,00 Hold 11/2904000 Shipped 12/10 000 Shipped 1/2008 000 Shipped 2/1700.00 Shipped 380S 0:00 Shipped Classic Cars Classic Cars Classic Cars Classic Cars Classic Cars Classic Cars Classic Cars Classic Cars Classic Cars Classic Cars Classic Cars Classic Can Classic Care Classic Cars Classic Cars Classic Cars Classic Cars Classic Cars Classic Can Classic Cars London Philadelphia PA Lyon Boston MA Singapore San Rafael CA New Haven CT Singapore Chu NSW Allentown PA Horas Cuernbede MA Vac BC Nahua NH Ende Melbourne Victoria Kanare CA North SydneNSW San CA North SNSW UK Medium USA Medium France Medium USA Medium Singapore Large USA Medium USA Medium Sing Medium Australia Medium USA Large Sweden Medium USA Medium Canada Medium USA Small Sweden Medium Austru Medium USA Medium Australia Small USA Medium Australia Small N 2 2 667 25154 318812 4428 $710.92 229705 31.54 1735.3 4 6 7