Fantasy football team using FIFA14 stats

Cluele55

Hi, so I've come up with a plan to take all English Premier League Fifa 14 player stats and come up with a way to generate the best possible fantasypremierleague.com team




Basically from a pool of 600 players who have 1 of 3 positions, Defender, Midfielder, Forward, I have $100m to spend on a team of 5 Defs, 5 Mids, and 3 Fors. I have assigned a price to each player.

I first want to filter out the players with <10 appearances this season and players with no price. Then taking the remainding player stats from Fifa14, generate a total stat number by adding and multiplying the player attributes.

Finally I want to find these 13 players, not exceed my budget, and ensure that I only have a maximum of 3 players from any one team.

Tough job I know, I was just wondering if you could point me in the right direction as to the method using RM.

Cheers
Red

Cluele55

Hope I'm doing this right. So I've performed the following and have narrowed my database down to this. I generated a new attribute called total stats with was based on all the previous attributes and I've filtered them out. I want to cluster the remaining players by position (def, mid and for) and then choose the top (5,5,3) players of each cluster with two conditions.

1. Total spend (price) <100million
2. No more than 3 players from any one team

I would really appreciate any help, even a guess as to my next move

Cheers

<?xml version="1.0" encoding="UTF-8"?>

-<process version="6.0.002">


-<context>

<input/>

<output/>

<macros/>

</context>


-<operator name="Process" expanded="true" compatibility="6.0.002" class="process" activated="true">

<parameter value="init" key="logverbosity"/>

<parameter value="2001" key="random_seed"/>

<parameter value="never" key="send_mail"/>

<parameter value="" key="notification_email"/>

<parameter value="30" key="process_duration_for_mail"/>

<parameter value="SYSTEM" key="encoding"/>


-<process expanded="true">


-<operator name="Retrieve FantasyFooter" expanded="true" compatibility="6.0.002" class="retrieve" activated="true" y="30" x="45" width="90" height="60">

<parameter value="//Local Repository/FantasyFooter" key="repository_entry"/>


-<operator name="Filter Examples (2)" expanded="true" compatibility="6.0.002" class="filter_examples" activated="true" y="120" x="45" width="90" height="76">

<parameter value="" key="parameter_expression"/>

<parameter value="custom_filters" key="condition_class"/>

<parameter value="false" key="invert_filter"/>


-<list key="filters_list">

<parameter value="Fantasy Price.is_not_missing." key="filters_entry_key"/>

<parameter value="APPEARANCEPercentage.gt.0\.5" key="filters_entry_key"/>

<parameter value="APPEARANCEPercentage.is_not_missing." key="filters_entry_key"/>

</list>

<parameter value="true" key="filters_logic_and"/>

</operator>


-<operator name="Generate Attributes (2)" expanded="true" compatibility="6.0.002" class="generate_attributes" activated="true" y="210" x="45" width="90" height="76">


-<list key="function_descriptions">

<parameter value="DEFENDING+DRIBBLING+HEADING+PACE+PASSING+RATING+SHOOTING+SKILL+WEAKFOOT*APPEARANCEPercentage" key="Total Stats"/>

</list>

<parameter value="true" key="use_standard_constants"/>

<parameter value="true" key="keep_all"/>

</operator>


-<operator name="Select Attributes" expanded="true" compatibility="6.0.002" class="select_attributes" activated="true" y="300" x="45" width="90" height="76">

<parameter value="subset" key="attribute_filter_type"/>

<parameter value="" key="attribute"/>

<parameter value="Club|Fantasy Price|Total Stats|Name" key="attributes"/>

<parameter value="false" key="use_except_expression"/>

<parameter value="attribute_value" key="value_type"/>

<parameter value="false" key="use_value_type_exception"/>

<parameter value="time" key="except_value_type"/>

<parameter value="attribute_block" key="block_type"/>

<parameter value="false" key="use_block_type_exception"/>

<parameter value="value_matrix_row_start" key="except_block_type"/>

<parameter value="false" key="invert_selection"/>

<parameter value="false" key="include_special_attributes"/>

</operator>

<connect to_port="example set input" to_op="Filter Examples (2)" from_port="output" from_op="Retrieve whosyodaddy"/>

<connect to_port="example set input" to_op="Generate Attributes (2)" from_port="example set output" from_op="Filter Examples (2)"/>

<connect to_port="example set input" to_op="Select Attributes" from_port="example set output" from_op="Generate Attributes (2)"/>

<connect to_port="result 1" from_port="example set output" from_op="Select Attributes"/>

<connect to_port="result 2" from_port="original" from_op="Select Attributes"/>

<portSpacing spacing="0" port="source_input 1"/>

<portSpacing spacing="0" port="sink_result 1"/>

<portSpacing spacing="0" port="sink_result 2"/>

<portSpacing spacing="0" port="sink_result 3"/>

</process>

</operator>

</process>