We both used webqueries Taca, but with a different approach.
Yours was more clearly organised, with a distinct tab for each username, which was also your key in the formulas
Mine was more compact although less readable, with no .iqy file saved, all queries import zones saved in the same tab, every 50th row (plenty room with 38 gw), and with the FPL ID embedded in the query name and in the zone name
I could the use parametric reference formulas, by inserting the idividual IDs (and NOT usernames) in the indirect zone names used in the lookup and index formulas
The amazing point, is that queries are required to import data from multiple sources with updating data , which URL is constant.
If I have all the needed data in one single source, I don't need automated queries any more: I'll just "import" the data from there with one single manual copypaste every gw.
Of course I'll have to revamp the way I permanently store only the sidegame relevant data, and rearrange accordingly all the formulas in my division tables
Your problem, is that even abandoning the individual player iqy approach, you still have the problem of over 30 5AS leagues to draw from, and that's too much to do without queries
Not mentioning that the Cup has a furtherly different structure not linked to a single league
I figure you'll be forced to redesign your whole formula structure anyway
I'm just going from memory, and I'll be on mobile till the 22nd, I'll be happy to share some more punctual suggestion THEN, not earlier
The main goals should be
- to have a FISO username - FPL ID global reference DB, at least for all members involved in at least one side
- to have a rmt data page which does NOT draw the individual rows FPL ID from a league members, but from the above IDs list, so as to have a unique repository dedicated to ALL the fiso sidegames and not just a specific league
- or at least, to do the league data page not for a league, but for a shortlist of selected ID that we'd communicate to Mav and that he'd keep in a simple hidden page to only be used as input for the tool he already set on
We can't hope to replicate our last season solution and tools, they'll have to be revamped anyway
Finally, the Fencing Men Sword Team semi is about to start, so you'll have yo excuse me...