I seem to have an error in the one or more calculations, and I am unsure as to how to fix it, I believe the error is in either scoring the age of each household member (if they are 5 and under, or 65 and older) or in calculating the cummulative disabilities for each household member. Otherwise stated if household member A has 1 disability and the are aged 69 a score of 2 should be returned. If household member B is under 5 and has 2 disabilities a score of 3 should be returned for that individual. From these two members of the household, 5 points should be added to Tier 1 score. I am asking assistance to check all calculations as, I am confident that there is an error in one of the calculations. I have also attached the matrix so you can see how the points should be allotted.Scoringmiscalculation.xlsx (28.0 KB)
Also how do I upload the xls file to the current project and not lose the data in form builder, and without creating a new project. I have tried to import previously(maybe incorrectly) and have lost information on the xls, or is unable to see the inputs in form builder.