UFC 3 - Excel Spreadsheet

Collapse

Recommended Videos

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jeremym480
    Speak it into existence
    • Oct 2008
    • 18197

    #46
    Re: UFC 3 - Excel Spreadsheet

    Originally posted by Maverick32093209
    Dude....i took your excel file then put it on steroids.

    *Improved and simplified ranking system that give extra value to fight bonus and win streaks.

    You will need to input win streaks only into ranking and sort.

    Trust me when I say that you will ALL love what I made. The only problem is I dont know how to upload it. If someone can tell me how to upload an excel file then I will get it to you all.
    Awesome. I can't wait to see it.

    I should note that the majority of the credit for spreadsheet is due to another user here - RyanLeaf16. All I did was share it really.

    Anyway, to post it, all I did was sent to a Compressed (Zipped) Folder and attached. I hope that helps, if not aholbert32 will take care of it for you.

    Thanks
    My 2K17 Boston Celtics MyLeague

    Alabama Crimson Tide
    Green Bay Packers
    Boston Celtics

    New Orleans Pelicans

    Comment

    • Maverick32093209
      Banned
      • Apr 2013
      • 247

      #47
      Re: UFC 3 - Excel Spreadsheet

      Its funny...I am at an interesting place with this new spreadsheet i created. There are few things I can improve...but I am having so much fun with it that I am not going to take the time to stop playing with it to improve it

      Comment

      • RyanLeaf16
        Pro
        • Dec 2007
        • 993

        #48
        Re: UFC 3 - Excel Spreadsheet

        Sounds amazing. If you can't upload it here, then send someone a PM and we can post it. Or, you can upload to a file sharing site.

        Comment

        • aholbert32
          (aka Alberto)
          • Jul 2002
          • 33106

          #49
          Re: UFC 3 - Excel Spreadsheet

          Originally posted by Maverick32093209
          Its funny...I am at an interesting place with this new spreadsheet i created. There are few things I can improve...but I am having so much fun with it that I am not going to take the time to stop playing with it to improve it
          Are you going to post it or send it to me so I can post?

          Comment

          • Maverick32093209
            Banned
            • Apr 2013
            • 247

            #50
            Re: UFC 3 - Excel Spreadsheet

            check your e-mail

            Comment

            • aholbert32
              (aka Alberto)
              • Jul 2002
              • 33106

              #51
              Re: UFC 3 - Excel Spreadsheet

              Thanks Man.

              Posted
              Attached Files

              Comment

              • aholbert32
                (aka Alberto)
                • Jul 2002
                • 33106

                #52
                Re: UFC 3 - Excel Spreadsheet

                Originally posted by Maverick32093209
                Dude....i took your excel file then put it on steroids.

                *Improved and simplified ranking system that give extra value to fight bonus and win streaks.

                You will need to input win streaks only into ranking and sort.

                Trust me when I say that you will ALL love what I made. The only problem is I dont know how to upload it. If someone can tell me how to upload an excel file then I will get it to you all.
                So how does this work exactly. I inputted the win streaks into the HW section but it did not change the rankings for HW.

                Comment

                • Maverick32093209
                  Banned
                  • Apr 2013
                  • 247

                  #53
                  Re: UFC 3 - Excel Spreadsheet

                  I should send you my new file...its even better....

                  but...the streaks alone will not move rank...you have to do the events.
                  Make sure to use the drop down to show the winning fighter.


                  You will need to sort and filter the rankings on the individual weight class page...so the are ordered correctly. YOu dont need to do so on the ranking sheets....except for the P4p Rankings at the bottom.

                  If you want...i can send you the new one...its a bit better

                  Comment

                  • Maverick32093209
                    Banned
                    • Apr 2013
                    • 247

                    #54
                    Re: UFC 3 - Excel Spreadsheet

                    I just sent you an updated version that is better. Here are the directions.
                    I sent you the new file....here are the directions as clear as I can give them
                    [LIST=1]

                    Event Page
                    - Select Weightclass
                    - Select Red Corner and Blue Corner
                    - After each fight Select winner
                    - Select Fight Bonus that apply (its possible to win 2. DONT assign FOTN 2x)
                    - Select Method (has no bearing now...but I could in another version)
                    Weight Class Page
                    - After each fight enter the streak -1 for a loss, +1 for a win. If it is the
                    second loss in a row enter -2 etc.
                    - If a champion loses the belt then use the drop down to indicate that. If a top 5 contender loses to someone outside of the top 5 use the drop down to indicate that
                    - Highlight the rows starting at 3 going down to the last fighter (sort in ascending order to see the rankings.
                    Rank Sheet
                    -hilight row 34 to 190 sort in ascending order...this will give you the p4p list. The top rankings adjust on their own as long as you do so on the individual weightclass pages
                    Last edited by Maverick32093209; 05-22-2013, 04:59 PM.

                    Comment

                    • aholbert32
                      (aka Alberto)
                      • Jul 2002
                      • 33106

                      #55
                      Re: UFC 3 - Excel Spreadsheet

                      Originally posted by Maverick32093209
                      I just sent you an updated version that is better. Here are the directions.
                      I sent you the new file....here are the directions as clear as I can give them
                      [LIST=1]

                      Event Page
                      - Select Weightclass
                      - Select Red Corner and Blue Corner
                      - After each fight Select winner
                      - Select Fight Bonus that apply (its possible to win 2. DONT assign FOTN 2x)
                      - Select Method (has no bearing now...but I could in another version)
                      Weight Class Page
                      - After each fight enter the streak -1 for a loss, +1 for a win. If it is the
                      second loss in a row enter -2 etc.
                      - If a champion loses the belt then use the drop down to indicate that. If a top 5 contender loses to someone outside of the top 5 use the drop down to indicate that
                      - Highlight the rows starting at 3 going down to the last fighter (sort in ascending order to see the rankings.
                      Rank Sheet
                      -hilight row 34 to 190 sort in ascending order...this will give you the p4p list. The top rankings adjust on their own as long as you do so on the individual weightclass pages
                      Thanks man. Is there anything I need to do to add fighters to the chart. I have a number of CAFs I want to add.

                      Comment

                      • Maverick32093209
                        Banned
                        • Apr 2013
                        • 247

                        #56
                        Re: UFC 3 - Excel Spreadsheet

                        Originally posted by aholbert32
                        Thanks man. Is there anything I need to do to add fighters to the chart. I have a number of CAFs I want to add.
                        That would be a bit of a problem. I could figure it out...give me some time.

                        Comment

                        • Maverick32093209
                          Banned
                          • Apr 2013
                          • 247

                          #57
                          Re: UFC 3 - Excel Spreadsheet

                          Good news and bad news...

                          Good news - I figured out how to add extra fighters. I actually just added BJ Penn to LW for my own spreadsheet.

                          Bad news - If you want to just keep adding them it would take some changing of the ranking formula of the weight class and the P4P rankings.

                          Good news - if you tell me who you want to enter by weight class...and where you want them to start in the rankings I can do that for you. If you are into excel I can explain how to do it for yourself going forward

                          Comment

                          • aholbert32
                            (aka Alberto)
                            • Jul 2002
                            • 33106

                            #58
                            Re: UFC 3 - Excel Spreadsheet

                            Originally posted by Maverick32093209
                            Good news and bad news...

                            Good news - I figured out how to add extra fighters. I actually just added BJ Penn to LW for my own spreadsheet.

                            Bad news - If you want to just keep adding them it would take some changing of the ranking formula of the weight class and the P4P rankings.

                            Good news - if you tell me who you want to enter by weight class...and where you want them to start in the rankings I can do that for you. If you are into excel I can explain how to do it for yourself going forward

                            Thanks man. Explain to us all how to do it in Excel. I'm sure I'm not the only one who wants to add CAFs.

                            Comment

                            • jimdawg47
                              Rookie
                              • Mar 2005
                              • 47

                              #59
                              Re: UFC 3 - Excel Spreadsheet

                              This spreadsheet looks great can you make a save in the .xls format when I convert I lose some of the formulas but if you save it in old it should be ok.

                              Thanks
                              Jim

                              Comment

                              • dpmx21
                                Rookie
                                • Jul 2010
                                • 478

                                #60
                                I've got one of these also, that's pretty simple. If anybody wants it I can post it on up.

                                Comment

                                Working...