Board Thread:Game Discussion/@comment-30967537-20170808114445/@comment-30967537-20170809053818

Hi Graham.

I think David is/was working on something to do with using lookup data, it seems to me that would be a better way of doing this.

However, looking at a way of doing this, I see it as two separate issues ...
 * Design
 * Data

Would you be using a tabbed layout? I think that would be nicest. Three tabs across the top of the table with the relevant information displayed for each tab ...
 * Base Stats
 * R$ Upgraded
 * Fully Upgraded

You could use Power Query to lookup and create the Wiki data for the tables e.g. have a sheet with the list of series and cars (already got it) which is referenced by a PQ script which also refers to the Cars Base Stats / R$ Upgraded / Fully Upgraded pages (again, already got the data!) to generate the templated data. That is definitely something that I could do.

Taking it one step further, those series-cars tables could become templates like the Navigation boxes on the Car pages, those are also maintained/created with PQ scripts. This would ensure consistent data. But it would need to be a regular maintenance task to ensure the templates are up-to-date. That said, I think it is a good idea to have data which you know is consistent and building (rather than users editing) the tables would ensure this.

If the Series & Special Events page Career table is the master table then a PQ script could build the Wiki templates for the series-cars tables ... but the Career table would need to be kept up-to-date ... it's not always correct! What about the other (non-Career i.e. limited/special) series?

Back to you to consider my suggestions AND to design tne tabbed table.

Nick