u/ejmfantasy

Hi all,

I am working on a sheet where one sheet will pull data from a number of different tabs using VLOOKUP. By using IFERROR, I also have it display nothing instead of #N/A when there's nothing to pull.

Where I run into issue is with counting.

Essentially the main sheet is a big grid with people's names in one column, and each following column pulling data next to their name from different tabs. But not every name is on every sheet. So I want to be able to count how many items are filled in for each row, but any counting formula counts all cells as it reads the blank cells as containing data (since it has a formula in it)

So the problem is that it shows everyone as being on 17 tabs when in reality it should vary between 0 and 17 depending on the person and number of times they actually display. The values it pulls from each tab are all different words (team names) so I can't simply use 'COUNTIF' to count a specific word either.

Any ideas?

EDIT: This has been solved. Thanks to everyone who posted things to try below!

Hey all! I just had a random late night stroke of inspiration and curious if this format of a league I just dreamed up would be of interest to anyone? I only just cooked it up within the last hour or two, so it's still half baked, but figured I would check to see if there's some interest out there and I can put together the rest and get it going if so.

Essentially you would have 3 teams, structured like a farm system we see in professional sports with prospects in the minor leagues. Below is what I have typed up about it so far.

This league is designed to mimic the nature of farm teams that we see within professional sports leagues such as the NHL (with AHL, ECHL) or the MLB (with MiLB) or even the NBA (with the G-League). Not to mention all the pro sports leagues outside North America with their own academies and systems of that nature. 

The idea here is that you will have your main team, featuring your strongest pokemon, but will also have two additional teams to manage that feature some of your weaker options (in other words, your “prospects”). For the purposes of this league, those two lower teams will be filled by the pre-evolutions of the pokemon on your “pro” or main team. 

So the league structure will be built as follows:

• Division 1: Only pokemon that are in their final stage of evolution (including ones that do not evolve)
• Division 2: Pokemon in the middle of a 3+ stage evolution, or base stage pokemon from that only evolve once
• Division 3: Pokemon that are eligible for the little cup format.

If you have a pokemon that only evolves once, and their base stage is eligible for little cup, you will choose which division they will compete in.

Our draft will only include pokemon in their final stage, or who do not evolve. When you select a pokemon, you automatically get all of it’s previous stages. So if you select Charizard, you will also get Charmeleon and Charmander as options for divisions 2 and 3. 

To be able to fill all the division rosters, we will draft a deeper pro roster, which will give you more opportunities to select pokemon who evolved once, twice, or more times while still having the option to select some that never evolved. This means the rosters for divisions 2 and 3 will likely be smaller.

For battle format, I am leaning towards doing doubles battles and kinda like the idea of no mechanics/gimmicks (ie no megas, no dynamax, no tera, etc) but can be flexible on some of this stuff.

Anyway, take a look and let me know if this is something you'd be interested in seeing thought out more or moved forward. I am happy to put in the work to cook out the idea and run the league if people like the idea.

Any questions or feedback are welcome too. This is a very new thought.

PS: This league will run on Showdown if I do move forward with it.

Hi everyone!

I play on a couple different 5v5 touch football teams at the moment, but one of them is planning to switch to flag football for the fall season in a few months. We're not playing in either league through the summer due to busier schedules and allowing us time to prepare and practice for flag football which will be an adjustment for our guys.

There's quite a few rule differences between the touch and flag divisions here, but as a ref I have a decent grasp on those and will be guiding the guys through that part at least.

Now, the reason I'm here - the playbook. We do have a small playbook that we have been using for touch. It's served us well but with the change to flag, we all agree it's time to change it to better fit the ruleset.

As the team's starting QB, I have been tasked to work with our acting coach to build the new book throughout the summer.

Our plan right now is for each of us to work on some ideas on our own time, then meet at various points to discuss and build it out.

We're essentially building it fully fresh from scratch, and in my head I am thinking of having the following elements:

• Offensive Plays (our wrist coach can fit 18 comfortably, so I think that is my target number, with maybe some more that we switch in/out throughout the season)
  • I know most suggestions online suggest a smaller number than 18, but we get a decent number of snaps per game, and when I have run smaller books I notice the defense cluing in on reads later in the game
• Situational Playcalling Chart
  • Sometimes we have the coach calling plays from the sideline so having situational play calls ready may help
• Hurry-up offense plan
  • This may seem excessive, but we had 4 games come down to a ticking clock on the final drive last season. Went 3-1 in those games but could have performed better in those moments
• Maybe some defense
  • I am tasked with the offense but having some defensive concepts make it into the final book will likely help the whole team

So, my questions:

• What, if anything am I missing on the above list that should go into the playbook structure?
• Any suggestions for plays and concepts to implement?
• Any suggestions for building our situational or hurry up plans?

A few notes on our team and league:

• We do play in a low div but these guys take it seriously and we want to build a good book and be competitive to climb the divisions, hence why I am taking this pretty serious for a low div mens flag team lol
• We do plan to practice during the summer prior to next season
• We play 5v5, with the center being eligible and no blocking
• QB cannot run unless it is pitched or handed to him. QB also has 7 seconds to throw but that pitch negates that clock
• Pass rusher starts 7 yards back from line and can rush immediately
• The only NRZ is within 5 yards of scoring, otherwise run plays are fair game
• We have one super-fast WR and a few others with decent speed. Also have a couple big body targets. The QB (me) has a decent deep ball a good spiral with decent accuracy. I also am fairly mobile and like to use my legs to extend plays (for a ratio idea, I have 60 career passing TD and 11 career rushing TD)

Apologies for the length of this post and if it seems silly in general to go this deep for a low end flag football league lol, but our guys want to take it seriously and so am I haha. Any assistance or ideas are welcome. We have a few months to build this final book, but I do want to get an early start on it as there's some vacations coming up and we want to run some practices with some early ideas of some plays.

Any help is appreciated. Not expecting much, it was fun to type this at least, and thank you for reading!