Managing Cricket Stats Online Since 2005

  • Cricket Statz on Facebook

CRICKET STATZ

  • Guides

    • Getting Started
    • Entering Match Scorecards
    • Live Scoring
    • Copying Reports to Excel
    • Importing Matches
    • Managing Historical Data
  • Pricing

  • Forum

  • Developers

    • Adding Reports to Your Web Site
    • API Reference Library
    • API For Uploading Matches
  • Contact

  • Free Trial

  • Log In

  • More

    Use tab to navigate through the menu items.
    To see this working, head to your live site.
    • Categories
    • All Posts
    • My Posts
    Joel Norman
    Dash  ·  
    Aug 12, 2021

    Players by First Match – Report - Sort order

    in Questions

    As I understand this report is sorted by :

    • date/time played

    • then innings batted in

    • then batting position.


    When clubs have multiple teams all playing on the same day and same time how does the system know which player is first in the order? Eg our club has 4 teams – a 1st, 2nd, 3rd and 4th XI.


    We award “Cap No’s” to players to acknowledge their first match so we need to have the order correct. So we have anyone new playing in the 1st XI coming before players in the 2nd XI etc. So I have to dump this report into Excel and then resort it based on the team they are in.


    Just wondering does any other club use this report for this same purpose? and how do you do it?


    Also we don’t do the order by batting position rather alphabetical like the Aussie Test does it. I think this is a more appropriate way as I’m not sure how you order it if 2 new players both don’t bat in their first game – which players goes first? If you do it alphabetical then there is always an order to follow.

    16 comments
    Pat Culpan
    Dash  ·  
    Aug 12, 2021

    Hi Joel, we only issue Cap numbers to 1st Graders, doing 125 years down all the grades would be near impossible. Like you, we use the alphabetical rather than batting order methodology. The alphabetical is the common method used and the major flaw I see with batting order is what if your side fields in the 1st Innings, and gets even worse, what's to say your team fields first and then the rest of the game is rained out, there is now batting order for your team (only a hypothetical one).

    0
    Joel Norman
    Dash  ·  
    Aug 12, 2021

    We actually started giving out numbers which included all our teams about 20 years ago which has made the task much easier to manage. With the First Match Player report from CS I was able to just run the report for our 1st XI only and resort it alphabetically like you do. I actually just presented this 1st XI only list to the committee this season but was told this was "elitist" and i should just continue with the old way of including all teams when running the report!

    0
    Mark
    Aug 12, 2021

    Gents, if you want it alphabetical as the second sort criteria then simply post it up as a suggestion. While I appreciate the discussion, a "suggestion" is the place to get action. Be sure to vote on it while you are there. Looking forward to seeing it.


    @Joel Norman Dumping it out to a spreadsheet and sorting by teams is the best solution for you if you want it sub-sorted by your 1st XI


    @Pat Culpan If a match is rained out before the 2nd team has batted, and you want the players in the second team credited on this report, then you need to enter them on a scorecard and put them all as DNB.

    Joel Norman
    Dash  ·  
    Aug 12, 2021

    Thanks Mark - i'll put this up as a suggestion.


    I just wanted to put it in here first to see if anyone else agreed with us first before doing the suggestion.

    Mark
    Aug 13, 2021

    https://www.cricketstatz.com/support-forum/5a235ec009dd690014684d7c/player-by-first-match-report-sort-order

    0
    Mark Ulcigrai
    Aug 16, 2021

    Hi all.


    We use the sorting feature Date played and batting position.


    This affects our honour board and the cap numbers that have already been issued. I appreciate that the other users in the forum have used alphabetical sorting but apart from the first Test Match (England and Australia) where both teams received their cap numbers alphabetically that is no longer the case.


    We use the DNB as Mark mentioned above. Look at the following international scorecard. Michael Slater (356) and Brendon Julian (357) debuted on the same day, however Michael Slater has the earlier number because they battered first. https://www.espncricinfo.com/series/australia-tour-of-england-and-ireland-1993-61338/england-vs-australia-1st-test-63609/full-scorecard Is there a way a sorting flowchart table could be activated by the end user to keep everyone happy?


    Thank you,

    Mark

    0
    Mark
    Aug 16, 2021

    @Mark Ulcigrai Thanks for posting up.


    I suspected this might happen where we have people wanting different systems. There appears to be no "standard" on this. It makes it difficult to keep everyone happy.


    I think the only solution is to have two separate reports and you guys can then pick and choose (I have kept the old report format handy - just in case this happened).


    Leave it with me.

    0
    Pat Culpan
    Dash  ·  
    Aug 16, 2021

    You will find the Australian team do use the alphabetical system. That Mark Slater/Brendan Julian issue is a whole other story and was caused by Slater believing as he would have the lower number by batting higher than Julian, had the number tattooed on his body, the rest they say is folklore Cricket 2021: Michael Slater tattoo, Brendon Julian Test cap number switch (news.com.au)

    0
    Pat Culpan
    Dash  ·  
    Aug 16, 2021

    And from Wikipedia (yes I know you can't believe everything you read in here) "Where more than one player won his first Test cap in the same Test match, those players are listed alphabetically by surname."

    0
    Mark
    Aug 16, 2021

    @Joel Norman And just a tip for you. *If* you wanted the report to sort by 1st XI then 2nd XI then you could cheat a little by changing the 2nd XI matches to start 1 minute later. It sorts by date/time so this would work nicely. You would only need to do it for matches where there we players starting on the same day in each of the 1st and 2nd teams. I don't think this would happen too often each year so there wouldn't be too many 2nd matches that would need an edit.

    0
    Joel Norman
    Dash  ·  
    Aug 19, 2021

    i just noticed that CS doesn't appear to give you the option of starting the match 1min later as the times are in 15min allotments, so for our 5th team the match would need to start 1hr after the actual time for this system to work, which is starting to look a bit weird...

    0
    Mark
    Aug 20, 2021