Excel Tips and Dynasty Startup Thoughts
Typing heights is one of the most annoying thing about a dynasty... I'd say. I used to just use the lazy 5-10 (dash between the two) as it was much easier.
I recently found a good "hack" for excel aka custom formatting. In your height column, edit to a custom cell format as such: Code:
[<100]#' #'';#' ##\" 510 and it returns 5'10" 68 and it returns 6'8" For me this was a big find, and I hope it helps someone else. |
Re: Just a quick Excel tip for my 'nasty boys I learned recently (Custom height forma
That's a great tip. I usually copy a roster from the teams website to start and it always changes the heights to a date.
|
Re: Just a quick Excel tip for my 'nasty boys I learned recently (Custom height forma
I'm a big excel guy as well so this is super helpful. Thanks man!
|
Re: Just a quick Excel tip for my 'nasty boys I learned recently (Custom height forma
This is a dandy tip!
|
Re: Just a quick Excel tip for my 'nasty boys I learned recently (Custom height forma
Quote:
Doing this will stop the numbers from converting to dates. What you type is what you get. |
Re: Just a quick Excel tip for my 'nasty boys I learned recently (Custom height forma
I have another tip that freaking BLEW MY DAMN MIND. We have to thank the data entry people that have such tough jobs for this because Excel had them in mind. This is another one that I did not know until just now. I stopped what I was doing and came over.
So you're typing up your roster, even if you don't track all ratings annually like I've started to do, it can still be a bear. Tip: Excel is designed for data entry people, one way it makes their job easier is with the selection tool. Select a section of data entry you want to work on, and start typing from the top left, it will automatically tab down after you press enter, and then tab up to the top of the next column after you complete the first column, all the way until the end. What you're currently working on is less shaded than the rest so it's easy to figure out exactly where you currently are. Here's an image: Good luck! |
Re: Just a quick Excel tip for my 'nasty boys I learned recently (Custom height forma
Another great find! Thank you again for sharing man!
|
Re: Just a quick Excel tip for my 'nasty boys I learned recently (Custom height forma
Love working with Excel so both these tips (height hack and current selection) will definitely help be more efficient! The height thing has always bothered me as it was such a PITA at times. The current selection will make it easier to just go down the entire roster and type in the attributes without having to click on the top of the next column. I envision XBOX paddle in my left hand, right hand working the number pad on the right of the keyboard and hopefully flying through the roster. Thanks again!!!
|
All times are GMT -4. The time now is 01:12 AM. |
Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.