sooty8
03-22-2008, 05:59 AM
Hi All
A shade longwinded my problem - my brother is Secretary of a Racing Pigeon Club and asked me to help him work out a velocity in Yards Per Minute -- basically it is the Distance Flown divide by the Time taken.
e.g 107Miles 1070Yards / 2Hours - 13Minutes - 23Seconds and by trial & error I have managed to get there the Velocity for the above would be
1419.893ypm.
However everything on the attached enters on Row 5 is it possible by entering an ID Number which is in Column "A" it would put the info in the TextBoxes in that Row. The reason that when another result is entered against J. Bloggs it adds to the previous entry is because this works out the Average Velocity over a series of 11 Races - 1 race per week and you have to enter every race if a competitor misses a race he would have to be deleted.
Many Thanks any help appreciated
Regards
Sooty8.
A shade longwinded my problem - my brother is Secretary of a Racing Pigeon Club and asked me to help him work out a velocity in Yards Per Minute -- basically it is the Distance Flown divide by the Time taken.
e.g 107Miles 1070Yards / 2Hours - 13Minutes - 23Seconds and by trial & error I have managed to get there the Velocity for the above would be
1419.893ypm.
However everything on the attached enters on Row 5 is it possible by entering an ID Number which is in Column "A" it would put the info in the TextBoxes in that Row. The reason that when another result is entered against J. Bloggs it adds to the previous entry is because this works out the Average Velocity over a series of 11 Races - 1 race per week and you have to enter every race if a competitor misses a race he would have to be deleted.
Many Thanks any help appreciated
Regards
Sooty8.