Indeed You alone know Yourself by Your internal potency O Supreme Person Origin of all Lord of all beings God of Gods Lord of the universe The Supersoul You are the Supreme Primal Objective You are the ultimate resting place of the universe You are inexhaustible and You are the oldest You are the maintainer of the eternal religion, the Personality of Godhead Oh master of the senses Oh Primal Lord O Limitless One God of Gods Refuge of the universe You are the invincible source The cause of all causes You are the knower of everything and all that is knowable You are the supreme refuge above the material modes O limitless form This whole cosmic manifestation is pervaded by You O unbounded power You are the master of limitless might You are all-pervading and thus You are everything Omniscient The ancient The Ruler of the whole world Minuter than the atom The supporter of all Of form inconceivable Effulgent like the Sun and Beyond the darkness There is nothing whatsoever higher than you You are the Sapidity in Water The Light in the Moon and the Sun You are the syllable OM in all the Vedas Sound in ether You are the Virility in men You are the sweet fragrance in earth and the brilliance in fire You are the life in all beings The austerity in the austere You are the eternal seed of all beings The intelligence of the intelligent You are the Splendor of the Splendid You are the Strength of the Strong Guest
Ajiri Morrison

Ajiri

Computer Scientist : HND Graduate, From Ozoro Polytechnic Delta State, Nigeria. Worked At Salus Trust LTD.

Wants to meet Work Partners : Preferably People Working On Any Programming Related Projects At The Moment. Send A Message

Articles
43
Followers
21

Make Your Zoom Background Come Alive. Top Sources To Get Your Green Screen Effect

You’ve Seen The Videos Where People Are Using The craziest Things As Backdrops for Their Zoom and Teams meetings. But Where Do T...
Ajiri Ajiri 2.9k
profile/1711PSX_20200322_135837.jpg
Ajiri
Make Your Zoom Background Come Alive. Top Sources To Get Your Green Screen Effect
~9.8 mins read
You’ve seen the videos where people are using the craziest things as backdrops for their Zoom and Teams meetings. But where do they get all those special effects? We’re going to share with you the 8 best online sources for green screen special effects.

What Is a Green Screen?The term ‘green screen’ has come to mean anything that allows two videos to be seamlessly overlaid on each other. A video is taken with the subject in front of a large green cloth. Video editing software is then used to replace the green parts of the first clip with another clip. This layers the two clips. 

This kind of editing can be done on almost any computer these days, but having a laptop powerful enough for video editing would be great. When done well, it presents a seamless integration of the two clips. The proper name for this process is ‘chroma key’.

YouTubeThe online home of amateur videos is the place to get the parts to build your videos. You‘ll need to know how to download videos from YouTube to make the best of these resources. 

There are dozens, maybe hundreds of YouTube channels dedicated to providing free green screen special effects. Some of the bigger channels include Green Screen Animation, Free Green HD, HD Green Screen, and BestGreenScreen. 

VidevoIf you’re looking for green-screen effects, motion graphics, music or sound effects, Videvo needs to be on your list. They have a variety of effects in resolutions from 720p to 4K. Some are premium clips you need to pay for, but there are a lot of free resources too. 

Videvo is especially helpful for green screen videos that allow you to present your content as though it’s on a tablet, computer, or phone.

PexelsA user-submitted stock site, Pexels offers thousands of creative resources. Everything is free to use, royalty-free, and attribution-free. It’s always nice to give credit to the creator though. The number of straight green screen effects is a bit limited, but there are a lot of backgrounds designed for use with a green screen. 

VideezyA freemium site with over 4,000 royalty-free green screen videos, Videezy sits in the middle of premium paid services and user-submitted free services. It works on a credit system. The more credits you buy, the cheaper the per credit price. 

Each pro video costs one credit, yet there are many free ones too. Filter search results by file type, license type, resolution, or format. Videezy makes it easy to find the right video for you.

GfycatYou might not think of green screens for animated gifs. But now that you know that’s a thing, Gfycat is a great resource for making your own animated gifs. 

