Let me download and install Libre and see what I can do
Tool to create tables in config file
- Thread starter CobraLAD
- Start date
@JAGG yes I just tested it on 2007
ianwoodmore
Active member
It's quite a while since I used Excel actively but reading through the posts I noted several comments on sorting.
To sort a kuid in order you need to split the kuid into separate columns for each part.
eg kuid author id asset number and asset extension.
You can then use Excel's built in function and sort by single or multiple columns.
You can use the first block of lines for your stats ie. Grand total in each column, Total selected, % selected, et al.
The next block is your headers. This also has the sort button by column.
Sorting can be done by colour, or text or both. The most useful sort is the one "contains".
So, if you have an asset <kuid2:1234:5678:1>, and many more in your first column, and then you use 'contains 1234' then it will select all lines with kuids belonging to that author. This avoids the manual manipulation to get rid of <>.
The stats then show how many assets that author has.
Some additional sort functionality could be applied to show the age of an asset and/or which trainz build it is part of. (TRS12, TANE, TS19, TS22 and the next.)
Other sorts could be by age (this year, previous year, older than 5 years, ancient.
Another attribute could be "when was the last time the author updated any or all of their assets."
An important piece of information is the authors License, particularly if they state it's free to clone, or upload to DLS. If not you ask authors permission, or if no license then International copyright pertains. Bear in mind the special rules that are imposed by assets housed on the DLS. This gets further complicated by Builtin, and packaged assets housed on the DLC
Trainz Content Manager and its in-game equivalent in conjunction with custom filters can provide a lot of info.
Your Excel macro would be very useful for both authors and repairers, but please realise the size of the task. Creeping excellence can be a killer. Here are some stats to illustrate based on my experience with building TARDIS. Each time I think I have covered all the bases, someone moves the goalposts.
as @ 23 MAR 24 applicable to my installation
TAD (total assets in database) 700,624
Installed on my machine 493,841 (almost the complete DLS less OBS-DLS)
Number of assets I still have to test in TARDIS 52,170 (Currently takes between 3 secs and 20 secs per asset to automatically scan and correct). Manually I can do 100/day. Using TARDIS I often exceed 3,000. Best 24 hours was 15,000.
CRAP 1570 ( # unfixable by me incl Speedtreez Mk 5, Polygon issues, Missing dependants and dependencies, Need LOD, and so it goes on.
BI ( builtin Trainz plus) 4,808
Packaged 62,800 includes Payware.
OBS-DLS (Obsolete on DLS) 202,343
Obsolete Packaged 2,702 includes Payware.
I first started on TARDIS in 2006. Just a few experienced Trainzers have helped over the years, but sadly they faded away, When will TARDIS be finished? I'm 88yrs old and past my Use by Date.
Hope this ramble gives you food for thought. Best of luck.
Ian in New Zealand
To sort a kuid in order you need to split the kuid into separate columns for each part.
eg kuid author id asset number and asset extension.
You can then use Excel's built in function and sort by single or multiple columns.
You can use the first block of lines for your stats ie. Grand total in each column, Total selected, % selected, et al.
The next block is your headers. This also has the sort button by column.
Sorting can be done by colour, or text or both. The most useful sort is the one "contains".
So, if you have an asset <kuid2:1234:5678:1>, and many more in your first column, and then you use 'contains 1234' then it will select all lines with kuids belonging to that author. This avoids the manual manipulation to get rid of <>.
The stats then show how many assets that author has.
Some additional sort functionality could be applied to show the age of an asset and/or which trainz build it is part of. (TRS12, TANE, TS19, TS22 and the next.)
Other sorts could be by age (this year, previous year, older than 5 years, ancient.
Another attribute could be "when was the last time the author updated any or all of their assets."
An important piece of information is the authors License, particularly if they state it's free to clone, or upload to DLS. If not you ask authors permission, or if no license then International copyright pertains. Bear in mind the special rules that are imposed by assets housed on the DLS. This gets further complicated by Builtin, and packaged assets housed on the DLC
Trainz Content Manager and its in-game equivalent in conjunction with custom filters can provide a lot of info.
Your Excel macro would be very useful for both authors and repairers, but please realise the size of the task. Creeping excellence can be a killer. Here are some stats to illustrate based on my experience with building TARDIS. Each time I think I have covered all the bases, someone moves the goalposts.
as @ 23 MAR 24 applicable to my installation
TAD (total assets in database) 700,624
Installed on my machine 493,841 (almost the complete DLS less OBS-DLS)
Number of assets I still have to test in TARDIS 52,170 (Currently takes between 3 secs and 20 secs per asset to automatically scan and correct). Manually I can do 100/day. Using TARDIS I often exceed 3,000. Best 24 hours was 15,000.
CRAP 1570 ( # unfixable by me incl Speedtreez Mk 5, Polygon issues, Missing dependants and dependencies, Need LOD, and so it goes on.
BI ( builtin Trainz plus) 4,808
Packaged 62,800 includes Payware.
OBS-DLS (Obsolete on DLS) 202,343
Obsolete Packaged 2,702 includes Payware.
I first started on TARDIS in 2006. Just a few experienced Trainzers have helped over the years, but sadly they faded away, When will TARDIS be finished? I'm 88yrs old and past my Use by Date.
Hope this ramble gives you food for thought. Best of luck.
Ian in New Zealand
Last edited:
Sorry for late reply, I have been busy on another project (related to TrainzThank you Leendert!
That's service
!
Cheers,
Philippe
) I had a look, there is a few differences in the language. At this stage I am not going to do it. If someone who is more familiar with Libre, wants to fix the errors, you are welcome to do it.Good day
New update on my tool
1. Added an option to not always insert a column. My lists just require a split into 2 columns without inserting additional columns (Be careful, this will replace any info in the second column)
2. I split 'kuid-table' to its own option and added a spin button to increase the start number. For example, if you have a kuid list without the commodities and the next number is 4, you can modify the commodity list to start at 4
Download here
tool_cobralad_v3.1
Bonus tip: If you know Excel Add-Ins, you can save the tool as an add-in.
New update on my tool
1. Added an option to not always insert a column. My lists just require a split into 2 columns without inserting additional columns (Be careful, this will replace any info in the second column)
2. I split 'kuid-table' to its own option and added a spin button to increase the start number. For example, if you have a kuid list without the commodities and the next number is 4, you can modify the commodity list to start at 4
Download here
tool_cobralad_v3.1
Bonus tip: If you know Excel Add-Ins, you can save the tool as an add-in.
Last edited: