Community - American Football Management Simulator
AdBlocker active? It seems you are using software to block advertisements. You could help us if you could switch it off when visiting redzoneaction.org. The reason is very simple: Advertisements help us running the site, to offer you the game in a good quality for free. So if you like the game, please support us by purchasing a Supporter Account or disabling the AdBlocker on this site. Thank you very much!
Main / Discussions / FB Blocking Statistics Search Forum
Navigation: |<   <   1  2 >|  
Poster Message
pete
H2TAGIT4Q

Europe   pete owns a supporter account   pete is a Knight of RedZoneAction.org

Joined: 2011-09-01/S00
Posts: 20495
Top Manager



 
posted: 2018-06-04 18:49:38 (ID: 100129510)  Edits found: 7 Report Abuse
Here you go with a basic interface.

If you are logged in, you can retrieve gamedata except for friendlies, scrimmages and live/all star challenges - or to put it different: public competitions and friendly cup games can be retrieved

https://redzoneaction.org/football/?action=getplaybyplaycsv&matchid=THEMATCHID

Example: https://redzoneaction.org/football/?action=getplaybyplaycsv&matchid=100613814

What you will get:

"matchid","gametype","gameday","hometeam","awayteam","quarter","clock","offenseonfield","homescore","awayscore","oformation","dformation","homeplayers","awayplayers","play"
"100613814","2","2018-06-03 21:00:00","4715","3603","1","900","4715","0","0","","","","","Cointoss won by Kneeling Guinness Drinkers, elects to receive"
"100613814","2","2018-06-03 21:00:00","4715","3603","1","900","4715","0","0","","","k:100667520~gl:100632304~gr:100663118~stt1:100694327~stt2:100759282~stt3:100631438~stt4:100708804~stt5:100663068~stt6:100674560~stt7:100701401~stt8:100673776~","krl:100683562~krr:100710547~stbl1:100649006~stbl2:100699620~stbl3:100716977~stbl4:100742495~stbl5:100716995~stbl6:100731854~stbl7:100742454~stbl8:100698258~stbl9:100697207~","Enzo Sperotto (K) kicks the ball for 66, results in a touchback, offense is on the field now, 1 and 10 on own 20"
"100613814","2","2018-06-03 21:00:00","4715","3603","1","900","3603","0","0","Pro set","4-4-3","der:100712273~del:100676141~dtr:100631438~dtl:100673776~mlb:100625084~mlb1:100701396~olbr:100663118~olbl:100445067~cbr:100632304~cbl:100679483~fsc:100650734~","otl:100649154~otr:100620375~ogl:100703535~ogr:100703718~oc:100708001~wrl:100708614~wrr:100683562~ter:100724838~hbl:100710547~hbr:100755629~qb:100672170~","1 and 10 to go on own 20, Peer Chestnut (OC) snaps the ball to Cetin Hamm (QB), Paride Britt (HB/L) gets the ball, this seems to be a run over the left end, Paride Britt (HB/L) tackled by Quirino Cazzato (DE/L), forward progress: no gain"

You won't get data from games not over (regular gametime)

We log the uerying userid, if we find abuse, the banhammer applies. So, do not fire thousand of request, and make some pause between the single requests.

Can you add multiple matchids to one request? No!

There are IDs in the playbyplay, to find the players, but the forum software is killing the display...you should make you able to parse the involved players...

The clock is in "seconds left for this quarter"


The manual has some more info: https://redzoneaction.org/football/index.php?page=help&subpage=manual&topic=getplaybyplaycsv

Last edited on 2018-06-04 19:20:06 by pete

Quote   Reply   Edit  
PJRAVENS
posted: 2018-06-06 08:50:30 (ID: 100129569) Report Abuse
Thank you very much Pete.
I downloaded only the game you linked, it is enough in order to have am example of this kind of statistics.
Here the results of your FBs

(PlayerID) (Player) (DL Pressure or Blitz) (FB Block Attempts) (Sacks on FB Blok Attempts) (Total Sacks) (Overthrown on FB Block Attempts) (FB Blocks Successful) % Success
100644767 Tino Stäfen 11 10 0 0 3 7 63.64%
100710547 Paride Britt 1 1 0 0 0 1 100.00%
100755629 Kwamie Whyte 6 6 1 1 0 5 83.33%
100767345 Mohammed Swan 6 3 0 0 0 3 50.00%
100777558 Franklyn Garvin 3 3 1 1 1 1 33.33%

I crosschecked the results with the Blocking Statistics on the gamecenter and the difference on block attempts is due your FB/TEs blocked 4 times also in rushing plays.

Here you can find the same analysis for rushing plays.
Can we say that in case of a DL breaks trough or Blitz the FB/TEs blocked successfully if there is no TFL?

Source S28 Elite Playoff
(Oformation) (DL Pressure or Blitz) (FB-TE Block Attempts) (TFL_on_FB-TE_Block_Attempt) (FB-TE Block Successful) (% Success)
Big I formation 8 8 1 7 87.50%
Flexbone 10 3 1 2 20.00%
Goalline O 22 22 5 17 77.27%
I-formation 20 12 5 7 35.00%
Pro set 14 7 1 6 42.86%
Shotgun 2 WR 121 121 22 99 81.82%
Singleback Big 6 6 1 5 83.33%
Wishbone 21 6 3 3 14.29%

Source Friendly Power Mode
(Oformation) (DL Pressure or Blitz) (FB-TE Block Attempts) (TFL_on_FB-TE_Block_Attempt) (FB-TE Block Successful) (% Success)
Big I formation 36 36 6 30 83.33%
Flexbone 14 8 2 6 42.86%
Goalline O 7 7 1 6 85.71%
I-formation 30 24 4 20 66.67%
Pro set 27 14 2 12 44.44%
Shotgun 2 WR 150 150 28 122 81.33%
Singleback Big 3 3 1 2 66.67%
Wishbone 27 10 1 9 33.33%

SB Spread is excluded because there are no FB nor TE
SG4W is excluded because there are no TE and the FB is the ball carrier.

In rushing plays despite have at disposal the list of the player on the field it is not possible going deeper.
In fact in this case for a missing block the guilty could be the FB or the TE or one of the two TE depending of the offensive formation in place.

Consider All the statistics I provided as an example because I used a base of only 12 games (S28 Elite playoff) and 11 games of FC in Power mode more or less 3800 plays.

I do not want to bother you anymore, if you think that in some way new statistics can be useful for you and RZA you have just to ask and I can try to process them.
If you are interested I can also send you the Access database and the code I wrote.
thanks again
pj
Quote   Reply   Edit  
pete
H2TAGIT4Q

Europe   pete owns a supporter account   pete is a Knight of RedZoneAction.org

Joined: 2011-09-01/S00
Posts: 20495
Top Manager



 
posted: 2018-06-06 08:57:56 (ID: 100129571) Report Abuse
Nice piece of work, well done. I really like this stuff. I will have a deeper look at it once I am back from vacation. If you like please free to publish more of it
Quote   Reply   Edit  
pete
H2TAGIT4Q

Europe   pete owns a supporter account   pete is a Knight of RedZoneAction.org

Joined: 2011-09-01/S00
Posts: 20495
Top Manager



 
posted: 2018-06-06 09:01:29 (ID: 100129572) Report Abuse
PJRAVENS wrote:

Can we say that in case of a DL breaks trough or Blitz the FB/TEs blocked successfully if there is no TFL?



I guess this is not fully true. Even if the FB/TE miss their blocks it does not mean the DL was successful in tackling for loss, since he could miss his tackle as well. Did I undertsand you wrong?
Quote   Reply   Edit  
PJRAVENS
posted: 2018-06-06 09:11:15 (ID: 100129574) Report Abuse
this is true
"Even if the FB/TE miss their blocks it does not mean the DL was successful in tackling for loss"
In fact I have counted the FB/TE block as missed only if a TFL happened.
To be honest also in this case it is not fully true because the defensive man who made the TFL could not be the one the TE/FB missed to block

Quote   Reply   Edit  
pete
H2TAGIT4Q

Europe   pete owns a supporter account   pete is a Knight of RedZoneAction.org

Joined: 2011-09-01/S00
Posts: 20495
Top Manager



 
posted: 2018-06-06 09:16:44 (ID: 100129575) Report Abuse
Yes...and we do not have this information in the database, it is just a live decision at simetime, "use it, forget it".
Quote   Reply   Edit  
marinarul10
posted: 2018-06-15 04:20:30 (ID: 100129779) Report Abuse
hollyhh2000 wrote:

=WENN(ISTFEHLER(FINDEN("breaks through";BU91833));0;1)



=WENN(AU91832=1;TEIL(TEIL(BU91832;FINDEN("breaks through";BU91832)-35;35);FINDEN(",";TEIL(BU91832;FINDEN("breaks through";BU91832)-35;35))+2;26-FINDEN(",";TEIL(BU91832;FINDEN("breaks through";BU91832)-35;35)));"")









