villeqert.blogg.se - Awsnick bungie halo stats

This means that if you come 4th place on a winning 4-man team, your team weighted placing will be 3. For a 5-man team it will be reduced by 1/5. For a 3-man team, each player's contribution to the team win is 1/3 (and each player's placing will be reduced by 1/3). The size of the adjustment is proportional to the size of your team. When team win weightings are used, everyone on the winning team has their placing adjusted downward (i.e. Team win weightings help to balance this out. For example, you may have kept the heat off your buddies in the hill, or escourted a flag-carrying team-mate home - but all you get for your trouble is a bad overall placing, while your team-mate comes 1st and gets all the glory.

Team Win Weightings: The idea of team win weightings, is to recognise a player's contribution to helping their team win.

Select "Analysis ToolPak" from the list (put a tick in the box) and click OK. To activate this, open the spreadsheet, click on "Tools" on the menu bar and select "Add-Ins". The Team Balancer uses functions which are in Excel's Analysis ToolPak. Also, you may need to activate one of the add-ins in Excel (you only need to do this once). In order to allow the Team Balance function to work, when you open the spreadsheet you need to click on the "Enable Macros" button.

Using the spreadsheet: The spreadsheet is in Excel 2000 format.

We recommend setting this to "Y" for King of the Hill & CTF games, and "N" for Slayer games. This is only used when calculating for an odd number of players. There is also a "Man Down adjustment?" variable you can set to "Y" or "N". Enter a "Y" in column C for each player you want to include in the calculation, and then click on the "Calc" button.

The "Team Balancer" sheet is used to calculate 2 evenly-matched teams.

It has a cross-reference listing of the team games won & lost, with each other player.

The "Teamwork Analysis" sheet is for viewing only.

The type of game & map can be entered in the green "Type:" area, and any Team Scores entered in the "Blue:" & "Red:" areas. If a team game was played: enter a "Y" in the "Team Win?" column if they player was on the winning team and an "N" if they were on the losing team. Placing/score/kills/assists/deaths are entered straight from the details on the Post Game Carnage Report. The 20 game-stats sheets are where the totals for each game are entered.We recommend leaving the Team Win Weightings option on (i.e. The player names are entered in column A, and there is a "Team Win Weightings?" option you can set to "Y" or "N". The "Totals" page is where the overall stats are viewed.

Sheet, 20 game-stats sheets, a "Teamwork Analysis" sheet, and the "Team The spreadsheet contains 23 individual sheets. Looking at the completed example is probably the best way to get a feel for how the sheet is used. I have included both a blank spreadsheet (190k, zipped) and one populated with the scores from our last day (194k, zipped). It also allows us to use a "Team Balancer" function to select the most evenly-matched teams. This allows us to monitor each player's performance and declare an overall winner for the day. Over this time, we have developed an Excel spreadsheet to record the stats for the day's play. Over the past year or so, I've hosted a number of Halo Multiplayer LAN parties at my place. I haven't had time to play with this (more than simply open the sheet) - but if you're serious about keeping track of how people in your group are doing, this might be helpful!Ĭan you please make the following spreadsheet available to your subscribers. We got this note from Greg Irvine recently - it's a pair of spreadsheets (one empty, one populated with real data as an example) that can help you keep track of player stats.