Re: Is This a Packard
Posted by humanpotatohybrid On 2021/8/24 20:36:05
Was thinking about making such a list in Excel before; there's almost 1400 entries there. Got around to doing it this time, after a couple of hours of Word macros, find-and-replace, Notepad CSV-ing, and custom Excel formulas, I got the data processed into an Excel spreadsheet.
There are a few errors in the sheet here and there with double-entries. For double-entries with a "year defunct" the year info should apply only to the second name in the cell, with the first one having no info on it. If anyone wants to patch these up (and maybe fix Excel's random alphabetizing errors) it would be appreciated, but I don't think anyone will be looking too closely at it; the Wikipedia page is still there for a proper reference.
Note: there is a "macro enabled" (.xlsm) and normal (.xlsx) versions. Just open the normal one unless you want to see the Excel macros I used (Excel will give you a warning if you try to open the macro one).
Attach file:
defunct car makes.zip Size: 0.00 KB; Hits: 165
There are a few errors in the sheet here and there with double-entries. For double-entries with a "year defunct" the year info should apply only to the second name in the cell, with the first one having no info on it. If anyone wants to patch these up (and maybe fix Excel's random alphabetizing errors) it would be appreciated, but I don't think anyone will be looking too closely at it; the Wikipedia page is still there for a proper reference.
Note: there is a "macro enabled" (.xlsm) and normal (.xlsx) versions. Just open the normal one unless you want to see the Excel macros I used (Excel will give you a warning if you try to open the macro one).
Attach file:
defunct car makes.zip Size: 0.00 KB; Hits: 165This Post was from: https://packardinfo.com/xoops/html/modules/newbb/viewtopic.php?post_id=236288