Well, my friends, this like 1+1=2 right
Quote   Reply   Edit  
jggreen
posted: 2018-06-27 12:27:45 (ID: 100130041) Report Abuse
PJRAVENS wrote:
Thank you very much Pete.
I downloaded only the game you linked, it is enough in order to have am example of this kind of statistics.
Here the results of your FBs

(PlayerID) (Player) (DL Pressure or Blitz) (FB Block Attempts) (Sacks on FB Blok Attempts) (Total Sacks) (Overthrown on FB Block Attempts) (FB Blocks Successful) % Success
100644767 Tino Stäfen 11 10 0 0 3 7 63.64%
100710547 Paride Britt 1 1 0 0 0 1 100.00%
100755629 Kwamie Whyte 6 6 1 1 0 5 83.33%
100767345 Mohammed Swan 6 3 0 0 0 3 50.00%
100777558 Franklyn Garvin 3 3 1 1 1 1 33.33%

I crosschecked the results with the Blocking Statistics on the gamecenter and the difference on block attempts is due your FB/TEs blocked 4 times also in rushing plays.

Here you can find the same analysis for rushing plays.
Can we say that in case of a DL breaks trough or Blitz the FB/TEs blocked successfully if there is no TFL?

Source S28 Elite Playoff
(Oformation) (DL Pressure or Blitz) (FB-TE Block Attempts) (TFL_on_FB-TE_Block_Attempt) (FB-TE Block Successful) (% Success)
Big I formation 8 8 1 7 87.50%
Flexbone 10 3 1 2 20.00%
Goalline O 22 22 5 17 77.27%
I-formation 20 12 5 7 35.00%
Pro set 14 7 1 6 42.86%
Shotgun 2 WR 121 121 22 99 81.82%
Singleback Big 6 6 1 5 83.33%
Wishbone 21 6 3 3 14.29%

Source Friendly Power Mode
(Oformation) (DL Pressure or Blitz) (FB-TE Block Attempts) (TFL_on_FB-TE_Block_Attempt) (FB-TE Block Successful) (% Success)
Big I formation 36 36 6 30 83.33%
Flexbone 14 8 2 6 42.86%
Goalline O 7 7 1 6 85.71%
I-formation 30 24 4 20 66.67%
Pro set 27 14 2 12 44.44%
Shotgun 2 WR 150 150 28 122 81.33%
Singleback Big 3 3 1 2 66.67%
Wishbone 27 10 1 9 33.33%

SB Spread is excluded because there are no FB nor TE
SG4W is excluded because there are no TE and the FB is the ball carrier.

In rushing plays despite have at disposal the list of the player on the field it is not possible going deeper.
In fact in this case for a missing block the guilty could be the FB or the TE or one of the two TE depending of the offensive formation in place.

Consider All the statistics I provided as an example because I used a base of only 12 games (S28 Elite playoff) and 11 games of FC in Power mode more or less 3800 plays.

I do not want to bother you anymore, if you think that in some way new statistics can be useful for you and RZA you have just to ask and I can try to process them.
If you are interested I can also send you the Access database and the code I wrote.
thanks again
pj


It would be nice to see these numbers with Def formation instead of Offense.
Quote   Reply   Edit  
PJRAVENS
posted: 2018-07-02 14:24:00 (ID: 100130184) Report Abuse
Hi jggreen

here below he number you asked (Source S28 Elite Playoff)

Passing plays with offensive formation with a FB and at least a DL that breaks through the line or a blitz

