Originally posted by heyelander
View Post
Announcement
Collapse
No announcement yet.
Announcement
Collapse
No announcement yet.
*** VD 15 Commentary Thread ***
Collapse
X
-
Originally posted by Bene Futuis View PostSo any of you smart Excel guys know how to make the spreadsheet not get all wonky and fucked up when you cut/paste/do stuff to the picks on the ROUNDS page? I swear I try to be careful when I'm messing with that thing, but inevitably I break something and usually the first sign of brokenness is the picks don't get "DRAFT" next to their name in the status column. Seems like it happens maybe even more than just when cutting/pasting, like maybe when you clear contents or move things from one cell to another.
Right Click > Paste Special > Unicode text
Long answer:
1. Copy the exact correct text from the VD History Thread (i.e. no empty rows before the first selection)
2. Right click on the first cell of the destination (in this case the second row)
3. Choose Paste Special
4. Choose Unicode text
5. Profit
Depending on how much messing around you've done with the spreadsheet, it might be wise to download a fresh sheet.
ALSO - NEVER CUT / PASTE ANYWHERE ON THE SPREADSHEET ... ONLY COPY PASTE and ONLY ON THE ROUNDS SHEET.
And even then, if you're copy pasting, always copy paste with the right click and text/text-icon option (or the paste special > unicode text / plain text option if necessary)
There is a separate sheet for ranking and messing around in the second post of the Draft Thread "PLAYER RANKING SPREADSHEET"Last edited by johnnya24; 06-24-2020, 05:42 AM.
Comment
-
Originally posted by heyelander View PostLess working, more posting!
I don't need to be making 5 posts in a row in Horn's retirement thread, but that's what you all have me doing.I'm not expecting to grow flowers in the desert...
Comment
-
Originally posted by heyelander View PostLess working, more posting!
I don't need to be making 5 posts in a row in Horn's retirement thread, but that's what you all have me doing.I'm not expecting to grow flowers in the desert...
Comment
-
Originally posted by heyelander View Postyou all are failing miserably. this thread is a wasteland!---------------------------------------------
Champagne for breakfast and a Sherman in my hand !
---------------------------------------------
The Party told you to reject the evidence of your eyes and ears. It was their final, most essential command.
George Orwell, 1984
Comment
-
Originally posted by cavebird View PostNice pick with Brouthers. Tough call on the year between 1887 and 1894 and 1891. At least I don't have to make that decision now, lol.
Comment
-
Originally posted by cavebird View PostSo dead in here today.---------------------------------------------
Champagne for breakfast and a Sherman in my hand !
---------------------------------------------
The Party told you to reject the evidence of your eyes and ears. It was their final, most essential command.
George Orwell, 1984
Comment
-
Johnny---just a quick note---the spreadsheet is not up-to-date on the 19,000 IP minimum for this draft. Or even consistent---some have 17,000 in the formula (behind me in draft order) and some have 18,000 (me and above). And warning to others (although I am the lowest IP guy, so it is really me, and I know)--the spreadsheet is not accurate on that.
Comment
Comment