Problem 1

Matrix multiplication table

12 13 14 15 16 17 18 19 20 ADDRESSING MODES
12 144 156 168 180 192 204 216 228 240 NOTE:
column fixed : $b5
13 156 169 182 195 208 221 234 247 260 row fixed : a$5
14 168 182 196 210 224 238 252 266 280 BOTH FIXED : $D$6
15 180 195 210 225 240 255 270 285 300
16 192 208 224 240 256 272 288 304 320 $ IS FOR FIXING PARTICULAR ROW OR COLUMN
17 204 221 238 255 272 289 306 323 340
18 216 234 252 270 288 306 324 342 360
19 228 247 266 285 304 323 342 361 380
20 240 260 280 300 320 340 360 380 400

Problem 2
Simple Interest calculation ((principal * Term * rate ) / 100)

Rate
Principal 5000 12 12.5 13 13.5 14 14.5 15 15.5
12 7200 7500
13 7800 8125
14 8400 8750
15 9000 9375
Term 16 9600 10000
17 10200 10625
18 10800 11250
19 11400 11875
20 12000 12500
UMN
 Example 1
Employees sheet

Last Name Basic Hra

Smith B ₹ 45,789.00 ₹ 4,578.90
Wilson C ₹ 41,245.00 ₹ 4,124.50
Thompson J ₹ 39,876.00 ₹ 3,987.60
Anthony Taylor ₹ 55,500.00 ₹ 5,550.00
Charles S. Billings ₹ 39,000.00 ₹ 3,900.00
Chris Poundsworth ₹ 29,850.00 ₹ 2,985.00
Clark Bickerson ₹ 120,000.00 ₹ 12,000.00
Douglas Williams ₹ 89,687.00 ₹ 8,968.70
Ivan Silberstein ₹ 95,000.00 ₹ 9,500.00
James Millen ₹ 27,690.00 ₹ 2,769.00
Jeffrey P. Jones ₹ 42,000.00 ₹ 4,200.00
Joe Morrison ₹ 24,000.00 ₹ 2,400.00
John T. Foster ₹ 39,500.00 ₹ 3,950.00
Kurt Kamichoff ₹ 48,000.00 ₹ 4,800.00
Michael Hayden ₹ 78,230.00 ₹ 7,823.00
Phillip A. Todd ₹ 29,500.00 ₹ 2,950.00
Richard E. Card ₹ 43,000.00 ₹ 4,300.00
Rick Fogerty ₹ 89,873.00 ₹ 8,987.30
Robert H. Miller ₹ 149,000.00 ₹ 14,900.00
Stephen C. Carter ₹ 44,123.00 ₹ 4,412.30
Steven H. Katz ₹ 32,900.00 ₹ 3,290.00
Thomas E. Abbott ₹ 60,000.00 ₹ 6,000.00
Tom Brown ₹ 65,000.00 ₹ 6,500.00
Total ### ₹ 132,876.30
Question A
Complete the above database with the following formula
1 Hra is 10% of Basic
2 DA will be 45% of Basic
3 Gross being sum of Basic, Hra, Da
4 Deduction is mention in the cell i4 and currently 6% of gross salary
5 Calculate Net salary where net salary will be gross salary - deduction
6 Fill the total column with the appropriate formulea

Question B
1 Format all numbers to include a currency symbol with two decimal points
Question C
Write formula to calculate the following in the shaded area
Average Gross Salary of all employees ₹ 89,547.07
Maximum Basic Salary ₹ 149,000.00
Minimum Basic Sal ₹ 24,000.00
Total No. of employees 23
ployees sheet
Date: 10/3/2007
Deduction Rate: 6%

DA Gross Salary Deduction Net salary

₹ 20,605.05 ₹ 70,972.95 ₹ 4,258.38 ₹ 66,714.57
₹ 18,560.25 ₹ 63,929.75 ₹ 3,835.79 ₹ 60,093.97
₹ 17,944.20 ₹ 61,807.80 ₹ 3,708.47 ₹ 58,099.33
₹ 24,975.00 ₹ 86,025.00 ₹ 5,161.50 ₹ 80,863.50
₹ 17,550.00 ₹ 60,450.00 ₹ 3,627.00 ₹ 56,823.00
₹ 13,432.50 ₹ 46,267.50 ₹ 2,776.05 ₹ 43,491.45
₹ 54,000.00 ₹ 186,000.00 ₹ 11,160.00 ₹ 174,840.00
₹ 40,359.15 ₹ 139,014.85 ₹ 8,340.89 ₹ 130,673.96
₹ 42,750.00 ₹ 147,250.00 ₹ 8,835.00 ₹ 138,415.00
₹ 12,460.50 ₹ 42,919.50 ₹ 2,575.17 ₹ 40,344.33
₹ 18,900.00 ₹ 65,100.00 ₹ 3,906.00 ₹ 61,194.00
₹ 10,800.00 ₹ 37,200.00 ₹ 2,232.00 ₹ 34,968.00
₹ 17,775.00 ₹ 61,225.00 ₹ 3,673.50 ₹ 57,551.50
₹ 21,600.00 ₹ 74,400.00 ₹ 4,464.00 ₹ 69,936.00
₹ 35,203.50 ₹ 121,256.50 ₹ 7,275.39 ₹ 113,981.11
₹ 13,275.00 ₹ 45,725.00 ₹ 2,743.50 ₹ 42,981.50
₹ 19,350.00 ₹ 66,650.00 ₹ 3,999.00 ₹ 62,651.00
₹ 40,442.85 ₹ 139,303.15 ₹ 8,358.19 ₹ 130,944.96
₹ 67,050.00 ₹ 230,950.00 ₹ 13,857.00 ₹ 217,093.00
₹ 19,855.35 ₹ 68,390.65 ₹ 4,103.44 ₹ 64,287.21
₹ 14,805.00 ₹ 50,995.00 ₹ 3,059.70 ₹ 47,935.30
₹ 27,000.00 ₹ 93,000.00 ₹ 5,580.00 ₹ 87,420.00
₹ 29,250.00 ₹ 100,750.00 ₹ 6,045.00 ₹ 94,705.00
₹ 597,943.35 ₹ 2,059,582.65 ₹ 123,574.96 ₹ 1,936,007.69
 CALCULATING ESTIMATES

You have received an enquiry for the supply of open storage tanks of one metre diameter.
You have to estimate the cost and prepare quotations with the details given below.

Consider the Table given below:

Drawing no: AAB/PROJ/PL2/EQP3/ASS1

Material requirement for the tank of one metre diameter:

SLNO ITEM/MATERIAL Wt Wastage allowance Total wt.

(kg) 0.1 (kg)
1 ms sheet 4mm 109 10.9 119.9
2 ms p1 6 mm 41 4.1 45.1
3 ms p1 10mm 4 0.4 4.4
4 ms p1 10mm 0.8 0.08 0.88
TOTAL MATERIAL COST
Material cost@ Rs.20/kg.

QUESTION A

1.Calculate wastage at 10% on the relevant weights for each material/ITEM and enter it in the WASTAGE ALLO
2.Calculate total weight by adding weight and wastage allowance for each material/ITEM in the TOTAL WEIGH
3.In the Cost Column calculate the cost by multiplying TOTAL WEIGHT COLUMN with the MATERIAL COST
4.Calculate the TOTAL MATERIAL COST FOR ALL THE ITEMS/MATERIALS

QUESTION B

1.Calculate the following:(PRINT RESULTS IN THE SHADED GREEN AREAS)

CONVERSION COST

a.Shell Rolling Cost

=(TOTAL WT. OF ITEM 1 * Rs 3/kg) #VALUE!

b.LEG CUTTING/EDGE PREPARATION/WELDING COST

=(TOTAL WT. OF ITEM 2,3,4 * Rs 3/kg)

c.WELDING COST:
8 MAN HOURS* Rs 25/hr

d.DRILLING/ASSEMBLY/PAINTING 500

TOTAL CONVERSION COST #VALUE!

QUESTION C
BOUGHT OUT COMPONENTS

1.VALVE
 =4* Rs 100

2.LEVEL GAUGE
=4* Rs 1000

TOTAL BOUGHT OUT COMPONENTS

QUESTION D
CONSOLIDATION

1 RAW MATERIAL COST

(PRINT TOTAL MATERIAL COST VALUE FROM QUESTION A USING PASTE SPECIAL)

2 LABOUR CHARGES
(PRINT TOTAL CONVERSION COST VALUE FROM QUESTION B USING PASTE SPECIAL)

3 BOUGHT OUT COMPONENTS

(PRINT TOTAL BOUGHT OUT COST VALUE FROM QUESTION C USING PASTE SPECIAL)

4 CONSOLIDATED TOTAL
=RAW MATERIAL COST+LABOUR CHARGES+BOUGHT OUT COMPONENTS

QUESTION E

Calculate the following:

1 ADMIN
=30% * CONSOLIDATED TOTAL

2 COMMISSION
=5% * CONSOLIDATED TOTAL

3 NEGOTIATION MARGIN
=10% * CONSOLIDATED TOTAL

4 TOTAL QUOTE
=ADMIN+COMMISION+NEGOTIATION+CONSOLIDATED TOTAL
 3

COST

359.7
135.3
13.2
2.64

enter it in the WASTAGE ALLOWANCE COLUMN

rial/ITEM in the TOTAL WEIGHT COLUMN.
N with the MATERIAL COST
 Student DataBase
Test1 Test2 average Project
sl.no name Marks marks marks marks assignment
1 Veena 49 58 21 58
2 Vignes 88 1 44 16
3 Vinuth 82 44 88 75
4 Vani 30 30 17 80
5 Vashis 86 99 99 80
6 Vikram 3 12 27 97
7 Vasu 74 71 16 18
8 Varun 77 96 92 73
9 Vanith 78 1 83 84
10 Veenit 83 59 95 47
11 ambani 9 32 98 70
12 brinda 98 29 43 11
13 deepak 92 19 92 55
14 anita 58 85 61 85
15 sebasti 53 22 3 48
16 leema 43 27 1 6
17 vincent 35 93 19 72
18 shantha 2 41 47 32
19 david 30 51 98 56
20 manu 24 82 40 21

Question A

Complete the above database :

1. Average marks is Average of test1 Marks and test2 Marks
2. Total Mark60% of average marks + 30% of project + 10% of assignment
3. Result is Pass if total marks is more than 35 else fail
4. Grades :
Total Grades
100-90Distinction
89-60 First Class
59-45 Second Class
44-35 Pass Class
<35 Fail
5. Results will be pass only if test1,test2, project marks and assignment marks

Question B

1. Total marks greater than 90 to yellow color

2. All project marks less than 35 in background Bright red color font White colo
3. All distinctions should be in blue color
4. Color all above Assignment marks which falls above average to Bright Blue b
5. insert a blue data bar to the project column
6. Remove all the conditional formatting
7. insert a check mark for project marks more than 60, ! for marks between 59
8. All Marks more than 90 should have a red icon
9. If the student is "fail" the whole record (row) should be in red color and if it is
10. Color the max total marks to green color and Min total marks to red color
11. Color all the Names which starts with a "A"

=if(logical condition,true value,false value)

simple
nested
complex
Banana Vinutha
dent DataBase
total
marks pass/fail grades Results

+ 10% of assignment
ks and assignment marks are more than or equal to 35.

t red color font White color

ve average to Bright Blue background

0, ! for marks between 59 and 35, X mark for marks less than 35

d be in red color and if it is "Pass" the whole record(row) should be in green color
total marks to red color

value,false value)

column condition
single single
single muliple
multiple single/multiple and/or
green color
Example 1 Simple if
Arrive at the discount available for each of these items purchased, where the discount being 10% for

Goods Purchased Available Discount Total Cost

5000 500 4500
10000 1500 8500
25000 3750 21250
32000 4800 27200

Example 2 Nested if
Award the "Gold" medal for the total score(round1 + round2) of 12 or greater , and a "silver" medal

Round1 Round2 Prize

Team A 7 3 NO PRIZE
Team B 4 3 NO PRIZE
Team C 3 4 NO PRIZE
Team D 4 9 GOLD
Team E 3 7 NO PRIZE
Team F 2 8 NO PRIZE
Team G 9 0 NO PRIZE

Example 3 Complex if
if the sugar levels of a patient are in the range specified print the resultant as "normal" else "Variati

Minimum
120
readings
Maximum
180
readings

Sugar readings Bonus

patient1 157 NORMAL
patient2 103 VAR
patient3 221 VAR
patient4 92 VAR
patient5 193 VAR
patient6 161 NORMAL
patient7 169 NORMAL
patient8 229 VAR
patient9 160 NORMAL
patient10 99 VAR

Example 4

slno empname age dept desgn basic rating ppl mgmn

1 shanthi 25 hr mgr 3000 20 good
2 aishwarya 26 hr sr mgr 4000 11 bad
3 sandeep 28 sales sr mgr 4000 15 good
4 simran 26 prod sr mgr 4000 16 avg
5 veer 24 hr mgr 3000 13 good
6 sachin 29 sales sr mgr 4000 5 bad
7 bin laden 26 prod mgr 3000 6 avg
8 ambani 25 hr sr mgr 4000 8 bad
9 brinda 28 prod sr mgr 4000 4 good
10 deepak 30 prod mgr 3000 7 avg
11 anita 40 Qc mgr 3000 6 good
12 sebastian 30 Qc Executive 2000 12 avg
13 leema 45 Qc mgr 3000 10 bad
14 vincent 24 Stores mgr 3000 17 good
15 shantha 20 Stores Executive 2000 18 good
16 david 45 Qc sr mgr 4000 14 avg
17 manu 30 Qc Executive 2000 11 good

simple
Rating Incentive1
>=10 1000
else 500

nested
rating Incentive2
<5 none
5 to 10 300
11 to 15 500
>15 1000

multiple

rating>=10 and ppl mgnt="good",then "y",else "n" for promotion

Example 5 Complex if

Height Weight
Sl. No Name Age (in cms) (in kgs) QualificaTest 1 Test2
1. Ravi B. S 21 157 55 GR
2. Shanker 19 161 60 PGR
3. Arun Kumar 20 163 59 P.U.C
4. Praveen Sharma 22 161 62 PGR
5. Ahmed R. 23 165 62 GR
6. Sebastian D’Souza 20 170 63 P.U.C
7. Gautam Kapoor 22 162 64 GR
8. Kiran Patil 23 163 63 PGR
9. Mahesh Gupta 25 164 62 GR
10. Dinesh Kumar 22 165 61 P.U.C

The above is a database of applicants for recruitment in the Defense Forces. The Selection process consists of four el

Test 1 : The candidate’s age should be 21 or above.

Test 2 : The candidate’s age should be 21 or above and his height should be above 161 cms.

Test 3 : The candidate’s age should be 21 or above, his height should be above 161 cms and his weight should 60 kg

Test 4 : The candidate’s age should be 21 or above, his height should be above 161 cms , his weight should 60 kgs o

Write an if function to get YES for the eligible candidates and NO for the candidates who are not eligible

Example 6

On the basis of the sales made calculate the price.

Global Marketting

discount for firs 10%

discount for sal 15%
Sales price discount
100 10
483 48.3
658 73.7
1800 245
Example 7 Nested if

On the basis of the pricing fixed below,arrive at the sales price for each of the gallon sales made below:

Cost/gallon for the fi 23

Cost/gallon for the n 20
Cost/gallon for gall 15

Number of gallons:price
1600
483
2001
he discount being 10% for goods less than 10,000 and 15% for the rest

ater , and a "silver" medal for a score between 8 and 11, "No prize" for less than 8

t as "normal" else "Variations"

incentive1 incentive2 promotion
 Test3 Test 4

on process consists of four eligibility tests for which criteria is given.

s and his weight should 60 kgs or above.

s , his weight should 60 kgs or above and he should be either a Graduate (GR) or a PostGraduate (PGR).

are not eligible

slno empname age dept desgn basic
1 shanthi 25 hr mgr 3000
2 aishwarya 26 hr sr mgr 4000
3 sandeep 28 sales sr mgr 4000
4 simran 26 prod sr mgr 4000
5 veer 24 hr mgr 3000
6 sachin 29 sales sr mgr 4000
7 bin laden 26 prod mgr 3000 ambani
8 ambani 25 hr sr mgr 4000 #NAME?
9 brinda 28 prod sr mgr 4000
10 deepak 30 prod mgr 3000
11 anita 40 Qc mgr 3000
12 sebastian 30 Qc Executive 2000
13 leema 45 Qc mgr 3000
14 vincent 24 Stores mgr 3000
15 shantha 20 Stores Executive 2000
16 david 45 Qc sr mgr 4000
17 manu 30 Qc Executive 2000
18 sss 31 Qc Vice Presid 2001

assnment 1: vlookup
name basic
deepak
ambani
shankar
rashmi
shanthi
assnment 2: vlookup

slno dept desgn

4
7
5
9
 20

slno 1 2 3 4 5 6 7 8 9 10 11 12
empname shanthi aishwarya sandeep simran veer sachin bin laden ambanbrinda deepak anita sebastian
age 25 26 28 26 24 29 26 25 28 30 40 30
dept hr hr sales prod hr sales prod hr prod prod Qc Qc
desgn mgr sr mgr sr mgr sr mgr mgr sr mgr mgr sr mgrsr mgr mgr mgr Executive
basic 3000 4000 4000 4000 3000 4000 3000 4000 4000 3000 3000 2000
hra 1500 2000 2000 2000 1500 2000 1500 2000 2000 1500 1500 1000
da 750 1000 1000 1000 750 1000 750 1000 1000 750 750 500
gross 5250 7000 7000 7000 5250 7000 5250 7000 7000 5250 5250 3500
rating 20 11 15 16 13 5 6 8 4 7 6 12

assnment 3:hlookup

empname shanthi sunitha ambani veer brinda

basic salary Err:511 4000 #N/A 3000 #N/A

assnment 4:hlookup

slno 5 6 15 20 21
dept
desgn
 13 14 15 16 17
leema vincent shanthadavid manu
45 24 20 45 30
Qc Stores Stores Qc Qc
mgr mgr Executisr mgr Executive
3000 3000 2000 4000 2000
1500 1500 1000 2000 1000
750 750 500 1000 500
5250 5250 3500 7000 3500
10 17 18 14 11
 Clearwater
Given below is the distance table between two cities.

City Code CITY

1 Clearwater 0
2 Daytona Beach 159
3 Ft. Lauderdale 247
4 Gainesville 131
5 Jacksonville 197
6 Key Largo 296
7 Miami 262
8 Orlando 106
9 Sarasota 53
10 Tampa 22

Write a Vlookup to Get distance b/w. the following cities and Orlando

City orlando
Key Largo
Miami
Clearwater
Tampa
Sarasota
Canada
Write a Vlookup to Get distance b/w. the following city codes and Orlando

City code orlando

8
6
10
2
18
15

Sl.no Last Name Age Department

1 Thompson J 22 Accounts
2 Anthony Taylor 48 Accounts
3 Thomas E. Abbott 45 Accounts
4 Tom Brown 26 Accounts
5 Clark Bickerson 32 Admin
6 Stephen C. Carter 21 Admin
 7 Steven H. Katz 21 Admin
8 Chris Poundswor 48 HR
9 Michael Hayden 21 HR
10 Phillip A. Todd 45 HR
11 Richard E. Card 26 HR
12 Rick Fogerty 24 HR
13 Robert H. Miller 34 HR

VLOOKUP
NAME Designation Sl.no
Thompson J 5
Tom Black 9
Michael Hayden 12
Rick Fogerty 8
Anthony Taylor 1

Sl.no 1 2 3
Last Name Thompson J Anthony Taylor Thomas E. Abbott
Age 22 48 45
Department Accounts Accounts Accounts
Designation Executive Sr. Manager Manager
Basic 39876 55500 60000
Hra 3987.6 5550 6000
DA 15950.4 22200 24000
Gross Salary 59814 83250 90000
Rank 5 1 2

HLOOKUP

NAME AGE Sl.no

Thompson J 5
Tom Black 9
Michael Hayden 12
Rick Fogerty 8
Anthony Taylor 1
 Daytona Beach

Ft. Lauderdale

Jacksonville
Gainesville

Key Largo

Sarasota
Orlando

Tampa
Miami
159 247 131 197 296 262 106 53 22
0 230 97 89 309 255 54 181 138
230 0 309 317 80 26 206 200 232
97 309 0 68 372 332 109 177 128
89 317 68 0 396 342 134 237 190
309 80 372 396 0 54 269 243 287
255 26 332 342 54 0 229 214 246
54 206 109 134 269 229 0 128 85
181 200 177 237 243 214 128 0 52
138 232 128 190 287 246 85 52 0

Designation Basic Hra DA Gross Sal Rank

Executive 39876 3987.6 15950.4 59814 5
Sr. Manager 55500 5550 22200 83250 1
Manager 60000 6000 24000 90000 2
Executive 65000 6500 26000 97500 3
Manager 120000 12000 48000 180000 4
Executive 44123 4412.3 17649.2 66184.5 3
Executive 32900 3290 13160 49350 3
Sr. Manager 29850 2985 11940 44775 2
Executive 78230 7823 31292 117345 5
Executive 29500 2950 11800 44250 5
Manager 43000 4300 17200 64500 3
Executive 89873 8987.3 35949.2 134810 3
Manager 149000 14900 59600 223500 1

Designation Department

4 5 6 7 8 9 10 11 12 13
Tom Brown Clark BickersStephen C. CarSteven H.Chris PouMichael Phillip A. Richard ERick FogeRobert H. Miller
26 32 21 21 48 21 45 26 24 34
Accounts Admin Admin Admin HR HR HR HR HR HR
Executive Manager Executive ExecutiveSr. ManagExecutiveExecutiveManager ExecutiveManager
65000 120000 44123 32900 29850 78230 29500 43000 89873 149000
6500 12000 4412.3 3290 2985 7823 2950 4300 8987.3 14900
26000 48000 17649.2 13160 11940 31292 11800 17200 35949.2 59600
97500 180000 66184.5 49350 44775 117345 44250 64500 134810 223500
3 4 3 3 2 5 5 3 3 1

Designation Department
 Employee Details Form