OFormation DFormation DL Pressure or Blitz FB Block Attempts Sacks on FB Blok Attempts Total Sacks Overthrown on FB Block Attempts FB Blocks Successful % Success
Big I formation 3-3-5 1 0 0 0 0 0 0.00%
Big I formation 3-4-4 8 8 0 0 1 7 87.50%
Big I formation 4-4-3 4 3 0 0 0 3 75.00%
Flexbone 3-3-5 1 1 0 0 0 1 100.00%
Flexbone 3-4-4 6 4 0 0 1 3 50.00%
Flexbone 4-4-3 1 0 0 0 0 0 0.00%
Flexbone 5-3-3 1 1 0 0 0 1 100.00%
Flexbone Dime 4DL MLB 4CB 2SF 1 1 1 1 0 0 0.00%
Goalline O 3-3-5 2 1 0 0 0 1 50.00%
Goalline O 3-4-4 12 7 1 1 2 4 33.33%
Goalline O 4-3-4 3 3 0 0 0 3 100.00%
Goalline O 4-4-3 14 9 0 0 1 8 57.14%
Goalline O 5-3-3 2 2 0 0 0 2 100.00%
Goalline O Goalline D 2 2 0 0 0 2 100.00%
I-formation 3-3-5 1 0 0 0 0 0 0.00%
I-formation 3-4-4 18 11 0 1 4 7 38.89%
I-formation 4-4-3 9 7 1 2 0 6 66.67%
I-formation 5-3-3 1 1 0 0 0 1 100.00%
I-formation Dime 4DL MLB 4CB 2SF 1 0 0 0 0 0 0.00%
Shotgun 2 WR 3-3-5 60 60 5 5 6 49 81.67%
Shotgun 2 WR 3-4-4 168 168 12 12 23 133 79.17%
Shotgun 2 WR 4-3-4 3 3 0 0 0 3 100.00%
Shotgun 2 WR 4-4-3 38 38 1 1 1 36 94.74%
Shotgun 2 WR 5-3-3 14 14 0 0 0 14 100.00%
Shotgun 2 WR Goalline D 2 2 0 0 0 2 100.00%
Shotgun 4 WR 3-3-5 143 143 14 14 22 107 74.83%
Shotgun 4 WR 3-4-4 53 53 1 1 6 46 86.79%
Shotgun 4 WR 4-3-4 5 5 0 0 0 5 100.00%
Shotgun 4 WR 4-4-3 23 23 0 0 1 22 95.65%
Shotgun 4 WR 5-3-3 21 21 0 0 3 18 85.71%
Shotgun 4 WR Goalline D 3 3 0 0 2 1 33.33%
Wishbone 3-3-5 3 3 1 1 1 1 33.33%
Wishbone 3-4-4 13 11 2 3 0 9 69.23%
Wishbone 4-4-3 14 9 0 1 3 6 42.86%
Wishbone 5-3-3 4 3 0 0 0 3 75.00%
Wishbone Dime 4DL MLB 4CB 2SF 2 2 0 0 0 2 100.00%
Wishbone Goalline D 2 2 1 1 1 0 0.00%

Running plays with offensive formation with at least a FB or a TE and at least a DL that breaks through the line or a blitz

OFormation DFormation DL Pressure or Blitz Back Block Attempts TFL on Missed Block TFL Back Block Successful % Success
Big I formation 3-4-4 3 3 0 0 3 100.00%
Big I formation 4-4-3 4 4 0 1 4 100.00%
Big I formation 5-3-3 1 1 0 0 1 100.00%
Flexbone 3-4-4 2 0 0 1 0 0.00%
Flexbone 4-4-3 6 3 1 4 2 33.33%
Flexbone 5-3-3 2 0 0 0 0 0.00%
Goalline O 3-3-5 1 1 0 0 1 100.00%
Goalline O 3-4-4 3 3 0 1 3 100.00%
Goalline O 4-4-3 3 3 0 0 3 100.00%
Goalline O 5-3-3 14 14 0 4 14 100.00%
Goalline O Goalline D 1 1 0 0 1 100.00%
I-formation 3-3-5 1 0 0 0 0 0.00%
I-formation 3-4-4 14 8 1 5 7 50.00%
I-formation 4-4-3 4 4 1 1 3 75.00%
I-formation 5-3-3 1 0 0 0 0 0.00%
Pro set 3-3-5 1 1 0 0 1 100.00%
Pro set 3-4-4 7 3 0 0 3 42.86%
Pro set 4-4-3 4 3 0 1 3 75.00%
Pro set 5-3-3 2 0 0 0 0 0.00%
Shotgun 2 WR 3-3-5 14 14 1 3 13 92.86%
Shotgun 2 WR 3-4-4 82 82 1 11 81 98.78%
Shotgun 2 WR 4-4-3 22 22 0 8 22 100.00%
Shotgun 2 WR 5-3-3 3 3 0 0 3 100.00%
Singleback Big 3-4-4 4 4 0 0 4 100.00%
Singleback Big 4-4-3 2 2 0 1 2 100.00%
Wishbone 3-4-4 8 1 0 2 1 12.50%
Wishbone 4-4-3 12 5 0 4 5 41.67%
Wishbone 5-2 1 0 0 0 0 0.00%

Here TFL are the number of TFL while "TFL on Missed Block" is a TFL made by the defensive man that broke the FB/TE back block.
Only this count in the evaluation of he back block efficiency.

I left the offensive formations because I supposed your goal is find the better defensive formation vs offense.
You can easily cancel the offense column and regrouping the numbers if I am wrong.

I know the base is only 11 games and so this in only a raw result.
I will collect more games and provide a new number I hope in the near future

Feel free to ask other statistics.
regards
pj

Quote   Reply   Edit  
reply   Mark this thread unread
Navigation: |<   <   1  2 >|  
Main / Discussions / FB Blocking Statistics