The forums are retiring and are now closed for new topics and comments. The existing content will remain online and accessible through 2020 to provide everyone the opportunity to save any relevant information. In the spring of 2021, these Community forums will be taken offline.

Search for Nfl teams in Topics

use excel to strip city name from team name in NFL? Answered

Hi all, how would i go about stripping the city from a list (over 3000) of Team names. ie Arizona Cardinals -> Cardinals i have a spreadsheet listing all games from Sunshine Forecast for the 1978 - 2011 seasons and have a lookup so i can see the matchups between any team and i will show me the Score, winner, loser & Home/Road. but the teams have moved/ changed names in that time.

Question by furby    |  last reply

import NFL win/loss data in to Excel? Answered

Hi, i have 2 Sheets in excel with the team names going Across & Down to form a matrix. 1 Sheet for Home Games, 1 Sheet for Away. is there any way to import that data into excel. (Picture to Show Layout)

Question by furby    |  last reply

excel problem. averaging results of index match?

Hi all (again) new problem semi related to previous. (check my profile for the ones with NFL in the title) now the problem is i want to get the average score for each team in each season. my current formula only gets the first result of the index/match even if i use some of the tricks i've googled. the data is in the format of YearVisitingTeam(W/L/D)Score@HomeTeam(W/L/D)Score          ie   201249ersW41@2012PatriotsL34 i use a formula to strip "Year(Visiting/Home)Team(W/L/D)" so i' left with Score on either side of the "@" (that was a [redacted] pain) using any and all of the tricks i know i get either 0, 27 or an error of some sort. the only way i've been sorta able to do this is by getting the first home win, first home loss, first away win, first away loss BUT that's only 4 of 16 games each season and not a good representation of the average points for the team in a season. the sheet in question is AVG point - Reg Season the source data is 78 - current regular season (2012 season starts @ row 3152)

Question by furby    |  last reply

Problems with Excel formula? (semi-related to previous questions)

Hi all, i've got a problem with a formula in my excel spreadsheet that i'm using to get the scores for NFL teams 1978 - Current i have the data ok but the problem is with matching the the specific games. i've CONCATENATED the data to provide unique data points also it's in two columns (Home & Visitor) in the format of YearTeamW/L/DScore     eg. 2012TitansW35 in the VERY unlikely event (and i've check a random selection) that the team has 2 wins at home with the same score this could cause an error. here is the formula i'm using: (version ~8000zzzzz lol) (all one formula, just added a line break to make it fit) =(IF(MATCH($A$3&$B$2&"w*",Home_Team,0)=MATCH($A$3&$C$2&"l*",Visitor,0),INDEX(Visitor,MATCH($A$3&$C$2&"l*",Visitor,0)) ,IF(MATCH($A$3&$B$2&"d*",Home_Team,0)=MATCH($A$3&$C$2&"d*",Visitor,0),INDEX(Visitor,MATCH($A$3&$C$2&"d*",Visitor,0))))) Here's a link to the folder with the spreadsheet. (NFL Stuf (test).xlsx) Sheet: Past Season Summary - what is says. eventually where the formula is going. Sheet: nfl2011lines - 92   - the data (actually 1978 - 2012 but i named it before i added all the data) Sheet: TESTING - my "sandbox" so i don't [Censored] the main sheets Semi-Related Question1 Semi-Related Question2

Question by furby    |  last reply

The Bears :-(.

Ok, this is a forum topic for Chicago Bears fans (and really, all sports fans). Who thinks that the Chicago Bears are the most depressing team to be a fan of? I just got done watching the Bears/Falcons game. That was depressing. They had their chance to come back... and they blew it! Oh well, there's always next week.

Topic by Gjdj3    |  last reply

lifes unanswered questions...

Great questions to ponder over (great conversation starters!)Can you cry under water?why does a round pizza come in a square box?What's the difference between a novel and a book?How old are you before it can be said you died of old age?If nobody buys a ticket to a movie do they still show it?if a person owns a piece of land, do they own it to the center of the earth?if you have a cold hot pocket, is it just a pocket?Why doesn't glue stick to the inside of the bottle?Do penguins have knees?Why is it said that an alarm clock is going off when really its coming on?How come people tell you not to stand in front of an emergency exit when if there was an emergency surely you would run through it?Why did Sally sell seashells on the seashore when you can just pick them up anyway?Why are both of Spongebob's parents round like sea sponges while he is square like a kitchen sponge?(isn't this one great?)Does a two-humped camel store more fat than a one-humped camel?If you pamper a cow, do you get spoiled milk?Why is it that if someone yells "duck" they are helping you, but if they yell "chicken" they are insulting you?why do we drive on the parkway and park on the driveway?If the FBI breaks your door down do they have to pay for it?If they have angel food cake on earth, do they have people food cake in heaven?(don't start a war over that, its just a joke!)If you fart and burp at the same time, would it make a vacuum in your tummy?Why do you put two cents in when its only a penny for your thoughts?You know the signs on restaurant doors? No Shirt, No Shoes, No Service? what if someone goes in with No Pants? Would the restaurant still have to serve them?If a doctor suddenly died while doing surgery, would the other doctors work on the doctor or the patient?Why do we sing "Rock a bye baby" to lull our little ones to sleep when the song is about putting your baby in a tree and letting the wind crash the cradle to the ground?Why do we say we're head over heels when we're happy? Isn't that the way we normally are?If the Wicked Witch of the West melts in water... how did she ever bathe?If bald people work as chefs in a restaurant,do they have to wear hairnets?Why do sleeping pills have warning labels that state :'Caution: May Cause Drowsiness?How can Darth Vader breathe and talk at the same time?If there's a wheelchair-bound comedian, is it still called "stand-up"?When the French swear do they say pardon my English?Do people who use sign language see little hands in their head when they think about what somebody said, or do they hear the words in their head?How did Walt Disney figure out how to make people pay to stand in lines all day?Why do people constantly return to the refrigerator with hopes that something new to eat will have materialized?Why is it that no matter what color bubble bath you use the bubbles are always white?Why does someone believe you when you say there are four billion stars, but check when you say the paint is wet?Why do they call someone "late" if they died early?If the serving size on a can of soda is one can, then why is the serving size on the little can one can, too? Wouldn't the little cans be 2 cans?If a king is gay and marries another guy what is that guy to the royal family?Why are red buttons always the most important?How is chess considered a sport?Why is it when your sleeping it`s called drool but when your awake its called spit?If a teacher were to teach a younger grade than they were teaching before, would they be "degraded"?Why does every Abraham Lincoln impersonator sound the same, even though there are no known audio recordings of the man?How's come people tell you to stay a kid for as long as you can. Yet the moment you do anything childish or immature they tell you to grow up.Why does the Easter bunny carry eggs? Rabbits don't lay eggs.If marbles are not made of marble, why are they called marbles?If you dig a hole through the center of the earth, come out on the other side, and then let go, would you be falling down or floating up?Could you be a closet claustrophobic?Could someone be addicted to counseling? If so, how would you treat them?If ketchup is good on french fries, how come it isn't good on mashed potatoes?Where do all the daylight savings hours go?Why doesn't the hair on your arms grow as fast as the hair on your head?What happens if a black cat walks under a ladder and breaks a mirror?Why when people ask you "what three things would you bring with you on a desert island?" no one ever replies, "A BOAT"Why are elderly people often called "old people" but children are never called "new people"?Why doesn't broccoli come in a can?Can you slam a revolving door?What would happen if you found a four-leaf-clover under a ladder?Can a cross-eyed teacher control his pupils?If Winnie the pooh was civilized enough to keep his honey in jars, why did he eat it off his hands? Surely he had spoons?What happens if you get a paper cut from a Get Well card?Can you read a picture book?Why does it say "shake well" on ketchup bottles, but not ketchup packets?Is there ever a day that mattresses are not on sale?Is eating a mermaid considered cannibalism?If mirrors need light to work, what happens if you put night vision goggles on in the dark and look at a mirror?if you're on an American airline, and you land in Canada and stay on the plane, is the drinking age still 21 or does it change to 19?What happens if every team in the NFL goes 8-8?What shape is the sky?If a Jewish person goes to court and is asked to put their right hand on the Bible, do they use a Torah instead? (again, don't start a war over that)Why is it written "May contain traces of peanuts or other kind of nuts" on peanut butter jars. Are people stupid enough not to realize it themselves?If you only have one eye...are you blinking or winking?If you have a gun and you ask, "can I ask you a question?" and they say "fire away" should you shoot them?What is a chickpea if it is neither a chick nor a pea?Why is it called the People's Republic Of China when China's not a republic?Why are dandelions considered weeds when daisies are considered flowers?Why does Sea World have a seafood restaurant?Whenever an adult is kidnapped why isn't it called adultnapped?Why do black lights look purple?Did Yankee Doodle name the feather, hat, town, or his pony Macaroni?Why is it that people duck in the rain, do they really think the rain won't hit them?Why isn't the caps lock capitalized?If someone with a nostril ring takes it out, then blows their nose, do they have to cover that hole as well as their nostril holes so that snot doesn't blow out everywhere?Isn't it weird that if you rearrange the word "teacher" you get "cheater"?How come whenever you start to sing, you automatically sing in a higher voice than you talk?How come people say they ate the last piece of gum, when they really just chew it?You know the saying "throw ya hands in the air like ya don't care"? why bother doing that if you don't care?Why is there no pine or apple in pineapple?Why do water bottles have a "best if used by" date?\If you called the police station to talk to an officer and he was not there, would that be considered a cop out?Why do they put holes in crackers?How come on TV the bell always rings and then the kids go to class, but in real life you need to be in class before the bell rings?Why can the saying "it's all downhill from here." mean both that it will be easy and that it is going to get worse?If all of ACME's products backfire, why does Wile E. Coyote keep buying them?Why do "cool" and "hot" mean the same thing?If you sneeze and fart at the same time, does a vacuum form in your stomach?Why does triangularly cut bread taste better than square bread?Does a baby feel the umbilical cord being cut off?Is it legal to name your kid "Anonymous"?If you have a pet with 2 heads do you have to name both heads?Why can't liquor freeze?If you dig a hole in the south pole are you digging up or down?How come they don't add the time that we are in our mom's to our age?Why do people squint their eyes when they can't see? Wouldn't that just make it less space to see out of?What is a hacky, and why is it in a sack?Who was in the kitchen with Dina?Why do we have to pay a toll on "freeways"?Why do they call them pepperoni if there is no pepper in it?How old does something have to be to become an antique?Can a school teacher give a homeless child homework?Do babies produce more spit than adults?How come French fries are not considered a vegetable, they are just deep fried potatoes?Do cows have calf muscles?Why is shampoo clear but conditioner not?If conjoined twins participate in sports, do they count as one or two players?If a singer sings their own song during a karaoke party, is it considered karaoke?Why do mattresses have designs on them when they're always covered with sheets?If you died with braces on would they take them off?If a person suffered from amnesia and then was cured would they remember that they forgot?Can someone have their head in the clouds and be down-to-earth at the same time?Why is Joey short for Joe, when Joey has more letters?If you were a pastor, and you were getting married, would you hire a pastor, or would you do the wedding yourself?Is there a certain temperature at which it stops being qualified as cold? At what temperature does it qualify as hot?if someone tells you not to be your self, who should you be?Why is most lunchmeat bigger than the bread?Why is it that whenever you sing to the radio, your voice is higher? Even when you have a low voice?How come toy hippos are always blue, or purple, when real hippos are brown?Have ex-mathematicians become dysfunctional?Have ex-locomotive engineers been derailed?Have ex-civil lawyers been distorted?Have ex-bankers become disinterested?Are there seeing eye humans for blind dogs?You know that little indestructible black box that is used on planes, why can't they make the whole plane out of the same substance?After eating, do amphibians have to wait an hour before getting out of the water?Can fat people go skinny-dipping?You know how most packages say "Open here". What is the protocol if the package says, "Open somewhere else"?Would a fly without wings be called a walk?Why isn't there mouse-flavored cat food?Why isn't phonetic spelled the way it sounds?Why isn't "palindrome" spelled the same way backwards?Why is there an expiration date on SOUR cream?Why is the word "abbreviate" so long?do the ABC's and twinkle twinkle little star have the same tune?Why is the alphabet in that order? Is it because of that song?Why is Mickey Mouse bigger than his dog Pluto?why does Goofy live in a house and Pluto in and dog house if there both dogs?Why is it, whether you sit up or sit down, the result is the same?Why is it when two planes almost hit each other it is called a "near miss"?Why is it called 'after dark', when it is really after light?Why is it called a TV "set" when you only get one?why is a pair of underwear one item?Why is it called a "building" when it is already built?Why do we say something is out of whack? What is a whack?Why do women wear evening gowns to go out at night? Shouldn't they be wearing night gowns?Why is the man who invests all your money called a broker?Do Roman paramedics refer to IV's as "4's"?olive oil is made out of olives, and peanut oil is made out of peanuts. What is baby oil made out of?!If drinking and driving is illegal, why do bars have parking lots?If someone leads but no one follows... are they just out for a walk?After they make styrofoam, what do they ship it in?Are part-time band leaders semi-conductors?Before they invented drawing boards, what did they go back to?.............the list goes on and on, maybe i will make a sequel.i can not take credit for all of these, most of them were from this website

Topic by dsman195276    |  last reply