Here are some details you need to complete the file. 1. You will need to add a column and create a function that calculates Cash Flow based on criteria from Type. Create an IF statement that returns a negative cash flow (looks like ($500.00) for example) if the type was a Withdrawal. For all other types, the cash flow should be positive. 2. In running your pivot tables, some suggestions are to look at things like branch, account type, customer, etc. These are suggestions only. You will probably run more than just those types. Remember to run more than just SUMs in your pivot tables. You can also run MIN, MAX, COUNT, PERCENT and more. Run at least different 3 pivot tables, saving each as a separate sheet with each tab descriptively labeled (For example: Pivot 1, Pivot 2, etc.), and include those pivot tables as images in your Word document report. (One final tip, don't forget about time such as dates and days of the week in your analysis and data set.) F25 X fx-17$D$2:$D$35=$D$14,-E25, E25) 6 17 8 New New Current 2 16300 9400 1100 200 1300 800 3880 Current Current 0 31 122 13 14 Current 910 Current Current New 1400 36 47 18 N 50 51 52 55555 2 Saturday 2-Aur Saturday -Aug Saturday 2-Aug Saturday 2-Aug Saturday 2-Aug Saturday -Aug Saturday 2-Aug Saturday 2-Aug Saturday 4-Aug Monday 4-Aug Monday 4-Aug Monday 4-Aug Monday 4-Aug Monday 4-Aug Monday 4-Aug Monday 4-Aug Monday 4-Aur Monday 4-Aug Monday 4-Aug Monday 4-Aug Monday 4-Aug Monday 4-Aug Monday 4-Aug Monday 4-Aug Monday 4 Aug Monday 4 Aug Monday 4-Aug Monday 4-Aug Monday 4.Aug Monday 4. Aug Monday 4 Aug Monday 4-Aug Monday 4. Aug Monday 4-Aug Monday 4 Aug Monday 4. Aug Monday 4. Aug Monday 4. Aug Monday 4-Aug Monday 4 Aug Monday 4 Aug Monday 4. Aug Monday Certificate of Deposit Certificate of Deposit Swing Savings Savings Savings Checiding Checking C hecking Savings Savings TRA Checking C hecking Checking Checking Checking Checking C hecking C hecking Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit Savings Savings Savings Savings Savings Savings Savings Savings IRA Checking Checking Checking Checking Checking Checking Checking Certificate of Deposit Certificate of Deposit Certificate of Deposit New Account New Account Withdrawal Withdrawal Deposit Deposit Deposit Deposit withdrawal New Account New Account New Account ew Account New Account New Account New Account New Account New Account New Account New Account New Account New Account New Account New Account Deposit Deposit Withdrawal Deposit Deposit Deposit Withdrawal Deposit New Account Deposit Deposit Deposit Withdrawal Deposit Withdrawal Deposit New New 18100 47200 26900 45200 1600 700 200 1000 900 700 300 Delhi Blue Ach Anderson Hills Delhi Anderson Hills Delhi Anderson Hills Anderson Hills Blue Ash Anderson Hills Delhi Blue Ash Anderson Hills Blue Ash Blue Ash Delhi Delhi Anderson Hills Anderson Hills Anderson Hills Anderson Hills Delhi Anderson Hills Anderson Hills Anderson Hills Blue Ash Anderson Hills Delhi Anderson Hills Anderson Hills Anderson Hills Anderson Hills Blue Ash Blue Ash Delhi Blue Ash Andersen Hills Delhi Anderson Hills Anderson Hills Blue Ash Blue Ash Anderson Hills New New Current Current Current Current Current Current Current 400 Current 6200 60 61 62 63 54 65 56 67 68 69 70 71 72 73 74 75 76 77 78 260 2820 450 870 Current Current Current Current Current Current Current Current Current Current Current 510 100 PeoplesChoiceBanktet F25 X fx =IF($D$2:$D$35=$D$14,-E25,E25) H 700 N New Account ew Account New Account New Account New New :2332 | SISISISISIS SIS 8 8888 S$ 336 38 8 212 III 9 New 8 7 89 9 383 992 2 2 2 &&& 300 6 213 28 LE 5 g 5-Aur Tuesday Savings 80 Aur Tuesday Checking 815-Aug Tuesday Checking 825M Tuesday Checking 5-Aug Tuesday C hecking 84 S-Aug Tuesday Certificate of Deposit 5-Aug Tuesday Certificate of Deposit 86 5-Aug Tuesday Certificate of Deposit 87 S.Aug Tuesday Certificate of Deposit 88 S-Aug Tuesday 5-Aug Tuesday wings 90 5-Aug Tuesday 91 S-Aur Tuesday 92 S-Aug Tuesday 93 S-Aug Tuesday 945-Aug Tuesday Savings 95 5-Aug Tuesday IRA 96 5.Aug Tuesday IRA 97 5.Aug Tuesday IRA 98 5 Aug Tuesday Checking 99 5-Aug Tuesday C hecking 100 5.Aug Tuesday C hecking 101 5 Aug Tuesday C hecking 102 5-Aug Tuesday C hecking 103 5.Aug Tuesday C hecking 104 5.Aug Tuesday C hecking 1055 -Aug Tuesday C hecking 106 S-Aug Tuesday C hecking 1075-Aug Tuesday C hecking 108 5-Aug Tuesday Checking 109 5 Aug Tuesday Checking 110 5-Aug Tuesday Certificate of Deposit 111 6 Aug Wednesday Savings 112 6-Aug Wednesday C hecking 113 6-Aug Wednesday C hecking 1146-Aug Wednesday Checking 115 6 Aug Wednesday Checking 6 Aug Wednesday Checking 6-Aug Wednesday Certificate of Deposit 6 Aug Wednesday Certificate of Deposit 6-Aug Wednesday Certificate of Deposit 120 Aug Wednesday Certificate of Deposit 6-Aug Wednesday Certificate of Deposit PeoplesChoiceBanktxt Andersen Hills Dan Anderson Hills Blue Ach Blue Ach Blue Ach DAN Del Anderson Hills Anderson Hills Blue Ad Anderson Hills Blue Ash Anderson Hills Dell Blue Ash Blue Ash Anderson Hills Blue Ash Anderson Hills Anderson Hills Anderson Hills Anderson Hills Anderson Hills Delhi Anderson Hills 8 1300 2700 3840 810 190 2610 Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Deposit Withdrawal Account Current Cont New Account Deposit Withdrawal Deposit Deposit Withdrawal Deposit Deposit Withdrawal Deposit Deposit Withdrawal Withdrawal New New Account New Account New Account ew Account ew Account New New New New Delhi Anderson Hills Current + anderson Hills Current Anderson Hills 6400 560 3700 N N Anderson Hills Delhi Anderson Hills Delhi Anderson Hills Anderson Anderson De 950 UNS BBB HR F25 X fx IF($D$2:$D$35=$D$14, E25,825) Anders Anderson Certificate of Deposit Certificate of Deposit Savings Savings Savings Savings Savings Checking Checking Checking Checking Checking New Account New Account Withdrawal Deposit Deposit Deposit Withdrawal Withdra Deposit Withdra Deposit Withdra Deposit Deposit Withdrawal Withdrawal 14100 55900 200 1000 3000 2500 1700 220 3370 2760 Anderson Blue Ach Anderson Anderson Hills Delhi Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current New Checking Blue Ash Blue Ach Blue Ash 3130 DeN 3800 5600 Anderson Hills Anderson 600 NUR 400 900 New 121 Aug Wednesday 122 6 Wednesday 123 6 Aur Wednesday 124 6 Wednesday 125 6 ADR Wednesday 126 6-Aur Wednesday 127 6-Aur Wednesday 128 6-Aug Wednesday 129 6 Aug Wednesday 130 6-Aug Wednesday 131 6 Aug Wednesday 132 6-Aug Wednesday 133 6 Aug Wednesday 134 6-Aug Wednesday 135 6-Aug Wednesday 136 6-Aug Wednesday 137 6 Aug Wednesday 138 7-Aur Thursday 139 7-Aug Thursday 140 7-Aug Thursday 141 7 Aug Thursday 142 7.Aug Thursday 1437.Aug Thursday 144 7 Aug Thursday 145 7.Aug Thursday 146 7.Aug Thursday 147 7. Aug Thursday 148 7.Aug Thursday 149 7-Aur Thursday 1507 Aug Thursday 151 7 Aug Thursday 1.52 7.Aug Thursday 1537-Aug Thursday 154 7.Aug Thursday 155 7 Aug Thursday 1567-Aug Thursday 157 7.Aug Thursday 158 7 Aug Thursday 159 7.Au Thursday 160 7-Aug Thursday 161 7 Aug Thursday 1627 Aug Thursday Aug Thursday Checking Checking Checking Certificate of Deposit Savings Savings Savings Savings Savings Checking Checking Checking Checking Checking Checking Checking Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit New Account New Account New Account New Account New Account New Account New Account New Account New Account New Account New Account New Account New Account New Account 1000 1700 700 490 150 3920 870 Anderson Hills Anderson Hills Anderson Hills Blue Ach Anderson Hills Anderson Hills Anderson Hills Anderson Hills Blue Ash Delhi Anderson Hills Blue Ash Anderson Hills Anderson Blue Ach Delhi NA 3990 56900 45300 59200 18300 11300 5500 New Account New Account New Account New Account New Account New Account New Account Deposit Withdrawal Withdrawa Deposit 32700 2400 57800 54800 2700 Savings Savines PeoplesChoiceBanktact lili Marga a Canis F25 Current Current Current Current Current Current Current Current Current Anderson Anderson Delhi Anderson Anderson 888 18 ! 332 & 6 6 6 6 6 6 6 6 8 8 29991199219 Current Current Current Current SES????SEPEPPER Anderson DuN Anderson Hills Anderson Hills Current BIV A X fx - R$D$2:$D$35=$D$14,-E25,E25) A CD 163 74 Thursday Savings Depost 164 Plug Thursday Savings Deposit 165 7 Aug Thursday Savings Deposit 166 7 Thursday Savings 7-Aug Thursday Saving 1687 Thursday Saving Aug Thursday savings Thursday 7- Thursday 1727 Thursday 7- Thursday 174 Thursday 175 74 Thursday 7 Thursday 172 T Thursday 178 7-Aug Thursday 179 Au Thursday 180 7 Aug Thursday 181 7-Aug Thursday 182 7-Aug Thursday 183 7Aug Thursday Deposit 184 7.Aug Thursday C hecking Withdrawal 185 7 Aug Thursday Checking Deposit 186 7-AU Thursday Checking Deposit 187 7-Aug Thursday Checking Withdrawal 188 Bug Friday Savings New Account 189 Aug Friday C hecking New Account 190 8 Aug Friday C hecking New Account 191 8.Aug Friday Checking N ew Account 192 Aug Friday Certificate of Deposit New Account 193 8 Aug Friday Certificate of Deposit New Account 194 8 Aug Friday Certificate of Deposit New Account 195 8 Aug Friday Savings withdrawal 1968. Aug Friday Savings Deposit 197 Aug Friday Saving Withdrawal 1988-Aug Friday Savings Deposit 199 B.Aug Friday Savings Deposit 2008 Aug Friday Savings Deposit 201 Aug Friday R Current Contribution 202 Aug Friday Checking Deposit Checking Withdrawal Current Current Anderson Hills Anderson Hills 490 330 SD 2830 2010 3110 930 3680 3110 2780 500 Current Current Current Current Current Current Current New New New New New New New Current Current Current Current Current Current Current Current Current Current Current Delhi Anderson Hills Blue Ash Anderson Hills Delhi Delhi Anderson Hills Blue Ash Delhi Anderson Hills Anderson Hills Anderson Hills Anderson Hills Blue Ash Anderson Hills Anderson Hills Anderson Hills Anderson Hills Delhi Blue Ash Anderson Blue Ash Anderson Hills Anderson Hills Anderson 88888888 2560 - a PeoplesCho F25 x fxIF($D$2:$D$35-$D$14,-E25,525) Z Current Current Current New New New New Current Current Current Current Current Current Current Current 700 680 300 2200 90 150 230 1300 1500 3400 3530 10 200 120 4 4900 100 2000 2100 700 IST 2920 3290 51300 6600 29000 20400 2700 2200 900 asy UNNINE Depost 205 Aug Friday Checking Withdrawal 206 Aug Friday Checking Deposit 2079-Aug Saturday Savings New Account 2009-Aug Saturday Savings New Account 209 9 Aug Saturday Checking New Account 210 9 Aug Saturday Checking New Account 211 9-Au Saturday Checking New Account 212 9-Aug Saturday Savings withdrawal 213 9 Aug Saturday TRA Current Contribution 214 9 Aug Saturday IRA Current Contribution 215 9 Aug Saturday Charling Deposit 216 9 Aug Saturday Checking Deposit 217 9 Aug Saturday Checking Withdrawal 218 9 Saturday Checking US Deposit 219 9 Saturday Certificate of Deposit New 220 11-Aur Monday Saving New Account 221 11-Aug Monday Savings New 222 11-Aug Monday Savings New 223 11-Aug Monday Savings 224 11-Aug Monday Checking New Account 225 11 Aug Monday Checking New Account 226 11-Aug Monday Certificate of Deposit New Account 227 11 Aug Monday Certificate of Deposit New Account 228 11 Aug Monday Certificate of Deposit New Account 229 11 Aug Monday Certificate of Deposit New Account 230 11-Aug Monday Savings Deposit 231 11-Aug Monday Savings Deposit 232 11 Aug Monday Savings Deposit 1 233 11-Aug Monday Savings Deposit 234 11-Aug Monday Savings Deposit 235 11-Aug Monday Saving Deposit 236 11 Aug Monday Savings Deposit R M 237 11-Aug Monday Savings withdrawal 2011 Aug Monday Deposit 239 11-Aug Monday Savings Deposit 240 11 Aug Monday IRA Current Contribution 241 11 Aug Monday IRA Current Contribution 242 11-Aug Monday Checking Deposit 243 11 Aug Monday Checking Deposit 244 11 Aug Monday Deposit 245 11-Aug Monday Checking Withdrawal 246 11 Aug Monday Checking Deposit 247 11 Aug Monday Checking Withdrawal PeoplesChoiceBanktxt New Account Anderson Anderson Hills Anderson Hills Anderson Hills Anderson Hills Anderson Hills Anderson Hills Blue Ash Anderson Anderson Hills Delhi Anderson Hills De Anderson Hills Anderson Hills Den Anderson Hills Delhi Anderson Hills Blue Ash Delhi Delhi Anderson Hills Blue Ash Blue Ash Blue Ash Delhi Anderson Hus Blue Ash Anderson Hills Dell Delhi Delhi Blue Ash Blue Ash Det Blue Ash Anderson Hills Blue Ash Andersen Hills Blue Ash Delhi Anderson Hills Anderson Hills 300 2700 700 1500 1100 300 New New New Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Savings 1100 3100 2940 2810 630 570 1020 Marge Carter F25 X fx -IF($D$2:$D$35=$D$14,25,825) Current 1 7 0 150 withdraw Deposit Withdrawal Deposit Deposit withdrawal Withdraws Withdraw Deposit withdrawal 990 Anderson Hills Blue Ash Anderson Hills Anderson Hills Delhi Anderson Hills Anderson Hills De Anderson Hills Anderson Hills Blue Ach 2 Qurrent Current Current Current Current Current Current Current 40 320 399 2710 39200 New Account Sod 800 New Account 2950 New NEW 290 13 Aug Wednesday 291 13 Aug Wednesday 292 11-Aug Wednesday 293 13-Aug Wednesday 294 13-Aug Wednesday 295 13 Wednesday 296 13-Aug Wednesday 297 13-Aug Wednesday 298 13 Wednesday 299 13-Aur Wednesday 300 13-Aug Wednesday 301 14 Aug Thursday 302 14-Aut Thursday 303 14 Aug Thursday 304 14 Aug Thursday 305 14-Aug Thursday 306 14-Aug Thursday 307 14 Aug Thursday BOR 14-Aug Thursday 309 14 Aug Thursday 310 14-Aug Thursday 311 14-Aug Thursday 312 14 Aug Thursday 313 14-Aug Thursday 314 14-Aug Thursday 315 14-Aug Thursday 316 14 Aug Thursday 317 14-Aug Thursday 318 14-Aug Thursday 319 14 Aug Thursday 320 14 Aug Thursday 321 14 Aug Thursday 322 15 Aug Friday 323 15 Aug Friday 324 15 Aug Friday 325 15 Aug Friday 326 15-Aug Friday 327 15 Aug Friday 328 15 Aug Friday 329 15 Aug Friday 330 15 Aug Friday 331 15 Aug Friday 332 15 Aug Friday Current Checking Checking Checking Checking Checking Chacking Checking Checking Checiding Checking Certificate of Deposit Savings Savings Savings Checking Checking Checking Checking Certificate of Depost Certificate of Deposit Savings Savings Savings Savings Savings Savings Savings Checking Checking Checking Certificate of Deposit Certificate of Deposit Saving Checking Checking Certificate of Deposit Certificate of Deposit Certificate of Deposit Saving Saving Savings Saving 4400 44700 2200 2500 New Account New Account Deposit Deposit Deposit Deposit Deposit Deposit Deposit Deposit Withdrawal Deposit 1500 1500 600 2500 1200 630 270 Current Current Current Current Current Current Current Current Current Current Current Blue Ach Delhi Anderson Hills Delhi Anderson Hills Anderson Hills Anderson Hills Anderson Hills Anderson Hills Blue Ash Delhi Anderson Hills Delhi Anderson Hills Anderson Hills Blue Ash Anderson Hills Anderson Hills Anderson Hills Anderson Hills Anderson Hills Delhi 650 NEW Delhi 15200 11000 1600 3100 830 16400 58500 11100 3000 300 1100 New Account New Account New Account New Account New Account New Account Deposit Deposit Deposit withdrawal Deposit New Current Current Current Current Current Anderson Hills Anderson Hills Delhi Anderson Hills Blue Ash Blue Ash Anderson Hills Anderson Hills 2100 PeoplesChoiceBankat . Marga Canter Pasta F25 BTU X fx A LE =18$D$2:$D$35-$D$14,-E25,825) DHE R Anderson Hills Bueh Blue Ash Wue Ath Al New 875 18.Aur Monday 476 19-Aug Tuesday 22 19 Aug Tuesday 878 19-Aug Tuesday 179 19-Aug Tuesday 10 19 Tuesday 181 19-Aug Tuesday 0 1 . 183 19-u Tuesday 184 19 Tuesday 15 19 Aug Tuesday 186 19 Aug Tuesday 18719 Aug Tuesday 188 19-Aug Tuesday 189 19-Aug Tuesday 190 19-AU Tuesday 391 19-Aur Tuesday 92 19-Aug Tuesday 93 19 Aug Tuesday 94 19-Aug Tuesday 95 19 Aug Tuesday 96 19-Aug Tuesday 97 19-Aug Tuesday 98 19-Aug Tuesday 99 19-Aug Tuesday 00 19-Aug Tuesday 01 19 Aug Tuesday 2 19 Aug Tuesday 03 19-Aug Tuesday 04 19 Aug Tuesday OS 19 Aug Tuesday 06 19-Aug Tuesday 07 19 Aug Tuesday 08 19 Aug Tuesday 0919 Aug Tuesday 10 19 Aug Tuesday 11 19 Aug Tuesday 1219-Aug Tuesday 13 19-Aug Tuesday 14 19 Aug Tuesday 15 19 Aug Tuesday 16 19 Aug Tuesday 17 19 Aug Tuesday Chacking Savings Sing N Savings Savings Checking Chacking Checking Charding Chacing Checking Chacing Checking Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit Savings Savings Savings Savings Savings Savings Savings Savings Savings Savings Savings Savings IRA Checking Checking Checking Checking Checking Checking Checking Checking Depot New Account ew Account New Account New Account T Account New Account New Account Now Acount Now Account New Account New Account New Account New Account New Account New Account Now Account New Account New Account New Account New Account New Account withdrawal Deposit Deposit Withdrawal Deposit Deposit Deposit Deposit Withdrawal Deposit Deposit Depasit Current Contribution Deposit Withdrawal Withdrawal withdrawal Withdrawal Deposit Withdrawal 420 2700 900 700 1 200 2590 9 10 2920 250 120 2900 330 530 21100 43300 35600 54700 17900 28900 59400 24500 7300 1700 3 600 Anderson Hills Anderson Hills Blue Ach Anderson Hills Anderson Hills Anderson Hills Anderson Hills Anderson Hills Anderson Hills Blue Ash Delhi Anderson Hills Blue Ash Delhi Blue Ash Anderson Hills Anderson Hills Delhi Anderson Hills Delhi Anderson Hills Anderson Hills Anderson Hills Blue Ash Anderson Hills Anderson Hills Delhi Blue Ash Anderson Hills Blue Ash Anderson Hills Den Anderson Hills 500 2800 2400 400 2700 1200 New New Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current 2300 2500 300 1200 Anderson Hills Anderson Andri PeoplesChoice Banktxt E Marge & Center 3 BTUA x fx ($D$2:$D$35=$D$14,-E25,825) F25 G - Anderson Hills Blue Ach Anderson Hills Anderson Hills Ander Blue Ash Delhi Anderson Hills Current Current Qument Current Current Current Current Current Current Current Current Current Current Current New Delhi Blue Ash Blue Ash Anderson Hills New New 200 332 15 Aug Friday 333 15-Aur Friday 334 15-Aug Friday 335 15-Aur Friday 336 15 Aug Friday 337 15-Aur Friday 338 15 Aug Friday 339 15 Aug Friday 3401 15 Aug Friday 341 15 Aug Friday 342 15 Aug Friday 343 15-Aug Friday 344 15.Aug Friday 345 15 Aug Friday 346 16-Aug Saturday 3471 16-Aug Saturday 348 16-Aug Saturday 349 16-Aur Saturday 350 16-Aug Saturday 351 16-Aug Saturday 352 16 Aug Saturday 353 16-Aug Saturday 254 16 Aug Saturday 355 18-Aug Monday 356 18-Aug Monday 357 18-Aug Monday 358 18-Aug Monday 259 18-Aug Monday 360 18-Aug Monday 261 18-Aug Monday 362 18-Aug Monday 363 18-Aug Monday 364 18 Aug Monday 365 18-Aug Monday 366 18-Aur Monday 367 18-Aur Monday 368 18 Aug Monday 369 18 Aug Monday 370 18-Aug Monday 371 18 Aug Monday 372 18 Aug Monday 373 18 Aug Monday 374 18 Aug Monday Savings Savings IRA Checking Checking Checking Checking Checking Checking Checking Checking Checking Checking Certificate of Deposit Savings Savings Checking Savings Savings Checking Checking Checking Checking Savings Savings Checking Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit Savings Savings Savings TRA IRA Checking Checking Checking Checking Checking Checking Checking Checking DIE WITTW Deposit 2100 Withdrawal 2700 Current Contribution 3900 Withdrawal 2 Deposit 3360 Depost 2740 Withdrawal 30 Depost 840 Withdrawal 3 00 withdrawal 670 Withdrawal Deposit 1010 Withdrawal 500 New 2 1 9900 New Account New Account New Account 3170 Withdrawal 900 Deposit Deposit 2800 Deposit 640 Withdrawal 590 Deposit New Account 1700 New Account 1900 New Account New Account II 55400 New Account 47200 New Account : 19200 New Account 29600 Deposit 1100 Deposit Deposit 500 Current Contribution New Account 6400 Withdrawal 430 Deposit 280 Deposit 800 Deposit 130 withdrawal Deposit Deposit 650 920 Current Current Current Current Current Current New New New New New New New Current Current Current Current Current Current Current Current Current Current Current Current Current Blue Ash Anderson Hills Anderson Hills Odhi Blue Ash Anderson Hills Delhi Anderson Hills Anderson Hills Anderson Hills Blue Ash Blue Ash Delhi Anderson Hills Blue Ash Anderson Hills Delhi Anderson Hills Anderson Hills Delhi Anderson Hills Blue Ash Anderson Hills Anderson Hills Blue Ash Anderson Hills Blue Ash Anderson Hills Delhi Anderson Hills 800 1300 140 Deposit 810 PeoplesChoiceBanktxt F25 x F G H Andersens DAN Current Current Current Current Current Current Current Current 3000 f x -IF($D$2:$D$35-$D$14,-E25,E25) C D E Checking Withdrawal 310 Checking Deposit 670 Checking withdrawal 230 Certificate of Depost New 15300 Certificate of Deposit New 18700 Certificate of Depost New 4 0800 New Account 400 New Account 500 Checiding New Account 2510 Checking New Account 3990 Checking New Account 590 Checking New Account 510 Checiding New Account 340 Certificate of Deposit New Account 43400 Certificate of Depost New Account 59600 Certificate of Deposit New Account 55800 Certificate of Deposit New Account Savings Withdrawal 1600 Savings Deposit Savings Deposit 1200 Savings Withdrawal 1500 IRA Current Contribution 1100 Checking Deposit 3350 Checking Deposit 2680 Checking Deposit 900 Checking Deposit 3710 Checking Deposit 3400 Checking Deposit 900 Checking Withdrawal 1010 IEEE Deposit Checking 280 Checking withdrawal 410 Certificate of Deposit Savings New Account 3100 Savings New Account Checking New Account 3100 Checking New Account 2809 Savings withdrawal 700 Current Contribution 3500 Current Contribution 2200 Checking Deposit 840 Deposit Checking 3250 Depost Checking 3650 Checking Deposit 920 418 19 Aug Tuesday 419 19 Aug Tuesday 420 19-Aug Tuesday 421 19 A Today 422 19 Aug Tuesday 423 19 Aug Tuesday 424 20 Aug Wednesday 425 20-Aug Wednesday 426 20 Aug Wednesday 427 20-4 Wednesday 428 20-Aug Wednesday 429 20-Aug Wednesday 430 20-Auf Wednesday 431 20 Aug Wednesday 432 20 Aug Wednesday 433 20-Aug Wednesday 434 20 Aug Wednesday 435 20 Aug Wednesday 436 20 Aug Wednesday 437 20-Aug Wednesday 438 20-Aug Wednesday 439 20-Aug Wednesday 440 20 Aug Wednesday 441 20 Aug Wednesday 442 20 Aug Wednesday 443 20-Aug Wednesday 444 20 Aug Wednesday 445 20 Aug Wednesday 446 20 Aug Wednesday 447 20 Aug Wednesday 448 20-Aug Wednesday 449 20 Aug Wednesday 450 21 Aug Thursday 451 21 Aug Thursday 452 21 Aug Thursday 453 21 Aug Thursday 454 21-Aug Thursday 455 21 Aug Thursday 1456 21 Aug Thursday 457 21 Aug Thursday 458 21 Aug Thursday 459 21 Aug Thursday 460 21-Aug Thursday Current Current Current Current Current Current Current Current Current Current Current Current Current New New Anderson Hills Anderson Hills Dan Anderson Hills De Anderson Anderson Hills Anderson Hills Anderson Hills Blue Ash Den Delhi Delhi Anderson Hills Delhi Blue Ash Blue Ash Anderson Hills Anderson Hills Blue Ash Anderson Hills Anderson Hills Anderson Hills Delhi Delhi Delhi Anderson Hills Anderson Hills Delhi Blue Ash Anderson Anderson Halls Delhi Anderson Hills Anderson Hills Blue Ash Blue Ash Anderson Hills Andersen Del Anderson 410 12700 Current Current Current Current Current Current Current PeoplesChoiceBanktxt F25 A * fx =IF($D$2:$D$35=$D$14,525,825) CD G H 500 2900 1600 Anderson Hills Blue Ath NA New Ne Nue Ach Anderson Hills Anderson Hills Nuech Anderson Hills Nuh 1000 1100 3400 710 740 430 890 35900 55100 22500 3600 2900 2500 No 2 700 1 504 25-Aug Monday 505 25 Aug Monday 506 25.Aur Monday 507 25-Aug Monday 508 25-Aug Monday 509 25 Aug Monday 510 25-Aug Monday 511 25 Aug Monday 512 25-Au Monday 513 25.Aug Monday 51425 Monday 515 25-Aug Monday 516 25-Aug Monday 517 25 Monday 518 25 Aug Monday 519 25 Aug Monday 520 25 Aug Monday 521 25-Aug Monday 522 25-Aug Monday 523 25 Aug Monday 524 25 Aug Monday 525 25 Aug Monday 526 25-Aug Monday 527 25 Aug Monday 528 25-Aug Monday 529 25 Aug Monday 530 25-Aug Monday 531 25-Aug Monday 532 25-Aug Monday 533 25 Aug Monday 534 25-Aug Monday $35 25-Aug Monday 536 25-Aug Monday 537 25-Aug Monday 538 25-Aug Monday 539 26 Aug Tuesday 540 26 Aug Tuesday 541 26 Aug Tuesday 542 26 Aug Tuesday 543 26 Aug Tuesday 54 26 Aug Tuesday 545 26 Aug Tuesday 546 26 Aug Tuesday Sawings Savings Savings Savings Savings Savings IRAN N Checking Checking Checking Checking Certificate of Deposit Certificate of Depost Certificate of Deposit Certificate of Deposit Saving Savings Saving Savings Savings Savings Savings Savings Checking Checking Checking Checking Checking Checking Checking Checking Checking Checking Certificate of Deposit Certificate of Deposit Savings Checking Checking Checking Checking Checking Certificate of Deposit Certificate of Depost New Account New Account New Account New Account New Account New Account ew Account New Account New Account New Account New Account New Account New Account New Account New Account Deposit Withdrawal Deposit Withdrawal Deposit Withdrawal withdrawal Deposit Deposit Withdrawal Deposit Deposit Deposit Withdrawal withdrawal Deposit Deposit withdrawal New New New Account New Account New Account New Account New Account New Account New Account New Account 800 2100 1800 1600 Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current 3310 3770 2900 Anderson Hills Anderson Hills Delhi Anderson Hills Blue Ash Anderson Hills Anderson Hills Blue Ash Blue Ash Delhi Blue Ash Blue Ash Blue Ash Anderson Hills Blue Ash Blue Ash Anderson Hills Anderson Hills Anderson Hills Anderson Hills Blue Ach Anderson Hills Anderson Hills Delhi Anderson Hills Anderson Hills Blue Ash Blue Ash Anderson Hills Anderson Hills Blue Ash Blue Ash Anderson 3230 3670 Current 510 52000 6100 Current Current 2570 2500 PeoplesChoiceBanktxt 27900 1900 2900 1200 2000 Anderson Hill Blue Ach Blue Ash Anderson is Blue Ach Nuh 2200 3000 Current Current Current Current Current Current Current Current Current Current Current Current Current 2300 6900 300 2020 Anderson DAN Nuesh Du Anderson Hills Anderson Hills 910 9 De 900 1900 2900 NOW New New Blue Ach Blue Ash Anderson Hills Anderson Hills Anderson Hills New 900 160 45200 1100 547 26-Aug Tuesday Certificate of Deposit New Account 548 26 Aug Tuesday Savings Deposit 549 26 Aug Tuesday Sawings Deposit $50 26-ug Tuesday savings Depout 551 26 Aug Tuesday Savings Deposit 552 26 Tuesday Savings Deposit 553 26 Aug Tuesday Savings Depost 554 26-Aug Tuesday IRA Current Contribution 555 26 Aug Tuesday JIRA Current Contribution 556 26 Aug Tuesday IRA New Account 552 26.Aur Tuesday Checkling Decout 558 26 Aug Tuesday Checking Depost 559 26-Aug Tuesday Checking Withdrawal 560 26 Aug Tuesday Certificate of Deposit New 561 27-Aug Wednesday Saving New Account 562 27-Aug Wednesday Savings New Account 563 27-Aug Wednesday Savings New Account 564 27-Aug Wednesday Savings New Account 565 27-Aug Wednesday Checking New Account 566 27-Aug Wednesday Certificate of Deposit New Account 567 27-Aug Wednesday Savings Deposit 568 27-Aug Wednesday Savings Deposit 569 27-Aug Wednesday Current Contribution 570 27-Aug Wednesday Checking Deposit 571 27-Aug Wednesday Checking Deposit 572 27-Aug Wednesday Checking Withdrawal 573 27 Aug Wednesday Checking Deposit 574 27 Aug Wednesday Checking Deposit 525 27 Aug Wednesday Certificate of Deposit 576 27.Aug Wednesday Certificate of Deposit 577 28 Aug Thursday Savings New Account 578 28 Aug Thursday Checking New Account 579 28 Aug Thursday Checking New Account SO 28 Aug Thursday Certificate of Deposit New Account 581 28-Aug Thursday Certificate of Deposit New Account 582 28 Aug Thursday Saving Deposit 583 28-Aug Thursday Savings Withdrawal 584 28 Aug Thursday Savings Withdrawal 58 28 Aug Thursday IRA Current Contribution 586 28 Aug Thursday Checking 587 25 Aug Thursday Checking Withdrawal 588 28-Aug Thursday Checking Withdrawal 589 28-Aug Thursday C hecking Deposit 590 28 Aus Thursday Checking Withdrawal PeoplesChoiceBanktxt 2800 1300 840 780 51700 36600 2300 530 480 25700 24400 200 200 1300 2800 810 New New Current Current Current Current Current Current Current Current Current Current New New New New New Current Current Current Current Current Current Current Current Current Anderson Hills Delhi Blue Ash Anderson Halls Anderson Hills Delhi Delhi Anderson Hills Anderson Hills Delhi Blue Ash Delhi Anderson Hills Delhi Anderson Hills Anderson Hills Anderson Hills Anderson Hills Blue Ash Deposit De Nuesh Anderson Hills Delhi Blue Ash F25 X X =IF($D$2:$D$35=$D$14,-E25, E25) 240 Checking Checking Savings Savings Checking Checking Checking Certificate of Deposit Savings Savings Savings Savings Savings N Delhi Blue Ach Alue Ash Anderson Hills Anderson Hills Anderson Hills Blue Ash Dih 300 3100 110 3070 450 2 2700 400 N 589 28-Aug Thursday 590 28-Aug Thursday 591 29-Aug Friday 592 29-Aug Friday 593 29-Aur Friday 594 29 Aug Friday 595 29-Aug Friday 596 29-Aug Friday 597 29-Aug Friday 598 29-Aug Friday 599 29-Aug Friday 600 29-Aug Friday 601 29-Aug Friday 602 29-Aug Friday 603 29-Aug Friday 604 29 Aug Friday 605 29-Aug Friday 606 29-Aug Friday 607 29-Aug Friday 508 30 Aug Saturday 609 30-Aug Saturday 610 30 Aug Saturday 611 30 Aug Saturday 612 30 Aug Saturday 613 30-Aug Saturday 614 30 Aug Saturday 615 30-Aug Saturday 1616 30 Aug Saturday 617 20 Aug Saturday 618 30 Aug Saturday 619 30-Aug Saturday 620 30 Aug Saturday 621 30 Aug Saturday Blue Ash Current Current New New New New New New Current Current Current Current Current Current Current Current Current Deposit Withdrawal New Account New Account ew Account New Account ew Account New Account E Deposit Deposit withdrawal Deposit Deposit Withdrawal Withdrawal Current Contribution Deposit Withdrawal withdrawal New Account New Account New Account Deposit Withdrawal Deposit New Deposit Deposit Deposit Deposit Withdraw Deposit Deposit Savings IRA Checking Checking Checking Certificate of Deposit Certificate of Deposit Certificate of Deposit Checking Checking Checking Certificate of Deposit Savings Savings Savings Saving Savings Savings Checking 190 580 37300 59200 15100 2880 620 160 44900 3000 Anderson Hills Blue Ash Anderson Hills Blue Ash Blue Ash Anderson Hills Blue Ash Anderson Hills Delhi Blue Ach Blue Ash Anderson Hills Delhi Delhi Delhi Anderson Hills Delhi Delhi Delhi Anderson Hills Blue Ach Blue Ash Blue Ash Anderson Hills 2900 1400 Current Current Current Current Current Current Current Current Current Current Current 2400 1000 500 790 PeoplesChoiceBanktxt Here are some details you need to complete the file. 1. You will need to add a column and create a function that calculates Cash Flow based on criteria from Type. Create an IF statement that returns a negative cash flow (looks like ($500.00) for example) if the type was a Withdrawal. For all other types, the cash flow should be positive. 2. In running your pivot tables, some suggestions are to look at things like branch, account type, customer, etc. These are suggestions only. You will probably run more than just those types. Remember to run more than just SUMs in your pivot tables. You can also run MIN, MAX, COUNT, PERCENT and more. Run at least different 3 pivot tables, saving each as a separate sheet with each tab descriptively labeled (For example: Pivot 1, Pivot 2, etc.), and include those pivot tables as images in your Word document report. (One final tip, don't forget about time such as dates and days of the week in your analysis and data set.) F25 X fx-17$D$2:$D$35=$D$14,-E25, E25) 6 17 8 New New Current 2 16300 9400 1100 200 1300 800 3880 Current Current 0 31 122 13 14 Current 910 Current Current New 1400 36 47 18 N 50 51 52 55555 2 Saturday 2-Aur Saturday -Aug Saturday 2-Aug Saturday 2-Aug Saturday 2-Aug Saturday -Aug Saturday 2-Aug Saturday 2-Aug Saturday 4-Aug Monday 4-Aug Monday 4-Aug Monday 4-Aug Monday 4-Aug Monday 4-Aug Monday 4-Aug Monday 4-Aug Monday 4-Aur Monday 4-Aug Monday 4-Aug Monday 4-Aug Monday 4-Aug Monday 4-Aug Monday 4-Aug Monday 4-Aug Monday 4 Aug Monday 4 Aug Monday 4-Aug Monday 4-Aug Monday 4.Aug Monday 4. Aug Monday 4 Aug Monday 4-Aug Monday 4. Aug Monday 4-Aug Monday 4 Aug Monday 4. Aug Monday 4. Aug Monday 4. Aug Monday 4-Aug Monday 4 Aug Monday 4 Aug Monday 4. Aug Monday Certificate of Deposit Certificate of Deposit Swing Savings Savings Savings Checiding Checking C hecking Savings Savings TRA Checking C hecking Checking Checking Checking Checking C hecking C hecking Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit Savings Savings Savings Savings Savings Savings Savings Savings IRA Checking Checking Checking Checking Checking Checking Checking Certificate of Deposit Certificate of Deposit Certificate of Deposit New Account New Account Withdrawal Withdrawal Deposit Deposit Deposit Deposit withdrawal New Account New Account New Account ew Account New Account New Account New Account New Account New Account New Account New Account New Account New Account New Account New Account Deposit Deposit Withdrawal Deposit Deposit Deposit Withdrawal Deposit New Account Deposit Deposit Deposit Withdrawal Deposit Withdrawal Deposit New New 18100 47200 26900 45200 1600 700 200 1000 900 700 300 Delhi Blue Ach Anderson Hills Delhi Anderson Hills Delhi Anderson Hills Anderson Hills Blue Ash Anderson Hills Delhi Blue Ash Anderson Hills Blue Ash Blue Ash Delhi Delhi Anderson Hills Anderson Hills Anderson Hills Anderson Hills Delhi Anderson Hills Anderson Hills Anderson Hills Blue Ash Anderson Hills Delhi Anderson Hills Anderson Hills Anderson Hills Anderson Hills Blue Ash Blue Ash Delhi Blue Ash Andersen Hills Delhi Anderson Hills Anderson Hills Blue Ash Blue Ash Anderson Hills New New Current Current Current Current Current Current Current 400 Current 6200 60 61 62 63 54 65 56 67 68 69 70 71 72 73 74 75 76 77 78 260 2820 450 870 Current Current Current Current Current Current Current Current Current Current Current 510 100 PeoplesChoiceBanktet F25 X fx =IF($D$2:$D$35=$D$14,-E25,E25) H 700 N New Account ew Account New Account New Account New New :2332 | SISISISISIS SIS 8 8888 S$ 336 38 8 212 III 9 New 8 7 89 9 383 992 2 2 2 &&& 300 6 213 28 LE 5 g 5-Aur Tuesday Savings 80 Aur Tuesday Checking 815-Aug Tuesday Checking 825M Tuesday Checking 5-Aug Tuesday C hecking 84 S-Aug Tuesday Certificate of Deposit 5-Aug Tuesday Certificate of Deposit 86 5-Aug Tuesday Certificate of Deposit 87 S.Aug Tuesday Certificate of Deposit 88 S-Aug Tuesday 5-Aug Tuesday wings 90 5-Aug Tuesday 91 S-Aur Tuesday 92 S-Aug Tuesday 93 S-Aug Tuesday 945-Aug Tuesday Savings 95 5-Aug Tuesday IRA 96 5.Aug Tuesday IRA 97 5.Aug Tuesday IRA 98 5 Aug Tuesday Checking 99 5-Aug Tuesday C hecking 100 5.Aug Tuesday C hecking 101 5 Aug Tuesday C hecking 102 5-Aug Tuesday C hecking 103 5.Aug Tuesday C hecking 104 5.Aug Tuesday C hecking 1055 -Aug Tuesday C hecking 106 S-Aug Tuesday C hecking 1075-Aug Tuesday C hecking 108 5-Aug Tuesday Checking 109 5 Aug Tuesday Checking 110 5-Aug Tuesday Certificate of Deposit 111 6 Aug Wednesday Savings 112 6-Aug Wednesday C hecking 113 6-Aug Wednesday C hecking 1146-Aug Wednesday Checking 115 6 Aug Wednesday Checking 6 Aug Wednesday Checking 6-Aug Wednesday Certificate of Deposit 6 Aug Wednesday Certificate of Deposit 6-Aug Wednesday Certificate of Deposit 120 Aug Wednesday Certificate of Deposit 6-Aug Wednesday Certificate of Deposit PeoplesChoiceBanktxt Andersen Hills Dan Anderson Hills Blue Ach Blue Ach Blue Ach DAN Del Anderson Hills Anderson Hills Blue Ad Anderson Hills Blue Ash Anderson Hills Dell Blue Ash Blue Ash Anderson Hills Blue Ash Anderson Hills Anderson Hills Anderson Hills Anderson Hills Anderson Hills Delhi Anderson Hills 8 1300 2700 3840 810 190 2610 Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Deposit Withdrawal Account Current Cont New Account Deposit Withdrawal Deposit Deposit Withdrawal Deposit Deposit Withdrawal Deposit Deposit Withdrawal Withdrawal New New Account New Account New Account ew Account ew Account New New New New Delhi Anderson Hills Current + anderson Hills Current Anderson Hills 6400 560 3700 N N Anderson Hills Delhi Anderson Hills Delhi Anderson Hills Anderson Anderson De 950 UNS BBB HR F25 X fx IF($D$2:$D$35=$D$14, E25,825) Anders Anderson Certificate of Deposit Certificate of Deposit Savings Savings Savings Savings Savings Checking Checking Checking Checking Checking New Account New Account Withdrawal Deposit Deposit Deposit Withdrawal Withdra Deposit Withdra Deposit Withdra Deposit Deposit Withdrawal Withdrawal 14100 55900 200 1000 3000 2500 1700 220 3370 2760 Anderson Blue Ach Anderson Anderson Hills Delhi Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current New Checking Blue Ash Blue Ach Blue Ash 3130 DeN 3800 5600 Anderson Hills Anderson 600 NUR 400 900 New 121 Aug Wednesday 122 6 Wednesday 123 6 Aur Wednesday 124 6 Wednesday 125 6 ADR Wednesday 126 6-Aur Wednesday 127 6-Aur Wednesday 128 6-Aug Wednesday 129 6 Aug Wednesday 130 6-Aug Wednesday 131 6 Aug Wednesday 132 6-Aug Wednesday 133 6 Aug Wednesday 134 6-Aug Wednesday 135 6-Aug Wednesday 136 6-Aug Wednesday 137 6 Aug Wednesday 138 7-Aur Thursday 139 7-Aug Thursday 140 7-Aug Thursday 141 7 Aug Thursday 142 7.Aug Thursday 1437.Aug Thursday 144 7 Aug Thursday 145 7.Aug Thursday 146 7.Aug Thursday 147 7. Aug Thursday 148 7.Aug Thursday 149 7-Aur Thursday 1507 Aug Thursday 151 7 Aug Thursday 1.52 7.Aug Thursday 1537-Aug Thursday 154 7.Aug Thursday 155 7 Aug Thursday 1567-Aug Thursday 157 7.Aug Thursday 158 7 Aug Thursday 159 7.Au Thursday 160 7-Aug Thursday 161 7 Aug Thursday 1627 Aug Thursday Aug Thursday Checking Checking Checking Certificate of Deposit Savings Savings Savings Savings Savings Checking Checking Checking Checking Checking Checking Checking Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit New Account New Account New Account New Account New Account New Account New Account New Account New Account New Account New Account New Account New Account New Account 1000 1700 700 490 150 3920 870 Anderson Hills Anderson Hills Anderson Hills Blue Ach Anderson Hills Anderson Hills Anderson Hills Anderson Hills Blue Ash Delhi Anderson Hills Blue Ash Anderson Hills Anderson Blue Ach Delhi NA 3990 56900 45300 59200 18300 11300 5500 New Account New Account New Account New Account New Account New Account New Account Deposit Withdrawal Withdrawa Deposit 32700 2400 57800 54800 2700 Savings Savines PeoplesChoiceBanktact lili Marga a Canis F25 Current Current Current Current Current Current Current Current Current Anderson Anderson Delhi Anderson Anderson 888 18 ! 332 & 6 6 6 6 6 6 6 6 8 8 29991199219 Current Current Current Current SES????SEPEPPER Anderson DuN Anderson Hills Anderson Hills Current BIV A X fx - R$D$2:$D$35=$D$14,-E25,E25) A CD 163 74 Thursday Savings Depost 164 Plug Thursday Savings Deposit 165 7 Aug Thursday Savings Deposit 166 7 Thursday Savings 7-Aug Thursday Saving 1687 Thursday Saving Aug Thursday savings Thursday 7- Thursday 1727 Thursday 7- Thursday 174 Thursday 175 74 Thursday 7 Thursday 172 T Thursday 178 7-Aug Thursday 179 Au Thursday 180 7 Aug Thursday 181 7-Aug Thursday 182 7-Aug Thursday 183 7Aug Thursday Deposit 184 7.Aug Thursday C hecking Withdrawal 185 7 Aug Thursday Checking Deposit 186 7-AU Thursday Checking Deposit 187 7-Aug Thursday Checking Withdrawal 188 Bug Friday Savings New Account 189 Aug Friday C hecking New Account 190 8 Aug Friday C hecking New Account 191 8.Aug Friday Checking N ew Account 192 Aug Friday Certificate of Deposit New Account 193 8 Aug Friday Certificate of Deposit New Account 194 8 Aug Friday Certificate of Deposit New Account 195 8 Aug Friday Savings withdrawal 1968. Aug Friday Savings Deposit 197 Aug Friday Saving Withdrawal 1988-Aug Friday Savings Deposit 199 B.Aug Friday Savings Deposit 2008 Aug Friday Savings Deposit 201 Aug Friday R Current Contribution 202 Aug Friday Checking Deposit Checking Withdrawal Current Current Anderson Hills Anderson Hills 490 330 SD 2830 2010 3110 930 3680 3110 2780 500 Current Current Current Current Current Current Current New New New New New New New Current Current Current Current Current Current Current Current Current Current Current Delhi Anderson Hills Blue Ash Anderson Hills Delhi Delhi Anderson Hills Blue Ash Delhi Anderson Hills Anderson Hills Anderson Hills Anderson Hills Blue Ash Anderson Hills Anderson Hills Anderson Hills Anderson Hills Delhi Blue Ash Anderson Blue Ash Anderson Hills Anderson Hills Anderson 88888888 2560 - a PeoplesCho F25 x fxIF($D$2:$D$35-$D$14,-E25,525) Z Current Current Current New New New New Current Current Current Current Current Current Current Current 700 680 300 2200 90 150 230 1300 1500 3400 3530 10 200 120 4 4900 100 2000 2100 700 IST 2920 3290 51300 6600 29000 20400 2700 2200 900 asy UNNINE Depost 205 Aug Friday Checking Withdrawal 206 Aug Friday Checking Deposit 2079-Aug Saturday Savings New Account 2009-Aug Saturday Savings New Account 209 9 Aug Saturday Checking New Account 210 9 Aug Saturday Checking New Account 211 9-Au Saturday Checking New Account 212 9-Aug Saturday Savings withdrawal 213 9 Aug Saturday TRA Current Contribution 214 9 Aug Saturday IRA Current Contribution 215 9 Aug Saturday Charling Deposit 216 9 Aug Saturday Checking Deposit 217 9 Aug Saturday Checking Withdrawal 218 9 Saturday Checking US Deposit 219 9 Saturday Certificate of Deposit New 220 11-Aur Monday Saving New Account 221 11-Aug Monday Savings New 222 11-Aug Monday Savings New 223 11-Aug Monday Savings 224 11-Aug Monday Checking New Account 225 11 Aug Monday Checking New Account 226 11-Aug Monday Certificate of Deposit New Account 227 11 Aug Monday Certificate of Deposit New Account 228 11 Aug Monday Certificate of Deposit New Account 229 11 Aug Monday Certificate of Deposit New Account 230 11-Aug Monday Savings Deposit 231 11-Aug Monday Savings Deposit 232 11 Aug Monday Savings Deposit 1 233 11-Aug Monday Savings Deposit 234 11-Aug Monday Savings Deposit 235 11-Aug Monday Saving Deposit 236 11 Aug Monday Savings Deposit R M 237 11-Aug Monday Savings withdrawal 2011 Aug Monday Deposit 239 11-Aug Monday Savings Deposit 240 11 Aug Monday IRA Current Contribution 241 11 Aug Monday IRA Current Contribution 242 11-Aug Monday Checking Deposit 243 11 Aug Monday Checking Deposit 244 11 Aug Monday Deposit 245 11-Aug Monday Checking Withdrawal 246 11 Aug Monday Checking Deposit 247 11 Aug Monday Checking Withdrawal PeoplesChoiceBanktxt New Account Anderson Anderson Hills Anderson Hills Anderson Hills Anderson Hills Anderson Hills Anderson Hills Blue Ash Anderson Anderson Hills Delhi Anderson Hills De Anderson Hills Anderson Hills Den Anderson Hills Delhi Anderson Hills Blue Ash Delhi Delhi Anderson Hills Blue Ash Blue Ash Blue Ash Delhi Anderson Hus Blue Ash Anderson Hills Dell Delhi Delhi Blue Ash Blue Ash Det Blue Ash Anderson Hills Blue Ash Andersen Hills Blue Ash Delhi Anderson Hills Anderson Hills 300 2700 700 1500 1100 300 New New New Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Savings 1100 3100 2940 2810 630 570 1020 Marge Carter F25 X fx -IF($D$2:$D$35=$D$14,25,825) Current 1 7 0 150 withdraw Deposit Withdrawal Deposit Deposit withdrawal Withdraws Withdraw Deposit withdrawal 990 Anderson Hills Blue Ash Anderson Hills Anderson Hills Delhi Anderson Hills Anderson Hills De Anderson Hills Anderson Hills Blue Ach 2 Qurrent Current Current Current Current Current Current Current 40 320 399 2710 39200 New Account Sod 800 New Account 2950 New NEW 290 13 Aug Wednesday 291 13 Aug Wednesday 292 11-Aug Wednesday 293 13-Aug Wednesday 294 13-Aug Wednesday 295 13 Wednesday 296 13-Aug Wednesday 297 13-Aug Wednesday 298 13 Wednesday 299 13-Aur Wednesday 300 13-Aug Wednesday 301 14 Aug Thursday 302 14-Aut Thursday 303 14 Aug Thursday 304 14 Aug Thursday 305 14-Aug Thursday 306 14-Aug Thursday 307 14 Aug Thursday BOR 14-Aug Thursday 309 14 Aug Thursday 310 14-Aug Thursday 311 14-Aug Thursday 312 14 Aug Thursday 313 14-Aug Thursday 314 14-Aug Thursday 315 14-Aug Thursday 316 14 Aug Thursday 317 14-Aug Thursday 318 14-Aug Thursday 319 14 Aug Thursday 320 14 Aug Thursday 321 14 Aug Thursday 322 15 Aug Friday 323 15 Aug Friday 324 15 Aug Friday 325 15 Aug Friday 326 15-Aug Friday 327 15 Aug Friday 328 15 Aug Friday 329 15 Aug Friday 330 15 Aug Friday 331 15 Aug Friday 332 15 Aug Friday Current Checking Checking Checking Checking Checking Chacking Checking Checking Checiding Checking Certificate of Deposit Savings Savings Savings Checking Checking Checking Checking Certificate of Depost Certificate of Deposit Savings Savings Savings Savings Savings Savings Savings Checking Checking Checking Certificate of Deposit Certificate of Deposit Saving Checking Checking Certificate of Deposit Certificate of Deposit Certificate of Deposit Saving Saving Savings Saving 4400 44700 2200 2500 New Account New Account Deposit Deposit Deposit Deposit Deposit Deposit Deposit Deposit Withdrawal Deposit 1500 1500 600 2500 1200 630 270 Current Current Current Current Current Current Current Current Current Current Current Blue Ach Delhi Anderson Hills Delhi Anderson Hills Anderson Hills Anderson Hills Anderson Hills Anderson Hills Blue Ash Delhi Anderson Hills Delhi Anderson Hills Anderson Hills Blue Ash Anderson Hills Anderson Hills Anderson Hills Anderson Hills Anderson Hills Delhi 650 NEW Delhi 15200 11000 1600 3100 830 16400 58500 11100 3000 300 1100 New Account New Account New Account New Account New Account New Account Deposit Deposit Deposit withdrawal Deposit New Current Current Current Current Current Anderson Hills Anderson Hills Delhi Anderson Hills Blue Ash Blue Ash Anderson Hills Anderson Hills 2100 PeoplesChoiceBankat . Marga Canter Pasta F25 BTU X fx A LE =18$D$2:$D$35-$D$14,-E25,825) DHE R Anderson Hills Bueh Blue Ash Wue Ath Al New 875 18.Aur Monday 476 19-Aug Tuesday 22 19 Aug Tuesday 878 19-Aug Tuesday 179 19-Aug Tuesday 10 19 Tuesday 181 19-Aug Tuesday 0 1 . 183 19-u Tuesday 184 19 Tuesday 15 19 Aug Tuesday 186 19 Aug Tuesday 18719 Aug Tuesday 188 19-Aug Tuesday 189 19-Aug Tuesday 190 19-AU Tuesday 391 19-Aur Tuesday 92 19-Aug Tuesday 93 19 Aug Tuesday 94 19-Aug Tuesday 95 19 Aug Tuesday 96 19-Aug Tuesday 97 19-Aug Tuesday 98 19-Aug Tuesday 99 19-Aug Tuesday 00 19-Aug Tuesday 01 19 Aug Tuesday 2 19 Aug Tuesday 03 19-Aug Tuesday 04 19 Aug Tuesday OS 19 Aug Tuesday 06 19-Aug Tuesday 07 19 Aug Tuesday 08 19 Aug Tuesday 0919 Aug Tuesday 10 19 Aug Tuesday 11 19 Aug Tuesday 1219-Aug Tuesday 13 19-Aug Tuesday 14 19 Aug Tuesday 15 19 Aug Tuesday 16 19 Aug Tuesday 17 19 Aug Tuesday Chacking Savings Sing N Savings Savings Checking Chacking Checking Charding Chacing Checking Chacing Checking Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit Savings Savings Savings Savings Savings Savings Savings Savings Savings Savings Savings Savings IRA Checking Checking Checking Checking Checking Checking Checking Checking Depot New Account ew Account New Account New Account T Account New Account New Account Now Acount Now Account New Account New Account New Account New Account New Account New Account Now Account New Account New Account New Account New Account New Account withdrawal Deposit Deposit Withdrawal Deposit Deposit Deposit Deposit Withdrawal Deposit Deposit Depasit Current Contribution Deposit Withdrawal Withdrawal withdrawal Withdrawal Deposit Withdrawal 420 2700 900 700 1 200 2590 9 10 2920 250 120 2900 330 530 21100 43300 35600 54700 17900 28900 59400 24500 7300 1700 3 600 Anderson Hills Anderson Hills Blue Ach Anderson Hills Anderson Hills Anderson Hills Anderson Hills Anderson Hills Anderson Hills Blue Ash Delhi Anderson Hills Blue Ash Delhi Blue Ash Anderson Hills Anderson Hills Delhi Anderson Hills Delhi Anderson Hills Anderson Hills Anderson Hills Blue Ash Anderson Hills Anderson Hills Delhi Blue Ash Anderson Hills Blue Ash Anderson Hills Den Anderson Hills 500 2800 2400 400 2700 1200 New New Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current 2300 2500 300 1200 Anderson Hills Anderson Andri PeoplesChoice Banktxt E Marge & Center 3 BTUA x fx ($D$2:$D$35=$D$14,-E25,825) F25 G - Anderson Hills Blue Ach Anderson Hills Anderson Hills Ander Blue Ash Delhi Anderson Hills Current Current Qument Current Current Current Current Current Current Current Current Current Current Current New Delhi Blue Ash Blue Ash Anderson Hills New New 200 332 15 Aug Friday 333 15-Aur Friday 334 15-Aug Friday 335 15-Aur Friday 336 15 Aug Friday 337 15-Aur Friday 338 15 Aug Friday 339 15 Aug Friday 3401 15 Aug Friday 341 15 Aug Friday 342 15 Aug Friday 343 15-Aug Friday 344 15.Aug Friday 345 15 Aug Friday 346 16-Aug Saturday 3471 16-Aug Saturday 348 16-Aug Saturday 349 16-Aur Saturday 350 16-Aug Saturday 351 16-Aug Saturday 352 16 Aug Saturday 353 16-Aug Saturday 254 16 Aug Saturday 355 18-Aug Monday 356 18-Aug Monday 357 18-Aug Monday 358 18-Aug Monday 259 18-Aug Monday 360 18-Aug Monday 261 18-Aug Monday 362 18-Aug Monday 363 18-Aug Monday 364 18 Aug Monday 365 18-Aug Monday 366 18-Aur Monday 367 18-Aur Monday 368 18 Aug Monday 369 18 Aug Monday 370 18-Aug Monday 371 18 Aug Monday 372 18 Aug Monday 373 18 Aug Monday 374 18 Aug Monday Savings Savings IRA Checking Checking Checking Checking Checking Checking Checking Checking Checking Checking Certificate of Deposit Savings Savings Checking Savings Savings Checking Checking Checking Checking Savings Savings Checking Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit Savings Savings Savings TRA IRA Checking Checking Checking Checking Checking Checking Checking Checking DIE WITTW Deposit 2100 Withdrawal 2700 Current Contribution 3900 Withdrawal 2 Deposit 3360 Depost 2740 Withdrawal 30 Depost 840 Withdrawal 3 00 withdrawal 670 Withdrawal Deposit 1010 Withdrawal 500 New 2 1 9900 New Account New Account New Account 3170 Withdrawal 900 Deposit Deposit 2800 Deposit 640 Withdrawal 590 Deposit New Account 1700 New Account 1900 New Account New Account II 55400 New Account 47200 New Account : 19200 New Account 29600 Deposit 1100 Deposit Deposit 500 Current Contribution New Account 6400 Withdrawal 430 Deposit 280 Deposit 800 Deposit 130 withdrawal Deposit Deposit 650 920 Current Current Current Current Current Current New New New New New New New Current Current Current Current Current Current Current Current Current Current Current Current Current Blue Ash Anderson Hills Anderson Hills Odhi Blue Ash Anderson Hills Delhi Anderson Hills Anderson Hills Anderson Hills Blue Ash Blue Ash Delhi Anderson Hills Blue Ash Anderson Hills Delhi Anderson Hills Anderson Hills Delhi Anderson Hills Blue Ash Anderson Hills Anderson Hills Blue Ash Anderson Hills Blue Ash Anderson Hills Delhi Anderson Hills 800 1300 140 Deposit 810 PeoplesChoiceBanktxt F25 x F G H Andersens DAN Current Current Current Current Current Current Current Current 3000 f x -IF($D$2:$D$35-$D$14,-E25,E25) C D E Checking Withdrawal 310 Checking Deposit 670 Checking withdrawal 230 Certificate of Depost New 15300 Certificate of Deposit New 18700 Certificate of Depost New 4 0800 New Account 400 New Account 500 Checiding New Account 2510 Checking New Account 3990 Checking New Account 590 Checking New Account 510 Checiding New Account 340 Certificate of Deposit New Account 43400 Certificate of Depost New Account 59600 Certificate of Deposit New Account 55800 Certificate of Deposit New Account Savings Withdrawal 1600 Savings Deposit Savings Deposit 1200 Savings Withdrawal 1500 IRA Current Contribution 1100 Checking Deposit 3350 Checking Deposit 2680 Checking Deposit 900 Checking Deposit 3710 Checking Deposit 3400 Checking Deposit 900 Checking Withdrawal 1010 IEEE Deposit Checking 280 Checking withdrawal 410 Certificate of Deposit Savings New Account 3100 Savings New Account Checking New Account 3100 Checking New Account 2809 Savings withdrawal 700 Current Contribution 3500 Current Contribution 2200 Checking Deposit 840 Deposit Checking 3250 Depost Checking 3650 Checking Deposit 920 418 19 Aug Tuesday 419 19 Aug Tuesday 420 19-Aug Tuesday 421 19 A Today 422 19 Aug Tuesday 423 19 Aug Tuesday 424 20 Aug Wednesday 425 20-Aug Wednesday 426 20 Aug Wednesday 427 20-4 Wednesday 428 20-Aug Wednesday 429 20-Aug Wednesday 430 20-Auf Wednesday 431 20 Aug Wednesday 432 20 Aug Wednesday 433 20-Aug Wednesday 434 20 Aug Wednesday 435 20 Aug Wednesday 436 20 Aug Wednesday 437 20-Aug Wednesday 438 20-Aug Wednesday 439 20-Aug Wednesday 440 20 Aug Wednesday 441 20 Aug Wednesday 442 20 Aug Wednesday 443 20-Aug Wednesday 444 20 Aug Wednesday 445 20 Aug Wednesday 446 20 Aug Wednesday 447 20 Aug Wednesday 448 20-Aug Wednesday 449 20 Aug Wednesday 450 21 Aug Thursday 451 21 Aug Thursday 452 21 Aug Thursday 453 21 Aug Thursday 454 21-Aug Thursday 455 21 Aug Thursday 1456 21 Aug Thursday 457 21 Aug Thursday 458 21 Aug Thursday 459 21 Aug Thursday 460 21-Aug Thursday Current Current Current Current Current Current Current Current Current Current Current Current Current New New Anderson Hills Anderson Hills Dan Anderson Hills De Anderson Anderson Hills Anderson Hills Anderson Hills Blue Ash Den Delhi Delhi Anderson Hills Delhi Blue Ash Blue Ash Anderson Hills Anderson Hills Blue Ash Anderson Hills Anderson Hills Anderson Hills Delhi Delhi Delhi Anderson Hills Anderson Hills Delhi Blue Ash Anderson Anderson Halls Delhi Anderson Hills Anderson Hills Blue Ash Blue Ash Anderson Hills Andersen Del Anderson 410 12700 Current Current Current Current Current Current Current PeoplesChoiceBanktxt F25 A * fx =IF($D$2:$D$35=$D$14,525,825) CD G H 500 2900 1600 Anderson Hills Blue Ath NA New Ne Nue Ach Anderson Hills Anderson Hills Nuech Anderson Hills Nuh 1000 1100 3400 710 740 430 890 35900 55100 22500 3600 2900 2500 No 2 700 1 504 25-Aug Monday 505 25 Aug Monday 506 25.Aur Monday 507 25-Aug Monday 508 25-Aug Monday 509 25 Aug Monday 510 25-Aug Monday 511 25 Aug Monday 512 25-Au Monday 513 25.Aug Monday 51425 Monday 515 25-Aug Monday 516 25-Aug Monday 517 25 Monday 518 25 Aug Monday 519 25 Aug Monday 520 25 Aug Monday 521 25-Aug Monday 522 25-Aug Monday 523 25 Aug Monday 524 25 Aug Monday 525 25 Aug Monday 526 25-Aug Monday 527 25 Aug Monday 528 25-Aug Monday 529 25 Aug Monday 530 25-Aug Monday 531 25-Aug Monday 532 25-Aug Monday 533 25 Aug Monday 534 25-Aug Monday $35 25-Aug Monday 536 25-Aug Monday 537 25-Aug Monday 538 25-Aug Monday 539 26 Aug Tuesday 540 26 Aug Tuesday 541 26 Aug Tuesday 542 26 Aug Tuesday 543 26 Aug Tuesday 54 26 Aug Tuesday 545 26 Aug Tuesday 546 26 Aug Tuesday Sawings Savings Savings Savings Savings Savings IRAN N Checking Checking Checking Checking Certificate of Deposit Certificate of Depost Certificate of Deposit Certificate of Deposit Saving Savings Saving Savings Savings Savings Savings Savings Checking Checking Checking Checking Checking Checking Checking Checking Checking Checking Certificate of Deposit Certificate of Deposit Savings Checking Checking Checking Checking Checking Certificate of Deposit Certificate of Depost New Account New Account New Account New Account New Account New Account ew Account New Account New Account New Account New Account New Account New Account New Account New Account Deposit Withdrawal Deposit Withdrawal Deposit Withdrawal withdrawal Deposit Deposit Withdrawal Deposit Deposit Deposit Withdrawal withdrawal Deposit Deposit withdrawal New New New Account New Account New Account New Account New Account New Account New Account New Account 800 2100 1800 1600 Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current Current 3310 3770 2900 Anderson Hills Anderson Hills Delhi Anderson Hills Blue Ash Anderson Hills Anderson Hills Blue Ash Blue Ash Delhi Blue Ash Blue Ash Blue Ash Anderson Hills Blue Ash Blue Ash Anderson Hills Anderson Hills Anderson Hills Anderson Hills Blue Ach Anderson Hills Anderson Hills Delhi Anderson Hills Anderson Hills Blue Ash Blue Ash Anderson Hills Anderson Hills Blue Ash Blue Ash Anderson 3230 3670 Current 510 52000 6100 Current Current 2570 2500 PeoplesChoiceBanktxt 27900 1900 2900 1200 2000 Anderson Hill Blue Ach Blue Ash Anderson is Blue Ach Nuh 2200 3000 Current Current Current Current Current Current Current Current Current Current Current Current Current 2300 6900 300 2020 Anderson DAN Nuesh Du Anderson Hills Anderson Hills 910 9 De 900 1900 2900 NOW New New Blue Ach Blue Ash Anderson Hills Anderson Hills Anderson Hills New 900 160 45200 1100 547 26-Aug Tuesday Certificate of Deposit New Account 548 26 Aug Tuesday Savings Deposit 549 26 Aug Tuesday Sawings Deposit $50 26-ug Tuesday savings Depout 551 26 Aug Tuesday Savings Deposit 552 26 Tuesday Savings Deposit 553 26 Aug Tuesday Savings Depost 554 26-Aug Tuesday IRA Current Contribution 555 26 Aug Tuesday JIRA Current Contribution 556 26 Aug Tuesday IRA New Account 552 26.Aur Tuesday Checkling Decout 558 26 Aug Tuesday Checking Depost 559 26-Aug Tuesday Checking Withdrawal 560 26 Aug Tuesday Certificate of Deposit New 561 27-Aug Wednesday Saving New Account 562 27-Aug Wednesday Savings New Account 563 27-Aug Wednesday Savings New Account 564 27-Aug Wednesday Savings New Account 565 27-Aug Wednesday Checking New Account 566 27-Aug Wednesday Certificate of Deposit New Account 567 27-Aug Wednesday Savings Deposit 568 27-Aug Wednesday Savings Deposit 569 27-Aug Wednesday Current Contribution 570 27-Aug Wednesday Checking Deposit 571 27-Aug Wednesday Checking Deposit 572 27-Aug Wednesday Checking Withdrawal 573 27 Aug Wednesday Checking Deposit 574 27 Aug Wednesday Checking Deposit 525 27 Aug Wednesday Certificate of Deposit 576 27.Aug Wednesday Certificate of Deposit 577 28 Aug Thursday Savings New Account 578 28 Aug Thursday Checking New Account 579 28 Aug Thursday Checking New Account SO 28 Aug Thursday Certificate of Deposit New Account 581 28-Aug Thursday Certificate of Deposit New Account 582 28 Aug Thursday Saving Deposit 583 28-Aug Thursday Savings Withdrawal 584 28 Aug Thursday Savings Withdrawal 58 28 Aug Thursday IRA Current Contribution 586 28 Aug Thursday Checking 587 25 Aug Thursday Checking Withdrawal 588 28-Aug Thursday Checking Withdrawal 589 28-Aug Thursday C hecking Deposit 590 28 Aus Thursday Checking Withdrawal PeoplesChoiceBanktxt 2800 1300 840 780 51700 36600 2300 530 480 25700 24400 200 200 1300 2800 810 New New Current Current Current Current Current Current Current Current Current Current New New New New New Current Current Current Current Current Current Current Current Current Anderson Hills Delhi Blue Ash Anderson Halls Anderson Hills Delhi Delhi Anderson Hills Anderson Hills Delhi Blue Ash Delhi Anderson Hills Delhi Anderson Hills Anderson Hills Anderson Hills Anderson Hills Blue Ash Deposit De Nuesh Anderson Hills Delhi Blue Ash F25 X X =IF($D$2:$D$35=$D$14,-E25, E25) 240 Checking Checking Savings Savings Checking Checking Checking Certificate of Deposit Savings Savings Savings Savings Savings N Delhi Blue Ach Alue Ash Anderson Hills Anderson Hills Anderson Hills Blue Ash Dih 300 3100 110 3070 450 2 2700 400 N 589 28-Aug Thursday 590 28-Aug Thursday 591 29-Aug Friday 592 29-Aug Friday 593 29-Aur Friday 594 29 Aug Friday 595 29-Aug Friday 596 29-Aug Friday 597 29-Aug Friday 598 29-Aug Friday 599 29-Aug Friday 600 29-Aug Friday 601 29-Aug Friday 602 29-Aug Friday 603 29-Aug Friday 604 29 Aug Friday 605 29-Aug Friday 606 29-Aug Friday 607 29-Aug Friday 508 30 Aug Saturday 609 30-Aug Saturday 610 30 Aug Saturday 611 30 Aug Saturday 612 30 Aug Saturday 613 30-Aug Saturday 614 30 Aug Saturday 615 30-Aug Saturday 1616 30 Aug Saturday 617 20 Aug Saturday 618 30 Aug Saturday 619 30-Aug Saturday 620 30 Aug Saturday 621 30 Aug Saturday Blue Ash Current Current New New New New New New Current Current Current Current Current Current Current Current Current Deposit Withdrawal New Account New Account ew Account New Account ew Account New Account E Deposit Deposit withdrawal Deposit Deposit Withdrawal Withdrawal Current Contribution Deposit Withdrawal withdrawal New Account New Account New Account Deposit Withdrawal Deposit New Deposit Deposit Deposit Deposit Withdraw Deposit Deposit Savings IRA Checking Checking Checking Certificate of Deposit Certificate of Deposit Certificate of Deposit Checking Checking Checking Certificate of Deposit Savings Savings Savings Saving Savings Savings Checking 190 580 37300 59200 15100 2880 620 160 44900 3000 Anderson Hills Blue Ash Anderson Hills Blue Ash Blue Ash Anderson Hills Blue Ash Anderson Hills Delhi Blue Ach Blue Ash Anderson Hills Delhi Delhi Delhi Anderson Hills Delhi Delhi Delhi Anderson Hills Blue Ach Blue Ash Blue Ash Anderson Hills 2900 1400 Current Current Current Current Current Current Current Current Current Current Current 2400 1000 500 790 PeoplesChoiceBanktxt