If you wanna follow the explanation of this post by looking at cell references, go to this post: Taking Microsoft Office Excel Web App for a spin

I’ll show you a practical use of the CountIf function that you can apply in both Microsoft Excel spreadsheets and Google Docs spreadsheets.

Let’s start with this sample spreadsheet:

I’m using the above spreadsheet to keep track of my progress during the course for my first driver’s license.

The CountIf function is being used in column Remaining classes for each discipline. For example, the actual formula in cell I17 is this:

I17 = H17 - countif(D3:I14, B17)

Let’s break this thing and explain each piece:

H17 is a fixed value = 18. I know it beforehand. In this case for the Transit Legislation discipline I must have a total of 18 classes.

The countif function has this form: COUNTIF(range, criteria). So the above countif(D3:I14, B17) is telling us that:

D3:I14 is the range of cells we’re searching and B17 is what we’re after… The range encompasses all the disciplines’ acronyms from 11/23/2010 to 12/9/2010 for all the timetable.

B17 is the discipline’s acronym, in this case it is TL.

Easy to understand, isn’t it?

Doing the above with countif I can tell how many classes I have scheduled for that discipline. Then I just subtract this value from the total necessary classes to have a picture of how many classes I still have to go through to fulfill the necessary ones.

Let’s do the math:

CountIf returns 18 because LT appears 18 times in the timetable. Making the substitution of values:

I17 = H17 - countif(D3:I14, B17)
I17 =  18 - 18 = 0

Now I know that if I follow the above schedule I’ll probably finish the theoretical course by 12/9/2010. Pretty good.

This was a simple and practical use of the countif function that came in handy in this situation.

Permit me to go a little bit "off topic" with this post… is it really off topic to a computer professional?

I know this is kinda of cliché and that it may scares you, but physical activity is a human necessity and as such it deserves special attention. So here I am writing about it hoping that someone that reads this takes notice and start acting right away. Do not leave for tomorrow what you can do today! Yet another cliché I know but it is perfect in this phrase.

People of my "professional class" and also from my generation also known as generation Y are the ones most impacted by the lack of physical exercises in this modern age of ours. In our age we are completely immersed in technology with products that make us want to avoid the outsides. Just to name a few: computers, internet, video games, delivery services, etc.

One thing that I as a computer engineer "have done" in the past 7 to 8 years was not moving my body to the extent needed.

When I was a kid ( 6 to 11 years old ) I used to play soccer almost 7 days a week. I lived near a soccer field. Then I moved to Volta Redonda where I live now and it ceased to happen.

In Volta Redonda I used to go to school every day cycling, that was about 6 KM (this route in Google Maps) each day. I used to play soccer with my street friends in front of my house (this green field seen in Google Street View) at least once a week, but as we all grew up we just did not keep contact and then the soccer games disappeared. I also used to go to Águas Quentes Country Club Resort "near" my house that has a lot of pools to practice swimming and that is now just past as well. I am not a member of the club anymore.

People that work with computers pass a lot of time fixed in a single place (programmers do it more frequently) as is my case and this tends to cause bad consequences to the body. Lots and lots of articles and TV programs debate this theme and lots and lots of people just do not give the necessary attention to this subject.

I am writing about this because I think it is crucial to our lives, that is, we were made to be in constant movement and it makes sense to expose my point of view since I am an avid user of computers and everything in between. Maybe this post will even serve as a start point to someone studying the impact of modern life in human health. What does a generation Y guy think about the subject? So here it is…

I definitely started to pay attention to this only after almost 2 years working at Chemtech. The work rhythm is intense and for someone that is starting in the job market, exercising can be a point of no interest and if you do not wake up to reality things can get worrisome. We had gymnastics at the workplace but that was not really something that I would call exercising, you know. While at Chemtech, on the weekends I was always inclined to rest since I was tired of working the whole week.

OK. What have I found? We need a way of moving our body, working out for at least 30 minutes a day. You can do the kind of exercise that is a best fit to you, but the thing is: do something to move your body. Do not tie yourself to the same routine each and every day - car/bus to workplace, seat, a little walking to have lunch, in a sitting position again and then car/bus to home.