Keep in mind that these are for animated gifs. They’re a choppy low frame rate, are very short, and low resolution. All the green screen gifs are free to use and user-submitted.  

PixabayAnother user-submitted content site, Pixabay is similar to Pexels. All the content is free for commercial use and no attribution is required. But please do make attributions if possible. There’s a coffee button on each file’s page to allow you to make a donation to the creator. 

The effects are high quality and range from flying subscribe buttons to numeric countdowns to device mockups.

ShutterstockA site with premium quality green screen effect stock is going to come at a premium price. If your project requires the best, then maybe Shutterstock is worth it. 

A single piece of footage can cost from $65to $179 depending on the resolution needed. The cost per clip can be reduced by purchasing one of their clip packs. Getting the 5 standard definition clip pack reduces the per clip cost to $59.80. The more you buy the less you pay per clip.

DepositPhotosThis site seems to have a lot of green screen footage of people presenting or doing things. There are device mockups and some transition effects as well. DepositPhotos is not free, but it may be the least expensive paid option. Depending on the definition needed, the price can be as low as $12.76 up to $169 per clip. 

It’s a good spot to find something a little more polished than the free stuff, but not as expensive as the network broadcast-quality stuff.

Make The Scene…The Green Scene!With a no budget or a very small one, and the resources above, you’re well on your way to putting together your own YouTube studio. Or maybe just integrate them into your video conferencing app? Perhaps use them while streaming on Twitch? 

Add some depth to your video with royalty-free sound effects or YouTube safe music. Once you have the tools to do green screen videos, the limits are up to you.

How To Easily Use The VLOOKUP Function In Microsoft Excel

Have You Ever Had A Large Spreadsheet With Data In Excel And Need An Easy Way To Filter And Extract Specific Information From It? ...
Ajiri Ajiri 896
profile/1711PSX_20200322_135837.jpg
Ajiri
How To Easily Use The VLOOKUP Function In Microsoft Excel
~12.6 mins read
Have you ever had a large spreadsheet with data in Excel and need an easy way to filter and extract specific information from it? If you learn how to use VLOOKUP in Excel, you can do this lookup with just a single, powerful Excel function.

The VLOOKUP function in Excel scares a lot of people because it has a lot of parameters and there are multiple ways to use it. In this article you’ll learn all of the ways you can use VLOOKUP in Excel and why the function is so powerful.

