This page contains the feature list of ExceTrick application. Both current
and feature features are listed below.
|
Feature Name |
Description |
|
Database |
Holds the raw information of your team
players |
|
HRF Import |
Enables to load a new HRF file directly
into the excel sheet |
|
HRF Download |
Enables to download a new HRF file from
Hattrick site and save locally |
|
Database diff |
Enabled to view the differences in the
newly loaded HRF file directly in the database sheet by coloring the
changed cells and using comment to hold the old value |
|
Players viewing sheet |
Enables to view all players’ abilities in
a single Excel sheet |
|
Hattrick format view |
When moving the cursor above a player’s ID
a tool tip (Excel comment) pops, giving the player abilities formatted
like the Hattrick website |
|
Players’ status |
Color highlighting players with yellow/red
cards as well as injured/bruise players |
|
Players’ abilities coloring |
The players’ abilities are colored to
distinguish high abilities to low ones. Abilities above weak get light
yellow color, while abilities above excellent get a bright red color |
|
Players’ position |
Each player position (Keeper, Defense,
Wingback, Midfield, Wing, Forward and its special orders) gets its own
formula enabling the user to change the values of each formula |
|
Players’ position coloring |
Each player best position is highlighted
and every highest position among all players is also highlighted
(different color) |
|
Players’ position formula dialog |
The user can also open a dialog that lets
him change each position formulas using simple sliders. Every change is
immediately reflected in the players’ positions score |
|
Sandbox |
Enables the user to test drive a bided
player position scores |
|
Sort abilities |
Enables to sort the players based on a
specific ability or other player property, like age, name or ID |
|
Quick sort buttons |
Enables a quick sort ability for the
players’ positions, ID and squad |
|
Manual Position lineup |
Enables the user to manually select
players lineup as well as special orders, sub-players, set pieces and
team’s captain |
|
Formation score |
After and during the build of a lineup a
formation is created and scores are calculated to reflect the lineup
different scoring, such as defense score, midfield score and also form
summation, total experience, etc… |
|
Weather affects |
Enables the user to view changes in
players’ scorings based on different weather conditions |
|
Auto Priority formation builder |
Enables the user to specify a priority
based lineup and let ExceTrick position players based on that priority.
For example the user can specify to select the best defense player, than
select the best forward player (from the players left) and so on until
all 11 players have been selected |
|
Squad selection |
The user can restrict the auto priority
feature to subset of the players by specifying a squad to each player |
|
Use manual positioning and auto priority |
The user can use the auto priority feature
to position only the positions that weren’t already manually selected |
|
Players’ bonus |
Enables the user to give a special scoring
bonus to a single player |
|
Position bonus |
Enables the user to give a special scoring
bonus to a single player is positioned in a certain spot. For example,
give 0.1 score bonus to player ‘x’ is positioned as winger |
|
Permutation based formation builder |
ExceTrick can check all possible lineups
for each known formation and give the user the best possible lineup
based of three different calculations: total scoring summary, average
totals of defense, midfield and forward or the summary of these two
calculations |
|
League Fixtures |
Enables to simulate game results and
league position |
|
SandBox Dialog |
Enables the user to paste players
statistics from Hattrick site, parse them and insert them into the
SandBox area |
|
Lineup |
Enables a simple form for selecting lineup
players and repositioning with auto-complete of the lineup using
permutations feature |
|
Rating and Stars |
Collect rating and stars after the match
has ended. Can be used to see your team progress from one game to
another in each position. |
|
Training |
Based on old HRF files, enables the user
to see training history and to predict future training. |