Hi all,
Long time lurker and first time poster. I regret to make my introduction one where I ask (beg) for help but am at a loss achievable results.
I'm compiling some football stats (not soccer). For anyone not familiar with football you have 4 downs to get a min. of 10 yards to achieve a first down. You could be 1st down and 10 yards to go, get 12 yards and you have a first down. Or you could be 3rd down and 12 yards to go, get 15 yards and achieve a first down. Or you could be 2nd down with 2 yards to go, get 3 yards and have a first down.
I am trying to populate a table with whether or not a first down was achieved (converted) based on the down, distance to go, and yardage gained on that play information is already in the table. I am praying someone here may be able to help?
Here's an example of some data in my file:
DN DIST GAIN CONVERTED
1 10 14 YES
1 10 3 NO
2 7 8 YES
1 10 5 NO
2 5 14 YES
1 10 3 NO
2 7 21 YES
2 22 0 NO
1 10 17 YES
1 10 0 NO
2 10 14 YES
1 10 9 NO
2 1 5 YES
1 10 75 YES
1 10 1 NO
2 9 8 NO
3 1 3 YES
1 10 6 NO
2 4 16 YES
1 10 0 NO
I manually wrote in whether the down was converted or not but ideally I am looking for a formula to help achieve that but I am pretty lost on how to achieve that ANY help would be appreciated.
This one file has 10K rows which is why I only entered a sample of the data so you can see what I am working with.
Thank you!!
Regards,
Nate
Long time lurker and first time poster. I regret to make my introduction one where I ask (beg) for help but am at a loss achievable results.
I'm compiling some football stats (not soccer). For anyone not familiar with football you have 4 downs to get a min. of 10 yards to achieve a first down. You could be 1st down and 10 yards to go, get 12 yards and you have a first down. Or you could be 3rd down and 12 yards to go, get 15 yards and achieve a first down. Or you could be 2nd down with 2 yards to go, get 3 yards and have a first down.
I am trying to populate a table with whether or not a first down was achieved (converted) based on the down, distance to go, and yardage gained on that play information is already in the table. I am praying someone here may be able to help?
Here's an example of some data in my file:
DN DIST GAIN CONVERTED
1 10 14 YES
1 10 3 NO
2 7 8 YES
1 10 5 NO
2 5 14 YES
1 10 3 NO
2 7 21 YES
2 22 0 NO
1 10 17 YES
1 10 0 NO
2 10 14 YES
1 10 9 NO
2 1 5 YES
1 10 75 YES
1 10 1 NO
2 9 8 NO
3 1 3 YES
1 10 6 NO
2 4 16 YES
1 10 0 NO
I manually wrote in whether the down was converted or not but ideally I am looking for a formula to help achieve that but I am pretty lost on how to achieve that ANY help would be appreciated.
This one file has 10K rows which is why I only entered a sample of the data so you can see what I am working with.
Thank you!!
Regards,
Nate