On Feb 3rd and Feb 10th, Sarthak and Sutapa met to transport data from ArcGIS Survey 123 app to an excel spreadsheet. (attached)

General Walkability study spreadsheet:

1. Data was cleaned and transposed. Each question is located on a separate row. Each column accounts for 1 survey taken by a volunteer of the study.

2. A separate sheet was designated for assigning each question with scores on a scale of 1-5.

3. Using the function index and match, formulas were introduced for each survey answer in the database.

A group meeting is scheduled in the end of February to finalize the scoring system of the map- blocks. The next step is to calculate averages for each map block and assign an average score out of 5 for each parameter.

Incomplete survey: The Map blocks 9, 10, 14, 22, 23 and 27 have no records yet. When the weather conditions improve in March 2022, another round of data collection is scheduled to be undertaken by volunteers. Details regarding their training sessions will be shared soon.