$3 Per Year Web Hosting

Tuesday, 30 January 2018

How to Install Groupme on Android

This wikiHow teaches you how to download the GroupMe app and create a new account, using Android.

EditSteps

EditInstalling the App

  1. Open the Play Store on your Android. Find and tap the icon on your Apps menu to open the Play Store.
    Install Groupme on Android Step 1.jpg
  2. Tap the search bar. The search bar reads Google Play at the top of your screen. You can enter any keyword here to search the apps, books, or movies on the Play Store.
    Install Groupme on Android Step 2.jpg
  3. Type into the search bar.
    Install Groupme on Android Step 3.jpg
    • The search function is not case-sensitive. You don't have to capitalize any letters here.
  4. Tap or on your keyboard. This will search the store, and list all the matching results on a new page.
    Install Groupme on Android Step 4.jpg
    • If you're using Google Keyboard, tap the green magnifier icon on the bottom-left.
  5. Find and tap the GroupMe app in the search results. The GroupMe icon looks like a blue speech bubble with a white "#" icon in it. Tapping it will open the app info page.
    Install Groupme on Android Step 5.jpg
  6. Tap the green button. This button is located below the GroupMe icon on the app info page. It will download and install the app on your Android.
    Install Groupme on Android Step 6.jpg
    • If you see a button that says OPEN instead of INSTALL, this means you already have the app installed on your Android.
  7. Wait for your download to finish. You will see a green progress bar on the app info page that shows your download rate. When your download hits 100%, the progress bar will disappear.
    Install Groupme on Android Step 7.jpg
  8. Wait for the app installation to finish after the download. When your download is finished, your Android will have to install the downloaded app. The app page will indicate "Installing".
    Install Groupme on Android Step 8.jpg
  9. Tap the green button. When the app is installed and ready to go, you will see a white UNINSTALL button and a green OPEN button on the app page. Tapping this button will open the app.
    Install Groupme on Android Step 9.jpg

EditCreating a New Account

  1. Enter your email address on the login screen. Tap the Enter your email address field at the bottom of the login screen, and enter the email you want to sign up with.
    Install Groupme on Android Step 10.jpg
    • Alternatively, you can sign up with a social media account by tapping one of the Google, Facebook, or Microsoft icons. This will automatically import your email address and personal info from your social media account.
  2. Tap the white checkmark icon. This button is in the upper-right corner of your screen. It will take you to the Sign Up form.
    Install Groupme on Android Step 11.jpg
  3. Enter your name in the field. This will be your display name, and all of your friends will see you by this name in your group chats.
    Install Groupme on Android Step 12.jpg
  4. Create a new password in the field. Make sure you enter a secure password here. You will use this password to log into your account.
    Install Groupme on Android Step 13.jpg
  5. Tap and check the box next to "I agree to the Terms of Service and Privacy Policy." You can't create a new account without agreeing to these terms.
    Install Groupme on Android Step 14.jpg
    • If you want to read the Terms of Service or the Privacy Policy, just tap it here.
  6. Tap the white checkmark icon. This button is in the upper-right corner of your screen. It will create your new account, and take you to the Verify Phone Number page.
    Install Groupme on Android Step 15.jpg

