Post by Deleted on Apr 4, 2016 1:50:44 GMT
Hey everyone, so I don't know if you've already realized, but with Hannes permission I've made some changes to the way the MLB/MiLB master lists work. The lists should now work by updating to automatically reflect the changes the LM makes on every teams sheet. I believe this will benefit us a great deal because we'll be able to have an updated list always, which should help finding players and will take a load off of Hannes and Bryan, because they won't spend 1-2 hours each time they need to update the list.
As the formulas I applied haven't really been tested, I wouldn't want something to fail, so I also left the Old sheets for now (the ones updated by Hannes in Feb 26). You can find them with the Old List name.
Onto the technical stuff, the list works by checking the cells which may contain players in each team's sheets, so it copies all of the info needed (player name, position, team) of every team into another sheet (which is hidden because of how terrible it looks
) , even those spaces which are blank, then I use a sort formula which filters out the blank spaces and makes everything work great, this formula can be seen on cell A5 at both lists.
So there's a couple of things to have in mind if you're going to update the sheet:
When deleting a record, be it a player or something else, please use either the backspace or the delete key, as these erase the values of the cell, if you use a space " " to delete its contents, it will make the formula fail, you'll be able to see this because the records at the top will be blank spaces, which is actually quite quick to fix, if you see that go into the team's sheet and erase the "blank" sheets.
Minor changes like Player's name, position, DL and dev roster are also updated automatically, so you will be able to see where a player is in each team with a quick look.
The most important problem I've seen right now is when moving players from one place to another, like moves from Dev Roster to MLB roster or from one team to another. The problem happens when doing this moves by selecting a range to move, then cutting (ctrl+x) and pasting (ctrl+v), the way formulas work, their values are updated to point to the new place if this is done (therefore creating two registers). This problem can be fixed quite easy if instead of doing that, you select the range to move, then copy(ctrl+c) and paste(ctrl+v) into the new place, then go back and erase the range. The only thing is not cutting and pasting as this affects the cell references. I'm not skilled in excel formulas at all, so I don't know how to come up with a fix for this, I've found something about that on google, it's called static referencing, and will try it next week because I'm a little bit busy right now.
So to recap, no cutting and pasting please (copying and pasting is fine), and also please don't add new rows into the sheets, as this will displace the formula if done.
I know this sounds like a lot, but it's really not as bad as it looks, it's quite simple and you'll see the difference quite quickly, everything works very good and it's great to finally be sure about what we look for in the lists.
Thanks for your attention and please let me know if anything happens, or if you know how to fix the mentioned problem
As the formulas I applied haven't really been tested, I wouldn't want something to fail, so I also left the Old sheets for now (the ones updated by Hannes in Feb 26). You can find them with the Old List name.
Onto the technical stuff, the list works by checking the cells which may contain players in each team's sheets, so it copies all of the info needed (player name, position, team) of every team into another sheet (which is hidden because of how terrible it looks
) , even those spaces which are blank, then I use a sort formula which filters out the blank spaces and makes everything work great, this formula can be seen on cell A5 at both lists. So there's a couple of things to have in mind if you're going to update the sheet:
When deleting a record, be it a player or something else, please use either the backspace or the delete key, as these erase the values of the cell, if you use a space " " to delete its contents, it will make the formula fail, you'll be able to see this because the records at the top will be blank spaces, which is actually quite quick to fix, if you see that go into the team's sheet and erase the "blank" sheets.
Minor changes like Player's name, position, DL and dev roster are also updated automatically, so you will be able to see where a player is in each team with a quick look.
The most important problem I've seen right now is when moving players from one place to another, like moves from Dev Roster to MLB roster or from one team to another. The problem happens when doing this moves by selecting a range to move, then cutting (ctrl+x) and pasting (ctrl+v), the way formulas work, their values are updated to point to the new place if this is done (therefore creating two registers). This problem can be fixed quite easy if instead of doing that, you select the range to move, then copy(ctrl+c) and paste(ctrl+v) into the new place, then go back and erase the range. The only thing is not cutting and pasting as this affects the cell references. I'm not skilled in excel formulas at all, so I don't know how to come up with a fix for this, I've found something about that on google, it's called static referencing, and will try it next week because I'm a little bit busy right now.
So to recap, no cutting and pasting please (copying and pasting is fine), and also please don't add new rows into the sheets, as this will displace the formula if done.
I know this sounds like a lot, but it's really not as bad as it looks, it's quite simple and you'll see the difference quite quickly, everything works very good and it's great to finally be sure about what we look for in the lists.
Thanks for your attention and please let me know if anything happens, or if you know how to fix the mentioned problem
