Ok! it will be interesting to see if that helps. To be strictly accurate the range test data I have from earlier research suggests that a 9pdr fired at 0 degree's elevation over a relatively flat range will make its first graze at 400 yards, its 2nd at 800 yards and its third at 900 yards, whilst a 6pdr under the same conditions achieved 360 yards; 720 yards and 800 yards.
What I suspect will be harder to model is that at elevation the figures were:
9pdr (1 Degree elevation)
1st graze 700 yards; 2nd graze 1,000 yards (with the shot non-lethal between 0-650 yards)
9pdr (2 degree elevation)
1st graze 900 yards; 2nd graze 950 yards; 3rd graze 1,000 yards (non lethal from 0-850 yards)
As you can see elevation rapidly reduces the lethal distance of ricochet fire, whether its a consequence of deliberately elevating the barrel, or simply firing from an elevated position on a target on lower ground. It also reduces the travelling distance of the ball between each bounce as the angle of impact is greater and the ball gets kicked higher into the air by each impact.