My boss asked me to create a win/loss ratio. I used another software to create the report, but he wants to see numbers and percentages
(you need an account to see links)
I guess you cant really see in the pic but the columns are PROJECT ID, PROJECT DESCRIPTION, CLIENT, PROPOSAL DATE, STATUS (WON OR LOST), DATE OF WON/LOSS, FINAL DISPOSITION REASON, AWARDED TO
I would like to figure out a way to show
1) Total number of won and total number of lost projects
2) Percentage won / loss (total)
For EVERYTHING
and also would like to see that for each individual client if we sort by client. For example,
say we have 5 projects with Ian Moxon and we won 3 and lost 2, we wanna also see that when we sort
Is there a way? IF yes, what would be the easiest way without me having to do this manually?
Thanks guys! I know many of you know a lot about this stuff!
Last edited by looklook123123; 05-04-2017 at 05:35 PM.
(you need an account to see links) | (you need an account to see links)
Made by the wonderful Umbreon!
some prob and stat functions for excel will be able to do this. I'm not fluent with excel functions but I can say yes its possible.
You can search the cell to see if it has a certain phrase (win/loss) to group them into two groups for your total win/loss
Then break it down from there more specifically.
Definitely possible. Can you upload your image to postimage.org or somewhere that won't resize your image? And then share the image here. Thanks.
(you need an account to see links)
(you need an account to see links)(you need an account to see links)
------------------------
[02/24/2013] Stealth CORE is made into the first standalone Neopets auto-player.
------------------------
In order to calculate total number of win and loss:
=CONCATENATE(COUNTIF($E$2: $E$6,"Win"),"-",COUNTIF($E$2: $E$6,"Loss"))
Please note I had to add spaces in here since it was giving smiley icons in the formula. Just take the spaces out in excel obviously.
There are a few things to note about the above formula:
$E$2: $E:6: was my test range. You will enter in here whatever range of cells your win/loss are spread across.
"Win" and "Loss" are whatever you refer to your wins and losses within the highlighted cells. This could be Win, Loss or W, L or whatever they are marked as. The formula is not case sensitive.
For a percentage just use the above formula by dividing the two numbers. ie 3-2 (W-L) just do =3/2 then make it a percentage in the number tab in the home ribbon. If you want solely a winning and losing percentage against the total, just sum the total jobs and divide the number of wins and losses into it ie 3/5=.6 aka 60% for Wins and 2/5=.4 aka 40% for Losses
@(you need an account to see links) I think this answers your question. If I missed something, let me know.
Last edited by looklook123123; 05-04-2017 at 05:50 PM.
(you need an account to see links) | (you need an account to see links)
Made by the wonderful Umbreon!
@(you need an account to see links) if you still need help I am an Excel guru
@(you need an account to see links) you want to use the [noparse] tag to avoid the smileys. Alternatively you can just disable "auto-parse smileys" from the Advanced reply view. Example :$ :) :D :P
l (05-04-2017)oo k lo o k1 2 31 2 3