DIR Return Create A Forum - Home
---------------------------------------------------------
PC2019
HTML https://pc2019.createaforum.com
---------------------------------------------------------
*****************************************************
DIR Return to: Help Needed
*****************************************************
#Post#: 2--------------------------------------------------
PC2019 player ratings
DIR By: Grenville
Date: August 31, 2018, 4:39 pm
---------------------------------------------------------
At some point if we have a lot of people working on these we can
convert to a google sheet
to handle live changes etc. For now though its just excel, so
best if we have just one person working on each club.
Instructions:
- grab the spreadsheet.
- so far it has all players who played a game in 2018.
- The script i used to grab them from the web did some rough
guesses based on their stats for the season. Not accurate at
all, just a starting point.
- tab 1 (calculations and lists) is the data for the dropdowns
on the ratings tab, and calculations for position ratings. Dont
change anything here. (useful to look at for reference though)
To build a player:
- go to your club's tab.
- fill in the skills (green). Ratings will calculate from those
- use dropdowns for original club/state
- dont edit anything in blue or grey.
- for adding a new players, you can just add a row. PlayerID can
be generated from any one of a number of online utilities like
this:
HTML https://www.guidgenerator.com/online-guid-generator.aspx
Balance
- first pass through we can just get players roughed in, then
comb through them a few more times as we get closer to release
- As a rule of thumb AFL standard players will rate generally in
the 60-100 range.
- PC2011 distribution looked like this:
HTML https://www.amazon.com/clouddrive/share/Ew0YdEm8Jox2m2nBlDzM1uLZ3006DtBbRsyKQHQ2zfE
#Post#: 3--------------------------------------------------
Re: PC2019 player ratings
DIR By: Grenville
Date: August 31, 2018, 7:01 pm
---------------------------------------------------------
Uploaded sheet to here:
HTML https://www.amazon.com/clouddrive/share/wSrr3rbstwcMzSRhTGUNVvnnwhuNm2BUaClMB5cOYzn
#Post#: 5--------------------------------------------------
Re: PC2019 player ratings
DIR By: Schods
Date: September 1, 2018, 3:31 am
---------------------------------------------------------
I'm just working on draft details/origin club/state at the
moment as well as adding in players that Grenville has left out
that are still currently under contract. Have finished Carlton,
Collingwood and Essendon, about to do North Melbourne.
#Post#: 6--------------------------------------------------
Re: PC2019 player ratings
DIR By: Schods
Date: September 1, 2018, 4:13 am
---------------------------------------------------------
Essendon VFL Side missing from potential Origin Club Name,
recently added to the VFL. Any chance of changing that and
having a former club history to exist (i.e. Franston
Dolphins/Bendigo Bombers in the VFL, NSW-ACT in the TAC Cup)?
Also any chance of creating a Mini-Draft draft option as well as
a Pre-Selection option and a category B rookie option in the
draft section?
#Post#: 7--------------------------------------------------
Re: PC2019 player ratings
DIR By: Grenville
Date: September 1, 2018, 7:38 am
---------------------------------------------------------
Thats great progress, thanks. These will all be highly
subjective and no doubt get plenty of debate, but nice to get
things rolling.
Unfortunately the spreadsheet is too big to attach in the free
forum (512kb limit, and its ~600kb zipped), so emailing it
around it probably quickest option.
I havent touched the VFL club list since i started wirking again
and need to do some updates. If you can email me spreadsheet
with changes (ad@sthcross.com) I'll rework the VFL club list,
update it and upload changes.
Thanks mate
#Post#: 8--------------------------------------------------
Re: PC2019 player ratings
DIR By: TheBeardAmigos
Date: September 1, 2018, 5:22 pm
---------------------------------------------------------
Hey guys,
I have started with Geelong.
Will look to do Port Adelaide/Hawks/Melbourne in the next coming
days
#Post#: 9--------------------------------------------------
Re: PC2019 player ratings
DIR By: haydo
Date: September 1, 2018, 8:42 pm
---------------------------------------------------------
G'day legends!
#Post#: 10--------------------------------------------------
Re: PC2019 player ratings
DIR By: Schods
Date: September 1, 2018, 9:02 pm
---------------------------------------------------------
I have emailed you, Grenville, about the changes I have done to
Collingwood, Carlton, Essendon and North Melbourne. I'll give
Gold Coast a go now.
#Post#: 11--------------------------------------------------
Re: PC2019 player ratings
DIR By: Grenville
Date: September 1, 2018, 9:54 pm
---------------------------------------------------------
Thanks all & G'day Haydo.
I've fixed up the VFL clubs and reserve affiliations. I'll grab
Schods changes from my email,. update the club list and
re-upload so they're up to date.
#Post#: 12--------------------------------------------------
Re: PC2019 player ratings
DIR By: Schods
Date: September 1, 2018, 9:57 pm
---------------------------------------------------------
Grenville, I just completed Gold Coast, I'll send you another
email.
*****************************************************
Page 1 of 7
DIR Next Page