I am not providing a sample for Lab-based questions, because that is extremely straightforward.
1) Given a range called data, give me a count of how many
numbers in the range are evenly divisible by 5. Use COUNTIF
or COUNTIFS.
2) Same question, but use DCOUNT.
3) Same question, but use Array formulas.
4) Given a range called data, use a deliberate circular reference to find the all-time high.
5) Make a column chart based on a table with three columns. (Salesman, Widgets Sold, Gadgets Sold).
Sever the "Widgets Sold" series from the actual spreadsheet.
Make the chart title depend on the contents of cell G19.
6) Consider the following balloon mortgage:
Term: 5-year balloon mortgage
Principal: $200,000
Interest rate: 6.5%
Monthly payment: $1,264.14
Remaining balance at end of 5-year term: $187,222
Know how to calculate any of these, if you are provided with the rest.
7) Find the shortest word in a range (restricted to a single column). Use MATCH and INDEX to accomplish this. Bonus points if you can perform it in a single array formula.
Advanced Excel
Thursday, December 8, 2011
Tuesday, December 6, 2011
Final
Dec 22
4-6 PM
What chapters will the final be on?
Lab: 6, 7, 8
Lecture: 7,8,11,14,15,(EC:16,9),first section of 17 (charts)
reminders:
14 and 15 are really a single chapter
about array formulas.
Really, only focus on the counting and summing part of it.
that also means how to do AND and OR
in array formulas.
Overlap with Ch 7. SumIf, CountIf.
Ch 11 (financial formulas)
Dec 22
4-6 PM
What chapters will the final be on?
Lab: 6, 7, 8
Lecture: 7,8,11,14,15,(EC:16,9),first section of 17 (charts)
reminders:
14 and 15 are really a single chapter
about array formulas.
Really, only focus on the counting and summing part of it.
that also means how to do AND and OR
in array formulas.
Overlap with Ch 7. SumIf, CountIf.
Ch 11 (financial formulas)
Thursday, December 1, 2011
Tuesday, November 8, 2011
Actual Excel Exam, CS88, Spring 2009
1/1/2005,Dixon,1856.16,Dresses,No
1/2/2005,Hernandez,920.44,Blouses,Yes
1/2/2005,Lugo,532.03,Accessories,Yes
1/3/2005,Paredes,3316.74,Dresses,No
1/5/2005,Lugo,2058.95,Dresses,Yes
1/5/2005,Lugo,593.1,Skirts and Pants,No
1/5/2005,Paredes,1899.54,Dresses,No
1/5/2005,Hernandez,568.46,Skirts and Pants,Yes
1/6/2005,Dixon,1559.58,Dresses,No
1/7/2005,Lugo,237.86,Blouses,Yes
1/8/2005,Hernandez,256.25,Skirts and Pants,No
1/8/2005,Lugo,1167.31,Skirts and Pants,Yes
1/8/2005,Lugo,326.48,Blouses,Yes
1/9/2005,Dixon,1109.53,Sweaters,No
1/9/2005,Paredes,835.85,Skirts and Pants,No
1/9/2005,Paredes,1809.46,Dresses,Yes
1/9/2005,Paredes,1062.66,Blouses,Yes
1/10/2005,Lugo,3391.94,Dresses,Yes
1/10/2005,Paredes,978.55,Dresses,No
1/12/2005,Hernandez,2154.15,Dresses,No
1/13/2005,Hernandez,891.65,Dresses,Yes
1/13/2005,Lugo,1441.66,Blouses,No
1/13/2005,Hernandez,1288.7,Sweaters,Yes
1/14/2005,Dixon,100.95,Accessories,No
1/14/2005,Lugo,2037.14,Dresses,No
1/14/2005,Paredes,1356.34,Sweaters,No
1/14/2005,Dixon,2241.9,Dresses,Yes
1/14/2005,Dixon,1701.11,Blouses,Yes
1/14/2005,Hernandez,438.65,Blouses,No
1/15/2005,Lugo,447.25,Blouses,Yes
1/16/2005,Dixon,703.95,Blouses,Yes
1/16/2005,Hernandez,308.78,Blouses,No
1/16/2005,Lugo,1716.8,Dresses,Yes
1/16/2005,Paredes,986.13,Dresses,Yes
1/16/2005,Lugo,67.84,Lingerie,No
1/19/2005,Dixon,618.5,Skirts and Pants,No
1/19/2005,Paredes,1901.48,Dresses,Yes
1/19/2005,Paredes,997.68,Sweaters,Yes
1/21/2005,Dixon,25.25,Lingerie,No
1/21/2005,Lugo,1493.88,Dresses,Yes
1/21/2005,Lugo,1242.75,Sweaters,No
1/21/2005,Lugo,316.63,Blouses,No
1/21/2005,Paredes,93.75,Lingerie,No
1/22/2005,Paredes,519.45,Sweaters,No
1/22/2005,Paredes,1084.71,Skirts and Pants,Yes
1/23/2005,Hernandez,1469.59,Sweaters,No
1/23/2005,Hernandez,118.75,Lingerie,No
1/23/2005,Lugo,2239.44,Sweaters,Yes
1/23/2005,Lugo,1370.5,Sweaters,No
1/23/2005,Paredes,3469.24,Dresses,No
1/23/2005,Lugo,63.08,Lingerie,Yes
1/24/2005,Lugo,148.89,Skirts and Pants,No
1/24/2005,Hernandez,148.89,Skirts and Pants,No
1/26/2005,Hernandez,206.43,Blouses,Yes
1/26/2005,Hernandez,206.43,Blouses,No
1/26/2005,Lugo,938.19,Skirts and Pants,Yes
1/27/2005,Lugo,1616.56,Blouses,No
1/27/2005,Dixon,2212.39,Dresses,No
1/28/2005,Dixon,1565.85,Dresses,Yes
1/29/2005,Lugo,1200.64,Blouses,Yes
1/29/2005,Lugo,1437.38,Dresses,No
1/29/2005,Paredes,1284.86,Sweaters,No
1/30/2005,Dixon,959.24,Dresses,No
1/30/2005,Hernandez,1604.56,Blouses,No
1/30/2005,Hernandez,55.5,Accessories,No
1/30/2005,Lugo,1283.43,Sweaters,Yes
1/30/2005,Lugo,949.9,Sweaters,Yes
1/30/2005,Lugo,333.25,Blouses,No
1/30/2005,Paredes,873.33,Blouses,No
1/30/2005,Paredes,2741.64,Dresses,No
1/31/2005,Hernandez,74.79,Accessories,Yes
2/2/2005,Lugo,816.94,Blouses,No
2/2/2005,Paredes,1426.23,Sweaters,No
2/3/2005,Lugo,863.71,Skirts and Pants,No
2/3/2005,Lugo,1234.36,Dresses,No
2/4/2005,Dixon,2129.85,Dresses,No
2/4/2005,Lugo,1224.11,Sweaters,No
2/4/2005,Lugo,357.31,Accessories,No
2/4/2005,Paredes,2856.23,Dresses,No
2/4/2005,Lugo,681.34,Blouses,Yes
2/6/2005,Hernandez,938.14,Blouses,Yes
2/6/2005,Hernandez,462.48,Accessories,Yes
2/6/2005,Lugo,258.99,Lingerie,No
2/6/2005,Paredes,138.4,Lingerie,No
2/7/2005,Lugo,881.86,Blouses,Yes
2/7/2005,Paredes,677.19,Blouses,No
2/7/2005,Paredes,1910.46,Dresses,Yes
2/9/2005,Hernandez,264.01,Lingerie,Yes
2/9/2005,Lugo,492.51,Sweaters,No
2/9/2005,Paredes,477.15,Sweaters,No
2/10/2005,Dixon,1237.3,Dresses,No
2/10/2005,Hernandez,1370.93,Sweaters,Yes
2/10/2005,Lugo,31.99,Lingerie,No
2/11/2005,Hernandez,454.96,Accessories,No
2/11/2005,Hernandez,142.51,Skirts and Pants,No
2/11/2005,Paredes,142.51,Skirts and Pants,Yes
2/11/2005,Lugo,252.34,Lingerie,Yes
2/12/2005,Hernandez,1438.74,Sweaters,No
2/12/2005,Lugo,1246.16,Sweaters,No
2/12/2005,Lugo,527.64,Sweaters,No
2/13/2005,Hernandez,219.35,Blouses,No
2/13/2005,Hernandez,1843.13,Dresses,Yes
2/13/2005,Hernandez,453.9,Blouses,No
2/13/2005,Dixon,219.35,Blouses,Yes
2/14/2005,Dixon,622.08,Skirts and Pants,Yes
2/16/2005,Lugo,174.75,Blouses,Yes
2/16/2005,Hernandez,174.75,Blouses,Yes
2/17/2005,Dixon,560.31,Skirts and Pants,No
2/18/2005,Hernandez,1618.35,Sweaters,Yes
2/18/2005,Lugo,1167.75,Skirts and Pants,Yes
2/18/2005,Lugo,258.79,Blouses,No
2/18/2005,Lugo,1989.03,Dresses,No
2/19/2005,Dixon,26.23,Lingerie,Yes
2/19/2005,Hernandez,354.41,Blouses,Yes
2/19/2005,Lugo,554.94,Accessories,No
2/20/2005,Dixon,1132.8,Skirts and Pants,No
2/20/2005,Lugo,139.53,Skirts and Pants,Yes
2/20/2005,Lugo,139.53,Skirts and Pants,No
2/20/2005,Paredes,3471.83,Dresses,No
2/20/2005,Paredes,1391.2,Dresses,Yes
2/21/2005,Paredes,1387.35,Dresses,No
2/23/2005,Lugo,1725.06,Sweaters,Yes
2/24/2005,Dixon,674.98,Blouses,No
2/25/2005,Dixon,529.88,Accessories,No
2/25/2005,Paredes,1126.41,Dresses,Yes
2/26/2005,Hernandez,254.16,Blouses,No
2/26/2005,Lugo,65.28,Lingerie,No
2/26/2005,Paredes,534.24,Sweaters,No
2/27/2005,Hernandez,257.98,Blouses,Yes
2/27/2005,Lugo,1026,Sweaters,No
2/28/2005,Dixon,1238.8,Dresses,No
2/28/2005,Hernandez,783.91,Blouses,Yes
3/2/2005,Dixon,761.1,Accessories,No
3/2/2005,Hernandez,787.79,Skirts and Pants,Yes
3/2/2005,Paredes,980.24,Dresses,Yes
3/3/2005,Dixon,909.85,Blouses,Yes
3/3/2005,Hernandez,3400.49,Dresses,No
3/3/2005,Hernandez,297.74,Blouses,Yes
3/3/2005,Hernandez,537.05,Skirts and Pants,No
3/3/2005,Paredes,1101.63,Skirts and Pants,Yes
3/3/2005,Lugo,1998.6,Dresses,Yes
3/4/2005,Dixon,164.23,Lingerie,Yes
3/4/2005,Hernandez,1512.05,Sweaters,No
3/4/2005,Lugo,978.76,Dresses,Yes
3/4/2005,Paredes,606.71,Skirts and Pants,Yes
3/4/2005,Paredes,60.3,Accessories,Yes
3/4/2005,Hernandez,1285.68,Sweaters,No
3/4/2005,Dixon,1151,Skirts and Pants,Yes
3/5/2005,Dixon,1191.01,Skirts and Pants,No
3/6/2005,Dixon,874.26,Blouses,No
3/6/2005,Hernandez,177.14,Lingerie,Yes
3/6/2005,Lugo,474.98,Blouses,Yes
3/6/2005,Hernandez,69.38,Accessories,No
3/7/2005,Dixon,1265.78,Sweaters,No
3/9/2005,Dixon,600.1,Accessories,No
3/9/2005,Paredes,2483.69,Sweaters,Yes
3/10/2005,Paredes,855.4,Skirts and Pants,Yes
3/11/2005,Dixon,740.44,Blouses,No
3/11/2005,Dixon,563.6,Blouses,No
3/11/2005,Hernandez,547.01,Skirts and Pants,Yes
3/11/2005,Hernandez,379.44,Accessories,No
3/11/2005,Lugo,1834.18,Dresses,No
3/12/2005,Dixon,965.38,Dresses,No
3/12/2005,Hernandez,1592.4,Dresses,Yes
3/13/2005,Hernandez,1334.8,Sweaters,Yes
3/13/2005,Hernandez,824.09,Blouses,Yes
3/13/2005,Lugo,809.16,Blouses,No
3/13/2005,Lugo,170.68,Lingerie,No
3/13/2005,Lugo,315.54,Accessories,Yes
3/14/2005,Dixon,2115.45,Dresses,Yes
3/14/2005,Paredes,3235.49,Dresses,Yes
3/14/2005,Paredes,1300,Sweaters,No
3/16/2005,Hernandez,1204.96,Sweaters,Yes
3/16/2005,Paredes,869.18,Dresses,No
3/17/2005,Paredes,1401.13,Dresses,No
3/18/2005,Dixon,2823.93,Dresses,Yes
3/18/2005,Dixon,887.48,Skirts and Pants,No
3/18/2005,Dixon,273.83,Accessories,No
3/18/2005,Hernandez,1674.21,Sweaters,No
3/18/2005,Hernandez,1557.9,Dresses,No
3/18/2005,Lugo,721.66,Blouses,No
3/18/2005,Paredes,275.5,Lingerie,Yes
3/18/2005,Paredes,368.54,Accessories,No
3/18/2005,Lugo,620.53,Skirts and Pants,No
3/19/2005,Dixon,835.15,Sweaters,No
3/19/2005,Dixon,694.53,Accessories,No
3/19/2005,Hernandez,1062.11,Sweaters,Yes
3/19/2005,Hernandez,754.84,Blouses,No
3/20/2005,Hernandez,663.73,Accessories,Yes
3/20/2005,Hernandez,73.63,Accessories,Yes
3/20/2005,Lugo,776.8,Dresses,No
3/21/2005,Hernandez,1209.92,Dresses,No
3/21/2005,Paredes,256.42,Blouses,No
3/23/2005,Hernandez,865.65,Sweaters,Yes
3/23/2005,Hernandez,391.51,Blouses,Yes
3/23/2005,Hernandez,203.74,Accessories,No
3/23/2005,Paredes,178.96,Blouses,No
3/23/2005,Paredes,178.96,Blouses,No
3/24/2005,Hernandez,764.92,Sweaters,No
3/24/2005,Hernandez,198.17,Blouses,Yes
3/24/2005,Paredes,487.89,Blouses,Yes
3/24/2005,Dixon,19.71,Lingerie,No
3/25/2005,Hernandez,1425.52,Dresses,No
3/25/2005,Hernandez,545.62,Blouses,Yes
3/25/2005,Lugo,1066.51,Sweaters,No
3/26/2005,Hernandez,500.06,Blouses,No
3/26/2005,Hernandez,323.73,Accessories,No
3/26/2005,Lugo,65.04,Accessories,No
3/27/2005,Hernandez,330.51,Accessories,No
3/27/2005,Lugo,802.28,Sweaters,Yes
3/27/2005,Paredes,743.69,Sweaters,No
3/28/2005,Hernandez,923.15,Skirts and Pants,No
3/30/2005,Hernandez,1123.46,Dresses,Yes
3/30/2005,Hernandez,882.27,Sweaters,No
3/30/2005,Paredes,184.78,Blouses,No
3/31/2005,Dixon,1551.52,Dresses,No
3/31/2005,Hernandez,925.38,Dresses,No
4/1/2005,Paredes,1397.36,Dresses,Yes
4/1/2005,Dixon,433.94,Skirts and Pants,No
4/2/2005,Hernandez,1331.43,Dresses,No
4/2/2005,Paredes,1755.57,Sweaters,No
4/2/2005,Paredes,1259.16,Dresses,Yes
4/2/2005,Hernandez,50.28,Lingerie,No
4/3/2005,Lugo,759.7,Sweaters,No
4/3/2005,Paredes,903.33,Sweaters,No
4/3/2005,Paredes,128.18,Blouses,Yes
4/3/2005,Paredes,128.18,Blouses,Yes
4/3/2005,Lugo,502.26,Skirts and Pants,Yes
4/4/2005,Lugo,1476.58,Dresses,Yes
4/6/2005,Hernandez,677.13,Sweaters,Yes
4/6/2005,Paredes,1155.49,Blouses,Yes
4/7/2005,Hernandez,821.85,Dresses,No
4/7/2005,Lugo,1363.62,Sweaters,No
4/7/2005,Lugo,515.95,Blouses,Yes
4/7/2005,Lugo,199.36,Lingerie,Yes
4/7/2005,Paredes,2181.6,Dresses,No
4/8/2005,Dixon,1049.36,Sweaters,No
4/8/2005,Dixon,823.39,Skirts and Pants,No
4/8/2005,Hernandez,1027.29,Sweaters,Yes
4/8/2005,Hernandez,265.02,Accessories,No
4/8/2005,Paredes,272.68,Blouses,No
4/9/2005,Dixon,944.72,Sweaters,No
4/9/2005,Hernandez,961.39,Blouses,Yes
4/9/2005,Hernandez,492.72,Accessories,Yes
4/10/2005,Dixon,636.04,Accessories,No
4/10/2005,Dixon,570.58,Blouses,Yes
4/10/2005,Hernandez,1150.41,Dresses,No
4/10/2005,Hernandez,729.75,Blouses,No
4/10/2005,Lugo,931.06,Dresses,Yes
4/10/2005,Paredes,207.36,Blouses,Yes
4/10/2005,Paredes,853.89,Sweaters,Yes
4/10/2005,Lugo,387.14,Sweaters,Yes
4/11/2005,Hernandez,548.35,Blouses,No
4/11/2005,Hernandez,817.43,Skirts and Pants,No
4/13/2005,Hernandez,2582.14,Dresses,No
4/13/2005,Hernandez,1865.33,Blouses,No
4/13/2005,Lugo,530.29,Blouses,Yes
4/13/2005,Dixon,899.32,Dresses,No
4/14/2005,Hernandez,922.25,Skirts and Pants,No
4/14/2005,Dixon,744.36,Blouses,No
4/14/2005,Hernandez,672.65,Sweaters,No
4/15/2005,Lugo,399.08,Accessories,No
4/15/2005,Paredes,313.98,Accessories,No
4/16/2005,Dixon,1371.04,Sweaters,Yes
4/16/2005,Hernandez,25.02,Lingerie,Yes
4/16/2005,Lugo,142.94,Blouses,No
4/16/2005,Lugo,142.94,Blouses,No
4/16/2005,Paredes,616.98,Accessories,Yes
4/17/2005,Hernandez,681.03,Blouses,No
4/17/2005,Hernandez,559.77,Accessories,Yes
4/17/2005,Paredes,681.13,Dresses,No
4/17/2005,Paredes,305.96,Skirts and Pants,No
4/18/2005,Dixon,1354.13,Dresses,No
4/20/2005,Dixon,613.24,Accessories,No
4/20/2005,Dixon,23.87,Lingerie,Yes
4/20/2005,Lugo,1298.99,Dresses,No
4/20/2005,Lugo,360.17,Accessories,No
4/21/2005,Dixon,817.91,Blouses,No
4/21/2005,Hernandez,2140.44,Dresses,No
4/21/2005,Hernandez,1213.59,Dresses,Yes
4/21/2005,Dixon,644.31,Accessories,Yes
4/22/2005,Hernandez,2100.39,Dresses,Yes
4/22/2005,Lugo,115,Lingerie,Yes
4/23/2005,Hernandez,1696.76,Blouses,No
4/23/2005,Lugo,1243.12,Dresses,No
4/23/2005,Lugo,784.86,Dresses,No
4/24/2005,Hernandez,1447.35,Dresses,No
4/24/2005,Hernandez,783.96,Blouses,Yes
4/24/2005,Hernandez,325.3,Blouses,Yes
4/24/2005,Lugo,501.13,Skirts and Pants,No
4/24/2005,Lugo,254.64,Accessories,Yes
4/25/2005,Lugo,714.16,Accessories,No
4/27/2005,Dixon,1271.8,Dresses,Yes
4/27/2005,Hernandez,587.85,Accessories,Yes
4/27/2005,Lugo,1608.15,Dresses,Yes
4/27/2005,Lugo,111.32,Skirts and Pants,No
4/27/2005,Dixon,111.32,Skirts and Pants,No
4/28/2005,Dixon,1049.54,Sweaters,No
4/28/2005,Hernandez,1133.16,Sweaters,No
4/28/2005,Lugo,189.94,Lingerie,Yes
4/29/2005,Dixon,207.3,Lingerie,Yes
4/29/2005,Hernandez,726.1,Dresses,Yes
4/29/2005,Hernandez,218.73,Accessories,No
4/29/2005,Hernandez,393.6,Accessories,Yes
4/30/2005,Lugo,562.88,Blouses,No
5/1/2005,Dixon,588.6,Blouses,No
5/1/2005,Dixon,410.38,Skirts and Pants,No
5/1/2005,Hernandez,756.09,Blouses,No
5/1/2005,Hernandez,740.06,Blouses,Yes
5/1/2005,Hernandez,711.97,Dresses,Yes
5/1/2005,Lugo,278.74,Blouses,No
5/1/2005,Lugo,1347.29,Dresses,No
5/1/2005,Paredes,44.78,Accessories,No
5/2/2005,Hernandez,232.06,Accessories,No
5/2/2005,Lugo,398.15,Skirts and Pants,Yes
5/5/2005,Dixon,795.74,Dresses,No
5/6/2005,Dixon,761.8,Blouses,Yes
5/6/2005,Paredes,705.06,Dresses,Yes
5/7/2005,Lugo,1497.04,Dresses,Yes
5/7/2005,Paredes,761.77,Dresses,No
5/9/2005,Hernandez,423.05,Blouses,Yes
5/12/2005,Lugo,811.4,Dresses,No
5/13/2005,Paredes,285.57,Accessories,No
5/14/2005,Hernandez,471.7,Accessories,No
5/15/2005,Dixon,1108.61,Sweaters,Yes
5/16/2005,Lugo,204.99,Accessories,No
5/19/2005,Hernandez,150.03,Blouses,Yes
5/19/2005,Lugo,150.03,Blouses,No
5/21/2005,Dixon,1882.59,Blouses,No
5/21/2005,Hernandez,180.74,Blouses,Yes
5/21/2005,Dixon,180.74,Blouses,No
5/22/2005,Hernandez,729.35,Blouses,No
5/23/2005,Hernandez,381.53,Skirts and Pants,No
5/23/2005,Hernandez,145.87,Skirts and Pants,No
5/23/2005,Hernandez,47.39,Lingerie,No
5/23/2005,Paredes,806.55,Skirts and Pants,No
5/24/2005,Dixon,1222.03,Dresses,No
5/26/2005,Paredes,524.12,Blouses,No
5/27/2005,Paredes,689.45,Sweaters,No
5/29/2005,Hernandez,1881.54,Dresses,No
5/30/2005,Dixon,427.67,Accessories,No
5/30/2005,Hernandez,853.52,Dresses,No
5/30/2005,Lugo,802.43,Blouses,No
6/2/2005,Lugo,1704.62,Blouses,No
6/3/2005,Hernandez,1505.71,Dresses,No
6/4/2005,Hernandez,704.24,Dresses,No
6/5/2005,Dixon,1707.3,Blouses,No
6/5/2005,Hernandez,929.25,Sweaters,No
6/6/2005,Lugo,1132,Sweaters,No
6/6/2005,Paredes,147.25,Skirts and Pants,No
6/9/2005,Hernandez,1105.64,Sweaters,Yes
6/9/2005,Hernandez,678.87,Sweaters,No
6/10/2005,Paredes,2070.88,Dresses,No
6/10/2005,Paredes,543.8,Blouses,No
6/11/2005,Lugo,490.68,Accessories,No
6/12/2005,Paredes,525.79,Skirts and Pants,No
6/13/2005,Hernandez,858.27,Sweaters,No
6/13/2005,Hernandez,548.85,Skirts and Pants,No
6/13/2005,Hernandez,19.43,Lingerie,No
6/14/2005,Dixon,238.02,Skirts and Pants,No
6/16/2005,Dixon,1191.99,Sweaters,No
6/17/2005,Paredes,804.37,Blouses,Yes
6/18/2005,Hernandez,652.75,Blouses,Yes
6/18/2005,Lugo,1710.1,Sweaters,Yes
6/19/2005,Dixon,1468.11,Sweaters,No
6/19/2005,Hernandez,782.74,Blouses,No
6/20/2005,Lugo,20.06,Lingerie,Yes
6/24/2005,Hernandez,976.03,Sweaters,No
6/25/2005,Lugo,1454.81,Dresses,Yes
6/26/2005,Hernandez,289.51,Blouses,No
6/30/2005,Dixon,803.25,Skirts and Pants,No
6/30/2005,Hernandez,2064.76,Dresses,Yes
6/30/2005,Lugo,624.19,Skirts and Pants,No
6/30/2005,Paredes,813.82,Sweaters,Yes
7/1/2005,Dixon,1010.05,Sweaters,No
7/1/2005,Dixon,704.39,Sweaters,No
7/1/2005,Hernandez,338.87,Skirts and Pants,No
7/2/2005,Hernandez,2063.78,Dresses,Yes
7/2/2005,Paredes,449.52,Accessories,Yes
7/4/2005,Dixon,579.45,Blouses,No
7/4/2005,Dixon,566.01,Skirts and Pants,Yes
7/4/2005,Dixon,467.26,Skirts and Pants,Yes
7/4/2005,Hernandez,738.89,Blouses,No
7/4/2005,Paredes,361.34,Blouses,Yes
7/6/2005,Hernandez,745.5,Blouses,No
7/6/2005,Hernandez,220.44,Accessories,No
7/7/2005,Paredes,363.13,Skirts and Pants,No
7/8/2005,Dixon,667.81,Dresses,Yes
7/9/2005,Lugo,54.94,Accessories,Yes
7/9/2005,Lugo,199.07,Accessories,No
7/10/2005,Lugo,221.01,Accessories,Yes
7/10/2005,Hernandez,758.37,Sweaters,Yes
7/10/2005,Dixon,319.77,Accessories,No
7/11/2005,Dixon,876.03,Dresses,No
7/11/2005,Hernandez,933,Sweaters,Yes
7/12/2005,Dixon,1491.91,Dresses,No
7/14/2005,Hernandez,1137.25,Sweaters,No
7/14/2005,Hernandez,86.38,Accessories,No
7/14/2005,Hernandez,86.38,Accessories,No
7/14/2005,Dixon,341.42,Accessories,Yes
7/14/2005,Hernandez,1059.49,Sweaters,Yes
7/15/2005,Lugo,792.61,Blouses,No
7/16/2005,Hernandez,486.49,Blouses,Yes
7/16/2005,Hernandez,245.45,Accessories,No
7/16/2005,Paredes,848.88,Skirts and Pants,Yes
7/16/2005,Lugo,1425,Dresses,Yes
7/16/2005,Paredes,541.62,Accessories,No
7/18/2005,Paredes,762.88,Blouses,No
7/19/2005,Dixon,2140.78,Dresses,No
7/20/2005,Lugo,162.49,Blouses,No
7/20/2005,Paredes,162.49,Blouses,No
7/21/2005,Dixon,464.18,Blouses,No
7/21/2005,Hernandez,519.91,Skirts and Pants,No
7/22/2005,Dixon,1151.91,Dresses,Yes
7/22/2005,Dixon,129.31,Blouses,No
7/22/2005,Lugo,749.24,Blouses,Yes
7/22/2005,Paredes,129.31,Blouses,No
7/23/2005,Hernandez,560.38,Blouses,Yes
7/23/2005,Paredes,1546.4,Dresses,Yes
7/25/2005,Dixon,649.04,Blouses,No
7/25/2005,Dixon,524.17,Blouses,Yes
7/25/2005,Hernandez,1236.7,Dresses,Yes
7/25/2005,Hernandez,120.35,Blouses,No
7/25/2005,Lugo,120.35,Blouses,No
7/27/2005,Hernandez,1705.15,Sweaters,No
7/29/2005,Dixon,1496.74,Dresses,Yes
7/29/2005,Paredes,781.39,Dresses,No
7/29/2005,Paredes,251.99,Accessories,No
7/30/2005,Dixon,483.38,Accessories,No
7/30/2005,Lugo,420.23,Skirts and Pants,No
7/31/2005,Dixon,1120.11,Dresses,Yes
7/31/2005,Dixon,422.98,Accessories,Yes
8/1/2005,Dixon,1019.17,Blouses,No
8/1/2005,Dixon,517.89,Blouses,No
8/1/2005,Dixon,410.82,Skirts and Pants,No
8/1/2005,Hernandez,2500.28,Dresses,No
8/1/2005,Lugo,818.74,Sweaters,Yes
8/1/2005,Paredes,1223.51,Dresses,No
8/2/2005,Paredes,1367.38,Dresses,No
8/4/2005,Dixon,1379.25,Blouses,No
8/5/2005,Paredes,1146.18,Dresses,Yes
8/6/2005,Dixon,845.57,Dresses,No
8/6/2005,Dixon,154.74,Blouses,No
8/6/2005,Hernandez,154.74,Blouses,No
8/6/2005,Paredes,362.01,Accessories,Yes
8/7/2005,Dixon,1215.29,Skirts and Pants,Yes
8/8/2005,Dixon,1473.64,Dresses,No
8/8/2005,Paredes,661,Sweaters,No
8/9/2005,Hernandez,618.51,Blouses,No
8/9/2005,Paredes,278.61,Accessories,Yes
8/11/2005,Dixon,612.04,Skirts and Pants,No
8/11/2005,Dixon,443.66,Dresses,Yes
8/11/2005,Dixon,119.9,Lingerie,No
8/12/2005,Dixon,1331.75,Dresses,No
8/12/2005,Dixon,1161.58,Sweaters,No
8/12/2005,Hernandez,1188.68,Dresses,No
8/12/2005,Hernandez,50.09,Lingerie,Yes
8/13/2005,Dixon,547.4,Skirts and Pants,No
8/13/2005,Hernandez,1227.12,Dresses,No
8/13/2005,Hernandez,345.72,Blouses,Yes
8/13/2005,Lugo,48.43,Lingerie,Yes
8/14/2005,Dixon,412.11,Accessories,Yes
8/14/2005,Lugo,1641.19,Dresses,No
8/14/2005,Paredes,485.95,Skirts and Pants,Yes
8/14/2005,Paredes,115.66,Skirts and Pants,Yes
8/14/2005,Lugo,115.66,Skirts and Pants,Yes
8/15/2005,Hernandez,288.19,Blouses,Yes
8/15/2005,Lugo,90.89,Accessories,Yes
8/15/2005,Hernandez,90.89,Accessories,Yes
8/16/2005,Dixon,1430.23,Dresses,No
8/16/2005,Dixon,850.73,Sweaters,No
8/16/2005,Hernandez,518.89,Blouses,No
8/16/2005,Paredes,382.6,Accessories,No
8/18/2005,Lugo,1053.28,Dresses,No
8/18/2005,Paredes,24.16,Lingerie,Yes
8/19/2005,Dixon,577.76,Skirts and Pants,No
8/20/2005,Dixon,2638.84,Dresses,Yes
8/20/2005,Dixon,495.86,Skirts and Pants,No
8/21/2005,Dixon,1284.36,Dresses,No
8/21/2005,Dixon,1172.72,Dresses,No
8/21/2005,Dixon,961.75,Dresses,No
8/21/2005,Dixon,156.03,Blouses,Yes
8/21/2005,Hernandez,117.91,Skirts and Pants,No
8/21/2005,Dixon,156.03,Blouses,Yes
8/21/2005,Dixon,117.91,Skirts and Pants,No
8/22/2005,Paredes,646.85,Blouses,No
8/23/2005,Hernandez,1406.08,Sweaters,No
8/26/2005,Dixon,601.32,Blouses,No
8/26/2005,Dixon,25.29,Lingerie,Yes
8/26/2005,Hernandez,2632.74,Dresses,No
8/27/2005,Dixon,1145.8,Blouses,Yes
8/27/2005,Lugo,494.39,Blouses,No
8/28/2005,Dixon,110.09,Lingerie,Yes
8/28/2005,Lugo,486.89,Skirts and Pants,No
8/29/2005,Hernandez,1364.55,Dresses,Yes
8/30/2005,Dixon,717.19,Dresses,No
8/30/2005,Hernandez,100.64,Skirts and Pants,Yes
8/30/2005,Hernandez,100.64,Skirts and Pants,No
8/31/2005,Lugo,248.31,Blouses,No
9/1/2005,Paredes,949.99,Skirts and Pants,No
9/2/2005,Dixon,1524.09,Dresses,Yes
9/2/2005,Hernandez,100.27,Lingerie,No
9/2/2005,Lugo,1239.03,Sweaters,No
9/3/2005,Dixon,2093.08,Dresses,No
9/3/2005,Dixon,683.87,Skirts and Pants,Yes
9/3/2005,Dixon,168.17,Blouses,Yes
9/3/2005,Hernandez,1716.91,Dresses,No
9/3/2005,Paredes,168.17,Blouses,No
9/4/2005,Hernandez,515.45,Accessories,No
9/5/2005,Dixon,1874.71,Sweaters,Yes
9/5/2005,Lugo,671.73,Blouses,No
9/8/2005,Dixon,1070.19,Dresses,Yes
9/8/2005,Hernandez,349.1,Blouses,No
9/9/2005,Hernandez,428.55,Skirts and Pants,Yes
9/10/2005,Hernandez,649.87,Blouses,No
9/10/2005,Lugo,1249.33,Dresses,No
9/10/2005,Lugo,206.05,Accessories,No
9/10/2005,Paredes,1388.88,Sweaters,No
9/11/2005,Hernandez,2552.98,Dresses,No
9/11/2005,Hernandez,1065.37,Skirts and Pants,No
9/11/2005,Hernandez,575.59,Blouses,Yes
9/11/2005,Paredes,858.52,Skirts and Pants,Yes
9/11/2005,Paredes,472.7,Skirts and Pants,Yes
9/11/2005,Paredes,211.61,Skirts and Pants,No
9/12/2005,Lugo,621.34,Blouses,No
9/13/2005,Paredes,379.2,Accessories,Yes
9/15/2005,Dixon,1047.31,Dresses,Yes
9/17/2005,Paredes,1319.26,Blouses,No
9/17/2005,Paredes,944.47,Dresses,Yes
9/18/2005,Dixon,754.15,Blouses,No
9/18/2005,Dixon,1131.33,Sweaters,No
9/18/2005,Hernandez,643.25,Blouses,Yes
9/18/2005,Hernandez,185.08,Blouses,No
9/19/2005,Hernandez,484.47,Skirts and Pants,No
9/19/2005,Lugo,1545.95,Dresses,No
9/19/2005,Paredes,1273.93,Dresses,No
9/19/2005,Paredes,1115.98,Sweaters,No
9/22/2005,Dixon,558.78,Blouses,No
9/22/2005,Lugo,1130.44,Dresses,Yes
9/23/2005,Hernandez,1410.72,Dresses,No
9/23/2005,Paredes,544.92,Blouses,No
9/24/2005,Lugo,119.75,Blouses,No
9/24/2005,Paredes,881.16,Sweaters,No
9/24/2005,Dixon,119.75,Blouses,Yes
9/25/2005,Dixon,496.78,Blouses,No
9/26/2005,Lugo,742.04,Dresses,Yes
9/26/2005,Paredes,838.79,Skirts and Pants,No
9/26/2005,Paredes,341.09,Accessories,No
9/26/2005,Paredes,147.25,Skirts and Pants,No
9/27/2005,Paredes,410.23,Sweaters,No
9/29/2005,Hernandez,554.71,Blouses,No
9/30/2005,Hernandez,136.62,Blouses,Yes
9/30/2005,Paredes,689.02,Accessories,No
9/30/2005,Hernandez,1224.19,Dresses,Yes
9/30/2005,Lugo,329.51,Blouses,No
9/30/2005,Paredes,136.62,Blouses,No
10/1/2005,Lugo,61.7,Accessories,No
10/1/2005,Paredes,397.7,Skirts and Pants,Yes
10/3/2005,Dixon,494.15,Blouses,No
10/3/2005,Dixon,23.62,Lingerie,No
10/3/2005,Hernandez,1620.22,Blouses,No
10/3/2005,Paredes,843.79,Skirts and Pants,No
10/4/2005,Paredes,254.13,Skirts and Pants,Yes
10/4/2005,Paredes,25.14,Lingerie,Yes
10/4/2005,Lugo,183.07,Blouses,No
10/7/2005,Dixon,768.71,Sweaters,Yes
10/7/2005,Paredes,498.02,Skirts and Pants,Yes
10/8/2005,Paredes,676.53,Dresses,Yes
10/8/2005,Hernandez,1378.1,Dresses,Yes
10/9/2005,Dixon,2595.19,Dresses,Yes
10/9/2005,Paredes,1148.52,Sweaters,No
10/9/2005,Paredes,728.55,Dresses,No
10/10/2005,Hernandez,286.78,Blouses,Yes
10/10/2005,Lugo,1014.87,Dresses,No
10/10/2005,Dixon,198.46,Lingerie,Yes
10/11/2005,Lugo,1133.71,Dresses,No
10/11/2005,Dixon,173.16,Blouses,No
10/11/2005,Hernandez,173.16,Blouses,No
10/13/2005,Hernandez,147.65,Blouses,No
10/13/2005,Lugo,697.08,Blouses,No
10/13/2005,Paredes,147.65,Blouses,No
10/14/2005,Dixon,178.17,Blouses,No
10/14/2005,Hernandez,178.17,Blouses,No
10/14/2005,Paredes,1454.84,Dresses,No
10/14/2005,Paredes,968.77,Sweaters,Yes
10/14/2005,Paredes,1019.68,Sweaters,Yes
10/14/2005,Paredes,509.14,Accessories,Yes
10/15/2005,Hernandez,697.29,Sweaters,No
10/15/2005,Paredes,1674.96,Dresses,No
10/15/2005,Lugo,549.47,Accessories,Yes
10/16/2005,Lugo,1005.93,Dresses,No
10/16/2005,Hernandez,1649.23,Dresses,Yes
10/17/2005,Dixon,1135.62,Skirts and Pants,No
10/17/2005,Dixon,817.72,Dresses,No
10/18/2005,Hernandez,545.96,Blouses,Yes
10/20/2005,Hernandez,2510.51,Dresses,No
10/21/2005,Lugo,174.87,Blouses,Yes
10/21/2005,Lugo,174.87,Blouses,Yes
10/21/2005,Dixon,339.07,Accessories,Yes
10/22/2005,Dixon,1181.71,Dresses,No
10/23/2005,Dixon,1634.97,Dresses,No
10/23/2005,Dixon,1092.71,Sweaters,Yes
10/23/2005,Lugo,141.56,Blouses,No
10/23/2005,Paredes,106.44,Skirts and Pants,No
10/23/2005,Paredes,106.44,Skirts and Pants,Yes
10/23/2005,Dixon,141.56,Blouses,No
10/24/2005,Lugo,24.79,Lingerie,No
10/24/2005,Paredes,693.8,Dresses,Yes
10/25/2005,Hernandez,80.75,Lingerie,Yes
10/25/2005,Lugo,358.63,Accessories,No
10/27/2005,Dixon,698.02,Blouses,Yes
10/27/2005,Hernandez,729.21,Blouses,Yes
10/28/2005,Paredes,143.45,Blouses,Yes
10/28/2005,Hernandez,1644.81,Dresses,Yes
10/28/2005,Lugo,143.45,Blouses,No
10/29/2005,Dixon,927.67,Sweaters,Yes
10/29/2005,Dixon,804.66,Blouses,Yes
10/29/2005,Hernandez,1059.53,Sweaters,Yes
10/29/2005,Paredes,1298.85,Sweaters,No
10/29/2005,Paredes,831.68,Sweaters,No
10/29/2005,Paredes,1315.73,Dresses,No
10/30/2005,Lugo,1094.12,Dresses,No
10/31/2005,Paredes,1379.82,Dresses,Yes
11/4/2005,Paredes,1828.89,Dresses,No
11/4/2005,Lugo,946.25,Sweaters,Yes
11/5/2005,Dixon,848.85,Blouses,Yes
11/5/2005,Hernandez,253.28,Blouses,No
11/5/2005,Lugo,467.47,Skirts and Pants,No
11/5/2005,Lugo,364.56,Blouses,Yes
11/5/2005,Paredes,947.67,Skirts and Pants,No
11/5/2005,Paredes,609.81,Accessories,No
11/6/2005,Dixon,1782.92,Blouses,No
11/7/2005,Hernandez,471.93,Blouses,No
11/8/2005,Paredes,911.64,Blouses,No
11/8/2005,Dixon,1886.24,Dresses,No
11/10/2005,Paredes,1700.74,Dresses,No
11/11/2005,Dixon,1528.08,Sweaters,No
11/11/2005,Hernandez,811.97,Sweaters,No
11/12/2005,Hernandez,1712.04,Blouses,No
11/14/2005,Hernandez,560.31,Blouses,No
11/14/2005,Lugo,2186.66,Dresses,Yes
11/15/2005,Hernandez,163.93,Blouses,Yes
11/15/2005,Lugo,163.93,Blouses,Yes
11/15/2005,Paredes,405.24,Skirts and Pants,No
11/17/2005,Dixon,285.31,Accessories,Yes
11/18/2005,Dixon,264.2,Blouses,No
11/18/2005,Hernandez,231.86,Skirts and Pants,No
11/18/2005,Hernandez,89.96,Accessories,Yes
11/18/2005,Hernandez,89.96,Accessories,Yes
11/18/2005,Lugo,499.66,Skirts and Pants,No
11/18/2005,Hernandez,878.94,Dresses,No
11/18/2005,Lugo,236.98,Lingerie,No
11/20/2005,Hernandez,570.46,Skirts and Pants,Yes
11/20/2005,Paredes,1198.49,Dresses,No
11/20/2005,Paredes,954.02,Sweaters,Yes
11/20/2005,Paredes,651.71,Blouses,No
11/21/2005,Paredes,855.42,Blouses,No
11/21/2005,Paredes,412.89,Blouses,Yes
11/24/2005,Lugo,1782.01,Dresses,No
11/25/2005,Dixon,550.98,Skirts and Pants,No
11/25/2005,Lugo,1895.3,Dresses,Yes
11/25/2005,Paredes,526.94,Skirts and Pants,No
11/26/2005,Hernandez,957.36,Dresses,No
11/27/2005,Hernandez,1248.26,Blouses,Yes
11/27/2005,Hernandez,543.38,Skirts and Pants,Yes
11/27/2005,Hernandez,194.07,Blouses,Yes
11/27/2005,Hernandez,109,Accessories,No
11/27/2005,Hernandez,109,Accessories,No
11/27/2005,Lugo,1251.37,Sweaters,No
11/27/2005,Paredes,194.07,Blouses,No
11/28/2005,Dixon,22.09,Lingerie,Yes
11/28/2005,Hernandez,312.53,Blouses,Yes
11/28/2005,Lugo,2510.71,Dresses,Yes
11/28/2005,Hernandez,1776.36,Dresses,No
11/30/2005,Dixon,3036.21,Dresses,Yes
12/2/2005,Dixon,1639.96,Dresses,No
12/2/2005,Lugo,1010.45,Sweaters,No
12/2/2005,Paredes,1345.72,Sweaters,No
12/2/2005,Paredes,56.97,Lingerie,No
12/2/2005,Dixon,472.85,Accessories,Yes
12/3/2005,Paredes,23.39,Lingerie,Yes
12/3/2005,Hernandez,1868.16,Dresses,Yes
12/4/2005,Dixon,566.24,Skirts and Pants,Yes
12/4/2005,Paredes,1139.18,Dresses,No
12/5/2005,Dixon,821.23,Skirts and Pants,No
12/5/2005,Hernandez,1809.48,Dresses,Yes
12/8/2005,Hernandez,2515.15,Dresses,No
12/8/2005,Hernandez,566.57,Skirts and Pants,No
12/8/2005,Lugo,689.29,Blouses,No
12/9/2005,Dixon,878.24,Blouses,No
12/9/2005,Paredes,889.96,Blouses,Yes
12/9/2005,Paredes,568.25,Blouses,No
12/9/2005,Paredes,955.92,Dresses,No
12/9/2005,Paredes,453.72,Skirts and Pants,No
12/10/2005,Dixon,820.81,Sweaters,No
12/11/2005,Dixon,1538.1,Sweaters,Yes
12/12/2005,Dixon,1046.19,Skirts and Pants,No
12/12/2005,Lugo,1856.71,Dresses,No
12/12/2005,Hernandez,421.42,Accessories,No
12/13/2005,Hernandez,127.11,Lingerie,Yes
12/13/2005,Paredes,1013.75,Skirts and Pants,No
12/13/2005,Paredes,481.94,Accessories,No
12/13/2005,Dixon,208.09,Blouses,No
12/13/2005,Dixon,208.09,Blouses,Yes
12/15/2005,Hernandez,863.3,Sweaters,No
12/15/2005,Lugo,138.48,Skirts and Pants,No
12/15/2005,Hernandez,138.48,Blouses,Yes
12/16/2005,Dixon,811.24,Dresses,No
12/16/2005,Paredes,224.41,Lingerie,No
12/17/2005,Paredes,311.55,Accessories,No
12/18/2005,Paredes,1480.12,Dresses,No
12/19/2005,Dixon,1660.08,Blouses,No
12/19/2005,Dixon,1232.64,Sweaters,Yes
12/19/2005,Hernandez,1132.48,Sweaters,Yes
12/19/2005,Hernandez,154.76,Blouses,No
12/19/2005,Hernandez,154.76,Blouses,No
12/19/2005,Lugo,998.75,Dresses,Yes
12/20/2005,Hernandez,1412.03,Sweaters,No
12/20/2005,Paredes,842.86,Blouses,No
12/22/2005,Dixon,1665.05,Dresses,Yes
12/22/2005,Lugo,67.41,Accessories,No
12/23/2005,Paredes,1775.32,Dresses,Yes
12/23/2005,Paredes,762.6,Accessories,No
12/24/2005,Hernandez,174.91,Blouses,No
12/24/2005,Paredes,530.04,Blouses,No
12/24/2005,Paredes,148.05,Blouses,No
12/24/2005,Paredes,148.05,Blouses,No
12/24/2005,Paredes,174.91,Blouses,Yes
12/25/2005,Lugo,223.86,Blouses,No
12/26/2005,Hernandez,2888.04,Dresses,Yes
12/26/2005,Hernandez,838.44,Sweaters,Yes
12/26/2005,Hernandez,233.4,Lingerie,Yes
12/26/2005,Lugo,320.75,Skirts and Pants,Yes
12/27/2005,Hernandez,1254.44,Sweaters,No
12/29/2005,Lugo,1975.13,Dresses,No
12/30/2005,Paredes,174.7,Blouses,Yes
12/30/2005,Hernandez,174.7,Blouses,No
12/31/2005,Dixon,846.81,Sweaters,Yes
12/31/2005,Paredes,1015.97,Sweaters,Yes
12/31/2005,Paredes,536.68,Skirts and Pants,No
12/31/2005,Dixon,133.35,Skirts and Pants,No
12/31/2005,Dixon,133.35,Skirts and Pants,Yes
12 points each
Date, Time arithmetic
- Put today’s date in cell A1. In cell A2, give me the date which is 26 days earlier than it. Using addition / subtraction.
- Put the current time in cell A5. In cell A6, give me the time which is 8 hours and 14 minutes, 32 seconds later. Using addition / subtraction, division.
- Using the Date function and other functions, give me the date which is 1 year, 5 months, 8 days from today.
Using the Time function and other functions, give me the time which is 16 hours, 14 minutes, and 32 seconds from now. - Using functions cleverly. Using date functions, determine whether the present year (using the TODAY function) is a leap year. As a hint: In a leap year, February has one extra day in it.
Counting, summing techniques
- Make a range of numbers.
In subsequent rows, we would have 17; 45; 68; 69; 12; 21; 32
Give me the count of all numbers which are between 12 and 46, inclusive. Use CountIfs. For an additional 10 points, do it using an array formula as well. - Next to those numbers, we have:
“Josh”; “Paul”; “Peter”; “Mary”; “Sally”; “Betty”; “Veronica”
Give me the sum of all scores where the person’s first name contains 4 letters. - Use the Frequency function to separate a bunch of numbers into bins. 47; 55; 28; 39; 30; 20; 31; Of size 10 each.
Lookup Functions
- Perform a two-way lookup, looking up Item type by Salesperson. You might want to use match and index for this.
Financial functions
1)
2) Know how to use CUMPRINC and CUMIPMT.
For an additional 10 points, also give me the same calculations using array formulas.
Ch 18, PivotTabes
1)
Order Date,Salesperson,Order Amount,Category,Sale Item1/1/2005,Dixon,1856.16,Dresses,No
1/2/2005,Hernandez,920.44,Blouses,Yes
1/2/2005,Lugo,532.03,Accessories,Yes
1/3/2005,Paredes,3316.74,Dresses,No
1/5/2005,Lugo,2058.95,Dresses,Yes
1/5/2005,Lugo,593.1,Skirts and Pants,No
1/5/2005,Paredes,1899.54,Dresses,No
1/5/2005,Hernandez,568.46,Skirts and Pants,Yes
1/6/2005,Dixon,1559.58,Dresses,No
1/7/2005,Lugo,237.86,Blouses,Yes
1/8/2005,Hernandez,256.25,Skirts and Pants,No
1/8/2005,Lugo,1167.31,Skirts and Pants,Yes
1/8/2005,Lugo,326.48,Blouses,Yes
1/9/2005,Dixon,1109.53,Sweaters,No
1/9/2005,Paredes,835.85,Skirts and Pants,No
1/9/2005,Paredes,1809.46,Dresses,Yes
1/9/2005,Paredes,1062.66,Blouses,Yes
1/10/2005,Lugo,3391.94,Dresses,Yes
1/10/2005,Paredes,978.55,Dresses,No
1/12/2005,Hernandez,2154.15,Dresses,No
1/13/2005,Hernandez,891.65,Dresses,Yes
1/13/2005,Lugo,1441.66,Blouses,No
1/13/2005,Hernandez,1288.7,Sweaters,Yes
1/14/2005,Dixon,100.95,Accessories,No
1/14/2005,Lugo,2037.14,Dresses,No
1/14/2005,Paredes,1356.34,Sweaters,No
1/14/2005,Dixon,2241.9,Dresses,Yes
1/14/2005,Dixon,1701.11,Blouses,Yes
1/14/2005,Hernandez,438.65,Blouses,No
1/15/2005,Lugo,447.25,Blouses,Yes
1/16/2005,Dixon,703.95,Blouses,Yes
1/16/2005,Hernandez,308.78,Blouses,No
1/16/2005,Lugo,1716.8,Dresses,Yes
1/16/2005,Paredes,986.13,Dresses,Yes
1/16/2005,Lugo,67.84,Lingerie,No
1/19/2005,Dixon,618.5,Skirts and Pants,No
1/19/2005,Paredes,1901.48,Dresses,Yes
1/19/2005,Paredes,997.68,Sweaters,Yes
1/21/2005,Dixon,25.25,Lingerie,No
1/21/2005,Lugo,1493.88,Dresses,Yes
1/21/2005,Lugo,1242.75,Sweaters,No
1/21/2005,Lugo,316.63,Blouses,No
1/21/2005,Paredes,93.75,Lingerie,No
1/22/2005,Paredes,519.45,Sweaters,No
1/22/2005,Paredes,1084.71,Skirts and Pants,Yes
1/23/2005,Hernandez,1469.59,Sweaters,No
1/23/2005,Hernandez,118.75,Lingerie,No
1/23/2005,Lugo,2239.44,Sweaters,Yes
1/23/2005,Lugo,1370.5,Sweaters,No
1/23/2005,Paredes,3469.24,Dresses,No
1/23/2005,Lugo,63.08,Lingerie,Yes
1/24/2005,Lugo,148.89,Skirts and Pants,No
1/24/2005,Hernandez,148.89,Skirts and Pants,No
1/26/2005,Hernandez,206.43,Blouses,Yes
1/26/2005,Hernandez,206.43,Blouses,No
1/26/2005,Lugo,938.19,Skirts and Pants,Yes
1/27/2005,Lugo,1616.56,Blouses,No
1/27/2005,Dixon,2212.39,Dresses,No
1/28/2005,Dixon,1565.85,Dresses,Yes
1/29/2005,Lugo,1200.64,Blouses,Yes
1/29/2005,Lugo,1437.38,Dresses,No
1/29/2005,Paredes,1284.86,Sweaters,No
1/30/2005,Dixon,959.24,Dresses,No
1/30/2005,Hernandez,1604.56,Blouses,No
1/30/2005,Hernandez,55.5,Accessories,No
1/30/2005,Lugo,1283.43,Sweaters,Yes
1/30/2005,Lugo,949.9,Sweaters,Yes
1/30/2005,Lugo,333.25,Blouses,No
1/30/2005,Paredes,873.33,Blouses,No
1/30/2005,Paredes,2741.64,Dresses,No
1/31/2005,Hernandez,74.79,Accessories,Yes
2/2/2005,Lugo,816.94,Blouses,No
2/2/2005,Paredes,1426.23,Sweaters,No
2/3/2005,Lugo,863.71,Skirts and Pants,No
2/3/2005,Lugo,1234.36,Dresses,No
2/4/2005,Dixon,2129.85,Dresses,No
2/4/2005,Lugo,1224.11,Sweaters,No
2/4/2005,Lugo,357.31,Accessories,No
2/4/2005,Paredes,2856.23,Dresses,No
2/4/2005,Lugo,681.34,Blouses,Yes
2/6/2005,Hernandez,938.14,Blouses,Yes
2/6/2005,Hernandez,462.48,Accessories,Yes
2/6/2005,Lugo,258.99,Lingerie,No
2/6/2005,Paredes,138.4,Lingerie,No
2/7/2005,Lugo,881.86,Blouses,Yes
2/7/2005,Paredes,677.19,Blouses,No
2/7/2005,Paredes,1910.46,Dresses,Yes
2/9/2005,Hernandez,264.01,Lingerie,Yes
2/9/2005,Lugo,492.51,Sweaters,No
2/9/2005,Paredes,477.15,Sweaters,No
2/10/2005,Dixon,1237.3,Dresses,No
2/10/2005,Hernandez,1370.93,Sweaters,Yes
2/10/2005,Lugo,31.99,Lingerie,No
2/11/2005,Hernandez,454.96,Accessories,No
2/11/2005,Hernandez,142.51,Skirts and Pants,No
2/11/2005,Paredes,142.51,Skirts and Pants,Yes
2/11/2005,Lugo,252.34,Lingerie,Yes
2/12/2005,Hernandez,1438.74,Sweaters,No
2/12/2005,Lugo,1246.16,Sweaters,No
2/12/2005,Lugo,527.64,Sweaters,No
2/13/2005,Hernandez,219.35,Blouses,No
2/13/2005,Hernandez,1843.13,Dresses,Yes
2/13/2005,Hernandez,453.9,Blouses,No
2/13/2005,Dixon,219.35,Blouses,Yes
2/14/2005,Dixon,622.08,Skirts and Pants,Yes
2/16/2005,Lugo,174.75,Blouses,Yes
2/16/2005,Hernandez,174.75,Blouses,Yes
2/17/2005,Dixon,560.31,Skirts and Pants,No
2/18/2005,Hernandez,1618.35,Sweaters,Yes
2/18/2005,Lugo,1167.75,Skirts and Pants,Yes
2/18/2005,Lugo,258.79,Blouses,No
2/18/2005,Lugo,1989.03,Dresses,No
2/19/2005,Dixon,26.23,Lingerie,Yes
2/19/2005,Hernandez,354.41,Blouses,Yes
2/19/2005,Lugo,554.94,Accessories,No
2/20/2005,Dixon,1132.8,Skirts and Pants,No
2/20/2005,Lugo,139.53,Skirts and Pants,Yes
2/20/2005,Lugo,139.53,Skirts and Pants,No
2/20/2005,Paredes,3471.83,Dresses,No
2/20/2005,Paredes,1391.2,Dresses,Yes
2/21/2005,Paredes,1387.35,Dresses,No
2/23/2005,Lugo,1725.06,Sweaters,Yes
2/24/2005,Dixon,674.98,Blouses,No
2/25/2005,Dixon,529.88,Accessories,No
2/25/2005,Paredes,1126.41,Dresses,Yes
2/26/2005,Hernandez,254.16,Blouses,No
2/26/2005,Lugo,65.28,Lingerie,No
2/26/2005,Paredes,534.24,Sweaters,No
2/27/2005,Hernandez,257.98,Blouses,Yes
2/27/2005,Lugo,1026,Sweaters,No
2/28/2005,Dixon,1238.8,Dresses,No
2/28/2005,Hernandez,783.91,Blouses,Yes
3/2/2005,Dixon,761.1,Accessories,No
3/2/2005,Hernandez,787.79,Skirts and Pants,Yes
3/2/2005,Paredes,980.24,Dresses,Yes
3/3/2005,Dixon,909.85,Blouses,Yes
3/3/2005,Hernandez,3400.49,Dresses,No
3/3/2005,Hernandez,297.74,Blouses,Yes
3/3/2005,Hernandez,537.05,Skirts and Pants,No
3/3/2005,Paredes,1101.63,Skirts and Pants,Yes
3/3/2005,Lugo,1998.6,Dresses,Yes
3/4/2005,Dixon,164.23,Lingerie,Yes
3/4/2005,Hernandez,1512.05,Sweaters,No
3/4/2005,Lugo,978.76,Dresses,Yes
3/4/2005,Paredes,606.71,Skirts and Pants,Yes
3/4/2005,Paredes,60.3,Accessories,Yes
3/4/2005,Hernandez,1285.68,Sweaters,No
3/4/2005,Dixon,1151,Skirts and Pants,Yes
3/5/2005,Dixon,1191.01,Skirts and Pants,No
3/6/2005,Dixon,874.26,Blouses,No
3/6/2005,Hernandez,177.14,Lingerie,Yes
3/6/2005,Lugo,474.98,Blouses,Yes
3/6/2005,Hernandez,69.38,Accessories,No
3/7/2005,Dixon,1265.78,Sweaters,No
3/9/2005,Dixon,600.1,Accessories,No
3/9/2005,Paredes,2483.69,Sweaters,Yes
3/10/2005,Paredes,855.4,Skirts and Pants,Yes
3/11/2005,Dixon,740.44,Blouses,No
3/11/2005,Dixon,563.6,Blouses,No
3/11/2005,Hernandez,547.01,Skirts and Pants,Yes
3/11/2005,Hernandez,379.44,Accessories,No
3/11/2005,Lugo,1834.18,Dresses,No
3/12/2005,Dixon,965.38,Dresses,No
3/12/2005,Hernandez,1592.4,Dresses,Yes
3/13/2005,Hernandez,1334.8,Sweaters,Yes
3/13/2005,Hernandez,824.09,Blouses,Yes
3/13/2005,Lugo,809.16,Blouses,No
3/13/2005,Lugo,170.68,Lingerie,No
3/13/2005,Lugo,315.54,Accessories,Yes
3/14/2005,Dixon,2115.45,Dresses,Yes
3/14/2005,Paredes,3235.49,Dresses,Yes
3/14/2005,Paredes,1300,Sweaters,No
3/16/2005,Hernandez,1204.96,Sweaters,Yes
3/16/2005,Paredes,869.18,Dresses,No
3/17/2005,Paredes,1401.13,Dresses,No
3/18/2005,Dixon,2823.93,Dresses,Yes
3/18/2005,Dixon,887.48,Skirts and Pants,No
3/18/2005,Dixon,273.83,Accessories,No
3/18/2005,Hernandez,1674.21,Sweaters,No
3/18/2005,Hernandez,1557.9,Dresses,No
3/18/2005,Lugo,721.66,Blouses,No
3/18/2005,Paredes,275.5,Lingerie,Yes
3/18/2005,Paredes,368.54,Accessories,No
3/18/2005,Lugo,620.53,Skirts and Pants,No
3/19/2005,Dixon,835.15,Sweaters,No
3/19/2005,Dixon,694.53,Accessories,No
3/19/2005,Hernandez,1062.11,Sweaters,Yes
3/19/2005,Hernandez,754.84,Blouses,No
3/20/2005,Hernandez,663.73,Accessories,Yes
3/20/2005,Hernandez,73.63,Accessories,Yes
3/20/2005,Lugo,776.8,Dresses,No
3/21/2005,Hernandez,1209.92,Dresses,No
3/21/2005,Paredes,256.42,Blouses,No
3/23/2005,Hernandez,865.65,Sweaters,Yes
3/23/2005,Hernandez,391.51,Blouses,Yes
3/23/2005,Hernandez,203.74,Accessories,No
3/23/2005,Paredes,178.96,Blouses,No
3/23/2005,Paredes,178.96,Blouses,No
3/24/2005,Hernandez,764.92,Sweaters,No
3/24/2005,Hernandez,198.17,Blouses,Yes
3/24/2005,Paredes,487.89,Blouses,Yes
3/24/2005,Dixon,19.71,Lingerie,No
3/25/2005,Hernandez,1425.52,Dresses,No
3/25/2005,Hernandez,545.62,Blouses,Yes
3/25/2005,Lugo,1066.51,Sweaters,No
3/26/2005,Hernandez,500.06,Blouses,No
3/26/2005,Hernandez,323.73,Accessories,No
3/26/2005,Lugo,65.04,Accessories,No
3/27/2005,Hernandez,330.51,Accessories,No
3/27/2005,Lugo,802.28,Sweaters,Yes
3/27/2005,Paredes,743.69,Sweaters,No
3/28/2005,Hernandez,923.15,Skirts and Pants,No
3/30/2005,Hernandez,1123.46,Dresses,Yes
3/30/2005,Hernandez,882.27,Sweaters,No
3/30/2005,Paredes,184.78,Blouses,No
3/31/2005,Dixon,1551.52,Dresses,No
3/31/2005,Hernandez,925.38,Dresses,No
4/1/2005,Paredes,1397.36,Dresses,Yes
4/1/2005,Dixon,433.94,Skirts and Pants,No
4/2/2005,Hernandez,1331.43,Dresses,No
4/2/2005,Paredes,1755.57,Sweaters,No
4/2/2005,Paredes,1259.16,Dresses,Yes
4/2/2005,Hernandez,50.28,Lingerie,No
4/3/2005,Lugo,759.7,Sweaters,No
4/3/2005,Paredes,903.33,Sweaters,No
4/3/2005,Paredes,128.18,Blouses,Yes
4/3/2005,Paredes,128.18,Blouses,Yes
4/3/2005,Lugo,502.26,Skirts and Pants,Yes
4/4/2005,Lugo,1476.58,Dresses,Yes
4/6/2005,Hernandez,677.13,Sweaters,Yes
4/6/2005,Paredes,1155.49,Blouses,Yes
4/7/2005,Hernandez,821.85,Dresses,No
4/7/2005,Lugo,1363.62,Sweaters,No
4/7/2005,Lugo,515.95,Blouses,Yes
4/7/2005,Lugo,199.36,Lingerie,Yes
4/7/2005,Paredes,2181.6,Dresses,No
4/8/2005,Dixon,1049.36,Sweaters,No
4/8/2005,Dixon,823.39,Skirts and Pants,No
4/8/2005,Hernandez,1027.29,Sweaters,Yes
4/8/2005,Hernandez,265.02,Accessories,No
4/8/2005,Paredes,272.68,Blouses,No
4/9/2005,Dixon,944.72,Sweaters,No
4/9/2005,Hernandez,961.39,Blouses,Yes
4/9/2005,Hernandez,492.72,Accessories,Yes
4/10/2005,Dixon,636.04,Accessories,No
4/10/2005,Dixon,570.58,Blouses,Yes
4/10/2005,Hernandez,1150.41,Dresses,No
4/10/2005,Hernandez,729.75,Blouses,No
4/10/2005,Lugo,931.06,Dresses,Yes
4/10/2005,Paredes,207.36,Blouses,Yes
4/10/2005,Paredes,853.89,Sweaters,Yes
4/10/2005,Lugo,387.14,Sweaters,Yes
4/11/2005,Hernandez,548.35,Blouses,No
4/11/2005,Hernandez,817.43,Skirts and Pants,No
4/13/2005,Hernandez,2582.14,Dresses,No
4/13/2005,Hernandez,1865.33,Blouses,No
4/13/2005,Lugo,530.29,Blouses,Yes
4/13/2005,Dixon,899.32,Dresses,No
4/14/2005,Hernandez,922.25,Skirts and Pants,No
4/14/2005,Dixon,744.36,Blouses,No
4/14/2005,Hernandez,672.65,Sweaters,No
4/15/2005,Lugo,399.08,Accessories,No
4/15/2005,Paredes,313.98,Accessories,No
4/16/2005,Dixon,1371.04,Sweaters,Yes
4/16/2005,Hernandez,25.02,Lingerie,Yes
4/16/2005,Lugo,142.94,Blouses,No
4/16/2005,Lugo,142.94,Blouses,No
4/16/2005,Paredes,616.98,Accessories,Yes
4/17/2005,Hernandez,681.03,Blouses,No
4/17/2005,Hernandez,559.77,Accessories,Yes
4/17/2005,Paredes,681.13,Dresses,No
4/17/2005,Paredes,305.96,Skirts and Pants,No
4/18/2005,Dixon,1354.13,Dresses,No
4/20/2005,Dixon,613.24,Accessories,No
4/20/2005,Dixon,23.87,Lingerie,Yes
4/20/2005,Lugo,1298.99,Dresses,No
4/20/2005,Lugo,360.17,Accessories,No
4/21/2005,Dixon,817.91,Blouses,No
4/21/2005,Hernandez,2140.44,Dresses,No
4/21/2005,Hernandez,1213.59,Dresses,Yes
4/21/2005,Dixon,644.31,Accessories,Yes
4/22/2005,Hernandez,2100.39,Dresses,Yes
4/22/2005,Lugo,115,Lingerie,Yes
4/23/2005,Hernandez,1696.76,Blouses,No
4/23/2005,Lugo,1243.12,Dresses,No
4/23/2005,Lugo,784.86,Dresses,No
4/24/2005,Hernandez,1447.35,Dresses,No
4/24/2005,Hernandez,783.96,Blouses,Yes
4/24/2005,Hernandez,325.3,Blouses,Yes
4/24/2005,Lugo,501.13,Skirts and Pants,No
4/24/2005,Lugo,254.64,Accessories,Yes
4/25/2005,Lugo,714.16,Accessories,No
4/27/2005,Dixon,1271.8,Dresses,Yes
4/27/2005,Hernandez,587.85,Accessories,Yes
4/27/2005,Lugo,1608.15,Dresses,Yes
4/27/2005,Lugo,111.32,Skirts and Pants,No
4/27/2005,Dixon,111.32,Skirts and Pants,No
4/28/2005,Dixon,1049.54,Sweaters,No
4/28/2005,Hernandez,1133.16,Sweaters,No
4/28/2005,Lugo,189.94,Lingerie,Yes
4/29/2005,Dixon,207.3,Lingerie,Yes
4/29/2005,Hernandez,726.1,Dresses,Yes
4/29/2005,Hernandez,218.73,Accessories,No
4/29/2005,Hernandez,393.6,Accessories,Yes
4/30/2005,Lugo,562.88,Blouses,No
5/1/2005,Dixon,588.6,Blouses,No
5/1/2005,Dixon,410.38,Skirts and Pants,No
5/1/2005,Hernandez,756.09,Blouses,No
5/1/2005,Hernandez,740.06,Blouses,Yes
5/1/2005,Hernandez,711.97,Dresses,Yes
5/1/2005,Lugo,278.74,Blouses,No
5/1/2005,Lugo,1347.29,Dresses,No
5/1/2005,Paredes,44.78,Accessories,No
5/2/2005,Hernandez,232.06,Accessories,No
5/2/2005,Lugo,398.15,Skirts and Pants,Yes
5/5/2005,Dixon,795.74,Dresses,No
5/6/2005,Dixon,761.8,Blouses,Yes
5/6/2005,Paredes,705.06,Dresses,Yes
5/7/2005,Lugo,1497.04,Dresses,Yes
5/7/2005,Paredes,761.77,Dresses,No
5/9/2005,Hernandez,423.05,Blouses,Yes
5/12/2005,Lugo,811.4,Dresses,No
5/13/2005,Paredes,285.57,Accessories,No
5/14/2005,Hernandez,471.7,Accessories,No
5/15/2005,Dixon,1108.61,Sweaters,Yes
5/16/2005,Lugo,204.99,Accessories,No
5/19/2005,Hernandez,150.03,Blouses,Yes
5/19/2005,Lugo,150.03,Blouses,No
5/21/2005,Dixon,1882.59,Blouses,No
5/21/2005,Hernandez,180.74,Blouses,Yes
5/21/2005,Dixon,180.74,Blouses,No
5/22/2005,Hernandez,729.35,Blouses,No
5/23/2005,Hernandez,381.53,Skirts and Pants,No
5/23/2005,Hernandez,145.87,Skirts and Pants,No
5/23/2005,Hernandez,47.39,Lingerie,No
5/23/2005,Paredes,806.55,Skirts and Pants,No
5/24/2005,Dixon,1222.03,Dresses,No
5/26/2005,Paredes,524.12,Blouses,No
5/27/2005,Paredes,689.45,Sweaters,No
5/29/2005,Hernandez,1881.54,Dresses,No
5/30/2005,Dixon,427.67,Accessories,No
5/30/2005,Hernandez,853.52,Dresses,No
5/30/2005,Lugo,802.43,Blouses,No
6/2/2005,Lugo,1704.62,Blouses,No
6/3/2005,Hernandez,1505.71,Dresses,No
6/4/2005,Hernandez,704.24,Dresses,No
6/5/2005,Dixon,1707.3,Blouses,No
6/5/2005,Hernandez,929.25,Sweaters,No
6/6/2005,Lugo,1132,Sweaters,No
6/6/2005,Paredes,147.25,Skirts and Pants,No
6/9/2005,Hernandez,1105.64,Sweaters,Yes
6/9/2005,Hernandez,678.87,Sweaters,No
6/10/2005,Paredes,2070.88,Dresses,No
6/10/2005,Paredes,543.8,Blouses,No
6/11/2005,Lugo,490.68,Accessories,No
6/12/2005,Paredes,525.79,Skirts and Pants,No
6/13/2005,Hernandez,858.27,Sweaters,No
6/13/2005,Hernandez,548.85,Skirts and Pants,No
6/13/2005,Hernandez,19.43,Lingerie,No
6/14/2005,Dixon,238.02,Skirts and Pants,No
6/16/2005,Dixon,1191.99,Sweaters,No
6/17/2005,Paredes,804.37,Blouses,Yes
6/18/2005,Hernandez,652.75,Blouses,Yes
6/18/2005,Lugo,1710.1,Sweaters,Yes
6/19/2005,Dixon,1468.11,Sweaters,No
6/19/2005,Hernandez,782.74,Blouses,No
6/20/2005,Lugo,20.06,Lingerie,Yes
6/24/2005,Hernandez,976.03,Sweaters,No
6/25/2005,Lugo,1454.81,Dresses,Yes
6/26/2005,Hernandez,289.51,Blouses,No
6/30/2005,Dixon,803.25,Skirts and Pants,No
6/30/2005,Hernandez,2064.76,Dresses,Yes
6/30/2005,Lugo,624.19,Skirts and Pants,No
6/30/2005,Paredes,813.82,Sweaters,Yes
7/1/2005,Dixon,1010.05,Sweaters,No
7/1/2005,Dixon,704.39,Sweaters,No
7/1/2005,Hernandez,338.87,Skirts and Pants,No
7/2/2005,Hernandez,2063.78,Dresses,Yes
7/2/2005,Paredes,449.52,Accessories,Yes
7/4/2005,Dixon,579.45,Blouses,No
7/4/2005,Dixon,566.01,Skirts and Pants,Yes
7/4/2005,Dixon,467.26,Skirts and Pants,Yes
7/4/2005,Hernandez,738.89,Blouses,No
7/4/2005,Paredes,361.34,Blouses,Yes
7/6/2005,Hernandez,745.5,Blouses,No
7/6/2005,Hernandez,220.44,Accessories,No
7/7/2005,Paredes,363.13,Skirts and Pants,No
7/8/2005,Dixon,667.81,Dresses,Yes
7/9/2005,Lugo,54.94,Accessories,Yes
7/9/2005,Lugo,199.07,Accessories,No
7/10/2005,Lugo,221.01,Accessories,Yes
7/10/2005,Hernandez,758.37,Sweaters,Yes
7/10/2005,Dixon,319.77,Accessories,No
7/11/2005,Dixon,876.03,Dresses,No
7/11/2005,Hernandez,933,Sweaters,Yes
7/12/2005,Dixon,1491.91,Dresses,No
7/14/2005,Hernandez,1137.25,Sweaters,No
7/14/2005,Hernandez,86.38,Accessories,No
7/14/2005,Hernandez,86.38,Accessories,No
7/14/2005,Dixon,341.42,Accessories,Yes
7/14/2005,Hernandez,1059.49,Sweaters,Yes
7/15/2005,Lugo,792.61,Blouses,No
7/16/2005,Hernandez,486.49,Blouses,Yes
7/16/2005,Hernandez,245.45,Accessories,No
7/16/2005,Paredes,848.88,Skirts and Pants,Yes
7/16/2005,Lugo,1425,Dresses,Yes
7/16/2005,Paredes,541.62,Accessories,No
7/18/2005,Paredes,762.88,Blouses,No
7/19/2005,Dixon,2140.78,Dresses,No
7/20/2005,Lugo,162.49,Blouses,No
7/20/2005,Paredes,162.49,Blouses,No
7/21/2005,Dixon,464.18,Blouses,No
7/21/2005,Hernandez,519.91,Skirts and Pants,No
7/22/2005,Dixon,1151.91,Dresses,Yes
7/22/2005,Dixon,129.31,Blouses,No
7/22/2005,Lugo,749.24,Blouses,Yes
7/22/2005,Paredes,129.31,Blouses,No
7/23/2005,Hernandez,560.38,Blouses,Yes
7/23/2005,Paredes,1546.4,Dresses,Yes
7/25/2005,Dixon,649.04,Blouses,No
7/25/2005,Dixon,524.17,Blouses,Yes
7/25/2005,Hernandez,1236.7,Dresses,Yes
7/25/2005,Hernandez,120.35,Blouses,No
7/25/2005,Lugo,120.35,Blouses,No
7/27/2005,Hernandez,1705.15,Sweaters,No
7/29/2005,Dixon,1496.74,Dresses,Yes
7/29/2005,Paredes,781.39,Dresses,No
7/29/2005,Paredes,251.99,Accessories,No
7/30/2005,Dixon,483.38,Accessories,No
7/30/2005,Lugo,420.23,Skirts and Pants,No
7/31/2005,Dixon,1120.11,Dresses,Yes
7/31/2005,Dixon,422.98,Accessories,Yes
8/1/2005,Dixon,1019.17,Blouses,No
8/1/2005,Dixon,517.89,Blouses,No
8/1/2005,Dixon,410.82,Skirts and Pants,No
8/1/2005,Hernandez,2500.28,Dresses,No
8/1/2005,Lugo,818.74,Sweaters,Yes
8/1/2005,Paredes,1223.51,Dresses,No
8/2/2005,Paredes,1367.38,Dresses,No
8/4/2005,Dixon,1379.25,Blouses,No
8/5/2005,Paredes,1146.18,Dresses,Yes
8/6/2005,Dixon,845.57,Dresses,No
8/6/2005,Dixon,154.74,Blouses,No
8/6/2005,Hernandez,154.74,Blouses,No
8/6/2005,Paredes,362.01,Accessories,Yes
8/7/2005,Dixon,1215.29,Skirts and Pants,Yes
8/8/2005,Dixon,1473.64,Dresses,No
8/8/2005,Paredes,661,Sweaters,No
8/9/2005,Hernandez,618.51,Blouses,No
8/9/2005,Paredes,278.61,Accessories,Yes
8/11/2005,Dixon,612.04,Skirts and Pants,No
8/11/2005,Dixon,443.66,Dresses,Yes
8/11/2005,Dixon,119.9,Lingerie,No
8/12/2005,Dixon,1331.75,Dresses,No
8/12/2005,Dixon,1161.58,Sweaters,No
8/12/2005,Hernandez,1188.68,Dresses,No
8/12/2005,Hernandez,50.09,Lingerie,Yes
8/13/2005,Dixon,547.4,Skirts and Pants,No
8/13/2005,Hernandez,1227.12,Dresses,No
8/13/2005,Hernandez,345.72,Blouses,Yes
8/13/2005,Lugo,48.43,Lingerie,Yes
8/14/2005,Dixon,412.11,Accessories,Yes
8/14/2005,Lugo,1641.19,Dresses,No
8/14/2005,Paredes,485.95,Skirts and Pants,Yes
8/14/2005,Paredes,115.66,Skirts and Pants,Yes
8/14/2005,Lugo,115.66,Skirts and Pants,Yes
8/15/2005,Hernandez,288.19,Blouses,Yes
8/15/2005,Lugo,90.89,Accessories,Yes
8/15/2005,Hernandez,90.89,Accessories,Yes
8/16/2005,Dixon,1430.23,Dresses,No
8/16/2005,Dixon,850.73,Sweaters,No
8/16/2005,Hernandez,518.89,Blouses,No
8/16/2005,Paredes,382.6,Accessories,No
8/18/2005,Lugo,1053.28,Dresses,No
8/18/2005,Paredes,24.16,Lingerie,Yes
8/19/2005,Dixon,577.76,Skirts and Pants,No
8/20/2005,Dixon,2638.84,Dresses,Yes
8/20/2005,Dixon,495.86,Skirts and Pants,No
8/21/2005,Dixon,1284.36,Dresses,No
8/21/2005,Dixon,1172.72,Dresses,No
8/21/2005,Dixon,961.75,Dresses,No
8/21/2005,Dixon,156.03,Blouses,Yes
8/21/2005,Hernandez,117.91,Skirts and Pants,No
8/21/2005,Dixon,156.03,Blouses,Yes
8/21/2005,Dixon,117.91,Skirts and Pants,No
8/22/2005,Paredes,646.85,Blouses,No
8/23/2005,Hernandez,1406.08,Sweaters,No
8/26/2005,Dixon,601.32,Blouses,No
8/26/2005,Dixon,25.29,Lingerie,Yes
8/26/2005,Hernandez,2632.74,Dresses,No
8/27/2005,Dixon,1145.8,Blouses,Yes
8/27/2005,Lugo,494.39,Blouses,No
8/28/2005,Dixon,110.09,Lingerie,Yes
8/28/2005,Lugo,486.89,Skirts and Pants,No
8/29/2005,Hernandez,1364.55,Dresses,Yes
8/30/2005,Dixon,717.19,Dresses,No
8/30/2005,Hernandez,100.64,Skirts and Pants,Yes
8/30/2005,Hernandez,100.64,Skirts and Pants,No
8/31/2005,Lugo,248.31,Blouses,No
9/1/2005,Paredes,949.99,Skirts and Pants,No
9/2/2005,Dixon,1524.09,Dresses,Yes
9/2/2005,Hernandez,100.27,Lingerie,No
9/2/2005,Lugo,1239.03,Sweaters,No
9/3/2005,Dixon,2093.08,Dresses,No
9/3/2005,Dixon,683.87,Skirts and Pants,Yes
9/3/2005,Dixon,168.17,Blouses,Yes
9/3/2005,Hernandez,1716.91,Dresses,No
9/3/2005,Paredes,168.17,Blouses,No
9/4/2005,Hernandez,515.45,Accessories,No
9/5/2005,Dixon,1874.71,Sweaters,Yes
9/5/2005,Lugo,671.73,Blouses,No
9/8/2005,Dixon,1070.19,Dresses,Yes
9/8/2005,Hernandez,349.1,Blouses,No
9/9/2005,Hernandez,428.55,Skirts and Pants,Yes
9/10/2005,Hernandez,649.87,Blouses,No
9/10/2005,Lugo,1249.33,Dresses,No
9/10/2005,Lugo,206.05,Accessories,No
9/10/2005,Paredes,1388.88,Sweaters,No
9/11/2005,Hernandez,2552.98,Dresses,No
9/11/2005,Hernandez,1065.37,Skirts and Pants,No
9/11/2005,Hernandez,575.59,Blouses,Yes
9/11/2005,Paredes,858.52,Skirts and Pants,Yes
9/11/2005,Paredes,472.7,Skirts and Pants,Yes
9/11/2005,Paredes,211.61,Skirts and Pants,No
9/12/2005,Lugo,621.34,Blouses,No
9/13/2005,Paredes,379.2,Accessories,Yes
9/15/2005,Dixon,1047.31,Dresses,Yes
9/17/2005,Paredes,1319.26,Blouses,No
9/17/2005,Paredes,944.47,Dresses,Yes
9/18/2005,Dixon,754.15,Blouses,No
9/18/2005,Dixon,1131.33,Sweaters,No
9/18/2005,Hernandez,643.25,Blouses,Yes
9/18/2005,Hernandez,185.08,Blouses,No
9/19/2005,Hernandez,484.47,Skirts and Pants,No
9/19/2005,Lugo,1545.95,Dresses,No
9/19/2005,Paredes,1273.93,Dresses,No
9/19/2005,Paredes,1115.98,Sweaters,No
9/22/2005,Dixon,558.78,Blouses,No
9/22/2005,Lugo,1130.44,Dresses,Yes
9/23/2005,Hernandez,1410.72,Dresses,No
9/23/2005,Paredes,544.92,Blouses,No
9/24/2005,Lugo,119.75,Blouses,No
9/24/2005,Paredes,881.16,Sweaters,No
9/24/2005,Dixon,119.75,Blouses,Yes
9/25/2005,Dixon,496.78,Blouses,No
9/26/2005,Lugo,742.04,Dresses,Yes
9/26/2005,Paredes,838.79,Skirts and Pants,No
9/26/2005,Paredes,341.09,Accessories,No
9/26/2005,Paredes,147.25,Skirts and Pants,No
9/27/2005,Paredes,410.23,Sweaters,No
9/29/2005,Hernandez,554.71,Blouses,No
9/30/2005,Hernandez,136.62,Blouses,Yes
9/30/2005,Paredes,689.02,Accessories,No
9/30/2005,Hernandez,1224.19,Dresses,Yes
9/30/2005,Lugo,329.51,Blouses,No
9/30/2005,Paredes,136.62,Blouses,No
10/1/2005,Lugo,61.7,Accessories,No
10/1/2005,Paredes,397.7,Skirts and Pants,Yes
10/3/2005,Dixon,494.15,Blouses,No
10/3/2005,Dixon,23.62,Lingerie,No
10/3/2005,Hernandez,1620.22,Blouses,No
10/3/2005,Paredes,843.79,Skirts and Pants,No
10/4/2005,Paredes,254.13,Skirts and Pants,Yes
10/4/2005,Paredes,25.14,Lingerie,Yes
10/4/2005,Lugo,183.07,Blouses,No
10/7/2005,Dixon,768.71,Sweaters,Yes
10/7/2005,Paredes,498.02,Skirts and Pants,Yes
10/8/2005,Paredes,676.53,Dresses,Yes
10/8/2005,Hernandez,1378.1,Dresses,Yes
10/9/2005,Dixon,2595.19,Dresses,Yes
10/9/2005,Paredes,1148.52,Sweaters,No
10/9/2005,Paredes,728.55,Dresses,No
10/10/2005,Hernandez,286.78,Blouses,Yes
10/10/2005,Lugo,1014.87,Dresses,No
10/10/2005,Dixon,198.46,Lingerie,Yes
10/11/2005,Lugo,1133.71,Dresses,No
10/11/2005,Dixon,173.16,Blouses,No
10/11/2005,Hernandez,173.16,Blouses,No
10/13/2005,Hernandez,147.65,Blouses,No
10/13/2005,Lugo,697.08,Blouses,No
10/13/2005,Paredes,147.65,Blouses,No
10/14/2005,Dixon,178.17,Blouses,No
10/14/2005,Hernandez,178.17,Blouses,No
10/14/2005,Paredes,1454.84,Dresses,No
10/14/2005,Paredes,968.77,Sweaters,Yes
10/14/2005,Paredes,1019.68,Sweaters,Yes
10/14/2005,Paredes,509.14,Accessories,Yes
10/15/2005,Hernandez,697.29,Sweaters,No
10/15/2005,Paredes,1674.96,Dresses,No
10/15/2005,Lugo,549.47,Accessories,Yes
10/16/2005,Lugo,1005.93,Dresses,No
10/16/2005,Hernandez,1649.23,Dresses,Yes
10/17/2005,Dixon,1135.62,Skirts and Pants,No
10/17/2005,Dixon,817.72,Dresses,No
10/18/2005,Hernandez,545.96,Blouses,Yes
10/20/2005,Hernandez,2510.51,Dresses,No
10/21/2005,Lugo,174.87,Blouses,Yes
10/21/2005,Lugo,174.87,Blouses,Yes
10/21/2005,Dixon,339.07,Accessories,Yes
10/22/2005,Dixon,1181.71,Dresses,No
10/23/2005,Dixon,1634.97,Dresses,No
10/23/2005,Dixon,1092.71,Sweaters,Yes
10/23/2005,Lugo,141.56,Blouses,No
10/23/2005,Paredes,106.44,Skirts and Pants,No
10/23/2005,Paredes,106.44,Skirts and Pants,Yes
10/23/2005,Dixon,141.56,Blouses,No
10/24/2005,Lugo,24.79,Lingerie,No
10/24/2005,Paredes,693.8,Dresses,Yes
10/25/2005,Hernandez,80.75,Lingerie,Yes
10/25/2005,Lugo,358.63,Accessories,No
10/27/2005,Dixon,698.02,Blouses,Yes
10/27/2005,Hernandez,729.21,Blouses,Yes
10/28/2005,Paredes,143.45,Blouses,Yes
10/28/2005,Hernandez,1644.81,Dresses,Yes
10/28/2005,Lugo,143.45,Blouses,No
10/29/2005,Dixon,927.67,Sweaters,Yes
10/29/2005,Dixon,804.66,Blouses,Yes
10/29/2005,Hernandez,1059.53,Sweaters,Yes
10/29/2005,Paredes,1298.85,Sweaters,No
10/29/2005,Paredes,831.68,Sweaters,No
10/29/2005,Paredes,1315.73,Dresses,No
10/30/2005,Lugo,1094.12,Dresses,No
10/31/2005,Paredes,1379.82,Dresses,Yes
11/4/2005,Paredes,1828.89,Dresses,No
11/4/2005,Lugo,946.25,Sweaters,Yes
11/5/2005,Dixon,848.85,Blouses,Yes
11/5/2005,Hernandez,253.28,Blouses,No
11/5/2005,Lugo,467.47,Skirts and Pants,No
11/5/2005,Lugo,364.56,Blouses,Yes
11/5/2005,Paredes,947.67,Skirts and Pants,No
11/5/2005,Paredes,609.81,Accessories,No
11/6/2005,Dixon,1782.92,Blouses,No
11/7/2005,Hernandez,471.93,Blouses,No
11/8/2005,Paredes,911.64,Blouses,No
11/8/2005,Dixon,1886.24,Dresses,No
11/10/2005,Paredes,1700.74,Dresses,No
11/11/2005,Dixon,1528.08,Sweaters,No
11/11/2005,Hernandez,811.97,Sweaters,No
11/12/2005,Hernandez,1712.04,Blouses,No
11/14/2005,Hernandez,560.31,Blouses,No
11/14/2005,Lugo,2186.66,Dresses,Yes
11/15/2005,Hernandez,163.93,Blouses,Yes
11/15/2005,Lugo,163.93,Blouses,Yes
11/15/2005,Paredes,405.24,Skirts and Pants,No
11/17/2005,Dixon,285.31,Accessories,Yes
11/18/2005,Dixon,264.2,Blouses,No
11/18/2005,Hernandez,231.86,Skirts and Pants,No
11/18/2005,Hernandez,89.96,Accessories,Yes
11/18/2005,Hernandez,89.96,Accessories,Yes
11/18/2005,Lugo,499.66,Skirts and Pants,No
11/18/2005,Hernandez,878.94,Dresses,No
11/18/2005,Lugo,236.98,Lingerie,No
11/20/2005,Hernandez,570.46,Skirts and Pants,Yes
11/20/2005,Paredes,1198.49,Dresses,No
11/20/2005,Paredes,954.02,Sweaters,Yes
11/20/2005,Paredes,651.71,Blouses,No
11/21/2005,Paredes,855.42,Blouses,No
11/21/2005,Paredes,412.89,Blouses,Yes
11/24/2005,Lugo,1782.01,Dresses,No
11/25/2005,Dixon,550.98,Skirts and Pants,No
11/25/2005,Lugo,1895.3,Dresses,Yes
11/25/2005,Paredes,526.94,Skirts and Pants,No
11/26/2005,Hernandez,957.36,Dresses,No
11/27/2005,Hernandez,1248.26,Blouses,Yes
11/27/2005,Hernandez,543.38,Skirts and Pants,Yes
11/27/2005,Hernandez,194.07,Blouses,Yes
11/27/2005,Hernandez,109,Accessories,No
11/27/2005,Hernandez,109,Accessories,No
11/27/2005,Lugo,1251.37,Sweaters,No
11/27/2005,Paredes,194.07,Blouses,No
11/28/2005,Dixon,22.09,Lingerie,Yes
11/28/2005,Hernandez,312.53,Blouses,Yes
11/28/2005,Lugo,2510.71,Dresses,Yes
11/28/2005,Hernandez,1776.36,Dresses,No
11/30/2005,Dixon,3036.21,Dresses,Yes
12/2/2005,Dixon,1639.96,Dresses,No
12/2/2005,Lugo,1010.45,Sweaters,No
12/2/2005,Paredes,1345.72,Sweaters,No
12/2/2005,Paredes,56.97,Lingerie,No
12/2/2005,Dixon,472.85,Accessories,Yes
12/3/2005,Paredes,23.39,Lingerie,Yes
12/3/2005,Hernandez,1868.16,Dresses,Yes
12/4/2005,Dixon,566.24,Skirts and Pants,Yes
12/4/2005,Paredes,1139.18,Dresses,No
12/5/2005,Dixon,821.23,Skirts and Pants,No
12/5/2005,Hernandez,1809.48,Dresses,Yes
12/8/2005,Hernandez,2515.15,Dresses,No
12/8/2005,Hernandez,566.57,Skirts and Pants,No
12/8/2005,Lugo,689.29,Blouses,No
12/9/2005,Dixon,878.24,Blouses,No
12/9/2005,Paredes,889.96,Blouses,Yes
12/9/2005,Paredes,568.25,Blouses,No
12/9/2005,Paredes,955.92,Dresses,No
12/9/2005,Paredes,453.72,Skirts and Pants,No
12/10/2005,Dixon,820.81,Sweaters,No
12/11/2005,Dixon,1538.1,Sweaters,Yes
12/12/2005,Dixon,1046.19,Skirts and Pants,No
12/12/2005,Lugo,1856.71,Dresses,No
12/12/2005,Hernandez,421.42,Accessories,No
12/13/2005,Hernandez,127.11,Lingerie,Yes
12/13/2005,Paredes,1013.75,Skirts and Pants,No
12/13/2005,Paredes,481.94,Accessories,No
12/13/2005,Dixon,208.09,Blouses,No
12/13/2005,Dixon,208.09,Blouses,Yes
12/15/2005,Hernandez,863.3,Sweaters,No
12/15/2005,Lugo,138.48,Skirts and Pants,No
12/15/2005,Hernandez,138.48,Blouses,Yes
12/16/2005,Dixon,811.24,Dresses,No
12/16/2005,Paredes,224.41,Lingerie,No
12/17/2005,Paredes,311.55,Accessories,No
12/18/2005,Paredes,1480.12,Dresses,No
12/19/2005,Dixon,1660.08,Blouses,No
12/19/2005,Dixon,1232.64,Sweaters,Yes
12/19/2005,Hernandez,1132.48,Sweaters,Yes
12/19/2005,Hernandez,154.76,Blouses,No
12/19/2005,Hernandez,154.76,Blouses,No
12/19/2005,Lugo,998.75,Dresses,Yes
12/20/2005,Hernandez,1412.03,Sweaters,No
12/20/2005,Paredes,842.86,Blouses,No
12/22/2005,Dixon,1665.05,Dresses,Yes
12/22/2005,Lugo,67.41,Accessories,No
12/23/2005,Paredes,1775.32,Dresses,Yes
12/23/2005,Paredes,762.6,Accessories,No
12/24/2005,Hernandez,174.91,Blouses,No
12/24/2005,Paredes,530.04,Blouses,No
12/24/2005,Paredes,148.05,Blouses,No
12/24/2005,Paredes,148.05,Blouses,No
12/24/2005,Paredes,174.91,Blouses,Yes
12/25/2005,Lugo,223.86,Blouses,No
12/26/2005,Hernandez,2888.04,Dresses,Yes
12/26/2005,Hernandez,838.44,Sweaters,Yes
12/26/2005,Hernandez,233.4,Lingerie,Yes
12/26/2005,Lugo,320.75,Skirts and Pants,Yes
12/27/2005,Hernandez,1254.44,Sweaters,No
12/29/2005,Lugo,1975.13,Dresses,No
12/30/2005,Paredes,174.7,Blouses,Yes
12/30/2005,Hernandez,174.7,Blouses,No
12/31/2005,Dixon,846.81,Sweaters,Yes
12/31/2005,Paredes,1015.97,Sweaters,Yes
12/31/2005,Paredes,536.68,Skirts and Pants,No
12/31/2005,Dixon,133.35,Skirts and Pants,No
12/31/2005,Dixon,133.35,Skirts and Pants,Yes
Make a PivotTable of Salesperson against Category, showing the amount.
For an additional 5 points, do the same, but show the count of amount, rather than the sum.
Subscribe to:
Posts (Atom)