Tags » Quick Tips

Trim Video using FFMPEG

Hi,

I recently needed to trim a video as I wanted to remove the intro part. I found a really easy way to do this and anyone can do this from home using their own computer for free. 242 more words

Quick Tips

CineRender - Bitmap Image Rectangles

CineRender R14 has an error sometimes when rendering bitmap images, even with the standard scenes – the transparent rectangle is shown faded around the image. Usually this goes away just as randomly as it came by next time you launch ARCHICAD, but there is also a workaround to make them disappear right away. 24 more words

Archicad

Errores comunes de Agentes de Bienes Raíces

  1. Fotografías mal implementadas.

Una de las cosas que uno debe de tener como prioridad para vender una propiedad es tener fotografías bien hechas.

  1. Falsas promesas.
  2. 398 more words
Mortgage

Excel cheat sheet for data analysis (Series – I)

Source is the key data being identified
Base is the column or array used for identification
 

Compare two columns and find # matching Source in a different row
=MATCH(Source, Base, 0)
=MATCH(A2,B:B,0)

Compare two columns and copy value matching against Source in a different row
=INDEX(Base,MATCH(Source,Base,0),1)
=INDEX(B:B,MATCH(A2,B:B,0),1)

Alternatively using VLOOKUP
=VLOOKUP(A2,B:B,1,TRUE)

Compare Source in column and copy different cell value when value matches against Source
=INDEX(Table,MATCH(Source,Base,0),1)
=INDEX($B$2:$E$8,MATCH(A2,$B$2:$B$8,0),3)

Alternatively using VLOOKUP
=VLOOKUP(A2,$B$2:$I$8,3,FALSE)

Compare two Sources in two different column and copy cell value when value matches with matching Source values*
=INDEX(Table,MATCH(1,(Base=Source1)*(Base=Source2),0),5)
=INDEX($A$2:$E$8,MATCH(1,($B$2:$B$8=A5)*($D$2:$D$8=C5),0),5)

*Press ctrl+Shift+Enter to effect function… 28 more words
Compare Two Values In Excel

No Buttermilk, No Problem

If you are like me, you don’t keep buttermilk in the refrigerator. It is not one of the staples I buy on a regular basis. However, it does add something extra special to homemade pancakes and biscuits. 231 more words

Cooking

Quick Tip: FLEx

Thanks to all of you who have responded to the Commit to Try Survey from last Friday. (If you haven’t filled it out yet, you can… 163 more words

In-Service

Quick tip

It’s finally spring and you know you will be bringing way more blooms into your house. Well I have a nifty little tip for you to make your flowers look perky. 30 more words