|
New England Team Projections - July 27th
|
SELECT *
FROM players
WHERE (team = 'NE')
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 = 'NE')
| Offense: |
QB,
RB,
WR,
TE,
PK,
Def/ST
|
| Teams: |
Ari,
Atl,
Bal,
Buf,
Car,
Chi,
Cin,
Cle,
Dal,
Den,
Det
GB,
Hou,
Ind,
Jac,
KC,
Mia
Min,
NE,
NO,
NYG,
NYJ
Oak,
Phi,
Pit,
SD,
SF,
Sea,
StL,
TB,
Ten,
Was
|
| Defense: |
DB,
DL,
LB
|
| Projections (7/27/03) |
Passing Stats |
Rush Stats |
Receiving Stats |
Fantasy |
| Change |
Name |
Pos |
Att |
Comp |
% |
Yds |
TD |
Int |
Att |
Yds |
TD |
Rec |
Yds |
TD |
Pts |
  |
#fname# #lname# |
#pos# |
---#NumberFormat("#patt#", '__,_____')# |
---#NumberFormat("#pcmp#", '__,_____')# |
---#NumberFormat("#evaluate(100*pper)#", '_____._')#% |
---#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("#evaluate(100*tot_pcmp/tot_patt)#", '_____._')#% |
#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
|
|
