Excel Assignment

ExcelFunctionsInClass2.xlsx

Home >Information Systems homework help >Excel Assignment

abs-rel

Student	Raw	Score	Curved	Exam Max	50
Abbey	47			Curve	1
Brian	33
Charles	42
David	36
Ellie	40
Francie	39
Garrison	21
Harry	49
Isobel	38
Jordan	42
Kari	43
Lauren	46
Matthew	37

1) Caculate the Score (as a percentage) by dividing the Raw column by the Exam Max. Format as needed. 2) Enter the number of raw points for the curve and calculate the Curved Score (as a percentage) by summing the raw value and the curve and dividing that value by the Exam Max. Format as needed. Explore Absolute Addressing & Named Ranges

IF-Data

Weekly Expense Report (Ryan Fallsworth)
Date	Entertaining Guest	Entertainment Reimbursement	General Expenses	Expenses Reimbursement	Total Reimbursement
1/22/17	Yes		$120.00		$1.00	Count of Reimbursements
1/23/17	Yes		$98.00		$0.00
1/24/17	No		$48.00		$1.00
1/25/17	Yes		$32.00		$0.00	Sum of Reimbursements
1/26/17	No		$129.00		$1.00
1/27/17	Yes		$199.00		$0.00
1/28/17	No		$87.00		$1.00

