<div align="center">Simulation Hockey League Historic Preservation Organization!


Who Am I Looking For?
I'm looking for highly motivated individuals to help complete this project up to S9. I need these to be done before the end of September or you will not get paid the $5M offered for your services.

What do you have to do?
Since the sim is challenged in terms of recording our leagues player history and history in general is either left out or incorrectly calculated. That means this has to be manually done if we want to preserve many of the historical feats our players work so hard to achieve.

What is this for?
Career Stats Center: http://theshl.b1.jcink.com/index.php?showt...=0&#entry215835

Work load?
A lot of repetitive number crunching (At least until we get EVERY player created and up to date). About half the teams are finished at this point up to S9 rosters.

How do I apply?
Send me a PM and let me know which team you're interested in doing and why you are a good choice to complete this project in a timely fashion.</div>

<div align="left">Open Team Scribes

Ask

:kings:

:thunder: NEW
McBride

Retired/Inactives
</div>

---------------------------------------------


How do I know what to do if I get the job?
I created a handy How to guide showing you how to correctly format, input and succeed as a SHL Scribe. You got this bro, I have the faith. You can check out the guide below, I will share it with everyone.

<div align="center">How-to Scribe</div>

1. Adding Player Pages
On each team page you will notice a player template and goalie template. Right click on the page title at the bottom, select Duplicate Page. Rename it with the player you are adding.

2. Player Formulas (Do not need to change)
For Skaters - PTS, Shooting %, Face offs Total are all formulas and should not be touched.
For Goalies - Save %, Goals Against Average, and Penalty Shot Saves are all formulas and should not be touched.

3. Awards & All-Star Appearances
For Awards - If the player has earned any of the official SHL awards they should be written down. (Ex. S5 Sarmad Khan Trophy, S3 Mike Honcho Trophy)

<div align="center">SHL Award History Thread
NWJHL Award History Thread</div>
For All-Star Appearances - If the player made an appearance in any all-star game record it. (Ex. S1 All-Star, S5 All-Star)

<div align="center">Spreadsheet Formating</div>

3a. Adding Rows
You will need to add a row each new season that player has played. To add a row click on the row in which you want to add a row underneath, select 'insert 1 below'.

3b. Junior Seasons
All NWJHL Seasons should be noted in the Seasons column and the entire row of statistics should be italicized.

3c. TOTALS
At the bottom of both playoffs and regular season the total career stats are calculated, these are all formulas and should not be changed. In the case of needing to add another row to the formula you have 2 options:

1) Click on the cell in the 'TOTAL' row that needs to be changed, a green highlight will show up around the cells in the range that are used in the formula. Click and hold the bottom right corner of the last cell in the formula and drag it down to the new row, hit enter.

2) Click on the cell in the 'TOTAL' row that needs to be changed, in the text box near the top change the range in which the cells show. Example: =SUM(C9:C13) -> =SUM(C9:C14).

3d. Colors
Every other row should be shaded (Third color box from the top right, a light gray). This makes it easier to view the stats from season to season.

Formatting is based off of NHL.com player stat pages. http://www.nhl.com/ice/player.htm?id=84741...id=nhl-keymatch

4. Column/Row sizes
All Rows: Size 17
Column - Season: 80
Column - Team: 200
Column - Stats: 40
Columns - Goalies GAA, SV%, PSS: 55
Columns Special - Skaters Shot %: 50


<div align="center">Resources</div>
Bookmarks
Whatever browser you use it would be beneficial to create a folder in your bookmarks specifically for working on player stats. I created one for myself and here are the links I have saved within the folder to easily jump season to season for statistics. I recommend following each link and bookmarking them into your created folder, it will save you time and frustration.

SHL Stats
S1-S5 Menu - http://z7.invisionfree.com/The_SHL/index.php?showforum=3
S6-S8 Menu - http://theshl.b1.jcink.com/index.php?showforum=15

