Yea me too I promise I’ll get to it by tomorrow and text my friends. Once I get in a Rythem it’ll be better. Sometimes I get a little lost in what I neee to do and when
Yea me too I promise I’ll get to it by tomorrow and text my friends. Once I get in a Rythem it’ll be better. Sometimes I get a little lost in what I neee to do and when
Honestly feel free to text me if you don’t mind cuz I personally won’t.Hit me up if you need any insight. I can walk you through whatever is needed.
Nerd@Truth, @RavensMania
So I got bored and annoyed one piece lacking automation and created this formula to calculate the total number of players based on entries (i.e., NOT NULL or field not blank) to calculate total cuts, retirements, additions, etc.
```
=56+(COUNTIF(D320, "<>")+COUNTIF(L3, "<>")+COUNTIF(L9:L18, "<>")+COUNTIF(L24:L33, "<>")+COUNTIF(T3:T48, "<>")+COUNTIF(X3:X22, "<>"))-(COUNTIF(L47:L49, "<>")+COUNTIF(P348, "<>")+COUNTIF(X29:X48, "<>"))
```
This is for the >51 or at 51 fields. However, this is also not super efficient. I'd suggest taking these and adding another column to the Final Numbers area to include total players cut, retired, etc. This way we can pull from these raw numbers without an ugly long formula chain lol. You can add an IF ELSE condition, too, to identify IF over 51 or NOT over 51. 56 represents total number of players I (KC started with, for example.
This is the formula to do that
=IF(B32 > 51, B32 - 51, B32)
This means if the value in B32 (just total roster, not <=51) so we could remove B33 and would mean we don't need to autocalculate total roster as it would do it for us.
BTW : P is the smiley emoji. For some reason inline code blocks are erroring
It's my day job, man. lol. It's sometimes hard to turn it off.Nerd
Also we've had limited or no activity from the following:
@Giants56Ravens52 @jmart112189 @DaddyDK @Grim @purplepittabread88 @amikeus9000 @LArams11
Understand a couple of you are busy, but also a large group of new players to the game. If you have any questions or need any help to get you going, please reach out and let one of me, @Truth, @RavensMania, or @DaCiderEarl know.
It's my day job, man. lol. It's sometimes hard to turn it off.
When was the roster locked again? I have a safety who was a ERFA for the Vikings who re-signed but don't know if it was before we locked the rosters or not.Anyone who still needs their ERFA or RFA totals can reference the Free Agency section of OTC. You can sort specifically by RFA and ERFA. However, keep in mind that the already signed ones will not show, and they'll need to be found elsewhere.
Shout out to those of you that got going - it's appreciated!Also we've had limited or no activity from the following:
@Giants56Ravens52 @jmart112189 @DaddyDK @Grim @purplepittabread88 @amikeus9000 @LArams11
Understand a couple of you are busy, but also a large group of new players to the game. If you have any questions or need any help to get you going, please reach out and let one of me, @Truth, @RavensMania, or @DaCiderEarl know.
These void years are killer manWhen you see lots of stars available from restructures on the computation hub, but they're all on their last year
I'm still alive, just super late. Sorry about that, been busy. Tomorrow should be good to go.Shout out to those of you that got going - it's appreciated!
Anyone had contact with @amikeus9000 or @Jacquouille (who I forgot to tag in the original)? Think everyone else has either gotten it going or communicated via PM.
I'm still alive, just super late. Sorry about that, been busy. Tomorrow should be good to go.
there, changed it!get that giant logo off the Depth Chart or you're banned @DaCiderEarl. It's a huge eyesore!