Dear community, I ask for your help.
I have an Excel spreadsheet where the leftmost column is age. This age determines the row in which three adjacent cells with numerical values for this age should be found and these data are taken for calculations in the formula. How can I use such tables in the AI application itself and (most importantly) how to search for neighboring cells by age parameter?
At the moment I have implemented everything using Google Sheets Document. The program sends and receives values from the cloud table (this example is taken as a basis https://docs.google.com/document/d/1dwiY1GYFGMd1pEeCl6NvGp3q3-G2hKEm_YyFRDekDDc/edit#heading=h.nfoaenbx12s), but the table does the calculations by itself using the formulas.
It works, but not convenient. Data reception and transmission is periodically disrupted, there is no way to work without the Internet, and I do not know how the table will behave with multiple requests from different users.
How do I organize my data retrieval and storage? example of my table