I find myself wishing I had one more pick... probably should have dropped that bum Blair (still had hopes his inexplicable control problems at the majors will iron themselves out).
I assume someone emailed Gibby? I would but I'm just on my phone which bloooooows during the draft (its like the LOD prospect draft all over again!).
I can email my picks to someone who will be around as I may not be on during the day.
ok, I'm on here for a second now (not before ?). Yes I am traveling this week. Nobody has updated the draft sheet since Boxy picked... who has been picked?
Order is finalized on the sheet. We had ~30 picks dissolve and have settled on 89 picks total.
I also updated the trade history, but please check for any trades made after Friday morning as I may have missed them (SG, I feel I saw something about some trade you did adding prospects to it, but I may be crazy).
Happy drafting folks. I'm still away until the end of the week, but i'll check in (for my picks and to update trade logs).
ok all, I'm on for a few minutes here. I'm going to try and update the draft history, log Silvo's cuts, and finalize the draft order.
If you have made a trade in the last few days (while I've been away), please check the trade history tomorrow to ensure it's been recorded.
credit to Boxy for generating the draft order, I just linked it to the team names. The draft actually fall at a bad time for me, I'm away for a week starting Friday, but I don't mind modifying the sheet Monday morning (day after the draft) if that makes sense to everyone. Could use that as the deadline (like 8:00 Monday morning).
I've got a pretty busy Sunday, so if anyone wants to do it prior to that, someone else will have to take up the task. I doubt we see too many early picks dissolved, so the draft can start Sunday night (or earlier) if people are chomping at the bit.
Let me know what you guys think.
Yup KK, that's the safest way. I think you did as well boxy.
It's really not a big deal and 'f***ing it up' is a harsh way of saying, 'caused me a very small inconvenience' lol. Designed it to be super easy to fix.
Sure thing!
The error checking is handled on the hidden sheet 'dims'. It's got a column that has a list of cell references to each value in the range of prospects. It then checks that cell for duplication of that prospect name.
When you cut a cell and paste it over another cell, it changes the reference in the related cell on the 'dims' sheet (to reflect the move), but also destroys the reference to the cell you are pasting over. Cutting a merged cell and pasting it elsewhere also unmerges the cells you cut from.
When you copy a cell and paste it over another (then delete the original value), the references stay in tact and the cells stay merged.