|
New Orleans Team Projections - Week 4 (9/27)
|
SELECT *
FROM players
WHERE (team = 'NO')
ORDER BY #SortOrder# DESC
SELECT SUM(pcmp) AS tot_pcmp, SUM(patt) AS tot_patt, SUM(pyds) AS tot_pyds, SUM(ptds) AS tot_ptds, SUM(Int) AS tot_int, SUM(ratt) AS tot_ratt, SUM(ryds) AS tot_ryds, SUM(rtds) AS tot_rtds, SUM(rec) AS tot_rec, SUM(cyds) AS tot_cyds, SUM(ctds) AS tot_ctds, SUM(pts) AS tot_pts
FROM players
WHERE (team = 'NO')
| Offense: |
QB,
RB,
WR,
TE,
|
| Teams: |
Ari,
Atl,
Bal,
Buf,
Car,
Chi,
Cin,
Cle,
Dal,
Den,
Det,
GB,
Hou,
Ind,
Jac,
KC,
Min,
NE,
NO,
NYJ,
Oak,
Phi,
Pit,
SD,
SF,
StL,
Ten,
Was
|
| Projections - Week 4 (9/27) |
Passing Stats |
Rush Stats |
Receiving Stats |
Fantasy |
| Change |
Name |
Pos |
Opp |
Att |
Comp |
Yds |
TD |
Int |
Att |
Yds |
TD |
Rec |
Yds |
TD |
Pts |
  |
#fname# #lname# |
#pos# |
#opp# |
---#NumberFormat("#patt#", '__,_____')# |
---#NumberFormat("#pcmp#", '__,_____')# |
---#NumberFormat("#pyds#", '__,_____')# |
---#NumberFormat("#ptds#", '__,____._')# |
---#NumberFormat("#int#", '__,____._')# |
---#NumberFormat("#ratt#", '__,_____')# |
---#NumberFormat("#ryds#", '__,_____')# |
---#NumberFormat("#rtds#", '__,____._')# |
---#NumberFormat("#rec#", '__,_____')# |
---#NumberFormat("#cyds#", '__,_____')# |
---#NumberFormat("#ctds#", '__,____._')# |
#NumberFormat("#pts#", '__,_____')# |
| Totals |
#NumberFormat("#tot_patt#", '__,_____')# |
#NumberFormat("#tot_pcmp#", '__,_____')# |
#NumberFormat("#tot_pyds#", '__,_____')# |
#NumberFormat("#tot_ptds#", '__,____._')# |
#NumberFormat("#tot_int#", '__,____._')# |
#NumberFormat("#tot_ratt#", '__,_____')# |
#NumberFormat("#tot_ryds#", '__,_____')# |
#NumberFormat("#tot_rtds#", '__,____._')# |
#NumberFormat("#tot_rec#", '__,_____')# |
#NumberFormat("#tot_cyds#", '__,_____')# |
#NumberFormat("#tot_ctds#", '__,____._')# |
#NumberFormat("#tot_pts#", '__,____._')# |
Offensive Scoring:
1 pt per 20 yards passing
4 pts per passing TD
1 pt per 10 yards rushing/receiving
6 pts per rushing/receiving TD
-1 per interception
Defensive Scoring:
1 pt per tackle
1 pt per assist
5 points per sack
2 pts per interception
1 pt per pass deflection
|
|