Since I started college in 2003 my exercising level downgraded to unacceptable levels. To correct this, one thing that I started doing lately was going to the gym to stretch my muscles – 5 days a week – 1/1.5 hours a day.

I am in the 3rd month mark now and I am really satisfied with the results because my overall mood got better and now I know I am contributing to my body and health. Body, Mind and Soul must be in synchrony.

The benefits of physical exercising are numerous and if you want to know more about them, refer to this article.

If you can not go to the gym: go walking/cycling to your workplace, do stair climbing (avoid elevators), but definitely do something that puts your body in movement. Start slowly and then increase the pace. You will see that as times goes by it starts to be a part of your day and the day you do not exercise you feel something is wrong/missing. Your body will ask for it. Amazing, isn't it? This is only a part of what we need to keep a healthy life. Of course, what you eat will have great impact in your health. Exercising alone will not be sufficient. Watch out for your way of life.

I think the point is: we all know that these are difficult days and that arranging all this stuff seems daunting enough. We already have a bunch of things to do but what if we do not keep close attention to our body health? We will not have anything else to be preoccupied with because maybe we will not be able to do that bunch of things again without a capable body. Did you get the point? I hope so.

An advice from an intensive computer user to everyone out there that thinks that exercises are not important: exercises do make a difference in life even more if you are a computer professional that depends on computers to get things done. It is better to start early and to keep it a constant in your life. You will save yourself and your money from doctors, medicines, hospitals, etc., that is, while it is not a guarantee it is most probably that you will save yourself from suffering. You will get a better quality of life having fun along the way.

Shake Yourself! I am linking to a Yes song titled Owner of a Lonely Heart that passes the message.

Updated on 12/30/2013

I’ve quit the gym because after 2 to 3 years there things started to get boring. I prefer the outdoors and cycling is my favorite exercise. The feeling I get while pedaling is inexplicable.

If you happen to own a mobile device, there’s a great app to keep track of your activity be it running or bike riding. It’s called Strava.

Here’s my latest activity:

Complementary reading

Sitting is Making You Fat and Killing You by Phil Haack

While applying to a masters degree course I had to write an essay of no more than 500 words containing:

1. Personal appreciation about the evolution of my academic and professional activities up to now, avoiding the mere repetition of information already contained in my resume/CV.
2. Succinct description about the reasons I have to take a post-graduation course and what I expect from the course.
3. My expectations regarding the post-graduate course's influences in my future professional activities.
4. Specification of topics of interest, trying to correlate them with the research area of the program I'm applying to.

So far so good.

I have sent my enrollment docs to two of the best universities in the Rio de Janeiro state in Brazil, namely: UFRJ and PUC-Rio. Both of them have the highest assessment grades ( 7 ) conferred by CAPES. CAPES is the Brazilian government agency responsible for the evaluation of post-graduate courses.

I applied for two research areas: Software Engineering and Artificial Intelligence.

The essay I'm posting here (English and Portuguese versions) is from the UFRJ enrollment process (Software Engineering one) in which I applied to the Systems and Computer Engineering Program (site in Portuguese).

