High School Recruiting Spreadsheet v0.55

A hub for everything related to NBA 2K14 modding. Releases, previews, requests, and other modding discussion belongs here.

High School Recruiting Spreadsheet v0.55

Postby Phreezy P on Sun Feb 09, 2014 11:07 am

Image


I have decided to make a spreadsheet that allows you to calculate the chances of your created player making a certain university based off your top 5 stats.

Best paired with the HS Hoops mod (In season or playoff mode or MyCareer [Not sure if supported] and March Madness mod)

I have included just the teams in the March Madness mod as of now.

Current features include (All position based):

  • Recommended Overall Rating calculator
  • Star Rating Calculator
  • Scholarship Checker

Future additions will include:

  • Better formulas for the overall calculations
  • More ratings
  • Location Factor (I.e. star rating if from Canada, Proximity to University etc.)
  • More teams

I need your opinion on the spreadsheet. Let me know if a university is too 'easy' or 'difficult' to join, or the overall ratings are too high or low for a certain position or all. If you have knowledge on formulas and would like to send some of your input to me, that'd be great.

GET IT HERE

High School Recruiting Spreadsheet
LA | TO | MIN
User avatar
Phreezy P
Varsity
 
Posts: 1062
Joined: Tue May 29, 2007 7:26 am
Location: Toronto

Re: High School Recruiting Spreadsheet v0.55

Postby BaldyGotGame10 on Sun Feb 09, 2014 11:26 am

I wish you could make a rating calculator for me based on the formula I'm using to speed this process up!
User avatar
BaldyGotGame10
 
Posts: 136
Joined: Mon Oct 28, 2013 10:20 am

Re: High School Recruiting Spreadsheet v0.55

Postby Phreezy P on Sun Feb 09, 2014 11:37 am

BaldyGotGame10 wrote:I wish you could make a rating calculator for me based on the formula I'm using to speed this process up!


What formula are you talking about?
LA | TO | MIN
User avatar
Phreezy P
Varsity
 
Posts: 1062
Joined: Tue May 29, 2007 7:26 am
Location: Toronto

Re: High School Recruiting Spreadsheet v0.55

Postby TGsoGood on Sun Feb 09, 2014 4:07 pm

glad to see this. I will be posting my work as well later, I decided to focus on
the player's perceived value while still in highschool. My spreadsheet takes
height and position into consideration as well as stats....
Still working on it though
Follow me on PATREON https://www.patreon.com/TGsoGood
Consider donating: http://cash.me/$TheJohnsonFamily or http://paypal.me/4TheGoods
Follow me on twitter @TGsoGood
Check me out on youtube https://www.youtube.com/channel/UCPydhZ ... PeRSmEVynQ

NBA 2K21 TGsoGood Mods and releases - viewtopic.php?f=267&t=110608
NBA 2K17 TGsoGood Mods and releases - viewtopic.php?f=225&t=102251#p1860681
NBA 2K14 TGsoGood Mods and releases - viewtopic.php?f=153&t=96056
User avatar
TGsoGood
Contributor
Contributor
 
Posts: 6433
Joined: Thu Jul 28, 2011 4:03 am
Location: Nashville, TN

Re: High School Recruiting Spreadsheet v0.55

Postby Phreezy P on Sun Feb 09, 2014 4:51 pm

^Nice, can't wait to see it

Heres an example of a new column I added, to represent the people who score 40ppg against crap competition and 20 on high competition. I also changed the way the overall rating is calculated. I used Wiggins Sr Year stats as an example. The overall rating seems correct right now. Not uploaded yet.

Image

Do you think Wiggins-type competition is Mid or High? I could change the algorithm to 'lower the standards' per se. Would High level be considered AAU type stats? Let me know.
LA | TO | MIN
User avatar
Phreezy P
Varsity
 
Posts: 1062
Joined: Tue May 29, 2007 7:26 am
Location: Toronto

Re: High School Recruiting Spreadsheet v0.55

Postby TGsoGood on Sun Feb 09, 2014 8:30 pm