Employee Code S031
Employee Name Mickey
SSN Number 628-76-6531
Region
Earnings
Department
Start Date
Employee_code First_name Last_name SSN Region Department Earnings Start_date
S029 Mickey Anderson 628-76-6529 South Accounts $45,000.00 01-Aug-2000
S030 Mickey Ryan 628-76-6530 West Accounts $32,000.00 01-Jan-2001
S031 Mickey Lee 628-76-6531 North Accounts $32,000.00 01-Jun-2001
S032 Mickey Taylor 628-76-6532 East Accounts $32,000.00 01-Nov-2001
S033 Mickey Fulkerson 628-76-6533 South Accounts $32,000.00 01-Apr-2002
S034 Mickey Tate 628-76-6534 West Accounts $32,000.00 01-Sep-2002
S035 Mickey Marks 628-76-6535 North Accounts $32,000.00 01-Feb-2003
S036 Mickey Taylor 628-76-6536 East Accounts $32,000.00 01-Jul-2003
S037 Mickey Fulkerson 628-76-6537 South Accounts $32,000.00 01-Dec-2003
S038 Mickey Kiln 628-76-6538 South Marketing $32,000.00 01-Apr-2004
S039 Mickey Pecks 628-76-6539 South Sales $32,000.00 01-Aug-2004
S040 Mickey Carroll 628-76-6540 South Human resources $32,000.00 01-Dec-2004
S041 Mickey Morrison 628-76-6541 South Administration $32,000.00 01-Apr-2005
S042 Mickey Owens 213-71-4547 South Accounts $32,000.00 01-Aug-2005
S043 Mickey Robertson 058-49-1739 South Marketing $32,000.00 01-Dec-2005
S044 Mickey Gable 785-48-2931 South Sales $32,000.00 10-Apr-1998
S045 Mickey Thomas 631-38-3711 South Human resources $32,000.00 10-Aug-1998
S046 Mickey Goldstein 816-17-7191 South Administration $32,000.00 10-Dec-1998
S047 Mickey Owens 476-20-4792 West Administration $34,000.00 01-Sep-2000
S048 Mickey Ryan 631-20-3941 North Administration $34,000.00 01-Feb-2001
S049 Mickey Goldstein 799-70-5719 East Administration $34,000.00 01-Jul-2001
S050 Mickey Adams 591-61-8906 South Administration $34,000.00 01-Dec-2001
S051 Mickey Knapp 639-39-3139 West Administration $34,000.00 01-May-2002
S052 Mickey Morgan 389-10-7124 North Administration $34,000.00 01-Oct-2002
S053 Mickey Ryan 729-49-1739 East Administration $34,000.00 01-Mar-2003
S054 Mickey Adams 720-92-7216 South Administration $34,000.00 01-Aug-2003
S055 Mickey Knapp 336-68-4267 West Administration $34,000.00 01-Jan-2004
S056 Mickey Tate 291-73-8906 West Accounts $34,000.00 01-May-2004
S057 Mickey Johnson 027-76-8856 West Marketing $34,000.00 01-Sep-2004
S058 Mickey James 022-38-3389 West Sales $34,000.00 01-Jan-2005
S059 Mickey O'Connor 712-35-4005 West Human resources $34,000.00 01-May-2005
S060 Mickey Carter 175-21-4107 West Administration $34,000.00 01-Sep-2005
S061 Mickey Anderson 019-26-9428 West Accounts $34,000.00 10-Jan-1998
S062 Mickey Miller 724-92-8094 West Marketing $34,000.00 10-May-1998
S063 Mickey Van Hof 501-16-1748 West Sales $34,000.00 10-Sep-1998
S064 Mickey Perry 790-70-5719 West Human resources $34,000.00 10-Jan-1999
S065 Mickey Ryan 882-17-3314 East Administration $34,000.00 23-Dec-1998
S066 Mickey Robertson 519-26-9428 East Marketing $45,000.00 01-Jul-2000
S067 Mickey Miller 784-62-8371 South Marketing $45,000.00 01-Dec-2000
S068 Mickey Thomas 712-35-2971 West Marketing $45,000.00 01-May-2001
S069 Mickey Roberts 391-71-3710 North Marketing $45,000.00 01-Oct-2001
S070 Mickey Linden 784-50-2831 East Marketing $45,000.00 01-Mar-2002
S071 Mickey Kiln 712-35-8120 South Marketing $45,000.00 01-Aug-2002
S072 Mickey Johnson 212-21-2121 West Marketing $45,000.00 01-Jan-2003
S073 Mickey Kelly 719-20-4792 North Marketing $45,000.00 01-Jun-2003
S074 Mickey Linden 816-17-3314 East Marketing $45,000.00 01-Nov-2003
S075 Mickey Hope 519-98-7549 East Sales $45,000.00 01-Mar-2004
S076 Mickey Dungen 986-03-5705 East Human resources $45,000.00 01-Jul-2004
S077 Mickey Ryan 785-87-4619 East Administration $45,000.00 01-Nov-2004
S078 Mickey Long 032-20-1728 East Accounts $45,000.00 01-Mar-2005
S079 Mickey Bennet 349-10-2721 East Marketing $45,000.00 01-Jul-2005
S080 Mickey Jones 421-39-2830 East Sales $45,000.00 01-Nov-2005
S081 Mickey Morrell 076-20-4792 East Human resources $45,000.00 10-Mar-1998
S082 Mickey Ryan 819-27-3940 East Administration $45,000.00 10-Jul-1998
S083 Mickey Lee 012-35-2971 East Accounts $45,000.00 10-Nov-1998
S084 Mickey Morrell 785-48-9898 North Human resources $56,000.00 01-Oct-2000
S085 Mickey Thomas 561-16-1748 East Human resources $56,000.00 01-Mar-2001
S086 Mickey Schmidt 336-68-6293 South Human resources $56,000.00 01-Aug-2001
S087 Mickey Jones 293-71-9578 West Human resources $56,000.00 01-Jan-2002
S088 Mickey Motts 342-49-1722 North Human resources $56,000.00 01-Jun-2002
S089 Mickey Dungen 213-82-1947 East Human resources $56,000.00 01-Nov-2002
S090 Mickey Carroll 519-49-6913 South Human resources $56,000.00 01-Apr-2003
S091 Mickey Jones 381-62-8371 West Human resources $56,000.00 01-Sep-2003
S092 Mickey Motts 312-71-3818 North Human resources $56,000.00 01-Feb-2004
S093 Mickey Morgan 591-58-9578 North Administration $56,000.00 01-Jun-2004
S094 Mickey Marks 476-45-9932 North Accounts $56,000.00 01-Oct-2004
S095 Mickey Light 631-16-3178 North Marketing $56,000.00 01-Feb-2005
S096 Mickey Young 089-85-3313 North Sales $56,000.00 01-Jun-2005
S097 Mickey Morris 212-19-2232 North Human resources $56,000.00 01-Oct-2005
S098 Mickey Owens 028-62-6529 North Administration $56,000.00 10-Feb-1998
S099 Mickey Ryan 080-62-8371 North Accounts $56,000.00 10-Jun-1998
S100 Mickey Thomas 340-27-2839 North Marketing $56,000.00 10-Oct-1998
S101 Mickey Thompson 336-60-6293 North Sales $56,000.00 10-Feb-1999
S102 Mickey Jones 956-49-1739 North Sales $60,000.00 01-Jun-2000
S103 Mickey Pingault 816-17-3312 East Human resources $72,000.00 20-Jan-1995
S104 Mickey Anderson 777-76-8856 East Human resources $72,000.00 22-Jan-2001
S105 Mickey Morrison 712-35-4665 East Human resources $72,000.00 19-Nov-1995
S106 Mickey O'Connor 189-85-3313 East Human resources $72,000.00 18-Jul-2003
S107 Mickey Roberts 312-43-5291 East Marketing $72,000.00 10-Mar-1999
S108 Mickey Bennet 342-49-1758 South Sales $72,000.00 10-Dec-1999
S109 Mickey Gable 729-49-1742 West Human resources $72,000.00 04-Aug-2003
S110 Mickey Goldstein 816-17-8295 West Accounts $72,000.00 24-Nov-2003
S111 Mickey Pingault 986-07-8259 West Sales $72,000.00 15-Mar-2004
S112 Mickey Greg 045-20-1728 West Administration $72,000.00 05-Jul-2004
S113 Mickey Mayers 421-72-9230 West Marketing $72,000.00 25-Oct-2004
S114 Mickey Jones 361-20-3941 North Sales $72,000.00 28-Feb-2005
S115 Mickey Ryan 391-39-3710 North Administration $72,000.00 20-Jun-2005
S116 Mickey Roberts 342-49-6139 North Marketing $72,000.00 23-Jul-1997
S117 Mickey Motts 421-71-2831 North Human resources $72,000.00 23-Mar-1998
S118 Mickey Williams 534-98-7549 East Marketing $78,000.00 29-Jun-2004
S119 Mickey Austin 476-20-9932 South Marketing $78,000.00 06-Sep-2002
S120 Mickey Owens 172-21-4107 West Marketing $78,000.00 01-Aug-2001
S121 Mickey Gregory 290-71-9578 East Sales $78,000.00 10-Jul-1999
S122 Mickey Jones 389-58-7124 South Human resources $78,000.00 26-May-2003
S123 Mickey Thomas 783-48-2491 West Administration $78,000.00 29-Sep-2003
S124 Mickey Taylor 534-98-7820 West Marketing $78,000.00 19-Jan-2004
S125 Mickey Williams 785-87-1947 West Human resources $78,000.00 10-May-2004
S126 Mickey Roberts 983-10-2721 West Accounts $78,000.00 30-Aug-2004
S127 Mickey Young 476-82-4792 West Sales $78,000.00 20-Dec-2004
S128 Mickey O'Connor 216-17-8291 North Human resources $78,000.00 25-Apr-2005
S129 Mickey Lee 729-51-5193 North Accounts $78,000.00 23-Mar-1997
S130 Mickey Gregory 389-86-7124 North Sales $78,000.00 23-Nov-1997
S131 Mickey Morgan 719-74-4792 North Administration $78,000.00 23-Jul-1998
S132 Mickey Lee 799-70-8097 South Accounts $80,000.00 06-Apr-2002
S133 Mickey James 456-78-8906 East Accounts $80,000.00 17-Jun-1989
S134 Mickey James 631-10-3178 North Accounts $80,000.00 27-Oct-2001
S135 Mickey Carter 212-21-2232 West Accounts $80,000.00 29-Jan-1998
S136 Mickey Morris 421-11-1111 West Accounts $80,000.00 03-Mar-2004
S137 Mickey Taylor 391-71-3712 South Accounts $80,000.00 10-Apr-1999
S138 Mickey Morrison 784-56-2831 West Accounts $80,000.00 10-Sep-1999
S139 Mickey Owens 343-71-5193 West Marketing $80,000.00 14-Apr-2003
S140 Mickey Anderson 172-38-3910 North Marketing $80,000.00 23-Jun-2003
S141 Mickey Miller 519-49-8203 North Sales $80,000.00 18-Aug-2003
S142 Mickey Thomas 381-62-8351 East Sales $80,000.00 27-Oct-2003
S143 Mickey Schmidt 099-70-8097 North Administration $80,000.00 08-Dec-2003
S144 Mickey Jones 381-78-8906 East Administration $80,000.00 16-Feb-2004
S145 Mickey Lee 376-61-3383 North Marketing $80,000.00 29-Mar-2004
S146 Mickey James 931-30-3389 East Marketing $80,000.00 07-Jun-2004
S147 Mickey Johnson 343-27-7193 North Human resources $80,000.00 19-Jul-2004
S148 Mickey Lawrence 172-21-4817 East Human resources $80,000.00 27-Sep-2004
S149 Mickey Long 025-49-1739 North Accounts $80,000.00 08-Nov-2004
S150 Mickey Owens 720-92-9138 East Accounts $80,000.00 17-Jan-2005
S151 Mickey Robertson 562-17-1748 East Marketing $80,000.00 14-Mar-2005
S152 Mickey Miller 335-68-6293 South Marketing $80,000.00 23-May-2005
S153 Mickey Thomas 856-93-6910 East Human resources $80,000.00 04-Jul-2005
S154 Mickey Schmidt 295-49-3861 South Human resources $80,000.00 23-May-1997
S155 Mickey Taylor 343-47-5193 East Accounts $80,000.00 23-Aug-1997
S156 Mickey Fulkerson 172-38-6293 South Accounts $80,000.00 23-Jan-1998
S157 Mickey Hope 927-49-1739 East Sales $80,000.00 23-Apr-1998
S158 Mickey Pecks 072-92-7216 South Sales $80,000.00 23-Sep-1998
S159 Mickey Gable 720-92-8094 East Sales $84,000.00 01-Nov-2000
S160 Mickey Van Hof 343-27-2839 South Sales $84,000.00 01-Apr-2001
S161 Mickey Thompson 312-41-5291 West Sales $84,000.00 01-Sep-2001
S162 Mickey Gregory 785-87-5193 North Sales $84,000.00 01-Feb-2002
S163 Mickey Hope 343-27-5193 East Sales $84,000.00 01-Jul-2002
S164 Mickey Pecks 172-38-4107 South Sales $84,000.00 01-Dec-2002
S165 Mickey Thomson 628-71-8341 West Sales $84,000.00 01-May-2003
S166 Mickey Gregory 391-30-3940 North Sales $84,000.00 01-Oct-2003
S167 Mickey Greg 986-07-5705 East Sales $85,000.00 04-Apr-2003
S168 Mickey Johnson 376-31-3383 North Sales $85,000.00 29-Mar-1998
S169 Mickey Roberts 785-87-9898 North Sales $85,000.00 08-May-2000
S170 Mickey Lee 784-98-8094 West Sales $85,000.00 14-Jan-2005
S171 Mickey Lawrence 133-30-3389 North Sales $85,000.00 07-Aug-2003
S172 Mickey Bennet 213-44-4547 South Sales $85,000.00 16-Oct-2002
S173 Mickey Young 630-39-3139 East Human resources $85,000.00 10-Nov-1999
S174 Mickey Morrell 421-61-2831 South Administration $85,000.00 21-Jul-2003
S175 Mickey Morris 331-30-3940 West Human resources $85,000.00 14-Feb-2005
S176 Mickey Marks 391-93-3940 North Accounts $85,000.00 23-Nov-1998
S177 Mickey Young 389-10-2721 North Customer support $86,000.00 09-Feb-1997
S178 Mickey Overmire 312-71-3816 South Administration $90,000.00 02-Oct-1997
S179 Mickey Jones 591-37-8906 North Human resources $90,000.00 10-Jun-1999
S180 Mickey Morris 172-85-4910 East Administration $90,000.00 12-May-2003
S181 Mickey Ryan 719-24-4792 South Accounts $90,000.00 15-Sep-2003
S182 Mickey Roberts 312-82-3816 South Sales $90,000.00 05-Jan-2004
S183 Mickey Overmire 476-71-9932 South Administration $90,000.00 26-Apr-2004
S184 Mickey Austin 198-85-3313 South Marketing $90,000.00 16-Aug-2004
S185 Mickey O'Connor 628-82-6529 South Human resources $90,000.00 06-Dec-2004
S186 Mickey Owens 712-85-2971 West Administration $90,000.00 11-Apr-2005
S187 Mickey Thomas 293-87-9578 West Marketing $90,000.00 23-Feb-1997
S188 Mickey Jones 981-85-4910 West Human resources $90,000.00 23-Oct-1997
S189 Mickey Tate 826-71-8341 West Accounts $90,000.00 23-Jun-1998
S190 Mickey McGregor 336-68-4467 South Administration $95,000.00 19-Jul-1999
S191 Mickey Smith 654-58-9578 North Administration $95,000.00 18-Feb-1999
S192 Mickey Mayers 332-20-1728 North Administration $95,000.00 10-Dec-1999
S193 Mickey Long 343-27-6567 North Administration $95,000.00 03-Jun-2001
S194 Mickey Adams 806-85-6910 West Administration $95,000.00 10-May-1999
S195 Mickey O'Connor 133-27-3861 North Administration $95,000.00 10-Oct-1999
S196 Mickey Carter 712-35-8719 North Accounts $95,000.00 28-Apr-2003
S197 Mickey Owens 491-57-2121 East Accounts $95,000.00 07-Jul-2003
S198 Mickey Ryan 608-71-8341 East Marketing $95,000.00 01-Sep-2003
S199 Mickey Lee 391-82-3940 South Marketing $95,000.00 10-Nov-2003
S200 Mickey Thompson 336-82-4467 East Human resources $95,000.00 22-Dec-2003
S201 Mickey Gregory 654-73-9578 South Human resources $95,000.00 01-Mar-2004
S202 Mickey McGregor 924-76-8856 East Accounts $95,000.00 12-Apr-2004
S203 Mickey Smith 631-82-3178 South Accounts $95,000.00 21-Jun-2004
S204 Mickey Anderson 721-35-4665 East Sales $95,000.00 02-Aug-2004
S205 Mickey James 926-21-7230 South Sales $95,000.00 11-Oct-2004
S206 Mickey Morrison 519-71-9428 East Administration $95,000.00 22-Nov-2004
S207 Mickey Carter 847-62-8371 South Administration $95,000.00 31-Jan-2005
S208 Mickey Anderson 343-27-2840 South Accounts $95,000.00 28-Mar-2005
S209 Mickey Ryan 316-48-5291 West Accounts $95,000.00 06-Jun-2005
S210 Mickey Van Hof 591-62-8906 South Sales $95,000.00 18-Jul-2005
S211 Mickey Thompson 639-42-3139 West Sales $95,000.00 23-Jun-1997
S212 Mickey Adams 712-61-8120 South Administration $95,000.00 23-Sep-1997
S213 Mickey Knapp 613-61-9247 West Administration $95,000.00 23-Feb-1998
S214 Mickey Kiln 519-72-6913 South Marketing $95,000.00 23-May-1998
S215 Mickey Johnson 381-78-8371 West Marketing $95,000.00 23-Oct-1998
S216 Mickey Philips 856-85-8586 West Human resources $98,000.00 05-Nov-2002
S217 Mickey Long 785-87-5171 South Marketing $98,000.00 10-Aug-1999
S218 Mickey Robertson 282-82-1947 West Sales $98,000.00 09-Jun-2003
S219 Mickey Van Hof 720-92-7336 North Human resources $98,000.00 13-Oct-2003
S220 Mickey Adams 027-85-8586 North Accounts $98,000.00 02-Feb-2004
S221 Mickey Philips 784-82-8094 North Sales $98,000.00 24-May-2004
S222 Mickey Lee 213-59-4547 North Administration $98,000.00 13-Sep-2004
S223 Mickey Bennet 785-48-0268 North Marketing $98,000.00 03-Jan-2005
S224 Mickey Gable 794-70-5719 East Sales $98,000.00 09-May-2005
S225 Mickey Goldstein 784-75-2831 East Administration $98,000.00 23-Apr-1997
S226 Mickey Linden 312-82-1947 East Marketing $98,000.00 23-Dec-1997
S227 Mickey Dungen 785-51-2491 East Human resources $98,000.00 23-Aug-1998
Salesperson Reports Sample Workbook Source Data

Country SalespersonOrder DateOrderID Order Amount

UK Buchanan 7/16/2003 10248 $440.00
UK Suyama 7/10/2003 10249 $1,863.40
USA Peacock 7/12/2003 10250 $1,552.60
USA Leverling 7/15/2003 10251 $654.06
USA Peacock 7/11/2003 10252 $3,597.90
USA Leverling 7/16/2003 10253 $1,444.80
UK Buchanan 7/23/2003 10254 $556.62
UK Dodsworth 7/15/2003 10255 $2,490.50
USA Leverling 7/17/2003 10256 $517.80
USA Peacock 7/22/2003 10257 $1,119.90
USA Davolio 7/23/2003 10258 $1,614.88
USA Peacock 7/25/2003 10259 $100.80
USA Peacock 7/29/2003 10260 $1,504.65
USA Peacock 7/30/2003 10261 $448.00
USA Callahan 7/25/2003 10262 $584.00
UK Dodsworth 7/31/2003 10263 $1,873.80
UK Suyama 8/23/2003 10264 $695.62
USA Fuller 8/12/2003 10265 $1,176.00
USA Leverling 7/31/2003 10266 $346.56
USA Peacock 8/6/2003 10267 $3,536.60
USA Callahan 8/2/2003 10268 $1,101.20
UK Buchanan 8/9/2003 10269 $642.20
USA Davolio 8/2/2003 10270 $1,376.00
UK Suyama 8/30/2003 10271 $48.00
UK Suyama 8/6/2003 10272 $1,456.00
USA Leverling 8/12/2003 10273 $2,037.28
UK Suyama 8/16/2003 10274 $538.60
USA Davolio 8/9/2003 10275 $291.84
USA Callahan 8/14/2003 10276 $420.00
USA Fuller 8/13/2003 10277 $1,200.80
USA Callahan 8/16/2003 10278 $1,488.80
USA Callahan 8/16/2003 10279 $351.00
USA Fuller 9/12/2003 10280 $613.20
USA Peacock 8/21/2003 10281 $86.50
USA Peacock 8/21/2003 10282 $155.40
USA Leverling 8/23/2003 10283 $1,414.80
USA Peacock 8/27/2003 10284 $1,170.37
USA Davolio 8/26/2003 10285 $1,743.36
USA Callahan 8/30/2003 10286 $3,016.00
USA Callahan 8/28/2003 10287 $819.00
USA Peacock 9/3/2003 10288 $80.10
UK King 8/28/2003 10289 $479.40
USA Callahan 9/3/2003 10290 $2,169.00
UK Suyama 9/4/2003 10291 $497.52
USA Davolio 9/2/2003 10292 $1,296.00
USA Davolio 9/11/2003 10293 $848.70
USA Peacock 9/5/2003 10294 $1,887.60
USA Fuller 9/10/2003 10295 $121.60
UK Suyama 9/11/2003 10296 $1,050.60
UK Buchanan 9/10/2003 10297 $1,420.00
UK Suyama 9/11/2003 10298 $2,645.00
USA Peacock 9/13/2003 10299 $349.50
USA Fuller 9/18/2003 10300 $608.00
USA Callahan 9/17/2003 10301 $755.00
USA Peacock 10/9/2003 10302 $2,708.80
UK King 9/18/2003 10303 $1,117.80
USA Davolio 9/17/2003 10304 $954.40
USA Callahan 10/9/2003 10305 $3,741.30
USA Davolio 9/23/2003 10306 $498.50
USA Fuller 9/25/2003 10307 $424.00
UK King 9/24/2003 10308 $88.80

Page 37
Salesperson Reports Sample Workbook Source Data

USA Leverling ### 10309 $1,762.00

USA Callahan 9/27/2003 10310 $336.00
USA Davolio 9/26/2003 10311 $268.80
USA Fuller 10/3/2003 10312 $1,614.80
USA Fuller 10/4/2003 10313 $182.40
USA Davolio 10/4/2003 10314 $2,094.30
USA Peacock 10/3/2003 10315 $516.80
USA Davolio 10/8/2003 10316 $2,835.00
UK Suyama ### 10317 $288.00
USA Callahan 10/4/2003 10318 $240.40
UK King ### 10319 $1,191.20
UK Buchanan ### 10320 $516.00
USA Leverling ### 10321 $144.00
UK King ### 10322 $112.00
USA Peacock ### 10323 $164.40
UK Dodsworth ### 10324 $5,275.71
USA Davolio ### 10325 $1,497.00
USA Peacock ### 10326 $982.00
USA Fuller ### 10327 $1,810.00
USA Peacock ### 10328 $1,168.00
USA Peacock ### 10329 $4,578.43
USA Leverling ### 10330 $1,649.00
UK Dodsworth ### 10331 $88.50
USA Leverling ### 10332 $1,786.88
UK Buchanan ### 10333 $877.20
USA Callahan ### 10334 $144.80
UK King ### 10335 $2,036.16
UK King ### 10336 $285.12
USA Peacock ### 10337 $2,467.00
USA Peacock ### 10338 $934.50
USA Fuller 11/4/2003 10339 $3,354.00
USA Davolio 11/8/2003 10340 $2,436.18
UK King 11/5/2003 10341 $352.60
USA Peacock 11/4/2003 10342 $1,840.64
USA Peacock 11/6/2003 10343 $1,584.00
USA Peacock 11/5/2003 10344 $2,296.00
USA Fuller ### 10345 $2,924.80
USA Leverling 11/8/2003 10346 $1,618.88
USA Peacock 11/8/2003 10347 $814.42
USA Peacock ### 10348 $363.60
UK King ### 10349 $141.60
UK Suyama 12/3/2003 10350 $642.06
USA Davolio ### 10351 $5,398.72
USA Leverling ### 10352 $136.30
UK King ### 10353 $8,593.28
USA Callahan ### 10354 $568.80
UK Suyama ### 10355 $480.00
UK Suyama ### 10356 $1,106.40
USA Davolio 12/2/2003 10357 $1,167.68
UK Buchanan ### 10358 $429.40
UK Buchanan ### 10359 $3,471.68
USA Peacock 12/2/2003 10360 $7,390.20
USA Davolio 12/3/2003 10361 $2,046.24
USA Leverling ### 10362 $1,549.60
USA Peacock 12/4/2003 10363 $447.20
USA Davolio 12/4/2003 10364 $950.00
USA Leverling 12/2/2003 10365 $403.20
USA Callahan ### 10366 $136.00
UK King 12/2/2003 10367 $834.20
USA Fuller 12/2/2003 10368 $1,689.78
USA Callahan 12/9/2003 10369 $2,390.40
UK Suyama ### 10370 $1,117.60

Page 38
Salesperson Reports Sample Workbook Source Data

USA Davolio ### 10371 $72.96

UK Buchanan 12/9/2003 10372 $9,210.90
USA Peacock ### 10373 $1,366.40
USA Davolio 12/9/2003 10374 $459.00
USA Leverling 12/9/2003 10375 $338.00
USA Davolio ### 10376 $399.00
USA Davolio ### 10377 $863.60
UK Buchanan ### 10378 $103.20
USA Fuller ### 10379 $863.28
USA Callahan 1/16/2004 10380 $1,313.82
USA Leverling ### 10381 $112.00
USA Peacock ### 10382 $2,900.00
USA Callahan ### 10383 $899.00
USA Leverling ### 10384 $2,222.40
USA Davolio ### 10385 $691.20
UK Dodsworth ### 10386 $166.00
USA Davolio ### 10387 $1,058.40
USA Fuller ### 10388 $1,228.80
USA Peacock ### 10389 $1,832.80
UK Suyama ### 10390 $2,090.88
USA Leverling ### 10391 $86.40
USA Fuller 1/1/2004 10392 $1,440.00
USA Davolio 1/3/2004 10393 $2,556.95
USA Davolio 1/3/2004 10394 $442.00
UK Suyama 1/3/2004 10395 $2,122.92
USA Davolio 1/6/2004 10396 $1,903.80
UK Buchanan 1/2/2004 10397 $716.72
USA Fuller 1/9/2004 10398 $2,505.60
USA Callahan 1/8/2004 10399 $1,765.60
USA Davolio 1/16/2004 10400 $3,063.00
USA Davolio 1/10/2004 10401 $3,868.60
USA Callahan 1/10/2004 10402 $2,713.50
USA Peacock 1/9/2004 10403 $855.01
USA Fuller 1/8/2004 10404 $1,591.25
USA Davolio 1/22/2004 10405 $400.00
UK King 1/13/2004 10406 $1,830.78
USA Fuller 1/30/2004 10407 $1,194.00
USA Callahan 1/14/2004 10408 $1,622.40
USA Leverling 1/14/2004 10409 $319.20
USA Leverling 1/15/2004 10410 $802.00
UK Dodsworth 1/21/2004 10411 $966.80
USA Callahan 1/15/2004 10412 $334.80
USA Leverling 1/16/2004 10413 $2,123.20
USA Fuller 1/17/2004 10414 $224.83
USA Leverling 1/24/2004 10415 $102.40
USA Callahan 1/27/2004 10416 $720.00
USA Peacock 1/28/2004 10417 $11,188.40
USA Peacock 1/24/2004 10418 $1,814.80
USA Peacock 1/30/2004 10419 $2,097.60
USA Leverling 1/27/2004 10420 $1,707.84
USA Callahan 1/27/2004 10421 $1,194.27
USA Fuller 1/31/2004 10422 $49.80
UK Suyama 2/24/2004 10423 $1,020.00
UK King 1/27/2004 10424 $9,194.56
UK Suyama 2/14/2004 10425 $360.00
USA Peacock 2/6/2004 10426 $338.20
USA Peacock 3/3/2004 10427 $651.00
UK King 2/4/2004 10428 $192.00
USA Leverling 2/7/2004 10429 $1,441.37
USA Peacock 2/3/2004 10430 $4,899.20
USA Peacock 2/7/2004 10431 $1,892.25
USA Leverling 2/7/2004 10432 $485.00

Page 39
Salesperson Reports Sample Workbook Source Data

USA Leverling 3/4/2004 10433 $851.20

