| The Southern Freedivers Forum - Spearfishing and Freediving in Victoria http://southernfreedivers.org.au/forums/ |
|
| Comp Score Sheet - old http://southernfreedivers.org.au/forums/viewtopic.php?f=9&t=556 |
Page 1 of 1 |
| Author: | Kurt [ 05 Oct 2007, 20:30 ] |
| Post subject: | Comp Score Sheet - old |
Leigh has brought this very nice, excel score sheet to my attention. It automatically works out your score from weight and it tells you your full score. you can get it here: http://southernfreedivers.org.au/forms_and_pdfs/Comp-Score-Sheet.xls Note* you need Excel installed to use this. Remember to thank Leigh! |
|
| Author: | south935 [ 07 Oct 2007, 18:14 ] |
| Post subject: | |
Champion effort. Jees it would be nice for these to be used at weighins rather than using the paper sheets. That way we could easily have all the catch and effort data in a database. Doesn't sound important, but they will be in the future! |
|
| Author: | Gigantor [ 09 Oct 2007, 10:39 ] |
| Post subject: | |
Great effort Leigh. I just gave it a go and all worked fine. Could possibly enhance it by including more diver tabs, then a separate sheet to rank all the divers automatically. Also, the blank spots at the end of each section are for any unusual/unlisted captures. You would need to include the formulas for these rows as well. Well done! Gig PS Spelling mistake for Trevally. Sand Flathead needs to have a space removed. |
|
| Author: | Lethal [ 09 Oct 2007, 17:58 ] |
| Post subject: | |
Thanks guys.. I really only spent half an hour on it with the intention being to give people a quick way of calculating their scores. I don't know how Brett currently does it, and tracks it over the year.. But if we want to use this sheet a bit I will put a marco in to rank the divers (overall and per grade). This will allow you to have a sheet that tracks scores over the year. You also have a database of all the divers and species shot for the year. This might be useful when deciding if a fish stays on the list or gets the arse??? Anyway let me know your opinions. And by the way the blank lines do have formulas, and i never claimed to be a good speller!! Cheers, Leigh |
|
| Author: | Kurt [ 09 Oct 2007, 20:55 ] |
| Post subject: | |
You might want to discuss this further with gigantor, but i was talking to him on the phone and reckons it would be a great idea to have separate tabs for other divers and have the comps placed out on computer instead of paper. If you have time to add more to it, it will be greatly appreciated. Kurt. |
|
| Author: | Lethal [ 09 Oct 2007, 21:35 ] |
| Post subject: | |
Yeah all that's a peice of piss.. It's just a matter of whether we want to do weigh-in's like that (it might take an extra 5 minutes). But i'm more than happy to bring my laptop down and trial it at the next comp. Once the weigh in is complete it's just a matter of clicking a button to obtain the results. |
|
| Author: | Gigantor [ 09 Oct 2007, 22:43 ] |
| Post subject: | |
Good work guys. I think we will always keep the hard copy as an official record and offer the carbon copy to the divers. Will write down scores first and input later. Running totals for the year sounds good too. The macro will also have to take into account that we tally up the best 6 of 8 competitions. Re rows, I stand corrected. Must have input the weight into the wrong column. |
|
| Author: | Watto [ 06 Oct 2010, 15:05 ] |
| Post subject: | Re: Comp Score Sheet |
hey kurt, can u post the new comp sheet please? Im stil memorising species |
|
| Author: | Chris [ 02 Dec 2011, 16:07 ] | ||
| Post subject: | Re: Comp Score Sheet | ||
new scoresheet
|
|||
| Page 1 of 1 | All times are UTC+11:00 |
| Powered by phpBB® Forum Software © phpBB Limited https://www.phpbb.com/ |
|