I hope you enjoy this new way of viewing the history of vintage Yamaha FG guitars. They are to catch any errors or if I add a new model and don’t add it to the chart. Those a “sanity” checks, calculating the same thing but in a different way. Though not a price guide, the book will enable collectors to identify the date, stock ingredients, wood, and evolution of their Fender, Martin, Gibson, Gretsch, or Mosrite axes, to name just a few. You’ll probably notice there are duplicate total numbers. In the second edition to Gruhn's Guide to Vintage Guitars, the pair have created a useful resource for any lover of fine guitars, banjos, or basses. You can see what models used each label, and how long a model was made. I tend to be a visual person, so organizing by color makes it easier to see for me.Īfter breaking the numbers out into model numbers, I figured I would take it a step further and break it out into Labels. I also use Conditional Formatting to automatically add a color to cells based on what Yamaha model number I enter. The only time I have to edit the chart is if I add a new model to the other sheets. These functions allow the chart to be automatically updated (live) because it’s using data from other sheets in the file. I found the COUNTIF and COUNTIFS functions in MS Excel allowed me to count cells in a range based on certain criteria such as model number, text, or even count cells that have anything in them. Being slightly obsessed with numbers, I was curious about the distribution of 1729 serial numbers and 267 date codes I’ve collected.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |