Excel Depth Chart Template(Firefox Only)

Discussion in 'Thread Archive' started by Nautica, Aug 7, 2010.

  1. Nautica

    Nautica #whatisdrugs?

    Joined:
    Jul 27, 2009
    Messages:
    7,915
    Excel Depth Chart Template(Firefox Only)

    I know that there has been a little gripe about having to do the detailed depth charts, no longer will that be the case. SodaAddict was gracious enough to supply us with an Excel template to post your Depth Charts. There is no need to wrap it, all you do is just copy and paste it.

    Excel 2007 & 2010 Template

    Excel 2003 Template


    How to Use the Template:

    1. Go to the Dynasty Wire, click on Rosters. Go to your team then Highlight the entire roster and copy it.
    2. In the Excel Template, click over to the "Copy-Pasted" Chart.
    3. Highlight Column "A" and then right-click over the column and then click on "Special Paste", then paste it as "text". A message might pop up saying something about being the wrong size, just click OK.
    4. Switch over to the "Ready for Posting" chart.
    5. Click on the very left hand corner of the chart, this should auto-highlight the whole chart.
    6. Next in the top, right hand corner of excel should be a "Sort & Filter" button, click on that and in the drop down click on custom sort.
    7. Now make sure to check the box "My data has headers" box and then click OK.
    8. Highlight only column "A" down to the bottom of the Info, you should see ||||||[/table] and below that should 0|0|0|0|0|0|0 on each line below that, only highlight down to the line that has the table wrap in it. Copy it.
    9. Now just paste it in the reply box and your good to go. No need to wrap it since the table wrapping code is already included.
    10. Now you can edit it how you want adding color to the headings and what-not.
    HOW-TO VIDEO
    [YOUTUBE]IKqll021rgk[/YOUTUBE]
     
  2. BoSoxFan58

    BoSoxFan58 Walk On

    Joined:
    Sep 21, 2009
    Messages:
    210
    For some reason this is absolutely stumping me...
     
  3. Nautica

    Nautica #whatisdrugs?

    Joined:
    Jul 27, 2009
    Messages:
    7,915
    I will be posting step by step photos later tonight
     
  4. AJ Hart MN

    AJ Hart MN Marseille - TFL Season 1 Champions

    Joined:
    Oct 16, 2009
    Messages:
    8,710
    At least i'm not the only one.. Spent an hour yesterday trying those instructions to no avail.. Was getting so frustrated, I felt like throwing my damn computer out the friggin window..
     
  5. PAgamer07

    PAgamer07 We're the ship without a storm

    Joined:
    Nov 11, 2009
    Messages:
    22,921
    What the problem is, is that it is not transferring from the copy pasted to the ready for posting step. There is a step missing. Im working on figuring it out.
     
  6. Nautica

    Nautica #whatisdrugs?

    Joined:
    Jul 27, 2009
    Messages:
    7,915
    i'll go over the instructions again, they are working fine for me. If you guys can get on live i'll talk you through it
     
  7. PAgamer07

    PAgamer07 We're the ship without a storm

    Joined:
    Nov 11, 2009
    Messages:
    22,921
    Im at the office dude, so no headset.
     
  8. Nautica

    Nautica #whatisdrugs?

    Joined:
    Jul 27, 2009
    Messages:
    7,915
    ok no problem
     
  9. Nautica

    Nautica #whatisdrugs?

    Joined:
    Jul 27, 2009
    Messages:
    7,915
  10. Nautica

    Nautica #whatisdrugs?

    Joined:
    Jul 27, 2009
    Messages:
    7,915
    Then just post it without wrapping it and it will look like this.

    Offense

    Name Position (Offense) Overall Year Height Weight Hometown
    Jones, Landry QB 90 Sophomore (RS) 6'4" 216 lbs Clayton, NM
    Allen, Drew QB 79 Freshman (RS) 6'5" 232 lbs Rosenberg, TX
    Bell, Blake QB 75 Freshman 6'6" 227 lbs Colby, KS
    Murray, DeMarco HB 95 Senior (RS) 6'1" 214 lbs Carson City, NV
    Calhoun, Jermie HB 88 Sophomore (RS) 6'0" 218 lbs Midland, TX
    Madu, Mossis HB 81 Senior (RS) 6'0" 200 lbs Noble, OK
    Clay, Brennan HB 77 Freshman 5'11" 192 lbs Compton, CA
    Miller, Jonathan HB 76 Sophomore 6'0" 198 lbs Abilene, TX
    Musil, Marshall FB 80 Freshman (RS) 6'2" 241 lbs Leawood, KS
    Millard, Trey FB 79 Freshman 6'2" 246 lbs St. Ann, MO
    Broyles, Ryan WR 95 Junior (RS) 5'11" 178 lbs Edmond, OK
    Miller, DeJuan WR 89 Sophomore (RS) 6'4" 224 lbs Carteret, NJ
    Caleb, Brandon WR 86 Senior (RS) 6'1" 187 lbs Montclair, VA
    Kenney, Cameron WR 84 Senior 6'1" 193 lbs Columbus, GA
    Reynolds, Jaz WR 80 Sophomore 6'2" 181 lbs Monahans, TX
    McCay, Justin WR 76 Freshman 6'3" 197 lbs Abilene, KS
    Stills, Kenny WR 75 Freshman 6'2" 175 lbs Gardena, CA
    McClain, Sheldon WR 66 Freshman 6'2" 174 lbs Grand Prairie, TX
    Ratterree, Trent TE 83 Junior (RS) 6'3" 225 lbs Durant, OK
    Hanna, James TE 75 Freshman 6'4" 237 lbs Wharton, TX
    Haywood, Austin TE 73 Freshman 6'4" 245 lbs Guymon, OK
    Jones, Jarvis LT 89 Junior (RS) 6'7" 297 lbs The Woodlands, TX
    Stephenson, Donald LT 85 Junior (RS) 6'6" 285 lbs Columbia, MO
    Thompson, Tyrus LT 74 Freshman 6'5" 311 lbs Canyon Lake, TX
    Good, Stephen LG 87 Junior 6'6" 291 lbs Forest Hill, TX
    Irwin, Bronson LG 77 Freshman 6'5" 316 lbs Sapulpa, OK
    Habern, Ben C 90 Sophomore 6'3" 292 lbs Aldine, TX
    Ikard, Gabe C 80 Freshman (RS) 6'4" 282 lbs Chickasha, OK
    Evans, Tyler RG 88 Sophomore 6'5" 316 lbs Joplin, MO
    Jeffries, Travaris RG 84 Senior 6'4" 309 lbs Clarksville, TN
    Brandon, Cory RT 90 Senior (RS) 6'7" 324 lbs Highland Village, TX
    Aledenoye, Josh RT 81 Freshman (RS) 6'5" 316 lbs Seguin, TX
    Williams, Daryl RT 75 Freshman 6'5" 269 lbs Plainview, TX
    Mensik, Eric RT 73 Senior (RS) 6'6" 288 lbs Balch Springs, TX



    Defense

    Name Position (Defense) Overall Year Height Weight Hometown
    Alexander, Frank RE 87 Junior (RS) 6'4" 259 lbs Marksville, LA
    Chaisson, Justin RE 80 Freshman (RS) 6'4" 268 lbs Ely, NV
    Washington, R J RE 75 Sophomore (RS) 6'3" 244 lbs Dallas, TX
    Taylor, Adrian DT 90 Senior (RS) 6'4" 303 lbs Houston, TX
    McFarland, Jamarkus DT 85 Sophomore 6'2" 296 lbs Harker Heights, TX
    McGee, Stacy DT 80 Sophomore (RS) 6'4" 275 lbs Sapulpa, OK
    Walker, Casey DT 76 Sophomore 6'2" 301 lbs Round Rock, TX
    Humphrey, Eric DT 75 Freshman 6'4" 292 lbs Port Neches, TX
    Beal, Jeremy LE 93 Senior (RS) 6'3" 261 lbs Highland Park, TX
    King, David LE 82 Sophomore (RS) 6'5" 236 lbs Robinson, TX
    Grissom, Geneo LE 75 Freshman 6'4" 233 lbs Russell, KS
    Lewis, Travis ROLB 94 Junior (RS) 6'2" 232 lbs Bellmead, TX
    Bird, Jaydan ROLB 84 Sophomore 6'1" 227 lbs Fort Scott, KS
    Nelson, Corey ROLB 74 Freshman 6'0" 210 lbs Brownsville, TX
    Wort, Tom MLB 89 Freshman (RS) 6'0" 220 lbs Dallas, TX
    Box, Austin MLB 82 Junior (RS) 6'2" 220 lbs Glenpool, OK
    Franklin, Daniel MLB 80 Sophomore (RS) 6'2" 219 lbs Panthersville, GA
    Favors, Rashod MLB 65 Freshman 6'1" 230 lbs Pleasanton, TX
    Lewis, Ronnell LOLB 85 Sophomore 6'2" 234 lbs The Village, OK
    Ibiloye, Joseph LOLB 76 Sophomore (RS) 6'3" 215 lbs West University, TX
    Lee, Erik LOLB 74 Freshman (RS) 6'3" 205 lbs El Reno, OK
    Nelson, Jonathan CB 88 Senior (RS) 5'11" 172 lbs Jacinto City, TX
    Hurst, Demontre CB 85 Sophomore 5'9" 165 lbs Universal City, TX
    Fleming, Jamell CB 84 Junior (RS) 5'11" 178 lbs San Antonio, TX
    Lynn, Gabe CB 75 Freshman (RS) 6'0" 186 lbs Elk City, OK
    Harris, Lamar CB 72 Sophomore (RS) 6'1" 186 lbs Odessa, TX
    Carter, Quinton FS 89 Senior (RS) 6'1" 193 lbs Carlin, NV
    Brent, Kevin FS 78 Freshman (RS) 5'11" 216 lbs McKinney, TX
    Trice, Marcus FS 77 Sophomore 5'8" 178 lbs Wylie, TX
    Proctor, Sam SS 88 Junior (RS) 6'0" 208 lbs Graham, TX
    Jefferson, Tony SS 75 Freshman 5'11" 198 lbs Westmont, CA
    Hayes, Quintin SS 72 Freshman 6'1" 175 lbs Weslaco, TX



    Special Teams

    Name Position (Special Teams) Overall Year Height Weight Hometown
    O Hara, Patrick K 87 Sophomore 6'0" 185 lbs Haysville, KS
    Way, Tress P 86 Sophomore (RS) 6'1" 220 lbs Glenpool, OK
     
  11. Nautica

    Nautica #whatisdrugs?

    Joined:
    Jul 27, 2009
    Messages:
    7,915
    sorry forgot to write on there click on custom sort for that box to come up
     
  12. AJ Hart MN

    AJ Hart MN Marseille - TFL Season 1 Champions

    Joined:
    Oct 16, 2009
    Messages:
    8,710
    The problem for me is that it doesnt give me the option to special paste.. I have done everything right but at that option it's not highlighted.. All I can do is regular paste.. I also am at work.. Getting home at 3cst, having a new dryer delivered at that time but anytime after 4:30 till about 10 would work for me if you're around.. If not i'll try again.. Hopefully today will better than yesterday.
     
  13. PAgamer07

    PAgamer07 We're the ship without a storm

    Joined:
    Nov 11, 2009
    Messages:
    22,921
    Tried again after the pics still couldnt get it to work. Think I need more coffee...
     
  14. Nautica

    Nautica #whatisdrugs?

    Joined:
    Jul 27, 2009
    Messages:
    7,915
    do you have 2007 or 2010 office, because if not you will need the older template for it to work. That might be the problem.
     
  15. Basis4aDay56

    Basis4aDay56 Walk On

    Joined:
    Feb 22, 2009
    Messages:
    5,421
    NAUTICA, this is f'in AWESOME!!!


    (y)(y)(y)(y)(y)

    I found it amazingly easy to use. I am super familiar with Excel though as it is what I use for 95% of what I do for a living.
     
  16. ctvolfan

    ctvolfan Vol for Life!!

    Joined:
    Jul 17, 2010
    Messages:
    1,339
    IDK what I am doing wrong. I am following the steps as he has them and after I do the custom sort w/headers thing it brings Oklahomas team up and the roster is OU everytime no matter what roster I try and use. Any help would be appreciated.
     
  17. AJ Hart MN

    AJ Hart MN Marseille - TFL Season 1 Champions

    Joined:
    Oct 16, 2009
    Messages:
    8,710
    Ah don't worry about it man.. That's a rmg thing and as seeing that all those guys have now dropped out suddenly (evidentally, all 4 guys got really busy at the same time), who knows if that's mandatory thing anymore. Btw, I could never get it to work either.
     
  18. ctvolfan

    ctvolfan Vol for Life!!

    Joined:
    Jul 17, 2010
    Messages:
    1,339
    Oh okay was not sure. I was hoping to use it anyway to add more content for this dynasty and others that I am in. Like you though I have no luck.
     
  19. SodaAddict

    SodaAddict Proud Hurt Locker Commish

    Joined:
    Jul 13, 2010
    Messages:
    1,205
    I am the one that designed the template, for what it's worth, and yes, depth charts and everything are still expected. You don't have to use the template, but it does save time.

    That being said, you do have to use FireFox because IE doesn't copy-paste the same way. I tried to make a template for IE, but it apparently didn't work and I just got too busy to try to fix that version when I already had one that worked.

    So, ctvolfan, the first question is: are you using Firefox?

    If so, are you sure that you are copy-pasting in to the right place? The only reasons I can think of that the game would bring up Oklahoma's roster (which is the default roster on there) are 1) the stuff didn't get pasted over on the "Copy-Paste" tab, and/or 2) the information pasted in the wrong format.
     
  20. ctvolfan

    ctvolfan Vol for Life!!

    Joined:
    Jul 17, 2010
    Messages:
    1,339
    I was using Google Chrome. Recently just switched over from Firefox. I will post a depth chart as soon as we figure out the direction that this league is going to take. Unless you want me to go ahead and do one now regardless.
     
  21. SodaAddict

    SodaAddict Proud Hurt Locker Commish

    Joined:
    Jul 13, 2010
    Messages:
    1,205
    Up to you. It only takes about 30 seconds, so it wouldn't hurt to go ahead.
     

Share This Page