
I need someone to sort out some formulars and add some on a spreedshett I have
- or -
Post a project like this4910
£40(approx. $54)
- Posted:
- Proposals: 3
- Remote
- #211776
- Awarded
Description
Experience Level: Intermediate
basically i have a spreedsheet I have created for keeping a log off all the tips I give out to people on twitter.
I have already asked someone on another site similar to this to try and sort it out and it kinda has but didnt know how to do certain parts.
Basically I need to be able to look at the spreedsheet and know what my win percentage is every week and every month. I give tips away every day so there will be a number of tips everyday.
I also have a members section. These people pay for their tips. I will need to know the win % of these on a weekly and monthly basis.
I also have a PAYB section as well. These are exclusive to members only and again I will need to know the win % of these on a weekly and monthly basis.
I would like somewhere on the spredsheet - even if its on a different "sheet" a running profit/loss on members, free tips and PAYB tips. If the win percenatge could somehow be included as well that would be great.
What is one the sheet right now he has create a win ratio. This seems to be wrong as if i put in 2 wins and a loss I have won 6% of them but this somehow makes it 200%. In the result colum I also need to add VOID as well.
When you see the sheet I really hope all the above makes sense and it will not take long to do as I need to start it on the morning of 1st feb.
any questions just ask.
I have already asked someone on another site similar to this to try and sort it out and it kinda has but didnt know how to do certain parts.
Basically I need to be able to look at the spreedsheet and know what my win percentage is every week and every month. I give tips away every day so there will be a number of tips everyday.
I also have a members section. These people pay for their tips. I will need to know the win % of these on a weekly and monthly basis.
I also have a PAYB section as well. These are exclusive to members only and again I will need to know the win % of these on a weekly and monthly basis.
I would like somewhere on the spredsheet - even if its on a different "sheet" a running profit/loss on members, free tips and PAYB tips. If the win percenatge could somehow be included as well that would be great.
What is one the sheet right now he has create a win ratio. This seems to be wrong as if i put in 2 wins and a loss I have won 6% of them but this somehow makes it 200%. In the result colum I also need to add VOID as well.
When you see the sheet I really hope all the above makes sense and it will not take long to do as I need to start it on the morning of 1st feb.
any questions just ask.
Dave E.
100% (1)Projects Completed
7
Freelancers worked with
6
Projects awarded
75%
Last project
10 Sep 2013
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies