Posts

Posted on

Excel Help Request [Solved]

[Edit] Problem solved, using a SumIF ended up fixing both of my problems. Thanks to Mr. Feraudo. [/Edit]

For you Microsoft Excel experts out there, I have data on the scoring for an individual player and I am trying to figure out the use of a formula or two to calculate the following: I need to calculate the number of goals a person scored at Home (or Away) without individually counting them and then do the same thing for games in which the player’s team Won or Loss.

I thought about using CountIf but I’m not sure how to count items from a range of data based on a criteria that is not necessarily in the range. For example, if I want to count items from the Goals column based upon whether the Location is Home or not. Also, I’m not too familiar with using the Offset formula to calculate a column’s worth of data in a single cell as opposed to repeat it for every cell.

Any suggestions would be greatly appreciated. Even if you think you have something that might work but you aren’t too sure, feel free to shoot me an email or talk to me online about it.


 

Posted on

First Coach’s Corner Interview

Earlier this week, the Stevens Athletics Department launched its own YouTube channel. It is a pretty good way to share views of the coaches, student-athletes and even some game footage from the games that take place. I think they have done a pretty good job adapting the change in social media by connecting with fans through Twitter, Facebook and now YouTube.

The first interview was conducted by Rob (our Sports Information Director) which was done two days ago with the Head Baseball Coach John Crane and the second one, which is embedded below, is my first one with Head Women’s Lacrosse Coach Celine Cunningham.

There are going to be more of these as the semester progresses and selfishly, it is quite unfortunate this is all starting in my last semester. However, comparing it to how things were when I first started school here — the change has been awesome.

Blame the darkness of the video on a gloomy, rainy day in Hoboken but I thought the interview went beautifully and Celine is always a pleasure to talk to, both on and off the record. She’s a huge Maryland fan and she took some Duke jabs at me before the interview so I’m homing Coach K and company take care of business in the ACC.

While watching this video, please be critical towards me — as critical as you can get, as I want to use this to improve my own techniques like I definitely should have had a straighter posture and maybe applied a couple of follow up questions. What else do you suggest?

To view this video at the Stevens YouTube Channel, click here.

Posted on

Red Sox Nation Commercials

I can’t really wait for the baseball season to start so in the meantime, enjoy these two Red Sox Nation commercials going after the Yankees in the meantime.

There have been plenty of angry comments on both of those videos by the bandwagon New York fans and I guess it doesn’t really surprise me. One would think after all these many years, they would understand what a rivalry is but I guess that might be expecting too much from them. Visit the You Tube page by clicking on the video to view the comments directly from the source.

Posted on

One Last Fascist Email (Hopefully)

Well there was one final “warning” sent about 8pm tonight and this one might have been sent out to the entire Stevens community as opposed to the other ones being just to those residing in off-campus housing.

Enjoy:

To:     Stevens Community
From:   Kenneth Nilsen, Dean of Student Life
Date:   March 5, 2010
Re:     Hoboken St. Patrick’s Day Parade

The Hoboken St. Patrick’s Day Parade and associated city-wide partying will take place on Saturday, March 6, 2010.  This event brings thousands of people to Hoboken which in the past has created issues related to public intoxication, public indecency and general safety concerns.

As a result, Hoboken Police have established a “Zero Tolerance Policy” for open containers, public urination, excessive noise from house parties, and disorderly conduct. .  Specifically, the Hoboken Police along with the Hudson County Prosecutors Office will have officers (uniformed and plain clothes) enforcing the following ordinances:

  1. City Ordinance 145-23 A/B (Consumption of Alcohol/Open Container in Public)- Any person seen possessing an open container of alcohol in public faces maximum penalties of a fine up to $2,000, and the possible sentence of having to perform Community Service.
  2. City Ordinance 145-22 (Urinating in Public)- Any person observed urinating on public streets, sidewalks or in parks faces maximum penalties of a fine up to $2,000, and the possible sentence of having to perform Community Service.
  3. New Jersey State Statute 2C:33-12 (Maintaining a Nuisance) – House parties have become our largest problem on the parade day. The maximum penalties for this offense are imprisonment of up to 6 months and fines not to exceed $1,000.
  4. New Jersey State Statute 2C: 33-2a (Disorderly Conduct, Improper Behavior) – A Person is guilty of disorderly conduct if “with purpose to cause public inconvenience, annoyance or alarm, or recklessly creating a risk thereof he, (1) Engages in fighting or threatening, or in violent or tumultuous behavior, or (2) Creates a hazardous or physically dangerous condition by any act which serves no legitimate purpose.” This offense carries maximum penalties of a 30 day prison term and a fine not to exceed $500.

The best approach is to act in responsible manner and avoid any behavior that makes you or your friends a target for a police officer response. If you have any questions, please contact Stevens Police at 201-216-5105.

Posted on

Muslim-American To Speak At Stevens

I got this email just about half an hour ago stating that as part of Women’s Programs and Graduate activies, Zainab Al-Suwaij will be hosting “Women’s Equality in the Muslim Word” on Tuesday, March 23, 2010 at 9:00 PM in the De Baun Auditorium.

The e-mail states:

At the age of 20, Zainab was one of the few women to join the 1991 intifada uprising against Saddam Hussein. After it’s failing, she went into hiding and eventually fled to the US where she became and citizen and a respected professor at Yale.

Co-founder of the American-Islamic Congress, Zainab provides an eye-opening account of her experiences as a Muslim-American & serves as a bridge across cultures, religious divides, & political differences.

I don’t think I have ever heard of the American Islamic Congress where she holds the position of Executive Director but this is their mission statement:

The American Islamic Congress (AIC) is a civil rights organization promoting tolerance and the exchange of ideas among Muslims and between other peoples. AIC challenges increasingly negative perceptions of Muslims by advocating responsible leadership and ‘two-way’ interfaith understanding. As Muslim-Americans, thriving amidst America’s open multicultural society and civil liberties, we promote these same values for the global Muslim community.

So I think any civic organization that is working towards achieving moderation and promoting tolerance between people of different faiths is certainly something worth listening to.

I will be attending the event later this month and will hopefully be able to provide a follow up to the event. If you go to Stevens or are even in the area, I urge you to attend and take a look for yourself and make your own judgment and even take part in the discussion on culture, religion and gender.

For more information on Zainab Al-Suwaij, please visit American Islamic Congress.