...and that's the difficulty, because the raw data is a record of when each basket is scored - that's the first stage. The second stage is to calculate how many of those where within the time limits (0 to 3 minutes and 37 to 40 minutes). The third stage is to sort the data to show the top 3 players in those categories. You should of course discuss this with your Dad.
The other things to consider are - who is going to view the information, and how will they access it, and on what platform (Windows/Linux/macOS on a Desktop Computer or Android/Apple iOS on a phone/Tablet). If a lot of people will view the information, it would be easiest to display it on a website, which can be viewed with any device.
One thing that does require code fixing is the time recorder!
I will show the tables on the institute's computer, which is windows, since that is where I make the presentation.
Once we correct the time I think it will be, what happens is that if in excel it is possible that it is not possible, I in app inventor do not know
Here is RB_Virtual4 - similar to RB_Virtual3 but the Table is sorted:
RB_Virtual4.aia (154.7 KB)
Concerning the presentation on the Institute's Windows PC, I would define the Tables as HTML web pages and display them in the Browser. Just as the App can export CSV files, it can export HTML files.
The App is currently exporting files to the phone's Documents folder. How are you transferring them to your PC? Via a USB Cable?
I can write the code for one statistic set, say the top 3 players on baskets scored in first 10 minutes, and you can use that as a guide to making the other statistics sets.
I am uploading them to the drive and from there I download them to excel (microsoft) because there are more options
Hi Carles
Just to let you know I haven't forgotten you. Busy with lots of things this week.
I'm making RB_Virtual5 for you to work with:
- I have added in-line comments everywhere to explain the processes.
- I have streamlined the statistics data extraction a little bit, since there will be a lot more data extraction once you finish the App.
- Since the App can output an html table file, I have removed the Table Extension and now the code simply displays the html table.
- Rather than having all the tables displayed, there can be a pick list to select a table - e.g. TLSI First 10 minutes, TLSI Last 10 minutes etc
- All the HTML Tables are saved to /Documents for transfer to a PC. I am doing the transfer here by simply emailing them from my phone. If you are going to perform a live demonstration of the App, you would probably want to send the files to the Cloud - Google Drive for example.
- I have changed the Chronometer to tick every 1 second. The App displays hours, minutes, seconds. The Players action times are recorded in milliseconds as they are easy to compare.
- Procedures have been changed so that they can be used for different but similar data sets - e.g. converting data to html table, table sort.
This is much more than I could have imagined when making the app.
Likewise, from html can it be passed to excel? To go up and update it, since my father knows how to do the time interval thing.
As always, very grateful.
It can't, but the App also saves CSV files for Excel 
Thats awesome Chris, it will be a very good app.
1 Like
...got some niggles, introduced by the updated Companion I think. I will try to fix them tonight.
Don't worry Chris, thank you very much.
Hi Chris, how are you doing? Is there something I can help you with?
Hi Carles
I have re-arranged how the data is stored/retrieved - the bug I hit before was from one stray line of my code, using the 'old' timer solution. 
There is one more bug that is similarly difficult to track but I'll get there.
There is something you can do, yes. Currently, the CSV and HTML tables are saved in the Android Shared folder 'Documents'. If you are going to demonstrate the App live, passing the data to a PC, then you need code that will make the transfer look professional - all I do at the moment, via the phone, is to email the files to myself.
Take a look at Google Drive - that's easy to access from a PC, you just need App code that can send the files to Google Drive. I think it may be that the files will need to be initially saved in the 'ASD' directory (App Specific Directory) instead of 'Documents'.
It's possible for you to write a test App that sends files to Google Drive and later integrate the code into the main App. Search the Forum for 'Google Drive'.
In the presentation I will first show the app interface and then I will show the tables in excel (Google sheet).
What I have done with the previous files that were saved in "Documents" was to upload them to my Drive, I don't know if that is what you mean.
Yes, I mean that
The CSV tables can actually be shown in Excel on the phone too, but the best presentation is the HTML
So if the HTML tables appear in the app, if I show the app it would be much better, right?
I think so - but you can also show them on a PC too - it's good to show flexibility because you need a big screen to show a wide audience.
Yes, I'll connect my PC to the projector to show it in a big screen.
Anything you need I am here.
As always thankful.
Change the extension from .txt to .html, put the file anywhere on your PC and double-click it to load into the browser.
SEASON_SQUAD_STATS_09_07_2022.txt (2.6 KB)