Spreadsheet: 272799d1382514459-has-income-of-homeless-improved-worsened-stayed-the-same-after-our-org-has-seen-them-clients
Sheet: Helper Column Way

 | Helper Columns for Analysis
[NAME] | Count of Client ID  with Hrs Company | Count If Client ID is Repeated(if No. is greater than 1 means Rating Can Be Given | Checking the Condition  based on Column B and C that which client is applicable for Rating | First Instance of income by HRS Formula used below is array formula, After any change instead of pressing control and enter,PLEASE HOLD CONTROL AND SHIFT THEN HIT ENTER TO MAKE IT ARRAY FORMULA ONCE IT IS ENTERED AS ARRAY YOU WILL SEE CURLY BRACES{} SURROUNDING FORMULA WHICH IS A CONFIRMATION. If you still get error then click the top cell once press F2, then HOLD CONTROL AND SHIFT together and THEN HIT ENTER. Drag formula [NAME] | Last Instance of Income Formula used below is array formula, After any change instead of pressing control and enter,PLEASE HOLD CONTROL AND SHIFT THEN HIT ENTER TO MAKE IT ARRAY FORMULA ONCE IT IS ENTERED AS ARRAY YOU WILL SEE CURLY BRACES{} SURROUNDING FORMULA WHICH IS A CONFIRMATION. If you still get error then click the top cell once press F2, then HOLD CONTROL AND SHIFT together and THEN HIT ENTER. Drag formula [NAME] | Ratings | Count of Rating
5703 |  |  |  |  |  |  |  | Improved
5704 |  |  |  |  |  |  |  | Same
5713 |  |  |  |  |  |  |  | Worse
5725 |  |  |  |  |  |  |  | Not Available
5729
5758
5774
5776
5792
5793
5801
5856
5858
5891
5894
5901
5933
5939
5940
5948
5955
5960
5970
5984
5988
5994
5995
6017
6055
6056
6106
6125
6178
6297
6306
6332
6343
6358
6378
6406
6529
6646
6686
6699
6726
6787
6828
6875
6974
7005
7010
7041
7046
7097
7108
7120
7128
7192
7220
7261
7305
7347
7350
7407
7425
7430
7479
7555
7581
7608
7614
7617
7663
7704
7709
7732
7778
7832
7856
7920
7929
8052
8072
8073
8190
8225
8231
8267
8299
8306
8312
8373
8384
8400
8476
8481
8487
8488
8499
8502
8504
8509
8609
8627
8638
8681
8693
8753
8808
8861
8878
8941
8945
8993
9019
9116
9123
9234
9276
9288
9315
9320
9352
9369
9371
9405
9419
9427
9434
9469
9470
9479
9521
9532
9536
9555
9590
9602
9657
9680
9716
9779
9836
9842
9857
9872
9890
9937
9951
9956
9972
10051
10053
10089
10092
10097
10100
10107
10126
10131
10167
10191
10197
10224
10229
10235
10260
10268
10292
10294
10301
10323
10341
10345
10354
10358
10359
10360
10397
10405
10416
10460
10480
10496
10531
10539
10556
10560
10567
10586
10590
10600
10601
10612
10628
10637
10674
10682
10700
10728
10735
10744
10749
10752
10764
10772
10790
10814
10851
10853
10857
10864
10876
10879
10882
10894
10895
10897
10911
10915
10923
10928
10943
10952
10968
10976
10980
11001
11011
11023
11026
11027
11028
11042
11059
11072
11086
11087
11091
11102
11103
11108
11135
11154
11179
11215
11216
11223
11248
11257
11259
11267
11270
11271
11275
11282
11283
11287
11296
11321
11330
11333
11334
11336
11358
11360
11363
11364
11369
11381
11534
11549
11558
11626
11732
11811
11826
11860
12630
12728
12778
13002
13003
13230
13865
13900
13904
13906
13915
13925
13938
13945
13957
13960
13974
13975
13976
14014
14028
14057
14062
14205
14283
14419
14430
14433
14435
14664
14948
14996
15046
15077
15096
15102
15170
15171
15172
15213
15215
15236
15253
15255
15452
15462
15468
15470
15471
15534
15538
15547
15554
15568
15582
15584
15596
15704
15705
15801
15809
15843
15884
15961
16009
16033
16106
16111
16155
16157
16202
16226
16231
16232
16238
16281
16320
16335
16361
16372
16403
16439
16440
16441
16446
16447
16457
16461
16462
16465
16478
16481
16558
16583
16584
16585
16612
16616
16618
16630
16633
16638
16643
16645
16698
16748
16758
16763
16767
16819
16826
16827
16875
16877
16884
16885
16886
16914
16933
16937
16945
16950
17002
17026
17027
17050
17054
17081
17089
17090
17108
17111
17112
17113
17118
17119
17120
17121
17122
17158
17172
17185
17203
17206
17225
17234
17235
17245
17252
17257
17261
17267
17274
17277
17284
17296
17315
17318
17329
17335
17341
17349
17362
17363
17367
17399
17404
17419
17438
17439
17440
17494
17515
17516
17517
17518
17519
17532
17533
17542
17549
17554
17557
17567
17598
17599
17601
17605
17607
17653
17657
17658
17661
17668
17674
17676
17708
17709
17718
17719
17721
17730
17732
17748
17749
17750
17767
17768
17769
17774
17778
17779
17780
17781
17782
17783
17801
17802
17804
17805
17809
17810
17811
17813
17814
17817
17819
17823
17829
17830
17833
17842
17844
17845
17846
17857
17860
17861
17862
17863
17864
17865
17866
17867
17868
17869
17870
17871
17872
17873
17874
17875
17876
17877
17878
17879
17880
17881
17882
17883
17884
17885
17886
17887
17888
17889
17890
17891
17892
17893
17894
17895
17896
17897
17898
17899
17900
17901
17902
17903
17904
17905
17906
17907
17908
17909
17910
17911
17912
17913
17914
17921
17922
17923
17924
17925
17926
17927
17928
17929
17930
17931
17932
17933
17934
17935
17941
17943
17950
17951
17952
17953
17954
17963
17964
17965
17966
17967
17968
17969
17970
17971
17972
17973
17974
17975
17976
17977
17978
17979
17980
17981
17982
17983
17984
17985
17986
17987
17988
17989
17990
17991
17992
17993
17994
17995
17996
17997
17998
17999
18000
18001
18002
18003
18004
18005
18006
18007
18008
18009
18010
18011
18012
18013
18014
18015
18016
18017
18018
18019
18020
18021
18022
18023
18024
18025
18026
18027
18028
18029
18030
18031
18032
18033
18034
18035
18036
18037
18038
18039
18040
18042
18043
18044
18045
18046
18047
18048
18049
18050
18051
18052
18053
18054
18055
18056
18057
18058
18059
18060
18061
18062
18063
18064
18065
18066
18067
18068
18069
18070
18071
18072
18073
18074
18075
18078
18080
18081
18082
18083
18084
18085
18086
18087
18088
18089
18090
18091
18092
18093
18094
18095
18096
18097
18098
18099
18100
18101
18102
18103
18105
18106
18107
18108
18109
18110
18111
18112
18113
18114
18115
18120
18121
18122
18123
18124
18125
18126
18127
18128
18129
18130
18131
18132
18133
18134
18135
18136
18137
18138
18144
18145
18146
18147
18148
18149
18152
18153
18154
18155
18156
18157
18158
18159
18160
18161
18162
18163
18164
18165
18166
18167
18168
18169
18170
18171
18172
18173
18174
18175
18176
18177
18178
18179
18180
18181
18182
18183
18184
18185
18186
18190
18194
18195
18196
18197
18198
18199
18200
18201
18202
18203
18204
18205
18206
18207
18208
18209
18210
18211
18212
18213
18214
18215
18216
18217
18218
18219
18223
18224
18225
18226
18227
18228
18230
18231
18232
18236
18237
18238
18239
18240
18241
18242
18243
18244
18245
18246
18248
18249
18250
18251
18252
18253
18254
18259
18260
18261
18262
18263
18264
18265
18266
18267
18268
18269
18270
18271
18272
18273
18274
18275
18276
18277
18278
18279
18280
18281
18282
18283
18284
18285
18286
18287
18288
18289
18290
18291
18292
18293
18294
18295
18296
18297
18298
18299
18300
18301
18302
18303
18304
18306
18307
18308
18309
18310
18311
18312
18313
18314
18315
18317
18318
18319
18320
18321
18322
18323
18324
18325
18326
18327
18328
18329
18330
18331
18332
18333
18334
18335
18336
18338
18339
18340
18341
18342
18343
18344
18345
18346
18347
18352
18354
18355
18356
18357
18358
18359
18360
18361
18362
18363
18364
18365
18366
18367
18368
18369
18370
18371
18372
18373
18374
18375
18377
18378
18379
18380
18381
18382
18384
18385
18386
18390
18393
18397
18398
18401
18403
18408
18410
18411
18418
18419
18427
18428
18429
18430
18431
18432
18436
18437
18438
18439
18440
18441
18442
18443
18444
18445
18446
18447
18449
18450
18451
18452
18453
18454
18455
18458
18459
18463
18465
18466
18468
18469
18473
18474
18475
18483
18529
18537
18538
18542
18544
18545
18546
18549
18550
18551
18552
18553
18554
18555
18556
18558
18559
18560
18561
18562
18564
18565
18569
18570
18572
18573
18579
18580
18581
18582
18583
18584
18586
18587
18588
18589
18591
18592
18593
18594
18598
18599
18600
18604
18605
18606
18607
18608
18609
18610
18611
18617
18618
18619
18630
18631
18632
18633
18634
18635
18636
18637
18638
18639
18640
18641
18642
18644
18645
18646
18647
18648
18649
18650
18651
18652
18653
18654
18655
18656
18657
18659
18661
18662
18663
18664
18665
18666
18667
18668
18669
18670
18671
18672
18673
18674
18675
18676
18677
18678
18679
18680
18681
18682
18686
18687
18688
18690
18691
18692
18693
18696
18700
18701
18702
18703
18704
18705
18706
18707
18708
18710
18712
18713
18714
18715
18716
18717
18718
18719
18720
18721
18722
18723
18724
18727
18730
18731
18732
18733
18734
18735
18736
18737
18738
18745
18746
18748
18749
18750
18751
18760
18763
18764
18765
18766
18767
18768
18769
18773
18774
18775
18776
18777
18778
18779
18783
18784
18785
18786
18790
18794
18795
18796
18797
18798
18799
18800
18801
18802
18803
18804
18805
18806
18807
18808
18809
18810
18811
18812
18813
18814
18815
18816
18817
18818
18819
18820
18821
18826
18829
18832
18833
18834
18835
18836
18837
18838
18839
18848
18874
18875
18876
18877
18878
18879
18880
18881
18882
18883
18894
18906
18907
18908
18914
18915
18916
18917
18918
18919
18920
18921
18922
18923
18924
18925
18926
18927
18928
18929
18930
18931
18932
18933
18934
18939
18942
18943
18944
18945
18946
18947
18948
18949
18950
18952
18953
18955
18956
18963
18964
18966
18967
18968
18969
18970
18990
18991
18992
18993
18994
18995
18996
18997
18998
18999
19000
19001
19002
19003
19004
19005
19013
19017
19018
19019
19020
19021
19022
19023
19026
19027
19032
19037
19038
19039
19040
19041
19042
19043
19044
19045
19057
19062
19063
19065
19066
19067
19068
19069
19070
19071
19076
19083
19084
19085
19086
19087
19088
19089
19090
19091
19092
19093
19094
19095
19096
19097
19098
19101
19114
19115
19117
19118
19119
19120
19121
19122
19123
19124
19125
19126
19129
19133
19134
19135
19136
19137
19138
19143
19145
19146
19147
19148
19149
19150
19151
19152
19153
19154
19155
19156
19157
19158
19160
19161
19162
19164
19165
19166
19167
19168
19169
19170
19171
19172
19174
19175
19176
19177
19178
19179
19187
19188
19189
19190
19191
19192
19193
19194
19195
19198
19199
19201
19209
19210
19211
19212
19213
19214
19215
19222
19223
19224
19225
19226
19227
19228
19229
19230
19231
19232
19233
19234
19235
19236
19237
19238
19239
19240
19241
19243
19244
19246
19247
19248
19249
19250
19251
19252
19253
19254
19255
19256
19257
19260
19261
19262
19263
19264
19265
19266
19267
19268
19269
19270
19271
19272
19273
19274
19275
19278
19279
19280
19284
19287
19288
19289
19290
19291
19292
19294
19295
19296
19298
19299
19300
19301
19302
19303
19305
19306
19307
19308
19309
19310
19311
19312
19318
19329
19330
19331
19332
19333
19334
19335
19336
19337