Announcement

Collapse
No announcement yet.

Statistical Tool for the MT Geeks

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • #31
    Re: Statistical Tool for the MT Geeks

    Have you thought of updating it for the possible 9th and 10th mockers this season allowed on a single team? If you do not want to do it, how would one adapt it for their own purposes?

    thanks.

    Comment


    • #32
      Re: Statistical Tool for the MT Geeks

      When I get a chance I'll update it with new mocker slots and streamline the drop-downs for this year's case. If anyone else wants to do that, the document is open source and you're welcome to edit and republish anyway you want so long as you keep the credit sheet in tact.
      "Call on God, but row away from the rocks." - Hunter S. Thompson

      Comment


      • #33
        Re: Statistical Tool for the MT Geeks

        Herb, It seems something in your code on the website, or the way the file was saved, is saying that the excel file is a .doc. Maybe it is just me but on each computer I tried to open it on Word wanted to view it instead of Excel.


        [quote author=JayZ link=topic=2855.msg159723#msg159723 date=1195149862]
        If anyone else wants to do that, the document is open source and you're welcome to edit and republish anyway you want so long as you keep the credit sheet in tact.
        [/quote]

        If you download the file from our site (as I have seen a few people do recently), www.arizonamocktrial.org, you will find the sheet protected. It was set that way so someone who doesn't know how to use it wouldn't edit the wrong cells and destroy the functionality of the file. We do have a copy of the unprotected file available (just not posted on the site), and it seems the Ole Miss version is open to editing as well.

        Comment


        • #34
          Re: Statistical Tool for the MT Geeks

          This program looks amazing, as I just downloaded it last night (from the Arizona site) while trying to review our scores from the ONU Polarbear Invitational. (Great tournament by the way). However, since it is protected, I can't type ANYTHING into any squares. I've seen protected sheets where you can at least input into certain cells (i.e. to ensure someone doesn't screw up the program); however, I couldn't type in our team name, numbers, nor members...etc.... I'm going to check out Ole Miss' site, but in the meantime, how do I go about getting access to use it from Az. (you can PM me if you don't want to post it here).

          I'm also a computer dork so I may try to work with it as well, if I find anything new and exciting to add.

          Thanks a ton, it looks amazing!

          Comment


          • #35
            Re: Statistical Tool for the MT Geeks

            The sheet should allow you to edit the cells that need data. The goal of the protection was to prevent someone from accidentally entering in information in the wrong area which could cause the sheet to stop working correctly.

            You are the second person who has had some problems with it though. I can email you the unprotected version (and maybe I can figure out why our protected version isn't working).
            If you could send me an email (my email address is listed on our contact page on the site - I'm Brian), then I can send you the sheet when I get back to my home computer this evening.
            Also, I'm curious to know if you are using Microsoft Office (and which version), or a different program to open the file.

            Comment


            • #36
              Re: Statistical Tool for the MT Geeks

              I couldn't get the documents to work either. I tried going back to the original link posted, and that didn't work very well.
              The one on Ole Miss website, I got an error trying to open it.
              "You don’t get up from the table until you’ve seen everyone’s hand"
              --

              Comment


              • #37
                Re: Statistical Tool for the MT Geeks

                I'll take a look at the file and see if I can figure out why it is not working for some.

                I'll repost it to our website once it is fixed, or I'll post a link here to an unprotected version. But I may not get around to that till next week.

                Comment


                • #38
                  Re: Statistical Tool for the MT Geeks

                  That's cool whenever you get it up... I'm just psyched to try it out and see what we get!
                  "You don’t get up from the table until you’ve seen everyone’s hand"
                  --

                  Comment


                  • #39
                    Re: Statistical Tool for the MT Geeks

                    ok, actually i reclicked the link from the Ole Miss site, and in doing this, i got the download pop up asking what program i wanted to use to open it (i use firefox, if that affects anyone) and went into my programs and chose to open it with excel, instead of word.
                    It opened, looks like it should be opening

                    Thanks!
                    "You don’t get up from the table until you’ve seen everyone’s hand"
                    --

                    Comment


                    • #40
                      Re: Statistical Tool for the MT Geeks

                      Is there a way to track statistical changes across multiple tournaments?
                      I have one set of data in the spreadsheet, and it is fun to look at it do all the number crunching for me!!

                      Or do you just analyze tournament by tournament?

                      Thanks! This thing is GREAT!

                      Comment


                      • #41
                        Re: Statistical Tool for the MT Geeks

                        I have created a much more statistically complex version of this document, which shows a lot more comparisons between individual performances, and shows the differences between crosser and crossed and the point spread for speeches. Also, it has lots of colorful graphs.

                        I have no idea how to upload it, however. Is there an easy way to do it on this site, or should I bother the team I coach to post it on their site?

                        Comment


                        • #42
                          Re: Statistical Tool for the MT Geeks

                          If you have a more complex version, please put it online and let us know the website. Thanks.

                          Comment


                          • #43
                            Re: Statistical Tool for the MT Geeks

                            As my team's resident stat/numbers geek, I feel compelled to ask if anyone's had a chance to update/post the new template yet. Thanks!
                            Superhuman effort isn't worth a damn unless it achieves results.
                            --Ern

                            Comment


                            • #44
                              Re: Statistical Tool for the MT Geeks

                              I haven't been able to reproduce the problems that some people are having with the version that is on the Arizona Mock Trial website - so I have not made any changes to it yet.
                              If I get some more free time I may develop a more web based version of it - or play around with making it a little more user friendly.


                              If someone has a more complete version than ours and needs a place to host it, I'll be happy to put it on our website.


                              Has anyone played around with doing an excel file for tab summaries? I always see Tab summaries in PDF or .doc format.
                              I could see having a standard excel template that would just require the person in the tab room to input the scores for each round and it would count wins, CS, top 10 teams, etc.

                              Comment


                              • #45
                                Re: Statistical Tool for the MT Geeks

                                [quote author=JayZ link=topic=2855.msg135576#msg135576 date=1139075551]
                                The more AMTA is like the NCAAs, the happier it makes me.
                                [/quote]

                                That's all we need... cheerleaders, full scholarships and the Mock Trial BCS
                                Muhammad Ali - I don't always know what I'm talking about but I know I

                                Comment

                                Working...
                                X