Our team made a shooting simulator in excel that factors in air resistance and rebounds against the backboard. It might be a little late to be useful, but we figured we would post it anyway in case anyone might find it useful.
There is a pdf attached that should show you how to use it.
Enjoy!
Physics of Shooting_Ver1.xlsx (1.83 MB)
Shot Trajectory and Scoring Simulator Quick Guide.pdf (507 KB)
Physics of Shooting_Ver1.xlsx (1.83 MB)
Shot Trajectory and Scoring Simulator Quick Guide.pdf (507 KB)