Catalogue version updated to 2.11.
2.11 (02/03/2012) Main update is migration support, adding a ID for cars and paints. Also added a standard/premium/tradable/untradable column.
Finally started testing 'check' labeled chips, with the same chip icon colour.
Added new paint variations: British Racing Green Metallic(Mini, P1616a), Ultra Red Pearl(Mitsubishi, P1711a), Reflexsilber Metallic(Volkswagen, P2545a), Tornadorot(Volkswagen, P2516a), Red Mica(Toyota, P2358a), Kaiser Silver Metallic(Honda, P1027a), Galaxy White Pearl(Mitsubishi, P1688a), Rosso Alfa(Alfa Romeo, P0062a), Rosso Proteo Metallizzato(Alfa Romeo, P0107a), Millennium Yellow(Chevrolet, P0374a), Cortez Silver Metallic(Chevrolet, P0412a), White(Daihatsu, P0521a), Bright Silver Metallic(Dodge, P0582a), Moro Blue Pearl Effect(Audi, P0224a).
Removed Lamborghini's Giallo Eviros (P1183): apparently has been corrected as Giallo Evros with last update, or maybe it was wrongly spelled in the catalogue.
Car removal: C4267 Nissan SKYLINE GT-R M-spec (R34) '01 Black Pearl, C4275 Nissan SKYLINE GT-R M.spec Nur (R34) '01 Black Pearl, C4316 Nissan SKYLINE GT-R V•spec (R34) '99 Black Pearl (first two found by CostasDrifter!).
New car added, pulled by ch1potle from a ticket: Honda NSX '95 in Grand Prix White (C1845a)
New collectable cars: Toyota ARISTO V300 Vertex Edition '00 in Silver Metallic, Audi RS 6 Avant '02 in Ebony Black Pearl Effect are scrooge cars that don't gift their chips (thanks to segovia). Also added the Opel Tigra 1.6i '99 in Zypressengrun which was well known but forgot to add to the ownership list (thanks to segovia too for bug retrieval)
As requested, I wrote a migration procedure for both google doc and ods sheets. Minimum supported catalogue to be able to migrate is 2.08. Migration will waste less than 5 minutes. New users don't need migration sheets. Old users that want to migrate their old version to the last one should open their catalogue, migration sheet and a copy of 2.11 barely new release.
Links:
GT5 Car Catalogue 2.11 - Google Doc format
GT5 Car Catalogue 2.11 - HTML preview
GT5 Car Catalogue 2.11 - Open Document Format (Openoffice/Libreoffice): see attachments
GT5 Collectable Cars stand alone list 2.11 - Google Doc format
Google doc migration sheet
ODS migration sheet: see attachments
Google doc migration process
1) Copy your first car variations account cells (from K4 to K5811)
2) Paste into cell K4 of this sheet (data will pasted from cell K4 to K5811).
3) Repeat steps 2 and 3 for your other accounts (L4-L5811, M4-M5811).
4) Copy your chips database account cells (from D3 to F2579). You will be able to do it in one time even using google docs.
5) Paste into cell D3 of this sheet (data will be pasted from cell D3 to F2579)
6) In car variations tab, click on a column Q cell of your choice, in Data menu select 'sort sheet by column Q, A to Z'
7) In chips database tab, click on a column N cell of your choice, in Data menu select 'sort sheet by column N, A to Z'
8) Now delete the cars with the following ID from the 'Car variations' tab. Right click with mouse on the row number and use 'Delete row'. Please note that ID is different than row number.
C4267: Nissan SKYLINE GT-R M-spec (R34) '01 Black Pearl
C4275: Nissan SKYLINE GT-R M.spec Nur (R34) '01 Black Pearl
C4316: Nissan SKYLINE GT-R V•spec (R34) '99 Black Pearl
9) Do the same for this paint in 'Chips database'
P1183: Giallo Eviros
Go to the bottom rows of each tab and fill up needed account data for new cars and chips.
You now have a fully sorted database for cars and paints. In order to complete migration, you should open the 2.11 version of the catalogue and copy your data from this sheet.
1) Make a backup of your catalogue (not mandatory but strongly suggested).
2) Copy from here your first car variations account cells (from K4 to K5809)
3) Paste into cell K4 of your new 2.11 sheet (data will pasted from cell K4 to K5809).
4) Repeat steps 2 and 3 for your other accounts (L4-L5809, M4-M5809).
5) Copy from here chips database account cells (from D3 to F2579). You will be able to do it in one time even using google docs.
6) Paste into cell D3 of your new 2.11 sheet (data will be pasted from cell D3 to F2579)
This is a transition sheet between 2.08 or 2.09 or 2.10 version of the catalogue TO version 2.11. In order to migrate to latest release please follow step by step following instructions
Openoffice/Libreoffice migration
1) Copy all of your car variations account cells (from K4 to M5811)
2) Paste into cell K4 of this sheet (data will pasted from cell K4 to M5811).
3) Copy your chips database account cells (from D3 to F2579).
4) Paste into cell D3 of this sheet (data will be pasted from cell D3 to F2579)
5) In car variations tab, select all (CTRL-A), deselect topmost fixed rows, in Data menu select 'sort', then sort with column Q
6) In car variations tab, select all (CTRL-A), deselect topmost fixed rows, in Data menu select 'sort', then sort with column N
7) Now delete the cars with the following ID from the 'Car variations' tab. Right click with mouse on the row number and use 'Delete row'. Please note that ID is different than row number.
C4267: Nissan SKYLINE GT-R M-spec (R34) '01 Black Pearl
C4275: Nissan SKYLINE GT-R M.spec Nur (R34) '01 Black Pearl
C4316: Nissan SKYLINE GT-R V•spec (R34) '99 Black Pearl
8) Do the same for this paint in 'Chips database'
P1183: Giallo Eviros
Go to the bottom rows of each tab and fill up needed account data for new cars and chips.
You now have a fully sorted database for cars and paints. In order to complete migration, you should open the 2.11 version of the catalogue and copy your data from this sheet.
1) Make a backup of your catalogue (not mandatory but strongly suggested).
2) Copy from here your car variations account cells (from K4 to M5809)
3) Paste into cell K4 of your new 2.11 sheet (data will pasted from cell K4 to M5809).
4) Copy from here chips database account cells (from D3 to F2592).
5) Paste into cell D3 of your new 2.11 sheet (data will be pasted from cell D3 to F2592).
Please make your comments and share your migration problems to build a FAQ section.
Last:
DO A BACKUP OF YOUR OLD CATALOGUE