USA Leverling 2/13/2004 10434 $321.12
USA Callahan 2/7/2004 10435 $631.60
USA Leverling 2/11/2004 10436 $1,994.52
USA Callahan 2/12/2004 10437 $393.00
USA Leverling 2/14/2004 10438 $454.00
UK Suyama 2/10/2004 10439 $1,078.00
USA Peacock 2/28/2004 10440 $4,924.13
USA Leverling 3/14/2004 10441 $1,755.00
USA Leverling 2/18/2004 10442 $1,792.00
USA Callahan 2/14/2004 10443 $517.44
USA Leverling 2/21/2004 10444 $1,031.70
USA Leverling 2/20/2004 10445 $174.90
UK Suyama 2/19/2004 10446 $246.24
USA Peacock 3/7/2004 10447 $914.40
USA Peacock 2/24/2004 10448 $443.40
USA Leverling 2/27/2004 10449 $1,838.20
USA Callahan 3/11/2004 10450 $425.12
USA Peacock 3/12/2004 10451 $3,849.66
USA Callahan 2/26/2004 10452 $2,018.50
USA Davolio 2/26/2004 10453 $407.70
USA Peacock 2/25/2004 10454 $331.20
USA Callahan 3/3/2004 10455 $2,684.00
USA Callahan 2/28/2004 10456 $557.60
USA Fuller 3/3/2004 10457 $1,584.00
UK King 3/4/2004 10458 $3,891.00
USA Peacock 2/28/2004 10459 $1,659.20
USA Callahan 3/3/2004 10460 $176.10
USA Davolio 3/5/2004 10461 $1,538.70
USA Fuller 3/18/2004 10462 $156.00
UK Buchanan 3/6/2004 10463 $713.30
USA Peacock 3/14/2004 10464 $1,609.28
USA Davolio 3/14/2004 10465 $2,518.00
USA Peacock 3/13/2004 10466 $216.00
USA Callahan 3/11/2004 10467 $235.20
USA Leverling 3/12/2004 10468 $717.60
USA Davolio 3/14/2004 10469 $956.67
USA Peacock 3/14/2004 10470 $1,820.80
USA Fuller 3/18/2004 10471 $1,328.00
USA Callahan 3/19/2004 10472 $1,036.80
USA Davolio 3/21/2004 10473 $230.40
UK Buchanan 3/21/2004 10474 $1,249.10
UK Dodsworth 4/4/2004 10475 $1,505.18
USA Callahan 3/24/2004 10476 $180.48
UK Buchanan 3/25/2004 10477 $558.00
USA Fuller 3/26/2004 10478 $471.20
USA Leverling 3/21/2004 10479 $10,495.60
UK Suyama 3/24/2004 10480 $756.00
USA Callahan 3/25/2004 10481 $1,472.00
USA Davolio 4/10/2004 10482 $147.00
UK King 4/25/2004 10483 $668.80
USA Leverling 4/1/2004 10484 $386.20
USA Peacock 3/31/2004 10485 $1,584.00
USA Davolio 4/2/2004 10486 $1,272.00
USA Fuller 3/28/2004 10487 $889.70
USA Callahan 4/2/2004 10488 $1,512.00
UK Suyama 4/9/2004 10489 $439.20
UK King 4/3/2004 10490 $3,163.20
USA Callahan 4/8/2004 10491 $259.50
USA Leverling 4/11/2004 10492 $851.20
USA Peacock 4/10/2004 10493 $608.40
USA Peacock 4/9/2004 10494 $912.00

Page 40
Salesperson Reports Sample Workbook Source Data

USA Leverling 4/11/2004 10495 $278.00

UK King 4/7/2004 10496 $190.00
UK King 4/7/2004 10497 $1,380.60
USA Callahan 4/11/2004 10498 $575.00
USA Peacock 4/16/2004 10499 $1,412.00
UK Suyama 4/17/2004 10500 $523.26
UK Dodsworth 4/16/2004 10501 $149.00
USA Fuller 4/29/2004 10502 $816.30
UK Suyama 4/16/2004 10503 $2,048.50
USA Peacock 4/18/2004 10504 $1,388.50
USA Leverling 4/21/2004 10505 $147.90
UK Dodsworth 5/2/2004 10506 $415.80
UK King 4/22/2004 10507 $749.06
USA Davolio 5/13/2004 10508 $240.00
USA Peacock 4/29/2004 10509 $136.80
UK Suyama 4/28/2004 10510 $4,707.54
USA Peacock 4/21/2004 10511 $2,550.00
UK King 4/24/2004 10512 $525.30
UK King 4/28/2004 10513 $1,942.00
USA Leverling 5/16/2004 10514 $8,623.45
USA Fuller 5/23/2004 10515 $9,921.30
USA Fuller 5/1/2004 10516 $2,381.05
USA Leverling 4/29/2004 10517 $352.00
USA Peacock 5/5/2004 10518 $4,150.05
UK Suyama 5/1/2004 10519 $2,314.20
UK King 5/1/2004 10520 $200.00
USA Callahan 5/2/2004 10521 $225.50
USA Peacock 5/6/2004 10522 $2,318.24
UK King 5/30/2004 10523 $2,444.31
USA Davolio 5/7/2004 10524 $3,192.65
USA Davolio 5/23/2004 10525 $818.40
USA Peacock 5/15/2004 10526 $1,151.40
UK King 5/7/2004 10527 $1,503.00
UK Suyama 5/9/2004 10528 $392.20
UK Buchanan 5/9/2004 10529 $946.00
USA Leverling 5/12/2004 10530 $4,180.00
UK King 5/19/2004 10531 $110.00
UK King 5/12/2004 10532 $796.35
USA Callahan 5/22/2004 10533 $2,222.20
USA Callahan 5/14/2004 10534 $465.70
USA Peacock 5/21/2004 10535 $1,940.85
USA Leverling 6/6/2004 10536 $1,645.00
USA Davolio 5/19/2004 10537 $1,823.80
UK Dodsworth 5/16/2004 10538 $139.80
UK Suyama 5/23/2004 10539 $355.50
USA Leverling 6/13/2004 10540 $10,191.70
USA Fuller 5/29/2004 10541 $1,946.52
USA Davolio 5/26/2004 10542 $469.11
USA Callahan 5/23/2004 10543 $1,504.50
USA Peacock 5/30/2004 10544 $417.20
USA Callahan 6/26/2004 10545 $210.00
USA Davolio 5/27/2004 10546 $2,812.00
USA Leverling 6/2/2004 10547 $1,792.80
USA Leverling 6/2/2004 10548 $240.10
UK Buchanan 5/30/2004 10549 $3,554.27
UK King 6/6/2004 10550 $683.30
USA Peacock 6/6/2004 10551 $1,677.30
USA Fuller 6/5/2004 10552 $880.50
USA Fuller 6/3/2004 10553 $1,546.30
USA Peacock 6/5/2004 10554 $1,728.52
UK Suyama 6/4/2004 10555 $2,944.40
USA Fuller 6/13/2004 10556 $835.20

Page 41
Salesperson Reports Sample Workbook Source Data

UK Dodsworth 6/6/2004 10557 $1,152.50

USA Davolio 6/10/2004 10558 $2,142.90
UK Suyama 6/13/2004 10559 $520.41
USA Callahan 6/9/2004 10560 $1,072.42
USA Fuller 6/9/2004 10561 $2,844.50
USA Davolio 6/12/2004 10562 $488.70
USA Fuller 6/24/2004 10563 $965.00
USA Peacock 6/16/2004 10564 $1,234.05
USA Callahan 6/18/2004 10565 $639.90
UK Dodsworth 6/18/2004 10566 $1,761.00
USA Davolio 6/17/2004 10567 $2,519.00
USA Leverling 7/9/2004 10568 $155.00
UK Buchanan 7/11/2004 10569 $890.00
USA Leverling 6/19/2004 10570 $2,465.25
USA Callahan 7/4/2004 10571 $550.59
USA Leverling 6/25/2004 10572 $1,501.08
UK King 6/20/2004 10573 $2,082.00
USA Peacock 6/30/2004 10574 $764.30
UK Buchanan 6/30/2004 10575 $2,147.40
USA Leverling 6/30/2004 10576 $838.45
UK Dodsworth 6/30/2004 10577 $569.00
USA Peacock 7/25/2004 10578 $477.00
USA Davolio 7/4/2004 10579 $317.75
USA Peacock 7/1/2004 10580 $1,013.74
USA Leverling 7/2/2004 10581 $310.00
USA Leverling 7/14/2004 10582 $330.00
USA Fuller 7/4/2004 10583 $2,237.50
USA Peacock 7/4/2004 10584 $593.75
UK King 7/10/2004 10585 $142.50
UK Dodsworth 7/9/2004 10586 $23.80
USA Davolio 7/9/2004 10587 $807.38
USA Fuller 7/10/2004 10588 $3,120.00
USA Callahan 7/14/2004 10589 $72.00
USA Peacock 7/14/2004 10590 $1,101.00
USA Davolio 7/16/2004 10591 $812.50
USA Leverling 7/16/2004 10592 $516.46
UK King 8/13/2004 10593 $1,994.40
USA Leverling 7/16/2004 10594 $565.50
USA Fuller 7/14/2004 10595 $4,725.00
USA Callahan 8/12/2004 10596 $1,180.88
UK King 7/18/2004 10597 $718.08
USA Davolio 7/18/2004 10598 $2,388.50
UK Suyama 7/21/2004 10599 $493.00
USA Peacock 7/21/2004 10600 $479.80
UK King 7/22/2004 10601 $2,285.00
USA Callahan 7/22/2004 10602 $48.75
USA Callahan 8/8/2004 10603 $1,483.00
USA Davolio 7/29/2004 10604 $230.85
USA Davolio 7/29/2004 10605 $4,109.69
USA Peacock 7/31/2004 10606 $1,130.40
UK Buchanan 7/25/2004 10607 $6,475.40
USA Peacock 8/1/2004 10608 $1,064.00
UK King 7/30/2004 10609 $424.00
USA Callahan 8/6/2004 10610 $299.25
UK Suyama 8/1/2004 10611 $808.00
USA Davolio 8/1/2004 10612 $6,375.00
USA Peacock 8/1/2004 10613 $353.20
USA Callahan 8/1/2004 10614 $464.00
USA Fuller 8/6/2004 10615 $120.00
USA Davolio 8/5/2004 10616 $4,806.99
USA Peacock 8/4/2004 10617 $1,402.50
USA Davolio 8/8/2004 10618 $2,697.50

Page 42
Salesperson Reports Sample Workbook Source Data

USA Leverling 8/7/2004 10619 $1,260.00

USA Fuller 8/14/2004 10620 $57.50
USA Peacock 8/11/2004 10621 $758.50
USA Peacock 8/11/2004 10622 $560.00
USA Callahan 8/12/2004 10623 $1,336.95
USA Peacock 8/19/2004 10624 $1,393.24
USA Leverling 8/14/2004 10625 $479.75
USA Davolio 8/20/2004 10626 $1,503.60
USA Callahan 8/21/2004 10627 $1,185.75
USA Peacock 8/20/2004 10628 $450.00
USA Peacock 8/20/2004 10629 $2,775.05
USA Davolio 8/19/2004 10630 $903.60
USA Callahan 8/15/2004 10631 $55.80
USA Callahan 8/19/2004 10632 $589.00
UK King 8/18/2004 10633 $5,510.59
USA Peacock 8/21/2004 10634 $4,985.50
USA Callahan 8/21/2004 10635 $1,326.22
USA Peacock 8/26/2004 10636 $629.50
UK Suyama 8/26/2004 10637 $2,761.94
USA Leverling 9/1/2004 10638 $2,720.05
UK King 8/27/2004 10639 $500.00
USA Peacock 8/28/2004 10640 $708.75
USA Peacock 8/26/2004 10641 $2,054.00
UK King 9/5/2004 10642 $696.00
UK Suyama 9/2/2004 10643 $814.50
USA Leverling 9/1/2004 10644 $1,371.80
USA Peacock 9/2/2004 10645 $1,535.00
UK Dodsworth 9/3/2004 10646 $1,446.00
USA Peacock 9/3/2004 10647 $636.00
UK Buchanan 9/9/2004 10648 $372.37
UK Buchanan 8/29/2004 10649 $1,434.00
UK Buchanan 9/3/2004 10650 $1,779.20
USA Callahan 9/11/2004 10651 $397.80
USA Peacock 9/8/2004 10652 $318.84
USA Davolio 9/19/2004 10653 $1,083.15
UK Buchanan 9/11/2004 10654 $601.83
USA Davolio 9/11/2004 10655 $154.40
UK Suyama 9/10/2004 10656 $604.21
USA Fuller 9/15/2004 10657 $4,371.60
USA Peacock 9/8/2004 10658 $4,464.60
UK King 9/10/2004 10659 $1,227.02
USA Callahan ### 10660 $1,701.00
UK King 9/15/2004 10661 $562.60
USA Leverling 9/18/2004 10662 $125.00
USA Fuller 10/3/2004 10663 $1,930.40
USA Davolio 9/19/2004 10664 $1,288.39
USA Davolio 9/17/2004 10665 $1,295.00
UK King 9/22/2004 10666 $4,666.94
UK King 9/19/2004 10667 $1,536.80
USA Davolio 9/23/2004 10668 $625.27
USA Fuller 9/22/2004 10669 $570.00
USA Peacock 9/18/2004 10670 $2,301.75
USA Davolio 9/24/2004 10671 $920.10
UK Dodsworth 9/26/2004 10672 $3,815.25
USA Fuller 9/19/2004 10673 $412.35
USA Peacock 9/30/2004 10674 $45.00
UK Buchanan 9/23/2004 10675 $1,423.00
USA Fuller 9/29/2004 10676 $534.85
USA Davolio 9/26/2004 10677 $813.36
UK King ### 10678 $5,256.50
USA Callahan 9/30/2004 10679 $660.00
USA Davolio 9/26/2004 10680 $1,261.88

Page 43
Salesperson Reports Sample Workbook Source Data

USA Leverling 9/30/2004 10681 $1,287.40

USA Leverling 10/1/2004 10682 $375.50
USA Fuller 10/1/2004 10683 $63.00
USA Leverling 9/30/2004 10684 $1,768.00
USA Peacock 10/3/2004 10685 $801.10
USA Fuller 10/8/2004 10686 $1,404.45
UK Dodsworth ### 10687 $4,960.90
USA Peacock 10/7/2004 10688 $3,160.60
USA Davolio 10/7/2004 10689 $472.50
USA Davolio 10/3/2004 10690 $862.50
USA Fuller ### 10691 $10,164.80
USA Peacock ### 10692 $878.00
USA Leverling ### 10693 $2,071.20
USA Callahan 10/9/2004 10694 $4,825.00
UK King ### 10695 $642.00
USA Callahan ### 10696 $996.00
USA Leverling ### 10697 $805.43
USA Peacock ### 10698 $3,436.45
USA Leverling ### 10699 $114.00
USA Leverling ### 10700 $1,638.40
UK Suyama ### 10701 $2,864.50
USA Peacock ### 10702 $330.00
UK Suyama ### 10703 $2,545.00
UK Suyama 11/7/2004 10704 $595.50
UK Dodsworth ### 10705 $378.00
USA Callahan ### 10706 $1,893.00
USA Peacock ### 10707 $1,641.00
UK Suyama 11/5/2004 10708 $180.40
USA Davolio ### 10709 $3,424.00
USA Davolio ### 10710 $93.50
UK Buchanan ### 10711 $4,451.70
USA Leverling ### 10712 $1,233.48
USA Davolio ### 10713 $2,827.90
UK Buchanan ### 10714 $2,205.75
USA Leverling ### 10715 $1,296.00
USA Peacock ### 10716 $706.00
USA Davolio ### 10717 $1,270.75
USA Davolio ### 10718 $3,463.00
USA Callahan 11/5/2004 10719 $844.25
USA Callahan 11/5/2004 10720 $550.00
UK Buchanan ### 10721 $923.87
USA Callahan 11/4/2004 10722 $1,570.00
USA Leverling ### 10723 $468.45
USA Callahan 11/5/2004 10724 $638.50
USA Peacock 11/5/2004 10725 $287.80
USA Peacock 12/5/2004 10726 $655.00
USA Fuller 12/5/2004 10727 $1,624.50
USA Peacock ### 10728 $1,296.75
USA Callahan ### 10729 $1,850.00
UK Buchanan ### 10730 $484.25
UK King ### 10731 $1,890.50
USA Leverling 11/7/2004 10732 $360.00
USA Davolio ### 10733 $1,459.00
USA Fuller ### 10734 $1,498.35
UK Suyama ### 10735 $536.40
UK Dodsworth ### 10736 $997.00
USA Fuller ### 10737 $139.80
USA Fuller ### 10738 $52.35
USA Leverling ### 10739 $240.00
USA Peacock ### 10740 $1,416.00
USA Peacock ### 10741 $228.00
USA Leverling ### 10742 $3,118.00

Page 44
Salesperson Reports Sample Workbook Source Data

USA Davolio ### 10743 $319.20

UK Suyama ### 10744 $736.00
UK Dodsworth ### 10745 $4,529.80
USA Davolio ### 10746 $2,311.70
UK Suyama ### 10747 $1,912.85
USA Leverling ### 10748 $2,196.00
USA Peacock ### 10749 $1,080.00
UK Dodsworth ### 10750 $1,590.56
USA Leverling 12/3/2004 10751 $1,631.48
USA Fuller ### 10752 $252.00
USA Leverling ### 10753 $88.00
UK Suyama ### 10754 $55.20
USA Peacock ### 10755 $1,948.50
USA Callahan 12/2/2004 10756 $1,990.00
UK Suyama ### 10757 $3,082.00
USA Leverling 12/4/2004 10758 $1,644.60
USA Leverling ### 10759 $320.00
USA Peacock ### 10760 $2,917.00
UK Buchanan 12/8/2004 10761 $507.00
USA Leverling 12/9/2004 10762 $4,337.00
USA Leverling 12/8/2004 10763 $616.00
UK Suyama 12/8/2004 10764 $2,286.00
USA Leverling 12/9/2004 10765 $1,515.60
USA Peacock 12/9/2004 10766 $2,310.00
USA Peacock ### 10767 $28.00
USA Leverling ### 10768 $1,477.00
USA Leverling ### 10769 $1,684.27
USA Callahan ### 10770 $236.25
UK Dodsworth 1/2/2004 10771 $344.00
USA Leverling ### 10772 $3,603.22
USA Davolio ### 10773 $2,030.40
USA Peacock ### 10774 $868.75
UK King ### 10775 $228.00
USA Davolio ### 10776 $6,635.27
UK King 1/21/2005 10777 $224.00
USA Leverling ### 10778 $96.50
USA Leverling 1/14/2005 10779 $1,335.00
USA Fuller ### 10780 $720.00
USA Fuller ### 10781 $975.88
UK Dodsworth ### 10782 $12.50
USA Peacock ### 10783 $1,442.50
USA Peacock ### 10784 $1,488.00
USA Davolio ### 10785 $387.50
USA Callahan ### 10786 $1,531.08
USA Fuller ### 10787 $2,622.76
USA Davolio 1/19/2005 10788 $731.50
USA Davolio ### 10789 $3,687.00
UK Suyama ### 10790 $722.50
UK Suyama 1/1/2005 10791 $1,829.76
USA Davolio ### 10792 $399.85
USA Leverling 1/8/2005 10793 $191.10
UK Suyama 1/2/2005 10794 $314.76
USA Callahan 1/20/2005 10795 $2,158.00
USA Leverling 1/14/2005 10796 $2,341.36
UK King 1/5/2005 10797 $420.00
USA Fuller 1/5/2005 10798 $446.60
UK Dodsworth 1/5/2005 10799 $1,553.50
USA Davolio 1/5/2005 10800 $1,468.93
USA Peacock ### 10801 $3,026.85
USA Peacock 1/2/2005 10802 $2,942.81
USA Peacock 1/6/2005 10803 $1,193.01
UK Suyama 1/7/2005 10804 $2,278.40

Page 45
Salesperson Reports Sample Workbook Source Data

USA Fuller 1/9/2005 10805 $2,775.00

USA Leverling 1/5/2005 10806 $439.60
USA Peacock 1/30/2005 10807 $18.40
USA Fuller 1/9/2005 10808 $1,411.00
UK King 1/7/2005 10809 $140.00
USA Fuller 1/7/2005 10810 $187.00
USA Callahan 1/8/2005 10811 $852.00
UK Buchanan 1/12/2005 10812 $1,692.80
USA Davolio 1/9/2005 10813 $602.40
USA Leverling 1/14/2005 10814 $1,788.45
USA Fuller 1/14/2005 10815 $40.00
USA Peacock 2/4/2005 10816 $8,446.45
USA Leverling 1/13/2005 10817 $10,952.84
UK King 1/12/2005 10818 $833.00
USA Fuller 1/16/2005 10819 $477.00
USA Leverling 1/13/2005 10820 $1,140.00
USA Davolio 1/15/2005 10821 $678.00
UK Suyama 1/16/2005 10822 $237.90
UK Buchanan 1/13/2005 10823 $2,826.00
USA Callahan 1/30/2005 10824 $250.80
USA Davolio 1/14/2005 10825 $1,030.76
UK Suyama 2/6/2005 10826 $730.00
USA Davolio 2/6/2005 10827 $843.00
UK Dodsworth 2/4/2005 10828 $932.00
UK Dodsworth 1/23/2005 10829 $1,764.00
USA Peacock 1/21/2005 10830 $1,974.00
USA Leverling 1/23/2005 10831 $2,684.40
USA Fuller 1/19/2005 10832 $475.11
UK Suyama 1/23/2005 10833 $906.93
USA Davolio 1/19/2005 10834 $1,432.71
USA Davolio 1/21/2005 10835 $845.80
UK King 1/21/2005 10836 $4,705.50
UK Dodsworth 1/23/2005 10837 $1,064.50
USA Leverling 1/23/2005 10838 $1,938.38
USA Leverling 1/22/2005 10839 $827.55
USA Peacock 2/16/2005 10840 $211.20
UK Buchanan 1/29/2005 10841 $4,581.00
USA Davolio 1/29/2005 10842 $975.00
USA Peacock 1/26/2005 10843 $159.00
USA Callahan 1/26/2005 10844 $735.00
USA Callahan 1/30/2005 10845 $3,812.70
USA Fuller 1/23/2005 10846 $1,112.00
USA Peacock 2/10/2005 10847 $4,931.92
UK King 1/29/2005 10848 $931.50
UK Dodsworth 1/30/2005 10849 $967.82
USA Davolio 1/30/2005 10850 $629.00
UK Buchanan 2/2/2005 10851 $2,603.00
USA Callahan 1/30/2005 10852 $2,984.00
UK Dodsworth 2/3/2005 10853 $625.00
USA Leverling 2/5/2005 10854 $2,966.50
USA Leverling 2/4/2005 10855 $2,227.89
USA Leverling 2/10/2005 10856 $660.00
USA Callahan 2/6/2005 10857 $2,048.22
USA Fuller 2/3/2005 10858 $649.00
USA Davolio 2/2/2005 10859 $1,078.69
USA Leverling 2/4/2005 10860 $519.00
USA Peacock 2/17/2005 10861 $3,523.40
USA Callahan 2/2/2005 10862 $581.00
USA Peacock 2/17/2005 10863 $441.15
USA Peacock 2/9/2005 10864 $282.00
USA Fuller 2/12/2005 10865 $16,387.50
UK Buchanan 2/12/2005 10866 $1,096.20

Page 46
Salesperson Reports Sample Workbook Source Data

UK Suyama 2/11/2005 10867 $98.40

UK King 2/23/2005 10868 $1,920.60
UK Buchanan 2/9/2005 10869 $1,630.00
UK Buchanan 2/13/2005 10870 $160.00
UK Dodsworth 2/10/2005 10871 $1,979.23
UK Buchanan 2/9/2005 10872 $2,058.46
USA Peacock 2/9/2005 10873 $336.80
UK Buchanan 2/11/2005 10874 $310.00
USA Peacock 3/3/2005 10875 $709.55
UK King 2/12/2005 10876 $917.00
USA Davolio 2/19/2005 10877 $1,955.13
USA Peacock 2/12/2005 10878 $1,539.00
USA Leverling 2/12/2005 10879 $611.30
UK King 2/18/2005 10880 $1,500.00
USA Peacock 2/18/2005 10881 $150.00
USA Peacock 2/20/2005 10882 $892.64
USA Callahan 2/20/2005 10883 $36.00
USA Peacock 2/13/2005 10884 $1,378.07
UK Suyama 2/18/2005 10885 $1,209.00
USA Davolio 3/2/2005 10886 $3,127.50
USA Callahan 2/16/2005 10887 $70.00
USA Davolio 2/23/2005 10888 $605.00
UK Dodsworth 2/23/2005 10889 $11,380.00
UK King 2/18/2005 10890 $860.10
UK King 2/19/2005 10891 $368.93
USA Peacock 2/19/2005 10892 $2,090.00
UK Dodsworth 2/20/2005 10893 $5,502.11
USA Davolio 2/20/2005 10894 $2,753.10
USA Leverling 2/23/2005 10895 $6,379.40
UK King 2/27/2005 10896 $750.50
USA Leverling 2/25/2005 10897 $10,835.24
USA Peacock 3/6/2005 10898 $30.00
UK Buchanan 2/26/2005 10899 $122.40
USA Davolio 3/4/2005 10900 $33.75
USA Peacock 2/26/2005 10901 $934.50
USA Davolio 3/3/2005 10902 $863.43
USA Leverling 3/4/2005 10903 $932.05
USA Leverling 2/27/2005 10904 $1,924.25
UK Dodsworth 3/6/2005 10905 $342.00
USA Peacock 3/3/2005 10906 $427.50
UK Suyama 2/27/2005 10907 $108.50
USA Peacock 3/6/2005 10908 $663.10
USA Davolio 3/10/2005 10909 $670.00
USA Davolio 3/4/2005 10910 $452.90
USA Leverling 3/5/2005 10911 $858.00
USA Fuller 3/18/2005 10912 $6,200.55
USA Peacock 3/4/2005 10913 $768.75
UK Suyama 3/2/2005 10914 $537.50
USA Fuller 3/2/2005 10915 $539.50
USA Davolio 3/9/2005 10916 $686.70
USA Peacock 3/11/2005 10917 $365.89
USA Leverling 3/11/2005 10918 $1,447.50
USA Fuller 3/4/2005 10919 $1,122.80
USA Peacock 3/9/2005 10920 $390.00
USA Davolio 3/9/2005 10921 $1,936.00
UK Buchanan 3/5/2005 10922 $742.50
UK King 3/13/2005 10923 $748.80
USA Leverling 4/8/2005 10924 $1,835.70
USA Leverling 3/13/2005 10925 $475.15
USA Peacock 3/11/2005 10926 $514.40
USA Peacock 4/8/2005 10927 $800.00
USA Davolio 3/18/2005 10928 $137.50

Page 47
Salesperson Reports Sample Workbook Source Data

UK Suyama 3/12/2005 10929 $1,174.75

USA Peacock 3/18/2005 10930 $2,255.50
USA Peacock 3/19/2005 10931 $799.20
USA Callahan 3/24/2005 10932 $1,788.63
UK Suyama 3/16/2005 10933 $920.60
USA Leverling 3/12/2005 10934 $500.00
USA Peacock 3/18/2005 10935 $619.50
USA Leverling 3/18/2005 10936 $456.00
UK King 3/13/2005 10937 $644.80
USA Leverling 3/16/2005 10938 $2,731.87
USA Fuller 3/13/2005 10939 $637.50
USA Callahan 3/23/2005 10940 $360.00
UK King 3/20/2005 10941 $4,011.75
UK Dodsworth 3/18/2005 10942 $560.00
USA Peacock 3/19/2005 10943 $711.00
UK Suyama 3/13/2005 10944 $1,025.33
USA Peacock 3/18/2005 10945 $245.00
USA Davolio 3/19/2005 10946 $1,407.50
USA Leverling 3/16/2005 10947 $220.00
USA Leverling 3/19/2005 10948 $2,362.25
USA Fuller 3/17/2005 10949 $4,422.00
USA Davolio 3/23/2005 10950 $110.00
UK Dodsworth 4/7/2005 10951 $458.74
USA Davolio 3/24/2005 10952 $471.20
UK Dodsworth 3/25/2005 10953 $4,441.25
UK Buchanan 3/20/2005 10954 $1,659.53
USA Callahan 3/20/2005 10955 $74.40
UK Suyama 3/20/2005 10956 $677.00
USA Callahan 3/27/2005 10957 $1,762.70
UK King 3/27/2005 10958 $781.00
UK Suyama 3/23/2005 10959 $131.75
USA Leverling 4/8/2005 10960 $265.35
USA Callahan 3/30/2005 10961 $1,119.90
USA Callahan 3/23/2005 10962 $3,584.00
UK Dodsworth 3/26/2005 10963 $57.80
USA Leverling 3/24/2005 10964 $2,052.50
UK Suyama 3/30/2005 10965 $848.00
USA Peacock 4/8/2005 10966 $1,098.46
USA Fuller 4/2/2005 10967 $910.40
USA Davolio 4/1/2005 10968 $1,408.00
USA Davolio 3/30/2005 10969 $108.00
UK Dodsworth 4/24/2005 10970 $224.00
USA Fuller 4/2/2005 10971 $1,733.06
USA Peacock 3/26/2005 10972 $251.50
UK Suyama 3/27/2005 10973 $291.55
USA Leverling 4/3/2005 10974 $439.00
USA Davolio 3/27/2005 10975 $717.50
USA Davolio 4/3/2005 10976 $912.00
USA Callahan 4/10/2005 10977 $2,233.00
UK Dodsworth 4/23/2005 10978 $1,303.19
USA Callahan 3/31/2005 10979 $4,813.50
USA Peacock 4/17/2005 10980 $248.00
USA Davolio 4/2/2005 10981 $15,810.00
USA Fuller 4/8/2005 10982 $1,014.00
USA Fuller 4/6/2005 10983 $720.90
USA Davolio 4/3/2005 10984 $1,809.75
USA Fuller 4/2/2005 10985 $2,023.38
USA Callahan 4/21/2005 10986 $2,220.00
USA Callahan 4/6/2005 10987 $2,772.00
USA Leverling 4/10/2005 10988 $3,574.80
USA Fuller 4/2/2005 10989 $1,353.60
USA Fuller 4/7/2005 10990 $4,288.85

Page 48
Salesperson Reports Sample Workbook Source Data

USA Davolio 4/7/2005 10991 $2,296.00

USA Davolio 4/3/2005 10992 $69.60
UK King 4/10/2005 10993 $4,895.44
USA Fuller 4/9/2005 10994 $940.50
USA Davolio 4/6/2005 10995 $1,196.00
USA Peacock 4/10/2005 10996 $560.00
USA Callahan 4/13/2005 10997 $1,885.00
USA Callahan 4/17/2005 10998 $686.00
UK Suyama 4/10/2005 10999 $1,197.95
USA Fuller 4/14/2005 11000 $903.75
USA Fuller 4/14/2005 11001 $2,769.00
USA Peacock 4/16/2005 11002 $1,811.10
USA Leverling 4/8/2005 11003 $326.00
USA Leverling 4/20/2005 11004 $295.38
USA Fuller 4/10/2005 11005 $586.00
USA Leverling 4/15/2005 11006 $329.69
USA Callahan 4/13/2005 11007 $2,633.90
USA Fuller 4/10/2005 11009 $616.50
USA Fuller 4/21/2005 11010 $645.00
USA Leverling 4/13/2005 11011 $933.50
USA Davolio 4/17/2005 11012 $2,825.30
USA Fuller 4/10/2005 11013 $361.00
USA Fuller 4/15/2005 11014 $243.18
USA Fuller 4/20/2005 11015 $622.35
UK Dodsworth 4/13/2005 11016 $491.50
UK Dodsworth 4/20/2005 11017 $6,750.00
USA Peacock 4/16/2005 11018 $1,575.00
USA Fuller 4/16/2005 11020 $632.40
USA Leverling 4/21/2005 11021 $6,306.24
USA Davolio 4/24/2005 11023 $1,500.00
USA Peacock 4/20/2005 11024 $1,966.81
UK Suyama 4/24/2005 11025 $270.00
USA Peacock 4/28/2005 11026 $1,030.00
USA Davolio 4/20/2005 11027 $877.72
USA Fuller 4/22/2005 11028 $2,160.00
USA Peacock 4/27/2005 11029 $1,286.80
UK King 4/27/2005 11030 $12,615.05
UK Suyama 4/24/2005 11031 $2,393.50
USA Fuller 4/23/2005 11032 $8,902.50
UK King 4/23/2005 11033 $3,232.80
USA Callahan 4/27/2005 11034 $539.40
USA Fuller 4/24/2005 11035 $1,754.50
USA Callahan 4/22/2005 11036 $1,692.00
UK King 4/27/2005 11037 $60.00
USA Davolio 4/30/2005 11038 $732.60
USA Leverling 4/28/2005 11041 $1,773.00
USA Fuller 5/1/2005 11042 $405.75
UK Buchanan 4/29/2005 11043 $210.00
USA Peacock 5/1/2005 11044 $591.60
USA Callahan 4/24/2005 11046 $1,485.80
UK King 5/1/2005 11047 $817.87
UK King 4/30/2005 11048 $525.00
USA Leverling 5/1/2005 11052 $1,332.00
USA Fuller 4/29/2005 11053 $3,055.00
USA Callahan 5/1/2005 11056 $3,740.00
USA Leverling 5/1/2005 11057 $45.00

Page 49
 Employees Database

Last Name Age Department Designation Basic Hra

Chris Poundsworth 48 HR Sr. Manager 29850 2985
Ivan Silberstein 47 Production Sr. Manager 95000 9500
Jeffrey P. Jones 31 Production Executive 42000 4200
Joe Morrison 25 Sales Executive 24000 2400
Richard E. Card 26 HR Manager 43000 4300
Rick Fogerty 24 HR Executive 89873 8987.3
Stephen C. Carter 21 Admin Executive 44123 4412.3
Tom Brown 26 Accounts Executive 65000 6500

Auto Filters

1 Details of All those employees who are in accounts or production Managers

2 Details of all managers who have a ranking above 2
3 Details of all records who are in HR department and rank below 3
4 Details of all records who are ranked between 3 and 7
5 Details of all records who are not ranked between 5 and 8
6 Details of all employees who are production managers or HR Sr. Managers
7 Details of all employees whoes basic salary is between 50000 and 80000
8 Details of all names starting with "R" and are managers
9 Details of all employees who have top 3 rankings
10 Details of all employees who are either managers or gross more than 10,000
 DA Gross Salary Rank
11940 44775 3
38000 142500 10
16800 63000 4
9600 36000 12
17200 64500 3
35949.2 134809.5 9
17649.2 66184.5 10
26000 97500 3

ction Managers

R Sr. Managers
0 and 80000

more than 10,000

 Custom Sorting
Example 1 Example 2

Household Expenses Sr.No Name Dept

14 Rani Accounts
Date Category Method Expense Income Change 8 Rakesh Accounts
01-Jan-01 Income automatic 3000 3000 3 Anil Accounts
03-Jan-01 House automatic 1200 -1200 22 Bhavya Accounts
05-Jan-01 Automobile automatic 500 -500 25 Haridas Accounts
07-Jan-01 Utilities automatic 98.5 -98.5 27 Hiten Accounts
09-Jan-01 Groceries ATM 125 -125 31 Om Accounts
11-Jan-01 Cash ATM 100 -100 11 Kajol Accounts
13-Jan-01 Automobile visa 18.37 -18.37 39 Ravi Accounts
15-Jan-01 Clothing visa 55 -55 13 Jyoti Operations
17-Jan-01 Gifts visa 329 -329 17 Bobby Operations
19-Jan-01 Entertainment visa 98 -98 4 Sunil Operations
21-Jan-01 Professional visa 50 -50 21 Fatima Operations
23-Jan-01 Utilities visa 88 -88 24 Jyothsna Operations
25-Jan-01 Insurance visa 125 -125 30 Pallavi Operations
27-Jan-01 Savings automatic 167 -167 33 Purab Operations
01-Feb-01 Income automatic 3000 3000 5 Ketan Operations
03-Feb-01 House automatic 1200 -1200 37 Gautham Operations
05-Feb-01 Automobile automatic 500 -500 9 Rajesh Purchase
07-Feb-01 Utilities automatic 110 -110 16 Rakhi Purchase
09-Feb-01 Groceries automatic 100 -100 19 Jayesh Purchase
11-Feb-01 Cash ATM 80 -80 7 Nitin Purchase
13-Feb-01 Automobile visa 20 -20 29 Parvati Purchase
15-Feb-01 Clothing visa 25 -25 34 Moksha Purchase
17-Feb-01 Gifts visa 55 -55 36 Abhay Purchase
19-Feb-01 Entertainment visa 40 -40 40 Naved Purchase
21-Feb-01 Professional visa 25 -25 1 Ajay Purchase
23-Feb-01 Utilities visa 70 -70 12 Monika Sales
25-Feb-01 Insurance visa 250 -250 15 Pretham Sales
27-Feb-01 Savings automatic 167 -167 18 Mangesh Sales
01-Mar-01 Income automatic 3000 3000 20 Raju Sales
03-Mar-01 House automatic 1200 -1200 23 Manisha Sales
05-Mar-01 Automobile automatic 500 -500 26 Deepa Sales
07-Mar-01 Utilities automatic 90 -90 2 Vijay Sales
09-Mar-01 Groceries automatic 150 -150 28 Gauri Sales
11-Mar-01 Cash ATM 120 -120 32 Kamal Sales
13-Mar-01 Automobile visa 22 -22 35 Anurag Sales
15-Mar-01 Clothing visa 300 -300 6 Nagraj Sales
17-Mar-01 Gifts visa 39 -39 10 Raja Sales
19-Mar-01 Entertainment visa 75 -75 38 Ansh Sales
21-Mar-01 Professional visa 45 -45
23-Mar-01 Utilities visa 90 -90 Sort the above table according to the list give below :
25-Mar-01 Insurance 1093 85 -85 Vice President
27-Mar-01 Savings automatic 167 -167 Manager
01-Apr-01 Income automatic 3000 3000 Customer Support
03-Apr-01 House automatic 1200 -1200 Executive
05-Apr-01 Automobile automatic 500 -500
07-Apr-01 Utilities automatic 80 -80
09-Apr-01 Groceries automatic 130 -130
11-Apr-01 Cash ATM 60 -60
13-Apr-01 Automobile visa 15 -15 Product Month Sales
15-Apr-01 Clothing visa 40 -40 Paper February 6
17-Apr-01 Gifts visa 88 -88 Pencils August 789
19-Apr-01 Entertainment visa 25 -25 Paper June 789
21-Apr-01 Professional visa 50 -50 Pencils January 789
23-Apr-01 Utilities visa 100 -100 Pens October 1152
25-Apr-01 Insurance visa 125 -125 Pencils February 1200
27-Apr-01 Savings automatic 167 -167 Pens April 1230
01-May-01 Income automatic 3000 3000 Pens March 1235
03-May-01 House automatic 1200 -1200 Paper September 1245
05-May-01 Automobile automatic 500 -500 Pens July 4444
07-May-01 Utilities automatic 70 -70 Pens January 4500
09-May-01 Groceries ATM 110 -110 Pencils May 4562
11-May-01 Cash ATM 80 -80 Paper March 4563
13-May-01 Automobile visa 20 -20 Pencils April 4569
15-May-01 Clothing visa 33 -33
17-May-01 Gifts visa 28 -28
19-May-01 Entertainment visa 75 -75
21-May-01 Professional visa 25 -25
23-May-01 Utilities visa 90 -90
25-May-01 Insurance visa 250 -250
27-May-01 Savings automatic 167 -167
01-Jun-01 Income automatic 3000 3000
03-Jun-01 House automatic 1200 -1200
05-Jun-01 Automobile automatic 500 -500
07-Jun-01 Utilities automatic 80 -80
09-Jun-01 Groceries ATM 125 -125
11-Jun-01 Cash ATM 120 -120
13-Jun-01 Automobile visa 19 -19
15-Jun-01 Clothing visa 85 -85
17-Jun-01 Gifts visa 25 -25
19-Jun-01 Entertainment visa 89 -89
21-Jun-01 Professional automatic 45 -45
23-Jun-01 Utilities automatic 85 -85
25-Jun-01 Insurance automatic 85 -85
27-Jun-01 Savings automatic 167 -167

1 Sort Table on category given below

Professional
Utilities
Insurance
Savings

2 Sort table on Method given Below

visa
automatic
ATM

Column Sorting
Example 1
1996 1996 1996 1997 1997 1997 1998 1998 1998
company Sales Net Profit EPS Sales Net Profit EPS Sales Net Profit EPS
A 89 59 56 2 38 15 100 83 73
B 28 93 76 86 30 6 47 54 8
C 6 20 48 25 46 60 71 77 4
D 62 1 64 63 31 86 54 30 1
E 33 47 28 22 75 46 26 69 44

Present the data shown above in the following format

1999 1998 1997 1996 1999 1998 1997 1996 1999
company Sales Sales Sales Sales Net Profit Net Profit Net Profit Net Profit EPS
A 65 100 2 89 61 83 38 59 90
B 39 47 86 28 64 54 30 93 71
C 5 71 25 6 97 77 46 20 5
D 93 54 63 62 95 30 31 1 40
E 1 26 22 33 51 69 75 47 81
 Desgination Basic sal
Customer Support 2500
Customer Support 3200
Customer Support 4000
Customer Support 4100
Customer Support 4700
Customer Support 5100
Customer Support 5900
Customer Support 6500
Customer Support 7500
Vice President 2300
Vice President 3100
Manager 3500
Vice President 3900
Vice President 4500
Vice President 5700
Vice President 6300
Vice President 6500
Vice President 7100
Manager 2500
Executive 2900
Manager 3500
Executive 4000
Manager 5500
Manager 6500
Manager 6900
Manager 7700
Manager 8000
Manager 2100
Manager 2700
Executive 3300
Executive 3700
Executive 4300
Manager 4900
Executive 5000
Executive 5300
Manager 6100
Executive 6700
Manager 7000
Executive 7000
Executive 7300

according to the list give below :

1999 1999 1999
Sales Net Profit EPS
65 61 90
39 64 71
5 97 5
93 95 40
1 51 81

1998 1997 1996

EPS EPS EPS
73 15 56
8 6 76
4 60 48
1 86 64
44 46 28
Student Score
Rhea Madsen 69
Jennifer Mendez 81 Total Number of Students
Brett Broyles A Appreared
Shirley Smith 28 Absent
John Brown 93 Withheld
Michael G. Welch A Pass
Donald Tse 100 Fail
Madeline Stevens
Howard Porter 86
Helen Craven 81
Lillie Schultz A Count ---> Count Numbers
Emily Li 80 CountA ---> Count Numbers & Text
Michael Long 71 CountBlank ---> Count Blank cells
Chris Herrman 88 CountIF ---> Count on condition
Marshall Sherman
William Grindle 82
Pauline Haun 85
Lydia J. Evans A
James Weaver 80
Barbara Billings 77
William Hernandez
Robert Griffin 90
Pearl Mendez A
Kevin Trujillo 62
Employee_code First_name Last_name SSN Region Department
S029 Mickey Anderson 628-76-6529 South Accounts
S034 Kelly Ryan 133-30-3940 West Accounts
S039 Donald Lee 816-17-8291 North Accounts
S044 Zachary Taylor 856-85-6910 East Accounts
S049 Mark Fulkerson 133-30-3861 South Accounts
S054 William Tate 189-85-4910 West Accounts
S059 Debbie Marks 421-40-2831 North Accounts
S064 Melinda Taylor 785-48-2491 East Accounts
S069 Mary Fulkerson 799-74-8097 South Accounts
S073 Rebecca Kiln 856-29-8586 South Marketing
S077 Kendra Pecks 076-10-3383 South Sales
Human
S081 Maureen Carroll 784-23-7193 South resources
S085 Mark Morrison 043-27-6267 South Administration
S089 Aiden Owens 213-71-4547 South Accounts
S093 Joe Robertson 058-49-1739 South Marketing
S097 Thomas Gable 785-48-2931 South Sales
Human
S101 James Thomas 631-38-3711 South resources
S105 Mary Goldstein 816-17-7191 South Administration
S030 Lila Owens 476-20-4792 West Administration
S035 Lisa Ryan 631-20-3941 North Administration
S040 Simon Goldstein 799-70-5719 East Administration
S045 Tina Adams 591-61-8906 South Administration
S050 Kaylen Knapp 639-39-3139 West Administration
S055 Spencer Morgan 389-10-7124 North Administration
S060 Denise Ryan 729-49-1739 East Administration
S065 James Adams 720-92-7216 South Administration
S070 Rita Knapp 336-68-4267 West Administration
S074 Cynthia Tate 291-73-8906 West Accounts
S078 Kevin Johnson 027-76-8856 West Marketing
S082 Stuart James 022-38-3389 West Sales
Human
S086 Kaylen O'Connor 712-35-4005 West resources
S090 William Carter 175-21-4107 West Administration
S094 Carla Anderson 019-26-9428 West Accounts
S098 Ryan Miller 724-92-8094 West Marketing
S102 Roger Van Hof 501-16-1748 West Sales
Human
S106 Rita Perry 790-70-5719 West resources
S200 Stuart Ryan 882-17-3314 East Administration
S028 Michael Robertson 519-26-9428 East Marketing
S033 Mary Miller 784-62-8371 South Marketing
S038 Mickey Thomas 712-35-2971 West Marketing
S043 Jessica Roberts 391-71-3710 North Marketing
S048 Luke Linden 784-50-2831 East Marketing
S053 Aiden Kiln 712-35-8120 South Marketing
S058 Carla Johnson 212-21-2121 West Marketing
S063 Shannon Kelly 719-20-4792 North Marketing
S068 Melissa Linden 816-17-3314 East Marketing
S072 Paul Hope 519-98-7549 East Sales
Human
S076 Sandra Dungen 986-03-5705 East resources
S080 Jamie Ryan 785-87-4619 East Administration

141000

###
Earnings Start_date age rating
$45,000.00 01-Aug-2000 32 4 Derive Functions for the following Querie
$32,000.00 01-Jan-2001 25 5
$32,000.00 01-Jun-2001 44 10 Practice 1
$32,000.00 01-Nov-2001 26 4
$32,000.00 01-Apr-2002 43 9 1. Total Earnings for South Region
$32,000.00 01-Sep-2002 36 4 2. Average ratings for all Accounts depar
$32,000.00 01-Feb-2003 35 1 3. Number of employees who have scored
$32,000.00 01-Jul-2003 30 3 4. Average age of all employees except fo
$32,000.00 01-Dec-2003 35 1 5. total earnings for all employees excep
$32,000.00 01-Apr-2004 20 8 6. Number of employees from Ease region
$32,000.00 01-Aug-2004 38 5
$32,000.00 01-Dec-2004 40 9
$32,000.00 01-Apr-2005 36 4 Practice 2
$32,000.00 01-Aug-2005 21 3
$32,000.00 01-Dec-2005 35 6 1. Total earnings for South Human Resou
$32,000.00 10-Apr-1998 44 1 2. Average age of all marketting employe
$32,000.00 10-Aug-1998 27 2 3. Total earnings of all adminstrators of a
$32,000.00 10-Dec-1998 38 7 4. Total number of employees above the
$34,000.00 01-Sep-2000 25 10 5. Total Number of employees from sale
$34,000.00 01-Feb-2001 41 9
$34,000.00 01-Jul-2001 23 6
$34,000.00 01-Dec-2001 34 1
$34,000.00 01-May-2002 31 8
$34,000.00 01-Oct-2002 40 8
$34,000.00 01-Mar-2003 35 5
$34,000.00 01-Aug-2003 39 8
$34,000.00 01-Jan-2004 38 10
$34,000.00 01-May-2004 20 8
$34,000.00 01-Sep-2004 42 1
$34,000.00 01-Jan-2005 29 2
$34,000.00 01-May-2005 37 9
$34,000.00 01-Sep-2005 45 3
$34,000.00 10-Jan-1998 37 2
$34,000.00 10-May-1998 40 3
$34,000.00 10-Sep-1998 33 9
$34,000.00 10-Jan-1999 35 10
$34,000.00 23-Dec-1998 40 1
$45,000.00 01-Jul-2000 22 2
$45,000.00 01-Dec-2000 32 8
$45,000.00 01-May-2001 29 10
$45,000.00 01-Oct-2001 43 2
$45,000.00 01-Mar-2002 32 9
$45,000.00 01-Aug-2002 27 1
$45,000.00 01-Jan-2003 27 2
$45,000.00 01-Jun-2003 34 3
$45,000.00 01-Nov-2003 38 2
$45,000.00 01-Mar-2004 25 6
$45,000.00 01-Jul-2004 35 7
$45,000.00 01-Nov-2004 38 3
 he following Queries:

South Region 555000

all Accounts department employ 4.5
ees who have scored more than 8 11
employees except for South Regi 33.6363636
all employees except Sales depa 1598000
es from Ease region 11

South Human Resources only 64000

marketting employees from South Region 28.5
l adminstrators of all region except East 336000
mployees above the age of 35 who have a ra 8
mployees from sales department who do not 3

column criteria
single single sumif, countif,averageif
mult single sumifs,countifs,averagif
mult/sinmult database functions
dcount,dsum,dmax……..
Using SUMIF,evaluate the following:

InvoiceNum Office Amount DateDue Today Difference

AG-0145 Oregon ### 2-Apr 6-May -34
AG-0189 California $450.00 20-Apr 6-May -16
AG-0220 Washington ### 29-Apr 6-May -7
AG-0310 Oregon $250.00 1-May 6-May -5
AG-0355 Washington $125.50 5-May 6-May -1
AG-0409 Washington ### 11-May 6-May 5
AG-0581 Oregon ### 24-May 6-May 18
AG-0600 Oregon $335.39 24-May 6-May 18
AG-0602 Washington $65.00 29-May 6-May 23
AG-0633 California $250.00 31-May 6-May 25

TOTAL

Total no of days past due days -63

Total amount past due days 9037

Total amount for Oregon only 7685

Total amount for all except Oregon 7102

Total amount with due date beyond Ap 6125

 Syrup Production

Maple Age Diameter Taps Production

Tree
Black 65 12 1 15
Silver 35 18 1 12
Sugar 75 15 1 18
Black 115 22 2 32
Silver 70 28 2 20
Sugar 125 25 2 35
Black 160 33 3 40
Silver 90 38 3 33
Sugar 175 35 3 45

Use Database functions to furnish the details

1. Total Diameter for Black trees age greater than 100 55

2. Number of sugar and silver trees with a diameter mor 4
3. Maximum production between sugar and silver trees a 45
4. Total production from blank trees 87
5. Product of production from blank and silver trees 1.52E+08
6. Minimum no. of taps for all trees age ranging between 2
Parties Seats
ABD $70.00
SDD $20.00
JHH $10.00

Total $100.00

10%

20%

70%

Car 1 Car2 15
X T X T
10
(m) (s) (m) (s)
12 2 9 3 5
24 4 18 6
36 6 27 9 0
48 8 36 12 0 10 20 30 40 50 60 70 80
60 10 45 15
Car # 1
72 12 54 18
 0
0 10 20 30 40 50 60 70 80
Car # 1

Poistion, X (s)Time, t (s)

0 0
2 1
4 2
6 3
8 4
8 5
8 6
8 7
6 8
4 9
2 10
0 11

qrt1 qrt2 qrt3 qrt4 Percentage

East 746 373 281 298 100
West 930 767 42 744 95
North 727 375 110 701 89
South 409 812 677 954 99
 1 100 95 89 99
0.8 Percentage
0.6 qrt4
0.4 qrt3
0.2 qrt2
0 qrt1

a st est rth uth

E W N o So
Chart Data 1 Chart Data 2
Who will win ODI 2009 ? Sale - Profit
Australia England Draw Item Sale Profit
4352 3241 231 Nokia 2342 43
Sony 4323 23
Chart Data 3 Moto 3242 54
Sales Analysis Samsun 2533 63
Jan Feb Mar
Bajaj 23 54 76
Honda 45 56 87
Tvs 67 24 76
Chart Data 6
Sale By State
Chart Data 4 State Year 20 Year 20 Year 2009
Revenue From Gasoline & Petrol Kerala 250 300 450
Year 2007 Year 2008 Karnata 200 250 400
2343 4324 Andhra 150 170 300
3243 4556 Tamil N 100 110 200
Chart Data 5
Employee Performance
Target Achieved
50 45
50 34
50 46
50 50
50 51
50 49
50 48

Chart Data 7
Temperature
Time Temp Predicted Temp
13:00 23.1 23.1
13:15 24.5 23.5
13:30 26.1 23.9
13:45 23.4 24.3
14:00 23.8 24.7
14:15 28.5 25.1
14:30 25.3 25.5
14:45 26.9 25.9
 15:00 24.3 26.3

