You might add rows and accomplish something close to what you are asking. change row 3 so D3 is 4 and E3 is 5. Insert a new row 4 where D4 is 1 and E4 is 3 (and new row 5 where D5 is 1 and E5 is 3 which will be needed due to separating the 5-12 range on the right side). Add another index number (.048) and value (7) in choose. The 'random busting' part, in my mind, would be on the right side where J3 and K3 would be 10. J4 would be 5 and K4 would be 9, you would then need to insert another row so that J5 could be 11 and K5 could be 12. Reset the Choose again adding index number .064 and value 8. This would mean that 10 would be chosen 60%, 5,6,7,8 or 9 would be chosen 20% and 11 or 12 would be chosen 20% of the original 8% that was designated to be 5-12. (I hope that makes some amount of sense.) I did not tackle any of the other ranges in the attached file as I am not sure that this approach is acceptable.
Bookmarks