Template:Spreadsheet/statsYr: Difference between revisions

From UFFL Wiki
(Created page with "<!--- PASSING STATS ----> {{#get_db_data: db=ufflData |from=PlayerSeasonStats |where= Team='{{{team|}}}' AND Season='{{{season|}}}' AND PassYds <> '0' |limit = 60 |order...")
 
mNo edit summary
Line 6: Line 6:
  |limit = 60
  |limit = 60
  |order by= PassYds DESC
  |order by= PassYds DESC
|data=playerID=PlayerID,team=Team,games=G,gameStarts=GS,passAtt=PassAtt,passComp=PassCmp,passYds=PassYds,passCmpPct=PassPct,longestpass=PassLong,touchdowns=PassTD,interceptions=PassInt,qbrating=PassRating
|data=playerID=PlayerID,team=Team,games=G,gameStarts=GS,passAtt=PassAtt,passComp=PassCmp,passYds=PassYds,passCmpPct=PassPct,longestpass=PassLong,touchdowns=PassTD,interceptions=PassInt,qbrating=PassRating
}}
}}{| style="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 100%" class="wikitable sortable"  
{| style="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 100%" class="wikitable sortable"  
|-
|-
! colspan="12"|{{{season|}}} Passing Statistics
! colspan="12"|{{{season|}}} Passing Statistics
Line 27: Line 26:
|}
|}
{{#clear_external_data:}}
{{#clear_external_data:}}
<!--- RUSHING STATS ---->
<!--- RUSHING STATS ---->{{#get_db_data:
{{#get_db_data:
  db=ufflData
  db=ufflData
  |from=PlayerSeasonStats
  |from=PlayerSeasonStats
Line 34: Line 32:
  |limit = 150
  |limit = 150
  |order by= RushYds DESC
  |order by= RushYds DESC
|data=playerID=PlayerID,team=Team,games=G,rushAtt=RushAtt,rushYds=RushYds,rushAvg=RushAvg,rushLng=RunLong,rushTDs=RushTD,fumbles=Fumbles
|data=playerID=PlayerID,team=Team,games=G,rushAtt=RushAtt,rushYds=RushYds,rushAvg=RushAvg,rushLng=RunLong,rushTDs=RushTD,fumbles=Fumbles
}}
}}{| style="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 100%" class="wikitable sortable"  
{| style="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 100%" class="wikitable sortable"  
|-
|-
! colspan="9"|{{{season|}}} Rushing Statistics
! colspan="9"|{{{season|}}} Rushing Statistics
Line 52: Line 49:
|}
|}
{{#clear_external_data:}}
{{#clear_external_data:}}
<!--- RECEIVING STATS ---->
<!--- RECEIVING STATS ---->{{#get_db_data:
{{#get_db_data:
  db=ufflData
  db=ufflData
  |from=PlayerSeasonStats
  |from=PlayerSeasonStats
Line 59: Line 55:
  |limit = 150
  |limit = 150
  |order by= RecYds DESC
  |order by= RecYds DESC
|data=playerID=PlayerID,team=Team,games=G,recAtt=Catches,recYds=RecYds,recAvg=RecAvg,recLng=RecLong,recTDs=RecTD,fumbles=Fumbles
|data=playerID=PlayerID,team=Team,games=G,recAtt=Catches,recYds=RecYds,recAvg=RecAvg,recLng=RecLong,recTDs=RecTD,fumbles=Fumbles
}}
}}{| style="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 100%" class="wikitable sortable"  
{| style="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 100%" class="wikitable sortable"  
|-
|-
! colspan="9"|{{{season|}}} Receiving Statistics
! colspan="9"|{{{season|}}} Receiving Statistics
Line 77: Line 72:
|}
|}
{{#clear_external_data:}}
{{#clear_external_data:}}
<!--- DEFENSIVE PLAYER STATS ---->
<!--- DEFENSIVE PLAYER STATS ---->{{#get_db_data:
{{#get_db_data:
  db=ufflData
  db=ufflData
  |from=PlayerSeasonStats
  |from=PlayerSeasonStats
  |where= Team='{{{team|}}}' AND Season='{{{season|}}}' AND Tackles <> '0'
  |where= Team='{{{team|}}}' AND Season='{{{season|}}}' AND Tackles <> '0'
  |order by= Tackles DESC
  |order by= Tackles DESC |data=playerID=PlayerID,team=Team,games=G,tackles=Tackles,tackles4Loss=TFL,forcedFum=ForcedFumbles,fumRec=FumblesRecovered,sacks=Sacks,interceptions=Ints,passDef=PassesDefensed,safeties=Safeties,defTDs=DefensiveTD,blockpunt=BlockedPunt,blockfg=BlockedFG,blockxp=BlockedPAT
|data=playerID=PlayerID,team=Team,games=G,tackles=Tackles,tackles4Loss=TFL,forcedFum=ForcedFumbles,fumRec=FumblesRecovered,sacks=Sacks,interceptions=Ints,passDef=PassesDefensed,safeties=Safeties,defTDs=DefensiveTD,blockpunt=BlockedPunt,blockfg=BlockedFG,blockxp=BlockedPAT
}}{| style="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 100%" class="wikitable sortable"  
}}
{| style="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 100%" class="wikitable sortable"  
|-
|-
! colspan="12"|{{{season|}}} Defensive Statistics
! colspan="12"|{{{season|}}} Defensive Statistics
Line 104: Line 96:
|}
|}
{{#clear_external_data:}}
{{#clear_external_data:}}
<!--- DEFENSIVE PLAYER STATS ---->
<!--- DEFENSIVE PLAYER STATS ---->{{#get_db_data:
{{#get_db_data:
  db=ufflData
  db=ufflData
  |from=PlayerSeasonStats
  |from=PlayerSeasonStats
Line 111: Line 102:
  |order by= Pancakes DESC
  |order by= Pancakes DESC
  |data=playerID=PlayerID,team=Team,games=G,pancakes=Pancakes,sacksAlwd=SacksAllowed
  |data=playerID=PlayerID,team=Team,games=G,pancakes=Pancakes,sacksAlwd=SacksAllowed
}}
}}{| style="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 100%" class="wikitable sortable"  
{| style="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 100%" class="wikitable sortable"  
|-
|-
! colspan="12"|{{{season|}}} Offensive Line Statistics
! colspan="12"|{{{season|}}} Offensive Line Statistics
Line 124: Line 114:
|}
|}
{{#clear_external_data:}}
{{#clear_external_data:}}
<!--- KICKING STATS ---->
<!--- KICKING STATS ---->{{#get_db_data:
{{#get_db_data:
  db=ufflData
  db=ufflData
  |from=PlayerSeasonStats
  |from=PlayerSeasonStats
  |where= Team='{{{team|}}}' AND Season='{{{season|}}}' AND KickingPoints <> '0'
  |where= Team='{{{team|}}}' AND Season='{{{season|}}}' AND KickingPoints <> '0'
  |order by= XPM DESC
  |order by= XPM DESC |data=playerID=PlayerID,team=Team,games=G,xpmade=XPM,xpatt=XPA,xppct=XPPct,fgmade=FGM,fgatt=FGA,fgpct=FGPct,fgm020=FGM_U20,fga020=FGA_U20,fgm2029=FGM_2029,fga2029=FGA_2029,fgm3039=FGM_3039,fga3039=FGA_3039,fgm4049=FGM_4049,fga4049=FGA_4049,fgm50plus=FGM_50,fga50plus=FGA_50,fglong=FGLong,points=KickingPoints
|data=playerID=PlayerID,team=Team,games=G,xpmade=XPM,xpatt=XPA,xppct=XPPct,fgmade=FGM,fgatt=FGA,fgpct=FGPct,fgm020=FGM_U20,fga020=FGA_U20,fgm2029=FGM_2029,fga2029=FGA_2029,fgm3039=FGM_3039,fga3039=FGA_3039,fgm4049=FGM_4049,fga4049=FGA_4049,fgm50plus=FGM_50,fga50plus=FGA_50,fglong=FGLong,points=KickingPoints
}}{| style="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 100%" class="wikitable sortable"  
}}
{| style="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 100%" class="wikitable sortable"  
|-
|-
! colspan="16"|{{{season|}}} Kicking Statistics
! colspan="16"|{{{season|}}} Kicking Statistics
Line 155: Line 142:
|}
|}
{{#clear_external_data:}}
{{#clear_external_data:}}
<!--- PUNTING STATS ---->
<!--- PUNTING STATS ---->{{#get_db_data:
{{#get_db_data:
  db=ufflData
  db=ufflData
  |from=PlayerSeasonStats
  |from=PlayerSeasonStats
  |where= Team='{{{team|}}}' AND Season='{{{season|}}}' AND Punts <> '0'
  |where= Team='{{{team|}}}' AND Season='{{{season|}}}' AND Punts <> '0'
  |order by= Punts DESC
  |order by= Punts DESC
|data=playerID=PlayerID,team=Team,games=G,punts=Punts,puntYds=PuntYds,puntAvg=PuntAvg,inside20=PuntsInside20,puntLng=PuntLong
|data=playerID=PlayerID,team=Team,games=G,punts=Punts,puntYds=PuntYds,puntAvg=PuntAvg,inside20=PuntsInside20,puntLng=PuntLong
}}
}}{| style="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 100%" class="wikitable sortable"  
{| style="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 100%" class="wikitable sortable"  
|-
|-
! colspan="8"|{{{season|}}} Punting Statistics
! colspan="8"|{{{season|}}} Punting Statistics
Line 178: Line 163:
|}
|}
{{#clear_external_data:}}
{{#clear_external_data:}}
<!--- SPECIAL TEAMS STATS ---->
<!--- SPECIAL TEAMS STATS ---->{{#get_db_data:
{{#get_db_data:
  db=ufflData
  db=ufflData
  |from=PlayerSeasonStats
  |from=PlayerSeasonStats
  |where= Team='{{{team|}}}' AND Season='{{{season|}}}' AND(KickoffReturns <> '0' OR PuntReturns <> '0')
  |where= Team='{{{team|}}}' AND Season='{{{season|}}}' AND(KickoffReturns <> '0' OR PuntReturns <> '0')
  |order by= KickReturnAvg DESC
  |order by= KickReturnAvg DESC
|data=playerID=PlayerID,team=Team,games=G,kickRet=KickoffReturns,kickRetYds=KickoffReturnYds,kickRetAvg=KickReturnAvg,kickretlng=KRLong,kickretTDs=KickoffReturnTD,puntRet=PuntReturns,puntRetYds=PuntReturnYds,puntRetAvg=PuntReturnAvg,puntRetLng=PRLong,puntRetTDs=PuntReturnTD
|data=playerID=PlayerID,team=Team,games=G,kickRet=KickoffReturns,kickRetYds=KickoffReturnYds,kickRetAvg=KickReturnAvg,kickretlng=KRLong,kickretTDs=KickoffReturnTD,puntRet=PuntReturns,puntRetYds=PuntReturnYds,puntRetAvg=PuntReturnAvg,puntRetLng=PRLong,puntRetTDs=PuntReturnTD
}}
}}{| style="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 100%" class="wikitable sortable"  
{| style="border:0; font-size:12px; cellpadding:0.5; cellspacing:0.5; width: 100%" class="wikitable sortable"  
|-
|-
! colspan="13"|{{{season|}}} Special Teams Statistics
! colspan="13"|{{{season|}}} Special Teams Statistics

Revision as of 03:58, 27 June 2021

Passing Statistics
Name Team G GS PA PC Yds % Lng TD Int Rating
Rushing Statistics
Name Team G Att Yds Avg Lng TD Fum
Receiving Statistics
Name Team G No Yds Avg Lng TD Fum
Defensive Statistics
Name Team G Tck TFL FF/FR Sck Int PD Sfty TD Blk P/XP/FG
Offensive Line Statistics
Name Team G Pancakes Sacks Allowed
Kicking Statistics
Name Team G XPM XPA XP% FGM FGA FG% <20 20-29 30-39 40-49 50+ Lng Pts
Punting Statistics
Name Team G Punts Yds Avg Inside 20 Long
Special Teams Statistics
Name Team G KR KR Yds KR Avg KR Lng KR TD PR PR Yds PR Avg PR Lng PR TD
Retrieved from "https://unitedfurryfootball.com/wiki/index.php?title=Template:Spreadsheet/statsYr&oldid=325"