Virtual Canadian Football League (VCFL) 2007

[ohcanada]

The only way I've been able to extract stats is by using excel.

I copy and paste the HTML output and then I can manipulate it in excel.

It takes a bit of time to set up, but once its done, it is very easy to use.

If I could figure out how to post an attachment I could show you an example.

Rick

[Mykal]

like this Rick

[mbsports]

Yeah I do the same thing, you grab the html file, copy it into excel and then it's somewhat usable.
 
What I do then is that I bring it back into access to create some additional things.  The SQL/PHP I'm using also does some of that - here's an example of a player page. http://www.mbsportsnet.com/cfl_player.php?id=4794&skin=default
 
I bring it into Access then kick it back out into an excel sheet with the sql query built in so that I can use MySQL to import the data.  This worked pretty good in the off-season I was able to do it in a day, but when I try to do it every week I would love to have a single source instead of having to go thru a 20 step process.
 
I also need to figure out how to bump the ratings over so that they lineup properly, I've been playing with that for a few days. 

The other thing is just the lack of stats that are pumped out such as yards after catch, drops, blocked kicks, kickoff yardage, touchbacks, and any sort of blocking whatsoever.
 
The stats output is a total mess right now - what we need is a way to convert this
1:0/2:0/3:0/4:0/5:0/6:0/7:0/8:0/9:0/10:0/11:0/12:0/
into columns where you'd have 1 in the first column 0 in the second 2 and 0 and 3 and 0 etc. etc.
 
Thinking about it in a CSV world you'd want the : and / to both become deliminators and then put it all in it's own columns.  Once that would be completed it would be a ton easier to make custom consistent reports and output.
 
I have to admit my Macro writing in Access is awful right now, but I don't see anything coming from MaxFB any time soon to address this so I guess I'll have to start on it.  I'm going to move this part of the conversation over to the 3rd Party Developers Section and will see if we can get some takers on working on this issue.
 
 
 
 

[VCFL Commish]

Trevor - I think at this time it would be best to put everything on hold. You've got enough things going on in your life that need attention. The lack of participation from some managers is a concern for me.

 
Rick the league has been around since 2001.We have had 1 18 team tournament.We then went down to a 8 team league.If anything in all this time I have learned about this game is that there will be change.You could wait another 2 years and there would still be some new update thats going to make it better.So no I don`t want to hold off on another season part of the problem has been these stops while new updates.
 

1) Use season one as a testing ground to determine how functional the game really is

 
This is the third competition every competition is a test.
 

2) Fill in remaining roster spots randomly and ignore salary cap for season one

 
There is one more round in the entry draft with rosters to be filled in.Salary cap will be in effect.
http://ca.geocities.com/football_canadian/VCFL2007/VCFL_ATL.html
This is a sample of the roster html a little easier to view.
 

3) Implement an easy method of setting up lineups (excel works)

 
For this season the games system will have to do.
 

4) Get the season started

Season will start on the 21st of July 2008.Your draft choice has to be in Friday.With roster cut down on the 20th.
 

1) Organize the league rules completely

http://ca.geocities.com/football_canadian/VCFL2007/VCFLRegulations.htm
http://ca.geocities.com/football_canadian/VCFL2007/VCFLSalaryRules.htm
http://ca.geocities.com/football_canadian/VCFL2007/VCFLCharter.htm
 

2) Prepare proper draft lists (free agent and college) for upcoming season and a set number of rounds

As with the roster page that will be done.
 

3) Implement a salary cap and import ratio

 
Salary cap 3,800,00 / 20 imports 42 man roster.
 

4) Structure league where all participating teams are managed

That would be in a perfect world.Were always goung to have open teams its the nature of the online leagues turnover is always there.2007 season will be a set up to 2008.Well thats the best I can do play if you want because you are more then welcome.
 
 
 
 
 

[Mykal]

Well Thank Jah for that

Like I said previously, I would hate to see the VCFL disappear
at last some order established.

[Mykal]

There is one more round in the entry draft with rosters to be filled in.Salary cap will be in effect.
http://ca.geocities.com/football_canadi ... L_ATL.html
This is a sample of the roster html a little easier to view.

Now thats alot crisper, excellent

[Brodie]

Looks good how did you do the roster pages?

[ohcanada]

Hey Trevor,

This is your league and I'm only trying to help or suggest.

Right off the bat you mention about drafting one more round. Now, some rosters will not meet minimum roster requirements. I assume that you will manually fill all remaining vacant spots??

Also check your PM. Five players listed on the free agent list and draft list are already on teams.....

I'll send in my draft pick and then you let me know what needs to be done next.

If you want to do this right I would not rush the season. However, I'm ready to go as is, since this is your wish..

Rick

ORIGINAL: VCFL Commish

Trevor - I think at this time it would be best to put everything on hold. You've got enough things going on in your life that need attention. The lack of participation from some managers is a concern for me.

Rick the league has been around since 2001.We have had 1 18 team tournament.We then went down to a 8 team league.If anything in all this time I have learned about this game is that there will be change.You could wait another 2 years and there would still be some new update thats going to make it better.So no I don`t want to hold off on another season part of the problem has been these stops while new updates.

