Đã hoàn thành

Simplify my spreadsheet

Ok, This project is just for fun to track a game clash of clans that I play with my son.

I built the attached spreadsheet to track how each of the players on my team does. But it became too clumsy and I finally quit. He now has a few friends on the team and so do I and want to track some stuff.

My needs are actually much simpler then the spreadsheet makes it look.

The game consists of a team of up to 50 players, many players change in and out. New ones come in but when a player leaves we rarely let them back in so we don’t need to keep their data. Every day or so a team will have a war against another team. You get two attacks and can get from 0-3 stars per attack.

At the start of each war the players that are participating get ranked. Your ranking is a reflection of how difficult an opponent you are.

All of this data need to be entered manually so I need the data entry to be as simplified as possible. This is really the key to the project.

1. I need to be able to add and remove teammates easily.

2. I need to be able to type their rank in at the beginning of each war. (this gives difficulty rating)

3. Not all teammates participate in a war so if I don’t enter a rank then it is assumed the player is not in this war.

4. Be able to enter the number of stars on the first and second raid as well as the numerical rank of the player they attacked.

5. I need to be able to enter this info when they are attacked as well.

6. I need to be able to enter if we won lost or tied the war.

7. Mark if a player missed one of his two raids

8. I also need to maintain a list of what the players real name is not just his game name.

This gives me the info to calculate a number of things.

For team:

How many wars have we been in

What is our win %

For Player:

1. Number of wars he has been in. This should be a two part number – first part is how many wars has the team had since his name went on list. Second part is how many of those wars has he participated in.

2. What is his average stars over all wars. I want this as a per war number, so the range is from 0-6.

3. What is his difficulty ranking, both offense and defense, your rank is how difficult an opponent you are. If our number one attacks their #9 it is an easier raid then him attacking their #1. This is their offensive difficulty ranking. So if he attacked their 1 he would be a difficulty of 0. If he attacked their #9 he would be a -9. This way I can rank the players not only by their average stars per war but also their difficulty ranking.

4. then I need this for their defensive ranking. So if our # 5 gets hit by their #2 he would have a +3 for that raid.

5. The offense and defensive ranking should be a per attack average over all attacks.

6. There should be an average stars against.

7. There should be an average team contribution – Average Team contribution is simply average stars scored – average stars you lost (defensive)

So each player should have this info

# of # of Avg. Avg. Avg. Avg. Avg.

wars wars Defensive Defensive Offensive Offensive team

here for in Difficulty Stars Difficulty Stars contribution

Kĩ năng: Excel

Xem nhiều hơn: what is data entry 10 key, what is a 10 key data entry, hit data entry, fun with excel, defense one, how do i change my, excel mark, 10 key data entry, raids, raid 5, of clans, numerical entry project^^%%, lost excel, game of war, clash, clash of c, data entry stuff, clash clans, fun excel spreadsheet, data entry fun

Về Bên Thuê:
( 14 nhận xét ) Farmingdale, United States

ID dự án: #7465005

Được trao cho:

bhupindrverma

Hi, I play clash of clans as well and will send you as simple sheet as i can create within 2 days. I love this game so this task will be a fun for me. Best Regards Bhupinder thakur

$20 USD trong 2 ngày
(1 Nhận xét)
0.8

6 freelancer đang chào giá trung bình $24 cho công việc này

facebooklikes007

Data Entry Sample work --- [login to view URL] Dear Buyer Greeting from Dream Media Solutions. Thank you very much for giving us an opportunity to bid for your Thêm

$30 USD trong 1 ngày
(53 Nhận xét)
5.5
aticul

Hi, I can take 100% confidently your project. I can give quality service fast from others. I am expert about it. You can see my full profile and feedback to check the experience. I available online any time. We will se Thêm

$11 USD trong 1 ngày
(5 Nhận xét)
1.9
noorannajeeb

HI, i am highly interested to do this work.I think i am perfect in excel but I don't have much rating so please just check me one time. i am a student and in need of pocket money so please check me one time.i promise u Thêm

$30 USD trong 1 ngày
(1 Nhận xét)
0.0
meganperkins

I can do this quickly accuratly and righT Check out my linkedin [login to view URL]

$25 USD trong 1 ngày
(0 Nhận xét)
0.0
donationbooster

As an avid player of CoC myself with my son (Lil Hog Riders Clan), this is an interesting project. My clan hasn't gone to these lengths yet to track performance because of the manual steps required to enter and track Thêm

$25 USD trong 1 ngày
(0 Nhận xét)
0.0