VLOOKUP Parameters In ExcelWhen you start typing =VLOOKUP( into any cell in Excel, you’ll see a pop-up showing all of the available function parameters.

Let’s examine each of these parameters and what they mean.

  • lookup_value: The value you’re looking for from the spreadsheet
  • table_array: The range of cells in the sheet you want to search through
  • col_index_num: The column where you want to pull your result from
  • [range_lookup]: Match mode (TRUE = approximate, FALSE = exact)
    • These four parameters let you do a lot of different, useful searches for data inside of very large datasets.

    A Simple VLOOKUP Excel ExampleVLOOKUP isn’t one of the basic Excel functions you might have learned, so let’s look at a simple example to get started.

    For the following example, we’ll use a large spreadsheet of SAT scores for schools in the United States. This spreadsheet contains over 450 schools along with individual SAT scores for reading, math, and writing. Feel free to download to follow along. There is an external connection that pulls the data, so you’ll get a warning when opening the file, but it’s safe.

    It would be very time consuming to search through such a large dataset to find the school that you’re interested in.

    Instead, you can create a simple form in the blank cells on the side of the table. To conduct this search, just make one field for School, and three additional fields for reading, math, and writing scores.

    Next, you’ll need to use the VLOOKUP function in Excel to make these three fields work. In the Reading field, create the VLOOKUP function as follows:

  • Type =VLOOKUP(
  • Select the School field, which in this example is I2. Type a comma.
  • Select the entire range of cells that contain the data you want to look up. Type a comma.
    • When you select the range, you can start from the column you’re using to look up (in this case the school name column), and then select all of the other columns and rows that contain the data.

    Note: The VLOOKUP function in Excel can only search through cells to the right of the search column. In this example, the school name column needs to be to the left of the data you’re looking up.

  • Next, to retrieve the Reading score, you’ll need to select the 3rd column from the leftmost selected column. So, type a 3 and then type another comma.
  • Finally, type FALSE for an exact match, and close the function with a ).
    • Your final VLOOKUP function should look something like this:

    =VLOOKUP(I2,B2:G461,3,FALSE)When you first press Enter and finish the function, you’ll notice the Reading field will contain an #N/A.

    This is because the School field is blank and there is nothing for the VLOOKUP function to find. However, if you enter the name of any high school you want to look up, you’ll see the correct results from that row for the Reading score.

    How To Deal With VLOOKUP Being Case- SensitiveYou may notice that if you don’t type the name of the school in the same case as how it’s listed in the dataset, you will not see any results.

    This is because the VLOOKUP function is case sensitive. This can be annoying, especially for a very large dataset where the column you’re searching through is inconsistent with how things are capitalized.

    To get around this, you can force what you’re searching for to switch to lowercase before looking up the results. To do this, create a new column next to the column you’re searching. Type the function:

    =TRIM(LOWER(B2))This will lowercase the school name and remove any extraneous characters (spaces) that might be on the left or right side of the name.

    Hold down the Shift key and place the mouse cursor over the lower right corner of the first cell until it changes to two horizontal lines. Double click the mouse to autofill the entire column.

    Finally, since VLOOKUP will try to use the formula rather than the text in these cells, you need to convert them all to values only.  To do this, copy the entire column, right click in the first cell, and paste values only.

    Now that all of your data is cleaned up in this new column, slightly modify your VLOOKUP function in Excel to use this new column instead of the previous one by starting the lookup range at C2 instead of B2.

    =VLOOKUP(I2,C2:G461,3,FALSE)Now you’ll notice that if you always type your search in lower case, you’ll always get a good search result.

    This is a handy Excel tip to overcome the fact that VLOOKUP is case sensitive.

    VLOOKUP Approximate MatchWhile the exact match LOOKUP example described in the first section of this article is pretty straightforward, the approximate match is a little more complex.

    The approximate match is best used to search through number ranges. To do this correctly the search range needs to be properly sorted. The best example of this is a VLOOKUP function to search for a letter grade that corresponds to a number grade.

    If a teacher has a long list of student homework grades from throughout the year with a final averaged column, it would be nice to have the letter grade corresponding to that final grade come up automatically.

    This is possible with the VLOOKUP function. All that’s required is a lookup table off to the right that contains the appropriate letter grade for each numerical score range.

    Now, using the VLOOKUP function and an approximate match, you can find the proper letter grade corresponding to the correct numeric range.

    In this VLOOKUP function:

  • lookup_value: F2, the final averaged grade
  • table_array: I2:J8, The letter grade lookup range
  • index_column: 2, the second column in the lookup table
  • [range_lookup]: TRUE, approximate match
    • Once you finish the VLOOKUP function in G2 and press Enter, you can fill in the rest of the cells using the same approach described in the last section. You’ll see all of the letter grades properly filled in.

    Note that the VLOOKUP function in Excel searches from the bottom end of the grade range with the assigned letter score to the top of the range of the next letter score.

    So, “C” needs to be the letter assigned to the lower range (75), and B is assigned to the bottom (minimum) of its own letter range. VLOOKUP will “find” the result for 60 (D) as the closest approximate value for anything between 60 to 75.

    VLOOKUP in Excel is a very powerful function that has been available for a long time. It is also useful for finding matching values anywhere in an Excel workbook.

    Keep in mind, however, that Microsoft users who have a monthly Office 365 subscription now have access to a newer XLOOKUP function. This function has more parameters and additional flexibility. Users with a semi-annual subscription will need to wait for the update to roll out in July 2020.

    Advertisement

    Loading...

    Link socials

    Matches