EditVerifying Your Phone Number

  1. Tap on the Verify Phone Number page. This is a blue button at the bottom of your screen. It will let you link your phone number to your new GroupMe account.
    Install Groupme on Android Step 16.jpg
    • Alternatively, you can select Verify a Different Phone Number and enter a different phone number. As long as you make sure you can receive a call or text message, any number is fine.
  2. Tap in the pop-up window. Your Android will ask if you want to allow the GroupMe app to make calls. Tap Allow here if you want to receive your verification code via phone call.
    Install Groupme on Android Step 17.jpg
  3. Tap in the pop-up window again. Your Android will now ask if you want to allow the GroupMe app to send text messages. Tap Allow here if you prefer to receive your verification code via SMS.
    Install Groupme on Android Step 18.jpg
  4. Enter your verification PIN code. GroupMe will send your phone number an SMS text message with a 4-digit verification PIN code in it. Tap the PIN field here and enter your verification code.
    Install Groupme on Android Step 19.jpg
  5. Tap the white checkmark icon. This button is in the upper-right corner of your screen. It will verify your PIN code, and take you to the welcome screen.
    Install Groupme on Android Step 20.jpg
  6. Tap the button. This button is located in the lower-left corner of the welcome screen. It will skip the welcome tips, and take you to the GroupMe app. You can now start your first group.
    Install Groupme on Android Step 21.jpg
    • Alternatively, swipe left on your screen or tap the blue arrow on the bottom-right to see all the tips.


from How to of the Day http://ift.tt/2nriBa5
via Peter

STOP WHAT YOU'RE DOING AND LOOK AT THESE DOGS SITTING LIKE PEOPLE

They attacc, they protecc, but most importantly, they relaccccccc.

"Bring me my scotch."

Instagram: @mallophaga

"Wait, is Meryl ACTUALLY gonna be on Big Little Lies?!"

Instagram: @adorabull

"Jeez, you drive like an escaped felon, Richard!"

Instagram: @allizzent

"Shit! Is it my turn to pick the kids up from school?"

Instagram: @teekafraser

"Cheryl, I know you wanted to spice things up in the bedroom, but THIS?!?!?!"

Instagram: @coupleofcockers_

"All that's ever on the news these days is incoherent barking."

Instagram: @caitlinsok

*Drags cigarette* "The company is downsizing and the first division they're making cuts to is — you guessed it — sales."

Instagram: @bugandpennypugparty

"I brought orange slices for halftime for the little soccer stars!"

Instagram: @swijnen

"If I'm being totally honest, I'm a little worried about your excessive butt-sniffing, Denise."

Instagram: @danelifewith_kumah_and_nala

"This episode of Black Mirror is getting too real..."

Instagram: @thelauraaurora

"When will my husband return from war?"

Instagram: @yohubbabubba

"I know the breakup's been hard man, but you gotta get back in the game."

Instagram: @notoriousruthie

"Men can be so heartless, Jessica. I need another mimosa."

Instagram: @xhellguelx

"There, there. It okay."

Instagram: @zillaandfriends

"Nothing to see here, just a man and his plushy cowboy..."

Instagram: @louie_lefrenchie_

"We'll get the assorted cheese platter to start. Right, my love?"

Instagram: @monsieurcheffy

"Crackin' open a cold one with the boys, gnawing on tennis balls... This is frickin' chiiiiiiiiiiiiiiill."

Instagram: @sennathepotato

"I know this sounds silly, *girlish giggle* but I feel like I've known you forever..."

Instagram: @a__barber

"If I sees a bench, I sits."

Instagram: @taleofanomad

"You gonna pass the popcorn or what?"

Instagram: @franongram

"So what job are you hoping to get with that degree in ceramics? I think everyone here would LOVE to know."

Instagram: @lokellogg

*Listens to "A Thousand Miles" by Vanessa Carlton in a prius*

Instagram: @mburds



from BuzzFeed - Animals http://ift.tt/2DOhFYf
via IFTTT

This Cat's Relationship With A Space Heater Is Basically All Of Us This Winter

Cold weather goals.

Meet Busao-san: a cat living in Japan who is doing winter right:

Meet Busao-san: a cat living in Japan who is doing winter right:

@tanryug / Via Instagram: @tanryug

Sure, it's been a season of freezing temps, slushy snow, and some bombogenesis bullshit, but as Busao-san proves, nothing else matters when you've got your space heater close.

Sure, it's been a season of freezing temps, slushy snow, and some bombogenesis bullshit, but as Busao-san proves, nothing else matters when you've got your space heater close.

So cozy. So toasty.

@tanryug / Via Instagram: @tanryug

