I don't have much time have to leave in 20 minutes. For those that are around have the master open that pops loaded this morning. Take this and copy it into cell BC1523 THEN hit a return.
+SUMPRODUCT((BC$347:BC$1518="ROAD DOG")*($AP$347:$AP$1518="L"))&"-"&SUMPRODUCT((BC$347:BC$1518="ROAD DOG")*($AP$347:$AP$1518="W"))
Once there you now have the win/loss for the road dogs within col BC. Notice that AP is looking at L first as you are counting the visitors wins. AP is listing win/loss by the home team so an L means the visiting team won. In the center of the formula you see &"-"& all that does is separates the formula into 2 parts. The first part deals with the wins for the visitor and second has the losses for the visitor.
Correct answer should be 13-27. 13 wins for the visiting dog while it lost 27.
This formula can be modified to add any specifics you wish. Keep the range the same as in row 347 which is the 1st of May to 1518 which was the last row in the master for today.
Within that formula you the figure *. This separates each segment of the formula into a specific grouping.
The first group is written (BC$347:BC$1518="ROAD DOG"). No * sign as it is the first statement within the formula.
The second statement *($AP$347:$AP$1518="L") is looking at the win/loss. Loss to be specific. The * separates the statement into 2 parts. First it looks for all road dogs in col BC once it finds them in counts the L for the loss in col AP. Not sure how many of these separations one can have but I never ran out yet.
I will stop here and let you digest that. All you have to do is paste that formula where I said and look at the answer.
+SUMPRODUCT((BC$347:BC$1518="ROAD DOG")*($AP$347:$AP$1518="L"))&"-"&SUMPRODUCT((BC$347:BC$1518="ROAD DOG")*($AP$347:$AP$1518="W"))
Once there you now have the win/loss for the road dogs within col BC. Notice that AP is looking at L first as you are counting the visitors wins. AP is listing win/loss by the home team so an L means the visiting team won. In the center of the formula you see &"-"& all that does is separates the formula into 2 parts. The first part deals with the wins for the visitor and second has the losses for the visitor.
Correct answer should be 13-27. 13 wins for the visiting dog while it lost 27.
This formula can be modified to add any specifics you wish. Keep the range the same as in row 347 which is the 1st of May to 1518 which was the last row in the master for today.
Within that formula you the figure *. This separates each segment of the formula into a specific grouping.
The first group is written (BC$347:BC$1518="ROAD DOG"). No * sign as it is the first statement within the formula.
The second statement *($AP$347:$AP$1518="L") is looking at the win/loss. Loss to be specific. The * separates the statement into 2 parts. First it looks for all road dogs in col BC once it finds them in counts the L for the loss in col AP. Not sure how many of these separations one can have but I never ran out yet.
I will stop here and let you digest that. All you have to do is paste that formula where I said and look at the answer.
I will be back later so leave your questions at the door. One step at a time. Does not get any harder than that. Once you have the formula and make it work the sky is the limit. I will answer them later so you all can do your own thing.
If you get that to work take this *($F$347:$F$1518="a")
copy it and paste it right after the last ) after road dog. Do this to the first part of the formula and also the second. Then put your cursor at the end of the formula and hit a return.
Now you have road dogs by the A league and by wins and losses. You can go inside the formula and change the A to a N and you now have national league.
The "A" have to remain. The "" make the formula look for the A in col. F.
You get this and your up to a B for the class. Again questions and I will answer later as I have to run.
If you get that to work take this *($F$347:$F$1518="a")
copy it and paste it right after the last ) after road dog. Do this to the first part of the formula and also the second. Then put your cursor at the end of the formula and hit a return.
Now you have road dogs by the A league and by wins and losses. You can go inside the formula and change the A to a N and you now have national league.
The "A" have to remain. The "" make the formula look for the A in col. F.
You get this and your up to a B for the class. Again questions and I will answer later as I have to run.
Okay okay, some interest which was nice. Here it is. I don't like pivots. They are great in there own way but I want something concrete and right now. This allows that to happen. The master is a master piece in its own right. I use it every day. I keep my own master. It is all the data that you people get but off to the right I have like 30 to 50 cols of calcs and so on that I look at. All little formulas that track things of interest to me. Like the examples you folks mentioned. By doing that I can keep track of each at a glance with year to date or 10 days or 21 days what ever trips your trigger. Just my way. Say you have 3 items that are working for you. Would you prefer to go to the pivots for each or use I formual like I showed you and at a glance you have the record and a record for x amount of previous ways. I am not trying to change the way you think but offer a different way for you to think.
JJ I do play those big favorites to a point. First I look at their record. Mentioned just yesterday that a play where the fav in the upper brkts was 0-4 in the last 21 days would I play that no. But today with Tam and Col the last 21 days with that scenerio has no losses. Would I play that hell yes. The money line no. But you can manipulate it to your advantage. Play the run line and the money line. All I have is -1.5 on the run line. So you set up your number so you make 20% if the m/l wins and all if they win by 2. Reduces the vig by large amounts. To each his own. Just have to realize that these are not just betting a huge favorite but a huge favorite that has a 80% chance or more of winning.
To sum this up by using the formula I mentioned and looking at the HF5, 6 and 7 cats. They are now all in the plus but a week or 10 days ago some were 6-7 and you would have lost your ass but cats mentioned by choosing were plus money.
You have seen the light questions welcome.
JJ I do play those big favorites to a point. First I look at their record. Mentioned just yesterday that a play where the fav in the upper brkts was 0-4 in the last 21 days would I play that no. But today with Tam and Col the last 21 days with that scenerio has no losses. Would I play that hell yes. The money line no. But you can manipulate it to your advantage. Play the run line and the money line. All I have is -1.5 on the run line. So you set up your number so you make 20% if the m/l wins and all if they win by 2. Reduces the vig by large amounts. To each his own. Just have to realize that these are not just betting a huge favorite but a huge favorite that has a 80% chance or more of winning.
To sum this up by using the formula I mentioned and looking at the HF5, 6 and 7 cats. They are now all in the plus but a week or 10 days ago some were 6-7 and you would have lost your ass but cats mentioned by choosing were plus money.
You have seen the light questions welcome.
yesterday recap...glad to see a few went to school to eat the teacher. hope you learned more than that 3-1 thursday, have to count TP a NP as there was also a PC road dog on detroit as well. one thing i failed to look at yesterday, and had the time to do it was the root cause of the sd ov for the zen 4. the simple way to say this is that they are based on the most recent past history of the teams playing or either high or low OL. in the case of SD it had low o/u numbers and even got bet down to a 6 spot but it showed as they had a bunch of recent very high scoring games (one was even a edding game that i had under that was in double digits and a few more around that time as well) at this point it's made up for the red crush the other day, but just in the black for the week time to get to work
as ctp said earlier to each his own, and whatever works for you. oil introduced me to pivot tables a few years back and i've never looked back. for me it's like looking at a picture, plus i'm just too fucken dumb to create all of the calc that ctp does. but they both work, ctp is a little faster in ziggs and zaggs, but they both get the job done. also note that ctp had me put in a filter to supress the HF7 so they will no longer show up in his projections, but i left the previous history as is
