@ZWExton and @rsvma the point of tracking the yardage is to determine a set of tees you would enjoy the most. The author, Brad Klein of Golfweek wrote, " I’m most comfortable and having the most fun when I’m playing tees in the 6,200-yard range" which is what HIS spreadsheet results were for him.
I don't need to track the yardage of my bogeys or worse. I make a notation on my card what CAUSED the poor play on that hole and work to eliminate them between rounds. If I can get my "Ah Shits" to 5 or less a round, I'm probably scoring in the low 80's or occasionally breaking 80, especially if I'm playing yardage that "I'm most comfortable and having the most fun".
It does lead to a good discussion. The resulting yardage may give you number that provides a good mix of greens in regulation you can hit with an iron to give you a shot at birdies while not playing something so short it becomes a driver and an 8,9, or W all day.