Spreadsheet: 686543d1594675225-aligning-data-with-2-softwares-formula-sheet
Sheet: Donor Pro

DONOR_ID | GIFT_ID | first_name | last_name | opt_line | address | address2 | city | state | zip | email | AMOUNT | GIFT_DATE | SOLICIT_CODE_DESCR | SOLICIT_CODE | SUB_SOLICIT_CODE_DESCR | SUB_SOLICIT_CODE | TRANSACTIONAMOUNT | TRANSACTION_CODE | TRANSACTION_ID | TRANSACTION_STATUS
2281 | 10916 | Suzanne | Bernard |  |  |  |  |  |  |  | 0 | 2020-06-04 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
2316 | 11032 |  | Boblick |  |  |  |  |  |  |  | 500 | 2020-06-15 00:00:00 | [NAME] | COVID-19
2860 | 10950 | [NAME] and [NAME] | Grills |  |  |  |  |  |  |  | 25 | 2020-06-11 00:00:00 | [NAME] | COVID-19
3352 | 10894 | [NAME] | Madden |  |  |  |  |  |  |  | 0 | 2020-06-01 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
3577 | 11024 | Bernadine | Nawara |  |  |  |  |  |  |  | 100 | 2020-06-25 00:00:00 | [NAME] | COVID-19
3700 | 11022 | Rande | Pauly |  |  |  |  |  |  |  | 25 | 2020-06-27 00:00:00 | [NAME] | COVID-19
3797 | 10969 | [NAME] | Rehn | Helen |  |  |  |  |  |  | 0 | 2020-06-17 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
4560 | 11025 |  | First Presbyterian Church of La Grange | Mission and Outreach Committee |  |  |  |  |  |  | 1750 | 2020-06-26 00:00:00 | LATH | LATH
5176 | 10912 | [NAME] | Schiltz |  |  |  |  |  |  |  | 0 | 2020-06-04 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
5239 | 10976 | [NAME] | Hampton |  |  |  |  |  |  |  | 50 | 2020-06-09 00:00:00 | Unsolicited Donation | 52 | Monthly | MONTHLY
5288 | 10982 | Issa | Muasher | Peggy |  |  |  |  |  |  | 1010 | 2020-06-22 00:00:00 | [NAME] | COVID-19 |  |  |  |  | 5448708785
5328 | 11051 |  | Proviso Township Mental Health Commission | [NAME], Director of Program Administration |  |  |  |  |  |  | 2500 | 2020-06-29 00:00:00 | Grant/Contract (Government) | 58
5361 | 11017 |  | St. John Of The Cross Parish | Rev. [NAME] |  |  |  |  |  |  | 500 | 2020-06-26 00:00:00 | [NAME] | COVID-19
5542 | 10989 | Cameron | Walker | [NAME] |  |  |  |  |  |  | 1010 | 2020-06-27 00:00:00 | [NAME] | COVID-19 |  |  |  |  | 5459361298
5644 | 10936 | [NAME] | [NAME] | Kathy |  |  |  |  |  |  | 510 | 2020-06-08 00:00:00 | [NAME] | COVID-19 |  |  |  |  | 5418169379
5758 | 10868 | [NAME] | [NAME] | Dominica |  |  |  |  |  |  | 0 | 2020-06-01 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
5960 | 10974 | Dennis | [NAME] | [NAME] |  |  |  |  |  |  | 0 | 2020-06-17 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
6109 | 10956 | [NAME] | Schwartz |  |  |  |  |  |  |  | 50 | 2020-06-15 00:00:00 | Unsolicited Donation | 52 | Monthly | MONTHLY
6305 | 10929 |  | Smothers Realty Group | [NAME] |  |  |  |  |  |  | 0 | 2020-06-05 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
6422 | 10992 | [NAME] | Sheehan |  |  |  |  |  |  |  | 1 | 2020-06-30 00:00:00 | Unsolicited Donation | 52
6476 | 10862 | [NAME] and Anne | Metzger |  |  |  |  |  |  |  | 0 | 2020-06-01 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
6478 | 10986 | [NAME] | Cushing |  |  |  |  |  |  |  | 103 | 2020-06-24 00:00:00 | [NAME] | COVID-19 |  |  |  |  | 5452811967
6615 | 10983 | Dawn | [NAME] |  |  |  |  |  |  |  | 103 | 2020-06-22 00:00:00 | [NAME] | COVID-19 |  |  |  |  | 5448026098
6615 | 10924 | Dawn | [NAME] |  |  |  |  |  |  |  | 77.25 | 2020-06-05 00:00:00 | [NAME] | COVID-19 |  |  |  |  | 5411011485
6651 | 10906 | [NAME] | Lannan | [NAME] |  |  |  |  |  |  | 0 | 2020-06-04 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
6744 | 10864 | George | [NAME] | Roberta |  |  |  |  |  |  | 0 | 2020-06-01 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
7287 | 10920 | [NAME] | Fischer | Teresa |  |  |  |  |  |  | 0 | 2020-06-04 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
7307 | 10939 | The | Chicago Community Trust | [NAME], Director, Community Impact |  |  |  |  |  |  | 50000 | 2020-06-05 00:00:00 | Grant (Private) | 57
7379 | 10984 | Tomaso | [NAME] |  |  |  |  |  |  |  | 50 | 2020-06-26 00:00:00 | [NAME] | COVID-19 |  |  |  |  | 5455488618
7522 | 10834 |  | Riverside Junior Women's Charity | [NAME] |  |  |  |  |  |  | 600 | 2020-06-20 00:00:00 | Unsolicited Donation | 52
7605 | 10865 | [NAME] | Spiering |  |  |  |  |  |  |  | 0 | 2020-06-01 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
7607 | 10833 |  | Zurich American Insurance Company | Ms. [NAME], [NAME], Employee Experience & Culture |  |  |  |  |  |  | 5000 | 2020-06-01 00:00:00 | Corporate [NAME] | CORPORATEGIFT
7628 | 11010 |  | [NAME] |  |  |  |  |  |  |  | 1000 | 2020-06-22 00:00:00 | LATH | LATH
7634 | 11030 | [NAME] | [NAME] |  |  |  |  |  |  |  | 200 | 2020-06-22 00:00:00 | Unsolicited Donation | 52 | Monthly | MONTHLY
7634 | 10954 | [NAME] | [NAME] |  |  |  |  |  |  |  | 100 | 2020-06-10 00:00:00 | Unsolicited Donation | 52 | Monthly | MONTHLY
7663 | 10975 | [NAME] | McVicker |  |  |  |  |  |  |  | 0 | 2020-06-17 00:00:00 | [NAME] | COVID-19 | Inkind | INKIND
8167 | 10905 | Mark | [NAME] | [NAME] |  |  |  |  |  |  | 0 | 2020-06-04 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
8252 | 10963 | [NAME] | [NAME] | Mr. [NAME] |  |  |  |  |  |  | 103 | 2020-06-17 00:00:00 | [NAME] | COVID-19 |  |  |  |  | 5436226252
8269 | 10913 | Regina | Blackstone |  |  |  |  |  |  |  | 0 | 2020-06-04 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
8298 | 10898 | Krystal | Steiner |  |  |  |  |  |  |  | 0 | 2020-06-01 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
8309 | 10899 | [NAME] | Reynolds |  |  |  |  |  |  |  | 0 | 2020-06-01 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
8359 | 11031 |  | Compassion United Methodist Church | Rev. [NAME] |  |  |  |  |  |  | 512.33 | 2020-06-13 00:00:00 | Unsolicited Donation | 52
8643 | 10886 | Heather | [NAME] |  |  |  |  |  |  |  | 0 | 2020-06-01 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
8660 | 10908 | [NAME] | Newman | [NAME] |  |  |  |  |  |  | 0 | 2020-06-04 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
8705 | 10961 | The | VNA Foundation | [NAME], Sr. Program Officer |  |  |  |  |  |  | 40000 | 2020-06-15 00:00:00 | Grant (Private) | 57
8775 | 10930 |  | [NAME] | [NAME], Partner |  |  |  |  |  |  | 25000 | 2020-06-01 00:00:00 | [NAME] | COVID-19
8781 | 10870 | [NAME] | Tymick | [NAME] |  |  |  |  |  |  | 0 | 2020-06-01 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
9351 | 10979 | [NAME] | Okrent | 1996 |  |  |  |  |  |  | 309 | 2020-06-19 00:00:00 | [NAME] | COVID-19 |  |  |  |  | 5441770006
9534 | 10858 |  | Sweetener Supply Corporation | [NAME] |  |  |  |  |  |  | 0 | 2020-06-01 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
9579 | 10962 |  | United Way of Metropolitan Chicago | [NAME], Vice President, Community Impact |  |  |  |  |  |  | 7175 | 2020-06-15 00:00:00 | Grant (Private) | 57
9683 | 10921 | [NAME] | Fitzpatrick | The Fitzpatrick Family |  |  |  |  |  |  | 0 | 2020-06-04 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
9752 | 10958 | [NAME] | [NAME] |  |  |  |  |  |  |  | 10 | 2020-06-01 00:00:00 | Unsolicited Donation | 52 | Monthly | MONTHLY
9801 | 11036 | Ricardo and [NAME] | Martinez |  |  |  |  |  |  |  | 50 | 2020-06-22 00:00:00 | Unsolicited Donation | 52 | Monthly | MONTHLY
9909 | 10861 | [NAME] | [NAME] |  |  |  |  |  |  |  | 0 | 2020-06-01 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
10101 | 10914 | [NAME] | Thiessen | [NAME] |  |  |  |  |  |  | 0 | 2020-06-04 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
10214 | 11046 |  | Lyons Township Mental Health Commission | [NAME], Executive Director |  |  |  |  |  |  | 41000 | 2020-06-01 00:00:00 | Grant/Contract (Government) | 58
10271 | 10955 | [NAME] | [NAME] | [NAME] |  |  |  |  |  |  | 5000 | 2020-06-08 00:00:00 | [NAME] | COVID-19
10311 | 10949 | [NAME] | Sloan |  |  |  |  |  |  |  | 50 | 2020-06-11 00:00:00 | [NAME] | COVID-19
10329 | 10993 | [NAME] | [NAME] |  |  |  |  |  |  |  | 25.75 | 2020-06-30 00:00:00 | [NAME] | COVID-19 |  |  |  |  | 5465413589
10555 | 10887 | [NAME] | Nortier | Michelle |  |  |  |  |  |  | 0 | 2020-06-01 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
10585 | 10910 | Peggy | Lyons |  |  |  |  |  |  |  | 0 | 2020-06-04 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
10630 | 10895 | [NAME] | O'Neill |  |  |  |  |  |  |  | 0 | 2020-06-01 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
10741 | 10994 |  | Enterprise Holdings Foundation | Ms. [NAME] |  |  |  |  |  |  | 1500 | 2020-06-23 00:00:00 | Grant (Private) | 57
10918 | 10970 | Frances | Colby |  |  |  |  |  |  |  | 0 | 2020-06-17 00:00:00
11182 | 10941 | [NAME] | [NAME] |  |  |  |  |  |  |  | 50 | 2020-06-03 00:00:00 | [NAME] | COVID-19
11202 | 10968 | [NAME] | Schaper |  |  |  |  |  |  |  | 0 | 2020-06-17 00:00:00 | Soup & Bread 2020 | SOUP2020 | Inkind | INKIND
11205 | 10909 | [NAME] | [NAME] |  |  |  |  |  |  |  | 0 | 2020-06-04 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
11221 | 10885 |  | LaGrange Field Club | [NAME] |  |  |  |  |  |  | 0 | 2020-06-01 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
11314 | 10948 | Vicky | Rehill |  |  |  |  |  |  |  | 25.75 | 2020-06-11 00:00:00 | [NAME] | COVID-19 |  |  |  |  | 5423614056
11366 | 10965 | Heather | [NAME] | Jozmine & Taylor |  |  |  |  |  |  | 0 | 2020-06-17 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
11433 | 10977 | [NAME] | Unander |  |  |  |  |  |  |  | 50 | 2020-06-19 00:00:00 | [NAME] | COVID-19 |  |  |  |  | 5440554082
11451 | 10988 | Kelly | Fulscher |  |  |  |  |  |  |  | 25 | 2020-06-29 00:00:00 | [NAME] | COVID-19 |  |  |  |  | 5461549293
11524 | 10971 | [NAME] | Crowley |  |  |  |  |  |  |  | 0 | 2020-06-17 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
11556 | 11026 | Nathan | [NAME] |  |  |  |  |  |  |  | 10 | 2020-06-22 00:00:00 | Unsolicited Donation | 52
11624 | 11028 | [NAME] | Bennick |  |  |  |  |  |  |  | 100 | 2020-06-29 00:00:00 | [NAME] | COVID-19
11632 | 10897 | Kerri | Kovel |  |  |  |  |  |  |  | 0 | 2020-06-01 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
11756 | 10985 | [NAME] | [NAME] |  |  |  |  |  |  |  | 50 | 2020-06-26 00:00:00 | [NAME] | COVID-19 |  |  |  |  | 5455488675
11760 | 10987 | [NAME] | Gibbons |  |  |  |  |  |  |  | 25.75 | 2020-06-27 00:00:00 | [NAME] | COVID-19 |  |  |  |  | 5458105166
11771 | 10978 | Leland | [NAME] |  |  |  |  |  |  |  | 1010 | 2020-06-19 00:00:00 | [NAME] | COVID-19 |  |  |  |  | 5442324115
11781 | 10973 | Sara | Cushing |  |  |  |  |  |  |  | 0 | 2020-06-17 00:00:00 | [NAME] | COVID-19 | Inkind | INKIND
11858 | 10911 | [NAME] | Piazza |  |  |  |  |  |  |  | 0 | 2020-06-04 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
11922 | 10926 | [NAME] | Horsky |  |  |  |  |  |  |  | 103 | 2020-06-05 00:00:00 | [NAME] | COVID-19 |  |  |  |  | 5411689872
11922 | 10981 | [NAME] | Horsky |  |  |  |  |  |  |  | 51.5 | 2020-06-19 00:00:00 | [NAME] | COVID-19 |  |  |  |  | 5440457591
11943 | 10925 | [NAME] | Sutton |  |  |  |  |  |  |  | 51.5 | 2020-06-05 00:00:00 | [NAME] | COVID-19 |  |  |  |  | 5411011559
11954 | 10932 | [NAME] | Cygal |  |  |  |  |  |  |  | 10.3 | 2020-06-08 00:00:00 | [NAME] | COVID-19 |  |  |  |  | 5417168973
11996 | 10860 | Anna | [NAME] |  |  |  |  |  |  |  | 0 | 2020-06-01 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
11997 | 10863 | [NAME] | [NAME] |  |  |  |  |  |  |  | 0 | 2020-06-01 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
11998 | 10866 | Cathy | [NAME] |  |  |  |  |  |  |  | 0 | 2020-06-01 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
11999 | 10867 | [NAME] | Tenuta |  |  |  |  |  |  |  | 0 | 2020-06-01 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
12000 | 10871 | Eleanor | McMeen |  |  |  |  |  |  |  | 0 | 2020-06-01 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
12001 | 10883 | [NAME] | Olsen |  |  |  |  |  |  |  | 0 | 2020-06-01 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
12002 | 10884 | Emma | Kaple |  |  |  |  |  |  |  | 0 | 2020-06-01 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
12003 | 10888 | [NAME] | [NAME] |  |  |  |  |  |  |  | 0 | 2020-06-01 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
12004 | 10889 | Jessica | McClean |  |  |  |  |  |  |  | 0 | 2020-06-01 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
12005 | 10890 | [NAME] | [NAME] |  |  |  |  |  |  |  | 0 | 2020-06-01 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
12006 | 10891 | [NAME] | O'Connell |  |  |  |  |  |  |  | 0 | 2020-06-01 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
12007 | 10892 | [NAME] | Lynch |  |  |  |  |  |  |  | 0 | 2020-06-01 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
12008 | 10893 | Karin | Carney |  |  |  |  |  |  |  | 0 | 2020-06-01 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
12009 | 10896 | [NAME] | Pece |  |  |  |  |  |  |  | 0 | 2020-06-01 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
12010 | 10900 | [NAME] | Standaert |  |  |  |  |  |  |  | 103 | 2020-06-02 00:00:00 | [NAME] | COVID-19 |  |  |  |  | 5404788320
12012 | 10901 | [NAME] | [NAME] |  |  |  |  |  |  |  | 0 | 2020-06-04 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
12013 | 10902 | Meredith | Adler |  |  |  |  |  |  |  | 0 | 2020-06-04 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
12014 | 10903 | [NAME] | O'Connell |  |  |  |  |  |  |  | 0 | 2020-06-04 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
12015 | 10904 | Michelle | Mahoney |  |  |  |  |  |  |  | 0 | 2020-06-04 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
12016 | 10907 | [NAME] | [NAME] |  |  |  |  |  |  |  | 0 | 2020-06-04 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
12017 | 10915 | [NAME] | [NAME] |  |  |  |  |  |  |  | 0 | 2020-06-04 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
12018 | 10917 | [NAME] | [NAME] |  |  |  |  |  |  |  | 0 | 2020-06-04 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
12019 | 10918 | Tania | Cuellar |  |  |  |  |  |  |  | 0 | 2020-06-04 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
12020 | 10919 | Tara | Bradbury |  |  |  |  |  |  |  | 0 | 2020-06-04 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
12021 | 10922 |  | Mazich Family |  |  |  |  |  |  |  | 0 | 2020-06-04 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
12022 | 10923 | [NAME] | Blasco |  |  |  |  |  |  |  | 0 | 2020-06-04 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
12023 | 10928 | [NAME] | Werwas |  |  |  |  |  |  |  | 25.75 | 2020-06-03 00:00:00 | [NAME] | COVID-19 |  |  |  |  | 5408250372
12023 | 10927 | [NAME] | Werwas |  |  |  |  |  |  |  | 0 | 2020-06-03 00:00:00 | [NAME] | COVID-19
12024 | 10933 | [NAME] | Jones |  |  |  |  |  |  |  | 206 | 2020-06-08 00:00:00 | [NAME] | COVID-19 |  |  |  |  | 5417467403
12029 | 10943 |  | Sisters of Mercy | Sr. [NAME] |  |  |  |  |  |  | 1000 | 2020-06-03 00:00:00 | [NAME] | COVID-19 | 3rd Party Fundraiser | SPECIALCOLLECTION
12031 | 10953 | Ellen | [NAME] |  |  |  |  |  |  |  | 51.5 | 2020-06-14 00:00:00 | [NAME] | COVID-19 |  |  |  |  | 5430858215
12032 | 10964 | Raj & Sujata | [NAME] |  |  |  |  |  |  |  | 0 | 2020-06-17 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
12033 | 10966 | Tara | [NAME] |  |  |  |  |  |  |  | 0 | 2020-06-17 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
12034 | 10967 | Miguel | Zarala |  |  |  |  |  |  |  | 0 | 2020-06-17 00:00:00 | Unsolicited Donation | 52 | Inkind | INKIND
12036 | 10980 | [NAME] | Bachmann |  |  |  |  |  |  |  | 51.5 | 2020-06-19 00:00:00 | [NAME] | COVID-19 |  |  |  |  | 5441352436
12038 | 10990 | Mark | [NAME] |  |  |  |  |  |  |  | 103 | 2020-06-26 00:00:00 | [NAME] | COVID-19 |  |  |  |  | 5457401411
12045 | 11016 | [NAME] | Cooney |  |  |  |  |  |  |  | 50 | 2020-06-21 00:00:00 | [NAME] | COVID-19
12046 | 11021 |  | YMCA of Metro Chicago |  |  |  |  |  |  |  | 1200 | 2020-06-01 00:00:00 | [NAME] | COVID-19
12048 | 11042 |  | EFSP (UWMC) | [NAME], Director, Community Impact, UWMC |  |  |  |  |  |  | 100000 | 2020-06-30 00:00:00 | [NAME] | COVID-19
12048 | 11043 |  | EFSP (UWMC) | [NAME], Director, Community Impact, UWMC |  |  |  |  |  |  | 35494 | 2020-06-30 00:00:00 | Grant/Contract (Government) | 58