Last answered:

28 Jul 2024

Posted on:

12 Jul 2024

0

Excel: Football Trnasfer Analysis

1. i am on step 3 of the FTA project. i calculated the sum of outgoing transfers from europe using SUM IFS but i am yet to see a column for  number of incoming transfers  cos there is no data for incoming transfers, i have attached a screen shot for your perusal.


 I have also screen shot how i got the sum for out going transfers

kindly advise on how to get data for incoming transfers. tx

6 answers ( 0 marked as helpful)
Instructor
Posted on:

14 Jul 2024

0

Hi!

Do you want to use column C of the 'Database' sheet, please?

Best,

Ned

Posted on:

14 Jul 2024

0

Column C of the database sheet? Am I to use countif per country in Europe to get the number of incoming transfer?

Posted on:

21 Jul 2024

0

i have calculated the number of incoming  and outgoing transfers using

count and sum respectively. 

find below a screen shot of the data base sheet showing some cells as zero , it also showed that its total club compensation, i have gone through the review again so as to derive a formula for the compensation, i dont think the info on the club compensation is complete, kindly advise


Posted on:

23 Jul 2024

0

Hello Ned, 

you are yet to answer my question, i thought of getting  an averge transfer fee using the number of incoming and outgoing players per country . the issue is that it will give an average, and the guide is asking for incoming and outgoing transfer fee.

i have reviewed the notes, i am yet to see an information that will help in deriving a formula, kindly advise

Instructor
Posted on:

24 Jul 2024

0

Hey Abiola,

Here's the formula I've used to calculate incoming transfers:

And here's the formula for outgoing:

Then i have the following per country:

And here's the dollar amount:

Hope this helps!

Best,

Ned

Posted on:

28 Jul 2024

0

Hello  Ned, i tried submitting my project but i realised  a screen shot would not suffice, hence using this link 

1.  Country transfer analysis: https://1drv.ms/x/c/fb2b261b33bb81c9/EYs7RnydvzBMmMUasR3w-UwBtNgoKbd4v3BkR6hEFbfi8Q?e=9b4i1C

2,  Net transfers : https://1drv.ms/x/c/fb2b261b33bb81c9/EYs7RnydvzBMmMUasR3w-UwBtNgoKbd4v3BkR6hEFbfi8Q?e=u4eLct

3. top 5 European transfer fees :https://1drv.ms/x/c/fb2b261b33bb81c9/EYs7RnydvzBMmMUasR3w-UwBtNgoKbd4v3BkR6hEFbfi8Q?e=Ud8pjD 


if there is abetter way of submitting my work, kinldy advise 

Thank you

Submit an answer