Page 1 of 1

[WIP] Vehicle spreadsheet/CSV Generator

Posted: 17 Nov 2004 20:05
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.

Posted: 17 Nov 2004 21:20
by PurdueGuy
Is this all default stock, or have you included any mod stock?

Posted: 17 Nov 2004 23:32
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.

Posted: 18 Nov 2004 15:12
by scrat
Just to give an idea of how useful this sheet is, see the attachment.

Posted: 18 Nov 2004 19:46
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.

Posted: 18 Nov 2004 19:54
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.

Posted: 18 Nov 2004 20:54
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!

Posted: 18 Nov 2004 21:46
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.