Chart Data 7
Wicket Fall
India Newzeland
23 32
45 54
67 76
89 98
123 123
156 145
190 178
213 211
244 234
276 267
Year 2009
 Income is Tax Rate
Enter Income: $21,566 Greater Than $0
or 15.00%
The Tax Rate is: $2,651
Equal To… 28.00%
$27,301 31.00%
$58,501 36.00%
$131,801 39.60%
$284,701 45.25%
Note: This is set up to work with whole numbers only (no decimals).

Problem2

Date: 1/19/2003 Date Weekday Amount

Amount: 1/1/2003 Wednesday 23
1/2/2003 Thursday 179
1/3/2003 Friday 149
1/4/2003 Saturday 196
1/5/2003 Sunday 131
1/6/2003 Monday 179
1/7/2003 Tuesday 134
1/8/2003 Wednesday 179
1/9/2003 Thursday 193
1/10/2003 Friday 191
1/11/2003 Saturday 176
1/12/2003 Sunday 189
1/13/2003 Monday 163
1/14/2003 Tuesday 121
1/15/2003 Wednesday 100
1/16/2003 Thursday 109
1/17/2003 Friday 151
1/18/2003 Saturday 138
1/19/2003 Sunday 114
1/20/2003 Monday 156

Problem3
Comm.
Sales Rep Years Sales Rate Commission <3 Years Tenure 3+ Years Tenure
Benson 2 120,000 0 Amt Sold Rate Amt Sold
Davidson 1 210,921 0 0 1.50% 0
Ellison 1 100,000 0 5,000 3.25% 50,000
Gomez 2 87,401 0 10,000 3.50% 100,000
Hernandez 6 310,983 0 20,000 5.00% 200,000
Kelly 3 43,902 0 50,000 6.00% 300,000
Martin 2 121,021 0 100,000 7.00% 500,000
Oswald 3 908 0 250,000 8.00%
Reginald 1 0 0
Veras 4 359,832 0
Wilmington 4 502,983 0

Problem4

Student Score Grade Score Grade

Adams 36 0 F
Baker 68 40 D
Camden 50 70 C
Dailey 77 80 B
Gomez 92 90 A
Hernandez 100
Jackson 74
Maplethorpe 45
Paulson 60
Ramirez 89
Sosa 99
Thompson 91
Wilson 59

Problem5

Price
Product Size Price shirt medium
Shirt Medium 22.00
Shirt Large 24.00
Jacket Medium 60.00
Jacket Large 65.00

Problem6

Student Data
Ann 9,101 Target Value --> 8025
Betsy 8,873
Chuck 6,000
David 9,820 Student:
George 10,500
Hilda 3,500
James 12,873
John 5,867
Keith 8,989
Leslie 8,000
Michelle 1,124
Nora 9,099
Paul 6,800
Peter 5,509
Rasmusen 5,460
Sally 8,400
Theresa 7,777
Violet 3,600
Wendy 5,400
3+ Years Tenure
Rate
2.00%
6.25%
7.25%
8.25%
9.25%
10.00%
List1 Eric Nancy Ana Stephan Steps
Gross Salary 2540 3258 3854 3285 1] Create three tables
Income Tax 381 488 578 493 2] Keep cell in the first table (List1)
Social Security 127 183 193 164 3] Press Ctrl Shift *
401K 78 98 116 99 4] Goto Insert - Name- Define
5] Define Name as List1
List2 Ana Nancy John Eric Lee 6] Repeat the step 2,3,4,5 for 2 other table (List1, List2)
Gross Salary 3758 3125 3528 2758 1552 7] Goto a blank sheet
Income Tax 564 469 529 414 233 8] Goto Data - Consolidate
Social Security 188 158 176 138 78 9] Add the name defined List1,List2,List3 in references
Other Deductio 100 50 25 35 25 10] Select top Raw and Left Column
401K 113 94 106 83 47 11] Click on Ok

List3 John Stephen Eric Nancy

Gross Salary 3541 2965 2999 3125
Income Tax 652 495 425 499
Social Security 181 148 150 142
401K 126 93 90 92
Country SalespersOrder DatOrderID Order Amount Practice 1
UK Buchanan ### 10248 $440.00
UK Suyama ### 10249 ### 1. Maximum and Minimum Order Amount for each country , sales person wise
USA Peacock ### 10250 ### 2. Total number of order per country, sales person wise
USA Leverling ### 10251 $654.06 3. Average amount for each country
USA Peacock ### 10252 ### 4. Total order amount for peacock only
USA Leverling ### 10253 ### 5. Who has made the maximum sales in UK
UK Buchanan ### 10254 $556.62 6. Which salesperson has made the highest sales
UK Dodsworth ### 10255 ### 7. which country has made the more number of sales
USA Leverling ### 10256 $517.80 8. What is the total sales for each country
USA Peacock ### 10257 ### 9. Top 2 sales persons who has made the highest sales in all countries
USA Davolio ### 10258 ###
USA Peacock ### 10259 $100.80
USA Peacock ### 10260 ### Practice 2
USA Peacock ### 10261 $448.00
USA Callahan ### 10262 $584.00 1. Total sales made by each country quarter wise
UK Dodsworth ### 10263 ### 2. Average sales of sales persons year wise
UK Suyama ### 10264 $695.62 3. Monthly sales report of all the sales persons
USA Fuller ### 10265 ###
USA Leverling ### 10266 $346.56
USA Peacock 8/6/2003 10267 ###
USA Callahan 8/2/2003 10268 ###
UK Buchanan 8/9/2003 10269 $642.20
USA Davolio 8/2/2003 10270 ###
UK Suyama ### 10271 $48.00
UK Suyama 8/6/2003 10272 ###
USA Leverling ### 10273 ###
UK Suyama ### 10274 $538.60
USA Davolio 8/9/2003 10275 $291.84
USA Callahan ### 10276 $420.00
USA Fuller ### 10277 ###
USA Callahan ### 10278 ###
USA Callahan ### 10279 $351.00
USA Fuller ### 10280 $613.20
USA Peacock ### 10281 $86.50
USA Peacock ### 10282 $155.40
USA Leverling ### 10283 ###
USA Peacock ### 10284 ###
USA Davolio ### 10285 ###
USA Callahan ### 10286 ###
USA Callahan ### 10287 $819.00
USA Peacock 9/3/2003 10288 $80.10
UK King ### 10289 $479.40
USA Callahan 9/3/2003 10290 ###
UK Suyama 9/4/2003 10291 $497.52
USA Davolio 9/2/2003 10292 ###
USA Davolio ### 10293 $848.70
USA Peacock 9/5/2003 10294 ###
USA Fuller ### 10295 $121.60
UK Suyama ### 10296 ###
UK Buchanan ### 10297 ###
UK Suyama ### 10298 ###
USA Peacock ### 10299 $349.50
USA Fuller ### 10300 $608.00
USA Callahan ### 10301 $755.00
USA Peacock ### 10302 ###
UK King ### 10303 ###
USA Davolio ### 10304 $954.40
USA Callahan ### 10305 ###
USA Davolio ### 10306 $498.50
USA Fuller ### 10307 $424.00
UK King ### 10308 $88.80
USA Leverling ### 10309 ###
USA Callahan ### 10310 $336.00
USA Davolio ### 10311 $268.80
USA Fuller ### 10312 ###
USA Fuller ### 10313 $182.40
USA Davolio ### 10314 ###
USA Peacock ### 10315 $516.80
USA Davolio ### 10316 ###
UK Suyama ### 10317 $288.00
USA Callahan ### 10318 $240.40
UK King ### 10319 ###
UK Buchanan ### 10320 $516.00
USA Leverling ### 10321 $144.00
UK King ### 10322 $112.00
USA Peacock ### 10323 $164.40
UK Dodsworth ### 10324 ###
USA Davolio ### 10325 ###
USA Peacock ### 10326 $982.00
USA Fuller ### 10327 ###
USA Peacock ### 10328 ###
USA Peacock ### 10329 ###
USA Leverling ### 10330 ###
UK Dodsworth ### 10331 $88.50
USA Leverling ### 10332 ###
UK Buchanan ### 10333 $877.20
USA Callahan ### 10334 $144.80
UK King ### 10335 ###
UK King ### 10336 $285.12
USA Peacock ### 10337 ###
USA Peacock ### 10338 $934.50
USA Fuller ### 10339 ###
USA Davolio ### 10340 ###
UK King ### 10341 $352.60
USA Peacock ### 10342 ###
USA Peacock ### 10343 ###
USA Peacock ### 10344 ###
USA Fuller ### 10345 ###
USA Leverling ### 10346 ###
USA Peacock ### 10347 $814.42
USA Peacock ### 10348 $363.60
UK King ### 10349 $141.60
UK Suyama ### 10350 $642.06
USA Davolio ### 10351 ###
USA Leverling ### 10352 $136.30
UK King ### 10353 ###
USA Callahan ### 10354 $568.80
UK Suyama ### 10355 $480.00
UK Suyama ### 10356 ###
USA Davolio ### 10357 ###
UK Buchanan ### 10358 $429.40
UK Buchanan ### 10359 ###
USA Peacock ### 10360 ###
USA Davolio ### 10361 ###
USA Leverling ### 10362 ###
USA Peacock ### 10363 $447.20
USA Davolio ### 10364 $950.00
USA Leverling ### 10365 $403.20
USA Callahan ### 10366 $136.00
UK King ### 10367 $834.20
USA Fuller ### 10368 ###
USA Callahan ### 10369 ###
UK Suyama ### 10370 ###
USA Davolio ### 10371 $72.96
UK Buchanan ### 10372 ###
USA Peacock ### 10373 ###
USA Davolio ### 10374 $459.00
USA Leverling ### 10375 $338.00
USA Davolio ### 10376 $399.00
USA Davolio ### 10377 $863.60
UK Buchanan ### 10378 $103.20
USA Fuller ### 10379 $863.28
USA Callahan ### 10380 ###
USA Leverling ### 10381 $112.00
USA Peacock ### 10382 ###
USA Callahan ### 10383 $899.00
USA Leverling ### 10384 ###
USA Davolio ### 10385 $691.20
UK Dodsworth ### 10386 $166.00
USA Davolio ### 10387 ###
USA Fuller ### 10388 ###
USA Peacock ### 10389 ###
UK Suyama ### 10390 ###
USA Leverling ### 10391 $86.40
USA Fuller 1/1/2004 10392 ###
USA Davolio 1/3/2004 10393 ###
USA Davolio 1/3/2004 10394 $442.00
UK Suyama 1/3/2004 10395 ###
USA Davolio 1/6/2004 10396 ###
UK Buchanan 1/2/2004 10397 $716.72
USA Fuller 1/9/2004 10398 ###
USA Callahan 1/8/2004 10399 ###
USA Davolio ### 10400 ###
USA Davolio ### 10401 ###
USA Callahan ### 10402 ###
USA Peacock 1/9/2004 10403 $855.01
USA Fuller 1/8/2004 10404 ###
USA Davolio ### 10405 $400.00
UK King ### 10406 ###
USA Fuller ### 10407 ###
USA Callahan ### 10408 ###
USA Leverling ### 10409 $319.20
USA Leverling ### 10410 $802.00
UK Dodsworth ### 10411 $966.80
USA Callahan ### 10412 $334.80
USA Leverling ### 10413 ###
USA Fuller ### 10414 $224.83
USA Leverling ### 10415 $102.40
USA Callahan ### 10416 $720.00
USA Peacock ### 10417 ###
USA Peacock ### 10418 ###
USA Peacock ### 10419 ###
USA Leverling ### 10420 ###
USA Callahan ### 10421 ###
USA Fuller ### 10422 $49.80
UK Suyama ### 10423 ###
UK King ### 10424 ###
UK Suyama ### 10425 $360.00
USA Peacock 2/6/2004 10426 $338.20
USA Peacock 3/3/2004 10427 $651.00
UK King 2/4/2004 10428 $192.00
USA Leverling 2/7/2004 10429 ###
USA Peacock 2/3/2004 10430 ###
USA Peacock 2/7/2004 10431 ###
USA Leverling 2/7/2004 10432 $485.00
USA Leverling 3/4/2004 10433 $851.20
USA Leverling ### 10434 $321.12
USA Callahan 2/7/2004 10435 $631.60
USA Leverling ### 10436 ###
USA Callahan ### 10437 $393.00
USA Leverling ### 10438 $454.00
UK Suyama ### 10439 ###
USA Peacock ### 10440 ###
USA Leverling ### 10441 ###
USA Leverling ### 10442 ###
USA Callahan ### 10443 $517.44
USA Leverling ### 10444 ###
USA Leverling ### 10445 $174.90
UK Suyama ### 10446 $246.24
USA Peacock 3/7/2004 10447 $914.40
USA Peacock ### 10448 $443.40
USA Leverling ### 10449 ###
USA Callahan ### 10450 $425.12
USA Peacock ### 10451 ###
USA Callahan ### 10452 ###
USA Davolio ### 10453 $407.70
USA Peacock ### 10454 $331.20
USA Callahan 3/3/2004 10455 ###
USA Callahan ### 10456 $557.60
USA Fuller 3/3/2004 10457 ###
UK King 3/4/2004 10458 ###
USA Peacock ### 10459 ###
USA Callahan 3/3/2004 10460 $176.10
USA Davolio 3/5/2004 10461 ###
USA Fuller ### 10462 $156.00
UK Buchanan 3/6/2004 10463 $713.30
USA Peacock ### 10464 ###
USA Davolio ### 10465 ###
USA Peacock ### 10466 $216.00
USA Callahan ### 10467 $235.20
USA Leverling ### 10468 $717.60
USA Davolio ### 10469 $956.67
USA Peacock ### 10470 ###
USA Fuller ### 10471 ###
USA Callahan ### 10472 ###
USA Davolio ### 10473 $230.40
UK Buchanan ### 10474 ###
UK Dodsworth 4/4/2004 10475 ###
USA Callahan ### 10476 $180.48
UK Buchanan ### 10477 $558.00
USA Fuller ### 10478 $471.20
USA Leverling ### 10479 ###
UK Suyama ### 10480 $756.00
USA Callahan ### 10481 ###
USA Davolio ### 10482 $147.00
UK King ### 10483 $668.80
USA Leverling 4/1/2004 10484 $386.20
USA Peacock ### 10485 ###
USA Davolio 4/2/2004 10486 ###
USA Fuller ### 10487 $889.70
USA Callahan 4/2/2004 10488 ###
UK Suyama 4/9/2004 10489 $439.20
UK King 4/3/2004 10490 ###
USA Callahan 4/8/2004 10491 $259.50
USA Leverling ### 10492 $851.20
USA Peacock ### 10493 $608.40
USA Peacock 4/9/2004 10494 $912.00
USA Leverling ### 10495 $278.00
UK King 4/7/2004 10496 $190.00
UK King 4/7/2004 10497 ###
USA Callahan ### 10498 $575.00
USA Peacock ### 10499 ###
UK Suyama ### 10500 $523.26
UK Dodsworth ### 10501 $149.00
USA Fuller ### 10502 $816.30
UK Suyama ### 10503 ###
USA Peacock ### 10504 ###
USA Leverling ### 10505 $147.90
UK Dodsworth 5/2/2004 10506 $415.80
UK King ### 10507 $749.06
USA Davolio ### 10508 $240.00
USA Peacock ### 10509 $136.80
UK Suyama ### 10510 ###
USA Peacock ### 10511 ###
UK King ### 10512 $525.30
UK King ### 10513 ###
USA Leverling ### 10514 ###
USA Fuller ### 10515 ###
USA Fuller 5/1/2004 10516 ###
USA Leverling ### 10517 $352.00
USA Peacock 5/5/2004 10518 ###
UK Suyama 5/1/2004 10519 ###
UK King 5/1/2004 10520 $200.00
USA Callahan 5/2/2004 10521 $225.50
USA Peacock 5/6/2004 10522 ###
UK King ### 10523 ###
USA Davolio 5/7/2004 10524 ###
USA Davolio ### 10525 $818.40
USA Peacock ### 10526 ###
UK King 5/7/2004 10527 ###
UK Suyama 5/9/2004 10528 $392.20
UK Buchanan 5/9/2004 10529 $946.00
USA Leverling ### 10530 ###
UK King ### 10531 $110.00
UK King ### 10532 $796.35
USA Callahan ### 10533 ###
USA Callahan ### 10534 $465.70
USA Peacock ### 10535 ###
USA Leverling 6/6/2004 10536 ###
USA Davolio ### 10537 ###
UK Dodsworth ### 10538 $139.80
UK Suyama ### 10539 $355.50
USA Leverling ### 10540 ###
USA Fuller ### 10541 ###
USA Davolio ### 10542 $469.11
USA Callahan ### 10543 ###
USA Peacock ### 10544 $417.20
USA Callahan ### 10545 $210.00
USA Davolio ### 10546 ###
USA Leverling 6/2/2004 10547 ###
USA Leverling 6/2/2004 10548 $240.10
UK Buchanan ### 10549 ###
UK King 6/6/2004 10550 $683.30
USA Peacock 6/6/2004 10551 ###
USA Fuller 6/5/2004 10552 $880.50
USA Fuller 6/3/2004 10553 ###
USA Peacock 6/5/2004 10554 ###
UK Suyama 6/4/2004 10555 ###
USA Fuller ### 10556 $835.20
UK Dodsworth 6/6/2004 10557 ###
USA Davolio ### 10558 ###
UK Suyama ### 10559 $520.41
USA Callahan 6/9/2004 10560 ###
USA Fuller 6/9/2004 10561 ###
USA Davolio ### 10562 $488.70
USA Fuller ### 10563 $965.00
USA Peacock ### 10564 ###
USA Callahan ### 10565 $639.90
UK Dodsworth ### 10566 ###
USA Davolio ### 10567 ###
USA Leverling 7/9/2004 10568 $155.00
UK Buchanan ### 10569 $890.00
USA Leverling ### 10570 ###
USA Callahan 7/4/2004 10571 $550.59
USA Leverling ### 10572 ###
UK King ### 10573 ###
USA Peacock ### 10574 $764.30
UK Buchanan ### 10575 ###
USA Leverling ### 10576 $838.45
UK Dodsworth ### 10577 $569.00
USA Peacock ### 10578 $477.00
USA Davolio 7/4/2004 10579 $317.75
USA Peacock 7/1/2004 10580 ###
USA Leverling 7/2/2004 10581 $310.00
USA Leverling ### 10582 $330.00
USA Fuller 7/4/2004 10583 ###
USA Peacock 7/4/2004 10584 $593.75
UK King ### 10585 $142.50
UK Dodsworth 7/9/2004 10586 $23.80
USA Davolio 7/9/2004 10587 $807.38
USA Fuller ### 10588 ###
USA Callahan ### 10589 $72.00
USA Peacock ### 10590 ###
USA Davolio ### 10591 $812.50
USA Leverling ### 10592 $516.46
UK King ### 10593 ###
USA Leverling ### 10594 $565.50
USA Fuller ### 10595 ###
USA Callahan ### 10596 ###
UK King ### 10597 $718.08
USA Davolio ### 10598 ###
UK Suyama ### 10599 $493.00
USA Peacock ### 10600 $479.80
UK King ### 10601 ###
USA Callahan ### 10602 $48.75
USA Callahan 8/8/2004 10603 ###
USA Davolio ### 10604 $230.85
USA Davolio ### 10605 ###
USA Peacock ### 10606 ###
UK Buchanan ### 10607 ###
USA Peacock 8/1/2004 10608 ###
UK King ### 10609 $424.00
USA Callahan 8/6/2004 10610 $299.25
UK Suyama 8/1/2004 10611 $808.00
USA Davolio 8/1/2004 10612 ###
USA Peacock 8/1/2004 10613 $353.20
USA Callahan 8/1/2004 10614 $464.00
USA Fuller 8/6/2004 10615 $120.00
USA Davolio 8/5/2004 10616 ###
USA Peacock 8/4/2004 10617 ###
USA Davolio 8/8/2004 10618 ###
USA Leverling 8/7/2004 10619 ###
USA Fuller ### 10620 $57.50
USA Peacock ### 10621 $758.50
USA Peacock ### 10622 $560.00
USA Callahan ### 10623 ###
USA Peacock ### 10624 ###
USA Leverling ### 10625 $479.75
USA Davolio ### 10626 ###
USA Callahan ### 10627 ###
USA Peacock ### 10628 $450.00
USA Peacock ### 10629 ###
USA Davolio ### 10630 $903.60
USA Callahan ### 10631 $55.80
USA Callahan ### 10632 $589.00
UK King ### 10633 ###
USA Peacock ### 10634 ###
USA Callahan ### 10635 ###
USA Peacock ### 10636 $629.50
UK Suyama ### 10637 ###
USA Leverling 9/1/2004 10638 ###
UK King ### 10639 $500.00
USA Peacock ### 10640 $708.75
USA Peacock ### 10641 ###
UK King 9/5/2004 10642 $696.00
UK Suyama 9/2/2004 10643 $814.50
USA Leverling 9/1/2004 10644 ###
USA Peacock 9/2/2004 10645 ###
UK Dodsworth 9/3/2004 10646 ###
USA Peacock 9/3/2004 10647 $636.00
UK Buchanan 9/9/2004 10648 $372.37
UK Buchanan ### 10649 ###
UK Buchanan 9/3/2004 10650 ###
USA Callahan ### 10651 $397.80
USA Peacock 9/8/2004 10652 $318.84
USA Davolio ### 10653 ###
UK Buchanan ### 10654 $601.83
USA Davolio ### 10655 $154.40
UK Suyama ### 10656 $604.21
USA Fuller ### 10657 ###
USA Peacock 9/8/2004 10658 ###
UK King ### 10659 ###
USA Callahan ### 10660 ###
UK King ### 10661 $562.60
USA Leverling ### 10662 $125.00
USA Fuller ### 10663 ###
USA Davolio ### 10664 ###
USA Davolio ### 10665 ###
UK King ### 10666 ###
UK King ### 10667 ###
USA Davolio ### 10668 $625.27
USA Fuller ### 10669 $570.00
USA Peacock ### 10670 ###
USA Davolio ### 10671 $920.10
UK Dodsworth ### 10672 ###
USA Fuller ### 10673 $412.35
USA Peacock ### 10674 $45.00
UK Buchanan ### 10675 ###
USA Fuller ### 10676 $534.85
USA Davolio ### 10677 $813.36
UK King ### 10678 ###
USA Callahan ### 10679 $660.00
USA Davolio ### 10680 ###
USA Leverling ### 10681 ###
USA Leverling ### 10682 $375.50
USA Fuller ### 10683 $63.00
USA Leverling ### 10684 ###
USA Peacock ### 10685 $801.10
USA Fuller ### 10686 ###
UK Dodsworth ### 10687 ###
USA Peacock ### 10688 ###
USA Davolio ### 10689 $472.50
USA Davolio ### 10690 $862.50
USA Fuller ### 10691 ###
USA Peacock ### 10692 $878.00
USA Leverling ### 10693 ###
USA Callahan ### 10694 ###
UK King ### 10695 $642.00
USA Callahan ### 10696 $996.00
USA Leverling ### 10697 $805.43
USA Peacock ### 10698 ###
USA Leverling ### 10699 $114.00
USA Leverling ### 10700 ###
UK Suyama ### 10701 ###
USA Peacock ### 10702 $330.00
UK Suyama ### 10703 ###
UK Suyama ### 10704 $595.50
UK Dodsworth ### 10705 $378.00
USA Callahan ### 10706 ###
USA Peacock ### 10707 ###
UK Suyama ### 10708 $180.40
USA Davolio ### 10709 ###
USA Davolio ### 10710 $93.50
UK Buchanan ### 10711 ###
USA Leverling ### 10712 ###
USA Davolio ### 10713 ###
UK Buchanan ### 10714 ###
USA Leverling ### 10715 ###
USA Peacock ### 10716 $706.00
USA Davolio ### 10717 ###
USA Davolio ### 10718 ###
USA Callahan ### 10719 $844.25
USA Callahan ### 10720 $550.00
UK Buchanan ### 10721 $923.87
USA Callahan ### 10722 ###
USA Leverling ### 10723 $468.45
USA Callahan ### 10724 $638.50
USA Peacock ### 10725 $287.80
USA Peacock ### 10726 $655.00
USA Fuller ### 10727 ###
USA Peacock ### 10728 ###
USA Callahan ### 10729 ###
UK Buchanan ### 10730 $484.25
UK King ### 10731 ###
USA Leverling ### 10732 $360.00
USA Davolio ### 10733 ###
USA Fuller ### 10734 ###
UK Suyama ### 10735 $536.40
UK Dodsworth ### 10736 $997.00
USA Fuller ### 10737 $139.80
USA Fuller ### 10738 $52.35
USA Leverling ### 10739 $240.00
USA Peacock ### 10740 ###
USA Peacock ### 10741 $228.00
USA Leverling ### 10742 ###
USA Davolio ### 10743 $319.20
UK Suyama ### 10744 $736.00
UK Dodsworth ### 10745 ###
USA Davolio ### 10746 ###
UK Suyama ### 10747 ###
USA Leverling ### 10748 ###
USA Peacock ### 10749 ###
UK Dodsworth ### 10750 ###
USA Leverling ### 10751 ###
USA Fuller ### 10752 $252.00
USA Leverling ### 10753 $88.00
UK Suyama ### 10754 $55.20
USA Peacock ### 10755 ###
USA Callahan ### 10756 ###
UK Suyama ### 10757 ###
USA Leverling ### 10758 ###
USA Leverling ### 10759 $320.00
USA Peacock ### 10760 ###
UK Buchanan ### 10761 $507.00
USA Leverling ### 10762 ###
USA Leverling ### 10763 $616.00
UK Suyama ### 10764 ###
USA Leverling ### 10765 ###
USA Peacock ### 10766 ###
USA Peacock ### 10767 $28.00
USA Leverling ### 10768 ###
USA Leverling ### 10769 ###
USA Callahan ### 10770 $236.25
UK Dodsworth 1/2/2004 10771 $344.00
USA Leverling ### 10772 ###
USA Davolio ### 10773 ###
USA Peacock ### 10774 $868.75
UK King ### 10775 $228.00
USA Davolio ### 10776 ###
UK King ### 10777 $224.00
USA Leverling ### 10778 $96.50
USA Leverling ### 10779 ###
USA Fuller ### 10780 $720.00
USA Fuller ### 10781 $975.88
UK Dodsworth ### 10782 $12.50
USA Peacock ### 10783 ###
USA Peacock ### 10784 ###
USA Davolio ### 10785 $387.50
USA Callahan ### 10786 ###
USA Fuller ### 10787 ###
USA Davolio ### 10788 $731.50
USA Davolio ### 10789 ###
UK Suyama ### 10790 $722.50
UK Suyama 1/1/2005 10791 ###
USA Davolio ### 10792 $399.85
USA Leverling 1/8/2005 10793 $191.10
UK Suyama 1/2/2005 10794 $314.76
USA Callahan ### 10795 ###
USA Leverling ### 10796 ###
UK King 1/5/2005 10797 $420.00
USA Fuller 1/5/2005 10798 $446.60
UK Dodsworth 1/5/2005 10799 ###
USA Davolio 1/5/2005 10800 ###
USA Peacock ### 10801 ###
USA Peacock 1/2/2005 10802 ###
USA Peacock 1/6/2005 10803 ###
UK Suyama 1/7/2005 10804 ###
USA Fuller 1/9/2005 10805 ###
USA Leverling 1/5/2005 10806 $439.60
USA Peacock ### 10807 $18.40
USA Fuller 1/9/2005 10808 ###
UK King 1/7/2005 10809 $140.00
USA Fuller 1/7/2005 10810 $187.00
USA Callahan 1/8/2005 10811 $852.00
UK Buchanan ### 10812 ###
USA Davolio 1/9/2005 10813 $602.40
USA Leverling ### 10814 ###
USA Fuller ### 10815 $40.00
USA Peacock 2/4/2005 10816 ###
USA Leverling ### 10817 ###
UK King ### 10818 $833.00
USA Fuller ### 10819 $477.00
USA Leverling ### 10820 ###
USA Davolio ### 10821 $678.00
UK Suyama ### 10822 $237.90
UK Buchanan ### 10823 ###
USA Callahan ### 10824 $250.80
USA Davolio ### 10825 ###
UK Suyama 2/6/2005 10826 $730.00
USA Davolio 2/6/2005 10827 $843.00
UK Dodsworth 2/4/2005 10828 $932.00
UK Dodsworth ### 10829 ###
USA Peacock ### 10830 ###
USA Leverling ### 10831 ###
USA Fuller ### 10832 $475.11
UK Suyama ### 10833 $906.93
USA Davolio ### 10834 ###
USA Davolio ### 10835 $845.80
UK King ### 10836 ###
UK Dodsworth ### 10837 ###
USA Leverling ### 10838 ###
USA Leverling ### 10839 $827.55
USA Peacock ### 10840 $211.20
UK Buchanan ### 10841 ###
USA Davolio ### 10842 $975.00
USA Peacock ### 10843 $159.00
USA Callahan ### 10844 $735.00
USA Callahan ### 10845 ###
USA Fuller ### 10846 ###
USA Peacock ### 10847 ###
UK King ### 10848 $931.50
UK Dodsworth ### 10849 $967.82
USA Davolio ### 10850 $629.00
UK Buchanan 2/2/2005 10851 ###
USA Callahan ### 10852 ###
UK Dodsworth 2/3/2005 10853 $625.00
USA Leverling 2/5/2005 10854 ###
USA Leverling 2/4/2005 10855 ###
USA Leverling ### 10856 $660.00
USA Callahan 2/6/2005 10857 ###
USA Fuller 2/3/2005 10858 $649.00
USA Davolio 2/2/2005 10859 ###
USA Leverling 2/4/2005 10860 $519.00
USA Peacock ### 10861 ###
USA Callahan 2/2/2005 10862 $581.00
USA Peacock ### 10863 $441.15
USA Peacock 2/9/2005 10864 $282.00
USA Fuller ### 10865 ###
UK Buchanan ### 10866 ###
UK Suyama ### 10867 $98.40
UK King ### 10868 ###
UK Buchanan 2/9/2005 10869 ###
UK Buchanan ### 10870 $160.00
UK Dodsworth ### 10871 ###
UK Buchanan 2/9/2005 10872 ###
USA Peacock 2/9/2005 10873 $336.80
UK Buchanan ### 10874 $310.00
USA Peacock 3/3/2005 10875 $709.55
UK King ### 10876 $917.00
USA Davolio ### 10877 ###
USA Peacock ### 10878 ###
USA Leverling ### 10879 $611.30
UK King ### 10880 ###
USA Peacock ### 10881 $150.00
USA Peacock ### 10882 $892.64
USA Callahan ### 10883 $36.00
USA Peacock ### 10884 ###
UK Suyama ### 10885 ###
USA Davolio 3/2/2005 10886 ###
USA Callahan ### 10887 $70.00
USA Davolio ### 10888 $605.00
UK Dodsworth ### 10889 ###
UK King ### 10890 $860.10
UK King ### 10891 $368.93
USA Peacock ### 10892 ###
UK Dodsworth ### 10893 ###
USA Davolio ### 10894 ###
USA Leverling ### 10895 ###
UK King ### 10896 $750.50
USA Leverling ### 10897 ###
USA Peacock 3/6/2005 10898 $30.00
UK Buchanan ### 10899 $122.40
USA Davolio 3/4/2005 10900 $33.75
USA Peacock ### 10901 $934.50
USA Davolio 3/3/2005 10902 $863.43
USA Leverling 3/4/2005 10903 $932.05
USA Leverling ### 10904 ###
UK Dodsworth 3/6/2005 10905 $342.00
USA Peacock 3/3/2005 10906 $427.50
UK Suyama ### 10907 $108.50
USA Peacock 3/6/2005 10908 $663.10
USA Davolio ### 10909 $670.00
USA Davolio 3/4/2005 10910 $452.90
USA Leverling 3/5/2005 10911 $858.00
USA Fuller ### 10912 ###
USA Peacock 3/4/2005 10913 $768.75
UK Suyama 3/2/2005 10914 $537.50
USA Fuller 3/2/2005 10915 $539.50
USA Davolio 3/9/2005 10916 $686.70
USA Peacock ### 10917 $365.89
USA Leverling ### 10918 ###
USA Fuller 3/4/2005 10919 ###
USA Peacock 3/9/2005 10920 $390.00
USA Davolio 3/9/2005 10921 ###
UK Buchanan 3/5/2005 10922 $742.50
UK King ### 10923 $748.80
USA Leverling 4/8/2005 10924 ###
USA Leverling ### 10925 $475.15
USA Peacock ### 10926 $514.40
USA Peacock 4/8/2005 10927 $800.00
USA Davolio ### 10928 $137.50
UK Suyama ### 10929 ###
USA Peacock ### 10930 ###
USA Peacock ### 10931 $799.20
USA Callahan ### 10932 ###
UK Suyama ### 10933 $920.60
USA Leverling ### 10934 $500.00
USA Peacock ### 10935 $619.50
USA Leverling ### 10936 $456.00
UK King ### 10937 $644.80
USA Leverling ### 10938 ###
USA Fuller ### 10939 $637.50
USA Callahan ### 10940 $360.00
UK King ### 10941 ###
UK Dodsworth ### 10942 $560.00
USA Peacock ### 10943 $711.00
UK Suyama ### 10944 ###
USA Peacock ### 10945 $245.00
USA Davolio ### 10946 ###
USA Leverling ### 10947 $220.00
USA Leverling ### 10948 ###
USA Fuller ### 10949 ###
USA Davolio ### 10950 $110.00
UK Dodsworth 4/7/2005 10951 $458.74
USA Davolio ### 10952 $471.20
UK Dodsworth ### 10953 ###
UK Buchanan ### 10954 ###
USA Callahan ### 10955 $74.40
UK Suyama ### 10956 $677.00
USA Callahan ### 10957 ###
UK King ### 10958 $781.00
UK Suyama ### 10959 $131.75
USA Leverling 4/8/2005 10960 $265.35
USA Callahan ### 10961 ###
USA Callahan ### 10962 ###
UK Dodsworth ### 10963 $57.80
USA Leverling ### 10964 ###
UK Suyama ### 10965 $848.00
USA Peacock 4/8/2005 10966 ###
USA Fuller 4/2/2005 10967 $910.40
USA Davolio 4/1/2005 10968 ###
USA Davolio ### 10969 $108.00
UK Dodsworth ### 10970 $224.00
USA Fuller 4/2/2005 10971 ###
USA Peacock ### 10972 $251.50
UK Suyama ### 10973 $291.55
USA Leverling 4/3/2005 10974 $439.00
USA Davolio ### 10975 $717.50
USA Davolio 4/3/2005 10976 $912.00
USA Callahan ### 10977 ###
UK Dodsworth ### 10978 ###
USA Callahan ### 10979 ###
USA Peacock ### 10980 $248.00
USA Davolio 4/2/2005 10981 ###
USA Fuller 4/8/2005 10982 ###
USA Fuller 4/6/2005 10983 $720.90
USA Davolio 4/3/2005 10984 ###
USA Fuller 4/2/2005 10985 ###
USA Callahan ### 10986 ###
USA Callahan 4/6/2005 10987 ###
USA Leverling ### 10988 ###
USA Fuller 4/2/2005 10989 ###
USA Fuller 4/7/2005 10990 ###
USA Davolio 4/7/2005 10991 ###
USA Davolio 4/3/2005 10992 $69.60
UK King ### 10993 ###
USA Fuller 4/9/2005 10994 $940.50
USA Davolio 4/6/2005 10995 ###
USA Peacock ### 10996 $560.00
USA Callahan ### 10997 ###
USA Callahan ### 10998 $686.00
UK Suyama ### 10999 ###
USA Fuller ### 11000 $903.75
USA Fuller ### 11001 ###
USA Peacock ### 11002 ###
USA Leverling 4/8/2005 11003 $326.00
USA Leverling ### 11004 $295.38
USA Fuller ### 11005 $586.00
USA Leverling ### 11006 $329.69
USA Callahan ### 11007 ###
USA Fuller ### 11009 $616.50
USA Fuller ### 11010 $645.00
USA Leverling ### 11011 $933.50
USA Davolio ### 11012 ###
USA Fuller ### 11013 $361.00
USA Fuller ### 11014 $243.18
USA Fuller ### 11015 $622.35
UK Dodsworth ### 11016 $491.50
UK Dodsworth ### 11017 ###
USA Peacock ### 11018 ###
USA Fuller ### 11020 $632.40
USA Leverling ### 11021 ###
USA Davolio ### 11023 ###
USA Peacock ### 11024 ###
UK Suyama ### 11025 $270.00
USA Peacock ### 11026 ###
USA Davolio ### 11027 $877.72
USA Fuller ### 11028 ###
USA Peacock ### 11029 ###
UK King ### 11030 ###
UK Suyama ### 11031 ###
USA Fuller ### 11032 ###
UK King ### 11033 ###
USA Callahan ### 11034 $539.40
USA Fuller ### 11035 ###
USA Callahan ### 11036 ###
UK King ### 11037 $60.00
USA Davolio ### 11038 $732.60
USA Leverling ### 11041 ###
USA Fuller 5/1/2005 11042 $405.75
UK Buchanan ### 11043 $210.00
USA Peacock 5/1/2005 11044 $591.60
USA Callahan ### 11046 ###
UK King 5/1/2005 11047 $817.87
UK King ### 11048 $525.00
USA Leverling 5/1/2005 11052 ###
USA Fuller ### 11053 ###
USA Callahan 5/1/2005 11056 ###
USA Leverling 5/1/2005 11057 $45.00
ntry , sales person wise

in all countries
 BRANCH DETAILS

Date AmountAcctType
OpenedBy Branch
Customer QUESTION A
### 340 CheckiNew AcCentralExisting
### ### CD Teller WestsiExisting ✦ What is the total deposit amount for each branch, broken down by account
### ### CD New AcNorth Existing type?
### ### CD New AcWestsiExisting ✦ How many accounts were opened at each branch, broken down by account
### 5,000 CD New AcNorth Existing type?
### 7,000 SavingNew AcNorth New ✦ What’s the dollar distribution of the different account types?
### 5,000 SavingNew AcWestsiExisting ✦ What types of accounts do tellers open most often?
### 4,623 SavingNew AcNorth Existing ✦ How does the Central branch compare to the other two branches?
### 5,879 CheckiNew AcCentralExisting ✦ Which branch opens the most accounts for new customers?
### 3,171 CheckiNew AcWestsiExisting
### 4,000 SavingNew AcCentralExisting QUESTION B
### 5,000 IRA New AcCentralExisting
### ### CD New AcCentralNew 1.Categorise the report to represent the total number of accounts opened year-wise,mont
### ### SavingNew AcCentralExisting
### ### CD New AcNorth Existing
### ### CD New AcNorth New
### ### CD New AcWestsiNew
### ### CD New AcNorth New
### ### CD New AcCentralExisting
### 3,000 CheckiNew AcCentralExisting
### 2,878 SavingNew AcNorth Existing
### ### CD New AcCentralNew
### 4,000 CheckiNew AcCentralExisting
### 3,075 CheckiNew AcWestsiExisting
### 4,000 CheckiNew AcNorth Existing
### 6,000 SavingNew AcCentralExisting
### ### SavingNew AcWestsiExisting
### 240 CheckiNew AcCentralExisting
### 2,000 IRA New AcWestsiExisting
### ### CD New AcCentralExisting
### 240 CheckiNew AcCentralExisting
### 6,307 SavingTeller North Existing
### ### CD New AcCentralNew
### ### CD New AcCentralExisting
### 9,095 IRA Teller CentralExisting
### ### CD New AcWestsiExisting
### 5,000 CheckiNew AcNorth Existing
### ### CD Teller WestsiExisting
### ### CD Teller WestsiExisting
### 1,000 SavingTeller North Existing
### 275 CheckiTeller North Existing
### ### CD Teller CentralExisting
### 3,000 CheckiNew AcCentralNew
### 5,000 CheckiNew AcNorth Existing
### 1,000 CheckiNew AcCentralExisting
### 4,000 CheckiTeller North Existing
### 200 CheckiNew AcWestsiExisting
### 3,000 CheckiNew AcNorth New
### 200 CheckiTeller WestsiExisting
### 100 CheckiNew AcNorth Existing
### ### CD Teller WestsiExisting
### 7,000 IRA New AcNorth Existing
### 100 CheckiNew AcCentralExisting
### ### CD New AcNorth Existing
### ### CD New AcNorth Existing
### 5,000 CD New AcNorth Existing
### 7,000 SavingNew AcNorth New
### ### CD New AcCentralExisting
### 124 CheckiTeller CentralExisting
### 400 CheckiTeller CentralExisting
### 100 CheckiNew AcCentralExisting
### ### CD New AcWestsiNew
### 3,807 CheckiNew AcWestsiExisting
### 7,342 CheckiNew AcCentralExisting
### 133 CheckiNew AcWestsiExisting
### ### CD New AcCentralExisting
### ### IRA Teller North Existing
### 200 SavingTeller CentralExisting
### 6,762 SavingNew AcCentralExisting
### ### IRA Teller North Existing
### 500 SavingNew AcWestsiExisting
### 5,000 SavingNew AcNorth Existing
### ### CD Teller CentralExisting
### 400 CheckiNew AcCentralExisting
### 3,171 CheckiNew AcWestsiExisting
### 4,000 SavingNew AcCentralExisting
### 2,000 IRA New AcWestsiExisting
### ### CD New AcCentralExisting
### 240 CheckiNew AcCentralExisting
### 6,307 SavingTeller North Existing
### ### CD New AcCentralNew
### ### CD New AcCentralExisting
### 4,535 CheckiNew AcNorth New
### 600 SavingNew AcCentralExisting
### ### CD New AcNorth Existing
### 3,000 CheckiNew AcNorth Existing
### ### CD New AcCentralNew
### ### CD New AcWestsiExisting
### ### CD Teller North Existing
### 8,000 SavingTeller CentralExisting
### ### CD New AcNorth Existing
### 500 CheckiNew AcWestsiExisting
### 2,749 CheckiNew AcCentralNew
### ### CD New AcNorth New
### ### CD New AcCentralExisting
### 100 CheckiNew AcCentralExisting
### 250 SavingNew AcNorth Existing
### 245 CheckiNew AcNorth Existing
### ### CD New AcCentralExisting
### 7,277 IRA New AcNorth Existing
### 4,000 CheckiTeller North Existing
### ### CD New AcCentralExisting
### 3,000 CheckiNew AcCentralExisting
### 2,878 SavingNew AcNorth Existing
### ### CD New AcCentralExisting
### 4,000 CheckiNew AcCentralNew
### 3,075 CheckiNew AcWestsiExisting
### 6,202 SavingTeller CentralExisting
### 4,000 CheckiNew AcNorth Existing
### ### CD New AcCentralExisting
### 4,000 CheckiNew AcWestsiNew
### 5,000 SavingNew AcCentralNew
### 344 CheckiNew AcWestsiExisting
### 100 CheckiNew AcCentralExisting
### 1,000 CheckiNew AcCentralNew
### 6,000 CheckiTeller WestsiExisting
### ### CD New AcWestsiNew
### 3,434 CheckiNew AcCentralExisting
### 4,000 CheckiNew AcNorth Existing
### 6,000 SavingNew AcCentralNew
### 500 SavingNew AcWestsiExisting
### 4,635 CheckiNew AcCentralExisting
### 9,000 IRA New AcCentralExisting
### 4,000 CheckiNew AcCentralExisting
### 4,000 SavingNew AcNorth Existing
### ### CD New AcCentralExisting
### 3,000 CheckiNew AcCentralExisting
### 2,878 SavingNew AcNorth Existing
### ### CD New AcCentralNew
### 4,000 CheckiNew AcCentralExisting
### 3,075 CheckiNew AcWestsiExisting
### 4,000 CheckiNew AcNorth Existing
### 6,000 SavingNew AcCentralExisting
### ### SavingNew AcWestsiExisting
### 240 CheckiNew AcCentralExisting
### 9,095 IRA Teller CentralExisting
### 3,000 CheckiNew AcCentralExisting
### 2,000 CD New AcNorth New
### ### CD New AcNorth Existing
### 7,000 SavingTeller North Existing
### 5,000 CD New AcCentralExisting
### 124 CheckiTeller CentralExisting
### 400 CheckiTeller CentralExisting
### 100 CheckiNew AcCentralNew
### ### CD New AcWestsiNew
### ### CD Teller CentralExisting
### 400 CheckiNew AcCentralNew
### 1,325 CheckiNew AcCentralNew
### 100 CheckiNew AcCentralExisting
### 250 SavingTeller North Existing
### 4,000 CheckiNew AcCentralExisting
### 3,075 CheckiNew AcWestsiExisting
### 4,000 CheckiNew AcNorth New
### 6,000 SavingNew AcCentralExisting
### 500 SavingNew AcWestsiExisting
### 240 CheckiNew AcCentralExisting
### 9,095 IRA Teller CentralExisting
### ### CD New AcWestsiExisting
### 8,000 SavingNew AcCentralExisting
### ### CD New AcNorth Existing
### 6,000 SavingNew AcCentralExisting
### 500 SavingNew AcWestsiExisting
### 240 CheckiNew AcCentralExisting
### 9,095 IRA Teller CentralExisting
### ### CD New AcWestsiExisting
### 8,000 SavingNew AcCentralExisting
### ### CD New AcNorth Existing
### 500 CheckiNew AcWestsiExisting
### ### SavingNew AcCentralNew
### ### CD New AcCentralExisting
### 6,000 SavingNew AcCentralExisting
### ### CD New AcNorth Existing
### 5,000 CheckiNew AcNorth Existing
### 7,000 IRA New AcNorth Existing
### ### CheckiNew AcCentralExisting
### ### CD New AcNorth Existing
### 500 SavingNew AcWestsiExisting
### 5,000 SavingTeller North Existing
### 2,749 CheckiNew AcCentralExisting
### ### CD New AcNorth Existing
### ### CD Teller WestsiExisting
### 3,807 CheckiNew AcWestsiExisting
### 7,342 CheckiNew AcCentralExisting
### 133 CheckiNew AcWestsiExisting
### ### CD New AcCentralNew
### ### IRA Teller North Existing
### 200 SavingNew AcCentralExisting
### 6,762 SavingNew AcCentralExisting
### ### IRA Teller North Existing
### 600 SavingNew AcCentralExisting
### ### CD New AcNorth Existing
### 100 CheckiNew AcCentralExisting
### 1,000 CheckiNew AcCentralExisting
### 6,000 CheckiTeller WestsiExisting
### ### CD New AcWestsiExisting
### 3,434 CheckiNew AcCentralExisting
### 5,000 SavingNew AcWestsiExisting
### 4,623 SavingNew AcNorth New
### 5,879 CheckiNew AcCentralExisting
### 3,171 CheckiNew AcWestsiExisting
### 4,000 SavingNew AcCentralExisting
### 2,000 IRA New AcWestsiExisting
### ### CD New AcWestsiExisting
### 5,000 CD Teller North Existing
### 4,000 CheckiTeller North Existing
### ### CD New AcCentralExisting
### 200 CheckiNew AcCentralExisting
### ### SavingNew AcNorth Existing
### ### CD New AcCentralExisting
### 4,000 CheckiNew AcCentralExisting
### 100 CheckiNew AcWestsiExisting
### 4,000 CheckiNew AcNorth Existing
### 8,000 SavingTeller CentralExisting
### ### CD New AcNorth Existing
### 6,000 SavingNew AcCentralExisting
### 500 SavingNew AcWestsiExisting
### 240 CheckiNew AcCentralExisting
### 6,000 SavingNew AcCentralExisting
### ### CD New AcNorth Existing
### 5,000 CheckiNew AcNorth Existing
### 7,000 IRA New AcNorth New
### 100 CheckiNew AcCentralExisting
### ### CD New AcNorth Existing
### 500 SavingNew AcWestsiNew
### 5,000 SavingNew AcNorth New
### 2,749 CheckiNew AcCentralExisting
### ### CD New AcNorth Existing
### ### CD New AcCentralNew
### 4,000 CheckiNew AcNorth Existing
### ### CD New AcCentralExisting
### 4,000 CheckiNew AcWestsiExisting
### 5,000 SavingNew AcCentralExisting
### 344 CheckiNew AcWestsiExisting
### 4,635 CheckiNew AcCentralExisting
### 9,000 IRA New AcCentralExisting
### 4,000 CheckiNew AcCentralExisting
### 4,000 SavingNew AcNorth Existing
### ### CD New AcCentralExisting
### 3,000 CheckiNew AcCentralExisting
### 2,878 SavingNew AcNorth Existing
### ### CD New AcCentralExisting
### 4,000 CheckiNew AcCentralNew
### 3,075 CheckiNew AcWestsiNew
### 4,000 CheckiNew AcNorth New
### ### SavingNew AcCentralExisting
### 500 SavingNew AcWestsiExisting
### 240 CheckiNew AcCentralExisting
### 2,000 CD Teller CentralExisting
### 3,000 CheckiNew AcCentralExisting
### 2,749 CheckiNew AcCentralExisting
### ### CD New AcNorth Existing
### ### CD Teller WestsiExisting
### 3,807 CheckiNew AcWestsiExisting
### 7,342 CheckiNew AcCentralExisting
### 133 CheckiNew AcWestsiExisting
### ### CD New AcCentralExisting
### ### IRA Teller North Existing
### ### SavingNew AcCentralExisting
### 6,762 SavingNew AcCentralExisting
### ### IRA Teller North Existing
### 600 SavingNew AcCentralExisting
### 344 CheckiNew AcWestsiNew
### 4,635 CheckiNew AcCentralExisting
### 9,000 IRA New AcCentralExisting
### 4,000 CheckiNew AcCentralExisting
### 4,000 SavingNew AcNorth Existing
### ### CD New AcCentralExisting
### 3,000 CheckiNew AcCentralExisting
### 2,878 SavingNew AcNorth Existing
### ### CD New AcCentralExisting
### 4,000 CheckiNew AcCentralNew
### 3,075 CheckiNew AcWestsiExisting
### 4,000 CheckiNew AcNorth Existing
### 2,749 CheckiNew AcCentralNew
### ### CD New AcNorth Existing
### ### CD Teller WestsiExisting
### 3,807 CheckiNew AcWestsiExisting
### 7,342 CheckiNew AcCentralNew
### 133 CheckiNew AcWestsiExisting
### ### CD New AcCentralExisting
### ### CD Teller North Existing
### 200 SavingNew AcCentralExisting
### ### SavingNew AcCentralExisting
### 2,000 IRA Teller North New
### 600 SavingNew AcCentralExisting
### ### CD New AcNorth New
### 100 CheckiNew AcCentralExisting
### 1,000 CheckiNew AcCentralExisting
### 6,000 CheckiTeller WestsiExisting
### ### CD New AcWestsiExisting
### ### CD New AcCentralExisting
### ### IRA Teller North Existing
### ### SavingNew AcCentralNew
### 6,762 SavingNew AcCentralExisting
### ### IRA Teller North Existing
### 600 SavingNew AcCentralNew
### ### CD New AcNorth Existing
### 100 CheckiNew AcCentralNew
### 1,000 CheckiNew AcCentralExisting
### 6,000 CheckiTeller WestsiExisting
### ### CD New AcWestsiExisting
### 3,434 CheckiNew AcCentralNew
### 5,000 SavingNew AcWestsiExisting
### 4,623 SavingNew AcNorth Existing
### 5,879 CheckiNew AcCentralNew
### 3,171 CheckiNew AcWestsiExisting
### 4,000 SavingNew AcCentralNew
### 2,000 IRA New AcWestsiExisting
### ### CD New AcCentralExisting
### 124 CheckiTeller CentralExisting
### 400 CheckiTeller CentralExisting
### 100 CheckiNew AcCentralExisting
### ### CD New AcWestsiExisting
### ### CD Teller CentralExisting
### 400 CheckiNew AcCentralExisting
### 1,325 CheckiNew AcCentralNew
### 100 CheckiNew AcCentralExisting
### 250 SavingNew AcNorth Existing
### ### CD New AcCentralExisting
### 7,277 IRA New AcNorth Existing
### 100 CheckiNew AcCentralExisting
### 1,000 CheckiNew AcCentralExisting
### 6,000 CheckiTeller WestsiExisting
### ### CD New AcWestsiExisting
### 3,434 CheckiNew AcCentralExisting
### 5,000 SavingNew AcWestsiExisting
### ### SavingNew AcNorth New
### 5,879 CheckiNew AcCentralNew
### 3,171 CheckiNew AcWestsiExisting
### 4,000 SavingNew AcCentralNew
### 2,000 IRA New AcWestsiExisting
### ### CD New AcCentralExisting
### 240 CheckiNew AcCentralExisting
### ### SavingNew AcNorth Existing
### ### CD New AcCentralExisting
### 124 CheckiTeller CentralExisting
### 400 CheckiTeller CentralExisting
### 100 CheckiNew AcCentralExisting
### ### CD New AcWestsiNew
### ### CD New AcCentralNew
### 2,000 CD New AcCentralNew
### 4,535 CheckiNew AcNorth Existing
### 7,000 IRA New AcNorth Existing
### ### CheckiNew AcCentralExisting
### ### CD New AcNorth Existing
### 4,535 CheckiNew AcNorth New
### 1,946 CheckiNew AcCentralNew
### 1,946 CheckiNew AcCentralExisting
### 1,000 CheckiNew AcCentralExisting
### 4,000 CheckiTeller North Existing
wn by account