I think the AAU competition is Mid, the game is not as strict as Highschool play is
Follow me on PATREON https://www.patreon.com/TGsoGood
Consider donating: http://cash.me/$TheJohnsonFamily or http://paypal.me/4TheGoods
Follow me on twitter @TGsoGood
Check me out on youtube https://www.youtube.com/channel/UCPydhZ ... PeRSmEVynQ

NBA 2K21 TGsoGood Mods and releases - viewtopic.php?f=267&t=110608
NBA 2K17 TGsoGood Mods and releases - viewtopic.php?f=225&t=102251#p1860681
NBA 2K14 TGsoGood Mods and releases - viewtopic.php?f=153&t=96056
User avatar
TGsoGood
Contributor
Contributor
 
Posts: 6433
Joined: Thu Jul 28, 2011 4:03 am
Location: Nashville, TN

Re: High School Recruiting Spreadsheet v0.55

Postby TGsoGood on Sun Feb 09, 2014 11:59 pm

Image

everything below rivals banners is output
everything above rivals banner is user input
Follow me on PATREON https://www.patreon.com/TGsoGood
Consider donating: http://cash.me/$TheJohnsonFamily or http://paypal.me/4TheGoods
Follow me on twitter @TGsoGood
Check me out on youtube https://www.youtube.com/channel/UCPydhZ ... PeRSmEVynQ

NBA 2K21 TGsoGood Mods and releases - viewtopic.php?f=267&t=110608
NBA 2K17 TGsoGood Mods and releases - viewtopic.php?f=225&t=102251#p1860681
NBA 2K14 TGsoGood Mods and releases - viewtopic.php?f=153&t=96056
User avatar
TGsoGood
Contributor
Contributor
 
Posts: 6433
Joined: Thu Jul 28, 2011 4:03 am
Location: Nashville, TN

Re: High School Recruiting Spreadsheet v0.55

Postby TGsoGood on Mon Feb 10, 2014 11:38 pm

Wow really surprised that there have not been more comments. I will try to upload a video with both spreadsheets
and also try to release my Spreadsheet.

I was planning on adding a GPA column to my spreadsheet. Also I wanted to breakdown the scholarships and show
how many Div I full scholarships and partial scholarships. The GPA could be used to show academic scholarships and
eligibility. This spreadsheet stuff is fun. In college i knew how to write basic programs but I wish I could remember now
I would love to create a program that uses both your recruiting data and my HS awards and ranking data. It would be
similar to leftos' stats tracker tool but Cooler and have a sleek user interface. I guess I'm dreaming right now.

Again I am very thankful for your spreadsheet. :bowdown2: . This almost reminds me of when Jaosming and Leftos were
brainstorming about a way to have storylines outside of the Game. This is sort of like that.
Follow me on PATREON https://www.patreon.com/TGsoGood
Consider donating: http://cash.me/$TheJohnsonFamily or http://paypal.me/4TheGoods
Follow me on twitter @TGsoGood
Check me out on youtube https://www.youtube.com/channel/UCPydhZ ... PeRSmEVynQ

NBA 2K21 TGsoGood Mods and releases - viewtopic.php?f=267&t=110608
NBA 2K17 TGsoGood Mods and releases - viewtopic.php?f=225&t=102251#p1860681
NBA 2K14 TGsoGood Mods and releases - viewtopic.php?f=153&t=96056
User avatar
TGsoGood
Contributor
Contributor
 
Posts: 6433
Joined: Thu Jul 28, 2011 4:03 am
Location: Nashville, TN

Re: High School Recruiting Spreadsheet v0.55

Postby Phreezy P on Tue Feb 11, 2014 5:17 am

That spreadsheet is something else :applaud: , I'm intrigued by your ideas

I haven't been working on it lately because I'm too sick to think. I have some things from BaldyGotGame that I'm going to try and integrate as well.
LA | TO | MIN
User avatar
Phreezy P
Varsity
 
Posts: 1062
Joined: Tue May 29, 2007 7:26 am
Location: Toronto

Re: High School Recruiting Spreadsheet v0.55

