Required Homework Assignments
Tutorial 1Tutorial 2TutorialTutorialCase Problem 2Case Problem 2
Access1/Case1/Lessons.xlsx
Sheet1
ContractID
StudentID
TeacherID
StartDate
EndDate
LessonType
LessonLength
LessonCost
RentalCost
3100
CAR7534
13-1100
3/31/12
3/31/13
Piano
30
130.00
0.00
3102
MEH7551
63-1554
5/18/13
5/18/14
Guitar
30
100.00
30.00
3103
MAK7556
34-4506
6/15/13
12/15/13
Violin
30
100.00
0.00
3105
BUR7559
22-0102
4/8/12
4/8/13
Cello
60
280.00
50.00
3107
MIL7512
22-0102
6/15/13
6/15/14
Piano
60
260.00
0.00
3108
SHA7522
63-1554
6/17/12
6/17/13
Guitar
30
100.00
30.00
3110
HIR7521
17-1798
9/9/12
9/9/13
Percussion
30
120.00
0.00
3113
YAM7535
91-0178
9/10/12
9/10/13
Violin
60
280.00
0.00
3114
MEN7541
70-4490
9/10/12
9/10/13
Guitar
60
200.00
30.00
3117
BRA7545
55-5310
3/11/13
3/11/14
Voice
30
120.00
0.00
3119
BAR7544
55-5310
9/15/12
3/15/13
Voice
30
100.00
0.00
3121
ROC7545
96-2151
9/20/13
9/20/14
Guitar
30
100.00
0.00
3122
SMI7538
17-1798
8/24/12
2/24/13
Percussion
30
120.00
75.00
3125
TEA7562
22-0102
10/1/12
10/1/13
Cello
60
280.00
50.00
3126
MCE7551
70-4490
12/1/12
6/1/13
Guitar
30
100.00
30.00
3128
FOR7548
72-0005
4/7/13
10/7/13
Violin
30
100.00
35.00
3130
TAN7549
72-0005
4/26/13
4/26/14
Violin
60
200.00
35.00
3133
LAM7537
63-1554
9/2/13
9/2/14
Saxophone
60
200.00
25.00
3136
HAV7535
55-5310
5/17/12
5/17/13
Voice
30
120.00
0.00
3137
BOL7533
63-1554
1/9/13
1/9/14
Guitar
60
200.00
30.00
3139
ECK7542
96-2151
7/15/13
7/15/14
Guitar
60
200.00
30.00
3141
KAL7530
13-1100
3/23/13
3/23/14
Piano
30
130.00
0.00
3144
LIM7553
70-4490
10/15/12
10/15/13
Guitar
30
100.00
0.00
3145
BRA7545
98-9123
9/14/13
9/14/14
Flute
30
130.00
25.00
3146
MIL7512
63-1554
12/1/13
6/1/14
Guitar
30
100.00
0.00
3147
GRE7502
96-2151
9/13/13
9/13/14
Saxophone
30
100.00
25.00
3148
APP7509
17-1798
2/1/12
2/1/13
Percussion
30
120.00
75.00
3150
THO7505
77-1201
2/2/13
2/2/14
Voice
30
100.00
0.00
3152
RIV7511
17-1798
2/2/13
8/2/13
Percussion
60
260.00
75.00
3153
PEN7515
98-9123
10/5/13
10/5/14
Flute
30
130.00
0.00
3156
HAM7518
96-2151
8/4/13
8/4/14
Saxophone
60
200.00
0.00
3157
YAM7535
13-1100
5/20/13
11/20/13
Piano
30
130.00
0.00
3158
GIL7529
91-0178
3/15/13
3/15/14
Violin
60
280.00
35.00
3162
CAR7534
13-1100
3/31/13
3/31/14
Piano
30
130.00
0.00
3164
MEH7551
63-1554
9/21/13
3/21/14
Saxophone
30
100.00
0.00
3165
BUR7559
22-0102
4/8/13
4/8/14
Cello
30
140.00
50.00
3166
COR7531
22-0102
6/16/12
12/16/12
Piano
30
125.00
0.00
3167
TAN7549
13-1100
11/3/13
11/3/14
Piano
30
130.00
0.00
3168
GAR7553
34-4506
6/16/12
6/16/13
Violin
30
100.00
0.00
3169
SHA7522
63-1554
6/17/13
6/17/14
Guitar
30
100.00
0.00
3170
KAL7530
34-4506
10/20/13
4/20/14
Violin
30
100.00
35.00
3171
HIR7521
17-1798
9/9/13
9/9/14
Percussion
60
260.00
0.00
3172
MEN7541
70-4490
9/10/13
9/10/14
Guitar
30
100.00
0.00
3174
BAR7544
77-1201
3/15/13
9/15/13
Voice
30
100.00
0.00
3175
SMI7538
17-1798
2/24/13
2/24/14
Percussion
60
260.00
0.00
Sheet2
Sheet3
Access1/Case1/Music.accdb
ID
Last Name
First Name
Address
City
State
Zip
Access1/Case1/Piano.bmp
Access1/Case1/School.accdb
TeacherID
FirstName
LastName
Degree
School
HireDate
63-1554
Carey
Eberle
BM
University of Oregon
2012-06-03
70-4490
Roger
Norris
BA
University of Portland
2012-09-02
72-0005
Sachi
Tanaka
BM
Lawrence University
2013-03-30
77-1201
Joy
Culbertson
BM
Reed College
2013-01-25
91-0178
Fred
Bishop
DMA
Eastman School of Music
2012-08-14
96-2151
Eric
Mueller
BA
Whitman College
2013-06-22
98-9123
Diana
Reese
MM
Berklee College of Music
2013-09-02
Access1/Case1/Student.txt
BOL7533
Eddie
Bolton
320 Main St
Gresham
OR
97236
503-760-5326
503-760-1045
6/12/1997 0:00:00
M
BRA7545
Lindsay
Brandenburg
78 Calaveras Ct
Beaverton
OR
97007
503-672-4409
503-579-4932
8/20/2000 0:00:00
F
BUR7500
Joshua
Burgess
11250 SW Walnut St
Portland
OR
97223
541-563-1135
541-563-0219
1/12/1999 0:00:00
M
BUR7559
Sara
Burmeister
279 Summer St
Cornelius
OR
97113
503-357-8410
503-357-9625
9/24/2001 0:00:00
F
CAR7534
Nicki
Carroll
1401 Lorraine Dr
Beaverton
OR
97229
503-617-3045
503-617-2410
10/5/1999 0:00:00
F
COR7531
Mary Beth
Corbett
205 Cedar St
Fairview
OR
97030
503-674-0838
503-674-7712
7/26/2002 0:00:00
F
ECK7542
Mark
Eckstein
12830 SW Trigger Dr
Beaverton
OR
97008
503-524-9610
503-646-8337
3/27/2001 0:00:00
M
FOR7548
Nicole
Forrest
19210 SE Division St
Portland
OR
97266
503-256-2368
503-968-1275
10/24/2003 0:00:00
F
GAR7553
Brett
Garver
17015 NW Holcomb Dr
Portland
OR
97229
503-690-8879
503-690-5951
2/4/2002 0:00:00
M
GIL7529
Aimee
Gilbertson
11763 SE Reedway St
Portland
OR
97266
503-762-3027
503-762-1033
11/29/1998 0:00:00
F
GRE7502
Melissa
Greco
1329 SE 135th Ave
Portland
OR
97233
503-256-4038
503-256-9117
9/13/2001 0:00:00
F
HAM7518
Akashi
Hamada
130 Maple Ave
Beaverton
OR
97229
503-617-7433
503-617-1956
4/4/2000 0:00:00
M
HAV7535
Laurie
Haverford
11286 SW Walnut St
Portland
OR
97223
541-563-7566
541-563-3904
12/2/2001 0:00:00
F
HIR7521
Erica
Hirsch
655 Langley Rd
Cornelius
OR
97123
503-547-2553
503-547-5573
6/14/2000 0:00:00
F
KAL7530
Ansis
Kalnajs
5504 SW 14th Ave
Portland
OR
97239
503-246-8864
503-246-6876
4/23/2000 0:00:00
M
LAM7537
Blake
Lamont
14305 SE Powell Blvd
Portland
OR
97236
503-761-1430
503-761-8002
1/31/1999 0:00:00
M
LIM7553
Youngho
Lim
14320 SW Barlow Rd
Beaverton
OR
97008
503-430-6218
503-430-1018
3/15/2000 0:00:00
M
MAK7556
Kim
Maki
15500 SW Allen St
Portland
OR
97223
541-563-6639
541-563-9511
7/27/1999 0:00:00
F
MCE7551
Danny
McElroy
1965 Alpine St
Cornelius
OR
97113
503-530-1269
503-530-7722
12/13/1998 0:00:00
M
MEH7551
Amrita
Mehta
18615 Yamhill Circle
Portland
OR
97233
503-491-0559
503-491-6303
11/13/2002 0:00:00
F
MEN7541
James
Mendoza
1347 Lancewood St
Beaverton
OR
97008
503-646-1155
503-646-8902
4/18/1997 0:00:00
M
MIL7512
Andy
Miller
6168 NE Rosebay Dr
Hillsboro
OR
97124
503-681-3379
503-617-9245
2/16/1999 0:00:00
M
PAP7524
Teddy
Pappas
78 Fairview Rd
Beaverton
OR
97007
503-672-6004
503-672-2790
6/16/2003 0:00:00
M
PEN7515
Dana
Pennimore
4015 SE 149th Ave
Portland
OR
97236
503-761-8155
503-761-3581
11/20/1997 0:00:00
F
RIV7511
John
Rivera
5436 NE Farmcrest St
Hillsboro
OR
97124
503-640-1517
503-640-0443
5/22/1999 0:00:00
M
ROC7545
Max
Roche
2385 Overlook Dr
Hillsboro
OR
97124
503-617-3717
503-617-7984
3/23/1998 0:00:00
M
SHA7522
Stacey
Shanahan
17440 Holcomb Dr
Portland
OR
97229
541-563-7998
541-563-7299
8/22/2002 0:00:00
F
SMI7538
Wilson
Smith
1634 Marian St
Gresham
OR
97233
503-258-4232
503-258-0202
10/19/1998 0:00:00
M
TAN7549
Kendra
Tang
2350 SE 157th Ave
Portland
OR
97233
503-761-7302
503-761-7819
6/6/2002 0:00:00
F
TEA7562
Jeff
Tealey
265 Elm St
Hillsboro
OR
97124
503-617-1027
503-617-3388
10/14/2003 0:00:00
M
THO7505
Maddie
Thorsten
60 Yearling Ct
Beaverton
OR
97008
503-524-2125
503-524-8842
7/24/1999 0:00:00
F
VAR7527
Kristin
Vargas
11084 SE 63rd St
Portland
OR
97222
503-762-5928
503-968-1972
9/18/1998 0:00:00
F
YAM7535
Angie
Yamamoto
8850 SW Burnham St
Portland
OR
97223
503-603-9451
503-603-8841
9/30/1996 0:00:00
F
Access1/Case2/Center.xlsx
Sheet1
MemberID
ProgramID
First
Last
Street
City
State
Zip
Phone
DateJoined
Expiration
Status
InitiationFeeWaived
1103
201
Joseph
Eckler
29 Prospect Street
Ashland
VA
23005
804-550-3050
01/16/2013
01/16/2014
Active
TRUE
1105
204
Barry
Hassan
9 Harrington Avenue
Richmond
VA
23220
804-236-6717
03/02/2013
03/02/2015
Active
FALSE
1106
202
Debbie
Ward
18 Barton Street
Richmond
VA
23219
804-674-8462
04/22/2013
10/22/2013
Active
TRUE
1110
201
Ashish
Mittal
103 Hubbard Way
Glen Allen
VA
23058
804-553-4737
04/03/2013
04/03/2014
On Hold
TRUE
1111
203
Liz
Sorrento
134 Lincoln Road
Chester
VA
23831
804-751-1270
02/10/2013
08/20/2013
Active
FALSE
1115
203
Michelle
Kim
290 Brook Mill Road
Bon Air
VA
23235
804-323-0291
05/17/2013
05/17/2015
Active
FALSE
1116
207
Robert
DeCosta
35 Washington Street
Richmond
VA
23220
804-236-4121
08/04/2013
08/04/2014
Inactive
TRUE
1117
203
Paul
Novick
302 Great Road
Ashland
VA
23005
804-550-1164
09/20/2013
09/20/2015
Active
FALSE
1120
202
Carmen
Sanchez
1294 Monument Avenue
Richmond
VA
23219
804-674-5991
10/18/2013
09/25/2014
On Hold
FALSE
1121
209
Kelly
Smith
7 Lakeview Road
Chester
VA
23831
804-751-0466
07/18/2013
07/18/2014
Active
FALSE
1125
203
Jessica
Picard
17 Briarwood Lane
Mechanicsville
VA
23111
804-559-0909
06/22/2013
12/22/2013
Active
FALSE
1126
204
Sam
Bethel
258 Elm Street
Mechanicsville
VA
23111
804-559-1750
05/19/2013
05/19/2014
Active
TRUE
1130
205
John
Ziminsky
1702 Hunter Avenue
Chester
VA
23831
804-751-4052
10/05/2013
10/05/2015
On Hold
FALSE
1131
207
Olivia
Alexander
29 Newtown Circle
Richmond
VA
23220
804-236-0642
03/11/2013
03/11/2015
Active
FALSE
1135
201
Tina
Sun
682 Hickory Way
Chester
VA
23831
804-751-9111
06/03/2013
06/03/2014
Active
FALSE
1136
212
Mary
Grant
913 Main Street
Chester
VA
23831
804-751-8772
05/01/2013
05/01/2015
Active
FALSE
1137
210
Alan
Fraser
41 Carver Hill Road
Mechanicsville
VA
23111
804-559-5885
03/20/2013
03/20/2014
Active
TRUE
1139
210
Peter
Grigas
3 Pleasant Street
Glen Allen
VA
23058
804-553-1642
06/09/2013
06/09/2015
Inactive
TRUE
1140
206
Ronald
Cunningham
52 Putnam Road
Ashland
VA
23005
804-550-7732
02/04/2013
08/04/2013
Active
FALSE
1142
207
Kye
Nguyen
456 Harringont Avenue
Richmond
VA
23220
804-236-0325
02/20/2013
02/20/2015
On Hold
FALSE
1143
206
Barry
Feinberg
73 Endicott Avenue
Chester
VA
23831
804-751-1119
10/05/2013
10/05/2014
Active
FALSE
1144
208
Colleen
Murphy
47 Winter Street
Mechanicsville
VA
23111
804-559-1651
06/09/2013
06/09/2014
Active
FALSE
1146
209
Marlene
Halpin
75 Elm Boulevard
Bon Air
VA
23235
804-323-0346
07/17/2013
07/17/2015
On Hold
FALSE
1147
210
Elijah
Slomich
108 Roosevelt Avenue
Mechanicsville
VA
23111
804-559-5060
08/02/2013
08/02/2015
On Hold
FALSE
1148
212
Todd
Wolfe
18 Parker Avenue
Richmond
VA
23219
804-674-2140
09/20/2013
09/20/2014
Active
TRUE
1150
203
Zach
Adgate
92 Apple Blossom Lane
Ashland
VA
23005
804-550-6119
10/15/2013
10/15/2014
Active
FALSE
1151
202
Isabella
Cimino
429 South Street
Ashland
VA
23005
804-550-9870
08/02/2013
08/02/2014
Active
FALSE
1153
212
Vinnie
Tumbiolo
358 East Street
Richmond
VA
23219
804-674-1434
05/19/2013
05/29/2015
Inactive
FALSE
1154
204
Jamal
Asmal
9872 Turnpike Road
Richmond
VA
23220
804-236-2194
06/07/2013
06/07/2014
Active
TRUE
1155
210
Juliette
Beaumont
35 Walnut Street
Glen Allen
VA
23058
804-553-1275
08/01/2013
08/01/2014
Active
FALSE
1156
208
Kurt
Eisler
5 Bradford Circle
Richmond
VA
23220
804-236-8961
04/17/2013
04/17/2015
On Hold
FALSE
1158
201
Pedro
Fuente
9 Mockingbird Lane
Chester
VA
23831
804-751-6333
09/05/2013
09/05/2014
Active
FALSE
1159
211
Maggie
Hadley
6 Rose Court
Ashland
VA
23005
804-550-6103
03/19/2013
03/19/2014
Active
TRUE
1160
212
Mark
Reynolds
11 Pond Lane
Mechanicsville
VA
23111
804-559-4642
06/20/2013
06/20/2015
Active
FALSE
1165
207
Shea
McKiernan
780 Flint Street
Ashland
VA
23005
804-550-0107
07/13/2013
07/13/2014
Active
TRUE
1166
203
Abigail
Turner
99 Maple Road
Richmond
VA
23219
804-674-6807
09/01/2013
09/01/2015
On Hold
TRUE
1167
204
George
Krukonis
14 Collins Drive
Richmond
VA
23219
804-674-4333
05/05/2013
05/05/2014
Active
TRUE
1169
211
Maria
Gonzalez
100 Tower Drive
Richmond
VA
23220
804-236-6337
05/19/2013
05/19/2014
Active
FALSE
Sheet2
Sheet3
Access1/Case2/Health.accdb
ProgramID
ProgramType
MonthlyFee
PhysicalRequired
205
Adult1 Full (ages 26-35)
¤ 60.00
No
206
Adult1 Limited (ages 26-35)
¤ 45.00
No
207
Adult2 Full (ages 36-50)
¤ 60.00
No
208
Adult2 Limited (ages 36-50)
¤ 45.00
No
209
Senior1 Full (ages 51-65)
¤ 50.00
Yes
210
Senior1 Limited (ages 51-65)
¤ 35.00
Yes
211
Senior2 Full (ages 66 and over)
¤ 40.00
Yes
212
Senior2 Limited (ages 66 and over)
¤ 30.00
Yes
Access1/Case2/Weights.bmp
Access1/Case3/Agency.txt
N33
Daycare and Family Services
Renee
Baker
825 Manchester Rd
Salina
KS
67401
785-825-5402
N57
Disability Resources Bureau
Amy
Hoffman
203 N. Kansas Ave
Salina
KS
67401
785-825-0922
R15
Elder Services Division
Ed
Rindahl
102 Jefferson St
Junction City
KS
67441
785-210-7740
R31
Mental Health of Salina
Wayne
Althorp
305 N. Kansas Ave
Salina
KS
67401
785-825-5060
R86
Workforce Development Office
Nina
Williams
400 Main St
Abilene
KS
67410
785-263-4255
W22
Vocational Rehabilitation
Kelly
Kaysen
601 Midtown Rd
McPherson
KS
67460
620-241-0889
W43
Kansas Social Services
Ray
Showalter
900 Sheridan St
Salina
KS
67401
785-827-4939
Y68
After School Youth
Linda
Mercier
131 W. 18th St
Junction City
KS
67441
785-761-7147
Access1/Case3/Gifts.xlsx
Sheet1
DonationID
DonorID
AgencyID
DonationDate
Description
DonationValue
Pickup
2100
36001
K82
01/12/2013
Cash
$30.00
FALSE
2103
36033
N57
06/02/2013
Small rugs
$40.00
FALSE
2105
36001
K64
03/10/2013
Cash
$40.00
FALSE
2108
36062
W22
05/17/2013
Computer equipment
$225.00
TRUE
2110
36041
R31
09/07/2013
Cookware
$35.00
FALSE
2112
36060
Y68
03/05/2013
Cash
$100.00
FALSE
2115
36056
N57
03/19/2013
Cash
$25.00
FALSE
2116
36001
K82
06/01/2013
Kitchen table and chairs
$347.25
TRUE
2119
36051
W22
04/23/2013
Table saw
$265.00
TRUE
2121
36058
K64
02/24/2013
Vacuum cleaner
$84.00
FALSE
2124
36055
Y68
02/02/2013
Children’s furniture
$265.50
TRUE
2125
36077
R31
03/03/2013
Small appliances
$180.00
FALSE
2126
36019
N57
04/04/2013
Cash
$75.00
FALSE
2128
36065
R15
10/07/2013
Humidifier
$65.00
FALSE
2129
36012
R86
08/30/2013
Business suits
$150.00
FALSE
2131
36049
N33
01/03/2013
Snow blower
$230.00
TRUE
2133
36042
W22
06/25/2013
Cash
$50.00
FALSE
2136
36037
W43
01/31/2013
Table linens
$45.00
FALSE
2137
36062
R31
11/01/2013
Desk lamps
$78.00
FALSE
2142
36064
N33
08/26/2013
Bookshelves
$238.75
TRUE
2144
36058
N57
11/12/2013
Sofa and chairs
$560.00
TRUE
2145
36020
R15
05/10/2013
Cash
$25.00
FALSE
2147
36032
R15
04/17/2013
Washer and dryer
$225.00
TRUE
2148
36037
W22
03/10/2013
Cash
$75.00
FALSE
2150
36073
Y68
05/28/2013
Office equipment
$305.50
TRUE
2151
36037
N33
05/06/2013
Cash
$35.00
FALSE
2153
36070
N57
02/02/2013
Linens
$47.00
FALSE
2154
36025
R31
06/12/2013
Cash
$50.00
FALSE
2155
36077
R31
07/01/2013
Sporting goods
$267.85
TRUE
2157
36028
W22
07/18/2013
Cash
$50.00
FALSE
2159
36041
K64
09/07/2013
Outdoor furniture
$345.00
TRUE
2160
36032
W43
08/21/2013
Cash
$45.00
FALSE
2163
36055
R86
05/29/2013
Cash
$35.00
FALSE
2167
36037
W22
11/27/2013
Portable heaters
$489.00
TRUE
2168
36033
Y68
06/02/2013
Sporting goods
$167.00
FALSE
2170
36074
R31
03/10/2013
Office equipment
$366.50
TRUE
2171
36056
W43
05/03/2013
Cash
$50.00
FALSE
2172
36033
Y68
09/24/2013
Cash
$35.00
FALSE
2175
36041
R15
12/12/2013
Cash
$125.00
FALSE
2177
36019
W43
09/07/2013
Cutlery
$67.00
FALSE
2179
36016
K64
04/11/2013
Small appliances
$236.50
TRUE
2180
36037
K64
12/03/2013
Cash
$50.00
FALSE
2181
36055
N33
09/07/2013
Linens
$68.00
FALSE
2182
36012
N57
11/12/2013
Microwave oven
$75.00
FALSE
2184
36020
Y68
08/28/2013
Computer equipment
$497.00
TRUE
2185
36074
K82
06/11/2013
Cash
$100.00
FALSE
2187
36070
W43
04/19/2013
Kitchen tools
$40.00
FALSE
2188
36073
R31
10/30/2013
Painting supplies
$135.40
FALSE
2190
36074
N57
10/14/2013
Dinnerware
$127.00
FALSE
2191
36077
W43
07/01/2013
Cookware
$85.75
FALSE
2192
36073
W22
11/02/2013
Welding tools
$468.00
FALSE
2193
36042
N33
12/01/2013
Cash
$100.00
FALSE
2195
36064
K64
10/15/2013
Sporting goods
$246.00
FALSE
2196
36051
N33
06/04/2013
Bookshelves
$168.90
TRUE
2197
36033
Y68
12/05/2013
Bicycles
$225.00
FALSE
2200
36032
K82
12/04/2013
Books on tape
$50.00
FALSE
2202
36051
W22
12/20/2013
Power tools
$517.00
TRUE
2205
36056
N33
09/07/2013
Office equipment
$347.00
TRUE
2210
36060
Y68
09/01/2013
Computer equipment
$388.00
FALSE
2212
36077
R86
12/20/2013
Computer equipment
$350.00
TRUE
2213
36055
W43
12/13/2013
Small appliances
$276.00
FALSE
2215
36070
N33
11/12/2013
Bicycles
$178.00
FALSE
Sheet2
Sheet3
Access1/Case3/Recycle.accdb
ID
Agency
Last Name
First Name
Phone
Fax Number
Mobile Phone
Notes
Access1/Case3/Recycle.bmp
Access1/Case3/RRGroup.accdb
DonorID
Title
FirstName
LastName
Phone
36025
Mrs.
Mary
Durnen
785-598-0569
36028
Mr.
Michael
Carlucci
316-283-6334
36032
Mrs.
Barbara
Schmidt
785-827-9713
36033
Mr.
Brian
Park
620-663-1418
36037
Ms.
Sherill
Kussow
785-823-2284
36041
Mrs.
Celia
Brubaker
620-669-3970
36042
Mrs.
Helen
Taft
785-238-9451
36049
Mrs.
Katharine
Gardiner
785-826-2135
36051
Mr.
Leland
Jaeger
785-309-1655
36055
Ms.
Tina
Sun
785-827-2688
36056
Mr.
Robert
Parkinson
785-263-5896
36058
Mrs.
Rebecca
Lawry
785-825-5583
36060
Mrs.
Dianne
Corrigan
785-826-0063
36062
Mr.
Wesley
Tarkenton
316-282-2226
36064
Ms.
Erika
Lange
785-263-1054
36065
Mrs.
Gayle
Berkelee
785-309-3896
36070
Mrs.
Ashley
Willis
785-827-1862
36073
Mr.
Gerald
Persinger
620-241-2526
36074
Mrs.
Maria
Gonzalez
785-238-0337
36077
Mrs.
Meredith
Dellkamp
785-820-1521
Access1/Case4/Bookings.txt
503
209
3488
6/12/2013 0:00:00
6/19/2013 0:00:00
12
$2000.00
504
203
3529
3/11/2013 0:00:00
3/25/2013 0:00:00
6
$1500.00
507
225
3002
5/12/2013 0:00:00
5/19/2013 0:00:00
8
$1000.00
510
220
3107
5/1/2013 0:00:00
5/15/2013 0:00:00
6
$1000.00
511
201
3142
8/20/2013 0:00:00
8/27/2013 0:00:00
7
$700.00
512
211
3222
4/4/2013 0:00:00
4/11/2013 0:00:00
8
$1600.00
513
216
3007
7/20/2013 0:00:00
7/27/2013 0:00:00
20
$3800.00
515
202
3050
9/8/2013 0:00:00
9/22/2013 0:00:00
7
$1200.00
516
224
3179
4/21/2013 0:00:00
5/5/2013 0:00:00
10
$2500.00
520
215
3002
8/10/2013 0:00:00
8/17/2013 0:00:00
6
$800.00
521
206
3395
6/3/2013 0:00:00
6/10/2013 0:00:00
6
$750.00
522
230
3190
6/22/2013 0:00:00
7/6/2013 0:00:00
15
$3000.00
525
212
3010
7/11/2013 0:00:00
7/18/2013 0:00:00
16
$5000.00
530
229
3204
8/5/2013 0:00:00
8/12/2013 0:00:00
14
$2400.00
531
205
3515
11/16/2013 0:00:00
11/23/2013 0:00:00
11
$2700.00
535
221
3003
9/10/2013 0:00:00
9/17/2013 0:00:00
6
$800.00
536
222
3675
2/20/2013 0:00:00
2/27/2013 0:00:00
8
$2500.00
537
210
3611
8/4/2013 0:00:00
8/11/2013 0:00:00
10
$2000.00
540
211
3222
4/10/2014 0:00:00
4/17/2014 0:00:00
8
$1600.00
541
228
3628
5/20/2013 0:00:00
5/27/2013 0:00:00
6
$900.00
545
203
3529
3/15/2014 0:00:00
3/29/2014 0:00:00
5
$1500.00
548
212
3395
10/2/2013 0:00:00
10/16/2013 0:00:00
5
$700.00
550
229
3670
11/5/2013 0:00:00
11/12/2013 0:00:00
8
$1300.00
Access1/Case4/Overseas.accdb
PropertyID
PropertyName
PropertyType
Location
Country
NightlyRate
Bedrooms
Sleeps
Description
VIP Program
3002
Chateau St. Antoine
Castle
Loire Valley
France
¤ 1,000.00
5
9
17th century; classic architecture; extensive gardens
false
3003
Manoir Rouy
Manor
Burgundy
France
¤ 800.00
3
6
Rural location; breathtaking views; close to vineyards
true
3007
Kilglen Castle
Castle
Inverness
Scotland
¤ 3,800.00
10
20
Traditional sporting pursuits; hunting; golf; historic tours
false
3010
Alberford Castle
Castle
Devon
England
¤ 5,000.00
8
16
1100-acre sporting estate; hunting; fishing; historic tours
false
3050
Riyad Primiere
Villa
Marrakesh
Morocco
¤ 1,600.00
4
8
Central location; courtyard; pool; art museums
false
3107
Villa Leopoldo
Villa
Tuscany
Italy
¤ 1,300.00
4
8
Close to beach and designer boutiques; biking; boating
false
3142
Clough Estate
Manor
Cork
Ireland
¤ 700.00
4
7
Early 17th century; extensive gardens; lake views; fishing
true
3179
Chateau Sur Mer
Castle
Cannes
France
¤ 2,500.00
5
10
Views over the bay; private beach; heated pool; secure
false
3190
Glenlow Castle
Castle
Dundee
Scotland
¤ 3,000.00
9
18
16th century refurbished castle; golf; fishing; horseback riding
true
3204
Hartfield Country Manor
Manor
Surrey
England
¤ 2,400.00
7
14
Late Tudor 14-acre estate; cultural and historic tours; floral art
false
3222
Casa Rosa Canina
Villa
Lake Como
Italy
¤ 1,700.00
6
12
English style architecture and gardens; panoramic lake views
true
3395
Villa San Vincenzo
Villa
Umbria
Italy
¤ 750.00
3
6
Hillside location; breathtaking views; pool; olive groves
false
3423
Castle Ballydare
Castle
Kerry
Ireland
¤ 5,000.00
9
25
Mountain views; golf; fishing; hunting; horseback riding
false
3488
Chateau du Boisvert
Castle
Provence
France
¤ 2,000.00
11
18
17th century chateau; formal gardens; pool; chapel
false
3515
Riyad Etoile
Villa
Marrakesh
Morocco
¤ 3,000.00
8
16
Multiple courtyards and terraces; pool; cultural tours
true
3529
La Amaranta
Villa
Valencia
Spain
¤ 1,700.00
6
8
Ocean views; close to beach; pool; art and music festivals
false
3611
Lumley Manor
Manor
Kent
England
¤ 2,000.00
6
11
Renaissance style with Benedictine origins; naturalist tours
false
3628
Kenyan Seaside Retreat
Villa
Mombasa
Kenya
¤ 900.00
3
7
Spectacular sea views; pool; diving; snorkeling; sailing
false
3670
Bellevue Villa
Villa
St. Tropez
France
¤ 1,300.00
4
8
Close to beach; heated pool; tennis courts; gardens
true
3675
Casa de Las Palmas
Villa
Mallorca
Spain
¤ 2,500.00
4
8
Private estate; multiple terraces; beautiful sea views; pool
false
Access1/Case4/Travel.accdb
GuestID
GuestFirst
GuestLast
Address
City
State/Prov
PostalCode
Country
Phone
209
Alex
Neeley
308 Lakeside Dr
Chicago
IL
60601
USA
312-303-1290
210
Luiz
Neto
8552 Main St
Chicago
IL
60602
USA
312-481-7053
211
Sarah
Vanesse
35 Park Rd
Crown Point
IN
46307
USA
219-377-1882
212
Janet
Froberg
433 Monroe St
Aurora
IL
60504
USA
630-788-3055
215
Brian
Campbell
14 Spencer Blvd
Gary
IN
46402
USA
219-475-3044
216
Linda
Gupta
130 Elm St
Evanston
IL
60202
USA
847-489-3339
217
Maddie
Roux
443 Front Rd
LaSalle
ON
N9J 2N7
Canada
519-734-0065
220
Alberto
Azevedo
991 Crestview Dr
Chicago
IL
60601
USA
312-842-1183
221
Amy
Shevlin
118 Forest Rd
Hammond
IN
46320
USA
219-334-1275
222
Lucas
Kalnajs
3 March Rde
Crown Point
IN
46307
USA
219-377-0312
224
Robert
Crawford
602 Pine Ridge Rd
Tinley Park
IL
60477
USA
708-292-0661
225
Kelly
Skolnik
15 Tobin Dr
Wilmington
IL
60481
USA
815-339-1597
228
Chris
Locke
4478 Howard Ave
Windsor
ON
N8X 3Y8
Canada
519-966-9094
229
Paul
Marchant
7533 Macleod Dr
Chicago
IL
60603
USA
312-783-2209
230
Susan
Goetz
29 Evergreen Rd
Aurora
IL
60507
USA
630-442-4831
Access1/Case4/Villa.bmp
Access1/Review/Goods.xlsx
Goods
ProductID
CompanyID
ProductType
Price
Unit
Color
Material
Size
Weight
Discount
5001
BAC200
Seesaw
1,394.00
Each
Yellow
Powder-coated steel
1.5 x 9 feet
112
No
5003
AND225
Small picnic table
830
Each
Green
Powder-coated steel
7 x 6 feet
299
No
5004
AND225
Large picnic table
990
Each
Blue
Powder-coated steel
9 x 6 feet
357
No
5006
BAC200
Spiderweb climber
1,722.00
Each
Green
Powder-coated steel
84 x 84 inches
146
No
5008
AND225
Small round table
575
Each
Red
Powder-coated steel
5 feet diameter
213
No
5009
AND225
Large round table
760
Each
Black
Powder-coated steel
6 feet diameter
257
No
5010
BAC200
Small play structure
4,960.00
Each
Beige-blue
Powder-coated steel
26 x 25 feet
790
No
5011
BAC200
Large play structure
12,750.00
Each
Beige-green
Powder-coated steel
33 x 34 feet
1890
No
5012
HOL207
Trash receptacle
672
Each
Black
Powder-coated steel
32 gallon
175
No
5014
BAC200
Double bay swing
3,740.00
Each
Purple
Powder-coated steel
23 x 6 feet
364
No
5015
AND225
Large bench
825
Each
Green
Powder-coated steel
15 x 2 feet
273
No
5018
AND225
Square tree grate
390
Each
Black
Powder-coated steel
4 feet square
114
No
5020
HOL207
Small bench with back
688
Each
Redwood
Redwood and iron
6 x 2 feet
197
No
5021
HOL207
Large bench with back
763
Each
Redwood
Redwood and iron
8 x 2 feet
275
No
5030
GRA231
Basketball backstop
1,245.00
Each
White
Aluminum
3 x 4 feet
458
No
5031
GRA231
Tennis posts
306
Pair
Green
Powder-coated steel
3 feet
69
No
5034
GRA231
Bicycle rack
486
Each
Blue
Powder-coated steel
5 feet
80
No
5100
PIN252
Small round table
551
Each
Wood
Teak
5 feet diameter
54
No
5101
PIN252
Large round table
980
Each
Wood
Teak
6 feet diameter
72
No
5105
PIN252
Side chair
250
Each
Wood
Teak
1.5 x 2 feet
17
No
5106
PIN252
Side chair with arms
425
Each
Wood
Teak
2 x 2 feet
24
No
5202
MIC268
Safety surface
9.6
Square foot
Black
Recycled rubber
22 gallon
58
No
5205
BES327
Matte paver
13
Each
Ginger
Precast concrete
1 square foot
21
No
5206
BES327
Granite paver
16.7
Each
Granite
Precast concrete
1 square foot
21
No
5207
BES327
Slate paver
19.9
Each
Charcoal
Precast concrete
1 square foot
21
No
5211
QUA331
Matte paver
9.65
Square foot
Blue-grey
Natural stone
No
5212
QUA331
Limestone paver
9.33
Square foot
Buff
Natural stone
No
5222
LAN348
Square paver
2.45
Square foot
Light brown
Precast concrete
No
5223
LAN348
Rectangular paver
4.05
Square foot
Light brown
Precast concrete
No
5227
LAN348
Retaining wall
10.35
Square foot
Grey
Precast concrete
1 x 1 foot
No
5228
QUA331
Wall stone
7.63
Square foot
Brown-grey
Natural stone
No
5230
BES327
Wall cap
8.5
Linear foot
White
Precast concrete
1 x 2 feet
40
No
5232
LAN348
Paver edging
1.95
Linear foot
Black
PVC
1 x 7 feet
No
5301
BEL273
Mulch
24.4
Cubic yard
Wood
Flat wood chips
Yes
5304
BEL273
Cypress mulch
20.45
Cubic yard
Shredded cypress
Yes
5305
GEN359
Cedar mulch
29
Cubic yard
Reddish
Cedar-pine blend
Yes
5311
GEN359
Top soil
13.5
Cubic yard
Screened top soil
Yes
5313
GEN359
Potting soil
16
Cubic yard
Sifted soil and compost
Yes
5314
BEL273
Potting soil
16.5
Cubic yard
Sifted soil and compost
Yes
5315
NAT304
Chain link fencing
10.6
Linear foot
Black
Vinyl-coated chain link
3.5 feet high
Yes
5317
BEL273
Top soil
13.5
Cubic yard
Screen top soil
Yes
5318
BEL273
Organic compost
14.45
Cubic yard
Organic compost
Yes
5322
NAT304
Short ornamental fence
48
Linear foot
Black
Powder-coated steel
2 feet high
Yes
5323
NAT304
Tall ornamental fence
72
Linear foot
Black
Powder-coated steel
4 feet high
Yes
5400
DUN284
Large pergola-round
17,830.00
Each
White
Vinyl
18 x 16 feet
2100
No
5401
DUN284
Large pergola-square
13,460.00
Each
White
Vinyl
18 x 16 feet
2100
No
5402
DUN284
Small pergola-round
9,455.00
Each
White
Vinyl
4 x 16 feet
700
No
5403
DUN284
Small pergola-square
7,526.00
Each
White
Vinyl
4 x 16 feet
700
No
5411
NAT304
Tennis court fencing
29.6
Linear foot
Black
Vinyl-coated chain link
10 feet high
Yes
5502
MID312
Halide lamp
312
Each
Bronze
Bronze
8.5 x 15 feet
No
5503
MID312
Lamp and post
1,007.00
Each
Black
Powder-coated aluminum
6 x .5 feet
No
5504
MID312
Lighting system
1,272.00
Each
Silver-grey
Powder-coated aluminum
12 feet high
No
5601
GEN359
Shade tree
250
Each
6-8 feet high
Yes
5602
HOL292
Shade tree
245
Each
7-9 feet high
Yes
5603
GEN359
Ornamental tree
135
Each
4-6 feet high
Yes
5604
HOL292
Ornamental tree
130
Each
6-7 feet high
Yes
5610
HOL292
Shrub
23.5
Each
3 gallon
Yes
5612
GEN359
Shrub
24
Each
3 gallon
Yes
5620
HOL292
Perennial
6.3
Each
1 gallon
Yes
5622
GEN359
Perennial
6.4
Each
1 gallon
Yes
5625
HOL292
Groundcover
3.25
Each
4 quart
Yes
5628
GEN359
Groundcover
3.25
Each
4 quart
Yes
Access1/Review/Provider.accdb
CompanyID
Company
Product
Address
City
State
Zip
Phone
ContactFirst
ContactLast
InitialContact
BEL273
Belmont Mulch
Organic and recycled mulch
3044 Edgewater Dr
Kalamazoo
MI
49007
269-343-6618
Natalie
Belmont
2012-06-17
DUN284
Dunn Rite Fence
Fencing
502 Market Ave
Grand Rapids
MI
49503
616-456-0943
Mike
Dunn
2012-02-25
GEN359
Genesis Garden Center
Mulch and soil
901 Market Ave
Grand Rapids
MI
49503
616-456-2273
Dennis
Jung
2012-05-07
GRA231
Grand Rapids Sports
Sports equipment
8022 Adams St
Grand Rapids
MI
49503
616-392-1403
Larry
Rudolph
2013-05-01
HOL207
Holland Yard and Patio
Site furnishings
85 College Ave
Holland
MI
49424
616-355-4604
Pam
Garvey
2012-03-28
LAN348
Lansing Building Supply
Pavers and walls
624 Washington Ave
Lansing
MI
48901
517-482-4562
Ken
Gratz
2012-10-01
MIC268
Michigan Surfaces
Recreational surfacing
265 W 12th St
Holland
MI
49424
616-392-1317
Ted
Silvers
2012-03-01
NAT304
National Fence Company
Ornamental fencing
3502 State St
Lansing
MI
48917
517-487-1114
Bruce
Dunleavy
2013-04-01
PIN252
Pinnacle Wood Furnishings
Benches and tables
43 Linden Dr
Lansing
MI
48933
517-483-7786
Phyllis
Walstead
2012-09-20
QUA331
Quarry Rock and Stone
Stone materials
105 Colgate Hill Rd
Holland
MI
49423
616-396-6787
Craig
Jensen
2013-10-11
Access1/Review/Tools.bmp
Access1/Tutorial/Customer.txt
11005
Owen
Hawes
616-392-0622
102 Pineview Rd
Holland
MI
49423
ohawes7@milocal123.com
11008
Melissa
Caputo
269-985-1122
302 Main St
Saint Joseph
MI
49085
mcaputo12@milocal123.com
11014
Amol
Mehta
616-396-1972
54 Lakeshore Ave
Holland
MI
49424
amehta3@milocal123.com
11015
John
Weiss
616-637-7783
456 Winchester St
South Haven
MI
49090
jweiss72@milocal123.com
11020
Battle Creek Dental Partners
Harry
Billings
269-963-0808
587 Longmeadow Rd
Battle Creek
MI
49014
hbillings1@bcdp77.com
11027
Karen
O’Brien
517-483-9244
38 Langley Rd
Lansing
MI
48933
kobrien4@milocal123.com
11030
Finn’s on the Waterfront
Devin
Finnerty
616-393-1228
78 East 8th St
Holland
MI
49423
dfinnerty1@finns78.com
11031
Happy Haven Day Care
Kathy
Rowe
616-842-4603
29 Graham’s Ln
Grand Haven
MI
49417
krowe47@hhdc123.com
11032
Pam
Wallner
269-857-1276
80 Cedar St
Saugatuck
MI
49453
pwallner2@milocal123.com
11038
M. Grant Investment Company
Alex
Engber
517-482-1400
505 Washington Ave
Lansing
MI
48901
aengber2@mgrant5.com
11040
RiverView Development Company
Charles
Nowak
616-988-0777
144 E Tower Ave
Grand Rapids
MI
49503
cnowak45@rvdc3.com
11042
Michael
Ingram
269-337-9208
10 Lincoln Dr
Kalamazoo
MI
49007
mingram8@milocal123.com
11043
Monroe State College
Rachel
Kirk
616-988-1320
40 Monroe St
Grand Rapids
MI
49503
rkirk9@msc25.edu
11045
Kalamazoo Neighborhood Development
James
Blackhawk
269-343-7509
3047 Millbrook Ave
Kalamazoo
MI
49007
jblackhawk7@knd89.gov
11048
Olivia
Pappas
616-637-6591
4 N Orchard St
South Haven
MI
49090
opappas2@milocal123.com
11049
Claire
Boucher
269-983-2255
828 Turner St
Saint Joseph
MI
49085
cboucher5@milocal123.com
11053
Hwan
Tang
616-396-8401
283 Cottrell St
Holland
MI
49423
htang3@milocal123.com
11054
Gilded Goose Gift Shop
Taylor
Wilson
616-355-3989
258 Briar Ln
Holland
MI
49424
twilson1@gggs1.com
11055
Fox and Hound Grille
Steve
Gorski
269-979-2004
1440 Beadle Lake Rd
Battle Creek
MI
49014
sgorski3@fhg1.com
11058
Cherrywood Senior Center
Lisa
Hall
269-857-1771
77 Forest Hill Rd
Saugatuck
MI
49453
lhall10@csc77.com
11059
G.R. Neighborhood Development Corp.
Matthew
Fraser
616-392-0015
8045 Jefferson Ave
Grand Rapids
MI
49503
mfraser22@grndc8.org
11060
Jerome
Smith
616-949-3862
75 Hillcrest St
East Grand Rapids
MI
49506
jsmith327@milocal123.com
11064
Northwest Transit Station
Henry
Goldberg
517-487-4700
3572 Clinton Ave
Lansing
MI
48917
hgoldberg23@nwts55.org
11065
Town of Holland
Amber
Ward
616-393-0403
24 Prospect St
Holland
MI
49423
award1@holland33.org
11067
Blossom Day Care Center
Christina
Garrett
269-985-1992
333 Empire Ave
Saint Joseph
MI
49085
cgarrett2@bdcc25.com
11068
Grand Rapids Housing Authority
Jessica
Ropiak
616-454-4002
5230 Fulton St
Grand Rapids
MI
49504
jropiak2@grha34.org
11070
Legacy Companies, LTD.
Michael
Faraci
616-456-7093
250 Market Ave
Grand Rapids
MI
49503
mfaraci8@legacy29.com
11071
Blue Star Mini Golf
Vanetta
Walker
269-857-4424
82 Mason St
Saugatuck
MI
49453
vwalker1@bsmg3.com
11072
Sierra Investment Company
Rodrigo
Valencia
269-337-8200
5049 Red Arrow Hwy
Kalamazoo
MI
49007
rvalencia1@sic99.com
11073
Connor
Riley
269-983-1116
11 Pleasant St
Saint Joseph
MI
49085
criley5@milocal123.com
11075
Kim Architects, Inc.
An
Kim
517-482-9932
1015 Williamston Rd
Lansing
MI
48933
akim3@kai82.com
11079
Dept. of Neighborhood Development
Sarah
Russell
616-940-3380
722 Beechwood Dr
East Grand Rapids
MI
49506
srussell3@dnd57.org
11080
Three Tulips Café
Jan
Van Dousen
616-392-4629
249 W 11th St
Holland
MI
49424
jvdousen2@tulips3.com
11083
Hopedale State College
John
Williams
517-337-0990
1003 Albert Ave
East Lansing
MI
48823
jwilliams94@hsc7.edu
11084
Cathy
DeSantis
616-866-4882
78 Spring St
Rockford
MI
49341
cdesantis9@milocal123.com
11085
Edward
Phillips
616-637-5408
39 Water St
South Haven
MI
49090
ephillips8@milocal123.com
11087
Walker Investment Company
Nancy
Belanger
616-456-2710
4031 Barclay St
Grand Rapids
MI
49503
nbelanger4@wic88.com
11088
Weston Community Parks Foundation
Sam
Kervin
616-454-3327
333 Pearl St
Grand Rapids
MI
49503
skervin3@wcpf47.org
Access1/Tutorial/Invoices.xlsx
Invoices
InvoiceNum
ContractNum
InvoiceDate
InvoiceItem
InvoiceAmt
InvoicePaid
2012
3011
05/10/2013
Planting Plan
$2,500.00
Yes
2021
3012
02/25/2013
Consultation
$300.00
Yes
2032
3020
08/19/2013
Landscape Planting
$2,000.00
Yes
2033
3020
09/20/2013
Lighting Plan
$2,000.00
Yes
2034
3020
10/20/2013
Permitting
$1,000.00
Yes
2041
3015
04/01/2013
Schematic Plan
$1,500.00
Yes
2051
3017
04/01/2013
Peer Plan Review
$2,250.00
Yes
2061
3026
03/11/2014
Schematic Open Space Plan
$35,000.00
Yes
2063
3026
07/11/2015
Construction Documents
$70,000.00
No
2064
3026
04/04/2017
Construction Admin. & Observation
$50,000.00
No
2071
3023
11/22/2013
Schematic Open Space Plan
$9,000.00
Yes
2072
3023
07/22/2014
Planting Plan
$20,000.00
Yes
2081
3025
07/23/2013
Schematic Plan
$4,000.00
Yes
2082
3025
12/20/2013
Construction Documents
$8,000.00
Yes
2083
3025
06/24/2014
Construction Observation
$3,500.00
Yes
2091
3027
06/07/2013
Schematic Plan
$1,250.00
Yes
2101
3022
07/14/2013
Schematic Plan
$4,500.00
Yes
2102
3022
11/15/2013
Construction Documents
$12,000.00
Yes
2103
3022
07/14/2014
Construction Observation
$5,500.00
Yes
2111
3021
10/12/2013
Schematic Landscape Plan
$4,500.00
Yes
2112
3021
11/12/2013
Permitting
$3,000.00
Yes
2113
3021
09/02/2014
Construction Documents
$12,000.00
No
2114
3021
09/05/2015
Construction Observation
$8,500.00
No
2121
3034
09/28/2013
Community Meetings
$3,500.00
Yes
2122
3034
12/28/2013
Schematic Design
$5,500.00
Yes
2131
3035
10/18/2013
Community Meetings
$4,500.00
Yes
2132
3035
03/28/2014
Schematic Design
$6,000.00
Yes
2141
3031
02/03/2014
Schematic Open Space Plan
$7,500.00
Yes
2142
3031
06/03/2014
Planting Plans
$16,000.00
Yes
2143
3031
10/03/2014
Layout Plans
$16,000.00
No
2144
3031
08/03/2015
Construction Observation
$9,000.00
No
2151
3030
08/11/2013
Schematic Plan
$1,500.00
Yes
2152
3030
10/15/2013
Construction Documents
$2,250.00
Yes
2153
3030
03/30/2014
Construction Observation
$1,500.00
Yes
2161
3032
09/10/2013
Schematic Plan
$2,500.00
Yes
2162
3032
10/12/2013
Planting Plan
$2,500.00
Yes
2163
3032
11/12/2013
Construction Details
$1,500.00
Yes
2171
3037
02/22/2014
Community Meetings & Coordination
$8,000.00
Yes
2172
3037
06/22/2014
Schematic Plan
$15,000.00
Yes
2173
3037
02/24/2015
Construction Documents
$30,000.00
No
2174
3037
03/20/2016
Construction Admin. & Observation
$15,000.00
No
2181
3038
10/22/2013
Community Meetings
$3,000.00
Yes
2182
3038
12/22/2013
Schematic Plan
$8,000.00
Yes
2183
3038
06/23/2014
Construction Documents
$15,000.00
Yes
2184
3038
04/27/2015
Construction Admin. & Observation
$8,000.00
No
2191
3033
09/29/2013
Schematic Plan
$2,250.00
Yes
2201
3040
01/12/2014
Schematic Landscape Plan
$8,500.00
Yes
2202
3040
08/26/2014
Construction Documents
$18,000.00
No
2203
3040
09/17/2015
Construction Admin. & Observation
$12,000.00
No
2211
3043
01/11/2014
Schematic Landscape Plan
$5,500.00
Yes
2212
3043
06/20/2014
Construction Documents
$10,500.00
Yes
2213
3043
03/30/2015
Construction Observation
$3,000.00
No
2221
3044
06/17/2014
Construction Documents
$15,500.00
Yes
2222
3044
05/01/2015
Construction Admin. & Observation
$10,000.00
No
2231
3045
12/22/2014
Schematic Plans
$18,000.00
No
2232
3045
08/15/2015
Community Meetings
$7,000.00
No
2241
3050
10/18/2013
Schematic Plan
$1,000.00
Yes
2251
3046
09/09/2013
Consultation
$300.00
Yes
2261
3053
09/22/2013
Consultation
$375.00
Yes
2271
3048
12/28/2013
Schematic Design
$1,500.00
Yes
2272
3048
02/28/2014
Permitting
$1,000.00
Yes
2273
3048
06/30/2014
Landscape Planting & Lighting Plan
$3,500.00
Yes
2274
3048
09/26/2014
Construction Observation
$1,500.00
No
2281
3056
09/30/2014
Construction Documents
$20,000.00
No
2282
3056
08/14/2015
Construction Admin. & Observation
$12,500.00
No
2291
3057
01/31/2014
Schematic Design
$4,000.00
Yes
2292
3057
06/30/2014
Construction Documents
$8,000.00
Yes
2293
3057
03/30/2015
Construction Observation
$3,500.00
No
2301
3051
03/07/2014
Schematic Landscape Plan
$5,500.00
Yes
2302
3051
07/07/2014
Construction Documents
$9,000.00
Yes
2303
3051
05/03/2015
Construction Observation
$3,500.00
No
2311
3060
12/21/2013
Schematic Plan
$1,500.00
Yes
2312
3060
05/27/2014
Planting & Materials Plan
$2,500.00
Yes
2321
3061
06/28/2014
Schematic Open Space Plan
$6,000.00
Yes
2322
3061
10/26/2014
Permitting
$3,000.00
No
2323
3061
04/25/2015
Construction Documents
$15,000.00
No
2324
3061
06/27/2016
Construction Observation
$6,800.00
No
2331
3062
06/10/2014
Schematic Landscape Plan
$6,000.00
Yes
2332
3062
11/14/2014
Construction Documents
$10,000.00
No
2333
3062
05/11/2015
Construction Observation
$4,000.00
No
2341
3063
03/21/2014
Schematic Plan
$1,750.00
Yes
2351
3065
06/03/2014
Community Meetings
$4,000.00
Yes
2352
3065
12/05/2014
Schematic Plan
$9,500.00
No
2353
3065
08/03/2015
Construction Documents
$15,000.00
No
2354
3065
08/01/2016
Construction Admin. & Observation
$9,500.00
No
2361
3068
04/21/2014
Schematic Plan
$1,500.00
Yes
2362
3068
07/07/2014
Planting & Materials Plan
$3,000.00
Yes
2371
3069
06/09/2014
Schematic Plan
$3,750.00
Yes
2372
3069
07/29/2014
Permitting
$2,500.00
Yes
2373
3069
09/23/2014
Planting Plan
$7,000.00
No
2374
3069
10/24/2014
Lighting Plans
$2,500.00
No
2381
3070
09/06/2014
Community Meetings
$3,500.00
No
2382
3070
01/03/2014
Schematic Plan
$8,500.00
No
2383
3070
11/05/2015
Construction Documents
$14,000.00
No
2384
3070
07/08/2016
Construction Observation
$9,000.00
No
2391
3071
12/09/2014
Schematic Plan
$8,500.00
No
2392
3071
03/12/2015
Community Meetings & Permitting
$4,500.00
No
2393
3071
03/11/2015
Construction Documents
$14,000.00
No
2394
3071
03/27/2017
Construction Observation
$10,000.00
No
2401
3072
11/10/2014
Schematic Plan
$12,000.00
No
2402
3072
09/13/2015
Construction Documents
$30,000.00
No
2403
3072
09/26/2016
Construction Admin. & Observation
$15,000.00
No
2411
3075
07/08/2014
Schematic Plan
$5,000.00
Yes
2412
3075
04/09/2015
Construction Documents
$8,000.00
No
2413
3075
09/27/2015
Construction Observation
$3,500.00
No
2421
3076
06/08/2014
Peer Plan Review
$5,000.00
Yes
2431
3080
08/03/2014
Schematic Design
$6,000.00
Yes
2432
3080
09/14/2014
Permitting
$1,500.00
No
2433
3080
02/15/2015
Planting Plan
$13,000.00
No
2434
3080
08/15/2015
Lighting Plans
$2,300.00
No
2441
3078
06/24/2014
Schematic Landscape Plan
$3,750.00
Yes
2442
3078
10/24/2014
Construction Documents
$7,500.00
No
2443
3078
06/25/2015
Construction Observation
$2,500.00
No
2451
3073
09/05/2015
Schematic Open Space & Landscape Plan
$45,000.00
No
2452
3073
05/06/2016
Community Meetings & Permitting
$25,000.00
No
2453
3073
05/05/2017
Construction Documents
$85,000.00
No
2454
3073
08/18/2018
Construction Admin. & Observation
$50,000.00
No
2461
3081
10/11/2014
Schematic Landscape Plan
$4,500.00
No
2462
3081
05/10/2015
Construction Documents
$12,000.00
No
2463
3081
10/18/2015
Construction Observation
$4,500.00
No
2471
3077
08/23/2014
Schematic Landscape Plan
$6,500.00
Yes
2481
3082
08/01/2014
Schematic Plan
$2,500.00
Yes
2482
3082
10/21/2014
Planting Plan
$2,500.00
No
2491
3090
10/14/2014
Community Meetings
$2,000.00
No
2492
3090
02/16/2015
Schematic Plan
$5,500.00
No
2493
3090
11/16/2015
Construction Documents
$12,000.00
No
2494
3090
09/09/2016
Construction Observation
$6,000.00
No
2501
3085
02/23/2015
Schematic Landscape Plan
$10,500.00
No
2502
3085
10/23/2015
Construction Documents
$26,000.00
No
2503
3085
08/26/2016
Construction Observation
$16,000.00
No
2511
3095
08/25/2014
Schematic Design
$3,000.00
Yes
2512
3095
03/29/2015
Construction Documents
$7,000.00
No
2513
3095
04/30/2016
Construction Observation
$4,500.00
No
2521
3086
10/11/2014
Schematic Landscape Plan
$4,750.00
No
2522
3086
03/12/2015
Construction Documents
$8,500.00
No
2523
3086
10/04/2015
Construction Observation
$4,000.00
No
2531
3098
12/15/2014
Schematic Landscape Plan
$8,000.00
No
2532
3098
03/15/2015
Community Meetings
$2,000.00
No
2533
3098
01/15/2016
Construction Documents
$17,000.00
No
2534
3098
07/15/2016
Construction Observation
$8,000.00
No
2541
3093
08/25/2014
Schematic Plan
$2,000.00
Yes
2542
3093
02/27/2015
Planting Plan
$3,000.00
No
2551
3099
12/23/2014
Schematic Landscape Design
$6,500.00
No
2561
3094
08/25/2014
Schematic Plan
$2,000.00
Yes
2562
3094
03/23/2015
Planting Plan
$3,000.00
No
2571
3104
09/28/2014
Schematic Plan
$2,000.00
No
2572
3104
01/27/2015
Planting & Materials Plan
$3,500.00
No
2581
3097
10/03/2014
Schematic Plan
$2,000.00
No
2582
3097
12/02/2014
Landscape Layout & Planting Plan
$4,000.00
No
2583
3097
04/20/2015
Construction Observation
$2,500.00
No
2591
3108
01/06/2015
Schematic Landscape Plan
$12,000.00
No
2592
3108
04/13/2015
Community Meetings
$3,000.00
No
2593
3108
02/15/2016
Construction Documents
$25,000.00
No
2594
3108
03/31/2017
Construction Observation
$10,000.00
No
2601
3100
03/08/2015
Schematic Landscape Design
$10,500.00
No
2611
3103
08/17/2015
Schematic Open Space & Landscape Plan
$45,000.00
No
2612
3103
08/16/2016
Community Meetings & Permitting
$25,000.00
No
2613
3103
12/17/2017
Construction Documents
$105,000.00
No
2614
3103
09/30/2019
Construction Admin. & Observation
$77,000.00
No
2621
3109
04/18/2015
Schematic Plan
$8,000.00
No
2622
3109
10/18/2015
Construction Documents
$18,000.00
No
2623
3109
09/23/2016
Construction Admin. & Observation
$15,000.00
No
2631
3101
11/28/2014
Schematic Plan
$2,500.00
No
2632
3101
12/28/2014
Permitting
$1,500.00
No
2633
3101
03/14/2015
Planting Plan
$4,000.00
No
2634
3101
05/15/2015
Lighting Plans
$1,500.00
No
2641
3105
10/24/2014
Schematic Plan
$2,000.00
No
2642
3105
05/25/2015
Planting Plan
$3,000.00
No
2651
3110
12/23/2014
Community Meetings
$4,000.00
No
2652
3110
02/24/2015
Schematic Plan
$9,500.00
No
2653
3110
12/21/2015
Construction Documents
$15,000.00
No
2654
3110
05/01/2017
Construction Admin. & Observation
$9,500.00
No
Access1/Tutorial/Landscape.bmp
Access1/Tutorial/Oren.accdb
ContractNum
CustomerID
ContractAmt
SigningDate
ContractType
3027
11008
¤ 1,250.00
2013-04-07
Schematic plan for back yard, residential
3030
11042
¤ 5,250.00
2013-06-11
Landscape plan for residential site
3031
11070
¤ 48,500.00
2013-06-03
Landscape design for multi-family housing
3032
11014
¤ 6,500.00
2013-06-22
Residential landscape plan
3033
11005
¤ 2,250.00
2013-07-08
Residential landscape plan for front yard
3034
11088
¤ 8,500.00
2013-05-28
Neighborhood park, nonprofit developer
3035
11088
¤ 10,500.00
2013-05-28
Neighborhood park, nonprofit developer
3037
11045
¤ 68,000.00
2013-06-22
Renovation of an existing city park
3038
11045
¤ 34,000.00
2013-06-22
Renovation of an existing playground at a city park
3040
11068
¤ 38,500.00
2013-07-27
Renovation of open space around public housing site
3043
11083
¤ 19,000.00
2013-08-11
Landscape design of open space around new campus building
3044
11075
¤ 25,500.00
2013-08-19
Handicap accessibility upgrades to public housing site
3045
11064
¤ 25,000.00
2013-08-20
Open space corridor planning at new transit station
3046
11048
¤ 300.00
2013-09-02
Consultation for back yard, residential
3048
11030
¤ 7,500.00
2013-09-23
Landscape design for restaurant site
3050
11015
¤ 1,000.00
2013-08-27
Schematic plan for back yard, residential
3051
11032
¤ 18,000.00
2013-10-05
Site layout and landscape design for residential site
3053
11049
¤ 375.00
2013-09-15
Consultation for front yard, residential
3056
11075
¤ 32,500.00
2013-09-30
Handicap accessibility upgrades to public housing site
3057
11075
¤ 15,500.00
2013-09-30
Handicap accessibility upgrades to public housing site
3060
11005
¤ 4,000.00
2013-11-30
Front walk and drive design, residential
3061
11070
¤ 30,800.00
2013-12-28
Landscape design for multi-family housing development
3062
11053
¤ 20,000.00
2014-01-11
Site layout and landscape design for residential site
3063
11015
¤ 1,750.00
2014-01-20
Landscape plan for front yard, residential
3065
11079
¤ 38,000.00
2014-02-03
Renovation of playground at elementary school
3068
11049
¤ 4,500.00
2014-02-07
Front walk and drive design, residential
3069
11030
¤ 15,750.00
2014-02-24
Landscape design for restaurant site
3070
11079
¤ 35,000.00
2014-03-03
Renovation of playground at elementary school
3071
11059
¤ 37,000.00
2014-03-11
Landscape design for affordable housing site
3072
11059
¤ 46,000.00
2014-03-11
Landscape design for affordable housing site
3073
11072
¤ 205,000.00
2014-05-05
Landscape plans for large-scale housing development
3075
11067
¤ 16,500.00
2014-04-08
Design of a playground for a daycare center
3076
11065
¤ 5,000.00
2014-04-08
Peer plan review for town
3077
11058
¤ 6,500.00
2014-05-17
Schematic landscape design for senior center
3078
11020
¤ 13,750.00
2014-04-25
Landscape design for business property
3080
11030
¤ 22,800.00
2014-04-14
Landscape design and site plan for restaurant site
3081
11071
¤ 21,000.00
2014-05-10
Landscape design for business property
3082
11060
¤ 5,000.00
2014-06-01
Residential landscape plan
3085
11068
¤ 52,500.00
2014-06-23
Open space & playground design for public housing site
3086
11054
¤ 17,250.00
2014-07-11
Landscape design for commercial property
3090
11079
¤ 25,500.00
2014-06-14
Renovation of playground at elementary school
3093
11085
¤ 5,000.00
2014-07-25
Residential landscape plan
3094
11015
¤ 5,000.00
2014-07-26
Front walk and drive design, residential
3095
11045
¤ 14,500.00
2014-06-29
Handicap accessibility upgrades to public housing site
3097
11080
¤ 8,500.00
2014-08-02
Landscape design for renovation of restaurant front entry
3098
11065
¤ 35,000.00
2014-07-15
Design of a small town park
3099
11067
¤ 6,500.00
2014-07-25
Schematic landscape design for daycare center
3100
11031
¤ 10,500.00
2014-08-08
Schematic landscape design for daycare center
3101
11030
¤ 9,500.00
2014-08-24
Landscape design for renovation of a restaurant site
3103
11087
¤ 252,000.00
2014-08-17
Landscape plans for large-scale housing development
3104
11073
¤ 6,500.00
2014-07-28
Front walk and drive design, residential
3105
11084
¤ 5,000.00
2014-08-24
Residential landscape plan
3108
11045
¤ 50,000.00
2014-08-02
Design of a small city park
3109
11059
¤ 41,000.00
2014-08-18
Landscape design for affordable housing site
3110
11079
¤ 38,000.00
2014-08-25
Renovation of playground at elementary school
Access1/Tutorial/Sarah.accdb
CustomerID
Company
Last
First
Phone
FaxNumber
Email
County
Web Page
Notes