Sorry Albert but I’m obviously being rather dense! What tracks list do you want displayed where? I might better understand if you screenshot the parts and paste them together how you want them. I’m sure we can find a solution.
Man!! This is like working with a database. I'm gonna love this array thing!!.
Okok, calm down Albert.
So, lemme explain you. I took all the data of My Garage page, then with a little help of Excel and Word to change slashes, commas, dots, or whatever, and then a bit of Concatenate function to create the strings, I generated a big array database.
Now I only need to put the name of the car and the template searches the info required on each cell.
Interesting. I’m sure I looked at this a couple years ago but couldn’t think of a use for it and then, as I usually do, forgot all about it! Could be useful for an interactive page where, for example, the user selects a car from a drop-down to get various details for it. Have to run some tests ... if I remember!
Hi, I'm trying to edit the Fullcars template to include M$ for the new F1 cars. I have H/Fullcars and T/Fullcars edited with the M$ column looking like it should, but I can't work out how to add it to the R/Fullcars template. I've added the code for a 13th variable, which should appear in a new column, but it's not appearing when I preview or publish the edit.
On another note, might it be better to just consolidate all the currencies into one column to bring the size down a bit? (The Cars (Fully Upgraded) page does now have a horizontal scroll bar)
It’s all good and we appreciate the help. If you look at my test page above (please don’t edit it!) (and the linked pages) you’ll see that the page and templates are all in my user area. We (should!) all work in the same way i.e. develop stuff in our user area and then move it live if it works ok and is approved. All input is welcome. Feel free to message any of us if you have questions or suggestions. Powerup777(Wall) • RR3-AG(Wall) • QuickNick(Wall) • SlatBH(Wall) • SirDuck74(Wall)
Not too pressing or important but I've hunted the pages to see if theres a thread or a place to share(flex) custom vinyl art and recreations in RR3? If not where would be a good place to do so (like a discord or smthin)
Hi Nick, By chance I found on the past sales page how to make the filterable and sortable classes work well together in a wikitable. Just adding scope="col" in the headers to specify that the cell is a header for a column. D'oh!, so simple!
Well, ok. But after taking a look to the page I saw that many of the headers and contents are a bit "unformatted". I know that page is not a very important page, but before doing any kind of changes I wanted to let you know it due to two main reasons:
Obvious. It's admin's stuff.
I know you update the page's content with Power Query, so it may happen that all changes disappear during the next page update.
Thanks for dealing with the WTTT thread and leaderboard.
I used to scrape data from the Sales page but when the table format was changed to a non-standard (date) format it was no longer possible so I now keep all the Cars Sales history in my spreadsheet and build the All Cars with Number of Sales table from that. So, if you want to change any of the tables my recommendation would be to do something in your user area and then send a message to the (other) admins and see if they're ok with your changes. Have fun!
I am using your Excel/PowerQuery sheet for quite a while. You really did a good job there. Having adapted/updated a few minor things to your original spreadsheet over the last year I am now trying to include the F1 cars in the calculation and Power Query formulas. Not only because it would work more smoothly there I also think it would be more logical to prepend each F1 car with F1 similar to the manufacturers name or the formula E race series name. What do you think about that?
It's on my to-do list to update the spreadsheet for the F1 cars ... but first I have to get the main PQ spreadsheet (which I use to do all my Wiki updates) working ... and that requires a LOT of fixes/changes to the Wiki.
There are many problems with the F1 cars which will have to be addressed ...
The names haven't been entered consistently in the Wiki.
Even though I don't like cars being held under the "F1" make (like Formula E cars) that is the way the Wiki should work (as it is meant to reflect the game) and is something which is currently being addressed.
I am working on changes to the Cars list pages to address the car names, once I (and the other admins) are happy with this it will go live.
The addition of the M$ currency.
So, there is a lot to do!
If you look at my test Cars page you will see that I have moved all the F1 cars to the F1 "make" (so I agree with you) and incorporated some other changes. I intend to make similar changes to the other Cars list pages. Feedback is welcome.
If you do go ahead and make changes please let me know so (if I agree with them!) I can incorporate them into my version of the Cars spreadsheet.
I hope that has answered your question AND let you know that I've not given up on this ... yet!
Hi. Sorry, I've been rather busy recently which means the Cars spreadsheet has dropped (nearly) to the bottom of my RR3-Wiki to-do list! Why not create a page in your user area (a bit like I did) and send me a link for it. Just so you know, I'm working on revised Cars list pages which may/will affect the spreadsheet. Thanks and best wishes, Nick
1. Edit the template to make sure the list of tracks.
2. Move it to the new week every week.
I've included it in the current OMP Schedule so you can see how easy it is to use.
ALTERNATIVE: If we display it above the cars it could be included as a flag in the weekly row template or use the |Current=Y flag to output it, in that way you wouldn't need to remember to move it every week (though that's not a big deal).
I've been playing with a template to display the track and variant using the existing templates which set the track and variant based on standard names/abbreviations.
User:QuickNick/Template/TrackAndVariant You can use it as follows for the OMP Schedule Tracks table.
It's still a work-in-progress but if you go to the template page (click on the link above) you'll see that I've allowed for various options to cater for various outputs. Let me know if you have any suggestions. I'll let you know if I decide to go live with it.