There are people out there who will insist that January and February are great months for going out and ~adventuring~ outdoors. Those are not your people.

Busao-san and this heater are.

Instagram: @tanryug

Besides, Busao-san would like to point out that you can do PLENTY of activities indoors.

Besides, Busao-san would like to point out that you can do PLENTY of activities indoors.

Such as: not being cold.

@tanryug / Via Instagram: @tanryug

He personally enjoys staring into the electric coils of his heater...

He personally enjoys staring into the electric coils of his heater...

ぶさお&りん / Via Facebook: busaophoto

And taking naps nearby...

And taking naps nearby...

ぶさお&りん / Via Facebook: busaophoto

And touching it, just to feel extra warmth.

And touching it, just to feel extra warmth.

Moar heat make him strong.

@tanryug / Via Instagram: @tanryug

And if you don't have a space heater, Busao-san also recommends sitting next to other large, warm objects.

And if you don't have a space heater, Busao-san also recommends sitting next to other large, warm objects.

ぶさお&りん / Via Facebook: busaophoto

But for max toastiness, nothing beats this:

But for max toastiness, nothing beats this:

ぶさお&りん / Via Facebook: busaophoto

See y'all in the spring! If anyone needs us, we'll be pulling a Busao-san and staying put.

Check out Busao-san's Facebook for more heart~warm~ing pictures and videos!

Instagram: @tanryug

This post was translated from Japanese.



from BuzzFeed - Animals http://ift.tt/2DNftwf
via IFTTT

How to Plan a Romantic Valentine's Day Date

Want to plan a romantic Valentine’s Day date for your partner or significant other? Make February 14th special by considering the preparations necessary for activities, food, gifts, and any other element that your date might enjoy.

EditSteps

EditDocuments

EditPlanning a Meal

  1. Cook for your date. Add a personal touch to your Valentine’s Day meal and avoid having to make a dinner reservation on this busy holiday. Make a home-cooked meal for your date and invite him or her over to eat with you for an intimate meal.
    Plan a Romantic Valentine's Day Date Step 1 Version 2.jpg
    • Make sure you plan out the recipes you want to make so you can get all your ingredients bought and ready ahead of time. It’s always a good idea to get extra, just in case you make a mistake or miscalculate your measurements.
    • Try out a classic heart-shaped dessert like cookies or cake, or give other dishes the same whimsical treatment by cutting or arranging them into classic heart shapes.[1]
    • Avoid really messy foods that could spoil the romantic atmosphere or ruin nice clothes that you and your date might be wearing. Stick to foods you both enjoy, perhaps of a slightly higher quality than you normally eat.
    • Set the mood for your homemade meal by lighting candles, setting up flowers, playing romantic music, using your best cutlery and plates, and any other decorations—if that’s what your date is into!
  2. Make reservations at a restaurant. Call ahead far in advance to reserve a table at a favorite restaurant, or one you’ve never tried but you know your date will love. Use dinner as an occasion to dress up, or just to enjoy some great cuisine and spend time together.
    Plan a Romantic Valentine's Day Date Step 2 Version 2.jpg
    • You don’t need your dinner reservation to be at someplace extra fancy or expensive. Choose a burger joint where you shared your first kiss instead of a five-star restaurant with too-small portions—it’s more important that the location is meaningful or sentimental for your date.
    • Try a lunch reservation, or a time earlier or later than a typical dinner, to avoid the busy dinner rush that most restaurants will have on the holiday.
    • Ask if the wait staff can surprise your date with a special dessert, or have the in-house band or musician play your date’s favorite song or a love song.[2]
  3. Order food to eat at home. Get the best of both worlds of eating out and dining in by getting takeout or delivery from your date’s favorite restaurant and eating it in the comfort and privacy of home.
    Plan a Romantic Valentine's Day Date Step 3 Version 2.jpg
    • Remember that restaurants will be busy on this holiday, even for deliveries or takeout orders. Make sure to call in your order well in advance so you can pick it up or have it delivered by the time you expect.
    • Add your own romantic touches to a takeout meal, like personalized writing on a cake, a beverage that your date loves, etc. You can even ask a restaurant if they can personalize an order, even if it’s just arranging your pizza toppings into a heart![3]
  4. Surprise your date with their favorite cuisine. Find a restaurant, grocery store, or other location that has food that will remind your date of home, favorite travels, or other happy times. Think of what your date has told you is particularly special to them.
    Plan a Romantic Valentine's Day Date Step 4 Version 2.jpg
    • Check specialty grocery stores, international aisles, and import stores if you’re looking for food items typically found in other countries.
    • Find a restaurant that serves your date’s favorite kind of food, look up recipes to make yourself, or even enlist the help of a family member who knows just how to make your date’s favorite dish.
  5. Get creative with how and where you eat. Make the experience of Valentine’s Day dinner an adventure in itself by doing something unique, like joining a supper club, attending dinner theater, or doing a taste test.
    Plan a Romantic Valentine's Day Date Step 5 Version 2.jpg
    • Be entertained while you eat by checking out dinner theater, available in many cities, at which you watch a live performance while being served a meal.
    • Get exposed to new chefs and restaurants by joining a supper club, or create your own “food tour” by getting just one appetizer, drink, or other small item from several different restaurants in the same night.
    • Take a picnic up to a scenic hill or mountain, or to a spot that’s special to your date or significant to a time in your relationship together.
    • You can even make dinner a unique sensory experience by feeding bites of food to your blindfolded date and having him or her guess what the food is!

