I think they are some problems with the Munsell notations of the reds, the pure colors.
First my experience makes me think that scarlet should be a yellow red. The name indicates that others thought so too. From what I can see in the pics , it looks like a yellow red to me-- the palest DOS looks coral, right. From what I know that means that that the hue should be greater than 5R up to 10R. Could you all please check this and correct the spreadsheet if you change your mind.
Peggy, you have both scarlet and deep red as 5R, and you maybe more correct in the hue than the others. But I bet they are not identical in hue. Could you please estimate the hue # a bit , make the blue of the two reds 4.9 or 4R and the yellower one 5.1R or greater? This will help when you go to mix.
By convention scarlet is a yellow based red and fuchsia is a blue based one, usually of high chroma. For example I could say that Lanasets have no fuchsia, that is why we use Polar Red a fuchsia from another set of dyes. Gold is a red based yellow, turquoise and cyan are yellow based blues and navy is a blackened blue.
None of you tried to mix 5YR from rust brown, even though it is in YR hue family, nor would you use Navy for 5PB; they both have low chroma and are dark. For the same reasons Emerald Green is not much use for 5G. There are uses for these colors, but not in mixing clear, bright colors like we need for the color wheel. Emerald Green is used in Forest greens and teals and Navy in Air Force or Midnight blue.
Gold is the most used yellow, used in most mixtures because the clear yellow is so weak tintorially that it has little impact mixed into a strong color.
There will soon be a new spreadsheet for the formulas you used to make the colors for your color wheel.