S1 - http://shlgames.webs.com/inidvidualstatsbyteam.htm
S2 - http://simulationhockeyleague.webs.com/Sea...eamScoring.html
S3 - http://simulationhockey.webs.com/Season%20...eamScoring.html
S4 - http://simulationhockey.webs.com/Season%20...eamScoring.html
S5 - http://simulationhockey.webs.com/Season%20...l#STHSRosterTop
Be Aware: S5 Vancouver (half), West Kendall, Winnipeg Jets stats are missing, output error which cuts off those last two teams.
S6 - http://dar1.webs.com/Season%206/SHL1-ProTeamScoring.html
S7 - http://simulationhockey.webs.com/Season7/S...eamScoring.html
S8 - http://simulationhockey.webs.com/Season%20...eamScoring.html

S1 Playoffs - http://shlgames5.webs.com/playoffteamscoring.htm
S2 Playoffs - http://simulationhockeyleague.webs.com/Sea...eamScoring.html
S3 Playoffs - http://simulationhockey.webs.com/Season%20...eamScoring.html
S4 Playoffs - http://simulationhockey.webs.com/Season%20...eamScoring.html
S5 Playoffs - http://simulationhockey.webs.com/SHL1-PLF-...eamScoring.html
S6 Playoffs - http://simulationhockey.webs.com/Season%20...eamScoring.html
S7 Playoffs - http://simulationhockey.webs.com/Season%20...eamScoring.html
S8 Playoffs - http://simulationhockey.webs.com/Season%20...eamScoring.html

Entry Drafts - http://theshl.b1.jcink.com/index.php?showforum=28

NWJHL (Old Site) - http://z7.invisionfree.com/The_SHL/index.php?showforum=125

Player Finding
When searching for the player it is helpful to use the find feature. Hit Control+F and copy the players name, it will highlight that text found on the webpage.

-----------------------------------------------------------------------------------------------------------------
Ryan Jesster - HoF Goalie (S1-S14)
Proud Calgary Dragon Alumni 
----------------------------------------------------------------------------------------------------------------

| |

omg my head hurts

If you need I could probably take on another team.

Originally posted by DylanJK@Sep 5 2012, 01:00 AM
omg my head hurts

Then this job is not for you cockroach!

Kidding. I need help guys, its big pay. $5,000,000 smackers. Half teams are finished and I want to get this streamlined into one incredibly awesome epic collection (Well two, actively playing and retired players) spreadsheets where anyone can view any current players career. Hopefully eventually tie it into a website of sorts but for now the spreadsheets are still might kick ass!

-----------------------------------------------------------------------------------------------------------------
Ryan Jesster - HoF Goalie (S1-S14)
Proud Calgary Dragon Alumni 
----------------------------------------------------------------------------------------------------------------

| |

Originally posted by mexico.27@Sep 5 2012, 01:04 AM
If you need I could probably take on another team.

You did a great job with the Jets so I'm all for it. Let me just see if theres enough interest out there for anyone else to get a chance to make that $5M first. I will let you know tomorrow Mexico, Thank you.

-----------------------------------------------------------------------------------------------------------------
Ryan Jesster - HoF Goalie (S1-S14)
Proud Calgary Dragon Alumni 
----------------------------------------------------------------------------------------------------------------

| |

Originally posted by Jesster@Sep 5 2012, 01:05 AM


You did a great job with the Jets so I'm all for it.&nbsp; Let me just see if theres enough interest out there for anyone else to get a chance to make that $5M first.&nbsp; I will let you know tomorrow Mexico, Thank you.

Alright Captain sounds good.

Where exactly are you putting all these numbers. I can number crunch, just no fuckin clue what you actually want done.

Originally posted by MacDaddy@Sep 5 2012, 01:20 AM
Where exactly are you putting all these numbers. I can number crunch, just no fuckin clue what you actually want done.

http://theshl.b1.jcink.com/index.php?showt...=0&#entry215835

-----------------------------------------------------------------------------------------------------------------
Ryan Jesster - HoF Goalie (S1-S14)
Proud Calgary Dragon Alumni 
----------------------------------------------------------------------------------------------------------------

| |

I can't spam a Jesster thread sorry. so just:



<div align="center">
</div>