The overall distance is generally correct, but I’m not happy with the roll estimates. I’m thinking of tweaking the roll formula to account for both elevation change AND slope of green.
If you have mapped your clubs you should already have incorporated to an extent the roll out otherwise, just mapping carry distance doesn't always get you closer to the hole but over a bunker or hump on the green...
What you may or may not be considering is the wind yardage effect on a PW and all clubs for that matter changes with the amount of spin applied.
If your calculations or spreadsheet do not account for this adjusted yardage based on spin you will be off sometimes while dead on the other times. So your spreadsheet seemingly works most of the time but when you try to make an adjustment and apply less spin in different wind conditions you are also adjusting the wind effect on that shot.
---A little while ago I watched part of a mapping video of Jason (Young46) working on a new L90 ball. It was almost mind boggling tedious but he plays at the highest level. His ball mapping reflected a range of yardages on the same club depending on the amount of spin applied. There may have been as little as 1 yard variance with some clubs and as much as 6 yards with others depending on the amount of spin applied.
Some people may attribute use a standard number for PW wind effect... but Jason's video shows that number fluctuates...
If you are not accounting for this... you would definitely feel your calculations are off.
At least that is how I account for some shot's that come up shorter than expected or go longer than expected. I have never put in that degree of work or effort to map my clubs with every type of wind. It is actually impressive but shows how well the top players know their club/ball combination and tweak their spreadsheets to account for these factors..
I am pretty certain most people simply don't go to this level of mapping.