EditOrganizing an Activity

  1. Plan a special outing. Go see a movie, watch or play a sport, see a concert or play, or another activity your date would enjoy. Try for an activity that you don’t get to do together often, or that your date has been wanting to do for awhile.
    Plan a Romantic Valentine's Day Date Step 6 Version 2.jpg
    • Check event locations for special Valentine’s Day parties, activities, or discounts to take advantage of. Choose activities perfect for two to create an intimate date.
    • Go ice skating, skiing, or another fun activity that takes advantage of the last of winter if the weather is still cold and snowy in your area.
    • If the weather is warmer, go out and do something in nature that you and your date love to do together, like hiking, camping, or just walking around town. Or try something special like sailing or a hot air balloon ride.[4]
  2. Get cozy at home. Have your date right at home, where you can have privacy, intimacy, and plenty of fun for free or very little money.
    Plan a Romantic Valentine's Day Date Step 7.jpg
    • Try building a blanket fort like you did when you were a kid, playing board games or video games, watching movies or binging on a new TV series. Cuddle up and enjoy each other’s company!
    • If you planned an outdoor date that got ruined by weather, just go with the flow and bring it indoors if you can. Try an indoor picnic, for example, by laying out a blanket on the floor with some treats in a basket.[5]
  3. Surprise your date. Go for an element of surprise for any activity you have planned, even if it’s simply an evening at home. Set something up before your sweetheart comes home, or present a gift or activity to them in a creative, unexpected way.
    Plan a Romantic Valentine's Day Date Step 8.jpg
    • Try a sweet scavenger hunt or romantic treasure hunt by leaving notes or clues for your date to find around the house or all over town.[6]
    • Leave a simple love letter, or a romantic note written with chocolates, candles, or flowers, for your date to find.[7]
  4. Travel somewhere new or loved. Get out of town and stay in a hotel, bed and breakfast, or go camping somewhere you’ve both never been or where you and your date love going.
    Plan a Romantic Valentine's Day Date Step 9.jpg
    • You don’t have to make a big, expensive trip to a faraway place. You can even have a “staycation” where you stay someplace new within your own city! Or, check out a nearby town that you and your date have never had the chance to go to.
    • Try heading back to the place that you and your date first met, or another spot that’s romantic and significant to your relationship.

