Home

Dynasty Spreadsheets

This is a discussion on Dynasty Spreadsheets within the NCAA Football forums.

Go Back   Operation Sports Forums > Football > NCAA Football
FIFA 21 Review
Tennis World Tour 2 Review
Doug Flutie's Maximum Football 2020 Review
Poll: Which next-gen console are you going to purchase? (Click to vote)
Reply
 
Thread Tools
Old 08-09-2017, 12:41 PM   #1
Rookie
 
OVR: 0
Join Date: Jan 2013
Location: Nebraska
Dynasty Spreadsheets

Hey Guys,

I've seen this thread before, but it's not active so might as well start a new one. Who all uses a spreadsheet to keep track of their dynasty? I just built a new one so if anyone needs a template, let me know. Also, if you post links I can go ahead and update this OP and get you guys some views on them.

Feedback would be appreciated to help out the community as much as you can! Also, I might go start a dynasty over on the specific forum for that but I'll keep you guys updated!

huskerfan01: Marshall Thundering Herd
__________________
The Depth Chart post is Page 144, #1151 (LINK)
...................
Want to help find official depth charts for Week 1? Please fill out the Google Form in the link above.

Nebraska Cornhuskers
huskerfan01 is offline  
Reply With Quote
Advertisements - Register to remove
Old 08-09-2017, 12:55 PM   #2
Rookie
 
OVR: 0
Join Date: May 2017
Re: Dynasty Spreadsheets

I'll take a look at one!! I use a spreadsheet to keep track of my recruiting, and dynasty but not very detailed on the dynasty...I'd like to see what you got...


#GBR baby!!!!!!!!!!!
AKEjcl41 is offline  
Reply With Quote
Old 08-09-2017, 12:59 PM   #3
MVP
 
whughes's Arena
 
OVR: 0
Join Date: Jul 2012
Location: Michigan
Re: Dynasty Spreadsheets

I've been using Jello's for around 15 seasons now across 2 dynasties and I love it.m
__________________
Check out my dynasty thread:
http://www.operationsports.com/forum...post2047930775

Fan of:
Chicago Bears
U of M Wolverines
CMU Chippewas


whughes is offline  
Reply With Quote
Old 08-09-2017, 04:44 PM   #4
Rookie
 
FarFromEer's Arena
 
OVR: 0
Join Date: May 2014
Location: Atlanta, GA
Posts: 214
Re: Dynasty Spreadsheets

Here's mine. I'm in the middle of starting my dynasty over (again), so it reflects a previous dynasty setup.

My spreadsheet began as a way to speed up recruiting, but grew into a much bigger ordeal. I use Skulletor's DB editor's File->Dump Tables to quickly export all of the dynasty tables, then use the import feature of Excel to populate the spreadsheets in the Data Builders folder. From there, it's copy and paste into the RecruIQ spreadsheet.

https://drive.google.com/open?id=0B7...21DSFhjRjJYdEU
FarFromEer is offline  
Reply With Quote
Old 08-09-2017, 11:32 PM   #5
Fan of real schools
 
Hellisan's Arena
 
OVR: 19
Join Date: Jul 2002
Location: San Diego
Posts: 1,746
Blog Entries: 8
Re: Dynasty Spreadsheets

I use several, but they're a mess and I should probably coalesce them.

I noticed your recruiting rules. I totally agree with the liberal allowance of recruiting 3-star guys for 2-star and up. They screwed up and 3-star is largely 2-star players, like half of it. The 2-star pool is WAY too small. For this reason I divided the 3-stars essentially in half every year and fibbed about 2-star/3star to some extent. Just random thought you didn't ask for.
Hellisan is offline  
Reply With Quote
Advertisements - Register to remove
Old 08-10-2017, 12:47 PM   #6
Pro
 
Heyuimintojsus's Arena
 
OVR: 8
Join Date: Nov 2004
Location: Mississippi
Re: Dynasty Spreadsheets

Quote:
Originally Posted by huskerfan01
Hey Guys,

I've seen this thread before, but it's not active so might as well start a new one. Who all uses a spreadsheet to keep track of their dynasty? I just built a new one so if anyone needs a template, let me know. Also, if you post links I can go ahead and update this OP and get you guys some views on them.

Feedback would be appreciated to help out the community as much as you can! Also, I might go start a dynasty over on the specific forum for that but I'll keep you guys updated!

huskerfan01: Marshall Thundering Herd
Interesting. Looks like a lot of busy work? How does the random.org thing work?
Heyuimintojsus is offline  
Reply With Quote
Old 08-10-2017, 08:37 PM   #7
Rookie
 
OVR: 0
Join Date: Jan 2013
Location: Nebraska
Re: Dynasty Spreadsheets

Quote:
Originally Posted by AKEjcl41
I'll take a look at one!! I use a spreadsheet to keep track of my recruiting, and dynasty but not very detailed on the dynasty...I'd like to see what you got...


#GBR baby!!!!!!!!!!!
Gonna be an interesting year with new system on D and new QB.

Quote:
Originally Posted by whughes
I've been using Jello's for around 15 seasons now across 2 dynasties and I love it.m
Mind sharing it?

Quote:
Originally Posted by mcfeenathan
Here's mine. I'm in the middle of starting my dynasty over (again), so it reflects a previous dynasty setup.

My spreadsheet began as a way to speed up recruiting, but grew into a much bigger ordeal. I use Skulletor's DB editor's File->Dump Tables to quickly export all of the dynasty tables, then use the import feature of Excel to populate the spreadsheets in the Data Builders folder. From there, it's copy and paste into the RecruIQ spreadsheet.

https://drive.google.com/open?id=0B7...21DSFhjRjJYdEU
I have Mac so I can't use the editor. Looks good though.

Quote:
Originally Posted by Hellisan
I use several, but they're a mess and I should probably coalesce them.

I noticed your recruiting rules. I totally agree with the liberal allowance of recruiting 3-star guys for 2-star and up. They screwed up and 3-star is largely 2-star players, like half of it. The 2-star pool is WAY too small. For this reason I divided the 3-stars essentially in half every year and fibbed about 2-star/3star to some extent. Just random thought you didn't ask for.
Yeah it gives it more of a challenge. If it's Week 8 and you have about 1000 points to spend, you can target a 5* that's about a 14-16% lock and still get him despite not even being in Top 10.

Quote:
Originally Posted by Heyuimintojsus
Interesting. Looks like a lot of busy work? How does the random.org thing work?
Eh. It's nice to keep track of everything and see how it all plays out over my entire dynasty. Random.org just chooses a team for you.
__________________
The Depth Chart post is Page 144, #1151 (LINK)
...................
Want to help find official depth charts for Week 1? Please fill out the Google Form in the link above.

Nebraska Cornhuskers
huskerfan01 is offline  
Reply With Quote
Old 08-10-2017, 09:02 PM   #8
Rookie
 
Mattyspence503's Arena
 
OVR: 0
Join Date: Jul 2011
Re: Dynasty Spreadsheets

Ive made a few for various dynasty trackers over the years, the NCAA one and my NHL one are the most used.

Attached is my current NCAA Dynasty
Attached Files
File Type: zip NCAA- Portland State Dynasty.zip (49.4 KB, 270 views)
Mattyspence503 is offline  
Reply With Quote
Reply


« Previous Thread | Next Thread »

« Operation Sports Forums > Football > NCAA Football »


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -4. The time now is 07:16 PM.

Top -