INSTRUCTIONS: Column C: Enter a formula using the IF() function in column C that will display $50.00 if the salesman was entertaining a guest and leave the cell blank if not. (NOTE: to compare TEXT DATA, you must enclose the text inside double quotes -- ie "Yes" or "No". To display the 50.00 -- do NOT enclose it inside quotes. Column E: Enter a formula using the IF() function in column E that will display the amount to reimburse of the general expenses shown in column D. The company rule is that they only reimburse up to $100. So if the value is greater than $100 -- you would only reimburse $100. If the amount is less than $100, you would reimburse the full amount - which is the value in column D. Column F: Add the value in column C to the value in Column E and display it in column F. Cell I4: Use the COUNT() function to count how many Entertainment reimbursements will be processed. Cell I7: Use the SUM() function to provide a total of the amount to be reimbursed.

CompIF

Student	Fees	Raw	Score	Pass?	Letter Grade	Scores >	Letter	CountIF	SumIF
Abbey	$ 2.00	47	94%		A	90%	A
Brian	$ - 0	33	66%		D	80%	B
Charles	$ 9.00	42	84%		B	70%	C
David	$ 16.00	36	72%		C	60%	D
Ellie	$ 5.00	40	80%		B	0%	F
Francie	$ 1.00	39	78%
Garrison	$ 13.00	21	42%
Harry	$ 17.00	49	98%
Isobel	$ 18.00	38	76%
Jordan	$ 7.00	42	84%
Kari	$ 15.00	43	86%
Lauren	$ 16.00	46	92%
Matthew	$ - 0	37	74%
Nick	$ 7.00	47	94%
Orlando	$ 13.00	16	32%
Peter	$ 9.00	9	18%
Quinn	$ 10.00	36	72%
Rachel	$ 19.00	25	50%
Sam	$ 13.00	11	22%
Thomas	$ 8.00	13	26%
Ulia	$ 15.00	30	60%
Vanessa	$ 13.00	23	46%
Walter	$ 19.00	27	54%
Yosefe	$ 8.00	45	90%
Zabrina	$ 3.00	28	56%

VLookUp

Student	Raw	Score	Pass?	Letter Grade	Message	Scores	Letter	Message
Abbey	47	94%				0.0%	F	See Me
Brian	33	66%				60.0%	D-	At Risk
Charles	42	84%				63.0%	D	Poor Performance
David	36	72%				67.0%	D+	Need Improvement
Ellie	40	80%				70.0%	C-	Below Average
Francie	39	78%				73.0%	C	Average Performance
Garrison	21	42%				77.0%	C+	A/B still in Reach
Harry	49	98%				80.0%	B-	Under performed
Isobel	38	76%				83.0%	B	Solid Performance
Jordan	42	84%				87.0%	B+	Well Done
Kari	43	86%				90.0%	A-	With Honors
Lauren	46	92%				93.0%	A	Top of your class!
Matthew	37	74%
Nick	47	94%
Orlando	16	32%
Peter	9	18%
Quinn	36	72%
Rachel	25	50%
Sam	11	22%
Thomas	13	26%
Ulia	30	60%
Vanessa	23	46%
Walter	27	54%
Yosefe	45	90%
Zabrina	28	56%

VLookup2

Friendly Grounds Coffee House
									Code	Variety	Price/Lb	Supplier
									BMT	Blue Mountain	$ 12.00	Fresh Market
Order #	First Name	Last Name	State	ItmCode	Variety	Price/lb.	Pounds	$ Sale	COL	Colombia	$ 5.00	Whole Foods
1001	Brenton	Hayashi	MI	ETH			5	$0	ETH	Ethiopia	$ 8.00	Trader Joe's
1002	Gregg	Socorro	CA	ETH			12	$0	JAV	Java	$ 7.00	Trader Joe's
1003	April	Beren	NY	BMT			11	$0	KON	Kona	$ 11.00	Whole Foods
1004	Rufus	Esquirel	LA	BMT			9	$0	SUM	Sumatra	$ 9.00	Fresh Thyme
1005	Kristen	Truesdell	GA	KON			10	$0
1006	Thad	Gaebler	MI	JAV			9	$0
1007	Rosella	Rheingold	CA	KON			8	$0
1008	Danna	Strevell	WI	BMT			11	$0
1009	Mildred	Knowlton	MA	KON			10	$0
1010	Andres	Reuter	OH	KON			9	$0
1011	Erik	Nocum	FL	KON			5	$0
1012	Hans	Gillund	MA	BMT			6	$0
1013	Sofia	Aurich	CA	BMT			12	$0
1014	Darrel	Hallack	IL	ETH			8	$0
1015	Hugh	Heide	MI	KON			7	$0
1016	Shelia	Oballe	NJ	BMT			9	$0
1017	Vincenzo	Hercules	MI	JAV			5	$0
1018	Moses	Pavlick	OH	COL			9	$0
1019	Haywood	Mccullen	CA	ETH			8	$0
1020	Carlos	Scheiern	MN	KON			6	$0
1021	Denis	Whitby	CA	COL			3	$0
1022	Shaun	Delille	CA	KON			9	$0
1023	Bessie	Loosle	MI	KON			6	$0
1024	Lauretta	Hergenreter	OH	BMT			3	$0
1025	Bernice	Gerchak	TX	SUM			7	$0
1026	Kelley	Eisenbarth	NY	BMT			6	$0
1027	Eunice	Heckendorf	OH	BMT			1	$0
1028	Bonita	Gottwald	CA	BMT			11	$0
1029	Malissa	Imada	CA	JAV			5	$0
1030	Paige	Belts	MI	ETH			1	$0
1031	Lance	Schut	CA	SUM			9	$0
1032	Bob	Arnholtz	AK	JAV			5	$0
1033	Juana	Tomjack	CA	KON			7	$0
1034	Rhonda	Vy	IL	ETH			9	$0
1035	Wilburn	Hindes	MI	ETH			7	$0
1036	Lavern	Trapper	NJ	BMT			8	$0
1037	Sanford	Micheals	NY	BMT			4	$0
1038	Elsie	Eloy	OH	KON			5	$0
1039	Nanette	Axsom	NJ	KON			11	$0
1040	Krystle	Boileau	WI	BMT			6	$0
1041	Sheila	Yielding	CA	COL			2	$0
1042	Frankie	Yarzabal	PA	KON			11	$0
1043	Caryn	Canelo	MI	KON			10	$0
1044	Leslie	Schornick	MI	ETH			2	$0
1045	Sung	Croutch	IN	BMT			11	$0
1046	Grace	Caillier	NY	BMT			6	$0
1047	Darla	Demaire	NY	ETH			4	$0
1048	Laurence	Loll	IN	BMT			12	$0
1049	Antoinette	Eisert	PA	BMT			12	$0
1050	Dominick	Barz	CA	JAV			11	$0
1051	Rex	Novi	CA	KON			12	$0
1052	Harry	Blakeslee	CA	KON			9	$0
1053	Yesenia	Andreadis	TX	ETH			6	$0
1054	Lewis	Penhall	NY	KON			3	$0
1055	Solomon	Trader	FL	COL			9	$0
1056	Lupe	Zumpfe	NY	BMT			8	$0
1057	Ivory	Norgard	NJ	BMT			4	$0
1058	Jess	Altsisi	MI	KON			4	$0
1059	Dewey	Gardella	MI	JAV			3	$0
1060	Jonas	Pollet	CA	BMT			7	$0
1061	Jermaine	Belles	CA	BMT			3	$0
1062	William	Stehle	NJ	KON			11	$0
1063	Jerrell	Muthana	CA	BMT			6	$0
1064	Lionel	Demuzio	LA	BMT			5	$0
1065	Cari	Jividen	PA	JAV			7	$0
1066	Elias	Shams	PA	ETH			3	$0
1067	Gayle	Giesy	NY	JAV			11	$0
1068	Celestine	Reuther	FL	KON			10	$0
1069	Kerri	Tingle	IN	BMT			7	$0
1070	Chelsea	Moberley	CO	ETH			4	$0
1071	Van	Gallion	PA	KON			10	$0
1072	Iona	Sibbett	NJ	BMT			9	$0
1073	Rico	Goltz	NY	BMT			3	$0
1074	Myrna	Kloster	MI	BMT			2	$0
1075	Eileen	Badura	MI	SUM			7	$0
1076	Eddie	Bugay	NY	BMT			4	$0
1077	Rebecca	Cathie	GA	KON			6	$0
1078	Gregorio	Mcmannus	FL	ETH			3	$0
1079	Faith	Coody	CO	KON			8	$0
1080	Louise	Hickie	AZ	BMT			6	$0
1081	Leon	Histand	WA	BMT			3	$0
1082	Joel	Grismore	VA	BMT			5	$0
1083	Maximo	Brzycki	IN	BMT			4	$0
1084	Marcellus	Niebla	NY	JAV			2	$0
1085	Melba	Mikita	CA	BMT			9	$0
1086	Tyron	Peveto	FL	BMT			6	$0
1087	Donovan	Medlock	NJ	ETH			6	$0
1088	Foster	Stranger	NV	BMT			12	$0
1089	Tiffani	Sculley	MA	BMT			9	$0
1090	Travis	Cragle	IL	BMT			1	$0
1091	Hiram	Wallin	NY	KON			7	$0
1092	Loretta	Pickell	CA	BMT			12	$0
1093	Margie	Laganga	MD	KON			5	$0
1094	Albert	Mansour	CA	JAV			9	$0
1095	Preston	Cheu	NY	JAV			3	$0
1096	Goldie	Gronowski	OH	JAV			7	$0
1097	Charla	Tausch	CA	KON			3	$0
1098	Robert	Branen	MO	BMT			1	$0
1099	Noe	Dacus	NY	JAV			7	$0
1100	Maritza	Applen	PA	BMT			11	$0
1101	Benedict	Beser	MA	BMT			7	$0
1102	Lucius	Isaak	NY	ETH			11	$0
1103	Maria	Mohabir	CT	BMT			4	$0
1104	Eloise	Grasman	ID	SUM			3	$0
1105	Aline	Taverna	IL	JAV			8	$0
1106	Genevieve	Herzog	CA	BMT			10	$0
1107	Elsie	Deveaux	MA	KON			9	$0
1108	Owen	Gabrielli	NY	KON			12	$0
1109	Barbara	Saraceno	MI	SUM			10	$0
1110	Corine	Quinoes	NJ	ETH			6	$0
1111	Delia	Simi	CA	ETH			4	$0
1112	Collin	Kloster	FL	ETH			5	$0
1113	Tommie	Guffey	MI	JAV			5	$0
1114	Guillermina	Kirsopp	CA	KON			5	$0
1115	Yvette	Schoemaker	CA	SUM			10	$0
1116	Hollis	Pedone	CA	KON			7	$0
1117	Rueben	Ketteringham	NJ	ETH			11	$0
1118	Glenn	Westenbarger	LA	KON			9	$0
1119	Bess	Brooker	MD	ETH			2	$0
1120	Bryon	Gubitosi	MI	KON			5	$0
1121	Jude	Flynn	NY	BMT			9	$0
1122	Lashonda	Prins	CT	SUM			12	$0
1123	Colton	Buike	TX	ETH			1	$0
1124	Claude	Booten	NJ	BMT			11	$0
1125	Ruben	Dodgen	NV	KON			10	$0
1126	Charla	Scoma	CA	BMT			9	$0
1127	Lakesha	Catello	OH	KON			2	$0
1128	Danette	Dirico	WV	KON			6	$0
1129	Francis	Shore	CA	BMT			12	$0
1130	Cortez	Hofford	TX	KON			12	$0
1131	Kristy	Halma	CA	COL			3	$0
1132	Geraldine	Falconer	CA	JAV			12	$0
1133	Emilio	Argueta	NY	SUM			9	$0
1134	Andreas	Menousek	IA	COL			3	$0
1135	Deidra	Nunnelee	MO	BMT			4	$0
1136	Ann	Drullard	FL	JAV			4	$0
1137	Marvin	Pernesky	FL	BMT			7	$0
1138	Cathy	Weinmann	MI	BMT			6	$0
1139	Nora	Asif	PA	ETH			11	$0
1140	Jody	Bourgois	CA	KON			8	$0
1141	Rudy	Murrish	GA	JAV			2	$0
1142	Deirdre	Cusatis	NY	COL			2	$0
1143	Brad	Titman	CA	KON			1	$0
1144	Maria	Scammahorn	CO	KON			12	$0
1145	Donnell	Parslow	WI	KON			5	$0
1146	Bob	Kramarczyk	CA	SUM			2	$0
1147	Misty	Guerino	FL	JAV			3	$0
1148	Kimberlee	Roys	NH	BMT			1	$0
1149	Elena	Swackhammer	CA	COL			11	$0
1150	Ricky	Jacques	CO	BMT			6	$0
1151	Ione	Garitty	CT	ETH			9	$0
1152	Wes	Beile	CA	ETH			12	$0
1153	Freddie	Too	OH	KON			9	$0
1154	Kari	Antenor	GA	BMT			9	$0
1155	Cliff	Bolon	CA	KON			1	$0
1156	Jeffrey	Hudmon	CA	JAV			11	$0
1157	Estelle	Squyres	NM	BMT			9	$0
1158	Ariel	Rawlinson	MI	KON			9	$0
1159	Len	Burkhart	NC	BMT			9	$0
1160	Fran	Kuchinski	TX	ETH			12	$0
1161	Hollis	Crofton	UT	ETH			7	$0
1162	Jeannette	Dexter	CO	KON			11	$0
1163	Leona	Cease	NY	BMT			12	$0
1164	Cecil	Stehlin	CA	COL			2	$0
1165	Caitlin	Sisneros	CA	BMT			5	$0
1166	Mary	Niederhauser	NY	KON			7	$0
1167	Maryanne	Sersen	NY	BMT			6	$0
1168	Taryn	Top	FL	SUM			6	$0
1169	Antionette	Kile	GA	ETH			7	$0
1170	Coleman	Carstarphen	PA	BMT			3	$0
1171	Otha	Temp	WY	KON			8	$0
1172	Arthur	Bergh	NY	KON			10	$0
1173	Janine	Wicka	CA	KON			2	$0
1174	Mara	Argue	MI	ETH			9	$0
1175	Eunice	Dettinger	PA	BMT			8	$0
1176	Corinne	Schlote	CA	KON			8	$0
1177	Jared	Millie	UT	COL			8	$0
1178	Clinton	Yellow	PA	KON			11	$0
1179	Janette	Gahan	NJ	BMT			3	$0
1180	Chet	Legendre	FL	KON			9	$0
1181	Nancy	Foulger	MN	BMT			12	$0
1182	Iva	Bowin	NY	JAV			5	$0
1183	Jackie	Friehauf	OH	ETH			2	$0
1184	Mayra	Vermeesch	TX	KON			12	$0
1185	Wilson	Mowatt	CA	COL			10	$0
1186	Kristopher	Kanzenbach	WI	KON			5	$0
1187	Abram	Goldfeld	HI	KON			1	$0
1188	Helga	Nydam	VT	ETH			9	$0
1189	Ambrose	Kippes	IL	BMT			7	$0
1190	Daisy	Carosiello	MN	ETH			9	$0
1191	Brian	Topolski	CA	KON			9	$0
1192	Marisol	Tecson	PA	ETH			8	$0
1193	Patty	Mazzoni	FL	SUM			7	$0
1194	Aron	Reddic	NY	BMT			2	$0
1195	Leif	Lueder	NJ	BMT			8	$0
1196	Pearl	Cristal	CA	JAV			9	$0
1197	Cortney	Lamango	CA	BMT			8	$0
1198	Cruz	Bequette	IL	BMT			2	$0
1199	Yong	Stoudamire	KS	ETH			5	$0

MultiSheets

Code	Variety	Price/Lb	Supplier
BMT	Blue Mountain	$ 12.00	Fresh Market
COL	Colombia	$ 5.00	Whole Foods
ETH	Ethiopia	$ 8.00	Trader Joe's
JAV	Java	$ 7.00	Trader Joe's
KON	Kona	$ 11.00	Whole Foods
SUM	Sumatra	$ 9.00	Fresh Thyme

Match

Friendly Grounds Coffee House
	Value	Row
Using the List of values in worksheet Vlookup2-Column A -- What row contains the value:	1013

Text

Banner, Adrian	123 Main Street, Toledo, OH 43601
Church, Rhiannon	44 County Rd. 1, Wabash, IN 38123
Davis, John	6769 Oakdale, Mentor, OH 44060
Edwards, Jillian	111 Stirling Way, Etna, OH 43062
	Text To Columns
	Upper
	Lower
	Left
	Right
	Mid
	Search
	Concatenate
	Trim

Exercise-1

Month	Type of Sale	SalesManID	SalesMan	Units Sold	Sales	Bonus	Commission	1) lookup the SalesManID from column C - and display the corresponding name in Column D
Jan	Clothing	2		1291	$ 384.10			2) Calculate a 1% bonus to be awarded for sales exceeding 500 units.
Sep	Sporting	2		2631	$ 265.11			3) count and sum the number of bonuses paid
Aug	Office Supplies	4		608	$ 402.94			4) calculate commission, using the commission rate from the salesman table
May	Sporting	1		2178	$ 116.57			5) complete the following tables			SalesMan Table
Jan	Sporting	8		396	$ 39.90						SalesManID	Name	Commision Rate
Apr	Electronics	1		1354	$ 314.63			Count of Bonuses			1	Adams	2.50%
Jan	Sporting	8		951	$ 284.66			Sum of Bonuses			2	Brown	1.50%
May	Hardware	8		2506	$ 151.82						3	Clark	3.00%
Nov	Hardware	4		205	$ 238.26			Type of Sale	Count of Sales	Sum of Sales	4	Devoe	2.75%
May	Office Supplies	4		1295	$ 230.66			Clothing			5	Edwards	3.25%
Jul	Electronics	7		462	$ 90.14			Electronics			6	Fisher	1.25%
Feb	Hardware	5		1658	$ 179.39			Hardware			7	Grubb	2.00%
Oct	Clothing	3		1274	$ 233.83			Office Supplies			8	Hamilton	3.00%
Mar	Office Supplies	3		1677	$ 283.89			Sporting
Dec	Hardware	2		162	$ 171.80
May	Hardware	7		1207	$ 107.93
Mar	Hardware	7		1261	$ 359.95
Apr	Electronics	3		1389	$ 200.23
Feb	Electronics	1		2074	$ 63.66
May	Hardware	2		2620	$ 278.19
Jun	Clothing	2		2603	$ 32.99
Jan	Office Supplies	2		1980	$ 27.10
Sep	Office Supplies	7		1396	$ 78.60
Dec	Office Supplies	3		686	$ 243.02
Aug	Electronics	2		2061	$ 263.99
Jul	Sporting	8		589	$ 399.05
Jul	Sporting	6		2596	$ 178.12
Jun	Sporting	8		1196	$ 243.06
Nov	Clothing	8		322	$ 262.14
Sep	Clothing	3		1863	$ 139.80
Jan	Hardware	3		31	$ 399.21
Jan	Office Supplies	6		1455	$ 335.75
Feb	Sporting	5		2714	$ 72.65
Mar	Electronics	1		957	$ 80.74
Jun	Office Supplies	3		1374	$ 402.15
Aug	Sporting	7		2490	$ 185.54
Oct	Sporting	1		2157	$ 2.06
Nov	Clothing	5		1658	$ 319.39
Sep	Clothing	8		1406	$ 219.85
Nov	Clothing	4		666	$ 283.34
Feb	Clothing	3		80	$ 284.55
Dec	Sporting	4		1200	$ 257.87
Dec	Office Supplies	1		327	$ 333.76
Jul	Electronics	1		158	$ 404.61
Jan	Office Supplies	1		589	$ 228.04
Aug	Clothing	7		1448	$ 359.82
Jul	Hardware	6		947	$ 309.18
Feb	Clothing	6		564	$ 32.22
Aug	Hardware	6		197	$ 147.91
Jul	Clothing	5		1760	$ 50.38
Sep	Office Supplies	6		381	$ 92.58
Nov	Electronics	7		1672	$ 209.57
Jul	Hardware	6		1906	$ 167.72
Jan	Clothing	7		1202	$ 149.12
Aug	Electronics	2		2503	$ 62.10
Mar	Clothing	1		2594	$ 355.86
Apr	Office Supplies	6		1049	$ 193.17
Dec	Electronics	7		2684	$ 368.78
May	Clothing	8		1159	$ 326.51
Jun	Electronics	3		1200	$ 291.17
Mar	Hardware	7		1301	$ 83.19
Sep	Sporting	2		43	$ 87.22
Dec	Sporting	8		2159	$ 150.17
Jul	Clothing	8		792	$ 186.57
Dec	Office Supplies	3		2699	$ 185.49
May	Clothing	4		2319	$ 96.41
Dec	Clothing	6		831	$ 15.65
Nov	Sporting	4		1018	$ 331.44
Oct	Electronics	8		2591	$ 380.30
Dec	Office Supplies	8		1523	$ 25.19
Apr	Sporting	2		2043	$ 211.79
May	Electronics	8		228	$ 336.54
Feb	Clothing	2		2690	$ 166.32
May	Clothing	1		539	$ 328.95
Jul	Hardware	4		1085	$ 51.11
Jul	Clothing	2		1920	$ 56.42
Jan	Hardware	1		276	$ 269.00
Dec	Office Supplies	6		572	$ 422.96
Nov	Hardware	4		496	$ 168.95
Dec	Hardware	8		1051	$ 166.11
Jan	Sporting	6		1045	$ 101.65
Feb	Hardware	6		2669	$ 422.22
Feb	Electronics	6		2178	$ 71.43
Sep	Hardware	7		2300	$ 403.38
Mar	Office Supplies	8		901	$ 288.77
Mar	Sporting	1		2688	$ 51.48
Jul	Hardware	8		613	$ 381.51
Apr	Electronics	1		508	$ 171.24
Feb	Office Supplies	6		219	$ 309.37
May	Electronics	2		1698	$ 332.47
Aug	Hardware	3		287	$ 4.73
Aug	Clothing	6		47	$ 29.61
Sep	Clothing	1		970	$ 380.53
Jan	Clothing	2		2683	$ 11.57
Jun	Office Supplies	1		2223	$ 143.53
Apr	Clothing	5		959	$ 270.77
May	Clothing	5		1405	$ 49.94
Jul	Office Supplies	1		2688	$ 345.75
Sep	Clothing	4		1690	$ 145.66
Mar	Clothing	5		1086	$ 174.72
Aug	Hardware	4		2271	$ 218.89
Jan	Office Supplies	7		1485	$ 354.54
Oct	Clothing	8		2398	$ 199.58
Sep	Sporting	7		1664	$ 289.62
Sep	Sporting	1		1683	$ 388.09
Jul	Clothing	6		51	$ 11.45
Jun	Clothing	5		466	$ 380.20
Dec	Electronics	4		658	$ 208.50

