@rfvieira , Here is my current XLSForm file: Farm_Observations.xlsx (163.2 KB)
Big picture
The survey form is used to manage farm tasks/events and tree observations designed for use by monolingual manual laborers, as well as French/English speaking/reading managers. See bottom for more details.
Specifics of CSV
The vast majority of surveys are done using a Tree ID number to make an observation, measurement, etc.
The CSV in particular is a list of all the trees that have ID numbers. When making an observation, enumerator either scans a barcode or manually enters the ID. The ID is used to pulldata for several different properties of the tree/plant, which determines some different questions later. Most of these pulldata calculations can be found in rows 28-57.
Details about Overall Survey/Project
The file/survey has become much larger than what I originally intended and thats mostly because ODK Collect is so AWESOME! It has become a game changer in a very positive way because it has allowed someone who is monolingual in a minority language and illiterate (but can read numbers decently) be able to collect consistent, detailed, and organized observations that previously were all just highly disorganized WhatsApp voice messages/pictures. We originally had about 300 grafted cashew trees and were taking detailed measurements/observations to confirm characteristics to verify the claims made about each variety. A couple years later, we added over 100 species with over 400 unique varieties of other fruit trees/plants, many of which don't have names in French and the English names are often stolen from Spanish/Portuguese. This is the first "big" project/survey file that I've created/used and at the moment it is primary used by myself and another monolingual, illiterate laborer. If there are comments/constructive criticisms about survey/form design that would help, feel free to PM me. Would love the feedback!