Now I hope to be called for at least one of these institutions. UFRJ process requires the applicant to take some tests: language test (English) and specifics test (the research area you're applying to) and both counts towards the acceptance.

---

Essay
I have been trying for almost three years now (since the graduation in Computer Engineering in Dec/2007) to apply at work and in my life the content I learned.

I succeeded in my last job at Chemtech because I had a good background provided by the Computer Engineering course. During the course, the disciplines that really caught my attention were those related to software. In this last job experience I could put into practice the theory seen at the university in my first level degree. I participated in several interesting software projects. I found this way the importance of theory in the activities of a computer professional.

My motivation to continue the studies through a masters course exists since I finished the first level degree. Meanwhile, between the graduation and the master's degree, I got a job. One of the reasons that made me quit that job was simply because I wanted to continue studying. I attended great part of the university only studying, which allowed me to have a good performance. Likewise, I wish to attend the masters in full time.

I want to take the post-graduate course to:

1 - Learn and get a deep understanding of the software area;
2 - Improve what I know;
3 - Grow as a computer professional;
4 - Get better opportunities in the job market.

My expectations for the course are the best. I know the the course and institution reputation and I know I can learn a lot. This is my main goal: to learn more and with quality. I am hungry for knowledge!

After the masters and possessing more advanced knowledge, I intend to pursue a career in software. The software engineering market is "young" compared to others and has shown steady growth in recent years. I believe that this market will provide excellent opportunities for the professional who has a post-graduate degree in the area. Money Magazine and Salary.com site rated the area of Software Engineering as the best area to work in 2006. This demonstrates and attests this area's power and influence in the global market. When I mention a career, I think of software companies or even in educational institutions as a teacher/university researcher. Any of these options I choose will satisfy me as a person and as professional. If I decide to go with a software company, I hope to contribute with a deeper view on the aspects involving software projects. Otherwise, I hope to be able to disseminate advanced knowledge in the area, teaching people. Brazil in particular has a deficit of engineers and particularly in the area of software engineering, which is a technology area that adds greater value and therefore contributes more effectively to the growth of our country.

My interest in the area of software engineering is focused on the development of software products. I love writing code, and consequently the programming languages, solve programming problems, study the software tools used in development and all the metrics involved and any possible subject that is related to software engineering.

See:

http://www.leniel.net
http://stackoverflow.com/users/114029/leniel-macaferi

---

Redação
Tenho buscado nestes quase 3 anos de formado em Engenharia de Computação aplicar no trabalho e nada vida o conteúdo que aprendi.

Tive êxito em minha última experiência profissional devido à base proporcionada pelo curso de Engenharia de Computação. Durante o curso, as matérias que mais chamaram minha atenção foram aquelas ligadas a software. Nesta última experiência profissional pude colocar em prática a teoria vista na faculdade. Participei em vários projetos de software interessantes. Constatei dessa maneira a importância da teoria nas atividades do profissional de computação.

Minha motivação para dar continuidade nos estudos através de um curso de mestrado existe desde que terminei o curso de graduação. Neste meio tempo, entre a graduação e o mestrado, consegui um emprego. Um dos motivos que me fez sair desse emprego foi justamente o de querer continuar os estudos. Cursei a maior parte da graduação somente estudando, o que me permitiu ter um bom aproveitamento. Da mesma forma, desejo cursar o mestrado com dedicação exclusiva.

Quero fazer o curso de pós-graduação para:

1 - Aprender e me aprofundar mais na área de software;
2 - Aprimorar o que sei;
3 - Crescer como profissional da área;
4 - Conseguir melhores oportunidades no mercado de trabalho.

Minhas expectativas quanto ao curso são as melhores. Conheço a reputação do curso e da instituição e sei que poderei aprender bastante. Este é o meu principal objetivo: aprender mais e com qualidade. Sou faminto por conhecimento!

Após o mestrado e de posse do conhecimento mais avançado, pretendo seguir carreira na área de software. O mercado de engenharia de software é "jovem" se comparado a outros e tem apresentado constante expansão nos últimos anos. Creio que este mercado proporcionará excelentes oportunidades para o profissional que possui uma pós-graduação na área. A revista Money Magazine e o site Salary.com, classificaram a área de Engenharia de Software como a melhor área para se trabalhar no ano de 2006. Isso mostra e atesta o poder e influência da área no mercado global.Quando menciono seguir carreira, penso em empresas de software ou até mesmo em instituições de ensino como professor/pesquisador universitário. Qualquer uma dessas opções que eu escolher me satisfará como pessoa e profissional. Caso eu siga em uma empresa de software, espero contribuir com uma visão mais ampla sobre os aspectos que envolvem os projetos de software. Caso contrário, espero ter a possibilidade de disseminar o conhecimento avançado na área, ajudando a formar pessoal capacitado. O Brasil em especial tem um déficit na área de engenharia e particularmente na engenharia de software, que é uma área tecnológica que agrega maior valor e portanto contribui de maneira mais eficaz para o crescimento do nosso país.

Meu interesse pela área de engenharia de software é centrado no desenvolvimento do produto de software. Amo escrever código e consequentemente as linguagens de programação, resolver problemas de programação, estudar ferramentas de software usadas no desenvolvimento e todas as métricas envolvidas e qualquer outro assunto possível que seja relativo à engenharia de software.

Veja:

http://www.leniel.net
http://stackoverflow.com/users/114029/leniel-macaferi