[WIP] Vehicle spreadsheet/CSV Generator

Discuss, get help with, or post new modifications, graphics or related tools for Locomotion in this forum.

Moderator: Locomotion Moderators

Post Reply
scrat
Chief Executive
Chief Executive
Posts: 713
Joined: 04 Oct 2004 10:20
Location: Rotterdam, The Netherlands

[WIP] Vehicle spreadsheet/CSV Generator

Post by scrat »

I'm fiddling with a tool that generates a CSV file containing vehicle data. Attached is a spreadsheet of what I've done sofar. I'll add some more columns and will then release it if there is a demand for it.
Attachments
vehicles.xls
Excel sheet
(43.5 KiB) Downloaded 309 times
So long and thanks for all the fish.
User avatar
PurdueGuy
Transport Coordinator
Transport Coordinator
Posts: 318
Joined: 27 Sep 2004 03:31
Location: West Lafayette, Indiana

Post by PurdueGuy »

Is this all default stock, or have you included any mod stock?
scrat
Chief Executive
Chief Executive
Posts: 713
Joined: 04 Oct 2004 10:20
Location: Rotterdam, The Netherlands

Post by scrat »

That one was only the default stock. The one attached to this post includes every mod (PikkaBird's mods amongst others) on my machine (including some unreleased NL stuff, which I'm still tweaking). I've also added some extra fields.

The reason I'm doing this is that I'm trying to find out how vehicle costs are calulated, cause the NL set is too expensive at the moment.
Attachments
vehicles.xls
Vehicles sheet including mods
(126 KiB) Downloaded 245 times
So long and thanks for all the fish.
scrat
Chief Executive
Chief Executive
Posts: 713
Joined: 04 Oct 2004 10:20
Location: Rotterdam, The Netherlands

Post by scrat »

Just to give an idea of how useful this sheet is, see the attachment.
Attachments
sheet.png
screenshot of spreadsheet. the yellow background of a cell indicates where i have to change xml code.
(114.28 KiB) Downloaded 158 times
So long and thanks for all the fish.
User avatar
PurdueGuy
Transport Coordinator
Transport Coordinator
Posts: 318
Joined: 27 Sep 2004 03:31
Location: West Lafayette, Indiana

Post by PurdueGuy »

It's not very clear what you're doing on the sheet in that pic. I'm assuming it's sorting or highlighting for some purpose, but it's not clear what.

Thanks for the sheet, though. I was starting to make something simmilar, but was dreading taking the time to do it.
scrat
Chief Executive
Chief Executive
Posts: 713
Joined: 04 Oct 2004 10:20
Location: Rotterdam, The Netherlands

Post by scrat »

PurdueGuy wrote:It's not very clear what you're doing on the sheet in that pic. I'm assuming it's sorting or highlighting for some purpose, but it's not clear what.

Thanks for the sheet, though. I was starting to make something simmilar, but was dreading taking the time to do it.
Oh, I was updating vehicle costs and vehicle running costs. The NL vehicles were way too expensive compared with similar orginal models.
As for the sheet generator: Better living through automation. :)

Let me know if you require extra fields. It's quite easy for me to code this.
So long and thanks for all the fish.
User avatar
PurdueGuy
Transport Coordinator
Transport Coordinator
Posts: 318
Joined: 27 Sep 2004 03:31
Location: West Lafayette, Indiana

Post by PurdueGuy »

Do these fields line up exactly with the code that is used for the stock in Lomo, or do you have extra fields or obscure fields left out? If this lines up with Lomo object code directly, I'm sure that would help in creating mods quite a bit. Thanks for the sheet!
scrat
Chief Executive
Chief Executive
Posts: 713
Joined: 04 Oct 2004 10:20
Location: Rotterdam, The Netherlands

Post by scrat »

The data in the sheets is straight from the .dats, so I guess the answer is "yes". I'm toying with the idea of extracting some spacing and bogey information as well, to aid me in finding troublespots and to compare with existing models.
So long and thanks for all the fish.
Post Reply

Return to “Locomotion Graphics, Modifications & Tools”

Who is online

Users browsing this forum: Amazon [Bot] and 24 guests