EditDeciding on a Gift

  1. Consider your date’s interests and hobbies. Think of your date’s favorite books, movies, TV shows, bands, etc. when buying a gift. Choose something your date has been waiting for or which has a special sentimental or emotional value.
    Plan a Romantic Valentine's Day Date Step 10 Version 4.jpg
    • Try buying something to add to a collection if your date has a running collection of any item, like postcards, stamps, etc. Add a romantic element by making the collectible item have something to do with a place you’ve shared a kiss, had a date, or created an inside joke.
    • Try personalizing any gift with your date’s initials, yours together, or anything else that is personal to your date or your relationship. You could personalize a picture frame, a bookmark in a book your date will love, etc.
    • Think about what your date has told you they love or miss about a certain time period or place, either from earlier in your relationship, their childhood, or another special time. Try to recreate a piece of that sentimental place or time period for him or her.
  2. Make or buy a card. Write in a card to let your date know how you feel, set a romantic mood, or just make your date laugh. If you buy a card, make sure you write a personal message inside it.
    Plan a Romantic Valentine's Day Date Step 11 Version 4.jpg
    • Try making a card with folded paper, markers or pens, and any other decorative elements you want to make it personal and unique to your date.
    • You can make several cards, to leave for your date to find at different places and times throughout the day for a sweet and romantic way to communicate even when you’re apart.
  3. Make your gift a fun activity. Your Valentine’s Day gift doesn’t have to be an object. Make your gift an experience that you share together, whether you travel somewhere new, see a show, or go on an adventure.
    Plan a Romantic Valentine's Day Date Step 12 Version 4.jpg
    • Try giving your date the gift of a class in something they’ve always wanted to learn, like cooking, dancing, or woodworking. Your date can do the class on his or her own, or you can attend it together.[8]
    • Try ending your date on a beautiful overlook, a quaint park or garden, or someplace that is unique and special to your date or your relationship.
    • Try a “coupon book” of fun activities or sweet things that you will do for your date whenever he or she redeems each one.
  4. Go traditional with flowers, chocolates, and stuffed animals. Try the typical trifecta of Valentine’s Day gifts, which are available almost anywhere before and on the holiday, if your date enjoys those things.
    Plan a Romantic Valentine's Day Date Step 13 Version 4.jpg
    • Try getting a type of chocolate that your date particularly enjoys, or another type of candy or treat they love. Personalize it with a sweet note or arrange candies into sweet words or hearts.
    • You don’t need to stick with an arrangement of flowers from the floral department. Try picking your date’s favorite wildflowers (from a permitted area), buying a different kind of plant they can enjoy planting outside or keeping indoors, or even making origami or paper flowers.[9]
    • Consider that many people enjoy a more personalized gift than what’s available at every store on Valentine’s Day, but others really do enjoy stuffed animals, flowers, and candy. It’s worth asking your date ahead of time before the holiday what they like instead of trying to guess.

EditTips

  • Always plan ahead. What you want for your date might not be available right before the holiday.

EditRelated wikiHows

EditSources and Citations


Cite error: <ref> tags exist, but no <references/> tag was found




from How to of the Day http://ift.tt/2BDLfJY
via Peter

Monday, 29 January 2018

How to Use Vlookup With an Excel Spreadsheet

This wikiHow teaches you how to find a cell's corresponding information in Microsoft Excel using the VLOOKUP formula. The VLOOKUP formula is useful for finding things like employee salary values or your budget on a given date. You can use VLOOKUP in both Windows and Mac versions of Excel.