1) Use season one as a testing ground to determine how functional the game really is

This is the third competition every competition is a test.

2) Fill in remaining roster spots randomly and ignore salary cap for season one

There is one more round in the entry draft with rosters to be filled in.Salary cap will be in effect.
http://ca.geocities.com/football_canadian/VCFL2007/VCFL_ATL.html
This is a sample of the roster html a little easier to view.

3) Implement an easy method of setting up lineups (excel works)

For this season the games system will have to do.

4) Get the season started

Season will start on the 21st of July 2008.Your draft choice has to be in Friday.With roster cut down on the 20th.

1) Organize the league rules completely

http://ca.geocities.com/football_canadian/VCFL2007/VCFLRegulations.htm
http://ca.geocities.com/football_canadian/VCFL2007/VCFLSalaryRules.htm
http://ca.geocities.com/football_canadian/VCFL2007/VCFLCharter.htm

2) Prepare proper draft lists (free agent and college) for upcoming season and a set number of rounds

As with the roster page that will be done.

3) Implement a salary cap and import ratio

Salary cap 3,800,00 / 20 imports 42 man roster.

4) Structure league where all participating teams are managed

That would be in a perfect world.Were always goung to have open teams its the nature of the online leagues turnover is always there.2007 season will be a set up to 2008.Well thats the best I can do play if you want because you are more then welcome.

[ohcanada]

Hey Mykal,

Works for pictures only...can't upload PDF or Excel files....

Thanks anyway,
Rick

ORIGINAL: Mykal

like this Rick

[Mykal]

Take a screen capture first, of what it is you want to show everyone
save it as jpeg and post it

[Mykal]

ORIGINAL: ohcanada

Hey Trevor,

This is your league and I'm only trying to help or suggest.

Right off the bat you mention about drafting one more round. Now, some rosters will not meet minimum roster requirements. I assume that you will manually fill all remaining vacant spots??

Also check your PM. Five players listed on the free agent list and draft list are already on teams.....

I'll send in my draft pick and then you let me know what needs to be done next.

If you want to do this right I would not rush the season. However, I'm ready to go as is, since this is your wish..

Rick

There are also a couple of players who have doubles
that is there in the DB twice, same name, height,wieght, college etc.
just so you know.

[VCFL Commish]

FREE AGENT LIST:
272 - R. Spencer DL
311 - J. *Jackson QB
343 - T. *White QB
DRAFT LIST:
66 - R. *Williams LB
82 - K. *Johnson WR
147 - J. *Jackson LB
196 - J. *Johnson DB
 
These players are doubled so they will be removed next update.I wii check through the db for any more.

[VCFL Commish]

VCFL Jul 19th 2008 will be the latest
version of the league file when you look
at when its loaded by the game.
I was going to get rid of the duplicates
when I updated the rosters but since there
was no updated rosters i will wait till Fridays
roster send ins to make changes.
Friday July 25th 2008 will be when rosters must meet
VCFL requirements.Failure to do so will result in the
league releasing or allocating players to those teams to
make them ready for the 2007 season.
I suggest playing with your roster against another VCFL
team during this week to get use to feel of your team.

[Brodie]

Trevor little confussing here about the VCFL is it still ago it looks like Ottawa and Yellowknife are gone but there still listed.Just curious because the CFC seems to be in the tank to.I was wondering if the VCFL is not ago maybe we could combine the CFC and RCSL to form a league.Let me know

[ohcanada]

Well the Ottawa franchise has not quit. In fact, I'm waiting for the Commish to fill my roster, and get the season started.

I got lost awhile back after my computer problems. Now, I'm not sure who to draft, what's available and the like.

I offered a solution and tried to help the commish, but he indicated that he had things under control, and as such I've left it up to him.

So, Commish, fill in my roster spots as required and lets get this season (league) started.

I'm ready!!!!!

Rick
Ottawa

[VCFL Commish]

The new file should be ready for Saturday.Got in late so tommorrow for sure

[VCFL Commish]

http://ca.geocities.com/football_canadian/VCFLStats/A_GO.html
 
Red Button league files.Didn`t get a chance to update the web pages yet but the file is availiable.

[VCFL Commish]

Roster pages updated
 
 
New page added for the league time table for this week only no signing period have your depth charts updated for Wednesday 8 pm Atlantic

[ohcanada]

Hey Commish,

I've set my depth charts for all positions. Do I have to send you the league file??

Rick
Ottawa

ORIGINAL: VCFL Commish

Roster pages updated


New page added for the league time table for this week only no signing period have your depth charts updated for Wednesday 8 pm Atlantic

[VCFL Commish]

football_canadian@yahoo.co.uk
 
Zip the whole DB and send it back to me