A B 0 P 1 First Name Last Name 2 Ram Aring 3 Charles Bartlett 4 Tina Baumann 5 Samrat Beard 6 Brian Brannen 7 Kevin Butterworth 8 Todd Cameron 9 Deanna cline 10 Laura Davis 11 Sourav Dicken 12 Rabonne Doyle 13 Croix Dunn 14 Alfred Garber 15 Joseph Harrison 16 Jacob Hill 17 Timika Hom 18 Brian Humphrey | 19 Kyra Janus 20 Catrice Kenny 21 Jaline Lopez 22 Charles Moore 23 Kelley Nicholson 24 Kevin Okoli 25 Benjamin O'Neill 26 Mariana Roberts 27 Kenneth Santos 28 Andrew Stanley 29 Emily Valeus 30 Tom Werner 31 Priscilla Werner 32 Keith Wright 33 Johnny Wynter 34 C D E F G H J K SSN Credit Score 1 Credit Score 2 Credit Score 3 Credit Score Average Income 1 Income 2 Debt 1 Debt 2 4.11E+09 799 793 804 799 $72,441.00 $8,653.00 $76,713.00 $10,357.00 1.89E+09 786 777 796 786 $30,391.00 $0.00 $72,177.00 $6,233.00 3.22E+09 623 618 622 621 $51,465.00 $0.00 $60,954.00 $7,751.00 1.11E+09 661 651 670 661 $57,483.00 $0.00 $69,784.00 $6,124.00 4.4E+09 359 364 368 364 $32,968.00 $6,468.00 $55,384.00 $8,188.00 5.02 E+09 543 534 553 543 $40,595.00 $0.00 $52,340.00 $7,451.00 2.97E+09 552 557 555 555 $61,145.00 $8,441.00 $83,383.00 $10,914.00 1.02 E+09 648 652 659 653 $ 74,024.00 $3,535.00 $85,464.00 $8,074.00 8.07E+09 721 713 727 720 $54,224.00 $0.00 $ 84,474.00 $8,510.00 7.37E+09 837 835 837 836 $37,400.00 $7,866.00 $52,900.00 $0.00 4.34E+09 626 623 634 628 $41,146.00 $0.00 $67,292.00 $6,587.00 7.07E+09 337 341 336 338 $46,209.00 $8,353.00 $ 65,045.00 $6,064.00 2.92E+09 634 626 631 630 $28,480.00 $3,410.00 $71,641.00 $7,026.00 3.5E+09 493 483 490 489 $49,987.00 $7,603.00 $60,684.00 $7,250.00 6.44E+09 335 336 342 338 $57,692.00 $0.00 $56,729.00 $6,976.00 3 E+09 778 775 776 776 $37,823.00 $0.00 $72,756.00 $0.00 346 337 341 341 $56,884.00 $9,892.00 $74,717.00 $0.00 5.99E+09 692 680 702 691 $56,287.00 $3,522.00 $71,422.00 $6,292.00 6.45E+09 657 657 664 659 $68,768.00 $9,238.00 $92,108.00 $10,523.00 7.43E+09 787 786 795 789 $ 55,617.00 $0.00 $54,921.00 $6,859.00 2.94E+09 774 773 784 777 $26,830.00 $0.00 $54,683.00 $5,045.00 5.16E+09 563 556 574 564 $43,770.00 $7,257.00 $69,994.00 $8,195.00 4.55E+09 723 725 722 723 $29,382.00 $0.00 $ 70,826.00 $5,404.00 9.1 E+08 736 724 740 733 $46,044.00 $0.00 $61,768.00 $0.00 5.46E+09 438 436 435 436 $36,736.00 $9,445.00 $76,469.00 $11,740.00 2.53E+09 556 547 552 552 $44,236.00 $3,082.00 $72,666.00 $6,283.00 4.8E+09 567 561 570 566 $41,882.00 $0.00 $64,593.00 $5,130.00 1.44E+09 476 464 483 474 $56,392.00 $4,038.00 $72,431.00 $0.00 8.18E+09 424 421 432 426 $74,397.00 $0.00 $93,433.00 $10,836.00 4.24E+09 805 805 804 805 $53,951.00 $9,712.00 $75,791.00 $10,712.00 7.5 E+09 721 717 716 718 $68,246.00 $7,747.00 ### $11,536.00 5.11E+09 503 502 499 501 $47,959.00 $4,549.00 $64,771.00 $5,571.00 L M M N Recent bankruptcy Redent denial Income/Payment Ratio NO Yes 0.32 NO No 0.62 NO No 0.34 NO No 0.35 NO No 0.48 NO No 0.36 NO No 0.41 YES No 0.36 NO No 0.47 NO No 0.41 NO No 0.44 NO No 0.39 NO No 0.74 NO No 0.35 NO No 0.28 NO No 0.49 NO No 0.36 NO No 0.39 NO No 0.39 NO No 0.31 NO No 0.49 NO No 0.46 NO No 0.58 NO No 0.40 NO No 0.57 NO No 0.50 NO No 0.46 NO No 0.39 YES No 0.40 NO No 0.41 No NO NO 0.46 0.40 No 35 A B C D E F G H K M N 0 P Q 1 First Name Last Name Complete Applicant Issue in Recent Activity Credit Score 1 Check Credit Score 2 Check Credit Score 3 Check Preapproval TRUE YES OK OK OK FALSE 2 Ram Aring Help Tommy by completing the following. 3 Charles Bartlett TRUE NO OK OK OK TRUE 4. Tina Baumann TRUE NO OK OK OK TRUE 5 Samrat Beard TRUE NO OK OK OK TRUE 1. Use the AND function can help determine if the application is complete. NOTE: Sometimes when you are selecting data from different pages, the spreadsheet will also insert the dollar signs to help make cell references absolute. You will need to manually removed these if it does insert them. Brannen TRUE NO OK OK OK TRUE 6 Brian 7 Kevin Butterworth TRUE NO OK OK OK TRUE 8 Todd TRUE NO OK OK OK TRUE 2. Use the OR can determine if someone has either filed for bankruptcy or been denied a loan. TRUE YES OK OK OK FALSE 9 Deanna 10 Laura Cameron cline Davis Dicken Doyle TRUE NO OK OK OK TRUE 11 Sourav TRUE NO OK OK OK TRUE 3. Use IF function to determine if there are any issues with the consistency of the credit score. Check to see if any of the scores are 10 points higher than that individual's average. NO OK OK OK TRUE 12 Rabonne 13 Croix 14 Alfred TRUE FALSE Dunn NO OK OK OK TRUE TRUE Garber TRUE NO OK OK OK 4. Use the AND function to determine if an applicant has met the requirements to be preapproved for final consideration by the committee. Harrison TRUE NO OK OK OK TRUE 15 loseph 16 lacob Hill FALSE NO OK OK OK TRUE 17 Timika Horn TRUE NO OK OK OK TRUE TRUE Humphrey FALSE NO OK OK OK 18 Brian 19 Kyra NOTE: In general when you are entering text into an "IF" statement you have to surround it with quotes. However, there are times when, if the text in the cell you are pointing to is the result of a logical function, that the quotes are not necessary. This will be different based on the version of your spreadsheet you are using. However, the final IF statement will work. You just may have to give it a few attemps to find the correct combination. Janus TRUE NO OK OK FALSE BAD OK 20 Catrice TRUE NO OK OK TRUE TRUE NO OK OK OK TRUE 21 laline 22 Charles 23 Kelley TRUE NO OK OK OK TRUE Kenny Lopez Moore Nicholson Okoli O'Neill NO OK OK OK TRUE TRUE TRUE 24 Kevin NO OK OK OK TRUE TRUE NO OK OK OK TRUE Roberts TRUE NO OK OK OK TRUE TRUE NO OK OK OK TRUE Santos Stanley Valeus TRUE NO OK OK OK 25 Benjamin 26 Mariana 27 Kenneth 28 Andrew 29 Emily 30 Tom 31 Priscilla 32 Keith TRUE TRUE NO OK OK OK TRUE Werner TRUE YES OK OK OK FALSE Werner NO OK OK OK TRUE TRUE TRUE NO OK OK OK TRUE Wright Wynter TRUE NO OK OK OK TRUE 33 lohnny 34 35 CH 7 Spreadsheet Activity--Additional Instructions From the Tommy's Applicant Sheet A B D E F G H 1 J K M Recent denial Income 1 Income 2 Debt 1 Debt 2 First Name Last Name SSN Credit Score 1 Credit Credit Score Score 3 2 L Recent bankruptcy Credit Score Average N Income/Payment Ratio D H Preapproval +From Tommy's Helpful Data Sheet B C First Last Complete Applicant Name Name Use the AND function can help determine if the application is complete. NOTE: Sometimes when you are selecting data from different pages, the spreadsheet will also insert the dollar signs to help make cell references absolute. You will need to manually removed these if it does insert them. E F G Credit Score 1 Credit Score 2 Credit Score 3 Check Check Check Use IF function to determine if there are any issues with the consistency of the credit score. Check to see if any of the scores are 10 points higher than that individual's average. Issue in Recent Activity Use the OR can determine if someone has either filed for bankruptcy or been denied a loan. NOTE: In general when you are entering text into an "IF" statement you have to surround it with quotes. However, there are times when, if the text in the cell you are pointing to is the result of a logical function, that the quotes are not necessary. This will be different based on the version of your spreadsheet you are using. However, the final IF statement will work. You just may have to give it a few attempts to find the correct combination. Use the AND function to determine if an applicant has met the requirements to be preapproved for final consideration by the committee. If recent bankruptcy = YES OR Recent denial = YES If there is a social security number AND credit 1>350 AND credit 2>350 AND credit3 >350 AND credit score average >350 and Income 1 >0 and Debt 1> 0 IF (Credit Score 1- Credit Score Average) >10 is TRUE then "BAD"; if FALSE then "OK" IF (Credit Score 2- Credit Score Average) >10 is TRUE then "BAD"; if FALSE then "OK" IF (Credit Score 3- Credit Score Average) >10 is TRUE then "BAD"; if FALSE then "OK" If Complete Applicant = TRUE AND Issues in Recent Activity = FALSE and all of the Credit Checks are "OK" A B 0 P 1 First Name Last Name 2 Ram Aring 3 Charles Bartlett 4 Tina Baumann 5 Samrat Beard 6 Brian Brannen 7 Kevin Butterworth 8 Todd Cameron 9 Deanna cline 10 Laura Davis 11 Sourav Dicken 12 Rabonne Doyle 13 Croix Dunn 14 Alfred Garber 15 Joseph Harrison 16 Jacob Hill 17 Timika Hom 18 Brian Humphrey | 19 Kyra Janus 20 Catrice Kenny 21 Jaline Lopez 22 Charles Moore 23 Kelley Nicholson 24 Kevin Okoli 25 Benjamin O'Neill 26 Mariana Roberts 27 Kenneth Santos 28 Andrew Stanley 29 Emily Valeus 30 Tom Werner 31 Priscilla Werner 32 Keith Wright 33 Johnny Wynter 34 C D E F G H J K SSN Credit Score 1 Credit Score 2 Credit Score 3 Credit Score Average Income 1 Income 2 Debt 1 Debt 2 4.11E+09 799 793 804 799 $72,441.00 $8,653.00 $76,713.00 $10,357.00 1.89E+09 786 777 796 786 $30,391.00 $0.00 $72,177.00 $6,233.00 3.22E+09 623 618 622 621 $51,465.00 $0.00 $60,954.00 $7,751.00 1.11E+09 661 651 670 661 $57,483.00 $0.00 $69,784.00 $6,124.00 4.4E+09 359 364 368 364 $32,968.00 $6,468.00 $55,384.00 $8,188.00 5.02 E+09 543 534 553 543 $40,595.00 $0.00 $52,340.00 $7,451.00 2.97E+09 552 557 555 555 $61,145.00 $8,441.00 $83,383.00 $10,914.00 1.02 E+09 648 652 659 653 $ 74,024.00 $3,535.00 $85,464.00 $8,074.00 8.07E+09 721 713 727 720 $54,224.00 $0.00 $ 84,474.00 $8,510.00 7.37E+09 837 835 837 836 $37,400.00 $7,866.00 $52,900.00 $0.00 4.34E+09 626 623 634 628 $41,146.00 $0.00 $67,292.00 $6,587.00 7.07E+09 337 341 336 338 $46,209.00 $8,353.00 $ 65,045.00 $6,064.00 2.92E+09 634 626 631 630 $28,480.00 $3,410.00 $71,641.00 $7,026.00 3.5E+09 493 483 490 489 $49,987.00 $7,603.00 $60,684.00 $7,250.00 6.44E+09 335 336 342 338 $57,692.00 $0.00 $56,729.00 $6,976.00 3 E+09 778 775 776 776 $37,823.00 $0.00 $72,756.00 $0.00 346 337 341 341 $56,884.00 $9,892.00 $74,717.00 $0.00 5.99E+09 692 680 702 691 $56,287.00 $3,522.00 $71,422.00 $6,292.00 6.45E+09 657 657 664 659 $68,768.00 $9,238.00 $92,108.00 $10,523.00 7.43E+09 787 786 795 789 $ 55,617.00 $0.00 $54,921.00 $6,859.00 2.94E+09 774 773 784 777 $26,830.00 $0.00 $54,683.00 $5,045.00 5.16E+09 563 556 574 564 $43,770.00 $7,257.00 $69,994.00 $8,195.00 4.55E+09 723 725 722 723 $29,382.00 $0.00 $ 70,826.00 $5,404.00 9.1 E+08 736 724 740 733 $46,044.00 $0.00 $61,768.00 $0.00 5.46E+09 438 436 435 436 $36,736.00 $9,445.00 $76,469.00 $11,740.00 2.53E+09 556 547 552 552 $44,236.00 $3,082.00 $72,666.00 $6,283.00 4.8E+09 567 561 570 566 $41,882.00 $0.00 $64,593.00 $5,130.00 1.44E+09 476 464 483 474 $56,392.00 $4,038.00 $72,431.00 $0.00 8.18E+09 424 421 432 426 $74,397.00 $0.00 $93,433.00 $10,836.00 4.24E+09 805 805 804 805 $53,951.00 $9,712.00 $75,791.00 $10,712.00 7.5 E+09 721 717 716 718 $68,246.00 $7,747.00 ### $11,536.00 5.11E+09 503 502 499 501 $47,959.00 $4,549.00 $64,771.00 $5,571.00 L M M N Recent bankruptcy Redent denial Income/Payment Ratio NO Yes 0.32 NO No 0.62 NO No 0.34 NO No 0.35 NO No 0.48 NO No 0.36 NO No 0.41 YES No 0.36 NO No 0.47 NO No 0.41 NO No 0.44 NO No 0.39 NO No 0.74 NO No 0.35 NO No 0.28 NO No 0.49 NO No 0.36 NO No 0.39 NO No 0.39 NO No 0.31 NO No 0.49 NO No 0.46 NO No 0.58 NO No 0.40 NO No 0.57 NO No 0.50 NO No 0.46 NO No 0.39 YES No 0.40 NO No 0.41 No NO NO 0.46 0.40 No 35 A B C D E F G H K M N 0 P Q 1 First Name Last Name Complete Applicant Issue in Recent Activity Credit Score 1 Check Credit Score 2 Check Credit Score 3 Check Preapproval TRUE YES OK OK OK FALSE 2 Ram Aring Help Tommy by completing the following. 3 Charles Bartlett TRUE NO OK OK OK TRUE 4. Tina Baumann TRUE NO OK OK OK TRUE 5 Samrat Beard TRUE NO OK OK OK TRUE 1. Use the AND function can help determine if the application is complete. NOTE: Sometimes when you are selecting data from different pages, the spreadsheet will also insert the dollar signs to help make cell references absolute. You will need to manually removed these if it does insert them. Brannen TRUE NO OK OK OK TRUE 6 Brian 7 Kevin Butterworth TRUE NO OK OK OK TRUE 8 Todd TRUE NO OK OK OK TRUE 2. Use the OR can determine if someone has either filed for bankruptcy or been denied a loan. TRUE YES OK OK OK FALSE 9 Deanna 10 Laura Cameron cline Davis Dicken Doyle TRUE NO OK OK OK TRUE 11 Sourav TRUE NO OK OK OK TRUE 3. Use IF function to determine if there are any issues with the consistency of the credit score. Check to see if any of the scores are 10 points higher than that individual's average. NO OK OK OK TRUE 12 Rabonne 13 Croix 14 Alfred TRUE FALSE Dunn NO OK OK OK TRUE TRUE Garber TRUE NO OK OK OK 4. Use the AND function to determine if an applicant has met the requirements to be preapproved for final consideration by the committee. Harrison TRUE NO OK OK OK TRUE 15 loseph 16 lacob Hill FALSE NO OK OK OK TRUE 17 Timika Horn TRUE NO OK OK OK TRUE TRUE Humphrey FALSE NO OK OK OK 18 Brian 19 Kyra NOTE: In general when you are entering text into an "IF" statement you have to surround it with quotes. However, there are times when, if the text in the cell you are pointing to is the result of a logical function, that the quotes are not necessary. This will be different based on the version of your spreadsheet you are using. However, the final IF statement will work. You just may have to give it a few attemps to find the correct combination. Janus TRUE NO OK OK FALSE BAD OK 20 Catrice TRUE NO OK OK TRUE TRUE NO OK OK OK TRUE 21 laline 22 Charles 23 Kelley TRUE NO OK OK OK TRUE Kenny Lopez Moore Nicholson Okoli O'Neill NO OK OK OK TRUE TRUE TRUE 24 Kevin NO OK OK OK TRUE TRUE NO OK OK OK TRUE Roberts TRUE NO OK OK OK TRUE TRUE NO OK OK OK TRUE Santos Stanley Valeus TRUE NO OK OK OK 25 Benjamin 26 Mariana 27 Kenneth 28 Andrew 29 Emily 30 Tom 31 Priscilla 32 Keith TRUE TRUE NO OK OK OK TRUE Werner TRUE YES OK OK OK FALSE Werner NO OK OK OK TRUE TRUE TRUE NO OK OK OK TRUE Wright Wynter TRUE NO OK OK OK TRUE 33 lohnny 34 35 CH 7 Spreadsheet Activity--Additional Instructions From the Tommy's Applicant Sheet A B D E F G H 1 J K M Recent denial Income 1 Income 2 Debt 1 Debt 2 First Name Last Name SSN Credit Score 1 Credit Credit Score Score 3 2 L Recent bankruptcy Credit Score Average N Income/Payment Ratio D H Preapproval +From Tommy's Helpful Data Sheet B C First Last Complete Applicant Name Name Use the AND function can help determine if the application is complete. NOTE: Sometimes when you are selecting data from different pages, the spreadsheet will also insert the dollar signs to help make cell references absolute. You will need to manually removed these if it does insert them. E F G Credit Score 1 Credit Score 2 Credit Score 3 Check Check Check Use IF function to determine if there are any issues with the consistency of the credit score. Check to see if any of the scores are 10 points higher than that individual's average. Issue in Recent Activity Use the OR can determine if someone has either filed for bankruptcy or been denied a loan. NOTE: In general when you are entering text into an "IF" statement you have to surround it with quotes. However, there are times when, if the text in the cell you are pointing to is the result of a logical function, that the quotes are not necessary. This will be different based on the version of your spreadsheet you are using. However, the final IF statement will work. You just may have to give it a few attempts to find the correct combination. Use the AND function to determine if an applicant has met the requirements to be preapproved for final consideration by the committee. If recent bankruptcy = YES OR Recent denial = YES If there is a social security number AND credit 1>350 AND credit 2>350 AND credit3 >350 AND credit score average >350 and Income 1 >0 and Debt 1> 0 IF (Credit Score 1- Credit Score Average) >10 is TRUE then "BAD"; if FALSE then "OK" IF (Credit Score 2- Credit Score Average) >10 is TRUE then "BAD"; if FALSE then "OK" IF (Credit Score 3- Credit Score Average) >10 is TRUE then "BAD"; if FALSE then "OK" If Complete Applicant = TRUE AND Issues in Recent Activity = FALSE and all of the Credit Checks are "OK