Speed Limits - Prop Tip/TAS

[Toobuilder]

Is there a limit (or at least a rule of thumb) that describes the relationship between propeller tip speed and aircraft TAS regarding efficiency? For instance, structural considerations aside, there becomes a point where higher RPM (tip speed) starts making more noise than thrust. It would be nice if one could plug in RPM, diameter, and TAS to a spreadsheet and find the limits of a given design expressed as: OK; Questionable; or Don’t Even Think About It!
Short of a readymade spreadsheet, is there a basic rule (% speed of sound, perhaps?) that describes tip speed limits?
Thanks
Mike

 

[addaon]

 

[Jan Carlsson]

 

[Toobuilder]

 

[Dan Thomas]

 

[TFF]

 

[Toobuilder]

 

[Jan Carlsson]