Postby Ebraam101 on Tue Feb 11, 2014 11:34 pm

TGsoGood wrote:Image

everything below rivals banners is output
everything above rivals banner is user input

TGsoGOOD, when will you release this amazing piece of work?
xoamberxo222 wrote:"We choose to mod 2k15 and other things not because it is easy, but because it is hard."

Kccitystar wrote:"You underestimate a modder's willpower.
Nothing is a waste of time. Where there is a will, there is a way."
User avatar
Ebraam101
 
Posts: 106
Joined: Mon Mar 25, 2013 7:59 am

Re: High School Recruiting Spreadsheet v0.55

Postby TGsoGood on Tue Feb 11, 2014 11:37 pm

Today, my spreadsheet is being done in excel but you can also open it in Open office calc and it will work.
Also I am trying to finish Converting AirAraron's spreadsheet to excel for those that don't have open office.
Follow me on PATREON https://www.patreon.com/TGsoGood
Consider donating: http://cash.me/$TheJohnsonFamily or http://paypal.me/4TheGoods
Follow me on twitter @TGsoGood
Check me out on youtube https://www.youtube.com/channel/UCPydhZ ... PeRSmEVynQ

NBA 2K21 TGsoGood Mods and releases - viewtopic.php?f=267&t=110608
NBA 2K17 TGsoGood Mods and releases - viewtopic.php?f=225&t=102251#p1860681
NBA 2K14 TGsoGood Mods and releases - viewtopic.php?f=153&t=96056
User avatar
TGsoGood
Contributor
Contributor
 
Posts: 6433
Joined: Thu Jul 28, 2011 4:03 am
Location: Nashville, TN

Re: High School Recruiting Spreadsheet v0.55

Postby Ebraam101 on Tue Feb 11, 2014 11:38 pm

TGsoGood wrote:Today, my spreadsheet is being done in excel but you can also open it in Open office calc and it will work.
Also I am trying to finish Converting AirAraron's spreadsheet to excel for those that don't have open office.

Thanks and I used AirAraron's spreadsheet easily on Excel.
xoamberxo222 wrote:"We choose to mod 2k15 and other things not because it is easy, but because it is hard."

Kccitystar wrote:"You underestimate a modder's willpower.
Nothing is a waste of time. Where there is a will, there is a way."
User avatar
Ebraam101
 
Posts: 106
Joined: Mon Mar 25, 2013 7:59 am

Re: High School Recruiting Spreadsheet v0.55

Postby bigh0rt on Wed Feb 12, 2014 12:06 am

This is really awesome, as I'm viewing it. Haven't had the opportunity to try it out, as I've been spending all my time editing and testing, but it's very, very cool and I hope people use it. (Y)
User avatar
bigh0rt
NLSC Team Member
NLSC Team Member
 
Posts: 9032
Joined: Thu Nov 10, 2005 5:06 pm
Location: New York

Re: High School Recruiting Spreadsheet v0.55

Postby TGsoGood on Wed Feb 12, 2014 3:47 am

HighSchool Ranking Spreadsheet
Image
Link: High School Ranking spreadsheet


I don't mean to keep posting this everywhere. I'm just trying to post the link where it is relevant
Follow me on PATREON https://www.patreon.com/TGsoGood
Consider donating: http://cash.me/$TheJohnsonFamily or http://paypal.me/4TheGoods
Follow me on twitter @TGsoGood
Check me out on youtube https://www.youtube.com/channel/UCPydhZ ... PeRSmEVynQ

NBA 2K21 TGsoGood Mods and releases - viewtopic.php?f=267&t=110608
NBA 2K17 TGsoGood Mods and releases - viewtopic.php?f=225&t=102251#p1860681
NBA 2K14 TGsoGood Mods and releases - viewtopic.php?f=153&t=96056
User avatar
TGsoGood
Contributor
Contributor
 
Posts: 6433
Joined: Thu Jul 28, 2011 4:03 am
Location: Nashville, TN


Return to NBA 2K14 Modding

Who is online

Users browsing this forum: No registered users and 11 guests