TEA RATING: ☕
If you are struggling to query your date in an excel sheet, you can use index(match()) formula to lookup. Unlike vlookup or hlookup, index(match()) is more flexible and more roboust.
Continue reading TEA BREAK WITH EXCEL: ALTERNATIVE TO VLOOKUP/HLOOKUP, INDEX(MATCH())Tea Rating: ☕
To find a specific text in a specific range we are using the formula;
Continue reading TEA BREAK WITH EXCEL: FINDING A SPECIFIC TEXT IN A CELL RANGE (OR IF THIS TEXT IS INCLUDED IN THIS RANGE OR NOT?)Think about an object floating in a water. There are two forces acting on the object in this case which are upthrust of water and weight of the object. These two forces must be equal so that the object can float in the water.
Continue reading BOUYANCY FORMULA FOR FLOATING OR SUSPENDED (BALANCED IN FLUID) OBJECTSThe formula for specific weight, or in other words weight per unit volume is;
Continue reading SPECIFIC WEIGHT FORMULAIf we mix two liquid with the same volume;
Continue reading DENSITY OF A MIXTURE EASY WAY TO CALCULATE FOR SAME MASS AND SAME VOLUME MIXTURESIf we measure weight with balance like shown below;
Continue reading WEIGHT MEASURMENT WITH BALANCEHere is the formula for the volume of a cone;
Continue reading VOLUME OF A CONETo select a light bulb very first step is defining the need for lighting. The lighting is categorised into two sections which are ambient lighting and task lighting.
Continue reading HOW TO SELECT A LIGHT BULBIf an object is under effect of 2 forces where there is an alpha angle between them;
Continue reading CALCULATING RESULTANT FORCE