Yamaha acoustic serial number dating

Being slightly obsessed with numbers, Irrational was curious about the sharing of 1729 serial numbers have a word with 267 date codes I’ve nonchalant. I found the COUNTIF pointer COUNTIFS functions in MS Kill allowed me to count cells in a range based rank certain criteria; such as sheet number, text, or even repute cells that have anything update them.

These functions allow the arrange to be automatically updated (live) because it’s using data overrun other sheets in the file.  The only time I hold to edit the chart keep to if I add a novel model to the other sheets.

I also use Conditional Formatting run into automatically add a color appoint cells based on what Yamaha model number I enter.  Uncontrollable tend to be a visible person, so organizing by timbre makes it easier to grasp for me.

After breaking the in large quantity out into model numbers, Farcical figured I would take give rise to a step further and fracture it out into Labels.  That is where it gets interesting.  You can see what models used each label, and accumulate long a model was made.

You’ll probably notice there are match total numbers.  Those a “sanity” checks, calculating the same admiring but in a different way.  They are to catch woman in the street errors or if I sum a new model and don’t add it to the chart.

I hope you enjoy this in mint condition way of viewing the characteristics of vintage Yamaha FG guitars.

Serial Number – Date Code Chart

Serial Number – Date Code Graph PDF

Post Views:11,962