wn by account

ts opened year-wise,month-wise for each account

Student Score Problem 1
Rhea Madsen 69
Jennifer Mendez 81 Min Max Grade Frequency
Brett Broyles 100 90 100 A
Shirley Smith 28 80 89 B
John Brown 93 51 79 C
Michael G. Welch 50 41 50 D
Donald Tse 100 0 40 F
Madeline Stevens 82
Howard Porter 86
Helen Craven 81 For the student database given alongside, arrive at the number of students who come under each of
Lillie Schultz 75
Emily Li 80
Michael Long 71
Chris Herrman 88 Problem 2
Marshall Sherman 48
William Grindle 82
Pauline Haun 85 Create a frequency distribution table for frequencies ranging b/w 20 marks each (no
Lydia J. Evans 82
James Weaver 80
Barbara Billings 77
William Hernandez 35
Robert Griffin 90
Pearl Mendez 86
Kevin Trujillo 62
Daniel Nelson 58
Alfred Johnson 34
Christopher Olszews 62
Christy Downing 95
Hui Scales 84
Norma Rea 89
Lucinda C. Roberts 75
Tommie Mosqueda 89
Leon Billups 90
Angela Newhouse 69
George Smith 93
Arthur Mack 70
Jody Stewart 68
Mark Veliz 54
Betty Adams 80
Tina Moore 66
Anne Moton 82
Nicole Strachan 69
Carol Palazzo 60
Rachel C. Vazquez 95
Christopher Lindley 60
Alvaro Kennedy 82
Kenneth Horn 67
Georgia Kim 87
Penny Glasco 81
Mark Jackson 52
Benjamin P. Tickle 91
John Curtis 95
Robert Ashley 53
Eric Mccoy 84
Barbara Delacruz 100
Paul Paredes 82
Randy Haywood 63
Mary Madison 82
Robert Catoe 85
Thomas Mitchell 88
James Mccarty 62
Joseph Peterson 62
Mary Lockett 98
Steven Scott 87
Kenneth D. Farmer 91
Dolores Jones 49
Willie Longmire 84
Susan Llamas 89
Michael Price 87
Christian Whiten 87
Louis Colson 85
Sally Crespo 92
Elizabeth Kinney 94
Ned Brown 91
Elaine Clark 86
Christy Rodriguez 90
Joan Reynolds 80
Brent Larrick 81
David Jones 81
Valeria Khan 91
Courtney Lawrence 93
Susan Flanders 89
Bruce Dunn 60
Rosemary Ruben 35
Orlando Sanders 65
Jane Smeltzer 40
Douglas Mak 58
Lynn Dare 71
Felipe Blakney 88
Dianne Atwood 62
Lisa Small 69
Liza Kirts 84
Richard Medina 94
Pauline George 84
Cecilia Hernandez 75
Kenneth Rosales 86
Karl Varga 91
Arthur Taylor 80
Annie Koch 62
Jannette Garcia 87
Chastity Adams 81
Les Paul 88
Julie Jones 83
Edward Fox 73
Robert Byrd 32
Dennis Johnson 86
Mary Duff 79
Pearlie Wilson 91
Rachel Harden 85
Burton Soto 91
Loyce Durham 83
Stacy Clark 87
Betty O. Holland 87
Terry Mchaney 90
Joseph Moore 91
Timothy Rondeau 94
Jason Mathis 56
Matthew Christian 82
Andre Caufield 72
Terry Torres 59
Christopher Hernan 69
Arthur Henry 30
Billy Esparza 90
Rebecca J. Lewis 89
Mike Rice 92
Justin Milliken 53
Erica Stanley 90
Joseph Neil 89
Kevin Leathers 92
Maggie Thoman 76
Jose Hallenbeck 85
Rafael Atkins 49
Andrew Boldt 95
Susan Gutierrez 82
John Bryan 72
Bryan Miller 84
James Kling 77
Mary Stoddard 89
Helen Cowherd 94
Ruth Hernandez 83
Brenda Williams 65
Patrick Lee 82
Leonard Bland 84
Stephen Joyner 92
Susan Feaster 86
Elena Rochelle 80
Martha Song 68
Alberta Clark 61
Jennifer Valletta 52
Jessie Abramson 100
Sarah Hayes 90
Robert Hofer 95
Jeffrey Pruett 80
Franklin Stpierre 91
Marvin Manzo 86
Roland Angeles 87
Molly Doss 92
Derek Moses 53
Jody Ludwig 67
Clifford Ford 95
Michael Shelton 61
James Arnold 80
Jimmy B. Marshall 91
Chelsea Youngman 87
Jennifer Bracero 64
Betty Reyes 91
David Kelly 91
Michelle Z. Rowe 66
Patricia Jordan 70
Gary King 57
Joshua S. Brown 94
Linda T. Morehead 96
Jennifer Bassham 83
Alfred Huffman 83
Jane Morgan 85
Margaret Reilly 86
Ernesto G. Binkley 69
James R. Bernal 47
Charlene Turner 73
Rebecca Prince 82
Bob Christie 84
Scott Crites 91
Naomi Rood 84
Thomas Edwards 84
Susan Beam 76
Paul K. Brown 47
Katherine Horton 78
John Carroll 76
Michael Baccus 81
Lenore Martino 53
Phillip Carlson 54
Brandy Brooks 65
Phyllis Lorenzen 96
Mavis Brady 92
Harvey Jones 94
Deborah Byrd 83
Sarah Keener 80
Nereida Hartle 83
Daryl Pollitt 72
Rose Baylor 85
Maria Wright 75
Edward J. Wagner 69
Catherine Talarico 27
Sheryl Lefebre 84
Chris Forrester 77
Kevin H. Hernandez 63
Robert Erazo 86
Nora Jusino 96
Autumn Pannell 98
Marylin Black 84
Stella Murray 84
Chris Beasley 85
Ramon Mcgovern 80
Keith Ross 87
Chris Maple 91
Harold Lamar 54
James Richards 54
Jackie Iliff 54
Junior Walker 82
Richard Carr 37
Alice Starks 78
number of students who come under each of the grade category.

encies ranging b/w 20 marks each (no.of students)

Student Grades Min Max Grade Frequency
Student 1 62 90 100 A
Student 2 92 80 89 B
Student 3 52 51 79 C
Student 4 60 41 50 D
Student 5 81 0 40 F
Student 6 66
Student 7 63
Student 8 100 For the student database given alongside, arrive at the number of students who come under each of the grade category.
Student 9 46
Student 10 87
Student 11 93
Student 12 84
Student 13 44
Student 14 71
Student 15 100
Student 16 40
Student 17 35
Student 18 73
Student 19 99
Student 20 88
Student 21 90
Student 22 90
Student 23 44
Student 24 74
Student 25 46
Student 26 74
Student 27 92
Student 28 31
Student 29 51
Student 30 59
Student 31 85
Student 32 63
Student 33 60
Student 34 83
Student 35 72
Student 36 94
Student 37 92
Student 38 92
Student 39 59
Student 40 51
Student 41 45
Student 42 89
Student 43 51
Student 44 84
Student 45 32
Student 46 73
Student 47 44
Student 48 81
Student 49 76
Student 50 89
grade category.
Problem 1

At Bats Average Player Player to lookup:JACKSON 8

12 0.333 Arias
41 0.390 Darr
24 0.333 Davis
25 0.160 Gomez
23 0.217 Gonzolez Average 0.333
30 0.300 Gwynn At Bats 51
0 0.000 Henders Gwynn
51 0.333 on
Jackson
43 0.186 Klesko
36 0.139 Kotsay
9 0.333 Magadan
16 0.313 Mendez
44 0.341 Nevin
14 0.286 Perez
28 0.321 Trammell

VisitDate RepairVisits Start with:

Repair Visits
6/2 12 6/4
6/3 10
6/4 9
6/5 15
6/6 19
6/7 13
6/8 11
6/9 21
6/10 12 9
6/11 10
6/12 15
6/13 16
6/14 13
 6/15 9
6/16 7
6/17 14
6/18 18
6/19 17
6/20 6

Problem 3

Month: March Widgets SprocketSnapholytes

Product: Widgets January 2,892 1,771 4,718
February 3,380 4,711 2,615
March 3,744 3,223 5,312
April 3,221 2,438 1,108
May 4,839 1,999 1,994
June 3,767 5,140 3,830
July 5,467 3,337 3,232
Single-formula --> 3,744 August 3,154 4,895 1,607
Septembe 1,718 2,040 1,563
October 1,548 1,061 2,590
Novembe 5,083 3,558 3,960
Decembe 5,753 2,839 3,013

Problem 4

Code Item
SW001 Sweater
JK002 Jacket
PN001 Pants

Jacket

Problem 5
 Small Med Large
Sweater 10 12 15
Jacket 30 35 40
Pants 25 30 35

Size Item Price

Med Pants 12
Date ProductSales
1/1/2015 Apple Ju 1742.4
1/1/2015 Atlanti 385
1/1/2015 Banana 1474.41
1/1/2015 Barley 2912.7
1/1/2015 Brie 294
1/1/2015 Brocolli 360
1/1/2015 Calamar 1215.2
1/1/2015 Camemb 3329.28
1/1/2015 Cappucc 214.52
1/1/2015 Chai 705.6
1/1/2015 Chamom 2720.8
1/1/2015 Chedda 4454.8
1/1/2015 Cherry 845
1/1/2015 Chicken 5154.85
1/1/2015 Colby 1357.44
1/1/2015 Cous Co 201.6
1/1/2015 Crunchi 4728
1/1/2015 Edam 456
1/1/2015 English 25127.36
1/1/2015 Espress 1398.4
1/1/2015 Eye Fill 2667.6
1/1/2015 Fruit C 1112.8
1/1/2015 Fruit n 817
1/1/2015 Gnocchi 6931.2
1/1/2015 Gorgonz 487
1/1/2015 Gouda 9116.8
1/1/2015 Gravad 208
1/1/2015 Green T 529.2
1/1/2015 Hokkien 985.6
1/1/2015 Iced Te 1508.4
1/1/2015 Irish Br 179.2
1/1/2015 Jasmine 979.2
1/1/2015 Jupiter 1418
1/1/2015 Kaviar 216
1/1/2015 King Cr 1500
1/1/2015 Kit Kats 1267.5
1/1/2015 Lamb Ba 1396.8
1/1/2015 Latte 1141.92
1/1/2015 Lemon 225.28
1/1/2015 Lemon G 590.4
1/1/2015 Liver 966.42
1/1/2015 M & M' 5079.6
1/1/2015 Mahi Ma 205.2
1/1/2015 Mange T 1084.8
1/1/2015 Milk Bot 1755
1/1/2015 Mozzare 1973.8
1/1/2015 Mustard 1347.36
1/1/2015 Nutella 3202.87
1/1/2015 Organic 1411.92
1/1/2015 Oysters 61.44
1/1/2015 Pasta 187.6
1/1/2015 Picnic 943.89
1/1/2015 Pork Ch 5710.08
1/1/2015 Raisins 4105.92
1/1/2015 Raspber 2679
1/1/2015 Ravioli 499.2
1/1/2015 Red Fro 1605.6
1/1/2015 Ricotta 2649.6
1/1/2015 Rump S 5702.4
1/1/2015 Scalops 1308.24
1/1/2015 Smartie 744.6
1/1/2015 Snakes 1685.36
1/1/2015 Snapper 803.52
1/1/2015 Strawbe 193.2
1/1/2015 Strawbe 544
1/1/2015 Sweet C 816
1/1/2015 Tofu 2018.1
1/1/2015 Vegimit 1994.85
1/1/2015 Yellow 68.4
2/1/2015 Apple Ju 1008
2/1/2015 Atlanti 1242.52
2/1/2015 Banana 2272
2/1/2015 Barley 1735.65
2/1/2015 Brie 242.5
2/1/2015 Brocolli 128
2/1/2015 Calamar 533.2
2/1/2015 Camemb 3989.9
2/1/2015 Cappucc 1508.92
2/1/2015 Chai 878.4
2/1/2015 Chamom 228
2/1/2015 Chedda 174.15
2/1/2015 Chicken 2099.2
2/1/2015 Colby 3029.25
2/1/2015 Cous Co 504
2/1/2015 Cranber 1300
2/1/2015 Crunchi 4547.92
2/1/2015 Edam 1396.5
2/1/2015 English 12806.1
2/1/2015 Espress 4496.5
2/1/2015 Eye Fill 4013.1
2/1/2015 Fruit C 1027.78
2/1/2015 Fruit n 285.95
2/1/2015 Gnocchi 9868.6
2/1/2015 Gorgonz 2993.12
2/1/2015 Gouda 7452.5
2/1/2015 Gravad 421.2
2/1/2015 Green T 467.55
2/1/2015 Hokkien 912.8
2/1/2015 Iced Te 384
2/1/2015 Irish Br 1037.4
2/1/2015 Jasmine 778.5
2/1/2015 Jupiter 756
2/1/2015 Kaviar 714
2/1/2015 King Cr 2362.5
2/1/2015 Kit Kats 1062.5
2/1/2015 Lamb Ba 1319.2
2/1/2015 Latte 1774.08
2/1/2015 Lemon 2970
2/1/2015 Lemon G 360
2/1/2015 Liver 490.21
2/1/2015 M & M' 1249.2
2/1/2015 Mahi Ma 1007
2/1/2015 Mange T 1575
2/1/2015 Mars Ba 4252.5
2/1/2015 Mascar 2220.8
2/1/2015 Milk Bot 5268
2/1/2015 Mocha 518
2/1/2015 Moreton 265
2/1/2015 Mozzare 4488.2
2/1/2015 Mustard 2150.77
2/1/2015 Nutella 263.4
2/1/2015 Organic 8384.6
2/1/2015 Oysters 168
2/1/2015 Pasta 742
2/1/2015 Pickalill 176.7
2/1/2015 Picnic 349.6
2/1/2015 Pork Ch 1316.4
2/1/2015 Raisins 3310.56
2/1/2015 Raspber 1881
2/1/2015 Ravioli 87.75
2/1/2015 Red Fro 620
2/1/2015 Ricotta 1267.2
2/1/2015 Rump S 4456.44
2/1/2015 Scalops 1838.19
2/1/2015 Smartie 162.56
2/1/2015 Snakes 2646.08
2/1/2015 Snapper 91.8
2/1/2015 Strawbe 865.2
2/1/2015 Strawbe 600
2/1/2015 Sweet C 1224
2/1/2015 Tofu 2185.5
2/1/2015 Vegimit 1753.62
2/1/2015 Yellow 2698
3/1/2015 Apple Ju 1683
3/1/2015 Atlanti 468.51
3/1/2015 Banana 3887.92
3/1/2015 Barley 1679.12
3/1/2015 Boysenb 1750
3/1/2015 Brie 99.5
3/1/2015 Calamar 3747.9
3/1/2015 Camemb 10273.1
3/1/2015 Cappucc 1233.8
3/1/2015 Chai 1174.5
3/1/2015 Chamom 2061.5
3/1/2015 Chedda 2541.29
3/1/2015 Cherry 385.94
3/1/2015 Chicken 1500.6
3/1/2015 Colby 504
3/1/2015 Cous Co 3318
3/1/2015 Crunchi 5472.3
3/1/2015 Edam 1162.8
3/1/2015 English 7312.12
3/1/2015 Espress 1196
3/1/2015 Eye Fill 3900
3/1/2015 Fruit C 2255.5
3/1/2015 Fruit n 668.8
3/1/2015 Gnocchi 6771.6
3/1/2015 Gorgonz 1458.75
3/1/2015 Gouda 5087.5
3/1/2015 Green T 219.37
3/1/2015 Hokkien 2307.2
3/1/2015 Honey 288.22
3/1/2015 Iced Te 1252.5
3/1/2015 Jasmine 423
3/1/2015 Jupiter 1733
3/1/2015 Kaviar 1646.25
3/1/2015 King Cr 7100
3/1/2015 Kit Kats 492.5
3/1/2015 Latte 3261.6
3/1/2015 Lemon 1337.6
3/1/2015 Lemon G 1100.7
3/1/2015 Liver 666.03
3/1/2015 M & M' 2061.17
3/1/2015 Mahi Ma 190
3/1/2015 Mange T 2700
3/1/2015 Mars Ba 1360.8
3/1/2015 Milk Bot 2195
3/1/2015 Mocha 350
3/1/2015 Moreton 1393.9
3/1/2015 Mozzare 3027.6
3/1/2015 Mustard 1975.54
3/1/2015 Nutella 842.88
3/1/2015 Organic 1855
3/1/2015 Oysters 469.5
3/1/2015 Pasta 226.8
3/1/2015 Pickalill 1298.12
3/1/2015 Picnic 841.8
3/1/2015 Pork Ch 864
3/1/2015 Raisins 1881
3/1/2015 Raspber 3021
3/1/2015 Ravioli 585
3/1/2015 Red Fro 835
3/1/2015 Ricotta 4473
3/1/2015 Rump S 8912.88
3/1/2015 Scalops 815.54
3/1/2015 Smartie 68.85
3/1/2015 Snakes 1849.7
3/1/2015 Snapper 1504.8
3/1/2015 Strawbe 140
3/1/2015 Tofu 1866.97
3/1/2015 Vegimit 1093.09
3/1/2015 Yellow 2199.25
4/1/2015 Apple Ju 1364
4/1/2015 Atlanti 2542.77
4/1/2015 Banana 2162
4/1/2015 Barley 798
4/1/2015 Boysenb 750
4/1/2015 Brie 150
4/1/2015 Brocolli 400
4/1/2015 Calamar 3323.2
4/1/2015 Camemb 3060
4/1/2015 Cappucc 1233.8
4/1/2015 Chai 2128.5
4/1/2015 Chamom 2028.25
4/1/2015 Chedda 2472.5
4/1/2015 Cherry 942.5
4/1/2015 Chicken 4029.48
4/1/2015 Colby 656.25
4/1/2015 Cous Co 210
4/1/2015 Cranber 2960
4/1/2015 Crunchi 6014.6
4/1/2015 Edam 5320
4/1/2015 English 1317.5
4/1/2015 Espress 3979
4/1/2015 Eye Fill 6000.15
4/1/2015 Fruit C 510.9
4/1/2015 Fruit n 1159
4/1/2015 Gnocchi 9032.6
4/1/2015 Gorgonz 2681.87
4/1/2015 Gouda 11959.75
4/1/2015 Green T 337.5
4/1/2015 Hokkien 978.6
4/1/2015 Honey 85.4
4/1/2015 Iced Te 2683.5
4/1/2015 Irish Br 750.4
4/1/2015 Jasmine 396
4/1/2015 Jupiter 1434
4/1/2015 Kaviar 941.25
4/1/2015 King Cr 4987.5
4/1/2015 Kit Kats 1935
4/1/2015 Lamb Ba 4219.5
4/1/2015 Latte 1705.5
4/1/2015 Lemon 682
4/1/2015 Lemon G 2424.6
4/1/2015 Liver 978.93
4/1/2015 M & M' 2835.68
4/1/2015 Mahi Ma 1953.67
4/1/2015 Mange T 3826.5
4/1/2015 Mars Ba 1701
4/1/2015 Mascar 448
4/1/2015 Milk Bot 1756
4/1/2015 Mocha 42
4/1/2015 Moreton 417.38
4/1/2015 Mozzare 2349
4/1/2015 Mustard 3857.41
4/1/2015 Nutella 2590.1
4/1/2015 Organic 11898.5
4/1/2015 Oysters 60
4/1/2015 Pasta 911.75
4/1/2015 Picnic 204.7
4/1/2015 Pork Ch 936
4/1/2015 Raisins 3556.8
4/1/2015 Raspber 1510.5
4/1/2015 Ravioli 984.75
4/1/2015 Ricotta 5652
4/1/2015 Rump S 14037.79
4/1/2015 Scalops 1922.33
4/1/2015 Smartie 306
4/1/2015 Snakes 999.01
4/1/2015 Snapper 823.2
4/1/2015 Strawbe 493.5
4/1/2015 Strawbe 440
4/1/2015 Sweet C 918
4/1/2015 Tofu 470.81
4/1/2015 Vegimit 1701.87
4/1/2015 Yellow 1928.5
5/1/2015 Apple Ju 2613.6
5/1/2015 Atlanti 577.5
5/1/2015 Banana 1916.73
5/1/2015 Barley 4369.05
5/1/2015 Brie 441
5/1/2015 Brocolli 432
5/1/2015 Calamar 1822.8
5/1/2015 Camemb 4660.99
5/1/2015 Cappucc 300.33
5/1/2015 Chai 1058.4
5/1/2015 Chamom 4081.2
5/1/2015 Chedda 6236.72
5/1/2015 Cherry 1267.5
5/1/2015 Chicken 6701.31
5/1/2015 Colby 2036.16
5/1/2015 Cous Co 302.4
5/1/2015 Crunchi 5673.6
5/1/2015 Edam 684
5/1/2015 English 35178.3
5/1/2015 Espress 1678.08
5/1/2015 Eye Fill 3467.88
5/1/2015 Fruit C 1335.36
5/1/2015 Fruit n 1143.8
5/1/2015 Gnocchi 8317.44
5/1/2015 Gorgonz 584.4
5/1/2015 Gouda 13675.2
5/1/2015 Gravad 249.6
5/1/2015 Green T 740.88
5/1/2015 Hokkien 1379.84
5/1/2015 Iced Te 2262.6
5/1/2015 Irish Br 215.04
5/1/2015 Jasmine 1272.96
5/1/2015 Jupiter 1843.4
5/1/2015 Kaviar 302.4
5/1/2015 King Cr 1950
5/1/2015 Kit Kats 1521
5/1/2015 Lamb Ba 1955.52
5/1/2015 Latte 1484.5
5/1/2015 Lemon 270.34
5/1/2015 Lemon G 885.6
5/1/2015 Liver 1352.99
5/1/2015 M & M' 6095.52
5/1/2015 Mahi Ma 246.24
5/1/2015 Mange T 1410.24
5/1/2015 Milk Bot 2106
5/1/2015 Mozzare 2960.7
5/1/2015 Mustard 1886.3
5/1/2015 Nutella 3843.44
5/1/2015 Organic 1835.5
5/1/2015 Oysters 79.87
5/1/2015 Pasta 225.12
5/1/2015 Picnic 1132.67
5/1/2015 Pork Ch 6852.1
5/1/2015 Raisins 5337.7
5/1/2015 Raspber 3214.8
5/1/2015 Ravioli 748.8
5/1/2015 Red Fro 2408.4
5/1/2015 Ricotta 3444.48
5/1/2015 Rump S 6842.88
5/1/2015 Scalops 1962.36
5/1/2015 Smartie 893.52
5/1/2015 Snakes 2190.97
5/1/2015 Snapper 1124.93
5/1/2015 Strawbe 251.16
5/1/2015 Strawbe 707.2
5/1/2015 Sweet C 1142.4
5/1/2015 Tofu 2825.34
5/1/2015 Vegimit 2393.82
5/1/2015 Yellow 95.76
6/1/2015 Apple Ju 1209.6
6/1/2015 Atlanti 1739.53
6/1/2015 Banana 3180.8
6/1/2015 Barley 2429.91
6/1/2015 Brie 363.75
6/1/2015 Brocolli 153.6
6/1/2015 Calamar 693.16
6/1/2015 Camemb 5585.86
6/1/2015 Cappucc 2263.38
6/1/2015 Chai 1317.6
6/1/2015 Chamom 342
6/1/2015 Chedda 261.23
6/1/2015 Chicken 3148.8
6/1/2015 Colby 4543.88
6/1/2015 Cous Co 705.6
6/1/2015 Cranber 1560
6/1/2015 Crunchi 6821.88
6/1/2015 Edam 1815.45
6/1/2015 English 17928.54
6/1/2015 Espress 6295.1
6/1/2015 Eye Fill 4815.72
6/1/2015 Fruit C 1336.11
6/1/2015 Fruit n 371.74
6/1/2015 Gnocchi 14802.9
6/1/2015 Gorgonz 3591.74
6/1/2015 Gouda 10433.5
6/1/2015 Gravad 589.68
6/1/2015 Green T 607.82
6/1/2015 Hokkien 1277.92
6/1/2015 Iced Te 576
6/1/2015 Irish Br 1244.88
6/1/2015 Jasmine 1012.05
6/1/2015 Jupiter 1058.4
6/1/2015 Kaviar 1071
6/1/2015 King Cr 3307.5
6/1/2015 Kit Kats 1381.25
6/1/2015 Lamb Ba 1846.88
6/1/2015 Latte 2483.71
6/1/2015 Lemon 3564
6/1/2015 Lemon G 468
6/1/2015 Liver 686.29
6/1/2015 M & M' 1748.88
6/1/2015 Mahi Ma 1409.8
6/1/2015 Mange T 2362.5
6/1/2015 Mars Ba 5103
6/1/2015 Mascar 2887.04
6/1/2015 Milk Bot 7902
6/1/2015 Mocha 725.2
6/1/2015 Moreton 318
6/1/2015 Mozzare 6732.3
6/1/2015 Mustard 2796
6/1/2015 Nutella 316.08
6/1/2015 Organic 11738.44
6/1/2015 Oysters 218.4
6/1/2015 Pasta 1113
6/1/2015 Pickalill 212.04
6/1/2015 Picnic 489.44
6/1/2015 Pork Ch 1974.6
6/1/2015 Raisins 4965.84
6/1/2015 Raspber 2445.3
6/1/2015 Ravioli 105.3
6/1/2015 Red Fro 806
6/1/2015 Ricotta 1900.8
6/1/2015 Rump S 5347.73
6/1/2015 Scalops 2389.65
6/1/2015 Smartie 195.07
6/1/2015 Snakes 3439.9
6/1/2015 Snapper 128.52
6/1/2015 Strawbe 1211.28
6/1/2015 Strawbe 900
6/1/2015 Sweet C 1591.2
6/1/2015 Tofu 2622.6
6/1/2015 Vegimit 2279.71
6/1/2015 Yellow 3507.4
7/1/2015 Apple Ju 2019.6
7/1/2015 Atlanti 609.06
7/1/2015 Banana 5443.09
7/1/2015 Barley 2182.86
7/1/2015 Boysenb 2450
7/1/2015 Brie 129.35
7/1/2015 Calamar 4872.27
7/1/2015 Camemb 13355.03
7/1/2015 Cappucc 1480.56
7/1/2015 Chai 1409.4
7/1/2015 Chamom 2886.1
7/1/2015 Chedda 3303.68
7/1/2015 Cherry 501.72
7/1/2015 Chicken 2100.84
7/1/2015 Colby 604.8
7/1/2015 Cous Co 3981.6
7/1/2015 Crunchi 7113.99
7/1/2015 Edam 1511.64
7/1/2015 English 8774.54
7/1/2015 Espress 1554.8
7/1/2015 Eye Fill 5460
7/1/2015 Fruit C 2706.6
7/1/2015 Fruit n 936.32
7/1/2015 Gnocchi 8125.92
7/1/2015 Gorgonz 1896.38
7/1/2015 Gouda 6105
7/1/2015 Green T 263.24
7/1/2015 Hokkien 3460.8
7/1/2015 Honey 403.51
7/1/2015 Iced Te 1753.5
7/1/2015 Jasmine 507.6
7/1/2015 Jupiter 2599.5
7/1/2015 Kaviar 2140.13
7/1/2015 King Cr 10650
7/1/2015 Kit Kats 689.5
7/1/2015 Latte 4240.08
7/1/2015 Lemon 1605.12
7/1/2015 Lemon G 1430.91
7/1/2015 Liver 865.84
7/1/2015 M & M' 2679.52
7/1/2015 Mahi Ma 247
7/1/2015 Mange T 4050
7/1/2015 Mars Ba 1632.96
7/1/2015 Milk Bot 3073
7/1/2015 Mocha 525
7/1/2015 Moreton 1951.46
7/1/2015 Mozzare 3935.88
7/1/2015 Mustard 2765.76
7/1/2015 Nutella 1011.46
7/1/2015 Organic 2597
7/1/2015 Oysters 563.4
7/1/2015 Pasta 294.84
7/1/2015 Pickalill 1687.56
7/1/2015 Picnic 1178.52
7/1/2015 Pork Ch 1123.2
7/1/2015 Raisins 2633.4
7/1/2015 Raspber 3625.2
7/1/2015 Ravioli 819
7/1/2015 Red Fro 1252.5
7/1/2015 Ricotta 6262.2
7/1/2015 Rump S 10695.46
7/1/2015 Scalops 1060.2
7/1/2015 Smartie 103.28
7/1/2015 Snakes 2774.55
7/1/2015 Snapper 2257.2
7/1/2015 Strawbe 182
7/1/2015 Tofu 2613.76
7/1/2015 Vegimit 1639.64
7/1/2015 Yellow 3298.88
8/1/2015 Apple Ju 1782.9
8/1/2015 Atlanti 3559.88
8/1/2015 Banana 3026.8
8/1/2015 Barley 957.6
8/1/2015 Boysenb 900
8/1/2015 Brie 195
8/1/2015 Brocolli 480
8/1/2015 Calamar 4984.8
8/1/2015 Camemb 4284
8/1/2015 Cappucc 1727.32
8/1/2015 Chai 3192.75
8/1/2015 Chamom 2433.9
8/1/2015 Chedda 3708.75
8/1/2015 Cherry 1225.25
8/1/2015 Chicken 4835.38
8/1/2015 Colby 984.38
8/1/2015 Cous Co 252
8/1/2015 Cranber 4440
8/1/2015 Crunchi 8420.44
8/1/2015 Edam 6384
8/1/2015 English 1976.25
8/1/2015 Espress 5172.7
8/1/2015 Eye Fill 7800.2
8/1/2015 Fruit C 766.35
8/1/2015 Fruit n 1390.8
8/1/2015 Gnocchi 13548.9
8/1/2015 Gorgonz 4022.81
8/1/2015 Gouda 15547.68
8/1/2015 Green T 506.25
8/1/2015 Hokkien 1272.18
8/1/2015 Honey 102.48
8/1/2015 Iced Te 4025.25
8/1/2015 Irish Br 1050.56
8/1/2015 Jasmine 594
8/1/2015 Jupiter 2007.6
8/1/2015 Kaviar 1317.75
8/1/2015 King Cr 5985
8/1/2015 Kit Kats 2902.5
8/1/2015 Lamb Ba 5907.3
8/1/2015 Latte 2387.7
8/1/2015 Lemon 886.6
8/1/2015 Lemon G 3394.44
8/1/2015 Liver 1370.5
8/1/2015 M & M' 3969.95
8/1/2015 Mahi Ma 2930.51
8/1/2015 Mange T 5739.75
8/1/2015 Mars Ba 2041.2
8/1/2015 Mascar 537.6
8/1/2015 Milk Bot 2282.8
8/1/2015 Mocha 50.4
8/1/2015 Moreton 626.07
8/1/2015 Mozzare 3053.7
8/1/2015 Mustard 5014.63
8/1/2015 Nutella 3626.14
8/1/2015 Organic 14278.2
8/1/2015 Oysters 90
8/1/2015 Pasta 1367.63
8/1/2015 Picnic 286.58
8/1/2015 Pork Ch 1216.8
8/1/2015 Raisins 4268.16
8/1/2015 Raspber 1812.6
8/1/2015 Ravioli 1181.7
8/1/2015 Ricotta 6782.4
8/1/2015 Rump S 19652.91
8/1/2015 Scalops 2691.26
8/1/2015 Smartie 397.8
8/1/2015 Snakes 1398.61
8/1/2015 Snapper 1152.48
8/1/2015 Strawbe 690.9
8/1/2015 Strawbe 572
8/1/2015 Sweet C 1101.6
8/1/2015 Tofu 706.22
8/1/2015 Vegimit 2552.81
8/1/2015 Yellow 2892.75
9/1/2015 Apple Ju 1829.52
9/1/2015 Atlanti 462
9/1/2015 Banana 1533.39
9/1/2015 Barley 3495.24
9/1/2015 Brie 308.7
9/1/2015 Brocolli 345.6
9/1/2015 Calamar 1458.24
9/1/2015 Camemb 3262.69
9/1/2015 Cappucc 210.23
9/1/2015 Chai 846.72
9/1/2015 Chamom 2856.84
9/1/2015 Chedda 4365.7
9/1/2015 Cherry 1014
9/1/2015 Chicken 5361.04
9/1/2015 Colby 1425.31
9/1/2015 Cous Co 241.92
9/1/2015 Crunchi 3971.52
9/1/2015 Edam 547.2
9/1/2015 English 28142.64
9/1/2015 Espress 1342.46
9/1/2015 Eye Fill 2427.52
9/1/2015 Fruit C 1068.29
9/1/2015 Fruit n 915.04
9/1/2015 Gnocchi 6653.95
9/1/2015 Gorgonz 467.52
9/1/2015 Gouda 9572.64
9/1/2015 Gravad 174.72
9/1/2015 Green T 518.62
9/1/2015 Hokkien 1103.87
9/1/2015 Iced Te 1583.82
9/1/2015 Irish Br 172.03
9/1/2015 Jasmine 1018.37
9/1/2015 Jupiter 1474.72
9/1/2015 Kaviar 211.68
9/1/2015 King Cr 1365
9/1/2015 Kit Kats 1064.7
9/1/2015 Lamb Ba 1564.42
9/1/2015 Latte 1187.6
9/1/2015 Lemon 189.24
9/1/2015 Lemon G 708.48
9/1/2015 Liver 1082.39
9/1/2015 M & M' 4876.42
9/1/2015 Mahi Ma 172.37
9/1/2015 Mange T 987.17
9/1/2015 Milk Bot 1684.8
9/1/2015 Mozzare 2368.56
9/1/2015 Mustard 1320.41
9/1/2015 Nutella 3074.76
9/1/2015 Organic 1284.85
9/1/2015 Oysters 55.91
9/1/2015 Pasta 180.1
9/1/2015 Picnic 792.87
9/1/2015 Pork Ch 5481.68
9/1/2015 Raisins 4270.16
9/1/2015 Raspber 2571.84
9/1/2015 Ravioli 599.04
9/1/2015 Red Fro 1685.88
9/1/2015 Ricotta 2411.14
9/1/2015 Rump S 4790.02
9/1/2015 Scalops 1373.65
9/1/2015 Smartie 625.46
9/1/2015 Snakes 1752.77
9/1/2015 Snapper 787.45
9/1/2015 Strawbe 200.93
9/1/2015 Strawbe 495.04
9/1/2015 Sweet C 913.92
9/1/2015 Tofu 1977.74
 9/1/2015 Vegimit 1915.06
9/1/2015 Yellow 67.03
10/1/2015 Apple Ju 846.72
10/1/2015 Atlanti 1391.62
10/1/2015 Banana 2544.64
10/1/2015 Barley 1700.94
10/1/2015 Brie 254.63
10/1/2015 Brocolli 107.52
10/1/2015 Calamar 554.53
10/1/2015 Camemb 3910.1
10/1/2015 Cappucc 1584.37
10/1/2015 Chai 922.32
10/1/2015 Chamom 239.4
10/1/2015 Chedda 182.86
10/1/2015 Chicken 2519.04
10/1/2015 Colby 3635.1
10/1/2015 Cous Co 564.48
10/1/2015 Cranber 1248
10/1/2015 Crunchi 5457.5
10/1/2015 Edam 1270.82
10/1/2015 English 14342.83
10/1/2015 Espress 4406.57
10/1/2015 Eye Fill 3852.58
10/1/2015 Fruit C 935.28
10/1/2015 Fruit n 260.21
10/1/2015 Gnocchi 10362.03
10/1/2015 Gorgonz 2873.4
10/1/2015 Gouda 8346.8
10/1/2015 Gravad 412.78
10/1/2015 Green T 425.47
10/1/2015 Hokkien 1022.34
10/1/2015 Iced Te 403.2
10/1/2015 Irish Br 871.42
10/1/2015 Jasmine 708.44
10/1/2015 Jupiter 740.88
10/1/2015 Kaviar 749.7
10/1/2015 King Cr 2315.25
10/1/2015 Kit Kats 966.88
10/1/2015 Lamb Ba 1292.82
10/1/2015 Latte 1986.97
10/1/2015 Lemon 2851.2
10/1/2015 Lemon G 374.4
10/1/2015 Liver 480.41
10/1/2015 M & M' 1224.22
10/1/2015 Mahi Ma 1127.84
10/1/2015 Mange T 1890
10/1/2015 Mars Ba 3572.1
10/1/2015 Mascar 2020.93
10/1/2015 Milk Bot 6321.6
10/1/2015 Mocha 507.64
10/1/2015 Moreton 254.4
10/1/2015 Mozzare 4712.61
10/1/2015 Mustard 2236.8
10/1/2015 Nutella 252.86
10/1/2015 Organic 8216.91
10/1/2015 Oysters 152.88
10/1/2015 Pasta 779.1
10/1/2015 Pickalill 148.43
10/1/2015 Picnic 342.61
10/1/2015 Pork Ch 1382.22
10/1/2015 Raisins 3476.09
10/1/2015 Raspber 1711.71
10/1/2015 Ravioli 73.71
10/1/2015 Red Fro 564.2
10/1/2015 Ricotta 1520.64
10/1/2015 Rump S 3743.41
10/1/2015 Scalops 1672.75
10/1/2015 Smartie 136.55
10/1/2015 Snakes 2407.93
10/1/2015 Snapper 102.82
10/1/2015 Strawbe 847.9
10/1/2015 Strawbe 720
10/1/2015 Sweet C 1272.96
10/1/2015 Tofu 2098.08
10/1/2015 Vegimit 1823.76
10/1/2015 Yellow 2805.92
11/1/2015 Apple Ju 1413.72
11/1/2015 Atlanti 487.25
11/1/2015 Banana 3810.16
11/1/2015 Barley 1746.28
11/1/2015 Boysenb 1960
11/1/2015 Brie 103.48
11/1/2015 Calamar 3897.82
11/1/2015 Camemb 9348.52
11/1/2015 Cappucc 1036.39
11/1/2015 Chai 1127.52
11/1/2015 Chamom 2020.27
11/1/2015 Chedda 2642.94
11/1/2015 Cherry 401.38
11/1/2015 Chicken 1470.59
11/1/2015 Colby 423.36
11/1/2015 Cous Co 2787.12
11/1/2015 Crunchi 4979.79
11/1/2015 Edam 1058.15
11/1/2015 English 6142.18
11/1/2015 Espress 1243.84
11/1/2015 Eye Fill 4368
11/1/2015 Fruit C 1894.62
11/1/2015 Fruit n 749.06
11/1/2015 Gnocchi 6500.74
11/1/2015 Gorgonz 1327.46
11/1/2015 Gouda 4273.5
11/1/2015 Green T 184.27
11/1/2015 Hokkien 2422.56
11/1/2015 Honey 282.46
11/1/2015 Iced Te 1227.45
11/1/2015 Jasmine 355.32
11/1/2015 Jupiter 1819.65
11/1/2015 Kaviar 1712.1
11/1/2015 King Cr 8520
11/1/2015 Kit Kats 482.65
11/1/2015 Latte 2968.06
11/1/2015 Lemon 1123.58
11/1/2015 Lemon G 1144.73
11/1/2015 Liver 606.09
11/1/2015 M & M' 1875.66
11/1/2015 Mahi Ma 197.6
11/1/2015 Mange T 3240
11/1/2015 Mars Ba 1306.37
11/1/2015 Milk Bot 2151.1
11/1/2015 Mocha 420
11/1/2015 Moreton 1561.17
11/1/2015 Mozzare 3148.7
11/1/2015 Mustard 2212.6
11/1/2015 Nutella 708.02
11/1/2015 Organic 2077.6
11/1/2015 Oysters 394.38
11/1/2015 Pasta 206.39
11/1/2015 Pickalill 1350.04
11/1/2015 Picnic 824.96
11/1/2015 Pork Ch 898.56
11/1/2015 Raisins 1843.38
11/1/2015 Raspber 2900.16
11/1/2015 Ravioli 573.3
11/1/2015 Red Fro 876.75
11/1/2015 Ricotta 4383.54
11/1/2015 Rump S 7486.82
11/1/2015 Scalops 848.16
11/1/2015 Smartie 72.29
11/1/2015 Snakes 1942.19
11/1/2015 Snapper 1805.76
11/1/2015 Strawbe 145.6
11/1/2015 Tofu 1829.63
11/1/2015 Vegimit 1147.74
11/1/2015 Yellow 2309.21
12/1/2015 Apple Ju 1426.32
12/1/2015 Atlanti 2847.9
12/1/2015 Banana 2421.44
12/1/2015 Barley 670.32
12/1/2015 Boysenb 720
12/1/2015 Brie 136.5
12/1/2015 Brocolli 384
12/1/2015 Calamar 3489.36
12/1/2015 Camemb 3427.2
12/1/2015 Cappucc 1381.86
12/1/2015 Chai 2554.2
12/1/2015 Chamom 1703.73
12/1/2015 Chedda 2596.13
12/1/2015 Cherry 857.68
12/1/2015 Chicken 3868.3
12/1/2015 Colby 787.5
12/1/2015 Cous Co 201.6
12/1/2015 Cranber 3108
12/1/2015 Crunchi 6736.35
12/1/2015 Edam 4468.8
12/1/2015 English 1581
12/1/2015 Espress 3620.89
12/1/2015 Eye Fill 6240.16
12/1/2015 Fruit C 613.08
12/1/2015 Fruit n 973.56
12/1/2015 Gnocchi 10839.12
12/1/2015 Gorgonz 2815.96
12/1/2015 Gouda 10883.37
12/1/2015 Green T 354.38
12/1/2015 Hokkien 890.53
12/1/2015 Honey 71.74
12/1/2015 Iced Te 3220.2
12/1/2015 Irish Br 840.45
12/1/2015 Jasmine 415.8
12/1/2015 Jupiter 1405.32
12/1/2015 Kaviar 1054.2
12/1/2015 King Cr 4788
12/1/2015 Kit Kats 2322
12/1/2015 Lamb Ba 4135.11
12/1/2015 Latte 1671.39
12/1/2015 Lemon 709.28
12/1/2015 Lemon G 2715.55
12/1/2015 Liver 959.35
12/1/2015 M & M' 2778.97
12/1/2015 Mahi Ma 2051.35
12/1/2015 Mange T 4017.83
12/1/2015 Mars Ba 1428.84
12/1/2015 Mascar 376.32
12/1/2015 Milk Bot 1597.96
12/1/2015 Mocha 35.28
12/1/2015 Moreton 438.25
12/1/2015 Mozzare 2442.96
12/1/2015 Mustard 4011.71
12/1/2015 Nutella 2900.91
12/1/2015 Organic 11422.56
12/1/2015 Oysters 63
12/1/2015 Pasta 957.34
12/1/2015 Picnic 229.26
12/1/2015 Pork Ch 851.76
12/1/2015 Raisins 3414.53
12/1/2015 Raspber 1450.08
12/1/2015 Ravioli 827.19
12/1/2015 Ricotta 4747.68
12/1/2015 Rump S 15722.32
12/1/2015 Scalops 2153.01
12/1/2015 Smartie 278.46
12/1/2015 Snakes 979.03
12/1/2015 Snapper 921.98
12/1/2015 Strawbe 552.72
12/1/2015 Strawbe 457.6
12/1/2015 Sweet C 771.12
12/1/2015 Tofu 564.97
12/1/2015 Vegimit 1786.96
12/1/2015 Yellow 2314.2
Category Product
Beverages Apple Juice
Beverages Cappuccino
Beverages Chai
Beverages Chamomile
Beverages English Breakfast
Beverages Espresso
Beverages Green Tea
Beverages Iced Tea
Beverages Irish Breakfast
Beverages Latte
Beverages Lemon Grass Tea
Beverages Mocha
CondimentsBoysenberry Spread
CondimentsCranberry Sauce
CondimentsFruit Chutney
CondimentsHoney
CondimentsLemon Curd
CondimentsMustard
CondimentsNutella
CondimentsPickalilly
CondimentsRaspberry Jam
CondimentsStrawberry Jam
CondimentsSweet Chilli Sauce
CondimentsVegimite
ConfectionsCherry Ripe
ConfectionsCrunchie
ConfectionsFruit n Nut
ConfectionsJupiter Bars
ConfectionsKit Kats
ConfectionsM & M's
ConfectionsMars Bars
ConfectionsMilk Bottles
ConfectionsPicnic
ConfectionsRed Frogs
ConfectionsSmarties
ConfectionsSnakes
ConfectionsStrawberries & Cream
Dairy ProduBrie
Dairy ProduCamembert
Dairy ProduCheddar
Dairy ProduColby
Dairy ProduEdam
Dairy ProduGorgonzola
Dairy ProduGouda
Dairy ProduMascarpone
Dairy ProduMozzarella
Dairy ProduRicotta
Grains/CereBarley
Grains/CereCous Cous
Grains/CereGnocchi
Grains/CereHokkien Noodles
Grains/CereJasmine Rice
Grains/CerePasta
Grains/CereRavioli
Meat/PoultChicken Breast
Meat/PoultEye Fillet
Meat/PoultLamb Backstrap
Meat/PoultLiver
Meat/PoultPork Chops
Meat/PoultRump Steak
Produce Brocollini
Produce Mange Tout
Produce Organic Apples
Produce Raisins
Produce Tofu
Seafood Atlantic Salmon
Seafood Banana Prawns
Seafood Calamari
Seafood Gravad lax
Seafood Kaviar
Seafood King Crabs
Seafood Mahi Mahi
Seafood Moreton Bay Bugs
Seafood Oysters
Seafood Scalops
Seafood Snapper
Seafood Yellow Fin Tuna
Task Start date #Working days
Design Completed 1/1/2021 10
Admin training 1/19/2021 15
Address IT issues 2/11/2021 12
Initial Build completed 3/2/2021 6
Data migration 3/11/2021 30
User Training 4/28/2021 15
Testing 5/22/2021 25
Parallel run 6/26/2021 8
Sign-off 7/8/2021 6
 Deadlines
Due on working May/2021
Task Due day
Estimate Data
Main Financials

Notes : Work day will not include the start date in the calculations
 Date Day Holiday

End date 1/14/2021Thu Makara Sankranti

1/18/2021 1/26/2021Tue Republic Day
2/10/2021 3/11/2021Thu Maha Shivaratri
3/1/2021 4/2/2021Fri Good Friday
3/10/2021 4/13/2021Tue Ugadi
4/27/2021 4/14/2021Wed Dr Ambedkar Jayanti
5/21/2021 4/25/2021Sun Mahavir Jayanti
6/25/2021 5/1/2021Sat May Day
7/7/2021 5/13/2021Thu Idul Fitr
7/16/2021 5/14/2021Fri Basava Jayanti
7/20/2021Tue Bakrid / Eid al Adha
8/15/2021Sun Independence Day
8/19/2021Thu Muharram
9/10/2021Fri Ganesh Chaturthi
10/2/2021Sat Gandhi Jayanti
10/6/2021Wed Mahalaya Amavasye
### Thu Maha Navami
### Fri Vijaya Dashami
### Tue Eid e Milad
### Wed Maharishi Valmiki Jayanti
11/1/2021Mon Kannada Rajyothsava
11/4/2021Thu Diwali
11/5/2021Fri Deepavali Holiday
### Sat Christmas Day
Deadlines
Jun/2021

te in the calculations
i Jayanti
State Color QuantitPrice
TX Red 10 $ 15.00
UT Blue 6 $ 18.00
CO Red 14 $ 15.00
NV Green 9 $ 16.00
TX Blue 11 $ 18.00
CO Blue 10 $ 18.00
TX Red 8 $ 15.00
UT Green 9 $ 16.00
NV Blue 11 $ 18.00
CO Green 10 $ 16.00

State Color Planned Sold

TX Red $ 13.00 $ 15.00
UT Blue $ 12.00 $ 20.00
CO Red $ 18.00 $ 19.00
NV Green $ 20.00 $ 17.00
TX Blue $ 14.00 $ 14.00
CO Blue $ 15.00 $ 15.00
TX Red $ 14.00 $ 13.00
UT Green $ 19.00 $ 11.00
NV Blue $ 16.00 $ 11.00
CO Green $ 13.00 $ 20.00

What is the total sales for the following ?

Sales Rep Region Sales Qrt

 John South $2,500 1
Paul $3,456 2 Sales Rep Paul
Ringo North $2,568 3 Region North
George South $9,854 4 Qrt 1
John North $2,569 1 Sales
Paul South $4,125 2
Ringo North $2,568 3
George South $1,458 4
John North $2,562 1

2/15/2022 0:54
 Date
Task Start date #Working daysEnd date 1/14/2021
Design Completed 1/1/2021 9 1/13/2021 1/26/2021
Admin training 1/13/2021 12 2/1/2021 3/11/2021
Address IT issues 2/1/2021 7 2/9/2021 4/2/2021
Initial Build complete 2/9/2021 9 2/19/2021 4/13/2021
Data migration 2/19/2021 11 3/6/2021 4/14/2021
User Training 3/6/2021 19 4/5/2021 4/25/2021
Testing 4/5/2021 10 4/20/2021 5/1/2021
Parallel run 4/20/2021 9 4/30/2021 5/13/2021
Sign-off 4/30/2021 9 5/15/2021 5/14/2021
7/20/2021
8/15/2021
8/19/2021
9/10/2021
10/2/2021
10/6/2021
###
###
 ###
###
11/1/2021
11/4/2021
11/5/2021
###
NETWORKDAYS(B3,D3,$F$2:$F$25)
 Australia USA
Task Start date #Working days End date 1-Jan
Design Completed 1/1/2021 8 1/13/2021 18-Jan
Admin training 1/13/2021 #NAME? 2/1/2021 20-Jan
Address IT issues 2/1/2021 #NAME? 2/9/2021 15-Feb
Initial Build complete 2/9/2021 #NAME? 2/19/2021 31-May
Data migration 2/19/2021 #NAME? 3/6/2021 18-Jun
User Training 3/6/2021 #NAME? 4/5/2021 19-Jun
Testing 4/5/2021 #NAME? 4/20/2021 4-Jul
Parallel run 4/20/2021 #NAME? 4/30/2021 5-Jul
Sign-off 4/30/2021 #NAME? 5/15/2021 6-Sep
11-Oct
11-Nov
8 25-Nov
24-Dec
25-Dec
31-Dec
=NETWORKDAYS($B4,$D4,IF($C$2="USA",USA,IF($C$2="Australia",Australia,0)))
=NETWORKDAYS($B4,$D4,IF($C$2="USA",USA,Australia))
Australia
1-Jan
25-Jan
2-Apr
5-Apr
25-Apr
25-Dec
26-Dec