EditSteps

  1. Open your Excel document. Double-click the Excel document that contains the data for which you want to use the VLOOKUP function.
    Use Vlookup With an Excel Spreadsheet Step 1 Version 5.jpg
    • If you haven't yet created your document, open Excel, click Blank workbook (Windows only), and enter your data by column.
  2. Make sure that your data is properly formatted. VLOOKUP only works with data that's organized in columns (e.g., in vertical sections), meaning that your data most likely has headers in the top row of cells but not in the far-left column of cells.
    Use Vlookup With an Excel Spreadsheet Step 2 Version 5.jpg
    • If your data is organized by rows instead, you'll won't be able to use VLOOKUP to find a value.
  3. Understand each aspect of the VLOOKUP formula. The VLOOKUP formula consists of four main parts, each of which refers to a piece of information in your spreadsheet:[1]
    Use Vlookup With an Excel Spreadsheet Step 3 Version 5.jpg
    • Lookup Value - The cell across from which the data that you want to look up is in. For example, if you want to look up data in cell F3, your lookup value will be in the third row of the spreadsheet.
    • Table Array - Your entire table's span from the top-left cell to the bottom-right cell (not including headers). For example, if your table starts at A2, goes down to A20, and extends over to the F column, your table goes from A2 to F20.
    • Column Index Number - The index number of the column in which the value that you want to look up is in. A column's "index number" refers to its order number; for example, in a spreadsheet that has data in columns A, B, and C, the index number of A would be 1, B would be 2, and C would be 3. The index number starts at 1 for the far-left column of data, so if your data starts in column F, its index number is 1.
    • Range Lookup - You'll normally want a precise answer for the VLOOKUP result, which can be achieved by typing in for this value. For an estimate, you can type in instead.
  4. Select an empty cell. Click a cell in which you want to store the result of the VLOOKUP formula.
    Use Vlookup With an Excel Spreadsheet Step 4 Version 4.jpg
  5. Add the VLOOKUP formula tag. Type in to start the VLOOKUP formula. The rest of the formula will go between the open parenthesis and a closed one at the end.
    Use Vlookup With an Excel Spreadsheet Step 5 Version 4.jpg
  6. Enter the lookup value. Find the cell in which the lookup value is written, then enter the cell's name into the VLOOKUP formula followed by a comma.[2]
    Use Vlookup With an Excel Spreadsheet Step 6 Version 4.jpg
    • For example, if the lookup value is written in cell A12, you'd type into the formula.
    • You'll separate each section of the formula with a comma, but you don't need to use spaces.
  7. Enter the table array value. Find the top-left cell in which data is stored and enter its name into the formula, type a colon (), find the bottom-right cell in the data group and add it to the formula, and then type a comma.
    Use Vlookup With an Excel Spreadsheet Step 7 Version 4.jpg
    • For example, if your table goes from cell A2 to cell C20, you'd type into the VLOOKUP formula.
  8. Enter the column index number. Find the index number of the column that contains the value that you want VLOOKUP to display, then type it into the formula with a comma after it.
    Use Vlookup With an Excel Spreadsheet Step 8 Version 4.jpg
    • For example, if your table uses the A, B, and C columns and the data that you want is in C, you would type in here.
  9. Type in to close the formula. This will allow VLOOKUP to find the exact value in your specified column for the selected item. Your formula should look something like this:
    Use Vlookup With an Excel Spreadsheet Step 9 Version 4.jpg
  10. Press . Doing so will run your formula and display the result in the formula's cell.
    Use Vlookup With an Excel Spreadsheet Step 10 Version 4.jpg

EditTips

  • A common application of VLOOKUP for an inventory sheet entails plugging an item's name into the "lookup value" section and using the item's cost column as the "column index number" value.
  • To keep the cell value from changing in your VLOOKUP code when you add or adjust cells in your table, put a '$' before each letter and number of each cell name. For example, A12 would become $A$12, and A2:C20 would become $A$2:$C$20.

EditWarnings

  • Double-check your column index number before plugging it into the VLOOKUP formula, as the column index number changes depending on which column your data starts in—not the order of the columns themselves.

EditRelated wikiHows

EditSources and Citations


Cite error: <ref> tags exist, but no <references/> tag was found




from How to of the Day http://ift.tt/2np34HO
via Peter
$3 Per Year Web Hosting