Ex-2 Instructions

Instructions: Use the necessary Text Functions to convert the data into a more usable form. For most of these requirements, you will need to create a new column of data using a text function(s). Then, Copy and Paste Values over to the worksheet Exercise-2 Solution, rebuilding the data column by column. Leave the work-in-process columns in the Exercise-2 worksheet with your formulas intact. 1) In Column A -- extract the ACH Batch# -- which is the number that is between the ach and the dash.. for example: ach9000185-019 has a batch number of 9000185 and a sequence# of 019 2) Display the Creditor name in UPPER case 3) Display the Account# as the 16 digit number 4) Split the client name into its first and last segments 5) Split the achdate into Year, Month and Day.

Exercise-2

ach_batch	credit_no	creditor	client_no	acct	budget_pay	fairshr	type	client	achdate
ach9000185-019	20000	sears-boise rccoc	26097	1.15005E+12	13	10	3	finn , gheinar	20120805
ach9000185-022	20000	sears-boise rccoc	26006	1150078385137	20	10	3	good , monica	20120804
ach9000185-045	20000	sears-boise rccoc	26118	1150035463811	20	10	3	otto , james	20120805
ach9000185-046	20000	sears-boise rccoc	26035	174049064036	45	10	3	phillips , travis	20120805
ach9000185-048	20000	sears-boise rccoc	30239	178815949817	45	10	3	policoff , brenda	20120804
ach9000185-050	20000	sears-boise rccoc	26043	1150046109221	11	10	3	robertson , donald	20120805
ach9000185-059	20000	sears-boise rccoc	30127	172158666740	65	10	3	wolfrum , terry	20120805
ach9000185-077	20001	greenwood trust	26110	6.01100564058186E+15	135	7	3	ebraheim , nagwa	20120805
ach9000185-079	20001	greenwood trust	30214	6.01100539014041E+15	27	7	3	fairchild , stacey	20120804
ach9000185-0114	20002	gecs/canton/montgomery wards	26110	573443969	26	7	3	ebraheim , nagwa	20120805
ach9000185-0125	20003	gecs/canton/jc penney	26098	3705803033	27	7	3	chiles , dennis	20120804
ach9000185-0134	20003	gecs/canton/jc penney	26124	12803482341	50	7	3	jaynes , dorothea	20120805
ach9000185-0181	30006	bank of america	26118	4.35649000946393E+15	20	7	3	otto , james	20120805
ach9000185-0196	30022	hfc/hrs usa/rps	26080	64360031617	15	6	3	mccarthy , mary	20120804
ach9000185-0220	30028	chase cardmember services	26080	5.2603152100323E+15	40	5	3	mccarthy , mary	20120804
ach9000185-0225	30028	chase cardmember services	26023	5.49104251092443E+15	185	5	3	spangler , marcia	20120805
ach9000185-0233	30028	chase cardmember services	30127	5.36993326000192E+15	20	5	3	wolfrum , terry	20120805
ach9000185-0239	30031	citibank	26126	4.4328440209044E+15	45	8	3	baumle , jodi	20120803
ach9000185-0250	30031	citibank	26110	4.12800382601219E+15	115	8	3	ebraheim , nagwa	20120805
ach9000185-0252	30031	citibank	26128	5.42418017684443E+15	95	8	3	french , joy	20120805
ach9000185-0267	30031	citibank	30239	4.12800318110848E+15	42	8	3	policoff , brenda	20120804
ach9000185-0272	30031	citibank	26046	4.12800377025922E+15	61	8	3	shiffler , andrea	20120805
ach9000185-0274	30031	citibank	26023	5.42418045202508E+15	95	8	3	spangler , marcia	20120805
ach9000185-0295	30031	citibank	30127	4.1280027319723E+15	40	8	3	wolfrum , terry	20120805
ach9000185-0316	30041	mbna america	26128	5.20001002050994E+15	400	0	1	french , joy	20120805
ach9000185-0328	30041	mbna america	26046	4.31308051000326E+15	51	0	1	shiffler , andrea	20120805
ach9000185-0345	30081	capital one	26126	4.3886420295564E+15	20	9	3	baumle , jodi	20120803
ach9000185-0354	30081	capital one	26057	5.29115141643234E+15	50	9	3	domagala , michael	20120805
ach9000185-0392	30081	capital one	26043	4.30572213350228E+15	15	9	3	robertson , donald	20120805
ach9000185-0401	30081	capital one	26023	7.81260185555775E+15	265	9	3	spangler , marcia	20120805
ach9000185-0402	30081	capital one	26023	4.30572184434167E+15	150	9	3	spangler , marcia	20120805
ach9000185-0415	30081	capital one	30127	4.12174135167003E+15	36	9	3	wolfrum , terry	20120805
ach9000185-0424	30135	citibank universal card/ at&t	26110	5.39882010326774E+15	33	8	3	ebraheim , nagwa	20120805
ach9000185-0425	30135	citibank universal card/ at&t	26128	5.49113034921851E+15	20	8	3	french , joy	20120805
ach9000185-0426	30135	citibank universal card/ at&t	26128	5.49113034921677E+15	210	8	3	french , joy	20120805
ach9000185-0432	30135	citibank universal card/ at&t	30239	5.3984300249907E+15	53	8	3	policoff , brenda	20120804
ach9000185-0436	30135	citibank universal card/ at&t	26023	5.4911303174845E+15	75	8	3	spangler , marcia	20120805
ach9000185-0447	30166	first usa bank, n.a.	5972	4250095229370	288.42	7.65	3	beatty , gary	20120805
ach9000185-0457	30166	first usa bank, n.a.	30214	4443063975237	20	7.65	3	fairchild , stacey	20120804
ach9000185-0458	30166	first usa bank, n.a.	26128	4.26650360457879E+15	150	7.65	3	french , joy	20120805
ach9000185-0459	30166	first usa bank, n.a.	26011	5.41712244219931E+15	200	7.65	3	gruver , heather	20120805
ach9000185-0462	30166	first usa bank, n.a.	30252	4.24615200846981E+15	433.24	7.65	3	kinder , tina	20120805
ach9000185-0478	30166	first usa bank, n.a.	30239	4.26650300801574E+15	76	7.65	3	policoff , brenda	20120804
ach9000185-0525	30292	citibank (south dakota)n.a.	26110	5.41931059028286E+15	45	8	3	ebraheim , nagwa	20120805
ach9000185-0527	30292	citibank (south dakota)n.a.	6430	5.41972740200158E+15	100	8	3	garmon , regina	20120805
ach9000185-0572	30433	direct merchants cdt card bank	26072	5.45800451421686E+15	37	7	3	hill , angie	20120805
ach9000185-0576	30433	direct merchants cdt card bank	26080	5.45800450808161E+15	67	7	3	mccarthy , mary	20120804
ach9000185-0581	30433	direct merchants cdt card bank	30239	5.45800190012377E+15	20	7	3	policoff , brenda	20120804
ach9000185-0583	30433	direct merchants cdt card bank	26043	5.45800402214237E+15	30	7	3	robertson , donald	20120805
ach9000185-0620	70125	united creditors alliance	26128	371519111821005	100	8	3	french , joy	20120805
ach9000185-0631	81099	hfc/bfc/rps-16#	26126	5.4079120592078E+15	15	0	1	baumle , jodi	20120803
ach9000185-0635	81099	hfc/bfc/rps-16#	26098	5.43700020025727E+15	300	0	1	chiles , dennis	20120804
ach9000185-0636	81099	hfc/bfc/rps-16#	26098	5.46702000047068E+15	132	0	1	chiles , dennis	20120804
ach9000185-0643	81099	hfc/bfc/rps-16#	26057	5.48042000913225E+15	85	0	1	domagala , michael	20120805
ach9000185-0654	81099	hfc/bfc/rps-16#	26080	5.43339000289306E+15	26	0	1	mccarthy , mary	20120804
ach9000185-0660	81099	hfc/bfc/rps-16#	26118	4.40561035430924E+15	15	0	1	otto , james	20120805
ach9000185-0661	81099	hfc/bfc/rps-16#	26035	5.46702000115682E+15	120	0	1	phillips , travis	20120805
ach9000185-0662	81099	hfc/bfc/rps-16#	26043	5.48042000717893E+15	20	0	1	robertson , donald	20120805
ach9000185-0669	81099	hfc/bfc/rps-16#	26053	5.4404500663184E+15	25	0	1	vasko , doris	20120805
ach9000185-0675	81150	wfnnb/rps	26006	5.85637500460533E+15	15	10	3	good , monica	20120804
ach9000185-0681	81376	gecs/canton/lowes	26006	82221361872548	20	7	3	good , monica	20120804
ach9000185-0684	81376	gecs/canton/lowes	26035	82222360054104	36	7	3	phillips , travis	20120805
ach9000185-0695	81672	providian/high line	30152	4.42847057520967E+15	99	10	3	hinschlager , charles	20120805
ach9000185-0706	81760	us bank,co/rps	26080	4.19000108594993E+15	35	5	3	mccarthy , mary	20120804
ach9000185-0708	81829	bankfirst of s.d./rps	26072	5.42477084260295E+15	20	4	3	hill , angie	20120805
ach9000185-0709	81829	bankfirst of s.d./rps	26072	4.77721084422612E+15	20	4	3	hill , angie	20120805
ach9000185-0713	81829	bankfirst of s.d./rps	26046	5.4247708123162E+15	42	4	3	shiffler , andrea	20120805
ach9000185-0714	81829	bankfirst of s.d./rps	26046	4.77721084613786E+15	40	4	3	shiffler , andrea	20120805
ach9000185-0719	82109	axsys national bank/fingerhut	26070	8.05005172309641E+15	45	10	3	franklin , janet	20120804
ach9000185-0722	82109	axsys national bank/fingerhut	26118	8.05010183909107E+15	38	10	3	otto , james	20120805
ach9000185-0723	82109	axsys national bank/fingerhut	26046	8.0501019418531E+15	36	10	3	shiffler , andrea	20120805
ach9000185-0724	82109	axsys national bank/fingerhut	26046	8.05010193178729E+15	19	10	3	shiffler , andrea	20120805
ach9000185-0736	82363	hfc/bfc installment/rps	5755	651745005195427	105	0	1	machcinski , shirley	20120805
ach9000185-0759	82643	hurley state bank/rps	26072	6.01176720124191E+15	30	8	3	hill , angie	20120805
ach9000185-0790	83358	providian/low line	26070	4.46569180042188E+15	35	10	3	franklin , janet	20120804
ach9000185-0791	83358	providian/low line	26006	4.5595408008395E+15	30	10	3	good , monica	20120804
ach9000185-0792	83358	providian/low line	26072	4.46569040069325E+15	80	10	3	hill , angie	20120805
ach9000185-0793	83358	providian/low line	26072	4.03113090042275E+15	85	10	3	hill , angie	20120805
ach9000185-0794	83358	providian/low line	26002	4.47947150057732E+15	35	10	3	johnson , albert	20120804
ach9000185-0795	83358	providian/low line	26002	4.5595022006137E+15	35	10	1	johnson , albert	20120804
ach9000185-0805	83358	providian/low line	26046	5.54285210060477E+15	61	10	3	shiffler , andrea	20120805
ach9000185-0806	83358	providian/low line	26046	4.03117450125257E+15	46	10	3	shiffler , andrea	20120805
ach9000185-0810	83358	providian/low line	26053	4.03113150095236E+15	75	10	3	vasko , doris	20120805
ach9000185-0819	83399	wfnnb/express	26006	498848506	25	10	3	good , monica	20120804
ach9000185-0823	83400	wfnnb/victorias secret	26098	592656490	15	10	3	chiles , dennis	20120804
ach9000185-0825	83400	wfnnb/victorias secret	26006	884558149	15	10	3	good , monica	20120804
ach9000185-0830	83402	wfnnb/brylane home	26019	68914837	15	10	3	hayward , phyllis	20120805
ach9000185-0832	83403	wfnnb/chadwicks	26097	146102835	10	10	3	finn , gheinar	20120805
ach9000185-0839	83404	wfnnb/lerners	26019	573504768	15	10	3	hayward , phyllis	20120805
ach9000185-0842	83405	wfnnb/roamans	26019	67718577	10	10	3	hayward , phyllis	20120805
ach9000185-0844	83407	wfnnb/abercrombie & fitch	26006	802728543	15	10	3	good , monica	20120804
ach9000185-0847	83416	wfnnb/lane bryant	26019	67458943	15	10	3	hayward , phyllis	20120805
ach9000185-0854	83555	gecs/canton/banana republic	26006	6.01859004044615E+15	15	7	3	good , monica	20120804
ach9000185-0855	83585	target (visa) financial svcs.	26046	4.35237339161988E+15	63	9	3	shiffler , andrea	20120805
ach9000186-0856	20000	sears-boise rccoc	26101	1150000956526	20	10	3	allman , scott	20120811
ach9000186-0857	20000	sears-boise rccoc	26101	168457730062	41	10	3	allman , scott	20120811
ach9000186-0896	20000	sears-boise rccoc	30241	7087164618522	80	10	3	maynard , daniel	20120810
ach9000186-0901	20000	sears-boise rccoc	26049	1150074944168	39	10	3	miesle , thomas	20120812
ach9000186-0911	20000	sears-boise rccoc	26074	7087101595411	36	10	3	ruiz , alicia	20120812
ach9000186-0912	20000	sears-boise rccoc	26145	8060513860011	25	10	3	ruiz , antonio	20120812
ach9000186-0927	20001	greenwood trust	30022	6.0110054425299E+15	45	7	3	cereghin , marjorie	20120812
ach9000186-0928	20001	greenwood trust	26064	6.01100501025141E+15	65	7	3	clark , jeffrey	20120812
ach9000186-0941	20001	greenwood trust	30247	6.01100553011953E+15	50	7	3	harris , melissa	20120811
ach9000186-0942	20001	greenwood trust	26010	6.01100574021298E+15	20	7	3	helf , gary	20120811
ach9000186-0946	20001	greenwood trust	30241	6.01100538005468E+15	148	7	3	maynard , daniel	20120810
ach9000186-0947	20001	greenwood trust	26028	6.01100557025353E+15	25	7	3	mccants , anika	20120811
ach9000186-0958	20001	greenwood trust	26074	6.01100542063733E+15	45	7	3	ruiz , alicia	20120812
ach9000186-0959	20001	greenwood trust	26145	6.01100517067825E+15	35	7	3	ruiz , antonio	20120812
ach9000186-0974	20003	gecs/canton/jc penney	26143	1177235254	80	7	3	brown , jean	20120812
ach9000186-0975	20003	gecs/canton/jc penney	26031	700777477	16	7	3	enderlin , robert	20120812
ach9000186-0976	20003	gecs/canton/jc penney	26078	1267333365	32	7	3	foust , gerald	20120811
ach9000186-0978	20003	gecs/canton/jc penney	26076	630567006	15	7	3	haffelder , william	20120811
ach9000186-0984	20003	gecs/canton/jc penney	26028	3400677278	15	7	3	mccants , anika	20120811
ach9000186-0985	20003	gecs/canton/jc penney	26125	1481171286	20	7	3	michael , daniel	20120807
ach9000186-01000	20058	target	26064	931435900190	19	9	3	clark , jeffrey	20120812
ach9000186-01001	20058	target	26031	940876115690	30	9	3	enderlin , robert	20120812
ach9000186-01003	20058	target	26127	923243667390	20	9	3	garrett , renee	20120811
ach9000186-01005	20058	target	26028	923140196590	15	9	3	mccants , anika	20120811
ach9000186-01007	20096	shoppers charge/rps	26143	8.92008220019405E+15	75	10	3	brown , jean	20120812
ach9000186-01012	30022	hfc/hrs usa/rps	26101	7.00116400097415E+15	30	6	3	allman , scott	20120811
ach9000186-01013	30022	hfc/hrs usa/rps	30213	7.10156800016169E+15	14	6	3	brellahan , edward/amy	20120811
ach9000186-01018	30022	hfc/hrs usa/rps	26074	7.10158800000507E+15	36	6	3	ruiz , alicia	20120812
ach9000186-01019	30022	hfc/hrs usa/rps	30280	72366727955	291.23	6	3	seibenick , pamela	20120812
ach9000186-01021	30022	hfc/hrs usa/rps	26095	7.00119111095185E+15	30	6	3	slagle , mame	20120812
ach9000186-01025	30024	ge capital-rps	26064	5.34819002269043E+15	10	8	3	clark , jeffrey	20120812
ach9000186-01027	30028	chase cardmember services	30012	5.36993385004979E+15	23	5	3	bott , clarence	20120811
ach9000186-01037	30028	chase cardmember services	26058	5.42228008001492E+15	55	5	3	gower , edna	20120810
ach9000186-01051	30031	citibank	30022	5.42418040570005E+15	25	8	3	cereghin , marjorie	20120812
ach9000186-01052	30031	citibank	26064	5.42418029789203E+15	134	8	3	clark , jeffrey	20120812
ach9000186-01056	30031	citibank	26058	4.12800278183359E+15	105	8	3	gower , edna	20120810
ach9000186-01064	30031	citibank	26028	5.42418032331402E+15	80	8	3	mccants , anika	20120811
ach9000186-01074	30031	citibank	26074	5.42418022728045E+15	250	8	3	ruiz , alicia	20120812
ach9000186-01083	30041	mbna america	26101	5.32901051301135E+15	70	0	1	allman , scott	20120811
ach9000186-01085	30041	mbna america	26143	5.32902475501428E+15	55	0	1	brown , jean	20120812
ach9000186-01087	30041	mbna america	26031	4.26429623701567E+15	360	0	3	enderlin , robert	20120812
ach9000186-01090	30041	mbna america	26078	74990135104746	115	0	1	foust , gerald	20120811
ach9000186-01091	30041	mbna america	26078	5.32904193731472E+15	195	0	3	foust , gerald	20120811
ach9000186-01096	30041	mbna america	26010	74981074398704	75	0	3	helf , gary	20120811
ach9000186-01105	30041	mbna america	26115	5.32905439615483E+15	25	0	1	mims , ralph	20120807
ach9000186-01111	30041	mbna america	30246	4.31308475300017E+15	350	0	1	vorthman , robert	20120811
ach9000186-01112	30041	mbna america	30121	74994012001223	125	0	1	walz , mary	20120810
ach9000186-01115	30081	capital one	26088	5.29115210752614E+15	25	9	3	adams , christina	20120812
ach9000186-01148	30081	capital one	26085	4.12174163469334E+15	25	9	3	mims , gloria	20120812
ach9000186-01152	30081	capital one	26067	5.29107148076868E+15	20	9	3	muncy , lisa	20120812
ach9000186-01166	30081	capital one	26099	5.29107137347465E+15	30	9	3	salkil , kevin	20120812
ach9000186-01167	30081	capital one	30280	4.38864133143571E+15	2468.73	9	3	seibenick , pamela	20120812
ach9000186-01171	30081	capital one	26095	5.5700918569544E+15	20	9	3	slagle , mame	20120812
ach9000186-01174	30081	capital one	26157	5.57009183238835E+15	10	9	3	sylvester , pearlie	20120812
ach9000186-01175	30081	capital one	26157	5.30758205070587E+15	25	9	3	sylvester , pearlie	20120812
ach9000186-01190	30135	citibank universal card/ at&t	30280	5.49113009201227E+15	2371.96	8	3	seibenick , pamela	20120812
ach9000186-01225	30166	first usa bank, n.a.	30280	4.36612000790675E+15	597.6	7.65	3	seibenick , pamela	20120812
ach9000186-01231	30166	first usa bank, n.a.	30246	4.24615200561903E+15	80	7.65	3	vorthman , robert	20120811
ach9000186-01237	30170	first premier bank	26087	5.17800709237348E+15	20	10	3	ibarra , jose	20120811
ach9000186-01240	30228	national city card svs-rps	26078	4.48950251011278E+15	60	10	3	foust , gerald	20120811
ach9000186-01241	30228	national city card svs-rps	26076	4.43601314006971E+15	45	10	3	haffelder , william	20120811
ach9000186-01243	30228	national city card svs-rps	26074	4.31196758001018E+15	171	10	3	ruiz , alicia	20120812
ach9000186-01245	30290	peoples bank/credit card plan	30241	5.41214600628505E+15	125	8	3	maynard , daniel	20120810
ach9000186-01248	30292	citibank (south dakota)n.a.	26143	5.45715004902072E+15	165	8	3	brown , jean	20120812
ach9000186-01264	30292	citibank (south dakota)n.a.	26115	4.22398015692612E+15	20	8	3	mims , ralph	20120807
ach9000186-01270	30292	citibank (south dakota)n.a.	26145	4.22398007916603E+15	45	8	3	ruiz , antonio	20120812
ach9000186-01278	30318	wachovia/first usa/rps	26031	4.11816030304167E+15	185	7.65	3	enderlin , robert	20120812
ach9000186-01285	30382	fnanb	26095	1.72720421084235E+15	15	7	3	slagle , mame	20120812
ach9000186-01289	30433	direct merchants cdt card bank	30213	5.42775303102198E+15	76	7	3	brellahan , edward/amy	20120811
ach9000186-01295	30433	direct merchants cdt card bank	26151	5.45800124500723E+15	75	7	3	droszcz , lawrence	20120811
ach9000186-01299	30433	direct merchants cdt card bank	26078	5.45800010805229E+15	58	7	3	foust , gerald	20120811
ach9000186-01318	30439	wachovia/first usa/rps	3663	4.68121195017118E+15	60	7.65	3	link , betty	20120811
ach9000186-01323	30451	fleet/advanta	30247	5.44718030304448E+15	25	10	3	harris , melissa	20120811
ach9000186-01338	70125	united creditors alliance	26117	372763305231006	96	8	3	cruz , christine	20120811
ach9000186-01339	70125	united creditors alliance	26076	373736743483008	104	8	3	haffelder , william	20120811
ach9000186-01341	70125	united creditors alliance	26125	373958513681005	30	8	3	michael , daniel	20120807
ach9000186-01347	81099	hfc/bfc/rps-16#	26101	5.48042000547318E+15	110	0	1	allman , scott	20120811
ach9000186-01366	81099	hfc/bfc/rps-16#	26095	5.40801000723047E+15	20	0	1	slagle , mame	20120812
ach9000186-01367	81099	hfc/bfc/rps-16#	30246	5.49945381012603E+15	105	0	1	vorthman , robert	20120811
ach9000186-01368	81099	hfc/bfc/rps-16#	30121	5.4323590001041E+15	230	0	1	walz , mary	20120810
ach9000186-01371	81150	wfnnb/rps	26117	2901098315	15	10	3	cruz , christine	20120811
ach9000186-01372	81150	wfnnb/rps	26087	5.85637050158138E+15	10	10	3	ibarra , jose	20120811
ach9000186-01373	81150	wfnnb/rps	26087	5.85637072775728E+15	15	10	3	ibarra , jose	20120811
ach9000186-01378	81376	gecs/canton/lowes	26117	82221360134890	50	7	3	cruz , christine	20120811
ach9000186-01383	81566	gecs/canton/home depot/hdbrc	26103	5191851571611	30	7	3	cox , james	20120812
ach9000186-01385	81566	gecs/canton/home depot/hdbrc	26087	5191850475806	20	7	3	ibarra , jose	20120811
ach9000186-01387	81567	gecs/canton/sam's club/scbrc	26064	7710540787736	50	7	3	clark , jeffrey	20120812
ach9000186-01388	81567	gecs/canton/sam's club/scbrc	26031	7710747740470	52	7	3	enderlin , robert	20120812
ach9000186-01391	81672	providian/high line	26074	4.42856160280017E+15	197	10	3	ruiz , alicia	20120812
ach9000186-01395	81829	bankfirst of s.d./rps	26058	5.42477083593555E+15	27	4	3	gower , edna	20120810
ach9000186-01396	81829	bankfirst of s.d./rps	26049	4.77721084629532E+15	20	4	3	miesle , thomas	20120812
ach9000186-01397	81829	bankfirst of s.d./rps	26049	5.42477084363607E+15	22	4	3	miesle , thomas	20120812
ach9000186-01405	82109	axsys national bank/fingerhut	26127	8.05005189194384E+15	15	10	3	garrett , renee	20120811
ach9000186-01409	82109	axsys national bank/fingerhut	26049	8.05005155995767E+15	40	10	3	miesle , thomas	20120812
ach9000186-01413	82363	hfc/bfc installment/rps	26064	650197001220604	130	0	1	clark , jeffrey	20120812
ach9000186-01414	82363	hfc/bfc installment/rps	26066	651397001024126	75	0	1	day , eric	20120807
ach9000186-01421	82445	gecs/canton/walmart	26151	6.03220329998745E+15	40	10	3	droszcz , lawrence	20120811
ach9000186-01423	82445	gecs/canton/walmart	26087	6.03220731054805E+15	25	10	3	ibarra , jose	20120811
ach9000186-01424	82445	gecs/canton/walmart	26157	6.0322075509398E+15	10	10	3	sylvester , pearlie	20120812
ach9000186-01429	82643	hurley state bank/rps	26103	7.75215970141322E+15	220	8	3	cox , james	20120812
ach9000186-01430	82643	hurley state bank/rps	26066	6.0117677033311E+15	50	8	3	day , eric	20120807
ach9000186-01431	82643	hurley state bank/rps	26031	7.75301006423014E+15	32	8	3	enderlin , robert	20120812
ach9000186-01434	82643	hurley state bank/rps	26087	7.75215980119035E+15	10	8	3	ibarra , jose	20120811
ach9000186-01435	82643	hurley state bank/rps	26087	6.0116613043692E+15	10	8	3	ibarra , jose	20120811
ach9000186-01460	83358	providian/low line	26064	4.55953250021357E+15	40	10	3	clark , jeffrey	20120812
ach9000186-01479	83358	providian/low line	26049	4.4656703009249E+15	82	10	3	miesle , thomas	20120812
ach9000186-01480	83358	providian/low line	26085	4.3614703005813E+15	80	10	3	mims , gloria	20120812
ach9000186-01481	83358	providian/low line	26085	4.03117450106693E+15	50	10	3	mims , gloria	20120812
ach9000186-01484	83358	providian/low line	26067	4.55950200062959E+15	35	10	3	muncy , lisa	20120812
ach9000186-01492	83358	providian/low line	26099	4.25449210056339E+15	60	10	3	salkil , kevin	20120812
ach9000186-01505	83399	wfnnb/express	26028	493080071	10	10	3	mccants , anika	20120811
ach9000186-01507	83399	wfnnb/express	26095	488767807	20	10	3	slagle , mame	20120812
ach9000186-01509	83403	wfnnb/chadwicks	26143	130884083	20	10	3	brown , jean	20120812
ach9000186-01510	83403	wfnnb/chadwicks	26127	137550950	15	10	3	garrett , renee	20120811
ach9000186-01514	83404	wfnnb/lerners	26028	585072689	10	10	3	mccants , anika	20120811
ach9000186-01515	83405	wfnnb/roamans	26157	795542166	10	10	3	sylvester , pearlie	20120812
ach9000186-01519	83416	wfnnb/lane bryant	26157	795024504	10	10	3	sylvester , pearlie	20120812
ach9000186-01521	83585	target (visa) financial svcs.	26125	4.35237338854848E+15	105	9	3	michael , daniel	20120807
ach9000187-01523	20000	sears-boise rccoc	30196	168622460181	250	10	3	marroquin , celeste	20120813
ach9000187-01524	20000	sears-boise rccoc	26026	172174009321	60	10	3	smith , charles	20120813
ach9000187-01525	20000	sears-boise rccoc	26068	167211146938	28	10	3	smith , christina	20120814
ach9000187-01527	20001	greenwood trust	30214	6.01100539014041E+15	23.18	7	3	fairchild , stacey	20120813
ach9000187-01535	30028	chase cardmember services	30196	5.36990026908275E+15	101	5	3	marroquin , celeste	20120813
ach9000187-01541	30031	citibank	26026	5.42418041422796E+15	225	8	3	smith , charles	20120813
ach9000187-01542	30031	citibank	26026	5.42418044277734E+15	216	8	3	smith , charles	20120813
ach9000187-01547	30081	capital one	26051	5.29107164039983E+15	69	9	3	hill , tina	20120814
ach9000187-01548	30081	capital one	26051	4.38864202955659E+15	30	9	3	hill , tina	20120814
ach9000187-01558	30081	capital one	26026	5.2910714475402E+15	25	9	3	smith , charles	20120813
ach9000187-01560	30166	first usa bank, n.a.	30214	4443063975237	30	7.65	3	fairchild , stacey	20120813
ach9000187-01563	30292	citibank (south dakota)n.a.	26145	4.22398007916503E+15	45	8	3	ruiz , antonio	20120817
ach9000187-01564	30292	citibank (south dakota)n.a.	26068	4.22398003244429E+15	150	8	3	smith , christina	20120814
ach9000187-01567	40027	hfc/bfc revolving/rps	26156	65179500513324	40	0	1	stewart , amy	20120814
ach9000187-01569	70125	united creditors alliance	26026	371262987892004	65	8	3	smith , charles	20120813
ach9000187-01572	81150	wfnnb/rps	26026	2901116760	10	10	3	smith , charles	20120813
ach9000187-01573	81829	bankfirst of s.d./rps	26026	4.77721084625643E+15	30	4	3	smith , charles	20120813
ach9000187-01577	82445	gecs/canton/walmart	26107	6.03220707066344E+15	25	10	3	simpson , diana	20120814
ach9000187-01578	83358	providian/low line	26107	4.55954160058699E+15	30	10	3	simpson , diana	20120814
ach9000187-01579	83358	providian/low line	26026	4.25449040131498E+15	60	10	3	smith , charles	20120813
ach9000187-01580	83358	providian/low line	26026	4.47945059973778E+15	85	10	3	smith , charles	20120813
ach9000188-01584	20000	sears-boise rccoc	26014	167187540791	45	10	3	baum , shannon	20120819
ach9000188-01592	20000	sears-boise rccoc	26108	174046856327	40	10	3	davis , william	20120819
ach9000188-01594	20000	sears-boise rccoc	26084	168601251197	35	10	3	everett , nancy	20120818
ach9000188-01600	20000	sears-boise rccoc	26114	1150079862811	50	10	3	kiss , michelle	20120819
ach9000188-01603	20000	sears-boise rccoc	26012	167029682777	67	10	3	logan , teri	20120819
ach9000188-01604	20000	sears-boise rccoc	26042	1150081105423	25	10	3	lopez , marisol	20120819
ach9000188-01636	20001	greenwood trust	26084	6.01100547060241E+15	45	7	3	everett , nancy	20120818
ach9000188-01642	20001	greenwood trust	26136	6.01100519066631E+15	25	7	3	gibson , giles	20120818
ach9000188-01651	20001	greenwood trust	26017	6.01100553019472E+15	75	7	3	jorgensen , kristen	20120819
ach9000188-01652	20001	greenwood trust	26041	6.01100556029049E+15	102	7	3	kelley , terrance	20120819
ach9000188-01674	20001	greenwood trust	26146	6.01100559022322E+15	30	7	3	williams , candace	20120819
ach9000188-01696	20057	marshall fields	26084	377784490290	10	9	3	everett , nancy	20120818
ach9000188-01697	20057	marshall fields	26084	377784490210	20	9	3	everett , nancy	20120818
ach9000188-01701	20058	target	26122	915870112790	15	9	3	franklin , bettina	20120819
ach9000188-01738	30028	chase cardmember services	26017	5.49104289144726E+15	210	5	3	jorgensen , kristen	20120819
ach9000188-01742	30028	chase cardmember services	26012	5.49104166033714E+15	110	5	3	logan , teri	20120819
ach9000188-01743	30028	chase cardmember services	26012	5.26031141006682E+15	88	5	3	logan , teri	20120819
ach9000188-01755	30028	chase cardmember services	30249	5.26021000128131E+15	62	5	3	young , dorothy	20120819
ach9000188-01766	30031	citibank	26084	5.42418048680634E+15	75	8	3	everett , nancy	20120818
ach9000188-01767	30031	citibank	26136	5.42418050052173E+15	35	8	3	gibson , giles	20120818
ach9000188-01769	30031	citibank	26007	4.12800322663074E+15	70	8	3	heath , catherine	20120819
ach9000188-01779	30031	citibank	26012	5.42418039538203E+15	149	8	3	logan , teri	20120819
ach9000188-01780	30031	citibank	26012	5.42418052224789E+15	28	8	3	logan , teri	20120819
ach9000188-01802	30031	citibank	26146	5.42418036865244E+15	23	8	3	williams , candace	20120819
ach9000188-01803	30031	citibank	26146	5.42418033158873E+15	33	8	3	williams , candace	20120819
ach9000188-01817	30041	mbna america	30041	5.32902173305796E+15	95	0	1	fitzwater , tina	20120819
ach9000188-01820	30041	mbna america	26136	4.31302467005441E+15	110	0	1	gibson , giles	20120818
ach9000188-01822	30041	mbna america	26041	5.49099073600565E+15	135	0	3	kelley , terrance	20120819
ach9000188-01841	30081	capital one	26088	5.29115210752614E+15	25	4	3	adams , christina	20120818
ach9000188-01842	30081	capital one	26088	5.2910714894411E+15	25	4	3	adams , christina	20120818
ach9000188-01942	30081	capital one	26157	5.30758205070587E+15	25	4	3	sylvester , pearlie	20120818
ach9000188-01943	30081	capital one	26157	5.57009183238835E+15	10	4	3	sylvester , pearlie	20120818
ach9000188-01950	30081	capital one	30249	4.12174130694289E+15	78	4	3	young , dorothy	20120819
ach9000188-01957	30135	citibank universal card/ at&t	26133	5.3988390422792E+15	135	8	3	shordt , brandi	20120818
ach9000188-01959	30142	credit first n.a.	26084	825089624	16	13	3	everett , nancy	20120818
ach9000188-01966	30166	first usa bank, n.a.	30041	4.41712807231245E+15	80	7.65	3	fitzwater , tina	20120819
ach9000188-01973	30166	first usa bank, n.a.	26017	4.36616304504041E+15	190	7.65	3	jorgensen , kristen	20120819
ach9000188-01974	30166	first usa bank, n.a.	30252	4.24615200846981E+15	175	7.65	3	kinder , tina	20120819
ach9000188-01993	30166	first usa bank, n.a.	30249	4.41712597037888E+15	194	7.65	3	young , dorothy	20120819
ach9000188-02019	30292	citibank (south dakota)n.a.	26114	4.62120116336142E+15	20	8	3	kiss , michelle	20120819
ach9000188-02027	30292	citibank (south dakota)n.a.	26090	5.41931086032219E+15	65	8	3	scurles , richard	20120818
ach9000188-02034	30292	citibank (south dakota)n.a.	26146	4.22398021064248E+15	15	8	3	williams , candace	20120819
ach9000188-02035	30292	citibank (south dakota)n.a.	26146	5.41931059533925E+15	40	8	3	williams , candace	20120819
ach9000188-02051	30433	direct merchants cdt card bank	26012	5.4580045023557E+15	163	7	3	logan , teri	20120819
ach9000188-02052	30433	direct merchants cdt card bank	26090	5.45800018001524E+15	224	7	3	scurles , richard	20120818
ach9000188-02053	30433	direct merchants cdt card bank	26037	5.458004540085E+15	25	7	3	sifers , terry	20120819
ach9000188-02058	30438	fleet b	30249	4.12450024040933E+15	212	10	3	young , dorothy	20120819
ach9000188-02083	81099	hfc/bfc/rps-16#	26084	5.43235415105668E+15	160	0	1	everett , nancy	20120818
ach9000188-02088	81099	hfc/bfc/rps-16#	26065	5.40791205371026E+15	15	0	1	jones , annie	20120819
ach9000188-02090	81099	hfc/bfc/rps-16#	26042	5.4079120520543E+15	25	0	1	lopez , marisol	20120819
ach9000188-02094	81099	hfc/bfc/rps-16#	26146	5.48042000984307E+15	25	0	1	williams , candace	20120819
ach9000188-02101	81150	wfnnb/rps	26037	5.85637072677135E+15	15	10	3	sifers , terry	20120819
ach9000188-02106	81566	gecs/canton/home depot/hdbrc	26084	5179570028880	10	7	3	everett , nancy	20120818
ach9000188-02121	82109	axsys national bank/fingerhut	26065	8.05005169325032E+15	62	10	3	jones , annie	20120819
ach9000188-02122	82109	axsys national bank/fingerhut	26042	8.05005180749774E+15	20	10	3	lopez , marisol	20120819
ach9000188-02135	82445	gecs/canton/walmart	26137	6.03220701005872E+15	20	10	3	hess , rose	20120819
ach9000188-02141	82643	hurley state bank/rps	26065	6.01176701098289E+15	25	8	3	jones , annie	20120819
ach9000188-02142	82643	hurley state bank/rps	26114	6.03525102471852E+15	15	8	3	kiss , michelle	20120819
ach9000188-02149	82942	gecs/best buy-rps	26065	6.0191700169874E+15	15	8	3	jones , annie	20120819
ach9000188-02154	83339	gecs/canton/old navy	26133	6.01859601188653E+15	20	7	3	shordt , brandi	20120818
ach9000188-02165	83358	providian/low line	26108	5.40979090061948E+15	30	10	3	davis , william	20120819
ach9000188-02166	83358	providian/low line	26108	4.55954030052617E+15	50	10	3	davis , william	20120819
ach9000189-02278	30006	bank of america	26013	4.31903000661612E+15	25	7	3	mccoy , christine	20120826
ach9000189-02282	30022	hfc/hrs usa/rps	26052	7.0010670027187E+15	25	6	3	gray , steven	20120826
ach9000189-02292	30028	chase cardmember services	2951	4.26277003668289E+15	137	5	3	elquez (enriqueta), marie	20120825
ach9000189-02293	30028	chase cardmember services	2951	5.26021001547272E+15	60	5	3	elquez (enriqueta), marie	20120825
ach9000189-02342	30041	mbna america	6213	74980028003691	40	0	3	irons , patricia	20120826
ach9000189-02371	30081	capital one	26013	4.38864171837462E+15	15	4	3	mccoy , christine	20120826
ach9000189-02372	30081	capital one	26013	5.57009185791845E+15	15	4	2	mccoy , christine	20120826
ach9000189-02373	30081	capital one	26013	4.38864188477423E+15	35	4	3	mccoy , christine	20120826
ach9000189-02386	30081	capital one	6272	4.1217413499733E+15	220	4	3	walters , brenda	20120826
ach9000189-02391	30135	citibank universal card/ at&t	26032	5.39880001924465E+15	25	8	3	richardson , kevin	20120825
ach9000189-02392	30135	citibank universal card/ at&t	6272	5.39870000050291E+15	90	8	3	walters , brenda	20120826
ach9000189-02395	30142	credit first n.a.	26089	516195193	10	13	3	waggoner , lisa	20120826
ach9000189-02396	30166	first usa bank, n.a.	30230	5.28630800122955E+15	100	7.65	3	ankney(hanna) , danielle	20120826
ach9000189-02422	30170	first premier bank	26152	4.6100784515395E+15	15	10	3	echelbarger , janet	20120825
ach9000189-02432	30228	national city card svs-rps	2951	5.48250251000548E+15	50	10	3	elquez (enriqueta), marie	20120825
ach9000189-02440	30292	citibank (south dakota)n.a.	2951	5.45715005020196E+15	70	8	3	elquez (enriqueta), marie	20120825
ach9000189-02442	30292	citibank (south dakota)n.a.	26052	4.31795101703535E+15	150	8	3	gray , steven	20120826
ach9000189-02447	30292	citibank (south dakota)n.a.	26013	4.31795703506009E+15	30	8	3	mccoy , christine	20120826
ach9000189-02451	30292	citibank (south dakota)n.a.	26089	4.62120094900167E+15	28	8	3	waggoner , lisa	20120826
ach9000189-02491	81099	hfc/bfc/rps-16#	26021	5.43857000125381E+15	20	0	1	ellis , jeffry	20120826
ach9000189-02492	81099	hfc/bfc/rps-16#	2951	5.43700030249309E+15	60	0	1	elquez (enriqueta), marie	20120825
ach9000189-02521	81760	us bank,co/rps	6213	4.19008081820984E+15	55	5	3	irons , patricia	20120826
ach9000189-02524	81829	bankfirst of s.d./rps	26077	4.777210846368E+15	40	4	3	hackney , robbin	20120824
ach9000189-02525	81829	bankfirst of s.d./rps	26077	5.42477023044739E+15	33	4	3	hackney , robbin	20120824
ach9000189-02544	82942	gecs/best buy-rps	26077	6.0191700137272E+15	30	8	3	hackney , robbin	20120824
ach9000189-02546	83358	providian/low line	26152	4.47941172490242E+15	50	10	3	echelbarger , janet	20120825
ach9000189-02547	83358	providian/low line	26021	4.47945290023042E+15	70	10	3	ellis , jeffry	20120826
ach9000189-02548	83358	providian/low line	26077	4.03117450286403E+15	35	10	3	hackney , robbin	20120824
ach9000189-02552	83358	providian/low line	26013	4.55954060075812E+15	30	10	3	mccoy , christine	20120826
ach9000190-02577	20000	sears-boise rccoc	5948	174006718061	125	10	3	haase , amy	20120828
ach9000190-02579	20000	sears-boise rccoc	26111	1150058497548	20	10	3	kniceley , gary	20120828
ach9000190-02581	20000	sears-boise rccoc	26016	6052635526382	15	10	3	leach , roy	20120828
ach9000190-02582	20000	sears-boise rccoc	26016	1150058892789	15	10	3	leach , roy	20120828
ach9000190-02589	20000	sears-boise rccoc	26030	1150023628847	50	10	3	sherry , christopher	20120828
ach9000190-02599	20001	greenwood trust	26162	6.01100542061828E+15	50	7	3	mccoy , jennifer	20120827
ach9000190-02600	20001	greenwood trust	26018	6.01100553017086E+15	45	7	3	mcgibney , michael	20120828
ach9000190-02620	20003	gecs/canton/jc penney	26016	11373379501	10	7	3	leach , roy	20120828
ach9000190-02632	20184	lazarus	26056	402731007	15	10	3	derr , pamela	20120828
ach9000190-02651	30028	chase cardmember services	26047	5.26340003310028E+15	136	5	3	pemberton , james	20120828
ach9000190-02693	30041	mbna america	26162	5.32905419103666E+15	55	0	1	mccoy , jennifer	20120827
ach9000190-02702	30081	capital one	26150	4.38864205956239E+15	65	4	3	barnes , angelina	20120827
ach9000190-02716	30081	capital one	26016	4.12174149437717E+15	25	4	3	leach , roy	20120828
ach9000190-02723	30081	capital one	26132	4.38864185850318E+15	15	4	3	reimer , david	20120828
ach9000190-02729	30135	citibank universal card/ at&t	26018	5.49113001804396E+15	115	8	3	mcgibney , michael	20120828
ach9000190-02731	30135	citibank universal card/ at&t	26047	5.39880001090321E+15	76	8	3	pemberton , james	20120828
ach9000190-02742	30166	first usa bank, n.a.	5948	5.54453030500176E+15	40	7.65	3	haase , amy	20120828
ach9000190-02759	30188	wells fargo financial/dial	26016	4.38884000517628E+15	67	5	3	leach , roy	20120828
ach9000190-02766	30292	citibank (south dakota)n.a.	26056	4.6165707201753E+15	45	8	3	derr , pamela	20120828
ach9000190-02767	30292	citibank (south dakota)n.a.	5948	5.45715002190205E+15	50	8	3	haase , amy	20120828
ach9000190-02768	30292	citibank (south dakota)n.a.	5948	4.30531003011095E+15	35	8	3	haase , amy	20120828
ach9000190-02780	30382	fnanb	26056	1.72720410546667E+15	18	7	3	derr , pamela	20120828
ach9000190-02785	30433	direct merchants cdt card bank	26016	5.45800000590601E+15	112	7	3	leach , roy	20120828
ach9000190-02787	30433	direct merchants cdt card bank	26047	5.41058110200369E+15	185	7	3	pemberton , james	20120828
ach9000190-02817	81173	gecs/canton/home shopping network	26056	286600348857	15	7	3	derr , pamela	20120828
ach9000190-02832	82445	gecs/canton/walmart	26016	6.03220739058379E+15	15	10	3	leach , roy	20120828
ach9000190-02848	83358	providian/low line	26150	4.25448260058489E+15	95	10	3	barnes , angelina	20120827
ach9000190-02854	83358	providian/low line	26111	4.36147140069688E+15	30	10	3	kniceley , gary	20120828
ach9000190-02855	83358	providian/low line	26111	4.25449090064419E+15	90	10	3	kniceley , gary	20120828
ach9000190-02859	83358	providian/low line	26132	4.36147080066735E+15	30	10	3	reimer , david	20120828
ach9000190-02860	83358	providian/low line	26132	4.03113200067071E+15	85	10	3	reimer , david	20120828
ach9000190-02864	83399	wfnnb/express	26162	4875793020	10	9	3	mccoy , jennifer	20120827
ach9000190-02869	83400	wfnnb/victorias secret	26056	297560997	10	9	3	derr , pamela	20120828
ach9000190-02874	83409	wfnnb/avenue	26056	143148765	10	9	3	derr , pamela	20120828
ach9000190-02878	83546	gecs/canton/casual corner	26056	6.00898101925715E+15	23	7	3	derr , pamela	20120828

Exercise-2 Solution

ACH Batch

ACH Seq#

Creditor

Acct#

Client First

Client Last

Year

Month

Day