Nothing makes my afternoon more interesting than an 8 sheet
spreadsheet doing integral calculus in French, with almost 40 named ranges,
with numbers in the French convention (commas instead of decimal points),
annotated in French.
Let me start by summarizing what I see here.
You have a data entry sheet, where you enter elapsed time in seconds for passage of irregularly spaced marks in a race, one race per row, one time reading per cell, ascending as the racer progresses along the track. The marks are columns in your data entry sheet.
You calculate and graph various physiological reserves by time, per race.
Looking at your blocks, I see some things missing ...
- You do not use internal storage like TinyDB to hold multiple races and racers.
- You do not use the new dictionary data type to store complex information about racers and their possible multiple races, like racer name and race date/time, and maybe ambient temperature(?).
- You do not use procedure parameters and value procedures to allow reuse of your computations against different races and to simplify calculation steps by name.
- You rely too much on global variables where value procedures could be used. This kills reuse.
It's possible to do this all in blocks, without Internet access to Google Sheets, if you want. Considering races are run outside away from WiFi, this can be helpful.
Be aware that AI2 needs decimal points instead of commas for its math blocks.
See this thread for how another app was converted from Excel to blocks, albeit too slow for robot arm control but probably okay for race time analysis ... How to make a link between an excel file and AppInventor - #9 by ABG
You named ranges would be good candidates for conversion to value procedures.
Study materials ...
http://www.appinventor.org/bookChapters/chapter21.pdf
Now I must take a puissance break.