How do I create a Poverty-Assessment Tool?

Poverty-assessment Tools in TaroWorks can be created with 10 questions with scoring built in and also a formula field that that translate the scores to the likelihood that one household is below a certain line (eg. National Poverty Line). 

The  raw score (0-100) can be mapped into object fields. Therefore it is possible get the poverty likelihood by creating an additional formula field (see below) to act as a look-up table, outputting the probability (in percent) based on the mapped score total. The result is that when a completed job with a Poverty-assessment Tool form is synced, the scores would be automatically calculated in the Salesforce record.

1. Create a Poverty Assessment Object with fields corresponding to the questions you will be using. (Note: When creating the object, set record name to Auto-number field.)
2. Create a Form with the 10 questions. These questions will be multi-select questions.
3. Do scoring of the questions using TaroWorks scoring feature.
4. Map the questions to the fields you created earlier.
5. Create a corresponding Job for the Form.
6. Create a formula field in Salesforce that will correspond to the Poverty likelihood (%) e.g. National, Poorest Half or International PPP i.e. Under $2 a day

Here is an example formula below assuming you will map the raw score to a field named "PPI Score". (The formula type should be a percentage %)

IF( PPI_Score__c < 5 , 0.954,

IF( PPI_Score__c < 10 , 0.95,

IF( PPI_Score__c < 15 , 0.858,

IF( PPI_Score__c < 20 , 0.825,

IF( PPI_Score__c < 25 , 0.773,

IF( PPI_Score__c < 30 , 0.679,

IF( PPI_Score__c < 35 , 0.637,

IF( PPI_Score__c < 40 , 0.464,

IF( PPI_Score__c < 45 , 0.369,

IF( PPI_Score__c < 50 , 0.30,

IF( PPI_Score__c < 55 , 0.178,

IF( PPI_Score__c < 60 , 0.139,

IF( PPI_Score__c < 65 , 0.061,

IF( PPI_Score__c < 70 , 0.046,

IF( PPI_Score__c < 75 , 0.038,

IF( PPI_Score__c < 80 , 0,

IF( PPI_Score__c < 85 , 0.004,

IF( PPI_Score__c < 90 , 0,

IF( PPI_Score__c < 95 , 0,0)))))))))))))))))))

 

Now when a form is submitted the  Poverty likelihood (%) will be calculated in that formula field.