![]() ![]() ![]() 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. I have read several sites that talk about how in the mid to late 90's Burny started using serial numbers again and that most say it was stamped in the bridge pickup, but, perhaps it is a modal number and not a serial number The guitar listed on reverb has the latest headstock inlay design (as does mine), and in the catalogs, 1992 was the last. Those a “sanity” checks, calculating the same thing but in a different way. You’ll probably notice there are duplicate total numbers. 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. |