Exp22_Excel_Ch11_Cumulative - Client FICO Scores
paull222
Exp22_Excel_Ch11_Cumulative_FICO.xlsx
LookUp
| Client Summary |
|
| FICO Scores |
|
| Formula Documentation |
| Select ID and Month |
|
| 0 |
Poor |
| B5 |
| ID |
T246L |
| 580 |
Fair |
| A8 |
| Month |
September |
| 670 |
Good |
| B8 |
| FICO Score |
|
| 740 |
Very Good |
|
|
|
| 800 |
Exceptional |
| Month |
FICO |
Clients
| Old ID |
New ID |
Initial |
Last |
Last Name |
Name |
City |
State |
| Total Locations |
| 123 |
| K |
FARSI |
|
| Kansas City, MO |
|
| Client Locations |
| 246 |
| T |
LOZANO |
|
| Liberty, MO |
| 267 |
| J |
SMITH |
|
| Overland Park, KS |
| 892 |
| D |
AUCHTER |
|
| Topeka, KS |
| 615 |
| B |
ORLOV |
|
| Kansas City, MO |
| 738 |
| S |
LIANG |
|
| Kansas City, KS |
| 861 |
| V |
NOWAK |
|
| Liberty, MO |
| 984 |
| E |
WILLIAMS |
|
| Kansas City, KS |
| 240 |
| N |
ROSSI |
|
| Independence, MO |
| 188 |
| S |
GARCIA |
|
| Overland Park, KS |
| 329 |
| L |
KORHONEN |
|
| Topeka, KS |
| 690 |
| B |
KENDRICK |
|
| Kansas City, KS |
| 369 |
| J |
HANSEN |
|
| Independence, MO |
| 492 |
| J |
JENSEN |
|
| Liberty, MO |
| 503 |
| F |
MURPHY |
|
| Kansas City, MO |
| 704 |
| D |
HAIR |
|
| Topeka, KS |
| 875 |
| T |
JABAL |
|
| Kansas City, KS |
| 318 |
| E |
YILMAZ |
|
| Olathe, KS |
| 321 |
| A |
MARTIN |
|
| Kansas City, MO |
| 440 |
| A |
VALDEZ |
|
| Liberty, MO |
Scores
| Record |
ID |
January |
February |
March |
April |
May |
June |
July |
August |
September |
October |
November |
December |
| Month Filter |
December |
|
| K123F |
745 |
750 |
750 |
740 |
739 |
735 |
735 |
737 |
737 |
740 |
740 |
740 |
| Top 4 |
|
| T246L |
815 |
817 |
825 |
815 |
817 |
820 |
820 |
825 |
822 |
825 |
825 |
830 |
|
| J267S |
641 |
641 |
650 |
650 |
655 |
655 |
658 |
660 |
670 |
670 |
671 |
671 |
|
| D892A |
740 |
735 |
738 |
740 |
740 |
740 |
738 |
738 |
735 |
735 |
735 |
737 |
|
| B615O |
585 |
590 |
595 |
595 |
595 |
600 |
600 |
590 |
584 |
586 |
586 |
590 |
|
| S738L |
825 |
835 |
835 |
838 |
838 |
840 |
835 |
835 |
831 |
832 |
834 |
829 |
|
| V861N |
790 |
790 |
790 |
795 |
795 |
795 |
798 |
798 |
800 |
795 |
795 |
795 |
| Summary |
Very Good |
|
| E984W |
655 |
645 |
650 |
648 |
640 |
644 |
650 |
646 |
638 |
638 |
640 |
640 |
| Average |
|
| N240R |
700 |
690 |
695 |
685 |
680 |
683 |
683 |
685 |
685 |
700 |
704 |
704 |
| Count |
|
| S188G |
695 |
680 |
680 |
685 |
695 |
680 |
680 |
685 |
685 |
685 |
690 |
680 |
|
| L329K |
835 |
835 |
835 |
820 |
822 |
822 |
825 |
813 |
810 |
810 |
814 |
811 |
| Criteria |
|
| B690K |
795 |
790 |
790 |
785 |
775 |
775 |
778 |
778 |
780 |
785 |
790 |
790 |
| December |
December |
|
| J369H |
580 |
575 |
577 |
577 |
570 |
570 |
565 |
575 |
575 |
575 |
580 |
585 |
|
| J492J |
660 |
665 |
665 |
669 |
672 |
672 |
672 |
680 |
680 |
680 |
675 |
678 |
|
| F503M |
635 |
638 |
638 |
640 |
640 |
640 |
630 |
635 |
635 |
627 |
627 |
627 |
|
| D704H |
755 |
755 |
750 |
740 |
732 |
732 |
740 |
740 |
742 |
745 |
755 |
755 |
|
| T875J |
805 |
815 |
813 |
795 |
795 |
795 |
795 |
800 |
800 |
800 |
805 |
805 |
|
| E318Y |
732 |
735 |
732 |
735 |
735 |
740 |
740 |
735 |
735 |
742 |
742 |
745 |
|
| A321M |
665 |
670 |
670 |
672 |
672 |
670 |
675 |
675 |
675 |
680 |
680 |
695 |
|
| A440V |
767 |
765 |
765 |
760 |
760 |
772 |
772 |
772 |
765 |
765 |
779 |
785 |
