English, Tutorials

Extracting Geographic Coordinates from Spreadsheet Cells [and Converting THEM]

Geographic coordinates are numbers used to locate elements, objects, places (etc) on the Earth’s surface. Our planet is vertical and horizontally divided in angles, which are called longitude and latitude, respectively.

Spreadsheets are a very good way to arrange a great range of information, including coordinates. But if they are used carelessly, it can bring headaches from other planets… Especially if you want to extract a piece of information from a cell, i.e. remove useless information.

Suppose you have a huge spreadsheet with many geographic coordinates (e.g. 28°40′39″S 49°22′11″W) and you need to separate the degrees, minutes and seconds from each other. This is necessary, if your GIS software only accepts decimal degrees. One way (the hardest way), is to edit each cell and copy and paste to another cell… boring and time consuming. Another way is to create a function (formula) that can do this for us!

Continue reading “Extracting Geographic Coordinates from Spreadsheet Cells [and Converting THEM]”

English, Environment

A Little About Cooking Oil

Cooking oils are present in most Brazilian households. In some,  they‘re used for seasoning, in others for frying, but their final destination is usually the same: the drain or the garbage.  Most people are unaware that vegetable oil can cause a large amount of damage to the environment when discarded incorrectly.

Oils and fats can be of animal or vegetable origin and are, by definition, insoluble substances; that is, they do not mix with water. Vegetable oil, which is the basis of most cooking oil, can be obtained from various plants or seeds, such as buriti, castor bean, soybean, canola, sunflower, corn, etc. Continue reading “A Little About Cooking Oil”

Environment, Français

À propos de l’huile de cuisson

lls sont présents dans la plupart des foyers brésiliens, certains servent à tempérer, d’autres à fouetter, mais leur destination finale est généralement la même: l’évier ou la poubelle. Les huiles végétales, bien que beaucoup ne le savent pas, sont à l’origine de grands dommages sur l’environnement lorsqu’elles sont disposées de manière inappropriée.

Continue reading “À propos de l’huile de cuisson”

Français, Science

Qu’est qu’il y a dans autres planètes?

Les scientifiques découvrent de nouvelles planètes tous les jours, connaissent leur position et de quoi elles sont composées. Récemment, mon professeur d’Anglais m’a demandé comment les scientifiques peuvent savoir de quoi sont faites ces planètes si personne ne les a visitées ! Et la réponse est la lumière. Oui, la lumière.

Continue reading “Qu’est qu’il y a dans autres planètes?”