Dropped 0 and 1 years minors players 1 year subtracted from non-2023 drafted players Reverted 'In Draft Year' column 'Y''s to 'N's, as they are no longer in drafted year. Random blank cells removed for formatting. Added new functional cells after last minor player on tab.
Took the calculated value of every team's 'Cut Players' from 2023 to 2030, and copied the value row to the row denoted as 'Previously Cut' in column A. This is to ensure no values lost when deleting actual cut players from the 2023 Fiscal year. Once done on all 14 player tabs, went to the 'Player Database' sheet, and deleted all 2023 fiscal year cut players.
'Cut Players' for both the 'Player Database' sheet and all individual team sheets is now refreshed.
On 'Player Database' sheet for the 'Cash' tab, removed all rows where there was only a dollar value for the 2023 year and no other years. This is meant to clean up the 'Cash' tab, and only reflect dollar values on each individual player sheet for 2024 and beyond. This is just housekeeping formatting.
On 'Minor Leagues' tab within 'Players Database' sheet: Deleted all rows of drafted players from 2015 to 2023. This tab was getting unruly with rows upon rows of useless data. Process of record for who got drafted by whom and when is the Cashman website found within the archives section using simple searches. Now draft only reflects 2024 thru 2028 which will make filtering data when doing Milb/entry trades easier for Minny and whoever is doing sheets. Had to fix the import functions for each team sheet to pull the proper data from the 'Player Database' sheet.
Also ensured integrity on 2024 through 2028 rows for future draft picks.
Okay, finally done with all the individual team sheets, upgraded to 2024. I don't know why this year was tougher than last year.
I think that is it.
Check your sheets. Buddy check. Anything I messed, Ill get to in coming days. If players I forgot to remove or add, Minny feel free to jump in to save me there.
Post by ChrisMac777@aim.com on Oct 25, 2023 21:15:45 GMT -5
Ok I fixed my mistakes. When league starts cutting players in earnest, please make sure the dead salaries from cut players populates the individual team pages. If not, send me a PM. If you post on these boards, I will not see it. PMs: I will get an email about a private message from cashman.