excel assignment
llmurbayz
house.xlsxDocumentation
| Tea House | |
| Author | |
| Date | |
| Purpose | Analyzing orders from last year |
Orders
| Country | Order Month | Salesperson | Order Amount |
| Country | Order Month | Salesperson | Order Amount |
| Denmark | Jan | Peacock, Margaret | $3,923.75 |
| Denmark | Feb | Peacock, Margaret | $14,104.00 |
| Denmark | Jun | King, Robert | $244.30 |
| Denmark | Jul | Fuller, Andrew | $835.20 |
| Denmark | Sep | King, Robert | $870.00 |
| Denmark | Oct | Fuller, Andrew | $570.00 |
| Denmark | Nov | King, Robert | $515.00 |
| Denmark | Jan | Callahan, Laura | $2,207.00 |
| Denmark | Jan | Leverling, Janet | $1,704.00 |
| Denmark | Apr | Davolio, Nancy | $3,399.97 |
| Denmark | Apr | Davolio, Nancy | $1,936.00 |
| Denmark | Apr | Davolio, Nancy | $1,407.50 |
| Denmark | May | Fuller, Andrew | $990.00 |
| Denmark | Aug | Davolio, Nancy | $812.50 |
| Denmark | Aug | Callahan, Laura | $65.00 |
| Denmark | Nov | Peacock, Margaret | $3,490.00 |
| Denmark | Dec | King, Robert | $1,044.85 |
| Denmark | Dec | Suyama, Michael | $920.00 |
| Finland | Jan | Fuller, Andrew | $1,132.35 |
| Finland | Feb | Callahan, Laura | $902.00 |
| Finland | Feb | Callahan, Laura | $465.00 |
| Finland | Mar | Callahan, Laura | $3,357.50 |
| Finland | Mar | Callahan, Laura | $492.00 |
| Finland | May | Suyama, Michael | $300.00 |
| Finland | Jun | Fuller, Andrew | $1,546.30 |
| Finland | Jun | Peacock, Margaret | $1,344.00 |
| Finland | Jul | Fuller, Andrew | $2,413.90 |
| Finland | Aug | Leverling, Janet | $456.00 |
| Finland | Sep | Davolio, Nancy | $1,720.00 |
| Finland | Sep | Peacock, Margaret | $629.50 |
| Finland | Nov | Buchanan, Steven | $1,192.50 |
| Finland | Nov | Buchanan, Steven | $645.00 |
| Finland | Dec | Dodsworth, Anne | $1,871.25 |
| Finland | Mar | Leverling, Janet | $611.30 |
| Finland | Mar | Davolio, Nancy | $452.90 |
| Finland | Mar | Peacock, Margaret | $336.80 |
| Finland | May | Fuller, Andrew | $586.00 |
| Finland | Aug | Fuller, Andrew | $120.00 |
| Finland | Oct | Fuller, Andrew | $412.35 |
| Finland | Nov | King, Robert | $642.00 |
| France | Mar | Leverling, Janet | $2,763.50 |
| France | Mar | Leverling, Janet | $2,299.50 |
| France | Jul | Dodsworth, Anne | $2,040.00 |
| France | Aug | Fuller, Andrew | $1,470.00 |
| France | Oct | Buchanan, Steven | $1,776.00 |
| France | Dec | Peacock, Margaret | $9,244.25 |
| France | Feb | Davolio, Nancy | $843.00 |
| France | Mar | Dodsworth, Anne | $2,083.40 |
| France | Mar | King, Robert | $917.00 |
| France | Apr | Peacock, Margaret | $2,276.00 |
| France | Apr | Callahan, Laura | $1,925.50 |
| France | Apr | Callahan, Laura | $360.00 |
| France | May | Peacock, Margaret | $3,000.00 |
| France | Jun | Peacock, Margaret | $1,057.00 |
| France | Jun | Davolio, Nancy | $846.00 |
| France | Oct | Fuller, Andrew | $2,032.00 |
| France | Nov | Davolio, Nancy | $3,205.80 |
| France | Nov | Leverling, Janet | $1,296.00 |
| France | Dec | Peacock, Margaret | $2,598.00 |
| France | Dec | Leverling, Janet | $1,938.80 |
| France | Dec | Leverling, Janet | $360.00 |
| France | Mar | King, Robert | $860.10 |
| France | Oct | Davolio, Nancy | $336.00 |
| France | Jan | Davolio, Nancy | $3,687.00 |
| France | Feb | Callahan, Laura | $2,030.20 |
| France | Apr | Suyama, Michael | $945.00 |
| France | Sep | Peacock, Margaret | $4,985.50 |
| France | Apr | Fuller, Andrew | $1,733.06 |
| France | Oct | Davolio, Nancy | $920.10 |
| France | Jan | Fuller, Andrew | $2,760.80 |
| France | Feb | Leverling, Janet | $2,656.00 |
| France | Apr | King, Robert | $936.00 |
| France | May | Peacock, Margaret | $845.75 |
| France | Aug | Callahan, Laura | $399.00 |
| France | Dec | Suyama, Michael | $891.75 |
| France | Apr | Leverling, Janet | $2,052.50 |
| France | Feb | Leverling, Janet | $2,070.00 |
| France | Mar | Peacock, Margaret | $2,112.00 |
| France | Jun | Davolio, Nancy | $2,812.00 |
| France | Aug | Leverling, Janet | $839.50 |
| Norway | Jan | Davolio, Nancy | $1,323.60 |
| Norway | Feb | Leverling, Janet | $2,684.40 |
| Norway | Mar | Davolio, Nancy | $670.00 |
| Norway | May | Fuller, Andrew | $622.35 |
| Norway | May | King, Robert | $200.00 |
| Norway | Sep | King, Robert | $500.00 |
| Sweden | Jan | Leverling, Janet | $2,778.00 |
| Sweden | Jan | Leverling, Janet | $96.50 |
| Sweden | Feb | Callahan, Laura | $2,630.95 |
| Sweden | Feb | Dodsworth, Anne | $1,254.00 |
| Sweden | Mar | Leverling, Janet | $2,034.50 |
| Sweden | Mar | Buchanan, Steven | $1,461.60 |
| Sweden | Mar | Leverling, Janet | $1,291.95 |
| Sweden | Mar | Peacock, Margaret | $729.50 |
| Sweden | Mar | Leverling, Janet | $219.75 |
| Sweden | Jun | Davolio, Nancy | $3,192.65 |
| Sweden | Jul | Leverling, Janet | $1,565.65 |
| Sweden | Sep | Callahan, Laura | $1,862.40 |
| Sweden | Sep | Davolio, Nancy | $1,503.60 |
| Sweden | Sep | Fuller, Andrew | $766.50 |
| Sweden | Oct | Dodsworth, Anne | $4,210.50 |
| Sweden | Oct | Buchanan, Steven | $668.70 |
| Sweden | Nov | Davolio, Nancy | $630.00 |
| Sweden | Dec | Davolio, Nancy | $1,459.00 |
| Sweden | Jan | Leverling, Janet | $4,337.00 |
| Sweden | Jan | Callahan, Laura | $2,233.00 |
| Sweden | Jan | Peacock, Margaret | $875.00 |
| Sweden | Jan | Buchanan, Steven | $129.00 |
| Sweden | Feb | Callahan, Laura | $250.80 |
| Sweden | Mar | Fuller, Andrew | $2,769.00 |
| Sweden | Mar | King, Robert | $1,875.00 |
| Sweden | Mar | Davolio, Nancy | $1,015.80 |
| Sweden | Mar | Leverling, Janet | $450.00 |
| Sweden | Mar | Callahan, Laura | $293.50 |
| Sweden | Apr | Peacock, Margaret | $310.00 |
| Sweden | Apr | Callahan, Laura | $93.00 |
| Sweden | May | King, Robert | $6,527.25 |
| Sweden | May | Callahan, Laura | $900.00 |
| Sweden | Jun | Callahan, Laura | $2,295.20 |
| Sweden | Jul | Fuller, Andrew | $2,844.50 |
| Sweden | Aug | Suyama, Michael | $906.25 |
| Sweden | Nov | Fuller, Andrew | $2,828.65 |
| Sweden | Nov | Suyama, Michael | $2,545.00 |
| UK | Jan | Leverling, Janet | $1,477.00 |
| UK | Jan | Callahan, Laura | $1,123.75 |
| UK | Jan | Leverling, Janet | $191.10 |
| UK | Mar | Davolio, Nancy | $566.25 |
| UK | Mar | Peacock, Margaret | $282.00 |
| UK | Apr | Dodsworth, Anne | $4,675.00 |
| UK | Jul | Davolio, Nancy | $2,142.90 |
| UK | Nov | Peacock, Margaret | $1,704.00 |
| UK | Dec | Suyama, Michael | $600.00 |
| UK | Apr | Fuller, Andrew | $1,660.00 |
| UK | Apr | Peacock, Margaret | $711.00 |
| UK | Apr | Leverling, Janet | $220.00 |
| UK | May | Davolio, Nancy | $1,500.00 |
| UK | Jun | Dodsworth, Anne | $139.80 |
| UK | Aug | Suyama, Michael | $493.00 |
| UK | Sep | King, Robert | $599.25 |
| UK | Feb | King, Robert | $931.50 |
| UK | Mar | Callahan, Laura | $790.00 |
| UK | Apr | Fuller, Andrew | $195.00 |
| UK | Feb | Davolio, Nancy | $3,829.59 |
| UK | Apr | Callahan, Laura | $2,772.00 |
| UK | May | Callahan, Laura | $3,740.00 |
| UK | May | Peacock, Margaret | $1,966.81 |
| UK | May | King, Robert | $1,090.50 |
| UK | Jun | King, Robert | $796.35 |
| UK | Dec | Davolio, Nancy | $1,187.50 |
| UK | Dec | Peacock, Margaret | $655.00 |
| UK | Feb | Dodsworth, Anne | $1,764.00 |
| UK | Apr | Suyama, Michael | $920.60 |
| UK | Sep | Peacock, Margaret | $758.50 |
| UK | Oct | Peacock, Margaret | $646.00 |
| UK | Oct | Peacock, Margaret | $45.00 |
| UK | Nov | Leverling, Janet | $180.00 |
| UK | Dec | Peacock, Margaret | $1,080.00 |
| UK | May | Leverling, Janet | $45.00 |
| UK | Dec | Fuller, Andrew | $252.00 |
| UK | Jan | Suyama, Michael | $2,290.40 |
| UK | Jan | Davolio, Nancy | $1,632.15 |
| UK | Jan | Fuller, Andrew | $1,594.50 |
| UK | Jan | Davolio, Nancy | $1,272.00 |
| UK | Mar | Buchanan, Steven | $1,630.00 |
| UK | Apr | Callahan, Laura | $1,314.00 |
| UK | Jun | King, Robert | $2,715.90 |
| UK | Jun | Leverling, Janet | $1,908.00 |
| UK | Dec | Buchanan, Steven | $4,572.20 |
Summary
| Country | Order Month | |
| Average Order | Total Orders | |
| France | ||
| UK |
